You can monitor a Tanzu Greenplum Text cluster via Tanzu Greenplum Command Center, using a plugin installed with Tanzu Greenplum Database. When the plugin is installed, you can view Greenplum Text monitoring information via the "Plugins" menu item in Greenplum Command Center. Selecting this menu item displays the status of Greenplum Text clusters, nodes, and indexes in real time.
In order to activate the plugin, you must:
Log into the
psql -d gpperfmon
gptext_gpcc extension in Greenplum Database:
create extension gptext_gpcc
Restart Greenplum Command Center
After the extension is installed, you can click the Plugins menu item in Greenplum Command Center. This will display Greenplum Text pages.
Click the entries pages to see the overall Greenplum Text cluster status.
Click the the nodes/indexes tags, you can see metrics for nodes or indexes.
gptext_gpcc.json configuration file -- located in
$GPHOME/share/postgresql/extension -- is not preserved after upgrading Greenplum Database. After upgrading to a new Greenplum Database version, you must copy
$GPHOME/share/postgresql/extension in the upgraded Greenplum Database.
You may interact with the plugin and control various aspects of its behavior by running the
gptext-gpcc-plugin command, as summarized below.
gptext-gpcc-plugin command is located in
$GPHOME/lib/python/gptext_gpcclib/bin; we recommend that you add this to your
$PATH environment variable.
gptext-gpcc-plugin <action> [options]
plugin-enable - Creates the extension in Greenplum Database.
plugin-disable - Drops the extension and removes all history metrics. You may choose to deactivate the plugin if you have no need to monitor Greenplum Text or if the plugin is causing performance issues or other issues.
config-show - Displays the plugin configuration file contents, including retention metrics data and sampling interval data.
config-edit - Updates the plugin configuration file contents, including retention metrics data and sampling interval data.
metrics-truncate - Truncates the metrics table the extension created. This deletes all of the history metrics data in the database, but keeps all settings; following this, the plugin will pull new metrics in from time to time.
-h, --help - Displays online help.
-v, --verbose - Provides extensive output for debugging.
--metrics_retention=<number of days> - Updates the number of days metrics data should be retained; the default is 30 days. Used only with the
--sampling_interval=<number of seconds> - Updates the sampling interval for loading metrics from Solr; the default is 60 seconds. Used only with the
Update the number of days metrics data should be retained to 45 days:
gptext-gpcc-plugin config-edit --metrics_retention=45
Update the sampling interval to 30 seconds:
gptext-gpcc-plugin config-edit --sampling_interval=30