explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uKYl

Settings
# exclusive inclusive rows x rows loops node
1. 1.656 5.373 ↓ 1.6 380 1

Bitmap Heap Scan on a_mail mail0_ (cost=177.11..311.70 rows=243 width=12,850) (actual time=3.776..5.373 rows=380 loops=1)

  • Recheck Cond: (((packet_list_ IS NULL) AND (act_item_ IS NULL) AND ((current_department_)::text = '299900/06/03'::text) AND ((mail_status_)::text = ANY ('{Registered,Returned,Forwarded,Arrived,ForDeliveryList,SendedToDeadLetter,RemovedFromForeign}'::text[])) AND (date(modify_date_) = CURRENT_DATE)) OR ((packet_list_ IS NULL) AND (act_item_ IS NULL) AND ((current_department_)::text = '299900/06/03'::text) AND ((mail_status_)::text = ANY ('{Registered,Returned,Forwarded,Arrived,ForDeliveryList,SendedToDeadLetter,RemovedFromForeign}'::text[])) AND (date(create_date_) = CURRENT_DATE)))
  • Filter: ((packet_list_ IS NULL) AND (act_item_ IS NULL) AND ((mail_status_)::text = ANY ('{Registered,Returned,Forwarded,Arrived,ForDeliveryList,SendedToDeadLetter,RemovedFromForeign}'::text[])) AND ((date(modify_date_) = CURRENT_DATE) OR ((modify_date_ IS NULL) AND (date(create_date_) = CURRENT_DATE))))
  • Heap Blocks: exact=234
  • Buffers: shared hit=348
2. 0.002 3.717 ↓ 0.0 0 1

BitmapOr (cost=177.11..177.11 rows=121 width=0) (actual time=3.717..3.717 rows=0 loops=1)

  • Buffers: shared hit=114
3. 0.463 0.463 ↓ 6.3 386 1

Bitmap Index Scan on packet_act_null_dts_idx (cost=0.00..8.48 rows=61 width=0) (actual time=0.463..0.463 rows=386 loops=1)

  • Index Cond: (((packet_list_ IS NULL) = true) AND ((act_item_ IS NULL) = true) AND ((current_department_)::text = '299900/06/03'::text) AND ((mail_status_)::text = ANY ('{Registered,Returned,Forwarded,Arrived,ForDeliveryList,SendedToDeadLetter,RemovedFromForeign}'::text[])) AND (date(modify_date_) = CURRENT_DATE))
  • Buffers: shared hit=31
4. 3.252 3.252 ↓ 2.4 149 1

Bitmap Index Scan on packet_act_null_dts_idx (cost=0.00..168.61 rows=61 width=0) (actual time=3.252..3.252 rows=149 loops=1)

  • Index Cond: (((packet_list_ IS NULL) = true) AND ((act_item_ IS NULL) = true) AND ((current_department_)::text = '299900/06/03'::text) AND ((mail_status_)::text = ANY ('{Registered,Returned,Forwarded,Arrived,ForDeliveryList,SendedToDeadLetter,RemovedFromForeign}'::text[])) AND (date(create_date_) = CURRENT_DATE))
  • Buffers: shared hit=83
Planning time : 2.505 ms
Execution time : 5.614 ms