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. 1732.468 2876.505 ↓ 8.6 183948 1

GroupAggregate (cost=0.000..226426.480 rows=21447 width=18) (actual time=5.997..2876.505 rows=183948 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. 1144.037 1144.037 ↓ 1.0 1501045 1

Index Scan using alpha on yankee (cost=0.000..184937.180 rows=1500903 width=18) (actual time=5.617..1144.037 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