Re: Runaway postgres process?

From: A B <gentosaker(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Runaway postgres process?
Date: 2009-01-30 15:05:58
Message-ID: dbbf25900901300705v77ecb4c4r70e3ab7eca0ee0b4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2009/1/30 Laurent Wandrebeck <l(dot)wandrebeck(at)gmail(dot)com>:
> 2009/1/30 A B <gentosaker(at)gmail(dot)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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hiroshi Inoue 2009-01-30 15:11:05 Re: encoding of PostgreSQL messages
Previous Message A B 2009-01-30 15:02:01 Re: Runaway postgres process?