Re: Q on SQL Performance tuning

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