On 2/15/06, Nikola Ivanov <[EMAIL PROTECTED]> wrote:
> I found the pid of the postgres process that was consuming all the CPU. I
> turned the stats back on (and reloaded the conf file), but when I query
> pg_stat_activity I get nothing back. No records.
did you restart server? I think stats collector setting is only set
on server start. You may want to consider using pg_ctl to kill that
pid. I also think about leaving command strings stats on for a while
depending on your transaction volume. There is some overhead but the
information it gives can be highly useful.
Merlin
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
