Updated on 2025-07-15 GMT+08:00

GS_STAT_DB_CU

GS_STAT_DB_CU displays CU hits on each node in each database in the cluster. You can clear it using gs_stat_reset(). This view can be viewed only by the users with SYSADMIN or MONADMIN permission.

Table 1 GS_STAT_DB_CU columns

Name

Type

Description

node_name1

text

Node name

db_name

text

Database name

mem_hit

bigint

Number of memory hits

hdd_sync_read

bigint

Number of synchronous hard disk reads

hdd_asyn_read

bigint

Number of asynchronous hard disk reads