Technical Tip: How to manually clean FortiClient EMS event table and data

If the event table is quite big or it was never cleaned up successfully before, it is possible to show 'Server Error' when trying to manually clear all events in the FortiClient EMS log settings. 

Manually clean the event table via command, and the following command can be used.

sudo psql -U postgres -h localhost -d fcm_default -c "VACUUM FULL events;"

Completely removing the event table helps if the above command still does not work.

sudo psql -U postgres -h localhost -d fcm_default -c "TRUNCATE TABLE events;"

Run the below command to check the event table size after the cleanup.

psql -U postgres -d fcm_default -h localhost -Atc "SELECT
    schemaname AS schema_name,
    tablename AS table_name,
    pg_size_pretty(pg_total_relation_size(schemaname || '.' || tablename)) AS total_size,
    pg_relation_size(schemaname || '.' || tablename) AS table_size,
    pg_indexes_size(schemaname || '.' || tablename) AS indexes_size
FROM
    pg_tables
WHERE
    schemaname NOT IN ('pg_catalog', 'information_schema','sqitch') and tablename = 'events';"