5mins of Postgres E57: The new pg_stat_io view in Postgres 16 and the everyday DBA perspective

preview_player
Показать описание
Today, I want to talk about the pg_stat_io view and the everyday DBA perspective on why it matters. We’ll go through tracking activity in Postgres with pg_stat_io and talk about getting insights into extends, evictions, reuses, and more.

*Find the article on our blog here:*

*Learn more about pganalyze:*

*Check out the pganalyze library for eBooks, webinars, and more:*

📑 *What we have discussed in this episode of 5mins of Postgres:*

*Waiting for PostgreSQL 16 – Add pg_stat_io view, providing more detailed IO statistics - by depesz*

*Add pg_stat_io view, providing more detailed IO statistics - postgres commitdiff*

*Andres Freund on Twitter*

*Melanie Plageman on Twitter*

*Track IO times in pg_stat_io*

*pgbench*

*Waiting for Postgres 16: Cumulative I/O statistics with pg_stat_io - by Lukas Fittl*
  1. pganalyze
  2. Lukas Fittl
  3. pganalyze
  4. Andres Freund
  5. Melanie Plageman
  6. depesz
Рекомендации по теме
5mins of Postgres 0:05:15

5mins of Postgres E57: The new pg_stat_io view in Postgres 16 and the everyday DBA perspective

5mins of Postgres 0:05:32

5mins of Postgres E51: Using Memoize to speed up joins between two Postgres tables

5mins of Postgres 0:06:18

5mins of Postgres E58: Handling integer sequence overflow without downtime

5mins of Postgres 0:05:30

5mins of Postgres E52: Waiting for Postgres 16: Surviving without a superuser & reserved_connect...

5mins of Postgres 0:05:52

5mins of Postgres E5: Debugging a 100% CPU utilization spike with Postgres EXPLAIN and perf

Waiting for Postgres 0:04:35

Waiting for Postgres 16: Buffer cache hit ratio and I/O times in pg_stat_io - 5mins of Postgres E64

Waiting for Postgres 0:05:41

Waiting for Postgres 16: Running EXPLAIN on any query (even with $1 parameters!)

4 improvements in 0:06:29

4 improvements in Postgres 16 that you might not know about yet

How bulk loading 0:04:47

How bulk loading with COPY can be 300% times faster in Postgres 16 Beta 1

Speed up Postgres 0:05:52

Speed up Postgres queries by 30%: How to use transaction pooling with prepared statements

Postgres 16 is 0:05:46

Postgres 16 is released

Webinar Recording: How 1:07:48

Webinar Recording: How to use the Postgres query planner to debug bad plans and speed up queries

Unleashing the Power 0:16:02

Unleashing the Power of PostgreSQL Materialized Views | Boost Database Performance!

SQL : How 0:01:17

SQL : How to efficiently vacuum analyze tables in Postgres

Postgres table bloat 0:03:50

Postgres table bloat with pgstattuple

pg_stat_statements | Postgres.FM 0:53:04

pg_stat_statements | Postgres.FM 044 | #PostgreSQL #Postgres podcast

Tutorial 27-Important statistics 0:01:14

Tutorial 27-Important statistics views to monitor PostgreSQL servers

16 Conditional statements 0:15:48

16 Conditional statements with SQL CASE - Spatial SQL with Postgres/PostGIS (Learning FOSS4G Stack)

Our favourite v16 0:30:55

Our favourite v16 feature | Postgres.FM 062 | #PostgreSQL #Postgres podcast

SQL : postgresql 0:01:33

SQL : postgresql pgBench tool running user defined SQL script

The Level Up 0:57:01

The Level Up Hour (E57) | Adding software to RHEL8 UBIs

Performance Analysis Using 0:38:33

Performance Analysis Using pg_stat | YugabyteDB Friday Tech Talks | Episode 46

Postgres 16 Beta 0:16:04

Postgres 16 Beta 1, Rust Functions, Partition Memory Problems, Tags & Arrays | Scaling Postgres ...

Databases: Query optimization 0:02:34

Databases: Query optimization for multiple joins postgres