Troubleshoot and Optimize PostgreSQL Performance in VS Code

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 Close description