Using plpgsql_check to Find Compilation Errors and Profile Functions

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
EXPLAIN or
EXPLAIN ANALYZE in PostgreSQL, the same would not work for functions. Recently, Jobin has published a blog post where he demonstrated how […]