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), results AS ( SELECT DISTINCT ON (s.symbolid) 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, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340)) AND ($341 = 0 OR p.patternname in ($342)) AND ($343 = 0 OR kr.patternclassid in ($344, $345)) AND ($346 = 0 OR kr.patternlengthbars <= $347) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $348 OR relevant = 1) AND ($349 = 0 OR age <= $350) ORDER BY identified DESC, length DESC;

Date: 2022-03-23 11:38:43
Duration: 0ms
Database: acaweb_fx
User: postgres

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 > 577827524 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2022-03-23 11:41:29
Duration: 0ms
Database: acaweb_fx
User: postgres

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), results AS ( SELECT DISTINCT ON (s.symbolid) kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, 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 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 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)) AND ($5 = 0 OR s.exchange in ($6)) AND ($7 = 0 OR s.symbol in ($8)) AND ($9 = 0 OR p.patternname in ($10)) AND ($11 = 0 OR kr.patternclassid in ($12)) AND ($13 = 0 OR kr.patternlengthbars <= $14) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $15 OR relevant = 1) AND ($16 = 0 OR age <= $17) ORDER BY identified DESC, length DESC;

Date: 2022-03-23 11:37:44
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), fr AS ( SELECT a.*, rr.age, rr.relevant from fibonacci_results a LEFT OUTER JOIN relevance_fibonacci_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) END), results AS ( SELECT DISTINCT ON (s.symbolid) fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, s.symbol AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, CASE WHEN fr.age IS NOT NULL THEN fr.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN fr.relevant IS NOT NULL THEN fr.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.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 downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($3 = 0 OR s.timegranularity in ($4)) AND ($5 = 0 OR s.exchange in ($6)) AND ($7 = 0 OR s.symbol in ($8)) AND ($9 = 0 OR fr.pattern in ($10)) AND ($11 = 0 OR fr.patternlengthbars <= $12) AND ($13 = 0 OR ($14 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($15 = 2 AND fr.timed < cast('1970-01-01' as timestamp))) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $16 OR relevant = 1) AND ($17 = 0 OR age <= $18) ORDER BY identified DESC, length DESC;

Date: 2022-03-23 11:37:45
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), fr AS ( SELECT a.*, rr.age, rr.relevant from fibonacci_results a LEFT OUTER JOIN relevance_fibonacci_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) END), results AS ( SELECT DISTINCT ON (s.symbolid) fr.resultuid AS resultuid, fr.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, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, CASE WHEN fr.age IS NOT NULL THEN fr.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN fr.relevant IS NOT NULL THEN fr.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.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 downloadersymbolsettings dss ON fr.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 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 fr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND (fr.simulation = 0 OR fr.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, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245)) AND ($246 = 0 OR fr.pattern in ($247)) AND ($248 = 0 OR fr.patternlengthbars <= $249) AND ($250 = 0 OR ($251 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($252 = 2 AND fr.timed < cast('1970-01-01' as timestamp))) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $253 OR relevant = 1) AND ($254 = 0 OR age <= $255) ORDER BY identified DESC, length DESC;

Date: 2022-03-23 11:39:42
Duration: 0ms
Database: acaweb_fx
User: postgres

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), results AS ( SELECT DISTINCT ON (s.symbolid) kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, 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 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 s.symbol in ($14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340)) AND ($341 = 0 OR p.patternname in ($342)) AND ($343 = 0 OR kr.patternclassid in ($344, $345)) AND ($346 = 0 OR kr.patternlengthbars <= $347) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $348 OR relevant = 1) AND ($349 = 0 OR age <= $350) ORDER BY identified DESC, length DESC;

