{
  "ok": true,
  "services": {
    "https": {
      "up": true,
      "latency_ms": 0,
      "uptime_pct": "100.00",
      "uptime_15m": "100.00",
      "uptime_1h": "100.00",
      "uptime_24h": "99.94",
      "samples_15m": 90,
      "samples_1h": 360,
      "samples_24h": 1786
    },
    "imap": {
      "up": true,
      "latency_ms": 0,
      "uptime_pct": "100.00",
      "uptime_15m": "100.00",
      "uptime_1h": "100.00",
      "uptime_24h": "99.94",
      "samples_15m": 90,
      "samples_1h": 360,
      "samples_24h": 1786
    },
    "mcp": {
      "up": true,
      "latency_ms": 0,
      "uptime_pct": "100.00",
      "uptime_15m": "100.00",
      "uptime_1h": "100.00",
      "uptime_24h": "99.94",
      "samples_15m": 90,
      "samples_1h": 360,
      "samples_24h": 1786
    },
    "nntp": {
      "up": true,
      "latency_ms": 0,
      "uptime_pct": "100.00",
      "uptime_15m": "100.00",
      "uptime_1h": "100.00",
      "uptime_24h": "99.94",
      "samples_15m": 90,
      "samples_1h": 360,
      "samples_24h": 1786
    },
    "pop3": {
      "up": true,
      "latency_ms": 0,
      "uptime_pct": "100.00",
      "uptime_15m": "100.00",
      "uptime_1h": "100.00",
      "uptime_24h": "99.94",
      "samples_15m": 90,
      "samples_1h": 360,
      "samples_24h": 1786
    }
  },
  "blended_uptime_pct": "100.00",
  "ingestion": {
    "inboxes": [
      {
        "name": "pgsql-fr-generale",
        "kind": "inbox",
        "last_update": "2026-05-22T18:44:56Z",
        "items": 4
      },
      {
        "name": "pgsql-admin",
        "kind": "inbox",
        "last_update": "2026-05-22T18:30:37Z",
        "items": 829
      },
      {
        "name": "pgsql-bugs",
        "kind": "inbox",
        "last_update": "2026-05-22T18:30:16Z",
        "items": 10971
      },
      {
        "name": "pgsql-general",
        "kind": "inbox",
        "last_update": "2026-05-22T18:30:08Z",
        "items": 15031
      },
      {
        "name": "pgsql-hackers",
        "kind": "inbox",
        "last_update": "2026-05-22T18:29:56Z",
        "items": 150231
      },
      {
        "name": "pgeu-general",
        "kind": "inbox",
        "last_update": "2026-05-22T18:16:09Z",
        "items": 43
      },
      {
        "name": "pgsql-advocacy",
        "kind": "inbox",
        "last_update": "2026-05-22T18:15:26Z",
        "items": 30
      },
      {
        "name": "karlsruhe-de-pug",
        "kind": "inbox",
        "last_update": "2026-05-22T17:41:06Z",
        "items": 5
      },
      {
        "name": "pgpool-buildfarm",
        "kind": "inbox",
        "last_update": "2026-05-22T17:06:29Z",
        "items": 597
      },
      {
        "name": "pgsql-committers",
        "kind": "inbox",
        "last_update": "2026-05-22T16:06:38Z",
        "items": 3581
      },
      {
        "name": "pgsql-sql",
        "kind": "inbox",
        "last_update": "2026-05-22T16:05:27Z",
        "items": 19
      },
      {
        "name": "pgsql-jdbc-commits",
        "kind": "inbox",
        "last_update": "2026-05-22T15:34:51Z",
        "items": 52
      },
      {
        "name": "pgsql-jobs",
        "kind": "inbox",
        "last_update": "2026-05-22T15:31:55Z",
        "items": 3
      },
      {
        "name": "lapug",
        "kind": "inbox",
        "last_update": "2026-05-22T14:27:00Z",
        "items": 3
      },
      {
        "name": "pgsql-translators",
        "kind": "inbox",
        "last_update": "2026-05-22T13:17:46Z",
        "items": 4
      },
      {
        "name": "pgsql-tr-genel",
        "kind": "inbox",
        "last_update": "2026-05-22T13:14:59Z",
        "items": 12
      },
      {
        "name": "pgsql-es-ayuda",
        "kind": "inbox",
        "last_update": "2026-05-22T13:14:28Z",
        "items": 14
      },
      {
        "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-es-fomento",
        "kind": "inbox",
        "last_update": "2026-05-22T13:14:18Z",
        "items": 1
      },
      {
        "name": "pgsql-it-generale",
        "kind": "inbox",
        "last_update": "2026-05-22T13:14:18Z",
        "items": 1
      },
      {
        "name": "pgsql-iw-general",
        "kind": "inbox",
        "last_update": "2026-05-22T13:14:18Z",
        "items": 1
      },
      {
        "name": "pgsql-pt-geral",
        "kind": "inbox",
        "last_update": "2026-05-22T13:14:18Z",
        "items": 1
      },
      {
        "name": "pgsql-ru-general",
        "kind": "inbox",
        "last_update": "2026-05-22T13:14:17Z",
        "items": 1
      },
      {
        "name": "pgsql-in-general",
        "kind": "inbox",
        "last_update": "2026-05-22T13:13:49Z",
        "items": 8
      },
      {
        "name": "pgsql-interfaces",
        "kind": "inbox",
        "last_update": "2026-05-22T13:13:37Z",
        "items": 5
      },
      {
        "name": "pgsql-jdbc",
        "kind": "inbox",
        "last_update": "2026-05-22T13:13:29Z",
        "items": 3
      },
      {
        "name": "pgsql-perffarm",
        "kind": "inbox",
        "last_update": "2026-05-22T13:13:24Z",
        "items": 2
      },
      {
        "name": "pgsql-gui-dev",
        "kind": "inbox",
        "last_update": "2026-05-22T13:13:21Z",
        "items": 1
      },
      {
        "name": "pgsql-women",
        "kind": "inbox",
        "last_update": "2026-05-22T13:13:21Z",
        "items": 1
      },
      {
        "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": "pdxpug",
        "kind": "inbox",
        "last_update": "2026-05-22T13:12:36Z",
        "items": 1
      },
      {
        "name": "psycopg",
        "kind": "inbox",
        "last_update": "2026-05-22T13:12:36Z",
        "items": 1
      },
      {
        "name": "arpug",
        "kind": "inbox",
        "last_update": "2026-05-22T13:12:25Z",
        "items": 10
      },
      {
        "name": "buildfarm-members",
        "kind": "inbox",
        "last_update": "2026-05-22T13:12:15Z",
        "items": 7
      },
      {
        "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-pkg-yum",
        "kind": "inbox",
        "last_update": "2026-05-22T12:49:34Z",
        "items": 70
      },
      {
        "name": "pgsql-performance",
        "kind": "inbox",
        "last_update": "2026-05-22T12:28:16Z",
        "items": 1509
      },
      {
        "name": "pgsql-novice",
        "kind": "inbox",
        "last_update": "2026-05-22T12:04:19Z",
        "items": 118
      },
      {
        "name": "pgsql-odbc",
        "kind": "inbox",
        "last_update": "2026-05-22T12:01:20Z",
        "items": 75
      },
      {
        "name": "pgsql-de-allgemein",
        "kind": "inbox",
        "last_update": "2026-05-22T11:40:20Z",
        "items": 8
      },
      {
        "name": "pgsql-pkg-debian",
        "kind": "inbox",
        "last_update": "2026-05-22T11:08:22Z",
        "items": 380
      },
      {
        "name": "pgpool-committers",
        "kind": "inbox",
        "last_update": "2026-05-22T10:20:07Z",
        "items": 380
      },
      {
        "name": "pgsql-docs",
        "kind": "inbox",
        "last_update": "2026-05-22T03:36:57Z",
        "items": 2503
      },
      {
        "name": "pgsql-announce",
        "kind": "inbox",
        "last_update": "2026-05-22T03:16:03Z",
        "items": 600
      },
      {
        "name": "pgadmin-support",
        "kind": "inbox",
        "last_update": "2026-05-22T03:02:44Z",
        "items": 337
      },
      {
        "name": "pgadmin-hackers",
        "kind": "inbox",
        "last_update": "2026-05-22T02:45:54Z",
        "items": 199
      },
      {
        "name": "pgsql-www",
        "kind": "inbox",
        "last_update": "2026-05-22T02:32:47Z",
        "items": 1619
      },
      {
        "name": "pgpool-general",
        "kind": "inbox",
        "last_update": "2026-05-21T19:30:30Z",
        "items": 135
      },
      {
        "name": "pgpool-hackers",
        "kind": "inbox",
        "last_update": "2026-05-21T14:15:21Z",
        "items": 203
      }
    ],
    "repositories": [
      {
        "name": "postgres-github",
        "kind": "repo",
        "last_update": "2026-05-22T18:33:22Z",
        "next_sync": "2026-05-22T19:46:11Z",
        "latest_commit": "06a5c3cdef024630aef0992bb7b471459aa2b70f"
      },
      {
        "name": "pgbouncer",
        "kind": "repo",
        "last_update": "2026-05-22T18:02:40Z",
        "next_sync": "2026-05-22T19:33:02Z",
        "items": 840,
        "latest_commit": "3c5cc87f47aafe3a13bb669ac61ddf38d3de7c17",
        "symbols": 1475
      },
      {
        "name": "pgdog",
        "kind": "repo",
        "last_update": "2026-05-22T18:02:36Z",
        "next_sync": "2026-05-22T22:19:45Z",
        "items": 902,
        "latest_commit": "8c64508af34635e0170c752a9aee68147ca65e1e",
        "symbols": 8836
      },
      {
        "name": "aws-advanced-jdbc-wrapper",
        "kind": "repo",
        "last_update": "2026-05-22T18:02:33Z",
        "next_sync": "2026-05-22T19:05:40Z",
        "items": 1366,
        "latest_commit": "dee59a1e245e653b5dfed6b59e72b42c2729f1ad",
        "symbols": 6679
      },
      {
        "name": "supabase-postgres",
        "kind": "repo",
        "last_update": "2026-05-22T18:02:30Z",
        "next_sync": "2026-05-22T23:09:51Z",
        "items": 1997,
        "latest_commit": "19ad20fd80fb1e914b9a3b70ce99ea45e253694f",
        "symbols": 705
      },
      {
        "name": "psqlodbc",
        "kind": "repo",
        "last_update": "2026-05-22T18:02:23Z",
        "next_sync": "2026-05-24T11:23:55Z",
        "items": 2157,
        "latest_commit": "aa6194377038c862b1b8d91fc6664fcfe2ee2034",
        "symbols": 2940
      },
      {
        "name": "postgresql-jdbc",
        "kind": "repo",
        "last_update": "2026-05-22T18:02:21Z",
        "next_sync": "2026-05-22T21:57:09Z",
        "items": 4118,
        "latest_commit": "1276a3decb6e05c8e836498a44b88658a4fbf46a",
        "symbols": 7176
      },
      {
        "name": "pgpool2",
        "kind": "repo",
        "last_update": "2026-05-22T18:02:19Z",
        "next_sync": "2026-05-23T05:33:54Z",
        "items": 4548,
        "latest_commit": "9644d8b429f996ded517d3bcaf98cb68fb65b8b3",
        "symbols": 7205
      },
      {
        "name": "postgrespro",
        "kind": "repo",
        "last_update": "2026-05-22T18:02:17Z",
        "next_sync": "2026-05-22T19:26:08Z",
        "items": 49333,
        "latest_commit": "a3fe99215b71721bfe6e9e8068ead63944b14e2f",
        "symbols": 49634
      },
      {
        "name": "postgres",
        "kind": "repo",
        "last_update": "2026-05-22T18:02:00Z",
        "next_sync": "2026-05-22T19:02:00Z",
        "items": 64334,
        "latest_commit": "06a5c3cdef024630aef0992bb7b471459aa2b70f",
        "symbols": 65596
      },
      {
        "name": "postgresql-cfbot",
        "kind": "repo",
        "last_update": "2026-05-22T14:37:49Z",
        "next_sync": "2026-05-22T19:38:30Z",
        "latest_commit": "b1c2d76a2fcef812af0be3343082414d401909c8"
      }
    ],
    "sources": [
      {
        "name": "pg-wiki",
        "kind": "wiki",
        "last_update": "2026-05-22T18:03:23Z",
        "next_sync": "2026-05-22T19:03:23Z"
      },
      {
        "name": "pg-docs",
        "kind": "docs",
        "last_update": "2026-05-22T00:47:37Z",
        "next_sync": "2026-05-23T00:47:37Z"
      }
    ],
    "last_email": "2026-05-22T18:44:56Z",
    "last_git": "2026-05-22T18:38:22Z",
    "last_docs": "2026-05-22T00:47:37Z",
    "last_wiki": "2026-05-22T18:03:23Z",
    "next_scheduled": "2026-05-22T19:02:00Z"
  },
  "slow_queries": [
    {
      "query": "SELECT COUNT(*) FROM ag_messages m LEFT JOIN ag_message_bodies b ON b.num = m.num WHERE m.inbox_id = $1 AND (m.subject %~~ tre_pattern($2, $3) OR m.from_addr %~~ tre_pattern($2, $3) OR b.body %~~ tre_",
      "calls": 4,
      "mean_ms": 13026.616337250001,
      "max_ms": 51833.939915,
      "rows": 4
    },
    {
      "query": "WITH cand AS ( (SELECT m.num FROM ag_messages m WHERE m.inbox_id = $1 AND m.subject ILIKE $2 ORDER BY m.ds DESC LIMIT $5) UNION (SELECT m.num FROM ag_messages m WHERE m.inbox_id = $1 AND m.from_addr I",
      "calls": 127,
      "mean_ms": 5631.289800440947,
      "max_ms": 32633.95514,
      "rows": 4039
    },
    {
      "query": "WITH latest_versions AS ( SELECT DISTINCT ON (r.path_id) r.path_id, r.commit_id, r.version_id, r.content_hash, r.mode, r.is_symlink, r.symlink_target, r.is_binary FROM ag_git_file_refs r JOIN ag_git_p",
      "calls": 8,
      "mean_ms": 5210.399240375001,
      "max_ms": 27568.695357,
      "rows": 61404
    },
    {
      "query": "WITH inbox_rows AS ( SELECT i.name AS name, $1::text AS kind, i.description AS description, COALESCE((SELECT COUNT(*) FROM ag_messages m WHERE m.inbox_id = i.id), $2) AS item_count, (SELECT to_timesta",
      "calls": 9,
      "mean_ms": 3816.895526,
      "max_ms": 4403.598138,
      "rows": 612
    },
    {
      "query": "SELECT DISTINCT ON (p.id) p.id, p.title, r.content, r.author, r.timestamp, ts_rank(to_tsvector($3, r.content), plainto_tsquery($4, $1)) as rank FROM ag_wiki_pages p JOIN ag_wiki_revisions r ON r.page_",
      "calls": 13,
      "mean_ms": 3661.247941307692,
      "max_ms": 27260.579664,
      "rows": 68
    },
    {
      "query": "SELECT s.id, s.repo_id, s.path_id, s.commit_id, s.content_hash, s.name, s.qualified_name, s.kind, s.language, s.start_line, s.end_line, COALESCE(s.signature,$1), COALESCE(s.doc_comment,$2), $3, s.pare",
      "calls": 4,
      "mean_ms": 3582.08781525,
      "max_ms": 6979.487716000001,
      "rows": 20
    },
    {
      "query": "SELECT id, seq, parent_id, tree_hash, message, author_name, author_email, authored_at, committer_name, committer_email, committed_at FROM ag_git_commits WHERE repo_id = $1 AND message %~~ tre_pattern(",
      "calls": 12,
      "mean_ms": 2647.954751083333,
      "max_ms": 20408.724321,
      "rows": 0
    },
    {
      "query": "SELECT id, seq, parent_id, tree_hash, message, author_name, author_email, authored_at, committer_name, committer_email, committed_at FROM ag_git_commits WHERE repo_id = $1 AND message %~~ tre_pattern(",
      "calls": 9,
      "mean_ms": 2000.8096998888886,
      "max_ms": 9710.352466,
      "rows": 10
    },
    {
      "query": "SELECT s.id, s.repo_id, s.path_id, s.commit_id, s.content_hash, s.name, s.qualified_name, s.kind, s.language, s.start_line, s.end_line, COALESCE(s.signature,$4), COALESCE(s.doc_comment,$5), COALESCE(s",
      "calls": 20,
      "mean_ms": 1705.6655672000002,
      "max_ms": 5208.403187,
      "rows": 154
    },
    {
      "query": "SELECT m.num, m.inbox_id, m.tid, COALESCE(m.sid, $6), COALESCE(m.ts, $7), COALESCE(m.ds, $8), m.mid, COALESCE(m.blob_oid, $9), COALESCE(m.subject, $10), COALESCE(m.from_addr, $11), COALESCE(m.to_addr,",
      "calls": 6,
      "mean_ms": 1505.2410855,
      "max_ms": 3715.3367249999997,
      "rows": 14
    }
  ]
}