Bloat
Table and index bloat in your database ordered by most wasteful
Table and index bloat in your database ordered by most wasteful
| Type | Schemaname | Object name | Bloat | Waste |
|---|---|---|---|---|
| table | public | oban_jobs | 1.1 | 336.0 KB |
| index | pg_catalog | pg_depend::pg_depend_depender_index | 1.3 | 24.0 KB |
| table | pg_catalog | pg_depend | 1.2 | 24.0 KB |
| index | public | asciicasts::asciicasts_env_index | 3.0 | 16.0 KB |
| table | public | asciicasts | 3.0 | 16.0 KB |
| index | pg_catalog | pg_ts_config_map::pg_ts_config_map_index | 2.0 | 16.0 KB |
| index | pg_catalog | pg_amproc::pg_amproc_fam_proc_index | 1.7 | 16.0 KB |
| index | pg_catalog | pg_ts_parser::pg_ts_parser_oid_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_attrdef::pg_attrdef_oid_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_auth_members::pg_auth_members_grantor_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_auth_members::pg_auth_members_member_role_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_auth_members::pg_auth_members_oid_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_auth_members::pg_auth_members_role_member_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_authid::pg_authid_oid_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_authid::pg_authid_rolname_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_cast::pg_cast_oid_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_cast::pg_cast_source_target_index | 2.0 | 8.0 KB |
| index | public | schema_migrations::schema_migrations_pkey | 2.0 | 8.0 KB |
| index | public | oban_peers::oban_peers_pkey | 2.0 | 8.0 KB |
| index | public | asciicasts::index_asciicasts_on_views_count | 2.0 | 8.0 KB |
| index | public | asciicasts::index_asciicasts_on_user_id | 2.0 | 8.0 KB |
| index | public | asciicasts::index_asciicasts_on_secret_token | 2.0 | 8.0 KB |
| index | public | asciicasts::index_asciicasts_on_featured | 2.0 | 8.0 KB |
| index | pg_catalog | pg_am::pg_am_oid_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_tablespace::pg_tablespace_spcname_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_trigger::pg_trigger_tgconstraint_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_trigger::pg_trigger_tgrelid_tgname_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_ts_config::pg_ts_config_cfgname_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_ts_config::pg_ts_config_oid_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_ts_dict::pg_ts_dict_dictname_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_ts_dict::pg_ts_dict_oid_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_range::pg_range_rngmultitypid_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_range::pg_range_rngtypid_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_ts_template::pg_ts_template_oid_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_ts_parser::pg_ts_parser_prsname_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_shdescription::pg_shdescription_o_c_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_tablespace::pg_tablespace_oid_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_trigger::pg_trigger_oid_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_am::pg_am_name_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_database::pg_database_datname_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_database::pg_database_oid_index | 2.0 | 8.0 KB |
| index | public | asciicasts::index_asciicasts_on_created_at | 2.0 | 8.0 KB |
| index | pg_catalog | pg_extension::pg_extension_name_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_extension::pg_extension_oid_index | 2.0 | 8.0 KB |
| index | public | asciicasts::asciicasts_visibility_index | 2.0 | 8.0 KB |
| index | public | asciicasts::asciicasts_stream_id_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_language::pg_language_name_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_language::pg_language_oid_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_namespace::pg_namespace_nspname_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_namespace::pg_namespace_oid_index | 2.0 | 8.0 KB |
| index | public | asciicasts::asciicasts_pkey | 2.0 | 8.0 KB |
| index | public | asciicasts::asciicasts_path_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_attrdef::pg_attrdef_adrelid_adnum_index | 2.0 | 8.0 KB |
| index | public | asciicasts::asciicasts_cli_id_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_ts_template::pg_ts_template_tmplname_index | 2.0 | 8.0 KB |
| index | pg_catalog | pg_amproc::pg_amproc_oid_index | 1.3 | 8.0 KB |
| table | pg_catalog | pg_index | 1.2 | 8.0 KB |
| index | pg_catalog | pg_amop::pg_amop_fam_strat_index | 1.2 | 8.0 KB |
| index | pg_catalog | pg_amop::pg_amop_opr_fam_index | 1.2 | 8.0 KB |
| table | pg_catalog | pg_class | 1.1 | 8.0 KB |
| table | pg_catalog | pg_description | 1.0 | 8.0 KB |
| index | public | asciicasts::asciicasts_snapshotless_index | 0.0 | 8.0 KB |
| table | public | schema_migrations | 1.0 | 0 B |
| index | pg_catalog | pg_amop::pg_amop_oid_index | 1.0 | 0 B |
| index | pg_catalog | pg_conversion::pg_conversion_default_index | 1.0 | 0 B |
| index | pg_catalog | pg_conversion::pg_conversion_name_nsp_index | 1.0 | 0 B |
| index | pg_catalog | pg_conversion::pg_conversion_oid_index | 1.0 | 0 B |
| index | pg_catalog | pg_depend::pg_depend_reference_index | 1.0 | 0 B |
| index | pg_catalog | pg_init_privs::pg_init_privs_o_c_o_index | 1.0 | 0 B |
| index | pg_catalog | pg_opfamily::pg_opfamily_am_name_nsp_index | 1.0 | 0 B |
| index | pg_catalog | pg_opfamily::pg_opfamily_oid_index | 1.0 | 0 B |
| table | pg_catalog | pg_am | 1.0 | 0 B |
| table | pg_catalog | pg_amop | 1.0 | 0 B |
| table | pg_catalog | pg_amproc | 1.0 | 0 B |
| table | pg_catalog | pg_attrdef | 1.0 | 0 B |
| table | pg_catalog | pg_attribute | 1.0 | 0 B |
| table | pg_catalog | pg_auth_members | 1.0 | 0 B |
| table | pg_catalog | pg_authid | 1.0 | 0 B |
| table | pg_catalog | pg_cast | 1.0 | 0 B |
| table | pg_catalog | pg_constraint | 1.0 | 0 B |
| table | pg_catalog | pg_conversion | 1.0 | 0 B |
| table | pg_catalog | pg_database | 1.0 | 0 B |
| table | pg_catalog | pg_extension | 1.0 | 0 B |
| table | pg_catalog | pg_init_privs | 1.0 | 0 B |
| table | pg_catalog | pg_language | 1.0 | 0 B |
| table | pg_catalog | pg_namespace | 1.0 | 0 B |
| table | pg_catalog | pg_opclass | 1.0 | 0 B |
| table | pg_catalog | pg_operator | 1.0 | 0 B |
| table | pg_catalog | pg_opfamily | 1.0 | 0 B |
| table | pg_catalog | pg_proc | 1.0 | 0 B |
| table | pg_catalog | pg_range | 1.0 | 0 B |
| table | pg_catalog | pg_rewrite | 1.0 | 0 B |
| table | pg_catalog | pg_shdescription | 1.0 | 0 B |
| table | pg_catalog | pg_tablespace | 1.0 | 0 B |
| table | pg_catalog | pg_trigger | 1.0 | 0 B |
| table | pg_catalog | pg_ts_config | 1.0 | 0 B |
| table | pg_catalog | pg_ts_config_map | 1.0 | 0 B |
| table | pg_catalog | pg_ts_dict | 1.0 | 0 B |
| table | pg_catalog | pg_ts_parser | 1.0 | 0 B |
| table | pg_catalog | pg_ts_template | 1.0 | 0 B |
| table | public | oban_peers | 1.0 | 0 B |
| index | pg_catalog | pg_aggregate::pg_aggregate_fnoid_index | 1.0 | 0 B |
| table | pg_catalog | pg_collation | 0.9 | 0 B |
| table | pg_catalog | pg_type | 0.9 | 0 B |
| index | pg_catalog | pg_description::pg_description_o_c_o_index | 0.8 | 0 B |
| index | pg_catalog | pg_constraint::pg_constraint_conrelid_contypid_conname_index | 0.7 | 0 B |
| index | pg_catalog | pg_opclass::pg_opclass_oid_index | 0.7 | 0 B |
| index | pg_catalog | pg_opclass::pg_opclass_am_name_nsp_index | 0.7 | 0 B |
| index | pg_catalog | pg_constraint::pg_constraint_oid_index | 0.7 | 0 B |
| index | pg_catalog | pg_constraint::pg_constraint_contypid_index | 0.7 | 0 B |
| index | pg_catalog | pg_constraint::pg_constraint_conparentid_index | 0.7 | 0 B |
| index | pg_catalog | pg_constraint::pg_constraint_conname_nsp_index | 0.7 | 0 B |
| table | pg_catalog | pg_aggregate | 0.7 | 0 B |
| index | pg_catalog | pg_class::pg_class_relname_nsp_index | 0.5 | 0 B |
| index | pg_catalog | pg_operator::pg_operator_oprname_l_r_n_index | 0.5 | 0 B |
| index | pg_catalog | pg_index::pg_index_indexrelid_index | 0.5 | 0 B |
| index | pg_catalog | pg_index::pg_index_indrelid_index | 0.5 | 0 B |
| index | pg_catalog | pg_collation::pg_collation_name_enc_nsp_index | 0.5 | 0 B |
| index | pg_catalog | pg_collation::pg_collation_oid_index | 0.5 | 0 B |
| index | pg_catalog | pg_proc::pg_proc_proname_args_nsp_index | 0.4 | 0 B |
| index | pg_catalog | pg_class::pg_class_tblspc_relfilenode_index | 0.4 | 0 B |
| index | pg_catalog | pg_class::pg_class_oid_index | 0.4 | 0 B |
| index | pg_catalog | pg_attribute::pg_attribute_relid_attnam_index | 0.4 | 0 B |
| index | pg_catalog | pg_type::pg_type_typname_nsp_index | 0.4 | 0 B |
| index | pg_catalog | pg_operator::pg_operator_oid_index | 0.4 | 0 B |
| index | pg_catalog | pg_type::pg_type_oid_index | 0.3 | 0 B |
| index | pg_catalog | pg_attribute::pg_attribute_relid_attnum_index | 0.3 | 0 B |
| index | pg_catalog | pg_rewrite::pg_rewrite_rel_rulename_index | 0.2 | 0 B |
| index | pg_catalog | pg_rewrite::pg_rewrite_oid_index | 0.2 | 0 B |
| index | public | oban_jobs::oban_jobs_state_queue_priority_scheduled_at_id_index | 0.2 | 0 B |
| index | pg_catalog | pg_proc::pg_proc_oid_index | 0.1 | 0 B |
| index | public | oban_jobs::oban_jobs_pkey | 0.1 | 0 B |
| index | public | oban_jobs::oban_jobs_meta_index | 0.1 | 0 B |
| index | public | oban_jobs::oban_jobs_args_index | 0.0 | 0 B |