EnterpriseDB Supplemental Guide: Database Read/Write Activity Report

2.1.2 Database Read/Write Activity Report

Database read/write activity is graphically represented by the bar charts on the DBA Management Server home page.

● The Transactions bar chart shows the number of transactions committed.

● The Memory Reads bar chart displays the number of cache block hits.

● The Disk Reads bar chart displays the number of physical disk blocks read.

Figure 4 Database Read/Write Activity

In addition to the database read/write activity, the home page also contains a table summarizing the following information on each row for each configured database.

● Database - Database name in the format hostname:port/database

● Version - The database’s major and minor version number

● Owner - The name of the database owner

● DB Size - Size of the database using KB, MB, GB, or TB as appropriate

● Active Sessions - The number of active sessions

● Server Uptime - The amount of time since the database server has been started

● Query Logging - Shows if Query Logging is currently on or off for a configured database. The entire row is displayed in red if Query Logging is on, or black if Query Logging is off. For more details on enabling/disabling Query Logging refer to the Query Profiler.

The DB Size and Server Uptime columns are only available with EnterpriseDB and PostgreSQL versions 8.1 and above.

If a server is not available, the tab for that server will appear greyed out with a red cross on it as shown in the following figure.

Figure 5 Unavailable Server

The report can be refreshed by clicking on the Refresh Report link.

When multiple data sources are configured, each is assigned a different color to differentiate each source. If a data source is not available or one of the connection parameters defined in the configure.xml file is incorrect, an appropriate error message is displayed.