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