WITH rar_max as ( ;

Date: 2023-07-24 07:35:47
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.20
Application: PostgreSQL JDBC Driver

x Hide

/*server.CPResultList*/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 558 AND (((s.symbol ilike '%eurusd%' AND timegranularity = 60);

Date: 2023-07-24 07:35:54
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.201
Application: PostgreSQL JDBC Driver

x Hide

with rankedmt4 as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select * from rankedmt4 where r = 1 ), ok_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select *, row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 * 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1;

Date: 2023-07-24 07:20:04
Duration: 1s827ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.25
Application: [unknown]

with rankedmt4 as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select * from rankedmt4 where r = 1 ), ok_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select *, row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 * 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1;

Date: 2023-07-24 07:40:04
Duration: 1s763ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.25
Application: [unknown]

with rankedmt4 as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select * from rankedmt4 where r = 1 ), ok_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select *, row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 * 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1;

Date: 2023-07-24 07:00:04
Duration: 1s746ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.25
Application: [unknown]

x Hide

/*server.CPResultList*/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 558 AND (((s.symbol ilike '%gbpchf%' AND timegranularity <= 1440);

Date: 2023-07-24 07:38:56
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.201
Application: PostgreSQL JDBC Driver

x Hide

select updateageforrelevantresults ();

Date: 2023-07-24 07:02:16
Duration: 13s853ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateageforrelevantresults ();

Date: 2023-07-24 07:17:16
Duration: 13s709ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateageforrelevantresults ();

Date: 2023-07-24 07:32:15
Duration: 13s376ms
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-07-24 07:35:47
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.145
Application: PostgreSQL JDBC Driver

x Hide

SELECT resultuid FROM relevance_consecutivecandles_results ORDER BY resultuid DESC LIMIT 1), all_results AS ( SELECT ccr.resultuid AS resultuid, ccr.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, ccr.patternendtime AS identified, dtt.timezone AS timezone, ccr.qtyconsecutivecandles AS length, g.basegroupname, CASE WHEN rcr.age IS NOT NULL THEN rcr.age WHEN ccr.resultuid <= rm.resultuid THEN 1 ELSE 0 END as age, CASE WHEN rcr.relevant IS NOT NULL THEN rcr.relevant WHEN ccr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip, newLevels.filtered FROM consecutivecandles_results ccr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = ccr.symbolid INNER JOIN symbols s ON ccr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN downloadersymbolsettings dss ON ccr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on ccr.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 rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_consecutivecandles_results rcr ON rcr.resultuid = ccr.resultuid 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' LEFT JOIN LATERAL calc_cc_signal_filter (ccr.resultuid) newLevels on true WHERE ccr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (ccr.simulation = 0 OR ccr.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 coalesce(bim.code, s.symbol) in ($13, $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)) AND ($242 = 0 OR ccr.patternlengthbars <= $243)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $244 OR relevant = 1) AND ($245 = 0 OR age <= $246) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;

Date: 2023-07-24 07:57:52
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.250
Application: PostgreSQL JDBC Driver

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 = 622 and symbol in ('BTCUSD', 'GBPHUF', 'USDSGD', 'ETHUSD', 'AUDNZD', 'USDZAR', 'USDTRY', 'EURCNH', 'EURCAD', 'EURNOK', 'JPN225', 'WTISPOT', 'EURSEK', 'CHFJPY', 'USDHUF', 'EURGBP', 'AUDJPY', 'AUDCHF', 'NZDJPY', 'AUDUSD', 'XAGUSD', 'USDHKD', 'USDMXN', 'EURCZK', 'EURAUD', 'AUDSGD', 'NZDCHF', 'USDCHF', 'GBPAUD', 'EURJPY', 'ESP35', 'CADCHF', 'XAUUSD', 'AEX25', 'GBPSEK', 'GBPUSD', 'NZDUSD', 'USDDKK', 'HK-Shares', 'USDPLN', 'GBPEUR', 'LTCUSD', 'GBPJPY', 'USDCZK', 'CADJPY', 'EURHUF', 'AUDCAD', 'EURPLN', 'USDSEK', 'USDCNH', 'USDJPY', 'GBPNZD', 'USDCAD', 'GBPCAD', 'BRENTSPOT', 'EURUSD', 'EURNZD', 'USDNOK', 'EURDKK', 'NZDCAD', 'EURTRY', 'GBPCHF') and timegranularity = 30 and pricedatetime >= current_timestamp - interval '40 days' order by pricedatetime asc;

Date: 2023-07-24 07:06:36
Duration: 328ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

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 = 640 and symbol in ('SP50R', 'AUDNZD', 'DJ5R', 'EURJPY', 'EURCAD', 'T.US', 'NQ20R', 'EURAUD', 'JP5R', 'CLR', 'CHFJPY', 'XAGUSD', 'EURGBP', 'AUDJPY', 'JPN225', 'NZDJPY', 'AUDUSD', 'F.US', 'NZDCHF', 'USDCHF', 'GBPAUD', 'HK5R', 'GBPUSD', 'XAUUSD', 'NZDUSD', 'UPS.US', 'GBPNZD', 'CADJPY', 'BABA.US', 'GBPJPY', 'AUDCAD', 'NKE.US', 'USDJPY', 'AMZN.US', 'USDCAD', 'GBPCAD', 'META.US', 'EURUSD', 'KO.US', 'EURNZD', 'GS.US', 'NFLX.US', 'AUDCHF', 'NZDCAD', 'MSFT.US', 'GOOG.US', 'JPM.US', 'MCD.US', 'GBPCHF') and timegranularity = 30 and pricedatetime >= current_timestamp - interval '40 days' order by pricedatetime asc;

Date: 2023-07-24 07:06:40
Duration: 272ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

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

Date: 2023-07-24 07:05:18
Duration: 114ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

x Hide

select pricedatetime, open, high, low, close, timegranularity, symbol from t240 p inner join symbols s on p.symbolid = s.symbolid inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where brokerid = 619 and symbol in ('EURCAD', 'AUDUSD', 'EURUSD', 'EURAUD', 'USDCHF', 'EURJPY', 'GBPUSD', 'NZDUSD', 'EURCHF', 'USDCAD', 'EURNZD', 'USDJPY') and timegranularity = 240 and pricedatetime >= current_timestamp - interval '320 days' order by pricedatetime asc;

Date: 2023-07-24 07:05:12
Duration: 1s22ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

select pricedatetime, open, high, low, close, timegranularity, symbol from t240 p inner join symbols s on p.symbolid = s.symbolid inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where brokerid = 479 and symbol in ('EURCAD', 'EURAUD', 'AUDUSD', 'USDCHF', 'EURJPY', 'EURCHF', 'EURUSD', 'GBPUSD', 'NZDUSD', 'USDCAD', 'EURNZD', 'USDJPY') and timegranularity = 240 and pricedatetime >= current_timestamp - interval '320 days' order by pricedatetime asc;

Date: 2023-07-24 07:05:04
Duration: 911ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

select pricedatetime, open, high, low, close, timegranularity, symbol from t240 p inner join symbols s on p.symbolid = s.symbolid inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where brokerid = 431 and symbol in ('AUDUSD', 'USDCHF', 'EURUSD', 'GBPUSD', 'NZDUSD', 'USDJPY', 'USDCAD') and timegranularity = 240 and pricedatetime >= current_timestamp - interval '320 days' order by pricedatetime asc;

Date: 2023-07-24 07:05:03
Duration: 595ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

x Hide

select pricedatetime, open, high, low, close, timegranularity, symbol from t15 p inner join symbols s on p.symbolid = s.symbolid inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where brokerid = 622 and symbol in ('BTCUSD', 'GBPHUF', 'USDSGD', 'ETHUSD', 'AUDNZD', 'USDZAR', 'USDTRY', 'EURCNH', 'EURCAD', 'EURNOK', 'JPN225', 'WTISPOT', 'EURSEK', 'CHFJPY', 'USDHUF', 'EURGBP', 'AUDJPY', 'AUDCHF', 'NZDJPY', 'AUDUSD', 'XAGUSD', 'USDHKD', 'USDMXN', 'EURCZK', 'EURAUD', 'AUDSGD', 'NZDCHF', 'USDCHF', 'GBPAUD', 'EURJPY', 'ESP35', 'CADCHF', 'XAUUSD', 'AEX25', 'GBPSEK', 'GBPUSD', 'NZDUSD', 'USDDKK', 'HK-Shares', 'USDPLN', 'GBPEUR', 'LTCUSD', 'GBPJPY', 'USDCZK', 'CADJPY', 'EURHUF', 'AUDCAD', 'EURPLN', 'USDSEK', 'USDCNH', 'USDJPY', 'GBPNZD', 'USDCAD', 'GBPCAD', 'BRENTSPOT', 'EURUSD', 'EURNZD', 'USDNOK', 'EURDKK', 'NZDCAD', 'EURTRY', 'GBPCHF') and timegranularity = 15 and pricedatetime >= current_timestamp - interval '20 days' order by pricedatetime asc;

Date: 2023-07-24 07:06:35
Duration: 201ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

select pricedatetime, open, high, low, close, timegranularity, symbol from t15 p inner join symbols s on p.symbolid = s.symbolid inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where brokerid = 640 and symbol in ('SP50R', 'AUDNZD', 'DJ5R', 'EURJPY', 'EURCAD', 'T.US', 'NQ20R', 'EURAUD', 'JP5R', 'CLR', 'CHFJPY', 'XAGUSD', 'EURGBP', 'AUDJPY', 'JPN225', 'NZDJPY', 'AUDUSD', 'F.US', 'NZDCHF', 'USDCHF', 'GBPAUD', 'HK5R', 'GBPUSD', 'XAUUSD', 'NZDUSD', 'UPS.US', 'GBPNZD', 'CADJPY', 'BABA.US', 'GBPJPY', 'AUDCAD', 'NKE.US', 'USDJPY', 'AMZN.US', 'USDCAD', 'GBPCAD', 'META.US', 'EURUSD', 'KO.US', 'EURNZD', 'GS.US', 'NFLX.US', 'AUDCHF', 'NZDCAD', 'MSFT.US', 'GOOG.US', 'JPM.US', 'MCD.US', 'GBPCHF') and timegranularity = 15 and pricedatetime >= current_timestamp - interval '20 days' order by pricedatetime asc;

Date: 2023-07-24 07:06:40
Duration: 188ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

select pricedatetime, open, high, low, close, timegranularity, symbol from t15 p inner join symbols s on p.symbolid = s.symbolid inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where brokerid = 758 and symbol in ('USDJPY', 'AUDUSD', 'USDCHF', 'EURCAD', 'GBPUSD', 'EURUSD', 'NZDUSD', 'EURAUD', 'USDCAD', 'EURJPY', 'EURNZD', 'EURCHF') and timegranularity = 15 and pricedatetime >= current_timestamp - interval '20 days' order by pricedatetime asc;

Date: 2023-07-24 07:05:32
Duration: 121ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

x Hide

/*server.CPResultList*/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN symbolgroup sg ON s.symbolid = sg.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 529 AND sg.groupid = 515852059718346308 AND breakout = - 1 AND patternlengthbars >= 20 AND patternquality >= 0.3 AND initialtrend >= 0.0 AND symmetry >= 0.0 AND noise <= 1.0 AND volumeincrease >= 0.0 AND TemporaryPattern = 0 AND PatternID & 65535 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND a.resultuid > 0 AND s.nonliquid = 0 AND dftt.dayofweek = 3 AND ((rar.age IS NULL AND a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1)) OR rar.age >= 1) ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2023-07-24 07:58:59
Duration: 248ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.23
Application: PostgreSQL JDBC Driver

/*server.CPResultList*/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN symbolgroup sg ON s.symbolid = sg.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 529 AND sg.groupid = 515852059758978308 AND breakout = - 1 AND patternlengthbars >= 20 AND patternquality >= 0.3 AND initialtrend >= 0.0 AND symmetry >= 0.0 AND noise <= 1.0 AND volumeincrease >= 0.0 AND TemporaryPattern = 0 AND PatternID & 65535 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND a.resultuid > 0 AND s.nonliquid = 0 AND dftt.dayofweek = 3 AND ((rar.age IS NULL AND a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1)) OR rar.age >= 1) ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2023-07-24 07:07:19
Duration: 147ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.23
Application: PostgreSQL JDBC Driver

