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, $5, $6, $7, $8, $9, $10)) AND ($11 = 0 OR s.exchange in ($12)) AND ($13 = 0 OR 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) 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: 2021-12-11 23:00:35
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, $5, $6, $7, $8, $9, $10)) AND ($11 = 0 OR s.exchange in ($12)) AND ($13 = 0 OR 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: 2021-12-11 23:00:36
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), 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 rar.age IS NOT NULL THEN rar.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM fibonacci_results fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 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 OUTER JOIN relevance_fibonacci_results rar ON rar.resultuid = fr.resultuid WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR s.symbol in ($7)) AND ($8 = 0 OR fr.pattern in ($9)) AND ($10 = 0 OR fr.patternlengthbars <= $11) AND ($12 = 0 OR ($13 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($14 = 2 AND fr.timed < cast('1970-01-01' as timestamp))) 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: 2021-12-11 23:01:14
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1), 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 rar.age IS NOT NULL THEN rar.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM keylevels_results kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON kr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on kr.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 kr.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 (kr.simulation = 0 OR kr.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR s.symbol in ($7)) AND ($8 = 0 OR p.patternname in ($9)) AND ($10 = 0 OR kr.patternclassid in ($11)) AND ($12 = 0 OR kr.patternlengthbars <= $13) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $14 OR relevant = 1) AND ($15 = 0 OR age <= $16) ORDER BY identified DESC, length DESC;

Date: 2021-12-11 23:01:29
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

SELECT resultuid FROM relevance_bigmovement_results ORDER BY resultuid DESC LIMIT 1), results AS ( SELECT DISTINCT ON (s.symbolid) bmr.resultuid AS resultuid, 0 AS direction, s.exchange AS exchange, s.symbolid AS symbolid, s.symbol AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, bmr.patternendtime AS identified, bmr.patternlengthbars, dtt.timezone AS timezone, g.basegroupname, CASE WHEN rbr.age IS NOT NULL THEN rbr.age WHEN bmr.resultuid <= rm.resultuid THEN 4 ELSE 0 END as age, CASE WHEN rbr.relevant IS NOT NULL THEN rbr.relevant WHEN bmr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM bigmovement_results bmr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = bmr.symbolid INNER JOIN symbols s ON bmr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN downloadersymbolsettings dss ON bmr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on bmr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_bigmovement_results rbr ON rbr.resultuid = bmr.resultuid WHERE bmr.gmttimefound > now() - INTERVAL '7 DAYS' AND (bmr.simulation = 0 OR bmr.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR s.symbol in ($7)) AND ($8 = 0 OR bmr.patternlengthbars <= $9) ORDER BY symbolid, identified DESC, interval DESC ) SELECT * from results WHERE (FALSE = $10 OR relevant = 1) AND ($11 = 0 OR age <= $12) ORDER BY identified DESC, interval DESC;

Date: 2021-12-11 23:06:21
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

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

Date: 2021-12-11 12:00:11
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

select stats_createSummaryTables_ChartPattens (cast(4769 as int));

Date: 2021-12-11 08:07:39
Duration: 7m43s
Database: acaweb_fx
User: postgres

select stats_createSummaryTables_ChartPattens (cast(4748 as int));

Date: 2021-12-11 07:32:54
Duration: 7m35s
Database: acaweb_fx
User: postgres

select stats_createSummaryTables_ChartPattens (cast(4571 as int));

Date: 2021-12-11 07:03:50
Duration: 5m9s
Database: acaweb_fx
User: postgres

x Hide

select stats_createSummaryTables_ChartPattens (cast(4441 as bigint));

Date: 2021-12-11 06:06:12
Duration: 4m43s
Database: acaweb_fx
User: postgres

select stats_createSummaryTables_ChartPattens (cast(4442 as bigint));

Date: 2021-12-11 06:06:12
Duration: 4m42s
Database: acaweb_fx
User: postgres

select stats_createSummaryTables_ChartPattens (cast(4459 as bigint));

Date: 2021-12-11 06:06:10
Duration: 4m26s
Database: acaweb_fx
User: postgres

x Hide

select stats_createSummaryTables_KeyLevels (cast(4788 as int));

Date: 2021-12-11 08:21:23
Duration: 1m53s
Database: acaweb_fx
User: postgres

select stats_createSummaryTables_KeyLevels (cast(4756 as int));

Date: 2021-12-11 07:45:34
Duration: 1m42s
Database: acaweb_fx
User: postgres

select stats_createSummaryTables_KeyLevels (cast(4807 as int));

Date: 2021-12-11 08:27:18
Duration: 1m28s
Database: acaweb_fx
User: postgres

x Hide

select stats_createSummaryTables_KeyLevels (cast(4442 as bigint));

Date: 2021-12-11 06:06:19
Duration: 4m49s
Database: acaweb_fx
User: postgres

select stats_createSummaryTables_KeyLevels (cast(4459 as bigint));

Date: 2021-12-11 06:06:21
Duration: 4m37s
Database: acaweb_fx
User: postgres

select stats_createSummaryTables_KeyLevels (cast(4441 as bigint));

