2.7.6.3 Auto Query Time Estimation Examples

• To view runtime data for all queries in the HeatWave query history for a particular schema:

  Press CTRL+C to copy
   
  mysql> CALL sys.heatwave_advisor(JSON_OBJECT('target_schema',JSON_ARRAY('tpch'),
            'query_insights',true));

• To view runtime data for queries issued by the current session:

  Press CTRL+C to copy
   
  mysql> CALL sys.heatwave_advisor(JSON_OBJECT('query_insights',true, 
            'query_session_id', JSON_ARRAY(connection_id())));

• To view runtime data for queries issued by a particular session:

  Press CTRL+C to copy
   
  mysql> CALL sys.heatwave_advisor(JSON_OBJECT('query_insights', true, 
            'query_session_id', JSON_ARRAY(8)));

• This example demonstrates how to invoke the Auto Query Time Estimation in silent output mode, which is useful if the output is consumed by a script, for example.

  Press CTRL+C to copy
   
  mysql> CALL sys.heatwave_advisor(JSON_OBJECT('query_insights',true,'output','silent'));