# データベースが説明不能なほど巨大なようです

**URL:** <https://meta.discourse.org/t/database-seems-inexplicably-large/77872>\
**Category:** Self-hosting\
**Tags:** hosting\
**Created:** [2018 年 1 月 12 日午後 7:28 UTC](https://meta.discourse.org/t/database-seems-inexplicably-large/77872 "2018-01-12T19:28:36Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![nildarar](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/nildarar/32/331927_2.png) [@nildarar](https://meta.discourse.org/u/nildarar)\
**Post date:** [2020 年 11 月 8 日午前 6:06 UTC](https://meta.discourse.org/t/database-seems-inexplicably-large/77872/5 "2020-11-08T06:06:34Z")

</div>

Discourse の `post-timings` テーブルのサイズは約 17GB です。これは正常でしょうか？

| table\_name | row\_estimate | table\_size | index\_size | total\_size |
| --- | --- | --- | --- | --- |
| post\_timings | 120967448 | 6676 MB | 10 GB | 17 GB |
| posts | 3616224 | 2413 MB | 3219 MB | 5632 MB |
| user\_actions | 15159571 | 1215 MB | 3699 MB | 4914 MB |
| post\_search\_data | 3531969 | 3756 MB | 1031 MB | 4787 MB |
| notifications | 2241273 | 687 MB | 824 MB | 1510 MB |
| topic\_views | 7696258 | 369 MB | 1110 MB | 1478 MB |
| post\_actions | 3475097 | 350 MB | 618 MB | 968 MB |
| topic\_users | 3343623 | 365 MB | 257 MB | 622 MB |
| user\_auth\_token\_logs | 1123545 | 410 MB | 110 MB | 520 MB |
| post\_stats | 2779471 | 354 MB | 155 MB | 509 MB |
| incoming\_links | 3154654 | 219 MB | 251 MB | 469 MB |
| topics | 64301 | 142 MB | 286 MB | 429 MB |
| post\_replies | 2327812 | 220 MB | 120 MB | 340 MB |
| user\_visits | 289994 | 17 MB | 229 MB | 246 MB |
| stylesheet\_cache | 4605 | 204 MB | 840 kB | 205 MB |
| top\_topics | 40202 | 19 MB | 148 MB | 167 MB |
| user\_profile\_views | 593591 | 61 MB | 97 MB | 158 MB |
| post\_revisions | 102832 | 87 MB | 8072 kB | 95 MB |

---

_[View the full topic](https://meta.discourse.org/t/database-seems-inexplicably-large/77872)._