diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/config.sgml | 15 | ||||
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 62 |
2 files changed, 76 insertions, 1 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 533faf060de..e4a01699e46 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -3647,6 +3647,21 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class=" </listitem> </varlistentry> + <varlistentry id="guc-enable-parallel-hash" xreflabel="enable_parallel_hash"> + <term><varname>enable_parallel_hash</varname> (<type>boolean</type>) + <indexterm> + <primary><varname>enable_parallel_hash</varname> configuration parameter</primary> + </indexterm> + </term> + <listitem> + <para> + Enables or disables the query planner's use of hash-join plan + types with parallel hash. Has no effect if hash-join plans are not + also enabled. The default is <literal>on</literal>. + </para> + </listitem> + </varlistentry> + <varlistentry id="guc-enable-partition-wise-join" xreflabel="enable_partition_wise_join"> <term><varname>enable_partition_wise_join</varname> (<type>boolean</type>) <indexterm> diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index b6f80d97080..8a9793644fa 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -1263,7 +1263,7 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser <entry>Waiting in an extension.</entry> </row> <row> - <entry morerows="17"><literal>IPC</literal></entry> + <entry morerows="32"><literal>IPC</literal></entry> <entry><literal>BgWorkerShutdown</literal></entry> <entry>Waiting for background worker to shut down.</entry> </row> @@ -1280,6 +1280,66 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser <entry>Waiting for activity from child process when executing <literal>Gather</literal> node.</entry> </row> <row> + <entry><literal>Hash/Batch/Allocating</literal></entry> + <entry>Waiting for an elected Parallel Hash participant to allocate a hash table.</entry> + </row> + <row> + <entry><literal>Hash/Batch/Electing</literal></entry> + <entry>Electing a Parallel Hash participant to allocate a hash table.</entry> + </row> + <row> + <entry><literal>Hash/Batch/Loading</literal></entry> + <entry>Waiting for other Parallel Hash participants to finish loading a hash table.</entry> + </row> + <row> + <entry><literal>Hash/Build/Allocating</literal></entry> + <entry>Waiting for an elected Parallel Hash participant to allocate the initial hash table.</entry> + </row> + <row> + <entry><literal>Hash/Build/Electing</literal></entry> + <entry>Electing a Parallel Hash participant to allocate the initial hash table.</entry> + </row> + <row> + <entry><literal>Hash/Build/HashingInner</literal></entry> + <entry>Waiting for other Parallel Hash participants to finish hashing the inner relation.</entry> + </row> + <row> + <entry><literal>Hash/Build/HashingOuter</literal></entry> + <entry>Waiting for other Parallel Hash participants to finish partitioning the outer relation.</entry> + </row> + <row> + <entry><literal>Hash/GrowBatches/Allocating</literal></entry> + <entry>Waiting for an elected Parallel Hash participant to allocate more batches.</entry> + </row> + <row> + <entry><literal>Hash/GrowBatches/Deciding</literal></entry> + <entry>Electing a Parallel Hash participant to decide on future batch growth.</entry> + </row> + <row> + <entry><literal>Hash/GrowBatches/Electing</literal></entry> + <entry>Electing a Parallel Hash participant to allocate more batches.</entry> + </row> + <row> + <entry><literal>Hash/GrowBatches/Finishing</literal></entry> + <entry>Waiting for an elected Parallel Hash participant to decide on future batch growth.</entry> + </row> + <row> + <entry><literal>Hash/GrowBatches/Repartitioning</literal></entry> + <entry>Waiting for other Parallel Hash participants to finishing repartitioning.</entry> + </row> + <row> + <entry><literal>Hash/GrowBuckets/Allocating</literal></entry> + <entry>Waiting for an elected Parallel Hash participant to finish allocating more buckets.</entry> + </row> + <row> + <entry><literal>Hash/GrowBuckets/Electing</literal></entry> + <entry>Electing a Parallel Hash participant to allocate more buckets.</entry> + </row> + <row> + <entry><literal>Hash/GrowBuckets/Reinserting</literal></entry> + <entry>Waiting for other Parallel Hash participants to finish inserting tuples into new buckets.</entry> + </row> + <row> <entry><literal>LogicalSyncData</literal></entry> <entry>Waiting for logical replication remote server to send data for initial table synchronization.</entry> </row> |