space_used

400 rows sorted by name

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
2 ./index ./index 0 0 129 125 2 19409 0 0 201 1 5 0 4056 418 0 0 24576
163 ahca-polls/ahca_polls ahca-polls/ahca_polls 0 0 16 15 2 5007 0 0 723 1 2 0 4077 3094 0 0 12288
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
63 alcohol-consumption/drinks alcohol-consumption/drinks 0 0 194 193 2 4689 0 0 46 1 2 0 4076 2649 0 0 12288
58 antiquities-act/actions_under_antiquities_act antiquities-act/actions_under_antiquities_act 0 0 353 344 2 36597 0 0 179 1 10 0 4015 2634 0 1 45056
36 avengers/avengers avengers/avengers 0 0 179 173 2 26720 0 0 389 1 7 0 4041 1083 0 1 32768
249 bachelorette/bachelorette bachelorette/bachelorette 0 0 934 921 2 48629 0 0 74 1 14 0 3981 4125 0 0 61440
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
31 bechdel/movies bechdel/movies 0 0 1835 1794 2 159234 0 0 161 1 42 0 3758 3606 0 0 176128
257 biopics/biopics biopics/biopics 0 0 788 761 2 105907 0 0 187 1 28 0 3872 4242 0 0 118784
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
282 bob-ross/elements-by-episode bob-ross/elements-by-episode 0 0 412 403 2 37497 0 0 105 1 10 0 4015 1495 0 1 45056
390 candy-power-ranking/candy-data candy-power-ranking/candy-data 0 0 86 85 2 4374 0 0 66 1 2 0 4077 3462 0 0 12288
297 chess-transfers/transfers chess-transfers/transfers 0 0 949 932 2 67301 0 0 74 1 18 0 3950 1750 0 0 77824
34 classic-rock/classic-rock-song-list classic-rock/classic-rock-song-list 0 0 2271 2229 2 159241 0 0 172 1 43 0 3750 5506 0 0 180224
245 college-majors/all-ages college-majors/all-ages 0 0 176 173 2 14307 0 0 139 1 4 0 4062 1305 0 0 20480
248 college-majors/grad-students college-majors/grad-students 0 0 179 173 2 23834 0 0 192 1 7 0 4040 3916 0 1 32768
244 college-majors/majors-list college-majors/majors-list 0 0 176 174 2 8702 0 0 109 1 3 0 4069 2819 0 0 16384
247 college-majors/recent-grads college-majors/recent-grads 0 0 178 173 2 19974 0 0 171 1 6 0 4047 3785 0 0 28672
246 college-majors/women-stem college-majors/women-stem 0 0 77 76 2 5365 0 0 106 1 2 0 4077 2507 0 0 12288
278 comic-characters/dc-wikia-data comic-characters/dc-wikia-data 0 0 7171 6896 2 1062706 0 0 214 1 276 0 1889 24885 0 0 1134592
277 comic-characters/marvel-wikia-data comic-characters/marvel-wikia-data 0 0 16981 16376 3 2337711 0 0 248 3 606 0 7417 44875 0 0 2494464
269 comma-survey/comma-survey comma-survey/comma-survey 0 0 1197 1129 2 267154 0 0 302 1 69 0 3547 8303 0 1 286720
391 congress-age/congress-terms congress-age/congress-terms 0 0 19011 18635 2 1429932 0 0 93 1 377 0 1034 15944 0 0 1548288
178 congress-resignations/congressional_resignations congress-resignations/congressional_resignations 0 0 629 615 2 57030 0 0 155 1 15 0 3975 1318 0 0 65536
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
12 daily-show-guests/daily_show_guests daily-show-guests/daily_show_guests 0 0 2726 2693 2 123777 0 0 110 1 34 0 3821 1877 0 0 143360
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
33 drug-use-by-age/drug-use-by-age drug-use-by-age/drug-use-by-age 0 0 17 17 1 2611 0 0 173 0 1 0 0 1393 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
385 elo-blatter/elo_blatter elo-blatter/elo_blatter 0 0 212 209 2 12683 0 0 268 1 4 0 4061 2747 0 0 20480
62 endorsements-june-30/endorsements-june-30 endorsements-june-30/endorsements-june-30 0 0 110 109 2 6307 0 0 72 1 2 0 4077 1433 0 0 12288
393 fandango/fandango_score_comparison fandango/fandango_score_comparison 0 0 151 146 2 21874 0 0 207 1 6 0 4048 1915 0 0 28672
392 fandango/fandango_scrape fandango/fandango_scrape 0 0 515 510 2 19762 0 0 86 1 6 0 4045 2343 0 0 28672
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
298 flying-etiquette-survey/flying-etiquette flying-etiquette-survey/flying-etiquette 0 0 1157 1040 2 442484 0 0 566 1 118 0 3160 33971 0 1 487424
283 food-world-cup/food-world-cup-data food-world-cup/food-world-cup-data 0 0 1421 1373 2 188442 0 0 190 1 49 0 3704 4040 0 1 204800
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
389 goose/goose_rawdata goose/goose_rawdata 0 0 31488 30962 3 1966780 0 0 77 3 527 0 7794 18334 0 0 2170880
272 hate-crimes/hate_crimes hate-crimes/hate_crimes 0 0 52 51 2 5250 0 0 110 1 2 0 4077 2722 0 0 12288
4 hip-hop-candidate-lyrics/genius_hip_hop_lyrics hip-hop-candidate-lyrics/genius_hip_hop_lyrics 0 0 393 377 2 62941 0 0 264 1 17 0 3961 4434 0 0 73728
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
32 inconvenient-sequel/ratings inconvenient-sequel/ratings 0 0 84237 80053 3 16022565 0 0 235 11 4185 0 8107 542512 0 0 17186816
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
296 librarians/librarians-by-msa librarians/librarians-by-msa 0 0 377 373 2 16605 0 0 96 1 5 0 4053 2097 0 0 24576
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
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
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
280 mad-men/show-data mad-men/show-data 0 0 256 248 2 33825 0 0 553 1 9 0 4025 1752 0 0 40960
191 march-madness-predictions/bracket-00 march-madness-predictions/bracket-00 0 0 69 68 2 6188 0 0 111 1 2 0 4077 1716 0 0 12288
190 march-madness-predictions/bracket-01 march-madness-predictions/bracket-01 0 0 69 68 2 6188 0 0 111 1 2 0 4077 1716 0 0 12288
194 march-madness-predictions/bracket-02 march-madness-predictions/bracket-02 0 0 69 68 2 6310 0 0 114 1 2 0 4077 1594 0 0 12288
197 march-madness-predictions/bracket-03 march-madness-predictions/bracket-03 0 0 69 68 2 6233 0 0 108 1 2 0 4077 1671 0 0 12288
203 march-madness-predictions/bracket-04 march-madness-predictions/bracket-04 0 0 69 68 2 6167 0 0 106 1 2 0 4077 1737 0 0 12288
206 march-madness-predictions/bracket-05 march-madness-predictions/bracket-05 0 0 69 68 2 6090 0 0 106 1 2 0 4077 1814 0 0 12288
201 march-madness-predictions/bracket-06 march-madness-predictions/bracket-06 0 0 69 68 2 7255 0 0 124 1 2 0 4077 649 0 0 12288
198 march-madness-predictions/bracket-07 march-madness-predictions/bracket-07 0 0 69 68 2 7190 0 0 124 1 2 0 4077 714 0 0 12288
208 march-madness-predictions/bracket-08 march-madness-predictions/bracket-08 0 0 69 68 2 7125 0 0 124 1 2 0 4077 779 0 0 12288
213 march-madness-predictions/bracket-09 march-madness-predictions/bracket-09 0 0 69 68 2 7055 0 0 124 1 2 0 4077 849 0 1 12288
202 march-madness-predictions/bracket-10 march-madness-predictions/bracket-10 0 0 69 68 2 6993 0 0 124 1 2 0 4077 911 0 0 12288
207 march-madness-predictions/bracket-11 march-madness-predictions/bracket-11 0 0 69 68 2 6923 0 0 124 1 2 0 4077 981 0 0 12288
200 march-madness-predictions/bracket-12 march-madness-predictions/bracket-12 0 0 69 68 2 6867 0 0 124 1 2 0 4077 1037 0 0 12288
199 march-madness-predictions/bracket-13 march-madness-predictions/bracket-13 0 0 69 68 2 6798 0 0 124 1 2 0 4077 1106 0 0 12288
192 march-madness-predictions/bracket-14 march-madness-predictions/bracket-14 0 0 69 68 2 6737 0 0 124 1 2 0 4077 1167 0 0 12288
189 march-madness-predictions/bracket-15 march-madness-predictions/bracket-15 0 0 69 68 2 6670 0 0 124 1 2 0 4077 1234 0 0 12288
195 march-madness-predictions/bracket-16 march-madness-predictions/bracket-16 0 0 69 68 2 6672 0 0 123 1 2 0 4077 1232 0 1 12288
196 march-madness-predictions/bracket-17 march-madness-predictions/bracket-17 0 0 69 68 2 6604 0 0 123 1 2 0 4077 1300 0 0 12288
225 march-madness-predictions/bracket-18 march-madness-predictions/bracket-18 0 0 69 68 2 6538 0 0 123 1 2 0 4077 1366 0 0 12288
224 march-madness-predictions/bracket-19 march-madness-predictions/bracket-19 0 0 69 68 2 6479 0 0 123 1 2 0 4077 1425 0 0 12288
210 march-madness-predictions/bracket-20 march-madness-predictions/bracket-20 0 0 69 68 2 6345 0 0 122 1 2 0 4077 1559 0 0 12288
211 march-madness-predictions/bracket-21 march-madness-predictions/bracket-21 0 0 69 68 2 6280 0 0 122 1 2 0 4077 1624 0 0 12288
217 march-madness-predictions/bracket-22 march-madness-predictions/bracket-22 0 0 69 68 2 4988 0 0 104 1 2 0 4077 2916 0 0 12288
214 march-madness-predictions/bracket-23 march-madness-predictions/bracket-23 0 0 69 68 2 4925 0 0 104 1 2 0 4077 2979 0 0 12288
226 march-madness-predictions/bracket-24 march-madness-predictions/bracket-24 0 0 69 68 2 4860 0 0 104 1 2 0 4077 3044 0 0 12288
223 march-madness-predictions/bracket-25 march-madness-predictions/bracket-25 0 0 69 68 2 4797 0 0 104 1 2 0 4077 3107 0 0 12288
218 march-madness-predictions/bracket-26 march-madness-predictions/bracket-26 0 0 69 68 2 4665 0 0 104 1 2 0 4077 3239 0 0 12288
221 march-madness-predictions/bracket-27 march-madness-predictions/bracket-27 0 0 69 68 2 4032 0 0 92 1 2 0 4077 3872 0 0 12288
193 march-madness-predictions/bracket-28 march-madness-predictions/bracket-28 0 0 69 68 2 3976 0 0 92 1 2 0 4077 3928 0 0 12288
188 march-madness-predictions/bracket-29 march-madness-predictions/bracket-29 0 0 69 68 2 3920 0 0 92 1 2 0 4077 3984 0 0 12288
227 march-madness-predictions/bracket-30 march-madness-predictions/bracket-30 0 0 68 68 1 3808 0 0 92 0 1 0 0 8 0 0 4096
222 march-madness-predictions/bracket-31 march-madness-predictions/bracket-31 0 0 69 68 2 4277 0 0 104 1 2 0 4077 3627 0 1 12288
219 march-madness-predictions/bracket-32 march-madness-predictions/bracket-32 0 0 69 68 2 4084 0 0 92 1 2 0 4077 3820 0 0 12288
220 march-madness-predictions/bracket-33 march-madness-predictions/bracket-33 0 0 69 68 2 4018 0 0 92 1 2 0 4077 3886 0 0 12288
209 march-madness-predictions/bracket-34 march-madness-predictions/bracket-34 0 0 69 68 2 3957 0 0 92 1 2 0 4077 3947 0 0 12288
212 march-madness-predictions/bracket-35 march-madness-predictions/bracket-35 0 0 69 68 2 3904 0 0 92 1 2 0 4077 4000 0 0 12288
216 march-madness-predictions/bracket-36 march-madness-predictions/bracket-36 0 0 69 68 2 3848 0 0 92 1 2 0 4077 4056 0 0 12288
215 march-madness-predictions/bracket-37 march-madness-predictions/bracket-37 0 0 68 68 1 3789 0 0 92 0 1 0 0 27 0 0 4096
204 march-madness-predictions/bracket-38 march-madness-predictions/bracket-38 0 0 68 68 1 3674 0 0 92 0 1 0 0 142 0 0 4096
205 march-madness-predictions/bracket-39 march-madness-predictions/bracket-39 0 0 68 68 1 3620 0 0 92 0 1 0 0 196 0 0 4096
232 march-madness-predictions/bracket-40 march-madness-predictions/bracket-40 0 0 68 68 1 3558 0 0 92 0 1 0 0 258 0 0 4096
235 march-madness-predictions/bracket-41 march-madness-predictions/bracket-41 0 0 69 68 2 4729 0 0 110 1 2 0 4077 3175 0 0 12288
230 march-madness-predictions/bracket-42 march-madness-predictions/bracket-42 0 0 68 68 1 3448 0 0 92 0 1 0 0 368 0 0 4096
229 march-madness-predictions/bracket-43 march-madness-predictions/bracket-43 0 0 68 68 1 3391 0 0 92 0 1 0 0 425 0 0 4096
239 march-madness-predictions/bracket-44 march-madness-predictions/bracket-44 0 0 69 68 2 4558 0 0 105 1 2 0 4077 3346 0 0 12288
236 march-madness-predictions/bracket-45 march-madness-predictions/bracket-45 0 0 68 68 1 3278 0 0 87 0 1 0 0 538 0 0 4096
241 march-madness-predictions/bracket-46 march-madness-predictions/bracket-46 0 0 69 68 2 4512 0 0 100 1 2 0 4077 3392 0 0 12288
242 march-madness-predictions/bracket-47 march-madness-predictions/bracket-47 0 0 69 68 2 4453 0 0 99 1 2 0 4077 3451 0 0 12288
185 march-madness-predictions/bracket-48 march-madness-predictions/bracket-48 0 0 69 68 2 4398 0 0 98 1 2 0 4077 3506 0 0 12288
182 march-madness-predictions/bracket-49 march-madness-predictions/bracket-49 0 0 68 68 1 3007 0 0 79 0 1 0 0 809 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 71.972ms