Method

GET

参数说明

参数名

必填

描述

默认值

access_token

必填

task_id

必填

服务监控项目ID

start_date

选填

开始时间[2016-03-03]

默认返回当天全部数据

end_date

选填

结束时间[2016-03-03]

返回结果说明：

Apache

{

  "apache": {

    "list": [

      {

          "check_date": "2016-03-01",

        "rps_avg":   "1.49",

        "rps_max":   4.5,

        "rps_min":   0.27,

          "curr_reqs_avg": "6.58",

          "curr_reqs_max": 28,

          "curr_reqs_min": 1

      }

    ],

    "statistic": {

      "rps_avg":   "1.49",

      "rps_max":   "4.50",

        "curr_reqs_avg": "6.58",

      "curr_reqs_max":   "28.00"

    }

  }

}

Nginx

{

  "nginx": {

    "list": [

      {

          "check_date": "2016-03-01",

        "rps_avg":   "0.28",

        "rps_max":   0.31,

        "rps_min":   0.27,

          "curr_reqs_avg": "1.00",

          "curr_reqs_max": 1,

          "curr_reqs_min": 1

      }

    ],

    "statistic": {

      "rps_avg":   "0.28",

      "rps_max":   "0.31",

        "curr_reqs_avg": "1.00",

        "curr_reqs_max": "1.00"

    }

  }

}

Lighttpd

{

  "lighttpd": {

    "list": [

      {

          "check_date": "2016-03-04",

        "rps_avg":   "0.00",

        "rps_max":   1,

        "rps_min":   0,

          "curr_reqs_avg": "1.43",

          "curr_reqs_max": 16,

          "curr_reqs_min": 1

      }

    ],

    "statistic": {

      "rps_avg":   "0.00",

      "rps_max":   "1.00",

        "curr_reqs_avg": "1.43",

        "curr_reqs_max": "16.00"

    }

  }

}

Memcache

{

  "memcache": {

    "list": [

      {

          "check_date": "2015-11-27",

          "curr_connections_min": 110,

        "curr_connections_avg":   "115.81",

          "curr_connections_max": 117,

          "bytes_min": 38.6,

          "bytes_avg": "38.60",

          "bytes_max": 38.63,

          "keyspace_ratio_min": 0,

          "keyspace_ratio_avg": "0.00",

          "keyspace_ratio_max": 0,

          "curr_items_min": 88495,

          "curr_items_avg": "88534.77",

          "curr_items_max": 88575,

          "mem_ratio_min": 3.77,

          "mem_ratio_avg": "3.77",

          "mem_ratio_max": 3.77

      }

    ],

    "statistic": {

      "version":   "1.4.20",

      "uptime":   "483.56",

        "limit_maxbytes": "1024.00",

        "keyspace_ratio_avg": "0.00",

        "keyspace_ratio_max": "0.00",

      "bytes_avg":   "38.60",

      "bytes_max":   "38.63",

        "curr_connections_avg": "115.81",

        "curr_connections_max": "117.00",

        "connected_sec_avg": "0.10",

        "connected_sec_max": "0.78",

        "curr_items_avg": "88534.77",

        "curr_items_max": "88575.00",

        "read_sec_avg": "0.01",

        "read_sec_max": "0.17",

        "write_sec_avg": "0.00",

        "write_sec_max": "0.00",

        "mem_ratio_avg": "3.77",

        "mem_ratio_max": "3.77"

    }

  }

}

MongoDB

{

  "mongodb": {

    "list": [

      {

          "check_date": "2015-11-27",

          "connections_current_min": 3015,

          "connections_current_avg": "9932.74",

          "connections_current_max": 18082,

          "globalLock_ratio_min": 0,

          "globalLock_ratio_avg": "0.00",

          "globalLock_ratio_max": 0,

          "page_faults_sec_min": 19,

        "page_faults_sec_avg":   "259.00",

          "page_faults_sec_max": 7667,

          "indexCounters_missRatio_min": 0,

          "indexCounters_missRatio_avg": "0.00",

          "indexCounters_missRatio_max": 0,

          "indexCounters_btree_accesses_sec_min": 0,

          "indexCounters_btree_accesses_sec_avg": "0.00",

          "indexCounters_btree_accesses_sec_max": 0

      }

    ],

    "statistic": {

      "version":   "2.4.3",

      "host":   "localhost.localdomain",

      "uptime":   "82.08",

        "mongodb_connections_current": {

          "connections_current_avg": "9932.74",

          "connections_current_max": "18082.00"

      }

    }

  }

}

MySQL

{

  "mysql": {

    "list": [

      {

          "check_date": "2016-03-23",

          "Connections_min": 24.36,

          "Connections_avg": "29.15",

          "Connections_max": 36.35,

          "Bytes_received_min": "11.51",

          "Bytes_received_avg": "14.73",

          "Bytes_received_max": "19.10",

          "Bytes_sent_min": "91.73",

          "Bytes_sent_avg": "103.44",

          "Bytes_sent_max": "122.73",

          "Threads_connected_min": 17,

          "Threads_connected_avg": "19.52",

          "Threads_connected_max": 27

      }

    ],

    "statistic": {

        "mysql_query_detail": {

        "Com_change_db_avg":   "36.15",

          "Com_change_db_max": "46.06",

          "Com_select_avg": "28.10",

          "Com_select_max": "31.44",

          "Com_insert_avg": "1.23",

          "Com_insert_max": "5.36",

          "Com_update_avg": "4.32",

        "Com_update_max":   "7.66",

          "Com_delete_avg": "0.00",

          "Com_delete_max": "0.01"

      },

        "mysql_qcache_querysum": {

          "query_cache_size": "128.00",

          "query_cache_limit": "1024.00"

      },

        "mysql_kcache_querysum": {

          "key_buffer_size": "2048.00"

      },

        "mysql_connps": {

          "Connections_avg": "29.15",

          "Connections_max": "36.35",

          "Threads_created_avg": "0.00",

          "Threads_created_max": "0.00",

          "thread_cache_size": "256",

          "max_connections": "1024"

      },

        "mysql_traffic": {

          "Bytes_received_avg": "14.73",

          "Bytes_received_max": "19.10",

          "Bytes_sent_avg": "103.44",

          "Bytes_sent_max": "122.73"

      }

    }

  }

}

