Guest User

Untitled

a guest
Jun 4th, 2016
127
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 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
  2. -------+-----------+-------+----------+-----------+---------------------------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+---------+--------+-------------+--------------+---------------------------------------------------------
  3. 16400 | discourse | 29151 | 16385 | discourse | sidekiq 4.1.2 discourse [0 of 5 busy] | | | -1 | 2016-06-04 23:51:54.639421+00 | 2016-06-04 23:53:13.789837+00 | 2016-06-04 23:53:13.789837+00 | 2016-06-04 23:53:13.789841+00 | f | active | | 1570362 | DELETE FROM user_actions USING user_actions ua2 +
  4. | | | | | | | | | | | | | | | | | WHERE ( user_actions.action_type = ua2.action_type AND+
  5. | | | | | | | | | | | | | | | | | user_actions.user_id = ua2.user_id AND +
  6. | | | | | | | | | | | | | | | | | user_actions.acting_user_id = ua2.acting_user_id AND +
  7. | | | | | | | | | | | | | | | | | user_actions.target_post_id = ua2.target_post_id AND +
  8. | | | | | | | | | | | | | | | | | user_actions.target_post_id > 0 AND +
  9. | | | | | | | | | | | | | | | | | user_actions.id > ua2.id +
  10. | | | | | | | | | | | | | | | | | ) +
  11. | | | | | | | | | | | | | | | | |
  12. 16400 | discourse | 558 | 16385 | discourse | sidekiq 4.1.2 discourse [0 of 5 busy] | | | -1 | 2016-06-04 22:22:09.151213+00 | 2016-06-04 22:22:10.983777+00 | 2016-06-04 22:22:10.983777+00 | 2016-06-04 22:22:10.983781+00 | f | active | | 1569808 | DELETE FROM user_actions USING user_actions ua2 +
  13. | | | | | | | | | | | | | | | | | WHERE ( user_actions.action_type = ua2.action_type AND+
  14. | | | | | | | | | | | | | | | | | user_actions.user_id = ua2.user_id AND +
  15. | | | | | | | | | | | | | | | | | user_actions.acting_user_id = ua2.acting_user_id AND +
  16. | | | | | | | | | | | | | | | | | user_actions.target_post_id = ua2.target_post_id AND +
  17. | | | | | | | | | | | | | | | | | user_actions.target_post_id > 0 AND +
  18. | | | | | | | | | | | | | | | | | user_actions.id > ua2.id +
  19. | | | | | | | | | | | | | | | | | ) +
  20. | | | | | | | | | | | | | | | | |
  21. 16400 | discourse | 10304 | 16385 | discourse | sidekiq 4.1.2 discourse [0 of 5 busy] | | | -1 | 2016-06-04 22:52:23.969608+00 | 2016-06-04 22:52:44.937166+00 | 2016-06-04 22:52:44.937166+00 | 2016-06-04 22:52:44.937169+00 | f | active | | 1569969 | DELETE FROM user_actions USING user_actions ua2 +
  22. | | | | | | | | | | | | | | | | | WHERE ( user_actions.action_type = ua2.action_type AND+
  23. | | | | | | | | | | | | | | | | | user_actions.user_id = ua2.user_id AND +
  24. | | | | | | | | | | | | | | | | | user_actions.acting_user_id = ua2.acting_user_id AND +
  25. | | | | | | | | | | | | | | | | | user_actions.target_post_id = ua2.target_post_id AND +
  26. | | | | | | | | | | | | | | | | | user_actions.target_post_id > 0 AND +
  27. | | | | | | | | | | | | | | | | | user_actions.id > ua2.id +
  28. | | | | | | | | | | | | | | | | | ) +
  29. 12413 | postgres | 19748 | 10 | postgres | psql | | | -1 | 2016-06-05 00:48:50.762279+00 | 2016-06-05 00:48:50.772262+00 | 2016-06-05 00:48:50.772262+00 | 2016-06-05 00:48:50.772264+00 | f | active | | 1570715 | select * from pg_stat_activity WHERE state='active'
  30. (4 rows)
RAW Paste Data