gistfile1.txt

fd=# \d instances
                                            Table "public.instances"
      Column       |            Type             | Collation | Nullable |                Default
-------------------+-----------------------------+-----------+----------+---------------------------------------
 id                | bigint                      |           | not null | nextval('instances_id_seq'::regclass)
 domain            | character varying(255)      |           |          |
 version           | character varying(255)      |           |          |
 server            | integer                     |           |          |
 name              | character varying(255)      |           |          |
 description       | text                        |           |          |
 email             | character varying(255)      |           |          |
 valid             | boolean                     |           |          |
 last_checked_at   | timestamp without time zone |           |          |
 last_up_at        | timestamp without time zone |           |          |
 last_down_at      | timestamp without time zone |           |          |
 has_mastapi       | boolean                     |           |          |
 mastapi_version   | character varying(255)      |           |          |
 mastapi_instance  | jsonb                       |           |          |
 custom_emojis     | jsonb                       |           |          |
 has_statusnet     | boolean                     |           |          |
 statusnet_version | character varying(255)      |           |          |
 statusnet_config  | jsonb                       |           |          |
 peertube_config   | jsonb                       |           |          |
 inserted_at       | timestamp without time zone |           | not null |
 updated_at        | timestamp without time zone |           | not null |
 up                | boolean                     |           |          |
 signup            | boolean                     |           |          |
 users             | integer                     |           |          |
 statuses          | integer                     |           |          |
 peers             | integer                     |           |          |
 emojis            | integer                     |           |          |
 max_chars         | integer                     |           |          |
 domain_suffix     | citext                      |           |          |
 domain_base       | citext                      |           |          |
 ases              | text[]                      |           |          |
 ips               | text[]                      |           |          |
 monitor           | boolean                     |           |          |
 hidden            | boolean                     |           |          |
 dead              | boolean                     |           |          |
 settings          | jsonb                       |           |          |
 nodeinfo          | jsonb                       |           |          |



fd=# \d instance_checks
                       Table "public.instance_checks"
   Column    |            Type             | Collation | Nullable | Default
-------------+-----------------------------+-----------+----------+---------
 instance_id | bigint                      |           |          |
 up          | boolean                     |           |          |
 users       | integer                     |           |          |
 peers       | integer                     |           |          |
 emojis      | integer                     |           |          |
 statuses    | integer                     |           |          |
 version     | character varying(255)      |           |          |
 signup      | boolean                     |           |          |
 max_chars   | integer                     |           |          |
 updated_at  | timestamp without time zone |           | not null |
 at          | timestamp without time zone |           |          |
 error_s     | character varying(255)      |           |          |
 server      | integer                     |           |          |