explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pN0V5

Settings
# exclusive inclusive rows x rows loops node
1. 25,999.895 50,672.741 ↑ 1.0 50,000,000 1

Hash Join (cost=75.12..2,419,667.12 rows=50,000,000 width=87) (actual time=9,712.672..50,672.741 rows=50,000,000 loops=1)

  • Hash Cond: (transmission_outage_data.from_substation = "*VALUES*".column1)
2. 24,671.307 24,671.307 ↑ 1.0 50,000,000 1

Seq Scan on transmission_outage_data (cost=0.00..1,732,092.00 rows=50,000,000 width=87) (actual time=9,711.108..24,671.307 rows=50,000,000 loops=1)

3. 0.564 1.539 ↑ 1.0 3,005 1

Hash (cost=37.56..37.56 rows=3,005 width=32) (actual time=1.539..1.539 rows=3,005 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 145kB
4. 0.975 0.975 ↑ 1.0 3,005 1

Values Scan on "*VALUES*" (cost=0.00..37.56 rows=3,005 width=32) (actual time=0.004..0.975 rows=3,005 loops=1)

Planning time : 1.121 ms
Execution time : 52,919.734 ms