Question 5 of 10Pro Only

How do you monitor and troubleshoot replication lag, and what are common causes of excessive lag?

Sample answer preview

Replication lag is the delay between when a change is committed on the primary and when it is applied on the replica. Managing lag is critical because excessive lag means the replica may serve stale data for read queries and may lose more data if failover is needed.

replication lagpg_stat_replicationreplay_lsnmax_standby_streaming_delaywal_compressionhot_standby_feedback

Unlock the full answer

Get the complete model answer, key points, common pitfalls, and access to 9+ more Database Administrator interview questions.

Upgrade to Pro

Starting at $19/month • Cancel anytime