pg_stat_statements
Postgres FM
How to Split Out Buffer Numbers for Time Compilation Statistics
There's about 10 different types that you get through the same ones you see in explain, explain analyze buffers. It could be useful to look at temp blocks or which queries are using most temporary space. I've seen quite a lot of people considering upping the cost limits for that or turning it off completely. But this would be my advice is to turn it off completely for LGP.
00:00
Transcript
Play full episode
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
