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 Microsoft Azure 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
  • Nodes from pg_dist_node
  • Tables from citus_tables and related
  • Table sizes using citus_table_size
  • Entries from the citus_stat_statements view
  • Co-ordinator and worker activity (citus_stat_activity)
  • Lock information (citus_lock_waits)

Currently the collected information is exposed only the JSON output.

Citus versions v10 and v11 are officially supported.