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/