WITH rar_max as ( ;

Date: 2024-04-02 08:01:00
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: 2024-04-02 08:30:07
Duration: 5s466ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.90
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: 2024-04-02 08:00:07
Duration: 5s78ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.90
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: 2024-04-02 08:20:06
Duration: 4s214ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.90
Application: [unknown]

x Hide

select updateageforrelevantresults ();

Date: 2024-04-02 08:32:15
Duration: 12s391ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateageforrelevantresults ();

Date: 2024-04-02 08:17:14
Duration: 12s178ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateageforrelevantresults ();

Date: 2024-04-02 08:02:13
Duration: 11s606ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

x Hide

INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ('2024-04-02 09:00:00', '1.25412', '1.2545', '1.25389', '1.25434', '1733', '500991628230657200', '0', '2024-04-02 08:20:15.76', '2024-04-02 08:20:15.548') ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = '1.25412', high = '1.2545', low = '1.25389', close = '1.25434', volume = '1733', bsf = '0', sastdatetimewritten = '2024-04-02 08:20:15.76', sastdatetimereceived = '2024-04-02 08:20:15.548';

Date: 2024-04-02 08:22:47
Database: acaweb_fx
User: postgres
Remote: 192.168.4.142
Application: [unknown]
Bind query: yes

INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ('2024-04-02 08:00:00', '98.426', '98.502', '98.404', '98.493', '1822', '515840218726811300', '0', '2024-04-02 08:20:16.702', '2024-04-02 08:20:16.445') ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = '98.426', high = '98.502', low = '98.404', close = '98.493', volume = '1822', bsf = '0', sastdatetimewritten = '2024-04-02 08:20:16.702', sastdatetimereceived = '2024-04-02 08:20:16.445';

Date: 2024-04-02 08:22:47
Database: acaweb_fx
User: postgres
Remote: 192.168.4.142
Application: [unknown]
Bind query: yes

INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ('2024-04-02 09:00:00', '0.88111', '0.881535', '0.88104', '0.88147', '1425', '515840230419121300', '0', '2024-04-02 08:20:17.039', '2024-04-02 08:20:16.872') ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = '0.88111', high = '0.881535', low = '0.88104', close = '0.88147', volume = '1425', bsf = '0', sastdatetimewritten = '2024-04-02 08:20:17.039', sastdatetimereceived = '2024-04-02 08:20:16.872';

Date: 2024-04-02 08:22:47
Database: acaweb_fx
User: postgres
Remote: 192.168.4.142
Application: [unknown]
Bind query: yes

x Hide