explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c2th

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.048 ↑ 1.0 1 1

Aggregate (cost=5,497.18..5,497.19 rows=1 width=8) (actual time=0.048..0.048 rows=1 loops=1)

2. 0.046 0.046 ↓ 0.0 0 1

Index Scan using a_mail_current_department_ on a_mail mail0_ (cost=0.06..5,497.18 rows=2 width=8) (actual time=0.045..0.046 rows=0 loops=1)

  • Index Cond: ((current_department_)::text = '071740'::text)
  • Filter: ((packet_list_ IS NULL) AND (act_item_ IS NULL) AND ((mail_status_)::text = ANY ('{Registered,Returned,Forwarded,Arrived,ForDeliveryList,SendedToDeadLetter,RemovedFromForeign}'::text[])) AND (((modify_date_ IS NOT NULL) AND (date(modify_date_) = CURRENT_DATE)) OR ((modify_date_ IS NULL) AND (date(create_date_) = CURRENT_DATE))))
Planning time : 0.856 ms
Execution time : 0.162 ms