Decompress TimescaleDB chunks, Zabbix

Decompress all compressed chunks:

SELECT decompress_chunk(c, true) FROM show_chunks('trends_uint') c;
SELECT decompress_chunk(c, true) FROM show_chunks('trends') c;
SELECT decompress_chunk(c, true) FROM show_chunks('history_uint') c;
SELECT decompress_chunk(c, true) FROM show_chunks('history_str') c;
SELECT decompress_chunk(c, true) FROM show_chunks('history_log') c;
SELECT decompress_chunk(c, true) FROM show_chunks('history_text') c;
SELECT decompress_chunk(c, true) FROM show_chunks('history') c;

Clean orphaned data:

DELETE FROM history WHERE itemid NOT IN (SELECT itemid FROM items);DELETE FROM history_uint WHERE itemid NOT IN (SELECT itemid FROM items);DELETE FROM history_log WHERE itemid NOT IN (SELECT itemid FROM items);DELETE FROM history_str WHERE itemid NOT IN (SELECT itemid FROM items);DELETE FROM history_text WHERE itemid NOT IN (SELECT itemid FROM items);DELETE FROM trends WHERE itemid NOT IN (SELECT itemid FROM items);DELETE FROM trends_uint WHERE itemid NOT IN (SELECT itemid FROM items);DELETE FROM events WHERE source = 0 AND object = 0 AND objectid NOT IN (SELECT triggerid FROM triggers);DELETE FROM events WHERE source = 3 AND object = 0 AND objectid NOT IN (SELECT triggerid FROM triggers);DELETE FROM events WHERE source = 3 AND object = 4 AND objectid NOT IN (SELECT itemid FROM items);