explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pil6

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Join (cost=6,983,506.77..53,431,579.06 rows=668,361 width=156) (actual rows= loops=)

  • Hash Cond: ((t1.mail_id_)::text = (t2.mail_id_)::text)
2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on a_mail_action t1 (cost=2,851,275.01..48,703,255.92 rows=668,517 width=28) (actual rows= loops=)

  • Recheck Cond: ((mail_status_)::text = 'Registered'::text)
  • Filter: ((date_trunc('day'::text, create_date_) >= '2018-01-01 00:00:00'::timestamp without time zone) AND (date_trunc('day'::text, create_date_) <= '2018-01-01 23:59:59'::timestamp without time zone))
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mail_action_mailstatus_ind (cost=0.00..2,851,107.88 rows=133,703,374 width=0) (actual rows= loops=)

  • Index Cond: ((mail_status_)::text = 'Registered'::text)
4. 0.000 0.000 ↓ 0.0

Hash (cost=3,476,363.56..3,476,363.56 rows=35,723,856 width=24) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on a_mail t2 (cost=0.00..3,476,363.56 rows=35,723,856 width=24) (actual rows= loops=)