Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.encoreos.io/llms.txt

Use this file to discover all available pages before exploring further.

Query performance monitoring page at /settings/system-health/query-performance that gives platform administrators visibility into database query metrics, slow-query logs, index recommendations, and anomaly alerts.

​
Overview

The Query Performance page is a tabbed admin dashboard (Overview, Slow Queries, Recommendations, Patterns, Settings) gated behind platform.system_health.manage. The Overview tab shows aggregate metrics cards; Slow Queries lists logs from useQueryPerformanceLogs; Recommendations surfaces index suggestions from useIndexRecommendations; Patterns shows recurring query patterns from useQueryPatterns; Settings exposes QueryPerformanceSettingsForm and AnomalyAlertsSettingsSection. An AdvancedQueryProfile component is also available for deep inspection.

​
Who it’s for

Required permission: platform.system_health.manage

​
Before you start

  • You must hold the platform.system_health.manage permission.
  • Query performance logging must be enabled in the Settings tab before data will appear.

​
Steps

  1. Navigate to /settings/system-health/query-performance.
  2. Review the Overview tab for high-level metrics.
  3. Open the Slow Queries tab to inspect individual slow-query records.
  4. Check the Recommendations tab for index suggestions (Phase 5 — confirm availability).
  5. Review Patterns for recurring query patterns (Phase 6 — confirm availability).
  6. Adjust logging configuration and anomaly alert thresholds in the Settings tab.

​
Key concepts

Slow query threshold — A configurable duration above which a query is flagged as slow. SME: confirm default value. Index recommendations — Suggestions generated based on slow-query analysis. SME: confirm whether these are manual or auto-applied. Anomaly alerts — Alert configuration for unusual query behavior; managed via AnomalyAlertsSettingsSection.

Platform Foundation

Platform Foundation overview.

Governance & parity

This page documents shipped product behavior. It is not medical, legal, or billing advice. Verify against your organization’s policies and applicable regulations before using it for clinical, compliance, or billing decisions. Protected health information (PHI) shown in the product is governed by your tenant’s access controls and is never exposed in this documentation.
  • src/routes/platform.tsx
  • src/platform/query-performance/pages/QueryPerformancePage.tsx
  • src/platform/query-performance/hooks/useQueryPerformanceLogs.ts
  • src/platform/query-performance/useQueryPerformanceSettings.ts