{
  "ok": true,
  "services": {
    "https": {
      "up": true,
      "latency_ms": 0,
      "uptime_pct": "100.00",
      "uptime_15m": "100.00",
      "uptime_1h": "100.00",
      "uptime_24h": "99.98",
      "samples_15m": 90,
      "samples_1h": 360,
      "samples_24h": 4333
    },
    "imap": {
      "up": true,
      "latency_ms": 0,
      "uptime_pct": "100.00",
      "uptime_15m": "100.00",
      "uptime_1h": "100.00",
      "uptime_24h": "99.98",
      "samples_15m": 90,
      "samples_1h": 360,
      "samples_24h": 4333
    },
    "mcp": {
      "up": true,
      "latency_ms": 0,
      "uptime_pct": "100.00",
      "uptime_15m": "100.00",
      "uptime_1h": "100.00",
      "uptime_24h": "99.98",
      "samples_15m": 90,
      "samples_1h": 360,
      "samples_24h": 4333
    },
    "nntp": {
      "up": true,
      "latency_ms": 0,
      "uptime_pct": "100.00",
      "uptime_15m": "100.00",
      "uptime_1h": "100.00",
      "uptime_24h": "99.98",
      "samples_15m": 90,
      "samples_1h": 360,
      "samples_24h": 4333
    },
    "pop3": {
      "up": true,
      "latency_ms": 0,
      "uptime_pct": "100.00",
      "uptime_15m": "100.00",
      "uptime_1h": "100.00",
      "uptime_24h": "99.98",
      "samples_15m": 90,
      "samples_1h": 360,
      "samples_24h": 4333
    }
  },
  "blended_uptime_pct": "100.00",
  "ingestion": {
    "inboxes": [
      {
        "name": "pgpool-hackers",
        "kind": "inbox",
        "last_update": "2026-05-26T08:04:56Z",
        "items": 312
      },
      {
        "name": "pgsql-in-general",
        "kind": "inbox",
        "last_update": "2026-05-26T08:04:40Z",
        "items": 61
      },
      {
        "name": "pgsql-admin",
        "kind": "inbox",
        "last_update": "2026-05-26T08:04:07Z",
        "items": 2067
      },
      {
        "name": "pgsql-bugs",
        "kind": "inbox",
        "last_update": "2026-05-26T08:03:51Z",
        "items": 12468
      },
      {
        "name": "pgsql-general",
        "kind": "inbox",
        "last_update": "2026-05-26T08:03:35Z",
        "items": 20440
      },
      {
        "name": "pgsql-hackers",
        "kind": "inbox",
        "last_update": "2026-05-26T08:03:25Z",
        "items": 224273
      },
      {
        "name": "pgsql-committers",
        "kind": "inbox",
        "last_update": "2026-05-26T05:08:24Z",
        "items": 5816
      },
      {
        "name": "pgpool-committers",
        "kind": "inbox",
        "last_update": "2026-05-26T02:14:54Z",
        "items": 640
      },
      {
        "name": "pgsql-docs",
        "kind": "inbox",
        "last_update": "2026-05-26T02:14:11Z",
        "items": 3238
      },
      {
        "name": "pgsql-pkg-debian",
        "kind": "inbox",
        "last_update": "2026-05-25T22:04:54Z",
        "items": 726
      },
      {
        "name": "pgpool-buildfarm",
        "kind": "inbox",
        "last_update": "2026-05-25T22:04:39Z",
        "items": 789
      },
      {
        "name": "pgadmin-hackers",
        "kind": "inbox",
        "last_update": "2026-05-25T20:11:30Z",
        "items": 987
      },
      {
        "name": "psycopg",
        "kind": "inbox",
        "last_update": "2026-05-25T18:50:21Z",
        "items": 15
      },
      {
        "name": "pgsql-www",
        "kind": "inbox",
        "last_update": "2026-05-25T18:14:46Z",
        "items": 4081
      },
      {
        "name": "pgsql-translators",
        "kind": "inbox",
        "last_update": "2026-05-25T17:49:42Z",
        "items": 43
      },
      {
        "name": "pgsql-sql",
        "kind": "inbox",
        "last_update": "2026-05-25T17:39:31Z",
        "items": 165
      },
      {
        "name": "pgsql-pkg-yum",
        "kind": "inbox",
        "last_update": "2026-05-25T17:22:06Z",
        "items": 114
      },
      {
        "name": "pgsql-odbc",
        "kind": "inbox",
        "last_update": "2026-05-25T17:05:06Z",
        "items": 87
      },
      {
        "name": "pgsql-performance",
        "kind": "inbox",
        "last_update": "2026-05-25T17:02:07Z",
        "items": 3945
      },
      {
        "name": "pgsql-novice",
        "kind": "inbox",
        "last_update": "2026-05-25T16:24:21Z",
        "items": 208
      },
      {
        "name": "pgsql-jobs",
        "kind": "inbox",
        "last_update": "2026-05-25T15:56:38Z",
        "items": 27
      },
      {
        "name": "pgsql-jdbc-commits",
        "kind": "inbox",
        "last_update": "2026-05-25T15:51:15Z",
        "items": 240
      },
      {
        "name": "pgsql-gui-dev",
        "kind": "inbox",
        "last_update": "2026-05-25T13:28:32Z",
        "items": 2
      },
      {
        "name": "pgsql-fr-generale",
        "kind": "inbox",
        "last_update": "2026-05-25T13:14:40Z",
        "items": 30
      },
      {
        "name": "pgsql-es-ayuda",
        "kind": "inbox",
        "last_update": "2026-05-25T12:54:43Z",
        "items": 166
      },
      {
        "name": "pgsql-announce",
        "kind": "inbox",
        "last_update": "2026-05-25T11:49:59Z",
        "items": 675
      },
      {
        "name": "pgsql-advocacy",
        "kind": "inbox",
        "last_update": "2026-05-25T11:24:50Z",
        "items": 71
      },
      {
        "name": "pgsql-iw-general",
        "kind": "inbox",
        "last_update": "2026-05-25T05:16:47Z",
        "items": 3
      },
      {
        "name": "pgeu-general",
        "kind": "inbox",
        "last_update": "2026-05-24T12:45:49Z",
        "items": 48
      },
      {
        "name": "pgadmin-support",
        "kind": "inbox",
        "last_update": "2026-05-24T12:44:15Z",
        "items": 638
      },
      {
        "name": "pdxpug",
        "kind": "inbox",
        "last_update": "2026-05-24T11:55:14Z",
        "items": 7
      },
      {
        "name": "buildfarm-members",
        "kind": "inbox",
        "last_update": "2026-05-24T11:23:31Z",
        "items": 13
      },
      {
        "name": "pgsql-women",
        "kind": "inbox",
        "last_update": "2026-05-24T10:01:10Z",
        "items": 3
      },
      {
        "name": "pgsql-pt-geral",
        "kind": "inbox",
        "last_update": "2026-05-24T09:29:59Z",
        "items": 6
      },
      {
        "name": "pgsql-ru-general",
        "kind": "inbox",
        "last_update": "2026-05-24T00:00:36Z",
        "items": 9
      },
      {
        "name": "pgsql-it-generale",
        "kind": "inbox",
        "last_update": "2026-05-23T22:24:06Z",
        "items": 4
      },
      {
        "name": "pgsql-interfaces",
        "kind": "inbox",
        "last_update": "2026-05-23T22:07:41Z",
        "items": 7
      },
      {
        "name": "pgsql-es-fomento",
        "kind": "inbox",
        "last_update": "2026-05-23T20:15:27Z",
        "items": 2
      },
      {
        "name": "pgsql-perffarm",
        "kind": "inbox",
        "last_update": "2026-05-23T00:09:18Z",
        "items": 3
      },
      {
        "name": "karlsruhe-de-pug",
        "kind": "inbox",
        "last_update": "2026-05-22T17:41:06Z",
        "items": 5
      },
      {
        "name": "lapug",
        "kind": "inbox",
        "last_update": "2026-05-22T14:27:00Z",
        "items": 3
      },
      {
        "name": "pgsql-tr-genel",
        "kind": "inbox",
        "last_update": "2026-05-22T13:14:59Z",
        "items": 12
      },
      {
        "name": "pgsql-es-trabajos",
        "kind": "inbox",
        "last_update": "2026-05-22T13:14:21Z",
        "items": 2
      },
      {
        "name": "pgsql-zh-general",
        "kind": "inbox",
        "last_update": "2026-05-22T13:14:21Z",
        "items": 2
      },
      {
        "name": "pljava-dev",
        "kind": "inbox",
        "last_update": "2026-05-22T13:14:20Z",
        "items": 2
      },
      {
        "name": "pgsql-jdbc",
        "kind": "inbox",
        "last_update": "2026-05-22T13:13:29Z",
        "items": 3
      },
      {
        "name": "seapug",
        "kind": "inbox",
        "last_update": "2026-05-22T13:12:49Z",
        "items": 10
      },
      {
        "name": "pgus-general",
        "kind": "inbox",
        "last_update": "2026-05-22T13:12:37Z",
        "items": 1
      },
      {
        "name": "arpug",
        "kind": "inbox",
        "last_update": "2026-05-22T13:12:25Z",
        "items": 10
      },
      {
        "name": "ecpug",
        "kind": "inbox",
        "last_update": "2026-05-22T13:11:47Z",
        "items": 1
      },
      {
        "name": "austinpug",
        "kind": "inbox",
        "last_update": "2026-05-22T13:11:46Z",
        "items": 1
      },
      {
        "name": "pgsql-de-allgemein",
        "kind": "inbox",
        "last_update": "2026-05-22T11:40:20Z",
        "items": 8
      },
      {
        "name": "pgpool-general",
        "kind": "inbox",
        "last_update": "2026-05-21T19:30:30Z",
        "items": 135
      }
    ],
    "repositories": [
      {
        "name": "postgresql-cfbot",
        "kind": "repo",
        "last_update": "2026-05-26T08:58:44Z",
        "next_sync": "2026-05-26T13:59:25Z",
        "latest_commit": "b1c2d76a2fcef812af0be3343082414d401909c8"
      },
      {
        "name": "postgres-github",
        "kind": "repo",
        "last_update": "2026-05-26T08:46:40Z",
        "next_sync": "2026-05-26T10:35:59Z",
        "latest_commit": "6aa26be288fa811270dfc1e39c015c23a97688b4"
      },
      {
        "name": "pgbouncer",
        "kind": "repo",
        "last_update": "2026-05-26T08:00:38Z",
        "next_sync": "2026-05-26T09:31:00Z",
        "items": 840,
        "latest_commit": "3c5cc87f47aafe3a13bb669ac61ddf38d3de7c17",
        "symbols": 1475
      },
      {
        "name": "pgdog",
        "kind": "repo",
        "last_update": "2026-05-26T08:00:38Z",
        "next_sync": "2026-05-26T12:17:47Z",
        "items": 902,
        "latest_commit": "8c64508af34635e0170c752a9aee68147ca65e1e",
        "symbols": 8836
      },
      {
        "name": "aws-advanced-jdbc-wrapper",
        "kind": "repo",
        "last_update": "2026-05-26T08:00:37Z",
        "next_sync": "2026-05-26T09:03:44Z",
        "items": 1366,
        "latest_commit": "dee59a1e245e653b5dfed6b59e72b42c2729f1ad",
        "symbols": 6679
      },
      {
        "name": "supabase-postgres",
        "kind": "repo",
        "last_update": "2026-05-26T08:00:36Z",
        "next_sync": "2026-05-26T13:07:57Z",
        "items": 1999,
        "latest_commit": "438c36be6614a851e43a24399f92f92fb9a88613",
        "symbols": 728
      },
      {
        "name": "psqlodbc",
        "kind": "repo",
        "last_update": "2026-05-26T08:00:34Z",
        "next_sync": "2026-05-28T01:22:06Z",
        "items": 2157,
        "latest_commit": "aa6194377038c862b1b8d91fc6664fcfe2ee2034",
        "symbols": 2940
      },
      {
        "name": "postgresql-jdbc",
        "kind": "repo",
        "last_update": "2026-05-26T08:00:33Z",
        "next_sync": "2026-05-26T11:55:21Z",
        "items": 4118,
        "latest_commit": "1276a3decb6e05c8e836498a44b88658a4fbf46a",
        "symbols": 7176
      },
      {
        "name": "pgpool2",
        "kind": "repo",
        "last_update": "2026-05-26T08:00:32Z",
        "next_sync": "2026-05-26T19:32:07Z",
        "items": 4549,
        "latest_commit": "627ab8cd89c453b04dd83ad96a916182a25023af",
        "symbols": 7207
      },
      {
        "name": "postgrespro",
        "kind": "repo",
        "last_update": "2026-05-26T08:00:31Z",
        "next_sync": "2026-05-26T09:24:22Z",
        "items": 49333,
        "latest_commit": "a3fe99215b71721bfe6e9e8068ead63944b14e2f",
        "symbols": 49634
      },
      {
        "name": "postgres",
        "kind": "repo",
        "last_update": "2026-05-26T08:00:29Z",
        "next_sync": "2026-05-26T09:00:29Z",
        "items": 64351,
        "latest_commit": "6aa26be288fa811270dfc1e39c015c23a97688b4",
        "symbols": 68113
      }
    ],
    "sources": [
      {
        "name": "pg-wiki",
        "kind": "wiki",
        "last_update": "2026-05-26T08:24:41Z",
        "next_sync": "2026-05-26T09:24:41Z"
      },
      {
        "name": "pg-docs",
        "kind": "docs",
        "last_update": "2026-05-26T03:47:27Z",
        "next_sync": "2026-05-27T03:47:27Z"
      }
    ],
    "last_email": "2026-05-26T08:04:56Z",
    "last_git": "2026-05-26T08:58:44Z",
    "last_docs": "2026-05-26T03:47:27Z",
    "last_wiki": "2026-05-26T08:24:41Z",
    "next_scheduled": "2026-05-26T09:00:29Z"
  },
  "slow_queries": [
    {
      "query": "WITH s AS ( SELECT cr.commit_sha, cr.repo_id, cr.role, cr.release, cr.committed_at FROM community.contributions_raw cr JOIN ag_repositories r ON r.id = cr.repo_id JOIN community.person_aliases pa ON p",
      "calls": 4,
      "mean_ms": 1864.4804015,
      "max_ms": 4192.304329,
      "rows": 40
    },
    {
      "query": "SELECT m.num, m.inbox_id, m.tid, COALESCE(m.sid, $4), COALESCE(m.ts, $5), COALESCE(m.ds, $6), m.mid, COALESCE(m.blob_oid, $7), COALESCE(m.subject, $8), COALESCE(m.from_addr, $9), COALESCE(m.to_addr, $",
      "calls": 10,
      "mean_ms": 1579.2429200000001,
      "max_ms": 4410.207102,
      "rows": 115
    },
    {
      "query": "SELECT COUNT(*) FROM ag_messages m WHERE m.inbox_id = $1 AND ((COALESCE(m.subject, $3) || $4 || COALESCE(m.from_addr, $5) || $6 || COALESCE(m.mid, $7)) \u003c@\u003e to_bm25query($2, $8)) \u003c $9",
      "calls": 13,
      "mean_ms": 399.9277568461539,
      "max_ms": 1176.758268,
      "rows": 13
    },
    {
      "query": "SELECT p.person_id, encode(substring(sha256(convert_to(lower(p.canonical_email),$3))::bytea, $4, $5), $6) AS hash, COALESCE(p.canonical_name,$7) AS name, COALESCE(p.canonical_email,$8) AS email, count",
      "calls": 15,
      "mean_ms": 263.1727855333333,
      "max_ms": 1185.596022,
      "rows": 216
    },
    {
      "query": "SELECT r.name, r.last_fetched_at, r.next_fetch_at, r.commit_count, COALESCE(r.last_imported_commit_id, $1) AS last_commit, (SELECT COUNT(*) FROM ag_ci_symbols WHERE repo_id = r.id) AS symbol_count FRO",
      "calls": 21,
      "mean_ms": 186.11653023809524,
      "max_ms": 2798.052043,
      "rows": 588
    },
    {
      "query": "SELECT COALESCE(MAX(num), $2) FROM ag_messages WHERE inbox_id = $1",
      "calls": 432,
      "mean_ms": 139.4827594861111,
      "max_ms": 20589.382057000003,
      "rows": 432
    },
    {
      "query": "SELECT COUNT(*) FROM ag_ci_embeddings",
      "calls": 8,
      "mean_ms": 107.28515300000001,
      "max_ms": 380.80203,
      "rows": 8
    },
    {
      "query": "SELECT i.name, to_timestamp(MAX(m.ts)) AS latest, COUNT(m.num) AS msgs FROM ag_inboxes i LEFT JOIN ag_messages m ON m.inbox_id = i.id GROUP BY i.name ORDER BY latest DESC NULLS LAST, i.name",
      "calls": 21,
      "mean_ms": 101.74562904761902,
      "max_ms": 722.5340110000001,
      "rows": 1134
    },
    {
      "query": "SELECT i.name, to_timestamp(MAX(m.ts)) AS latest, COUNT(m.num) AS msgs FROM ag_inboxes i LEFT JOIN ag_messages m ON m.inbox_id = i.id WHERE i.name \u003c\u003e $1 GROUP BY i.name ORDER BY latest DESC NULLS LAST",
      "calls": 2070,
      "mean_ms": 82.92330704347827,
      "max_ms": 839.667013,
      "rows": 109710
    },
    {
      "query": "SELECT m.num, m.inbox_id, m.tid, COALESCE(m.sid, $5), COALESCE(m.ts, $6), COALESCE(m.ds, $7), m.mid, COALESCE(m.blob_oid, $8), COALESCE(m.subject, $9), COALESCE(m.from_addr, $10), COALESCE(m.to_addr, ",
      "calls": 13,
      "mean_ms": 77.06966984615386,
      "max_ms": 307.847082,
      "rows": 164
    }
  ]
}