Informatica - Session Performance Stats - Sql to pull performance data from Repository

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT opti.SUBJECT_ID,
       opti.WORKFLOW_ID,
       opti.WORKFLOW_RUN_ID,
       opti.INSTANCE_ID,
       opti.INSTANCE_NAME,
       opti.START_TIME,
       opti.END_TIME,
       opti.RUN_ERR_CODE,
       opti.RUN_ERR_MSG,
       ostl.MAPPING_NAME,
       ostl.SRC_SUCCESS_ROWS,
       ostl.SRC_FAILED_ROWS,
       ostl.TARG_SUCCESS_ROWS,
       ostl.TARG_SUCCESS_ROWS,
       DATEDIFF (SECOND, opti.START_TIME, opti.END_TIME) TimeDifferenceinSec,
       CASE
           WHEN DATEDIFF (ss, opti.START_TIME, opti.END_TIME) = 0 THEN 0
           ELSE ostl.TARG_SUCCESS_ROWS/DATEDIFF (SS, opti.START_TIME, opti.END_TIME)
       END AS avgRecordsPerSec
FROM [PC_REP].[dbo].[OPB_TASK_INST_RUN] opti
INNER JOIN [PC_REP].[dbo].[OPB_SESS_TASK_LOG] ostl ON ostl.WORKFLOW_RUN_ID=opti.WORKFLOW_RUN_ID
AND ostl.INSTANCE_ID=opti.INSTANCE_ID
AND INSTANCE_NAME LIKE '%EnterTheNameOfsession%'
ORDER BY ostl.WORKFLOW_RUN_ID DESC 

Or For all task instance types.

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT --opti.SUBJECT_ID,
 --     opti.WORKFLOW_ID,
 --   opti.WORKFLOW_RUN_ID,
 -- opti.INSTANCE_ID,
 opti.INSTANCE_NAME,
 opti.START_TIME,
 opti.END_TIME,
 DATEDIFF (SECOND, opti.START_TIME, opti.END_TIME) TimeDifferenceinSec, --opti.RUN_ERR_CODE,
 -- opti.RUN_ERR_MSG,
 --ostl.MAPPING_NAME,
 ostl.SRC_SUCCESS_ROWS, --ostl.SRC_FAILED_ROWS,
 --ostl.TARG_SUCCESS_ROWS,
 --ostl.TARG_SUCCESS_ROWS,
 CASE
     WHEN DATEDIFF (ss, opti.START_TIME, opti.END_TIME) = 0 THEN 0
     ELSE ostl.TARG_SUCCESS_ROWS/DATEDIFF (SS, opti.START_TIME, opti.END_TIME)
 END AS avgRecordsPerSec
FROM [PC_REP].[dbo].[OPB_TASK_INST_RUN] opti --change to inner join if you are intrested only in session stats and change to left outer join if you are after other tasks.
--but for other tasks last 2 columns will/may not have any data
LEFT OUTER JOIN [PC_REP].[dbo].[OPB_SESS_TASK_LOG] ostl ON ostl.WORKFLOW_RUN_ID=opti.WORKFLOW_RUN_ID
AND ostl.INSTANCE_ID=opti.INSTANCE_ID 
--and RUN_ERR_CODE=0

WHERE INSTANCE_NAME LIKE '%TaskName%'
ORDER BY opti.START_TIME DESC --and   ostl.WORKFLOW_RUN_ID=646762
 ----and ostl.INSTANCE_ID=4472