8.1.8 The rpd_query_stats Table

The rpd_query_stats table stores query compilation and execution statistics produced by the MySQL 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.

For MySQL HeatWave AutoML routines that include multiple sub-queries, such as ML_TRAIN, a new record is used for each query.

The rpd_query_stats table has these columns:

  • CONNECTION_ID

    The ID of the connection.

  • QUERY_ID

    The query ID. The counter auto-increments for each MySQL HeatWave and MySQL HeatWave AutoML query.

  • MYSQL_QUERY_ID

    The MySQL Shell query ID. The counter auto-increments for each query run using MySQL Shell. Available as of MySQL 9.4.0.

  • QUERY_TEXT

    The RAPID engine query or MySQL HeatWave AutoML query run by the user.

  • QEXEC_TEXT

    Query execution log. For MySQL HeatWave AutoML, this contains the arguments the user passed to the MySQL HeatWave AutoML routine call.

  • QKRN_TEXT

    Logical query execution plan. This field is not used for MySQL HeatWave AutoML queries.

  • QEP_TEXT

    Physical query execution plan. This field is not used for MySQL HeatWave AutoML queries.

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

  • STATEMENT_ID

    The global query ID.

  • INTERNAL_OFFLOAD_FAIL_TEXT

    Internal offload failure message for the query failing the offload.

  • EXTERNAL_OFFLOAD_FAIL_TEXT

    External offload failure message for the query failing the offload.

  • OFFLOAD_FAIL_QUERY_SUBSTR_START

    Points to the start of the query substring that is responsible for the offload failure in the original query. Available as of MySQL 9.1.0.

  • OFFLOAD_FAIL_QUERY_SUBSTR_LEN

    Length of the query substring that is responsible for the offload failure in the original query from its start. Available as of MySQL 9.1.0.

  • EXPORT_FILE_PREFIX

    Contains the export file prefix used in queries that export query results to Object Storage. Available as of MySQL 9.1.1.