Skip to main content

MV_QUERIES

This view describes queries seen by SingleStoreDB.

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