explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PbEZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.048 59.499 ↑ 1.0 100 1

Limit (cost=0.86..21,434.64 rows=100 width=265) (actual time=0.059..59.499 rows=100 loops=1)

2. 3.979 59.451 ↑ 32.0 100 1

Nested Loop (cost=0.86..685,882.01 rows=3,200 width=265) (actual time=0.057..59.451 rows=100 loops=1)

3. 22.454 22.454 ↑ 39.1 16,509 1

Index Scan Backward using index_notifications_on_time_to_display on notifications (cost=0.43..72,209.97 rows=645,174 width=264) (actual time=0.016..22.454 rows=16,509 loops=1)

  • Filter: (vetted AND (created_at < '2020-03-20 23:14:02'::timestamp without time zone))
  • Rows Removed by Filter: 12713
4. 33.018 33.018 ↓ 0.0 0 16,509

Index Scan using index_user_notifications_on_user_id_and_notification_id on user_notifications (cost=0.43..0.94 rows=1 width=5) (actual time=0.002..0.002 rows=0 loops=16,509)

  • Index Cond: ((user_id = 1154) AND (notification_id = notifications.id))
Planning time : 0.500 ms
Execution time : 59.568 ms