Changelog

SQL activity log

Nov 9, 2023

Organization administrators can now access the history of SQL statements run against Materialize using the new mz_internal.mz_activity_log system catalog view. This allows performing database administration tasks like identifying slow or long-running queries, monitoring query performance SLAs, and analyzing access patterns.

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

‚Üź Back to the Changelog

Try Materialize Free