WITH rar_max as ( ;

Date: 2025-11-17 10:01:32
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.145
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: 2025-11-17 10:30:08
Duration: 6s336ms
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: 2025-11-17 10:00:08
Duration: 5s902ms
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: 2025-11-17 10:50:08
Duration: 5s626ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.90
Application: [unknown]

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: 2025-11-17 10:41:14
Duration: 2s40ms
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: 2025-11-17 10:56:13
Duration: 2s27ms
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: 2025-11-17 10:01:13
Duration: 1s694ms
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: 2025-11-17 10:16:17
Duration: 3s780ms
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: 2025-11-17 10:41:18
Duration: 3s727ms
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: 2025-11-17 10:01:17
Duration: 3s596ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

x Hide

select updateresultsmaterializedview ();

Date: 2025-11-17 10:17:28
Duration: 6s159ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateresultsmaterializedview ();

Date: 2025-11-17 10:47:25
Duration: 5s817ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateresultsmaterializedview ();

Date: 2025-11-17 10:32:27
Duration: 4s935ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

x Hide

select updateageforrelevantresults ();

Date: 2025-11-17 10:32:22
Duration: 19s668ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateageforrelevantresults ();

Date: 2025-11-17 10:17:22
Duration: 19s551ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateageforrelevantresults ();

Date: 2025-11-17 10:47:20
Duration: 17s738ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

x Hide

select count(*) from ( select * from patternresultsage pa inner join relevance_autochartist_results a on pa.resultuid = a.resultuid where pa.type = 0 and abs(pa.age - a.age) > 1 union all select * from patternresultsage pa inner join relevance_fibonacci_results a on pa.resultuid = a.resultuid where pa.type = 1 and abs(pa.age - a.age) > 1 union all select * from patternresultsage pa inner join relevance_keylevels_results a on pa.resultuid = a.resultuid where pa.type = 2 and abs(pa.age - a.age) > 1 union all select * from patternresultsage pa inner join relevance_consecutivecandles_results a on pa.resultuid = a.resultuid where pa.type = 4 and abs(pa.age - a.age) > 1 union all select * from patternresultsage pa inner join relevance_bigmovement_results a on pa.resultuid = a.resultuid where pa.type = 5 and abs(pa.age - a.age) > 1) a;

Date: 2025-11-17 10:25:02
Duration: 827ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.90
Application: [unknown]

select count(*) from ( select * from patternresultsage pa inner join relevance_autochartist_results a on pa.resultuid = a.resultuid where pa.type = 0 and abs(pa.age - a.age) > 1 union all select * from patternresultsage pa inner join relevance_fibonacci_results a on pa.resultuid = a.resultuid where pa.type = 1 and abs(pa.age - a.age) > 1 union all select * from patternresultsage pa inner join relevance_keylevels_results a on pa.resultuid = a.resultuid where pa.type = 2 and abs(pa.age - a.age) > 1 union all select * from patternresultsage pa inner join relevance_consecutivecandles_results a on pa.resultuid = a.resultuid where pa.type = 4 and abs(pa.age - a.age) > 1 union all select * from patternresultsage pa inner join relevance_bigmovement_results a on pa.resultuid = a.resultuid where pa.type = 5 and abs(pa.age - a.age) > 1) a;

Date: 2025-11-17 10:25:02
Duration: 826ms
Database: acaweb_fx
User: postgres
Remote: 192.168.2.126
Application: [unknown]

select count(*) from ( select * from patternresultsage pa inner join relevance_autochartist_results a on pa.resultuid = a.resultuid where pa.type = 0 and abs(pa.age - a.age) > 1 union all select * from patternresultsage pa inner join relevance_fibonacci_results a on pa.resultuid = a.resultuid where pa.type = 1 and abs(pa.age - a.age) > 1 union all select * from patternresultsage pa inner join relevance_keylevels_results a on pa.resultuid = a.resultuid where pa.type = 2 and abs(pa.age - a.age) > 1 union all select * from patternresultsage pa inner join relevance_consecutivecandles_results a on pa.resultuid = a.resultuid where pa.type = 4 and abs(pa.age - a.age) > 1 union all select * from patternresultsage pa inner join relevance_bigmovement_results a on pa.resultuid = a.resultuid where pa.type = 5 and abs(pa.age - a.age) > 1) a;

Date: 2025-11-17 10:25:01
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.2.126
Application: [unknown]

x Hide

select count(distinct brokerid) from broker_symbol_ticker_view where brokerid not in ( select distinct brokerid from broker_symbol_ticker_view b inner join powerstats_symboldata pa on b.symbolid = pa.symbolid inner join powerstats_hourly t on pa.hourlysymbolid = t.symbolid where t.enddate = ( select max(enddate) from powerstats_hourly)) and enabled = 1 and latestpricedatetime > current_timestamp - interval '5 days' and timegranularity = 60;

Date: 2025-11-17 10:03:09
Duration: 668ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.90
Application: [unknown]

select count(distinct brokerid) from broker_symbol_ticker_view where brokerid not in ( select distinct brokerid from broker_symbol_ticker_view b inner join powerstats_symboldata pa on b.symbolid = pa.symbolid inner join powerstats_hourly t on pa.hourlysymbolid = t.symbolid where t.enddate = ( select max(enddate) from powerstats_hourly)) and enabled = 1 and latestpricedatetime > current_timestamp - interval '5 days' and timegranularity = 60;

Date: 2025-11-17 10:03:09
Duration: 668ms
Database: acaweb_fx
User: postgres
Remote: 192.168.2.126
Application: [unknown]

select count(distinct brokerid) from broker_symbol_ticker_view where brokerid not in ( select distinct brokerid from broker_symbol_ticker_view b inner join powerstats_symboldata pa on b.symbolid = pa.symbolid inner join powerstats_hourly t on pa.hourlysymbolid = t.symbolid where t.enddate = ( select max(enddate) from powerstats_hourly)) and enabled = 1 and latestpricedatetime > current_timestamp - interval '5 days' and timegranularity = 60;

Date: 2025-11-17 10:03:09
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.2.126
Application: [unknown]

x Hide

select count(distinct brokerid) from broker_symbol_ticker_view where brokerid not in ( select distinct brokerid from broker_symbol_ticker_view b inner join powerstats_symboldata pa on b.symbolid = pa.symbolid inner join powerstats_trumpet t on pa.trumpetsymbolid = t.symbolid where t.enddate = ( select max(enddate) from powerstats_trumpet)) and enabled = 1 and latestpricedatetime > current_timestamp - interval '5 days';

Date: 2025-11-17 10:03:31
Duration: 3s974ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.90
Application: [unknown]

select count(distinct brokerid) from broker_symbol_ticker_view where brokerid not in ( select distinct brokerid from broker_symbol_ticker_view b inner join powerstats_symboldata pa on b.symbolid = pa.symbolid inner join powerstats_trumpet t on pa.trumpetsymbolid = t.symbolid where t.enddate = ( select max(enddate) from powerstats_trumpet)) and enabled = 1 and latestpricedatetime > current_timestamp - interval '5 days';

Date: 2025-11-17 10:03:31
Duration: 3s974ms
Database: acaweb_fx
User: postgres
Remote: 192.168.2.126
Application: [unknown]

x Hide