5.4.6 The rpd_query_stats Table

Note

The Performance Schema table described here is available as of MySQL 8.0.24. HeatWave ML queries are shown from MySQL 8.0.31.

The rpd_query_stats table stores query compilation and execution statistics produced by the HeatWave plugin in JSON format. One row of data is stored for each query. The table stores data for the last 1000 executed queries. Data is stored for successfully processed queries and failed queries.

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

The rpd_query_stats table has these columns:

• QUERY_ID

  The query ID. The counter is auto-incremented for each RAPID or (from MySQL 8.0.31) HeatWave ML query.

• QUERY_TEXT

  The RAPID engine query or HeatWave ML query run by the user.

• QEXEC_TEXT

  Query execution log. For HeatWave ML, this contains the arguments the user passed to the HeatWave ML routine call.

• QKRN_TEXT

  Logical query execution plan. This field is not used for HeatWave ML queries.

• QEP_TEXT

  Physical query execution plan. This field is not used for HeatWave ML queries.

  Includes prepart data, which can be queried to determine if a JOIN or GROUP BY query used data placement partitions. See Section 2.14, “Metadata Queries”.