[postgis-users] How to estimate the time taken for a query plan without actually running it?

Shaozhong SHI shishaozhong at gmail.com
Mon Aug 3 07:56:18 PDT 2020


I tried to use "explain" to look into the query plan.  It only gives me the
cost and rows, and does not give an estimate of time to run the query.

"Explain analyze" gives an estimate of time needed, but for a Big Data
query, one has to wait to get an answer,

Is there a way to get an estimate of time for running a query, without
actually running it.

Looking forward to hearing from you.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200803/f51dac00/attachment.html>

More information about the postgis-users mailing list