ITAGAKI Takahiro wrote:
The feature could be achieved by an extension module using new executor
hooks in 8.4. It is just like contrib/pg_stat_statements;
Well, it is a good idea.
Displaying last-query-string may be useful, but it is not a feature for
general purpose. So, it may be an external module.
Now, I have two choice.
1. Displaying last-query-string by pg_stat_activity (suggested by Gurjeet):
Extends the pg_stat_activity to display "previous_query".
We can check only a previous query.
2. Displaying query-string-history by external module (suggested by Itagaki):
Using executor hook to get a query string and stores it in
shared memory.
We can check specified number of query string history.
I think I will try mainly 2.
# Or this feature may merge to pg_stat_statements.
Any comments welcome.
Best regards,
--
Tatsuhito Kasahara
kasahara.tatsuh...@oss.ntt.co.jp
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
