Cheat Sheet logoCheat Sheet Today
PostgreSQL Advanced Cheat Sheet/Current WAL LSN

Inspect the current write-ahead log position.

Back to sheetBrowse commands
Sign in to save
Section: Replication and WAL

Current WAL LSN

sql
sql
SELECT pg_current_wal_lsn();
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Replication and WAL
Show wal_level
Inspect the current WAL level setting.
OpenIn sheetsqlsame section
Show max_wal_senders
Check capacity for replication sender processes.
OpenIn sheetsqlsame section
Create physical replication slot
Create a physical slot to retain WAL for a replica.
OpenIn sheetsqlsame section
Drop replication slot
Remove a replication slot when it is no longer needed.
OpenIn sheetsqlsame section
Create logical publication
Publish table changes for logical replication.
OpenIn sheetsqlsame section
Create subscription
Subscribe to logical replication changes from another server.
OpenIn sheetsqlsame section