执行一个简单的查询，耗时非常久，请教各位专家大佬，这是为什么呢？需要怎么排查优化？以下是profile。
Query:
Summary:
- Query ID: 1e41c048-334c-11ed-b108-00163e14e443
- Start Time: 2022-09-13 18:09:13
- End Time: 2022-09-13 18:09:25
- Total: 11s562ms
- Query Type: Query
- Query State: EOF
- StarRocks Version: 2.3.0
- User: xxxx
- Default Db: xxxx:xxxx
- Sql Statement: /* ApplicationName=DBeaver 22.0.3 - SQLEditor <script-6.sql> */ SELECT tenant_id, id, server_id, name, alias, account, pwd, country_id, currency_id, disabled, pu_dear, ticket_dear, review, invitation_review, feedback, invitation_feedback, invitation_mfn, fee_vat, selling, fee_report, traffice, shipment, returns, inventory, session, subscript_offer_change, ads, holiday_reply_email, ignore_order_invitation_date_befor, order_incitation_email2, add_date, others, disable_Subaccounts, ads_code, ads_state, api_state, ses_auth_status, public_token, refresh_token, ads_unauthorized_count, encrypt_flag, auth_type, create_time, update_time, delete_state, db, table, ts_ms
FROM xxxx.xxxx
LIMIT 0, 200
- QueryCpuCost: 4ms
- QueryMemCost: 5.906MB
- Variables: parallel_fragment_exec_instance_num=8,pipeline_dop=0
- Collect Profile Time: 2s0ms
Planner:
- Total: 1ms / 1
Execution Profile 1e41c048-334c-11ed-b108-00163e14e443:(Active: 11s558ms[11558552006ns], % non-child: 100.00%)
Fragment 0:
- BackendNum: 1
Instance 1e41c048-334c-11ed-b108-00163e14e447 (host=TNetworkAddress(hostname:xxxx, port:9060)):
Fragment 1:
- BackendNum: 3
Instance 1e41c048-334c-11ed-b108-00163e14e444 (host=TNetworkAddress(hostname:xxxx, port:9060)):
Instance 1e41c048-334c-11ed-b108-00163e14e445 (host=TNetworkAddress(hostname:xxxx, port:9060)):
Instance 1e41c048-334c-11ed-b108-00163e14e446 (host=TNetworkAddress(hostname:xxxx, port:9060)):
</script-6.sql>