To start with PL/SQL or SQL tuning the first step should be to identify the bottleneck in the whole code. Idetifying individual SQL queries that are giving problems is no difficult task.
But identifying some PL/SQL block can be a difficult job.
Who Thought Banks Would Move from Oracle to PostgreSQL?
Open source databases such as PostgreSQL are no longer treated only as developer tools. For many enterprises, the real question has shifted from brand comfort to engineering maturity.