Postgres Pro
Downloads
Home   >   mailing lists

RE: Estimate time without running the query - Mailing list pgsql-general

From Johnes Castro
Subject RE: Estimate time without running the query
Date
Msg-id RO1P15201MB242633BE2EA7493007BBCFD1D41A0@RO1P15201MB2426.LAMP152.PROD.OUTLOOK.COM
Whole thread Raw
In response to Estimate time without running the query  (Neto pr <netoprbr9@gmail.com>)
Responses Re: [External] RE: Estimate time without running the query  (Vijaykumar Jain <vjain@opentable.com>)
List pgsql-general
Tree view
Hi netoprbr,

Use a command explain analyse.

Best Regards.
Johnes Castro
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?

Best Regards
[]`s Neto

pgsql-general by date:

Previous
From: Neto pr
Date:
Subject: Estimate time without running the query
Next
From: Vijaykumar Jain
Date:
Subject: Re: [External] RE: Estimate time without running the query