Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E2B9E47682F; Fri, 20 Sep 2002 15:55:41 -0400 (EDT) Received: from bob.samurai.com (bob.samurai.com [205.207.28.75]) by postgresql.org (Postfix) with ESMTP id 5C5F0476019; Fri, 20 Sep 2002 15:55:41 -0400 (EDT) Received: from boston.samurai.com (DU179.N224.ResNet.QueensU.CA [130.15.224.179]) by bob.samurai.com (Postfix) with ESMTP id 0DBB81EDE; Fri, 20 Sep 2002 15:54:53 -0400 (EDT) To: Bruce Momjian Cc: Aaron Held , pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: Monitoring a Query References: <200209201619.g8KGJ4J00624@candle.pha.pa.us> From: Neil Conway In-Reply-To: <200209201619.g8KGJ4J00624@candle.pha.pa.us> Date: 20 Sep 2002 15:54:45 -0400 Message-ID: <87znuc5tdm.fsf@mailbox.samurai.com> Lines: 16 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.2 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/956 X-Sequence-Number: 30537 Bruce Momjian writes: > Aaron Held wrote: > > Is there any way to monitor a long running query? > > Oh, sorry, you want to know how far the query has progressed. Gee, I > don't think there is any easy way to do that. Would it be a good idea to add the time that the current query began execution at to pg_stat_activity? Cheers, Neil -- Neil Conway || PGP Key ID: DB3C29FC