pg_plan_advsr VS pg_show_plans

Compare pg_plan_advsr vs pg_show_plans and see what are their differences.

pg_plan_advsr

PostgreSQL extension for automated execution plan tuning (by ossc-db)

pg_show_plans

Show query plans of all currently running SQL statements (by cybertec-postgresql)
Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
pg_plan_advsr pg_show_plans
1 1
87 174
- 8.6%
4.8 7.7
almost 3 years ago 14 days ago
C C
- GNU General Public License v3.0 or later
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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_plan_advsr

Posts with mentions or reviews of pg_plan_advsr. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-01-08.

pg_show_plans

Posts with mentions or reviews of pg_show_plans. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-12-01.

What are some alternatives?

When comparing pg_plan_advsr and pg_show_plans you can also consider the following projects:

pg_profile - Postgres historic workload reports

pg_wait_sampling - Sampling based statistics of wait events

optuna - A hyperparameter optimization framework

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).

hyperopt - Distributed Asynchronous Hyperparameter Optimization in Python

bg_mon - Background worker for monitoring PostgreSQL

libfirm - graph based intermediate representation and backend for optimising compilers

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.

pgsentinel - postgresql extension providing Active session history

pg-ulid - PostgreSQL extension for ULID

postgresql-unit - SI Units for PostgreSQL