Improve customer experience for puppetdb

As our customers grow they engaging with parts of PE that rely heavily on puppetdb. This epic is to capture improvements we have made in hotfixes and stabilizing these fixes.

Improve query response time and prevent deadlocks and timeouts. This will result in our customers to get better and faster response time from PE, thus improving their velocity to meet their business goals.