Zabbix Cleanup - Revision history

Busk at 17:06, 3 February 2023

2023-02-03T17:06:09Z

2023-02-03T16:51:00Z

2022-09-29T17:36:38Z

2022-09-29T16:32:31Z

2022-09-29T16:31:25Z

2022-09-29T16:19:33Z

2022-09-23T14:11:51Z

2022-09-23T14:10:30Z

2022-09-23T14:08:32Z

2022-09-23T13:48:46Z

@@ Line 511: / Line 511: @@
 VACUUM FULL VERBOSE;
 REINDEX DATABASE zabbix;
 ```

@@ Line 414: / Line 414: @@
 # Drop and recreate all large tables and vacuum reindex
 ```
-DROP TABLE public.history_str
+DROP TABLE public.history_str;
-DROP TABLE public.history
+DROP TABLE public.history;
-DROP TABLE public.history_uint
+DROP TABLE public.history_uint;
-DROP TABLE public.history_text
+DROP TABLE public.history_text;
-DROP TABLE public.history_log
+DROP TABLE public.history_log;

@@ Line 513: / Line 513: @@
 ```
 ```
 select * from pg_stat_progress_create_index;

← Older revision		Revision as of 16:32, 29 September 2022
Line 517:		Line 517:
	select * from pg_stat_progress_vacuum;		select * from pg_stat_progress_vacuum;
	```		```
		+	- https://www.postgresql.org/docs/current/progress-reporting.html

@@ Line 511: / Line 511: @@
 VACUUM FULL VERBOSE;
 REINDEX DATABASE zabbix;
 ```

@@ Line 409: / Line 409: @@
 psql -U postgres zabbix -c 'DELETE FROM history_uint h WHERE ctid IN ( SELECT h.ctid FROM history_uint h LEFT JOIN items i ON i.itemid = h.itemid WHERE to_timestamp(h.clock) < (current_date - ((i.history)::interval)) LIMIT 500000);'
 ) 9>/var/lock/00-zabbix-history-purge.lock
 ```

← Older revision		Revision as of 14:11, 23 September 2022
Line 21:		Line 21:
	ORDER BY pg_table_size(C.oid)		ORDER BY pg_table_size(C.oid)
	DESC LIMIT 1;		DESC LIMIT 1;
		+
		+	SELECT relname, last_vacuum, last_autovacuum FROM pg_stat_user_tables;
		+
		+	SELECT reloptions FROM pg_class WHERE relname='my_table';

@@ Line 11: / Line 11: @@
 ```
 SELECT relname, n_dead_tup FROM pg_stat_user_tables WHERE relname like 'history%';
 select * from pg_stat_progress_vacuum;
@@ Line 22: / Line 33: @@
 - https://medium.com/coding-blocks/optimizing-storage-and-managing-cleanup-in-postgresql-c2fe56d4cf5
 - https://dba.stackexchange.com/questions/44657/how-much-time-will-a-vacuum-autovacuum-operation-take
 .env