{
  "ok": true,
  "services": {
    "https": {
      "up": true,
      "latency_ms": 0,
      "uptime_pct": "97.37",
      "uptime_15m": "97.37",
      "uptime_1h": "97.37",
      "uptime_24h": "97.37",
      "samples_15m": 38,
      "samples_1h": 38,
      "samples_24h": 38
    },
    "imap": {
      "up": true,
      "latency_ms": 0,
      "uptime_pct": "97.37",
      "uptime_15m": "97.37",
      "uptime_1h": "97.37",
      "uptime_24h": "97.37",
      "samples_15m": 38,
      "samples_1h": 38,
      "samples_24h": 38
    },
    "mcp": {
      "up": true,
      "latency_ms": 0,
      "uptime_pct": "97.37",
      "uptime_15m": "97.37",
      "uptime_1h": "97.37",
      "uptime_24h": "97.37",
      "samples_15m": 38,
      "samples_1h": 38,
      "samples_24h": 38
    },
    "nntp": {
      "up": true,
      "latency_ms": 0,
      "uptime_pct": "97.37",
      "uptime_15m": "97.37",
      "uptime_1h": "97.37",
      "uptime_24h": "97.37",
      "samples_15m": 38,
      "samples_1h": 38,
      "samples_24h": 38
    },
    "pop3": {
      "up": true,
      "latency_ms": 0,
      "uptime_pct": "97.37",
      "uptime_15m": "97.37",
      "uptime_1h": "97.37",
      "uptime_24h": "97.37",
      "samples_15m": 38,
      "samples_1h": 38,
      "samples_24h": 38
    }
  },
  "blended_uptime_pct": "97.37",
  "ingestion": {
    "inboxes": [
      {
        "name": "pgsql-hackers",
        "kind": "inbox",
        "last_update": "2026-07-10T13:31:41Z",
        "items": 1380546
      },
      {
        "name": "pgsql-www",
        "kind": "inbox",
        "last_update": "2026-07-10T12:18:01Z",
        "items": 12227
      },
      {
        "name": "pgsql-docs",
        "kind": "inbox",
        "last_update": "2026-07-10T10:54:39Z",
        "items": 10559
      },
      {
        "name": "pgsql-bugs",
        "kind": "inbox",
        "last_update": "2026-07-10T07:53:55Z",
        "items": 30068
      },
      {
        "name": "pgpool-hackers",
        "kind": "inbox",
        "last_update": "2026-07-10T01:01:47Z",
        "items": 1554
      },
      {
        "name": "pgsql-committers",
        "kind": "inbox",
        "last_update": "2026-07-10T01:01:12Z",
        "items": 36259
      },
      {
        "name": "pgsql-advocacy",
        "kind": "inbox",
        "last_update": "2026-07-08T22:52:36Z",
        "items": 632
      },
      {
        "name": "pgsql-pkg-debian",
        "kind": "inbox",
        "last_update": "2026-07-08T22:52:30Z",
        "items": 3159
      },
      {
        "name": "pgpool-committers",
        "kind": "inbox",
        "last_update": "2026-07-08T22:52:25Z",
        "items": 739
      },
      {
        "name": "pgsql-announce",
        "kind": "inbox",
        "last_update": "2026-07-08T22:51:47Z",
        "items": 1338
      },
      {
        "name": "pgsql-admin",
        "kind": "inbox",
        "last_update": "2026-07-07T21:41:42Z",
        "items": 13827
      },
      {
        "name": "pgadmin-support",
        "kind": "inbox",
        "last_update": "2026-07-07T21:41:32Z",
        "items": 5670
      },
      {
        "name": "pgeu-general",
        "kind": "inbox",
        "last_update": "2026-07-07T21:41:28Z",
        "items": 392
      },
      {
        "name": "pgsql-de-allgemein",
        "kind": "inbox",
        "last_update": "2026-07-07T21:41:28Z",
        "items": 217
      },
      {
        "name": "pgadmin-hackers",
        "kind": "inbox",
        "last_update": "2026-07-07T21:24:59Z",
        "items": 13249
      },
      {
        "name": "austinpug",
        "kind": "inbox",
        "last_update": "2026-07-07T21:24:46Z",
        "items": 326
      },
      {
        "name": "buildfarm-members",
        "kind": "inbox",
        "last_update": "2026-07-07T21:24:46Z",
        "items": 326
      },
      {
        "name": "lapug",
        "kind": "inbox",
        "last_update": "2026-07-07T21:24:46Z",
        "items": 237
      },
      {
        "name": "pgsql-in-general",
        "kind": "inbox",
        "last_update": "2026-07-07T21:24:46Z",
        "items": 210
      },
      {
        "name": "arpug",
        "kind": "inbox",
        "last_update": "2026-07-07T21:24:45Z",
        "items": 199
      },
      {
        "name": "ecpug",
        "kind": "inbox",
        "last_update": "2026-07-07T21:24:45Z",
        "items": 252
      },
      {
        "name": "pdxpug",
        "kind": "inbox",
        "last_update": "2026-07-07T21:24:45Z",
        "items": 124
      },
      {
        "name": "pgsql-translators",
        "kind": "inbox",
        "last_update": "2026-07-07T21:09:46Z",
        "items": 400
      },
      {
        "name": "psycopg",
        "kind": "inbox",
        "last_update": "2026-07-07T21:09:45Z",
        "items": 559
      },
      {
        "name": "pgsql-sql",
        "kind": "inbox",
        "last_update": "2026-07-07T21:09:44Z",
        "items": 1508
      },
      {
        "name": "pgsql-tr-genel",
        "kind": "inbox",
        "last_update": "2026-07-07T21:09:42Z",
        "items": 283
      },
      {
        "name": "pljava-dev",
        "kind": "inbox",
        "last_update": "2026-07-07T21:09:42Z",
        "items": 880
      },
      {
        "name": "seapug",
        "kind": "inbox",
        "last_update": "2026-07-07T21:09:42Z",
        "items": 295
      },
      {
        "name": "pgsql-general",
        "kind": "inbox",
        "last_update": "2026-07-07T21:04:45Z",
        "items": 56233
      },
      {
        "name": "pgsql-performance",
        "kind": "inbox",
        "last_update": "2026-07-07T20:52:52Z",
        "items": 12343
      },
      {
        "name": "pgsql-novice",
        "kind": "inbox",
        "last_update": "2026-07-07T20:52:50Z",
        "items": 1187
      },
      {
        "name": "pgsql-ru-general",
        "kind": "inbox",
        "last_update": "2026-07-07T20:52:49Z",
        "items": 357
      },
      {
        "name": "pgsql-jobs",
        "kind": "inbox",
        "last_update": "2026-07-07T20:52:48Z",
        "items": 250
      },
      {
        "name": "pgsql-odbc",
        "kind": "inbox",
        "last_update": "2026-07-07T20:52:48Z",
        "items": 737
      },
      {
        "name": "pgsql-es-ayuda",
        "kind": "inbox",
        "last_update": "2026-07-07T20:37:30Z",
        "items": 1677
      },
      {
        "name": "pgsql-jdbc",
        "kind": "inbox",
        "last_update": "2026-07-07T20:37:19Z",
        "items": 1440
      },
      {
        "name": "pgsql-es-fomento",
        "kind": "inbox",
        "last_update": "2026-07-07T20:37:18Z",
        "items": 171
      },
      {
        "name": "pgsql-fr-generale",
        "kind": "inbox",
        "last_update": "2026-07-07T20:37:18Z",
        "items": 324
      },
      {
        "name": "pgsql-interfaces",
        "kind": "inbox",
        "last_update": "2026-07-07T20:37:17Z",
        "items": 195
      },
      {
        "name": "pgsql-it-generale",
        "kind": "inbox",
        "last_update": "2026-07-07T20:37:17Z",
        "items": 181
      },
      {
        "name": "pgus-general",
        "kind": "inbox",
        "last_update": "2026-07-07T15:01:52Z",
        "items": 328
      },
      {
        "name": "pgsql-pkg-yum",
        "kind": "inbox",
        "last_update": "2026-07-07T12:06:12Z",
        "items": 1825
      },
      {
        "name": "pgsql-pt-geral",
        "kind": "inbox",
        "last_update": "2026-07-06T17:45:10Z",
        "items": 247
      },
      {
        "name": "pgsql-women",
        "kind": "inbox",
        "last_update": "2026-07-06T15:34:28Z",
        "items": 193
      },
      {
        "name": "pgsql-zh-general",
        "kind": "inbox",
        "last_update": "2026-07-06T04:57:10Z",
        "items": 157
      },
      {
        "name": "pgsql-gui-dev",
        "kind": "inbox",
        "last_update": "2026-07-04T12:53:05Z",
        "items": 40
      },
      {
        "name": "pgsql-es-trabajos",
        "kind": "inbox",
        "last_update": "2026-07-04T08:54:23Z",
        "items": 25
      },
      {
        "name": "pgpool-buildfarm",
        "kind": "inbox",
        "last_update": "2026-06-29T18:10:07Z",
        "items": 864
      },
      {
        "name": "pgjdbc",
        "kind": "inbox",
        "last_update": "2026-06-19T06:40:11Z",
        "items": 25354
      },
      {
        "name": "psqlodbc",
        "kind": "inbox",
        "last_update": "2026-06-18T14:28:51Z",
        "items": 738
      },
      {
        "name": "karlsruhe-de-pug",
        "kind": "inbox",
        "last_update": "2026-06-08T02:57:58Z",
        "items": 37
      },
      {
        "name": "pgpool-general",
        "kind": "inbox",
        "last_update": "2026-06-05T02:02:46Z",
        "items": 138
      },
      {
        "name": "pgsql-iw-general",
        "kind": "inbox",
        "last_update": "2026-06-04T22:25:44Z",
        "items": 26
      },
      {
        "name": "pgsql-jdbc-commits",
        "kind": "inbox",
        "last_update": "2026-06-01T10:20:46Z",
        "items": 348
      },
      {
        "name": "pgsql-perffarm",
        "kind": "inbox",
        "last_update": "2026-05-23T00:09:18Z",
        "items": 3
      }
    ],
    "repositories": [
      {
        "name": "postgresql-cfbot",
        "kind": "repo",
        "last_update": "2026-07-10T13:11:52Z",
        "next_sync": "2026-07-10T18:12:33Z",
        "latest_commit": "b1c2d76a2fcef812af0be3343082414d401909c8"
      },
      {
        "name": "pgbouncer",
        "kind": "repo",
        "last_update": "2026-07-10T13:00:40Z",
        "next_sync": "2026-07-10T14:31:02Z",
        "items": 840,
        "latest_commit": "3c5cc87f47aafe3a13bb669ac61ddf38d3de7c17",
        "symbols": 1475
      },
      {
        "name": "pgdog",
        "kind": "repo",
        "last_update": "2026-07-10T13:00:38Z",
        "next_sync": "2026-07-10T17:17:47Z",
        "items": 902,
        "latest_commit": "8c64508af34635e0170c752a9aee68147ca65e1e",
        "symbols": 8836
      },
      {
        "name": "aws-advanced-jdbc-wrapper",
        "kind": "repo",
        "last_update": "2026-07-10T13:00:37Z",
        "next_sync": "2026-07-10T14:03:44Z",
        "items": 1366,
        "latest_commit": "dee59a1e245e653b5dfed6b59e72b42c2729f1ad",
        "symbols": 6679
      },
      {
        "name": "psqlodbc",
        "kind": "repo",
        "last_update": "2026-07-10T13:00:29Z",
        "next_sync": "2026-07-12T04:03:53Z",
        "items": 2162,
        "latest_commit": "95b35ac7cb2c9ea9df087fda08a695d89b8f8134",
        "symbols": 3668
      },
      {
        "name": "postgresql-jdbc",
        "kind": "repo",
        "last_update": "2026-07-10T13:00:28Z",
        "next_sync": "2026-07-10T16:55:16Z",
        "items": 4118,
        "latest_commit": "1276a3decb6e05c8e836498a44b88658a4fbf46a",
        "symbols": 7176
      },
      {
        "name": "pgpool2",
        "kind": "repo",
        "last_update": "2026-07-10T13:00:26Z",
        "next_sync": "2026-07-11T00:32:01Z",
        "items": 4564,
        "latest_commit": "912d7ce0b9d3a29a343a4b828e86fc05c0f47755",
        "symbols": 9859
      },
      {
        "name": "postgres",
        "kind": "repo",
        "last_update": "2026-07-10T13:00:18Z",
        "next_sync": "2026-07-10T14:00:18Z",
        "items": 64910,
        "latest_commit": "701f021b680ec33a799022d31b574fbcd618a40f",
        "symbols": 101276
      }
    ],
    "sources": [
      {
        "name": "pg-discord",
        "kind": "discord",
        "last_update": "2026-07-10T13:34:51Z",
        "next_sync": "2026-07-10T13:39:51Z"
      },
      {
        "name": "pg-wiki",
        "kind": "wiki",
        "last_update": "2026-07-10T12:46:48Z",
        "next_sync": "2026-07-10T13:46:48Z"
      },
      {
        "name": "pg-docs",
        "kind": "docs",
        "last_update": "2026-07-09T16:44:45Z",
        "next_sync": "2026-07-10T16:44:45Z"
      }
    ],
    "last_email": "2026-07-10T13:31:41Z",
    "last_git": "2026-07-10T13:11:52Z",
    "last_docs": "2026-07-09T16:44:45Z",
    "last_wiki": "2026-07-10T12:46:48Z",
    "next_scheduled": "2026-07-10T13:39:51Z"
  },
  "tools": [
    {
      "name": "search_discord_topics",
      "calls_24h": 15,
      "errors_24h": 0,
      "median_24h_ms": 59947,
      "p95_24h_ms": 74387,
      "samples_24h": 15
    },
    {
      "name": "search",
      "calls_24h": 6,
      "errors_24h": 0,
      "median_24h_ms": 2307,
      "p95_24h_ms": 14147,
      "samples_24h": 6
    },
    {
      "name": "get_thread",
      "calls_24h": 3,
      "errors_24h": 0,
      "median_24h_ms": 12,
      "p95_24h_ms": 236,
      "samples_24h": 3
    },
    {
      "name": "find_entries_for_author",
      "calls_24h": 2,
      "errors_24h": 0,
      "median_24h_ms": 272,
      "p95_24h_ms": 516,
      "samples_24h": 2
    },
    {
      "name": "get_message",
      "calls_24h": 2,
      "errors_24h": 0,
      "median_24h_ms": 107,
      "p95_24h_ms": 112,
      "samples_24h": 2
    },
    {
      "name": "get_contributor_history",
      "calls_24h": 1,
      "errors_24h": 0,
      "median_24h_ms": 4,
      "p95_24h_ms": 4,
      "samples_24h": 1
    },
    {
      "name": "list_discord_channels",
      "calls_24h": 1,
      "errors_24h": 0,
      "median_24h_ms": 106,
      "p95_24h_ms": 106,
      "samples_24h": 1
    }
  ],
  "slow_queries": [
    {
      "query": "SELECT ib.name, am.mid, COALESCE(am.subject,$4), am.from_addr, to_timestamp(am.ts) FROM ag_messages am JOIN ag_inboxes ib ON ib.id = am.inbox_id WHERE EXISTS ( SELECT $5 FROM regexp_split_to_table(coa",
      "calls": 4,
      "mean_ms": 13773.13886925,
      "max_ms": 16591.334076,
      "rows": 121
    },
    {
      "query": "WITH idents AS ( SELECT e, v AS raw_email FROM mentat.datoms_text_new WHERE a = (SELECT entid FROM mentat.idents WHERE ident=$2) ), names AS ( SELECT e, v AS raw_name FROM mentat.datoms_text_new WHERE",
      "calls": 6,
      "mean_ms": 3151.8041785,
      "max_ms": 4155.455268,
      "rows": 17
    },
    {
      "query": "SELECT c.tree_hash FROM ag_git_refs r JOIN ag_git_commits c ON c.repo_id = r.repo_id AND c.id = r.commit_id WHERE r.repo_id = $1 AND r.name = $2",
      "calls": 3,
      "mean_ms": 1022.4046269999999,
      "max_ms": 2921.962446,
      "rows": 3
    },
    {
      "query": "WITH subj AS MATERIALIZED ( SELECT m.num, m.ds FROM ag_messages m WHERE m.inbox_id = $1 AND lower(m.subject) %~~ tre_pattern($2, $6)), frm AS MATERIALIZED ( SELECT m.num, m.ds FROM ag_messages m WHERE",
      "calls": 2,
      "mean_ms": 483.1484435,
      "max_ms": 868.1203419999999,
      "rows": 20
    },
    {
      "query": "SELECT num, inbox_id, tid, COALESCE(sid, $3), COALESCE(ts, $4), COALESCE(ds, $5), mid, COALESCE(blob_oid, $6), COALESCE(subject, $7), COALESCE(from_addr, $8), COALESCE(to_addr, $9), COALESCE(cc_addr, ",
      "calls": 12,
      "mean_ms": 450.7655440833334,
      "max_ms": 5148.9665110000005,
      "rows": 300
    },
    {
      "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": 4026,
      "mean_ms": 436.5537820263285,
      "max_ms": 3977.9092029999997,
      "rows": 221430
    },
    {
      "query": "SELECT num, inbox_id, tid, COALESCE(sid, $4), COALESCE(ts, $5), COALESCE(ds, $6), mid, COALESCE(blob_oid, $7), COALESCE(subject, $8), COALESCE(from_addr, $9), COALESCE(to_addr, $10), COALESCE(cc_addr,",
      "calls": 188,
      "mean_ms": 350.2247771063829,
      "max_ms": 2997.179275,
      "rows": 3222
    },
    {
      "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": 9,
      "mean_ms": 273.1892288888889,
      "max_ms": 680.3192300000001,
      "rows": 500
    },
    {
      "query": "WITH cand AS ( (SELECT m.num FROM ag_messages m WHERE m.inbox_id = $1 AND lower(m.subject) %~~ tre_pattern($2, $4) ORDER BY m.ds DESC LIMIT $3) UNION (SELECT m.num FROM ag_messages m WHERE m.inbox_id ",
      "calls": 6,
      "mean_ms": 179.84245083333334,
      "max_ms": 369.316585,
      "rows": 368
    },
    {
      "query": "SELECT COUNT(DISTINCT datoms0.e)::TEXT FROM (SELECT e, a, $4::SMALLINT AS value_type_tag, $5::BIGINT AS v_ref, $6::BOOLEAN AS v_bool, $7::BIGINT AS v_long, $8::DOUBLE PRECISION AS v_double, $9::TEXT A",
      "calls": 5,
      "mean_ms": 159.7542568,
      "max_ms": 226.030865,
      "rows": 5
    }
  ]
}