+
+

Related Products

  • AdRem NetCrunch
    165 Ratings
    Visit Website
  • DbVisualizer
    584 Ratings
    Visit Website
  • Google Cloud SQL
    554 Ratings
    Visit Website
  • Google Cloud BigQuery
    2,023 Ratings
    Visit Website
  • Windocks
    7 Ratings
    Visit Website
  • ZenTreasury
    9 Ratings
    Visit Website
  • EazyStock
    65 Ratings
    Visit Website
  • New Relic
    2,935 Ratings
    Visit Website
  • RaimaDB
    12 Ratings
    Visit Website
  • LeaseAccounting.app
    Visit Website

About

PawSQL integrates the best practices of query optimization in database industry, provides advanced SQL rewrite optimization, and sophisticate index recommendation capabilities for slow queries. Based on the professional PawSQL optimization engine (used by more than 10,000 database practitioners around the world), it provides rich SQL optimization suggestions and intelligent index recommendations. PawSQL provides a comprehensive and balanced audit rule set for multiple databases such as MySQL, PostgreSQL, openGauss, Oracle, etc., providing enterprises with a consistent audit experience no matter how diverse their database environment is. Rule-based SQL review, covering potential correctness and performance optimization issues. Rich rewrite optimization, recommending semantically equivalent but more efficient SQL queries. Cost-based verification ensures that new solutions based on SQL rewrite and index recommendation have better performance. Intelligent index recommendation.

About

Percona Monitoring and Management (PMM) is a free, best-of-breed, open source database monitoring and management solution. It helps enterprises reduce complexity and simplify management, while optimizing performance and improving the security of your business-critical database environments, no matter where they are located - on-premises or in the cloud. It provides thorough time-based analysis for MySQL, PostgreSQL and MongoDB servers to ensure that your data works as efficiently as possible. PMM allows you to identify the issues that impact your business, fast! Our single platform simplifies management and reduces complexity. It helps you optimize your database by allowing you to easily find, fix, and prevent issues with scaling, bottlenecks and potential outages. Our innovative tools improve data security and reduce your risk of data exposure. PMM is used by thousands of organizations around the globe to manage their complex database environments.

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Audience

Individuals looking for query optimization in database industry, advanced SQL rewrite optimization, and sophisticate index recommendation capabilities for slow queries

Audience

Organizations that utilize MongoDB, MySQL, PostgreSQL, or MariaDB

Support

Phone Support
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

API

Offers API

API

Offers API

Screenshots and Videos

Screenshots and Videos

Pricing

No information available.
Free Version
Free Trial

Pricing

$0
Software is completely Free and Open Source, Support plans are available for those that need it.
Free Version
Free Trial

Reviews/Ratings

Overall 5.0 / 5
ease 5.0 / 5
features 5.0 / 5
design 4.0 / 5
support 3.0 / 5

Reviews/Ratings

Overall 4.7 / 5
ease 4.4 / 5
features 4.6 / 5
design 4.6 / 5
support 4.5 / 5

Pros & Cons from Real Users

Pros

  • 1. Comprehensive Database Support: PawSQL supports a variety of database systems, including MySQL, PostgreSQL, OpenGauss, and more, providing a consistent auditing experience across diverse database environments 2. Advanced Parsing Capabilities: PawSQL demonstrates excellent parsing abilities, capable of handling all tested SQL statements without issues 3. High-Accuracy Warnings: PawSQL provides SQL warnings or tips with high precision, focusing not only on the correctness of SQL statements but also offering performance optimization rules and potential correctness issues 4. Optimization Suggestions: PawSQL offers query rewrite optimization and intelligent index recommendations, helping developers and DBAs solve SQL performance issues in a one-stop manner 5. Performance Verification: PawSQL provides a What-If performance verification feature, offering an analyze option to obtain the actual parsing and execution cost of SQL, avoiding the shortcomings of MySQL's explain for intermediate result tables and providing more accurate cost estimation

Cons

  • PawSQL doesn't support SQL Server yet, and little support for HIVE SQL.

Pros & Cons from Real Users

Pros

  • Increased performance optimization. It is scalable. It provides comprehensive analytics and monitoring capabilities for mySQL. Nice expert support.
  • This tool helps tracking performance and identify areas of optimisation. This further helps in reducing cost in upgrading the software.
  • Percona Monitoring and Management is the best tool for monitoring database, we use this with MySql but also it can also use with PostgreSQL, MongoDB. It provides real tine monitoring with best analysis. PMM also gives us alert about thresholds. It is best open source platform. The best thing about this software is that it provides graphical data with exact analysis and also it is secure to use.
  • Comprehensive monitoring features, user-friendly interface, and excellent performance optimization capabilities.
  • . Easy to use . Attractive dashboard . Everything is working smoothly . All features are very helpful . Very nice support services . Safe and secure

Cons

  • Dedicated learning is required .Limited compatibility with Third party tools.
  • There is scope of improvement in documentation part.
  • Not much dislike about this tool but hard to control its dashboard for newcomer, it must be easy and simple to use.
  • The initial configuration might require some technical knowledge, but the documentation helps overcome any hurdles.
  • There any major issue to dislike this tool. It is totally worthy

Training

Documentation
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

Company Information

PawSQL
Founded: 2024
China
www.pawsql.com

Company Information

Percona
Founded: 2006
United States
www.percona.com

Alternatives

Alternatives

ClusterControl

ClusterControl

Severalnines
SQL Query Tuner

SQL Query Tuner

IDERA, an Idera, Inc. company

Categories

Categories

Database Monitoring Features

Anomaly Detection
Autodiscovery
Capacity Planning
Dashboard
Dependency Tracking
Historical Trend Analysis
Multitenancy
Notifications / Alerts
Performance Monitoring
Permissions / Access Controls
Predictive Analytics
Prioritization
Query Analysis
Resource Optimization
Troubleshooting

Integrations

MariaDB
MySQL
PostgreSQL
DataGrip
Devart ODBC Drivers
Lyftrondata
MongoDB
Oracle Database
Percona Distribution for PostgreSQL
Percona Server for MongoDB
Percona Server for MySQL

Integrations

MariaDB
MySQL
PostgreSQL
DataGrip
Devart ODBC Drivers
Lyftrondata
MongoDB
Oracle Database
Percona Distribution for PostgreSQL
Percona Server for MongoDB
Percona Server for MySQL
Claim PawSQL and update features and information
Claim PawSQL and update features and information
Claim Percona Monitoring and Management (PMM) and update features and information
Claim Percona Monitoring and Management (PMM) and update features and information