{
  "ok": true,
  "services": {
    "https": {
      "up": true,
      "latency_ms": 0,
      "uptime_pct": "100.00",
      "uptime_15m": "100.00",
      "uptime_1h": "100.00",
      "uptime_24h": "100.00",
      "samples_15m": 90,
      "samples_1h": 360,
      "samples_24h": 8640
    },
    "imap": {
      "up": true,
      "latency_ms": 0,
      "uptime_pct": "100.00",
      "uptime_15m": "100.00",
      "uptime_1h": "100.00",
      "uptime_24h": "100.00",
      "samples_15m": 90,
      "samples_1h": 360,
      "samples_24h": 8640
    },
    "mcp": {
      "up": true,
      "latency_ms": 0,
      "uptime_pct": "100.00",
      "uptime_15m": "100.00",
      "uptime_1h": "100.00",
      "uptime_24h": "100.00",
      "samples_15m": 90,
      "samples_1h": 360,
      "samples_24h": 8640
    },
    "nntp": {
      "up": true,
      "latency_ms": 0,
      "uptime_pct": "100.00",
      "uptime_15m": "100.00",
      "uptime_1h": "100.00",
      "uptime_24h": "100.00",
      "samples_15m": 90,
      "samples_1h": 360,
      "samples_24h": 8640
    },
    "pop3": {
      "up": true,
      "latency_ms": 0,
      "uptime_pct": "100.00",
      "uptime_15m": "100.00",
      "uptime_1h": "100.00",
      "uptime_24h": "100.00",
      "samples_15m": 90,
      "samples_1h": 360,
      "samples_24h": 8640
    }
  },
  "blended_uptime_pct": "100.00",
  "ingestion": {
    "inboxes": [
      {
        "name": "pgpool-hackers",
        "kind": "inbox",
        "last_update": "2026-06-07T05:05:46Z",
        "items": 646
      },
      {
        "name": "pgsql-bugs",
        "kind": "inbox",
        "last_update": "2026-06-07T05:05:13Z",
        "items": 18252
      },
      {
        "name": "pgsql-hackers",
        "kind": "inbox",
        "last_update": "2026-06-07T05:05:02Z",
        "items": 400756
      },
      {
        "name": "pgsql-pkg-yum",
        "kind": "inbox",
        "last_update": "2026-06-07T05:03:14Z",
        "items": 1111
      },
      {
        "name": "pgsql-pkg-debian",
        "kind": "inbox",
        "last_update": "2026-06-07T05:02:54Z",
        "items": 2431
      },
      {
        "name": "pgsql-novice",
        "kind": "inbox",
        "last_update": "2026-06-07T04:48:16Z",
        "items": 458
      },
      {
        "name": "pgsql-odbc",
        "kind": "inbox",
        "last_update": "2026-06-07T04:48:02Z",
        "items": 434
      },
      {
        "name": "pgsql-jobs",
        "kind": "inbox",
        "last_update": "2026-06-07T04:22:52Z",
        "items": 60
      },
      {
        "name": "pgsql-jdbc",
        "kind": "inbox",
        "last_update": "2026-06-07T04:21:03Z",
        "items": 25
      },
      {
        "name": "pgadmin-hackers",
        "kind": "inbox",
        "last_update": "2026-06-07T04:04:47Z",
        "items": 7707
      },
      {
        "name": "pgsql-it-generale",
        "kind": "inbox",
        "last_update": "2026-06-07T04:04:09Z",
        "items": 11
      },
      {
        "name": "pgpool-committers",
        "kind": "inbox",
        "last_update": "2026-06-07T04:04:08Z",
        "items": 695
      },
      {
        "name": "pgsql-in-general",
        "kind": "inbox",
        "last_update": "2026-06-07T03:36:29Z",
        "items": 62
      },
      {
        "name": "pgsql-fr-generale",
        "kind": "inbox",
        "last_update": "2026-06-07T03:11:20Z",
        "items": 177
      },
      {
        "name": "pgsql-es-ayuda",
        "kind": "inbox",
        "last_update": "2026-06-07T02:26:07Z",
        "items": 568
      },
      {
        "name": "pgsql-docs",
        "kind": "inbox",
        "last_update": "2026-06-07T02:05:05Z",
        "items": 7292
      },
      {
        "name": "pgsql-de-allgemein",
        "kind": "inbox",
        "last_update": "2026-06-07T01:25:46Z",
        "items": 25
      },
      {
        "name": "pgsql-committers",
        "kind": "inbox",
        "last_update": "2026-06-07T01:13:19Z",
        "items": 14876
      },
      {
        "name": "pgsql-announce",
        "kind": "inbox",
        "last_update": "2026-06-07T00:49:22Z",
        "items": 993
      },
      {
        "name": "pgsql-advocacy",
        "kind": "inbox",
        "last_update": "2026-06-07T00:35:33Z",
        "items": 297
      },
      {
        "name": "pgsql-admin",
        "kind": "inbox",
        "last_update": "2026-06-07T00:07:17Z",
        "items": 7167
      },
      {
        "name": "pgeu-general",
        "kind": "inbox",
        "last_update": "2026-06-06T22:35:39Z",
        "items": 113
      },
      {
        "name": "pgadmin-support",
        "kind": "inbox",
        "last_update": "2026-06-06T22:20:34Z",
        "items": 3824
      },
      {
        "name": "pdxpug",
        "kind": "inbox",
        "last_update": "2026-06-06T21:43:10Z",
        "items": 22
      },
      {
        "name": "karlsruhe-de-pug",
        "kind": "inbox",
        "last_update": "2026-06-06T21:27:52Z",
        "items": 33
      },
      {
        "name": "psycopg",
        "kind": "inbox",
        "last_update": "2026-06-06T20:42:27Z",
        "items": 67
      },
      {
        "name": "pgsql-www",
        "kind": "inbox",
        "last_update": "2026-06-06T20:06:02Z",
        "items": 10757
      },
      {
        "name": "pgsql-sql",
        "kind": "inbox",
        "last_update": "2026-06-06T19:32:56Z",
        "items": 447
      },
      {
        "name": "pgsql-ru-general",
        "kind": "inbox",
        "last_update": "2026-06-06T12:17:57Z",
        "items": 32
      },
      {
        "name": "pgpool-buildfarm",
        "kind": "inbox",
        "last_update": "2026-06-06T11:02:45Z",
        "items": 813
      },
      {
        "name": "buildfarm-members",
        "kind": "inbox",
        "last_update": "2026-06-06T07:11:30Z",
        "items": 87
      },
      {
        "name": "pgsql-es-fomento",
        "kind": "inbox",
        "last_update": "2026-06-06T03:22:15Z",
        "items": 9
      },
      {
        "name": "lapug",
        "kind": "inbox",
        "last_update": "2026-06-06T00:39:36Z",
        "items": 7
      },
      {
        "name": "pgsql-general",
        "kind": "inbox",
        "last_update": "2026-06-05T23:01:46Z",
        "items": 45821
      },
      {
        "name": "pgsql-translators",
        "kind": "inbox",
        "last_update": "2026-06-05T22:46:50Z",
        "items": 255
      },
      {
        "name": "pgsql-interfaces",
        "kind": "inbox",
        "last_update": "2026-06-05T21:11:17Z",
        "items": 37
      },
      {
        "name": "pgsql-gui-dev",
        "kind": "inbox",
        "last_update": "2026-06-05T05:39:05Z",
        "items": 7
      },
      {
        "name": "pgpool-general",
        "kind": "inbox",
        "last_update": "2026-06-05T02:02:46Z",
        "items": 138
      },
      {
        "name": "ecpug",
        "kind": "inbox",
        "last_update": "2026-06-05T01:53:04Z",
        "items": 2
      },
      {
        "name": "pgsql-iw-general",
        "kind": "inbox",
        "last_update": "2026-06-04T22:25:44Z",
        "items": 26
      },
      {
        "name": "pgsql-performance",
        "kind": "inbox",
        "last_update": "2026-06-04T20:57:58Z",
        "items": 10239
      },
      {
        "name": "pljava-dev",
        "kind": "inbox",
        "last_update": "2026-06-04T07:53:06Z",
        "items": 16
      },
      {
        "name": "pgsql-pt-geral",
        "kind": "inbox",
        "last_update": "2026-06-04T06:34:37Z",
        "items": 8
      },
      {
        "name": "pgsql-es-trabajos",
        "kind": "inbox",
        "last_update": "2026-06-04T04:28:13Z",
        "items": 7
      },
      {
        "name": "seapug",
        "kind": "inbox",
        "last_update": "2026-06-02T16:32:30Z",
        "items": 17
      },
      {
        "name": "austinpug",
        "kind": "inbox",
        "last_update": "2026-06-01T22:25:12Z",
        "items": 2
      },
      {
        "name": "pgjdbc",
        "kind": "inbox",
        "last_update": "2026-06-01T11:57:59Z",
        "items": 25282
      },
      {
        "name": "pgsql-jdbc-commits",
        "kind": "inbox",
        "last_update": "2026-06-01T10:20:46Z",
        "items": 348
      },
      {
        "name": "psqlodbc",
        "kind": "inbox",
        "last_update": "2026-06-01T08:39:10Z",
        "items": 729
      },
      {
        "name": "pgsql-women",
        "kind": "inbox",
        "last_update": "2026-05-24T10:01:10Z",
        "items": 3
      },
      {
        "name": "pgsql-perffarm",
        "kind": "inbox",
        "last_update": "2026-05-23T00:09:18Z",
        "items": 3
      },
      {
        "name": "pgsql-tr-genel",
        "kind": "inbox",
        "last_update": "2026-05-22T13:14:59Z",
        "items": 12
      },
      {
        "name": "pgsql-zh-general",
        "kind": "inbox",
        "last_update": "2026-05-22T13:14:21Z",
        "items": 2
      },
      {
        "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
      }
    ],
    "repositories": [
      {
        "name": "pgbouncer",
        "kind": "repo",
        "last_update": "2026-06-07T05:01:32Z",
        "next_sync": "2026-06-07T06:31:54Z",
        "items": 840,
        "latest_commit": "3c5cc87f47aafe3a13bb669ac61ddf38d3de7c17",
        "symbols": 1475
      },
      {
        "name": "pgdog",
        "kind": "repo",
        "last_update": "2026-06-07T05:01:30Z",
        "next_sync": "2026-06-07T09:18:39Z",
        "items": 902,
        "latest_commit": "8c64508af34635e0170c752a9aee68147ca65e1e",
        "symbols": 8836
      },
      {
        "name": "aws-advanced-jdbc-wrapper",
        "kind": "repo",
        "last_update": "2026-06-07T05:01:28Z",
        "next_sync": "2026-06-07T06:04:35Z",
        "items": 1366,
        "latest_commit": "dee59a1e245e653b5dfed6b59e72b42c2729f1ad",
        "symbols": 6679
      },
      {
        "name": "psqlodbc",
        "kind": "repo",
        "last_update": "2026-06-07T05:01:19Z",
        "next_sync": "2026-06-08T22:22:51Z",
        "items": 2160,
        "latest_commit": "53e01fdc2f2d7ae5c6cdc7cd7657123acfce502d",
        "symbols": 3376
      },
      {
        "name": "postgresql-jdbc",
        "kind": "repo",
        "last_update": "2026-06-07T05:01:17Z",
        "next_sync": "2026-06-07T08:56:05Z",
        "items": 4118,
        "latest_commit": "1276a3decb6e05c8e836498a44b88658a4fbf46a",
        "symbols": 7176
      },
      {
        "name": "pgpool2",
        "kind": "repo",
        "last_update": "2026-06-07T05:01:14Z",
        "next_sync": "2026-06-07T16:32:49Z",
        "items": 4555,
        "latest_commit": "7c918dc247613d16d590a9f30ecc747da6871796",
        "symbols": 8015
      },
      {
        "name": "postgres",
        "kind": "repo",
        "last_update": "2026-06-07T05:01:01Z",
        "next_sync": "2026-06-07T06:01:01Z",
        "items": 64461,
        "latest_commit": "89eafad297a9b01ad77cfc1ab93a433e0af894b0",
        "symbols": 74845
      },
      {
        "name": "postgresql-cfbot",
        "kind": "repo",
        "last_update": "2026-06-07T02:21:13Z",
        "next_sync": "2026-06-07T07:21:54Z",
        "latest_commit": "b1c2d76a2fcef812af0be3343082414d401909c8"
      }
    ],
    "sources": [
      {
        "name": "pg-wiki",
        "kind": "wiki",
        "last_update": "2026-06-07T05:25:10Z",
        "next_sync": "2026-06-07T06:25:10Z"
      },
      {
        "name": "pg-docs",
        "kind": "docs",
        "last_update": "2026-06-06T05:51:46Z",
        "next_sync": "2026-06-07T05:51:46Z"
      }
    ],
    "last_email": "2026-06-07T05:05:46Z",
    "last_git": "2026-06-07T05:01:38Z",
    "last_docs": "2026-06-06T05:51:46Z",
    "last_wiki": "2026-06-07T05:25:10Z",
    "next_scheduled": "2026-06-07T05:51:46Z"
  },
  "slow_queries": [
    {
      "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": 3,
      "mean_ms": 20432.978286999998,
      "max_ms": 36042.245811,
      "rows": 10
    },
    {
      "query": "SELECT num, mid, COALESCE(subject,$4), $5, COALESCE(from_addr,$6), to_timestamp(COALESCE(ts,$7)) FROM ag_messages WHERE (subject %~~ tre_pattern($1, $8) AND subject %~~ tre_pattern($2, $9)) OR (mid %~",
      "calls": 3,
      "mean_ms": 2946.7717293333335,
      "max_ms": 6728.481272999999,
      "rows": 13
    },
    {
      "query": "SELECT num, mid, COALESCE(subject,$5), $6, COALESCE(from_addr,$7), to_timestamp(COALESCE(ts,$8)) FROM ag_messages WHERE (subject %~~ tre_pattern($1, $9) AND subject %~~ tre_pattern($2, $10) AND subjec",
      "calls": 2,
      "mean_ms": 2287.3780825000003,
      "max_ms": 2792.1488640000002,
      "rows": 10
    },
    {
      "query": "SELECT MAX(committed_at) FROM ag_git_commits WHERE repo_id = $1",
      "calls": 56,
      "mean_ms": 862.6231083750002,
      "max_ms": 10569.182377000001,
      "rows": 56
    },
    {
      "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": 2,
      "mean_ms": 860.945895,
      "max_ms": 1643.597771,
      "rows": 0
    },
    {
      "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": 586,
      "mean_ms": 795.9480946501714,
      "max_ms": 23083.413823000003,
      "rows": 2357
    },
    {
      "query": "WITH s AS ( SELECT DISTINCT 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_aliase",
      "calls": 3,
      "mean_ms": 427.2236066666667,
      "max_ms": 1179.036687,
      "rows": 92
    },
    {
      "query": "SELECT DISTINCT r.name, cr.commit_sha, COALESCE(gc.tree_hash,$4), cr.role, COALESCE(ce.effective_release,$5), cr.committed_at FROM community.v_contributions_effective ce JOIN community.contributions_r",
      "calls": 8,
      "mean_ms": 384.27063549999997,
      "max_ms": 2391.675236,
      "rows": 29
    },
    {
      "query": "WITH bm AS ( SELECT b.num, (b.body \u003c@\u003e to_bm25query($2, $5)) AS bm25_score FROM ag_message_bodies b ORDER BY b.body \u003c@\u003e to_bm25query($2, 'idx_ag_bodies_pgts') ASC LIMIT $4 ) SELECT m.num, m.inbox_id, ",
      "calls": 25,
      "mean_ms": 357.09873760000005,
      "max_ms": 744.771137,
      "rows": 732
    },
    {
      "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 tree_hash = $2 LIMIT $3",
      "calls": 54,
      "mean_ms": 343.75595535185187,
      "max_ms": 3095.34184,
      "rows": 54
    }
  ]
}