/*server.KeyLevelResultList*/ SELECT DISTINCT a.ResultUID AS ruid, c.symbolid AS sid, c.symbol AS sym, c.longname as longname, c.shortname, c.Exchange AS e, c.timegranularity AS tg, p.PatternID AS pid, a.direction AS d, cast(atbaridentified as timestamp) AS pet, cast(patternstarttime as timestamp) AS pst, PatternPrice AS patp, breakoutprice as pE, breakoutbars as bE, errorMargin as erm, PatternLengthBars AS l, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, cast(x0 as timestamp) AS x0, cast(x1 as timestamp) AS x1, cast(x2 as timestamp) AS x2, cast(( case when x3 = '' then '1900-01-01' else x3 end) as timestamp) AS x3, cast((case when x4 = '' then '1900-01-01' else x4 end) as timestamp) AS x4, cast(( case when x5 = '' then '1900-01-01' else x5 end) as timestamp) AS x5, cast((case when x6 = '' then '1900-01-01' else x6 end) as timestamp) AS x6, cast(( case when x7 = '' then '1900-01-01' else x7 end) as timestamp) AS x7, cast((case when x8 = '' then '1900-01-01' else x8 end) as timestamp) AS x8, cast(( case when x9 = '' then '1900-01-01' else x9 end) as timestamp) AS x9, cast(atbaridentified as timestamp) as PatternEndTime, cast(atbaridentified as timestamp) as atBar, cast((case when approachingtimestamp = '' then '1900-01-01' else approachingtimestamp end) as timestamp) as apr, dftt.timezone as tz, dftt.absolutetimezoneoffset as tzOs, predictionpricefrom as ppf, predictionpriceto as ppt, predictiontimefrom as ptf, predictiontimebars as ptb, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_keylevels_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_keylevels_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant, cast(0.0 as double precision) as premium, cast(0 as bigint) as instrumentid, 0 as derivativeid, 0 as underlyingid, 0 as isunderlying FROM symbols c INNER JOIN brokersymbollist b ON c.symbolid = b.symbolid INNER JOIN symbolgroup sg ON c.symbolid = sg.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = c.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN keylevels_results a ON a.symbolid = c.symbolid INNER JOIN hrspatterns p ON a.patternid = p.patternid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 621 AND sg.groupid = 515852059852088308 AND patternclassid = '1' AND patternlengthbars >= '20' AND a.PatternID & '39' > 0 AND dftt.dayofweek = '3' AND a.qtytp >= '0' AND a.resultuid > '-573847993' AND c.nonliquid = '0' AND c.deleted = 0 AND dss.enabled = 1 ORDER BY relevant DESC, age asc, PatternEndTime DESC, qtp DESC LIMIT 50;

Date: 2023-05-05 14:04:13
Duration: 961ms
Database: acaweb_fx
User: postgres
Remote: 192.168.0.42
Application: PostgreSQL JDBC Driver

/*server.KeyLevelResultList*/ SELECT DISTINCT a.ResultUID AS ruid, c.symbolid AS sid, c.symbol AS sym, c.longname as longname, c.shortname, c.Exchange AS e, c.timegranularity AS tg, p.PatternID AS pid, a.direction AS d, cast(atbaridentified as timestamp) AS pet, cast(patternstarttime as timestamp) AS pst, PatternPrice AS patp, breakoutprice as pE, breakoutbars as bE, errorMargin as erm, PatternLengthBars AS l, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, cast(x0 as timestamp) AS x0, cast(x1 as timestamp) AS x1, cast(x2 as timestamp) AS x2, cast(( case when x3 = '' then '1900-01-01' else x3 end) as timestamp) AS x3, cast((case when x4 = '' then '1900-01-01' else x4 end) as timestamp) AS x4, cast(( case when x5 = '' then '1900-01-01' else x5 end) as timestamp) AS x5, cast((case when x6 = '' then '1900-01-01' else x6 end) as timestamp) AS x6, cast(( case when x7 = '' then '1900-01-01' else x7 end) as timestamp) AS x7, cast((case when x8 = '' then '1900-01-01' else x8 end) as timestamp) AS x8, cast(( case when x9 = '' then '1900-01-01' else x9 end) as timestamp) AS x9, cast(atbaridentified as timestamp) as PatternEndTime, cast(atbaridentified as timestamp) as atBar, cast((case when approachingtimestamp = '' then '1900-01-01' else approachingtimestamp end) as timestamp) as apr, dftt.timezone as tz, dftt.absolutetimezoneoffset as tzOs, predictionpricefrom as ppf, predictionpriceto as ppt, predictiontimefrom as ptf, predictiontimebars as ptb, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_keylevels_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_keylevels_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant, cast(0.0 as double precision) as premium, cast(0 as bigint) as instrumentid, 0 as derivativeid, 0 as underlyingid, 0 as isunderlying FROM symbols c INNER JOIN brokersymbollist b ON c.symbolid = b.symbolid INNER JOIN symbolgroup sg ON c.symbolid = sg.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = c.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN keylevels_results a ON a.symbolid = c.symbolid INNER JOIN hrspatterns p ON a.patternid = p.patternid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 692 AND sg.groupid = 515852059916698308 AND patternclassid = '1' AND patternlengthbars >= '20' AND a.PatternID & '39' > 0 AND dftt.dayofweek = '3' AND a.qtytp >= '0' AND a.resultuid > '353671727' AND c.nonliquid = '0' AND c.deleted = 0 AND dss.enabled = 1 ORDER BY relevant DESC, age asc, PatternEndTime DESC, qtp DESC LIMIT 50;

