explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NBJ3 : Optimization for: Optimization for: plan #I37j; plan #Jkfj

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.022 6,452.919 ↑ 1.0 1 1

Nested Loop (cost=2,864.22..3,059.58 rows=1 width=13,956) (actual time=6,452.917..6,452.919 rows=1 loops=1)

2. 1.149 6,452.824 ↑ 2.0 1 1

Bitmap Heap Scan on a_mail am (cost=2,864.19..3,052.88 rows=2 width=12,820) (actual time=6,452.823..6,452.824 rows=1 loops=1)

  • Recheck Cond: ((to_telephone_1_)::text ~~ '7029912555'::text)
  • Filter: (market_shelf_ IS NOT NULL)
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=15
3. 6,451.675 6,451.675 ↑ 11.3 15 1

Bitmap Index Scan on a_mail_to_phone_1_idx (cost=0.00..2,864.19 rows=170 width=0) (actual time=6,451.675..6,451.675 rows=15 loops=1)

  • Index Cond: ((to_telephone_1_)::text ~~ '7029912555'::text)
4. 0.073 0.073 ↑ 1.0 1 1

Index Scan using wx_group_pkey on wx_group wx (cost=0.03..2.24 rows=1 width=1,136) (actual time=0.073..0.073 rows=1 loops=1)

  • Index Cond: ((name_)::text = (am.current_department_)::text)
  • Filter: ((techindex_)::text = '010000'::text)
Planning time : 4.670 ms
Execution time : 6,453.260 ms