Skip to main content

Query Admin

The Query Admin tab lists recent and in-progress SQL queries that Mitzu has sent to your data warehouse on behalf of this workspace. Use it to spot slow queries, debug unexpected load, or cancel a runaway query before it finishes.

image

Executed SQL queries​

The table shows the latest queries Mitzu executed for this workspace, with the following columns:

  • Owner email — the Mitzu user whose action triggered the query (e.g. opening an insight or refreshing a dashboard).
  • Created — how long ago Mitzu submitted the query to the warehouse. Badges turn red once the query has been running for more than a minute.
  • Source — the kind of action that produced the query (Insight, Dashboard, Public dashboard, Cohort, Query info, Indexing). Click the source button to open the originating page in a new tab.
  • Statistics — warehouse-reported metrics such as bytes processed, rows returned, or elapsed time. Contents depend on the adapter (Postgres, BigQuery, Snowflake, etc.).
  • Status — the current state reported by the warehouse (running, done, cancelled, or error). A red close icon appears next to queries that are still running — click it to cancel the query.

Only the latest 30 queries are shown. Older queries are dropped from the list once newer ones are submitted.

Refresh​

Click Refresh to re-fetch the latest queries from the warehouse. Mitzu does not poll automatically — you need to refresh the list to see newly started queries and updated states.

Cancel a running query​

To stop a query that is still running, click the red × icon in the Status column. Mitzu sends a cancel request to the warehouse; once acknowledged, the status updates to Cancelled.

warning

Cancelling a query only stops the warehouse-side execution. The Mitzu page that triggered the query may still show a loading state until it times out or is refreshed.