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

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