Too much CPU usage
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.
Thx in advance,
regards,
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