<commit_before>delete from foglamp.statistics_history;

update statistics set value = 1234, previous_value = 4567;

\set new_ts now()::timestamp(0) - 'interval \'20 minute\''
insert into statistics_history (key, history_ts, value, ts) values ( 'BUFFERED', :new_ts, 10, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'SENT', :new_ts, 11, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'UNSENT', :new_ts, 12, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'PURGED', :new_ts, 13, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'UNSNPURGED', :new_ts, 14, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'DISCARDED', :new_ts, 15, :new_ts );

\set new_ts now()::timestamp(0) - 'interval \'15 minute\''
insert into statistics_history (key, history_ts, value, ts) values ( 'BUFFERED', :new_ts, 16, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'SENT', :new_ts, 17, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'UNSENT', :new_ts, 18, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'PURGED', :new_ts, 19, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'UNSNPURGED', :new_ts, 20, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'DISCARDED', :new_ts, 21, :new_ts );

\set new_ts now()::timestamp(0) - 'interval \'10 minute\''
insert into statistics_history (key, history_ts, value, ts) values ( 'BUFFERED', :new_ts, 22, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'SENT', :new_ts, 23, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'UNSENT', :new_ts, 24, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'PURGED', :new_ts, 25, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'UNSNPURGED', :new_ts, 26, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'DISCARDED', :new_ts, 27, :new_ts );

\set new_ts now()::timestamp(0) - 'interval \'5 minute\''
insert into statistics_history (key, history_ts, value, ts) values ( 'BUFFERED', :new_ts, 28, :new_ts );<commit_msg>Minor fix in statistics demo data<commit_after>delete from foglamp.statistics_history;

update statistics set value = 1234, previous_value = 4567;

\set new_ts now() - 'interval \'20 minute\''
insert into statistics_history (key, history_ts, value, ts) values ( 'BUFFERED', :new_ts, 10, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'SENT', :new_ts, 11, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'UNSENT', :new_ts, 12, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'PURGED', :new_ts, 13, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'UNSNPURGED', :new_ts, 14, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'DISCARDED', :new_ts, 15, :new_ts );

\set new_ts now() - 'interval \'15 minute\''
insert into statistics_history (key, history_ts, value, ts) values ( 'BUFFERED', :new_ts, 16, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'SENT', :new_ts, 17, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'UNSENT', :new_ts, 18, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'PURGED', :new_ts, 19, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'UNSNPURGED', :new_ts, 20, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'DISCARDED', :new_ts, 21, :new_ts );

\set new_ts now() - 'interval \'10 minute\''
insert into statistics_history (key, history_ts, value, ts) values ( 'BUFFERED', :new_ts, 22, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'SENT', :new_ts, 23, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'UNSENT', :new_ts, 24, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'PURGED', :new_ts, 25, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'UNSNPURGED', :new_ts, 26, :new_ts );
insert into statistics_history (key, history_ts, value, ts) values ( 'DISCARDED', :new_ts, 27, :new_ts );

\set new_ts now() - 'interval \'5 minute\''
insert into statistics_history (key, history_ts, value, ts) values ( 'BUFFERED', :new_ts, 28, :new_ts );
{'fraction_non_alphanumeric': 0.1469703480876665, 'fraction_numerical': 0.023635582294800173, 'mean_word_length': 6.053030303030303, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '105165', 'n_tokens_mistral': 1721, 'n_tokens_neox': 1612, 'n_words': 529}