explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ug1N

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6.38..126.40 rows=1 width=25) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Index Scan using carrier_idx1 on carrier car (cost=0.28..8.29 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((carrier_code)::text = 'GLC'::text)
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on schedule schd (cost=6.11..117.61 rows=50 width=29) (actual rows= loops=)

  • Recheck Cond: ((carrier_id = car.carrier_id) AND (effective_date <= '2020-03-16'::date) AND (catalog_date < '2020-03-16'::date))
  • Filter: (((expiration_date IS NULL) OR (expiration_date >= '2020-03-16'::date)) AND ((inactive_date IS NULL) OR (inactive_date >= '2020-03-16'::date)))
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on schedule_idx2 (cost=0.00..6.09 rows=84 width=0) (actual rows= loops=)

  • Index Cond: ((carrier_id = car.carrier_id) AND (effective_date <= '2020-03-16'::date) AND (catalog_date < '2020-03-16'::date))