explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C4uU

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.289 10.206 ↑ 20.9 7 1

GroupAggregate (cost=0.57..1,790.08 rows=146 width=45) (actual time=6.336..10.206 rows=7 loops=1)

  • Group Key: ano, mes, idproduto
2. 9.917 9.917 ↓ 1.4 205 1

Index Scan using saldo_filiais_index05 on saldo_filiais sf (cost=0.57..1,786.79 rows=146 width=16) (actual time=5.665..9.917 rows=205 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.458 ms
Execution time : 10.252 ms