Postgres FM cover image

pg_stat_statements

Postgres FM

CHAPTER

How to Deal With Snapshots of Your Workload

It would be good if all monitoring systems supported it quite well, but there is no. We need to take total time and understand like every second how many seconds we spend to process queries. This gives you understanding of your workload. And the same with buffers, block numbers, shot block, heat,. red, temporary blocks, and so on, local blocks. But in metrics, they collect, they don't collect this and you cannot calculate it yourself. They don't collect everything. It's a building block. If you want to work with it, you can work directly. I still don't have very good examples. So even 14, I work in production on systems I observe from myself

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.
App store bannerPlay store banner