Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1EA02476296; Fri, 20 Sep 2002 15:13:58 -0400 (EDT) Received: from metrony.com (webware.metrony.com [207.159.131.106]) by postgresql.org (Postfix) with ESMTP id 5C48547624F; Fri, 20 Sep 2002 15:13:57 -0400 (EDT) Received: from MetroNY.com ([66.9.109.130]) by metrony.com (8.11.0/8.11.0) with ESMTP id g8KJDkT94781; Fri, 20 Sep 2002 19:13:46 GMT (envelope-from aaron@MetroNY.com) Message-ID: <3D8B735B.7050206@MetroNY.com> Date: Fri, 20 Sep 2002 15:13:31 -0400 From: Aaron Held User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0 X-Accept-Language: en-us, en MIME-Version: 1.0 To: wsheldah@lexmark.com Cc: Bruce Momjian , pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: Monitoring a Query References: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/950 X-Sequence-Number: 30531 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 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 @postgresql.org on 09/20/2002 > 12:18:06 PM > > Sent by: pgsql-general-owner@postgresql.org > > > To: Aaron Held > 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 >> >> >> >> >> >> in transaction >>FETCH ALL FROM PgSQL_470AEE94 >> in transaction >>select * from "Calls" WHERE "DurationOfCall" = 2.5 AND "DateOfCall" = >>'7/01/02' AND ("GroupCode" = 'MIAMI' OR "GroupCode" = 'Salt Lake'); >> >> >> >> >> >>---------------------------(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 > > >