pgcenter
pg_activity
Our great sponsors
| pgcenter | pg_activity | |
|---|---|---|
| 2 | 5 | |
| 1,509 | 2,396 | |
| - | 2.5% | |
| 0.0 | 7.7 | |
| about 1 year ago | 8 days ago | |
| Go | Python | |
| GNU General Public License v3.0 or later | PostgreSQL License |
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.
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
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.
What are some alternatives?
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.
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
go-pg - Golang ORM with focus on PostgreSQL features and performance
psutil - Cross-platform lib for process and system monitoring in Python
pgweb - Cross-platform client for PostgreSQL databases
nvitop - An interactive NVIDIA-GPU process viewer and beyond, the one-stop solution for GPU process management.
sqlc - Generate type-safe code from SQL
topalias - Linux bash/zsh aliases generator
electric - Local-first sync layer for web and mobile apps. Build reactive, realtime, local-first apps directly on Postgres.
daytona - The Open Source Dev Environment Manager.
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