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 <johne...@hotmail.com> Date: Friday, September 14, 2018 at 3:12 AM To: Neto pr <netopr...@gmail.com>, PostgreSQL General <pgsql-gene...@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 <netopr...@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
