This function was implemented as a solution for issue # 1478:
link
According to the source code, the part outside the parentheses is the execution time and the inside is the fetch time . execution time is the time it takes the database to identify the records that should be returned based on your query. fetch time is how long the bank took to deliver the data.
So, if you do SELECT * FROM ANO_MODELO the database will have almost no work to identify the records that should be returned, since you want the whole table. So you would have a smaller execution time but a larger fetch time , because the amount of records is larger and requires more time to fetch.
Below is the code snippet that details the implementation (GitHub source):
if (statistics == null || statistics.isEmpty()) {
return "";
}
long fetchTime = statistics.getFetchTime();
long totalTime = statistics.getTotalTime();
if (fetchTime <= 0) {
return " - " + RuntimeUtils.formatExecutionTime(totalTime);
} else {
return " - " + RuntimeUtils.formatExecutionTime(statistics.getExecuteTime()) + " (+" + RuntimeUtils.formatExecutionTime(fetchTime) + ")";
}
}