explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZG3F

Settings
# exclusive inclusive rows x rows loops node
1. 1.534 17.376 ↑ 1.0 1,000 1

Limit (cost=15.42..432.65 rows=1,000 width=92) (actual time=1.243..17.376 rows=1,000 loops=1)

2. 1.695 15.842 ↑ 608.2 1,000 1

Merge Join (cost=15.42..253,783.98 rows=608,217 width=92) (actual time=1.241..15.842 rows=1,000 loops=1)

  • Merge Cond: (cabsueldos.nropatronal = empleado.nropatronal)
3. 0.121 0.968 ↑ 1,653.7 23 1

Merge Left Join (cost=0.71..15,424.22 rows=38,036 width=58) (actual time=0.223..0.968 rows=23 loops=1)

  • Merge Cond: (cabsueldos.nropatronal = empresas_sucursales.nro_patronal)
4. 0.128 0.128 ↑ 1,653.7 23 1

Index Scan using cabsueldos_nropatronal_anho_idx on cabsueldos (cost=0.42..9,353.87 rows=38,036 width=8) (actual time=0.022..0.128 rows=23 loops=1)

  • Index Cond: (anho = 2018)
  • Filter: (confirmado = 1)
  • Rows Removed by Filter: 1
5. 0.719 0.719 ↑ 1,552.8 38 1

Index Scan using empresas_sucursales_nro_patronal_key on empresas_sucursales (cost=0.29..5,511.93 rows=59,005 width=54) (actual time=0.044..0.719 rows=38 loops=1)

6. 13.179 13.179 ↑ 683.2 1,000 1

Index Scan using empleado_nropatronal_documento_anho_idx on empleado (cost=0.43..230,493.62 rows=683,223 width=42) (actual time=1.011..13.179 rows=1,000 loops=1)

  • Index Cond: (anho = 2018)