# pt-query-digest and Postgres...

**URL:** <https://forums.percona.com/t/pt-query-digest-and-postgres/2569>\
**Category:** Percona Toolkit\
**Created:** [July 19, 2012, 9:10am UTC](https://forums.percona.com/t/pt-query-digest-and-postgres/2569 "2012-07-19T09:10:22Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![mrmatey](https://avatars.discourse-cdn.com/v4/letter/m/b782af/32.png) [@mrmatey](https://forums.percona.com/u/mrmatey)\
**Post date:** [July 19, 2012, 9:10am UTC](https://forums.percona.com/t/pt-query-digest-and-postgres/2569/1 "2012-07-19T09:10:22Z")

</div>

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](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  
😕