Demystifying Database Performance Issues with sqlcommenter
summary
sqlcommenter augments SQL with URL-encoded key=value tags appended after the statement (preserving existing comments, comma‑separated and lexicographically sorted) so slow queries can be traced back to callsite info. Demo uses Node.js + Sequelize, Postgres on Cloud SQL (Cloud SQL Proxy), and the npm package google-cloud-sqlcommenter-connect; a simple voting app with a new getAllVotes route returns eight rows and logs show the added tags. Cloud SQL Insights surfaces those tags so route-by-load and query-plan samples pinpoint where latency originates.
AI-written summary · about
chapters (10)
- 0:00Start
- 1:11Sql Commenter
- 3:30Query Log
- 4:51Create a New Cloud Sql Instance
- 6:14Create a Database
- 7:24Create a Service Account
- 11:43Clone and Test
- 21:13Cloud Sql Insights
- 23:53Query Plans
- 24:52Resources
related talks
50mDemystifying Database Performance Issues with SQL Commenter
18mThe Future of Database Observability is Open: SQL Commenter Merges W...
46mAwesome SQL – tips and tricks for application developers
22mCorrelating Application and Database Performance Using OpenTelemetry
22mImproving the efficiency of more than 800 databases with o11y
26mLess Code, Faster Apps- Rediscovering SQL for Modern ORM Developers
23mFANTASTIC DATABASES AND WHERE TO FIND THEM
31mUsing Databases to pull your applications weight