pg_show_plans
pg_plan_advsr
pg_show_plans | pg_plan_advsr | |
---|---|---|
1 | 1 | |
176 | 92 | |
1.7% | - | |
7.7 | 6.8 | |
about 2 months ago | about 2 months ago | |
C | C | |
GNU General Public License v3.0 or later | - |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pg_show_plans
pg_plan_advsr
-
Discussion: the feasubility of using open source hyperparameter optimization tools and SQLAlchemy to automatically tune database performance
Something along the lines of https://github.com/ossc-db/pg_plan_advsr sounds more promising.
What are some alternatives?
pg_profile - Postgres historic workload reports
optuna - A hyperparameter optimization framework
pg_wait_sampling - Sampling based statistics of wait events
hyperopt - Distributed Asynchronous Hyperparameter Optimization in Python
plpgsql_check - plpgsql_check is a linter tool (does source code static analyze) for the PostgreSQL language plpgsql (the native language for PostgreSQL store procedures).
orafce - The "orafce" project implements in Postgres some of the functions from the Oracle database that are missing (or behaving differently).Those functions were verified on Oracle 10g, and the module is useful for production work.
bg_mon - Background worker for monitoring PostgreSQL
libfirm - graph based intermediate representation and backend for optimising compilers
pgsentinel - postgresql extension providing Active session history