http://www.markleith.co.uk/ps_helper/
To refer how to use them, see the following link:
http://www.markleith.co.uk/ps_helper/#statement_analysis
For example:
View: statements_with_full_table_scans
select * from statements_with_full_table_scans limit 5; SELECT * FROM schema_tables_with_full_table_scans LIMIT 10; SELECT * FROM schema_unused_indexes; SELECT * FROM schema_table_statistics LIMIT 10; SELECT * FROM statements_with_runtimes_in_95th_percentile WHERE QUERY NOT LIKE 'show%';
0 comments:
Post a Comment