explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OL3W

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 275,019.268 ↑ 1.0 25 1

Limit (cost=0.57..7,922.22 rows=25 width=90) (actual time=215.599..275,019.268 rows=25 loops=1)

2. 275,019.252 275,019.252 ↑ 447.6 25 1

Index Scan Backward using notifications_pkey on notifications (cost=0.57..3,545,731.51 rows=11,190 width=90) (actual time=215.598..275,019.252 rows=25 loops=1)

  • Filter: (recipient_id = 88862)
  • Rows Removed by Filter: 28,888,636
Planning time : 18.679 ms
Execution time : 275,020.338 ms