Online Documentation for SQL Manager for PostgreSQL

Browsing Object Statistics

The Object Statistics tab of the Database Statistics window displays statistics for each object of the specified type (table, index, sequence) in the current database.

The list displays the existing database objects as a grid with the following columns:

Schema, Table, OID, Sequential Scans, Row Reads by Sequential Scans, Index Scans, Rows Fetched by Index Scans, Rows Inserted, Rows Updated, Rows Deleted, Block Reads from Disk, Block Reads from Cache, Index Block Reads from Disk, Index Block Reads from Cache, Toast Block Reads from Disk, Toast Block Reads from Cache, Toast Index Block Reads from Disk, Toast Index Block Reads from Cache, Live Rows Read, Dead Rows Read (for tables);

Schema, Table, Index, OID, Index Scans, Index Tuple Reads, Index Tuple Fetches, Index Block Reads from Disk, Index Block Reads from Cache (for indexes);

Schema, Sequence, OID, Block Reads from Disk, Block Reads from Cache (for sequences).

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.

Statistics data can be also represented as a diagram. See Diagram view for more information.

Use the Object Group pane of the Navigation bar to select the type of objects to collect statistics for (Tables, Indices, Sequences), and whether All objects, User objects only or System objects only should be displayed.

The status bar at the bottom of the window displays type of statistics being currently displayed and the date/time they were collected.