Online Documentation for SQL Manager for PostgreSQL
Database Statistics
The Database Statistics service is intended for browsing and reporting information about database activity.
Using the service, you can get count of accesses to tables and indexes. PostgreSQL also supports determining the exact command currently being executed by other server processes. Since collection of statistics adds some overhead to query execution, the system can be configured to collect or not collect information. This is controlled by configuration parameters that can easily can be set up with the help of the corresponding item of the Navigation bar.
To open the Database Statistics window, select the Services | 
Database Statistics main menu item, or right-click the database alias in the DB Explorer tree and select the Tasks | Database Statistics item from the context menu.
- Using Navigation bar and Toolbar
- Diagram view
- Browsing Object Statistics
- Browsing Column Statistics
- Browsing Database Statistics
- Saving/loading statistics
- Statistics Collector options
|
Availability: |
|
|
Full version (for Windows) |
Yes |
|
Lite version (for Windows) |
No |
|
Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page. |
|
|
See also: |
