| Sort (cost=10.55..10.55 rows=1 width=816) |
| Sort Key: u.pinyin1, u.namecut1, u.pinyin2, u.namecut2, u.pinyin3, u.namecut3, u.pinyin4, u.namecut4 |
| -> Group (cost=10.47..10.54 rows=1 width=816) |
| Group Key: u.id, sg.m1_budget, sg.m2_budget, sg.m3_budget, sg.m4_budget, sg.m5_budget, sg.m6_budget, sg.m7_budget, sg.m8_budget, sg.m9_budget, sg.m10_budget, sg.m11_budget, sg.m12_budget, sg.m1_profit, sg.m2_profit, sg.m3_profit, sg.m4_profit, sg.m5_profit, sg.m6_profit, sg.m7_profit, sg.m8_profit, sg.m9_profit, sg.m10_profit, sg.m11_profit, sg.m12_profit |
| -> Sort (cost=10.47..10.48 rows=1 width=812) |
| Sort Key: sg.m1_budget, sg.m2_budget, sg.m3_budget, sg.m4_budget, sg.m5_budget, sg.m6_budget, sg.m7_budget, sg.m8_budget, sg.m9_budget, sg.m10_budget, sg.m11_budget, sg.m12_budget, sg.m1_profit, sg.m2_profit, sg.m3_profit, sg.m4_profit, sg.m5_profit, sg.m6_profit, sg.m7_profit, sg.m8_profit, sg.m9_profit, sg.m10_profit, sg.m11_profit, sg.m12_profit |
| -> Nested Loop Left Join (cost=0.00..10.46 rows=1 width=812) |
| Join Filter: (sgr.user_id = u.id) |
| -> Seq Scan on tbl_users u (cost=0.00..7.76 rows=1 width=44) |
| Filter: (id = 1001) |
| -> Nested Loop (cost=0.00..2.69 rows=1 width=772) |
| Join Filter: (sgr.sales_goal_id = sg.id) |
| -> Seq Scan on tbl_sales_goal_rels sgr (cost=0.00..1.52 rows=1 width=8) |
| Filter: (user_id = 1001) |
| -> Seq Scan on tbl_sales_goals sg (cost=0.00..1.15 rows=1 width=772) |
| Filter: ((id IS NOT NULL) AND (goal_year = '2025'::smallint)) |