explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OfP7

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 7,860.402 ↑ 1.0 10 1

Limit (cost=305,863.67..305,863.69 rows=10 width=952) (actual time=7,860.390..7,860.402 rows=10 loops=1)

2. 117.878 7,860.392 ↑ 522.3 10 1

Sort (cost=305,863.67..305,876.72 rows=5,223 width=952) (actual time=7,860.389..7,860.392 rows=10 loops=1)

  • Sort Key: gh.game_date DESC
  • Sort Method: top-N heapsort Memory: 29kB
3. 206.743 7,742.514 ↓ 31.6 165,090 1

Hash Join (cost=265,775.90..305,750.80 rows=5,223 width=952) (actual time=5,922.006..7,742.514 rows=165,090 loops=1)

  • Hash Cond: (p.agent_id = "*VALUES*_1".column1)
4. 52.401 7,535.662 ↓ 43.9 165,090 1

Hash Semi Join (cost=265,768.95..305,407.11 rows=3,757 width=832) (actual time=5,921.880..7,535.662 rows=165,090 loops=1)

  • Hash Cond: (p.agent_id = (unnest('{a56e3ec8-6ed9-da6a-804f-0ebc9f5b593f,167f6d0d-6725-4b54-a896-d5d1e33e64fa,2d8c665c-8e02-4408-b07c-c58bd44df76a,1f9dd7e7-c0be-4f19-b825-53d862f1df25,66f969b8-bbc5-4a87-af99-7a3674c3ca17,9e9e7700-4a7c-4214-b995-d21f06eb31f7,88057eaa-ce6d-4fcb-a748-d55a1a7c9252,ad1b0ce9-0071-437d-a4d5-9898ac66917f,0208b99f-e75a-4355-a01c-7e8bcbff4eda,e91df962-d77b-42a7-b472-8302a8c5e90d,8627ee19-7b1a-4ebf-a34a-92590764121c,82076f25-be2c-4543-84be-7a5fd4c41a37,0fe9d953-a046-40d1-ae17-1d5108f9620d,0274f032-efca-4bbc-a721-2647387190e8,d8ad4f29-a644-49f8-b7a4-dee2cd64a080,139b14de-d01c-43d8-aa8b-f412eeed05fe,84b67b3e-d12b-4163-a5bf-59f6e3b06f04,82a56ca1-3339-4933-8c17-5dc20e784b43,6342f257-4fbc-42d5-a367-d3b96897529e,3e34df47-684d-4dfb-aafd-68cda403e7a2,72a7c586-6407-45a9-9709-02bc2570339e,4c7b7f63-db51-4327-b6fe-532922baa922,6432d056-4102-4e08-bda0-5feffb4c781f,58738e61-790f-4a98-8f18-5f5746d1bd3b,a7edb6a5-2682-444a-a6c3-702579a3f0b6,46c0fd13-2efe-4bb1-8b7b-5e156ec15fd0,5272d238-ad82-4b0c-a71d-fc543f4c2e1d,e60e2b89-46dd-48ec-a17f-5c465f85cb4a,de4a604c-48ce-4493-b37f-e3dff8b75bf9,7ff45572-a67e-44fb-8ac5-c110150ca740,f7f5f80d-c0ac-490c-95ba-3a2201f9db5b,883f413f-3c2d-4123-a692-cf643b0ad73f,2792356a-f0fb-4147-a63f-5317b16d2cd2,77cd807e-73b7-4011-8818-b6c137a2fb5b,384d5dd8-aa11-4488-a649-95e997631abe,d0d61c4c-78ff-4c78-beb2-8bcd42bb5481,3bc71e22-0017-4a90-ae3c-be22f1519c2c,68ade134-9f15-4018-8ead-e70868bd084b,c411dfa0-1660-42ba-81ba-8f3018999613,1a5da013-7427-45c4-b95d-42ca75d0f590,092d02a7-a565-47be-ab98-c3553f4e708b,332c478d-41db-485c-a1b7-6218ada9ce59,817c9c62-10a4-4b2c-9cee-8e3ea6b6e488,67d7bdbc-b441-45dd-ab5a-af9a5e468c0c,f7c29c67-a05c-45ab-96af-1e4388b0d5e8,5ec31dbd-9d6a-4acd-b19f-8f3f0b224ca9,2c4a1099-7704-4475-8bce-e50507fdf512,d75e9f12-35e8-4bd8-8d5d-682be787ed4e,61830d43-0840-4f01-ac47-8b8bad10e8c9,688c3ec7-278f-4d97-9c4f-e97b428aa0d8,b41b042c-c0a5-4b54-89c5-8b9f1a479f57,032d64ac-3ed7-434a-807b-4cf601eee4e0,52b2d9bf-df4e-47b2-bc15-b720f658f799,5b002f0d-5924-41c3-bbaf-d9df41b5518d,f6f7f601-62a4-4d7b-8b39-dca025c9cb25,0693b6cf-a42b-4162-b3fc-f451156bb012,c411285e-e06b-40f9-b2a5-572f7fe2b820,a22c53ed-25de-4f9b-8c7a-11343529a636,d94afc12-5081-4506-b97e-c1b7bd450deb,6e8db755-1a8d-4715-acd7-d0fa1915a1bb,41b2ccae-b070-4e43-8d64-f92f3735b814,8d7d9f8c-46f9-4e2d-a7eb-b6e21e633fc6,58945003-6b4f-46c3-9f2f-db8f6cc8699a,4d5c9731-6eda-44c2-a445-63fa66267d04,61cddcd7-f302-456d-b637-e0991535cc90,49e72e78-ed1f-42a2-bf84-242fabf74b9a,82a74ee6-070a-4bfe-9fe2-1a7e36164608,80470f53-df98-41a5-be51-f75dc221a29c,0cf5d507-4913-407e-be6e-d410667e5bc0,cf0f6134-5ecd-4b5c-8a44-23df8a681b26,24b1b991-e099-477d-9edc-f40404a7007c,fc1d9c9b-d0a0-4edf-b70b-501a16049947,cdf34746-8aa4-43df-a5a2-7c33b630b6f0,3eccfe44-d9a9-4aec-8477-23c6c06944e9,ff837249-659f-4597-9482-76cff90acfbc,0e298960-3643-4f24-ba16-0be251b3f974,112e655e-b67f-4450-96d7-0e5ad7f160ea,a076321d-736a-4d1d-9247-0cf6b73dc1b4,956155a7-c9de-4b20-8b7b-a9d8f3097478,c9cab318-bb7b-48aa-87a9-fd6acc6cafb4,77c7985a-c1ab-4a81-8ed3-38f0bbc4933b,d1709d7a-bbd2-487c-af11-81914601bcfb,cd62a48b-06fb-40f4-a187-50b2b7e033b2,05a1978b-6632-4fbe-b842-b4fb8428e046,ab845aea-b534-4833-82b5-3fdedf6e34f3,d0f7999e-4bba-490f-86e4-e30979eb1cc2,fbb50de1-fe98-4dda-93fa-887d9937e706,5ae58b39-ead1-415f-9a0c-73ef31a96509,db81d8a0-8aa4-4d9f-9286-a66afba09a45,1bdb5524-19f8-41e8-809e-c796279322a9,70b4883a-e4b2-4d6f-aa70-a72785d2cfd1,dd6ee38c-8bc8-478a-ab3d-63c0d227b528,8bde614f-dba4-4309-87a7-9c512e8ec20c,dad547be-78ff-4217-89b3-95cc3d832338,7dec3385-ce91-447f-99d5-6711be390b37,f39e3e84-8969-45ef-aa3a-e3014a2ea466,c556d398-047b-4c89-829b-14c1b45d5df4,71e057f1-47f8-4cd5-a1af-0479cdff0225,cd9a4d2e-2176-44b9-96e4-ed3e458f3641,5dff400a-075e-413f-a90d-61ddd8a724fa,18dfa152-3843-4da6-85d3-08582c1e6202,99f0a755-bf15-44b8-a541-eb83b33c1f34,420ff8d3-9af3-485f-96d9-9a2318d34b68,50f10098-d1da-45aa-9b55-ff2a97338af6,3fd862d3-e7f3-42ec-a9d0-7bf7d52e9672,f70ad3f1-3506-4a55-a3c4-6dfd96c79544,dc9b41a8-1323-4029-82ad-30eb384aa153,129c5c52-0c42-40b8-b9b5-42f9d80dce98,85ef8114-f891-4ad9-b8c8-0590317ac321,9d48045a-1b1c-4676-8299-3d70e83ba55a,da470098-f8fe-4ecb-bddd-3663b0e6b660,b911d1c6-8515-45a5-b2ca-b051da7104b1,2c7ab751-14dd-4c22-96bc-52505dee43d2,17bc2126-2229-47c3-84ce-4b7e311b6f31,ec8d4b62-b80b-43ac-a7ea-f7eb5df3405e,d1efe0be-77b6-4674-b78d-7a8da620fa38,dbe2d667-fb9f-407c-b4ee-aec0f89e19b4,ba13eea2-b48c-40d4-8f07-fa7b80d67000,b3594081-1f80-4a4f-9997-2fbf5403a1cb,cb18e643-3324-4d7b-936c-879ab111a98e,d1a0b306-1597-4764-aa18-17be28466dc0,981a283c-454e-4bbe-9cc4-255052d3dcd3,cf9ae38b-dbd9-4d1c-89a2-3729b30d549a,2974bb62-2254-4f85-aad2-c902df394ed9,3bf91340-c2d9-4741-96b1-1b937243c846,26a31f9e-164d-4a83-9def-f27bc45d9bff,a19f3ef1-9930-4a5d-8a67-3e59f35d17eb,a5102393-1b83-4362-a545-b9d3272a66ea,1a9f4810-20d8-46ae-b3a7-73bd5ee06a3c,b2c665ed-f1f3-47c9-950d-d98f737fc59d,faf60230-878d-43bd-a8a0-c2e3e59f9ef4,b32cdd32-1433-4b71-80d8-9fe027ce2255,0ece075e-275d-42fd-9b27-28aa5928ccab,fcb659fb-2801-47c9-bb43-1912f1d01b14,ba187a26-ddea-41dd-b7be-d8c729dd0923,af37ca4c-08d6-4af0-928f-b87c817023aa,cd828459-be35-4624-87a4-4b888b14b2ac,2dc7ec8e-6808-474b-b7f5-9489df042ad9,47824bfb-790e-4c0b-8e67-cf9b2fb233ac,82c31302-3d44-48b3-8bf0-d3aa796bb738,31b021b3-2155-468e-a38d-2b682d279f0c,85c6215c-f20b-4dba-9f1e-b484c9bccf16,b33cc6a9-cf06-480a-9947-598454d23b2d,615fe769-9962-4c8a-af7c-b4e333a6086a,0221831d-4b32-4f34-a184-a17f1f9d2206,39f6404e-c745-4fd2-900d-c402c20d070e,4fd78cb2-5ac2-4285-b7cb-28227bb85e69,95aca226-d01b-4ac0-b4e8-88b81de8926a,c6a16709-5c16-4e73-9491-8be7b19773e3,15c7acd7-949a-4be0-b3c3-813780ab81da,c25e19f2-d66d-44cb-b594-f51a47fca021,064513f9-f62b-41f1-8634-5778f38ff7cc,5163acdb-fc92-43af-a11b-cd5fb12be15e,32707825-8143-478c-9c17-d4dfd29f33ba,2f4e6847-5827-4889-8741-1219ea4cde47,aa73ad16-1055-4014-885f-07c7649f7bd4,a92b50ce-32d7-426b-959f-bc9e8805a258,78ff419b-d26a-4a16-b784-21501dcf6a1c,34f6f334-ab9a-4dc6-b027-178347e6da8e,10a58c6b-cef3-4e77-9ecb-b666deae089d,525415f8-7968-48da-a48e-d29189574665,ab88647f-a9df-48c5-8799-89d2b5519b7f,3b175854-4202-48be-8edb-0d2fd5439b76,4795a366-c223-4491-b1d4-cf2338bce7ae,59305a56-9325-4ee6-ab1e-b1ea79bc8787,d305e834-5516-48d5-a76d-7d6c938ed031,6dcade5d-5e9b-47d9-9a1d-9d944e4cf287,6fd3922e-22ae-4cc4-8eae-bc8673e7c153,7890d9cb-447f-4f19-9318-5c326a931539,2083baea-d6ab-479d-a946-f5c9b5af002e,55a0737a-4122-4870-8e5d-2de421375969,87a4431d-c07d-40f7-a720-e62239875484,0405163b-94de-4b89-a6ed-46b1a562b404,d962c0f6-0614-49e9-a996-3adb22ff534d,59646186-ac7c-4425-bc5b-687107dfea8f,90bc90ed-9760-4655-982d-390cdf453d72,f899579c-ced7-420d-95b1-153642d488f4,2c62eda1-361a-4721-94e9-4b27e5475c98,1af33dcd-8668-401f-85b5-20ef7032b04e,f1879ceb-cefc-4cbf-ac8d-8668731f9cc9,bc796d83-d559-4360-9c7e-d67c24db8442,d3689009-aee3-4499-a69b-70ebe9d8ec4f,db575df2-0ab5-491c-a1a6-feb0890dfef7,cbb65f4f-91c3-4ef2-98d2-7f4ab4b62e08,426b4a2f-a603-4e05-8fee-3e8fa97a4262,1e1d934e-e371-43cb-909a-f8db48cfd724,2f4b99e9-31c8-4f6b-bbaa-b062cac037b2,675f20db-cc60-48b4-a1e5-48140286eb40,2abdc381-3401-4fea-8a00-2d7858ae30d2,415ed732-4c2a-4c63-b35a-815a2f29a484,529c9f81-f057-4c5b-8048-ad26da4fa1be,22721f6e-c1e0-4939-bb81-ff2aad6bf737,2f59773e-7d89-4a77-98cb-41ef67f0c5a0,c4a5b52c-3e9d-40a9-b278-bf3c398d4757,78def06f-75f1-425e-bdaf-443ae7763412,7a8b4534-cf45-4956-842d-9e8b8a14f8c5,3ef413b4-2073-4934-a962-aedd0bbd56dc,e4c5b88a-73fc-4c4a-8401-90a7665ccb09,962b8394-3c91-4ec7-bff0-3b64001744ae,3a775997-e470-48cb-84a8-8f2318db91d6,dcd325d0-feb9-4664-bb1b-0c5b9f2bc996,376007fa-c119-4e65-8bd0-da25fc0701cc,22fa4bd6-c2d4-48c5-9be5-a8e507f17f50,e63b7868-acab-4400-8f43-828c6ef9c8ab,05d08950-05a6-49e7-832f-943a7845ba67,f560f153-479f-468e-854c-deb25a4aa635,281c8007-d15e-4975-be1f-5d1419f1c76d,50a31441-7c0c-44d3-98a3-9bc482ece041,5d538c57-33fe-49d6-8fcb-21b7650b8671,411aea94-1a6a-4014-8f23-adeec2863c7b,59bdf899-1a44-4374-9a0c-6e01630f31ff,cfc26dad-b1eb-4383-acc4-0bfd3af7dfc4,b196abec-4923-404d-9c48-8cad87405248,67715a8c-4215-461d-a47f-2a17375f3f37,5dbbcfb8-4f4a-4d74-9b91-890c434b8e38,f1b261ad-11bc-4879-bc2a-1c146000b235,45fa1925-4c59-4d52-89b8-59eda913d7c0,b36c7b72-a2d2-44db-96e9-dd12b8bfcab9,279093e6-1a7d-4a17-b419-08ec141b2f50,9acf2e05-2d27-4e71-8adb-aa7aa543a8f2,fcb151dc-f01c-4215-a818-6e2a3fdf6e9d,2c610e1b-23fb-44bb-859a-b08a020c7359,b9aee346-f924-4775-812f-06163065c478,6d69a0f6-7d4b-4052-8c8e-5671b42edbaa,f0080701-8c7d-4328-95a7-764916fa6997,135aa295-9cf9-48a7-aabb-c188b55a63f5,d6ebc5af-7bf0-4d4a-a010-a5e897396977,3b2f622f-000f-4740-a506-23914288ccbf,8eb9f4a8-5cb7-4e70-8e10-b29860f18bf6,4c6f96d3-b937-433f-8750-3f1ecebc1b1e,6cdb5208-da64-4572-86da-0d3dd87ca00b,ecb45e3a-cd24-4773-9b43-b6de6702503e,46ab499a-d11e-422d-887f-6d6b5fbbbb90,daf5638e-cf1e-4bc7-b68a-ca61505dbcab,7ab1ef14-8f51-4649-b252-7392179be4ab,c34fad05-6582-482d-8033-8540dcf19f27,3026b747-078b-43fb-a588-bedde51d24c8,4c402d4a-bf94-4819-9d79-34f8d5b4caea,364ced6d-a3c3-4d05-980b-2712a8f548c0,43fc59f3-c664-4b44-9fb3-1515640e28d1,5cdf98d7-aa32-4879-b78b-85f72120d66f,87a934ce-0875-4147-a9b3-9d926b472875,039d01df-1d98-4baf-b1f3-286be1563a09,034dab31-29f9-497d-b31c-903b636faaea,aa15a739-e971-4d91-9249-f12ced7085c8,1cc6cd0b-0fae-4d39-ba2a-9e2dcd91ee3b,1a155113-c2c3-4aaa-94f6-3e7abd507bb1,02b246a6-9db1-4c7d-b1fb-143193f85dc7,20b21127-bcd6-4b0a-9aac-19a3f6cecc7c,3deec0e6-b33f-4cc3-a406-7786a0d15ebc,1b61a4e1-7c01-49c8-a178-15ec87e6b6cc,4ef39543-d413-4a2d-a39d-115636ccdb0a,d4b7c1aa-4d9a-4912-954c-a8aae072446a,d7efd8c3-edcd-493c-a034-be37516bbdbd,a43b509c-8295-40f9-b7ca-e50910a1cec0,707c9dbf-d5c9-413a-a1c2-5884dc733417,c4bafd81-de25-4655-82e2-17d1179174a7,261eaa41-e9e4-48cf-97a7-002eee028c9d,6cb26e10-0f30-4de3-89d5-26507032d69d,872ac07f-3479-46c9-b496-126c7165446b,86ec7223-bf4d-43f1-aa4c-fcfad2417e55,b17b3906-a327-4618-9814-13163aaf36e6,a8923b24-717e-4d67-bcbc-b442f40c96d0,a63b8567-a916-4e2b-bbd9-1d58a7831dc3,e58a4d8c-2fa7-4bcf-9f0f-e2ee1a35fb72,23b71a6d-a13b-402a-ba09-a51d83f34f48,9e42d9cd-0831-4dee-b390-e758a092360a,bb115f26-18bf-4c91-ba02-9ff068e03162,f46ac611-b0d2-462b-b0cc-54c02038c071,26033197-ef08-4796-add7-4fd47bca0f46,35e42688-abf3-4e47-a772-5eecb66a61ca,bf466814-2e0a-46ed-9106-404389298dd9,2e1b7a9d-a471-4d33-89bd-a93ab1a8d978,a859f83c-43fd-4ac6-b436-78eca768cf85,947a22ae-699f-4477-bd7a-233044afc4e0,c0fd09bf-3d63-46e1-a34b-d8b3293a0289,ed4e3cf1-9ec6-48c0-8680-73f8967887b2,cc6ed0a0-6538-4426-8988-9286ad06e892}'::uuid[])))
