JSON Digger reads files from disk without loading them, so it sets no size limit on a file you open. These limits apply to data it has to decompress, download, or hold in memory:
| Limit |
Value |
Decompressed size of a .gz or .zst file |
16 GiB |
| Text pasted from the clipboard |
256 MiB |
| Response fetched from a URL |
256 MiB |
| Request body of a fetch |
1 MiB |
| Data a jq or JSONPath query, an Analyze view pipeline, or schema validation loads into memory |
512 MiB |
| Messages kept by a live stream |
5,000 by default, from 100 to 100,000 |
| Length of a live stream message shown in the list |
64 KiB. A longer message is cut short. |
| Limit |
Value |
| Entries in Recent files |
10 |
| Time allowed for a fetch |
30 seconds by default, set in the dialog |
| Limit |
Value |
| Size of a file you can edit |
2 GiB. A notice appears for files over 300 MiB. |
| Value in the inline editor |
64 KiB |
| Node in the subtree editor, inserted value |
10 MiB |
| Array to sort |
250,000 elements and 10 MiB |
| Part of a document a JSON Patch rewrites, patch file |
10 MiB |
| Undo |
The last edit |
| Free disk space needed for an edit |
The size of the edited file, plus 20%. Until you save, up to three copies of the file sit next to it. |
| Limit |
Value |
| Children of one object or array shown in the tree |
4,096. Search, queries, and the Table view cover all of them. |
| Records of an NDJSON file shown in the tree |
4,096. Later records open in the NDJSON view. |
| Expanding a node with all its descendants |
50,000 objects and arrays, or 12 levels |
| Nodes kept by the search bar’s Filter |
400,000 |
Expanding a node with o in jdig |
500 objects and arrays, or 5 levels |
See Very large objects and arrays.
| Limit |
Value |
| One value or subtree copied to the clipboard |
50 MiB |
| A node converted with Copy As |
10 MiB |
| Copy Selected Values |
1,000 nodes and 50 MiB |
| Limit |
Value |
| Matches listed by one search |
100,000, also in jdig |
| Results of a filter or JSONPath query, and values output by a jq query |
100,000. jq gives no notice when its output stops there. |
| Highlighters on at once |
8 |
| Saved highlighters |
64 |
| Searches and queries kept in history |
50 each |
Results of a query in jdig, and with jdig -q |
1,000 |
| Limit |
Value |
| Rows per page in the Table view |
100 |
| Rows read by a Table view filter, sort, or CSV export |
100,000 |
| Rows read by value frequency and group by |
100,000, or 1,000,000 with Scan more |
| Values listed by value frequency |
50 |
| Groups listed by group by |
10,000 |
| Columns to group by |
3 |
| Each side of a comparison |
50 MiB |
| Results of an Analyze view pipeline |
500 |
| Groups in a bar chart, slices in a pie chart |
20 groups, 10 slices; the rest are combined |
| Depth of the Graph view |
1 to 8 levels, 4 by default |
| Lines shown in the NDJSON and Text views |
64 KiB per line. A longer line is cut short. |
| Limit |
Value |
| Objects read by Anomalies |
The first 10,000 |
| Lint warnings listed |
500. The counts include all. |
| Part of a file lint checks on open |
256 MiB by default; set it in Preferences |
| Violations listed by schema validation |
100 |
| Keys listed by Key frequency |
100 |
| Keys listed under Top Keys in Statistics |
20 |
| Pins per file |
50 |
| Bookmarks per file |
50 |
| Files that keep pins or bookmarks |
200. The oldest file’s are removed first. |
Some views read a sample of a large array instead of every element:
| View |
Sample |
| Table view columns and their summaries |
The first 50 rows |
| Chart view |
5,000 rows spread evenly over the array; columns from the first 50 rows |
| Graph view |
64 elements per array, at most 2,000 shapes in all, 8 levels |
| Statistics on an NDJSON file |
5,000 records spread evenly over the file |
| A schema inferred from an array |
The first 50 elements |
| Types from Export Types for an array |
The first 500 elements |
These limits apply to SQL queries:
| Limit |
Value |
| Rows shown in the result grid |
10,000. Export every row writes all rows. |
| Size of the rows shown in the grid |
32 MiB |
| Size of one cell in the grid |
4 KiB. A longer value is shortened. |
Rows read to find the columns of doc |
20,480. Every column reads the whole file. |
| Array in a pasted, fetched, or repaired document, or inside an NDJSON record |
256 MiB |
| SQL memory limit |
1,024 MiB by default, from 512 MiB to 80% of installed memory |
| Temporary files written by queries |
10 GiB |
