Interpreting EXPLAIN ANALYZE results

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Interpreting EXPLAIN ANALYZE results

Dan Lyke
What does it mean when the first line of an "EXPLAIN ANALYZE ..." is
something like

Sort (cost=3735.76..3736.48 rows=290 width=288) (actual time=86.109....

vs:

Result (cost=17.28..17.80 rows=1 width=224) (actual time=134.161....

And that "Result" line is then followed by the indented and prefixed
with "-->" "Sort" statement that I expected?

_______________________________________________
postgis-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Interpreting EXPLAIN ANALYZE results

Dan Lyke
On Wed, 2 Aug 2017 08:57:37 -0700
Dan Lyke <[hidden email]> wrote:
> Sort (cost=3735.76..3736.48 rows=290 width=288) (actual
> time=86.109....
>
> vs:
>
> Result (cost=17.28..17.80 rows=1 width=224) (actual time=134.161....

Hmmm... I think the answer is 9.5 vs 9.6

_______________________________________________
postgis-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/postgis-users
Loading...