Have you ever run out of space on your Confluence server, but you don’t know who is downloading the most attachments?

To find out, you need access to the PostgreSQL confluence database.

Using SQL query to PostgreSQL database, you can find useful statistics on Confluence.

Total size of all attachments in Confluence:

Output (spacename replaced):

Pages with most historical versions in conjunction:

Output:

The largest attachment files in your Confluence instance

Output:

The number of pages in the basket and the total size of pages in the basket per space:

Output:

Total size of attachments downloaded by each user on all pages

Output: