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