3min chapter

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

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.
App store bannerPlay store banner

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode