Help Center/ GaussDB/ Developer Guide(Distributed_8.x)/ SQL Reference/ Functions and Operators/ Hotkey Feature Functions
Updated on 2024-08-20 GMT+08:00
View PDF
Share

Hotkey Feature Functions

  • gs_stat_get_hotkeys_info()

    Description: Obtains hotkey information queried on the local node.

    Return type: Tuple

    Example:

    1
2
3
4
5
6
    		 
    gaussdb=# SELECT * FROM  gs_stat_get_hotkeys_info() order by count, hash_value;
 database_name | schema_name |    table_name     | key_value | hash_value | count 
---------------+-------------+-------------------+-----------+------------+-------
 regression    | public      | hotkey_single_col | {22}      | 1858004829 |     2
 regression    | public      | hotkey_single_col | {11}      | 2011968649 |     2
(2 rows)
  • gs_stat_clean_hotkeys()

    Description: Clears hotkey cache and resets hotkey status information.

    Return type: bool, and the return value is always true.

    Example:

    1
2
3
4
5
    		 
    gaussdb=# SELECT * FROM  gs_stat_clean_hotkeys();
 gs_stat_clean_hotkeys 
-----------------------
 t
(1 row)
Parent topic: Functions and Operators