explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GMf7

Settings
# exclusive inclusive rows x rows loops node
1. 0.700 4,127.025 ↑ 621.0 100 1

Sort (cost=152,071.29..152,226.54 rows=62,101 width=763) (actual time=4,126.980..4,127.025 rows=100 loops=1)

  • Sort Key: molecules.rec_id, batches.hash
  • Sort Method: quicksort Memory: 126kB
2. 0.541 4,126.325 ↑ 621.0 100 1

Hash Left Join (cost=15,551.83..126,113.33 rows=62,101 width=763) (actual time=709.746..4,126.325 rows=100 loops=1)

  • Hash Cond: ((molecules.rec_id)::text = (guides.rec_id)::text)
3. 29.146 4,109.055 ↑ 621.0 100 1

Hash Left Join (cost=15,396.01..125,406.39 rows=62,101 width=456) (actual time=692.956..4,109.055 rows=100 loops=1)

  • Hash Cond: ((molecules.rec_id)::text = (sirnas.rec_id)::text)
4. 3,147.019 3,924.157 ↑ 621.0 100 1

Hash Join (cost=11,330.06..113,199.35 rows=62,101 width=449) (actual time=537.047..3,924.157 rows=100 loops=1)

  • Hash Cond: ((batches.rec_id)::text = (molecules.rec_id)::text)
  • Join Filter: ((molecules.synonyms && '{75510f04-b7a8-4217-8118-ef09e6562663,a94e57f8-f25d-463c-aa20-887030f4c9c3,b0ea1af2-50e1-4919-bf29-ec78ffdc0072,10bca36f-c24d-48bd-a048-7d6a881f42b7,be5f8370-bacc-4118-a064-030e1b993cd9,413a8a65-567d-4526-ba67-835703c91fac,3e5b1900-eddf-4609-afbb-414056f01faf,d8a33ee8-fa4d-4502-a078-c30a1742a0db,d77cbe02-c438-4dba-a4f8-26cf672e4148,082bb222-a373-4ee2-86fe-d3ed2749811a,7305e911-3310-40e3-993c-e400cdbacd9f,43eb4e94-8528-442c-9ce8-d3285bdee6fb,b44f97a1-8baa-442d-add4-f2feb83aa730,40d6ccd5-4abd-4757-aafb-dc52ee73f00a,054c6f28-c340-45fa-8b75-67f257b1d034,120e5d3d-4835-445b-8de6-16f318916c0a,831d64bc-ccdf-4e1c-bb9c-ba50fbac5b36,241ac370-e8d1-4d1a-9c23-157b8868867d,f053e145-cdfb-47fd-a553-322879aa8f95,b2f08f12-e7b2-44cd-8b27-b36a7e7de0d8,77381a87-996d-4d55-8cff-63a2409adb75,49df05e8-351a-4ba3-9910-2e0afc7eb721,c780b532-439e-443b-8445-821e18edca23,c9c64901-5357-48b6-8813-0aae1e538382,b72eb12a-f624-4952-80cb-c77672392f3f,93df3f64-b6f2-4cbf-8a3f-08b24c775b3a,7ed07155-97ba-46ff-b40a-2773a51d1748,40285a6a-9b29-4c80-bd79-89310a4a9fec,975e3d0a-689a-4253-b5b9-446e64314532,766519eb-22de-465f-b69a-bda9fb10d52b,767ab36a-95fc-473f-8d77-c5277d4a452d,ef87ceb2-e108-46c6-af97-4075f74db39d,615ea599-9c35-4cb9-80cc-11ee5e1a920d,fe601aa7-92c5-435b-afb2-831a9ae1c2b7,cae3022c-577d-4530-a4e7-f10c43088272,5e59441e-a95f-4430-9d32-e2634cf9e7dc,016591bf-f344-464e-94ed-dcf7c23bb0f7,01fb3545-6631-42b2-ae3a-07b7785c2bed,6958f168-dabb-4c85-a7eb-8d0f7fd97e77,a0246a10-5b69-4b40-aee4-5c629b7fcc1c,f9ecd710-918c-48a0-8f63-acc82dee9924,4a1efd0c-b700-42a6-9dd9-b08a69d58e15,0714c019-fa49-4396-882a-18b830fb1455,2b843b4d-6481-4e2f-a113-03c13620b50d,aa2c2410-f05e-474d-926f-28e8023cf7a6,94e4b16a-71f9-4b0f-a8e0-365040e000f0,fa20258d-a795-4d16-864d-703954e66400,87cda976-fb26-4383-ab6f-2cdbe03df22a,a06c0b53-809d-4863-ab67-916a295a26c9,ec33446b-87bd-46d1-a7fb-e64dbdfb7138,2af6058c-fa44-423e-94ab-dc538a8bc5c6,c8917148-7656-4738-8313-27bb9bd282d0,45533f70-1f5b-4ffd-9148-bcc0c4f62918,d88bc3df-8105-4f19-97e9-e0ec7d12c436,c69604e5-2524-423e-b02a-c9f68960f365,86b528f6-c6e7-4cbe-9f9a-3e5b7c668543,5c9ed07e-2e49-414e-8628-c70f1f664c8f,4f54f6a0-722a-4bf7-80fe-928a201b8b3e,2b378e8c-3482-4eba-b2eb-72ab9ee55871,c1dc2945-e46a-44e2-937c-6159e06955d2,8b1b3174-8c77-4283-8e8e-4b84843292b5,8cc618c3-7fbd-479a-aebb-710ccb1af8cd,60b1b95a-ac77-4506-8a68-2a3b33b57413,7f13438e-2b9c-4ce5-8dd4-e13f2b5bb01e,8a843c36-781f-44d7-a384-9819a59e0d4b,48d9ce45-d421-4389-9287-4548ec7f80a9,5d8c32f4-3ffb-483e-a4a9-eab368a14b3a,3d0cfa77-86d4-4534-9428-71500801dccd,c9196576-6ada-46f9-b65c-6c19a8bc12df,8960c8c5-44e7-4269-86bd-f159a7a2d969,14d01248-bf17-4d91-b2f1-17a8015d28e5,7fe530de-e744-4331-8273-e9ecae15fd20,15d00e45-2341-45c1-9be2-11163847a918,a39ad0ba-70c5-4418-8fd8-e73c33ef19f5,ff4314c2-51ad-4965-b896-0d67f37b66cf,b457fbbf-d63a-40e1-8301-7cf575382c43,c3a2019e-9377-4f33-aa20-0765d076457a,7774339e-b508-413e-87fe-2f47ff856e67,80b9bd1b-0b6f-42e6-9d2a-b43717def059,5f33b8fd-0ed2-4160-8082-4d653caf2c07,422d74ad-c891-4c3f-b73b-f5e6781cc090,1de9edc8-949b-406c-bed4-d18d6a2474ae,dbb60f4f-e7dd-4884-b295-53b71178851f,1d7dcdc6-238c-4033-8175-57ed9596670f,559189f6-3800-46a5-8a0f-80b571067255,f428ea89-417a-45b0-8768-0a744925fcb1,172740c8-d5e9-4d92-a4d3-e059e56d1cb1,25ba65d5-4c31-4f2b-9c5e-137ae55bc28c,8afc6fe9-600c-42cd-bcdf-ba3e3196c837,20714426-dc14-4f6f-bd0d-8af53283ca85,46f20eb1-6a54-4fb3-8c3a-d683d27d6319,68e93ab4-9a97-46bc-be16-bfddfede5b2e,1905d8b8-34de-4147-b112-37e9a0c22459,14713d66-a990-4c70-9c43-90c3eae64f1a,726345a7-0adb-4a6e-ab8b-11fed429bb9b,52968671-ed71-4bd0-ae30-86e970396299,59232f70-fc8a-4b30-919a-c3ef35cf98fc,d31ea9c1-ba21-4291-b073-51b0a5b8ed6c,3d32844b-2b7e-4d7d-b5b5-416e026d72c9,93a383c7-5ea3-4063-a24e-26f1a7b82114}'::character varying[]) OR ((batches.hash)::text = ANY ('{75510f04-b7a8-4217-8118-ef09e6562663,a94e57f8-f25d-463c-aa20-887030f4c9c3,b0ea1af2-50e1-4919-bf29-ec78ffdc0072,10bca36f-c24d-48bd-a048-7d6a881f42b7,be5f8370-bacc-4118-a064-030e1b993cd9,413a8a65-567d-4526-ba67-835703c91fac,3e5b1900-eddf-4609-afbb-414056f01faf,d8a33ee8-fa4d-4502-a078-c30a1742a0db,d77cbe02-c438-4dba-a4f8-26cf672e4148,082bb222-a373-4ee2-86fe-d3ed2749811a,7305e911-3310-40e3-993c-e400cdbacd9f,43eb4e94-8528-442c-9ce8-d3285bdee6fb,b44f97a1-8baa-442d-add4-f2feb83aa730,40d6ccd5-4abd-4757-aafb-dc52ee73f00a,054c6f28-c340-45fa-8b75-67f257b1d034,120e5d3d-4835-445b-8de6-16f318916c0a,831d64bc-ccdf-4e1c-bb9c-ba50fbac5b36,241ac370-e8d1-4d1a-9c23-157b8868867d,f053e145-cdfb-47fd-a553-322879aa8f95,b2f08f12-e7b2-44cd-8b27-b36a7e7de0d8,77381a87-996d-4d55-8cff-63a2409adb75,49df05e8-351a-4ba3-9910-2e0afc7eb721,c780b532-439e-443b-8445-821e18edca23,c9c64901-5357-48b6-8813-0aae1e538382,b72eb12a-f624-4952-80cb-c77672392f3f,93df3f64-b6f2-4cbf-8a3f-08b24c775b3a,7ed07155-97ba-46ff-b40a-2773a51d1748,40285a6a-9b29-4c80-bd79-89310a4a9fec,975e3d0a-689a-4253-b5b9-446e64314532,766519eb-22de-465f-b69a-bda9fb10d52b,767ab36a-95fc-473f-8d77-c5277d4a452d,ef87ceb2-e108-46c6-af97-4075f74db39d,615ea599-9c35-4cb9-80cc-11ee5e1a920d,fe601aa7-92c5-435b-afb2-831a9ae1c2b7,cae3022c-577d-4530-a4e7-f10c43088272,5e59441e-a95f-4430-9d32-e2634cf9e7dc,016591bf-f344-464e-94ed-dcf7c23bb0f7,01fb3545-6631-42b2-ae3a-07b7785c2bed,6958f168-dabb-4c85-a7eb-8d0f7fd97e77,a0246a10-5b69-4b40-aee4-5c629b7fcc1c,f9ecd710-918c-48a0-8f63-acc82dee9924,4a1efd0c-b700-42a6-9dd9-b08a69d58e15,0714c019-fa49-4396-882a-18b830fb1455,2b843b4d-6481-4e2f-a113-03c13620b50d,aa2c2410-f05e-474d-926f-28e8023cf7a6,94e4b16a-71f9-4b0f-a8e0-365040e000f0,fa20258d-a795-4d16-864d-703954e66400,87cda976-fb26-4383-ab6f-2cdbe03df22a,a06c0b53-809d-4863-ab67-916a295a26c9,ec33446b-87bd-46d1-a7fb-e64dbdfb7138,2af6058c-fa44-423e-94ab-dc538a8bc5c6,c8917148-7656-4738-8313-27bb9bd282d0,45533f70-1f5b-4ffd-9148-bcc0c4f62918,d88bc3df-8105-4f19-97e9-e0ec7d12c436,c69604e5-2524-423e-b02a-c9f68960f365,86b528f6-c6e7-4cbe-9f9a-3e5b7c668543,5c9ed07e-2e49-414e-8628-c70f1f664c8f,4f54f6a0-722a-4bf7-80fe-928a201b8b3e,2b378e8c-3482-4eba-b2eb-72ab9ee55871,c1dc2945-e46a-44e2-937c-6159e06955d2,8b1b3174-8c77-4283-8e8e-4b84843292b5,8cc618c3-7fbd-479a-aebb-710ccb1af8cd,60b1b95a-ac77-4506-8a68-2a3b33b57413,7f13438e-2b9c-4ce5-8dd4-e13f2b5bb01e,8a843c36-781f-44d7-a384-9819a59e0d4b,48d9ce45-d421-4389-9287-4548ec7f80a9,5d8c32f4-3ffb-483e-a4a9-eab368a14b3a,3d0cfa77-86d4-4534-9428-71500801dccd,c9196576-6ada-46f9-b65c-6c19a8bc12df,8960c8c5-44e7-4269-86bd-f159a7a2d969,14d01248-bf17-4d91-b2f1-17a8015d28e5,7fe530de-e744-4331-8273-e9ecae15fd20,15d00e45-2341-45c1-9be2-11163847a918,a39ad0ba-70c5-4418-8fd8-e73c33ef19f5,ff4314c2-51ad-4965-b896-0d67f37b66cf,b457fbbf-d63a-40e1-8301-7cf575382c43,c3a2019e-9377-4f33-aa20-0765d076457a,7774339e-b508-413e-87fe-2f47ff856e67,80b9bd1b-0b6f-42e6-9d2a-b43717def059,5f33b8fd-0ed2-4160-8082-4d653caf2c07,422d74ad-c891-4c3f-b73b-f5e6781cc090,1de9edc8-949b-406c-bed4-d18d6a2474ae,dbb60f4f-e7dd-4884-b295-53b71178851f,1d7dcdc6-238c-4033-8175-57ed9596670f,559189f6-3800-46a5-8a0f-80b571067255,f428ea89-417a-45b0-8768-0a744925fcb1,172740c8-d5e9-4d92-a4d3-e059e56d1cb1,25ba65d5-4c31-4f2b-9c5e-137ae55bc28c,8afc6fe9-600c-42cd-bcdf-ba3e3196c837,20714426-dc14-4f6f-bd0d-8af53283ca85,46f20eb1-6a54-4fb3-8c3a-d683d27d6319,68e93ab4-9a97-46bc-be16-bfddfede5b2e,1905d8b8-34de-4147-b112-37e9a0c22459,14713d66-a990-4c70-9c43-90c3eae64f1a,726345a7-0adb-4a6e-ab8b-11fed429bb9b,52968671-ed71-4bd0-ae30-86e970396299,59232f70-fc8a-4b30-919a-c3ef35cf98fc,d31ea9c1-ba21-4291-b073-51b0a5b8ed6c,3d32844b-2b7e-4d7d-b5b5-416e026d72c9,93a383c7-5ea3-4063-a24e-26f1a7b82114}'::text[])))
  • Rows Removed by Join Filter: 180217
