SELECT blocked_locks.*, blocking_locks.*, blocked_activity.*, blocking_activity.* FROM pg_locks blocked_locks JOIN pg_stat_activity blocked_activity ON blocked_activity.pid = blocked_locks.pid JOIN pg_locks blocking_locks ON blocking_locks.locktype = blocked_locks.locktype AND blocking_locks.database IS NOT DISTINCT FROM blocked_locks.database AND blocking_locks.relation IS NOT DISTINCT FROM blocked_locks.relation AND blocking_locks.page IS NOT DISTINCT FROM blocked_locks.page AND blocking_locks.tuple IS NOT DISTINCT FROM blocked_locks.tuple AND blocking_locks.virtualxid IS NOT DISTINCT FROM blocked_locks.virtualxid AND blocking_locks.transactionid IS NOT DISTINCT FROM blocked_locks.transactionid AND blocking_locks.classid IS NOT DISTINCT FROM blocked_locks.classid AND blocking_locks.objid IS NOT DISTINCT FROM blocked_locks.objid AND blocking_locks.objsubid IS NOT DISTINCT FROM blocked_locks.objsubid AND blocking_locks.pid IS DISTINCT FROM blocked_locks.pid JOIN pg_stat_activity blocking_activity ON blocking_activity.pid = blocking_locks.pid WHERE NOT blocked_locks.granted \watch 1 Mon 11 Aug 2025 01:58:45 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+------------------+-------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:44.821141+01 | Activity | LogicalApplyMain | idle | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:58:46 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | | | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:58:47 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+----------------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | IPC | LogicalApplySendData | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:58:48 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+----------------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | IPC | LogicalApplySendData | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:58:49 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+----------------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | IPC | LogicalApplySendData | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:58:50 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+----------------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | IPC | LogicalApplySendData | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:58:51 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | | | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:58:52 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+----------------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | IPC | LogicalApplySendData | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:58:53 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+----------------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | IPC | LogicalApplySendData | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:58:54 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+----------------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | IPC | LogicalApplySendData | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:58:55 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+----------------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | IPC | LogicalApplySendData | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:58:56 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+----------------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | IPC | LogicalApplySendData | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:58:57 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+----------------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | IPC | LogicalApplySendData | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:58:58 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+----------------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | IPC | LogicalApplySendData | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:58:59 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+----------------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | IPC | LogicalApplySendData | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:59:00 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+----------------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | IPC | LogicalApplySendData | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:59:01 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+----------------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | IPC | LogicalApplySendData | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:59:02 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+----------------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | IPC | LogicalApplySendData | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:59:03 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+----------------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | IPC | LogicalApplySendData | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:59:04 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+----------------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | IPC | LogicalApplySendData | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:59:05 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+----------------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | IPC | LogicalApplySendData | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:59:06 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+----------------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | IPC | LogicalApplySendData | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:59:07 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+----------------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | IPC | LogicalApplySendData | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:59:08 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------+-------------+-------------------------------+-----------------+----------------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:58:45.569176+01 | IPC | LogicalApplySendData | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:59:09 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/6805 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | 2025-08-11 01:59:08.738109+01 | | 2025-08-11 01:58:45.569176+01 | | | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:59:10 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/6805 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | 2025-08-11 01:59:08.738109+01 | | 2025-08-11 01:58:45.569176+01 | | | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:59:11 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/6805 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | 2025-08-11 01:59:08.738109+01 | | 2025-08-11 01:58:45.569176+01 | | | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:59:12 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/6805 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | 2025-08-11 01:59:08.738109+01 | | 2025-08-11 01:58:45.569176+01 | | | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:59:13 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+---------------------------------- applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/6805 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | 2025-08-11 01:59:08.738109+01 | | 2025-08-11 01:58:45.569176+01 | Activity | LogicalApplyMain | active | | | | | logical replication apply worker (1 row) Mon 11 Aug 2025 01:59:14 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:58:45.570852+01 | IO | WalSync | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:15 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:58:45.570852+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:16 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:58:45.570852+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:17 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:58:45.570852+01 | LWLock | WALWrite | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:18 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:58:45.570852+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:19 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:58:45.570852+01 | IO | WalWrite | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:20 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:58:45.570852+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:21 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:58:45.570852+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:22 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:58:45.570852+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:23 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:58:45.570852+01 | IO | WalSync | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:24 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:58:45.570852+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:25 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:58:45.570852+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:26 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:58:45.570852+01 | LWLock | WALWrite | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:27 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:58:45.570852+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:28 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:58:45.570852+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:29 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:58:45.570852+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:30 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:59:29.478742+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:31 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:59:29.478742+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:32 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:59:29.478742+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:33 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:59:29.478742+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:34 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:59:29.478742+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:35 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:59:29.478742+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:36 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:59:29.478742+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:37 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:59:29.478742+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:38 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:59:29.478742+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:39 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:59:29.478742+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:40 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:59:29.478742+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:41 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:59:29.478742+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:42 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:59:29.478742+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:43 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+-----------------+---------+----------+-------------------------------+------------------+----------+----------+------+-------+------------+---------------+---------+------------+----------+--------------------+---------+---------------------+---------+----------+-----------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+-------------------------------------+-------+------------------+---------+------------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------------+-------------+-------------------------------+-----------------+------------------+--------+-------------+--------------+----------+-------+------------------------------------- applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1026/0 | 2857187 | AccessShareLock | f | f | 2025-08-11 01:59:13.773033+01 | applytransaction | 16423 | | | | | 295096568 | | 2237467148 | 1 | 1030/17288 | 2861846 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker | 16423 | xxxxxxxxxxxxxxxx | 2861846 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:58:45.568735+01 | 2025-08-11 01:58:45.57086+01 | | 2025-08-11 01:59:29.478742+01 | | | active | 274447366 | 274447365 | | | logical replication parallel worker applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1036/16951 | 2857523 | AccessShareLock | f | f | 2025-08-11 01:58:45.346485+01 | applytransaction | 16423 | | | | | 295087899 | | 2237467148 | 0 | 1026/0 | 2857187 | AccessExclusiveLock | t | f | | 16423 | xxxxxxxxxxxxxxxx | 2857523 | 2857187 | 10 | postgres | | | | | 2025-08-11 01:48:10.211841+01 | 2025-08-11 01:48:10.213933+01 | | 2025-08-11 01:48:10.213925+01 | Lock | applytransaction | active | 274447365 | | | | logical replication parallel worker | 16423 | xxxxxxxxxxxxxxxx | 2857187 | | 10 | postgres | | | | | 2025-08-11 01:46:36.037042+01 | | | 2025-08-11 01:59:13.734909+01 | Lock | applytransaction | idle | | | | | logical replication apply worker (2 rows) Mon 11 Aug 2025 01:59:44 BST (every 1s) locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type | datid | datname | pid | leader_pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query_id | query | backend_type ----------+----------+----------+------+-------+------------+---------------+---------+-------+----------+--------------------+-----+------+---------+----------+-----------+----------+----------+----------+------+-------+------------+---------------+---------+-------+----------+--------------------+-----+------+---------+----------+-----------+-------+---------+-----+------------+----------+---------+------------------+-------------+-----------------+-------------+---------------+------------+-------------+--------------+-----------------+------------+-------+-------------+--------------+----------+-------+--------------+-------+---------+-----+------------+----------+---------+------------------+-------------+-----------------+-------------+---------------+------------+-------------+--------------+-----------------+------------+-------+-------------+--------------+----------+-------+-------------- (0 rows)