Indexes list

Index name Schema name Table Owner relam relfilenode Tablespace name Pages # Tuples # OID Toast Table OID Toast Index Has index? Is shared? Kind natts Checks Triggers Unique Keys Foreign Keys Refs Has OID? Has Primary Key? Has Rules? Has subclass? Frozen XID ACL Options Size
actor_pkey public postgres 403 18217 2 200 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
address_pkey public postgres 403 18219 4 603 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 32 kB
category_pkey public postgres 403 18221 1 0 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
city_pkey public postgres 403 18223 4 600 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 32 kB
country_pkey public postgres 403 18225 2 109 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
customer_pkey public postgres 403 18227 4 599 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 32 kB
film_actor_pkey public postgres 403 18229 14 5462 0 0 Off Off 2 0 0 0 0 0 Off Off Off Off 0 112 kB
film_category_pkey public postgres 403 18231 5 1000 0 0 Off Off 2 0 0 0 0 0 Off Off Off Off 0 40 kB
film_fulltext_idx public postgres 783 18247 10 1000 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 80 kB
film_pkey public postgres 403 18233 5 1000 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 40 kB
idx_actor_last_name public postgres 403 18248 4 200 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 32 kB
idx_fk_address_id public postgres 403 18249 4 599 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 32 kB
idx_fk_city_id public postgres 403 18250 5 603 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 40 kB
idx_fk_country_id public postgres 403 18251 5 600 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 40 kB
idx_fk_customer_id public postgres 403 18252 1 0 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 8192 bytes
idx_fk_film_id public postgres 403 18253 18 5462 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 144 kB
idx_fk_inventory_id public postgres 403 18254 46 16044 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 368 kB
idx_fk_language_id public postgres 403 18255 6 1000 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 48 kB
idx_fk_original_language_id public postgres 403 18256 5 1000 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 40 kB
idx_fk_payment_p2007_01_customer_id public postgres 403 18257 6 1157 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 48 kB
idx_fk_payment_p2007_01_staff_id public postgres 403 18258 7 1157 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 56 kB
idx_fk_payment_p2007_02_customer_id public postgres 403 18259 10 2312 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 80 kB
idx_fk_payment_p2007_02_staff_id public postgres 403 18260 10 2312 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 80 kB
idx_fk_payment_p2007_03_customer_id public postgres 403 18261 20 5644 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 160 kB
idx_fk_payment_p2007_03_staff_id public postgres 403 18262 18 5644 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 144 kB
idx_fk_payment_p2007_04_customer_id public postgres 403 18263 23 6754 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 184 kB
idx_fk_payment_p2007_04_staff_id public postgres 403 18264 23 6754 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 184 kB
idx_fk_payment_p2007_05_customer_id public postgres 403 18265 2 182 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
idx_fk_payment_p2007_05_staff_id public postgres 403 18266 2 182 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
idx_fk_payment_p2007_06_customer_id public postgres 403 18267 1 0 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 8192 bytes
idx_fk_payment_p2007_06_staff_id public postgres 403 18268 1 0 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 8192 bytes
idx_fk_staff_id public postgres 403 18269 1 0 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 8192 bytes
idx_fk_store_id public postgres 403 18270 5 599 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 40 kB
idx_last_name public postgres 403 18271 5 599 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 40 kB
idx_store_id_film_id public postgres 403 18272 17 4581 0 0 Off Off 2 0 0 0 0 0 Off Off Off Off 0 136 kB
idx_title public postgres 403 18273 6 1000 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 48 kB
idx_unq_manager_staff_id public postgres 403 18274 1 0 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
idx_unq_rental_rental_date_inventory_id_customer_id public postgres 403 18275 77 16044 0 0 Off Off 3 0 0 0 0 0 Off Off Off Off 0 616 kB
inventory_pkey public postgres 403 18235 12 4581 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 96 kB
language_pkey public postgres 403 18237 1 0 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
payment_pkey public postgres 403 18239 1 0 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 8192 bytes
pg_aggregate_fnoid_index pg_catalog guillaume 403 2650 2 117 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_am_name_index pg_catalog guillaume 403 2651 2 4 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_am_oid_index pg_catalog guillaume 403 2652 2 4 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_amop_fam_strat_index pg_catalog guillaume 403 2653 4 347 0 0 Off Off 4 0 0 0 0 0 Off Off Off Off 0 32 kB
pg_amop_oid_index pg_catalog guillaume 403 2756 2 347 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_amop_opr_fam_index pg_catalog guillaume 403 2654 2 347 0 0 Off Off 2 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_amproc_fam_proc_index pg_catalog guillaume 403 2655 2 243 0 0 Off Off 4 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_amproc_oid_index pg_catalog guillaume 403 2757 2 243 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_attrdef_adrelid_adnum_index pg_catalog guillaume 403 2656 1 0 0 0 Off Off 2 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_attrdef_oid_index pg_catalog guillaume 403 2657 1 0 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_attribute_relid_attnam_index pg_catalog guillaume 403 2658 29 2331 0 0 Off Off 2 0 0 0 0 0 Off Off Off Off 0 232 kB
pg_attribute_relid_attnum_index pg_catalog guillaume 403 2659 9 2331 0 0 Off Off 2 0 0 0 0 0 Off Off Off Off 0 72 kB
pg_auth_members_member_role_index pg_catalog guillaume 403 2695 pg_global 1 0 0 0 Off On 2 0 0 0 0 0 Off Off Off Off 0 8192 bytes
pg_auth_members_role_member_index pg_catalog guillaume 403 2694 pg_global 1 0 0 0 Off On 2 0 0 0 0 0 Off Off Off Off 0 8192 bytes
pg_authid_oid_index pg_catalog guillaume 403 2677 pg_global 2 1 0 0 Off On 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_authid_rolname_index pg_catalog guillaume 403 2676 pg_global 2 1 0 0 Off On 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_autovacuum_vacrelid_index pg_catalog guillaume 403 1250 1 0 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 8192 bytes
pg_cast_oid_index pg_catalog guillaume 403 2660 2 191 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_cast_source_target_index pg_catalog guillaume 403 2661 2 191 0 0 Off Off 2 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_class_oid_index pg_catalog guillaume 403 2662 2 315 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_class_relname_nsp_index pg_catalog guillaume 403 2663 8 315 0 0 Off Off 2 0 0 0 0 0 Off Off Off Off 0 64 kB
pg_constraint_conname_nsp_index pg_catalog guillaume 403 2664 2 63 0 0 Off Off 2 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_constraint_conrelid_index pg_catalog guillaume 403 2665 2 63 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_constraint_contypid_index pg_catalog guillaume 403 2666 2 63 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_constraint_oid_index pg_catalog guillaume 403 2667 2 63 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_conversion_default_index pg_catalog guillaume 403 2668 2 130 0 0 Off Off 4 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_conversion_name_nsp_index pg_catalog guillaume 403 2669 5 130 0 0 Off Off 2 0 0 0 0 0 Off Off Off Off 0 40 kB
pg_conversion_oid_index pg_catalog guillaume 403 2670 2 130 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_database_datname_index pg_catalog guillaume 403 2671 pg_global 2 2 0 0 Off On 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_database_oid_index pg_catalog guillaume 403 2672 pg_global 2 2 0 0 Off On 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_depend_depender_index pg_catalog guillaume 403 2673 31 6030 0 0 Off Off 3 0 0 0 0 0 Off Off Off Off 0 248 kB
pg_depend_reference_index pg_catalog guillaume 403 2674 32 6030 0 0 Off Off 3 0 0 0 0 0 Off Off Off Off 0 256 kB
pg_description_o_c_o_index pg_catalog guillaume 403 2675 12 1988 0 0 Off Off 3 0 0 0 0 0 Off Off Off Off 0 96 kB
pg_enum_oid_index pg_catalog guillaume 403 3502 1 0 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_enum_typid_label_index pg_catalog guillaume 403 3503 1 0 0 0 Off Off 2 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_index_indexrelid_index pg_catalog guillaume 403 2679 2 90 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_index_indrelid_index pg_catalog guillaume 403 2678 2 90 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_inherits_relid_seqno_index pg_catalog guillaume 403 2680 1 0 0 0 Off Off 2 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_language_name_index pg_catalog guillaume 403 2681 2 3 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_language_oid_index pg_catalog guillaume 403 2682 2 3 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_largeobject_loid_pn_index pg_catalog guillaume 403 2683 1 0 0 0 Off Off 2 0 0 0 0 0 Off Off Off Off 0 8192 bytes
pg_namespace_nspname_index pg_catalog guillaume 403 2684 2 6 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_namespace_oid_index pg_catalog guillaume 403 2685 2 6 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_opclass_am_name_nsp_index pg_catalog guillaume 403 2686 4 112 0 0 Off Off 3 0 0 0 0 0 Off Off Off Off 0 32 kB
pg_opclass_oid_index pg_catalog guillaume 403 2687 2 112 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_operator_oid_index pg_catalog guillaume 403 2688 4 702 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 32 kB
pg_operator_oprname_l_r_n_index pg_catalog guillaume 403 2689 11 702 0 0 Off Off 4 0 0 0 0 0 Off Off Off Off 0 88 kB
pg_opfamily_am_name_nsp_index pg_catalog guillaume 403 2754 2 69 0 0 Off Off 3 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_opfamily_oid_index pg_catalog guillaume 403 2755 2 69 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_pltemplate_name_index pg_catalog guillaume 403 1137 pg_global 2 6 0 0 Off On 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_proc_oid_index pg_catalog guillaume 403 2690 7 2143 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 56 kB
pg_proc_proname_args_nsp_index pg_catalog guillaume 403 2691 40 2143 0 0 Off Off 3 0 0 0 0 0 Off Off Off Off 0 328 kB
pg_rewrite_oid_index pg_catalog guillaume 403 2692 2 75 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_rewrite_rel_rulename_index pg_catalog guillaume 403 2693 2 75 0 0 Off Off 2 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_shdepend_depender_index pg_catalog guillaume 403 1232 pg_global 2 199 0 0 Off On 3 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_shdepend_reference_index pg_catalog guillaume 403 1233 pg_global 2 199 0 0 Off On 2 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_shdescription_o_c_index pg_catalog guillaume 403 2397 pg_global 2 1 0 0 Off On 2 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_statistic_relid_att_index pg_catalog guillaume 403 2696 5 434 0 0 Off Off 2 0 0 0 0 0 Off Off Off Off 0 40 kB
pg_tablespace_oid_index pg_catalog guillaume 403 2697 pg_global 2 2 0 0 Off On 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_tablespace_spcname_index pg_catalog guillaume 403 2698 pg_global 2 2 0 0 Off On 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_trigger_oid_index pg_catalog guillaume 403 2702 2 178 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_trigger_tgconstrname_index pg_catalog guillaume 403 2699 5 178 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 40 kB
pg_trigger_tgrelid_tgname_index pg_catalog guillaume 403 2701 6 178 0 0 Off Off 2 0 0 0 0 0 Off Off Off Off 0 48 kB
pg_ts_config_cfgname_index pg_catalog guillaume 403 3608 2 16 0 0 Off Off 2 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_ts_config_map_index pg_catalog guillaume 403 3609 2 304 0 0 Off Off 3 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_ts_config_oid_index pg_catalog guillaume 403 3712 2 16 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_ts_dict_dictname_index pg_catalog guillaume 403 3604 2 16 0 0 Off Off 2 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_ts_dict_oid_index pg_catalog guillaume 403 3605 2 16 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_ts_parser_oid_index pg_catalog guillaume 403 3607 2 1 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_ts_parser_prsname_index pg_catalog guillaume 403 3606 2 1 0 0 Off Off 2 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_ts_template_oid_index pg_catalog guillaume 403 3767 2 5 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_ts_template_tmplname_index pg_catalog guillaume 403 3766 2 5 0 0 Off Off 2 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_type_oid_index pg_catalog guillaume 403 2703 2 343 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
pg_type_typname_nsp_index pg_catalog guillaume 403 2704 7 343 0 0 Off Off 2 0 0 0 0 0 Off Off Off Off 0 56 kB
rental_pkey public postgres 403 18241 37 16044 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 296 kB
staff_pkey public postgres 403 18243 1 0 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB
store_pkey public postgres 403 18245 1 0 0 0 Off Off 1 0 0 0 0 0 Off Off Off Off 0 16 kB

SELECT relname, nspname AS schema, rolname AS owner, relam, relfilenode, (select spcname from pg_tablespace where oid=reltablespace) as tablespace, relpages, reltuples, reltoastrelid, reltoastidxid, relhasindex, relisshared, reltype, relnatts, relchecks, reltriggers, relukeys, relfkeys, relrefs, relhasoids, relhaspkey, relhasrules, relhassubclass, relfrozenxid, relacl, reloptions, pg_size_pretty(pg_relation_size(pg_class.oid)) AS size FROM pg_class, pg_roles, pg_namespace WHERE relkind = 'i' AND relowner = pg_roles.oid AND relnamespace = pg_namespace.oid AND pg_table_is_visible(pg_class.oid) ORDER BY relname