通过psycopg2模块监控postgresql

最新推荐文章于 2023-08-22 16:31:17 发布

三支烟

最新推荐文章于 2023-08-22 16:31:17 发布

阅读量501

点赞数

CC 4.0 BY-SA版权

分类专栏： python 日常运维文章标签： pg zabbix

本文链接：https://blog.csdn.net/qq_36357820/article/details/98042208

最近做了关于postgresql数据库的简单监控，脚本如下：

import psycopg2
import sys

sqlItem = {
           'alive': "select 1;",  # 监控存活
           'active_connections': "select count(*) from pg_stat_activity where state = 'active';",  # 当前会话数
           'server_connections': "select count(*) from pg_stat_activity where backend_type = 'client backend'",  # 服务端进程数
           'idle_connections': "select count(*) from pg_stat_activity where state = 'idle'",  # 空闲连接
           'idle_tx_connections': "select count(*) from pg_stat_activity where state = 'idle in transaction'",  # 空闲连接事务
           'locks_waiting': "select count(*) from pg_stat_activity where backend_type = 'client backend' and wait_event_type like '%Lock%'",  # 锁等待
           'server_maxcon': "select setting::int from pg_settings where name = 'max_connections'",  # 服务端最大连接数
           'tx_commited': "select sum(xact_commit) from pg_stat_database",  # 事务提交
           'tx_rollbacked': "select sum(xact_rollback) from pg_stat_database