This custom report started taking a much longer time to run than it had before. It used to complete in few minutes and now takes 22-23 hours scoped to a parent group of 20 backup servers. As per customer nothing has changed in the configuration of the report.
Troubleshooting path consisted of:
It was identified that for some reason PostgreSQL database is using a poor query plan for the backupjob table on the 20-node parent group.
Workaround was running the report on the 20 individually selected child nodes.
More investigation is needed to determine why the entire 20-node group query started performing poor suddenly. It has occurred twice in few months.
Contact Dell EMC Data Protection Advisor support team for further information.