gpmemreport
Interprets the output created by the gpmemwatcher utility and generates output files in a readable format.
Synopsis
gpmemreport <gzip_file>
[ -s <start> | --start=<start> ]
[ -e <end> | --end=<end> ]
gpmemreport --version
gpmemreport -h | --helpDescription
The gpmemreport utility helps interpret the output file created by the gpmemwatcher utility.
When running gpmemreport against the .gz files generated by gpmemwatcher, it generates a series of files, where each file corresponds to a 60-second period of data collected by gpmemwatcher converted into a readable format.
Options
- -s | --start <start_time>
-
Indicate the start of the reporting period. Timestamp format must be
'%Y-%m-%d %H:%M:%S'. - -e | --end <end_time>
-
Indicate the end of the reporting period. Timestamp format must be
'%Y-%m-%d %H:%M:%S'. - --version
-
Display the version of this utility.
- -h | --help
-
Display help.
Examples
Example 1
Extract all the files generated by gpmemwatcher for the Greengage DB master.
Locate the output .gz file from gpmemwatcher and run gpmemreport against it:
$ gpmemreport mdw.ps.out.gzThe result:
>>>21:11:19:15:37:18<<< >>>21:11:19:15:38:18<<< >>>21:11:19:15:39:18<<<
Check that the generated files are listed under the current directory:
$ ls -thrlThe result:
-rw-rw-r--. 1 gpadmin gpadmin 1.2K Nov 19 15:50 20211119-153718 -rw-rw-r--. 1 gpadmin gpadmin 1.2K Nov 19 15:50 20211119-153818 -rw-rw-r--. 1 gpadmin gpadmin 1.2K Nov 19 15:50 20211119-153918
Example 2
Extract the files generated by gpmemwatcher for the Greengage DB master starting after a certain timestamp.
Locate the output .gz file from gpmemwatcher and run gpmemreport against it, indicating the start time as 2021-11-19 15:38:00:
$ gpmemreport mdw.ps.out.gz --start='2021-11-19 15:38:00'The result:
>>>21:11:19:15:37:18<<< >>>21:11:19:15:38:18<<< >>>21:11:19:15:39:18<<<
Check under the current directory that only the selected timestamp files are listed:
$ ls -thrlThe result:
-rw-rw-r--. 1 gpadmin gpadmin 1.2K Nov 19 15:50 20211119-153818 -rw-rw-r--. 1 gpadmin gpadmin 1.2K Nov 19 15:50 20211119-153918