pgsentinel
parallel-qo-postgres
pgsentinel | parallel-qo-postgres | |
---|---|---|
2 | 1 | |
157 | 4 | |
1.3% | - | |
4.7 | 0.0 | |
19 days ago | about 3 years 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
parallel-qo-postgres
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).
wal2json - JSON output plugin for changeset extraction
pg_wait_sampling - Sampling based statistics of wait events
citus - Distributed PostgreSQL as an extension
pg_net - A PostgreSQL extension that enables asynchronous (non-blocking) HTTP/HTTPS requests with SQL
jet - Type safe SQL builder with code generation and automatic query result data mapping
pg_profile - Postgres historic workload reports
pgBackRest - Reliable PostgreSQL Backup & Restore
pg_similarity - set of functions and operators for executing similarity queries
fluent-bit - Fast and Lightweight Logs and Metrics processor for Linux, BSD, OSX and Windows
pg_show_plans - Show query plans of all currently running SQL statements
TimescaleDB - An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.