Request a Demo
46.3. Vacuum Processes
Prev UpChapter 46. ActivityHome Next

46.3. Vacuum Processes #

46.3.1. Viewing Vacuum Processes
46.3.2. Canceling a Vacuum Process
46.3.3. Terminating the User Session for a Vacuum Process

You can view information about vacuum (VACUUM) and autovacuum (autovacuum) processes. The information is based on the pg_stat_progress_vacuum view.

46.3.1. Viewing Vacuum Processes #

Go to vacuum processes in one of the following ways:

  • Using the monitoring section:

    1. In the navigation panel, go to Monitoring → Activity.

    2. Select Vacuum, and then in the top-right corner of the page, select the instance and database.

  • Using the configuration section of an instance:

    1. In the navigation panel, go to Infrastructure → Instances.

    2. Click the name of the instance.

    3. In the navigation panel, go to Activity.

    4. Select Vacuum, and then in the top-right corner of the page, select the database.

The table of vacuum processes with the following columns will be displayed:

  • PID: The ID of the backend.

  • State: The state of the backend.

    For more information about possible values, refer to the official Postgres Pro documentation on the pg_stat_activity module (refer to the state column).

  • Wait event: The name and type of the wait event for the backend.

    For more information, refer to the official Postgres Pro documentation on the pg_stat_activity module (refer to wait_event_type and wait_event columns).

  • Phase: The vacuum phase.

    For more information about possible values, refer to the official Postgres Pro documentation.

  • Database: The name of the database being vacuumed.

  • User: The name of the DBMS user on behalf of which vacuum is being performed.

  • Table: The name or ID of the table being vacuumed.

  • Query: The text of the current or last backend query.

  • Query duration: The duration of the current or last backend query.

  • Heap size: The size of the table for which vacuum is being performed.

  • Total size: The total size of the table, including indexes, for which vacuum is being performed.

  • Scanned, %: The percentage of data scanned in the table being vacuumed.

    This column includes additional information:

    Size: The size of scanned table data.

  • Vacuumed, %: The percentage of vacuumed table data.

    This column includes additional information:

    Size: The size of vacuumed table data.

  • Index vacuum: The number of vacuumed table indexes.

  • Memory usage, %: Usage of the memory that stores pointers to expired versions of table rows.

    For more information, refer to the official Postgres Pro documentation on the autovacuum_work_mem and maintenance_work_mem parameters.

  • Actions.

    For more information about available actions, refer to the corresponding instructions.

46.3.2. Canceling a Vacuum Process #

Canceling a vacuum process does not terminate a user session.

To cancel a vacuum process:

  1. Go to vacuum processes in one of the following ways:

    • Using the monitoring section:

      1. In the navigation panel, go to Monitoring → Activity.

      2. Select Vacuum, and then in the top-right corner of the page, select the instance and database.

    • Using the configuration section of an instance:

      1. In the navigation panel, go to Infrastructure → Instances.

      2. Click the name of the instance.

      3. In the navigation panel, go to Activity.

      4. Select Vacuum, and then in the top-right corner of the page, select the database.

  2. Click Cancel current request next to the vacuum process.

  3. Click Execute.

46.3.3. Terminating the User Session for a Vacuum Process #

When the user session is terminated, the vacuum process is canceled automatically.

To terminate the user session for a vacuum process:

  1. Go to vacuum processes in one of the following ways:

    • Using the monitoring section:

      1. In the navigation panel, go to Monitoring → Activity.

      2. Select Vacuum, and then in the top-right corner of the page, select the instance and database.

    • Using the configuration section of an instance:

      1. In the navigation panel, go to Infrastructure → Instances.

      2. Click the name of the instance.

      3. In the navigation panel, go to Activity.

      4. Select Vacuum, and then in the top-right corner of the page, select the database.

  2. Click Cancel session next to the vacuum process.

  3. Click Execute.

Prev Up Next
46.2. Wait Event Statistics Home 46.4. Statistics Collection Processes
epub pdf