1. home-assistant_v2.db

sqlite3 /config/home-assistant_v2.db ".dump"
sqlite3 /config/home-assistant_v2.db ".tables"
events                 states                 statistics_runs
recorder_runs          statistics             statistics_short_term
schema_changes         statistics_meta
sqlite3 /config/home-assistant_v2.db "pragma table_info('events')"
0|event_id|INTEGER|1||1
1|event_type|VARCHAR(64)|0||0
2|event_data|TEXT|0||0
3|origin|VARCHAR(32)|0||0
4|time_fired|DATETIME|0||0
5|context_id|VARCHAR(36)|0||0
6|context_user_id|VARCHAR(36)|0||0
7|context_parent_id|VARCHAR(36)|0||0
sqlite3 /config/home-assistant_v2.db "select * from events"

2. zigbee.db

sqlite3 /config/zigbee.db ".tables"
attributes_cache_v7        neighbors_v7
devices_v7                 node_descriptors_v7
endpoints_v7               out_clusters_v7
group_members_v7           relays_v7
groups_v7                  unsupported_attributes_v7
in_clusters_v7
sqlite3 /config/zigbee.db "pragma table_info('attributes_cache_v7')"
0|ieee|ieee|1||0
1|endpoint_id|INTEGER|1||0
2|cluster|INTEGER|1||0
3|attrid|INTEGER|1||0
4|value|BLOB|1||0
sqlite3 /config/zigbee.db "select * from attributes_cache_v7"
sqlite3 /config/zigbee.db "select * from devices_v7"
00:12:4b:00:25:6c:54:70|0|2
50:32:5f:ff:fe:24:20:1b|24907|2
50:32:5f:ff:fe:36:28:d3|5915|2
50:32:5f:ff:fe:58:66:e5|65198|2
50:32:5f:ff:fe:30:32:a6|7763|2
a4:c1:38:9b:ea:20:82:76|33748|2
a4:c1:38:04:74:0d:ac:af|51701|2

3. cases

3.1. reset statistics

sqlite3 /config/home-assistant_v2.db "select * from statistics_meta"
sqlite3 /config/home-assistant_v2.db "select * from statistics_meta where statistic_id like '%elgris%'"
sqlite3 /config/home-assistant_v2.db "delete from statistics_meta where statistic_id like '%elgris%'"