explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vg4U

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 8,916,539.564 ↓ 0.0 0 1

Limit (cost=0.57..120,629.21 rows=1 width=53) (actual time=8,916,539.564..8,916,539.564 rows=0 loops=1)

  • Output: reply_to_email_address, id
  • Buffers: shared hit=347568890 read=29349046
2. 8,916,539.563 8,916,539.563 ↓ 0.0 0 1

Index Scan Backward using pk_system_emails on public.system_emails (cost=0.57..56,092,317.71 rows=465 width=53) (actual time=8,916,539.563..8,916,539.563 rows=0 loops=1)

  • Output: reply_to_email_address, id
  • Filter: ((system_emails.to_email_address ~~* 'system@entrata.com'::text) AND ((system_emails.subject)::text ~~* '%Your delivery was picked up!%'::text) AND (system_emails.sent_on > (now() - '3 days'::interval)))
  • Rows Removed by Filter: 510596596
  • Buffers: shared hit=347568890 read=29349046