WITH rar_max as ( ;

Date: 2023-07-16 22:55:46
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 182.165.1.42
Application: [unknown]

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 = 667 ) 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 = 667 inner join powerstats_trumpet pt on bsl.symbolid = pt.symbolid and pet.enddate = pt.enddate where case when 667 != 285 then 1 = 1 else 1 = 0 end and case when 88 > 500 and 667 != 412 then s.exchange ilike 'FOREX' ELSE 1 = 1 END) b order by symbol, dayofweek, fromtime) a;

Date: 2023-07-16 22:51:13
Duration: 881ms
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: 2023-07-16 22:08:11
Duration: 620ms
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 = 638 ) 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 = 638 inner join powerstats_trumpet pt on bsl.symbolid = pt.symbolid and pet.enddate = pt.enddate where case when 638 != 285 then 1 = 1 else 1 = 0 end and case when 99 > 500 and 638 != 412 then s.exchange ilike 'FOREX' ELSE 1 = 1 END) b order by symbol, dayofweek, fromtime) a;

Date: 2023-07-16 22:30:39
Duration: 599ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

x Hide

/*server.CPResultList*/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 538 AND (((s.symbol ilike '%gbpusd%' AND timegranularity = 240);

Date: 2023-07-16 22:01:36
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.0.42
Application: PostgreSQL JDBC Driver

x Hide

select updateageforrelevantresults ();

Date: 2023-07-16 22:02:20
Duration: 17s832ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateageforrelevantresults ();

Date: 2023-07-16 22:32:18
Duration: 16s238ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateageforrelevantresults ();

Date: 2023-07-16 22:17:18
Duration: 15s719ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

x Hide