The Performance Schema table described here is available as of MySQL 8.0.24.
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.
The rpd_query_stats
table has these columns:
-
QUERY_ID
The query ID.
-
QUERY_TEXT
The query.
-
QEXEC_TEXT
Query execution log.
-
QKRN_TEXT
Logical query execution plan.
-
QEP_TEXT
Physical query execution plan.
Includes
prepart
data, which can be queried to determine if aJOIN
orGROUP BY
query used data placement partitions. See Section 2.15, “Metadata Queries”.