Unanswered: How to determine the status of a query?
I have a query that runs for about 10-30min to return results, and was wondering if I add this to a application, how can I determine how long the query has to complete so I can update my progress indicator to the user?
as far as I know, there is no way to determine how long your query will take.
Nevertheless, you can have a good idea of the query plan if you include
"set explain on" before your query. it will write the detailed query plan
in a file called sqexplain.out in the place you run the query from. This is generally a great way to understand whether your query behaves well and a good indicator to how to enhance it.
On version 11.70, the explain file is even more detailed and takes execution time of all the steps of your queries.