#Connect directly to postgres at command line:
psql dbname username
psql dbname postgres
truncate table vse_visitor_events;

#Check storage status:
df -h

#Sort directories by size (use sudo?):
du --max-depth=1 --human-readable / | sort --human-numeric-sort

#In Postgres, list all databases and sizes:
SELECT pg_database.datname,
       pg_size_pretty(pg_database_size(pg_database.datname)) AS size
FROM pg_database;

#List all tables and sizes:
SELECT schemaname, tablename,
pg_size_pretty(size) AS size_pretty,
pg_size_pretty(total_size) AS total_size_pretty
FROM (SELECT *,
pg_relation_size(schemaname||'.'||tablename) AS size,
pg_total_relation_size(schemaname||'.'||tablename) AS total_size
FROM pg_tables) AS TABLES
ORDER BY total_size DESC;