Postgres Pro
Downloads
Home   >   mailing lists

Re: How to find the query completeion time? - Mailing list pgsql-general

From Leif B. Kristensen
Subject Re: How to find the query completeion time?
Date
Msg-id 200904021653.36447.leif@solumslekt.org
Whole thread Raw
In response to How to find the query completeion time?  (SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com>)
List pgsql-general
Tree view 
On Thursday 2. April 2009, SHARMILA JOTHIRAJAH wrote:
>Hi,
>Is there a way in Postgres to find when a particular query will
> finish?
>
>For example, for a query like this
>SELECT * FROM TABLE1
>Can we find out from any of the catalog tables(or any other way) when
> this query is likely to  complete?
>
>Thanks

How about

EXPLAIN ANALYZE SELECT * FROM TABLE1

?

or just set \timing in the psql and run the query.
--
Leif Biberg Kristensen | Registered Linux User #338009
Me And My Database: http://solumslekt.org/blog/

pgsql-general by date:

Previous
From: SHARMILA JOTHIRAJAH
Date:
Subject: How to find the query completeion time?
Next
From: linnewbie
Date:
Subject: Re: Posgres Adding braces at beginning and end of text (html) content