explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QkHO

Settings
# exclusive inclusive rows x rows loops node
1. 26.792 50.576 ↓ 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=25.199..50.576 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. 23.784 23.784 ↓ 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=23.784..23.784 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[])))