{
  "schema_version": "awooop_conversation_event_hot_path_index_apply_receipt_v1",
  "generated_at": "2026-07-01T07:58:00+08:00",
  "scope": "188:k3s-postgres-recovery:awoooi_prod:awooop_conversation_event",
  "source_commit": "c29771a2d1b592e94fe3a1051b3a9d3842ec20f4",
  "migration": "apps/api/migrations/awooop_conversation_event_hot_path_indexes_2026-07-01.sql",
  "rollback": "apps/api/migrations/awooop_conversation_event_hot_path_indexes_2026-07-01_down.sql",
  "operation": {
    "type": "controlled_db_migration",
    "statements": "CREATE INDEX CONCURRENTLY IF NOT EXISTS only",
    "lock_timeout": "5s",
    "statement_timeout": "0",
    "runtime_write_performed": true,
    "destructive_db_operation_performed": false,
    "drop_truncate_restore_performed": false,
    "service_restart_performed": false,
    "secret_value_read": false,
    "runner_token_read": false
  },
  "pre_apply": {
    "table_size": "93 MB",
    "indexes_present": [
      "awooop_conversation_event_pkey",
      "idx_conv_event_run",
      "idx_conv_event_subject",
      "uix_conv_event_dedup"
    ],
    "k3s_postgres_recovery_cpu_cores": 7.9277,
    "host_188_load5": 10.57
  },
  "post_apply": {
    "indexes_valid_ready": [
      "idx_awooop_conv_event_project_provider_event_recent",
      "idx_awooop_conv_event_project_provider_lower_recent",
      "idx_awooop_conv_event_project_provider_recent",
      "idx_awooop_conv_event_project_run_id_text_recent",
      "idx_awooop_conv_event_source_refs_alert_ids_gin",
      "idx_awooop_conv_event_source_refs_approval_ids_gin",
      "idx_awooop_conv_event_source_refs_event_ids_gin",
      "idx_awooop_conv_event_source_refs_fingerprints_gin",
      "idx_awooop_conv_event_source_refs_incident_ids_gin",
      "idx_awooop_conv_event_source_refs_sentry_issue_ids_gin",
      "idx_awooop_conv_event_source_refs_signoz_alerts_gin",
      "idx_conv_event_recent"
    ],
    "pg_stat_activity": {
      "idle": 35,
      "unknown": 5,
      "active": 1
    },
    "k3s_postgres_recovery_cpu_cores_after_first_readback": 1.0552,
    "k3s_postgres_recovery_top3_after_20_seconds": false,
    "host_188_load5_after_20_seconds": 10.04
  },
  "remaining_blockers": [
    "host_110_gitea_cpu_pressure",
    "harbor_110_repair_no_matching_runner:awoooi-host",
    "cd_4182_failure_or_waiting_backlog"
  ],
  "safe_next_step": "continue_110_gitea_queue_control_path_recovery_without_generic_runner_or_host_reboot"
}
