| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Francisco Reyes <lists(at)natserv(dot)com> |
| Cc: | "Elizabeth O'Neill" <elizabeth(dot)oneill(at)abcmail(dot)co(dot)uk>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Timing a query |
| Date: | 2001-11-30 23:13:00 |
| Message-ID: | 11797.1007161980@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Francisco Reyes <lists(at)natserv(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Link | 2001-11-30 23:16:08 | Re: Integer keys vs. Varchar keys |
| Previous Message | Francisco Reyes | 2001-11-30 22:15:11 | Re: Timing a query |