Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- payment=# 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 | waiting | state | backend_xid | backend_xmin | query
- --------+---------+-------+----------+---------+-----------------------------------------------------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+---------+---------------------+-------------+--------------+----------------------------------------------------------------------------------------------------------------
- 115053 | payment | 49240 | 16385 | koreth | saga-thread-4 | 127.0.0.1 | | 61252 | 2016-02-14 13:33:07.195781-08 | 2016-02-14 13:33:48.526562-08 | 2016-02-14 13:52:54.007417-08 | 2016-02-14 13:52:54.007472-08 | f | idle in transaction | | 3101955 | SELECT sagaId FROM AssociationValueEntry WHERE associationKey = $1 AND associationValue = $2 AND sagaType = $3
- 115053 | payment | 49241 | 16385 | koreth | QuartzScheduler_org.springfram...0-NON_CLUSTERED_MisfireHandler | 127.0.0.1 | | 61253 | 2016-02-14 13:33:07.223672-08 | | 2016-02-14 13:53:45.616056-08 | 2016-02-14 13:53:45.616154-08 | f | idle | | | COMMIT
- 115053 | payment | 49284 | 16385 | koreth | saga-thread-5 | 127.0.0.1 | | 61259 | 2016-02-14 13:33:48.457022-08 | 2016-02-14 13:33:48.542306-08 | 2016-02-14 13:52:36.815366-08 | 2016-02-14 13:52:36.815412-08 | f | idle in transaction | | 3101955 | SELECT sagaId FROM AssociationValueEntry WHERE associationKey = $1 AND associationValue = $2 AND sagaType = $3
- 115053 | payment | 49283 | 16385 | koreth | saga-thread-6 | 127.0.0.1 | | 61258 | 2016-02-14 13:33:48.455688-08 | 2016-02-14 13:33:48.543192-08 | 2016-02-14 13:52:36.816883-08 | 2016-02-14 13:52:36.816916-08 | f | idle in transaction | | 3101955 | SELECT sagaId FROM AssociationValueEntry WHERE associationKey = $1 AND associationValue = $2 AND sagaType = $3
- 115053 | payment | 49285 | 16385 | koreth | saga-thread-2 | 127.0.0.1 | | 61260 | 2016-02-14 13:33:48.458705-08 | 2016-02-14 13:33:48.54246-08 | 2016-02-14 13:52:53.999086-08 | 2016-02-14 13:52:53.999143-08 | f | idle in transaction | | 3101955 | SELECT sagaId FROM AssociationValueEntry WHERE associationKey = $1 AND associationValue = $2 AND sagaType = $3
- 115053 | payment | 49286 | 16385 | koreth | saga-thread-1 | 127.0.0.1 | | 61261 | 2016-02-14 13:33:48.459651-08 | 2016-02-14 13:34:00.101528-08 | 2016-02-14 13:52:53.999205-08 | 2016-02-14 13:52:53.999222-08 | f | idle in transaction | | 3101955 | SELECT sagaId FROM AssociationValueEntry WHERE associationKey = $1 AND associationValue = $2 AND sagaType = $3
- 115053 | payment | 49287 | 16385 | koreth | saga-thread-3 | 127.0.0.1 | | 61262 | 2016-02-14 13:33:48.471204-08 | 2016-02-14 13:34:00.101706-08 | 2016-02-14 13:52:53.998396-08 | 2016-02-14 13:52:53.998417-08 | f | idle in transaction | | 3101955 | SELECT sagaId FROM AssociationValueEntry WHERE associationKey = $1 AND associationValue = $2 AND sagaType = $3
- 115053 | payment | 49288 | 16385 | koreth | saga-thread-0 | 127.0.0.1 | | 61263 | 2016-02-14 13:33:48.472715-08 | 2016-02-14 13:35:28.986346-08 | 2016-02-14 13:52:53.999285-08 | 2016-02-14 13:52:53.9993-08 | f | idle in transaction | | 3101955 | SELECT sagaId FROM AssociationValueEntry WHERE associationKey = $1 AND associationValue = $2 AND sagaType = $3
- 115053 | payment | 49368 | 16385 | koreth | org.springframework.scheduling...ryBean#0_QuartzSchedulerThread | 127.0.0.1 | | 61277 | 2016-02-14 13:35:17.405837-08 | | 2016-02-14 13:54:17.955573-08 | 2016-02-14 13:54:17.955598-08 | f | idle | | | COMMIT
- 115053 | payment | 49369 | 16385 | koreth | org.springframework.scheduling...ryBean#0_QuartzSchedulerThread | 127.0.0.1 | | 61278 | 2016-02-14 13:35:17.407079-08 | | 2016-02-14 13:53:45.610607-08 | 2016-02-14 13:53:45.610621-08 | f | idle | | | COMMIT
- 115053 | payment | 39256 | 10 | koreth | psql | | | -1 | 2016-02-14 10:44:14.390196-08 | 2016-02-14 13:54:33.685107-08 | 2016-02-14 13:54:33.685107-08 | 2016-02-14 13:54:33.68511-08 | f | active | | 3101956 | select * from pg_stat_activity ;
- (11 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
