There are some good views and functions you can use to get at the SQL query being executed
try turning on the stats collector and running select * from pg_stat_activity; (See http://www.postgresql.org/idocs/index.php?monitoring-stats.html ) You can also see the procID. From Python I can use this info to get a lot of details about the running query, CPU and memory use. But I can't tell how far along it actually is. -Aaron [EMAIL PROTECTED] wrote: > I just downloaded and installed pgmonitor on my dev. machine after seeing > your post, and it looks nifty. Only problem is I really want to avoid > running X on the database server to conserve the RAM it uses, and this > appears to require X. Any terminal applications to monitor database > activity, perhaps loosely analagous to mtop for MySQL? > (http://mtop.sf.net/) > > Wes Sheldahl > > > > > Bruce Momjian <[EMAIL PROTECTED]>@postgresql.org on 09/20/2002 > 12:18:06 PM > > Sent by: [EMAIL PROTECTED] > > > To: Aaron Held <[EMAIL PROTECTED]> > cc: [EMAIL PROTECTED], [EMAIL PROTECTED] > Subject: Re: [GENERAL] Monitoring a Query > > > > There is pgmonitor: > > http://gborg.postgresql.org/project/pgmonitor > > --------------------------------------------------------------------------- > > Aaron Held wrote: > >>Is there any way to monitor a long running query? >> >>I have stats turned on and I can see my queries, but is there any better >>measure of the progress? >> >>Thanks, >>-Aaron Held >> >>select current_query from pg_stat_activity; >>current_query >> >><IDLE> >><IDLE> >><IDLE> >><IDLE> >><IDLE> in transaction >>FETCH ALL FROM PgSQL_470AEE94 >><IDLE> in transaction >>select * from "Calls" WHERE "DurationOfCall" = 2.5 AND "DateOfCall" = >>'7/01/02' AND ("GroupCode" = 'MIAMI' OR "GroupCode" = 'Salt Lake'); >><IDLE> >><IDLE> >><IDLE> >> >> >>---------------------------(end of broadcast)--------------------------- >>TIP 2: you can get off all lists at once with the unregister command >> (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) >> > > > -- > Bruce Momjian | http://candle.pha.pa.us > [EMAIL PROTECTED] | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania > 19073 > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > > > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
