Online Documentation for SQL Manager for PostgreSQL

Browsing Database Statistics

The Database Statistics tab displays statistical data about the specified server databases.


Database Statistics - Browsing Database Statistics


The list displays databases as a grid with the following columns:

OID, Database, Number of Active Server Processes, Committed Transactions, Rolled Back Transactions, Total Disk Block Reads, Total Number of Buffer Hits, Rows Returned, Rows Fetched, Rows Inserted, Rows Updated, Rows Deleted.


If necessary, you can group the data in grid by any of the columns. This operation is performed by dragging the column header to the gray "Group by" box area at the top. When grouping by a column is applied to the grid, all the rows are displayed as subnodes to the grouping row value. To reverse grouping, just drag the column header back. If more convenient, you can change the order of the columns by dragging their headers horizontally.


Click a column caption to sort items by values of this column in the ascending or the descending mode.


Background writer statistics

This area is available for PostgreSQL 8.3. The following parameters pertaining to the selected database are available: Number of scheduled checkpoints, Requested checkpoints, Buffers written by checkpoints, Buffers cleaning scans, Number of times the background writer stopped a cleaning scan, Buffers written by backends, Total buffers allocated.