Created
July 17, 2026 14:19
-
-
Save pushcx/853a71279451cb8fe52861900951308a to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** Disk-Space Utilization Report For primary.sqlite3 | |
| Page size in bytes................................ 4096 | |
| Pages in the whole file (measured)................ 919448 | |
| Pages in the whole file (calculated).............. 919448 | |
| Pages that store data............................. 919447 100.000% | |
| Pages on the freelist (per header)................ 0 0.0% | |
| Pages on the freelist (calculated)................ 0 0.0% | |
| Pages of auto-vacuum overhead..................... 0 0.0% | |
| Number of tables in the database.................. 52 | |
| Number of indices................................. 124 | |
| Number of defined indices......................... 122 | |
| Number of implied indices......................... 2 | |
| Size of the file in bytes......................... 3766059008 | |
| Bytes of user payload stored...................... 3010997786 80.0% | |
| *** Page counts for all tables with their indices ***************************** | |
| STORY_TEXTS....................................... 298953 32.5% | |
| COMMENTS.......................................... 247435 26.9% | |
| STORY_TEXTS_FTS_DATA.............................. 130432 14.2% | |
| READ_RIBBONS...................................... 48061 5.2% | |
| VOTES............................................. 39055 4.2% | |
| COMMENTS_FTS_DATA................................. 36898 4.0% | |
| NOTIFICATIONS..................................... 29973 3.3% | |
| STORIES........................................... 24612 2.7% | |
| LINKS............................................. 21303 2.3% | |
| SAVED_STORIES..................................... 9520 1.0% | |
| HIDDEN_STORIES.................................... 8529 0.93% | |
| USERS............................................. 5394 0.59% | |
| MESSAGES.......................................... 3489 0.38% | |
| MOD_NOTES......................................... 2371 0.26% | |
| COMMENTS_FTS_DOCSIZE.............................. 2200 0.24% | |
| TAGGINGS.......................................... 2084 0.23% | |
| DOMAINS........................................... 1531 0.17% | |
| MODERATIONS....................................... 1374 0.15% | |
| KEYSTORES......................................... 1067 0.12% | |
| MOD_ACTIVITIES.................................... 993 0.11% | |
| INVITATIONS....................................... 723 0.079% | |
| STORY_TEXTS_FTS_DOCSIZE........................... 491 0.053% | |
| ORIGINS........................................... 431 0.047% | |
| SUGGESTED_TAGGINGS................................ 393 0.043% | |
| STORY_TEXTS_FTS_IDX............................... 357 0.039% | |
| TAG_FILTERS....................................... 354 0.039% | |
| ACTION_MAILBOX_INBOUND_EMAILS..................... 296 0.032% | |
| USERNAMES......................................... 273 0.030% | |
| ACTIVE_STORAGE_BLOBS.............................. 264 0.029% | |
| ACTIVE_STORAGE_ATTACHMENTS........................ 180 0.020% | |
| SUGGESTED_TITLES.................................. 128 0.014% | |
| COMMENTS_FTS_IDX.................................. 70 0.008% | |
| MOD_MAIL_MESSAGES................................. 66 0.007% | |
| COMMENT_STATS..................................... 49 0.005% | |
| HATS.............................................. 18 0.002% | |
| MOD_MAIL_RECIPIENTS............................... 16 0.002% | |
| MASTODON_APPS..................................... 14 0.002% | |
| SQLITE_SCHEMA..................................... 11 0.001% | |
| TAGS.............................................. 10 0.001% | |
| MOD_MAILS......................................... 9 0.0% | |
| CATEGORIES........................................ 3 0.0% | |
| HAT_REQUESTS...................................... 3 0.0% | |
| MOD_MAIL_REFERENCES............................... 3 0.0% | |
| ACTIVE_STORAGE_VARIANT_RECORDS.................... 2 0.0% | |
| AR_INTERNAL_METADATA.............................. 2 0.0% | |
| INVITATION_REQUESTS............................... 2 0.0% | |
| SCHEMA_MIGRATIONS................................. 2 0.0% | |
| COMMENTS_FTS_CONFIG............................... 1 0.0% | |
| SQLITE_SEQUENCE................................... 1 0.0% | |
| STORY_TEXTS_FTS_CONFIG............................ 1 0.0% | |
| *** Page counts for all tables and indices separately ************************* | |
| STORY_TEXTS....................................... 298953 32.5% | |
| COMMENTS.......................................... 222293 24.2% | |
| STORY_TEXTS_FTS_DATA.............................. 130432 14.2% | |
| COMMENTS_FTS_DATA................................. 36898 4.0% | |
| READ_RIBBONS...................................... 33458 3.6% | |
| NOTIFICATIONS..................................... 18469 2.0% | |
| VOTES............................................. 17136 1.9% | |
| STORIES........................................... 14201 1.5% | |
| LINKS............................................. 9615 1.0% | |
| INDEX_READ_RIBBONS_ON_STORY_ID.................... 7485 0.81% | |
| INDEX_COMMENTS_ON_TOKEN........................... 7370 0.80% | |
| INDEX_READ_RIBBONS_ON_USER_ID..................... 7118 0.77% | |
| USER_ID_STORY_ID.................................. 6982 0.76% | |
| INDEX_NOTIFICATIONS_ON_TOKEN...................... 6072 0.66% | |
| USER_ID_COMMENT_ID................................ 5698 0.62% | |
| SAVED_STORIES..................................... 5378 0.58% | |
| VOTES_STORY_ID_FK................................. 5257 0.57% | |
| INDEX_LINKS_ON_URL_AND_FROM_STORY_ID_AND_FROM_COMMENT_ID 4729 0.51% | |
| INDEX_VOTES_ON_COMMENT_ID......................... 3982 0.43% | |
| USERS............................................. 3960 0.43% | |
| HIDDEN_STORIES.................................... 3886 0.42% | |
| INDEX_LINKS_ON_NORMALIZED_URL..................... 3631 0.39% | |
| STORY_ID_SHORT_ID................................. 3230 0.35% | |
| MESSAGES.......................................... 3079 0.33% | |
| INDEX_HIDDEN_STORIES_ON_TOKEN..................... 2965 0.32% | |
| IDX_ON_USER_ID_NOTIFIABLE_TYPE_NOTIFIABLE_ID_FFAC34041E 2915 0.32% | |
| CONFIDENCE_IDX.................................... 2912 0.32% | |
| INDEX_SAVED_STORIES_ON_TOKEN...................... 2621 0.29% | |
| SHORT_ID.......................................... 2595 0.28% | |
| INDEX_NOTIFICATIONS_ON_NOTIFIABLE................. 2517 0.27% | |
| COMMENTS_FTS_DOCSIZE.............................. 2200 0.24% | |
| MOD_NOTES......................................... 2198 0.24% | |
| URL............................................... 2157 0.23% | |
| THREAD_ID......................................... 2048 0.22% | |
| INDEX_COMMENTS_ON_USER_ID......................... 1900 0.21% | |
| COMMENTS_PARENT_COMMENT_ID_FK..................... 1870 0.20% | |
| INDEX_STORIES_ON_NORMALIZED_URL................... 1844 0.20% | |
| INDEX_COMMENTS_ON_SCORE........................... 1678 0.18% | |
| COMMENTS_HAT_ID_FK................................ 1539 0.17% | |
| INDEX_STORIES_ON_TOKEN............................ 1286 0.14% | |
| INDEX_LINKS_ON_TO_STORY_ID_AND_FROM_STORY_ID_AND_FROM_COMMENT_ID 955 0.10% | |
| IDX_LINKS_ON_TO_COMMENT_ID_AND_FROM_STORY_ID_AND_FROM_COMMENT_ID 952 0.10% | |
| INDEX_HIDDEN_STORIES_ON_USER_ID_AND_STORY_ID...... 935 0.10% | |
| DOMAINS........................................... 905 0.098% | |
| INDEX_STORIES_ON_CREATED_AT....................... 872 0.095% | |
| MODERATIONS....................................... 854 0.093% | |
| INDEX_SAVED_STORIES_ON_USER_ID_AND_STORY_ID....... 847 0.092% | |
| TAGGINGS.......................................... 766 0.083% | |
| STORY_ID_TAG_ID................................... 762 0.083% | |
| INDEX_LINKS_ON_FROM_COMMENT_ID.................... 747 0.081% | |
| HIDDEN_STORIES_STORY_ID_FK........................ 743 0.081% | |
| INDEX_LINKS_ON_FROM_STORY_ID...................... 674 0.073% | |
| SAVED_STORIES_STORY_ID_FK......................... 674 0.073% | |
| INDEX_STORIES_ON_LAST_COMMENT_AT.................. 635 0.069% | |
| MOD_ACTIVITIES.................................... 599 0.065% | |
| INDEX_STORIES_ON_MERGED_STORY_ID_AND_HOTNESS...... 560 0.061% | |
| TAGGINGS_TAG_ID_FK................................ 556 0.060% | |
| KEYSTORES......................................... 551 0.060% | |
| HOTNESS_IDX....................................... 529 0.058% | |
| INVITATIONS....................................... 516 0.056% | |
| KEY............................................... 516 0.056% | |
| STORY_TEXTS_FTS_DOCSIZE........................... 491 0.053% | |
| UNIQUE_SHORT_ID................................... 469 0.051% | |
| INDEX_STORIES_ON_ID_AND_IS_DELETED................ 394 0.043% | |
| INDEX_STORIES_ON_MASTODON_ID...................... 379 0.041% | |
| STORY_TEXTS_FTS_IDX............................... 357 0.039% | |
| INDEX_DOMAINS_ON_TOKEN............................ 353 0.038% | |
| SESSION_HASH...................................... 351 0.038% | |
| RSS_TOKEN......................................... 350 0.038% | |
| INDEX_STORIES_ON_USER_ID.......................... 341 0.037% | |
| INDEX_STORIES_ON_DOMAIN_ID........................ 340 0.037% | |
| INDEX_STORIES_ON_SCORE............................ 323 0.035% | |
| INDEX_STORIES_ON_ORIGIN_ID........................ 282 0.031% | |
| INDEX_MOD_ACTIVITIES_ON_TOKEN..................... 276 0.030% | |
| ORIGINS........................................... 252 0.027% | |
| TAG_FILTERS....................................... 252 0.027% | |
| USERNAMES......................................... 219 0.024% | |
| ACTIVE_STORAGE_BLOBS.............................. 208 0.023% | |
| INDEX_MESSAGES_ON_TOKEN........................... 205 0.022% | |
| INDEX_DOMAINS_ON_DOMAIN........................... 203 0.022% | |
| INDEX_USERS_ON_TOKEN.............................. 200 0.022% | |
| ACTION_MAILBOX_INBOUND_EMAILS..................... 186 0.020% | |
| INDEX_MODERATIONS_ON_TOKEN........................ 166 0.018% | |
| SUGGESTED_TAGGINGS................................ 150 0.016% | |
| INDEX_INVITATIONS_ON_TOKEN........................ 143 0.016% | |
| INDEX_USERS_ON_EMAIL.............................. 143 0.016% | |
| INDEX_MOD_ACTIVITIES_ON_ITEM_TYPE_AND_ITEM_ID..... 118 0.013% | |
| INDEX_ACTION_MAILBOX_INBOUND_EMAILS_UNIQUENESS.... 110 0.012% | |
| ACTIVE_STORAGE_ATTACHMENTS........................ 101 0.011% | |
| INDEX_MODERATIONS_ON_CREATED_AT................... 99 0.011% | |
| INDEX_MOD_NOTES_ON_TOKEN.......................... 96 0.010% | |
| SUGGESTED_TITLES.................................. 93 0.010% | |
| MAILING_LIST_TOKEN................................ 91 0.010% | |
| SUGGESTED_TAGGINGS_STORY_ID_FK.................... 87 0.009% | |
| INDEX_ORIGINS_ON_TOKEN............................ 83 0.009% | |
| SUGGESTED_TAGGINGS_USER_ID_FK..................... 81 0.009% | |
| USERNAME.......................................... 79 0.009% | |
| SUGGESTED_TAGGINGS_TAG_ID_FK...................... 75 0.008% | |
| COMMENTS_FTS_IDX.................................. 70 0.008% | |
| INDEX_DOMAINS_ON_BANNED_BY_USER_ID................ 70 0.008% | |
| RANDOM_HASH....................................... 69 0.008% | |
| INDEX_ACTIVE_STORAGE_ATTACHMENTS_UNIQUENESS....... 65 0.007% | |
| MOD_MAIL_MESSAGES................................. 64 0.007% | |
| INDEX_ORIGINS_ON_IDENTIFIER....................... 58 0.006% | |
| USER_TAG_IDX...................................... 58 0.006% | |
| INDEX_ACTIVE_STORAGE_BLOBS_ON_KEY................. 56 0.006% | |
| FK_RAILS_74BBEF8F63............................... 54 0.006% | |
| USERS_INVITED_BY_USER_ID_FK....................... 51 0.006% | |
| MESSAGES_RECIPIENT_USER_ID_FK..................... 49 0.005% | |
| INDEX_MESSAGES_ON_AUTHOR_USER_ID.................. 47 0.005% | |
| PASSWORD_RESET_TOKEN.............................. 45 0.005% | |
| TAG_FILTERS_TAG_ID_FK............................. 44 0.005% | |
| USERS_BANNED_BY_USER_ID_FK........................ 42 0.005% | |
| MAILING_LIST_ENABLED.............................. 41 0.004% | |
| USERS_DISABLED_INVITE_BY_USER_ID_FK............... 41 0.004% | |
| INDEX_MESSAGES_ON_HAT_ID.......................... 40 0.004% | |
| MODERATIONS_STORY_ID_FK........................... 38 0.004% | |
| MODERATIONS_MODERATOR_USER_ID_FK.................. 33 0.004% | |
| INVITATIONS_NEW_USER_ID_FK........................ 32 0.003% | |
| INVITATIONS_USER_ID_FK............................ 32 0.003% | |
| MODERATIONS_COMMENT_ID_FK......................... 32 0.003% | |
| INDEX_MODERATIONS_ON_DOMAIN_ID.................... 31 0.003% | |
| INDEX_MODERATIONS_ON_USER_ID...................... 31 0.003% | |
| INDEX_MOD_NOTES_ON_ID_AND_USER_ID................. 30 0.003% | |
| INDEX_MODERATIONS_ON_CATEGORY_ID.................. 30 0.003% | |
| INDEX_MODERATIONS_ON_ORIGIN_ID.................... 30 0.003% | |
| MODERATIONS_TAG_ID_FK............................. 30 0.003% | |
| COMMENT_STATS..................................... 26 0.003% | |
| MOD_NOTES_USER_ID_FK.............................. 24 0.003% | |
| INDEX_COMMENT_STATS_ON_DATE....................... 23 0.003% | |
| MOD_NOTES_MODERATOR_USER_ID_FK.................... 23 0.003% | |
| INDEX_ORIGINS_ON_DOMAIN_ID........................ 21 0.002% | |
| SUGGESTED_TITLES_STORY_ID_FK...................... 18 0.002% | |
| INDEX_ORIGINS_ON_BANNED_BY_USER_ID................ 17 0.002% | |
| SUGGESTED_TITLES_USER_ID_FK....................... 17 0.002% | |
| INDEX_ACTIVE_STORAGE_ATTACHMENTS_ON_BLOB_ID....... 14 0.002% | |
| HATS.............................................. 12 0.001% | |
| MASTODON_APPS..................................... 11 0.001% | |
| SQLITE_SCHEMA..................................... 11 0.001% | |
| MOD_MAIL_RECIPIENTS............................... 10 0.001% | |
| MOD_MAILS......................................... 8 0.0% | |
| TAGS.............................................. 5 0.0% | |
| INDEX_HATS_ON_TOKEN............................... 4 0.0% | |
| FK_RAILS_7A6D5232BE............................... 3 0.0% | |
| INDEX_MASTODON_APPS_ON_NAME....................... 3 0.0% | |
| INDEX_MOD_MAIL_RECIPIENTS_ON_MOD_MAIL_ID.......... 3 0.0% | |
| INDEX_TAGS_ON_TOKEN............................... 3 0.0% | |
| ACTIVE_STORAGE_VARIANT_RECORDS.................... 1 0.0% | |
| AR_INTERNAL_METADATA.............................. 1 0.0% | |
| CATEGORIES........................................ 1 0.0% | |
| COMMENTS_FTS_CONFIG............................... 1 0.0% | |
| FK_RAILS_40FA20CAB5............................... 1 0.0% | |
| HAT_REQUESTS...................................... 1 0.0% | |
| HAT_REQUESTS_USER_ID_FK........................... 1 0.0% | |
| HATS_GRANTED_BY_USER_ID_FK........................ 1 0.0% | |
| HATS_USER_ID_FK................................... 1 0.0% | |
| INDEX_ACTIVE_STORAGE_VARIANT_RECORDS_UNIQUENESS... 1 0.0% | |
| INDEX_CATEGORIES_ON_CATEGORY...................... 1 0.0% | |
| INDEX_CATEGORIES_ON_TOKEN......................... 1 0.0% | |
| INDEX_HAT_REQUESTS_ON_TOKEN....................... 1 0.0% | |
| INDEX_INVITATION_REQUESTS_ON_TOKEN................ 1 0.0% | |
| INDEX_MOD_MAIL_MESSAGES_ON_MOD_MAIL_ID............ 1 0.0% | |
| INDEX_MOD_MAIL_REFERENCES_ON_MOD_MAIL_ID.......... 1 0.0% | |
| INDEX_MOD_MAIL_REFERENCES_ON_REFERENCE............ 1 0.0% | |
| INDEX_MOD_MAILS_ON_SHORT_ID....................... 1 0.0% | |
| INDEX_TAGS_ON_CATEGORY_ID......................... 1 0.0% | |
| INVITATION_REQUESTS............................... 1 0.0% | |
| MOD_MAIL_REFERENCES............................... 1 0.0% | |
| SCHEMA_MIGRATIONS................................. 1 0.0% | |
| SQLITE_AUTOINDEX_AR_INTERNAL_METADATA_1........... 1 0.0% | |
| SQLITE_AUTOINDEX_SCHEMA_MIGRATIONS_1.............. 1 0.0% | |
| SQLITE_SEQUENCE................................... 1 0.0% | |
| STORY_TEXTS_FTS_CONFIG............................ 1 0.0% | |
| TAG............................................... 1 0.0% | |
| *** All tables and indices **************************************************** | |
| Percentage of total database...................... 100.000% | |
| Number of entries................................. 34216864 | |
| Bytes of storage consumed......................... 3766054912 | |
| Bytes of payload.................................. 3376791216 89.7% | |
| Bytes of metadata................................. 145174538 3.9% | |
| Average payload per entry......................... 98.69 | |
| Average unused bytes per entry.................... 7.15 | |
| Average metadata per entry........................ 4.24 | |
| Average fanout.................................... 259.00 | |
| Maximum payload per entry......................... 1492891 | |
| Entries that use overflow......................... 90062 0.26% | |
| Index pages used.................................. 2576 | |
| Primary pages used................................ 664683 | |
| Overflow pages used............................... 252188 | |
| Total pages used.................................. 919447 | |
| Unused bytes on index pages....................... 1611697 15.3% | |
| Unused bytes on primary pages..................... 238689588 8.8% | |
| Unused bytes on overflow pages.................... 4436377 0.43% | |
| Unused bytes on all pages......................... 244737662 6.5% | |
| *** All tables **************************************************************** | |
| Percentage of total database...................... 88.0% | |
| Number of entries................................. 8044879 | |
| Bytes of storage consumed......................... 3313184768 | |
| Bytes of payload.................................. 3011034146 90.9% | |
| Bytes of metadata................................. 65320852 2.0% | |
| Average payload per entry......................... 374.28 | |
| Average unused bytes per entry.................... 29.52 | |
| Average metadata per entry........................ 8.12 | |
| Average fanout.................................... 351.00 | |
| Maximum payload per entry......................... 1492891 | |
| Entries that use overflow......................... 90062 1.1% | |
| Index pages used.................................. 1585 | |
| Primary pages used................................ 555110 | |
| Overflow pages used............................... 252188 | |
| Total pages used.................................. 808883 | |
| Unused bytes on index pages....................... 956244 14.7% | |
| Unused bytes on primary pages..................... 232085653 10.2% | |
| Unused bytes on overflow pages.................... 4436377 0.43% | |
| Unused bytes on all pages......................... 237478274 7.2% | |
| *** All indices *************************************************************** | |
| Percentage of total database...................... 12.0% | |
| Number of entries................................. 26171985 | |
| Bytes of storage consumed......................... 452870144 | |
| Bytes of payload.................................. 365757070 80.8% | |
| Bytes of metadata................................. 79853686 17.6% | |
| Average payload per entry......................... 13.98 | |
| Average unused bytes per entry.................... 0.28 | |
| Average metadata per entry........................ 3.05 | |
| Average fanout.................................... 111.00 | |
| Maximum payload per entry......................... 262 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 991 | |
| Primary pages used................................ 109573 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 110564 | |
| Unused bytes on index pages....................... 655453 16.1% | |
| Unused bytes on primary pages..................... 6603935 1.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7259388 1.6% | |
| *** Table ACTION_MAILBOX_INBOUND_EMAILS and all its indices ******************* | |
| Percentage of total database...................... 0.032% | |
| Number of entries................................. 10334 | |
| Bytes of storage consumed......................... 1212416 | |
| Bytes of payload.................................. 1128782 93.1% | |
| Bytes of metadata................................. 50652 4.2% | |
| Average payload per entry......................... 109.23 | |
| Average unused bytes per entry.................... 3.19 | |
| Average metadata per entry........................ 4.90 | |
| Average fanout.................................... 59.00 | |
| Maximum payload per entry......................... 167 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 5 | |
| Primary pages used................................ 291 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 296 | |
| Unused bytes on index pages....................... 9590 46.8% | |
| Unused bytes on primary pages..................... 23392 2.0% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 32982 2.7% | |
| *** Table ACTION_MAILBOX_INBOUND_EMAILS w/o any indices *********************** | |
| Percentage of total database...................... 0.020% | |
| Number of entries................................. 5167 | |
| Bytes of storage consumed......................... 761856 | |
| Bytes of payload.................................. 703957 92.4% | |
| Bytes of metadata................................. 33835 4.4% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 136.24 | |
| Average unused bytes per entry.................... 4.66 | |
| Average metadata per entry........................ 6.55 | |
| Average fanout.................................... 185.00 | |
| Non-sequential pages.............................. 3 1.6% | |
| Maximum payload per entry......................... 167 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 185 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 186 | |
| Unused bytes on index pages....................... 2616 63.9% | |
| Unused bytes on primary pages..................... 21448 2.8% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 24064 3.2% | |
| *** Index INDEX_ACTION_MAILBOX_INBOUND_EMAILS_UNIQUENESS of table ACTION_MAILBOX_INBOUND_EMAILS | |
| Percentage of total database...................... 0.012% | |
| Number of entries................................. 5167 | |
| Bytes of storage consumed......................... 450560 | |
| Bytes of payload.................................. 424825 94.3% | |
| Bytes of metadata................................. 16817 3.7% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 82.22 | |
| Average unused bytes per entry.................... 1.73 | |
| Average metadata per entry........................ 3.25 | |
| Average fanout.................................... 27.00 | |
| Non-sequential pages.............................. 2 1.8% | |
| Maximum payload per entry......................... 113 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 4 | |
| Primary pages used................................ 106 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 110 | |
| Unused bytes on index pages....................... 6974 42.6% | |
| Unused bytes on primary pages..................... 1944 0.45% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8918 2.0% | |
| *** Table ACTIVE_STORAGE_ATTACHMENTS and all its indices ********************** | |
| Percentage of total database...................... 0.020% | |
| Number of entries................................. 15501 | |
| Bytes of storage consumed......................... 737280 | |
| Bytes of payload.................................. 660480 89.6% | |
| Bytes of metadata................................. 59252 8.0% | |
| Average payload per entry......................... 42.61 | |
| Average unused bytes per entry.................... 1.13 | |
| Average metadata per entry........................ 3.82 | |
| Average fanout.................................... 59.00 | |
| Maximum payload per entry......................... 73 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 177 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 180 | |
| Unused bytes on index pages....................... 7832 63.7% | |
| Unused bytes on primary pages..................... 9716 1.3% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 17548 2.4% | |
| *** Table ACTIVE_STORAGE_ATTACHMENTS w/o any indices ************************** | |
| Percentage of total database...................... 0.011% | |
| Number of entries................................. 5167 | |
| Bytes of storage consumed......................... 413696 | |
| Bytes of payload.................................. 376935 91.1% | |
| Bytes of metadata................................. 27310 6.6% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 72.95 | |
| Average unused bytes per entry.................... 1.83 | |
| Average metadata per entry........................ 5.29 | |
| Average fanout.................................... 100.00 | |
| Non-sequential pages.............................. 3 3.0% | |
| Maximum payload per entry......................... 73 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 100 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 101 | |
| Unused bytes on index pages....................... 3294 80.4% | |
| Unused bytes on primary pages..................... 6157 1.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 9451 2.3% | |
| *** Indices of table ACTIVE_STORAGE_ATTACHMENTS ******************************* | |
| Percentage of total database...................... 0.009% | |
| Number of entries................................. 10334 | |
| Bytes of storage consumed......................... 323584 | |
| Bytes of payload.................................. 283545 87.6% | |
| Bytes of metadata................................. 31942 9.9% | |
| Average payload per entry......................... 27.44 | |
| Average unused bytes per entry.................... 0.78 | |
| Average metadata per entry........................ 3.09 | |
| Average fanout.................................... 39.00 | |
| Maximum payload per entry......................... 48 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 2 | |
| Primary pages used................................ 77 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 79 | |
| Unused bytes on index pages....................... 4538 55.4% | |
| Unused bytes on primary pages..................... 3559 1.1% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8097 2.5% | |
| *** Index INDEX_ACTIVE_STORAGE_ATTACHMENTS_ON_BLOB_ID of table ACTIVE_STORAGE_ATTACHMENTS | |
| Percentage of total database...................... 0.002% | |
| Number of entries................................. 5167 | |
| Bytes of storage consumed......................... 57344 | |
| Bytes of payload.................................. 35913 62.6% | |
| Bytes of metadata................................. 15665 27.3% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 6.95 | |
| Average unused bytes per entry.................... 1.12 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 14.00 | |
| Non-sequential pages.............................. 1 7.7% | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 13 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 14 | |
| Unused bytes on index pages....................... 3916 95.6% | |
| Unused bytes on primary pages..................... 1850 3.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 5766 10.1% | |
| *** Index INDEX_ACTIVE_STORAGE_ATTACHMENTS_UNIQUENESS of table ACTIVE_STORAGE_ATTACHMENTS | |
| Percentage of total database...................... 0.007% | |
| Number of entries................................. 5167 | |
| Bytes of storage consumed......................... 266240 | |
| Bytes of payload.................................. 247632 93.0% | |
| Bytes of metadata................................. 16277 6.1% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 47.93 | |
| Average unused bytes per entry.................... 0.45 | |
| Average metadata per entry........................ 3.15 | |
| Average fanout.................................... 65.00 | |
| Non-sequential pages.............................. 2 3.1% | |
| Maximum payload per entry......................... 48 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 64 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 65 | |
| Unused bytes on index pages....................... 622 15.2% | |
| Unused bytes on primary pages..................... 1709 0.65% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 2331 0.88% | |
| *** Table ACTIVE_STORAGE_BLOBS and all its indices **************************** | |
| Percentage of total database...................... 0.029% | |
| Number of entries................................. 10334 | |
| Bytes of storage consumed......................... 1081344 | |
| Bytes of payload.................................. 981406 90.8% | |
| Bytes of metadata................................. 50355 4.7% | |
| Average payload per entry......................... 94.97 | |
| Average unused bytes per entry.................... 4.80 | |
| Average metadata per entry........................ 4.87 | |
| Average fanout.................................... 131.00 | |
| Maximum payload per entry......................... 158 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 2 | |
| Primary pages used................................ 262 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 264 | |
| Unused bytes on index pages....................... 4365 53.3% | |
| Unused bytes on primary pages..................... 45218 4.2% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 49583 4.6% | |
| *** Table ACTIVE_STORAGE_BLOBS w/o any indices ******************************** | |
| Percentage of total database...................... 0.023% | |
| Number of entries................................. 5167 | |
| Bytes of storage consumed......................... 851968 | |
| Bytes of payload.................................. 811023 95.2% | |
| Bytes of metadata................................. 34186 4.0% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 156.96 | |
| Average unused bytes per entry.................... 1.31 | |
| Average metadata per entry........................ 6.62 | |
| Average fanout.................................... 207.00 | |
| Non-sequential pages.............................. 4 1.9% | |
| Maximum payload per entry......................... 158 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 207 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 208 | |
| Unused bytes on index pages....................... 2441 59.6% | |
| Unused bytes on primary pages..................... 4318 0.51% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 6759 0.79% | |
| *** Index INDEX_ACTIVE_STORAGE_BLOBS_ON_KEY of table ACTIVE_STORAGE_BLOBS ***** | |
| Percentage of total database...................... 0.006% | |
| Number of entries................................. 5167 | |
| Bytes of storage consumed......................... 229376 | |
| Bytes of payload.................................. 170383 74.3% | |
| Bytes of metadata................................. 16169 7.0% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 32.98 | |
| Average unused bytes per entry.................... 8.29 | |
| Average metadata per entry........................ 3.13 | |
| Average fanout.................................... 56.00 | |
| Non-sequential pages.............................. 8 14.5% | |
| Maximum payload per entry......................... 33 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 55 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 56 | |
| Unused bytes on index pages....................... 1924 47.0% | |
| Unused bytes on primary pages..................... 40900 18.2% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 42824 18.7% | |
| *** Table ACTIVE_STORAGE_VARIANT_RECORDS and all its indices ****************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 8192 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 16 0.20% | |
| Average payload per entry......................... 0.0 | |
| Average unused bytes per entry.................... 0.0 | |
| Average metadata per entry........................ 0.0 | |
| Maximum payload per entry......................... 0 | |
| Entries that use overflow......................... 0 | |
| Primary pages used................................ 2 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 2 | |
| Unused bytes on primary pages..................... 8176 99.80% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8176 99.80% | |
| *** Table ACTIVE_STORAGE_VARIANT_RECORDS w/o any indices ********************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 8 0.20% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 0.0 | |
| Average unused bytes per entry.................... 0.0 | |
| Average metadata per entry........................ 0.0 | |
| Maximum payload per entry......................... 0 | |
| Entries that use overflow......................... 0 | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 4088 99.80% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4088 99.80% | |
| *** Index INDEX_ACTIVE_STORAGE_VARIANT_RECORDS_UNIQUENESS of table ACTIVE_STORAGE_VARIANT_RECORDS | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 8 0.20% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 0.0 | |
| Average unused bytes per entry.................... 0.0 | |
| Average metadata per entry........................ 0.0 | |
| Maximum payload per entry......................... 0 | |
| Entries that use overflow......................... 0 | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 4088 99.80% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4088 99.80% | |
| *** Table AR_INTERNAL_METADATA and all its indices **************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 4 | |
| Bytes of storage consumed......................... 8192 | |
| Bytes of payload.................................. 215 2.6% | |
| Bytes of metadata................................. 30 0.37% | |
| Average payload per entry......................... 53.75 | |
| Average unused bytes per entry.................... 1986.75 | |
| Average metadata per entry........................ 7.50 | |
| Maximum payload per entry......................... 108 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 2 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 2 | |
| Unused bytes on primary pages..................... 7947 97.0% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7947 97.0% | |
| *** Table AR_INTERNAL_METADATA w/o any indices ******************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 2 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 186 4.5% | |
| Bytes of metadata................................. 16 0.39% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 93.00 | |
| Average unused bytes per entry.................... 1947.00 | |
| Average metadata per entry........................ 8.00 | |
| Maximum payload per entry......................... 108 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 3894 95.1% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3894 95.1% | |
| *** Index SQLITE_AUTOINDEX_AR_INTERNAL_METADATA_1 of table AR_INTERNAL_METADATA | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 2 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 29 0.71% | |
| Bytes of metadata................................. 14 0.34% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 14.50 | |
| Average unused bytes per entry.................... 2026.50 | |
| Average metadata per entry........................ 7.00 | |
| Maximum payload per entry......................... 15 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 4053 99.0% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4053 99.0% | |
| *** Table CATEGORIES and all its indices ************************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 36 | |
| Bytes of storage consumed......................... 12288 | |
| Bytes of payload.................................. 1628 13.2% | |
| Bytes of metadata................................. 144 1.2% | |
| Average payload per entry......................... 45.22 | |
| Average unused bytes per entry.................... 292.11 | |
| Average metadata per entry........................ 4.00 | |
| Maximum payload per entry......................... 90 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 3 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 3 | |
| Unused bytes on primary pages..................... 10516 85.6% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 10516 85.6% | |
| *** Table CATEGORIES w/o any indices ****************************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 12 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 1031 25.2% | |
| Bytes of metadata................................. 56 1.4% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 85.92 | |
| Average unused bytes per entry.................... 250.75 | |
| Average metadata per entry........................ 4.67 | |
| Maximum payload per entry......................... 90 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 3009 73.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3009 73.5% | |
| *** Indices of table CATEGORIES *********************************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 24 | |
| Bytes of storage consumed......................... 8192 | |
| Bytes of payload.................................. 597 7.3% | |
| Bytes of metadata................................. 88 1.1% | |
| Average payload per entry......................... 24.88 | |
| Average unused bytes per entry.................... 312.79 | |
| Average metadata per entry........................ 3.67 | |
| Maximum payload per entry......................... 39 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 2 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 2 | |
| Unused bytes on primary pages..................... 7507 91.6% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7507 91.6% | |
| *** Index INDEX_CATEGORIES_ON_CATEGORY of table CATEGORIES ******************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 12 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 130 3.2% | |
| Bytes of metadata................................. 44 1.1% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 10.83 | |
| Average unused bytes per entry.................... 326.83 | |
| Average metadata per entry........................ 3.67 | |
| Maximum payload per entry......................... 15 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 3922 95.8% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3922 95.8% | |
| *** Index INDEX_CATEGORIES_ON_TOKEN of table CATEGORIES *********************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 12 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 467 11.4% | |
| Bytes of metadata................................. 44 1.1% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 38.92 | |
| Average unused bytes per entry.................... 298.75 | |
| Average metadata per entry........................ 3.67 | |
| Maximum payload per entry......................... 39 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 3585 87.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3585 87.5% | |
| *** Table COMMENT_STATS and all its indices *********************************** | |
| Percentage of total database...................... 0.005% | |
| Number of entries................................. 9898 | |
| Bytes of storage consumed......................... 200704 | |
| Bytes of payload.................................. 148420 73.9% | |
| Bytes of metadata................................. 40141 20.0% | |
| Average payload per entry......................... 14.99 | |
| Average unused bytes per entry.................... 1.23 | |
| Average metadata per entry........................ 4.06 | |
| Average fanout.................................... 24.00 | |
| Maximum payload per entry......................... 22 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 2 | |
| Primary pages used................................ 47 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 49 | |
| Unused bytes on index pages....................... 7514 91.7% | |
| Unused bytes on primary pages..................... 4629 2.4% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 12143 6.1% | |
| *** Table COMMENT_STATS w/o any indices *************************************** | |
| Percentage of total database...................... 0.003% | |
| Number of entries................................. 4949 | |
| Bytes of storage consumed......................... 106496 | |
| Bytes of payload.................................. 74313 69.8% | |
| Bytes of metadata................................. 25022 23.5% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 15.02 | |
| Average unused bytes per entry.................... 1.45 | |
| Average metadata per entry........................ 5.06 | |
| Average fanout.................................... 25.00 | |
| Non-sequential pages.............................. 1 4.0% | |
| Maximum payload per entry......................... 22 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 25 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 26 | |
| Unused bytes on index pages....................... 3892 95.0% | |
| Unused bytes on primary pages..................... 3269 3.2% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7161 6.7% | |
| *** Index INDEX_COMMENT_STATS_ON_DATE of table COMMENT_STATS ****************** | |
| Percentage of total database...................... 0.003% | |
| Number of entries................................. 4949 | |
| Bytes of storage consumed......................... 94208 | |
| Bytes of payload.................................. 74107 78.7% | |
| Bytes of metadata................................. 15119 16.0% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 14.97 | |
| Average unused bytes per entry.................... 1.01 | |
| Average metadata per entry........................ 3.05 | |
| Average fanout.................................... 23.00 | |
| Non-sequential pages.............................. 1 4.5% | |
| Maximum payload per entry......................... 15 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 22 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 23 | |
| Unused bytes on index pages....................... 3622 88.4% | |
| Unused bytes on primary pages..................... 1360 1.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4982 5.3% | |
| *** Table COMMENTS and all its indices **************************************** | |
| Percentage of total database...................... 26.9% | |
| Number of entries................................. 6999700 | |
| Bytes of storage consumed......................... 1013493760 | |
| Bytes of payload.................................. 837178008 82.6% | |
| Bytes of metadata................................. 27671397 2.7% | |
| Average payload per entry......................... 119.60 | |
| Average unused bytes per entry.................... 21.24 | |
| Average metadata per entry........................ 3.95 | |
| Average fanout.................................... 330.00 | |
| Maximum payload per entry......................... 113343 | |
| Entries that use overflow......................... 17380 0.25% | |
| Index pages used.................................. 686 | |
| Primary pages used................................ 226176 | |
| Overflow pages used............................... 20573 | |
| Total pages used.................................. 247435 | |
| Unused bytes on index pages....................... 338839 12.1% | |
| Unused bytes on primary pages..................... 146837246 15.9% | |
| Unused bytes on overflow pages.................... 1481042 1.8% | |
| Unused bytes on all pages......................... 148657127 14.7% | |
| *** Table COMMENTS w/o any indices ******************************************** | |
| Percentage of total database...................... 24.2% | |
| Number of entries................................. 699970 | |
| Bytes of storage consumed......................... 910512128 | |
| Bytes of payload.................................. 753938126 82.8% | |
| Bytes of metadata................................. 8470539 0.93% | |
| B-tree depth...................................... 4 | |
| Average payload per entry......................... 1077.10 | |
| Average unused bytes per entry.................... 211.60 | |
| Average metadata per entry........................ 12.10 | |
| Average fanout.................................... 397.00 | |
| Non-sequential pages.............................. 14 0.006% | |
| Maximum payload per entry......................... 113343 | |
| Entries that use overflow......................... 17380 2.5% | |
| Index pages used.................................. 507 | |
| Primary pages used................................ 201213 | |
| Overflow pages used............................... 20573 | |
| Total pages used.................................. 222293 | |
| Unused bytes on index pages....................... 263903 12.7% | |
| Unused bytes on primary pages..................... 146371290 17.8% | |
| Unused bytes on overflow pages.................... 1481042 1.8% | |
| Unused bytes on all pages......................... 148116235 16.3% | |
| *** Indices of table COMMENTS ************************************************* | |
| Percentage of total database...................... 2.7% | |
| Number of entries................................. 6299730 | |
| Bytes of storage consumed......................... 102981632 | |
| Bytes of payload.................................. 83239882 80.8% | |
| Bytes of metadata................................. 19200858 18.6% | |
| Average payload per entry......................... 13.21 | |
| Average unused bytes per entry.................... 0.09 | |
| Average metadata per entry........................ 3.05 | |
| Average fanout.................................... 140.00 | |
| Maximum payload per entry......................... 40 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 179 | |
| Primary pages used................................ 24963 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 25142 | |
| Unused bytes on index pages....................... 74936 10.2% | |
| Unused bytes on primary pages..................... 465956 0.46% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 540892 0.53% | |
| *** Index COMMENTS_HAT_ID_FK of table COMMENTS ******************************** | |
| Percentage of total database...................... 0.17% | |
| Number of entries................................. 699970 | |
| Bytes of storage consumed......................... 6303744 | |
| Bytes of payload.................................. 4171391 66.2% | |
| Bytes of metadata................................. 2118374 33.6% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 5.96 | |
| Average unused bytes per entry.................... 0.02 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 256.00 | |
| Non-sequential pages.............................. 2 0.13% | |
| Maximum payload per entry......................... 8 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 6 | |
| Primary pages used................................ 1533 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1539 | |
| Unused bytes on index pages....................... 4638 18.9% | |
| Unused bytes on primary pages..................... 9341 0.15% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 13979 0.22% | |
| *** Index COMMENTS_PARENT_COMMENT_ID_FK of table COMMENTS ********************* | |
| Percentage of total database...................... 0.20% | |
| Number of entries................................. 699970 | |
| Bytes of storage consumed......................... 7659520 | |
| Bytes of payload.................................. 5512481 72.0% | |
| Bytes of metadata................................. 2122346 27.7% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 7.88 | |
| Average unused bytes per entry.................... 0.04 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 207.00 | |
| Non-sequential pages.............................. 2 0.11% | |
| Maximum payload per entry......................... 9 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 9 | |
| Primary pages used................................ 1861 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1870 | |
| Unused bytes on index pages....................... 8720 23.7% | |
| Unused bytes on primary pages..................... 15973 0.21% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 24693 0.32% | |
| *** Index CONFIDENCE_IDX of table COMMENTS ************************************ | |
| Percentage of total database...................... 0.32% | |
| Number of entries................................. 699970 | |
| Bytes of storage consumed......................... 11927552 | |
| Bytes of payload.................................. 9676699 81.1% | |
| Bytes of metadata................................. 2134850 17.9% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 13.82 | |
| Average unused bytes per entry.................... 0.17 | |
| Average metadata per entry........................ 3.05 | |
| Average fanout.................................... 145.00 | |
| Non-sequential pages.............................. 16 0.55% | |
| Maximum payload per entry......................... 14 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 20 | |
| Primary pages used................................ 2892 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 2912 | |
| Unused bytes on index pages....................... 21285 26.0% | |
| Unused bytes on primary pages..................... 94718 0.80% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 116003 0.97% | |
| *** Index INDEX_COMMENTS_ON_SCORE of table COMMENTS *************************** | |
| Percentage of total database...................... 0.18% | |
| Number of entries................................. 699970 | |
| Bytes of storage consumed......................... 6873088 | |
| Bytes of payload.................................. 4672242 68.0% | |
| Bytes of metadata................................. 2120042 30.8% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 6.67 | |
| Average unused bytes per entry.................... 0.12 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 239.00 | |
| Non-sequential pages.............................. 16 0.95% | |
| Maximum payload per entry......................... 8 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 7 | |
| Primary pages used................................ 1671 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1678 | |
| Unused bytes on index pages....................... 5706 19.9% | |
| Unused bytes on primary pages..................... 75098 1.1% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 80804 1.2% | |
| *** Index INDEX_COMMENTS_ON_TOKEN of table COMMENTS *************************** | |
| Percentage of total database...................... 0.80% | |
| Number of entries................................. 699970 | |
| Bytes of storage consumed......................... 30187520 | |
| Bytes of payload.................................. 27965911 92.6% | |
| Bytes of metadata................................. 2188346 7.2% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 39.95 | |
| Average unused bytes per entry.................... 0.05 | |
| Average metadata per entry........................ 3.13 | |
| Average fanout.................................... 86.00 | |
| Non-sequential pages.............................. 1 0.014% | |
| Maximum payload per entry......................... 40 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 85 | |
| Primary pages used................................ 7285 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 7370 | |
| Unused bytes on index pages....................... 5127 1.5% | |
| Unused bytes on primary pages..................... 28136 0.094% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 33263 0.11% | |
| *** Index INDEX_COMMENTS_ON_USER_ID of table COMMENTS ************************* | |
| Percentage of total database...................... 0.21% | |
| Number of entries................................. 699970 | |
| Bytes of storage consumed......................... 7782400 | |
| Bytes of payload.................................. 5556580 71.4% | |
| Bytes of metadata................................. 2122706 27.3% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 7.94 | |
| Average unused bytes per entry.................... 0.15 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 211.00 | |
| Non-sequential pages.............................. 21 1.1% | |
| Maximum payload per entry......................... 8 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 9 | |
| Primary pages used................................ 1891 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1900 | |
| Unused bytes on index pages....................... 8509 23.1% | |
| Unused bytes on primary pages..................... 94605 1.2% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 103114 1.3% | |
| *** Index SHORT_ID of table COMMENTS ****************************************** | |
| Percentage of total database...................... 0.28% | |
| Number of entries................................. 699970 | |
| Bytes of storage consumed......................... 10629120 | |
| Bytes of payload.................................. 8366751 78.7% | |
| Bytes of metadata................................. 2131046 20.0% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 11.95 | |
| Average unused bytes per entry.................... 0.19 | |
| Average metadata per entry........................ 3.04 | |
| Average fanout.................................... 173.00 | |
| Non-sequential pages.............................. 26 1.0% | |
| Maximum payload per entry......................... 12 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 15 | |
| Primary pages used................................ 2580 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 2595 | |
| Unused bytes on index pages....................... 12369 20.1% | |
| Unused bytes on primary pages..................... 118954 1.1% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 131323 1.2% | |
| *** Index STORY_ID_SHORT_ID of table COMMENTS ********************************* | |
| Percentage of total database...................... 0.35% | |
| Number of entries................................. 699970 | |
| Bytes of storage consumed......................... 13230080 | |
| Bytes of payload.................................. 11075362 83.7% | |
| Bytes of metadata................................. 2138666 16.2% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 15.82 | |
| Average unused bytes per entry.................... 0.02 | |
| Average metadata per entry........................ 3.06 | |
| Average fanout.................................... 170.00 | |
| Non-sequential pages.............................. 1 0.031% | |
| Maximum payload per entry......................... 16 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 19 | |
| Primary pages used................................ 3211 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 3230 | |
| Unused bytes on index pages....................... 4293 5.5% | |
| Unused bytes on primary pages..................... 11759 0.089% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 16052 0.12% | |
| *** Index THREAD_ID of table COMMENTS ***************************************** | |
| Percentage of total database...................... 0.22% | |
| Number of entries................................. 699970 | |
| Bytes of storage consumed......................... 8388608 | |
| Bytes of payload.................................. 6242465 74.4% | |
| Bytes of metadata................................. 2124482 25.3% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 8.92 | |
| Average unused bytes per entry.................... 0.03 | |
| Average metadata per entry........................ 3.04 | |
| Average fanout.................................... 227.00 | |
| Non-sequential pages.............................. 1 0.049% | |
| Maximum payload per entry......................... 9 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 9 | |
| Primary pages used................................ 2039 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 2048 | |
| Unused bytes on index pages....................... 4289 11.6% | |
| Unused bytes on primary pages..................... 17372 0.21% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 21661 0.26% | |
| *** Table COMMENTS_FTS_CONFIG ************************************************* | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 1 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 11 0.27% | |
| Bytes of metadata................................. 11 0.27% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 11.00 | |
| Average unused bytes per entry.................... 4074.00 | |
| Average metadata per entry........................ 11.00 | |
| Maximum payload per entry......................... 11 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 4074 99.46% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4074 99.46% | |
| *** Table COMMENTS_FTS_DATA *************************************************** | |
| Percentage of total database...................... 4.0% | |
| Number of entries................................. 37994 | |
| Bytes of storage consumed......................... 151134208 | |
| Bytes of payload.................................. 148857261 98.5% | |
| Bytes of metadata................................. 1115739 0.74% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 3917.91 | |
| Average unused bytes per entry.................... 30.56 | |
| Average metadata per entry........................ 29.37 | |
| Average fanout.................................... 295.00 | |
| Non-sequential pages.............................. 13 0.035% | |
| Maximum payload per entry......................... 4057 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 125 | |
| Primary pages used................................ 36773 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 36898 | |
| Unused bytes on index pages....................... 69241 13.5% | |
| Unused bytes on primary pages..................... 1091967 0.72% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 1161208 0.77% | |
| *** Table COMMENTS_FTS_DOCSIZE ************************************************ | |
| Percentage of total database...................... 0.24% | |
| Number of entries................................. 699970 | |
| Bytes of storage consumed......................... 9011200 | |
| Bytes of payload.................................. 4766830 52.9% | |
| Bytes of metadata................................. 4220629 46.8% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 6.81 | |
| Average unused bytes per entry.................... 0.03 | |
| Average metadata per entry........................ 6.03 | |
| Average fanout.................................... 314.00 | |
| Non-sequential pages.............................. 1 0.045% | |
| Maximum payload per entry......................... 8 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 7 | |
| Primary pages used................................ 2193 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 2200 | |
| Unused bytes on index pages....................... 8903 31.1% | |
| Unused bytes on primary pages..................... 14838 0.17% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 23741 0.26% | |
| *** Table COMMENTS_FTS_IDX **************************************************** | |
| Percentage of total database...................... 0.008% | |
| Number of entries................................. 15893 | |
| Bytes of storage consumed......................... 286720 | |
| Bytes of payload.................................. 229293 80.0% | |
| Bytes of metadata................................. 48516 16.9% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 14.43 | |
| Average unused bytes per entry.................... 0.56 | |
| Average metadata per entry........................ 3.05 | |
| Average fanout.................................... 69.00 | |
| Non-sequential pages.............................. 3 4.3% | |
| Maximum payload per entry......................... 142 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 69 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 70 | |
| Unused bytes on index pages....................... 2606 63.6% | |
| Unused bytes on primary pages..................... 6305 2.2% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8911 3.1% | |
| *** Table DOMAINS and all its indices ***************************************** | |
| Percentage of total database...................... 0.17% | |
| Number of entries................................. 138812 | |
| Bytes of storage consumed......................... 6270976 | |
| Bytes of payload.................................. 5656875 90.2% | |
| Bytes of metadata................................. 526975 8.4% | |
| Average payload per entry......................... 40.75 | |
| Average unused bytes per entry.................... 0.63 | |
| Average metadata per entry........................ 3.80 | |
| Average fanout.................................... 127.00 | |
| Maximum payload per entry......................... 306 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 12 | |
| Primary pages used................................ 1519 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1531 | |
| Unused bytes on index pages....................... 19167 39.0% | |
| Unused bytes on primary pages..................... 67959 1.1% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 87126 1.4% | |
| *** Table DOMAINS w/o any indices ********************************************* | |
| Percentage of total database...................... 0.098% | |
| Number of entries................................. 34703 | |
| Bytes of storage consumed......................... 3706880 | |
| Bytes of payload.................................. 3449925 93.1% | |
| Bytes of metadata................................. 207147 5.6% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 99.41 | |
| Average unused bytes per entry.................... 1.44 | |
| Average metadata per entry........................ 5.97 | |
| Average fanout.................................... 301.00 | |
| Non-sequential pages.............................. 1 0.11% | |
| Maximum payload per entry......................... 306 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 902 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 905 | |
| Unused bytes on index pages....................... 4565 37.2% | |
| Unused bytes on primary pages..................... 45243 1.2% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 49808 1.3% | |
| *** Indices of table DOMAINS ************************************************** | |
| Percentage of total database...................... 0.068% | |
| Number of entries................................. 104109 | |
| Bytes of storage consumed......................... 2564096 | |
| Bytes of payload.................................. 2206950 86.1% | |
| Bytes of metadata................................. 319828 12.5% | |
| Average payload per entry......................... 21.20 | |
| Average unused bytes per entry.................... 0.36 | |
| Average metadata per entry........................ 3.07 | |
| Average fanout.................................... 69.00 | |
| Maximum payload per entry......................... 157 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 9 | |
| Primary pages used................................ 617 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 626 | |
| Unused bytes on index pages....................... 14602 39.6% | |
| Unused bytes on primary pages..................... 22716 0.90% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 37318 1.5% | |
| *** Index INDEX_DOMAINS_ON_BANNED_BY_USER_ID of table DOMAINS ***************** | |
| Percentage of total database...................... 0.008% | |
| Number of entries................................. 34703 | |
| Bytes of storage consumed......................... 286720 | |
| Bytes of payload.................................. 175847 61.3% | |
| Bytes of metadata................................. 104945 36.6% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 5.07 | |
| Average unused bytes per entry.................... 0.17 | |
| Average metadata per entry........................ 3.02 | |
| Average fanout.................................... 70.00 | |
| Non-sequential pages.............................. 1 1.4% | |
| Maximum payload per entry......................... 8 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 69 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 70 | |
| Unused bytes on index pages....................... 3263 79.7% | |
| Unused bytes on primary pages..................... 2665 0.94% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 5928 2.1% | |
| *** Index INDEX_DOMAINS_ON_DOMAIN of table DOMAINS **************************** | |
| Percentage of total database...................... 0.022% | |
| Number of entries................................. 34703 | |
| Bytes of storage consumed......................... 831488 | |
| Bytes of payload.................................. 710379 85.4% | |
| Bytes of metadata................................. 106542 12.8% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 20.47 | |
| Average unused bytes per entry.................... 0.42 | |
| Average metadata per entry........................ 3.07 | |
| Average fanout.................................... 67.00 | |
| Non-sequential pages.............................. 2 0.99% | |
| Maximum payload per entry......................... 157 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 200 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 203 | |
| Unused bytes on index pages....................... 6555 53.3% | |
| Unused bytes on primary pages..................... 8012 0.98% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 14567 1.8% | |
| *** Index INDEX_DOMAINS_ON_TOKEN of table DOMAINS ***************************** | |
| Percentage of total database...................... 0.038% | |
| Number of entries................................. 34703 | |
| Bytes of storage consumed......................... 1445888 | |
| Bytes of payload.................................. 1320724 91.3% | |
| Bytes of metadata................................. 108341 7.5% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 38.06 | |
| Average unused bytes per entry.................... 0.48 | |
| Average metadata per entry........................ 3.12 | |
| Average fanout.................................... 70.00 | |
| Non-sequential pages.............................. 1 0.28% | |
| Maximum payload per entry......................... 39 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 5 | |
| Primary pages used................................ 348 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 353 | |
| Unused bytes on index pages....................... 4784 23.4% | |
| Unused bytes on primary pages..................... 12039 0.84% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 16823 1.2% | |
| *** Table HAT_REQUESTS and all its indices ************************************ | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 12288 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 24 0.20% | |
| Average payload per entry......................... 0.0 | |
| Average unused bytes per entry.................... 0.0 | |
| Average metadata per entry........................ 0.0 | |
| Maximum payload per entry......................... 0 | |
| Entries that use overflow......................... 0 | |
| Primary pages used................................ 3 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 3 | |
| Unused bytes on primary pages..................... 12264 99.80% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 12264 99.80% | |
| *** Table HAT_REQUESTS w/o any indices **************************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 8 0.20% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 0.0 | |
| Average unused bytes per entry.................... 0.0 | |
| Average metadata per entry........................ 0.0 | |
| Maximum payload per entry......................... 0 | |
| Entries that use overflow......................... 0 | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 4088 99.80% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4088 99.80% | |
| *** Indices of table HAT_REQUESTS ********************************************* | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 8192 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 16 0.20% | |
| Average payload per entry......................... 0.0 | |
| Average unused bytes per entry.................... 0.0 | |
| Average metadata per entry........................ 0.0 | |
| Maximum payload per entry......................... 0 | |
| Entries that use overflow......................... 0 | |
| Primary pages used................................ 2 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 2 | |
| Unused bytes on primary pages..................... 8176 99.80% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8176 99.80% | |
| *** Index HAT_REQUESTS_USER_ID_FK of table HAT_REQUESTS *********************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 8 0.20% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 0.0 | |
| Average unused bytes per entry.................... 0.0 | |
| Average metadata per entry........................ 0.0 | |
| Maximum payload per entry......................... 0 | |
| Entries that use overflow......................... 0 | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 4088 99.80% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4088 99.80% | |
| *** Index INDEX_HAT_REQUESTS_ON_TOKEN of table HAT_REQUESTS ******************* | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 8 0.20% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 0.0 | |
| Average unused bytes per entry.................... 0.0 | |
| Average metadata per entry........................ 0.0 | |
| Maximum payload per entry......................... 0 | |
| Entries that use overflow......................... 0 | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 4088 99.80% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4088 99.80% | |
| *** Table HATS and all its indices ******************************************** | |
| Percentage of total database...................... 0.002% | |
| Number of entries................................. 1136 | |
| Bytes of storage consumed......................... 73728 | |
| Bytes of payload.................................. 52650 71.4% | |
| Bytes of metadata................................. 4268 5.8% | |
| Average payload per entry......................... 46.35 | |
| Average unused bytes per entry.................... 14.80 | |
| Average metadata per entry........................ 3.76 | |
| Average fanout.................................... 8.00 | |
| Maximum payload per entry......................... 246 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 2 | |
| Primary pages used................................ 16 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 18 | |
| Unused bytes on index pages....................... 8009 97.8% | |
| Unused bytes on primary pages..................... 8801 13.4% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 16810 22.8% | |
| *** Table HATS w/o any indices ************************************************ | |
| Percentage of total database...................... 0.001% | |
| Number of entries................................. 284 | |
| Bytes of storage consumed......................... 49152 | |
| Bytes of payload.................................. 39482 80.3% | |
| Bytes of metadata................................. 1652 3.4% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 139.02 | |
| Average unused bytes per entry.................... 28.23 | |
| Average metadata per entry........................ 5.82 | |
| Average fanout.................................... 11.00 | |
| Non-sequential pages.............................. 1 9.1% | |
| Maximum payload per entry......................... 246 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 11 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 12 | |
| Unused bytes on index pages....................... 4008 97.9% | |
| Unused bytes on primary pages..................... 4010 8.9% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8018 16.3% | |
| *** Indices of table HATS ***************************************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 852 | |
| Bytes of storage consumed......................... 24576 | |
| Bytes of payload.................................. 13168 53.6% | |
| Bytes of metadata................................. 2616 10.6% | |
| Average payload per entry......................... 15.46 | |
| Average unused bytes per entry.................... 10.32 | |
| Average metadata per entry........................ 3.07 | |
| Average fanout.................................... 6.00 | |
| Maximum payload per entry......................... 35 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 5 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 6 | |
| Unused bytes on index pages....................... 4001 97.7% | |
| Unused bytes on primary pages..................... 4791 23.4% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8792 35.8% | |
| *** Index HATS_GRANTED_BY_USER_ID_FK of table HATS **************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 284 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 1504 36.7% | |
| Bytes of metadata................................. 860 21.0% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 5.30 | |
| Average unused bytes per entry.................... 6.10 | |
| Average metadata per entry........................ 3.03 | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 1732 42.3% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 1732 42.3% | |
| *** Index HATS_USER_ID_FK of table HATS *************************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 284 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 1851 45.2% | |
| Bytes of metadata................................. 860 21.0% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 6.52 | |
| Average unused bytes per entry.................... 4.88 | |
| Average metadata per entry........................ 3.03 | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 1385 33.8% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 1385 33.8% | |
| *** Index INDEX_HATS_ON_TOKEN of table HATS *********************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 284 | |
| Bytes of storage consumed......................... 16384 | |
| Bytes of payload.................................. 9813 59.9% | |
| Bytes of metadata................................. 896 5.5% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 34.55 | |
| Average unused bytes per entry.................... 19.98 | |
| Average metadata per entry........................ 3.15 | |
| Average fanout.................................... 4.00 | |
| Non-sequential pages.............................. 1 33.3% | |
| Maximum payload per entry......................... 35 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 3 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 4 | |
| Unused bytes on index pages....................... 4001 97.7% | |
| Unused bytes on primary pages..................... 1674 13.6% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 5675 34.6% | |
| *** Table HIDDEN_STORIES and all its indices ********************************** | |
| Percentage of total database...................... 0.93% | |
| Number of entries................................. 1027296 | |
| Bytes of storage consumed......................... 34934784 | |
| Bytes of payload.................................. 30759020 88.0% | |
| Bytes of metadata................................. 3958074 11.3% | |
| Average payload per entry......................... 29.94 | |
| Average unused bytes per entry.................... 0.21 | |
| Average metadata per entry........................ 3.85 | |
| Average fanout.................................... 144.00 | |
| Maximum payload per entry......................... 75 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 59 | |
| Primary pages used................................ 8470 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 8529 | |
| Unused bytes on index pages....................... 28294 11.7% | |
| Unused bytes on primary pages..................... 189396 0.55% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 217690 0.62% | |
| *** Table HIDDEN_STORIES w/o any indices ************************************** | |
| Percentage of total database...................... 0.42% | |
| Number of entries................................. 256824 | |
| Bytes of storage consumed......................... 15917056 | |
| Bytes of payload.................................. 14218052 89.3% | |
| Bytes of metadata................................. 1590954 10.0% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 55.36 | |
| Average unused bytes per entry.................... 0.42 | |
| Average metadata per entry........................ 6.19 | |
| Average fanout.................................... 353.00 | |
| Non-sequential pages.............................. 1 0.026% | |
| Maximum payload per entry......................... 75 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 11 | |
| Primary pages used................................ 3875 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 3886 | |
| Unused bytes on index pages....................... 10262 22.8% | |
| Unused bytes on primary pages..................... 97788 0.62% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 108050 0.68% | |
| *** Indices of table HIDDEN_STORIES ******************************************* | |
| Percentage of total database...................... 0.50% | |
| Number of entries................................. 770472 | |
| Bytes of storage consumed......................... 19017728 | |
| Bytes of payload.................................. 16540968 87.0% | |
| Bytes of metadata................................. 2367120 12.4% | |
| Average payload per entry......................... 21.47 | |
| Average unused bytes per entry.................... 0.14 | |
| Average metadata per entry........................ 3.07 | |
| Average fanout.................................... 96.00 | |
| Maximum payload per entry......................... 44 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 48 | |
| Primary pages used................................ 4595 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 4643 | |
| Unused bytes on index pages....................... 18032 9.2% | |
| Unused bytes on primary pages..................... 91608 0.49% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 109640 0.58% | |
| *** Index HIDDEN_STORIES_STORY_ID_FK of table HIDDEN_STORIES ****************** | |
| Percentage of total database...................... 0.081% | |
| Number of entries................................. 256824 | |
| Bytes of storage consumed......................... 3043328 | |
| Bytes of payload.................................. 2251024 74.0% | |
| Bytes of metadata................................. 779384 25.6% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 8.76 | |
| Average unused bytes per entry.................... 0.05 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 185.00 | |
| Non-sequential pages.............................. 1 0.13% | |
| Maximum payload per entry......................... 9 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 4 | |
| Primary pages used................................ 739 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 743 | |
| Unused bytes on index pages....................... 4674 28.5% | |
| Unused bytes on primary pages..................... 8246 0.27% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 12920 0.42% | |
| *** Index INDEX_HIDDEN_STORIES_ON_TOKEN of table HIDDEN_STORIES *************** | |
| Percentage of total database...................... 0.32% | |
| Number of entries................................. 256824 | |
| Bytes of storage consumed......................... 12144640 | |
| Bytes of payload.................................. 11268967 92.8% | |
| Bytes of metadata................................. 806048 6.6% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 43.88 | |
| Average unused bytes per entry.................... 0.27 | |
| Average metadata per entry........................ 3.14 | |
| Average fanout.................................... 78.00 | |
| Non-sequential pages.............................. 1 0.034% | |
| Maximum payload per entry......................... 44 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 38 | |
| Primary pages used................................ 2927 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 2965 | |
| Unused bytes on index pages....................... 6297 4.0% | |
| Unused bytes on primary pages..................... 63328 0.53% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 69625 0.57% | |
| *** Index INDEX_HIDDEN_STORIES_ON_USER_ID_AND_STORY_ID of table HIDDEN_STORIES | |
| Percentage of total database...................... 0.10% | |
| Number of entries................................. 256824 | |
| Bytes of storage consumed......................... 3829760 | |
| Bytes of payload.................................. 3020977 78.9% | |
| Bytes of metadata................................. 781688 20.4% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 11.76 | |
| Average unused bytes per entry.................... 0.11 | |
| Average metadata per entry........................ 3.04 | |
| Average fanout.................................... 155.00 | |
| Non-sequential pages.............................. 4 0.43% | |
| Maximum payload per entry......................... 12 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 6 | |
| Primary pages used................................ 929 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 935 | |
| Unused bytes on index pages....................... 7061 28.7% | |
| Unused bytes on primary pages..................... 20034 0.53% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 27095 0.71% | |
| *** Table INVITATION_REQUESTS and all its indices ***************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 8192 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 16 0.20% | |
| Average payload per entry......................... 0.0 | |
| Average unused bytes per entry.................... 0.0 | |
| Average metadata per entry........................ 0.0 | |
| Maximum payload per entry......................... 0 | |
| Entries that use overflow......................... 0 | |
| Primary pages used................................ 2 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 2 | |
| Unused bytes on primary pages..................... 8176 99.80% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8176 99.80% | |
| *** Table INVITATION_REQUESTS w/o any indices ********************************* | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 8 0.20% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 0.0 | |
| Average unused bytes per entry.................... 0.0 | |
| Average metadata per entry........................ 0.0 | |
| Maximum payload per entry......................... 0 | |
| Entries that use overflow......................... 0 | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 4088 99.80% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4088 99.80% | |
| *** Index INDEX_INVITATION_REQUESTS_ON_TOKEN of table INVITATION_REQUESTS ***** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 0 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 0 0.0% | |
| Bytes of metadata................................. 8 0.20% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 0.0 | |
| Average unused bytes per entry.................... 0.0 | |
| Average metadata per entry........................ 0.0 | |
| Maximum payload per entry......................... 0 | |
| Entries that use overflow......................... 0 | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 4088 99.80% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4088 99.80% | |
| *** Table INVITATIONS and all its indices ************************************* | |
| Percentage of total database...................... 0.079% | |
| Number of entries................................. 50748 | |
| Bytes of storage consumed......................... 2961408 | |
| Bytes of payload.................................. 2684533 90.7% | |
| Bytes of metadata................................. 200332 6.8% | |
| Average payload per entry......................... 52.90 | |
| Average unused bytes per entry.................... 1.51 | |
| Average metadata per entry........................ 3.95 | |
| Average fanout.................................... 90.00 | |
| Maximum payload per entry......................... 520 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 8 | |
| Primary pages used................................ 715 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 723 | |
| Unused bytes on index pages....................... 20931 63.9% | |
| Unused bytes on primary pages..................... 55612 1.9% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 76543 2.6% | |
| *** Table INVITATIONS w/o any indices ***************************************** | |
| Percentage of total database...................... 0.056% | |
| Number of entries................................. 12687 | |
| Bytes of storage consumed......................... 2113536 | |
| Bytes of payload.................................. 1978373 93.6% | |
| Bytes of metadata................................. 83677 4.0% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 155.94 | |
| Average unused bytes per entry.................... 4.06 | |
| Average metadata per entry........................ 6.60 | |
| Average fanout.................................... 171.00 | |
| Non-sequential pages.............................. 1 0.19% | |
| Maximum payload per entry......................... 520 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 513 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 516 | |
| Unused bytes on index pages....................... 8156 66.4% | |
| Unused bytes on primary pages..................... 43330 2.1% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 51486 2.4% | |
| *** Indices of table INVITATIONS ********************************************** | |
| Percentage of total database...................... 0.023% | |
| Number of entries................................. 38061 | |
| Bytes of storage consumed......................... 847872 | |
| Bytes of payload.................................. 706160 83.3% | |
| Bytes of metadata................................. 116655 13.8% | |
| Average payload per entry......................... 18.55 | |
| Average unused bytes per entry.................... 0.66 | |
| Average metadata per entry........................ 3.06 | |
| Average fanout.................................... 41.00 | |
| Maximum payload per entry......................... 42 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 5 | |
| Primary pages used................................ 202 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 207 | |
| Unused bytes on index pages....................... 12775 62.4% | |
| Unused bytes on primary pages..................... 12282 1.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 25057 3.0% | |
| *** Index INDEX_INVITATIONS_ON_TOKEN of table INVITATIONS ********************* | |
| Percentage of total database...................... 0.016% | |
| Number of entries................................. 12687 | |
| Bytes of storage consumed......................... 585728 | |
| Bytes of payload.................................. 532836 91.0% | |
| Bytes of metadata................................. 39773 6.8% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 42.00 | |
| Average unused bytes per entry.................... 1.03 | |
| Average metadata per entry........................ 3.13 | |
| Average fanout.................................... 47.00 | |
| Non-sequential pages.............................. 1 0.70% | |
| Maximum payload per entry......................... 42 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 140 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 143 | |
| Unused bytes on index pages....................... 5441 44.3% | |
| Unused bytes on primary pages..................... 7678 1.3% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 13119 2.2% | |
| *** Index INVITATIONS_NEW_USER_ID_FK of table INVITATIONS ********************* | |
| Percentage of total database...................... 0.003% | |
| Number of entries................................. 12687 | |
| Bytes of storage consumed......................... 131072 | |
| Bytes of payload.................................. 84875 64.8% | |
| Bytes of metadata................................. 38441 29.3% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 6.69 | |
| Average unused bytes per entry.................... 0.61 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 32.00 | |
| Non-sequential pages.............................. 1 3.2% | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 31 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 32 | |
| Unused bytes on index pages....................... 3670 89.6% | |
| Unused bytes on primary pages..................... 4086 3.2% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7756 5.9% | |
| *** Index INVITATIONS_USER_ID_FK of table INVITATIONS ************************* | |
| Percentage of total database...................... 0.003% | |
| Number of entries................................. 12687 | |
| Bytes of storage consumed......................... 131072 | |
| Bytes of payload.................................. 88449 67.5% | |
| Bytes of metadata................................. 38441 29.3% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 6.97 | |
| Average unused bytes per entry.................... 0.33 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 32.00 | |
| Non-sequential pages.............................. 1 3.2% | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 31 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 32 | |
| Unused bytes on index pages....................... 3664 89.5% | |
| Unused bytes on primary pages..................... 518 0.41% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4182 3.2% | |
| *** Table KEYSTORES and all its indices *************************************** | |
| Percentage of total database...................... 0.12% | |
| Number of entries................................. 140022 | |
| Bytes of storage consumed......................... 4370432 | |
| Bytes of payload.................................. 3695508 84.6% | |
| Bytes of metadata................................. 638196 14.6% | |
| Average payload per entry......................... 26.39 | |
| Average unused bytes per entry.................... 0.26 | |
| Average metadata per entry........................ 4.56 | |
| Average fanout.................................... 118.00 | |
| Maximum payload per entry......................... 41 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 9 | |
| Primary pages used................................ 1058 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1067 | |
| Unused bytes on index pages....................... 14053 38.1% | |
| Unused bytes on primary pages..................... 22675 0.52% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 36728 0.84% | |
| *** Table KEYSTORES w/o any indices ******************************************* | |
| Percentage of total database...................... 0.060% | |
| Number of entries................................. 70011 | |
| Bytes of storage consumed......................... 2256896 | |
| Bytes of payload.................................. 1815401 80.4% | |
| Bytes of metadata................................. 421975 18.7% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 25.93 | |
| Average unused bytes per entry.................... 0.28 | |
| Average metadata per entry........................ 6.03 | |
| Average fanout.................................... 183.00 | |
| Non-sequential pages.............................. 1 0.18% | |
| Maximum payload per entry......................... 39 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 548 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 551 | |
| Unused bytes on index pages....................... 7346 59.8% | |
| Unused bytes on primary pages..................... 12174 0.54% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 19520 0.86% | |
| *** Index KEY of table KEYSTORES ********************************************** | |
| Percentage of total database...................... 0.056% | |
| Number of entries................................. 70011 | |
| Bytes of storage consumed......................... 2113536 | |
| Bytes of payload.................................. 1880107 89.0% | |
| Bytes of metadata................................. 216221 10.2% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 26.85 | |
| Average unused bytes per entry.................... 0.25 | |
| Average metadata per entry........................ 3.09 | |
| Average fanout.................................... 86.00 | |
| Non-sequential pages.............................. 1 0.19% | |
| Maximum payload per entry......................... 41 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 6 | |
| Primary pages used................................ 510 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 516 | |
| Unused bytes on index pages....................... 6707 27.3% | |
| Unused bytes on primary pages..................... 10501 0.50% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 17208 0.81% | |
| *** Table LINKS and all its indices ******************************************* | |
| Percentage of total database...................... 2.3% | |
| Number of entries................................. 1946154 | |
| Bytes of storage consumed......................... 87257088 | |
| Bytes of payload.................................. 78895467 90.4% | |
| Bytes of metadata................................. 7098873 8.1% | |
| Average payload per entry......................... 40.54 | |
| Average unused bytes per entry.................... 0.65 | |
| Average metadata per entry........................ 3.65 | |
| Average fanout.................................... 101.00 | |
| Maximum payload per entry......................... 637 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 209 | |
| Primary pages used................................ 21094 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 21303 | |
| Unused bytes on index pages....................... 92132 10.8% | |
| Unused bytes on primary pages..................... 1170616 1.4% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 1262748 1.4% | |
| *** Table LINKS w/o any indices *********************************************** | |
| Percentage of total database...................... 1.0% | |
| Number of entries................................. 278022 | |
| Bytes of storage consumed......................... 39383040 | |
| Bytes of payload.................................. 36651079 93.1% | |
| Bytes of metadata................................. 1945742 4.9% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 131.83 | |
| Average unused bytes per entry.................... 2.83 | |
| Average metadata per entry........................ 7.00 | |
| Average fanout.................................... 384.00 | |
| Non-sequential pages.............................. 2 0.021% | |
| Maximum payload per entry......................... 637 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 25 | |
| Primary pages used................................ 9590 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 9615 | |
| Unused bytes on index pages....................... 16302 15.9% | |
| Unused bytes on primary pages..................... 769917 2.0% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 786219 2.0% | |
| *** Indices of table LINKS **************************************************** | |
| Percentage of total database...................... 1.3% | |
| Number of entries................................. 1668132 | |
| Bytes of storage consumed......................... 47874048 | |
| Bytes of payload.................................. 42244388 88.2% | |
| Bytes of metadata................................. 5153131 10.8% | |
| Average payload per entry......................... 25.32 | |
| Average unused bytes per entry.................... 0.29 | |
| Average metadata per entry........................ 3.09 | |
| Average fanout.................................... 63.00 | |
| Maximum payload per entry......................... 262 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 184 | |
| Primary pages used................................ 11504 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 11688 | |
| Unused bytes on index pages....................... 75830 10.1% | |
| Unused bytes on primary pages..................... 400699 0.85% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 476529 1.00% | |
| *** Index IDX_LINKS_ON_TO_COMMENT_ID_AND_FROM_STORY_ID_AND_FROM_COMMENT_ID of table LINKS | |
| Percentage of total database...................... 0.10% | |
| Number of entries................................. 278022 | |
| Bytes of storage consumed......................... 3899392 | |
| Bytes of payload.................................. 3037095 77.9% | |
| Bytes of metadata................................. 845486 21.7% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 10.92 | |
| Average unused bytes per entry.................... 0.06 | |
| Average metadata per entry........................ 3.04 | |
| Average fanout.................................... 158.00 | |
| Non-sequential pages.............................. 3 0.32% | |
| Maximum payload per entry......................... 14 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 6 | |
| Primary pages used................................ 946 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 952 | |
| Unused bytes on index pages....................... 7549 30.7% | |
| Unused bytes on primary pages..................... 9262 0.24% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 16811 0.43% | |
| *** Index INDEX_LINKS_ON_FROM_COMMENT_ID of table LINKS *********************** | |
| Percentage of total database...................... 0.081% | |
| Number of entries................................. 278022 | |
| Bytes of storage consumed......................... 3059712 | |
| Bytes of payload.................................. 2201199 71.9% | |
| Bytes of metadata................................. 843026 27.6% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 7.92 | |
| Average unused bytes per entry.................... 0.06 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 186.00 | |
| Non-sequential pages.............................. 2 0.27% | |
| Maximum payload per entry......................... 9 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 4 | |
| Primary pages used................................ 743 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 747 | |
| Unused bytes on index pages....................... 5141 31.4% | |
| Unused bytes on primary pages..................... 10346 0.34% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 15487 0.51% | |
| *** Index INDEX_LINKS_ON_FROM_STORY_ID of table LINKS ************************* | |
| Percentage of total database...................... 0.073% | |
| Number of entries................................. 278022 | |
| Bytes of storage consumed......................... 2760704 | |
| Bytes of payload.................................. 1903315 68.9% | |
| Bytes of metadata................................. 842150 30.5% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 6.85 | |
| Average unused bytes per entry.................... 0.05 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 168.00 | |
| Non-sequential pages.............................. 2 0.30% | |
| Maximum payload per entry......................... 9 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 4 | |
| Primary pages used................................ 670 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 674 | |
| Unused bytes on index pages....................... 6913 42.2% | |
| Unused bytes on primary pages..................... 8326 0.30% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 15239 0.55% | |
| *** Index INDEX_LINKS_ON_NORMALIZED_URL of table LINKS ************************ | |
| Percentage of total database...................... 0.39% | |
| Number of entries................................. 278022 | |
| Bytes of storage consumed......................... 14872576 | |
| Bytes of payload.................................. 13815629 92.9% | |
| Bytes of metadata................................. 879926 5.9% | |
| B-tree depth...................................... 4 | |
| Average payload per entry......................... 49.69 | |
| Average unused bytes per entry.................... 0.64 | |
| Average metadata per entry........................ 3.16 | |
| Average fanout.................................... 55.00 | |
| Non-sequential pages.............................. 11 0.30% | |
| Maximum payload per entry......................... 246 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 65 | |
| Primary pages used................................ 3566 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 3631 | |
| Unused bytes on index pages....................... 23749 8.9% | |
| Unused bytes on primary pages..................... 153272 1.0% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 177021 1.2% | |
| *** Index INDEX_LINKS_ON_TO_STORY_ID_AND_FROM_STORY_ID_AND_FROM_COMMENT_ID of table LINKS | |
| Percentage of total database...................... 0.10% | |
| Number of entries................................. 278022 | |
| Bytes of storage consumed......................... 3911680 | |
| Bytes of payload.................................. 3044804 77.8% | |
| Bytes of metadata................................. 845522 21.6% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 10.95 | |
| Average unused bytes per entry.................... 0.08 | |
| Average metadata per entry........................ 3.04 | |
| Average fanout.................................... 159.00 | |
| Non-sequential pages.............................. 4 0.42% | |
| Maximum payload per entry......................... 14 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 6 | |
| Primary pages used................................ 949 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 955 | |
| Unused bytes on index pages....................... 7461 30.4% | |
| Unused bytes on primary pages..................... 13893 0.36% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 21354 0.55% | |
| *** Index INDEX_LINKS_ON_URL_AND_FROM_STORY_ID_AND_FROM_COMMENT_ID of table LINKS | |
| Percentage of total database...................... 0.51% | |
| Number of entries................................. 278022 | |
| Bytes of storage consumed......................... 19369984 | |
| Bytes of payload.................................. 18242346 94.2% | |
| Bytes of metadata................................. 897021 4.6% | |
| B-tree depth...................................... 4 | |
| Average payload per entry......................... 65.61 | |
| Average unused bytes per entry.................... 0.83 | |
| Average metadata per entry........................ 3.23 | |
| Average fanout.................................... 47.00 | |
| Non-sequential pages.............................. 7 0.15% | |
| Maximum payload per entry......................... 262 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 99 | |
| Primary pages used................................ 4630 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 4729 | |
| Unused bytes on index pages....................... 25017 6.2% | |
| Unused bytes on primary pages..................... 205600 1.1% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 230617 1.2% | |
| *** Table MASTODON_APPS and all its indices *********************************** | |
| Percentage of total database...................... 0.002% | |
| Number of entries................................. 482 | |
| Bytes of storage consumed......................... 57344 | |
| Bytes of payload.................................. 42531 74.2% | |
| Bytes of metadata................................. 2233 3.9% | |
| Average payload per entry......................... 88.24 | |
| Average unused bytes per entry.................... 26.10 | |
| Average metadata per entry........................ 4.63 | |
| Average fanout.................................... 6.00 | |
| Maximum payload per entry......................... 216 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 2 | |
| Primary pages used................................ 12 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 14 | |
| Unused bytes on index pages....................... 8075 98.6% | |
| Unused bytes on primary pages..................... 4505 9.2% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 12580 21.9% | |
| *** Table MASTODON_APPS w/o any indices *************************************** | |
| Percentage of total database...................... 0.001% | |
| Number of entries................................. 241 | |
| Bytes of storage consumed......................... 45056 | |
| Bytes of payload.................................. 38057 84.5% | |
| Bytes of metadata................................. 1478 3.3% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 157.91 | |
| Average unused bytes per entry.................... 22.91 | |
| Average metadata per entry........................ 6.13 | |
| Average fanout.................................... 10.00 | |
| Non-sequential pages.............................. 1 10.0% | |
| Maximum payload per entry......................... 216 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 10 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 11 | |
| Unused bytes on index pages....................... 4017 98.1% | |
| Unused bytes on primary pages..................... 1504 3.7% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 5521 12.3% | |
| *** Index INDEX_MASTODON_APPS_ON_NAME of table MASTODON_APPS ****************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 241 | |
| Bytes of storage consumed......................... 12288 | |
| Bytes of payload.................................. 4474 36.4% | |
| Bytes of metadata................................. 755 6.1% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 18.56 | |
| Average unused bytes per entry.................... 29.29 | |
| Average metadata per entry........................ 3.13 | |
| Average fanout.................................... 3.00 | |
| Non-sequential pages.............................. 1 50.0% | |
| Maximum payload per entry......................... 33 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 2 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 3 | |
| Unused bytes on index pages....................... 4058 99.07% | |
| Unused bytes on primary pages..................... 3001 36.6% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7059 57.4% | |
| *** Table MESSAGES and all its indices **************************************** | |
| Percentage of total database...................... 0.38% | |
| Number of entries................................. 118146 | |
| Bytes of storage consumed......................... 14290944 | |
| Bytes of payload.................................. 12486775 87.4% | |
| Bytes of metadata................................. 471470 3.3% | |
| Average payload per entry......................... 105.69 | |
| Average unused bytes per entry.................... 11.28 | |
| Average metadata per entry........................ 3.99 | |
| Average fanout.................................... 205.00 | |
| Maximum payload per entry......................... 65887 | |
| Entries that use overflow......................... 151 0.13% | |
| Index pages used.................................. 16 | |
| Primary pages used................................ 3268 | |
| Overflow pages used............................... 205 | |
| Total pages used.................................. 3489 | |
| Unused bytes on index pages....................... 29480 45.0% | |
| Unused bytes on primary pages..................... 1290349 9.6% | |
| Unused bytes on overflow pages.................... 13086 1.6% | |
| Unused bytes on all pages......................... 1332915 9.3% | |
| *** Table MESSAGES w/o any indices ******************************************** | |
| Percentage of total database...................... 0.33% | |
| Number of entries................................. 19691 | |
| Bytes of storage consumed......................... 12611584 | |
| Bytes of payload.................................. 11140303 88.3% | |
| Bytes of metadata................................. 171205 1.4% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 565.76 | |
| Average unused bytes per entry.................... 66.03 | |
| Average metadata per entry........................ 8.69 | |
| Average fanout.................................... 359.00 | |
| Non-sequential pages.............................. 1 0.032% | |
| Maximum payload per entry......................... 65887 | |
| Entries that use overflow......................... 151 0.77% | |
| Index pages used.................................. 8 | |
| Primary pages used................................ 2866 | |
| Overflow pages used............................... 205 | |
| Total pages used.................................. 3079 | |
| Unused bytes on index pages....................... 8932 27.3% | |
| Unused bytes on primary pages..................... 1278274 10.9% | |
| Unused bytes on overflow pages.................... 13086 1.6% | |
| Unused bytes on all pages......................... 1300292 10.3% | |
| *** Indices of table MESSAGES ************************************************* | |
| Percentage of total database...................... 0.045% | |
| Number of entries................................. 98455 | |
| Bytes of storage consumed......................... 1679360 | |
| Bytes of payload.................................. 1346472 80.2% | |
| Bytes of metadata................................. 300265 17.9% | |
| Average payload per entry......................... 13.68 | |
| Average unused bytes per entry.................... 0.33 | |
| Average metadata per entry........................ 3.05 | |
| Average fanout.................................... 51.00 | |
| Maximum payload per entry......................... 39 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 8 | |
| Primary pages used................................ 402 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 410 | |
| Unused bytes on index pages....................... 20548 62.7% | |
| Unused bytes on primary pages..................... 12075 0.73% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 32623 1.9% | |
| *** Index INDEX_MESSAGES_ON_AUTHOR_USER_ID of table MESSAGES ****************** | |
| Percentage of total database...................... 0.005% | |
| Number of entries................................. 19691 | |
| Bytes of storage consumed......................... 192512 | |
| Bytes of payload.................................. 126955 65.9% | |
| Bytes of metadata................................. 59633 31.0% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 6.45 | |
| Average unused bytes per entry.................... 0.30 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 47.00 | |
| Non-sequential pages.............................. 1 2.2% | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 46 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 47 | |
| Unused bytes on index pages....................... 3476 84.9% | |
| Unused bytes on primary pages..................... 2448 1.3% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 5924 3.1% | |
| *** Index INDEX_MESSAGES_ON_HAT_ID of table MESSAGES ************************** | |
| Percentage of total database...................... 0.004% | |
| Number of entries................................. 19691 | |
| Bytes of storage consumed......................... 163840 | |
| Bytes of payload.................................. 99838 60.9% | |
| Bytes of metadata................................. 59549 36.3% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 5.07 | |
| Average unused bytes per entry.................... 0.23 | |
| Average metadata per entry........................ 3.02 | |
| Average fanout.................................... 40.00 | |
| Non-sequential pages.............................. 1 2.6% | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 39 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 40 | |
| Unused bytes on index pages....................... 3625 88.5% | |
| Unused bytes on primary pages..................... 828 0.52% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4453 2.7% | |
| *** Index INDEX_MESSAGES_ON_TOKEN of table MESSAGES *************************** | |
| Percentage of total database...................... 0.022% | |
| Number of entries................................. 19691 | |
| Bytes of storage consumed......................... 839680 | |
| Bytes of payload.................................. 767843 91.4% | |
| Bytes of metadata................................. 61529 7.3% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 38.99 | |
| Average unused bytes per entry.................... 0.52 | |
| Average metadata per entry........................ 3.12 | |
| Average fanout.................................... 51.00 | |
| Non-sequential pages.............................. 1 0.49% | |
| Maximum payload per entry......................... 39 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 4 | |
| Primary pages used................................ 201 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 205 | |
| Unused bytes on index pages....................... 7137 43.6% | |
| Unused bytes on primary pages..................... 3171 0.39% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 10308 1.2% | |
| *** Index MESSAGES_RECIPIENT_USER_ID_FK of table MESSAGES ********************* | |
| Percentage of total database...................... 0.005% | |
| Number of entries................................. 19691 | |
| Bytes of storage consumed......................... 200704 | |
| Bytes of payload.................................. 135341 67.4% | |
| Bytes of metadata................................. 59657 29.7% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 6.87 | |
| Average unused bytes per entry.................... 0.29 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 49.00 | |
| Non-sequential pages.............................. 1 2.1% | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 48 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 49 | |
| Unused bytes on index pages....................... 3432 83.8% | |
| Unused bytes on primary pages..................... 2274 1.2% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 5706 2.8% | |
| *** Index RANDOM_HASH of table MESSAGES *************************************** | |
| Percentage of total database...................... 0.008% | |
| Number of entries................................. 19691 | |
| Bytes of storage consumed......................... 282624 | |
| Bytes of payload.................................. 216495 76.6% | |
| Bytes of metadata................................. 59897 21.2% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 10.99 | |
| Average unused bytes per entry.................... 0.32 | |
| Average metadata per entry........................ 3.04 | |
| Average fanout.................................... 69.00 | |
| Non-sequential pages.............................. 1 1.5% | |
| Maximum payload per entry......................... 11 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 68 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 69 | |
| Unused bytes on index pages....................... 2878 70.3% | |
| Unused bytes on primary pages..................... 3354 1.2% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 6232 2.2% | |
| *** Table MOD_ACTIVITIES and all its indices ********************************** | |
| Percentage of total database...................... 0.11% | |
| Number of entries................................. 72318 | |
| Bytes of storage consumed......................... 4067328 | |
| Bytes of payload.................................. 3708308 91.2% | |
| Bytes of metadata................................. 287234 7.1% | |
| Average payload per entry......................... 51.28 | |
| Average unused bytes per entry.................... 0.99 | |
| Average metadata per entry........................ 3.97 | |
| Average fanout.................................... 110.00 | |
| Maximum payload per entry......................... 109 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 9 | |
| Primary pages used................................ 984 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 993 | |
| Unused bytes on index pages....................... 15530 42.1% | |
| Unused bytes on primary pages..................... 56256 1.4% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 71786 1.8% | |
| *** Table MOD_ACTIVITIES w/o any indices ************************************** | |
| Percentage of total database...................... 0.065% | |
| Number of entries................................. 24106 | |
| Bytes of storage consumed......................... 2453504 | |
| Bytes of payload.................................. 2266303 92.4% | |
| Bytes of metadata................................. 137878 5.6% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 94.01 | |
| Average unused bytes per entry.................... 2.05 | |
| Average metadata per entry........................ 5.72 | |
| Average fanout.................................... 199.00 | |
| Non-sequential pages.............................. 1 0.17% | |
| Maximum payload per entry......................... 109 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 596 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 599 | |
| Unused bytes on index pages....................... 7304 59.4% | |
| Unused bytes on primary pages..................... 42019 1.7% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 49323 2.0% | |
| *** Indices of table MOD_ACTIVITIES ******************************************* | |
| Percentage of total database...................... 0.043% | |
| Number of entries................................. 48212 | |
| Bytes of storage consumed......................... 1613824 | |
| Bytes of payload.................................. 1442005 89.4% | |
| Bytes of metadata................................. 149356 9.3% | |
| Average payload per entry......................... 29.91 | |
| Average unused bytes per entry.................... 0.47 | |
| Average metadata per entry........................ 3.10 | |
| Average fanout.................................... 65.00 | |
| Maximum payload per entry......................... 43 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 6 | |
| Primary pages used................................ 388 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 394 | |
| Unused bytes on index pages....................... 8226 33.5% | |
| Unused bytes on primary pages..................... 14237 0.90% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 22463 1.4% | |
| *** Index INDEX_MOD_ACTIVITIES_ON_ITEM_TYPE_AND_ITEM_ID of table MOD_ACTIVITIES | |
| Percentage of total database...................... 0.013% | |
| Number of entries................................. 24106 | |
| Bytes of storage consumed......................... 483328 | |
| Bytes of payload.................................. 405575 83.9% | |
| Bytes of metadata................................. 73730 15.3% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 16.82 | |
| Average unused bytes per entry.................... 0.17 | |
| Average metadata per entry........................ 3.06 | |
| Average fanout.................................... 118.00 | |
| Non-sequential pages.............................. 1 0.85% | |
| Maximum payload per entry......................... 18 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 117 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 118 | |
| Unused bytes on index pages....................... 1305 31.9% | |
| Unused bytes on primary pages..................... 2718 0.57% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4023 0.83% | |
| *** Index INDEX_MOD_ACTIVITIES_ON_TOKEN of table MOD_ACTIVITIES *************** | |
| Percentage of total database...................... 0.030% | |
| Number of entries................................. 24106 | |
| Bytes of storage consumed......................... 1130496 | |
| Bytes of payload.................................. 1036430 91.7% | |
| Bytes of metadata................................. 75626 6.7% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 42.99 | |
| Average unused bytes per entry.................... 0.76 | |
| Average metadata per entry........................ 3.14 | |
| Average fanout.................................... 55.00 | |
| Non-sequential pages.............................. 1 0.36% | |
| Maximum payload per entry......................... 43 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 5 | |
| Primary pages used................................ 271 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 276 | |
| Unused bytes on index pages....................... 6921 33.8% | |
| Unused bytes on primary pages..................... 11519 1.0% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 18440 1.6% | |
| *** Table MOD_MAIL_MESSAGES and all its indices ******************************* | |
| Percentage of total database...................... 0.007% | |
| Number of entries................................. 1002 | |
| Bytes of storage consumed......................... 270336 | |
| Bytes of payload.................................. 237947 88.0% | |
| Bytes of metadata................................. 4883 1.8% | |
| Average payload per entry......................... 237.47 | |
| Average unused bytes per entry.................... 27.45 | |
| Average metadata per entry........................ 4.87 | |
| Average fanout.................................... 65.00 | |
| Maximum payload per entry......................... 3426 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 65 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 66 | |
| Unused bytes on index pages....................... 3610 88.1% | |
| Unused bytes on primary pages..................... 23896 9.0% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 27506 10.2% | |
| *** Table MOD_MAIL_MESSAGES w/o any indices *********************************** | |
| Percentage of total database...................... 0.007% | |
| Number of entries................................. 334 | |
| Bytes of storage consumed......................... 262144 | |
| Bytes of payload.................................. 233635 89.1% | |
| Bytes of metadata................................. 2863 1.1% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 699.51 | |
| Average unused bytes per entry.................... 76.78 | |
| Average metadata per entry........................ 8.57 | |
| Average fanout.................................... 63.00 | |
| Non-sequential pages.............................. 1 1.6% | |
| Maximum payload per entry......................... 3426 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 63 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 64 | |
| Unused bytes on index pages....................... 3610 88.1% | |
| Unused bytes on primary pages..................... 22036 8.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 25646 9.8% | |
| *** Indices of table MOD_MAIL_MESSAGES **************************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 668 | |
| Bytes of storage consumed......................... 8192 | |
| Bytes of payload.................................. 4312 52.6% | |
| Bytes of metadata................................. 2020 24.7% | |
| Average payload per entry......................... 6.46 | |
| Average unused bytes per entry.................... 2.78 | |
| Average metadata per entry........................ 3.02 | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 2 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 2 | |
| Unused bytes on primary pages..................... 1860 22.7% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 1860 22.7% | |
| *** Index FK_RAILS_40FA20CAB5 of table MOD_MAIL_MESSAGES ********************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 334 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 2221 54.2% | |
| Bytes of metadata................................. 1010 24.7% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 6.65 | |
| Average unused bytes per entry.................... 2.59 | |
| Average metadata per entry........................ 3.02 | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 865 21.1% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 865 21.1% | |
| *** Index INDEX_MOD_MAIL_MESSAGES_ON_MOD_MAIL_ID of table MOD_MAIL_MESSAGES *** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 334 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 2091 51.0% | |
| Bytes of metadata................................. 1010 24.7% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 6.26 | |
| Average unused bytes per entry.................... 2.98 | |
| Average metadata per entry........................ 3.02 | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 995 24.3% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 995 24.3% | |
| *** Table MOD_MAIL_RECIPIENTS and all its indices ***************************** | |
| Percentage of total database...................... 0.002% | |
| Number of entries................................. 1587 | |
| Bytes of storage consumed......................... 65536 | |
| Bytes of payload.................................. 39528 60.3% | |
| Bytes of metadata................................. 5935 9.1% | |
| Average payload per entry......................... 24.91 | |
| Average unused bytes per entry.................... 12.65 | |
| Average metadata per entry........................ 3.74 | |
| Average fanout.................................... 5.00 | |
| Maximum payload per entry......................... 62 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 13 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 16 | |
| Unused bytes on index pages....................... 12161 99.0% | |
| Unused bytes on primary pages..................... 7912 14.9% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 20073 30.6% | |
| *** Table MOD_MAIL_RECIPIENTS w/o any indices ********************************* | |
| Percentage of total database...................... 0.001% | |
| Number of entries................................. 529 | |
| Bytes of storage consumed......................... 40960 | |
| Bytes of payload.................................. 32556 79.5% | |
| Bytes of metadata................................. 2697 6.6% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 61.54 | |
| Average unused bytes per entry.................... 10.79 | |
| Average metadata per entry........................ 5.10 | |
| Average fanout.................................... 9.00 | |
| Non-sequential pages.............................. 1 11.1% | |
| Maximum payload per entry......................... 62 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 9 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 10 | |
| Unused bytes on index pages....................... 4021 98.2% | |
| Unused bytes on primary pages..................... 1686 4.6% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 5707 13.9% | |
| *** Indices of table MOD_MAIL_RECIPIENTS ************************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 1058 | |
| Bytes of storage consumed......................... 24576 | |
| Bytes of payload.................................. 6972 28.4% | |
| Bytes of metadata................................. 3238 13.2% | |
| Average payload per entry......................... 6.59 | |
| Average unused bytes per entry.................... 13.58 | |
| Average metadata per entry........................ 3.06 | |
| Average fanout.................................... 3.00 | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 2 | |
| Primary pages used................................ 4 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 6 | |
| Unused bytes on index pages....................... 8140 99.37% | |
| Unused bytes on primary pages..................... 6226 38.0% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 14366 58.5% | |
| *** Index FK_RAILS_7A6D5232BE of table MOD_MAIL_RECIPIENTS ******************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 529 | |
| Bytes of storage consumed......................... 12288 | |
| Bytes of payload.................................. 3585 29.2% | |
| Bytes of metadata................................. 1619 13.2% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 6.78 | |
| Average unused bytes per entry.................... 13.39 | |
| Average metadata per entry........................ 3.06 | |
| Average fanout.................................... 3.00 | |
| Non-sequential pages.............................. 1 50.0% | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 2 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 3 | |
| Unused bytes on index pages....................... 4070 99.37% | |
| Unused bytes on primary pages..................... 3014 36.8% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7084 57.6% | |
| *** Index INDEX_MOD_MAIL_RECIPIENTS_ON_MOD_MAIL_ID of table MOD_MAIL_RECIPIENTS | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 529 | |
| Bytes of storage consumed......................... 12288 | |
| Bytes of payload.................................. 3387 27.6% | |
| Bytes of metadata................................. 1619 13.2% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 6.40 | |
| Average unused bytes per entry.................... 13.77 | |
| Average metadata per entry........................ 3.06 | |
| Average fanout.................................... 3.00 | |
| Non-sequential pages.............................. 1 50.0% | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 2 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 3 | |
| Unused bytes on index pages....................... 4070 99.37% | |
| Unused bytes on primary pages..................... 3212 39.2% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7282 59.3% | |
| *** Table MOD_MAIL_REFERENCES and all its indices ***************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 12 | |
| Bytes of storage consumed......................... 12288 | |
| Bytes of payload.................................. 366 3.0% | |
| Bytes of metadata................................. 64 0.52% | |
| Average payload per entry......................... 30.50 | |
| Average unused bytes per entry.................... 988.17 | |
| Average metadata per entry........................ 5.33 | |
| Maximum payload per entry......................... 71 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 3 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 3 | |
| Unused bytes on primary pages..................... 11858 96.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 11858 96.5% | |
| *** Table MOD_MAIL_REFERENCES w/o any indices ********************************* | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 4 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 284 6.9% | |
| Bytes of metadata................................. 24 0.59% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 71.00 | |
| Average unused bytes per entry.................... 947.00 | |
| Average metadata per entry........................ 6.00 | |
| Maximum payload per entry......................... 71 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 3788 92.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3788 92.5% | |
| *** Indices of table MOD_MAIL_REFERENCES ************************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 8 | |
| Bytes of storage consumed......................... 8192 | |
| Bytes of payload.................................. 82 1.0% | |
| Bytes of metadata................................. 40 0.49% | |
| Average payload per entry......................... 10.25 | |
| Average unused bytes per entry.................... 1008.75 | |
| Average metadata per entry........................ 5.00 | |
| Maximum payload per entry......................... 15 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 2 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 2 | |
| Unused bytes on primary pages..................... 8070 98.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8070 98.5% | |
| *** Index INDEX_MOD_MAIL_REFERENCES_ON_MOD_MAIL_ID of table MOD_MAIL_REFERENCES | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 4 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 23 0.56% | |
| Bytes of metadata................................. 20 0.49% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 5.75 | |
| Average unused bytes per entry.................... 1013.25 | |
| Average metadata per entry........................ 5.00 | |
| Maximum payload per entry......................... 6 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 4053 99.0% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4053 99.0% | |
| *** Index INDEX_MOD_MAIL_REFERENCES_ON_REFERENCE of table MOD_MAIL_REFERENCES * | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 4 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 59 1.4% | |
| Bytes of metadata................................. 20 0.49% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 14.75 | |
| Average unused bytes per entry.................... 1004.25 | |
| Average metadata per entry........................ 5.00 | |
| Maximum payload per entry......................... 15 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 4017 98.1% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4017 98.1% | |
| *** Table MOD_MAILS and all its indices *************************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 530 | |
| Bytes of storage consumed......................... 36864 | |
| Bytes of payload.................................. 26648 72.3% | |
| Bytes of metadata................................. 2133 5.8% | |
| Average payload per entry......................... 50.28 | |
| Average unused bytes per entry.................... 15.25 | |
| Average metadata per entry........................ 4.02 | |
| Average fanout.................................... 8.00 | |
| Maximum payload per entry......................... 90 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 8 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 9 | |
| Unused bytes on index pages....................... 4038 98.6% | |
| Unused bytes on primary pages..................... 4045 12.3% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8083 21.9% | |
| *** Table MOD_MAILS w/o any indices ******************************************* | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 265 | |
| Bytes of storage consumed......................... 32768 | |
| Bytes of payload.................................. 23843 72.8% | |
| Bytes of metadata................................. 1330 4.1% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 89.97 | |
| Average unused bytes per entry.................... 28.66 | |
| Average metadata per entry........................ 5.02 | |
| Average fanout.................................... 7.00 | |
| Non-sequential pages.............................. 1 14.3% | |
| Maximum payload per entry......................... 90 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 7 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 8 | |
| Unused bytes on index pages....................... 4038 98.6% | |
| Unused bytes on primary pages..................... 3557 12.4% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7595 23.2% | |
| *** Index INDEX_MOD_MAILS_ON_SHORT_ID of table MOD_MAILS ********************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 265 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 2805 68.5% | |
| Bytes of metadata................................. 803 19.6% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 10.58 | |
| Average unused bytes per entry.................... 1.84 | |
| Average metadata per entry........................ 3.03 | |
| Maximum payload per entry......................... 11 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 488 11.9% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 488 11.9% | |
| *** Table MOD_NOTES and all its indices *************************************** | |
| Percentage of total database...................... 0.26% | |
| Number of entries................................. 45225 | |
| Bytes of storage consumed......................... 9711616 | |
| Bytes of payload.................................. 8377619 86.3% | |
| Bytes of metadata................................. 198428 2.0% | |
| Average payload per entry......................... 185.24 | |
| Average unused bytes per entry.................... 25.11 | |
| Average metadata per entry........................ 4.39 | |
| Average fanout.................................... 182.00 | |
| Maximum payload per entry......................... 47726 | |
| Entries that use overflow......................... 122 0.27% | |
| Index pages used.................................. 12 | |
| Primary pages used................................ 2181 | |
| Overflow pages used............................... 178 | |
| Total pages used.................................. 2371 | |
| Unused bytes on index pages....................... 27629 56.2% | |
| Unused bytes on primary pages..................... 1101814 12.3% | |
| Unused bytes on overflow pages.................... 6350 0.87% | |
| Unused bytes on all pages......................... 1135793 11.7% | |
| *** Table MOD_NOTES w/o any indices ******************************************* | |
| Percentage of total database...................... 0.24% | |
| Number of entries................................. 9045 | |
| Bytes of storage consumed......................... 9003008 | |
| Bytes of payload.................................. 7812040 86.8% | |
| Bytes of metadata................................. 87828 0.98% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 863.69 | |
| Average unused bytes per entry.................... 121.99 | |
| Average metadata per entry........................ 9.71 | |
| Average fanout.................................... 336.00 | |
| Non-sequential pages.............................. 1 0.046% | |
| Maximum payload per entry......................... 47726 | |
| Entries that use overflow......................... 122 1.3% | |
| Index pages used.................................. 6 | |
| Primary pages used................................ 2014 | |
| Overflow pages used............................... 178 | |
| Total pages used.................................. 2198 | |
| Unused bytes on index pages....................... 8427 34.3% | |
| Unused bytes on primary pages..................... 1088587 13.2% | |
| Unused bytes on overflow pages.................... 6350 0.87% | |
| Unused bytes on all pages......................... 1103364 12.3% | |
| *** Indices of table MOD_NOTES ************************************************ | |
| Percentage of total database...................... 0.019% | |
| Number of entries................................. 36180 | |
| Bytes of storage consumed......................... 708608 | |
| Bytes of payload.................................. 565579 79.8% | |
| Bytes of metadata................................. 110600 15.6% | |
| Average payload per entry......................... 15.63 | |
| Average unused bytes per entry.................... 0.90 | |
| Average metadata per entry........................ 3.06 | |
| Average fanout.................................... 28.00 | |
| Maximum payload per entry......................... 39 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 6 | |
| Primary pages used................................ 167 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 173 | |
| Unused bytes on index pages....................... 19202 78.1% | |
| Unused bytes on primary pages..................... 13227 1.9% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 32429 4.6% | |
| *** Index INDEX_MOD_NOTES_ON_ID_AND_USER_ID of table MOD_NOTES **************** | |
| Percentage of total database...................... 0.003% | |
| Number of entries................................. 9045 | |
| Bytes of storage consumed......................... 122880 | |
| Bytes of payload.................................. 90141 73.4% | |
| Bytes of metadata................................. 27491 22.4% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 9.97 | |
| Average unused bytes per entry.................... 0.58 | |
| Average metadata per entry........................ 3.04 | |
| Average fanout.................................... 30.00 | |
| Non-sequential pages.............................. 1 3.4% | |
| Maximum payload per entry......................... 10 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 29 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 30 | |
| Unused bytes on index pages....................... 3608 88.1% | |
| Unused bytes on primary pages..................... 1640 1.4% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 5248 4.3% | |
| *** Index INDEX_MOD_NOTES_ON_TOKEN of table MOD_NOTES ************************* | |
| Percentage of total database...................... 0.010% | |
| Number of entries................................. 9045 | |
| Bytes of storage consumed......................... 393216 | |
| Bytes of payload.................................. 352627 89.7% | |
| Bytes of metadata................................. 28283 7.2% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 38.99 | |
| Average unused bytes per entry.................... 1.36 | |
| Average metadata per entry........................ 3.13 | |
| Average fanout.................................... 32.00 | |
| Non-sequential pages.............................. 1 1.1% | |
| Maximum payload per entry......................... 39 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 93 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 96 | |
| Unused bytes on index pages....................... 8021 65.3% | |
| Unused bytes on primary pages..................... 4285 1.1% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 12306 3.1% | |
| *** Index MOD_NOTES_MODERATOR_USER_ID_FK of table MOD_NOTES ******************* | |
| Percentage of total database...................... 0.003% | |
| Number of entries................................. 9045 | |
| Bytes of storage consumed......................... 94208 | |
| Bytes of payload.................................. 59677 63.3% | |
| Bytes of metadata................................. 27407 29.1% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 6.60 | |
| Average unused bytes per entry.................... 0.79 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 23.00 | |
| Non-sequential pages.............................. 1 4.5% | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 22 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 23 | |
| Unused bytes on index pages....................... 3797 92.7% | |
| Unused bytes on primary pages..................... 3327 3.7% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7124 7.6% | |
| *** Index MOD_NOTES_USER_ID_FK of table MOD_NOTES ***************************** | |
| Percentage of total database...................... 0.003% | |
| Number of entries................................. 9045 | |
| Bytes of storage consumed......................... 98304 | |
| Bytes of payload.................................. 63134 64.2% | |
| Bytes of metadata................................. 27419 27.9% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 6.98 | |
| Average unused bytes per entry.................... 0.86 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 24.00 | |
| Non-sequential pages.............................. 1 4.3% | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 23 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 24 | |
| Unused bytes on index pages....................... 3776 92.2% | |
| Unused bytes on primary pages..................... 3975 4.2% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7751 7.9% | |
| *** Table MODERATIONS and all its indices ************************************* | |
| Percentage of total database...................... 0.15% | |
| Number of entries................................. 162756 | |
| Bytes of storage consumed......................... 5627904 | |
| Bytes of payload.................................. 4856508 86.3% | |
| Bytes of metadata................................. 550919 9.8% | |
| Average payload per entry......................... 29.84 | |
| Average unused bytes per entry.................... 1.36 | |
| Average metadata per entry........................ 3.38 | |
| Average fanout.................................... 89.00 | |
| Maximum payload per entry......................... 65559 | |
| Entries that use overflow......................... 13 0.008% | |
| Index pages used.................................. 15 | |
| Primary pages used................................ 1328 | |
| Overflow pages used............................... 31 | |
| Total pages used.................................. 1374 | |
| Unused bytes on index pages....................... 40766 66.4% | |
| Unused bytes on primary pages..................... 178519 3.3% | |
| Unused bytes on overflow pages.................... 1264 1.00% | |
| Unused bytes on all pages......................... 220549 3.9% | |
| *** Table MODERATIONS w/o any indices ***************************************** | |
| Percentage of total database...................... 0.093% | |
| Number of entries................................. 14796 | |
| Bytes of storage consumed......................... 3497984 | |
| Bytes of payload.................................. 3238938 92.6% | |
| Bytes of metadata................................. 100839 2.9% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 218.91 | |
| Average unused bytes per entry.................... 10.70 | |
| Average metadata per entry........................ 6.82 | |
| Average fanout.................................... 274.00 | |
| Non-sequential pages.............................. 1 0.12% | |
| Maximum payload per entry......................... 65559 | |
| Entries that use overflow......................... 13 0.088% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 820 | |
| Overflow pages used............................... 31 | |
| Total pages used.................................. 854 | |
| Unused bytes on index pages....................... 5701 46.4% | |
| Unused bytes on primary pages..................... 151314 4.5% | |
| Unused bytes on overflow pages.................... 1264 1.00% | |
| Unused bytes on all pages......................... 158279 4.5% | |
| *** Indices of table MODERATIONS ********************************************** | |
| Percentage of total database...................... 0.057% | |
| Number of entries................................. 147960 | |
| Bytes of storage consumed......................... 2129920 | |
| Bytes of payload.................................. 1617570 75.9% | |
| Bytes of metadata................................. 450080 21.1% | |
| Average payload per entry......................... 10.93 | |
| Average unused bytes per entry.................... 0.42 | |
| Average metadata per entry........................ 3.04 | |
| Average fanout.................................... 43.00 | |
| Maximum payload per entry......................... 42 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 12 | |
| Primary pages used................................ 508 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 520 | |
| Unused bytes on index pages....................... 35065 71.3% | |
| Unused bytes on primary pages..................... 27205 1.3% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 62270 2.9% | |
| *** Index INDEX_MODERATIONS_ON_CATEGORY_ID of table MODERATIONS *************** | |
| Percentage of total database...................... 0.003% | |
| Number of entries................................. 14796 | |
| Bytes of storage consumed......................... 122880 | |
| Bytes of payload.................................. 73943 60.2% | |
| Bytes of metadata................................. 44744 36.4% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 5.00 | |
| Average unused bytes per entry.................... 0.28 | |
| Average metadata per entry........................ 3.02 | |
| Average fanout.................................... 30.00 | |
| Non-sequential pages.............................. 1 3.4% | |
| Maximum payload per entry......................... 5 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 29 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 30 | |
| Unused bytes on index pages....................... 3748 91.5% | |
| Unused bytes on primary pages..................... 445 0.37% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4193 3.4% | |
| *** Index INDEX_MODERATIONS_ON_CREATED_AT of table MODERATIONS **************** | |
| Percentage of total database...................... 0.011% | |
| Number of entries................................. 14796 | |
| Bytes of storage consumed......................... 405504 | |
| Bytes of payload.................................. 355410 87.6% | |
| Bytes of metadata................................. 45572 11.2% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 24.02 | |
| Average unused bytes per entry.................... 0.31 | |
| Average metadata per entry........................ 3.08 | |
| Average fanout.................................... 99.00 | |
| Non-sequential pages.............................. 1 1.0% | |
| Maximum payload per entry......................... 31 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 98 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 99 | |
| Unused bytes on index pages....................... 1077 26.3% | |
| Unused bytes on primary pages..................... 3445 0.86% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4522 1.1% | |
| *** Index INDEX_MODERATIONS_ON_DOMAIN_ID of table MODERATIONS ***************** | |
| Percentage of total database...................... 0.003% | |
| Number of entries................................. 14796 | |
| Bytes of storage consumed......................... 126976 | |
| Bytes of payload.................................. 74593 58.7% | |
| Bytes of metadata................................. 44756 35.2% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 5.04 | |
| Average unused bytes per entry.................... 0.52 | |
| Average metadata per entry........................ 3.02 | |
| Average fanout.................................... 31.00 | |
| Non-sequential pages.............................. 1 3.3% | |
| Maximum payload per entry......................... 8 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 30 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 31 | |
| Unused bytes on index pages....................... 3733 91.1% | |
| Unused bytes on primary pages..................... 3894 3.2% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7627 6.0% | |
| *** Index INDEX_MODERATIONS_ON_ORIGIN_ID of table MODERATIONS ***************** | |
| Percentage of total database...................... 0.003% | |
| Number of entries................................. 14796 | |
| Bytes of storage consumed......................... 122880 | |
| Bytes of payload.................................. 74001 60.2% | |
| Bytes of metadata................................. 44744 36.4% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 5.00 | |
| Average unused bytes per entry.................... 0.28 | |
| Average metadata per entry........................ 3.02 | |
| Average fanout.................................... 30.00 | |
| Non-sequential pages.............................. 1 3.4% | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 29 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 30 | |
| Unused bytes on index pages....................... 3748 91.5% | |
| Unused bytes on primary pages..................... 387 0.33% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4135 3.4% | |
| *** Index INDEX_MODERATIONS_ON_TOKEN of table MODERATIONS ********************* | |
| Percentage of total database...................... 0.018% | |
| Number of entries................................. 14796 | |
| Bytes of storage consumed......................... 679936 | |
| Bytes of payload.................................. 621395 91.4% | |
| Bytes of metadata................................. 46376 6.8% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 42.00 | |
| Average unused bytes per entry.................... 0.82 | |
| Average metadata per entry........................ 3.13 | |
| Average fanout.................................... 55.00 | |
| Non-sequential pages.............................. 1 0.61% | |
| Maximum payload per entry......................... 42 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 163 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 166 | |
| Unused bytes on index pages....................... 4314 35.1% | |
| Unused bytes on primary pages..................... 7851 1.2% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 12165 1.8% | |
| *** Index INDEX_MODERATIONS_ON_USER_ID of table MODERATIONS ******************* | |
| Percentage of total database...................... 0.003% | |
| Number of entries................................. 14796 | |
| Bytes of storage consumed......................... 126976 | |
| Bytes of payload.................................. 78102 61.5% | |
| Bytes of metadata................................. 44756 35.2% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 5.28 | |
| Average unused bytes per entry.................... 0.28 | |
| Average metadata per entry........................ 3.02 | |
| Average fanout.................................... 31.00 | |
| Non-sequential pages.............................. 1 3.3% | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 30 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 31 | |
| Unused bytes on index pages....................... 3726 91.0% | |
| Unused bytes on primary pages..................... 392 0.32% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4118 3.2% | |
| *** Index MODERATIONS_COMMENT_ID_FK of table MODERATIONS ********************** | |
| Percentage of total database...................... 0.003% | |
| Number of entries................................. 14796 | |
| Bytes of storage consumed......................... 131072 | |
| Bytes of payload.................................. 79938 61.0% | |
| Bytes of metadata................................. 44768 34.2% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 5.40 | |
| Average unused bytes per entry.................... 0.43 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 32.00 | |
| Non-sequential pages.............................. 1 3.2% | |
| Maximum payload per entry......................... 8 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 31 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 32 | |
| Unused bytes on index pages....................... 3706 90.5% | |
| Unused bytes on primary pages..................... 2660 2.1% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 6366 4.9% | |
| *** Index MODERATIONS_MODERATOR_USER_ID_FK of table MODERATIONS *************** | |
| Percentage of total database...................... 0.004% | |
| Number of entries................................. 14796 | |
| Bytes of storage consumed......................... 135168 | |
| Bytes of payload.................................. 82921 61.3% | |
| Bytes of metadata................................. 44780 33.1% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 5.60 | |
| Average unused bytes per entry.................... 0.50 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 33.00 | |
| Non-sequential pages.............................. 1 3.1% | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 32 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 33 | |
| Unused bytes on index pages....................... 3693 90.2% | |
| Unused bytes on primary pages..................... 3774 2.9% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7467 5.5% | |
| *** Index MODERATIONS_STORY_ID_FK of table MODERATIONS ************************ | |
| Percentage of total database...................... 0.004% | |
| Number of entries................................. 14796 | |
| Bytes of storage consumed......................... 155648 | |
| Bytes of payload.................................. 103282 66.4% | |
| Bytes of metadata................................. 44840 28.8% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 6.98 | |
| Average unused bytes per entry.................... 0.51 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 38.00 | |
| Non-sequential pages.............................. 1 2.7% | |
| Maximum payload per entry......................... 8 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 37 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 38 | |
| Unused bytes on index pages....................... 3572 87.2% | |
| Unused bytes on primary pages..................... 3954 2.6% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7526 4.8% | |
| *** Index MODERATIONS_TAG_ID_FK of table MODERATIONS ************************** | |
| Percentage of total database...................... 0.003% | |
| Number of entries................................. 14796 | |
| Bytes of storage consumed......................... 122880 | |
| Bytes of payload.................................. 73985 60.2% | |
| Bytes of metadata................................. 44744 36.4% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 5.00 | |
| Average unused bytes per entry.................... 0.28 | |
| Average metadata per entry........................ 3.02 | |
| Average fanout.................................... 30.00 | |
| Non-sequential pages.............................. 1 3.4% | |
| Maximum payload per entry......................... 6 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 29 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 30 | |
| Unused bytes on index pages....................... 3748 91.5% | |
| Unused bytes on primary pages..................... 403 0.34% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4151 3.4% | |
| *** Table NOTIFICATIONS and all its indices *********************************** | |
| Percentage of total database...................... 3.3% | |
| Number of entries................................. 2063548 | |
| Bytes of storage consumed......................... 122769408 | |
| Bytes of payload.................................. 113206548 92.2% | |
| Bytes of metadata................................. 8686387 7.1% | |
| Average payload per entry......................... 54.86 | |
| Average unused bytes per entry.................... 0.42 | |
| Average metadata per entry........................ 4.21 | |
| Average fanout.................................... 182.00 | |
| Maximum payload per entry......................... 144 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 164 | |
| Primary pages used................................ 29809 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 29973 | |
| Unused bytes on index pages....................... 55929 8.3% | |
| Unused bytes on primary pages..................... 820544 0.67% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 876473 0.71% | |
| *** Table NOTIFICATIONS w/o any indices *************************************** | |
| Percentage of total database...................... 2.0% | |
| Number of entries................................. 515887 | |
| Bytes of storage consumed......................... 75649024 | |
| Bytes of payload.................................. 71083016 94.0% | |
| Bytes of metadata................................. 3905368 5.2% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 137.79 | |
| Average unused bytes per entry.................... 1.28 | |
| Average metadata per entry........................ 7.57 | |
| Average fanout.................................... 392.00 | |
| Non-sequential pages.............................. 3 0.016% | |
| Maximum payload per entry......................... 144 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 47 | |
| Primary pages used................................ 18422 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 18469 | |
| Unused bytes on index pages....................... 26748 13.9% | |
| Unused bytes on primary pages..................... 633892 0.84% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 660640 0.87% | |
| *** Indices of table NOTIFICATIONS ******************************************** | |
| Percentage of total database...................... 1.3% | |
| Number of entries................................. 1547661 | |
| Bytes of storage consumed......................... 47120384 | |
| Bytes of payload.................................. 42123532 89.4% | |
| Bytes of metadata................................. 4781019 10.1% | |
| Average payload per entry......................... 27.22 | |
| Average unused bytes per entry.................... 0.14 | |
| Average metadata per entry........................ 3.09 | |
| Average fanout.................................... 98.00 | |
| Maximum payload per entry......................... 45 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 117 | |
| Primary pages used................................ 11387 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 11504 | |
| Unused bytes on index pages....................... 29181 6.1% | |
| Unused bytes on primary pages..................... 186652 0.40% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 215833 0.46% | |
| *** Index IDX_ON_USER_ID_NOTIFIABLE_TYPE_NOTIFIABLE_ID_FFAC34041E of table NOTIFICATIONS | |
| Percentage of total database...................... 0.32% | |
| Number of entries................................. 515887 | |
| Bytes of storage consumed......................... 11939840 | |
| Bytes of payload.................................. 10239701 85.8% | |
| Bytes of metadata................................. 1582637 13.3% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 19.85 | |
| Average unused bytes per entry.................... 0.23 | |
| Average metadata per entry........................ 3.07 | |
| Average fanout.................................... 121.00 | |
| Non-sequential pages.............................. 15 0.51% | |
| Maximum payload per entry......................... 26 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 24 | |
| Primary pages used................................ 2891 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 2915 | |
| Unused bytes on index pages....................... 20371 20.7% | |
| Unused bytes on primary pages..................... 97131 0.82% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 117502 0.98% | |
| *** Index INDEX_NOTIFICATIONS_ON_NOTIFIABLE of table NOTIFICATIONS ************ | |
| Percentage of total database...................... 0.27% | |
| Number of entries................................. 515887 | |
| Bytes of storage consumed......................... 10309632 | |
| Bytes of payload.................................. 8701811 84.4% | |
| Bytes of metadata................................. 1577861 15.3% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 16.87 | |
| Average unused bytes per entry.................... 0.06 | |
| Average metadata per entry........................ 3.06 | |
| Average fanout.................................... 157.00 | |
| Non-sequential pages.............................. 2 0.079% | |
| Maximum payload per entry......................... 23 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 16 | |
| Primary pages used................................ 2501 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 2517 | |
| Unused bytes on index pages....................... 5653 8.6% | |
| Unused bytes on primary pages..................... 24307 0.24% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 29960 0.29% | |
| *** Index INDEX_NOTIFICATIONS_ON_TOKEN of table NOTIFICATIONS ***************** | |
| Percentage of total database...................... 0.66% | |
| Number of entries................................. 515887 | |
| Bytes of storage consumed......................... 24870912 | |
| Bytes of payload.................................. 23182020 93.2% | |
| Bytes of metadata................................. 1620521 6.5% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 44.94 | |
| Average unused bytes per entry.................... 0.13 | |
| Average metadata per entry........................ 3.14 | |
| Average fanout.................................... 78.00 | |
| Non-sequential pages.............................. 1 0.016% | |
| Maximum payload per entry......................... 45 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 77 | |
| Primary pages used................................ 5995 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 6072 | |
| Unused bytes on index pages....................... 3157 1.0% | |
| Unused bytes on primary pages..................... 65214 0.27% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 68371 0.27% | |
| *** Table ORIGINS and all its indices ***************************************** | |
| Percentage of total database...................... 0.047% | |
| Number of entries................................. 40850 | |
| Bytes of storage consumed......................... 1765376 | |
| Bytes of payload.................................. 1584740 89.8% | |
| Bytes of metadata................................. 145155 8.2% | |
| Average payload per entry......................... 38.79 | |
| Average unused bytes per entry.................... 0.87 | |
| Average metadata per entry........................ 3.55 | |
| Average fanout.................................... 86.00 | |
| Maximum payload per entry......................... 252 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 5 | |
| Primary pages used................................ 426 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 431 | |
| Unused bytes on index pages....................... 12502 61.0% | |
| Unused bytes on primary pages..................... 22979 1.3% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 35481 2.0% | |
| *** Table ORIGINS w/o any indices ********************************************* | |
| Percentage of total database...................... 0.027% | |
| Number of entries................................. 8170 | |
| Bytes of storage consumed......................... 1032192 | |
| Bytes of payload.................................. 970113 94.0% | |
| Bytes of metadata................................. 44983 4.4% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 118.74 | |
| Average unused bytes per entry.................... 2.09 | |
| Average metadata per entry........................ 5.51 | |
| Average fanout.................................... 251.00 | |
| Non-sequential pages.............................. 1 0.40% | |
| Maximum payload per entry......................... 252 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 251 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 252 | |
| Unused bytes on index pages....................... 2087 51.0% | |
| Unused bytes on primary pages..................... 15009 1.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 17096 1.7% | |
| *** Indices of table ORIGINS ************************************************** | |
| Percentage of total database...................... 0.019% | |
| Number of entries................................. 32680 | |
| Bytes of storage consumed......................... 733184 | |
| Bytes of payload.................................. 614627 83.8% | |
| Bytes of metadata................................. 100172 13.7% | |
| Average payload per entry......................... 18.81 | |
| Average unused bytes per entry.................... 0.56 | |
| Average metadata per entry........................ 3.07 | |
| Average fanout.................................... 44.00 | |
| Maximum payload per entry......................... 87 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 4 | |
| Primary pages used................................ 175 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 179 | |
| Unused bytes on index pages....................... 10415 63.6% | |
| Unused bytes on primary pages..................... 7970 1.1% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 18385 2.5% | |
| *** Index INDEX_ORIGINS_ON_BANNED_BY_USER_ID of table ORIGINS ***************** | |
| Percentage of total database...................... 0.002% | |
| Number of entries................................. 8170 | |
| Bytes of storage consumed......................... 69632 | |
| Bytes of payload.................................. 40751 58.5% | |
| Bytes of metadata................................. 24710 35.5% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 4.99 | |
| Average unused bytes per entry.................... 0.51 | |
| Average metadata per entry........................ 3.02 | |
| Average fanout.................................... 17.00 | |
| Non-sequential pages.............................. 1 6.2% | |
| Maximum payload per entry......................... 6 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 16 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 17 | |
| Unused bytes on index pages....................... 3904 95.3% | |
| Unused bytes on primary pages..................... 267 0.41% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4171 6.0% | |
| *** Index INDEX_ORIGINS_ON_DOMAIN_ID of table ORIGINS ************************* | |
| Percentage of total database...................... 0.002% | |
| Number of entries................................. 8170 | |
| Bytes of storage consumed......................... 86016 | |
| Bytes of payload.................................. 57062 66.3% | |
| Bytes of metadata................................. 24758 28.8% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 6.98 | |
| Average unused bytes per entry.................... 0.51 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 21.00 | |
| Non-sequential pages.............................. 1 5.0% | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 20 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 21 | |
| Unused bytes on index pages....................... 3818 93.2% | |
| Unused bytes on primary pages..................... 378 0.46% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4196 4.9% | |
| *** Index INDEX_ORIGINS_ON_IDENTIFIER of table ORIGINS ************************ | |
| Percentage of total database...................... 0.006% | |
| Number of entries................................. 8170 | |
| Bytes of storage consumed......................... 237568 | |
| Bytes of payload.................................. 206482 86.9% | |
| Bytes of metadata................................. 25202 10.6% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 25.27 | |
| Average unused bytes per entry.................... 0.72 | |
| Average metadata per entry........................ 3.08 | |
| Average fanout.................................... 58.00 | |
| Non-sequential pages.............................. 1 1.8% | |
| Maximum payload per entry......................... 87 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 57 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 58 | |
| Unused bytes on index pages....................... 2253 55.0% | |
| Unused bytes on primary pages..................... 3631 1.6% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 5884 2.5% | |
| *** Index INDEX_ORIGINS_ON_TOKEN of table ORIGINS ***************************** | |
| Percentage of total database...................... 0.009% | |
| Number of entries................................. 8170 | |
| Bytes of storage consumed......................... 339968 | |
| Bytes of payload.................................. 310332 91.3% | |
| Bytes of metadata................................. 25502 7.5% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 37.98 | |
| Average unused bytes per entry.................... 0.51 | |
| Average metadata per entry........................ 3.12 | |
| Average fanout.................................... 83.00 | |
| Non-sequential pages.............................. 1 1.2% | |
| Maximum payload per entry......................... 38 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 82 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 83 | |
| Unused bytes on index pages....................... 440 10.7% | |
| Unused bytes on primary pages..................... 3694 1.1% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4134 1.2% | |
| *** Table READ_RIBBONS and all its indices ************************************ | |
| Percentage of total database...................... 5.2% | |
| Number of entries................................. 7075755 | |
| Bytes of storage consumed......................... 196857856 | |
| Bytes of payload.................................. 162796525 82.7% | |
| Bytes of metadata................................. 31438491 16.0% | |
| Average payload per entry......................... 23.01 | |
| Average unused bytes per entry.................... 0.37 | |
| Average metadata per entry........................ 4.44 | |
| Average fanout.................................... 298.00 | |
| Maximum payload per entry......................... 64 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 161 | |
| Primary pages used................................ 47900 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 48061 | |
| Unused bytes on index pages....................... 85385 12.9% | |
| Unused bytes on primary pages..................... 2537455 1.3% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 2622840 1.3% | |
| *** Table READ_RIBBONS w/o any indices **************************************** | |
| Percentage of total database...................... 3.6% | |
| Number of entries................................. 2358585 | |
| Bytes of storage consumed......................... 137043968 | |
| Bytes of payload.................................. 118508280 86.5% | |
| Bytes of metadata................................. 17111753 12.5% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 50.25 | |
| Average unused bytes per entry.................... 0.60 | |
| Average metadata per entry........................ 7.26 | |
| Average fanout.................................... 355.00 | |
| Non-sequential pages.............................. 9 0.027% | |
| Maximum payload per entry......................... 64 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 94 | |
| Primary pages used................................ 33364 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 33458 | |
| Unused bytes on index pages....................... 50266 13.1% | |
| Unused bytes on primary pages..................... 1373669 1.0% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 1423935 1.0% | |
| *** Indices of table READ_RIBBONS ********************************************* | |
| Percentage of total database...................... 1.6% | |
| Number of entries................................. 4717170 | |
| Bytes of storage consumed......................... 59813888 | |
| Bytes of payload.................................. 44288245 74.0% | |
| Bytes of metadata................................. 14326738 24.0% | |
| Average payload per entry......................... 9.39 | |
| Average unused bytes per entry.................... 0.25 | |
| Average metadata per entry........................ 3.04 | |
| Average fanout.................................... 217.00 | |
| Maximum payload per entry......................... 10 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 67 | |
| Primary pages used................................ 14536 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 14603 | |
| Unused bytes on index pages....................... 35119 12.8% | |
| Unused bytes on primary pages..................... 1163786 2.0% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 1198905 2.0% | |
| *** Index INDEX_READ_RIBBONS_ON_STORY_ID of table READ_RIBBONS **************** | |
| Percentage of total database...................... 0.81% | |
| Number of entries................................. 2358585 | |
| Bytes of storage consumed......................... 30658560 | |
| Bytes of payload.................................. 23327493 76.1% | |
| Bytes of metadata................................. 7165571 23.4% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 9.89 | |
| Average unused bytes per entry.................... 0.07 | |
| Average metadata per entry........................ 3.04 | |
| Average fanout.................................... 220.00 | |
| Non-sequential pages.............................. 24 0.32% | |
| Maximum payload per entry......................... 10 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 34 | |
| Primary pages used................................ 7451 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 7485 | |
| Unused bytes on index pages....................... 12971 9.3% | |
| Unused bytes on primary pages..................... 152525 0.50% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 165496 0.54% | |
| *** Index INDEX_READ_RIBBONS_ON_USER_ID of table READ_RIBBONS ***************** | |
| Percentage of total database...................... 0.77% | |
| Number of entries................................. 2358585 | |
| Bytes of storage consumed......................... 29155328 | |
| Bytes of payload.................................. 20960752 71.9% | |
| Bytes of metadata................................. 7161167 24.6% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 8.89 | |
| Average unused bytes per entry.................... 0.44 | |
| Average metadata per entry........................ 3.04 | |
| Average fanout.................................... 215.00 | |
| Non-sequential pages.............................. 110 1.5% | |
| Maximum payload per entry......................... 9 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 33 | |
| Primary pages used................................ 7085 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 7118 | |
| Unused bytes on index pages....................... 22148 16.4% | |
| Unused bytes on primary pages..................... 1011261 3.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 1033409 3.5% | |
| *** Table SAVED_STORIES and all its indices *********************************** | |
| Percentage of total database...................... 1.0% | |
| Number of entries................................. 923616 | |
| Bytes of storage consumed......................... 38993920 | |
| Bytes of payload.................................. 34787970 89.2% | |
| Bytes of metadata................................. 3589236 9.2% | |
| Average payload per entry......................... 37.66 | |
| Average unused bytes per entry.................... 0.67 | |
| Average metadata per entry........................ 3.89 | |
| Average fanout.................................... 169.00 | |
| Maximum payload per entry......................... 101 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 56 | |
| Primary pages used................................ 9464 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 9520 | |
| Unused bytes on index pages....................... 25246 11.0% | |
| Unused bytes on primary pages..................... 591468 1.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 616714 1.6% | |
| *** Table SAVED_STORIES w/o any indices *************************************** | |
| Percentage of total database...................... 0.58% | |
| Number of entries................................. 230904 | |
| Bytes of storage consumed......................... 22028288 | |
| Bytes of payload.................................. 20100630 91.2% | |
| Bytes of metadata................................. 1461408 6.6% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 87.05 | |
| Average unused bytes per entry.................... 2.02 | |
| Average metadata per entry........................ 6.33 | |
| Average fanout.................................... 384.00 | |
| Non-sequential pages.............................. 1 0.019% | |
| Maximum payload per entry......................... 101 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 14 | |
| Primary pages used................................ 5364 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 5378 | |
| Unused bytes on index pages....................... 9250 16.1% | |
| Unused bytes on primary pages..................... 457000 2.1% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 466250 2.1% | |
| *** Indices of table SAVED_STORIES ******************************************** | |
| Percentage of total database...................... 0.45% | |
| Number of entries................................. 692712 | |
| Bytes of storage consumed......................... 16965632 | |
| Bytes of payload.................................. 14687340 86.6% | |
| Bytes of metadata................................. 2127828 12.5% | |
| Average payload per entry......................... 21.20 | |
| Average unused bytes per entry.................... 0.22 | |
| Average metadata per entry........................ 3.07 | |
| Average fanout.................................... 98.00 | |
| Maximum payload per entry......................... 43 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 42 | |
| Primary pages used................................ 4100 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 4142 | |
| Unused bytes on index pages....................... 15996 9.3% | |
| Unused bytes on primary pages..................... 134468 0.80% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 150464 0.89% | |
| *** Index INDEX_SAVED_STORIES_ON_TOKEN of table SAVED_STORIES ***************** | |
| Percentage of total database...................... 0.29% | |
| Number of entries................................. 230904 | |
| Bytes of storage consumed......................... 10735616 | |
| Bytes of payload.................................. 9900031 92.2% | |
| Bytes of metadata................................. 724160 6.7% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 42.88 | |
| Average unused bytes per entry.................... 0.48 | |
| Average metadata per entry........................ 3.14 | |
| Average fanout.................................... 79.00 | |
| Non-sequential pages.............................. 1 0.038% | |
| Maximum payload per entry......................... 43 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 33 | |
| Primary pages used................................ 2588 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 2621 | |
| Unused bytes on index pages....................... 5738 4.2% | |
| Unused bytes on primary pages..................... 105687 1.00% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 111425 1.0% | |
| *** Index INDEX_SAVED_STORIES_ON_USER_ID_AND_STORY_ID of table SAVED_STORIES ** | |
| Percentage of total database...................... 0.092% | |
| Number of entries................................. 230904 | |
| Bytes of storage consumed......................... 3469312 | |
| Bytes of payload.................................. 2739653 79.0% | |
| Bytes of metadata................................. 702872 20.3% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 11.86 | |
| Average unused bytes per entry.................... 0.12 | |
| Average metadata per entry........................ 3.04 | |
| Average fanout.................................... 169.00 | |
| Non-sequential pages.............................. 4 0.47% | |
| Maximum payload per entry......................... 12 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 5 | |
| Primary pages used................................ 842 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 847 | |
| Unused bytes on index pages....................... 4543 22.2% | |
| Unused bytes on primary pages..................... 22244 0.64% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 26787 0.77% | |
| *** Index SAVED_STORIES_STORY_ID_FK of table SAVED_STORIES ******************** | |
| Percentage of total database...................... 0.073% | |
| Number of entries................................. 230904 | |
| Bytes of storage consumed......................... 2760704 | |
| Bytes of payload.................................. 2047656 74.2% | |
| Bytes of metadata................................. 700796 25.4% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 8.87 | |
| Average unused bytes per entry.................... 0.05 | |
| Average metadata per entry........................ 3.04 | |
| Average fanout.................................... 168.00 | |
| Non-sequential pages.............................. 1 0.15% | |
| Maximum payload per entry......................... 9 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 4 | |
| Primary pages used................................ 670 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 674 | |
| Unused bytes on index pages....................... 5715 34.9% | |
| Unused bytes on primary pages..................... 6537 0.24% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 12252 0.44% | |
| *** Table SCHEMA_MIGRATIONS and all its indices ******************************* | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 30 | |
| Bytes of storage consumed......................... 8192 | |
| Bytes of payload.................................. 509 6.2% | |
| Bytes of metadata................................. 121 1.5% | |
| Average payload per entry......................... 16.97 | |
| Average unused bytes per entry.................... 252.07 | |
| Average metadata per entry........................ 4.03 | |
| Maximum payload per entry......................... 18 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 2 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 2 | |
| Unused bytes on primary pages..................... 7562 92.3% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7562 92.3% | |
| *** Table SCHEMA_MIGRATIONS w/o any indices *********************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 15 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 240 5.9% | |
| Bytes of metadata................................. 68 1.7% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 16.00 | |
| Average unused bytes per entry.................... 252.53 | |
| Average metadata per entry........................ 4.53 | |
| Maximum payload per entry......................... 16 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 3788 92.5% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3788 92.5% | |
| *** Index SQLITE_AUTOINDEX_SCHEMA_MIGRATIONS_1 of table SCHEMA_MIGRATIONS ***** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 15 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 269 6.6% | |
| Bytes of metadata................................. 53 1.3% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 17.93 | |
| Average unused bytes per entry.................... 251.60 | |
| Average metadata per entry........................ 3.53 | |
| Maximum payload per entry......................... 18 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 3774 92.1% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3774 92.1% | |
| *** Table SQLITE_SCHEMA ******************************************************* | |
| Percentage of total database...................... 0.001% | |
| Number of entries................................. 175 | |
| Bytes of storage consumed......................... 45056 | |
| Bytes of payload.................................. 36360 80.7% | |
| Bytes of metadata................................. 1098 2.4% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 207.77 | |
| Average unused bytes per entry.................... 43.42 | |
| Average metadata per entry........................ 6.27 | |
| Average fanout.................................... 10.00 | |
| Non-sequential pages.............................. 10 100.0% | |
| Maximum payload per entry......................... 1389 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 10 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 11 | |
| Unused bytes on index pages....................... 3920 95.7% | |
| Unused bytes on primary pages..................... 3678 9.0% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7598 16.9% | |
| *** Table SQLITE_SEQUENCE ***************************************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 37 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 647 15.8% | |
| Bytes of metadata................................. 156 3.8% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 17.49 | |
| Average unused bytes per entry.................... 89.00 | |
| Average metadata per entry........................ 4.22 | |
| Maximum payload per entry......................... 34 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 3293 80.4% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3293 80.4% | |
| *** Table STORIES and all its indices ***************************************** | |
| Percentage of total database...................... 2.7% | |
| Number of entries................................. 1920405 | |
| Bytes of storage consumed......................... 100810752 | |
| Bytes of payload.................................. 89254098 88.5% | |
| Bytes of metadata................................. 6617794 6.6% | |
| Average payload per entry......................... 46.48 | |
| Average unused bytes per entry.................... 2.57 | |
| Average metadata per entry........................ 3.45 | |
| Average fanout.................................... 138.00 | |
| Maximum payload per entry......................... 90612 | |
| Entries that use overflow......................... 366 0.019% | |
| Index pages used.................................. 172 | |
| Primary pages used................................ 23719 | |
| Overflow pages used............................... 721 | |
| Total pages used.................................. 24612 | |
| Unused bytes on index pages....................... 112358 15.9% | |
| Unused bytes on primary pages..................... 4795976 4.9% | |
| Unused bytes on overflow pages.................... 31946 1.1% | |
| Unused bytes on all pages......................... 4940280 4.9% | |
| *** Table STORIES w/o any indices ********************************************* | |
| Percentage of total database...................... 1.5% | |
| Number of entries................................. 128027 | |
| Bytes of storage consumed......................... 58167296 | |
| Bytes of payload.................................. 52587868 90.4% | |
| Bytes of metadata................................. 1112829 1.9% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 410.76 | |
| Average unused bytes per entry.................... 34.90 | |
| Average metadata per entry........................ 8.69 | |
| Average fanout.................................... 396.00 | |
| Non-sequential pages.............................. 1 0.007% | |
| Maximum payload per entry......................... 90612 | |
| Entries that use overflow......................... 366 0.29% | |
| Index pages used.................................. 34 | |
| Primary pages used................................ 13446 | |
| Overflow pages used............................... 721 | |
| Total pages used.................................. 14201 | |
| Unused bytes on index pages....................... 19488 14.0% | |
| Unused bytes on primary pages..................... 4416585 8.0% | |
| Unused bytes on overflow pages.................... 31946 1.1% | |
| Unused bytes on all pages......................... 4468019 7.7% | |
| *** Indices of table STORIES ************************************************** | |
| Percentage of total database...................... 1.1% | |
| Number of entries................................. 1792378 | |
| Bytes of storage consumed......................... 42643456 | |
| Bytes of payload.................................. 36666230 86.0% | |
| Bytes of metadata................................. 5504965 12.9% | |
| Average payload per entry......................... 20.46 | |
| Average unused bytes per entry.................... 0.26 | |
| Average metadata per entry........................ 3.07 | |
| Average fanout.................................... 75.00 | |
| Maximum payload per entry......................... 257 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 138 | |
| Primary pages used................................ 10273 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 10411 | |
| Unused bytes on index pages....................... 92870 16.4% | |
| Unused bytes on primary pages..................... 379391 0.90% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 472261 1.1% | |
| *** Index HOTNESS_IDX of table STORIES **************************************** | |
| Percentage of total database...................... 0.058% | |
| Number of entries................................. 128027 | |
| Bytes of storage consumed......................... 2166784 | |
| Bytes of payload.................................. 1759487 81.2% | |
| Bytes of metadata................................. 390425 18.0% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 13.74 | |
| Average unused bytes per entry.................... 0.13 | |
| Average metadata per entry........................ 3.05 | |
| Average fanout.................................... 132.00 | |
| Non-sequential pages.............................. 2 0.38% | |
| Maximum payload per entry......................... 14 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 4 | |
| Primary pages used................................ 525 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 529 | |
| Unused bytes on index pages....................... 5461 33.3% | |
| Unused bytes on primary pages..................... 11411 0.53% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 16872 0.78% | |
| *** Index INDEX_STORIES_ON_CREATED_AT of table STORIES ************************ | |
| Percentage of total database...................... 0.095% | |
| Number of entries................................. 128027 | |
| Bytes of storage consumed......................... 3571712 | |
| Bytes of payload.................................. 3169058 88.7% | |
| Bytes of metadata................................. 394541 11.0% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 24.75 | |
| Average unused bytes per entry.................... 0.06 | |
| Average metadata per entry........................ 3.08 | |
| Average fanout.................................... 109.00 | |
| Non-sequential pages.............................. 1 0.11% | |
| Maximum payload per entry......................... 32 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 8 | |
| Primary pages used................................ 864 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 872 | |
| Unused bytes on index pages....................... 5264 16.1% | |
| Unused bytes on primary pages..................... 2849 0.081% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8113 0.23% | |
| *** Index INDEX_STORIES_ON_DOMAIN_ID of table STORIES ************************* | |
| Percentage of total database...................... 0.037% | |
| Number of entries................................. 128027 | |
| Bytes of storage consumed......................... 1392640 | |
| Bytes of payload.................................. 987016 70.9% | |
| Bytes of metadata................................. 388157 27.9% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 7.71 | |
| Average unused bytes per entry.................... 0.14 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 113.00 | |
| Non-sequential pages.............................. 3 0.88% | |
| Maximum payload per entry......................... 9 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 337 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 340 | |
| Unused bytes on index pages....................... 7296 59.4% | |
| Unused bytes on primary pages..................... 10171 0.74% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 17467 1.3% | |
| *** Index INDEX_STORIES_ON_ID_AND_IS_DELETED of table STORIES ***************** | |
| Percentage of total database...................... 0.043% | |
| Number of entries................................. 128027 | |
| Bytes of storage consumed......................... 1613824 | |
| Bytes of payload.................................. 1214488 75.3% | |
| Bytes of metadata................................. 388805 24.1% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 9.49 | |
| Average unused bytes per entry.................... 0.08 | |
| Average metadata per entry........................ 3.04 | |
| Average fanout.................................... 131.00 | |
| Non-sequential pages.............................. 1 0.25% | |
| Maximum payload per entry......................... 10 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 391 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 394 | |
| Unused bytes on index pages....................... 5798 47.2% | |
| Unused bytes on primary pages..................... 4733 0.30% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 10531 0.65% | |
| *** Index INDEX_STORIES_ON_LAST_COMMENT_AT of table STORIES ******************* | |
| Percentage of total database...................... 0.069% | |
| Number of entries................................. 128027 | |
| Bytes of storage consumed......................... 2600960 | |
| Bytes of payload.................................. 2187740 84.1% | |
| Bytes of metadata................................. 391697 15.1% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 17.09 | |
| Average unused bytes per entry.................... 0.17 | |
| Average metadata per entry........................ 3.06 | |
| Average fanout.................................... 90.00 | |
| Non-sequential pages.............................. 2 0.32% | |
| Maximum payload per entry......................... 32 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 7 | |
| Primary pages used................................ 628 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 635 | |
| Unused bytes on index pages....................... 10227 35.7% | |
| Unused bytes on primary pages..................... 11296 0.44% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 21523 0.83% | |
| *** Index INDEX_STORIES_ON_MASTODON_ID of table STORIES *********************** | |
| Percentage of total database...................... 0.041% | |
| Number of entries................................. 128027 | |
| Bytes of storage consumed......................... 1552384 | |
| Bytes of payload.................................. 1151483 74.2% | |
| Bytes of metadata................................. 388625 25.0% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 8.99 | |
| Average unused bytes per entry.................... 0.10 | |
| Average metadata per entry........................ 3.04 | |
| Average fanout.................................... 126.00 | |
| Non-sequential pages.............................. 2 0.53% | |
| Maximum payload per entry......................... 24 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 376 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 379 | |
| Unused bytes on index pages....................... 4702 38.3% | |
| Unused bytes on primary pages..................... 7574 0.49% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 12276 0.79% | |
| *** Index INDEX_STORIES_ON_MERGED_STORY_ID_AND_HOTNESS of table STORIES ******* | |
| Percentage of total database...................... 0.061% | |
| Number of entries................................. 128027 | |
| Bytes of storage consumed......................... 2293760 | |
| Bytes of payload.................................. 1890258 82.4% | |
| Bytes of metadata................................. 390797 17.0% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 14.76 | |
| Average unused bytes per entry.................... 0.10 | |
| Average metadata per entry........................ 3.05 | |
| Average fanout.................................... 140.00 | |
| Non-sequential pages.............................. 2 0.36% | |
| Maximum payload per entry......................... 18 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 4 | |
| Primary pages used................................ 556 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 560 | |
| Unused bytes on index pages....................... 4247 25.9% | |
| Unused bytes on primary pages..................... 8458 0.37% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 12705 0.55% | |
| *** Index INDEX_STORIES_ON_NORMALIZED_URL of table STORIES ******************** | |
| Percentage of total database...................... 0.20% | |
| Number of entries................................. 128027 | |
| Bytes of storage consumed......................... 7553024 | |
| Bytes of payload.................................. 7047006 93.3% | |
| Bytes of metadata................................. 407195 5.4% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 55.04 | |
| Average unused bytes per entry.................... 0.77 | |
| Average metadata per entry........................ 3.18 | |
| Average fanout.................................... 51.00 | |
| Non-sequential pages.............................. 5 0.27% | |
| Maximum payload per entry......................... 245 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 36 | |
| Primary pages used................................ 1808 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1844 | |
| Unused bytes on index pages....................... 15707 10.7% | |
| Unused bytes on primary pages..................... 83116 1.1% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 98823 1.3% | |
| *** Index INDEX_STORIES_ON_ORIGIN_ID of table STORIES ************************* | |
| Percentage of total database...................... 0.031% | |
| Number of entries................................. 128027 | |
| Bytes of storage consumed......................... 1155072 | |
| Bytes of payload.................................. 759348 65.7% | |
| Bytes of metadata................................. 387461 33.5% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 5.93 | |
| Average unused bytes per entry.................... 0.06 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 282.00 | |
| Non-sequential pages.............................. 2 0.71% | |
| Maximum payload per entry......................... 8 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 281 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 282 | |
| Unused bytes on index pages....................... 447 10.9% | |
| Unused bytes on primary pages..................... 7816 0.68% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8263 0.72% | |
| *** Index INDEX_STORIES_ON_SCORE of table STORIES ***************************** | |
| Percentage of total database...................... 0.035% | |
| Number of entries................................. 128027 | |
| Bytes of storage consumed......................... 1323008 | |
| Bytes of payload.................................. 850807 64.3% | |
| Bytes of metadata................................. 387953 29.3% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 6.65 | |
| Average unused bytes per entry.................... 0.66 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 107.00 | |
| Non-sequential pages.............................. 18 5.6% | |
| Maximum payload per entry......................... 8 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 320 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 323 | |
| Unused bytes on index pages....................... 7889 64.2% | |
| Unused bytes on primary pages..................... 76359 5.8% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 84248 6.4% | |
| *** Index INDEX_STORIES_ON_TOKEN of table STORIES ***************************** | |
| Percentage of total database...................... 0.14% | |
| Number of entries................................. 128027 | |
| Bytes of storage consumed......................... 5267456 | |
| Bytes of payload.................................. 4832135 91.7% | |
| Bytes of metadata................................. 399509 7.6% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 37.74 | |
| Average unused bytes per entry.................... 0.28 | |
| Average metadata per entry........................ 3.12 | |
| Average fanout.................................... 85.00 | |
| Non-sequential pages.............................. 1 0.078% | |
| Maximum payload per entry......................... 38 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 15 | |
| Primary pages used................................ 1271 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1286 | |
| Unused bytes on index pages....................... 4429 7.2% | |
| Unused bytes on primary pages..................... 31383 0.60% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 35812 0.68% | |
| *** Index INDEX_STORIES_ON_USER_ID of table STORIES *************************** | |
| Percentage of total database...................... 0.037% | |
| Number of entries................................. 128027 | |
| Bytes of storage consumed......................... 1396736 | |
| Bytes of payload.................................. 983024 70.4% | |
| Bytes of metadata................................. 388169 27.8% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 7.68 | |
| Average unused bytes per entry.................... 0.20 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 113.00 | |
| Non-sequential pages.............................. 4 1.2% | |
| Maximum payload per entry......................... 8 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 338 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 341 | |
| Unused bytes on index pages....................... 7299 59.4% | |
| Unused bytes on primary pages..................... 18244 1.3% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 25543 1.8% | |
| *** Index UNIQUE_SHORT_ID of table STORIES ************************************ | |
| Percentage of total database...................... 0.051% | |
| Number of entries................................. 128027 | |
| Bytes of storage consumed......................... 1921024 | |
| Bytes of payload.................................. 1503433 78.3% | |
| Bytes of metadata................................. 389705 20.3% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 11.74 | |
| Average unused bytes per entry.................... 0.22 | |
| Average metadata per entry........................ 3.04 | |
| Average fanout.................................... 117.00 | |
| Non-sequential pages.............................. 5 1.1% | |
| Maximum payload per entry......................... 12 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 4 | |
| Primary pages used................................ 465 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 469 | |
| Unused bytes on index pages....................... 7630 46.6% | |
| Unused bytes on primary pages..................... 20256 1.1% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 27886 1.5% | |
| *** Index URL of table STORIES ************************************************ | |
| Percentage of total database...................... 0.23% | |
| Number of entries................................. 128027 | |
| Bytes of storage consumed......................... 8835072 | |
| Bytes of payload.................................. 8330947 94.3% | |
| Bytes of metadata................................. 411926 4.7% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 65.07 | |
| Average unused bytes per entry.................... 0.72 | |
| Average metadata per entry........................ 3.22 | |
| Average fanout.................................... 49.00 | |
| Non-sequential pages.............................. 2 0.093% | |
| Maximum payload per entry......................... 257 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 44 | |
| Primary pages used................................ 2113 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 2157 | |
| Unused bytes on index pages....................... 6474 3.6% | |
| Unused bytes on primary pages..................... 85725 0.99% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 92199 1.0% | |
| *** Table STORY_TEXTS ********************************************************* | |
| Percentage of total database...................... 32.5% | |
| Number of entries................................. 127876 | |
| Bytes of storage consumed......................... 1224511488 | |
| Bytes of payload.................................. 1149927645 93.9% | |
| Bytes of metadata................................. 3878256 0.32% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 8992.52 | |
| Average unused bytes per entry.................... 557.88 | |
| Average metadata per entry........................ 30.33 | |
| Average fanout.................................... 402.00 | |
| Non-sequential pages.............................. 2 0.0% | |
| Maximum payload per entry......................... 1492891 | |
| Entries that use overflow......................... 72026 56.3% | |
| Index pages used.................................. 170 | |
| Primary pages used................................ 68333 | |
| Overflow pages used............................... 230450 | |
| Total pages used.................................. 298953 | |
| Unused bytes on index pages....................... 88592 12.7% | |
| Unused bytes on primary pages..................... 68351637 24.4% | |
| Unused bytes on overflow pages.................... 2899054 0.31% | |
| Unused bytes on all pages......................... 71339283 5.8% | |
| *** Table STORY_TEXTS_FTS_CONFIG ********************************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 1 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 11 0.27% | |
| Bytes of metadata................................. 11 0.27% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 11.00 | |
| Average unused bytes per entry.................... 4074.00 | |
| Average metadata per entry........................ 11.00 | |
| Maximum payload per entry......................... 11 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 4074 99.46% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4074 99.46% | |
| *** Table STORY_TEXTS_FTS_DATA ************************************************ | |
| Percentage of total database...................... 14.2% | |
| Number of entries................................. 136931 | |
| Bytes of storage consumed......................... 534249472 | |
| Bytes of payload.................................. 526278058 98.5% | |
| Bytes of metadata................................. 3967680 0.74% | |
| B-tree depth...................................... 4 | |
| Average payload per entry......................... 3843.38 | |
| Average unused bytes per entry.................... 29.24 | |
| Average metadata per entry........................ 28.98 | |
| Average fanout.................................... 297.00 | |
| Non-sequential pages.............................. 3 0.002% | |
| Maximum payload per entry......................... 32782 | |
| Entries that use overflow......................... 2 0.001% | |
| Index pages used.................................. 438 | |
| Primary pages used................................ 129984 | |
| Overflow pages used............................... 10 | |
| Total pages used.................................. 130432 | |
| Unused bytes on index pages....................... 228922 12.8% | |
| Unused bytes on primary pages..................... 3774401 0.71% | |
| Unused bytes on overflow pages.................... 443 1.1% | |
| Unused bytes on all pages......................... 4003766 0.75% | |
| *** Table STORY_TEXTS_FTS_DOCSIZE ********************************************* | |
| Percentage of total database...................... 0.053% | |
| Number of entries................................. 127876 | |
| Bytes of storage consumed......................... 2011136 | |
| Bytes of payload.................................. 1238533 61.6% | |
| Bytes of metadata................................. 759017 37.7% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 9.69 | |
| Average unused bytes per entry.................... 0.11 | |
| Average metadata per entry........................ 5.94 | |
| Average fanout.................................... 163.00 | |
| Non-sequential pages.............................. 1 0.20% | |
| Maximum payload per entry......................... 12 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 488 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 491 | |
| Unused bytes on index pages....................... 7925 64.5% | |
| Unused bytes on primary pages..................... 5661 0.28% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 13586 0.68% | |
| *** Table STORY_TEXTS_FTS_IDX ************************************************* | |
| Percentage of total database...................... 0.039% | |
| Number of entries................................. 79223 | |
| Bytes of storage consumed......................... 1462272 | |
| Bytes of payload.................................. 1204695 82.4% | |
| Bytes of metadata................................. 241960 16.5% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 15.21 | |
| Average unused bytes per entry.................... 0.20 | |
| Average metadata per entry........................ 3.05 | |
| Average fanout.................................... 88.00 | |
| Non-sequential pages.............................. 1 0.28% | |
| Maximum payload per entry......................... 1389 | |
| Entries that use overflow......................... 1 0.001% | |
| Index pages used.................................. 4 | |
| Primary pages used................................ 352 | |
| Overflow pages used............................... 1 | |
| Total pages used.................................. 357 | |
| Unused bytes on index pages....................... 8037 49.1% | |
| Unused bytes on primary pages..................... 4388 0.30% | |
| Unused bytes on overflow pages.................... 3192 77.9% | |
| Unused bytes on all pages......................... 15617 1.1% | |
| *** Table SUGGESTED_TAGGINGS and all its indices ****************************** | |
| Percentage of total database...................... 0.043% | |
| Number of entries................................. 129672 | |
| Bytes of storage consumed......................... 1609728 | |
| Bytes of payload.................................. 1099870 68.3% | |
| Bytes of metadata................................. 475187 29.5% | |
| Average payload per entry......................... 8.48 | |
| Average unused bytes per entry.................... 0.27 | |
| Average metadata per entry........................ 3.66 | |
| Average fanout.................................... 98.00 | |
| Maximum payload per entry......................... 65 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 4 | |
| Primary pages used................................ 389 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 393 | |
| Unused bytes on index pages....................... 11758 71.8% | |
| Unused bytes on primary pages..................... 22913 1.4% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 34671 2.2% | |
| *** Table SUGGESTED_TAGGINGS w/o any indices ********************************** | |
| Percentage of total database...................... 0.016% | |
| Number of entries................................. 32418 | |
| Bytes of storage consumed......................... 614400 | |
| Bytes of payload.................................. 426429 69.4% | |
| Bytes of metadata................................. 180521 29.4% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 13.15 | |
| Average unused bytes per entry.................... 0.23 | |
| Average metadata per entry........................ 5.57 | |
| Average fanout.................................... 149.00 | |
| Non-sequential pages.............................. 1 0.67% | |
| Maximum payload per entry......................... 65 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 149 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 150 | |
| Unused bytes on index pages....................... 2822 68.9% | |
| Unused bytes on primary pages..................... 4628 0.76% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7450 1.2% | |
| *** Indices of table SUGGESTED_TAGGINGS *************************************** | |
| Percentage of total database...................... 0.026% | |
| Number of entries................................. 97254 | |
| Bytes of storage consumed......................... 995328 | |
| Bytes of payload.................................. 673441 67.7% | |
| Bytes of metadata................................. 294666 29.6% | |
| Average payload per entry......................... 6.92 | |
| Average unused bytes per entry.................... 0.28 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 81.00 | |
| Maximum payload per entry......................... 8 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 240 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 243 | |
| Unused bytes on index pages....................... 8936 72.7% | |
| Unused bytes on primary pages..................... 18285 1.9% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 27221 2.7% | |
| *** Index SUGGESTED_TAGGINGS_STORY_ID_FK of table SUGGESTED_TAGGINGS ********** | |
| Percentage of total database...................... 0.009% | |
| Number of entries................................. 32418 | |
| Bytes of storage consumed......................... 356352 | |
| Bytes of payload.................................. 253843 71.2% | |
| Bytes of metadata................................. 98294 27.6% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 7.83 | |
| Average unused bytes per entry.................... 0.13 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 87.00 | |
| Non-sequential pages.............................. 1 1.2% | |
| Maximum payload per entry......................... 8 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 86 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 87 | |
| Unused bytes on index pages....................... 2822 68.9% | |
| Unused bytes on primary pages..................... 1393 0.40% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4215 1.2% | |
| *** Index SUGGESTED_TAGGINGS_TAG_ID_FK of table SUGGESTED_TAGGINGS ************ | |
| Percentage of total database...................... 0.008% | |
| Number of entries................................. 32418 | |
| Bytes of storage consumed......................... 307200 | |
| Bytes of payload.................................. 194203 63.2% | |
| Bytes of metadata................................. 98150 31.9% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 5.99 | |
| Average unused bytes per entry.................... 0.46 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 75.00 | |
| Non-sequential pages.............................. 2 2.7% | |
| Maximum payload per entry......................... 6 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 74 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 75 | |
| Unused bytes on index pages....................... 3135 76.5% | |
| Unused bytes on primary pages..................... 11712 3.9% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 14847 4.8% | |
| *** Index SUGGESTED_TAGGINGS_USER_ID_FK of table SUGGESTED_TAGGINGS *********** | |
| Percentage of total database...................... 0.009% | |
| Number of entries................................. 32418 | |
| Bytes of storage consumed......................... 331776 | |
| Bytes of payload.................................. 225395 67.9% | |
| Bytes of metadata................................. 98222 29.6% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 6.95 | |
| Average unused bytes per entry.................... 0.25 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 81.00 | |
| Non-sequential pages.............................. 2 2.5% | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 80 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 81 | |
| Unused bytes on index pages....................... 2979 72.7% | |
| Unused bytes on primary pages..................... 5180 1.6% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8159 2.5% | |
| *** Table SUGGESTED_TITLES and all its indices ******************************** | |
| Percentage of total database...................... 0.014% | |
| Number of entries................................. 18867 | |
| Bytes of storage consumed......................... 524288 | |
| Bytes of payload.................................. 433431 82.7% | |
| Bytes of metadata................................. 70947 13.5% | |
| Average payload per entry......................... 22.97 | |
| Average unused bytes per entry.................... 1.06 | |
| Average metadata per entry........................ 3.76 | |
| Average fanout.................................... 42.00 | |
| Maximum payload per entry......................... 145 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 125 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 128 | |
| Unused bytes on index pages....................... 11076 90.1% | |
| Unused bytes on primary pages..................... 8834 1.7% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 19910 3.8% | |
| *** Table SUGGESTED_TITLES w/o any indices ************************************ | |
| Percentage of total database...................... 0.010% | |
| Number of entries................................. 6289 | |
| Bytes of storage consumed......................... 380928 | |
| Bytes of payload.................................. 340556 89.4% | |
| Bytes of metadata................................. 32801 8.6% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 54.15 | |
| Average unused bytes per entry.................... 1.20 | |
| Average metadata per entry........................ 5.22 | |
| Average fanout.................................... 92.00 | |
| Non-sequential pages.............................. 1 1.1% | |
| Maximum payload per entry......................... 145 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 92 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 93 | |
| Unused bytes on index pages....................... 3357 82.0% | |
| Unused bytes on primary pages..................... 4214 1.1% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7571 2.0% | |
| *** Indices of table SUGGESTED_TITLES ***************************************** | |
| Percentage of total database...................... 0.004% | |
| Number of entries................................. 12578 | |
| Bytes of storage consumed......................... 143360 | |
| Bytes of payload.................................. 92875 64.8% | |
| Bytes of metadata................................. 38146 26.6% | |
| Average payload per entry......................... 7.38 | |
| Average unused bytes per entry.................... 0.98 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 17.00 | |
| Maximum payload per entry......................... 8 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 2 | |
| Primary pages used................................ 33 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 35 | |
| Unused bytes on index pages....................... 7719 94.2% | |
| Unused bytes on primary pages..................... 4620 3.4% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 12339 8.6% | |
| *** Index SUGGESTED_TITLES_STORY_ID_FK of table SUGGESTED_TITLES ************** | |
| Percentage of total database...................... 0.002% | |
| Number of entries................................. 6289 | |
| Bytes of storage consumed......................... 73728 | |
| Bytes of payload.................................. 49403 67.0% | |
| Bytes of metadata................................. 19079 25.9% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 7.86 | |
| Average unused bytes per entry.................... 0.83 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 18.00 | |
| Non-sequential pages.............................. 1 5.9% | |
| Maximum payload per entry......................... 8 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 17 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 18 | |
| Unused bytes on index pages....................... 3845 93.9% | |
| Unused bytes on primary pages..................... 1401 2.0% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 5246 7.1% | |
| *** Index SUGGESTED_TITLES_USER_ID_FK of table SUGGESTED_TITLES *************** | |
| Percentage of total database...................... 0.002% | |
| Number of entries................................. 6289 | |
| Bytes of storage consumed......................... 69632 | |
| Bytes of payload.................................. 43472 62.4% | |
| Bytes of metadata................................. 19067 27.4% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 6.91 | |
| Average unused bytes per entry.................... 1.13 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 17.00 | |
| Non-sequential pages.............................. 1 6.2% | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 16 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 17 | |
| Unused bytes on index pages....................... 3874 94.6% | |
| Unused bytes on primary pages..................... 3219 4.9% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7093 10.2% | |
| *** Table TAG_FILTERS and all its indices ************************************* | |
| Percentage of total database...................... 0.039% | |
| Number of entries................................. 58398 | |
| Bytes of storage consumed......................... 1449984 | |
| Bytes of payload.................................. 1205355 83.1% | |
| Bytes of metadata................................. 227553 15.7% | |
| Average payload per entry......................... 20.64 | |
| Average unused bytes per entry.................... 0.29 | |
| Average metadata per entry........................ 3.90 | |
| Average fanout.................................... 117.00 | |
| Maximum payload per entry......................... 61 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 351 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 354 | |
| Unused bytes on index pages....................... 8706 70.8% | |
| Unused bytes on primary pages..................... 8370 0.58% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 17076 1.2% | |
| *** Table TAG_FILTERS w/o any indices ***************************************** | |
| Percentage of total database...................... 0.027% | |
| Number of entries................................. 19466 | |
| Bytes of storage consumed......................... 1032192 | |
| Bytes of payload.................................. 914553 88.6% | |
| Bytes of metadata................................. 109541 10.6% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 46.98 | |
| Average unused bytes per entry.................... 0.42 | |
| Average metadata per entry........................ 5.63 | |
| Average fanout.................................... 251.00 | |
| Non-sequential pages.............................. 1 0.40% | |
| Maximum payload per entry......................... 61 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 251 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 252 | |
| Unused bytes on index pages....................... 1979 48.3% | |
| Unused bytes on primary pages..................... 6119 0.60% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8098 0.78% | |
| *** Indices of table TAG_FILTERS ********************************************** | |
| Percentage of total database...................... 0.011% | |
| Number of entries................................. 38932 | |
| Bytes of storage consumed......................... 417792 | |
| Bytes of payload.................................. 290802 69.6% | |
| Bytes of metadata................................. 118012 28.2% | |
| Average payload per entry......................... 7.47 | |
| Average unused bytes per entry.................... 0.23 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 51.00 | |
| Maximum payload per entry......................... 9 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 2 | |
| Primary pages used................................ 100 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 102 | |
| Unused bytes on index pages....................... 6727 82.1% | |
| Unused bytes on primary pages..................... 2251 0.55% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8978 2.1% | |
| *** Index TAG_FILTERS_TAG_ID_FK of table TAG_FILTERS ************************** | |
| Percentage of total database...................... 0.005% | |
| Number of entries................................. 19466 | |
| Bytes of storage consumed......................... 180224 | |
| Bytes of payload.................................. 116364 64.6% | |
| Bytes of metadata................................. 58922 32.7% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 5.98 | |
| Average unused bytes per entry.................... 0.25 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 44.00 | |
| Non-sequential pages.............................. 1 2.3% | |
| Maximum payload per entry......................... 6 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 43 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 44 | |
| Unused bytes on index pages....................... 3538 86.4% | |
| Unused bytes on primary pages..................... 1400 0.79% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4938 2.7% | |
| *** Index USER_TAG_IDX of table TAG_FILTERS *********************************** | |
| Percentage of total database...................... 0.006% | |
| Number of entries................................. 19466 | |
| Bytes of storage consumed......................... 237568 | |
| Bytes of payload.................................. 174438 73.4% | |
| Bytes of metadata................................. 59090 24.9% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 8.96 | |
| Average unused bytes per entry.................... 0.21 | |
| Average metadata per entry........................ 3.04 | |
| Average fanout.................................... 58.00 | |
| Non-sequential pages.............................. 1 1.8% | |
| Maximum payload per entry......................... 9 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 57 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 58 | |
| Unused bytes on index pages....................... 3189 77.9% | |
| Unused bytes on primary pages..................... 851 0.36% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4040 1.7% | |
| *** Table TAGGINGS and all its indices **************************************** | |
| Percentage of total database...................... 0.23% | |
| Number of entries................................. 684486 | |
| Bytes of storage consumed......................... 8536064 | |
| Bytes of payload.................................. 5740909 67.3% | |
| Bytes of metadata................................. 2750361 32.2% | |
| Average payload per entry......................... 8.39 | |
| Average unused bytes per entry.................... 0.07 | |
| Average metadata per entry........................ 4.02 | |
| Average fanout.................................... 189.00 | |
| Maximum payload per entry......................... 11 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 11 | |
| Primary pages used................................ 2073 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 2084 | |
| Unused bytes on index pages....................... 17133 38.0% | |
| Unused bytes on primary pages..................... 27661 0.33% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 44794 0.52% | |
| *** Table TAGGINGS w/o any indices ******************************************** | |
| Percentage of total database...................... 0.083% | |
| Number of entries................................. 228162 | |
| Bytes of storage consumed......................... 3137536 | |
| Bytes of payload.................................. 1763470 56.2% | |
| Bytes of metadata................................. 1365581 43.5% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 7.73 | |
| Average unused bytes per entry.................... 0.04 | |
| Average metadata per entry........................ 5.99 | |
| Average fanout.................................... 255.00 | |
| Non-sequential pages.............................. 1 0.13% | |
| Maximum payload per entry......................... 8 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 763 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 766 | |
| Unused bytes on index pages....................... 5441 44.3% | |
| Unused bytes on primary pages..................... 3044 0.097% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 8485 0.27% | |
| *** Indices of table TAGGINGS ************************************************* | |
| Percentage of total database...................... 0.14% | |
| Number of entries................................. 456324 | |
| Bytes of storage consumed......................... 5398528 | |
| Bytes of payload.................................. 3977439 73.7% | |
| Bytes of metadata................................. 1384780 25.7% | |
| Average payload per entry......................... 8.72 | |
| Average unused bytes per entry.................... 0.08 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 164.00 | |
| Maximum payload per entry......................... 11 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 8 | |
| Primary pages used................................ 1310 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1318 | |
| Unused bytes on index pages....................... 11692 35.7% | |
| Unused bytes on primary pages..................... 24617 0.46% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 36309 0.67% | |
| *** Index STORY_ID_TAG_ID of table TAGGINGS *********************************** | |
| Percentage of total database...................... 0.083% | |
| Number of entries................................. 228162 | |
| Bytes of storage consumed......................... 3121152 | |
| Bytes of payload.................................. 2415409 77.4% | |
| Bytes of metadata................................. 693626 22.2% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 10.59 | |
| Average unused bytes per entry.................... 0.05 | |
| Average metadata per entry........................ 3.04 | |
| Average fanout.................................... 152.00 | |
| Non-sequential pages.............................. 1 0.13% | |
| Maximum payload per entry......................... 11 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 5 | |
| Primary pages used................................ 757 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 762 | |
| Unused bytes on index pages....................... 7089 34.6% | |
| Unused bytes on primary pages..................... 5028 0.16% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 12117 0.39% | |
| *** Index TAGGINGS_TAG_ID_FK of table TAGGINGS ******************************** | |
| Percentage of total database...................... 0.060% | |
| Number of entries................................. 228162 | |
| Bytes of storage consumed......................... 2277376 | |
| Bytes of payload.................................. 1562030 68.6% | |
| Bytes of metadata................................. 691154 30.3% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 6.85 | |
| Average unused bytes per entry.................... 0.11 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 185.00 | |
| Non-sequential pages.............................. 3 0.54% | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 553 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 556 | |
| Unused bytes on index pages....................... 4603 37.5% | |
| Unused bytes on primary pages..................... 19589 0.86% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 24192 1.1% | |
| *** Table TAGS and all its indices ******************************************** | |
| Percentage of total database...................... 0.001% | |
| Number of entries................................. 464 | |
| Bytes of storage consumed......................... 40960 | |
| Bytes of payload.................................. 19004 46.4% | |
| Bytes of metadata................................. 1640 4.0% | |
| Average payload per entry......................... 40.96 | |
| Average unused bytes per entry.................... 43.78 | |
| Average metadata per entry........................ 3.53 | |
| Average fanout.................................... 4.00 | |
| Maximum payload per entry......................... 183 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 2 | |
| Primary pages used................................ 8 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 10 | |
| Unused bytes on index pages....................... 8106 99.0% | |
| Unused bytes on primary pages..................... 12210 37.3% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 20316 49.6% | |
| *** Table TAGS w/o any indices ************************************************ | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 116 | |
| Bytes of storage consumed......................... 20480 | |
| Bytes of payload.................................. 13302 65.0% | |
| Bytes of metadata................................. 548 2.7% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 114.67 | |
| Average unused bytes per entry.................... 57.16 | |
| Average metadata per entry........................ 4.72 | |
| Average fanout.................................... 4.00 | |
| Non-sequential pages.............................. 1 25.0% | |
| Maximum payload per entry......................... 183 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 4 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 5 | |
| Unused bytes on index pages....................... 4063 99.19% | |
| Unused bytes on primary pages..................... 2567 15.7% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 6630 32.4% | |
| *** Indices of table TAGS ***************************************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 348 | |
| Bytes of storage consumed......................... 20480 | |
| Bytes of payload.................................. 5702 27.8% | |
| Bytes of metadata................................. 1092 5.3% | |
| Average payload per entry......................... 16.39 | |
| Average unused bytes per entry.................... 39.33 | |
| Average metadata per entry........................ 3.14 | |
| Average fanout.................................... 5.00 | |
| Maximum payload per entry......................... 34 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 4 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 5 | |
| Unused bytes on index pages....................... 4043 98.7% | |
| Unused bytes on primary pages..................... 9643 58.9% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 13686 66.8% | |
| *** Index INDEX_TAGS_ON_CATEGORY_ID of table TAGS ***************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 116 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 570 13.9% | |
| Bytes of metadata................................. 356 8.7% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 4.91 | |
| Average unused bytes per entry.................... 27.33 | |
| Average metadata per entry........................ 3.07 | |
| Maximum payload per entry......................... 5 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 3170 77.4% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3170 77.4% | |
| *** Index INDEX_TAGS_ON_TOKEN of table TAGS *********************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 116 | |
| Bytes of storage consumed......................... 12288 | |
| Bytes of payload.................................. 3943 32.1% | |
| Bytes of metadata................................. 380 3.1% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 33.99 | |
| Average unused bytes per entry.................... 68.66 | |
| Average metadata per entry........................ 3.28 | |
| Average fanout.................................... 3.00 | |
| Non-sequential pages.............................. 1 50.0% | |
| Maximum payload per entry......................... 34 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 2 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 3 | |
| Unused bytes on index pages....................... 4043 98.7% | |
| Unused bytes on primary pages..................... 3922 47.9% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7965 64.8% | |
| *** Index TAG of table TAGS *************************************************** | |
| Percentage of total database...................... 0.0% | |
| Number of entries................................. 116 | |
| Bytes of storage consumed......................... 4096 | |
| Bytes of payload.................................. 1189 29.0% | |
| Bytes of metadata................................. 356 8.7% | |
| B-tree depth...................................... 1 | |
| Average payload per entry......................... 10.25 | |
| Average unused bytes per entry.................... 21.99 | |
| Average metadata per entry........................ 3.07 | |
| Maximum payload per entry......................... 18 | |
| Entries that use overflow......................... 0 0.0% | |
| Primary pages used................................ 1 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1 | |
| Unused bytes on primary pages..................... 2551 62.3% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 2551 62.3% | |
| *** Table USERNAMES and all its indices *************************************** | |
| Percentage of total database...................... 0.030% | |
| Number of entries................................. 43350 | |
| Bytes of storage consumed......................... 1118208 | |
| Bytes of payload.................................. 923727 82.6% | |
| Bytes of metadata................................. 182753 16.3% | |
| Average payload per entry......................... 21.31 | |
| Average unused bytes per entry.................... 0.27 | |
| Average metadata per entry........................ 4.22 | |
| Average fanout.................................... 136.00 | |
| Maximum payload per entry......................... 71 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 2 | |
| Primary pages used................................ 271 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 273 | |
| Unused bytes on index pages....................... 5652 69.0% | |
| Unused bytes on primary pages..................... 6076 0.55% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 11728 1.0% | |
| *** Table USERNAMES w/o any indices ******************************************* | |
| Percentage of total database...................... 0.024% | |
| Number of entries................................. 21675 | |
| Bytes of storage consumed......................... 897024 | |
| Bytes of payload.................................. 772263 86.1% | |
| Bytes of metadata................................. 117084 13.1% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 35.63 | |
| Average unused bytes per entry.................... 0.35 | |
| Average metadata per entry........................ 5.40 | |
| Average fanout.................................... 218.00 | |
| Non-sequential pages.............................. 1 0.46% | |
| Maximum payload per entry......................... 71 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 218 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 219 | |
| Unused bytes on index pages....................... 2296 56.1% | |
| Unused bytes on primary pages..................... 5381 0.60% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7677 0.86% | |
| *** Index FK_RAILS_74BBEF8F63 of table USERNAMES ****************************** | |
| Percentage of total database...................... 0.006% | |
| Number of entries................................. 21675 | |
| Bytes of storage consumed......................... 221184 | |
| Bytes of payload.................................. 151464 68.5% | |
| Bytes of metadata................................. 65669 29.7% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 6.99 | |
| Average unused bytes per entry.................... 0.19 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 54.00 | |
| Non-sequential pages.............................. 1 1.9% | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 53 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 54 | |
| Unused bytes on index pages....................... 3356 81.9% | |
| Unused bytes on primary pages..................... 695 0.32% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4051 1.8% | |
| *** Table USERS and all its indices ******************************************* | |
| Percentage of total database...................... 0.59% | |
| Number of entries................................. 245748 | |
| Bytes of storage consumed......................... 22093824 | |
| Bytes of payload.................................. 19589848 88.7% | |
| Bytes of metadata................................. 883771 4.0% | |
| Average payload per entry......................... 79.72 | |
| Average unused bytes per entry.................... 6.59 | |
| Average metadata per entry........................ 3.60 | |
| Average fanout.................................... 134.00 | |
| Maximum payload per entry......................... 79809 | |
| Entries that use overflow......................... 1 0.0% | |
| Index pages used.................................. 40 | |
| Primary pages used................................ 5335 | |
| Overflow pages used............................... 19 | |
| Total pages used.................................. 5394 | |
| Unused bytes on index pages....................... 62148 37.9% | |
| Unused bytes on primary pages..................... 1558129 7.1% | |
| Unused bytes on overflow pages.................... 0 0.0% | |
| Unused bytes on all pages......................... 1620277 7.3% | |
| *** Table USERS w/o any indices *********************************************** | |
| Percentage of total database...................... 0.43% | |
| Number of entries................................. 20479 | |
| Bytes of storage consumed......................... 16220160 | |
| Bytes of payload.................................. 14512866 89.5% | |
| Bytes of metadata................................. 190800 1.2% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 708.67 | |
| Average unused bytes per entry.................... 74.05 | |
| Average metadata per entry........................ 9.32 | |
| Average fanout.................................... 394.00 | |
| Non-sequential pages.............................. 1 0.025% | |
| Maximum payload per entry......................... 79809 | |
| Entries that use overflow......................... 1 0.005% | |
| Index pages used.................................. 10 | |
| Primary pages used................................ 3931 | |
| Overflow pages used............................... 19 | |
| Total pages used.................................. 3960 | |
| Unused bytes on index pages....................... 8621 21.0% | |
| Unused bytes on primary pages..................... 1507945 9.4% | |
| Unused bytes on overflow pages.................... 0 0.0% | |
| Unused bytes on all pages......................... 1516566 9.3% | |
| *** Indices of table USERS **************************************************** | |
| Percentage of total database...................... 0.16% | |
| Number of entries................................. 225269 | |
| Bytes of storage consumed......................... 5873664 | |
| Bytes of payload.................................. 5076982 86.4% | |
| Bytes of metadata................................. 692971 11.8% | |
| Average payload per entry......................... 22.54 | |
| Average unused bytes per entry.................... 0.46 | |
| Average metadata per entry........................ 3.08 | |
| Average fanout.................................... 47.00 | |
| Maximum payload per entry......................... 66 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 30 | |
| Primary pages used................................ 1404 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 1434 | |
| Unused bytes on index pages....................... 53527 43.6% | |
| Unused bytes on primary pages..................... 50184 0.87% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 103711 1.8% | |
| *** Index INDEX_USERS_ON_EMAIL of table USERS ********************************* | |
| Percentage of total database...................... 0.016% | |
| Number of entries................................. 20479 | |
| Bytes of storage consumed......................... 585728 | |
| Bytes of payload.................................. 512260 87.5% | |
| Bytes of metadata................................. 63149 10.8% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 25.01 | |
| Average unused bytes per entry.................... 0.50 | |
| Average metadata per entry........................ 3.08 | |
| Average fanout.................................... 47.00 | |
| Non-sequential pages.............................. 1 0.70% | |
| Maximum payload per entry......................... 66 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 3 | |
| Primary pages used................................ 140 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 143 | |
| Unused bytes on index pages....................... 7686 62.5% | |
| Unused bytes on primary pages..................... 2633 0.46% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 10319 1.8% | |
| *** Index INDEX_USERS_ON_TOKEN of table USERS ********************************* | |
| Percentage of total database...................... 0.022% | |
| Number of entries................................. 20479 | |
| Bytes of storage consumed......................... 819200 | |
| Bytes of payload.................................. 737116 90.0% | |
| Bytes of metadata................................. 63833 7.8% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 35.99 | |
| Average unused bytes per entry.................... 0.89 | |
| Average metadata per entry........................ 3.12 | |
| Average fanout.................................... 50.00 | |
| Non-sequential pages.............................. 1 0.50% | |
| Maximum payload per entry......................... 36 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 4 | |
| Primary pages used................................ 196 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 200 | |
| Unused bytes on index pages....................... 7952 48.5% | |
| Unused bytes on primary pages..................... 10299 1.3% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 18251 2.2% | |
| *** Index MAILING_LIST_ENABLED of table USERS ********************************* | |
| Percentage of total database...................... 0.004% | |
| Number of entries................................. 20479 | |
| Bytes of storage consumed......................... 167936 | |
| Bytes of payload.................................. 102327 60.9% | |
| Bytes of metadata................................. 61925 36.9% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 5.00 | |
| Average unused bytes per entry.................... 0.18 | |
| Average metadata per entry........................ 3.02 | |
| Average fanout.................................... 41.00 | |
| Non-sequential pages.............................. 1 2.5% | |
| Maximum payload per entry......................... 6 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 40 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 41 | |
| Unused bytes on index pages....................... 3616 88.3% | |
| Unused bytes on primary pages..................... 68 0.042% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3684 2.2% | |
| *** Index MAILING_LIST_TOKEN of table USERS *********************************** | |
| Percentage of total database...................... 0.010% | |
| Number of entries................................. 20479 | |
| Bytes of storage consumed......................... 372736 | |
| Bytes of payload.................................. 307057 82.4% | |
| Bytes of metadata................................. 62525 16.8% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 14.99 | |
| Average unused bytes per entry.................... 0.15 | |
| Average metadata per entry........................ 3.05 | |
| Average fanout.................................... 91.00 | |
| Non-sequential pages.............................. 1 1.1% | |
| Maximum payload per entry......................... 15 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 90 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 91 | |
| Unused bytes on index pages....................... 2127 51.9% | |
| Unused bytes on primary pages..................... 1027 0.28% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3154 0.85% | |
| *** Index PASSWORD_RESET_TOKEN of table USERS ********************************* | |
| Percentage of total database...................... 0.005% | |
| Number of entries................................. 20479 | |
| Bytes of storage consumed......................... 184320 | |
| Bytes of payload.................................. 116371 63.1% | |
| Bytes of metadata................................. 61973 33.6% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 5.68 | |
| Average unused bytes per entry.................... 0.29 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 45.00 | |
| Non-sequential pages.............................. 1 2.3% | |
| Maximum payload per entry......................... 46 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 44 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 45 | |
| Unused bytes on index pages....................... 3404 83.1% | |
| Unused bytes on primary pages..................... 2572 1.4% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 5976 3.2% | |
| *** Index RSS_TOKEN of table USERS ******************************************** | |
| Percentage of total database...................... 0.038% | |
| Number of entries................................. 20479 | |
| Bytes of storage consumed......................... 1433600 | |
| Bytes of payload.................................. 1345953 93.9% | |
| Bytes of metadata................................. 65633 4.6% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 65.72 | |
| Average unused bytes per entry.................... 1.07 | |
| Average metadata per entry........................ 3.20 | |
| Average fanout.................................... 43.00 | |
| Non-sequential pages.............................. 1 0.29% | |
| Maximum payload per entry......................... 66 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 8 | |
| Primary pages used................................ 342 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 350 | |
| Unused bytes on index pages....................... 7836 23.9% | |
| Unused bytes on primary pages..................... 14178 1.0% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 22014 1.5% | |
| *** Index SESSION_HASH of table USERS ***************************************** | |
| Percentage of total database...................... 0.038% | |
| Number of entries................................. 20479 | |
| Bytes of storage consumed......................... 1437696 | |
| Bytes of payload.................................. 1351486 94.0% | |
| Bytes of metadata................................. 65645 4.6% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 65.99 | |
| Average unused bytes per entry.................... 1.00 | |
| Average metadata per entry........................ 3.21 | |
| Average fanout.................................... 43.00 | |
| Non-sequential pages.............................. 2 0.57% | |
| Maximum payload per entry......................... 66 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 8 | |
| Primary pages used................................ 343 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 351 | |
| Unused bytes on index pages....................... 7708 23.5% | |
| Unused bytes on primary pages..................... 12857 0.92% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 20565 1.4% | |
| *** Index USERNAME of table USERS ********************************************* | |
| Percentage of total database...................... 0.009% | |
| Number of entries................................. 20479 | |
| Bytes of storage consumed......................... 323584 | |
| Bytes of payload.................................. 257428 79.6% | |
| Bytes of metadata................................. 62381 19.3% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 12.57 | |
| Average unused bytes per entry.................... 0.18 | |
| Average metadata per entry........................ 3.05 | |
| Average fanout.................................... 79.00 | |
| Non-sequential pages.............................. 1 1.3% | |
| Maximum payload per entry......................... 30 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 78 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 79 | |
| Unused bytes on index pages....................... 2579 63.0% | |
| Unused bytes on primary pages..................... 1196 0.37% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3775 1.2% | |
| *** Index USERS_BANNED_BY_USER_ID_FK of table USERS *************************** | |
| Percentage of total database...................... 0.005% | |
| Number of entries................................. 20479 | |
| Bytes of storage consumed......................... 172032 | |
| Bytes of payload.................................. 102646 59.7% | |
| Bytes of metadata................................. 61937 36.0% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 5.01 | |
| Average unused bytes per entry.................... 0.36 | |
| Average metadata per entry........................ 3.02 | |
| Average fanout.................................... 42.00 | |
| Non-sequential pages.............................. 1 2.4% | |
| Maximum payload per entry......................... 6 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 41 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 42 | |
| Unused bytes on index pages....................... 3603 88.0% | |
| Unused bytes on primary pages..................... 3846 2.3% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 7449 4.3% | |
| *** Index USERS_DISABLED_INVITE_BY_USER_ID_FK of table USERS ****************** | |
| Percentage of total database...................... 0.004% | |
| Number of entries................................. 20479 | |
| Bytes of storage consumed......................... 167936 | |
| Bytes of payload.................................. 102339 60.9% | |
| Bytes of metadata................................. 61925 36.9% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 5.00 | |
| Average unused bytes per entry.................... 0.18 | |
| Average metadata per entry........................ 3.02 | |
| Average fanout.................................... 41.00 | |
| Non-sequential pages.............................. 1 2.5% | |
| Maximum payload per entry......................... 6 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 40 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 41 | |
| Unused bytes on index pages....................... 3616 88.3% | |
| Unused bytes on primary pages..................... 56 0.034% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3672 2.2% | |
| *** Index USERS_INVITED_BY_USER_ID_FK of table USERS ************************** | |
| Percentage of total database...................... 0.006% | |
| Number of entries................................. 20479 | |
| Bytes of storage consumed......................... 208896 | |
| Bytes of payload.................................. 141999 68.0% | |
| Bytes of metadata................................. 62045 29.7% | |
| B-tree depth...................................... 2 | |
| Average payload per entry......................... 6.93 | |
| Average unused bytes per entry.................... 0.24 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 51.00 | |
| Non-sequential pages.............................. 1 2.0% | |
| Maximum payload per entry......................... 7 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 1 | |
| Primary pages used................................ 50 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 51 | |
| Unused bytes on index pages....................... 3400 83.0% | |
| Unused bytes on primary pages..................... 1452 0.71% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 4852 2.3% | |
| *** Table VOTES and all its indices ******************************************* | |
| Percentage of total database...................... 4.2% | |
| Number of entries................................. 9033665 | |
| Bytes of storage consumed......................... 159969280 | |
| Bytes of payload.................................. 121990116 76.3% | |
| Bytes of metadata................................. 34050025 21.3% | |
| Average payload per entry......................... 13.50 | |
| Average unused bytes per entry.................... 0.43 | |
| Average metadata per entry........................ 3.77 | |
| Average fanout.................................... 263.00 | |
| Maximum payload per entry......................... 44 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 148 | |
| Primary pages used................................ 38907 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 39055 | |
| Unused bytes on index pages....................... 85537 14.1% | |
| Unused bytes on primary pages..................... 3843602 2.4% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3929139 2.5% | |
| *** Table VOTES w/o any indices *********************************************** | |
| Percentage of total database...................... 1.9% | |
| Number of entries................................. 1806733 | |
| Bytes of storage consumed......................... 70189056 | |
| Bytes of payload.................................. 57657374 82.1% | |
| Bytes of metadata................................. 12106217 17.2% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 31.91 | |
| Average unused bytes per entry.................... 0.24 | |
| Average metadata per entry........................ 6.70 | |
| Average fanout.................................... 364.00 | |
| Non-sequential pages.............................. 22 0.13% | |
| Maximum payload per entry......................... 44 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 47 | |
| Primary pages used................................ 17089 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 17136 | |
| Unused bytes on index pages....................... 28845 15.0% | |
| Unused bytes on primary pages..................... 396620 0.57% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 425465 0.61% | |
| *** Indices of table VOTES **************************************************** | |
| Percentage of total database...................... 2.4% | |
| Number of entries................................. 7226932 | |
| Bytes of storage consumed......................... 89780224 | |
| Bytes of payload.................................. 64332742 71.7% | |
| Bytes of metadata................................. 21943808 24.4% | |
| Average payload per entry......................... 8.90 | |
| Average unused bytes per entry.................... 0.48 | |
| Average metadata per entry........................ 3.04 | |
| Average fanout.................................... 217.00 | |
| Maximum payload per entry......................... 12 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 101 | |
| Primary pages used................................ 21818 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 21919 | |
| Unused bytes on index pages....................... 56692 13.7% | |
| Unused bytes on primary pages..................... 3446982 3.9% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 3503674 3.9% | |
| *** Index INDEX_VOTES_ON_COMMENT_ID of table VOTES **************************** | |
| Percentage of total database...................... 0.43% | |
| Number of entries................................. 1806733 | |
| Bytes of storage consumed......................... 16310272 | |
| Bytes of payload.................................. 10827213 66.4% | |
| Bytes of metadata................................. 5467979 33.5% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 5.99 | |
| Average unused bytes per entry.................... 0.01 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 284.00 | |
| Non-sequential pages.............................. 6 0.15% | |
| Maximum payload per entry......................... 9 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 14 | |
| Primary pages used................................ 3968 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 3982 | |
| Unused bytes on index pages....................... 5623 9.8% | |
| Unused bytes on primary pages..................... 9457 0.058% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 15080 0.092% | |
| *** Index USER_ID_COMMENT_ID of table VOTES *********************************** | |
| Percentage of total database...................... 0.62% | |
| Number of entries................................. 1806733 | |
| Bytes of storage consumed......................... 23339008 | |
| Bytes of payload.................................. 16216294 69.5% | |
| Bytes of metadata................................. 5488571 23.5% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 8.98 | |
| Average unused bytes per entry.................... 0.90 | |
| Average metadata per entry........................ 3.04 | |
| Average fanout.................................... 219.00 | |
| Non-sequential pages.............................. 387 6.8% | |
| Maximum payload per entry......................... 12 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 26 | |
| Primary pages used................................ 5672 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 5698 | |
| Unused bytes on index pages....................... 15565 14.6% | |
| Unused bytes on primary pages..................... 1618578 7.0% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 1634143 7.0% | |
| *** Index USER_ID_STORY_ID of table VOTES ************************************* | |
| Percentage of total database...................... 0.76% | |
| Number of entries................................. 1806733 | |
| Bytes of storage consumed......................... 28598272 | |
| Bytes of payload.................................. 21339158 74.6% | |
| Bytes of metadata................................. 5503979 19.2% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 11.81 | |
| Average unused bytes per entry.................... 0.97 | |
| Average metadata per entry........................ 3.05 | |
| Average fanout.................................... 179.00 | |
| Non-sequential pages.............................. 400 5.7% | |
| Maximum payload per entry......................... 12 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 39 | |
| Primary pages used................................ 6943 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 6982 | |
| Unused bytes on index pages....................... 28577 17.9% | |
| Unused bytes on primary pages..................... 1726558 6.1% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 1755135 6.1% | |
| *** Index VOTES_STORY_ID_FK of table VOTES ************************************ | |
| Percentage of total database...................... 0.57% | |
| Number of entries................................. 1806733 | |
| Bytes of storage consumed......................... 21532672 | |
| Bytes of payload.................................. 15950077 74.1% | |
| Bytes of metadata................................. 5483279 25.5% | |
| B-tree depth...................................... 3 | |
| Average payload per entry......................... 8.83 | |
| Average unused bytes per entry.................... 0.05 | |
| Average metadata per entry........................ 3.03 | |
| Average fanout.................................... 238.00 | |
| Non-sequential pages.............................. 18 0.34% | |
| Maximum payload per entry......................... 9 | |
| Entries that use overflow......................... 0 0.0% | |
| Index pages used.................................. 22 | |
| Primary pages used................................ 5235 | |
| Overflow pages used............................... 0 | |
| Total pages used.................................. 5257 | |
| Unused bytes on index pages....................... 6927 7.7% | |
| Unused bytes on primary pages..................... 92389 0.43% | |
| Unused bytes on overflow pages.................... 0 | |
| Unused bytes on all pages......................... 99316 0.46% | |
| *** Definitions *************************************************************** | |
| Page size in bytes | |
| The number of bytes in a single page of the database file. | |
| Usually 1024. | |
| Number of pages in the whole file | |
| The number of 4096-byte pages that go into forming the complete | |
| database | |
| Pages that store data | |
| The number of pages that store data, either as primary B*Tree pages or | |
| as overflow pages. The number at the right is the data pages divided by | |
| the total number of pages in the file. | |
| Pages on the freelist | |
| The number of pages that are not currently in use but are reserved for | |
| future use. The percentage at the right is the number of freelist pages | |
| divided by the total number of pages in the file. | |
| Pages of auto-vacuum overhead | |
| The number of pages that store data used by the database to facilitate | |
| auto-vacuum. This is zero for databases that do not support auto-vacuum. | |
| Number of tables in the database | |
| The number of tables in the database, including the SQLITE_SCHEMA table | |
| used to store schema information. | |
| Number of indices | |
| The total number of indices in the database. | |
| Number of defined indices | |
| The number of indices created using an explicit CREATE INDEX statement. | |
| Number of implied indices | |
| The number of indices used to implement PRIMARY KEY or UNIQUE constraints | |
| on tables. | |
| Size of the file in bytes | |
| The total amount of disk space used by the entire database files. | |
| Bytes of user payload stored | |
| The total number of bytes of user payload stored in the database. The | |
| schema information in the SQLITE_SCHEMA table is not counted when | |
| computing this number. The percentage at the right shows the payload | |
| divided by the total file size. | |
| Percentage of total database | |
| The amount of the complete database file that is devoted to storing | |
| information described by this category. | |
| Number of entries | |
| The total number of B-Tree key/value pairs stored under this category. | |
| Bytes of storage consumed | |
| The total amount of disk space required to store all B-Tree entries | |
| under this category. The is the total number of pages used times | |
| the pages size. | |
| Bytes of payload | |
| The amount of payload stored under this category. Payload is the data | |
| part of table entries and the key part of index entries. The percentage | |
| at the right is the bytes of payload divided by the bytes of storage | |
| consumed. | |
| Bytes of metadata | |
| The amount of formatting and structural information stored in the | |
| table or index. Metadata includes the btree page header, the cell pointer | |
| array, the size field for each cell, the left child pointer or non-leaf | |
| cells, the overflow pointers for overflow cells, and the rowid value for | |
| rowid table cells. In other words, metadata is everything that is neither | |
| unused space nor content. The record header in the payload is counted as | |
| content, not metadata. | |
| Average payload per entry | |
| The average amount of payload on each entry. This is just the bytes of | |
| payload divided by the number of entries. | |
| Average unused bytes per entry | |
| The average amount of free space remaining on all pages under this | |
| category on a per-entry basis. This is the number of unused bytes on | |
| all pages divided by the number of entries. | |
| Non-sequential pages | |
| The number of pages in the table or index that are out of sequence. | |
| Many filesystems are optimized for sequential file access so a small | |
| number of non-sequential pages might result in faster queries, | |
| especially for larger database files that do not fit in the disk cache. | |
| Note that after running VACUUM, the root page of each table or index is | |
| at the beginning of the database file and all other pages are in a | |
| separate part of the database file, resulting in a single non- | |
| sequential page. | |
| Maximum payload per entry | |
| The largest payload size of any entry. | |
| Entries that use overflow | |
| The number of entries that user one or more overflow pages. | |
| Total pages used | |
| This is the number of pages used to hold all information in the current | |
| category. This is the sum of index, primary, and overflow pages. | |
| Index pages used | |
| This is the number of pages in a table B-tree that hold only key (rowid) | |
| information and no data. | |
| Primary pages used | |
| This is the number of B-tree pages that hold both key and data. | |
| Overflow pages used | |
| The total number of overflow pages used for this category. | |
| Unused bytes on index pages | |
| The total number of bytes of unused space on all index pages. The | |
| percentage at the right is the number of unused bytes divided by the | |
| total number of bytes on index pages. | |
| Unused bytes on primary pages | |
| The total number of bytes of unused space on all primary pages. The | |
| percentage at the right is the number of unused bytes divided by the | |
| total number of bytes on primary pages. | |
| Unused bytes on overflow pages | |
| The total number of bytes of unused space on all overflow pages. The | |
| percentage at the right is the number of unused bytes divided by the | |
| total number of bytes on overflow pages. | |
| Unused bytes on all pages | |
| The total number of bytes of unused space on all primary and overflow | |
| pages. The percentage at the right is the number of unused bytes | |
| divided by the total number of bytes. | |
| ******************************************************************************* | |
| The entire text of this report can be sourced into any SQL database | |
| engine for further analysis. All of the text above is an SQL comment. | |
| The data used to generate this report follows: | |
| */ | |
| BEGIN; | |
| 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 | |
| ); | |
| INSERT INTO space_used VALUES('sqlite_schema','sqlite_schema',0,0,184,175,2,36360,0,0,1389,1,10,0,3920,3678,0,10,45056); | |
| INSERT INTO space_used VALUES('action_mailbox_inbound_emails','action_mailbox_inbound_emails',0,0,5351,5167,2,703957,0,0,167,1,185,0,2616,21448,0,3,761856); | |
| INSERT INTO space_used VALUES('sqlite_sequence','sqlite_sequence',0,0,37,37,1,647,0,0,34,0,1,0,0,3293,0,0,4096); | |
| INSERT INTO space_used VALUES('active_storage_blobs','active_storage_blobs',0,0,5373,5167,2,811023,0,0,158,1,207,0,2441,4318,0,4,851968); | |
| INSERT INTO space_used VALUES('categories','categories',0,0,12,12,1,1031,0,0,90,0,1,0,0,3009,0,0,4096); | |
| INSERT INTO space_used VALUES('comment_stats','comment_stats',0,0,4973,4949,2,74313,0,0,22,1,25,0,3892,3269,0,1,106496); | |
| INSERT INTO space_used VALUES('invitation_requests','invitation_requests',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096); | |
| INSERT INTO space_used VALUES('keystores','keystores',0,0,70558,70011,3,1815401,0,0,39,3,548,0,7346,12174,0,1,2256896); | |
| INSERT INTO space_used VALUES('mastodon_apps','mastodon_apps',0,0,250,241,2,38057,0,0,216,1,10,0,4017,1504,0,1,45056); | |
| INSERT INTO space_used VALUES('mod_activities','mod_activities',0,0,24701,24106,3,2266303,0,0,109,3,596,0,7304,42019,0,1,2453504); | |
| INSERT INTO space_used VALUES('mod_mails','mod_mails',0,0,271,265,2,23843,0,0,90,1,7,0,4038,3557,0,1,32768); | |
| INSERT INTO space_used VALUES('story_texts','story_texts',0,0,196208,127876,3,1149927645,940102346,72026,1492891,170,68333,230450,88592,68351637,2899054,2,1224511488); | |
| INSERT INTO space_used VALUES('active_storage_attachments','active_storage_attachments',0,0,5266,5167,2,376935,0,0,73,1,100,0,3294,6157,0,3,413696); | |
| INSERT INTO space_used VALUES('active_storage_variant_records','active_storage_variant_records',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096); | |
| INSERT INTO space_used VALUES('domains','domains',0,0,35604,34703,3,3449925,0,0,306,3,902,0,4565,45243,0,1,3706880); | |
| INSERT INTO space_used VALUES('hat_requests','hat_requests',0,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096); | |
| INSERT INTO space_used VALUES('hats','hats',0,0,294,284,2,39482,0,0,246,1,11,0,4008,4010,0,1,49152); | |
| INSERT INTO space_used VALUES('hidden_stories','hidden_stories',0,0,260698,256824,3,14218052,0,0,75,11,3875,0,10262,97788,0,1,15917056); | |
| INSERT INTO space_used VALUES('invitations','invitations',0,0,13199,12687,3,1978373,0,0,520,3,513,0,8156,43330,0,1,2113536); | |
| INSERT INTO space_used VALUES('links','links',0,0,287611,278022,3,36651079,0,0,637,25,9590,0,16302,769917,0,2,39383040); | |
| INSERT INTO space_used VALUES('messages','messages',0,0,22556,19691,3,11140303,825774,151,65887,8,2866,205,8932,1278274,13086,1,12611584); | |
| INSERT INTO space_used VALUES('mod_mail_messages','mod_mail_messages',0,0,396,334,2,233635,0,0,3426,1,63,0,3610,22036,0,1,262144); | |
| INSERT INTO space_used VALUES('mod_mail_recipients','mod_mail_recipients',0,0,537,529,2,32556,0,0,62,1,9,0,4021,1686,0,1,40960); | |
| INSERT INTO space_used VALUES('mod_mail_references','mod_mail_references',0,0,4,4,1,284,0,0,71,0,1,0,0,3788,0,0,4096); | |
| INSERT INTO space_used VALUES('mod_notes','mod_notes',0,0,11058,9045,3,7812040,722026,122,47726,6,2014,178,8427,1088587,6350,1,9003008); | |
| INSERT INTO space_used VALUES('moderations','moderations',0,0,15615,14796,3,3238938,125588,13,65559,3,820,31,5701,151314,1264,1,3497984); | |
| INSERT INTO space_used VALUES('notifications','notifications',0,0,534308,515887,3,71083016,0,0,144,47,18422,0,26748,633892,0,3,75649024); | |
| INSERT INTO space_used VALUES('origins','origins',0,0,8420,8170,2,970113,0,0,252,1,251,0,2087,15009,0,1,1032192); | |
| INSERT INTO space_used VALUES('read_ribbons','read_ribbons',0,0,2391948,2358585,3,118508280,0,0,64,94,33364,0,50266,1373669,0,9,137043968); | |
| INSERT INTO space_used VALUES('saved_stories','saved_stories',0,0,236267,230904,3,20100630,0,0,101,14,5364,0,9250,457000,0,1,22028288); | |
| INSERT INTO space_used VALUES('stories','stories',0,0,141472,128027,3,52587868,2918386,366,90612,34,13446,721,19488,4416585,31946,1,58167296); | |
| INSERT INTO space_used VALUES('suggested_taggings','suggested_taggings',0,0,32566,32418,2,426429,0,0,65,1,149,0,2822,4628,0,1,614400); | |
| INSERT INTO space_used VALUES('suggested_titles','suggested_titles',0,0,6380,6289,2,340556,0,0,145,1,92,0,3357,4214,0,1,380928); | |
| INSERT INTO space_used VALUES('tag_filters','tag_filters',0,0,19716,19466,2,914553,0,0,61,1,251,0,1979,6119,0,1,1032192); | |
| INSERT INTO space_used VALUES('taggings','taggings',0,0,228924,228162,3,1763470,0,0,8,3,763,0,5441,3044,0,1,3137536); | |
| INSERT INTO space_used VALUES('tags','tags',0,0,119,116,2,13302,0,0,183,1,4,0,4063,2567,0,1,20480); | |
| INSERT INTO space_used VALUES('usernames','usernames',0,0,21892,21675,2,772263,0,0,71,1,218,0,2296,5381,0,1,897024); | |
| INSERT INTO space_used VALUES('users','users',0,0,24409,20479,3,14512866,77748,1,79809,10,3931,19,8621,1507945,0,1,16220160); | |
| INSERT INTO space_used VALUES('votes','votes',0,0,1823821,1806733,3,57657374,0,0,44,47,17089,0,28845,396620,0,22,70189056); | |
| INSERT INTO space_used VALUES('comments_fts_data','comments_fts_data',0,0,74766,37994,3,148857261,0,0,4057,125,36773,0,69241,1091967,0,13,151134208); | |
| INSERT INTO space_used VALUES('comments_fts_idx','comments_fts_idx',0,1,15893,15825,2,229293,0,0,142,1,69,0,2606,6305,0,3,286720); | |
| INSERT INTO space_used VALUES('comments_fts_docsize','comments_fts_docsize',0,0,702162,699970,3,4766830,0,0,8,7,2193,0,8903,14838,0,1,9011200); | |
| INSERT INTO space_used VALUES('comments_fts_config','comments_fts_config',0,1,1,1,1,11,0,0,11,0,1,0,0,4074,0,0,4096); | |
| INSERT INTO space_used VALUES('story_texts_fts_data','story_texts_fts_data',0,0,266914,136931,4,526278058,40477,2,32782,438,129984,10,228922,3774401,443,3,534249472); | |
| INSERT INTO space_used VALUES('story_texts_fts_idx','story_texts_fts_idx',0,1,79223,78872,3,1204695,900,1,1389,4,352,1,8037,4388,3192,1,1462272); | |
| INSERT INTO space_used VALUES('story_texts_fts_docsize','story_texts_fts_docsize',0,0,128363,127876,3,1238533,0,0,12,3,488,0,7925,5661,0,1,2011136); | |
| INSERT INTO space_used VALUES('story_texts_fts_config','story_texts_fts_config',0,1,1,1,1,11,0,0,11,0,1,0,0,4074,0,0,4096); | |
| INSERT INTO space_used VALUES('schema_migrations','schema_migrations',0,0,15,15,1,240,0,0,16,0,1,0,0,3788,0,0,4096); | |
| INSERT INTO space_used VALUES('sqlite_autoindex_schema_migrations_1','schema_migrations',1,0,15,15,1,269,0,0,18,0,1,0,0,3774,0,0,4096); | |
| INSERT INTO space_used VALUES('ar_internal_metadata','ar_internal_metadata',0,0,2,2,1,186,0,0,108,0,1,0,0,3894,0,0,4096); | |
| INSERT INTO space_used VALUES('sqlite_autoindex_ar_internal_metadata_1','ar_internal_metadata',1,0,2,2,1,29,0,0,15,0,1,0,0,4053,0,0,4096); | |
| INSERT INTO space_used VALUES('comments','comments',0,0,901182,699970,4,753938126,82703674,17380,113343,507,201213,20573,263903,146371290,1481042,14,910512128); | |
| INSERT INTO space_used VALUES('index_action_mailbox_inbound_emails_uniqueness','action_mailbox_inbound_emails',1,0,5167,5062,3,424825,0,0,113,4,106,0,6974,1944,0,2,450560); | |
| INSERT INTO space_used VALUES('index_active_storage_blobs_on_key','active_storage_blobs',1,0,5167,5113,2,170383,0,0,33,1,55,0,1924,40900,0,8,229376); | |
| INSERT INTO space_used VALUES('index_categories_on_category','categories',1,0,12,12,1,130,0,0,15,0,1,0,0,3922,0,0,4096); | |
| INSERT INTO space_used VALUES('index_categories_on_token','categories',1,0,12,12,1,467,0,0,39,0,1,0,0,3585,0,0,4096); | |
| INSERT INTO space_used VALUES('index_comment_stats_on_date','comment_stats',1,0,4949,4928,2,74107,0,0,15,1,22,0,3622,1360,0,1,94208); | |
| INSERT INTO space_used VALUES('index_invitation_requests_on_token','invitation_requests',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096); | |
| INSERT INTO space_used VALUES('key','keystores',1,0,70011,69502,3,1880107,0,0,41,6,510,0,6707,10501,0,1,2113536); | |
| INSERT INTO space_used VALUES('index_mastodon_apps_on_name','mastodon_apps',1,0,241,240,2,4474,0,0,33,1,2,0,4058,3001,0,1,12288); | |
| INSERT INTO space_used VALUES('index_mod_activities_on_item_type_and_item_id','mod_activities',1,0,24106,23990,2,405575,0,0,18,1,117,0,1305,2718,0,1,483328); | |
| INSERT INTO space_used VALUES('index_mod_activities_on_token','mod_activities',1,0,24106,23836,3,1036430,0,0,43,5,271,0,6921,11519,0,1,1130496); | |
| INSERT INTO space_used VALUES('index_mod_mails_on_short_id','mod_mails',1,0,265,265,1,2805,0,0,11,0,1,0,0,488,0,0,4096); | |
| INSERT INTO space_used VALUES('index_active_storage_attachments_on_blob_id','active_storage_attachments',1,0,5167,5155,2,35913,0,0,7,1,13,0,3916,1850,0,1,57344); | |
| INSERT INTO space_used VALUES('index_active_storage_attachments_uniqueness','active_storage_attachments',1,0,5167,5104,2,247632,0,0,48,1,64,0,622,1709,0,2,266240); | |
| INSERT INTO space_used VALUES('index_active_storage_variant_records_uniqueness','active_storage_variant_records',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096); | |
| INSERT INTO space_used VALUES('index_domains_on_banned_by_user_id','domains',1,0,34703,34635,2,175847,0,0,8,1,69,0,3263,2665,0,1,286720); | |
| INSERT INTO space_used VALUES('index_domains_on_domain','domains',1,0,34703,34504,3,710379,0,0,157,3,200,0,6555,8012,0,2,831488); | |
| INSERT INTO space_used VALUES('index_domains_on_token','domains',1,0,34703,34356,3,1320724,0,0,39,5,348,0,4784,12039,0,1,1445888); | |
| INSERT INTO space_used VALUES('index_hat_requests_on_token','hat_requests',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096); | |
| INSERT INTO space_used VALUES('hat_requests_user_id_fk','hat_requests',1,0,0,0,1,0,0,0,0,0,1,0,0,4088,0,0,4096); | |
| INSERT INTO space_used VALUES('hats_granted_by_user_id_fk','hats',1,0,284,284,1,1504,0,0,7,0,1,0,0,1732,0,0,4096); | |
| INSERT INTO space_used VALUES('index_hats_on_token','hats',1,0,284,282,2,9813,0,0,35,1,3,0,4001,1674,0,1,16384); | |
| INSERT INTO space_used VALUES('hats_user_id_fk','hats',1,0,284,284,1,1851,0,0,7,0,1,0,0,1385,0,0,4096); | |
| INSERT INTO space_used VALUES('hidden_stories_story_id_fk','hidden_stories',1,0,256824,256086,3,2251024,0,0,9,4,739,0,4674,8246,0,1,3043328); | |
| INSERT INTO space_used VALUES('index_hidden_stories_on_token','hidden_stories',1,0,256824,253898,3,11268967,0,0,44,38,2927,0,6297,63328,0,1,12144640); | |
| INSERT INTO space_used VALUES('index_hidden_stories_on_user_id_and_story_id','hidden_stories',1,0,256824,255896,3,3020977,0,0,12,6,929,0,7061,20034,0,4,3829760); | |
| INSERT INTO space_used VALUES('invitations_new_user_id_fk','invitations',1,0,12687,12657,2,84875,0,0,7,1,31,0,3670,4086,0,1,131072); | |
| INSERT INTO space_used VALUES('index_invitations_on_token','invitations',1,0,12687,12548,3,532836,0,0,42,3,140,0,5441,7678,0,1,585728); | |
| INSERT INTO space_used VALUES('invitations_user_id_fk','invitations',1,0,12687,12657,2,88449,0,0,7,1,31,0,3664,518,0,1,131072); | |
| INSERT INTO space_used VALUES('index_links_on_from_comment_id','links',1,0,278022,277280,3,2201199,0,0,9,4,743,0,5141,10346,0,2,3059712); | |
| INSERT INTO space_used VALUES('index_links_on_from_story_id','links',1,0,278022,277353,3,1903315,0,0,9,4,670,0,6913,8326,0,2,2760704); | |
| INSERT INTO space_used VALUES('index_links_on_normalized_url','links',1,0,278022,274457,4,13815629,0,0,246,65,3566,0,23749,153272,0,11,14872576); | |
| INSERT INTO space_used VALUES('idx_links_on_to_comment_id_and_from_story_id_and_from_comment_id','links',1,0,278022,277077,3,3037095,0,0,14,6,946,0,7549,9262,0,3,3899392); | |
| INSERT INTO space_used VALUES('index_links_on_to_story_id_and_from_story_id_and_from_comment_id','links',1,0,278022,277074,3,3044804,0,0,14,6,949,0,7461,13893,0,4,3911680); | |
| INSERT INTO space_used VALUES('index_links_on_url_and_from_story_id_and_from_comment_id','links',1,0,278022,273393,4,18242346,0,0,262,99,4630,0,25017,205600,0,7,19369984); | |
| INSERT INTO space_used VALUES('index_messages_on_author_user_id','messages',1,0,19691,19646,2,126955,0,0,7,1,46,0,3476,2448,0,1,192512); | |
| INSERT INTO space_used VALUES('index_messages_on_hat_id','messages',1,0,19691,19653,2,99838,0,0,7,1,39,0,3625,828,0,1,163840); | |
| INSERT INTO space_used VALUES('messages_recipient_user_id_fk','messages',1,0,19691,19644,2,135341,0,0,7,1,48,0,3432,2274,0,1,200704); | |
| INSERT INTO space_used VALUES('random_hash','messages',1,0,19691,19624,2,216495,0,0,11,1,68,0,2878,3354,0,1,282624); | |
| INSERT INTO space_used VALUES('index_messages_on_token','messages',1,0,19691,19491,3,767843,0,0,39,4,201,0,7137,3171,0,1,839680); | |
| INSERT INTO space_used VALUES('index_mod_mail_messages_on_mod_mail_id','mod_mail_messages',1,0,334,334,1,2091,0,0,7,0,1,0,0,995,0,0,4096); | |
| INSERT INTO space_used VALUES('fk_rails_40fa20cab5','mod_mail_messages',1,0,334,334,1,2221,0,0,7,0,1,0,0,865,0,0,4096); | |
| INSERT INTO space_used VALUES('index_mod_mail_recipients_on_mod_mail_id','mod_mail_recipients',1,0,529,528,2,3387,0,0,7,1,2,0,4070,3212,0,1,12288); | |
| INSERT INTO space_used VALUES('fk_rails_7a6d5232be','mod_mail_recipients',1,0,529,528,2,3585,0,0,7,1,2,0,4070,3014,0,1,12288); | |
| INSERT INTO space_used VALUES('index_mod_mail_references_on_mod_mail_id','mod_mail_references',1,0,4,4,1,23,0,0,6,0,1,0,0,4053,0,0,4096); | |
| INSERT INTO space_used VALUES('index_mod_mail_references_on_reference','mod_mail_references',1,0,4,4,1,59,0,0,15,0,1,0,0,4017,0,0,4096); | |
| INSERT INTO space_used VALUES('index_mod_notes_on_id_and_user_id','mod_notes',1,0,9045,9017,2,90141,0,0,10,1,29,0,3608,1640,0,1,122880); | |
| INSERT INTO space_used VALUES('mod_notes_moderator_user_id_fk','mod_notes',1,0,9045,9024,2,59677,0,0,7,1,22,0,3797,3327,0,1,94208); | |
| INSERT INTO space_used VALUES('index_mod_notes_on_token','mod_notes',1,0,9045,8953,3,352627,0,0,39,3,93,0,8021,4285,0,1,393216); | |
| INSERT INTO space_used VALUES('mod_notes_user_id_fk','mod_notes',1,0,9045,9023,2,63134,0,0,7,1,23,0,3776,3975,0,1,98304); | |
| INSERT INTO space_used VALUES('index_moderations_on_category_id','moderations',1,0,14796,14768,2,73943,0,0,5,1,29,0,3748,445,0,1,122880); | |
| INSERT INTO space_used VALUES('moderations_comment_id_fk','moderations',1,0,14796,14766,2,79938,0,0,8,1,31,0,3706,2660,0,1,131072); | |
| INSERT INTO space_used VALUES('index_moderations_on_created_at','moderations',1,0,14796,14699,2,355410,0,0,31,1,98,0,1077,3445,0,1,405504); | |
| INSERT INTO space_used VALUES('index_moderations_on_domain_id','moderations',1,0,14796,14767,2,74593,0,0,8,1,30,0,3733,3894,0,1,126976); | |
| INSERT INTO space_used VALUES('moderations_moderator_user_id_fk','moderations',1,0,14796,14765,2,82921,0,0,7,1,32,0,3693,3774,0,1,135168); | |
| INSERT INTO space_used VALUES('index_moderations_on_origin_id','moderations',1,0,14796,14768,2,74001,0,0,7,1,29,0,3748,387,0,1,122880); | |
| INSERT INTO space_used VALUES('moderations_story_id_fk','moderations',1,0,14796,14760,2,103282,0,0,8,1,37,0,3572,3954,0,1,155648); | |
| INSERT INTO space_used VALUES('moderations_tag_id_fk','moderations',1,0,14796,14768,2,73985,0,0,6,1,29,0,3748,403,0,1,122880); | |
| INSERT INTO space_used VALUES('index_moderations_on_token','moderations',1,0,14796,14634,3,621395,0,0,42,3,163,0,4314,7851,0,1,679936); | |
| INSERT INTO space_used VALUES('index_moderations_on_user_id','moderations',1,0,14796,14767,2,78102,0,0,7,1,30,0,3726,392,0,1,126976); | |
| INSERT INTO space_used VALUES('index_notifications_on_notifiable','notifications',1,0,515887,513387,3,8701811,0,0,23,16,2501,0,5653,24307,0,2,10309632); | |
| INSERT INTO space_used VALUES('index_notifications_on_token','notifications',1,0,515887,509893,3,23182020,0,0,45,77,5995,0,3157,65214,0,1,24870912); | |
| INSERT INTO space_used VALUES('idx_on_user_id_notifiable_type_notifiable_id_ffac34041e','notifications',1,0,515887,512997,3,10239701,0,0,26,24,2891,0,20371,97131,0,15,11939840); | |
| INSERT INTO space_used VALUES('index_origins_on_banned_by_user_id','origins',1,0,8170,8155,2,40751,0,0,6,1,16,0,3904,267,0,1,69632); | |
| INSERT INTO space_used VALUES('index_origins_on_domain_id','origins',1,0,8170,8151,2,57062,0,0,7,1,20,0,3818,378,0,1,86016); | |
| INSERT INTO space_used VALUES('index_origins_on_identifier','origins',1,0,8170,8114,2,206482,0,0,87,1,57,0,2253,3631,0,1,237568); | |
| INSERT INTO space_used VALUES('index_origins_on_token','origins',1,0,8170,8089,2,310332,0,0,38,1,82,0,440,3694,0,1,339968); | |
| INSERT INTO space_used VALUES('index_read_ribbons_on_story_id','read_ribbons',1,0,2358585,2351135,3,23327493,0,0,10,34,7451,0,12971,152525,0,24,30658560); | |
| INSERT INTO space_used VALUES('index_read_ribbons_on_user_id','read_ribbons',1,0,2358585,2351501,3,20960752,0,0,9,33,7085,0,22148,1011261,0,110,29155328); | |
| INSERT INTO space_used VALUES('saved_stories_story_id_fk','saved_stories',1,0,230904,230235,3,2047656,0,0,9,4,670,0,5715,6537,0,1,2760704); | |
| INSERT INTO space_used VALUES('index_saved_stories_on_token','saved_stories',1,0,230904,228317,3,9900031,0,0,43,33,2588,0,5738,105687,0,1,10735616); | |
| INSERT INTO space_used VALUES('index_saved_stories_on_user_id_and_story_id','saved_stories',1,0,230904,230063,3,2739653,0,0,12,5,842,0,4543,22244,0,4,3469312); | |
| INSERT INTO space_used VALUES('index_stories_on_created_at','stories',1,0,128027,127164,3,3169058,0,0,32,8,864,0,5264,2849,0,1,3571712); | |
| INSERT INTO space_used VALUES('index_stories_on_domain_id','stories',1,0,128027,127691,3,987016,0,0,9,3,337,0,7296,10171,0,3,1392640); | |
| INSERT INTO space_used VALUES('hotness_idx','stories',1,0,128027,127503,3,1759487,0,0,14,4,525,0,5461,11411,0,2,2166784); | |
| INSERT INTO space_used VALUES('index_stories_on_id_and_is_deleted','stories',1,0,128027,127637,3,1214488,0,0,10,3,391,0,5798,4733,0,1,1613824); | |
| INSERT INTO space_used VALUES('index_stories_on_last_comment_at','stories',1,0,128027,127400,3,2187740,0,0,32,7,628,0,10227,11296,0,2,2600960); | |
| INSERT INTO space_used VALUES('index_stories_on_mastodon_id','stories',1,0,128027,127652,3,1151483,0,0,24,3,376,0,4702,7574,0,2,1552384); | |
| INSERT INTO space_used VALUES('index_stories_on_merged_story_id_and_hotness','stories',1,0,128027,127472,3,1890258,0,0,18,4,556,0,4247,8458,0,2,2293760); | |
| INSERT INTO space_used VALUES('index_stories_on_normalized_url','stories',1,0,128027,126220,3,7047006,0,0,245,36,1808,0,15707,83116,0,5,7553024); | |
| INSERT INTO space_used VALUES('index_stories_on_origin_id','stories',1,0,128027,127747,2,759348,0,0,8,1,281,0,447,7816,0,2,1155072); | |
| INSERT INTO space_used VALUES('index_stories_on_score','stories',1,0,128027,127708,3,850807,0,0,8,3,320,0,7889,76359,0,18,1323008); | |
| INSERT INTO space_used VALUES('unique_short_id','stories',1,0,128027,127563,3,1503433,0,0,12,4,465,0,7630,20256,0,5,1921024); | |
| INSERT INTO space_used VALUES('index_stories_on_token','stories',1,0,128027,126757,3,4832135,0,0,38,15,1271,0,4429,31383,0,1,5267456); | |
| INSERT INTO space_used VALUES('url','stories',1,0,128027,125915,3,8330947,0,0,257,44,2113,0,6474,85725,0,2,8835072); | |
| INSERT INTO space_used VALUES('index_stories_on_user_id','stories',1,0,128027,127690,3,983024,0,0,8,3,338,0,7299,18244,0,4,1396736); | |
| INSERT INTO space_used VALUES('suggested_taggings_story_id_fk','suggested_taggings',1,0,32418,32333,2,253843,0,0,8,1,86,0,2822,1393,0,1,356352); | |
| INSERT INTO space_used VALUES('suggested_taggings_tag_id_fk','suggested_taggings',1,0,32418,32345,2,194203,0,0,6,1,74,0,3135,11712,0,2,307200); | |
| INSERT INTO space_used VALUES('suggested_taggings_user_id_fk','suggested_taggings',1,0,32418,32339,2,225395,0,0,7,1,80,0,2979,5180,0,2,331776); | |
| INSERT INTO space_used VALUES('suggested_titles_story_id_fk','suggested_titles',1,0,6289,6273,2,49403,0,0,8,1,17,0,3845,1401,0,1,73728); | |
| INSERT INTO space_used VALUES('suggested_titles_user_id_fk','suggested_titles',1,0,6289,6274,2,43472,0,0,7,1,16,0,3874,3219,0,1,69632); | |
| INSERT INTO space_used VALUES('tag_filters_tag_id_fk','tag_filters',1,0,19466,19424,2,116364,0,0,6,1,43,0,3538,1400,0,1,180224); | |
| INSERT INTO space_used VALUES('user_tag_idx','tag_filters',1,0,19466,19410,2,174438,0,0,9,1,57,0,3189,851,0,1,237568); | |
| INSERT INTO space_used VALUES('story_id_tag_id','taggings',1,0,228162,227406,3,2415409,0,0,11,5,757,0,7089,5028,0,1,3121152); | |
| INSERT INTO space_used VALUES('taggings_tag_id_fk','taggings',1,0,228162,227610,3,1562030,0,0,7,3,553,0,4603,19589,0,3,2277376); | |
| INSERT INTO space_used VALUES('index_tags_on_category_id','tags',1,0,116,116,1,570,0,0,5,0,1,0,0,3170,0,0,4096); | |
| INSERT INTO space_used VALUES('tag','tags',1,0,116,116,1,1189,0,0,18,0,1,0,0,2551,0,0,4096); | |
| INSERT INTO space_used VALUES('index_tags_on_token','tags',1,0,116,115,2,3943,0,0,34,1,2,0,4043,3922,0,1,12288); | |
| INSERT INTO space_used VALUES('fk_rails_74bbef8f63','usernames',1,0,21675,21623,2,151464,0,0,7,1,53,0,3356,695,0,1,221184); | |
| INSERT INTO space_used VALUES('users_banned_by_user_id_fk','users',1,0,20479,20439,2,102646,0,0,6,1,41,0,3603,3846,0,1,172032); | |
| INSERT INTO space_used VALUES('users_disabled_invite_by_user_id_fk','users',1,0,20479,20440,2,102339,0,0,6,1,40,0,3616,56,0,1,167936); | |
| INSERT INTO space_used VALUES('index_users_on_email','users',1,0,20479,20340,3,512260,0,0,66,3,140,0,7686,2633,0,1,585728); | |
| INSERT INTO space_used VALUES('users_invited_by_user_id_fk','users',1,0,20479,20430,2,141999,0,0,7,1,50,0,3400,1452,0,1,208896); | |
| INSERT INTO space_used VALUES('mailing_list_enabled','users',1,0,20479,20440,2,102327,0,0,6,1,40,0,3616,68,0,1,167936); | |
| INSERT INTO space_used VALUES('mailing_list_token','users',1,0,20479,20390,2,307057,0,0,15,1,90,0,2127,1027,0,1,372736); | |
| INSERT INTO space_used VALUES('password_reset_token','users',1,0,20479,20436,2,116371,0,0,46,1,44,0,3404,2572,0,1,184320); | |
| INSERT INTO space_used VALUES('rss_token','users',1,0,20479,20138,3,1345953,0,0,66,8,342,0,7836,14178,0,1,1433600); | |
| INSERT INTO space_used VALUES('session_hash','users',1,0,20479,20137,3,1351486,0,0,66,8,343,0,7708,12857,0,2,1437696); | |
| INSERT INTO space_used VALUES('index_users_on_token','users',1,0,20479,20284,3,737116,0,0,36,4,196,0,7952,10299,0,1,819200); | |
| INSERT INTO space_used VALUES('username','users',1,0,20479,20402,2,257428,0,0,30,1,78,0,2579,1196,0,1,323584); | |
| INSERT INTO space_used VALUES('index_votes_on_comment_id','votes',1,0,1806733,1802766,3,10827213,0,0,9,14,3968,0,5623,9457,0,6,16310272); | |
| INSERT INTO space_used VALUES('votes_story_id_fk','votes',1,0,1806733,1801499,3,15950077,0,0,9,22,5235,0,6927,92389,0,18,21532672); | |
| INSERT INTO space_used VALUES('user_id_comment_id','votes',1,0,1806733,1801062,3,16216294,0,0,12,26,5672,0,15565,1618578,0,387,23339008); | |
| INSERT INTO space_used VALUES('user_id_story_id','votes',1,0,1806733,1799791,3,21339158,0,0,12,39,6943,0,28577,1726558,0,400,28598272); | |
| INSERT INTO space_used VALUES('confidence_idx','comments',1,0,699970,697079,3,9676699,0,0,14,20,2892,0,21285,94718,0,16,11927552); | |
| INSERT INTO space_used VALUES('comments_hat_id_fk','comments',1,0,699970,698438,3,4171391,0,0,8,6,1533,0,4638,9341,0,2,6303744); | |
| INSERT INTO space_used VALUES('comments_parent_comment_id_fk','comments',1,0,699970,698110,3,5512481,0,0,9,9,1861,0,8720,15973,0,2,7659520); | |
| INSERT INTO space_used VALUES('index_comments_on_score','comments',1,0,699970,698300,3,4672242,0,0,8,7,1671,0,5706,75098,0,16,6873088); | |
| INSERT INTO space_used VALUES('short_id','comments',1,0,699970,697391,3,8366751,0,0,12,15,2580,0,12369,118954,0,26,10629120); | |
| INSERT INTO space_used VALUES('story_id_short_id','comments',1,0,699970,696760,3,11075362,0,0,16,19,3211,0,4293,11759,0,1,13230080); | |
| INSERT INTO space_used VALUES('thread_id','comments',1,0,699970,697932,3,6242465,0,0,9,9,2039,0,4289,17372,0,1,8388608); | |
| INSERT INTO space_used VALUES('index_comments_on_token','comments',1,0,699970,692686,3,27965911,0,0,40,85,7285,0,5127,28136,0,1,30187520); | |
| INSERT INTO space_used VALUES('index_comments_on_user_id','comments',1,0,699970,698080,3,5556580,0,0,8,9,1891,0,8509,94605,0,21,7782400); | |
| COMMIT; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment