digoal
2020-09-11
PostgreSQL , pgMonitor
pgmonitor 集成了一些监控、可视化工具, 用于了解PostgreSQL健康相关的重要指标. 同时它支持定制化, 可以自定义metric. 由PG社区铂金贡献企业crunchy开源,值得信赖.
pgMonitor combines a suite of tools to facilitate the collection and visualization of important metrics that you need be aware of in your PostgreSQL database and your host environment, including:
- Connection counts: how busy is your system being accessed and if connections are hanging
- Database size: how much disk your cluster is using
- Replication lag: know if your replicas are falling behind in loading data from your primary
- Transaction wraparound: don't let your PostgreSQL database stop working
- Bloat: how much extra space are your tables and indexes using
- System metrics: CPU, Memory, I/O, uptime
pgMonitor is also highly configurable, and advanced users can design their own metrics, visualizations, and add in other features such as alerting.
Running pgMonitor will give you confidence in understanding how well your PostgreSQL cluster is performing, and will provide you the information to make calculated adjustments to your environment.
github: https://github.com/CrunchyData/pgmonitor
相关文档: https://info.crunchydata.com/blog/postgresql-node-metrics-pgnodemx
使用手册: https://access.crunchydata.com/documentation/pgmonitor/latest/
您的愿望将传达给PG kernel hacker、数据库厂商等, 帮助提高数据库产品质量和功能, 说不定下一个PG版本就有您提出的功能点. 针对非常好的提议，奖励限量版PG文化衫、纪念品、贴纸、PG热门书籍等，奖品丰富，快来许愿。开不开森.
