explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fxcm

Settings
# exclusive inclusive rows x rows loops node
1. 0.060 8,595.962 ↑ 1.0 1 1

Aggregate (cost=226,978.04..226,978.05 rows=1 width=8) (actual time=8,595.962..8,595.962 rows=1 loops=1)

2. 145.298 8,595.902 ↓ 1.4 338 1

Bitmap Heap Scan on a_mail mail0_ (cost=162,097.01..226,977.98 rows=243 width=8) (actual time=8,484.153..8,595.902 rows=338 loops=1)

  • Recheck Cond: (((current_department_)::text = '299900/06/03'::text) AND ((mail_status_)::text = ANY ('{Registered,Returned,Forwarded,Arrived,ForDeliveryList,SendedToDeadLetter,RemovedFromForeign}'::text[])))
  • Filter: ((packet_list_ IS NULL) AND (act_item_ IS NULL) AND (((modify_date_ IS NOT NULL) AND (date(modify_date_) = CURRENT_DATE)) OR ((modify_date_ IS NULL) AND (date(create_date_) = CURRENT_DATE))))
  • Rows Removed by Filter: 10,105
  • Heap Blocks: exact=10,164
3. 272.382 8,450.604 ↓ 0.0 0 1

BitmapAnd (cost=162,097.01..162,097.01 rows=58,721 width=0) (actual time=8,450.604..8,450.604 rows=0 loops=1)

4. 226.838 226.838 ↓ 1.1 525,662 1

Bitmap Index Scan on a_mail_current_department_ (cost=0.00..8,264.83 rows=497,918 width=0) (actual time=226.837..226.838 rows=525,662 loops=1)

  • Index Cond: ((current_department_)::text = '299900/06/03'::text)
5. 7,951.384 7,951.384 ↓ 2.9 29,958,801 1

Bitmap Index Scan on a_mail_mail_status_ (cost=0.00..153,832.15 rows=10,380,865 width=0) (actual time=7,951.384..7,951.384 rows=29,958,801 loops=1)

  • Index Cond: ((mail_status_)::text = ANY ('{Registered,Returned,Forwarded,Arrived,ForDeliveryList,SendedToDeadLetter,RemovedFromForeign}'::text[]))
Planning time : 1.315 ms
Execution time : 8,611.631 ms