Скачать или смотреть PostgreSQL Monitoring Made Easy | Custom Queries + Filebeat + Elasticsearch

PostgreSQL offers tons of performance metrics — but how do you actually monitor them in real time?

In this deep dive, I’ll show you how to automate PostgreSQL performance monitoring using *custom SQL queries* and integrate them with *Filebeat, Elasticsearch, and Kibana* for insights and alerts.

You’ll learn:
How to collect PostgreSQL metrics using custom SQL queries
The gap between manual monitoring and real-time visibility
How to build a lightweight architecture using Filebeat + ELK
A real-world example: tracking active connections in PostgreSQL
Demo: end-to-end setup
How to safely deploy this workflow in a production system

By the end of this video, you’ll have a clear workflow for monitoring PostgreSQL performance reliably in your production setup.

#PostgreSQL #Monitoring #Elasticsearch #Filebeat #DevOps #DatabasePerformance

🔗 Resources:
Blog:   / monitor-postgres-performance-using-custom-...  
Source code: https://github.com/anasanjaria/monito...
Deep dive on Elastic Search:    • Elasticsearch Shards, Indices & ILM | Deep...  
Full course: https://www.notion.com/templates/moni...

⌚️Timestamps:

0:00 Introduction & agenda
1:24 The gap — how to streamline monitoring with custom queries
2:17 Architecture overview for automating custom query monitoring
3:30 Real-world example: monitoring active PostgreSQL connections
5:24 Demo: setting up the monitoring workflow
8:09 Understanding the code — how everything works
10:32 Deploying this system in production