explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nD7U

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 119,459.913 119,459.913 ↑ 2.8 422,363 1

Index Scan using a_mail_mail_status_ on a_mail t1 (cost=0.56..3,665,909.16 rows=1,185,630 width=663) (actual time=3.681..119,459.913 rows=422,363 loops=1)

  • Index Cond: ((mail_status_)::text = ANY ('{Created,Registered,Departed,Transit,Returned,Forwarded,atCustom}'::text[]))
  • Filter: ((modify_date_ > '2019-03-01 00:00:00'::timestamp without time zone) AND (modify_date_ < (CURRENT_DATE - '15:00:00'::interval)))
  • Rows Removed by Filter: 2567860
Planning time : 5.831 ms
Execution time : 119,481.593 ms