| From: | "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com> |
|---|---|
| To: | Jérôme BENOIS <benois(at)argia-engineering(dot)fr> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: High CPU Load |
| Date: | 2006-09-14 14:26:10 |
| Message-ID: | 1d4e0c10609140726i4e18aaa2w19e680038f8c64b0@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 9/14/06, Jérôme BENOIS <benois(at)argia-engineering(dot)fr> wrote:
> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
> 15667 postgres 25 0 536m 222m 532m R 98.8 11.0 1:39.29 postmaster
> 19533 postgres 25 0 535m 169m 532m R 92.9 8.3 0:38.68 postmaster
> 16278 postgres 25 0 537m 285m 532m R 86.3 14.1 1:37.56 postmaster
Enable stats_command_string and see which queries are running on these
backends by selecting on pg_stat_activity.
Do the queries finish? Do you have them in your query log?
--
Guillaume
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jérôme BENOIS | 2006-09-14 14:27:12 | Re: High CPU Load |
| Previous Message | Scott Marlowe | 2006-09-14 14:21:50 | Re: High CPU Load |