Foreman Deep Dives: SQL Debugging for Beginners (with Chris Duryee)
Links from this recording: https://explain.depesz.com/
Chris Duryee (@beav) joins us for this Deep Dive, in which he offers to give us a look into SQL debugging. He had this to say :)
"Have you ever seen this dreaded message in your production.log?
Completed 200 OK in 370053ms (Views: 29.8ms | ActiveRecord: 37007.0ms)
One of the reasons this can happen is from slow SQL statements. In this
30 minute tutorial, I will explain the steps needed to go from "hey this
is slow" through assembling all the data listed in
https://wiki.postgresql.org/wiki/Slow....
I'm by no means a database expert, but I found that being able to
assemble and examine the explain plan can make working with a developer
or database expert very productive.
This tutorial is primarily for advanced users and developers, but anyone
is welcome to attend."