> ## 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

> Platform admin tool for monitoring database query performance, identifying slow queries, and reviewing index recommendations.

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`.

## Related

<Columns cols={2}>
  <Card title="Platform Foundation" icon="layer-group" href="/pf/overview">
    Platform Foundation overview.
  </Card>

  <Card title="Governance & parity" icon="scale-balanced" href="/governance/index" />
</Columns>

<Note>
  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.
</Note>

<Accordion title="Documentation sources">
  * src/routes/platform.tsx
  * src/platform/query-performance/pages/QueryPerformancePage.tsx
  * src/platform/query-performance/hooks/useQueryPerformanceLogs.ts
  * src/platform/query-performance/useQueryPerformanceSettings.ts
</Accordion>