pg_locks_query_results.txt
text/plain
Filename: pg_locks_query_results.txt
Type: text/plain
Part: 0
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)