Troubleshoot and Optimize PostgreSQL Performance in VS Code
From Visual Studio Code · · 5 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.
If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.
Description
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