explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ckHKV

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 3.876 ↓ 4.0 215 1

Limit (cost=32.51..220.67 rows=54 width=16) (actual time=2.934..3.876 rows=215 loops=1)

  • Buffers: shared hit=1190
2.          

CTE bb_edge

3. 2.641 2.641 ↓ 143.0 143 1

Index Scan using treenode_edge_gix on treenode_edge te (cost=0.53..28.58 rows=1 width=16) (actual time=0.276..2.641 rows=143 loops=1)

  • Index Cond: ((edge &&& '01020000800200000000000000F0C71C41000000007026144100000000C095034100000000F88D20410000000070B511410000000080940341'::geometry) AND (edge &&& st_expand('0103000080010000000500000000000000F0C71C410000000070B51141000000002095034100000000F88D20410000000070B51141000000002095034100000000F88D20410000000070261441000000002095034100000000F0C71C410000000070261441000000002095034100000000F0C71C410000000070B511410000000020950341'::geometry, '20'::double precision)))
  • Filter: ((project_id = 1) AND st_3ddwithin(edge, '0103000080010000000500000000000000F0C71C410000000070B51141000000002095034100000000F88D20410000000070B51141000000002095034100000000F88D20410000000070261441000000002095034100000000F0C71C410000000070261441000000002095034100000000F0C71C410000000070B511410000000020950341'::geometry, '20'::double precision))
  • Buffers: shared hit=198
4. 0.122 3.847 ↓ 4.0 215 1

Nested Loop (cost=3.94..192.09 rows=54 width=16) (actual time=2.931..3.847 rows=215 loops=1)

  • Buffers: shared hit=1190
5. 0.180 2.948 ↓ 4.8 259 1

HashAggregate (cost=3.51..5.13 rows=54 width=8) (actual time=2.893..2.948 rows=259 loops=1)

  • Group Key: bb_edge.id
  • Buffers: shared hit=198
6. 0.031 2.768 ↓ 6.3 338 1

Append (cost=0.00..3.38 rows=54 width=8) (actual time=0.285..2.768 rows=338 loops=1)

  • Buffers: shared hit=198
7. 2.704 2.704 ↓ 143.0 143 1

CTE Scan on bb_edge (cost=0.00..0.06 rows=1 width=8) (actual time=0.284..2.704 rows=143 loops=1)

  • Buffers: shared hit=198
8. 0.020 0.020 ↓ 143.0 143 1

CTE Scan on bb_edge bb_edge_1 (cost=0.00..0.06 rows=1 width=8) (actual time=0.001..0.020 rows=143 loops=1)

9. 0.012 0.013 ↑ 1.0 52 1

ProjectSet (cost=0.00..0.83 rows=52 width=8) (actual time=0.006..0.013 rows=52 loops=1)

10. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.03 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

11. 0.777 0.777 ↑ 1.0 1 259

Index Scan using treenode_pkey on treenode t1 (cost=0.42..3.43 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=259)

  • Index Cond: (id = bb_edge.id)
  • Buffers: shared hit=992
Planning time : 1.148 ms
Execution time : 3.981 ms