Created
October 6, 2022 20:49
-
-
Save samul-1/e5a627a897f0d51371c1520cb913cc39 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 | wait_event_type | wait_event | state | backend_xid | backend_xmin | query | backend_type | |
| -------+------------+-------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-----------------+---------------------+--------+-------------+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------ | |
| | | 33 | | | | | | | 2022-10-05 09:56:54.650806+00 | | | | Activity | AutoVacuumMain | | | | | autovacuum launcher | |
| | | 35 | 10 | postgres | | | | | 2022-10-05 09:56:54.651548+00 | | | | Activity | LogicalLauncherMain | | | | | logical replication launcher | |
| 16384 | sai_evo_db | 21859 | 10 | postgres | | 172.17.0.11 | | 55672 | 2022-10-06 18:07:21.581141+00 | | 2022-10-06 18:07:27.776491+00 | 2022-10-06 18:07:27.789135+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 21854 | 10 | postgres | | 172.17.0.8 | | 38472 | 2022-10-06 18:07:15.088229+00 | | 2022-10-06 18:07:32.928591+00 | 2022-10-06 18:07:32.928891+00 | Client | ClientRead | idle | | | SELECT "courses_eventparticipationslot"."id", "courses_eventparticipationslot"."participation_id", "courses_eventparticipationslot"."exercise_id", "courses_eventparticipationslot"."parent_id", "courses_eventparticipationslot"."populating_rule_id", "courses_eventparticipationslot"."slot_number", "courses_eventparticipationslot"."seen_at", "courses_eventparticipationslot"."answered_at", "courses_eventparticipationslot"."answer_text", "courses_eventparticipationslot"."attachment", "courses_eventparticipationslot"."execution_results", "courses_eventparticipationslot"."comment", "courses_eventparticipationslot"."_score" FROM "courses_eventparticipationslot" WHERE "courses_eventparticipationslot"."id" = 135741 LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21634 | 10 | postgres | | 172.17.0.8 | | 57462 | 2022-10-06 17:53:05.505896+00 | | 2022-10-06 17:53:05.54409+00 | 2022-10-06 17:53:05.544524+00 | Client | ClientRead | idle | | | SELECT "courses_courserole"."id", "courses_courserole"."name", "courses_courserole"."course_id", "courses_courserole"."allow_privileges" FROM "courses_courserole" INNER JOIN "users_user_roles" ON ("courses_courserole"."id" = "users_user_roles"."courserole_id") WHERE ("users_user_roles"."user_id" = 1004 AND "courses_courserole"."course_id" IN (27, 25, 17, 15, 14, 8, 7, 2)) ORDER BY "courses_courserole"."course_id" ASC, "courses_courserole"."name" ASC | client backend | |
| 16384 | sai_evo_db | 21856 | 10 | postgres | | 172.17.0.10 | | 42218 | 2022-10-06 18:07:15.310231+00 | | 2022-10-06 18:07:32.929946+00 | 2022-10-06 18:07:32.939425+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 21633 | 10 | postgres | | 172.17.0.8 | | 57458 | 2022-10-06 17:53:05.474393+00 | | 2022-10-06 17:53:05.602752+00 | 2022-10-06 17:53:05.603012+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135731 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21663 | 10 | postgres | | 172.17.0.8 | | 39578 | 2022-10-06 17:53:35.88918+00 | | 2022-10-06 17:53:35.924362+00 | 2022-10-06 17:53:35.924471+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 1004) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21675 | 10 | postgres | | 172.17.0.8 | | 59724 | 2022-10-06 17:53:46.603649+00 | | 2022-10-06 17:53:46.668713+00 | 2022-10-06 17:53:46.668795+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 728 AND "courses_exercisesolutionvote"."user_id" = 1004 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 18258 | 10 | postgres | psql | 127.0.0.1 | | 56788 | 2022-10-06 15:40:48.023472+00 | | 2022-10-06 15:48:00.651403+00 | 2022-10-06 15:48:00.65224+00 | Client | ClientRead | idle | | | SELECT * FROM pg_stat_activity; | client backend | |
| 16384 | sai_evo_db | 21701 | 10 | postgres | | 172.17.0.8 | | 37746 | 2022-10-06 17:56:07.340039+00 | | 2022-10-06 17:56:07.429472+00 | 2022-10-06 17:56:07.429609+00 | Client | ClientRead | idle | | | SELECT "courses_eventtemplaterule"."id", "courses_eventtemplaterule"."_ordering", "courses_eventtemplaterule"."template_id", "courses_eventtemplaterule"."rule_type", "courses_eventtemplaterule"."weight", "courses_eventtemplaterule"."amount", "courses_eventtemplaterule"."search_public_tags_only" FROM "courses_eventtemplaterule" WHERE "courses_eventtemplaterule"."template_id" = 10800 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21653 | 10 | postgres | | 172.17.0.8 | | 35478 | 2022-10-06 17:53:28.45927+00 | | 2022-10-06 17:53:28.532629+00 | 2022-10-06 17:53:28.532784+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 527 AND "courses_exercisesolutionvote"."user_id" = 1004 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 21640 | 10 | postgres | | 172.17.0.8 | | 48348 | 2022-10-06 17:53:20.123695+00 | | 2022-10-06 17:53:20.162154+00 | 2022-10-06 17:53:20.162737+00 | Client | ClientRead | idle | | | SELECT COUNT(*) AS "__count" FROM "courses_exercise" WHERE ("courses_exercise"."course_id" = 25 AND "courses_exercise"."state" = 2) | client backend | |
| 16384 | sai_evo_db | 21649 | 10 | postgres | | 172.17.0.8 | | 35450 | 2022-10-06 17:53:27.195794+00 | | 2022-10-06 17:53:27.262253+00 | 2022-10-06 17:53:27.262372+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 25 AND "courses_usercourseprivilege"."user_id" = 1004) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21654 | 10 | postgres | | 172.17.0.8 | | 35480 | 2022-10-06 17:53:28.461891+00 | | 2022-10-06 17:53:28.544929+00 | 2022-10-06 17:53:28.545027+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 534 AND "courses_exercisesolutionvote"."user_id" = 1004 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 21706 | 10 | postgres | | 172.17.0.8 | | 48186 | 2022-10-06 17:56:18.867637+00 | | 2022-10-06 17:56:18.903507+00 | 2022-10-06 17:56:18.903806+00 | Client | ClientRead | idle | | | SELECT "gamification_gamificationcontext"."id", "gamification_gamificationcontext"."content_type_id", "gamification_gamificationcontext"."object_id", "gamification_gamificationcontext"."is_default_context" FROM "gamification_gamificationcontext" WHERE ("gamification_gamificationcontext"."content_type_id" = 6 AND "gamification_gamificationcontext"."object_id" = '27') LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21707 | 10 | postgres | | 172.17.0.8 | | 48188 | 2022-10-06 17:56:18.871449+00 | | 2022-10-06 17:56:18.911489+00 | 2022-10-06 17:56:18.912011+00 | Client | ClientRead | idle | | | SELECT ("courses_exercise_public_tags"."tag_id") AS "_prefetch_related_val_tag_id", "courses_exercise"."id", "courses_exercise"."_ordering", "courses_exercise"."created", "courses_exercise"."modified", "courses_exercise"."locked_by_id", "courses_exercise"."last_lock_update", "courses_exercise"."course_id", "courses_exercise"."creator_id", "courses_exercise"."parent_id", "courses_exercise"."child_weight", "courses_exercise"."exercise_type", "courses_exercise"."label", "courses_exercise"."text", "courses_exercise"."solution", "courses_exercise"."initial_code", "courses_exercise"."state", "courses_exercise"."time_to_complete", "courses_exercise"."skip_if_timeout", "courses_exercise"."requires_typescript", "courses_exercise"."all_or_nothing" FROM "courses_exercise" INNER JOIN "courses_exercise_public_tags" ON ("courses_exercise"."id" = "courses_exercise_public_tags"."exercise_id") WHERE ("courses_exercise"."state" = 2 AND NOT ("courses_exercise"."id" IN (2564)) AND "courses_exercise_public_tags"."tag_id" IN (279 | client backend | |
| 16384 | sai_evo_db | 21724 | 10 | postgres | | 172.17.0.8 | | 47802 | 2022-10-06 17:56:30.600126+00 | | 2022-10-06 17:56:30.65721+00 | 2022-10-06 17:56:30.657293+00 | Client | ClientRead | idle | | | SELECT "users_user"."id", "users_user"."password", "users_user"."last_login", "users_user"."is_superuser", "users_user"."username", "users_user"."first_name", "users_user"."last_name", "users_user"."email", "users_user"."is_staff", "users_user"."is_active", "users_user"."date_joined", "users_user"."is_teacher", "users_user"."mat", "users_user"."course" FROM "users_user" WHERE "users_user"."id" = 2 LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21669 | 10 | postgres | | 172.17.0.8 | | 39610 | 2022-10-06 17:53:37.980774+00 | | 2022-10-06 17:53:38.088048+00 | 2022-10-06 17:53:38.088374+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135731 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21687 | 10 | postgres | | 172.17.0.8 | | 44558 | 2022-10-06 17:55:07.900147+00 | | 2022-10-06 17:55:08.0366+00 | 2022-10-06 17:55:08.03673+00 | Client | ClientRead | idle | | | SELECT "courses_eventtemplaterule"."id", "courses_eventtemplaterule"."_ordering", "courses_eventtemplaterule"."template_id", "courses_eventtemplaterule"."rule_type", "courses_eventtemplaterule"."weight", "courses_eventtemplaterule"."amount", "courses_eventtemplaterule"."search_public_tags_only" FROM "courses_eventtemplaterule" WHERE "courses_eventtemplaterule"."template_id" = 10799 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21727 | 10 | postgres | | 172.17.0.8 | | 56208 | 2022-10-06 17:56:57.458785+00 | | 2022-10-06 17:56:57.490072+00 | 2022-10-06 17:56:57.490444+00 | Client | ClientRead | idle | | | SELECT "gamification_gamificationcontext"."id", "gamification_gamificationcontext"."content_type_id", "gamification_gamificationcontext"."object_id", "gamification_gamificationcontext"."is_default_context" FROM "gamification_gamificationcontext" WHERE ("gamification_gamificationcontext"."content_type_id" = 6 AND "gamification_gamificationcontext"."object_id" = '27') LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21694 | 10 | postgres | | 172.17.0.8 | | 51292 | 2022-10-06 17:55:49.85091+00 | | 2022-10-06 17:55:49.89034+00 | 2022-10-06 17:55:49.890449+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 1004) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21728 | 10 | postgres | | 172.17.0.8 | | 56210 | 2022-10-06 17:56:57.463962+00 | | 2022-10-06 17:56:57.502908+00 | 2022-10-06 17:56:57.50371+00 | Client | ClientRead | idle | | | SELECT ("courses_exercise_public_tags"."tag_id") AS "_prefetch_related_val_tag_id", "courses_exercise"."id", "courses_exercise"."_ordering", "courses_exercise"."created", "courses_exercise"."modified", "courses_exercise"."locked_by_id", "courses_exercise"."last_lock_update", "courses_exercise"."course_id", "courses_exercise"."creator_id", "courses_exercise"."parent_id", "courses_exercise"."child_weight", "courses_exercise"."exercise_type", "courses_exercise"."label", "courses_exercise"."text", "courses_exercise"."solution", "courses_exercise"."initial_code", "courses_exercise"."state", "courses_exercise"."time_to_complete", "courses_exercise"."skip_if_timeout", "courses_exercise"."requires_typescript", "courses_exercise"."all_or_nothing" FROM "courses_exercise" INNER JOIN "courses_exercise_public_tags" ON ("courses_exercise"."id" = "courses_exercise_public_tags"."exercise_id") WHERE ("courses_exercise"."state" = 2 AND NOT ("courses_exercise"."id" IN (2564)) AND "courses_exercise_public_tags"."tag_id" IN (279 | client backend | |
| 16384 | sai_evo_db | 21734 | 10 | postgres | | 172.17.0.8 | | 41674 | 2022-10-06 17:57:06.569227+00 | | 2022-10-06 17:57:06.606567+00 | 2022-10-06 17:57:06.606682+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 1004) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21713 | 10 | postgres | | 172.17.0.8 | | 47752 | 2022-10-06 17:56:24.626859+00 | | 2022-10-06 17:56:24.676565+00 | 2022-10-06 17:56:24.676677+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 1004) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21826 | 10 | postgres | | 172.17.0.8 | | 38118 | 2022-10-06 18:04:56.801744+00 | | 2022-10-06 18:04:56.899741+00 | 2022-10-06 18:04:56.899996+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135732 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21860 | 10 | postgres | | 172.17.0.8 | | 43140 | 2022-10-06 18:07:26.334168+00 | | 2022-10-06 18:07:26.445243+00 | 2022-10-06 18:07:26.445511+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135741 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21756 | 10 | postgres | | 172.17.0.8 | | 34244 | 2022-10-06 17:58:51.662045+00 | | 2022-10-06 17:58:51.805293+00 | 2022-10-06 17:58:51.805666+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135732 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21721 | 10 | postgres | | 172.17.0.8 | | 47784 | 2022-10-06 17:56:28.308149+00 | | 2022-10-06 17:56:28.373403+00 | 2022-10-06 17:56:28.373517+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 1004) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21750 | 10 | postgres | | 172.17.0.8 | | 44992 | 2022-10-06 17:58:03.509261+00 | | 2022-10-06 17:58:03.617873+00 | 2022-10-06 17:58:03.618144+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135638 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21739 | 10 | postgres | | 172.17.0.8 | | 41172 | 2022-10-06 17:57:17.759912+00 | | 2022-10-06 17:57:17.868702+00 | 2022-10-06 17:57:17.86896+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135732 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21760 | 10 | postgres | | 172.17.0.8 | | 53812 | 2022-10-06 18:00:03.628286+00 | | 2022-10-06 18:00:03.734921+00 | 2022-10-06 18:00:03.735199+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135732 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21746 | 10 | postgres | | 172.17.0.8 | | 48002 | 2022-10-06 17:57:27.141433+00 | | 2022-10-06 17:57:27.204184+00 | 2022-10-06 17:57:27.20432+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 1004) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21821 | 10 | postgres | | 172.17.0.8 | | 33304 | 2022-10-06 18:04:36.981243+00 | | 2022-10-06 18:04:37.09729+00 | 2022-10-06 18:04:37.097547+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135732 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21828 | 10 | postgres | | 172.17.0.8 | | 38700 | 2022-10-06 18:05:13.488306+00 | | 2022-10-06 18:05:13.601949+00 | 2022-10-06 18:05:13.602331+00 | Client | ClientRead | idle | | | SELECT "courses_eventtemplaterule"."id", "courses_eventtemplaterule"."_ordering", "courses_eventtemplaterule"."template_id", "courses_eventtemplaterule"."rule_type", "courses_eventtemplaterule"."weight", "courses_eventtemplaterule"."amount", "courses_eventtemplaterule"."search_public_tags_only" FROM "courses_eventtemplaterule" WHERE "courses_eventtemplaterule"."id" = 24149 LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21774 | 10 | postgres | | 172.17.0.8 | | 53872 | 2022-10-06 18:00:39.705804+00 | | 2022-10-06 18:00:39.810915+00 | 2022-10-06 18:00:39.811243+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135732 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21809 | 10 | postgres | | 172.17.0.8 | | 58232 | 2022-10-06 18:03:07.201238+00 | | 2022-10-06 18:03:07.290104+00 | 2022-10-06 18:03:07.2905+00 | Client | ClientRead | idle | | | SELECT "courses_eventtemplaterule"."id", "courses_eventtemplaterule"."_ordering", "courses_eventtemplaterule"."template_id", "courses_eventtemplaterule"."rule_type", "courses_eventtemplaterule"."weight", "courses_eventtemplaterule"."amount", "courses_eventtemplaterule"."search_public_tags_only" FROM "courses_eventtemplaterule" WHERE "courses_eventtemplaterule"."template_id" = 10804 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21804 | 10 | postgres | | 172.17.0.8 | | 59314 | 2022-10-06 18:02:38.818166+00 | | 2022-10-06 18:02:38.901048+00 | 2022-10-06 18:02:38.901208+00 | Client | ClientRead | idle | | | SELECT "courses_eventtemplaterule"."id", "courses_eventtemplaterule"."_ordering", "courses_eventtemplaterule"."template_id", "courses_eventtemplaterule"."rule_type", "courses_eventtemplaterule"."weight", "courses_eventtemplaterule"."amount", "courses_eventtemplaterule"."search_public_tags_only" FROM "courses_eventtemplaterule" WHERE "courses_eventtemplaterule"."template_id" = 10803 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21768 | 10 | postgres | | 172.17.0.8 | | 53858 | 2022-10-06 18:00:10.779502+00 | | 2022-10-06 18:00:10.820696+00 | 2022-10-06 18:00:10.820825+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 925) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21781 | 10 | postgres | | 172.17.0.8 | | 51608 | 2022-10-06 18:01:17.487782+00 | | 2022-10-06 18:01:17.522659+00 | 2022-10-06 18:01:17.523193+00 | Client | ClientRead | idle | | | SELECT COUNT(*) AS "__count" FROM "courses_exercise" WHERE ("courses_exercise"."course_id" = 27 AND "courses_exercise"."state" = 2) | client backend | |
| 16384 | sai_evo_db | 21797 | 10 | postgres | | 172.17.0.8 | | 60986 | 2022-10-06 18:02:18.082868+00 | | 2022-10-06 18:02:18.151006+00 | 2022-10-06 18:02:18.151201+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 1004) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21790 | 10 | postgres | | 172.17.0.8 | | 35580 | 2022-10-06 18:01:28.115046+00 | | 2022-10-06 18:01:28.172611+00 | 2022-10-06 18:01:28.17272+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 925) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21861 | 10 | postgres | | 172.17.0.8 | | 43146 | 2022-10-06 18:07:26.681173+00 | | 2022-10-06 18:07:26.778128+00 | 2022-10-06 18:07:26.778525+00 | Client | ClientRead | idle | | | SELECT "courses_eventtemplaterule"."id", "courses_eventtemplaterule"."_ordering", "courses_eventtemplaterule"."template_id", "courses_eventtemplaterule"."rule_type", "courses_eventtemplaterule"."weight", "courses_eventtemplaterule"."amount", "courses_eventtemplaterule"."search_public_tags_only" FROM "courses_eventtemplaterule" WHERE "courses_eventtemplaterule"."id" = 24148 LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21815 | 10 | postgres | | 172.17.0.8 | | 40974 | 2022-10-06 18:03:14.205957+00 | | 2022-10-06 18:03:14.278017+00 | 2022-10-06 18:03:14.278156+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 728 AND "courses_exercisesolutionvote"."user_id" = 1004 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 21816 | 10 | postgres | | 172.17.0.8 | | 40978 | 2022-10-06 18:03:14.216942+00 | | 2022-10-06 18:03:14.260634+00 | 2022-10-06 18:03:14.260786+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 1004) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21833 | 10 | postgres | | 172.17.0.8 | | 59404 | 2022-10-06 18:05:51.664332+00 | | 2022-10-06 18:05:51.786196+00 | 2022-10-06 18:05:51.78662+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135742 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21858 | 10 | postgres | | 172.17.0.8 | | 38490 | 2022-10-06 18:07:21.519575+00 | | 2022-10-06 18:07:21.617825+00 | 2022-10-06 18:07:21.618194+00 | Client | ClientRead | idle | | | SELECT "courses_eventtemplaterule"."id", "courses_eventtemplaterule"."_ordering", "courses_eventtemplaterule"."template_id", "courses_eventtemplaterule"."rule_type", "courses_eventtemplaterule"."weight", "courses_eventtemplaterule"."amount", "courses_eventtemplaterule"."search_public_tags_only" FROM "courses_eventtemplaterule" WHERE "courses_eventtemplaterule"."id" = 24149 LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21877 | 10 | postgres | psql | 127.0.0.1 | | 58798 | 2022-10-06 18:07:52.655907+00 | 2022-10-06 18:08:02.406642+00 | 2022-10-06 18:08:02.406642+00 | 2022-10-06 18:08:02.406644+00 | | | active | | 811648 | SELECT * FROM pg_stat_activity; | client backend | |
| 16384 | sai_evo_db | 21629 | 10 | postgres | | 172.17.0.8 | | 57352 | 2022-10-06 17:53:03.786599+00 | | 2022-10-06 17:53:04.401465+00 | 2022-10-06 17:53:04.401733+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135638 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21840 | 10 | postgres | | 172.17.0.8 | | 47072 | 2022-10-06 18:06:31.279859+00 | | 2022-10-06 18:06:31.321135+00 | 2022-10-06 18:06:31.321529+00 | Client | ClientRead | idle | | | SELECT ("courses_exercise_public_tags"."tag_id") AS "_prefetch_related_val_tag_id", "courses_exercise"."id", "courses_exercise"."_ordering", "courses_exercise"."created", "courses_exercise"."modified", "courses_exercise"."locked_by_id", "courses_exercise"."last_lock_update", "courses_exercise"."course_id", "courses_exercise"."creator_id", "courses_exercise"."parent_id", "courses_exercise"."child_weight", "courses_exercise"."exercise_type", "courses_exercise"."label", "courses_exercise"."text", "courses_exercise"."solution", "courses_exercise"."initial_code", "courses_exercise"."state", "courses_exercise"."time_to_complete", "courses_exercise"."skip_if_timeout", "courses_exercise"."requires_typescript", "courses_exercise"."all_or_nothing" FROM "courses_exercise" INNER JOIN "courses_exercise_public_tags" ON ("courses_exercise"."id" = "courses_exercise_public_tags"."exercise_id") WHERE ("courses_exercise"."state" = 2 AND NOT ("courses_exercise"."id" IN (2564)) AND "courses_exercise_public_tags"."tag_id" IN (279 | client backend | |
| 16384 | sai_evo_db | 21846 | 10 | postgres | | 172.17.0.8 | | 47908 | 2022-10-06 18:06:47.349771+00 | | 2022-10-06 18:06:47.414458+00 | 2022-10-06 18:06:47.414563+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 728 AND "courses_exercisesolutionvote"."user_id" = 925 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 21852 | 10 | postgres | | 172.17.0.8 | | 33762 | 2022-10-06 18:07:09.310317+00 | | 2022-10-06 18:07:09.401561+00 | 2022-10-06 18:07:09.401696+00 | Client | ClientRead | idle | | | SELECT "courses_eventtemplaterule"."id", "courses_eventtemplaterule"."_ordering", "courses_eventtemplaterule"."template_id", "courses_eventtemplaterule"."rule_type", "courses_eventtemplaterule"."weight", "courses_eventtemplaterule"."amount", "courses_eventtemplaterule"."search_public_tags_only" FROM "courses_eventtemplaterule" WHERE "courses_eventtemplaterule"."template_id" = 10800 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| | | 31 | | | | | | | 2022-10-05 09:56:54.650005+00 | | | | Activity | BgWriterHibernate | | | | | background writer | |
| | | 30 | | | | | | | 2022-10-05 09:56:54.649735+00 | | | | Activity | CheckpointerMain | | | | | checkpointer | |
| | | 32 | | | | | | | 2022-10-05 09:56:54.650302+00 | | | | Activity | WalWriterMain | | | | | walwriter | |
| (55 rows) | |
| sai_evo_db=# | |
| ------------- | |
| -- | |
| 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 | wait_event_type | wait_event | state | backend_xid | backend_xmin | query | backend_type | |
| -------+------------+-------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-----------------+---------------------+--------+-------------+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------ | |
| | | 33 | | | | | | | 2022-10-05 09:56:54.650806+00 | | | | Activity | AutoVacuumMain | | | | | autovacuum launcher | |
| | | 35 | 10 | postgres | | | | | 2022-10-05 09:56:54.651548+00 | | | | Activity | LogicalLauncherMain | | | | | logical replication launcher | |
| 16384 | sai_evo_db | 21859 | 10 | postgres | | 172.17.0.11 | | 55672 | 2022-10-06 18:07:21.581141+00 | | 2022-10-06 18:07:27.776491+00 | 2022-10-06 18:07:27.789135+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 21854 | 10 | postgres | | 172.17.0.8 | | 38472 | 2022-10-06 18:07:15.088229+00 | | 2022-10-06 18:07:32.928591+00 | 2022-10-06 18:07:32.928891+00 | Client | ClientRead | idle | | | SELECT "courses_eventparticipationslot"."id", "courses_eventparticipationslot"."participation_id", "courses_eventparticipationslot"."exercise_id", "courses_eventparticipationslot"."parent_id", "courses_eventparticipationslot"."populating_rule_id", "courses_eventparticipationslot"."slot_number", "courses_eventparticipationslot"."seen_at", "courses_eventparticipationslot"."answered_at", "courses_eventparticipationslot"."answer_text", "courses_eventparticipationslot"."attachment", "courses_eventparticipationslot"."execution_results", "courses_eventparticipationslot"."comment", "courses_eventparticipationslot"."_score" FROM "courses_eventparticipationslot" WHERE "courses_eventparticipationslot"."id" = 135741 LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21634 | 10 | postgres | | 172.17.0.8 | | 57462 | 2022-10-06 17:53:05.505896+00 | | 2022-10-06 17:53:05.54409+00 | 2022-10-06 17:53:05.544524+00 | Client | ClientRead | idle | | | SELECT "courses_courserole"."id", "courses_courserole"."name", "courses_courserole"."course_id", "courses_courserole"."allow_privileges" FROM "courses_courserole" INNER JOIN "users_user_roles" ON ("courses_courserole"."id" = "users_user_roles"."courserole_id") WHERE ("users_user_roles"."user_id" = 1004 AND "courses_courserole"."course_id" IN (27, 25, 17, 15, 14, 8, 7, 2)) ORDER BY "courses_courserole"."course_id" ASC, "courses_courserole"."name" ASC | client backend | |
| 16384 | sai_evo_db | 21856 | 10 | postgres | | 172.17.0.10 | | 42218 | 2022-10-06 18:07:15.310231+00 | | 2022-10-06 18:07:32.929946+00 | 2022-10-06 18:07:32.939425+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 21633 | 10 | postgres | | 172.17.0.8 | | 57458 | 2022-10-06 17:53:05.474393+00 | | 2022-10-06 17:53:05.602752+00 | 2022-10-06 17:53:05.603012+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135731 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21663 | 10 | postgres | | 172.17.0.8 | | 39578 | 2022-10-06 17:53:35.88918+00 | | 2022-10-06 17:53:35.924362+00 | 2022-10-06 17:53:35.924471+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 1004) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21675 | 10 | postgres | | 172.17.0.8 | | 59724 | 2022-10-06 17:53:46.603649+00 | | 2022-10-06 17:53:46.668713+00 | 2022-10-06 17:53:46.668795+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 728 AND "courses_exercisesolutionvote"."user_id" = 1004 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 18258 | 10 | postgres | psql | 127.0.0.1 | | 56788 | 2022-10-06 15:40:48.023472+00 | | 2022-10-06 15:48:00.651403+00 | 2022-10-06 15:48:00.65224+00 | Client | ClientRead | idle | | | SELECT * FROM pg_stat_activity; | client backend | |
| 16384 | sai_evo_db | 21701 | 10 | postgres | | 172.17.0.8 | | 37746 | 2022-10-06 17:56:07.340039+00 | | 2022-10-06 17:56:07.429472+00 | 2022-10-06 17:56:07.429609+00 | Client | ClientRead | idle | | | SELECT "courses_eventtemplaterule"."id", "courses_eventtemplaterule"."_ordering", "courses_eventtemplaterule"."template_id", "courses_eventtemplaterule"."rule_type", "courses_eventtemplaterule"."weight", "courses_eventtemplaterule"."amount", "courses_eventtemplaterule"."search_public_tags_only" FROM "courses_eventtemplaterule" WHERE "courses_eventtemplaterule"."template_id" = 10800 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21653 | 10 | postgres | | 172.17.0.8 | | 35478 | 2022-10-06 17:53:28.45927+00 | | 2022-10-06 17:53:28.532629+00 | 2022-10-06 17:53:28.532784+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 527 AND "courses_exercisesolutionvote"."user_id" = 1004 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 21640 | 10 | postgres | | 172.17.0.8 | | 48348 | 2022-10-06 17:53:20.123695+00 | | 2022-10-06 17:53:20.162154+00 | 2022-10-06 17:53:20.162737+00 | Client | ClientRead | idle | | | SELECT COUNT(*) AS "__count" FROM "courses_exercise" WHERE ("courses_exercise"."course_id" = 25 AND "courses_exercise"."state" = 2) | client backend | |
| 16384 | sai_evo_db | 21649 | 10 | postgres | | 172.17.0.8 | | 35450 | 2022-10-06 17:53:27.195794+00 | | 2022-10-06 17:53:27.262253+00 | 2022-10-06 17:53:27.262372+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 25 AND "courses_usercourseprivilege"."user_id" = 1004) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21654 | 10 | postgres | | 172.17.0.8 | | 35480 | 2022-10-06 17:53:28.461891+00 | | 2022-10-06 17:53:28.544929+00 | 2022-10-06 17:53:28.545027+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 534 AND "courses_exercisesolutionvote"."user_id" = 1004 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 21706 | 10 | postgres | | 172.17.0.8 | | 48186 | 2022-10-06 17:56:18.867637+00 | | 2022-10-06 17:56:18.903507+00 | 2022-10-06 17:56:18.903806+00 | Client | ClientRead | idle | | | SELECT "gamification_gamificationcontext"."id", "gamification_gamificationcontext"."content_type_id", "gamification_gamificationcontext"."object_id", "gamification_gamificationcontext"."is_default_context" FROM "gamification_gamificationcontext" WHERE ("gamification_gamificationcontext"."content_type_id" = 6 AND "gamification_gamificationcontext"."object_id" = '27') LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21707 | 10 | postgres | | 172.17.0.8 | | 48188 | 2022-10-06 17:56:18.871449+00 | | 2022-10-06 17:56:18.911489+00 | 2022-10-06 17:56:18.912011+00 | Client | ClientRead | idle | | | SELECT ("courses_exercise_public_tags"."tag_id") AS "_prefetch_related_val_tag_id", "courses_exercise"."id", "courses_exercise"."_ordering", "courses_exercise"."created", "courses_exercise"."modified", "courses_exercise"."locked_by_id", "courses_exercise"."last_lock_update", "courses_exercise"."course_id", "courses_exercise"."creator_id", "courses_exercise"."parent_id", "courses_exercise"."child_weight", "courses_exercise"."exercise_type", "courses_exercise"."label", "courses_exercise"."text", "courses_exercise"."solution", "courses_exercise"."initial_code", "courses_exercise"."state", "courses_exercise"."time_to_complete", "courses_exercise"."skip_if_timeout", "courses_exercise"."requires_typescript", "courses_exercise"."all_or_nothing" FROM "courses_exercise" INNER JOIN "courses_exercise_public_tags" ON ("courses_exercise"."id" = "courses_exercise_public_tags"."exercise_id") WHERE ("courses_exercise"."state" = 2 AND NOT ("courses_exercise"."id" IN (2564)) AND "courses_exercise_public_tags"."tag_id" IN (279 | client backend | |
| 16384 | sai_evo_db | 21724 | 10 | postgres | | 172.17.0.8 | | 47802 | 2022-10-06 17:56:30.600126+00 | | 2022-10-06 17:56:30.65721+00 | 2022-10-06 17:56:30.657293+00 | Client | ClientRead | idle | | | SELECT "users_user"."id", "users_user"."password", "users_user"."last_login", "users_user"."is_superuser", "users_user"."username", "users_user"."first_name", "users_user"."last_name", "users_user"."email", "users_user"."is_staff", "users_user"."is_active", "users_user"."date_joined", "users_user"."is_teacher", "users_user"."mat", "users_user"."course" FROM "users_user" WHERE "users_user"."id" = 2 LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21669 | 10 | postgres | | 172.17.0.8 | | 39610 | 2022-10-06 17:53:37.980774+00 | | 2022-10-06 17:53:38.088048+00 | 2022-10-06 17:53:38.088374+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135731 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21687 | 10 | postgres | | 172.17.0.8 | | 44558 | 2022-10-06 17:55:07.900147+00 | | 2022-10-06 17:55:08.0366+00 | 2022-10-06 17:55:08.03673+00 | Client | ClientRead | idle | | | SELECT "courses_eventtemplaterule"."id", "courses_eventtemplaterule"."_ordering", "courses_eventtemplaterule"."template_id", "courses_eventtemplaterule"."rule_type", "courses_eventtemplaterule"."weight", "courses_eventtemplaterule"."amount", "courses_eventtemplaterule"."search_public_tags_only" FROM "courses_eventtemplaterule" WHERE "courses_eventtemplaterule"."template_id" = 10799 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21727 | 10 | postgres | | 172.17.0.8 | | 56208 | 2022-10-06 17:56:57.458785+00 | | 2022-10-06 17:56:57.490072+00 | 2022-10-06 17:56:57.490444+00 | Client | ClientRead | idle | | | SELECT "gamification_gamificationcontext"."id", "gamification_gamificationcontext"."content_type_id", "gamification_gamificationcontext"."object_id", "gamification_gamificationcontext"."is_default_context" FROM "gamification_gamificationcontext" WHERE ("gamification_gamificationcontext"."content_type_id" = 6 AND "gamification_gamificationcontext"."object_id" = '27') LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21694 | 10 | postgres | | 172.17.0.8 | | 51292 | 2022-10-06 17:55:49.85091+00 | | 2022-10-06 17:55:49.89034+00 | 2022-10-06 17:55:49.890449+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 1004) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21728 | 10 | postgres | | 172.17.0.8 | | 56210 | 2022-10-06 17:56:57.463962+00 | | 2022-10-06 17:56:57.502908+00 | 2022-10-06 17:56:57.50371+00 | Client | ClientRead | idle | | | SELECT ("courses_exercise_public_tags"."tag_id") AS "_prefetch_related_val_tag_id", "courses_exercise"."id", "courses_exercise"."_ordering", "courses_exercise"."created", "courses_exercise"."modified", "courses_exercise"."locked_by_id", "courses_exercise"."last_lock_update", "courses_exercise"."course_id", "courses_exercise"."creator_id", "courses_exercise"."parent_id", "courses_exercise"."child_weight", "courses_exercise"."exercise_type", "courses_exercise"."label", "courses_exercise"."text", "courses_exercise"."solution", "courses_exercise"."initial_code", "courses_exercise"."state", "courses_exercise"."time_to_complete", "courses_exercise"."skip_if_timeout", "courses_exercise"."requires_typescript", "courses_exercise"."all_or_nothing" FROM "courses_exercise" INNER JOIN "courses_exercise_public_tags" ON ("courses_exercise"."id" = "courses_exercise_public_tags"."exercise_id") WHERE ("courses_exercise"."state" = 2 AND NOT ("courses_exercise"."id" IN (2564)) AND "courses_exercise_public_tags"."tag_id" IN (279 | client backend | |
| 16384 | sai_evo_db | 21734 | 10 | postgres | | 172.17.0.8 | | 41674 | 2022-10-06 17:57:06.569227+00 | | 2022-10-06 17:57:06.606567+00 | 2022-10-06 17:57:06.606682+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 1004) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21713 | 10 | postgres | | 172.17.0.8 | | 47752 | 2022-10-06 17:56:24.626859+00 | | 2022-10-06 17:56:24.676565+00 | 2022-10-06 17:56:24.676677+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 1004) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21826 | 10 | postgres | | 172.17.0.8 | | 38118 | 2022-10-06 18:04:56.801744+00 | | 2022-10-06 18:04:56.899741+00 | 2022-10-06 18:04:56.899996+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135732 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21891 | 10 | postgres | | 172.17.0.8 | | 44194 | 2022-10-06 18:09:36.10826+00 | | 2022-10-06 18:09:36.208159+00 | 2022-10-06 18:09:36.208586+00 | Client | ClientRead | idle | | | SELECT "users_user"."id", "users_user"."password", "users_user"."last_login", "users_user"."is_superuser", "users_user"."username", "users_user"."first_name", "users_user"."last_name", "users_user"."email", "users_user"."is_staff", "users_user"."is_active", "users_user"."date_joined", "users_user"."is_teacher", "users_user"."mat", "users_user"."course" FROM "users_user" INNER JOIN "courses_exercisesolution_bookmarked_by" ON ("users_user"."id" = "courses_exercisesolution_bookmarked_by"."user_id") WHERE "courses_exercisesolution_bookmarked_by"."exercisesolution_id" = 737 | client backend | |
| 16384 | sai_evo_db | 21756 | 10 | postgres | | 172.17.0.8 | | 34244 | 2022-10-06 17:58:51.662045+00 | | 2022-10-06 17:58:51.805293+00 | 2022-10-06 17:58:51.805666+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135732 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21721 | 10 | postgres | | 172.17.0.8 | | 47784 | 2022-10-06 17:56:28.308149+00 | | 2022-10-06 17:56:28.373403+00 | 2022-10-06 17:56:28.373517+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 1004) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21750 | 10 | postgres | | 172.17.0.8 | | 44992 | 2022-10-06 17:58:03.509261+00 | | 2022-10-06 17:58:03.617873+00 | 2022-10-06 17:58:03.618144+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135638 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21739 | 10 | postgres | | 172.17.0.8 | | 41172 | 2022-10-06 17:57:17.759912+00 | | 2022-10-06 17:57:17.868702+00 | 2022-10-06 17:57:17.86896+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135732 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21760 | 10 | postgres | | 172.17.0.8 | | 53812 | 2022-10-06 18:00:03.628286+00 | | 2022-10-06 18:00:03.734921+00 | 2022-10-06 18:00:03.735199+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135732 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21746 | 10 | postgres | | 172.17.0.8 | | 48002 | 2022-10-06 17:57:27.141433+00 | | 2022-10-06 17:57:27.204184+00 | 2022-10-06 17:57:27.20432+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 1004) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21821 | 10 | postgres | | 172.17.0.8 | | 33304 | 2022-10-06 18:04:36.981243+00 | | 2022-10-06 18:04:37.09729+00 | 2022-10-06 18:04:37.097547+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135732 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21828 | 10 | postgres | | 172.17.0.8 | | 38700 | 2022-10-06 18:05:13.488306+00 | | 2022-10-06 18:05:13.601949+00 | 2022-10-06 18:05:13.602331+00 | Client | ClientRead | idle | | | SELECT "courses_eventtemplaterule"."id", "courses_eventtemplaterule"."_ordering", "courses_eventtemplaterule"."template_id", "courses_eventtemplaterule"."rule_type", "courses_eventtemplaterule"."weight", "courses_eventtemplaterule"."amount", "courses_eventtemplaterule"."search_public_tags_only" FROM "courses_eventtemplaterule" WHERE "courses_eventtemplaterule"."id" = 24149 LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21774 | 10 | postgres | | 172.17.0.8 | | 53872 | 2022-10-06 18:00:39.705804+00 | | 2022-10-06 18:00:39.810915+00 | 2022-10-06 18:00:39.811243+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135732 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21809 | 10 | postgres | | 172.17.0.8 | | 58232 | 2022-10-06 18:03:07.201238+00 | | 2022-10-06 18:03:07.290104+00 | 2022-10-06 18:03:07.2905+00 | Client | ClientRead | idle | | | SELECT "courses_eventtemplaterule"."id", "courses_eventtemplaterule"."_ordering", "courses_eventtemplaterule"."template_id", "courses_eventtemplaterule"."rule_type", "courses_eventtemplaterule"."weight", "courses_eventtemplaterule"."amount", "courses_eventtemplaterule"."search_public_tags_only" FROM "courses_eventtemplaterule" WHERE "courses_eventtemplaterule"."template_id" = 10804 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21804 | 10 | postgres | | 172.17.0.8 | | 59314 | 2022-10-06 18:02:38.818166+00 | | 2022-10-06 18:02:38.901048+00 | 2022-10-06 18:02:38.901208+00 | Client | ClientRead | idle | | | SELECT "courses_eventtemplaterule"."id", "courses_eventtemplaterule"."_ordering", "courses_eventtemplaterule"."template_id", "courses_eventtemplaterule"."rule_type", "courses_eventtemplaterule"."weight", "courses_eventtemplaterule"."amount", "courses_eventtemplaterule"."search_public_tags_only" FROM "courses_eventtemplaterule" WHERE "courses_eventtemplaterule"."template_id" = 10803 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21768 | 10 | postgres | | 172.17.0.8 | | 53858 | 2022-10-06 18:00:10.779502+00 | | 2022-10-06 18:00:10.820696+00 | 2022-10-06 18:00:10.820825+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 925) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21781 | 10 | postgres | | 172.17.0.8 | | 51608 | 2022-10-06 18:01:17.487782+00 | | 2022-10-06 18:01:17.522659+00 | 2022-10-06 18:01:17.523193+00 | Client | ClientRead | idle | | | SELECT COUNT(*) AS "__count" FROM "courses_exercise" WHERE ("courses_exercise"."course_id" = 27 AND "courses_exercise"."state" = 2) | client backend | |
| 16384 | sai_evo_db | 21797 | 10 | postgres | | 172.17.0.8 | | 60986 | 2022-10-06 18:02:18.082868+00 | | 2022-10-06 18:02:18.151006+00 | 2022-10-06 18:02:18.151201+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 1004) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21790 | 10 | postgres | | 172.17.0.8 | | 35580 | 2022-10-06 18:01:28.115046+00 | | 2022-10-06 18:01:28.172611+00 | 2022-10-06 18:01:28.17272+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 925) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21897 | 10 | postgres | | 172.17.0.8 | | 39996 | 2022-10-06 18:10:12.910496+00 | | 2022-10-06 18:10:12.94576+00 | 2022-10-06 18:10:12.94615+00 | Client | ClientRead | idle | | | SELECT ("courses_exercise_public_tags"."tag_id") AS "_prefetch_related_val_tag_id", "courses_exercise"."id", "courses_exercise"."_ordering", "courses_exercise"."created", "courses_exercise"."modified", "courses_exercise"."locked_by_id", "courses_exercise"."last_lock_update", "courses_exercise"."course_id", "courses_exercise"."creator_id", "courses_exercise"."parent_id", "courses_exercise"."child_weight", "courses_exercise"."exercise_type", "courses_exercise"."label", "courses_exercise"."text", "courses_exercise"."solution", "courses_exercise"."initial_code", "courses_exercise"."state", "courses_exercise"."time_to_complete", "courses_exercise"."skip_if_timeout", "courses_exercise"."requires_typescript", "courses_exercise"."all_or_nothing" FROM "courses_exercise" INNER JOIN "courses_exercise_public_tags" ON ("courses_exercise"."id" = "courses_exercise_public_tags"."exercise_id") WHERE ("courses_exercise"."state" = 2 AND NOT ("courses_exercise"."id" IN (2564)) AND "courses_exercise_public_tags"."tag_id" IN (279 | client backend | |
| 16384 | sai_evo_db | 21815 | 10 | postgres | | 172.17.0.8 | | 40974 | 2022-10-06 18:03:14.205957+00 | | 2022-10-06 18:03:14.278017+00 | 2022-10-06 18:03:14.278156+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 728 AND "courses_exercisesolutionvote"."user_id" = 1004 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 21816 | 10 | postgres | | 172.17.0.8 | | 40978 | 2022-10-06 18:03:14.216942+00 | | 2022-10-06 18:03:14.260634+00 | 2022-10-06 18:03:14.260786+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 1004) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21833 | 10 | postgres | | 172.17.0.8 | | 59404 | 2022-10-06 18:05:51.664332+00 | | 2022-10-06 18:05:51.786196+00 | 2022-10-06 18:05:51.78662+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135742 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21858 | 10 | postgres | | 172.17.0.8 | | 38490 | 2022-10-06 18:07:21.519575+00 | | 2022-10-06 18:07:21.617825+00 | 2022-10-06 18:07:21.618194+00 | Client | ClientRead | idle | | | SELECT "courses_eventtemplaterule"."id", "courses_eventtemplaterule"."_ordering", "courses_eventtemplaterule"."template_id", "courses_eventtemplaterule"."rule_type", "courses_eventtemplaterule"."weight", "courses_eventtemplaterule"."amount", "courses_eventtemplaterule"."search_public_tags_only" FROM "courses_eventtemplaterule" WHERE "courses_eventtemplaterule"."id" = 24149 LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21877 | 10 | postgres | psql | 127.0.0.1 | | 58798 | 2022-10-06 18:07:52.655907+00 | 2022-10-06 18:11:11.002906+00 | 2022-10-06 18:11:11.002906+00 | 2022-10-06 18:11:11.002909+00 | | | active | | 811654 | SELECT * FROM pg_stat_activity; | client backend | |
| 16384 | sai_evo_db | 21882 | 10 | postgres | | 172.17.0.8 | | 51728 | 2022-10-06 18:08:05.80231+00 | | 2022-10-06 18:08:05.901375+00 | 2022-10-06 18:08:05.901631+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135742 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21629 | 10 | postgres | | 172.17.0.8 | | 57352 | 2022-10-06 17:53:03.786599+00 | | 2022-10-06 17:53:04.401465+00 | 2022-10-06 17:53:04.401733+00 | Client | ClientRead | idle | | | SELECT "courses_exercisechoice"."id", "courses_exercisechoice"."_ordering", "courses_exercisechoice"."exercise_id", "courses_exercisechoice"."text", "courses_exercisechoice"."correctness" FROM "courses_exercisechoice" INNER JOIN "courses_eventparticipationslot_selected_choices" ON ("courses_exercisechoice"."id" = "courses_eventparticipationslot_selected_choices"."exercisechoice_id") WHERE "courses_eventparticipationslot_selected_choices"."eventparticipationslot_id" = 135638 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21840 | 10 | postgres | | 172.17.0.8 | | 47072 | 2022-10-06 18:06:31.279859+00 | | 2022-10-06 18:06:31.321135+00 | 2022-10-06 18:06:31.321529+00 | Client | ClientRead | idle | | | SELECT ("courses_exercise_public_tags"."tag_id") AS "_prefetch_related_val_tag_id", "courses_exercise"."id", "courses_exercise"."_ordering", "courses_exercise"."created", "courses_exercise"."modified", "courses_exercise"."locked_by_id", "courses_exercise"."last_lock_update", "courses_exercise"."course_id", "courses_exercise"."creator_id", "courses_exercise"."parent_id", "courses_exercise"."child_weight", "courses_exercise"."exercise_type", "courses_exercise"."label", "courses_exercise"."text", "courses_exercise"."solution", "courses_exercise"."initial_code", "courses_exercise"."state", "courses_exercise"."time_to_complete", "courses_exercise"."skip_if_timeout", "courses_exercise"."requires_typescript", "courses_exercise"."all_or_nothing" FROM "courses_exercise" INNER JOIN "courses_exercise_public_tags" ON ("courses_exercise"."id" = "courses_exercise_public_tags"."exercise_id") WHERE ("courses_exercise"."state" = 2 AND NOT ("courses_exercise"."id" IN (2564)) AND "courses_exercise_public_tags"."tag_id" IN (279 | client backend | |
| 16384 | sai_evo_db | 21846 | 10 | postgres | | 172.17.0.8 | | 47908 | 2022-10-06 18:06:47.349771+00 | | 2022-10-06 18:06:47.414458+00 | 2022-10-06 18:06:47.414563+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 728 AND "courses_exercisesolutionvote"."user_id" = 925 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 21852 | 10 | postgres | | 172.17.0.8 | | 33762 | 2022-10-06 18:07:09.310317+00 | | 2022-10-06 18:07:09.401561+00 | 2022-10-06 18:07:09.401696+00 | Client | ClientRead | idle | | | SELECT "courses_eventtemplaterule"."id", "courses_eventtemplaterule"."_ordering", "courses_eventtemplaterule"."template_id", "courses_eventtemplaterule"."rule_type", "courses_eventtemplaterule"."weight", "courses_eventtemplaterule"."amount", "courses_eventtemplaterule"."search_public_tags_only" FROM "courses_eventtemplaterule" WHERE "courses_eventtemplaterule"."template_id" = 10800 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21903 | 10 | postgres | | 172.17.0.8 | | 58906 | 2022-10-06 18:10:14.403541+00 | | 2022-10-06 18:10:14.445379+00 | 2022-10-06 18:10:14.445489+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 925) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21904 | 10 | postgres | | 172.17.0.8 | | 58908 | 2022-10-06 18:10:14.407418+00 | | 2022-10-06 18:10:14.479299+00 | 2022-10-06 18:10:14.479432+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 737 AND "courses_exercisesolutionvote"."user_id" = 925 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 21943 | 10 | postgres | | 172.17.0.8 | | 55316 | 2022-10-06 18:11:09.383923+00 | | 2022-10-06 18:11:09.418367+00 | 2022-10-06 18:11:09.418476+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 1004) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21944 | 10 | postgres | | 172.17.0.8 | | 55320 | 2022-10-06 18:11:10.505332+00 | | 2022-10-06 18:11:10.567803+00 | 2022-10-06 18:11:10.567969+00 | Client | ClientRead | idle | | | SELECT "courses_eventtemplaterule"."id", "courses_eventtemplaterule"."_ordering", "courses_eventtemplaterule"."template_id", "courses_eventtemplaterule"."rule_type", "courses_eventtemplaterule"."weight", "courses_eventtemplaterule"."amount", "courses_eventtemplaterule"."search_public_tags_only" FROM "courses_eventtemplaterule" WHERE "courses_eventtemplaterule"."template_id" = 10800 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 21934 | 10 | postgres | | 172.17.0.8 | | 60226 | 2022-10-06 18:10:54.11956+00 | | 2022-10-06 18:10:54.178476+00 | 2022-10-06 18:10:54.178587+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 925) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21911 | 10 | postgres | | 172.17.0.8 | | 58264 | 2022-10-06 18:10:30.164129+00 | | 2022-10-06 18:10:30.20564+00 | 2022-10-06 18:10:30.206029+00 | Client | ClientRead | idle | | | SELECT ("courses_exercise_public_tags"."tag_id") AS "_prefetch_related_val_tag_id", "courses_exercise"."id", "courses_exercise"."_ordering", "courses_exercise"."created", "courses_exercise"."modified", "courses_exercise"."locked_by_id", "courses_exercise"."last_lock_update", "courses_exercise"."course_id", "courses_exercise"."creator_id", "courses_exercise"."parent_id", "courses_exercise"."child_weight", "courses_exercise"."exercise_type", "courses_exercise"."label", "courses_exercise"."text", "courses_exercise"."solution", "courses_exercise"."initial_code", "courses_exercise"."state", "courses_exercise"."time_to_complete", "courses_exercise"."skip_if_timeout", "courses_exercise"."requires_typescript", "courses_exercise"."all_or_nothing" FROM "courses_exercise" INNER JOIN "courses_exercise_public_tags" ON ("courses_exercise"."id" = "courses_exercise_public_tags"."exercise_id") WHERE ("courses_exercise"."state" = 2 AND NOT ("courses_exercise"."id" IN (2564)) AND "courses_exercise_public_tags"."tag_id" IN (279 | client backend | |
| 16384 | sai_evo_db | 21921 | 10 | postgres | | 172.17.0.8 | | 33756 | 2022-10-06 18:10:40.435985+00 | | 2022-10-06 18:10:40.472569+00 | 2022-10-06 18:10:40.473088+00 | Client | ClientRead | idle | | | SELECT COUNT(*) AS "__count" FROM "courses_exercise" WHERE ("courses_exercise"."course_id" = 27 AND "courses_exercise"."state" = 2) | client backend | |
| 16384 | sai_evo_db | 21929 | 10 | postgres | | 172.17.0.8 | | 38396 | 2022-10-06 18:10:47.591924+00 | | 2022-10-06 18:10:47.62732+00 | 2022-10-06 18:10:47.627895+00 | Client | ClientRead | idle | | | SELECT COUNT(*) AS "__count" FROM "courses_exercise" WHERE ("courses_exercise"."course_id" = 27 AND "courses_exercise"."state" = 2) | client backend | |
| 16384 | sai_evo_db | 21942 | 10 | postgres | | 172.17.0.8 | | 55312 | 2022-10-06 18:11:09.154858+00 | | 2022-10-06 18:11:09.228137+00 | 2022-10-06 18:11:09.228285+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 1004) LIMIT 21 | client backend | |
| | | 31 | | | | | | | 2022-10-05 09:56:54.650005+00 | | | | Activity | BgWriterHibernate | | | | | background writer | |
| | | 30 | | | | | | | 2022-10-05 09:56:54.649735+00 | | | | Activity | CheckpointerMain | | | | | checkpointer | |
| | | 32 | | | | | | | 2022-10-05 09:56:54.650302+00 | | | | Activity | WalWriterMain | | | | | walwriter | |
| (65 rows) | |
| sai_evo_db=# | |
| --------- | |
| 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 | wait_event_type | wait_event | state | backend_xid | backend_xmin | query | backend_type | |
| -------+------------+-------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-----------------+---------------------+--------+-------------+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------ | |
| | | 33 | | | | | | | 2022-10-05 09:56:54.650806+00 | | | | Activity | AutoVacuumMain | | | | | autovacuum launcher | |
| | | 35 | 10 | postgres | | | | | 2022-10-05 09:56:54.651548+00 | | | | Activity | LogicalLauncherMain | | | | | logical replication launcher | |
| 16384 | sai_evo_db | 21958 | 10 | postgres | | 172.17.0.11 | | 45450 | 2022-10-06 18:11:15.617736+00 | | 2022-10-06 18:11:21.812058+00 | 2022-10-06 18:11:21.820547+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 21955 | 10 | postgres | | 172.17.0.8 | | 46242 | 2022-10-06 18:11:15.460327+00 | | 2022-10-06 18:11:21.809076+00 | 2022-10-06 18:11:21.809302+00 | Client | ClientRead | idle | | | SELECT "courses_eventparticipationslot"."id", "courses_eventparticipationslot"."participation_id", "courses_eventparticipationslot"."exercise_id", "courses_eventparticipationslot"."parent_id", "courses_eventparticipationslot"."populating_rule_id", "courses_eventparticipationslot"."slot_number", "courses_eventparticipationslot"."seen_at", "courses_eventparticipationslot"."answered_at", "courses_eventparticipationslot"."answer_text", "courses_eventparticipationslot"."attachment", "courses_eventparticipationslot"."execution_results", "courses_eventparticipationslot"."comment", "courses_eventparticipationslot"."_score" FROM "courses_eventparticipationslot" WHERE "courses_eventparticipationslot"."id" = 135741 LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21984 | 10 | postgres | | 172.17.0.8 | | 34498 | 2022-10-06 18:11:29.228317+00 | | 2022-10-06 18:11:29.551514+00 | 2022-10-06 18:11:29.728138+00 | Client | ClientRead | idle | | | SELECT ("courses_exercise_public_tags"."tag_id") AS "_prefetch_related_val_tag_id", "courses_exercise"."id", "courses_exercise"."_ordering", "courses_exercise"."created", "courses_exercise"."modified", "courses_exercise"."locked_by_id", "courses_exercise"."last_lock_update", "courses_exercise"."course_id", "courses_exercise"."creator_id", "courses_exercise"."parent_id", "courses_exercise"."child_weight", "courses_exercise"."exercise_type", "courses_exercise"."label", "courses_exercise"."text", "courses_exercise"."solution", "courses_exercise"."initial_code", "courses_exercise"."state", "courses_exercise"."time_to_complete", "courses_exercise"."skip_if_timeout", "courses_exercise"."requires_typescript", "courses_exercise"."all_or_nothing" FROM "courses_exercise" INNER JOIN "courses_exercise_public_tags" ON ("courses_exercise"."id" = "courses_exercise_public_tags"."exercise_id") WHERE ("courses_exercise"."state" = 2 AND NOT ("courses_exercise"."id" IN (2564)) AND "courses_exercise_public_tags"."tag_id" IN (270 | client backend | |
| 16384 | sai_evo_db | 21856 | 10 | postgres | | 172.17.0.10 | | 42218 | 2022-10-06 18:07:15.310231+00 | | 2022-10-06 18:07:32.929946+00 | 2022-10-06 18:07:32.939425+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 21989 | 10 | postgres | | 172.17.0.8 | | 34534 | 2022-10-06 18:11:31.772555+00 | | 2022-10-06 18:11:31.873552+00 | 2022-10-06 18:11:31.873679+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 227 AND "courses_exercisesolutionvote"."user_id" = 925 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 21979 | 10 | postgres | | 172.17.0.8 | | 34470 | 2022-10-06 18:11:27.034135+00 | | 2022-10-06 18:11:27.388032+00 | 2022-10-06 18:11:27.568709+00 | Client | ClientRead | idle | | | SELECT ("courses_exercise_public_tags"."tag_id") AS "_prefetch_related_val_tag_id", "courses_exercise"."id", "courses_exercise"."_ordering", "courses_exercise"."created", "courses_exercise"."modified", "courses_exercise"."locked_by_id", "courses_exercise"."last_lock_update", "courses_exercise"."course_id", "courses_exercise"."creator_id", "courses_exercise"."parent_id", "courses_exercise"."child_weight", "courses_exercise"."exercise_type", "courses_exercise"."label", "courses_exercise"."text", "courses_exercise"."solution", "courses_exercise"."initial_code", "courses_exercise"."state", "courses_exercise"."time_to_complete", "courses_exercise"."skip_if_timeout", "courses_exercise"."requires_typescript", "courses_exercise"."all_or_nothing" FROM "courses_exercise" INNER JOIN "courses_exercise_public_tags" ON ("courses_exercise"."id" = "courses_exercise_public_tags"."exercise_id") WHERE ("courses_exercise"."state" = 2 AND NOT ("courses_exercise"."id" IN (2564)) AND "courses_exercise_public_tags"."tag_id" IN (270 | client backend | |
| 16384 | sai_evo_db | 21983 | 10 | postgres | | 172.17.0.8 | | 34494 | 2022-10-06 18:11:28.084236+00 | | 2022-10-06 18:11:28.12265+00 | 2022-10-06 18:11:28.122804+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 2 AND "courses_usercourseprivilege"."user_id" = 925) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 18258 | 10 | postgres | psql | 127.0.0.1 | | 56788 | 2022-10-06 15:40:48.023472+00 | | 2022-10-06 15:48:00.651403+00 | 2022-10-06 15:48:00.65224+00 | Client | ClientRead | idle | | | SELECT * FROM pg_stat_activity; | client backend | |
| 16384 | sai_evo_db | 21990 | 10 | postgres | | 172.17.0.8 | | 34540 | 2022-10-06 18:11:31.792383+00 | | 2022-10-06 18:11:31.930332+00 | 2022-10-06 18:11:31.930467+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 399 AND "courses_exercisesolutionvote"."user_id" = 925 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 21987 | 10 | postgres | | 172.17.0.8 | | 34514 | 2022-10-06 18:11:30.803433+00 | | 2022-10-06 18:11:31.153446+00 | 2022-10-06 18:11:31.325911+00 | Client | ClientRead | idle | | | SELECT ("courses_exercise_public_tags"."tag_id") AS "_prefetch_related_val_tag_id", "courses_exercise"."id", "courses_exercise"."_ordering", "courses_exercise"."created", "courses_exercise"."modified", "courses_exercise"."locked_by_id", "courses_exercise"."last_lock_update", "courses_exercise"."course_id", "courses_exercise"."creator_id", "courses_exercise"."parent_id", "courses_exercise"."child_weight", "courses_exercise"."exercise_type", "courses_exercise"."label", "courses_exercise"."text", "courses_exercise"."solution", "courses_exercise"."initial_code", "courses_exercise"."state", "courses_exercise"."time_to_complete", "courses_exercise"."skip_if_timeout", "courses_exercise"."requires_typescript", "courses_exercise"."all_or_nothing" FROM "courses_exercise" INNER JOIN "courses_exercise_public_tags" ON ("courses_exercise"."id" = "courses_exercise_public_tags"."exercise_id") WHERE ("courses_exercise"."state" = 2 AND NOT ("courses_exercise"."id" IN (2564)) AND "courses_exercise_public_tags"."tag_id" IN (270 | client backend | |
| 16384 | sai_evo_db | 21991 | 10 | postgres | | 172.17.0.8 | | 34542 | 2022-10-06 18:11:31.808539+00 | | 2022-10-06 18:11:31.956469+00 | 2022-10-06 18:11:31.956611+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 230 AND "courses_exercisesolutionvote"."user_id" = 925 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 22003 | 10 | postgres | | 172.17.0.8 | | 50450 | 2022-10-06 18:11:41.587896+00 | | 2022-10-06 18:11:41.667279+00 | 2022-10-06 18:11:41.667451+00 | Client | ClientRead | idle | | | SELECT MAX("courses_exercisechoice"."correctness") AS "correctness__max" FROM "courses_exercisechoice" WHERE "courses_exercisechoice"."exercise_id" = 1371 | client backend | |
| 16384 | sai_evo_db | 21993 | 10 | postgres | | 172.17.0.8 | | 50406 | 2022-10-06 18:11:38.046811+00 | | 2022-10-06 18:11:38.394298+00 | 2022-10-06 18:11:38.572596+00 | Client | ClientRead | idle | | | SELECT ("courses_exercise_public_tags"."tag_id") AS "_prefetch_related_val_tag_id", "courses_exercise"."id", "courses_exercise"."_ordering", "courses_exercise"."created", "courses_exercise"."modified", "courses_exercise"."locked_by_id", "courses_exercise"."last_lock_update", "courses_exercise"."course_id", "courses_exercise"."creator_id", "courses_exercise"."parent_id", "courses_exercise"."child_weight", "courses_exercise"."exercise_type", "courses_exercise"."label", "courses_exercise"."text", "courses_exercise"."solution", "courses_exercise"."initial_code", "courses_exercise"."state", "courses_exercise"."time_to_complete", "courses_exercise"."skip_if_timeout", "courses_exercise"."requires_typescript", "courses_exercise"."all_or_nothing" FROM "courses_exercise" INNER JOIN "courses_exercise_public_tags" ON ("courses_exercise"."id" = "courses_exercise_public_tags"."exercise_id") WHERE ("courses_exercise"."state" = 2 AND NOT ("courses_exercise"."id" IN (2564)) AND "courses_exercise_public_tags"."tag_id" IN (270 | client backend | |
| 16384 | sai_evo_db | 22004 | 10 | postgres | | 172.17.0.8 | | 50464 | 2022-10-06 18:11:41.745939+00 | | 2022-10-06 18:11:41.842959+00 | 2022-10-06 18:11:41.843121+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 227 AND "courses_exercisesolutionvote"."user_id" = 925 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 21996 | 10 | postgres | | 172.17.0.8 | | 50420 | 2022-10-06 18:11:39.227988+00 | | 2022-10-06 18:11:39.270807+00 | 2022-10-06 18:11:39.271282+00 | Client | ClientRead | idle | | | SELECT "gamification_gamificationcontext"."id", "gamification_gamificationcontext"."content_type_id", "gamification_gamificationcontext"."object_id", "gamification_gamificationcontext"."is_default_context" FROM "gamification_gamificationcontext" WHERE ("gamification_gamificationcontext"."content_type_id" = 6 AND "gamification_gamificationcontext"."object_id" = '27') LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 21997 | 10 | postgres | | 172.17.0.8 | | 50422 | 2022-10-06 18:11:39.230322+00 | | 2022-10-06 18:11:39.272922+00 | 2022-10-06 18:11:39.273372+00 | Client | ClientRead | idle | | | SELECT ("courses_exercise_public_tags"."tag_id") AS "_prefetch_related_val_tag_id", "courses_exercise"."id", "courses_exercise"."_ordering", "courses_exercise"."created", "courses_exercise"."modified", "courses_exercise"."locked_by_id", "courses_exercise"."last_lock_update", "courses_exercise"."course_id", "courses_exercise"."creator_id", "courses_exercise"."parent_id", "courses_exercise"."child_weight", "courses_exercise"."exercise_type", "courses_exercise"."label", "courses_exercise"."text", "courses_exercise"."solution", "courses_exercise"."initial_code", "courses_exercise"."state", "courses_exercise"."time_to_complete", "courses_exercise"."skip_if_timeout", "courses_exercise"."requires_typescript", "courses_exercise"."all_or_nothing" FROM "courses_exercise" INNER JOIN "courses_exercise_public_tags" ON ("courses_exercise"."id" = "courses_exercise_public_tags"."exercise_id") WHERE ("courses_exercise"."state" = 2 AND NOT ("courses_exercise"."id" IN (2564)) AND "courses_exercise_public_tags"."tag_id" IN (279 | client backend | |
| 16384 | sai_evo_db | 22005 | 10 | postgres | | 172.17.0.8 | | 50466 | 2022-10-06 18:11:41.75068+00 | | 2022-10-06 18:11:41.879094+00 | 2022-10-06 18:11:41.879214+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 399 AND "courses_exercisesolutionvote"."user_id" = 925 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 22001 | 10 | postgres | | 172.17.0.8 | | 50438 | 2022-10-06 18:11:40.779537+00 | | 2022-10-06 18:11:41.140067+00 | 2022-10-06 18:11:41.330484+00 | Client | ClientRead | idle | | | SELECT ("courses_exercise_public_tags"."tag_id") AS "_prefetch_related_val_tag_id", "courses_exercise"."id", "courses_exercise"."_ordering", "courses_exercise"."created", "courses_exercise"."modified", "courses_exercise"."locked_by_id", "courses_exercise"."last_lock_update", "courses_exercise"."course_id", "courses_exercise"."creator_id", "courses_exercise"."parent_id", "courses_exercise"."child_weight", "courses_exercise"."exercise_type", "courses_exercise"."label", "courses_exercise"."text", "courses_exercise"."solution", "courses_exercise"."initial_code", "courses_exercise"."state", "courses_exercise"."time_to_complete", "courses_exercise"."skip_if_timeout", "courses_exercise"."requires_typescript", "courses_exercise"."all_or_nothing" FROM "courses_exercise" INNER JOIN "courses_exercise_public_tags" ON ("courses_exercise"."id" = "courses_exercise_public_tags"."exercise_id") WHERE ("courses_exercise"."state" = 2 AND NOT ("courses_exercise"."id" IN (2564)) AND "courses_exercise_public_tags"."tag_id" IN (270 | client backend | |
| 16384 | sai_evo_db | 22002 | 10 | postgres | | 172.17.0.8 | | 50442 | 2022-10-06 18:11:40.908668+00 | | 2022-10-06 18:11:40.976129+00 | 2022-10-06 18:11:40.976311+00 | Client | ClientRead | idle | | | SELECT "courses_eventtemplaterule"."id", "courses_eventtemplaterule"."_ordering", "courses_eventtemplaterule"."template_id", "courses_eventtemplaterule"."rule_type", "courses_eventtemplaterule"."weight", "courses_eventtemplaterule"."amount", "courses_eventtemplaterule"."search_public_tags_only" FROM "courses_eventtemplaterule" WHERE "courses_eventtemplaterule"."template_id" = 10799 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 22006 | 10 | postgres | | 172.17.0.8 | | 50468 | 2022-10-06 18:11:41.754266+00 | | 2022-10-06 18:11:41.906378+00 | 2022-10-06 18:11:41.906502+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 385 AND "courses_exercisesolutionvote"."user_id" = 925 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 22007 | 10 | postgres | | 172.17.0.8 | | 50470 | 2022-10-06 18:11:41.758354+00 | | 2022-10-06 18:11:41.891253+00 | 2022-10-06 18:11:41.891369+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 230 AND "courses_exercisesolutionvote"."user_id" = 925 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 22013 | 10 | postgres | | 172.17.0.8 | | 36764 | 2022-10-06 18:11:51.880482+00 | | 2022-10-06 18:11:51.96125+00 | 2022-10-06 18:11:51.961371+00 | Client | ClientRead | idle | | | SELECT MAX("courses_exercisechoice"."correctness") AS "correctness__max" FROM "courses_exercisechoice" WHERE "courses_exercisechoice"."exercise_id" = 4 | client backend | |
| 16384 | sai_evo_db | 22014 | 10 | postgres | | 172.17.0.8 | | 36778 | 2022-10-06 18:11:52.10803+00 | | 2022-10-06 18:11:52.225912+00 | 2022-10-06 18:11:52.226079+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 335 AND "courses_exercisesolutionvote"."user_id" = 925 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 22015 | 10 | postgres | | 172.17.0.8 | | 36784 | 2022-10-06 18:11:52.12711+00 | | 2022-10-06 18:11:52.246579+00 | 2022-10-06 18:11:52.246703+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 336 AND "courses_exercisesolutionvote"."user_id" = 925 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 22016 | 10 | postgres | | 172.17.0.8 | | 36786 | 2022-10-06 18:11:52.137459+00 | | 2022-10-06 18:11:52.270812+00 | 2022-10-06 18:11:52.270952+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 430 AND "courses_exercisesolutionvote"."user_id" = 925 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 22017 | 10 | postgres | | 172.17.0.8 | | 36788 | 2022-10-06 18:11:52.146841+00 | | 2022-10-06 18:11:52.325802+00 | 2022-10-06 18:11:52.325933+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 371 AND "courses_exercisesolutionvote"."user_id" = 925 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 22020 | 10 | postgres | | 172.17.0.8 | | 57628 | 2022-10-06 18:11:56.818564+00 | | 2022-10-06 18:11:56.980281+00 | 2022-10-06 18:11:56.980552+00 | Client | ClientRead | idle | | | SELECT "courses_eventtemplateruleclause"."id", "courses_eventtemplateruleclause"."rule_id" FROM "courses_eventtemplateruleclause" WHERE "courses_eventtemplateruleclause"."rule_id" = 24150 ORDER BY "courses_eventtemplateruleclause"."rule_id" ASC, "courses_eventtemplateruleclause"."id" ASC | client backend | |
| 16384 | sai_evo_db | 22019 | 10 | postgres | | 172.17.0.8 | | 57622 | 2022-10-06 18:11:56.465416+00 | | 2022-10-06 18:11:56.811896+00 | 2022-10-06 18:11:56.98799+00 | Client | ClientRead | idle | | | SELECT ("courses_exercise_public_tags"."tag_id") AS "_prefetch_related_val_tag_id", "courses_exercise"."id", "courses_exercise"."_ordering", "courses_exercise"."created", "courses_exercise"."modified", "courses_exercise"."locked_by_id", "courses_exercise"."last_lock_update", "courses_exercise"."course_id", "courses_exercise"."creator_id", "courses_exercise"."parent_id", "courses_exercise"."child_weight", "courses_exercise"."exercise_type", "courses_exercise"."label", "courses_exercise"."text", "courses_exercise"."solution", "courses_exercise"."initial_code", "courses_exercise"."state", "courses_exercise"."time_to_complete", "courses_exercise"."skip_if_timeout", "courses_exercise"."requires_typescript", "courses_exercise"."all_or_nothing" FROM "courses_exercise" INNER JOIN "courses_exercise_public_tags" ON ("courses_exercise"."id" = "courses_exercise_public_tags"."exercise_id") WHERE ("courses_exercise"."state" = 2 AND NOT ("courses_exercise"."id" IN (2564)) AND "courses_exercise_public_tags"."tag_id" IN (270 | client backend | |
| 16384 | sai_evo_db | 22031 | 10 | postgres | | 172.17.0.8 | | 57668 | 2022-10-06 18:12:01.019249+00 | | 2022-10-06 18:12:01.051785+00 | 2022-10-06 18:12:01.051917+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 2 AND "courses_usercourseprivilege"."user_id" = 925) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 22030 | 10 | postgres | | 172.17.0.8 | | 57664 | 2022-10-06 18:12:00.917463+00 | | 2022-10-06 18:12:00.954772+00 | 2022-10-06 18:12:00.954899+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 2 AND "courses_usercourseprivilege"."user_id" = 925) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 22032 | 10 | postgres | | 172.17.0.8 | | 57672 | 2022-10-06 18:12:02.379364+00 | | 2022-10-06 18:12:02.40859+00 | 2022-10-06 18:12:02.409009+00 | Client | ClientRead | idle | | | SELECT "courses_courserole"."id", "courses_courserole"."name", "courses_courserole"."course_id", "courses_courserole"."allow_privileges" FROM "courses_courserole" INNER JOIN "users_user_roles" ON ("courses_courserole"."id" = "users_user_roles"."courserole_id") WHERE ("users_user_roles"."user_id" = 925 AND "courses_courserole"."course_id" IN (27, 25, 17, 15, 14, 8, 7, 2)) ORDER BY "courses_courserole"."course_id" ASC, "courses_courserole"."name" ASC | client backend | |
| 16384 | sai_evo_db | 22026 | 10 | postgres | | 172.17.0.8 | | 57656 | 2022-10-06 18:12:00.119996+00 | | 2022-10-06 18:12:00.465792+00 | 2022-10-06 18:12:00.641622+00 | Client | ClientRead | idle | | | SELECT ("courses_exercise_public_tags"."tag_id") AS "_prefetch_related_val_tag_id", "courses_exercise"."id", "courses_exercise"."_ordering", "courses_exercise"."created", "courses_exercise"."modified", "courses_exercise"."locked_by_id", "courses_exercise"."last_lock_update", "courses_exercise"."course_id", "courses_exercise"."creator_id", "courses_exercise"."parent_id", "courses_exercise"."child_weight", "courses_exercise"."exercise_type", "courses_exercise"."label", "courses_exercise"."text", "courses_exercise"."solution", "courses_exercise"."initial_code", "courses_exercise"."state", "courses_exercise"."time_to_complete", "courses_exercise"."skip_if_timeout", "courses_exercise"."requires_typescript", "courses_exercise"."all_or_nothing" FROM "courses_exercise" INNER JOIN "courses_exercise_public_tags" ON ("courses_exercise"."id" = "courses_exercise_public_tags"."exercise_id") WHERE ("courses_exercise"."state" = 2 AND NOT ("courses_exercise"."id" IN (2564)) AND "courses_exercise_public_tags"."tag_id" IN (270 | client backend | |
| 16384 | sai_evo_db | 21877 | 10 | postgres | psql | 127.0.0.1 | | 58798 | 2022-10-06 18:07:52.655907+00 | 2022-10-06 18:12:07.508929+00 | 2022-10-06 18:12:07.508929+00 | 2022-10-06 18:12:07.508932+00 | | | active | | 811667 | SELECT * FROM pg_stat_activity; | client backend | |
| 16384 | sai_evo_db | 21976 | 10 | postgres | | 172.17.0.8 | | 34452 | 2022-10-06 18:11:24.618024+00 | | 2022-10-06 18:11:24.657276+00 | 2022-10-06 18:11:24.657406+00 | Client | ClientRead | idle | | | SELECT "courses_usercourseprivilege"."id", "courses_usercourseprivilege"."user_id", "courses_usercourseprivilege"."course_id", "courses_usercourseprivilege"."allow_privileges", "courses_usercourseprivilege"."deny_privileges" FROM "courses_usercourseprivilege" WHERE ("courses_usercourseprivilege"."course_id" = 27 AND "courses_usercourseprivilege"."user_id" = 925) LIMIT 21 | client backend | |
| | | 31 | | | | | | | 2022-10-05 09:56:54.650005+00 | | | | Activity | BgWriterHibernate | | | | | background writer | |
| | | 30 | | | | | | | 2022-10-05 09:56:54.649735+00 | | | | Activity | CheckpointerMain | | | | | checkpointer | |
| | | 32 | | | | | | | 2022-10-05 09:56:54.650302+00 | | | | Activity | WalWriterMain | | | | | walwriter | |
| (39 rows) | |
| sai_evo_db=# | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment