5.6 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 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 a JOIN or GROUP BY query used data placement partitions. See Section 2.15, “Metadata Queries”.