logo
ExamplesEditorPricingDocs
37.1kSign in

Error tracking and monitoring database schema

How an error monitoring service models its data: projects and releases, raw events with stack frames and breadcrumbs, grouping into issues by fingerprint, resolve and regression detection, alert rules and event sampling.

Error Tracking ER diagram

Error tracking and monitoring database schema n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 users idBIGINT emailVARCHAR full_nameVARCHAR is_activeBOOLEAN created_atTIMESTAMPTZ projects idBIGINT slugVARCHAR nameVARCHAR platformVARCHAR ingest_keyVARCHAR sample_rate_bpsINTEGER retention_daysSMALLINT created_atTIMESTAMPTZ releases idBIGINT project_idBIGINT versionVARCHAR ordinalBIGINT commit_shaVARCHAR released_atTIMESTAMPTZ created_atTIMESTAMPTZ issues idBIGINT project_idBIGINT fingerprintCHAR titleVARCHAR culpritVARCHAR levelVARCHAR statusVARCHAR ignored_untilTIMESTAMPTZ first_seen_atTIMESTAMPTZ last_seen_atTIMESTAMPTZ times_seenBIGINT users_affectedBIGINT first_release_idBIGINT resolved_in_relea…BIGINT resolved_atTIMESTAMPTZ regressed_atTIMESTAMPTZ events idBIGINT event_idUUID issue_idBIGINT project_idBIGINT release_idBIGINT environmentVARCHAR messageTEXT server_nameVARCHAR user_keyVARCHAR request_urlVARCHAR contextJSONB sample_weightINTEGER occurred_atTIMESTAMPTZ received_atTIMESTAMPTZ event_stack_frames event_idBIGINT ordinalSMALLINT filenameVARCHAR function_nameVARCHAR line_noINTEGER col_noINTEGER in_appBOOLEAN context_lineTEXT event_breadcrumbs event_idBIGINT ordinalSMALLINT categoryVARCHAR levelVARCHAR messageVARCHAR dataJSONB occurred_atTIMESTAMPTZ event_tags event_idBIGINT tag_keyVARCHAR tag_valueVARCHAR issue_assignees issue_idBIGINT user_idBIGINT assigned_by_idBIGINT assigned_atTIMESTAMPTZ alert_rules idBIGINT project_idBIGINT nameVARCHAR trigger_kindVARCHAR thresholdINTEGER window_minutesINTEGER min_levelVARCHAR environmentVARCHAR channelVARCHAR targetVARCHAR cooldown_minutesINTEGER is_enabledBOOLEAN created_atTIMESTAMPTZ alert_notifications idBIGINT rule_idBIGINT issue_idBIGINT dedupe_keyVARCHAR statusVARCHAR error_messageVARCHAR sent_atTIMESTAMPTZ created_atTIMESTAMPTZ issue_activity idBIGINT issue_idBIGINT actor_idBIGINT actionVARCHAR release_idBIGINT bodyTEXT created_atTIMESTAMPTZ

Related database schemas

PostgreSQL
Developer tools

API gateway & rate limiting database schema

How an API platform is modelled: consumers and applications, hashed API keys with scopes and rotation, upstream services and routes, rate limit policies, durable usage counters, rolled-up aggregates, sampled request logs, plans, quotas and overage billing.

PostgreSQL
Developer tools

CI/CD build pipeline database schema

How a build system models its data: versioned pipeline definitions, immutable runs triggered by a commit, stages with approval gates, a job DAG stored as edges, runners and capabilities, attempts and retries, artifacts, caches and streamed logs.

PostgreSQL
Developer tools

Feature flag service database schema

How a feature management platform stores its data: flags and variations, per-environment settings, ordered targeting rules, reusable segments, percentage rollouts with deterministic bucketing, scheduled changes and a full audit trail.

PostgreSQL
Developer tools

GitHub code hosting database schema

How a code hosting platform models its data: users and organisations, repositories, refs and commits, issues and pull requests sharing one number sequence, reviews with comments anchored to a file and line, labels, milestones and workflow runs.