WAIT EVENTS / VERSION COMPARISON
What changed?
Wait Events · PostgreSQL 10 → 11
Historical documentation for a PostgreSQL version that is no longer supported.
19 added · 0 removed · 1 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
addedHashBatchAllocate
--- 10 +++ 11 @@ -0,0 +1,2 @@ +IPC/Hash/Batch/Allocating +Waiting for an elected Parallel Hash participant to allocate a hash table.
addedHashBatchElect
--- 10 +++ 11 @@ -0,0 +1,2 @@ +IPC/Hash/Batch/Electing +Electing a Parallel Hash participant to allocate a hash table.
addedHashBatchLoad
--- 10 +++ 11 @@ -0,0 +1,2 @@ +IPC/Hash/Batch/Loading +Waiting for other Parallel Hash participants to finish loading a hash table.
addedHashBuildAllocate
--- 10 +++ 11 @@ -0,0 +1,2 @@ +IPC/Hash/Build/Allocating +Waiting for an elected Parallel Hash participant to allocate the initial hash table.
addedHashBuildElect
--- 10 +++ 11 @@ -0,0 +1,2 @@ +IPC/Hash/Build/Electing +Electing a Parallel Hash participant to allocate the initial hash table.
addedHashBuildHashInner
--- 10 +++ 11 @@ -0,0 +1,2 @@ +IPC/Hash/Build/HashingInner +Waiting for other Parallel Hash participants to finish hashing the inner relation.
addedHashBuildHashOuter
--- 10 +++ 11 @@ -0,0 +1,2 @@ +IPC/Hash/Build/HashingOuter +Waiting for other Parallel Hash participants to finish partitioning the outer relation.
addedHashGrowBatchesDecide
--- 10 +++ 11 @@ -0,0 +1,2 @@ +IPC/Hash/GrowBatches/Deciding +Electing a Parallel Hash participant to decide on future batch growth.
addedHashGrowBatchesElect
--- 10 +++ 11 @@ -0,0 +1,2 @@ +IPC/Hash/GrowBatches/Electing +Electing a Parallel Hash participant to allocate more batches.
addedHashGrowBatchesFinish
--- 10 +++ 11 @@ -0,0 +1,2 @@ +IPC/Hash/GrowBatches/Finishing +Waiting for an elected Parallel Hash participant to decide on future batch growth.
addedHashGrowBatchesReallocate
--- 10 +++ 11 @@ -0,0 +1,2 @@ +IPC/Hash/GrowBatches/Allocating +Waiting for an elected Parallel Hash participant to allocate more batches.
addedHashGrowBatchesRepartition
--- 10 +++ 11 @@ -0,0 +1,2 @@ +IPC/Hash/GrowBatches/Repartitioning +Waiting for other Parallel Hash participants to finishing repartitioning.
addedHashGrowBucketsElect
--- 10 +++ 11 @@ -0,0 +1,2 @@ +IPC/Hash/GrowBuckets/Electing +Electing a Parallel Hash participant to allocate more buckets.
addedHashGrowBucketsReallocate
--- 10 +++ 11 @@ -0,0 +1,2 @@ +IPC/Hash/GrowBuckets/Allocating +Waiting for an elected Parallel Hash participant to finish allocating more buckets.
addedHashGrowBucketsReinsert
--- 10 +++ 11 @@ -0,0 +1,2 @@ +IPC/Hash/GrowBuckets/Reinserting +Waiting for other Parallel Hash participants to finish inserting tuples into new buckets.
addedParallelCreateIndexScan
--- 10 +++ 11 @@ -0,0 +1,2 @@ +IPC/ParallelCreateIndexScan +Waiting for parallel CREATE INDEX workers to finish heap scan.
addedXactGroupUpdate
--- 10 +++ 11 @@ -0,0 +1,2 @@ +IPC/ClogGroupUpdate +Waiting for group leader to update transaction status at transaction end.
addedParallelAppend
--- 10 +++ 11 @@ -0,0 +1,2 @@ +LWLock/parallel_append +Waiting to choose the next subplan during Parallel Append plan execution.
addedParallelHashJoin
--- 10 +++ 11 @@ -0,0 +1,2 @@ +LWLock/parallel_hash_join +Waiting to allocate or exchange a chunk of memory or update counters during Parallel Hash plan execution.
changedSerialBuffer
--- 10 +++ 11 @@ -1,2 +1,2 @@ LWLock/oldserxid -Waiting to I/O on an oldserxid buffer. +Waiting for I/O on an oldserxid buffer.