# pt-query-digest output to easily insert in a table

**URL:** <https://forums.percona.com/t/pt-query-digest-output-to-easily-insert-in-a-table/7637>\
**Category:** Percona Toolkit\
**Created:** [May 17, 2020, 6:07am UTC](https://forums.percona.com/t/pt-query-digest-output-to-easily-insert-in-a-table/7637 "2020-05-17T06:07:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![shah](https://avatars.discourse-cdn.com/v4/letter/s/f4b2a3/32.png) [@shah](https://forums.percona.com/u/shah)\
**Post date:** [May 17, 2020, 6:07am UTC](https://forums.percona.com/t/pt-query-digest-output-to-easily-insert-in-a-table/7637/1 "2020-05-17T06:07:42Z")

</div>

I am trying save all entries of the slow query log output to a table. I started by running:  
pt-query-digest slow.log --filter ‘print Dumper $event’ --no-report  
&nbsp;which gives a hash output for perl. Is there a way it can generate csv format? or a routine to generate insert statements?

---

<div class="post-metadata">

**Author:** ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)\
**Post date:** [May 26, 2020, 5:19pm UTC](https://forums.percona.com/t/pt-query-digest-output-to-easily-insert-in-a-table/7637/2 "2020-05-26T17:19:07Z")

</div>

Have you looked at --history and --review options in&nbsp; Percona Toolkit - they insert data into tables directly, without need to specially format it&nbsp;[https://www.percona.com/doc/percona-toolkit/LATEST/pt-query-digest.html](https://www.percona.com/doc/percona-toolkit/LATEST/pt-query-digest.html "Link: https://www.percona.com/doc/percona-toolkit/LATEST/pt-query-digest.html")