explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9o48

Settings
# exclusive inclusive rows x rows loops node
1. 46.703 1,234.153 ↑ 37,119,439.5 36,524 1

Nested Loop (cost=1.27..6,857,641.82 rows=1,355,750,407,595 width=702) (actual time=1.623..1,234.153 rows=36,524 loops=1)

2. 3.740 237.826 ↑ 47.5 36,524 1

Nested Loop (cost=0.70..39,859.70 rows=1,733,291 width=12) (actual time=1.556..237.826 rows=36,524 loops=1)

3. 6.782 6.782 ↑ 1.0 1 1

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

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

Index Only Scan using ddn_variabilidade_evento_kij_cd_cliente_cd_id_variabilida_key52 on ddn_variabilidade_evento_kijo113 dvek (cost=0.70..38,757.11 rows=88,208 width=20) (actual time=0.482..227.304 rows=36,524 loops=1)

  • Index Cond: ((cd_cliente = 113) AND (cd_id_variabilidade_evento = dve.cd_id))
  • Heap Fetches: 0
5. 949.624 949.624 ↑ 1.0 1 36,524

Index Scan using ddn_mapa_cliente113_cd_id_cd_cliente_key on ddn_mapa_cliente113 dm (cost=0.57..3.92 rows=1 width=702) (actual time=0.026..0.026 rows=1 loops=36,524)

  • Index Cond: ((cd_id = dvek.cd_id_ddn_mapa) AND (cd_cliente = 113))
Planning time : 0.613 ms
Execution time : 1,236.689 ms