PgHero

Space

Database Size: 121 MB

5 unused indices. Remove them for faster writes. 

rails generate migration remove_unused_indexes

And paste

remove_index :transactions, name: "idx_transaction_plan_billing_token"
remove_index :flyway_schema_history, name: "flyway_schema_history_s_idx"
remove_index :invoices, name: "idx_invoices_plan_billing_token"
remove_index :transaction_wallets, name: "idx_transaction_wallets_tunning_01"
remove_index :merchant_business_unit_plan_payer_billings, name: "idx_mbu_plan_payer_billing"
Relation Size
onboarding_merchant_events 73 MB
transactions 21.3 MB
transaction_events 8.71 MB
idx_transactions_tunning_01 1.13 MB
uq_transaction_token 960 KB
transactions_pkey 760 KB
invoices 448 KB
refund_events 216 KB
idx_transaction_plan_billing_token UNUSED 184 KB
transaction_fees 112 KB
refunds 104 KB
business_unit_partner_keys 96 KB
partner_pinbank_mcc_de_para 88 KB
subscription_plan_fees 88 KB
flyway_schema_history 72 KB
payout_events 72 KB
idx_partner_pinbank_mcc_de_para 64 KB
business_unit_payment_methods 48 KB
merchant_business_unit_plans 48 KB
merchants 48 KB
onboarding_documents 48 KB
onboarding_tokens 48 KB
order_items 48 KB
payouts 48 KB
wallets 48 KB
orders 40 KB
addresses 16 KB
addresses_pkey 16 KB
banking_accounts 16 KB
banking_accounts_banking_account_token_key 16 KB
banking_accounts_pkey 16 KB
busines_unit_bureaus_pkey 16 KB
business_unit_payer_cards 16 KB
business_unit_payer_events 16 KB
business_unit_payers 16 KB
countries_country_token_key 16 KB
countries_pkey 16 KB
country_currency_pkey 16 KB
currencies_currency_token_key 16 KB
currencies_pkey 16 KB
fitbank_bank_account_aliases_pkey 16 KB
flyway_schema_history_pk 16 KB
flyway_schema_history_s_idx UNUSED 16 KB
idx_invoices_plan_billing_token UNUSED 16 KB
idx_pbb_payout_beneficiary_id 16 KB
idx_transaction_wallets_tunning_01 UNUSED 16 KB
invoice_split_beneficiaries_pkey 16 KB
invoices_pkey 16 KB
merchant_business_unit_plan_payers 16 KB
merchant_business_unit_plan_payers_pkey 16 KB
merchant_business_unit_plans_pkey 16 KB
merchant_business_units 16 KB
merchants_unique_key 16 KB
onboarding_merchants 16 KB
onboarding_merchants_merchant_token_key 16 KB
onboarding_merchants_onboarding_token_key 16 KB
onboarding_tokens_onboarding_token_key 16 KB
order_items_pkey 16 KB
orders_pkey 16 KB
payment_methods 16 KB
payment_partner_methods 16 KB
payment_partners 16 KB
payout_beneficiaries 16 KB
payout_beneficiaries_pkey 16 KB
payout_beneficiary_bank_accounts_pkey 16 KB
payout_beneficiary_keys 16 KB
payout_events_pkey 16 KB
payouts_pkey 16 KB
pk_business_unit_id 16 KB
pk_business_unit_partner_keys 16 KB
pk_business_unit_payer_cards 16 KB
pk_business_unit_payer_events 16 KB
pk_business_unit_payers 16 KB
pk_merchants_id 16 KB
pk_onboarding_documents 16 KB
pk_onboarding_merchant_events 16 KB
pk_onboarding_merchants 16 KB
pk_onboarding_tokens 16 KB
pk_payment_method_id 16 KB
pk_payment_partner_id 16 KB
pk_payment_partner_method_id 16 KB
rate_conversion_pkey 16 KB
recurrence_payer_payment_methods 16 KB
recurrence_payer_payment_methods_pkey 16 KB
recurrencies 16 KB
recurrencies_pkey 16 KB
recurrency_events 16 KB
recurrency_events_pkey 16 KB
refund_events_pkey 16 KB
refund_receivers 16 KB
refund_receivers_pkey 16 KB
refund_types 16 KB
refund_types_pkey 16 KB
refunds_pkey 16 KB
security_payer_transactional_informations 16 KB
split_bank_accounts_pkey 16 KB
split_bank_international_accounts 16 KB
split_bank_international_accounts_pkey 16 KB
split_beneficiaries 16 KB
split_beneficiaries_merchant_token_business_unit_token_emai_key 16 KB
split_beneficiaries_pkey 16 KB
split_payment_keys 16 KB
split_payment_keys_pkey 16 KB
split_payment_methods 16 KB
split_payment_methods_payment_method_name_key 16 KB
split_payment_methods_pkey 16 KB
split_rule_events_pkey 16 KB
split_rules 16 KB
split_rules_merchant_token_business_unit_token_alias_key 16 KB
split_rules_pkey 16 KB
subscription_plan_fees_pkey 16 KB
subscription_plans_pkey 16 KB
transaction_fees_pkey 16 KB
transaction_split_beneficiaries_pkey 16 KB
transaction_wallets 16 KB
transaction_wallets_pkey 16 KB
transaction_wallets_wallet_token_key 16 KB
uniq_payer_card 16 KB
unique_wallet_balance_fields 16 KB
uq_business_unit_token 16 KB
uq_invoice_token 16 KB
uq_merchant_token 16 KB
uq_order_token 16 KB
uq_partner_token 16 KB
uq_payer_tax_number 16 KB
uq_payment_method_per_payer 16 KB
uq_payment_method_token 16 KB
wallet_balances_pkey 16 KB
wallets_handle_key 16 KB
wallets_pkey 16 KB
banking_account_events 8 KB
banking_account_events_pkey 8 KB
busines_unit_bureau_events_pkey 8 KB
busines_units_events_pkey 8 KB
business_unit_bureau_events 8 KB
business_unit_bureaus 8 KB
business_unit_client_bureau_events 8 KB
business_unit_client_bureau_events_pkey 8 KB
business_unit_client_bureaus_pkey 8 KB
business_unit_partner_key_events 8 KB
business_unit_payer_card_events 8 KB
business_unit_payer_cards_events_pkey 8 KB
business_units_events 8 KB
countries 8 KB
country_currency 8 KB
currencies 8 KB
fitbank_bank_account_aliases 8 KB
idx_mbu_plan_payer_billing UNUSED 8 KB
idx_pbwiretransfer_payout_beneficiary_id 8 KB
idx_wallet_balance_statements_idempotent_composite 8 KB
invoice_split_beneficiaries 8 KB
merchant_business_unit_plan_events_pkey 8 KB
merchant_business_unit_plan_payer_billing_events_pkey 8 KB
merchant_business_unit_plan_payer_billings 8 KB
merchant_business_unit_plan_payer_billings_pkey 8 KB
merchant_business_unit_plan_payer_events_pkey 8 KB
merchant_business_unit_plan_split_events_pkey 8 KB
merchant_business_unit_plan_splits 8 KB
merchant_business_unit_plan_splits_pkey 8 KB
merchant_payment_partner_prefers 8 KB
merchant_payment_partner_prefers_pkey 8 KB
merchant_payment_setup 8 KB
merchant_payment_setup_pkey 8 KB
onboarding_merchant_resends 8 KB
onboarding_merchant_resends_merchant_token_key 8 KB
payer_bureau_events 8 KB
payer_bureau_events_pkey 8 KB
payer_bureaus 8 KB
payer_bureaus_pkey 8 KB
payout_batch_file_registry_pkey 8 KB
payout_beneficiary_bank_accounts 8 KB
payout_beneficiary_events 8 KB
payout_beneficiary_wire_transfer_accounts 8 KB
payout_beneficiary_wire_transfer_accounts_pkey 8 KB
pk_business_unit_partner_key_event 8 KB
pk_dispute_documents 8 KB
pk_onboarding_merchant_resends 8 KB
rate_conversion 8 KB
recurrence_payer_payment_methods_events 8 KB
recurrence_payer_payment_methods_events_pkey 8 KB
refund_check 8 KB
refund_check_events 8 KB
refund_fees 8 KB
refund_fees_pkey 8 KB
settlement_scheduler_controllers 8 KB
settlement_scheduler_controllers_pkey 8 KB
settlement_transactions_pkey 8 KB
settlements 8 KB
settlements_pkey 8 KB
split_bank_accounts 8 KB
split_rule_events 8 KB
subscription_plan_channels_pkey 8 KB
subscription_plans 8 KB
transaction_dispute_documents 8 KB
transaction_disputes 8 KB
transaction_disputes_events 8 KB
transaction_disputes_events_pkey 8 KB
transaction_disputes_pkey 8 KB
transaction_metrics 8 KB
transaction_metrics_pkey 8 KB
transaction_split_beneficiaries 8 KB
transaction_tags_pkey 8 KB
transaction_wallets_keys_pkey 8 KB
wallet_balance_histories_pkey 8 KB
wallet_balance_statements 8 KB
wallet_balance_statements_pkey 8 KB
wallet_balances 8 KB
wallet_events_pkey 8 KB
business_unit_client_bureaus 0 Bytes
merchant_business_unit_plan_events 0 Bytes
merchant_business_unit_plan_payer_billing_events 0 Bytes
merchant_business_unit_plan_payer_events 0 Bytes
merchant_business_unit_plan_split_events 0 Bytes
payout_batch_file_registry 0 Bytes
settlement_transactions 0 Bytes
subscription_plan_channels 0 Bytes
transaction_tags 0 Bytes
transaction_wallets_keys 0 Bytes
wallet_balance_histories 0 Bytes
wallet_events 0 Bytes