Statistical indexes list

Schema name Table name Index name idx_scan idx_tup_read idx_tup_fetch
pg_catalog pg_aggregate pg_aggregate_fnoid_index 100 100 100
pg_catalog pg_am pg_am_name_index 0 0 0
pg_catalog pg_am pg_am_oid_index 0 0 0
pg_catalog pg_amop pg_amop_oid_index 0 0 0
pg_catalog pg_amop pg_amop_opr_fam_index 840 1044 1044
pg_catalog pg_amop pg_amop_fam_strat_index 4306 18866 18866
pg_catalog pg_amproc pg_amproc_oid_index 0 0 0
pg_catalog pg_amproc pg_amproc_fam_proc_index 4048 4228 4228
pg_catalog pg_attrdef pg_attrdef_oid_index 0 0 0
pg_catalog pg_attrdef pg_attrdef_adrelid_adnum_index 665 1264 1264
pg_catalog pg_attribute pg_attribute_relid_attnum_index 21348 70440 70359
pg_catalog pg_attribute pg_attribute_relid_attnam_index 0 0 0
pg_catalog pg_auth_members pg_auth_members_member_role_index 66 0 0
pg_catalog pg_auth_members pg_auth_members_role_member_index 0 0 0
pg_catalog pg_authid pg_authid_oid_index 1443 1443 1443
pg_catalog pg_authid pg_authid_rolname_index 749 748 748
pg_catalog pg_autovacuum pg_autovacuum_vacrelid_index 290768 0 0
pg_catalog pg_cast pg_cast_source_target_index 5621 1073 1073
pg_catalog pg_cast pg_cast_oid_index 0 0 0
pg_catalog pg_class pg_class_relname_nsp_index 8057 4514 4513
pg_catalog pg_class pg_class_oid_index 26177 26141 26140
pg_catalog pg_constraint pg_constraint_conname_nsp_index 0 0 0
pg_catalog pg_constraint pg_constraint_conrelid_index 185 740 740
pg_catalog pg_constraint pg_constraint_contypid_index 0 0 0
pg_catalog pg_constraint pg_constraint_oid_index 1123 1123 1123
pg_catalog pg_conversion pg_conversion_oid_index 0 0 0
pg_catalog pg_conversion pg_conversion_default_index 0 0 0
pg_catalog pg_conversion pg_conversion_name_nsp_index 0 0 0
pg_catalog pg_database pg_database_datname_index 297 297 297
pg_catalog pg_database pg_database_oid_index 21380 21380 21380
pg_catalog pg_depend pg_depend_depender_index 0 0 0
pg_catalog pg_depend pg_depend_reference_index 0 0 0
pg_catalog pg_description pg_description_o_c_o_index 1 0 0
pg_catalog pg_enum pg_enum_oid_index 0 0 0
pg_catalog pg_enum pg_enum_typid_label_index 0 0 0
pg_catalog pg_index pg_index_indrelid_index 387 795 795
pg_catalog pg_index pg_index_indexrelid_index 6614 6614 6614
pg_catalog pg_inherits pg_inherits_relid_seqno_index 8 0 0
pg_catalog pg_language pg_language_name_index 0 0 0
pg_catalog pg_language pg_language_oid_index 3 3 3
pg_catalog pg_largeobject pg_largeobject_loid_pn_index 0 0 0
pg_catalog pg_namespace pg_namespace_oid_index 22944 22944 22944
pg_catalog pg_namespace pg_namespace_nspname_index 180 126 126
pg_catalog pg_opclass pg_opclass_am_name_nsp_index 261 10440 10440
pg_catalog pg_opclass pg_opclass_oid_index 3913 3913 3913
pg_catalog pg_operator pg_operator_oid_index 1027 1027 1027
pg_catalog pg_operator pg_operator_oprname_l_r_n_index 784 3413 3413
pg_catalog pg_opfamily pg_opfamily_am_name_nsp_index 0 0 0
pg_catalog pg_opfamily pg_opfamily_oid_index 0 0 0
pg_catalog pg_pltemplate pg_pltemplate_name_index 2 2 2
pg_catalog pg_proc pg_proc_proname_args_nsp_index 704 1809 1809
pg_catalog pg_proc pg_proc_oid_index 2985 2985 2985
pg_catalog pg_rewrite pg_rewrite_rel_rulename_index 928 1147 1147
pg_catalog pg_rewrite pg_rewrite_oid_index 0 0 0
pg_catalog pg_shdepend pg_shdepend_reference_index 9 9 9
pg_catalog pg_shdepend pg_shdepend_depender_index 0 0 0
pg_catalog pg_shdescription pg_shdescription_o_c_index 0 0 0
pg_catalog pg_statistic pg_statistic_relid_att_index 2909 2335 2335
pg_catalog pg_tablespace pg_tablespace_oid_index 0 0 0
pg_catalog pg_tablespace pg_tablespace_spcname_index 0 0 0
pg_catalog pg_trigger pg_trigger_oid_index 2 2 2
pg_catalog pg_trigger pg_trigger_tgrelid_tgname_index 10984 15777 15777
pg_catalog pg_trigger pg_trigger_tgconstrname_index 0 0 0
pg_catalog pg_ts_config pg_ts_config_oid_index 0 0 0
pg_catalog pg_ts_config pg_ts_config_cfgname_index 0 0 0
pg_catalog pg_ts_config_map pg_ts_config_map_index 0 0 0
pg_catalog pg_ts_dict pg_ts_dict_dictname_index 0 0 0
pg_catalog pg_ts_dict pg_ts_dict_oid_index 0 0 0
pg_catalog pg_ts_parser pg_ts_parser_oid_index 0 0 0
pg_catalog pg_ts_parser pg_ts_parser_prsname_index 0 0 0
pg_catalog pg_ts_template pg_ts_template_oid_index 0 0 0
pg_catalog pg_ts_template pg_ts_template_tmplname_index 0 0 0
pg_catalog pg_type pg_type_typname_nsp_index 363 113 113
pg_catalog pg_type pg_type_oid_index 1762 1735 1735
pg_toast pg_toast_11429 pg_toast_11429_index 0 0 0
pg_toast pg_toast_11434 pg_toast_11434_index 0 0 0
pg_toast pg_toast_11439 pg_toast_11439_index 0 0 0
pg_toast pg_toast_11444 pg_toast_11444_index 0 0 0
pg_toast pg_toast_11449 pg_toast_11449_index 0 0 0
pg_toast pg_toast_11454 pg_toast_11454_index 0 0 0
pg_toast pg_toast_11459 pg_toast_11459_index 0 0 0
pg_toast pg_toast_1255 pg_toast_1255_index 0 0 0
pg_toast pg_toast_1260 pg_toast_1260_index 0 0 0
pg_toast pg_toast_1262 pg_toast_1262_index 0 0 0
pg_toast pg_toast_18049 pg_toast_18049_index 0 0 0
pg_toast pg_toast_18183 pg_toast_18183_index 0 0 0
pg_toast pg_toast_2396 pg_toast_2396_index 0 0 0
pg_toast pg_toast_2604 pg_toast_2604_index 0 0 0
pg_toast pg_toast_2606 pg_toast_2606_index 0 0 0
pg_toast pg_toast_2609 pg_toast_2609_index 0 0 0
pg_toast pg_toast_2618 pg_toast_2618_index 385 902 902
pg_toast pg_toast_2619 pg_toast_2619_index 0 0 0
public actor idx_actor_last_name 0 0 0
public actor actor_pkey 0 0 0
public address idx_fk_city_id 0 0 0
public address address_pkey 0 0 0
public category category_pkey 0 0 0
public city city_pkey 0 0 0
public city idx_fk_country_id 0 0 0
public country country_pkey 0 0 0
public customer customer_pkey 0 0 0
public customer idx_last_name 0 0 0
public customer idx_fk_store_id 0 0 0
public customer idx_fk_address_id 0 0 0
public film film_pkey 0 0 0
public film idx_fk_original_language_id 0 0 0
public film idx_fk_language_id 0 0 0
public film film_fulltext_idx 0 0 0
public film idx_title 0 0 0
public film_actor film_actor_pkey 2 38 0
public film_actor idx_fk_film_id 0 0 0
public film_category film_category_pkey 0 0 0
public inventory inventory_pkey 0 0 0
public inventory idx_store_id_film_id 0 0 0
public language language_pkey 0 0 0
public payment idx_fk_staff_id 0 0 0
public payment idx_fk_customer_id 0 0 0
public payment payment_pkey 0 0 0
public payment_p2007_01 idx_fk_payment_p2007_01_staff_id 0 0 0
public payment_p2007_01 idx_fk_payment_p2007_01_customer_id 0 0 0
public payment_p2007_02 idx_fk_payment_p2007_02_customer_id 0 0 0
public payment_p2007_02 idx_fk_payment_p2007_02_staff_id 0 0 0
public payment_p2007_03 idx_fk_payment_p2007_03_customer_id 0 0 0
public payment_p2007_03 idx_fk_payment_p2007_03_staff_id 0 0 0
public payment_p2007_04 idx_fk_payment_p2007_04_customer_id 0 0 0
public payment_p2007_04 idx_fk_payment_p2007_04_staff_id 0 0 0
public payment_p2007_05 idx_fk_payment_p2007_05_customer_id 0 0 0
public payment_p2007_05 idx_fk_payment_p2007_05_staff_id 0 0 0
public payment_p2007_06 idx_fk_payment_p2007_06_staff_id 0 0 0
public payment_p2007_06 idx_fk_payment_p2007_06_customer_id 0 0 0
public rental idx_unq_rental_rental_date_inventory_id_customer_id 0 0 0
public rental idx_fk_inventory_id 0 0 0
public rental rental_pkey 0 0 0
public staff staff_pkey 0 0 0
public store idx_unq_manager_staff_id 0 0 0
public store store_pkey 0 0 0

SELECT schemaname, relname, indexrelname, idx_scan, idx_tup_read, idx_tup_fetch FROM pg_stat_all_indexes ORDER BY schemaname, relname