SQL Doctor

Pre-requirements

• shc package must be installed on your system

Installation Instructions

1. Install

[sudo] make install

Then, follow the messages during installation!

2. Verify

sql_doctor -v

# sql_doctor 1.0.3 (2024-12-24 🎄)

3. Usage

• Default value: --execution-time = 1000, --total-results-peak = 200 and --multiple-pattern = n

sql_doctor /path/to/log/file.log

• Choose your desired values for --execution-time and --total-results-peak.

sql_doctor -e 5000 -p 100 /path/to/log/file.log

# Explain
  - Get all SQLs in the `/path/to/log/file.log` with  `--execution-time >= 5000 miliseconds`
  - Results must be "<=100" records

4. Uninstall

[sudo] make uninstall

5. Contributing

• Fork it ( https://github.com/papakvy/sql_doctor/fork )
• Create your feature branch (git checkout -b my-new-feature)
• Commit your changes (git commit -am 'Add some feature')
• Push to the branch (git push origin my-new-feature)
• Create a new Pull Request