pg_profile 0.1.4

Installation

pg_profile--0.1.4.tar.gz

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

sudo tar xzf pg_profile--0.1.4.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.1.4_manual.tar.gz file only for manual objects creation in restricted environments (when you have no file system access).

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

Changelog

• sample() function now tracks time elapsed taking sample on each server
• Top indexes by blocks fetched/read report section now conains index scan count field
• New take_subset_sample() function can be used in parallel samples collection in case of many servers.
• fix of #9 reported by @Guzya - incorrect database and tablespace size in report