#  O11y statements sql 
## 1. 使用curl抓取指定时间段内所有的数据，生成文件json文件
### 1.1 命令
curl -G 'https://clinic.pingcap.com/ngm/api/v1/statements/list' \
  --data-urlencode 'begin_time=1756111200' \
  --data-urlencode 'end_time=1756114800' \
  --data-urlencode 'fields=digest_text,sum_latency,avg_latency,max_latency,min_latency,exec_count,plan_count,schema_name' \
  --data-urlencode 'text=' \
  -H 'Accept: application/json, text/plain, */*' \
  -H 'User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36' \
  -H 'x-cluster-id: 10218000100066887827' \
  -H 'x-csrf-token: vWXqa7laee3vDI0R' \
  -H 'x-deploy-type: dedicated' \
  -H 'x-org-id: 1372813089209061633' \
  -H 'x-project-id: 1372813089454544954' \
  -H 'x-provider: aws' \
  -H 'x-region: us-east-1' \
  -H 'Referer: https://clinic.pingcap.com/portal/dashboard/cloud/ngm.html?provider=aws&region=us-east-1&orgName=Buffet%27s%20Org&orgId=1372813089209061633&projectId=1372813089454544954&clusterId=1379661944646416027&clusterName=prod-us-saas-region01-tidb-v75&deployType=dedicated' \
  -H 'Cookie: _gcl_au=1.1.1237103435.1751536543; _ga=GA1.1.1641060396.1751536543; hubspotutk=8011e37a441a4e81ca095aa387c52f04; Hm_lvt_51f740f561d61c4b58220327215136bf=1753372173,1754357489; HMACCOUNT=D81AD1525176C9AB; Hm_lvt_495aa576958489d83f7053886babd22e=1753372173,1754357489; __hssrc=1; Hm_lpvt_51f740f561d61c4b58220327215136bf=1754639497; Hm_lpvt_495aa576958489d83f7053886babd22e=1754639497; _clck=7apexj%7C2%7Cfya%7C0%7C2031; _ga_8HPPX9V3E9=GS2.1.s1754639496$o6$g1$t1754639507$j49$l0$h0; __hstc=86493575.8011e37a441a4e81ca095aa387c52f04.1751536573507.1755230772337.1755497729479.17; _ga_ZEL0RNV6R2=GS2.1.s1755497752$o23$g1$t1755497753$j59$l0$h0; _ga_BQ970DC3WX=GS2.1.s1755584875$o28$g1$t1755584875$j60$l0$h0; _ga_3JVXJ41175=GS2.1.s1755584876$o33$g0$t1755584876$j60$l0$h311525887; _ga_CPG2VW1Y41=GS2.1.s1755584876$o27$g0$t1755584876$j60$l0$h0; clinic.session_id=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHAiOjE3NTYxOTI5OTQsInVzZXIiOnsiZW1haWwiOiJsZXRpYW4ud2FuZ0BwaW5nY2FwLmNvbSIsInVzZXJuYW1lIjoibGV0aWFuLndhbmdAcGluZ2NhcC5jb20iLCJjc3JmVG9rZW4iOiJ5dTM3RjNUQ252a29Yc29xIn19.J8K51yL_QGwdpYSTmnQP9rbDxQ5-GcJak6X6DjI9R9U' \
| tee statements_saas_0825.json

### 结果示例
statements_saas_0825.json 
- exec_count字段为执行次数
[
    {
        "summary_begin_time": 1756115098,
        "summary_end_time": 1756116913,
        "digest_text": "commit",
        "digest": "9505cacb7c710ed17125fcc6cb3669e8ddca6c8cd8af6a31f6b3cd64604c3098",
        "exec_count": 5340,
        "sum_latency": 59601654919,
        "max_latency": 90917936,
        "min_latency": 52538,
        "avg_latency": 11161358,
        "schema_name": "dh_app_7980",
        "plan_count": 1
    },
    {
        "summary_begin_time": 1756115098,
        "summary_end_time": 1756116913,
        "digest_text": "select `a` . `id` , `a` . `site_code` , `a` . `useridx` , `a` . `username` , `a` . `realname_secret` , `a` . `account_type` , `a` . `user_status` , `a` . `game_gold` , `a` . `member_level` , `a` . `vip_level` , `a` . `register_time` , `a` . `regpkgid` , `a` . `register_ip` , `a` . `register_ip_addr` , `a` . `register_device_id` , `a` . `verify_time` , `a` . `birthday_secret` , `a` . `area_code` , `a` . `phone_hash` , `a` . `restrict_flag` , `b` . `currency` , `c` . `email_verify_time` , `c` . `third_user_id` , `d` . `login_id` , `d` . `login_os_type` , `d` . `last_login_ip_addr` , `d` . `register_browser_finger_id` , `d` . `login_device_model` , `d` . `has_app_login` , `d` . `last_login_time` , if ( `isnull` ( `p` . `useridx` ) , ... ) `agent_type` from `dh_account_basic` `a` inner join `dh_account_ext_financeinfo` `b` on `a` . `useridx` = `b` . `useridx` and `a` . `site_code` = `b` . `site_code` inner join `dh_account_ext_authinfo` `c` on `a` . `useridx` = `c` . `useridx` and `a` ....",
        "digest": "a132424079ac2d4e2c3cead9bce3d5e96a97a315a309ef593384ee35c0f392a9",
        "exec_count": 284,
        "sum_latency": 55388300129,
        "max_latency": 290838713,
        "min_latency": 154474207,
        "avg_latency": 195029225,
        "schema_name": "dh_app_8292",
        "plan_count": 4
    }
]