The postgres db for das is around 250 GB in which the table query_detail is alone 220 Gb filling up my disk space. How can I control this? Can I delete this table?
Please refer below doc to clean old queries.
Can I delete this table?
select pg_size_pretty(pg_total_relation_size('query_details')); -- run this query to check the table size.
Thank you for your reply @balajip .
The output of the below query is 220GB.
Do I need to Truncate the table first before adding the new properties in Data Analytics Studio Event Processor config file template.
And how long will it take to Truncate this table.