explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FCvH

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

Gather Merge (cost=34,532.26..34,587.80 rows=476 width=209) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Sort (cost=33,532.24..33,532.84 rows=238 width=209) (actual rows= loops=)

  • Sort Key: (date(created_at))
3. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on events (cost=2,278.52..33,522.85 rows=238 width=209) (actual rows= loops=)

  • Recheck Cond: ((home_id = '10017724'::bigint) OR (home_id IS NULL))
  • Filter: ((date(created_at) >= '2020-05-31'::date) AND (date(created_at) <= '2020-07-05'::date))
4. 0.000 0.000 ↓ 0.0

BitmapOr (cost=2,278.52..2,278.52 rows=115,918 width=0) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on index_events_on_home_id (cost=0.00..426.97 rows=21,673 width=0) (actual rows= loops=)

  • Index Cond: (home_id = '10017724'::bigint)
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on index_events_on_home_id (cost=0.00..1,851.26 rows=94,245 width=0) (actual rows= loops=)

  • Index Cond: (home_id IS NULL)