pgsentinel
pguri
| pgsentinel | pguri | |
|---|---|---|
| 2 | 1 | |
| 157 | 304 | |
| 1.3% | - | |
| 4.7 | 0.0 | |
| 19 days ago | 7 months ago | |
| C | C | |
| PostgreSQL License | 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.
pgsentinel
-
[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?
pgsentinel
pguri
-
Image URLs: Text or Character Varying Data Type
There's also https://github.com/petere/pguri
What are some alternatives?
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.
pg_wait_sampling - Sampling based statistics of wait events
urler - trurl is a command line tool for URL parsing and manipulation. [Moved to: https://github.com/curl/trurl]
pg_net - A PostgreSQL extension that enables asynchronous (non-blocking) HTTP/HTTPS requests with SQL
trurl - trurl is a command line tool for URL parsing and manipulation.
pg_profile - Postgres historic workload reports
pg_auto_failover - Postgres extension and service for automated failover and high-availability
pg_similarity - set of functions and operators for executing similarity queries
Apache AGE - Graph database optimized for fast analysis and real-time data processing. It is provided as an extension to PostgreSQL.
pg_show_plans - Show query plans of all currently running SQL statements
parallel-qo-postgres - (not) Parellel Query Optimizer for Postgres. In this fork of Postgres, we replace the original query optimizer with a parallelized query optimizer based on the work of Trummer et al.