5. 107.051 7,483.199 ↓ 30.9 165,100 1

Nested Loop Left Join (cost=265,766.19..305,348.55 rows=5,335 width=816) (actual time=5,921.811..7,483.199 rows=165,100 loops=1)

  • Join Filter: (sbr.type = "*VALUES*".column1)
  • Rows Removed by Join Filter: 495300
6. 36.670 7,376.148 ↓ 30.9 165,100 1

Hash Left Join (cost=265,766.19..305,108.43 rows=5,335 width=784) (actual time=5,921.791..7,376.148 rows=165,100 loops=1)

  • Hash Cond: (gh.game_number = sbr.game_number)
7. 0.000 7,339.460 ↓ 30.9 165,100 1

Nested Loop (cost=265,754.39..305,076.61 rows=5,335 width=715) (actual time=5,921.753..7,339.460 rows=165,100 loops=1)

8. 0.000 7,014.443 ↓ 30.9 165,100 1

Nested Loop (cost=265,754.10..302,816.36 rows=5,335 width=701) (actual time=5,921.745..7,014.443 rows=165,100 loops=1)

9. 1,050.844 6,692.598 ↓ 30.9 165,100 1

Hash Right Join (cost=265,753.81..301,041.26 rows=5,335 width=669) (actual time=5,921.725..6,692.598 rows=165,100 loops=1)

  • Hash Cond: (game_history_reports_jackpotdetails.game_history_reports_id = gh.id)
