View monitoring_vacuum
View to monitor vacuum processes.
Columns
| Column Name | datatype | Description |
|---|---|---|
| database_name | name | The name of the database. |
| schema_name | regclass | The name of the schema. |
| table_name | regclass | The name of the table. |
| process_id | integer | The backend process id (pid). |
| progress | double precision | Current state of the vacuum process. |
Example
SELECT *
FROM monitoring_vacuum;
| database_name | schema_name | table_name | process_id | progress |
|---|---|---|---|---|
| stefanie | timetravel | timetravel | 2794 | 73.8 |