User Tools

Site Tools


reference:find_biggest_messages

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

reference:find_biggest_messages [2019/07/08 08:19] (current)
paul created
Line 1: Line 1:
 +======Find biggest messages======
  
 +To find the 10 biggest messages in your VPOP3 message store:
 +
 +Go to Settings → Database → Query
 +
 +Alternatively,​ at a command prompt in the VPOP3 directory run
 +
 +  psql
 +(The password is '​vpop3pass'​)
 +
 +Then, type
 +
 +<​code>​
 +SELECT username, folder, subject, fromaddr, PG_SIZE_PRETTY(size) FROM messages.messages INNER JOIN messages.folders f USING(folderid) INNER JOIN users.users u ON u.usernumber=f.userid ORDER BY size DESC LIMIT 10;
 +</​code>​
 +
 +N.B. VPOP3 does not need to be stopped while you do this
reference/find_biggest_messages.txt · Last modified: 2019/07/08 08:19 by paul