PGXC_GET_ALL_TABLES_DIRTY_RATIO

PGXC_GET_ALL_TABLES_DIRTY_RATIO is used to obtain the dirty page ratios and sizes for the cudesc and delta tables and CU files of all HStore_opt tables in the current database. This view is supported only by clusters of version 9.1.1.200 or later.

**Table 1** PGXC_GET_ALL_TABLES_DIRTY_RATIO columns
Name	Type	Description
database_name	name	Name of the database where a table is located
schema_name	name	Schema name of the table
group_name	name	Name of the logical cluster where the table is located
rel_name	name	Table name
partition_name	name	Partition name of the table
cudesc_min_size	bigint	Size of the smallest cudesc table on each DN
cudesc_max_size	bigint	Size of the largest cudesc table on each DN
cudesc_avg_size	numeric	Average size of cudesc tables on each DN
cudesc_max_dirty_ratio	bigint	Maximum dirty page ratio for cudesc tables on each DN
delta_min_size	bigint	Size of the smallest delta table on each DN
delta_max_size	bigint	Size of the largest delta table on each DN
delta_avg_size	numeric	Average size of delta tables on each DN
delta_max_dirty_ratio	bigint	Maximum dirty page ratio for delta tables on each DN
cu_min_size	bigint	Size of the CU file of the smallest table on each DN
cu_max_size	bigint	Size of the CU file of the largest table on each DN
cu_avg_size	numeric	Average size of the CU files of the tables on each DN
cu_max_dirty_ratio	bigint	Maximum dirty page ratio for the CU files of tables on each DN

Example

Use the PGXC_GET_ALL_TABLES_DIRTY_RATIO view to query the dirty page ratios and sizes for the cudesc and delta tables and CU files of all HStore_opt tables in the current database.

     
          SELECT * FROM PGXC_GET_ALL_TABLES_DIRTY_RATIO;
database_name | schema_name |    group_name     |        rel_name        | partition_name | cudesc_min_size | cudesc_max_size | cudesc_avg_size | cudesc_max_dirty_ratio | delta_min_size | delta_max_size | delta_avg_size |
delta_max_dirty_ratio | cu_min_size | cu_max_size | cu_avg_size | cu_max_dirty_ratio
---------------+-------------+-------------------+------------------------+----------------+-----------------+-----------------+-----------------+------------------------+----------------+----------------+----------------+-
----------------------+-------------+-------------+-------------+--------------------
postgres      | dbms_om     | def_regress_group | gs_wlm_session_info_v2 | p_maximum      |           24576 |           24576 |           24576 |                      0 |          16384 |          16384 |          16384 |
0 |           0 |           0 |           0 |                  0
postgres      | public      | def_regress_group | test2                  |                |           98304 |           98304 |           98304 |                      0 |         704512 |         704512 |         704512 |
0 |      491520 |      491520 |      491520 |                 60
(2 rows)