How do you handle slow queries when there's no DBA on the team?
Hey all -
Been doing database performance work (mostly Postgres/MySQL) for over a decade, and I keep running into the same situation with small teams: no dedicated DBA, but queries are slowing things down as the product grows.
Curious how people here actually deal with it in practice. Do you just wait until something breaks and then dig into EXPLAIN plans yourself? Does one dev end up becoming the "unofficial DBA" by default? Do you use any monitoring tool, or is it mostly guesswork?
Not selling anything, genuinely trying to understand how painful (or not) this actually is for teams without dedicated DB expertise, and what you wish existed to make it easier.