How to check which statement is taking more time in a stored procedure of pipeline?

Help Connectors and Pipelines
1

I am running a pipeline stored procedure. This pipeline is taking around 3 min. How to check which statement is causing the issue other than keeping an dummy insert statement.

2

Only method to check is to extract each SQL statement out of the SP and profile it directly.