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, 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 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 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 fr.pattern in ($342)) AND ($343 = 0 OR fr.patternlengthbars <= $344) AND ($345 = 0 OR ($346 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($347 = 2 AND fr.timed < cast('1970-01-01' as timestamp))) 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-26 09:30:07
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-26 09:29:57
Duration: 0ms
Database: acaweb_fx
User: postgres

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: 2022-03-26 09:04:27
Duration: 2s294ms
Database: acaweb_fx
User: postgres

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

Date: 2022-03-26 09:50:52
Duration: 145ms
Database: acaweb_fx
User: postgres

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

Date: 2022-03-26 09:51:35
Duration: 137ms
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, 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)) AND ($264 = 0 OR p.patternname in ($265)) AND ($266 = 0 OR kr.patternclassid in ($267, $268)) AND ($269 = 0 OR kr.patternlengthbars <= $270) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $271 OR relevant = 1) AND ($272 = 0 OR age <= $273) ORDER BY identified DESC, length DESC;

Date: 2022-03-26 09:55:37
Duration: 0ms
Database: acaweb_fx
User: postgres

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 > 73042971 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, averagequality DESC LIMIT 50;

Date: 2022-03-26 09:38:35
Duration: 0ms
Database: acaweb_fx
User: postgres

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

Date: 2022-03-26 09:30:46
Duration: 18s27ms
Database: acaweb_fx
User: postgres

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: 2022-03-26 09:04:32
Duration: 4s693ms
Database: acaweb_fx
User: postgres

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

Date: 2022-03-26 09:50:55
Duration: 3s193ms
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)) AND ($15 = 0 OR fr.pattern in ($16)) AND ($17 = 0 OR fr.patternlengthbars <= $18) AND ($19 = 0 OR ($20 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($21 = 2 AND fr.timed < cast('1970-01-01' as timestamp))) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $22 OR relevant = 1) AND ($23 = 0 OR age <= $24) ORDER BY identified DESC, length DESC;

Date: 2022-03-26 09:52:47
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 > 577252795 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2022-03-26 09:32:08
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

) OR ((symbol ilike '%eurusd%' AND timegranularity = 240)) OR ((symbol ilike '%usdjpy%' AND timegranularity = 240)) OR ((symbol ilike '%gbpusd%' AND timegranularity = 240)) OR ((symbol ilike '%audusd%' AND timegranularity = 240)) OR ((symbol ilike '%usdcad%' AND timegranularity = 240)) OR ((symbol ilike '%usdchf%' AND timegranularity = 240)) OR ((symbol ilike '%nzdusd%' AND timegranularity = 240)) OR ((symbol ilike '%eurgbp%' AND timegranularity = 240)) OR ((symbol ilike '%eurjpy%' AND timegranularity = 240)) OR ((symbol ilike '%gbpjpy%' AND timegranularity = 240)) OR ((symbol ilike '%eurcad%' AND timegranularity = 240)) OR ((symbol ilike '%audjpy%' AND timegranularity = 240)) OR ((symbol ilike '%euraud%' AND timegranularity = 240)) OR ((symbol ilike '%eurchf%' AND timegranularity = 240)) OR ((symbol ilike '%audnzd%' AND timegranularity = 240)) OR ((symbol ilike '%nzdjpy%' AND timegranularity = 240)) OR ((symbol ilike '%gbpaud%' AND timegranularity = 240)) OR ((symbol ilike '%audcad%' AND timegranularity = 240)) OR ((symbol ilike '%cadjpy%' AND timegranularity = 240)) OR ((symbol ilike '%chfjpy%' AND timegranularity = 240)) OR ((symbol ilike '%audchf%' AND timegranularity = 240)) OR ((symbol ilike '%cadchf%' AND timegranularity = 240)) OR ((symbol ilike '%gbpchf%' AND timegranularity = 240)) OR ((symbol ilike '%gbpnzd%' AND timegranularity = 240))) 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-26 09:42:58
Duration: 0ms
Database: acaweb_fx
User: postgres

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

Date: 2022-03-26 09:55:53
Duration: 59s840ms
Database: acaweb_fx
User: postgres

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: 2022-03-26 09:01:18
Duration: 55s323ms
Database: acaweb_fx
User: postgres

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

Date: 2022-03-26 09:30:26
Duration: 7s938ms
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-26 09:52:02
Duration: 0ms
Database: acaweb_fx
User: postgres

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: 2022-03-26 09:32:10
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide