Hi Hannan I recall you had a similar request which I responded to back in Jan 11. Maybe worth re-reading that thread as some of it seems still to be relevant. In particular:
1. The first question, as always, is has this suddenly happened or has something recently changed? Back then there had been some new datasets created by UNICEF which you were suspecting. I recall at the time you said that analytics then was taking 13 hours. So 12 hours is an improvement? Is this a sudden problem, like from a recent system upgrade or some changes to datasets, or just the way it has been for some time .. unacceptably slow. 2. A lot of analytics generation time is taken up on CREATE INDEX. You might try to increase maintenance_work_mem. I think I had suggested back then pushing as far as 4G on your system. 3. You still have some automated creature (username elmisinterop) logging into your system at a crazy rate per second after 1am. As I recall this user is trying to download all the data on your system which is probably not a good thing to do during analytics generation. Whatever it is, you need to disable that. Try 2 and 3 and see where that gets you. Any chance you can also try to get access to some faster disk resource? Hope this helps. Bob On 30 April 2018 at 12:36, Hannan Khan <hann...@gmail.com> wrote: > Dear Experts > > I am drawing your attention to one problem and need your kind attention. > In one of our DHIS2 instances, 'Central Server' analytics generation taking > too much time 12 h, 22 m, 34 s. DB size is 127 GB and have aggregated and > trackers as. During analytics run-time the processor utilization and RAM > utilization is normal. But from the log it is clear that the trackers are > taking too much time though they are not having much data. "EPI Cold Chain" > tracker taking near about 9 hour, "Cause of death (MCCOD)"tracker taking 3 > hour and "Cervical and Breast Cancer Screening Program" tracker taking 7 > hour. What seems to be the reason? Is something wrong with the tracker > system? > > We are using DHIS2 version 2.28 release 533e983. > > Need immediate help. > > Regards > > Muhammad Abdul Hannan Khan > Team Leader > Support to the National HMIS > MIS, Directorate General of Health Services > Ministry of Health and Family Welfare > > T +880-2- 58816459, 58816412 ext 118 > F +88 02 58813 875 > M+88 01819 239 241 > M+88 01534 312 066 > E hann...@gmail.com > S hannan.khan.dhaka > B hannan-tech.blogspot.com > L https://bd.linkedin.com/in/hannankhan > > > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
