I have used plprofiler in the past and it helped a lot especially while migrating to POstgres from Oracle. I have a good feedback about this always.