space_used

400 rows sorted by mx_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
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
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
267 rare-pepes/blocks_timestamps rare-pepes/blocks_timestamps 0 0 78567 78265 2 782650 0 0 10 1 303 0 1426 2934 0 0 1245184
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
394 births/US_births_1994-2003_CDC_NCHS births/US_births_1994-2003_CDC_NCHS 0 0 3667 3652 2 46524 0 0 13 1 16 0 3964 751 0 0 69632
395 births/US_births_2000-2014_SSA births/US_births_2000-2014_SSA 0 0 5502 5479 2 69799 0 0 13 1 24 0 3900 1045 0 0 102400
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
264 rare-pepes/xcp_prices rare-pepes/xcp_prices 0 0 522 520 2 7723 0 0 15 1 3 0 4068 2068 0 0 16384
265 rare-pepes/pepecash_prices rare-pepes/pepecash_prices 0 0 493 491 2 7365 0 0 15 1 3 0 4068 2571 0 0 16384
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
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
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
69 most-common-name/new-top-surnames most-common-name/new-top-surnames 0 0 100 100 1 1892 0 0 23 0 1 0 0 1796 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
66 most-common-name/new-top-firstNames most-common-name/new-top-firstNames 0 0 100 100 1 1912 0 0 24 0 1 0 0 1776 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
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
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
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
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
172 nba-tattoos/nba-tattoos-data nba-tattoos/nba-tattoos-data 0 0 639 636 2 11674 0 0 30 1 4 0 4060 1625 0 0 20480
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
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
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
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
8 terrorism/country_stats_1993_appendix2 terrorism/country_stats_1993_appendix2 0 0 129 129 1 3037 0 0 35 0 1 0 0 533 0 0 4096
175 tennis-time/players_time tennis-time/players_time 0 0 219 218 2 5426 0 0 35 1 2 0 4076 1787 0 0 12288
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
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
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
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
294 murder_2016/murder_2015_final murder_2016/murder_2015_final 0 0 83 83 1 2153 0 0 44 0 1 0 0 1603 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
266 rare-pepes/ordermatches_all rare-pepes/ordermatches_all 0 0 26257 26038 2 755904 0 0 45 1 220 0 2249 3738 0 0 905216
63 alcohol-consumption/drinks alcohol-consumption/drinks 0 0 194 193 2 4689 0 0 46 1 2 0 4076 2649 0 0 12288
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
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
174 tennis-time/events_time tennis-time/events_time 0 0 206 205 2 7128 0 0 46 1 2 0 4077 150 0 0 12288
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
295 tarantino/tarantino tarantino/tarantino 0 0 1913 1894 2 68937 0 0 47 1 20 0 3933 3480 0 0 86016
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
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
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
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
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
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
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
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
37 presidential-campaign-trail/trump presidential-campaign-trail/trump 0 0 107 106 2 4589 0 0 51 1 2 0 4077 3163 0 0 12288
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
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
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
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
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
183 march-madness-predictions/bracket-61 march-madness-predictions/bracket-61 0 0 68 68 1 2486 0 0 51 0 1 0 0 1330 0 0 4096
184 march-madness-predictions/bracket-60 march-madness-predictions/bracket-60 0 0 68 68 1 2486 0 0 51 0 1 0 0 1330 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
268 sandy-311-calls/sandy-311-calls-by-day sandy-311-calls/sandy-311-calls-by-day 0 0 1800 1783 2 62440 0 0 53 1 18 0 3949 2356 0 0 77824
29 unisex-names/unisex_names_table unisex-names/unisex_names_table 0 0 930 919 2 42716 0 0 54 1 12 0 3997 1872 0 0 53248
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
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
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
287 fifa/fifa_countries_audience fifa/fifa_countries_audience 0 0 192 191 2 6167 0 0 55 1 2 0 4077 1181 0 0 12288
286 pulitzer/pulitzer-circulation-data pulitzer/pulitzer-circulation-data 0 0 50 50 1 2299 0 0 56 0 1 0 0 1589 0 0 4096
5 bad-drivers/bad-drivers bad-drivers/bad-drivers 0 0 51 51 1 2322 0 0 57 0 1 0 0 1562 0 0 4096
26 forecast-methodology/historical-senate-predictions forecast-methodology/historical-senate-predictions 0 0 208 207 2 6361 0 0 59 1 2 0 4077 907 0 0 12288
48 us-weather-history/KPHL us-weather-history/KPHL 0 0 370 365 2 19155 0 0 59 1 6 0 4045 3675 0 0 28672
49 us-weather-history/KNYC us-weather-history/KNYC 0 0 370 365 2 19212 0 0 59 1 6 0 4045 3618 0 0 28672
50 us-weather-history/KPHX us-weather-history/KPHX 0 0 369 365 2 18106 0 0 59 1 5 0 4053 636 0 1 24576
51 us-weather-history/KCQT us-weather-history/KCQT 0 0 369 365 2 17578 0 0 59 1 5 0 4053 1164 0 0 24576
52 us-weather-history/KHOU us-weather-history/KHOU 0 0 370 365 2 19264 0 0 59 1 6 0 4045 3566 0 0 28672
53 us-weather-history/KMDW us-weather-history/KMDW 0 0 370 365 2 19127 0 0 59 1 6 0 4045 3703 0 0 28672
54 us-weather-history/KJAX us-weather-history/KJAX 0 0 370 365 2 19004 0 0 59 1 6 0 4045 3826 0 0 28672
55 us-weather-history/KIND us-weather-history/KIND 0 0 370 365 2 19313 0 0 59 1 6 0 4045 3517 0 0 28672
56 us-weather-history/KSEA us-weather-history/KSEA 0 0 370 365 2 19280 0 0 59 1 6 0 4045 3550 0 0 28672
57 us-weather-history/KCLT us-weather-history/KCLT 0 0 370 365 2 19076 0 0 59 1 6 0 4045 3754 0 0 28672
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
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
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
187 march-madness-predictions/bracket-59 march-madness-predictions/bracket-59 0 0 68 68 1 2519 0 0 59 0 1 0 0 1297 0 0 4096
38 presidential-campaign-trail/clinton presidential-campaign-trail/clinton 0 0 71 71 1 3557 0 0 60 0 1 0 0 247 0 0 4096
259 love-actually/love_actually_appearances love-actually/love_actually_appearances 0 0 1008 1003 2 17669 0 0 60 1 6 0 4045 1971 0 0 28672
173 tennis-time/serve_times tennis-time/serve_times 0 0 121 120 2 6386 0 0 61 1 2 0 4077 1310 0 1 12288
281 mad-men/performer-scores mad-men/performer-scores 0 0 245 243 2 9499 0 0 61 1 3 0 4069 1677 0 0 16384
288 historical-ncaa-forecasts/historical-538-ncaa-tournament-model-results historical-ncaa-forecasts/historical-538-ncaa-tournament-model-results 0 0 255 253 2 9577 0 0 61 1 3 0 4069 1549 0 0 16384
18 puerto-rico-media/tv_hurricanes_by_network puerto-rico-media/tv_hurricanes_by_network 0 0 85 84 2 4629 0 0 62 1 2 0 4077 3211 0 0 12288
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
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
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
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
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
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

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 69.486ms