Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP
	id B1D5D4760EF; Fri, 20 Sep 2002 14:59:17 -0400 (EDT)
Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251])
	by postgresql.org (Postfix) with ESMTP
	id 48420476B52; Fri, 20 Sep 2002 14:59:15 -0400 (EDT)
Received: (from pgman@localhost)
	by candle.pha.pa.us (8.11.6/8.10.1) id g8KIu2h27025;
	Fri, 20 Sep 2002 14:56:02 -0400 (EDT)
From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200209201856.g8KIu2h27025@candle.pha.pa.us>
Subject: Re: Monitoring a Query
In-Reply-To: <OFFB5F6014.73E8A50B-ON85256C3A.00673363@lexmark.com>
To: wsheldah@lexmark.com
Date: Fri, 20 Sep 2002 14:56:02 -0400 (EDT)
Cc: Aaron Held <aaron@MetroNY.com>, pgsql-sql@postgresql.org,
	pgsql-general@postgresql.org
X-Mailer: ELM [version 2.4ME+ PL99 (25)]
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200209/946
X-Sequence-Number: 30527


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