From: | Vijaykumar Jain <vjain(at)opentable(dot)com> |
---|---|
To: | Johnes Castro <johnescm(at)hotmail(dot)com>, Neto pr <netoprbr9(at)gmail(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [External] RE: Estimate time without running the query |
Date: | 2018-09-13 21:49:35 |
Message-ID: | 9777232F-131E-46BF-AF0C-3B2242A99645@opentable.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Williams | 2018-09-13 22:04:31 | Slow shutdowns sometimes on RDS Postgres |
Previous Message | Johnes Castro | 2018-09-13 21:41:16 | RE: Estimate time without running the query |