plpgsql_check VS pg_show_plans

Compare plpgsql_check vs pg_show_plans and see what are their differences.

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). (by okbob)

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
plpgsql_check pg_show_plans
3 1
605 176
- 1.7%
8.4 7.7
about 1 month ago about 2 months ago
C C
GNU General Public License v3.0 or later 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.

plpgsql_check

Posts with mentions or reviews of plpgsql_check. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-08-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 plpgsql_check and pg_show_plans you can also consider the following projects:

pgsentinel - postgresql extension providing Active session history

pg_profile - Postgres historic workload reports

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.

pg_wait_sampling - Sampling based statistics of wait events

docker-postgis - Docker image for PostGIS

bg_mon - Background worker for monitoring PostgreSQL

tds_fdw - A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)

pg_plan_advsr - PostgreSQL extension for automated execution plan tuning

pg_plan_guarantee - Postgres Query Optimizer Extension that guarantees your desired plan will not change

pgaudit - PostgreSQL Audit Extension

pg-ulid - PostgreSQL extension for ULID