From: Bruce Momjian <pgman@candle.pha.pa.us>
To: wsheldah@lexmark.com
Cc: Aaron Held <aaron@MetroNY.com>
Cc: pgsql-sql@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Re: Monitoring a Query
Date: Fri, 20 Sep 2002 14:56:02 -0400 (EDT)
Message-ID: <200209201856.g8KIu2h27025@candle.pha.pa.us> (raw)
In-Reply-To: <OFFB5F6014.73E8A50B-ON85256C3A.00673363@lexmark.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pgman@candle.pha.pa.us, wsheldah@lexmark.com, aaron@MetroNY.com, pgsql-general@postgresql.org
Subject: Re: Monitoring a Query
In-Reply-To: <200209201856.g8KIu2h27025@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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