explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SuxF : Optimization for: plan #nD7U

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 16,297.928 24,619.858 ↑ 18.7 422,295 1

Nested Loop (cost=0.56..20,448,676.42 rows=7,895,675 width=663) (actual time=30.012..24,619.858 rows=422,295 loops=1)

2. 0.050 0.050 ↑ 1.0 7 1

Values Scan on "*VALUES*" (cost=0.00..0.09 rows=7 width=32) (actual time=0.002..0.050 rows=7 loops=1)

3. 8,321.880 8,321.880 ↑ 18.7 60,328 7

Index Scan using a_mail_mail_status_ on a_mail t1 (cost=0.56..1,773,546.72 rows=1,127,953 width=57) (actual time=92.787..1,188.840 rows=60,328 loops=7)

  • Index Cond: ((mail_status_)::text = "*VALUES*".column1)
  • 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: 367077
Planning time : 1.343 ms
Execution time : 24,640.740 ms