Table stats
Total size: 3.1 GB
Page key indexes: 19.8 MB
Session original writes: 3.1 GB (12.1 MB buffered)
Session compactation writes: 6.3 GB
Buffered: 12.1 MB
Page key indexes: 19.8 MB
Session original writes: 3.1 GB (12.1 MB buffered)
Session compactation writes: 6.3 GB
Buffered: 12.1 MB
| Name | Size on disk | # Slices | # Keys | # Values | Avg #values | Pg. key index | Buffered | Flushed | Original writes | Compactation writes | Total writes | Kind |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| did-doc-6 | 650.8 MB | 7 | 24M | 439M | 18 | 736.7 KB | 0 KB | 1m | 673.4 MB | 1.8 GB | 2.4 GB | PreserveOrder |
| profile-search-prefix | 529.6 MB | 10 | 17M | 75M | 4.2 | 2.1 MB | 0 KB | 1m | 636.6 MB | 1.5 GB | 2.1 GB | SortedValues |
| did-hash-to-user-id | 466.3 MB | 5 | 24M | 24M | (1) | 11.6 MB | 7.1 MB | 2m | 429.4 MB | 792.5 MB | 1.2 GB | SingleValue |
| plc-to-did-plc | 468.1 MB | 11 | 24M | 24M | (1) | 741.8 KB | 3.2 MB | 1m | 431.2 MB | 438.4 MB | 869.6 MB | SingleValue |
| handle-to-possible-dids | 436.5 MB | 8 | 25M | 25M | 1.0 | 3.0 MB | 0 KB | 1m | 439.4 MB | 783.7 MB | 1.2 GB | SortedValues |
| profile-search-prefix-2-letters | 287.8 MB | 11 | 13K | 75M | 5.7K | 0.1 KB | 0 KB | 1m | 298.7 MB | 769.8 MB | 1.0 GB | SortedValues |
| profile-search-long | 243.0 MB | 9 | 14M | 14M | 1.0 | 1.7 MB | 1.7 MB | 1m | 245.7 MB | 361.6 MB | 607.2 MB | SortedValues |
| list-membership-2 | 22.4 MB | 6 | 530K | 910K | 1.7 | 13.1 KB | 0 KB | 1h | 22.6 MB | 18.2 MB | 40.8 MB | SortedValues |
| list-item | 10.4 MB | 9 | 353 | 910K | 2.5K | 0.1 KB | 0 KB | 1h | 10.1 MB | 0 KB | 10.1 MB | SortedValues |
| post-label | 242.4 KB | 6 | 6.8K | 7.3K | 1.0 | 0.1 KB | 0 KB | 1h | 210.3 KB | 185.9 KB | 396.1 KB | SortedValues |
| post-text-approx-time-32 | 145.3 KB | 13 | 6.6K | 13K | 2.0 | 0.1 KB | 0 KB | 38m | 83.3 KB | 0 KB | 83.3 KB | SortedValues |
| block | 125.4 KB | 6 | 5.8K | 5.8K | 1.0 | 0.1 KB | 0 KB | 1h | 82.4 KB | 0 KB | 82.4 KB | SortedValues |
| pds-id-to-string | 106.1 KB | 12 | 3.4K | 81K | 23 | 0.1 KB | 11.8 KB | 8m | 102.0 KB | 42.6 KB | 144.6 KB | PreserveOrder |
| profile-search-description-only | 97.8 KB | 14 | 5.0K | 7.4K | 1.4 | 0.1 KB | 0 KB | 38m | 46.8 KB | 0 KB | 46.8 KB | SortedValues |
| post-data-time-first-2 | 89.4 KB | 13 | 705 | 78K | 111 | 0.2 KB | 0 KB | 38m | 52.1 KB | 0 KB | 52.1 KB | PreserveOrder |
| label-to-posts | 84.6 KB | 6 | 46 | 7.1K | 155 | 0.1 KB | 0 KB | 1h | 74.9 KB | 64.3 KB | 139.3 KB | SortedValues |
| pds-hash-to-id | 63.0 KB | 12 | 3.4K | 3.4K | (1) | 0.2 KB | 9.2 KB | 8m | 61.1 KB | 24.8 KB | 85.8 KB | SingleValue |
| profile-basic-2 | 64.5 KB | 14 | 385 | 62K | 161 | 0.1 KB | 0 KB | 38m | 30.4 KB | 0 KB | 30.4 KB | PreserveOrder |
| list | 56.9 KB | 6 | 355 | 51K | 146 | 0.1 KB | 0 KB | 1h | 37.6 KB | 0 KB | 37.6 KB | PreserveOrder |
| block-rkey-hash-to-approx-target24 | 51.6 KB | 6 | 5.8K | 5.8K | (1) | 0.1 KB | 0 KB | 1h | 33.7 KB | 0 KB | 33.7 KB | SingleValue |
| profile-label | 36.0 KB | 6 | 1.2K | 1.4K | 1.1 | 0.1 KB | 0 KB | 1h | 32.2 KB | 27.5 KB | 59.7 KB | SortedValues |
| follow | 17.3 KB | 2 | 779 | 823 | 1.0 | 0.1 KB | 0 KB | 1h | 4.3 KB | 0 KB | 4.3 KB | SortedValues |
| handle-verifications | 12.6 KB | 15 | 429 | 429 | 1 | 0.2 KB | 0 KB | 38m | 6.7 KB | 0 KB | 6.7 KB | SortedValues |
| user-to-recent-posts-2 | 11.1 KB | 13 | 286 | 705 | 2.4 | 0.1 KB | 0 KB | 38m | 6.3 KB | 0 KB | 6.3 KB | SortedValues |
| post-reply-direct-2 | 8.0 KB | 4 | 271 | 277 | 1.0 | 0.1 KB | 0 KB | 1h | 5.8 KB | 0 KB | 5.8 KB | SortedValues |
| follow-rkey-hash-to-approx-target24 | 7.2 KB | 2 | 823 | 823 | (1) | 0.1 KB | 0 KB | 1h | 1.8 KB | 0 KB | 1.8 KB | SingleValue |
| car-import-proto-2 | 7.0 KB | 8 | 235 | 2.8K | 12 | 0.1 KB | 0 KB | 1h | 5.5 KB | 0 KB | 5.5 KB | PreserveOrder |
| registered-user-to-followees | 6.8 KB | 1 | 1 | 577 | 577 | 0.1 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SortedValues |
| label-to-profiles | 5.8 KB | 6 | 19 | 1.3K | 73 | 0.1 KB | 0 KB | 1h | 5.8 KB | 4.2 KB | 10.0 KB | SortedValues |
| last-retrieved-plc-directory-6 | 4.2 KB | 14 | 556 | 556 | - | 0.1 KB | 0.5 KB | 8m | 3.9 KB | 2.3 KB | 6.2 KB | KeySetOnly |
| feed-generator-search | 4.6 KB | 4 | 152 | 215 | 1.4 | 0.1 KB | 0 KB | 1h | 3.3 KB | 0 KB | 3.3 KB | SortedValues |
| feed-generator | 4.1 KB | 5 | 21 | 3.7K | 180 | 0.1 KB | 0 KB | 1h | 2.9 KB | 0 KB | 2.9 KB | PreserveOrder |
| user-to-recent-media-posts | 3.6 KB | 13 | 166 | 251 | 1.5 | 0.1 KB | 0 KB | 38m | 1.7 KB | 0 KB | 1.7 KB | SortedValues |
| label-data | 2.2 KB | 1 | 24 | 1.7K | 74 | 0.1 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | PreserveOrder |
| appviewlite-profile | 1.8 KB | 2 | 2 | 1.8K | 905 | 0.1 KB | 0 KB | 3h | 0.2 KB | 0 KB | 0.2 KB | PreserveOrder |
| list-block | 1.6 KB | 5 | 69 | 69 | (1) | 0.1 KB | 0 KB | 1h | 1.4 KB | 0 KB | 1.4 KB | SingleValue |
| list-subscribers | 1.5 KB | 5 | 64 | 64 | (1) | 0.1 KB | 0 KB | 1h | 1.3 KB | 0 KB | 1.3 KB | SingleValue |
| post-quote-2 | 1.2 KB | 3 | 38 | 43 | 1.1 | 0.1 KB | 0 KB | 2h | 0.2 KB | 0 KB | 0.2 KB | SortedValues |
| block-deletion | 0.9 KB | 1 | 46 | 46 | (1) | 0.1 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SingleValue |
| notification-2 | 0.8 KB | 1 | 1 | 45 | 45 | 0.1 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SortedValues |
| threadgate-2 | 0.7 KB | 6 | 23 | 337 | 14 | 0.1 KB | 0 KB | 38m | 0.2 KB | 0 KB | 0.2 KB | PreserveOrder |
| label-name | 0.6 KB | 3 | 27 | 237 | 8.7 | 0.1 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | PreserveOrder |
| profile-basic-failed | 0.4 KB | 3 | 21 | 21 | 1 | 0.1 KB | 0 KB | 2h | 0.4 KB | 0 KB | 0.4 KB | SortedValues |
| plc-to-did-other | 0.2 KB | 2 | 4 | 207 | 51 | 0.1 KB | 0 KB | 2h | 0.2 KB | 0 KB | 0.2 KB | PreserveOrder |
| block-deletion-counts-2 | 0.2 KB | 1 | 30 | 30 | (1) | 0.1 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SingleValue |
| post-data-failed | 0.1 KB | 4 | 5 | 5 | 1 | 0.1 KB | 0 KB | 2h | 0.1 KB | 0 KB | 0.1 KB | SortedValues |
| postgate-2 | 0.1 KB | 3 | 5 | 10 | 2.0 | 0.1 KB | 0 KB | 2h | 0.1 KB | 0 KB | 0.1 KB | PreserveOrder |
| account-state | 0.1 KB | 1 | 8 | 8 | (1) | 0.1 KB | 0 KB | 2h | 0.1 KB | 0 KB | 0.1 KB | SingleValue |
| last-seen-notification-3 | 0.1 KB | 1 | 1 | 1 | (1) | 0.1 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SingleValue |
| bookmark | 0 KB | 0 | 0 | 0 | 0 | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SortedValues |
| bookmark-recent | 0 KB | 0 | 0 | 0 | 0 | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SortedValues |
| bookmark-deletion | 0 KB | 0 | 0 | 0 | 0 | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SortedValues |
| post-deletion-2 | 0 KB | 0 | 0 | 0 | (1) | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SingleValue |
| recent-post-like-count-2 | 0 KB | 0 | 0 | 0 | (1) | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SingleValue |
| list-data-failed | 0 KB | 0 | 0 | 0 | 0 | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SortedValues |
| list-item-deletion | 0 KB | 0 | 0 | 0 | (1) | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SingleValue |
| list-deletion | 0 KB | 0 | 0 | 0 | (1) | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SingleValue |
| list-block-deletion | 0 KB | 0 | 0 | 0 | (1) | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SingleValue |
| notification-dark | 0 KB | 0 | 0 | 0 | 0 | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SortedValues |
| registered-user-to-rss-feeds | 0 KB | 0 | 0 | 0 | 0 | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SortedValues |
| user-to-recent-reposts-2 | 0 KB | 0 | 0 | 0 | 0 | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SortedValues |
| last-seen-notification-dark | 0 KB | 0 | 0 | 0 | (1) | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SingleValue |
| feed-deletion | 0 KB | 0 | 0 | 0 | 0 | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SortedValues |
| custom-emoji | 0 KB | 0 | 0 | 0 | 0 | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | PreserveOrder |
| known-mirror-ignore | 0 KB | 0 | 0 | 0 | - | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | KeySetOnly |
| external-post-id-to-synth-tid | 0 KB | 0 | 0 | 0 | (1) | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SingleValue |
| seen-posts-2 | 0 KB | 0 | 0 | 0 | 0 | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SortedValues |
| seen-posts-by-date | 0 KB | 0 | 0 | 0 | 0 | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SortedValues |
| rss-refresh-info | 0 KB | 0 | 0 | 0 | 0 | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | PreserveOrder |
| nostr-seen-pubkey-hashes | 0 KB | 0 | 0 | 0 | - | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | KeySetOnly |
| reposter-only-profile | 0 KB | 0 | 0 | 0 | - | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | KeySetOnly |
| opengraph | 0 KB | 0 | 0 | 0 | 0 | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | PreserveOrder |
| post-like-time-first | 0 KB | 0 | 0 | 0 | 0 | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SortedValues |
| post-like-time-first-deletion | 0 KB | 0 | 0 | 0 | (1) | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SingleValue |
| post-like-time-first-deletion-counts-2 | 0 KB | 0 | 0 | 0 | (1) | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SingleValue |
| post-like-time-first-rkey-hash-to-approx-target24 | 0 KB | 0 | 0 | 0 | (1) | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SingleValue |
| post-repost-time-first | 0 KB | 0 | 0 | 0 | 0 | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SortedValues |
| post-repost-time-first-deletion | 0 KB | 0 | 0 | 0 | (1) | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SingleValue |
| post-repost-time-first-deletion-counts-2 | 0 KB | 0 | 0 | 0 | (1) | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SingleValue |
| post-repost-time-first-rkey-hash-to-approx-target24 | 0 KB | 0 | 0 | 0 | (1) | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SingleValue |
| follow-deletion | 0 KB | 0 | 0 | 0 | (1) | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SingleValue |
| follow-deletion-counts-2 | 0 KB | 0 | 0 | 0 | (1) | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SingleValue |
| feed-generator-like-2 | 0 KB | 0 | 0 | 0 | 0 | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SortedValues |
| feed-generator-like-2-deletion | 0 KB | 0 | 0 | 0 | (1) | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SingleValue |
| feed-generator-like-2-deletion-counts-2 | 0 KB | 0 | 0 | 0 | (1) | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SingleValue |
| feed-generator-like-2-rkey-hash-to-approx-target24 | 0 KB | 0 | 0 | 0 | (1) | 0 KB | 0 KB | 4h | 0 KB | 0 KB | 0 KB | SingleValue |