The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 2,160 other followers

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.

  1. Paste the bits in [WayBack] Best JSON Pretty Print Online then fix any syntax errors.
  2. Copy from there to [WayBack] json2table.com and press the triangle button (run)
  3. Copy either the tabular or tree result to your favourite program.
  4. 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

{
"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}
}

view raw
memory-states.0.json
hosted with ❤ by GitHub

{
"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}
}

view raw
memory-states.1.json
hosted with ❤ by GitHub

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

 
%d bloggers like this: