Updated on 2023-10-23 GMT+08:00

GS_STAT_DB_CU

GS_STAT_DB_CU queries CU hits in a database and in each node in a cluster. You can clear it using gs_stat_reset(). This view can be viewed only by the users with monitor admin and sysadmin 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