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

[Neto pr <netoprbr9@xxxxxxxxx>]

Em qui, 13 de set de 2018 às 18:49, Vijaykumar Jain <vjain@xxxxxxxxxxxxx> 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@xxxxxxxxxxx>
Date: Friday, September 14, 2018 at 3:12 AM
To: Neto pr <netoprbr9@xxxxxxxxx>, PostgreSQL General <pgsql-general@xxxxxxxxxxxxxx>
Subject: [External] RE: Estimate time without running the query

 

Hi netoprbr,

 

Use a command explain analyse.

 

Best Regards.

Johnes Castro

---

De: Neto pr <netoprbr9@xxxxxxxxx>
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