explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mjG

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 5.535 ↓ 0.0 5 1

Unique (cost=0..0 rows=0 width=0) (actual time=5.533..5.535 rows=5 loops=1)

2. 0.007 5.533 ↓ 0.0 5 1

Sort (cost=0..0 rows=0 width=0) (actual time=5.532..5.533 rows=5 loops=1)

  • Sort Key: se.shift_id
  • Sort Method: quicksort Memory: 25kB
3. 0.003 5.526 ↓ 0.0 5 1

Nested Loop (cost=0..0 rows=0 width=0) (actual time=5.496..5.526 rows=5 loops=1)

4. 0.026 5.498 ↓ 0.0 5 1

Bitmap Heap Scan on shift_event se (cost=0..0 rows=0 width=0) (actual time=5.485..5.498 rows=5 loops=1)

  • Filter: (date_part('day'::text, (now() - occurred_at)) < '120'::double precision)
5. 0.016 5.472 ↓ 0.0 0 1

BitmapAnd (cost=0..0 rows=0 width=0) (actual time=5.472..5.472 rows=0 loops=1)

6. 4.964 4.964 ↓ 0.0 275 1

Bitmap Index Scan on shift_event_user_id (cost=0..0 rows=0 width=0) (actual time=4.964..4.964 rows=275 loops=1)

  • Index Cond: (user_id = 22259)
7. 0.492 0.492 ↓ 0.0 4,671 1

Bitmap Index Scan on shift_event_type_idx (cost=0..0 rows=0 width=0) (actual time=0.492..0.492 rows=4,671 loops=1)

  • Index Cond: (type = 53)
8. 0.025 0.025 ↓ 0.0 1 5

Index Only Scan using shift_pkey on shift s (cost=0..0 rows=0 width=0) (actual time=0.005..0.005 rows=1 loops=5)

  • Index Cond: (id = se.shift_id)