{
  "id": "skill-area:postgres-tuning",
  "_kind": "SkillArea",
  "_file": "domain/skill-areas/postgres-tuning.yaml",
  "_cluster": "domain",
  "attributes": {
    "displayName": "Postgres Performance Tuning",
    "description": "PostgreSQL performance work: reading EXPLAIN (ANALYZE, BUFFERS) plans,\nbtree / GIN / GiST / BRIN index selection, partial and expression\nindexes, table partitioning, vacuum/autovacuum, statistics targets,\nwork_mem and shared_buffers tuning, and query rewriting.\n",
    "domains": [
      "domain:data-engineering"
    ],
    "requiresStackParts": [
      "stack-part:relational-database"
    ],
    "expertiseLevels": [
      "intermediate",
      "expert",
      "authoritative"
    ]
  },
  "outgoingEdges": [
    {
      "from": "skill-area:postgres-tuning",
      "to": "domain:data-engineering",
      "kind": "applies_to",
      "attributes": {
        "confidence": "primary"
      }
    },
    {
      "from": "skill-area:postgres-tuning",
      "to": "domain:databases",
      "kind": "applies_to",
      "attributes": {
        "confidence": "secondary"
      }
    },
    {
      "from": "skill-area:postgres-tuning",
      "to": "specialization:postgres-tuning",
      "kind": "applies_to",
      "attributes": {
        "confidence": "primary"
      }
    },
    {
      "from": "skill-area:postgres-tuning",
      "to": "stack-part:relational-database",
      "kind": "uses_stack_part"
    }
  ],
  "incomingEdges": [
    {
      "from": "skill-area:database-migrations-zero-downtime",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area"
    },
    {
      "from": "skill-area:query-optimizer-internals",
      "to": "skill-area:postgres-tuning",
      "kind": "prerequisite_for_learning",
      "attributes": {
        "strength": "helpful"
      }
    },
    {
      "from": "skill-area:connection-pool-tuning",
      "to": "skill-area:postgres-tuning",
      "kind": "prerequisite_for_learning",
      "attributes": {
        "strength": "helpful"
      }
    },
    {
      "from": "skill-area:backend-data-persistence",
      "to": "skill-area:postgres-tuning",
      "kind": "prerequisite_for_learning",
      "attributes": {
        "strength": "recommended"
      }
    },
    {
      "from": "stack-part:relational-database",
      "to": "skill-area:postgres-tuning",
      "kind": "stack_part_used_by",
      "attributes": {}
    },
    {
      "from": "stack-profile:geospatial-analytics",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area"
    },
    {
      "from": "stack-profile:go-gin-postgres",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area"
    },
    {
      "from": "stack-profile:go-grpc-postgres",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area"
    },
    {
      "from": "skill:python-django-debug",
      "to": "skill-area:postgres-tuning",
      "kind": "addresses",
      "attributes": {}
    },
    {
      "from": "lib-skill:software-architecture--db-query-analyzer",
      "to": "skill-area:postgres-tuning",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "role:database-administrator",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_expertise",
      "attributes": {}
    },
    {
      "from": "role:data-analyst",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_expertise",
      "attributes": {}
    },
    {
      "from": "role:backend-engineer",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_expertise",
      "attributes": {}
    },
    {
      "from": "role:database-engineer",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_expertise",
      "attributes": {}
    },
    {
      "from": "workflow:backend-performance-profiling",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:database-migration-cutover",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:data-retention-review",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:ad-hoc-analysis-request-cycle",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:data-catalog-maintenance",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:dbt-model-review",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:data-governance-review",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:schema-migration",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:query-performance-review",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:backup-recovery-drill",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:database-index-optimization",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:database-failover-drill",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:database-connection-pool-tuning",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:data-governance-review",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:schema-migration",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:query-performance-review",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:backup-recovery-drill",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area",
      "attributes": {}
    }
  ]
}