Space
Database Size: 10.5 MB
11 unused indices. Remove them for faster writes.
rails generate migration remove_unused_indexes
And paste
remove_index :products, name: "idx_products_search" remove_index :products, name: "idx_products_title_search" remove_index :product_variants, name: "idx_variants_attributes" remove_index :products, name: "idx_cat_price" remove_index :product_images, name: "idx_images_variant_order" remove_index :products, name: "idx_products_brand_price_compound" remove_index :products, name: "idx_products_cat_price" remove_index :products, name: "idx_products_category" remove_index :products, name: "idx_products_category_id" remove_index :product_variants, name: "idx_variants_stock" remove_index :Features, name: "Features_order_idx"
| Relation | Size |
|---|---|
| idx_products_attributes | 24 KB |
| idx_products_search UNUSED | 24 KB |
| idx_products_title_search UNUSED | 24 KB |
| idx_variants_attributes UNUSED | 24 KB |
| brands | 16 KB |
| brands_pkey | 16 KB |
| brands_slug_key | 16 KB |
| categories_pkey | 16 KB |
| categories_slug_key | 16 KB |
| idx_attr_cat_val_composite | 16 KB |
| idx_cat_price UNUSED | 16 KB |
| idx_categories_parent | 16 KB |
| idx_categories_parent_id | 16 KB |
| idx_categories_slug | 16 KB |
| idx_images_variant_order UNUSED | 16 KB |
| idx_product_images_listing | 16 KB |
| idx_product_images_primary | 16 KB |
| idx_product_images_product | 16 KB |
| idx_product_images_product_id | 16 KB |
| idx_product_images_variant | 16 KB |
| idx_product_variants_product_id | 16 KB |
| idx_products_brand_id | 16 KB |
| idx_products_brand_price_compound UNUSED | 16 KB |
| idx_products_cat_price UNUSED | 16 KB |
| idx_products_cat_price_compound | 16 KB |
| idx_products_category UNUSED | 16 KB |
| idx_products_category_id UNUSED | 16 KB |
| idx_products_created | 16 KB |
| idx_products_id | 16 KB |
| idx_products_price | 16 KB |
| idx_variants_stock UNUSED | 16 KB |
| product_attribute_category_values | 16 KB |
| product_attribute_category_values_attribute_key_category_id_key | 16 KB |
| product_attribute_category_values_pkey | 16 KB |
| product_attribute_definitions | 16 KB |
| product_attribute_definitions_key_scope_key | 16 KB |
| product_attribute_definitions_pkey | 16 KB |
| product_images | 16 KB |
| product_images_pkey | 16 KB |
| product_variants | 16 KB |
| product_variants_pkey | 16 KB |
| product_variants_sku_key | 16 KB |
| products | 16 KB |
| products_pkey | 16 KB |
| products_slug_key | 16 KB |
| uk_variant_sku | 16 KB |
| unique_attribute_key | 16 KB |
| Features pjuezgotrxo40rf | 8 KB |
| Features_order_idx pjuezgotrxo40rf UNUSED | 8 KB |
| Features_pkey pjuezgotrxo40rf | 8 KB |
| categories | 8 KB |