{"Entry":{"collection":"plan","key":"sample-scan","name":"Sample Scan","aliases":["Sample Scan","SampleScan","T_SampleScan"],"metadata":{"aliases":["Sample Scan","SampleScan","T_SampleScan"],"category":"Scan","content_hash":"1f2cc990f86661ef61c2f70c4b4d45148043e6918f83da47483d7d15554716cd","imported_at":"2026-09-30T00:40:44.242061+08:00","name":"Sample Scan","name_zh":"SampleScan","slug":"sample-scan","summary":"Reads a relation using the selected table-sampling method."}},"Definition":{"Collection":"plan","Key":"sample-scan","SourceDatabase":"center","Version":"18","SourceTable":"plan_node","SourceKey":"sample-scan","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","Facts":{"comparison_data":{"initializer":"ExecInitSampleScan","memory_mechanism":"unclassified","node_tag":"T_SampleScan","parallel_callbacks":[],"partial_modes":[],"strategies":[],"text_names":["Sample Scan"]},"comparison_hash":"353ba2b42b3d419de2b0fd5f49ddf5d460404fbad27fe1fded7536333a1bedeb","description":["Reads a relation using the selected table-sampling method."],"evidence_kind":"source and documentation","explain_names":["Sample Scan"],"explain_prefixes":["Parallel","Async"],"facts":[{"label":"Core node tag","value":"T_SampleScan"},{"label":"Structured EXPLAIN Node Type","value":"Sample Scan"},{"label":"Inputs","value":"A relation and sampling method"},{"label":"Output","value":"Sampled tuples"},{"label":"Executor initializer","value":"ExecInitSampleScan"},{"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/nodeSamplescan.c","path":"src/backend/executor/nodeSamplescan.c","sha256":"59ddce276a131990661664393bf645d62693a722f382bd040f6b1c2584e7b2a5","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"}],"mechanism":"unclassified","source_notes":[]},"node_tag":"T_SampleScan","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: Sample 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":["nodeSamplescan.c Support routines for sample scans of relations (table sampling).","SampleRecheck -- access method routine to recheck a tuple in EvalPlanQual","No need to recheck for SampleScan, since like SeqScan we don't pass any checkable keys to heap_beginscan.","Scans the relation using the sampling method and returns the next qualifying tuple. We call the ExecScan() routine and pass it the appropriate access method functions.","If we don't have a REPEATABLE clause, select a random seed. We want to do this just once, since the seed shouldn't change over rescans."],"title":"Executor implementation notes"},{"code":"case T_SampleScan:\n\t\t\tpname = sname = \"Sample 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/nodeSamplescan.c"},"sources":[{"archive_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","label":"src/backend/commands/explain.c:1435","line":1435,"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:214","line":214,"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/nodeSamplescan.c","path":"src/backend/executor/nodeSamplescan.c","sha256":"59ddce276a131990661664393bf645d62693a722f382bd040f6b1c2584e7b2a5","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":"Sample Scan","label":"Sample 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:1435","line":1435,"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:214","line":214,"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/nodeSamplescan.c","path":"src/backend/executor/nodeSamplescan.c","sha256":"59ddce276a131990661664393bf645d62693a722f382bd040f6b1c2584e7b2a5","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":"sample-scan","SourceDatabase":"center","Version":"18","Locale":"en","Title":"Sample Scan","Summary":"Reads a relation using the selected table-sampling method.","BodyHTML":"\u003cp\u003eReads a relation using the selected table-sampling method.\u003c/p\u003e","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","ContentHash":"e88d868f443c619adfd07553c0edfaf0658f620c29eaa765e6cd1438979f9566","Payload":{"description":["Reads a relation using the selected table-sampling method."],"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: Sample 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":["nodeSamplescan.c Support routines for sample scans of relations (table sampling).","SampleRecheck -- access method routine to recheck a tuple in EvalPlanQual","No need to recheck for SampleScan, since like SeqScan we don't pass any checkable keys to heap_beginscan.","Scans the relation using the sampling method and returns the next qualifying tuple. We call the ExecScan() routine and pass it the appropriate access method functions.","If we don't have a REPEATABLE clause, select a random seed. We want to do this just once, since the seed shouldn't change over rescans."],"title":"Executor implementation notes"},{"code":"case T_SampleScan:\n\t\t\tpname = sname = \"Sample 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":"Sample Scan","label":"Sample 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}