explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8sfL

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

CTE Scan on x (cost=58.03..58.07 rows=1 width=636) (actual rows= loops=)

2.          

CTE x

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.86..58.03 rows=1 width=308) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.71..24.79 rows=1 width=596) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..16.61 rows=1 width=462) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using eleitores_idx5 on eleitores e (cost=0.42..8.44 rows=1 width=304) (actual rows= loops=)

  • Index Cond: ((cpf)::text = '29006406104'::text)
7. 0.000 0.000 ↓ 0.0

Index Scan using regioes_pkey on regioes r (cost=0.14..8.16 rows=1 width=162) (actual rows= loops=)

  • Index Cond: (idregiao = e.idregiao)
  • Filter: ((uf)::text = 'DF'::text)
8. 0.000 0.000 ↓ 0.0

Index Scan using situacoes_pkey on situacoes s (cost=0.15..8.17 rows=1 width=142) (actual rows= loops=)

  • Index Cond: (idsituacao = e.idsituacao)
9. 0.000 0.000 ↓ 0.0

Index Scan using existedebito_pkey on existedebito d (cost=0.15..8.17 rows=1 width=62) (actual rows= loops=)

  • Index Cond: (idexistedebito = e.idexistedebito)
10.          

SubPlan (forNested Loop Left Join)

11. 0.000 0.000 ↓ 0.0

Aggregate (cost=24.80..24.81 rows=1 width=8) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.72..24.80 rows=1 width=4) (actual rows= loops=)

  • Filter: (concat(sx.nome, dx.nome) = 'AtivoNão'::text)
13. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.57..16.62 rows=1 width=146) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Index Scan using eleitores_idx5 on eleitores ex (cost=0.42..8.44 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((cpf)::text = '${registro}'::text)
  • Filter: (idregiao <> r.idregiao)
15. 0.000 0.000 ↓ 0.0

Index Scan using situacoes_pkey on situacoes sx (cost=0.15..8.17 rows=1 width=142) (actual rows= loops=)

  • Index Cond: (idsituacao = ex.idsituacao)
16. 0.000 0.000 ↓ 0.0

Index Scan using existedebito_pkey on existedebito dx (cost=0.15..8.17 rows=1 width=62) (actual rows= loops=)

  • Index Cond: (idexistedebito = ex.idexistedebito)