explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qbU4

Settings
# exclusive inclusive rows x rows loops node
1. 73.149 21,031.124 ↑ 1.4 11,576 1

Gather (cost=1,075.12..1,443,262.44 rows=16,665 width=87) (actual time=9,684.650..21,031.124 rows=11,576 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 13.801 20,957.975 ↑ 1.8 3,859 3 / 3

Hash Join (cost=75.12..1,440,595.94 rows=6,944 width=87) (actual time=9,737.280..20,957.975 rows=3,859 loops=3)

  • Hash Cond: (transmission_outage_data.from_substation = "*VALUES*".column1)
3. 20,941.883 20,941.883 ↑ 1.8 3,859 3 / 3

Parallel Seq Scan on transmission_outage_data (cost=0.00..1,440,425.33 rows=6,944 width=87) (actual time=9,732.595..20,941.883 rows=3,859 loops=3)

  • Filter: (actual_end_date IS NOT NULL)
  • Rows Removed by Filter: 16662808
4. 0.910 2.291 ↑ 1.0 3,005 3 / 3

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

  • Buckets: 4096 Batches: 1 Memory Usage: 145kB
5. 1.381 1.381 ↑ 1.0 3,005 3 / 3

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

Planning time : 4.703 ms
Execution time : 21,033.063 ms