SingleStore Managed Service

mv_queries

The mv_queries view in the information_schema database describes queries seen by SingleStore DB. It holds a row for each query sent to the cluster by a user, as well as rows for artificial queries sent between nodes according to internal SingleStore DB logic.

Its purpose is to map the activity_name of query activities to their associated de-parameterized query text.

mv_queries may only be queried while connected to an aggregator node.

Column name

Description

activity_name

The ID associated with the query. This will be the activity_name of all query tasks associated with the query.

query_text

The de-parameterized text of the query.