pgBadger can parse PostgreSQL log files to produce daily and weekly statistical reports from many points of view.