explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jkfj : Optimization for: plan #I37j

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.023 1,026.948 ↑ 1.0 1 1

Nested Loop (cost=8,360.90..9,646.69 rows=1 width=13,956) (actual time=1,020.352..1,026.948 rows=1 loops=1)

2. 8.645 8.645 ↑ 1.0 1 1

Seq Scan on wx_group wx (cost=0.00..1,008.25 rows=1 width=1,136) (actual time=6.440..8.645 rows=1 loops=1)

  • Filter: ((techindex_)::text = '010000'::text)
  • Rows Removed by Filter: 13,000
3. 200.093 1,018.280 ↑ 1.0 1 1

Bitmap Heap Scan on a_mail am (cost=8,360.90..8,638.43 rows=1 width=12,820) (actual time=1,013.891..1,018.280 rows=1 loops=1)

  • Recheck Cond: (((current_department_)::text = (wx.name_)::text) AND (market_shelf_ IS NOT NULL))
  • Filter: ((to_telephone_1_)::text = '7029912555'::text)
  • Rows Removed by Filter: 32,784
  • Heap Blocks: exact=29,019
4. 74.297 818.187 ↓ 0.0 0 1

BitmapAnd (cost=8,360.90..8,360.90 rows=250 width=0) (actual time=818.186..818.187 rows=0 loops=1)

5. 493.737 493.737 ↓ 49.2 1,091,992 1

Bitmap Index Scan on a_mail_current_department_ (cost=0.00..374.05 rows=22,208 width=0) (actual time=493.737..493.737 rows=1,091,992 loops=1)

  • Index Cond: ((current_department_)::text = (wx.name_)::text)
6. 250.153 250.153 ↑ 1.0 945,920 1

Bitmap Index Scan on a_mail_market_shelf_ind (cost=0.00..7,986.83 rows=967,099 width=0) (actual time=250.153..250.153 rows=945,920 loops=1)

  • Index Cond: (market_shelf_ IS NOT NULL)
Planning time : 4.073 ms
Execution time : 1,047.532 ms