pgwatch is an enterprise scale monitoring solution for PostgreSQL. It helps you to monitor PostgreSQL databases from version 9.0 on and provides you with a fast and efficient overview of what is really going on on your systems. pgwatch is 100% Open Source and can be downloaded for free.
PLEASE NOTE: Version 1 of pgwatch is no longer being developed and is not recommended for current PostgreSQL versions!
We are currently working on pgwatch 2.0 with many new features, new look and feel and top performance.
- Simple configuration
- Many pre-defined graphs
- Dashboard: Gain insights
- Automatic gathering of data
- Interactive Flash-charts
- Integrated SQL worksheet
We support PostgreSQL 9.0 and 9.1. Future releases of PostgreSQL will be supported by future versions of pgwatch.
How does it work?
pgwatch is based on a daemon which periodically collects data from your database infrastructure. All data is stored in a centralized database and used by pgwatch. All you have to do is to open your favorite web browser and have a look at the data and graphs.
pgwatch can be downloaded and used freely under the terms of the Creative Commons license.
pgwatch: Professional PostgreSQL monitoring
The default-setup of pgwatch provides a rich set of pre-defined graphs which are essential to figure out what your database systems are really doing.
This information is available out of the box:
- Disk I/O
- Cache hit rates
- Checkpointing behavior
- System activity
- Open database connections
- Current queries
- COMMITs and ROLLBACKs
- Optimizer information
- Sequentual scans
- Index scans