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 |
Last Article: PGXC_COMM_STATUS
Next Article: PGXC_GET_TABLE_SKEWNESS
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.