explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xCRe

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=208,943.42..237,481.50 rows=627,647 width=139) (actual rows= loops=)

  • Merge Cond: (cabsueldos.nropatronal = empleado.nropatronal)
  • Join Filter: (cabsueldos.anho = empleado.anho)
2. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=0.71..15,493.71 rows=39,546 width=105) (actual rows= loops=)

  • Merge Cond: (cabsueldos.nropatronal = empresas_sucursales.nro_patronal)
3. 0.000 0.000 ↓ 0.0

Index Scan using cabsueldos_nropatronal_anho_idx on cabsueldos (cost=0.42..9,375.00 rows=39,546 width=8) (actual rows= loops=)

  • Index Cond: (anho = 2018)
  • Filter: (confirmado = 1)
4. 0.000 0.000 ↓ 0.0

Index Scan using empresas_sucursales_nro_patronal_key on empresas_sucursales (cost=0.29..5,511.86 rows=58,978 width=97) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Materialize (cost=208,942.67..212,343.12 rows=680,089 width=42) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Sort (cost=208,942.67..210,642.89 rows=680,089 width=42) (actual rows= loops=)

  • Sort Key: empleado.nropatronal
7. 0.000 0.000 ↓ 0.0

Seq Scan on empleado (cost=0.00..128,112.81 rows=680,089 width=42) (actual rows= loops=)

  • Filter: (anho = 2018)