explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0csR

Settings
# exclusive inclusive rows x rows loops node
1. 1,902.456 4,259.818 ↓ 0.0 0 1

Insert on dados_gerais_cas_tmp (cost=0.86..508,750.75 rows=44,660 width=687) (actual time=4,259.818..4,259.818 rows=0 loops=1)

2. 242.708 2,357.362 ↓ 4.8 213,749 1

Nested Loop Left Join (cost=0.86..508,750.75 rows=44,660 width=687) (actual time=0.090..2,357.362 rows=213,749 loops=1)

3. 334.991 1,259.658 ↓ 4.8 213,749 1

Nested Loop Left Join (cost=0.43..288,204.20 rows=44,660 width=605) (actual time=0.061..1,259.658 rows=213,749 loops=1)

4. 69.671 69.671 ↓ 4.8 213,749 1

Seq Scan on dados_gerais_tmp dg (cost=0.00..3,636.60 rows=44,660 width=546) (actual time=0.033..69.671 rows=213,749 loops=1)

5. 854.996 854.996 ↑ 1.0 1 213,749

Index Scan using ca_contratos_ak1 on ca_contratos cac (cost=0.43..6.36 rows=1 width=63) (actual time=0.004..0.004 rows=1 loops=213,749)

  • Index Cond: (cod_pai = dg.cod_contrato)
6. 854.996 854.996 ↑ 1.0 1 213,749

Index Scan using ca_clientes_ak1 on ca_clientes cacli (cost=0.43..4.92 rows=1 width=86) (actual time=0.003..0.004 rows=1 loops=213,749)

  • Index Cond: (cod_pai = dg.cod_cliente)