4.21. Subscription Metrics #

Metrics based on the pg_stat_subscription view, collected by the subscription plugin:

  • postgresql.subscription.info{database, name, worker_type, worker_pid, worker_leader_pid, relid}

  • postgresql.subscription.lag_bytes{database, name}

  • postgresql.subscription.latest_end_unixtime{database, name}

  • postgresql.subscription.last_msg_send_unixtime{database, name}

  • postgresql.subscription.last_msg_receipt_unixtime{database, name}

  • available from Postgres Pro and PostgreSQL 15:

    • postgresql.subscription.apply_error_count{database, name}

    • postgresql.subscription.sync_error_count{database, name}

  • available from Postgres Pro and PostgreSQL 18:

    • postgresql.subscription.conflicts{database, name, conflict}