explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sUmA : Optimization for: plan #huNq

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.006 42.613 ↓ 0.0 0 1

Update on metasporfazenda (cost=8,149.46..8,157.49 rows=1 width=443) (actual time=42.611..42.613 rows=0 loops=1)

2. 0.004 42.607 ↓ 0.0 0 1

Nested Loop (cost=8,149.46..8,157.49 rows=1 width=443) (actual time=42.605..42.607 rows=0 loops=1)

3. 0.005 42.603 ↓ 0.0 0 1

HashAggregate (cost=8,148.92..8,148.93 rows=1 width=55) (actual time=42.602..42.603 rows=0 loops=1)

  • Group Key: (m.cod_objeto)::text
4. 0.003 42.598 ↓ 0.0 0 1

Nested Loop (cost=0.42..8,148.92 rows=1 width=55) (actual time=42.596..42.598 rows=0 loops=1)

  • Join Filter: ((m.meta)::text = (dm.cod_objeto)::text)
5. 0.006 42.595 ↓ 0.0 0 1

Nested Loop (cost=0.42..8,144.30 rows=1 width=86) (actual time=42.593..42.595 rows=0 loops=1)

6. 42.589 42.589 ↓ 0.0 0 1

Seq Scan on auxcalculometas aux (cost=0.00..6,796.09 rows=162 width=38) (actual time=42.588..42.589 rows=0 loops=1)

  • Filter: ((contexto)::text = '1'::text)
  • Rows Removed by Filter: 271503
7. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_sigla_fazenda on metasporfazenda m (cost=0.42..8.31 rows=1 width=112) (never executed)

  • Index Cond: (((fazenda)::text = (aux.idfazenda)::text) AND ((siglameta)::text = '1'::text))
8. 0.000 0.000 ↓ 0.0 0

Seq Scan on dominiometas dm (cost=0.00..4.48 rows=11 width=43) (never executed)

  • Filter: ((fctnome IS NOT NULL) AND (length(ltrim(rtrim((fctnome)::text))) > 0))
9. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_metasporfazenda on metasporfazenda (cost=0.54..8.56 rows=1 width=405) (never executed)

  • Index Cond: ((cod_objeto)::text = (m.cod_objeto)::text)