I am not familiar with Oracle databases in general, or the tools you mentioned, but if you want to assess your PostgreSQL database's performance on a per-query level, you should check out pgbadger[0] (a performance-oriented log analysis tool) and pg_stat_statements[1] (an extension that records aggregate query performance characteristics), for starters.