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

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now20140424-VMware-Fusion-6.0.3.-no-reclaimable
    More Photos

  • Pages

  • All categories

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

    Join 2,422 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

This entry was posted on 2020/11/10 at 18:00 and is filed under Development, JavaScript/ECMAScript, JSON, LifeHacker, Power User, Scripting, Software Development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

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

Gravatar
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 )

Cancel

Connecting to %s

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

«
»
 
%d bloggers like this: