Digging through the appliance I found a large amount of python and shell scripts that have little to no documentation. So alot of my time has been spent executing them manually and actually checking out syntax and how the scripts were created.
I stumbled upon this directory
In that directory there are several tools that I will touch on in later posts but for right now we are going to check out pgtop.py
If you execute this script you will see something like the following
Based on everything that I have seen within the actual script it looks like it lists all of the underlying threads for the VCDB and what the total amount of IO / status is. This will come in handy when troubleshooting underlying vPostgres issues in the future. There is a severe lack of documentation for this utility but I do like the fact that I can see the total amount of transactions per secondand the total amounts of reads / writes. I am just happy that we have additional insight into the built in database.
According to the script there is a help option when issuing a -h which gives you the following
Usage: pgtop [options]
--version show program's version number and exit
-h, --help show this help message and exit
-I, --idle Do not display idle processes.
-b, --batch All input from the terminal is ignored. Interrupt characters
(such as ^C and ^\) still have an effect.
I don’t believe that this is like standard batch mode like we have seen before with esxtop and vimtop. The idle command is actually kind of nice since it cleans up from what we saw previously to this below
the –batch option apparently just gives you a snapshot instead of having the option to output the stats to. Not sure if this is working as intended but my guess would be that this will change in a later release to align better with vimtop / esxtop.