| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | "Froggy / Froggy Corp(dot)" <froggy(at)froggycorp(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Too much CPU usage |
| Date: | 2004-02-13 16:30:02 |
| Message-ID: | 200402131630.02144.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Friday 13 February 2004 15:30, Froggy / Froggy Corp. wrote:
> Hello,
>
> I am looking for a function like "top" to show online the cpu time used
> by request.
>
> When i try to show which http request eat all my cpu, i can use the
> stat_mod (not very usefull but can help), and the log.
> But i have no way to link the http thread and the postgresql thread, so
> if a module like stat_mod existe under postgres, it will be very fine.
Combine "top" with pg_stat_activity. Details in the manuals under "monitoring
activity".
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2004-02-13 16:30:46 | Re: Quad Xeon vs. Dual Itanium |
| Previous Message | scott.marlowe | 2004-02-13 16:26:55 | Re: update set x=(subquery on same table) |