explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tpQ

Settings
# exclusive inclusive rows x rows loops node
1. 8,336.087 41,232.859 ↑ 2.0 1 1

HashAggregate (cost=626,126.50..626,126.52 rows=2 width=16) (actual time=41,232.857..41,232.859 rows=1 loops=1)

  • Group Key: quadkey.id, quadkey.iso_a3
2. 13,557.962 32,896.772 ↓ 4.0 7,810,420 1

Nested Loop (cost=0.56..611,590.31 rows=1,938,158 width=40) (actual time=0.744..32,896.772 rows=7,810,420 loops=1)

3. 2.020 2.020 ↑ 1.0 2 1

Seq Scan on z7_tilecover_countries quadkey (cost=0.00..269.95 rows=2 width=136) (actual time=0.389..2.020 rows=2 loops=1)

  • Filter: ((iso_a3)::text = 'NLD'::text)
  • Rows Removed by Filter: 7194
4. 19,336.790 19,336.790 ↓ 48.7 3,905,210 2

Index Scan using idx_nodes_geom on nodes (cost=0.56..304,857.92 rows=80,226 width=32) (actual time=0.172..9,668.395 rows=3,905,210 loops=2)

  • Index Cond: (geom && quadkey.geom)
  • Filter: _st_intersects(geom, quadkey.geom)
  • Rows Removed by Filter: 77
Planning time : 0.698 ms
Execution time : 41,232.922 ms