Citus

Citus is a horizontal scaling solution for PostgreSQL, now part of Microsoft.

Starting with version 1.10.0, pgmetrics can collect information exposed by the citus extension. It can work with both standalone Citus installations as well as the managed Azure Hyperscale Citus deployments.

pgmetrics will automatically detect if the extension is installed, and if so collect citus-specific information. This is the default behavior, to change it add the command-line option --omit=citus.

Currently the following metrics/details are collected:

  • Citus version, e.g. Citus 9.4.0 on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
  • Table sizes using citus_table_size
  • List of nodes in the Citus cluster
  • Entries from the citus_stat_statements view (Citus Enteprise, Azure Hyperscale)
  • Co-ordinator and worker activity (citus_{dist,worker}_stat_activity)
  • Lock information (citus_lock_waits)

Currently the collected information is exposed only the JSON output.