Database Reference
In-Depth Information
Where to find more information about generic
monitoring tools
Setting up the tools themselves is a larger topic, and outside the scope of this topic. In fact,
each of these tools have more than one topic written about them. The basic setup information
and the tools themselves can be found at the following URLs:
F
RRDtool (
http://www.mrtg.org/rrdtool/)
F
Cacti (
http://www.cacti.net/)
F
Munin
(http://munin-monitoring.org/)
F
Nagios
(
http://www.nagios.org/
)
Realtime view using pgAdmin
You can also use pgAdmin to get a quick view of what is going on in the database. To do this,
connect to the database, and then select menu item Tools | Server Status. This will open a
window similar to the following screenshot, showing locks and running transactions:
