#	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

"QUERY PLAN"
"HashAggregate  (cost=17365.06..17365.08 rows=2 width=196) (actual time=1634.304..1634.306 rows=1 loops=1)"
"  Group Key: qk.id, qk.iso_a3, qk.continent, qk.name_en, qk.geom"
"  ->  Nested Loop  (cost=0.42..15991.15 rows=4996 width=342) (actual time=0.449..608.241 rows=128712 loops=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"
"        ->  Index Scan using idx_highway_linestring on highway  (cost=0.42..7858.49 rows=211 width=186) (actual time=0.132..196.197 rows=64356 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: 1634.383 ms"

Per node type stats

node type	count	sum of times	% of query
HashAggregate	1	1,026.065 ms	62.8 %
Index Scan	1	392.394 ms	24.0 %
Nested Loop	1	214.878 ms	13.1 %
Seq Scan	1	0.969 ms	0.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
highway	1	392.394 ms	24.0 %
Index Scan	1	392.394 ms	100.0 %
z7_tilecover_countries	1	0.969 ms	0.1 %
Seq Scan	1	0.969 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lJDa

Color mode:

Visible columns:

Per node type stats

Per table stats