Help Center> GaussDB> Distributed_8.x> System Catalogs and System Views> System Views> Other System Views> GLOBAL_STAT_HOTKEYS_INFO
Updated on 2024-06-03 GMT+08:00
View PDF

GLOBAL_STAT_HOTKEYS_INFO

GLOBAL_STAT_HOTKEYS_INFO queries 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.
Parent topic: Other System Views