explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cNO2 : Optimization for: plan #eUTh

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.007 2.234 ↓ 0.0 0 1

Bitmap Heap Scan on transmission_outage_data (cost=116.31..136.09 rows=1 width=82) (actual time=2.234..2.234 rows=0 loops=1)

  • Recheck Cond: ((to_substation = ANY ('{WCWS,CLEARCRO}'::text[])) AND (from_substation = ANY ('{CLEARCRO,WCWS}'::text[])))
  • Filter: (actual_end_date IS NOT NULL)
2. 0.101 2.227 ↓ 0.0 0 1

BitmapAnd (cost=116.31..116.31 rows=5 width=0) (actual time=2.227..2.227 rows=0 loops=1)

3. 0.230 0.230 ↑ 6.4 166 1

Bitmap Index Scan on ix_gaiascope_transmission_outage_data_to_substation (cost=0.00..24.85 rows=1,065 width=0) (actual time=0.230..0.230 rows=166 loops=1)

  • Index Cond: (to_substation = ANY ('{WCWS,CLEARCRO}'::text[]))
4. 1.896 1.896 ↑ 1.1 4,065 1

Bitmap Index Scan on ix_gaiascope_transmission_outage_data_from_substation (cost=0.00..91.22 rows=4,583 width=0) (actual time=1.896..1.896 rows=4,065 loops=1)

  • Index Cond: (from_substation = ANY ('{CLEARCRO,WCWS}'::text[]))