pg_activity
pgcenter
pg_activity | pgcenter | |
---|---|---|
5 | 2 | |
2,397 | 1,509 | |
0.5% | - | |
7.7 | 0.0 | |
16 days ago | about 1 year ago | |
Python | Go | |
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.
pg_activity
- FLaNK AI for 11 March 2024
-
PostgreSQL 16 Bi-Directional Logical Replication
https://github.com/cloudnative-pg/cloudnative-pg/issues/13
/? logical replication:
https://www.google.com/search?q=logical+replication
pgadmin docs > Publication Dialog; logical replication: https://www.pgadmin.org/docs/pgadmin4/development/publicatio...
https://github.com/dalibo/pg_activity#faq ; pip install `pg_activity[psychopg]` :
> FAQ: I can't see my queries only TPS is shown
Only the TPS
(How) Do any ~pg_top tools delineate logical replication activity?
pgcenter > PostgreSQL statistics [virtual tables] (and also /proc)
- pg_activity
- Pg_activity is a top like application for PostgreSQL server activity monitoring
-
How to Find and Stop Running Queries on PostgreSQL
https://github.com/dalibo/pg_activity ('a top-like application for PostgreSQL server activity monitoring') is quite useful.
pgcenter
-
PostgreSQL 16 Bi-Directional Logical Replication
https://github.com/lesovsky/pgcenter#postgresql-statistics
...
"Show HN: ElectricSQL, Postgres to SQLite active-active sync for local-first apps" (2023) from the creators of CRDTs https://news.ycombinator.com/item?id=37590257
electric-sql/electric:
-
How can I check the load of the PostgreSQL container?
pgmetrics will not tell you anything about the load in your database and container. It is more about the details of the internal structure of the database. You can try the pgcenter tool. https://github.com/lesovsky/pgcenter
What are some alternatives?
systeminformer - A free, powerful, multi-purpose tool that helps you monitor system resources, debug software and detect malware. Brought to you by Winsider Seminars & Solutions, Inc. @ http://www.windows-internals.com
Grafana - The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.
psutil - Cross-platform lib for process and system monitoring in Python
go-pg - Golang ORM with focus on PostgreSQL features and performance
nvitop - An interactive NVIDIA-GPU process viewer and beyond, the one-stop solution for GPU process management.
pgweb - Cross-platform client for PostgreSQL databases
topalias - Linux bash/zsh aliases generator
sqlc - Generate type-safe code from SQL
daytona - The Open Source Dev Environment Manager.
electric - Local-first sync layer for web and mobile apps. Build reactive, realtime, local-first apps directly on Postgres.
cloudnative-pg - CloudNativePG is a comprehensive platform designed to seamlessly manage PostgreSQL databases within Kubernetes environments, covering the entire operational lifecycle from initial deployment to ongoing maintenance
patroni - A template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or Kubernetes