Created
October 19, 2022 19:06
-
-
Save samul-1/f7d27b63f1e394223f5a036eea867820 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
| 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 | 125663 | 10 | postgres | | 172.17.0.21 | | 45030 | 2022-10-19 16:15:52.281339+00 | | 2022-10-19 16:15:52.568642+00 | 2022-10-19 16:15:52.580326+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125383 | 10 | postgres | | 172.17.0.12 | | 43384 | 2022-10-19 16:06:25.860875+00 | | 2022-10-19 16:06:26.194382+00 | 2022-10-19 16:06:26.194774+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" = 970) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125661 | 10 | postgres | | 172.17.0.8 | | 45362 | 2022-10-19 16:15:52.164028+00 | | 2022-10-19 16:15:52.549241+00 | 2022-10-19 16:15:52.549591+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" = 143073 LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125326 | 10 | postgres | | 172.17.0.8 | | 56442 | 2022-10-19 16:05:39.47792+00 | | 2022-10-19 16:05:40.154992+00 | 2022-10-19 16:05:40.231447+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 (276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287 | client backend | |
| 16384 | sai_evo_db | 125699 | 10 | postgres | | 172.17.0.12 | | 46264 | 2022-10-19 16:16:42.972391+00 | | 2022-10-19 16:16:44.506768+00 | 2022-10-19 16:16:44.507257+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" = 143073 LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 24490 | 10 | postgres | psql | 127.0.0.1 | | 34608 | 2022-10-07 07:17:19.348326+00 | | 2022-10-07 07:17:34.325313+00 | 2022-10-07 07:17:34.327764+00 | Client | ClientRead | idle | | | SELECT * FROM pg_stat_activity; | client backend | |
| 16384 | sai_evo_db | 125389 | 10 | postgres | | 172.17.0.12 | | 34010 | 2022-10-19 16:06:31.897113+00 | | 2022-10-19 16:06:32.048193+00 | 2022-10-19 16:06:32.048552+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" = 970) 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 | 125390 | 10 | postgres | | 172.17.0.12 | | 34026 | 2022-10-19 16:06:33.695667+00 | | 2022-10-19 16:06:33.747319+00 | 2022-10-19 16:06:33.747565+00 | Client | ClientRead | idle | | | SELECT "courses_eventtemplateruleclause"."id", "courses_eventtemplateruleclause"."rule_id" FROM "courses_eventtemplateruleclause" WHERE "courses_eventtemplateruleclause"."rule_id" = 25958 ORDER BY "courses_eventtemplateruleclause"."rule_id" ASC, "courses_eventtemplateruleclause"."id" ASC | client backend | |
| 16384 | sai_evo_db | 125300 | 10 | postgres | | 172.17.0.8 | | 59112 | 2022-10-19 16:05:06.199396+00 | | 2022-10-19 16:05:06.227254+00 | 2022-10-19 16:05:06.227765+00 | Client | ClientRead | idle | | | SELECT "oauth2_provider_accesstoken"."id", "oauth2_provider_accesstoken"."user_id", "oauth2_provider_accesstoken"."source_refresh_token_id", "oauth2_provider_accesstoken"."token", "oauth2_provider_accesstoken"."id_token_id", "oauth2_provider_accesstoken"."application_id", "oauth2_provider_accesstoken"."expires", "oauth2_provider_accesstoken"."scope", "oauth2_provider_accesstoken"."created", "oauth2_provider_accesstoken"."updated", "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", "oauth2_provider_application"."id", "oauth2_provider_application"."client_id", "oauth2_provider_application"."user_id", "oauth2_provider_application"."redirect_uris", "oauth2_provider_application"."client_type", "oauth2_provider_applicatio | client backend | |
| 16384 | sai_evo_db | 125330 | 10 | postgres | | 172.17.0.8 | | 56466 | 2022-10-19 16:05:39.936331+00 | | 2022-10-19 16:05:40.163763+00 | 2022-10-19 16:05:40.175261+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125701 | 10 | postgres | | 172.17.0.13 | | 50952 | 2022-10-19 16:16:43.064476+00 | | 2022-10-19 16:16:44.518428+00 | 2022-10-19 16:16:44.532835+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125402 | 10 | postgres | | 172.17.0.8 | | 33468 | 2022-10-19 16:06:47.572701+00 | | 2022-10-19 16:06:47.68896+00 | 2022-10-19 16:06:47.689371+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" = 916) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125388 | 10 | postgres | | 172.17.0.8 | | 58208 | 2022-10-19 16:06:31.473201+00 | | 2022-10-19 16:06:31.590324+00 | 2022-10-19 16:06:31.59065+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" = 916) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125451 | 10 | postgres | | 172.17.0.21 | | 54090 | 2022-10-19 16:07:56.233039+00 | | 2022-10-19 16:07:57.75939+00 | 2022-10-19 16:07:57.768697+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125393 | 10 | postgres | | 172.17.0.8 | | 58728 | 2022-10-19 16:06:36.607378+00 | | 2022-10-19 16:06:36.663551+00 | 2022-10-19 16:06:36.664385+00 | Client | ClientRead | idle | | | SELECT "courses_tag"."id", "courses_tag"."course_id", "courses_tag"."creator_id", "courses_tag"."name" FROM "courses_tag" INNER JOIN "courses_eventtemplateruleclause_tags" ON ("courses_tag"."id" = "courses_eventtemplateruleclause_tags"."tag_id") WHERE "courses_eventtemplateruleclause_tags"."eventtemplateruleclause_id" = 25232 ORDER BY "courses_tag"."course_id" ASC, "courses_tag"."id" ASC | client backend | |
| 16384 | sai_evo_db | 125406 | 10 | postgres | | 172.17.0.12 | | 51384 | 2022-10-19 16:06:56.996647+00 | | 2022-10-19 16:06:57.078998+00 | 2022-10-19 16:06:57.091749+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125453 | 10 | postgres | | 172.17.0.13 | | 43870 | 2022-10-19 16:07:56.466888+00 | | 2022-10-19 16:07:58.260914+00 | 2022-10-19 16:07:58.272505+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125395 | 10 | postgres | | 172.17.0.12 | | 36516 | 2022-10-19 16:06:40.226573+00 | | 2022-10-19 16:06:40.340175+00 | 2022-10-19 16:06:40.340529+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" = 916) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125414 | 10 | postgres | | 172.17.0.12 | | 59858 | 2022-10-19 16:07:10.306837+00 | | 2022-10-19 16:07:10.421088+00 | 2022-10-19 16:07:10.421417+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" = 1000) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125400 | 10 | postgres | | 172.17.0.8 | | 58794 | 2022-10-19 16:06:45.730437+00 | | 2022-10-19 16:06:45.765173+00 | 2022-10-19 16:06:45.765663+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" = 959 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 | 125401 | 10 | postgres | | 172.17.0.12 | | 36550 | 2022-10-19 16:06:45.730862+00 | | 2022-10-19 16:06:45.811163+00 | 2022-10-19 16:06:45.81123+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125311 | 10 | postgres | | 172.17.0.8 | | 59164 | 2022-10-19 16:05:09.349778+00 | | 2022-10-19 16:05:09.424343+00 | 2022-10-19 16:05:09.424473+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" = 1000) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125316 | 10 | postgres | | 172.17.0.8 | | 44434 | 2022-10-19 16:05:16.820528+00 | | 2022-10-19 16:05:16.906384+00 | 2022-10-19 16:05:16.924726+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125332 | 10 | postgres | | 172.17.0.8 | | 56510 | 2022-10-19 16:05:40.838514+00 | | 2022-10-19 16:05:40.923422+00 | 2022-10-19 16:05:40.938058+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125324 | 10 | postgres | | 172.17.0.8 | | 56418 | 2022-10-19 16:05:37.977274+00 | | 2022-10-19 16:05:38.008097+00 | 2022-10-19 16:05:38.011177+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" = 190 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 | 125405 | 10 | postgres | | 172.17.0.8 | | 46840 | 2022-10-19 16:06:56.830151+00 | | 2022-10-19 16:06:56.937966+00 | 2022-10-19 16:06:56.938288+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" = 916) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125415 | 10 | postgres | | 172.17.0.12 | | 59864 | 2022-10-19 16:07:10.749789+00 | | 2022-10-19 16:07:10.854873+00 | 2022-10-19 16:07:10.855194+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" = 914) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125409 | 10 | postgres | | 172.17.0.12 | | 51426 | 2022-10-19 16:07:01.42273+00 | | 2022-10-19 16:07:01.51122+00 | 2022-10-19 16:07:01.521157+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125413 | 10 | postgres | | 172.17.0.8 | | 56172 | 2022-10-19 16:07:08.894495+00 | | 2022-10-19 16:07:09.009466+00 | 2022-10-19 16:07:09.009798+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" = 1000) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125341 | 10 | postgres | | 172.17.0.8 | | 35886 | 2022-10-19 16:05:47.265356+00 | | 2022-10-19 16:05:47.382994+00 | 2022-10-19 16:05:47.383351+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" = 970) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125340 | 10 | postgres | | 172.17.0.8 | | 56614 | 2022-10-19 16:05:44.978505+00 | | 2022-10-19 16:05:45.193555+00 | 2022-10-19 16:05:45.193773+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" = 11924 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125412 | 10 | postgres | | 172.17.0.12 | | 59850 | 2022-10-19 16:07:07.419231+00 | | 2022-10-19 16:07:07.533511+00 | 2022-10-19 16:07:07.533834+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" = 1000) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125416 | 10 | postgres | | 172.17.0.8 | | 56188 | 2022-10-19 16:07:12.314574+00 | | 2022-10-19 16:07:12.419319+00 | 2022-10-19 16:07:12.419642+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" = 916) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125417 | 10 | postgres | | 172.17.0.12 | | 59874 | 2022-10-19 16:07:12.628209+00 | | 2022-10-19 16:07:12.734597+00 | 2022-10-19 16:07:12.734942+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" = 1000) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125344 | 10 | postgres | | 172.17.0.8 | | 35904 | 2022-10-19 16:05:47.823339+00 | | 2022-10-19 16:05:48.187851+00 | 2022-10-19 16:05:48.263334+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 (276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287 | client backend | |
| 16384 | sai_evo_db | 125418 | 10 | postgres | | 172.17.0.8 | | 56196 | 2022-10-19 16:07:13.902835+00 | | 2022-10-19 16:07:14.016878+00 | 2022-10-19 16:07:14.017304+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" = 1000) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125347 | 10 | postgres | | 172.17.0.8 | | 35934 | 2022-10-19 16:05:48.896172+00 | | 2022-10-19 16:05:49.096582+00 | 2022-10-19 16:05:49.096678+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 230 AND "courses_exercisesolutionvote"."user_id" = 190 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 125349 | 10 | postgres | | 172.17.0.8 | | 35938 | 2022-10-19 16:05:48.900509+00 | | 2022-10-19 16:05:49.036635+00 | 2022-10-19 16:05:49.036799+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 385 AND "courses_exercisesolutionvote"."user_id" = 190 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 125354 | 10 | postgres | | 172.17.0.8 | | 36758 | 2022-10-19 16:05:58.253627+00 | | 2022-10-19 16:05:58.37398+00 | 2022-10-19 16:05:58.374323+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" = 970) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125351 | 10 | postgres | | 172.17.0.8 | | 35944 | 2022-10-19 16:05:48.932421+00 | | 2022-10-19 16:05:49.156131+00 | 2022-10-19 16:05:49.156544+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" = 970) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125419 | 10 | postgres | | 172.17.0.12 | | 59890 | 2022-10-19 16:07:15.667946+00 | | 2022-10-19 16:07:15.773245+00 | 2022-10-19 16:07:15.773512+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" = 141856 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125428 | 10 | postgres | | 172.17.0.12 | | 52874 | 2022-10-19 16:07:18.990122+00 | | 2022-10-19 16:07:19.101477+00 | 2022-10-19 16:07:19.1018+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" = 1000) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125429 | 10 | postgres | | 172.17.0.8 | | 42418 | 2022-10-19 16:07:19.773338+00 | | 2022-10-19 16:07:19.88+00 | 2022-10-19 16:07:19.880372+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" = 1000) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125357 | 10 | postgres | | 172.17.0.8 | | 36772 | 2022-10-19 16:06:02.137099+00 | | 2022-10-19 16:06:02.255262+00 | 2022-10-19 16:06:02.255585+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" = 970) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125424 | 10 | postgres | | 172.17.0.12 | | 52854 | 2022-10-19 16:07:17.206018+00 | | 2022-10-19 16:07:17.320568+00 | 2022-10-19 16:07:17.320934+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" = 1000) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125426 | 10 | postgres | | 172.17.0.12 | | 52866 | 2022-10-19 16:07:17.837842+00 | | 2022-10-19 16:07:17.9484+00 | 2022-10-19 16:07:17.94873+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" = 1000) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125359 | 10 | postgres | | 172.17.0.8 | | 45436 | 2022-10-19 16:06:08.369295+00 | | 2022-10-19 16:06:10.699379+00 | 2022-10-19 16:06:10.773932+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 (276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287 | client backend | |
| 16384 | sai_evo_db | 125427 | 10 | postgres | | 172.17.0.8 | | 42410 | 2022-10-19 16:07:18.397648+00 | | 2022-10-19 16:07:18.51564+00 | 2022-10-19 16:07:18.515961+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" = 1000) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125437 | 10 | postgres | | 172.17.0.12 | | 32862 | 2022-10-19 16:07:33.902357+00 | | 2022-10-19 16:07:34.012818+00 | 2022-10-19 16:07:34.013144+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" = 916) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125431 | 10 | postgres | | 172.17.0.12 | | 52904 | 2022-10-19 16:07:24.499903+00 | | 2022-10-19 16:07:24.621993+00 | 2022-10-19 16:07:24.622334+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" = 916) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125368 | 10 | postgres | | 172.17.0.8 | | 45482 | 2022-10-19 16:06:12.67919+00 | | 2022-10-19 16:06:12.7119+00 | 2022-10-19 16:06:12.715426+00 | Client | ClientRead | idle | | | SELECT "gamification_gamificationreputationdelta"."id", "gamification_gamificationreputationdelta"."created", "gamification_gamificationreputationdelta"."modified", "gamification_gamificationreputationdelta"."context_id", "gamification_gamificationreputationdelta"."user_id", "gamification_gamificationreputationdelta"."delta", "gamification_gamificationreputationdelta"."data" FROM "gamification_gamificationreputationdelta" WHERE ("gamification_gamificationreputationdelta"."context_id" = 2 AND "gamification_gamificationreputationdelta"."user_id" IN (190, 253, 32, 132, 266, 89, 216, 109, 91, 139)) | client backend | |
| 16384 | sai_evo_db | 125376 | 10 | postgres | | 172.17.0.8 | | 45546 | 2022-10-19 16:06:15.24345+00 | | 2022-10-19 16:06:15.619977+00 | 2022-10-19 16:06:15.694909+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 (276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287 | client backend | |
| 16384 | sai_evo_db | 125373 | 10 | postgres | | 172.17.0.8 | | 45510 | 2022-10-19 16:06:13.855941+00 | | 2022-10-19 16:06:13.894965+00 | 2022-10-19 16:06:13.895087+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" = 190) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125436 | 10 | postgres | | 172.17.0.8 | | 46654 | 2022-10-19 16:07:28.905257+00 | | 2022-10-19 16:07:29.027946+00 | 2022-10-19 16:07:29.028294+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" = 1000) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125433 | 10 | postgres | | 172.17.0.8 | | 42454 | 2022-10-19 16:07:25.728464+00 | | 2022-10-19 16:07:25.820183+00 | 2022-10-19 16:07:25.83091+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125454 | 10 | postgres | | 172.17.0.8 | | 42992 | 2022-10-19 16:07:56.620273+00 | | 2022-10-19 16:07:56.708554+00 | 2022-10-19 16:07:56.720249+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125460 | 10 | postgres | | 172.17.0.12 | | 60188 | 2022-10-19 16:07:59.602666+00 | | 2022-10-19 16:07:59.81372+00 | 2022-10-19 16:07:59.813909+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" = 11924 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125441 | 10 | postgres | | 172.17.0.12 | | 35282 | 2022-10-19 16:07:43.201781+00 | | 2022-10-19 16:07:43.30778+00 | 2022-10-19 16:07:43.308103+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" = 916) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125378 | 10 | postgres | | 172.17.0.8 | | 45554 | 2022-10-19 16:06:15.837813+00 | | 2022-10-19 16:06:16.038101+00 | 2022-10-19 16:06:16.038233+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" = 190) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125382 | 10 | postgres | | 172.17.0.12 | | 43374 | 2022-10-19 16:06:21.83359+00 | | 2022-10-19 16:06:26.071702+00 | 2022-10-19 16:06:26.071874+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" = 190) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125442 | 10 | postgres | | 172.17.0.12 | | 35288 | 2022-10-19 16:07:45.281332+00 | | 2022-10-19 16:07:45.40335+00 | 2022-10-19 16:07:45.403678+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" = 959) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125469 | 10 | postgres | | 172.17.0.8 | | 43008 | 2022-10-19 16:08:25.785951+00 | | 2022-10-19 16:08:25.893076+00 | 2022-10-19 16:08:25.893349+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" = 141856 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125444 | 10 | postgres | | 172.17.0.8 | | 60212 | 2022-10-19 16:07:48.464416+00 | | 2022-10-19 16:07:48.571034+00 | 2022-10-19 16:07:48.571361+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" = 143165 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125448 | 10 | postgres | | 172.17.0.8 | | 60236 | 2022-10-19 16:07:55.76344+00 | | 2022-10-19 16:07:55.854534+00 | 2022-10-19 16:07:55.863592+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125459 | 10 | postgres | | 172.17.0.8 | | 43090 | 2022-10-19 16:07:57.787445+00 | | 2022-10-19 16:07:57.960012+00 | 2022-10-19 16:07:57.960335+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" = 11924 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125457 | 10 | postgres | | 172.17.0.8 | | 43050 | 2022-10-19 16:07:57.206379+00 | | 2022-10-19 16:07:57.303143+00 | 2022-10-19 16:07:57.314972+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125462 | 10 | postgres | | 172.17.0.8 | | 43128 | 2022-10-19 16:08:03.492693+00 | | 2022-10-19 16:08:03.596932+00 | 2022-10-19 16:08:03.597203+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" = 141856 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125463 | 10 | postgres | | 172.17.0.12 | | 41824 | 2022-10-19 16:08:08.756191+00 | | 2022-10-19 16:08:08.860178+00 | 2022-10-19 16:08:08.860441+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" = 143165 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125486 | 10 | postgres | | 172.17.0.12 | | 60902 | 2022-10-19 16:08:56.334393+00 | | 2022-10-19 16:08:56.367579+00 | 2022-10-19 16:08:56.367948+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 | 125492 | 10 | postgres | | 172.17.0.12 | | 60936 | 2022-10-19 16:08:57.861298+00 | | 2022-10-19 16:08:57.912972+00 | 2022-10-19 16:08:57.913472+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, 2577)) AND "courses_exercise_public_tags"."tag_id" I | client backend | |
| 16384 | sai_evo_db | 125500 | 10 | postgres | | 172.17.0.8 | | 56896 | 2022-10-19 16:09:02.54071+00 | | 2022-10-19 16:09:02.583031+00 | 2022-10-19 16:09:02.583406+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_eventparticipation" WHERE ("courses_eventparticipation"."event_id" = 11924 AND "courses_eventparticipation"."user_id" = 998) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 125468 | 10 | postgres | | 172.17.0.12 | | 40374 | 2022-10-19 16:08:23.934906+00 | | 2022-10-19 16:08:24.05777+00 | 2022-10-19 16:08:24.058051+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" = 143124 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125478 | 10 | postgres | | 172.17.0.8 | | 59486 | 2022-10-19 16:08:39.917253+00 | | 2022-10-19 16:08:40.051501+00 | 2022-10-19 16:08:40.051863+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" = 940) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125475 | 10 | postgres | | 172.17.0.8 | | 54096 | 2022-10-19 16:08:27.575598+00 | | 2022-10-19 16:08:27.641448+00 | 2022-10-19 16:08:27.641566+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" = 998) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125481 | 10 | postgres | | 172.17.0.12 | | 49234 | 2022-10-19 16:08:45.459191+00 | | 2022-10-19 16:08:45.530761+00 | 2022-10-19 16:08:45.531116+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" = 998) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125494 | 10 | postgres | | 172.17.0.8 | | 56858 | 2022-10-19 16:08:58.026819+00 | | 2022-10-19 16:08:58.094835+00 | 2022-10-19 16:08:58.094981+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" = 916) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125524 | 10 | postgres | | 172.17.0.8 | | 57586 | 2022-10-19 16:10:29.560186+00 | | 2022-10-19 16:10:29.635055+00 | 2022-10-19 16:10:29.635219+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" = 916) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125525 | 10 | postgres | | 172.17.0.12 | | 58088 | 2022-10-19 16:10:29.570321+00 | | 2022-10-19 16:10:29.662599+00 | 2022-10-19 16:10:29.676984+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125498 | 10 | postgres | | 172.17.0.12 | | 60964 | 2022-10-19 16:09:00.577922+00 | | 2022-10-19 16:09:00.78742+00 | 2022-10-19 16:09:00.787616+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" = 11924 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125491 | 10 | postgres | | 172.17.0.8 | | 56844 | 2022-10-19 16:08:57.792196+00 | | 2022-10-19 16:08:57.901986+00 | 2022-10-19 16:08:57.90231+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" = 141856 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125508 | 10 | postgres | | 172.17.0.8 | | 38246 | 2022-10-19 16:09:47.972546+00 | | 2022-10-19 16:09:48.148898+00 | 2022-10-19 16:09:48.149453+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" = 141856 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125548 | 10 | postgres | | 172.17.0.8 | | 45000 | 2022-10-19 16:10:44.72402+00 | | 2022-10-19 16:10:44.761307+00 | 2022-10-19 16:10:44.7659+00 | Client | ClientRead | idle | | | SELECT "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", EXISTS(SELECT (1) AS "a" FROM "courses_eventparticipationslot" U0 INNER JOIN "courses_eventparticipation" U1 ON (U0."participation_id" = U1."id") INNER JOIN "courses_event" U2 ON (U1."event_id" = U2."id") WHERE ((U1."_assessment_state" = 2 OR U2."event_type" = 0) AND U0."exercise_id" = ("courses_exercise"."id") AND U2."course_id" = 27 AND U1."user_i | client backend | |
| 16384 | sai_evo_db | 125506 | 10 | postgres | | 172.17.0.12 | | 47184 | 2022-10-19 16:09:45.957339+00 | | 2022-10-19 16:09:46.017681+00 | 2022-10-19 16:09:46.01863+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" = 930 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 | 125511 | 10 | postgres | | 172.17.0.8 | | 48938 | 2022-10-19 16:10:14.27948+00 | | 2022-10-19 16:10:14.38355+00 | 2022-10-19 16:10:14.383847+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" = 141856 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125533 | 10 | postgres | | 172.17.0.12 | | 58146 | 2022-10-19 16:10:34.984062+00 | | 2022-10-19 16:10:35.019213+00 | 2022-10-19 16:10:35.019645+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, 2577)) AND "courses_exercise_public_tags"."tag_id" I | client backend | |
| 16384 | sai_evo_db | 125549 | 10 | postgres | | 172.17.0.8 | | 45002 | 2022-10-19 16:10:44.730156+00 | | 2022-10-19 16:10:44.778659+00 | 2022-10-19 16:10:44.783849+00 | Client | ClientRead | idle | | | SELECT "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", EXISTS(SELECT (1) AS "a" FROM "courses_eventparticipationslot" U0 INNER JOIN "courses_eventparticipation" U1 ON (U0."participation_id" = U1."id") INNER JOIN "courses_event" U2 ON (U1."event_id" = U2."id") WHERE ((U1."_assessment_state" = 2 OR U2."event_type" = 0) AND U0."exercise_id" = ("courses_exercise"."id") AND U2."course_id" = 27 AND U1."user_i | client backend | |
| 16384 | sai_evo_db | 125561 | 10 | postgres | | 172.17.0.12 | | 49378 | 2022-10-19 16:10:50.412805+00 | | 2022-10-19 16:10:50.466238+00 | 2022-10-19 16:10:50.471369+00 | Client | ClientRead | idle | | | SELECT "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", EXISTS(SELECT (1) AS "a" FROM "courses_eventparticipationslot" U0 INNER JOIN "courses_eventparticipation" U1 ON (U0."participation_id" = U1."id") INNER JOIN "courses_event" U2 ON (U1."event_id" = U2."id") WHERE ((U1."_assessment_state" = 2 OR U2."event_type" = 0) AND U0."exercise_id" = ("courses_exercise"."id") AND U2."course_id" = 27 AND U1."user_i | client backend | |
| 16384 | sai_evo_db | 125562 | 10 | postgres | | 172.17.0.8 | | 38656 | 2022-10-19 16:10:50.414877+00 | | 2022-10-19 16:10:50.488394+00 | 2022-10-19 16:10:50.492924+00 | Client | ClientRead | idle | | | SELECT "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", EXISTS(SELECT (1) AS "a" FROM "courses_eventparticipationslot" U0 INNER JOIN "courses_eventparticipation" U1 ON (U0."participation_id" = U1."id") INNER JOIN "courses_event" U2 ON (U1."event_id" = U2."id") WHERE ((U1."_assessment_state" = 2 OR U2."event_type" = 0) AND U0."exercise_id" = ("courses_exercise"."id") AND U2."course_id" = 27 AND U1."user_i | client backend | |
| 16384 | sai_evo_db | 125519 | 10 | postgres | | 172.17.0.8 | | 57562 | 2022-10-19 16:10:27.622898+00 | | 2022-10-19 16:10:27.69225+00 | 2022-10-19 16:10:27.692369+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" = 916) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125547 | 10 | postgres | | 172.17.0.8 | | 44990 | 2022-10-19 16:10:44.680582+00 | | 2022-10-19 16:10:44.740059+00 | 2022-10-19 16:10:44.744746+00 | Client | ClientRead | idle | | | SELECT "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", EXISTS(SELECT (1) AS "a" FROM "courses_eventparticipationslot" U0 INNER JOIN "courses_eventparticipation" U1 ON (U0."participation_id" = U1."id") INNER JOIN "courses_event" U2 ON (U1."event_id" = U2."id") WHERE ((U1."_assessment_state" = 2 OR U2."event_type" = 0) AND U0."exercise_id" = ("courses_exercise"."id") AND U2."course_id" = 27 AND U1."user_i | client backend | |
| 16384 | sai_evo_db | 125535 | 10 | postgres | | 172.17.0.12 | | 58154 | 2022-10-19 16:10:35.123507+00 | | 2022-10-19 16:10:35.192757+00 | 2022-10-19 16:10:35.192874+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" = 916) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125536 | 10 | postgres | | 172.17.0.8 | | 57658 | 2022-10-19 16:10:35.454018+00 | | 2022-10-19 16:10:35.495306+00 | 2022-10-19 16:10:35.495421+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" = 916) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125564 | 10 | postgres | | 172.17.0.12 | | 49388 | 2022-10-19 16:10:50.432736+00 | | 2022-10-19 16:10:50.51535+00 | 2022-10-19 16:10:50.521242+00 | Client | ClientRead | idle | | | SELECT "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", EXISTS(SELECT (1) AS "a" FROM "courses_eventparticipationslot" U0 INNER JOIN "courses_eventparticipation" U1 ON (U0."participation_id" = U1."id") INNER JOIN "courses_event" U2 ON (U1."event_id" = U2."id") WHERE ((U1."_assessment_state" = 2 OR U2."event_type" = 0) AND U0."exercise_id" = ("courses_exercise"."id") AND U2."course_id" = 27 AND U1."user_i | client backend | |
| 16384 | sai_evo_db | 125552 | 10 | postgres | | 172.17.0.8 | | 45010 | 2022-10-19 16:10:45.370313+00 | | 2022-10-19 16:10:45.488013+00 | 2022-10-19 16:10:45.488352+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" = 914) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125545 | 10 | postgres | | 172.17.0.12 | | 49858 | 2022-10-19 16:10:44.40419+00 | | 2022-10-19 16:10:44.472224+00 | 2022-10-19 16:10:44.472352+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" = 916) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125563 | 10 | postgres | | 172.17.0.8 | | 38662 | 2022-10-19 16:10:50.432734+00 | | 2022-10-19 16:10:50.493022+00 | 2022-10-19 16:10:50.497622+00 | Client | ClientRead | idle | | | SELECT "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", EXISTS(SELECT (1) AS "a" FROM "courses_eventparticipationslot" U0 INNER JOIN "courses_eventparticipation" U1 ON (U0."participation_id" = U1."id") INNER JOIN "courses_event" U2 ON (U1."event_id" = U2."id") WHERE ((U1."_assessment_state" = 2 OR U2."event_type" = 0) AND U0."exercise_id" = ("courses_exercise"."id") AND U2."course_id" = 27 AND U1."user_i | client backend | |
| 16384 | sai_evo_db | 125565 | 10 | postgres | | 172.17.0.12 | | 49390 | 2022-10-19 16:10:50.444666+00 | | 2022-10-19 16:10:50.527147+00 | 2022-10-19 16:10:50.535485+00 | Client | ClientRead | idle | | | SELECT "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", EXISTS(SELECT (1) AS "a" FROM "courses_eventparticipationslot" U0 INNER JOIN "courses_eventparticipation" U1 ON (U0."participation_id" = U1."id") INNER JOIN "courses_event" U2 ON (U1."event_id" = U2."id") WHERE ((U1."_assessment_state" = 2 OR U2."event_type" = 0) AND U0."exercise_id" = ("courses_exercise"."id") AND U2."course_id" = 27 AND U1."user_i | client backend | |
| 16384 | sai_evo_db | 125566 | 10 | postgres | | 172.17.0.12 | | 49392 | 2022-10-19 16:10:50.450201+00 | | 2022-10-19 16:10:50.563324+00 | 2022-10-19 16:10:50.56861+00 | Client | ClientRead | idle | | | SELECT "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", EXISTS(SELECT (1) AS "a" FROM "courses_eventparticipationslot" U0 INNER JOIN "courses_eventparticipation" U1 ON (U0."participation_id" = U1."id") INNER JOIN "courses_event" U2 ON (U1."event_id" = U2."id") WHERE ((U1."_assessment_state" = 2 OR U2."event_type" = 0) AND U0."exercise_id" = ("courses_exercise"."id") AND U2."course_id" = 27 AND U1."user_i | client backend | |
| 16384 | sai_evo_db | 125577 | 10 | postgres | | 172.17.0.12 | | 45360 | 2022-10-19 16:10:58.375744+00 | | 2022-10-19 16:10:58.417803+00 | 2022-10-19 16:10:58.417943+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" = 916) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125557 | 10 | postgres | | 172.17.0.8 | | 38614 | 2022-10-19 16:10:48.881077+00 | | 2022-10-19 16:10:48.916802+00 | 2022-10-19 16:10:48.917682+00 | Client | ClientRead | idle | | | SELECT COUNT(*) AS "__count" FROM "courses_exercise" WHERE ("courses_exercise"."course_id" = 8 AND "courses_exercise"."state" = 2) | client backend | |
| 16384 | sai_evo_db | 125578 | 10 | postgres | | 172.17.0.8 | | 53424 | 2022-10-19 16:10:59.747769+00 | | 2022-10-19 16:10:59.953019+00 | 2022-10-19 16:10:59.953196+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" = 11924 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125586 | 10 | postgres | | 172.17.0.8 | | 43424 | 2022-10-19 16:11:23.030394+00 | | 2022-10-19 16:11:23.123659+00 | 2022-10-19 16:11:23.134331+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125587 | 10 | postgres | | 172.17.0.12 | | 42166 | 2022-10-19 16:11:26.29055+00 | | 2022-10-19 16:11:26.431582+00 | 2022-10-19 16:11:26.431927+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" = 940) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125606 | 10 | postgres | | 172.17.0.8 | | 44826 | 2022-10-19 16:12:00.100719+00 | | 2022-10-19 16:12:00.21567+00 | 2022-10-19 16:12:00.215939+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" = 141856 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125584 | 10 | postgres | | 172.17.0.12 | | 36138 | 2022-10-19 16:11:22.707226+00 | | 2022-10-19 16:11:22.847044+00 | 2022-10-19 16:11:22.847536+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" = 142153 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125611 | 10 | postgres | | 172.17.0.12 | | 48864 | 2022-10-19 16:12:14.896059+00 | | 2022-10-19 16:12:15.003044+00 | 2022-10-19 16:12:15.003366+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" = 998) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125594 | 10 | postgres | | 172.17.0.12 | | 42392 | 2022-10-19 16:11:34.501391+00 | | 2022-10-19 16:11:34.612612+00 | 2022-10-19 16:11:34.614852+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 (1938, 1936, 1935, 1907, 1929, 1891, 1894, 1930, 1928, 1888 | client backend | |
| 16384 | sai_evo_db | 125591 | 10 | postgres | | 172.17.0.8 | | 41952 | 2022-10-19 16:11:34.359851+00 | | 2022-10-19 16:11:34.492354+00 | 2022-10-19 16:11:34.503575+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125576 | 10 | postgres | | 172.17.0.8 | | 53414 | 2022-10-19 16:10:58.190612+00 | | 2022-10-19 16:10:58.260543+00 | 2022-10-19 16:10:58.26069+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" = 916) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125608 | 10 | postgres | | 172.17.0.8 | | 55438 | 2022-10-19 16:12:10.944372+00 | | 2022-10-19 16:12:11.071394+00 | 2022-10-19 16:12:11.071931+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" = 998) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125610 | 10 | postgres | | 172.17.0.12 | | 48844 | 2022-10-19 16:12:12.565624+00 | | 2022-10-19 16:12:12.659305+00 | 2022-10-19 16:12:12.669343+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125599 | 10 | postgres | | 172.17.0.12 | | 42426 | 2022-10-19 16:11:34.841288+00 | | 2022-10-19 16:11:35.104551+00 | 2022-10-19 16:11:35.104716+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" = 15 AND "courses_usercourseprivilege"."user_id" = 417) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125601 | 10 | postgres | | 172.17.0.12 | | 43530 | 2022-10-19 16:11:39.493016+00 | | 2022-10-19 16:11:39.59113+00 | 2022-10-19 16:11:39.60562+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125612 | 10 | postgres | | 172.17.0.8 | | 51852 | 2022-10-19 16:12:16.468447+00 | | 2022-10-19 16:12:16.59348+00 | 2022-10-19 16:12:16.59381+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" = 1000) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125604 | 10 | postgres | | 172.17.0.12 | | 43576 | 2022-10-19 16:11:42.369023+00 | | 2022-10-19 16:11:42.554732+00 | 2022-10-19 16:11:42.554824+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125617 | 10 | postgres | | 172.17.0.8 | | 33894 | 2022-10-19 16:12:30.516232+00 | | 2022-10-19 16:12:30.5585+00 | 2022-10-19 16:12:30.559079+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" = 930 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 | 125631 | 10 | postgres | | 172.17.0.12 | | 50354 | 2022-10-19 16:13:02.47432+00 | | 2022-10-19 16:13:02.605487+00 | 2022-10-19 16:13:02.605833+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" = 1005) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125615 | 10 | postgres | | 172.17.0.8 | | 51880 | 2022-10-19 16:12:25.40013+00 | | 2022-10-19 16:12:25.519412+00 | 2022-10-19 16:12:25.519748+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" = 998) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125616 | 10 | postgres | | 172.17.0.12 | | 36752 | 2022-10-19 16:12:30.365104+00 | | 2022-10-19 16:12:30.399261+00 | 2022-10-19 16:12:30.399736+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" = 930 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 | 125619 | 10 | postgres | | 172.17.0.8 | | 33902 | 2022-10-19 16:12:35.354167+00 | | 2022-10-19 16:12:35.462967+00 | 2022-10-19 16:12:35.46336+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" = 998) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125626 | 10 | postgres | | 172.17.0.8 | | 51452 | 2022-10-19 16:12:50.579003+00 | | 2022-10-19 16:12:50.663806+00 | 2022-10-19 16:12:50.679167+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125622 | 10 | postgres | | 172.17.0.12 | | 60424 | 2022-10-19 16:12:47.493186+00 | | 2022-10-19 16:12:47.610273+00 | 2022-10-19 16:12:47.61064+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" = 998) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125632 | 10 | postgres | | 172.17.0.8 | | 56916 | 2022-10-19 16:13:03.153086+00 | | 2022-10-19 16:13:03.286495+00 | 2022-10-19 16:13:03.286837+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" = 998) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125633 | 10 | postgres | | 172.17.0.12 | | 44942 | 2022-10-19 16:13:10.985246+00 | | 2022-10-19 16:13:11.106003+00 | 2022-10-19 16:13:11.106487+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" = 998) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125630 | 10 | postgres | | 172.17.0.12 | | 50346 | 2022-10-19 16:12:58.928443+00 | | 2022-10-19 16:12:59.000777+00 | 2022-10-19 16:12:59.001131+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" = 998) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125653 | 10 | postgres | | 172.17.0.12 | | 57974 | 2022-10-19 16:15:09.128438+00 | | 2022-10-19 16:15:09.259771+00 | 2022-10-19 16:15:09.260058+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" = 143130 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125641 | 10 | postgres | | 172.17.0.8 | | 59566 | 2022-10-19 16:14:09.560126+00 | | 2022-10-19 16:14:09.590754+00 | 2022-10-19 16:14:09.591177+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" = 930 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 | 125639 | 10 | postgres | | 172.17.0.12 | | 40770 | 2022-10-19 16:13:42.383467+00 | | 2022-10-19 16:13:42.495499+00 | 2022-10-19 16:13:42.495857+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" = 970) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125642 | 10 | postgres | | 172.17.0.12 | | 41554 | 2022-10-19 16:14:09.622393+00 | | 2022-10-19 16:14:09.656285+00 | 2022-10-19 16:14:09.656734+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" = 930 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 | 125666 | 10 | postgres | | 172.17.0.12 | | 47684 | 2022-10-19 16:15:56.496777+00 | | 2022-10-19 16:15:56.678259+00 | 2022-10-19 16:15:56.678453+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" = 12192 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125665 | 10 | postgres | | 172.17.0.8 | | 45388 | 2022-10-19 16:15:56.009288+00 | | 2022-10-19 16:15:56.296704+00 | 2022-10-19 16:15:56.296859+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" = 12192 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125647 | 10 | postgres | | 172.17.0.8 | | 60148 | 2022-10-19 16:14:56.01556+00 | | 2022-10-19 16:14:56.150046+00 | 2022-10-19 16:14:56.150361+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" = 141944 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125652 | 10 | postgres | | 172.17.0.12 | | 37358 | 2022-10-19 16:15:04.20844+00 | | 2022-10-19 16:15:04.364428+00 | 2022-10-19 16:15:04.364775+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" = 914) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 120290 | 10 | postgres | | 172.17.0.13 | | 50886 | 2022-10-19 14:31:28.558784+00 | | 2022-10-19 14:31:29.274504+00 | 2022-10-19 14:31:29.295332+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125662 | 10 | postgres | | 172.17.0.8 | | 45370 | 2022-10-19 16:15:52.231765+00 | | 2022-10-19 16:15:52.329959+00 | 2022-10-19 16:15:52.339933+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125656 | 10 | postgres | | 172.17.0.8 | | 54534 | 2022-10-19 16:15:32.698715+00 | | 2022-10-19 16:15:32.807958+00 | 2022-10-19 16:15:32.808302+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" = 142509 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125660 | 10 | postgres | | 172.17.0.12 | | 36318 | 2022-10-19 16:15:51.998511+00 | | 2022-10-19 16:15:52.120863+00 | 2022-10-19 16:15:52.121188+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" = 143073 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125673 | 10 | postgres | | 172.17.0.12 | | 57616 | 2022-10-19 16:16:19.078209+00 | | 2022-10-19 16:16:19.188985+00 | 2022-10-19 16:16:19.189299+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" = 142509 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125700 | 10 | postgres | | 172.17.0.8 | | 46022 | 2022-10-19 16:16:43.015774+00 | | 2022-10-19 16:16:43.110215+00 | 2022-10-19 16:16:43.127325+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 125687 | 10 | postgres | | 172.17.0.12 | | 46248 | 2022-10-19 16:16:39.128333+00 | | 2022-10-19 16:16:39.162991+00 | 2022-10-19 16:16:39.16311+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" = 7 AND "courses_usercourseprivilege"."user_id" = 788) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125711 | 10 | postgres | | 172.17.0.8 | | 54318 | 2022-10-19 16:16:53.381311+00 | | 2022-10-19 16:16:53.415347+00 | 2022-10-19 16:16:53.41555+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" = 7 AND "courses_usercourseprivilege"."user_id" = 788) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125677 | 10 | postgres | | 172.17.0.12 | | 46222 | 2022-10-19 16:16:38.169312+00 | | 2022-10-19 16:16:38.418377+00 | 2022-10-19 16:16:38.447934+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 (2238, 2252, 2239, 2250, 2275, 2237, 2259, 2258, 2267, 2260 | client backend | |
| 16384 | sai_evo_db | 125672 | 10 | postgres | | 172.17.0.8 | | 47928 | 2022-10-19 16:16:10.943744+00 | | 2022-10-19 16:16:11.109585+00 | 2022-10-19 16:16:11.109916+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" = 143073 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 125696 | 10 | postgres | psql | 127.0.0.1 | | 46792 | 2022-10-19 16:16:40.872918+00 | 2022-10-19 16:16:58.461178+00 | 2022-10-19 16:16:58.461178+00 | 2022-10-19 16:16:58.46118+00 | | | active | | 861636 | SELECT * FROM pg_stat_activity; | client backend | |
| 16384 | sai_evo_db | 125707 | 10 | postgres | | 172.17.0.8 | | 54302 | 2022-10-19 16:16:52.768158+00 | | 2022-10-19 16:16:52.919882+00 | 2022-10-19 16:16:52.947339+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 (2238, 2252, 2239, 2250, 2275, 2237, 2259, 2258, 2267, 2260 | client backend | |
| 16384 | sai_evo_db | 125709 | 10 | postgres | | 172.17.0.8 | | 54310 | 2022-10-19 16:16:53.077056+00 | | 2022-10-19 16:16:53.109316+00 | 2022-10-19 16:16:53.110219+00 | Client | ClientRead | idle | | | SELECT COUNT(*) AS "__count" FROM "courses_exercise" WHERE ("courses_exercise"."course_id" = 7 AND "courses_exercise"."state" = 2) | client backend | |
| 16384 | sai_evo_db | 125710 | 10 | postgres | | 172.17.0.12 | | 44402 | 2022-10-19 16:16:53.178551+00 | | 2022-10-19 16:16:53.246018+00 | 2022-10-19 16:16:53.24614+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" = 7 AND "courses_usercourseprivilege"."user_id" = 788) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 125715 | 10 | postgres | | 172.17.0.12 | | 51548 | 2022-10-19 16:16:57.941003+00 | | 2022-10-19 16:16:58.021003+00 | 2022-10-19 16:16:58.021407+00 | Client | ClientRead | idle | | | SELECT "courses_tag"."id", "courses_tag"."course_id", "courses_tag"."creator_id", "courses_tag"."name" FROM "courses_tag" INNER JOIN "courses_eventtemplateruleclause_tags" ON ("courses_tag"."id" = "courses_eventtemplateruleclause_tags"."tag_id") WHERE "courses_eventtemplateruleclause_tags"."eventtemplateruleclause_id" = 25233 ORDER BY "courses_tag"."course_id" ASC, "courses_tag"."id" ASC | client backend | |
| 16384 | sai_evo_db | 120288 | 10 | postgres | | 172.17.0.21 | | 60908 | 2022-10-19 14:31:28.457442+00 | | 2022-10-19 14:31:29.272379+00 | 2022-10-19 14:31:29.28604+00 | Client | ClientRead | idle | | | COMMIT | 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 | |
| (155 rows) | |
| sai_evo_db=# | |
| sai_evo_db=# | |
| 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 | 138250 | 10 | postgres | | 172.17.0.12 | | 59686 | 2022-10-19 18:34:47.216049+00 | | 2022-10-19 18:34:47.289376+00 | 2022-10-19 18:34:47.289869+00 | Client | ClientRead | idle | | | SELECT "oauth2_provider_accesstoken"."id", "oauth2_provider_accesstoken"."user_id", "oauth2_provider_accesstoken"."source_refresh_token_id", "oauth2_provider_accesstoken"."token", "oauth2_provider_accesstoken"."id_token_id", "oauth2_provider_accesstoken"."application_id", "oauth2_provider_accesstoken"."expires", "oauth2_provider_accesstoken"."scope", "oauth2_provider_accesstoken"."created", "oauth2_provider_accesstoken"."updated", "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", "oauth2_provider_application"."id", "oauth2_provider_application"."client_id", "oauth2_provider_application"."user_id", "oauth2_provider_application"."redirect_uris", "oauth2_provider_application"."client_type", "oauth2_provider_applicatio | client backend | |
| 16384 | sai_evo_db | 138282 | 10 | postgres | | 172.17.0.8 | | 57862 | 2022-10-19 18:35:07.788432+00 | | 2022-10-19 18:35:07.861898+00 | 2022-10-19 18:35:07.862053+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" = 928) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138402 | 10 | postgres | | 172.17.0.8 | | 52182 | 2022-10-19 18:59:42.507781+00 | | 2022-10-19 18:59:43.582074+00 | 2022-10-19 18:59:43.582425+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" = 141947 LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138291 | 10 | postgres | | 172.17.0.12 | | 53080 | 2022-10-19 18:35:33.205811+00 | | 2022-10-19 18:35:33.319064+00 | 2022-10-19 18:35:33.319391+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" = 928) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138335 | 10 | postgres | | 172.17.0.12 | | 59286 | 2022-10-19 18:36:58.608385+00 | | 2022-10-19 18:36:59.188733+00 | 2022-10-19 18:36:59.189097+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" = 142594 LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 24490 | 10 | postgres | psql | 127.0.0.1 | | 34608 | 2022-10-07 07:17:19.348326+00 | | 2022-10-07 07:17:34.325313+00 | 2022-10-07 07:17:34.327764+00 | Client | ClientRead | idle | | | SELECT * FROM pg_stat_activity; | client backend | |
| 16384 | sai_evo_db | 138251 | 10 | postgres | | 172.17.0.12 | | 59688 | 2022-10-19 18:34:47.219241+00 | | 2022-10-19 18:34:47.387582+00 | 2022-10-19 18:34:47.388052+00 | Client | ClientRead | idle | | | SELECT "oauth2_provider_accesstoken"."id", "oauth2_provider_accesstoken"."user_id", "oauth2_provider_accesstoken"."source_refresh_token_id", "oauth2_provider_accesstoken"."token", "oauth2_provider_accesstoken"."id_token_id", "oauth2_provider_accesstoken"."application_id", "oauth2_provider_accesstoken"."expires", "oauth2_provider_accesstoken"."scope", "oauth2_provider_accesstoken"."created", "oauth2_provider_accesstoken"."updated", "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", "oauth2_provider_application"."id", "oauth2_provider_application"."client_id", "oauth2_provider_application"."user_id", "oauth2_provider_application"."redirect_uris", "oauth2_provider_application"."client_type", "oauth2_provider_applicatio | 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 | 138279 | 10 | postgres | | 172.17.0.12 | | 47078 | 2022-10-19 18:35:07.603623+00 | | 2022-10-19 18:35:07.674455+00 | 2022-10-19 18:35:07.674576+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" = 958) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138292 | 10 | postgres | | 172.17.0.8 | | 51288 | 2022-10-19 18:35:35.940432+00 | | 2022-10-19 18:35:36.046951+00 | 2022-10-19 18:35:36.047291+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" = 928) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138285 | 10 | postgres | | 172.17.0.8 | | 57884 | 2022-10-19 18:35:09.92123+00 | | 2022-10-19 18:35:09.99751+00 | 2022-10-19 18:35:09.99758+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 138273 | 10 | postgres | | 172.17.0.8 | | 35836 | 2022-10-19 18:35:02.921446+00 | | 2022-10-19 18:35:07.4118+00 | 2022-10-19 18:35:07.41249+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, 2577)) AND "courses_exercise_public_tags"."tag_id" I | client backend | |
| 16384 | sai_evo_db | 138293 | 10 | postgres | | 172.17.0.8 | | 33668 | 2022-10-19 18:35:37.507975+00 | | 2022-10-19 18:35:37.618077+00 | 2022-10-19 18:35:37.6184+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" = 939) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138404 | 10 | postgres | | 172.17.0.13 | | 55116 | 2022-10-19 18:59:42.645939+00 | | 2022-10-19 18:59:43.586202+00 | 2022-10-19 18:59:43.599532+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 126203 | 10 | postgres | | 172.17.0.21 | | 40656 | 2022-10-19 16:40:18.951333+00 | | 2022-10-19 16:40:32.078049+00 | 2022-10-19 16:40:32.09385+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 138294 | 10 | postgres | | 172.17.0.12 | | 49000 | 2022-10-19 18:35:40.710304+00 | | 2022-10-19 18:35:40.824826+00 | 2022-10-19 18:35:40.825163+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" = 939) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138290 | 10 | postgres | | 172.17.0.12 | | 42930 | 2022-10-19 18:35:20.2073+00 | | 2022-10-19 18:35:20.282054+00 | 2022-10-19 18:35:20.282134+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 126205 | 10 | postgres | | 172.17.0.13 | | 50460 | 2022-10-19 16:40:19.118823+00 | | 2022-10-19 16:40:31.624622+00 | 2022-10-19 16:40:31.634187+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 138295 | 10 | postgres | | 172.17.0.8 | | 33686 | 2022-10-19 18:35:45.691898+00 | | 2022-10-19 18:35:45.809529+00 | 2022-10-19 18:35:45.809899+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" = 939) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138302 | 10 | postgres | | 172.17.0.12 | | 43130 | 2022-10-19 18:35:59.070808+00 | | 2022-10-19 18:35:59.181314+00 | 2022-10-19 18:35:59.181633+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" = 928) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138303 | 10 | postgres | | 172.17.0.8 | | 33736 | 2022-10-19 18:36:01.093752+00 | | 2022-10-19 18:36:01.202743+00 | 2022-10-19 18:36:01.20306+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" = 928) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138301 | 10 | postgres | | 172.17.0.12 | | 39038 | 2022-10-19 18:35:52.468134+00 | | 2022-10-19 18:35:52.58149+00 | 2022-10-19 18:35:52.581818+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" = 939) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138323 | 10 | postgres | | 172.17.0.12 | | 33178 | 2022-10-19 18:36:35.206886+00 | | 2022-10-19 18:36:35.333965+00 | 2022-10-19 18:36:35.334295+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" = 939) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138368 | 10 | postgres | | 172.17.0.21 | | 35066 | 2022-10-19 18:50:16.311704+00 | | 2022-10-19 18:50:16.802009+00 | 2022-10-19 18:50:16.814009+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 138306 | 10 | postgres | | 172.17.0.8 | | 33762 | 2022-10-19 18:36:05.799843+00 | | 2022-10-19 18:36:05.908333+00 | 2022-10-19 18:36:05.908672+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" = 939) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138329 | 10 | postgres | | 172.17.0.12 | | 48032 | 2022-10-19 18:36:38.951396+00 | | 2022-10-19 18:36:39.074745+00 | 2022-10-19 18:36:39.07514+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" = 939) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138314 | 10 | postgres | | 172.17.0.12 | | 53480 | 2022-10-19 18:36:22.688328+00 | | 2022-10-19 18:36:22.728232+00 | 2022-10-19 18:36:22.728383+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" = 939) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138317 | 10 | postgres | | 172.17.0.8 | | 41872 | 2022-10-19 18:36:28.087942+00 | | 2022-10-19 18:36:28.220144+00 | 2022-10-19 18:36:28.220498+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" = 939) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138324 | 10 | postgres | | 172.17.0.8 | | 41912 | 2022-10-19 18:36:35.988711+00 | | 2022-10-19 18:36:36.110665+00 | 2022-10-19 18:36:36.110984+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" = 939) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138320 | 10 | postgres | | 172.17.0.8 | | 41886 | 2022-10-19 18:36:29.98838+00 | | 2022-10-19 18:36:30.09431+00 | 2022-10-19 18:36:30.094585+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" = 142594 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 138322 | 10 | postgres | | 172.17.0.12 | | 33172 | 2022-10-19 18:36:31.119606+00 | | 2022-10-19 18:36:31.243072+00 | 2022-10-19 18:36:31.243419+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" = 939) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138313 | 10 | postgres | | 172.17.0.8 | | 46124 | 2022-10-19 18:36:22.456231+00 | | 2022-10-19 18:36:22.568804+00 | 2022-10-19 18:36:22.569581+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_event_users_allowed_past_closure" ON ("users_user"."id" = "courses_event_users_allowed_past_closure"."user_id") WHERE "courses_event_users_allowed_past_closure"."event_id" = 11122 | client backend | |
| 16384 | sai_evo_db | 138326 | 10 | postgres | | 172.17.0.12 | | 48008 | 2022-10-19 18:36:37.108068+00 | | 2022-10-19 18:36:37.235554+00 | 2022-10-19 18:36:37.235886+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" = 939) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138328 | 10 | postgres | | 172.17.0.8 | | 41050 | 2022-10-19 18:36:37.463226+00 | | 2022-10-19 18:36:37.552529+00 | 2022-10-19 18:36:37.562527+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 138263 | 10 | postgres | | 172.17.0.12 | | 59748 | 2022-10-19 18:34:55.816153+00 | | 2022-10-19 18:34:55.892252+00 | 2022-10-19 18:34:55.89233+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 138351 | 10 | postgres | | 172.17.0.12 | | 48796 | 2022-10-19 18:37:39.755519+00 | | 2022-10-19 18:37:39.962998+00 | 2022-10-19 18:37:39.963595+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" = 905) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138331 | 10 | postgres | | 172.17.0.12 | | 60626 | 2022-10-19 18:36:47.830437+00 | | 2022-10-19 18:36:47.951623+00 | 2022-10-19 18:36:47.951949+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" = 958) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138337 | 10 | postgres | | 172.17.0.8 | | 44698 | 2022-10-19 18:36:58.791808+00 | | 2022-10-19 18:36:58.909493+00 | 2022-10-19 18:36:58.90987+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" = 137305 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 138365 | 10 | postgres | | 172.17.0.12 | | 52526 | 2022-10-19 18:50:15.843577+00 | | 2022-10-19 18:50:15.964813+00 | 2022-10-19 18:50:15.965108+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" = 142734 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 138350 | 10 | postgres | | 172.17.0.8 | | 39018 | 2022-10-19 18:37:14.072856+00 | | 2022-10-19 18:37:14.197514+00 | 2022-10-19 18:37:14.197659+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 138384 | 10 | postgres | | 172.17.0.8 | | 40468 | 2022-10-19 18:54:40.607415+00 | | 2022-10-19 18:54:40.691566+00 | 2022-10-19 18:54:40.692145+00 | Client | ClientRead | idle | | | SELECT ("courses_event_users_allowed_past_closure"."event_id") AS "_prefetch_related_val_event_id", "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_event_users_allowed_past_closure" ON ("users_user"."id" = "courses_event_users_allowed_past_closure"."user_id") WHERE "courses_event_users_allowed_past_closure"."event_id" IN (8686, 6089, 6051, 3771, 1912, 352, 351, 258) | client backend | |
| 16384 | sai_evo_db | 138369 | 10 | postgres | | 172.17.0.8 | | 34278 | 2022-10-19 18:50:21.607261+00 | | 2022-10-19 18:50:21.727886+00 | 2022-10-19 18:50:21.728201+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" = 906) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138418 | 10 | postgres | | 172.17.0.8 | | 40956 | 2022-10-19 19:04:51.000112+00 | | 2022-10-19 19:04:51.175304+00 | 2022-10-19 19:04:51.175466+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 28 AND "courses_exercisesolutionvote"."user_id" = 403 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 138343 | 10 | postgres | | 172.17.0.12 | | 52212 | 2022-10-19 18:37:07.208742+00 | | 2022-10-19 18:37:07.35494+00 | 2022-10-19 18:37:07.355206+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" = 137305 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 138375 | 10 | postgres | | 172.17.0.8 | | 40292 | 2022-10-19 18:53:15.940165+00 | | 2022-10-19 18:53:16.001313+00 | 2022-10-19 18:53:16.001444+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 | 138347 | 10 | postgres | | 172.17.0.8 | | 38994 | 2022-10-19 18:37:07.825525+00 | | 2022-10-19 18:37:07.866598+00 | 2022-10-19 18:37:07.867304+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 | 138378 | 10 | postgres | | 172.17.0.12 | | 52976 | 2022-10-19 18:54:28.506806+00 | | 2022-10-19 18:54:28.584345+00 | 2022-10-19 18:54:28.584953+00 | Client | ClientRead | idle | | | SELECT ("courses_event_users_allowed_past_closure"."event_id") AS "_prefetch_related_val_event_id", "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_event_users_allowed_past_closure" ON ("users_user"."id" = "courses_event_users_allowed_past_closure"."user_id") WHERE "courses_event_users_allowed_past_closure"."event_id" IN (8686, 6089, 6051, 3771, 1912, 352, 351, 258) | client backend | |
| 16384 | sai_evo_db | 138395 | 10 | postgres | | 172.17.0.8 | | 41434 | 2022-10-19 18:54:50.759442+00 | | 2022-10-19 18:54:50.841235+00 | 2022-10-19 18:54:50.841839+00 | Client | ClientRead | idle | | | SELECT ("courses_event_users_allowed_past_closure"."event_id") AS "_prefetch_related_val_event_id", "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_event_users_allowed_past_closure" ON ("users_user"."id" = "courses_event_users_allowed_past_closure"."user_id") WHERE "courses_event_users_allowed_past_closure"."event_id" IN (8686, 6089, 6051, 3771, 1912, 352, 351, 258) | client backend | |
| 16384 | sai_evo_db | 138391 | 10 | postgres | | 172.17.0.12 | | 54256 | 2022-10-19 18:54:48.478543+00 | | 2022-10-19 18:54:49.192479+00 | 2022-10-19 18:54:49.19319+00 | Client | ClientRead | idle | | | SELECT ("courses_exercise_private_tags"."exercise_id") AS "_prefetch_related_val_exercise_id", "courses_tag"."id", "courses_tag"."course_id", "courses_tag"."creator_id", "courses_tag"."name" FROM "courses_tag" INNER JOIN "courses_exercise_private_tags" ON ("courses_tag"."id" = "courses_exercise_private_tags"."tag_id") WHERE "courses_exercise_private_tags"."exercise_id" IN (1995, 1997, 1999, 2001, 1996, 1994, 1998, 2002, 2000) ORDER BY "courses_tag"."course_id" ASC, "courses_tag"."id" ASC | client backend | |
| 16384 | sai_evo_db | 138383 | 10 | postgres | | 172.17.0.12 | | 39106 | 2022-10-19 18:54:40.57248+00 | | 2022-10-19 18:54:40.638709+00 | 2022-10-19 18:54:40.638795+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 | 138388 | 10 | postgres | | 172.17.0.12 | | 39132 | 2022-10-19 18:54:43.562053+00 | | 2022-10-19 18:54:43.616918+00 | 2022-10-19 18:54:43.617455+00 | Client | ClientRead | idle | | | SELECT ("courses_exercise_private_tags"."exercise_id") AS "_prefetch_related_val_exercise_id", "courses_tag"."id", "courses_tag"."course_id", "courses_tag"."creator_id", "courses_tag"."name" FROM "courses_tag" INNER JOIN "courses_exercise_private_tags" ON ("courses_tag"."id" = "courses_exercise_private_tags"."tag_id") WHERE "courses_exercise_private_tags"."exercise_id" IN (830, 1998) ORDER BY "courses_tag"."course_id" ASC, "courses_tag"."id" ASC | client backend | |
| 16384 | sai_evo_db | 138394 | 10 | postgres | | 172.17.0.12 | | 54268 | 2022-10-19 18:54:49.84498+00 | | 2022-10-19 18:54:49.987023+00 | 2022-10-19 18:54:49.98775+00 | Client | ClientRead | idle | | | SELECT ("courses_exercise_private_tags"."exercise_id") AS "_prefetch_related_val_exercise_id", "courses_tag"."id", "courses_tag"."course_id", "courses_tag"."creator_id", "courses_tag"."name" FROM "courses_tag" INNER JOIN "courses_exercise_private_tags" ON ("courses_tag"."id" = "courses_exercise_private_tags"."tag_id") WHERE "courses_exercise_private_tags"."exercise_id" IN (1995, 1997, 1999, 2001, 1996, 1994, 1998, 2002, 2000) ORDER BY "courses_tag"."course_id" ASC, "courses_tag"."id" ASC | client backend | |
| 16384 | sai_evo_db | 138401 | 10 | postgres | | 172.17.0.12 | | 51328 | 2022-10-19 18:59:42.25952+00 | | 2022-10-19 18:59:42.386755+00 | 2022-10-19 18:59:42.387053+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" = 141947 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 138406 | 10 | postgres | | 172.17.0.8 | | 51534 | 2022-10-19 19:00:06.026693+00 | | 2022-10-19 19:00:06.164578+00 | 2022-10-19 19:00:06.164922+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" = 914) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 138419 | 10 | postgres | | 172.17.0.12 | | 56174 | 2022-10-19 19:04:51.00184+00 | | 2022-10-19 19:04:51.138509+00 | 2022-10-19 19:04:51.13867+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 14 AND "courses_exercisesolutionvote"."user_id" = 403 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 138413 | 10 | postgres | | 172.17.0.8 | | 33878 | 2022-10-19 19:04:28.03083+00 | | 2022-10-19 19:04:28.090565+00 | 2022-10-19 19:04:28.090651+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 | 138415 | 10 | postgres | | 172.17.0.8 | | 40882 | 2022-10-19 19:04:46.702307+00 | | 2022-10-19 19:04:47.332351+00 | 2022-10-19 19:04:47.332562+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" = 11869 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 138417 | 10 | postgres | | 172.17.0.8 | | 40938 | 2022-10-19 19:04:50.96326+00 | | 2022-10-19 19:04:51.103307+00 | 2022-10-19 19:04:51.103454+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 25 AND "courses_exercisesolutionvote"."user_id" = 403 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 138420 | 10 | postgres | | 172.17.0.12 | | 56176 | 2022-10-19 19:04:51.017196+00 | | 2022-10-19 19:04:51.156106+00 | 2022-10-19 19:04:51.156237+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 27 AND "courses_exercisesolutionvote"."user_id" = 403 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 138421 | 10 | postgres | | 172.17.0.8 | | 40962 | 2022-10-19 19:04:51.041532+00 | | 2022-10-19 19:04:51.224101+00 | 2022-10-19 19:04:51.224243+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 765 AND "courses_exercisesolutionvote"."user_id" = 403 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 138424 | 10 | postgres | | 172.17.0.8 | | 40968 | 2022-10-19 19:04:51.055092+00 | | 2022-10-19 19:04:51.231162+00 | 2022-10-19 19:04:51.231309+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 24 AND "courses_exercisesolutionvote"."user_id" = 403 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 138422 | 10 | postgres | | 172.17.0.8 | | 40964 | 2022-10-19 19:04:51.053208+00 | | 2022-10-19 19:04:51.256847+00 | 2022-10-19 19:04:51.256997+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 41 AND "courses_exercisesolutionvote"."user_id" = 403 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 138423 | 10 | postgres | | 172.17.0.12 | | 56182 | 2022-10-19 19:04:51.054389+00 | | 2022-10-19 19:04:51.232198+00 | 2022-10-19 19:04:51.232363+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 23 AND "courses_exercisesolutionvote"."user_id" = 403 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 138425 | 10 | postgres | | 172.17.0.12 | | 56186 | 2022-10-19 19:04:51.063387+00 | | 2022-10-19 19:04:51.221407+00 | 2022-10-19 19:04:51.221545+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 26 AND "courses_exercisesolutionvote"."user_id" = 403 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 138426 | 10 | postgres | | 172.17.0.12 | | 56192 | 2022-10-19 19:04:51.224972+00 | | 2022-10-19 19:04:51.292423+00 | 2022-10-19 19:04:51.292709+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 15 AND "courses_exercisesolutionvote"."user_id" = 403 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 138427 | 10 | postgres | | 172.17.0.8 | | 40978 | 2022-10-19 19:04:51.249473+00 | | 2022-10-19 19:04:51.320073+00 | 2022-10-19 19:04:51.320174+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 40 AND "courses_exercisesolutionvote"."user_id" = 403 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 138442 | 10 | postgres | psql | 127.0.0.1 | | 48436 | 2022-10-19 19:05:18.614151+00 | 2022-10-19 19:05:25.144239+00 | 2022-10-19 19:05:25.144239+00 | 2022-10-19 19:05:25.144242+00 | | | active | | 862995 | SELECT * FROM pg_stat_activity; | client backend | |
| 16384 | sai_evo_db | 120290 | 10 | postgres | | 172.17.0.13 | | 50886 | 2022-10-19 14:31:28.558784+00 | | 2022-10-19 14:31:29.274504+00 | 2022-10-19 14:31:29.295332+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 126207 | 10 | postgres | | 172.17.0.21 | | 40684 | 2022-10-19 16:40:19.315296+00 | | 2022-10-19 16:40:19.966161+00 | 2022-10-19 16:40:19.975897+00 | Client | ClientRead | idle | | | COMMIT | 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 | |
| (74 rows) | |
| sai_evo_db=# | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment