explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CW85

Settings
# exclusive inclusive rows x rows loops node
1. 499.710 706.422 ↑ 9.6 964,575 1

Merge Join (cost=10,173.85..289,526.18 rows=9,298,824 width=4) (actual time=48.367..706.422 rows=964,575 loops=1)

  • Merge Cond: ((CASE WHEN ((vs.incorrect_id)::text = ''::text) THEN 0 ELSE (vs.incorrect_id)::integer END) = sc.drug_id)
2. 18.155 33.324 ↑ 1.0 31,009 1

Sort (cost=3,108.47..3,185.99 rows=31,009 width=12) (actual time=26.346..33.324 rows=31,009 loops=1)

  • Sort Key: (CASE WHEN ((vs.incorrect_id)::text = ''::text) THEN 0 ELSE (vs.incorrect_id)::integer END)
  • Sort Method: quicksort Memory: 3109kB
3. 15.169 15.169 ↑ 1.0 31,009 1

Seq Scan on v_stock_mapping_temp vs (cost=0.00..795.13 rows=31,009 width=12) (actual time=0.019..15.169 rows=31,009 loops=1)

  • Filter: (((correct_id IS NOT NULL) OR ((correct_id)::text <> ''::text)) AND (((incorrect_id)::text <> ''::text) OR (incorrect_id IS NOT NULL)))
4. 159.579 173.388 ↓ 16.1 964,576 1

Sort (cost=7,065.38..7,215.32 rows=59,975 width=4) (actual time=21.935..173.388 rows=964,576 loops=1)

  • Sort Key: sc.drug_id
  • Sort Method: quicksort Memory: 2013kB
5. 6.396 13.809 ↑ 2.3 26,591 1

Append (cost=0.00..2,305.74 rows=59,975 width=4) (actual time=0.016..13.809 rows=26,591 loops=1)

6. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on stock_count sc (cost=0.00..0.00 rows=1 width=4) (actual time=0.008..0.008 rows=0 loops=1)

7. 0.190 0.190 ↑ 1.3 535 1

Seq Scan on _3a_health_pharm_ltd sc_1 (cost=0.00..42.20 rows=720 width=4) (actual time=0.007..0.190 rows=535 loops=1)

8. 0.068 0.068 ↑ 2.0 223 1

Seq Scan on _3a_health sc_2 (cost=0.00..12.46 rows=446 width=4) (actual time=0.005..0.068 rows=223 loops=1)

9. 0.067 0.067 ↑ 2.0 223 1

Seq Scan on _3a_health_2 sc_3 (cost=0.00..12.46 rows=446 width=4) (actual time=0.005..0.067 rows=223 loops=1)

10. 0.069 0.069 ↑ 2.0 223 1

Seq Scan on _3a_health_3 sc_4 (cost=0.00..12.46 rows=446 width=4) (actual time=0.005..0.069 rows=223 loops=1)

11. 0.071 0.071 ↑ 1.8 223 1

Seq Scan on _3a_health_pharmacy_north_kaneshie sc_5 (cost=0.00..13.01 rows=401 width=4) (actual time=0.005..0.071 rows=223 loops=1)

12. 0.071 0.071 ↑ 1.8 223 1

Seq Scan on _3a_health_pharm_ltd_nungua sc_6 (cost=0.00..13.01 rows=401 width=4) (actual time=0.005..0.071 rows=223 loops=1)

13. 0.054 0.054 ↑ 2.0 170 1

Seq Scan on _3rd_gate_pharmacy sc_7 (cost=0.00..9.40 rows=340 width=4) (actual time=0.006..0.054 rows=170 loops=1)

14. 0.105 0.105 ↑ 1.9 357 1

Seq Scan on _at_home_pharmacy sc_8 (cost=0.00..19.63 rows=663 width=4) (actual time=0.005..0.105 rows=357 loops=1)

15. 0.006 0.006 ↑ 41.7 6 1

Seq Scan on _ababio_memorial_clinic sc_9 (cost=0.00..12.50 rows=250 width=4) (actual time=0.004..0.006 rows=6 loops=1)

16. 0.008 0.008 ↑ 1.0 24 1

Seq Scan on _abuakwa_pharmacy sc_10 (cost=0.00..1.24 rows=24 width=4) (actual time=0.004..0.008 rows=24 loops=1)

17. 0.050 0.050 ↑ 1.0 166 1

Seq Scan on _acacia_medical_centre sc_11 (cost=0.00..6.66 rows=166 width=4) (actual time=0.005..0.050 rows=166 loops=1)

18. 0.006 0.006 ↑ 1.0 14 1

Seq Scan on _acrecity_medical_centre sc_12 (cost=0.00..1.14 rows=14 width=4) (actual time=0.003..0.006 rows=14 loops=1)

19. 0.012 0.012 ↑ 9.7 38 1

Seq Scan on _aide_warehouse sc_13 (cost=0.00..13.70 rows=370 width=4) (actual time=0.005..0.012 rows=38 loops=1)

20. 0.014 0.014 ↑ 9.2 38 1

Seq Scan on _aide_chemist_koforidua sc_14 (cost=0.00..13.50 rows=350 width=4) (actual time=0.005..0.014 rows=38 loops=1)

21. 0.011 0.011 ↑ 9.2 38 1

Seq Scan on _aide_chemist_ogbojo sc_15 (cost=0.00..13.50 rows=350 width=4) (actual time=0.004..0.011 rows=38 loops=1)

22. 0.012 0.012 ↑ 8.9 38 1

Seq Scan on _aide_chemist_rawlings_circle sc_16 (cost=0.00..13.40 rows=340 width=4) (actual time=0.003..0.012 rows=38 loops=1)

23. 0.011 0.011 ↑ 8.9 38 1

Seq Scan on _aide_chemist_ritz_junction sc_17 (cost=0.00..13.40 rows=340 width=4) (actual time=0.004..0.011 rows=38 loops=1)

24. 0.012 0.012 ↑ 9.2 38 1

Seq Scan on _aide_chemist_sakaman sc_18 (cost=0.00..13.50 rows=350 width=4) (actual time=0.005..0.012 rows=38 loops=1)

25. 0.011 0.011 ↑ 9.2 38 1

Seq Scan on _aide_chemist_korle_gono sc_19 (cost=0.00..13.50 rows=350 width=4) (actual time=0.004..0.011 rows=38 loops=1)

26. 0.010 0.010 ↑ 9.7 38 1

Seq Scan on _total_aide sc_20 (cost=0.00..13.70 rows=370 width=4) (actual time=0.004..0.010 rows=38 loops=1)

27. 0.013 0.013 ↑ 1.0 40 1

Seq Scan on _aide_chemist_adenta sc_21 (cost=0.00..1.40 rows=40 width=4) (actual time=0.005..0.013 rows=40 loops=1)

28. 0.011 0.011 ↑ 9.2 38 1

Seq Scan on _aide_chemist_atomic sc_22 (cost=0.00..13.50 rows=350 width=4) (actual time=0.005..0.011 rows=38 loops=1)

29. 0.013 0.013 ↑ 9.2 38 1

Seq Scan on _aide_chemist_ashiyie sc_23 (cost=0.00..13.50 rows=350 width=4) (actual time=0.005..0.013 rows=38 loops=1)

30. 0.012 0.012 ↑ 9.2 38 1

Seq Scan on _aide_chemist_batshona sc_24 (cost=0.00..13.50 rows=350 width=4) (actual time=0.004..0.012 rows=38 loops=1)

31. 0.013 0.013 ↑ 9.5 38 1

Seq Scan on _aide_chemist_botwe sc_25 (cost=0.00..13.60 rows=360 width=4) (actual time=0.004..0.013 rows=38 loops=1)

32. 0.012 0.012 ↑ 9.5 38 1

Seq Scan on _aide_chemist_tema sc_26 (cost=0.00..13.60 rows=360 width=4) (actual time=0.005..0.012 rows=38 loops=1)

33. 0.012 0.012 ↑ 9.2 38 1

Seq Scan on _aide_chemist_dependable sc_27 (cost=0.00..13.50 rows=350 width=4) (actual time=0.004..0.012 rows=38 loops=1)

34. 0.013 0.013 ↑ 9.2 38 1

Seq Scan on _aide_chemist_mathaeko sc_28 (cost=0.00..13.50 rows=350 width=4) (actual time=0.005..0.013 rows=38 loops=1)

35. 0.011 0.011 ↑ 8.9 38 1

Seq Scan on _aide_chemist_zongo_junction sc_29 (cost=0.00..13.40 rows=340 width=4) (actual time=0.005..0.011 rows=38 loops=1)

36. 0.047 0.047 ↑ 1.0 183 1

Seq Scan on _airport_women_s_hospital sc_30 (cost=0.00..5.83 rows=183 width=4) (actual time=0.005..0.047 rows=183 loops=1)

37. 0.010 0.010 ↑ 1.0 30 1

Seq Scan on _akpabe_pharmacy sc_31 (cost=0.00..1.30 rows=30 width=4) (actual time=0.004..0.010 rows=30 loops=1)

38. 0.030 0.030 ↑ 1.0 108 1

Seq Scan on _alamanda_pharmacy sc_32 (cost=0.00..3.08 rows=108 width=4) (actual time=0.005..0.030 rows=108 loops=1)

39. 0.003 0.003 ↑ 83.3 3 1

Seq Scan on _albany_specialist_clinic sc_33 (cost=0.00..12.50 rows=250 width=4) (actual time=0.003..0.003 rows=3 loops=1)

40. 0.006 0.006 ↑ 17.9 14 1

Seq Scan on _allen_clinic sc_34 (cost=0.00..12.50 rows=250 width=4) (actual time=0.004..0.006 rows=14 loops=1)

41. 0.044 0.044 ↑ 1.0 166 1

Seq Scan on _amby_chemist_ltd sc_35 (cost=0.00..4.66 rows=166 width=4) (actual time=0.005..0.044 rows=166 loops=1)

42. 0.003 0.003 ↑ 41.7 6 1

Seq Scan on _american_international_hospital sc_36 (cost=0.00..12.50 rows=250 width=4) (actual time=0.003..0.003 rows=6 loops=1)

43. 0.023 0.023 ↑ 1.0 81 1

Seq Scan on _anstand_chemists_ltd_assin_fosu sc_37 (cost=0.00..2.81 rows=81 width=4) (actual time=0.005..0.023 rows=81 loops=1)

44. 0.020 0.020 ↑ 1.0 81 1

Seq Scan on _anstand_chemists_ltd_kumasi sc_38 (cost=0.00..2.81 rows=81 width=4) (actual time=0.005..0.020 rows=81 loops=1)

45. 0.003 0.003 ↑ 83.3 3 1

Seq Scan on _anwiam_hospital sc_39 (cost=0.00..12.50 rows=250 width=4) (actual time=0.003..0.003 rows=3 loops=1)

46. 0.017 0.017 ↑ 1.0 62 1

Seq Scan on _asbury_hospital_fertility_centre sc_40 (cost=0.00..2.62 rows=62 width=4) (actual time=0.005..0.017 rows=62 loops=1)

47. 0.010 0.010 ↑ 9.2 38 1

Seq Scan on _bcodco_pharmacy_ltd sc_41 (cost=0.00..13.50 rows=350 width=4) (actual time=0.004..0.010 rows=38 loops=1)

48. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on _bemuah_hospital sc_42 (cost=0.00..12.50 rows=250 width=4) (actual time=0.002..0.003 rows=0 loops=1)

49. 0.033 0.033 ↑ 1.0 132 1

Seq Scan on _biolink_pharmacy sc_43 (cost=0.00..4.32 rows=132 width=4) (actual time=0.004..0.033 rows=132 loops=1)

50. 0.034 0.034 ↑ 1.0 132 1

Seq Scan on _biolink_pharmacy_ayikuma_branch sc_44 (cost=0.00..4.32 rows=132 width=4) (actual time=0.005..0.034 rows=132 loops=1)

51. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _blue_valley_specialist_hospital sc_45 (cost=0.00..12.50 rows=250 width=4) (actual time=0.002..0.002 rows=0 loops=1)

52. 0.011 0.011 ↑ 9.4 36 1

Seq Scan on _briteaid_health_kumasi sc_46 (cost=0.00..13.40 rows=340 width=4) (actual time=0.004..0.011 rows=36 loops=1)

53. 0.012 0.012 ↑ 9.7 36 1

Seq Scan on _briteaid_health sc_47 (cost=0.00..13.50 rows=350 width=4) (actual time=0.004..0.012 rows=36 loops=1)

54. 0.182 0.182 ↑ 1.0 621 1

Seq Scan on _centrixmas_pharmacy sc_48 (cost=0.00..20.21 rows=621 width=4) (actual time=0.007..0.182 rows=621 loops=1)

55. 0.061 0.061 ↑ 1.0 213 1

Seq Scan on _calvary_central_pharmacy sc_49 (cost=0.00..8.13 rows=213 width=4) (actual time=0.005..0.061 rows=213 loops=1)

56. 0.004 0.004 ↑ 31.2 8 1

Seq Scan on _cardinal_chemist sc_50 (cost=0.00..12.50 rows=250 width=4) (actual time=0.003..0.004 rows=8 loops=1)

57. 0.008 0.008 ↑ 1.0 18 1

Seq Scan on _care360 sc_51 (cost=0.00..1.18 rows=18 width=4) (actual time=0.004..0.008 rows=18 loops=1)

58. 0.016 0.016 ↑ 1.0 52 1

Seq Scan on _center_for_health_and_rejuvenation_actio sc_52 (cost=0.00..2.52 rows=52 width=4) (actual time=0.005..0.016 rows=52 loops=1)

59. 0.028 0.028 ↑ 1.0 95 1

Seq Scan on _chaneck_pharmacy sc_53 (cost=0.00..2.95 rows=95 width=4) (actual time=0.004..0.028 rows=95 loops=1)

60. 0.167 0.167 ↑ 1.0 590 1

Seq Scan on _charis_pharmacy sc_54 (cost=0.00..26.90 rows=590 width=4) (actual time=0.006..0.167 rows=590 loops=1)

61. 0.011 0.011 ↑ 1.0 33 1

Seq Scan on _chelebee_pharmacy_ltd sc_55 (cost=0.00..1.33 rows=33 width=4) (actual time=0.005..0.011 rows=33 loops=1)

62. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _citycare_pharmacy sc_56 (cost=0.00..13.60 rows=360 width=4) (actual time=0.002..0.002 rows=0 loops=1)

63. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _claron_hospital sc_57 (cost=0.00..13.60 rows=360 width=4) (actual time=0.002..0.002 rows=0 loops=1)

64. 0.006 0.006 ↑ 35.7 7 1

Seq Scan on _community_hospital sc_58 (cost=0.00..12.50 rows=250 width=4) (actual time=0.003..0.006 rows=7 loops=1)

65. 0.043 0.043 ↑ 1.0 156 1

Seq Scan on _cosmopolitan_medical_centre sc_59 (cost=0.00..5.56 rows=156 width=4) (actual time=0.005..0.043 rows=156 loops=1)

66. 0.034 0.034 ↑ 1.0 137 1

Seq Scan on _cross_road_healthcare sc_60 (cost=0.00..4.37 rows=137 width=4) (actual time=0.004..0.034 rows=137 loops=1)

67. 0.007 0.007 ↑ 24.7 15 1

Seq Scan on _crown_medical sc_61 (cost=0.00..13.70 rows=370 width=4) (actual time=0.003..0.007 rows=15 loops=1)

68. 0.083 0.083 ↑ 1.0 337 1

Seq Scan on _cure_pharmacy sc_62 (cost=0.00..9.37 rows=337 width=4) (actual time=0.005..0.083 rows=337 loops=1)

69. 0.021 0.021 ↑ 1.0 79 1

Seq Scan on _cyrex_pharmacy sc_63 (cost=0.00..2.79 rows=79 width=4) (actual time=0.004..0.021 rows=79 loops=1)

70. 0.202 0.202 ↓ 1.0 742 1

Seq Scan on _daelyn_pharmacy sc_64 (cost=0.00..29.28 rows=728 width=4) (actual time=0.005..0.202 rows=742 loops=1)

71. 0.026 0.026 ↑ 1.0 95 1

Seq Scan on _danstel_pharmacy sc_65 (cost=0.00..2.95 rows=95 width=4) (actual time=0.006..0.026 rows=95 loops=1)

72. 0.023 0.023 ↑ 1.0 78 1

Seq Scan on _day_by_day_pharmacy sc_66 (cost=0.00..2.78 rows=78 width=4) (actual time=0.005..0.023 rows=78 loops=1)

73. 0.008 0.008 ↑ 1.0 19 1

Seq Scan on _dayden_pharmacy sc_67 (cost=0.00..1.19 rows=19 width=4) (actual time=0.004..0.008 rows=19 loops=1)

74. 0.037 0.037 ↑ 1.0 131 1

Seq Scan on _doctors_in_service sc_68 (cost=0.00..4.31 rows=131 width=4) (actual time=0.005..0.037 rows=131 loops=1)

75. 0.036 0.036 ↑ 1.0 131 1

Seq Scan on _doctor_in_service_dis_takoradi sc_69 (cost=0.00..4.31 rows=131 width=4) (actual time=0.005..0.036 rows=131 loops=1)

76. 0.015 0.015 ↑ 1.0 50 1

Seq Scan on _dreamguard_pharmacy sc_70 (cost=0.00..1.50 rows=50 width=4) (actual time=0.005..0.015 rows=50 loops=1)

77. 0.013 0.013 ↑ 1.0 49 1

Seq Scan on _e_and_e_medical_centre sc_71 (cost=0.00..1.49 rows=49 width=4) (actual time=0.004..0.013 rows=49 loops=1)

78. 0.029 0.029 ↑ 1.0 114 1

Seq Scan on _east_wing_clinic sc_72 (cost=0.00..3.14 rows=114 width=4) (actual time=0.006..0.029 rows=114 loops=1)

79. 0.031 0.031 ↑ 1.0 114 1

Seq Scan on _eckstary_pharmacy sc_73 (cost=0.00..3.14 rows=114 width=4) (actual time=0.004..0.031 rows=114 loops=1)

80. 0.092 0.092 ↑ 1.0 365 1

Seq Scan on _emboch_chemist sc_74 (cost=0.00..9.65 rows=365 width=4) (actual time=0.005..0.092 rows=365 loops=1)

81. 0.005 0.005 ↑ 50.0 5 1

Seq Scan on _engen_pharmacy sc_75 (cost=0.00..12.50 rows=250 width=4) (actual time=0.003..0.005 rows=5 loops=1)

82. 0.045 0.045 ↑ 1.0 176 1

Seq Scan on _enise_pharmacy sc_76 (cost=0.00..4.76 rows=176 width=4) (actual time=0.005..0.045 rows=176 loops=1)

83. 0.118 0.118 ↓ 1.0 470 1

Seq Scan on _equity_2_east_legon sc_77 (cost=0.00..14.69 rows=469 width=4) (actual time=0.005..0.118 rows=470 loops=1)

84. 0.114 0.114 ↑ 1.0 468 1

Seq Scan on _equity_5_westland sc_78 (cost=0.00..13.68 rows=468 width=4) (actual time=0.005..0.114 rows=468 loops=1)

85. 0.148 0.148 ↑ 1.0 468 1

Seq Scan on _equity_total sc_79 (cost=0.00..13.68 rows=468 width=4) (actual time=0.005..0.148 rows=468 loops=1)

86. 0.126 0.126 ↑ 1.0 468 1

Seq Scan on _equity_1_french_school sc_80 (cost=0.00..13.68 rows=468 width=4) (actual time=0.005..0.126 rows=468 loops=1)

87. 0.117 0.117 ↑ 1.0 468 1

Seq Scan on _equity_4_ghana_canada sc_81 (cost=0.00..13.68 rows=468 width=4) (actual time=0.004..0.117 rows=468 loops=1)

88. 0.111 0.111 ↑ 1.0 468 1

Seq Scan on _equity_3_okponglo sc_82 (cost=0.00..13.68 rows=468 width=4) (actual time=0.004..0.111 rows=468 loops=1)

89. 0.118 0.118 ↑ 1.0 468 1

Seq Scan on _equity_east_legon_2 sc_83 (cost=0.00..13.68 rows=468 width=4) (actual time=0.008..0.118 rows=468 loops=1)

90. 0.012 0.012 ↑ 1.0 42 1

Seq Scan on _erama_pharmacy sc_84 (cost=0.00..1.42 rows=42 width=4) (actual time=0.005..0.012 rows=42 loops=1)

91. 0.076 0.076 ↑ 1.0 294 1

Seq Scan on _espana_pharmacy_mateheko sc_85 (cost=0.00..8.94 rows=294 width=4) (actual time=0.005..0.076 rows=294 loops=1)

92. 0.018 0.018 ↑ 1.0 56 1

Seq Scan on _euracare sc_86 (cost=0.00..1.56 rows=56 width=4) (actual time=0.007..0.018 rows=56 loops=1)

93. 0.030 0.030 ↑ 1.0 122 1

Seq Scan on _express_life_healthcare_pharmacy_achimota_mall_ sc_87 (cost=0.00..4.22 rows=122 width=4) (actual time=0.005..0.030 rows=122 loops=1)

94. 0.048 0.048 ↑ 1.0 218 1

Seq Scan on _fabby_chemist sc_88 (cost=0.00..6.18 rows=218 width=4) (actual time=0.006..0.048 rows=218 loops=1)

95. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _family_care_pharmacy sc_89 (cost=0.00..13.50 rows=350 width=4) (actual time=0.001..0.001 rows=0 loops=1)

96. 0.069 0.069 ↑ 1.0 276 1

Seq Scan on _familymeds_pharmacy sc_90 (cost=0.00..8.76 rows=276 width=4) (actual time=0.004..0.069 rows=276 loops=1)

97. 0.079 0.079 ↑ 1.0 312 1

Seq Scan on _famog_pharmacy sc_91 (cost=0.00..9.12 rows=312 width=4) (actual time=0.005..0.079 rows=312 loops=1)

98. 0.014 0.014 ↑ 1.0 52 1

Seq Scan on _finney_hospital sc_92 (cost=0.00..1.52 rows=52 width=4) (actual time=0.005..0.014 rows=52 loops=1)

99. 0.104 0.104 ↓ 1.0 386 1

Seq Scan on _francdor_pharmacy sc_93 (cost=0.00..10.85 rows=385 width=4) (actual time=0.005..0.104 rows=386 loops=1)

100. 0.168 0.168 ↓ 1.0 613 1

Seq Scan on _free_mart_pharmacy sc_94 (cost=0.00..22.06 rows=606 width=4) (actual time=0.005..0.168 rows=613 loops=1)

101. 0.239 0.239 ↑ 1.0 889 1

Seq Scan on _fresh_spring_chemists_ltd sc_95 (cost=0.00..37.15 rows=915 width=4) (actual time=0.005..0.239 rows=889 loops=1)

102. 0.055 0.055 ↑ 1.0 230 1

Seq Scan on _g_a_pharmacy sc_96 (cost=0.00..6.30 rows=230 width=4) (actual time=0.004..0.055 rows=230 loops=1)

103. 0.015 0.015 ↑ 1.0 52 1

Seq Scan on _gary_marvin_hospital sc_97 (cost=0.00..1.52 rows=52 width=4) (actual time=0.005..0.015 rows=52 loops=1)

104. 0.048 0.048 ↑ 1.0 153 1

Seq Scan on _gilead_medical_and_dental_center sc_98 (cost=0.00..5.53 rows=153 width=4) (actual time=0.004..0.048 rows=153 loops=1)

105. 0.047 0.047 ↑ 1.0 186 1

Seq Scan on _glomax_pharmacy_ltd sc_99 (cost=0.00..5.86 rows=186 width=4) (actual time=0.005..0.047 rows=186 loops=1)

106. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _graceside_hospital sc_100 (cost=0.00..12.50 rows=250 width=4) (actual time=0.002..0.002 rows=0 loops=1)

107. 0.046 0.046 ↑ 1.0 180 1

Seq Scan on _graphic_clinic sc_101 (cost=0.00..4.80 rows=180 width=4) (actual time=0.005..0.046 rows=180 loops=1)

108. 0.029 0.029 ↑ 1.0 102 1

Seq Scan on _hag_medical_centre sc_102 (cost=0.00..3.02 rows=102 width=4) (actual time=0.006..0.029 rows=102 loops=1)

109. 0.010 0.010 ↑ 1.0 36 1

Seq Scan on _hapres_pharmacy_ltd sc_103 (cost=0.00..1.36 rows=36 width=4) (actual time=0.004..0.010 rows=36 loops=1)

110. 0.034 0.034 ↑ 1.0 138 1

Seq Scan on _healthlane_pharmacy sc_104 (cost=0.00..4.38 rows=138 width=4) (actual time=0.005..0.034 rows=138 loops=1)

111. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _healthnet_airport sc_105 (cost=0.00..12.50 rows=250 width=4) (actual time=0.001..0.001 rows=0 loops=1)

112. 0.010 0.010 ↑ 1.0 29 1

Seq Scan on _healthnet_osu sc_106 (cost=0.00..1.29 rows=29 width=4) (actual time=0.004..0.010 rows=29 loops=1)

113. 0.018 0.018 ↑ 1.0 70 1

Seq Scan on _healthwise_medical_center sc_107 (cost=0.00..2.70 rows=70 width=4) (actual time=0.005..0.018 rows=70 loops=1)

114. 0.042 0.042 ↑ 1.0 160 1

Seq Scan on _hobem_clinic sc_108 (cost=0.00..4.60 rows=160 width=4) (actual time=0.004..0.042 rows=160 loops=1)

115. 0.146 0.146 ↓ 1.0 551 1

Seq Scan on _immaculate_pharmacy sc_109 (cost=0.00..17.45 rows=545 width=4) (actual time=0.006..0.146 rows=551 loops=1)

116. 0.012 0.012 ↑ 1.0 45 1

Seq Scan on _impact_clinic sc_110 (cost=0.00..1.45 rows=45 width=4) (actual time=0.005..0.012 rows=45 loops=1)

117. 0.006 0.006 ↑ 22.7 11 1

Seq Scan on _jubail_hospital sc_111 (cost=0.00..12.50 rows=250 width=4) (actual time=0.004..0.006 rows=11 loops=1)

118. 0.037 0.037 ↓ 1.0 149 1

Seq Scan on _kaps_pharmacy sc_112 (cost=0.00..4.47 rows=147 width=4) (actual time=0.005..0.037 rows=149 loops=1)

119. 0.010 0.010 ↑ 1.0 26 1

Seq Scan on _knust_hospital sc_113 (cost=0.00..1.26 rows=26 width=4) (actual time=0.004..0.010 rows=26 loops=1)

120. 0.010 0.010 ↑ 1.0 35 1

Seq Scan on _kems_clinic sc_114 (cost=0.00..1.35 rows=35 width=4) (actual time=0.004..0.010 rows=35 loops=1)

121. 0.034 0.034 ↑ 1.0 132 1

Seq Scan on _kendicks_pharmacy sc_115 (cost=0.00..4.32 rows=132 width=4) (actual time=0.006..0.034 rows=132 loops=1)

122. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _kess_pharmacy_ltd sc_116 (cost=0.00..12.50 rows=250 width=4) (actual time=0.002..0.002 rows=0 loops=1)

123. 0.154 0.154 ↓ 1.0 561 1

Seq Scan on _king_mirror_pharmacy sc_117 (cost=0.00..22.55 rows=555 width=4) (actual time=0.005..0.154 rows=561 loops=1)

124. 0.023 0.023 ↑ 1.0 75 1

Seq Scan on _kwabenya_community_hospital sc_118 (cost=0.00..2.75 rows=75 width=4) (actual time=0.006..0.023 rows=75 loops=1)

125. 0.006 0.006 ↑ 20.6 16 1

Seq Scan on _kwady_chemist_comm_11_branch sc_119 (cost=0.00..13.30 rows=330 width=4) (actual time=0.003..0.006 rows=16 loops=1)

126. 0.006 0.006 ↑ 1.0 16 1

Seq Scan on _kwady_chemist_comm_3_branch sc_120 (cost=0.00..1.16 rows=16 width=4) (actual time=0.003..0.006 rows=16 loops=1)

127. 0.042 0.042 ↑ 1.0 173 1

Seq Scan on _kwik_pharmacy sc_121 (cost=0.00..4.73 rows=173 width=4) (actual time=0.006..0.042 rows=173 loops=1)

128. 0.040 0.040 ↑ 1.0 154 1

Seq Scan on _lifedoor_dansoman sc_122 (cost=0.00..4.54 rows=154 width=4) (actual time=0.005..0.040 rows=154 loops=1)

129. 0.026 0.026 ↑ 1.0 88 1

Seq Scan on _lifedoor_spintex sc_123 (cost=0.00..2.88 rows=88 width=4) (actual time=0.006..0.026 rows=88 loops=1)

130. 0.008 0.008 ↑ 1.0 30 1

Seq Scan on _lj_investments_pharmacy sc_124 (cost=0.00..1.30 rows=30 width=4) (actual time=0.004..0.008 rows=30 loops=1)

131. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _last_hour_pharmacy sc_125 (cost=0.00..13.50 rows=350 width=4) (actual time=0.001..0.001 rows=0 loops=1)

132. 0.019 0.019 ↑ 1.0 73 1

Seq Scan on _lauski_pharmacy sc_126 (cost=0.00..2.73 rows=73 width=4) (actual time=0.004..0.019 rows=73 loops=1)

133. 0.009 0.009 ↑ 13.3 27 1

Seq Scan on _legacy_hospital sc_127 (cost=0.00..13.60 rows=360 width=4) (actual time=0.004..0.009 rows=27 loops=1)

134. 0.010 0.010 ↑ 1.0 28 1

Seq Scan on _lemon_pharmacy sc_128 (cost=0.00..1.28 rows=28 width=4) (actual time=0.004..0.010 rows=28 loops=1)

135. 0.031 0.031 ↑ 1.0 114 1

Seq Scan on _life_gem_pharmacy sc_129 (cost=0.00..3.14 rows=114 width=4) (actual time=0.004..0.031 rows=114 loops=1)

136. 0.081 0.081 ↑ 1.0 303 1

Seq Scan on _life_healthcare_clinic_palace_mall_ sc_130 (cost=0.00..10.03 rows=303 width=4) (actual time=0.005..0.081 rows=303 loops=1)

137. 0.061 0.061 ↑ 1.0 237 1

Seq Scan on _life_healthcare_pharmacy_airport_ sc_131 (cost=0.00..7.37 rows=237 width=4) (actual time=0.005..0.061 rows=237 loops=1)

