WITH rar_max as ( ;

Date: 2023-09-17 23:47:49
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.250
Application: PostgreSQL JDBC Driver

x Hide

select updateageforrelevantresults ();

Date: 2023-09-17 23:02:14
Duration: 12s235ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateageforrelevantresults ();

Date: 2023-09-17 23:47:14
Duration: 11s863ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateageforrelevantresults ();

Date: 2023-09-17 23:32:14
Duration: 11s496ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

x Hide

WITH pet as ( select enddate, t.symbolid, row_number() over (partition by t.symbolid order by enddate desc) r from powerstats_trumpet t inner join brokersymbollist bsl on t.symbolid = bsl.symbolid and bsl.brokerid = 754 ) select _xml FROM ( select * from ( select distinct replace(symbol, ' ', '~') || '%<' || dayofweek || '_' || fromtime || '><15>' || round(ave_15, 5) || '</15><30>' || round(ave_30, 5) || '</30><60>' || round(ave_60, 5) || '</60><240>' || round(ave_240, 5) || '</240><1440>' || round(ave_1440, 5) || '</1440></' || dayofweek || '_' || fromtime || '>' as _xml, replace(symbol, ' ', '~') as symbol, dayofweek, fromtime, round(ave_15, 5) as ave_15, round(ave_30, 5) as ave_30, round(ave_60, 5) as ave_60, round(ave_240, 5) as ave_240, round(ave_1440, 5) as ave_1440 from symbols s inner join brokersymbollist bsl on s.symbolid = bsl.symbolid inner join pet on pet.r = 1 and bsl.symbolid = pet.symbolid and bsl.brokerid = 754 inner join powerstats_trumpet pt on bsl.symbolid = pt.symbolid and pet.enddate = pt.enddate where case when 754 != 285 then 1 = 1 else 1 = 0 end and case when 77 > 500 and 754 != 412 then s.exchange ilike 'FOREX' ELSE 1 = 1 END) b order by symbol, dayofweek, fromtime) a;

Date: 2023-09-17 23:05:24
Duration: 235ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

WITH pet as ( select enddate, t.symbolid, row_number() over (partition by t.symbolid order by enddate desc) r from powerstats_trumpet t inner join brokersymbollist bsl on t.symbolid = bsl.symbolid and bsl.brokerid = 817 ) select _xml FROM ( select * from ( select distinct replace(symbol, ' ', '~') || '%<' || dayofweek || '_' || fromtime || '><15>' || round(ave_15, 5) || '</15><30>' || round(ave_30, 5) || '</30><60>' || round(ave_60, 5) || '</60><240>' || round(ave_240, 5) || '</240><1440>' || round(ave_1440, 5) || '</1440></' || dayofweek || '_' || fromtime || '>' as _xml, replace(symbol, ' ', '~') as symbol, dayofweek, fromtime, round(ave_15, 5) as ave_15, round(ave_30, 5) as ave_30, round(ave_60, 5) as ave_60, round(ave_240, 5) as ave_240, round(ave_1440, 5) as ave_1440 from symbols s inner join brokersymbollist bsl on s.symbolid = bsl.symbolid inner join pet on pet.r = 1 and bsl.symbolid = pet.symbolid and bsl.brokerid = 817 inner join powerstats_trumpet pt on bsl.symbolid = pt.symbolid and pet.enddate = pt.enddate where case when 817 != 285 then 1 = 1 else 1 = 0 end and case when 25 > 500 and 817 != 412 then s.exchange ilike 'FOREX' ELSE 1 = 1 END) b order by symbol, dayofweek, fromtime) a;

Date: 2023-09-17 23:09:45
Duration: 138ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

WITH pet as ( select enddate, t.symbolid, row_number() over (partition by t.symbolid order by enddate desc) r from powerstats_trumpet t inner join brokersymbollist bsl on t.symbolid = bsl.symbolid and bsl.brokerid = 75 ) select _xml FROM ( select * from ( select distinct replace(symbol, ' ', '~') || '%<' || dayofweek || '_' || fromtime || '><15>' || round(ave_15, 5) || '</15><30>' || round(ave_30, 5) || '</30><60>' || round(ave_60, 5) || '</60><240>' || round(ave_240, 5) || '</240><1440>' || round(ave_1440, 5) || '</1440></' || dayofweek || '_' || fromtime || '>' as _xml, replace(symbol, ' ', '~') as symbol, dayofweek, fromtime, round(ave_15, 5) as ave_15, round(ave_30, 5) as ave_30, round(ave_60, 5) as ave_60, round(ave_240, 5) as ave_240, round(ave_1440, 5) as ave_1440 from symbols s inner join brokersymbollist bsl on s.symbolid = bsl.symbolid inner join pet on pet.r = 1 and bsl.symbolid = pet.symbolid and bsl.brokerid = 75 inner join powerstats_trumpet pt on bsl.symbolid = pt.symbolid and pet.enddate = pt.enddate where case when 75 != 285 then 1 = 1 else 1 = 0 end and case when 59 > 500 and 75 != 412 then s.exchange ilike 'FOREX' ELSE 1 = 1 END) b order by symbol, dayofweek, fromtime) a;

Date: 2023-09-17 23:08:22
Duration: 101ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

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), all_results AS ( SELECT 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, newLevels.filtered, 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 LATERAL calc_fib_signal_filter (fr.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 fr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 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)) AND ($243 = 0 OR fr.pattern in ($244)) AND ($245 = 0 OR fr.patternlengthbars <= $246) AND ($247 = 0 OR ($248 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($249 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $250 OR relevant = 1) AND ($251 = 0 OR age <= $252) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;

Date: 2023-09-17 23:00:52
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.145
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 = 667 AND sg.groupid = 500996399199151208 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-09-17 23:00:17
Duration: 208ms
Database: acaweb_fx
User: postgres
Remote: 192.168.0.239
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 = 667 AND sg.groupid = 500996399201641208 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-09-17 23:00:17
Duration: 67ms
Database: acaweb_fx
User: postgres
Remote: 192.168.0.239
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 = 667 AND sg.groupid = 500996399199757208 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-09-17 23:00:17
Duration: 39ms
Database: acaweb_fx
User: postgres
Remote: 192.168.0.239
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 = 667 AND sg.groupid = 500996399199151208 AND breakout = - 1 AND patternlengthbars >= 20 AND patternquality >= 0.3 AND initialtrend >= 0.0 AND symmetry >= 0.0 AND noise <= 1.0 AND volumeincrease >= 0.0 AND TemporaryPattern = 0 AND PatternID & 65535 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND a.resultuid > 0 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2023-09-17 23:00:17
Duration: 490ms
Database: acaweb_fx
User: postgres
Remote: 192.168.0.239
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 = 667 AND sg.groupid = 500996399201641208 AND breakout = - 1 AND patternlengthbars >= 20 AND patternquality >= 0.3 AND initialtrend >= 0.0 AND symmetry >= 0.0 AND noise <= 1.0 AND volumeincrease >= 0.0 AND TemporaryPattern = 0 AND PatternID & 65535 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND a.resultuid > 0 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2023-09-17 23:00:17
Duration: 138ms
Database: acaweb_fx
User: postgres
Remote: 192.168.0.239
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 = 667 AND sg.groupid = 500996399200380208 AND breakout = - 1 AND patternlengthbars >= 20 AND patternquality >= 0.3 AND initialtrend >= 0.0 AND symmetry >= 0.0 AND noise <= 1.0 AND volumeincrease >= 0.0 AND TemporaryPattern = 0 AND PatternID & 65535 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND a.resultuid > 0 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2023-09-17 23:00:17
Duration: 74ms
Database: acaweb_fx
User: postgres
Remote: 192.168.0.239
Application: PostgreSQL JDBC Driver

x Hide