Hello there! Over the past few months our website back-end load speeds have been getting longer. (Not front-end, fortunately.)
The long load persists on only 2 pages in the Admin Dashboard: Events and Products.
The load times will be 45-90 seconds when calling the Events Post List. Sometimes this causes an error 502 server time-out.
Our hosting provider, WP Engine, dug deep and found this:
Screenshot: https://www.dropbox.com/s/vzrn04zej84csw7/Screenshot%202018-01-22%2014.49.28.png?raw=1
Also when drilling deeper into the issue, Im also seeing a lot of calls to the WP_Posts_List_Table query.
In his testing, these calls took 30+ seconds.
I can provide back-end access if requested. Thanks!