跳转到主要内容

PostgreSQL 等待事件大典

等待大典排查总图版本矩阵

English
简体中文

PostgreSQL 等待事件大典

PostgreSQL 等待事件大典
- 等待大典
  排查总图
  
  版本矩阵
  
  术语表
  
  Lock
  
  advisory
  
  applytransaction
  
  extend
  
  frozenid
  
  object
  
  page
  
  relation
  
  spectoken
  
  transactionid
  
  tuple
  
  userlock
  
  virtualxid
  
  LWLock
  
  AddinShmemInit
  
  AioUringCompletion
  
  AioWorkerSubmissionQueue
  
  AutoFile
  
  Autovacuum
  
  AutovacuumSchedule
  
  BackgroundWorker
  
  BtreeVacuum
  
  BufferContent
  
  BufferMapping
  
  Checkpoint
  
  CheckpointerComm
  
  CommitTs
  
  CommitTsBuffer
  
  CommitTsSLRU
  
  ControlFile
  
  DSMRegistry
  
  DSMRegistryDSA
  
  DSMRegistryHash
  
  DynamicSharedMemoryControl
  
  InjectionPoint
  
  LockFastPath
  
  LockManager
  
  LogicalRepLauncherDSA
  
  LogicalRepLauncherHash
  
  LogicalRepWorker
  
  MultiXactGen
  
  MultiXactMemberBuffer
  
  MultiXactMemberSLRU
  
  MultiXactOffsetBuffer
  
  MultiXactOffsetSLRU
  
  MultiXactTruncation
  
  NotifyBuffer
  
  NotifyQueue
  
  NotifyQueueTail
  
  NotifySLRU
  
  OidGen
  
  OldSnapshotTimeMap
  
  ParallelAppend
  
  ParallelBtreeScan
  
  ParallelHashJoin
  
  ParallelQueryDSA
  
  ParallelVacuumDSA
  
  PerSessionDSA
  
  PerSessionRecordType
  
  PerSessionRecordTypmod
  
  PerXactPredicateList
  
  PgStatsDSA
  
  PgStatsData
  
  PgStatsHash
  
  PredicateLockManager
  
  ProcArray
  
  RelCacheInit
  
  RelationMapping
  
  ReplicationOrigin
  
  ReplicationOriginState
  
  ReplicationSlotAllocation
  
  ReplicationSlotControl
  
  ReplicationSlotIO
  
  SInvalRead
  
  SInvalWrite
  
  SerialBuffer
  
  SerialControl
  
  SerialSLRU
  
  SerializableFinishedList
  
  SerializablePredicateList
  
  SerializableXactHash
  
  SharedTidBitmap
  
  SharedTupleStore
  
  ShmemIndex
  
  SubtransBuffer
  
  SubtransSLRU
  
  SyncRep
  
  SyncScan
  
  TablespaceCreate
  
  TwoPhaseState
  
  WALBufMapping
  
  WALInsert
  
  WALSummarizer
  
  WALWrite
  
  WaitEventCustom
  
  WrapLimitsVacuum
  
  XactBuffer
  
  XactSLRU
  
  XactTruncation
  
  XidGen
  
  I/O
  
  AioIoCompletion
  
  AioIoUringExecution
  
  AioIoUringSubmit
  
  BasebackupRead
  
  BasebackupSync
  
  BasebackupWrite
  
  BuffileRead
  
  BuffileTruncate
  
  BuffileWrite
  
  ControlFileRead
  
  ControlFileSync
  
  ControlFileSyncUpdate
  
  ControlFileWrite
  
  ControlFileWriteUpdate
  
  CopyFileCopy
  
  CopyFileRead
  
  CopyFileWrite
  
  DataFileExtend
  
  DataFileFlush
  
  DataFileImmediateSync
  
  DataFilePrefetch
  
  DataFileRead
  
  DataFileSync
  
  DataFileTruncate
  
  DataFileWrite
  
  DsmAllocate
  
  DsmFillZeroWrite
  
  LockFileAddtodatadirRead
  
  LockFileAddtodatadirSync
  
  LockFileAddtodatadirWrite
  
  LockFileCreateRead
  
  LockFileCreateSync
  
  LockFileCreateWrite
  
  LockFileRecheckdatadirRead
  
  LogicalChangesRead
  
  LogicalChangesWrite
  
  LogicalRewriteCheckpointSync
  
  LogicalRewriteMappingSync
  
  LogicalRewriteMappingWrite
  
  LogicalRewriteSync
  
  LogicalRewriteTruncate
  
  LogicalRewriteWrite
  
  LogicalSubxactRead
  
  LogicalSubxactWrite
  
  RelationMapRead
  
  RelationMapReplace
  
  RelationMapSync
  
  RelationMapWrite
  
  ReorderBufferRead
  
  ReorderBufferWrite
  
  ReorderLogicalMappingRead
  
  ReplicationSlotRead
  
  ReplicationSlotRestoreSync
  
  ReplicationSlotSync
  
  ReplicationSlotWrite
  
  SlruFlushSync
  
  SlruRead
  
  SlruSync
  
  SlruWrite
  
  SnapbuildRead
  
  SnapbuildSync
  
  SnapbuildWrite
  
  TimelineHistoryFileSync
  
  TimelineHistoryFileWrite
  
  TimelineHistoryRead
  
  TimelineHistorySync
  
  TimelineHistoryWrite
  
  TwophaseFileRead
  
  TwophaseFileSync
  
  TwophaseFileWrite
  
  VersionFileSync
  
  VersionFileWrite
  
  WalBootstrapSync
  
  WalBootstrapWrite
  
  WalCopyRead
  
  WalCopySync
  
  WalCopyWrite
  
  WalInitSync
  
  WalInitWrite
  
  WalRead
  
  WalSummaryRead
  
  WalSummaryWrite
  
  WalSync
  
  WalSyncMethodAssign
  
  WalWrite
  
  WalsenderTimelineHistoryRead
  
  IPC
  
  AppendReady
  
  ArchiveCleanupCommand
  
  ArchiveCommand
  
  BackendTermination
  
  BackupWaitWalArchive
  
  BgworkerShutdown
  
  BgworkerStartup
  
  BtreePage
  
  BufferIo
  
  CheckpointDelayComplete
  
  CheckpointDelayStart
  
  CheckpointDone
  
  CheckpointStart
  
  ExecuteGather
  
  HashBatchAllocate
  
  HashBatchElect
  
  HashBatchLoad
  
  HashBuildAllocate
  
  HashBuildElect
  
  HashBuildHashInner
  
  HashBuildHashOuter
  
  HashGrowBatchesDecide
  
  HashGrowBatchesElect
  
  HashGrowBatchesFinish
  
  HashGrowBatchesReallocate
  
  HashGrowBatchesRepartition
  
  HashGrowBucketsElect
  
  HashGrowBucketsReallocate
  
  HashGrowBucketsReinsert
  
  LogicalApplySendData
  
  LogicalParallelApplyStateChange
  
  LogicalSyncData
  
  LogicalSyncStateChange
  
  MessageQueueInternal
  
  MessageQueuePutMessage
  
  MessageQueueReceive
  
  MessageQueueSend
  
  MultixactCreation
  
  ParallelBitmapScan
  
  ParallelCreateIndexScan
  
  ParallelFinish
  
  ProcSignalBarrier
  
  ProcarrayGroupUpdate
  
  Promote
  
  RecoveryConflictSnapshot
  
  RecoveryConflictTablespace
  
  RecoveryEndCommand
  
  RecoveryPause
  
  ReplicationOriginDrop
  
  ReplicationSlotDrop
  
  RestoreCommand
  
  SafeSnapshot
  
  SyncRep
  
  WalReceiverExit
  
  WalReceiverUpstreamCatchup
  
  WalReceiverWaitStart
  
  WalSummaryReady
  
  XactGroupUpdate
  
  Client
  
  ClientRead
  
  ClientWrite
  
  GssOpenServer
  
  LibpqwalreceiverConnect
  
  LibpqwalreceiverReceive
  
  SslOpenServer
  
  WaitForStandbyConfirmation
  
  WalSenderWaitForWal
  
  WalSenderWriteData
  
  Activity
  
  ArchiverMain
  
  AutovacuumMain
  
  BgwriterHibernate
  
  BgwriterMain
  
  CheckpointerMain
  
  CheckpointerShutdown
  
  IoWorkerMain
  
  LogicalApplyMain
  
  LogicalLauncherMain
  
  LogicalParallelApplyMain
  
  PgStatMain
  
  RecoveryWalStream
  
  ReplicationSlotsyncMain
  
  ReplicationSlotsyncShutdown
  
  SysloggerMain
  
  WalReceiverMain
  
  WalSenderMain
  
  WalSummarizerWal
  
  WalWriterMain
  
  Timeout
  
  BaseBackupThrottle
  
  CheckpointWriteDelay
  
  PgSleep
  
  RecoveryApplyDelay
  
  RecoveryRetrieveRetryInterval
  
  RegisterSyncRequest
  
  SpinDelay
  
  VacuumDelay
  
  VacuumTruncate
  
  WalSummarizerError
  
  BufferPin
  
  BufferPin
  
  Extension
  
  GUC
  
  autovacuum_freeze_max_age
  
  autovacuum_multixact_freeze_max_age
  
  autovacuum_naptime
  
  checkpoint_timeout
  
  deadlock_timeout
  
  full_page_writes
  
  idle_in_transaction_session_timeout
  
  lock_timeout
  
  max_connections
  
  max_locks_per_transaction
  
  max_parallel_workers_per_gather
  
  max_wal_size
  
  shared_buffers
  
  synchronous_commit
  
  synchronous_standby_names
  
  vacuum_freeze_table_age
  
  vacuum_multixact_freeze_table_age
  
  wal_buffers
  
  wal_sender_timeout
  
  wal_writer_delay
  
  wal_writer_flush_after
  
  指标
  
  active_backends
  
  blocked_sessions
  
  blocks_read
  
  buffer_hit_ratio
  
  checkpoint_time
  
  commit_latency
  
  io_read_time
  
  io_write_time
  
  locks_per_backend
  
  multixact_member_io
  
  oldest_multixact_age
  
  oldest_transaction_age
  
  replication_flush_lag
  
  statement_latency
  
  statement_wal_bytes
  
  wait_event_share
  
  waiting_sessions
  
  wal_bytes
  
  wal_fpi
  
  wal_sync_time
  
  wal_write_time
  
  xact_slru_io

等待大典
GUC
wal_writer_delay

查阅 Markdown 源码
打印完整章节

[[guc:wal_writer_delay]]

WAL writer 两轮活动之间的延迟。

WAL writer 两轮活动之间的延迟。

PostgreSQL 18 官方参数参考

被哪些等待事件引用

LWLock/WALWrite

最后修改 2026-09-11

←wal_sender_timeout wal_writer_flush_after→

被哪些等待事件引用

© 2026 PostgreSQL Wait Event Atlas contributors 保留所有权利

Built for the 03:00 incident window.

English
简体中文

键盘快捷键

章节导航

WS↑↓: 在侧栏中移动
AD←→: 收起或展开章节
EnterG: 打开当前页面
JK: 上一个或下一个标题
QE: 上一页或下一页

操作

/F: 搜索
\C: 命令面板
H: 专注阅读模式
LY: 切换语言
T: 切换主题
R: 切换顶层页面

↑↓ 选择 ↵ 打开 esc 关闭