"Hash Left Join (cost=2396.70..3979.19 rows=67 width=1627) (actual time=78.095..1130.079 rows=76913 loops=1)"
" Output: homework.id, homework.""createdAt"", homework.""updatedAt"", homework.slug, homework.""descriptionSvg"", homework.closed, homework.level, homework.status, homework.""ratingsCount"", homework.""ratingsAvg"", author.id, author.username, author.""firstName"", author.""lastName"", author.""displayName"", answers.id, answers.label, answers.answer, answers.""order"", ""solutionFormats"".id, ""solutionFormats"".name, ""adminReview"".comment, ""adminReview"".status, domains.id, domains.type, domains.slug, domains.name, theorems.id, theorems.type, theorems.slug, theorems.name, theorems.aliases, definitions.id, definitions.type, definitions.slug, definitions.name, definitions.aliases, tags.id, tags.type, tags.slug, tags.name, tags.aliases, ""homeworkExams"".id, ""homeworkExams"".answers, exam.id, exam.details, exam.slug, exam.date, exam.name, exam.level, exam.type, exam.variant, ""homeworkType"".id, ""homeworkType"".name, ""homeworkType"".slug, ""homeworksBookNode"".id, ""favoriteHomeworks"".id, ""favoriteHomeworks"".""createdAt"", ""favoriteHomeworks"".""order"", ""favoriteHomeworks"".description, favorite.id, favorite.name"
" Inner Unique: true"
" Hash Cond: (""favoriteHomeworks"".""favoriteId"" = favorite.id)"
" Buffers: shared hit=1188026"
" -> Nested Loop Left Join (cost=2395.49..3977.74 rows=67 width=1618) (actual time=78.020..1092.308 rows=76913 loops=1)"
" Output: homework.id, homework.""createdAt"", homework.""updatedAt"", homework.slug, homework.""descriptionSvg"", homework.closed, homework.level, homework.status, homework.""ratingsCount"", homework.""ratingsAvg"", author.id, author.username, author.""firstName"", author.""lastName"", author.""displayName"", answers.id, answers.label, answers.answer, answers.""order"", ""solutionFormats"".id, ""solutionFormats"".name, ""adminReview"".comment, ""adminReview"".status, domains.id, domains.type, domains.slug, domains.name, theorems.id, theorems.type, theorems.slug, theorems.name, theorems.aliases, definitions.id, definitions.type, definitions.slug, definitions.name, definitions.aliases, tags.id, tags.type, tags.slug, tags.name, tags.aliases, ""homeworkExams"".id, ""homeworkExams"".answers, exam.id, exam.details, exam.slug, exam.date, exam.name, exam.level, exam.type, exam.variant, ""homeworkType"".id, ""homeworkType"".name, ""homeworkType"".slug, ""homeworksBookNode"".id, ""favoriteHomeworks"".id, ""favoriteHomeworks"".""createdAt"", ""favoriteHomeworks"".""order"", ""favoriteHomeworks"".description, ""favoriteHomeworks"".""favoriteId"""
" Buffers: shared hit=1188025"
" -> Nested Loop Anti Join (cost=2395.08..3944.71 rows=67 width=1542) (actual time=77.995..813.691 rows=75981 loops=1)"
" Output: homework.id, homework.""createdAt"", homework.""updatedAt"", homework.slug, homework.""descriptionSvg"", homework.closed, homework.level, homework.status, homework.""ratingsCount"", homework.""ratingsAvg"", author.id, author.username, author.""firstName"", author.""lastName"", author.""displayName"", answers.id, answers.label, answers.answer, answers.""order"", ""solutionFormats"".id, ""solutionFormats"".name, ""adminReview"".comment, ""adminReview"".status, domains.id, domains.type, domains.slug, domains.name, theorems.id, theorems.type, theorems.slug, theorems.name, theorems.aliases, definitions.id, definitions.type, definitions.slug, definitions.name, definitions.aliases, tags.id, tags.type, tags.slug, tags.name, tags.aliases, ""homeworkExams"".id, ""homeworkExams"".answers, exam.id, exam.details, exam.slug, exam.date, exam.name, exam.level, exam.type, exam.variant, ""homeworkType"".id, ""homeworkType"".name, ""homeworkType"".slug, ""homeworksBookNode"".id"
" Buffers: shared hit=804961"
" -> Nested Loop Left Join (cost=2394.66..3892.18 rows=107 width=1542) (actual time=77.843..541.213 rows=76005 loops=1)"
" Output: homework.id, homework.""createdAt"", homework.""updatedAt"", homework.slug, homework.""descriptionSvg"", homework.closed, homework.level, homework.status, homework.""ratingsCount"", homework.""ratingsAvg"", author.id, author.username, author.""firstName"", author.""lastName"", author.""displayName"", answers.id, answers.label, answers.answer, answers.""order"", ""solutionFormats"".id, ""solutionFormats"".name, ""adminReview"".comment, ""adminReview"".status, domains.id, domains.type, domains.slug, domains.name, theorems.id, theorems.type, theorems.slug, theorems.name, theorems.aliases, definitions.id, definitions.type, definitions.slug, definitions.name, definitions.aliases, tags.id, tags.type, tags.slug, tags.name, tags.aliases, ""homeworkExams"".id, ""homeworkExams"".answers, exam.id, exam.details, exam.slug, exam.date, exam.name, exam.level, exam.type, exam.variant, ""homeworkType"".id, ""homeworkType"".name, ""homeworkType"".slug, ""homeworksBookNode"".id"
" Inner Unique: true"
" Buffers: shared hit=421753"
" -> Hash Left Join (cost=2394.39..3859.01 rows=107 width=1389) (actual time=77.778..386.667 rows=76005 loops=1)"
" Output: homework.id, homework.""createdAt"", homework.""updatedAt"", homework.slug, homework.""descriptionSvg"", homework.closed, homework.level, homework.status, homework.""ratingsCount"", homework.""ratingsAvg"", homework.""typeId"", author.id, author.username, author.""firstName"", author.""lastName"", author.""displayName"", answers.id, answers.label, answers.answer, answers.""order"", ""solutionFormats"".id, ""solutionFormats"".name, ""adminReview"".comment, ""adminReview"".status, domains.id, domains.type, domains.slug, domains.name, theorems.id, theorems.type, theorems.slug, theorems.name, theorems.aliases, definitions.id, definitions.type, definitions.slug, definitions.name, definitions.aliases, tags.id, tags.type, tags.slug, tags.name, tags.aliases, ""homeworkExams"".id, ""homeworkExams"".answers, exam.id, exam.details, exam.slug, exam.date, exam.name, exam.level, exam.type, exam.variant, ""homeworksBookNode"".id"
" Inner Unique: true"
" Hash Cond: (""homeworkExams"".""examId"" = exam.id)"
" Filter: ((exam.id IS NULL) OR (exam.id <> ALL ('{be7ee56f-1b76-46cd-ba6f-5f0a2c0194cf,05f12827-b37d-4b06-b9e7-d71f056bf114,607917f8-a025-4819-929b-9b02ea616010,9d8a496b-b3a6-4ba4-ad89-f99fab59c794,9ed193cd-6819-4d96-941d-9536454cdf12,d83a5d1d-0dcb-4be6-96cb-4b1648312daf,9bf26e8c-cb10-49cc-a6ef-fb5d5a37045a,53a566bd-a1ba-4e4e-aa5a-f7099cd8ef2a,67a56dd1-d6c1-4887-a07e-e5f6140f0171,0c8543a6-d31b-4d42-8c56-370028b900e6,b795f205-ccef-4b1a-ba4e-1bd6793d86e9,99c5d43c-f2c1-4173-891f-bc054d160dbb,46af9f90-f05e-415f-9bc6-a677968506ae,38f4415d-d6b5-43f5-bc82-aa81bfb8855d,2229a50b-ba67-4153-83d0-ce193c100947,3a77390e-788f-4d87-b0a1-f8346ed9ee51,b3bc0484-0453-4512-9754-4f1452989316,9c1f258a-b13e-4aa0-94d0-24d2c01ef2b1,bd843f24-b1f2-4726-8398-2781bed6661a,2a6b5439-0cb7-44c2-8c49-00206fe8cd0d,2cf29ba2-a232-4f9b-b3bd-8ab43feca977,b02f4efe-975b-449c-9bca-814b080774fb,547bff7a-c17f-4b64-969e-fa4867d4337a,b87af2a7-96ba-44f7-9d81-73e972de097c,f4e1158b-1056-47e8-aa05-cddea75d971c,ac5e640b-d4b8-4f21-9e76-aa14f6cec4e5,82a4c242-b682-467c-a931-e320b67d95c9,590c36f8-13f6-42b8-a170-aace19be77f8,9b9b979d-f27d-44e4-adad-9ce67bbbc63f,6d8897ff-fe26-47b8-bddb-1af4afb211ba,45b7797b-08fd-48a0-931e-c3cfa44549ef,edf0c2da-f13b-4aa7-acfd-325c650a5484,48c8ce5c-b179-4f3c-bdb4-7d62f0e6bc86,3e6c1cd4-69bf-434c-9cfd-b657b7db2237,e9ec5c41-3995-44fb-bf52-2a32d6ed14d6,e40d7a87-866d-4894-a32e-d1a08b9060ea,269c8c51-21d9-414b-b07a-d75ef6428a78,81ee0fc6-78ff-485f-94d6-d434c49110f5,eaff4fb4-e19c-4f45-af55-355ec1034857,6f0353ba-773f-4d3f-9c57-75737146f806,70729824-7631-44ae-9826-47300abaa440,7a966120-54b7-4da0-885a-d28c1f6d5216,fde864d6-db9a-49de-91bc-662e445c1e4a,3e7b9db3-0bc9-4986-88f8-ef66165fb411,632e5461-fa33-4fbd-a855-5fc0b0d6f8fd,75f1febe-6d71-4445-8104-97efd52030df}'::uuid[])))"
" Rows Removed by Filter: 64"
" Buffers: shared hit=193738"
" -> Nested Loop Left Join (cost=2377.05..3841.28 rows=141 width=1253) (actual time=77.491..339.894 rows=76069 loops=1)"
" Output: homework.id, homework.""createdAt"", homework.""updatedAt"", homework.slug, homework.""descriptionSvg"", homework.closed, homework.level, homework.status, homework.""ratingsCount"", homework.""ratingsAvg"", homework.""typeId"", author.id, author.username, author.""firstName"", author.""lastName"", author.""displayName"", answers.id, answers.label, answers.answer, answers.""order"", ""solutionFormats"".id, ""solutionFormats"".name, ""adminReview"".comment, ""adminReview"".status, domains.id, domains.type, domains.slug, domains.name, theorems.id, theorems.type, theorems.slug, theorems.name, theorems.aliases, definitions.id, definitions.type, definitions.slug, definitions.name, definitions.aliases, tags.id, tags.type, tags.slug, tags.name, tags.aliases, ""homeworkExams"".id, ""homeworkExams"".answers, ""homeworkExams"".""examId"", ""homeworksBookNode"".id"
" Buffers: shared hit=193725"
" -> Hash Left Join (cost=2376.76..3786.58 rows=141 width=891) (actual time=77.458..186.245 rows=65469 loops=1)"
" Output: homework.id, homework.""createdAt"", homework.""updatedAt"", homework.slug, homework.""descriptionSvg"", homework.closed, homework.level, homework.status, homework.""ratingsCount"", homework.""ratingsAvg"", homework.""typeId"", author.id, author.username, author.""firstName"", author.""lastName"", author.""displayName"", answers.id, answers.label, answers.answer, answers.""order"", ""solutionFormats"".id, ""solutionFormats"".name, ""adminReview"".comment, ""adminReview"".status, domains.id, domains.type, domains.slug, domains.name, theorems.id, theorems.type, theorems.slug, theorems.name, theorems.aliases, definitions.id, definitions.type, definitions.slug, definitions.name, definitions.aliases, tags.id, tags.type, tags.slug, tags.name, tags.aliases, ""homeworksBookNode"".id"
" Inner Unique: true"
" Hash Cond: (homework.id = ""homeworksBookNode"".""homeworkId"")"
" Filter: (""homeworksBookNode"".id IS NULL)"
" Buffers: shared hit=1938"
" -> Hash Left Join (cost=2376.75..3712.23 rows=28288 width=875) (actual time=77.406..160.649 rows=65469 loops=1)"
" Output: homework.id, homework.""createdAt"", homework.""updatedAt"", homework.slug, homework.""descriptionSvg"", homework.closed, homework.level, homework.status, homework.""ratingsCount"", homework.""ratingsAvg"", homework.""typeId"", author.id, author.username, author.""firstName"", author.""lastName"", author.""displayName"", answers.id, answers.label, answers.answer, answers.""order"", ""solutionFormats"".id, ""solutionFormats"".name, ""adminReview"".comment, ""adminReview"".status, domains.id, domains.type, domains.slug, domains.name, theorems.id, theorems.type, theorems.slug, theorems.name, theorems.aliases, definitions.id, definitions.type, definitions.slug, definitions.name, definitions.aliases, tags.id, tags.type, tags.slug, tags.name, tags.aliases"
" Hash Cond: (homework.id = homework_definitions.""homeworkEntityId"")"
" Buffers: shared hit=1938"
" -> Hash Left Join (cost=1823.10..2689.97 rows=10613 width=784) (actual time=61.361..116.272 rows=19573 loops=1)"
" Output: homework.id, homework.""createdAt"", homework.""updatedAt"", homework.slug, homework.""descriptionSvg"", homework.closed, homework.level, homework.status, homework.""ratingsCount"", homework.""ratingsAvg"", homework.""typeId"", author.id, author.username, author.""firstName"", author.""lastName"", author.""displayName"", answers.id, answers.label, answers.answer, answers.""order"", ""solutionFormats"".id, ""solutionFormats"".name, ""adminReview"".comment, ""adminReview"".status, domains.id, domains.type, domains.slug, domains.name, theorems.id, theorems.type, theorems.slug, theorems.name, theorems.aliases, tags.id, tags.type, tags.slug, tags.name, tags.aliases"
" Hash Cond: (homework.id = homework_theorems.""homeworkEntityId"")"
" Buffers: shared hit=1706"
" -> Hash Left Join (cost=1468.73..2075.79 rows=8196 width=693) (actual time=50.260..93.672 rows=13759 loops=1)"
" Output: homework.id, homework.""createdAt"", homework.""updatedAt"", homework.slug, homework.""descriptionSvg"", homework.closed, homework.level, homework.status, homework.""ratingsCount"", homework.""ratingsAvg"", homework.""typeId"", author.id, author.username, author.""firstName"", author.""lastName"", author.""displayName"", answers.id, answers.label, answers.answer, answers.""order"", ""solutionFormats"".id, ""solutionFormats"".name, ""adminReview"".comment, ""adminReview"".status, domains.id, domains.type, domains.slug, domains.name, tags.id, tags.type, tags.slug, tags.name, tags.aliases"
" Inner Unique: true"
" Hash Cond: (homework_domains.""mathConceptEntityId"" = domains.id)"
" Buffers: shared hit=1524"
" -> Hash Left Join (cost=1307.40..1892.89 rows=8196 width=631) (actual time=48.694..85.385 rows=13759 loops=1)"
" Output: homework.id, homework.""createdAt"", homework.""updatedAt"", homework.slug, homework.""descriptionSvg"", homework.closed, homework.level, homework.status, homework.""ratingsCount"", homework.""ratingsAvg"", homework.""typeId"", author.id, author.username, author.""firstName"", author.""lastName"", author.""displayName"", answers.id, answers.label, answers.answer, answers.""order"", ""solutionFormats"".id, ""solutionFormats"".name, ""adminReview"".comment, ""adminReview"".status, homework_domains.""mathConceptEntityId"", tags.id, tags.type, tags.slug, tags.name, tags.aliases"
" Hash Cond: (homework.id = homework_tags.""homeworkEntityId"")"
" Buffers: shared hit=1394"
" -> Hash Right Join (cost=1204.91..1688.07 rows=8196 width=540) (actual time=46.821..77.394 rows=12825 loops=1)"
" Output: homework.id, homework.""createdAt"", homework.""updatedAt"", homework.slug, homework.""descriptionSvg"", homework.closed, homework.level, homework.status, homework.""ratingsCount"", homework.""ratingsAvg"", homework.""typeId"", author.id, author.username, author.""firstName"", author.""lastName"", author.""displayName"", answers.id, answers.label, answers.answer, answers.""order"", ""solutionFormats"".id, ""solutionFormats"".name, ""adminReview"".comment, ""adminReview"".status, homework_domains.""mathConceptEntityId"""
" Hash Cond: (answers.""homeworkId"" = homework.id)"
" Buffers: shared hit=1088"
" -> Seq Scan on public.homework_answer_entity answers (cost=0.00..364.08 rows=9908 width=170) (actual time=0.060..16.557 rows=9908 loops=1)"
" Output: answers.id, answers.label, answers.answer, answers.correct, answers.""order"", answers.""homeworkId"""
" Buffers: shared hit=265"
" -> Hash (cost=1160.10..1160.10 rows=3585 width=386) (actual time=46.694..46.706 rows=4373 loops=1)"
" Output: homework.id, homework.""createdAt"", homework.""updatedAt"", homework.slug, homework.""descriptionSvg"", homework.closed, homework.level, homework.status, homework.""ratingsCount"", homework.""ratingsAvg"", homework.""typeId"", author.id, author.username, author.""firstName"", author.""lastName"", author.""displayName"", ""solutionFormats"".id, ""solutionFormats"".name, ""adminReview"".comment, ""adminReview"".status, homework_domains.""mathConceptEntityId"""
" Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 1644kB"
" Buffers: shared hit=823"
" -> Hash Left Join (cost=987.09..1160.10 rows=3585 width=386) (actual time=26.568..35.672 rows=4373 loops=1)"
" Output: homework.id, homework.""createdAt"", homework.""updatedAt"", homework.slug, homework.""descriptionSvg"", homework.closed, homework.level, homework.status, homework.""ratingsCount"", homework.""ratingsAvg"", homework.""typeId"", author.id, author.username, author.""firstName"", author.""lastName"", author.""displayName"", ""solutionFormats"".id, ""solutionFormats"".name, ""adminReview"".comment, ""adminReview"".status, homework_domains.""mathConceptEntityId"""
" Inner Unique: true"
" Hash Cond: (homework.id = ""adminReview"".""homeworkId"")"
" Buffers: shared hit=823"
" -> Hash Join (cost=987.08..1150.67 rows=3585 width=322) (actual time=26.465..34.447 rows=4373 loops=1)"
" Output: homework.id, homework.""createdAt"", homework.""updatedAt"", homework.slug, homework.""descriptionSvg"", homework.closed, homework.level, homework.status, homework.""ratingsCount"", homework.""ratingsAvg"", homework.""typeId"", author.id, author.username, author.""firstName"", author.""lastName"", author.""displayName"", ""solutionFormats"".id, ""solutionFormats"".name, homework_domains.""mathConceptEntityId"""
" Inner Unique: true"
" Hash Cond: (""homework_solutionFormats"".""solutionFormatEntityId"" = ""solutionFormats"".id)"
" Buffers: shared hit=823"
" -> Hash Left Join (cost=986.01..1126.89 rows=3585 width=318) (actual time=26.313..32.811 rows=4373 loops=1)"
" Output: homework.id, homework.""createdAt"", homework.""updatedAt"", homework.slug, homework.""descriptionSvg"", homework.closed, homework.level, homework.status, homework.""ratingsCount"", homework.""ratingsAvg"", homework.""typeId"", author.id, author.username, author.""firstName"", author.""lastName"", author.""displayName"", ""homework_solutionFormats"".""solutionFormatEntityId"", homework_domains.""mathConceptEntityId"""
" Inner Unique: true"
" Hash Cond: (homework.""authorId"" = author.id)"
" Buffers: shared hit=822"
" -> Hash Right Join (cost=980.29..1110.52 rows=3585 width=284) (actual time=26.177..31.092 rows=4373 loops=1)"
" Output: homework.id, homework.""createdAt"", homework.""updatedAt"", homework.slug, homework.""descriptionSvg"", homework.closed, homework.level, homework.status, homework.""ratingsCount"", homework.""ratingsAvg"", homework.""authorId"", homework.""typeId"", ""homework_solutionFormats"".""solutionFormatEntityId"", homework_domains.""mathConceptEntityId"""
" Hash Cond: (homework_domains.""homeworkEntityId"" = homework.id)"
" Buffers: shared hit=817"
" -> Seq Scan on public.homework_entity_domains_math_concept_entity homework_domains (cost=0.00..78.24 rows=4324 width=32) (actual time=0.021..1.457 rows=4324 loops=1)"
" Output: homework_domains.""homeworkEntityId"", homework_domains.""mathConceptEntityId"""
" Buffers: shared hit=35"
" -> Hash (cost=935.48..935.48 rows=3585 width=268) (actual time=26.083..26.086 rows=3633 loops=1)"
" Output: homework.id, homework.""createdAt"", homework.""updatedAt"", homework.slug, homework.""descriptionSvg"", homework.closed, homework.level, homework.status, homework.""ratingsCount"", homework.""ratingsAvg"", homework.""authorId"", homework.""typeId"", ""homework_solutionFormats"".""solutionFormatEntityId"""
" Buckets: 4096 Batches: 1 Memory Usage: 1103kB"
" Buffers: shared hit=782"
" -> Hash Join (cost=860.39..935.48 rows=3585 width=268) (actual time=13.875..17.515 rows=3633 loops=1)"
" Output: homework.id, homework.""createdAt"", homework.""updatedAt"", homework.slug, homework.""descriptionSvg"", homework.closed, homework.level, homework.status, homework.""ratingsCount"", homework.""ratingsAvg"", homework.""authorId"", homework.""typeId"", ""homework_solutionFormats"".""solutionFormatEntityId"""
" Inner Unique: true"
" Hash Cond: (""homework_solutionFormats"".""homeworkEntityId"" = homework.id)"
" Buffers: shared hit=782"
" -> Seq Scan on public.homework_entity_solution_formats_solution_format_entity ""homework_solutionFormats"" (cost=0.00..65.50 rows=3650 width=32) (actual time=0.053..0.679 rows=3650 loops=1)"
" Output: ""homework_solutionFormats"".""homeworkEntityId"", ""homework_solutionFormats"".""solutionFormatEntityId"""
" Buffers: shared hit=29"
" -> Hash (cost=807.17..807.17 rows=4257 width=252) (actual time=13.544..13.545 rows=4257 loops=1)"
" Output: homework.id, homework.""createdAt"", homework.""updatedAt"", homework.slug, homework.""descriptionSvg"", homework.closed, homework.level, homework.status, homework.""ratingsCount"", homework.""ratingsAvg"", homework.""authorId"", homework.""typeId"""
" Buckets: 8192 Batches: 1 Memory Usage: 1247kB"
" Buffers: shared hit=753"
" -> Seq Scan on public.homework_entity homework (cost=0.00..807.17 rows=4257 width=252) (actual time=0.069..4.212 rows=4257 loops=1)"
" Output: homework.id, homework.""createdAt"", homework.""updatedAt"", homework.slug, homework.""descriptionSvg"", homework.closed, homework.level, homework.status, homework.""ratingsCount"", homework.""ratingsAvg"", homework.""authorId"", homework.""typeId"""
" Filter: ((homework.""deletedAt"" IS NULL) AND (homework.status = 'Publiczne'::homework_entity_status_enum))"
" Rows Removed by Filter: 77"
" Buffers: shared hit=753"
" -> Hash (cost=5.32..5.32 rows=32 width=66) (actual time=0.084..0.086 rows=32 loops=1)"
" Output: author.id, author.username, author.""firstName"", author.""lastName"", author.""displayName"", author.""avatarId"""
" Buckets: 1024 Batches: 1 Memory Usage: 11kB"
" Buffers: shared hit=5"
" -> Seq Scan on public.user_entity author (cost=0.00..5.32 rows=32 width=66) (actual time=0.015..0.045 rows=32 loops=1)"
" Output: author.id, author.username, author.""firstName"", author.""lastName"", author.""displayName"", author.""avatarId"""
" Filter: (author.""deletedAt"" IS NULL)"
" Buffers: shared hit=5"
" -> Hash (cost=1.03..1.03 rows=3 width=20) (actual time=0.037..0.038 rows=3 loops=1)"
" Output: ""solutionFormats"".id, ""solutionFormats"".name"
" Buckets: 1024 Batches: 1 Memory Usage: 9kB"
" Buffers: shared hit=1"
" -> Seq Scan on public.solution_format_entity ""solutionFormats"" (cost=0.00..1.03 rows=3 width=20) (actual time=0.021..0.022 rows=3 loops=1)"
" Output: ""solutionFormats"".id, ""solutionFormats"".name"
" Buffers: shared hit=1"
" -> Hash (cost=0.00..0.00 rows=1 width=80) (actual time=0.063..0.064 rows=0 loops=1)"
" Output: ""adminReview"".comment, ""adminReview"".status, ""adminReview"".""homeworkId"""
" Buckets: 1024 Batches: 1 Memory Usage: 8kB"
" -> Seq Scan on public.homework_admin_review_entity ""adminReview"" (cost=0.00..0.00 rows=1 width=80) (actual time=0.063..0.063 rows=0 loops=1)"
" Output: ""adminReview"".comment, ""adminReview"".status, ""adminReview"".""homeworkId"""
" Filter: (""adminReview"".""deletedAt"" IS NULL)"
" -> Hash (cost=89.03..89.03 rows=1077 width=107) (actual time=1.801..1.803 rows=1077 loops=1)"
" Output: homework_tags.""homeworkEntityId"", tags.id, tags.type, tags.slug, tags.name, tags.aliases"
" Buckets: 2048 Batches: 1 Memory Usage: 160kB"
" Buffers: shared hit=306"
" -> Nested Loop Left Join (cost=0.29..89.03 rows=1077 width=107) (actual time=0.095..1.032 rows=1077 loops=1)"
" Output: homework_tags.""homeworkEntityId"", tags.id, tags.type, tags.slug, tags.name, tags.aliases"
" Inner Unique: true"
" Buffers: shared hit=306"
" -> Seq Scan on public.homework_entity_tags_math_concept_entity homework_tags (cost=0.00..19.77 rows=1077 width=32) (actual time=0.027..0.129 rows=1077 loops=1)"
" Output: homework_tags.""homeworkEntityId"", homework_tags.""mathConceptEntityId"""
" Buffers: shared hit=9"
" -> Memoize (cost=0.29..0.43 rows=1 width=91) (actual time=0.001..0.001 rows=1 loops=1077)"
" Output: tags.id, tags.type, tags.slug, tags.name, tags.aliases"
" Cache Key: homework_tags.""mathConceptEntityId"""
" Cache Mode: logical"
" Hits: 978 Misses: 99 Evictions: 0 Overflows: 0 Memory Usage: 21kB"
" Buffers: shared hit=297"
" -> Index Scan using ""PK_824d4a39ab8c53d3bd1e3581f98"" on public.math_concept_entity tags (cost=0.28..0.42 rows=1 width=91) (actual time=0.003..0.003 rows=1 loops=99)"
" Output: tags.id, tags.type, tags.slug, tags.name, tags.aliases"
" Index Cond: (tags.id = homework_tags.""mathConceptEntityId"")"
" Filter: (tags.""deletedAt"" IS NULL)"
" Rows Removed by Filter: 0"
" Buffers: shared hit=297"
" -> Hash (cost=144.06..144.06 rows=1381 width=78) (actual time=1.503..1.504 rows=1381 loops=1)"
" Output: domains.id, domains.type, domains.slug, domains.name"
" Buckets: 2048 Batches: 1 Memory Usage: 167kB"
" Buffers: shared hit=130"
" -> Seq Scan on public.math_concept_entity domains (cost=0.00..144.06 rows=1381 width=78) (actual time=0.030..0.539 rows=1381 loops=1)"
" Output: domains.id, domains.type, domains.slug, domains.name"
" Filter: (domains.""deletedAt"" IS NULL)"
" Rows Removed by Filter: 25"
" Buffers: shared hit=130"
" -> Hash (cost=284.22..284.22 rows=5612 width=107) (actual time=10.916..10.918 rows=5612 loops=1)"
" Output: homework_theorems.""homeworkEntityId"", theorems.id, theorems.type, theorems.slug, theorems.name, theorems.aliases"
" Buckets: 8192 Batches: 1 Memory Usage: 955kB"
" Buffers: shared hit=182"
" -> Hash Left Join (cost=161.32..284.22 rows=5612 width=107) (actual time=1.547..5.033 rows=5612 loops=1)"
" Output: homework_theorems.""homeworkEntityId"", theorems.id, theorems.type, theorems.slug, theorems.name, theorems.aliases"
" Inner Unique: true"
" Hash Cond: (homework_theorems.""mathConceptEntityId"" = theorems.id)"
" Buffers: shared hit=182"
" -> Seq Scan on public.homework_entity_theorems_math_concept_entity homework_theorems (cost=0.00..108.12 rows=5612 width=32) (actual time=0.010..1.623 rows=5612 loops=1)"
" Output: homework_theorems.""homeworkEntityId"", homework_theorems.""mathConceptEntityId"""
" Buffers: shared hit=52"
" -> Hash (cost=144.06..144.06 rows=1381 width=91) (actual time=1.477..1.477 rows=1381 loops=1)"
" Output: theorems.id, theorems.type, theorems.slug, theorems.name, theorems.aliases"
" Buckets: 2048 Batches: 1 Memory Usage: 178kB"
" Buffers: shared hit=130"
" -> Seq Scan on public.math_concept_entity theorems (cost=0.00..144.06 rows=1381 width=91) (actual time=0.016..0.479 rows=1381 loops=1)"
" Output: theorems.id, theorems.type, theorems.slug, theorems.name, theorems.aliases"
" Filter: (theorems.""deletedAt"" IS NULL)"
" Rows Removed by Filter: 25"
" Buffers: shared hit=130"
" -> Hash (cost=409.26..409.26 rows=11552 width=107) (actual time=15.636..15.638 rows=11552 loops=1)"
" Output: homework_definitions.""homeworkEntityId"", definitions.id, definitions.type, definitions.slug, definitions.name, definitions.aliases"
" Buckets: 16384 Batches: 1 Memory Usage: 1401kB"
" Buffers: shared hit=232"
" -> Hash Left Join (cost=161.32..409.26 rows=11552 width=107) (actual time=2.366..7.273 rows=11552 loops=1)"
" Output: homework_definitions.""homeworkEntityId"", definitions.id, definitions.type, definitions.slug, definitions.name, definitions.aliases"
" Inner Unique: true"
" Hash Cond: (homework_definitions.""mathConceptEntityId"" = definitions.id)"
" Buffers: shared hit=232"
" -> Seq Scan on public.homework_entity_definitions_math_concept_entity homework_definitions (cost=0.00..217.52 rows=11552 width=32) (actual time=0.022..1.260 rows=11552 loops=1)"
" Output: homework_definitions.""homeworkEntityId"", homework_definitions.""mathConceptEntityId"""
" Buffers: shared hit=102"
" -> Hash (cost=144.06..144.06 rows=1381 width=91) (actual time=2.265..2.266 rows=1381 loops=1)"
" Output: definitions.id, definitions.type, definitions.slug, definitions.name, definitions.aliases"
" Buckets: 2048 Batches: 1 Memory Usage: 178kB"
" Buffers: shared hit=130"
" -> Seq Scan on public.math_concept_entity definitions (cost=0.00..144.06 rows=1381 width=91) (actual time=0.028..0.787 rows=1381 loops=1)"
" Output: definitions.id, definitions.type, definitions.slug, definitions.name, definitions.aliases"
" Filter: (definitions.""deletedAt"" IS NULL)"
" Rows Removed by Filter: 25"
" Buffers: shared hit=130"
" -> Hash (cost=0.00..0.00 rows=1 width=48) (actual time=0.015..0.015 rows=0 loops=1)"
" Output: ""homeworksBookNode"".id, ""homeworksBookNode"".""homeworkId"", ""homeworksBookNode"".""targetId"""
" Buckets: 1024 Batches: 1 Memory Usage: 8kB"
" -> Seq Scan on public.homeworks_book_node_entity ""homeworksBookNode"" (cost=0.00..0.00 rows=1 width=48) (actual time=0.014..0.014 rows=0 loops=1)"
" Output: ""homeworksBookNode"".id, ""homeworksBookNode"".""homeworkId"", ""homeworksBookNode"".""targetId"""
" Filter: (""homeworksBookNode"".""deletedAt"" IS NULL)"
" -> Index Scan using ""IDX_9926858842c73a53888afb8e53"" on public.homework_exam_entity ""homeworkExams"" (cost=0.28..0.38 rows=1 width=378) (actual time=0.001..0.002 rows=1 loops=65469)"
" Output: ""homeworkExams"".id, ""homeworkExams"".answers, ""homeworkExams"".""homeworkId"", ""homeworkExams"".""examId"""
" Index Cond: (""homeworkExams"".""homeworkId"" = homework.id)"
" Filter: (""homeworkExams"".""deletedAt"" IS NULL)"
" Buffers: shared hit=191787"
" -> Hash (cost=14.88..14.88 rows=188 width=152) (actual time=0.247..0.248 rows=188 loops=1)"
" Output: exam.id, exam.details, exam.slug, exam.date, exam.name, exam.level, exam.type, exam.variant"
" Buckets: 1024 Batches: 1 Memory Usage: 32kB"
" Buffers: shared hit=13"
" -> Seq Scan on public.exam_entity exam (cost=0.00..14.88 rows=188 width=152) (actual time=0.021..0.105 rows=188 loops=1)"
" Output: exam.id, exam.details, exam.slug, exam.date, exam.name, exam.level, exam.type, exam.variant"
" Filter: (exam.""deletedAt"" IS NULL)"
" Buffers: shared hit=13"
" -> Index Scan using ""PK_a8e6d95e7ef98343a34531b651d"" on public.homework_type_entity ""homeworkType"" (cost=0.27..0.31 rows=1 width=169) (actual time=0.001..0.001 rows=1 loops=76005)"
" Output: ""homeworkType"".id, ""homeworkType"".name, ""homeworkType"".slug"
" Index Cond: (""homeworkType"".id = homework.""typeId"")"
" Filter: (""homeworkType"".""deletedAt"" IS NULL)"
" Buffers: shared hit=228015"
" -> Nested Loop (cost=0.42..0.48 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=76005)"
" Output: fh.""homeworkId"""
" Inner Unique: true"
" Buffers: shared hit=383208"
" -> Index Scan using ""IDX_favorite_homework_homework_deleted"" on public.favorite_homework_entity fh (cost=0.28..0.32 rows=1 width=32) (actual time=0.001..0.002 rows=1 loops=76005)"
" Output: fh.""favoriteId"", fh.""homeworkId"""
" Index Cond: (fh.""homeworkId"" = homework.id)"
" Buffers: shared hit=229068"
" -> Index Scan using ""PK_05ae9b9abba1cbe21e1cfc879f7"" on public.favorite_entity f (cost=0.14..0.16 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=77070)"
" Output: f.id, f.""createdAt"", f.""updatedAt"", f.""deletedAt"", f.name, f.description, f.""userId"""
" Index Cond: (f.id = fh.""favoriteId"")"
" Filter: ((f.""deletedAt"" IS NULL) AND ((f.name)::text = 'Ukryte'::text))"
" Rows Removed by Filter: 1"
" Buffers: shared hit=154140"
" -> Nested Loop (cost=0.42..0.48 rows=1 width=92) (actual time=0.003..0.003 rows=1 loops=75981)"
" Output: ""favoriteHomeworks"".id, ""favoriteHomeworks"".""createdAt"", ""favoriteHomeworks"".""order"", ""favoriteHomeworks"".description, ""favoriteHomeworks"".""favoriteId"", ""favoriteHomeworks"".""homeworkId"""
" Inner Unique: true"
" Buffers: shared hit=383064"
" -> Index Scan using ""IDX_favorite_homework_homework_deleted"" on public.favorite_homework_entity ""favoriteHomeworks"" (cost=0.28..0.32 rows=1 width=92) (actual time=0.001..0.002 rows=1 loops=75981)"
" Output: ""favoriteHomeworks"".id, ""favoriteHomeworks"".""createdAt"", ""favoriteHomeworks"".""order"", ""favoriteHomeworks"".description, ""favoriteHomeworks"".""favoriteId"", ""favoriteHomeworks"".""homeworkId"""
" Index Cond: (""favoriteHomeworks"".""homeworkId"" = homework.id)"
" Buffers: shared hit=228996"
" -> Index Scan using ""PK_05ae9b9abba1cbe21e1cfc879f7"" on public.favorite_entity f_1 (cost=0.14..0.16 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=77034)"
" Output: f_1.id, f_1.""createdAt"", f_1.""updatedAt"", f_1.""deletedAt"", f_1.name, f_1.description, f_1.""userId"""
" Index Cond: (f_1.id = ""favoriteHomeworks"".""favoriteId"")"
" Filter: ((f_1.""deletedAt"" IS NULL) AND (f_1.""deletedAt"" IS NULL) AND (f_1.""userId"" = '45630d49-2a87-415b-b9da-800a788e3a4a'::uuid))"
" Rows Removed by Filter: 0"
" Buffers: shared hit=154068"
" -> Hash (cost=1.09..1.09 rows=9 width=25) (actual time=0.018..0.019 rows=9 loops=1)"
" Output: favorite.id, favorite.name"
" Buckets: 1024 Batches: 1 Memory Usage: 9kB"
" Buffers: shared hit=1"
" -> Seq Scan on public.favorite_entity favorite (cost=0.00..1.09 rows=9 width=25) (actual time=0.007..0.009 rows=9 loops=1)"
" Output: favorite.id, favorite.name"
" Filter: (favorite.""deletedAt"" IS NULL)"
" Buffers: shared hit=1"
"Settings: effective_cache_size = '571MB', effective_io_concurrency = '2', random_page_cost = '1', work_mem = '2MB'"
"Query Identifier: 1870089502033369906"
"Planning:"
" Buffers: shared hit=218"
"Planning Time: 17.998 ms"
"Execution Time: 1142.437 ms"