explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HAdv

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,216.382 ↓ 252.9 64,484 1

Unique (cost=25,097.96..25,162.35 rows=255 width=2,608) (actual time=929.946..1,216.382 rows=64,484 loops=1)

2. 0.000 1,008.730 ↓ 252.9 64,484 1

Sort (cost=25,097.96..25,098.60 rows=255 width=2,608) (actual time=929.945..1,008.730 rows=64,484 loops=1)

3. 1,368.215 1,368.215 ↓ 252.9 64,484 1

Sort Key: kitchenbra0_.i Unique (cost=25,097.96..25,162.35 rows=255 width=2,608) (actual time=1,130.603..1,368.215 rows=64,484 loops=1)

4. 717.718 1,164.042 ↓ 252.9 64,484 1

Sort (cost=25,097.96..25,098.60 rows=255 width=2,608) (actual time=1,130.601..1,164.042 rows=64,484 loops=1)

  • Sort Key: kitchenbra0_.id, kitchenbra1_.id, kitchenbra2_.id, kitchenbra3_.id, timeperiod4_.day, timeperiod4_.from_time, timeperiod4_.menu_availability_setting_id, timeperiod4_.to_time, kitchenbra5_.id, kitchenbra7_.id, timeperiod8_.day, timeperiod8_.from_time, timeperiod8_.menu_availability_setting_id, timeperiod8_.to_time, kitchenbra9_.id, kitchenbra0_.entity_created, kitchenbra0_.version, kitchenbra0_.available, kitchenbra0_.order_workflow_id, kitchenbra0_.price, kitchenbra0_.tax_id, kitchenbra0_.tax_name, kitchenbra0_.tax_type, kitchenbra0_.tax_value, kitchenbra0_.updated_at, kitchenbra0_.variant_id, kitchenbra0_.variant_name, kitchenbra0_.variant_name_translations, kitchenbra0_.variant_value_id, kitchenbra0_.variant_value_label, kitchenbra0_.variant_value_label_translations, kitchenbra1_.entity_created, kitchenbra1_.version, kitchenbra1_.allowed_outside_combo, kitchenbra1_.description, kitchenbra1_.description_translations, kitchenbra1_.dynamics_id, kitchenbra1_.global_item_id, kitchenbra1_.image_uri, kitchenbra1_.menu_item_id, kitchenbra1_.menu_item_master_id, kitchenbra1_.name, kitchenbra1_.name_translations, kitchenbra1_.item_order, kitchenbra1_.out_of_stock, kitchenbra1_.station_id, kitchenbra1_.updated_at, kitchenbra2_.entity_created, kitchenbra2_.version, kitchenbra2_.availability_setting_id, kitchenbra2_.menu_category_id, kitchenbra2_.menu_category_master_id, kitchenbra2_.name, kitchenbra2_.name_translations, kitchenbra2_.category_order, kitchenbra2_.state, kitchenbra2_.updated_at, kitchenbra3_.entity_created, kitchenbra3_.version, kitchenbra3_.from_date, kitchenbra3_.menu_availability_setting_id, kitchenbra3_.open_all_day_friday, kitchenbra3_.open_all_day_monday, kitchenbra3_.open_all_day_saturday, kitchenbra3_.open_all_day_sunday, kitchenbra3_.open_all_day_thursday, kitchenbra3_.open_all_day_tuesday, kitchenbra3_.open_all_day_wednesday, kitchenbra3_.to_date, kitchenbra5_.entity_created, kitchenbra5_.version, kitchenbra5_.menu_id, kitchenbra5_.menu_master_id, kitchenbra5_.name, kitchenbra5_.name_translations, kitchenbra5_.state, kitchenbra5_.updated_at, kitchenbra7_.entity_created, kitchenbra7_.version, kitchenbra7_.from_date, kitchenbra7_.menu_availability_setting_id, kitchenbra7_.open_all_day_friday, kitchenbra7_.open_all_day_monday, kitchenbra7_.open_all_day_saturday, kitchenbra7_.open_all_day_sunday, kitchenbra7_.open_all_day_thursday, kitchenbra7_.open_all_day_tuesday, kitchenbra7_.open_all_day_wednesday, kitchenbra7_.to_date, kitchenbra9_.entity_created, kitchenbra9_.version, kitchenbra9_.abbreviation, kitchenbra9_.brand_dynamics_id, kitchenbra9_.category, kitchenbra9_.description, kitchenbra9_.image_uri, kitchenbra9_.logo_uri, kitchenbra9_.name, kitchenbra9_.state, kitchenbra9_.updated_at
  • Sort Method: external merge Disk: 143,896kB
  • Sort Method: external merge Disk: 143,968kB
