WITH rar_max as ( ;

Date: 2023-01-07 06:46:34
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.135
Application: PostgreSQL JDBC Driver

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 = 660 AND sg.groupid = 515852059890091308 AND patternclassid = '2' AND patternlengthbars >= '20' AND a.PatternID & '39' > 0 AND dftt.dayofweek = '3' AND a.qtytp >= '0' AND a.resultuid > '-1931837601' 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-01-07 06:43:35
Duration: 2s632ms
Database: acaweb_fx
User: postgres
Remote: 192.168.0.23
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 = '1' AND patternlengthbars >= '20' AND a.PatternID & '39' > 0 AND dftt.dayofweek = '3' AND a.qtytp >= '0' AND a.resultuid > '1421692679' 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-01-07 06:35:55
Duration: 1s804ms
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 = 538 AND sg.groupid = 515852059729069308 AND patternclassid = '1' AND patternlengthbars >= '20' AND a.PatternID & '39' > 0 AND dftt.dayofweek = '3' AND a.qtytp >= '0' AND a.resultuid > '1421692679' 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-01-07 06:35:55
Duration: 1s800ms
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, 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 '%cadchf%' AND timegranularity = 60);

Date: 2023-01-07 06:45:26
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.201
Application: PostgreSQL JDBC Driver

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 = 495 AND sg.groupid = 515852059429487308 AND patternclassid = '1' AND patternlengthbars >= '20' AND a.PatternID & '3' > 0 AND dftt.dayofweek = '3' AND a.resultuid > '-791202545' 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-01-07 06:43:31
Duration: 1s13ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.23
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 = 495 AND sg.groupid = 515852059429487308 AND patternclassid = '2' AND patternlengthbars >= '20' AND a.PatternID & '3' > 0 AND dftt.dayofweek = '3' AND a.resultuid > '1767669615' 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-01-07 06:43:31
Duration: 922ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.23
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 = 495 AND sg.groupid = 515852059483997308 AND patternclassid = '1' AND patternlengthbars >= '20' AND a.PatternID & '3' > 0 AND dftt.dayofweek = '3' AND a.resultuid > '-2075553321' 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-01-07 06:43:37
Duration: 664ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.23
Application: PostgreSQL JDBC Driver

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 'atfx - 1';

Date: 2023-01-07 06:26:21
Duration: 4s266ms
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 'albforex - 1';

Date: 2023-01-07 06:25:41
Duration: 197ms
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 'forex4you - 1';

Date: 2023-01-07 06:26:23
Duration: 108ms
Database: acaweb_fx
User: postgres
Remote: 127.0.0.1
Application: [unknown]

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 'ADSSECURITIES - 1';

Date: 2023-01-07 06:25:21
Duration: 457ms
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 'ATFX - 1';

Date: 2023-01-07 06:26:22
Duration: 373ms
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 'ALBForex - 1';

Date: 2023-01-07 06:25:42
Duration: 325ms
Database: acaweb_fx
User: postgres
Remote: 127.0.0.1
Application: [unknown]

x Hide

select fixcandlegaps ('XM', false);

Date: 2023-01-07 06:06:09
Duration: 3s198ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select fixcandlegaps ('XM', false);

Date: 2023-01-07 06:06:27
Duration: 2s713ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select fixcandlegaps ('LEGACYFXMT5', false);

Date: 2023-01-07 06:06:05
Duration: 2s493ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

x Hide

select distinct ss.statsid from stats_success t inner join stats_symbols ss on t.symbolid = ss.symbolid where statsid in ( select statsid from stats where (0 = 0 or brokerid = 0)) and atbaridentified >= (current_timestamp - interval '12 months') and atbaridentified <= current_timestamp and type = 'cp' and pattern not ilike '%NON_LIQUID%' and (0 = 0 OR statsid >= 0) order by ss.statsid;

Date: 2023-01-07 06:42:25
Duration: 28s940ms
Database: acaweb_fx
User: postgres
Remote: 127.0.0.1
Application: psql

