Horton

Re: IDLE in transaction introspection

Albe Laurenz <laurenz.albe@wien.gv.at>

View thread
From: "Albe Laurenz" <laurenz.albe@wien.gv.at>
To: "Andrew Dunstan *EXTERN*" <andrew@dunslane.net>, "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "Simon Riggs" <simon@2ndQuadrant.com>, "Robert Haas" <robertmhaas@gmail.com>, "Magnus Hagander" <magnus@hagander.net>, "Scott Mead" <scottm@openscg.com>, "pgsql-hackers" <pgsql-hackers@postgresql.org>
Date: 2011-11-02T08:12:41Z
Lists: pgsql-hackers 
Andrew Dunstan wrote:
> On 11/01/2011 09:52 AM, Tom Lane wrote:
>> I'm for just redefining the query field as "current or last
>> query".
>
> +1
> 
>> I could go either way on whether to rename it.
> 
> Rename it please. "current_query" will just be wrong. I'd be inclined
> just to call it "query" or "query_string" and leave it to the docs to
> define the exact semantics.

+1 for renaming, +1 for a state column.
I think it is overkill to keep a query history beyond that -- if you
want that,
you can resort to the log files.

Yours,
Laurenz Albe