pg_profile 4.2

Installation

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

sudo tar xzf pg_profile--4.2.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.2_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.2.tar.gz file.

Changelog

• Completely new report engine providing interactive reports feature (By @Djoongaar and @zubkov-andrei)
• max_sample_age field added to the output of show_servers() function. (Reported by @bat-manav in #40)
• WAL LSN of report bounds is now shown in "Cluster statistics" section
• Fixed #62 reported by @portnov - incorrect values in V15 before first statistics reset
• Support of temporary I/O time statistics for statements from pg_stat_statements extension.
• Fixed #65 reported by @pkonotopov - Idle in transaction timeout during a sample.
• #66 implemented. Now the take_sample(text, boolean) function returns the result of the operation.
• Manual objects creation script fixed. #64 reported by @Poleon-Na