Help Center/ GaussDB/ Developer Guide(Distributed_8.x)/ System Catalogs and System Views/ System Views/ Other System Views/ GLOBAL_STAT_HOTKEYS_INFO

Updated on 2024-08-20 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 distributed table, the value of this column is 0.
count	numeric	Frequency of accessing the hotspot key.

Parent topic: Other System Views

Previous topic: GLOBAL_SQL_PATCH

Next topic: GLOBAL_WAL_SENDER_STATUS

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.