Maintenance
Примечание
The maintenance page is available for primary and standalone(standalone) PostgreSQL instances and not available for Hot Standby instances.
Main Page

When you go to the maintenance page, by default, a tab with maintenance options opens. You will see a list of databases and the percentage of table bloat, index bloat, and wraparound. There are three options in this menu (see number 2 in the picture above) for each database:
Fixed table bloat
Fix index bloat
Fix transaction counter overflow
History

The second tab contains the service history. On this page you will see a list of past services. If you select “Open” from the menu (see number 1 in the figure above), a detailed overview of the particular service will appear.

Detailed information about the maintenance performed can be seen on this screen. Information about before and after service (indicated by numbers 1 and 2 in the picture above) can be very helpful.
Fix Index Bloat

The list of indexes in the selected database will be presented on the “Index Bloat” page, sorted by the blow factor. To serve a specific index, click the «SELECT» button next to the selected index (you can select multiple indexes at once).

When you press «SELECT», the above window will appear with the following three actions:
REINDEX
VACUUM
VACUUM FULL

REINDEX: the command can be run with special parameters (see number 2 above). Then click the «Done» button.

VACUUM: the command can be run with special parameters (see number 2). Then click the «Done» button.

VACUUM FULL: the command can be run with special options (see number 2 above). Then click the «Done» button.
Fix Table Bloat

The “Table Bloat” page provides a list of tables in the selected database. To maintain a specific table, click the «SELECT» button next to the selected table (you can select multiple tables at once).

When you press «SELECT», the above window will appear with the following three actions:
ANALYZE
VACUUM
VACUUM FULL

VACUUM: the command can be run with special parameters (see number 2). Then click the «Done» button.

VACUUM FULL: the command can be run with special options (see number 2 above). Then click the «Done» button.
Fix transaction counter overflow (Fix Wraparound)

The “Wraparound Stats” page provides a list of tables in the selected database. To normalize the loop for a particular table, click the «SELECT» button next to the selected table (you can run multiple tables at the same time).

When you press «SELECT», the above window will appear with the following two actions:
VACUUM
VACUUM FULL

VACUUM: the command can be run with special parameters (see number 2). Then click the «Done» button.

VACUUM FULL: the command can be run with special options (see number 2 above). Then click the «Done» button.
Run Maintenance
Before you can start any maintenance, you must select the action you want to fix - fix an index bloat, a table bloat, or a transaction counter overflow.

After selecting an action, it will be indicated in the line of the object in the list (see number 1 in the figure above). By pressing the “Run Maintenance” button (see number 2 in the figure above). a warning window will appear.
Предупреждение
if you exit this screen (by clicking on any object outside its area), your selection will be reset.

Fill in the field with the word proceed (continue).
Click the “Run Maintenance” button to start maintenance.
After maintenance is completed, you can see the results on the Maintenance History tab.