Skip to content

Releases: cybertec-postgresql/pgwatch

v4.0.0

24 Sep 13:42
@pashagolub pashagolub
v4.0.0
c3590c2
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

Choose a tag to compare

View all tags
v4.0.0 Latest
Latest

What's New

This major release introduces several significant updates, new features, bug fixes, and enhancements

Important Changes

PostgreSQL 18 Metrics

  • total_XXX_time columns are added to table_stats metric;
  • read_bytes, write_bytes, and extend_bytes are added to stat_io metric;
  • use pg_stat_io for wal_stats metric;
  • use pg_ls_archive_statusdir() in archiver_pending_count metric;
  • num_done and slru_written columns are added to checkpointer metric;
  • parallel_workers_to_launch and parallel_workers_launched columns are added to db_stats metric.

Grafana Dashboards

  • New Grafana v12 dashboards have been added for both PostgreSQL and Prometheus sinks;
  • Grafana v10 support is discontinued;
  • New "Global Database Overview" dashboard with 26 panels, including new panels for replication, connections, and index usage (inspired by postgres.ai);
  • New "Database Overview" now has 21 panels with time lag support and improved visualizations;
  • New "Query Performance Analysis" dashboard with enhanced table with 17 metrics and 8 visualization panels (inspired by postgres.ai);
  • New "Tables Overview" dashboard providing insights into table sizes, bloat, and index usage with treemap visualizations panels.

Metrics

  • Realtime metrics have been deprecated and removed from the system.
  • Metrics can now be loaded from a specified folder, allowing for better organization and management of metric definitions.

Sinks

  • gRPC Sink Enhancements: Basic authentication support has been added to the gRPC sink, along with improved documentation for its usage.

Development and Contribution

  • The development experience with Docker Compose has been enhanced, making it easier to set up and manage the environment.
  • A new repository, pgwatch-contrib, has been created to host additional contributions and extensions for pgwatch from the community. The rpc subdirectory contains sample gRPC sinks implementations.

Changelog

New Contributors

Full Changelog: v3.7.0...v4.0.0

Contributors

pashagolub, dependabot, and 3 other contributors
Assets 13

v4.0.0-beta

08 Sep 16:32
@pashagolub pashagolub
v4.0.0-beta
d52df8d

Choose a tag to compare

View all tags
v4.0.0-beta

What's New

This major release introduces several significant updates, new features, bug fixes, and enhancements

Important Changes

PostgreSQL 18 Metrics

  • total_XXX_time columns are added to table_stats metric;
  • read_bytes, write_bytes, and extend_bytes are added to stat_io metric;
  • use pg_stat_io for wal_stats metric;
  • use pg_ls_archive_statusdir() in archiver_pending_count metric;
  • num_done and slru_written columns are added to checkpointer metric;
  • parallel_workers_to_launch and parallel_workers_launched columns are added to db_stats metric.

Grafana Dashboards

  • New Grafana v12 dashboards have been added for both PostgreSQL and Prometheus sinks;
  • Grafana v10 support is discontinued;
  • New "Global Database Overview" dashboard with 26 panels, including new panels for replication, connections, and index usage (inspired by postgres.ai);
  • New "Database Overview" now has 21 panels with time lag support and improved visualizations;
  • New "Query Performance Analysis" dashboard with enhanced table with 17 metrics and 8 visualization panels (inspired by postgres.ai);
  • New "Tables Overview" dashboard providing insights into table sizes, bloat, and index usage with treemap visualizations panels.

Metrics

  • Realtime metrics have been deprecated and removed from the system.
  • Metrics can now be loaded from a specified folder, allowing for better organization and management of metric definitions.

Sinks

  • gRPC Sink Enhancements: Basic authentication support has been added to the gRPC sink, along with improved documentation for its usage.

Development and Contribution

  • The development experience with Docker Compose has been enhanced, making it easier to set up and manage the environment.
  • A new repository, pgwatch-contrib, has been created to host additional contributions and extensions for pgwatch from the community. The rpc subdirectory contains sample gRPC sinks implementations.

Changelog

New Contributors

Full Changelog: v3.7.0...v4.0.0-beta

Contributors

pashagolub, dependabot, and 2 other contributors
Loading
0 Join discussion

v3.7.0

24 Jul 12:47
@pashagolub pashagolub
v3.7.0
2995dbe

Choose a tag to compare

View all tags
v3.7.0

What's Changed

  • [-] monitor all sources if --group cmdopt is omitted, fixes #843 (#847)
  • [*] improve stat-statements Grafana v11 Postgres dashboards by @f9n in #846

Full Changelog: v3.6.0...v3.7.0

What to do next?

Contributors

f9n
Loading

v3.6.0

16 Jul 09:05
@pashagolub pashagolub
v3.6.0
9ced8ec
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

Choose a tag to compare

View all tags
v3.6.0

What's Changed

  • [+] add "default" group processing by @pashagolub in #798
  • [+] add measurements written log message to RPC sink by @0xgouda in #829
  • [+] add TLS encryption to RPC channel by @0xgouda in #796
  • [+] bump go.etcd.io/etcd/v3 from 3.6.0 to 3.6.2 by @dependabot[bot] in #789 #837
  • [+] bump pashagolub/pgxmock/v4 from 4.7.0 to 4.8.0 by @dependabot[bot] in #806
  • [+] bump shirou/gopsutil/v4 from 4.25.5 to 4.25.6 by @dependabot[bot] in #827
  • [+] bump testcontainers/testcontainers-go from 0.37.0 to 0.38.0 by @dependabot[bot] in #839
  • [+] optimize the size of MeasurementEnvelope by @pashagolub in #793
  • [*] exclude MetricDef from MeasurementEnvelope by @pashagolub in #787
  • [*] improve --batching-delay parameter description, closes #821 by @pashagolub in #828
  • [-] fix --group command-line option, closes #792 by @pashagolub in #794
  • [-] fix instance_up metric, closes #759 by @pashagolub in #791
  • [-] fix master only postgres source shutdown due to catched InRecovery state logic by @0xgouda in #813
  • [-] fix Reap() method to update Recovery cache after processing the previous value by @0xgouda in #815
  • [-] fix Reap() to not require Source.MinDbSizeMb to be >= 8 by @0xgouda in #818
  • [-] fix Source.Equal() presets comparison, closes #830 by @0xgouda in #831
  • [-] fix typo in reapMetricMeasurements() log message by @0xgouda in #807
  • [-] fix JSONB null casting errors in postgres/v11 dashboards by @f9n in #838
  • [-] fix JSONB null casting errors in "Top Tables" and "Health-check" dashboards by @kmoppel in #833
  • [-] improve Prometheus scrapping, fixes #749 by @pashagolub in #790
  • [-] remove unnecessary check from FetchMetric() by @0xgouda in #808

New Contributors

  • @f9n made their first contribution in #838

Full Changelog: v3.5.0...v3.6.0

What to do next?

Contributors

kmoppel, pashagolub, and 3 other contributors
Loading

v3.5.0

05 Jun 14:48
@pashagolub pashagolub
v3.5.0
732f097
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

Choose a tag to compare

View all tags
v3.5.0

What's Changed

  • [+] add pprof build profile for debugging by @pashagolub in #779
  • [+] bump shirou/gopsutil/v4 from 4.25.4 to 4.25.5 by @dependabot in #774
  • [+] decrease memory allocations for metrics.MeasurementEnvelope by @pashagolub in #768
  • [+] define sync metric operations types as constants by @0xgouda in #781 #782
  • [+] move sources sync to the reaper by @pashagolub in #769
  • [+] rewrite ParseLogs() with timers and eliminate extra checks by @pashagolub in #770
  • [+] switch to json-iterator/go from encoding/json by @pashagolub in #776
  • [*] change json sink to use one global encoder by @0xgouda in #772
  • [*] remove metrics definitions from Postgres sink by @pashagolub in #773
  • [*] use pgx.Rows directly in DetectConfigurationChanges() by @pashagolub in #775
  • [-] add additional checks to LogParse() by @pashagolub in #784
  • [-] remove misleading VOLUME /var/lib/postgresql declaration by @pashagolub in #780

New Contributors

Full Changelog: v3.4.0...v3.5.0

What to do next?

Contributors

pashagolub, dependabot, and 0xgouda
Loading

v3.4.0

23 May 19:58
@pashagolub pashagolub
v3.4.0
861c882
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

Choose a tag to compare

View all tags
v3.4.0

