{
  "id": "lib-process:performance-optimization--n-plus-one-query-detection",
  "_kind": "LibraryProcess",
  "_file": "generated-library/processes.yaml",
  "_cluster": "generated-library",
  "attributes": {
    "displayName": "specializations/performance-optimization/n-plus-one-query-detection",
    "description": "N+1 Query Detection and Resolution - Detect and fix N+1 query problems in applications including\nquery logging instrumentation, pattern identification, eager loading implementation, and batch query optimization.",
    "libraryPath": "library/specializations/performance-optimization/n-plus-one-query-detection.js",
    "specialization": "performance-optimization",
    "references": [
      "- SQLAlchemy: https://www.sqlalchemy.org/"
    ],
    "example": "const result = await orchestrate('specializations/performance-optimization/n-plus-one-query-detection', {\n  projectName: 'Blog Platform',\n  targetApplication: 'blog-api',\n  ormFramework: 'hibernate'\n});",
    "usesAgents": [
      "performance-engineer"
    ]
  },
  "outgoingEdges": [
    {
      "from": "lib-process:performance-optimization--n-plus-one-query-detection",
      "to": "skill-area:performance-monitoring-profiling",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:performance-optimization--n-plus-one-query-detection",
      "to": "skill-area:profiling-cpu",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "lib-process:performance-optimization--n-plus-one-query-detection",
      "to": "topic:observability-driven-development",
      "kind": "lib_covers_topic",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:performance-optimization--n-plus-one-query-detection",
      "to": "domain:software-engineering",
      "kind": "lib_applies_to_domain",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:performance-optimization--n-plus-one-query-detection",
      "to": "role:backend-engineer",
      "kind": "lib_involves_role",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:performance-optimization--n-plus-one-query-detection",
      "to": "role:sre",
      "kind": "lib_involves_role",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "lib-process:performance-optimization--n-plus-one-query-detection",
      "to": "workflow:performance-profiling-cycle",
      "kind": "lib_implements_workflow",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:performance-optimization--n-plus-one-query-detection",
      "to": "specialization:performance-optimization",
      "kind": "lib_belongs_to_specialization",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:performance-optimization--n-plus-one-query-detection",
      "to": "lib-agent:software-architecture--performance-engineer",
      "kind": "uses_agent",
      "attributes": {
        "weight": 0.8
      }
    }
  ],
  "incomingEdges": []
}