Postgres Pro Enterprise Manager : Documentation: 2: 46.5. Clustering Processes : Postgres Professional

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

epub pdf