pg_profile 0.3.6

Installation

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

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

• WAL fields in statements by blocks dirtied report section
• pg_class.relpages is collected in samples now. This data is used in estimations while pg_relations_size() data is unavailable due to relation size collection policy.
• set application_name while taking a sample
• fixed #29 reported by @xinferum (relation size collection window)
• query texts in reports is now truncated to 20 000 characters by default
• internal fixes and optimizations
• fixed #31 reported by @sgrinko "ERROR: integer out of range" while collecting relation size data based on pg_class.relpages