## AddinShmemInit ### Description Waiting to manage an extension's space allocation in shared memory. ### OS Resources Consumed - Memory, CPU threads ## AutoFile ### Description Waiting to update the postgresql.auto.conf file. ### OS Resources Consumed - Disk I/O, CPU threads ## Autovacuum ### Description Waiting to read or update the current state of autovacuum workers. ### OS Resources Consumed - CPU threads, memory ## AutovacuumSchedule ### Description Waiting to ensure that a table selected for autovacuum still needs vacuuming. ### OS Resources Consumed - CPU threads, memory ## BackgroundWorker ### Description Waiting to read or update background worker state. ### OS Resources Consumed - CPU threads, memory ## BtreeVacuum ### Description Waiting to read or update vacuum-related information for a B-tree index. ### OS Resources Consumed - CPU threads, memory ## BufferContent ### Description Waiting to access a data page in memory. ### OS Resources Consumed - Memory, CPU threads ## BufferMapping ### Description Waiting to associate a data block with a buffer in the buffer pool. ### OS Resources Consumed - Memory, CPU threads ## CheckpointerComm ### Description Waiting to manage fsync requests. ### OS Resources Consumed - Disk I/O, CPU threads ## CommitTs ### Description Waiting to read or update the last value set for a transaction commit timestamp. ### OS Resources Consumed - Memory, CPU threads ## CommitTsBuffer ### Description Waiting for I/O on a commit timestamp SLRU buffer. ### OS Resources Consumed - Disk I/O, CPU threads ## CommitTsSLRU ### Description Waiting to access the commit timestamp SLRU cache. ### OS Resources Consumed - Memory, CPU threads ## ControlFile ### Description Waiting to read or update the pg_control file or create a new WAL file. ### OS Resources Consumed - Disk I/O, CPU threads ## DynamicSharedMemoryControl ### Description Waiting to read or update dynamic shared memory allocation information. ### OS Resources Consumed - Memory, CPU threads ## LockFastPath ### Description Waiting to read or update a process' fast-path lock information. ### OS Resources Consumed - Memory, CPU threads ## LockManager ### Description Waiting to read or update information about “heavyweight” locks. ### OS Resources Consumed - Memory, CPU threads ## LogicalRepLauncherDSA ### Description Waiting to access logical replication launcher's dynamic shared memory allocator. ### OS Resources Consumed - Memory, CPU threads ## LogicalRepLauncherHash ### Description Waiting to access logical replication launcher's shared hash table. ### OS Resources Consumed - Memory, CPU threads ## LogicalRepWorker ### Description Waiting to read or update the state of logical replication workers. ### OS Resources Consumed - Memory, CPU threads ## MultiXactGen ### Description Waiting to read or update shared multixact state. ### OS Resources Consumed - Memory, CPU threads ## MultiXactMemberBuffer ### Description Waiting for I/O on a multixact member SLRU buffer. ### OS Resources Consumed - Disk I/O, CPU threads ## MultiXactMemberSLRU ### Description Waiting to access the multixact member SLRU cache. ### OS Resources Consumed - Memory, CPU threads ## MultiXactOffsetBuffer ### Description Waiting for I/O on a multixact offset SLRU buffer. ### OS Resources Consumed - Disk I/O, CPU threads ## MultiXactOffsetSLRU ### Description Waiting to access the multixact offset SLRU cache. ### OS Resources Consumed - Memory, CPU threads ## MultiXactTruncation ### Description Waiting to read or truncate multixact information. ### OS Resources Consumed - Disk I/O, CPU threads ## NotifyBuffer ### Description Waiting for I/O on a NOTIFY message SLRU buffer. ### OS Resources Consumed - Disk I/O, CPU threads ## NotifyQueue ### Description Waiting to read or update NOTIFY messages. ### OS Resources Consumed - Memory, CPU threads ## NotifyQueueTail ### Description Waiting to update limit on NOTIFY message storage. ### OS Resources Consumed - Memory, CPU threads ## NotifySLRU ### Description Waiting to access the NOTIFY message SLRU cache. ### OS Resources Consumed - Memory, CPU threads ## OidGen ### Description Waiting to allocate a new OID. ### OS Resources Consumed - Memory, CPU threads ## OldSnapshotTimeMap ### Description Waiting to read or update old snapshot control information. ### OS Resources Consumed - Memory, CPU threads ## ParallelAppend ### Description Waiting to choose the next subplan during Parallel Append plan execution. ### OS Resources Consumed - Memory, CPU threads ## ParallelHashJoin ### Description Waiting to synchronize workers during Parallel Hash Join plan execution. ### OS Resources Consumed - Memory, CPU threads ## ParallelQueryDSA ### Description Waiting for parallel query dynamic shared memory allocation. ### OS Resources Consumed - Memory, CPU threads ## PerSessionDSA ### Description Waiting for parallel query dynamic shared memory allocation. ### OS Resources Consumed - Memory, CPU threads ## PerSessionRecordType ### Description Waiting to access a parallel query's information about composite types. ### OS Resources Consumed - Memory, CPU threads ## PerSessionRecordTypmod ### Description Waiting to access a parallel query's information about type modifiers that identify anonymous record types. ### OS Resources Consumed - Memory, CPU threads ## PerXactPredicateList ### Description Waiting to access the list of predicate locks held by the current serializable transaction during a parallel query. ### OS Resources Consumed - Memory, CPU threads ## PgStatsData ### Description Waiting for shared memory stats data access. ### OS Resources Consumed - Memory, CPU threads ## PgStatsDSA ### Description Waiting for stats dynamic shared memory allocator access. ### OS Resources Consumed - Memory, CPU threads ## PgStatsHash ### Description Waiting for stats shared memory hash table access. ### OS Resources Consumed - Memory, CPU threads ## PredicateLockManager ### Description Waiting to access predicate lock information used by serializable transactions. ### OS Resources Consumed - Memory, CPU threads ## ProcArray ### Description Waiting to access the shared per-process data structures (typically, to get a snapshot or report a session's transaction ID). ### OS Resources Consumed - Memory, CPU threads ## RelationMapping ### Description Waiting to read or update a pg_filenode.map file (used to track the filenode assignments of certain system catalogs). ### OS Resources Consumed - Disk I/O, CPU threads ## RelCacheInit ### Description Waiting to read or update a pg_internal.init relation cache initialization file. ### OS Resources Consumed - Disk I/O, CPU threads ## ReplicationOrigin ### Description Waiting to create, drop, or use a replication origin. ### OS Resources Consumed - Memory, CPU threads ## ReplicationOriginState ### Description Waiting to read or update the progress of one replication origin. ### OS Resources Consumed - Memory, CPU threads ## ReplicationSlotAllocation ### Description Waiting to allocate or free a replication slot. ### OS Resources Consumed - Memory, CPU threads ## ReplicationSlotControl ### Description Waiting to read or update replication slot state. ### OS Resources Consumed - Memory, CPU threads ## ReplicationSlotIO ### Description Waiting for I/O on a replication slot. ### OS Resources Consumed - Disk I/O, CPU threads ## SerialBuffer ### Description Waiting for I/O on a serializable transaction conflict SLRU buffer. ### OS Resources Consumed - Disk I/O, CPU threads ## SerializableFinishedList ### Description Waiting to access the list of finished serializable transactions. ### OS Resources Consumed - Memory, CPU threads ## SerializablePredicateList ### Description Waiting to access the list of predicate locks held by serializable transactions. ### OS Resources Consumed - Memory, CPU threads ## SerializableXactHash ### Description Waiting to read or update information about serializable transactions. ### OS Resources Consumed - Memory, CPU threads ## SerialSLRU ### Description Waiting to access the serializable transaction conflict SLRU cache. ### OS Resources Consumed - Memory, CPU threads ## SharedTidBitmap ### Description Waiting to access a shared TID bitmap during a parallel bitmap index scan. ### OS Resources Consumed - Memory, CPU threads ## SharedTupleStore ### Description Waiting to access a shared tuple store during parallel query. ### OS Resources Consumed - Memory, CPU threads ## ShmemIndex ### Description Waiting to find or allocate space in shared memory. ### OS Resources Consumed - Memory, CPU threads ## SInvalRead ### Description Waiting to retrieve messages from the shared catalog invalidation queue. ### OS Resources Consumed - Memory, CPU threads ## SInvalWrite ### Description Waiting to add a message to the shared catalog invalidation queue. ### OS Resources Consumed - Memory, CPU threads ## SubtransBuffer ### Description Waiting for I/O on a sub-transaction SLRU buffer. ### OS Resources Consumed - Disk I/O, CPU threads ## SubtransSLRU ### Description Waiting to access the sub-transaction SLRU cache. ### OS Resources Consumed - Memory, CPU threads ## SyncRep ### Description Waiting to read or update information about the state of synchronous replication. ### OS Resources Consumed - Memory, CPU threads ## SyncScan ### Description Waiting to select the starting location of a synchronized table scan. ### OS Resources Consumed - Memory, CPU threads ## TablespaceCreate ### Description Waiting to create or drop a tablespace. ### OS Resources Consumed - Disk I/O, CPU threads ## TwoPhaseState ### Description Waiting to read or update the state of prepared transactions. ### OS Resources Consumed - Memory, CPU threads ## WALBufMapping ### Description Waiting to replace a page in WAL buffers. ### OS Resources Consumed - Disk I/O, CPU threads ## WALInsert ### Description Waiting to insert WAL data into a memory buffer. ### OS Resources Consumed - Memory, CPU threads ## WALWrite ### Description Waiting for WAL buffers to be written to disk. ### OS Resources Consumed - Disk I/O, CPU threads ## WrapLimitsVacuum ### Description Waiting to update limits on transaction ID and multixact consumption. ### OS Resources Consumed - Memory, CPU threads ## XactBuffer ### Description Waiting for I/O on a transaction status SLRU buffer. ### OS Resources Consumed - Disk I/O, CPU threads ## XactSLRU ### Description Waiting to access the transaction status SLRU cache. ### OS Resources Consumed - Memory, CPU threads ## XactTruncation ### Description Waiting to execute pg_xact_status or update the oldest transaction ID available to it. ### OS Resources Consumed - Disk I/O, CPU threads ## XidGen ### Description Waiting to allocate a new transaction ID. ### OS Resources Consumed - Memory, CPU threads