5. 29.696 226.673 ↓ 252.9 64,484 1

Nested Loop Left Join (cost=5,395.19..25,087.77 rows=255 width=2,608) (actual time=45.914..226.673 rows=64,484 loops=1)

6. 11.087 173.947 ↓ 66.8 4,606 1

Hash Join (cost=5,394.91..25,027.50 rows=69 width=2,240) (actual time=45.892..173.947 rows=4,606 loops=1)

  • Hash Cond: ((kitchenbra5_.kitchen_brand_id)::text = (kitchenbra9_.id)::text)
7. 43.562 162.829 ↓ 4.0 93,841 1

Hash Left Join (cost=5,378.87..24,950.00 rows=23,268 width=1,740) (actual time=45.787..162.829 rows=93,841 loops=1)

  • Hash Cond: ((kitchenbra2_.availability_setting_id)::text = (kitchenbra3_.id)::text)
8. 9.168 116.547 ↓ 2.5 16,033 1

Hash Join (cost=5,252.43..24,543.61 rows=6,304 width=1,580) (actual time=43.036..116.547 rows=16,033 loops=1)

  • Hash Cond: ((kitchenbra5_.availability_setting_id)::text = (kitchenbra7_.id)::text)
9. 8.970 107.090 ↓ 2.5 16,033 1

Hash Join (cost=5,223.35..24,497.87 rows=6,304 width=1,481) (actual time=42.741..107.090 rows=16,033 loops=1)

  • Hash Cond: ((kitchenbra2_.kitchen_brand_menu_id)::text = (kitchenbra5_.id)::text)
10. 7.146 97.763 ↓ 2.6 16,033 1

Hash Join (cost=5,182.84..24,440.87 rows=6,246 width=1,223) (actual time=42.378..97.763 rows=16,033 loops=1)

  • Hash Cond: ((kitchenbra2_.kitchen_brand_menu_id)::text = (poses6_.kitchen_brand_menu_id)::text)
11. 10.661 90.337 ↓ 1.4 16,042 1

Hash Join (cost=5,029.24..24,256.76 rows=11,552 width=1,142) (actual time=42.091..90.337 rows=16,042 loops=1)

  • Hash Cond: ((kitchenbra1_.kitchen_brand_menu_category_id)::text = (kitchenbra2_.id)::text)
12. 21.905 75.887 ↓ 1.4 16,042 1

Hash Join (cost=4,614.77..23,811.94 rows=11,552 width=884) (actual time=38.286..75.887 rows=16,042 loops=1)

  • Hash Cond: ((kitchenbra0_.kitchen_brand_menu_item_id)::text = (kitchenbra1_.id)::text)
13. 17.324 19.920 ↓ 1.0 20,628 1

Bitmap Heap Scan on kitchen_brand_menu_pos_items kitchenbra0_ (cost=787.57..19,932.19 rows=20,019 width=380) (actual time=4.183..19.920 rows=20,628 loops=1)

  • Recheck Cond: (((point_of_sale_id)::text = '798b53ed-9dc5-4f94-88a5-24b9e61d5dfe'::text) AND available)
  • Heap Blocks: exact=12,682
14. 2.596 2.596 ↓ 1.1 22,284 1

Bitmap Index Scan on idx_tmp_kitchen_brand_menu_pos_items_pos_id_available (cost=0.00..782.56 rows=20,019 width=0) (actual time=2.596..2.596 rows=22,284 loops=1)

  • Index Cond: ((point_of_sale_id)::text = '798b53ed-9dc5-4f94-88a5-24b9e61d5dfe'::text)
15. 18.035 34.062 ↓ 1.0 29,544 1

Hash (cost=3,461.22..3,461.22 rows=29,278 width=504) (actual time=34.061..34.062 rows=29,544 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 12,299kB
16. 16.027 16.027 ↓ 1.0 29,544 1

Seq Scan on kitchen_brand_menu_items kitchenbra1_ (cost=0.00..3,461.22 rows=29,278 width=504) (actual time=0.008..16.027 rows=29,544 loops=1)

  • Filter: ((state)::text = 'ACTIVE'::text)
  • Rows Removed by Filter: 21,194
17. 2.055 3.789 ↓ 1.0 7,044 1

Hash (cost=326.43..326.43 rows=7,043 width=258) (actual time=3.789..3.789 rows=7,044 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 1,949kB
18. 1.734 1.734 ↓ 1.0 7,044 1

Seq Scan on kitchen_brand_menu_categories kitchenbra2_ (cost=0.00..326.43 rows=7,043 width=258) (actual time=0.005..1.734 rows=7,044 loops=1)

19. 0.043 0.280 ↓ 1.0 378 1

Hash (cost=148.91..148.91 rows=376 width=81) (actual time=0.280..0.280 rows=378 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 50kB
20. 0.206 0.237 ↓ 1.0 378 1

Bitmap Heap Scan on kitchen_brand_menu_point_of_sales poses6_ (cost=15.22..148.91 rows=376 width=81) (actual time=0.045..0.237 rows=378 loops=1)

  • Recheck Cond: ((point_of_sale_id)::text = '798b53ed-9dc5-4f94-88a5-24b9e61d5dfe'::text)
  • Filter: ((state)::text = 'ACTIVE'::text)
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=123
21. 0.031 0.031 ↑ 1.0 379 1

Bitmap Index Scan on idx_19852_fk_kitchen_brand_menu_point_of_sale_extract_point_of_ (cost=0.00..15.13 rows=379 width=0) (actual time=0.031..0.031 rows=379 loops=1)

  • Index Cond: ((point_of_sale_id)::text = '798b53ed-9dc5-4f94-88a5-24b9e61d5dfe'::text)
22. 0.191 0.357 ↑ 1.0 689 1

Hash (cost=31.89..31.89 rows=689 width=258) (actual time=0.357..0.357 rows=689 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 192kB
23. 0.166 0.166 ↑ 1.0 689 1

Seq Scan on kitchen_brand_menus kitchenbra5_ (cost=0.00..31.89 rows=689 width=258) (actual time=0.004..0.166 rows=689 loops=1)

24. 0.145 0.289 ↑ 1.0 715 1

Hash (cost=20.15..20.15 rows=715 width=99) (actual time=0.289..0.289 rows=715 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 102kB
25. 0.144 0.144 ↑ 1.0 715 1

Seq Scan on kitchen_brand_menu_availability_settings kitchenbra7_ (cost=0.00..20.15 rows=715 width=99) (actual time=0.005..0.144 rows=715 loops=1)

26. 1.163 2.720 ↓ 1.2 3,117 1

Hash (cost=93.45..93.45 rows=2,639 width=160) (actual time=2.720..2.720 rows=3,117 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 610kB
27. 1.060 1.557 ↓ 1.2 3,117 1

Hash Right Join (cost=29.09..93.45 rows=2,639 width=160) (actual time=0.339..1.557 rows=3,117 loops=1)

  • Hash Cond: ((timeperiod4_.menu_availability_setting_id)::text = (kitchenbra3_.id)::text)
28. 0.170 0.170 ↑ 1.0 2,639 1

Seq Scan on kitchen_brand_menu_availability_time_period_settings timeperiod4_ (cost=0.00..57.39 rows=2,639 width=61) (actual time=0.002..0.170 rows=2,639 loops=1)

29. 0.181 0.327 ↑ 1.0 715 1

Hash (cost=20.15..20.15 rows=715 width=99) (actual time=0.327..0.327 rows=715 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 102kB
30. 0.146 0.146 ↑ 1.0 715 1

Seq Scan on kitchen_brand_menu_availability_settings kitchenbra3_ (cost=0.00..20.15 rows=715 width=99) (actual time=0.009..0.146 rows=715 loops=1)

31. 0.002 0.031 ↑ 2.0 1 1

Hash (cost=16.01..16.01 rows=2 width=500) (actual time=0.031..0.031 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
32. 0.006 0.029 ↑ 2.0 1 1

Bitmap Heap Scan on kitchen_brands kitchenbra9_ (cost=9.38..16.01 rows=2 width=500) (actual time=0.028..0.029 rows=1 loops=1)

  • Recheck Cond: (((brand_id)::text = '60817b2f-b570-434a-968e-6b0b6f98c2a3'::text) AND ((kitchen_id)::text = 'f5244760-1a78-4b30-a0d4-db2177345e60'::text))
  • Heap Blocks: exact=1
33. 0.002 0.023 ↓ 0.0 0 1

BitmapAnd (cost=9.38..9.38 rows=2 width=0) (actual time=0.023..0.023 rows=0 loops=1)

34. 0.012 0.012 ↑ 1.0 20 1

Bitmap Index Scan on idx_19885_fk_kitchen_brand_brands (cost=0.00..4.43 rows=20 width=0) (actual time=0.012..0.012 rows=20 loops=1)

  • Index Cond: ((brand_id)::text = '60817b2f-b570-434a-968e-6b0b6f98c2a3'::text)
35. 0.009 0.009 ↑ 1.1 54 1

Bitmap Index Scan on idx_19885_fk_kitchen_brand_kitchens (cost=0.00..4.70 rows=57 width=0) (actual time=0.009..0.009 rows=54 loops=1)

  • Index Cond: ((kitchen_id)::text = 'f5244760-1a78-4b30-a0d4-db2177345e60'::text)
36. 23.030 23.030 ↓ 1.3 14 4,606

Index Scan using idx_19783_fk_kbm_time_perios_setting_kbm_availability_setting on kitchen_brand_menu_availability_time_period_settings timeperiod8_ (cost=0.28..0.76 rows=11 width=61) (actual time=0.003..0.005 rows=14 loops=4,606)

  • Index Cond: ((kitchenbra7_.id)::text = (menu_availability_setting_id)::text)
37. 26.996 219.651 ↓ 252.9 64,484 1

Nested Loop Left Join (cost=5,395.19..25,087.77 rows=255 width=2,608) (actual time=42.613..219.651 rows=64,484 loops=1)

38. 10.939 169.625 ↓ 66.8 4,606 1

Hash Join (cost=5,394.91..25,027.50 rows=69 width=2,240) (actual time=42.593..169.625 rows=4,606 loops=1)

  • Hash Cond: ((kitchenbra5_.kitchen_brand_id)::text = (kitchenbra9_.id)::text)
39. 42.745 158.657 ↓ 4.0 93,841 1

Hash Left Join (cost=5,378.87..24,950.00 rows=23,268 width=1,740) (actual time=42.507..158.657 rows=93,841 loops=1)

  • Hash Cond: ((kitchenbra2_.availability_setting_id)::text = (kitchenbra3_.id)::text)
40. 9.179 113.326 ↓ 2.5 16,033 1

Hash Join (cost=5,252.43..24,543.61 rows=6,304 width=1,580) (actual time=39.897..113.326 rows=16,033 loops=1)

  • Hash Cond: ((kitchenbra5_.availability_setting_id)::text = (kitchenbra7_.id)::text)
41. 9.040 103.856 ↓ 2.5 16,033 1

Hash Join (cost=5,223.35..24,497.87 rows=6,304 width=1,481) (actual time=39.599..103.856 rows=16,033 loops=1)

  • Hash Cond: ((kitchenbra2_.kitchen_brand_menu_id)::text = (kitchenbra5_.id)::text)
42. 7.204 94.463 ↓ 2.6 16,033 1

Hash Join (cost=5,182.84..24,440.87 rows=6,246 width=1,223) (actual time=39.239..94.463 rows=16,033 loops=1)

  • Hash Cond: ((kitchenbra2_.kitchen_brand_menu_id)::text = (poses6_.kitchen_brand_menu_id)::text)
43. 10.669 86.984 ↓ 1.4 16,042 1

Hash Join (cost=5,029.24..24,256.76 rows=11,552 width=1,142) (actual time=38.957..86.984 rows=16,042 loops=1)

  • Hash Cond: ((kitchenbra1_.kitchen_brand_menu_category_id)::text = (kitchenbra2_.id)::text)
44. 21.678 72.558 ↓ 1.4 16,042 1

Hash Join (cost=4,614.77..23,811.94 rows=11,552 width=884) (actual time=35.185..72.558 rows=16,042 loops=1)

  • Hash Cond: ((kitchenbra0_.kitchen_brand_menu_item_id)::text = (kitchenbra1_.id)::text)
45. 17.273 19.621 ↓ 1.0 20,628 1

Bitmap Heap Scan on kitchen_brand_menu_pos_items kitchenbra0_ (cost=787.57..19,932.19 rows=20,019 width=380) (actual time=3.886..19.621 rows=20,628 loops=1)

  • Recheck Cond: (((point_of_sale_id)::text = '798b53ed-9dc5-4f94-88a5-24b9e61d5dfe'::text) AND available)
  • Heap Blocks: exact=12,682
46. 2.348 2.348 ↓ 1.1 22,284 1

Bitmap Index Scan on idx_tmp_kitchen_brand_menu_pos_items_pos_id_available (cost=0.00..782.56 rows=20,019 width=0) (actual time=2.348..2.348 rows=22,284 loops=1)

  • Index Cond: ((point_of_sale_id)::text = '798b53ed-9dc5-4f94-88a5-24b9e61d5dfe'::text)
47. 15.531 31.259 ↓ 1.0 29,544 1

Hash (cost=3,461.22..3,461.22 rows=29,278 width=504) (actual time=31.259..31.259 rows=29,544 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 12,299kB
48. 15.728 15.728 ↓ 1.0 29,544 1

Seq Scan on kitchen_brand_menu_items kitchenbra1_ (cost=0.00..3,461.22 rows=29,278 width=504) (actual time=0.008..15.728 rows=29,544 loops=1)

  • Filter: ((state)::text = 'ACTIVE'::text)
  • Rows Removed by Filter: 21,194
49. 2.057 3.757 ↓ 1.0 7,044 1

Hash (cost=326.43..326.43 rows=7,043 width=258) (actual time=3.757..3.757 rows=7,044 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 1,949kB
50. 1.700 1.700 ↓ 1.0 7,044 1

Seq Scan on kitchen_brand_menu_categories kitchenbra2_ (cost=0.00..326.43 rows=7,043 width=258) (actual time=0.005..1.700 rows=7,044 loops=1)

51. 0.043 0.275 ↓ 1.0 378 1

Hash (cost=148.91..148.91 rows=376 width=81) (actual time=0.275..0.275 rows=378 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 50kB
52. 0.201 0.232 ↓ 1.0 378 1

Bitmap Heap Scan on kitchen_brand_menu_point_of_sales poses6_ (cost=15.22..148.91 rows=376 width=81) (actual time=0.044..0.232 rows=378 loops=1)

  • Recheck Cond: ((point_of_sale_id)::text = '798b53ed-9dc5-4f94-88a5-24b9e61d5dfe'::text)
  • Filter: ((state)::text = 'ACTIVE'::text)
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=123
53. 0.031 0.031 ↑ 1.0 379 1

Bitmap Index Scan on idx_19852_fk_kitchen_brand_menu_point_of_sale_extract_point_of_ (cost=0.00..15.13 rows=379 width=0) (actual time=0.031..0.031 rows=379 loops=1)

  • Index Cond: ((point_of_sale_id)::text = '798b53ed-9dc5-4f94-88a5-24b9e61d5dfe'::text)
54. 0.190 0.353 ↑ 1.0 689 1

Hash (cost=31.89..31.89 rows=689 width=258) (actual time=0.353..0.353 rows=689 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 192kB
55. 0.163 0.163 ↑ 1.0 689 1

Seq Scan on kitchen_brand_menus kitchenbra5_ (cost=0.00..31.89 rows=689 width=258) (actual time=0.004..0.163 rows=689 loops=1)

56. 0.144 0.291 ↑ 1.0 715 1

Hash (cost=20.15..20.15 rows=715 width=99) (actual time=0.291..0.291 rows=715 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 102kB
57. 0.147 0.147 ↑ 1.0 715 1

Seq Scan on kitchen_brand_menu_availability_settings kitchenbra7_ (cost=0.00..20.15 rows=715 width=99) (actual time=0.005..0.147 rows=715 loops=1)

58. 1.072 2.586 ↓ 1.2 3,117 1

Hash (cost=93.45..93.45 rows=2,639 width=160) (actual time=2.586..2.586 rows=3,117 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 610kB
59. 1.012 1.514 ↓ 1.2 3,117 1

Hash Right Join (cost=29.09..93.45 rows=2,639 width=160) (actual time=0.342..1.514 rows=3,117 loops=1)

  • Hash Cond: ((timeperiod4_.menu_availability_setting_id)::text = (kitchenbra3_.id)::text)
60. 0.171 0.171 ↑ 1.0 2,639 1

Seq Scan on kitchen_brand_menu_availability_time_period_settings timeperiod4_ (cost=0.00..57.39 rows=2,639 width=61) (actual time=0.002..0.171 rows=2,639 loops=1)

61. 0.184 0.331 ↑ 1.0 715 1

Hash (cost=20.15..20.15 rows=715 width=99) (actual time=0.331..0.331 rows=715 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 102kB
62. 0.147 0.147 ↑ 1.0 715 1

Seq Scan on kitchen_brand_menu_availability_settings kitchenbra3_ (cost=0.00..20.15 rows=715 width=99) (actual time=0.008..0.147 rows=715 loops=1)

63. 0.002 0.029 ↑ 2.0 1 1

Hash (cost=16.01..16.01 rows=2 width=500) (actual time=0.029..0.029 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
64. 0.005 0.027 ↑ 2.0 1 1

Bitmap Heap Scan on kitchen_brands kitchenbra9_ (cost=9.38..16.01 rows=2 width=500) (actual time=0.027..0.027 rows=1 loops=1)

  • Recheck Cond: (((brand_id)::text = '60817b2f-b570-434a-968e-6b0b6f98c2a3'::text) AND ((kitchen_id)::text = 'f5244760-1a78-4b30-a0d4-db2177345e60'::text))
  • Heap Blocks: exact=1
65. 0.001 0.022 ↓ 0.0 0 1

BitmapAnd (cost=9.38..9.38 rows=2 width=0) (actual time=0.022..0.022 rows=0 loops=1)

66. 0.012 0.012 ↑ 1.0 20 1

Bitmap Index Scan on idx_19885_fk_kitchen_brand_brands (cost=0.00..4.43 rows=20 width=0) (actual time=0.011..0.012 rows=20 loops=1)

  • Index Cond: ((brand_id)::text = '60817b2f-b570-434a-968e-6b0b6f98c2a3'::text)
67. 0.009 0.009 ↑ 1.1 54 1

Bitmap Index Scan on idx_19885_fk_kitchen_brand_kitchens (cost=0.00..4.70 rows=57 width=0) (actual time=0.009..0.009 rows=54 loops=1)

  • Index Cond: ((kitchen_id)::text = 'f5244760-1a78-4b30-a0d4-db2177345e60'::text)
68. 23.030 23.030 ↓ 1.3 14 4,606

Index Scan using idx_19783_fk_kbm_time_perios_setting_kbm_availability_setting on kitchen_brand_menu_availability_time_period_settings timeperiod8_ (cost=0.28..0.76 rows=11 width=61) (actual time=0.003..0.005 rows=14 loops=4,606)

  • Index Cond: ((kitchenbra7_.id)::text = (menu_availability_setting_id)::text)
Planning time : 13.748 ms
Execution time : 1,243.014 ms