Read the abstract ➤ https://www.conf42.com/DevOps_2024_Adam_Furmanek_observability_postgresql_mysql Other sessions at this event ➤ https://www.conf42.com/devops2024 Join Discord ➤ https://discord.gg/DnyHgrC7jC Chapters 0:00 intro 0:38 preamble 1:16 where we used to be... 3:30 where we are now 5:25 conway's law 8:17 communication 9:40 shift left 11:05 self service 12:56 dashboards what breaks in the current world? 14:03 problems with databases 15:55 slow queries 21:42 incompatible changes in schema 23:39 missing indexes 24:38 too many indexes orm challenges 25:49 - n+1 selects 27:07 - joins 27:25 - lack of visibility 27:55 - migrations 28:55 test - do they work? 29:30 load testing? 31:22 nonoptimal configuration solution - detabase guardrails 34:04 know the context to find the root cause 36:14 monitoring and observability what to observe? 37:14 executing the query 37:43 anatomy of an sql query how to observe? 39:10 observability 45:44 database guardrails 46:29 be proactive and push to the left! 46:54 metis demo 49:16 about metis 49:49 summary 50:57 thank you!