sql查询
开发中
POST
https://api.flashcat.cloud/api/n9e/logs-query
最后修改时间：2026-02-02 09:23:32
请求参数
Header 参数
Body 参数application/json必填
返回响应
请求示例请求示例
Shell
JavaScript
Java
Swift
curl --location --request POST 'https://api.flashcat.cloud/api/n9e/logs-query' \
--header 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhY2Nlc3NfdXVpZCI6IjdjMGM4YmQyLTExOTYtNDlmYS04YzY0LWE0NDE2ODQ4NTUzYSIsImF1dGhvcml6ZWQiOnRydWUsImV4cCI6MTc0OTg4ODQ4MCwidXNlcl9pZGVudGl0eSI6IjEtcm9vdCJ9._S1Isb29viOhHyVrjbwIUjPZnNQXewmb4zftVeqbFpA' \
--header 'X-User-Token: <api-key>' \
--header 'Content-Type: application/json' \
--data-raw '{
"cate": "doris",
"datasource_id": 10049,
"query": [
{
"from": 1770020375,
"to": 1770023975,
"sql": "SELECT\n *\nFROM\n `db_insight_doris`.`ewall_event`\nWHERE\n (`event_status` = '\''warning'\'') AND $__timeFilter(`event_date`)\nORDER BY\n `event_date` DESC\nLIMIT\n 10"
}
]
}'响应示例响应示例
{
"dat": {
"total": 10,
"list": [
{
"created_at": "2026-02-02 17:19:36",
"data_source_id": 1008,
"data_source_name": "夜莺告警",
"data_source_type": "polaris.alert",
"description": "sss()",
"event_date": "2026-02-02 17:19:31",
"event_id": "9237783",
"event_key": "2fcb8e0addc1a88a60fe81f121a2445e",
"event_severity": "warning",
"event_status": "warning",
"event_type": "polaris.alert",
"id": 17653983,
"labels": "{\"anomaly_code\":\"数据中断\", \"anomaly_detection\":\"数据中断检测\", \"anomaly_params\":\"连续15分钟无数据\", \"business\":\"快猫业务\", \"business_id\":\"24\", \"check\":\"sss\", \"cluster\":\"zg_test_mysql\", \"group_id\":\"0\", \"identifier\":\"northstar_db91a18f9d\", \"metric\":\"组件部署量\", \"name\":\"sss\", \"prom_ql\":\"business=快猫业务 metric=组件部署量\", \"rule_id\":\"272\", \"rule_note\":\"\", \"rulename\":\"sss\", \"workspace\":\"默认空间\", \"workspace_id\":\"823147571215\"}",
"link": "http://10.99.1.106:9000/polaris/24?spaceId=823147571215&identifier=northstar_db91a18f9d",
"title": "business=快猫业务 metric=组件部署量/连续15分钟无数据"
},
{
"created_at": "2026-02-02 17:19:36",
"data_source_id": 1008,
"data_source_name": "夜莺告警",
"data_source_type": "polaris.alert",
"description": "sss()",
"event_date": "2026-02-02 17:19:31",
"event_id": "9237784",
"event_key": "c8ef4a993e85c5718759b91bb9e13c7e",
"event_severity": "warning",
"event_status": "warning",
"event_type": "polaris.alert",
"id": 17653984,
"labels": "{\"anomaly_code\":\"数据中断\", \"anomaly_detection\":\"数据中断检测\", \"anomaly_params\":\"连续15分钟无数据\", \"business\":\"快猫业务\", \"business_id\":\"24\", \"check\":\"sss\", \"cluster\":\"zabbix.history\", \"group_id\":\"0\", \"identifier\":\"northstar_e3cbdfee77\", \"metric\":\"ysy_join\", \"name\":\"sss\", \"prom_ql\":\"business=快猫业务 metric=ysy_join\", \"rule_id\":\"272\", \"rule_note\":\"\", \"rulename\":\"sss\", \"workspace\":\"默认空间\", \"workspace_id\":\"823147571215\"}",
"link": "http://10.99.1.106:9000/polaris/24?spaceId=823147571215&identifier=northstar_e3cbdfee77",
"title": "business=快猫业务 metric=ysy_join/连续15分钟无数据"
},
{
"created_at": "2026-02-02 17:19:36",
"data_source_id": 1008,
"data_source_name": "夜莺告警",
"data_source_type": "polaris.alert",
"description": "sss()",
"event_date": "2026-02-02 17:19:31",
"event_id": "9237781",
"event_key": "0202422e4df375dd42c7a1575a8aee4a",
"event_severity": "warning",
"event_status": "warning",
"event_type": "polaris.alert",
"id": 17653981,
"labels": "{\"anomaly_code\":\"数据中断\", \"anomaly_detection\":\"数据中断检测\", \"anomaly_params\":\"连续15分钟无数据\", \"business\":\"快猫业务\", \"business_id\":\"24\", \"check\":\"sss\", \"cluster\":\"ysy_do_not_delete\", \"group_id\":\"0\", \"identifier\":\"northstar_9e1fe522e7\", \"metric\":\"ysy_join_by_2dbs\", \"name\":\"sss\", \"prom_ql\":\"business=快猫业务 metric=ysy_join_by_2dbs\", \"rule_id\":\"272\", \"rule_note\":\"\", \"rulename\":\"sss\", \"workspace\":\"默认空间\", \"workspace_id\":\"823147571215\"}",
"link": "http://10.99.1.106:9000/polaris/24?spaceId=823147571215&identifier=northstar_9e1fe522e7",
"title": "business=快猫业务 metric=ysy_join_by_2dbs/连续15分钟无数据"
},
{
"created_at": "2026-02-02 17:19:36",
"data_source_id": 1008,
"data_source_name": "夜莺告警",
"data_source_type": "polaris.alert",
"description": "sss()",
"event_date": "2026-02-02 17:19:31",
"event_id": "9237782",
"event_key": "000868d11671e389a0ead1dc83060932",
"event_severity": "warning",
"event_status": "warning",
"event_type": "polaris.alert",
"id": 17653982,
"labels": "{\"anomaly_code\":\"数据中断\", \"anomaly_detection\":\"数据中断检测\", \"anomaly_params\":\"连续15分钟无数据\", \"business\":\"快猫业务\", \"business_id\":\"24\", \"check\":\"sss\", \"cluster\":\"present_do_not_update\", \"group_id\":\"0\", \"identifier\":\"zabbix_history_cnt\", \"metric\":\"zabbix指标收集数量\", \"name\":\"sss\", \"prom_ql\":\"business=快猫业务 metric=zabbix指标收集数量\", \"rule_id\":\"272\", \"rule_note\":\"\", \"rulename\":\"sss\", \"workspace\":\"默认空间\", \"workspace_id\":\"823147571215\"}",
"link": "http://10.99.1.106:9000/polaris/24?spaceId=823147571215&identifier=zabbix_history_cnt",
"title": "business=快猫业务 metric=zabbix指标收集数量/连续15分钟无数据"
},
{
"created_at": "2026-02-02 17:19:36",
"data_source_id": 1008,
"data_source_name": "夜莺告警",
"data_source_type": "n9e.alert",
"description": "test(185.97M)",
"event_date": "2026-02-02 17:19:29",
"event_id": "9237773",
"event_key": "b64079fd4910c8fb4ac20a60d6037f11",
"event_severity": "warning",
"event_status": "warning",
"event_type": "n9e.alert",
"id": 17653973,
"labels": "{\"__name__\":\"cnt\", \"check\":\"test\", \"cluster\":\"doris-10.99.1.251测试环境\", \"group_id\":\"44\", \"metric\":\"cnt\", \"prom_ql\":\"query:[map[database:flashcat_log keys:map[valueKey:cnt] offset:0 prom_ql: ref:A severity:3 sql:select count(*) as cnt from log_table unit:sishort]] trigger:{Expressions:[map[comparisonOperator:u003e logicalOperator:u0026u0026 ref:A value:0]] Mode:0 Exp:$A u003e 0 Severity:2 Type: Duration:0 Percent:0 Joins:[] JoinRef:A RecoverConfig:{JudgeType:0 RecoverExp:}}\", \"rule_id\":\"1046\", \"rule_note\":\"\", \"rulename\":\"test\"}",
"link": "http://10.99.1.106:9000/alert-his-events/9237773",
"title": "doris-10.99.1.251测试环境 / test - [__name__=cnt, rulename=test]"
},
{
"created_at": "2026-02-02 17:19:36",
"data_source_id": 1008,
"data_source_name": "夜莺告警",
"data_source_type": "firemap.alert",
"description": "持续生成一条告警事件(指标1:4)",
"event_date": "2026-02-02 17:19:27",
"event_id": "9237768",
"event_key": "8eb7f6d6974f814cce0bd7ea3a8fca99",
"event_severity": "warning",
"event_status": "warning",
"event_type": "firemap.alert",
"id": 17653968,
"labels": "{\"business\":\"Prometheus卡片\", \"business_group\":\"系统\", \"business_id\":\"3167\", \"card\":\"新增一个卡片交给fc-alert执行\", \"card_group\":\"测试snapshot encode\", \"card_group_id\":\"98414\", \"card_id\":\"24191\", \"check\":\"持续生成一条告警事件\", \"cluster\":\"prometheus_categraf_flasheye\", \"group_id\":\"0\", \"level_type\":\"function\", \"page_type\":\"function\", \"prom_ql\":\"Prometheus卡片-u003e测试snapshot encode-u003e新增一个卡片交给fc-alert执行\", \"rule_id\":\"833\", \"rule_note\":\"\", \"rulename\":\"持续生成一条告警事件\", \"workspace\":\"研发自测\", \"workspace_id\":\"893594101777\"}",
"link": "http://10.99.1.106:9000/firemap/function/3167?spaceId=893594101777&time=1770023880&groupId=98414&cardId=24191&level2ViewMode=card",
"title": "Prometheus卡片->测试snapshot encode->新增一个卡片交给fc-alert执行/指标1>95 || 指标1<95"
},
{
"created_at": "2026-02-02 17:19:26",
"data_source_id": 1008,
"data_source_name": "夜莺告警",
"data_source_type": "n9e.alert",
"description": "categraf_prometheus_sd_kubernetes_events_total(0.00)",
"event_date": "2026-02-02 17:19:22",
"event_id": "9237753",
"event_key": "e372f7f865cae5f8d460198ed89bf8c3",
"event_severity": "warning",
"event_status": "warning",
"event_type": "n9e.alert",
"id": 17653956,
"labels": "{\"__name__\":\"categraf_prometheus_sd_kubernetes_events_total\", \"agent_hostname\":\"dev-flasheye-02\", \"check\":\"categraf_prometheus_sd_kubernetes_events_total\", \"cluster\":\"Flashcat_metrics\", \"event\":\"update\", \"group_id\":\"56\", \"metric\":\"categraf_prometheus_sd_kubernetes_events_total\", \"prom_ql\":\"categraf_prometheus_sd_kubernetes_events_totalu003c5\", \"role\":\"node\", \"rule_id\":\"903\", \"rule_note\":\"\", \"rulename\":\"categraf_prometheus_sd_kubernetes_events_total\", \"version\":\"ent-v0.3.133-502af232dc4dc582ef1f70d5868710039a649362-dirty\"}",
"link": "http://10.99.1.106:9000/alert-his-events/9237753",
"title": "Flashcat_metrics / categraf_prometheus_sd_kubernetes_events_total - [agent_hostname=dev-flasheye-02, event=update, role=node]"
},
{
"created_at": "2026-02-02 17:19:26",
"data_source_id": 1008,
"data_source_name": "夜莺告警",
"data_source_type": "n9e.alert",
"description": "categraf_prometheus_sd_kubernetes_events_total(0.00)",
"event_date": "2026-02-02 17:19:22",
"event_id": "9237763",
"event_key": "172f125bf1a17b65674df6de02a92c9e",
"event_severity": "warning",
"event_status": "warning",
"event_type": "n9e.alert",
"id": 17653964,
"labels": "{\"__name__\":\"categraf_prometheus_sd_kubernetes_events_total\", \"agent_hostname\":\"dev-flasheye-02\", \"check\":\"categraf_prometheus_sd_kubernetes_events_total\", \"cluster\":\"Flashcat_metrics\", \"event\":\"delete\", \"group_id\":\"56\", \"metric\":\"categraf_prometheus_sd_kubernetes_events_total\", \"prom_ql\":\"categraf_prometheus_sd_kubernetes_events_totalu003c5\", \"role\":\"service\", \"rule_id\":\"903\", \"rule_note\":\"\", \"rulename\":\"categraf_prometheus_sd_kubernetes_events_total\", \"version\":\"ent-v0.3.133-502af232dc4dc582ef1f70d5868710039a649362-dirty\"}",
"link": "http://10.99.1.106:9000/alert-his-events/9237763",
"title": "Flashcat_metrics / categraf_prometheus_sd_kubernetes_events_total - [agent_hostname=dev-flasheye-02, event=delete, role=service]"
},
{
"created_at": "2026-02-02 17:19:26",
"data_source_id": 1008,
"data_source_name": "夜莺告警",
"data_source_type": "n9e.alert",
"description": "categraf_prometheus_sd_kubernetes_events_total(0.00)",
"event_date": "2026-02-02 17:19:22",
"event_id": "9237765",
"event_key": "9d3233035863c015c65ffcf237e2cd69",
"event_severity": "warning",
"event_status": "warning",
"event_type": "n9e.alert",
"id": 17653961,
"labels": "{\"__name__\":\"categraf_prometheus_sd_kubernetes_events_total\", \"agent_hostname\":\"dev-flasheye-02\", \"check\":\"categraf_prometheus_sd_kubernetes_events_total\", \"cluster\":\"Flashcat_metrics\", \"event\":\"add\", \"group_id\":\"56\", \"metric\":\"categraf_prometheus_sd_kubernetes_events_total\", \"prom_ql\":\"categraf_prometheus_sd_kubernetes_events_totalu003c5\", \"role\":\"ingress\", \"rule_id\":\"903\", \"rule_note\":\"\", \"rulename\":\"categraf_prometheus_sd_kubernetes_events_total\", \"version\":\"ent-v0.3.133-502af232dc4dc582ef1f70d5868710039a649362-dirty\"}",
"link": "http://10.99.1.106:9000/alert-his-events/9237765",
"title": "Flashcat_metrics / categraf_prometheus_sd_kubernetes_events_total - [agent_hostname=dev-flasheye-02, event=add, role=ingress]"
},
{
"created_at": "2026-02-02 17:19:26",
"data_source_id": 1008,
"data_source_name": "夜莺告警",
"data_source_type": "n9e.alert",
"description": "categraf_prometheus_sd_kubernetes_events_total(0.00)",
"event_date": "2026-02-02 17:19:22",
"event_id": "9237760",
"event_key": "5fc75809525a4db5997e023de0268f05",
"event_severity": "warning",
"event_status": "warning",
"event_type": "n9e.alert",
"id": 17653960,
"labels": "{\"__name__\":\"categraf_prometheus_sd_kubernetes_events_total\", \"agent_hostname\":\"dev-flasheye-02\", \"check\":\"categraf_prometheus_sd_kubernetes_events_total\", \"cluster\":\"Flashcat_metrics\", \"event\":\"update\", \"group_id\":\"56\", \"metric\":\"categraf_prometheus_sd_kubernetes_events_total\", \"prom_ql\":\"categraf_prometheus_sd_kubernetes_events_totalu003c5\", \"role\":\"pod\", \"rule_id\":\"903\", \"rule_note\":\"\", \"rulename\":\"categraf_prometheus_sd_kubernetes_events_total\", \"version\":\"ent-v0.3.133-502af232dc4dc582ef1f70d5868710039a649362-dirty\"}",
"link": "http://10.99.1.106:9000/alert-his-events/9237760",
"title": "Flashcat_metrics / categraf_prometheus_sd_kubernetes_events_total - [agent_hostname=dev-flasheye-02, event=update, role=pod]"
}
]
},
"err": ""
}
微信扫码交流修改于 2026-02-02 09:23:32