About Site Map Submit Contact Us Log in | Create an account
Create an account Log In
Average Rating
User Rating:
Visitors Rating:
My rating:

Write review
See full specifications

linux default iconPractical Query Analyzer Publisher's description

Practical Query Analyzer produces HTML reports on query statistics.

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.

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.]".

System 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
Program Release Status:
Program Install Support: Install and Uninstall and Repair

Practical Query Analyzer Tags:

Click on a tag to find related softwares

Most Popular

linux default icon A2Billing 1.6.0
A2Billing is a billing system interactive with Asterisk to give any Telecom company traditional offering VOIP... Read more
linux default icon FrontAccounting 2.3.10
FrontAccounting is free and released under the GNU General Public License.
linux default icon PgAdmin III for Linux 1.14.1
pgAdmin is the most popular and feature rich Open Source administration and development platform for... Read more
linux default icon RazorSQL for Linux 5.6.3
RazorSQL is an SQL query tool, database browser, SQL editor,....
linux default icon Salat Book 1.00
Salat / Namaz prayer database and tracking application