[ovirt-users] oVirt Manager problem
Massimo Mad
mad1969it at gmail.com
Wed Feb 25 09:14:28 UTC 2015
Hi,
Here is the result of the command actually tables "audit_log" are very large
.
What can I do to prevent the file system fills up?
psql engine -c "SELECT nspname || '.' || relname AS relation,
pg_size_pretty(pg_relation_size(C.oid)) AS size
FROM pg_class C
LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
WHERE nspname NOT IN ('pg_catalog', 'information_schema')
ORDER BY pg_relation_size(C.oid) DESC
LIMIT 20;"
relation | size
------------------------------------------+---------
public.audit_log | 826 MB
public.idx_audit_correlation_id | 159 MB
public.idx_audit_log_job_id | 114 MB
public.idx_audit_log_storage_domain_name | 114 MB
public.idx_audit_log_user_name | 114 MB
public.idx_audit_log_vm_name | 114 MB
public.idx_audit_log_storage_pool_name | 114 MB
public.idx_audit_log_vds_name | 114 MB
public.idx_audit_log_vm_template_name | 113 MB
public.pk_audit_log | 90 MB
public.idx_audit_log_log_time | 90 MB
pg_toast.pg_toast_2618 | 1336 kB
public.vm_dynamic | 680 kB
public.vm_statistics | 496 kB
public.disk_image_dynamic | 288 kB
public.vds_interface_statistics | 256 kB
public.vm_device | 208 kB
public.vds_dynamic | 128 kB
pg_toast.pg_toast_2619 | 120 kB
public.pk_disk_image_dynamic | 104 kB
(20 rows)
Regards Massimo
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20150225/11f00461/attachment-0001.html>
More information about the Users
mailing list