| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: monitor SQL activity in db |
| Date: | 2010-12-07 18:20:32 |
| Message-ID: | 4CFE269002000025000383C9@gw.wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Isabella Ghiurea <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sridhar Reddapani | 2010-12-07 23:05:32 | Two copies of Postgres with Graphical installer |
| Previous Message | Kevin Grittner | 2010-12-07 18:01:03 | Re: restore In parallel postgres 9 |