Read PG WAL stats
read_pg_wal_statsRead Write-Ahead Log (WAL) record statistics for a specified LSN range, grouped by resource manager or record type. Requires the pg_walinspect extension.
Instructions
Read Write-Ahead Log (WAL) record statistics over a specified LSN range, grouped by resource manager or record type. Requires the pg_walinspect extension. If not installed, returns available=false.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| end_lsn | No | ||
| database | No | Optional: target a configured secondary (read-only) database by name; omit for the primary. Call list_databases to see the configured ids. | |
| start_lsn | Yes | ||
| per_record | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| stats | Yes | ||
| available | Yes |