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 1,610.348 ↑ 1.0 1 1

Aggregate (cost=121,769.29..121,769.30 rows=1 width=0) (actual time=1,610.348..1,610.348 rows=1 loops=1)

2. 203.401 1,608.211 ↓ 1.0 33,659 1

GroupAggregate (cost=112,721.96..121,367.73 rows=32,124 width=32) (actual time=1,215.700..1,608.211 rows=33,659 loops=1)

3. 1,244.591 1,404.810 ↑ 1.0 653,113 1

Sort (cost=112,721.96..114,354.74 rows=653,113 width=32) (actual time=1,215.678..1,404.810 rows=653,113 loops=1)

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

Seq Scan on movimentacaoestoque (cost=0.00..18,386.13 rows=653,113 width=32) (actual time=0.151..160.219 rows=653,113 loops=1)