explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UYZP

Settings
# exclusive inclusive rows x rows loops node
1. 7.083 47.928 ↑ 47.5 36,524 1

Nested Loop (cost=0.70..190,979.70 rows=1,733,291 width=52) (actual time=0.169..47.928 rows=36,524 loops=1)

2. 1.148 1.148 ↑ 1.0 1 1

Seq Scan on ddn_variabilidade_evento113 dve (cost=0.00..220.51 rows=1 width=12) (actual time=0.148..1.148 rows=1 loops=1)

  • Filter: ((cd_cliente = 113) AND (cd_id_evento = 38,923,022))
  • Rows Removed by Filter: 5,138
3. 39.697 39.697 ↑ 2.4 36,524 1

Index Scan using ddn_variabilidade_evento_kij_cd_cliente_cd_id_variabilida_key52 on ddn_variabilidade_evento_kijo113 dvek (cost=0.70..189,877.11 rows=88,208 width=52) (actual time=0.019..39.697 rows=36,524 loops=1)

  • Index Cond: ((cd_cliente = 113) AND (cd_id_variabilidade_evento = dve.cd_id))
Planning time : 0.312 ms
Execution time : 49.395 ms