8.1.3 The rpd_exec_stats Table

The rpd_exec_stats table stores query execution statistics produced by MySQL HeatWave nodes in JSON format. One row of execution statistics is stored for each node that participates in the query. The table stores a maximum of 1000 queries.

For MySQL HeatWave AutoML routines that include multiple sub-queries, such as ML_TRAIN, a new record is used for each query.

The rpd_exec_stats table has these columns:

• QUERY_ID

  The query ID. The counter auto-increments for each MySQL HeatWave and MySQL HeatWave AutoML query.

• NODE_ID

  The MySQL HeatWave node ID.

• EXEC_TEXT

  Query execution statistics. For MySQL HeatWave AutoML, this contains the MySQL HeatWave AutoML routine that the user runs.