Space
Database Size: 15.4 MB
10 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_stock" remove_index :products, name: "idx_cat_price" 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_attributes" remove_index :Features, name: "Features_order_idx"
| Relation | Size |
|---|---|
| product_images | 1.38 MB |
| idx_product_images_listing | 504 KB |
| idx_product_images_variant | 368 KB |
| idx_product_images_primary | 360 KB |
| idx_products_search UNUSED | 344 KB |
| product_images_pkey | 312 KB |
| idx_product_images_product | 288 KB |
| idx_product_images_product_id | 288 KB |
| products | 272 KB |
| product_variants | 256 KB |
| idx_products_title_search UNUSED | 120 KB |
| idx_product_variants_product_id | 104 KB |
| product_variants_pkey | 104 KB |
| product_variants_sku_key | 104 KB |
| idx_variants_stock UNUSED | 72 KB |
| idx_variants_attributes UNUSED | 64 KB |
| products_slug_key | 56 KB |
| brands | 48 KB |
| idx_cat_price UNUSED | 48 KB |
| idx_products_brand_price_compound UNUSED | 48 KB |
| idx_products_cat_price UNUSED | 48 KB |
| idx_products_cat_price_compound | 48 KB |
| idx_products_brand_id | 40 KB |
| idx_products_category UNUSED | 40 KB |
| idx_products_category_id UNUSED | 40 KB |
| idx_products_id | 40 KB |
| products_pkey | 40 KB |
| idx_products_created | 32 KB |
| idx_products_price | 32 KB |
| idx_products_attributes | 24 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_categories_parent | 16 KB |
| idx_categories_parent_id | 16 KB |
| idx_categories_slug | 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 |
| Features pjuezgotrxo40rf | 8 KB |
| Features_order_idx pjuezgotrxo40rf UNUSED | 8 KB |
| Features_pkey pjuezgotrxo40rf | 8 KB |
| categories | 8 KB |