Date: 2023-05-05 14:48:12
Duration: 564ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.45
Application: PostgreSQL JDBC Driver

/*server.KeyLevelResultList*/ SELECT DISTINCT a.ResultUID AS ruid, c.symbolid AS sid, c.symbol AS sym, c.longname as longname, c.shortname, c.Exchange AS e, c.timegranularity AS tg, p.PatternID AS pid, a.direction AS d, cast(atbaridentified as timestamp) AS pet, cast(patternstarttime as timestamp) AS pst, PatternPrice AS patp, breakoutprice as pE, breakoutbars as bE, errorMargin as erm, PatternLengthBars AS l, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, cast(x0 as timestamp) AS x0, cast(x1 as timestamp) AS x1, cast(x2 as timestamp) AS x2, cast(( case when x3 = '' then '1900-01-01' else x3 end) as timestamp) AS x3, cast((case when x4 = '' then '1900-01-01' else x4 end) as timestamp) AS x4, cast(( case when x5 = '' then '1900-01-01' else x5 end) as timestamp) AS x5, cast((case when x6 = '' then '1900-01-01' else x6 end) as timestamp) AS x6, cast(( case when x7 = '' then '1900-01-01' else x7 end) as timestamp) AS x7, cast((case when x8 = '' then '1900-01-01' else x8 end) as timestamp) AS x8, cast(( case when x9 = '' then '1900-01-01' else x9 end) as timestamp) AS x9, cast(atbaridentified as timestamp) as PatternEndTime, cast(atbaridentified as timestamp) as atBar, cast((case when approachingtimestamp = '' then '1900-01-01' else approachingtimestamp end) as timestamp) as apr, dftt.timezone as tz, dftt.absolutetimezoneoffset as tzOs, predictionpricefrom as ppf, predictionpriceto as ppt, predictiontimefrom as ptf, predictiontimebars as ptb, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_keylevels_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_keylevels_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant, cast(0.0 as double precision) as premium, cast(0 as bigint) as instrumentid, 0 as derivativeid, 0 as underlyingid, 0 as isunderlying FROM symbols c INNER JOIN brokersymbollist b ON c.symbolid = b.symbolid INNER JOIN symbolgroup sg ON c.symbolid = sg.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = c.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN keylevels_results a ON a.symbolid = c.symbolid INNER JOIN hrspatterns p ON a.patternid = p.patternid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 538 AND sg.groupid = 515852059729069308 AND patternclassid = '2' AND patternlengthbars >= '20' AND a.PatternID & '39' > 0 AND dftt.dayofweek = '3' AND a.qtytp >= '0' AND a.resultuid > '-1398049617' AND c.nonliquid = '0' AND c.deleted = 0 AND dss.enabled = 1 ORDER BY relevant DESC, age asc, PatternEndTime DESC, qtp DESC LIMIT 50;

Date: 2023-05-05 14:06:27
Duration: 551ms
Database: acaweb_fx
User: postgres
Remote: 192.168.0.42
Application: PostgreSQL JDBC Driver

x Hide

