View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000676 | Pgpool-II | General | public | 2020-12-23 00:06 | 2021-01-06 17:00 |
| Reporter | Ken | Assigned To | t-ishii | ||
| Priority | normal | Severity | major | Reproducibility | random |
| Status | feedback | Resolution | open | ||
| Product Version | 4.1.5 | ||||
| Summary | 0000676: ERROR: unable to flush data to frontend | ||||
| Description | Hello I use postgres 11 and pgpool in version 4.1.5. After configuration pgpool and durning test all good work, i don't saw error in log pgpool. But when all programs and clients begin connect to pgpool I note error in log pgpool "ERROR: unable to flush data to frontend". What is this and why this appear in my log? I note that sometimes during connecting to postgres by virtual IP connect is long time. Connection continues even 10 - 15 second Why do connection continues long time? | ||||
| Tags | No tags attached. | ||||
|
|
additional i have in log too infromation: DETAIL: socket read failed with an error "Connection reset by peer" All look this: Dec 22 16:02:10 QSDB01SV pgpool[44767]: [2428-1] 2020-12-22 16:02:10: pid 44767: ERROR: unable to read data from frontend Dec 22 16:02:10 QSDB01SV pgpool[44767]: [2428-2] 2020-12-22 16:02:10: pid 44767: DETAIL: socket read failed with an error "Connection reset by peer" If you need whole log, let me know |
|
|
> What is this and why this appear in my log? Pgpool-II failed to send message to frontend (client). This means either 1) the client already disappeared (exited) before the client tells Pgpoo-II that the client exits, or 2) there's something wrong with the network between frontend and Pgpool-II. In any case the cause of the issue is not Pgpool-II. You should check that the frontend properly disconnects to Pgpool-II. Or check the network configuration. > I note that sometimes during connecting to postgres by virtual IP connect is long time. Connection continues even 10 - 15 second > Why do connection continues long time? Don't know. I am not familiar with the configuration that VIP is assigned to postgres. |
|
|
> Dec 22 16:02:10 QSDB01SV pgpool[44767]: [2428-1] 2020-12-22 16:02:10: pid 44767: ERROR: unable to read data from frontend > Dec 22 16:02:10 QSDB01SV pgpool[44767]: [2428-2] 2020-12-22 16:02:10: pid 44767: DETAIL: socket read failed with an error "Connection reset by peer" It seems you have a network problem between frontend and Pgpool-II. |
|
|
thank you for information. I writing "connecting to postgres by virtual IP", i had mean connectiong to postgres by pgpool and in pgpool is configured virtual IP. |
|
|
> I writing "connecting to postgres by virtual IP", i had mean connectiong to postgres by pgpool and in pgpool is configured virtual IP. Ok, then. So if you connect to Pgpool-II with physical IP (not VIP), then the problem goes away? |
|
|
Now is ok, I noted that this problem occur when connection pool was end. I change parameters max_pool and init_num_connection and work. Sometimes this error occur in my log but very rarely Thank you for help |
|
|
Thank you for the report. > noted that this problem occur when connection pool was end. I change parameters max_pool and init_num_connection and work. You mean "init_num_connection" is actually "num_init_children"? |
|
|
Yes, i had mean about num_init_children. Sorry my mistake |
|
|
I note that increase num_init_children don't help because all connection pool after time is again exhausted. When I starting service which generate query with COPY I see that connection pool is exhausted. Additional I note that pgpool don't delete connection which is in idle status after copy status My configuration connection pool looked this: num_init_children = 150 # Number of concurrent sessions allowed # (change requires restart) max_pool = 4 # Number of connection pool caches per connection # (change requires restart) # - Life time - child_life_time = 300 # Pool exits after being idle for this many seconds child_max_connections = 4 # Pool exits after receiving that many connections # 0 means no exit connection_life_time = 5 # Connection to backend closes after being idle for this many seconds # 0 means no close client_idle_limit = 30 # Client is disconnected after being idle for that many seconds # (even inside an explicit transactions!) # 0 means no disconnection result with show pool_processes in attachement file name pool_processes and command ps -aux in attachement file name psaux pool_processes.txt (14,055 bytes)
postgres=# show pool_processes; pool_pid | start_time | database | username | create_time | pool_counter ----------+---------------------+----------+---------------------+---------------------+-------------- 1209700 | 2020-12-30 14:52:29 | QLogs | qlogs_writer | 2020-12-30 14:53:43 | 1 1211389 | 2020-12-30 15:08:56 | QLogs | qlogs_writer | 2020-12-30 15:12:57 | 1 1188232 | 2020-12-30 11:29:01 | QLogs | qlogs_writer | 2020-12-30 15:20:57 | 1 1211926 | 2020-12-30 15:14:39 | QLogs | qlogs_writer | 2020-12-30 15:21:57 | 1 1212251 | 2020-12-30 15:18:05 | QLogs | qlogs_writer | 2020-12-30 15:23:57 | 1 1202019 | 2020-12-30 13:39:29 | QLogs | qlogs_writer | 2020-12-30 14:43:55 | 1 1208690 | 2020-12-30 14:42:58 | QLogs | qlogs_writer | 2020-12-30 14:55:56 | 1 1207663 | 2020-12-30 14:33:35 | QLogs | qlogs_writer | 2020-12-30 14:34:55 | 1 1209445 | 2020-12-30 14:50:44 | QLogs | qlogs_writer | 2020-12-30 15:07:44 | 1 1209428 | 2020-12-30 14:50:32 | QLogs | qlogs_writer | 2020-12-30 15:15:45 | 1 1205846 | 2020-12-30 14:16:28 | QLogs | qlogs_writer | 2020-12-30 15:19:45 | 1 1210718 | 2020-12-30 15:02:54 | QLogs | qlogs_writer | 2020-12-30 15:10:57 | 1 1201637 | 2020-12-30 13:36:30 | QLogs | qlogs_writer | 2020-12-30 14:33:42 | 1 1209893 | 2020-12-30 14:54:29 | QLogs | qlogs_writer | 2020-12-30 15:00:56 | 1 1209533 | 2020-12-30 14:51:40 | QLogs | qlogs_writer | 2020-12-30 14:51:43 | 1 1188249 | 2020-12-30 11:29:01 | QLogs | qlogs_writer | 2020-12-30 15:13:45 | 1 1207508 | 2020-12-30 14:32:02 | QLogs | qlogs_writer | 2020-12-30 14:44:55 | 1 1207777 | 2020-12-30 14:34:43 | QLogs | qlogs_writer | 2020-12-30 14:35:42 | 1 1212029 | 2020-12-30 15:15:43 | QLogs | qlogs_writer | 2020-12-30 15:31:58 | 1 1208958 | 2020-12-30 14:45:44 | QLogs | qlogs_writer | 2020-12-30 14:46:55 | 1 1208395 | 2020-12-30 14:40:01 | QLogs | qlogs_writer | 2020-12-30 14:45:43 | 1 1207823 | 2020-12-30 14:35:11 | QLogs | qlogs_writer | 2020-12-30 14:45:55 | 1 1209942 | 2020-12-30 14:55:00 | QLogs | qlogs_writer | 2020-12-30 15:09:57 | 1 1210725 | 2020-12-30 15:02:55 | QSR | qliksenserepository | 2020-12-30 15:34:40 | 1 1207880 | 2020-12-30 14:35:45 | QLogs | qlogs_writer | 2020-12-30 14:44:43 | 1 1211599 | 2020-12-30 15:11:09 | QSR | qliksenserepository | 2020-12-30 15:34:17 | 1 1210504 | 2020-12-30 15:00:41 | QLogs | qlogs_writer | 2020-12-30 15:30:46 | 1 1212107 | 2020-12-30 15:16:36 | QLogs | qlogs_writer | 2020-12-30 15:16:57 | 1 1208019 | 2020-12-30 14:37:01 | QLogs | qlogs_writer | 2020-12-30 14:50:55 | 1 1212901 | 2020-12-30 15:24:03 | QSR | qliksenserepository | 2020-12-30 15:34:26 | 1 1207865 | 2020-12-30 14:35:33 | QLogs | qlogs_writer | 2020-12-30 15:01:44 | 1 1212000 | 2020-12-30 15:15:25 | QLogs | qlogs_writer | 2020-12-30 15:19:57 | 1 1192505 | 2020-12-30 12:08:51 | QLogs | qlogs_writer | 2020-12-30 15:18:57 | 1 1212933 | 2020-12-30 15:24:21 | QLogs | qlogs_writer | 2020-12-30 15:32:46 | 1 1209210 | 2020-12-30 14:48:19 | QLogs | qlogs_writer | 2020-12-30 15:22:45 | 1 1210127 | 2020-12-30 14:56:51 | QLogs | qlogs_writer | 2020-12-30 15:00:44 | 1 1207341 | 2020-12-30 14:30:22 | QLogs | qlogs_writer | 2020-12-30 14:31:54 | 1 1197743 | 2020-12-30 12:58:54 | QLogs | qlogs_writer | 2020-12-30 15:21:45 | 1 1207724 | 2020-12-30 14:34:12 | QLogs | qlogs_writer | 2020-12-30 14:39:42 | 1 1209886 | 2020-12-30 14:54:25 | QLogs | qlogs_writer | 2020-12-30 14:56:56 | 1 1210404 | 2020-12-30 14:59:42 | QLogs | qlogs_writer | 2020-12-30 15:11:44 | 1 1207169 | 2020-12-30 14:28:41 | QLogs | qlogs_writer | 2020-12-30 14:29:42 | 1 1188276 | 2020-12-30 11:29:01 | QLogs | qlogs_writer | 2020-12-30 15:05:44 | 1 1212152 | 2020-12-30 15:17:03 | QSR | qliksenserepository | 2020-12-30 15:34:33 | 1 1211792 | 2020-12-30 15:13:13 | QLogs | qlogs_writer | 2020-12-30 15:17:45 | 1 1209510 | 2020-12-30 14:51:25 | QLogs | qlogs_writer | 2020-12-30 14:54:56 | 1 1206608 | 2020-12-30 14:23:16 | QLogs | qlogs_writer | 2020-12-30 14:36:55 | 1 1210346 | 2020-12-30 14:59:08 | QLogs | qlogs_writer | 2020-12-30 15:02:56 | 1 1188282 | 2020-12-30 11:29:01 | Licenses | qliksenserepository | 2020-12-30 11:45:10 | 1 1208672 | 2020-12-30 14:42:48 | QLogs | qlogs_writer | 2020-12-30 14:42:55 | 1 1207156 | 2020-12-30 14:28:35 | QLogs | qlogs_writer | 2020-12-30 14:42:43 | 1 1210680 | 2020-12-30 15:02:24 | QLogs | qlogs_writer | 2020-12-30 15:02:44 | 1 1210888 | 2020-12-30 15:04:39 | QLogs | qlogs_writer | 2020-12-30 15:11:57 | 1 1195598 | 2020-12-30 12:38:12 | QSMQ | qliksenserepository | 2020-12-30 15:34:40 | 1 1209170 | 2020-12-30 14:47:54 | QLogs | qlogs_writer | 2020-12-30 14:52:56 | 1 1212295 | 2020-12-30 15:18:33 | QSR | qliksenserepository | 2020-12-30 15:34:18 | 1 1205750 | 2020-12-30 14:15:27 | QLogs | qlogs_writer | 2020-12-30 14:30:42 | 1 1205254 | 2020-12-30 14:10:21 | QLogs | qlogs_writer | 2020-12-30 15:10:44 | 1 1210999 | 2020-12-30 15:05:46 | QSR | qliksenserepository | 2020-12-30 15:34:26 | 1 1206532 | 2020-12-30 14:22:30 | QLogs | qlogs_writer | 2020-12-30 14:29:24 | 1 1206710 | 2020-12-30 14:24:17 | QLogs | qlogs_writer | 2020-12-30 14:33:54 | 1 1208047 | 2020-12-30 14:37:20 | QLogs | qlogs_writer | 2020-12-30 14:47:55 | 1 1208015 | 2020-12-30 14:37:00 | QLogs | qlogs_writer | 2020-12-30 14:37:42 | 1 1212768 | 2020-12-30 15:22:37 | QSR | qliksenserepository | 2020-12-30 15:34:20 | 1 1211138 | 2020-12-30 15:07:12 | QLogs | qlogs_writer | 2020-12-30 15:28:45 | 1 1210931 | 2020-12-30 15:05:03 | QLogs | qlogs_writer | 2020-12-30 15:06:56 | 1 1210034 | 2020-12-30 14:55:53 | QLogs | qlogs_writer | 2020-12-30 14:58:44 | 1 1207493 | 2020-12-30 14:31:52 | QLogs | qlogs_writer | 2020-12-30 14:34:42 | 1 1211958 | 2020-12-30 15:14:59 | QLogs | qlogs_writer | 2020-12-30 15:33:46 | 1 1207805 | 2020-12-30 14:35:00 | QLogs | qlogs_writer | 2020-12-30 14:38:42 | 1 1207154 | 2020-12-30 14:28:33 | QSMQ | qliksenserepository | 2020-12-30 15:34:35 | 1 1204346 | 2020-12-30 14:02:13 | QLogs | qlogs_writer | 2020-12-30 15:03:44 | 1 1211007 | 2020-12-30 15:05:51 | QLogs | qlogs_writer | 2020-12-30 15:07:56 | 1 1209216 | 2020-12-30 14:48:21 | QLogs | qlogs_writer | 2020-12-30 14:59:44 | 1 1210163 | 2020-12-30 14:57:13 | QLogs | qlogs_writer | 2020-12-30 15:08:57 | 1 1208694 | 2020-12-30 14:43:00 | QLogs | qlogs_writer | 2020-12-30 15:05:56 | 1 1208241 | 2020-12-30 14:38:26 | QLogs | qlogs_writer | 2020-12-30 14:40:42 | 1 1208697 | 2020-12-30 14:43:01 | QLogs | qlogs_writer | 2020-12-30 14:51:56 | 1 1198933 | 2020-12-30 13:09:57 | QLogs | qlogs_writer | 2020-12-30 14:47:43 | 1 1210210 | 2020-12-30 14:57:42 | QSR | qliksenserepository | 2020-12-30 15:34:23 | 1 1210706 | 2020-12-30 15:02:46 | QLogs | qlogs_writer | 2020-12-30 15:14:57 | 1 1209828 | 2020-12-30 14:53:51 | QLogs | qlogs_writer | 2020-12-30 14:54:43 | 1 1209128 | 2020-12-30 14:47:31 | QLogs | qlogs_writer | 2020-12-30 14:57:43 | 1 1201224 | 2020-12-30 13:32:27 | QLogs | qlogs_writer | 2020-12-30 13:35:01 | 1 1199764 | 2020-12-30 13:18:28 | QLogs | qlogs_writer | 2020-12-30 15:27:45 | 1 1212639 | 2020-12-30 15:22:11 | QLogs | qlogs_writer | 2020-12-30 15:34:01 | 1 1207717 | 2020-12-30 14:34:09 | QLogs | qlogs_writer | 2020-12-30 14:35:55 | 1 1208995 | 2020-12-30 14:46:08 | QLogs | qlogs_writer | 2020-12-30 14:48:55 | 1 1210460 | 2020-12-30 15:00:14 | QLogs | qlogs_writer | 2020-12-30 15:23:45 | 1 1206554 | 2020-12-30 14:22:45 | QLogs | qlogs_writer | 2020-12-30 14:31:42 | 1 1211103 | 2020-12-30 15:06:51 | QLogs | qlogs_writer | 2020-12-30 15:20:45 | 1 1208478 | 2020-12-30 14:40:47 | QLogs | qlogs_writer | 2020-12-30 14:40:55 | 1 1207343 | 2020-12-30 14:30:22 | QLogs | qlogs_writer | 2020-12-30 14:41:43 | 1 1209116 | 2020-12-30 14:47:22 | QLogs | qlogs_writer | 2020-12-30 14:49:43 | 1 1207244 | 2020-12-30 14:29:26 | QLogs | qlogs_writer | 2020-12-30 14:32:54 | 1 1211842 | 2020-12-30 15:13:46 | QLogs | qlogs_writer | 2020-12-30 15:14:45 | 1 1207999 | 2020-12-30 14:36:52 | QLogs | qlogs_writer | 2020-12-30 14:46:43 | 1 1213420 | 2020-12-30 15:29:42 | QSR | qliksenserepository | 2020-12-30 15:34:28 | 1 1202241 | 2020-12-30 13:41:46 | QLogs | qlogs_writer | 2020-12-30 14:36:42 | 1 1210828 | 2020-12-30 15:04:01 | QLogs | qlogs_writer | 2020-12-30 15:12:44 | 1 1206925 | 2020-12-30 14:26:13 | QLogs | qlogs_writer | 2020-12-30 14:30:54 | 1 1209957 | 2020-12-30 14:55:07 | QLogs | qlogs_writer | 2020-12-30 14:57:56 | 1 1209195 | 2020-12-30 14:48:11 | QLogs | qlogs_writer | 2020-12-30 15:01:56 | 1 1212153 | 2020-12-30 15:17:03 | QLogs | qlogs_writer | 2020-12-30 15:26:45 | 1 1211943 | 2020-12-30 15:14:49 | QLogs | qlogs_writer | 2020-12-30 15:29:58 | 1 1211925 | 2020-12-30 15:14:38 | QLogs | qlogs_writer | 2020-12-30 15:17:57 | 1 1208849 | 2020-12-30 14:44:39 | QSR | qliksenserepository | 2020-12-30 15:34:19 | 1 1209887 | 2020-12-30 14:54:27 | QLogs | qlogs_writer | 2020-12-30 14:55:43 | 1 1203230 | 2020-12-30 13:51:51 | QLogs | qlogs_writer | 2020-12-30 15:27:58 | 1 1208184 | 2020-12-30 14:37:49 | QLogs | qlogs_writer | 2020-12-30 14:37:55 | 1 1189349 | 2020-12-30 11:38:39 | Licenses | qliksenserepository | 2020-12-30 11:45:10 | 1 1211646 | 2020-12-30 15:11:40 | QLogs | qlogs_writer | 2020-12-30 15:31:46 | 1 1211940 | 2020-12-30 15:14:47 | QLogs | qlogs_writer | 2020-12-30 15:24:45 | 1 1209379 | 2020-12-30 14:50:02 | QLogs | qlogs_writer | 2020-12-30 14:56:43 | 1 1208168 | 2020-12-30 14:37:37 | QLogs | qlogs_writer | 2020-12-30 15:26:58 | 1 1209062 | 2020-12-30 14:46:50 | QLogs | qlogs_writer | 2020-12-30 14:50:43 | 1 1207924 | 2020-12-30 14:36:08 | QLogs | qlogs_writer | 2020-12-30 14:39:55 | 1 1209823 | 2020-12-30 14:53:47 | QLogs | qlogs_writer | 2020-12-30 14:58:56 | 1 1210525 | 2020-12-30 15:00:54 | QSMQ | qliksenserepository | 2020-12-30 15:34:49 | 1 1208853 | 2020-12-30 14:44:42 | QLogs | qlogs_writer | 2020-12-30 14:49:55 | 1 1212419 | 2020-12-30 15:19:51 | QLogs | qlogs_writer | 2020-12-30 15:29:46 | 1 1210505 | 2020-12-30 15:00:42 | QLogs | qlogs_writer | 2020-12-30 15:08:44 | 1 1211654 | 2020-12-30 15:11:43 | QLogs | qlogs_writer | 2020-12-30 15:32:58 | 1 1212543 | 2020-12-30 15:21:09 | QSMQ | qliksenserepository | 2020-12-30 15:34:26 | 1 1188358 | 2020-12-30 11:29:01 | QLogs | qlogs_writer | 2020-12-30 15:16:45 | 1 1209276 | 2020-12-30 14:48:58 | QLogs | qlogs_writer | 2020-12-30 15:13:57 | 1 1210108 | 2020-12-30 14:56:40 | QLogs | qlogs_writer | 2020-12-30 15:04:56 | 1 1208515 | 2020-12-30 14:41:10 | QLogs | qlogs_writer | 2020-12-30 14:41:55 | 1 1208565 | 2020-12-30 14:41:42 | QLogs | qlogs_writer | 2020-12-30 14:48:43 | 1 1210109 | 2020-12-30 14:56:40 | QLogs | qlogs_writer | 2020-12-30 15:04:44 | 1 1209792 | 2020-12-30 14:53:28 | QLogs | qlogs_writer | 2020-12-30 14:59:56 | 1 1188365 | 2020-12-30 11:29:01 | QLogs | qlogs_writer | 2020-12-30 15:15:57 | 1 1208920 | 2020-12-30 14:45:22 | QLogs | qlogs_writer | 2020-12-30 14:52:43 | 1 1206611 | 2020-12-30 14:23:17 | QLogs | qlogs_writer | 2020-12-30 14:32:42 | 1 1210365 | 2020-12-30 14:59:20 | QLogs | qlogs_writer | 2020-12-30 15:18:45 | 1 1207485 | 2020-12-30 14:31:48 | QLogs | qlogs_writer | 2020-12-30 14:43:43 | 1 1209501 | 2020-12-30 14:51:20 | QLogs | qlogs_writer | 2020-12-30 15:03:56 | 1 1207696 | 2020-12-30 14:33:54 | QLogs | qlogs_writer | 2020-12-30 14:38:55 | 1 1212245 | 2020-12-30 15:18:02 | QLogs | qlogs_writer | 2020-12-30 15:22:57 | 1 1210175 | 2020-12-30 14:57:21 | Licenses | qliksenserepository | 2020-12-30 15:34:26 | 1 1212364 | 2020-12-30 15:19:17 | QLogs | qlogs_writer | 2020-12-30 15:24:58 | 1 1209842 | 2020-12-30 14:53:58 | QSMQ | qliksenserepository | 2020-12-30 15:34:44 | 2 1212829 | 2020-12-30 15:23:15 | postgres | postgres | 2020-12-30 15:34:12 | 1 1210838 | 2020-12-30 15:04:10 | QLogs | qlogs_writer | 2020-12-30 15:09:44 | 1 1208399 | 2020-12-30 14:40:02 | QLogs | qlogs_writer | 2020-12-30 14:53:56 | 1 1211503 | 2020-12-30 15:10:11 | QLogs | qlogs_writer | 2020-12-30 15:25:45 | 1 1212957 | 2020-12-30 15:24:38 | QLogs | qlogs_writer | 2020-12-30 15:25:58 | 1 1212449 | 2020-12-30 15:20:09 | QLogs | qlogs_writer | 2020-12-30 15:30:58 | 1 1212869 | 2020-12-30 15:23:40 | QLogs | qlogs_writer | 2020-12-30 15:28:58 | 1 1210316 | 2020-12-30 14:58:49 | QLogs | qlogs_writer | 2020-12-30 15:06:44 | 1 (150 wierszy) psaux.txt (57,547 bytes)
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND root 1 0.0 0.0 244724 11092 ? Ss gru21 0:04 /usr/lib/systemd/systemd --switched-root --system --deserialize 17 root 2 0.0 0.0 0 0 ? S gru21 0:00 [kthreadd] root 3 0.0 0.0 0 0 ? I< gru21 0:00 [rcu_gp] root 4 0.0 0.0 0 0 ? I< gru21 0:00 [rcu_par_gp] root 6 0.0 0.0 0 0 ? I< gru21 0:00 [kworker/0:0H-kblockd] root 9 0.0 0.0 0 0 ? I< gru21 0:00 [mm_percpu_wq] root 10 0.0 0.0 0 0 ? S gru21 0:00 [ksoftirqd/0] root 11 0.0 0.0 0 0 ? I gru21 1:49 [rcu_sched] root 12 0.0 0.0 0 0 ? S gru21 0:00 [migration/0] root 13 0.0 0.0 0 0 ? S gru21 0:00 [watchdog/0] root 14 0.0 0.0 0 0 ? S gru21 0:00 [cpuhp/0] root 15 0.0 0.0 0 0 ? S gru21 0:00 [cpuhp/1] root 16 0.0 0.0 0 0 ? S gru21 0:00 [watchdog/1] root 17 0.0 0.0 0 0 ? S gru21 0:00 [migration/1] root 18 0.0 0.0 0 0 ? S gru21 0:00 [ksoftirqd/1] root 20 0.0 0.0 0 0 ? I< gru21 0:00 [kworker/1:0H] root 21 0.0 0.0 0 0 ? S gru21 0:00 [cpuhp/2] root 22 0.0 0.0 0 0 ? S gru21 0:00 [watchdog/2] root 23 0.0 0.0 0 0 ? S gru21 0:00 [migration/2] root 24 0.0 0.0 0 0 ? S gru21 0:00 [ksoftirqd/2] root 26 0.0 0.0 0 0 ? I< gru21 0:00 [kworker/2:0H-kblockd] root 27 0.0 0.0 0 0 ? S gru21 0:00 [cpuhp/3] root 28 0.0 0.0 0 0 ? S gru21 0:00 [watchdog/3] root 29 0.0 0.0 0 0 ? S gru21 0:00 [migration/3] root 30 0.0 0.0 0 0 ? S gru21 0:00 [ksoftirqd/3] root 32 0.0 0.0 0 0 ? I< gru21 0:00 [kworker/3:0H-kblockd] root 37 0.0 0.0 0 0 ? S gru21 0:00 [kdevtmpfs] root 38 0.0 0.0 0 0 ? I< gru21 0:00 [netns] root 39 0.0 0.0 0 0 ? S gru21 0:00 [kauditd] root 40 0.0 0.0 0 0 ? S gru21 0:00 [khungtaskd] root 41 0.0 0.0 0 0 ? S gru21 0:00 [oom_reaper] root 42 0.0 0.0 0 0 ? I< gru21 0:00 [writeback] root 43 0.0 0.0 0 0 ? S gru21 0:00 [kcompactd0] root 44 0.0 0.0 0 0 ? SN gru21 0:00 [ksmd] root 45 0.0 0.0 0 0 ? SN gru21 0:13 [khugepaged] root 46 0.0 0.0 0 0 ? I< gru21 0:00 [crypto] root 47 0.0 0.0 0 0 ? I< gru21 0:00 [kintegrityd] root 48 0.0 0.0 0 0 ? I< gru21 0:00 [kblockd] root 49 0.0 0.0 0 0 ? I< gru21 0:00 [blkcg_punt_bio] root 50 0.0 0.0 0 0 ? I< gru21 0:00 [tpm_dev_wq] root 51 0.0 0.0 0 0 ? I< gru21 0:00 [md] root 52 0.0 0.0 0 0 ? I< gru21 0:00 [edac-poller] root 53 0.0 0.0 0 0 ? S gru21 0:00 [watchdogd] root 54 0.0 0.0 0 0 ? I< gru21 0:00 [pm_wq] root 77 0.0 0.0 0 0 ? S gru21 0:00 [kswapd0] root 170 0.0 0.0 0 0 ? I< gru21 0:00 [kthrotld] root 171 0.0 0.0 0 0 ? S gru21 0:00 [irq/24-pciehp] root 172 0.0 0.0 0 0 ? S gru21 0:00 [irq/25-pciehp] root 173 0.0 0.0 0 0 ? S gru21 0:00 [irq/26-pciehp] root 174 0.0 0.0 0 0 ? S gru21 0:00 [irq/27-pciehp] root 175 0.0 0.0 0 0 ? S gru21 0:00 [irq/28-pciehp] root 176 0.0 0.0 0 0 ? S gru21 0:00 [irq/29-pciehp] root 177 0.0 0.0 0 0 ? S gru21 0:00 [irq/30-pciehp] root 178 0.0 0.0 0 0 ? S gru21 0:00 [irq/31-pciehp] root 179 0.0 0.0 0 0 ? S gru21 0:00 [irq/32-pciehp] root 180 0.0 0.0 0 0 ? S gru21 0:00 [irq/33-pciehp] root 181 0.0 0.0 0 0 ? S gru21 0:00 [irq/34-pciehp] root 182 0.0 0.0 0 0 ? S gru21 0:00 [irq/35-pciehp] root 183 0.0 0.0 0 0 ? S gru21 0:00 [irq/36-pciehp] root 184 0.0 0.0 0 0 ? S gru21 0:00 [irq/37-pciehp] root 185 0.0 0.0 0 0 ? S gru21 0:00 [irq/38-pciehp] root 186 0.0 0.0 0 0 ? S gru21 0:00 [irq/39-pciehp] root 187 0.0 0.0 0 0 ? S gru21 0:00 [irq/40-pciehp] root 188 0.0 0.0 0 0 ? S gru21 0:00 [irq/41-pciehp] root 189 0.0 0.0 0 0 ? S gru21 0:00 [irq/42-pciehp] root 190 0.0 0.0 0 0 ? S gru21 0:00 [irq/43-pciehp] root 191 0.0 0.0 0 0 ? S gru21 0:00 [irq/44-pciehp] root 192 0.0 0.0 0 0 ? S gru21 0:00 [irq/45-pciehp] root 193 0.0 0.0 0 0 ? S gru21 0:00 [irq/46-pciehp] root 194 0.0 0.0 0 0 ? S gru21 0:00 [irq/47-pciehp] root 195 0.0 0.0 0 0 ? S gru21 0:00 [irq/48-pciehp] root 196 0.0 0.0 0 0 ? S gru21 0:00 [irq/49-pciehp] root 197 0.0 0.0 0 0 ? S gru21 0:00 [irq/50-pciehp] root 198 0.0 0.0 0 0 ? S gru21 0:00 [irq/51-pciehp] root 199 0.0 0.0 0 0 ? S gru21 0:00 [irq/52-pciehp] root 200 0.0 0.0 0 0 ? S gru21 0:00 [irq/53-pciehp] root 201 0.0 0.0 0 0 ? S gru21 0:00 [irq/54-pciehp] root 202 0.0 0.0 0 0 ? S gru21 0:00 [irq/55-pciehp] root 204 0.0 0.0 0 0 ? I< gru21 0:00 [acpi_thermal_pm] root 205 0.0 0.0 0 0 ? I< gru21 0:00 [kmpath_rdacd] root 206 0.0 0.0 0 0 ? I< gru21 0:00 [kaluad] root 207 0.0 0.0 0 0 ? I< gru21 0:00 [ipv6_addrconf] root 208 0.0 0.0 0 0 ? I< gru21 0:00 [kstrp] root 533 0.0 0.0 0 0 ? I< gru21 0:00 [ata_sff] root 535 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_0] root 536 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_0] root 537 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_1] root 538 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_1] root 539 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_2] root 540 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_2] root 541 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_3] root 543 0.0 0.0 0 0 ? I< gru21 0:00 [vmw_pvscsi_wq_2] root 544 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_3] root 546 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_4] root 549 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_4] root 551 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_5] root 552 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_5] root 553 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_6] root 555 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_6] root 557 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_7] root 558 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_7] root 559 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_8] root 560 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_8] root 561 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_9] root 563 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_9] root 564 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_10] root 566 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_10] root 567 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_11] root 568 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_11] root 569 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_12] root 570 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_12] root 571 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_13] root 572 0.0 0.0 0 0 ? S gru21 0:18 [irq/16-vmwgfx] root 573 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_13] root 575 0.0 0.0 0 0 ? I< gru21 0:00 [ttm_swap] root 576 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_14] root 577 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_14] root 579 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_15] root 580 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_15] root 581 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_16] root 583 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_16] root 585 0.0 0.0 0 0 ? I< gru21 0:00 [kworker/0:1H-kblockd] root 586 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_17] root 588 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_17] root 591 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_18] root 592 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_18] root 593 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_19] root 594 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_19] root 595 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_20] root 596 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_20] root 597 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_21] root 598 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_21] root 601 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_22] root 603 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_22] root 606 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_23] root 609 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_23] root 612 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_24] root 615 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_24] root 618 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_25] root 621 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_25] root 624 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_26] root 627 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_26] root 629 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_27] root 633 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_27] root 636 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_28] root 639 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_28] root 644 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_29] root 646 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_29] root 650 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_30] root 651 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_30] root 656 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_31] root 657 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_31] root 659 0.0 0.0 0 0 ? S gru21 0:00 [scsi_eh_32] root 660 0.0 0.0 0 0 ? I< gru21 0:00 [scsi_tmf_32] root 687 0.0 0.0 0 0 ? I< gru21 0:01 [kworker/3:1H-kblockd] root 689 0.0 0.0 0 0 ? I< gru21 0:01 [kworker/2:1H-xfs-log/dm-0] root 690 0.0 0.0 0 0 ? I< gru21 0:00 [kworker/1:1H-kblockd] root 725 0.0 0.0 0 0 ? I< gru21 0:00 [kdmflush] root 758 0.0 0.0 0 0 ? I< gru21 0:00 [xfsalloc] root 760 0.0 0.0 0 0 ? I< gru21 0:00 [xfs_mru_cache] root 761 0.0 0.0 0 0 ? I< gru21 0:00 [xfs-buf/dm-0] root 762 0.0 0.0 0 0 ? I< gru21 0:00 [xfs-conv/dm-0] root 763 0.0 0.0 0 0 ? I< gru21 0:00 [xfs-cil/dm-0] root 764 0.0 0.0 0 0 ? I< gru21 0:00 [xfs-reclaim/dm-] root 765 0.0 0.0 0 0 ? I< gru21 0:00 [xfs-eofblocks/d] root 766 0.0 0.0 0 0 ? I< gru21 0:00 [xfs-log/dm-0] root 767 0.0 0.0 0 0 ? S gru21 0:59 [xfsaild/dm-0] root 863 0.0 0.5 201600 95688 ? Ss gru21 0:09 /usr/lib/systemd/systemd-journald root 901 0.0 0.0 109480 10248 ? Ss gru21 0:00 /usr/lib/systemd/systemd-udevd root 970 0.0 0.0 0 0 ? I< gru21 0:00 [nfit] root 1007 0.0 0.0 0 0 ? S gru21 0:00 [jbd2/sda1-8] root 1008 0.0 0.0 0 0 ? I< gru21 0:00 [ext4-rsv-conver] root 1028 0.0 0.0 76964 1996 ? S<sl gru21 0:00 /sbin/auditd polkitd 1051 0.0 0.1 1763312 24384 ? Ssl gru21 0:00 /usr/lib/polkit-1/polkitd --no-debug dbus 1054 0.0 0.0 76872 5912 ? Ss gru21 0:01 /usr/bin/dbus-daemon --system --address=systemd: --nofork --nopidfile --systemd-activation --syslog-only root 1056 0.0 0.1 392016 19028 ? Ssl gru21 0:09 /usr/sbin/NetworkManager --no-daemon root 1057 0.0 0.0 124956 5420 ? Ssl gru21 0:19 /usr/sbin/irqbalance --foreground root 1058 0.0 0.0 230784 15028 ? Ss gru21 0:00 /usr/sbin/sssd -i --logger=files root 1060 0.0 0.0 86440 11780 ? Ss gru21 0:00 /usr/bin/VGAuthService -s root 1061 0.0 0.0 278616 11476 ? Ssl gru21 6:43 /usr/bin/vmtoolsd rngd 1062 0.0 0.0 381304 8708 ? Ssl gru21 0:34 /sbin/rngd -f --fill-watermark=0 chrony 1064 0.0 0.0 30320 2656 ? S gru21 0:02 /usr/sbin/chronyd root 1089 0.0 0.1 416568 30328 ? Ssl gru21 0:58 /usr/libexec/platform-python -Es /usr/sbin/tuned -l -P root 1091 0.0 0.0 92284 7756 ? Ss gru21 0:00 /usr/sbin/sshd -D -oCiphers=aes256-gcm@openssh.com,chacha20-poly1305@openssh.com,aes256-ctr,aes256-cbc,aes128-gcm@openssh.com,aes128-ctr,aes128-cbc -oMACs=hmac-sha2-256-e root 1092 0.0 0.0 51328 4552 ? Ss gru21 0:00 /usr/sbin/oddjobd -n -p /var/run/oddjobd.pid -t 300 root 1099 0.0 0.0 41748 2280 ? Ss gru21 0:00 /usr/bin/rhsmcertd root 1108 0.0 0.0 227576 15228 ? S gru21 0:03 /usr/libexec/sssd/sssd_be --domain implicit_files --uid 0 --gid 0 --logger=files root 1109 0.0 0.1 374052 27944 ? S gru21 0:08 /usr/libexec/sssd/sssd_be --domain rossmann.com.pl --uid 0 --gid 0 --logger=files root 1121 0.0 0.3 320804 58608 ? Ssl gru21 0:25 /usr/sbin/rsyslogd -n root 1126 0.0 0.2 241680 45460 ? S gru21 0:04 /usr/libexec/sssd/sssd_nss --uid 0 --gid 0 --logger=files root 1127 0.0 0.0 207344 14016 ? S gru21 0:03 /usr/libexec/sssd/sssd_pam --uid 0 --gid 0 --logger=files root 1141 0.0 0.0 97512 8348 ? Ss gru21 0:01 /usr/lib/systemd/systemd-logind root 1146 0.0 0.0 36920 3668 ? Ss gru21 0:00 /usr/sbin/crond -n root 1153 0.0 0.0 13628 1572 tty1 Ss+ gru21 0:00 /sbin/agetty -o -p -- \u --noclear tty1 linux adm.lcz+ 1631 0.0 0.0 93872 9632 ? Ss gru21 0:00 /usr/lib/systemd/systemd --user adm.lcz+ 1634 0.0 0.0 180472 2752 ? S gru21 0:00 (sd-pam) postgres 129837 0.0 0.8 5004900 139188 ? S gru23 5:58 /usr/pgsql-11/bin/postgres -D /var/lib/pgsql/11/data postgres 129838 0.0 0.0 139916 3912 ? Ss gru23 0:00 postgres: logger postgres 129840 0.0 2.4 5005152 401260 ? Ss gru23 0:38 postgres: checkpointer postgres 129841 0.0 0.3 5005052 59220 ? Ss gru23 0:06 postgres: background writer postgres 129842 0.0 0.1 5004900 21632 ? Ss gru23 1:35 postgres: walwriter postgres 129843 0.0 0.0 5005648 7900 ? Ss gru23 0:18 postgres: autovacuum launcher postgres 129844 0.0 0.0 142036 4824 ? Ss gru23 0:00 postgres: archiver last was 0000000700000000000000A1 postgres 129845 0.0 0.0 142628 5000 ? Ss gru23 1:29 postgres: stats collector postgres 129846 0.0 0.0 5005328 6408 ? Ss gru23 0:00 postgres: logical replication launcher postgres 130204 0.0 0.0 5006028 10836 ? Ss gru23 0:23 postgres: walsender repl 192.168.41.154(56772) streaming 0/A2E56600 root 725522 0.0 0.1 332532 18408 ? Ssl gru29 0:02 /opt/commvault/Base/cvlaunchd root 725523 0.0 1.4 2627424 233052 ? Ssl gru29 0:32 /opt/commvault/Base/cvd root 725525 0.0 0.0 177232 10672 ? Ssl gru29 0:03 /opt/commvault/Base/cvfwd root 1170588 0.0 0.0 172940 11996 ? Ss 09:29 0:00 sshd: adm.lczajkowski [priv] adm.lcz+ 1170608 0.0 0.0 172940 6344 ? R 09:29 0:00 sshd: adm.lczajkowski@pts/1 adm.lcz+ 1170609 0.0 0.0 24092 3960 pts/1 Ss 09:29 0:00 -bash root 1174280 0.0 0.0 0 0 ? I 09:58 0:00 [kworker/1:2-mm_percpu_wq] root 1187950 0.0 0.0 0 0 ? I 11:25 0:00 [kworker/1:0-events] root 1187961 0.0 0.0 0 0 ? I 11:25 0:00 [kworker/0:3-events] postgres 1188224 0.0 0.4 223420 67620 ? Ss 11:28 0:01 /usr/bin/pgpool -f /etc/pgpool-II/pgpool.conf -n postgres 1188226 0.0 0.0 223548 3476 ? S 11:28 0:00 pgpool: watchdog postgres 1188229 0.0 0.0 223428 3020 ? S 11:29 0:00 pgpool: lifecheck postgres 1188232 0.0 0.0 225640 7468 ? S 11:29 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55339) idle postgres 1188237 0.0 0.0 223428 1160 ? S 11:29 0:00 pgpool: heartbeat receiver postgres 1188239 0.0 0.0 223428 1160 ? S 11:29 0:00 pgpool: heartbeat sender postgres 1188241 0.0 0.0 223428 1160 ? S 11:29 0:00 pgpool: heartbeat receiver postgres 1188243 0.0 0.0 223428 1160 ? S 11:29 0:00 pgpool: heartbeat sender postgres 1188249 0.0 0.0 225640 7468 ? S 11:29 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53487) idle postgres 1188276 0.0 0.0 225640 7416 ? S 11:29 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53070) idle postgres 1188282 0.0 0.0 225988 7580 ? S 11:29 0:00 pgpool: qliksenserepository Licenses 192.168.41.151(60081) idle postgres 1188358 0.0 0.0 225640 7424 ? S 11:29 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53642) idle postgres 1188365 0.0 0.0 225704 7828 ? S 11:29 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55077) idle postgres 1188385 0.0 0.0 223424 1200 ? S 11:29 0:00 pgpool: PCP: wait for connection request postgres 1188386 0.0 0.0 223548 3236 ? S 11:29 0:00 pgpool: worker process postgres 1188387 0.0 0.0 223420 2776 ? S 11:29 0:00 pgpool: health check process(0) postgres 1188388 0.0 0.0 223420 2776 ? S 11:29 0:00 pgpool: health check process(1) root 1188441 0.0 0.0 167644 8860 pts/1 S 11:29 0:00 sudo su - postgres root 1188442 0.0 0.0 155076 6884 pts/1 S 11:29 0:00 su - postgres postgres 1188443 0.0 0.0 24088 4060 pts/1 S 11:29 0:00 -bash postgres 1189349 0.0 0.0 225736 7612 ? S 11:38 0:00 pgpool: qliksenserepository Licenses 192.168.41.151(60080) idle postgres 1189973 0.0 0.1 5006180 20992 ? Ss 11:44 0:00 postgres: qliksenserepository QSMQ 192.168.41.153(50992) idle postgres 1189991 0.0 0.1 5006560 31148 ? Ss 11:45 0:00 postgres: qliksenserepository Licenses 192.168.41.153(51016) idle postgres 1189992 0.0 0.1 5006560 30932 ? Ss 11:45 0:01 postgres: qliksenserepository Licenses 192.168.41.153(51020) idle postgres 1192505 0.0 0.0 225904 7432 ? S 12:08 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55233) idle postgres 1195598 0.0 0.0 225984 8088 ? S 12:38 0:00 pgpool: accept connection root 1196179 0.0 0.0 0 0 ? I 12:44 0:00 [kworker/0:0-events] postgres 1197743 0.0 0.0 225704 7852 ? S 12:58 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53901) idle postgres 1198933 0.0 0.0 225644 7484 ? S 13:09 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51566) idle postgres 1199764 0.0 0.0 225980 7868 ? S 13:18 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54299) idle postgres 1201224 0.0 0.0 224604 6372 ? S 13:32 0:02 pgpool: qlogs_writer QLogs 192.168.26.239(58555) idle postgres 1201494 0.5 0.1 5008380 29220 ? Ss 13:35 0:43 postgres: qlogs_writer QLogs 192.168.41.153(42352) idle postgres 1201637 0.0 0.0 225644 7484 ? S 13:36 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(50794) idle postgres 1202019 0.0 0.0 225644 7484 ? S 13:39 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53360) idle postgres 1202241 0.0 0.0 225644 7116 ? S 13:41 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(50955) idle postgres 1203230 0.0 0.0 225736 8064 ? S 13:51 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55702) idle postgres 1204346 0.0 0.0 225644 7484 ? S 14:02 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(52922) idle postgres 1205254 0.0 0.0 225644 7436 ? S 14:10 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53335) idle root 1205585 0.0 0.0 0 0 ? I 14:13 0:00 [kworker/2:2-mm_percpu_wq] postgres 1205750 0.0 0.0 225752 8144 ? S 14:15 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(50644) idle postgres 1205846 0.0 0.0 225700 7920 ? S 14:16 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53794) idle postgres 1206532 0.0 0.0 225644 7484 ? S 14:22 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(52608) idle postgres 1206554 0.0 0.0 225644 7116 ? S 14:22 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(50696) idle postgres 1206608 0.0 0.0 225644 7172 ? S 14:23 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53002) idle postgres 1206611 0.0 0.0 225644 7484 ? S 14:23 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(50744) idle postgres 1206710 0.0 0.0 225644 7484 ? S 14:24 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(52836) idle postgres 1206925 0.0 0.0 225968 7788 ? S 14:26 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(52684) idle postgres 1207154 0.0 0.0 225704 7856 ? S 14:28 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(56115) idle postgres 1207156 0.0 0.0 225712 7860 ? S 14:28 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51294) idle postgres 1207169 0.0 0.0 225904 7480 ? S 14:28 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(50535) idle postgres 1207241 0.0 0.1 5007344 27452 ? Ss 14:29 0:00 postgres: qlogs_writer QLogs 192.168.41.153(52028) COPY postgres 1207244 0.0 0.0 225944 7812 ? S 14:29 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(52786) idle postgres 1207253 0.0 0.1 5006180 20996 ? Ss 14:29 0:00 postgres: qliksenserepository QSMQ 192.168.41.153(52056) idle postgres 1207275 0.0 0.1 5007456 27420 ? Ss 14:29 0:00 postgres: qlogs_writer QLogs 192.168.41.153(52102) COPY postgres 1207341 0.0 0.0 225644 7484 ? S 14:30 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(52735) idle postgres 1207343 0.0 0.0 225644 7484 ? S 14:30 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51242) idle postgres 1207372 0.0 0.1 5006804 26552 ? Ss 14:30 0:00 postgres: qlogs_writer QLogs 192.168.41.153(52282) COPY postgres 1207396 0.0 0.1 5006804 26496 ? Ss 14:30 0:00 postgres: qlogs_writer QLogs 192.168.41.153(52324) COPY postgres 1207473 0.0 0.1 5007344 27700 ? Ss 14:31 0:00 postgres: qlogs_writer QLogs 192.168.41.153(52476) COPY postgres 1207485 0.0 0.0 225644 7484 ? S 14:31 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51345) idle postgres 1207493 0.0 0.0 225644 7484 ? S 14:31 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(50848) idle postgres 1207498 0.0 0.1 5006804 26616 ? Ss 14:31 0:00 postgres: qlogs_writer QLogs 192.168.41.153(52518) COPY postgres 1207508 0.0 0.0 225644 7484 ? S 14:32 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53415) idle postgres 1207574 0.0 0.1 5006804 26552 ? Ss 14:32 0:00 postgres: qlogs_writer QLogs 192.168.41.153(52662) COPY postgres 1207580 0.0 0.1 5006180 20992 ? Ss 14:32 0:00 postgres: qliksenserepository QSMQ 192.168.41.153(52680) idle postgres 1207598 0.0 0.1 5007344 27960 ? Ss 14:32 0:00 postgres: qlogs_writer QLogs 192.168.41.153(52704) COPY postgres 1207663 0.0 0.0 225644 7484 ? S 14:33 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(52904) idle postgres 1207674 0.0 0.1 5007344 27840 ? Ss 14:33 0:00 postgres: qlogs_writer QLogs 192.168.41.153(52842) COPY postgres 1207696 0.0 0.0 225644 7116 ? S 14:33 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53100) idle postgres 1207698 0.0 0.1 5007344 28240 ? Ss 14:33 0:00 postgres: qlogs_writer QLogs 192.168.41.153(52896) COPY postgres 1207717 0.0 0.0 225644 7484 ? S 14:34 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(52953) idle postgres 1207724 0.0 0.0 225704 7864 ? S 14:34 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51139) idle postgres 1207775 0.0 0.1 5006936 26556 ? Ss 14:34 0:00 postgres: qlogs_writer QLogs 192.168.41.153(53034) COPY postgres 1207777 0.0 0.0 225644 7484 ? S 14:34 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(50904) idle postgres 1207799 0.0 0.1 5007344 28188 ? Ss 14:34 0:00 postgres: qlogs_writer QLogs 192.168.41.153(53088) COPY postgres 1207805 0.0 0.0 225720 7868 ? S 14:34 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51060) idle postgres 1207823 0.0 0.0 225712 7780 ? S 14:35 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53470) idle postgres 1207865 0.0 0.0 225708 7788 ? S 14:35 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(52598) idle postgres 1207876 0.0 0.1 5006936 26616 ? Ss 14:35 0:00 postgres: qlogs_writer QLogs 192.168.41.153(53220) COPY postgres 1207880 0.0 0.0 225712 7804 ? S 14:35 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51395) idle postgres 1207897 0.0 0.1 5007344 28352 ? Ss 14:35 0:00 postgres: qlogs_writer QLogs 192.168.41.153(53256) COPY postgres 1207924 0.0 0.0 225644 7436 ? S 14:36 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53156) idle postgres 1207986 0.0 0.1 5006936 26612 ? Ss 14:36 0:00 postgres: qlogs_writer QLogs 192.168.41.153(53432) COPY postgres 1207999 0.0 0.0 225644 7484 ? S 14:36 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51520) idle postgres 1208003 0.0 0.1 5006936 26612 ? Ss 14:36 0:00 postgres: qlogs_writer QLogs 192.168.41.153(53456) COPY postgres 1208015 0.0 0.0 225644 7116 ? S 14:37 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51008) idle postgres 1208019 0.0 0.0 225720 7880 ? S 14:37 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53750) idle postgres 1208047 0.0 0.0 225708 7852 ? S 14:37 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53574) idle postgres 1208168 0.0 0.0 225708 7860 ? S 14:37 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55660) idle postgres 1208175 0.0 0.1 5006936 26668 ? Ss 14:37 0:00 postgres: qlogs_writer QLogs 192.168.41.153(53612) COPY postgres 1208184 0.0 0.0 225644 7116 ? S 14:37 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53054) idle postgres 1208194 0.0 0.1 5006936 26612 ? Ss 14:37 0:00 postgres: qlogs_writer QLogs 192.168.41.153(53640) COPY postgres 1208241 0.0 0.0 225644 7116 ? S 14:38 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51194) idle postgres 1208273 0.0 0.1 5007344 28356 ? Ss 14:38 0:00 postgres: qlogs_writer QLogs 192.168.41.153(53796) COPY postgres 1208289 0.0 0.1 5006936 26676 ? Ss 14:38 0:00 postgres: qlogs_writer QLogs 192.168.41.153(53818) COPY postgres 1208370 0.0 0.1 5007344 28540 ? Ss 14:39 0:00 postgres: qlogs_writer QLogs 192.168.41.153(53990) COPY postgres 1208389 0.0 0.1 5006936 26676 ? Ss 14:39 0:00 postgres: qlogs_writer QLogs 192.168.41.153(54018) COPY postgres 1208395 0.0 0.0 225644 7484 ? S 14:40 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51469) idle postgres 1208399 0.0 0.0 225696 7868 ? S 14:40 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53898) idle postgres 1208468 0.0 0.1 5007344 28864 ? Ss 14:40 0:00 postgres: qlogs_writer QLogs 192.168.41.153(54166) COPY postgres 1208478 0.0 0.0 225644 7436 ? S 14:40 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53208) idle postgres 1208491 0.0 0.1 5006936 26792 ? Ss 14:40 0:00 postgres: qlogs_writer QLogs 192.168.41.153(54206) COPY postgres 1208515 0.0 0.0 225644 7484 ? S 14:41 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53256) idle postgres 1208565 0.0 0.0 225964 7852 ? S 14:41 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51624) idle postgres 1208567 0.0 0.1 5006936 26620 ? Ss 14:41 0:00 postgres: qlogs_writer QLogs 192.168.41.153(54338) COPY postgres 1208588 0.0 0.1 5006936 26612 ? Ss 14:41 0:00 postgres: qlogs_writer QLogs 192.168.41.153(54382) COPY postgres 1208664 0.0 0.1 5006936 29096 ? Ss 14:42 0:00 postgres: qlogs_writer QLogs 192.168.41.153(54530) COPY postgres 1208672 0.0 0.0 225644 7436 ? S 14:42 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53309) idle postgres 1208685 0.0 0.1 5006936 26624 ? Ss 14:42 0:00 postgres: qlogs_writer QLogs 192.168.41.153(54566) COPY postgres 1208690 0.0 0.0 225964 7856 ? S 14:42 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54011) idle postgres 1208694 0.0 0.0 225700 7852 ? S 14:43 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54535) idle postgres 1208697 0.0 0.0 225644 7484 ? S 14:43 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53799) idle postgres 1208762 0.0 0.1 5006936 29460 ? Ss 14:43 0:00 postgres: qlogs_writer QLogs 192.168.41.153(54710) COPY postgres 1208782 0.0 0.1 5007344 29132 ? Ss 14:43 0:00 postgres: qlogs_writer QLogs 192.168.41.153(54754) COPY postgres 1208849 0.0 0.0 226124 8184 ? S 14:44 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(55234) idle postgres 1208853 0.0 0.0 225644 7436 ? S 14:44 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53700) idle postgres 1208856 0.0 0.1 5007344 29156 ? Ss 14:44 0:00 postgres: qlogs_writer QLogs 192.168.41.153(54894) COPY postgres 1208878 0.0 0.1 5006936 26812 ? Ss 14:44 0:00 postgres: qlogs_writer QLogs 192.168.41.153(54942) COPY postgres 1208920 0.0 0.0 225644 7484 ? S 14:45 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51827) idle postgres 1208957 0.0 0.1 5006936 29160 ? Ss 14:45 0:00 postgres: qlogs_writer QLogs 192.168.41.153(55094) COPY postgres 1208958 0.0 0.0 225644 7484 ? S 14:45 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53523) idle postgres 1208979 0.0 0.1 5006936 26760 ? Ss 14:45 0:00 postgres: qlogs_writer QLogs 192.168.41.153(55134) COPY postgres 1208995 0.0 0.0 225644 7432 ? S 14:46 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53647) idle postgres 1209054 0.0 0.1 5007344 29364 ? Ss 14:46 0:00 postgres: qlogs_writer QLogs 192.168.41.153(55278) COPY postgres 1209062 0.0 0.0 225644 7484 ? S 14:46 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51727) idle postgres 1209074 0.0 0.1 5006936 26680 ? Ss 14:46 0:00 postgres: qlogs_writer QLogs 192.168.41.153(55314) COPY postgres 1209116 0.0 0.0 225644 7436 ? S 14:47 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51674) idle postgres 1209128 0.0 0.0 225712 7868 ? S 14:47 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(52082) idle postgres 1209150 0.0 0.1 5007344 29448 ? Ss 14:47 0:00 postgres: qlogs_writer QLogs 192.168.41.153(55454) COPY postgres 1209170 0.0 0.0 225644 7484 ? S 14:47 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53848) idle postgres 1209174 0.0 0.1 5007344 29436 ? Ss 14:47 0:00 postgres: qlogs_writer QLogs 192.168.41.153(55502) COPY postgres 1209195 0.0 0.0 225688 7820 ? S 14:48 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54317) idle postgres 1209210 0.0 0.0 225996 8424 ? S 14:48 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54015) idle postgres 1209216 0.0 0.0 225644 7484 ? S 14:48 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(52183) idle postgres 1209249 0.0 0.1 5007344 29660 ? Ss 14:48 0:00 postgres: qlogs_writer QLogs 192.168.41.153(55638) COPY postgres 1209268 0.0 0.1 5007344 29580 ? Ss 14:48 0:00 postgres: qlogs_writer QLogs 192.168.41.153(55678) COPY postgres 1209276 0.0 0.0 225644 7436 ? S 14:48 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54968) idle postgres 1209347 0.0 0.1 5006936 29464 ? Ss 14:49 0:00 postgres: qlogs_writer QLogs 192.168.41.153(55822) COPY postgres 1209367 0.0 0.1 5006936 29564 ? Ss 14:49 0:00 postgres: qlogs_writer QLogs 192.168.41.153(55866) COPY postgres 1209379 0.0 0.0 225644 7436 ? S 14:50 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(52032) idle postgres 1209428 0.0 0.0 225644 7484 ? S 14:50 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53593) idle postgres 1209443 0.0 0.1 5007344 29896 ? Ss 14:50 0:00 postgres: qlogs_writer QLogs 192.168.41.153(55998) COPY postgres 1209445 0.0 0.0 225716 8388 ? S 14:50 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53172) idle postgres 1209461 0.0 0.1 5006936 26684 ? Ss 14:50 0:00 postgres: qlogs_writer QLogs 192.168.41.153(56022) COPY postgres 1209501 0.0 0.0 225712 7856 ? S 14:51 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54420) idle postgres 1209510 0.0 0.0 225904 7480 ? S 14:51 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53957) idle postgres 1209533 0.0 0.0 225644 7436 ? S 14:51 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51779) idle postgres 1209541 0.0 0.1 5006936 28848 ? Ss 14:51 0:00 postgres: qlogs_writer QLogs 192.168.41.153(56186) COPY postgres 1209556 0.0 0.1 5007344 30032 ? Ss 14:51 0:00 postgres: qlogs_writer QLogs 192.168.41.153(56202) COPY postgres 1209700 0.0 0.0 225644 7384 ? S 14:52 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51878) idle postgres 1209725 0.0 0.1 5007344 30068 ? Ss 14:52 0:00 postgres: qlogs_writer QLogs 192.168.41.153(56366) COPY postgres 1209741 0.0 0.1 5007344 30068 ? Ss 14:52 0:00 postgres: qlogs_writer QLogs 192.168.41.153(56390) COPY postgres 1209792 0.0 0.0 225644 7484 ? S 14:53 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54218) idle postgres 1209819 0.0 0.1 5006936 29568 ? Ss 14:53 0:00 postgres: qlogs_writer QLogs 192.168.41.153(56550) COPY postgres 1209823 0.0 0.0 225644 7436 ? S 14:53 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54159) idle postgres 1209828 0.0 0.0 225644 7436 ? S 14:53 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51930) idle postgres 1209836 0.0 0.1 5007344 30148 ? Ss 14:53 0:00 postgres: qlogs_writer QLogs 192.168.41.153(56574) COPY postgres 1209886 0.0 0.0 225644 7484 ? S 14:54 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54058) idle postgres 1209887 0.0 0.0 225644 7484 ? S 14:54 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51984) idle postgres 1209893 0.0 0.0 225904 7480 ? S 14:54 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54270) idle postgres 1209913 0.0 0.1 5006180 21060 ? Ss 14:54 0:00 postgres: qliksenserepository QSMQ 192.168.41.153(56714) idle postgres 1209918 0.0 0.1 5006936 29444 ? Ss 14:54 0:00 postgres: qlogs_writer QLogs 192.168.41.153(56730) COPY postgres 1209937 0.0 0.1 5007344 30456 ? Ss 14:54 0:00 postgres: qlogs_writer QLogs 192.168.41.153(56766) COPY postgres 1209942 0.0 0.0 225644 7436 ? S 14:54 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54763) idle postgres 1209957 0.0 0.0 225644 9776 ? S 14:55 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54111) idle postgres 1210016 0.0 0.1 5007344 30352 ? Ss 14:55 0:00 postgres: qlogs_writer QLogs 192.168.41.153(56906) COPY postgres 1210034 0.0 0.0 225644 7484 ? S 14:55 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(52134) idle postgres 1210038 0.0 0.1 5007344 30516 ? Ss 14:55 0:00 postgres: qlogs_writer QLogs 192.168.41.153(56954) COPY postgres 1210108 0.0 0.0 225708 7868 ? S 14:56 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54481) idle postgres 1210109 0.0 0.0 225700 7864 ? S 14:56 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53012) idle postgres 1210114 0.0 0.1 5006936 28984 ? Ss 14:56 0:00 postgres: qlogs_writer QLogs 192.168.41.153(57094) COPY postgres 1210127 0.0 0.0 225704 7832 ? S 14:56 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(52436) idle postgres 1210136 0.0 0.2 5007344 32884 ? Ss 14:56 0:00 postgres: qlogs_writer QLogs 192.168.41.153(57142) COPY postgres 1210163 0.0 0.0 225644 7484 ? S 14:57 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54713) idle postgres 1210210 0.0 0.0 225996 8296 ? S 14:57 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(56610) idle postgres 1210213 0.0 0.1 5007344 30580 ? Ss 14:57 0:00 postgres: qlogs_writer QLogs 192.168.41.153(57282) COPY postgres 1210233 0.0 0.1 5006936 29568 ? Ss 14:57 0:00 postgres: qlogs_writer QLogs 192.168.41.153(57326) COPY postgres 1210310 0.0 0.1 5006936 29808 ? Ss 14:58 0:00 postgres: qlogs_writer QLogs 192.168.41.153(57478) COPY postgres 1210316 0.0 0.0 225904 7480 ? S 14:58 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53118) idle postgres 1210326 0.0 0.1 5006936 29624 ? Ss 14:58 0:00 postgres: qlogs_writer QLogs 192.168.41.153(57502) COPY postgres 1210346 0.0 0.0 225644 7484 ? S 14:59 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54375) idle postgres 1210365 0.0 0.0 225748 8028 ? S 14:59 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53739) idle postgres 1210404 0.0 0.0 225688 7960 ? S 14:59 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53386) idle postgres 1210408 0.0 0.1 5007344 30988 ? Ss 14:59 0:00 postgres: qlogs_writer QLogs 192.168.41.153(57666) COPY postgres 1210429 0.0 0.2 5007344 33184 ? Ss 14:59 0:00 postgres: qlogs_writer QLogs 192.168.41.153(57714) COPY postgres 1210460 0.0 0.0 225700 7832 ? S 15:00 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54066) idle postgres 1210504 0.0 0.0 225976 7980 ? S 15:00 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54475) idle postgres 1210505 0.0 0.0 225784 8444 ? S 15:00 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53226) idle postgres 1210510 0.0 0.2 5007344 34292 ? Ss 15:00 0:00 postgres: qlogs_writer QLogs 192.168.41.153(57870) COPY postgres 1210525 0.0 0.0 225972 7944 ? S 15:00 0:00 pgpool: accept connection postgres 1210529 0.0 0.1 5006936 29448 ? Ss 15:00 0:00 postgres: qlogs_writer QLogs 192.168.41.153(57906) COPY postgres 1210613 0.0 0.2 5007344 33580 ? Ss 15:01 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58050) COPY postgres 1210630 0.0 0.1 5006936 29512 ? Ss 15:01 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58078) COPY postgres 1210680 0.0 0.0 225644 7436 ? S 15:02 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(52815) idle postgres 1210704 0.0 0.1 5006936 29628 ? Ss 15:02 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58222) COPY postgres 1210706 0.0 0.0 225696 7776 ? S 15:02 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55025) idle postgres 1210718 0.0 0.0 225720 7868 ? S 15:02 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54810) idle postgres 1210725 0.0 0.0 225712 7944 ? S 15:02 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(56246) idle postgres 1210728 0.0 0.1 5006936 29680 ? Ss 15:02 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58266) COPY postgres 1210795 0.0 0.1 5006936 29328 ? Ss 15:03 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58378) COPY postgres 1210819 0.0 0.2 5007344 33840 ? Ss 15:03 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58430) COPY postgres 1210828 0.0 0.0 225700 7848 ? S 15:04 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53437) idle postgres 1210838 0.0 0.0 225644 7484 ? S 15:04 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53278) idle postgres 1210888 0.0 0.0 225644 7484 ? S 15:04 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54865) idle postgres 1210895 0.0 0.1 5006936 29588 ? Ss 15:04 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58570) COPY postgres 1210917 0.0 0.2 5007616 33972 ? Ss 15:04 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58618) COPY postgres 1210931 0.0 0.0 225644 7484 ? S 15:05 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54580) idle postgres 1210996 0.0 0.1 5006936 29400 ? Ss 15:05 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58770) COPY postgres 1211007 0.0 0.0 225644 7484 ? S 15:05 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54634) idle postgres 1211023 0.0 0.1 5007208 29812 ? Ss 15:05 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58830) COPY postgres 1211095 0.0 0.1 5006936 31424 ? Ss 15:06 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58962) COPY postgres 1211103 0.0 0.0 225708 7856 ? S 15:06 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53848) idle postgres 1211114 0.0 0.2 5007616 33980 ? Ss 15:06 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58998) COPY postgres 1211138 0.0 0.0 225716 7948 ? S 15:07 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54347) idle postgres 1211278 0.0 0.1 5006936 29456 ? Ss 15:07 0:00 postgres: qlogs_writer QLogs 192.168.41.153(59146) COPY postgres 1211297 0.0 0.2 5007616 34412 ? Ss 15:07 0:00 postgres: qlogs_writer QLogs 192.168.41.153(59182) COPY postgres 1211372 0.0 0.1 5006936 29568 ? Ss 15:08 0:00 postgres: qlogs_writer QLogs 192.168.41.153(59334) COPY postgres 1211389 0.0 0.0 225644 7484 ? S 15:08 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54916) idle postgres 1211391 0.0 0.1 5007208 29772 ? Ss 15:08 0:00 postgres: qlogs_writer QLogs 192.168.41.153(59370) COPY postgres 1211465 0.0 0.1 5006936 29388 ? Ss 15:09 0:00 postgres: qlogs_writer QLogs 192.168.41.153(59514) COPY postgres 1211483 0.0 0.1 5007208 29508 ? Ss 15:09 0:00 postgres: qlogs_writer QLogs 192.168.41.153(59546) COPY postgres 1211503 0.0 0.0 225988 7960 ? S 15:10 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54202) idle postgres 1211560 0.0 0.1 5006936 29628 ? Ss 15:10 0:00 postgres: qlogs_writer QLogs 192.168.41.153(59698) COPY postgres 1211580 0.0 0.1 5007208 29328 ? Ss 15:10 0:00 postgres: qlogs_writer QLogs 192.168.41.153(59738) COPY postgres 1211646 0.0 0.0 225972 7892 ? S 15:11 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54538) idle postgres 1211654 0.0 0.0 225716 7920 ? S 15:11 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55962) idle postgres 1211656 0.0 0.2 5007344 34556 ? Ss 15:11 0:00 postgres: qlogs_writer QLogs 192.168.41.153(59886) COPY postgres 1211676 0.0 0.2 5007616 34440 ? Ss 15:11 0:00 postgres: qlogs_writer QLogs 192.168.41.153(59930) COPY postgres 1211747 0.0 0.1 5006936 29208 ? Ss 15:12 0:00 postgres: qlogs_writer QLogs 192.168.41.153(60062) COPY postgres 1211768 0.0 0.2 5007616 34688 ? Ss 15:12 0:00 postgres: qlogs_writer QLogs 192.168.41.153(60110) COPY postgres 1211792 0.0 0.0 225644 7436 ? S 15:13 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53695) idle postgres 1211838 0.0 0.2 5007344 35596 ? Ss 15:13 0:00 postgres: qlogs_writer QLogs 192.168.41.153(60238) COPY root 1211840 0.0 0.0 0 0 ? I 15:13 0:00 [kworker/3:1-events_power_efficient] postgres 1211842 0.0 0.0 225644 7436 ? S 15:13 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53536) idle postgres 1211857 0.0 0.2 5007616 34524 ? Ss 15:13 0:00 postgres: qlogs_writer QLogs 192.168.41.153(60270) COPY postgres 1211925 0.0 0.0 225644 7436 ? S 15:14 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55180) idle postgres 1211926 0.0 0.0 225708 7772 ? S 15:14 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55386) idle postgres 1211937 0.0 0.1 5006936 29448 ? Ss 15:14 0:00 postgres: qlogs_writer QLogs 192.168.41.153(60434) COPY postgres 1211940 0.0 0.0 225752 7948 ? S 15:14 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54147) idle postgres 1211943 0.0 0.0 225708 7940 ? S 15:14 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55807) idle postgres 1211955 0.0 0.1 5007208 29512 ? Ss 15:14 0:00 postgres: qlogs_writer QLogs 192.168.41.153(60462) COPY postgres 1211958 0.0 0.0 225700 7872 ? S 15:14 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54665) idle postgres 1212000 0.0 0.0 225644 7484 ? S 15:15 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55289) idle postgres 1212029 0.0 0.0 225672 7824 ? S 15:15 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55911) idle postgres 1212031 0.0 0.1 5006936 29692 ? Ss 15:15 0:00 postgres: qlogs_writer QLogs 192.168.41.153(60602) COPY postgres 1212050 0.0 0.2 5007616 35076 ? Ss 15:15 0:00 postgres: qlogs_writer QLogs 192.168.41.153(60638) COPY postgres 1212107 0.0 0.0 225644 7436 ? S 15:16 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55127) idle postgres 1212123 0.0 0.2 5007344 34656 ? Ss 15:16 0:00 postgres: qlogs_writer QLogs 192.168.41.153(60786) COPY postgres 1212143 0.0 0.1 5007208 29108 ? Ss 15:16 0:00 postgres: qlogs_writer QLogs 192.168.41.153(60826) COPY postgres 1212152 0.0 0.0 225948 7940 ? S 15:17 0:00 pgpool: accept connection postgres 1212153 0.0 0.0 225696 10236 ? S 15:17 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54252) idle postgres 1212218 0.0 0.1 5007208 29504 ? Ss 15:17 0:00 postgres: qlogs_writer QLogs 192.168.41.153(60982) COPY postgres 1212239 0.0 0.1 5007208 28488 ? Ss 15:17 0:00 postgres: qlogs_writer QLogs 192.168.41.153(32794) COPY postgres 1212245 0.0 0.0 225720 7868 ? S 15:18 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55446) idle postgres 1212251 0.0 0.0 225712 7780 ? S 15:18 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55498) idle postgres 1212312 0.0 0.1 5007208 29508 ? Ss 15:18 0:00 postgres: qlogs_writer QLogs 192.168.41.153(32932) COPY postgres 1212317 0.0 0.1 5006180 21040 ? Ss 15:18 0:00 postgres: qliksenserepository QSMQ 192.168.41.153(32944) idle postgres 1212337 0.0 0.1 5007208 28192 ? Ss 15:18 0:00 postgres: qlogs_writer QLogs 192.168.41.153(32988) COPY postgres 1212364 0.0 0.0 225904 7480 ? S 15:19 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55550) idle postgres 1212411 0.0 0.2 5007616 35760 ? Ss 15:19 0:00 postgres: qlogs_writer QLogs 192.168.41.153(33130) COPY postgres 1212419 0.0 0.0 225976 7868 ? S 15:19 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54398) idle postgres 1212436 0.0 0.1 5007208 28188 ? Ss 15:19 0:00 postgres: qlogs_writer QLogs 192.168.41.153(33186) COPY postgres 1212449 0.0 0.0 225700 7916 ? S 15:20 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55856) idle postgres 1212503 0.0 0.2 5007616 35292 ? Ss 15:20 0:00 postgres: qlogs_writer QLogs 192.168.41.153(33306) COPY postgres 1212528 0.0 0.2 5007616 34688 ? Ss 15:20 0:00 postgres: qlogs_writer QLogs 192.168.41.153(33366) COPY postgres 1212543 0.0 0.0 225932 7832 ? S 15:21 0:00 pgpool: accept connection postgres 1212597 0.0 0.1 5007208 31092 ? Ss 15:21 0:00 postgres: qlogs_writer QLogs 192.168.41.153(33498) COPY postgres 1212616 0.0 0.2 5007616 34212 ? Ss 15:21 0:00 postgres: qlogs_writer QLogs 192.168.41.153(33534) COPY postgres 1212639 0.0 0.0 225780 7484 ? S 15:22 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(56037) idle postgres 1212760 0.0 0.1 5006180 21116 ? Ss 15:22 0:00 postgres: qliksenserepository QSMQ 192.168.41.153(33650) idle postgres 1212783 0.0 0.2 5007616 35596 ? Ss 15:22 0:00 postgres: qlogs_writer QLogs 192.168.41.153(33698) COPY postgres 1212798 0.0 0.1 5007208 28312 ? Ss 15:22 0:00 postgres: qlogs_writer QLogs 192.168.41.153(33718) COPY postgres 1212869 0.0 0.0 225644 7484 ? S 15:23 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55755) idle postgres 1212875 0.0 0.1 5007208 29208 ? Ss 15:23 0:00 postgres: qlogs_writer QLogs 192.168.41.153(33878) COPY postgres 1212893 0.0 0.2 5007744 34720 ? Ss 15:23 0:00 postgres: qlogs_writer QLogs 192.168.41.153(33910) COPY postgres 1212933 0.0 0.0 225692 7856 ? S 15:24 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54603) idle postgres 1212957 0.0 0.0 225644 7436 ? S 15:24 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55607) idle postgres 1212974 0.0 0.2 5007616 36044 ? Ss 15:24 0:00 postgres: qlogs_writer QLogs 192.168.41.153(34074) COPY postgres 1212990 0.0 0.2 5007744 34548 ? Ss 15:24 0:00 postgres: qlogs_writer QLogs 192.168.41.153(34098) COPY postgres 1213066 0.0 0.1 5007208 29208 ? Ss 15:25 0:00 postgres: qlogs_writer QLogs 192.168.41.153(34250) COPY postgres 1213085 0.0 0.1 5007208 28008 ? Ss 15:25 0:00 postgres: qlogs_writer QLogs 192.168.41.153(34290) COPY postgres 1213156 0.0 0.1 5007208 30936 ? Ss 15:26 0:00 postgres: qlogs_writer QLogs 192.168.41.153(34430) COPY postgres 1213176 0.0 0.1 5007208 28312 ? Ss 15:26 0:00 postgres: qlogs_writer QLogs 192.168.41.153(34474) COPY postgres 1213245 0.0 0.1 5007208 29092 ? Ss 15:27 0:00 postgres: qlogs_writer QLogs 192.168.41.153(34606) COPY postgres 1213263 0.0 0.1 5007208 28612 ? Ss 15:27 0:00 postgres: qlogs_writer QLogs 192.168.41.153(34642) COPY postgres 1213337 0.0 0.2 5007616 36064 ? Ss 15:28 0:00 postgres: qlogs_writer QLogs 192.168.41.153(34794) COPY postgres 1213353 0.0 0.1 5007208 28064 ? Ss 15:28 0:00 postgres: qlogs_writer QLogs 192.168.41.153(34822) COPY postgres 1213407 0.0 0.1 5006180 21160 ? Ss 15:29 0:00 postgres: qliksenserepository QSMQ 192.168.41.153(34938) idle postgres 1213420 0.0 0.0 225968 7872 ? S 15:29 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54874) idle postgres 1213427 0.0 0.1 5007208 28508 ? Ss 15:29 0:00 postgres: qlogs_writer QLogs 192.168.41.153(34970) COPY postgres 1213445 0.0 0.1 5007208 31632 ? Ss 15:29 0:00 postgres: qlogs_writer QLogs 192.168.41.153(35006) COPY postgres 1213521 0.0 0.1 5007208 28688 ? Ss 15:30 0:00 postgres: qlogs_writer QLogs 192.168.41.153(35158) COPY postgres 1213537 0.0 0.2 5007744 35248 ? Ss 15:30 0:00 postgres: qlogs_writer QLogs 192.168.41.153(35186) COPY postgres 1213611 0.0 0.2 5007616 38156 ? Ss 15:31 0:00 postgres: qlogs_writer QLogs 192.168.41.153(35338) COPY root 1213615 0.0 0.0 0 0 ? I 15:31 0:00 [kworker/u8:0-events_unbound] postgres 1213632 0.0 0.2 5007744 38520 ? Ss 15:31 0:00 postgres: qlogs_writer QLogs 192.168.41.153(35382) COPY postgres 1213701 0.0 0.1 5007208 28676 ? Ss 15:32 0:00 postgres: qlogs_writer QLogs 192.168.41.153(35518) COPY postgres 1213723 0.0 0.1 5007208 31960 ? Ss 15:32 0:00 postgres: qlogs_writer QLogs 192.168.41.153(35570) COPY postgres 1213797 0.0 0.2 5007616 36764 ? Ss 15:33 0:00 postgres: qlogs_writer QLogs 192.168.41.153(35722) COPY postgres 1213820 0.0 0.1 5007208 32176 ? Ss 15:34 0:00 postgres: qlogs_writer QLogs 192.168.41.153(35770) COPY postgres 1213941 0.0 0.0 224604 6164 ? S 15:35 0:00 pgpool: accept connection postgres 1213954 0.0 0.0 224084 5140 ? S 15:35 0:00 pgpool: accept connection postgres 1213963 0.0 0.0 225764 7240 ? S 15:35 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54739) idle postgres 1213965 0.0 0.1 5007208 28876 ? Ss 15:35 0:00 postgres: qlogs_writer QLogs 192.168.41.153(36034) COPY postgres 1213981 0.0 0.2 5007744 39040 ? Ss 15:35 0:00 postgres: qlogs_writer QLogs 192.168.41.153(36066) COPY postgres 1214107 0.0 0.0 225904 7432 ? S 15:37 0:00 pgpool: accept connection postgres 1214263 0.0 0.0 5005908 12540 ? Ss 15:38 0:00 postgres: qliksenserepository QSMQ 192.168.41.153(36380) idle root 1214297 0.0 0.0 0 0 ? I 15:38 0:00 [kworker/u8:1-events_unbound] postgres 1214316 0.0 0.2 5007616 38356 ? Ss 15:38 0:00 postgres: qlogs_writer QLogs 192.168.41.153(36528) COPY postgres 1214321 0.0 0.2 5007744 38964 ? Ss 15:38 0:00 postgres: qlogs_writer QLogs 192.168.41.153(36548) COPY postgres 1214409 0.0 0.0 225904 7480 ? S 15:39 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54962) idle postgres 1214484 0.0 0.1 5007208 31980 ? Ss 15:40 0:00 postgres: qlogs_writer QLogs 192.168.41.153(36856) COPY postgres 1214696 0.0 0.0 224084 5200 ? S 15:43 0:00 pgpool: accept connection root 1214730 0.0 0.0 0 0 ? I 15:43 0:00 [kworker/2:1-mm_percpu_wq] postgres 1215005 0.0 0.2 5007336 34148 ? Ss 15:46 0:00 postgres: qlogs_writer QLogs 192.168.41.153(37832) COPY postgres 1215007 0.0 0.2 5007744 38320 ? Ss 15:46 0:00 postgres: qlogs_writer QLogs 192.168.41.153(37840) COPY root 1215018 0.0 0.0 0 0 ? I 15:46 0:00 [kworker/3:0-mm_percpu_wq] postgres 1215118 0.0 0.0 224068 5260 ? S 15:47 0:00 pgpool: accept connection root 1215329 0.0 0.0 0 0 ? I 15:50 0:00 [kworker/2:0-events] root 1215406 0.0 0.0 0 0 ? I 15:52 0:00 [kworker/3:2-events] postgres 1215628 0.0 0.0 224084 5140 ? S 15:53 0:00 pgpool: accept connection postgres 1215840 0.0 0.0 61604 4124 pts/1 R+ 15:55 0:00 ps -aux |
|
|
> Additional I note that pgpool don't delete connection which is in idle status after copy status Do you see something like in the pgpool log? unable to read data child connection forced to terminate due to client_idle_limit:30 is reached If so, "client_idle_limit = 30" may not be short enough and pgpool is occupied with idle clients. In this case you should decrease client_idle_limit so that idle frontend be disconnected earlier. |
|
|
I'm understand what you wrote "If so, client_idle_limit = 30" may not be short enough and pgpool is occupied with idle clients. In this case you should decrease client_idle_limit so that idle frontend be disconnected earlier." but I observed one process with idle status and after the time has elapsed of parameter client_idle_limit, connection isn't releasing My pgpool log in attachement |
|
|
> but I observed one process with idle status and after the time has elapsed of parameter client_idle_limit, connection isn't releasing From the log file you uploaded, client_idle_limit definitely works. For example: Dec 30 10:14:38 QSDB01V pgpool[1176573]: [2408-1] 2020-12-30 10:14:38: pid 1176573: ERROR: unable to read data Dec 30 10:14:38 QSDB01V pgpool[1176573]: [2408-2] 2020-12-30 10:14:38: pid 1176573: DETAIL: child connection forced to terminate due to client_idle_limit:15 is reached So I wonder how did you know "after the time has elapsed". If you are using a wall clock, it is possible that you missed new client connection arrives after the client_idle_limit passed and the timer was reset. To know it actually happens, you could turn on log_connections. |
|
|
In attachement pgpool log with log_connection |
|
|
I have looked into pgpool-2.log. I think client_idle_limit is working as expected. For example below are particular log lines regarding pgpool child pid 1341836. Line 81543 and 81546 show that new clients arrived and they exited very soon. Looks good. However on line 81590 new client arrived but it shit for about 30 seconds and then killed due client_idle_limit reached on line 81560 and 81561. So in this 30 seconds other clients cannot connect to pgpool. This is your issue. I think what you should do is, fixing client application to not sit long time without doing anything. Also you may want to shorten client_idle_limit (the minimum is 1 second). t-ishii$ grep -n 1341836 pgpool-2.log 81542:Dec 31 15:51:20 QSDB01V pgpool[1188224]: [3893-1] 2020-12-31 15:51:20: pid 1188224: LOG: fork a new child process with pid: 1341836 81543:Dec 31 15:51:20 QSDB01V pgpool[1341836]: [3893-1] 2020-12-31 15:51:20: pid 1341836: LOG: new connection received 81544:Dec 31 15:51:20 QSDB01V pgpool[1341836]: [3893-2] 2020-12-31 15:51:20: pid 1341836: DETAIL: connecting host=192.168.41.152 port=63344 81545:Dec 31 15:51:20 QSDB01V pgpool[1341836]: [3894-1] 2020-12-31 15:51:20: pid 1341836: ERROR: unable to flush data to frontend 81546:Dec 31 15:51:20 QSDB01V pgpool[1341836]: [3895-1] 2020-12-31 15:51:20: pid 1341836: LOG: new connection received 81547:Dec 31 15:51:20 QSDB01V pgpool[1341836]: [3895-2] 2020-12-31 15:51:20: pid 1341836: DETAIL: connecting host=192.168.41.151 port=52334 81548:Dec 31 15:51:30 QSDB01V pgpool[1341836]: [3896-1] 2020-12-31 15:51:30: pid 1341836: LOG: new connection received 81549:Dec 31 15:51:30 QSDB01V pgpool[1341836]: [3896-2] 2020-12-31 15:51:30: pid 1341836: DETAIL: connecting host=192.168.41.151 port=52336 81550:Dec 31 15:51:40 QSDB01V pgpool[1341836]: [3897-1] 2020-12-31 15:51:40: pid 1341836: LOG: new connection received 81551:Dec 31 15:51:40 QSDB01V pgpool[1341836]: [3897-2] 2020-12-31 15:51:40: pid 1341836: DETAIL: connecting host=192.168.41.151 port=52337 81572:Dec 31 15:52:14 QSDB01V pgpool[1341836]: [3898-1] 2020-12-31 15:52:14: pid 1341836: ERROR: unable to read data 81573:Dec 31 15:52:14 QSDB01V pgpool[1341836]: [3898-2] 2020-12-31 15:52:14: pid 1341836: DETAIL: child connection forced to terminate due to client_idle_limit:30 is reached 81574:Dec 31 15:52:14 QSDB01V pgpool[1341836]: [3899-1] 2020-12-31 15:52:14: pid 1341836: LOG: new connection received 81575:Dec 31 15:52:14 QSDB01V pgpool[1341836]: [3899-2] 2020-12-31 15:52:14: pid 1341836: DETAIL: connecting host=192.168.41.152 port=63356 81576:Dec 31 15:52:14 QSDB01V pgpool[1341836]: [3900-1] 2020-12-31 15:52:14: pid 1341836: ERROR: unable to flush data to frontend 81577:Dec 31 15:52:14 QSDB01V pgpool[1341836]: [3901-1] 2020-12-31 15:52:14: pid 1341836: LOG: new connection received 81578:Dec 31 15:52:14 QSDB01V pgpool[1341836]: [3901-2] 2020-12-31 15:52:14: pid 1341836: DETAIL: connecting host=192.168.41.151 port=52351 81579:Dec 31 15:52:14 QSDB01V pgpool[1341836]: [3902-1] 2020-12-31 15:52:14: pid 1341836: ERROR: unable to flush data to frontend 81580:Dec 31 15:52:14 QSDB01V pgpool[1341836]: [3903-1] 2020-12-31 15:52:14: pid 1341836: LOG: new connection received 81581:Dec 31 15:52:14 QSDB01V pgpool[1341836]: [3903-2] 2020-12-31 15:52:14: pid 1341836: DETAIL: connecting host=192.168.41.152 port=63358 81582:Dec 31 15:52:14 QSDB01V pgpool[1341836]: [3904-1] 2020-12-31 15:52:14: pid 1341836: ERROR: unable to flush data to frontend 81583:Dec 31 15:52:14 QSDB01V pgpool[1341836]: [3905-1] 2020-12-31 15:52:14: pid 1341836: LOG: new connection received 81584:Dec 31 15:52:14 QSDB01V pgpool[1341836]: [3905-2] 2020-12-31 15:52:14: pid 1341836: DETAIL: connecting host=192.168.41.152 port=63362 81585:Dec 31 15:52:45 QSDB01V pgpool[1341836]: [3906-1] 2020-12-31 15:52:45: pid 1341836: ERROR: unable to read data 81586:Dec 31 15:52:45 QSDB01V pgpool[1341836]: [3906-2] 2020-12-31 15:52:45: pid 1341836: DETAIL: child connection forced to terminate due to client_idle_limit:30 is reached 81587:Dec 31 15:52:45 QSDB01V pgpool[1341836]: [3907-1] 2020-12-31 15:52:45: pid 1341836: LOG: new connection received 81588:Dec 31 15:52:45 QSDB01V pgpool[1341836]: [3907-2] 2020-12-31 15:52:45: pid 1341836: DETAIL: connecting host=192.168.41.151 port=52356 81589:Dec 31 15:52:45 QSDB01V pgpool[1341836]: [3908-1] 2020-12-31 15:52:45: pid 1341836: ERROR: unable to flush data to frontend 81590:Dec 31 15:52:45 QSDB01V pgpool[1341836]: [3909-1] 2020-12-31 15:52:45: pid 1341836: LOG: new connection received 81591:Dec 31 15:52:45 QSDB01V pgpool[1341836]: [3909-2] 2020-12-31 15:52:45: pid 1341836: DETAIL: connecting host=192.168.41.152 port=63364 81600:Dec 31 15:53:17 QSDB01V pgpool[1341836]: [3910-1] 2020-12-31 15:53:17: pid 1341836: ERROR: unable to read data 81601:Dec 31 15:53:17 QSDB01V pgpool[1341836]: [3910-2] 2020-12-31 15:53:17: pid 1341836: DETAIL: child connection forced to terminate due to client_idle_limit:30 is reached 81602:Dec 31 15:53:17 QSDB01V pgpool[1341836]: [3911-1] 2020-12-31 15:53:17: pid 1341836: LOG: new connection received 81603:Dec 31 15:53:17 QSDB01V pgpool[1341836]: [3911-2] 2020-12-31 15:53:17: pid 1341836: DETAIL: connecting host=192.168.41.152 port=63370 |
|
|
While looking at the log, I noticed that child_max_connections sometimes does not work as expected. It seems you set the parameter to 4, and pgpool process should exit after 4 times connections from frontend. However, when ERROR occurs, it seems the count is reset. After inspecting the source code I found a bug and fixed (will appear next minor releases). Note that this does not relate to your issue, though. |
|
|
ok, I change client_idle_limit and connection_life_time on 1. I change connection_pool = off too. I will observe now pgpool. Additional I sent question about long time connection in application to outside support. But I note all process postgres is COPY status and pgpool process is idle status, this is strange. What are you think? ps -aux in attachement psaux (60,794 bytes)
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND root 1 0.0 0.0 244724 11204 ? Ss 2020 0:07 /usr/lib/systemd/systemd --switched-root --system --deserialize 17 root 2 0.0 0.0 0 0 ? S 2020 0:00 [kthreadd] root 3 0.0 0.0 0 0 ? I< 2020 0:00 [rcu_gp] root 4 0.0 0.0 0 0 ? I< 2020 0:00 [rcu_par_gp] root 6 0.0 0.0 0 0 ? I< 2020 0:00 [kworker/0:0H-kblockd] root 9 0.0 0.0 0 0 ? I< 2020 0:00 [mm_percpu_wq] root 10 0.0 0.0 0 0 ? S 2020 0:01 [ksoftirqd/0] root 11 0.0 0.0 0 0 ? I 2020 2:39 [rcu_sched] root 12 0.0 0.0 0 0 ? S 2020 0:00 [migration/0] root 13 0.0 0.0 0 0 ? S 2020 0:01 [watchdog/0] root 14 0.0 0.0 0 0 ? S 2020 0:00 [cpuhp/0] root 15 0.0 0.0 0 0 ? S 2020 0:00 [cpuhp/1] root 16 0.0 0.0 0 0 ? S 2020 0:01 [watchdog/1] root 17 0.0 0.0 0 0 ? S 2020 0:00 [migration/1] root 18 0.0 0.0 0 0 ? S 2020 0:01 [ksoftirqd/1] root 20 0.0 0.0 0 0 ? I< 2020 0:00 [kworker/1:0H] root 21 0.0 0.0 0 0 ? S 2020 0:00 [cpuhp/2] root 22 0.0 0.0 0 0 ? S 2020 0:00 [watchdog/2] root 23 0.0 0.0 0 0 ? S 2020 0:00 [migration/2] root 24 0.0 0.0 0 0 ? S 2020 0:01 [ksoftirqd/2] root 26 0.0 0.0 0 0 ? I< 2020 0:00 [kworker/2:0H-kblockd] root 27 0.0 0.0 0 0 ? S 2020 0:00 [cpuhp/3] root 28 0.0 0.0 0 0 ? S 2020 0:01 [watchdog/3] root 29 0.0 0.0 0 0 ? S 2020 0:00 [migration/3] root 30 0.0 0.0 0 0 ? S 2020 0:01 [ksoftirqd/3] root 32 0.0 0.0 0 0 ? I< 2020 0:00 [kworker/3:0H-kblockd] root 37 0.0 0.0 0 0 ? S 2020 0:00 [kdevtmpfs] root 38 0.0 0.0 0 0 ? I< 2020 0:00 [netns] root 39 0.0 0.0 0 0 ? S 2020 0:00 [kauditd] root 40 0.0 0.0 0 0 ? S 2020 0:00 [khungtaskd] root 41 0.0 0.0 0 0 ? S 2020 0:00 [oom_reaper] root 42 0.0 0.0 0 0 ? I< 2020 0:00 [writeback] root 43 0.0 0.0 0 0 ? S 2020 0:00 [kcompactd0] root 44 0.0 0.0 0 0 ? SN 2020 0:00 [ksmd] root 45 0.0 0.0 0 0 ? SN 2020 0:23 [khugepaged] root 46 0.0 0.0 0 0 ? I< 2020 0:00 [crypto] root 47 0.0 0.0 0 0 ? I< 2020 0:00 [kintegrityd] root 48 0.0 0.0 0 0 ? I< 2020 0:00 [kblockd] root 49 0.0 0.0 0 0 ? I< 2020 0:00 [blkcg_punt_bio] root 50 0.0 0.0 0 0 ? I< 2020 0:00 [tpm_dev_wq] root 51 0.0 0.0 0 0 ? I< 2020 0:00 [md] root 52 0.0 0.0 0 0 ? I< 2020 0:00 [edac-poller] root 53 0.0 0.0 0 0 ? S 2020 0:00 [watchdogd] root 54 0.0 0.0 0 0 ? I< 2020 0:00 [pm_wq] root 77 0.0 0.0 0 0 ? S 2020 0:00 [kswapd0] root 170 0.0 0.0 0 0 ? I< 2020 0:00 [kthrotld] root 171 0.0 0.0 0 0 ? S 2020 0:00 [irq/24-pciehp] root 172 0.0 0.0 0 0 ? S 2020 0:00 [irq/25-pciehp] root 173 0.0 0.0 0 0 ? S 2020 0:00 [irq/26-pciehp] root 174 0.0 0.0 0 0 ? S 2020 0:00 [irq/27-pciehp] root 175 0.0 0.0 0 0 ? S 2020 0:00 [irq/28-pciehp] root 176 0.0 0.0 0 0 ? S 2020 0:00 [irq/29-pciehp] root 177 0.0 0.0 0 0 ? S 2020 0:00 [irq/30-pciehp] root 178 0.0 0.0 0 0 ? S 2020 0:00 [irq/31-pciehp] root 179 0.0 0.0 0 0 ? S 2020 0:00 [irq/32-pciehp] root 180 0.0 0.0 0 0 ? S 2020 0:00 [irq/33-pciehp] root 181 0.0 0.0 0 0 ? S 2020 0:00 [irq/34-pciehp] root 182 0.0 0.0 0 0 ? S 2020 0:00 [irq/35-pciehp] root 183 0.0 0.0 0 0 ? S 2020 0:00 [irq/36-pciehp] root 184 0.0 0.0 0 0 ? S 2020 0:00 [irq/37-pciehp] root 185 0.0 0.0 0 0 ? S 2020 0:00 [irq/38-pciehp] root 186 0.0 0.0 0 0 ? S 2020 0:00 [irq/39-pciehp] root 187 0.0 0.0 0 0 ? S 2020 0:00 [irq/40-pciehp] root 188 0.0 0.0 0 0 ? S 2020 0:00 [irq/41-pciehp] root 189 0.0 0.0 0 0 ? S 2020 0:00 [irq/42-pciehp] root 190 0.0 0.0 0 0 ? S 2020 0:00 [irq/43-pciehp] root 191 0.0 0.0 0 0 ? S 2020 0:00 [irq/44-pciehp] root 192 0.0 0.0 0 0 ? S 2020 0:00 [irq/45-pciehp] root 193 0.0 0.0 0 0 ? S 2020 0:00 [irq/46-pciehp] root 194 0.0 0.0 0 0 ? S 2020 0:00 [irq/47-pciehp] root 195 0.0 0.0 0 0 ? S 2020 0:00 [irq/48-pciehp] root 196 0.0 0.0 0 0 ? S 2020 0:00 [irq/49-pciehp] root 197 0.0 0.0 0 0 ? S 2020 0:00 [irq/50-pciehp] root 198 0.0 0.0 0 0 ? S 2020 0:00 [irq/51-pciehp] root 199 0.0 0.0 0 0 ? S 2020 0:00 [irq/52-pciehp] root 200 0.0 0.0 0 0 ? S 2020 0:00 [irq/53-pciehp] root 201 0.0 0.0 0 0 ? S 2020 0:00 [irq/54-pciehp] root 202 0.0 0.0 0 0 ? S 2020 0:00 [irq/55-pciehp] root 204 0.0 0.0 0 0 ? I< 2020 0:00 [acpi_thermal_pm] root 205 0.0 0.0 0 0 ? I< 2020 0:00 [kmpath_rdacd] root 206 0.0 0.0 0 0 ? I< 2020 0:00 [kaluad] root 207 0.0 0.0 0 0 ? I< 2020 0:00 [ipv6_addrconf] root 208 0.0 0.0 0 0 ? I< 2020 0:00 [kstrp] root 533 0.0 0.0 0 0 ? I< 2020 0:00 [ata_sff] root 535 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_0] root 536 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_0] root 537 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_1] root 538 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_1] root 539 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_2] root 540 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_2] root 541 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_3] root 543 0.0 0.0 0 0 ? I< 2020 0:00 [vmw_pvscsi_wq_2] root 544 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_3] root 546 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_4] root 549 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_4] root 551 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_5] root 552 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_5] root 553 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_6] root 555 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_6] root 557 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_7] root 558 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_7] root 559 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_8] root 560 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_8] root 561 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_9] root 563 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_9] root 564 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_10] root 566 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_10] root 567 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_11] root 568 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_11] root 569 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_12] root 570 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_12] root 571 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_13] root 572 0.0 0.0 0 0 ? S 2020 0:29 [irq/16-vmwgfx] root 573 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_13] root 575 0.0 0.0 0 0 ? I< 2020 0:00 [ttm_swap] root 576 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_14] root 577 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_14] root 579 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_15] root 580 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_15] root 581 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_16] root 583 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_16] root 585 0.0 0.0 0 0 ? I< 2020 0:00 [kworker/0:1H-xfs-log/dm-0] root 586 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_17] root 588 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_17] root 591 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_18] root 592 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_18] root 593 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_19] root 594 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_19] root 595 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_20] root 596 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_20] root 597 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_21] root 598 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_21] root 601 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_22] root 603 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_22] root 606 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_23] root 609 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_23] root 612 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_24] root 615 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_24] root 618 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_25] root 621 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_25] root 624 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_26] root 627 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_26] root 629 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_27] root 633 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_27] root 636 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_28] root 639 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_28] root 644 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_29] root 646 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_29] root 650 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_30] root 651 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_30] root 656 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_31] root 657 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_31] root 659 0.0 0.0 0 0 ? S 2020 0:00 [scsi_eh_32] root 660 0.0 0.0 0 0 ? I< 2020 0:00 [scsi_tmf_32] root 687 0.0 0.0 0 0 ? I< 2020 0:01 [kworker/3:1H-kblockd] root 689 0.0 0.0 0 0 ? I< 2020 0:02 [kworker/2:1H-xfs-log/dm-0] root 690 0.0 0.0 0 0 ? I< 2020 0:01 [kworker/1:1H-kblockd] root 725 0.0 0.0 0 0 ? I< 2020 0:00 [kdmflush] root 758 0.0 0.0 0 0 ? I< 2020 0:00 [xfsalloc] root 760 0.0 0.0 0 0 ? I< 2020 0:00 [xfs_mru_cache] root 761 0.0 0.0 0 0 ? I< 2020 0:00 [xfs-buf/dm-0] root 762 0.0 0.0 0 0 ? I< 2020 0:00 [xfs-conv/dm-0] root 763 0.0 0.0 0 0 ? I< 2020 0:00 [xfs-cil/dm-0] root 764 0.0 0.0 0 0 ? I< 2020 0:00 [xfs-reclaim/dm-] root 765 0.0 0.0 0 0 ? I< 2020 0:00 [xfs-eofblocks/d] root 766 0.0 0.0 0 0 ? I< 2020 0:00 [xfs-log/dm-0] root 767 0.0 0.0 0 0 ? S 2020 1:34 [xfsaild/dm-0] root 863 0.0 1.2 332684 210140 ? Ss 2020 0:24 /usr/lib/systemd/systemd-journald root 901 0.0 0.0 109480 10248 ? Ss 2020 0:01 /usr/lib/systemd/systemd-udevd root 970 0.0 0.0 0 0 ? I< 2020 0:00 [nfit] root 1007 0.0 0.0 0 0 ? S 2020 0:00 [jbd2/sda1-8] root 1008 0.0 0.0 0 0 ? I< 2020 0:00 [ext4-rsv-conver] root 1028 0.0 0.0 76964 1996 ? S<sl 2020 0:00 /sbin/auditd polkitd 1051 0.0 0.1 1763312 24384 ? Ssl 2020 0:00 /usr/lib/polkit-1/polkitd --no-debug dbus 1054 0.0 0.0 76872 5912 ? Ss 2020 0:01 /usr/bin/dbus-daemon --system --address=systemd: --nofork --nopidfile --systemd-activation --syslog-only root 1056 0.0 0.1 392016 19028 ? Ssl 2020 0:14 /usr/sbin/NetworkManager --no-daemon root 1057 0.0 0.0 124956 5420 ? Ssl 2020 0:29 /usr/sbin/irqbalance --foreground root 1058 0.0 0.0 230784 15028 ? Ss 2020 0:01 /usr/sbin/sssd -i --logger=files root 1060 0.0 0.0 86440 11780 ? Ss 2020 0:00 /usr/bin/VGAuthService -s root 1061 0.0 0.0 278616 11476 ? Ssl 2020 10:16 /usr/bin/vmtoolsd rngd 1062 0.0 0.0 381304 8708 ? Ssl 2020 0:44 /sbin/rngd -f --fill-watermark=0 chrony 1064 0.0 0.0 30320 2656 ? S 2020 0:04 /usr/sbin/chronyd root 1089 0.0 0.1 416568 30328 ? Ssl 2020 1:29 /usr/libexec/platform-python -Es /usr/sbin/tuned -l -P root 1091 0.0 0.0 92284 7756 ? Ss 2020 0:00 /usr/sbin/sshd -D -oCiphers=aes256-gcm@openssh.com,chacha20-poly1305@openssh.com,aes256-ctr,aes256-cbc,aes128-gcm@openssh.com,aes128-ctr,aes128-cbc -oMACs=hmac-sha2-256-etm@openssh.com,hmac-sha1-etm@openssh.com,umac-128-etm@openssh.com,hmac-sha2-512-etm@openssh.com,hmac-sha2-256,hmac-sha1,umac-128@openssh.com,hmac-sha2-512 -oGSSAPIKexAlgorithms=gss-curve25519-sha256-,gss-nistp256-sha256-,gss-group14-sha256-,gss-group16-sha512-,gss-gex-sha1-,gss-group14-sha1- -oKexAlgorithms=curve25519-sha256,curve25519-sha256@libssh.org,ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,diffie-hellman-group-exchange-sha256,diffie-hellman-group14-sha256,diffie-hellman-group16-sha512,diffie-hellman-group18-sha512,diffie-hellman-group-exchange-sha1,diffie-hellman-group14-sha1 -oHostKeyAlgorithms=ecdsa-sha2-nistp256,ecdsa-sha2-nistp256-cert-v01@openssh.com,ecdsa-sha2-nistp384,ecdsa-sha2-nistp384-cert-v01@openssh.com,ecdsa-sha2-nistp521,ecdsa-sha2-nistp521-cert-v01@openssh.com,ssh-ed25519,ssh-ed25519-cert-v01@openssh.com,rsa-sha2-256,rsa-sha2-256-cert-v01@openssh.com,rsa-sha2-512,rsa-sha2-512-cert-v01@openssh.com,ssh-rsa,ssh-rsa-cert-v01@openssh.com -oPubkeyAcceptedKeyTypes=ecdsa-sha2-nistp256,ecdsa-sha2-nistp256-cert-v01@openssh.com,ecdsa-sha2-nistp384,ecdsa-sha2-nistp384-cert-v01@openssh.com,ecdsa-sha2-nistp521,ecdsa-sha2-nistp521-cert-v01@openssh.com,ssh-ed25519,ssh-ed25519-cert-v01@openssh.com,rsa-sha2-256,rsa-sha2-256-cert-v01@openssh.com,rsa-sha2-512,rsa-sha2-512-cert-v01@openssh.com,ssh-rsa,ssh-rsa-cert-v01@openssh.com -oCASignatureAlgorithms=ecdsa-sha2-nistp256,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521,ssh-ed25519,rsa-sha2-256,rsa-sha2-512,ssh-rsa root 1092 0.0 0.0 51328 4552 ? Ss 2020 0:00 /usr/sbin/oddjobd -n -p /var/run/oddjobd.pid -t 300 root 1099 0.0 0.0 41748 2280 ? Ss 2020 0:00 /usr/bin/rhsmcertd root 1108 0.0 0.0 227576 15228 ? S 2020 0:05 /usr/libexec/sssd/sssd_be --domain implicit_files --uid 0 --gid 0 --logger=files root 1109 0.0 0.1 374052 28116 ? S 2020 0:12 /usr/libexec/sssd/sssd_be --domain rossmann.com.pl --uid 0 --gid 0 --logger=files root 1121 0.0 0.3 437516 60120 ? Ssl 2020 0:47 /usr/sbin/rsyslogd -n root 1126 0.0 0.2 241680 45460 ? S 2020 0:07 /usr/libexec/sssd/sssd_nss --uid 0 --gid 0 --logger=files root 1127 0.0 0.0 207344 14020 ? S 2020 0:05 /usr/libexec/sssd/sssd_pam --uid 0 --gid 0 --logger=files root 1141 0.0 0.0 97512 8348 ? Ss 2020 0:01 /usr/lib/systemd/systemd-logind root 1146 0.0 0.0 36920 3668 ? Ss 2020 0:00 /usr/sbin/crond -n root 1153 0.0 0.0 13628 1572 tty1 Ss+ 2020 0:00 /sbin/agetty -o -p -- \u --noclear tty1 linux adm.lcz+ 1631 0.0 0.0 93872 9632 ? Ss 2020 0:00 /usr/lib/systemd/systemd --user adm.lcz+ 1634 0.0 0.0 180472 2752 ? S 2020 0:00 (sd-pam) postgres 129837 0.0 0.8 5004900 139188 ? S 2020 10:04 /usr/pgsql-11/bin/postgres -D /var/lib/pgsql/11/data postgres 129838 0.0 0.0 139916 3912 ? Ss 2020 0:00 postgres: logger postgres 129840 0.0 2.4 5005152 401260 ? Ss 2020 0:44 postgres: checkpointer postgres 129841 0.0 0.3 5005052 59824 ? Ss 2020 0:09 postgres: background writer postgres 129842 0.0 0.1 5004900 21632 ? Ss 2020 1:41 postgres: walwriter postgres 129843 0.0 0.0 5005648 7900 ? Ss 2020 0:28 postgres: autovacuum launcher postgres 129844 0.0 0.0 142036 4824 ? Ss 2020 0:01 postgres: archiver last was 0000000700000000000000A3 postgres 129845 0.0 0.0 142628 5000 ? Ss 2020 3:50 postgres: stats collector postgres 129846 0.0 0.0 5005328 6408 ? Ss 2020 0:00 postgres: logical replication launcher postgres 130204 0.0 0.0 5006028 10836 ? Ss 2020 0:25 postgres: walsender repl 192.168.41.154(56772) streaming 0/A491C0F8 root 725522 0.0 0.1 332532 18408 ? Ssl 2020 0:13 /opt/commvault/Base/cvlaunchd root 725523 0.0 1.4 2643816 234188 ? Ssl 2020 2:00 /opt/commvault/Base/cvd root 725525 0.0 0.0 177232 10696 ? Ssl 2020 0:15 /opt/commvault/Base/cvfwd root 1170588 0.0 0.0 172940 11996 ? Ss 2020 0:01 sshd: adm.lczajkowski [priv] adm.lcz+ 1170608 0.0 0.0 172940 6344 ? S 2020 0:01 sshd: adm.lczajkowski@pts/1 adm.lcz+ 1170609 0.0 0.0 24092 4040 pts/1 Ss 2020 0:00 -bash postgres 1188224 0.0 0.4 223552 67636 ? Ss 2020 0:04 /usr/bin/pgpool -f /etc/pgpool-II/pgpool.conf -n postgres 1188226 0.0 0.0 223548 3476 ? S 2020 0:15 pgpool: watchdog postgres 1188229 0.0 0.0 223428 3020 ? S 2020 0:00 pgpool: lifecheck postgres 1188232 0.0 0.0 225640 7468 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55339) idle postgres 1188237 0.0 0.0 223428 1160 ? S 2020 0:04 pgpool: heartbeat receiver postgres 1188239 0.0 0.0 223428 1160 ? S 2020 0:11 pgpool: heartbeat sender postgres 1188241 0.0 0.0 223428 1160 ? S 2020 0:04 pgpool: heartbeat receiver postgres 1188243 0.0 0.0 223428 1160 ? S 2020 0:11 pgpool: heartbeat sender postgres 1188249 0.0 0.0 225640 7468 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53487) idle postgres 1188276 0.0 0.0 225640 7416 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53070) idle postgres 1188358 0.0 0.0 225640 7424 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53642) idle postgres 1188365 0.0 0.0 225704 7828 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55077) idle postgres 1188385 0.0 0.0 223424 1200 ? S 2020 0:00 pgpool: PCP: wait for connection request postgres 1188386 0.0 0.0 223548 3236 ? S 2020 0:12 pgpool: worker process postgres 1188387 0.0 0.0 223548 3396 ? S 2020 0:12 pgpool: health check process(0) postgres 1188388 0.0 0.0 223548 3396 ? S 2020 0:14 pgpool: health check process(1) postgres 1189349 0.0 0.0 226256 7872 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(58784) idle postgres 1192505 0.0 0.0 225904 7432 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55233) idle postgres 1197743 0.0 0.0 225704 7852 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53901) idle postgres 1198933 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51566) idle postgres 1199764 0.0 0.0 225980 7868 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54299) idle postgres 1201224 0.0 0.0 224604 6372 ? S 2020 1:38 pgpool: qlogs_writer QLogs 192.168.26.239(58555) idle postgres 1201494 0.5 0.1 5008892 29840 ? Ss 2020 39:10 postgres: qlogs_writer QLogs 192.168.41.153(42352) idle postgres 1201637 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(50794) idle postgres 1202019 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53360) idle postgres 1202241 0.0 0.0 225644 7116 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(50955) idle postgres 1203230 0.0 0.0 225736 8064 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55702) idle postgres 1204346 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(52922) idle postgres 1205254 0.0 0.0 225644 7436 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53335) idle postgres 1205750 0.0 0.0 225752 8144 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(50644) idle postgres 1205846 0.0 0.0 225700 7920 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53794) idle postgres 1206532 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(52608) idle postgres 1206554 0.0 0.0 225644 7116 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(50696) idle postgres 1206608 0.0 0.0 225644 7172 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53002) idle postgres 1206611 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(50744) idle postgres 1206710 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(52836) idle postgres 1206925 0.0 0.0 225968 7788 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(52684) idle postgres 1207154 0.0 0.0 225704 7856 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(56115) idle postgres 1207156 0.0 0.0 225712 7860 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51294) idle postgres 1207169 0.0 0.0 225904 7480 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(50535) idle postgres 1207241 0.0 0.1 5007344 27452 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(52028) COPY postgres 1207244 0.0 0.0 225944 7812 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(52786) idle postgres 1207253 0.0 0.1 5006180 20996 ? Ss 2020 0:00 postgres: qliksenserepository QSMQ 192.168.41.153(52056) idle postgres 1207275 0.0 0.1 5007456 27420 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(52102) COPY postgres 1207341 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(52735) idle postgres 1207343 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51242) idle postgres 1207372 0.0 0.1 5006804 26552 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(52282) COPY postgres 1207396 0.0 0.1 5006804 26496 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(52324) COPY postgres 1207473 0.0 0.1 5007344 27700 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(52476) COPY postgres 1207485 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51345) idle postgres 1207493 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(50848) idle postgres 1207498 0.0 0.1 5006804 26616 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(52518) COPY postgres 1207508 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53415) idle postgres 1207574 0.0 0.1 5006804 26552 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(52662) COPY postgres 1207580 0.0 0.1 5006180 20992 ? Ss 2020 0:00 postgres: qliksenserepository QSMQ 192.168.41.153(52680) idle postgres 1207598 0.0 0.1 5007344 27960 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(52704) COPY postgres 1207663 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(52904) idle postgres 1207674 0.0 0.1 5007344 27840 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(52842) COPY postgres 1207696 0.0 0.0 225644 7116 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53100) idle postgres 1207698 0.0 0.1 5007344 28240 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(52896) COPY postgres 1207717 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(52953) idle postgres 1207724 0.0 0.0 225704 7864 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51139) idle postgres 1207775 0.0 0.1 5006936 26556 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(53034) COPY postgres 1207777 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(50904) idle postgres 1207799 0.0 0.1 5007344 28188 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(53088) COPY postgres 1207805 0.0 0.0 225720 7868 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51060) idle postgres 1207823 0.0 0.0 225712 7780 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53470) idle postgres 1207865 0.0 0.0 225708 7788 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(52598) idle postgres 1207876 0.0 0.1 5006936 26616 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(53220) COPY postgres 1207880 0.0 0.0 225712 7804 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51395) idle postgres 1207897 0.0 0.1 5007344 28352 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(53256) COPY postgres 1207924 0.0 0.0 225644 7436 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53156) idle postgres 1207986 0.0 0.1 5006936 26612 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(53432) COPY postgres 1207999 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51520) idle postgres 1208003 0.0 0.1 5006936 26612 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(53456) COPY postgres 1208015 0.0 0.0 225644 7116 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51008) idle postgres 1208019 0.0 0.0 225720 7880 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53750) idle postgres 1208047 0.0 0.0 225708 7852 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53574) idle postgres 1208168 0.0 0.0 225708 7860 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55660) idle postgres 1208175 0.0 0.1 5006936 26668 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(53612) COPY postgres 1208184 0.0 0.0 225644 7116 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53054) idle postgres 1208194 0.0 0.1 5006936 26612 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(53640) COPY postgres 1208241 0.0 0.0 225644 7116 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51194) idle postgres 1208273 0.0 0.1 5007344 28356 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(53796) COPY postgres 1208289 0.0 0.1 5006936 26676 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(53818) COPY postgres 1208370 0.0 0.1 5007344 28540 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(53990) COPY postgres 1208389 0.0 0.1 5006936 26676 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(54018) COPY postgres 1208395 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51469) idle postgres 1208399 0.0 0.0 225696 7868 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53898) idle postgres 1208468 0.0 0.1 5007344 28864 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(54166) COPY postgres 1208478 0.0 0.0 225644 7436 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53208) idle postgres 1208491 0.0 0.1 5006936 26792 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(54206) COPY postgres 1208515 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53256) idle postgres 1208565 0.0 0.0 225964 7852 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51624) idle postgres 1208567 0.0 0.1 5006936 26620 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(54338) COPY postgres 1208588 0.0 0.1 5006936 26612 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(54382) COPY postgres 1208664 0.0 0.1 5006936 29096 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(54530) COPY postgres 1208672 0.0 0.0 225644 7436 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53309) idle postgres 1208685 0.0 0.1 5006936 26624 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(54566) COPY postgres 1208690 0.0 0.0 225964 7856 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54011) idle postgres 1208694 0.0 0.0 225700 7852 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54535) idle postgres 1208697 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53799) idle postgres 1208762 0.0 0.1 5006936 29460 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(54710) COPY postgres 1208782 0.0 0.1 5007344 29132 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(54754) COPY postgres 1208849 0.0 0.0 226124 8184 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(55234) idle postgres 1208853 0.0 0.0 225644 7436 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53700) idle postgres 1208856 0.0 0.1 5007344 29156 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(54894) COPY postgres 1208878 0.0 0.1 5006936 26812 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(54942) COPY postgres 1208920 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51827) idle postgres 1208957 0.0 0.1 5006936 29160 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(55094) COPY postgres 1208958 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53523) idle postgres 1208979 0.0 0.1 5006936 26760 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(55134) COPY postgres 1208995 0.0 0.0 225644 7432 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53647) idle postgres 1209054 0.0 0.1 5007344 29364 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(55278) COPY postgres 1209062 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51727) idle postgres 1209074 0.0 0.1 5006936 26680 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(55314) COPY postgres 1209116 0.0 0.0 225644 7436 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51674) idle postgres 1209128 0.0 0.0 225712 7868 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(52082) idle postgres 1209150 0.0 0.1 5007344 29448 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(55454) COPY postgres 1209170 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53848) idle postgres 1209174 0.0 0.1 5007344 29436 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(55502) COPY postgres 1209195 0.0 0.0 225688 7820 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54317) idle postgres 1209210 0.0 0.0 225996 8424 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54015) idle postgres 1209216 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(52183) idle postgres 1209249 0.0 0.1 5007344 29660 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(55638) COPY postgres 1209268 0.0 0.1 5007344 29580 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(55678) COPY postgres 1209276 0.0 0.0 225644 7436 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54968) idle postgres 1209347 0.0 0.1 5006936 29464 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(55822) COPY postgres 1209367 0.0 0.1 5006936 29564 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(55866) COPY postgres 1209379 0.0 0.0 225644 7436 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(52032) idle postgres 1209428 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53593) idle postgres 1209443 0.0 0.1 5007344 29896 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(55998) COPY postgres 1209445 0.0 0.0 225716 8388 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53172) idle postgres 1209461 0.0 0.1 5006936 26684 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(56022) COPY postgres 1209501 0.0 0.0 225712 7856 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54420) idle postgres 1209510 0.0 0.0 225904 7480 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(53957) idle postgres 1209533 0.0 0.0 225644 7436 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51779) idle postgres 1209541 0.0 0.1 5006936 28848 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(56186) COPY postgres 1209556 0.0 0.1 5007344 30032 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(56202) COPY postgres 1209700 0.0 0.0 225644 7384 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51878) idle postgres 1209725 0.0 0.1 5007344 30068 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(56366) COPY postgres 1209741 0.0 0.1 5007344 30068 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(56390) COPY postgres 1209792 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54218) idle postgres 1209819 0.0 0.1 5006936 29568 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(56550) COPY postgres 1209823 0.0 0.0 225644 7436 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54159) idle postgres 1209828 0.0 0.0 225644 7436 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51930) idle postgres 1209836 0.0 0.1 5007344 30148 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(56574) COPY postgres 1209886 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54058) idle postgres 1209887 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(51984) idle postgres 1209893 0.0 0.0 225904 7480 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54270) idle postgres 1209913 0.0 0.1 5006180 21060 ? Ss 2020 0:00 postgres: qliksenserepository QSMQ 192.168.41.153(56714) idle postgres 1209918 0.0 0.1 5006936 29444 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(56730) COPY postgres 1209937 0.0 0.1 5007344 30456 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(56766) COPY postgres 1209942 0.0 0.0 225644 7436 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54763) idle postgres 1209957 0.0 0.0 225644 9776 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54111) idle postgres 1210016 0.0 0.1 5007344 30352 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(56906) COPY postgres 1210034 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(52134) idle postgres 1210038 0.0 0.1 5007344 30516 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(56954) COPY postgres 1210108 0.0 0.0 225708 7868 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54481) idle postgres 1210109 0.0 0.0 225700 7864 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53012) idle postgres 1210114 0.0 0.1 5006936 28984 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(57094) COPY postgres 1210127 0.0 0.0 225704 7832 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(52436) idle postgres 1210136 0.0 0.2 5007344 32884 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(57142) COPY postgres 1210163 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54713) idle postgres 1210210 0.0 0.0 225996 8296 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(56610) idle postgres 1210213 0.0 0.1 5007344 30580 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(57282) COPY postgres 1210233 0.0 0.1 5006936 29568 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(57326) COPY postgres 1210310 0.0 0.1 5006936 29808 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(57478) COPY postgres 1210316 0.0 0.0 225904 7480 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53118) idle postgres 1210326 0.0 0.1 5006936 29624 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(57502) COPY postgres 1210346 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54375) idle postgres 1210365 0.0 0.0 225748 8028 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53739) idle postgres 1210404 0.0 0.0 225688 7960 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53386) idle postgres 1210408 0.0 0.1 5007344 30988 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(57666) COPY postgres 1210429 0.0 0.2 5007344 33184 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(57714) COPY postgres 1210460 0.0 0.0 225700 7832 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54066) idle postgres 1210504 0.0 0.0 225976 7980 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54475) idle postgres 1210505 0.0 0.0 225784 8444 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53226) idle postgres 1210510 0.0 0.2 5007344 34292 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(57870) COPY postgres 1210529 0.0 0.1 5006936 29448 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(57906) COPY postgres 1210613 0.0 0.2 5007344 33580 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58050) COPY postgres 1210630 0.0 0.1 5006936 29512 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58078) COPY postgres 1210680 0.0 0.0 225644 7436 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(52815) idle postgres 1210704 0.0 0.1 5006936 29628 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58222) COPY postgres 1210706 0.0 0.0 225696 7776 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55025) idle postgres 1210718 0.0 0.0 225720 7868 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54810) idle postgres 1210725 0.0 0.0 225712 7944 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(56246) idle postgres 1210728 0.0 0.1 5006936 29680 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58266) COPY postgres 1210795 0.0 0.1 5006936 29328 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58378) COPY postgres 1210819 0.0 0.2 5007344 33840 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58430) COPY postgres 1210828 0.0 0.0 225700 7848 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53437) idle postgres 1210838 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53278) idle postgres 1210888 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54865) idle postgres 1210895 0.0 0.1 5006936 29588 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58570) COPY postgres 1210917 0.0 0.2 5007616 33972 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58618) COPY postgres 1210931 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54580) idle postgres 1210996 0.0 0.1 5006936 29400 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58770) COPY postgres 1211007 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54634) idle postgres 1211023 0.0 0.1 5007208 29812 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58830) COPY postgres 1211095 0.0 0.1 5006936 31424 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58962) COPY postgres 1211103 0.0 0.0 225708 7856 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53848) idle postgres 1211114 0.0 0.2 5007616 33980 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58998) COPY postgres 1211138 0.0 0.0 225716 7948 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54347) idle postgres 1211278 0.0 0.1 5006936 29456 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(59146) COPY postgres 1211297 0.0 0.2 5007616 34412 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(59182) COPY postgres 1211372 0.0 0.1 5006936 29568 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(59334) COPY postgres 1211389 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(54916) idle postgres 1211391 0.0 0.1 5007208 29772 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(59370) COPY postgres 1211465 0.0 0.1 5006936 29388 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(59514) COPY postgres 1211483 0.0 0.1 5007208 29508 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(59546) COPY postgres 1211503 0.0 0.0 225988 7960 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54202) idle postgres 1211560 0.0 0.1 5006936 29628 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(59698) COPY postgres 1211580 0.0 0.1 5007208 29328 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(59738) COPY postgres 1211646 0.0 0.0 225972 7892 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54538) idle postgres 1211654 0.0 0.0 225716 7920 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55962) idle postgres 1211656 0.0 0.2 5007344 34556 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(59886) COPY postgres 1211676 0.0 0.2 5007616 34440 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(59930) COPY postgres 1211747 0.0 0.1 5006936 29208 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(60062) COPY postgres 1211768 0.0 0.2 5007616 34688 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(60110) COPY postgres 1211792 0.0 0.0 225644 7436 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53695) idle postgres 1211838 0.0 0.2 5007344 35596 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(60238) COPY postgres 1211842 0.0 0.0 225644 7436 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(53536) idle postgres 1211857 0.0 0.2 5007616 34524 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(60270) COPY postgres 1211925 0.0 0.0 225644 7436 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55180) idle postgres 1211926 0.0 0.0 225708 7772 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55386) idle postgres 1211937 0.0 0.1 5006936 29448 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(60434) COPY postgres 1211940 0.0 0.0 225752 7948 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54147) idle postgres 1211943 0.0 0.0 225708 7940 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55807) idle postgres 1211955 0.0 0.1 5007208 29512 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(60462) COPY postgres 1211958 0.0 0.0 225700 7872 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54665) idle postgres 1212000 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55289) idle postgres 1212029 0.0 0.0 225672 7824 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55911) idle postgres 1212031 0.0 0.1 5006936 29692 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(60602) COPY postgres 1212050 0.0 0.2 5007616 35076 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(60638) COPY postgres 1212107 0.0 0.0 225644 7436 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55127) idle postgres 1212123 0.0 0.2 5007344 34656 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(60786) COPY postgres 1212143 0.0 0.1 5007208 29108 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(60826) COPY postgres 1212153 0.0 0.0 225696 10236 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54252) idle postgres 1212218 0.0 0.1 5007208 29504 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(60982) COPY postgres 1212239 0.0 0.1 5007208 28488 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(32794) COPY postgres 1212245 0.0 0.0 225720 7868 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55446) idle postgres 1212251 0.0 0.0 225712 7780 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55498) idle postgres 1212312 0.0 0.1 5007208 29508 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(32932) COPY postgres 1212317 0.0 0.1 5006180 21040 ? Ss 2020 0:00 postgres: qliksenserepository QSMQ 192.168.41.153(32944) idle postgres 1212337 0.0 0.1 5007208 28192 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(32988) COPY postgres 1212364 0.0 0.0 225904 7480 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55550) idle postgres 1212411 0.0 0.2 5007616 35760 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(33130) COPY postgres 1212419 0.0 0.0 225976 7868 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54398) idle postgres 1212436 0.0 0.1 5007208 28188 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(33186) COPY postgres 1212449 0.0 0.0 225700 7916 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55856) idle postgres 1212503 0.0 0.2 5007616 35292 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(33306) COPY postgres 1212528 0.0 0.2 5007616 34688 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(33366) COPY postgres 1212597 0.0 0.1 5007208 31092 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(33498) COPY postgres 1212616 0.0 0.2 5007616 34212 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(33534) COPY postgres 1212639 0.0 0.0 225780 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(56037) idle postgres 1212760 0.0 0.1 5006180 21116 ? Ss 2020 0:00 postgres: qliksenserepository QSMQ 192.168.41.153(33650) idle postgres 1212783 0.0 0.2 5007616 35596 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(33698) COPY postgres 1212798 0.0 0.1 5007208 28312 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(33718) COPY postgres 1212869 0.0 0.0 225644 7484 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55755) idle postgres 1212875 0.0 0.1 5007208 29208 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(33878) COPY postgres 1212893 0.0 0.2 5007744 34720 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(33910) COPY postgres 1212933 0.0 0.0 225692 7856 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54603) idle postgres 1212957 0.0 0.0 225644 7436 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(55607) idle postgres 1212974 0.0 0.2 5007616 36044 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(34074) COPY postgres 1212990 0.0 0.2 5007744 34548 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(34098) COPY postgres 1213066 0.0 0.1 5007208 29208 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(34250) COPY postgres 1213085 0.0 0.1 5007208 28008 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(34290) COPY postgres 1213156 0.0 0.1 5007208 30936 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(34430) COPY postgres 1213176 0.0 0.1 5007208 28312 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(34474) COPY postgres 1213245 0.0 0.1 5007208 29092 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(34606) COPY postgres 1213263 0.0 0.1 5007208 28612 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(34642) COPY postgres 1213337 0.0 0.2 5007616 36064 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(34794) COPY postgres 1213353 0.0 0.1 5007208 28064 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(34822) COPY postgres 1213407 0.0 0.1 5006180 21160 ? Ss 2020 0:00 postgres: qliksenserepository QSMQ 192.168.41.153(34938) idle postgres 1213420 0.0 0.0 225968 7872 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54874) idle postgres 1213427 0.0 0.1 5007208 28508 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(34970) COPY postgres 1213445 0.0 0.1 5007208 31632 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(35006) COPY postgres 1213521 0.0 0.1 5007208 28688 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(35158) COPY postgres 1213537 0.0 0.2 5007744 35248 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(35186) COPY postgres 1213611 0.0 0.2 5007616 38156 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(35338) COPY postgres 1213632 0.0 0.2 5007744 38520 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(35382) COPY postgres 1213701 0.0 0.1 5007208 28676 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(35518) COPY postgres 1213723 0.0 0.1 5007208 31960 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(35570) COPY postgres 1213797 0.0 0.2 5007616 36764 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(35722) COPY postgres 1213820 0.0 0.1 5007208 32176 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(35770) COPY postgres 1213941 0.0 0.0 226164 7776 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(57279) idle postgres 1213963 0.0 0.0 225764 7240 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54739) idle postgres 1213965 0.0 0.1 5007208 28876 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(36034) COPY postgres 1213981 0.0 0.2 5007744 39040 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(36066) COPY postgres 1214263 0.0 0.0 5005908 12540 ? Ss 2020 0:00 postgres: qliksenserepository QSMQ 192.168.41.153(36380) idle postgres 1214316 0.0 0.2 5007616 38356 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(36528) COPY postgres 1214321 0.0 0.2 5007744 38964 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(36548) COPY postgres 1214409 0.0 0.0 225904 7480 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(54962) idle postgres 1214484 0.0 0.1 5007208 31980 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(36856) COPY postgres 1215005 0.0 0.2 5007336 34148 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(37832) COPY postgres 1215007 0.0 0.2 5007744 38320 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(37840) COPY postgres 1216039 0.0 0.0 226164 7744 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(55864) idle postgres 1216317 0.0 0.0 5005908 12544 ? Ss 2020 0:00 postgres: qliksenserepository QSMQ 192.168.41.153(40046) idle postgres 1216366 0.0 0.2 5007336 35940 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(40162) COPY postgres 1216371 0.0 0.2 5007360 42496 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(40182) COPY postgres 1216449 0.0 0.0 226164 7776 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(58764) idle postgres 1219179 0.0 0.0 5005908 12540 ? Ss 2020 0:00 postgres: qliksenserepository QSMQ 192.168.41.153(44986) idle postgres 1219211 0.0 0.2 5007336 35568 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(45058) COPY postgres 1220323 0.0 0.0 226148 7772 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(60105) idle postgres 1220992 0.0 0.0 226148 7556 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(58382) idle postgres 1221540 0.0 0.0 5005908 12564 ? Ss 2020 0:00 postgres: qliksenserepository QSMQ 192.168.41.153(48652) idle postgres 1221544 0.0 0.1 5006184 21100 ? Ss 2020 0:00 postgres: qliksenserepository QSMQ 192.168.41.153(48668) idle postgres 1221565 0.0 0.2 5007360 44540 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(48720) COPY postgres 1221577 0.0 0.2 5007336 35124 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(48742) COPY postgres 1221716 0.0 0.0 226164 7772 ? S 2020 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(60519) idle postgres 1222353 0.0 0.0 5005908 12496 ? Ss 2020 0:00 postgres: qliksenserepository QSMQ 192.168.41.153(49762) idle postgres 1222469 0.0 0.2 5007360 45484 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(50166) COPY postgres 1222472 0.0 0.2 5007336 35876 ? Ss 2020 0:00 postgres: qlogs_writer QLogs 192.168.41.153(50178) COPY postgres 1524377 0.0 0.0 226152 7780 ? S sty02 0:00 pgpool: qlogs_writer QLogs 192.168.41.152(62825) idle postgres 1528408 0.0 0.0 225892 7748 ? S sty02 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(56142) idle postgres 1528427 0.0 0.2 5007360 47240 ? Ss sty02 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58824) COPY postgres 1528429 0.0 0.2 5007360 47396 ? Ss sty02 0:00 postgres: qlogs_writer QLogs 192.168.41.153(58828) COPY root 1728597 0.0 0.0 0 0 ? I 00:00 0:01 [kworker/0:2-events] root 1759364 0.0 0.0 0 0 ? I 06:27 0:00 [kworker/1:1-events] root 1774680 0.0 0.0 0 0 ? I 09:41 0:00 [kworker/2:1-mm_percpu_wq] root 1774913 0.0 0.0 167644 8852 pts/1 S 09:44 0:00 sudo su - postgres root 1774915 0.0 0.0 155076 7024 pts/1 S 09:44 0:00 su - postgres postgres 1774916 0.0 0.0 24248 4148 pts/1 S 09:44 0:00 -bash root 1775156 0.0 0.0 0 0 ? I 09:47 0:00 [kworker/3:0-mm_percpu_wq] root 1775368 0.0 0.0 0 0 ? I 09:48 0:00 [kworker/0:0] root 1775515 0.0 0.0 0 0 ? I 09:50 0:00 [kworker/u8:1-events_unbound] postgres 1777383 0.2 1.2 272236 205628 pts/1 T 10:15 0:05 psql -h 192.168.41.153 -p 5432 -U postgres postgres 1777416 0.0 1.2 5007808 202740 ? Ss 10:16 0:01 postgres: postgres QLogs 192.168.41.153(38258) idle postgres 1777975 0.0 0.0 225944 7588 ? S 10:23 0:00 pgpool: accept connection root 1778049 0.0 0.0 0 0 ? I 10:24 0:00 [kworker/u8:0-events_unbound] postgres 1778899 0.0 0.0 9972 2256 pts/1 T 10:34 0:00 more postgres 1779318 0.0 0.0 225892 7748 ? S 10:40 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(52076) idle root 1780223 0.0 0.0 0 0 ? I 10:50 0:00 [kworker/1:2-mm_percpu_wq] root 1780246 0.0 0.0 0 0 ? I 10:51 0:00 [kworker/3:1-mm_percpu_wq] postgres 1780380 0.0 0.0 226288 7744 ? S 10:52 0:00 pgpool: qlogs_writer QLogs 192.168.41.151(52180) idle root 1780477 0.0 0.0 0 0 ? I 10:53 0:00 [kworker/2:2-mm_percpu_wq] root 1780671 0.0 0.0 0 0 ? I 10:57 0:00 [kworker/3:2-mm_percpu_wq] postgres 1780879 0.0 0.2 5007360 48496 ? Ss 10:58 0:00 postgres: qlogs_writer QLogs 192.168.41.153(43316) COPY postgres 1780969 0.0 0.2 5007336 36704 ? Ss 10:59 0:00 postgres: qlogs_writer QLogs 192.168.41.153(43466) COPY root 1781089 0.0 0.0 0 0 ? I 11:01 0:00 [kworker/2:0-events] postgres 1781113 0.0 0.0 5005516 6452 ? Ss 11:01 0:00 postgres: qliksenserepository QSMQ 192.168.41.153(43622) authentication postgres 1781125 0.0 0.0 61604 4024 pts/1 R+ 11:01 0:00 ps -aux |
|
|
> But I note all process postgres is COPY status and pgpool process is idle status, this is strange. What are you think? Yeah, looks strange to me as well. I never personally experience such that phenomenon. Can you elaborate more about what kind of COPY operation clients are doing? For example, COPY FROM or TO? Are they COPY .. STDIN? |
|
|
pg_stat_activity (81,899 bytes)
datid | datname | 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 | backend_type
-------+---------------+---------+----------+---------------------+----------------------------------+----------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-----------------+---------------------+--------+-------------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------
| | 129843 | | | | | | | 2020-12-23 10:32:17.509196+01 | | | | Activity | AutoVacuumMain | | | | | autovacuum launcher
| | 129846 | 10 | postgres | | | | | 2020-12-23 10:32:17.510048+01 | | | | Activity | LogicalLauncherMain | | | | | logical replication launcher
16392 | QLogs | 1801070 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 36968 | 2021-01-04 15:15:41.277324+01 | 2021-01-04 15:15:41.289723+01 | 2021-01-04 15:15:41.289733+01 | 2021-01-04 15:15:41.289734+01 | Client | ClientRead | active | 451713 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1802186 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 40418 | 2021-01-04 15:19:09.671405+01 | 2021-01-04 15:19:09.719953+01 | 2021-01-04 15:19:09.719974+01 | 2021-01-04 15:19:09.719974+01 | Client | ClientRead | active | 451717 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
| | 130204 | 22611 | repl | 192.168.41.154 | 192.168.41.154 | | 56772 | 2020-12-23 10:38:39.762349+01 | | | 2020-12-23 10:38:39.763851+01 | Activity | WalSenderMain | active | | | | walsender
16392 | QLogs | 1800764 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 35956 | 2021-01-04 15:14:41.190678+01 | 2021-01-04 15:14:41.213606+01 | 2021-01-04 15:14:41.213618+01 | 2021-01-04 15:14:41.213618+01 | Client | ClientRead | active | 451712 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1801365 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 37964 | 2021-01-04 15:16:41.330474+01 | 2021-01-04 15:16:41.344334+01 | 2021-01-04 15:16:41.344347+01 | 2021-01-04 15:16:41.344347+01 | Client | ClientRead | active | 451714 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1804134 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 46900 | 2021-01-04 15:25:41.88467+01 | 2021-01-04 15:25:41.900656+01 | 2021-01-04 15:25:41.900669+01 | 2021-01-04 15:25:41.900669+01 | Client | ClientRead | active | 451726 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1803534 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 44900 | 2021-01-04 15:23:41.751467+01 | 2021-01-04 15:23:41.767362+01 | 2021-01-04 15:23:41.767376+01 | 2021-01-04 15:23:41.767377+01 | Client | ClientRead | active | 451722 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1804426 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 47884 | 2021-01-04 15:26:41.942158+01 | 2021-01-04 15:26:41.958935+01 | 2021-01-04 15:26:41.958952+01 | 2021-01-04 15:26:41.958952+01 | Client | ClientRead | active | 451727 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1803836 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 45904 | 2021-01-04 15:24:41.825863+01 | 2021-01-04 15:24:41.840834+01 | 2021-01-04 15:24:41.840846+01 | 2021-01-04 15:24:41.840846+01 | Client | ClientRead | active | 451724 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1804715 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 48852 | 2021-01-04 15:27:42.0029+01 | 2021-01-04 15:27:42.018319+01 | 2021-01-04 15:27:42.018332+01 | 2021-01-04 15:27:42.018332+01 | Client | ClientRead | active | 451728 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1805007 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 49824 | 2021-01-04 15:28:42.059274+01 | 2021-01-04 15:28:42.075002+01 | 2021-01-04 15:28:42.075013+01 | 2021-01-04 15:28:42.075013+01 | Client | ClientRead | active | 451729 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1805299 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 50792 | 2021-01-04 15:29:42.138267+01 | 2021-01-04 15:29:42.15226+01 | 2021-01-04 15:29:42.152267+01 | 2021-01-04 15:29:42.152267+01 | Client | ClientRead | active | 451730 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1800455 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 34972 | 2021-01-04 15:13:41.084508+01 | 2021-01-04 15:13:41.135161+01 | 2021-01-04 15:13:41.135169+01 | 2021-01-04 15:13:41.13517+01 | Client | ClientRead | active | 451711 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1805723 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 52202 | 2021-01-04 15:31:09.916928+01 | 2021-01-04 15:31:09.937732+01 | 2021-01-04 15:31:09.937744+01 | 2021-01-04 15:31:09.937744+01 | Client | ClientRead | active | 451732 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1806545 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 54640 | 2021-01-04 15:33:42.377841+01 | 2021-01-04 15:33:42.393954+01 | 2021-01-04 15:33:42.393963+01 | 2021-01-04 15:33:42.393964+01 | Client | ClientRead | active | 451735 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1810253 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 39914 | 2021-01-04 15:40:57.057969+01 | 2021-01-04 15:40:57.101889+01 | 2021-01-04 15:40:57.101911+01 | 2021-01-04 15:40:57.101911+01 | Client | ClientRead | active | 451750 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1801659 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 38964 | 2021-01-04 15:17:41.385854+01 | 2021-01-04 15:17:41.401415+01 | 2021-01-04 15:17:41.401425+01 | 2021-01-04 15:17:41.401426+01 | Client | ClientRead | active | 451715 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1807154 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 56844 | 2021-01-04 15:34:56.727739+01 | 2021-01-04 15:34:56.742663+01 | 2021-01-04 15:34:56.742677+01 | 2021-01-04 15:34:56.742678+01 | Client | ClientRead | active | 451738 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1802047 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 39964 | 2021-01-04 15:18:41.44451+01 | 2021-01-04 15:18:41.46134+01 | 2021-01-04 15:18:41.461353+01 | 2021-01-04 15:18:41.461353+01 | Client | ClientRead | active | 451716 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1802652 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 41956 | 2021-01-04 15:20:41.581875+01 | 2021-01-04 15:20:41.59675+01 | 2021-01-04 15:20:41.596765+01 | 2021-01-04 15:20:41.596765+01 | Client | ClientRead | active | 451719 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1802348 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 40960 | 2021-01-04 15:19:41.501812+01 | 2021-01-04 15:19:41.517544+01 | 2021-01-04 15:19:41.517566+01 | 2021-01-04 15:19:41.517566+01 | Client | ClientRead | active | 451718 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1802949 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 42952 | 2021-01-04 15:21:41.639323+01 | 2021-01-04 15:21:41.654634+01 | 2021-01-04 15:21:41.654652+01 | 2021-01-04 15:21:41.654652+01 | Client | ClientRead | active | 451720 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1803248 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 43940 | 2021-01-04 15:22:41.694556+01 | 2021-01-04 15:22:41.708185+01 | 2021-01-04 15:22:41.708192+01 | 2021-01-04 15:22:41.708193+01 | Client | ClientRead | active | 451721 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1806633 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 54952 | 2021-01-04 15:33:56.67648+01 | 2021-01-04 15:33:56.691394+01 | 2021-01-04 15:33:56.691402+01 | 2021-01-04 15:33:56.691402+01 | Client | ClientRead | active | 451736 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1807680 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 58762 | 2021-01-04 15:35:56.77653+01 | 2021-01-04 15:35:56.793216+01 | 2021-01-04 15:35:56.79323+01 | 2021-01-04 15:35:56.79323+01 | Client | ClientRead | active | 451740 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1803683 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 45398 | 2021-01-04 15:24:09.723282+01 | 2021-01-04 15:24:09.738326+01 | 2021-01-04 15:24:09.73834+01 | 2021-01-04 15:24:09.73834+01 | Client | ClientRead | active | 451723 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1803979 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 46394 | 2021-01-04 15:25:09.82159+01 | 2021-01-04 15:25:09.837045+01 | 2021-01-04 15:25:09.837052+01 | 2021-01-04 15:25:09.837053+01 | Client | ClientRead | active | 451725 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1808070 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 60182 | 2021-01-04 15:36:42.558593+01 | 2021-01-04 15:36:42.576932+01 | 2021-01-04 15:36:42.576953+01 | 2021-01-04 15:36:42.576953+01 | Client | ClientRead | active | 451741 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1807025 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 56372 | 2021-01-04 15:34:42.438042+01 | 2021-01-04 15:34:42.453415+01 | 2021-01-04 15:34:42.453426+01 | 2021-01-04 15:34:42.453427+01 | Client | ClientRead | active | 451737 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1807553 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 58294 | 2021-01-04 15:35:42.499574+01 | 2021-01-04 15:35:42.514966+01 | 2021-01-04 15:35:42.514979+01 | 2021-01-04 15:35:42.514979+01 | Client | ClientRead | active | 451739 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1808198 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 60654 | 2021-01-04 15:36:56.826102+01 | 2021-01-04 15:36:56.843366+01 | 2021-01-04 15:36:56.843385+01 | 2021-01-04 15:36:56.843385+01 | Client | ClientRead | active | 451742 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1810771 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 41812 | 2021-01-04 15:41:57.138767+01 | 2021-01-04 15:41:57.155482+01 | 2021-01-04 15:41:57.15549+01 | 2021-01-04 15:41:57.15549+01 | Client | ClientRead | active | 451752 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1805591 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 51760 | 2021-01-04 15:30:42.193655+01 | 2021-01-04 15:30:42.211735+01 | 2021-01-04 15:30:42.211749+01 | 2021-01-04 15:30:42.211749+01 | Client | ClientRead | active | 451731 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1811161 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 43234 | 2021-01-04 15:42:42.958601+01 | 2021-01-04 15:42:42.977317+01 | 2021-01-04 15:42:42.977332+01 | 2021-01-04 15:42:42.977332+01 | Client | ClientRead | active | 451753 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1805881 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 52732 | 2021-01-04 15:31:42.257787+01 | 2021-01-04 15:31:42.273361+01 | 2021-01-04 15:31:42.273368+01 | 2021-01-04 15:31:42.273369+01 | Client | ClientRead | active | 451733 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1811678 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 45122 | 2021-01-04 15:43:43.020079+01 | 2021-01-04 15:43:43.038785+01 | 2021-01-04 15:43:43.038797+01 | 2021-01-04 15:43:43.038797+01 | Client | ClientRead | active | 451755 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1806174 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 53712 | 2021-01-04 15:32:42.317744+01 | 2021-01-04 15:32:42.332718+01 | 2021-01-04 15:32:42.332733+01 | 2021-01-04 15:32:42.332733+01 | Client | ClientRead | active | 451734 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1811290 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 43710 | 2021-01-04 15:42:57.188011+01 | 2021-01-04 15:42:57.227808+01 | 2021-01-04 15:42:57.227823+01 | 2021-01-04 15:42:57.227823+01 | Client | ClientRead | active | 451754 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1812197 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 47022 | 2021-01-04 15:44:43.088033+01 | 2021-01-04 15:44:43.103981+01 | 2021-01-04 15:44:43.104+01 | 2021-01-04 15:44:43.104001+01 | Client | ClientRead | active | 451757 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1812717 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 48914 | 2021-01-04 15:45:43.144926+01 | 2021-01-04 15:45:43.159651+01 | 2021-01-04 15:45:43.159666+01 | 2021-01-04 15:45:43.159666+01 | Client | ClientRead | active | 451759 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1813236 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 50818 | 2021-01-04 15:46:43.254173+01 | 2021-01-04 15:46:43.29972+01 | 2021-01-04 15:46:43.29974+01 | 2021-01-04 15:46:43.29974+01 | Client | ClientRead | active | 451761 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1816510 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 34204 | 2021-01-04 15:52:57.81029+01 | 2021-01-04 15:52:57.82926+01 | 2021-01-04 15:52:57.829272+01 | 2021-01-04 15:52:57.829272+01 | Client | ClientRead | active | 451774 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1817021 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 36074 | 2021-01-04 15:53:57.868626+01 | 2021-01-04 15:53:57.886927+01 | 2021-01-04 15:53:57.886945+01 | 2021-01-04 15:53:57.886945+01 | Client | ClientRead | active | 451776 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1814975 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 56838 | 2021-01-04 15:49:57.653618+01 | 2021-01-04 15:49:57.668364+01 | 2021-01-04 15:49:57.668377+01 | 2021-01-04 15:49:57.668378+01 | Client | ClientRead | active | 451768 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1815487 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 58704 | 2021-01-04 15:50:57.704463+01 | 2021-01-04 15:50:57.720403+01 | 2021-01-04 15:50:57.720418+01 | 2021-01-04 15:50:57.720418+01 | Client | ClientRead | active | 451770 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1816000 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 60576 | 2021-01-04 15:51:57.760724+01 | 2021-01-04 15:51:57.776433+01 | 2021-01-04 15:51:57.776444+01 | 2021-01-04 15:51:57.776445+01 | Client | ClientRead | active | 451772 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1816384 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 33740 | 2021-01-04 15:52:43.694954+01 | 2021-01-04 15:52:43.70969+01 | 2021-01-04 15:52:43.709702+01 | 2021-01-04 15:52:43.709702+01 | Client | ClientRead | active | 451773 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1817533 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 37940 | 2021-01-04 15:54:57.92159+01 | 2021-01-04 15:54:57.940848+01 | 2021-01-04 15:54:57.940861+01 | 2021-01-04 15:54:57.940862+01 | Client | ClientRead | active | 451778 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1818045 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 39812 | 2021-01-04 15:55:57.980273+01 | 2021-01-04 15:55:57.997182+01 | 2021-01-04 15:55:57.997189+01 | 2021-01-04 15:55:57.99719+01 | Client | ClientRead | active | 451780 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1816896 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 35610 | 2021-01-04 15:53:43.754708+01 | 2021-01-04 15:53:43.772106+01 | 2021-01-04 15:53:43.772118+01 | 2021-01-04 15:53:43.772118+01 | Client | ClientRead | active | 451775 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1817407 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 37478 | 2021-01-04 15:54:43.821734+01 | 2021-01-04 15:54:43.837473+01 | 2021-01-04 15:54:43.837483+01 | 2021-01-04 15:54:43.837483+01 | Client | ClientRead | active | 451777 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1817920 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 39350 | 2021-01-04 15:55:43.88252+01 | 2021-01-04 15:55:43.903401+01 | 2021-01-04 15:55:43.903424+01 | 2021-01-04 15:55:43.903425+01 | Client | ClientRead | active | 451779 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1818941 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 43086 | 2021-01-04 15:57:44.014419+01 | 2021-01-04 15:57:44.030792+01 | 2021-01-04 15:57:44.030804+01 | 2021-01-04 15:57:44.030804+01 | Client | ClientRead | active | 451783 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1808715 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 34314 | 2021-01-04 15:37:56.878247+01 | 2021-01-04 15:37:56.894844+01 | 2021-01-04 15:37:56.894857+01 | 2021-01-04 15:37:56.894857+01 | Client | ClientRead | active | 451744 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1809235 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 36208 | 2021-01-04 15:38:56.931571+01 | 2021-01-04 15:38:56.947566+01 | 2021-01-04 15:38:56.947578+01 | 2021-01-04 15:38:56.947579+01 | Client | ClientRead | active | 451746 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1809755 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 38106 | 2021-01-04 15:39:57.007232+01 | 2021-01-04 15:39:57.024775+01 | 2021-01-04 15:39:57.024789+01 | 2021-01-04 15:39:57.024789+01 | Client | ClientRead | active | 451748 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1808589 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 33850 | 2021-01-04 15:37:42.646019+01 | 2021-01-04 15:37:42.662558+01 | 2021-01-04 15:37:42.662567+01 | 2021-01-04 15:37:42.662567+01 | Client | ClientRead | active | 451743 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1809109 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 35742 | 2021-01-04 15:38:42.708882+01 | 2021-01-04 15:38:42.72623+01 | 2021-01-04 15:38:42.726245+01 | 2021-01-04 15:38:42.726246+01 | Client | ClientRead | active | 451745 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1809625 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 37630 | 2021-01-04 15:39:42.770675+01 | 2021-01-04 15:39:42.787883+01 | 2021-01-04 15:39:42.787893+01 | 2021-01-04 15:39:42.787893+01 | Client | ClientRead | active | 451747 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1818431 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 41220 | 2021-01-04 15:56:43.953624+01 | 2021-01-04 15:56:43.970686+01 | 2021-01-04 15:56:43.9707+01 | 2021-01-04 15:56:43.970701+01 | Client | ClientRead | active | 451781 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1810145 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 39522 | 2021-01-04 15:40:42.835472+01 | 2021-01-04 15:40:42.852697+01 | 2021-01-04 15:40:42.852711+01 | 2021-01-04 15:40:42.852712+01 | Client | ClientRead | active | 451749 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1818558 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 41688 | 2021-01-04 15:56:58.034386+01 | 2021-01-04 15:56:58.050822+01 | 2021-01-04 15:56:58.050835+01 | 2021-01-04 15:56:58.050835+01 | Client | ClientRead | active | 451782 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1819069 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 43560 | 2021-01-04 15:57:58.127296+01 | 2021-01-04 15:57:58.14548+01 | 2021-01-04 15:57:58.145492+01 | 2021-01-04 15:57:58.145493+01 | Client | ClientRead | active | 451784 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1819454 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 44962 | 2021-01-04 15:58:44.081046+01 | 2021-01-04 15:58:44.097327+01 | 2021-01-04 15:58:44.097336+01 | 2021-01-04 15:58:44.097336+01 | Client | ClientRead | active | 451785 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1810664 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 41424 | 2021-01-04 15:41:42.897007+01 | 2021-01-04 15:41:42.912263+01 | 2021-01-04 15:41:42.912271+01 | 2021-01-04 15:41:42.912271+01 | Client | ClientRead | active | 451751 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1819965 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 46830 | 2021-01-04 15:59:44.19382+01 | 2021-01-04 15:59:44.209843+01 | 2021-01-04 15:59:44.209856+01 | 2021-01-04 15:59:44.209857+01 | Client | ClientRead | active | 451787 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1820608 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 49124 | 2021-01-04 16:00:58.292611+01 | 2021-01-04 16:00:58.311291+01 | 2021-01-04 16:00:58.311307+01 | 2021-01-04 16:00:58.311308+01 | Client | ClientRead | active | 451790 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1820072 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 47220 | 2021-01-04 15:59:58.237726+01 | 2021-01-04 15:59:58.254242+01 | 2021-01-04 15:59:58.25426+01 | 2021-01-04 15:59:58.254261+01 | Client | ClientRead | active | 451788 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1811807 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 45600 | 2021-01-04 15:43:57.263952+01 | 2021-01-04 15:43:57.279599+01 | 2021-01-04 15:43:57.279613+01 | 2021-01-04 15:43:57.279613+01 | Client | ClientRead | active | 451756 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1821131 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 50996 | 2021-01-04 16:01:58.347086+01 | 2021-01-04 16:01:58.363675+01 | 2021-01-04 16:01:58.363688+01 | 2021-01-04 16:01:58.363689+01 | Client | ClientRead | active | 451792 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1812326 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 47496 | 2021-01-04 15:44:57.342505+01 | 2021-01-04 15:44:57.35947+01 | 2021-01-04 15:44:57.359478+01 | 2021-01-04 15:44:57.359478+01 | Client | ClientRead | active | 451758 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1821516 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 52404 | 2021-01-04 16:02:44.493682+01 | 2021-01-04 16:02:44.51146+01 | 2021-01-04 16:02:44.511468+01 | 2021-01-04 16:02:44.511469+01 | Client | ClientRead | active | 451793 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1812845 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 49386 | 2021-01-04 15:45:57.395321+01 | 2021-01-04 15:45:57.409674+01 | 2021-01-04 15:45:57.409683+01 | 2021-01-04 15:45:57.409683+01 | Client | ClientRead | active | 451760 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1822116 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 54274 | 2021-01-04 16:03:44.557078+01 | 2021-01-04 16:03:44.572791+01 | 2021-01-04 16:03:44.572804+01 | 2021-01-04 16:03:44.572804+01 | Client | ClientRead | active | 451795 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1813364 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 51290 | 2021-01-04 15:46:57.446877+01 | 2021-01-04 15:46:57.511611+01 | 2021-01-04 15:46:57.51163+01 | 2021-01-04 15:46:57.51163+01 | Client | ClientRead | active | 451762 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1813754 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 52716 | 2021-01-04 15:47:43.386537+01 | 2021-01-04 15:47:43.400553+01 | 2021-01-04 15:47:43.400561+01 | 2021-01-04 15:47:43.400562+01 | Client | ClientRead | active | 451763 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1813882 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 53190 | 2021-01-04 15:47:57.547813+01 | 2021-01-04 15:47:57.563641+01 | 2021-01-04 15:47:57.563654+01 | 2021-01-04 15:47:57.563654+01 | Client | ClientRead | active | 451764 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1814354 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 54582 | 2021-01-04 15:48:43.449088+01 | 2021-01-04 15:48:43.465883+01 | 2021-01-04 15:48:43.465891+01 | 2021-01-04 15:48:43.465891+01 | Client | ClientRead | active | 451765 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1814482 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 55054 | 2021-01-04 15:48:57.601382+01 | 2021-01-04 15:48:57.619489+01 | 2021-01-04 15:48:57.619503+01 | 2021-01-04 15:48:57.619503+01 | Client | ClientRead | active | 451766 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1822628 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 56148 | 2021-01-04 16:04:44.625169+01 | 2021-01-04 16:04:44.640201+01 | 2021-01-04 16:04:44.640215+01 | 2021-01-04 16:04:44.640215+01 | Client | ClientRead | active | 451797 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1814868 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 56450 | 2021-01-04 15:49:43.51069+01 | 2021-01-04 15:49:43.526401+01 | 2021-01-04 15:49:43.526409+01 | 2021-01-04 15:49:43.526409+01 | Client | ClientRead | active | 451767 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1825810 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 39534 | 2021-01-04 16:10:58.878979+01 | 2021-01-04 16:10:58.947+01 | 2021-01-04 16:10:58.947014+01 | 2021-01-04 16:10:58.947014+01 | Client | ClientRead | active | 451810 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1815381 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 58320 | 2021-01-04 15:50:43.573756+01 | 2021-01-04 15:50:43.588827+01 | 2021-01-04 15:50:43.588842+01 | 2021-01-04 15:50:43.588846+01 | Client | ClientRead | active | 451769 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1823145 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 58024 | 2021-01-04 16:05:44.751008+01 | 2021-01-04 16:05:44.767983+01 | 2021-01-04 16:05:44.767995+01 | 2021-01-04 16:05:44.767996+01 | Client | ClientRead | active | 451799 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1815893 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 60188 | 2021-01-04 15:51:43.631316+01 | 2021-01-04 15:51:43.646929+01 | 2021-01-04 15:51:43.646936+01 | 2021-01-04 15:51:43.646936+01 | Client | ClientRead | active | 451771 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1825299 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 37666 | 2021-01-04 16:09:58.82557+01 | 2021-01-04 16:09:58.841622+01 | 2021-01-04 16:09:58.841636+01 | 2021-01-04 16:09:58.841637+01 | Client | ClientRead | active | 451808 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1824787 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 35792 | 2021-01-04 16:08:58.769314+01 | 2021-01-04 16:08:58.785256+01 | 2021-01-04 16:08:58.78527+01 | 2021-01-04 16:08:58.78527+01 | Client | ClientRead | active | 451806 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1826322 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 41402 | 2021-01-04 16:11:58.988665+01 | 2021-01-04 16:11:59.001515+01 | 2021-01-04 16:11:59.001522+01 | 2021-01-04 16:11:59.001523+01 | Client | ClientRead | active | 451812 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1826833 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 43268 | 2021-01-04 16:12:59.039741+01 | 2021-01-04 16:12:59.056229+01 | 2021-01-04 16:12:59.056239+01 | 2021-01-04 16:12:59.056239+01 | Client | ClientRead | active | 451814 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1827857 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 47018 | 2021-01-04 16:14:59.153211+01 | 2021-01-04 16:14:59.168275+01 | 2021-01-04 16:14:59.168282+01 | 2021-01-04 16:14:59.168287+01 | Client | ClientRead | active | 451818 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1827346 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 45148 | 2021-01-04 16:13:59.098534+01 | 2021-01-04 16:13:59.115335+01 | 2021-01-04 16:13:59.115348+01 | 2021-01-04 16:13:59.115348+01 | Client | ClientRead | active | 451816 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1827221 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 44686 | 2021-01-04 16:13:45.270593+01 | 2021-01-04 16:13:45.287325+01 | 2021-01-04 16:13:45.287336+01 | 2021-01-04 16:13:45.287336+01 | Client | ClientRead | active | 451815 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1827731 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 46552 | 2021-01-04 16:14:45.339778+01 | 2021-01-04 16:14:45.353921+01 | 2021-01-04 16:14:45.353935+01 | 2021-01-04 16:14:45.353936+01 | Client | ClientRead | active | 451817 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1828370 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 48890 | 2021-01-04 16:15:59.210397+01 | 2021-01-04 16:15:59.227016+01 | 2021-01-04 16:15:59.227029+01 | 2021-01-04 16:15:59.22703+01 | Client | ClientRead | active | 451820 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1828244 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 48424 | 2021-01-04 16:15:45.463256+01 | 2021-01-04 16:15:45.478384+01 | 2021-01-04 16:15:45.478416+01 | 2021-01-04 16:15:45.478416+01 | Client | ClientRead | active | 451819 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1830923 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 57906 | 2021-01-04 16:20:50.780157+01 | 2021-01-04 16:20:50.795097+01 | 2021-01-04 16:20:50.79511+01 | 2021-01-04 16:20:50.79511+01 | Client | ClientRead | active | 451829 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1828756 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 50298 | 2021-01-04 16:16:45.648106+01 | 2021-01-04 16:16:45.663684+01 | 2021-01-04 16:16:45.663691+01 | 2021-01-04 16:16:45.663691+01 | Client | ClientRead | active | 451821 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1826716 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 42838 | 2021-01-04 16:12:45.207777+01 | 2021-01-04 16:12:45.226284+01 | 2021-01-04 16:12:45.226296+01 | 2021-01-04 16:12:45.226296+01 | Client | ClientRead | active | 451813 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1819581 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 45432 | 2021-01-04 15:58:58.18484+01 | 2021-01-04 15:58:58.201155+01 | 2021-01-04 15:58:58.201173+01 | 2021-01-04 15:58:58.201174+01 | Client | ClientRead | active | 451786 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1820501 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 48734 | 2021-01-04 16:00:44.344208+01 | 2021-01-04 16:00:44.379918+01 | 2021-01-04 16:00:44.379937+01 | 2021-01-04 16:00:44.379937+01 | Client | ClientRead | active | 451789 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1831000 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 58186 | 2021-01-04 16:20:59.499547+01 | 2021-01-04 16:20:59.515611+01 | 2021-01-04 16:20:59.515624+01 | 2021-01-04 16:20:59.515624+01 | Client | ClientRead | active | 451830 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1821023 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 50602 | 2021-01-04 16:01:44.425562+01 | 2021-01-04 16:01:44.441543+01 | 2021-01-04 16:01:44.441558+01 | 2021-01-04 16:01:44.441558+01 | Client | ClientRead | active | 451791 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1829977 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 54440 | 2021-01-04 16:18:59.38255+01 | 2021-01-04 16:18:59.398518+01 | 2021-01-04 16:18:59.398532+01 | 2021-01-04 16:18:59.398532+01 | Client | ClientRead | active | 451826 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1830410 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 56028 | 2021-01-04 16:19:50.648571+01 | 2021-01-04 16:19:50.664747+01 | 2021-01-04 16:19:50.664759+01 | 2021-01-04 16:19:50.664759+01 | Client | ClientRead | active | 451827 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1830488 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 56314 | 2021-01-04 16:19:59.441691+01 | 2021-01-04 16:19:59.459916+01 | 2021-01-04 16:19:59.459928+01 | 2021-01-04 16:19:59.459929+01 | Client | ClientRead | active | 451828 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1831435 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 59780 | 2021-01-04 16:21:50.842843+01 | 2021-01-04 16:21:50.85906+01 | 2021-01-04 16:21:50.859074+01 | 2021-01-04 16:21:50.859074+01 | Client | ClientRead | active | 451831 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1821643 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 52874 | 2021-01-04 16:02:58.405307+01 | 2021-01-04 16:02:58.423207+01 | 2021-01-04 16:02:58.423215+01 | 2021-01-04 16:02:58.423215+01 | Client | ClientRead | active | 451794 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1831947 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 33420 | 2021-01-04 16:22:50.913891+01 | 2021-01-04 16:22:50.9306+01 | 2021-01-04 16:22:50.930617+01 | 2021-01-04 16:22:50.930618+01 | Client | ClientRead | active | 451833 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1822243 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 54746 | 2021-01-04 16:03:58.459841+01 | 2021-01-04 16:03:58.476349+01 | 2021-01-04 16:03:58.476356+01 | 2021-01-04 16:03:58.476356+01 | Client | ClientRead | active | 451796 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1834657 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 43202 | 2021-01-04 16:28:00.514666+01 | 2021-01-04 16:28:00.571513+01 | 2021-01-04 16:28:00.57153+01 | 2021-01-04 16:28:00.57153+01 | Client | ClientRead | active | 451843 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1823784 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 60362 | 2021-01-04 16:06:58.657381+01 | 2021-01-04 16:06:58.675965+01 | 2021-01-04 16:06:58.675973+01 | 2021-01-04 16:06:58.675974+01 | Client | ClientRead | active | 451802 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1822756 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 56620 | 2021-01-04 16:04:58.515142+01 | 2021-01-04 16:04:58.560352+01 | 2021-01-04 16:04:58.560367+01 | 2021-01-04 16:04:58.560368+01 | Client | ClientRead | active | 451798 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1823273 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 58494 | 2021-01-04 16:05:58.599953+01 | 2021-01-04 16:05:58.616458+01 | 2021-01-04 16:05:58.616471+01 | 2021-01-04 16:05:58.616471+01 | Client | ClientRead | active | 451800 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1823658 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 59894 | 2021-01-04 16:06:44.820551+01 | 2021-01-04 16:06:44.834625+01 | 2021-01-04 16:06:44.834632+01 | 2021-01-04 16:06:44.834632+01 | Client | ClientRead | active | 451801 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1824295 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 34000 | 2021-01-04 16:07:58.714031+01 | 2021-01-04 16:07:58.731691+01 | 2021-01-04 16:07:58.731699+01 | 2021-01-04 16:07:58.7317+01 | Client | ClientRead | active | 451804 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1833093 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 37480 | 2021-01-04 16:24:59.731345+01 | 2021-01-04 16:24:59.748003+01 | 2021-01-04 16:24:59.748011+01 | 2021-01-04 16:24:59.748012+01 | Client | ClientRead | active | 451838 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1824170 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 33536 | 2021-01-04 16:07:44.879547+01 | 2021-01-04 16:07:44.89377+01 | 2021-01-04 16:07:44.893778+01 | 2021-01-04 16:07:44.893779+01 | Client | ClientRead | active | 451803 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1824681 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 35408 | 2021-01-04 16:08:44.946947+01 | 2021-01-04 16:08:44.962342+01 | 2021-01-04 16:08:44.962356+01 | 2021-01-04 16:08:44.962356+01 | Client | ClientRead | active | 451805 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1833606 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 39344 | 2021-01-04 16:25:59.791799+01 | 2021-01-04 16:25:59.811838+01 | 2021-01-04 16:25:59.811845+01 | 2021-01-04 16:25:59.811846+01 | Client | ClientRead | active | 451839 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1825193 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 37278 | 2021-01-04 16:09:45.006489+01 | 2021-01-04 16:09:45.020336+01 | 2021-01-04 16:09:45.020348+01 | 2021-01-04 16:09:45.020349+01 | Client | ClientRead | active | 451807 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1833662 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 39538 | 2021-01-04 16:26:07.05582+01 | 2021-01-04 16:26:07.076324+01 | 2021-01-04 16:26:07.076337+01 | 2021-01-04 16:26:07.076337+01 | Client | ClientRead | active | 451840 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1825705 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 39150 | 2021-01-04 16:10:45.072566+01 | 2021-01-04 16:10:45.089284+01 | 2021-01-04 16:10:45.089296+01 | 2021-01-04 16:10:45.089296+01 | Client | ClientRead | active | 451809 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16386 | QSMQ | 1835030 | 16388 | qliksenserepository | | 192.168.41.153 | | 44556 | 2021-01-04 16:28:44.505333+01 | | 2021-01-04 16:28:44.539081+01 | 2021-01-04 16:28:44.539122+01 | Client | ClientRead | idle | | | LISTEN messageadded | client backend
16386 | QSMQ | 1835032 | 16388 | qliksenserepository | | 192.168.41.153 | | 44560 | 2021-01-04 16:28:44.601417+01 | | 2021-01-04 16:28:44.611145+01 | 2021-01-04 16:28:44.611172+01 | Client | ClientRead | idle | | | LISTEN messageadded | client backend
16392 | QLogs | 1826218 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 41026 | 2021-01-04 16:11:45.138393+01 | 2021-01-04 16:11:45.154795+01 | 2021-01-04 16:11:45.154809+01 | 2021-01-04 16:11:45.154809+01 | Client | ClientRead | active | 451811 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16386 | QSMQ | 1835028 | 16388 | qliksenserepository | | 192.168.41.153 | | 44548 | 2021-01-04 16:28:43.969613+01 | | 2021-01-04 16:28:44.476883+01 | 2021-01-04 16:28:44.476986+01 | Client | ClientRead | idle | | | LISTEN messageadded | client backend
16386 | QSMQ | 1835035 | 16388 | qliksenserepository | | 192.168.41.153 | | 44572 | 2021-01-04 16:28:44.973974+01 | | 2021-01-04 16:28:45.605331+01 | 2021-01-04 16:28:45.605351+01 | Client | ClientRead | idle | | | COMMIT | client backend
16386 | QSMQ | 1835036 | 16388 | qliksenserepository | | 192.168.41.153 | | 44576 | 2021-01-04 16:28:44.976556+01 | | 2021-01-04 16:28:44.981469+01 | 2021-01-04 16:28:44.981525+01 | Client | ClientRead | idle | | | LISTEN messageadded | client backend
16386 | QSMQ | 1835038 | 16388 | qliksenserepository | | 192.168.41.153 | | 44586 | 2021-01-04 16:28:45.485671+01 | | 2021-01-04 16:28:45.501056+01 | 2021-01-04 16:28:45.501082+01 | Client | ClientRead | idle | | | LISTEN messageadded | client backend
16386 | QSMQ | 1835026 | 16388 | qliksenserepository | | 192.168.41.153 | | 44540 | 2021-01-04 16:28:43.764526+01 | | 2021-01-04 16:28:43.923412+01 | 2021-01-04 16:28:43.923469+01 | Client | ClientRead | idle | | | LISTEN messageadded | client backend
16392 | QLogs | 1834130 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 41274 | 2021-01-04 16:27:00.366517+01 | 2021-01-04 16:27:00.387145+01 | 2021-01-04 16:27:00.387157+01 | 2021-01-04 16:27:00.387158+01 | Client | ClientRead | active | 451841 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16386 | QSMQ | 1835027 | 16388 | qliksenserepository | | 192.168.41.153 | | 44544 | 2021-01-04 16:28:43.925098+01 | | 2021-01-04 16:28:43.941226+01 | 2021-01-04 16:28:43.941275+01 | Client | ClientRead | idle | | | LISTEN messageadded | client backend
16392 | QLogs | 1834192 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 41496 | 2021-01-04 16:27:07.422817+01 | 2021-01-04 16:27:07.445299+01 | 2021-01-04 16:27:07.445312+01 | 2021-01-04 16:27:07.445313+01 | Client | ClientRead | active | 451842 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16386 | QSMQ | 1835022 | 16388 | qliksenserepository | | 192.168.41.153 | | 44524 | 2021-01-04 16:28:43.571131+01 | | 2021-01-04 16:28:43.611597+01 | 2021-01-04 16:28:43.611632+01 | Client | ClientRead | idle | | | LISTEN messageadded | client backend
16392 | QLogs | 1828881 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 50760 | 2021-01-04 16:16:59.265134+01 | 2021-01-04 16:16:59.28188+01 | 2021-01-04 16:16:59.281891+01 | 2021-01-04 16:16:59.281891+01 | Client | ClientRead | active | 451822 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1829317 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 52358 | 2021-01-04 16:17:50.410557+01 | 2021-01-04 16:17:50.426509+01 | 2021-01-04 16:17:50.426517+01 | 2021-01-04 16:17:50.426518+01 | Client | ClientRead | active | 451823 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1829396 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 52642 | 2021-01-04 16:17:59.327731+01 | 2021-01-04 16:17:59.34652+01 | 2021-01-04 16:17:59.346528+01 | 2021-01-04 16:17:59.346528+01 | Client | ClientRead | active | 451824 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16386 | QSMQ | 1835029 | 16388 | qliksenserepository | | 192.168.41.153 | | 44552 | 2021-01-04 16:28:44.478636+01 | | 2021-01-04 16:28:44.503567+01 | 2021-01-04 16:28:44.5036+01 | Client | ClientRead | idle | | | LISTEN messageadded | client backend
16392 | QLogs | 1829919 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 54234 | 2021-01-04 16:18:50.581553+01 | 2021-01-04 16:18:50.596636+01 | 2021-01-04 16:18:50.596647+01 | 2021-01-04 16:18:50.596647+01 | Client | ClientRead | active | 451825 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16385 | SenseServices | 1835033 | 16388 | qliksenserepository | | 192.168.41.153 | | 44564 | 2021-01-04 16:28:44.768647+01 | | | 2021-01-04 16:28:44.770917+01 | Client | ClientRead | idle | | | | client backend
16385 | SenseServices | 1835034 | 16388 | qliksenserepository | | 192.168.41.153 | | 44568 | 2021-01-04 16:28:44.783999+01 | | | 2021-01-04 16:28:44.786079+01 | Client | ClientRead | idle | | | | client backend
16386 | QSMQ | 1835039 | 16388 | qliksenserepository | | 192.168.41.153 | | 44590 | 2021-01-04 16:28:45.584333+01 | | 2021-01-04 16:28:45.603633+01 | 2021-01-04 16:28:45.603669+01 | Client | ClientRead | idle | | | LISTEN messageadded | client backend
16386 | QSMQ | 1835037 | 16388 | qliksenserepository | | 192.168.41.153 | | 44580 | 2021-01-04 16:28:44.980892+01 | | 2021-01-04 16:28:44.984544+01 | 2021-01-04 16:28:44.984592+01 | Client | ClientRead | idle | | | LISTEN messageadded | client backend
16392 | QLogs | 1834721 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 43434 | 2021-01-04 16:28:07.779823+01 | 2021-01-04 16:28:07.799355+01 | 2021-01-04 16:28:07.799369+01 | 2021-01-04 16:28:07.799369+01 | Client | ClientRead | active | 451844 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1831512 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 60060 | 2021-01-04 16:21:59.559011+01 | 2021-01-04 16:21:59.574552+01 | 2021-01-04 16:21:59.574565+01 | 2021-01-04 16:21:59.574566+01 | Client | ClientRead | active | 451832 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1832536 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 35578 | 2021-01-04 16:23:59.674559+01 | 2021-01-04 16:23:59.690454+01 | 2021-01-04 16:23:59.690461+01 | 2021-01-04 16:23:59.690461+01 | Client | ClientRead | active | 451836 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1832026 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 33710 | 2021-01-04 16:22:59.614678+01 | 2021-01-04 16:22:59.63139+01 | 2021-01-04 16:22:59.631402+01 | 2021-01-04 16:22:59.631403+01 | Client | ClientRead | active | 451834 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
13092 | postgres | 1835040 | 10 | postgres | psql | 192.168.41.153 | | 44594 | 2021-01-04 16:28:45.603753+01 | 2021-01-04 16:28:45.606479+01 | 2021-01-04 16:28:45.606479+01 | 2021-01-04 16:28:45.606485+01 | | | active | | 451711 | select * from pg_stat_activity; | client backend
16392 | QLogs | 1832459 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 35298 | 2021-01-04 16:23:50.984305+01 | 2021-01-04 16:23:51.002463+01 | 2021-01-04 16:23:51.002475+01 | 2021-01-04 16:23:51.002476+01 | Client | ClientRead | active | 451835 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16392 | QLogs | 1833014 | 16391 | qlogs_writer | Qlik.Logging.Service:[LogServer] | 192.168.41.153 | | 37190 | 2021-01-04 16:24:51.056581+01 | 2021-01-04 16:24:51.139186+01 | 2021-01-04 16:24:51.139197+01 | 2021-01-04 16:24:51.139198+01 | Client | ClientRead | active | 451837 | | COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY | client backend
16386 | QSMQ | 1835025 | 16388 | qliksenserepository | | 192.168.41.153 | | 44536 | 2021-01-04 16:28:43.613539+01 | | 2021-01-04 16:28:43.759968+01 | 2021-01-04 16:28:43.760023+01 | Client | ClientRead | idle | | | LISTEN messageadded | client backend
| | 129841 | | | | | | | 2020-12-23 10:32:17.508463+01 | | | | Activity | BgWriterHibernate | | | | | background writer
| | 129840 | | | | | | | 2020-12-23 10:32:17.508383+01 | | | | Activity | CheckpointerMain | | | | | checkpointer
| | 129842 | | | | | | | 2020-12-23 10:32:17.508661+01 | | | | Activity | WalWriterMain | | | | | walwriter
(156 wierszy)
|
|
|
I found in pg_stat_activity query COPY, all query look such same: COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY All result of pg_stat_activity in attachment |
|
|
I think maybe older version would work good. What do you think? What will version compatible for query copy and parameter stdin? |
|
|
> COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY Thanks. Looks nothing unusual except "BINARY". So I tested several COPY patterns including "BINARY" option but I was not able to find any problem. Do you know any way to produce the issue (in ps output PostgreSQL is "COPY" but Pgpool-II is "idle")? > I think maybe older version would work good. What do you think? What will version compatible for query copy and parameter stdin? Not sure because the source code related to COPY has not been changed for long time. |
|
|
Is the COPY executed via "extended query mode" (i.e. Java)? If so, it is possible that ps staus for Pgpool-II could not be correct. This has been fixed in 4.2 but 4.1 still has the issue. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-12-23 00:06 | Ken | New Issue | |
| 2020-12-23 00:52 | Ken | Note Added: 0003680 | |
| 2020-12-23 13:46 | t-ishii | Assigned To | => t-ishii |
| 2020-12-23 13:46 | t-ishii | Status | new => assigned |
| 2020-12-23 13:57 | t-ishii | Note Added: 0003681 | |
| 2020-12-23 13:57 | t-ishii | Status | assigned => feedback |
| 2020-12-23 14:15 | t-ishii | Note Added: 0003682 | |
| 2020-12-23 17:20 | Ken | Note Added: 0003683 | |
| 2020-12-23 17:20 | Ken | Status | feedback => assigned |
| 2020-12-23 18:44 | t-ishii | Note Added: 0003684 | |
| 2020-12-23 18:44 | t-ishii | Status | assigned => feedback |
| 2020-12-24 00:59 | Ken | Note Added: 0003685 | |
| 2020-12-24 00:59 | Ken | Status | feedback => assigned |
| 2020-12-24 03:30 | t-ishii | Note Added: 0003686 | |
| 2020-12-24 03:31 | t-ishii | Status | assigned => feedback |
| 2020-12-28 23:27 | Ken | Note Added: 0003690 | |
| 2020-12-28 23:27 | Ken | Status | feedback => assigned |
| 2020-12-31 00:10 | Ken | File Added: pool_processes.txt | |
| 2020-12-31 00:10 | Ken | File Added: psaux.txt | |
| 2020-12-31 00:10 | Ken | Note Added: 0003694 | |
| 2020-12-31 11:05 | t-ishii | Note Added: 0003695 | |
| 2020-12-31 11:05 | t-ishii | Status | assigned => feedback |
| 2020-12-31 17:59 | Ken | File Added: pgpool.log | |
| 2020-12-31 17:59 | Ken | Note Added: 0003699 | |
| 2020-12-31 17:59 | Ken | Status | feedback => assigned |
| 2020-12-31 20:00 | t-ishii | Note Added: 0003700 | |
| 2020-12-31 20:00 | t-ishii | Status | assigned => feedback |
| 2020-12-31 23:54 | Ken | File Added: pgpool-2.log | |
| 2020-12-31 23:54 | Ken | Note Added: 0003701 | |
| 2020-12-31 23:54 | Ken | Status | feedback => assigned |
| 2021-01-01 10:08 | t-ishii | Note Added: 0003702 | |
| 2021-01-01 10:09 | t-ishii | Status | assigned => feedback |
| 2021-01-01 11:50 | t-ishii | Note Added: 0003703 | |
| 2021-01-04 20:13 | Ken | File Added: psaux | |
| 2021-01-04 20:13 | Ken | Note Added: 0003708 | |
| 2021-01-04 20:13 | Ken | Status | feedback => assigned |
| 2021-01-04 21:58 | t-ishii | Note Added: 0003709 | |
| 2021-01-04 21:58 | t-ishii | Status | assigned => feedback |
| 2021-01-05 00:35 | Ken | File Added: pg_stat_activity | |
| 2021-01-05 00:35 | Ken | Note Added: 0003710 | |
| 2021-01-05 00:35 | Ken | Status | feedback => assigned |
| 2021-01-05 18:54 | t-ishii | Note Edited: 0003709 | |
| 2021-01-05 23:19 | Ken | Note Added: 0003711 | |
| 2021-01-06 10:40 | t-ishii | Note Added: 0003712 | |
| 2021-01-06 10:40 | t-ishii | Status | assigned => feedback |
| 2021-01-06 17:00 | t-ishii | Note Added: 0003713 |
