Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- postgres=# select * from pg_stat_activity;
- datid | datname | procpid | usesysid | usename | current_query | waiting | xact_start | query_start | backend_start | client_addr | client_port
- --------+------------+---------+----------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+-------------------------------+-------------------------------+-------------------------------+-------------+-------------
- 11511 | postgres | 6106 | 10 | postgres | select * from pg_stat_activity; | f | 2011-02-15 03:15:38.343233+00 | 2011-02-15 03:15:38.343233+00 | 2011-02-15 03:15:12.84389+00 | | -1
- 17798 | mochigames | 6256 | 10 | postgres | SELECT "auth_user"."username", "auth_user"."date_joined" FROM "auth_user" WHERE "auth_user"."is_active" = true LIMIT 50000 OFFSET 5600000 | f | 2011-02-15 03:15:19.02215+00 | 2011-02-15 03:15:36.419049+00 | 2011-02-15 03:15:19.018246+00 | 10.0.0.114 | 23318
- 17798 | mochigames | 5993 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:15:38.334303+00 | 2011-02-15 03:14:47.186021+00 | 10.0.0.114 | 22068
- 17798 | mochigames | 5992 | 19577 | mochi | | f | 2011-02-15 03:15:38.337326+00 | 2011-02-15 03:15:38.337502+00 | 2011-02-15 03:14:47.163422+00 | 10.0.0.114 | 22066
- : SELECT
- : U.id,
- : U.username,
- : P.profile_img_source,
- : P.uploaded_img,
- : P.gender,
- : P.birthday
- : FROM auth_user U
- : INNER JOIN profiles_userprofile P ON (U.id = P.user_id)
- : WHERE U.id IN (5780466)
- 201645 | forums | 6049 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:15:35.340912+00 | 2011-02-15 03:14:55.881505+00 | 10.0.0.30 | 49569
- 201645 | forums | 5998 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:15:38.328811+00 | 2011-02-15 03:14:47.446181+00 | 10.0.0.66 | 10015
- 201645 | forums | 5997 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:15:33.17311+00 | 2011-02-15 03:14:47.425555+00 | 10.0.0.68 | 3659
- 201645 | forums | 5975 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:15:33.913538+00 | 2011-02-15 03:14:45.046963+00 | 10.0.0.30 | 49503
- 201645 | forums | 6046 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:15:34.315379+00 | 2011-02-15 03:14:55.406419+00 | 10.0.0.68 | 3705
- 143356 | mochiads | 6600 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:15:36.75899+00 | 2011-02-15 03:15:36.753739+00 | 10.0.0.52 | 35102
- 143356 | mochiads | 6105 | 19577 | mochi | | f | 2011-02-15 03:15:37.535444+00 | 2011-02-15 03:15:37.536095+00 | 2011-02-15 03:15:12.832769+00 | 10.0.0.113 | 7061
- : SELECT DISTINCT A.* FROM denormalized_game A
- : INNER JOIN game_tags USING(game_tag)
- :
- : WHERE
- : (approved OR (coins_approved AND (approved IS NULL))) AND
- : ((alternate_url != '' AND alternate_url IS NOT NULL) OR feed_approved) AND
- : public AND deactivated IS NOT TRUE
- :
- : AND game_tags.tag NOT IN (E'zh-cn') ORDER BY metascore DESC LIMIT 27 OFFSET 0
- 143356 | mochiads | 6077 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:15:37.416895+00 | 2011-02-15 03:15:10.067577+00 | 10.0.0.114 | 22688
- 143356 | mochiads | 6076 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:15:36.606273+00 | 2011-02-15 03:15:09.743809+00 | 10.0.0.66 | 10145
- 143356 | mochiads | 6059 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:15:37.9565+00 | 2011-02-15 03:15:03.995408+00 | 10.0.0.72 | 35824
- 143356 | mochiads | 6055 | 19577 | mochi | | f | 2011-02-15 03:15:34.326105+00 | 2011-02-15 03:15:34.326588+00 | 2011-02-15 03:15:03.121212+00 | 10.0.0.114 | 22559
- : SELECT DISTINCT A.* FROM denormalized_game A
- : INNER JOIN game_tags USING(game_tag)
- :
- : WHERE
- : (approved OR (coins_approved AND (approved IS NULL))) AND
- : ((alternate_url != '' AND alternate_url IS NOT NULL) OR feed_approved) AND
- : public AND deactivated IS NOT TRUE
- :
- : AND game_tags.tag NOT IN (E'zh-cn') AND recommendation >= 4 ORDER BY approval_created DESC, coins_approval_created DESC, feed_approval_created DESC, metascore DESC LIMIT 27 OFFSET 0
- 143356 | mochiads | 6054 | 19577 | mochi | | f | 2011-02-15 03:15:00.028027+00 | 2011-02-15 03:15:00.028755+00 | 2011-02-15 03:15:00.025324+00 | 10.0.0.114 | 22491
- : SELECT DISTINCT A.* FROM denormalized_game A
- : INNER JOIN game_tags USING(game_tag)
- :
- : WHERE
- : (approved OR (coins_approved AND (approved IS NULL))) AND
- : ((alternate_url != '' AND alternate_url IS NOT NULL) OR feed_approved) AND
- : public AND deactivated IS NOT TRUE
- :
- : AND game_tags.tag NOT IN (E'zh-cn') ORDER BY metascore DESC LIMIT 27 OFFSET 0
- 143356 | mochiads | 6053 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:15:33.637498+00 | 2011-02-15 03:14:59.999956+00 | 10.0.0.113 | 55911
- 143356 | mochiads | 6052 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:15:37.745214+00 | 2011-02-15 03:14:59.808528+00 | 10.0.0.67 | 61626
- 143356 | mochiads | 6051 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:15:36.753346+00 | 2011-02-15 03:14:56.904453+00 | 10.0.0.52 | 35097
- 143356 | mochiads | 6017 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:15:36.290165+00 | 2011-02-15 03:14:49.95449+00 | 10.0.0.50 | 47647
- 143356 | mochiads | 6021 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:15:36.191692+00 | 2011-02-15 03:14:50.351866+00 | 10.0.0.72 | 35818
- 143356 | mochiads | 6009 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:14:51.779767+00 | 2011-02-15 03:14:48.455349+00 | 10.0.0.30 | 49510
- 143356 | mochiads | 6035 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:15:33.995344+00 | 2011-02-15 03:14:51.660797+00 | 10.0.0.114 | 22281
- 143356 | mochiads | 6024 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:15:36.865457+00 | 2011-02-15 03:14:50.592163+00 | 10.0.0.30 | 49537
- 143356 | mochiads | 5978 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:15:38.315318+00 | 2011-02-15 03:14:45.190921+00 | 10.0.0.51 | 24856
- 143356 | mochiads | 5946 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:15:36.060662+00 | 2011-02-15 03:14:42.968881+00 | 10.0.0.66 | 9983
- 143356 | mochiads | 5945 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:15:37.268312+00 | 2011-02-15 03:14:42.564907+00 | 10.0.0.68 | 3643
- 143356 | mochiads | 6044 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:15:36.204781+00 | 2011-02-15 03:14:54.862606+00 | 10.0.0.30 | 49563
- 143356 | mochiads | 5960 | 19577 | mochi | <IDLE> | f | | 2011-02-15 03:15:36.686874+00 | 2011-02-15 03:14:44.096696+00 | 10.0.0.50 | 47640
- (29 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
