pg_stat_local_bk_j4.txt

text/plain

Filename: pg_stat_local_bk_j4.txt
Type: text/plain
Part: 0
Message: Re: WIP/PoC for parallel backup
  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 | IO              | BaseBackupRead      | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:47:32 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:47:35 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:47:38 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 | IO              | BaseBackupRead      | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:47:41 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 | IO              | BaseBackupRead      | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 | IO              | BaseBackupRead      | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:47:44 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:47:47 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 | IO              | BaseBackupRead      | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:47:50 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:47:53 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:47:56 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:47:59 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 | IO              | BaseBackupRead      | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:48:02 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:48:05 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 | IO              | BaseBackupRead      | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:48:08 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:48:11 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:48:14 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 | IO              | BaseBackupRead      | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 | IO              | BaseBackupRead      | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:48:17 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 | IO              | BaseBackupRead      | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:48:20 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:48:23 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:48:26 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:48:29 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:48:32 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:48:35 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 | IO              | BaseBackupRead      | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:48:38 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 | IO              | BaseBackupRead      | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterMain        |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:48:41 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterHibernate   |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:48:44 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 | IO              | BaseBackupRead      | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterHibernate   |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:48:47 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterHibernate   |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:48:50 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 | IO              | BaseBackupRead      | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterHibernate   |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:48:53 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108943 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108945 | suraj.kharage | pg_basebackup    |                 | Client          | ClientWrite         | active |       | walsender
 108947 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108949 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterHibernate   |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(10 rows)

                                                     Fri 22 May 2020 05:48:56 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state  | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+--------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |        |       | logical replication launcher
 108939 | suraj.kharage | pg_basebackup    |                 | Client          | ClientRead          | idle   |       | walsender
 108941 | suraj.kharage | pg_basebackup    |                 |                 |                     | active |       | walsender
 108910 |               |                  |                 | Activity        | BgWriterHibernate   |        |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |        |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |        |       | walwriter
(6 rows)

                                                     Fri 22 May 2020 05:48:59 AM BST (every 3s)

  pid   |    usename    | application_name | client_hostname | wait_event_type |     wait_event      | state | query |         backend_type         
--------+---------------+------------------+-----------------+-----------------+---------------------+-------+-------+------------------------------
 108914 | suraj.kharage |                  |                 | Activity        | LogicalLauncherMain |       |       | logical replication launcher
 108910 |               |                  |                 | Activity        | BgWriterHibernate   |       |       | background writer
 108909 |               |                  |                 | Activity        | CheckpointerMain    |       |       | checkpointer
 108911 |               |                  |                 | Activity        | WalWriterMain       |       |       | walwriter
(4 rows)