pg_profile 0.1.2

PostgreSQL 13 support - new WAL and Planning time statistics.

Installation

pg_profile--0.1.2.tar.gz

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

sudo tar xzf pg_profile--0.1.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 pg_profile v.0.1.1 is installed in your database, it can be updated:

ALTER EXTENSION pg_profile UPDATE;

Use provided pg_profile--0.1.2_sql.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

• pg_stat_statements version 1.8 support:
  • Statement planning time
  • Statement WAL generation
• fix: "Hit(%)" field was incorrectly calculated
• Baseline creation on time range is now supported
• CPU timings are now shown in "Top SQL by elapsed time" if pg_stat_kcache extension was available
• I/O timing statistics added to "Statements statistics by database" section
• "WAL segments archived" and "WAL segments archive failed" statistics added to "Cluster statistics" section
• Workaround for pg_table_size and AccessExclusiveLocks. Now in many cases snapshot will be taken successful without size of locked relation.
• Top vacuum and analyze count tables in reports
• Implicit index vacuum I/O load estimation
• Added trigger functions timing statistics
• Many pg_profile functions renamed to be more standard-compatible (see doc/pg_profile.md file)
  • gets renamed to fetches
  • snapshots renamed to samples, and snapshot() function renamed to take_sample(), but for backward compatibility snapshot() call is possible.
  • retention renamed to max_sample_age
  • node renamed to server
  • pages renamed to blocks
• fixed issue #7 reported by @kayform
• Added a lot of report-table header hints
• Other improvements