<div dir="ltr"><div>Hi,<br><span id="result_box" class="" lang="en"><span class="">Here is the result</span> <span class="">of the command</span> <span class="">actually</span> <span class="">tables</span> <span class="">&quot;</span><span class="">audit_log</span><span class="">&quot;</span> <span class="">are very</span> <span class="">large</span><span>.</span><br> <span class="">What can I do</span> <span class="">to prevent the</span> <span class="">file system</span> <span class="">fills up</span><span class="">?</span></span><br><br>psql engine -c &quot;SELECT nspname || &#39;.&#39; || relname AS relation,<br>     pg_size_pretty(pg_relation_size(C.oid)) AS size<br>   FROM pg_class C<br>   LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)<br>   WHERE nspname NOT IN (&#39;pg_catalog&#39;, &#39;information_schema&#39;)<br>   ORDER BY pg_relation_size(C.oid) DESC<br>   LIMIT 20;&quot;<br>    <br>                     relation                 |  size<br>------------------------------------------+---------<br> public.audit_log                         | 826 MB<br> public.idx_audit_correlation_id          | 159 MB<br> public.idx_audit_log_job_id              | 114 MB<br> public.idx_audit_log_storage_domain_name | 114 MB<br> public.idx_audit_log_user_name           | 114 MB<br> public.idx_audit_log_vm_name             | 114 MB<br> public.idx_audit_log_storage_pool_name   | 114 MB<br> public.idx_audit_log_vds_name            | 114 MB<br> public.idx_audit_log_vm_template_name    | 113 MB<br> public.pk_audit_log                      | 90 MB<br> public.idx_audit_log_log_time            | 90 MB<br> pg_toast.pg_toast_2618                   | 1336 kB<br> public.vm_dynamic                        | 680 kB<br> public.vm_statistics                     | 496 kB<br> public.disk_image_dynamic                | 288 kB<br> public.vds_interface_statistics          | 256 kB<br> public.vm_device                         | 208 kB<br> public.vds_dynamic                       | 128 kB<br> pg_toast.pg_toast_2619                   | 120 kB<br> public.pk_disk_image_dynamic             | 104 kB<br>(20 rows)<br><br></div>Regards Massimo<br></div>