The Performance Schema table described here is available as of MySQL 8.0.24. HeatWave ML queries are shown from MySQL 8.0.31.
rpd_query_stats table stores query
compilation and execution statistics produced by the HeatWave
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
a new record is used for each query.
rpd_query_stats table has these
The query ID. The counter is auto-incremented for each
RAPIDor (from MySQL 8.0.31) HeatWave ML query.
RAPIDengine query or HeatWave ML query run by the user.
Query execution log. For HeatWave ML, this contains the arguments the user passed to the HeatWave ML routine call.
Logical query execution plan. This field is not used for HeatWave ML queries.
Physical query execution plan. This field is not used for HeatWave ML queries.
prepartdata, which can be queried to determine if a
GROUP BYquery used data placement partitions. See Section 2.14, “Metadata Queries”.