GaussDB(DWS)数据库智能监控运维服务体系指标设计 - 查询监控

原始采集项

采集说明

页面呈现

概览页面

聚合指标说明

查询详情

查询详情条目说明

openAPI （华为云未上线）

/v1/{project_id}/dms/clusters/{cluster_id}/query

{
  "queries": [
    {
      "query": "select  count(*) \r\nfrom store_sales\r\n    ,household_demographics \r\n    ,time_dim, store\r\nwhere ss_sold_time_sk = time_dim.t_time_sk   \r\n    and ss_hdemo_sk = household_demographics.hd_demo_sk \r\n    and ss_store_sk = s_store_sk\r\n    and time_dim.t_hour = 8\r\n    and time_dim.t_minute >= 30\r\n    and household_demographics.hd_dep_count = 5\r\n    and store.s_store_name = 'ese'\r\norder by count(*)\r\nlimit 100;",
      "max_cpu_time": 0,
      "min_cpu_time": 0,
      "total_cpu_time": 0,
      "cpu_skew": 0,
      "max_peak_mem": 11,
      "min_peak_mem": 11,
      "avg_peak_mem": 11,
      "mem_skew": 0,
      "max_spill_size": 0,
      "min_spill_size": 0,
      "avg_spill_size": 0,
      "spill_skew": 0,
      "max_peak_iops": 0,
      "min_peak_iops": 0,
      "avg_peak_iops": 0,
      "iops_skew": 0,
      "db_name": "test",
      "application": "gsql",
      "query_id": "79657418412457882"
    },
    {
      "query": "WITH web_v1 as (\r\nselect\r\n  ws_item_sk item_sk, d_date,\r\n  sum(sum(ws_sales_price))\r\n      over (partition by ws_item_sk order by d_date rows between unbounded preceding and current row) cume_sales\r\nfrom web_sales\r\n    ,date_dim\r\nwhere ws_sold_date_sk=d_date_sk\r\n  and d_month_seq between 1212 and 1212+11\r\n  and ws_item_sk is not NULL\r\ngroup by ws_item_sk, d_date),\r\nstore_v1 as (\r\nselect\r\n  ss_item_sk item_sk, d_date,\r\n  sum(sum(ss_sales_price))\r\n      over (partition by ss_item_sk order by d_date rows between unbounded preceding and current row) cume_sales\r\nfrom store_sales\r\n    ,date_dim\r\nwhere ss_sold_date_sk=d_date_sk\r\n  and d_month_seq between 1212 and 1212+11\r\n  and ss_item_sk is not NULL\r\ngroup by ss_item_sk, d_date)\r\n select  *\r\nfrom (select item_sk\r\n     ,d_date\r\n     ,web_sales\r\n     ,store_sales\r\n     ,max(web_sales)\r\n         over (partition by item_sk order by d_date rows between unbounded preceding and current row) web_cumulative\r\n     ,max(store_sales)\r\n         over (partition by item_sk order by d_date rows between unbounded preceding and current row) store_cumulative\r\n     from (select case when web.item_sk is not null then web.item_sk else store.item_sk end item_sk\r\n                 ,case when web.d_date is not null then web.d_date else store.d_date end d_date\r\n                 ,web.cume_sales web_sales\r\n                 ,store.cume_sales store_sales\r\n           from web_v1 web full outer join store_v1 store on (web.item_sk = store.item_sk\r\n                                                          and web.d_date = store.d_date)\r\n          )x )y\r\nwhere web_cumulative > store_cumulative\r\norder by item_sk\r\n        ,d_date\r\nlimit 100;",
      "max_cpu_time": 487,
      "min_cpu_time": 1,
      "total_cpu_time": 1435,
      "cpu_skew": 50,
      "max_peak_mem": 37,
      "min_peak_mem": 21,
      "avg_peak_mem": 28,
      "mem_skew": 24,
      "max_spill_size": 0,
      "min_spill_size": 0,
      "avg_spill_size": 0,
      "spill_skew": 0,
      "max_peak_iops": 0,
      "min_peak_iops": 0,
      "avg_peak_iops": 0,
      "iops_skew": 0,
      "db_name": "test",
      "application": "gsql",
      "query_id": "79657418412457869"
    }
  ],
  "timestamp": 1616679496270,
  "cluster_id": "9c11a33a-64e6-40c1-93bd-01b2255b2228"
}

想了解GuassDB(DWS)更多信息，欢迎微信搜索“GaussDB DWS”关注微信公众号，和您分享最新最全的PB级数仓黑科技，后台还可获取众多学习资料哦~