20180722-15290-pg_stat_activity.txt

-[ RECORD 2 ]----+-----------------------------------------------------------------------------------------------------
datid            | 16401
datname          | coub
pid              | 3416
usesysid         | 16384
usename          | app
application_name | 
client_addr      | 
client_hostname  | 
client_port      | 
backend_start    | 2018-07-22 12:01:15.035754+03
xact_start       | 2018-07-22 12:01:15.035121+03
query_start      | 2018-07-22 12:01:15.035121+03
state_change     | 2018-07-22 12:01:15.036292+03
wait_event_type  | IPC
wait_event       | BtreePage
state            | active
backend_xid      | 
backend_xmin     | 1172840663
query            | select count(*) as value from coubs where type='Coub::Simple' and is_done=false and in_process=false
backend_type     | background worker
-[ RECORD 3 ]----+-----------------------------------------------------------------------------------------------------
datid            | 16401
datname          | coub
pid              | 3417
usesysid         | 16384
usename          | app
application_name | 
client_addr      | 
client_hostname  | 
client_port      | 
backend_start    | 2018-07-22 12:01:15.037382+03
xact_start       | 2018-07-22 12:01:15.036679+03
query_start      | 2018-07-22 12:01:15.036679+03
state_change     | 2018-07-22 12:01:15.037955+03
wait_event_type  | IPC
wait_event       | BtreePage
state            | active
backend_xid      | 
backend_xmin     | 1172840663
query            | select count(*) as value from coubs where type='Coub::Simple' and is_done=false and in_process=false
backend_type     | background worker
-[ RECORD 4 ]----+-----------------------------------------------------------------------------------------------------
datid            | 16401
datname          | coub
pid              | 2877
usesysid         | 16384
usename          | app
application_name | 
client_addr      | 
client_hostname  | 
client_port      | -1
backend_start    | 2018-07-22 11:59:15.039972+03
xact_start       | 2018-07-22 12:01:15.032002+03
query_start      | 2018-07-22 12:01:15.032002+03
state_change     | 2018-07-22 12:01:15.032003+03
wait_event_type  | IPC
wait_event       | BgWorkerShutdown
state            | active
backend_xid      | 
backend_xmin     | 1172840663
query            | select count(*) as value from coubs where type='Coub::Simple' and is_done=false and in_process=false
backend_type     | client backend
-[ RECORD 5 ]----+-----------------------------------------------------------------------------------------------------
datid            | 16401
datname          | coub
pid              | 3418
usesysid         | 16384
usename          | app
application_name | 
client_addr      | 
client_hostname  | 
client_port      | 
backend_start    | 2018-07-22 12:01:15.038647+03
xact_start       | 2018-07-22 12:01:15.038105+03
query_start      | 2018-07-22 12:01:15.038105+03
state_change     | 2018-07-22 12:01:15.039151+03
wait_event_type  | IPC
wait_event       | BtreePage
state            | active
backend_xid      | 
backend_xmin     | 1172840663
query            | select count(*) as value from coubs where type='Coub::Simple' and is_done=false and in_process=false
backend_type     | background worker
-[ RECORD 6 ]----+-----------------------------------------------------------------------------------------------------
datid            | 16401
datname          | coub
pid              | 3419
usesysid         | 16384
usename          | app
application_name | 
client_addr      | 
client_hostname  | 
client_port      | 
backend_start    | 2018-07-22 12:01:15.040754+03
xact_start       | 2018-07-22 12:01:15.039853+03
query_start      | 2018-07-22 12:01:15.039853+03
state_change     | 2018-07-22 12:01:15.041481+03
wait_event_type  | IPC
wait_event       | BtreePage
state            | active
backend_xid      | 
backend_xmin     | 1172840663
query            | select count(*) as value from coubs where type='Coub::Simple' and is_done=false and in_process=false
backend_type     | background worker