10. 3,324.759 5,292.296 ↓ 1.1 819,715 1

GroupAggregate (cost=247,232.38..272,021.74 rows=762,735 width=36) (actual time=1,647.704..5,292.296 rows=819,715 loops=1)

  • Group Key: game_history_reports_jackpotdetails.game_history_reports_id
11. 1,530.635 1,967.537 ↑ 1.0 1,525,517 1

Sort (cost=247,232.38..251,046.17 rows=1,525,517 width=23) (actual time=1,647.675..1,967.537 rows=1,525,517 loops=1)

  • Sort Key: game_history_reports_jackpotdetails.game_history_reports_id
  • Sort Method: external merge Disk: 50216kB
12. 436.902 436.902 ↑ 1.0 1,525,517 1

Seq Scan on game_history_reports_jackpotdetails (cost=0.00..27,982.17 rows=1,525,517 width=23) (actual time=0.071..436.902 rows=1,525,517 loops=1)

13. 176.520 349.458 ↓ 30.9 165,100 1

Hash (cost=18,454.75..18,454.75 rows=5,335 width=637) (actual time=349.458..349.458 rows=165,100 loops=1)

  • Buckets: 32768 (originally 8192) Batches: 8 (originally 1) Memory Usage: 4023kB
14. 43.322 172.938 ↓ 30.9 165,100 1

