#!/bin/sh

dbname="zabbix"
username="postgres"
psql $dbname $username << EOF
SELECT table_name, pg_relation_size(quote_ident(table_name))
from information_schema.tables
where table_schema = 'public'
order by 2;
TRUNCATE history_uint;
TRUNCATE history_text;
TRUNCATE history;
TRUNCATE trends_uint;
TRUNCATE trends;
TRUNCATE events CASCADE;
TRUNCATE auditlog CASCADE;
TRUNCATE sessions;
TRUNCATE housekeeper;
VACUUM ANALYZE;
VACUUM;
VACUUM FULL;
update triggers set value = 0 where value=1;
EOF