On Tue, 27 Nov 2001, Tom Lane wrote:
> You can get more info than you probably want by setting show_query_stats
> to true (either with SET, or in postgresql.conf if you want it across
> all backends). Also set debug_print_query to true. Now you'll get
> stuff like this in the postmaster log:
>
> DEBUG: query: select count(*) from tenk1 a, tenk1 b where a.unique1=b.unique2;
> DEBUG: QUERY STATISTICS
Is this available on 7.1.3?
I did:
drf=# set show_query_stats = TRUE;
drf=# set debug_print_query = TRUE;
drf=# select horse,fd from horses limit 1;
horse | fd
-------------------+----
a big kahuna* | d
drf=# show debug_print_query;
NOTICE: debug_print_query is on
drf=# show show_query_stats;
NOTICE: show_query_stats is on
The variables were on, yet I didn't get the debug output.