Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-2.x)/ System Catalogs and System Views/ System Views/ GLOBAL_STAT_HOTKEYS_INFO
Updated on 2025-08-19 GMT+08:00
View PDF

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 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 distributed table, the value of this column is 0.

count

numeric

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