Observability & Event Logging

Built-in event log capturing trigger firings, function calls, query executions, and auth events. In-memory ring buffer with configurable retention (10K events / 24 hours).

Event Types

Query Events

SHOW EVENTS
SHOW EVENTS LIMIT 20
SHOW EVENTS WHERE type = 'TriggerError'
SHOW EVENTS WHERE name = 'my_trigger'

Query Analytics

-- Most-called queries with latency percentiles
SHOW QUERY STATS LIMIT 10

Returns: query, count, avg_ms, p95_ms, p99_ms, min_ms, max_ms.

Dependency Analysis

-- Map all trigger/function/sync dependencies
SHOW DEPENDENCIES

-- Dependencies for a specific trigger
SHOW DEPENDENCIES FOR TRIGGER create_profile

Detects potential infinite loops and sync-trigger overlaps.

Alert Rules

CREATE ALERT my_alert WHEN TriggerError > 10 IN 5m THEN LOG
SHOW ALERTS
DROP ALERT my_alert

Built-in Alerts