pg_profile 4.0

Installation

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

sudo tar xzf pg_profile--4.0.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.0_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

Changelog

• Corrected nested-level statements support (#37)
• Added username field in statement-related sections
• Statement statistics collection optimized
• pg_stat_kcache 2.2.1 (#39)
• Support of the pg_wait_sampling extension
• Manual samples delete functions (reported by @xinferum in #30)
• Obsolete samples management optimized
• bugfix: take_sample() function was waited on a lock on servers table entry due to missplaced lock check routine
• per-database checksum_failures is tracked and reported if detected during report interval
• Server name prefix for importing server names to avoid name conflicts during import
• Added Block I/O times in Database statistics section
• Report generation engine completely rewritten for future improvements
• fixed session statistics import
• fixed error in the docs #27
• Other fixes and optimizations