pg_show_plans
Show query plans of all currently running SQL statements (by cybertec-postgresql)
pg_profile
Postgres historic workload reports (by zubkov-andrei)
Our great sponsors
| pg_show_plans | pg_profile | |
|---|---|---|
| 1 | 3 | |
| 176 | 200 | |
| 1.7% | - | |
| 7.7 | 6.1 | |
| about 1 month ago | 19 days ago | |
| C | HTML | |
| 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.
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
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.
pg_profile
Posts with mentions or reviews of pg_profile.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-05-04.
-
Oracle to PostgreSQL
You could potentially use pg_profile on RDS as an AWR-like equivalent. !ref, the extension isn't supported natively but you can install the functionality using the SQL.
-
[RDS] Huge spikes in CPU Usage, but the Freeable Memory remains high. How do I configure my DB to use more memory?
Another Another source of high CPU could be wait events. There are no built-in tools in Postgres to monitor them (unless RDS provides some). The approach I'd take on a "regular" Postgres installation is to sample the content of pg_stat_activity and then later analyze that after spikes have occurred. There are several extensions that already provide this, e.g. pg_profile or pg_wait_sampling or pgsentinel
-
Any Tips for Analyzing (Concurrent) Transaction Performance?
pg_profile
What are some alternatives?
When comparing pg_show_plans and pg_profile you can also consider the following projects:
pg_wait_sampling - Sampling based statistics of wait events
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).
bg_mon - Background worker for monitoring PostgreSQL
pgsentinel - postgresql extension providing Active session history
pg_plan_advsr - PostgreSQL extension for automated execution plan tuning
pg-ulid - PostgreSQL extension for ULID