Schedule - PGDay UK 2023
Using buffers for query optimisation
Date: 2023-09-12
Time: 10:00–10:50
Room: Council Chamber
Level: Intermediate
Feedback: Leave feedback
When doing query optimisation work, it is natural to focus on timing data. If we want to speed up a query, we need to understand which parts are slow.
But timings have a few weaknesses: they vary from run to run, they depend on the cache, and on their own can hide some inefficiencies.
In this talk we’ll explore how you can complement timings with the amount of data read and/or written by a query, by using the explain parameter buffers.