Skip to main content

Performance Patroller

info

The PawSQL Database Performance Patroller supports performance patrols for various databases such as MySQL, PostgreSQL, openGauss, etc.; it automatically and periodically captures slow queries generated in the database and provides SQL optimization suggestions, including automatic SQL rewriting, intelligent index recommendations, and analysis of existing redundant indexes; it also automatically and periodically patrols database objects to identify potential performance, security, and maintainability issues and provides optimization suggestions.

1. Core Features​

  • Automated slow query collection, storage, and trend analysis capabilities,

  • Rich SQL rewriting optimization, for slow query SQL collected, recommend semantically equivalent but more efficient SQL execution;

  • Intelligent index recommendation, for slow query SQL collected, recommend the optimal index combination;

  • Performance verification based on cost, ensuring that new plans based on rewriting and index recommendations have better performance;

  • Automated database object collection, storage, and analysis review capabilities, identifying potential issues and providing suggestions.

2. Supported Databases​

PawSQL, based on its self-developed SQL parser, supports multiple database types and SQL dialects. The current list of supported databases is as follows:

  • MySQL 5.6 and above

  • PostgreSQL 9.1 and above

  • openGauss 1.0 and above

  • Alibaba Cloud RDS MySQL