Date: 2022-03-23 11:40:39
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

) OR ((s.symbol ilike '%spotcrude%' AND timegranularity = 1440))) 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 > 578262387 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2022-03-23 11:42:31
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

) OR ((s.symbol ilike '%gbpcad%' AND timegranularity = 15)) OR ((s.symbol ilike '%gbpchf%' AND timegranularity = 15)) OR ((s.symbol ilike '%gbpjpy%' AND timegranularity = 15)) OR ((s.symbol ilike '%gbpnzd%' AND timegranularity = 15)) OR ((s.symbol ilike '%gbpusd%' AND timegranularity = 15))) 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 > 578281187 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2022-03-23 11:46:31
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

SELECT distinct a.symbolid, p.resultuid, case when a.breakout >= 0 then 1 else 2 end as type, a.resultid, a.bandwidth, a.patternlengthbars, a.patternendtime, a.resy0, a.supporty0, a.resy1, a.supporty1, a.direction, a.predictionpriceto, a.patternendprice, a.predictionpricefrom, a.resx0, a.supportx0, a.resgradient, a.supportgradient FROM relevance_autochartist_results p INNER JOIN autochartist_results a ON p.resultuid = a.resultuid INNER JOIN autochartist_stocklist asl ON a.symbolid = asl.symbolid WHERE asl.enabled = 1 AND asl.recognitionengine ILIKE 'RakutenSecurities - 1';

Date: 2022-03-23 11:46:05
Duration: 257ms
Database: acaweb_fx
User: postgres

SELECT distinct a.symbolid, p.resultuid, case when a.breakout >= 0 then 1 else 2 end as type, a.resultid, a.bandwidth, a.patternlengthbars, a.patternendtime, a.resy0, a.supporty0, a.resy1, a.supporty1, a.direction, a.predictionpriceto, a.patternendprice, a.predictionpricefrom, a.resx0, a.supportx0, a.resgradient, a.supportgradient FROM relevance_autochartist_results p INNER JOIN autochartist_results a ON p.resultuid = a.resultuid INNER JOIN autochartist_stocklist asl ON a.symbolid = asl.symbolid WHERE asl.enabled = 1 AND asl.recognitionengine ILIKE 'VALBURYCAPITAL - 1';

Date: 2022-03-23 11:46:07
Duration: 167ms
Database: acaweb_fx
User: postgres

SELECT distinct a.symbolid, p.resultuid, case when a.breakout >= 0 then 1 else 2 end as type, a.resultid, a.bandwidth, a.patternlengthbars, a.patternendtime, a.resy0, a.supporty0, a.resy1, a.supporty1, a.direction, a.predictionpriceto, a.patternendprice, a.predictionpricefrom, a.resx0, a.supportx0, a.resgradient, a.supportgradient FROM relevance_autochartist_results p INNER JOIN autochartist_results a ON p.resultuid = a.resultuid INNER JOIN autochartist_stocklist asl ON a.symbolid = asl.symbolid WHERE asl.enabled = 1 AND asl.recognitionengine ILIKE 'RakutenSecurities - 1';

Date: 2022-03-23 11:31:24
Duration: 145ms
Database: acaweb_fx
User: postgres

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 = 660 and symbol in ('GERMAN30', 'EURJPY', 'BCHUSD', 'VIV.pa', 'ACKB.br', 'BCHEUR', 'FRENCH40', 'XRPUSD', 'LLOY.l', 'UBSG.vx', 'AAPL', 'VIE.pa', 'EURPLN', 'SPANISH35', 'FSLR', 'DIS', 'FP.pa', 'XAUUSD', 'USDJPY', 'MSFT', 'US30', 'NZDJPY', 'BA', 'PANW', 'CBK.de', 'IBE.mc', 'ALV.de', 'CAT', 'NGAS', 'USDZAR', 'BNP.pa', 'IFX.de', 'COTTON', 'GBPCHF', 'SAP.de', 'CADJPY', 'BAC', 'BTCUSD', 'UNA.as', 'BTCEUR', 'QCOM', 'PYPL', 'AUDJPY', 'C', 'CHFJPY', 'LTCEUR', 'XAGUSD', 'EURZAR', 'EURTRY', 'WMT', 'ETHUSD', 'UK100', 'NOVN.vx', 'T', 'NKE', 'USDSEK', 'GBPUSD', 'MC.pa', 'GBPJPY', 'DTE.de', 'LTCUSD', 'EURMXN', 'GBPAUD', 'NZDCHF', 'USDMXN', 'ACA.pa', 'USTECH100', 'BMW.de', 'LR.pa', 'EURSEK', 'NFLX', 'GLE.pa', 'GBPCAD', 'LMT', 'RI.pa', 'EDF.pa', 'AMZN', 'USDX', 'US500', 'NETHERLAND25', 'SIE.de', 'AD.as', 'URW.as', 'SRE', 'TKA.de', 'XRPEUR', 'USDPLN', 'NZDCAD', 'USDTRY', 'USVIX', 'PUB.pa', 'USDCZK', 'USDCHF', 'EURNZD', 'USDHUF', 'EURAUD', 'USDNOK', 'EURHUF', 'HEIA.as', 'SAF.pa', 'ETHEUR', 'BN.pa', 'CORN', 'COCOA', 'USDCAD', 'EURCAD', 'USDSGD', 'AUDCAD', 'HAS', 'EURNOK', 'EURGBP', 'WTI', 'BRENT', 'EURCZK', 'TEVA', 'BABA', 'EN.pa', 'CRON', 'CGC', 'SUGAR', 'GBPNZD', 'SNAP', 'ADBE', 'CVX', 'SU.pa', 'ACB', 'TGT', 'EURCHF', 'EURUSD', 'VZ', 'USDRON', 'RNO.pa', 'DPW.de', 'M', 'ML.pa', 'HOG', 'BAS.de', 'GBPZAR', 'AUDCHF', 'ORA.pa', 'INTC', 'IBM', 'SBUX', 'TWTR', 'DBK.de', 'VOW3.de', 'CAP.pa', 'AGS.br', 'DAI.de', 'WHEAT', 'LHA.de', 'GE', 'AIR.pa', 'NOV', 'COFFEE', 'EL.pa', 'JNJ', 'TEF.mc', 'SGO.pa', 'CADCHF', 'ADS.de', 'NZDUSD', 'AC.pa', 'PG', 'HSY', 'GS', 'RWE.de', 'MRK.de', 'CS.pa', 'AUDNZD', 'EBAY', 'LYFT', 'HPQ', 'AUDUSD', 'V', 'VK.pa', 'MMM', 'FB', 'CA.pa', 'UBER', 'LVS', 'KO', 'AIG', 'EOAN.de', 'SAN.pa', 'NVDA', 'AI.pa', 'REGN', 'JPN225', 'SWISS20', 'RACE', 'JPM', 'DLTR', 'CSCO', 'BAYN.de', 'PFE', 'AXP', 'GOOG', 'BRKB', 'GM', 'FEYE', 'HEN3.de', 'GILD', 'INGA.as', 'MS', 'SMSN.l', 'XOM', 'PM', 'BIDU', 'TSLA') and timegranularity = 60 and pricedatetime >= current_timestamp - interval '80 days' order by pricedatetime asc;

Date: 2022-03-23 11:48:45
Duration: 28s830ms
Database: acaweb_fx
User: postgres

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 = 689 and symbol in ('#DBK', 'USDTRY', '#WB', 'ESP35', 'USDHUF', 'AUS200', '#MSFT', 'USDJPY', 'AUDNZD', 'CADJPY', 'BTCUSD', '#MCD', '#BA', '#CBK', 'EURTRY', '#ALV', '#CAT', '#IFX', 'CADCHF', '#EON', '#SAP', '#QCOM', '#BAC', 'USDSEK', 'AUDUSD', 'AUDJPY', 'CHFJPY', 'ETHUSD', '#DIS', 'JP225', 'UK100', 'EURPLN', '#NKE', 'XAUUSD', 'GBPJPY', 'USDX', '#BEI', 'BRENT', 'GBPAUD', 'HKCH50', 'EURCAD', '#NFLX', '#LMT', 'GBPNZD', 'NZDJPY', '#T', 'USDCHF', 'NZDCAD', 'LTCUSD', 'SPX500', '#DB1', 'GBPCHF', 'WTI', 'USDDKK', 'NZDCHF', 'USDPLN', 'USDNOK', 'EURAUD', '#CVX', 'NZDUSD', '#INTC', 'EURGBP', 'XAGUSD', 'USDCAD', 'EURNZD', 'GBPCAD', 'GBPUSD', 'USDSGD', '#TWTR', '#BMW', 'USDZAR', '#ORCL', 'USDCZK', 'EURHUF', '#RWE', '#MUV2', 'USDRUB', 'GER30', '#BIDU', '#VOW', '#BAS', '#SNP', '#DTE', '#BABA', '#PTR', '#FDX', '#JD', 'USDMXN', 'EURCHF', '#SIE', 'AUDCAD', 'EURJPY', '#V', 'AUDCHF', '#C', '#MA', '#FB', 'USDCNH', '#AIG', '#F', 'HK50', '#DPW', 'FRA40', '#PG', 'CHI50', '#TSLA', 'US30', '#ADS', 'IT40', '#XOM', 'EURUSD', '#PFE', '#HPQ', '#GS', 'NAS100', '#JPM', '#NTES', '#LIN', '#CSCO', 'USDHKD', '#GOOG', '#BAYN', '#GE', '#LHA', '#FME', '#EBAY', '#KO', '#CL', 'EU50', '#JNJ', '#IBM', '#MMM', '#GM', '#DAI', '#UBER') and timegranularity = 60 and pricedatetime >= current_timestamp - interval '80 days' order by pricedatetime asc;

Date: 2022-03-23 11:46:09
Duration: 25s318ms
Database: acaweb_fx
User: postgres

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 = 689 and symbol in ('USDJPY', 'AUDUSD', 'EURCAD', 'USDCHF', 'EURAUD', 'NZDUSD', 'USDCAD', 'EURNZD', 'GBPUSD', 'EURCHF', 'EURJPY', 'EURUSD') and timegranularity = 60 and pricedatetime >= current_timestamp - interval '80 days' order by pricedatetime asc;

