pg_profile 0.3.4

Installation

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

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

• support of new statistics of Postgres 14 (session and WAL statistics).
• optimized report building.
• limited relations sizes collection with defined size collection policy will now collect sizes for only seq-scanned or vacuumed tables in each sample providing useful estimations in reports without overall database objects size collections.
• fixed incorrect database growth value in case of database statistics reset in a report interval.
• interval bounds in the report contains timezone now (reported by @antiorum in #21).
• fixed settings collection. pg_profile dump could not be loaded if there was a postgres updrage on the source system.
• fixed statements aggregation in report tables. Due to different query texts the same statement could appear several times in one report section making it difficult to realize workload of the statement.
• other fixes and optimisations