explain.depesz.com

PostgreSQL's explain analyze made readable

Result: huNq

Settings

Optimization(s) for this plan:

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

Update on metasporfazenda (cost=96,678.54..96,686.57 rows=1 width=443) (actual time=303.485..303.487 rows=0 loops=1)

2. 0.004 303.481 ↓ 0.0 0 1

Nested Loop (cost=96,678.54..96,686.57 rows=1 width=443) (actual time=303.479..303.481 rows=0 loops=1)

3. 0.006 303.477 ↓ 0.0 0 1

HashAggregate (cost=96,677.99..96,678.00 rows=1 width=55) (actual time=303.476..303.477 rows=0 loops=1)

  • Group Key: (m.cod_objeto)::text
4. 0.004 303.471 ↓ 0.0 0 1

Nested Loop (cost=0.00..96,677.99 rows=1 width=55) (actual time=303.469..303.471 rows=0 loops=1)

  • Join Filter: ((m.fazenda)::text = (aux.idfazenda)::text)
5. 0.004 303.467 ↓ 0.0 0 1

Nested Loop (cost=0.00..89,294.45 rows=1 width=81) (actual time=303.466..303.467 rows=0 loops=1)

  • Join Filter: ((m.meta)::text = (dm.cod_objeto)::text)
6. 303.463 303.463 ↓ 0.0 0 1

Seq Scan on metasporfazenda m (cost=0.00..89,289.84 rows=1 width=112) (actual time=303.461..303.463 rows=0 loops=1)

  • Filter: ((siglameta)::text = '1'::text)
  • Rows Removed by Filter: 88874
7. 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))
8. 0.000 0.000 ↓ 0.0 0

Seq Scan on auxcalculometas aux (cost=0.00..7,381.34 rows=176 width=38) (never executed)

  • Filter: ((contexto)::text = '1'::text)
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)