采集配置列表

{
  "dat": [
    {
      "id": 44,
      "name": "prom",
      "group_id": 32,
      "queries": [
        {
          "key": "all_hosts",
          "op": "",
          "values": null
        },
        {
          "key": "group_ids",
          "op": "==",
          "values": [
            32
          ]
        }
      ],
      "disabled": 1,
      "cate": "prometheus",
      "content": "# # collect interval\n# interval = 15\n\n[[instances]]\nurls = [\n     \"http://localhost:19000/metrics\"\n]\n\nurl_label_key = \"{{.smtp_port}}\"\nurl_label_value = \"{{.Host}}\"\n\n## Scrape Services available in Consul Catalog\n# [instances.consul]\n#   enabled = false\n#   agent = \"http://localhost:8500\"\n#   query_interval = \"5m\"\n\n#   [[instances.consul.query]]\n#     name = \"a service name\"\n#     tag = \"a service tag\"\n#     url = 'http://{{if ne .ServiceAddress \"\"}}{{.ServiceAddress}}{{else}}{{.Address}}{{end}}:{{.ServicePort}}/{{with .ServiceMeta.metrics_path}}{{.}}{{else}}metrics{{end}}'\n#     [instances.consul.query.tags]\n#       host = \"{{.Node}}\"\n\n# bearer_token_string = \"\"\n\n# e.g. /run/secrets/kubernetes.io/serviceaccount/token\n# bearer_token_file = \"\"\n\n# # basic auth\n# username = \"\"\n# password = \"\"\n\n# headers = [\"X-From\", \"categraf\"]\n\n# # interval = global.interval * interval_times\n# interval_times = 1\n\n# labels = {}\n\n# support glob\n# ignore_metrics = [ \"go_*\" ]\n\n# support glob\n# ignore_label_keys = []\n\n# timeout for every url\n# timeout = \"3s\"\n\n## Optional TLS Config\n# use_tls = false\n# tls_min_version = \"1.2\"\n# tls_ca = \"/etc/categraf/ca.pem\"\n# tls_cert = \"/etc/categraf/cert.pem\"\n# tls_key = \"/etc/categraf/key.pem\"\n## Use TLS but skip chain & host verification\n# insecure_skip_verify = true\n",
      "version": "4b07848b2065dc50242be9f1c63291c7",
      "create_at": 1703589130,
      "create_by": "root",
      "update_at": 1703589407,
      "update_by": "root",
      "load_by_categraf": false
    },
    {
      "id": 47,
      "name": "oracle",
      "group_id": 32,
      "queries": [
        {
          "key": "all_hosts",
          "op": "",
          "values": null
        },
        {
          "key": "group_ids",
          "op": "==",
          "values": [
            32
          ]
        }
      ],
      "disabled": 0,
      "cate": "oracle",
      "content": "[[metrics]]\nmesurement = \"sessionsaaaa\"\nlabel_fields = [ \"status\", \"type\" ]\nmetric_fields = [ \"value\" ]\ntimeout = \"3s\"\nrequest = '''\nSELECT status, type, COUNT(*) as value FROM v$session GROUP BY status, type\n'''\n\n[[metrics]]\nmesurement = \"lock\"\nmetric_fields = [ \"cnt\" ]\ntimeout = \"3s\"\nrequest = '''\nSELECT COUNT(*) AS cnt\n  FROM ALL_OBJECTS A, V$LOCKED_OBJECT B, SYS.GV_$SESSION C\n WHERE A.OBJECT_ID = B.OBJECT_ID\n   AND B.PROCESS = C.PROCESS\n'''\n\n[[metrics]]\nmesurement = \"slow_queries\"\nmetric_fields = [ \"p95_time_usecs\" , \"p99_time_usecs\"]\ntimeout = \"3s\"\nrequest = '''\nselect  percentile_disc(0.95)  within group (order by elapsed_time) as p95_time_usecs, \n  percentile_disc(0.99)  within group (order by elapsed_time) as p99_time_usecs \nfrom v$sql where last_active_time >= sysdate - 5/(24*60)\n'''\n\n[[metrics]]\nmesurement = \"resource\"\nlabel_fields = [ \"resource_name\" ]\nmetric_fields = [ \"current_utilization\", \"limit_value\" ]\ntimeout = \"3s\"\nrequest = '''\nSELECT resource_name,current_utilization,CASE WHEN TRIM(limit_value) LIKE 'UNLIMITED' THEN '-1' ELSE TRIM(limit_value) END as limit_value FROM v$resource_limit\n'''\n\n[[metrics]]\nmesurement = \"asm_diskgroup\"\nlabel_fields = [ \"name\" ]\nmetric_fields = [ \"total\", \"free\" ]\ntimeout = \"3s\"\nrequest = '''\nSELECT name,total_mb*1024*1024 as total,free_mb*1024*1024 as free FROM v$asm_diskgroup_stat where exists (select 1 from v$datafile where name like '+%')\n'''\nIgnoreZeroResult = true\n\n[[metrics]]\nmesurement = \"activity\"\nmetric_fields = [ \"value\" ]\nfield_to_append = \"name\"\ntimeout = \"3s\"\nrequest = '''\nSELECT name, value FROM v$sysstat WHERE name IN ('parse count (total)', 'execute count', 'user commits', 'user rollbacks')\n'''\n\n[[metrics]]\nmesurement = \"process\"\nmetric_fields = [ \"count\" ]\ntimeout = \"3s\"\nrequest = '''\nSELECT COUNT(*) as count FROM v$process\n'''\n\n[[metrics]]\nmesurement = \"wait_time\"\nmetric_fields = [ \"value\" ]\nlabel_fields = [\"wait_class\"]\ntimeout = \"3s\"\nrequest = '''\nSELECT\n  n.wait_class as WAIT_CLASS,\n  round(m.time_waited/m.INTSIZE_CSEC,3) as VALUE\nFROM\n  v$waitclassmetric  m, v$system_wait_class n\nWHERE\n  m.wait_class_id=n.wait_class_id AND n.wait_class != 'Idle'\n'''\n\n[[metrics]]\nmesurement = \"tablespace\"\nlabel_fields = [ \"tablespace\", \"type\" ]\nmetric_fields = [ \"bytes\", \"max_bytes\", \"free\" ]\ntimeout = \"3s\"\nrequest = '''\nSELECT\n    dt.tablespace_name as tablespace,\n    dt.contents as type,\n    dt.block_size * dtum.used_space as bytes,\n    dt.block_size * dtum.tablespace_size as max_bytes,\n    dt.block_size * (dtum.tablespace_size - dtum.used_space) as free\nFROM  dba_tablespace_usage_metrics dtum, dba_tablespaces dt\nWHERE dtum.tablespace_name = dt.tablespace_name\nORDER by tablespace\n'''\n\n[[metrics]]\nmesurement = \"sysmetric\"\nmetric_fields = [ \"value\" ]\nfield_to_append = \"metric_name\"\ntimeout = \"3s\"\nrequest = '''\nselect METRIC_NAME,VALUE from v$sysmetric where group_id=2\n'''\n",
      "version": "03d66eeab814a9212336a192f98218b2",
      "create_at": 1706163831,
      "create_by": "root",
      "update_at": 1706163831,
      "update_by": "root",
      "load_by_categraf": false
    },
    {
      "id": 48,
      "name": "mysql",
      "group_id": 32,
      "queries": [
        {
          "key": "tags",
          "op": "==",
          "values": [
            "myenv=my-test"
          ]
        },
        {
          "key": "group_ids",
          "op": "==",
          "values": [
            32
          ]
        }
      ],
      "disabled": 0,
      "cate": "mysql",
      "content": "[[instances]]\naddress = \"127.0.0.2:3306\"\nusername = \"root\"\npassword = \"1234\"\n\n# # set tls=custom to enable tls\n# parameters = \"tls=false\"\n\n# extra_status_metrics = true\n# extra_innodb_metrics = false\n# gather_processlist_processes_by_state = false\n# gather_processlist_processes_by_user = false\n# gather_schema_size = true\n# gather_table_size = false\n# gather_system_table_size = false\n# gather_slave_status = true\n\n# # timeout\n# timeout_seconds = 3\n\n# # interval = global.interval * interval_times\n# interval_times = 1\n\n# important! use global unique string to specify instance\n# labels = { instance=\"n9e-10.2.3.4:3306\" }\n\n## Optional TLS Config\n# use_tls = false\n# tls_min_version = \"1.2\"\n# tls_ca = \"/etc/categraf/ca.pem\"\n# tls_cert = \"/etc/categraf/cert.pem\"\n# tls_key = \"/etc/categraf/key.pem\"\n## Use TLS but skip chain & host verification\n# insecure_skip_verify = true\n\n#[[instances.queries]]\n# mesurement = \"lock_wait\"\n# metric_fields = [ \"total\" ]\n# timeout = \"3s\"\n# request = '''\n#SELECT count(*) as total FROM information_schema.innodb_trx WHERE trx_state='LOCK WAIT'\n#'''\n\n# [[instances.queries]]\n# mesurement = \"users\"\n# metric_fields = [ \"total\" ]\n# label_fields = [ \"service\" ]\n# # field_to_append = \"\"\n# timeout = \"3s\"\n# request = '''\n# select 'n9e' as service, count(*) as total from n9e_v5.users\n# '''\n",
      "version": "c0578b5c5248b898fc6493ce92985d21",
      "create_at": 1707211959,
      "create_by": "root",
      "update_at": 1707212288,
      "update_by": "root",
      "load_by_categraf": false
    }
  ],
  "err": ""
}