{
  "id": "workflow:database-connection-pool-tuning",
  "_kind": "Workflow",
  "_file": "workflows/workflows/workflows-performance-deep.yaml",
  "_cluster": "workflows",
  "attributes": {
    "displayName": "Database Connection Pool Tuning",
    "workflowKind": "development",
    "triggerType": "on-demand",
    "typicalCadence": "per-regression",
    "complexity": "single-team",
    "description": "Analyzes and optimizes database connection pool configurations -- profiling\nconnection checkout latency, identifying pool exhaustion events, measuring\nconnection idle timeout effectiveness, evaluating pool size against\nconcurrent query load, analyzing connection leak patterns via stack trace\nattribution, testing pool warm-up strategies, validating\nPgBouncer/ProxySQL intermediate pooler settings, and recommending pool\nparameter changes with load-test validation. Excludes query optimization\nand schema migration.\n"
  },
  "outgoingEdges": [
    {
      "from": "workflow:database-connection-pool-tuning",
      "to": "role:database-administrator",
      "kind": "involves_role",
      "attributes": {}
    },
    {
      "from": "workflow:database-connection-pool-tuning",
      "to": "role:performance-profiler",
      "kind": "involves_role",
      "attributes": {}
    },
    {
      "from": "workflow:database-connection-pool-tuning",
      "to": "role:backend-engineer",
      "kind": "involves_role",
      "attributes": {}
    },
    {
      "from": "workflow:database-connection-pool-tuning",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:database-connection-pool-tuning",
      "to": "skill-area:observability-pipeline",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:database-connection-pool-tuning",
      "to": "domain:databases",
      "kind": "applies_to_domain",
      "attributes": {}
    },
    {
      "from": "workflow:database-connection-pool-tuning",
      "to": "domain:software-engineering",
      "kind": "applies_to_domain",
      "attributes": {}
    },
    {
      "from": "workflow:database-connection-pool-tuning",
      "to": "responsibility:performance-budget-tracking",
      "kind": "triggers_responsibility",
      "attributes": {}
    },
    {
      "from": "workflow:database-connection-pool-tuning",
      "to": "responsibility:slo-definition",
      "kind": "triggers_responsibility",
      "attributes": {}
    },
    {
      "from": "workflow:database-connection-pool-tuning",
      "to": "org-unit:database-team",
      "kind": "performed_by_org_unit",
      "attributes": {}
    },
    {
      "from": "workflow:database-connection-pool-tuning",
      "to": "org-unit:engineering",
      "kind": "performed_by_org_unit",
      "attributes": {}
    }
  ],
  "incomingEdges": []
}