I am using pt-query-digest to munge through my MySQL slow query logs and put the results into a DB, I am then using the awesome “Box Anemometer” tool to look at the results in a nice web interface.
I’m now wanting to do the same with my Postgres Logs. the use of pt-query-digest to do this is great, and as far as generating the flat-file style output it works a treat.
When it comes to loading in the DB, it’s not working as great as for Anemometer to work it needs a hostname column populating in the DB.
Reading the use of --filter and ATTRIBUTES here: http://www.percona.com/doc/percona-toolkit/2.1/pt-query-dige st.html#attributes it implies I can set this somehow, but everything I have tried just seems to fail - I’m really struggling to get my head around the correct format for this option