How to monitor PG and tune workers


What are the things to monitor for data loads and post processing in Splunk?

Basically, ramping workers on PostGress data loading isnt efficient, but I would like to know what the things to look at in splunk are to see how that is going.