explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lJDa

Settings
# exclusive inclusive rows x rows loops node
1. 1,026.065 1,634.306 ↑ 2.0 1 1

HashAggregate (cost=17,365.06..17,365.08 rows=2 width=196) (actual time=1,634.304..1,634.306 rows=1 loops=1)

  • Group Key: qk.id, qk.iso_a3, qk.continent, qk.name_en, qk.geom
2. 214.878 608.241 ↓ 25.8 128,712 1

Nested Loop (cost=0.42..15,991.15 rows=4,996 width=342) (actual time=0.449..608.241 rows=128,712 loops=1)

3. 0.969 0.969 ↑ 1.0 2 1

Seq Scan on z7_tilecover_countries qk (cost=0.00..269.95 rows=2 width=156) (actual time=0.172..0.969 rows=2 loops=1)

  • Filter: ((iso_a3)::text = 'NLD'::text)
  • Rows Removed by Filter: 7194
4. 392.394 392.394 ↓ 305.0 64,356 2

Index Scan using idx_highway_linestring on highway (cost=0.42..7,858.49 rows=211 width=186) (actual time=0.132..196.197 rows=64,356 loops=2)

  • Index Cond: (linestring && qk.geom)
  • Filter: (((tags -> 'highway'::text) = ANY ('{residential,unclassified,living_street,track,service,tertiary,secondary,primary,trunk,motorway,motorway_link,trunk_link,primary_link,secondary_link,tertiary_link,footway,cycleway,path,bridleway,steps,pedestrian}'::text[])) AND _st_intersects(linestring, qk.geom))
  • Rows Removed by Filter: 262
Planning time : 0.554 ms
Execution time : 1,634.383 ms