# | 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)
|
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)
|
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)
|
Planning time | : | 0.554 ms |
---|---|---|
Execution time | : | 1,634.383 ms |