Search Postgresql Archives

Re: [External] RE: Estimate time without running the query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Sep 13, 2018 at 3:30 PM, Neto pr <netoprbr9@xxxxxxxxx> wrote:
The problem is that using the explain analyze <query> I have to wait for the query to execute.
I would like to estimate the time without having to wait for the query execution.
Does anyone know how to estimate the time without waiting for the query to be executed?

On the machine in question you have to experiment to obtain data to construct a formula to convert cost to time.  Then when using the function remember that lots of things can play into individual executions taking more time (and sometimes less too I suspect) such as locks, caching, physical data locality.

It seems more useful to log actual execution times and look for trends.  If you are writing a query odds are it needs to be run regardless of how efficient it may be - or used in a relative comparison to an alternate query.

David J.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux