Search PostgreSQL documentation

WalReceiverWaitStartWait EventsReferenceWalReceiverWaitStart IPC 10 Waiting for startup process to send initial data for streaming replication. 11 12 13 14 15 16 17 18 19 20 Brief rendezvous is normal when every participant contin…Wait Events · IPC WalSenderMainWait EventsReferenceWalSenderMain Activity 10 Waiting in main loop of WAL sender process. 11 12 13 14 15 16 17 18 19 20 This is normally expected idleness for the matching background process. Investigate only w…Wait Events · Activity WalsenderTimelineHistoryReadWait EventsReferenceWalsenderTimelineHistoryRead IO 10 Waiting for a read from a timeline history file during walsender timeline command. 11 12 13 Waiting for a read from a timeline history file during a walsen…Wait Events · IO WalSenderWaitForWalWait EventsReferenceWalSenderWaitForWal Client 10 Waiting for WAL to be flushed in WAL sender process. 11 12 13 14 15 16 17 18 19 20 Idle ClientRead sessions are normal connection-pool inventory. Investigate ac…Wait Events · Client WalSenderWriteDataWait EventsReferenceWalSenderWriteData Client 10 Waiting for any activity when processing replies from WAL receiver in WAL sender process. 11 12 13 14 15 16 17 18 19 20 Idle ClientRead sessions are normal conne…Wait Events · Client WALSummarizerWait EventsReferenceWALSummarizer LWLock 17 Waiting to read or update WAL summarization state. 18 19 20 A brief sample is normal around short internal critical sections. Investigate when the same tranche affect…Wait Events · LWLock WalSummarizerErrorWait EventsReferenceWalSummarizerError Timeout 17 Waiting after a WAL summarizer error. 18 19 20 The wait is normal when the configured policy is intentional and useful work advances at the expected rate. Inves…Wait Events · Timeout WalSummarizerWalWait EventsReferenceWalSummarizerWal Activity 17 Waiting in WAL summarizer for more WAL to be generated. 18 19 20 This is normally expected idleness for the matching background process. Investigate only when qu…Wait Events · Activity WalSummaryReadWait EventsReferenceWalSummaryRead IO 17 Waiting for a read from a WAL summary file. 18 19 20 The wait is normal when the workload is expected to perform this read, write, sync, allocation, or completion operat…Wait Events · IO WalSummaryReadyWait EventsReferenceWalSummaryReady IPC 17 Waiting for a new WAL summary to be generated. 18 19 20 Brief rendezvous is normal when every participant continues to advance. Investigate when the same phase persist…Wait Events · IPC WalSummaryWriteWait EventsReferenceWalSummaryWrite IO 17 Waiting for a write to a WAL summary file. 18 19 20 The wait is normal when the workload is expected to perform this read, write, sync, allocation, or completion operat…Wait Events · IO WalSyncWait EventsReferenceWalSync IO 12 Waiting for a WAL file to reach durable storage. 13 14 15 16 17 18 19 20 The wait is normal when the workload is expected to perform this read, write, sync, allocation, or comp…Wait Events · IO WalSyncMethodAssignWait EventsReferenceWalSyncMethodAssign IO 10 Waiting for data to reach durable storage while assigning WAL sync method. 11 12 13 Waiting for data to reach durable storage while assigning a new WAL sync method.…Wait Events · IO WalWriteWait EventsReferenceWalWrite IO 10 Waiting for a write to a WAL file. 11 12 13 14 15 16 17 18 19 20 The wait is normal when the workload is expected to perform this read, write, sync, allocation, or completion …Wait Events · IO WALWriteWait EventsReferenceWALWrite LWLock 10 Waiting for WAL buffers to be written to disk. 11 12 13 14 15 16 17 18 19 20 9.6 Brief waits occur when concurrent committers help write WAL. Sustained WALWrite with commi…Wait Events · LWLock WalWriterMainWait EventsReferenceWalWriterMain Activity 10 Waiting in main loop of WAL writer process. 11 12 13 14 15 16 17 18 19 20 This is normally expected idleness for the matching background process. Investigate only w…Wait Events · Activity WrapLimitsVacuumWait EventsReferenceWrapLimitsVacuum LWLock 10 Waiting to update limits on transaction id and multixact consumption. 11 12 13 14 15 16 17 18 19 20 9.6 A brief sample is normal around short internal critical sec…Wait Events · LWLock XactBufferWait EventsReferenceXactBuffer LWLock 10 Waiting for I/O on a clog (transaction status) buffer. 11 12 13 Waiting for I/O on a transaction status SLRU buffer. 14 15 16 17 18 19 20 9.6 A brief sample is normal ar…Wait Events · LWLock XactGroupUpdateWait EventsReferenceXactGroupUpdate IPC 11 Waiting for group leader to update transaction status at transaction end. 12 13 Waiting for the group leader to update transaction status at transaction end. 14 15 16 …Wait Events · IPC XactSLRUWait EventsReferenceXactSLRU LWLock 10 Waiting to read or update transaction status. 11 12 13 Waiting to access the transaction status SLRU cache. 14 15 16 17 18 19 20 9.6 Short waits accompany transaction comp…Wait Events · LWLock XactTruncationWait EventsReferenceXactTruncation LWLock 10 Waiting to execute txid_status or update the oldest transaction id available to it. 11 12 13 Waiting to execute pg_xact_status or update the oldest transaction ID av…Wait Events · LWLock XidGenWait EventsReferenceXidGen LWLock 10 Waiting to allocate or assign a transaction id. 11 12 13 Waiting to allocate a new transaction ID. 14 15 16 17 18 19 20 9.6 A brief sample is normal around short internal cr…Wait Events · LWLock