跳转到主要内容

版本矩阵

对账后的 PostgreSQL 13–18 等待事件清单,包括改名与类型迁移。

版本矩阵对账两条事实路径:PostgreSQL 13–16 官方监控章节表格,以及在 PostgreSQL 17–18 Docker 实例上实查得到的 pg_wait_events 行。

版本 提取权威 行数
13 官方 monitoring 文档 222
14 官方 monitoring 文档 231
15 官方 monitoring 文档 238
16 官方 monitoring 文档 246
17 Docker postgres:17,查询 pg_wait_events 265
18 Docker postgres:18,查询 pg_wait_events 274

并集包含 327 个精确的 (type, name) 身份。其中 45 个历史身份归并为 282 个语义档案:281 个核心事件条目,加 1 个 Extension 机制占位记录。映射包括 PG14 两次类型迁移、PG16 两个经核验的 Parallel Hash 改名,以及 PostgreSQL 在 PG17 进行的等待名称拼写规范化。

下载

CSV 会把新旧名称保留为独立行,并提供 canonical 列。事件页面通过显式 alias 合并阅读,但不会抹掉它们真实的版本范围。

改名判定策略

只有证据确定时才建立映射:相邻版本替代项在忽略大小写并移除非字母数字后完全相同,或源码/文档能够建立经核验的改名关系。描述相似本身不足以判定;PgStatMain 等移除项会保留为历史事件,而不是猜测别名。

完整身份矩阵

类型 事件身份 13 14 15 16 17 18 标准身份 / 变化
Activity ArchiverMain
Activity AutoVacuumMain Activity/AutovacuumMain · spelling
Activity AutovacuumMain
Activity BgWriterHibernate Activity/BgwriterHibernate · spelling
Activity BgWriterMain Activity/BgwriterMain · spelling
Activity BgwriterHibernate
Activity BgwriterMain
Activity CheckpointerMain
Activity CheckpointerShutdown
Activity IoWorkerMain
Activity LogicalApplyMain
Activity LogicalLauncherMain
Activity LogicalParallelApplyMain
Activity PgStatMain
Activity RecoveryWalStream
Activity ReplicationSlotsyncMain
Activity ReplicationSlotsyncShutdown
Activity SysLoggerMain Activity/SysloggerMain · spelling
Activity SysloggerMain
Activity WalReceiverMain
Activity WalSenderMain
Activity WalSummarizerWal
Activity WalWriterMain
BufferPin BufferPin
Client ClientRead
Client ClientWrite
Client GSSOpenServer Client/GssOpenServer · spelling
Client GssOpenServer
Client LibPQWalReceiverConnect Client/LibpqwalreceiverConnect · spelling
Client LibPQWalReceiverReceive Client/LibpqwalreceiverReceive · spelling
Client LibpqwalreceiverConnect
Client LibpqwalreceiverReceive
Client SSLOpenServer Client/SslOpenServer · spelling
Client SslOpenServer
Client WaitForStandbyConfirmation
Client WalReceiverWaitStart IPC/WalReceiverWaitStart · type_move
Client WalSenderWaitForWAL Client/WalSenderWaitForWal · spelling
Client WalSenderWaitForWal
Client WalSenderWriteData
Extension Extension
IO AioIoCompletion
IO AioIoUringExecution
IO AioIoUringSubmit
IO BaseBackupRead IO/BasebackupRead · spelling
IO BaseBackupSync IO/BasebackupSync · spelling
IO BaseBackupWrite IO/BasebackupWrite · spelling
IO BasebackupRead
IO BasebackupSync
IO BasebackupWrite
IO BufFileRead IO/BuffileRead · spelling
IO BufFileTruncate IO/BuffileTruncate · spelling
IO BufFileWrite IO/BuffileWrite · spelling
IO BuffileRead
IO BuffileTruncate
IO BuffileWrite
IO ControlFileRead
IO ControlFileSync
IO ControlFileSyncUpdate
IO ControlFileWrite
IO ControlFileWriteUpdate
IO CopyFileCopy
IO CopyFileRead
IO CopyFileWrite
IO DSMAllocate IO/DsmAllocate · spelling
IO DSMFillZeroWrite IO/DsmFillZeroWrite · spelling
IO DataFileExtend
IO DataFileFlush
IO DataFileImmediateSync
IO DataFilePrefetch
IO DataFileRead
IO DataFileSync
IO DataFileTruncate
IO DataFileWrite
IO DsmAllocate
IO DsmFillZeroWrite
IO LockFileAddToDataDirRead IO/LockFileAddtodatadirRead · spelling
IO LockFileAddToDataDirSync IO/LockFileAddtodatadirSync · spelling
IO LockFileAddToDataDirWrite IO/LockFileAddtodatadirWrite · spelling
IO LockFileAddtodatadirRead
IO LockFileAddtodatadirSync
IO LockFileAddtodatadirWrite
IO LockFileCreateRead
IO LockFileCreateSync
IO LockFileCreateWrite
IO LockFileReCheckDataDirRead IO/LockFileRecheckdatadirRead · spelling
IO LockFileRecheckdatadirRead
IO LogicalChangesRead
IO LogicalChangesWrite
IO LogicalRewriteCheckpointSync
IO LogicalRewriteMappingSync
IO LogicalRewriteMappingWrite
IO LogicalRewriteSync
IO LogicalRewriteTruncate
IO LogicalRewriteWrite
IO LogicalSubxactRead
IO LogicalSubxactWrite
IO RelationMapRead
IO RelationMapReplace
IO RelationMapSync
IO RelationMapWrite
IO ReorderBufferRead
IO ReorderBufferWrite
IO ReorderLogicalMappingRead
IO ReplicationSlotRead
IO ReplicationSlotRestoreSync
IO ReplicationSlotSync
IO ReplicationSlotWrite
IO SLRUFlushSync IO/SlruFlushSync · spelling
IO SLRURead IO/SlruRead · spelling
IO SLRUSync IO/SlruSync · spelling
IO SLRUWrite IO/SlruWrite · spelling
IO SlruFlushSync
IO SlruRead
IO SlruSync
IO SlruWrite
IO SnapbuildRead
IO SnapbuildSync
IO SnapbuildWrite
IO TimelineHistoryFileSync
IO TimelineHistoryFileWrite
IO TimelineHistoryRead
IO TimelineHistorySync
IO TimelineHistoryWrite
IO TwophaseFileRead
IO TwophaseFileSync
IO TwophaseFileWrite
IO VersionFileSync
IO VersionFileWrite
IO WALBootstrapSync IO/WalBootstrapSync · spelling
IO WALBootstrapWrite IO/WalBootstrapWrite · spelling
IO WALCopyRead IO/WalCopyRead · spelling
IO WALCopySync IO/WalCopySync · spelling
IO WALCopyWrite IO/WalCopyWrite · spelling
IO WALInitSync IO/WalInitSync · spelling
IO WALInitWrite IO/WalInitWrite · spelling
IO WALRead IO/WalRead · spelling
IO WALSenderTimelineHistoryRead IO/WalsenderTimelineHistoryRead · spelling
IO WALSync IO/WalSync · spelling
IO WALSyncMethodAssign IO/WalSyncMethodAssign · spelling
IO WALWrite IO/WalWrite · spelling
IO WalBootstrapSync
IO WalBootstrapWrite
IO WalCopyRead
IO WalCopySync
IO WalCopyWrite
IO WalInitSync
IO WalInitWrite
IO WalRead
IO WalSummaryRead
IO WalSummaryWrite
IO WalSync
IO WalSyncMethodAssign
IO WalWrite
IO WalsenderTimelineHistoryRead
IPC AppendReady
IPC ArchiveCleanupCommand
IPC ArchiveCommand
IPC BackendTermination
IPC BackupWaitWalArchive
IPC BgWorkerShutdown IPC/BgworkerShutdown · spelling
IPC BgWorkerStartup IPC/BgworkerStartup · spelling
IPC BgworkerShutdown
IPC BgworkerStartup
IPC BtreePage
IPC BufferIO IPC/BufferIo · spelling
IPC BufferIo
IPC CheckpointDelayComplete
IPC CheckpointDelayStart
IPC CheckpointDone
IPC CheckpointStart
IPC ExecuteGather
IPC HashBatchAllocate
IPC HashBatchElect
IPC HashBatchLoad
IPC HashBuildAllocate
IPC HashBuildElect
IPC HashBuildHashInner
IPC HashBuildHashOuter
IPC HashGrowBatchesAllocate IPC/HashGrowBatchesReallocate · rename
IPC HashGrowBatchesDecide
IPC HashGrowBatchesElect
IPC HashGrowBatchesFinish
IPC HashGrowBatchesReallocate
IPC HashGrowBatchesRepartition
IPC HashGrowBucketsAllocate IPC/HashGrowBucketsReallocate · rename
IPC HashGrowBucketsElect
IPC HashGrowBucketsReallocate
IPC HashGrowBucketsReinsert
IPC LogicalApplySendData
IPC LogicalParallelApplyStateChange
IPC LogicalSyncData
IPC LogicalSyncStateChange
IPC MessageQueueInternal
IPC MessageQueuePutMessage
IPC MessageQueueReceive
IPC MessageQueueSend
IPC MultixactCreation
IPC ParallelBitmapScan
IPC ParallelCreateIndexScan
IPC ParallelFinish
IPC ProcArrayGroupUpdate IPC/ProcarrayGroupUpdate · spelling
IPC ProcSignalBarrier
IPC ProcarrayGroupUpdate
IPC Promote
IPC RecoveryConflictSnapshot
IPC RecoveryConflictTablespace
IPC RecoveryEndCommand
IPC RecoveryPause
IPC ReplicationOriginDrop
IPC ReplicationSlotDrop
IPC RestoreCommand
IPC SafeSnapshot
IPC SyncRep
IPC WalReceiverExit
IPC WalReceiverUpstreamCatchup
IPC WalReceiverWaitStart
IPC WalSummaryReady
IPC XactGroupUpdate
Lock advisory
Lock applytransaction
Lock extend
Lock frozenid
Lock object
Lock page
Lock relation
Lock spectoken
Lock transactionid
Lock tuple
Lock userlock
Lock virtualxid
LWLock AddinShmemInit
LWLock AioUringCompletion
LWLock AioWorkerSubmissionQueue
LWLock AutoFile
LWLock Autovacuum
LWLock AutovacuumSchedule
LWLock BackgroundWorker
LWLock BtreeVacuum
LWLock BufferContent
LWLock BufferIO IPC/BufferIo · type_move
LWLock BufferMapping
LWLock Checkpoint
LWLock CheckpointerComm
LWLock CommitTs
LWLock CommitTsBuffer
LWLock CommitTsSLRU
LWLock ControlFile
LWLock DSMRegistry
LWLock DSMRegistryDSA
LWLock DSMRegistryHash
LWLock DynamicSharedMemoryControl
LWLock InjectionPoint
LWLock LockFastPath
LWLock LockManager
LWLock LogicalRepLauncherDSA
LWLock LogicalRepLauncherHash
LWLock LogicalRepWorker
LWLock MultiXactGen
LWLock MultiXactMemberBuffer
LWLock MultiXactMemberSLRU
LWLock MultiXactOffsetBuffer
LWLock MultiXactOffsetSLRU
LWLock MultiXactTruncation
LWLock NotifyBuffer
LWLock NotifyQueue
LWLock NotifyQueueTail
LWLock NotifySLRU
LWLock OidGen
LWLock OldSnapshotTimeMap
LWLock ParallelAppend
LWLock ParallelBtreeScan
LWLock ParallelHashJoin
LWLock ParallelQueryDSA
LWLock ParallelVacuumDSA
LWLock PerSessionDSA
LWLock PerSessionRecordType
LWLock PerSessionRecordTypmod
LWLock PerXactPredicateList
LWLock PgStatsDSA
LWLock PgStatsData
LWLock PgStatsHash
LWLock PredicateLockManager
LWLock ProcArray
LWLock RelCacheInit
LWLock RelationMapping
LWLock ReplicationOrigin
LWLock ReplicationOriginState
LWLock ReplicationSlotAllocation
LWLock ReplicationSlotControl
LWLock ReplicationSlotIO
LWLock SInvalRead
LWLock SInvalWrite
LWLock SerialBuffer
LWLock SerialControl
LWLock SerialSLRU
LWLock SerializableFinishedList
LWLock SerializablePredicateList
LWLock SerializableXactHash
LWLock SharedTidBitmap
LWLock SharedTupleStore
LWLock ShmemIndex
LWLock SubtransBuffer
LWLock SubtransSLRU
LWLock SyncRep
LWLock SyncScan
LWLock TablespaceCreate
LWLock TwoPhaseState
LWLock WALBufMapping
LWLock WALInsert
LWLock WALSummarizer
LWLock WALWrite
LWLock WaitEventCustom
LWLock WrapLimitsVacuum
LWLock XactBuffer
LWLock XactSLRU
LWLock XactTruncation
LWLock XidGen
Timeout BaseBackupThrottle
Timeout CheckpointWriteDelay
Timeout PgSleep
Timeout RecoveryApplyDelay
Timeout RecoveryRetrieveRetryInterval
Timeout RegisterSyncRequest
Timeout SpinDelay
Timeout VacuumDelay
Timeout VacuumTruncate
Timeout WalSummarizerError