MV_QUERIES

This view describes queries seen by SingleStore.

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

An ID shared by all instances of the activity. This ID is often human-readable, but does not include the query text for query tasks. This will be the activity_name of all query tasks associated with the query.

query_text

The de-parameterized text of the query.

Last modified: May 8, 2023

Was this article helpful?