# Database seems inexplicably large

**URL:** <https://meta.discourse.org/t/database-seems-inexplicably-large/77872>\
**Category:** Self-hosting\
**Tags:** hosting\
**Created:** [1월 12, 2018, 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:** 3

<div class="post-metadata">

**Author:** ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)\
**Post date:** [1월 12, 2018, 7:54오후 UTC](https://meta.discourse.org/t/database-seems-inexplicably-large/77872/3 "2018-01-12T19:54:09Z")

</div>

Thanks. Is this what I’m looking for? I don’t think I see a restore schema, but I’m not quite sure what I’m looking for.

```
                List of relations

```

| Schema | Name | Type | Owner |
| --- | --- | --- | --- |
| public | api\_keys | table | discourse |
| public | application\_requests | table | discourse |
| public | ar\_internal\_metadata | table | discourse |
| public | badge\_groupings | table | discourse |
| public | badge\_types | table | discourse |
| public | badges | table | discourse |
| public | categories | table | discourse |
| public | categories\_web\_hooks | table | discourse |
| public | category\_custom\_fields | table | discourse |
| public | category\_featured\_topics | table | discourse |
| public | category\_featured\_users | table | discourse |
| public | category\_groups | table | discourse |
| public | category\_search\_data | table | discourse |
| public | category\_tag\_groups | table | discourse |
| public | category\_tags | table | discourse |
| public | category\_users | table | discourse |
| public | child\_themes | table | discourse |
| public | color\_scheme\_colors | table | discourse |
| public | color\_schemes | table | discourse |
| public | custom\_emojis | table | discourse |
| public | developers | table | discourse |
| public | directory\_items | table | discourse |
| public | draft\_sequences | table | discourse |
| public | drafts | table | discourse |
| public | email\_change\_requests | table | discourse |
| public | email\_logs | table | discourse |
| public | email\_tokens | table | discourse |
| public | embeddable\_hosts | table | discourse |
| public | facebook\_user\_infos | table | discourse |
| public | github\_user\_infos | table | discourse |
| public | given\_daily\_likes | table | discourse |
| public | google\_user\_infos | table | discourse |
| public | group\_archived\_messages | table | discourse |
| public | group\_custom\_fields | table | discourse |
| public | group\_histories | table | discourse |
| public | group\_mentions | table | discourse |
| public | group\_users | table | discourse |
| public | groups | table | discourse |
| public | groups\_web\_hooks | table | discourse |
| public | incoming\_domains | table | discourse |
| public | incoming\_emails | table | discourse |
| public | incoming\_links | table | discourse |
| public | incoming\_referers | table | discourse |
| public | instagram\_user\_infos | table | discourse |
| public | invited\_groups | table | discourse |
| public | invites | table | discourse |
| public | message\_bus | table | discourse |
| public | muted\_users | table | discourse |
| public | notifications | table | discourse |
| public | oauth2\_user\_infos | table | discourse |
| public | onceoff\_logs | table | discourse |
| public | optimized\_images | table | discourse |
| public | permalinks | table | discourse |
| public | plugin\_store\_rows | table | discourse |
| public | post\_action\_types | table | discourse |
| public | post\_actions | table | discourse |
| public | post\_custom\_fields | table | discourse |
| public | post\_details | table | discourse |
| public | post\_replies | table | discourse |
| public | post\_revisions | table | discourse |
| public | post\_search\_data | table | discourse |
| public | post\_stats | table | discourse |
| public | post\_timings | table | discourse |
| public | post\_uploads | table | discourse |
| public | posts | table | discourse |
| public | queued\_posts | table | discourse |
| public | quoted\_posts | table | discourse |
| public | remote\_themes | table | discourse |
| public | scheduler\_stats | table | discourse |
| public | schema\_migration\_details | table | discourse |
| public | schema\_migrations | table | discourse |
| public | screened\_emails | table | discourse |
| public | screened\_ip\_addresses | table | discourse |
| public | screened\_urls | table | discourse |
| public | search\_logs | table | discourse |
| public | single\_sign\_on\_records | table | discourse |
| public | site\_settings | table | discourse |
| public | stylesheet\_cache | table | discourse |
| public | tag\_group\_memberships | table | discourse |
| public | tag\_groups | table | discourse |
| public | tag\_search\_data | table | discourse |
| public | tag\_users | table | discourse |
| public | tags | table | discourse |
| public | theme\_fields | table | discourse |
| public | themes | table | discourse |
| public | top\_topics | table | discourse |
| public | topic\_allowed\_groups | table | discourse |
| public | topic\_allowed\_users | table | discourse |
| public | topic\_custom\_fields | table | discourse |
| public | topic\_embeds | table | discourse |
| public | topic\_invites | table | discourse |
| public | topic\_link\_clicks | table | discourse |
| public | topic\_links | table | discourse |
| public | topic\_search\_data | table | discourse |
| public | topic\_tags | table | discourse |
| public | topic\_timers | table | discourse |
| public | topic\_users | table | discourse |
| public | topic\_views | table | discourse |
| public | topics | table | discourse |
| public | translation\_overrides | table | discourse |
| public | twitter\_user\_infos | table | discourse |
| public | unsubscribe\_keys | table | discourse |
| public | uploads | table | discourse |
| public | user\_actions | table | discourse |
| public | user\_api\_keys | table | discourse |
| public | user\_archived\_messages | table | discourse |
| public | user\_auth\_token\_logs | table | discourse |
| public | user\_auth\_tokens | table | discourse |
| public | user\_avatars | table | discourse |
| public | user\_badges | table | discourse |
| public | user\_custom\_fields | table | discourse |
| public | user\_emails | table | discourse |
| public | user\_exports | table | discourse |
| public | user\_field\_options | table | discourse |
| public | user\_fields | table | discourse |
| public | user\_histories | table | discourse |
| public | user\_open\_ids | table | discourse |
| public | user\_options | table | discourse |
| public | user\_profile\_views | table | discourse |
| public | user\_profiles | table | discourse |
| public | user\_search\_data | table | discourse |
| public | user\_stats | table | discourse |
| public | user\_visits | table | discourse |
| public | user\_warnings | table | discourse |
| public | users | table | discourse |
| public | versions | table | discourse |
| public | watched\_words | table | discourse |
| public | web\_hook\_event\_types | table | discourse |
| public | web\_hook\_event\_types\_hooks | table | discourse |
| public | web\_hook\_events | table | discourse |
| public | web\_hooks | table | discourse |
| (131 rows) | | | |

---

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