Re: 'show full processlist' in postgres? - Mailing list pgsql-sql

From Tom Lane
Subject Re: 'show full processlist' in postgres?
Date
Msg-id 20839.1120246970@sss.pgh.pa.us
Whole thread Raw
In response to Re: 'show full processlist' in postgres?  (Erik Wasser <erik.wasser@iquer.net>)
List pgsql-sql
Erik Wasser <erik.wasser@iquer.net> writes:
> But 'current_query' is still always empty... B-(

The pg_stats views lag reality by a certain amount, so checking for your
own query is generally not gonna work.  Try starting a long-running
query in another session.
        regards, tom lane


pgsql-sql by date:

Previous
From: "Nick Stone"
Date:
Subject: Re: Some help please
Next
From: Andreas Kretschmer
Date:
Subject: Re: [despammed] Re: 'show full processlist' in postgres?