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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
