On 29 Oct 2025, Mughees Ahmed, PostgreSQL Consultant at Stormatics, gave a practical, hands-on session showing how to use pg_gather to diagnose and fix common PostgreSQL production issues.
When performance issues strike, knowing where to look is half the battle. pg_gather simplifies PostgreSQL troubleshooting by collecting key diagnostic data in one go, so you can quickly identify and resolve problems before they impact your users.
On 29 Oct 2025, Mughees Ahmed, PostgreSQL Consultant at Stormatics, gave a practical, hands-on session showing how to use pg_gather to diagnose and fix common PostgreSQL production issues.
This webinar covered the following topics:
→ Detect table bloat and dead tuples before they slow down queries
→ Identify unused or expensive indexes draining resources
→ Spot blocking and idle-in-transaction sessions causing bottlenecks
→ Analyse database time and wait events to pinpoint contention
→ Review top queries impacting performance and response times
→ Interpret background writer and checkpointer information for I/O tuning
→ Get actionable tuning suggestions for parameters and workloads
This session is perfect for DBAs, DevOps engineers, and developers who manage PostgreSQL in production and want a faster way to get to the root cause of performance problems.
Mughees Ahmed is a PostgreSQL Database Architect with extensive expertise in designing and optimizing open-source database infrastructures to achieve high performance, high availability, and operational efficiency. He collaborates with engineering teams and database administrators to deliver scalable PostgreSQL solutions tailored to demanding, production-grade environments.
With a robust background across various open-source database systems, Mughees adopts a practical, real-world approach to database architecture, whether deploying high-availability clusters, automating backups, designing DR solutions, or managing DBaaS on Cloud platforms.
He actively disseminates his knowledge through hands-on content created for database professionals transitioning into PostgreSQL. His educational initiatives include Udemy.com courses with over 2,000 enrolled students and a YouTube channel attracting more than 3,000 daily viewers, accumulating over 300,000 views to date.