Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 5E5219FA13B for ; Wed, 11 Jul 2007 12:39:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 13439-03 for ; Wed, 11 Jul 2007 12:39:17 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id BE8F89FA6B5 for ; Wed, 11 Jul 2007 12:39:19 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1I8eHd-0002fV-0Q for pgsql-performance@postgresql.org; Wed, 11 Jul 2007 11:39:17 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id A3B384050; Wed, 11 Jul 2007 11:39:11 -0400 (EDT) Date: Wed, 11 Jul 2007 11:39:11 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: TIMING A QUERY ??? Message-ID: <20070711153911.GQ1241@phlogiston.dyndns.org> References: <11542393.post@talk.nabble.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <11542393.post@talk.nabble.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/92 X-Sequence-Number: 25776 On Wed, Jul 11, 2007 at 08:21:40AM -0700, smiley2211 wrote: > > How can I get the time it takes a query to execute - explain analyze is > taking over 5 hours to complete You can't get it any faster than what explain analyse does: it runs the query. How else would you get the answer? > ...can I use \timing??? I don't get any time when using the > \timing option... How so? It returns Time: N ms at the end of output for me. A -- Andrew Sullivan | ajs@crankycanuck.ca In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland