WITH rar_max as ( ;

Date: 2023-12-11 11:00:32
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 182.165.1.42
Application: [unknown]

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-12-11 11:30:07
Duration: 4s956ms
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-12-11 11:00:06
Duration: 4s372ms
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-12-11 11:10:06
Duration: 3s639ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.25
Application: [unknown]

x Hide

select updateageforrelevantresults ();

Date: 2023-12-11 11:47:13
Duration: 10s960ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateageforrelevantresults ();

Date: 2023-12-11 11:02:13
Duration: 10s743ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateageforrelevantresults ();

Date: 2023-12-11 11:32:13
Duration: 10s663ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

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

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

Date: 2023-12-11 11:28:20
Duration: 115ms
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 = 758 and symbol in ('USDJPY', 'USDCAD', 'EURNZD', 'USDCHF', 'EURCAD', 'EURJPY', 'GBPUSD', 'EURAUD', 'EURUSD', 'EURCHF', 'NZDUSD', 'AUDUSD') and timegranularity = 60 and pricedatetime >= current_timestamp - interval '80 days' order by pricedatetime asc;

Date: 2023-12-11 11:28:32
Duration: 105ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

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

Date: 2023-12-11 11:29:05
Duration: 274ms
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 = 758 and symbol in ('USDJPY', 'USDCAD', 'EURNZD', 'USDCHF', 'EURCAD', 'EURJPY', 'GBPUSD', 'EURAUD', 'EURUSD', 'EURCHF', 'NZDUSD', 'AUDUSD') and timegranularity = 30 and pricedatetime >= current_timestamp - interval '40 days' order by pricedatetime asc;

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

Date: 2023-12-11 11:28:20
Duration: 118ms
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 = 689 and symbol in ('USDJPY', 'USDCAD', 'USDCHF', 'EURCAD', 'EURCHF', 'EURJPY', 'NZDUSD', 'GBPUSD', 'EURUSD', 'EURAUD', 'AUDUSD', 'EURNZD') and timegranularity = 240 and pricedatetime >= current_timestamp - interval '320 days' order by pricedatetime asc;

Date: 2023-12-11 11:28:20
Duration: 289ms
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 = 640 and symbol in ('CHFJPY', 'DJ5R', 'USDCHF', 'GBPNZD', 'AUDJPY', 'GBPJPY', 'USDCAD', 'NZDJPY', 'EURCAD', 'XAGUSD', 'EURNZD', 'CADJPY', 'CLR', 'NZDUSD', 'EURCHF', 'EURJPY', 'GOOG.US', 'EURAUD', 'AUDCHF', 'JPN225', 'JP5R', 'NZDCAD', 'GBPUSD', 'AUDNZD', 'HK5R', 'GBPCHF', 'EURUSD', 'XAUUSD', 'AUDCAD', 'AUDUSD', 'GBPAUD', 'NZDCHF', 'SP50R', 'EURGBP', 'F.US', 'USDJPY', 'GBPCAD', 'JPM.US', 'GS.US', 'KO.US', 'AMZN.US', 'NQ20R', 'BA.US', 'MSFT.US', 'MCD.US', 'XOM.US', 'META.US', 'BABA.US') and timegranularity = 240 and pricedatetime >= current_timestamp - interval '320 days' order by pricedatetime asc;

Date: 2023-12-11 11:29:05
Duration: 233ms
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 = 758 and symbol in ('USDJPY', 'USDCAD', 'EURNZD', 'USDCHF', 'EURCAD', 'EURJPY', 'GBPUSD', 'EURAUD', 'EURUSD', 'EURCHF', 'NZDUSD', 'AUDUSD') and timegranularity = 240 and pricedatetime >= current_timestamp - interval '320 days' order by pricedatetime asc;

Date: 2023-12-11 11:28:32
Duration: 219ms
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 = 640 and symbol in ('CHFJPY', 'DJ5R', 'USDCHF', 'GBPNZD', 'AUDJPY', 'GBPJPY', 'USDCAD', 'NZDJPY', 'EURCAD', 'XAGUSD', 'EURNZD', 'CADJPY', 'CLR', 'NZDUSD', 'EURCHF', 'EURJPY', 'GOOG.US', 'EURAUD', 'AUDCHF', 'JPN225', 'JP5R', 'NZDCAD', 'GBPUSD', 'AUDNZD', 'HK5R', 'GBPCHF', 'EURUSD', 'XAUUSD', 'AUDCAD', 'AUDUSD', 'GBPAUD', 'NZDCHF', 'SP50R', 'EURGBP', 'F.US', 'USDJPY', 'GBPCAD', 'JPM.US', 'GS.US', 'KO.US', 'AMZN.US', 'NQ20R', 'BA.US', 'MSFT.US', 'MCD.US', 'XOM.US', 'META.US', 'BABA.US') and timegranularity = 15 and pricedatetime >= current_timestamp - interval '20 days' order by pricedatetime asc;

Date: 2023-12-11 11:29:04
Duration: 127ms
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 = 689 and symbol in ('USDJPY', 'USDCAD', 'USDCHF', 'EURCAD', 'EURCHF', 'EURJPY', 'NZDUSD', 'GBPUSD', 'EURUSD', 'EURAUD', 'AUDUSD', 'EURNZD') and timegranularity = 15 and pricedatetime >= current_timestamp - interval '20 days' order by pricedatetime asc;

Date: 2023-12-11 11:28:20
Duration: 85ms
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', 'USDCAD', 'EURNZD', 'USDCHF', 'EURCAD', 'EURJPY', 'GBPUSD', 'EURAUD', 'EURUSD', 'EURCHF', 'NZDUSD', 'AUDUSD') and timegranularity = 15 and pricedatetime >= current_timestamp - interval '20 days' order by pricedatetime asc;

Date: 2023-12-11 11:28:32
Duration: 67ms
Database: acaweb_fx
User: postgres
Remote: 192.168.4.176
Application: [unknown]

x Hide