Postgres Pro
Downloads
Home   >   mailing lists

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

From Si Chen
Subject is there a way log last query in pg_stat_activity
Date
Msg-id CAAYSSjMLJQOX+wGDzW0zZ_U=x6Njn2q3YE1ZHpQT_ySViW7BdQ@mail.gmail.com
Whole thread Raw
Responses Re: is there a way log last query in pg_stat_activity  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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?

--
Si Chen
Open Source Strategies, Inc.
twitter.com/opentaps

Unify social, email, and business communications with opentaps CRM2 for Android, iPad/iPhone, Gmail - It's Free!

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: How to cast to regprocedure with OUT parameters
Next
From: Andy Lau
Date:
Subject: Best practices for cloning DB servers