pg_wait_sampling vs pgsentinel

pg_wait_sampling

Sampling based statistics of wait events (by postgrespro)

Source Code

Suggest alternative

Edit details

pgsentinel

postgresql extension providing Active session history (by pgsentinel)

Postgresql Postgres Database Troubleshooting tuning Extension Ash postgresql-extension

Source Code

Suggest alternative

Edit details

WorkOS - The modern identity platform for B2B SaaS

The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

workos.com

featured

InfluxDB - Power Real-Time Data Analytics at Scale

Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

www.influxdata.com

featured

pg_wait_sampling		pgsentinel
	Project
3	Mentions	2
132	Stars	157
0.8%	Growth	1.3%
5.6	Activity	4.7
6 months ago	Latest Commit	15 days ago
C	Language	C
GNU General Public License v3.0 or later	License	PostgreSQL License

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_wait_sampling

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

Moving from Oracle to Postgres, what should I know?
5 projects | /r/PostgreSQL | 11 Jul 2022

pg_wait_sampling together with pg_stat_statements gets you nearer to Oracle's ASH/AWR capabilities. PoWA can integrate that (and other interesting extensions) to generate some nice reports.
[RDS] Huge spikes in CPU Usage, but the Freeable Memory remains high. How do I configure my DB to use more memory?
3 projects | /r/PostgreSQL | 4 May 2022

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?
5 projects | /r/PostgreSQL | 1 Dec 2021

pg_wait_sampling

pgsentinel

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

[RDS] Huge spikes in CPU Usage, but the Freeable Memory remains high. How do I configure my DB to use more memory?
3 projects | /r/PostgreSQL | 4 May 2022

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?
5 projects | /r/PostgreSQL | 1 Dec 2021

pgsentinel

What are some alternatives?

When comparing pg_wait_sampling and pgsentinel you can also consider the following projects:

pg_profile - Postgres historic workload reports

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

pg_show_plans - Show query plans of all currently running SQL statements

pg_net - A PostgreSQL extension that enables asynchronous (non-blocking) HTTP/HTTPS requests with SQL

pgbadger - A fast PostgreSQL Log Analyzer

powa - PostgreSQL Workload Analyzer

pg_similarity - set of functions and operators for executing similarity queries

hstr - bash and zsh shell history suggest box - easily view, navigate, search and manage your command history.

pgBackRest - Reliable PostgreSQL Backup & Restore

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.