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-07-07 21:16:12
Duration: 556ms
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-07-07 21:01:12
Duration: 453ms
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-07-07 21:46:11
Duration: 438ms
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-07-07 21:16:14
Duration: 1s484ms
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-07-07 21:31:13
Duration: 1s214ms
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-07-07 21:41:13
Duration: 1s201ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

x Hide

WITH pet as ( select enddate, t.symbolid, row_number() over (partition by t.symbolid order by enddate desc) r from powerstats_trumpet t inner join brokersymbollist bsl on t.symbolid = bsl.symbolid and bsl.brokerid = 558 ) select _xml FROM ( select * from ( select distinct replace(symbol, ' ', '~') || '%<' || dayofweek || '_' || fromtime || '><15>' || round(ave_15, 5) || '</15><30>' || round(ave_30, 5) || '</30><60>' || round(ave_60, 5) || '</60><240>' || round(ave_240, 5) || '</240><1440>' || round(ave_1440, 5) || '</1440></' || dayofweek || '_' || fromtime || '>' as _xml, replace(symbol, ' ', '~') as symbol, dayofweek, fromtime, round(ave_15, 5) as ave_15, round(ave_30, 5) as ave_30, round(ave_60, 5) as ave_60, round(ave_240, 5) as ave_240, round(ave_1440, 5) as ave_1440 from symbols s inner join brokersymbollist bsl on s.symbolid = bsl.symbolid inner join pet on pet.r = 1 and bsl.symbolid = pet.symbolid and bsl.brokerid = 558 inner join powerstats_trumpet pt on bsl.symbolid = pt.symbolid and pet.enddate = pt.enddate where case when 558 != 285 then 1 = 1 else 1 = 0 end and case when 98 > 500 and 558 != 412 then s.exchange ilike 'FOREX' ELSE 1 = 1 END) b order by symbol, dayofweek, fromtime) a;

Date: 2024-07-07 21:20:57
Duration: 947ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

WITH pet as ( select enddate, t.symbolid, row_number() over (partition by t.symbolid order by enddate desc) r from powerstats_trumpet t inner join brokersymbollist bsl on t.symbolid = bsl.symbolid and bsl.brokerid = 529 ) select _xml FROM ( select * from ( select distinct replace(symbol, ' ', '~') || '%<' || dayofweek || '_' || fromtime || '><15>' || round(ave_15, 5) || '</15><30>' || round(ave_30, 5) || '</30><60>' || round(ave_60, 5) || '</60><240>' || round(ave_240, 5) || '</240><1440>' || round(ave_1440, 5) || '</1440></' || dayofweek || '_' || fromtime || '>' as _xml, replace(symbol, ' ', '~') as symbol, dayofweek, fromtime, round(ave_15, 5) as ave_15, round(ave_30, 5) as ave_30, round(ave_60, 5) as ave_60, round(ave_240, 5) as ave_240, round(ave_1440, 5) as ave_1440 from symbols s inner join brokersymbollist bsl on s.symbolid = bsl.symbolid inner join pet on pet.r = 1 and bsl.symbolid = pet.symbolid and bsl.brokerid = 529 inner join powerstats_trumpet pt on bsl.symbolid = pt.symbolid and pet.enddate = pt.enddate where case when 529 != 285 then 1 = 1 else 1 = 0 end and case when 204 > 500 and 529 != 412 then s.exchange ilike 'FOREX' ELSE 1 = 1 END) b order by symbol, dayofweek, fromtime) a;

Date: 2024-07-07 21:04:48
Duration: 789ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

WITH pet as ( select enddate, t.symbolid, row_number() over (partition by t.symbolid order by enddate desc) r from powerstats_trumpet t inner join brokersymbollist bsl on t.symbolid = bsl.symbolid and bsl.brokerid = 627 ) select _xml FROM ( select * from ( select distinct replace(symbol, ' ', '~') || '%<' || dayofweek || '_' || fromtime || '><15>' || round(ave_15, 5) || '</15><30>' || round(ave_30, 5) || '</30><60>' || round(ave_60, 5) || '</60><240>' || round(ave_240, 5) || '</240><1440>' || round(ave_1440, 5) || '</1440></' || dayofweek || '_' || fromtime || '>' as _xml, replace(symbol, ' ', '~') as symbol, dayofweek, fromtime, round(ave_15, 5) as ave_15, round(ave_30, 5) as ave_30, round(ave_60, 5) as ave_60, round(ave_240, 5) as ave_240, round(ave_1440, 5) as ave_1440 from symbols s inner join brokersymbollist bsl on s.symbolid = bsl.symbolid inner join pet on pet.r = 1 and bsl.symbolid = pet.symbolid and bsl.brokerid = 627 inner join powerstats_trumpet pt on bsl.symbolid = pt.symbolid and pet.enddate = pt.enddate where case when 627 != 285 then 1 = 1 else 1 = 0 end and case when 126 > 500 and 627 != 412 then s.exchange ilike 'FOREX' ELSE 1 = 1 END) b order by symbol, dayofweek, fromtime) a;

Date: 2024-07-07 21:41:59
Duration: 611ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

x Hide

WITH rar_max as ( ;

Date: 2024-07-07 21:12:06
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.250
Application: PostgreSQL JDBC Driver

x Hide

select updateageforrelevantresults ();

Date: 2024-07-07 21:32:11
Duration: 8s316ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateageforrelevantresults ();

Date: 2024-07-07 21:02:10
Duration: 8s196ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateageforrelevantresults ();

Date: 2024-07-07 21:17:10
Duration: 7s961ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

x Hide

select distinct bsl.brokerid || '_' || sc.symbolcount from broker bb inner join brokersymbollist bsl on bb.brokerid = bsl.brokerid inner join autochartist_symbolupdates au on bsl.symbolid = au.symbolid and au.latestpricedatetime > current_timestamp - interval '2 weeks' inner join powerstats_symboldata ps on bsl.symbolid = ps.symbolid inner join broker_powerstats bp on bsl.brokerid = bp.brokerid inner join ( select count(distinct s.symbol) as symbolcount, b.brokerid from brokersymbollist b inner join symbols s on b.symbolid = s.symbolid group by b.brokerid) sc on bsl.brokerid = sc.brokerid where bp.ps_allowed = 1 and bb.maketradeurl not ilike 'com.autochartist.Authentication.DenyAllAuthenticator' and (1 = 1 or bsl.brokerid = - 1);

Date: 2024-07-07 21:00:02
Duration: 527ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select distinct bsl.brokerid || '_' || sc.symbolcount from broker bb inner join brokersymbollist bsl on bb.brokerid = bsl.brokerid inner join autochartist_symbolupdates au on bsl.symbolid = au.symbolid and au.latestpricedatetime > current_timestamp - interval '2 weeks' inner join powerstats_symboldata ps on bsl.symbolid = ps.symbolid inner join broker_powerstats bp on bsl.brokerid = bp.brokerid inner join ( select count(distinct s.symbol) as symbolcount, b.brokerid from brokersymbollist b inner join symbols s on b.symbolid = s.symbolid group by b.brokerid) sc on bsl.brokerid = sc.brokerid where bp.ps_allowed = 1 and bb.maketradeurl not ilike 'com.autochartist.Authentication.DenyAllAuthenticator' and (1 = 1 or bsl.brokerid = - 1);

Date: 2024-07-07 21:00:02
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

x Hide

jr.resultuid AS resultuid, jr.direction AS direction, jr.patternendtime AS identified, jr.patternlengthbars AS length, jr.patternstarttime AS patternstarttime, case when jr.trendchangeid = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;

Date: 2024-07-07 21:00:00
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.250
Application: PostgreSQL JDBC Driver

x Hide