{
  "id": "workflow:query-performance-review",
  "_kind": "Workflow",
  "_file": "workflows/workflows/workflows-database-architecture.yaml",
  "_cluster": "workflows",
  "attributes": {
    "displayName": "Query Performance Review",
    "workflowKind": "operational",
    "triggerType": "scheduled",
    "typicalCadence": "weekly",
    "complexity": "single-team",
    "description": "Identifies slow and resource-intensive database queries, analyzes execution\nplans, recommends index changes, and validates improvements. Excludes\nschema redesign.\n"
  },
  "outgoingEdges": [
    {
      "from": "workflow:query-performance-review",
      "to": "role:database-administrator",
      "kind": "involves_role",
      "attributes": {}
    },
    {
      "from": "workflow:query-performance-review",
      "to": "role:performance-profiler",
      "kind": "involves_role",
      "attributes": {}
    },
    {
      "from": "workflow:query-performance-review",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:query-performance-review",
      "to": "skill-area:observability-pipeline",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:query-performance-review",
      "to": "domain:databases",
      "kind": "applies_to_domain",
      "attributes": {}
    },
    {
      "from": "workflow:query-performance-review",
      "to": "domain:observability",
      "kind": "applies_to_domain",
      "attributes": {}
    },
    {
      "from": "workflow:query-performance-review",
      "to": "responsibility:slo-definition",
      "kind": "triggers_responsibility",
      "attributes": {}
    },
    {
      "from": "workflow:query-performance-review",
      "to": "org-unit:database-team",
      "kind": "performed_by_org_unit",
      "attributes": {}
    },
    {
      "from": "workflow:query-performance-review",
      "to": "role:database-administrator",
      "kind": "involves_role",
      "attributes": {}
    },
    {
      "from": "workflow:query-performance-review",
      "to": "role:performance-profiler",
      "kind": "involves_role",
      "attributes": {}
    },
    {
      "from": "workflow:query-performance-review",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:query-performance-review",
      "to": "skill-area:observability-pipeline",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:query-performance-review",
      "to": "domain:databases",
      "kind": "applies_to_domain",
      "attributes": {}
    },
    {
      "from": "workflow:query-performance-review",
      "to": "domain:observability",
      "kind": "applies_to_domain",
      "attributes": {}
    },
    {
      "from": "workflow:query-performance-review",
      "to": "responsibility:slo-definition",
      "kind": "triggers_responsibility",
      "attributes": {}
    },
    {
      "from": "workflow:query-performance-review",
      "to": "org-unit:database-team",
      "kind": "performed_by_org_unit",
      "attributes": {}
    }
  ],
  "incomingEdges": [
    {
      "from": "tool:turso",
      "to": "workflow:query-performance-review",
      "kind": "supports_work",
      "attributes": {
        "confidence": "medium",
        "evidence": "Query and replica behavior can be reviewed as part of performance tuning."
      }
    },
    {
      "from": "tool:neon",
      "to": "workflow:query-performance-review",
      "kind": "supports_work",
      "attributes": {
        "confidence": "medium",
        "evidence": "Postgres query behavior supports performance review."
      }
    },
    {
      "from": "tool:redis",
      "to": "workflow:query-performance-review",
      "kind": "supports_work",
      "attributes": {
        "confidence": "medium",
        "evidence": "Cache hit rates and slowlog data inform query and latency review."
      }
    },
    {
      "from": "tool-server:mcp-turso-candidate",
      "to": "workflow:query-performance-review",
      "kind": "supports_work",
      "attributes": {
        "confidence": "medium",
        "evidence": "Query metadata and replica state support performance review."
      }
    }
  ]
}