Lu, Huayi
a24ca60074
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com> Co-authored-by: Lu, Huayi <luhuayi@huawei.com> Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
8.0 KiB
PGXC_GET_STAT_ALL_TABLES
PGXC_GET_STAT_ALL_TABLES displays 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 it.
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.
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 |
page_dirty_rate |
numeric(5,2) |
Dirty page rate (%) of a table |
GaussDB(DWS) also provides the pgxc_get_stat_dirty_tables(int dirty_percent, int n_tuples) and pgxc_get_stat_dirty_tables(int dirty_percent, int n_tuples, text schema) functions to quickly filter out tables whose dirty page rate is greater than dirty_percent, number of dead tuples is greater than n_tuples, and schema name is schema. For details, see "Functions and Operators > System Administration Functions > Other Functions" in the SQL Syntax.