Re: monitor SQL activity in db

Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca> wrote:

> I'm running PG 9.0.1 and have some issues with some  SQL, I  would
> like to know if are  other  system views/tables beside the
> pg_stat_activity from where I can get details about a running
> transactions / SQL at given time.

You might start with these Wiki pages.  If that doesn't lead you to
what you need, please post again with more detail about what you
need or the problem you're trying to solve.

http://wiki.postgresql.org/wiki/Monitoring

http://wiki.postgresql.org/wiki/Lock_Monitoring

-Kevin