G

gistfile1.txt

"schemaname","tablename","indexname","tablespace","indexdef"
"public","ahoy_events","ahoy_events_pkey",NULL,"CREATE UNIQUE INDEX ahoy_events_pkey ON public.ahoy_events USING btree (id)"
"public","api_request_logs","api_request_logs_pkey",NULL,"CREATE UNIQUE INDEX api_request_logs_pkey ON public.api_request_logs USING btree (id)"
"public","awsdms_ddl_audit","awsdms_ddl_audit_pkey",NULL,"CREATE UNIQUE INDEX awsdms_ddl_audit_pkey ON public.awsdms_ddl_audit USING btree (c_key)"
"public","batch_import_logs","batch_import_logs_pkey",NULL,"CREATE UNIQUE INDEX batch_import_logs_pkey ON public.batch_import_logs USING btree (id)"
"public","batch_imports","batch_imports_pkey",NULL,"CREATE UNIQUE INDEX batch_imports_pkey ON public.batch_imports USING btree (id)"
"public","bisac_hierarchies","bisac_anc_desc_idx",NULL,"CREATE UNIQUE INDEX bisac_anc_desc_idx ON public.bisac_hierarchies USING btree (ancestor_id, descendant_id, generations)"
"public","bisac_hierarchies","bisac_ancestor_idx",NULL,"CREATE INDEX bisac_ancestor_idx ON public.bisac_hierarchies USING btree (ancestor_id)"
"public","bisac_hierarchies","bisac_desc_idx",NULL,"CREATE INDEX bisac_desc_idx ON public.bisac_hierarchies USING btree (descendant_id)"
"public","bisacs","bisacs_pkey",NULL,"CREATE UNIQUE INDEX bisacs_pkey ON public.bisacs USING btree (id)"
"public","catalog_import_logs","catalog_import_logs_pkey",NULL,"CREATE UNIQUE INDEX catalog_import_logs_pkey ON public.catalog_import_logs USING btree (id)"
"public","email_domains","email_domains_pkey",NULL,"CREATE UNIQUE INDEX email_domains_pkey ON public.email_domains USING btree (id)"
"public","spree_users","email_idx_unique",NULL,"CREATE UNIQUE INDEX email_idx_unique ON public.spree_users USING btree (email)"
"public","email_optins","email_optins_pkey",NULL,"CREATE UNIQUE INDEX email_optins_pkey ON public.email_optins USING btree (id)"
"public","exact_target_api_call_logs","exact_target_api_call_logs_pkey",NULL,"CREATE UNIQUE INDEX exact_target_api_call_logs_pkey ON public.exact_target_api_call_logs USING btree (id)"
"public","exact_target_send_requests","exact_target_send_requests_pkey",NULL,"CREATE UNIQUE INDEX exact_target_send_requests_pkey ON public.exact_target_send_requests USING btree (id)"
"public","failed_credit_cards","failed_credit_cards_pkey",NULL,"CREATE UNIQUE INDEX failed_credit_cards_pkey ON public.failed_credit_cards USING btree (id)"
"public","gift_cards","gift_cards_pkey",NULL,"CREATE UNIQUE INDEX gift_cards_pkey ON public.gift_cards USING btree (id)"
"public","hpb_gift_card_service_logs","hpb_gift_card_service_logs_pkey",NULL,"CREATE UNIQUE INDEX hpb_gift_card_service_logs_pkey ON public.hpb_gift_card_service_logs USING btree (id)"
"public","spree_addresses","index_addresses_on_firstname",NULL,"CREATE INDEX index_addresses_on_firstname ON public.spree_addresses USING btree (firstname)"
"public","spree_addresses","index_addresses_on_lastname",NULL,"CREATE INDEX index_addresses_on_lastname ON public.spree_addresses USING btree (lastname)"
"public","spree_adjustments","index_adjustments_on_order_id",NULL,"CREATE INDEX index_adjustments_on_order_id ON public.spree_adjustments USING btree (adjustable_id)"
"public","ahoy_events","index_ahoy_events_category_clicks_on_visit_id_and_and_time",NULL,"CREATE INDEX index_ahoy_events_category_clicks_on_visit_id_and_and_time ON public.ahoy_events USING btree (visit_id, ""time"" DESC) WHERE ((name)::text = 'Category Click'::text)"
"public","ahoy_events","index_ahoy_events_category_on_visit_id_and_name_and_time",NULL,"CREATE INDEX index_ahoy_events_category_on_visit_id_and_name_and_time ON public.ahoy_events USING btree (visit_id, name, ""time"")"
"public","ahoy_events","index_ahoy_events_on_name",NULL,"CREATE INDEX index_ahoy_events_on_name ON public.ahoy_events USING btree (name)"
"public","ahoy_events","index_ahoy_events_on_time",NULL,"CREATE INDEX index_ahoy_events_on_time ON public.ahoy_events USING btree (""time"")"
"public","ahoy_events","index_ahoy_events_on_time_category_click",NULL,"CREATE INDEX index_ahoy_events_on_time_category_click ON public.ahoy_events USING btree (""time"" DESC) WHERE ((name)::text = 'Category Click'::text)"
"public","ahoy_events","index_ahoy_events_on_user_id",NULL,"CREATE INDEX index_ahoy_events_on_user_id ON public.ahoy_events USING btree (user_id)"
"public","ahoy_events","index_ahoy_events_on_visit_id",NULL,"CREATE INDEX index_ahoy_events_on_visit_id ON public.ahoy_events USING btree (visit_id)"
"public","spree_assets","index_assets_on_viewable_id",NULL,"CREATE INDEX index_assets_on_viewable_id ON public.spree_assets USING btree (viewable_id)"
"public","spree_assets","index_assets_on_viewable_type_and_type",NULL,"CREATE INDEX index_assets_on_viewable_type_and_type ON public.spree_assets USING btree (viewable_type, type)"
"public","batch_import_logs","index_batch_import_logs_on_batch_import_id",NULL,"CREATE INDEX index_batch_import_logs_on_batch_import_id ON public.batch_import_logs USING btree (batch_import_id)"
"public","bisac_hierarchies","index_bisac_hierarchies_on_generations",NULL,"CREATE INDEX index_bisac_hierarchies_on_generations ON public.bisac_hierarchies USING btree (generations)"
"public","bisacs","index_bisacs_on_code",NULL,"CREATE INDEX index_bisacs_on_code ON public.bisacs USING btree (code)"
"public","bisacs","index_bisacs_on_parent_id",NULL,"CREATE INDEX index_bisacs_on_parent_id ON public.bisacs USING btree (parent_id)"
"public","catalog_import_logs","index_catalog_import_logs_on_batch_import_id",NULL,"CREATE INDEX index_catalog_import_logs_on_batch_import_id ON public.catalog_import_logs USING btree (batch_import_id)"
"public","email_domains","index_email_domains_on_domain",NULL,"CREATE INDEX index_email_domains_on_domain ON public.email_domains USING btree (domain)"
"public","exact_target_api_call_logs","index_exact_target_api_call_logs_on_customer_key",NULL,"CREATE INDEX index_exact_target_api_call_logs_on_customer_key ON public.exact_target_api_call_logs USING btree (customer_key)"
"public","exact_target_api_call_logs","index_exact_target_api_call_logs_on_send_request_id",NULL,"CREATE INDEX index_exact_target_api_call_logs_on_send_request_id ON public.exact_target_api_call_logs USING btree (send_request_id)"
"public","exact_target_api_call_logs","index_exact_target_api_call_logs_on_success",NULL,"CREATE INDEX index_exact_target_api_call_logs_on_success ON public.exact_target_api_call_logs USING btree (success)"
"public","failed_credit_cards","index_failed_credit_cards_on_digits_first_and_last",NULL,"CREATE INDEX index_failed_credit_cards_on_digits_first_and_last ON public.failed_credit_cards USING btree (last_digits, last_name, first_name)"
"public","failed_credit_cards","index_failed_credit_cards_on_user_id",NULL,"CREATE INDEX index_failed_credit_cards_on_user_id ON public.failed_credit_cards USING btree (user_id)"
"public","gift_cards","index_gift_cards_on_number",NULL,"CREATE INDEX index_gift_cards_on_number ON public.gift_cards USING btree (number)"
"public","spree_inventory_units","index_inventory_units_on_order_id",NULL,"CREATE INDEX index_inventory_units_on_order_id ON public.spree_inventory_units USING btree (order_id)"
"public","spree_inventory_units","index_inventory_units_on_shipment_id",NULL,"CREATE INDEX index_inventory_units_on_shipment_id ON public.spree_inventory_units USING btree (shipment_id)"
"public","spree_inventory_units","index_inventory_units_on_variant_id",NULL,"CREATE INDEX index_inventory_units_on_variant_id ON public.spree_inventory_units USING btree (variant_id)"
"public","monsoon_inventories","index_monsoon_inventories_on_isbn",NULL,"CREATE INDEX index_monsoon_inventories_on_isbn ON public.monsoon_inventories USING btree (isbn)"
"public","nyt_best_sellers","index_nyt_best_sellers_on_product_id",NULL,"CREATE INDEX index_nyt_best_sellers_on_product_id ON public.nyt_best_sellers USING btree (product_id)"
"public","spree_option_values_variants","index_option_values_variants_on_variant_id_and_option_value_id",NULL,"CREATE INDEX index_option_values_variants_on_variant_id_and_option_value_id ON public.spree_option_values_variants USING btree (variant_id, option_value_id)"
"public","product_families","index_product_families_on_family_id",NULL,"CREATE INDEX index_product_families_on_family_id ON public.product_families USING btree (family_id)"
"public","product_families","index_product_families_on_hpb_catalog_id_and_family_id",NULL,"CREATE INDEX index_product_families_on_hpb_catalog_id_and_family_id ON public.product_families USING btree (hpb_catalog_id, family_id)"
"public","spree_product_properties","index_product_properties_on_product_id",NULL,"CREATE INDEX index_product_properties_on_product_id ON public.spree_product_properties USING btree (product_id)"
"public","spree_products_promotion_rules","index_products_promotion_rules_on_product_id",NULL,"CREATE INDEX index_products_promotion_rules_on_product_id ON public.spree_products_promotion_rules USING btree (product_id)"
"public","spree_products_promotion_rules","index_products_promotion_rules_on_promotion_rule_id",NULL,"CREATE INDEX index_products_promotion_rules_on_promotion_rule_id ON public.spree_products_promotion_rules USING btree (promotion_rule_id)"
"public","products_quirky_tags","index_products_quirky_tags_on_product_id_and_quirky_tag_id",NULL,"CREATE UNIQUE INDEX index_products_quirky_tags_on_product_id_and_quirky_tag_id ON public.products_quirky_tags USING btree (product_id, quirky_tag_id)"
"public","spree_promotion_rules","index_promotion_rules_on_product_group_id",NULL,"CREATE INDEX index_promotion_rules_on_product_group_id ON public.spree_promotion_rules USING btree (product_group_id)"
"public","spree_promotion_rules","index_promotion_rules_on_user_id",NULL,"CREATE INDEX index_promotion_rules_on_user_id ON public.spree_promotion_rules USING btree (user_id)"
"public","spree_promotion_rules_users","index_promotion_rules_users_on_promotion_rule_id",NULL,"CREATE INDEX index_promotion_rules_users_on_promotion_rule_id ON public.spree_promotion_rules_users USING btree (promotion_rule_id)"
"public","spree_promotion_rules_users","index_promotion_rules_users_on_user_id",NULL,"CREATE INDEX index_promotion_rules_users_on_user_id ON public.spree_promotion_rules_users USING btree (user_id)"
"public","quirky_tags","index_quirky_tags_on_slug",NULL,"CREATE UNIQUE INDEX index_quirky_tags_on_slug ON public.quirky_tags USING btree (slug)"
"public","return_items","index_return_items_on_inventory_unit_id",NULL,"CREATE INDEX index_return_items_on_inventory_unit_id ON public.return_items USING btree (inventory_unit_id)"
"public","sales_ranks","index_sales_ranks_on_upc",NULL,"CREATE INDEX index_sales_ranks_on_upc ON public.sales_ranks USING btree (upc)"
"public","sales_summary_bisacs","index_sales_sumamry_bisacs_on_code",NULL,"CREATE INDEX index_sales_sumamry_bisacs_on_code ON public.sales_summary_bisacs USING btree (code)"
"public","sales_summaries","index_sales_summaries_on_completed_at",NULL,"CREATE INDEX index_sales_summaries_on_completed_at ON public.sales_summaries USING btree (completed_at)"
"public","sales_summaries","index_sales_summaries_on_product_type_and_completed_at",NULL,"CREATE INDEX index_sales_summaries_on_product_type_and_completed_at ON public.sales_summaries USING btree (completed_at) WHERE ((product_type)::text = 'Catalog::Video'::text)"
"public","sales_summaries","index_sales_summaries_on_product_type_audio_and_completed_at",NULL,"CREATE INDEX index_sales_summaries_on_product_type_audio_and_completed_at ON public.sales_summaries USING btree (completed_at) WHERE ((product_type)::text = 'Catalog::Audio'::text)"
"public","sales_summaries","index_sales_summaries_on_product_type_book_and_completed_at",NULL,"CREATE INDEX index_sales_summaries_on_product_type_book_and_completed_at ON public.sales_summaries USING btree (completed_at) WHERE ((product_type)::text = 'Catalog::Book'::text)"
"public","sales_summary_bisacs","index_sales_summary_bisacs_on_sales_summary_id",NULL,"CREATE INDEX index_sales_summary_bisacs_on_sales_summary_id ON public.sales_summary_bisacs USING btree (sales_summary_id)"
"public","spree_shipments","index_shipments_on_number",NULL,"CREATE INDEX index_shipments_on_number ON public.spree_shipments USING btree (number)"
"public","spree_addresses","index_spree_addresses_on_user_id",NULL,"CREATE INDEX index_spree_addresses_on_user_id ON public.spree_addresses USING btree (user_id)"
"public","spree_adjustments","index_spree_adjustments_on_order_id",NULL,"CREATE INDEX index_spree_adjustments_on_order_id ON public.spree_adjustments USING btree (order_id)"
"public","spree_adjustments","index_spree_adjustments_on_source_type_and_source_id",NULL,"CREATE INDEX index_spree_adjustments_on_source_type_and_source_id ON public.spree_adjustments USING btree (source_type, source_id)"
"public","spree_calculators","index_spree_calculators_on_calculable_id_and_calculable_type",NULL,"CREATE INDEX index_spree_calculators_on_calculable_id_and_calculable_type ON public.spree_calculators USING btree (calculable_id, calculable_type)"
"public","spree_calculators","index_spree_calculators_on_id_and_type",NULL,"CREATE INDEX index_spree_calculators_on_id_and_type ON public.spree_calculators USING btree (id, type)"
"public","spree_configurations","index_spree_configurations_on_name_and_type",NULL,"CREATE INDEX index_spree_configurations_on_name_and_type ON public.spree_configurations USING btree (name, type)"
"public","spree_credit_cards","index_spree_credit_cards_on_payment_method_id",NULL,"CREATE INDEX index_spree_credit_cards_on_payment_method_id ON public.spree_credit_cards USING btree (payment_method_id)"
"public","spree_credit_cards","index_spree_credit_cards_on_user_id",NULL,"CREATE INDEX index_spree_credit_cards_on_user_id ON public.spree_credit_cards USING btree (user_id)"
"public","spree_inventory_units","index_spree_inventory_units_on_line_item_id",NULL,"CREATE INDEX index_spree_inventory_units_on_line_item_id ON public.spree_inventory_units USING btree (line_item_id)"
"public","spree_line_items","index_spree_line_items_on_order_id",NULL,"CREATE INDEX index_spree_line_items_on_order_id ON public.spree_line_items USING btree (order_id)"
"public","spree_line_items","index_spree_line_items_on_variant_id",NULL,"CREATE INDEX index_spree_line_items_on_variant_id ON public.spree_line_items USING btree (variant_id)"
"public","spree_option_values","index_spree_option_values_on_option_type_id",NULL,"CREATE INDEX index_spree_option_values_on_option_type_id ON public.spree_option_values USING btree (option_type_id)"
"public","spree_option_values_variants","index_spree_option_values_variants_on_variant_id",NULL,"CREATE INDEX index_spree_option_values_variants_on_variant_id ON public.spree_option_values_variants USING btree (variant_id)"
"public","spree_orders","index_spree_orders_on_completed_at",NULL,"CREATE INDEX index_spree_orders_on_completed_at ON public.spree_orders USING btree (completed_at)"
"public","spree_orders","index_spree_orders_on_number",NULL,"CREATE INDEX index_spree_orders_on_number ON public.spree_orders USING btree (number)"
"public","spree_orders","index_spree_orders_on_user_id",NULL,"CREATE INDEX index_spree_orders_on_user_id ON public.spree_orders USING btree (user_id)"
"public","spree_orders","index_spree_orders_on_user_id_and_created_by_id",NULL,"CREATE INDEX index_spree_orders_on_user_id_and_created_by_id ON public.spree_orders USING btree (user_id, created_by_id)"
"public","spree_payment_capture_events","index_spree_payment_capture_events_on_payment_id",NULL,"CREATE INDEX index_spree_payment_capture_events_on_payment_id ON public.spree_payment_capture_events USING btree (payment_id)"
"public","spree_payment_methods","index_spree_payment_methods_on_id_and_type",NULL,"CREATE INDEX index_spree_payment_methods_on_id_and_type ON public.spree_payment_methods USING btree (id, type)"
"public","spree_payments","index_spree_payments_on_order_id",NULL,"CREATE INDEX index_spree_payments_on_order_id ON public.spree_payments USING btree (order_id)"
"public","spree_payments","index_spree_payments_on_payment_method_id",NULL,"CREATE INDEX index_spree_payments_on_payment_method_id ON public.spree_payments USING btree (payment_method_id)"
"public","spree_preferences","index_spree_preferences_on_key",NULL,"CREATE UNIQUE INDEX index_spree_preferences_on_key ON public.spree_preferences USING btree (key)"
"public","spree_prices","index_spree_prices_on_variant_id_and_currency",NULL,"CREATE INDEX index_spree_prices_on_variant_id_and_currency ON public.spree_prices USING btree (variant_id, currency)"
"public","spree_products","index_spree_products_on_deleted_at",NULL,"CREATE INDEX index_spree_products_on_deleted_at ON public.spree_products USING btree (deleted_at)"
"public","spree_products","index_spree_products_on_deleted_at_and_rare_find_and_ep_showcas",NULL,"CREATE INDEX index_spree_products_on_deleted_at_and_rare_find_and_ep_showcas ON public.spree_products USING btree (deleted_at, rare_find, ((extended_properties -> 'showcase'::text)))"
"public","spree_products","index_spree_products_on_format_description",NULL,"CREATE INDEX index_spree_products_on_format_description ON public.spree_products USING btree (format_description)"
"public","spree_products","index_spree_products_on_funky_find",NULL,"CREATE INDEX index_spree_products_on_funky_find ON public.spree_products USING btree (funky_find)"
"public","spree_products","index_spree_products_on_has_image",NULL,"CREATE INDEX index_spree_products_on_has_image ON public.spree_products USING btree (has_image)"
"public","spree_products","index_spree_products_on_hpb_catalog_id",NULL,"CREATE INDEX index_spree_products_on_hpb_catalog_id ON public.spree_products USING btree (hpb_catalog_id)"
"public","spree_products","index_spree_products_on_lowercase_name",NULL,"CREATE INDEX index_spree_products_on_lowercase_name ON public.spree_products USING btree (lower((name)::text))"
"public","spree_products","index_spree_products_on_monsoon_upc",NULL,"CREATE INDEX index_spree_products_on_monsoon_upc ON public.spree_products USING btree (monsoon_upc)"
"public","spree_products","index_spree_products_on_name",NULL,"CREATE INDEX index_spree_products_on_name ON public.spree_products USING btree (name)"
"public","spree_products","index_spree_products_on_rare_find",NULL,"CREATE INDEX index_spree_products_on_rare_find ON public.spree_products USING btree (rare_find)"
"public","spree_products","index_spree_products_on_type",NULL,"CREATE INDEX index_spree_products_on_type ON public.spree_products USING btree (type)"
"public","spree_products","index_spree_products_on_upc",NULL,"CREATE INDEX index_spree_products_on_upc ON public.spree_products USING btree (upc)"
"public","spree_products_taxons","index_spree_products_taxons_on_product_id",NULL,"CREATE INDEX index_spree_products_taxons_on_product_id ON public.spree_products_taxons USING btree (product_id)"
"public","spree_products_taxons","index_spree_products_taxons_on_taxon_id",NULL,"CREATE INDEX index_spree_products_taxons_on_taxon_id ON public.spree_products_taxons USING btree (taxon_id)"
"public","spree_promotion_actions","index_spree_promotion_actions_on_deleted_at",NULL,"CREATE INDEX index_spree_promotion_actions_on_deleted_at ON public.spree_promotion_actions USING btree (deleted_at)"
"public","spree_promotion_actions","index_spree_promotion_actions_on_id_and_type",NULL,"CREATE INDEX index_spree_promotion_actions_on_id_and_type ON public.spree_promotion_actions USING btree (id, type)"
"public","spree_promotion_actions","index_spree_promotion_actions_on_promotion_id",NULL,"CREATE INDEX index_spree_promotion_actions_on_promotion_id ON public.spree_promotion_actions USING btree (promotion_id)"
"public","spree_promotions","index_spree_promotions_on_id_and_type",NULL,"CREATE INDEX index_spree_promotions_on_id_and_type ON public.spree_promotions USING btree (id, type)"
"public","spree_roles_users","index_spree_roles_users_on_role_id",NULL,"CREATE INDEX index_spree_roles_users_on_role_id ON public.spree_roles_users USING btree (role_id)"
"public","spree_roles_users","index_spree_roles_users_on_user_id",NULL,"CREATE INDEX index_spree_roles_users_on_user_id ON public.spree_roles_users USING btree (user_id)"
"public","spree_shipments","index_spree_shipments_on_order_id",NULL,"CREATE INDEX index_spree_shipments_on_order_id ON public.spree_shipments USING btree (order_id)"
"public","spree_shipments","index_spree_shipments_on_stock_location_id",NULL,"CREATE INDEX index_spree_shipments_on_stock_location_id ON public.spree_shipments USING btree (stock_location_id)"
"public","spree_shipping_method_categories","index_spree_shipping_method_categories_on_shipping_method_id",NULL,"CREATE INDEX index_spree_shipping_method_categories_on_shipping_method_id ON public.spree_shipping_method_categories USING btree (shipping_method_id)"
"public","spree_stock_items2","index_spree_stock_items2_1",NULL,"CREATE INDEX index_spree_stock_items2_1 ON public.spree_stock_items2 USING btree (stock_location_id)"
"public","spree_stock_items2","index_spree_stock_items2_2",NULL,"CREATE INDEX index_spree_stock_items2_2 ON public.spree_stock_items2 USING btree (updated_at DESC NULLS LAST)"
"public","spree_stock_items2","index_spree_stock_items2_3",NULL,"CREATE INDEX index_spree_stock_items2_3 ON public.spree_stock_items2 USING btree (variant_id)"
"public","spree_stock_items","index_spree_stock_items_by_stock_location_id_and_count_and_upda",NULL,"CREATE INDEX index_spree_stock_items_by_stock_location_id_and_count_and_upda ON public.spree_stock_items USING btree (stock_location_id, count_on_hand, updated_at)"
"public","spree_stock_items","index_spree_stock_items_location_stocked_updates",NULL,"CREATE INDEX index_spree_stock_items_location_stocked_updates ON public.spree_stock_items USING btree (stock_location_id, updated_at DESC) WHERE (count_on_hand > 0)"
"public","spree_stock_items","index_spree_stock_items_on_count_on_hand",NULL,"CREATE INDEX index_spree_stock_items_on_count_on_hand ON public.spree_stock_items USING btree (count_on_hand)"
"public","spree_stock_items2","index_spree_stock_items_on_count_on_hand2",NULL,"CREATE INDEX index_spree_stock_items_on_count_on_hand2 ON public.spree_stock_items2 USING btree (count_on_hand)"
"public","spree_stock_items","index_spree_stock_items_on_hand",NULL,"CREATE INDEX index_spree_stock_items_on_hand ON public.spree_stock_items USING btree (count_on_hand) WHERE (count_on_hand > 0)"
"public","spree_stock_items","index_spree_stock_items_on_stock_location_id",NULL,"CREATE INDEX index_spree_stock_items_on_stock_location_id ON public.spree_stock_items USING btree (stock_location_id)"
"public","spree_stock_items","index_spree_stock_items_on_stock_location_id_and_count_on_hand",NULL,"CREATE INDEX index_spree_stock_items_on_stock_location_id_and_count_on_hand ON public.spree_stock_items USING btree (stock_location_id, count_on_hand)"
"public","spree_stock_items","index_spree_stock_items_on_variant_id",NULL,"CREATE INDEX index_spree_stock_items_on_variant_id ON public.spree_stock_items USING btree (variant_id)"
"public","spree_stock_items","index_spree_stock_items_stocked_by_loc_and_time_desc",NULL,"CREATE INDEX index_spree_stock_items_stocked_by_loc_and_time_desc ON public.spree_stock_items USING btree (stock_location_id, updated_at DESC)"
"public","spree_stock_items","index_spree_stock_items_stocked_by_location_and_time",NULL,"CREATE INDEX index_spree_stock_items_stocked_by_location_and_time ON public.spree_stock_items USING btree (stock_location_id, updated_at DESC) WHERE (count_on_hand > 0)"
"public","spree_stock_locations","index_spree_stock_locations_on_facility_id",NULL,"CREATE INDEX index_spree_stock_locations_on_facility_id ON public.spree_stock_locations USING btree (facility_id)"
"public","spree_stock_locations","index_spree_stock_locations_on_hpb_location_no",NULL,"CREATE INDEX index_spree_stock_locations_on_hpb_location_no ON public.spree_stock_locations USING btree (hpb_location_no)"
"public","spree_stock_locations","index_spree_stock_locations_on_store_code",NULL,"CREATE INDEX index_spree_stock_locations_on_store_code ON public.spree_stock_locations USING btree (store_code)"
"public","spree_stock_locations_store_events","index_spree_stock_locations_store_events_on_stock_location_id",NULL,"CREATE INDEX index_spree_stock_locations_store_events_on_stock_location_id ON public.spree_stock_locations_store_events USING btree (stock_location_id)"
"public","spree_stock_movements","index_spree_stock_movements_on_stock_item_id",NULL,"CREATE INDEX index_spree_stock_movements_on_stock_item_id ON public.spree_stock_movements USING btree (stock_item_id)"
"public","spree_stock_transfers","index_spree_stock_transfers_on_destination_location_id",NULL,"CREATE INDEX index_spree_stock_transfers_on_destination_location_id ON public.spree_stock_transfers USING btree (destination_location_id)"
"public","spree_stock_transfers","index_spree_stock_transfers_on_number",NULL,"CREATE INDEX index_spree_stock_transfers_on_number ON public.spree_stock_transfers USING btree (number)"
"public","spree_stock_transfers","index_spree_stock_transfers_on_source_location_id",NULL,"CREATE INDEX index_spree_stock_transfers_on_source_location_id ON public.spree_stock_transfers USING btree (source_location_id)"
"public","spree_users","index_spree_users_on_spree_api_key",NULL,"CREATE INDEX index_spree_users_on_spree_api_key ON public.spree_users USING btree (spree_api_key)"
"public","spree_variants","index_spree_variants_on_is_master",NULL,"CREATE INDEX index_spree_variants_on_is_master ON public.spree_variants USING btree (is_master)"
"public","spree_variants","index_spree_variants_on_is_master_and_sku",NULL,"CREATE INDEX index_spree_variants_on_is_master_and_sku ON public.spree_variants USING btree (is_master, sku)"
"public","spree_variants","index_spree_variants_on_item_type",NULL,"CREATE INDEX index_spree_variants_on_item_type ON public.spree_variants USING btree (item_type)"
"public","spree_variants","index_spree_variants_on_product_id",NULL,"CREATE INDEX index_spree_variants_on_product_id ON public.spree_variants USING btree (product_id)"
"public","spree_variants","index_spree_variants_on_sku",NULL,"CREATE INDEX index_spree_variants_on_sku ON public.spree_variants USING btree (sku)"
"public","spree_variants","index_spree_variants_on_tax_category_id",NULL,"CREATE INDEX index_spree_variants_on_tax_category_id ON public.spree_variants USING btree (tax_category_id)"
"public","spree_variants","index_spree_variants_on_type",NULL,"CREATE INDEX index_spree_variants_on_type ON public.spree_variants USING btree (type)"
"public","staff_picks","index_staff_picks_on_created_at",NULL,"CREATE INDEX index_staff_picks_on_created_at ON public.staff_picks USING btree (created_at)"
"public","staff_picks","index_staff_picks_on_media_type",NULL,"CREATE INDEX index_staff_picks_on_media_type ON public.staff_picks USING btree (media_type)"
"public","staff_picks","index_staff_picks_on_product_id",NULL,"CREATE INDEX index_staff_picks_on_product_id ON public.staff_picks USING btree (product_id)"
"public","staff_picks","index_staff_picks_on_stock_location_id",NULL,"CREATE INDEX index_staff_picks_on_stock_location_id ON public.staff_picks USING btree (stock_location_id)"
"public","spree_stock_locations_store_events","index_stock_locations_store_events_on_location_and_event",NULL,"CREATE INDEX index_stock_locations_store_events_on_location_and_event ON public.spree_stock_locations_store_events USING btree (stock_location_id, store_event_id)"
"public","tax_rates","index_tax_rates_on_zip",NULL,"CREATE INDEX index_tax_rates_on_zip ON public.tax_rates USING btree (zip)"
"public","spree_taxons","index_taxons_on_parent_id",NULL,"CREATE INDEX index_taxons_on_parent_id ON public.spree_taxons USING btree (parent_id)"
"public","spree_taxons","index_taxons_on_permalink",NULL,"CREATE INDEX index_taxons_on_permalink ON public.spree_taxons USING btree (permalink)"
"public","spree_taxons","index_taxons_on_taxonomy_id",NULL,"CREATE INDEX index_taxons_on_taxonomy_id ON public.spree_taxons USING btree (taxonomy_id)"
"public","spree_tokenized_permissions","index_tokenized_name_and_type",NULL,"CREATE INDEX index_tokenized_name_and_type ON public.spree_tokenized_permissions USING btree (permissable_id, permissable_type)"
"public","spree_variants","index_undeleted_masters_on_product_id",NULL,"CREATE INDEX index_undeleted_masters_on_product_id ON public.spree_variants USING btree (product_id) WHERE ((deleted_at IS NULL) AND is_master)"
"public","visits","index_visits_on_user_id",NULL,"CREATE INDEX index_visits_on_user_id ON public.visits USING btree (user_id)"
"public","visits","index_visits_on_visitor_id",NULL,"CREATE INDEX index_visits_on_visitor_id ON public.visits USING btree (visitor_id)"
"public","invoices","invoices_pkey",NULL,"CREATE UNIQUE INDEX invoices_pkey ON public.invoices USING btree (id)"
"public","monsoon_api_call_logs","monsoon_api_call_logs_pkey",NULL,"CREATE UNIQUE INDEX monsoon_api_call_logs_pkey ON public.monsoon_api_call_logs USING btree (id)"
"public","nyt_best_sellers","nyt_best_sellers_pkey",NULL,"CREATE UNIQUE INDEX nyt_best_sellers_pkey ON public.nyt_best_sellers USING btree (id)"
"public","spree_products","permalink_idx_unique",NULL,"CREATE UNIQUE INDEX permalink_idx_unique ON public.spree_products USING btree (slug)"
"pg_catalog","pg_aggregate","pg_aggregate_fnoid_index",NULL,"CREATE UNIQUE INDEX pg_aggregate_fnoid_index ON pg_catalog.pg_aggregate USING btree (aggfnoid)"
"pg_catalog","pg_am","pg_am_name_index",NULL,"CREATE UNIQUE INDEX pg_am_name_index ON pg_catalog.pg_am USING btree (amname)"
"pg_catalog","pg_am","pg_am_oid_index",NULL,"CREATE UNIQUE INDEX pg_am_oid_index ON pg_catalog.pg_am USING btree (oid)"
"pg_catalog","pg_amop","pg_amop_fam_strat_index",NULL,"CREATE UNIQUE INDEX pg_amop_fam_strat_index ON pg_catalog.pg_amop USING btree (amopfamily, amoplefttype, amoprighttype, amopstrategy)"
"pg_catalog","pg_amop","pg_amop_oid_index",NULL,"CREATE UNIQUE INDEX pg_amop_oid_index ON pg_catalog.pg_amop USING btree (oid)"
"pg_catalog","pg_amop","pg_amop_opr_fam_index",NULL,"CREATE UNIQUE INDEX pg_amop_opr_fam_index ON pg_catalog.pg_amop USING btree (amopopr, amoppurpose, amopfamily)"
"pg_catalog","pg_amproc","pg_amproc_fam_proc_index",NULL,"CREATE UNIQUE INDEX pg_amproc_fam_proc_index ON pg_catalog.pg_amproc USING btree (amprocfamily, amproclefttype, amprocrighttype, amprocnum)"
"pg_catalog","pg_amproc","pg_amproc_oid_index",NULL,"CREATE UNIQUE INDEX pg_amproc_oid_index ON pg_catalog.pg_amproc USING btree (oid)"
"pg_catalog","pg_attrdef","pg_attrdef_adrelid_adnum_index",NULL,"CREATE UNIQUE INDEX pg_attrdef_adrelid_adnum_index ON pg_catalog.pg_attrdef USING btree (adrelid, adnum)"
"pg_catalog","pg_attrdef","pg_attrdef_oid_index",NULL,"CREATE UNIQUE INDEX pg_attrdef_oid_index ON pg_catalog.pg_attrdef USING btree (oid)"
"pg_catalog","pg_attribute","pg_attribute_relid_attnam_index",NULL,"CREATE UNIQUE INDEX pg_attribute_relid_attnam_index ON pg_catalog.pg_attribute USING btree (attrelid, attname)"
"pg_catalog","pg_attribute","pg_attribute_relid_attnum_index",NULL,"CREATE UNIQUE INDEX pg_attribute_relid_attnum_index ON pg_catalog.pg_attribute USING btree (attrelid, attnum)"
"pg_catalog","pg_auth_members","pg_auth_members_member_role_index","pg_global","CREATE UNIQUE INDEX pg_auth_members_member_role_index ON pg_catalog.pg_auth_members USING btree (member, roleid)"
"pg_catalog","pg_auth_members","pg_auth_members_role_member_index","pg_global","CREATE UNIQUE INDEX pg_auth_members_role_member_index ON pg_catalog.pg_auth_members USING btree (roleid, member)"
"pg_catalog","pg_authid","pg_authid_oid_index","pg_global","CREATE UNIQUE INDEX pg_authid_oid_index ON pg_catalog.pg_authid USING btree (oid)"
"pg_catalog","pg_authid","pg_authid_rolname_index","pg_global","CREATE UNIQUE INDEX pg_authid_rolname_index ON pg_catalog.pg_authid USING btree (rolname)"
"pg_catalog","pg_cast","pg_cast_oid_index",NULL,"CREATE UNIQUE INDEX pg_cast_oid_index ON pg_catalog.pg_cast USING btree (oid)"
"pg_catalog","pg_cast","pg_cast_source_target_index",NULL,"CREATE UNIQUE INDEX pg_cast_source_target_index ON pg_catalog.pg_cast USING btree (castsource, casttarget)"
"pg_catalog","pg_class","pg_class_oid_index",NULL,"CREATE UNIQUE INDEX pg_class_oid_index ON pg_catalog.pg_class USING btree (oid)"
"pg_catalog","pg_class","pg_class_relname_nsp_index",NULL,"CREATE UNIQUE INDEX pg_class_relname_nsp_index ON pg_catalog.pg_class USING btree (relname, relnamespace)"
"pg_catalog","pg_class","pg_class_tblspc_relfilenode_index",NULL,"CREATE INDEX pg_class_tblspc_relfilenode_index ON pg_catalog.pg_class USING btree (reltablespace, relfilenode)"
"pg_catalog","pg_collation","pg_collation_name_enc_nsp_index",NULL,"CREATE UNIQUE INDEX pg_collation_name_enc_nsp_index ON pg_catalog.pg_collation USING btree (collname, collencoding, collnamespace)"
"pg_catalog","pg_collation","pg_collation_oid_index",NULL,"CREATE UNIQUE INDEX pg_collation_oid_index ON pg_catalog.pg_collation USING btree (oid)"
"pg_catalog","pg_constraint","pg_constraint_conname_nsp_index",NULL,"CREATE INDEX pg_constraint_conname_nsp_index ON pg_catalog.pg_constraint USING btree (conname, connamespace)"
"pg_catalog","pg_constraint","pg_constraint_conrelid_index",NULL,"CREATE INDEX pg_constraint_conrelid_index ON pg_catalog.pg_constraint USING btree (conrelid)"
"pg_catalog","pg_constraint","pg_constraint_contypid_index",NULL,"CREATE INDEX pg_constraint_contypid_index ON pg_catalog.pg_constraint USING btree (contypid)"
"pg_catalog","pg_constraint","pg_constraint_oid_index",NULL,"CREATE UNIQUE INDEX pg_constraint_oid_index ON pg_catalog.pg_constraint USING btree (oid)"
"pg_catalog","pg_conversion","pg_conversion_default_index",NULL,"CREATE UNIQUE INDEX pg_conversion_default_index ON pg_catalog.pg_conversion USING btree (connamespace, conforencoding, contoencoding, oid)"
"pg_catalog","pg_conversion","pg_conversion_name_nsp_index",NULL,"CREATE UNIQUE INDEX pg_conversion_name_nsp_index ON pg_catalog.pg_conversion USING btree (conname, connamespace)"
"pg_catalog","pg_conversion","pg_conversion_oid_index",NULL,"CREATE UNIQUE INDEX pg_conversion_oid_index ON pg_catalog.pg_conversion USING btree (oid)"
"pg_catalog","pg_database","pg_database_datname_index","pg_global","CREATE UNIQUE INDEX pg_database_datname_index ON pg_catalog.pg_database USING btree (datname)"
"pg_catalog","pg_database","pg_database_oid_index","pg_global","CREATE UNIQUE INDEX pg_database_oid_index ON pg_catalog.pg_database USING btree (oid)"
"pg_catalog","pg_db_role_setting","pg_db_role_setting_databaseid_rol_index","pg_global","CREATE UNIQUE INDEX pg_db_role_setting_databaseid_rol_index ON pg_catalog.pg_db_role_setting USING btree (setdatabase, setrole)"
"pg_catalog","pg_default_acl","pg_default_acl_oid_index",NULL,"CREATE UNIQUE INDEX pg_default_acl_oid_index ON pg_catalog.pg_default_acl USING btree (oid)"
"pg_catalog","pg_default_acl","pg_default_acl_role_nsp_obj_index",NULL,"CREATE UNIQUE INDEX pg_default_acl_role_nsp_obj_index ON pg_catalog.pg_default_acl USING btree (defaclrole, defaclnamespace, defaclobjtype)"
"pg_catalog","pg_depend","pg_depend_depender_index",NULL,"CREATE INDEX pg_depend_depender_index ON pg_catalog.pg_depend USING btree (classid, objid, objsubid)"
"pg_catalog","pg_depend","pg_depend_reference_index",NULL,"CREATE INDEX pg_depend_reference_index ON pg_catalog.pg_depend USING btree (refclassid, refobjid, refobjsubid)"
"pg_catalog","pg_description","pg_description_o_c_o_index",NULL,"CREATE UNIQUE INDEX pg_description_o_c_o_index ON pg_catalog.pg_description USING btree (objoid, classoid, objsubid)"
"pg_catalog","pg_enum","pg_enum_oid_index",NULL,"CREATE UNIQUE INDEX pg_enum_oid_index ON pg_catalog.pg_enum USING btree (oid)"
"pg_catalog","pg_enum","pg_enum_typid_label_index",NULL,"CREATE UNIQUE INDEX pg_enum_typid_label_index ON pg_catalog.pg_enum USING btree (enumtypid, enumlabel)"
"pg_catalog","pg_enum","pg_enum_typid_sortorder_index",NULL,"CREATE UNIQUE INDEX pg_enum_typid_sortorder_index ON pg_catalog.pg_enum USING btree (enumtypid, enumsortorder)"
"pg_catalog","pg_event_trigger","pg_event_trigger_evtname_index",NULL,"CREATE UNIQUE INDEX pg_event_trigger_evtname_index ON pg_catalog.pg_event_trigger USING btree (evtname)"
"pg_catalog","pg_event_trigger","pg_event_trigger_oid_index",NULL,"CREATE UNIQUE INDEX pg_event_trigger_oid_index ON pg_catalog.pg_event_trigger USING btree (oid)"
"pg_catalog","pg_extension","pg_extension_name_index",NULL,"CREATE UNIQUE INDEX pg_extension_name_index ON pg_catalog.pg_extension USING btree (extname)"
"pg_catalog","pg_extension","pg_extension_oid_index",NULL,"CREATE UNIQUE INDEX pg_extension_oid_index ON pg_catalog.pg_extension USING btree (oid)"
"pg_catalog","pg_foreign_data_wrapper","pg_foreign_data_wrapper_name_index",NULL,"CREATE UNIQUE INDEX pg_foreign_data_wrapper_name_index ON pg_catalog.pg_foreign_data_wrapper USING btree (fdwname)"
"pg_catalog","pg_foreign_data_wrapper","pg_foreign_data_wrapper_oid_index",NULL,"CREATE UNIQUE INDEX pg_foreign_data_wrapper_oid_index ON pg_catalog.pg_foreign_data_wrapper USING btree (oid)"
"pg_catalog","pg_foreign_server","pg_foreign_server_name_index",NULL,"CREATE UNIQUE INDEX pg_foreign_server_name_index ON pg_catalog.pg_foreign_server USING btree (srvname)"
"pg_catalog","pg_foreign_server","pg_foreign_server_oid_index",NULL,"CREATE UNIQUE INDEX pg_foreign_server_oid_index ON pg_catalog.pg_foreign_server USING btree (oid)"
"pg_catalog","pg_foreign_table","pg_foreign_table_relid_index",NULL,"CREATE UNIQUE INDEX pg_foreign_table_relid_index ON pg_catalog.pg_foreign_table USING btree (ftrelid)"
"pg_catalog","pg_index","pg_index_indexrelid_index",NULL,"CREATE UNIQUE INDEX pg_index_indexrelid_index ON pg_catalog.pg_index USING btree (indexrelid)"
"pg_catalog","pg_index","pg_index_indrelid_index",NULL,"CREATE INDEX pg_index_indrelid_index ON pg_catalog.pg_index USING btree (indrelid)"
"pg_catalog","pg_inherits","pg_inherits_parent_index",NULL,"CREATE INDEX pg_inherits_parent_index ON pg_catalog.pg_inherits USING btree (inhparent)"
"pg_catalog","pg_inherits","pg_inherits_relid_seqno_index",NULL,"CREATE UNIQUE INDEX pg_inherits_relid_seqno_index ON pg_catalog.pg_inherits USING btree (inhrelid, inhseqno)"
"pg_catalog","pg_init_privs","pg_init_privs_o_c_o_index",NULL,"CREATE UNIQUE INDEX pg_init_privs_o_c_o_index ON pg_catalog.pg_init_privs USING btree (objoid, classoid, objsubid)"
"pg_catalog","pg_language","pg_language_name_index",NULL,"CREATE UNIQUE INDEX pg_language_name_index ON pg_catalog.pg_language USING btree (lanname)"
"pg_catalog","pg_language","pg_language_oid_index",NULL,"CREATE UNIQUE INDEX pg_language_oid_index ON pg_catalog.pg_language USING btree (oid)"
"pg_catalog","pg_largeobject","pg_largeobject_loid_pn_index",NULL,"CREATE UNIQUE INDEX pg_largeobject_loid_pn_index ON pg_catalog.pg_largeobject USING btree (loid, pageno)"
"pg_catalog","pg_largeobject_metadata","pg_largeobject_metadata_oid_index",NULL,"CREATE UNIQUE INDEX pg_largeobject_metadata_oid_index ON pg_catalog.pg_largeobject_metadata USING btree (oid)"
"pg_catalog","pg_namespace","pg_namespace_nspname_index",NULL,"CREATE UNIQUE INDEX pg_namespace_nspname_index ON pg_catalog.pg_namespace USING btree (nspname)"
"pg_catalog","pg_namespace","pg_namespace_oid_index",NULL,"CREATE UNIQUE INDEX pg_namespace_oid_index ON pg_catalog.pg_namespace USING btree (oid)"
"pg_catalog","pg_opclass","pg_opclass_am_name_nsp_index",NULL,"CREATE UNIQUE INDEX pg_opclass_am_name_nsp_index ON pg_catalog.pg_opclass USING btree (opcmethod, opcname, opcnamespace)"
"pg_catalog","pg_opclass","pg_opclass_oid_index",NULL,"CREATE UNIQUE INDEX pg_opclass_oid_index ON pg_catalog.pg_opclass USING btree (oid)"
"pg_catalog","pg_operator","pg_operator_oid_index",NULL,"CREATE UNIQUE INDEX pg_operator_oid_index ON pg_catalog.pg_operator USING btree (oid)"
"pg_catalog","pg_operator","pg_operator_oprname_l_r_n_index",NULL,"CREATE UNIQUE INDEX pg_operator_oprname_l_r_n_index ON pg_catalog.pg_operator USING btree (oprname, oprleft, oprright, oprnamespace)"
"pg_catalog","pg_opfamily","pg_opfamily_am_name_nsp_index",NULL,"CREATE UNIQUE INDEX pg_opfamily_am_name_nsp_index ON pg_catalog.pg_opfamily USING btree (opfmethod, opfname, opfnamespace)"
"pg_catalog","pg_opfamily","pg_opfamily_oid_index",NULL,"CREATE UNIQUE INDEX pg_opfamily_oid_index ON pg_catalog.pg_opfamily USING btree (oid)"
"pg_catalog","pg_pltemplate","pg_pltemplate_name_index","pg_global","CREATE UNIQUE INDEX pg_pltemplate_name_index ON pg_catalog.pg_pltemplate USING btree (tmplname)"
"pg_catalog","pg_policy","pg_policy_oid_index",NULL,"CREATE UNIQUE INDEX pg_policy_oid_index ON pg_catalog.pg_policy USING btree (oid)"
"pg_catalog","pg_policy","pg_policy_polrelid_polname_index",NULL,"CREATE UNIQUE INDEX pg_policy_polrelid_polname_index ON pg_catalog.pg_policy USING btree (polrelid, polname)"
"pg_catalog","pg_proc","pg_proc_oid_index",NULL,"CREATE UNIQUE INDEX pg_proc_oid_index ON pg_catalog.pg_proc USING btree (oid)"
"pg_catalog","pg_proc","pg_proc_proname_args_nsp_index",NULL,"CREATE UNIQUE INDEX pg_proc_proname_args_nsp_index ON pg_catalog.pg_proc USING btree (proname, proargtypes, pronamespace)"
"pg_catalog","pg_range","pg_range_rngtypid_index",NULL,"CREATE UNIQUE INDEX pg_range_rngtypid_index ON pg_catalog.pg_range USING btree (rngtypid)"
"pg_catalog","pg_replication_origin","pg_replication_origin_roiident_index","pg_global","CREATE UNIQUE INDEX pg_replication_origin_roiident_index ON pg_catalog.pg_replication_origin USING btree (roident)"
"pg_catalog","pg_replication_origin","pg_replication_origin_roname_index","pg_global","CREATE UNIQUE INDEX pg_replication_origin_roname_index ON pg_catalog.pg_replication_origin USING btree (roname text_pattern_ops)"
"pg_catalog","pg_rewrite","pg_rewrite_oid_index",NULL,"CREATE UNIQUE INDEX pg_rewrite_oid_index ON pg_catalog.pg_rewrite USING btree (oid)"
"pg_catalog","pg_rewrite","pg_rewrite_rel_rulename_index",NULL,"CREATE UNIQUE INDEX pg_rewrite_rel_rulename_index ON pg_catalog.pg_rewrite USING btree (ev_class, rulename)"
"pg_catalog","pg_seclabel","pg_seclabel_object_index",NULL,"CREATE UNIQUE INDEX pg_seclabel_object_index ON pg_catalog.pg_seclabel USING btree (objoid, classoid, objsubid, provider text_pattern_ops)"
"pg_catalog","pg_shdepend","pg_shdepend_depender_index","pg_global","CREATE INDEX pg_shdepend_depender_index ON pg_catalog.pg_shdepend USING btree (dbid, classid, objid, objsubid)"
"pg_catalog","pg_shdepend","pg_shdepend_reference_index","pg_global","CREATE INDEX pg_shdepend_reference_index ON pg_catalog.pg_shdepend USING btree (refclassid, refobjid)"
"pg_catalog","pg_shdescription","pg_shdescription_o_c_index","pg_global","CREATE UNIQUE INDEX pg_shdescription_o_c_index ON pg_catalog.pg_shdescription USING btree (objoid, classoid)"
"pg_catalog","pg_shseclabel","pg_shseclabel_object_index","pg_global","CREATE UNIQUE INDEX pg_shseclabel_object_index ON pg_catalog.pg_shseclabel USING btree (objoid, classoid, provider text_pattern_ops)"
"pg_catalog","pg_statistic","pg_statistic_relid_att_inh_index",NULL,"CREATE UNIQUE INDEX pg_statistic_relid_att_inh_index ON pg_catalog.pg_statistic USING btree (starelid, staattnum, stainherit)"
"pg_catalog","pg_tablespace","pg_tablespace_oid_index","pg_global","CREATE UNIQUE INDEX pg_tablespace_oid_index ON pg_catalog.pg_tablespace USING btree (oid)"
"pg_catalog","pg_tablespace","pg_tablespace_spcname_index","pg_global","CREATE UNIQUE INDEX pg_tablespace_spcname_index ON pg_catalog.pg_tablespace USING btree (spcname)"
"pg_catalog","pg_transform","pg_transform_oid_index",NULL,"CREATE UNIQUE INDEX pg_transform_oid_index ON pg_catalog.pg_transform USING btree (oid)"
"pg_catalog","pg_transform","pg_transform_type_lang_index",NULL,"CREATE UNIQUE INDEX pg_transform_type_lang_index ON pg_catalog.pg_transform USING btree (trftype, trflang)"
"pg_catalog","pg_trigger","pg_trigger_oid_index",NULL,"CREATE UNIQUE INDEX pg_trigger_oid_index ON pg_catalog.pg_trigger USING btree (oid)"
"pg_catalog","pg_trigger","pg_trigger_tgconstraint_index",NULL,"CREATE INDEX pg_trigger_tgconstraint_index ON pg_catalog.pg_trigger USING btree (tgconstraint)"
"pg_catalog","pg_trigger","pg_trigger_tgrelid_tgname_index",NULL,"CREATE UNIQUE INDEX pg_trigger_tgrelid_tgname_index ON pg_catalog.pg_trigger USING btree (tgrelid, tgname)"
"pg_catalog","pg_ts_config","pg_ts_config_cfgname_index",NULL,"CREATE UNIQUE INDEX pg_ts_config_cfgname_index ON pg_catalog.pg_ts_config USING btree (cfgname, cfgnamespace)"
"pg_catalog","pg_ts_config_map","pg_ts_config_map_index",NULL,"CREATE UNIQUE INDEX pg_ts_config_map_index ON pg_catalog.pg_ts_config_map USING btree (mapcfg, maptokentype, mapseqno)"
"pg_catalog","pg_ts_config","pg_ts_config_oid_index",NULL,"CREATE UNIQUE INDEX pg_ts_config_oid_index ON pg_catalog.pg_ts_config USING btree (oid)"
"pg_catalog","pg_ts_dict","pg_ts_dict_dictname_index",NULL,"CREATE UNIQUE INDEX pg_ts_dict_dictname_index ON pg_catalog.pg_ts_dict USING btree (dictname, dictnamespace)"
"pg_catalog","pg_ts_dict","pg_ts_dict_oid_index",NULL,"CREATE UNIQUE INDEX pg_ts_dict_oid_index ON pg_catalog.pg_ts_dict USING btree (oid)"
"pg_catalog","pg_ts_parser","pg_ts_parser_oid_index",NULL,"CREATE UNIQUE INDEX pg_ts_parser_oid_index ON pg_catalog.pg_ts_parser USING btree (oid)"
"pg_catalog","pg_ts_parser","pg_ts_parser_prsname_index",NULL,"CREATE UNIQUE INDEX pg_ts_parser_prsname_index ON pg_catalog.pg_ts_parser USING btree (prsname, prsnamespace)"
"pg_catalog","pg_ts_template","pg_ts_template_oid_index",NULL,"CREATE UNIQUE INDEX pg_ts_template_oid_index ON pg_catalog.pg_ts_template USING btree (oid)"
"pg_catalog","pg_ts_template","pg_ts_template_tmplname_index",NULL,"CREATE UNIQUE INDEX pg_ts_template_tmplname_index ON pg_catalog.pg_ts_template USING btree (tmplname, tmplnamespace)"
"pg_catalog","pg_type","pg_type_oid_index",NULL,"CREATE UNIQUE INDEX pg_type_oid_index ON pg_catalog.pg_type USING btree (oid)"
"pg_catalog","pg_type","pg_type_typname_nsp_index",NULL,"CREATE UNIQUE INDEX pg_type_typname_nsp_index ON pg_catalog.pg_type USING btree (typname, typnamespace)"
"pg_catalog","pg_user_mapping","pg_user_mapping_oid_index",NULL,"CREATE UNIQUE INDEX pg_user_mapping_oid_index ON pg_catalog.pg_user_mapping USING btree (oid)"
"pg_catalog","pg_user_mapping","pg_user_mapping_user_server_index",NULL,"CREATE UNIQUE INDEX pg_user_mapping_user_server_index ON pg_catalog.pg_user_mapping USING btree (umuser, umserver)"
"public","product_families","product_families_pkey",NULL,"CREATE UNIQUE INDEX product_families_pkey ON public.product_families USING btree (id)"
"public","quirky_tags","quirky_tags_pkey",NULL,"CREATE UNIQUE INDEX quirky_tags_pkey ON public.quirky_tags USING btree (id)"
"public","refunds","refunds_pkey",NULL,"CREATE UNIQUE INDEX refunds_pkey ON public.refunds USING btree (id)"
"public","return_items","return_items_pkey",NULL,"CREATE UNIQUE INDEX return_items_pkey ON public.return_items USING btree (id)"
"public","sales_summaries","sales_summaries_pkey",NULL,"CREATE UNIQUE INDEX sales_summaries_pkey ON public.sales_summaries USING btree (id)"
"public","sales_summary_bisacs","sales_summary_bisacs_pkey",NULL,"CREATE UNIQUE INDEX sales_summary_bisacs_pkey ON public.sales_summary_bisacs USING btree (id)"
"public","spree_addresses","spree_addresses_pkey",NULL,"CREATE UNIQUE INDEX spree_addresses_pkey ON public.spree_addresses USING btree (id)"
"public","spree_adjustments","spree_adjustments_pkey",NULL,"CREATE UNIQUE INDEX spree_adjustments_pkey ON public.spree_adjustments USING btree (id)"
"public","spree_assets","spree_assets_pkey",NULL,"CREATE UNIQUE INDEX spree_assets_pkey ON public.spree_assets USING btree (id)"
"public","spree_authentication_methods","spree_authentication_methods_pkey",NULL,"CREATE UNIQUE INDEX spree_authentication_methods_pkey ON public.spree_authentication_methods USING btree (id)"
"public","spree_calculators","spree_calculators_pkey",NULL,"CREATE UNIQUE INDEX spree_calculators_pkey ON public.spree_calculators USING btree (id)"
"public","spree_configurations","spree_configurations_pkey",NULL,"CREATE UNIQUE INDEX spree_configurations_pkey ON public.spree_configurations USING btree (id)"
"public","spree_countries","spree_countries_pkey",NULL,"CREATE UNIQUE INDEX spree_countries_pkey ON public.spree_countries USING btree (id)"
"public","spree_credit_cards","spree_credit_cards_pkey",NULL,"CREATE UNIQUE INDEX spree_credit_cards_pkey ON public.spree_credit_cards USING btree (id)"
"public","spree_gateways","spree_gateways_pkey",NULL,"CREATE UNIQUE INDEX spree_gateways_pkey ON public.spree_gateways USING btree (id)"
"public","spree_inventory_units","spree_inventory_units_pkey",NULL,"CREATE UNIQUE INDEX spree_inventory_units_pkey ON public.spree_inventory_units USING btree (id)"
"public","spree_line_items","spree_line_items_pkey",NULL,"CREATE UNIQUE INDEX spree_line_items_pkey ON public.spree_line_items USING btree (id)"
"public","spree_log_entries","spree_log_entries_pkey",NULL,"CREATE UNIQUE INDEX spree_log_entries_pkey ON public.spree_log_entries USING btree (id)"
"public","spree_option_types","spree_option_types_pkey",NULL,"CREATE UNIQUE INDEX spree_option_types_pkey ON public.spree_option_types USING btree (id)"
"public","spree_option_values","spree_option_values_pkey",NULL,"CREATE UNIQUE INDEX spree_option_values_pkey ON public.spree_option_values USING btree (id)"
"public","spree_orders","spree_orders_pkey",NULL,"CREATE UNIQUE INDEX spree_orders_pkey ON public.spree_orders USING btree (id)"
"public","spree_payment_capture_events","spree_payment_capture_events_pkey",NULL,"CREATE UNIQUE INDEX spree_payment_capture_events_pkey ON public.spree_payment_capture_events USING btree (id)"
"public","spree_payment_methods","spree_payment_methods_pkey",NULL,"CREATE UNIQUE INDEX spree_payment_methods_pkey ON public.spree_payment_methods USING btree (id)"
"public","spree_payments","spree_payments_pkey",NULL,"CREATE UNIQUE INDEX spree_payments_pkey ON public.spree_payments USING btree (id)"
"public","spree_preferences","spree_preferences_pkey",NULL,"CREATE UNIQUE INDEX spree_preferences_pkey ON public.spree_preferences USING btree (id)"
"public","spree_prices","spree_prices_pkey",NULL,"CREATE UNIQUE INDEX spree_prices_pkey ON public.spree_prices USING btree (id)"
"public","spree_product_option_types","spree_product_option_types_pkey",NULL,"CREATE UNIQUE INDEX spree_product_option_types_pkey ON public.spree_product_option_types USING btree (id)"
"public","spree_product_properties","spree_product_properties_pkey",NULL,"CREATE UNIQUE INDEX spree_product_properties_pkey ON public.spree_product_properties USING btree (id)"
"public","spree_products","spree_products_pkey",NULL,"CREATE UNIQUE INDEX spree_products_pkey ON public.spree_products USING btree (id)"
"public","spree_products_taxons","spree_products_taxons_pkey",NULL,"CREATE UNIQUE INDEX spree_products_taxons_pkey ON public.spree_products_taxons USING btree (id)"
"public","spree_promotion_action_line_items","spree_promotion_action_line_items_pkey",NULL,"CREATE UNIQUE INDEX spree_promotion_action_line_items_pkey ON public.spree_promotion_action_line_items USING btree (id)"
"public","spree_promotion_actions","spree_promotion_actions_pkey",NULL,"CREATE UNIQUE INDEX spree_promotion_actions_pkey ON public.spree_promotion_actions USING btree (id)"
"public","spree_promotion_rules","spree_promotion_rules_pkey",NULL,"CREATE UNIQUE INDEX spree_promotion_rules_pkey ON public.spree_promotion_rules USING btree (id)"
"public","spree_promotions","spree_promotions_pkey",NULL,"CREATE UNIQUE INDEX spree_promotions_pkey ON public.spree_promotions USING btree (id)"
"public","spree_properties","spree_properties_pkey",NULL,"CREATE UNIQUE INDEX spree_properties_pkey ON public.spree_properties USING btree (id)"
"public","spree_prototypes","spree_prototypes_pkey",NULL,"CREATE UNIQUE INDEX spree_prototypes_pkey ON public.spree_prototypes USING btree (id)"
"public","spree_return_authorizations","spree_return_authorizations_pkey",NULL,"CREATE UNIQUE INDEX spree_return_authorizations_pkey ON public.spree_return_authorizations USING btree (id)"
"public","spree_roles","spree_roles_pkey",NULL,"CREATE UNIQUE INDEX spree_roles_pkey ON public.spree_roles USING btree (id)"
"public","spree_shipments","spree_shipments_pkey",NULL,"CREATE UNIQUE INDEX spree_shipments_pkey ON public.spree_shipments USING btree (id)"
"public","spree_shipping_categories","spree_shipping_categories_pkey",NULL,"CREATE UNIQUE INDEX spree_shipping_categories_pkey ON public.spree_shipping_categories USING btree (id)"
"public","spree_shipping_method_categories","spree_shipping_method_categories_pkey",NULL,"CREATE UNIQUE INDEX spree_shipping_method_categories_pkey ON public.spree_shipping_method_categories USING btree (id)"
"public","spree_shipping_methods","spree_shipping_methods_pkey",NULL,"CREATE UNIQUE INDEX spree_shipping_methods_pkey ON public.spree_shipping_methods USING btree (id)"
"public","spree_shipping_rates","spree_shipping_rates_join_index",NULL,"CREATE UNIQUE INDEX spree_shipping_rates_join_index ON public.spree_shipping_rates USING btree (shipment_id, shipping_method_id)"
"public","spree_shipping_rates","spree_shipping_rates_pkey",NULL,"CREATE UNIQUE INDEX spree_shipping_rates_pkey ON public.spree_shipping_rates USING btree (id)"
"public","spree_state_changes","spree_state_changes_pkey",NULL,"CREATE UNIQUE INDEX spree_state_changes_pkey ON public.spree_state_changes USING btree (id)"
"public","spree_states","spree_states_pkey",NULL,"CREATE UNIQUE INDEX spree_states_pkey ON public.spree_states USING btree (id)"
"public","spree_stock_items2","spree_stock_items2_pkey",NULL,"CREATE UNIQUE INDEX spree_stock_items2_pkey ON public.spree_stock_items2 USING btree (id)"
"public","spree_stock_items","spree_stock_items_pkey",NULL,"CREATE UNIQUE INDEX spree_stock_items_pkey ON public.spree_stock_items USING btree (id)"
"public","spree_stock_locations","spree_stock_locations_pkey",NULL,"CREATE UNIQUE INDEX spree_stock_locations_pkey ON public.spree_stock_locations USING btree (id)"
"public","spree_stock_movements","spree_stock_movements_pkey",NULL,"CREATE UNIQUE INDEX spree_stock_movements_pkey ON public.spree_stock_movements USING btree (id)"
"public","spree_stock_transfers","spree_stock_transfers_pkey",NULL,"CREATE UNIQUE INDEX spree_stock_transfers_pkey ON public.spree_stock_transfers USING btree (id)"
"public","spree_tax_categories","spree_tax_categories_pkey",NULL,"CREATE UNIQUE INDEX spree_tax_categories_pkey ON public.spree_tax_categories USING btree (id)"
"public","spree_tax_rates","spree_tax_rates_pkey",NULL,"CREATE UNIQUE INDEX spree_tax_rates_pkey ON public.spree_tax_rates USING btree (id)"
"public","spree_taxonomies","spree_taxonomies_pkey",NULL,"CREATE UNIQUE INDEX spree_taxonomies_pkey ON public.spree_taxonomies USING btree (id)"
"public","spree_taxons","spree_taxons_pkey",NULL,"CREATE UNIQUE INDEX spree_taxons_pkey ON public.spree_taxons USING btree (id)"
"public","spree_tokenized_permissions","spree_tokenized_permissions_pkey",NULL,"CREATE UNIQUE INDEX spree_tokenized_permissions_pkey ON public.spree_tokenized_permissions USING btree (id)"
"public","spree_trackers","spree_trackers_pkey",NULL,"CREATE UNIQUE INDEX spree_trackers_pkey ON public.spree_trackers USING btree (id)"
"public","spree_user_authentications","spree_user_authentications_pkey",NULL,"CREATE UNIQUE INDEX spree_user_authentications_pkey ON public.spree_user_authentications USING btree (id)"
"public","spree_users","spree_users_pkey",NULL,"CREATE UNIQUE INDEX spree_users_pkey ON public.spree_users USING btree (id)"
"public","spree_variants","spree_variants_pkey",NULL,"CREATE UNIQUE INDEX spree_variants_pkey ON public.spree_variants USING btree (id)"
"public","spree_zone_members","spree_zone_members_pkey",NULL,"CREATE UNIQUE INDEX spree_zone_members_pkey ON public.spree_zone_members USING btree (id)"
"public","spree_zones","spree_zones_pkey",NULL,"CREATE UNIQUE INDEX spree_zones_pkey ON public.spree_zones USING btree (id)"
"public","staff_picks","staff_picks_pkey",NULL,"CREATE UNIQUE INDEX staff_picks_pkey ON public.staff_picks USING btree (id)"
"public","spree_stock_items","stock_item_by_loc_and_var_id",NULL,"CREATE INDEX stock_item_by_loc_and_var_id ON public.spree_stock_items USING btree (stock_location_id, variant_id)"
"public","store_events","store_events_pkey",NULL,"CREATE UNIQUE INDEX store_events_pkey ON public.store_events USING btree (id)"
"public","tax_rates","tax_rates_pkey",NULL,"CREATE UNIQUE INDEX tax_rates_pkey ON public.tax_rates USING btree (id)"
"public","tax_service_logs","tax_service_logs_pkey",NULL,"CREATE UNIQUE INDEX tax_service_logs_pkey ON public.tax_service_logs USING btree (id)"
"public","schema_migrations","unique_schema_migrations",NULL,"CREATE UNIQUE INDEX unique_schema_migrations ON public.schema_migrations USING btree (version)"
"public","spree_shipping_method_categories","unique_spree_shipping_method_categories",NULL,"CREATE UNIQUE INDEX unique_spree_shipping_method_categories ON public.spree_shipping_method_categories USING btree (shipping_category_id, shipping_method_id)"
"public","visits","visits_pkey",NULL,"CREATE UNIQUE INDEX visits_pkey ON public.visits USING btree (id)"