Re: IDLE in transaction introspection
Magnus Hagander <magnus@hagander.net>
From: Magnus Hagander <magnus@hagander.net>
To: Fujii Masao <masao.fujii@gmail.com>
Cc: Scott Mead <scottm@openscg.com>, Greg Smith <greg@2ndquadrant.com>, pgsql-hackers@postgresql.org
Date: 2012-01-20T11:24:29Z
Lists: pgsql-hackers
On Thu, Jan 19, 2012 at 15:42, Fujii Masao <masao.fujii@gmail.com> wrote: > On Thu, Jan 19, 2012 at 10:31 PM, Magnus Hagander <magnus@hagander.net> wrote: >> Applied with fairly extensive modifications. I moved things around, >> switched to using enum instead of int+#define and a few things like >> that. Also changed most of the markup in the docs - I may well have >> broken some previously good language that, so if I did and someone >> spots it, please mention it :-) > > The attached patch seems to need to be committed. Thanks, applied. > BTW, the following change in the patch is not required, but ISTM that > it's better to change that way. > > -SELECT pg_stat_get_backend_pid(s.backendid) AS procpid, > - pg_stat_get_backend_activity(s.backendid) AS current_query > +SELECT pg_stat_get_backend_pid(s.backendid) AS pid, > + pg_stat_get_backend_activity(s.backendid) AS query Agreed. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/