Space
Database Size: 10.7 MB
17 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 :products, name: "idx_products_attributes" remove_index :product_images, name: "idx_product_images_product_id" remove_index :product_variants, name: "idx_variants_attributes" remove_index :products, name: "idx_cat_price" remove_index :product_variants, name: "idx_product_variants_product_id" remove_index :products, name: "idx_products_brand_id" remove_index :products, name: "idx_products_brand_price_compound" remove_index :products, name: "idx_products_cat_price" remove_index :products, name: "idx_products_cat_price_compound" 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" remove_index :products, name: "idx_products_discount_active" remove_index :products, name: "idx_products_on_sale"
| Relation | Size |
|---|---|
| idx_products_search UNUSED | 216 KB |
| idx_products_title_search UNUSED | 104 KB |
| product_images | 104 KB |
| idx_products_attributes UNUSED | 64 KB |
| products | 64 KB |
| idx_variants_attributes UNUSED | 48 KB |
| product_variants | 48 KB |
| idx_product_images_primary | 40 KB |
| idx_product_images_product | 40 KB |
| product_images_pkey | 40 KB |
| idx_product_images_product_id UNUSED | 32 KB |
| brands | 16 KB |
| brands_pkey | 16 KB |
| brands_slug_key | 16 KB |
| categories_pkey | 16 KB |
| categories_slug_key | 16 KB |
| idx_cat_price UNUSED | 16 KB |
| idx_categories_parent_id | 16 KB |
| idx_categories_slug | 16 KB |
| idx_product_variants_product_id UNUSED | 16 KB |
| idx_products_brand_id UNUSED | 16 KB |
| idx_products_brand_price_compound UNUSED | 16 KB |
| idx_products_cat_price UNUSED | 16 KB |
| idx_products_cat_price_compound UNUSED | 16 KB |
| idx_products_category UNUSED | 16 KB |
| idx_products_category_id UNUSED | 16 KB |
| idx_products_id | 16 KB |
| idx_products_price | 16 KB |
| idx_variants_stock UNUSED | 16 KB |
| product_variants_pkey | 16 KB |
| product_variants_sku_key | 16 KB |
| products_pkey | 16 KB |
| products_slug_key | 16 KB |
| Features pjuezgotrxo40rf | 8 KB |
| Features_order_idx pjuezgotrxo40rf UNUSED | 8 KB |
| Features_pkey pjuezgotrxo40rf | 8 KB |
| categories | 8 KB |
| idx_products_discount_active UNUSED | 8 KB |
| idx_products_on_sale UNUSED | 8 KB |