Help Center > > Developer Guide> System Catalogs and System Views> System Views> PGXC_GET_STAT_ALL_TABLES

PGXC_GET_STAT_ALL_TABLES

Updated at: Jul 15, 2020 GMT+08:00

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.

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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel