Re: Timing a query - Mailing list pgsql-general

From Tom Lane
Subject Re: Timing a query
Date
Msg-id 11797.1007161980@sss.pgh.pa.us
Whole thread Raw
In response to Re: Timing a query  (Francisco Reyes <lists@natserv.com>)
List pgsql-general
Francisco Reyes <lists@natserv.com> writes:
> The variables were on, yet I didn't get the debug output.

Did you look in the postmaster log?  The stats are not sent to the client.

I think in 7.1 and before, those stats are printed directly to
postmaster stderr, which means you can't log them using syslog either;
you really have to send stderr to someplace useful.  In 7.2 the stats
can be logged to syslog ... but they still don't go to the client.

            regards, tom lane

pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: Timing a query
Next
From: David Link
Date:
Subject: Re: Integer keys vs. Varchar keys