Troubleshoot and Optimize PostgreSQL Performance in VS Code
The Visual Studio Code team walks through diagnosing a PostgreSQL slowdown from within the editor, using performance evidence to guide changes and check their effects. The demonstration is part of PostgreSQL Like a Pro: VS Code Edition.
From slowdown to evidence
The workflow starts in VS Code with the Performance Dashboard. It follows an application slowdown from its initial signals to the database workload and queries involved, keeping the investigation connected rather than moving between disconnected tools.
The episode covers these stages:
- Inspect performance signals in the Performance Dashboard.
- Identify the database workload and queries associated with the slowdown.
- Review guidance from Azure Advisor.
- Take a controlled action.
- Verify the result after the change.
The focus is on connecting symptoms to evidence before making changes, then checking whether the action addressed the problem.
Database Agent and approval
The episode also introduces the Database Agent experience, which brings issue context and recommended actions together. Review and approval remain under the user's control, so recommendations can be assessed before action is taken.
Resources
The series is produced by Microsoft in collaboration with AMD, supporting the infrastructure behind PostgreSQL workloads on Azure.