explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ULtN : Optimization for: plan #ZuKA

Settings

Optimization path:

Optimization(s) for this plan:

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

GroupAggregate (cost=7.34..7.36 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=1)

  • Group Key: stato_conserv_documento
2. 0.007 0.013 ↓ 0.0 0 1

Sort (cost=7.34..7.34 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=1)

  • Sort Key: stato_conserv_documento
  • Sort Method: quicksort Memory: 25kB
3. 0.006 0.006 ↓ 0.0 0 1

Index Scan using conserv_documento_ipa_id_idx on conserv_documento conservazi0_ (cost=0.27..7.33 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (ipa_id = 0)
  • Filter: ((NOT deleted) AND ((deleted_edk IS NULL) OR (NOT deleted_edk)) AND (NOT expired) AND ((stato_conserv_documento)::text <> 'CANCELLATO'::text) AND (esercizio = 2017) AND ((tipo_documento)::text = 'FLUSSO_OPI'::text) AND ((tipo_aggregazione)::text = 'ENTE'::text))
Planning time : 0.389 ms
Execution time : 0.039 ms