explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IXcK

Settings
# exclusive inclusive rows x rows loops node
1. 8.018 6,273.793 ↑ 1.0 1 1

Aggregate (cost=476,431.59..476,431.60 rows=1 width=8) (actual time=6,273.792..6,273.793 rows=1 loops=1)

  • Planning time: 0.150 ms
  • Execution time: 6273.825 ms
2. 6,265.775 6,265.775 ↓ 22.8 44,500 1

Index Only Scan using index_notifications_on_recipient_id_and_created_at on notifications (cost=0.57..476,426.71 rows=1,954 width=0) (actual time=21.510..6,265.775 rows=44,500 loops=1)

  • Index Cond: (created_at > (now() - '2 days'::interval))
  • Heap Fetches: 47619