Skip to content

Release 4.14

Latest
Latest

Choose a tag to compare

View all tags
@zubkov-andrei zubkov-andrei released this 30 Jun 11:09
4.14
This tag was signed with the committer’s verified signature.
zubkov-andrei Andrei Zubkov
GPG key ID: B9110093C76E3666
Verified
Learn about vigilant mode.
323a50c
This commit was signed with the committer’s verified signature.
zubkov-andrei Andrei Zubkov
GPG key ID: B9110093C76E3666
Verified
Learn about vigilant mode.

pg_profile 4.14

Installation

Provided file pg_profile--4.14.tar.gz is to be extracted into extension folder of postgresql installation:

sudo tar xzf pg_profile--4.14.tar.gz --directory $(pg_config --sharedir)/extension

You will need plpgsql and dblink extensions in your database, and pg_stat_statements extension if you need statements statistics. Then, you can create extension in postgresql database:

CREATE SCHEMA profile;
CREATE EXTENSION pg_profile SCHEMA profile;

If previous version of pg_profile is installed in your database, it can be updated:

ALTER EXTENSION pg_profile UPDATE;

Use provided pg_profile--4.14_manual.tar.gz file only for manual objects creation in restricted environments (when you have no file system access). Right now export and import functionalities is not supported in manually installed version.

For further setup and usage details refer to doc/pg_profile.md file

Grafana dashboards

You can use Grafana to visualize pg_profile samples data as time series. It will help you to find time intervals for reports. Dashboards are in pg_profile_grafana_4.14.tar.gz file.

Changelog

  • Support of PostgreSQL 19 statistics
  • Support of pg_stat_statements 1.13
  • Support of pg_stat_kcache 2.3.2
  • Added rows "WAL FPI generated" and "WAL FPI per second" to "WAL statistics" section (from pg_stat_wal.wal_fpi_bytes)
  • Added "Plan types" columns "Generic" and "Custom" to "Top SQL by planning time" section (from pg_stat_statements.generic_plan_calls and custom_plan_calls)
  • Added "Lock statistics" section (from pg_stat_lock)
  • Added "Top sequences by blocks fetched" and "Top sequences by blocks read" sections (from pg_statio_all_sequences)
  • fixed ordering in some dataset functions and report_struct
  • Added tests for comparing datasets during export-import regression test
  • get_report_context perfomance improved
  • Renamed "BufferPin" wait event type to "Buffer" in grafana
  • Fixed flaky regression test for storage parameters
  • Fixed flaky regression tests on slow execution environments
  • Fixed import errors and FK violations for missing samples
Assets 5
Loading