explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eq6e : Optimization for: plan #6f0

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 4,111.450 31,021.638 ↓ 1.0 16,469,420 1

Hash Join (cost=321,406.42..1,036,868.31 rows=16,469,395 width=52) (actual time=4,474.944..31,021.638 rows=16,469,420 loops=1)

  • Hash Cond: (here_streets.network_id = here_streets_info.id)
2. 14,218.987 26,910.177 ↓ 1.0 16,469,420 1

Hash Join (cost=321,377.30..993,391.46 rows=16,469,395 width=24) (actual time=4,474.926..26,910.177 rows=16,469,420 loops=1)

  • Hash Cond: (network_config.here_streets_id = here_streets.id)
3. 8,219.218 8,219.218 ↓ 1.0 16,469,420 1

Seq Scan on network_config (cost=0.00..448,649.95 rows=16,469,395 width=12) (actual time=0.148..8,219.218 rows=16,469,420 loops=1)

4. 886.938 4,471.972 ↓ 1.0 3,293,884 1

Hash (cost=260,911.91..260,911.91 rows=3,293,391 width=20) (actual time=4,471.972..4,471.972 rows=3,293,884 loops=1)

  • Buckets: 524288 Batches: 16 Memory Usage: 14352kB
5. 3,585.034 3,585.034 ↓ 1.0 3,293,884 1

Seq Scan on here_streets (cost=0.00..260,911.91 rows=3,293,391 width=20) (actual time=0.011..3,585.034 rows=3,293,884 loops=1)

6. 0.002 0.011 ↑ 850.0 1 1

Hash (cost=18.50..18.50 rows=850 width=36) (actual time=0.011..0.011 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.009 0.009 ↑ 850.0 1 1

Seq Scan on here_streets_info (cost=0.00..18.50 rows=850 width=36) (actual time=0.008..0.009 rows=1 loops=1)