Hi,
There are many tools:
- (core) extension pg_stat_statements will give you informations of SQL
executions,
- extension pgsentinel https://github.com/pgsentinel/pgsentinel
gives the same results as Oracle ASH view
- java front end PASH viewer https://github.com/dbacvetkov/PASH-Viewer
gives a nice view of CPU IO per query
- extension pg_stat_sql_plans (alpha) gives all of pg_stat_statements and
much more
(parsing time, planid, plan text, ...)
Regards
PAscal
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html