Date: 2022-03-23 11:45:36
Duration: 3s804ms
Database: acaweb_fx
User: postgres

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 = 660 and symbol in ('GERMAN30', 'EURJPY', 'BCHUSD', 'VIV.pa', 'ACKB.br', 'BCHEUR', 'FRENCH40', 'XRPUSD', 'LLOY.l', 'UBSG.vx', 'AAPL', 'VIE.pa', 'EURPLN', 'SPANISH35', 'FSLR', 'DIS', 'FP.pa', 'XAUUSD', 'USDJPY', 'MSFT', 'US30', 'NZDJPY', 'BA', 'PANW', 'CBK.de', 'IBE.mc', 'ALV.de', 'CAT', 'NGAS', 'USDZAR', 'BNP.pa', 'IFX.de', 'COTTON', 'GBPCHF', 'SAP.de', 'CADJPY', 'BAC', 'BTCUSD', 'UNA.as', 'BTCEUR', 'QCOM', 'PYPL', 'AUDJPY', 'C', 'CHFJPY', 'LTCEUR', 'XAGUSD', 'EURZAR', 'EURTRY', 'WMT', 'ETHUSD', 'UK100', 'NOVN.vx', 'T', 'NKE', 'USDSEK', 'GBPUSD', 'MC.pa', 'GBPJPY', 'DTE.de', 'LTCUSD', 'EURMXN', 'GBPAUD', 'NZDCHF', 'USDMXN', 'ACA.pa', 'USTECH100', 'BMW.de', 'LR.pa', 'EURSEK', 'NFLX', 'GLE.pa', 'GBPCAD', 'LMT', 'RI.pa', 'EDF.pa', 'AMZN', 'USDX', 'US500', 'NETHERLAND25', 'SIE.de', 'AD.as', 'URW.as', 'SRE', 'TKA.de', 'XRPEUR', 'USDPLN', 'NZDCAD', 'USDTRY', 'USVIX', 'PUB.pa', 'USDCZK', 'USDCHF', 'EURNZD', 'USDHUF', 'EURAUD', 'USDNOK', 'EURHUF', 'HEIA.as', 'SAF.pa', 'ETHEUR', 'BN.pa', 'CORN', 'COCOA', 'USDCAD', 'EURCAD', 'USDSGD', 'AUDCAD', 'HAS', 'EURNOK', 'EURGBP', 'WTI', 'BRENT', 'EURCZK', 'TEVA', 'BABA', 'EN.pa', 'CRON', 'CGC', 'SUGAR', 'GBPNZD', 'SNAP', 'ADBE', 'CVX', 'SU.pa', 'ACB', 'TGT', 'EURCHF', 'EURUSD', 'VZ', 'USDRON', 'RNO.pa', 'DPW.de', 'M', 'ML.pa', 'HOG', 'BAS.de', 'GBPZAR', 'AUDCHF', 'ORA.pa', 'INTC', 'IBM', 'SBUX', 'TWTR', 'DBK.de', 'VOW3.de', 'CAP.pa', 'AGS.br', 'DAI.de', 'WHEAT', 'LHA.de', 'GE', 'AIR.pa', 'NOV', 'COFFEE', 'EL.pa', 'JNJ', 'TEF.mc', 'SGO.pa', 'CADCHF', 'ADS.de', 'NZDUSD', 'AC.pa', 'PG', 'HSY', 'GS', 'RWE.de', 'MRK.de', 'CS.pa', 'AUDNZD', 'EBAY', 'LYFT', 'HPQ', 'AUDUSD', 'V', 'VK.pa', 'MMM', 'FB', 'CA.pa', 'UBER', 'LVS', 'KO', 'AIG', 'EOAN.de', 'SAN.pa', 'NVDA', 'AI.pa', 'REGN', 'JPN225', 'SWISS20', 'RACE', 'JPM', 'DLTR', 'CSCO', 'BAYN.de', 'PFE', 'AXP', 'GOOG', 'BRKB', 'GM', 'FEYE', 'HEN3.de', 'GILD', 'INGA.as', 'MS', 'SMSN.l', 'XOM', 'PM', 'BIDU', 'TSLA') and timegranularity = 30 and pricedatetime >= current_timestamp - interval '40 days' order by pricedatetime asc;

Date: 2022-03-23 11:48:50
Duration: 33s552ms
Database: acaweb_fx
User: postgres

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 = 689 and symbol in ('#DBK', 'USDTRY', '#WB', 'ESP35', 'USDHUF', 'AUS200', '#MSFT', 'USDJPY', 'AUDNZD', 'CADJPY', 'BTCUSD', '#MCD', '#BA', '#CBK', 'EURTRY', '#ALV', '#CAT', '#IFX', 'CADCHF', '#EON', '#SAP', '#QCOM', '#BAC', 'USDSEK', 'AUDUSD', 'AUDJPY', 'CHFJPY', 'ETHUSD', '#DIS', 'JP225', 'UK100', 'EURPLN', '#NKE', 'XAUUSD', 'GBPJPY', 'USDX', '#BEI', 'BRENT', 'GBPAUD', 'HKCH50', 'EURCAD', '#NFLX', '#LMT', 'GBPNZD', 'NZDJPY', '#T', 'USDCHF', 'NZDCAD', 'LTCUSD', 'SPX500', '#DB1', 'GBPCHF', 'WTI', 'USDDKK', 'NZDCHF', 'USDPLN', 'USDNOK', 'EURAUD', '#CVX', 'NZDUSD', '#INTC', 'EURGBP', 'XAGUSD', 'USDCAD', 'EURNZD', 'GBPCAD', 'GBPUSD', 'USDSGD', '#TWTR', '#BMW', 'USDZAR', '#ORCL', 'USDCZK', 'EURHUF', '#RWE', '#MUV2', 'USDRUB', 'GER30', '#BIDU', '#VOW', '#BAS', '#SNP', '#DTE', '#BABA', '#PTR', '#FDX', '#JD', 'USDMXN', 'EURCHF', '#SIE', 'AUDCAD', 'EURJPY', '#V', 'AUDCHF', '#C', '#MA', '#FB', 'USDCNH', '#AIG', '#F', 'HK50', '#DPW', 'FRA40', '#PG', 'CHI50', '#TSLA', 'US30', '#ADS', 'IT40', '#XOM', 'EURUSD', '#PFE', '#HPQ', '#GS', 'NAS100', '#JPM', '#NTES', '#LIN', '#CSCO', 'USDHKD', '#GOOG', '#BAYN', '#GE', '#LHA', '#FME', '#EBAY', '#KO', '#CL', 'EU50', '#JNJ', '#IBM', '#MMM', '#GM', '#DAI', '#UBER') and timegranularity = 30 and pricedatetime >= current_timestamp - interval '40 days' order by pricedatetime asc;

