Not the answer you need?
Register and ask your own question!

pt-query-digest and Postgres...

mrmateymrmatey EntrantInactive User Role Beginner
Hi,

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

Thanks
:confused:
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.