explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ggR8

Settings
# exclusive inclusive rows x rows loops node
1. 1,596.867 165,098.894 ↓ 1.9 188,010 1

GroupAggregate (cost=0.56..708,702.58 rows=99,630 width=24) (actual time=0.040..165,098.894 rows=188,010 loops=1)

  • Group Key: embalagemid, unidadenegocioid
2. 163,502.027 163,502.027 ↓ 1.0 14,573,998 1

Index Only Scan using cidx_itemvenda_embalagemid_unidadenegocioid_datahora on itemvenda (cost=0.56..598,414.39 rows=14,572,251 width=24) (actual time=0.008..163,502.027 rows=14,573,998 loops=1)

  • Heap Fetches: 40,589
Planning time : 0.141 ms
Execution time : 165,108.282 ms