From 42a8ab0a1429b4ba78a35ad8b210734d1561d644 Mon Sep 17 00:00:00 2001 From: Robert Haas Date: Mon, 1 Feb 2010 15:43:36 +0000 Subject: Augment EXPLAIN output with more details on Hash nodes. We show the number of buckets, the number of batches (and also the original number if it has changed), and the peak space used by the hash table. Minor executor changes to track peak space used. --- src/include/executor/hashjoin.h | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'src/include/executor') diff --git a/src/include/executor/hashjoin.h b/src/include/executor/hashjoin.h index 4e90cbd353..4ac6ae3ce8 100644 --- a/src/include/executor/hashjoin.h +++ b/src/include/executor/hashjoin.h @@ -7,7 +7,7 @@ * Portions Copyright (c) 1996-2010, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $PostgreSQL: pgsql/src/include/executor/hashjoin.h,v 1.52 2010/01/02 16:58:03 momjian Exp $ + * $PostgreSQL: pgsql/src/include/executor/hashjoin.h,v 1.53 2010/02/01 15:43:36 rhaas Exp $ * *------------------------------------------------------------------------- */ @@ -149,6 +149,7 @@ typedef struct HashJoinTableData Size spaceUsed; /* memory space currently used by tuples */ Size spaceAllowed; /* upper limit for space used */ + Size spacePeak; /* peak space used */ Size spaceUsedSkew; /* skew hash table's current space usage */ Size spaceAllowedSkew; /* upper limit for skew hashtable */ -- cgit v1.2.1