#	exclusive	inclusive	rows x	rows	loops	node
1.	745.594	1668.610	↓ 8.6	183948	1	→ GroupAggregate (cost=0.00..192656.16 rows=21447 width=8) (actual time=0.119..1668.610 rows=183948 loops=1) Output: lotout, sum(cantout)
2.	923.016	923.016	↓ 1.0	1501045	1	→ Index Scan using idxdocoutlotout on public.docout (cost=0.00..184937.18 rows=1500903 width=8) (actual time=0.022..923.016 rows=1501045 loops=1) Output: idout, lotout, comandaout, valid, partener, datdoc, tipdoc, nrdoc, nrdocsec, cantout, pret, pretdef, moneda, curs, infoiesiri, lotprod, rabat, gesttransfer, stornoid, userid, datemodified, trlocdest, pickid, nrpicking, datapicking, cantpick, grnet_out Filter: docout.valid

"GroupAggregate  (cost=0.00..192656.16 rows=21447 width=8) (actual time=0.119..1668.610 rows=183948 loops=1)"
"  Output: lotout, sum(cantout)"
"  ->  Index Scan using idxdocoutlotout on public.docout  (cost=0.00..184937.18 rows=1500903 width=8) (actual time=0.022..923.016 rows=1501045 loops=1)"
"        Output: idout, lotout, comandaout, valid, partener, datdoc, tipdoc, nrdoc, nrdocsec, cantout, pret, pretdef, moneda, curs, infoiesiri, lotprod, rabat, gesttransfer, stornoid, userid, datemodified, trlocdest, pickid, nrpicking, datapicking, cantpick, grnet_out"
"        Filter: docout.valid"
"Total runtime: 1681.900 ms"

Per node type stats

node type	count	sum of times	% of query
GroupAggregate	1	745.594 ms	44.7 %
Index Scan	1	923.016 ms	55.3 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
public.docout	1	923.016 ms	55.3 %
Index Scan	1	923.016 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: fEs

Colorize:

Columns visibility:

Per node type stats

Per table stats