reference:find_biggest_messages
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
| — | reference:find_biggest_messages [2019/07/08 09:19] (current) – created paul | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ======Find biggest messages====== | ||
| + | To find the 10 biggest messages in your VPOP3 message store: | ||
| + | |||
| + | Go to Settings → Database → Query | ||
| + | |||
| + | Alternatively, | ||
| + | |||
| + | psql | ||
| + | (The password is ' | ||
| + | |||
| + | Then, type | ||
| + | |||
| + | < | ||
| + | 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; | ||
| + | </ | ||
| + | |||
| + | N.B. VPOP3 does not need to be stopped while you do this | ||
reference/find_biggest_messages.txt · Last modified: 2019/07/08 09:19 by paul
Page Tools
