MySQL Internal Temporary Tables - RAM, mmap Overflow, and InnoDB Spill

GROUP BY · TempTable · filesort · LIMIT

MySQL 8.4.10captured evidence

01 · SOURCE

Exact SQL

1 active fragmentsMySQLGROUP BY · ORDER BY · LIMIT 100

SELECT account_id, status, bucket_id, COUNT(*) AS order_count, SUM(amount_cents) AS total_cents, MAX(payload) AS sample_payload
FROM work_orders
GROUP BY account_id, status, bucket_id
ORDER BY total_cents DESC, account_id, status, bucket_id
LIMIT 100;

source-scan
temporary-work
temporary-scan
filesort
limit

02 · FLOW

Native plan and actual iterators

01 / 12

Active native operators5

limitlimit

TREE: -> Limit: 100 row(s)
ANALYZE: -> Limit: 100 row(s)  (actual time=222..222 rows=100 loops=1)

TREE line 1; ANALYZE line 1

filesortsort

TREE:     -> Sort: total_cents DESC, work_orders.account_id, work_orders.`status`, work_orders.bucket_id, limit input to 100 row(s) per chunk
ANALYZE:     -> Sort: total_cents DESC, work_orders.account_id, work_orders.`status`, work_orders.bucket_id, limit input to 100 row(s) per chunk  (actual time=222..222 rows=100 loops=1)

TREE line 2; ANALYZE line 2

temporary-scantable-scan

TREE:         -> Table scan on <temporary>
ANALYZE:         -> Table scan on <temporary>  (actual time=196..209 rows=65536 loops=1)

TREE line 3; ANALYZE line 3

temporary-worktemp-table

TREE:             -> Aggregate using temporary table
ANALYZE:             -> Aggregate using temporary table  (actual time=196..196 rows=65536 loops=1)

TREE line 4; ANALYZE line 4

source-scantable-scan

TREE:                 -> Table scan on work_orders  (cost=15156 rows=128478)
ANALYZE:                 -> Table scan on work_orders  (cost=13513 rows=128478) (actual time=0.037..40.3 rows=131072 loops=1)

TREE line 5; ANALYZE line 5

Exact execution detail

131072 source rows become 100 result rows

How does this SQL reduce 131072 source rows to 100 result rows?

GROUP BY output

Logical temporary rows

Derived · fixture

65536 rows65536 omitted from this bounded view

Active metrics4

source scan actual rows: 131072 row
limit actual rows: 100 row
execution rows examined: 131172 row
execution rows sent: 100 row

How does this SQL reduce 131072 source rows to 100 result rows?

131072 source rows become 100 result rows

The 131072 rows in work_orders become 65536 aggregate rows through GROUP BY, then ORDER BY and LIMIT 100 return 100 rows. The current profile is TempTable RAM-resident.

Storage evidence

Derived · capture

ram-residentTempTable

RAM

Captured

baseline high-water: 0
current bytes: 1048608
high-water: 67109088

mmap

Captured

baseline high-water: 0
current bytes: 0
high-water: 0

Statement factsCaptured

Created_tmp_tables: 1
Created_tmp_disk_tables: 0
MAX_CONTROLLED_MEMORY: 67450431
MAX_TOTAL_MEMORY: 67474433

Frame metrics4

source scan actual rows: 131072 row
limit actual rows: 100 row
execution rows examined: 131172 row
execution rows sent: 100 row

Active evidence10

evidence:internal-temporary-work-ram-resident-explain-analyze-txt51cfcfb5c812aba483060683d50c50c543939b305557d62d7c17a020e8d1a8bb

Captured

evidence:internal-temporary-work-ram-resident-explain-json58863dfed445671d4f3f07905bf4972253b5e71c2dc755f83835c1f7acb64c31

Captured

evidence:internal-temporary-work-ram-resident-explain-tree-txt91d857f5a0e4782546ab8bf111ad264baf55d2f6a5f4e75f597406c70525e280

Captured

evidence:internal-temporary-work-ram-resident-memory-summary-after-json83185950f23e72953e653687f0fcdfc9ae174c33133e38ead9fb67e3ab1feec5

Captured

evidence:internal-temporary-work-ram-resident-memory-summary-before-jsonda5e25a6753942403bab5cfeb4c50f9e41ee3422bd64df6660219d1fb03b7d34

Captured

evidence:internal-temporary-work-ram-resident-memory-summary-delta25e2f773036435b42aa15e29de15c8de38ae8cebc34376257b5801d4abf428b7

Derived · capture

evidence:internal-temporary-work-ram-resident-session-status-deltaef06a0d2d0ee91286f7ecea79e018bd6851c19498f4ea105fd9cb9b101cbb8f9

Derived · capture

evidence:internal-temporary-work-ram-resident-statement-event-json6c83b6283ca7ead3dfc289a19d288604806d215a41c1ab26fa3498b999fc6173

Captured

evidence:internal-temporary-work.fixture-workbench-projection2f1bc804898b6765637bd18f90c117ea2c2287e16d71af00609f77c2557fe0fc

Derived · fixture

evidence:internal-temporary-work.ram-resident.workbench-plan86ffe039d8369a6c3279514aed0cc08c0ad225c45bc6853e48e45ec7eca314b8

Derived · capture

01 / 12

.internal-temporary-work-page { overflow: auto !important; } .internal-temporary-work-page main { height: auto !important; min-height: 100dvh; } .temporary-workbench-shell { display: none !important; } .temporary-noscript { width: min(100%, 88rem); margin: 0 auto; padding: 32px 20px 72px; color: #171a1d; overflow-wrap: anywhere; } .temporary-noscript > section { padding-block: 24px; border-bottom: 1px solid #d8dde1; } .temporary-noscript > section:last-child { border-bottom: 0; } .temporary-noscript h1 { margin: 8px 0 12px; font-size: 32px; line-height: 1.25; letter-spacing: 0; } .temporary-noscript h2 { margin: 0 0 14px; font-size: 22px; letter-spacing: 0; } .temporary-noscript h3 { margin: 20px 0 10px; font-size: 17px; letter-spacing: 0; } .temporary-noscript h4 { margin: 14px 0 8px; font-size: 15px; } .temporary-noscript p, .temporary-noscript li, .temporary-noscript dd, .temporary-noscript td, .temporary-noscript th { font-size: 14px; line-height: 1.6; } .temporary-noscript-eyebrow { margin: 0; color: #0d6d4d; font-size: 13px !important; font-weight: 800; } .temporary-noscript a { color: #174ca7; } .temporary-noscript-sql { max-width: 100%; padding: 16px; overflow-wrap: anywhere; border: 1px solid #d8dde1; background: #f7f9fa; font: 15px/1.65 "SFMono-Regular", Consolas, monospace; white-space: pre-wrap; } .temporary-noscript-facts { display: grid; grid-template-columns: repeat(2, minmax(0, 1fr)); gap: 1px; margin: 14px 0; background: #d8dde1; } .temporary-noscript-facts > div { display: grid; min-width: 0; gap: 5px; padding: 12px 14px; background: #fff; } .temporary-noscript-facts dt { color: #657078; font-size: 13px; font-weight: 800; } .temporary-noscript-facts dd { min-width: 0; margin: 0; } .temporary-noscript-profile { padding-block: 8px 18px; border-bottom: 1px solid #edf0f2; } .temporary-noscript-profile:last-child { border-bottom: 0; } .temporary-noscript-table-scroll { max-width: 100%; overflow-x: auto; } .temporary-noscript-table-scroll table { width: 100%; min-width: 780px; border-collapse: collapse; } .temporary-noscript-table-scroll th, .temporary-noscript-table-scroll td { padding: 8px 10px; border: 1px solid #d8dde1; text-align: left; vertical-align: top; } .temporary-noscript-table-scroll th { background: #f2f5f6; } .temporary-noscript-table-scroll code { display: block; max-width: 68ch; overflow-wrap: anywhere; white-space: normal; } .temporary-noscript-pair { display: grid; grid-template-columns: repeat(2, minmax(0, 1fr)); gap: 20px; } .temporary-noscript-steps { display: grid; grid-template-columns: repeat(2, minmax(0, 1fr)); gap: 1px; margin: 0; padding: 1px; background: #d8dde1; list-style-position: inside; } .temporary-noscript-steps li { padding: 14px; background: #fff; } .temporary-noscript-steps p { margin-bottom: 0; color: #46525a; } .temporary-noscript-checksum { word-break: break-all; } @media (max-width: 760px) { .temporary-noscript { padding-inline: 14px; } .temporary-noscript h1 { font-size: 26px; } .temporary-noscript-facts, .temporary-noscript-pair, .temporary-noscript-steps { grid-template-columns: minmax(0, 1fr); } }

SQL & capture identity · MySQL 8.4.10 · Captured

MySQL Internal Temporary Tables - RAM, mmap Overflow, and InnoDB Spill

Compare how one GROUP BY, ORDER BY, and LIMIT query executes across TempTable RAM, mmap overflow, and InnoDB on-disk profiles with exact evidence.

한국어

captureId: capture:internal-temporary-work-ram-resident
Engine: MySQL 8.4.10 · arm64
capturedAt: 2026-07-13T20:52:04.405Z
Frames: 12 per profile · 3 profiles

SQL

SELECT
  account_id,
  status,
  bucket_id,
  COUNT(*) AS order_count,
  SUM(amount_cents) AS total_cents,
  MAX(payload) AS sample_payload
FROM work_orders
GROUP BY account_id, status, bucket_id
ORDER BY total_cents DESC, account_id, status, bucket_id
LIMIT 100;

Settings and captured memory for three storage profiles

TempTable RAM-resident

captureId: capture:internal-temporary-work-ram-resident
Internal temporary table engine: TempTable · Derived · capture
tmp_table_size: 268435456 byte · Captured
temptable_max_ram: 268435456 byte · Captured
temptable_max_mmap: 0 byte · Captured
temptable_use_mmap: 0 count · Captured
sort_buffer_size: 8388608 byte · Captured

RAM allocator · Captured

baseline high-water: 0
current bytes: 1048608
high-water: 67109088

mmap allocator · Captured

baseline high-water: 0
current bytes: 0
high-water: 0

Created_tmp_tables: 1 · Captured
Created_tmp_disk_tables: 0 · Captured
MAX_CONTROLLED_MEMORY: 67450431 · Captured
MAX_TOTAL_MEMORY: 67474433 · Captured

TempTable mmap overflow

captureId: capture:internal-temporary-work-mmap-overflow
Internal temporary table engine: TempTable · Derived · capture
tmp_table_size: 268435456 byte · Captured
temptable_max_ram: 2097152 byte · Captured
temptable_max_mmap: 268435456 byte · Captured
temptable_use_mmap: 1 count · Captured
sort_buffer_size: 8388608 byte · Captured

RAM allocator · Captured

baseline high-water: 0
current bytes: 1048608
high-water: 1048608

mmap allocator · Captured

baseline high-water: 0
current bytes: 0
high-water: 66060480

Created_tmp_tables: 1 · Captured
Created_tmp_disk_tables: 0 · Captured
MAX_CONTROLLED_MEMORY: 67450431 · Captured
MAX_TOTAL_MEMORY: 67474434 · Captured

Model · ram-to-mmap-allocation

InnoDB on-disk

captureId: capture:internal-temporary-work-innodb-on-disk
Internal temporary table engine: InnoDB · Derived · capture
tmp_table_size: 4194304 byte · Captured
temptable_max_ram: 268435456 byte · Captured
temptable_max_mmap: 0 byte · Captured
temptable_use_mmap: 0 count · Captured
sort_buffer_size: 8388608 byte · Captured

RAM allocator · Captured

baseline high-water: 0
current bytes: 1048608
high-water: 8388736

mmap allocator · Captured

baseline high-water: 0
current bytes: 0
high-water: 0

Created_tmp_tables: 1 · Captured
Created_tmp_disk_tables: 1 · Captured
MAX_CONTROLLED_MEMORY: 8585888 · Captured
MAX_TOTAL_MEMORY: 8629970 · Captured

Model · temptable-to-innodb

Native plan and actual iterators

TempTable RAM-resident

operator	kind	parent	metrics	native TREE + ANALYZE
`limit`	limit	`ROOT`	`limit-actual-first-row-ms`: 222 `limit-actual-last-row-ms`: 222 `limit-actual-rows`: 100 row `limit-loops`: 1 count	`TREE: -> Limit: 100 row(s) ANALYZE: -> Limit: 100 row(s) (actual time=222..222 rows=100 loops=1)`TREE line 1; ANALYZE line 1
`filesort`	sort	`limit`	`filesort-actual-first-row-ms`: 222 `filesort-actual-last-row-ms`: 222 `filesort-actual-rows`: 100 row `filesort-loops`: 1 count	TREE: -> Sort: total_cents DESC, work_orders.account_id, work_orders.`status`, work_orders.bucket_id, limit input to 100 row(s) per chunk ANALYZE: -> Sort: total_cents DESC, work_orders.account_id, work_orders.`status`, work_orders.bucket_id, limit input to 100 row(s) per chunk (actual time=222..222 rows=100 loops=1)TREE line 2; ANALYZE line 2
`temporary-scan`	table-scan	`filesort`	`temporary-scan-actual-first-row-ms`: 196 `temporary-scan-actual-last-row-ms`: 209 `temporary-scan-actual-rows`: 65536 row `temporary-scan-loops`: 1 count	`TREE: -> Table scan on <temporary> ANALYZE: -> Table scan on <temporary> (actual time=196..209 rows=65536 loops=1)`TREE line 3; ANALYZE line 3
`temporary-work`	temp-table	`temporary-scan`	`temporary-work-actual-first-row-ms`: 196 `temporary-work-actual-last-row-ms`: 196 `temporary-work-actual-rows`: 65536 row `temporary-work-loops`: 1 count	`TREE: -> Aggregate using temporary table ANALYZE: -> Aggregate using temporary table (actual time=196..196 rows=65536 loops=1)`TREE line 4; ANALYZE line 4
`source-scan`	table-scan	`temporary-work`	`source-scan-actual-first-row-ms`: 0.037 `source-scan-actual-last-row-ms`: 40.3 `source-scan-actual-rows`: 131072 row `source-scan-loops`: 1 count `source-scan-estimated-rows`: 128478 row `source-scan-estimated-cost`: 13513 cost-unit	`TREE: -> Table scan on work_orders (cost=15156 rows=128478) ANALYZE: -> Table scan on work_orders (cost=13513 rows=128478) (actual time=0.037..40.3 rows=131072 loops=1)`TREE line 5; ANALYZE line 5

TempTable mmap overflow

operator	kind	parent	metrics	native TREE + ANALYZE
`limit`	limit	`ROOT`	`limit-actual-first-row-ms`: 339 `limit-actual-last-row-ms`: 339 `limit-actual-rows`: 100 row `limit-loops`: 1 count	`TREE: -> Limit: 100 row(s) ANALYZE: -> Limit: 100 row(s) (actual time=339..339 rows=100 loops=1)`TREE line 1; ANALYZE line 1
`filesort`	sort	`limit`	`filesort-actual-first-row-ms`: 339 `filesort-actual-last-row-ms`: 339 `filesort-actual-rows`: 100 row `filesort-loops`: 1 count	TREE: -> Sort: total_cents DESC, work_orders.account_id, work_orders.`status`, work_orders.bucket_id, limit input to 100 row(s) per chunk ANALYZE: -> Sort: total_cents DESC, work_orders.account_id, work_orders.`status`, work_orders.bucket_id, limit input to 100 row(s) per chunk (actual time=339..339 rows=100 loops=1)TREE line 2; ANALYZE line 2
`temporary-scan`	table-scan	`filesort`	`temporary-scan-actual-first-row-ms`: 313 `temporary-scan-actual-last-row-ms`: 325 `temporary-scan-actual-rows`: 65536 row `temporary-scan-loops`: 1 count	`TREE: -> Table scan on <temporary> ANALYZE: -> Table scan on <temporary> (actual time=313..325 rows=65536 loops=1)`TREE line 3; ANALYZE line 3
`temporary-work`	temp-table	`temporary-scan`	`temporary-work-actual-first-row-ms`: 313 `temporary-work-actual-last-row-ms`: 313 `temporary-work-actual-rows`: 65536 row `temporary-work-loops`: 1 count	`TREE: -> Aggregate using temporary table ANALYZE: -> Aggregate using temporary table (actual time=313..313 rows=65536 loops=1)`TREE line 4; ANALYZE line 4
`source-scan`	table-scan	`temporary-work`	`source-scan-actual-first-row-ms`: 0.0416 `source-scan-actual-last-row-ms`: 40.3 `source-scan-actual-rows`: 131072 row `source-scan-loops`: 1 count `source-scan-estimated-rows`: 128478 row `source-scan-estimated-cost`: 13513 cost-unit	`TREE: -> Table scan on work_orders (cost=15156 rows=128478) ANALYZE: -> Table scan on work_orders (cost=13513 rows=128478) (actual time=0.0416..40.3 rows=131072 loops=1)`TREE line 5; ANALYZE line 5

InnoDB on-disk

operator	kind	parent	metrics	native TREE + ANALYZE
`limit`	limit	`ROOT`	`limit-actual-first-row-ms`: 671 `limit-actual-last-row-ms`: 671 `limit-actual-rows`: 100 row `limit-loops`: 1 count	`TREE: -> Limit: 100 row(s) ANALYZE: -> Limit: 100 row(s) (actual time=671..671 rows=100 loops=1)`TREE line 1; ANALYZE line 1
`filesort`	sort	`limit`	`filesort-actual-first-row-ms`: 671 `filesort-actual-last-row-ms`: 671 `filesort-actual-rows`: 100 row `filesort-loops`: 1 count	TREE: -> Sort: total_cents DESC, work_orders.account_id, work_orders.`status`, work_orders.bucket_id, limit input to 100 row(s) per chunk ANALYZE: -> Sort: total_cents DESC, work_orders.account_id, work_orders.`status`, work_orders.bucket_id, limit input to 100 row(s) per chunk (actual time=671..671 rows=100 loops=1)TREE line 2; ANALYZE line 2
`temporary-scan`	table-scan	`filesort`	`temporary-scan-actual-first-row-ms`: 636 `temporary-scan-actual-last-row-ms`: 657 `temporary-scan-actual-rows`: 65536 row `temporary-scan-loops`: 1 count	`TREE: -> Table scan on <temporary> ANALYZE: -> Table scan on <temporary> (actual time=636..657 rows=65536 loops=1)`TREE line 3; ANALYZE line 3
`temporary-work`	temp-table	`temporary-scan`	`temporary-work-actual-first-row-ms`: 636 `temporary-work-actual-last-row-ms`: 636 `temporary-work-actual-rows`: 65536 row `temporary-work-loops`: 1 count	`TREE: -> Aggregate using temporary table ANALYZE: -> Aggregate using temporary table (actual time=636..636 rows=65536 loops=1)`TREE line 4; ANALYZE line 4
`source-scan`	table-scan	`temporary-work`	`source-scan-actual-first-row-ms`: 0.042 `source-scan-actual-last-row-ms`: 42.3 `source-scan-actual-rows`: 131072 row `source-scan-loops`: 1 count `source-scan-estimated-rows`: 128478 row `source-scan-estimated-cost`: 13513 cost-unit	`TREE: -> Table scan on work_orders (cost=15156 rows=128478) ANALYZE: -> Table scan on work_orders (cost=13513 rows=128478) (actual time=0.042..42.3 rows=131072 loops=1)`TREE line 5; ANALYZE line 5

Exact GROUP BY, filesort, and LIMIT rows

work_orders source sample

131072 rows · 131064 omitted · Derived · fixture

id	account_id	status	bucket_id	amount_cents	payload
1	1	NEW	0	0	`payload-000000xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
2	1	NEW	0	37	`payload-000001xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
3	1	NEW	1	74	`payload-000002xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
4	1	NEW	1	111	`payload-000003xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
131069	2048	CANCELLED	6	49516	`payload-131068xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
131070	2048	CANCELLED	6	49553	`payload-131069xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
131071	2048	CANCELLED	7	49590	`payload-131070xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
131072	2048	CANCELLED	7	49627	`payload-131071xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`

Two member rows for one GROUP BY key

423 / PAID / 1 · Derived · fixture

id	account_id	status	bucket_id	amount_cents	payload
27027	423	PAID	1	99962	`payload-027026xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
27028	423	PAID	1	99999	`payload-027027xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`

COUNT, SUM, and MAX accumulator

COUNT(*): 2
SUM(amount_cents): 199961
MAX(payload): payload-027027xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Eight rows before ORDER BY

row	total_cents	account_id	status	bucket_id
`aggregate-row-423-paid-1`	199961	423	PAID	1
`aggregate-row-549-cancelled-7`	199953	549	CANCELLED	7
`aggregate-row-676-shipped-5`	199945	676	SHIPPED	5
`aggregate-row-803-paid-3`	199937	803	PAID	3
`aggregate-row-1267-cancelled-4`	199957	1267	CANCELLED	4
`aggregate-row-1394-shipped-2`	199949	1394	SHIPPED	2
`aggregate-row-1521-paid-0`	199941	1521	PAID	0
`aggregate-row-1985-cancelled-1`	199961	1985	CANCELLED	1

The same eight rows after ORDER BY

row	total_cents DESC	account_id	status	bucket_id
`aggregate-row-423-paid-1`	199961	423	PAID	1
`aggregate-row-1985-cancelled-1`	199961	1985	CANCELLED	1
`aggregate-row-1267-cancelled-4`	199957	1267	CANCELLED	4
`aggregate-row-549-cancelled-7`	199953	549	CANCELLED	7
`aggregate-row-1394-shipped-2`	199949	1394	SHIPPED	2
`aggregate-row-676-shipped-5`	199945	676	SHIPPED	5
`aggregate-row-1521-paid-0`	199941	1521	PAID	0
`aggregate-row-803-paid-3`	199937	803	PAID	3

LIMIT 100 boundary

boundary	row	total_cents	account_id	status	bucket_id
Row 100 · included	`aggregate-row-549-cancelled-5`	199657	549	CANCELLED	5
Row 101 · excluded	`aggregate-row-1394-shipped-0`	199653	1394	SHIPPED	0

Exact 100-row result

100 rows · SHA-256 1c49507ed73d3ebe41637f5148435ea9f87df3b04fee50a513e660faf5b96d33 · Derived · capture

#	account_id	status	bucket_id	order_count	total_cents	sample_payload
1	423	PAID	1	2	199961	`payload-027027xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
2	1985	CANCELLED	1	2	199961	`payload-127027xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
3	1267	CANCELLED	4	2	199957	`payload-081081xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
4	549	CANCELLED	7	2	199953	`payload-035135xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
5	1394	SHIPPED	2	2	199949	`payload-089189xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
6	676	SHIPPED	5	2	199945	`payload-043243xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
7	1521	PAID	0	2	199941	`payload-097297xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
8	803	PAID	3	2	199937	`payload-051351xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
9	85	PAID	6	2	199933	`payload-005405xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
10	1647	CANCELLED	6	2	199933	`payload-105405xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
11	930	NEW	1	2	199929	`payload-059459xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
12	212	NEW	4	2	199925	`payload-013513xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
13	1774	SHIPPED	4	2	199925	`payload-113513xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
14	1056	SHIPPED	7	2	199921	`payload-067567xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
15	338	CANCELLED	2	2	199917	`payload-021621xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
16	1901	PAID	2	2	199917	`payload-121621xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
17	1183	PAID	5	2	199913	`payload-075675xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
18	465	SHIPPED	0	2	199909	`payload-029729xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
19	2028	NEW	0	2	199909	`payload-129729xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
20	1310	NEW	3	2	199905	`payload-083783xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
21	592	NEW	6	2	199901	`payload-037837xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
22	1436	CANCELLED	1	2	199897	`payload-091891xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
23	718	CANCELLED	4	2	199893	`payload-045945xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
24	1563	PAID	7	2	199889	`payload-099999xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
25	845	SHIPPED	2	2	199885	`payload-054053xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
26	127	SHIPPED	5	2	199881	`payload-008107xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
27	1690	NEW	5	2	199881	`payload-108107xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
28	972	PAID	0	2	199877	`payload-062161xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
29	254	PAID	3	2	199873	`payload-016215xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
30	1816	CANCELLED	3	2	199873	`payload-116215xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
31	1098	CANCELLED	6	2	199869	`payload-070269xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
32	381	NEW	1	2	199865	`payload-024323xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
33	1943	SHIPPED	1	2	199865	`payload-124323xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
34	1225	SHIPPED	4	2	199861	`payload-078377xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
35	507	SHIPPED	7	2	199857	`payload-032431xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
36	1352	PAID	2	2	199853	`payload-086485xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
37	634	PAID	5	2	199849	`payload-040539xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
38	1479	NEW	0	2	199845	`payload-094593xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
39	761	NEW	3	2	199841	`payload-048647xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
40	43	NEW	6	2	199837	`payload-002701xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
41	1605	SHIPPED	6	2	199837	`payload-102701xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
42	887	CANCELLED	1	2	199833	`payload-056755xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
43	169	CANCELLED	4	2	199829	`payload-010809xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
44	1732	PAID	4	2	199829	`payload-110809xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
45	1014	PAID	7	2	199825	`payload-064863xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
46	296	SHIPPED	2	2	199821	`payload-018917xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
47	1859	NEW	2	2	199821	`payload-118917xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
48	1141	NEW	5	2	199817	`payload-072971xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
49	423	PAID	0	2	199813	`payload-027025xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
50	1985	CANCELLED	0	2	199813	`payload-127025xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
51	1267	CANCELLED	3	2	199809	`payload-081079xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
52	549	CANCELLED	6	2	199805	`payload-035133xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
53	1394	SHIPPED	1	2	199801	`payload-089187xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
54	676	SHIPPED	4	2	199797	`payload-043241xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
55	1521	NEW	7	2	199793	`payload-097295xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
56	803	PAID	2	2	199789	`payload-051349xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
57	85	PAID	5	2	199785	`payload-005403xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
58	1647	CANCELLED	5	2	199785	`payload-105403xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
59	930	NEW	0	2	199781	`payload-059457xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
60	212	NEW	3	2	199777	`payload-013511xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
61	1774	SHIPPED	3	2	199777	`payload-113511xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
62	1056	SHIPPED	6	2	199773	`payload-067565xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
63	338	CANCELLED	1	2	199769	`payload-021619xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
64	1901	PAID	1	2	199769	`payload-121619xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
65	1183	PAID	4	2	199765	`payload-075673xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
66	465	PAID	7	2	199761	`payload-029727xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
67	2027	CANCELLED	7	2	199761	`payload-129727xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
68	1310	NEW	2	2	199757	`payload-083781xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
69	592	NEW	5	2	199753	`payload-037835xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
70	1436	CANCELLED	0	2	199749	`payload-091889xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
71	718	CANCELLED	3	2	199745	`payload-045943xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
72	1563	PAID	6	2	199741	`payload-099997xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
73	845	SHIPPED	1	2	199737	`payload-054051xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
74	127	SHIPPED	4	2	199733	`payload-008105xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
75	1690	NEW	4	2	199733	`payload-108105xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
76	972	NEW	7	2	199729	`payload-062159xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
77	254	PAID	2	2	199725	`payload-016213xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
78	1816	CANCELLED	2	2	199725	`payload-116213xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
79	1098	CANCELLED	5	2	199721	`payload-070267xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
80	381	NEW	0	2	199717	`payload-024321xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
81	1943	SHIPPED	0	2	199717	`payload-124321xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
82	1225	SHIPPED	3	2	199713	`payload-078375xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
83	507	SHIPPED	6	2	199709	`payload-032429xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
84	1352	PAID	1	2	199705	`payload-086483xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
85	634	PAID	4	2	199701	`payload-040537xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
86	1478	CANCELLED	7	2	199697	`payload-094591xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
87	761	NEW	2	2	199693	`payload-048645xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
88	43	NEW	5	2	199689	`payload-002699xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
89	1605	SHIPPED	5	2	199689	`payload-102699xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
90	887	CANCELLED	0	2	199685	`payload-056753xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
91	169	CANCELLED	3	2	199681	`payload-010807xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
92	1732	PAID	3	2	199681	`payload-110807xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
93	1014	PAID	6	2	199677	`payload-064861xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
94	296	SHIPPED	1	2	199673	`payload-018915xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
95	1859	NEW	1	2	199673	`payload-118915xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
96	1141	NEW	4	2	199669	`payload-072969xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
97	423	NEW	7	2	199665	`payload-027023xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
98	1985	SHIPPED	7	2	199665	`payload-127023xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
99	1267	CANCELLED	2	2	199661	`payload-081077xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`
100	549	CANCELLED	5	2	199657	`payload-035131xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`

Full explanation · Complete 12-step explanation

TempTable RAM-resident

131072 source rows become 100 result rows
How does this SQL reduce 131072 source rows to 100 result rows?
The 131072 rows in work_orders become 65536 aggregate rows through GROUP BY, then ORDER BY and LIMIT 100 return 100 rows. The current profile is TempTable RAM-resident.
The native plan contains both temporary work and filesort
Where do internal temporary work and filesort appear in the native plan?
The accepted plan connects temporary-work, temporary-scan, filesort, and limit. The TempTable RAM-resident classification combines settings, statement counters, and allocator evidence rather than relying on the plan alone.
source-scan reads 131072 rows from work_orders
Which rows enter the source-scan operator?
The table shows the first four and last four rows in primary-key order. This is the fixture sample policy, not the engine's row-visit order.
Two rows form the account 423 / PAID / bucket 1 group
Which source rows form one GROUP BY key?
Rows 27027 and 27028 share account_id, status, and bucket_id, so they enter the same GROUP BY key. The right panel shows the final captured allocation summary for TempTable RAM-resident.
COUNT, SUM, and MAX produce one aggregate row
Which COUNT, SUM, and MAX values do the two member rows produce?
The two members produce COUNT(*)=2 and SUM(amount_cents)=199961. MAX(payload) is the payload from row 27028; the accumulator below shows its full value. Statement-wide MAX_CONTROLLED_MEMORY=67450431 and MAX_TOTAL_MEMORY=67474433 are final captured evidence for TempTable RAM-resident.
65536 aggregate rows form the temporary rowset
What temporary rowset does GROUP BY produce?
temporary-scan reads the GROUP BY output. The table is a deterministic eight-row sample; together with the omitted 65528 rows, the rowset contains 65536 rows.
The TempTable work remains in the RAM-resident profile
Which captured evidence distinguishes the RAM-resident storage profile?
physical_ram high-water is 67109088 bytes, physical_disk high-water is 0 bytes, and Created_tmp_disk_tables is 0. This captured evidence produces the RAM-resident classification.
Separate the 65536 logical rows from SORT_ROWS
What do the logical filesort input and SORT_ROWS each represent?
The logical ORDER BY input contains 65536 fixture-derived rows. The statement-level SORT_ROWS value is 100; the two values do not count the same fact. SORT_MERGE_PASSES is 0.
Four ORDER BY keys rearrange the same eight rows
How do the four ORDER BY keys rearrange the same row set?
The before and after views use the same row identities. total_cents DESC, account_id, status, and bucket_id determine the final order. Using filesort identifies a separate sort phase, not a disk spill.
Row 100 is included and row 101 is excluded
Where does LIMIT 100 cut the ordered set?
account 549 / CANCELLED / bucket 5 is the last row included by LIMIT 100. account 1394 / SHIPPED / bucket 0 is next under the same ORDER BY but is excluded from the result.
All three profiles return the same 100 rows and checksum
Do the three storage profiles return the same result?
The current profile result checksum is 1c49507ed73d3ebe41637f5148435ea9f87df3b04fee50a513e660faf5b96d33. The three accepted normalized result evidence records close over the same rows, order, and checksum.
One evidence closure binds the native plan, fixture, counters, and result
Which evidence closes the current plan, fixture rows, counters, and result?
Capture capture:internal-temporary-work-ram-resident, MySQL 8.4.10, accepted settings, native plan locators, statement and allocator evidence, the fixture checksum, and cross-profile result evidence close the current document.

TempTable mmap overflow

131072 source rows become 100 result rows
How does this SQL reduce 131072 source rows to 100 result rows?
The 131072 rows in work_orders become 65536 aggregate rows through GROUP BY, then ORDER BY and LIMIT 100 return 100 rows. The current profile is TempTable mmap overflow.
The native plan contains both temporary work and filesort
Where do internal temporary work and filesort appear in the native plan?
The accepted plan connects temporary-work, temporary-scan, filesort, and limit. The TempTable mmap overflow classification combines settings, statement counters, and allocator evidence rather than relying on the plan alone.
source-scan reads 131072 rows from work_orders
Which rows enter the source-scan operator?
The table shows the first four and last four rows in primary-key order. This is the fixture sample policy, not the engine's row-visit order.
Two rows form the account 423 / PAID / bucket 1 group
Which source rows form one GROUP BY key?
Rows 27027 and 27028 share account_id, status, and bucket_id, so they enter the same GROUP BY key. The right panel shows the final captured allocation summary for TempTable mmap overflow.
COUNT, SUM, and MAX produce one aggregate row
Which COUNT, SUM, and MAX values do the two member rows produce?
The two members produce COUNT(*)=2 and SUM(amount_cents)=199961. MAX(payload) is the payload from row 27028; the accumulator below shows its full value. Statement-wide MAX_CONTROLLED_MEMORY=67450431 and MAX_TOTAL_MEMORY=67474434 are final captured evidence for TempTable mmap overflow.
65536 aggregate rows form the temporary rowset
What temporary rowset does GROUP BY produce?
temporary-scan reads the GROUP BY output. The table is a deterministic eight-row sample; together with the omitted 65528 rows, the rowset contains 65536 rows.
New TempTable allocations use mmap
Which captured evidence distinguishes the mmap overflow storage profile?
physical_ram high-water is 1048608 bytes, physical_disk high-water is 66060480 bytes, and Created_tmp_disk_tables is 0. The Model shows later allocations using mmap-backed storage; it does not show existing RAM rows moving into mmap.
Separate the 65536 logical rows from SORT_ROWS
What do the logical filesort input and SORT_ROWS each represent?
The logical ORDER BY input contains 65536 fixture-derived rows. The statement-level SORT_ROWS value is 100; the two values do not count the same fact. SORT_MERGE_PASSES is 0.
Four ORDER BY keys rearrange the same eight rows
How do the four ORDER BY keys rearrange the same row set?
The before and after views use the same row identities. total_cents DESC, account_id, status, and bucket_id determine the final order. Using filesort identifies a separate sort phase, not a disk spill.
Row 100 is included and row 101 is excluded
Where does LIMIT 100 cut the ordered set?
account 549 / CANCELLED / bucket 5 is the last row included by LIMIT 100. account 1394 / SHIPPED / bucket 0 is next under the same ORDER BY but is excluded from the result.
All three profiles return the same 100 rows and checksum
Do the three storage profiles return the same result?
The current profile result checksum is 1c49507ed73d3ebe41637f5148435ea9f87df3b04fee50a513e660faf5b96d33. The three accepted normalized result evidence records close over the same rows, order, and checksum.
One evidence closure binds the native plan, fixture, counters, and result
Which evidence closes the current plan, fixture rows, counters, and result?
Capture capture:internal-temporary-work-mmap-overflow, MySQL 8.4.10, accepted settings, native plan locators, statement and allocator evidence, the fixture checksum, and cross-profile result evidence close the current document.

InnoDB on-disk

131072 source rows become 100 result rows
How does this SQL reduce 131072 source rows to 100 result rows?
The 131072 rows in work_orders become 65536 aggregate rows through GROUP BY, then ORDER BY and LIMIT 100 return 100 rows. The current profile is InnoDB on-disk.
The native plan contains both temporary work and filesort
Where do internal temporary work and filesort appear in the native plan?
The accepted plan connects temporary-work, temporary-scan, filesort, and limit. The InnoDB on-disk classification combines settings, statement counters, and allocator evidence rather than relying on the plan alone.
source-scan reads 131072 rows from work_orders
Which rows enter the source-scan operator?
The table shows the first four and last four rows in primary-key order. This is the fixture sample policy, not the engine's row-visit order.
Two rows form the account 423 / PAID / bucket 1 group
Which source rows form one GROUP BY key?
Rows 27027 and 27028 share account_id, status, and bucket_id, so they enter the same GROUP BY key. The right panel shows the final captured allocation summary for InnoDB on-disk.
COUNT, SUM, and MAX produce one aggregate row
Which COUNT, SUM, and MAX values do the two member rows produce?
The two members produce COUNT(*)=2 and SUM(amount_cents)=199961. MAX(payload) is the payload from row 27028; the accumulator below shows its full value. Statement-wide MAX_CONTROLLED_MEMORY=8585888 and MAX_TOTAL_MEMORY=8629970 are final captured evidence for InnoDB on-disk.
65536 aggregate rows form the temporary rowset
What temporary rowset does GROUP BY produce?
temporary-scan reads the GROUP BY output. The table is a deterministic eight-row sample; together with the omitted 65528 rows, the rowset contains 65536 rows.
An InnoDB on-disk temporary table follows TempTable RAM use
Which captured evidence distinguishes the InnoDB on-disk storage profile?
physical_ram high-water is 8388736 bytes and Created_tmp_disk_tables is 1. mmap is disabled, and physical_disk high-water 0 bytes does not rise above its 0-byte baseline. The Model is a conversion boundary without assigning it to an exact row or time.
Separate the 65536 logical rows from SORT_ROWS
What do the logical filesort input and SORT_ROWS each represent?
The logical ORDER BY input contains 65536 fixture-derived rows. The statement-level SORT_ROWS value is 100; the two values do not count the same fact. SORT_MERGE_PASSES is 0.
Four ORDER BY keys rearrange the same eight rows
How do the four ORDER BY keys rearrange the same row set?
The before and after views use the same row identities. total_cents DESC, account_id, status, and bucket_id determine the final order. Using filesort identifies a separate sort phase, not a disk spill.
Row 100 is included and row 101 is excluded
Where does LIMIT 100 cut the ordered set?
account 549 / CANCELLED / bucket 5 is the last row included by LIMIT 100. account 1394 / SHIPPED / bucket 0 is next under the same ORDER BY but is excluded from the result.
All three profiles return the same 100 rows and checksum
Do the three storage profiles return the same result?
The current profile result checksum is 1c49507ed73d3ebe41637f5148435ea9f87df3b04fee50a513e660faf5b96d33. The three accepted normalized result evidence records close over the same rows, order, and checksum.
One evidence closure binds the native plan, fixture, counters, and result
Which evidence closes the current plan, fixture rows, counters, and result?
Capture capture:internal-temporary-work-innodb-on-disk, MySQL 8.4.10, accepted settings, native plan locators, statement and allocator evidence, the fixture checksum, and cross-profile result evidence close the current document.

Result identity and evidence boundaries

Captured: Native plan excerpts, actual iterator metrics, settings, statement counters, and allocator observations from each accepted MySQL capture
Derived · capture: Normalized storage classification and result checksum linked to accepted capture evidence
Derived · fixture: Exact source members, aggregate rows, sort samples, LIMIT boundary, and deterministic result membership
Model: Frame 7 allocation or conversion boundary, kept separate from captured byte counters

Three-profile result identity · 100 rows · 1c49507ed73d3ebe41637f5148435ea9f87df3b04fee50a513e660faf5b96d33

evidence:internal-temporary-work-innodb-on-disk-result-normalized
evidence:internal-temporary-work-mmap-overflow-result-normalized
evidence:internal-temporary-work-ram-resident-result-normalized

TempTable RAM-resident · capture:internal-temporary-work-ram-resident · 20 browser evidence records
TempTable mmap overflow · capture:internal-temporary-work-mmap-overflow · 20 browser evidence records
InnoDB on-disk · capture:internal-temporary-work-innodb-on-disk · 20 browser evidence records