explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oHgj

Settings
# exclusive inclusive rows x rows loops node
1. 127.831 10,976.759 ↑ 7,580,383.0 131,382 1

Nested Loop (cost=1.27..2,487,796.98 rows=995,925,883,096 width=701) (actual time=5.366..10,976.759 rows=131,382 loops=1)

2. 15.114 338.368 ↑ 18.3 131,382 1

Nested Loop (cost=0.70..23,437.80 rows=2,403,152 width=12) (actual time=4.574..338.368 rows=131,382 loops=1)

3. 6.652 6.652 ↑ 1.0 1 1

Seq Scan on ddn_variabilidade_evento113 dve (cost=0.00..303.40 rows=1 width=12) (actual time=3.063..6.652 rows=1 loops=1)

  • Filter: ((cd_cliente = 113) AND (cd_id_evento = 693,835))
  • Rows Removed by Filter: 9,776
4. 316.602 316.602 ↓ 1.9 131,382 1

Index Only Scan using ddn_variabilidade_evento_kijo_cd_cliente_cd_id_variabilida_key2 on ddn_variabilidade_evento_kijo113 dvek (cost=0.70..22,436.52 rows=69,788 width=20) (actual time=1.503..316.602 rows=131,382 loops=1)

  • Index Cond: ((cd_cliente = 113) AND (cd_id_variabilidade_evento = dve.cd_id))
  • Heap Fetches: 131,382
5. 10,510.560 10,510.560 ↑ 1.0 1 131,382

Index Scan using ddn_mapa_cliente113_cd_id_cd_cliente_key on ddn_mapa_cliente113 dm (cost=0.57..1.02 rows=1 width=701) (actual time=0.080..0.080 rows=1 loops=131,382)

  • Index Cond: ((cd_id = dvek.cd_id_ddn_mapa) AND (cd_cliente = 113))
Planning time : 29.211 ms
Execution time : 10,986.468 ms