The main novelty of the version of Query Performance v1.6 is that the possibility of executing the queries that we have collected from an Oracle environment in another PostgreSQL has been introduced. This allows us in a simple and fast way to see the behavior of these queries in the new environment and anticipate problems of query execution, as well as possible degradations after their execution. It is also very useful in Oracle environment migrations. Either between Oracle’s own versions. Or migrate from Oracle to PostgreSQL. This way you can compare the result of the queries before the migration. And correct errors before they occur in production. Query Performance allows you to run, measure, and compare queries, from your current Oracle environment, in another environment.
To do this, during the Replay process it is possible to create a connection to PostgreSQL that will allow us to launch the Queries:
Once added, we can select this new connection during the process:
When the execution ends, in the jobs screen we can already see the Queries that have failed in the new environment:
Generate reports with Query Performance v1.6
It also allows us to generate a report comparing the two runs by the criteria of our choice, in this example we have chosen to compare by Elapsed Time. When generating execution plans in different formats, they cannot be compared, but if it allows us to see the queries that have different performance behavior:
In this case we have chosen to see those with a worse execution time:
We can also see the plans on one platform and another, although they are not comparable by the format if it will give us an idea of what may be happening:
By generating a report we can see the Queries that have failed and the reason
Discover more features in this Youtube presentation.