Online Documentation for SQL Manager for PostgreSQL

Analyze & Vacuum Table


Analyze & Vacuum Table Wizard collects statistics about the table contents, and reclaims storage occupied by deleted tuples (optionally). These operations can also be performed for multiple tables with the help of Analyze Tables and Vacuum Tables wizards.

 

To run the wizard, use the Analyze & vacuum item of the Navigation bar (or toolbar) in Table Editor, or right-click the table alias in the DB Explorer tree and select the Tasks | Analyze & Vacuum Table... item from the context menu.

 

 

menuAnalyze&Vacuum

 

 

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.