WITH rar_max as ( ;

Date: 2023-03-16 06:38:58
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.250
Application: PostgreSQL JDBC Driver

x Hide

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

Date: 2023-03-16 06:20:07
Duration: 5s214ms
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-03-16 06:30:04
Duration: 2s948ms
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-03-16 06:40:05
Duration: 2s657ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.25
Application: [unknown]

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 '%xauusd%' AND timegranularity = 1440);

Date: 2023-03-16 06:39:43
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.201
Application: PostgreSQL JDBC Driver

x Hide

select fixcandlegaps ('XM', false);

Date: 2023-03-16 06:06:10
Duration: 2s654ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select fixcandlegaps ('LEGACYFXMT5', false);

Date: 2023-03-16 06:06:06
Duration: 2s560ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select fixcandlegaps ('ATFX', false);

Date: 2023-03-16 06:06:18
Duration: 2s557ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

x Hide

SELECT DISTINCT a.resultuid, a.breakoutbars, a.patternid, CAST(a.x0 as timestamp) as x0, CAST(a.x1 as timestamp) as x1, CAST(x2 as timestamp) as x2, CASE WHEN (x3 != '' and x3 != '0') THEN CAST(x3 as timestamp) ELSE CAST('1900-01-01' as timestamp) END as x3, CASE WHEN (x4 != '' and x4 != '0') THEN CAST(x4 as timestamp) ELSE CAST('1900-01-01' as timestamp) END as x4, CASE WHEN (x5 != '' and x5 != '0') THEN CAST(x5 as timestamp) ELSE CAST('1900-01-01' as timestamp) END as x5, CASE WHEN (x6 != '' and x6 != '0') THEN CAST(x6 as timestamp) ELSE CAST('1900-01-01' as timestamp) END as x6, CASE WHEN (x7 != '' and x7 != '0') THEN CAST(x7 as timestamp) ELSE CAST('1900-01-01' as timestamp) END as x7, CASE WHEN (x8 != '' and x8 != '0') THEN CAST(x8 as timestamp) ELSE CAST('1900-01-01' as timestamp) END as x8, CASE WHEN (x9 != '' and x9 != '0') THEN CAST(x9 as timestamp) ELSE CAST('1900-01-01' as timestamp) END as x9, CAST(a.atbaridentified as timestamp) as atbaridentified, CAST(a.patternstarttime as timestamp) as patternstarttime, a.breakoutprice, a.symbolid, a.approachingregion, a.patternprice, a.errorMargin, a.bandwidth, a.qtytp, a.patternlengthbars, a.symbolid, a.uniquepointsvalue, a.predictionpricefrom, a.predictionpriceto, a.breakout, a.direction, a.furthestPrice, a.approachingtimestamp, a.atPriceIdentified FROM keylevels_results a INNER JOIN symbols s on a.symbolid = s.symbolid INNER JOIN autochartist_stocklist aus on s.symbolid = aus.symbolid LEFT OUTER JOIN relevance_keylevels_results rkl on a.resultuid = rkl.resultuid WHERE aus.Enabled = 1 AND (rkl.relevant = 1 OR a.resultuid > ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1)) AND aus.RecognitionEngine ILIKE 'iqfeed_fx - 1';

Date: 2023-03-16 06:06:38
Duration: 130ms
Database: acaweb_fx
User: postgres
Remote: 127.0.0.1
Application: [unknown]

SELECT DISTINCT a.resultuid, a.breakoutbars, a.patternid, CAST(a.x0 as timestamp) as x0, CAST(a.x1 as timestamp) as x1, CAST(x2 as timestamp) as x2, CASE WHEN (x3 != '' and x3 != '0') THEN CAST(x3 as timestamp) ELSE CAST('1900-01-01' as timestamp) END as x3, CASE WHEN (x4 != '' and x4 != '0') THEN CAST(x4 as timestamp) ELSE CAST('1900-01-01' as timestamp) END as x4, CASE WHEN (x5 != '' and x5 != '0') THEN CAST(x5 as timestamp) ELSE CAST('1900-01-01' as timestamp) END as x5, CASE WHEN (x6 != '' and x6 != '0') THEN CAST(x6 as timestamp) ELSE CAST('1900-01-01' as timestamp) END as x6, CASE WHEN (x7 != '' and x7 != '0') THEN CAST(x7 as timestamp) ELSE CAST('1900-01-01' as timestamp) END as x7, CASE WHEN (x8 != '' and x8 != '0') THEN CAST(x8 as timestamp) ELSE CAST('1900-01-01' as timestamp) END as x8, CASE WHEN (x9 != '' and x9 != '0') THEN CAST(x9 as timestamp) ELSE CAST('1900-01-01' as timestamp) END as x9, CAST(a.atbaridentified as timestamp) as atbaridentified, CAST(a.patternstarttime as timestamp) as patternstarttime, a.breakoutprice, a.symbolid, a.approachingregion, a.patternprice, a.errorMargin, a.bandwidth, a.qtytp, a.patternlengthbars, a.symbolid, a.uniquepointsvalue, a.predictionpricefrom, a.predictionpriceto, a.breakout, a.direction, a.furthestPrice, a.approachingtimestamp, a.atPriceIdentified FROM keylevels_results a INNER JOIN symbols s on a.symbolid = s.symbolid INNER JOIN autochartist_stocklist aus on s.symbolid = aus.symbolid LEFT OUTER JOIN relevance_keylevels_results rkl on a.resultuid = rkl.resultuid WHERE aus.Enabled = 1 AND (rkl.relevant = 1 OR a.resultuid > ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1)) AND aus.RecognitionEngine ILIKE 'iqfeed_fx - 1';

