Fix auto-explain JSON output to be valid JSON.

adunstan · adunstan · commit 0f3fcbbb6134 · 2012-02-13T08:23:13.000-05:00
Problem reported by Peter Eisentraut.

Backpatched to release 9.0.
diff --git a/contrib/auto_explain/auto_explain.c b/contrib/auto_explain/auto_explain.c
@@ -248,6 +248,13 @@ explain_ExecutorEnd(QueryDesc *queryDesc)
 			if (es.str->len > 0 && es.str->data[es.str->len - 1] == '\n')
 				es.str->data[--es.str->len] = '\0';
 
+			/* Fix JSON to output an object */
+			if (auto_explain_log_format == EXPLAIN_FORMAT_JSON)
+			{
+				es.str->data[0] = '{';
+				es.str->data[es.str->len - 1] = '}';
+			}
+
 			/*
 			 * Note: we rely on the existing logging of context or
 			 * debug_query_string to identify just which statement is being
