posted Apr 28, 2017, 10:08 AM by Sachchida Ojha
The gpperfmon database iterators_* tables store information about query plan iterators and their metrics. A query iterator refers to a node or operation in a query plan. Here are the list of all possible iterators in a query on Greenplum Database instance. The iterator tables include the metric name, the column in the iterators_* table in the gpperfmon database where the metric appears, how the metric is measured (unit), and a description of the metric. The following iterators are listed:
- Append
- Append-only Scan
- Append-only Columnar Scan
- Aggregate
- BitmapAnd
- BitmapOr
- Bitmap Append-Only Scan
- Bitmap Heap Scan
- Bitmap Index Scan
- Broadcast Motion
- Explicit Redistribute Motion
- External Scan
- Function Scan
- Gather Motion
- GroupAggregate
- Hash Join
- HashAggregate
- Index Scan
- Limit
- Materialize
- Merge Join
- Nested Loop
- Redistribute Motion
- Result
- Repeat
- Seq Scan
- SetOp
- Shared Scan
- Sort
- Subquery Scan
- Tid Scan
- Unique
- Values Scan
- Window
|
|