138. 0.011 0.011 ↑ 1.0 31 1

Seq Scan on _lifeline_medical_centre sc_132 (cost=0.00..1.31 rows=31 width=4) (actual time=0.005..0.011 rows=31 loops=1)

139. 0.031 0.031 ↑ 1.0 116 1

Seq Scan on _lissons_pharmacy sc_133 (cost=0.00..3.16 rows=116 width=4) (actual time=0.005..0.031 rows=116 loops=1)

140. 0.087 0.087 ↑ 1.0 346 1

Seq Scan on _mbj_pharmacy sc_134 (cost=0.00..9.46 rows=346 width=4) (actual time=0.006..0.087 rows=346 loops=1)

141. 0.026 0.026 ↓ 1.0 105 1

Seq Scan on _medicplus_healthcare sc_135 (cost=0.00..3.03 rows=103 width=4) (actual time=0.005..0.026 rows=105 loops=1)

142. 0.070 0.070 ↑ 1.0 277 1

Seq Scan on _marah_pharmacy sc_136 (cost=0.00..7.77 rows=277 width=4) (actual time=0.005..0.070 rows=277 loops=1)

143. 0.070 0.070 ↑ 1.0 279 1

Seq Scan on _marah_pharmacy_airport_t3 sc_137 (cost=0.00..8.79 rows=279 width=4) (actual time=0.005..0.070 rows=279 loops=1)

144. 0.056 0.056 ↑ 1.0 241 1

Seq Scan on _margbest_pharmacy sc_138 (cost=0.00..7.41 rows=241 width=4) (actual time=0.005..0.056 rows=241 loops=1)

145. 0.013 0.013 ↓ 1.0 42 1

Seq Scan on _matell_chemist sc_139 (cost=0.00..1.41 rows=41 width=4) (actual time=0.005..0.013 rows=42 loops=1)

146. 0.061 0.061 ↑ 1.0 256 1

Seq Scan on _medex_pharmacy sc_140 (cost=0.00..7.56 rows=256 width=4) (actual time=0.005..0.061 rows=256 loops=1)

147. 0.026 0.026 ↓ 1.0 83 1

Seq Scan on _mednet_pharmacy sc_141 (cost=0.00..2.81 rows=81 width=4) (actual time=0.005..0.026 rows=83 loops=1)

148. 0.005 0.005 ↑ 17.9 14 1

Seq Scan on _mednight_pharmaceuticals_ltd sc_142 (cost=0.00..12.50 rows=250 width=4) (actual time=0.004..0.005 rows=14 loops=1)

149. 0.019 0.019 ↑ 1.0 81 1

Seq Scan on _medtouch_pharmacy sc_143 (cost=0.00..2.81 rows=81 width=4) (actual time=0.004..0.019 rows=81 loops=1)

150. 0.013 0.013 ↑ 7.7 47 1

Seq Scan on _mendskrom_clinic sc_144 (cost=0.00..13.60 rows=360 width=4) (actual time=0.004..0.013 rows=47 loops=1)

151. 0.005 0.005 ↑ 28.5 13 1

Seq Scan on _metro_health sc_145 (cost=0.00..13.70 rows=370 width=4) (actual time=0.003..0.005 rows=13 loops=1)

152. 0.042 0.042 ↑ 1.0 174 1

Seq Scan on _mobimed_nungua sc_146 (cost=0.00..4.74 rows=174 width=4) (actual time=0.005..0.042 rows=174 loops=1)

153. 0.073 0.073 ↑ 1.0 295 1

Seq Scan on _mobimed_sakumono sc_147 (cost=0.00..7.95 rows=295 width=4) (actual time=0.005..0.073 rows=295 loops=1)

154. 0.011 0.011 ↑ 1.0 25 1

Seq Scan on _mobimed_spintex sc_148 (cost=0.00..1.25 rows=25 width=4) (actual time=0.004..0.011 rows=25 loops=1)

155. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _motherlove_clinic_pharmacy sc_149 (cost=0.00..13.30 rows=330 width=4) (actual time=0.002..0.002 rows=0 loops=1)

156. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _netcare_pharmacy_kasoa sc_150 (cost=0.00..13.40 rows=340 width=4) (actual time=0.001..0.001 rows=0 loops=1)

157. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _netcare_pharmacy_dansoman sc_151 (cost=0.00..13.40 rows=340 width=4) (actual time=0.001..0.001 rows=0 loops=1)

158. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _next_care_pharmacy_ltd sc_152 (cost=0.00..13.40 rows=340 width=4) (actual time=0.001..0.002 rows=0 loops=1)

159. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on _nissi_brown_pharmacy sc_153 (cost=0.00..13.50 rows=350 width=4) (actual time=0.013..0.013 rows=0 loops=1)

160. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _north_legon_hospital sc_154 (cost=0.00..13.50 rows=350 width=4) (actual time=0.002..0.002 rows=0 loops=1)

161. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _nyaho_clinic_pharmacy sc_155 (cost=0.00..13.50 rows=350 width=4) (actual time=0.001..0.001 rows=0 loops=1)

162. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _nyaho_warehouse sc_156 (cost=0.00..13.50 rows=350 width=4) (actual time=0.002..0.002 rows=0 loops=1)

163. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _oak_tree_medical_services sc_157 (cost=0.00..13.30 rows=330 width=4) (actual time=0.001..0.001 rows=0 loops=1)

164. 0.188 0.188 ↑ 1.0 710 1

Seq Scan on _onyx_pharmacy sc_158 (cost=0.00..21.10 rows=710 width=4) (actual time=0.006..0.188 rows=710 loops=1)

165. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _optimum_care_pharmacy sc_159 (cost=0.00..13.50 rows=350 width=4) (actual time=0.001..0.002 rows=0 loops=1)

166. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _oxale_pharmacy sc_160 (cost=0.00..12.50 rows=250 width=4) (actual time=0.002..0.002 rows=0 loops=1)

167. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _p_ray_pharmacy sc_161 (cost=0.00..13.70 rows=370 width=4) (actual time=0.001..0.002 rows=0 loops=1)

168. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _passion_medical_center sc_162 (cost=0.00..12.50 rows=250 width=4) (actual time=0.002..0.002 rows=0 loops=1)

