explain.depesz.com

PostgreSQL's explain analyze made readable

Result: A7Vy

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 27,708.868 ↑ 1.0 1 1

Limit (cost=89,813.64..89,813.64 rows=1 width=32) (actual time=27,708.867..27,708.868 rows=1 loops=1)

  • Buffers: shared hit=18130999
2. 0.213 27,708.866 ↑ 100.0 1 1

Sort (cost=89,813.64..89,813.89 rows=100 width=32) (actual time=27,708.866..27,708.866 rows=1 loops=1)

  • Sort Key: ((st_startpoint(te.edge) <<->> '010100008000000000808D08410000000040A60E410000000080A50141'::geometry))
  • Sort Method: top-N heapsort Memory: 25kB
  • Buffers: shared hit=18130999
3. 0.539 27,708.653 ↑ 1.0 100 1

Nested Loop (cost=1.55..89,813.14 rows=100 width=32) (actual time=13,996.072..27,708.653 rows=100 loops=1)

  • Buffers: shared hit=18130999
4. 0.095 27,707.814 ↑ 1.0 100 1

Limit (cost=0.98..89,353.39 rows=100 width=80) (actual time=13,996.042..27,707.814 rows=100 loops=1)

  • Buffers: shared hit=18130499
5. 0.000 27,707.719 ↑ 337.7 100 1

Nested Loop (cost=0.98..30,171,628.11 rows=33,767 width=80) (actual time=13,996.041..27,707.719 rows=100 loops=1)

  • Buffers: shared hit=18130499
6. 13,167.707 13,167.707 ↑ 13.5 3,006,186 1

Index Scan using treenode_edge_gix on treenode_edge te (cost=0.42..4,554,656.90 rows=40,583,663 width=72) (actual time=0.449..13,167.707 rows=3,006,186 loops=1)

  • Order By: (edge <<->> '010100008000000000808D08410000000040A60E410000000080A50141'::geometry)
  • Filter: (project_id = 1)
  • Rows Removed by Filter: 4518
  • Buffers: shared hit=3077805
7. 15,030.930 15,030.930 ↓ 0.0 0 3,006,186

Index Scan using treenode_pkey on treenode t (cost=0.56..0.63 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=3,006,186)

  • Index Cond: (id = te.id)
  • Filter: (skeleton_id = 11545803)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=15052694
8. 0.300 0.300 ↑ 1.0 1 100

Index Scan using treenode_pkey on treenode (cost=0.56..4.58 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=100)

  • Index Cond: (id = te.id)
  • Buffers: shared hit=500
Planning time : 0.745 ms
Execution time : 27,708.944 ms