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@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
Use a command explain analyse.
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?
