cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

🎥 SQL Query Optimization in Kubernetes: Using PostgreSQL Logs for Analytics

GosiaMurawska
Community Team
Community Team


Welcome to "Observe & Resolve" – Cloud-Native Troubleshooting Made Simple!

In this new series, Henrik Rexed @HenrikRexed will explore how to collect and analyze SQL statements from the PostgreSQL database, including execution durations. Logs, analytics, and dashboards will give you deep insights into your database performance.

🚀 Here’s what you’ll learn:
• Why Logs Matter: Configure PostgreSQL to log detailed SQL statements and execution times, focusing on slow queries.
• Setting up Observability: Use Dynatrace Operator, Fluent Bit, and Dynatrace collector to capture logs and traces from your Kubernetes environment.
• Analyzing SQL Statements: Visualize PostgreSQL logs and perform analytics to track query performance.
• Dashboards and Workflow Automations: Turn SQL insights into real-time dashboards and trigger workflows based on slow queries.

🚀 Key Tools:
• PostgreSQL logs for query insights
• Dynatrace Operator for observability
• Fluent Bit for log collection
• Dynatrace collector for performance tracing

-----------------------------

📖 Chapters 📖

00:00 Introduction
00:41 The importance of logs in SQL performance
01:10 Configuring PostgreSQL for detailed SQL logging
02:12 Setting up observability in Kubernetes
03:04 Analyzing SQL statements for performance insights

-----------------------------

🔗 Additional Links

GitHub Observe-Resolve

-----------------------------

Subscribe to our YT channel 
Stay up-to-date with Dynatrace! Follow us on FacebookInstagramLinkedIn, TwitterTwitch  

0 REPLIES 0

Featured Posts