Help Center/ Data Warehouse Service/ Developer Guide/ Developer Guide (9.1.1.x)/ DWS System Catalogs and Views/ System Views/ PGXC_GET_ALL_TABLES_DIRTY_RATIO
Updated on 2026-07-02 GMT+08:00
View PDF
Share

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

1
 
SELECT * FROM PGXC_GET_ALL_TABLES_DIRTY_RATIO;

Parent Topic: System Views