Hi Ankush!
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.
Hth!
[0]: http://pgbadger.darold.net/
[1]: https://www.postgresql.org/docs/current/pgstatstatements.html
--
with best regards:
- Johannes Truschnigg ( johannes@truschnigg.info )
www: https://johannes.truschnigg.info/
phone: +43 650 2 133337
xmpp: johannes@truschnigg.info
Please do not bother me with HTML-email or attachments. Thank you.