This documentation aims to guide our customers in checking the amount of data they have for each Xray issue type. It also helps assess the size of their Jira instance, providing insight into the volume of data to be migrated to the Cloud.

To check the size of your data, run the following queries in your database:

select count(*) from jiraissue j join issuetype as it on (it.id=j.issuetype) where it.pname='Test';
select count(*) from jiraissue j join issuetype as it on (it.id=j.issuetype) where it.pname in ('Test Execution', 'Sub Test Execution');
select count(*) from jiraissue j join issuetype as it on (it.id=j.issuetype) where it.pname='Test Plan';
select count(*) from "AO_8B1069_TEST_RUN";
select count(*) from jiraissue j join issuetype as it on (it.id=j.issuetype) where it.pname in ('Test Execution', 'Sub Test Execution');
select count(*) from jiraissue j join issuetype as it on (it.id=j.issuetype) where it.pname='Test Plan';
select count(*) from "AO_8B1069_TEST_RUN";

For the Attachment size, please check: How to get Xray Attachments size info on Jira Data Center?