Redis

{

  "redis": {

    "list": [

      {

          "check_date": "2015-12-11",

          "connected_sec_min": 61,

          "connected_sec_avg": "73.77",

          "connected_sec_max": 90,

          "keyspace_ratio_min": 85.04,

          "keyspace_ratio_avg": "94.46",

          "keyspace_ratio_max": 99.93,

          "used_memory_min": 3825.72,

          "used_memory_avg": "3842.02",

          "used_memory_max": 3859.45,

          "connected_clients_min": 1020,

          "connected_clients_avg": "1020.35",

          "connected_clients_max": 1022,

          "blocked_clients_min": 0,

          "blocked_clients_avg": "0.00",

          "blocked_clients_max": 0,

          "pubsub_channels_min": 0,

          "pubsub_channels_avg": "0.00",

          "pubsub_channels_max": 0,

          "pubsub_patterns_min": 0,

          "pubsub_patterns_avg": "0.00",

          "pubsub_patterns_max": 0

      }

    ],

    "statistic": {

        "redis_version": "2.8.1",

        "uptime_in_days": 802,

        "changes_since_last_save": null,

        "used_memory_avg": "3842.02",

        "used_memory_max": "3859.45",

        "commands_sec_avg": "154046.57",

        "commands_sec_max": "582631.00",

        "keyspace_ratio_avg": "94.46",

        "keyspace_ratio_max": "99.93",

        "connected_clients_avg": "1020.35",

        "connected_clients_max": "1022.00",

        "connected_sec_avg": "73.77",

        "connected_sec_max": "90.00",

        "blocked_clients_avg": "0.00",

        "blocked_clients_max": "0.00",

        "pubsub_channels_avg": "0.00",

        "pubsub_channels_max": "0.00",

      "pubsub_patterns_avg":   "0.00",

        "pubsub_patterns_max": "0.00"

    }

  }

}

Tomcat

{

  "tomcat": {

    "list": [

      {

          "check_date": "2015-07-30",

          "free_memory_min": 786.41,

          "free_memory_avg": "786.41",

          "free_memory_max": 786.41,

          "total_memory_min": 2045,

          "total_memory_avg": "2045.00",

          "total_memory_max": 2045,

          "max_memory_min": 3925.5,

          "max_memory_avg": "3925.50",

          "max_memory_max": 3925.5,

          "processing_time_sec_min": 0,

        "processing_time_sec_avg":   "0.00",

          "processing_time_sec_max": 0,

          "request_count_sec_min": 0,

          "request_count_sec_avg": "0.00",

          "request_count_sec_max": 0,

          "bytes_received_sec_min": 0,

          "bytes_received_sec_avg": "0.00",

          "bytes_received_sec_max": 0,

          "bytes_sent_sec_min": 0,

          "bytes_sent_sec_avg": "0.00",

          "bytes_sent_sec_max": 0

      }

    ],

    "statistic": {

        "tomcat_ver": "Apache Tomcat/7.0.54",

      "jvm_ver":   "1.7.0_71-b14",

      "os_ver":   "Linux    2.6.32-431.29.2.el6.x86_64",

      "appname":   "http-bio-11106",

        "total_memory": "2045.00",

        "max_memory": "3925.50",

        "max_processing_time": "7532"

    }

  }

}

IIS

{

  "iis": {

    "list": [

      {

          "check_date": "2015-10-11",

          "total_requestRate_min": 0,

          "total_requestRate_avg": 0,

          "total_requestRate_max": 0,

          "total_resptime_min": 0,

          "total_resptime_avg": 0,

          "total_resptime_max": 0

      }

    ],

    "statistic": {

      "clock":   null,

        "processors": null,

        "architecture": null,

        "total_requestRate_avg": "0.00",

        "total_requestRate_max": "0.000",

        "total_resptime_avg": "0.00",

        "total_resptime_max": "0.000"

    }

  }

}

SQLServer

{

  "sqlserver": {

    "list": [

      {

          "check_date": "2015-05-12",

          "connections_min": 3,

          "connections_avg": "3.90",

          "connections_max": 7,

          "req_m_min": -5280,

          "req_m_avg": "60.89",

        "req_m_max":   430,

          "total_server_memory_min": 8,

          "total_server_memory_avg": "8.00",

          "total_server_memory_max": 8

      }

    ],

    "statistic": {

      "cpu_count":   1,

        "hyperthread_ratio": 1,

        "scheduler_count": 1,

      "physical_memory_mb":   1499,

        "virtual_memory_mb": 4095,

        "database_name": "master",

        "connections": {

          "connections_avg": "3.90",

          "connections_max": "7.00"

      },

        "request_rates": {

          "req_m_avg": "60.89",

          "req_m_max": "430.00"

      }

    }

  }

}

Oracle

{

  "oracle": {

    "list": [

      {

          "check_date": "2015-05-12",

          "Logical_read_min": 162.36,

          "Logical_read_avg": "370.82",

          "Logical_read_max": 990.04,

        "iops_min":   0.58,

          "iops_avg": "1.63",

          "iops_max": 46.01,

          "mbps_min": 0,

          "mbps_avg": "0.12",

          "mbps_max": 2.875625,

          "Ph_read_min": 0.03,

          "Ph_read_avg": "0.88",

          "Ph_read_max": 42.79,

          "Ph_write_min": 0.51,

          "Ph_write_avg": "0.77",

          "Ph_write_max": 5.22

      }

    ],

    "statistic": {

      "db_name":   "ORCL",

      "db_id":   "1371014808",

        "db_instance": "orcl",

        "db_inst_num": "1",

      "F_IO": {

        "EXAMPLE": {

          "name":   "EXAMPLE",

          "used":   "77.63",

          "total":   "32.00",

            "used_rate": "0.24",

            "day_add": "3.76"

        },

        "SYSAUX":   {

          "name":   "SYSAUX",

          "used":   "705.00",

          "total":   "32.00",

            "used_rate": "2.15",

            "day_add": "74.22"

        },

        "SYSTEM":   {

          "name":   "SYSTEM",

          "used":   "492.13",

          "total":   "32.00",

            "used_rate": "1.50",

            "day_add": "23.92"

        },

          "UNDOTBS1": {

          "name":   "UNDOTBS1",

          "used":   "2.25",

          "total":   "32.00",

            "used_rate": "0.01",

            "day_add": "-0.39"

        },

        "USERS": {

          "name":   "USERS",

          "used":   "3.25",

          "total":   "32.00",

            "used_rate": "0.01",

            "day_add": "0.32"

        }

      },

      "Read_": {

          "39m4sx9k63ba2": {

          "SQL   ID": "39m4sx9k63ba2",

          "SQL   Text": "select /*+ index(idl_ub2$ i_idl_ub21) +*/   piece#,length,piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3   order by piece#",

          "Elapsed   Time(s)": "17",

          "cpu   time(s)": "110",

          "executions": "0.2",

          "Elap/Exec(s)": "11.8",

          "db   time": "0.02"

        },

          "350myuyx0t1d6": {

          "SQL   ID": "350myuyx0t1d6",

          "SQL   Text": "insert into wrh$_tablespace_stat (snap_id, dbid,   instance_number, ts#, tsname, contents, status, segment_space_management,   extent_management, is_backup) select :snap_id, :dbid, :instance_number,   ts.ts#, ts.name as tsname,decode(ts.contents$, 0, (decode(bitand(ts.flags,   16), 16, ‘UNDO’, ‘",

          "Elapsed   Time(s)": "5",

          "cpu   time(s)": "1",

            "executions": "5.0",

            "Elap/Exec(s)": "3.5",

          "db   time": "0.02"

        },

          "586b2udq6dbng": {

          "SQL   ID": "586b2udq6dbng",

          "SQL   Text": "insert into wrh$_sysstat (snap_id, dbid, instance_number,   stat_id, value) select :snap_id, :dbid, :instance_number, stat_id, value from   v$sysstat order by stat_id",

          "Elapsed   Time(s)": "5",

          "cpu   time(s)": "1",

            "executions": "5.0",

            "Elap/Exec(s)": "3.5",

          "db   time": "0.02"

        },

          "84qubbrsr0kfn": {

          "SQL   ID": "84qubbrsr0kfn",

          "SQL   Text": "insert into wrh$_latch (snap_id, dbid, instance_number,   latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses,   spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid,   :instance_number,hash, level#, gets, misses, sleeps, immediate_gets,   immediate_misses, spin_ge",

          "Elapsed   Time(s)": "5",

          "cpu   time(s)": "1",

            "executions": "5.0",

            "Elap/Exec(s)": "3.5",

          "db   time": "0.02"

        },

        "c0agatqzq2jzr":   {

          "SQL   ID": "c0agatqzq2jzr",

          "SQL   Text": "insert into \"SYS\".\"ALERT_QT\"   (q_name, msgid, corrid, priority, state, delay, expiration,   time_manager_info, local_order_no, chain_no, enq_time, step_no, enq_uid,   enq_tid, retry_count, exception_qschema, exception_queue,   recipient_key,dequeue_msgid, user_data, sender_name, sender_address,   sender_protocol, user",

          "Elapsed   Time(s)": "5",

          "cpu   time(s)": "6",

            "executions": "0.8",

            "Elap/Exec(s)": "3.5",

          "db   time": "0.02"

        },

          "6hwjmjgrpsuaa": {

          "SQL   ID": "6hwjmjgrpsuaa",

          "SQL   Text": "insert into wrh$_enqueue_stat (snap_id, dbid,   instance_number, eq_type, req_reason, total_req#, total_wait#, succ_req#,   failed_req#, cum_wait_time, event#) select :snap_id, :dbid, :instance_number,   eq_type, req_reason, total_req#, total_wait#, succ_req#, failed_req#,   cum_wait_time, event# from v$e",

          "Elapsed   Time(s)": "4",

          "cpu   time(s)": "1",

          "executions":   "4.0",

            "Elap/Exec(s)": "2.8",

          "db   time": "0.02"

        },

          "13fnb572x6z9j": {

          "SQL   ID": "13fnb572x6z9j",

          "SQL   Text": "insert into wrh$_osstat (snap_id, dbid, instance_number,   stat_id, value) select :snap_id, :dbid, :instance_number, osstat_id, value   from v$osstat",

          "Elapsed   Time(s)": "3",

          "cpu   time(s)": "1",

          "executions":   "3.0",

            "Elap/Exec(s)": "2.1",

          "db   time": "0.01"

        },

          "13kwg458hfzfb": {

          "SQL   ID": "13kwg458hfzfb",

          "SQL   Text": "insert into wrh$_sys_time_model (snap_id, dbid,   instance_number, stat_id, value) select :snap_id, :dbid, :instance_number,   stat_id, value from v$sys_time_model order by stat_id",

          "Elapsed   Time(s)": "3",

          "cpu   time(s)": "1",

            "executions": "3.0",

            "Elap/Exec(s)": "2.1",

          "db   time": "0.01"

        },

          "71k5024zn7c9a": {

          "SQL   ID": "71k5024zn7c9a",

          "SQL   Text": "insert into wrh$_latch_misses_summary (snap_id, dbid,   instance_number, parent_name, where_in_code, nwfail_count, sleep_count,   wtr_slp_count) select :snap_id, :dbid, :instance_number, parent_name,   \"WHERE\", sum(nwfail_count), sum(sleep_count), sum(wtr_slp_count)   from v$latch_misses where sleep_count >",

          "Elapsed   Time(s)": "3",

          "cpu   time(s)": "1",

            "executions": "3.0",

          "Elap/Exec(s)":   "2.1",

          "db   time": "0.02"

        },

          "bqnn4c3gjtmgu": {

          "SQL   ID": "bqnn4c3gjtmgu",

          "SQL   Text": "insert into wrh$_bg_event_summary (snap_id, dbid,   instance_number, event_id, total_waits, total_timeouts, time_waited_micro)   select /*+ ordered use_nl(e) */ :snap_id, :dbid, :instance_number,   e.event_id, sum(e.total_waits),sum(e.total_timeouts),   sum(e.time_waited_micro) from v$session bgsids, v$s",

          "Elapsed   Time(s)": "3",

          "cpu   time(s)": "1",

            "executions": "3.0",

            "Elap/Exec(s)": "2.1",

          "db   time": "0.02"

        }

      },

      "El_T": {

          "bunssq950snhf": {

          "SQL   ID": "bunssq950snhf",

          "SQL   Text": "insert into wrh$_sga_target_advice (snap_id, dbid,   instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME,   ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE,   SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from   v$sga_target_advice",

          "cpu   time(s)": "0",

          "Elapsed   time(s)": "0",

            "Executions": "1",

          "cpu   time/Exec(s)": "0.2",

          "db   time": "4.2"

        },

          "6hwjmjgrpsuaa": {

          "SQL   ID": "6hwjmjgrpsuaa",

          "SQL   Text": "insert into wrh$_enqueue_stat (snap_id, dbid,   instance_number, eq_type, req_reason, total_req#, total_wait#, succ_req#,   failed_req#, cum_wait_time, event#) select :snap_id, :dbid, :instance_number,   eq_type, req_reason, total_req#, total_wait#, succ_req#, failed_req#,   cum_wait_time, event# from v$e",

          "cpu   time(s)": "0",

          "Elapsed   time(s)": "0",

          "Executions": "1",

          "cpu   time/Exec(s)": "0.2",

          "db   time": "4.2"

        },

          "350myuyx0t1d6": {

          "SQL   ID": "350myuyx0t1d6",

          "SQL   Text": "insert into wrh$_tablespace_stat (snap_id, dbid,   instance_number, ts#, tsname, contents, status, segment_space_management,   extent_management, is_backup) select :snap_id, :dbid, :instance_number,   ts.ts#, ts.name as tsname,decode(ts.contents$, 0, (decode(bitand(ts.flags,   16), 16, ‘UNDO’, ‘",

          "cpu   time(s)": "0",

          "Elapsed   time(s)": "0",

            "Executions": "1",

          "cpu   time/Exec(s)": "0.1",

          "db   time": "2.3"

        },

          "c0agatqzq2jzr": {

          "SQL ID":   "c0agatqzq2jzr",

          "SQL   Text": "insert into \"SYS\".\"ALERT_QT\"   (q_name, msgid, corrid, priority, state, delay, expiration,   time_manager_info, local_order_no, chain_no, enq_time, step_no, enq_uid,   enq_tid, retry_count, exception_qschema, exception_queue,   recipient_key,dequeue_msgid, user_data, sender_name, sender_address,   sender_protocol, user",

          "cpu   time(s)": "0",

          "Elapsed   time(s)": "0",

            "Executions": "6",

          "cpu   time/Exec(s)": "0.0",

          "db time": "1.9"

        },

          "bqnn4c3gjtmgu": {

          "SQL   ID": "bqnn4c3gjtmgu",

          "SQL   Text": "insert into wrh$_bg_event_summary (snap_id, dbid,   instance_number, event_id, total_waits, total_timeouts, time_waited_micro)   select /*+ ordered use_nl(e) */ :snap_id, :dbid, :instance_number,   e.event_id, sum(e.total_waits),sum(e.total_timeouts),   sum(e.time_waited_micro) from v$session bgsids, v$s",

          "cpu   time(s)": "0",

          "Elapsed   time(s)": "0",

            "Executions": "1",

          "cpu time/Exec(s)":   "0.1",

          "db   time": "1.8"

        },

          "7ng34ruy5awxq": {

          "SQL   ID": "7ng34ruy5awxq",

          "SQL   Text": "select   i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(",

          "cpu   time(s)": "0",

          "Elapsed   time(s)": "0",

          "Executions": "165",

          "cpu   time/Exec(s)": "0.0",

          "db   time": "1.3"

        },

          "84qubbrsr0kfn": {

          "SQL   ID": "84qubbrsr0kfn",

          "SQL   Text": "insert into wrh$_latch (snap_id, dbid, instance_number,   latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses,   spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid,   :instance_number,hash, level#, gets, misses, sleeps, immediate_gets,   immediate_misses, spin_ge",

          "cpu   time(s)": "0",

          "Elapsed   time(s)": "0",

          "Executions": "1",

          "cpu time/Exec(s)":   "0.0",

          "db   time": "0.9"

        },

          "71k5024zn7c9a": {

          "SQL   ID": "71k5024zn7c9a",

          "SQL   Text": "insert into wrh$_latch_misses_summary (snap_id, dbid,   instance_number, parent_name, where_in_code, nwfail_count, sleep_count,   wtr_slp_count) select :snap_id, :dbid, :instance_number, parent_name,   \"WHERE\", sum(nwfail_count), sum(sleep_count), sum(wtr_slp_count)   from v$latch_misses where sleep_count >",

          "cpu   time(s)": "0",

          "Elapsed   time(s)": "0",

          "Executions":   "1",

          "cpu   time/Exec(s)": "0.0",

          "db   time": "0.8"

        },

          "83taa7kaw59c1": {

          "SQL   ID": "83taa7kaw59c1",

          "SQL   Text": "select   name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182,scale,183,scale,231,scale,0),null$,fixedstorage,nvl(deflength,0),default$,rowid,col#,property,   nvl(charsetid,0),nvl(charsetform,0),spare1,spare2,nvl(spare3,0) from col$   wh",

          "cpu   time(s)": "0",

          "Elapsed   time(s)": "0",

          "Executions": "348",

          "cpu   time/Exec(s)": "0.0",

          "db   time": "0.7"

        },

          "71y370j6428cb": {

          "SQL   ID": "71y370j6428cb",

          "SQL   Text": "insert into wrh$_thread (snap_id, dbid, instance_number,   thread#, thread_instance_number, status, open_time, current_group#,   sequence#) select:snap_id, :dbid, :instance_number, t.thread#,   i.instance_number, t.status, t.open_time, t.current_group#, t.sequence# from   v$thread t, v$instance",

          "cpu   time(s)": "0",

          "Elapsed   time(s)": "0",

          "Executions": "1",

          "cpu   time/Exec(s)": "0.0",

          "db time": "0.7"

        }

      },

      "CPU_T": {

          "bunssq950snhf": {

          "SQL   ID": "bunssq950snhf",

         "SQL   Text": "insert into wrh$_sga_target_advice (snap_id, dbid,   instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME,   ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE,   SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from   v$sga_target_advice",

          "Physical   Reads": "0",

          "Executions": "0",

          "Reads/Exec": "1",

          "cpu   Time(s)": "0.21",

          "Elapsed   Time(s)": "4.2"

        },

          "7ng34ruy5awxq": {

          "SQL   ID": "7ng34ruy5awxq",

          "SQL   Text": "select   i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(",

          "Physical Reads":   "0",

          "Executions": "0",

          "Reads/Exec": "165",

          "cpu   Time(s)": "0.00",

          "Elapsed   Time(s)": "1.3"

        },

          "83taa7kaw59c1": {

          "SQL   ID": "83taa7kaw59c1",

          "SQL   Text": "select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182,scale,183,scale,231,scale,0),null$,fixedstorage,nvl(deflength,0),default$,rowid,col#,property,   nvl(charsetid,0),nvl(charsetform,0),spare1,spare2,nvl(spare3,0) from col$   wh",

          "Physical   Reads": "0",

          "Executions": "0",

          "Reads/Exec": "348",

          "cpu   Time(s)": "0.00",

          "Elapsed   Time(s)": "0.7"

        },

          "cqgv56fmuj63x": {

          "SQL   ID": "cqgv56fmuj63x",

          "SQL   Text": "select   owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#,   nvl(property,0),subname,d_attrs from dependency$ d, obj$ o where d_obj#=:1   and p_obj#=obj#(+) order by order#",

          "Physical   Reads": "0",

          "Executions": "0",

          "Reads/Exec": "229",

          "cpu   Time(s)": "0.00",

          "Elapsed   Time(s)": "0.4"

        },

          "130dvvr5s8bgn": {

          "SQL   ID": "130dvvr5s8bgn",

          "SQL   Text": "select obj#, dataobj#, part#, hiboundlen, hiboundval, ts#,   file#, block#, pctfree$, pctused$, initrans, maxtrans, flags, analyzetime,   samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln,   length(bhiboundval), bhiboundval from tabpart$where bo# = :1 order by   part#",

          "Physical   Reads": "0",

          "Executions": "0",

          "Reads/Exec": "18",

          "cpu   Time(s)": "0.00",

          "Elapsed   Time(s)": "0.4"

        },

          "39m4sx9k63ba2": {

          "SQL   ID": "39m4sx9k63ba2",

          "SQL   Text": "select /*+ index(idl_ub2$ i_idl_ub21) +*/   piece#,length,piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3   order by piece#",

          "Physical   Reads": "0",

          "Executions": "0",

          "Reads/Exec":   "110",

          "cpu   Time(s)": "0.00",

          "Elapsed   Time(s)": "0.3"

        },

          "f318xdxdn0pdc": {

          "SQL   ID": "f318xdxdn0pdc",

          "SQL   Text": "insert into wrh$_log (snap_id, dbid, instance_number,   group#, thread#,sequence#, bytes, members, archived, status, first_change#,   first_time) select :snap_id, :dbid, :instance_number, group#, thread#,   sequence#, bytes, members, archived, status, first_change#, first_time",

          "Physical   Reads": "0",

          "Executions": "0",

          "Reads/Exec": "1",

          "cpu   Time(s)": "0.02",

          "Elapsed   Time(s)": "0.5"

        },

          "350myuyx0t1d6": {

          "SQL   ID": "350myuyx0t1d6",

          "SQL   Text": "insert into wrh$_tablespace_stat (snap_id, dbid,   instance_number, ts#, tsname, contents, status, segment_space_management,   extent_management, is_backup) select :snap_id, :dbid, :instance_number,   ts.ts#, ts.name as tsname,decode(ts.contents$, 0, (decode(bitand(ts.flags,   16), 16, ‘UNDO’, ‘",

          "Physical   Reads": "0",

          "Executions": "0",

          "Reads/Exec": "1",

          "cpu   Time(s)": "0.02",

          "Elapsed   Time(s)": "2.3"

        },

          "71y370j6428cb": {

          "SQL ID":   "71y370j6428cb",

          "SQL   Text": "insert into wrh$_thread (snap_id, dbid, instance_number,   thread#, thread_instance_number, status, open_time, current_group#,   sequence#) select:snap_id, :dbid, :instance_number, t.thread#, i.instance_number,   t.status, t.open_time, t.current_group#, t.sequence# from v$thread t,   v$instance",

          "Physical   Reads": "0",

          "Executions": "0",

          "Reads/Exec": "1",

          "cpu   Time(s)": "0.02",

          "Elapsed   Time(s)": "0.7"

        },

          "71k5024zn7c9a": {

          "SQL   ID": "71k5024zn7c9a",

          "SQL   Text": "insert into wrh$_latch_misses_summary (snap_id, dbid,   instance_number, parent_name, where_in_code, nwfail_count, sleep_count,   wtr_slp_count) select :snap_id, :dbid, :instance_number, parent_name,   \"WHERE\", sum(nwfail_count), sum(sleep_count), sum(wtr_slp_count)   from v$latch_misses where sleep_count >",

          "Physical   Reads": "0",

          "Executions": "0",

          "Reads/Exec": "1",

          "cpu   Time(s)": "0.02",

          "Elapsed   Time(s)": "0.8"

        }

      }

    }

  }

}

监控项目

分类

返回项

类型

描述

Apache、Nginx、Lighttpd

list

check_date

String

日期

list

rps_min

String

最小吞吐率

list

rps_avg

String

平均吞吐率

list

rps_max

String

最大吞吐率

list

curr_reqs_min

String

最小连接数

list

curr_reqs_avg

String

平均连接数

list

curr_reqs_max

String

最大连接数

statistic

rps_avg

String

平均吞吐率

statistic

rps_max

String

最大吞吐率

statistic

curr_reqs_avg

String

平均并发连接数

statistic

curr_reqs_max

String

最大并发连接数

Memcache

list

check_date

String

日期

list

curr_connections_min

String

最小连接数

list

curr_connections_avg

String

平均连接数

list

curr_connections_max

String

最大连接数

list

bytes_min

String

最小内存消耗

list

bytes_avg

String

平均内存消耗

list

bytes_max

String

最大内存消耗

list

keyspace_ratio_min

String

最小命中率

list

keyspace_ratio_avg

String

平均命中率

list

keyspace_ratio_max

String

最大命中率

list

curr_items_min

String

最小缓存数量

list

curr_items_avg

String

平均缓存数量

list

curr_items_max

String

最大缓存数量

list

mem_ratio_min

String

最小空间使用率

list

