# Licensed to the Apache Software Foundation (ASF) under one or more # contributor license agreements. See the NOTICE file distributed with # this work for additional information regarding copyright ownership. # The ASF licenses this file to You under the Apache License, Version 2.0 # (the "License"); you may not use this file except in compliance with # the License. You may obtain a copy of the License at # # http://www.apache.org/licenses/LICENSE-2.0 # # Unless required by applicable law or agreed to in writing, software # distributed under the License is distributed on an "AS IS" BASIS, # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. # See the License for the specific language governing permissions and # limitations under the License. # The monitoring type category:service-application service monitoring db-database monitoring custom-custom monitoring os-operating system monitoring # 监控类型所属类别:service-应用服务 program-应用程序 db-数据库 custom-自定义 os-操作系统 bigdata-大数据 mid-中间件 webserver-web服务器 cache-缓存 cn-云原生 network-网络监控等等 category: db # The monitoring type eg: linux windows tomcat mysql aws... # 监控类型 eg: linux windows tomcat mysql aws... app: postgresql # The monitoring i18n name # 监控类型国际化名称 name: zh-CN: PostgreSQL数据库 en-US: PostgreSQL DB # The description and help of this monitoring type # 监控类型的帮助描述信息 help: zh-CN: HertzBeat 对 PostgreSQL 数据库的通用性能指标(basic、state、activity)进行采集监控,支持版本为 PostgreSQL 10+。
您可以点击“新建 PostgreSQL 数据库”并进行配置,或者选择“更多操作”,导入已有配置。 en-US: HertzBeat monitors PostgreSQL database through basic performance metrics such as state and activity, the version we support is PostgreSQL 10+.
You could click the "New MariPostgreSQLaDB" button and proceed with the configuration or import an existing setup through the "More Actions" menu. zh-TW: HertzBeat對PostgreSQL資料庫的通用性能指標(basic、state、activity)進行採集監控,支持版本為PostgreSQL 10+。
您可以點擊“新建PostgreSQL資料庫”並進行配寘,或者選擇“更多操作”,導入已有配寘。 helpLink: zh-CN: https://hertzbeat.com/zh-cn/docs/help/postgresql en-US: https://hertzbeat.com/docs/help/postgresql # 监控所需输入参数定义(根据定义渲染页面UI) # Input params define for monitoring(render web ui by the definition) params: # field-param field key # field-变量字段标识符 - field: host # name-param field display i18n name # name-参数字段显示名称 name: zh-CN: 目标Host en-US: Target Host # type-param field type(most mapping the html input type) # type-字段类型,样式(大部分映射input标签type属性) type: host # required-true or false # required-是否是必输项 true-必填 false-可选 required: true # field-param field key # field-变量字段标识符 - field: port # name-param field display i18n name # name-参数字段显示名称 name: zh-CN: 端口 en-US: Port # type-param field type(most mapping the html input type) # type-字段类型,样式(大部分映射input标签type属性) type: number # when type is number, range is required # 当type为number时,用range表示范围 range: '[0,65535]' # required-true or false # required-是否是必输项 true-必填 false-可选 required: true # default value defaultValue: 5432 - field: timeout name: zh-CN: 查询超时时间(ms) en-US: Query Timeout(ms) type: number range: '[400,200000]' required: false hide: true defaultValue: 6000 - field: database name: zh-CN: 数据库名称 en-US: Database Name type: text defaultValue: postgres required: false - field: username name: zh-CN: 用户名 en-US: Username type: text limit: 20 required: false - field: password name: zh-CN: 密码 en-US: Password type: password required: false - field: url name: zh-CN: URL en-US: URL type: text required: false hide: true # collect metrics config list # 采集指标组配置列表 metrics: # metrics - basic # 监控指标组 - basic - name: basic # metrics group scheduling priority(0->127)->(high->low), metrics with the same priority will be scheduled in parallel # priority 0's metrics group is availability metrics, it will be scheduled first, only availability metrics collect success will the scheduling continue # 指标组调度优先级(0->127)->(优先级高->低) 优先级低的指标组会等优先级高的指标组采集完成后才会被调度, 相同优先级的指标组会并行调度采集 # 优先级为0的指标组为可用性指标组,即它会被首先调度,采集成功才会继续调度其它指标组,采集失败则中断调度 priority: 0 # collect metrics content # 具体监控指标列表 fields: # field-metric name, type-metric type(0-number,1-string), unit-metric unit('%','ms','MB'), label-whether it is a metrics label field # field-指标名称, type-指标类型(0-number数字,1-string字符串), unit-指标单位('%','ms','MB'), label-是否是指标标签字段 - field: server_version type: 1 label: true - field: port type: 1 - field: server_encoding type: 1 - field: data_directory type: 1 - field: max_connections type: 0 # the protocol used for monitoring, eg: sql, ssh, http, telnet, wmi, snmp, sdk # 用于监控的协议, eg: sql, ssh, http, telnet, wmi, snmp, sdk protocol: jdbc # the config content when protocol is jdbc # 协议为jdbc时的配置内容 jdbc: # host: ipv4 ipv6 host # 主机host: ipv4 ipv6 域名 host: ^_^host^_^ port: ^_^port^_^ timeout: ^_^timeout^_^ # database platform name # 数据库平台名称 platform: postgresql username: ^_^username^_^ password: ^_^password^_^ database: ^_^database^_^ # SQL Query Method:oneRow, multiRow, columns # SQL查询方式: oneRow, multiRow, columns queryType: columns # sql sql: select name, setting as value from pg_settings where name = 'max_connections' or name = 'server_version' or name = 'server_encoding' or name = 'port' or name = 'data_directory'; # JDBC url url: ^_^url^_^ - name: state priority: 1 fields: - field: db_name type: 1 label: true - field: conflicts type: 0 unit: times - field: deadlocks type: 0 unit: times - field: blks_read type: 0 unit: blocks per second - field: blks_hit type: 0 unit: blocks per second - field: blk_read_time type: 0 unit: ms - field: blk_write_time type: 0 unit: ms - field: stats_reset type: 1 protocol: jdbc jdbc: host: ^_^host^_^ port: ^_^port^_^ timeout: ^_^timeout^_^ platform: postgresql username: ^_^username^_^ password: ^_^password^_^ database: ^_^database^_^ queryType: multiRow sql: SELECT COALESCE(datname,'shared-object') as db_name, conflicts, deadlocks, blks_read, blks_hit, blk_read_time, blk_write_time, stats_reset from pg_stat_database where (datname != 'template1' and datname != 'template0') or datname is null; url: ^_^url^_^ - name: activity priority: 2 fields: - field: running type: 0 unit: sbc protocol: jdbc jdbc: host: ^_^host^_^ port: ^_^port^_^ timeout: ^_^timeout^_^ platform: postgresql username: ^_^username^_^ password: ^_^password^_^ database: ^_^database^_^ queryType: oneRow sql: SELECT count(*) as running FROM pg_stat_activity WHERE NOT pid=pg_backend_pid(); url: ^_^url^_^ - name: resource_config priority: 1 fields: - field: work_mem type: 0 unit: MB - field: shared_buffers type: 0 unit: MB - field: autovacuum type: 1 - field: max_connections type: 0 - field: effective_cache_size type: 0 unit: MB - field: wal_buffers type: 0 unit: MB protocol: jdbc jdbc: host: ^_^host^_^ port: ^_^port^_^ timeout: ^_^timeout^_^ platform: postgresql username: ^_^username^_^ password: ^_^password^_^ database: ^_^database^_^ queryType: columns sql: show all; url: ^_^url^_^ - name: connection priority: 1 fields: - field: active type: 0 protocol: jdbc jdbc: host: ^_^host^_^ port: ^_^port^_^ timeout: ^_^timeout^_^ platform: postgresql username: ^_^username^_^ password: ^_^password^_^ database: ^_^database^_^ queryType: oneRow sql: select count(1) as active from pg_stat_activity; url: ^_^url^_^ - name: connection_state priority: 1 fields: - field: state type: 1 label: true - field: num type: 0 protocol: jdbc jdbc: host: ^_^host^_^ port: ^_^port^_^ timeout: ^_^timeout^_^ platform: postgresql username: ^_^username^_^ password: ^_^password^_^ database: ^_^database^_^ queryType: multiRow sql: select COALESCE(state, 'other') as state, count(*) as num from pg_stat_activity group by state; url: ^_^url^_^ - name: connection_db priority: 1 fields: - field: db_name type: 1 label: true - field: active type: 0 protocol: jdbc jdbc: host: ^_^host^_^ port: ^_^port^_^ timeout: ^_^timeout^_^ platform: postgresql username: ^_^username^_^ password: ^_^password^_^ database: ^_^database^_^ queryType: multiRow sql: select count(*) as active, COALESCE(datname, 'other') as db_name from pg_stat_activity group by datname; url: ^_^url^_^ - name: tuple priority: 1 fields: - field: fetched type: 0 - field: returned type: 0 - field: inserted type: 0 - field: updated type: 0 - field: deleted type: 0 protocol: jdbc jdbc: host: ^_^host^_^ port: ^_^port^_^ timeout: ^_^timeout^_^ platform: postgresql username: ^_^username^_^ password: ^_^password^_^ database: ^_^database^_^ queryType: multiRow sql: select sum(tup_fetched) as fetched, sum(tup_updated) as updated, sum(tup_deleted) as deleted, sum(tup_inserted) as inserted, sum(tup_returned) as returned from pg_stat_database; url: ^_^url^_^ - name: temp_file priority: 1 fields: - field: db_name type: 1 label: true - field: num type: 0 - field: size type: 0 unit: B protocol: jdbc jdbc: host: ^_^host^_^ port: ^_^port^_^ timeout: ^_^timeout^_^ platform: postgresql username: ^_^username^_^ password: ^_^password^_^ database: ^_^database^_^ queryType: multiRow sql: select COALESCE(datname, 'other') as db_name, sum(temp_files) as num, sum(temp_bytes) as size from pg_stat_database group by datname; url: ^_^url^_^ - name: lock priority: 1 fields: - field: db_name type: 1 label: true - field: conflicts type: 0 unit: times - field: deadlocks type: 0 unit: times protocol: jdbc jdbc: host: ^_^host^_^ port: ^_^port^_^ timeout: ^_^timeout^_^ platform: postgresql username: ^_^username^_^ password: ^_^password^_^ database: ^_^database^_^ queryType: multiRow sql: SELECT COALESCE(datname,'shared-object') as db_name, conflicts, deadlocks from pg_stat_database where (datname != 'template1' and datname != 'template0') or datname is null; url: ^_^url^_^ - name: slow_sql priority: 1 fields: - field: sql_text type: 1 label: true - field: calls type: 0 - field: rows type: 0 - field: avg_time type: 0 unit: ms - field: total_time type: 0 unit: ms aliasFields: - query - calls - rows - total_exec_time - mean_exec_time calculates: - sql_text=query - avg_time=mean_exec_time - total_time=total_exec_time protocol: jdbc jdbc: host: ^_^host^_^ port: ^_^port^_^ timeout: ^_^timeout^_^ platform: postgresql username: ^_^username^_^ password: ^_^password^_^ database: ^_^database^_^ queryType: multiRow sql: select * from pg_stat_statements; url: ^_^url^_^ - name: transaction priority: 2 fields: - field: db_name type: 1 label: true - field: commits type: 0 unit: times - field: rollbacks type: 0 unit: times protocol: jdbc jdbc: host: ^_^host^_^ port: ^_^port^_^ timeout: ^_^timeout^_^ platform: postgresql username: ^_^username^_^ password: ^_^password^_^ database: ^_^database^_^ queryType: multiRow sql: select COALESCE(datname, 'other') as db_name, sum(xact_commit) as commits, sum(xact_rollback) as rollbacks from pg_stat_database group by datname; url: ^_^url^_^ - name: conflicts priority: 2 fields: - field: db_name type: 1 label: true - field: tablespace type: 0 - field: lock type: 0 - field: snapshot type: 0 - field: bufferpin type: 0 - field: deadlock type: 0 protocol: jdbc jdbc: host: ^_^host^_^ port: ^_^port^_^ timeout: ^_^timeout^_^ platform: postgresql username: ^_^username^_^ password: ^_^password^_^ database: ^_^database^_^ queryType: multiRow sql: select datname as db_name, confl_tablespace as tablespace, confl_lock as lock, confl_snapshot as snapshot, confl_bufferpin as bufferpin, confl_deadlock as deadlock from pg_stat_database_conflicts; url: ^_^url^_^ - name: cache_hit_ratio priority: 2 fields: - field: db_name type: 1 label: true - field: ratio type: 0 unit: '%' aliasFields: - blks_hit - blks_read - db_name calculates: - ratio=(blks_hit + 1) / (blks_read + blks_hit + 1) * 100 protocol: jdbc jdbc: host: ^_^host^_^ port: ^_^port^_^ timeout: ^_^timeout^_^ platform: postgresql username: ^_^username^_^ password: ^_^password^_^ database: ^_^database^_^ queryType: multiRow sql: select datname as db_name, blks_hit, blks_read from pg_stat_database; url: ^_^url^_^ - name: checkpoint priority: 2 fields: - field: checkpoint_sync_time type: 0 unit: ms - field: checkpoint_write_time type: 0 unit: ms protocol: jdbc jdbc: host: ^_^host^_^ port: ^_^port^_^ timeout: ^_^timeout^_^ platform: postgresql username: ^_^username^_^ password: ^_^password^_^ database: ^_^database^_^ queryType: oneRow sql: select checkpoint_sync_time, checkpoint_write_time from pg_stat_bgwriter; url: ^_^url^_^ - name: buffer priority: 2 fields: - field: allocated type: 0 - field: fsync_calls_by_backend type: 0 - field: written_directly_by_backend type: 0 - field: written_by_background_writer type: 0 - field: written_during_checkpoints type: 0 protocol: jdbc jdbc: host: ^_^host^_^ port: ^_^port^_^ timeout: ^_^timeout^_^ platform: postgresql username: ^_^username^_^ password: ^_^password^_^ database: ^_^database^_^ queryType: oneRow sql: select buffers_alloc as allocated, buffers_backend_fsync as fsync_calls_by_backend, buffers_backend as written_directly_by_backend, buffers_clean as written_by_background_writer, buffers_checkpoint as written_during_checkpoints from pg_stat_bgwriter; url: ^_^url^_^