Online Documentation for SQL Manager for PostgreSQL

Analyze Tables

Analyze Tables Wizard collects statistics about the contents of tables in the database, and stores the results in the system table pg_statistic (with PostgreSQL routines used). Subsequently, the query planner uses these statistics to help determine the most efficient execution plans for queries.


Note that Analyze Tables service is only available for the versions of PostgreSQL server 7.2 and higher.


To run the wizard, select the Services | iconServices_AnalyzeTables Analyze Tables... main menu item, or right-click the database alias in the DB Explorer tree and select the Tasks | iconServices_AnalyzeTables Analyze Tables... item from the context menu.






Full version (for Windows)


Lite version (for Windows)


Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page.