Re: Monitoring activities of PostgreSQL

2010/6/15 Allan Kamau <kamauallan(at)gmail(dot)com>

> I do have a PL/SQL function that gets executed called many times but
> with different parameter values each of these times. For most
> invocations of this function run in a couple of seconds however some
> invocations of the same function run (on the same dataset) for hours
> with very little disk activity but high CPU.
>

>
> How can I monitor the actual DB activities during such times so I may
> better understand what the situation truly is.

You can monitor system parameters (CPU, disk IO, memory) with standard
OS-specific tools (on Unix: top, ps iostat,vmstat)

I have seen some users
> on this list posting some complex log/outputs, this are the kind of
> outputs I would like to capture and view. Where are they?
>
>
they are mostly in log files or output from EXPLAIN ANALYZE command

for general info see

http://www.postgresql.org/docs/current/static/runtime-config-logging.html
http://www.postgresql.org/docs/8.4/static/using-explain.html
http://wiki.postgresql.org/wiki/Performance_Optimization

and this list archives.

Filip