Dhis2 creates indexes for unused period types

Implementation - Implémentation
1

It would be great if dhis2 could create indexes really needed on analytics tables.
Is there a settings to limit to known/expected period types ?

ex “ethiopian” related and other unused period type are generated whatever we use them/analyze on them on large setup with big history its cpu runtime and lost storage.

 public.analytics_temp_2024                | in_quarterlynov_ax_2024_y5Dv6                | 56 MB      |           0
 public.analytics_temp_2024                | in_sixmonthlynov_ax_2024_WSGDG               | 56 MB      |           0
 public.analytics_temp_2024                | in_financialnov_ax_2024_X42QE                | 55 MB      |           0
1 Like
2

@Gassim does it stop generating the indexes or just hiding the picker ? Can we add hide “nov based” periods ?

image
image455×269 17.6 KB

1 Like
3

Hi @Stephan_Mestach

Interesting question. I will need to triage this one to @dhis2-analytics / @dhis2-backend team. To the best of my knowledge this system setting will only hide the picker.

I will triage the post now; however, I personally have a question hoping if you’d clarify please. You mentioned that unused period type are generated whenever you use them then how are they unused?

Thanks!

4

unused = we don’t have datasets with these periodicity and won’t produce visualisations based on these period types

ex quarterlyNov, financialYearlyNov, financialYearlyJuly… are really specific, the nov one are really specific to amharic/ethiopian calendar

most of our projects implies monthly, quarterly, yearly, sometimes weekly and/or daily
only ethiopian’s one use quarterlyNov and yearlyNov
I think I had only one using the financialJuly in 8 years.

1 Like