Re: How to find the query completeion time?

--- On Thu, 4/2/09, Leif B. Kristensen <leif@solumslekt.org> wrote:

> From: Leif B. Kristensen <leif@solumslekt.org>
> Subject: Re: [GENERAL] How to find the query completeion time?
> To: pgsql-general@postgresql.org
> Date: Thursday, April 2, 2009, 10:53 AM
> 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.
This will basically execute the query and return the time taken. Is there a way to know when an "already-started" query
willend? 

In ORACLE I can get that information from V$SESSION_LONGOPS view which will give the approx TIME_REMAINING to complete
runningqueries. Is there a similar way in postgres? 


> --
> 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
>