Where did the space on the Confluence server go? Or Confluence statistics on attachments
Have you ever encountered a situation where your Confluence server ran out of space and you didn't know who was uploading the most attachments? To find this out, you need access to the PostgreSQL database of Confluence. With an SQL query to the PostgreSQL database, you can obtain useful statistics about Confluence. Total size of all attachments in Confluence: SELECT s.spaceid, s.spacename, sum(LONGVAL) FROM contentproperties c JOIN […]
