Created
October 20, 2022 16:37
-
-
Save samul-1/def8ccb850a08cdaac7080b63a4b7680 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT * FROM pg_stat_activity; | |
| datid | datname | pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | state_change | wait_event_type | wait_event | state | backend_xid | backend_xmin | query | backend_type | |
| -------+------------+--------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------+-----------------+---------------------+--------+-------------+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------ | |
| | | 33 | | | | | | | 2022-10-05 09:56:54.650806+00 | | | | Activity | AutoVacuumMain | | | | | autovacuum launcher | |
| | | 35 | 10 | postgres | | | | | 2022-10-05 09:56:54.651548+00 | | | | Activity | LogicalLauncherMain | | | | | logical replication launcher | |
| 16384 | sai_evo_db | 164388 | 10 | postgres | | 172.17.0.17 | | 38058 | 2022-10-20 16:17:26.512134+00 | | 2022-10-20 16:17:26.739449+00 | 2022-10-20 16:17:26.739846+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 156803 | 10 | postgres | | 172.17.0.18 | | 51598 | 2022-10-20 14:06:50.353574+00 | | 2022-10-20 14:06:50.368952+00 | 2022-10-20 14:06:50.369506+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" = 951 LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164658 | 10 | postgres | | 172.17.0.10 | | 41596 | 2022-10-20 16:23:33.58789+00 | | 2022-10-20 16:24:16.170554+00 | 2022-10-20 16:24:16.180159+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 164799 | 10 | postgres | | 172.17.0.22 | | 51632 | 2022-10-20 16:25:24.5916+00 | | 2022-10-20 16:25:25.050714+00 | 2022-10-20 16:25:25.063849+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 164706 | 10 | postgres | | 172.17.0.22 | | 60690 | 2022-10-20 16:24:15.260233+00 | | 2022-10-20 16:24:15.793081+00 | 2022-10-20 16:24:15.802538+00 | Client | ClientRead | idle | | | COMMIT | 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 | 156802 | 10 | postgres | | 172.17.0.17 | | 40368 | 2022-10-20 14:06:35.970244+00 | | 2022-10-20 14:07:00.836527+00 | 2022-10-20 14:07:00.836677+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" = 951 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 | 164389 | 10 | postgres | | 172.17.0.17 | | 38064 | 2022-10-20 16:17:26.633545+00 | | 2022-10-20 16:17:26.703515+00 | 2022-10-20 16:17:26.703888+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164390 | 10 | postgres | | 172.17.0.17 | | 38072 | 2022-10-20 16:17:26.635353+00 | | 2022-10-20 16:17:26.77705+00 | 2022-10-20 16:17:26.777493+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 | 164435 | 10 | postgres | | 172.17.0.17 | | 38256 | 2022-10-20 16:17:35.86195+00 | | 2022-10-20 16:17:35.932372+00 | 2022-10-20 16:17:35.932771+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164704 | 10 | postgres | | 172.17.0.10 | | 51044 | 2022-10-20 16:24:15.060818+00 | | 2022-10-20 16:24:17.261036+00 | 2022-10-20 16:24:17.270173+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 164392 | 10 | postgres | | 172.17.0.17 | | 38076 | 2022-10-20 16:17:26.649146+00 | | 2022-10-20 16:17:26.738277+00 | 2022-10-20 16:17:26.738692+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 148216 | 10 | postgres | | 172.17.0.22 | | 56798 | 2022-10-20 11:14:39.517213+00 | | 2022-10-20 11:14:40.512074+00 | 2022-10-20 11:14:40.526065+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 164697 | 10 | postgres | psql | 127.0.0.1 | | 52892 | 2022-10-20 16:24:08.334026+00 | 2022-10-20 16:28:30.490327+00 | 2022-10-20 16:28:30.490327+00 | 2022-10-20 16:28:30.49033+00 | | | active | | 872044 | SELECT * FROM pg_stat_activity; | client backend | |
| 16384 | sai_evo_db | 164414 | 10 | postgres | | 172.17.0.17 | | 38164 | 2022-10-20 16:17:30.996051+00 | | 2022-10-20 16:17:31.062029+00 | 2022-10-20 16:17:31.062401+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164426 | 10 | postgres | | 172.17.0.17 | | 38212 | 2022-10-20 16:17:33.832857+00 | | 2022-10-20 16:17:33.95078+00 | 2022-10-20 16:17:33.951061+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" = 143807 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 164402 | 10 | postgres | | 172.17.0.17 | | 38120 | 2022-10-20 16:17:28.642613+00 | | 2022-10-20 16:17:28.690712+00 | 2022-10-20 16:17:28.691075+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164700 | 10 | postgres | | 172.17.0.18 | | 59778 | 2022-10-20 16:24:14.587981+00 | | 2022-10-20 16:24:14.704285+00 | 2022-10-20 16:24:14.71429+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 164437 | 10 | postgres | | 172.17.0.17 | | 38260 | 2022-10-20 16:17:35.870139+00 | | 2022-10-20 16:17:35.945677+00 | 2022-10-20 16:17:35.946134+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164731 | 10 | postgres | | 172.17.0.17 | | 57330 | 2022-10-20 16:24:34.178319+00 | | 2022-10-20 16:24:34.238679+00 | 2022-10-20 16:24:34.239266+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" = 990) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164683 | 10 | postgres | | 172.17.0.17 | | 39192 | 2022-10-20 16:24:04.126046+00 | | 2022-10-20 16:24:04.168001+00 | 2022-10-20 16:24:04.168138+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"."parent_id" IN (141976) ORDER BY "courses_eventparticipationslot"."participation_id" ASC, "courses_eventparticipationslot"."parent_id" ASC, "courses_eventparticipationslot"."slot_number" ASC | client backend | |
| 16384 | sai_evo_db | 164701 | 10 | postgres | | 172.17.0.18 | | 59782 | 2022-10-20 16:24:14.607959+00 | | 2022-10-20 16:24:14.772391+00 | 2022-10-20 16:24:14.772736+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" = 929) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164703 | 10 | postgres | | 172.17.0.18 | | 59798 | 2022-10-20 16:24:15.006677+00 | | 2022-10-20 16:24:15.100667+00 | 2022-10-20 16:24:15.110898+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 164778 | 10 | postgres | | 172.17.0.17 | | 50282 | 2022-10-20 16:25:06.160471+00 | | 2022-10-20 16:25:06.196249+00 | 2022-10-20 16:25:06.196573+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" = 990) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164438 | 10 | postgres | | 172.17.0.17 | | 38262 | 2022-10-20 16:17:35.904697+00 | | 2022-10-20 16:17:35.972958+00 | 2022-10-20 16:17:35.973355+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164711 | 10 | postgres | | 172.17.0.17 | | 56640 | 2022-10-20 16:24:17.77273+00 | | 2022-10-20 16:24:17.97769+00 | 2022-10-20 16:24:17.977863+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 | 164404 | 10 | postgres | | 172.17.0.17 | | 38124 | 2022-10-20 16:17:28.648652+00 | | 2022-10-20 16:17:28.706358+00 | 2022-10-20 16:17:28.706685+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164783 | 10 | postgres | | 172.17.0.18 | | 39984 | 2022-10-20 16:25:11.167053+00 | | 2022-10-20 16:25:11.204547+00 | 2022-10-20 16:25:11.20487+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" = 990) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164411 | 10 | postgres | | 172.17.0.17 | | 38158 | 2022-10-20 16:17:30.974386+00 | | 2022-10-20 16:17:31.026515+00 | 2022-10-20 16:17:31.02688+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164790 | 10 | postgres | | 172.17.0.17 | | 37262 | 2022-10-20 16:25:18.169035+00 | | 2022-10-20 16:25:18.204582+00 | 2022-10-20 16:25:18.204916+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" = 990) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164710 | 10 | postgres | | 172.17.0.18 | | 59872 | 2022-10-20 16:24:16.227304+00 | | 2022-10-20 16:24:16.404957+00 | 2022-10-20 16:24:16.405218+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 | 164413 | 10 | postgres | | 172.17.0.17 | | 38162 | 2022-10-20 16:17:30.978371+00 | | 2022-10-20 16:17:31.043236+00 | 2022-10-20 16:17:31.043613+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164748 | 10 | postgres | | 172.17.0.18 | | 49888 | 2022-10-20 16:24:48.752873+00 | | 2022-10-20 16:24:48.875734+00 | 2022-10-20 16:24:48.876007+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" = 143808 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 164447 | 10 | postgres | | 172.17.0.17 | | 53380 | 2022-10-20 16:17:37.886225+00 | | 2022-10-20 16:17:37.955653+00 | 2022-10-20 16:17:37.956101+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164448 | 10 | postgres | | 172.17.0.17 | | 53382 | 2022-10-20 16:17:37.905186+00 | | 2022-10-20 16:17:37.970074+00 | 2022-10-20 16:17:37.970464+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164717 | 10 | postgres | | 172.17.0.17 | | 56668 | 2022-10-20 16:24:22.165212+00 | | 2022-10-20 16:24:22.230561+00 | 2022-10-20 16:24:22.23113+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" = 990) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164423 | 10 | postgres | | 172.17.0.17 | | 38204 | 2022-10-20 16:17:33.792772+00 | | 2022-10-20 16:17:33.851064+00 | 2022-10-20 16:17:33.851413+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164767 | 10 | postgres | | 172.17.0.18 | | 52490 | 2022-10-20 16:25:00.161033+00 | | 2022-10-20 16:25:00.200078+00 | 2022-10-20 16:25:00.200395+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" = 990) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164804 | 10 | postgres | | 172.17.0.18 | | 54308 | 2022-10-20 16:25:28.168698+00 | | 2022-10-20 16:25:28.204738+00 | 2022-10-20 16:25:28.205075+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" = 990) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164722 | 10 | postgres | | 172.17.0.18 | | 60666 | 2022-10-20 16:24:27.170815+00 | | 2022-10-20 16:24:27.237634+00 | 2022-10-20 16:24:27.238203+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" = 990) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164815 | 10 | postgres | | 172.17.0.17 | | 45146 | 2022-10-20 16:25:39.163855+00 | | 2022-10-20 16:25:39.200139+00 | 2022-10-20 16:25:39.200464+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" = 990) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164736 | 10 | postgres | | 172.17.0.18 | | 47926 | 2022-10-20 16:24:39.164492+00 | | 2022-10-20 16:24:39.236782+00 | 2022-10-20 16:24:39.237383+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" = 990) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164829 | 10 | postgres | | 172.17.0.18 | | 34406 | 2022-10-20 16:25:52.164766+00 | | 2022-10-20 16:25:52.202927+00 | 2022-10-20 16:25:52.20324+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" = 990) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164743 | 10 | postgres | | 172.17.0.17 | | 49670 | 2022-10-20 16:24:46.155724+00 | | 2022-10-20 16:24:46.201852+00 | 2022-10-20 16:24:46.202186+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" = 990) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164816 | 10 | postgres | | 172.17.0.18 | | 59414 | 2022-10-20 16:25:40.168791+00 | | 2022-10-20 16:25:40.212526+00 | 2022-10-20 16:25:40.212844+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" = 990) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164461 | 10 | postgres | | 172.17.0.17 | | 53438 | 2022-10-20 16:17:40.698011+00 | | 2022-10-20 16:17:40.771051+00 | 2022-10-20 16:17:40.771432+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164844 | 10 | postgres | | 172.17.0.17 | | 38438 | 2022-10-20 16:25:57.257648+00 | | 2022-10-20 16:25:57.297522+00 | 2022-10-20 16:25:57.297676+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" = 8 AND "courses_usercourseprivilege"."user_id" = 1124) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164761 | 10 | postgres | | 172.17.0.17 | | 50242 | 2022-10-20 16:24:57.16029+00 | | 2022-10-20 16:24:57.201401+00 | 2022-10-20 16:24:57.201785+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" = 990) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164828 | 10 | postgres | | 172.17.0.17 | | 48112 | 2022-10-20 16:25:51.164099+00 | | 2022-10-20 16:25:51.19983+00 | 2022-10-20 16:25:51.200165+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" = 990) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164462 | 10 | postgres | | 172.17.0.17 | | 53440 | 2022-10-20 16:17:40.705415+00 | | 2022-10-20 16:17:40.7695+00 | 2022-10-20 16:17:40.769888+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164831 | 10 | postgres | | 172.17.0.18 | | 34414 | 2022-10-20 16:25:53.86923+00 | | 2022-10-20 16:25:53.97829+00 | 2022-10-20 16:25:53.978616+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" = 929) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164529 | 10 | postgres | | 172.17.0.17 | | 48460 | 2022-10-20 16:17:53.815662+00 | | 2022-10-20 16:17:53.856758+00 | 2022-10-20 16:17:53.857108+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164795 | 10 | postgres | | 172.17.0.18 | | 35228 | 2022-10-20 16:25:23.40384+00 | | 2022-10-20 16:25:23.446138+00 | 2022-10-20 16:25:23.446473+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" = 990) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164884 | 10 | postgres | | 172.17.0.18 | | 43326 | 2022-10-20 16:26:16.168674+00 | | 2022-10-20 16:26:16.203976+00 | 2022-10-20 16:26:16.204315+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" = 990) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164803 | 10 | postgres | | 172.17.0.17 | | 56334 | 2022-10-20 16:25:27.163001+00 | | 2022-10-20 16:25:27.207391+00 | 2022-10-20 16:25:27.207716+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" = 990) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164857 | 10 | postgres | | 172.17.0.17 | | 38504 | 2022-10-20 16:26:01.167753+00 | | 2022-10-20 16:26:01.208356+00 | 2022-10-20 16:26:01.208707+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" = 990) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164847 | 10 | postgres | | 172.17.0.17 | | 38456 | 2022-10-20 16:25:57.520743+00 | | 2022-10-20 16:25:57.612577+00 | 2022-10-20 16:25:57.640264+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 (201, 183, 1719, 205)) AND "courses_exercise_public_tags"." | client backend | |
| 16384 | sai_evo_db | 164474 | 10 | postgres | | 172.17.0.17 | | 53496 | 2022-10-20 16:17:43.935846+00 | | 2022-10-20 16:17:44.002738+00 | 2022-10-20 16:17:44.003243+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164475 | 10 | postgres | | 172.17.0.17 | | 53498 | 2022-10-20 16:17:43.946169+00 | | 2022-10-20 16:17:44.024494+00 | 2022-10-20 16:17:44.024914+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164824 | 10 | postgres | | 172.17.0.17 | | 48096 | 2022-10-20 16:25:47.893436+00 | | 2022-10-20 16:25:48.02736+00 | 2022-10-20 16:25:48.027701+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" = 929) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164868 | 10 | postgres | | 172.17.0.18 | | 43254 | 2022-10-20 16:26:08.169909+00 | | 2022-10-20 16:26:08.206652+00 | 2022-10-20 16:26:08.206986+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" = 990) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164895 | 10 | postgres | | 172.17.0.18 | | 50674 | 2022-10-20 16:26:23.467308+00 | | 2022-10-20 16:26:23.516193+00 | 2022-10-20 16:26:23.516977+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" = 25432 ORDER BY "courses_tag"."course_id" ASC, "courses_tag"."id" ASC | client backend | |
| 16384 | sai_evo_db | 164848 | 10 | postgres | | 172.17.0.17 | | 38462 | 2022-10-20 16:25:57.641866+00 | | 2022-10-20 16:25:57.667815+00 | 2022-10-20 16:25:57.668203+00 | Client | ClientRead | idle | | | SELECT "gamification_goal"."id", "gamification_goal"."context_id", "gamification_goal"."name" FROM "gamification_goal" WHERE "gamification_goal"."context_id" = 1 | client backend | |
| 16384 | sai_evo_db | 164838 | 10 | postgres | | 172.17.0.18 | | 47170 | 2022-10-20 16:25:56.787209+00 | | 2022-10-20 16:25:56.852112+00 | 2022-10-20 16:25:56.864558+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 "courses_exercise_public_tags"."tag_id" IN (54, 51, 46, 96, 52, 278, 48, 86, 85, 144, 95, 5 | client backend | |
| 16384 | sai_evo_db | 164839 | 10 | postgres | | 172.17.0.18 | | 47174 | 2022-10-20 16:25:56.856508+00 | | 2022-10-20 16:25:57.281781+00 | 2022-10-20 16:25:57.282278+00 | Client | ClientRead | idle | | | SELECT "oauth2_provider_refreshtoken"."id", "oauth2_provider_refreshtoken"."user_id", "oauth2_provider_refreshtoken"."token", "oauth2_provider_refreshtoken"."application_id", "oauth2_provider_refreshtoken"."access_token_id", "oauth2_provider_refreshtoken"."created", "oauth2_provider_refreshtoken"."updated", "oauth2_provider_refreshtoken"."revoked" FROM "oauth2_provider_refreshtoken" WHERE "oauth2_provider_refreshtoken"."access_token_id" = 4156 LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164915 | 10 | postgres | | 172.17.0.18 | | 41388 | 2022-10-20 16:27:49.885246+00 | | 2022-10-20 16:27:49.995939+00 | 2022-10-20 16:27:49.996204+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" = 143821 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 164910 | 10 | postgres | | 172.17.0.17 | | 33980 | 2022-10-20 16:27:12.835217+00 | | 2022-10-20 16:27:12.869751+00 | 2022-10-20 16:27:12.869867+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" = 163) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164870 | 10 | postgres | | 172.17.0.17 | | 41136 | 2022-10-20 16:26:09.589726+00 | | 2022-10-20 16:26:09.706846+00 | 2022-10-20 16:26:09.707557+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" ORDER BY "users_user"."id" DESC LIMIT 100 | client backend | |
| 16384 | sai_evo_db | 164476 | 10 | postgres | | 172.17.0.17 | | 53500 | 2022-10-20 16:17:43.950194+00 | | 2022-10-20 16:17:44.018572+00 | 2022-10-20 16:17:44.018953+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164883 | 10 | postgres | | 172.17.0.17 | | 41194 | 2022-10-20 16:26:15.160448+00 | | 2022-10-20 16:26:15.196362+00 | 2022-10-20 16:26:15.19668+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" = 990) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164911 | 10 | postgres | | 172.17.0.17 | | 36208 | 2022-10-20 16:27:18.522227+00 | | 2022-10-20 16:27:18.685778+00 | 2022-10-20 16:27:18.685856+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 164856 | 10 | postgres | | 172.17.0.18 | | 47266 | 2022-10-20 16:26:00.945235+00 | | 2022-10-20 16:26:01.029582+00 | 2022-10-20 16:26:01.029705+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" = 12336 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 164489 | 10 | postgres | | 172.17.0.17 | | 48288 | 2022-10-20 16:17:46.869352+00 | | 2022-10-20 16:17:46.952303+00 | 2022-10-20 16:17:46.95267+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164922 | 10 | postgres | | 172.17.0.17 | | 45942 | 2022-10-20 16:28:07.033929+00 | | 2022-10-20 16:28:07.08622+00 | 2022-10-20 16:28:07.086502+00 | Client | ClientRead | idle | | | SELECT "courses_eventtemplateruleclause"."id", "courses_eventtemplateruleclause"."rule_id" FROM "courses_eventtemplateruleclause" WHERE "courses_eventtemplateruleclause"."rule_id" = 26175 ORDER BY "courses_eventtemplateruleclause"."rule_id" ASC, "courses_eventtemplateruleclause"."id" ASC | client backend | |
| 16384 | sai_evo_db | 164867 | 10 | postgres | | 172.17.0.18 | | 43244 | 2022-10-20 16:26:07.787397+00 | | 2022-10-20 16:26:07.955387+00 | 2022-10-20 16:26:07.966332+00 | Client | ClientRead | idle | | | SELECT "django_admin_log"."id", "django_admin_log"."action_time", "django_admin_log"."user_id", "django_admin_log"."content_type_id", "django_admin_log"."object_id", "django_admin_log"."object_repr", "django_admin_log"."action_flag", "django_admin_log"."change_message", "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", "django_content_type"."id", "django_content_type"."app_label", "django_content_type"."model" FROM "django_admin_log" INNER JOIN "users_user" ON ("django_admin_log"."user_id" = "users_user"."id") LEFT OUTER JOIN "django_content_type" ON ("django_admin_log"."content_type_id" = "django_content_type"."id") WHERE "django_admin_log"."user_id" = 1 ORDER BY "django_admin_log"."action_time" DESC LIMIT 10 | client backend | |
| 16384 | sai_evo_db | 164899 | 10 | postgres | | 172.17.0.17 | | 46234 | 2022-10-20 16:26:32.366512+00 | | 2022-10-20 16:26:32.532904+00 | 2022-10-20 16:26:32.547687+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 164891 | 10 | postgres | | 172.17.0.17 | | 57688 | 2022-10-20 16:26:18.737604+00 | | 2022-10-20 16:26:18.851562+00 | 2022-10-20 16:26:18.887689+00 | Client | ClientRead | idle | | | COMMIT | client backend | |
| 16384 | sai_evo_db | 139546 | 10 | postgres | psql | 127.0.0.1 | | 41480 | 2022-10-19 20:01:00.816799+00 | | 2022-10-19 20:33:05.971088+00 | 2022-10-19 20:33:05.972439+00 | Client | ClientRead | idle | | | SELECT * FROM pg_stat_activity; | client backend | |
| 16384 | sai_evo_db | 164482 | 10 | postgres | | 172.17.0.17 | | 53530 | 2022-10-20 16:17:45.550301+00 | | 2022-10-20 16:17:45.669303+00 | 2022-10-20 16:17:45.66964+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" = 143790 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 164934 | 10 | postgres | | 172.17.0.18 | | 44072 | 2022-10-20 16:28:29.46754+00 | | 2022-10-20 16:28:29.486731+00 | 2022-10-20 16:28:29.487443+00 | Client | ClientRead | idle | | | SELECT "gamification_goal"."id", "gamification_goal"."context_id", "gamification_goal"."name" FROM "gamification_goal" WHERE "gamification_goal"."context_id" = 1 | client backend | |
| 16384 | sai_evo_db | 164881 | 10 | postgres | | 172.17.0.17 | | 41186 | 2022-10-20 16:26:14.477518+00 | | 2022-10-20 16:26:14.849345+00 | 2022-10-20 16:26:14.849356+00 | Client | ClientRead | idle | | | CLOSE "_django_curs_139946791261952_sync_3" | client backend | |
| 16384 | sai_evo_db | 164491 | 10 | postgres | | 172.17.0.17 | | 48292 | 2022-10-20 16:17:46.89015+00 | | 2022-10-20 16:17:46.979231+00 | 2022-10-20 16:17:46.979667+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164492 | 10 | postgres | | 172.17.0.17 | | 48294 | 2022-10-20 16:17:46.891911+00 | | 2022-10-20 16:17:46.957661+00 | 2022-10-20 16:17:46.958051+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164935 | 10 | postgres | | 172.17.0.17 | | 35570 | 2022-10-20 16:28:29.574465+00 | | 2022-10-20 16:28:29.607356+00 | 2022-10-20 16:28:29.608291+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 | 164909 | 10 | postgres | | 172.17.0.17 | | 33970 | 2022-10-20 16:27:11.231923+00 | | 2022-10-20 16:27:11.369511+00 | 2022-10-20 16:27:11.36964+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" = 163) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164936 | 10 | postgres | | 172.17.0.18 | | 44080 | 2022-10-20 16:28:29.657425+00 | | 2022-10-20 16:28:29.731385+00 | 2022-10-20 16:28:29.73152+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 | 164925 | 10 | postgres | | 172.17.0.18 | | 39974 | 2022-10-20 16:28:13.997921+00 | | 2022-10-20 16:28:14.16066+00 | 2022-10-20 16:28:14.160996+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" = 143333 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 164514 | 10 | postgres | | 172.17.0.17 | | 48398 | 2022-10-20 16:17:51.87536+00 | | 2022-10-20 16:17:51.949873+00 | 2022-10-20 16:17:51.950223+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164503 | 10 | postgres | | 172.17.0.17 | | 48354 | 2022-10-20 16:17:49.913642+00 | | 2022-10-20 16:17:50.010662+00 | 2022-10-20 16:17:50.011062+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164933 | 10 | postgres | | 172.17.0.17 | | 35562 | 2022-10-20 16:28:29.369516+00 | | 2022-10-20 16:28:29.474612+00 | 2022-10-20 16:28:29.50476+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, 2237, 2275, 2250, 2239, 2258, 2259, 2267, 2260 | client backend | |
| 16384 | sai_evo_db | 164506 | 10 | postgres | | 172.17.0.17 | | 48360 | 2022-10-20 16:17:49.924353+00 | | 2022-10-20 16:17:50.000847+00 | 2022-10-20 16:17:50.001254+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164505 | 10 | postgres | | 172.17.0.17 | | 48358 | 2022-10-20 16:17:49.924793+00 | | 2022-10-20 16:17:49.998336+00 | 2022-10-20 16:17:49.998705+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164515 | 10 | postgres | | 172.17.0.17 | | 48400 | 2022-10-20 16:17:51.884653+00 | | 2022-10-20 16:17:51.963384+00 | 2022-10-20 16:17:51.963772+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164516 | 10 | postgres | | 172.17.0.17 | | 48402 | 2022-10-20 16:17:51.899964+00 | | 2022-10-20 16:17:51.967346+00 | 2022-10-20 16:17:51.967701+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164557 | 10 | postgres | | 172.17.0.17 | | 48306 | 2022-10-20 16:17:58.95935+00 | | 2022-10-20 16:17:59.081372+00 | 2022-10-20 16:17:59.081509+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 770 AND "courses_exercisesolutionvote"."user_id" = 6 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 164558 | 10 | postgres | | 172.17.0.17 | | 48308 | 2022-10-20 16:17:58.971523+00 | | 2022-10-20 16:17:59.196035+00 | 2022-10-20 16:17:59.196184+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 124 AND "courses_exercisesolutionvote"."user_id" = 6 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 164564 | 10 | postgres | | 172.17.0.17 | | 48322 | 2022-10-20 16:17:59.044778+00 | | 2022-10-20 16:17:59.18+00 | 2022-10-20 16:17:59.181046+00 | Client | ClientRead | idle | | | SELECT COUNT(*) FROM (SELECT CASE WHEN "courses_exercisesolution"."state" = 2 THEN 2 WHEN "courses_exercisesolution"."state" = 1 THEN 1 ELSE 0 END AS "state_value", COALESCE(SUM(CASE WHEN "courses_exercisesolutionvote"."vote_type" = 1 THEN -1 WHEN "courses_exercisesolutionvote"."vote_type" = 0 THEN 1 ELSE 0 END), 0) AS "votes_score" FROM "courses_exercisesolution" LEFT OUTER JOIN "courses_exercisesolutionvote" ON ("courses_exercisesolution"."id" = "courses_exercisesolutionvote"."solution_id") WHERE ("courses_exercisesolution"."exercise_id" = 391 AND NOT (("courses_exercisesolution"."state" = 3 OR "courses_exercisesolution"."state" = 0) AND NOT ("courses_exercisesolution"."user_id" = 6))) GROUP BY "courses_exercisesolution"."id", CASE WHEN "courses_exercisesolution"."state" = 2 THEN 2 WHEN "courses_exercisesolution"."state" = 1 THEN 1 ELSE 0 END) subquery | client backend | |
| 16384 | sai_evo_db | 164541 | 10 | postgres | | 172.17.0.17 | | 48684 | 2022-10-20 16:17:55.484973+00 | | 2022-10-20 16:17:55.525851+00 | 2022-10-20 16:17:55.526198+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164553 | 10 | postgres | | 172.17.0.17 | | 48272 | 2022-10-20 16:17:57.797287+00 | | 2022-10-20 16:17:57.841736+00 | 2022-10-20 16:17:57.842128+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" = 8 AND "courses_usercourseprivilege"."user_id" = 6) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164565 | 10 | postgres | | 172.17.0.17 | | 48324 | 2022-10-20 16:17:59.060964+00 | | 2022-10-20 16:17:59.212778+00 | 2022-10-20 16:17:59.213743+00 | Client | ClientRead | idle | | | SELECT COUNT(*) FROM (SELECT CASE WHEN "courses_exercisesolution"."state" = 2 THEN 2 WHEN "courses_exercisesolution"."state" = 1 THEN 1 ELSE 0 END AS "state_value", COALESCE(SUM(CASE WHEN "courses_exercisesolutionvote"."vote_type" = 1 THEN -1 WHEN "courses_exercisesolutionvote"."vote_type" = 0 THEN 1 ELSE 0 END), 0) AS "votes_score" FROM "courses_exercisesolution" LEFT OUTER JOIN "courses_exercisesolutionvote" ON ("courses_exercisesolution"."id" = "courses_exercisesolutionvote"."solution_id") WHERE ("courses_exercisesolution"."exercise_id" = 390 AND NOT (("courses_exercisesolution"."state" = 3 OR "courses_exercisesolution"."state" = 0) AND NOT ("courses_exercisesolution"."user_id" = 6))) GROUP BY "courses_exercisesolution"."id", CASE WHEN "courses_exercisesolution"."state" = 2 THEN 2 WHEN "courses_exercisesolution"."state" = 1 THEN 1 ELSE 0 END) subquery | client backend | |
| 16384 | sai_evo_db | 164566 | 10 | postgres | | 172.17.0.17 | | 48326 | 2022-10-20 16:17:59.067399+00 | | 2022-10-20 16:17:59.235907+00 | 2022-10-20 16:17:59.236048+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 125 AND "courses_exercisesolutionvote"."user_id" = 6 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 164581 | 10 | postgres | | 172.17.0.17 | | 47658 | 2022-10-20 16:20:46.001119+00 | | 2022-10-20 16:20:46.120921+00 | 2022-10-20 16:20:46.121254+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" = 141878 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 164610 | 10 | postgres | | 172.17.0.17 | | 59370 | 2022-10-20 16:21:50.963827+00 | | 2022-10-20 16:21:51.094018+00 | 2022-10-20 16:21:51.094345+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" = 143817 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 164576 | 10 | postgres | | 172.17.0.17 | | 40130 | 2022-10-20 16:19:38.3199+00 | | 2022-10-20 16:19:38.436974+00 | 2022-10-20 16:19:38.437266+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" = 141878 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 164589 | 10 | postgres | | 172.17.0.17 | | 51072 | 2022-10-20 16:21:08.520027+00 | | 2022-10-20 16:21:08.56345+00 | 2022-10-20 16:21:08.563592+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"."parent_id" IN (141878) ORDER BY "courses_eventparticipationslot"."participation_id" ASC, "courses_eventparticipationslot"."parent_id" ASC, "courses_eventparticipationslot"."slot_number" ASC | client backend | |
| 16384 | sai_evo_db | 164602 | 10 | postgres | | 172.17.0.17 | | 40974 | 2022-10-20 16:21:45.722148+00 | | 2022-10-20 16:21:46.051549+00 | 2022-10-20 16:21:46.140626+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 (421, 101, 163, 214, 156, 97, 114, 123, 148, 199, 207, 208, | client backend | |
| 16384 | sai_evo_db | 164621 | 10 | postgres | | 172.17.0.17 | | 44346 | 2022-10-20 16:22:05.227639+00 | | 2022-10-20 16:22:05.293284+00 | 2022-10-20 16:22:05.294295+00 | Client | ClientRead | idle | | | SELECT COUNT(*) FROM (SELECT CASE WHEN "courses_exercisesolution"."state" = 2 THEN 2 WHEN "courses_exercisesolution"."state" = 1 THEN 1 ELSE 0 END AS "state_value", COALESCE(SUM(CASE WHEN "courses_exercisesolutionvote"."vote_type" = 1 THEN -1 WHEN "courses_exercisesolutionvote"."vote_type" = 0 THEN 1 ELSE 0 END), 0) AS "votes_score" FROM "courses_exercisesolution" LEFT OUTER JOIN "courses_exercisesolutionvote" ON ("courses_exercisesolution"."id" = "courses_exercisesolutionvote"."solution_id") WHERE ("courses_exercisesolution"."exercise_id" = 1206 AND NOT (("courses_exercisesolution"."state" = 3 OR "courses_exercisesolution"."state" = 0) AND NOT ("courses_exercisesolution"."user_id" = 282))) GROUP BY "courses_exercisesolution"."id", CASE WHEN "courses_exercisesolution"."state" = 2 THEN 2 WHEN "courses_exercisesolution"."state" = 1 THEN 1 ELSE 0 END) subquery | client backend | |
| 16384 | sai_evo_db | 164600 | 10 | postgres | | 172.17.0.17 | | 40962 | 2022-10-20 16:21:39.099132+00 | | 2022-10-20 16:21:39.22557+00 | 2022-10-20 16:21:39.225741+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" = 12328 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 164609 | 10 | postgres | | 172.17.0.17 | | 59364 | 2022-10-20 16:21:49.830325+00 | | 2022-10-20 16:21:49.862984+00 | 2022-10-20 16:21:49.866586+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, 51)) | client backend | |
| 16384 | sai_evo_db | 164622 | 10 | postgres | | 172.17.0.17 | | 44348 | 2022-10-20 16:22:05.233609+00 | | 2022-10-20 16:22:05.332494+00 | 2022-10-20 16:22:05.332626+00 | Client | ClientRead | idle | | | SELECT (1) AS "a" FROM "courses_exercisesolutionvote" WHERE ("courses_exercisesolutionvote"."solution_id" = 521 AND "courses_exercisesolutionvote"."user_id" = 282 AND "courses_exercisesolutionvote"."vote_type" = 1) LIMIT 1 | client backend | |
| 16384 | sai_evo_db | 164655 | 10 | postgres | | 172.17.0.17 | | 54978 | 2022-10-20 16:23:29.484007+00 | | 2022-10-20 16:23:29.544434+00 | 2022-10-20 16:23:29.544521+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 | 164620 | 10 | postgres | | 172.17.0.17 | | 44328 | 2022-10-20 16:22:04.951831+00 | | 2022-10-20 16:22:05.107075+00 | 2022-10-20 16:22:05.107268+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" = 12335 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 164666 | 10 | postgres | | 172.17.0.17 | | 57722 | 2022-10-20 16:23:44.366137+00 | | 2022-10-20 16:23:44.405879+00 | 2022-10-20 16:23:44.406005+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" = 8 AND "courses_usercourseprivilege"."user_id" = 1026) LIMIT 21 | client backend | |
| 16384 | sai_evo_db | 164636 | 10 | postgres | | 172.17.0.17 | | 43316 | 2022-10-20 16:22:33.890689+00 | | 2022-10-20 16:22:34.002956+00 | 2022-10-20 16:22:34.00328+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" = 143808 ORDER BY "courses_exercisechoice"."exercise_id" ASC, "courses_exercisechoice"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 164650 | 10 | postgres | | 172.17.0.17 | | 53950 | 2022-10-20 16:22:59.617816+00 | | 2022-10-20 16:22:59.75532+00 | 2022-10-20 16:22:59.755493+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" = 12320 ORDER BY "courses_eventtemplaterule"."template_id" ASC, "courses_eventtemplaterule"."_ordering" ASC | client backend | |
| 16384 | sai_evo_db | 164672 | 10 | postgres | | 172.17.0.17 | | 47356 | 2022-10-20 16:23:49.465107+00 | | 2022-10-20 16:23:49.529365+00 | 2022-10-20 16:23:49.529451+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 | 164677 | 10 | postgres | | 172.17.0.18 | | 55836 | 2022-10-20 16:23:58.314446+00 | | 2022-10-20 16:23:59.598053+00 | 2022-10-20 16:23:59.601323+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 | |
| | | 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 | |
| (123 rows) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment