The only tool you need to know what is happening and how to fix it.
Go alertingexception-trackerissue-trackinglogsmetricsmonitoringobservability-platformopen-telemetryotelsession-replaytelemetrytraces
CREATE TABLE IF NOT EXISTS endpoints (
id TEXT NOT NULL,
project_id TEXT NOT NULL,
endpoint TEXT NOT NULL DEFAULT '',
duration INTEGER NOT NULL DEFAULT 0,
recorded_at DATETIME NOT NULL,
status_code INTEGER NOT NULL DEFAULT 0,
body_size INTEGER NOT NULL DEFAULT 0,
client_ip TEXT NOT NULL DEFAULT '',
attributes TEXT NOT NULL DEFAULT '{}',
app_version TEXT NOT NULL DEFAULT '',
server_name TEXT NOT NULL DEFAULT ''
);
CREATE INDEX IF NOT EXISTS idx_endpoints_project_recorded ON endpoints(project_id, recorded_at);
CREATE INDEX IF NOT EXISTS idx_endpoints_project_endpoint ON endpoints(project_id, endpoint);
CREATE TABLE IF NOT EXISTS tasks (
id TEXT NOT NULL,
project_id TEXT NOT NULL,
task_name TEXT NOT NULL DEFAULT '',
duration INTEGER NOT NULL DEFAULT 0,
recorded_at DATETIME NOT NULL,
client_ip TEXT NOT NULL DEFAULT '',
attributes TEXT NOT NULL DEFAULT '{}',
app_version TEXT NOT NULL DEFAULT '',
server_name TEXT NOT NULL DEFAULT ''
);
CREATE INDEX IF NOT EXISTS idx_tasks_project_recorded ON tasks(project_id, recorded_at);
CREATE TABLE IF NOT EXISTS exception_stack_traces (
id TEXT NOT NULL,
project_id TEXT NOT NULL,
trace_id TEXT,
trace_type TEXT NOT NULL DEFAULT 'endpoint',
exception_hash TEXT NOT NULL DEFAULT '',
stack_trace TEXT NOT NULL DEFAULT '',
recorded_at DATETIME NOT NULL,
attributes TEXT NOT NULL DEFAULT '{}',
app_version TEXT NOT NULL DEFAULT '',
server_name TEXT NOT NULL DEFAULT '',
is_message INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX IF NOT EXISTS idx_exceptions_project_recorded ON exception_stack_traces(project_id, recorded_at);
CREATE INDEX IF NOT EXISTS idx_exceptions_project_hash ON exception_stack_traces(project_id, exception_hash);
CREATE TABLE IF NOT EXISTS spans (
id TEXT NOT NULL,
trace_id TEXT NOT NULL,
project_id TEXT NOT NULL,
name TEXT NOT NULL DEFAULT '',
start_time DATETIME NOT NULL,
duration INTEGER NOT NULL DEFAULT 0,
recorded_at DATETIME NOT NULL
);
CREATE INDEX IF NOT EXISTS idx_spans_project_trace ON spans(project_id, trace_id);
CREATE TABLE IF NOT EXISTS metric_points (
project_id TEXT NOT NULL,
name TEXT NOT NULL DEFAULT '',
value REAL NOT NULL DEFAULT 0,
tags TEXT NOT NULL DEFAULT '{}',
recorded_at DATETIME NOT NULL
);
CREATE INDEX IF NOT EXISTS idx_metric_points_project_name ON metric_points(project_id, name, recorded_at);
CREATE TABLE IF NOT EXISTS session_recordings (
id TEXT NOT NULL,
project_id TEXT NOT NULL,
exception_id TEXT NOT NULL,
file_path TEXT NOT NULL DEFAULT '',
recorded_at DATETIME NOT NULL
);
CREATE INDEX IF NOT EXISTS idx_session_recordings_project_exception ON session_recordings(project_id, exception_id);
CREATE TABLE IF NOT EXISTS archived_exceptions (
project_id TEXT NOT NULL,
exception_hash TEXT NOT NULL,
archived_at DATETIME NOT NULL DEFAULT (datetime('now')),
UNIQUE(project_id, exception_hash)
);
CREATE TABLE IF NOT EXISTS slow_endpoints (
project_id TEXT NOT NULL,
endpoint TEXT NOT NULL,
offset_ms INTEGER NOT NULL DEFAULT 0,
reason TEXT NOT NULL DEFAULT '',
UNIQUE(project_id, endpoint)
);
CREATE TABLE IF NOT EXISTS fired_notifications (
project_id TEXT NOT NULL,
rule_id INTEGER NOT NULL DEFAULT 0,
rule_type TEXT NOT NULL DEFAULT '',
rule_name TEXT NOT NULL DEFAULT '',
channel_type TEXT NOT NULL DEFAULT '',
channel_name TEXT NOT NULL DEFAULT '',
severity TEXT NOT NULL DEFAULT '',
subject TEXT NOT NULL DEFAULT '',
body TEXT NOT NULL DEFAULT '',
status TEXT NOT NULL DEFAULT '',
error_message TEXT NOT NULL DEFAULT '',
endpoint TEXT NOT NULL DEFAULT '',
fired_at DATETIME NOT NULL
);