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

Previous topic: PG_STAT_ACTIVITY

Next topic: Other System Views