Help Center/ GaussDB/ Developer Guide(Distributed_2.x)/ System Catalogs and System Views/ System Views/ GLOBAL_STAT_HOTKEYS_INFO
Updated on 2023-10-23 GMT+08:00
View PDF
Share

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 hotspot key is located.

schema_name

text

Name of the schema where the hotspot key is located.

table_name

text

Name of the table where the hotspot key is located.

key_value

text

Value of a 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 field is 0.

count

numeric

Frequency of accessing the hotspot key.
Parent topic: System Views