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

Em qui, 13 de set de 2018 às 18:49, Vijaykumar Jain <vjain(at)opentable(dot)com>
escreveu:

> explain analyze would *run* the query and it can be dangerous if it is a
> DML statement like insert/update/delete 😊
>
>
>
> If you still want to go with explain analyze,
>
> You can do
>
>
>
> begin;
>
> explain analyze <my query>;
>
> rollback;
>
>
>

Dear all,

The problem is that using the explain analyze <query> 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 query to
be executed?

Best regards
Neto

> thanks,
>
> Vijay
>
>
>
> *From: *Johnes Castro <johnescm(at)hotmail(dot)com>
> *Date: *Friday, September 14, 2018 at 3:12 AM
> *To: *Neto pr <netoprbr9(at)gmail(dot)com>, PostgreSQL General <
> pgsql-general(at)postgresql(dot)org>
> *Subject: *[External] RE: Estimate time without running the query
>
>
>
> Hi netoprbr,
>
>
>
> Use a command explain analyse.
>
>
>
> Best Regards.
>
> Johnes Castro
> ------------------------------
>
> *De:* Neto pr <netoprbr9(at)gmail(dot)com>
> *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 <query> 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
>