Hash Left Join (cost=125.78..18,454.75 rows=5,335 width=637) (actual time=1.535..172.938 rows=165,100 loops=1)

  • Hash Cond: (gh.game_id = g.id)
15. 67.125 129.498 ↓ 30.9 165,100 1

Hash Join (cost=115.93..18,371.54 rows=5,335 width=629) (actual time=1.407..129.498 rows=165,100 loops=1)

  • Hash Cond: (gh.game_id = gs.game_id)
16. 60.990 60.990 ↑ 1.1 165,100 1

Index Scan Backward using ix_game_history_reports_game_date on game_history_reports gh (cost=0.43..16,035.48 rows=173,377 width=615) (actual time=0.017..60.990 rows=165,100 loops=1)

  • Index Cond: ((game_date >= '2019-03-06 06:00:00-06'::timestamp with time zone) AND (game_date <= '2019-03-08 05:59:59-06'::timestamp with time zone))
17. 0.080 1.383 ↓ 32.5 260 1

Hash (cost=115.40..115.40 rows=8 width=30) (actual time=1.383..1.383 rows=260 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
18. 1.303 1.303 ↓ 32.5 260 1

Seq Scan on game_strings gs (cost=0.00..115.40 rows=8 width=30) (actual time=0.038..1.303 rows=260 loops=1)

  • Filter: (lower((locale)::text) = 'en-us'::text)
  • Rows Removed by Filter: 1300
19. 0.056 0.118 ↑ 1.0 260 1

Hash (cost=6.60..6.60 rows=260 width=24) (actual time=0.118..0.118 rows=260 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
20. 0.062 0.062 ↑ 1.0 260 1

Seq Scan on games g (cost=0.00..6.60 rows=260 width=24) (actual time=0.023..0.062 rows=260 loops=1)

21. 330.200 330.200 ↑ 1.0 1 165,100

Index Scan using pk_casino_players on casino_players cp (cost=0.29..0.32 rows=1 width=48) (actual time=0.001..0.002 rows=1 loops=165,100)

  • Index Cond: (id = gh.casino_player_id)
22. 330.200 330.200 ↑ 1.0 1 165,100

Index Scan using pk_players on players p (cost=0.29..0.41 rows=1 width=46) (actual time=0.001..0.002 rows=1 loops=165,100)

  • Index Cond: (id = cp.player_id)
23. 0.000 0.018 ↓ 0.0 0 1

Hash (cost=10.80..10.80 rows=80 width=77) (actual time=0.018..0.018 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
24. 0.018 0.018 ↓ 0.0 0 1

Seq Scan on side_bets_reports sbr (cost=0.00..10.80 rows=80 width=77) (actual time=0.018..0.018 rows=0 loops=1)

25. 0.000 0.000 ↑ 1.0 3 165,100

Materialize (cost=0.00..0.05 rows=3 width=36) (actual time=0.000..0.000 rows=3 loops=165,100)

26. 0.004 0.004 ↑ 1.0 3 1

Values Scan on "*VALUES*" (cost=0.00..0.04 rows=3 width=36) (actual time=0.002..0.004 rows=3 loops=1)

27. 0.033 0.062 ↓ 2.8 278 1

Hash (cost=1.51..1.51 rows=100 width=16) (actual time=0.062..0.062 rows=278 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
28. 0.029 0.029 ↓ 2.8 278 1

Result (cost=0.00..0.51 rows=100 width=16) (actual time=0.005..0.029 rows=278 loops=1)

29. 0.054 0.109 ↑ 1.0 278 1

Hash (cost=3.48..3.48 rows=278 width=48) (actual time=0.109..0.109 rows=278 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 26kB
30. 0.055 0.055 ↑ 1.0 278 1

Values Scan on "*VALUES*_1" (cost=0.00..3.48 rows=278 width=48) (actual time=0.001..0.055 rows=278 loops=1)