Date: 2021-12-11 06:05:52
Duration: 4m23s
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 > 523836781 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2021-12-11 23:05:32
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1), results AS ( SELECT DISTINCT ON (s.symbolid) ar.resultuid AS resultuid, ar.direction AS direction, ar.predictiontimeto AS predictiontimeto, ar.predictionpricefrom AS predictionpricefrom, ar.predictionpriceto AS predictionpriceto, cp.pip AS pip, s.exchange AS exchange, s.symbolid AS symbolid, s.symbol AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, ar.pattern AS pattern_name, ar.breakout AS breakout, ar.patternendtime AS identified, dtt.timezone AS timezone, ar.patternlengthbars AS length, g.basegroupname, newLevels.profit, newLevels.stop, newLevels.filtered, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN ar.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN ar.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM autochartist_results ar INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = ar.symbolid INNER JOIN symbols s ON ar.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on ar.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 ar.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_autochartist_results rar ON rar.resultuid = ar.resultuid LEFT OUTER JOIN currencypips cp ON s.symbol = cp.symbol LEFT JOIN LATERAL calc_cp_signal (ar.resultuid) newLevels on true WHERE ar.gmttimefound > now() - INTERVAL '7 DAYS' AND (ar.simulation = 0 OR ar.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3, $4, $5, $6, $7, $8, $9)) AND ($10 = 0 OR s.exchange in ($11)) AND ($12 = 0 OR s.symbol in ($13)) AND ($14 = 0 OR ar.pattern in ($15)) AND ($16 = 0 OR ($17 = 1 AND ar.breakout >= 0) OR ($18 = 2 AND ar.breakout < 0)) AND ($19 = 0 OR ar.patternlengthbars <= $20) and newLevels.filtered = false ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $21 OR relevant = 1) AND ($22 = 0 OR age <= $23) ORDER BY identified DESC, length DESC;

Date: 2021-12-11 23:16:14
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

select stats_createSummaryTables_by_groups_ChartPattens (cast(259 as int));

Date: 2021-12-11 09:39:44
Duration: 4m49s
Database: acaweb_fx
User: postgres

select stats_createSummaryTables_by_groups_ChartPattens (cast(258 as int));

Date: 2021-12-11 09:34:21
Duration: 4m36s
Database: acaweb_fx
User: postgres

select stats_createSummaryTables_by_groups_ChartPattens (cast(201 as int));

Date: 2021-12-11 08:57:56
Duration: 4m11s
Database: acaweb_fx
User: postgres

x Hide

select stats_createSummaryTables_by_groups_KeyLevels (cast(277 as int));

Date: 2021-12-11 09:48:10
Duration: 3m34s
Database: acaweb_fx
User: postgres

select stats_createSummaryTables_by_groups_KeyLevels (cast(355 as int));

Date: 2021-12-11 10:13:58
Duration: 1m33s
Database: acaweb_fx
User: postgres

select stats_createSummaryTables_by_groups_KeyLevels (cast(430 as int));

Date: 2021-12-11 10:24:53
Duration: 1m21s
Database: acaweb_fx
User: postgres

x Hide

select fixcandlegaps ('XM', false);

Date: 2021-12-11 07:08:52
Duration: 54s29ms
Database: acaweb_fx
User: postgres

select fixcandlegaps ('XM', false);

Date: 2021-12-11 10:07:10
Duration: 32s160ms
Database: acaweb_fx
User: postgres

select fixcandlegaps ('XM', false);

Date: 2021-12-11 06:07:32
Duration: 28s80ms
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: 2021-12-11 09:15:31
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 > 62173653 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, averagequality DESC LIMIT 50;

Date: 2021-12-11 09:07:29
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

) OR ((s.symbol ilike '%usdjpy%' AND timegranularity = 1440)) OR ((s.symbol ilike '%audjpy%' AND timegranularity = 240)) OR ((s.symbol ilike '%audjpy%' AND timegranularity = 1440)) OR ((s.symbol ilike '%cadjpy%' AND timegranularity = 240)) OR ((s.symbol ilike '%cadjpy%' AND timegranularity = 1440)) OR ((s.symbol ilike '%chfjpy%' AND timegranularity = 240)) OR ((s.symbol ilike '%chfjpy%' AND timegranularity = 1440)) OR ((s.symbol ilike '%eurjpy%' AND timegranularity = 240)) OR ((s.symbol ilike '%eurjpy%' AND timegranularity = 1440)) OR ((s.symbol ilike '%gbpjpy%' AND timegranularity = 240)) OR ((s.symbol ilike '%gbpjpy%' AND timegranularity = 1440)) OR ((s.symbol ilike '%nzdjpy%' AND timegranularity = 240)) OR ((s.symbol ilike '%nzdjpy%' 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 > 523829211 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2021-12-11 12:01:02
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

) OR ((c.symbol ilike '%xauusd%' AND timegranularity = 30)) OR ((c.symbol ilike '%xauusd%' AND timegranularity = 60)) OR ((c.symbol ilike '%xauusd%' AND timegranularity = 240)) OR ((c.symbol ilike '%xauusd%' AND timegranularity = 1440)) OR ((c.symbol ilike '%xagusd%' AND timegranularity = 15)) OR ((c.symbol ilike '%xagusd%' AND timegranularity = 30)) OR ((c.symbol ilike '%xagusd%' AND timegranularity = 60)) OR ((c.symbol ilike '%xagusd%' AND timegranularity = 60)) OR ((c.symbol ilike '%xagusd%' AND timegranularity = 240)) OR ((c.symbol ilike '%xagusd%' AND timegranularity = 1440))) 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: 2021-12-11 09:31:36
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

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

Date: 2021-12-11 08:01:26
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide