Re: IDLE in transaction introspection
Simon Riggs <simon@2ndquadrant.com>
From: Simon Riggs <simon@2ndQuadrant.com>
To: Magnus Hagander <magnus@hagander.net>
Cc: Robert Haas <robertmhaas@gmail.com>, Scott Mead <scottm@openscg.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2011-11-01T13:03:18Z
Lists: pgsql-hackers
On Tue, Nov 1, 2011 at 12:41 PM, Magnus Hagander <magnus@hagander.net> wrote: > On Tue, Nov 1, 2011 at 13:19, Simon Riggs <simon@2ndquadrant.com> wrote: >> On Mon, Oct 31, 2011 at 10:13 PM, Robert Haas <robertmhaas@gmail.com> wrote: >>> On Mon, Oct 31, 2011 at 5:45 PM, Magnus Hagander <magnus@hagander.net> wrote: >>>> Actually, for the future, it might be useful to have a "state" column, >>>> that holds the idle/in transaction/running status, instead of the >>>> tools having to parse the query text to get that information... >>> >>> +1 for doing it this way. Splitting "current_query" into "query" and >>> "state" would be more elegant and easier to use all around. >> >> Why not leave it exactly as it is, and add a previous_query column? >> >> That gives you exactly what you need without breaking anything. > > That would be the backwards compatible way I suggested. Sorry Magnus, I hadn't read the whole thread. +1 to your suggestion. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services