WITH rar_max as ( ;

Date: 2024-06-24 14:00:59
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.250
Application: PostgreSQL JDBC Driver

x Hide

with rankedmt4 as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select * from rankedmt4 where r = 1 ), ok_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select *, row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 * 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1;

Date: 2024-06-24 14:30:09
Duration: 6s107ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.90
Application: [unknown]

with rankedmt4 as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select * from rankedmt4 where r = 1 ), ok_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select *, row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 * 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1;

Date: 2024-06-24 14:10:07
Duration: 5s667ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.90
Application: [unknown]

with rankedmt4 as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select * from rankedmt4 where r = 1 ), ok_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select *, row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 * 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1;

Date: 2024-06-24 14:00:08
Duration: 5s596ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.90
Application: [unknown]

x Hide

select cleanupkeylevelsresults (15, 2, 15);

Date: 2024-06-24 14:21:33
Duration: 41s100ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select cleanupkeylevelsresults (30, 2, 30);

Date: 2024-06-24 14:22:11
Duration: 19s76ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select cleanupkeylevelsresults (360, 2, 1440);

Date: 2024-06-24 14:31:16
Duration: 13s887ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

x Hide

UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type = 'cp') sub WHERE result_uid = sub.resultuid;

Date: 2024-06-24 14:18:14
Duration: 2s720ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type = 'cp') sub WHERE result_uid = sub.resultuid;

Date: 2024-06-24 14:11:14
Duration: 2s223ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type = 'cp') sub WHERE result_uid = sub.resultuid;

Date: 2024-06-24 14:26:13
Duration: 1s255ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

x Hide

with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;

Date: 2024-06-24 14:26:20
Duration: 6s841ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;

Date: 2024-06-24 14:31:15
Duration: 1s597ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;

Date: 2024-06-24 14:16:14
Duration: 1s589ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

x Hide

select updateageforrelevantresults ();

Date: 2024-06-24 14:17:33
Duration: 31s762ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateageforrelevantresults ();

Date: 2024-06-24 14:32:28
Duration: 25s745ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateageforrelevantresults ();

Date: 2024-06-24 14:47:22
Duration: 19s672ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

x Hide

with sel as ( select resultuid from stats_success where atbaridentified < current_timestamp - interval '2 year' limit 1000000 ), del as ( delete from stats_success where atbaridentified < current_timestamp - interval '1 year' and resultuid in ( select resultuid from sel) returning *) insert into archive.stats_success (resultuid, atbaridentified, type, minprice, maxprice, correct, symbol, interval, pattern, direction, hourofday, quality, breakout, clarity, initialtrend, volumeincrease, symmetry, qtytp, trendchange, patternlengthbars, symbolid) select * from del on conflict do nothing;

Date: 2024-06-24 14:32:45
Duration: 4s482ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

with sel as ( select resultuid from stats_success where atbaridentified < current_timestamp - interval '2 year' limit 1000000 ), del as ( delete from stats_success where atbaridentified < current_timestamp - interval '1 year' and resultuid in ( select resultuid from sel) returning *) insert into archive.stats_success (resultuid, atbaridentified, type, minprice, maxprice, correct, symbol, interval, pattern, direction, hourofday, quality, breakout, clarity, initialtrend, volumeincrease, symmetry, qtytp, trendchange, patternlengthbars, symbolid) select * from del on conflict do nothing;

Date: 2024-06-24 14:32:51
Duration: 33ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

with sel as ( select resultuid from stats_success where atbaridentified < current_timestamp - interval '2 year' limit 1000000 ), del as ( delete from stats_success where atbaridentified < current_timestamp - interval '1 year' and resultuid in ( select resultuid from sel) returning *) insert into archive.stats_success (resultuid, atbaridentified, type, minprice, maxprice, correct, symbol, interval, pattern, direction, hourofday, quality, breakout, clarity, initialtrend, volumeincrease, symmetry, qtytp, trendchange, patternlengthbars, symbolid) select * from del on conflict do nothing;

Date: 2024-06-24 14:32:45
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

x Hide

select cleanup_whatshot (2, 3, 1);

Date: 2024-06-24 14:33:26
Duration: 7s579ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select cleanup_whatshot (2, 3, 1);

Date: 2024-06-24 14:33:28
Duration: 1s282ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select cleanup_whatshot (2, 3, 1);

Date: 2024-06-24 14:33:19
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

x Hide

select count(*) from ( select distinct w.id from whatshot_probability w left outer join autochartist_results a on w.resultuid = a.resultuid left outer join relevance_autochartist_results r on w.resultuid = r.resultuid where type = 'cp' and w.resultuid < ( SELECT MAX(resultuid) FROM relevance_autochartist_results) and case when a.writtendatetime is not null then a.writtendatetime else a.patternendtime end < current_timestamp - interval '8 days' and r.resultuid is null union select distinct w.id from whatshot_probability w left outer join keylevels_results a on w.resultuid = a.resultuid left outer join relevance_keylevels_results r on w.resultuid = r.resultuid where type in ('kl', 'ekl') and w.resultuid < ( SELECT MAX(resultuid) FROM relevance_keylevels_results) and case when a.writtendatetime is not null then a.writtendatetime else a.patternendtime end < current_timestamp - interval '8 days' and r.resultuid is null) a;

Date: 2024-06-24 14:02:00
Duration: 11s62ms
Database: acaweb_fx
User: postgres
Remote: 105.27.154.74
Application: PostgreSQL JDBC Driver

select count(*) from ( select distinct w.id from whatshot_probability w left outer join autochartist_results a on w.resultuid = a.resultuid left outer join relevance_autochartist_results r on w.resultuid = r.resultuid where type = 'cp' and w.resultuid < ( SELECT MAX(resultuid) FROM relevance_autochartist_results) and case when a.writtendatetime is not null then a.writtendatetime else a.patternendtime end < current_timestamp - interval '8 days' and r.resultuid is null union select distinct w.id from whatshot_probability w left outer join keylevels_results a on w.resultuid = a.resultuid left outer join relevance_keylevels_results r on w.resultuid = r.resultuid where type in ('kl', 'ekl') and w.resultuid < ( SELECT MAX(resultuid) FROM relevance_keylevels_results) and case when a.writtendatetime is not null then a.writtendatetime else a.patternendtime end < current_timestamp - interval '8 days' and r.resultuid is null) a;

Date: 2024-06-24 14:34:02
Duration: 10s70ms
Database: acaweb_fx
User: postgres
Remote: 105.27.154.74
Application: PostgreSQL JDBC Driver

x Hide