• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PGXC_GET_STAT_ALL_TABLES

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 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.

Table 1 PGXC_GET_STAT_ALL_TABLES columns

Name

Type

Description

relid

oid

OID of a table

relname

name

Name of a table

schemaname

name

Schema name of a 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