postgresDBSamples
pgwatch2
postgresDBSamples | pgwatch2 | |
---|---|---|
1 | 2 | |
418 | 1,730 | |
- | 1.3% | |
4.5 | 8.4 | |
8 months ago | 4 days ago | |
PLpgSQL | PLpgSQL | |
- | BSD 3-clause "New" or "Revised" 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.
postgresDBSamples
-
How to use indexes to optimize PostgreSQL queries
For this example we'll use a sample database with USDA food information. The .sql file to create and populate the database can be downloaded from here. We'll also be using SeeQR, an open source PostgreSQL analytics tool that I've recently been contributing to. If you'd like to follow along the examples you should have:
pgwatch2
- pgwatch2
-
How to check available disk space through pgadmin of RDS running postgre
pg_watch2 provides a PL/python function which lets you retrieve that information.
What are some alternatives?
netdata - Real-time performance monitoring, done right! https://www.netdata.cloud [Moved to: https://github.com/netdata/netdata]
UnifiedMetrics - Fully-featured metrics collection agent for Minecraft servers. Supports Prometheus and InfluxDB. Dashboard included out-of-box.
App.Metrics - App Metrics is an open-source and cross-platform .NET library used to record and report metrics within an application.
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.
Netdata - The open-source observability platform everyone needs
awesome-monitoring - INFRASTRUCTUREćOPERATION SYSTEM and APPLICATION monitoring tools.
zombodb - Making Postgres and Elasticsearch work together like it's 2023
blog - OpenSource,Database,Business,Minds. git clone --depth 1 https://github.com/digoal/blog