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
Custom
format##0.00E+00
that 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
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"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} | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"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