What's Changed

  • [+] bump jackc/pgx/v5 from 5.7.4 to 5.7.5 by @dependabot in #763
  • [+] bump go.etcd.io/etcd/v3 from 3.5.21 to 3.6.0 by @dependabot in #762
  • [*] use consistent password in install docs by @df7cb in #765
  • [-] fix dbSourcesReaderWriter.updateDatabase() to include is_enabled by @pashagolub in #760
  • [-] fix QueryMeasurements nil pointer dereference, fixes #766 by @pashagolub in #767

New Contributors

Full Changelog: v3.3.0...v3.4.0

What to do next?

Contributors

df7cb, pashagolub, and dependabot
Loading

v3.3.0

12 May 11:51
@pashagolub pashagolub
v3.3.0
29ef983
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

Choose a tag to compare

View all tags
v3.3.0

What's Changed

New Contributors

Full Changelog: v3.2.0...v3.3.0

What to do next?

Contributors

kmoppel, iuuuuan, and 2 other contributors
Loading

v3.2.0

25 Mar 11:22
@pashagolub pashagolub
v3.2.0
f0949f9
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

Choose a tag to compare

View all tags
v3.2.0

What's Changed

New Contributors

Full Changelog: v3.1.0...v3.2.0

What to do next?

Contributors

mookie-, pashagolub, and 3 other contributors
Loading

v3.1.0

13 Feb 11:36
@pashagolub pashagolub
v3.1.0
05494f7

Choose a tag to compare

View all tags
v3.1.0

What's Changed

New Contributors

Full Changelog: v3.0.0...v3.1.0

What to do next?

Contributors

kmoppel, agelwarg, and 5 other contributors
Loading

3.0.0

17 Dec 11:15
@pashagolub pashagolub
3.0.0
98e0398

Choose a tag to compare

View all tags
3.0.0

What's New

This major release introduces several significant updates, new features, bug fixes, and enhancements:

Important Changes

  • Documentation: The documentation has been updated and moved to https://pgwat.ch for improved readability and navigation. Special part dedicated to the pgwatch development has been added.
  • Parallel Sinks: Support for simultaneous storing metric measurements to several destinations, e.g. database and file at once.
  • Custom Storage: Leverage our remote sink (RPC) interface to seamlessly integrate any storage format or data stream, such as Parquet files or Kafka, directly into pgwatch.
  • Windows Support Added: Windows support has been integrated, broadening the compatibility of the software.
  • Docker Images Rename: The pgwatch2-postgres Docker image has been renamed to pgwatch-demo, pgwatch2-daemon to pgwatch.
  • Enhanced Logging: An advanced logging system has been implemented to improve error tracking and monitoring.
  • Grafana Upgrade: Support for the latest Grafana v9.x and v10 has been added, including a switch to Grafana's REST API for dashboard provisioning.
  • Etcd v3 Migration: The system has been upgraded to Etcd v3, ensuring better performance and compatibility.
  • PostgreSQL 17 Metrics: New metrics for PostgreSQL 17 have been introduced.
  • Automatic Schema Rollout: A new automatic schema rollout mechanism has been implemented, streamlining database management.
  • Build and Test Workflow: A new "Build and Test" workflow has been added to automate testing and building processes.
  • WebUI Enhancements: The WebUI now includes options like test connections, a log tab, and a clone button for the database grid.
  • REST API: New REST API endpoints have been added, including endpoints such as source, /metric, /preset, log.
  • Docker Improvements: The Docker images and related scripts have been improved, including the introduction of a new Dockerfile based on the official Postgres image and Docker Compose support.
  • Test Coverage: Test coverage statistics are now available to ensure code quality and reliability.
  • Environment Variables Update: The PW2_ environment variable prefixes have been updated to PW3_.
  • Code Refactoring: The main.go file has been streamlined by extracting functionality into separate packages.
  • Deprecations: Removed support for InfluxDB, Graphite datastore, and other outdated features.

Dependency Updates

Numerous dependencies have been updated, including upgrades to Golang, PostgreSQL, Prometheus, and various Go modules. These upgrades ensure better performance, security, and compatibility with other tools.

This release represents a significant step forward in functionality, performance, and security, with a strong focus on expanding compatibility and improving the user experience.

Changelog

Read more

Contributors

krisavi, ondar, and 11 other contributors
Loading