This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
sql_analysis_dedup_attachments [2014/09/01 23:00] daniel created |
sql_analysis_dedup_attachments [2018/09/09 19:53] (current) daniel |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Attachments deduplication ====== | ||
+ | |||
Attachments are stored into 3 tables: ''attachments'', ''attachment_contents'' and the ''pg_largeobject'' system table. | Attachments are stored into 3 tables: ''attachments'', ''attachment_contents'' and the ''pg_largeobject'' system table. | ||
Line 13: | Line 15: | ||
</code> | </code> | ||
- | This query retrieves, within the top 30 of the most deduplicated attachments (in number of occurrences), the count and sizes of attachments with file names and a significant size: | + | The following query retrieves, within the top 30 of the most deduplicated attachments (in number of occurrences), the count and sizes of attachments with file names and a significant size: |
<code sql> | <code sql> | ||
select filename,count(*),content_size | select filename,count(*),content_size |