Help Center/GaussDB/Developer Guide(Distributed_V2.0-8.x)/System Catalogs and System Views/System Views/VACUUM/GS_STAT_PROGRESS_VACUUM
Updated on 2025-08-19 GMT+08:00
View PDF

GS_STAT_PROGRESS_VACUUM

Displays the current VACUUM progress. The columns are described as follows:

Table 1 GS_STAT_PROGRESS_VACUUM columns

Parameter Type

Parameter

Description

Input parameter

pid

PID of the VACUUM thread.

Output parameter

dataname

Name of the database that is being cleared.

Output parameter

relid

OID of the table that is being cleared.

Output parameter

relname

Name of the table that is being cleared.

Output parameter

phase

Current VACUUM phase.

Output parameter

detail

Clearance progress details, including the total number of pages, number of scanned pages, number of cleared pages, and number of cleared indexes.

The running result is as follows:

gaussdb=# select * from GS_STAT_PROGRESS_VACUUM(140123447490304);
       pid       | dataname | relid | relname |     phase     |
         detail
-----------------+----------+-------+---------+---------------+---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------
 140123447490304 | postgres | 24602 | t1      | scanning heap | vacuum db "postgres" starts at 2025-02-09 13:34:24.497618-05, vacuumed 12/240 relations, current r
elation "t1"; heap: scanned 32369/73216 blocks, skipped 0 blocks; info: found 0 dead tuples, already run 357s, delay 356s.
(1 row)
Parent topic:VACUUM