explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eUTh

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 5.546 93.677 ↓ 0.0 0 1

Gather (cost=1,000.00..20,374.10 rows=1 width=82) (actual time=91.105..93.677 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 88.131 88.131 ↓ 0.0 0 3 / 3

Parallel Seq Scan on transmission_outage_data (cost=0.00..19,374.00 rows=1 width=82) (actual time=88.130..88.131 rows=0 loops=3)

  • Filter: ((actual_end_date IS NOT NULL) AND (from_substation = ANY ('{CLEARCRO,WCWS}'::text[])) AND (to_substation = ANY ('{WCWS,CLEARCRO}'::text[])))
  • Rows Removed by Filter: 333333