Postgres Pro
Downloads
Home   >   mailing lists

Re: is there a way log last query in pg_stat_activity - Mailing list pgsql-general

From Tom Lane
Subject Re: is there a way log last query in pg_stat_activity
Date
Msg-id 5565.1408033433@sss.pgh.pa.us
Whole thread Raw
In response to is there a way log last query in pg_stat_activity  (Si Chen <sichen@opensourcestrategies.com>)
List pgsql-general
Tree view 
Si Chen <sichen@opensourcestrategies.com> writes:
> I'm using Postgresql 9.0, and my pg_stat_activity.query seems to always be
> showing <IDLE> when no query is being run.

> Is there a way for it to show the last query, even if it was run a while
> ago?

More recent versions act that way.  There is no way to make 9.0.x do it
short of patching the source code.

            regards, tom lane

pgsql-general by date:

Previous
From: Andy Lau
Date:
Subject: Best practices for cloning DB servers
Next
From: Rajmohan C
Date:
Subject: How to modify parser in PostgreSQL to handle new keyword and parse it