VCSA6 Utility: pgtop

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

asdf\

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

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

asdfasdfasdf

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.