mem_ratio_avg

String

平均空间使用率

list

mem_ratio_max

String

最大空间使用率

statistic

version

String

运行版本

statistic

uptime

String

连续运行天数

statistic

limit_maxbytes

String

最大内存使用量

statistic

keyspace_ratio_avg

String

平均命中率

statistic

keyspace_ratio_max

String

最大命中率

statistic

bytes_avg

String

平均消耗内存数

statistic

bytes_max

String

最大消耗内存数

statistic

curr_connections_avg

String

平均连接数

statistic

curr_connections_max

String

最大连接数

statistic

connected_sec_avg

String

平均每秒链接数

statistic

connected_sec_max

String

最大每秒链接数

statistic

curr_items_avg

String

平均缓存数

statistic

curr_items_max

String

最大缓存数

statistic

read_sec_avg

String

每秒平均读

statistic

read_sec_max

String

每秒最大读

statistic

write_sec_avg

String

每秒平均写

statistic

write_sec_max

String

每秒最大写

statistic

mem_ratio_avg

String

平均空间使用率

statistic

mem_ratio_max

String

最大空间使用率

MongoDB

list

check_date

String

日期

list

connections_current_min

String

最小连接数

list

connections_current_avg

String

平均连接数

list

connections_current_max

String

最大连接数

list

