Skip to content

Instantly share code, notes, and snippets.

@sargon
sargon / Output of a run of above script
Created March 29, 2020 10:17
matrix-synapse: Analyse Purge process
Number of rooms we have a look at: 57
StateGroups
Number of state groups touched by purge process: 35
Number of state groups not touched by purge process: 46840
Number of rows in state_state_groups not touched by purge process: 10466145
Entries in state_groups_state: 35
Tables with event_id
Room event_auth event_edges event_push_actions_staging event_reference_hashes event_relations event_to_state_groups redactions rejections state_events
---------------------------------------- ------------ ------------- ---------------------------- ------------------------ ----------------- ----------------------- ------------ ------------ --------------
!MSJlzbwbCXLGDMCjpG:toppoint.de 0 0 0 0 0 0 0 0 0
@sargon
sargon / iptables-save
Created June 7, 2015 22:23
iptables-save output of the created firewall on gc-gw0 with the new concept.
# Generated by iptables-save v1.4.14 on Sun Jun 7 23:36:31 2015
*nat
:PREROUTING ACCEPT [0:0]
:INPUT ACCEPT [0:0]
:OUTPUT ACCEPT [0:0]
:POSTROUTING ACCEPT [0:0]
-A POSTROUTING -o tun-anonvpn -j MASQUERADE
COMMIT
# Completed on Sun Jun 7 23:36:31 2015
# Generated by iptables-save v1.4.14 on Sun Jun 7 23:36:31 2015