What is gpmt?
gpmt is a Greenplum Database utility designed to help users manage and monitor their Greenplum Database systems more effectively. It provides a range of features for maintenance, troubleshooting, and optimization of Greenplum clusters.
Why is it important?
Efficient management and monitoring are vital for ensuring the high performance and reliability of a Greenplum Database. gpmt assists in various aspects such as health checks, query performance analysis, and system configuration, making it a valuable tool for Greenplum administrators.
How to use gpmt:
Using gpmt involves running specific commands and options depending on your requirements. Here's an example of how to utilize gpmt:
gpmt <command> [options]
gpmt -d <dbname>
{ -s <schema> |
{ -t <schema>.<table>
[ -i <col1>[, <col2>, ...] |
-x <col1>[, <col2>, ...] ] } |
{ -f | --file} <config-file> }
[ -l | --list ]
[ --gen_profile_only ]
[ -p <parallel-level> ]
[ --full ]
[ --skip_root_stats ]
[ -v | --verbose ]
[ --debug ]
[ -a ]
gpmt { --clean_last | --clean_all }
gpmt --version
gpmt { -? | -h | --help }