Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D272E475BC3; Mon, 23 Sep 2002 09:42:52 -0400 (EDT) Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.236.160]) by postgresql.org (Postfix) with ESMTP id 9F856475AAC; Mon, 23 Sep 2002 09:42:51 -0400 (EDT) Received: from roberto by brasileiro.net with local (Exim 3.35 #1 (Debian)) id 17tTZ6-0007wZ-00; Mon, 23 Sep 2002 07:47:56 -0600 Date: Mon, 23 Sep 2002 07:47:56 -0600 From: Roberto Mello To: Bruce Momjian Cc: Neil Conway , Aaron Held , pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: [GENERAL] Monitoring a Query Message-ID: <20020923134756.GB30392@cc.usu.edu> References: <87znuc5tdm.fsf@mailbox.samurai.com> <200209230151.g8N1ptW22413@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline In-Reply-To: <200209230151.g8N1ptW22413@candle.pha.pa.us> User-Agent: Mutt/1.4i X-message-flag: Please consider using an e-mail program other than Outlook. It's insecure. X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/261 X-Sequence-Number: 9538 On Sun, Sep 22, 2002 at 09:51:55PM -0400, Bruce Momjian wrote: > > > > Would it be a good idea to add the time that the current query began > > execution at to pg_stat_activity? > > What do people think about this? It seems like a good idea to me. OpenACS has a package called "Developer Support" that shows you (among other things) how long a query took to be executed. Very good to finding out slow-running queries that need to be optimized. -Roberto -- +----| Roberto Mello - http://www.brasileiro.net/ |------+ + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +