Horton

v2-0002-ad-hoc-usage-stats-collection.patch

text/x-diff

Download
Filename: v2-0002-ad-hoc-usage-stats-collection.patch
Type: text/x-diff
Part: 1
Message: Re: Optimize planner memory consumption for huge arrays

Patch

Same data as JSON: GET /api/v1/attachments/:id/patch the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes. API reference →
Format: unified
Series: patch v2-0002
File+−
src/backend/optimizer/plan/planner.c 11 0 
diff --git a/src/backend/optimizer/plan/planner.c b/src/backend/optimizer/plan/planner.c
index df6a1fd330..db1d0fd7de 100644
--- a/src/backend/optimizer/plan/planner.c
+++ b/src/backend/optimizer/plan/planner.c
@@ -297,6 +297,10 @@ standard_planner(Query *parse, const char *query_string, int cursorOptions,
 	Plan	   *top_plan;
 	ListCell   *lp,
 			   *lr;
+	MemoryContextCounters before_counters,
+				after_counters;
+
+	MemoryContextMemConsumed(CurrentMemoryContext, &before_counters);
 
 	/*
 	 * Set up global state for this planner invocation.  This data is needed
@@ -598,6 +602,13 @@ standard_planner(Query *parse, const char *query_string, int cursorOptions,
 	if (glob->partition_directory != NULL)
 		DestroyPartitionDirectory(glob->partition_directory);
 
+	MemoryContextMemConsumed(CurrentMemoryContext, &after_counters);
+	after_counters.freespace -= before_counters.freespace;
+	after_counters.totalspace -= before_counters.totalspace;
+	elog(LOG, "planning memory consumption: used=%lld allocated=%lld",
+		 (long long) (after_counters.totalspace - after_counters.freespace),
+		 (long long) (after_counters.totalspace));
+
 	return result;
 }