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,

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

http://archives.postgresql.org

re: Too much CPU usage

On Friday 13 February 2004 15:30, Froggy / Froggy Corp. wrote:[color=blue]
> 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.[/color]

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