explain.depesz.com

A tool for finding a real cause for slow queries.

Result: QbU

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 2.137 1610.348 ↑ 1.0 1 1

Aggregate (cost=121769.29..121769.30 rows=1 width=0) (actual time=1610.348..1610.348 rows=1 loops=1)

2. 203.401 1608.211 ↓ 1.0 33659 1

GroupAggregate (cost=112721.96..121367.73 rows=32124 width=32) (actual time=1215.700..1608.211 rows=33659 loops=1)

3. 1244.591 1404.810 ↑ 1.0 653113 1

Sort (cost=112721.96..114354.74 rows=653113 width=32) (actual time=1215.678..1404.810 rows=653113 loops=1)

  • Sort Key: movimentacaoestoque.unidadenegocioid, movimentacaoestoque.embalagemid
  • Sort Method: external merge Disk: 26792kB
4. 160.219 160.219 ↑ 1.0 653113 1

Seq Scan on movimentacaoestoque (cost=0.00..18386.13 rows=653113 width=32) (actual time=0.151..160.219 rows=653113 loops=1)