Re: Timing a query

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.