explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jsKd

Settings
# exclusive inclusive rows x rows loops node
1. 0.273 9.958 ↑ 21.7 7 1

GroupAggregate (cost=0.57..1,854.85 rows=152 width=45) (actual time=6.265..9.958 rows=7 loops=1)

  • Group Key: ano, mes, idproduto
2. 9.685 9.685 ↓ 1.3 205 1

Index Scan using saldo_filiais_index05 on saldo_filiais sf (cost=0.57..1,851.43 rows=152 width=16) (actual time=5.626..9.685 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.410 ms
Execution time : 10.000 ms