[postgis-users] Interpreting EXPLAIN ANALYZE results

Dan Lyke danlyke at flutterby.com
Wed Aug 2 08:57:37 PDT 2017


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?



More information about the postgis-users mailing list