By analyzing SQL query activities, you can accurately identify SQL statements that affect database performance or continuously monitor query activities for statement adjustments and optimizations.
Click on MySQL-PXC in the left navigation bar.
Click on Namespace Name.
Click on Instance Name.
In the Query Analysis tab, set the search criteria.
To find statements executed within a specific time period: select a time period in the Time Range section.
To find specific statements: enter keyword(s) in the Search by SQL Statement section, then click search.
Wait for a moment and view the results.