## AppendReady ### Description Waiting for subplan nodes of an Append plan node to be ready. ### OS Resources Consumed - CPU threads, memory ## ArchiveCleanupCommand ### Description Waiting for archive_cleanup_command to complete. ### OS Resources Consumed - Disk I/O, CPU threads ## ArchiveCommand ### Description Waiting for archive_command to complete. ### OS Resources Consumed - Disk I/O, CPU threads ## BackendTermination ### Description Waiting for the termination of another backend. ### OS Resources Consumed - CPU threads, memory ## BackupWaitWalArchive ### Description Waiting for WAL files required for a backup to be successfully archived. ### OS Resources Consumed - Disk I/O, CPU threads ## BgWorkerShutdown ### Description Waiting for background worker to shut down. ### OS Resources Consumed - CPU threads, memory ## BgWorkerStartup ### Description Waiting for background worker to start up. ### OS Resources Consumed - CPU threads, memory ## BtreePage ### Description Waiting for the page number needed to continue a parallel B-tree scan to become available. ### OS Resources Consumed - CPU threads, memory ## BufferIO ### Description Waiting for buffer I/O to complete. ### OS Resources Consumed - Disk I/O, CPU threads ## CheckpointDone ### Description Waiting for a checkpoint to complete. ### OS Resources Consumed - CPU threads, disk I/O ## CheckpointStart ### Description Waiting for a checkpoint to start. ### OS Resources Consumed - CPU threads, disk I/O ## ExecuteGather ### Description Waiting for activity from a child process while executing a Gather plan node. ### OS Resources Consumed - CPU threads, memory ## HashBatchAllocate ### Description Waiting for an elected Parallel Hash participant to allocate a hash table. ### OS Resources Consumed - CPU threads, memory ## HashBatchElect ### Description Waiting to elect a Parallel Hash participant to allocate a hash table. ### OS Resources Consumed - CPU threads, memory ## HashBatchLoad ### Description Waiting for other Parallel Hash participants to finish loading a hash table. ### OS Resources Consumed - CPU threads, memory ## HashBuildAllocate ### Description Waiting for an elected Parallel Hash participant to allocate the initial hash table. ### OS Resources Consumed - CPU threads, memory ## HashBuildElect ### Description Waiting to elect a Parallel Hash participant to allocate the initial hash table. ### OS Resources Consumed - CPU threads, memory ## HashBuildHashInner ### Description Waiting for other Parallel Hash participants to finish hashing the inner relation. ### OS Resources Consumed - CPU threads, memory ## HashBuildHashOuter ### Description Waiting for other Parallel Hash participants to finish partitioning the outer relation. ### OS Resources Consumed - CPU threads, memory ## HashGrowBatchesDecide ### Description Waiting to elect a Parallel Hash participant to decide on future batch growth. ### OS Resources Consumed - CPU threads, memory ## HashGrowBatchesElect ### Description Waiting to elect a Parallel Hash participant to allocate more batches. ### OS Resources Consumed - CPU threads, memory ## HashGrowBatchesFinish ### Description Waiting for an elected Parallel Hash participant to decide on future batch growth. ### OS Resources Consumed - CPU threads, memory ## HashGrowBatchesReallocate ### Description Waiting for an elected Parallel Hash participant to allocate more batches. ### OS Resources Consumed - CPU threads, memory ## HashGrowBatchesRepartition ### Description Waiting for other Parallel Hash participants to finish repartitioning. ### OS Resources Consumed - CPU threads, memory ## HashGrowBucketsElect ### Description Waiting to elect a Parallel Hash participant to allocate more buckets. ### OS Resources Consumed - CPU threads, memory ## HashGrowBucketsReallocate ### Description Waiting for an elected Parallel Hash participant to finish allocating more buckets. ### OS Resources Consumed - CPU threads, memory ## HashGrowBucketsReinsert ### Description Waiting for other Parallel Hash participants to finish inserting tuples into new buckets. ### OS Resources Consumed - CPU threads, memory ## LogicalApplySendData ### Description Waiting for a logical replication leader apply process to send data to a parallel apply process. ### OS Resources Consumed - CPU threads, network ## LogicalParallelApplyStateChange ### Description Waiting for a logical replication parallel apply process to change state. ### OS Resources Consumed - CPU threads, memory ## LogicalSyncData ### Description Waiting for a logical replication remote server to send data for initial table synchronization. ### OS Resources Consumed - CPU threads, network ## LogicalSyncStateChange ### Description Waiting for a logical replication remote server to change state. ### OS Resources Consumed - CPU threads, network ## MessageQueueInternal ### Description Waiting for another process to be attached to a shared message queue. ### OS Resources Consumed - CPU threads, memory ## MessageQueuePutMessage ### Description Waiting to write a protocol message to a shared message queue. ### OS Resources Consumed - CPU threads, memory ## MessageQueueReceive ### Description Waiting to receive bytes from a shared message queue. ### OS Resources Consumed - CPU threads, memory ## MessageQueueSend ### Description Waiting to send bytes to a shared message queue. ### OS Resources Consumed - CPU threads, memory ## ParallelBitmapScan ### Description Waiting for parallel bitmap scan to become initialized. ### OS Resources Consumed - CPU threads, memory ## ParallelCreateIndexScan ### Description Waiting for parallel CREATE INDEX workers to finish heap scan. ### OS Resources Consumed - CPU threads, memory ## ParallelFinish ### Description Waiting for parallel workers to finish computing. ### OS Resources Consumed - CPU threads, memory ## ProcArrayGroupUpdate ### Description Waiting for the group leader to clear the transaction ID at end of a parallel operation. ### OS Resources Consumed - CPU threads, memory ## ProcSignalBarrier ### Description Waiting for a barrier event to be processed by all backends. ### OS Resources Consumed - CPU threads, memory ## Promote ### Description Waiting for standby promotion. ### OS Resources Consumed - CPU threads ## RecoveryConflictSnapshot ### Description Waiting for recovery conflict resolution for a vacuum cleanup. ### OS Resources Consumed - CPU threads, memory ## RecoveryConflictTablespace ### Description Waiting for recovery conflict resolution for dropping a tablespace. ### OS Resources Consumed - CPU threads, memory ## RecoveryEndCommand ### Description Waiting for recovery_end_command to complete. ### OS Resources Consumed - CPU threads, disk I/O ## RecoveryPause ### Description Waiting for recovery to be resumed. ### OS Resources Consumed - CPU threads ## ReplicationOriginDrop ### Description Waiting for a replication origin to become inactive so it can be dropped. ### OS Resources Consumed - CPU threads, disk I/O ## ReplicationSlotDrop ### Description Waiting for a replication slot to become inactive so it can be dropped. ### OS Resources Consumed - CPU threads, disk I/O ## RestoreCommand ### Description Waiting for restore_command to complete. ### OS Resources Consumed - CPU threads, disk I/O ## SafeSnapshot ### Description Waiting to obtain a valid snapshot for a READ ONLY DEFERRABLE transaction. ### OS Resources Consumed - CPU threads, memory ## SyncRep ### Description Waiting for confirmation from a remote server during synchronous replication. ### OS Resources Consumed - CPU threads, network ## WalReceiverExit ### Description Waiting for the WAL receiver to exit. ### OS Resources Consumed - CPU threads ## WalReceiverWaitStart ### Description Waiting for startup process to send initial data for streaming replication. ### OS Resources Consumed - CPU threads, network ## XactGroupUpdate ### Description Waiting for the group leader to update transaction status at end of a parallel operation. ### OS Resources Consumed - CPU threads, memory