‎24 Sep 2024 08:19 AM - edited ‎24 Sep 2024 08:20 AM
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
-----------------------------
Subscribe to our YT channel
Stay up-to-date with Dynatrace! Follow us on Facebook, Instagram, LinkedIn, Twitter, Twitch