explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Az1E

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.324 10.904 ↑ 21.3 7 1

GroupAggregate (cost=0.57..1,824.44 rows=149 width=45) (actual time=6.509..10.904 rows=7 loops=1)

  • Group Key: ano, mes, idproduto
2. 10.580 10.580 ↓ 1.4 206 1

Index Scan using saldo_filiais_index05 on saldo_filiais sf (cost=0.57..1,821.08 rows=149 width=16) (actual time=5.720..10.580 rows=206 loops=1)

  • Index Cond: ((filial = 1) AND ((idproduto)::text = '80691'::text))
  • Filter: ((data <= ('now'::cstring)::date) AND (data >= first_day((('now'::cstring)::date - 180))))
  • Rows Removed by Filter: 243
Planning time : 0.506 ms
Execution time : 10.955 ms