pt-query-digest and Postgres...


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: 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 :frowning: