About
This PostgreSQL extension is a bundle of views and function. They might be useful in the DBA daily jobs.
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 release candidate 1 .
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
- System Information Functions - FUNCTION pg_schema_size - FUNCTION pg_schema_size
- Encoding Functions - FUNCTION is_encoding - FUNCTION is_latin1 - FUNCTION return_not_part_of_latin1 - FUNCTION replace_latin1 - FUNCTION return_not_part_of_encoding - FUNCTION replace_encoding
- Aggregate Functions - AGGREGATE gap_fill - AGGREGATE array_min - AGGREGATE array_max - AGGREGATE array_avg - AGGREGATE array_sum
- Format Functionshttps://rtfm.pgsql-tweaks.org/docs/functions/format/index.html - FUNCTION date_de - FUNCTION datetime_de
- Conversion Functions
- FUNCTION to_unix_timestamp
- Other functions - FUNCTION is_empty - FUNCTION array_trim - FUNCTION get_markdown_doku_by_schema
- View Documentation
- System Information Views Documentation
- Statistic and Monitoring Views
- VIEW statistics_top_ten_query_times
- VIEW statistics_top_ten_query_times
- 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
- VIEW statistics_top_ten_wal_records_generated_queries
- Monitoring Views Documentation