explain.depesz.com

A tool for finding a real cause for slow queries.

Result: fEs

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 745.594 1,668.610 ↓ 8.6 183,948 1

GroupAggregate (cost=0.00..192,656.16 rows=21,447 width=8) (actual time=0.119..1,668.610 rows=183,948 loops=1)

  • Output: lotout, sum(cantout)
2. 923.016 923.016 ↓ 1.0 1,501,045 1

Index Scan using idxdocoutlotout on public.docout (cost=0.00..184,937.18 rows=1,500,903 width=8) (actual time=0.022..923.016 rows=1,501,045 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