Every number here is a measurement at a time.

SELECT chain_id,
       block_height                            AS head,
       latest_processed_block                  AS processed,
       (block_height - latest_processed_block) AS lag,
       latest_fetched_block_number             AS fetched,
       num_events_processed                    AS events,
       is_hyper_sync                           AS is_hyper_sync,
       timestamp_caught_up_to_head_or_endblock AS caught_up_at
FROM public.chain_metadata
ORDER BY chain_id

SELECT 'Agent'            AS entity, "chainId", count(*) AS n FROM "Agent"            GROUP BY "chainId"
UNION ALL SELECT 'AgentRecord',      "chainId", count(*) FROM "AgentRecord"      GROUP BY "chainId"
UNION ALL SELECT 'AgentRecordOwner', "chainId", count(*) FROM "AgentRecordOwner" GROUP BY "chainId"
UNION ALL SELECT 'Feedback',         "chainId", count(*) FROM "Feedback"         GROUP BY "chainId"
UNION ALL SELECT 'Validation',       "chainId", count(*) FROM "Validation"       GROUP BY "chainId"
UNION ALL SELECT 'ChiasmRecord',     NULL::integer, count(*) FROM "ChiasmRecord"
UNION ALL SELECT 'ChiasmPresence',   NULL::integer, count(*) FROM "ChiasmPresence"
ORDER BY entity, "chainId" NULLS FIRST

SELECT c."chainId",
       COALESCE(a.registered, 0)           AS registered,
       COALESCE(a.later_transfers, 0)      AS later_transfers,
       COALESCE(a.metadata_updates, 0)     AS metadata_updates,
       COALESCE(f.new_feedback, 0)         AS new_feedback,
       COALESCE(f.feedback_revoked, 0)     AS feedback_revoked,
       COALESCE(f.responses, 0)            AS responses,
       COALESCE(v.validation_requests, 0)  AS validation_requests,
       COALESCE(v.validation_responses, 0) AS validation_responses
FROM (SELECT "chainId" FROM "Agent"
      UNION SELECT "chainId" FROM "Feedback"
      UNION SELECT "chainId" FROM "Validation") c
LEFT JOIN (SELECT "chainId", count(*) AS registered,
                  sum("transferCount") AS later_transfers,
                  sum("metadataUpdateCount") AS metadata_updates
           FROM "Agent" GROUP BY "chainId") a ON a."chainId" = c."chainId"
LEFT JOIN (SELECT "chainId", count(*) AS new_feedback,
                  count(*) FILTER (WHERE revoked) AS feedback_revoked,
                  count(*) FILTER (WHERE "responseUri" IS NOT NULL) AS responses
           FROM "Feedback" GROUP BY "chainId") f ON f."chainId" = c."chainId"
LEFT JOIN (SELECT "chainId", count(*) AS validation_requests,
                  count(*) FILTER (WHERE response IS NOT NULL) AS validation_responses
           FROM "Validation" GROUP BY "chainId") v ON v."chainId" = c."chainId"
ORDER BY c."chainId"

SELECT count(*)                                              AS documents,
       count(*) FILTER (WHERE "chainCount" >= 2)             AS on_both_chains,
       count(*) FILTER (WHERE "chainCount" >= 2
                        AND "uriConflict")                   AS key_collisions
FROM "ChiasmRecord"


SELECT r.id AS uri_hash, r.uri, r."chainCount", r."chainIds", r."agentCount",
       r."firstSeenChainId", r."uriConflict",
       p."chainId", p."agentCount" AS agents_on_chain, p."firstAgentId"
FROM "ChiasmRecord" r
JOIN "ChiasmPresence" p ON p.record_id = r.id
WHERE r."chainCount" >= 2 AND NOT r."uriConflict"
ORDER BY r."agentCount" DESC, r.id, p."chainId"