explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7wbf

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.06..25,705.60 rows=1 width=13,978) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

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

  • Filter: ((techindex_)::text = '010000'::text)
3. 0.000 0.000 ↓ 0.0

Index Scan using a_mail_current_department_ on a_mail am (cost=0.06..24,697.34 rows=1 width=12,842) (actual rows= loops=)

  • Index Cond: ((current_department_)::text = (wx.name_)::text)
  • Filter: ((market_shelf_ IS NOT NULL) AND ((to_telephone_1_)::text = '7029912555'::text))