5. 254.581 254.581 ↓ 1.0 180,317 1

Seq Scan on batches (cost=0.00..55,297.11 rows=178,911 width=407) (actual time=0.013..254.581 rows=180,317 loops=1)

6. 235.860 522.557 ↑ 1.0 248,847 1

Hash (cost=5,788.47..5,788.47 rows=248,847 width=54) (actual time=522.557..522.557 rows=248,847 loops=1)

  • Buckets: 65536 Batches: 8 Memory Usage: 3107kB
7. 286.697 286.697 ↑ 1.0 248,847 1

Seq Scan on molecules (cost=0.00..5,788.47 rows=248,847 width=54) (actual time=0.046..286.697 rows=248,847 loops=1)

8. 83.561 155.752 ↑ 1.0 75,049 1

Hash (cost=2,681.20..2,681.20 rows=75,420 width=23) (actual time=155.751..155.752 rows=75,049 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 2568kB
9. 72.191 72.191 ↑ 1.0 75,049 1

Seq Scan on sirnas (cost=0.00..2,681.20 rows=75,420 width=23) (actual time=0.018..72.191 rows=75,049 loops=1)

10. 15.134 16.729 ↑ 1.0 3,103 1

Hash (cost=117.03..117.03 rows=3,103 width=22) (actual time=16.729..16.729 rows=3,103 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 198kB
11. 1.595 1.595 ↑ 1.0 3,103 1

Seq Scan on guides (cost=0.00..117.03 rows=3,103 width=22) (actual time=0.017..1.595 rows=3,103 loops=1)