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.
The main repository is availabe on Codeberg.
If you discover any issue, please file them on https://codeberg.org/pgsql_tweaks/pgsql_tweaks/issues.
You may either, install all functions as a package, or install single functions of your choice.
Please see the Installation Dokumentation documentation.
Please see the Developer Information documentation.
Please read the Contribution Informaion before you open a merge request.
Detailed documentation is available on rtfm.pgsql-tweaks.org, this documentation just links the documentation there.
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
- Schema pgsql_tweaks
- Function Documentation
-
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