advancedDatabase455 of 469
Database CPU hits 100% while application CPU stays low. How do you find the queries responsible?
Tests whether you'd pull the DB's slow-query log or active query view (pg_stat_activity, SHOW PROCESSLIST) to find long-running or frequently-executed queries, rather than looking at the application side where the symptom clearly isn't located.
Ready to master this question?
Generate a complete walkthrough — background, the full answer in plain language, a working code example explained line by line, a real-world scenario, common mistakes, and how this same question gets asked in different ways.
Sign in to generate a response