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
stringand 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.tatsuhito@oss.ntt.co.jp