Use ? instead of "unknown" in EXPLAIN ANALYZE
@@ -410,13 +410,13 @@ public class PlanPrinter
PlanNodeStats nodeStats = stats.get().get(planNodeId);
if (nodeStats == null) {
output.append(indentString(indent));
- output.append("Cost: unknown");
+ output.append("Cost: ?");
if (printInput) {
- output.append(", Input: unknown");
+ output.append(", Input: ? lines (?B)");
}
- output.append(", Output: unknown");
+ output.append(", Output: ? lines (?B)");
if (printFiltered) {
- output.append(", Filtered: unknown");
+ output.append(", Filtered: ?%");
}
output.append('\n');
return;
@@ -428,7 +428,7 @@ public class PlanPrinter
fractionString = format(Locale.US, "%.2f%%", 100.0 * fraction);
}
else {
- fractionString = "unknown";
+ fractionString = "?";
}
output.append(indentString(indent));
@@ -448,7 +448,7 @@ public class PlanPrinter
filteredString = format(Locale.US, "%.2f%%", filtered);
}
else {
- filteredString = "unknown";
+ filteredString = "?";
}
output.append(", Filtered: " + filteredString);