WITH rar_max as ( ;

Date: 2023-05-05 14:30:47
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 182.165.1.42
Application: [unknown]

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: 2023-05-05 14:10:05
Duration: 3s173ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.25
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: 2023-05-05 14:20:04
Duration: 2s145ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.25
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: 2023-05-05 14:00:04
Duration: 2s128ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.25
Application: [unknown]

x Hide

/*server.KeyLevelResultList*/ SELECT DISTINCT a.ResultUID AS ruid, c.symbolid AS sid, c.symbol AS sym, c.longname as longname, c.shortname, c.Exchange AS e, c.timegranularity AS tg, p.PatternID AS pid, a.direction AS d, cast(atbaridentified as timestamp) AS pet, cast(patternstarttime as timestamp) AS pst, PatternPrice AS patp, breakoutprice as pE, breakoutbars as bE, errorMargin as erm, PatternLengthBars AS l, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, cast(x0 as timestamp) AS x0, cast(x1 as timestamp) AS x1, cast(x2 as timestamp) AS x2, cast(( case when x3 = '' then '1900-01-01' else x3 end) as timestamp) AS x3, cast((case when x4 = '' then '1900-01-01' else x4 end) as timestamp) AS x4, cast(( case when x5 = '' then '1900-01-01' else x5 end) as timestamp) AS x5, cast((case when x6 = '' then '1900-01-01' else x6 end) as timestamp) AS x6, cast(( case when x7 = '' then '1900-01-01' else x7 end) as timestamp) AS x7, cast((case when x8 = '' then '1900-01-01' else x8 end) as timestamp) AS x8, cast(( case when x9 = '' then '1900-01-01' else x9 end) as timestamp) AS x9, cast(atbaridentified as timestamp) as PatternEndTime, cast(atbaridentified as timestamp) as atBar, cast((case when approachingtimestamp = '' then '1900-01-01' else approachingtimestamp end) as timestamp) as apr, dftt.timezone as tz, dftt.absolutetimezoneoffset as tzOs, predictionpricefrom as ppf, predictionpriceto as ppt, predictiontimefrom as ptf, predictiontimebars as ptb, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_keylevels_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_keylevels_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant, cast(0.0 as double precision) as premium, cast(0 as bigint) as instrumentid, 0 as derivativeid, 0 as underlyingid, 0 as isunderlying FROM symbols c INNER JOIN brokersymbollist b ON c.symbolid = b.symbolid INNER JOIN symbolgroup sg ON c.symbolid = sg.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = c.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN keylevels_results a ON a.symbolid = c.symbolid INNER JOIN hrspatterns p ON a.patternid = p.patternid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 431 AND sg.groupid = 515852059926914308 AND patternclassid = '1' AND patternlengthbars >= '20' AND a.PatternID & '65535' > 0 AND dftt.dayofweek = '3' AND a.resultuid > '580446823' AND c.nonliquid = '0' AND c.deleted = 0 AND dss.enabled = 1 ORDER BY relevant DESC, age asc, PatternEndTime DESC, qtp DESC LIMIT 50;

Date: 2023-05-05 14:18:56
Duration: 711ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.45
Application: PostgreSQL JDBC Driver

/*server.KeyLevelResultList*/ SELECT DISTINCT a.ResultUID AS ruid, c.symbolid AS sid, c.symbol AS sym, c.longname as longname, c.shortname, c.Exchange AS e, c.timegranularity AS tg, p.PatternID AS pid, a.direction AS d, cast(atbaridentified as timestamp) AS pet, cast(patternstarttime as timestamp) AS pst, PatternPrice AS patp, breakoutprice as pE, breakoutbars as bE, errorMargin as erm, PatternLengthBars AS l, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, cast(x0 as timestamp) AS x0, cast(x1 as timestamp) AS x1, cast(x2 as timestamp) AS x2, cast(( case when x3 = '' then '1900-01-01' else x3 end) as timestamp) AS x3, cast((case when x4 = '' then '1900-01-01' else x4 end) as timestamp) AS x4, cast(( case when x5 = '' then '1900-01-01' else x5 end) as timestamp) AS x5, cast((case when x6 = '' then '1900-01-01' else x6 end) as timestamp) AS x6, cast(( case when x7 = '' then '1900-01-01' else x7 end) as timestamp) AS x7, cast((case when x8 = '' then '1900-01-01' else x8 end) as timestamp) AS x8, cast(( case when x9 = '' then '1900-01-01' else x9 end) as timestamp) AS x9, cast(atbaridentified as timestamp) as PatternEndTime, cast(atbaridentified as timestamp) as atBar, cast((case when approachingtimestamp = '' then '1900-01-01' else approachingtimestamp end) as timestamp) as apr, dftt.timezone as tz, dftt.absolutetimezoneoffset as tzOs, predictionpricefrom as ppf, predictionpriceto as ppt, predictiontimefrom as ptf, predictiontimebars as ptb, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_keylevels_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_keylevels_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant, cast(0.0 as double precision) as premium, cast(0 as bigint) as instrumentid, 0 as derivativeid, 0 as underlyingid, 0 as isunderlying FROM symbols c INNER JOIN brokersymbollist b ON c.symbolid = b.symbolid INNER JOIN symbolgroup sg ON c.symbolid = sg.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = c.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN keylevels_results a ON a.symbolid = c.symbolid INNER JOIN hrspatterns p ON a.patternid = p.patternid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 621 AND sg.groupid = 515852059852088308 AND patternclassid = '2' AND patternlengthbars >= '20' AND a.PatternID & '3' > 0 AND dftt.dayofweek = '3' AND a.resultuid > '0' AND c.nonliquid = '0' AND c.deleted = 0 AND dss.enabled = 1 ORDER BY relevant DESC, age asc, PatternEndTime DESC, qtp DESC LIMIT 50;

Date: 2023-05-05 14:47:35
Duration: 623ms
Database: acaweb_fx
User: postgres
Remote: 192.168.0.42
Application: PostgreSQL JDBC Driver

/*server.KeyLevelResultList*/ SELECT DISTINCT a.ResultUID AS ruid, c.symbolid AS sid, c.symbol AS sym, c.longname as longname, c.shortname, c.Exchange AS e, c.timegranularity AS tg, p.PatternID AS pid, a.direction AS d, cast(atbaridentified as timestamp) AS pet, cast(patternstarttime as timestamp) AS pst, PatternPrice AS patp, breakoutprice as pE, breakoutbars as bE, errorMargin as erm, PatternLengthBars AS l, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, cast(x0 as timestamp) AS x0, cast(x1 as timestamp) AS x1, cast(x2 as timestamp) AS x2, cast(( case when x3 = '' then '1900-01-01' else x3 end) as timestamp) AS x3, cast((case when x4 = '' then '1900-01-01' else x4 end) as timestamp) AS x4, cast(( case when x5 = '' then '1900-01-01' else x5 end) as timestamp) AS x5, cast((case when x6 = '' then '1900-01-01' else x6 end) as timestamp) AS x6, cast(( case when x7 = '' then '1900-01-01' else x7 end) as timestamp) AS x7, cast((case when x8 = '' then '1900-01-01' else x8 end) as timestamp) AS x8, cast(( case when x9 = '' then '1900-01-01' else x9 end) as timestamp) AS x9, cast(atbaridentified as timestamp) as PatternEndTime, cast(atbaridentified as timestamp) as atBar, cast((case when approachingtimestamp = '' then '1900-01-01' else approachingtimestamp end) as timestamp) as apr, dftt.timezone as tz, dftt.absolutetimezoneoffset as tzOs, predictionpricefrom as ppf, predictionpriceto as ppt, predictiontimefrom as ptf, predictiontimebars as ptb, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_keylevels_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_keylevels_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant, cast(0.0 as double precision) as premium, cast(0 as bigint) as instrumentid, 0 as derivativeid, 0 as underlyingid, 0 as isunderlying FROM symbols c INNER JOIN brokersymbollist b ON c.symbolid = b.symbolid INNER JOIN symbolgroup sg ON c.symbolid = sg.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = c.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN keylevels_results a ON a.symbolid = c.symbolid INNER JOIN hrspatterns p ON a.patternid = p.patternid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 692 AND sg.groupid = 515852059916698308 AND patternclassid = '2' AND patternlengthbars >= '20' AND a.PatternID & '3' > 0 AND dftt.dayofweek = '3' AND a.resultuid > '1591200535' AND c.nonliquid = '0' AND c.deleted = 0 AND dss.enabled = 1 ORDER BY relevant DESC, age asc, PatternEndTime DESC, qtp DESC LIMIT 50;

Date: 2023-05-05 14:11:05
Duration: 521ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.45
Application: PostgreSQL JDBC Driver

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 = 558 AND (((s.symbol ilike '%eurgbp%' AND timegranularity <= 1440);

Date: 2023-05-05 14:31:53
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.201
Application: PostgreSQL JDBC Driver

x Hide

select pricedatetime, open, high, low, close, timegranularity, symbol from t30 p inner join symbols s on p.symbolid = s.symbolid inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where brokerid = 622 and symbol in ('EURAUD', 'USDCNH', 'EURCNH', 'NZDJPY', 'NZDCAD', 'AUDSGD', 'CHFJPY', 'EURSEK', 'JPN225', 'AUDHKD', 'AUDCHF', 'WTISPOT', 'EURTRY', 'BRENTSPOT', 'GBPUSD', 'GBPHKD', 'AUDJPY', 'GBPTRY', 'GBPNOK', 'XAGUSD', 'GBPCAD', 'GBPNZD', 'GBPAUD', 'AUDCAD', 'EURHKD', 'USDSGD', 'GBPJPY', 'USDRUB', 'USDTRY', 'GBPRUB', 'USDMXN', 'AUDNZD', 'USDPLN', 'USDCZK', 'USDCAD', 'GBPSEK', 'USDNOK', 'EURNOK', 'GBPMXN', 'EURMXN', 'GBPDKK', 'USDZAR', 'USDDKK', 'EURNZD', 'EURCAD', 'USDJPY', 'GBPCHF', 'USDSEK', 'CADJPY', 'GBPHUF', 'AUDUSD', 'USDHUF', 'EURJPY', 'HK-Shares', 'ESP35', 'LTCUSD', 'EURUSD', 'GBPCNH', 'NZDUSD', 'ETHUSD', 'EURHUF', 'EURZAR', 'EURRUB', 'GBPCZK', 'EURCHF', 'GBPEUR', 'GBPPLN', 'BTCUSD', 'GBPZAR', 'EURPLN', 'EURCZK', 'EURDKK', 'XAUUSD', 'CADCHF', 'NZDCHF', 'USDCHF', 'EURGBP', 'USDHKD') and timegranularity = 30 and pricedatetime >= current_timestamp - interval '40 days' order by pricedatetime asc;

Date: 2023-05-05 14:17:54
Duration: 779ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

select pricedatetime, open, high, low, close, timegranularity, symbol from t30 p inner join symbols s on p.symbolid = s.symbolid inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where brokerid = 622 and symbol in ('EURAUD', 'USDCNH', 'EURCNH', 'NZDJPY', 'NZDCAD', 'AUDSGD', 'CHFJPY', 'EURSEK', 'JPN225', 'AUDHKD', 'AUDCHF', 'WTISPOT', 'EURTRY', 'BRENTSPOT', 'GBPUSD', 'GBPHKD', 'AUDJPY', 'GBPTRY', 'GBPNOK', 'XAGUSD', 'GBPCAD', 'GBPNZD', 'GBPAUD', 'AUDCAD', 'EURHKD', 'USDSGD', 'GBPJPY', 'USDRUB', 'USDTRY', 'GBPRUB', 'USDMXN', 'AUDNZD', 'USDPLN', 'USDCZK', 'USDCAD', 'GBPSEK', 'USDNOK', 'EURNOK', 'GBPMXN', 'EURMXN', 'GBPDKK', 'USDZAR', 'USDDKK', 'EURNZD', 'EURCAD', 'USDJPY', 'GBPCHF', 'USDSEK', 'CADJPY', 'GBPHUF', 'AUDUSD', 'USDHUF', 'EURJPY', 'HK-Shares', 'ESP35', 'LTCUSD', 'EURUSD', 'GBPCNH', 'NZDUSD', 'ETHUSD', 'EURHUF', 'EURZAR', 'EURRUB', 'GBPCZK', 'EURCHF', 'GBPEUR', 'GBPPLN', 'BTCUSD', 'GBPZAR', 'EURPLN', 'EURCZK', 'EURDKK', 'XAUUSD', 'CADCHF', 'NZDCHF', 'USDCHF', 'EURGBP', 'USDHKD') and timegranularity = 30 and pricedatetime >= current_timestamp - interval '40 days' order by pricedatetime asc;

Date: 2023-05-05 14:33:59
Duration: 434ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

select pricedatetime, open, high, low, close, timegranularity, symbol from t30 p inner join symbols s on p.symbolid = s.symbolid inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where brokerid = 622 and symbol in ('EURAUD', 'USDCNH', 'EURCNH', 'NZDJPY', 'NZDCAD', 'AUDSGD', 'CHFJPY', 'EURSEK', 'JPN225', 'AUDHKD', 'AUDCHF', 'WTISPOT', 'EURTRY', 'BRENTSPOT', 'GBPUSD', 'GBPHKD', 'AUDJPY', 'GBPTRY', 'GBPNOK', 'XAGUSD', 'GBPCAD', 'GBPNZD', 'GBPAUD', 'AUDCAD', 'EURHKD', 'USDSGD', 'GBPJPY', 'USDRUB', 'USDTRY', 'GBPRUB', 'USDMXN', 'AUDNZD', 'USDPLN', 'USDCZK', 'USDCAD', 'GBPSEK', 'USDNOK', 'EURNOK', 'GBPMXN', 'EURMXN', 'GBPDKK', 'USDZAR', 'USDDKK', 'EURNZD', 'EURCAD', 'USDJPY', 'GBPCHF', 'USDSEK', 'CADJPY', 'GBPHUF', 'AUDUSD', 'USDHUF', 'EURJPY', 'HK-Shares', 'ESP35', 'LTCUSD', 'EURUSD', 'GBPCNH', 'NZDUSD', 'ETHUSD', 'EURHUF', 'EURZAR', 'EURRUB', 'GBPCZK', 'EURCHF', 'GBPEUR', 'GBPPLN', 'BTCUSD', 'GBPZAR', 'EURPLN', 'EURCZK', 'EURDKK', 'XAUUSD', 'CADCHF', 'NZDCHF', 'USDCHF', 'EURGBP', 'USDHKD') and timegranularity = 30 and pricedatetime >= current_timestamp - interval '40 days' order by pricedatetime asc;

Date: 2023-05-05 14:39:16
Duration: 397ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

x Hide

select pricedatetime, open, high, low, close, timegranularity, symbol from t240 p inner join symbols s on p.symbolid = s.symbolid inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where brokerid = 622 and symbol in ('EURAUD', 'USDCNH', 'EURCNH', 'NZDJPY', 'NZDCAD', 'AUDSGD', 'CHFJPY', 'EURSEK', 'JPN225', 'AUDHKD', 'AUDCHF', 'WTISPOT', 'EURTRY', 'BRENTSPOT', 'GBPUSD', 'GBPHKD', 'AUDJPY', 'GBPTRY', 'GBPNOK', 'XAGUSD', 'GBPCAD', 'GBPNZD', 'GBPAUD', 'AUDCAD', 'EURHKD', 'USDSGD', 'GBPJPY', 'USDRUB', 'USDTRY', 'GBPRUB', 'USDMXN', 'AUDNZD', 'USDPLN', 'USDCZK', 'USDCAD', 'GBPSEK', 'USDNOK', 'EURNOK', 'GBPMXN', 'EURMXN', 'GBPDKK', 'USDZAR', 'USDDKK', 'EURNZD', 'EURCAD', 'USDJPY', 'GBPCHF', 'USDSEK', 'CADJPY', 'GBPHUF', 'AUDUSD', 'USDHUF', 'EURJPY', 'HK-Shares', 'ESP35', 'LTCUSD', 'EURUSD', 'GBPCNH', 'NZDUSD', 'ETHUSD', 'EURHUF', 'EURZAR', 'EURRUB', 'GBPCZK', 'EURCHF', 'GBPEUR', 'GBPPLN', 'BTCUSD', 'GBPZAR', 'EURPLN', 'EURCZK', 'EURDKK', 'XAUUSD', 'CADCHF', 'NZDCHF', 'USDCHF', 'EURGBP', 'USDHKD') and timegranularity = 240 and pricedatetime >= current_timestamp - interval '320 days' order by pricedatetime asc;

Date: 2023-05-05 14:17:54
Duration: 933ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

select pricedatetime, open, high, low, close, timegranularity, symbol from t240 p inner join symbols s on p.symbolid = s.symbolid inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where brokerid = 640 and symbol in ('AMZN.US', 'EURAUD', 'NZDJPY', 'AUDUSD', 'JP5R', 'AUDCHF', 'NQ20R', 'DJ5R', 'GBPUSD', 'SP50R', 'AUDJPY', 'GBPJPY', 'XAGUSD', 'CLR', 'GBPNZD', 'GBPAUD', 'AUDCAD', 'NFLX.US', 'GS.US', 'MCD.US', 'AUDNZD', 'USDCAD', 'HK5R', 'EURNZD', 'USDJPY', 'BABA.US', 'GBPCHF', 'JPM.US', 'F.US', 'CADJPY', 'EURJPY', 'JPN225', 'T.US', 'CHFJPY', 'EURUSD', 'NZDUSD', 'EURGBP', 'EURCHF', 'XOM.US', 'NZDCAD', 'EURCAD', 'MSFT.US', 'GBPCAD', 'NKE.US', 'NZDCHF', 'XAUUSD', 'USDCHF', 'BA.US', 'GOOG.US') and timegranularity = 240 and pricedatetime >= current_timestamp - interval '320 days' order by pricedatetime asc;

Date: 2023-05-05 14:50:23
Duration: 516ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

select pricedatetime, open, high, low, close, timegranularity, symbol from t240 p inner join symbols s on p.symbolid = s.symbolid inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where brokerid = 640 and symbol in ('AMZN.US', 'EURAUD', 'NZDJPY', 'AUDUSD', 'JP5R', 'AUDCHF', 'NQ20R', 'DJ5R', 'GBPUSD', 'SP50R', 'AUDJPY', 'XAGUSD', 'CLR', 'GBPNZD', 'GBPAUD', 'AUDCAD', 'NFLX.US', 'GS.US', 'GBPJPY', 'MCD.US', 'AUDNZD', 'USDCAD', 'EURNZD', 'USDJPY', 'BABA.US', 'GBPCHF', 'JPM.US', 'F.US', 'CADJPY', 'EURJPY', 'JPN225', 'T.US', 'CHFJPY', 'EURUSD', 'NZDUSD', 'HK5R', 'EURGBP', 'EURCHF', 'XOM.US', 'NZDCAD', 'EURCAD', 'MSFT.US', 'GBPCAD', 'NKE.US', 'NZDCHF', 'XAUUSD', 'USDCHF', 'BA.US', 'GOOG.US') and timegranularity = 240 and pricedatetime >= current_timestamp - interval '320 days' order by pricedatetime asc;

Date: 2023-05-05 14:30:23
Duration: 483ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

x Hide

select pricedatetime, open, high, low, close, timegranularity, symbol from t15 p inner join symbols s on p.symbolid = s.symbolid inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where brokerid = 622 and symbol in ('EURAUD', 'USDCNH', 'EURCNH', 'NZDJPY', 'NZDCAD', 'AUDSGD', 'CHFJPY', 'EURSEK', 'JPN225', 'AUDHKD', 'AUDCHF', 'WTISPOT', 'EURTRY', 'BRENTSPOT', 'GBPUSD', 'GBPHKD', 'AUDJPY', 'GBPTRY', 'GBPNOK', 'XAGUSD', 'GBPCAD', 'GBPNZD', 'GBPAUD', 'AUDCAD', 'EURHKD', 'USDSGD', 'GBPJPY', 'USDRUB', 'USDTRY', 'GBPRUB', 'USDMXN', 'AUDNZD', 'USDPLN', 'USDCZK', 'USDCAD', 'GBPSEK', 'USDNOK', 'EURNOK', 'GBPMXN', 'EURMXN', 'GBPDKK', 'USDZAR', 'USDDKK', 'EURNZD', 'EURCAD', 'USDJPY', 'GBPCHF', 'USDSEK', 'CADJPY', 'GBPHUF', 'AUDUSD', 'USDHUF', 'EURJPY', 'HK-Shares', 'ESP35', 'LTCUSD', 'EURUSD', 'GBPCNH', 'NZDUSD', 'ETHUSD', 'EURHUF', 'EURZAR', 'EURRUB', 'GBPCZK', 'EURCHF', 'GBPEUR', 'GBPPLN', 'BTCUSD', 'GBPZAR', 'EURPLN', 'EURCZK', 'EURDKK', 'XAUUSD', 'CADCHF', 'NZDCHF', 'USDCHF', 'EURGBP', 'USDHKD') and timegranularity = 15 and pricedatetime >= current_timestamp - interval '20 days' order by pricedatetime asc;

Date: 2023-05-05 14:39:16
Duration: 378ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

select pricedatetime, open, high, low, close, timegranularity, symbol from t15 p inner join symbols s on p.symbolid = s.symbolid inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where brokerid = 622 and symbol in ('EURAUD', 'USDCNH', 'EURCNH', 'NZDJPY', 'NZDCAD', 'AUDSGD', 'CHFJPY', 'EURSEK', 'JPN225', 'AUDHKD', 'AUDCHF', 'WTISPOT', 'EURTRY', 'BRENTSPOT', 'GBPUSD', 'GBPHKD', 'AUDJPY', 'GBPTRY', 'GBPNOK', 'XAGUSD', 'GBPCAD', 'GBPNZD', 'GBPAUD', 'AUDCAD', 'EURHKD', 'USDSGD', 'GBPJPY', 'USDRUB', 'USDTRY', 'GBPRUB', 'USDMXN', 'AUDNZD', 'USDPLN', 'USDCZK', 'USDCAD', 'GBPSEK', 'USDNOK', 'EURNOK', 'GBPMXN', 'EURMXN', 'GBPDKK', 'USDZAR', 'USDDKK', 'EURNZD', 'EURCAD', 'USDJPY', 'GBPCHF', 'USDSEK', 'CADJPY', 'GBPHUF', 'AUDUSD', 'USDHUF', 'EURJPY', 'HK-Shares', 'ESP35', 'LTCUSD', 'EURUSD', 'GBPCNH', 'NZDUSD', 'ETHUSD', 'EURHUF', 'EURZAR', 'EURRUB', 'GBPCZK', 'EURCHF', 'GBPEUR', 'GBPPLN', 'BTCUSD', 'GBPZAR', 'EURPLN', 'EURCZK', 'EURDKK', 'XAUUSD', 'CADCHF', 'NZDCHF', 'USDCHF', 'EURGBP', 'USDHKD') and timegranularity = 15 and pricedatetime >= current_timestamp - interval '20 days' order by pricedatetime asc;

Date: 2023-05-05 14:33:59
Duration: 334ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

select pricedatetime, open, high, low, close, timegranularity, symbol from t15 p inner join symbols s on p.symbolid = s.symbolid inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where brokerid = 622 and symbol in ('EURAUD', 'USDCNH', 'EURCNH', 'NZDJPY', 'NZDCAD', 'AUDSGD', 'CHFJPY', 'EURSEK', 'JPN225', 'AUDHKD', 'AUDCHF', 'WTISPOT', 'EURTRY', 'BRENTSPOT', 'GBPUSD', 'GBPHKD', 'AUDJPY', 'GBPTRY', 'GBPNOK', 'XAGUSD', 'GBPCAD', 'GBPNZD', 'GBPAUD', 'AUDCAD', 'EURHKD', 'USDSGD', 'GBPJPY', 'USDRUB', 'USDTRY', 'GBPRUB', 'USDMXN', 'AUDNZD', 'USDPLN', 'USDCZK', 'USDCAD', 'GBPSEK', 'USDNOK', 'EURNOK', 'GBPMXN', 'EURMXN', 'GBPDKK', 'USDZAR', 'USDDKK', 'EURNZD', 'EURCAD', 'USDJPY', 'GBPCHF', 'USDSEK', 'CADJPY', 'GBPHUF', 'AUDUSD', 'USDHUF', 'EURJPY', 'HK-Shares', 'ESP35', 'LTCUSD', 'EURUSD', 'GBPCNH', 'NZDUSD', 'ETHUSD', 'EURHUF', 'EURZAR', 'EURRUB', 'GBPCZK', 'EURCHF', 'GBPEUR', 'GBPPLN', 'BTCUSD', 'GBPZAR', 'EURPLN', 'EURCZK', 'EURDKK', 'XAUUSD', 'CADCHF', 'NZDCHF', 'USDCHF', 'EURGBP', 'USDHKD') and timegranularity = 15 and pricedatetime >= current_timestamp - interval '20 days' order by pricedatetime asc;

Date: 2023-05-05 14:17:54
Duration: 307ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

x Hide

select pricedatetime, open, high, low, close, timegranularity, symbol from t60 p inner join symbols s on p.symbolid = s.symbolid inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where brokerid = 622 and symbol in ('EURAUD', 'USDCNH', 'EURCNH', 'NZDJPY', 'NZDCAD', 'AUDSGD', 'CHFJPY', 'EURSEK', 'JPN225', 'AUDHKD', 'AUDCHF', 'WTISPOT', 'EURTRY', 'BRENTSPOT', 'GBPUSD', 'GBPHKD', 'AUDJPY', 'GBPTRY', 'GBPNOK', 'XAGUSD', 'GBPCAD', 'GBPNZD', 'GBPAUD', 'AUDCAD', 'EURHKD', 'USDSGD', 'GBPJPY', 'USDRUB', 'USDTRY', 'GBPRUB', 'USDMXN', 'AUDNZD', 'USDPLN', 'USDCZK', 'USDCAD', 'GBPSEK', 'USDNOK', 'EURNOK', 'GBPMXN', 'EURMXN', 'GBPDKK', 'USDZAR', 'USDDKK', 'EURNZD', 'EURCAD', 'USDJPY', 'GBPCHF', 'USDSEK', 'CADJPY', 'GBPHUF', 'AUDUSD', 'USDHUF', 'EURJPY', 'HK-Shares', 'ESP35', 'LTCUSD', 'EURUSD', 'GBPCNH', 'NZDUSD', 'ETHUSD', 'EURHUF', 'EURZAR', 'EURRUB', 'GBPCZK', 'EURCHF', 'GBPEUR', 'GBPPLN', 'BTCUSD', 'GBPZAR', 'EURPLN', 'EURCZK', 'EURDKK', 'XAUUSD', 'CADCHF', 'NZDCHF', 'USDCHF', 'EURGBP', 'USDHKD') and timegranularity = 60 and pricedatetime >= current_timestamp - interval '80 days' order by pricedatetime asc;

Date: 2023-05-05 14:17:54
Duration: 635ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

select pricedatetime, open, high, low, close, timegranularity, symbol from t60 p inner join symbols s on p.symbolid = s.symbolid inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where brokerid = 622 and symbol in ('EURAUD', 'USDCNH', 'EURCNH', 'NZDJPY', 'NZDCAD', 'AUDSGD', 'CHFJPY', 'EURSEK', 'JPN225', 'AUDHKD', 'AUDCHF', 'WTISPOT', 'EURTRY', 'BRENTSPOT', 'GBPUSD', 'GBPHKD', 'AUDJPY', 'GBPTRY', 'GBPNOK', 'XAGUSD', 'GBPCAD', 'GBPNZD', 'GBPAUD', 'AUDCAD', 'EURHKD', 'USDSGD', 'GBPJPY', 'USDRUB', 'USDTRY', 'GBPRUB', 'USDMXN', 'AUDNZD', 'USDPLN', 'USDCZK', 'USDCAD', 'GBPSEK', 'USDNOK', 'EURNOK', 'GBPMXN', 'EURMXN', 'GBPDKK', 'USDZAR', 'USDDKK', 'EURNZD', 'EURCAD', 'USDJPY', 'GBPCHF', 'USDSEK', 'CADJPY', 'GBPHUF', 'AUDUSD', 'USDHUF', 'EURJPY', 'HK-Shares', 'ESP35', 'LTCUSD', 'EURUSD', 'GBPCNH', 'NZDUSD', 'ETHUSD', 'EURHUF', 'EURZAR', 'EURRUB', 'GBPCZK', 'EURCHF', 'GBPEUR', 'GBPPLN', 'BTCUSD', 'GBPZAR', 'EURPLN', 'EURCZK', 'EURDKK', 'XAUUSD', 'CADCHF', 'NZDCHF', 'USDCHF', 'EURGBP', 'USDHKD') and timegranularity = 60 and pricedatetime >= current_timestamp - interval '80 days' order by pricedatetime asc;

Date: 2023-05-05 14:25:16
Duration: 421ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

select pricedatetime, open, high, low, close, timegranularity, symbol from t60 p inner join symbols s on p.symbolid = s.symbolid inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where brokerid = 622 and symbol in ('EURAUD', 'USDCNH', 'EURCNH', 'NZDJPY', 'NZDCAD', 'AUDSGD', 'CHFJPY', 'EURSEK', 'JPN225', 'AUDHKD', 'AUDCHF', 'WTISPOT', 'EURTRY', 'BRENTSPOT', 'GBPUSD', 'GBPHKD', 'AUDJPY', 'GBPTRY', 'GBPNOK', 'XAGUSD', 'GBPCAD', 'GBPNZD', 'GBPAUD', 'AUDCAD', 'EURHKD', 'USDSGD', 'GBPJPY', 'USDRUB', 'USDTRY', 'GBPRUB', 'USDMXN', 'AUDNZD', 'USDPLN', 'USDCZK', 'USDCAD', 'GBPSEK', 'USDNOK', 'EURNOK', 'GBPMXN', 'EURMXN', 'GBPDKK', 'USDZAR', 'USDDKK', 'EURNZD', 'EURCAD', 'USDJPY', 'GBPCHF', 'USDSEK', 'CADJPY', 'GBPHUF', 'AUDUSD', 'USDHUF', 'EURJPY', 'HK-Shares', 'ESP35', 'LTCUSD', 'EURUSD', 'GBPCNH', 'NZDUSD', 'ETHUSD', 'EURHUF', 'EURZAR', 'EURRUB', 'GBPCZK', 'EURCHF', 'GBPEUR', 'GBPPLN', 'BTCUSD', 'GBPZAR', 'EURPLN', 'EURCZK', 'EURDKK', 'XAUUSD', 'CADCHF', 'NZDCHF', 'USDCHF', 'EURGBP', 'USDHKD') and timegranularity = 60 and pricedatetime >= current_timestamp - interval '80 days' order by pricedatetime asc;

Date: 2023-05-05 14:33:59
Duration: 378ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

x Hide

select updateageforrelevantresults ();

Date: 2023-05-05 14:17:32
Duration: 29s610ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateageforrelevantresults ();

Date: 2023-05-05 14:02:18
Duration: 15s655ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateageforrelevantresults ();

Date: 2023-05-05 14:32:17
Duration: 15s579ms
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 = 558 AND (((s.symbol ilike '%eurusd%' AND timegranularity = 30);

Date: 2023-05-05 14:47:25
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.201
Application: PostgreSQL JDBC Driver

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 symbolgroup sg ON s.symbolid = sg.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 = 621 AND sg.groupid = 515852059852088308 AND breakout = - 1 AND patternlengthbars >= 20 AND patternquality >= 0.3 AND initialtrend >= 0.0 AND symmetry >= 0.0 AND noise <= 1.0 AND volumeincrease >= 0.0 AND TemporaryPattern = 0 AND PatternID & 65535 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND a.resultuid > 0 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2023-05-05 14:47:35
Duration: 312ms
Database: acaweb_fx
User: postgres
Remote: 192.168.0.42
Application: PostgreSQL JDBC Driver

/*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 symbolgroup sg ON s.symbolid = sg.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 = 572 AND sg.groupid = 515852059800200308 AND breakout = - 1 AND patternlengthbars >= 20 AND patternquality >= 0.3 AND initialtrend >= 0.0 AND symmetry >= 0.0 AND noise <= 1.0 AND volumeincrease >= 0.0 AND TemporaryPattern = 0 AND PatternID & 65535 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND a.resultuid > 0 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2023-05-05 14:53:59
Duration: 173ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.201
Application: PostgreSQL JDBC Driver

/*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 symbolgroup sg ON s.symbolid = sg.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 = 621 AND sg.groupid = 515852059852866308 AND breakout = - 1 AND patternlengthbars >= 20 AND patternquality >= 0.3 AND initialtrend >= 0.0 AND symmetry >= 0.0 AND noise <= 1.0 AND volumeincrease >= 0.0 AND TemporaryPattern = 0 AND PatternID & 65535 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND a.resultuid > 0 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2023-05-05 14:47:34
Duration: 153ms
Database: acaweb_fx
User: postgres
Remote: 192.168.0.42
Application: PostgreSQL JDBC Driver

x Hide

)) AND breakout >= 0.0 AND patternendtime = LatestBarAtBreakoutTime AND patternlengthbars >= 20 AND patternquality >= 0.3 AND initialtrend >= 0.0 AND symmetry >= 0.0 AND noise <= 1.0 AND volumeincrease >= 0.0 AND TemporaryPattern = 0 AND PatternID & 65535 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND a.resultuid > 601920299172072301 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2023-05-05 14:06:45
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.23
Application: PostgreSQL JDBC Driver

x Hide