| From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
|---|---|
| To: | Hunter Hillegas <lists(at)lastonepicked(dot)com>, PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Recent High CPU |
| Date: | 2004-07-17 17:35:10 |
| Message-ID: | 200407171035.10293.scrawford@pinpointresearch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Friday 16 July 2004 10:57 pm, Hunter Hillegas wrote:
> I have recently seen my 'postmaster' processes sucking up a lot of
> CPU.
>
> What can I do to determine why they have started eating the
> processors?
>
Here are some starting places:
Check the Postgresql log files for clues.
Find what queries are running:
select * from pg_stat_activity;
Use basic system tools (ps, netstat, fuser, etc.) to track back to the
client machine and process that is triggering the high usage.
The above may lead you to the answer. If not, ask here again with the
info you have discovered.
Cheers,
Steve
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hervé Piedvache | 2004-07-17 20:05:40 | URGENT pg_xlog full impossible to restart ... |
| Previous Message | Jean-Luc Lachance | 2004-07-17 16:04:28 | Re: get first / last date of given week |