globalLock_ratio_min

String

最小锁定时间比例

list

globalLock_ratio_avg

String

平均锁定时间比例

list

globalLock_ratio_max

String

最大锁定时间比例

list

page_faults_sec_min

String

最小分页次数

list

page_faults_sec_avg

String

平均分页次数

list

page_faults_sec_max

String

最大分页次数

list

indexCounters_missRatio_min

String

最小命中率

list

indexCounters_missRatio_avg

String

平均命中率

list

indexCounters_missRatio_max

String

最大命中率

list

indexCounters_btree_accesses_sec_min

String

最小索引访问次数

list

indexCounters_btree_accesses_sec_avg

String

平均索引访问次数

list

indexCounters_btree_accesses_sec_max

String

最大索引访问次数

statistic

version

String

运行版本

statistic

host

String

主机名与端口

statistic

uptime

String

连续运行时间

statistic

mongodb_connections_current

String

statistic

connections_current_avg

String

平均连接数

statistic

connections_current_max

String

最大连接数

MySQL

list

check_date

String

日期

list

Connections_min

String

最小吞吐率

list

Connections_avg

String

平均吞吐率

list

Connections_max

String

最大吞吐率

list

Bytes_received_min

String

最小速率 [流入]

list

Bytes_received_avg

String

平均速率 [流入]

