Updated on 2024-05-07 GMT+08:00

GLOBAL_STAT_HOTKEYS_INFO

GLOBAL_STAT_HOTKEYS_INFO is used to query the statistics of hotspot keys in the entire cluster. The query results are sorted by count in descending order.

Table 1 GLOBAL_STAT_HOTKEYS_INFO columns

Name

Type

Description

database_name

text

Name of the database where the hot key is located.

schema_name

text

Name of the mode where the hotspot key is located.

table_name

text

Name of the table where the hotspot key is located.

key_value

text

Value of the hotspot key.

hash_value

bigint

Hash value of the hotspot key in the database. If the table is a list or range distribution table, the value of this column is 0.

count

numeric

Frequency of accessing the hotspot key.