合 PG开源的巡检工具pg_gather

简介

GitHub：https://github.com/jobinau/pg_gather

This is a single SQL-only script for gathering performance and configuration data from PostgreSQL databases.
And another SQL script available for analyzing and generating detailed HTML reports from the collected data. Yes, everything SQL-Only!, leveraging the features of psql-The command-line utility of PostgreSQL

Supported Versions : 10, 11, 12, 13, 14, 15 & 16
Minimum support versions : PostgreSQL 9.5, 9.6

纯SQL脚本，只生成一个html报告文件。

缺点

需要导入数据库部分数据

安装

后续精彩内容已被站长无情隐藏，请输入验证码解锁本文！

验证码：

获取验证码： 请先关注本站微信公众号，然后回复“验证码”，获取验证码。在微信里搜索“AiDBA”或者“dbaup6”或者微信扫描右侧二维码都可以关注本站微信公众号。