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 <[email protected]> Date: Friday, September 14, 2018 at 3:12 AM To: Neto pr <[email protected]>, PostgreSQL General <[email protected]> Subject: [External] RE: Estimate time without running the query Hi netoprbr, Use a command explain analyse. Best Regards. Johnes Castro ________________________________ De: Neto pr <[email protected]> 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
