explain.depesz.com

A tool for finding a real cause for slow queries.

Result: TDj : su

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

GroupAggregate (cost=0.000..226,426.480 rows=21,447 width=18) (actual time=5.997..2,876.505 rows=183,948 loops=1)

  • Output: lotout, sum(CASE ((tipdoc)::text ~~ 'pro%'::text) WHEN CASE_TEST_EXPR THEN 0::double precision ELSE (cantout)::double precision END), sum(CASE (((tipdoc)::text = 'tvliv'::text) AND ((nrdocsec)::text <> 'validat'::text)) WHEN CASE_TEST_EXPR THEN (cantout)::double precision ELSE 0::double precision END), sum(CASE ((tipdoc)::text ~~ 'pro%'::text) WHEN CASE_TEST_EXPR THEN (cantout)::double precision ELSE 0::double precision END)
2. 1,144.037 1,144.037 ↓ 1.0 1,501,045 1

Index Scan using alpha on yankee (cost=0.000..184,937.180 rows=1,500,903 width=18) (actual time=5.617..1,144.037 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