Documentation Home
MySQL HeatWave User Guide
Related Documentation Download this Manual
PDF (US Ltr) - 1.0Mb
PDF (A4) - 1.0Mb


MySQL HeatWave User Guide  /  HeatWave Performance Schema Tables  /  The rpd_query_stats Table

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”.