X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6570AD918B for ; Wed, 9 Nov 2005 09:02:39 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 33822-03 for ; Wed, 9 Nov 2005 13:02:35 +0000 (GMT) X-Greylist: delayed 00:06:39.878329 by SQLgrey- Received: from mail.cdexpress.com (mail.cdexpress.com [212.203.21.83]) by svr1.postgresql.org (Postfix) with ESMTP id ACB23D9A17 for ; Wed, 9 Nov 2005 09:02:36 -0400 (AST) Received: (qmail 5132 invoked by uid 101); 9 Nov 2005 12:55:56 -0000 Received: from unknown (HELO sol.office.safepoint.nl) (patrick@safepoint.nl@192.168.6.7) by mail.safepoint.nl with RC4-MD5 encrypted SMTP; 9 Nov 2005 12:55:56 -0000 Subject: Is there a way to check execution progress of a query? From: patrick hoogendijk To: pgsql-admin@postgresql.org Content-Type: text/plain Date: Wed, 09 Nov 2005 13:56:01 +0100 Message-Id: <1131540961.10015.34.camel@sol.office.safepoint.nl> Mime-Version: 1.0 X-Mailer: Evolution 2.0.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/104 X-Sequence-Number: 19477 Hi, Some of the queries I run on my Postgresql database take some time to complete (1 hour+). I know you can get the active queries by 'select * from pg_stat_activity', but I was wondering if there is a way to see some information on the progress of the query execution while running (for example the number of updated records , read records). TIA, Patrick -- ------------------------------------------------------------ Patrick Hoogendijk Safepoint Internet Services curacaolaan 144 3131 XG Vlaardingen http://www.safepoint.nl tel: +31 (0)10 4340044 fax: +31 (0)10 4340032 ------------------------------------------------------------ "Walking on water and meeting requirements are both equally easy to do when both are frozen."