Organization administrators can now access the history of SQL statements run
against Materialize using the new
system catalog view. This allows performing database administration tasks like identifying
slow or long-running queries, monitoring query performance SLAs,
and analyzing access patterns.
-- Say you have an SLA of "queries return under 3 seconds", and want to look -- into any statements that don't comply. 🦥 SELECT sql, application_name, cluster_name, rows_returned, (finished_at - began_at) AS execution_time, finished_status FROM mz_internal.mz_activity_log WHERE (finished_at - began_at) > INTERVAL '3 seconds' ORDER BY execution_time DESC;
In the future, the activity log will also be exposed in the Materialize console, so it’s easier to access.