2.8.5.2 Unload Advisor Examples

• To view recommendations for tables to unload, for a particular schema:

  mysql> CALL sys.heatwave_advisor(JSON_OBJECT('auto_unload',JSON_OBJECT('mode','recommend')));
  +----------------------------------------------------------------------------------------------------------------------------------------------------------+
  | HEATWAVE UNLOAD ADVISOR                                                                                                                                  | 
  +----------------------------------------------------------------------------------------------------------------------------------------------------------+
  | This feature is in Preview Mode.                                                                                                                         |
  | Using:                                                                                                                                                   |
  |  "last_queried_hours": 24                                                                                                                                |
  |  "memory_gain_ascending": false                                                                                                                          |
  |  "limit_tables": 10                                                                                                                                      |                                                                                                                
  | Number of excluded tables: 0                                                                                                                             |
  |                                                                                                                                                          |
  | SCHEMA                   TABLE                                                                                 MEMORY GAIN               MEMORY GAIN     | 
  | NAME                     NAME                                                   REASON                    (HEATWAVE NODES)                    (HOST)     |
  | ------                   -----------      ---------------------------------------------     ------------------------------       -------------------     |
  | `tpch128`                `LINEITEM`         LAST QUERIED ON '2022-09-12 15:30:40.538585'                             10 GiB                     0 GiB    |
  | `tpch128`                `CUSTOMER`         LAST QUERIED ON '2022-09-12 15:30:40.538585'                             10 GiB                     5 GiB    |
  |                                                                                                                                                          |
  |                                                                                                                                                          |
  | Storage consumed by base relations after unload: 100 GiB                                                                                                 |
  +----------------------------------------------------------------------------------------------------------------------------------------------------------+