Tag:http io os use data on c log code
A good news: in September, the PostgreSQL OPM development team released the first release version of the open source PostgreSQL database Monitoring Suite, OPM v2.3.
PostgreSQL is an advanced advanced database, but one of its major drawbacks is the lack of open source specialized monitoring tools. Compared to its competitors, the PostgreSQL community has not been able to provide a set of product-like monitoring tools similar to Oracle Grid control,mysql Workbench or SQL Server Management Studio. The OPM project is a complete open source management suite that provides graphical interfaces, dynamic charting, custom statistics, performance analysis, server health, and packet management capabilities.
If you are using a large number of PostgreSQL servers in production, Open PostgreSQL monitoring can observe the status of the current database in full, such as db size, hit ratio, streaming replication Lags, System load, page bloat, longest queries, WAL files generation, locks, backends status, etc.
This initial public release is the first step towards more functionality and a more diversified development. OPM includes remote agents, a data storage system, and a Web interface. Most of the code is currently in Perl and the information collected is based on Nagios, but the entire suite is designed to be extended to other monitoring frameworks and other languages. It may be your own remote agent, a specific data store, or another user interface.
The OPM project began in 2012 and has been running for months in production environments. Today, the OPM development team released version 2.3, hoping it would help the world's many users of PostgreSQL.
RELATED links:
website:http://opm.io/
Demo:http://demo.opm.io (Login/pass = Opm/demo)
Twitter: @opm
Original address:
http://www.postgresql.org/about/news/1542/
Open Source PostgreSQL monitoring tool OPM