Postgres Pro
Downloads
Home   >   mailing lists

Re: monitor SQL activity in db - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: monitor SQL activity in db
Date
Msg-id 4CFE269002000025000383C9@gw.wicourts.gov
Whole thread Raw
In response to monitor SQL activity in db  (Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: restore In parallel postgres 9
Next
From: "Manasi Save"
Date:
Subject: Create database/table using postgresql stored function