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 | iconTools_DatabaseStatistic Database Statistics main menu item, or right-click the database alias in the DB Explorer tree and select the Tasks | iconTools_DatabaseStatistic Database Statistics item from the context menu.

 

menuDatabaseStatistics

 

 

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.