Nested Loop
Rescans the inner plan for outer rows and evaluates the join qualifications.
当前阅读 PG 18·选择有来源记录的版本
此版本暂无所选语言的定义，以下显示原始英文内容。
- Core node tag
- T_NestLoop
- Structured EXPLAIN Node Type
- Nested Loop
- Inputs
- Outer and inner child plans
- Output
- Joined tuples according to the selected join type
- Executor initializer
- ExecInitNestLoop
- Memory mechanism
- unclassified
- evidence kind
- source and documentation
- explain names
- Nested Loop
- explain prefixes
- Parallel, Async
- node tag
- T_NestLoop
- parallel callbacks
- 未知
- partial modes
- 未知
- runtime verified
- false
- strategies
- 未知
版本定义 PG 18
Rescans the inner plan for outer rows and evaluates the join qualifications.
EXPLAIN labels in this source build
| Text-format label | Structured node identity |
|---|---|
| Nested Loop | Nested Loop |
比较版本
完整来源事实
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/nodeNestloop.c","path":"src/backend/executor/nodeNestloop.c","sha256":"2d8fbc2a3a31ce10400f0524107d2d083721071b6a384f5d635c11d1d2aeb49c","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"}],"mechanism":"unclassified","source_notes":[]}source inventory
{"executor":"src/backend/executor/execProcnode.c","explain":"src/backend/commands/explain.c","implementation":"src/backend/executor/nodeNestloop.c"}来源引用
- src/backend/commands/explain.c:1421
- src/backend/executor/execProcnode.c:297
- src/backend/executor/nodeNestloop.c
- src/include/nodes/plannodes.h
- PostgreSQL 18.6 · parallel-plans
- PostgreSQL 18.6 · using-explain
定义来源
center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
正文语言: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f