{"Entry":{"collection":"plan","key":"worktable-scan","name":"WorkTable Scan","aliases":["T_WorkTableScan","WorkTable Scan","WorkTableScan"],"metadata":{"aliases":["T_WorkTableScan","WorkTable Scan","WorkTableScan"],"category":"Scan","content_hash":"d02078fa00cc8dd41b3ea0da69566a233dd28df3267ae3694c3c7ec3e533e794","imported_at":"2026-09-30T00:40:44.281574+08:00","name":"WorkTable Scan","name_zh":"WorkTableScan","slug":"worktable-scan","summary":"Reads the current working table of a recursive union."}},"Definition":{"Collection":"plan","Key":"worktable-scan","SourceDatabase":"center","Version":"18","SourceTable":"plan_node","SourceKey":"worktable-scan","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","Facts":{"comparison_data":{"initializer":"ExecInitWorkTableScan","memory_mechanism":"unclassified","node_tag":"T_WorkTableScan","parallel_callbacks":[],"partial_modes":[],"strategies":[],"text_names":["WorkTable Scan"]},"comparison_hash":"71b471dbdc054af8e4fa93bbbd9076da1fe3facccf5d5a46389f2bab3721761d","description":["Reads the current working table of a recursive union."],"evidence_kind":"source and documentation","explain_names":["WorkTable Scan"],"explain_prefixes":["Parallel","Async"],"facts":[{"label":"Core node tag","value":"T_WorkTableScan"},{"label":"Structured EXPLAIN Node Type","value":"WorkTable Scan"},{"label":"Inputs","value":"The recursive query working table"},{"label":"Output","value":"Working-table tuples"},{"label":"Executor initializer","value":"ExecInitWorkTableScan"},{"label":"Memory mechanism","value":"unclassified"}],"memory":{"description":"This extraction does not assign a universal memory limit or spill policy to this node. Inspect the same-build implementation and its expressions or provider.","evidence":[{"archive_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","label":"src/backend/executor/nodeWorktablescan.c","path":"src/backend/executor/nodeWorktablescan.c","sha256":"912d71e785d7f013d5889e3389deff289a01e35fa2c3aafa2345939fbb988834","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"}],"mechanism":"unclassified","source_notes":[]},"node_tag":"T_WorkTableScan","parallel_callbacks":[],"partial_modes":[],"related":[{"label":"EXPLAIN","url":"/wiki/sql/explain/?v=18"},{"label":"Using EXPLAIN","url":"/docs/18/using-explain.html"},{"label":"Parallel plans","url":"/docs/18/parallel-plans.html"}],"release":{"channel":"stable","label":"18.6","major":"18","ref":"PostgreSQL 18.6 source archive","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_snapshot_utc":"","source_url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"},"runtime_verified":false,"sections":[{"paragraphs":["Structured formats use the Node Type above. Text-format spellings can also include operation, strategy, join type, scan direction or aggregation-stage attributes.","Text names recorded by this source: WorkTable Scan.","Parallel-aware and parallel-safe are different plan properties. A node running inside a parallel worker is not necessarily a parallel-aware node."],"title":"EXPLAIN names and attributes"},{"paragraphs":["This extraction does not assign a universal memory limit or spill policy to this node. Inspect the same-build implementation and its expressions or provider."],"title":"Memory and temporary storage"},{"paragraphs":["The source callbacks below can coordinate execution or collect worker instrumentation. Their presence is not a blanket claim that this node supports a shared parallel scan or shared state.","Callbacks in this build: none extracted from this node implementation."],"title":"Parallel execution and instrumentation"},{"paragraphs":["Note: we intentionally do not support backward scan. Although it would take only a couple more lines here, it would force nodeRecursiveunion.c to create the tuplestore with backward scan enabled, which has a performance cost. In practice backward scan is never useful for a worktable plan node, since it cannot appear high enough in the plan tree of a scrollable cursor to be exposed to a backward-scan requirement. So it's not worth expending effort to support it.","Note: we are also assuming that this node is the only reader of the worktable. Therefore, we don't need a private read pointer for the tuplestore, nor do we need to tell tuplestore_gettupleslot to copy.","Get the next tuple from tuplestore. Return NULL if no more tuples.","WorkTableScanRecheck -- access method routine to recheck a tuple in EvalPlanQual","Scans the worktable sequentially and returns the next qualifying tuple. We call the ExecScan() routine and pass it the appropriate access method functions."],"title":"Executor implementation notes"},{"code":"case T_WorkTableScan:\n\t\t\tpname = sname = \"WorkTable Scan\";\n\t\t\tbreak;","title":"EXPLAIN identity in core source"}],"source_inventory":{"executor":"src/backend/executor/execProcnode.c","explain":"src/backend/commands/explain.c","implementation":"src/backend/executor/nodeWorktablescan.c"},"sources":[{"archive_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","label":"src/backend/commands/explain.c:1480","line":1480,"path":"src/backend/commands/explain.c","sha256":"34c86d6070224a0e981efef51f79101d6d505e5874f1684ace183034bab14bb4","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"},{"archive_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","label":"src/backend/executor/execProcnode.c:279","line":279,"path":"src/backend/executor/execProcnode.c","sha256":"f8a06a3f539077249b20664b2812433db6d7bd12b2c0ca633525db43d06f112a","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"},{"archive_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","label":"src/backend/executor/nodeWorktablescan.c","path":"src/backend/executor/nodeWorktablescan.c","sha256":"912d71e785d7f013d5889e3389deff289a01e35fa2c3aafa2345939fbb988834","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"},{"archive_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","label":"src/include/nodes/plannodes.h","path":"src/include/nodes/plannodes.h","sha256":"52422b327a8049fbbb20d8b96008a0fc0a6fafa60f7eff3c695d5b2e83830120","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"}],"strategies":[],"tables":[{"columns":[{"key":"label","label":"Text-format label"},{"key":"identity","label":"Structured node identity"}],"key":"explain-labels","rows":[{"identity":"WorkTable Scan","label":"WorkTable Scan"}],"title":"EXPLAIN labels in this source build"}]},"ManualEvidence":{"release":{"channel":"stable","label":"18.6","major":"18","ref":"PostgreSQL 18.6 source archive","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_snapshot_utc":"","source_url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"},"sources":[{"archive_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","label":"src/backend/commands/explain.c:1480","line":1480,"path":"src/backend/commands/explain.c","sha256":"34c86d6070224a0e981efef51f79101d6d505e5874f1684ace183034bab14bb4","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"},{"archive_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","label":"src/backend/executor/execProcnode.c:279","line":279,"path":"src/backend/executor/execProcnode.c","sha256":"f8a06a3f539077249b20664b2812433db6d7bd12b2c0ca633525db43d06f112a","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"},{"archive_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","label":"src/backend/executor/nodeWorktablescan.c","path":"src/backend/executor/nodeWorktablescan.c","sha256":"912d71e785d7f013d5889e3389deff289a01e35fa2c3aafa2345939fbb988834","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"},{"archive_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","label":"src/include/nodes/plannodes.h","path":"src/include/nodes/plannodes.h","sha256":"52422b327a8049fbbb20d8b96008a0fc0a6fafa60f7eff3c695d5b2e83830120","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"}]},"MeasuredEvidence":{"runtime_verified":false}},"Text":{"Collection":"plan","Key":"worktable-scan","SourceDatabase":"center","Version":"18","Locale":"en","Title":"WorkTable Scan","Summary":"Reads the current working table of a recursive union.","BodyHTML":"\u003cp\u003eReads the current working table of a recursive union.\u003c/p\u003e","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","ContentHash":"e04d1581372c96c9d3556f50de7cce0b195d2400f22e208c149b2d6b1f2cf734","Payload":{"description":["Reads the current working table of a recursive union."],"related":[{"label":"EXPLAIN","url":"/wiki/sql/explain/?v=18"},{"label":"Using EXPLAIN","url":"/docs/18/using-explain.html"},{"label":"Parallel plans","url":"/docs/18/parallel-plans.html"}],"sections":[{"paragraphs":["Structured formats use the Node Type above. Text-format spellings can also include operation, strategy, join type, scan direction or aggregation-stage attributes.","Text names recorded by this source: WorkTable Scan.","Parallel-aware and parallel-safe are different plan properties. A node running inside a parallel worker is not necessarily a parallel-aware node."],"title":"EXPLAIN names and attributes"},{"paragraphs":["This extraction does not assign a universal memory limit or spill policy to this node. Inspect the same-build implementation and its expressions or provider."],"title":"Memory and temporary storage"},{"paragraphs":["The source callbacks below can coordinate execution or collect worker instrumentation. Their presence is not a blanket claim that this node supports a shared parallel scan or shared state.","Callbacks in this build: none extracted from this node implementation."],"title":"Parallel execution and instrumentation"},{"paragraphs":["Note: we intentionally do not support backward scan. Although it would take only a couple more lines here, it would force nodeRecursiveunion.c to create the tuplestore with backward scan enabled, which has a performance cost. In practice backward scan is never useful for a worktable plan node, since it cannot appear high enough in the plan tree of a scrollable cursor to be exposed to a backward-scan requirement. So it's not worth expending effort to support it.","Note: we are also assuming that this node is the only reader of the worktable. Therefore, we don't need a private read pointer for the tuplestore, nor do we need to tell tuplestore_gettupleslot to copy.","Get the next tuple from tuplestore. Return NULL if no more tuples.","WorkTableScanRecheck -- access method routine to recheck a tuple in EvalPlanQual","Scans the worktable sequentially and returns the next qualifying tuple. We call the ExecScan() routine and pass it the appropriate access method functions."],"title":"Executor implementation notes"},{"code":"case T_WorkTableScan:\n\t\t\tpname = sname = \"WorkTable Scan\";\n\t\t\tbreak;","title":"EXPLAIN identity in core source"}],"tables":[{"columns":[{"key":"label","label":"Text-format label"},{"key":"identity","label":"Structured node identity"}],"key":"explain-labels","rows":[{"identity":"WorkTable Scan","label":"WorkTable Scan"}],"title":"EXPLAIN labels in this source build"}]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}