Re: Runaway postgres process? - Mailing list pgsql-general

From A B
Subject Re: Runaway postgres process?
Date
Msg-id dbbf25900901300705v77ecb4c4r70e3ab7eca0ee0b4@mail.gmail.com
Whole thread Raw
In response to Runaway postgres process?  (A B <gentosaker@gmail.com>)
List pgsql-general
2009/1/30 Laurent Wandrebeck <l.wandrebeck@gmail.com>:
> 2009/1/30 A B <gentosaker@gmail.com>:
>> Hi.
> Hello,
>> I just discovered three "postmaster" processes running and really
>> eating all the cpu.
>> I'm not sure why?
>> So, what steps do I take for finiding the queries that is causing this?
> select * from pg_catalog.pg_stat_activity;

Ah, great!

Some things: In the field query_start it is empty, and the
current_query field says: "<command string not enabled>" but that
seems to be fixed by turning on "stats_command_string".

What does the backend_start field indicate?

pgsql-general by date:

Previous
From: A B
Date:
Subject: Re: Runaway postgres process?
Next
From: Hiroshi Inoue
Date:
Subject: Re: encoding of PostgreSQL messages