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 1,669.840 ↓ 8.6 183,948 1

GroupAggregate (cost=0.000..192,659.000 rows=21,447 width=8) (actual time=0.111..1,669.840 rows=183,948 loops=1)

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

Index Scan using alpha on yankee (cost=0.000..184,939.310 rows=1,501,045 width=8) (actual time=0.018..921.234 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: papa.xray