diff options
| author | Thomas Munro | 2023-03-22 23:39:43 +0000 |
|---|---|---|
| committer | Thomas Munro | 2023-03-23 00:14:25 +0000 |
| commit | 8fba928fd78856712f69d96852f8061e77390fda (patch) | |
| tree | bad0cda018a6e277f7b4d92180edf55ea3eac057 /doc/src | |
| parent | 11470f544e3729c60fab890145b2e839cbc8905e (diff) | |
Improve the naming of Parallel Hash Join phases.
* Commit 3048898e dropped -ING from PHJ wait event names. Update the
corresponding barrier phases names to match.
* Rename the "DONE" phases to "FREE". That's symmetrical with
"ALLOCATE", and names the activity that actually happens in that phase
(as we do for the other phases) rather than a state. The bug fixed by
commit 8d578b9b might have been more obvious with this name.
* Rename the batch/bucket growth barriers' "ALLOCATE" phases to
"REALLOCATE", a better description of what they do.
* Update the high level comments about phases to highlight phases
are executed by a single process with an asterisk (mostly memory
management phases).
No behavior change, as this is just improving internal identifiers. The
only user-visible sign of this is that a couple of wait events' display
names change from "...Allocate" to "...Reallocate" in pg_stat_activity,
to stay in sync with the internal names.
Reviewed-by: Melanie Plageman <melanieplageman@gmail.com>
Discussion: https://postgr.es/m/CA%2BhUKG%2BMDpwF2Eo2LAvzd%3DpOh81wUTsrwU1uAwR-v6OGBB6%2B7g%40mail.gmail.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 2ae24127a83..7ab4424bf13 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -1701,11 +1701,6 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser the outer relation.</entry> </row> <row> - <entry><literal>HashGrowBatchesAllocate</literal></entry> - <entry>Waiting for an elected Parallel Hash participant to allocate more - batches.</entry> - </row> - <row> <entry><literal>HashGrowBatchesDecide</literal></entry> <entry>Waiting to elect a Parallel Hash participant to decide on future batch growth.</entry> @@ -1721,21 +1716,26 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser future batch growth.</entry> </row> <row> + <entry><literal>HashGrowBatchesReallocate</literal></entry> + <entry>Waiting for an elected Parallel Hash participant to allocate more + batches.</entry> + </row> + <row> <entry><literal>HashGrowBatchesRepartition</literal></entry> <entry>Waiting for other Parallel Hash participants to finish repartitioning.</entry> </row> <row> - <entry><literal>HashGrowBucketsAllocate</literal></entry> - <entry>Waiting for an elected Parallel Hash participant to finish - allocating more buckets.</entry> - </row> - <row> <entry><literal>HashGrowBucketsElect</literal></entry> <entry>Waiting to elect a Parallel Hash participant to allocate more buckets.</entry> </row> <row> + <entry><literal>HashGrowBucketsReallocate</literal></entry> + <entry>Waiting for an elected Parallel Hash participant to finish + allocating more buckets.</entry> + </row> + <row> <entry><literal>HashGrowBucketsReinsert</literal></entry> <entry>Waiting for other Parallel Hash participants to finish inserting tuples into new buckets.</entry> |