explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eCDm

Settings
# exclusive inclusive rows x rows loops node
1. 68.441 733.760 ↑ 23.0 490,607 1

Nested Loop (cost=0.70..451,701.76 rows=11,261,692 width=52) (actual time=2.550..733.760 rows=490,607 loops=1)

2. 2.074 2.074 ↑ 1.0 1 1

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

  • Filter: ((cd_cliente = 113) AND (cd_id_evento = 24,861,752))
  • Rows Removed by Filter: 11,894
3. 663.245 663.245 ↓ 2.0 490,607 1

Index Scan using ddn_variabilidade_evento_kij_cd_cliente_cd_id_variabilida_key52 on ddn_variabilidade_evento_kijo113 dvek (cost=0.70..448,906.50 rows=248,877 width=52) (actual time=0.508..663.245 rows=490,607 loops=1)

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