August 25th, 2007 by depesz | Tags: | Comments Off on analyze.pgsql.logs
Did it help? If yes - maybe you can help me?


  1. set locale to C for sorting – otherwise sort results will not be really sorted (let's everybody “thank" locale subsystem)
  2. fix a bug that prevented *last* sql-type to be printed


  1. add rule for normalizing so: SELECT * FROM table WHERE field = -12 will be normalized to SELECT * FROM table WHERE field = ? instead of “… field = – ?"
  2. remove extra spaces from normalized version – they did happen sometimes 🙁

SVN repo at:

Sorry, comments for this post are disabled.