Stored procedures can be written in a variety of languages, including C, C++, Java, and SQL PL. SQL PL is a language specifically designed for DB2 and offers a rich set of features that can make it su...
Postgres includes lots of monitoring tools that allow you to see what is happening, but there are a few settings that really go into detail, e.g. log_statement_stats:
SET client_min_messages = log; S...
