dimitri / pgloader

Migrate to PostgreSQL in a single command!
http://pgloader.io
Other
5.47k stars 551 forks source link

Foreign Key Errors #1165

Closed asifiqbal closed 4 years ago

asifiqbal commented 4 years ago

Thanks for contributing to pgloader by reporting an issue! Reporting an issue is the only way we can solve problems, fix bugs, and improve both the software and its user experience in general.

The best bug reports follow those 3 simple steps:

  1. show what you did,
$ pgloader --version
pgloader version "3.6.2"
compiled with SBCL 2.0.2
$ cat mysql2pgsql.load
LOAD DATABASE
     FROM      mysql://mysql:secret@192.168.1.184/jiratiny
     INTO      pgsql://postgres:postgres@192.168.1.184/jiratiny

     WITH
        batch rows = 1000,
        batch size = 512 MB,
        prefetch rows = 20000
;
$ pgloader mysql2pgsql.load
  1. show the result you got,
                             table name     errors       rows      bytes      total time
---------------------------------------  ---------  ---------  ---------  --------------
                        fetch meta data          0       3487                     5.300s
                         Create Schemas          0          0                     0.003s
                       Create SQL Types          0          0                     0.007s
                          Create tables          0       1932                     4.670s
                         Set Table OIDs          0        966                     0.015s
---------------------------------------  ---------  ---------  ---------  --------------
                jiratiny.actions_c14101          0        100     6.9 kB          0.084s
... (966 tables)
          jiratiny.workflowschemeentity          0        100     3.2 kB       1m11.525s
---------------------------------------  ---------  ---------  ---------  --------------
                COPY Threads Completion          0          4                  1m17.716s
                         Create Indexes          0       2198                  2m58.550s
                 Index Build Completion          0       2198                     0.235s
                        Reset Sequences          0        759                     0.382s
                           Primary Keys          0        966                     2.301s
                    Create Foreign Keys         50        273                     1.004s
                        Create Triggers          0          0                     0.001s
                        Set Search Path          0          1                     0.003s
                       Install Comments          0          0                     0.000s
---------------------------------------  ---------  ---------  ---------  --------------
                      Total import time          ✓      35690    54.2 MB       4m20.192
  1. explain how the result is not what you expected.

I am seeing 50 of the foreign keys failed to migrate

