Online Documentation for SQL Manager for PostgreSQL

Using Navigation bar and Toolbar

The Navigation bar and Toolbar provide quick access to tools implemented in Database Statistics.


Database Statistics - Using Navigation bar




iconDB select a database for collecting statistics



iconRefresh refresh the content of the active tab

iconPrint print the content of the active tab

iconSaveToFile save the statistics to an external file or memory

iconLoadFromFile load statistics from an external file or memory

iconTools_DBStats_CompareStats compare current statistics data with data of an existing one

iconProperties set Statistics Collector options

iconTools_DBStats_ResetStats reset current statistics

iconRestoreDefaultSize restore the default size and position of the window


Depending on the current tab selection, the Navigation bar expands to one or more additional panes with tab-specific actions that can be useful for working with statistics data:



Tick select the type of objects to collect statistics for (Tables, Indices, Sequences)

Tick select whether all statistics, query statistics, data change statistics or cache statistics should be collected

Tick select whether All objects, User objects only or System objects only should be displayed


Diagram Options

Tick specify the number of objects to be displayed in the diagram

Tick select the diagram criterion: Most frequent table scans (sequential and index), Number of scans, Updates, Inserts, Deletes, Most changed tables, Cache efficiency (for tables); Most frequently used indices, Most frequent scans, Cache efficiency (for indexes); Most frequent scans (for sequences).


NB: You can enable\disable Toolbars and Navigation bars at Environment options.