pgFouine – PostgreSQL Log Analyzer
Oct-11-2007 By miketeo
If your postgreSQL database performance is not up to your expectations, or queries have started to run slower than before, it’s time to do some optimizations. The first feature to activate on your PostgreSQL engine to enable to logging to log your queries and their running statistics. Second is to run these logs through pgFouine.
pgFouine is a PostgreSQL log analyzer used to generate detailed reports from a PostgreSQL log file. pgFouine can help you to determine which queries you should optimize to speed up your PostgreSQL based application. In addition, pgFouine can also analyze your VACUUM stats to determine if you should increase your FSM parameters, or to perform a VACUUM FULL to reclaim the free space in your tables.
Posted in: PostgreSQL
