explain.depesz.com

A tool for finding a real cause for slow queries.

Result: teMO

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 748.606 1669.840 ↓ 8.6 183948 1

GroupAggregate (cost=0.000..192659.000 rows=21447 width=8) (actual time=0.111..1669.840 rows=183948 loops=1)

  • Output: lotout, sum(cantout)
2. 921.234 921.234 ↑ 1.0 1501045 1

Index Scan using alpha on yankee (cost=0.000..184939.310 rows=1501045 width=8) (actual time=0.018..921.234 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: papa.xray