explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kKG6 : Optimization for: Optimization for: Optimization for: plan #yjMh; plan #wnJx; plan #ADVh

Settings

Optimization path:

Optimization(s) for this plan:

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

Merge Join (cost=2,751,226.50..3,636,272.49 rows=47,649,078 width=104) (actual rows= loops=)

  • Merge Cond: ((s1.num_cnpj)::text = (s2.num_cnpj)::text)
  • Join Filter: ((s2.num_cnpj_empresa)::text <> (s1.num_cnpj_empresa)::text)
2. 0.000 0.000 ↓ 0.0

Sort (cost=1,375,613.25..1,392,674.95 rows=6,824,682 width=67) (actual rows= loops=)

  • Sort Key: s1.num_cnpj
3. 0.000 0.000 ↓ 0.0

Seq Scan on vw_socio s1 (cost=0.00..321,012.82 rows=6,824,682 width=67) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=1,375,613.25..1,409,736.66 rows=6,824,682 width=67) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Sort (cost=1,375,613.25..1,392,674.95 rows=6,824,682 width=67) (actual rows= loops=)

  • Sort Key: s2.num_cnpj
6. 0.000 0.000 ↓ 0.0

Seq Scan on vw_socio s2 (cost=0.00..321,012.82 rows=6,824,682 width=67) (actual rows= loops=)