WITH rar_max as ( ;

Date: 2024-01-29 12:00:26
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.250
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: 2024-01-29 12:00:10
Duration: 7s758ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.160
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-01-29 12:30:10
Duration: 7s689ms
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-01-29 12:30:10
Duration: 7s491ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.160
Application: [unknown]

x Hide

select updateageforrelevantresults ();

Date: 2024-01-29 12:47:16
Duration: 14s572ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateageforrelevantresults ();

Date: 2024-01-29 12:17:13
Duration: 11s718ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

select updateageforrelevantresults ();

Date: 2024-01-29 12:02:12
Duration: 10s99ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

x Hide

select distinct current_database() as database, s.symbolid, s.symbol, dss.downloadersymbol, s.shortname, s.longname, s.exchange, dss.classname, dss.enabled, s.nonliquid, s.timegranularity, count(s.symbolid) filter (where s.symbol ILIKE '%V%') as symbol_match, count(s.symbolid) filter (where dss.downloadersymbol ILIKE '%V%') as downloadersymbol_match, count(s.symbolid) filter (where s.longname ilike '%V%') as longname_match, count(s.symbolid) filter (where dss.classname ilike '%V%') as classname_match, count(s.symbolid) filter (where s.exchange ilike '%V%') as exchange_match from symbols s join downloadersymbolsettings dss on s.symbolid = dss.symbolid where (s.symbol ILIKE '%V%' or downloadersymbol ilike '%V%' or s.shortname ilike '%V%' or s.longname ilike '%V%' or dss.classname ilike '%V%' or s.exchange ilike '%V%') GROUP BY s.symbolid, s.symbol, current_database(), dss.downloadersymbol, s.shortname, s.longname, s.exchange, dss.classname, dss.enabled, s.nonliquid, s.timegranularity ORDER BY symbol_match DESC, downloadersymbol_match DESC, longname_match DESC;

Date: 2024-01-29 12:03:49
Duration: 501ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.231
Application: PostgreSQL JDBC Driver

select distinct current_database() as database, s.symbolid, s.symbol, dss.downloadersymbol, s.shortname, s.longname, s.exchange, dss.classname, dss.enabled, s.nonliquid, s.timegranularity, count(s.symbolid) filter (where s.symbol ILIKE '%lTCUSD%') as symbol_match, count(s.symbolid) filter (where dss.downloadersymbol ILIKE '%lTCUSD%') as downloadersymbol_match, count(s.symbolid) filter (where s.longname ilike '%lTCUSD%') as longname_match, count(s.symbolid) filter (where dss.classname ilike '%lTCUSD%') as classname_match, count(s.symbolid) filter (where s.exchange ilike '%lTCUSD%') as exchange_match from symbols s join downloadersymbolsettings dss on s.symbolid = dss.symbolid where (s.symbol ILIKE '%lTCUSD%' or downloadersymbol ilike '%lTCUSD%' or s.shortname ilike '%lTCUSD%' or s.longname ilike '%lTCUSD%' or dss.classname ilike '%lTCUSD%' or s.exchange ilike '%lTCUSD%') GROUP BY s.symbolid, s.symbol, current_database(), dss.downloadersymbol, s.shortname, s.longname, s.exchange, dss.classname, dss.enabled, s.nonliquid, s.timegranularity ORDER BY symbol_match DESC, downloadersymbol_match DESC, longname_match DESC;

Date: 2024-01-29 12:06:04
Duration: 218ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.231
Application: PostgreSQL JDBC Driver

select distinct current_database() as database, s.symbolid, s.symbol, dss.downloadersymbol, s.shortname, s.longname, s.exchange, dss.classname, dss.enabled, s.nonliquid, s.timegranularity, count(s.symbolid) filter (where s.symbol ILIKE '%NVDA%') as symbol_match, count(s.symbolid) filter (where dss.downloadersymbol ILIKE '%NVDA%') as downloadersymbol_match, count(s.symbolid) filter (where s.longname ilike '%NVDA%') as longname_match, count(s.symbolid) filter (where dss.classname ilike '%NVDA%') as classname_match, count(s.symbolid) filter (where s.exchange ilike '%NVDA%') as exchange_match from symbols s join downloadersymbolsettings dss on s.symbolid = dss.symbolid where (s.symbol ILIKE '%NVDA%' or downloadersymbol ilike '%NVDA%' or s.shortname ilike '%NVDA%' or s.longname ilike '%NVDA%' or dss.classname ilike '%NVDA%' or s.exchange ilike '%NVDA%') GROUP BY s.symbolid, s.symbol, current_database(), dss.downloadersymbol, s.shortname, s.longname, s.exchange, dss.classname, dss.enabled, s.nonliquid, s.timegranularity ORDER BY symbol_match DESC, downloadersymbol_match DESC, longname_match DESC;

Date: 2024-01-29 12:02:50
Duration: 212ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.231
Application: PostgreSQL JDBC Driver

x Hide