Quote:
Originally Posted by
figaro
I have a big, ugly query which is quadratic in the input size and therefore want to display an approximate completion time prior to sending it off:
I don't see the link between what you want and the query and like you have said it's not correct. So, to analyze the query you have the explain command to get information about the plan that will be used and from there you can estimate quick query and slow query.
See the official web site for "EXPLAIN"
The other option is to do it on the application side.