docs: update comment for PROFILE QueryMode

Google APIs · copybara-github · commit 72a51519aec1 · 2024-09-30T10:24:54.000-07:00
feat: add new QueryMode enum values (WITH_STATS, WITH_PLAN_AND_STATS)

PiperOrigin-RevId: 680628448
diff --git a/google/spanner/v1/spanner.proto b/google/spanner/v1/spanner.proto
@@ -628,9 +628,19 @@ message ExecuteSqlRequest {
     // execution statistics information.
     PLAN = 1;
 
-    // This mode returns both the query plan and the execution statistics along
-    // with the results.
+    // This mode returns the query plan, overall execution statistics,
+    // operator level execution statistics along with the results. This has a
+    // performance overhead compared to the other modes. It is not recommended
+    // to use this mode for production traffic.
     PROFILE = 2;
+
+    // This mode returns the overall (but not operator-level) execution
+    // statistics along with the results.
+    WITH_STATS = 3;
+
+    // This mode returns the query plan, overall (but not operator-level)
+    // execution statistics along with the results.
+    WITH_PLAN_AND_STATS = 4;
   }
 
   // Query optimizer configuration.
