Skip to content
Legaciti Dev Docs

Sentry + GlitchTip Slow DB Query Plan

Migrated from root technical docs.

Sentry + GlitchTip Slow DB Query Plan

Section titled “Sentry + GlitchTip Slow DB Query Plan”

Status: Active Last updated: 2026-04-24 Owner: Platform + App teams

This folder contains the remaining implementation tickets for slow database query observability using existing Sentry-compatible GlitchTip instrumentation.

Goals

Section titled “Goals”
  • Enable performance tracing safely in Cloudflare/server runtimes.
  • Record DB query spans with useful metadata and redaction-safe query identifiers.
  • Detect slow-query events with a consistent threshold policy.
  • Build GlitchTip views and alerts that are actionable.
  • Add tests and rollout controls so overhead/cost stays predictable.

Out of Scope

Section titled “Out of Scope”
  • Full SQL optimization pass across all endpoints.
  • Automatic index recommendations.
  • Browser performance tracing (unless explicitly enabled later).

Remaining Tickets

Section titled “Remaining Tickets”
  1. TKT-005: GlitchTip dashboards, alerts, runbook
  2. TKT-006: Tests, staged rollout, ratchet

Global Task Board

Section titled “Global Task Board”
  • Complete TKT-005
  • Complete TKT-006

Global Acceptance Criteria

Section titled “Global Acceptance Criteria”
  • Tracing sample rate is configurable by environment and defaults to safe values.
  • DB spans include operation, shard, duration, and redacted query fingerprint.
  • Slow-query threshold tagging works consistently across instrumented services.
  • GlitchTip has at least one saved slow-query view and one active alert (manual GlitchTip config).
  • Unit/integration tests cover key helper logic and critical instrumentation paths.
  • Rollout and rollback steps are documented and tested in production (runbook published; production validation pending).
Docs Architecture Runbooks Dashboard

Start Here

Legaciti Dev Docs Documentation Index Documentation Placement Guide New Contributors

Architecture

Repo Map Code Placement Guide Package Categories Dependency Rules Dashboard App Structure Worker Structure Known Architecture Gaps 07 — Feature Source of Truth 08 — Feature Module Internals 09 — TanStack Query Patterns 10 — Domain Packages 11) Cloudflare Runtime Boundary Generated Artifacts Policy 13 — Naming Conventions 14 — Barrel Files and Public Boundaries Architecture Checks in CI 16 — Contributing With The Architecture 17 — Feature Package Audit

Runbooks

GlitchTip Monitoring Setup Integrations API Rollout Runbook Slow DB Query Runbook Workspace Modules Rollout Runbook

Operational References

Worker Deploy Order Workspace API Key Management Publication & ORCID Resync Single-ORCID Resync Resync Unverified Works

Migrated Internal Docs

ADR E1: Localized Search Strategy ADR — Installation-Centric Integrations Model Authentication Operations CLI Deploy Workers Integrations Ownership, Migration, and Rollback Locale Key Checks Locale-Search Rollout Runbook Operations Runbook Partner Write API Performance And Localization Roadmap (2 to 100 Languages) Performance And Localization Implementation Backlog

Root Docs Archive

Fallow Prompt Documentation Placement Guide Documentation Index