Date: 2022-03-23 11:46:06
Duration: 21s919ms
Database: acaweb_fx
User: postgres

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 = 689 and symbol in ('USDJPY', 'AUDUSD', 'EURCAD', 'USDCHF', 'EURAUD', 'NZDUSD', 'USDCAD', 'EURNZD', 'GBPUSD', 'EURCHF', 'EURJPY', 'EURUSD') and timegranularity = 30 and pricedatetime >= current_timestamp - interval '40 days' order by pricedatetime asc;

Date: 2022-03-23 11:45:37
Duration: 4s844ms
Database: acaweb_fx
User: postgres

x Hide

) OR ((symbol ilike '%eurusd%' AND timegranularity = 60)) OR ((symbol ilike '%usdjpy%' AND timegranularity = 60)) OR ((symbol ilike '%gbpusd%' AND timegranularity = 60)) OR ((symbol ilike '%audusd%' AND timegranularity = 60)) OR ((symbol ilike '%usdcad%' AND timegranularity = 60)) OR ((symbol ilike '%usdchf%' AND timegranularity = 60)) OR ((symbol ilike '%nzdusd%' AND timegranularity = 60)) OR ((symbol ilike '%eurgbp%' AND timegranularity = 60)) OR ((symbol ilike '%eurjpy%' AND timegranularity = 60)) OR ((symbol ilike '%gbpjpy%' AND timegranularity = 60)) OR ((symbol ilike '%eurcad%' AND timegranularity = 60)) OR ((symbol ilike '%audjpy%' AND timegranularity = 60)) OR ((symbol ilike '%euraud%' AND timegranularity = 60)) OR ((symbol ilike '%eurchf%' AND timegranularity = 60)) OR ((symbol ilike '%audnzd%' AND timegranularity = 60)) OR ((symbol ilike '%nzdjpy%' AND timegranularity = 60)) OR ((symbol ilike '%gbpaud%' AND timegranularity = 60)) OR ((symbol ilike '%audcad%' AND timegranularity = 60)) OR ((symbol ilike '%cadjpy%' AND timegranularity = 60)) OR ((symbol ilike '%chfjpy%' AND timegranularity = 60)) OR ((symbol ilike '%audchf%' AND timegranularity = 60)) OR ((symbol ilike '%cadchf%' AND timegranularity = 60)) OR ((symbol ilike '%gbpchf%' AND timegranularity = 60)) OR ((symbol ilike '%gbpnzd%' AND timegranularity = 60))) AND patternlengthbars >= 40 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 & 1 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND PatternEndPrice > - 1 AND a.resultuid > 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, averagequality DESC LIMIT 50;

Date: 2022-03-23 11:31:55
Duration: 0ms
Database: acaweb_fx
User: postgres