There is always a need for profiling tools in databases for admins or developers. While it is easy to understand the point where an SQL is spending more time using [crayon-5d5b15ed42f79136795479-i/] or [crayon-5d5b15ed42f7d687411335-i/] in PostgreSQL, the same would not work for functions. Recently, Jobin has published a blog post where he demonstrated how plprofiler can [&]

https://www.percona.com/blog/2019/07/30/using-plpgsql_check-to-find-compilation-errors-and-profile-functions/