explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WmU

Settings
# exclusive inclusive rows x rows loops node
1. 24.399 33,041.591 ↓ 1.0 2,351 1

HashAggregate (cost=9,085.42..9,108.30 rows=2,288 width=8) (actual time=33,040.916..33,041.591 rows=2,351 loops=1)

  • Group Key: task_id
2. 32,346.109 33,017.192 ↓ 1.5 3,629 1

Bitmap Heap Scan on notifications (cost=65.01..9,073.50 rows=2,385 width=8) (actual time=682.059..33,017.192 rows=3,629 loops=1)

  • Recheck Cond: ((recipient_id = 6701) AND (created_at > '2019-01-01 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=3860
3. 671.083 671.083 ↓ 2.3 5,597 1

Bitmap Index Scan on index_notifications_on_recipient_id_and_created_at (cost=0.00..64.41 rows=2,385 width=0) (actual time=671.083..671.083 rows=5,597 loops=1)

  • Index Cond: ((recipient_id = 6701) AND (created_at > '2019-01-01 00:00:00'::timestamp without time zone))