JSON to tabular format via JSONformatter.org and JSON2table.com
Posted by jpluimers on 2020/11/10
Two interesting sites to ease transforming JSON fragments in log-messages to a table system, for instance Excel.
- Paste the bits in [WayBack] Best JSON Pretty Print Online then fix any syntax errors.
- Copy from there to [WayBack] json2table.com and press the triangle button (run)
- Copy either the tabular or tree result to your favourite program.
- Format any numbers for readability. I really like the
Customformat##0.00E+00that just shows the exponents in multiples of 3 (so kilo, mega, giga, etc)[WayBack] formatting – How can I format bytes a cell in Excel as KB, MB, GB etc? – Stack Overflow
This way I copied the example code into adjecent Excel areas, so I could compare the values and calculate memory increase of a Delphi application.
—jeroen
| { | |
| "MMSummary": | |
| {"allocatedBytes":93170132,"overheadBytes":407169068,"efficiencyPercentage":18.6213936465502}, | |
| "MMState": | |
| {"largeBlockSizeUsageBytes":82105584,"logicalSmallBlockSizeUsageBytes":421510160,"mediumBlockSizeUsageBytes":754302480,"pysicalSmallBlockSizeUsageBytes":69364160,"reservedSmallBlockSizeUsageBytes":472539008,"reservedMemoryUsageBytes":500339200,"totalBlockSizeUsageBytes":93170132}, | |
| "WindowsState": | |
| {"processorCount":6,"allocationGranularity":65536,"availablePhysicalMemory":10068516864,"totalPhysicalMemory":17176760320,"availableVirtualMemory":103985152,"totalVirtualMemory":2147352576,"totalVirtualExtendedMemory":0,"haveTotalVirtualExtendedMemory":true,"maximumIncrement":156250,"pageSize":4096,"numberOfPhysicalPages":4193545,"lowestPhysicalPage":1,"highestPhysicalPage":4227071,"haveMaximumIncrement":true,"havePageSize":true,"haveNumberOfPhysicalPages":true,"haveLowestPhysicalPage":true,"haveHighestPhysicalPage":true,"pageFaultCount":400503,"peakWorkingSetSize":824729600,"workingSetSize":809132032,"quotaPeakPagedPoolUsage":2711680,"quotaPagedPoolUsage":2694200,"quotaPeakNonPagedPoolUsage":814288,"quotaNonPagedPoolUsage":238048,"pagefileUsage":1001943040,"peakPagefileUsage":1009856512,"havePageFaultCount":true,"havePeakWorkingSetSize":true,"haveWorkingSetSize":true,"haveQuotaPeakPagedPoolUsage":true,"haveQuotaPagedPoolUsage":true,"haveQuotaPeakNonPagedPoolUsage":true,"haveQuotaNonPagedPoolUsage":true,"havePagefileUsage":true,"havePeakPagefileUsage":true,"currentProcessId":12784,"minimumAddress":65536,"maximumVMAddress":2147418111,"pageProtectionAndCommitSize":4096,"minimumQuota":204800,"maximumQuota":1413120} | |
| } |
| { | |
| "MMSummary": | |
| {"allocatedBytes":102667512,"overheadBytes":407763976,"efficiencyPercentage":20.1138672698813}, | |
| "MMState": | |
| {"largeBlockSizeUsageBytes":146430020,"logicalSmallBlockSizeUsageBytes":424802160,"mediumBlockSizeUsageBytes":797062032,"pysicalSmallBlockSizeUsageBytes":69975260,"reservedSmallBlockSizeUsageBytes":472574384,"reservedMemoryUsageBytes":510431488,"totalBlockSizeUsageBytes":102667512}, | |
| "WindowsState": | |
| {"processorCount":6,"allocationGranularity":65536,"availablePhysicalMemory":10040336384,"totalPhysicalMemory":17176760320,"availableVirtualMemory":93360128,"totalVirtualMemory":2147352576,"totalVirtualExtendedMemory":0,"haveTotalVirtualExtendedMemory":true,"maximumIncrement":156250,"pageSize":4096,"numberOfPhysicalPages":4193545,"lowestPhysicalPage":1,"highestPhysicalPage":4227071,"haveMaximumIncrement":true,"havePageSize":true,"haveNumberOfPhysicalPages":true,"haveLowestPhysicalPage":true,"haveHighestPhysicalPage":true,"pageFaultCount":402912,"peakWorkingSetSize":824729600,"workingSetSize":818823168,"quotaPeakPagedPoolUsage":2711680,"quotaPagedPoolUsage":2694200,"quotaPeakNonPagedPoolUsage":814288,"quotaNonPagedPoolUsage":238560,"pagefileUsage":1012244480,"peakPagefileUsage":1012244480,"havePageFaultCount":true,"havePeakWorkingSetSize":true,"haveWorkingSetSize":true,"haveQuotaPeakPagedPoolUsage":true,"haveQuotaPagedPoolUsage":true,"haveQuotaPeakNonPagedPoolUsage":true,"haveQuotaNonPagedPoolUsage":true,"havePagefileUsage":true,"havePeakPagefileUsage":true,"currentProcessId":12784,"minimumAddress":65536,"maximumVMAddress":2147418111,"pageProtectionAndCommitSize":4096,"minimumQuota":204800,"maximumQuota":1413120} | |
| } |
Leave a Reply