search

ergoplatform / explorer-back

Ergo blockchain explorer backend
4 stars 5 forks source link

DB connections leak #204

Open andyceo opened 5 years ago

andyceo commented 5 years ago 
postgres=# SELECT * from pg_stat_activity ;
 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     
-------+----------+------+----------+----------+------------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-----------------+---------------------+---------------------+-------------+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------
       |          |   22 |          |          |                        |             |                 |             | 2019-09-04 15:04:20.076121+00 |                               |                               |                               | Activity        | AutoVacuumMain      |                     |             |              |                                                                                                                                                                                                                | autovacuum launcher
       |          |   24 |       10 | postgres |                        |             |                 |             | 2019-09-04 15:04:20.081415+00 |                               |                               |                               | Activity        | LogicalLauncherMain |                     |             |              |                                                                                                                                                                                                                | background worker
 16384 | explorer | 2091 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       41002 | 2019-09-24 08:37:43.953959+00 |                               | 2019-09-24 08:37:43.957703+00 | 2019-09-24 08:37:43.957732+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3271 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       41674 | 2019-09-24 09:56:23.339363+00 |                               | 2019-09-24 09:56:23.342921+00 | 2019-09-24 09:56:23.342951+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2300 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       53076 | 2019-09-24 08:54:37.229971+00 |                               | 2019-09-24 08:54:37.233288+00 | 2019-09-24 08:54:37.233317+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3176 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       37976 | 2019-09-24 09:51:24.874109+00 |                               | 2019-09-24 09:51:24.877747+00 | 2019-09-24 09:51:24.877777+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2382 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       56044 | 2019-09-24 08:58:40.07867+00  |                               | 2019-09-24 08:58:40.082222+00 | 2019-09-24 08:58:40.082252+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3348 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       44438 | 2019-09-24 10:00:10.104815+00 |                               | 2019-09-24 10:00:10.109384+00 | 2019-09-24 10:00:10.109422+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2176 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       44506 | 2019-09-24 08:42:36.235301+00 |                               | 2019-09-24 08:42:36.238881+00 | 2019-09-24 08:42:36.238911+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2036 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       39372 | 2019-09-24 08:35:33.45163+00  |                               | 2019-09-24 08:35:33.455276+00 | 2019-09-24 08:35:33.455305+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3357 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       45204 | 2019-09-24 10:01:14.787851+00 |                               | 2019-09-24 10:01:14.795279+00 | 2019-09-24 10:01:14.795309+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3605 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       52876 | 2019-09-24 10:20:06.851655+00 | 2019-09-24 10:29:29.934263+00 | 2019-09-24 10:29:29.934345+00 | 2019-09-24 10:29:29.934392+00 | Client          | ClientRead          | idle in transaction |             |      3466896 | SELECT id, parent_id, version, height, n_bits, difficulty, timestamp, state_root, ad_proofs_root, transactions_root, extension_hash, miner_pk, w, n, d, votes, main_chain FROM node_headers WHERE height = $1  | client backend
 16384 | explorer | 1958 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       36954 | 2019-09-24 08:32:18.368979+00 |                               | 2019-09-24 08:32:18.372495+00 | 2019-09-24 08:32:18.372527+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2079 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       40656 | 2019-09-24 08:37:15.606292+00 |                               | 2019-09-24 08:37:15.609634+00 | 2019-09-24 08:37:15.609664+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3254 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       41220 | 2019-09-24 09:55:47.974075+00 |                               | 2019-09-24 09:55:47.977607+00 | 2019-09-24 09:55:47.977637+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2524 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       39000 | 2019-09-24 09:14:17.259212+00 |                               | 2019-09-24 09:14:17.26271+00  | 2019-09-24 09:14:17.26274+00  | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2310 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       53854 | 2019-09-24 08:55:43.728184+00 |                               | 2019-09-24 08:55:43.731649+00 | 2019-09-24 08:55:43.731679+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2092 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       41004 | 2019-09-24 08:37:43.959019+00 |                               | 2019-09-24 08:37:43.961935+00 | 2019-09-24 08:37:43.961964+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2824 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       51068 | 2019-09-24 09:30:44.464575+00 |                               | 2019-09-24 09:30:44.467909+00 | 2019-09-24 09:30:44.467939+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2677 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       45058 | 2019-09-24 09:22:31.461661+00 |                               | 2019-09-24 09:22:31.465244+00 | 2019-09-24 09:22:31.465274+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2776 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       49018 | 2019-09-24 09:27:56.054495+00 |                               | 2019-09-24 09:27:56.058266+00 | 2019-09-24 09:27:56.058296+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2361 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       55570 | 2019-09-24 08:58:02.657858+00 |                               | 2019-09-24 08:58:02.666125+00 | 2019-09-24 08:58:02.666155+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 12292 | postgres |   46 |       10 | postgres |                        | 10.0.0.2    |                 |       49482 | 2019-09-04 15:05:10.038222+00 |                               | 2019-09-24 10:29:30.636568+00 | 2019-09-24 10:29:30.636664+00 | Client          | ClientRead          | idle                |             |              | SELECT * FROM pg_stat_bgwriter                                                                                                                                                                                 | client backend
 16384 | explorer | 2374 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       55926 | 2019-09-24 08:58:31.007286+00 |                               | 2019-09-24 08:58:31.014092+00 | 2019-09-24 08:58:31.014123+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2472 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       60362 | 2019-09-24 09:04:35.368007+00 |                               | 2019-09-24 09:04:35.371495+00 | 2019-09-24 09:04:35.371525+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3670 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       54128 | 2019-09-24 10:21:27.420766+00 |                               | 2019-09-24 10:29:30.071679+00 | 2019-09-24 10:29:30.071758+00 | Client          | ClientRead          | idle                |             |              | COMMIT                                                                                                                                                                                                         | client backend
 16384 | explorer | 3211 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       39374 | 2019-09-24 09:53:19.570665+00 |                               | 2019-09-24 09:53:19.57446+00  | 2019-09-24 09:53:19.574495+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2838 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       51432 | 2019-09-24 09:31:12.809526+00 |                               | 2019-09-24 09:31:12.81308+00  | 2019-09-24 09:31:12.813112+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2492 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       33324 | 2019-09-24 09:06:13.748357+00 |                               | 2019-09-24 09:06:13.751969+00 | 2019-09-24 09:06:13.751999+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3606 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       52880 | 2019-09-24 10:20:07.092475+00 |                               | 2019-09-24 10:29:29.932513+00 | 2019-09-24 10:29:29.932574+00 | Client          | ClientRead          | idle                |             |              | COMMIT                                                                                                                                                                                                         | client backend
 16384 | explorer | 2954 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       56316 | 2019-09-24 09:37:51.883712+00 |                               | 2019-09-24 09:37:51.887037+00 | 2019-09-24 09:37:51.887068+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3625 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       53078 | 2019-09-24 10:20:20.59477+00  |                               | 2019-09-24 10:29:29.935031+00 | 2019-09-24 10:29:29.935065+00 | Client          | ClientRead          | idle                |             |              | COMMIT                                                                                                                                                                                                         | client backend
 16384 | explorer | 3804 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       58030 | 2019-09-24 10:25:54.114781+00 |                               | 2019-09-24 10:29:23.186214+00 | 2019-09-24 10:29:23.186273+00 | Client          | ClientRead          | idle                |             |              | COMMIT                                                                                                                                                                                                         | client backend
 16384 | explorer | 3301 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       42888 | 2019-09-24 09:58:01.711667+00 |                               | 2019-09-24 09:58:01.715452+00 | 2019-09-24 09:58:01.715482+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2516 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       37408 | 2019-09-24 09:12:01.707718+00 |                               | 2019-09-24 09:12:01.711285+00 | 2019-09-24 09:12:01.711317+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2163 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       44214 | 2019-09-24 08:42:12.641124+00 |                               | 2019-09-24 08:42:12.648869+00 | 2019-09-24 08:42:12.648898+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2160 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       44204 | 2019-09-24 08:42:11.000032+00 |                               | 2019-09-24 08:42:11.005629+00 | 2019-09-24 08:42:11.005659+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3389 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       47226 | 2019-09-24 10:04:02.430739+00 |                               | 2019-09-24 10:04:02.434544+00 | 2019-09-24 10:04:02.434592+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2521 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       38430 | 2019-09-24 09:13:28.337518+00 |                               | 2019-09-24 09:13:28.341475+00 | 2019-09-24 09:13:28.341507+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2984 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       58184 | 2019-09-24 09:40:30.292831+00 |                               | 2019-09-24 09:40:30.296537+00 | 2019-09-24 09:40:30.296568+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3212 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       39392 | 2019-09-24 09:53:19.575907+00 |                               | 2019-09-24 09:53:19.579117+00 | 2019-09-24 09:53:19.579148+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3390 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       47246 | 2019-09-24 10:04:03.20827+00  |                               | 2019-09-24 10:04:03.214382+00 | 2019-09-24 10:04:03.214413+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2254 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       51470 | 2019-09-24 08:52:26.111098+00 |                               | 2019-09-24 08:52:26.114805+00 | 2019-09-24 08:52:26.114835+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2952 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       56092 | 2019-09-24 09:37:34.430721+00 |                               | 2019-09-24 09:37:34.434293+00 | 2019-09-24 09:37:34.434337+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3302 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       42890 | 2019-09-24 09:58:01.716846+00 |                               | 2019-09-24 09:58:01.719728+00 | 2019-09-24 09:58:01.719757+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3083 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       33968 | 2019-09-24 09:45:57.149334+00 |                               | 2019-09-24 09:45:57.158707+00 | 2019-09-24 09:45:57.15875+00  | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3160 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       37610 | 2019-09-24 09:50:56.51898+00  |                               | 2019-09-24 09:50:56.522613+00 | 2019-09-24 09:50:56.522643+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3117 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       35564 | 2019-09-24 09:48:10.09689+00  |                               | 2019-09-24 09:48:10.100454+00 | 2019-09-24 09:48:10.100484+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2336 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       54346 | 2019-09-24 08:56:22.07942+00  |                               | 2019-09-24 08:56:22.082828+00 | 2019-09-24 08:56:22.082858+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3391 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       47248 | 2019-09-24 10:04:03.215466+00 |                               | 2019-09-24 10:04:03.223561+00 | 2019-09-24 10:04:03.223592+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2080 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       40658 | 2019-09-24 08:37:15.611035+00 |                               | 2019-09-24 08:37:15.613968+00 | 2019-09-24 08:37:15.613998+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2049 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       39560 | 2019-09-24 08:35:47.049364+00 |                               | 2019-09-24 08:35:47.052949+00 | 2019-09-24 08:35:47.052979+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3392 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       47250 | 2019-09-24 10:04:03.224779+00 |                               | 2019-09-24 10:04:03.230749+00 | 2019-09-24 10:04:03.230782+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3013 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       59400 | 2019-09-24 09:42:08.668692+00 |                               | 2019-09-24 09:42:08.67233+00  | 2019-09-24 09:42:08.672359+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3607 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       52882 | 2019-09-24 10:20:07.119142+00 |                               | 2019-09-24 10:29:30.073333+00 | 2019-09-24 10:29:30.07338+00  | Client          | ClientRead          | idle                |             |              | COMMIT                                                                                                                                                                                                         | client backend
 16384 | explorer | 2910 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       54632 | 2019-09-24 09:35:35.159076+00 |                               | 2019-09-24 09:35:35.162712+00 | 2019-09-24 09:35:35.162742+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 1996 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       38146 | 2019-09-24 08:33:55.075141+00 |                               | 2019-09-24 08:33:55.078658+00 | 2019-09-24 08:33:55.078687+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 1972 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       37306 | 2019-09-24 08:32:46.712935+00 |                               | 2019-09-24 08:32:46.716893+00 | 2019-09-24 08:32:46.716923+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2561 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       40632 | 2019-09-24 09:16:30.901119+00 |                               | 2019-09-24 09:16:30.906284+00 | 2019-09-24 09:16:30.906314+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3608 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       52884 | 2019-09-24 10:20:07.134526+00 |                               | 2019-09-24 10:29:30.072806+00 | 2019-09-24 10:29:30.072854+00 | Client          | ClientRead          | idle                |             |              | COMMIT                                                                                                                                                                                                         | client backend
 16384 | explorer | 2456 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       59102 | 2019-09-24 09:02:49.542727+00 |                               | 2019-09-24 09:02:49.547182+00 | 2019-09-24 09:02:49.547218+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2570 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       40800 | 2019-09-24 09:16:44.243645+00 |                               | 2019-09-24 09:16:44.247397+00 | 2019-09-24 09:16:44.247427+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3609 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       52886 | 2019-09-24 10:20:07.157261+00 |                               | 2019-09-24 10:29:29.933989+00 | 2019-09-24 10:29:29.934021+00 | Client          | ClientRead          | idle                |             |              | COMMIT                                                                                                                                                                                                         | client backend
 16384 | explorer | 2659 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       44642 | 2019-09-24 09:21:59.215421+00 |                               | 2019-09-24 09:21:59.219044+00 | 2019-09-24 09:21:59.219074+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2277 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       52278 | 2019-09-24 08:53:31.587278+00 |                               | 2019-09-24 08:53:31.594798+00 | 2019-09-24 08:53:31.594841+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2039 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       39378 | 2019-09-24 08:35:34.710729+00 |                               | 2019-09-24 08:35:34.714471+00 | 2019-09-24 08:35:34.714501+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2164 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       44216 | 2019-09-24 08:42:12.738583+00 |                               | 2019-09-24 08:42:12.742663+00 | 2019-09-24 08:42:12.742706+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3325 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       43684 | 2019-09-24 09:59:06.396544+00 |                               | 2019-09-24 09:59:06.400173+00 | 2019-09-24 09:59:06.400202+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2580 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       41050 | 2019-09-24 09:17:02.986543+00 |                               | 2019-09-24 09:17:02.991859+00 | 2019-09-24 09:17:02.991901+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2013 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       38594 | 2019-09-24 08:34:30.530735+00 |                               | 2019-09-24 08:34:30.538112+00 | 2019-09-24 08:34:30.538143+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3358 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       45206 | 2019-09-24 10:01:14.796719+00 |                               | 2019-09-24 10:01:14.800383+00 | 2019-09-24 10:01:14.800412+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2730 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       47426 | 2019-09-24 09:25:47.664338+00 |                               | 2019-09-24 09:25:47.667807+00 | 2019-09-24 09:25:47.667841+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2052 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       39826 | 2019-09-24 08:36:08.911668+00 |                               | 2019-09-24 08:36:08.915173+00 | 2019-09-24 08:36:08.915203+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3130 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       35772 | 2019-09-24 09:48:26.347303+00 |                               | 2019-09-24 09:48:26.35069+00  | 2019-09-24 09:48:26.350726+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2594 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       41462 | 2019-09-24 09:17:36.121659+00 |                               | 2019-09-24 09:17:36.125809+00 | 2019-09-24 09:17:36.125873+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2311 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       53856 | 2019-09-24 08:55:43.73277+00  |                               | 2019-09-24 08:55:43.735893+00 | 2019-09-24 08:55:43.735921+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2925 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       55108 | 2019-09-24 09:36:12.74875+00  |                               | 2019-09-24 09:36:12.753198+00 | 2019-09-24 09:36:12.753229+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3014 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       59402 | 2019-09-24 09:42:08.673994+00 |                               | 2019-09-24 09:42:08.677206+00 | 2019-09-24 09:42:08.677237+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2660 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       44644 | 2019-09-24 09:21:59.220443+00 |                               | 2019-09-24 09:21:59.22364+00  | 2019-09-24 09:21:59.22367+00  | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2351 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       54706 | 2019-09-24 08:56:50.4238+00   |                               | 2019-09-24 08:56:50.427381+00 | 2019-09-24 08:56:50.42741+00  | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2457 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       59104 | 2019-09-24 09:02:49.548873+00 |                               | 2019-09-24 09:02:49.552401+00 | 2019-09-24 09:02:49.552435+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2926 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       55110 | 2019-09-24 09:36:12.755724+00 |                               | 2019-09-24 09:36:12.762567+00 | 2019-09-24 09:36:12.762598+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2753 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       48198 | 2019-09-24 09:26:49.914505+00 |                               | 2019-09-24 09:26:49.918167+00 | 2019-09-24 09:26:49.918197+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2397 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       56332 | 2019-09-24 08:59:01.8753+00   |                               | 2019-09-24 08:59:01.878883+00 | 2019-09-24 08:59:01.878928+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2419 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       57534 | 2019-09-24 09:00:40.264626+00 |                               | 2019-09-24 09:00:40.26832+00  | 2019-09-24 09:00:40.26835+00  | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3090 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       34024 | 2019-09-24 09:46:01.482979+00 |                               | 2019-09-24 09:46:01.487294+00 | 2019-09-24 09:46:01.487326+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2505 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       33672 | 2019-09-24 09:06:42.092856+00 |                               | 2019-09-24 09:06:42.096477+00 | 2019-09-24 09:06:42.096507+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3683 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       54348 | 2019-09-24 10:21:40.778556+00 |                               | 2019-09-24 10:29:29.934643+00 | 2019-09-24 10:29:29.934698+00 | Client          | ClientRead          | idle                |             |              | COMMIT                                                                                                                                                                                                         | client backend
 16384 | explorer | 2935 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       55830 | 2019-09-24 09:37:13.529801+00 |                               | 2019-09-24 09:37:13.536205+00 | 2019-09-24 09:37:13.536236+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3610 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       52888 | 2019-09-24 10:20:07.176745+00 |                               | 2019-09-24 10:29:29.933652+00 | 2019-09-24 10:29:29.933685+00 | Client          | ClientRead          | idle                |             |              | COMMIT                                                                                                                                                                                                         | client backend
 16384 | explorer | 3704 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       55184 | 2019-09-24 10:22:35.595062+00 |                               | 2019-09-24 10:29:29.650349+00 | 2019-09-24 10:29:29.650469+00 | Client          | ClientRead          | idle                |             |              | ROLLBACK                                                                                                                                                                                                       | client backend
 16384 | explorer | 3049 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       60868 | 2019-09-24 09:44:08.75692+00  |                               | 2019-09-24 09:44:08.760661+00 | 2019-09-24 09:44:08.760691+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2555 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       40266 | 2019-09-24 09:16:00.462939+00 |                               | 2019-09-24 09:16:00.466666+00 | 2019-09-24 09:16:00.466707+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 3647 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       53664 | 2019-09-24 10:20:58.997371+00 | 2019-09-24 10:29:29.933265+00 | 2019-09-24 10:29:29.933348+00 | 2019-09-24 10:29:29.933404+00 | Client          | ClientRead          | idle in transaction |             |      3466896 | SELECT id, parent_id, version, height, n_bits, difficulty, timestamp, state_root, ad_proofs_root, transactions_root, extension_hash, miner_pk, w, n, d, votes, main_chain FROM node_headers WHERE height = $1  | client backend
 16384 | explorer | 2065 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       40174 | 2019-09-24 08:36:37.254138+00 |                               | 2019-09-24 08:36:37.257743+00 | 2019-09-24 08:36:37.257772+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2137 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       43358 | 2019-09-24 08:41:03.378729+00 |                               | 2019-09-24 08:41:03.382706+00 | 2019-09-24 08:41:03.382744+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2839 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       51434 | 2019-09-24 09:31:12.814447+00 |                               | 2019-09-24 09:31:12.817513+00 | 2019-09-24 09:31:12.817541+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2842 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       51502 | 2019-09-24 09:31:18.375009+00 |                               | 2019-09-24 09:31:18.379745+00 | 2019-09-24 09:31:18.379776+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 16384 | explorer | 2867 |    16385 | ergo     | PostgreSQL JDBC Driver | 10.0.0.2    |                 |       53034 | 2019-09-24 09:33:26.765675+00 |                               | 2019-09-24 09:33:26.769337+00 | 2019-09-24 09:33:26.769367+00 | Client          | ClientRead          | idle                |             |              | SET application_name = 'PostgreSQL JDBC Driver'                                                                                                                                                                | client backend
 12292 | postgres | 3874 |       10 | postgres | psql                   |             |                 |          -1 | 2019-09-24 10:28:49.271839+00 | 2019-09-24 10:29:30.969613+00 | 2019-09-24 10:29:30.969613+00 | 2019-09-24 10:29:30.969617+00 |                 |                     | active              |             |      3466896 | SELECT * from pg_stat_activity ;                                                                                                                                                                               | client backend
       |          |   20 |          |          |                        |             |                 |             | 2019-09-04 15:04:20.075462+00 |                               |                               |                               | Activity        | BgWriterMain        |                     |             |              |                                                                                                                                                                                                                | background writer
       |          |   19 |          |          |                        |             |                 |             | 2019-09-04 15:04:20.076004+00 |                               |                               |                               | Activity        | CheckpointerMain    |                     |             |              |                                                                                                                                                                                                                | checkpointer
       |          |   21 |          |          |                        |             |                 |             | 2019-09-04 15:04:20.075077+00 |                               |                               |                               | Activity        | WalWriterMain       |                     |             |              |                                                                                                                                                                                                                | walwriter
(103 rows)
andyceo commented 5 years ago

Update for @oskin1 :

You can log into db with admin privileges from server: sudo docker exec -ti <CONTAINER_ID> psql -U postgres

Execute following to view processes: SELECT * from pg_stat_activity ;

Execute to destroy all process: select pg_terminate_backend(pid) from pg_stat_activity where datname='explorer';