Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- pid | state | wait_event | xact_start | query_start | query
- -------+---------------------+----------------------------+-------------------------------+-------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- 1649 | | | | | <insufficient privilege>
- 1651 | | | | | <insufficient privilege>
- 3145 | idle | ClientRead | | 2020-09-30 17:11:42.064721-04 | ROLLBACK
- 3146 | active | | 2020-09-30 22:40:04.390738-04 | 2020-09-30 22:40:04.391899-04 | SELECT auth."user".user_id <>, auth."user".created_date AS auth_user_created_date, auth."user".last_login_date AS auth_user_last_login_date +
- | | | | | FROM auth."user" +
- | | | | | WHERE auth."user".user_id = -2
- 3147 | idle | ClientRead | | 2020-09-30 16:18:13.906803-04 | ROLLBACK
- 3148 | active | | 2020-09-30 22:40:04.145926-04 | 2020-09-30 22:40:04.147153-04 | SELECT auth."user".user_id <>, auth."user".created_date AS auth_user_created_date, auth."user".last_login_date AS auth_user_last_login_date +
- | | | | | FROM auth."user" +
- | | | | | WHERE auth."user".user_id = -2
- 3149 | active | MultiXactOffsetControlLock | 2020-09-30 22:40:04.33811-04 | 2020-09-30 22:40:04.339572-04 | SELECT auth."user".user_id <>, auth."user".created_date AS auth_user_created_date, auth."user".last_login_date AS auth_user_last_login_date +
- | | | | | FROM auth."user" +
- | | | | | WHERE auth."user".user_id = -2
- 7840 | idle | ClientRead | | 2020-09-30 22:15:29.215356-04 | ROLLBACK
- 14994 | idle | ClientRead | | 2020-09-30 16:48:59.34612-04 | ROLLBACK
- 2724 | active | | 2020-09-30 22:40:04.659671-04 | 2020-09-30 22:40:04.659671-04 | select pid, state, wait_event, xact_start,query_start, query from pg_stat_activity;
- 3153 | active | | 2020-09-30 22:40:04.18476-04 | 2020-09-30 22:40:04.186143-04 | SELECT auth."user".user_id <>, auth."user".created_date AS auth_user_created_date, auth."user".last_login_date AS auth_user_last_login_date +
- | | | | | FROM auth."user" +
- | | | | | WHERE auth."user".user_id = -2
- 14875 | idle | ClientRead | | 2020-09-30 22:16:27.641829-04 | select pid, xact_start,query_start, query from pg_stat_activity where xact_start is not null;
- 3155 | active | MultiXactOffsetControlLock | 2020-09-30 22:40:04.130107-04 | 2020-09-30 22:40:04.131599-04 | SELECT auth."user".user_id <>, auth."user".created_date AS auth_user_created_date, auth."user".last_login_date AS auth_user_last_login_date +
- | | | | | FROM auth."user" +
- | | | | | WHERE auth."user".user_id = -2
- 7587 | idle | ClientRead | | 2020-09-30 21:44:50.321819-04 | ROLLBACK
- 12768 | idle | ClientRead | | 2020-09-30 16:19:10.120838-04 | ROLLBACK
- 7819 | active | MultiXactOffsetControlLock | 2020-09-30 22:40:04.541498-04 | 2020-09-30 22:40:04.542917-04 | SELECT auth."user".user_id <>, auth."user".created_date AS auth_user_created_date, auth."user".last_login_date AS auth_user_last_login_date +
- | | | | | FROM auth."user" +
- | | | | | WHERE auth."user".user_id = -2
- 7828 | idle in transaction | ClientRead | 2020-09-30 18:24:09.234009-04 | 2020-09-30 18:24:09.411903-04 | INSERT INTO api.log (user_id, level, trace, msg, user_agent, remote_ip, endpoint, method, log_type) VALUES ( -2, 'INFO', NULL, 'Created job(29223) target(5110)', 'python-requests/2.22.0', 'xx.xx.xx.xx', '/api/target?tax_rank=phylum&ms2_score_cutoff=0.2', 'POST', 'api') RETURNING api.log.log_id
- 7829 | idle | ClientRead | | 2020-09-30 21:42:18.883982-04 | ROLLBACK
- 7830 | active | | 2020-09-30 22:40:03.76508-04 | 2020-09-30 22:40:04.350322-04 | UPDATE auth."user" SET last_login_date='2020-10-01T02:40:04.349599'::timestamp WHERE auth."user".user_id = -2
- 7834 | idle | ClientRead | | 2020-09-30 22:39:12.869048-04 | ROLLBACK
- 7835 | idle | ClientRead | | 2020-09-30 22:19:08.843584-04 | ROLLBACK
- 7836 | active | | 2020-09-30 22:40:04.144516-04 | 2020-09-30 22:40:04.145754-04 | SELECT auth."user".user_id <>, auth."user".created_date AS auth_user_created_date, auth."user".last_login_date AS auth_user_last_login_date +
- | | | | | FROM auth."user" +
- | | | | | WHERE auth."user".user_id = -2
- 7837 | idle | ClientRead | | 2020-09-30 22:39:55.909803-04 | ROLLBACK
- 7841 | idle | ClientRead | | 2020-09-30 22:10:13.47573-04 | ROLLBACK
- 7842 | idle | ClientRead | | 2020-09-30 22:39:24.835903-04 | ROLLBACK
- 6788 | idle | ClientRead | | 2020-09-30 09:51:04.081189-04 | ROLLBACK
- 7889 | idle | ClientRead | | 2020-09-30 22:23:41.806397-04 | ROLLBACK
- 13423 | idle | ClientRead | | 2020-09-29 09:29:32.654047-04 | ROLLBACK
- 7898 | idle | ClientRead | | 2020-09-30 22:39:51.220354-04 | ROLLBACK
- 12773 | idle | ClientRead | | 2020-09-30 15:11:15.939585-04 | ROLLBACK
- 13424 | idle | ClientRead | | 2020-09-30 17:11:43.596551-04 | ROLLBACK
- 16645 | idle | ClientRead | | 2020-09-30 16:19:19.120851-04 | ROLLBACK
- 19894 | idle | ClientRead | | 2020-09-30 16:18:34.874721-04 | ROLLBACK
- 6427 | idle | ClientRead | | 2020-09-30 22:15:29.109954-04 | ROLLBACK
- 17928 | idle | ClientRead | | 2020-09-30 16:49:00.212292-04 | ROLLBACK
- 22881 | idle | ClientRead | | 2020-09-30 22:15:28.214282-04 | ROLLBACK
- 7444 | idle | ClientRead | | 2020-09-30 09:24:35.133501-04 | ROLLBACK
- 2691 | idle | ClientRead | | 2020-09-30 22:40:03.340736-04 | COMMIT
- 2563 | idle | ClientRead | | 2020-09-30 22:39:55.94099-04 | COMMIT
- 1647 | | | | | <insufficient privilege>
- 1646 | | | | | <insufficient privilege>
- 1648 | | | | | <insufficient privilege>
- (42 rows)
Add Comment
Please, Sign In to add comment