Input: Postgres slowqwery raw file
Output: Two Csv file.
File 1: Contains all the queries with the executed time in desending order
Columns: Hash, Group, Time, Query
File 2: Contains all the unique queries with the Max time of that query.
Columns: Hash, Group, Count, Time, Query
*Hash is basically an uniqueness parameter for the Sql command.
*Group used for grouping the query
*Count is the no of queries found Corresponding to hash
How to Use:
1)Set the $destination_folder where you want to save your files
2)Set the $files_read array .You can pass no of files in single go.
Thats It.
Now run on shell: php index.php
Your file will be parsed.