explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U49f : Optimization for: plan #Az1E

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.043 0.303 ↑ 25.7 7 1

GroupAggregate (cost=690.83..695.33 rows=180 width=45) (actual time=0.251..0.303 rows=7 loops=1)

  • Group Key: ano, mes, idproduto
2. 0.044 0.260 ↓ 1.0 181 1

Sort (cost=690.83..691.28 rows=180 width=16) (actual time=0.246..0.260 rows=181 loops=1)

  • Sort Key: ano, mes
  • Sort Method: quicksort Memory: 39kB
3. 0.216 0.216 ↓ 1.0 181 1

Index Scan using saldo_filiais_index07 on saldo_filiais sf (cost=0.58..684.09 rows=180 width=16) (actual time=0.036..0.216 rows=181 loops=1)

  • Index Cond: ((filial = 1) AND ((idproduto)::text = '80691'::text) AND (data >= (('now'::cstring)::date - 180)) AND (data <= ('now'::cstring)::date))
Planning time : 0.287 ms
Execution time : 0.332 ms