Date: 2023-03-16 06:06:38
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 127.0.0.1
Application: [unknown]

x Hide

select updateageforrelevantresults ();

Date: 2023-03-16 06:32:37
Duration: 34s666ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateageforrelevantresults ();

Date: 2023-03-16 06:47:12
Duration: 9s736ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateageforrelevantresults ();

Date: 2023-03-16 06:17:12
Duration: 9s256ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

x Hide

WITH a AS ( SELECT *, row_number() OVER (PARTITION BY symbolid, direction ORDER BY datetime DESC) r FROM sa_hist_consecutivecandles ) SELECT DISTINCT a.symbolid, a.qty, a.percentile, a.direction FROM a INNER JOIN symbols s on a.symbolid = s.symbolid INNER JOIN autochartist_stocklist aus on s.symbolid = aus.symbolid WHERE aus.Enabled = 1 AND a.r = 1 AND aus.RecognitionEngine ILIKE 'IQFEED_FX - 1';

Date: 2023-03-16 06:06:39
Duration: 496ms
Database: acaweb_fx
User: postgres
Remote: 127.0.0.1
Application: [unknown]

WITH a AS ( SELECT *, row_number() OVER (PARTITION BY symbolid, direction ORDER BY datetime DESC) r FROM sa_hist_consecutivecandles ) SELECT DISTINCT a.symbolid, a.qty, a.percentile, a.direction FROM a INNER JOIN symbols s on a.symbolid = s.symbolid INNER JOIN autochartist_stocklist aus on s.symbolid = aus.symbolid WHERE aus.Enabled = 1 AND a.r = 1 AND aus.RecognitionEngine ILIKE 'IQFEED_FX - 1';

Date: 2023-03-16 06:06:39
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 127.0.0.1
Application: [unknown]

x Hide

SELECT DISTINCT a.resultuid, a.resultid, a.patternlengthbars, a.patternendtime, a.predictionpriceto, a.predictionpricefrom, a.direction, a.breakout, a.bandwidth, a.resy0, a.resy1, a.supporty0, a.supporty1, a.resx0, a.resx1, a.supportx0, a.supportx1, a.patternendprice, a.symbolid, a.resgradient, a.supportgradient, a.pattern FROM autochartist_results a INNER JOIN symbols s on a.symbolid = s.symbolid INNER JOIN autochartist_stocklist aus on s.symbolid = aus.symbolid LEFT OUTER JOIN relevance_autochartist_results rev on a.resultuid = rev.resultuid WHERE aus.Enabled = 1 AND (rev.relevant = 1 OR a.resultuid > ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1)) AND aus.RecognitionEngine ILIKE 'iqfeed_fx - 1';

Date: 2023-03-16 06:06:37
Duration: 1s570ms
Database: acaweb_fx
User: postgres
Remote: 127.0.0.1
Application: [unknown]

SELECT DISTINCT a.resultuid, a.resultid, a.patternlengthbars, a.patternendtime, a.predictionpriceto, a.predictionpricefrom, a.direction, a.breakout, a.bandwidth, a.resy0, a.resy1, a.supporty0, a.supporty1, a.resx0, a.resx1, a.supportx0, a.supportx1, a.patternendprice, a.symbolid, a.resgradient, a.supportgradient, a.pattern FROM autochartist_results a INNER JOIN symbols s on a.symbolid = s.symbolid INNER JOIN autochartist_stocklist aus on s.symbolid = aus.symbolid LEFT OUTER JOIN relevance_autochartist_results rev on a.resultuid = rev.resultuid WHERE aus.Enabled = 1 AND (rev.relevant = 1 OR a.resultuid > ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1)) AND aus.RecognitionEngine ILIKE 'iqfeed_fx - 1';

Date: 2023-03-16 06:06:37
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 127.0.0.1
Application: [unknown]

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 = 538 AND sg.groupid = 515852059729069308 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-03-16 06:01:15
Duration: 325ms
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 = 538 AND sg.groupid = 515852059729069308 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 > 601639826890289301 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2023-03-16 06:33:16
Duration: 80ms
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 = 538 AND sg.groupid = 515852059729069308 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 > 601639887164911301 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2023-03-16 06:49:16
Duration: 61ms
Database: acaweb_fx
User: postgres
Remote: 192.168.0.42
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 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 WHERE b.brokerid = 529 AND sg.groupid = 515852059758978308 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 PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2023-03-16 06:09:13
Duration: 145ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.23
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 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 WHERE b.brokerid = 529 AND sg.groupid = 515852059718346308 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 PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2023-03-16 06:09:13
Duration: 137ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.23
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 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 WHERE b.brokerid = 529 AND sg.groupid = 515852059709228308 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 PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2023-03-16 06:09:13
Duration: 132ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.23
Application: PostgreSQL JDBC Driver

x Hide