title: I have statistical data on my SQL queries, what can I do with that to make my app faster?
body: <p>I have a J2EE application built on EclipseLink and running under Glassfish on Postgres. We're doing some performance analysis now. </p>
  
  <p>I turned on pg logging on our build server and analyzed the output with pgfouine. Now that I have these charts and data from pgfouine, how should I interpret that to actually improve performance?</p>
  
  <p>I think I want to find the most frequently used, but slower queries to get the most benefit. Reducing the number of frequently run queries (perhaps through caching) also seems like a sound approach.</p>