[root@vps133498 pg_log]# su - postgres -c 'psql  mastodon_production'
psql (9.4.18)
Type "help" for help.

mastodon_production=# \d+ statuses
                                                            Table "public.statuses"
         Column         |            Type             |                    Modifiers                    | Storage  | Stats target | Description
------------------------+-----------------------------+-------------------------------------------------+----------+--------------+-------------
 id                     | bigint                      | not null default timestamp_id('statuses'::text) | plain    |              |
 uri                    | character varying           |                                                 | extended |              |
 text                   | text                        | not null default ''::text                       | extended |              |
 created_at             | timestamp without time zone | not null                                        | plain    |              |
 updated_at             | timestamp without time zone | not null                                        | plain    |              |
 in_reply_to_id         | bigint                      |                                                 | plain    |              |
 reblog_of_id           | bigint                      |                                                 | plain    |              |
 url                    | character varying           |                                                 | extended |              |
 sensitive              | boolean                     | not null default false                          | plain    |              |
 visibility             | integer                     | not null default 0                              | plain    |              |
 spoiler_text           | text                        | not null default ''::text                       | extended |              |
 reply                  | boolean                     | not null default false                          | plain    |              |
 favourites_count       | integer                     | not null default 0                              | plain    |              |
 reblogs_count          | integer                     | not null default 0                              | plain    |              |
 language               | character varying           |                                                 | extended |              |
 conversation_id        | bigint                      |                                                 | plain    |              |
 local                  | boolean                     |                                                 | plain    |              |
 account_id             | bigint                      | not null                                        | plain    |              |
 application_id         | bigint                      |                                                 | plain    |              |
 in_reply_to_account_id | bigint                      |                                                 | plain    |              |
Indexes:
    "statuses_pkey" PRIMARY KEY, btree (id)
    "index_statuses_20180106" btree (account_id, id DESC, visibility, updated_at)
    "index_statuses_on_conversation_id" btree (conversation_id)
    "index_statuses_on_in_reply_to_id" btree (in_reply_to_id)
    "index_statuses_on_reblog_of_id_and_account_id" btree (reblog_of_id, account_id)
Foreign-key constraints:
    "fk_9bda1543f7" FOREIGN KEY (account_id) REFERENCES accounts(id) ON DELETE CASCADE
    "fk_c7fa917661" FOREIGN KEY (in_reply_to_account_id) REFERENCES accounts(id) ON DELETE SET NULL
    "fk_rails_256483a9ab" FOREIGN KEY (reblog_of_id) REFERENCES statuses(id) ON DELETE CASCADE
    "fk_rails_94a6f70399" FOREIGN KEY (in_reply_to_id) REFERENCES statuses(id) ON DELETE SET NULL
Referenced by:
    TABLE "favourites" CONSTRAINT "fk_b0e856845e" FOREIGN KEY (status_id) REFERENCES statuses(id) ON DELETE CASCADE
    TABLE "statuses" CONSTRAINT "fk_rails_256483a9ab" FOREIGN KEY (reblog_of_id) REFERENCES statuses(id) ON DELETE CASCADE
    TABLE "media_attachments" CONSTRAINT "fk_rails_3ec0cfdd70" FOREIGN KEY (status_id) REFERENCES statuses(id) ON DELETE SET NULL
    TABLE "mentions" CONSTRAINT "fk_rails_59edbe2887" FOREIGN KEY (status_id) REFERENCES statuses(id) ON DELETE CASCADE
    TABLE "status_pins" CONSTRAINT "fk_rails_65c05552f1" FOREIGN KEY (status_id) REFERENCES statuses(id) ON DELETE CASCADE
    TABLE "statuses" CONSTRAINT "fk_rails_94a6f70399" FOREIGN KEY (in_reply_to_id) REFERENCES statuses(id) ON DELETE SET NULL
    TABLE "statuses_tags" CONSTRAINT "fk_rails_df0fe11427" FOREIGN KEY (status_id) REFERENCES statuses(id) ON DELETE CASCADE
    TABLE "deprecated_preview_cards" CONSTRAINT "fk_rails_e0cd3ac7fe" FOREIGN KEY (status_id) REFERENCES statuses(id) ON DELETE CASCADE