Troubleshoot and Optimize PostgreSQL Performance in VS Code

When your application slows down, finding the database issue shouldn’t mean jumping between disconnected tools. In this episode of PostgreSQL Like a Pro: VS Code Edition, see a PostgreSQL performance troubleshooting workflow that starts from Visual Studio Code. Follow a slowdown from signal to evidence using the Performance Dashboard, identify the database workload and queries involved, review guidance from Azure Advisor, take a controlled action, and verify the result. You’ll also get a look at the Database Agent experience for bringing issue context and recommended actions together while keeping you in control of review and approval. 🚀 Build with the PostgreSQL extension for VS Code: https://aka.ms/pg-pro-vs-code-repo ▶ Check out the full series: https://aka.ms/postgresql-like-a-pro-vscode 📖 Chapters: 00:00 Introduction to Database Agent 00:27 Welcome to PostgreSQL Like a Pro series 00:52 Overview of PostgreSQL performance challenges 01:47 Introducing the Database Agent in VS Code 02:22 How Database Agent works (Proactive and Reactive monitoring) 02:34 Analyzing a detected performance issue 03:05 Reviewing recommendations and performing actions 03:56 Using GitHub Copilot for further investigation 04:27 Conclusion PostgreSQL Like a Pro: VS Code Edition is brought to you by Microsoft in collaboration with AMD, supporting the infrastructure that powers modern PostgreSQL workloads on Azure. 📲 Follow VS Code: Instagram: https://www.instagram.com/vscode/ X: https://x.com/code Bluesky: https://bsky.app/profile/vscode.dev LinkedIn: https://aka.ms/VSCode/LinkedIn GitHub: https://github.com/microsoft/vscode #postgresql #vscode