/*server.CPResultList*/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN symbolgroup sg ON s.symbolid = sg.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 529 AND sg.groupid = 515852059709228308 AND breakout = - 1 AND patternlengthbars >= 20 AND patternquality >= 0.3 AND initialtrend >= 0.0 AND symmetry >= 0.0 AND noise <= 1.0 AND volumeincrease >= 0.0 AND TemporaryPattern = 0 AND PatternID & 65535 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND a.resultuid > 0 AND s.nonliquid = 0 AND dftt.dayofweek = 3 AND ((rar.age IS NULL AND a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1)) OR rar.age >= 1) ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2023-07-24 07:58:59
Duration: 134ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.23
Application: PostgreSQL JDBC Driver

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

Date: 2023-07-24 07:05:03
Duration: 401ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

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 = 622 and symbol in ('BTCUSD', 'GBPHUF', 'USDSGD', 'ETHUSD', 'AUDNZD', 'USDZAR', 'USDTRY', 'EURCNH', 'EURCAD', 'EURNOK', 'JPN225', 'WTISPOT', 'EURSEK', 'CHFJPY', 'USDHUF', 'EURGBP', 'AUDJPY', 'AUDCHF', 'NZDJPY', 'AUDUSD', 'XAGUSD', 'USDHKD', 'USDMXN', 'EURCZK', 'EURAUD', 'AUDSGD', 'NZDCHF', 'USDCHF', 'GBPAUD', 'EURJPY', 'ESP35', 'CADCHF', 'XAUUSD', 'AEX25', 'GBPSEK', 'GBPUSD', 'NZDUSD', 'USDDKK', 'HK-Shares', 'USDPLN', 'GBPEUR', 'LTCUSD', 'GBPJPY', 'USDCZK', 'CADJPY', 'EURHUF', 'AUDCAD', 'EURPLN', 'USDSEK', 'USDCNH', 'USDJPY', 'GBPNZD', 'USDCAD', 'GBPCAD', 'BRENTSPOT', 'EURUSD', 'EURNZD', 'USDNOK', 'EURDKK', 'NZDCAD', 'EURTRY', 'GBPCHF') and timegranularity = 60 and pricedatetime >= current_timestamp - interval '80 days' order by pricedatetime asc;

Date: 2023-07-24 07:06:36
Duration: 348ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

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

Date: 2023-07-24 07:05:12
Duration: 329ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

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, 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, $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)) AND ($326 = 0 OR fr.pattern in ($327)) AND ($328 = 0 OR fr.patternlengthbars <= $329) AND ($330 = 0 OR ($331 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($332 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $333 OR relevant = 1) AND ($334 = 0 OR age <= $335) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;

Date: 2023-07-24 07:16:03
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 182.165.1.42
Application: [unknown]