# Measure PostgreSQL WAL Throughput With SQL: Step-by-Step Guide

DevFeed: [Measure PostgreSQL WAL Throughput With SQL: Step-by-Step Guide](<https://devfeed.tech/articles/measure-postgresql-wal-throughput-with-sql-step-by-step-guide-82213.md>)

Original publisher: [Read original article](<https://estuary.dev/blog/measuring-postgresql-wal-throughput>)

Author: Dani Pálma

Published: 2024-10-04T12:39:12Z

Content type: tutorial

Language: en

Sources: [Estuary](<https://devfeed.tech/sources/estuary.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [data-engineering](<https://devfeed.tech/topics/data-engineering.md>)

Tags: [cdc](<https://devfeed.tech/tags/cdc.md>), [change-data-capture](<https://devfeed.tech/tags/change-data-capture.md>), [cron](<https://devfeed.tech/tags/cron.md>), [guide](<https://devfeed.tech/tags/guide.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

A tutorial shows how to estimate PostgreSQL WAL throughput by recording LSN positions, calculating WAL volume and generation rates with SQL views, and scheduling collection with cron or pg_cron. It explains that WAL volume only approximates change event throughput because WAL also includes metadata and other overhead.

## Source excerpt

Learn how to approximate change event throughput for PostgreSQL by measuring the Write-ahead-log (WAL).