46.5. Clustering Processes

46.5. Clustering Processes
Prev	Up	Chapter 46. Activity	Home	Next

46.5. Clustering Processes #

46.5.1. Viewing Clustering Processes
46.5.2. Canceling a Clustering Process
46.5.3. Terminating the User Session for a Clustering Process

You can view information about clustering processes — reindexing tables (CLUSTER) and about full vacuum processes (VACUUM FULL). The information is based on the pg_stat_progress_cluster view.

46.5.1. Viewing Clustering Processes #

Go to clustering processes in one of the following ways:

Using the monitoring section:
1. In the navigation panel, go to Monitoring → Activity.
2. Select Cluster, 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 Cluster, and then in the top-right corner of the page, select the database.

The table of clustering 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 clustering phase.
For more information about possible values, refer to the official Postgres Pro documentation.
Database: The name of the database where clustering is being performed.
User: The name of the DBMS user on behalf of which clustering is being performed.
Table: The name or ID of the table for which clustering is being performed.
Query: The text of the current or last backend query.
Query duration: The duration of the current or last backend query.
Blocked totals: The number of user sessions blocked by the clustering process.
Heap scanned, %: The percentage of data scanned in the table for which clustering is being performed.
Heap total: The total size of the table for which clustering is being performed.
Scanned: The size of data scanned in the table for which clustering is being performed.
Tuples scanned: The number of rows scanned in the table for which clustering is being performed.
Tuples written: The number of rows written to the table for which clustering is being performed.
Actions.
For more information about available actions, refer to the corresponding instructions.

46.5.2. Canceling a Clustering Process #

Canceling a clustering process does not terminate a user session.

To cancel a clustering process:

Go to clustering processes in one of the following ways:
- Using the monitoring section:
  1. In the navigation panel, go to Monitoring → Activity.
  2. Select Cluster, 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 Cluster, and then in the top-right corner of the page, select the database.
Click next to the clustering process.
Click Execute.

46.5.3. Terminating the User Session for a Clustering Process #

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

To terminate the user session for a clustering process:

Go to clustering processes in one of the following ways:
- Using the monitoring section:
  1. In the navigation panel, go to Monitoring → Activity.
  2. Select Cluster, 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 Cluster, and then in the top-right corner of the page, select the database.
Click next to the clustering process.
Click Execute.

Prev	Up	Next
46.4. Statistics Collection Processes	Home	46.6. Reindexing or Index Creation Processes