User Tools

Site Tools


reference:sent_message_summary

Sent message summary

This will display the number of messages sent and total size over the past month. (It counts each recipient as its own message). You must have Historical Logging enabled in VPOP3 (Settings → Logging)

At a command prompt in the VPOP3 directory run

psql

(The password is 'vpop3pass')

Then, type

select count(*),pg_size_pretty(sum(size)) from logdb.recipients r inner join logdb.messages m using (msgid) 
inner join logdb.sessions s using (sessid) where sesstype IN ('C','M') and 
m.datetime>(now()- interval '1 month');

N.B. VPOP3 does not need to be stopped while you do this

reference/sent_message_summary.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1