Maintenance

maintenance feature gives user an overview on the databases, schemas, tables or indexes respective size.

It’s very useful to get information about bloat and toast. This can help users determine potential issues and understand or prevent performance issues due to unaccordingly used space.

The maintenance feature also provides easy access to administrative actions such as VACUUM, ANALYZE or REINDEX in order to fix space or performances problems.

Note

Please beware that the values for bloat, toast, etc… are estimated. They may not perfectly reflect the reality especially if there hasn’t been any analyze performed recently.

Views

The maintenance plugin lets you navigate through databases, schemas and tables of the instance.

The page for one table shows more detailed information.

Hints

Once in a while temBoard may be able to provide some hints on actions to perform on tables or indexes.

Actions

If you’re logged onto the agent, you may then be able to perform actions by clicking on the dedicated buttons.

temBoard can let you launch different actions such as ANALYZE, VACUUM or REINDEX

You can also choose either to launch the action immediately or in the future at the date and time you decide.