| Aggregate (cost=2911.86..2911.87 rows=1 width=8) |
| -> Append (cost=57.89..2904.44 rows=2968 width=0) |
| -> Subquery Scan on sub (cost=57.89..57.93 rows=2 width=0) |
| -> Group (cost=57.89..57.91 rows=2 width=265) |
| Group Key: r.id, rvr.status, rsvr.status |
| -> Sort (cost=57.89..57.90 rows=2 width=12) |
| Sort Key: r.id, rvr.status, rsvr.status |
| -> Hash Left Join (cost=44.38..57.88 rows=2 width=12) |
| Hash Cond: (r.id = rsvr.erp_purchase_inbound_id) |
| Filter: (((rsvr.status <> 0) OR (rsvr.status IS NULL)) AND ((rvr.user_id = 1001) OR (rsvr.user_id = 1001))) |
| -> Hash Left Join (cost=22.19..35.00 rows=168 width=12) |
| Hash Cond: (r.id = rvr.erp_purchase_inbound_id) |
| Filter: ((rvr.status <> 0) OR (rvr.status IS NULL)) |
| -> Seq Scan on tbl_erp_purchase_inbounds r (cost=0.00..12.12 rows=169 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_purchase_inbound_verify_rels rvr (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_purchase_inbound_stop_verify_rels rsvr (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 2" (cost=188.12..188.80 rows=30 width=0) |
| -> Group (cost=188.12..188.50 rows=30 width=265) |
| Group Key: r_1.id, rvr_1.status, rsvr_1.status, rcvr.status |
| -> Sort (cost=188.12..188.20 rows=30 width=16) |
| Sort Key: r_1.id, rvr_1.status, rsvr_1.status, rcvr.status |
| -> Hash Left Join (cost=66.56..187.39 rows=30 width=16) |
| Hash Cond: (r_1.id = rcvr.erp_purchase_order_id) |
| Filter: (((rcvr.status <> 0) OR (rcvr.status IS NULL)) AND ((rvr_1.user_id = 1001) OR (rsvr_1.user_id = 1001) OR (rcvr.user_id = 1001))) |
| -> Hash Left Join (cost=44.38..157.64 rows=1989 width=20) |
| Hash Cond: (r_1.id = rsvr_1.erp_purchase_order_id) |
| Filter: ((rsvr_1.status <> 0) OR (rsvr_1.status IS NULL)) |
| -> Hash Left Join (cost=22.19..127.90 rows=1999 width=12) |
| Hash Cond: (r_1.id = rvr_1.erp_purchase_order_id) |
| Filter: ((rvr_1.status <> 0) OR (rvr_1.status IS NULL)) |
| -> Seq Scan on tbl_erp_purchase_orders r_1 (cost=0.00..98.11 rows=2009 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_purchase_order_verify_rels rvr_1 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_purchase_order_stop_verify_rels rsvr_1 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_purchase_order_cancel_verify_rels rcvr (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 3" (cost=58.72..58.76 rows=2 width=0) |
| -> Group (cost=58.72..58.74 rows=2 width=265) |
| Group Key: r_2.id, rvr_2.status, rsvr_2.status |
| -> Sort (cost=58.72..58.73 rows=2 width=12) |
| Sort Key: r_2.id, rvr_2.status, rsvr_2.status |
| -> Hash Left Join (cost=44.38..58.71 rows=2 width=12) |
| Hash Cond: (r_2.id = rsvr_2.erp_purchase_return_id) |
| Filter: (((rsvr_2.status <> 0) OR (rsvr_2.status IS NULL)) AND ((rvr_2.user_id = 1001) OR (rsvr_2.user_id = 1001))) |
| -> Hash Left Join (cost=22.19..35.66 rows=208 width=12) |
| Hash Cond: (r_2.id = rvr_2.erp_purchase_return_id) |
| Filter: ((rvr_2.status <> 0) OR (rvr_2.status IS NULL)) |
| -> Seq Scan on tbl_erp_purchase_returns r_2 (cost=0.00..12.62 rows=209 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_purchase_return_verify_rels rvr_2 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_purchase_return_stop_verify_rels rsvr_2 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 4" (cost=58.72..58.76 rows=2 width=0) |
| -> Group (cost=58.72..58.74 rows=2 width=265) |
| Group Key: r_3.id, rvr_3.status, rsvr_3.status |
| -> Sort (cost=58.72..58.73 rows=2 width=12) |
| Sort Key: r_3.id, rvr_3.status, rsvr_3.status |
| -> Hash Left Join (cost=44.38..58.71 rows=2 width=12) |
| Hash Cond: (r_3.id = rsvr_3.erp_inventory_lost_id) |
| Filter: (((rsvr_3.status <> 0) OR (rsvr_3.status IS NULL)) AND ((rvr_3.user_id = 1001) OR (rsvr_3.user_id = 1001))) |
| -> Hash Left Join (cost=22.19..35.66 rows=208 width=12) |
| Hash Cond: (r_3.id = rvr_3.erp_inventory_lost_id) |
| Filter: ((rvr_3.status <> 0) OR (rvr_3.status IS NULL)) |
| -> Seq Scan on tbl_erp_inventory_losts r_3 (cost=0.00..12.62 rows=209 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_inventory_lost_verify_rels rvr_3 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_inventory_lost_stop_verify_rels rsvr_3 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 5" (cost=58.09..58.13 rows=2 width=0) |
| -> Group (cost=58.09..58.11 rows=2 width=265) |
| Group Key: r_4.id, rvr_4.status, rsvr_4.status |
| -> Sort (cost=58.09..58.10 rows=2 width=12) |
| Sort Key: r_4.id, rvr_4.status, rsvr_4.status |
| -> Hash Left Join (cost=44.38..58.08 rows=2 width=12) |
| Hash Cond: (r_4.id = rsvr_4.erp_inventory_build_id) |
| Filter: (((rsvr_4.status <> 0) OR (rsvr_4.status IS NULL)) AND ((rvr_4.user_id = 1001) OR (rsvr_4.user_id = 1001))) |
| -> Hash Left Join (cost=22.19..35.16 rows=178 width=12) |
| Hash Cond: (r_4.id = rvr_4.erp_inventory_build_id) |
| Filter: ((rvr_4.status <> 0) OR (rvr_4.status IS NULL)) |
| -> Seq Scan on tbl_erp_inventory_builds r_4 (cost=0.00..12.25 rows=179 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_inventory_build_verify_rels rvr_4 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_inventory_build_stop_verify_rels rsvr_4 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 6" (cost=166.34..166.86 rows=23 width=0) |
| -> Group (cost=166.34..166.63 rows=23 width=265) |
| Group Key: r_5.id, rvr_5.status, rsvr_5.status, rcvr_1.status |
| -> Sort (cost=166.34..166.40 rows=23 width=16) |
| Sort Key: r_5.id, rvr_5.status, rsvr_5.status, rcvr_1.status |
| -> Hash Left Join (cost=66.56..165.82 rows=23 width=16) |
| Hash Cond: (r_5.id = rcvr_1.erp_sales_order_id) |
| Filter: (((rcvr_1.status <> 0) OR (rcvr_1.status IS NULL)) AND ((rvr_5.user_id = 1001) OR (rsvr_5.user_id = 1001) OR (rcvr_1.user_id = 1001))) |
| -> Hash Left Join (cost=44.38..137.73 rows=1547 width=20) |
| Hash Cond: (r_5.id = rsvr_5.erp_sales_order_id) |
| Filter: ((rsvr_5.status <> 0) OR (rsvr_5.status IS NULL)) |
| -> Hash Left Join (cost=22.19..109.65 rows=1555 width=12) |
| Hash Cond: (r_5.id = rvr_5.erp_sales_order_id) |
| Filter: ((rvr_5.status <> 0) OR (rvr_5.status IS NULL)) |
| -> Seq Scan on tbl_erp_sales_orders r_5 (cost=0.00..81.54 rows=1563 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_sales_order_verify_rels rvr_5 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_sales_order_stop_verify_rels rsvr_5 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_sales_order_cancel_verify_rels rcvr_1 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 7" (cost=58.52..58.56 rows=2 width=0) |
| -> Group (cost=58.52..58.54 rows=2 width=265) |
| Group Key: r_6.id, rvr_6.status, rsvr_6.status |
| -> Sort (cost=58.52..58.53 rows=2 width=12) |
| Sort Key: r_6.id, rvr_6.status, rsvr_6.status |
| -> Hash Left Join (cost=44.38..58.51 rows=2 width=12) |
| Hash Cond: (r_6.id = rsvr_6.erp_sales_outbound_id) |
| Filter: (((rsvr_6.status <> 0) OR (rsvr_6.status IS NULL)) AND ((rvr_6.user_id = 1001) OR (rsvr_6.user_id = 1001))) |
| -> Hash Left Join (cost=22.19..35.50 rows=198 width=12) |
| Hash Cond: (r_6.id = rvr_6.erp_sales_outbound_id) |
| Filter: ((rvr_6.status <> 0) OR (rvr_6.status IS NULL)) |
| -> Seq Scan on tbl_erp_sales_outbounds r_6 (cost=0.00..12.50 rows=199 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_sales_outbound_verify_rels rvr_6 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_sales_outbound_stop_verify_rels rsvr_6 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 8" (cost=58.72..58.76 rows=2 width=0) |
| -> Group (cost=58.72..58.74 rows=2 width=265) |
| Group Key: r_7.id, rvr_7.status, rsvr_7.status |
| -> Sort (cost=58.72..58.73 rows=2 width=12) |
| Sort Key: r_7.id, rvr_7.status, rsvr_7.status |
| -> Hash Left Join (cost=44.38..58.71 rows=2 width=12) |
| Hash Cond: (r_7.id = rsvr_7.erp_sales_return_id) |
| Filter: (((rsvr_7.status <> 0) OR (rsvr_7.status IS NULL)) AND ((rvr_7.user_id = 1001) OR (rsvr_7.user_id = 1001))) |
| -> Hash Left Join (cost=22.19..35.66 rows=208 width=12) |
| Hash Cond: (r_7.id = rvr_7.erp_sales_return_id) |
| Filter: ((rvr_7.status <> 0) OR (rvr_7.status IS NULL)) |
| -> Seq Scan on tbl_erp_sales_returns r_7 (cost=0.00..12.62 rows=209 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_sales_return_verify_rels rvr_7 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_sales_return_stop_verify_rels rsvr_7 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 9" (cost=57.89..57.93 rows=2 width=0) |
| -> Group (cost=57.89..57.91 rows=2 width=265) |
| Group Key: r_8.id, rvr_8.status, rsvr_8.status |
| -> Sort (cost=57.89..57.90 rows=2 width=12) |
| Sort Key: r_8.id, rvr_8.status, rsvr_8.status |
| -> Hash Left Join (cost=44.38..57.88 rows=2 width=12) |
| Hash Cond: (r_8.id = rsvr_8.erp_purchase_gift_id) |
| Filter: (((rsvr_8.status <> 0) OR (rsvr_8.status IS NULL)) AND ((rvr_8.user_id = 1001) OR (rsvr_8.user_id = 1001))) |
| -> Hash Left Join (cost=22.19..35.00 rows=168 width=12) |
| Hash Cond: (r_8.id = rvr_8.erp_purchase_gift_id) |
| Filter: ((rvr_8.status <> 0) OR (rvr_8.status IS NULL)) |
| -> Seq Scan on tbl_erp_purchase_gifts r_8 (cost=0.00..12.12 rows=169 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_purchase_gift_verify_rels rvr_8 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_purchase_gift_stop_verify_rels rsvr_8 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 10" (cost=58.52..58.56 rows=2 width=0) |
| -> Group (cost=58.52..58.54 rows=2 width=265) |
| Group Key: r_9.id, rvr_9.status, rsvr_9.status |
| -> Sort (cost=58.52..58.53 rows=2 width=12) |
| Sort Key: r_9.id, rvr_9.status, rsvr_9.status |
| -> Hash Left Join (cost=44.38..58.51 rows=2 width=12) |
| Hash Cond: (r_9.id = rsvr_9.erp_sales_gift_id) |
| Filter: (((rsvr_9.status <> 0) OR (rsvr_9.status IS NULL)) AND ((rvr_9.user_id = 1001) OR (rsvr_9.user_id = 1001))) |
| -> Hash Left Join (cost=22.19..35.50 rows=198 width=12) |
| Hash Cond: (r_9.id = rvr_9.erp_sales_gift_id) |
| Filter: ((rvr_9.status <> 0) OR (rvr_9.status IS NULL)) |
| -> Seq Scan on tbl_erp_sales_gifts r_9 (cost=0.00..12.50 rows=199 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_sales_gift_verify_rels rvr_9 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_sales_gift_stop_verify_rels rsvr_9 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 11" (cost=116.70..117.10 rows=20 width=0) |
| -> Group (cost=116.70..116.90 rows=20 width=265) |
| Group Key: r_10.id, rvr_10.status, rsvr_10.status |
| -> Sort (cost=116.70..116.75 rows=20 width=12) |
| Sort Key: r_10.id, rvr_10.status, rsvr_10.status |
| -> Hash Left Join (cost=44.38..116.27 rows=20 width=12) |
| Hash Cond: (r_10.id = rsvr_10.erp_collect_ticket_id) |
| Filter: (((rsvr_10.status <> 0) OR (rsvr_10.status IS NULL)) AND ((rvr_10.user_id = 1001) OR (rsvr_10.user_id = 1001))) |
| -> Hash Left Join (cost=22.19..86.57 rows=1979 width=12) |
| Hash Cond: (r_10.id = rvr_10.erp_collect_ticket_id) |
| Filter: ((rvr_10.status <> 0) OR (rvr_10.status IS NULL)) |
| -> Seq Scan on tbl_erp_collect_tickets r_10 (cost=0.00..56.86 rows=1989 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_collect_ticket_verify_rels rvr_10 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_collect_ticket_stop_verify_rels rsvr_10 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 12" (cost=121.52..121.94 rows=21 width=0) |
| -> Group (cost=121.52..121.73 rows=21 width=265) |
| Group Key: r_11.id, rvr_11.status, rsvr_11.status |
| -> Sort (cost=121.52..121.58 rows=21 width=12) |
| Sort Key: r_11.id, rvr_11.status, rsvr_11.status |
| -> Hash Left Join (cost=44.38..121.06 rows=21 width=12) |
| Hash Cond: (r_11.id = rsvr_11.erp_payment_ticket_id) |
| Filter: (((rsvr_11.status <> 0) OR (rsvr_11.status IS NULL)) AND ((rvr_11.user_id = 1001) OR (rsvr_11.user_id = 1001))) |
| -> Hash Left Join (cost=22.19..90.85 rows=2118 width=12) |
| Hash Cond: (r_11.id = rvr_11.erp_payment_ticket_id) |
| Filter: ((rvr_11.status <> 0) OR (rvr_11.status IS NULL)) |
| -> Seq Scan on tbl_erp_payment_tickets r_11 (cost=0.00..60.61 rows=2129 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_payment_ticket_verify_rels rvr_11 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_payment_ticket_stop_verify_rels rsvr_11 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 13" (cost=58.52..58.56 rows=2 width=0) |
| -> Group (cost=58.52..58.54 rows=2 width=265) |
| Group Key: r_12.id, rvr_12.status, rsvr_12.status |
| -> Sort (cost=58.52..58.53 rows=2 width=12) |
| Sort Key: r_12.id, rvr_12.status, rsvr_12.status |
| -> Hash Left Join (cost=44.38..58.51 rows=2 width=12) |
| Hash Cond: (r_12.id = rsvr_12.erp_other_income_ticket_id) |
| Filter: (((rsvr_12.status <> 0) OR (rsvr_12.status IS NULL)) AND ((rvr_12.user_id = 1001) OR (rsvr_12.user_id = 1001))) |
| -> Hash Left Join (cost=22.19..35.50 rows=198 width=12) |
| Hash Cond: (r_12.id = rvr_12.erp_other_income_ticket_id) |
| Filter: ((rvr_12.status <> 0) OR (rvr_12.status IS NULL)) |
| -> Seq Scan on tbl_erp_other_income_tickets r_12 (cost=0.00..12.50 rows=199 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_other_income_ticket_verify_rels rvr_12 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_other_income_ticket_stop_verify_rels rsvr_12 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 14" (cost=58.32..58.36 rows=2 width=0) |
| -> Group (cost=58.32..58.34 rows=2 width=265) |
| Group Key: r_13.id, rvr_13.status, rsvr_13.status |
| -> Sort (cost=58.32..58.33 rows=2 width=12) |
| Sort Key: r_13.id, rvr_13.status, rsvr_13.status |
| -> Hash Left Join (cost=44.38..58.31 rows=2 width=12) |
| Hash Cond: (r_13.id = rsvr_13.erp_cost_convert_ticket_id) |
| Filter: (((rsvr_13.status <> 0) OR (rsvr_13.status IS NULL)) AND ((rvr_13.user_id = 1001) OR (rsvr_13.user_id = 1001))) |
| -> Hash Left Join (cost=22.19..35.33 rows=188 width=12) |
| Hash Cond: (r_13.id = rvr_13.erp_cost_convert_ticket_id) |
| Filter: ((rvr_13.status <> 0) OR (rvr_13.status IS NULL)) |
| -> Seq Scan on tbl_erp_cost_convert_tickets r_13 (cost=0.00..12.38 rows=189 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_cost_convert_ticket_verify_rels rvr_13 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_cost_convert_ticket_stop_verify_rels rsvr_13 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 15" (cost=58.52..58.56 rows=2 width=0) |
| -> Group (cost=58.52..58.54 rows=2 width=265) |
| Group Key: r_14.id, rvr_14.status, rsvr_14.status |
| -> Sort (cost=58.52..58.53 rows=2 width=12) |
| Sort Key: r_14.id, rvr_14.status, rsvr_14.status |
| -> Hash Left Join (cost=44.38..58.51 rows=2 width=12) |
| Hash Cond: (r_14.id = rsvr_14.erp_bank_transfer_ticket_id) |
| Filter: (((rsvr_14.status <> 0) OR (rsvr_14.status IS NULL)) AND ((rvr_14.user_id = 1001) OR (rsvr_14.user_id = 1001))) |
| -> Hash Left Join (cost=22.19..35.50 rows=198 width=12) |
| Hash Cond: (r_14.id = rvr_14.erp_bank_transfer_ticket_id) |
| Filter: ((rvr_14.status <> 0) OR (rvr_14.status IS NULL)) |
| -> Seq Scan on tbl_erp_bank_transfer_tickets r_14 (cost=0.00..12.50 rows=199 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_bank_transfer_ticket_verify_rels rvr_14 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_bank_transfer_ticket_stop_verify_rels rsvr_14 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 16" (cost=1060.18..1116.84 rows=2833 width=0) |
| -> HashAggregate (cost=1060.18..1088.51 rows=2833 width=265) |
| Group Key: r_15.id, rvr_15.status, rsvr_15.status |
| -> Hash Left Join (cost=649.83..1038.93 rows=2833 width=12) |
| Hash Cond: (r_15.id = rsvr_15.erp_cash_cost_ticket_id) |
| Filter: (((rsvr_15.status <> 0) OR (rsvr_15.status IS NULL)) AND ((rvr_15.user_id = 1001) OR (rsvr_15.user_id = 1001))) |
| -> Hash Right Join (cost=627.64..989.12 rows=7343 width=12) |
| Hash Cond: (rvr_15.erp_cash_cost_ticket_id = r_15.id) |
| Filter: ((rvr_15.status <> 0) OR (rvr_15.status IS NULL)) |
| -> Seq Scan on tbl_erp_cash_cost_ticket_verify_rels rvr_15 (cost=0.00..342.23 rows=7330 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=535.85..535.85 rows=7343 width=4) |
| -> Seq Scan on tbl_erp_cash_cost_tickets r_15 (cost=0.00..535.85 rows=7343 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_cash_cost_ticket_stop_verify_rels rsvr_15 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 17" (cost=58.09..58.13 rows=2 width=0) |
| -> Group (cost=58.09..58.11 rows=2 width=265) |
| Group Key: r_16.id, rvr_16.status, rsvr_16.status |
| -> Sort (cost=58.09..58.10 rows=2 width=12) |
| Sort Key: r_16.id, rvr_16.status, rsvr_16.status |
| -> Hash Left Join (cost=44.38..58.08 rows=2 width=12) |
| Hash Cond: (r_16.id = rsvr_16.erp_advance_payment_ticket_id) |
| Filter: (((rsvr_16.status <> 0) OR (rsvr_16.status IS NULL)) AND ((rvr_16.user_id = 1001) OR (rsvr_16.user_id = 1001))) |
| -> Hash Left Join (cost=22.19..35.16 rows=178 width=12) |
| Hash Cond: (r_16.id = rvr_16.erp_advance_payment_ticket_id) |
| Filter: ((rvr_16.status <> 0) OR (rvr_16.status IS NULL)) |
| -> Seq Scan on tbl_erp_advance_payment_tickets r_16 (cost=0.00..12.25 rows=179 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_advance_payment_ticket_verify_rels rvr_16 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_advance_payment_ticket_stop_verify_rels rsvr_16 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 18" (cost=57.89..57.93 rows=2 width=0) |
| -> Group (cost=57.89..57.91 rows=2 width=265) |
| Group Key: r_17.id, rvr_17.status, rsvr_17.status |
| -> Sort (cost=57.89..57.90 rows=2 width=12) |
| Sort Key: r_17.id, rvr_17.status, rsvr_17.status |
| -> Hash Left Join (cost=44.38..57.88 rows=2 width=12) |
| Hash Cond: (r_17.id = rsvr_17.erp_other_payment_ticket_id) |
| Filter: (((rsvr_17.status <> 0) OR (rsvr_17.status IS NULL)) AND ((rvr_17.user_id = 1001) OR (rsvr_17.user_id = 1001))) |
| -> Hash Left Join (cost=22.19..35.00 rows=168 width=12) |
| Hash Cond: (r_17.id = rvr_17.erp_other_payment_ticket_id) |
| Filter: ((rvr_17.status <> 0) OR (rvr_17.status IS NULL)) |
| -> Seq Scan on tbl_erp_other_payment_tickets r_17 (cost=0.00..12.12 rows=169 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_other_payment_ticket_verify_rels rvr_17 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_other_payment_ticket_stop_verify_rels rsvr_17 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 19" (cost=57.89..57.93 rows=2 width=0) |
| -> Group (cost=57.89..57.91 rows=2 width=265) |
| Group Key: r_18.id, rvr_18.status, rsvr_18.status |
| -> Sort (cost=57.89..57.90 rows=2 width=12) |
| Sort Key: r_18.id, rvr_18.status, rsvr_18.status |
| -> Hash Left Join (cost=44.38..57.88 rows=2 width=12) |
| Hash Cond: (r_18.id = rsvr_18.erp_other_collect_ticket_id) |
| Filter: (((rsvr_18.status <> 0) OR (rsvr_18.status IS NULL)) AND ((rvr_18.user_id = 1001) OR (rsvr_18.user_id = 1001))) |
| -> Hash Left Join (cost=22.19..35.00 rows=168 width=12) |
| Hash Cond: (r_18.id = rvr_18.erp_other_collect_ticket_id) |
| Filter: ((rvr_18.status <> 0) OR (rvr_18.status IS NULL)) |
| -> Seq Scan on tbl_erp_other_collect_tickets r_18 (cost=0.00..12.12 rows=169 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_other_collect_ticket_verify_rels rvr_18 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_other_collect_ticket_stop_verify_rels rsvr_18 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 20" (cost=81.30..81.37 rows=3 width=0) |
| -> Group (cost=81.30..81.34 rows=3 width=265) |
| Group Key: r_19.id, rvr_19.status, rsvr_19.status, rcvr_2.status |
| -> Sort (cost=81.30..81.31 rows=3 width=16) |
| Sort Key: r_19.id, rvr_19.status, rsvr_19.status, rcvr_2.status |
| -> Hash Left Join (cost=66.56..81.28 rows=3 width=16) |
| Hash Cond: (r_19.id = rcvr_2.erp_purchase_cost_id) |
| Filter: (((rcvr_2.status <> 0) OR (rcvr_2.status IS NULL)) AND ((rvr_19.user_id = 1001) OR (rsvr_19.user_id = 1001) OR (rcvr_2.user_id = 1001))) |
| -> Hash Left Join (cost=44.38..58.29 rows=187 width=20) |
| Hash Cond: (r_19.id = rsvr_19.erp_purchase_cost_id) |
| Filter: ((rsvr_19.status <> 0) OR (rsvr_19.status IS NULL)) |
| -> Hash Left Join (cost=22.19..35.33 rows=188 width=12) |
| Hash Cond: (r_19.id = rvr_19.erp_purchase_cost_id) |
| Filter: ((rvr_19.status <> 0) OR (rvr_19.status IS NULL)) |
| -> Seq Scan on tbl_erp_purchase_costs r_19 (cost=0.00..12.38 rows=189 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_purchase_cost_verify_rels rvr_19 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_purchase_cost_stop_verify_rels rsvr_19 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_purchase_cost_cancel_verify_rels rcvr_2 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 21" (cost=58.92..58.96 rows=2 width=0) |
| -> Group (cost=58.92..58.94 rows=2 width=265) |
| Group Key: r_20.id, rvr_20.status, rsvr_20.status |
| -> Sort (cost=58.92..58.93 rows=2 width=12) |
| Sort Key: r_20.id, rvr_20.status, rsvr_20.status |
| -> Hash Left Join (cost=44.38..58.91 rows=2 width=12) |
| Hash Cond: (r_20.id = rsvr_20.erp_wage_ticket_id) |
| Filter: (((rsvr_20.status <> 0) OR (rsvr_20.status IS NULL)) AND ((rvr_20.user_id = 1001) OR (rsvr_20.user_id = 1001))) |
| -> Hash Left Join (cost=22.19..35.82 rows=218 width=12) |
| Hash Cond: (r_20.id = rvr_20.erp_wage_ticket_id) |
| Filter: ((rvr_20.status <> 0) OR (rvr_20.status IS NULL)) |
| -> Seq Scan on tbl_erp_wage_tickets r_20 (cost=0.00..12.75 rows=219 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_wage_ticket_verify_rels rvr_20 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_wage_ticket_stop_verify_rels rsvr_20 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 22" (cost=58.92..58.96 rows=2 width=0) |
| -> Group (cost=58.92..58.94 rows=2 width=265) |
| Group Key: r_21.id, rvr_21.status, rsvr_21.status |
| -> Sort (cost=58.92..58.93 rows=2 width=12) |
| Sort Key: r_21.id, rvr_21.status, rsvr_21.status |
| -> Hash Left Join (cost=44.38..58.91 rows=2 width=12) |
| Hash Cond: (r_21.id = rsvr_21.erp_social_insurance_id) |
| Filter: (((rsvr_21.status <> 0) OR (rsvr_21.status IS NULL)) AND ((rvr_21.user_id = 1001) OR (rsvr_21.user_id = 1001))) |
| -> Hash Left Join (cost=22.19..35.82 rows=218 width=12) |
| Hash Cond: (r_21.id = rvr_21.erp_social_insurance_id) |
| Filter: ((rvr_21.status <> 0) OR (rvr_21.status IS NULL)) |
| -> Seq Scan on tbl_erp_social_insurances r_21 (cost=0.00..12.75 rows=219 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_social_insurance_verify_rels rvr_21 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_social_insurance_stop_verify_rels rsvr_21 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 23" (cost=58.92..58.96 rows=2 width=0) |
| -> Group (cost=58.92..58.94 rows=2 width=265) |
| Group Key: r_22.id, rvr_22.status, rsvr_22.status |
| -> Sort (cost=58.92..58.93 rows=2 width=12) |
| Sort Key: r_22.id, rvr_22.status, rsvr_22.status |
| -> Hash Left Join (cost=44.38..58.91 rows=2 width=12) |
| Hash Cond: (r_22.id = rsvr_22.erp_provident_fund_id) |
| Filter: (((rsvr_22.status <> 0) OR (rsvr_22.status IS NULL)) AND ((rvr_22.user_id = 1001) OR (rsvr_22.user_id = 1001))) |
| -> Hash Left Join (cost=22.19..35.82 rows=218 width=12) |
| Hash Cond: (r_22.id = rvr_22.erp_provident_fund_id) |
| Filter: ((rvr_22.status <> 0) OR (rvr_22.status IS NULL)) |
| -> Seq Scan on tbl_erp_provident_funds r_22 (cost=0.00..12.75 rows=219 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_provident_fund_verify_rels rvr_22 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_provident_fund_stop_verify_rels rsvr_22 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 24" (cost=58.92..58.96 rows=2 width=0) |
| -> Group (cost=58.92..58.94 rows=2 width=265) |
| Group Key: r_23.id, rvr_23.status, rsvr_23.status |
| -> Sort (cost=58.92..58.93 rows=2 width=12) |
| Sort Key: r_23.id, rvr_23.status, rsvr_23.status |
| -> Hash Left Join (cost=44.38..58.91 rows=2 width=12) |
| Hash Cond: (r_23.id = rsvr_23.erp_personal_tax_id) |
| Filter: (((rsvr_23.status <> 0) OR (rsvr_23.status IS NULL)) AND ((rvr_23.user_id = 1001) OR (rsvr_23.user_id = 1001))) |
| -> Hash Left Join (cost=22.19..35.82 rows=218 width=12) |
| Hash Cond: (r_23.id = rvr_23.erp_personal_tax_id) |
| Filter: ((rvr_23.status <> 0) OR (rvr_23.status IS NULL)) |
| -> Seq Scan on tbl_erp_personal_taxs r_23 (cost=0.00..12.75 rows=219 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_personal_tax_verify_rels rvr_23 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_personal_tax_stop_verify_rels rsvr_23 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 25" (cost=58.72..58.76 rows=2 width=0) |
| -> Group (cost=58.72..58.74 rows=2 width=265) |
| Group Key: r_24.id, rvr_24.status, rsvr_24.status |
| -> Sort (cost=58.72..58.73 rows=2 width=12) |
| Sort Key: r_24.id, rvr_24.status, rsvr_24.status |
| -> Hash Left Join (cost=44.38..58.71 rows=2 width=12) |
| Hash Cond: (r_24.id = rsvr_24.erp_wage_prize_id) |
| Filter: (((rsvr_24.status <> 0) OR (rsvr_24.status IS NULL)) AND ((rvr_24.user_id = 1001) OR (rsvr_24.user_id = 1001))) |
| -> Hash Left Join (cost=22.19..35.66 rows=208 width=12) |
| Hash Cond: (r_24.id = rvr_24.erp_wage_prize_id) |
| Filter: ((rvr_24.status <> 0) OR (rvr_24.status IS NULL)) |
| -> Seq Scan on tbl_erp_wage_prizes r_24 (cost=0.00..12.62 rows=209 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_wage_prize_verify_rels rvr_24 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_wage_prize_stop_verify_rels rsvr_24 (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |