apiVersion: apps/v1
kind: StatefulSet
metadata:
  labels:
    app: diagnosis-query-performance
  name: diagnosis-query-performance
  namespace: observability
spec:
  replicas: 1
  selector:
    matchLabels:
      app: diagnosis-query-performance
  template:
    metadata:
      labels:
        app: diagnosis-query-performance
    spec:
      containers:
      - args:
        - -vendor
        - aws
        - -region
        - ap-southeast-1
        - -duckDBSwitchAllEnabled=true
        - -duckDBSwitchTime
        - "1748736001"
        command:
        - /diagnosis-query
        env:
        - name: TOPSQL_OLD_CLUSTERS
          value: "1372813089209061633/1379661944646416073,1372813089209061633/1379661944646416074,1372813089209061633/1379661944646416075,1372813089209061633/1379661944646416046"
        - name: POD_MEMORY_LIMITS_MB
          valueFrom:
            resourceFieldRef:
              containerName: diagnosis-query-performance
              resource: limits.memory
              divisor: 1Mi
        - name: DUCKDB_MEMORY_PERCENTAGE
          value: "40"
        image: 557537366020.dkr.ecr.us-west-2.amazonaws.com/diagnosis-query:v86
        imagePullPolicy: IfNotPresent
        name: diagnosis-query-performance
        ports:
        - containerPort: 8081
          protocol: TCP
        resources:
          limits:
            cpu: "2"
            memory: 8Gi
          requests:
            cpu: "2"
            memory: 7Gi
        volumeMounts:
        - mountPath: /cache
          name: diagnosis-query-performance-cache
      serviceAccount: regional-server-controller-manager
      serviceAccountName: regional-server-controller-manager
  volumeClaimTemplates:
  - apiVersion: v1
    kind: PersistentVolumeClaim
    metadata:
      labels:
        app: diagnosis-query-performance
      name: diagnosis-query-performance-cache
    spec:
      accessModes:
      - ReadWriteOnce
      resources:
        requests:
          storage: 200Gi
      storageClassName: gp2
      volumeMode: Filesystem

---
apiVersion: v1
kind: Service
metadata:
  labels:
    app: diagnosis-query-performance
  name: diagnosis-query-performance
  namespace: observability
spec:
  selector:
    app: diagnosis-query-performance
  ports:
    - protocol: TCP
      port: 8081
      targetPort: 8081

---
apiVersion: monitoring.coreos.com/v1
kind: ServiceMonitor
metadata:
  labels:
    release: self-monitoring
  name: diagnosis-query-performance-monitor
  namespace: self-monitoring
spec:
  endpoints:
    - path: /metrics
      targetPort: 8081
  namespaceSelector:
    matchNames:
      - observability
  selector:
    matchLabels:
      app: diagnosis-query-performance