## advisory ### Description Waiting to acquire an advisory user lock. ### OS Resources Consumed - CPU threads, memory ## applytransaction ### Description Waiting to acquire a lock on a remote transaction being applied by a logical replication subscriber. ### OS Resources Consumed - CPU threads, network ## extend ### Description Waiting to extend a relation. ### OS Resources Consumed - Disk I/O, CPU threads ## frozenid ### Description Waiting to update pg_database.datfrozenxid and pg_database.datminmxid. ### OS Resources Consumed - CPU threads, memory ## object ### Description Waiting to acquire a lock on a non-relation database object. ### OS Resources Consumed - CPU threads, memory ## page ### Description Waiting to acquire a lock on a page of a relation. ### OS Resources Consumed - CPU threads, memory ## relation ### Description Waiting to acquire a lock on a relation. ### OS Resources Consumed - CPU threads, memory ## spectoken ### Description Waiting to acquire a speculative insertion lock. ### OS Resources Consumed - CPU threads, memory ## transactionid ### Description Waiting for a transaction to finish. ### OS Resources Consumed - CPU threads, memory ## tuple ### Description Waiting to acquire a lock on a tuple. ### OS Resources Consumed - CPU threads, memory ## userlock ### Description Waiting to acquire a user lock. ### OS Resources Consumed - CPU threads, memory ## virtualxid ### Description Waiting to acquire a virtual transaction ID lock. ### OS Resources Consumed - CPU threads, memory