#	exclusive	inclusive	rows x	rows	loops	node
1.	3.935	2931.475	↑ 1.0	1	1	→ Aggregate (cost=68511.60..68511.61 rows=1 width=0) (actual time=2931.475..2931.475 rows=1 loops=1)
2.	352.721	2927.540	↓ 1.0	33659	1	→ GroupAggregate (cost=0.00..68109.40 rows=32176 width=32) (actual time=0.143..2927.540 rows=33659 loops=1)
3.	2574.819	2574.819	↑ 1.0	653113	1	→ Index Scan using idx_movimentacaoestoque_unidadenegocioid_embalagemid on movimentacaoestoque (cost=0.00..61095.63 rows=653113 width=32) (actual time=0.109..2574.819 rows=653113 loops=1)

"Aggregate  (cost=68511.60..68511.61 rows=1 width=0) (actual time=2931.475..2931.475 rows=1 loops=1)"
"  ->  GroupAggregate  (cost=0.00..68109.40 rows=32176 width=32) (actual time=0.143..2927.540 rows=33659 loops=1)"
"        ->  Index Scan using idx_movimentacaoestoque_unidadenegocioid_embalagemid on movimentacaoestoque  (cost=0.00..61095.63 rows=653113 width=32) (actual time=0.109..2574.819 rows=653113 loops=1)"
"Total runtime: 2931.535 ms"

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	3.935 ms	0.1 %
GroupAggregate	1	352.721 ms	12.0 %
Index Scan	1	2574.819 ms	87.8 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
movimentacaoestoque	1	2574.819 ms	87.8 %
Index Scan	1	2574.819 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: tiE

Colorize:

Columns visibility:

Per node type stats

Per table stats