Uh, no, not yet. There is a non-X version of tcl but I don't think pgaccess will work under that.
--------------------------------------------------------------------------- [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 > > > > > -- 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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
