space_used

400 rows sorted by payload

View and edit SQL

Suggested facets: depth, ovfl_payload, ovfl_cnt, int_pages, ovfl_pages, ovfl_unused, gap_cnt

Link rowid name tblname is_index is_without_rowid nentry leaf_entries depth payload ▼ ovfl_payload ovfl_cnt mx_payload int_pages leaf_pages ovfl_pages int_unused leaf_unused ovfl_unused gap_cnt compressed_size
23 scrabble-games/scrabble_games scrabble-games/scrabble_games 0 0 2 2 1 94 0 0 78 0 1 0 0 3986 0 0 4096
30 science-giving/science_federal_giving science-giving/science_federal_giving 0 0 2 2 1 94 0 0 78 0 1 0 0 3986 0 0 4096
7 terrorism/eu_terrorism_fatalities_by_year terrorism/eu_terrorism_fatalities_by_year 0 0 29 29 1 180 0 0 7 0 1 0 0 3792 0 0 4096
9 terrorism/france_terrorism_fatalities_by_year terrorism/france_terrorism_fatalities_by_year 0 0 43 43 1 242 0 0 6 0 1 0 0 3674 0 0 4096
24 nfl-wide-receivers/try-per-game-aging-curve nfl-wide-receivers/try-per-game-aging-curve 0 0 24 24 1 336 0 0 14 0 1 0 0 3656 0 0 4096
28 unisex-names/aging_curve unisex-names/aging_curve 0 0 12 12 1 356 0 0 32 0 1 0 0 3684 0 0 4096
68 most-common-name/aging-curve most-common-name/aging-curve 0 0 12 12 1 356 0 0 32 0 1 0 0 3684 0 0 4096
258 love-actually/love_actually_adjacencies love-actually/love_actually_adjacencies 0 0 14 14 1 445 0 0 36 0 1 0 0 3587 0 0 4096
19 puerto-rico-media/mediacloud_hurricanes puerto-rico-media/mediacloud_hurricanes 0 0 38 38 1 621 0 0 20 0 1 0 0 3315 0 0 4096
253 trump-world-trust/TRUMPWORLD-issue-1 trump-world-trust/TRUMPWORLD-issue-1 0 0 37 37 1 632 0 0 24 0 1 0 0 3308 0 0 4096
254 trump-world-trust/TRUMPWORLD-issue-2 trump-world-trust/TRUMPWORLD-issue-2 0 0 37 37 1 632 0 0 24 0 1 0 0 3308 0 0 4096
255 trump-world-trust/TRUMPWORLD-issue-3 trump-world-trust/TRUMPWORLD-issue-3 0 0 37 37 1 634 0 0 24 0 1 0 0 3306 0 0 4096
251 trump-world-trust/TRUMPWORLD-issue-4 trump-world-trust/TRUMPWORLD-issue-4 0 0 37 37 1 635 0 0 24 0 1 0 0 3305 0 0 4096
252 trump-world-trust/TRUMPWORLD-issue-5 trump-world-trust/TRUMPWORLD-issue-5 0 0 37 37 1 635 0 0 24 0 1 0 0 3305 0 0 4096
20 puerto-rico-media/google_trends puerto-rico-media/google_trends 0 0 37 37 1 654 0 0 19 0 1 0 0 3286 0 0 4096
284 infrastructure-jobs/payroll-states infrastructure-jobs/payroll-states 0 0 53 53 1 678 0 0 24 0 1 0 0 3198 0 0 4096
17 puerto-rico-media/mediacloud_states puerto-rico-media/mediacloud_states 0 0 51 51 1 889 0 0 18 0 1 0 0 2995 0 0 4096
10 terrorism/eu_terrorism_fatalities_by_country terrorism/eu_terrorism_fatalities_by_country 0 0 45 45 1 916 0 0 24 0 1 0 0 2992 0 0 4096
180 nfl-ticket-prices/jets-buyer nfl-ticket-prices/jets-buyer 0 0 62 62 1 919 0 0 34 0 1 0 0 2921 0 0 4096
179 nfl-ticket-prices/national-average nfl-ticket-prices/national-average 0 0 32 32 1 922 0 0 33 0 1 0 0 3038 0 0 4096
256 trump-world-trust/TRUMPWORLD-pres trump-world-trust/TRUMPWORLD-pres 0 0 15 15 1 1037 0 0 87 0 1 0 0 2991 0 0 4096
383 early-senate-polls/early-senate-polls early-senate-polls/early-senate-polls 0 0 107 107 1 1064 0 0 10 0 1 0 0 2596 0 0 4096
15 puerto-rico-media/tv_hurricanes puerto-rico-media/tv_hurricanes 0 0 37 37 1 1152 0 0 45 0 1 0 0 2788 0 0 4096
16 puerto-rico-media/mediacloud_trump puerto-rico-media/mediacloud_trump 0 0 51 51 1 1154 0 0 26 0 1 0 0 2730 0 0 4096
81 womens-world-cup-predictions/wwc-forecast-20150705-205539 womens-world-cup-predictions/wwc-forecast-20150705-205539 0 0 24 24 1 1164 0 0 52 0 1 0 0 2828 0 0 4096
250 trump-world-trust/TRUMPWORLD-us trump-world-trust/TRUMPWORLD-us 0 0 17 17 1 1174 0 0 87 0 1 0 0 2846 0 0 4096
155 womens-world-cup-predictions/wwc-forecast-20150701-205548 womens-world-cup-predictions/wwc-forecast-20150701-205548 0 0 24 24 1 1180 0 0 54 0 1 0 0 2812 0 0 4096
107 womens-world-cup-predictions/wwc-forecast-20150630-210243 womens-world-cup-predictions/wwc-forecast-20150630-210243 0 0 24 24 1 1204 0 0 64 0 1 0 0 2788 0 0 4096
75 womens-world-cup-predictions/wwc-forecast-20150627-213532 womens-world-cup-predictions/wwc-forecast-20150627-213532 0 0 24 24 1 1228 0 0 64 0 1 0 0 2764 0 0 4096
61 cousin-marriage/cousin-marriage-data cousin-marriage/cousin-marriage-data 0 0 70 70 1 1257 0 0 26 0 1 0 0 2551 0 0 4096
84 womens-world-cup-predictions/wwc-forecast-20150627-180119 womens-world-cup-predictions/wwc-forecast-20150627-180119 0 0 24 24 1 1260 0 0 72 0 1 0 0 2732 0 0 4096
122 womens-world-cup-predictions/wwc-matches-20150617-175941 womens-world-cup-predictions/wwc-matches-20150617-175941 0 0 36 36 1 1272 0 0 59 0 1 0 0 2672 0 0 4096
111 womens-world-cup-predictions/wwc-forecast-20150626-212544 womens-world-cup-predictions/wwc-forecast-20150626-212544 0 0 24 24 1 1292 0 0 74 0 1 0 0 2700 0 0 4096
93 womens-world-cup-predictions/wwc-matches-20150616-220036 womens-world-cup-predictions/wwc-matches-20150616-220036 0 0 36 36 1 1320 0 0 59 0 1 0 0 2624 0 0 4096
135 womens-world-cup-predictions/wwc-forecast-20150626-184421 womens-world-cup-predictions/wwc-forecast-20150626-184421 0 0 24 24 1 1324 0 0 74 0 1 0 0 2668 0 0 4096
160 womens-world-cup-predictions/wwc-forecast-20150623-235546 womens-world-cup-predictions/wwc-forecast-20150623-235546 0 0 24 24 1 1356 0 0 74 0 1 0 0 2636 0 0 4096
87 womens-world-cup-predictions/wwc-matches-20150616-190139 womens-world-cup-predictions/wwc-matches-20150616-190139 0 0 36 36 1 1368 0 0 59 0 1 0 0 2576 0 0 4096
120 womens-world-cup-predictions/wwc-forecast-20150622-215702 womens-world-cup-predictions/wwc-forecast-20150622-215702 0 0 24 24 1 1396 0 0 84 0 1 0 0 2596 0 0 4096
106 womens-world-cup-predictions/wwc-matches-20150615-213540 womens-world-cup-predictions/wwc-matches-20150615-213540 0 0 36 36 1 1416 0 0 62 0 1 0 0 2528 0 0 4096
132 womens-world-cup-predictions/wwc-forecast-20150622-185345 womens-world-cup-predictions/wwc-forecast-20150622-185345 0 0 24 24 1 1436 0 0 84 0 1 0 0 2556 0 0 4096
72 most-common-name/state-pop most-common-name/state-pop 0 0 51 51 1 1457 0 0 37 0 1 0 0 2427 0 0 4096
80 womens-world-cup-predictions/wwc-matches-20150615-175745 womens-world-cup-predictions/wwc-matches-20150615-175745 0 0 36 36 1 1464 0 0 62 0 1 0 0 2480 0 0 4096
146 womens-world-cup-predictions/wwc-forecast-20150621-213134 womens-world-cup-predictions/wwc-forecast-20150621-213134 0 0 24 24 1 1476 0 0 84 0 1 0 0 2516 0 0 4096
128 womens-world-cup-predictions/wwc-matches-20150613-205441 womens-world-cup-predictions/wwc-matches-20150613-205441 0 0 36 36 1 1512 0 0 62 0 1 0 0 2432 0 0 4096
108 womens-world-cup-predictions/wwc-forecast-20150621-175918 womens-world-cup-predictions/wwc-forecast-20150621-175918 0 0 24 24 1 1516 0 0 84 0 1 0 0 2476 0 0 4096
147 womens-world-cup-predictions/wwc-matches-20150613-175552 womens-world-cup-predictions/wwc-matches-20150613-175552 0 0 36 36 1 1536 0 0 64 0 1 0 0 2408 0 0 4096
144 womens-world-cup-predictions/wwc-forecast-20150621-145724 womens-world-cup-predictions/wwc-forecast-20150621-145724 0 0 24 24 1 1556 0 0 84 0 1 0 0 2436 0 0 4096
161 womens-world-cup-predictions/wwc-matches-20150621-145724 womens-world-cup-predictions/wwc-matches-20150621-145724 0 0 44 44 1 1563 0 0 51 0 1 0 0 2349 0 0 4096
314 world-cup-predictions/wc-20140711-102258 world-cup-predictions/wc-20140711-102258 0 0 32 32 1 1565 0 0 63 0 1 0 0 2395 0 0 4096
317 world-cup-predictions/wc-20140713-113900 world-cup-predictions/wc-20140713-113900 0 0 32 32 1 1565 0 0 63 0 1 0 0 2395 0 0 4096
356 world-cup-predictions/wc-20140710-164509 world-cup-predictions/wc-20140710-164509 0 0 32 32 1 1565 0 0 63 0 1 0 0 2395 0 0 4096
360 world-cup-predictions/wc-20140709-231617 world-cup-predictions/wc-20140709-231617 0 0 32 32 1 1572 0 0 63 0 1 0 0 2388 0 0 4096
397 next-bechdel/nextBechdel_allTests next-bechdel/nextBechdel_allTests 0 0 50 50 1 1577 0 0 63 0 1 0 0 2311 0 0 4096
159 womens-world-cup-predictions/wwc-matches-20150621-213134 womens-world-cup-predictions/wwc-matches-20150621-213134 0 0 45 45 1 1578 0 0 50 0 1 0 0 2330 0 0 4096
119 womens-world-cup-predictions/wwc-matches-20150620-213513 womens-world-cup-predictions/wwc-matches-20150620-213513 0 0 44 44 1 1579 0 0 51 0 1 0 0 2333 0 0 4096
102 womens-world-cup-predictions/wwc-matches-20150613-145639 womens-world-cup-predictions/wwc-matches-20150613-145639 0 0 36 36 1 1584 0 0 64 0 1 0 0 2360 0 0 4096
339 world-cup-predictions/wc-20140708-215459 world-cup-predictions/wc-20140708-215459 0 0 32 32 1 1589 0 0 68 0 1 0 0 2371 0 0 4096
97 womens-world-cup-predictions/wwc-matches-20150621-175918 womens-world-cup-predictions/wwc-matches-20150621-175918 0 0 45 45 1 1594 0 0 51 0 1 0 0 2314 0 0 4096
292 democratic-bench/democratic-bench democratic-bench/democratic-bench 0 0 67 67 1 1594 0 0 30 0 1 0 0 2226 0 0 4096
153 womens-world-cup-predictions/wwc-matches-20150620-180614 womens-world-cup-predictions/wwc-matches-20150620-180614 0 0 44 44 1 1595 0 0 51 0 1 0 0 2317 0 0 4096
140 womens-world-cup-predictions/wwc-forecast-20150620-213513 womens-world-cup-predictions/wwc-forecast-20150620-213513 0 0 24 24 1 1596 0 0 84 0 1 0 0 2396 0 0 4096
357 world-cup-predictions/wc-20140709-095047 world-cup-predictions/wc-20140709-095047 0 0 32 32 1 1596 0 0 68 0 1 0 0 2364 0 0 4096
291 nfl-favorite-team/team-picking-categories nfl-favorite-team/team-picking-categories 0 0 32 32 1 1599 0 0 54 0 1 0 0 2361 0 0 4096
91 womens-world-cup-predictions/wwc-matches-20150612-235650 womens-world-cup-predictions/wwc-matches-20150612-235650 0 0 36 36 1 1608 0 0 64 0 1 0 0 2336 0 0 4096
127 womens-world-cup-predictions/wwc-matches-20150622-185345 womens-world-cup-predictions/wwc-matches-20150622-185345 0 0 46 46 1 1609 0 0 50 0 1 0 0 2295 0 0 4096
90 womens-world-cup-predictions/wwc-matches-20150617-210614 womens-world-cup-predictions/wwc-matches-20150617-210614 0 0 44 44 1 1611 0 0 51 0 1 0 0 2301 0 0 4096
318 world-cup-predictions/wc-20140708-092538 world-cup-predictions/wc-20140708-092538 0 0 32 32 1 1613 0 0 68 0 1 0 0 2347 0 0 4096
350 world-cup-predictions/wc-20140707-100337 world-cup-predictions/wc-20140707-100337 0 0 32 32 1 1613 0 0 68 0 1 0 0 2347 0 0 4096
352 world-cup-predictions/wc-20140706-091537 world-cup-predictions/wc-20140706-091537 0 0 32 32 1 1613 0 0 68 0 1 0 0 2347 0 0 4096
371 world-cup-predictions/wc-20140705-225331 world-cup-predictions/wc-20140705-225331 0 0 32 32 1 1620 0 0 68 0 1 0 0 2340 0 0 4096
85 womens-world-cup-predictions/wwc-matches-20150612-215533 womens-world-cup-predictions/wwc-matches-20150612-215533 0 0 36 36 1 1632 0 0 64 0 1 0 0 2312 0 0 4096
139 womens-world-cup-predictions/wwc-matches-20150622-215702 womens-world-cup-predictions/wwc-matches-20150622-215702 0 0 47 47 1 1635 0 0 50 0 1 0 0 2265 0 0 4096
152 womens-world-cup-predictions/wwc-forecast-20150620-180614 womens-world-cup-predictions/wwc-forecast-20150620-180614 0 0 24 24 1 1636 0 0 84 0 1 0 0 2356 0 0 4096
123 womens-world-cup-predictions/wwc-matches-20150626-184421 womens-world-cup-predictions/wwc-matches-20150626-184421 0 0 48 48 1 1651 0 0 48 0 1 0 0 2245 0 0 4096
74 womens-world-cup-predictions/wwc-matches-20150612-205525 womens-world-cup-predictions/wwc-matches-20150612-205525 0 0 36 36 1 1656 0 0 64 0 1 0 0 2288 0 0 4096
79 womens-world-cup-predictions/wwc-matches-20150627-180119 womens-world-cup-predictions/wwc-matches-20150627-180119 0 0 49 49 1 1663 0 0 47 0 1 0 0 2229 0 0 4096
271 airline-safety/airline-safety airline-safety/airline-safety 0 0 56 56 1 1666 0 0 48 0 1 0 0 2198 0 0 4096
145 womens-world-cup-predictions/wwc-matches-20150623-235546 womens-world-cup-predictions/wwc-matches-20150623-235546 0 0 48 48 1 1667 0 0 48 0 1 0 0 2229 0 0 4096
115 womens-world-cup-predictions/wwc-forecast-20150617-210614 womens-world-cup-predictions/wwc-forecast-20150617-210614 0 0 24 24 1 1676 0 0 84 0 1 0 0 2316 0 0 4096
98 womens-world-cup-predictions/wwc-matches-20150630-210243 womens-world-cup-predictions/wwc-matches-20150630-210243 0 0 50 50 1 1677 0 0 46 0 1 0 0 2211 0 0 4096
94 womens-world-cup-predictions/wwc-matches-20150626-212544 womens-world-cup-predictions/wwc-matches-20150626-212544 0 0 49 49 1 1679 0 0 48 0 1 0 0 2213 0 0 4096
95 womens-world-cup-predictions/wwc-matches-20150612-185329 womens-world-cup-predictions/wwc-matches-20150612-185329 0 0 36 36 1 1680 0 0 64 0 1 0 0 2264 0 0 4096
325 world-cup-predictions/wc-20140705-093245 world-cup-predictions/wc-20140705-093245 0 0 32 32 1 1684 0 0 76 0 1 0 0 2276 0 0 4096
329 world-cup-predictions/wc-20140704-220110 world-cup-predictions/wc-20140704-220110 0 0 32 32 1 1684 0 0 76 0 1 0 0 2276 0 0 4096
88 womens-world-cup-predictions/wwc-matches-20150627-213532 womens-world-cup-predictions/wwc-matches-20150627-213532 0 0 50 50 1 1693 0 0 46 0 1 0 0 2195 0 0 4096
118 womens-world-cup-predictions/wwc-matches-20150611-232844 womens-world-cup-predictions/wwc-matches-20150611-232844 0 0 36 36 1 1704 0 0 64 0 1 0 0 2240 0 0 4096
372 world-cup-predictions/wc-20140704-180211 world-cup-predictions/wc-20140704-180211 0 0 32 32 1 1716 0 0 76 0 1 0 0 2244 0 0 4096
82 womens-world-cup-predictions/wwc-matches-20150705-205539 womens-world-cup-predictions/wwc-matches-20150705-205539 0 0 52 52 1 1719 0 0 41 0 1 0 0 2161 0 0 4096
133 womens-world-cup-predictions/wwc-matches-20150611-210229 womens-world-cup-predictions/wwc-matches-20150611-210229 0 0 36 36 1 1728 0 0 64 0 1 0 0 2216 0 0 4096
316 world-cup-predictions/wc-20140701-224103 world-cup-predictions/wc-20140701-224103 0 0 32 32 1 1748 0 0 76 0 1 0 0 2212 0 0 4096
333 world-cup-predictions/wc-20140703-094053 world-cup-predictions/wc-20140703-094053 0 0 32 32 1 1748 0 0 76 0 1 0 0 2212 0 0 4096
378 world-cup-predictions/wc-20140702-094046 world-cup-predictions/wc-20140702-094046 0 0 32 32 1 1748 0 0 76 0 1 0 0 2212 0 0 4096
13 puerto-rico-media/mediacloud_top_online_news puerto-rico-media/mediacloud_top_online_news 0 0 49 49 1 1750 0 0 55 0 1 0 0 2142 0 0 4096
150 womens-world-cup-predictions/wwc-matches-20150701-205548 womens-world-cup-predictions/wwc-matches-20150701-205548 0 0 52 52 1 1751 0 0 48 0 1 0 0 2129 0 0 4096
156 womens-world-cup-predictions/wwc-matches-20150611-200059 womens-world-cup-predictions/wwc-matches-20150611-200059 0 0 36 36 1 1752 0 0 64 0 1 0 0 2192 0 0 4096
112 womens-world-cup-predictions/wwc-matches-20150611-182114 womens-world-cup-predictions/wwc-matches-20150611-182114 0 0 36 36 1 1776 0 0 64 0 1 0 0 2168 0 0 4096
320 world-cup-predictions/wc-20140701-184332 world-cup-predictions/wc-20140701-184332 0 0 32 32 1 1788 0 0 80 0 1 0 0 2172 0 0 4096
105 womens-world-cup-predictions/wwc-matches-20150609-205725 womens-world-cup-predictions/wwc-matches-20150609-205725 0 0 36 36 1 1800 0 0 64 0 1 0 0 2144 0 0 4096
14 puerto-rico-media/tv_states puerto-rico-media/tv_states 0 0 52 52 1 1824 0 0 37 0 1 0 0 2056 0 0 4096
142 womens-world-cup-predictions/wwc-matches-20150609-175933 womens-world-cup-predictions/wwc-matches-20150609-175933 0 0 36 36 1 1824 0 0 64 0 1 0 0 2120 0 0 4096

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE space_used(
   name clob,        -- Name of a table or index in the database file
   tblname clob,     -- Name of associated table
   is_index boolean, -- TRUE if it is an index, false for a table
   is_without_rowid boolean, -- TRUE if WITHOUT ROWID table  
   nentry int,       -- Number of entries in the BTree
   leaf_entries int, -- Number of leaf entries
   depth int,        -- Depth of the b-tree
   payload int,      -- Total amount of data stored in this table or index
   ovfl_payload int, -- Total amount of data stored on overflow pages
   ovfl_cnt int,     -- Number of entries that use overflow
   mx_payload int,   -- Maximum payload size
   int_pages int,    -- Number of interior pages used
   leaf_pages int,   -- Number of leaf pages used
   ovfl_pages int,   -- Number of overflow pages used
   int_unused int,   -- Number of unused bytes on interior pages
   leaf_unused int,  -- Number of unused bytes on primary pages
   ovfl_unused int,  -- Number of unused bytes on overflow pages
   gap_cnt int,      -- Number of gaps in the page layout
   compressed_size int  -- Total bytes stored on disk
);
Powered by Datasette · Query took 66.067ms