169. 0.159 0.159 ↑ 1.0 505 1

Seq Scan on _pharm_in sc_163 (cost=0.00..42.05 rows=505 width=4) (actual time=0.005..0.159 rows=505 loops=1)

170. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _pharma_solutions_pharmacy sc_164 (cost=0.00..13.30 rows=330 width=4) (actual time=0.001..0.001 rows=0 loops=1)

171. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _pharma_solutions_abeka_pharmacy sc_165 (cost=0.00..13.20 rows=320 width=4) (actual time=0.002..0.002 rows=0 loops=1)

172. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _pharmachoice_pharmacy sc_166 (cost=0.00..13.50 rows=350 width=4) (actual time=0.001..0.001 rows=0 loops=1)

173. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _pharmachoice_2 sc_167 (cost=0.00..13.50 rows=350 width=4) (actual time=0.001..0.002 rows=0 loops=1)

174. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _pharmachoice_warehouse sc_168 (cost=0.00..13.40 rows=340 width=4) (actual time=0.001..0.001 rows=0 loops=1)

175. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _pharmatab_pharmacy sc_169 (cost=0.00..13.50 rows=350 width=4) (actual time=0.002..0.002 rows=0 loops=1)

176. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _pharmhaus_pharmacy sc_170 (cost=0.00..13.60 rows=360 width=4) (actual time=0.001..0.001 rows=0 loops=1)

177. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _power_house_hospital sc_171 (cost=0.00..13.50 rows=350 width=4) (actual time=0.001..0.001 rows=0 loops=1)

178. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _premier_point_chemists sc_172 (cost=0.00..13.40 rows=340 width=4) (actual time=0.001..0.002 rows=0 loops=1)

179. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _prime_care_medical_centre sc_173 (cost=0.00..13.30 rows=330 width=4) (actual time=0.002..0.002 rows=0 loops=1)

180. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _providence_hospital sc_174 (cost=0.00..13.50 rows=350 width=4) (actual time=0.001..0.001 rows=0 loops=1)

181. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _quality_care_medical_clinic sc_175 (cost=0.00..12.50 rows=250 width=4) (actual time=0.001..0.001 rows=0 loops=1)

182. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _radiance_pharmacy_agbogba sc_176 (cost=0.00..12.50 rows=250 width=4) (actual time=0.001..0.002 rows=0 loops=1)

183. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _radiance_pharmacy_haatso sc_177 (cost=0.00..12.50 rows=250 width=4) (actual time=0.001..0.001 rows=0 loops=1)

184. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _rase_chemists_ltd sc_178 (cost=0.00..13.60 rows=360 width=4) (actual time=0.002..0.002 rows=0 loops=1)

185. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _rhino_pharmacy sc_179 (cost=0.00..13.70 rows=370 width=4) (actual time=0.001..0.001 rows=0 loops=1)

186. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _ringway_chemist sc_180 (cost=0.00..12.50 rows=250 width=4) (actual time=0.001..0.001 rows=0 loops=1)

187. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _rophe_specialist_care sc_181 (cost=0.00..13.50 rows=350 width=4) (actual time=0.001..0.001 rows=0 loops=1)

188. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _sp_pharmacy sc_182 (cost=0.00..13.80 rows=380 width=4) (actual time=0.001..0.001 rows=0 loops=1)

189. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _stc_health_portal_clinic sc_183 (cost=0.00..13.30 rows=330 width=4) (actual time=0.001..0.001 rows=0 loops=1)

190. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _samospharma_limited sc_184 (cost=0.00..13.50 rows=350 width=4) (actual time=0.001..0.001 rows=0 loops=1)

191. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _sandpark_pharmacy sc_185 (cost=0.00..13.60 rows=360 width=4) (actual time=0.001..0.002 rows=0 loops=1)

192. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _siaw_larbi_hospital sc_186 (cost=0.00..13.50 rows=350 width=4) (actual time=0.001..0.001 rows=0 loops=1)

193. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _sibakon_wellness_and_medical_centre sc_187 (cost=0.00..13.00 rows=300 width=4) (actual time=0.001..0.001 rows=0 loops=1)

194. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _speed_medical_centre sc_188 (cost=0.00..13.50 rows=350 width=4) (actual time=0.001..0.001 rows=0 loops=1)

195. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _speed_pharmacy_ltd sc_189 (cost=0.00..13.50 rows=350 width=4) (actual time=0.002..0.002 rows=0 loops=1)

196. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _st_augustines_healthcare sc_190 (cost=0.00..12.50 rows=250 width=4) (actual time=0.001..0.002 rows=0 loops=1)

197. 0.160 0.160 ↑ 1.0 532 1

Seq Scan on _sunnyside_pharmacy sc_191 (cost=0.00..38.32 rows=532 width=4) (actual time=0.006..0.160 rows=532 loops=1)

198. 0.013 0.013 ↓ 1.1 40 1

Seq Scan on _sunnyside_pharmacy_vmi sc_192 (cost=0.00..1.37 rows=37 width=4) (actual time=0.005..0.013 rows=40 loops=1)

199. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _the_mall_pharmacy_a_c_mall sc_193 (cost=0.00..13.20 rows=320 width=4) (actual time=0.001..0.001 rows=0 loops=1)

200. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on _the_mall_pharmacy_westhills_mall sc_194 (cost=0.00..13.20 rows=320 width=4) (actual time=0.002..0.003 rows=0 loops=1)

201. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _the_mall_pharmacy_accra_mall sc_195 (cost=0.00..13.20 rows=320 width=4) (actual time=0.001..0.001 rows=0 loops=1)

202. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _the_mall_pharmacy_junction_mall sc_196 (cost=0.00..13.20 rows=320 width=4) (actual time=0.001..0.001 rows=0 loops=1)

203. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _the_truth_pharmacy sc_197 (cost=0.00..13.50 rows=350 width=4) (actual time=0.001..0.001 rows=0 loops=1)

204. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _thywill_chemist_ltd sc_198 (cost=0.00..13.50 rows=350 width=4) (actual time=0.001..0.001 rows=0 loops=1)

205. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on _total_house_clinic_airport_city_pharmacy sc_199 (cost=0.00..12.50 rows=250 width=4) (actual time=0.002..0.003 rows=0 loops=1)

206. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on _total_house_clinic_pharmacy sc_200 (cost=0.00..12.50 rows=250 width=4) (actual time=0.004..0.004 rows=0 loops=1)

207. 0.018 0.018 ↑ 1.0 56 1

Seq Scan on _twumasiwaa_hospital_pharmacy sc_201 (cost=0.00..2.56 rows=56 width=4) (actual time=0.005..0.018 rows=56 loops=1)

208. 0.177 0.177 ↑ 1.0 699 1

Seq Scan on _uniham_pharmacy sc_202 (cost=0.00..20.99 rows=699 width=4) (actual time=0.006..0.177 rows=699 loops=1)

209. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _university_of_ghana_hospital_pharmacy sc_203 (cost=0.00..12.50 rows=250 width=4) (actual time=0.002..0.002 rows=0 loops=1)

210. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _ugh_warehouse sc_204 (cost=0.00..12.50 rows=250 width=4) (actual time=0.002..0.002 rows=0 loops=1)

211. 0.005 0.005 ↑ 31.2 8 1

Seq Scan on _urgent_care_hospital sc_205 (cost=0.00..12.50 rows=250 width=4) (actual time=0.003..0.005 rows=8 loops=1)

212. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _vertex_pharmacy sc_206 (cost=0.00..13.60 rows=360 width=4) (actual time=0.001..0.002 rows=0 loops=1)

213. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _vicdoris_pharmacy_ltd_retail_ sc_207 (cost=0.00..12.50 rows=250 width=4) (actual time=0.002..0.002 rows=0 loops=1)

214. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _vital_pharmacy_suame_branch sc_208 (cost=0.00..13.30 rows=330 width=4) (actual time=0.001..0.001 rows=0 loops=1)

215. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _vital_pharmacy_santasi_branch sc_209 (cost=0.00..13.20 rows=320 width=4) (actual time=0.001..0.001 rows=0 loops=1)

216. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on _vital_pharmacy_ahodwo_branch sc_210 (cost=0.00..13.20 rows=320 width=4) (actual time=0.001..0.001 rows=0 loops=1)

217. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on _vital_pharmacy_patasi_branch sc_211 (cost=0.00..13.20 rows=320 width=4) (actual time=0.001..0.002 rows=0 loops=1)

218. 0.166 0.166 ↓ 1.0 636 1

Seq Scan on _mpharma_delivery_pharmacy sc_212 (cost=0.00..23.31 rows=631 width=4) (actual time=0.004..0.166 rows=636 loops=1)

219. 0.043 0.043 ↑ 1.0 162 1

Seq Scan on _afrah_international_hospital sc_213 (cost=0.00..5.62 rows=162 width=4) (actual time=0.004..0.043 rows=162 loops=1)

220. 0.037 0.037 ↑ 1.0 142 1

Seq Scan on _bebamelbee_pharmacy sc_214 (cost=0.00..4.42 rows=142 width=4) (actual time=0.006..0.037 rows=142 loops=1)

221. 0.033 0.033 ↑ 1.0 128 1

Seq Scan on _bansel_pharmacy sc_215 (cost=0.00..4.28 rows=128 width=4) (actual time=0.005..0.033 rows=128 loops=1)

222. 0.021 0.021 ↑ 1.0 74 1

Seq Scan on _danelizabeth_chemist_ltd sc_216 (cost=0.00..2.74 rows=74 width=4) (actual time=0.005..0.021 rows=74 loops=1)

223. 0.023 0.023 ↑ 1.0 87 1

Seq Scan on _dixxons_group sc_217 (cost=0.00..2.87 rows=87 width=4) (actual time=0.005..0.023 rows=87 loops=1)

224. 0.089 0.089 ↑ 1.0 355 1

Seq Scan on _doraking_pharmacy sc_218 (cost=0.00..10.55 rows=355 width=4) (actual time=0.005..0.089 rows=355 loops=1)

225. 0.024 0.024 ↑ 1.0 94 1

Seq Scan on _eribel_pharmacy sc_219 (cost=0.00..2.94 rows=94 width=4) (actual time=0.005..0.024 rows=94 loops=1)

226. 0.020 0.020 ↑ 1.0 71 1

Seq Scan on _jelsha_pharmacy_limited sc_220 (cost=0.00..2.71 rows=71 width=4) (actual time=0.005..0.020 rows=71 loops=1)

227. 0.020 0.020 ↑ 1.0 80 1

Seq Scan on _jersey_pharmacy sc_221 (cost=0.00..2.80 rows=80 width=4) (actual time=0.004..0.020 rows=80 loops=1)

228. 0.019 0.019 ↑ 1.0 79 1

Seq Scan on _keat_pharmacy sc_222 (cost=0.00..2.79 rows=79 width=4) (actual time=0.004..0.019 rows=79 loops=1)

229. 0.006 0.006 ↑ 17.9 14 1

Seq Scan on _kojokrom_pharmacy sc_223 (cost=0.00..12.50 rows=250 width=4) (actual time=0.003..0.006 rows=14 loops=1)

230. 0.022 0.022 ↑ 1.0 79 1

Seq Scan on _liniven_pharmacy sc_224 (cost=0.00..2.79 rows=79 width=4) (actual time=0.005..0.022 rows=79 loops=1)

231. 0.014 0.014 ↑ 1.0 53 1

Seq Scan on _leverage_pharmaceuticals_ltd_ sc_225 (cost=0.00..2.53 rows=53 width=4) (actual time=0.005..0.014 rows=53 loops=1)

232. 0.061 0.061 ↑ 1.0 244 1

Seq Scan on _maple_mart_pharmacy sc_226 (cost=0.00..7.44 rows=244 width=4) (actual time=0.005..0.061 rows=244 loops=1)

233. 0.007 0.007 ↑ 13.2 19 1

Seq Scan on _med_pharmacy sc_227 (cost=0.00..12.50 rows=250 width=4) (actual time=0.003..0.007 rows=19 loops=1)

234. 0.006 0.006 ↑ 50.0 5 1

Seq Scan on _yaa_achiaa_memorial_hospital sc_228 (cost=0.00..12.50 rows=250 width=4) (actual time=0.003..0.006 rows=5 loops=1)

Planning time : 5.491 ms
Execution time : 826.489 ms