explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TFg5

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

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

2. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ((cpf)::text = '29006406104'::text)
3. 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)