explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UQsG

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

Nested Loop (cost=0.70..451,585.05 rows=11,258,825 width=52) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on ddn_variabilidade_evento113 dve (cost=0.00..306.49 rows=1 width=12) (actual rows= loops=)

  • Filter: ((cd_cliente = 113) AND (cd_id_evento = 24,861,752))
3. 0.000 0.000 ↓ 0.0

Index Scan using ddn_variabilidade_evento_kij_cd_cliente_cd_id_variabilida_key52 on ddn_variabilidade_evento_kijo113 dvek (cost=0.70..448,790.42 rows=248,814 width=52) (actual rows= loops=)

  • Index Cond: ((cd_cliente = 113) AND (cd_id_variabilidade_evento = dve.cd_id))