pgloader version "3.6.2"
compiled with SBCL 2.0.2
2020-06-05T21:37:06.757000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_589059_rule_to_label" violates foreign key constraint "fk_ao_589059_rule_to_label_rule_id"
DETAIL: Key (rule_id)=(188) is not present in table "ao_589059_rule_config".
QUERY: ALTER TABLE jiratiny.ao_589059_rule_to_label ADD CONSTRAINT fk_ao_589059_rule_to_label_rule_id FOREIGN KEY(rule_id) REFERENCES jiratiny.ao_589059_rule_config(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:06.765000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_60db71_boardadmins" violates foreign key constraint "fk_ao_60db71_boardadmins_rapid_view_id"
DETAIL: Key (rapid_view_id)=(203) is not present in table "ao_60db71_rapidview".
QUERY: ALTER TABLE jiratiny.ao_60db71_boardadmins ADD CONSTRAINT fk_ao_60db71_boardadmins_rapid_view_id FOREIGN KEY(rapid_view_id) REFERENCES jiratiny.ao_60db71_rapidview(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:06.771000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_60db71_cardlayout" violates foreign key constraint "fk_ao_60db71_cardlayout_rapid_view_id"
DETAIL: Key (rapid_view_id)=(307) is not present in table "ao_60db71_rapidview".
QUERY: ALTER TABLE jiratiny.ao_60db71_cardlayout ADD CONSTRAINT fk_ao_60db71_cardlayout_rapid_view_id FOREIGN KEY(rapid_view_id) REFERENCES jiratiny.ao_60db71_rapidview(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:06.781000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_60db71_estimatestatistic" violates foreign key constraint "fk_ao_60db71_estimatestatistic_rapid_view_id"
DETAIL: Key (rapid_view_id)=(203) is not present in table "ao_60db71_rapidview".
QUERY: ALTER TABLE jiratiny.ao_60db71_estimatestatistic ADD CONSTRAINT fk_ao_60db71_estimatestatistic_rapid_view_id FOREIGN KEY(rapid_view_id) REFERENCES jiratiny.ao_60db71_rapidview(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:06.803000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_60db71_nonworkingday" violates foreign key constraint "fk_ao_60db71_nonworkingday_working_days_id"
DETAIL: Key (working_days_id)=(302) is not present in table "ao_60db71_workingdays".
QUERY: ALTER TABLE jiratiny.ao_60db71_nonworkingday ADD CONSTRAINT fk_ao_60db71_nonworkingday_working_days_id FOREIGN KEY(working_days_id) REFERENCES jiratiny.ao_60db71_workingdays(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:06.803000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_60db71_subquery" violates foreign key constraint "fk_ao_60db71_subquery_rapid_view_id"
DETAIL: Key (rapid_view_id)=(203) is not present in table "ao_60db71_rapidview".
QUERY: ALTER TABLE jiratiny.ao_60db71_subquery ADD CONSTRAINT fk_ao_60db71_subquery_rapid_view_id FOREIGN KEY(rapid_view_id) REFERENCES jiratiny.ao_60db71_rapidview(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:06.804000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_60db71_trackingstatistic" violates foreign key constraint "fk_ao_60db71_trackingstatistic_rapid_view_id"
DETAIL: Key (rapid_view_id)=(203) is not present in table "ao_60db71_rapidview".
QUERY: ALTER TABLE jiratiny.ao_60db71_trackingstatistic ADD CONSTRAINT fk_ao_60db71_trackingstatistic_rapid_view_id FOREIGN KEY(rapid_view_id) REFERENCES jiratiny.ao_60db71_rapidview(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:06.904000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_60db71_workingdays" violates foreign key constraint "fk_ao_60db71_workingdays_rapid_view_id"
DETAIL: Key (rapid_view_id)=(203) is not present in table "ao_60db71_rapidview".
QUERY: ALTER TABLE jiratiny.ao_60db71_workingdays ADD CONSTRAINT fk_ao_60db71_workingdays_rapid_view_id FOREIGN KEY(rapid_view_id) REFERENCES jiratiny.ao_60db71_rapidview(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:06.904000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_6b9f04_aio_calculated_field" violates foreign key constraint "fk_ao_6b9f04_aio_calculated_field_owner_id"
DETAIL: Key (owner_id)=(282) is not present in table "ao_6b9f04_aio_user".
QUERY: ALTER TABLE jiratiny.ao_6b9f04_aio_calculated_field ADD CONSTRAINT fk_ao_6b9f04_aio_calculated_field_owner_id FOREIGN KEY(owner_id) REFERENCES jiratiny.ao_6b9f04_aio_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:06.905000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_6b9f04_aio_published_result" violates foreign key constraint "fk_ao_6b9f04_aio_published_result_report_id"
DETAIL: Key (report_id)=(235) is not present in table "ao_6b9f04_aio_report".
QUERY: ALTER TABLE jiratiny.ao_6b9f04_aio_published_result ADD CONSTRAINT fk_ao_6b9f04_aio_published_result_report_id FOREIGN KEY(report_id) REFERENCES jiratiny.ao_6b9f04_aio_report(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:06.905000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_6b9f04_aio_report" violates foreign key constraint "fk_ao_6b9f04_aio_report_owner_id"
DETAIL: Key (owner_id)=(110) is not present in table "ao_6b9f04_aio_user".
QUERY: ALTER TABLE jiratiny.ao_6b9f04_aio_report ADD CONSTRAINT fk_ao_6b9f04_aio_report_owner_id FOREIGN KEY(owner_id) REFERENCES jiratiny.ao_6b9f04_aio_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:06.905000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_6b9f04_aio_report_page" violates foreign key constraint "fk_ao_6b9f04_aio_report_page_report_id"
DETAIL: Key (report_id)=(680) is not present in table "ao_6b9f04_aio_report".
QUERY: ALTER TABLE jiratiny.ao_6b9f04_aio_report_page ADD CONSTRAINT fk_ao_6b9f04_aio_report_page_report_id FOREIGN KEY(report_id) REFERENCES jiratiny.ao_6b9f04_aio_report(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:06.906000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_6b9f04_aio_scheduled_report" violates foreign key constraint "fk_ao_6b9f04_aio_scheduled_report_report_id"
DETAIL: Key (report_id)=(853) is not present in table "ao_6b9f04_aio_report".
QUERY: ALTER TABLE jiratiny.ao_6b9f04_aio_scheduled_report ADD CONSTRAINT fk_ao_6b9f04_aio_scheduled_report_report_id FOREIGN KEY(report_id) REFERENCES jiratiny.ao_6b9f04_aio_report(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:06.906000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_6b9f04_aio_sched_rep_rcpt" violates foreign key constraint "fk_ao_6b9f04_aio_sched_rep_rcpt_recipient_id"
DETAIL: Key (recipient_id)=(2375) is not present in table "ao_6b9f04_aio_user".
QUERY: ALTER TABLE jiratiny.ao_6b9f04_aio_sched_rep_rcpt ADD CONSTRAINT fk_ao_6b9f04_aio_sched_rep_rcpt_recipient_id FOREIGN KEY(recipient_id) REFERENCES jiratiny.ao_6b9f04_aio_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:06.907000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_6b9f04_aio_shared_report" violates foreign key constraint "fk_ao_6b9f04_aio_shared_report_report_id"
DETAIL: Key (report_id)=(163) is not present in table "ao_6b9f04_aio_report".
QUERY: ALTER TABLE jiratiny.ao_6b9f04_aio_shared_report ADD CONSTRAINT fk_ao_6b9f04_aio_shared_report_report_id FOREIGN KEY(report_id) REFERENCES jiratiny.ao_6b9f04_aio_report(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:06.907000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_6b9f04_aio_shared_report" violates foreign key constraint "fk_ao_6b9f04_aio_shared_report_user_id"
DETAIL: Key (user_id)=(112) is not present in table "ao_6b9f04_aio_user".
QUERY: ALTER TABLE jiratiny.ao_6b9f04_aio_shared_report ADD CONSTRAINT fk_ao_6b9f04_aio_shared_report_user_id FOREIGN KEY(user_id) REFERENCES jiratiny.ao_6b9f04_aio_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:06.908000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_6b9f04_aio_team" violates foreign key constraint "fk_ao_6b9f04_aio_team_owner_id"
DETAIL: Key (owner_id)=(225) is not present in table "ao_6b9f04_aio_user".
QUERY: ALTER TABLE jiratiny.ao_6b9f04_aio_team ADD CONSTRAINT fk_ao_6b9f04_aio_team_owner_id FOREIGN KEY(owner_id) REFERENCES jiratiny.ao_6b9f04_aio_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:06.908000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_6b9f04_aio_team_member" violates foreign key constraint "fk_ao_6b9f04_aio_team_member_user_id"
DETAIL: Key (user_id)=(226) is not present in table "ao_6b9f04_aio_user".
QUERY: ALTER TABLE jiratiny.ao_6b9f04_aio_team_member ADD CONSTRAINT fk_ao_6b9f04_aio_team_member_user_id FOREIGN KEY(user_id) REFERENCES jiratiny.ao_6b9f04_aio_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:06.908000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_6b9f04_aio_user_preferences" violates foreign key constraint "fk_ao_6b9f04_aio_user_preferences_user_id"
DETAIL: Key (user_id)=(260) is not present in table "ao_6b9f04_aio_user".
QUERY: ALTER TABLE jiratiny.ao_6b9f04_aio_user_preferences ADD CONSTRAINT fk_ao_6b9f04_aio_user_preferences_user_id FOREIGN KEY(user_id) REFERENCES jiratiny.ao_6b9f04_aio_user(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:06.993000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_7deabf_folder_cycle_mapping" violates foreign key constraint "fk_ao_7deabf_folder_cycle_mapping_cycle_id"
DETAIL: Key (cycle_id)=(386) is not present in table "ao_7deabf_cycle".
QUERY: ALTER TABLE jiratiny.ao_7deabf_folder_cycle_mapping ADD CONSTRAINT fk_ao_7deabf_folder_cycle_mapping_cycle_id FOREIGN KEY(cycle_id) REFERENCES jiratiny.ao_7deabf_cycle(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:06.993000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_7deabf_step_defect" violates foreign key constraint "fk_ao_7deabf_step_defect_step_result_id"
DETAIL: Key (step_result_id)=(201) is not present in table "ao_7deabf_step_result".
QUERY: ALTER TABLE jiratiny.ao_7deabf_step_defect ADD CONSTRAINT fk_ao_7deabf_step_defect_step_result_id FOREIGN KEY(step_result_id) REFERENCES jiratiny.ao_7deabf_step_result(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:06.996000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_7deabf_step_result" violates foreign key constraint "fk_ao_7deabf_step_result_step_id"
DETAIL: Key (step_id)=(174) is not present in table "ao_7deabf_teststep".
QUERY: ALTER TABLE jiratiny.ao_7deabf_step_result ADD CONSTRAINT fk_ao_7deabf_step_result_step_id FOREIGN KEY(step_id) REFERENCES jiratiny.ao_7deabf_teststep(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.013000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_82b313_ability" violates foreign key constraint "fk_ao_82b313_ability_person_id"
DETAIL: Key (person_id)=(315) is not present in table "ao_82b313_person".
QUERY: ALTER TABLE jiratiny.ao_82b313_ability ADD CONSTRAINT fk_ao_82b313_ability_person_id FOREIGN KEY(person_id) REFERENCES jiratiny.ao_82b313_person(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.024000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_82b313_resource" violates foreign key constraint "fk_ao_82b313_resource_person_id"
DETAIL: Key (person_id)=(169) is not present in table "ao_82b313_person".
QUERY: ALTER TABLE jiratiny.ao_82b313_resource ADD CONSTRAINT fk_ao_82b313_resource_person_id FOREIGN KEY(person_id) REFERENCES jiratiny.ao_82b313_person(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.053000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_8542f1_ifj_comment" violates foreign key constraint "fk_ao_8542f1_ifj_comment_object_id"
DETAIL: Key (object_id)=(3959) is not present in table "ao_8542f1_ifj_obj".
QUERY: ALTER TABLE jiratiny.ao_8542f1_ifj_comment ADD CONSTRAINT fk_ao_8542f1_ifj_comment_object_id FOREIGN KEY(object_id) REFERENCES jiratiny.ao_8542f1_ifj_obj(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.085000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_8542f1_ifj_obj_attach" violates foreign key constraint "fk_ao_8542f1_ifj_obj_attach_object_id"
DETAIL: Key (object_id)=(4617) is not present in table "ao_8542f1_ifj_obj".
QUERY: ALTER TABLE jiratiny.ao_8542f1_ifj_obj_attach ADD CONSTRAINT fk_ao_8542f1_ifj_obj_attach_object_id FOREIGN KEY(object_id) REFERENCES jiratiny.ao_8542f1_ifj_obj(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.090000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_8542f1_ifj_obj_attr" violates foreign key constraint "fk_ao_8542f1_ifj_obj_attr_object_type_attribute_id"
DETAIL: Key (object_type_attribute_id)=(191) is not present in table "ao_8542f1_ifj_obj_type_attr".
QUERY: ALTER TABLE jiratiny.ao_8542f1_ifj_obj_attr ADD CONSTRAINT fk_ao_8542f1_ifj_obj_attr_object_type_attribute_id FOREIGN KEY(object_type_attribute_id) REFERENCES jiratiny.ao_8542f1_ifj_obj_type_attr(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.103000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_8542f1_ifj_obj_attr_val" violates foreign key constraint "fk_ao_8542f1_ifj_obj_attr_val_object_attribute_id"
DETAIL: Key (object_attribute_id)=(205) is not present in table "ao_8542f1_ifj_obj_attr".
QUERY: ALTER TABLE jiratiny.ao_8542f1_ifj_obj_attr_val ADD CONSTRAINT fk_ao_8542f1_ifj_obj_attr_val_object_attribute_id FOREIGN KEY(object_attribute_id) REFERENCES jiratiny.ao_8542f1_ifj_obj_attr(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.103000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_8542f1_ifj_obj_jiraissue" violates foreign key constraint "fk_ao_8542f1_ifj_obj_jiraissue_object_id"
DETAIL: Key (object_id)=(14548) is not present in table "ao_8542f1_ifj_obj".
QUERY: ALTER TABLE jiratiny.ao_8542f1_ifj_obj_jiraissue ADD CONSTRAINT fk_ao_8542f1_ifj_obj_jiraissue_object_id FOREIGN KEY(object_id) REFERENCES jiratiny.ao_8542f1_ifj_obj(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.104000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_8542f1_ifj_obj_type" violates foreign key constraint "fk_ao_8542f1_ifj_obj_type_icon_id"
DETAIL: Key (icon_id)=(110) is not present in table "ao_8542f1_ifj_icon".
QUERY: ALTER TABLE jiratiny.ao_8542f1_ifj_obj_type ADD CONSTRAINT fk_ao_8542f1_ifj_obj_type_icon_id FOREIGN KEY(icon_id) REFERENCES jiratiny.ao_8542f1_ifj_icon(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.110000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_8542f1_ifj_obj_type" violates foreign key constraint "fk_ao_8542f1_ifj_obj_type_parent_object_type_id"
DETAIL: Key (parent_object_type_id)=(233) is not present in table "ao_8542f1_ifj_obj_type".
QUERY: ALTER TABLE jiratiny.ao_8542f1_ifj_obj_type ADD CONSTRAINT fk_ao_8542f1_ifj_obj_type_parent_object_type_id FOREIGN KEY(parent_object_type_id) REFERENCES jiratiny.ao_8542f1_ifj_obj_type(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.123000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_8542f1_ifj_obj_watch" violates foreign key constraint "fk_ao_8542f1_ifj_obj_watch_object_id"
DETAIL: Key (object_id)=(15637) is not present in table "ao_8542f1_ifj_obj".
QUERY: ALTER TABLE jiratiny.ao_8542f1_ifj_obj_watch ADD CONSTRAINT fk_ao_8542f1_ifj_obj_watch_object_id FOREIGN KEY(object_id) REFERENCES jiratiny.ao_8542f1_ifj_obj(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.162000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_8542f1_ifj_role_actor" violates foreign key constraint "fk_ao_8542f1_ifj_role_actor_role_aoid"
DETAIL: Key (role_aoid)=(254) is not present in table "ao_8542f1_ifj_role".
QUERY: ALTER TABLE jiratiny.ao_8542f1_ifj_role_actor ADD CONSTRAINT fk_ao_8542f1_ifj_role_actor_role_aoid FOREIGN KEY(role_aoid) REFERENCES jiratiny.ao_8542f1_ifj_role(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.206000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_8b1069_pre_cond_result" violates foreign key constraint "fk_ao_8b1069_pre_cond_result_test_run_id"
DETAIL: Key (test_run_id)=(1632) is not present in table "ao_8b1069_test_run".
QUERY: ALTER TABLE jiratiny.ao_8b1069_pre_cond_result ADD CONSTRAINT fk_ao_8b1069_pre_cond_result_test_run_id FOREIGN KEY(test_run_id) REFERENCES jiratiny.ao_8b1069_test_run(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.210000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_8b1069_test_example_result" violates foreign key constraint "fk_ao_8b1069_test_example_result_test_run_id"
DETAIL: Key (test_run_id)=(6674) is not present in table "ao_8b1069_test_run".
QUERY: ALTER TABLE jiratiny.ao_8b1069_test_example_result ADD CONSTRAINT fk_ao_8b1069_test_example_result_test_run_id FOREIGN KEY(test_run_id) REFERENCES jiratiny.ao_8b1069_test_run(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.213000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_8b1069_test_example_result" violates foreign key constraint "fk_ao_8b1069_test_example_result_test_run_result_id"
DETAIL: Key (test_run_result_id)=(7644) is not present in table "ao_8b1069_test_run_result".
QUERY: ALTER TABLE jiratiny.ao_8b1069_test_example_result ADD CONSTRAINT fk_ao_8b1069_test_example_result_test_run_result_id FOREIGN KEY(test_run_result_id) REFERENCES jiratiny.ao_8b1069_test_run_result(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.226000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_8b1069_test_run_defect" violates foreign key constraint "fk_ao_8b1069_test_run_defect_test_run_id"
DETAIL: Key (test_run_id)=(1710) is not present in table "ao_8b1069_test_run".
QUERY: ALTER TABLE jiratiny.ao_8b1069_test_run_defect ADD CONSTRAINT fk_ao_8b1069_test_run_defect_test_run_id FOREIGN KEY(test_run_id) REFERENCES jiratiny.ao_8b1069_test_run(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.230000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_8b1069_test_run_defect" violates foreign key constraint "fk_ao_8b1069_test_run_defect_test_step_result_id"
DETAIL: Key (test_step_result_id)=(562) is not present in table "ao_8b1069_test_step_result".
QUERY: ALTER TABLE jiratiny.ao_8b1069_test_run_defect ADD CONSTRAINT fk_ao_8b1069_test_run_defect_test_step_result_id FOREIGN KEY(test_step_result_id) REFERENCES jiratiny.ao_8b1069_test_step_result(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.253000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_8b1069_test_step_result" violates foreign key constraint "fk_ao_8b1069_test_step_result_test_run_id"
DETAIL: Key (test_run_id)=(1540) is not present in table "ao_8b1069_test_run".
QUERY: ALTER TABLE jiratiny.ao_8b1069_test_step_result ADD CONSTRAINT fk_ao_8b1069_test_step_result_test_run_id FOREIGN KEY(test_run_id) REFERENCES jiratiny.ao_8b1069_test_run(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.254000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_8b1069_test_step_result" violates foreign key constraint "fk_ao_8b1069_test_step_result_test_step_id"
DETAIL: Key (test_step_id)=(185) is not present in table "ao_8b1069_test_step".
QUERY: ALTER TABLE jiratiny.ao_8b1069_test_step_result ADD CONSTRAINT fk_ao_8b1069_test_step_result_test_step_id FOREIGN KEY(test_step_id) REFERENCES jiratiny.ao_8b1069_test_step(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.287000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_a415df_aoestimate" violates foreign key constraint "fk_ao_a415df_aoestimate_aowork_item_id"
DETAIL: Key (aowork_item_id)=(251) is not present in table "ao_a415df_aowork_item".
QUERY: ALTER TABLE jiratiny.ao_a415df_aoestimate ADD CONSTRAINT fk_ao_a415df_aoestimate_aowork_item_id FOREIGN KEY(aowork_item_id) REFERENCES jiratiny.ao_a415df_aowork_item(id_other) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.363000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_aefed0_membership" violates foreign key constraint "fk_ao_aefed0_membership_team_member_id"
DETAIL: Key (team_member_id)=(101) is not present in table "ao_aefed0_team_member_v2".
QUERY: ALTER TABLE jiratiny.ao_aefed0_membership ADD CONSTRAINT fk_ao_aefed0_membership_team_member_id FOREIGN KEY(team_member_id) REFERENCES jiratiny.ao_aefed0_team_member_v2(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.423000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_d9132d_distribution" violates foreign key constraint "fk_ao_d9132d_distribution_scenario_issue_id"
DETAIL: Key (scenario_issue_id)=(1646) is not present in table "ao_d9132d_scenario_issues".
QUERY: ALTER TABLE jiratiny.ao_d9132d_distribution ADD CONSTRAINT fk_ao_d9132d_distribution_scenario_issue_id FOREIGN KEY(scenario_issue_id) REFERENCES jiratiny.ao_d9132d_scenario_issues(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.442000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_d9132d_planteam" violates foreign key constraint "fk_ao_d9132d_planteam_issue_source_id"
DETAIL: Key (issue_source_id)=(190) is not present in table "ao_d9132d_issue_source".
QUERY: ALTER TABLE jiratiny.ao_d9132d_planteam ADD CONSTRAINT fk_ao_d9132d_planteam_issue_source_id FOREIGN KEY(issue_source_id) REFERENCES jiratiny.ao_d9132d_issue_source(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.456000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_d9132d_planversion" violates foreign key constraint "fk_ao_d9132d_planversion_plan_id"
DETAIL: Key (plan_id)=(134) is not present in table "ao_d9132d_plan".
QUERY: ALTER TABLE jiratiny.ao_d9132d_planversion ADD CONSTRAINT fk_ao_d9132d_planversion_plan_id FOREIGN KEY(plan_id) REFERENCES jiratiny.ao_d9132d_plan(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.462000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_d9132d_plan_custom_field" violates foreign key constraint "fk_ao_d9132d_plan_custom_field_plan_id"
DETAIL: Key (plan_id)=(142) is not present in table "ao_d9132d_plan".
QUERY: ALTER TABLE jiratiny.ao_d9132d_plan_custom_field ADD CONSTRAINT fk_ao_d9132d_plan_custom_field_plan_id FOREIGN KEY(plan_id) REFERENCES jiratiny.ao_d9132d_plan(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.484000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_d9132d_scenario_issue_cmpnt" violates foreign key constraint "fk_ao_d9132d_scenario_issue_cmpnt_scenario_issue_id"
DETAIL: Key (scenario_issue_id)=(2168) is not present in table "ao_d9132d_scenario_issues".
QUERY: ALTER TABLE jiratiny.ao_d9132d_scenario_issue_cmpnt ADD CONSTRAINT fk_ao_d9132d_scenario_issue_cmpnt_scenario_issue_id FOREIGN KEY(scenario_issue_id) REFERENCES jiratiny.ao_d9132d_scenario_issues(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.495000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_d9132d_scenario_issue_res" violates foreign key constraint "fk_ao_d9132d_scenario_issue_res_scenario_issue_id"
DETAIL: Key (scenario_issue_id)=(789) is not present in table "ao_d9132d_scenario_issues".
QUERY: ALTER TABLE jiratiny.ao_d9132d_scenario_issue_res ADD CONSTRAINT fk_ao_d9132d_scenario_issue_res_scenario_issue_id FOREIGN KEY(scenario_issue_id) REFERENCES jiratiny.ao_d9132d_scenario_issues(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.510000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_d9132d_scenario_team" violates foreign key constraint "fk_ao_d9132d_scenario_team_issue_source_id"
DETAIL: Key (issue_source_id)=(219) is not present in table "ao_d9132d_issue_source".
QUERY: ALTER TABLE jiratiny.ao_d9132d_scenario_team ADD CONSTRAINT fk_ao_d9132d_scenario_team_issue_source_id FOREIGN KEY(issue_source_id) REFERENCES jiratiny.ao_d9132d_issue_source(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.514000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_d9132d_scenario_team" violates foreign key constraint "fk_ao_d9132d_scenario_team_scenario_id"
DETAIL: Key (scenario_id)=(137) is not present in table "ao_d9132d_scenario".
QUERY: ALTER TABLE jiratiny.ao_d9132d_scenario_team ADD CONSTRAINT fk_ao_d9132d_scenario_team_scenario_id FOREIGN KEY(scenario_id) REFERENCES jiratiny.ao_d9132d_scenario(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:37:07.588000+01:00 LOG report summary reset
                             table name     errors       rows      bytes      total time
---------------------------------------  ---------  ---------  ---------  --------------
                        fetch meta data          0       3487                     5.300s
                         Create Schemas          0          0                     0.003s
                       Create SQL Types          0          0                     0.007s
                          Create tables          0       1932                     4.670s
                         Set Table OIDs          0        966                     0.015s
---------------------------------------  ---------  ---------  ---------  --------------
                jiratiny.actions_c14101          0        100     6.9 kB          0.084s
                jiratiny.actions_c14119          0        100     6.6 kB          0.091s
                jiratiny.actions_c14517          0          0                     0.160s
                jiratiny.actions_c14401          0        100    15.1 kB          0.159s
                jiratiny.actions_c14613          0        100    10.1 kB          0.276s
                jiratiny.actions_c14522          0        100     3.4 kB          0.340s
                jiratiny.actions_c15003          0          9     0.4 kB          0.434s
                jiratiny.actions_c14657          0        100     5.2 kB          0.461s
                jiratiny.actions_c16209          0          0                     0.606s
                jiratiny.actions_c16106          0          0                     0.582s
                jiratiny.actions_c16627          0          0                     0.759s
                jiratiny.actions_c16630          0        100    51.9 kB          0.936s
                jiratiny.actions_c17607          0         49     7.3 kB          1.093s
                jiratiny.actions_c17501          0          3     0.5 kB          1.003s
                jiratiny.actions_c26228          0          0                     1.221s
                jiratiny.actions_c26227          0        100    23.4 kB          1.122s
                jiratiny.actions_c26472          0          4     0.3 kB          1.257s
                jiratiny.actions_c26626          0          0                     1.463s
                jiratiny.actions_c27117          0          2     0.2 kB          1.411s
                jiratiny.actions_c27118          0          1     0.1 kB          1.626s
                jiratiny.actions_f13519          0          0                     1.756s
                jiratiny.actions_f13501          0          0                     1.538s
                jiratiny.actions_f13915          0          0                     1.858s
                jiratiny.actions_f13800          0          0                     1.732s
                jiratiny.actions_f13920          0          0                     1.838s
                jiratiny.actions_f14011          0          0                     1.933s
                jiratiny.actions_f14054          0          0                     1.925s
                jiratiny.actions_f14400          0          0                     2.002s
                jiratiny.actions_f15923          0          0                     2.095s
                jiratiny.actions_f15404          0          0                     2.039s
     jiratiny.ao_013613_activity_source          0          0                     2.157s
                jiratiny.actions_f16907          0          0                     2.101s
        jiratiny.ao_013613_exp_category          0          1     0.0 kB          2.344s
             jiratiny.ao_013613_expense          0          0                     2.202s
           jiratiny.ao_013613_favorites          0          0                     2.373s
           jiratiny.ao_013613_hd_scheme          0          1     0.0 kB          2.502s
    jiratiny.ao_013613_hd_scheme_member          0         21     0.8 kB          2.746s
       jiratiny.ao_013613_hd_scheme_day          0          0                     2.506s
      jiratiny.ao_013613_project_config          0          2     0.0 kB          2.844s
    jiratiny.ao_013613_permission_group          0          3     0.1 kB          2.669s
            jiratiny.ao_013613_wa_value          0          0                     3.019s
         jiratiny.ao_013613_wa_sl_value          0          0                     2.832s
       jiratiny.ao_013613_wl_scheme_day          0          7     0.1 kB          3.227s
           jiratiny.ao_013613_wl_scheme          0          1     0.1 kB          3.032s
      jiratiny.ao_013613_work_attribute          0          0                     3.401s
    jiratiny.ao_013613_wl_scheme_member          0         21     0.8 kB          3.207s
            jiratiny.ao_09e361_xls_view          0         18     3.0 kB          3.596s
        jiratiny.ao_09e361_xls_resource          0         19   402.1 kB          3.615s
   jiratiny.ao_0a5972_push_registration          0          0                     3.691s
      jiratiny.ao_1273f8_admin_settings          0          0                     3.825s
           jiratiny.ao_1b54da_dbconfigs          0          0                     3.972s
jiratiny.ao_0a5972_notification_setting          0          0                     3.717s
   jiratiny.ao_0ac321_recommendation_ao          0          0                     3.852s
          jiratiny.ao_1273f8_cov_filter          0         10     9.1 kB          4.011s
    jiratiny.ao_1b54da_jobconfiguration          0          0                     4.069s
   jiratiny.ao_1b54da_integrationconfig          0          0                     4.198s
       jiratiny.ao_1b54da_krunnablesils          0          0                     4.366s
         jiratiny.ao_1b54da_krssecurity          0          0                     4.436s
             jiratiny.ao_1b54da_persvar          0          0                     4.500s
          jiratiny.ao_1b54da_ldapconfig          0          0                     4.524s
       jiratiny.ao_1b54da_remoteconfigs          0          0                     4.568s
        jiratiny.ao_1b54da_pluginconfig          0         30     2.6 kB          4.727s
              jiratiny.ao_1b54da_tstext          0          0                     4.749s
              jiratiny.ao_1b54da_tspath          0          0                     4.808s
       jiratiny.ao_1b54da_webhookconfig          0          0                     4.851s
         jiratiny.ao_1b54da_ug_security          0          0                     4.883s
     jiratiny.ao_21d670_whitelist_rules          0         15     0.8 kB          4.943s
       jiratiny.ao_1b54da_webhookmethod          0          0                     4.916s
  jiratiny.ao_21f425_message_mapping_ao          0          2     0.1 kB          5.038s
          jiratiny.ao_21f425_message_ao          0          2     1.2 kB          4.984s
    jiratiny.ao_21f425_user_property_ao          0        100    10.9 kB          5.036s
          jiratiny.ao_242870_attachment          0          0                     5.150s
    jiratiny.ao_242870_auto_import_rule          0          2     0.2 kB          5.343s
  jiratiny.ao_242870_auto_import_report          0        100    10.1 kB          5.056s
            jiratiny.ao_242870_baseline          0          3     0.3 kB          5.483s
    jiratiny.ao_242870_auto_imp_rep_ent          0        100     1.4 kB          5.145s
       jiratiny.ao_242870_baseline_item          0        100     2.2 kB          5.584s
jiratiny.ao_242870_baseline_comp_filter          0          3     0.1 kB          5.209s
  jiratiny.ao_242870_baseline_signature          0          0                     5.294s
     jiratiny.ao_242870_black_li_fi_rev          0          0                     5.786s
        jiratiny.ao_242870_cov_fil_migr          0          0                     5.894s
  jiratiny.ao_242870_child_req_relation          0          0                     5.368s
     jiratiny.ao_242870_dmmodel_project          0          0                     5.416s
          jiratiny.ao_242870_dmsettings          0          0                     5.927s
      jiratiny.ao_242870_email_template          0          1     0.0 kB          5.486s
      jiratiny.ao_242870_issue_revision          0        100     6.9 kB          6.014s
  jiratiny.ao_242870_permission_project          0        100     0.9 kB          5.522s
     jiratiny.ao_242870_permission_role          0         42     1.3 kB          6.012s
 jiratiny.ao_242870_permission_settings          0          1     0.0 kB          5.720s
     jiratiny.ao_242870_pers_cov_filter          0          0                     6.165s
   jiratiny.ao_242870_per_proj_category          0          2     0.0 kB          5.715s
     jiratiny.ao_242870_project_del_per          0          3     0.1 kB          6.173s
     jiratiny.ao_242870_project_mod_per          0          3     0.1 kB          5.848s
     jiratiny.ao_242870_project_mov_per          0          2     0.1 kB          6.312s
  jiratiny.ao_242870_project_permission          0         11     0.3 kB          5.843s
 jiratiny.ao_242870_project_read_filter          0          6     0.7 kB          5.940s
    jiratiny.ao_242870_project_per_rest          0          1     0.0 kB          6.319s
    jiratiny.ao_242870_project_settings          0        100    23.2 kB          5.984s
    jiratiny.ao_242870_project_rest_per          0          2     0.0 kB          6.482s
 jiratiny.ao_242870_project_she_mod_per          0          0                     6.138s
 jiratiny.ao_242870_project_she_del_per          0          0                     6.625s
 jiratiny.ao_242870_project_tree_filter          0        100     5.8 kB          6.144s
jiratiny.ao_242870_project_she_rest_per          0          0                     6.605s
 jiratiny.ao_242870_project_tree_folder          0        100     9.9 kB          6.822s
   jiratiny.ao_242870_project_tree_item          0        100     3.8 kB          6.284s
   jiratiny.ao_242870_project_tree_page          0          0                     6.725s
     jiratiny.ao_242870_proj_tree_watch          0          9     0.1 kB          6.286s
      jiratiny.ao_242870_pub_cov_filter          0          1     0.3 kB          6.937s
   jiratiny.ao_242870_req_data_mdl_rule          0          0                     6.444s
      jiratiny.ao_242870_req_dmmdl_rule          0          0                     6.928s
         jiratiny.ao_242870_req_dmmodel          0          0                     6.478s
     jiratiny.ao_242870_req_dmrule_link          0          0                     7.192s
      jiratiny.ao_242870_req_if_mapping          0          0                     6.548s
    jiratiny.ao_242870_revision_history          0        100    17.7 kB          6.617s
   jiratiny.ao_242870_reuse_copy_config          0          0                     7.063s
 jiratiny.ao_242870_suspect_config_item          0          0                     6.628s
      jiratiny.ao_242870_suspect_config          0          0                     7.193s
        jiratiny.ao_242870_suspect_migr          0          0                     6.695s
 jiratiny.ao_242870_suspect_config_link          0          0                     7.329s
   jiratiny.ao_242870_trace_pers_filter          0          1     0.3 kB          6.717s
            jiratiny.ao_242870_template          0         11   769.8 kB          7.879s
        jiratiny.ao_242870_user_profile          0          9     0.5 kB          6.841s
            jiratiny.ao_272c37_dtgentry          0          3     3.4 kB          6.830s
    jiratiny.ao_242870_trace_pub_filter          0          4     0.9 kB          7.501s
       jiratiny.ao_272c37_multi_cascade          0          0                     6.971s
            jiratiny.ao_272c37_dssentry          0          0                     7.690s
          jiratiny.ao_2b7a0e_delegation          0        100     4.7 kB          6.959s
        jiratiny.ao_272c37_field_config          0          2     2.1 kB          7.826s
      jiratiny.ao_2c4e5c_mailconnection          0          0                     7.103s
            jiratiny.ao_272c37_ubpentry          0        100     7.2 kB          8.074s
         jiratiny.ao_2c4e5c_mailhandler          0          0                     7.076s
       jiratiny.ao_2c4e5c_mailitemaudit          0          0                     7.214s
        jiratiny.ao_2c4e5c_mailrunaudit          0          0                     7.307s
          jiratiny.ao_2d3bea_attachment          0          0                     7.448s
             jiratiny.ao_2d3bea_comment          0          0                     7.548s
         jiratiny.ao_2d3bea_customfield          0          0                     7.616s
    jiratiny.ao_2d3bea_customfieldvalue          0          0                     7.687s
        jiratiny.ao_2d3bea_exchangerate          0          0                     7.743s
        jiratiny.ao_2d3bea_externalteam          0          2     0.1 kB          7.841s
             jiratiny.ao_2d3bea_foliocf          0          0                     7.897s
    jiratiny.ao_2d3bea_foliotoportfolio          0         10     0.1 kB          7.982s
        jiratiny.ao_2d3bea_folio_format          0         12     0.3 kB          8.049s
       jiratiny.ao_2d3bea_folio_user_ao          0        100     4.8 kB          8.227s
       jiratiny.ao_2d3bea_otruletofolio          0          0                     8.284s
    jiratiny.ao_2d3bea_permission_group          0          0                     8.402s
   jiratiny.ao_2d3bea_plan_approval_log          0          0                     8.514s
jiratiny.ao_2d3bea_portfoliotoportfolio          0          5     0.0 kB          8.622s
jiratiny.ao_2d3bea_portfolio_dynamic_cf          0          0                     8.722s
                jiratiny.ao_2d3bea_rate          0          8     0.2 kB          8.838s
            jiratiny.ao_2d3bea_timeline          0          0                     8.903s
          jiratiny.ao_2d3bea_user_index          0        100    19.8 kB          9.121s
             jiratiny.ao_2d3bea_weekday          0         84     1.0 kB          9.175s
            jiratiny.ao_2d3bea_workflow          0          0                     9.425s
          jiratiny.ao_2f1435_properties          0          1     0.0 kB          9.361s
             jiratiny.ao_319474_message          0          0                     9.585s
         jiratiny.ao_2c4e5c_mailchannel          0          0                     7.834s
               jiratiny.ao_319474_queue          0          0                     9.708s
   jiratiny.ao_2c4e5c_mailglobalhandler          0          0                     7.964s
 jiratiny.ao_38321b_custom_content_link          0          0                     9.853s
            jiratiny.ao_2c4e5c_mailitem          0          0                     8.140s
         jiratiny.ao_39e198_bar_comment          0         51    25.0 kB         10.290s
       jiratiny.ao_2c4e5c_mailitemchunk          0          0                     8.197s
        jiratiny.ao_39e198_bar_resource          0        100     1.6 MB         10.602s
          jiratiny.ao_2d3bea_allocation          0         46     2.4 kB          8.308s
            jiratiny.ao_2d3bea_baseline          0          0                     8.356s
            jiratiny.ao_2d3bea_currency          0         77     2.2 kB          8.535s
   jiratiny.ao_2d3bea_customfieldpvalue          0          0                     8.606s
       jiratiny.ao_2d3bea_entity_change          0        100     9.3 kB          8.768s
            jiratiny.ao_39e198_bar_user          0         16     4.6 kB         10.436s
        jiratiny.ao_39e198_bas_presence          0          0                    10.552s
     jiratiny.ao_39e198_bas_temp_object          0          0                    10.646s
             jiratiny.ao_2d3bea_expense          0          3     0.5 kB          8.780s
               jiratiny.ao_2d3bea_folio          0         12     2.5 kB          9.093s
     jiratiny.ao_4136f9_permission_role          0          3     0.1 kB         10.656s
         jiratiny.ao_4136f9_sche_filter          0          0                    10.727s
        jiratiny.ao_2d3bea_foliocfvalue          0          0                     9.032s
          jiratiny.ao_4136f9_sche_issue          0          0                    10.731s
         jiratiny.ao_2d3bea_folio_admin          0         27     1.1 kB          9.260s
       jiratiny.ao_4634d4_action_config          0          0                    10.834s
    jiratiny.ao_2d3bea_folio_perm_group          0          3     0.1 kB          9.335s
   jiratiny.ao_4634d4_additional_config          0          0                    10.831s
                jiratiny.ao_2d3bea_nwds          0          0                     9.484s
         jiratiny.ao_4634d4_field_entry          0          0                    10.979s
            jiratiny.ao_2d3bea_overtime          0          0                     9.594s
         jiratiny.ao_4634d4_restriction          0          0                    10.969s
     jiratiny.ao_2d3bea_plan_allocation          0          0                     9.723s
         jiratiny.ao_4634d4_salt_config          0          0                    11.057s
           jiratiny.ao_2d3bea_portfolio          0          7     0.7 kB          9.848s
       jiratiny.ao_4634d4_scheme_config          0          0                    11.054s
     jiratiny.ao_2d3bea_portfolio_admin          0         12     0.4 kB          9.902s
  jiratiny.ao_4634d4_user_select_config          0          0                    11.261s
            jiratiny.ao_2d3bea_position          0         46     6.4 kB         10.045s
 jiratiny.ao_4789dd_health_check_status          0         13     4.5 kB         11.229s
  jiratiny.ao_4789dd_read_notifications          0         61     4.0 kB         11.341s
              jiratiny.ao_2d3bea_status          0          0                    10.067s
         jiratiny.ao_2d3bea_user_filter          0          0                    10.240s
         jiratiny.ao_4aeacd_webhook_dao          0          1     0.3 kB         11.379s
   jiratiny.ao_4b00e6_script_run_result          0        100   157.6 kB         11.487s
                jiratiny.ao_2d3bea_wage          0         46     1.7 kB         10.480s
        jiratiny.ao_2d3bea_worked_hours          0          0                    10.391s
      jiratiny.ao_4b00e6_stash_settings          0          1     0.0 kB         11.504s
 jiratiny.ao_2f1435_health_check_status          0         25     8.9 kB         10.624s
  jiratiny.ao_2f1435_read_notifications          0        100     6.3 kB         10.578s
            jiratiny.ao_550953_shortcut          0        100    11.5 kB         11.572s
    jiratiny.ao_319474_message_property          0          0                    10.711s
          jiratiny.ao_55c8c0_bar_branch          0         23     5.6 kB         11.597s
      jiratiny.ao_319474_queue_property          0          0                    10.712s
            jiratiny.ao_55c8c0_bar_info          0        100     6.4 kB         11.708s
       jiratiny.ao_55c8c0_bar_thumbnail          0        100   895.4 kB         12.162s
          jiratiny.ao_39e198_bar_branch          0        100    20.6 kB         10.953s
            jiratiny.ao_39e198_bar_info          0        100     6.5 kB         10.919s
       jiratiny.ao_39e198_bar_thumbnail          0        100   852.4 kB         11.245s
   jiratiny.ao_39e198_bas_platform_info          0        100    11.5 kB         11.004s
   jiratiny.ao_55c8c0_bas_platform_info          0         15     2.0 kB         11.808s
         jiratiny.ao_39e198_bas_session          0        100    40.5 kB         11.165s
         jiratiny.ao_55c8c0_bas_session          0        100    37.9 kB         11.963s
      jiratiny.ao_3b1893_loop_detection          0          0                    11.276s
          jiratiny.ao_55c8c0_user_event          0         19     8.2 kB         12.198s
 jiratiny.ao_4136f9_permission_settings          0          1     0.0 kB         11.305s
        jiratiny.ao_563aee_actor_entity          0          0                    12.224s
        jiratiny.ao_4136f9_sche_history          0          0                    11.463s
       jiratiny.ao_563aee_object_entity          0          0                    12.320s
         jiratiny.ao_4136f9_sche_series          0          0                    11.409s
         jiratiny.ao_575bf5_dev_summary          0        100    23.1 kB         12.413s
   jiratiny.ao_4634d4_action_log_entity          0        100     2.8 kB         11.501s
      jiratiny.ao_575bf5_provider_issue          0        100     3.6 kB         12.462s
    jiratiny.ao_4634d4_audit_log_config          0         38     0.8 kB         11.605s
       jiratiny.ao_587b34_glance_config          0          0                    12.594s
       jiratiny.ao_4634d4_field_mapping          0          0                    11.691s
          jiratiny.ao_589059_audit_item          0        100    26.2 kB         12.671s
      jiratiny.ao_4634d4_run_log_entity          0         13     1.0 kB         11.743s
 jiratiny.ao_589059_audit_item_cge_item          0        100    12.7 kB         12.862s
  jiratiny.ao_589059_audit_item_project          0        100     1.6 kB         12.892s
     jiratiny.ao_4634d4_schedule_config          0          0                    11.876s
            jiratiny.ao_589059_counters          0          0                    13.125s
     jiratiny.ao_4634d4_user_log_entity          0        100     7.9 kB         11.883s
  jiratiny.ao_589059_rule_cfg_component          0        100    18.7 kB         13.188s
         jiratiny.ao_46e61b_used_fields          0         77     0.7 kB         12.028s
         jiratiny.ao_589059_rule_config          0        100    21.8 kB         13.367s
          jiratiny.ao_4789dd_properties          0          1     0.0 kB         12.031s
       jiratiny.ao_589059_rule_schedule          0         30     2.0 kB         13.404s
        jiratiny.ao_4789dd_task_monitor          0          0                    12.241s
   jiratiny.ao_589059_rule_state_latest          0        100     9.4 kB         13.571s
     jiratiny.ao_4b00e6_adapta_analytic          0          1     0.1 kB         12.213s
        jiratiny.ao_4b00e6_sr_user_prop          0          9     1.2 kB         12.370s
 jiratiny.ao_589059_rule_stat_rollup_hr          0        100     8.4 kB         13.571s
  jiratiny.ao_54307e_asyncupgraderecord          0         18     1.9 kB         12.420s
            jiratiny.ao_589059_rule_tag          0          0                    13.840s
        jiratiny.ao_55c8c0_app_settings          0          2     0.2 kB         12.557s
     jiratiny.ao_5fb9d7_aohip_chat_link          0          0                    13.847s
         jiratiny.ao_55c8c0_bar_comment          0         34    16.4 kB         12.649s
          jiratiny.ao_60db71_auditentry          0        100    10.5 kB         14.029s
        jiratiny.ao_55c8c0_bar_resource          0        100     1.1 MB         13.962s
           jiratiny.ao_60db71_cardcolor          0        100     2.8 kB         14.001s
              jiratiny.ao_60db71_column          0        100     2.8 kB         14.297s
     jiratiny.ao_60db71_detailviewfield          0        100     1.8 kB         14.275s
        jiratiny.ao_60db71_issueranking          0        100     2.1 kB         14.524s
            jiratiny.ao_55c8c0_bar_user          0          6     1.7 kB         12.865s
            jiratiny.ao_60db71_lexorank          0        100     3.5 kB         14.495s
        jiratiny.ao_55c8c0_bas_presence          0          0                    13.071s
       jiratiny.ao_60db71_nonworkingday          0        100     1.9 kB         14.732s
     jiratiny.ao_55c8c0_bas_temp_object          0          0                    13.250s
      jiratiny.ao_60db71_rankableobject          0          5     0.1 kB         14.701s
     jiratiny.ao_563aee_activity_entity          0        100    50.6 kB         13.453s
           jiratiny.ao_60db71_rapidview          0        100     9.1 kB         15.018s
   jiratiny.ao_563aee_media_link_entity          0        100    11.6 kB         13.744s
        jiratiny.ao_60db71_sprintmarker          0          5     0.1 kB         15.006s
       jiratiny.ao_563aee_target_entity          0        100    11.6 kB         13.916s
            jiratiny.ao_60db71_subquery          0        100     6.8 kB         15.282s
   jiratiny.ao_575bf5_processed_commits          0          6     0.5 kB         13.979s
     jiratiny.ao_575bf5_provider_seq_no          0          2     0.1 kB         14.227s
   jiratiny.ao_60db71_trackingstatistic          0        100     1.5 kB         15.309s
      jiratiny.ao_587b34_project_config          0          0                    14.306s
         jiratiny.ao_60db71_workingdays          0        100     3.8 kB         15.443s
 jiratiny.ao_589059_audit_item_asc_item          0        100     6.1 kB         14.475s
        jiratiny.ao_6358c7_dynamic_form          0          0                    15.510s
     jiratiny.ao_6358c7_mention_request          0          0                    15.657s
 jiratiny.ao_589059_audit_item_comp_cge          0        100     9.9 kB         14.839s
         jiratiny.ao_6358c7_pccache_prj          0        100     1.3 kB         15.680s
    jiratiny.ao_589059_automation_queue          0          1    29.3 kB         14.766s
jiratiny.ao_6b9f04_aio_calculated_field          0         43    26.6 kB         15.899s
    jiratiny.ao_589059_legacy_rule_link          0          0                    15.066s
 jiratiny.ao_6b9f04_aio_custom_attr_val          0          0                    15.881s
 jiratiny.ao_589059_rule_cfg_proj_assoc          0        100     2.2 kB         15.085s
jiratiny.ao_6b9f04_aio_non_project_hour          0          0                    16.059s
          jiratiny.ao_589059_rule_label          0          5     0.1 kB         15.290s
           jiratiny.ao_589059_rule_stat          0        100     9.5 kB         15.286s
    jiratiny.ao_6b9f04_aio_notification          0          0                    16.026s
jiratiny.ao_6b9f04_aio_published_result          0        100    33.5 MB         28.149s
jiratiny.ao_589059_rule_stat_rollup_day          0        100     8.7 kB         15.440s
jiratiny.ao_589059_rule_stat_rollup_min          0        100     9.1 kB         15.589s
       jiratiny.ao_589059_rule_to_label          0         44     0.4 kB         15.692s
     jiratiny.ao_5fb9d7_aohip_chat_user          0          0                    15.798s
         jiratiny.ao_60db71_boardadmins          0        100     4.2 kB         16.118s
          jiratiny.ao_60db71_cardlayout          0        100     3.1 kB         15.980s
        jiratiny.ao_60db71_columnstatus          0        100     1.1 kB         16.235s
   jiratiny.ao_60db71_estimatestatistic          0        100     2.5 kB         16.311s
     jiratiny.ao_60db71_issuerankinglog          0          0                    16.378s
    jiratiny.ao_60db71_lexorankbalancer          0          0                    16.425s
         jiratiny.ao_60db71_quickfilter          0        100    11.0 kB         16.485s
     jiratiny.ao_60db71_rank_issue_link          0          0                    16.581s
              jiratiny.ao_60db71_sprint          0        100     6.1 kB         16.694s
          jiratiny.ao_60db71_statsfield          0        100     1.4 kB         16.786s
            jiratiny.ao_60db71_swimlane          0        100     5.6 kB         16.904s
             jiratiny.ao_60db71_version          0          0                    16.971s
       jiratiny.ao_6358c7_attach_upload          0          0                    17.125s
  jiratiny.ao_6358c7_dynamic_form_value          0          0                    17.177s
             jiratiny.ao_6358c7_pccache          0          7     0.3 kB         17.295s
   jiratiny.ao_6b9f04_aio_bounced_email          0          0                    17.411s
jiratiny.ao_6b9f04_aio_custom_attribute          0          0                    17.441s
             jiratiny.ao_6b9f04_aio_key          0          1     2.0 kB         17.582s
jiratiny.ao_6b9f04_aio_non_project_task          0          0                    17.622s
     jiratiny.ao_6b9f04_aio_permissions          0          1    59.1 kB         17.761s
          jiratiny.ao_6b9f04_aio_report          0        100   456.3 kB         17.927s
jiratiny.ao_6b9f04_aio_scheduled_report          0         44    66.5 kB         17.966s
   jiratiny.ao_6b9f04_aio_shared_report          0        100     1.4 kB         18.030s
            jiratiny.ao_6b9f04_aio_team          0         21     0.5 kB         18.206s
       jiratiny.ao_6b9f04_aio_team_team          0          0                    18.325s
           jiratiny.ao_6b9f04_aio_timer          0          0                    18.442s
            jiratiny.ao_6b9f04_aio_user          0        100    24.4 kB         18.555s
              jiratiny.ao_6b9f04_report          0          0                    18.600s
                jiratiny.ao_6b9f04_user          0          0                    18.728s
     jiratiny.ao_733371_event_parameter          0        100     7.3 kB         18.795s
            jiratiny.ao_7a2604_calendar          0          7     0.7 kB         18.888s
         jiratiny.ao_7a2604_workingtime          0         35     1.2 kB         18.930s
         jiratiny.ao_7c2234_project_nvp          0          0                    19.024s
     jiratiny.ao_7deabf_change_zjegroup          0        100     9.4 kB         19.056s
  jiratiny.ao_7deabf_column_layout_item          0        100     2.2 kB         19.199s
  jiratiny.ao_7deabf_custom_fields_meta          0          9     1.0 kB         19.297s
jiratiny.ao_7deabf_custom_field_project          0          1     0.0 kB         19.402s
        jiratiny.ao_7deabf_execution_cf          0        100     2.7 kB         19.555s
              jiratiny.ao_7deabf_folder          0         65     5.3 kB         19.673s
jiratiny.ao_7deabf_reindex_job_progress          0          4     0.3 kB         19.725s
     jiratiny.ao_7deabf_schedule_defect          0        100     1.5 kB         19.837s
         jiratiny.ao_7deabf_step_result          0        100    10.6 kB         19.948s
        jiratiny.ao_7deabf_test_step_cf          0          0                    20.371s
    jiratiny.ao_7deabf_zqlfavorite_asoc          0         95     3.6 kB         20.463s
jiratiny.ao_7deabf_zqlshare_permissions          0         92     1.7 kB         20.624s
             jiratiny.ao_82b313_absence          0          0                    20.649s
                jiratiny.ao_82b313_init          0          2     0.0 kB         20.789s
            jiratiny.ao_82b313_resource          0        100     1.9 kB         20.784s
                jiratiny.ao_82b313_team          0        100     8.0 kB         20.991s
        jiratiny.ao_8542f1_ifj_atm_rule          0          1     0.1 kB         20.958s
 jiratiny.ao_8542f1_ifj_atm_rule_ac_log          0          1     0.0 kB         21.125s
  jiratiny.ao_8542f1_ifj_atm_rule_co_ac          0          1     0.0 kB         21.121s
      jiratiny.ao_8542f1_ifj_cf_connect          0          0                    21.235s
     jiratiny.ao_8542f1_ifj_dcf_connect          0          4     0.6 kB         21.214s
            jiratiny.ao_8542f1_ifj_file          0         31     6.1 kB         21.848s
           jiratiny.ao_8542f1_ifj_image          0          0                    21.359s
 jiratiny.ao_8542f1_ifj_import_cfg_attr          0          0                    21.598s
   jiratiny.ao_8542f1_ifj_import_result          0          0                    21.715s
   jiratiny.ao_8542f1_ifj_import_src_ot          0         15     1.4 kB         21.839s
       jiratiny.ao_8542f1_ifj_label_tmp          0          0                    21.961s
      jiratiny.ao_8542f1_ifj_obj_attach          0         40     6.9 kB         21.968s
    jiratiny.ao_8542f1_ifj_obj_attr_val          0        100     4.0 kB         22.151s
   jiratiny.ao_8542f1_ifj_obj_jiraissue          0        100     2.2 kB         22.171s
      jiratiny.ao_8542f1_ifj_obj_schema          0         15     1.2 kB         22.414s
   jiratiny.ao_8542f1_ifj_obj_type_attr          0        100    13.0 kB         22.407s
        jiratiny.ao_8542f1_ifj_on_event          0          0                    22.621s
       jiratiny.ao_8542f1_ifj_on_filter          0          5     1.1 kB         22.605s
   jiratiny.ao_8542f1_ifj_on_filter_fav          0          5     0.3 kB         22.773s
      jiratiny.ao_8542f1_ifj_prg_in_prg          0          0                    22.753s
         jiratiny.ao_8542f1_ifj_prg_res          0        100    57.6 kB         23.003s
  jiratiny.ao_8542f1_ifj_rcf_to_reftype          0          0                    23.049s
         jiratiny.ao_8542f1_ifj_res_ref          0         14     0.3 kB         23.168s
      jiratiny.ao_8542f1_ifj_role_actor          0        100     5.9 kB         23.252s
     jiratiny.ao_8542f1_ifj_status_type          0         28     0.6 kB         23.481s
          jiratiny.ao_8542f1_ifj_widget          0          8     4.2 kB         23.450s
      jiratiny.ao_8542f1_ifj_widget_lbl          0          0                    23.688s
   jiratiny.ao_8542f1_ifj_widget_to_lbl          0          0                    23.662s
     jiratiny.ao_86ed1b_grace_period_v2          0          0                    23.995s
       jiratiny.ao_86ed1b_period_config          0          2     0.2 kB         23.925s
     jiratiny.ao_86ed1b_report_template          0          0                    24.139s
            jiratiny.ao_86ed1b_timeplan          0          0                    24.115s
    jiratiny.ao_86ed1b_timesheet_status          0          0                    24.333s
 jiratiny.ao_88263f_health_check_status          0         23     8.1 kB         24.263s
  jiratiny.ao_88263f_read_notifications          0        100     6.3 kB         24.403s
            jiratiny.ao_8ac478_box_node          0        100     1.5 kB         24.461s
     jiratiny.ao_8ac478_box_type_id_gen          0          1     0.0 kB         24.550s
    jiratiny.ao_8ac478_distributed_lock          0          0                    24.668s
     jiratiny.ao_8ac478_et_surrogate_id          0         25     0.1 kB         24.684s
    jiratiny.ao_8ac478_extplatform_data          0          0                    24.656s
        jiratiny.ao_8ac478_extuser_data          0          2     0.1 kB         24.645s
 jiratiny.ao_8ac478_gantt_work_schedule          0          1     0.1 kB         24.896s
         jiratiny.ao_8ac478_global_task          0        100    20.2 kB         24.815s
        jiratiny.ao_8ac478_holiday_plan          0          1     0.1 kB         24.986s
              jiratiny.ao_8ac478_marker          0          0                    24.988s
            jiratiny.ao_8ac478_property          0        100    16.7 kB         25.763s
    jiratiny.ao_8ac478_resource_absence          0          0                    25.535s
      jiratiny.ao_8ac478_resource_skill          0          0                    26.085s
    jiratiny.ao_8ac478_res_surrogate_id          0        100     0.6 kB         26.041s
                jiratiny.ao_8ac478_role          0          3     0.2 kB         26.252s
      jiratiny.ao_8ac478_schedule_beta3          0        100     4.7 kB         26.305s
        jiratiny.ao_8ac478_task_mapping          0          2     0.2 kB         26.404s
       jiratiny.ao_8ac478_team_member_2          0          0                    26.524s
     jiratiny.ao_6b9f04_aio_report_page          0        100   399.3 kB         14.872s
               jiratiny.ao_8ac478_view2          0        100   228.1 kB         26.874s
  jiratiny.ao_6b9f04_aio_sched_rep_rcpt          0        100     5.0 kB         14.991s
       jiratiny.ao_8ac478_wbs_hierarchy          0        100     3.8 kB         26.804s
     jiratiny.ao_6b9f04_aio_shared_team          0          0                    15.207s
    jiratiny.ao_8ac478_wbs_quick_filter          0        100    10.9 kB         27.057s
   jiratiny.ao_8ac478_wbs_task_template          0          0                    27.071s
     jiratiny.ao_6b9f04_aio_team_member          0        100     1.0 kB         15.395s
       jiratiny.ao_8ac478_workload_plan          0          1     0.1 kB         27.225s
          jiratiny.ao_6b9f04_aio_tenant          0          1     0.2 kB         15.578s
       jiratiny.ao_6b9f04_aio_timesheet          0          0                    15.769s
       jiratiny.ao_8b1069_activity_item          0        100     3.2 kB         27.268s
          jiratiny.ao_8b1069_attachment          0        100    14.6 kB         27.429s
jiratiny.ao_6b9f04_aio_user_preferences          0         89     6.9 kB         15.940s
      jiratiny.ao_8b1069_automated_step          0        100    15.4 kB         27.743s
       jiratiny.ao_6b9f04_shared_report          0          0                    16.138s
jiratiny.ao_8b1069_automated_step_label          0          3     0.0 kB         28.425s
               jiratiny.ao_733371_event          0        100    10.0 kB         16.287s
              jiratiny.ao_8b1069_folder          0         49     3.0 kB         28.176s
     jiratiny.ao_733371_event_recipient          0        100    11.5 kB         16.557s
    jiratiny.ao_8b1069_pre_cond_memento          0          0                    28.631s
             jiratiny.ao_7a2604_holiday          0          0                    16.825s
  jiratiny.ao_8b1069_req_hstatus_entity          0        100     4.7 kB         28.838s
       jiratiny.ao_7aeb56_shared_script          0          0                    17.080s
         jiratiny.ao_8b1069_step_status          0          0                    28.797s
          jiratiny.ao_7deabf_attachment          0        100    12.5 kB         17.316s
   jiratiny.ao_8b1069_test_example_step          0        100     8.3 kB         29.174s
      jiratiny.ao_7deabf_change_zjeitem          0        100    22.5 kB         17.592s
 jiratiny.ao_8b1069_test_plan_test_link          0        100     3.9 kB         28.972s
        jiratiny.ao_7deabf_custom_field          0          1     0.1 kB         17.715s
  jiratiny.ao_8b1069_test_pre_cond_link          0        100     3.8 kB         29.206s
 jiratiny.ao_7deabf_custom_field_option          0          7     0.1 kB         17.924s
     jiratiny.ao_8b1069_test_run_defect          0        100     2.2 kB         29.437s
               jiratiny.ao_7deabf_cycle          0        100    15.1 kB         18.145s
     jiratiny.ao_8b1069_test_run_result          0        100     5.7 kB         29.588s
jiratiny.ao_7deabf_exec_cluster_message          0          0                    18.491s
         jiratiny.ao_8b1069_test_status          0          0                    29.689s
jiratiny.ao_7deabf_folder_cycle_mapping          0         65     4.8 kB         18.636s
   jiratiny.ao_8b1069_test_step_memento          0        100    18.0 kB         29.804s
            jiratiny.ao_7deabf_schedule          0        100    17.1 kB         18.893s
    jiratiny.ao_8b1069_tetest_plan_link          0        100     3.8 kB         29.890s
         jiratiny.ao_7deabf_step_defect          0        100     2.4 kB         19.310s
   jiratiny.ao_8b1069_trmigration_fault          0          0                    29.975s
            jiratiny.ao_7deabf_teststep          0        100    43.9 kB         19.593s
           jiratiny.ao_8bad1b_bootstrap          0          1     0.0 kB         30.150s
    jiratiny.ao_7deabf_zfjcolumn_layout          0        100     3.8 kB         19.807s
              jiratiny.ao_8bad1b_folder          0        100     2.3 kB         30.224s
           jiratiny.ao_7deabf_zqlfilter          0         92    19.1 kB         20.099s
       jiratiny.ao_8bad1b_forest_change          0        100     8.1 kB         30.383s
             jiratiny.ao_82b313_ability          0         21     0.3 kB         20.265s
        jiratiny.ao_8bad1b_generic_item          0          5     0.4 kB         30.424s
        jiratiny.ao_82b313_availability          0          0                    20.528s
       jiratiny.ao_8bad1b_history_entry          0        100     7.2 kB         30.673s
              jiratiny.ao_82b313_person          0        100     4.4 kB         20.668s
     jiratiny.ao_8bad1b_history_project          0        100     2.3 kB         30.665s
               jiratiny.ao_82b313_skill          0         11     0.2 kB         20.777s
         jiratiny.ao_8bad1b_item_events          0          0                    30.995s
  jiratiny.ao_85377d_switch_user_config          0          1     0.0 kB         20.947s
  jiratiny.ao_8bad1b_manual_adjustments          0         47    49.8 kB         30.997s
            jiratiny.ao_8bad1b_ordering          0          7     0.5 kB         31.637s
     jiratiny.ao_8542f1_ifj_atm_rule_ac          0          1     0.3 kB         21.117s
       jiratiny.ao_8bad1b_process_state          0          0                    31.307s
     jiratiny.ao_8542f1_ifj_atm_rule_co          0          1     0.0 kB         21.783s
                 jiratiny.ao_8bad1b_row          0        100     1.6 kB         31.661s
     jiratiny.ao_8542f1_ifj_atm_rule_ev          0          4     0.1 kB         21.963s
           jiratiny.ao_8bad1b_structure          0        100    21.0 kB         31.927s
         jiratiny.ao_8542f1_ifj_comment          0         25     4.7 kB         22.169s
   jiratiny.ao_8bad1b_structure_to_view          0        100    15.9 kB         31.967s
         jiratiny.ao_8542f1_ifj_feature          0          1     0.0 kB         22.359s
          jiratiny.ao_8bad1b_sync_event          0          0                    32.158s
     jiratiny.ao_8bad1b_s_item_property          0          4     0.1 kB         32.183s
            jiratiny.ao_8542f1_ifj_icon          0        100     5.1 kB         22.561s
   jiratiny.ao_8bad1b_view_to_structure          0        100     1.1 kB         32.368s
      jiratiny.ao_8542f1_ifj_import_cfg          0          0                    22.751s
         jiratiny.ao_923159_node_status          0          0                    32.362s
     jiratiny.ao_8542f1_ifj_import_miss          0         52     2.9 kB         23.012s
   jiratiny.ao_956e29_calendar_settings          0          0                    32.553s
      jiratiny.ao_8542f1_ifj_import_src          0         14     3.6 kB         23.238s
     jiratiny.ao_956e29_format_settings          0          1     0.0 kB         32.623s
  jiratiny.ao_8542f1_ifj_import_src_ota          0        100     8.8 kB         23.401s
    jiratiny.ao_956e29_time_in_property          0          1     0.6 kB         32.726s
             jiratiny.ao_8542f1_ifj_obj          0        100     8.4 kB         23.601s
             jiratiny.ao_96e78c_group_f          0          8     0.2 kB         32.917s
        jiratiny.ao_8542f1_ifj_obj_attr          0        100     0.9 kB         23.768s
           jiratiny.ao_96e78c_project_f          0         11     0.1 kB         33.098s
        jiratiny.ao_8542f1_ifj_obj_hist          0        100    10.9 kB         23.953s
            jiratiny.ao_96e78c_scheme_f          0         12     0.2 kB         33.135s
     jiratiny.ao_8542f1_ifj_obj_key_map          0          0                    24.128s
        jiratiny.ao_8542f1_ifj_obj_type          0        100     8.1 kB         24.449s
jiratiny.ao_a0b856_web_hook_listener_ao          0          0                    33.249s
            jiratiny.ao_a29aea_exposure          0          4     0.1 kB         33.276s
       jiratiny.ao_8542f1_ifj_obj_watch          0          1     0.0 kB         25.133s
         jiratiny.ao_a29aea_exp_mapping          0          0                    33.496s
   jiratiny.ao_8542f1_ifj_on_event_user          0          0                    25.526s
  jiratiny.ao_8542f1_ifj_on_filter_attr          0         50     1.1 kB         25.755s
        jiratiny.ao_a406ed_access_group          0          1     0.0 kB         33.561s
 jiratiny.ao_8542f1_ifj_on_filter_share          0          0                    25.922s
         jiratiny.ao_a406ed_access_user          0          0                    33.855s
      jiratiny.ao_a406ed_acc_manager_v2          0          1     0.0 kB         33.979s
      jiratiny.ao_8542f1_ifj_prg_ot_res          0        100   393.5 kB         26.431s
       jiratiny.ao_a406ed_calendar_date          0         54     2.7 kB         34.257s
               jiratiny.ao_a406ed_field          0          0                    34.316s
     jiratiny.ao_8542f1_ifj_rcf_connect          0          0                    26.310s
  jiratiny.ao_a406ed_fire_history_entry          0          0                    34.528s
        jiratiny.ao_8542f1_ifj_ref_type          0        100     2.8 kB         26.620s
     jiratiny.ao_a406ed_fire_history_v3          0        100    10.5 kB         34.887s
            jiratiny.ao_8542f1_ifj_role          0        100     8.4 kB         26.656s
         jiratiny.ao_8542f1_ifj_sd_prop          0         15     0.3 kB         26.804s
            jiratiny.ao_a406ed_param_v1          0          0                    34.992s
     jiratiny.ao_a406ed_scheduled_issue          0          0                    35.484s
            jiratiny.ao_8542f1_ifj_user          0        100     3.9 kB         26.841s
      jiratiny.ao_8542f1_ifj_widget_fav          0          0                    27.670s
       jiratiny.ao_a406ed_scheduled_job          0        100    19.7 kB         35.569s
    jiratiny.ao_8542f1_ifj_widget_share          0          0                    26.983s
        jiratiny.ao_a406ed_shared_group          0          1     0.0 kB         36.052s
        jiratiny.ao_86ed1b_grace_period          0          0                    27.625s
         jiratiny.ao_a406ed_shared_user          0          8     0.3 kB         36.495s
              jiratiny.ao_86ed1b_period          0          0                    27.952s
            jiratiny.ao_a406ed_share_si          0          0                    37.071s
      jiratiny.ao_86ed1b_project_config          0          0                    27.952s
             jiratiny.ao_a406ed_trigger          0          0                    37.033s
       jiratiny.ao_86ed1b_streams_entry          0          0                    28.227s
          jiratiny.ao_a406ed_trigger_v3          0         90     8.1 kB         37.271s
  jiratiny.ao_86ed1b_timesheet_approval          0          0                    28.176s
           jiratiny.ao_a415df_aoability          0         84     1.5 kB         37.321s
      jiratiny.ao_a415df_aoavailability          0          0                    37.590s
    jiratiny.ao_86ed1b_worklog_ext_prop          0          0                    28.379s
          jiratiny.ao_88263f_properties          0          1     0.0 kB         28.439s
    jiratiny.ao_a415df_aocustom_wording          0          0                    37.549s
         jiratiny.ao_a415df_aodoor_stop          0          1     0.0 kB         37.988s
    jiratiny.ao_8ac478_box_id_generator          0          4     0.0 kB         28.558s
    jiratiny.ao_a415df_aoextension_link          0        100    11.6 kB         37.993s
            jiratiny.ao_8ac478_box_type          0          4     0.2 kB         28.574s
        jiratiny.ao_a415df_aopermission          0        100     5.1 kB         38.244s
       jiratiny.ao_8ac478_custom_action          0          0                    29.029s
              jiratiny.ao_a415df_aoplan          0         12     0.7 kB         38.247s
       jiratiny.ao_8ac478_embedded_task          0         22     1.5 kB         28.796s
          jiratiny.ao_a415df_aopresence          0          0                    38.509s
         jiratiny.ao_8ac478_extplatform          0          2     0.1 kB         29.163s
        jiratiny.ao_a415df_aoreplanning          0          0                    38.511s
             jiratiny.ao_8ac478_extuser          0          2     0.0 kB         29.286s
             jiratiny.ao_a415df_aoskill          0         23     0.9 kB         38.820s
      jiratiny.ao_8ac478_gantt_config_2          0        100    10.8 kB         29.395s
            jiratiny.ao_a415df_aosprint          0          0                    38.806s
       jiratiny.ao_8ac478_global_link_2          0        100    10.0 kB         29.489s
            jiratiny.ao_a415df_aostream          0         13     0.6 kB         39.303s
             jiratiny.ao_8ac478_holiday          0          0                    29.574s
              jiratiny.ao_a415df_aoteam          0          7     0.5 kB         39.232s
         jiratiny.ao_a415df_aowork_item          0        100    14.7 kB         39.482s
  jiratiny.ao_8ac478_holiday_plan_entry          0          0                    29.713s
             jiratiny.ao_8ac478_program          0        100   597.2 kB         30.284s
 jiratiny.ao_a44657_health_check_entity          0          0                    39.520s
            jiratiny.ao_a83c21_pdf_view          0         15     2.1 kB         39.738s
           jiratiny.ao_aefed0_pgp_group          0          4     0.1 kB         39.759s
  jiratiny.ao_aefed0_pgp_membership_idx          0          0                    40.069s
          jiratiny.ao_8ac478_resource_2          0        100    12.1 kB         29.938s
             jiratiny.ao_aefed0_program          0          1     0.1 kB         40.136s
    jiratiny.ao_8ac478_resource_mapping          0        100     7.9 kB         30.254s
           jiratiny.ao_aefed0_team_link          0          5     0.1 kB         40.404s
         jiratiny.ao_8ac478_res_hd_plan          0        100     4.3 kB         30.342s
      jiratiny.ao_aefed0_team_member_v2          0        100     4.4 kB         40.315s
         jiratiny.ao_8ac478_res_wl_plan          0        100     4.7 kB         30.572s
           jiratiny.ao_aefed0_team_role          0         22     0.7 kB         40.611s
 jiratiny.ao_8ac478_role_assign_beta_v1          0        100     7.7 kB         30.724s
             jiratiny.ao_aefed0_team_v2          0          7     0.4 kB         40.585s
    jiratiny.ao_8ac478_schedule_v_beta4          0        100     1.6 kB         30.876s
   jiratiny.ao_b300f0_field_config_item          0          0                    41.324s
      jiratiny.ao_bee373_internal_issue          0          0                    41.356s
                jiratiny.ao_8ac478_team          0          0                    31.045s
          jiratiny.ao_8ac478_team_usage          0          0                    31.327s
          jiratiny.ao_c3c6e8_account_v1          0          0                    41.784s
          jiratiny.ao_8ac478_wbs_config          0        100    38.7 kB         31.368s
       jiratiny.ao_c3c6e8_category_type          0          4     0.2 kB         41.845s
 jiratiny.ao_c3c6e8_customer_permission          0          0                    42.055s
            jiratiny.ao_8ac478_wbs_node          0        100     5.0 kB         31.494s
             jiratiny.ao_c3c6e8_link_v1          0          0                    42.627s
  jiratiny.ao_8ac478_wbs_sub_wbs_fields          0          0                    31.597s
          jiratiny.ao_c3c6e8_rate_table          0          1     0.1 kB         42.355s
jiratiny.ao_8ac478_wbs_team_to_schedule          0          0                    31.736s
jiratiny.ao_cbc281_drawio_configuration          0          1     0.0 kB         42.824s
      jiratiny.ao_8b1069_activity_entry          0        100     7.9 kB         31.833s
      jiratiny.ao_cbc281_drawio_library          0          0                    42.935s
     jiratiny.ao_8b1069_analytics_entry          0         26     1.7 kB         31.900s
          jiratiny.ao_ce20b8_soc_config          0          0                    43.163s
     jiratiny.ao_8b1069_automated_label          0          3     0.1 kB         32.063s
      jiratiny.ao_cf468e_bar_dependency          0          0                    43.909s
jiratiny.ao_8b1069_automated_step_issue          0        100     1.3 kB         32.064s
           jiratiny.ao_cf468e_bootstrap          0          1     0.0 kB         43.807s
         jiratiny.ao_8b1069_db_provider          0          1     0.0 kB         32.251s
        jiratiny.ao_cf468e_gantt_config          0         46    55.3 kB         43.996s
                jiratiny.ao_8b1069_leaf          0        100     4.5 kB         32.283s
 jiratiny.ao_cf468e_resource_attributes          0          2     0.2 kB         44.109s
     jiratiny.ao_8b1069_pre_cond_result          0        100    23.2 kB         32.548s
jiratiny.ao_cff990_aotransition_failure          0          0                    44.225s
          jiratiny.ao_d9132d_assignment          0          0                    44.367s
   jiratiny.ao_8b1069_req_status_entity          0        100   150.6 kB         32.508s
       jiratiny.ao_d9132d_configuration          0          1     0.0 kB         44.616s
 jiratiny.ao_8b1069_test_example_result          0         36     1.2 kB         32.774s
        jiratiny.ao_d9132d_distribution          0         30     1.6 kB         44.918s
       jiratiny.ao_d9132d_genericreport          0         45   136.9 kB         45.053s
        jiratiny.ao_8b1069_test_memento          0        100    15.8 kB         32.770s
                jiratiny.ao_d9132d_init          0         17     0.5 kB         45.110s
    jiratiny.ao_8b1069_test_precon_link          0          0                    32.945s
      jiratiny.ao_d9132d_nonworkingdays          0          0                    45.284s
            jiratiny.ao_8b1069_test_run          0        100    12.3 kB         33.040s
                jiratiny.ao_d9132d_plan          0        100    16.4 kB         45.412s
jiratiny.ao_8b1069_test_run_requirement          0          0                    33.164s
            jiratiny.ao_d9132d_planteam          0        100     2.6 kB         45.541s
  jiratiny.ao_8b1069_test_set_test_link          0        100     3.9 kB         33.502s
         jiratiny.ao_d9132d_planversion          0         78     1.9 kB         45.575s
           jiratiny.ao_8b1069_test_step          0        100    15.1 kB         33.658s
    jiratiny.ao_8b1069_test_step_result          0        100     2.0 kB         33.841s
  jiratiny.ao_d9132d_plan_us_pr_mapping          0          0                    45.759s
    jiratiny.ao_8b1069_trinfo_migration          0          0                    33.946s
jiratiny.ao_d9132d_program_custom_field          0          7     0.1 kB         45.919s
          jiratiny.ao_d9132d_saved_view          0          0                    46.087s
         jiratiny.ao_8bad1b_atomic_flag          0          0                    34.187s
           jiratiny.ao_8bad1b_favorites          0        100     4.5 kB         35.052s
    jiratiny.ao_d9132d_scenario_ability          0         11     2.7 kB         46.315s
    jiratiny.ao_d9132d_scenario_changes          0        100     1.9 kB         46.586s
              jiratiny.ao_8bad1b_forest          0        100    25.7 kB         34.984s
           jiratiny.ao_8bad1b_generator          0        100    13.2 kB         35.358s
jiratiny.ao_d9132d_scenario_issue_cmpnt          0          7     0.1 kB         46.652s
jiratiny.ao_d9132d_scenario_issue_links          0         15     2.5 kB         46.939s
      jiratiny.ao_8bad1b_history_change          0        100     7.1 kB         35.350s
       jiratiny.ao_8bad1b_history_issue          0        100     2.4 kB         35.633s
     jiratiny.ao_d9132d_scenario_person          0         34     5.7 kB         47.030s
      jiratiny.ao_d9132d_scenario_skill          0         20     3.6 kB         47.217s
         jiratiny.ao_8bad1b_issue_index          0        100     1.9 kB         35.599s
       jiratiny.ao_d9132d_scenario_team          0         53     7.9 kB         47.409s
           jiratiny.ao_8bad1b_item_type          0         26     1.1 kB         35.992s
          jiratiny.ao_8bad1b_node_signs          0          0                    36.025s
         jiratiny.ao_8bad1b_perspective          0         24    77.1 kB         36.914s
    jiratiny.ao_d9132d_scenario_version          0        100    22.8 kB         47.583s
            jiratiny.ao_8bad1b_property          0         13     0.6 kB         36.405s
  jiratiny.ao_d9132d_scen_cstm_fld_mval          0          0                    47.756s
 jiratiny.ao_d9132d_scen_team_ex_sprint          0          2     0.0 kB         47.997s
          jiratiny.ao_8bad1b_statistics          0        100     6.1 kB         36.666s
            jiratiny.ao_d9132d_solution          0        100   858.4 kB         48.947s
  jiratiny.ao_8bad1b_structure_property          0        100    17.2 kB         36.973s
   jiratiny.ao_8bad1b_sync_audit_record          0          0                    37.157s
       jiratiny.ao_8bad1b_sync_instance          0          9     1.7 kB         37.235s
                jiratiny.ao_8bad1b_view          0        100   114.4 kB         37.458s
    jiratiny.ao_923159_computer_account          0          0                    37.586s
      jiratiny.ao_d9132d_team_ex_sprint          0          2     0.0 kB         48.261s
  jiratiny.ao_d9132d_version_enrichment          0         91     1.1 kB         48.524s
         jiratiny.ao_923159_samlidcache          0          0                    37.732s
jiratiny.ao_956e29_export_building_info          0         19     6.2 kB         37.846s
        jiratiny.ao_da6ab9_app_property          0          1     0.0 kB         48.794s
         jiratiny.ao_da6ab9_context_key          0          6     0.1 kB         49.245s
     jiratiny.ao_956e29_report_settings          0         83    60.7 kB         38.112s
            jiratiny.ao_da6ab9_template          0         10     2.0 kB         49.665s
         jiratiny.ao_96e78c_allowparent          0          0                    38.304s
         jiratiny.ao_db6376_wd_calendar          0          4     0.1 kB         49.821s
           jiratiny.ao_96e78c_issuetype          0         80     1.0 kB         38.458s
 jiratiny.ao_db6376_wd_calendar_day_off          0          0                    50.134s
              jiratiny.ao_96e78c_role_f          0         12     0.2 kB         38.662s
   jiratiny.ao_e24dea_timesheet_job_cfg          0         10     1.7 kB         50.434s
      jiratiny.ao_97edab_userinvitation          0          7     1.0 kB         38.734s
    jiratiny.ao_e30806_available_scheme          0          0                    50.408s
              jiratiny.ao_a29aea_config          0         26     0.7 kB         38.900s
        jiratiny.ao_e30806_bundle_issue          0         59     0.9 kB         50.622s
    jiratiny.ao_a29aea_exposure_mapping          0         25     0.4 kB         38.982s
        jiratiny.ao_e30806_custom_field          0          0                    50.706s
       jiratiny.ao_a29aea_risk_register          0        100     0.9 kB         39.164s
          jiratiny.ao_e30806_field_info          0          0                    50.819s
         jiratiny.ao_a406ed_access_role          0          1     0.0 kB         39.408s
           jiratiny.ao_e30806_lock_info          0          0                    50.920s
         jiratiny.ao_a406ed_acc_manager          0          0                    39.512s
             jiratiny.ao_e30806_project          0          0                    51.166s
            jiratiny.ao_a406ed_calendar          0         31     1.1 kB         39.599s
 jiratiny.ao_e30806_specific_permission          0         71     2.0 kB         51.233s
       jiratiny.ao_a406ed_created_issue          0        100     1.3 kB         39.702s
             jiratiny.ao_e30806_tracker          0          9     0.1 kB         51.439s
            jiratiny.ao_a406ed_field_v2          0        100     7.9 kB         39.807s
              jiratiny.ao_e8b6cc_branch          0         24     0.3 kB         51.391s
     jiratiny.ao_a406ed_fire_history_v2          0        100    10.2 kB         40.043s
   jiratiny.ao_e8b6cc_changeset_mapping          0        100   318.3 kB         53.033s
               jiratiny.ao_a406ed_param          0          0                    40.178s
            jiratiny.ao_a406ed_param_v2          0        100     4.0 kB         40.848s
       jiratiny.ao_e8b6cc_git_hub_event          0        100     3.3 kB         51.754s
  jiratiny.ao_e8b6cc_issue_to_changeset          0        100     2.1 kB         52.144s
  jiratiny.ao_a406ed_scheduled_issue_v2          0         96     3.0 kB         41.277s
   jiratiny.ao_a406ed_scheduled_subtask          0          4     0.1 kB         41.427s
  jiratiny.ao_e8b6cc_message_queue_item          0          0                    52.875s
         jiratiny.ao_a406ed_shared_role          0         46     0.5 kB         41.552s
jiratiny.ao_e8b6cc_organization_mapping          0          3     0.5 kB         53.181s
           jiratiny.ao_a406ed_share_job          0         58     0.6 kB         41.675s
        jiratiny.ao_e8b6cc_pr_issue_key          0          0                    53.273s
        jiratiny.ao_e8b6cc_pr_to_commit          0          5     0.0 kB         53.574s
  jiratiny.ao_e8b6cc_repository_mapping          0          5     0.4 kB         53.637s
          jiratiny.ao_a406ed_si_subtask          0          3     0.0 kB         41.883s
     jiratiny.ao_e8b6cc_repo_to_project          0          0                    53.879s
          jiratiny.ao_a406ed_trigger_v2          0          0                    42.089s
          jiratiny.ao_e8b6cc_sync_event          0          0                    53.911s
          jiratiny.ao_a406ed_trigger_v4          0         98     8.7 kB         42.344s
      jiratiny.ao_f1b27b_history_record          0          0                    54.665s
           jiratiny.ao_a415df_aoabsence          0          0                    42.291s
    jiratiny.ao_f1b27b_key_comp_history          0          0                    54.936s
     jiratiny.ao_a415df_aoconfiguration          0          1     0.0 kB         42.562s
     jiratiny.ao_f1b27b_promise_history          0          0                    54.955s
        jiratiny.ao_a415df_aodependency          0          0                    43.024s
           jiratiny.audit_changed_value          0        100     4.0 kB         55.174s
          jiratiny.ao_a415df_aoestimate          0        100     2.8 kB         43.223s
                     jiratiny.audit_log          0        100    30.9 kB         55.274s
  jiratiny.ao_a415df_aonon_working_days          0          0                    43.247s
            jiratiny.ao_a415df_aoperson          0         26     1.2 kB         43.402s
                         jiratiny.board          0          0                    55.555s
jiratiny.ao_a415df_aoplan_configuration          0         12     1.4 kB         43.668s
                        jiratiny.ccb_d3          0          3     0.2 kB         55.510s
                    jiratiny.changeitem          0        100     7.8 kB         55.891s
           jiratiny.ao_a415df_aorelease          0         25     1.7 kB         43.604s
             jiratiny.clusterlockstatus          0          0                    55.762s
          jiratiny.ao_a415df_aoresource          0         27     0.6 kB         44.014s
    jiratiny.ao_a415df_aosolution_store          0         11   421.8 kB         44.491s
                   jiratiny.clusternode          0          0                    56.011s
           jiratiny.clusterupgradestate          0          0                    56.676s
              jiratiny.columnlayoutitem          0        100     2.3 kB         56.894s
             jiratiny.ao_a415df_aostage          0         26     1.1 kB         44.369s
          jiratiny.configurationcontext          0        100     3.6 kB         57.052s
    jiratiny.ao_a415df_aostream_to_team          0          0                    44.616s
             jiratiny.customfieldoption          0        100     4.1 kB         57.364s
             jiratiny.ao_a415df_aotheme          0         23     1.6 kB         44.706s
               jiratiny.cwd_application          0          7     1.0 kB         58.028s
  jiratiny.ao_a415df_aowork_item_to_res          0          0                    44.989s
                 jiratiny.cwd_directory          0          1     0.2 kB         58.252s
        jiratiny.ao_a83c21_pdf_resource          0         29   465.5 kB         45.368s
       jiratiny.cwd_directory_operation          0         12     0.2 kB         58.508s
          jiratiny.cwd_group_attributes          0          0                    58.820s
          jiratiny.ao_aefed0_membership          0        100     1.9 kB         45.399s
                      jiratiny.cwd_user          0        100    32.9 kB         59.162s
          jiratiny.ao_aefed0_pgp_member          0          1     0.0 kB         45.644s
                    jiratiny.deadletter          0          0                    59.134s
      jiratiny.ao_aefed0_pgp_permission          0         58     2.9 kB         45.638s
     jiratiny.draftworkflowschemeentity          0         30     1.4 kB         59.746s
jiratiny.entity_property_index_document          0          5     2.7 kB         59.731s
                jiratiny.ao_aefed0_team          0          1     0.0 kB         46.173s
                jiratiny.externalgadget          0          3     0.4 kB        1m0.130s
         jiratiny.ao_aefed0_team_member          0          2     0.1 kB         45.880s
         jiratiny.favouriteassociations          0        100     5.5 kB        1m0.155s
     jiratiny.ao_aefed0_team_permission          0          1     0.1 kB         46.280s
      jiratiny.ao_aefed0_team_to_member          0          2     0.0 kB         46.782s
             jiratiny.fieldconfigscheme          0        100    13.5 kB        1m0.648s
          jiratiny.ao_aefed0_user_index          0        100    19.3 kB         46.682s
            jiratiny.fieldconfiguration          0        100     9.9 kB        1m0.644s
               jiratiny.fieldlayoutitem          0        100     8.5 kB        1m0.814s
    jiratiny.ao_b9a0f0_applied_template          0        100    14.1 kB         46.998s
  jiratiny.fieldlayoutschemeassociation          0          0                   1m0.806s
            jiratiny.ao_c16815_alert_ao          0        100     3.3 MB         51.258s
                   jiratiny.fieldscreen          0        100     5.4 kB        1m1.084s
             jiratiny.fieldscreenscheme          0        100     4.6 kB        1m1.115s
                jiratiny.fieldscreentab          0        100     2.7 kB        1m1.222s
            jiratiny.filtersubscription          0        100     7.4 kB        1m1.190s
          jiratiny.genericconfiguration          0        100    17.0 kB        1m1.538s
                     jiratiny.groupbase          0          0                   1m1.409s
                 jiratiny.issuelinktype          0         34     2.0 kB        1m1.770s
                   jiratiny.issuestatus          0        100     9.2 kB        1m1.779s
         jiratiny.issuetypescreenscheme          0        100     5.4 kB        1m2.127s
            jiratiny.issue_field_option          0          0                   1m2.000s
                    jiratiny.jiraaction          0        100    23.5 kB        1m2.245s
              jiratiny.ao_c3c6e8_budget          0          0                    47.165s
                 jiratiny.jiraeventtype          0         52     3.5 kB        1m2.355s
                     jiratiny.jiraperms          0          0                   1m2.422s
         jiratiny.ao_c3c6e8_category_v1          0          0                    47.588s
          jiratiny.jiraworkflowstatuses          0          0                   1m2.541s
         jiratiny.ao_c3c6e8_customer_v1          0          0                    47.817s
                jiratiny.ao_c3c6e8_rate          0          1     0.0 kB         48.038s
             jiratiny.jquartz_calendars          0          0                   1m2.737s
   jiratiny.ao_cbc281_def_lib_for_group          0          0                    48.170s
        jiratiny.jquartz_fired_triggers          0          0                   1m2.749s
        jiratiny.ao_cbc281_drawio_draft          0         22   115.5 kB         49.058s
         jiratiny.jquartz_job_listeners          0          0                   1m3.033s
   jiratiny.ao_ce20b8_pcf_ugppro_config          0          0                    49.492s
   jiratiny.jquartz_paused_trigger_grps          0          0                   1m3.034s
      jiratiny.ao_cf468e_bar_attributes          0         65     5.9 kB         49.765s
       jiratiny.jquartz_simple_triggers          0          6     0.7 kB        1m3.330s
            jiratiny.ao_cf468e_baseline          0          2   216.0 kB         50.164s
              jiratiny.jquartz_triggers          0         44    57.1 kB        1m3.328s
                   jiratiny.kissuestate          0          0                   1m3.659s
                   jiratiny.kpluginscfg          0         29     2.4 kB        1m3.689s
               jiratiny.ao_cf468e_gantt          0         89    14.5 kB         50.468s
                 jiratiny.krunnablesils          0          0                   1m3.898s
       jiratiny.ao_cf468e_leveling_data          0          8     0.5 kB         50.712s
                         jiratiny.label          0        100     2.1 kB        1m4.008s
       jiratiny.ao_cf468e_work_calendar          0          2     0.6 kB         51.057s
             jiratiny.licenserolesgroup          0          7     0.3 kB        1m4.306s
  jiratiny.ao_d53e8e_jcpp_global_config          0          0                    51.261s
                    jiratiny.mailserver          0          1     0.1 kB        1m4.650s
      jiratiny.ao_d9132d_assignment_ext          0        100     9.7 kB         51.288s
                jiratiny.membershipbase          0          0                   1m4.706s
jiratiny.ao_d9132d_dep_issue_link_types          0         22     0.2 kB         52.064s
               jiratiny.nodeassociation          0        100     5.3 kB        1m4.928s
   jiratiny.ao_d9132d_excluded_versions          0        100     1.3 kB         52.228s
                  jiratiny.notification          0        100     3.8 kB        1m5.041s
    jiratiny.ao_d9132d_hierarchy_config          0          6     0.2 kB         52.388s
            jiratiny.notificationscheme          0         42     2.6 kB        1m5.190s
        jiratiny.ao_d9132d_issue_source          0        100     2.1 kB         52.539s
            jiratiny.oauthconsumertoken          0        100    15.1 kB        1m5.229s
         jiratiny.ao_d9132d_permissions          0        100     4.2 kB         52.675s
                  jiratiny.oauthsptoken          0        100    27.5 kB        1m5.555s
           jiratiny.ao_d9132d_planskill          0          4     0.1 kB         52.955s
                jiratiny.os_currentstep          0        100     5.0 kB        1m5.448s
                jiratiny.os_historystep          0        100     9.0 kB        1m5.793s
           jiratiny.ao_d9132d_plantheme          0         22     0.4 kB         52.998s
                    jiratiny.os_wfentry          0        100     2.0 kB        1m5.932s
   jiratiny.ao_d9132d_plan_custom_field          0         27     0.6 kB         53.425s
     jiratiny.permissionschemeattribute          0          2     0.1 kB        1m6.059s
             jiratiny.ao_d9132d_program          0         15     0.9 kB         53.244s
           jiratiny.ao_d9132d_rank_item          0        100     9.9 kB         53.918s
                 jiratiny.pluginversion          0        100    10.0 kB        1m6.153s
          jiratiny.portletconfiguration          0        100    13.1 kB        1m6.424s
            jiratiny.ao_d9132d_scenario          0        100     2.0 kB         53.911s
                jiratiny.productlicense          0          2     1.2 kB        1m6.459s
    jiratiny.ao_d9132d_scenario_avlblty          0          0                    54.249s
               jiratiny.projectcategory          0         27     1.4 kB        1m6.613s
     jiratiny.ao_d9132d_scenario_issues          0        100    26.1 kB         54.529s
                   jiratiny.projectrole          0         14     1.5 kB        1m6.575s
jiratiny.ao_d9132d_scenario_issue_label          0          0                    54.426s
                jiratiny.projectversion          0        100    10.0 kB        1m6.855s
  jiratiny.ao_d9132d_scenario_issue_res          0        100     4.3 kB         54.855s
                  jiratiny.propertydata          0          0                   1m6.934s
   jiratiny.ao_d9132d_scenario_resource          0        100    18.5 kB         54.870s
               jiratiny.propertydecimal          0          0                   1m7.069s
                jiratiny.propertynumber          0        100     0.9 kB        1m7.137s
      jiratiny.ao_d9132d_scenario_stage          0         10     1.6 kB         55.189s
                  jiratiny.propertytext          0        100    27.2 kB        1m7.310s
      jiratiny.ao_d9132d_scenario_theme          0         18     2.9 kB         55.246s
            jiratiny.qrtz_cron_triggers          0         18     0.5 kB        1m7.270s
  jiratiny.ao_d9132d_scenario_xpversion          0          9     1.4 kB         55.594s
   jiratiny.ao_d9132d_scen_custom_field          0          0                    55.863s
              jiratiny.qrtz_job_details          0          1     0.1 kB        1m7.494s
          jiratiny.qrtz_simple_triggers          0          0                   1m7.514s
        jiratiny.qrtz_trigger_listeners          0          0                   1m7.742s
               jiratiny.reindex_request          0          9     0.7 kB        1m7.679s
       jiratiny.ao_d9132d_shared_report          0          9     2.0 kB         56.105s
                    jiratiny.remotelink          0        100    19.9 kB        1m8.043s
               jiratiny.ao_d9132d_stage          0          6     0.1 kB         56.234s
                    jiratiny.resolution          0         34     1.4 kB        1m8.214s
         jiratiny.schemeissuesecurities          0        100     4.1 kB        1m8.469s
               jiratiny.ao_d9132d_theme          0         22     0.4 kB         56.532s
   jiratiny.ao_d9132d_x_project_version          0          7     0.1 kB         56.700s
             jiratiny.schemepermissions          0        100     5.8 kB        1m8.480s
               jiratiny.ao_da6ab9_audit          0          0                    57.319s
   jiratiny.ao_da6ab9_statistics_record          0          0                    57.710s
           jiratiny.sequence_value_item          0        100     2.2 kB        1m8.580s
          jiratiny.ao_da6ab9_templateck          0         10     0.1 kB         57.648s
              jiratiny.sharepermissions          0        100     4.4 kB        1m8.652s
     jiratiny.ao_db6376_wd_calendar_day          0         28     0.6 kB         58.360s
                jiratiny.trackback_ping          0          0                   1m8.727s
             jiratiny.ao_e24dea_holiday          0          0                    58.230s
                jiratiny.upgradehistory          0        100     7.5 kB        1m8.844s
      jiratiny.ao_e24dea_timesheet_pref          0         13     0.6 kB         58.721s
    jiratiny.upgradetaskhistoryauditlog          0         39     2.8 kB        1m8.884s
               jiratiny.userassociation          0        100     5.5 kB        1m8.980s
           jiratiny.ao_e30806_bundlestr          0         12     0.3 kB         59.056s
               jiratiny.userhistoryitem          0        100     7.1 kB        1m9.083s
          jiratiny.ao_e30806_bundle_map          0         57     5.1 kB         59.292s
         jiratiny.userpickerfiltergroup          0          8     0.2 kB        1m9.137s
    jiratiny.ao_e30806_delegation_group          0          0                    59.776s
                jiratiny.versioncontrol          0          0                   1m9.267s
 jiratiny.ao_e30806_general_config_info          0          0                    59.857s
                jiratiny.workflowscheme          0        100     8.1 kB        1m9.381s
          jiratiny.ao_e30806_permission          0          0                   1m0.020s
       jiratiny.ao_e30806_project_audit          0          0                   1m0.055s
                       jiratiny.worklog          0        100    14.6 kB        1m9.574s
      jiratiny.ao_e30806_stop_proj_info          0          0                   1m0.187s
         jiratiny.ao_e30806_undo_entity          0        100    13.6 kB        1m0.280s
 jiratiny.ao_e8b6cc_branch_head_mapping          0         24     1.3 kB        1m0.381s
              jiratiny.ao_e8b6cc_commit          0          5     0.5 kB        1m0.482s
     jiratiny.ao_e8b6cc_issue_to_branch          0          0                   1m0.567s
             jiratiny.ao_e8b6cc_message          0          0                   1m0.759s
         jiratiny.ao_e8b6cc_message_tag          0          0                   1m0.795s
      jiratiny.ao_e8b6cc_org_to_project          0          0                   1m1.052s
      jiratiny.ao_e8b6cc_pr_participant          0          3     0.1 kB        1m1.185s
        jiratiny.ao_e8b6cc_pull_request          0          3     0.5 kB        1m1.378s
   jiratiny.ao_e8b6cc_repo_to_changeset          0        100     0.8 kB        1m1.422s
      jiratiny.ao_e8b6cc_sync_audit_log          0        100     9.4 kB        1m1.643s
     jiratiny.ao_ed669c_seen_assertions          0          0                   1m1.693s
       jiratiny.ao_f1b27b_key_component          0          0                   1m1.852s
             jiratiny.ao_f1b27b_promise          0          0                   1m1.970s
                      jiratiny.app_user          0        100     2.2 kB        1m2.120s
                    jiratiny.audit_item          0        100    10.1 kB        1m2.314s
                        jiratiny.avatar          0        100     4.8 kB        1m2.541s
                  jiratiny.boardproject          0          0                   1m2.631s
                   jiratiny.changegroup          0        100     3.8 kB        1m2.902s
                  jiratiny.clusteredjob          0        100    93.3 kB        1m3.097s
                jiratiny.clustermessage          0          0                   1m3.290s
          jiratiny.clusternodeheartbeat          0          0                   1m3.326s
                  jiratiny.columnlayout          0        100     2.4 kB        1m3.576s
                     jiratiny.component          0        100     6.6 kB        1m3.587s
                   jiratiny.customfield          0        100    19.6 kB        1m4.026s
              jiratiny.customfieldvalue          0        100     6.1 kB        1m4.158s
       jiratiny.cwd_application_address          0         20     0.4 kB        1m4.308s
       jiratiny.cwd_directory_attribute          0          2     0.1 kB        1m4.427s
                     jiratiny.cwd_group          0        100    11.1 kB        1m4.513s
                jiratiny.cwd_membership          0        100    13.3 kB        1m4.658s
           jiratiny.cwd_user_attributes          0        100     5.8 kB        1m5.110s
           jiratiny.draftworkflowscheme          0          6     0.4 kB        1m4.805s
               jiratiny.entity_property          0        100     9.9 kB        1m5.083s
            jiratiny.entity_translation          0          0                   1m5.313s
             jiratiny.external_entities          0        100     6.0 kB        1m5.337s
                       jiratiny.feature          0         28     2.1 kB        1m5.556s
    jiratiny.fieldconfigschemeissuetype          0        100     2.0 kB        1m5.610s
                   jiratiny.fieldlayout          0        100     7.0 kB        1m5.888s
             jiratiny.fieldlayoutscheme          0        100     5.2 kB        1m5.823s
       jiratiny.fieldlayoutschemeentity          0        100     2.1 kB        1m6.099s
         jiratiny.fieldscreenlayoutitem          0        100     2.6 kB        1m5.976s
         jiratiny.fieldscreenschemeitem          0        100     2.0 kB        1m6.244s
                jiratiny.fileattachment          0        100    11.8 kB        1m6.346s
          jiratiny.gadgetuserpreference          0        100     2.8 kB        1m6.426s
         jiratiny.globalpermissionentry          0         63     3.4 kB        1m6.552s
                     jiratiny.issuelink          0        100     2.6 kB        1m6.638s
           jiratiny.issuesecurityscheme          0         19     0.9 kB        1m6.809s
                     jiratiny.issuetype          0        100    10.6 kB        1m6.827s
   jiratiny.issuetypescreenschemeentity          0        100     2.0 kB        1m7.003s
      jiratiny.issue_field_option_scope          0          0                   1m7.002s
            jiratiny.jiradraftworkflows          0        100     1.6 MB        1m8.349s
                     jiratiny.jiraissue          0        100    29.6 kB        1m7.090s
                 jiratiny.jiraworkflows          0        100     1.8 MB        1m8.610s
         jiratiny.jquartz_blob_triggers          0          0                   1m8.361s
         jiratiny.jquartz_cron_triggers          0         38     4.7 kB        1m8.528s
           jiratiny.jquartz_job_details          0          8     5.6 kB        1m8.746s
                 jiratiny.jquartz_locks          0          5     0.1 kB        1m8.744s
       jiratiny.jquartz_scheduler_state          0          0                   1m8.865s
      jiratiny.jquartz_simprop_triggers          0          0                   1m8.916s
     jiratiny.jquartz_trigger_listeners          0          0                   1m8.815s
                      jiratiny.kplugins          0          2     0.0 kB        1m9.018s
                   jiratiny.krssecurity          0          0                   1m9.017s
                  jiratiny.kstatevalues          0          0                   1m9.059s
           jiratiny.licenserolesdefault          0          1     0.0 kB        1m9.162s
                jiratiny.listenerconfig          0          3     0.3 kB        1m9.221s
      jiratiny.managedconfigurationitem          0         42     5.9 kB        1m9.167s
               jiratiny.moved_issue_key          0        100     2.2 kB        1m9.185s
              jiratiny.nodeindexcounter          0          0                   1m9.300s
          jiratiny.notificationinstance          0          0                   1m9.308s
                 jiratiny.oauthconsumer          0          1     1.2 kB        1m9.372s
               jiratiny.oauthspconsumer          0         12     3.8 kB        1m9.370s
           jiratiny.optionconfiguration          0        100     2.6 kB        1m9.980s
           jiratiny.os_currentstep_prev          0        100     1.2 kB        1m9.525s
           jiratiny.os_historystep_prev          0        100     1.2 kB        1m9.568s
              jiratiny.permissionscheme          0         76     8.2 kB        1m9.883s
                   jiratiny.pluginstate          0         59     2.6 kB        1m9.913s
                    jiratiny.portalpage          0        100     7.9 kB        1m9.916s
                      jiratiny.priority          0         32     2.8 kB       1m10.038s
                       jiratiny.project          0        100    12.0 kB       1m10.049s
            jiratiny.projectchangedtime          0          0                  1m10.077s
              jiratiny.projectroleactor          0        100     6.9 kB       1m10.017s
                   jiratiny.project_key          0        100     1.8 kB       1m10.209s
                  jiratiny.propertydate          0          1     0.0 kB       1m10.216s
                 jiratiny.propertyentry          0        100     5.5 kB       1m10.240s
                jiratiny.propertystring          0        100     3.0 kB       1m10.274s
                jiratiny.qrtz_calendars          0          0                  1m10.327s
           jiratiny.qrtz_fired_triggers          0          0                  1m10.413s
            jiratiny.qrtz_job_listeners          0          0                  1m10.404s
                 jiratiny.qrtz_triggers          0         18     1.9 kB       1m10.485s
             jiratiny.reindex_component          0         18     0.5 kB       1m10.562s
               jiratiny.remembermetoken          0        100     9.7 kB       1m10.626s
      jiratiny.replicatedindexoperation          0          0                  1m10.568s
                    jiratiny.rundetails          0        100     8.8 kB       1m10.695s
     jiratiny.schemeissuesecuritylevels          0         60     2.1 kB       1m10.747s
                 jiratiny.searchrequest          0        100    22.3 kB       1m10.774s
                 jiratiny.serviceconfig          0          2     0.2 kB       1m10.830s
        jiratiny.tempattachmentsmonitor          0          8     1.1 kB       1m10.877s
                    jiratiny.trustedapp          0          0                  1m10.987s
            jiratiny.upgradetaskhistory          0         36     1.7 kB       1m10.993s
         jiratiny.upgradeversionhistory          0         10     0.4 kB       1m11.076s
                      jiratiny.userbase          0          0                  1m11.086s
              jiratiny.userpickerfilter          0          6     0.1 kB       1m11.252s
          jiratiny.userpickerfilterrole          0          1     0.0 kB       1m11.168s
                   jiratiny.votehistory          0        100     3.3 kB       1m11.243s
          jiratiny.workflowschemeentity          0        100     3.2 kB       1m11.525s
---------------------------------------  ---------  ---------  ---------  --------------
                COPY Threads Completion          0          4                  1m17.716s
                         Create Indexes          0       2198                  2m58.550s
                 Index Build Completion          0       2198                     0.235s
                        Reset Sequences          0        759                     0.382s
                           Primary Keys          0        966                     2.301s
                    Create Foreign Keys         50        273                     1.004s
                        Create Triggers          0          0                     0.001s
                        Set Search Path          0          1                     0.003s
                       Install Comments          0          0                     0.000s
---------------------------------------  ---------  ---------  ---------  --------------
                      Total import time          ✓      35690    54.2 MB       4m20.192s
       96.31 real       107.85 user        12.56 sys

jira MySQL data

No foreign key failure.

dimitri commented 4 years ago

Hi @asifiqbal ; can you investigate your source database to see if you have the same data error as Postgres is complaining about with your foreign keys? It might just be that the data are missing on the source database and your source database is not complaining about it...

asifiqbal commented 4 years ago

grep ERROR mysqld.log | grep foreign did not give me anything. Any suggestions on how to inspect this?

asifiqbal commented 4 years ago

I also noticed all the tables on PostgreSQL is in lowercase. In MySQL they are mixed cases, so some tables are uppercase and some are lowercase.

asifiqbal commented 4 years ago

Here is an example table which is upper case in MySQL and lowercase in PostgreSQL and having foreign key issue.

2020-06-06T18:57:03.375000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_d9132d_scenario_team" violates foreign key constraint "fk_ao_d9132d_scenario_team_scenario_id"

mysql> show create table AO_D9132D_SCENARIO_TEAM \G
*************************** 1. row ***************************
       Table: AO_D9132D_SCENARIO_TEAM
Create Table: CREATE TABLE `AO_D9132D_SCENARIO_TEAM` (
  `ADD_TO_PLAN` tinyint(1) DEFAULT NULL,
  `AVATAR` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `AVATAR_CHANGED` tinyint(1) DEFAULT NULL,
  `C_KEY` varchar(255) COLLATE utf8_bin NOT NULL,
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `ISSUE_SOURCE_CHANGED` tinyint(1) DEFAULT NULL,
  `ISSUE_SOURCE_ID` bigint(20) DEFAULT NULL,
  `ITEM_KEY` varchar(255) COLLATE utf8_bin NOT NULL,
  `ITERATION_LENGTH` bigint(20) DEFAULT NULL,
  `ITERATION_LENGTH_CHANGED` tinyint(1) DEFAULT NULL,
  `LAST_CHANGE_TIMESTAMP` bigint(20) DEFAULT NULL,
  `LAST_CHANGE_USER` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `SCENARIO_ID` bigint(20) DEFAULT NULL,
  `SCENARIO_TYPE` varchar(255) COLLATE utf8_bin NOT NULL,
  `SCHEDULING_MODE` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `SCHEDULING_MODE_CHANGED` tinyint(1) DEFAULT NULL,
  `TITLE` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TITLE_CHANGED` tinyint(1) DEFAULT NULL,
  `VELOCITY` double DEFAULT NULL,
  `VELOCITY_CHANGED` tinyint(1) DEFAULT NULL,
  `WEEKLY_HOURS` double DEFAULT NULL,
  `WEEKLY_HOURS_CHANGED` tinyint(1) DEFAULT NULL,
  `EXCLUDED_SPRINTS_CHANGED` tinyint(1) DEFAULT NULL,
  `CAPACITY_MEASUREMENT_CHANGED` tinyint(1) DEFAULT NULL,
  `CAPACITY_MEASUREMENT` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `U_AO_D9132D_SCENARI1025062113` (`C_KEY`),
  KEY `index_ao_d9132d_sce410924660` (`ISSUE_SOURCE_ID`),
  KEY `index_ao_d9132d_sce838588485` (`SCENARIO_ID`),
  KEY `index_ao_d9132d_sce1569966108` (`SCENARIO_TYPE`),
  KEY `index_ao_d9132d_sce434778360` (`ITEM_KEY`),
  CONSTRAINT `fk_ao_d9132d_scenario_team_issue_source_id` FOREIGN KEY (`ISSUE_SOURCE_ID`) REFERENCES `AO_D9132D_ISSUE_SOURCE` (`ID`),
  CONSTRAINT `fk_ao_d9132d_scenario_team_scenario_id` FOREIGN KEY (`SCENARIO_ID`) REFERENCES `AO_D9132D_SCENARIO` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=utf8 COLLATE=utf8_bin
1 row in set (0.00 sec)
jiratiny=# \d jiratiny.ao_d9132d_scenario_team ;
                                              Table "jiratiny.ao_d9132d_scenario_team"
            Column            |          Type          | Collation | Nullable |                       Default
------------------------------+------------------------+-----------+----------+-----------------------------------------------------
 add_to_plan                  | boolean                |           |          |
 avatar                       | character varying(255) |           |          |
 avatar_changed               | boolean                |           |          |
 c_key                        | character varying(255) |           | not null |
 id                           | bigint                 |           | not null | nextval('ao_d9132d_scenario_team_id_seq'::regclass)
 issue_source_changed         | boolean                |           |          |
 issue_source_id              | bigint                 |           |          |
 item_key                     | character varying(255) |           | not null |
 iteration_length             | bigint                 |           |          |
 iteration_length_changed     | boolean                |           |          |
 last_change_timestamp        | bigint                 |           |          |
 last_change_user             | character varying(255) |           |          |
 scenario_id                  | bigint                 |           |          |
 scenario_type                | character varying(255) |           | not null |
 scheduling_mode              | character varying(255) |           |          |
 scheduling_mode_changed      | boolean                |           |          |
 title                        | character varying(255) |           |          |
 title_changed                | boolean                |           |          |
 velocity                     | double precision       |           |          |
 velocity_changed             | boolean                |           |          |
 weekly_hours                 | double precision       |           |          |
 weekly_hours_changed         | boolean                |           |          |
 excluded_sprints_changed     | boolean                |           |          |
 capacity_measurement_changed | boolean                |           |          |
 capacity_measurement         | character varying(255) |           |          |
Indexes:
    "idx_479409_primary" PRIMARY KEY, btree (id)
    "idx_479409_u_ao_d9132d_scenari1025062113" UNIQUE, btree (c_key)
    "idx_479409_index_ao_d9132d_sce1569966108" btree (scenario_type)
    "idx_479409_index_ao_d9132d_sce410924660" btree (issue_source_id)
    "idx_479409_index_ao_d9132d_sce434778360" btree (item_key)
    "idx_479409_index_ao_d9132d_sce838588485" btree (scenario_id)
Referenced by:
    TABLE "ao_d9132d_scen_team_ex_sprint" CONSTRAINT "fk_ao_d9132d_scen_team_ex_sprint_scenario_team_id" FOREIGN KEY (scenario_team_id) REFERENCES ao_d9132d_scenario_team(id) ON UPDATE RESTRICT ON DELETE RESTRICT

(END)
asifiqbal commented 4 years ago

Here is the reference table AO_D9132D_SCENARIO of the foreign key fk_ao_d9132d_scenario_team_scenario_id

mysql> show create table AO_D9132D_SCENARIO \G
*************************** 1. row ***************************
       Table: AO_D9132D_SCENARIO
Create Table: CREATE TABLE `AO_D9132D_SCENARIO` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `PLAN_ID` bigint(20) DEFAULT NULL,
  `COLOR` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TITLE` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `MASTER` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `index_ao_d9132d_sce1223631444` (`PLAN_ID`),
  CONSTRAINT `fk_ao_d9132d_scenario_plan_id` FOREIGN KEY (`PLAN_ID`) REFERENCES `AO_D9132D_PLAN` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=184 DEFAULT CHARSET=utf8 COLLATE=utf8_bin
1 row in set (0.01 sec)
asifiqbal commented 4 years ago

Here is the reference table AO_D9132D_PLAN

mysql> show create table AO_D9132D_PLAN \G
*************************** 1. row ***************************
       Table: AO_D9132D_PLAN
Create Table: CREATE TABLE `AO_D9132D_PLAN` (
  `ASSIGNEE_SCHEDULING_LEVEL` bigint(20) DEFAULT '0',
  `DEFAULT_TEAM_WEEKLY_CAPACITY` double DEFAULT '0',
  `DEF_EST_MAP` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `GLOBAL_DEFAULT_VELOCITY` double DEFAULT '0',
  `GLOBAL_SPRINT_LENGTH` int(11) DEFAULT '0',
  `HAS_SPRINT_CONSTRAINT` int(11) DEFAULT '0',
  `HEURISTIC_THRESHOLD` int(11) DEFAULT '0',
  `HOURS_PER_DAY` double DEFAULT '0',
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `MAX_RESOURCES_PER_STORY` bigint(20) DEFAULT '0',
  `MIN_LOAD_UNSTR_EPICS` bigint(20) DEFAULT '0',
  `PLANNING_UNIT` bigint(20) DEFAULT NULL,
  `SCHEDULING_VERBOSITY` bigint(20) DEFAULT '0',
  `SPRINT_EXCEEDED_WARN` int(11) DEFAULT '0',
  `STRICT_STAGE_DIVISION` int(11) DEFAULT '0',
  `SYNC_START_ENABLED` int(11) DEFAULT '0',
  `TITLE` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `WEEKDAY_CONFIGURATION` int(11) DEFAULT '0',
  `COMMIT_ISSUE_ASSIGNEE` int(11) DEFAULT NULL,
  `DEPENDENCY_MODE` bigint(20) DEFAULT NULL,
  `DEFAULT_ESTIMATES` longtext COLLATE utf8_bin,
  `UNESTIMATED_ISSUES_OPTION` bigint(20) DEFAULT '0',
  `PROGRAM_ID` bigint(20) DEFAULT NULL,
  `MULTI_SCENARIO_ENABLED` int(11) DEFAULT NULL,
  `TIME_ZONE` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `SCHEDULING_END_CUSTOM_FIELD` bigint(20) DEFAULT NULL,
  `SCHEDULING_START_CUSTOM_FIELD` bigint(20) DEFAULT NULL,
  `CREATOR_ID` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PORTFOLIO_PLAN_VERSION` bigint(20) DEFAULT '0',
  `INCLUDE_COMPLETED_ISSUES_FOR` int(11) DEFAULT NULL,
  `IGNORE_RELEASES` int(11) DEFAULT NULL,
  `IGNORE_TEAMS` int(11) DEFAULT NULL,
  `IGNORE_SPRINTS` int(11) DEFAULT NULL,
  `BASELINE_START_FIELD_ID` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `BASELINE_END_FIELD_ID` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `RANK_AGAINST_STORIES` tinyint(1) DEFAULT NULL,
  `ISSUE_INFERRED_DATE_SELECTION` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `index_ao_d9132d_pla1139540794` (`PROGRAM_ID`),
  KEY `index_ao_d9132d_pla495183907` (`PORTFOLIO_PLAN_VERSION`)
) ENGINE=InnoDB AUTO_INCREMENT=172 DEFAULT CHARSET=utf8 COLLATE=utf8_bin
1 row in set (0.00 sec)
dimitri commented 4 years ago

I meant to have a look at the data themselves. Are you missing reference data? you can find that with LEFT JOIN queries WHERE the other side is NULL, which is unexcited when you have a foreign key constraint. You can also use the data samples that Postgres complains about in its logs and see if the missing row also is missing in MySQL...

asifiqbal commented 4 years ago

So if inspected the data and I find it empty

2020-06-05T21:04:48.258000+01:00 NOTICE ALTER TABLE jiratiny.ao_589059_rule_to_label ADD CONSTRAINT fk_ao_589059_rule_to_label_label_id FOREIGN KEY(label_id) REFERENCES jiratiny.ao_589059_rule_label(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:04:48.263000+01:00 NOTICE ALTER TABLE jiratiny.ao_589059_rule_to_label ADD CONSTRAINT fk_ao_589059_rule_to_label_rule_id FOREIGN KEY(rule_id) REFERENCES jiratiny.ao_589059_rule_config(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:04:48.264000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_589059_rule_to_label" violates foreign key constraint "fk_ao_589059_rule_to_label_rule_id"
DETAIL: Key (rule_id)=(188) is not present in table "ao_589059_rule_config".
QUERY: ALTER TABLE jiratiny.ao_589059_rule_to_label ADD CONSTRAINT fk_ao_589059_rule_to_label_rule_id FOREIGN KEY(rule_id) REFERENCES jiratiny.ao_589059_rule_config(id) ON UPDATE RESTRICT ON DELETE RESTRICT
mysql> select * from AO_589059_RULE_TO_LABEL where ID = 188;
Empty set (0.00 sec)

mysql> select * from AO_589059_RULE_CONFIG where ID = 188;
Empty set (0.00 sec)

Here are those two tables

mysql> show create table AO_589059_RULE_CONFIG \G
*************************** 1. row ***************************
       Table: AO_589059_RULE_CONFIG
Create Table: CREATE TABLE `AO_589059_RULE_CONFIG` (
  `ACTOR_KEY` varchar(255) COLLATE utf8_bin NOT NULL,
  `AUTHOR_KEY` varchar(255) COLLATE utf8_bin NOT NULL,
  `CAN_OTHER_RULE_TRIGGER` tinyint(1) DEFAULT NULL,
  `CLIENT_KEY` varchar(255) COLLATE utf8_bin NOT NULL,
  `CREATED` datetime NOT NULL,
  `DESCRIPTION` longtext COLLATE utf8_bin,
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `NAME` varchar(255) COLLATE utf8_bin NOT NULL,
  `NOTIFY_ON_ERROR` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'FIRSTERROR',
  `PROJECT_ID` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PROJECT_TYPE_KEY` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `STATE` varchar(255) COLLATE utf8_bin NOT NULL,
  `UPDATED` datetime DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `index_ao_589059_rul1206101986` (`CLIENT_KEY`,`PROJECT_ID`),
  KEY `index_ao_589059_rul2042676290` (`CLIENT_KEY`)
) ENGINE=InnoDB AUTO_INCREMENT=186 DEFAULT CHARSET=utf8 COLLATE=utf8_bin
1 row in set (0.01 sec)

mysql> show create table AO_589059_RULE_TO_LABEL \G
*************************** 1. row ***************************
       Table: AO_589059_RULE_TO_LABEL
Create Table: CREATE TABLE `AO_589059_RULE_TO_LABEL` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `LABEL_ID` int(11) NOT NULL,
  `RULE_ID` int(11) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `index_ao_589059_rul487188655` (`LABEL_ID`),
  KEY `index_ao_589059_rul677772867` (`RULE_ID`,`LABEL_ID`),
  KEY `index_ao_589059_rul1420464715` (`RULE_ID`),
  CONSTRAINT `fk_ao_589059_rule_to_label_label_id` FOREIGN KEY (`LABEL_ID`) REFERENCES `AO_589059_RULE_LABEL` (`ID`),
  CONSTRAINT `fk_ao_589059_rule_to_label_rule_id` FOREIGN KEY (`RULE_ID`) REFERENCES `AO_589059_RULE_CONFIG` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8 COLLATE=utf8_bin
1 row in set (0.01 sec)
asifiqbal commented 4 years ago

Here is left join for that error message DETAIL: Key (rule_id)=(188) is not present in table "ao_589059_rule_config".

mysql> select * from AO_589059_RULE_LABEL left join AO_589059_RULE_CONFIG on AO_589059_RULE_LABEL.ID = AO_589059_RULE_CONFIG.ID WHERE AO_589059_RULE_LABEL.ID = NULL;
Empty set (0.01 sec)
dimitri commented 4 years ago

So if inspected the data and I find it empty

2020-06-05T21:04:48.258000+01:00 NOTICE ALTER TABLE jiratiny.ao_589059_rule_to_label ADD CONSTRAINT fk_ao_589059_rule_to_label_label_id FOREIGN KEY(label_id) REFERENCES jiratiny.ao_589059_rule_label(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:04:48.263000+01:00 NOTICE ALTER TABLE jiratiny.ao_589059_rule_to_label ADD CONSTRAINT fk_ao_589059_rule_to_label_rule_id FOREIGN KEY(rule_id) REFERENCES jiratiny.ao_589059_rule_config(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2020-06-05T21:04:48.264000+01:00 ERROR PostgreSQL Database error 23503: insert or update on table "ao_589059_rule_to_label" violates foreign key constraint "fk_ao_589059_rule_to_label_rule_id"
DETAIL: Key (rule_id)=(188) is not present in table "ao_589059_rule_config".
QUERY: ALTER TABLE jiratiny.ao_589059_rule_to_label ADD CONSTRAINT fk_ao_589059_rule_to_label_rule_id FOREIGN KEY(rule_id) REFERENCES jiratiny.ao_589059_rule_config(id) ON UPDATE RESTRICT ON DELETE RESTRICT
mysql> select * from AO_589059_RULE_TO_LABEL where ID = 188;
Empty set (0.00 sec)

mysql> select * from AO_589059_RULE_CONFIG where ID = 188;
Empty set (0.00 sec)

If I read the error message correctly the query that we are interested into is:

select * from AO_589059_RULE_TO_LABEL where rule_id = 188

And the join would be:

select AO_589059_RULE_LABEL.id, AO_589059_RULE_LABEL.rule_id
   from AO_589059_RULE_LABEL 
        left join AO_589059_RULE_CONFIG 
        on AO_589059_RULE_LABEL.RULE_ID = AO_589059_RULE_CONFIG.ID
WHERE AO_589059_RULE_CONFIG.ID IS NULL;

Note that we expect to have data in the rule table that is missing in the config table, the reference goes from rule.rule_id to config.id, and that we need to use IS NULL rather than = to compare against null values.

asifiqbal commented 4 years ago
mysql> select * from AO_589059_RULE_TO_LABEL where rule_id = 188;
+----+----------+---------+
| ID | LABEL_ID | RULE_ID |
+----+----------+---------+
| 46 |        1 |     188 |
+----+----------+---------+
1 row in set (0.00 sec)
mysql> select AO_589059_RULE_TO_LABEL.id, AO_589059_RULE_TO_LABEL.rule_id   
from AO_589059_RULE_TO_LABEL   
left join AO_589059_RULE_CONFIG          
on AO_589059_RULE_TO_LABEL.RULE_ID = AO_589059_RULE_CONFIG.ID 
WHERE AO_589059_RULE_CONFIG.ID IS NULL;
+----+---------+
| id | rule_id |
+----+---------+
| 46 |     188 |
| 47 |     189 |
| 48 |     258 |
| 49 |     282 |
| 50 |     301 |
| 51 |     304 |
| 52 |     312 |
| 54 |     315 |
| 63 |     315 |
| 55 |     316 |
| 56 |     316 |
| 57 |     317 |
| 58 |     317 |
| 59 |     318 |
| 60 |     318 |
| 61 |     319 |
| 62 |     319 |
| 64 |     321 |
| 65 |     321 |
| 66 |     332 |
| 67 |     332 |
| 69 |     339 |
| 70 |     340 |
| 68 |     341 |
| 71 |     342 |
| 72 |     343 |
| 73 |     344 |
| 74 |     345 |
| 75 |     346 |
| 76 |     350 |
| 77 |     366 |
| 78 |     368 |
| 79 |     404 |
| 80 |     405 |
+----+---------+
34 rows in set (0.01 sec)
dimitri commented 4 years ago

The first query is looking into the label table instead of the config table, as per the error message from Postgres:

DETAIL: Key (rule_id)=(188) is not present in table "ao_589059_rule_config".

So the first query find the row in the label table that has no match in the config table.

The second “LEFT JOIN” query is finding rows in the label table with a rule_id that is not to be found in the config table. It seems that despite having a foreign key reference, you have 34 rows without the expected entry in the config table.

Postgres nor pgloader can invent those missing rows, hence the failure of the creation of the foreign key on the Postgres side. Consider cleaning-up your MySQL database before migrating if that's possible, or after the migration, so that you have a data set compliant with your schema constraints.

asifiqbal commented 4 years ago

I found the problem. I was taking 100 rows (jiratiny, mysqldump of 100 rows of jira) and that is why those IDs (AO_589059_RULE_TO_LABEL.RULE_ID -> AO_589059_RULE_CONFIG.ID) were missing on reference table AO_589059_RULE_CONFIG. When I ran that same query against full database (jira), it is not NULL anymore. Showing results below.

mysql> select ID from jiratiny.AO_589059_RULE_CONFIG where id = 188;
Empty set (0.00 sec)

mysql> select ID from jira.AO_589059_RULE_CONFIG where id = 188;
+-----+
| ID  |
+-----+
| 188 |
+-----+
1 row in set (0.00 sec)

Here is the output of the full database migration

2020-06-08T17:41:57.825000+01:00 LOG report summary reset
                         table name     errors       rows      bytes      total time
-----------------------------------  ---------  ---------  ---------  --------------
                    fetch meta data          0       3487                     5.645s
                     Create Schemas          0          0                     0.003s
                   Create SQL Types          0          0                     0.010s
                      Create tables          0       1932                     5.470s
                     Set Table OIDs          0        966                     0.013s
-----------------------------------  ---------  ---------  ---------  --------------
                jira.actions_c14101          0       2958   203.0 kB          0.081s
                jira.actions_c14119          0      13048   916.7 kB          0.154s
                jira.actions_c14401          0       3142   556.2 kB          0.131s
                jira.actions_c14517          0          0                     0.057s
                jira.actions_c14522          0       3039   119.0 kB          0.172s
                jira.actions_c14613          0       2951   321.7 kB          0.093s
                jira.actions_c14657          0       6025   328.2 kB          0.136s
                jira.actions_c15003          0          9     0.4 kB          0.040s
                jira.actions_c16106          0          0                     0.060s
                jira.actions_c16209          0          0                     0.080s
                jira.actions_c16627          0          0                     0.246s
                jira.actions_c16630          0        362    95.6 kB          0.291s
                jira.actions_c17501          0          3     0.5 kB          0.039s
                jira.actions_c17607          0         49     7.3 kB          0.081s
                jira.actions_c26227          0        423    99.1 kB          0.168s
                jira.actions_c26228          0          0                     0.117s
                jira.actions_c26472          0          4     0.3 kB          0.165s
                jira.actions_c26626          0          0                     0.279s
                jira.actions_c27117          0          2     0.2 kB          0.311s
                jira.actions_c27118          0          1     0.1 kB          0.362s
                jira.actions_f13501          0          0                     0.487s
                jira.actions_f13519          0          0                     0.511s
                jira.actions_f13800          0          0                     0.531s
                jira.actions_f13915          0          0                     0.545s
                jira.actions_f13920          0          0                     0.562s
                jira.actions_f14011          0          0                     0.623s
                jira.actions_f14054          0          0                     0.643s
                jira.actions_f14400          0          0                     0.665s
                jira.actions_f15404          0          0                     0.707s
                jira.actions_f15923          0          0                     0.770s
                jira.actions_f16907          0          0                     0.809s
     jira.ao_013613_activity_source          0          0                     0.851s
             jira.ao_013613_expense          0          0                     0.887s
        jira.ao_013613_exp_category          0          1     0.0 kB          0.943s
           jira.ao_013613_favorites          0          0                     1.031s
           jira.ao_013613_hd_scheme          0          1     0.0 kB          1.058s
       jira.ao_013613_hd_scheme_day          0          0                     1.076s
    jira.ao_013613_hd_scheme_member          0         21     0.8 kB          1.094s
    jira.ao_013613_permission_group          0          3     0.1 kB          1.285s
      jira.ao_013613_project_config          0          2     0.0 kB          1.298s
         jira.ao_013613_wa_sl_value          0          0                     1.317s
            jira.ao_013613_wa_value          0          0                     1.339s
           jira.ao_013613_wl_scheme          0          1     0.1 kB          1.385s
       jira.ao_013613_wl_scheme_day          0          7     0.1 kB          1.508s
    jira.ao_013613_wl_scheme_member          0         21     0.8 kB          1.547s
      jira.ao_013613_work_attribute          0          0                     1.567s
        jira.ao_09e361_xls_resource          0         19   402.1 kB          1.722s
            jira.ao_09e361_xls_view          0         18     3.0 kB          1.751s
jira.ao_0a5972_notification_setting          0          0                     1.769s
   jira.ao_0a5972_push_registration          0          0                     1.785s
   jira.ao_0ac321_recommendation_ao          0          0                     1.794s
      jira.ao_1273f8_admin_settings          0          0                     1.810s
          jira.ao_1273f8_cov_filter          0         10     9.1 kB          1.835s
           jira.ao_1b54da_dbconfigs          0          0                     1.919s
   jira.ao_1b54da_integrationconfig          0          0                     1.995s
    jira.ao_1b54da_jobconfiguration          0          0                     2.043s
         jira.ao_1b54da_krssecurity          0          0                     2.076s
       jira.ao_1b54da_krunnablesils          0          0                     2.113s
          jira.ao_1b54da_ldapconfig          0          0                     2.136s
             jira.ao_1b54da_persvar          0          0                     2.155s
        jira.ao_1b54da_pluginconfig          0         30     2.6 kB          2.174s
       jira.ao_1b54da_remoteconfigs          0          0                     2.193s
              jira.ao_1b54da_tspath          0          0                     2.263s
              jira.ao_1b54da_tstext          0          0                     2.335s
         jira.ao_1b54da_ug_security          0          0                     2.361s
       jira.ao_1b54da_webhookconfig          0          0                     2.394s
       jira.ao_1b54da_webhookmethod          0          0                     2.424s
     jira.ao_21d670_whitelist_rules          0         15     0.8 kB          2.457s
          jira.ao_21f425_message_ao          0          2     1.2 kB          2.490s
  jira.ao_21f425_message_mapping_ao          0          2     0.1 kB          2.508s
    jira.ao_21f425_user_property_ao          0       9544   998.9 kB          2.716s
          jira.ao_242870_attachment          0          0                     0.047s
  jira.ao_242870_auto_import_report          0       2201   227.0 kB          0.122s
    jira.ao_242870_auto_import_rule          0          2     0.2 kB          0.073s
    jira.ao_242870_auto_imp_rep_ent          0        396     6.0 kB          0.344s
            jira.ao_242870_baseline          0          3     0.3 kB          0.038s
jira.ao_242870_baseline_comp_filter          0          3     0.1 kB          0.061s
       jira.ao_242870_baseline_item          0        223     5.0 kB          0.085s
  jira.ao_242870_baseline_signature          0          0                     0.062s
     jira.ao_242870_black_li_fi_rev          0          0                     0.125s
  jira.ao_242870_child_req_relation          0          0                     0.185s
        jira.ao_242870_cov_fil_migr          0          0                     0.210s
     jira.ao_242870_dmmodel_project          0          0                     0.233s
          jira.ao_242870_dmsettings          0          0                     0.263s
      jira.ao_242870_email_template          0          1     0.0 kB          0.320s
      jira.ao_242870_issue_revision          0     537038    40.6 MB          5.382s
  jira.ao_242870_permission_project          0        124     1.1 kB          0.050s
     jira.ao_242870_permission_role          0         42     1.3 kB          0.065s
 jira.ao_242870_permission_settings          0          1     0.0 kB          0.130s
     jira.ao_242870_pers_cov_filter          0          0                     0.330s
   jira.ao_242870_per_proj_category          0          2     0.0 kB          0.502s
     jira.ao_242870_project_del_per          0          3     0.1 kB          0.697s
     jira.ao_242870_project_mod_per          0          3     0.1 kB          0.898s
     jira.ao_242870_project_mov_per          0          2     0.1 kB          1.122s
  jira.ao_242870_project_permission          0         11     0.3 kB          1.303s
    jira.ao_242870_project_per_rest          0          1     0.0 kB          1.474s
 jira.ao_242870_project_read_filter          0          6     0.7 kB          1.647s
    jira.ao_242870_project_rest_per          0          2     0.0 kB          1.753s
    jira.ao_242870_project_settings          0        194    37.9 kB          1.823s
 jira.ao_242870_project_she_del_per          0          0                     0.043s
 jira.ao_242870_project_she_mod_per          0          0                     0.074s
jira.ao_242870_project_she_rest_per          0          0                     0.119s
 jira.ao_242870_project_tree_filter          0        194    10.8 kB          0.372s
 jira.ao_242870_project_tree_folder          0        135    17.4 kB          0.049s
   jira.ao_242870_project_tree_item          0        422    16.1 kB          0.057s
   jira.ao_242870_project_tree_page          0          0                     0.071s
     jira.ao_242870_proj_tree_watch          0          9     0.1 kB          0.164s
      jira.ao_242870_pub_cov_filter          0          1     0.3 kB          0.214s
   jira.ao_242870_req_data_mdl_rule          0          0                     0.292s
      jira.ao_242870_req_dmmdl_rule          0          0                     0.341s
         jira.ao_242870_req_dmmodel          0          0                     0.410s
     jira.ao_242870_req_dmrule_link          0          0                     0.433s
      jira.ao_242870_req_if_mapping          0          0                     0.498s
   jira.ao_242870_reuse_copy_config          0          0                     0.524s
    jira.ao_242870_revision_history          0   26282074     3.8 GB       7m51.649s
      jira.ao_242870_suspect_config          0          0                     0.178s
 jira.ao_242870_suspect_config_item          0          0                     0.268s
 jira.ao_242870_suspect_config_link          0          0                     0.457s
        jira.ao_242870_suspect_migr          0          0                     0.674s
            jira.ao_242870_template          0         11   769.8 kB          1.173s
   jira.ao_242870_trace_pers_filter          0          1     0.3 kB          1.297s
    jira.ao_242870_trace_pub_filter          0          4     0.9 kB          1.417s
        jira.ao_242870_user_profile          0          9     0.5 kB          1.560s
            jira.ao_272c37_dssentry          0          0                     1.710s
            jira.ao_272c37_dtgentry          0          3     3.4 kB          1.870s
        jira.ao_272c37_field_config          0          2     2.1 kB          2.029s
       jira.ao_272c37_multi_cascade          0          0                     2.150s
            jira.ao_272c37_ubpentry          0        195    14.1 kB          2.352s
          jira.ao_2b7a0e_delegation          0       5936   317.5 kB          0.409s
         jira.ao_2c4e5c_mailchannel          0          0                     0.224s
      jira.ao_2c4e5c_mailconnection          0          0                     0.394s
   jira.ao_2c4e5c_mailglobalhandler          0          0                     0.565s
         jira.ao_2c4e5c_mailhandler          0          0                     0.687s
            jira.ao_2c4e5c_mailitem          0          0                     0.812s
       jira.ao_2c4e5c_mailitemaudit          0          0                     0.950s
       jira.ao_2c4e5c_mailitemchunk          0          0                     1.094s
        jira.ao_2c4e5c_mailrunaudit          0          0                     1.162s
          jira.ao_2d3bea_allocation          0         46     2.4 kB          1.310s
          jira.ao_2d3bea_attachment          0          0                     1.484s
            jira.ao_2d3bea_baseline          0          0                     1.612s
             jira.ao_2d3bea_comment          0          0                     1.778s
            jira.ao_2d3bea_currency          0         77     2.2 kB          2.011s
         jira.ao_2d3bea_customfield          0          0                     0.094s
   jira.ao_2d3bea_customfieldpvalue          0          0                     0.213s
    jira.ao_2d3bea_customfieldvalue          0          0                     0.402s
       jira.ao_2d3bea_entity_change          0        405    38.0 kB          0.725s
        jira.ao_2d3bea_exchangerate          0          0                     0.237s
             jira.ao_2d3bea_expense          0          3     0.5 kB          0.437s
        jira.ao_2d3bea_externalteam          0          2     0.1 kB          0.631s
               jira.ao_2d3bea_folio          0         12     2.5 kB          0.840s
             jira.ao_2d3bea_foliocf          0          0                     1.044s
        jira.ao_2d3bea_foliocfvalue          0          0                     1.227s
    jira.ao_2d3bea_foliotoportfolio          0         10     0.1 kB          1.427s
         jira.ao_2d3bea_folio_admin          0         27     1.1 kB          1.587s
        jira.ao_2d3bea_folio_format          0         12     0.3 kB          1.732s
    jira.ao_2d3bea_folio_perm_group          0          3     0.1 kB          1.890s
       jira.ao_2d3bea_folio_user_ao          0       5671   273.2 kB          2.178s
                jira.ao_2d3bea_nwds          0          0                     0.263s
       jira.ao_2d3bea_otruletofolio          0          0                     0.455s
            jira.ao_2d3bea_overtime          0          0                     0.602s
    jira.ao_2d3bea_permission_group          0          0                     0.778s
     jira.ao_2d3bea_plan_allocation          0          0                     0.823s
   jira.ao_2d3bea_plan_approval_log          0          0                     0.864s
           jira.ao_2d3bea_portfolio          0          7     0.7 kB          1.089s
jira.ao_2d3bea_portfoliotoportfolio          0          5     0.0 kB          1.254s
     jira.ao_2d3bea_portfolio_admin          0         12     0.4 kB          1.365s
jira.ao_2d3bea_portfolio_dynamic_cf          0          0                     1.534s
            jira.ao_2d3bea_position          0         46     6.4 kB          1.715s
                jira.ao_2d3bea_rate          0          8     0.2 kB          1.965s
              jira.ao_2d3bea_status          0          0                     2.204s
            jira.ao_2d3bea_timeline          0          0                     2.407s
         jira.ao_2d3bea_user_filter          0          0                     2.552s
          jira.ao_2d3bea_user_index          0       5050  1014.7 kB          3.128s
                jira.ao_2d3bea_wage          0         46     1.7 kB          0.336s
             jira.ao_2d3bea_weekday          0         84     1.0 kB          0.634s
        jira.ao_2d3bea_worked_hours          0          0                     0.231s
            jira.ao_2d3bea_workflow          0          0                     0.386s
 jira.ao_2f1435_health_check_status          0         25     8.9 kB          0.513s
          jira.ao_2f1435_properties          0          1     0.0 kB          0.676s
  jira.ao_2f1435_read_notifications          0        213    13.5 kB          1.061s
             jira.ao_319474_message          0          0                     0.190s
    jira.ao_319474_message_property          0          0                     0.357s
               jira.ao_319474_queue          0          0                     0.521s
      jira.ao_319474_queue_property          0          0                     0.663s
 jira.ao_38321b_custom_content_link          0          0                     0.810s
          jira.ao_39e198_bar_branch          0        186    39.7 kB          1.112s
         jira.ao_39e198_bar_comment          0         51    25.0 kB          0.173s
            jira.ao_39e198_bar_info          0        760    49.2 kB          0.232s
        jira.ao_39e198_bar_resource          0       1772    32.6 MB          9.298s
       jira.ao_39e198_bar_thumbnail          0       1274    12.0 MB          4.932s
            jira.ao_39e198_bar_user          0         16     4.6 kB          0.568s
   jira.ao_39e198_bas_platform_info          0        133    14.7 kB          0.781s
        jira.ao_39e198_bas_presence          0          0                     0.282s
         jira.ao_39e198_bas_session          0       2513   983.5 kB          0.710s
     jira.ao_39e198_bas_temp_object          0          0                     0.202s
      jira.ao_3b1893_loop_detection          0          0                     0.344s
     jira.ao_4136f9_permission_role          0          3     0.1 kB          0.517s
 jira.ao_4136f9_permission_settings          0          1     0.0 kB          0.632s
         jira.ao_4136f9_sche_filter          0          0                     0.736s
        jira.ao_4136f9_sche_history          0          0                     0.828s
          jira.ao_4136f9_sche_issue          0          0                     0.938s
         jira.ao_4136f9_sche_series          0          0                     1.113s
       jira.ao_4634d4_action_config          0          0                     1.291s
   jira.ao_4634d4_action_log_entity          0      49886     1.6 MB          2.001s
   jira.ao_4634d4_additional_config          0          0                     0.375s
    jira.ao_4634d4_audit_log_config          0         38     0.8 kB          0.570s
         jira.ao_4634d4_field_entry          0          0                     0.769s
       jira.ao_4634d4_field_mapping          0          0                     0.911s
         jira.ao_4634d4_restriction          0          0                     1.047s
      jira.ao_4634d4_run_log_entity          0         13     1.0 kB          1.181s
         jira.ao_4634d4_salt_config          0          0                     1.377s
     jira.ao_4634d4_schedule_config          0          0                     1.520s
       jira.ao_4634d4_scheme_config          0          0                     1.627s
     jira.ao_4634d4_user_log_entity          0      24943     2.0 MB          2.490s
  jira.ao_4634d4_user_select_config          0          0                     0.336s
         jira.ao_46e61b_used_fields          0         77     0.7 kB          0.653s
 jira.ao_4789dd_health_check_status          0         13     4.5 kB          0.280s
          jira.ao_4789dd_properties          0          1     0.0 kB          0.569s
  jira.ao_4789dd_read_notifications          0         61     4.0 kB          0.864s
        jira.ao_4789dd_task_monitor          0          0                     0.262s
         jira.ao_4aeacd_webhook_dao          0          1     0.3 kB          0.456s
     jira.ao_4b00e6_adapta_analytic          0          1     0.1 kB          0.636s
   jira.ao_4b00e6_script_run_result          0        634     1.5 MB          1.151s
        jira.ao_4b00e6_sr_user_prop          0          9     1.2 kB          0.220s
      jira.ao_4b00e6_stash_settings          0          1     0.0 kB          0.382s
  jira.ao_54307e_asyncupgraderecord          0         18     1.9 kB          0.547s
            jira.ao_550953_shortcut          0       1066   109.1 kB          0.736s
        jira.ao_55c8c0_app_settings          0          2     0.2 kB          0.206s
          jira.ao_55c8c0_bar_branch          0         23     5.6 kB          0.418s
         jira.ao_55c8c0_bar_comment          0         34    16.4 kB          0.529s
            jira.ao_55c8c0_bar_info          0        115     7.4 kB          0.703s
        jira.ao_55c8c0_bar_resource          0        399     5.1 MB          1.910s
       jira.ao_55c8c0_bar_thumbnail          0        335     3.5 MB          2.128s
            jira.ao_55c8c0_bar_user          0          6     1.7 kB          0.882s
   jira.ao_55c8c0_bas_platform_info          0         15     2.0 kB          1.715s
        jira.ao_55c8c0_bas_presence          0          0                     1.889s
         jira.ao_55c8c0_bas_session          0        388   143.5 kB          2.184s
     jira.ao_55c8c0_bas_temp_object          0          0                     0.245s
          jira.ao_55c8c0_user_event          0         19     8.2 kB          0.408s
     jira.ao_563aee_activity_entity          0       2623     1.4 MB          1.008s
        jira.ao_563aee_actor_entity          0          0                     0.325s
   jira.ao_563aee_media_link_entity          0       2623   330.4 kB          0.602s
       jira.ao_563aee_object_entity          0          0                     0.187s
       jira.ao_563aee_target_entity          0       2623   340.3 kB          0.515s
         jira.ao_575bf5_dev_summary          0    1819659   463.8 MB       1m23.194s
   jira.ao_575bf5_processed_commits          0          6     0.5 kB          1.903s
      jira.ao_575bf5_provider_issue          0     204309     7.8 MB          6.430s
     jira.ao_575bf5_provider_seq_no          0          2     0.1 kB          0.791s
       jira.ao_587b34_glance_config          0          0                     1.021s
      jira.ao_587b34_project_config          0          0                     1.400s
          jira.ao_589059_audit_item          0      78142    23.5 MB          9.123s
 jira.ao_589059_audit_item_asc_item          0      82125     4.6 MB          3.618s
 jira.ao_589059_audit_item_cge_item          0     108163    10.7 MB          3.945s
 jira.ao_589059_audit_item_comp_cge          0     174906    18.0 MB          3.822s
  jira.ao_589059_audit_item_project          0     155784     3.0 MB          1.165s
    jira.ao_589059_automation_queue          0          1    29.3 kB          0.079s
            jira.ao_589059_counters          0          0                     0.344s
    jira.ao_589059_legacy_rule_link          0          0                     0.468s
  jira.ao_589059_rule_cfg_component          0       2149   694.3 kB          0.811s
 jira.ao_589059_rule_cfg_proj_assoc          0        314     7.2 kB          0.197s
         jira.ao_589059_rule_config          0        314    66.7 kB          0.119s
          jira.ao_589059_rule_label          0          5     0.1 kB          0.100s
       jira.ao_589059_rule_schedule          0         30     2.0 kB          0.162s
           jira.ao_589059_rule_stat          0        145    13.7 kB          0.195s
   jira.ao_589059_rule_state_latest          0        339    31.2 kB          0.127s
jira.ao_589059_rule_stat_rollup_day          0       3385   293.1 kB          0.432s
 jira.ao_589059_rule_stat_rollup_hr          0       5405   470.5 kB          0.211s
jira.ao_589059_rule_stat_rollup_min          0        137    12.4 kB          0.073s
            jira.ao_589059_rule_tag          0          0                     0.049s
       jira.ao_589059_rule_to_label          0         44     0.4 kB          0.159s
     jira.ao_5fb9d7_aohip_chat_link          0          0                     0.425s
     jira.ao_5fb9d7_aohip_chat_user          0          0                     0.460s
          jira.ao_60db71_auditentry          0      12043     1.2 MB          0.848s
         jira.ao_60db71_boardadmins          0       8602   388.1 kB          0.122s
           jira.ao_60db71_cardcolor          0      20358   846.4 kB          0.355s
          jira.ao_60db71_cardlayout          0       1917    63.5 kB          0.115s
              jira.ao_60db71_column          0      19023   676.6 kB          0.250s
        jira.ao_60db71_columnstatus          0      78809     1.6 MB          0.526s
     jira.ao_60db71_detailviewfield          0      46006     1.0 MB          0.385s
   jira.ao_60db71_estimatestatistic          0       3903    89.5 kB          0.241s
        jira.ao_60db71_issueranking          0      25303   589.2 kB          0.208s
     jira.ao_60db71_issuerankinglog          0          0                     0.042s
            jira.ao_60db71_lexorank          0     829487    31.7 MB          6.121s
    jira.ao_60db71_lexorankbalancer          0          0                     0.049s
       jira.ao_60db71_nonworkingday          0        677    13.3 kB          0.258s
         jira.ao_60db71_quickfilter          0      15046     1.5 MB          1.244s
      jira.ao_60db71_rankableobject          0          5     0.1 kB          0.537s
     jira.ao_60db71_rank_issue_link          0          0                     0.805s
           jira.ao_60db71_rapidview          0       3903   358.3 kB          1.423s
              jira.ao_60db71_sprint          0       9162   753.8 kB          1.083s
        jira.ao_60db71_sprintmarker          0          5     0.1 kB          0.495s
          jira.ao_60db71_statsfield          0       3903    71.9 kB          0.848s
            jira.ao_60db71_subquery          0       2790   223.5 kB          0.549s
            jira.ao_60db71_swimlane          0       8391   608.5 kB          0.561s
   jira.ao_60db71_trackingstatistic          0       3903    68.3 kB          0.348s
             jira.ao_60db71_version          0          0                     0.184s
         jira.ao_60db71_workingdays          0       3899   158.8 kB          0.602s
       jira.ao_6358c7_attach_upload          0          0                     0.261s
        jira.ao_6358c7_dynamic_form          0          0                     0.431s
  jira.ao_6358c7_dynamic_form_value          0          0                     0.585s
     jira.ao_6358c7_mention_request          0          0                     0.726s
             jira.ao_6358c7_pccache          0          7     0.3 kB          0.921s
         jira.ao_6358c7_pccache_prj          0        103     1.3 kB          1.193s
   jira.ao_6b9f04_aio_bounced_email          0          0                     0.187s
jira.ao_6b9f04_aio_calculated_field          0         43    26.6 kB          0.381s
jira.ao_6b9f04_aio_custom_attribute          0          0                     0.501s
 jira.ao_6b9f04_aio_custom_attr_val          0          0                     0.690s
             jira.ao_6b9f04_aio_key          0          1     2.0 kB          0.868s
jira.ao_6b9f04_aio_non_project_hour          0          0                     1.030s
jira.ao_6b9f04_aio_non_project_task          0          0                     1.165s
    jira.ao_6b9f04_aio_notification          0          0                     1.372s
     jira.ao_6b9f04_aio_permissions          0          1    59.1 kB          1.591s
jira.ao_6b9f04_aio_published_result          0        164   359.3 MB         46.692s
          jira.ao_6b9f04_aio_report          0       1146    37.5 MB         33.623s
     jira.ao_6b9f04_aio_report_page          0       1616    84.3 MB         10.885s
jira.ao_6b9f04_aio_scheduled_report          0         44    66.5 kB          2.466s
  jira.ao_6b9f04_aio_sched_rep_rcpt          0        112     5.6 kB          2.529s
   jira.ao_6b9f04_aio_shared_report          0       1133    18.1 kB          0.123s
     jira.ao_6b9f04_aio_shared_team          0          0                     0.110s
            jira.ao_6b9f04_aio_team          0         21     0.5 kB          0.187s
     jira.ao_6b9f04_aio_team_member          0        118     1.2 kB          0.290s
       jira.ao_6b9f04_aio_team_team          0          0                     0.044s
          jira.ao_6b9f04_aio_tenant          0          1     0.2 kB          0.068s
           jira.ao_6b9f04_aio_timer          0          0                     0.188s
       jira.ao_6b9f04_aio_timesheet          0          0                     0.318s
            jira.ao_6b9f04_aio_user          0       3308   534.1 kB          0.474s
jira.ao_6b9f04_aio_user_preferences          0         89     6.9 kB          0.183s
              jira.ao_6b9f04_report          0          0                     0.136s
       jira.ao_6b9f04_shared_report          0          0                     0.170s
                jira.ao_6b9f04_user          0          0                     0.193s
               jira.ao_733371_event          0     156908    15.5 MB          2.691s
     jira.ao_733371_event_parameter          0    2976467   205.6 MB         30.675s
     jira.ao_733371_event_recipient          0     323338    37.8 MB         12.991s
            jira.ao_7a2604_calendar          0          7     0.7 kB          0.733s
             jira.ao_7a2604_holiday          0          0                     0.987s
         jira.ao_7a2604_workingtime          0         35     1.2 kB          1.493s
       jira.ao_7aeb56_shared_script          0          0                     1.692s
         jira.ao_7c2234_project_nvp          0          0                     2.070s
          jira.ao_7deabf_attachment          0      16338     2.2 MB          3.960s
     jira.ao_7deabf_change_zjegroup          0     305541    31.1 MB          5.673s
      jira.ao_7deabf_change_zjeitem          0     605391    47.0 MB         11.031s
  jira.ao_7deabf_column_layout_item          0       2094    52.8 kB          0.558s
        jira.ao_7deabf_custom_field          0          1     0.1 kB          0.249s
  jira.ao_7deabf_custom_fields_meta          0          9     1.0 kB          0.335s
 jira.ao_7deabf_custom_field_option          0          7     0.1 kB          0.507s
jira.ao_7deabf_custom_field_project          0          1     0.0 kB          0.763s
               jira.ao_7deabf_cycle          0       1204   195.5 kB          1.161s
        jira.ao_7deabf_execution_cf          0        323     9.0 kB          0.279s
jira.ao_7deabf_exec_cluster_message          0          0                     0.218s
              jira.ao_7deabf_folder          0         65     5.3 kB          0.466s
jira.ao_7deabf_folder_cycle_mapping          0         65     4.8 kB          0.432s
jira.ao_7deabf_reindex_job_progress          0          4     0.3 kB          0.231s
            jira.ao_7deabf_schedule          0      27016     4.9 MB          1.486s
     jira.ao_7deabf_schedule_defect          0        625     9.8 kB          0.412s
         jira.ao_7deabf_step_defect          0       1504    43.0 kB          0.520s
         jira.ao_7deabf_step_result          0     141832    17.2 MB          3.778s
            jira.ao_7deabf_teststep          0     102515    22.2 MB          4.966s
        jira.ao_7deabf_test_step_cf          0          0                     0.147s
    jira.ao_7deabf_zfjcolumn_layout          0        156     6.0 kB          0.353s
    jira.ao_7deabf_zqlfavorite_asoc          0         95     3.6 kB          0.415s
           jira.ao_7deabf_zqlfilter          0         92    19.1 kB          0.503s
jira.ao_7deabf_zqlshare_permissions          0         92     1.7 kB          0.455s
             jira.ao_82b313_ability          0         21     0.3 kB          0.272s
             jira.ao_82b313_absence          0          0                     0.408s
        jira.ao_82b313_availability          0          0                     0.530s
                jira.ao_82b313_init          0          2     0.0 kB          0.749s
              jira.ao_82b313_person          0       5943   268.7 kB          0.887s
            jira.ao_82b313_resource          0        220     4.3 kB          0.214s
               jira.ao_82b313_skill          0         11     0.2 kB          0.122s
                jira.ao_82b313_team          0        220    19.0 kB          0.279s
  jira.ao_85377d_switch_user_config          0          1     0.0 kB          0.043s
        jira.ao_8542f1_ifj_atm_rule          0          1     0.1 kB          0.074s
     jira.ao_8542f1_ifj_atm_rule_ac          0          1     0.3 kB          0.105s
 jira.ao_8542f1_ifj_atm_rule_ac_log          0          1     0.0 kB          0.142s
     jira.ao_8542f1_ifj_atm_rule_co          0          1     0.0 kB          0.226s
  jira.ao_8542f1_ifj_atm_rule_co_ac          0          1     0.0 kB          0.268s
     jira.ao_8542f1_ifj_atm_rule_ev          0          4     0.1 kB          0.290s
      jira.ao_8542f1_ifj_cf_connect          0          0                     0.317s
         jira.ao_8542f1_ifj_comment          0         25     4.7 kB          0.554s
     jira.ao_8542f1_ifj_dcf_connect          0          4     0.6 kB          0.601s
         jira.ao_8542f1_ifj_feature          0          1     0.0 kB          0.683s
            jira.ao_8542f1_ifj_file          0         31     6.1 kB          0.778s
            jira.ao_8542f1_ifj_icon          0        160     8.3 kB          0.819s
           jira.ao_8542f1_ifj_image          0          0                     0.044s
      jira.ao_8542f1_ifj_import_cfg          0          0                     0.105s
 jira.ao_8542f1_ifj_import_cfg_attr          0          0                     0.196s
     jira.ao_8542f1_ifj_import_miss          0         52     2.9 kB          0.289s
   jira.ao_8542f1_ifj_import_result          0          0                     0.097s
      jira.ao_8542f1_ifj_import_src          0         14     3.6 kB          0.199s
   jira.ao_8542f1_ifj_import_src_ot          0         15     1.4 kB          0.241s
  jira.ao_8542f1_ifj_import_src_ota          0        166    15.0 kB          0.391s
       jira.ao_8542f1_ifj_label_tmp          0          0                     0.087s
             jira.ao_8542f1_ifj_obj          0       7522   732.3 kB          0.475s
      jira.ao_8542f1_ifj_obj_attach          0         40     6.9 kB          0.083s
        jira.ao_8542f1_ifj_obj_attr          0      87490     1.4 MB          0.534s
    jira.ao_8542f1_ifj_obj_attr_val          0      88774     5.2 MB          0.879s
        jira.ao_8542f1_ifj_obj_hist          0      20550     3.5 MB          0.898s
   jira.ao_8542f1_ifj_obj_jiraissue          0        270     6.0 kB          0.312s
     jira.ao_8542f1_ifj_obj_key_map          0          0                     0.101s
      jira.ao_8542f1_ifj_obj_schema          0         15     1.2 kB          0.221s
        jira.ao_8542f1_ifj_obj_type          0        183    14.6 kB          0.316s
   jira.ao_8542f1_ifj_obj_type_attr          0       1515   182.9 kB          0.147s
       jira.ao_8542f1_ifj_obj_watch          0          1     0.0 kB          0.166s
        jira.ao_8542f1_ifj_on_event          0          0                     0.278s
   jira.ao_8542f1_ifj_on_event_user          0          0                     0.308s
       jira.ao_8542f1_ifj_on_filter          0          5     1.1 kB          0.353s
  jira.ao_8542f1_ifj_on_filter_attr          0         50     1.1 kB          0.521s
   jira.ao_8542f1_ifj_on_filter_fav          0          5     0.3 kB          0.061s
 jira.ao_8542f1_ifj_on_filter_share          0          0                     0.079s
      jira.ao_8542f1_ifj_prg_in_prg          0          0                     0.102s
      jira.ao_8542f1_ifj_prg_ot_res          0        182   521.0 kB          0.382s
         jira.ao_8542f1_ifj_prg_res          0        182   105.3 kB          0.130s
     jira.ao_8542f1_ifj_rcf_connect          0          0                     0.104s
  jira.ao_8542f1_ifj_rcf_to_reftype          0          0                     0.195s
        jira.ao_8542f1_ifj_ref_type          0        191     5.6 kB          0.279s
         jira.ao_8542f1_ifj_res_ref          0         14     0.3 kB          0.110s
            jira.ao_8542f1_ifj_role          0        595    50.7 kB          0.375s
      jira.ao_8542f1_ifj_role_actor          0        160     9.2 kB          0.059s
         jira.ao_8542f1_ifj_sd_prop          0         15     0.3 kB          0.041s
     jira.ao_8542f1_ifj_status_type          0         28     0.6 kB          0.171s
            jira.ao_8542f1_ifj_user          0        207     7.8 kB          0.426s
          jira.ao_8542f1_ifj_widget          0          8     4.2 kB          0.056s
      jira.ao_8542f1_ifj_widget_fav          0          0                     0.179s
      jira.ao_8542f1_ifj_widget_lbl          0          0                     0.319s
    jira.ao_8542f1_ifj_widget_share          0          0                     0.370s
   jira.ao_8542f1_ifj_widget_to_lbl          0          0                     0.461s
        jira.ao_86ed1b_grace_period          0          0                     0.563s
     jira.ao_86ed1b_grace_period_v2          0          0                     0.667s
              jira.ao_86ed1b_period          0          0                     0.758s
       jira.ao_86ed1b_period_config          0          2     0.2 kB          0.853s
      jira.ao_86ed1b_project_config          0          0                     0.939s
     jira.ao_86ed1b_report_template          0          0                     0.978s
       jira.ao_86ed1b_streams_entry          0          0                     1.002s
            jira.ao_86ed1b_timeplan          0          0                     1.027s
  jira.ao_86ed1b_timesheet_approval          0          0                     1.076s
    jira.ao_86ed1b_timesheet_status          0          0                     1.215s
    jira.ao_86ed1b_worklog_ext_prop          0          0                     1.339s
 jira.ao_88263f_health_check_status          0         23     8.1 kB          1.363s
          jira.ao_88263f_properties          0          1     0.0 kB          1.382s
  jira.ao_88263f_read_notifications          0        183    11.5 kB          1.495s
    jira.ao_8ac478_box_id_generator          0          4     0.0 kB          0.079s
            jira.ao_8ac478_box_node          0        672    11.6 kB          0.201s
            jira.ao_8ac478_box_type          0          4     0.2 kB          0.050s
     jira.ao_8ac478_box_type_id_gen          0          1     0.0 kB          0.081s
       jira.ao_8ac478_custom_action          0          0                     0.128s
    jira.ao_8ac478_distributed_lock          0          0                     0.185s
       jira.ao_8ac478_embedded_task          0         22     1.5 kB          0.270s
     jira.ao_8ac478_et_surrogate_id          0         25     0.1 kB          0.297s
         jira.ao_8ac478_extplatform          0          2     0.1 kB          0.318s
    jira.ao_8ac478_extplatform_data          0          0                     0.338s
             jira.ao_8ac478_extuser          0          2     0.0 kB          0.377s
        jira.ao_8ac478_extuser_data          0          2     0.1 kB          0.524s
      jira.ao_8ac478_gantt_config_2          0        543    59.5 kB          0.733s
 jira.ao_8ac478_gantt_work_schedule          0          1     0.1 kB          0.042s
       jira.ao_8ac478_global_link_2          0        391    40.0 kB          0.138s
         jira.ao_8ac478_global_task          0     109495    16.6 MB          2.309s
             jira.ao_8ac478_holiday          0          0                     0.062s
        jira.ao_8ac478_holiday_plan          0          1     0.1 kB          0.185s
  jira.ao_8ac478_holiday_plan_entry          0          0                     0.407s
              jira.ao_8ac478_marker          0          0                     0.585s
             jira.ao_8ac478_program          0        110   601.1 kB          0.949s
            jira.ao_8ac478_property          0       3591   663.0 kB          0.538s
          jira.ao_8ac478_resource_2          0        614    73.4 kB          0.381s
    jira.ao_8ac478_resource_absence          0          0                     0.310s
    jira.ao_8ac478_resource_mapping          0        614    49.9 kB          0.538s
      jira.ao_8ac478_resource_skill          0          0                     0.155s
         jira.ao_8ac478_res_hd_plan          0        614    27.9 kB          0.350s
    jira.ao_8ac478_res_surrogate_id          0        631     4.2 kB          0.120s
         jira.ao_8ac478_res_wl_plan          0        614    30.3 kB          0.191s
                jira.ao_8ac478_role          0          3     0.2 kB          0.076s
 jira.ao_8ac478_role_assign_beta_v1          0        109     8.5 kB          0.175s
      jira.ao_8ac478_schedule_beta3          0        672    34.7 kB          0.104s
    jira.ao_8ac478_schedule_v_beta4          0        559    10.2 kB          0.112s
        jira.ao_8ac478_task_mapping          0          2     0.2 kB          0.049s
                jira.ao_8ac478_team          0          0                     0.207s
       jira.ao_8ac478_team_member_2          0          0                     0.326s
          jira.ao_8ac478_team_usage          0          0                     0.362s
               jira.ao_8ac478_view2          0        330  1006.1 kB          0.678s
          jira.ao_8ac478_wbs_config          0        116    44.1 kB          0.122s
       jira.ao_8ac478_wbs_hierarchy          0        320    12.2 kB          0.074s
            jira.ao_8ac478_wbs_node          0     207392    11.6 MB          2.177s
    jira.ao_8ac478_wbs_quick_filter          0        326    38.8 kB          0.088s
  jira.ao_8ac478_wbs_sub_wbs_fields          0          0                     0.155s
   jira.ao_8ac478_wbs_task_template          0          0                     0.310s
jira.ao_8ac478_wbs_team_to_schedule          0          0                     0.564s
       jira.ao_8ac478_workload_plan          0          1     0.1 kB          0.844s
      jira.ao_8b1069_activity_entry          0      23310     1.9 MB          1.835s
       jira.ao_8b1069_activity_item          0      70311     2.3 MB          1.623s
     jira.ao_8b1069_analytics_entry          0         26     1.7 kB          0.536s
          jira.ao_8b1069_attachment          0        219    29.5 kB          0.857s
     jira.ao_8b1069_automated_label          0          3     0.1 kB          0.267s
      jira.ao_8b1069_automated_step          0        195    32.3 kB          0.516s
jira.ao_8b1069_automated_step_issue          0        651     9.5 kB          0.306s
jira.ao_8b1069_automated_step_label          0          3     0.0 kB          0.191s
         jira.ao_8b1069_db_provider          0          1     0.0 kB          0.383s
              jira.ao_8b1069_folder          0         49     3.0 kB          0.551s
                jira.ao_8b1069_leaf          0        165     7.6 kB          0.751s
    jira.ao_8b1069_pre_cond_memento          0          0                     0.184s
     jira.ao_8b1069_pre_cond_result          0        982   220.2 kB          0.493s
  jira.ao_8b1069_req_hstatus_entity          0      13666   640.6 kB          0.426s
   jira.ao_8b1069_req_status_entity          0        792   958.2 kB          0.505s
         jira.ao_8b1069_step_status          0          0                     0.077s
 jira.ao_8b1069_test_example_result          0         36     1.2 kB          0.097s
   jira.ao_8b1069_test_example_step          0        390    32.9 kB          0.228s
        jira.ao_8b1069_test_memento          0      13336     1.8 MB          0.373s
 jira.ao_8b1069_test_plan_test_link          0      11697   488.2 kB          0.154s
    jira.ao_8b1069_test_precon_link          0          0                     0.062s
  jira.ao_8b1069_test_pre_cond_link          0        428    16.6 kB          0.185s
            jira.ao_8b1069_test_run          0      13576     1.7 MB          0.670s
     jira.ao_8b1069_test_run_defect          0        103     2.3 kB          0.521s
jira.ao_8b1069_test_run_requirement          0          0                     0.051s
     jira.ao_8b1069_test_run_result          0      14604     2.5 MB          0.523s
  jira.ao_8b1069_test_set_test_link          0       2161    87.8 kB          0.065s
         jira.ao_8b1069_test_status          0          0                     0.088s
           jira.ao_8b1069_test_step          0       8590     1.3 MB          0.361s
   jira.ao_8b1069_test_step_memento          0      13490     1.9 MB          0.313s
    jira.ao_8b1069_test_step_result          0      13490   342.7 kB          0.128s
    jira.ao_8b1069_tetest_plan_link          0        396    15.4 kB          0.076s
    jira.ao_8b1069_trinfo_migration          0          0                     0.152s
   jira.ao_8b1069_trmigration_fault          0          0                     0.262s
         jira.ao_8bad1b_atomic_flag          0          0                     0.309s
           jira.ao_8bad1b_bootstrap          0          1     0.0 kB          0.327s
           jira.ao_8bad1b_favorites          0        392    16.5 kB          0.420s
              jira.ao_8bad1b_folder          0       1104    27.5 kB          0.075s
              jira.ao_8bad1b_forest          0        334    56.5 kB          0.097s
       jira.ao_8bad1b_forest_change          0       6702   645.5 kB          0.299s
           jira.ao_8bad1b_generator          0       2103   255.3 kB          0.087s
        jira.ao_8bad1b_generic_item          0          5     0.4 kB          0.042s
      jira.ao_8bad1b_history_change          0       7929   780.1 kB          0.227s
       jira.ao_8bad1b_history_entry          0       7499   519.8 kB          0.126s
       jira.ao_8bad1b_history_issue          0      20884   531.1 kB          0.279s
     jira.ao_8bad1b_history_project          0       4664   110.2 kB          0.136s
         jira.ao_8bad1b_issue_index          0       4169    82.0 kB          0.178s
         jira.ao_8bad1b_item_events          0          0                     0.158s
           jira.ao_8bad1b_item_type          0         26     1.1 kB          0.178s
  jira.ao_8bad1b_manual_adjustments          0         47    49.8 kB          0.204s
          jira.ao_8bad1b_node_signs          0          0                     0.235s
            jira.ao_8bad1b_ordering          0          7     0.5 kB          0.326s
         jira.ao_8bad1b_perspective          0         24    77.1 kB          0.357s
       jira.ao_8bad1b_process_state          0          0                     0.367s
            jira.ao_8bad1b_property          0         13     0.6 kB          0.383s
                 jira.ao_8bad1b_row          0      24307   456.2 kB          0.682s
          jira.ao_8bad1b_statistics          0     132855     6.5 MB          1.189s
           jira.ao_8bad1b_structure          0        334    63.9 kB          0.075s
  jira.ao_8bad1b_structure_property          0        239    59.4 kB          0.047s
   jira.ao_8bad1b_structure_to_view          0        133    19.4 kB          0.034s
   jira.ao_8bad1b_sync_audit_record          0          0                     0.120s
          jira.ao_8bad1b_sync_event          0          0                     0.313s
       jira.ao_8bad1b_sync_instance          0          9     1.7 kB          0.470s
     jira.ao_8bad1b_s_item_property          0          4     0.1 kB          0.526s
                jira.ao_8bad1b_view          0        192   336.3 kB          0.658s
   jira.ao_8bad1b_view_to_structure          0        253     3.0 kB          0.064s
    jira.ao_923159_computer_account          0          0                     0.076s
         jira.ao_923159_node_status          0          0                     0.129s
         jira.ao_923159_samlidcache          0          0                     0.162s
   jira.ao_956e29_calendar_settings          0          0                     0.189s
jira.ao_956e29_export_building_info          0         19     6.2 kB          0.230s
     jira.ao_956e29_format_settings          0          1     0.0 kB          0.352s
     jira.ao_956e29_report_settings          0         83    60.7 kB          0.402s
    jira.ao_956e29_time_in_property          0          1     0.6 kB          0.049s
         jira.ao_96e78c_allowparent          0          0                     0.078s
             jira.ao_96e78c_group_f          0          8     0.2 kB          0.124s
           jira.ao_96e78c_issuetype          0         80     1.0 kB          0.288s
           jira.ao_96e78c_project_f          0         11     0.1 kB          0.092s
              jira.ao_96e78c_role_f          0         12     0.2 kB          0.111s
            jira.ao_96e78c_scheme_f          0         12     0.2 kB          0.161s
      jira.ao_97edab_userinvitation          0          7     1.0 kB          0.272s
jira.ao_a0b856_web_hook_listener_ao          0          0                     0.294s
              jira.ao_a29aea_config          0         26     0.7 kB          0.313s
            jira.ao_a29aea_exposure          0          4     0.1 kB          0.330s
    jira.ao_a29aea_exposure_mapping          0         25     0.4 kB          0.381s
         jira.ao_a29aea_exp_mapping          0          0                     0.426s
       jira.ao_a29aea_risk_register          0        131     1.2 kB          0.500s
        jira.ao_a406ed_access_group          0          1     0.0 kB          0.145s
         jira.ao_a406ed_access_role          0          1     0.0 kB          0.162s
         jira.ao_a406ed_access_user          0          0                     0.139s
         jira.ao_a406ed_acc_manager          0          0                     0.157s
      jira.ao_a406ed_acc_manager_v2          0          1     0.0 kB          0.289s
            jira.ao_a406ed_calendar          0         31     1.1 kB          0.340s
       jira.ao_a406ed_calendar_date          0         54     2.7 kB          0.384s
       jira.ao_a406ed_created_issue          0       3273    51.2 kB          0.116s
               jira.ao_a406ed_field          0          0                     0.035s
            jira.ao_a406ed_field_v2          0       1516   121.8 kB          0.173s
  jira.ao_a406ed_fire_history_entry          0          0                     0.089s
     jira.ao_a406ed_fire_history_v2          0       2734   336.7 kB          0.419s
     jira.ao_a406ed_fire_history_v3          0       3370   627.1 kB          0.126s
               jira.ao_a406ed_param          0          0                     0.050s
            jira.ao_a406ed_param_v1          0          0                     0.094s
            jira.ao_a406ed_param_v2          0       1941    96.1 kB          0.275s
     jira.ao_a406ed_scheduled_issue          0          0                     0.036s
  jira.ao_a406ed_scheduled_issue_v2          0         96     3.0 kB          0.099s
       jira.ao_a406ed_scheduled_job          0        100    19.7 kB          0.098s
   jira.ao_a406ed_scheduled_subtask          0          4     0.1 kB          0.190s
        jira.ao_a406ed_shared_group          0          1     0.0 kB          0.206s
         jira.ao_a406ed_shared_role          0         46     0.5 kB          0.224s
         jira.ao_a406ed_shared_user          0          8     0.3 kB          0.243s
           jira.ao_a406ed_share_job          0         58     0.6 kB          0.394s
            jira.ao_a406ed_share_si          0          0                     0.077s
          jira.ao_a406ed_si_subtask          0          3     0.0 kB          0.098s
             jira.ao_a406ed_trigger          0          0                     0.125s
          jira.ao_a406ed_trigger_v2          0          0                     0.202s
          jira.ao_a406ed_trigger_v3          0         90     8.1 kB          0.277s
          jira.ao_a406ed_trigger_v4          0         98     8.7 kB          0.068s
           jira.ao_a415df_aoability          0         84     1.5 kB          0.105s
           jira.ao_a415df_aoabsence          0          0                     0.080s
      jira.ao_a415df_aoavailability          0          0                     0.100s
     jira.ao_a415df_aoconfiguration          0          1     0.0 kB          0.120s
    jira.ao_a415df_aocustom_wording          0          0                     0.139s
        jira.ao_a415df_aodependency          0          0                     0.158s
         jira.ao_a415df_aodoor_stop          0          1     0.0 kB          0.256s
          jira.ao_a415df_aoestimate          0        104     2.9 kB          0.398s
    jira.ao_a415df_aoextension_link          0        254    29.6 kB          0.104s
  jira.ao_a415df_aonon_working_days          0          0                     0.102s
        jira.ao_a415df_aopermission          0        131     6.6 kB          0.366s
            jira.ao_a415df_aoperson          0         26     1.2 kB          0.055s
              jira.ao_a415df_aoplan          0         12     0.7 kB          0.100s
jira.ao_a415df_aoplan_configuration          0         12     1.4 kB          0.193s
          jira.ao_a415df_aopresence          0          0                     0.224s
           jira.ao_a415df_aorelease          0         25     1.7 kB          0.264s
        jira.ao_a415df_aoreplanning          0          0                     0.322s
          jira.ao_a415df_aoresource          0         27     0.6 kB          0.404s
             jira.ao_a415df_aoskill          0         23     0.9 kB          0.468s
    jira.ao_a415df_aosolution_store          0         11   421.8 kB          0.568s
            jira.ao_a415df_aosprint          0          0                     0.568s
             jira.ao_a415df_aostage          0         26     1.1 kB          0.588s
            jira.ao_a415df_aostream          0         13     0.6 kB          0.607s
    jira.ao_a415df_aostream_to_team          0          0                     0.625s
              jira.ao_a415df_aoteam          0          7     0.5 kB          0.853s
             jira.ao_a415df_aotheme          0         23     1.6 kB          0.868s
         jira.ao_a415df_aowork_item          0        314    45.5 kB          0.915s
  jira.ao_a415df_aowork_item_to_res          0          0                     0.171s
 jira.ao_a44657_health_check_entity          0          0                     0.376s
        jira.ao_a83c21_pdf_resource          0         29   465.5 kB          0.441s
            jira.ao_a83c21_pdf_view          0         15     2.1 kB          0.435s
          jira.ao_aefed0_membership          0        110     2.1 kB          0.503s
           jira.ao_aefed0_pgp_group          0          4     0.1 kB          0.040s
          jira.ao_aefed0_pgp_member          0          1     0.0 kB          0.110s
  jira.ao_aefed0_pgp_membership_idx          0          0                     0.176s
      jira.ao_aefed0_pgp_permission          0         58     2.9 kB          0.263s
             jira.ao_aefed0_program          0          1     0.1 kB          0.040s
                jira.ao_aefed0_team          0          1     0.0 kB          0.116s
           jira.ao_aefed0_team_link          0          5     0.1 kB          0.172s
         jira.ao_aefed0_team_member          0          2     0.1 kB          0.201s
      jira.ao_aefed0_team_member_v2          0        111     4.8 kB          0.287s
     jira.ao_aefed0_team_permission          0          1     0.1 kB          0.112s
           jira.ao_aefed0_team_role          0         22     0.7 kB          0.180s
      jira.ao_aefed0_team_to_member          0          2     0.0 kB          0.229s
             jira.ao_aefed0_team_v2          0          7     0.4 kB          0.252s
          jira.ao_aefed0_user_index          0       5158  1020.9 kB          0.517s
   jira.ao_b300f0_field_config_item          0          0                     0.046s
    jira.ao_b9a0f0_applied_template          0        866    99.1 kB          0.306s
      jira.ao_bee373_internal_issue          0          0                     0.063s
            jira.ao_c16815_alert_ao          0        447    15.0 MB          1.397s
          jira.ao_c3c6e8_account_v1          0          0                     0.188s
              jira.ao_c3c6e8_budget          0          0                     0.207s
       jira.ao_c3c6e8_category_type          0          4     0.2 kB          0.240s
         jira.ao_c3c6e8_category_v1          0          0                     0.329s
 jira.ao_c3c6e8_customer_permission          0          0                     0.401s
         jira.ao_c3c6e8_customer_v1          0          0                     0.437s
             jira.ao_c3c6e8_link_v1          0          0                     0.456s
                jira.ao_c3c6e8_rate          0          1     0.0 kB          0.473s
          jira.ao_c3c6e8_rate_table          0          1     0.1 kB          0.557s
   jira.ao_cbc281_def_lib_for_group          0          0                     0.645s
jira.ao_cbc281_drawio_configuration          0          1     0.0 kB          0.700s
        jira.ao_cbc281_drawio_draft          0         22   115.5 kB          0.779s
      jira.ao_cbc281_drawio_library          0          0                     0.800s
   jira.ao_ce20b8_pcf_ugppro_config          0          0                     0.826s
          jira.ao_ce20b8_soc_config          0          0                     0.851s
      jira.ao_cf468e_bar_attributes          0         65     5.9 kB          0.962s
      jira.ao_cf468e_bar_dependency          0          0                     0.067s
            jira.ao_cf468e_baseline          0          2   216.0 kB          0.165s
           jira.ao_cf468e_bootstrap          0          1     0.0 kB          0.218s
               jira.ao_cf468e_gantt          0         89    14.5 kB          0.271s
        jira.ao_cf468e_gantt_config          0         46    55.3 kB          0.116s
       jira.ao_cf468e_leveling_data          0          8     0.5 kB          0.142s
 jira.ao_cf468e_resource_attributes          0          2     0.2 kB          0.178s
       jira.ao_cf468e_work_calendar          0          2     0.6 kB          0.202s
jira.ao_cff990_aotransition_failure          0          0                     0.222s
  jira.ao_d53e8e_jcpp_global_config          0          0                     0.311s
          jira.ao_d9132d_assignment          0          0                     0.333s
      jira.ao_d9132d_assignment_ext          0      12767     1.4 MB          0.871s
       jira.ao_d9132d_configuration          0          1     0.0 kB          0.041s
jira.ao_d9132d_dep_issue_link_types          0         22     0.2 kB          0.058s
        jira.ao_d9132d_distribution          0         30     1.6 kB          0.109s
   jira.ao_d9132d_excluded_versions          0       1432    20.1 kB          0.618s
       jira.ao_d9132d_genericreport          0         45   136.9 kB          0.072s
    jira.ao_d9132d_hierarchy_config          0          6     0.2 kB          0.086s
                jira.ao_d9132d_init          0         17     0.5 kB          0.116s
        jira.ao_d9132d_issue_source          0        204     4.5 kB          0.316s
      jira.ao_d9132d_nonworkingdays          0          0                     0.031s
         jira.ao_d9132d_permissions          0        210     8.8 kB          0.104s
                jira.ao_d9132d_plan          0        136    21.8 kB          0.108s
           jira.ao_d9132d_planskill          0          4     0.1 kB          0.073s
            jira.ao_d9132d_planteam          0        189     5.2 kB          0.167s
           jira.ao_d9132d_plantheme          0         22     0.4 kB          0.061s
         jira.ao_d9132d_planversion          0         78     1.9 kB          0.200s
   jira.ao_d9132d_plan_custom_field          0         27     0.6 kB          0.139s
  jira.ao_d9132d_plan_us_pr_mapping          0          0                     0.166s
             jira.ao_d9132d_program          0         15     0.9 kB          0.186s
jira.ao_d9132d_program_custom_field          0          7     0.1 kB          0.210s
           jira.ao_d9132d_rank_item          0        356    29.0 kB          0.392s
          jira.ao_d9132d_saved_view          0          0                     0.168s
            jira.ao_d9132d_scenario          0        145     3.0 kB          0.273s
    jira.ao_d9132d_scenario_ability          0         11     2.7 kB          0.101s
    jira.ao_d9132d_scenario_avlblty          0          0                     0.198s
    jira.ao_d9132d_scenario_changes          0        241     4.9 kB          0.402s
     jira.ao_d9132d_scenario_issues          0       1575   367.8 kB          0.294s
jira.ao_d9132d_scenario_issue_cmpnt          0          7     0.1 kB          0.099s
jira.ao_d9132d_scenario_issue_label          0          0                     0.336s
jira.ao_d9132d_scenario_issue_links          0         15     2.5 kB          0.611s
  jira.ao_d9132d_scenario_issue_res          0        104     4.5 kB          0.864s
     jira.ao_d9132d_scenario_person          0         34     5.7 kB          0.040s
   jira.ao_d9132d_scenario_resource          0        117    21.7 kB          0.139s
      jira.ao_d9132d_scenario_skill          0         20     3.6 kB          0.198s
      jira.ao_d9132d_scenario_stage          0         10     1.6 kB          0.348s
       jira.ao_d9132d_scenario_team          0         53     7.9 kB          0.520s
      jira.ao_d9132d_scenario_theme          0         18     2.9 kB          0.164s
    jira.ao_d9132d_scenario_version          0        142    30.0 kB          0.497s
  jira.ao_d9132d_scenario_xpversion          0          9     1.4 kB          0.132s
  jira.ao_d9132d_scen_cstm_fld_mval          0          0                     0.235s
   jira.ao_d9132d_scen_custom_field          0          0                     0.350s
 jira.ao_d9132d_scen_team_ex_sprint          0          2     0.0 kB          0.401s
       jira.ao_d9132d_shared_report          0          9     2.0 kB          0.547s
            jira.ao_d9132d_solution          0        164     1.2 MB          0.754s
               jira.ao_d9132d_stage          0          6     0.1 kB          0.103s
      jira.ao_d9132d_team_ex_sprint          0          2     0.0 kB          0.122s
               jira.ao_d9132d_theme          0         22     0.4 kB          0.258s
  jira.ao_d9132d_version_enrichment          0         91     1.1 kB          0.417s
   jira.ao_d9132d_x_project_version          0          7     0.1 kB          0.085s
        jira.ao_da6ab9_app_property          0          1     0.0 kB          0.143s
               jira.ao_da6ab9_audit          0          0                     0.168s
         jira.ao_da6ab9_context_key          0          6     0.1 kB          0.190s
   jira.ao_da6ab9_statistics_record          0          0                     0.217s
            jira.ao_da6ab9_template          0         10     2.0 kB          0.285s
          jira.ao_da6ab9_templateck          0         10     0.1 kB          0.357s
         jira.ao_db6376_wd_calendar          0          4     0.1 kB          0.379s
     jira.ao_db6376_wd_calendar_day          0         28     0.6 kB          0.406s
 jira.ao_db6376_wd_calendar_day_off          0          0                     0.449s
             jira.ao_e24dea_holiday          0          0                     0.530s
   jira.ao_e24dea_timesheet_job_cfg          0         10     1.7 kB          0.563s
      jira.ao_e24dea_timesheet_pref          0         13     0.6 kB          0.583s
    jira.ao_e30806_available_scheme          0          0                     0.606s
           jira.ao_e30806_bundlestr          0         12     0.3 kB          0.684s
        jira.ao_e30806_bundle_issue          0         59     0.9 kB          0.874s
          jira.ao_e30806_bundle_map          0         57     5.1 kB          0.192s
        jira.ao_e30806_custom_field          0          0                     0.068s
    jira.ao_e30806_delegation_group          0          0                     0.085s
          jira.ao_e30806_field_info          0          0                     0.118s
 jira.ao_e30806_general_config_info          0          0                     0.173s
           jira.ao_e30806_lock_info          0          0                     0.194s
          jira.ao_e30806_permission          0          0                     0.216s
             jira.ao_e30806_project          0          0                     0.263s
       jira.ao_e30806_project_audit          0          0                     0.292s
 jira.ao_e30806_specific_permission          0         71     2.0 kB          0.403s
      jira.ao_e30806_stop_proj_info          0          0                     0.047s
             jira.ao_e30806_tracker          0          9     0.1 kB          0.066s
         jira.ao_e30806_undo_entity          0        187    36.4 kB          0.106s
              jira.ao_e8b6cc_branch          0         24     0.3 kB          0.059s
 jira.ao_e8b6cc_branch_head_mapping          0         24     1.3 kB          0.131s
   jira.ao_e8b6cc_changeset_mapping          0        503     1.3 MB          0.470s
              jira.ao_e8b6cc_commit          0          5     0.5 kB          0.042s
       jira.ao_e8b6cc_git_hub_event          0        370    12.4 kB          0.132s
     jira.ao_e8b6cc_issue_to_branch          0          0                     0.150s
  jira.ao_e8b6cc_issue_to_changeset          0        154     3.4 kB          0.293s
             jira.ao_e8b6cc_message          0          0                     0.051s
  jira.ao_e8b6cc_message_queue_item          0          0                     0.155s
         jira.ao_e8b6cc_message_tag          0          0                     0.224s
jira.ao_e8b6cc_organization_mapping          0          3     0.5 kB          0.339s
      jira.ao_e8b6cc_org_to_project          0          0                     0.406s
        jira.ao_e8b6cc_pr_issue_key          0          0                     0.454s
      jira.ao_e8b6cc_pr_participant          0          3     0.1 kB          0.493s
        jira.ao_e8b6cc_pr_to_commit          0          5     0.0 kB          0.598s
        jira.ao_e8b6cc_pull_request          0          3     0.5 kB          0.705s
  jira.ao_e8b6cc_repository_mapping          0          5     0.4 kB          0.809s
   jira.ao_e8b6cc_repo_to_changeset          0        504     4.7 kB          0.943s
     jira.ao_e8b6cc_repo_to_project          0          0                     0.073s
      jira.ao_e8b6cc_sync_audit_log          0        503    47.3 kB          0.185s
          jira.ao_e8b6cc_sync_event          0          0                     0.043s
     jira.ao_ed669c_seen_assertions          0          0                     0.069s
      jira.ao_f1b27b_history_record          0          0                     0.090s
       jira.ao_f1b27b_key_component          0          0                     0.111s
    jira.ao_f1b27b_key_comp_history          0          0                     0.263s
             jira.ao_f1b27b_promise          0          0                     0.364s
     jira.ao_f1b27b_promise_history          0          0                     0.388s
                      jira.app_user          0      13852   844.2 kB          0.795s
           jira.audit_changed_value          0     287462    36.8 MB          4.605s
                    jira.audit_item          0     203878    15.8 MB          2.807s
                     jira.audit_log          0     276222    98.1 MB         11.181s
                        jira.avatar          0       4203   301.6 kB          0.106s
                         jira.board          0          0                     0.182s
                  jira.boardproject          0          0                     0.303s
                        jira.ccb_d3          0          3     0.2 kB          0.444s
                   jira.changegroup          0    7304301   462.9 MB        1m4.723s
                    jira.changeitem          0    9332879     1.6 GB        4m9.201s
                  jira.clusteredjob          0        365   320.7 kB          0.255s
             jira.clusterlockstatus          0          0                     0.204s
                jira.clustermessage          0          0                     0.416s
                   jira.clusternode          0          0                     0.609s
          jira.clusternodeheartbeat          0          0                     0.781s
           jira.clusterupgradestate          0          0                     0.977s
                  jira.columnlayout          0      11423   201.0 kB          1.472s
              jira.columnlayoutitem          0     141301     3.5 MB          2.566s
                     jira.component          0       3465   198.1 kB          0.707s
          jira.configurationcontext          0       3987   144.2 kB          0.685s
                   jira.customfield          0       1316   261.8 kB          1.267s
             jira.customfieldoption          0      11157   538.4 kB          1.346s
              jira.customfieldvalue          0   13824552   890.9 MB       2m52.459s
               jira.cwd_application          0          7     1.0 kB          0.285s
       jira.cwd_application_address          0         20     0.4 kB          0.315s
                 jira.cwd_directory          0          1     0.2 kB          0.433s
       jira.cwd_directory_attribute          0          2     0.1 kB          0.621s
       jira.cwd_directory_operation          0         12     0.2 kB          0.836s
                     jira.cwd_group          0       2155   231.5 kB          1.104s
          jira.cwd_group_attributes          0          0                     0.256s
                jira.cwd_membership          0      36736     4.8 MB          1.763s
                      jira.cwd_user          0      13015     4.3 MB          1.838s
           jira.cwd_user_attributes          0     114281     6.7 MB          3.726s
                    jira.deadletter          0          0                     0.685s
           jira.draftworkflowscheme          0          6     0.4 kB          0.998s
     jira.draftworkflowschemeentity          0         30     1.4 kB          1.442s
               jira.entity_property          0     143936    16.6 MB          8.066s
jira.entity_property_index_document          0          5     2.7 kB          0.330s
            jira.entity_translation          0          0                     0.644s
                jira.externalgadget          0          3     0.4 kB          1.081s
             jira.external_entities          0        203    12.3 kB          1.527s
         jira.favouriteassociations          0      20121     1.1 MB          0.901s
                       jira.feature          0         28     2.1 kB          0.411s
             jira.fieldconfigscheme          0       2457   223.4 kB          0.896s
    jira.fieldconfigschemeissuetype          0       3185    66.8 kB          0.568s
            jira.fieldconfiguration          0       3911   401.6 kB          0.665s
                   jira.fieldlayout          0        204    13.8 kB          0.312s
               jira.fieldlayoutitem          0     221767    22.0 MB          6.618s
             jira.fieldlayoutscheme          0        125     6.3 kB          0.485s
  jira.fieldlayoutschemeassociation          0          0                     0.278s
       jira.fieldlayoutschemeentity          0        313     6.5 kB          0.603s
                   jira.fieldscreen          0       2113    95.4 kB          0.564s
         jira.fieldscreenlayoutitem          0      36003   947.5 kB          1.481s
             jira.fieldscreenscheme          0       1586    68.7 kB          0.706s
         jira.fieldscreenschemeitem          0       1957    39.8 kB          0.564s
                jira.fieldscreentab          0       2630    69.7 kB          0.393s
                jira.fileattachment          0     295320    39.2 MB         15.422s
            jira.filtersubscription          0        233    16.8 kB          0.703s
          jira.gadgetuserpreference          0      67895     2.3 MB          2.255s
          jira.genericconfiguration          0        799    69.5 kB          0.587s
         jira.globalpermissionentry          0         63     3.4 kB          0.376s
                     jira.groupbase          0          0                     0.226s
                     jira.issuelink          0     525047    14.7 MB          7.014s
                 jira.issuelinktype          0         34     2.0 kB          0.599s
           jira.issuesecurityscheme          0         19     0.9 kB          0.809s
                   jira.issuestatus          0       1097    81.0 kB          1.140s
                     jira.issuetype          0        311    32.7 kB          0.399s
         jira.issuetypescreenscheme          0        626    30.5 kB          0.405s
   jira.issuetypescreenschemeentity          0       1951    40.7 kB          0.613s
            jira.issue_field_option          0          0                     0.446s
      jira.issue_field_option_scope          0          0                     0.713s
                    jira.jiraaction          0     868963   317.5 MB         52.201s
            jira.jiradraftworkflows          0        202     3.9 MB          1.862s
                 jira.jiraeventtype          0         52     3.5 kB          1.482s
                     jira.jiraissue          0     787751   434.3 MB        1m6.089s
                     jira.jiraperms          0          0                     0.238s
                 jira.jiraworkflows          0       1267    20.7 MB         13.626s
          jira.jiraworkflowstatuses          0          0                     2.277s
         jira.jquartz_blob_triggers          0          0                     2.534s
             jira.jquartz_calendars          0          0                     2.828s
         jira.jquartz_cron_triggers          0         38     4.7 kB          3.151s
        jira.jquartz_fired_triggers          0          0                     3.498s
           jira.jquartz_job_details          0          8     5.6 kB          3.873s
         jira.jquartz_job_listeners          0          0                     4.196s
                 jira.jquartz_locks          0          5     0.1 kB          4.654s
   jira.jquartz_paused_trigger_grps          0          0                     4.937s
       jira.jquartz_scheduler_state          0          0                     5.431s
       jira.jquartz_simple_triggers          0          6     0.7 kB          5.921s
      jira.jquartz_simprop_triggers          0          0                     6.253s
              jira.jquartz_triggers          0         44    57.1 kB          6.479s
     jira.jquartz_trigger_listeners          0          0                     6.803s
                   jira.kissuestate          0          0                     7.172s
                      jira.kplugins          0          2     0.0 kB          7.659s
                   jira.kpluginscfg          0         29     2.4 kB          7.920s
                   jira.krssecurity          0          0                     8.163s
                 jira.krunnablesils          0          0                     8.396s
                  jira.kstatevalues          0          0                     8.600s
                         jira.label          0     506458    14.2 MB         16.227s
           jira.licenserolesdefault          0          1     0.0 kB          0.801s
             jira.licenserolesgroup          0          7     0.3 kB          1.125s
                jira.listenerconfig          0          3     0.3 kB          1.406s
                    jira.mailserver          0          1     0.1 kB          1.789s
      jira.managedconfigurationitem          0         42     5.9 kB          2.079s
                jira.membershipbase          0          0                     2.417s
               jira.moved_issue_key          0      18390   410.3 kB          3.548s
               jira.nodeassociation          0     597951    26.4 MB          9.980s
              jira.nodeindexcounter          0          0                     0.290s
                  jira.notification          0       1624    66.1 kB          0.654s
          jira.notificationinstance          0          0                     0.504s
            jira.notificationscheme          0         42     2.6 kB          0.719s
                 jira.oauthconsumer          0          1     1.2 kB          0.915s
            jira.oauthconsumertoken          0        258    39.0 kB          1.291s
               jira.oauthspconsumer          0         12     3.8 kB          0.248s
                  jira.oauthsptoken          0       1316   360.3 kB          0.910s
           jira.optionconfiguration          0       4837   130.3 kB          0.542s
                jira.os_currentstep          0     788016    41.3 MB          9.981s
           jira.os_currentstep_prev          0    2017631    29.6 MB          9.406s
                jira.os_historystep          0    2657870   227.6 MB         39.583s
           jira.os_historystep_prev          0    1493533    21.8 MB         13.932s
                    jira.os_wfentry          0    1516664    78.5 MB         19.878s
              jira.permissionscheme          0         76     8.2 kB          0.106s
     jira.permissionschemeattribute          0          2     0.1 kB          0.091s
                   jira.pluginstate          0         59     2.6 kB          0.444s
                 jira.pluginversion          0        322    33.5 kB          0.313s
                    jira.portalpage          0       1803   145.3 kB          0.221s
          jira.portletconfiguration          0       9259     1.2 MB          0.435s
                      jira.priority          0         32     2.8 kB          0.200s
                jira.productlicense          0          2     1.2 kB          0.336s
                       jira.project          0        661    70.6 kB          0.512s
               jira.projectcategory          0         27     1.4 kB          0.137s
            jira.projectchangedtime          0          0                     0.232s
                   jira.projectrole          0         14     1.5 kB          0.387s
              jira.projectroleactor          0      11754   800.3 kB          0.836s
                jira.projectversion          0       7977   740.7 kB          0.603s
                   jira.project_key          0        703    12.3 kB          0.249s
                  jira.propertydata          0          0                     0.161s
                  jira.propertydate          0          1     0.0 kB          0.229s
               jira.propertydecimal          0          0                     0.254s
                 jira.propertyentry          0     326657    19.5 MB          4.850s
                jira.propertynumber          0     126079     1.4 MB          2.011s
                jira.propertystring          0      91159     4.1 MB          2.235s
                  jira.propertytext          0     110026    22.2 MB          6.015s
                jira.qrtz_calendars          0          0                     0.313s
            jira.qrtz_cron_triggers          0         18     0.5 kB          0.460s
           jira.qrtz_fired_triggers          0          0                     0.572s
              jira.qrtz_job_details          0          1     0.1 kB          0.645s
            jira.qrtz_job_listeners          0          0                     0.707s
          jira.qrtz_simple_triggers          0          0                     0.772s
                 jira.qrtz_triggers          0         18     1.9 kB          0.874s
        jira.qrtz_trigger_listeners          0          0                     0.920s
             jira.reindex_component          0         18     0.5 kB          1.016s
               jira.reindex_request          0          9     0.7 kB          1.130s
               jira.remembermetoken          0       2042   198.6 kB          1.396s
                    jira.remotelink          0      68379    13.8 MB          1.663s
      jira.replicatedindexoperation          0          0                     0.046s
                    jira.resolution          0         34     1.4 kB          0.104s
                    jira.rundetails          0        481    46.8 kB          0.348s
         jira.schemeissuesecurities          0        153     6.3 kB          0.324s
     jira.schemeissuesecuritylevels          0         60     2.1 kB          0.273s
             jira.schemepermissions          0       4229   222.6 kB          0.323s
                 jira.searchrequest          0      20972     5.4 MB          1.560s
           jira.sequence_value_item          0        121     2.6 kB          0.206s
                 jira.serviceconfig          0          2     0.2 kB          0.186s
              jira.sharepermissions          0      16037   771.3 kB          0.544s
        jira.tempattachmentsmonitor          0          8     1.1 kB          0.046s
                jira.trackback_ping          0          0                     0.082s
                    jira.trustedapp          0          0                     0.107s
                jira.upgradehistory          0        172    13.0 kB          0.157s
            jira.upgradetaskhistory          0         36     1.7 kB          0.250s
    jira.upgradetaskhistoryauditlog          0         39     2.8 kB          0.290s
         jira.upgradeversionhistory          0         10     0.4 kB          0.256s
               jira.userassociation          0    1182947    87.7 MB         14.869s
                      jira.userbase          0          0                     0.053s
               jira.userhistoryitem          0     235990    16.0 MB          6.248s
              jira.userpickerfilter          0          6     0.1 kB          0.433s
         jira.userpickerfiltergroup          0          8     0.2 kB          0.670s
          jira.userpickerfilterrole          0          1     0.0 kB          0.977s
                jira.versioncontrol          0          0                     1.269s
                   jira.votehistory          0       1405    47.9 kB          1.698s
                jira.workflowscheme          0        929   151.0 kB          0.499s
          jira.workflowschemeentity          0       2248   104.7 kB          0.529s
                       jira.worklog          0     238851    42.5 MB          9.980s
-----------------------------------  ---------  ---------  ---------  --------------
            COPY Threads Completion          0          2                 28m55.376s
                     Create Indexes          0       2198                 31m38.614s
             Index Build Completion          0       2198                     1.710s
                    Reset Sequences          0        759                     2.562s
                       Primary Keys          0        966                     3.087s
                Create Foreign Keys          0        323                     4.717s
                    Create Triggers          0          0                     0.003s
                    Set Search Path          0          1                     0.003s
                   Install Comments          0          0                     0.000s
-----------------------------------  ---------  ---------  ---------  --------------
                  Total import time          ✓   83025740    10.0 GB       1h46.072s