Re: [External] RE: Estimate time without running the query - Mailing list pgsql-general

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;

 

thanks,

Vijay

 

From: Johnes Castro <johnescm@hotmail.com>
Date: Friday, September 14, 2018 at 3:12 AM
To: Neto pr <netoprbr9@gmail.com>, PostgreSQL General <pgsql-general@postgresql.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@gmail.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