Maintenance

Примечание

The maintenance page is available for primary and standalone(standalone) PostgreSQL instances and not available for Hot Standby instances.

Main Page

../_images/image63.png

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

../_images/image70.png

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.

../_images/image64.png

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

../_images/image54.png

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).

../_images/image57.png

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

  1. REINDEX

  2. VACUUM

  3. VACUUM FULL

../_images/image97.png

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

../_images/image73.png

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

../_images/image16.png

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

Fix Table Bloat

../_images/image107.png

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).

../_images/image89.png

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

  1. ANALYZE

  2. VACUUM

  3. VACUUM FULL

image5
ANALYZE: according to the version of the instance, the command can be run with special parameters (see number 2 above). Then click the «Done» button.
../_images/image73.png

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

../_images/image16.png

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)

../_images/image66.png

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).

../_images/image4.png

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

  1. VACUUM

  2. VACUUM FULL

../_images/image73.png

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

../_images/image16.png

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.

../_images/image171.png

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.

../_images/image124.png
  • 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.