explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ItbW

Settings
# exclusive inclusive rows x rows loops node
1. 2.346 93.571 ↓ 2.7 2,178 1

Hash Join (cost=632.59..4,817.67 rows=810 width=775) (actual time=66.362..93.571 rows=2,178 loops=1)

  • Hash Cond: ((kitchenbra0_.point_of_sale_id)::text = (pointofsal1_.id)::text)
2. 9.223 88.909 ↓ 2.7 2,178 1

Hash Join (cost=624.35..4,807.24 rows=810 width=416) (actual time=63.047..88.909 rows=2,178 loops=1)

  • Hash Cond: ((kitchenbra0_.kitchen_brand_menu_addon_id)::text = (kitchenbra2_.id)::text)
3. 17.048 17.048 ↑ 1.0 65,815 1

Seq Scan on kitchen_brand_menu_pos_addons kitchenbra0_ (cost=0.00..4,009.43 rows=66,048 width=227) (actual time=0.006..17.048 rows=65,815 loops=1)

  • Filter: available
  • Rows Removed by Filter: 28,115
4. 1.487 62.638 ↑ 1.0 121 1

Hash (cost=622.84..622.84 rows=121 width=189) (actual time=62.638..62.638 rows=121 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 33kB
5. 24.064 61.151 ↑ 1.0 121 1

Bitmap Heap Scan on kitchen_brand_menu_addons kitchenbra2_ (cost=371.42..622.84 rows=121 width=189) (actual time=37.107..61.151 rows=121 loops=1)

  • Recheck Cond: ((id)::text = ANY ('{785acc9d-a058-43ca-bc6a-c94bfcd7d567,d70bbda9-8083-4475-b053-295aa8009403,15f1b5b2-3a73-4750-a05a-5c8ab3133ee7,7cf9260c-297c-489b-88c7-524bc6b41f81,9b336d61-9f50-40fc-8585-ce9ee78d0b7e,cd032395-6e19-4f9d-ba05-8bcdaeb8c3a7,991ada9e-663a-40bd-90e5-5db6aef66aef,747fc8af-2777-4c29-9f69-c184a77b2ba0,e1884bc1-5114-4bf8-886c-bd034f779b6b,b2c5f522-4cb5-4132-bcac-400388342279,82fa3812-bef0-4cd4-9cfe-49734bca48c0,efe22b21-ea2b-4826-b392-41ab86c729df,0ac9ca86-ab6c-4a6d-bb2e-f4cf4f9d4828,de4cc491-f212-4b6e-a9ca-fa0813db4f7d,edc38ad9-5a5e-4df2-865b-487a22ae0c55,3c5aa1dc-0747-4cb3-adf8-8be62a5a2cc7,a4962561-81c9-4860-a936-5add15891da4,2bcbcfce-fede-4eeb-acaf-64adf15feb85,c983f6cb-cbf3-4143-a186-c0f82df6d9ce,251eda55-27f9-4af3-8fc4-3a433c156d0f,cc394330-5113-4cc1-b8bf-a450761ed7f6,a39d8c15-3e5a-4af4-96db-34425b87a6c9,a02fdfff-7a70-4422-be3c-33b7036ba952,6cef5088-57bd-4198-a356-f2f843e26e1d,0f4c020e-7e49-48a9-ad6d-cd345004e41f,45fd0460-2aff-4ea4-8be1-51fd56bce23a,791c0723-63ec-4cee-9108-1c9025e7eb25,d23a0b89-33c4-4dec-bbe3-b9c130355601,21f7465e-35cf-479c-8cd5-0a82edd68406,2167df2f-ab47-4da4-8784-65035a972b83,9b0f51f2-04e8-424c-ba32-5d92a9c0be02,6ce23182-91c9-451d-959a-420d06dd0f86,a635e5b7-5729-48bf-828a-8943f2fb0159,83fc4dcd-3903-4bd4-9656-84f8ac04eb46,4b927169-4f5d-4278-bdc3-e7e9e1fdcad7,a4fe6e47-e39c-4641-99e4-2f908e0fa949,1622020b-3d83-4b10-bf0e-6ed0b01c2461,523d1bcb-52a0-4aa5-b1de-df1196b8c146,f94f5af6-f7a4-482b-a99d-a06ea251d3c4,6a5cef17-b0a7-457e-a19d-1ba56daff9ad,fa40e263-a6bd-4c52-8939-3d2ca5ba3c61,c8db3d5d-3256-4dc8-ab59-e596baa7ab1b,ea68da1a-1081-42b9-98fe-c18dc284f6a6,4fe24957-98be-46d9-be0f-0d1eef02fb93,8e1174f4-889c-4ea2-a256-3860891ff079,b42c7a50-4c1f-4cf3-82a6-b1d98f185c7f,a8a5cb94-3fcc-47d8-8053-8e31af9c8311,8b8486e9-c8c3-4315-a28d-afe65e64ac15,a70f09cd-e5c8-4916-88a9-cac2ad7e7ccd,88283b54-f808-4dd3-8f17-5c2af448b8af,aa835230-e6c2-4307-b2f7-feedfa80841d,b7c0de8f-b8d5-43be-be94-47f464967aee,af7a50ec-2c86-4b63-8f45-d8affc2e5b48,2a5923b8-21d9-4960-9ec1-72f5cb174c17,d3e5f7ef-9da4-4fa7-af25-1a5222a81f37,77c82f1b-4d4f-4c9e-b03e-e2a7a07ee54a,1b12d62b-6997-4d54-b619-319440e9d13c,589a6dfd-9cb5-4f23-9ed2-77ee3918673f,c0e02a36-898b-4b73-aa88-828796cd4ccc,bc47de69-6305-43f7-9cd6-b71d94a28b96,db62bbdd-ca21-42e3-abe6-c0b3f3b09931,254e1b4f-9ff1-4a11-9550-c07035882b55,4a7570d3-643b-4565-8f02-e6a6729981c4,34840a76-1874-4210-bc5f-a6179fe4d499,00d3aefe-7a4f-4840-9f1a-d0d4f4e4b18a,cdad3a9d-cc53-425a-95db-b69fe21f469d,2d35d185-5f12-4622-87be-e1790aaeb823,b46c254d-3620-4ad8-b9f6-feae0f86b02a,190c7d8d-23b5-4587-ae35-9a722a4ff461,b603c9f4-796f-47f7-b078-e6564eeb4e37,5328f153-e164-4bc0-b4a1-6994b7270f38,d8287aed-2eb4-44cb-9ead-a2a3f206dbd4,6de25ae4-3c5d-4e4c-b2b5-c4ea5f004289,d31f81d1-24a2-475b-8a07-376b83e4fc8e,da31ebc0-2d74-45e0-bd0f-a153872eac3a,475112f8-731b-46cd-83d8-d9b1ffbe1000,ca66ef1d-fccc-460f-9a2a-9b170549832e,ad53ca52-efd9-479e-8596-a4f155d7ad19,6a30d002-5a65-45f3-b35e-a711805c5562,70cebc2f-4d7d-4524-a40b-6b7169633cfc,a1e79fae-67ba-4a73-a16a-b699fcc09468,12f56f3c-5ab7-4adb-9f84-cdb968077cb1,1e831d02-f8f0-4814-b934-97335656ae4f,827a5ae1-dd07-494b-86b3-0e3fe553fa14,14c46133-58a4-4bb6-a386-58ff1482b1a7,628c2fae-39d9-4283-8278-29ecde7590b9,58d546b4-73e6-47d0-ba77-1202166d95fa,a0937338-0bf5-4144-9712-019dc0f310e7,2aa9be8a-bbaf-430a-8890-49872a9d31f7,d74f84c0-6dfc-4e3e-9506-595f1c6ed973,39ab2dce-9b91-4756-9fd4-8a724731f47d,05e31ac5-b2f5-478b-b8a9-192047c2165d,409ebaab-1cf2-4f2f-8207-3541da182fce,7c6fd39d-5b29-4d81-ad4e-500cbb34913a,3f64ebbe-2bc7-4919-a2c3-1c04dd945fe7,3f38bb4c-88af-483f-8233-c439defa1953,992aceb0-2f22-4044-97db-6c337a044912,3cde6908-1436-4e34-bd74-5adc7d9b6f99,f5e819ef-2ebc-4ce2-b48c-4dd474b6be5a,b8844ddd-688f-4e89-91dc-4022f0992bc2,7570b40a-12ac-4b23-8629-399a8404edd2,0ab6c0fc-803d-400f-a0b4-bef608fb44d2,9176fa24-1dd9-42d3-9b23-05ba38330109,8465ecc3-f4fa-4788-8d3d-1fdb7aedecf8,1834a3f2-8335-4f62-b461-833013a6397c,69e2ca18-7f17-4f93-83cb-d3aca64ed014,e0289f6e-071a-456c-be3c-7fe4b7099a40,c30c4127-10ae-4837-95f8-df4934f7018a,a67cb04a-a665-497c-96ca-ee5b6756a791,e16c9def-d40c-4cd1-8d5c-6952defeb02b,f9467300-5780-4312-a661-921878d29b3b,760ece08-4fd0-44b6-ae5f-134be05eccd5,42a3aa6a-600a-45f7-bc3c-2acc8c009eab,3de7a29a-9d5e-4b86-8bf1-5d833d1fe269,c0e23d84-6c1e-44de-b0f6-32d9c1c48131,060af058-d8ef-4abc-8df2-d028f390081c,2f42c53d-3997-4213-9549-74cb86a6fa98,cbd2528e-1c15-4fdb-968e-3f56e79dad29,8a38d3f6-c302-491f-8aef-799a6e051d21,cefc7197-7b89-4953-af97-c6aadd127b26,c7e3bbf5-5e87-4c3f-a404-7d4e9db52a6d}'::text[]))
  • Heap Blocks: exact=102
6. 37.087 37.087 ↑ 1.0 121 1

Bitmap Index Scan on idx_16719_primary (cost=0.00..371.39 rows=121 width=0) (actual time=37.087..37.087 rows=121 loops=1)

  • Index Cond: ((id)::text = ANY ('{785acc9d-a058-43ca-bc6a-c94bfcd7d567,d70bbda9-8083-4475-b053-295aa8009403,15f1b5b2-3a73-4750-a05a-5c8ab3133ee7,7cf9260c-297c-489b-88c7-524bc6b41f81,9b336d61-9f50-40fc-8585-ce9ee78d0b7e,cd032395-6e19-4f9d-ba05-8bcdaeb8c3a7,991ada9e-663a-40bd-90e5-5db6aef66aef,747fc8af-2777-4c29-9f69-c184a77b2ba0,e1884bc1-5114-4bf8-886c-bd034f779b6b,b2c5f522-4cb5-4132-bcac-400388342279,82fa3812-bef0-4cd4-9cfe-49734bca48c0,efe22b21-ea2b-4826-b392-41ab86c729df,0ac9ca86-ab6c-4a6d-bb2e-f4cf4f9d4828,de4cc491-f212-4b6e-a9ca-fa0813db4f7d,edc38ad9-5a5e-4df2-865b-487a22ae0c55,3c5aa1dc-0747-4cb3-adf8-8be62a5a2cc7,a4962561-81c9-4860-a936-5add15891da4,2bcbcfce-fede-4eeb-acaf-64adf15feb85,c983f6cb-cbf3-4143-a186-c0f82df6d9ce,251eda55-27f9-4af3-8fc4-3a433c156d0f,cc394330-5113-4cc1-b8bf-a450761ed7f6,a39d8c15-3e5a-4af4-96db-34425b87a6c9,a02fdfff-7a70-4422-be3c-33b7036ba952,6cef5088-57bd-4198-a356-f2f843e26e1d,0f4c020e-7e49-48a9-ad6d-cd345004e41f,45fd0460-2aff-4ea4-8be1-51fd56bce23a,791c0723-63ec-4cee-9108-1c9025e7eb25,d23a0b89-33c4-4dec-bbe3-b9c130355601,21f7465e-35cf-479c-8cd5-0a82edd68406,2167df2f-ab47-4da4-8784-65035a972b83,9b0f51f2-04e8-424c-ba32-5d92a9c0be02,6ce23182-91c9-451d-959a-420d06dd0f86,a635e5b7-5729-48bf-828a-8943f2fb0159,83fc4dcd-3903-4bd4-9656-84f8ac04eb46,4b927169-4f5d-4278-bdc3-e7e9e1fdcad7,a4fe6e47-e39c-4641-99e4-2f908e0fa949,1622020b-3d83-4b10-bf0e-6ed0b01c2461,523d1bcb-52a0-4aa5-b1de-df1196b8c146,f94f5af6-f7a4-482b-a99d-a06ea251d3c4,6a5cef17-b0a7-457e-a19d-1ba56daff9ad,fa40e263-a6bd-4c52-8939-3d2ca5ba3c61,c8db3d5d-3256-4dc8-ab59-e596baa7ab1b,ea68da1a-1081-42b9-98fe-c18dc284f6a6,4fe24957-98be-46d9-be0f-0d1eef02fb93,8e1174f4-889c-4ea2-a256-3860891ff079,b42c7a50-4c1f-4cf3-82a6-b1d98f185c7f,a8a5cb94-3fcc-47d8-8053-8e31af9c8311,8b8486e9-c8c3-4315-a28d-afe65e64ac15,a70f09cd-e5c8-4916-88a9-cac2ad7e7ccd,88283b54-f808-4dd3-8f17-5c2af448b8af,aa835230-e6c2-4307-b2f7-feedfa80841d,b7c0de8f-b8d5-43be-be94-47f464967aee,af7a50ec-2c86-4b63-8f45-d8affc2e5b48,2a5923b8-21d9-4960-9ec1-72f5cb174c17,d3e5f7ef-9da4-4fa7-af25-1a5222a81f37,77c82f1b-4d4f-4c9e-b03e-e2a7a07ee54a,1b12d62b-6997-4d54-b619-319440e9d13c,589a6dfd-9cb5-4f23-9ed2-77ee3918673f,c0e02a36-898b-4b73-aa88-828796cd4ccc,bc47de69-6305-43f7-9cd6-b71d94a28b96,db62bbdd-ca21-42e3-abe6-c0b3f3b09931,254e1b4f-9ff1-4a11-9550-c07035882b55,4a7570d3-643b-4565-8f02-e6a6729981c4,34840a76-1874-4210-bc5f-a6179fe4d499,00d3aefe-7a4f-4840-9f1a-d0d4f4e4b18a,cdad3a9d-cc53-425a-95db-b69fe21f469d,2d35d185-5f12-4622-87be-e1790aaeb823,b46c254d-3620-4ad8-b9f6-feae0f86b02a,190c7d8d-23b5-4587-ae35-9a722a4ff461,b603c9f4-796f-47f7-b078-e6564eeb4e37,5328f153-e164-4bc0-b4a1-6994b7270f38,d8287aed-2eb4-44cb-9ead-a2a3f206dbd4,6de25ae4-3c5d-4e4c-b2b5-c4ea5f004289,d31f81d1-24a2-475b-8a07-376b83e4fc8e,da31ebc0-2d74-45e0-bd0f-a153872eac3a,475112f8-731b-46cd-83d8-d9b1ffbe1000,ca66ef1d-fccc-460f-9a2a-9b170549832e,ad53ca52-efd9-479e-8596-a4f155d7ad19,6a30d002-5a65-45f3-b35e-a711805c5562,70cebc2f-4d7d-4524-a40b-6b7169633cfc,a1e79fae-67ba-4a73-a16a-b699fcc09468,12f56f3c-5ab7-4adb-9f84-cdb968077cb1,1e831d02-f8f0-4814-b934-97335656ae4f,827a5ae1-dd07-494b-86b3-0e3fe553fa14,14c46133-58a4-4bb6-a386-58ff1482b1a7,628c2fae-39d9-4283-8278-29ecde7590b9,58d546b4-73e6-47d0-ba77-1202166d95fa,a0937338-0bf5-4144-9712-019dc0f310e7,2aa9be8a-bbaf-430a-8890-49872a9d31f7,d74f84c0-6dfc-4e3e-9506-595f1c6ed973,39ab2dce-9b91-4756-9fd4-8a724731f47d,05e31ac5-b2f5-478b-b8a9-192047c2165d,409ebaab-1cf2-4f2f-8207-3541da182fce,7c6fd39d-5b29-4d81-ad4e-500cbb34913a,3f64ebbe-2bc7-4919-a2c3-1c04dd945fe7,3f38bb4c-88af-483f-8233-c439defa1953,992aceb0-2f22-4044-97db-6c337a044912,3cde6908-1436-4e34-bd74-5adc7d9b6f99,f5e819ef-2ebc-4ce2-b48c-4dd474b6be5a,b8844ddd-688f-4e89-91dc-4022f0992bc2,7570b40a-12ac-4b23-8629-399a8404edd2,0ab6c0fc-803d-400f-a0b4-bef608fb44d2,9176fa24-1dd9-42d3-9b23-05ba38330109,8465ecc3-f4fa-4788-8d3d-1fdb7aedecf8,1834a3f2-8335-4f62-b461-833013a6397c,69e2ca18-7f17-4f93-83cb-d3aca64ed014,e0289f6e-071a-456c-be3c-7fe4b7099a40,c30c4127-10ae-4837-95f8-df4934f7018a,a67cb04a-a665-497c-96ca-ee5b6756a791,e16c9def-d40c-4cd1-8d5c-6952defeb02b,f9467300-5780-4312-a661-921878d29b3b,760ece08-4fd0-44b6-ae5f-134be05eccd5,42a3aa6a-600a-45f7-bc3c-2acc8c009eab,3de7a29a-9d5e-4b86-8bf1-5d833d1fe269,c0e23d84-6c1e-44de-b0f6-32d9c1c48131,060af058-d8ef-4abc-8df2-d028f390081c,2f42c53d-3997-4213-9549-74cb86a6fa98,cbd2528e-1c15-4fdb-968e-3f56e79dad29,8a38d3f6-c302-491f-8aef-799a6e051d21,cefc7197-7b89-4953-af97-c6aadd127b26,c7e3bbf5-5e87-4c3f-a404-7d4e9db52a6d}'::text[]))
7. 1.722 2.316 ↑ 1.0 144 1

Hash (cost=6.44..6.44 rows=144 width=359) (actual time=2.316..2.316 rows=144 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 47kB
8. 0.594 0.594 ↑ 1.0 144 1

Seq Scan on extract_point_of_sales pointofsal1_ (cost=0.00..6.44 rows=144 width=359) (actual time=0.008..0.594 rows=144 loops=1)

Planning time : 25.603 ms
Execution time : 96.495 ms