explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ua4v

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 2,117.350 ↑ 1.0 1 1

Aggregate (cost=20,581.82..20,581.83 rows=1 width=8) (actual time=2,117.350..2,117.350 rows=1 loops=1)

2. 1,486.586 2,117.346 ↓ 0.0 0 1

Bitmap Heap Scan on a_mail mail0_ (cost=17,867.51..20,581.82 rows=2 width=8) (actual time=2,117.346..2,117.346 rows=0 loops=1)

  • Recheck Cond: (((current_department_)::text = '071718'::text) AND (packet_list_ IS NULL) AND (act_item_ IS NULL) AND ((mail_status_)::text = 'Delivered'::text))
  • Filter: (((mail_type2_)::text = 'P144'::text) AND (delivery_date_ > (CURRENT_DATE - 60)) AND (delivery_date_ < (CURRENT_DATE - 30)))
  • Rows Removed by Filter: 1,544
  • Heap Blocks: exact=1,320
3. 30.559 630.760 ↓ 0.0 0 1

BitmapAnd (cost=17,867.51..17,867.51 rows=2,443 width=0) (actual time=630.760..630.760 rows=0 loops=1)

4. 97.070 97.070 ↓ 1.0 217,803 1

Bitmap Index Scan on a_mail_current_department_null_idx (cost=0.00..1,854.72 rows=209,746 width=0) (actual time=97.070..97.070 rows=217,803 loops=1)

  • Index Cond: ((current_department_)::text = '071718'::text)
5. 503.131 503.131 ↓ 1.1 1,178,298 1

Bitmap Index Scan on a_mail_mail_status_ (cost=0.00..16,012.77 rows=1,071,297 width=0) (actual time=503.131..503.131 rows=1,178,298 loops=1)

  • Index Cond: ((mail_status_)::text = 'Delivered'::text)
Planning time : 4.995 ms
Execution time : 2,136.086 ms