11.10.7 The rpd_query_stats Table

Note

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 200 executed queries. Data is stored only for successfully executed queries.

The rpd_query_stats table has these columns:

• QUERY_ID

  The query ID.

• QUERY_TEXT

  The query.

• QEXEC_TEXT

  Query execution plan.

• QKRN_TEXT

  Logical query execution plan.

• QEP_TEXT

  Query execution log.

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