"Sort (cost=815671.03..815672.95 rows=767 width=320) (actual time=44452.152..44452.845 rows=2120 loops=1)"
" Sort Key: sutacc, jobday, mcode, serial, settime"
" -> Subquery Scan lp (cost=1051.69..815634.28 rows=767 width=320) (actual time=125.025..44433.888 rows=2120 loops=1)"
" Filter: (settime >= (subplan))"
" -> Unique (cost=1051.69..1137.98 rows=2301 width=424) (actual time=85.100..105.088 rows=4533 loops=1)"
" -> Sort (cost=1051.69..1057.44 rows=2301 width=424) (actual time=85.098..93.585 rows=4533 loops=1)"
" Sort Key: idx, settime, jobday, sutacc, ssutacc, jcode, mcode, serial, cc, price, instatus, commant, statusc, setuid"
" -> Append (cost=517.61..661.98 rows=2301 width=424) (actual time=42.414..65.807 rows=4533 loops=1)"
" -> Result (cost=517.61..603.82 rows=2299 width=424) (actual time=42.412..60.574 rows=4531 loops=1)"
" -> Unique (cost=517.61..603.82 rows=2299 width=424) (actual time=42.392..52.735 rows=4531 loops=1)"
" -> Sort (cost=517.61..523.36 rows=2299 width=424) (actual time=42.390..45.495 rows=4531 loops=1)"
" Sort Key: idx, settime, jobday, sutacc, ssutacc, jcode, mcode, serial, cc, price, instatus, commant, statusc, setuid"
" -> Append (cost=0.00..389.25 rows=2299 width=424) (actual time=0.179..22.901 rows=4531 loops=1)"
" -> Subquery Scan "*SELECT* 1" (cost=0.00..191.94 rows=71 width=83) (actual time=0.178..11.507 rows=2579 loops=1)"
" -> Seq Scan on t_in (cost=0.00..191.23 rows=71 width=83) (actual time=0.176..8.336 rows=2579 loops=1)"
" Filter: (((COALESCE(debenture_debt, \'\'::character varying))::text <> \'M\'::text) AND ((setmid)::text = \'metro\'::text) AND ((tno)::text = \'1\'::text) AND (jobday <= \'2006-12-04\'::date) AND (((CASE (..)"
" -> Subquery Scan "*SELECT* 2" (cost=0.00..137.52 rows=2224 width=297) (actual time=0.081..7.733 rows=1947 loops=1)"
" -> Seq Scan on t_out ssel (cost=0.00..115.28 rows=2224 width=297) (actual time=0.078..5.528 rows=1947 loops=1)"
" Filter: (((setmid)::text = \'metro\'::text) AND ((tno)::text = \'1\'::text) AND (jobday <= \'2006-12-04\'::date) AND (((status)::text = \'1\'::text) OR ((status)::text = \'2\'::text) OR ((status)::text = (..)"
" -> Subquery Scan "*SELECT* 3" (cost=0.00..14.89 rows=1 width=384) (actual time=0.015..0.034 rows=5 loops=1)"
" -> Seq Scan on t_bi ssel (cost=0.00..14.88 rows=1 width=384) (actual time=0.013..0.026 rows=5 loops=1)"
" Filter: (((setmid)::text = \'metro\'::text) AND ((tno)::text = \'1\'::text) AND (jobday <= \'2006-12-04\'::date) AND (((status)::text = \'1\'::text) OR ((status)::text = \'2\'::text) OR ((status)::text = (..)"
" -> Subquery Scan "*SELECT* 4" (cost=0.00..14.89 rows=1 width=424) (actual time=0.017..0.017 rows=0 loops=1)"
" -> Seq Scan on t_bp ssel (cost=0.00..14.88 rows=1 width=424) (actual time=0.016..0.016 rows=0 loops=1)"
" Filter: (((setmid)::text = \'metro\'::text) AND ((tno)::text = \'1\'::text) AND (jobday <= \'2006-12-04\'::date) AND (((status)::text = \'1\'::text) OR ((status)::text = \'2\'::text) OR ((status)::text = (..)"
" -> Subquery Scan "*SELECT* 5" (cost=0.00..15.14 rows=1 width=83) (actual time=0.575..0.575 rows=0 loops=1)"
" -> Seq Scan on t_gp ssel (cost=0.00..15.13 rows=1 width=83) (actual time=0.574..0.574 rows=0 loops=1)"
" Filter: (((setmid)::text = \'metro\'::text) AND ((tno)::text = \'1\'::text) AND (jobday <= \'2006-12-04\'::date) AND (((status)::text = \'1\'::text) OR ((status)::text = \'2\'::text) OR ((status)::text = (..)"
" -> Subquery Scan "*SELECT* 6" (cost=0.00..14.89 rows=1 width=424) (actual time=0.120..0.120 rows=0 loops=1)"
" -> Seq Scan on t_gong ssel (cost=0.00..14.88 rows=1 width=424) (actual time=0.119..0.119 rows=0 loops=1)"
" Filter: (((setmid)::text = \'metro\'::text) AND ((tno)::text = \'1\'::text) AND (jobday <= \'2006-12-04\'::date) AND (((status)::text = \'1\'::text) OR ((status)::text = \'2\'::text) OR ((status)::text = (..)"
" -> Subquery Scan "*SELECT* 7" (cost=0.00..58.16 rows=2 width=90) (actual time=1.653..2.390 rows=2 loops=1)"
" -> Seq Scan on t_sale ssel (cost=0.00..58.14 rows=2 width=90) (actual time=1.648..2.384 rows=2 loops=1)"
" Filter: (((setmid)::text = \'metro\'::text) AND ((tno)::text = \'1\'::text) AND (saledate <= \'2006-12-04\'::date) AND (((status)::text = \'1\'::text) OR ((status)::text = \'2\'::text) OR ((status)::text = \'3\'::text) OR ((status (..)"
" SubPlan"
" -> Aggregate (cost=353.95..353.96 rows=1 width=8) (actual time=9.771..9.771 rows=1 loops=4533)"
" -> Unique (cost=353.74..353.86 rows=7 width=134) (actual time=9.761..9.765 rows=2 loops=4533)"
" -> Sort (cost=353.74..353.75 rows=7 width=134) (actual time=9.758..9.759 rows=2 loops=4533)"
" Sort Key: settime, jcode, mcode, serial, setmid, tno"
" -> Append (cost=0.00..353.64 rows=7 width=134) (actual time=1.879..9.741 rows=2 loops=4533)"
" -> Seq Scan on t_in (cost=0.00..136.58 rows=1 width=45) (actual time=1.873..4.270 rows=1 loops=4533)"
" Filter: ((jobday <= \'2006-12-04\'::date) AND ((setmid)::text = \'metro\'::text) AND ((tno)::text = \'1\'::text) AND (($0)::text = (mcode)::text) AND (($1)::text = (serial)::text) AND ((setmid)::text = \'metro\'::text) AND ( (..)"
" -> Seq Scan on t_out (cost=0.00..104.16 rows=1 width=45) (actual time=1.702..3.171 rows=1 loops=4533)"
" Filter: ((jobday <= \'2006-12-04\'::date) AND ((setmid)::text = \'metro\'::text) AND ((tno)::text = \'1\'::text) AND (($0)::text = (mcode)::text) AND (($1)::text = (serial)::text) AND ((setmid)::text = \'metro\'::text) AND ( (..)"
" -> Seq Scan on t_bi (cost=0.00..14.13 rows=1 width=134) (actual time=0.009..0.009 rows=0 loops=4533)"
" Filter: ((jobday <= \'2006-12-04\'::date) AND ((setmid)::text = \'metro\'::text) AND ((tno)::text = \'1\'::text) AND (($0)::text = (mcode)::text) AND (($1)::text = (serial)::text) AND ((setmid)::text = \'metro\'::text) AND ( (..)"
" -> Seq Scan on t_bp (cost=0.00..14.13 rows=1 width=134) (actual time=0.005..0.005 rows=0 loops=4533)"
" Filter: ((jobday <= \'2006-12-04\'::date) AND ((setmid)::text = \'metro\'::text) AND ((tno)::text = \'1\'::text) AND (($0)::text = (mcode)::text) AND (($1)::text = (serial)::text) AND ((setmid)::text = \'metro\'::text) AND ( (..)"
" -> Seq Scan on t_gp (cost=0.00..14.49 rows=1 width=45) (actual time=0.437..0.439 rows=0 loops=4533)"
" Filter: ((jobday <= \'2006-12-04\'::date) AND ((setmid)::text = \'metro\'::text) AND ((tno)::text = \'1\'::text) AND (($0)::text = (mcode)::text) AND (($1)::text = (serial)::text) AND ((setmid)::text = \'metro\'::text) AND ( (..)"
" -> Seq Scan on t_gong (cost=0.00..14.13 rows=1 width=134) (actual time=0.104..0.104 rows=0 loops=4533)"
" Filter: ((jobday <= \'2006-12-04\'::date) AND ((setmid)::text = \'metro\'::text) AND ((tno)::text = \'1\'::text) AND (($0)::text = (mcode)::text) AND (($1)::text = (serial)::text) AND ((setmid)::text = \'metro\'::text) AND ( (..)"
" -> Seq Scan on t_sale (cost=0.00..55.96 rows=1 width=43) (actual time=1.605..1.704 rows=0 loops=4533)"
" Filter: ((saledate <= \'2006-12-04\'::date) AND ((setmid)::text = \'metro\'::text) AND ((tno)::text = \'1\'::text) AND (($0)::text = (mcode)::text) AND (($1)::text = (serial)::text) AND ((setmid)::text = \'metro\'::text) AND (..)"
"Total runtime: 44455.151 ms"
이렇게 나오던데,
잘좀 해결됐음 좋겠습니다.
딴쪽은 문제 없는데, 재고쪽이 문제가 되어서 곤혹스럽습니다.
|