pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedmonitor SQL activity in db
2+ messages / 2 participants
[nested] [flat]
* monitor SQL activity in db
@ 2010-12-06 20:03 Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
2010-12-07 18:20 ` Re: monitor SQL activity in db Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 1 reply; 2+ messages in thread
From: Isabella Ghiurea @ 2010-12-06 20:03 UTC (permalink / raw)
To: pgsql-admin
Hi Gurus,
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.
Thank you
Isabella
--
-----------------------------------------------------------
Isabella A. Ghiurea
Isabella.Ghiurea@nrc-cnrc.gc.ca
Canadian Astronomy Data Centre |http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html
National Research Council of Canada, Herzberg Institute of Astrophysics
5071 West Saanich Road, Victoria BC V9E 2E7, Canada
Phone: 250 363-3446 fax: 250 363-0045
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: monitor SQL activity in db
2010-12-06 20:03 monitor SQL activity in db Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
@ 2010-12-07 18:20 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 0 replies; 2+ messages in thread
From: Kevin Grittner @ 2010-12-07 18:20 UTC (permalink / raw)
To: isabella.ghiurea@nrc-cnrc.gc.ca; pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-12-07 18:20 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-12-06 20:03 monitor SQL activity in db Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
2010-12-07 18:20 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox