Request a Demo
46.6. Reindexing or Index Creation Processes
Prev UpChapter 46. ActivityHome Next

46.6. Reindexing or Index Creation Processes #

46.6.1. Viewing Reindexing or Index Creation Processes
46.6.2. Canceling a Reindexing or Index Creation Process
46.6.3. Terminating the User Session for a Reindexing or Index Creation Process

You can view information about reindexing (REINDEX) or index creation (CREATE INDEX) processes. The information is based on the pg_stat_progress_create_index view.

46.6.1. Viewing Reindexing or Index Creation Processes #

Go to reindexing or index creation processes in one of the following ways:

  • Using the monitoring section:

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

    2. Select Reindex, 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 Reindex, and then in the top-right corner of the page, select the database.

The table of reindexing or index creation 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 reindexing or index creation phase.

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

  • Database: The name of the database where reindexing or index creation is being performed.

  • User: The name of the DBMS user on behalf of which reindexation or index creation is being performed.

  • Table: The name or ID of the table for which reindexing or index creation is being performed.

  • Index: The name or ID of the index being reindexed or created.

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

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

  • Done, %: The percentage of table data processed in the current phase of reindexing or index creation.

    This column includes additional information:

    • Total size: The total size of the table data to be processed.

    • Done size: The size of the processed table data.

  • Tuples done, %: The percentage of table rows processed in the current phase of reindexing or index creation.

    This column includes additional information:

    • Total size: The total number of table rows to be processed.

    • Done size: The number of processed table rows.

  • Lockers: The processes locked when performing reindexing or index creation.

    This column includes additional information:

    • Done: The number of locked processes for which the waiting is finished.

    • Total: The total number of locked processes.

    • PID: The ID of the currently locked process.

  • Partitions done, %: The percentage of partitioned tables processed when performing reindexing or index creation.

    This column includes additional information:

    • Total: The total number of partitioned tables to be processed.

    • Done: The number of processed partitioned tables.

  • Actions.

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

46.6.2. Canceling a Reindexing or Index Creation Process #

Canceling a reindexing or index creation process does not terminate a user session.

To cancel a reindexing or index creation process:

  1. Go to reindexing or index creation processes in one of the following ways:

    • Using the monitoring section:

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

      2. Select Reindex, 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 Reindex, and then in the top-right corner of the page, select the database.

  2. Click Cancel current request next to the reindexing or index creation process.

  3. Click Execute.

46.6.3. Terminating the User Session for a Reindexing or Index Creation Process #

When the user session is terminated, the reindexing or index creation process is canceled automatically.

To terminate the user session for a reindexing or index creation process:

  1. Go to reindexing or index creation processes in one of the following ways:

    • Using the monitoring section:

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

      2. Select Reindex, 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 Reindex, and then in the top-right corner of the page, select the database.

  2. Click Cancel session next to the reindexing or index creation process.

  3. Click Execute.

Prev Up Next
46.5. Clustering Processes Home 46.7. Base Backup Processes
epub pdf