Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Get index stats (JiraNode1 Jira 8.13.3, JSD 4.13.)
- schemaname | tablename | indexname | index_size
- ------------+--------------------------------+--------------------------------+------------
- public | AO_54307E_SLAAUDITLOG | index_ao_54307e_sla1843930481 | 951369728
- public | AO_733371_EVENT_PARAMETER | index_ao_733371_eve1423945899 | 625491968
- public | cwd_user_attributes | idx_user_attr_dir_name_lval | 212705280
- public | AO_544E33_AUDIT_LOG_ENTRY | index_ao_544e33_aud1602451017 | 188375040
- public | clusteredjob | clusteredjob_nextrun_idx | 170041344
- public | AO_319474_QUEUE | index_ao_319474_queue_topic | 121118720
- public | AO_319474_MESSAGE | index_ao_319474_mes1697012995 | 74711040
- public | AO_8542F1_IFJ_OBJ | index_ao_8542f1_ifj1846712946 | 60964864
- public | AO_544E33_AUDIT_LOG_ENTRY | index_ao_544e33_aud845075831 | 58294272
- public | AO_544E33_AUDIT_LOG_ENTRY | index_ao_544e33_aud449906846 | 50044928
- public | AO_544E33_AUDIT_LOG_ENTRY | index_ao_544e33_aud365482369 | 49152000
- public | AO_319474_MESSAGE | index_ao_319474_mes525710975 | 44974080
- public | AO_319474_MESSAGE | index_ao_319474_mes1815442463 | 43982848
- public | AO_544E33_AUDIT_LOG_ENTRY | index_ao_544e33_aud1940082561 | 41091072
- public | AO_544E33_AUDIT_LOG_ENTRY | index_ao_544e33_aud740477310 | 40116224
- public | AO_544E33_AUDIT_LOG_ENTRY | index_ao_544e33_aud365906193 | 37470208
- public | issue_version | iv_parent_id | 32382976
- public | AO_733371_EVENT | index_ao_733371_event_user_key | 30547968
- public | jiraissue | issue_resolutiondate | 26861568
- public | jiraissue | issue_watches | 24846336
- public | jiraissue | issue_duedate | 24813568
- public | AO_733371_EVENT | index_ao_733371_eve902883849 | 21389312
- public | AO_733371_EVENT | index_ao_733371_event_action | 21233664
- public | AO_C77861_AUDIT_ENTITY | index_ao_c77861_aud237541374 | 13467648
- public | AO_4E8AE6_NOTIF_BATCH_QUEUE | index_ao_4e8ae6_not1193702477 | 12574720
- public | AO_C77861_AUDIT_ENTITY | index_ao_c77861_aud265617021 | 11632640
- public | AO_C77861_AUDIT_ENTITY | index_ao_c77861_aud470300084 | 11190272
- public | AO_4E8AE6_NOTIF_BATCH_QUEUE | index_ao_4e8ae6_not850480572 | 5087232
- public | AO_D530BB_CANNEDRESPONSEUSAGE | index_ao_d530bb_can955130060 | 1646592
- public | cwd_user | idx_last_name | 1212416
- public | cwd_user | idx_first_name | 1171456
- public | label | label_fieldissuelabel | 974848
- public | AO_AEFED0_USER_INDEX | index_ao_aefed0_use916119569 | 688128
- public | label | label_fieldissue | 638976
- public | label | label_label | 565248
- public | AO_D4B4E5_SMART_COMMENT | index_ao_d4b4e5_sma477627042 | 442368
- public | AO_013613_WA_VALUE | index_ao_013613_wa_194126942 | 352256
- public | AO_5E638F_VAULT_FILE | index_ao_5e638f_vau29836584 | 311296
- public | fieldscreenlayoutitem | fieldscreen_field | 294912
- public | AO_8542F1_IFJ_PRG_OT_RES | index_ao_8542f1_ifj561489672 | 180224
- public | searchrequest | searchrequest_filternamelower | 131072
- public | AO_8542F1_IFJ_OBJ_TYPE_ATTR | index_ao_8542f1_ifj337003186 | 98304
- public | configurationcontext | confcontext | 73728
- public | avatar | avatar_filename_index | 65536
- public | fieldconfiguration | fc_fieldid | 40960
- public | AO_8542F1_IFJ_ROLE_ACTOR | index_ao_8542f1_ifj2045257638 | 40960
- public | AO_D530BB_CRAUDITACTIONDATA | index_ao_d530bb_cra1221426719 | 40960
- public | AO_D530BB_CRAUDITACTIONDATA | index_ao_d530bb_cra1494025551 | 40960
- public | AO_8542F1_IFJ_IMPORT_SRC_OT | index_ao_8542f1_ifj1005648332 | 16384
- public | AO_C3C6E8_ACCOUNT_V1 | index_ao_c3c6e8_acc888259217 | 16384
- public | AO_9B2E3B_PROJECT_USER_CONTEXT | index_ao_9b2e3b_pro738954449 | 16384
- public | AO_4B00E6_SR_USER_PROP | index_ao_4b00e6_sr_1334294815 | 16384
- public | reindex_component | idx_reindex_component_req_id | 16384
- public | AO_8542F1_IFJ_FEATURE | index_ao_8542f1_ifj478929883 | 16384
- public | AO_8542F1_IFJ_ATM_RULE_CO_AC | index_ao_8542f1_ifj1094570871 | 16384
- public | AO_8542F1_IFJ_ATM_RULE_CO | index_ao_8542f1_ifj1081536420 | 16384
- public | AO_8542F1_IFJ_ATM_RULE_CO | index_ao_8542f1_ifj1188172174 | 16384
- public | AO_8542F1_IFJ_ATM_RULE_AC | index_ao_8542f1_ifj1986867694 | 16384
- public | AO_8542F1_IFJ_ATM_RULE_AC | index_ao_8542f1_ifj999950596 | 16384
- public | AO_60DB71_WORKINGDAYS | index_ao_60db71_wor1205491794 | 16384
- public | AO_60DB71_TRACKINGSTATISTIC | index_ao_60db71_tra1711190333 | 16384
- public | AO_60DB71_SUBQUERY | index_ao_60db71_sub730851836 | 16384
- public | AO_60DB71_STATSFIELD | index_ao_60db71_sta1907922871 | 16384
- public | project_key | idx_all_project_ids | 16384
- public | AO_60DB71_ESTIMATESTATISTIC | index_ao_60db71_est1680565966 | 16384
- public | AO_60DB71_CARDLAYOUT | index_ao_60db71_car149237770 | 16384
- public | AO_60DB71_BOARDADMINS | index_ao_60db71_boa2110227660 | 16384
- public | AO_60DB71_AUDITENTRY | index_ao_60db71_aud137736645 | 16384
- public | AO_60DB71_AUDITENTRY | index_ao_60db71_aud1756477597 | 16384
- public | permissionschemeattribute | prmssn_scheme_attr_idx | 16384
- public | permissionschemeattribute | prmssn_scheme_attr_key_idx | 16384
- public | oauthconsumertoken | oauth_consumer_token_index | 16384
- public | AO_563AEE_ACTIVITY_ENTITY | index_ao_563aee_act1642652291 | 16384
- public | AO_563AEE_ACTIVITY_ENTITY | index_ao_563aee_act1978295567 | 16384
- public | AO_563AEE_ACTIVITY_ENTITY | index_ao_563aee_act972488439 | 16384
- public | AO_550953_SHORTCUT | index_ao_550953_sho1778115994 | 16384
- public | AO_54307E_VIEWPORT | index_ao_54307e_vie1002606617 | 16384
- public | AO_54307E_REPORT | index_ao_54307e_rep1824414723 | 16384
- public | AO_54307E_QUEUE | index_ao_54307e_que1043532634 | 16384
- public | AO_AEFED0_TEAM_MEMBER | index_ao_aefed0_tea28350697 | 16384
- public | AO_AEFED0_TEAM_TO_MEMBER | index_ao_aefed0_tea1458208454 | 16384
- public | AO_AEFED0_TEAM_TO_MEMBER | index_ao_aefed0_tea101585109 | 16384
- public | AO_AEFED0_TEAM_MEMBER_V2 | index_ao_aefed0_tea395955497 | 16384
- public | AO_AEFED0_TEAM_MEMBER_V2 | index_ao_aefed0_tea1751936206 | 16384
- public | AO_AEFED0_TEAM_LINK | index_ao_aefed0_tea1942841893 | 16384
- public | AO_AEFED0_TEAM_V2 | index_ao_aefed0_tea53980605 | 16384
- public | AO_AEFED0_MEMBERSHIP | index_ao_aefed0_mem1925201761 | 16384
- public | AO_544E33_CONTEXT | index_ao_544e33_con389053716 | 16384
- public | AO_013613_PERMISSION_GROUP | index_ao_013613_per594040534 | 16384
- public | AO_544E33_CONTEXT | index_ao_544e33_con881385042 | 16384
- public | AO_013613_FAVORITES | index_ao_013613_favorites_type | 16384
- public | AO_013613_FAVORITES | index_ao_013613_favorites_item | 16384
- public | issuelinktype | linktypename | 16384
- public | issuelinktype | linktypestyle | 16384
- public | AO_D530BB_CANNEDRESPONSEAUDIT | index_ao_d530bb_can1880088006 | 16384
- public | AO_D530BB_CANNEDRESPONSEAUDIT | index_ao_d530bb_can474028001 | 16384
- public | AO_D530BB_CANNEDRESPONSEAUDIT | index_ao_d530bb_can762862566 | 16384
- public | AO_D4B4E5_PROJECT_CATEGORIES | index_ao_d4b4e5_pro653473483 | 16384
- public | filtersubscription | subscrpt_user | 16384
- public | AO_2D3BEA_PLAN_ALLOCATION | index_ao_2d3bea_pla2112398099 | 16384
- public | AO_21F425_MESSAGE_MAPPING_AO | index_ao_21f425_mes1965715920 | 16384
- public | feature | feature_id_userkey | 16384
- public | AO_D4B4E5_GLOBAL_SETTINGS | index_ao_d4b4e5_glo1940878326 | 16384
- public | cwd_directory | idx_directory_active | 16384
- public | cwd_directory | idx_directory_impl | 16384
- public | cwd_directory | idx_directory_type | 16384
- public | cwd_directory | uk_directory_name | 16384
- public | AO_544E33_FIELD_RULE | index_ao_544e33_fie861445027 | 16384
- public | AO_544E33_AUTO_REPLY_PARAMS | index_ao_544e33_aut1005010751 | 16384
- public | AO_544E33_AUTO_REPLY_PARAMS | index_ao_544e33_aut2005391903 | 16384
- public | AO_544E33_NOTIFICATION_EVENT | index_ao_544e33_not312783942 | 16384
- public | AO_544E33_NOTIFICATION_EVENT | index_ao_544e33_not1911977422 | 16384
- public | AO_544E33_NOTIFICATION_RECIP | index_ao_544e33_not241034691 | 16384
- public | AO_544E33_MAIL_HANDLER_LOG | index_ao_544e33_mai505567918 | 16384
- public | AO_544E33_MAIL_HANDLER_LOG | index_ao_544e33_mai532512453 | 16384
- public | AO_544E33_MAIL_HANDLER_LOG | index_ao_544e33_mai1611860173 | 16384
- public | AO_544E33_MAIL_HANDLER_LOG | index_ao_544e33_mai1507261652 | 16384
- public | AO_544E33_MAIL_HANDLER_LOG | index_ao_544e33_mai233373260 | 16384
- public | AO_544E33_MAIL_HANDLER_LOG | index_ao_544e33_mai1680680320 | 16384
- public | AO_544E33_MAIL_HANDLER_LOG | index_ao_544e33_mai1483005427 | 16384
- public | AO_544E33_MAIL_HANDLER_LOG | index_ao_544e33_mai1615893247 | 16384
- public | AO_A912D8_TENANT_CONFIG | index_ao_a912d8_ten1467754719 | 16384
- public | AO_D4B4E5_LOCK | index_ao_d4b4e5_loc453259742 | 16384
- public | AO_54307E_VIEWPORT | index_ao_54307e_vie1184941465 | 16384
- public | AO_5E638F_DV_PARAMETER | index_ao_5e638f_dv_625595410 | 16384
- public | AO_5E638F_VF_COM_HIST | index_ao_5e638f_vf_99539047 | 16384
- public | AO_54307E_CUSTOMGLOBALTHEME | index_ao_54307e_cus23265228 | 16384
- public | AO_C7F17E_PROJECT_LANG_CONFIG | index_ao_c7f17e_pro1274623457 | 16384
- public | AO_013613_ACTIVITY_SOURCE | index_ao_013613_act324649239 | 16384
- public | AO_013613_ACTIVITY_SOURCE | index_ao_013613_act115863318 | 16384
- public | AO_8542F1_IFJ_WIDGET | index_ao_8542f1_ifj305424786 | 16384
- public | AO_8542F1_IFJ_WIDGET | index_ao_8542f1_ifj941564104 | 16384
- public | AO_B1EC07_ICATEGORY_SORTING | index_ao_b1ec07_ica619186160 | 16384
- public | AO_B1EC07_ICATEGORY_FILTER | index_ao_b1ec07_ica48955554 | 16384
- public | AO_B1EC07_ICATEGORIZED_ATTACH | index_ao_b1ec07_ica2074260068 | 16384
- public | AO_B1EC07_IATT_CAT_ISSUE_TYPE | index_ao_b1ec07_iat2067890058 | 16384
- public | AO_8542F1_IFJ_WIDGET | index_ao_8542f1_ifj1060492104 | 16384
- public | AO_B1EC07_IATTACHMENT_CATEGORY | index_ao_b1ec07_iat1537998220 | 16384
- public | AO_013613_HD_SCHEME_MEMBER | index_ao_013613_hd_764606571 | 16384
- public | AO_8542F1_IFJ_STATUS_TYPE | index_ao_8542f1_ifj447719176 | 16384
- public | AO_8542F1_IFJ_SD_PROP | index_ao_8542f1_ifj386106510 | 16384
- public | AO_8542F1_IFJ_REF_TYPE | index_ao_8542f1_ifj1757574379 | 16384
- public | AO_8542F1_IFJ_WIDGET | index_ao_8542f1_ifj1824166175 | 16384
- public | AO_C3C6E8_CATEGORY_V1 | index_ao_c3c6e8_cat125822599 | 16384
- public | AO_60DB71_SPRINT | index_ao_60db71_spr1457658269 | 16384
- public | AO_54307E_PARTICIPANTSETTINGS | index_ao_54307e_par1577879197 | 16384
- public | AO_8542F1_IFJ_OBJ_SCHEMA | index_ao_8542f1_ifj477145454 | 16384
- public | AO_C3C6E8_ACCOUNT_V1 | index_ao_c3c6e8_acc1873384369 | 16384
- public | external_entities | ext_entity_name | 8192
- public | entity_translation | entitytranslation_locale | 8192
- public | cwd_group_attributes | idx_group_attr_dir_name_lval | 8192
- public | clusterupgradestate | ordernumber_idx | 8192
- public | boardproject | idx_board_board_ids | 8192
- public | boardproject | idx_board_project_ids | 8192
- public | AO_F58FCA_SYNC_STATUS_MSG | index_ao_f58fca_syn1872092082 | 8192
- public | AO_ED669C_SEEN_ASSERTIONS | index_ao_ed669c_see20117222 | 8192
- public | AO_E8B6CC_SYNC_EVENT | index_ao_e8b6cc_syn493078035 | 8192
- public | AO_E8B6CC_SYNC_AUDIT_LOG | index_ao_e8b6cc_syn203792807 | 8192
- public | AO_E8B6CC_REPO_TO_PROJECT | index_ao_e8b6cc_rep1928770529 | 8192
- public | AO_E8B6CC_REPO_TO_CHANGESET | index_ao_e8b6cc_rep1082901832 | 8192
- public | AO_E8B6CC_REPO_TO_CHANGESET | index_ao_e8b6cc_rep922992576 | 8192
- public | AO_E8B6CC_REPOSITORY_MAPPING | index_ao_e8b6cc_rep702725269 | 8192
- public | AO_E8B6CC_REPOSITORY_MAPPING | index_ao_e8b6cc_rep93578901 | 8192
- public | AO_E8B6CC_PULL_REQUEST | index_ao_e8b6cc_pul1230717024 | 8192
- public | AO_E8B6CC_PULL_REQUEST | index_ao_e8b6cc_pul1448445182 | 8192
- public | AO_E8B6CC_PR_TO_COMMIT | index_ao_e8b6cc_pr_1045528152 | 8192
- public | AO_E8B6CC_PR_TO_COMMIT | index_ao_e8b6cc_pr_1458633226 | 8192
- public | AO_E8B6CC_PR_TO_COMMIT | index_ao_e8b6cc_pr_685151049 | 8192
- public | AO_E8B6CC_PR_PARTICIPANT | index_ao_e8b6cc_pr_1105917040 | 8192
- public | AO_E8B6CC_PR_PARTICIPANT | index_ao_e8b6cc_pr_758084799 | 8192
- public | AO_E8B6CC_PR_ISSUE_KEY | index_ao_e8b6cc_pr_1639282617 | 8192
- public | AO_E8B6CC_PR_ISSUE_KEY | index_ao_e8b6cc_pr_2106805302 | 8192
- public | AO_E8B6CC_PR_ISSUE_KEY | index_ao_e8b6cc_pr_281193494 | 8192
- public | AO_E8B6CC_ORG_TO_PROJECT | index_ao_e8b6cc_org1899590324 | 8192
- public | AO_E8B6CC_MESSAGE_TAG | index_ao_e8b6cc_mes1391090780 | 8192
- public | AO_E8B6CC_MESSAGE_TAG | index_ao_e8b6cc_mes1648007831 | 8192
- public | AO_E8B6CC_MESSAGE_QUEUE_ITEM | index_ao_e8b6cc_mes344532677 | 8192
- public | AO_E8B6CC_MESSAGE | index_ao_e8b6cc_mes1247039512 | 8192
- public | AO_B1EC07_IUPLOAD_ROLE | index_ao_b1ec07_iup1365765414 | 8192
- public | AO_B1EC07_ISCHEDULER_PROJECT | index_ao_b1ec07_isc1839119630 | 8192
- public | AO_B1EC07_IRULED_PROJECT | index_ao_b1ec07_iru732613407 | 8192
- public | AO_B1EC07_IJAM_PROJECT_ENTITY | index_ao_b1ec07_ija454563677 | 8192
- public | AO_B1EC07_IATTACH_PRO_CONFIG | index_ao_b1ec07_iat2013010319 | 8192
- public | AO_B1EC07_IATTACH_CAT_RESTRICT | index_ao_b1ec07_iat2114269937 | 8192
- public | AO_B1EC07_IATTACH_CAT_RESTRICT | index_ao_b1ec07_iat349026178 | 8192
- public | AO_B1EC07_IATTACHMENT_BACKUP | index_ao_b1ec07_iat717303258 | 8192
- public | AO_8542F1_IFJ_RCF_TO_REFTYPE | index_ao_8542f1_ifj2118996768 | 8192
- public | AO_8542F1_IFJ_RCF_CONNECT | index_ao_8542f1_ifj783962056 | 8192
- public | AO_8542F1_IFJ_ON_FILTER_ATTR | index_ao_8542f1_ifj987496734 | 8192
- public | AO_8542F1_IFJ_ON_EVENT_USER | index_ao_8542f1_ifj283958390 | 8192
- public | AO_8542F1_IFJ_OBJ_KEY_MAP | index_ao_8542f1_ifj1191683536 | 8192
- public | AO_8542F1_IFJ_IMPORT_RESULT | index_ao_8542f1_ifj1275124657 | 8192
- public | AO_8542F1_IFJ_IMPORT_CFG_ATTR | index_ao_8542f1_ifj1400084318 | 8192
- public | AO_8542F1_IFJ_IMPORT_CFG | index_ao_8542f1_ifj1202022130 | 8192
- public | userpickerfilterrole | cf_userpickerfilterrole | 8192
- public | userpickerfiltergroup | cf_userpickerfiltergroup | 8192
- public | userpickerfilter | upf_customfield | 8192
- public | userbase | osuser_name | 8192
- public | AO_60DB71_ISSUERANKING | index_ao_60db71_iss1616896230 | 8192
- public | AO_60DB71_ISSUERANKING | index_ao_60db71_iss1786461035 | 8192
- public | AO_5FB9D7_AOHIP_CHAT_USER | index_ao_5fb9d7_aoh49772492 | 8192
- public | AO_575BF5_PROVIDER_SEQ_NO | index_ao_575bf5_pro996609822 | 8192
- public | AO_575BF5_PROVIDER_ISSUE | index_ao_575bf5_pro1117502689 | 8192
- public | AO_575BF5_PROVIDER_ISSUE | index_ao_575bf5_pro741170824 | 8192
- public | AO_575BF5_PROCESSED_COMMITS | index_ao_575bf5_pro1681808571 | 8192
- public | AO_575BF5_PROCESSED_COMMITS | index_ao_575bf5_pro78019725 | 8192
- public | AO_575BF5_DEV_SUMMARY | index_ao_575bf5_dev996442447 | 8192
- public | AO_56464C_NOTIFICATIONRECORD | index_ao_56464c_not5371299 | 8192
- public | AO_8542F1_IFJ_WIDGET_SHARE | index_ao_8542f1_ifj2100595035 | 8192
- public | AO_54307E_OUT_EMAIL_SETTINGS | index_ao_54307e_out808665536 | 8192
- public | AO_54307E_ORGANIZATION_MEMBER | index_ao_54307e_org1628402717 | 8192
- public | AO_54307E_ORGANIZATION | index_ao_54307e_org240106076 | 8192
- public | AO_54307E_EMAILSETTINGS | index_ao_54307e_ema648278202 | 8192
- public | AO_54307E_CONFLUENCEKBLABELS | index_ao_54307e_con1589156183 | 8192
- public | AO_54307E_CONFLUENCEKBLABELS | index_ao_54307e_con714018041 | 8192
- public | AO_54307E_CONFLUENCEKBENABLED | index_ao_54307e_con1483953915 | 8192
- public | AO_54307E_CONFLUENCEKBENABLED | index_ao_54307e_con1935875239 | 8192
- public | AO_38321B_CUSTOM_CONTENT_LINK | index_ao_38321b_cus1828044926 | 8192
- public | AO_E8B6CC_ISSUE_TO_CHANGESET | index_ao_e8b6cc_iss1229805759 | 8192
- public | AO_E8B6CC_ISSUE_TO_CHANGESET | index_ao_e8b6cc_iss417950110 | 8192
- public | AO_E8B6CC_ISSUE_TO_BRANCH | index_ao_e8b6cc_iss1325927291 | 8192
- public | AO_E8B6CC_ISSUE_TO_BRANCH | index_ao_e8b6cc_iss353204826 | 8192
- public | AO_E8B6CC_GIT_HUB_EVENT | index_ao_e8b6cc_git1120895454 | 8192
- public | AO_E8B6CC_GIT_HUB_EVENT | index_ao_e8b6cc_git1804640320 | 8192
- public | AO_E8B6CC_COMMIT | index_ao_e8b6cc_com1308336834 | 8192
- public | AO_E8B6CC_COMMIT | index_ao_e8b6cc_commit_node | 8192
- public | AO_E8B6CC_CHANGESET_MAPPING | index_ao_e8b6cc_cha1086340152 | 8192
- public | AO_E8B6CC_CHANGESET_MAPPING | index_ao_e8b6cc_cha1483243924 | 8192
- public | AO_E8B6CC_CHANGESET_MAPPING | index_ao_e8b6cc_cha509722037 | 8192
- public | AO_E8B6CC_BRANCH_HEAD_MAPPING | index_ao_e8b6cc_bra1368852151 | 8192
- public | AO_E8B6CC_BRANCH | index_ao_e8b6cc_bra405461593 | 8192
- public | AO_2C4E5C_MAILITEMCHUNK | index_ao_2c4e5c_mai9620346 | 8192
- public | AO_2C4E5C_MAILITEMAUDIT | index_ao_2c4e5c_mai1011024424 | 8192
- public | AO_2C4E5C_MAILHANDLER | index_ao_2c4e5c_mai737633864 | 8192
- public | AO_2C4E5C_MAILCHANNEL | index_ao_2c4e5c_mai809659826 | 8192
- public | AO_563AEE_OBJECT_ENTITY | index_ao_563aee_obj696886343 | 8192
- public | AO_544E33_ATTACHMENT_DIGEST | index_ao_544e33_att47380303 | 8192
- public | AO_F58FCA_CONNECTOR_STORAGE | index_ao_f58fca_con1945787255 | 8192
- public | AO_F58FCA_CONNECTOR_STORAGE | index_ao_f58fca_con131774621 | 8192
- public | AO_D4B4E5_PARTICIPANT_IS_RESTR | index_ao_d4b4e5_par1402296938 | 8192
- public | AO_D4B4E5_PARTICIPANT_IS_RESTR | index_ao_d4b4e5_par481043990 | 8192
- public | AO_D4B4E5_PARTICIPANT_IS_RESTR | index_ao_d4b4e5_par46416081 | 8192
- public | AO_D4B4E5_PARTICIPANT_IS_RESTR | index_ao_d4b4e5_par1402498841 | 8192
- public | AO_D4B4E5_CATEGORY_IS_RESTR | index_ao_d4b4e5_cat799453438 | 8192
- public | AO_D4B4E5_STATUS_IS_RESTR | index_ao_d4b4e5_sta953869226 | 8192
- public | AO_D4B4E5_STATUS_IS_RESTR | index_ao_d4b4e5_sta1041765216 | 8192
- public | AO_D4B4E5_ISSUE_TYPE_IS_RESTR | index_ao_d4b4e5_iss3242655 | 8192
- public | AO_D4B4E5_ISSUE_TYPE_IS_RESTR | index_ao_d4b4e5_iss1439208498 | 8192
- public | AO_D4B4E5_ISSUE_TYPE_IS_RESTR | index_ao_d4b4e5_iss1680370042 | 8192
- public | AO_D4B4E5_CONF_IS_RESTR | index_ao_d4b4e5_con1816428783 | 8192
- public | AO_8542F1_IFJ_CF_CONNECT | index_ao_8542f1_ifj780619716 | 8192
- public | AO_8542F1_IFJ_ON_FILTER_SHARE | index_ao_8542f1_ifj860606516 | 8192
- public | AO_8542F1_IFJ_ON_FILTER_FAV | index_ao_8542f1_ifj1291363088 | 8192
- public | AO_8542F1_IFJ_ON_FILTER_FAV | index_ao_8542f1_ifj1521738877 | 8192
- public | AO_8542F1_IFJ_ON_FILTER | index_ao_8542f1_ifj7775394 | 8192
- public | AO_8542F1_IFJ_ON_FILTER | index_ao_8542f1_ifj1724793810 | 8192
- public | AO_013613_SAVED_REPORT | index_ao_013613_sav760223531 | 8192
- public | AO_013613_SAVED_REPORT | index_ao_013613_sav521436703 | 8192
- public | AO_D4B4E5_FOLDER_ROOT | index_ao_d4b4e5_fol2035912419 | 8192
- public | AO_D4B4E5_NODE_FOLDER | index_ao_d4b4e5_nod600627144 | 8192
- public | AO_D4B4E5_NODE_FOLDER | index_ao_d4b4e5_nod842082843 | 8192
- public | AO_D4B4E5_NODE_ATTACHMENT | index_ao_d4b4e5_nod571439152 | 8192
- public | AO_D4B4E5_NODE_ATTACHMENT | index_ao_d4b4e5_nod2008405591 | 8192
- public | AO_D4B4E5_CHILD_NODE | index_ao_d4b4e5_chi835129489 | 8192
- public | AO_D4B4E5_CHILD_NODE | index_ao_d4b4e5_chi2045960863 | 8192
- public | AO_D4B4E5_TREE_NODE | index_ao_d4b4e5_tre1183721941 | 8192
- public | AO_86B55C_OUT_OF_OFFICE_RPROP | index_ao_86b55c_out633627372 | 8192
- public | AO_AD17CE_HISTORY_LOG | index_ao_ad17ce_his1153076223 | 8192
- public | AO_AD17CE_HISTORY_LOG | index_ao_ad17ce_his591900316 | 8192
- public | AO_AD17CE_HISTORY_LOG | index_ao_ad17ce_his1819735103 | 8192
- public | AO_AD17CE_RESOURCE | index_ao_ad17ce_res1831272510 | 8192
- public | AO_D76270_GC_FEEDBACK_GRADE | index_ao_d76270_gc_609208029 | 8192
- public | AO_D76270_GC_FEEDBACK_MAILROLE | index_ao_d76270_gc_128356057 | 8192
- public | AO_D76270_GC_FEEDBACK_MAILUSER | index_ao_d76270_gc_1635020164 | 8192
- public | AO_D76270_GC_FEEDBACK_STATUSES | index_ao_d76270_gc_1326164851 | 8192
- public | AO_D76270_GC_FEEDBACK_VIEWROLE | index_ao_d76270_gc_1609075944 | 8192
- public | AO_D76270_GC_FEEDBACK_QUESTION | index_ao_d76270_gc_1600652781 | 8192
- public | AO_D76270_GC_FEEDBACK_TITLE | index_ao_d76270_gc_1199876643 | 8192
- public | AO_A912D8_REMOTE_COMMENT | index_ao_a912d8_rem2053688355 | 8192
- public | AO_A912D8_REMOTE_COMMENT | index_ao_a912d8_rem1918256321 | 8192
- public | AO_544E33_DISTRIBUTION_LIST | index_ao_544e33_dis272488082 | 8192
- public | AO_544E33_MAIL_LAST_FETCH | index_ao_544e33_mai828731196 | 8192
- public | AO_A912D8_REMOTE_ATTACHMENT | index_ao_a912d8_rem1083704121 | 8192
- public | AO_A912D8_REMOTE_ATTACHMENT | index_ao_a912d8_rem625181545 | 8192
- public | AO_544E33_ACC2_HANDLERS | index_ao_544e33_acc65472962 | 8192
- public | AO_544E33_ACC2_HANDLERS | index_ao_544e33_acc1437774971 | 8192
- public | AO_544E33_INCOMGING_QUEUE_ITEM | index_ao_544e33_inc997156982 | 8192
- public | AO_544E33_MAIL_UID | index_ao_544e33_mai759591785 | 8192
- public | AO_A912D8_PROFILE_CONFIG | index_ao_a912d8_pro803763130 | 8192
- public | AO_A912D8_PROFILE_CONFIG | index_ao_a912d8_pro1215509732 | 8192
- public | AO_A912D8_PROFILE_CONFIG | index_ao_a912d8_pro25673642 | 8192
- public | votehistory | votehistory_issue_index | 8192
- public | AO_5E638F_VAULT_COMMENT | index_ao_5e638f_vau1144634920 | 8192
- public | AO_013613_EXPENSE | index_ao_013613_exp1681165127 | 8192
- public | AO_013613_WA_SL_VALUE | index_ao_013613_wa_2138046152 | 8192
- public | cwd_synchronisation_status | idx_sync_status_node | 8192
- public | AO_C3C6E8_CUSTOMER_PERMISSION | index_ao_c3c6e8_cus2101421576 | 8192
- public | AO_54307E_ORGANIZATION_PROJECT | index_ao_54307e_org1427239366 | 8192
- public | AO_2D3BEA_FOLIO_USER_AO | index_ao_2d3bea_fol1244646876 | 8192
- public | AO_2D3BEA_RATE | index_ao_2d3bea_rat1642264103 | 8192
- public | AO_2D3BEA_RATE | index_ao_2d3bea_rate_link_key | 8192
- public | AO_587B34_PROJECT_CONFIG | index_ao_587b34_pro1732672724 | 8192
- public | AO_587B34_PROJECT_CONFIG | index_ao_587b34_pro193829489 | 8192
- public | AO_587B34_PROJECT_CONFIG | index_ao_587b34_pro2093917684 | 8192
- public | AO_587B34_PROJECT_CONFIG | index_ao_587b34_pro2115480362 | 8192
- public | AO_2D3BEA_ENTITY_CHANGE | index_ao_2d3bea_ent1268213396 | 8192
- public | AO_2D3BEA_ENTITY_CHANGE | index_ao_2d3bea_ent1481928026 | 8192
- public | AO_2D3BEA_EXCHANGERATE | index_ao_2d3bea_exc105892572 | 8192
- public | AO_2D3BEA_PERMISSION_GROUP | index_ao_2d3bea_per731548227 | 8192
- public | AO_2D3BEA_FOLIO_PERM_GROUP | index_ao_2d3bea_fol895702292 | 8192
- public | AO_2D3BEA_FOLIO_ADMIN | index_ao_2d3bea_fol203863211 | 8192
- public | AO_2D3BEA_STATUS | index_ao_2d3bea_sta860711872 | 8192
- public | AO_2D3BEA_EXTERNALTEAM | index_ao_2d3bea_ext1423640266 | 8192
- public | AO_2D3BEA_EXTERNALTEAM | index_ao_2d3bea_ext2053839966 | 8192
- public | AO_2D3BEA_NWDS | index_ao_2d3bea_nwds_folio_id | 8192
- public | AO_2D3BEA_TIMELINE | index_ao_2d3bea_tim1628972975 | 8192
- public | AO_2D3BEA_WEEKDAY | index_ao_2d3bea_wee197705530 | 8192
- public | AO_2D3BEA_FOLIO_FORMAT | index_ao_2d3bea_fol765065541 | 8192
- public | AO_2D3BEA_CUSTOMFIELD | index_ao_2d3bea_cus664654363 | 8192
- public | AO_2D3BEA_EXPENSE | index_ao_2d3bea_exp1879294570 | 8192
- public | AO_2D3BEA_EXPENSE | index_ao_2d3bea_exp336835184 | 8192
- public | AO_2D3BEA_EXPENSE | index_ao_2d3bea_expense_type | 8192
- public | AO_2D3BEA_OTRULETOFOLIO | index_ao_2d3bea_otr1829544105 | 8192
- public | AO_2D3BEA_OTRULETOFOLIO | index_ao_2d3bea_otr434298623 | 8192
- public | AO_2D3BEA_BASELINE | index_ao_2d3bea_baseline_name | 8192
- public | AO_2D3BEA_FOLIOTOPORTFOLIO | index_ao_2d3bea_fol1864668786 | 8192
- public | AO_2D3BEA_FOLIOTOPORTFOLIO | index_ao_2d3bea_fol1921262961 | 8192
- public | AO_2D3BEA_PORTFOLIO_ADMIN | index_ao_2d3bea_por1692002135 | 8192
- public | AO_2D3BEA_PORTFOLIO_DYNAMIC_CF | index_ao_2d3bea_por721364473 | 8192
- public | AO_2D3BEA_PORTFOLIO | index_ao_2d3bea_portfolio_name | 8192
- public | AO_2D3BEA_PORTFOLIOTOPORTFOLIO | index_ao_2d3bea_por1120179622 | 8192
- public | AO_2D3BEA_PORTFOLIOTOPORTFOLIO | index_ao_2d3bea_por1799341332 | 8192
- public | AO_2D3BEA_FOLIOCF | index_ao_2d3bea_fol689716514 | 8192
- public | AO_2D3BEA_FOLIOCFVALUE | index_ao_2d3bea_fol646663790 | 8192
- public | AO_2D3BEA_FOLIOCFVALUE | index_ao_2d3bea_fol1411200621 | 8192
- public | AO_2D3BEA_CUSTOMFIELDVALUE | index_ao_2d3bea_cus1293981141 | 8192
- public | AO_2D3BEA_CUSTOMFIELDVALUE | index_ao_2d3bea_cus1832390725 | 8192
- public | AO_2D3BEA_WORKED_HOURS | index_ao_2d3bea_wor1157240656 | 8192
- public | AO_2D3BEA_CUSTOMFIELDPVALUE | index_ao_2d3bea_cus1659130843 | 8192
- public | AO_2D3BEA_CUSTOMFIELDPVALUE | index_ao_2d3bea_cus1700721342 | 8192
- public | AO_2D3BEA_ALLOCATION | index_ao_2d3bea_all545553968 | 8192
- public | AO_2D3BEA_POSITION | index_ao_2d3bea_pos1710678563 | 8192
- public | AO_2D3BEA_POSITION | index_ao_2d3bea_pos1563453887 | 8192
- public | AO_2D3BEA_POSITION | index_ao_2d3bea_pos653699722 | 8192
- public | AO_2D3BEA_POSITION | index_ao_2d3bea_pos405202839 | 8192
- public | AO_2D3BEA_WAGE | index_ao_2d3bea_wag1842102024 | 8192
- public | AO_2D3BEA_ATTACHMENT | index_ao_2d3bea_att629655053 | 8192
- public | AO_2D3BEA_ATTACHMENT | index_ao_2d3bea_att70353952 | 8192
- public | AO_86ED1B_TIMEPLAN | index_ao_86ed1b_tim2080992994 | 8192
- public | AO_86ED1B_WORKLOG_EXT_PROP | index_ao_86ed1b_wor713457950 | 8192
- public | AO_AC3877_RL_USER_COUNTER | index_ao_ac3877_rl_2023752663 | 8192
- public | AO_AC3877_RL_USER_COUNTER | index_ao_ac3877_rl_1696242418 | 8192
- public | AO_D4B4E5_CATEGORY_IS_RESTR | index_ao_d4b4e5_cat686424532 | 8192
- public | AO_8542F1_IFJ_WIDGET_FAV | index_ao_8542f1_ifj1720511709 | 8192
- public | AO_8542F1_IFJ_WIDGET_TO_LBL | index_ao_8542f1_ifj122682079 | 8192
- public | schemeissuesecurities | sec_security | 8192
- public | projectversion | idx_version_sequence | 8192
- public | projectcategory | idx_project_category_name | 8192
- public | membershipbase | mshipbase_group | 8192
- public | membershipbase | mshipbase_user | 8192
- public | jquartz_triggers | idx_qrtz_j_g | 8192
- public | jquartz_triggers | idx_qrtz_j_state | 8192
- public | jquartz_triggers | idx_qrtz_t_c | 8192
- public | jquartz_triggers | idx_qrtz_t_j | 8192
- public | jquartz_triggers | idx_qrtz_t_jg | 8192
- public | jquartz_triggers | idx_qrtz_t_n_g_state | 8192
- public | jquartz_triggers | idx_qrtz_t_n_state | 8192
- public | jquartz_triggers | idx_qrtz_t_next_fire_time | 8192
- public | jquartz_triggers | idx_qrtz_t_nft_misfire | 8192
- public | jquartz_triggers | idx_qrtz_t_nft_st | 8192
- public | jquartz_triggers | idx_qrtz_t_nft_st_misfire | 8192
- public | jquartz_triggers | idx_qrtz_t_nft_st_misfire_grp | 8192
- public | jquartz_job_details | idx_qrtz_j_grp | 8192
- public | jquartz_job_details | idx_qrtz_j_req_recovery | 8192
- public | jquartz_fired_triggers | idx_qrtz_ft_inst_job_req_rcvry | 8192
- public | jquartz_fired_triggers | idx_qrtz_ft_j_g | 8192
- public | jquartz_fired_triggers | idx_qrtz_ft_jg | 8192
- public | jquartz_fired_triggers | idx_qrtz_ft_t_g | 8192
- public | jquartz_fired_triggers | idx_qrtz_ft_tg | 8192
- public | jquartz_fired_triggers | idx_qrtz_ft_trig_inst_name | 8192
- public | jiraworkflowstatuses | idx_parent_name | 8192
- public | groupbase | osgroup_name | 8192
- public | fieldlayoutschemeassociation | fl_scheme_assoc | 8192
- (383 ROWS)
- -- top 30 indexes by size
- schemaname | tablename | indexname | index_size | idx_tup_read | idx_tup_fetch | idx_scan
- ------------+------------------------------+-------------------------------+------------+--------------+---------------+------------
- public | AO_8542F1_IFJ_OBJ_ATTR_VAL | index_ao_8542f1_ifj138788814 | 939 MB | 2601 | 888 | 681
- public | AO_8542F1_IFJ_OBJ_ATTR | index_ao_8542f1_ifj268009346 | 934 MB | 2801949499 | 2673942790 | 68508
- public | AO_8542F1_IFJ_OBJ_ATTR_VAL | index_ao_8542f1_ifj228666017 | 934 MB | 2968800661 | 2968319722 | 2921953090
- public | AO_8542F1_IFJ_OBJ_ATTR | index_ao_8542f1_ifj43488772 | 931 MB | 215818618 | 215603487 | 6569870
- public | customfieldvalue | cfvalue_issue | 838 MB | 26893543 | 26617110 | 9686163
- public | AO_8542F1_IFJ_OBJ_HIST | index_ao_8542f1_ifj217015789 | 813 MB | 157197 | 53876 | 702
- public | changeitem | chgitem_group_field | 566 MB | 944422 | 944422 | 4454587
- public | changeitem | chgitem_field | 456 MB | 1605 | 1605 | 3
- public | changegroup | chggroup_author_created | 389 MB | 1299 | 1299 | 24
- public | changeitem | chgitem_chggrp | 329 MB | 3522118 | 3522118 | 2356773
- public | changegroup | chggroup_issue_id | 317 MB | 50 | 48 | 48
- public | entity_property | entityproperty_id_name_key | 311 MB | 776420 | 737646 | 1345049
- public | entity_property | entityproperty_key_name | 280 MB | 0 | 0 | 126
- public | AO_9B2E3B_EXEC_RULE_MSG_ITEM | index_ao_9b2e3b_exe1939877636 | 253 MB | 1632219 | 1270005 | 148507
- public | AO_733371_EVENT_PARAMETER | index_ao_733371_eve704112384 | 230 MB | 305151 | 104891 | 9924
- public | changegroup | chggroup_issue | 226 MB | 8112531 | 8099533 | 663675
- public | entity_property | entityproperty_entity | 191 MB | 0 | 0 | 444
- public | AO_54307E_SLAAUDITLOGDATA | index_ao_54307e_sla384441158 | 187 MB | 3414286 | 1707142 | 2150642
- public | AO_54307E_SLAAUDITLOG | index_ao_54307e_sla400544864 | 119 MB | 0 | 0 | 2
- public | AO_9B2E3B_IF_COND_EXECUTION | index_ao_9b2e3b_if_939960910 | 114 MB | 196854 | 94652 | 185893
- public | AO_9B2E3B_IF_EXECUTION | index_ao_9b2e3b_if_469154523 | 113 MB | 286330 | 185901 | 278845
- public | AO_9B2E3B_IF_THEN_EXECUTION | index_ao_9b2e3b_if_180675374 | 113 MB | 565170 | 464741 | 118959
- public | os_historystep | historystep_entryid | 71 MB | 247 | 247 | 83
- public | AO_8542F1_IFJ_OBJ_JIRAISSUE | index_ao_8542f1_ifj1301902193 | 60 MB | 29721 | 29712 | 11511
- public | AO_8542F1_IFJ_OBJ_JIRAISSUE | index_ao_8542f1_ifj502692216 | 60 MB | 167 | 0 | 227
- public | jiraaction | action_author_created | 43 MB | 356 | 356 | 24
- public | AO_60DB71_LEXORANK | index_ao_60db71_lex1694305086 | 31 MB | 0 | 0 | 2
- public | AO_60DB71_LEXORANK | index_ao_60db71_lex1569533973 | 30 MB | 5408125 | 5389452 | 6385
- public | jiraaction | action_issue | 24 MB | 2168997 | 2168527 | 555318
- public | jiraissue | issue_proj_status | 24 MB | 525708157 | 525668649 | 5268
- -- ask from Gonchik Tsymzhitov the full idea of investigation
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement