explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eHWU

Settings
# exclusive inclusive rows x rows loops node
1. 2,125.619 2,151.205 ↓ 1.3 19,442 1

Bitmap Heap Scan on send_mail_email mail (cost=12,184.95..61,632.43 rows=14,510 width=1,233) (actual time=26.928..2,151.205 rows=19,442 loops=1)

  • Recheck Cond: ((app_id = 1) AND (date(timezone('UTC'::text, created_at)) >= '2018-02-12'::date) AND (date(timezone('UTC'::text, created_at)) <= '2019-03-11'::date) AND (status = ANY ('{3}'::integer[])))
  • Heap Blocks: exact=7017
2. 25.586 25.586 ↓ 1.3 19,442 1

Bitmap Index Scan on send_mail_email_app_id_created_at_asdate_status (cost=0.00..12,181.32 rows=14,510 width=0) (actual time=25.586..25.586 rows=19,442 loops=1)

  • Index Cond: ((app_id = 1) AND (date(timezone('UTC'::text, created_at)) >= '2018-02-12'::date) AND (date(timezone('UTC'::text, created_at)) <= '2019-03-11'::date) AND (status = ANY ('{3}'::integer[])))