Practical Query Analyzer produces HTML reports on query statistics. #HTML reports #Query analyzer #Query statistics #Reports #Query #Analyzer
Practical Query Analyzer produces HTML reports on the most frequent queries, slowest queries, queries by type (select/insert/update/delete), and more for both PostgreSQL and MySQL log files.
Requirements:
� Ruby � PQA itself � PostgreSQL or MySQL installation.
You can install PQA by simply unzipping it into any directory. Then open a command line window, cd into the pqa-1.4 directory, and run it like this:
[tom@hal lib]$ ./pqa.rb -file ../sample/pglog_sample.log -normalize -top 5 645 queries (65 unique), longest ran in 0.370524 seconds), parsed in 0.088793 seconds ### Queries by type SELECTs: 593 (92%) INSERTs: 51 (8%) UPDATEs: 1 (0%) ### 5 most frequent queries 61 times: SELECT total FROM forum_group_list_vw WHERE group_forum_id='' 46 times: SELECT plugin_id, plugin_name FROM plugins 46 times: INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','',''); 40 times: select classname from supported_languages where language_code = '' 40 times: SELECT language_code FROM supported_languages WHERE language_id=''
� -file - required - The name of the data file to analyze � -top N - optional - "Top N queries", defaults to 10. � -format N - optional - Either "text" or "html", defaults to "text" � -normalize - optional - Removes quoted items and various bits of whitespaces � -logtype - optional - The type of log file: syslog, pglog, or mysql - defaults to pglog
What's New in This Release:
� This release fixes a silly bug that prevented it from being run directly. � It has various internal improvements. � If you install it via RubyGems, you can run it using "pqa -f file1 [file2, etc.]".
Practical Query Analyzer 1.6
add to watchlist add to download basket send us an update REPORT- runs on:
- Linux
- filename:
- pqa-1.6.zip
- main category:
- Database
- developer:
- visit homepage
Microsoft Teams 24060.3102.2733.5911 Home / 1.7.00.10152 Work
ShareX 16.0.1
Zoom Client 6.0.4.38135
7-Zip 23.01 / 24.04 Beta
Windows Sandbox Launcher 1.0.0
Context Menu Manager 3.3.3.1
4k Video Downloader 1.5.3.0080 Plus / 4.30.0.5655
calibre 7.9.0
Bitdefender Antivirus Free 27.0.35.146
IrfanView 4.67
- calibre
- Bitdefender Antivirus Free
- IrfanView
- Microsoft Teams
- ShareX
- Zoom Client
- 7-Zip
- Windows Sandbox Launcher
- Context Menu Manager
- 4k Video Downloader