GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

pt-query-digest and Postgres...

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-query-digest and Postgres...

    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
Working...
X