explain.depesz.com

PostgreSQL's explain analyze made readable

Result: guPs

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

Hash Join (cost=11,684.97..237,387.00 rows=619,619 width=139) (actual rows= loops=)

  • Hash Cond: (empleado.nropatronal = cabsueldos.nropatronal)
2. 0.000 0.000 ↓ 0.0

Seq Scan on empleado (cost=0.00..136,421.21 rows=671,391 width=42) (actual rows= loops=)

  • Filter: (((documento)::text <> '0'::text) AND (anho = 2018))
3. 0.000 0.000 ↓ 0.0

Hash (cost=11,190.64..11,190.64 rows=39,546 width=105) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=3,478.05..11,190.64 rows=39,546 width=105) (actual rows= loops=)

  • Hash Cond: (cabsueldos.nropatronal = empresas_sucursales.nro_patronal)
5. 0.000 0.000 ↓ 0.0

Seq Scan on cabsueldos (cost=0.00..6,872.24 rows=39,546 width=8) (actual rows= loops=)

  • Filter: ((anho = 2018) AND (confirmado = 1))
6. 0.000 0.000 ↓ 0.0

Hash (cost=2,740.80..2,740.80 rows=58,980 width=97) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on empresas_sucursales (cost=0.00..2,740.80 rows=58,980 width=97) (actual rows= loops=)