By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,773 Members | 1,249 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,773 IT Pros & Developers. It's quick & easy.

Too much CPU usage

P: n/a
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,

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 22 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.