Also Manila is effected. There are no indexes created for postgres, e.g.:


# MySQL
show index from share_instances;
+-----------------+------------+---------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table           | Non_unique | Key_name            | Seq_in_index | Column_name          | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-----------------+------------+---------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| share_instances |          0 | PRIMARY             |            1 | id                   | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| share_instances |          1 | si_share_fk         |            1 | share_id             | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
| share_instances |          1 | si_share_network_fk |            1 | share_network_id     | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
| share_instances |          1 | si_share_server_fk  |            1 | share_server_id      | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
| share_instances |          1 | si_az_id_fk         |            1 | availability_zone_id | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
| share_instances |          1 | si_st_id_fk         |            1 | share_type_id        | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
+-----------------+------------+---------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

# postgres
\d+ share_instances
                                      Table "public.share_instances"
         Column         |            Type             | Modifiers | Storage  | Stats target | Description
------------------------+-----------------------------+-----------+----------+--------------+-------------
 created_at             | timestamp without time zone |           | plain    |              |
 updated_at             | timestamp without time zone |           | plain    |              |
 deleted_at             | timestamp without time zone |           | plain    |              |
 deleted                | character varying(36)       |           | extended |              |
 id                     | character varying(36)       | not null  | extended |              |
 share_id               | character varying(36)       |           | extended |              |
 host                   | character varying(255)      |           | extended |              |
 status                 | character varying(255)      |           | extended |              |
 scheduled_at           | timestamp without time zone |           | plain    |              |
 launched_at            | timestamp without time zone |           | plain    |              |
 terminated_at          | timestamp without time zone |           | plain    |              |
 share_network_id       | character varying(36)       |           | extended |              |
 share_server_id        | character varying(36)       |           | extended |              |
 availability_zone_id   | character varying(36)       |           | extended |              |
 access_rules_status    | character varying(255)      |           | extended |              |
 replica_state          | character varying(255)      |           | extended |              |
 share_type_id          | character varying(36)       |           | extended |              |
 cast_rules_to_readonly | boolean                     | not null  | plain    |              |
Indexes:
    "share_instances_pkey" PRIMARY KEY, btree (id)