Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 65E229FA66C for ; Wed, 11 Jul 2007 12:21:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 94861-04 for ; Wed, 11 Jul 2007 12:21:36 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by postgresql.org (Postfix) with ESMTP id 06F9A9F9C89 for ; Wed, 11 Jul 2007 12:21:44 -0300 (ADT) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1I8e0a-0001Qh-PS for pgsql-performance@postgresql.org; Wed, 11 Jul 2007 08:21:40 -0700 Message-ID: <11542393.post@talk.nabble.com> Date: Wed, 11 Jul 2007 08:21:40 -0700 (PDT) From: smiley2211 To: pgsql-performance@postgresql.org Subject: TIMING A QUERY ??? MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: smiley2211@yahoo.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.414 tagged_above=0 required=5 tests=AWL=-2.479, BAYES_05=-1.11, DNS_FROM_OPENWHOIS=1.13, FORGED_YAHOO_RCVD=2.297, SUBJ_ALL_CAPS=2.077, WHOIS_MYPRIVREG=1.499 X-Spam-Level: *** X-Archive-Number: 200707/88 X-Sequence-Number: 25772 How can I get the time it takes a query to execute - explain analyze is taking over 5 hours to complete...can I use \timing??? I don't get any time when using the \timing option... Thanks...Marsha -- View this message in context: http://www.nabble.com/TIMING-A-QUERY-----tf4062567.html#a11542393 Sent from the PostgreSQL - performance mailing list archive at Nabble.com.