---
title: "[Xray DC] How to get Xray Attachments size info on Jira Data Center?"
canonical: "https://docs.getxray.app/space/ProductKB/46269215/%5BXray%20DC%5D%20How%20to%20get%20Xray%20Attachments%20size%20info%20on%20Jira%20Data%20Center%3F"
format: markdown
---
Sometimes, when talking about Xray attachments, it can be helpful to understand what is stored in Xray datatables and their size. 


With this simple SQL query, is possible to <u>know the size of attachments by project:</u>  


```sql
SELECT
    COUNT(*) AS num_attachments,
    AVG(CAST(ao.FILE_SIZE AS FLOAT) / 1048576) AS avg_filesize_Mb,
    SUM(CAST(ao.FILE_SIZE AS FLOAT) / 1048576) AS total_filesize_Mb,
    p.pname,
    p.pkey
FROM
    project p
JOIN
    jiraissue j ON p.id = j.project
JOIN
    AO_8B1069_ATTACHMENT ao ON ao.ISSUE_ID = j.id
GROUP BY
    p.pkey,
    p.pname;
```

  
<u>SQL for all projects:</u>

```sql
SELECT
  COUNT(*) AS num_attachments,
  SUM(CAST(file_size AS FLOAT) / (1024 * 1024)) AS total_size_MB
  FROM AO_8B1069_ATTACHMENT;
```


<u>SQL to know the size of each individual attachment by project:</u>


```sql
SELECT
    ao.FILE_NAME,
    CAST(ao.FILE_SIZE AS FLOAT) / 1048576 AS filesize_Mb,
    p.pname,
    p.pkey
FROM
    project p
JOIN
    jiraissue j ON p.id = j.project
JOIN
    AO_8B1069_ATTACHMENT ao ON ao.ISSUE_ID = j.id; 
```