Re: [External] RE: Estimate time without running the query

2018-09-14 Thread Adrian Klaver
On 9/13/18 4:55 PM, Neto pr wrote: Em qui, 13 de set de 2018 às 19:53, David G. Johnston mailto:david.g.johns...@gmail.com>> escreveu: On Thu, Sep 13, 2018 at 3:30 PM, Neto pr mailto:netopr...@gmail.com>>wrote: The problem is that using the explain analyze I have to wai

Re: [External] RE: Estimate time without running the query

2018-09-13 Thread Neto pr
Em qui, 13 de set de 2018 às 19:53, David G. Johnston < david.g.johns...@gmail.com> escreveu: > On Thu, Sep 13, 2018 at 3:30 PM, Neto pr wrote: > >> The problem is that using the explain analyze I have to wait for >> the query to execute. >> I would like to estimate the time without having to wa

Re: [External] RE: Estimate time without running the query

2018-09-13 Thread David G. Johnston
On Thu, Sep 13, 2018 at 3:30 PM, Neto pr wrote: > The problem is that using the explain analyze I have to wait for > the query to execute. > I would like to estimate the time without having to wait for the query > execution. > Does anyone know how to estimate the time without waiting for the que

Re: [External] RE: Estimate time without running the query

2018-09-13 Thread Neto pr
waiting for the query to be executed? Best regards Neto > thanks, > > Vijay > > > > *From: *Johnes Castro > *Date: *Friday, September 14, 2018 at 3:12 AM > *To: *Neto pr , PostgreSQL General < > pgsql-gene...@postgresql.org> > *Subject: *[External] RE: Es

Re: [External] RE: Estimate time without running the query

2018-09-13 Thread Vijaykumar Jain
: Neto pr , PostgreSQL General Subject: [External] RE: Estimate time without running the query Hi netoprbr, Use a command explain analyse. Best Regards. Johnes Castro De: Neto pr Enviado: quinta-feira, 13 de setembro de 2018 19:38 Para: PostgreSQL General Assunto

RE: Estimate time without running the query

2018-09-13 Thread Johnes Castro
Hi netoprbr, Use a command explain analyse. Best Regards. Johnes Castro De: Neto pr Enviado: quinta-feira, 13 de setembro de 2018 19:38 Para: PostgreSQL General Assunto: Estimate time without running the query Dear all, Only a doubt. The Explain command only

Estimate time without running the query

2018-09-13 Thread Neto pr
Dear all, Only a doubt. The Explain command only estimates the cost of execution of a query, and does not estimate time for execution. I would like know if exists some way to estimate the time, without running the query? Best Regards []`s Neto