#	exclusive	inclusive	rows x	rows	loops	node
1.	4.035	3014.068	↑ 1.0	1	1	→ Aggregate (cost=69334.79..69334.80 rows=1 width=0) (actual time=3014.068..3014.068 rows=1 loops=1)
2.	358.908	3010.033	↓ 1.1	33659	1	→ GroupAggregate (cost=0.00..68938.43 rows=31708 width=32) (actual time=0.209..3010.033 rows=33659 loops=1)
3.	2651.125	2651.125	↑ 1.0	653113	1	→ Index Scan using idx_movimentacaoestoque_unidadenegocioid_embalagemid on movimentacaoestoque (cost=0.00..61931.68 rows=653113 width=32) (actual time=0.157..2651.125 rows=653113 loops=1)

"Aggregate  (cost=69334.79..69334.80 rows=1 width=0) (actual time=3014.068..3014.068 rows=1 loops=1)"
"  ->  GroupAggregate  (cost=0.00..68938.43 rows=31708 width=32) (actual time=0.209..3010.033 rows=33659 loops=1)"
"        ->  Index Scan using idx_movimentacaoestoque_unidadenegocioid_embalagemid on movimentacaoestoque  (cost=0.00..61931.68 rows=653113 width=32) (actual time=0.157..2651.125 rows=653113 loops=1)"
"Total runtime: 3014.164 ms"

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	4.035 ms	0.1 %
GroupAggregate	1	358.908 ms	11.9 %
Index Scan	1	2651.125 ms	88.0 %

Per table stats

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

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: iC4

Colorize:

Columns visibility:

Per node type stats

Per table stats