explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VY5q

Settings
# exclusive inclusive rows x rows loops node
1. 23,007.727 100,573.318 ↓ 13.4 22,777 1

Nested Loop Left Join (cost=1.14..15,847.75 rows=1,700 width=76) (actual time=1.337..100,573.318 rows=22,777 loops=1)

  • Join Filter: (ser.id = ee.system_email_recipient_id)
  • Rows Removed by Join Filter: 285690401
2. 8.482 241.071 ↓ 13.4 22,776 1

Nested Loop Left Join (cost=0.57..7,951.25 rows=1,700 width=24) (actual time=0.985..241.071 rows=22,776 loops=1)

  • Filter: ((se.applicant_id IS NOT NULL) OR (ser.id IS NOT NULL))
  • Rows Removed by Filter: 67
3. 0.023 0.023 ↑ 20.5 83 1

Seq Scan on system_emails_temp se (cost=0.00..61.00 rows=1,700 width=20) (actual time=0.007..0.023 rows=83 loops=1)

4. 232.566 232.566 ↓ 274.0 274 83

Index Scan using idx_system_email_recipients_custom_system_email_id on system_email_recipients ser (cost=0.57..4.61 rows=1 width=12) (actual time=0.033..2.802 rows=274 loops=83)

  • Index Cond: ((cid = se.cid) AND (recipient_type_id = 1) AND (system_email_id = se.id))
5. 77,324.520 77,324.520 ↓ 12,544.0 12,544 22,776

Index Scan using idx_email_events_system_email_id on email_events ee (cost=0.57..4.61 rows=1 width=68) (actual time=0.007..3.395 rows=12,544 loops=22,776)

  • Index Cond: (system_email_id = se.id)
  • Filter: (cid = se.cid)
Planning time : 11.922 ms