Updated on 2023-10-23 GMT+08:00

PGXC_GET_STAT_ALL_TABLES

PGXC_GET_STAT_ALL_TABLES obtains information about insertion, update, and deletion operations on tables and the dirty page rate of tables. Before running VACUUM FULL to a system catalog with a high dirty page rate, ensure that no user is performing operations on it. This view is a new function in GaussDB. After an upgrade to this version, statistics about insert, update, and deletion operations performed before the upgrade will not be collected. You are advised to run VACUUM FULL to tables (excluding system catalogs) whose dirty page rate exceeds 30% or run it based on service scenarios. Only users with the system admin or monitor admin permission can view the information.

Table 1 PGXC_GET_STAT_ALL_TABLES columns

Name

Type

Description

relid

oid

Table OID

relname

name

Table name

schemaname

name

Schema name of the table

n_tup_ins

numeric

Number of inserted tuples

n_tup_upd

numeric

Number of updated tuples

n_tup_del

numeric

Number of deleted tuples

n_live_tup

numeric

Number of live tuples

n_dead_tup

numeric

Number of dead tuples

dirty_page_rate

numeric(5,2)

Dirty page rate (%) of a table