list

Bytes_received_max

String

最大速率 [流入]

list

Bytes_sent_min

String

最小速率 [流出]

list

Bytes_sent_avg

String

平均速率 [流出]

list

Bytes_sent_max

String

最大速率 [流出]

list

Threads_connected_min

String

最小 [并发连接数]

list

Threads_connected_avg

String

平均 [并发连接数]

list

Threads_connected_max

String

最大 [并发连接数]

statistic

mysql_query_detail

String

查询吞吐率

statistic

Com_change_db_avg

String

changedb

statistic

Com_change_db_max

String

statistic

Com_select_avg

String

select

statistic

Com_select_max

String

statistic

Com_update_avg

String

update

statistic

Com_update_max

String

statistic

Com_insert_avg

String

insert

statistic

Com_insert_max

String

statistic

Com_delete_avg

String

delete

statistic

Com_delete_max

String

statistic

mysql_qcache_querysum

String

查询缓存

statistic

query_cache_size

String

查询缓存空间大小

statistic

query_cache_limit

String

查询缓存最大查询数据集大小

statistic

mysql_kcache_querysum

String

索引缓存

statistic

key_buffer_size

String

索引缓存空间大小

statistic

mysql_connps

String

连接

statistic

Connections_avg

String

每秒平均连接次数

statistic

Connections_max

String

每秒最大连接数

statistic

Threads_created_avg

String

每秒实际平均创建连接次数

statistic

Threads_created_max

String

每秒实际最大创建连接次数

statistic

max_connections

String

最大允许连接数

statistic

thread_cache_size

String

连接缓存大小

statistic

mysql_traffic

String

网络流量

statistic

Bytes_received_avg

String

流入速率

statistic

Bytes_received_max

String

statistic

Bytes_sent_avg

String

流出速率

statistic

Bytes_sent_max

String

Redis

list

check_date

String

日期

list

connected_sec_min

String

最小连接数

list

connected_sec_avg

String

平均连接数

list

connected_sec_max

String

最大连接数

list

keyspace_ratio_min

String

最小命中率

list

keyspace_ratio_avg

String

平均命中率

list

keyspace_ratio_max

String

最大命中率

list

used_memory_min

String

最小已使用内存

list

used_memory_avg

String

平均已使用内存

list

used_memory_max

String

最大已使用内存

list

connected_clients_min

String

最小链接客户数

list

connected_clients_avg

String

平均链接客户数

list

connected_clients_max

String

最大链接客户数

list

blocked_clients_min

String

最小阻塞客户数

list

blocked_clients_avg

String

平均阻塞客户数

list

blocked_clients_max

String

最大阻塞客户数

list

pubsub_channels_min

String

最小Pub/Sub通道数

list

pubsub_channels_avg

String

平均Pub/Sub通道数

list

pubsub_channels_max

String

最大Pub/Sub通道数

list

pubsub_patterns_min

String

最小Pub/Sub模式数

list

pubsub_patterns_avg

String

平均Pub/Sub模式数

list

pubsub_patterns_max

String

最大Pub/Sub模式数

statistic

redis_version

String

运行版本

statistic

uptime_in_days

String

连续运行时间

statistic

changes_since_last_save

String

最新变更数

statistic

used_memory_avg

String

平均使用内存

statistic

used_memory_max

String

最大使用内存

statistic

commands_sec_avg

String

每分钟平均执行命令数

statistic

commands_sec_max

String

每分钟最大执行命令数

statistic

keyspace_ratio_avg

String

平均命中率

statistic

keyspace_ratio_max

String

最大命中率

statistic

connected_clients_avg

String

平均链接客户数

statistic

connected_clients_max

String

最大链接客户数

statistic

connected_sec_avg

String

平均每分钟连接数

statistic

connected_sec_max

String

最大每分钟连接数

statistic

blocked_clients_avg

String

平均阻塞客户数

statistic

blocked_clients_max

String

最大阻塞客户数

statistic

pubsub_channels_avg

String

平均Pub/Sub通道数

statistic

pubsub_channels_max

String

最大Pub/Sub通道数

statistic

pubsub_patterns_avg

String

平均Pub/Sub模式数

statistic

pubsub_patterns_max

String

