explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2msW

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

Hash Join (cost=38.23..245.31 rows=1,254 width=25) (actual rows= loops=)

  • Hash Cond: (schd.carrier_id = car.carrier_id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on schedule schd (cost=0.00..203.78 rows=1,254 width=29) (actual rows= loops=)

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

Hash (cost=25.88..25.88 rows=988 width=12) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on carrier car (cost=0.00..25.88 rows=988 width=12) (actual rows= loops=)