explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ic41

Settings
# exclusive inclusive rows x rows loops node
1. 1,707.557 1,853.081 ↓ 1.3 22,732 1

Bitmap Heap Scan on public.send_mail_email mail (cost=20,447.02..78,890.38 rows=17,474 width=1,233) (actual time=147.328..1,853.081 rows=22,732 loops=1)

  • Output: id, app_id, name_sender, email_sender, name_receiver, email, subject, uuid, content, second_content, created_at, scheduled_at, sent_at, campaign_id, sended, not_sended, template_id
  • Recheck Cond: ((mail.app_id = 1) AND (date(timezone('UTC'::text, mail.created_at)) >= '2018-02-12'::date) AND (date(timezone('UTC'::text, mail.created_at)) <= '2019-03-11'::date) AND (mail.status = ANY ('{4,5}'::integer[])))
  • Heap Blocks: exact=6580
  • Buffers: shared hit=3604 read=6210
2. 145.524 145.524 ↓ 1.3 22,732 1

Bitmap Index Scan on send_mail_email_app_id_created_at_asdate_status (cost=0.00..20,442.65 rows=17,474 width=0) (actual time=145.524..145.524 rows=22,732 loops=1)

  • Index Cond: ((mail.app_id = 1) AND (date(timezone('UTC'::text, mail.created_at)) >= '2018-02-12'::date) AND (date(timezone('UTC'::text, mail.created_at)) <= '2019-03-11'::date) AND (mail.status = ANY ('{4,5}'::integer[])))
  • Buffers: shared hit=1617 read=1617