Is any method to get estimation of query progress for activation / rail / postgraze (for example, 75%)? Or if I had to close ActiveRecord, is there any way to get it?
How to do this with a straightforward postgrace
This can be done with the hive query in an Hadoop cluster, especially when there are large numbers of mapers and reducers, because it is a partition And when its pieces are finished, it may have some idea of its progress (although this progression is not always smooth, because not all the data is equally distributed evenly).
In the postgres , since there is only one query, there is no division (there is currently no division) to finish the laminate and report progress if you actually In , then stress has postgress process to run your query, and the only way to find out about progress is reading the file. Due to the layout of the tables on the disc, it is based on the reading Some can progress progress. However, this is an indirect relationship, to ensure that a full percentage, and generally not worth the hassle, is the IMO.
The best bet, in general, is to ensure that your statistics are updated in the tables, and then look at the query plan, and depending on the complexity / possible execution time Try to guess.
No comments:
Post a Comment