#	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)

"Aggregate  (cost=121769.29..121769.30 rows=1 width=0) (actual time=1610.348..1610.348 rows=1 loops=1)"
"  ->  GroupAggregate  (cost=112721.96..121367.73 rows=32124 width=32) (actual time=1215.700..1608.211 rows=33659 loops=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"
"              ->  Seq Scan on movimentacaoestoque  (cost=0.00..18386.13 rows=653113 width=32) (actual time=0.151..160.219 rows=653113 loops=1)"
"Total runtime: 1616.649 ms"

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	2.137 ms	0.1 %
GroupAggregate	1	203.401 ms	12.6 %
Seq Scan	1	160.219 ms	9.9 %
Sort	1	1244.591 ms	77.3 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
movimentacaoestoque	1	160.219 ms	9.9 %
Seq Scan	1	160.219 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: QbU

Colorize:

Columns visibility:

Per node type stats

Per table stats