I have a question regarding monitoring PDI transformations and jobs. In all my jobs and transformations I have set that Pentaho is writing all possible informations and metrics to logging tables. Now I am looking for best way for monitoring executions of all jobs and transformations (to see which parts of ETL are consuming most of the time, to see which tasks are getting slowly day by day etc).

Querying tables can be sometimes very time consuming and unpractical so I am wondering if there is some kind of already prepared dashboard within Pentaho solutions for monitoring those kind of things? If not, is there available any detailed documentation for logging tables - with detailed explanations of fields content, explained relationships between tables, is there available relationships model...?

What are best practices for monitoring jobs and transformations?