Back to Materialize

Operator Table

doc/user/layouts/partials/explain-plans/operator-table.html

123965 B
Original Source

The following table lists the operators that are available in the {{ .planType }} plan.

  • For those operators that require memory to maintain intermediate state, Uses memory is marked with Yes.
  • For those operators that expand the data size (either rows or columns), Can increase data size is marked with Yes.
OperatorDescriptionExample
{{ range .operators }}{{ .operator }}{{ .description

Can increase data size: {{ if .expansive }} {{ .expansive_details | markdownify }}{{ else }}No{{ end }}
Uses memory: {{ if .uses_memory }} ✅ {{ .memory_details | markdownify }} {{ else }}No{{ end }} | {{ .example | markdownify }} | {{ end }}

  • Can increase data size: Specifies whether the operator can increase the data size (can be the number of rows or the number of columns).
  • Uses memory: Specifies whether the operator use memory to maintain state for its inputs.