Statistics Available for Monitoring
Two Pivotal GemFire® regions are populated with statistics about import and export operations that are currently in progress.
GemFire Regions with Statistics
The GGC_OPERATIONS_MONITOR
region is a replicated region that
contains one entry for each operation.
An entry is added when an import or export is initiated,
and the entry is removed when the import or export completes.
The key identifies the operation; it is a Java UUID.
The value is comprised of
the UID of the user that invokes the import or export command
either “import” or “export”, to distinguish the operation
the GemFire region name that is the source or destination of the operation
the GPDB table name that is the source or destination of the operation
the start time of the operation, the
long
that results from a call toSystem.currentTimeMillis()
The GGC_STATISTICS_MONITOR
region is a partitioned region that
contains statistics entries for each import or export operation.
Each server maintains the statistics for itself.
An entry is added when an import or export is initiated,
and the entry is removed when the import or export completes.
A composite key contains an operation ID, the server name, and
a thread ID.
The value is comprised of
the number of GPDB rows or GemFire entries processed
the number of bytes processed
These values within an entry are updated on a per-server basis after each 10,000 rows/entries are processed.
Acquiring the Statistics
The gfsh list gpdb operations
command aggregates the number of rows
and the number of bytes processed across all servers and then
outputs a table with one row for each import or export operation.
Each row contains all fields from the GGC_OPERATIONS_MONITOR
region
and the aggregate values calculated from the partitioned
GGC_STATISTICS_MONITOR
region.
See the command reference page
for details on the use of the gfsh list gpdb operations
command.