Horton

explain-sort-skipped.patch

application/octet-stream

Download
Filename: explain-sort-skipped.patch
Type: application/octet-stream
Part: 0
Message: [PATCH] Make skipped sort explicit in EXPLAIN ANALYZE

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
File+−
src/backend/utils/sort/tuplesort.c 0 0 
diff --git a/src/backend/utils/sort/tuplesort.c b/src/backend/utils/sort/tuplesort.c
new file mode 100644
index 8969818..f7d6bf9
*** a/src/backend/utils/sort/tuplesort.c
--- b/src/backend/utils/sort/tuplesort.c
*************** tuplesort_get_stats(Tuplesortstate *stat
*** 2376,2382 ****
  	switch (state->status)
  	{
  		case TSS_SORTEDINMEM:
! 			if (state->boundUsed)
  				*sortMethod = "top-N heapsort";
  			else
  				*sortMethod = "quicksort";
--- 2376,2384 ----
  	switch (state->status)
  	{
  		case TSS_SORTEDINMEM:
! 			if (state->memtupcount <= 1)
! 				*sortMethod = "skipped";
! 			else if (state->boundUsed)
  				*sortMethod = "top-N heapsort";
  			else
  				*sortMethod = "quicksort";