LATEST VERSION: 3.2.0 - CHANGELOG
Pivotal GemFire®-Greenplum® Connector v3.2

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 to System.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.