Re: Monitoring a Query - Mailing list pgsql-general
From | Bruce Momjian |
---|---|
Subject | Re: Monitoring a Query |
Date | |
Msg-id | 200209201856.g8KIu2h27025@candle.pha.pa.us Whole thread Raw |
In response to | Monitoring a Query (Aaron Held <aaron@MetroNY.com>) |
List | pgsql-general |
Uh, no, not yet. There is a non-X version of tcl but I don't think pgaccess will work under that. --------------------------------------------------------------------------- wsheldah@lexmark.com 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 <pgman@candle.pha.pa.us>@postgresql.org on 09/20/2002 > 12:18:06 PM > > Sent by: pgsql-general-owner@postgresql.org > > > To: Aaron Held <aaron@MetroNY.com> > cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org > 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 majordomo@postgresql.org) > > > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (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 > > > > > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
pgsql-general by date: