explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c5xB

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 1.218 ↑ 1.0 1 1

Aggregate (cost=5,546.30..5,546.31 rows=1 width=8) (actual time=1.218..1.218 rows=1 loops=1)

2. 1.213 1.213 ↓ 0.0 0 1

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

  • Index Cond: ((current_department_)::text = '019900/22'::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 : 1.134 ms
Execution time : 1.356 ms