Table stats
Total size: 7.7 GB
Session original writes: 798.0 MB (79.0 MB buffered)
Session compactation writes: 1.8 GB
Session original writes: 798.0 MB (79.0 MB buffered)
Session compactation writes: 1.8 GB
| Name | Size on disk | # Slices | # Keys | # Values | Avg #values | Buffered | Flushed | Original writes | Compactation writes | Total writes |
|---|---|---|---|---|---|---|---|---|---|---|
| did-doc-6 | 1007.7 MB | 16 | 37M | 681M | 18 | 0 KB | 1m | 5.4 MB | 56.2 MB | 61.6 MB |
| profile-search-prefix | 833.8 MB | 6 | 28M | 118M | 4.1 | 4.8 KB | 1m | 19.8 MB | 71.0 MB | 90.8 MB |
| post-data-time-first-2 | 768.0 MB | 8 | 6.1M | 699M | 114 | 4.8 MB | 4h | 188.3 MB | 462.8 MB | 651.1 MB |
| did-hash-to-user-id | 707.2 MB | 9 | 37M | 37M | (1) | 1.6 MB | May 12 | 2.8 MB | 1.5 MB | 4.3 MB |
| plc-to-did-plc | 707.2 MB | 15 | 37M | 37M | (1) | 1.4 MB | May 12 | 2.8 MB | 10.3 MB | 13.1 MB |
| handle-to-possible-dids | 663.3 MB | 13 | 38M | 39M | 1.0 | 5.6 MB | May 12 | 3.7 MB | 14.1 MB | 17.8 MB |
| post-text-approx-time-32 | 465.5 MB | 4 | 6.3M | 100M | 15 | 1.4 MB | 54m | 153.3 MB | 319.1 MB | 472.5 MB |
| profile-search-prefix-2-letters | 448.9 MB | 14 | 17K | 117M | 6.7K | 2.8 KB | 1m | 8.2 MB | 21.3 MB | 29.6 MB |
| post-like-time-first | 419.2 MB | 8 | 6.5M | 26M | 4.1 | 67.6 KB | May 11 | 24.0 MB | 37.8 MB | 61.7 MB |
| profile-search-long | 380.7 MB | 9 | 22M | 22M | 1.0 | 5.6 MB | May 12 | 2.6 MB | 381.3 MB | 383.9 MB |
| list-membership-2 | 262.8 MB | 30 | 5.3M | 11M | 2.0 | 1.5 KB | May 12 | 50.7 MB | 83.8 MB | 134.5 MB |
| post-like-time-first-rkey-hash-to-approx-target24 | 230.2 MB | 7 | 26M | 26M | (1) | 48.9 KB | May 11 | 10.0 MB | 15.4 MB | 25.4 MB |
| list-item | 127.9 MB | 26 | 62K | 11M | 178 | 0.6 KB | May 12 | 22.1 MB | 59.8 MB | 81.9 MB |
| follow | 107.3 MB | 13 | 3.5M | 6.4M | 1.8 | 5.8 KB | May 12 | 12.6 MB | 27.5 MB | 40.1 MB |
| block | 89.8 MB | 14 | 2.6M | 5.6M | 2.1 | 79.9 KB | May 12 | 87.6 MB | 88.5 MB | 176.1 MB |
| user-to-recent-posts-2 | 75.9 MB | 8 | 1.3M | 6.1M | 4.5 | 8.3 MB | 9h | 13.8 MB | 34.5 MB | 48.3 MB |
| user-to-recent-reposts-2 | 81.7 MB | 15 | 883K | 3.8M | 4.3 | 10.2 KB | May 11 | 3.9 MB | 0 KB | 3.9 MB |
| profile-basic-2 | 78.3 MB | 13 | 569K | 77M | 136 | 1.3 MB | 1h | 63.0 MB | 16.1 MB | 79.0 MB |
| post-reply-direct-2 | 69.0 MB | 9 | 2.2M | 3.0M | 1.3 | 5.8 MB | 6h | 18.0 MB | 28.2 MB | 46.2 MB |
| post-repost-time-first | 64.5 MB | 13 | 1.1M | 3.8M | 3.2 | 9.9 KB | May 11 | 3.6 MB | 5.1 MB | 8.7 MB |
| follow-rkey-hash-to-approx-target24 | 55.4 MB | 13 | 6.4M | 6.4M | (1) | 4.8 KB | May 12 | 5.7 MB | 15.9 MB | 21.7 MB |
| block-rkey-hash-to-approx-target24 | 48.4 MB | 12 | 5.6M | 5.6M | (1) | 66.7 KB | May 12 | 39.1 MB | 51.3 MB | 90.4 MB |
| profile-search-description-only | 36.4 MB | 7 | 812K | 8.6M | 10 | 9.5 MB | 6h | 34.2 MB | 23.8 MB | 58.1 MB |
| post-repost-time-first-rkey-hash-to-approx-target24 | 33.0 MB | 15 | 3.8M | 3.8M | (1) | 7.0 KB | May 11 | 1.5 MB | 0 KB | 1.5 MB |
| handle-verifications | 10.2 MB | 14 | 542K | 543K | 1.0 | 7.1 MB | 9h | 9.4 MB | 2.6 MB | 12.1 MB |
| follow-deletion | 15.4 MB | 17 | 808K | 808K | (1) | 1.2 KB | May 12 | 656.0 KB | 806.0 KB | 1.4 MB |
| user-to-recent-media-posts | 10.3 MB | 15 | 501K | 1.1M | 2.3 | 4.4 MB | May 12 | 966.2 KB | 5.6 MB | 6.6 MB |
| post-quote-2 | 8.3 MB | 10 | 280K | 507K | 1.8 | 3.4 MB | May 12 | 629.0 KB | 1.3 MB | 1.9 MB |
| post-like-time-first-deletion | 10.9 MB | 10 | 572K | 572K | (1) | 0.5 KB | May 11 | 272.1 KB | 742.2 KB | 1014.3 KB |
| car-import-proto-2 | 2.2 MB | 8 | 224K | 1.9M | 8.5 | 6.0 MB | May 12 | 1.5 MB | 2.9 MB | 4.4 MB |
| list | 2.6 MB | 12 | 68K | 5.9M | 87 | 5.1 MB | May 12 | 1.4 MB | 2.8 MB | 4.2 MB |
| post-deletion-2 | 4.9 MB | 10 | 258K | 258K | (1) | 0.4 KB | May 11 | 276.1 KB | 606.0 KB | 882.1 KB |
| post-label | 4.5 MB | 12 | 130K | 136K | 1.0 | 2.4 KB | May 12 | 1.5 MB | 3.2 MB | 4.7 MB |
| post-repost-time-first-deletion | 3.1 MB | 15 | 160K | 160K | (1) | 0.1 KB | May 11 | 175.7 KB | 0 KB | 175.7 KB |
| threadgate-2 | 2.9 MB | 11 | 121K | 797K | 6.5 | 0.5 KB | May 11 | 128.9 KB | 214.5 KB | 343.4 KB |
| feed-generator-search | 354.5 KB | 12 | 28K | 160K | 5.6 | 2.2 MB | May 12 | 210.4 KB | 407.3 KB | 617.7 KB |
| feed-generator | 365.8 KB | 5 | 11K | 2.1M | 182 | 2.1 MB | May 12 | 217.7 KB | 515.4 KB | 733.2 KB |
| post-like-time-first-deletion-counts-2 | 2.4 MB | 6 | 156K | 156K | (1) | 0.1 KB | May 11 | 117.4 KB | 155.1 KB | 272.4 KB |
| block-deletion | 1.9 MB | 17 | 100K | 100K | (1) | 0.1 KB | May 12 | 1.1 MB | 1.9 MB | 2.9 MB |
| label-to-posts | 1.6 MB | 11 | 126 | 135K | 1.0K | 0.8 KB | May 12 | 554.3 KB | 1.1 MB | 1.6 MB |
| profile-basic-failed | 108.0 KB | 13 | 59K | 59K | 1 | 1.4 MB | May 12 | 89.2 KB | 117.9 KB | 207.1 KB |
| account-state | 84.2 KB | 14 | 63K | 63K | (1) | 1.2 MB | May 12 | 24.0 KB | 50.0 KB | 74.1 KB |
| list-block | 1.3 MB | 9 | 56K | 56K | (1) | 0.6 KB | May 12 | 1.1 MB | 1.6 MB | 2.7 MB |
| postgate-2 | 960.1 KB | 14 | 48K | 104K | 2.1 | 0.1 KB | May 11 | 42.0 KB | 0 KB | 42.0 KB |
| follow-deletion-counts-2 | 692.9 KB | 14 | 88K | 88K | (1) | 0.2 KB | May 12 | 30.2 KB | 85.6 KB | 115.8 KB |
| post-repost-time-first-deletion-counts-2 | 637.3 KB | 14 | 40K | 40K | (1) | 0.1 KB | May 11 | 28.4 KB | 0 KB | 28.4 KB |
| block-deletion-counts-2 | 559.0 KB | 19 | 71K | 71K | (1) | 0.1 KB | May 12 | 432.7 KB | 629.3 KB | 1.0 MB |
| profile-label | 384.4 KB | 12 | 14K | 14K | 1.0 | 0.2 KB | May 12 | 106.6 KB | 238.4 KB | 345.0 KB |
| post-data-failed | 30.2 KB | 8 | 8.8K | 8.8K | 1 | 271.0 KB | May 12 | 16.9 KB | 40.0 KB | 56.8 KB |
| list-item-deletion | 236.8 KB | 14 | 12K | 12K | (1) | 0.1 KB | May 11 | 5.5 KB | 0 KB | 5.5 KB |
| pds-id-to-string | 203.3 KB | 22 | 6.2K | 146K | 23 | 0.9 KB | May 12 | 1.9 KB | 0.2 KB | 2.1 KB |
| notification-2 | 126.4 KB | 16 | 42 | 7.7K | 183 | 2.0 KB | May 12 | 0.6 KB | 0.6 KB | 1.2 KB |
| pds-hash-to-id | 120.7 KB | 6 | 6.2K | 6.2K | (1) | 0.7 KB | May 12 | 1.1 KB | 4.6 KB | 5.7 KB |
| list-subscribers | 116.3 KB | 4 | 4.9K | 4.9K | (1) | 0.5 KB | May 12 | 482.7 KB | 320.3 KB | 803.0 KB |
| plc-to-did-other | 47.1 KB | 13 | 888 | 51K | 58 | 17.4 KB | May 12 | 0.4 KB | 0.6 KB | 0.9 KB |
| label-to-profiles | 57.9 KB | 11 | 67 | 14K | 216 | 0.1 KB | May 12 | 20.9 KB | 37.5 KB | 58.5 KB |
| label-data | 28.4 KB | 8 | 249 | 33K | 135 | 10.0 KB | May 12 | 2.2 KB | 0 KB | 2.2 KB |
| list-data-failed | 2.9 KB | 11 | 895 | 895 | 1 | 27.4 KB | May 12 | 2.3 KB | 1.7 KB | 4.0 KB |
| registered-user-to-followees | 28.1 KB | 11 | 11 | 2.3K | 217 | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| feed-generator-like-2 | 26.4 KB | 10 | 762 | 1.1K | 1.4 | 0 KB | May 11 | 0.9 KB | 8.1 KB | 9.0 KB |
| appviewlite-profile | 15.7 KB | 10 | 10 | 16K | 1.6K | 0 KB | May 11 | 0.2 KB | 0 KB | 0.2 KB |
| last-retrieved-plc-directory-6 | 8.0 KB | 13 | 1.1K | 1.1K | - | 3.1 KB | May 12 | 0.6 KB | 1.3 KB | 1.9 KB |
| feed-generator-like-2-rkey-hash-to-approx-target24 | 9.8 KB | 9 | 1.1K | 1.1K | (1) | 0 KB | May 11 | 0.3 KB | 1.1 KB | 1.4 KB |
| list-deletion | 7.1 KB | 6 | 362 | 362 | (1) | 0 KB | May 11 | 0.3 KB | 0.5 KB | 0.7 KB |
| list-block-deletion | 6.3 KB | 6 | 321 | 321 | (1) | 0 KB | May 11 | 0.2 KB | 0.4 KB | 0.6 KB |
| seen-posts-2 | 5.1 KB | 7 | 20 | 385 | 19 | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| seen-posts-by-date | 4.3 KB | 1 | 6 | 216 | 36 | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| notification-dark | 3.1 KB | 11 | 26 | 170 | 6.5 | 0 KB | May 12 | 1.6 KB | 1.0 KB | 2.7 KB |
| feed-deletion | 1.6 KB | 8 | 59 | 72 | 1.2 | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| label-name | 1.3 KB | 7 | 59 | 624 | 10 | 0.2 KB | May 11 | 0 KB | 0 KB | 0 KB |
| external-post-id-to-synth-tid | 0.7 KB | 1 | 29 | 29 | (1) | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| feed-generator-like-2-deletion | 0.5 KB | 5 | 27 | 27 | (1) | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| recent-post-like-count-2 | 0.5 KB | 1 | 29 | 29 | (1) | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| feed-generator-like-2-deletion-counts-2 | 0.3 KB | 5 | 19 | 19 | (1) | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| last-seen-notification-3 | 0.3 KB | 13 | 14 | 14 | (1) | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| bookmark | 0.1 KB | 1 | 1 | 1 | 1 | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| bookmark-recent | 0.1 KB | 1 | 1 | 1 | 1 | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| bookmark-deletion | 0.1 KB | 1 | 1 | 1 | 1 | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| reposter-only-profile | 0.1 KB | 1 | 1 | 1 | - | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| post-reply-direct | 0 KB | 0 | 0 | 0 | 0 | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| post-quote | 0 KB | 0 | 0 | 0 | 0 | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| post-deletion | 0 KB | 0 | 0 | 0 | (1) | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| threadgate | 0 KB | 0 | 0 | 0 | 0 | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| postgate | 0 KB | 0 | 0 | 0 | 0 | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| registered-user-to-rss-feeds | 0 KB | 0 | 0 | 0 | 0 | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| last-seen-notification-dark | 0 KB | 0 | 0 | 0 | (1) | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| custom-emoji | 0 KB | 0 | 0 | 0 | 0 | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| known-mirror-ignore | 0 KB | 0 | 0 | 0 | - | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| rss-refresh-info | 0 KB | 0 | 0 | 0 | 0 | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| nostr-seen-pubkey-hashes | 0 KB | 0 | 0 | 0 | - | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |
| opengraph | 0 KB | 0 | 0 | 0 | 0 | 0 KB | May 11 | 0 KB | 0 KB | 0 KB |