pg_profile 0.2.1

Installation

pg_profile--0.2.1.tar.gz

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

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

• detailed sample taking timings collection feature.
• removed unmeaning zeros from report tables
• Latest two samples report function get_report_latest() added.
• FIX: time range based report-generating calls seldom failed. Reported by @cuprumtan
• FIX: kcache v.2.1.3 support #11 by @guilhermebrike
• FIX: field %Elapsed of sections "Top SQL by planning time" and "Top SQL by execution time"
• FIX: corrected statistics reset detection condition
• FIX: corrected diff reports join condition
• pg_stat_statements queryid field is shown in reports
• fixes and optimizations