explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

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

Nested Loop (cost=0.00..1,385,428,479.52 rows=116,407,172,391,815 width=74) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on socio s1 (cost=0.00..803,424.16 rows=20,184,616 width=52) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan using idx_rfb_socio_cnpj on socio s2 (cost=0.00..45.78 rows=2,282 width=52) (actual rows= loops=)

  • Index Cond: ((num_cnpj)::text = (s1.num_cnpj)::text)
  • Filter: ((num_cnpj_empresa)::text <> (s1.num_cnpj_empresa)::text)