explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lxux : ac_his

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 9,014.018 ↑ 1.0 1 1

Aggregate (cost=221,477.30..221,477.31 rows=1 width=8) (actual time=9,014.018..9,014.018 rows=1 loops=1)

2. 220.542 9,013.998 ↑ 3.7 63 1

Bitmap Heap Scan on a_mail (cost=159,839.80..221,477.25 rows=230 width=0) (actual time=9,001.237..9,013.998 rows=63 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,001
  • Heap Blocks: exact=8,395
3. 7,851.162 8,793.456 ↓ 0.0 0 1

BitmapAnd (cost=159,839.80..159,839.80 rows=55,773 width=0) (actual time=8,793.456..8,793.456 rows=0 loops=1)

  • -> Bitmap Index Scan on a_mail_mail_status_ (cost=0.00..151895.78 rows=10,189,919 width=0) (actual time=7,617.334..7617.334 rows=11,300,440 loops=1)" Index Cond: ((mail_status_)::text = ANY ('{Registered,Returned,Forwarded,Arrived,ForDeliveryList,SendedToDeadLetter,RemovedFromForeign}'::text[]))
4. 942.294 942.294 ↓ 1.1 526,134 1

Bitmap Index Scan on a_mail_current_department_ (cost=0.00..7,943.98 rows=477,662 width=0) (actual time=942.294..942.294 rows=526,134 loops=1)

  • Index Cond: ((current_department_)::text = '299900/06/03'::text)