Read in intermediate stages in an operation, usually a recursive operation declared using WITH RECURSIVE.

WorkTable Scan fields

• Parent Relationship

• Parallel Aware

• CTE Name

• Alias

• Startup Cost

• Total Cost

• Plan Rows

• Plan Width

• Actual Startup Time

• Actual Total Time

• Actual Rows

• Actual Loops

• Output

• Filter

• Rows Removed by Filter

• Shared Hit Blocks

• Shared Read Blocks

• Shared Dirtied Blocks

• Shared Written Blocks

• Local Hit Blocks

• Local Read Blocks

• Local Dirtied Blocks

• Local Written Blocks

• Temp Read Blocks

• Temp Written Blocks

• Shared I/O Read Time

• Shared I/O Write Time

• Local I/O Read Time

• Local I/O Write Time

• Temp I/O Read Time

• Temp I/O Write Time

Related operations

• CTE Scan

Related official docs

• WITH Queries

• WITH Clause

• Source code