Skip site navigation (1) Skip section navigation (2)

pgsql: Augment EXPLAIN output with more details on Hash nodes.

From: rhaas(at)postgresql(dot)org (Robert Haas)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Augment EXPLAIN output with more details on Hash nodes.
Date: 2010-02-01 15:43:36
Message-ID: 20100201154336.36B7D7541B9@cvs.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
Log Message:
-----------
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.

Modified Files:
--------------
    pgsql/src/backend/commands:
        explain.c (r1.199 -> r1.200)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/explain.c?r1=1.199&r2=1.200)
    pgsql/src/backend/executor:
        nodeHash.c (r1.126 -> r1.127)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeHash.c?r1=1.126&r2=1.127)
    pgsql/src/include/executor:
        hashjoin.h (r1.52 -> r1.53)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/executor/hashjoin.h?r1=1.52&r2=1.53)

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2010-02-01 15:45:12
Subject: Re: Hot Standby and VACUUM FULL
Previous:From: Robert HaasDate: 2010-02-01 15:40:37
Subject: Re: Review: listagg aggregate

pgsql-committers by date

Next:From: Bruce MomjianDate: 2010-02-01 15:48:35
Subject: pgsql: Remove tabs in sgml.
Previous:From: Robert HaasDate: 2010-02-01 15:38:21
Subject: pgsql: Minor documentation improvements for new string_agg aggregate.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group