Extensions
- pgsql_tweaks 1.0.0
- Contains PostgreSQL functions and views which I regularly needed and might help others, too.
Documentation
README
Contents
PostgreSQL Views and Functions
The functions and views published in this extension are regularly needed in DBA daily jobs.
The views and functions are published in a schema of its own, pgsql_tweaks, please see the documentation Schema pgsql_tweaks.
All functions and views are covered by tests. The tests are done in simple SQL statements. Each test does raise division by zero if it fails.
The tests have been done with PostgreSQL 13 up to 18 beta 3.
Differences in the PostgreSQL behavior of previous PostgreSQL versions are noted.
Repositories
The main repository is availabe on Codeberg.
Issue Tracker
If you discover any issue, please file them on https://codeberg.org/pgsql_tweaks/pgsql_tweaks/issues.
Installation
You may either, install all functions as a package, or install single functions of your choice.
Please see the Installation Dokumentation documentation.
Building the Extension
Please see the Developer Information documentation.
Contribution Informaion
Please read the Contribution Informaion before you open a merge request.
Documentation
Detailed documentation is available on rtfm.pgsql-tweaks.org, this documentation just links the documentation there.
Additional Extensions
Parts of this extension do need additional extensions. It is documented in views and functions, when they depend on an additional extension.
All additional extensions are part of the PostgreSQL Additional Supplied Modules and Extensions
List of Additional Extensions
Functions and Views
- Schema pgsql_tweaks
- Function Documentation
- Functions to check data types
- Functions about Encryption
- System Information Functions
- Encoding Functions
- Aggregate Functions
- Format Functionshttps://rtfm.pgsql-tweaks.org/docs/functions/format/index.html
- Conversion Functions
- FUNCTION to_unix_timestamp - FUNCTION hex2bigint
- Other functions
- View Documentation
- System Information Views Documentation
- Statistic and Monitoring Views
- VIEW statistics_top_ten_query_times
- VIEW top_ten_query_average_time_in_seconds
- VIEW statistics_top_ten_time_consuming_queries
- VIEW statistics_top_ten_memory_usage_queries
- VIEW statistics_top_ten_called_queries
- VIEW statistics_top_ten_rows_returned_queries
- VIEW statistics_top_ten_shared_block_hits_queries
- Monitoring Views Documentation