"Sort (cost=1161.97..1161.98 rows=1 width=83) (actual time=6458.955..6459.166 rows=458 loops=1)" " Sort Key: to_char((coitem.coitem_scheddate)::timestamp with time zone, 'Month Dy DD YYYY'::text), cohead.cohead_number, coitem.coitem_linenumber" " -> Nested Loop Left Join (cost=0.00..1161.96 rows=1 width=83) (actual time=14.638..6453.589 rows=458 loops=1)" " -> Nested Loop (cost=0.00..191.54 rows=1 width=75) (actual time=0.121..31.942 rows=458 loops=1)" " -> Nested Loop (cost=0.00..191.22 rows=1 width=44) (actual time=0.111..24.863 rows=458 loops=1)" " -> Nested Loop (cost=0.00..182.94 rows=1 width=40) (actual time=0.102..18.215 rows=458 loops=1)" " -> Nested Loop (cost=0.00..182.53 rows=1 width=30) (actual time=0.091..11.299 rows=458 loops=1)" " -> Index Scan using coitem_status_key on coitem (cost=0.00..174.25 rows=1 width=30) (actual time=0.077..2.314 rows=458 loops=1)" " Index Cond: (coitem_status = 'O'::bpchar)" " Filter: ((coitem_scheddate >= '2008-01-01'::date) AND (coitem_scheddate <= '2008-12-31'::date))" " -> Index Scan using itemsite_pkey on itemsite (cost=0.00..8.27 rows=1 width=8) (actual time=0.012..0.014 rows=1 loops=458)" " Index Cond: (coitem.coitem_itemsite_id = itemsite.itemsite_id)" " -> Index Scan using item_pkey on item (cost=0.00..0.40 rows=1 width=18) (actual time=0.008..0.010 rows=1 loops=458)" " Index Cond: (itemsite.itemsite_item_id = item.item_id)" " -> Index Scan using cohead_pkey on cohead (cost=0.00..8.27 rows=1 width=12) (actual time=0.008..0.010 rows=1 loops=458)" " Index Cond: (cohead.cohead_id = coitem.coitem_cohead_id)" " -> Index Scan using cust_pkey on custinfo (cost=0.00..0.31 rows=1 width=39) (actual time=0.007..0.010 rows=1 loops=458)" " Index Cond: (cohead.cohead_cust_id = custinfo.cust_id)" " -> Index Scan using wo_pkey on wo (cost=0.00..8.27 rows=1 width=12) (actual time=0.007..0.011 rows=1 loops=458)" " Index Cond: (wo.wo_id = coitem.coitem_order_id)" " SubPlan" " -> Limit (cost=962.12..962.12 rows=1 width=36) (actual time=13.977..13.978 rows=1 loops=458)" " -> Sort (cost=962.12..962.12 rows=1 width=36) (actual time=13.970..13.970 rows=1 loops=458)" " Sort Key: wooper.wooper_seqnumber" " -> Nested Loop (cost=0.00..962.11 rows=1 width=36) (actual time=13.515..13.951 rows=1 loops=458)" " Join Filter: (wrkcnt.wrkcnt_id = wooper.wooper_wrkcnt_id)" " -> Seq Scan on wooper (cost=0.00..958.41 rows=1 width=8) (actual time=13.469..13.838 rows=1 loops=458)" " Filter: (wooper_rncomplete AND (wooper_wo_id = $0))" " -> Seq Scan on wrkcnt (cost=0.00..2.75 rows=75 width=36) (actual time=0.008..0.049 rows=75 loops=419)" "Total runtime: 6460.009 ms"