最大Pub/Sub模式数

Tomcat

list

check_date

String

日期

list

free_memory_min

String

最小JVM可使用内存

list

free_memory_avg

String

平均JVM可使用内存

list

free_memory_max

String

最大JVM可使用内存

list

total_memory_min

String

最小JVM所有使用内存

list

total_memory_avg

String

平均VM所有使用内存

list

total_memory_max

String

最大JVM所有使用内存

list

max_memory_min

String

最小已使用内存

list

max_memory_avg

String

平均已使用内存

list

max_memory_max

String

最大已使用内存

list

processing_time_sec_min

String

最小Tomcat处理时间

list

processing_time_sec_avg

String

平均Tomcat处理时间

list

processing_time_sec_max

String

最大Tomcat处理时间

list

request_count_sec_min

String

最小Tomcat请求数

list

request_count_sec_avg

String

平均Tomcat请求数

list

request_count_sec_max

String

最大Tomcat请求数

list

bytes_received_sec_min

String

最小入流量

list

bytes_received_sec_avg

String

平均入流量

list

bytes_received_sec_max

String

最大入流量

list

bytes_sent_sec_min

String

最小出流量

list

bytes_sent_sec_avg

String

平均出流量

list

bytes_sent_sec_max

String

最大出流量

statistic

tomcat_ver

String

Tomcat运行版本

statistic

jvm_ver

String

JVM版本

statistic

os_ver

String

OS版本

statistic

appname

String

监控服务名

statistic

total_memory

String

JVM最大已使用内存

statistic

max_memory

String

JVM最大可使用内存

statistic

max_processing_time

String

请求最大处理时间

IIS

list

check_date

String

日期

list

total_requestRate_min

String

最小请求频率

list

total_requestRate_avg

String

平均请求频率

list

total_requestRate_max

String

最大请求频率

list

total_resptime_min

String

最小响应时间

list

total_resptime_avg

String

平均响应时间

list

total_resptime_max

String

最大响应时间

statistic

clock

String

处理器速度

statistic

processors

String

核数

statistic

architecture

String

平台

statistic

total_requestRate_avg

String

平均请求频率

statistic

total_requestRate_max

String

最大请求频率

statistic

total_resptime_avg

String

平均响应时间

statistic

total_resptime_max

String

最大相应时间

SQLServer

list

check_date

String

日期

list

connections_min

String

最小连接数

list

connections_avg

String

平均连接数

list

connections_max

String

最大连接数

list

req_m_min

String

最小请求频率

list

req_m_avg

String

平均请求频率

list

req_m_max

String

最大请求频率

list

total_server_memory_min

String

最小消耗物理内存数

list

total_server_memory_avg

String

平均消耗物理内存数

list

total_server_memory_max

String

最大消耗物理内存数

statistic

cpu_count

String

CPU频率

statistic

hyperthread_ratio

String

超线程

statistic

scheduler_count

String

CPU核数

statistic

physical_memory_mb

String

物理内存

statistic

virtual_memory_mb

String

虚拟内存

statistic

database_name

String

数据库名称

statistic

connections

statistic

connections_avg

String

平均连接数

statistic

connections_max

String

最大连接数

statistic

request_rates

statistic

req_m_avg

String

平均请求频率

statistic

req_m_max

String

最大请求频率

Oracle

list

check_date

String

日期

list

Logical_read_min

String

最小每秒逻辑读

list

Logical_read_avg

String

平均每秒逻辑读

list

Logical_read_max

String

最大每秒逻辑读

list

iops_min

String

最小IOPS

list

iops_avg

String

平均IOPS

list

iops_max

String

最大IOPS

list

mbps_min

String

最小MBPS

list

mbps_avg

String

平均MBPS

list

mbps_max

String

最大MBPS

list

Ph_read_min

String

最小物理读

list

Ph_read_avg

String

平均物理读

list

Ph_read_max

String

最大物理读

list

Ph_write_min

String

最小物理写

list

Ph_write_avg

String

平均物理写

list

Ph_write_max

String

最大物理写

statistic

db_name

String

数据库名

statistic

db_id

String

数据库ID

statistic

db_instance

String

实例名

statistic

db_inst_num

String

实例号

statistic

F_IO

String

空间变化

statistic

EXAMPLE

String

statistic

name

String

名称

statistic

used

String

已使用大小（MB）

statistic

total

String

总大小（GB）

statistic

used_rate

String

已使用率（%）

statistic

day_add

String

日增长（MB）

statistic

Read_

String

TOP SQL 逻辑读

statistic

SQL ID

String

statistic

SQL Text

String

statistic

Elapsed Time(s)

String

statistic

cpu time(s)

String

statistic

executions

String

statistic

Elap/Exec(s)

String

statistic

db time

String

statistic

El_T

String

TOP SQL 消耗时间

statistic

SQL ID

String

statistic

SQL Text

String

statistic

cpu time(s)

String

statistic

Elapsed time(s)

String

statistic

Executions

String

statistic

cpu time/Exec(s)

String

statistic

db time

String

statistic

CPU_T

String

TOP SQL CPU时间

statistic

SQL ID

String

statistic

SQL Text

String

statistic

Physical Reads

String

statistic

Executions

String

statistic

Reads/Exec

String

statistic

cpu Time(s)

String

statistic

Elapsed Time(s)

String

失败返回结果：

{

  "code": 400,

  "msg": "您没有权限查看该任务!"

}

返回项

类型

默认值

code

String

错误码

msg

String

错误信息