| Limit (cost=3926.47..3926.52 rows=20 width=197) |
| -> Sort (cost=3926.47..3971.65 rows=18074 width=197) |
| Sort Key: (CASE WHEN ((sub.verify_status = 0) OR (sub.stop_verify_status = 0) OR (sub.cancel_verify_status = 0)) THEN 1 WHEN (sub.self_verify_at IS NOT NULL) THEN 2 ELSE 3 END), (CASE WHEN ((sub.verify_status = 0) OR (sub.stop_verify_status = 0) OR (sub.cancel_verify_status = 0)) THEN sub.created_at ELSE NULL::timestamp with time zone END) DESC NULLS LAST, sub.self_verify_at DESC NULLS LAST, sub.last_verify_at DESC NULLS LAST, sub.created_at DESC |
| -> Result (cost=26.46..3445.52 rows=18074 width=197) |
| -> Append (cost=26.46..2993.67 rows=18074 width=185) |
| -> Subquery Scan on sub (cost=26.46..37.48 rows=210 width=182) |
| -> HashAggregate (cost=26.46..35.38 rows=210 width=190) |
| Group Key: r.id, rvr.status, rsvr.status |
| -> Hash Left Join (cost=13.52..22.78 rows=210 width=123) |
| Hash Cond: (r.id = rsvr.erp_purchase_inbound_id) |
| -> Hash Left Join (cost=12.46..20.92 rows=210 width=111) |
| Hash Cond: (r.id = rvr.erp_purchase_inbound_id) |
| -> Seq Scan on tbl_erp_purchase_inbounds r (cost=0.00..7.66 rows=210 width=99) |
| Filter: (status <> 0) |
| -> Hash (cost=12.45..12.45 rows=1 width=16) |
| -> Seq Scan on tbl_erp_purchase_inbound_verify_rels rvr (cost=0.00..12.45 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.05..1.05 rows=1 width=16) |
| -> Seq Scan on tbl_erp_purchase_inbound_stop_verify_rels rsvr (cost=0.00..1.05 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 2" (cost=155.93..289.07 rows=2219 width=213) |
| -> HashAggregate (cost=155.93..266.88 rows=2219 width=225) |
| Group Key: r_1.id, rvr_1.status, rsvr_1.status, rcvr.status |
| -> Hash Left Join (cost=7.69..100.46 rows=2219 width=170) |
| Hash Cond: (r_1.id = rcvr.erp_purchase_order_id) |
| -> Hash Left Join (cost=6.60..91.04 rows=2219 width=158) |
| Hash Cond: (r_1.id = rsvr_1.erp_purchase_order_id) |
| -> Hash Left Join (cost=5.34..81.44 rows=2219 width=146) |
| Hash Cond: (r_1.id = rvr_1.erp_purchase_order_id) |
| -> Seq Scan on tbl_erp_purchase_orders r_1 (cost=0.00..67.78 rows=2219 width=134) |
| Filter: (status <> 0) |
| -> Hash (cost=5.33..5.33 rows=1 width=16) |
| -> Seq Scan on tbl_erp_purchase_order_verify_rels rvr_1 (cost=0.00..5.33 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.25..1.25 rows=1 width=16) |
| -> Seq Scan on tbl_erp_purchase_order_stop_verify_rels rsvr_1 (cost=0.00..1.25 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.07..1.07 rows=1 width=16) |
| -> Seq Scan on tbl_erp_purchase_order_cancel_verify_rels rcvr (cost=0.00..1.07 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 3" (cost=24.61..25.04 rows=6 width=246) |
| -> GroupAggregate (cost=24.61..24.98 rows=6 width=254) |
| Group Key: r_2.id, rvr_2.status, rsvr_2.status |
| -> Sort (cost=24.61..24.62 rows=6 width=179) |
| Sort Key: r_2.id, rvr_2.status, rsvr_2.status |
| -> Nested Loop Left Join (cost=1.15..24.53 rows=6 width=179) |
| Join Filter: (rvr_2.erp_purchase_return_id = r_2.id) |
| -> Hash Right Join (cost=1.15..23.29 rows=6 width=167) |
| Hash Cond: (rsvr_2.erp_purchase_return_id = r_2.id) |
| -> Seq Scan on tbl_erp_purchase_return_stop_verify_rels rsvr_2 (cost=0.00..22.12 rows=5 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.07..1.07 rows=6 width=155) |
| -> Seq Scan on tbl_erp_purchase_returns r_2 (cost=0.00..1.07 rows=6 width=155) |
| Filter: (status <> 0) |
| -> Materialize (cost=0.00..1.15 rows=1 width=16) |
| -> Seq Scan on tbl_erp_purchase_return_verify_rels rvr_2 (cost=0.00..1.15 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 4" (cost=3.58..4.00 rows=8 width=182) |
| -> HashAggregate (cost=3.58..3.92 rows=8 width=190) |
| Group Key: r_3.id, rvr_3.status, rsvr_3.status |
| -> Hash Left Join (cost=2.25..3.44 rows=8 width=111) |
| Hash Cond: (r_3.id = rsvr_3.erp_inventory_lost_id) |
| -> Hash Left Join (cost=1.19..2.34 rows=8 width=99) |
| Hash Cond: (r_3.id = rvr_3.erp_inventory_lost_id) |
| -> Seq Scan on tbl_erp_inventory_losts r_3 (cost=0.00..1.11 rows=8 width=87) |
| Filter: (status <> 0) |
| -> Hash (cost=1.18..1.18 rows=1 width=16) |
| -> Seq Scan on tbl_erp_inventory_lost_verify_rels rvr_3 (cost=0.00..1.18 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.05..1.05 rows=1 width=16) |
| -> Seq Scan on tbl_erp_inventory_lost_stop_verify_rels rsvr_3 (cost=0.00..1.05 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 5" (cost=3.57..4.04 rows=9 width=222) |
| -> HashAggregate (cost=3.57..3.95 rows=9 width=230) |
| Group Key: r_4.id, rvr_4.status, rsvr_4.status |
| -> Hash Left Join (cost=2.20..3.41 rows=9 width=159) |
| Hash Cond: (r_4.id = rsvr_4.erp_inventory_overflow_id) |
| -> Hash Left Join (cost=1.16..2.33 rows=9 width=147) |
| Hash Cond: (r_4.id = rvr_4.erp_inventory_overflow_id) |
| -> Seq Scan on tbl_erp_inventory_overflows r_4 (cost=0.00..1.12 rows=9 width=135) |
| Filter: (status <> 0) |
| -> Hash (cost=1.15..1.15 rows=1 width=16) |
| -> Seq Scan on tbl_erp_inventory_overflow_verify_rels rvr_4 (cost=0.00..1.15 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.02..1.02 rows=1 width=16) |
| -> Seq Scan on tbl_erp_inventory_overflow_stop_verify_rels rsvr_4 (cost=0.00..1.02 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 6" (cost=24.92..25.64 rows=10 width=176) |
| -> GroupAggregate (cost=24.92..25.54 rows=10 width=184) |
| Group Key: r_5.id, rvr_5.status, rsvr_5.status |
| -> Sort (cost=24.92..24.94 rows=10 width=105) |
| Sort Key: r_5.id, rvr_5.status, rsvr_5.status |
| -> Nested Loop Left Join (cost=1.27..24.75 rows=10 width=105) |
| Join Filter: (rvr_5.erp_inventory_build_id = r_5.id) |
| -> Hash Right Join (cost=1.27..23.41 rows=10 width=93) |
| Hash Cond: (rsvr_5.erp_inventory_build_id = r_5.id) |
| -> Seq Scan on tbl_erp_inventory_build_stop_verify_rels rsvr_5 (cost=0.00..22.12 rows=5 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.15..1.15 rows=10 width=81) |
| -> Seq Scan on tbl_erp_inventory_builds r_5 (cost=0.00..1.15 rows=10 width=81) |
| Filter: (status <> 0) |
| -> Materialize (cost=0.00..1.19 rows=1 width=16) |
| -> Seq Scan on tbl_erp_inventory_build_verify_rels rvr_5 (cost=0.00..1.19 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 7" (cost=24.64..24.93 rows=4 width=231) |
| -> GroupAggregate (cost=24.64..24.89 rows=4 width=239) |
| Group Key: r_6.id, rvr_6.status, rsvr_6.status |
| -> Sort (cost=24.64..24.65 rows=4 width=160) |
| Sort Key: r_6.id, rvr_6.status, rsvr_6.status |
| -> Nested Loop Left Join (cost=1.11..24.60 rows=4 width=160) |
| Join Filter: (rvr_6.erp_inventory_disassemble_id = r_6.id) |
| -> Hash Right Join (cost=1.11..23.25 rows=4 width=148) |
| Hash Cond: (rsvr_6.erp_inventory_disassemble_id = r_6.id) |
| -> Seq Scan on tbl_erp_inventory_disassemble_stop_verify_rels rsvr_6 (cost=0.00..22.12 rows=5 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.06..1.06 rows=4 width=136) |
| -> Seq Scan on tbl_erp_inventory_disassembles r_6 (cost=0.00..1.06 rows=4 width=136) |
| Filter: (status <> 0) |
| -> Materialize (cost=0.00..1.18 rows=3 width=16) |
| -> Seq Scan on tbl_erp_inventory_disassemble_verify_rels rvr_6 (cost=0.00..1.16 rows=3 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 8" (cost=60.80..69.68 rows=169 width=321) |
| -> HashAggregate (cost=60.80..67.99 rows=169 width=329) |
| Group Key: r_7.id, rvr_7.status, rsvr_7.status |
| -> Hash Left Join (cost=44.38..57.85 rows=169 width=250) |
| Hash Cond: (r_7.id = rsvr_7.erp_inventory_transfer_id) |
| -> Hash Left Join (cost=22.19..34.99 rows=169 width=238) |
| Hash Cond: (r_7.id = rvr_7.erp_inventory_transfer_id) |
| -> Seq Scan on tbl_erp_inventory_transfers r_7 (cost=0.00..12.12 rows=169 width=226) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=16) |
| -> Seq Scan on tbl_erp_inventory_transfer_verify_rels rvr_7 (cost=0.00..22.12 rows=5 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=22.12..22.12 rows=5 width=16) |
| -> Seq Scan on tbl_erp_inventory_transfer_stop_verify_rels rsvr_7 (cost=0.00..22.12 rows=5 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 9" (cost=126.80..229.58 rows=1713 width=221) |
| -> HashAggregate (cost=126.80..212.45 rows=1713 width=233) |
| Group Key: r_8.id, rvr_8.status, rsvr_8.status, rcvr_1.status |
| -> Hash Left Join (cost=5.23..83.98 rows=1713 width=178) |
| Hash Cond: (r_8.id = rcvr_1.erp_sales_order_id) |
| -> Hash Left Join (cost=4.15..76.47 rows=1713 width=166) |
| Hash Cond: (r_8.id = rsvr_8.erp_sales_order_id) |
| -> Hash Left Join (cost=2.83..68.71 rows=1713 width=154) |
| Hash Cond: (r_8.id = rvr_8.erp_sales_order_id) |
| -> Seq Scan on tbl_erp_sales_orders r_8 (cost=0.00..59.45 rows=1713 width=142) |
| Filter: (status <> 0) |
| -> Hash (cost=2.81..2.81 rows=1 width=16) |
| -> Seq Scan on tbl_erp_sales_order_verify_rels rvr_8 (cost=0.00..2.81 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.31..1.31 rows=1 width=16) |
| -> Seq Scan on tbl_erp_sales_order_stop_verify_rels rsvr_8 (cost=0.00..1.31 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.06..1.06 rows=1 width=16) |
| -> Seq Scan on tbl_erp_sales_order_cancel_verify_rels rcvr_1 (cost=0.00..1.06 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 10" (cost=22.79..32.82 rows=191 width=232) |
| -> HashAggregate (cost=22.79..30.91 rows=191 width=240) |
| Group Key: r_9.id, rvr_9.status, rsvr_9.status |
| -> Hash Left Join (cost=10.60..19.45 rows=191 width=165) |
| Hash Cond: (r_9.id = rsvr_9.erp_sales_outbound_id) |
| -> Hash Left Join (cost=9.50..17.63 rows=191 width=153) |
| Hash Cond: (r_9.id = rvr_9.erp_sales_outbound_id) |
| -> Seq Scan on tbl_erp_sales_outbounds r_9 (cost=0.00..7.40 rows=191 width=141) |
| Filter: (status <> 0) |
| -> Hash (cost=9.49..9.49 rows=1 width=16) |
| -> Seq Scan on tbl_erp_sales_outbound_verify_rels rvr_9 (cost=0.00..9.49 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.09..1.09 rows=1 width=16) |
| -> Seq Scan on tbl_erp_sales_outbound_stop_verify_rels rsvr_9 (cost=0.00..1.09 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 11" (cost=24.56..24.99 rows=6 width=256) |
| -> GroupAggregate (cost=24.56..24.93 rows=6 width=264) |
| Group Key: r_10.id, rvr_10.status, rsvr_10.status |
| -> Sort (cost=24.56..24.57 rows=6 width=189) |
| Sort Key: r_10.id, rvr_10.status, rsvr_10.status |
| -> Nested Loop Left Join (cost=1.15..24.48 rows=6 width=189) |
| Join Filter: (rvr_10.erp_sales_return_id = r_10.id) |
| -> Hash Right Join (cost=1.15..23.29 rows=6 width=177) |
| Hash Cond: (rsvr_10.erp_sales_return_id = r_10.id) |
| -> Seq Scan on tbl_erp_sales_return_stop_verify_rels rsvr_10 (cost=0.00..22.12 rows=5 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.07..1.07 rows=6 width=165) |
| -> Seq Scan on tbl_erp_sales_returns r_10 (cost=0.00..1.07 rows=6 width=165) |
| Filter: (status <> 0) |
| -> Materialize (cost=0.00..1.10 rows=1 width=16) |
| -> Seq Scan on tbl_erp_sales_return_verify_rels rvr_10 (cost=0.00..1.10 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 12" (cost=4.51..5.61 rows=21 width=184) |
| -> HashAggregate (cost=4.51..5.40 rows=21 width=192) |
| Group Key: r_11.id, rvr_11.status, rsvr_11.status |
| -> Hash Left Join (cost=2.69..4.14 rows=21 width=129) |
| Hash Cond: (r_11.id = rsvr_11.erp_purchase_gift_id) |
| -> Hash Left Join (cost=1.60..2.96 rows=21 width=117) |
| Hash Cond: (r_11.id = rvr_11.erp_purchase_gift_id) |
| -> Seq Scan on tbl_erp_purchase_gifts r_11 (cost=0.00..1.27 rows=21 width=105) |
| Filter: (status <> 0) |
| -> Hash (cost=1.59..1.59 rows=1 width=16) |
| -> Seq Scan on tbl_erp_purchase_gift_verify_rels rvr_11 (cost=0.00..1.59 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.07..1.07 rows=1 width=16) |
| -> Seq Scan on tbl_erp_purchase_gift_stop_verify_rels rsvr_11 (cost=0.00..1.07 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 13" (cost=19.18..28.16 rows=171 width=211) |
| -> HashAggregate (cost=19.18..26.45 rows=171 width=219) |
| Group Key: r_12.id, rvr_12.status, rsvr_12.status |
| -> Hash Left Join (cost=8.74..16.19 rows=171 width=144) |
| Hash Cond: (r_12.id = rsvr_12.erp_sales_gift_id) |
| -> Hash Left Join (cost=7.68..14.48 rows=171 width=132) |
| Hash Cond: (r_12.id = rvr_12.erp_sales_gift_id) |
| -> Seq Scan on tbl_erp_sales_gifts r_12 (cost=0.00..6.15 rows=171 width=120) |
| Filter: (status <> 0) |
| -> Hash (cost=7.66..7.66 rows=1 width=16) |
| -> Seq Scan on tbl_erp_sales_gift_verify_rels rvr_12 (cost=0.00..7.66 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.05..1.05 rows=1 width=16) |
| -> Seq Scan on tbl_erp_sales_gift_stop_verify_rels rsvr_12 (cost=0.00..1.05 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 14" (cost=123.82..238.90 rows=2192 width=162) |
| -> HashAggregate (cost=123.82..216.98 rows=2192 width=170) |
| Group Key: r_13.id, rvr_13.status, rsvr_13.status |
| -> Hash Left Join (cost=5.55..85.46 rows=2192 width=139) |
| Hash Cond: (r_13.id = rsvr_13.erp_collect_ticket_id) |
| -> Hash Left Join (cost=4.46..76.14 rows=2192 width=127) |
| Hash Cond: (r_13.id = rvr_13.erp_collect_ticket_id) |
| -> Seq Scan on tbl_erp_collect_tickets r_13 (cost=0.00..63.45 rows=2192 width=115) |
| Filter: (status <> 0) |
| -> Hash (cost=4.45..4.45 rows=1 width=16) |
| -> Seq Scan on tbl_erp_collect_ticket_verify_rels rvr_13 (cost=0.00..4.45 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.07..1.07 rows=1 width=16) |
| -> Seq Scan on tbl_erp_collect_ticket_stop_verify_rels rsvr_13 (cost=0.00..1.07 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 15" (cost=133.72..257.10 rows=2350 width=167) |
| -> HashAggregate (cost=133.72..233.60 rows=2350 width=175) |
| Group Key: r_14.id, rvr_14.status, rsvr_14.status |
| -> Hash Left Join (cost=6.53..92.60 rows=2350 width=145) |
| Hash Cond: (r_14.id = rsvr_14.erp_payment_ticket_id) |
| -> Hash Left Join (cost=5.40..82.65 rows=2350 width=133) |
| Hash Cond: (r_14.id = rvr_14.erp_payment_ticket_id) |
| -> Seq Scan on tbl_erp_payment_tickets r_14 (cost=0.00..68.42 rows=2350 width=121) |
| Filter: (status <> 0) |
| -> Hash (cost=5.39..5.39 rows=1 width=16) |
| -> Seq Scan on tbl_erp_payment_ticket_verify_rels rvr_14 (cost=0.00..5.39 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.11..1.11 rows=1 width=16) |
| -> Seq Scan on tbl_erp_payment_ticket_stop_verify_rels rsvr_14 (cost=0.00..1.11 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 16" (cost=7.00..10.04 rows=58 width=219) |
| -> HashAggregate (cost=7.00..9.46 rows=58 width=227) |
| Group Key: r_15.id, rvr_15.status, rsvr_15.status |
| -> Hash Left Join (cost=2.79..5.98 rows=58 width=192) |
| Hash Cond: (r_15.id = rsvr_15.erp_cost_ticket_id) |
| -> Hash Left Join (cost=1.74..4.70 rows=58 width=180) |
| Hash Cond: (r_15.id = rvr_15.erp_cost_ticket_id) |
| -> Seq Scan on tbl_erp_cost_tickets r_15 (cost=0.00..2.74 rows=58 width=168) |
| Filter: (status <> 0) |
| -> Hash (cost=1.73..1.73 rows=1 width=16) |
| -> Seq Scan on tbl_erp_cost_ticket_verify_rels rvr_15 (cost=0.00..1.73 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.04..1.04 rows=1 width=16) |
| -> Seq Scan on tbl_erp_cost_ticket_stop_verify_rels rsvr_15 (cost=0.00..1.04 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 17" (cost=5.04..7.09 rows=39 width=188) |
| -> HashAggregate (cost=5.04..6.70 rows=39 width=196) |
| Group Key: r_16.id, rvr_16.status, rsvr_16.status |
| -> Hash Left Join (cost=2.55..4.36 rows=39 width=165) |
| Hash Cond: (r_16.id = rsvr_16.erp_other_income_ticket_id) |
| -> Hash Left Join (cost=1.51..3.17 rows=39 width=153) |
| Hash Cond: (r_16.id = rvr_16.erp_other_income_ticket_id) |
| -> Seq Scan on tbl_erp_other_income_tickets r_16 (cost=0.00..1.50 rows=39 width=141) |
| Filter: (status <> 0) |
| -> Hash (cost=1.50..1.50 rows=1 width=16) |
| -> Seq Scan on tbl_erp_other_income_ticket_verify_rels rvr_16 (cost=0.00..1.50 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.02..1.02 rows=1 width=16) |
| -> Seq Scan on tbl_erp_other_income_ticket_stop_verify_rels rsvr_16 (cost=0.00..1.02 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 18" (cost=3.58..4.11 rows=10 width=294) |
| -> HashAggregate (cost=3.58..4.01 rows=10 width=302) |
| Group Key: r_17.id, rvr_17.status, rsvr_17.status |
| -> Hash Left Join (cost=2.17..3.41 rows=10 width=231) |
| Hash Cond: (r_17.id = rsvr_17.erp_cost_convert_ticket_id) |
| -> Hash Left Join (cost=1.15..2.33 rows=10 width=219) |
| Hash Cond: (r_17.id = rvr_17.erp_cost_convert_ticket_id) |
| -> Seq Scan on tbl_erp_cost_convert_tickets r_17 (cost=0.00..1.14 rows=10 width=207) |
| Filter: (status <> 0) |
| -> Hash (cost=1.14..1.14 rows=1 width=16) |
| -> Seq Scan on tbl_erp_cost_convert_ticket_verify_rels rvr_17 (cost=0.00..1.14 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.01..1.01 rows=1 width=16) |
| -> Seq Scan on tbl_erp_cost_convert_ticket_stop_verify_rels rsvr_17 (cost=0.00..1.01 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 19" (cost=4.57..5.78 rows=23 width=232) |
| -> HashAggregate (cost=4.57..5.55 rows=23 width=240) |
| Group Key: r_18.id, rvr_18.status, rsvr_18.status |
| -> Hash Left Join (cost=2.68..4.17 rows=23 width=161) |
| Hash Cond: (r_18.id = rsvr_18.erp_bank_transfer_ticket_id) |
| -> Hash Left Join (cost=1.61..3.01 rows=23 width=149) |
| Hash Cond: (r_18.id = rvr_18.erp_bank_transfer_ticket_id) |
| -> Seq Scan on tbl_erp_bank_transfer_tickets r_18 (cost=0.00..1.30 rows=23 width=137) |
| Filter: (status <> 0) |
| -> Hash (cost=1.60..1.60 rows=1 width=16) |
| -> Seq Scan on tbl_erp_bank_transfer_ticket_verify_rels rvr_18 (cost=0.00..1.60 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.05..1.05 rows=1 width=16) |
| -> Seq Scan on tbl_erp_bank_transfer_ticket_stop_verify_rels rsvr_18 (cost=0.00..1.05 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 20" (cost=1101.25..1546.08 rows=8473 width=175) |
| -> HashAggregate (cost=1101.25..1461.35 rows=8473 width=183) |
| Group Key: r_19.id, rvr_19.status, rsvr_19.status |
| -> Hash Left Join (cost=386.35..952.97 rows=8473 width=145) |
| Hash Cond: (r_19.id = rsvr_19.erp_cash_cost_ticket_id) |
| -> Hash Left Join (cost=385.19..920.02 rows=8473 width=133) |
| Hash Cond: (r_19.id = rvr_19.erp_cash_cost_ticket_id) |
| -> Seq Scan on tbl_erp_cash_cost_tickets r_19 (cost=0.00..470.94 rows=8473 width=121) |
| Filter: (status <> 0) |
| -> Hash (cost=384.75..384.75 rows=35 width=16) |
| -> Seq Scan on tbl_erp_cash_cost_ticket_verify_rels rvr_19 (cost=0.00..384.75 rows=35 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.15..1.15 rows=1 width=16) |
| -> Seq Scan on tbl_erp_cash_cost_ticket_stop_verify_rels rsvr_19 (cost=0.00..1.15 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 21" (cost=3.19..3.33 rows=2 width=161) |
| -> GroupAggregate (cost=3.19..3.31 rows=2 width=169) |
| Group Key: r_20.id, rvr_20.status, rsvr_20.status |
| -> Sort (cost=3.19..3.19 rows=2 width=131) |
| Sort Key: r_20.id, rvr_20.status, rsvr_20.status |
| -> Nested Loop Left Join (cost=0.00..3.18 rows=2 width=131) |
| Join Filter: (rsvr_20.erp_advance_payment_ticket_id = r_20.id) |
| -> Nested Loop Left Join (cost=0.00..2.12 rows=2 width=119) |
| Join Filter: (rvr_20.erp_advance_payment_ticket_id = r_20.id) |
| -> Seq Scan on tbl_erp_advance_payment_tickets r_20 (cost=0.00..1.04 rows=2 width=107) |
| Filter: (status <> 0) |
| -> Materialize (cost=0.00..1.05 rows=1 width=16) |
| -> Seq Scan on tbl_erp_advance_payment_ticket_verify_rels rvr_20 (cost=0.00..1.05 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Materialize (cost=0.00..1.03 rows=1 width=16) |
| -> Seq Scan on tbl_erp_advance_payment_ticket_stop_verify_rels rsvr_20 (cost=0.00..1.02 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 22" (cost=27.08..29.39 rows=44 width=174) |
| -> HashAggregate (cost=27.08..28.95 rows=44 width=182) |
| Group Key: r_21.id, rvr_21.status, rsvr_21.status |
| -> Hash Left Join (cost=23.40..26.31 rows=44 width=151) |
| Hash Cond: (r_21.id = rsvr_21.erp_other_payment_ticket_id) |
| -> Hash Left Join (cost=1.21..3.95 rows=44 width=139) |
| Hash Cond: (r_21.id = rvr_21.erp_other_payment_ticket_id) |
| -> Seq Scan on tbl_erp_other_payment_tickets r_21 (cost=0.00..2.56 rows=44 width=127) |
| Filter: (status <> 0) |
| -> Hash (cost=1.20..1.20 rows=1 width=16) |
| -> Seq Scan on tbl_erp_other_payment_ticket_verify_rels rvr_21 (cost=0.00..1.20 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=22.12..22.12 rows=5 width=16) |
| -> Seq Scan on tbl_erp_other_payment_ticket_stop_verify_rels rsvr_21 (cost=0.00..22.12 rows=5 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 23" (cost=6.37..8.79 rows=46 width=196) |
| -> HashAggregate (cost=6.37..8.33 rows=46 width=204) |
| Group Key: r_22.id, rvr_22.status, rsvr_22.status |
| -> Hash Left Join (cost=2.61..5.57 rows=46 width=173) |
| Hash Cond: (r_22.id = rsvr_22.erp_other_collect_ticket_id) |
| -> Hash Left Join (cost=1.55..4.32 rows=46 width=161) |
| Hash Cond: (r_22.id = rvr_22.erp_other_collect_ticket_id) |
| -> Seq Scan on tbl_erp_other_collect_tickets r_22 (cost=0.00..2.59 rows=46 width=149) |
| Filter: (status <> 0) |
| -> Hash (cost=1.54..1.54 rows=1 width=16) |
| -> Seq Scan on tbl_erp_other_collect_ticket_verify_rels rvr_22 (cost=0.00..1.54 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.05..1.05 rows=1 width=16) |
| -> Seq Scan on tbl_erp_other_collect_ticket_stop_verify_rels rsvr_22 (cost=0.00..1.05 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 24" (cost=8.83..11.89 rows=51 width=257) |
| -> HashAggregate (cost=8.83..11.38 rows=51 width=269) |
| Group Key: r_23.id, rvr_23.status, rsvr_23.status, rcvr_2.status |
| -> Hash Left Join (cost=4.30..7.55 rows=51 width=214) |
| Hash Cond: (r_23.id = rcvr_2.erp_purchase_cost_id) |
| -> Hash Left Join (cost=3.25..6.30 rows=51 width=202) |
| Hash Cond: (r_23.id = rsvr_23.erp_purchase_cost_id) |
| -> Hash Left Join (cost=2.10..4.95 rows=51 width=190) |
| Hash Cond: (r_23.id = rvr_23.erp_purchase_cost_id) |
| -> Seq Scan on tbl_erp_purchase_costs r_23 (cost=0.00..2.65 rows=51 width=178) |
| Filter: (status <> 0) |
| -> Hash (cost=2.09..2.09 rows=1 width=16) |
| -> Seq Scan on tbl_erp_purchase_cost_verify_rels rvr_23 (cost=0.00..2.09 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.14..1.14 rows=1 width=16) |
| -> Seq Scan on tbl_erp_purchase_cost_stop_verify_rels rsvr_23 (cost=0.00..1.14 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.04..1.04 rows=1 width=16) |
| -> Seq Scan on tbl_erp_purchase_cost_cancel_verify_rels rcvr_2 (cost=0.00..1.04 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 25" (cost=3.78..4.52 rows=14 width=217) |
| -> HashAggregate (cost=3.78..4.38 rows=14 width=225) |
| Group Key: r_24.id, rvr_24.status, rsvr_24.status |
| -> Hash Left Join (cost=2.23..3.54 rows=14 width=179) |
| Hash Cond: (r_24.id = rsvr_24.erp_wage_ticket_id) |
| -> Hash Left Join (cost=1.19..2.44 rows=14 width=167) |
| Hash Cond: (r_24.id = rvr_24.erp_wage_ticket_id) |
| -> Seq Scan on tbl_erp_wage_tickets r_24 (cost=0.00..1.19 rows=14 width=155) |
| Filter: (status <> 0) |
| -> Hash (cost=1.18..1.18 rows=1 width=16) |
| -> Seq Scan on tbl_erp_wage_ticket_verify_rels rvr_24 (cost=0.00..1.18 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.02..1.02 rows=1 width=16) |
| -> Seq Scan on tbl_erp_wage_ticket_stop_verify_rels rsvr_24 (cost=0.00..1.02 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 26" (cost=3.79..4.37 rows=11 width=190) |
| -> HashAggregate (cost=3.79..4.26 rows=11 width=198) |
| Group Key: r_25.id, rvr_25.status, rsvr_25.status |
| -> Hash Left Join (cost=2.35..3.60 rows=11 width=152) |
| Hash Cond: (r_25.id = rsvr_25.erp_social_insurance_id) |
| -> Hash Left Join (cost=1.29..2.49 rows=11 width=140) |
| Hash Cond: (r_25.id = rvr_25.erp_social_insurance_id) |
| -> Seq Scan on tbl_erp_social_insurances r_25 (cost=0.00..1.15 rows=11 width=128) |
| Filter: (status <> 0) |
| -> Hash (cost=1.27..1.27 rows=1 width=16) |
| -> Seq Scan on tbl_erp_social_insurance_verify_rels rvr_25 (cost=0.00..1.27 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.05..1.05 rows=1 width=16) |
| -> Seq Scan on tbl_erp_social_insurance_stop_verify_rels rsvr_25 (cost=0.00..1.05 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 27" (cost=24.79..25.37 rows=8 width=206) |
| -> GroupAggregate (cost=24.79..25.29 rows=8 width=214) |
| Group Key: r_26.id, rvr_26.status, rsvr_26.status |
| -> Sort (cost=24.79..24.81 rows=8 width=168) |
| Sort Key: r_26.id, rvr_26.status, rsvr_26.status |
| -> Nested Loop Left Join (cost=1.21..24.67 rows=8 width=168) |
| Join Filter: (rvr_26.erp_provident_fund_id = r_26.id) |
| -> Hash Right Join (cost=1.21..23.35 rows=8 width=156) |
| Hash Cond: (rsvr_26.erp_provident_fund_id = r_26.id) |
| -> Seq Scan on tbl_erp_provident_fund_stop_verify_rels rsvr_26 (cost=0.00..22.12 rows=5 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.11..1.11 rows=8 width=144) |
| -> Seq Scan on tbl_erp_provident_funds r_26 (cost=0.00..1.11 rows=8 width=144) |
| Filter: (status <> 0) |
| -> Materialize (cost=0.00..1.20 rows=1 width=16) |
| -> Seq Scan on tbl_erp_provident_fund_verify_rels rvr_26 (cost=0.00..1.20 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 28" (cost=3.52..3.99 rows=9 width=197) |
| -> HashAggregate (cost=3.52..3.90 rows=9 width=205) |
| Group Key: r_27.id, rvr_27.status, rsvr_27.status |
| -> Hash Left Join (cost=2.15..3.36 rows=9 width=159) |
| Hash Cond: (r_27.id = rsvr_27.erp_personal_tax_id) |
| -> Hash Left Join (cost=1.12..2.29 rows=9 width=147) |
| Hash Cond: (r_27.id = rvr_27.erp_personal_tax_id) |
| -> Seq Scan on tbl_erp_personal_taxs r_27 (cost=0.00..1.12 rows=9 width=135) |
| Filter: (status <> 0) |
| -> Hash (cost=1.11..1.11 rows=1 width=16) |
| -> Seq Scan on tbl_erp_personal_tax_verify_rels rvr_27 (cost=0.00..1.11 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Hash (cost=1.01..1.01 rows=1 width=16) |
| -> Seq Scan on tbl_erp_personal_tax_stop_verify_rels rsvr_27 (cost=0.00..1.01 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 29" (cost=3.31..3.52 rows=4 width=222) |
| -> HashAggregate (cost=3.31..3.48 rows=4 width=230) |
| Group Key: r_28.id, rvr_28.status, rsvr_28.status |
| -> Nested Loop Left Join (cost=1.02..3.24 rows=4 width=184) |
| Join Filter: (rvr_28.erp_wage_prize_id = r_28.id) |
| -> Hash Left Join (cost=1.02..2.11 rows=4 width=172) |
| Hash Cond: (r_28.id = rsvr_28.erp_wage_prize_id) |
| -> Seq Scan on tbl_erp_wage_prizes r_28 (cost=0.00..1.06 rows=4 width=160) |
| Filter: (status <> 0) |
| -> Hash (cost=1.01..1.01 rows=1 width=16) |
| -> Seq Scan on tbl_erp_wage_prize_stop_verify_rels rsvr_28 (cost=0.00..1.01 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Materialize (cost=0.00..1.07 rows=1 width=16) |
| -> Seq Scan on tbl_erp_wage_prize_verify_rels rvr_28 (cost=0.00..1.06 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Subquery Scan on "*SELECT* 30" (cost=28.12..28.35 rows=3 width=391) |
| -> GroupAggregate (cost=28.12..28.32 rows=3 width=399) |
| Group Key: r_29.id, rvr_29.status, rsvr_29.status |
| -> Sort (cost=28.12..28.12 rows=3 width=297) |
| Sort Key: r_29.id, rvr_29.status, rsvr_29.status |
| -> Nested Loop Left Join (cost=0.28..28.09 rows=3 width=297) |
| Join Filter: (rsvr_29.erp_profit_distribute_id = r_29.id) |
| -> Nested Loop Left Join (cost=0.28..27.03 rows=3 width=285) |
| Join Filter: (rvr_29.erp_profit_distribute_id = r_29.id) |
| -> Nested Loop Left Join (cost=0.28..25.95 rows=3 width=273) |
| -> Seq Scan on tbl_erp_profit_distributes r_29 (cost=0.00..1.05 rows=3 width=272) |
| Filter: (status <> 0) |
| -> Index Scan using tbl_projects_pkey on tbl_projects p (cost=0.28..8.30 rows=1 width=9) |
| Index Cond: (r_29.project_id = id) |
| -> Materialize (cost=0.00..1.04 rows=1 width=16) |
| -> Seq Scan on tbl_erp_profit_distribute_verify_rels rvr_29 (cost=0.00..1.04 rows=1 width=16) |
| Filter: (user_id = 1000) |
| -> Materialize (cost=0.00..1.02 rows=1 width=16) |
| -> Seq Scan on tbl_erp_profit_distribute_stop_verify_rels rsvr_29 (cost=0.00..1.01 rows=1 width=16) |
| Filter: (user_id = 1000) |