Postgres activity log

pg_stat_activity_log

# Put this file in /etc/cron.d/

# Setup:
# sudo -u postgres psql -c "create table activity_log as select now(), * from pg_stat_activity limit 0; create index activity_log_idx on activity_log (now);"

* * * * * postgres psql -q -c "insert into activity_log select now(), * from pg_stat_activity;"
0 0 * * * postgres psql -q -c "delete from activity_log where now < now() - interval '7 days';"