explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EI1b : Optimization for: Optimization for: plan #PnPx; plan #ZGl

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 8,302.333 8,302.333 ↓ 33.5 6,394 1

Index Scan using a_mail_mail_status_ on a_mail (cost=0.56..744,361.17 rows=191 width=142) (actual time=463.478..8,302.333 rows=6,394 loops=1)

  • Index Cond: ((mail_status_)::text = 'Delivered'::text)
  • Filter: (((mail_type2_)::text = ANY ('{P104,P113,P115,P118,P124,P204,P212,P213}'::text[])) AND (date_trunc('day'::text, modify_date_) >= (CURRENT_DATE - 30)) AND (date_trunc('day'::text, modify_date_) <= (CURRENT_DATE - 1)))
  • Rows Removed by Filter: 939832
Planning time : 9.274 ms
Execution time : 8,302.935 ms