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 | [EMAIL PROTECTED]
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism.
--Brad Holland
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
