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
-------+-----------+-------+----------+-----------+---------------------------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+---------+--------+-------------+--------------+---------------------------------------------------------
 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        +
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              | WHERE (  user_actions.action_type = ua2.action_type AND+
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              |   user_actions.user_id = ua2.user_id AND               +
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              |   user_actions.acting_user_id = ua2.acting_user_id AND +
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              |   user_actions.target_post_id = ua2.target_post_id AND +
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              |   user_actions.target_post_id > 0 AND                  +
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              |   user_actions.id > ua2.id                             +
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              | )                                                      +
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              |
 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        +
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              | WHERE (  user_actions.action_type = ua2.action_type AND+
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              |   user_actions.user_id = ua2.user_id AND               +
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              |   user_actions.acting_user_id = ua2.acting_user_id AND +
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              |   user_actions.target_post_id = ua2.target_post_id AND +
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              |   user_actions.target_post_id > 0 AND                  +
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              |   user_actions.id > ua2.id                             +
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              | )                                                      +
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              |
 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        +
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              | WHERE (  user_actions.action_type = ua2.action_type AND+
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              |   user_actions.user_id = ua2.user_id AND               +
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              |   user_actions.acting_user_id = ua2.acting_user_id AND +
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              |   user_actions.target_post_id = ua2.target_post_id AND +
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              |   user_actions.target_post_id > 0 AND                  +
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              |   user_actions.id > ua2.id                             +
       |           |       |          |           |                                       |             |                 |             |                               |                               |                               |                               |         |        |             |              | )                                                      +
 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'
(4 rows)