dhis2-devs-core team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hi,

I have done some analysis of postgres logs from the pepfar / datim system
which is available here:

http://folk.uio.no/larshelg/files/datim-postgres-log.html

Some interesting stuff under Top > Normalized slowest queries. As expected
it seems validation, approval, analytics contribute heavily. Some
unexpected Hibernate queries against categoryoptiongroupmembers,
dataelementgroupmembers, datasetmembers, datasetsource deserve some
investigation.

Lars