select distinct ss.statsid from stats_success t inner join stats_symbols ss on t.symbolid = ss.symbolid where statsid in ( select statsid from stats where (0 = 0 or brokerid = 0)) and atbaridentified >= (current_timestamp - interval '12 months') and atbaridentified <= current_timestamp and type = 'ekl' and pattern not ilike '%NON_LIQUID%' and (0 = 0 OR statsid >= 0) order by ss.statsid;

Date: 2023-01-07 06:42:56
Duration: 6s433ms
Database: acaweb_fx
User: postgres
Remote: 127.0.0.1
Application: psql

select distinct ss.statsid from stats_success t inner join stats_symbols ss on t.symbolid = ss.symbolid where statsid in ( select statsid from stats where (0 = 0 or brokerid = 0)) and atbaridentified >= (current_timestamp - interval '12 months') and atbaridentified <= current_timestamp and type = 'kl' and pattern not ilike '%NON_LIQUID%' and (0 = 0 OR statsid >= 0) order by ss.statsid;

Date: 2023-01-07 06:42:44
Duration: 6s365ms
Database: acaweb_fx
User: postgres
Remote: 127.0.0.1
Application: psql

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 'atfx - 1';

Date: 2023-01-07 06:26:14
Duration: 12s849ms
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 'xm - 2';

Date: 2023-01-07 06:28:11
Duration: 2s962ms
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 'valburycapital - 1';

Date: 2023-01-07 06:27:48
Duration: 935ms
Database: acaweb_fx
User: postgres
Remote: 127.0.0.1
Application: [unknown]

x Hide

)) AND patternlengthbars >= 20 AND averagequality >= 0.0 AND (timequality >= 0.0 OR timequality = - 1) AND errormargin >= 0.0 AND 1 - noise >= 0.0 AND s.nonliquid = 0 AND PatternID & 63 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND PatternEndPrice > - 1 AND a.resultuid > 601234969773701302 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, averagequality DESC LIMIT 50;

Date: 2023-01-07 06:11:57
Duration: 0ms
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, 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 = 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 AND ((rar.age IS NULL AND a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1)) OR rar.age >= 1) ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2023-01-07 06:41:41
Duration: 437ms
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, 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 = 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 AND ((rar.age IS NULL AND a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1)) OR rar.age >= 1) ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2023-01-07 06:41:41
Duration: 306ms
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, 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 = 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 AND ((rar.age IS NULL AND a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1)) OR rar.age >= 1) ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2023-01-07 06:41:41
Duration: 279ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.23
Application: PostgreSQL JDBC Driver

x Hide

select stats_calcstatsforallbrokers ();

Date: 2023-01-07 06:41:54
Duration: 1m53s
Database: acaweb_fx
User: postgres
Remote: 127.0.0.1
Application: psql

select stats_calcstatsforallbrokers ();

Date: 2023-01-07 06:41:12
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 127.0.0.1
Application: psql

x Hide

)) AND patternclassid = $1 AND patternlengthbars >= $2 AND a.PatternID & $3 > 0 AND dftt.dayofweek = $4 AND a.resultuid > $5 AND c.nonliquid = $6 AND c.deleted = 0 AND dss.enabled = 1 ORDER BY relevant DESC, age asc, PatternEndTime DESC, qtp DESC LIMIT 50;

Date: 2023-01-07 06:23:58
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.0.42
Application: PostgreSQL JDBC Driver

x Hide

SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1), kr AS ( SELECT a.*, rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, 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, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 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 INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true 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 kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ($3 = 0 OR s.timegranularity in ($4, $5, $6, $7, $8, $9, $10)) AND ($11 = 0 OR s.exchange in ($12)) AND ($13 = 0 OR coalesce(bim.code, s.symbol) in ($14)) AND ($15 = 0 OR p.patternname in ($16)) AND ($17 = 0 OR kr.patternclassid in ($18, $19)) AND ($20 = 0 OR kr.patternlengthbars <= $21)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $22 OR relevant = 1) AND ($23 = 0 OR age <= $24) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;

Date: 2023-01-07 06:43:41
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.250
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 = 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-01-07 06:41:41
Duration: 108ms
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 = 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-01-07 06:41:41
Duration: 97ms
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-01-07 06:41:41
Duration: 60ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.23
Application: PostgreSQL JDBC Driver

x Hide