A.1. pgpro-otel-collector 0.5.0 #

Release date: 2026-02-13

This release is based on pgpro-otel-collector 0.4.0 and provides new features, optimizations and bug fixes. Major changes are as follows:

  • Added the sqlquery receiver to collect metrics and/or logs from custom SQL queries.

    Note

    The sqlquery receiver is currently experimental and is not recommended for production use.

  • Added the metricstransform processor to rename metrics and manage labels, including scaling and aggregation.

  • Added the recovery plugin to collect recovery statistics from the pg_stat_recovery_prefetch and pg_stat_database_conflicts views.

  • Added the subscription plugin to collect subscription statistics from the pg_stat_subscription and pg_stat_subscription_stats views.

  • Added the sequences plugin to collect sequence usage statistics from the pg_sequences view.

  • Added the logs plugin to collect log statistics using the pg_ls_logdir() function. This plugin currently includes only one metric — postgresql.logs.directory_size_bytes.

  • Added the biha plugin to collect BiHA cluster node statistics from the biha.status_v and biha.nodes_v views.

  • Split the tables plugin into several specialized plugins:

    • tables to retrieve table-level access and tuple statistics from the pg_stat_all_tables view

    • tables_io to retrieve table-level I/O statistics from the pg_statio_all_tables view

    • tables_size to retrieve table, heap, toast size statistics from the pg_tables view

    • tables_vacuum to retrieve table-level vacuum and analyze statistics from the pg_stat_all_tables view

  • Added new plugins to support the pgpro_stats extension. For the list of plugins, refer to Section 7.1.1.

  • Added metrics for collecting pg_wal and log directory sizes.

  • Added new metrics to support Postgres Pro and PostgreSQL 17 and 18. For details, refer to the Metrics section.

  • Added metrics for the archiver plugin to collect WAL archiving queue statistics.

  • Added the postgresql_wal_directory_files_count metric for the wal plugin to display the current number of WAL segments.

  • Included TOAST tables in bloat calculations.

  • Added support for regular expressions in ACL configuration. For example usage, refer to Section 6.6.5.1.

  • Added the ability to select the data source in Grafana when importing dashboard examples.

  • Added the example of sending logs to VictoriaLogs. Refer to Section 6.3.2.1.

  • Enhanced integration with Zabbix, including the following improvements:

    • Added support for activity, archiver, bgwriter, cache, checkpointer, health, io, locks, replication, tablespaces, and wal plugins.

    • Added triggers for the activity, archiver, cache, checkpointer, prepared_transactions, replication, and uptime plugins.

    • Fixed an issue that could lead to incorrect connection reuse across different data chunks. Now each batch is sent within a dedicated connection.

  • Implemented dashboards for the archiver, bgwriter, bloat_indexes, bloat_tables, cache, and checkpointer plugins.

  • Excluded vacuum operation statistics from the postgresql_activity_transactions_max_duration_milliseconds metric to avoid blocking statistic collection from other potentially long queries.

  • Fixed incorrect Postgres Pro and PostgreSQL edition detection in PPEM.

  • Updated the End User License Agreement. To see the revised document, refer to the LICENSE.EN.txt file.