pgBadger-
Global information
- Generated on Tue Dec 30 08:00:00 2025
- Log file: /home/postgres/pg_data/data/pg_log/postgresql-2025-12-30_090000.log
- Parsed 2,624,968 log entries in 59s
- Log start from 2025-12-30 09:00:00 to 2025-12-30 09:59:56
-
Overview
Global Stats
- 265 Number of unique normalized queries
- 276,725 Number of queries
- 1h30m45s Total query duration
- 2025-12-30 09:00:00 First query
- 2025-12-30 09:59:56 Last query
- 4,459 queries/s at 2025-12-30 09:30:04 Query peak
- 1h30m45s Total query duration
- 4s938ms Prepare/parse total duration
- 43s45ms Bind total duration
- 1h29m58s Execute total duration
- 1 Number of events
- 1 Number of unique normalized events
- 1 Max number of times the same event was reported
- 0 Number of cancellation
- 46 Total number of automatic vacuums
- 58 Total number of automatic analyzes
- 807 Number temporary file
- 583.57 MiB Max size of temporary file
- 6.84 MiB Average size of temporary file
- 2,489 Total number of sessions
- 12 sessions at 2025-12-30 09:53:07 Session peak
- 14d23h24m12s Total duration of sessions
- 8m39s Average duration of sessions
- 111 Average queries per session
- 2s188ms Average queries duration per session
- 8m37s Average idle time per session
- 2,486 Total number of connections
- 30 connections/s at 2025-12-30 09:40:02 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4,459 queries/s Query Peak
- 2025-12-30 09:30:04 Date
SELECT Traffic
Key values
- 2,147 queries/s Query Peak
- 2025-12-30 09:30:04 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 174 queries/s Query Peak
- 2025-12-30 09:33:51 Date
Queries duration
Key values
- 1h30m45s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 30 09 276,725 0ms 40s476ms 19ms 3m51s 4m21s 4m52s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 30 09 88,165 26 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 30 09 31,618 2,381 16 96 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Dec 30 09 17,404 107,115 6.15 12.89% Day Hour Count Average / Second Dec 30 09 2,486 0.69/s Day Hour Count Average Duration Average idle time Dec 30 09 2,489 8m39s 8m37s -
Connections
Established Connections
Key values
- 30 connections Connection Peak
- 2025-12-30 09:40:02 Date
Connections per database
Key values
- acaweb_fx Main Database
- 2,486 connections Total
Connections per user
Key values
- postgres Main User
- 2,486 connections Total
Connections per host
Key values
- 192.168.4.142 Main host with 994 connections
- 2,486 Total connections
Host Count 127.0.0.1 113 182.165.1.54 2 192.168.0.114 2 192.168.0.216 101 192.168.0.74 45 192.168.0.84 2 192.168.1.131 2 192.168.1.145 79 192.168.1.15 67 192.168.1.20 106 192.168.1.238 2 192.168.1.239 2 192.168.1.90 65 192.168.2.126 72 192.168.2.182 12 192.168.2.82 48 192.168.3.199 36 192.168.4.134 1 192.168.4.142 994 192.168.4.150 10 192.168.4.214 4 192.168.4.222 1 192.168.4.238 10 192.168.4.33 96 192.168.4.64 4 192.168.4.74 6 192.168.4.98 330 [local] 274 -
Sessions
Simultaneous sessions
Key values
- 12 sessions Session Peak
- 2025-12-30 09:53:07 Date
Histogram of session times
Key values
- 1,943 0-500ms duration
Sessions per database
Key values
- acaweb_fx Main Database
- 2,489 sessions Total
Sessions per user
Key values
- postgres Main User
- 2,489 sessions Total
Sessions per host
Key values
- 192.168.4.142 Main Host
- 2,489 sessions Total
Host Count Total Duration Average Duration 127.0.0.1 113 6s538ms 57ms 182.165.1.54 2 23h17m8s 11h38m34s 192.168.0.114 4 23m10s 5m47s 192.168.0.216 101 1m22s 817ms 192.168.0.74 45 1d11h8m 46m50s 192.168.0.84 2 23h59m21s 11h59m40s 192.168.1.131 2 23h59m20s 11h59m40s 192.168.1.145 80 3d17h56m51s 1h7m27s 192.168.1.15 67 2d5h48m28s 48m11s 192.168.1.20 106 2d16h28m55s 36m29s 192.168.1.238 2 23h59m27s 11h59m43s 192.168.1.239 2 12ms 6ms 192.168.1.90 65 35s60ms 539ms 192.168.2.126 72 17s30ms 236ms 192.168.2.182 12 928ms 77ms 192.168.2.82 48 16s792ms 349ms 192.168.3.199 36 1s420ms 39ms 192.168.4.134 1 213ms 213ms 192.168.4.142 994 8m24s 507ms 192.168.4.150 10 20h4m38s 2h27s 192.168.4.214 4 38ms 9ms 192.168.4.222 1 44s339ms 44s339ms 192.168.4.238 10 10s543ms 1s54ms 192.168.4.33 96 2m56s 1s833ms 192.168.4.64 4 25s939ms 6s484ms 192.168.4.74 6 66ms 11ms 192.168.4.98 330 15s307ms 46ms [local] 274 3m12s 702ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 16,171 buffers Checkpoint Peak
- 2025-12-30 09:07:47 Date
- 209.945 seconds Highest write time
- 0.007 seconds Sync time
Checkpoints Wal files
Key values
- 7 files Wal files usage Peak
- 2025-12-30 09:07:47 Date
Checkpoints distance
Key values
- 216.05 Mo Distance Peak
- 2025-12-30 09:07:47 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Dec 30 09 51,714 1,750.106s 0.039s 1,750.44s Day Hour Added Removed Recycled Synced files Longest sync Average sync Dec 30 09 0 0 26 1,897 0.004s 0s Day Hour Count Avg time (sec) Dec 30 09 0 0s Day Hour Mean distance Mean estimate Dec 30 09 35,379.75 kB 118,039.00 kB -
Temporary Files
Size of temporary files
Key values
- 583.57 MiB Temp Files size Peak
- 2025-12-30 09:13:10 Date
Number of temporary files
Key values
- 62 per second Temp Files Peak
- 2025-12-30 09:17:07 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Dec 30 09 807 5.39 GiB 6.84 MiB Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 28 1.66 GiB 7.64 MiB 178.98 MiB 60.74 MiB 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 = ? ), ok_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = ? ), 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 = ?) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, ?::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 = ?) 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 = ? where (ok.r is null or ok.r = ?) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = ?) and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > ? * ? and last.eventtimestamp > current_timestamp - interval ? and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval ?) and last.eventtimestamp > current_timestamp - interval ? and broker.r = ?;-
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: 2025-12-30 09:00:06 Duration: 0ms
2 19 135.48 MiB 7.12 MiB 7.15 MiB 7.13 MiB jr.resultuid as resultuid, jr.direction as direction, jr.patternendtime as identified, jr.patternlengthbars as length, jr.patternstarttime as patternstarttime, case when jr.trendchangeid = ? then ? else ? end as trendchange, 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, jp.patternname as pattern_name, dtt.timezone as timezone, ? as age, cps.pip, g.basegroupname from japsticks_results jr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = jr.symbolid inner join relevance_japsticks_results rar on rar.resultuid = jr.resultuid inner join symbols s on jr.symbolid = s.symbolid and s.nonliquid = ? inner join japsticks_patterns jp on jr.patternid = jp.id inner join downloadersymbolsettings dss on jr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on s.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 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 = ? where jr.gmttimefound > now() - interval ? and s.deleted = ? and (jr.simulation = ? or jr.simulation is null) and (rar.relevant = ?) --and (semicolon_age = ? or rar.age <= semicolon_age) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or jp.patternname in (...)) and (? = ? or jr.patternlengthbars <= ?) ), results as ( select distinct on (symbolid) * from all_results order by symbolid, resultuid ) select * from results order by identified desc, length desc ;-
jr.resultuid AS resultuid, jr.direction AS direction, jr.patternendtime AS identified, jr.patternlengthbars AS length, jr.patternstarttime AS patternstarttime, case when jr.trendchangeid = 1 then 'Continuation' else 'Reversal' end AS trendchange, 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, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.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 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 jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;
Date: 2025-12-30 09:01:49 Duration: 0ms
3 16 552.12 MiB 34.51 MiB 34.51 MiB 34.51 MiB update solr_relevance_old set new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total from ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total from whatshot_probability where type = ?) sub where result_uid = sub.resultuid;-
UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type = 'cp') sub WHERE result_uid = sub.resultuid;
Date: 2025-12-30 09:01:13 Duration: 0ms
4 16 1.10 GiB 70.69 MiB 70.70 MiB 70.69 MiB with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit ?) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then ? else ? end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then ? else ? end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike ? inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike ?) sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike ?; update solr_relevance_old set newrelevant = ? where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike ? and a.resultuid is null); update solr_relevance_old set new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total from ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total from whatshot_probability where type in (...)) sub where result_uid = sub.resultuid;-
with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;
Date: 2025-12-30 09:01:17 Duration: 0ms
5 8 955.13 MiB 119.35 MiB 119.44 MiB 119.39 MiB select updateresultsmaterializedview ();-
select updateresultsmaterializedview ();
Date: 2025-12-30 09:02:15 Duration: 0ms
6 4 352.65 MiB 88.08 MiB 88.26 MiB 88.16 MiB select updateageforrelevantresults ();-
select updateageforrelevantresults ();
Date: 2025-12-30 09:02:06 Duration: 0ms
Queries generating the largest temporary files
Rank Size Query 1 178.98 MiB 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: 2025-12-30 09:50:04 ]
2 172.48 MiB 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: 2025-12-30 09:40:04 ]
3 119.44 MiB select updateresultsmaterializedview ();[ Date: 2025-12-30 09:47:11 ]
4 119.42 MiB select updateresultsmaterializedview ();[ Date: 2025-12-30 09:50:33 ]
5 119.40 MiB select updateresultsmaterializedview ();[ Date: 2025-12-30 09:32:12 ]
6 119.40 MiB select updateresultsmaterializedview ();[ Date: 2025-12-30 09:02:15 ]
7 119.39 MiB select updateresultsmaterializedview ();[ Date: 2025-12-30 09:35:33 ]
8 119.37 MiB select updateresultsmaterializedview ();[ Date: 2025-12-30 09:17:11 ]
9 119.36 MiB select updateresultsmaterializedview ();[ Date: 2025-12-30 09:20:33 ]
10 119.35 MiB select updateresultsmaterializedview ();[ Date: 2025-12-30 09:05:33 ]
11 108.98 MiB 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: 2025-12-30 09:30:04 ]
12 99.35 MiB 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: 2025-12-30 09:00:05 ]
13 88.26 MiB select updateageforrelevantresults ();[ Date: 2025-12-30 09:02:06 ]
14 88.17 MiB select updateageforrelevantresults ();[ Date: 2025-12-30 09:32:05 ]
15 88.14 MiB select updateageforrelevantresults ();[ Date: 2025-12-30 09:47:04 ]
16 88.08 MiB select updateageforrelevantresults ();[ Date: 2025-12-30 09:17:04 ]
17 87.09 MiB 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: 2025-12-30 09:20:04 ]
18 76.48 MiB 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: 2025-12-30 09:30:05 ]
19 74.90 MiB 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: 2025-12-30 09:00:06 ]
20 70.70 MiB with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;[ Date: 2025-12-30 09:11:18 ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Analyzes per table
Key values
- public.solr_relevance_old (16) Main table analyzed (database acaweb_fx)
- 58 analyzes Total
Table Number of analyzes acaweb_fx.public.solr_relevance_old 16 acaweb_fx.pg_catalog.pg_attribute 6 acaweb_fx.public.datafeeds_latestrun 4 acaweb_fx.public.relevance_keylevels_results 4 acaweb_fx.pg_catalog.pg_class 4 acaweb_fx.public.relevance_fibonacci_results 4 acaweb_fx.public.relevance_autochartist_results 4 acaweb_fx.pg_catalog.pg_type 3 acaweb_fx.pg_catalog.pg_index 2 acaweb_fx.public.autochartist_symbolupdates 2 acaweb_fx.pg_catalog.pg_depend 2 acaweb_fx.public.latest_t15_candle_view 2 acaweb_fx.public.solr_imports 1 socialmedia.public.processes 1 acaweb_fx.public.latest_candle_datetime_per_receng 1 acaweb_fx.public.relevance_consecutivecandles_results 1 acaweb_fx.public.correlating_signals 1 Total 58 Vacuums per table
Key values
- public.solr_relevance_old (19) Main table vacuumed on database acaweb_fx
- 46 vacuums Total
Index Buffer usage Skipped WAL usage Table Vacuums scans hits misses dirtied pins frozen records full page bytes acaweb_fx.public.solr_relevance_old 19 17 15,388 0 58 0 79 9,629 16 1,710,559 acaweb_fx.public.datafeeds_latestrun 4 0 482 0 12 0 0 60 36 77,824 acaweb_fx.public.relevance_autochartist_results 3 3 10,378 0 166 2 700 1,775 138 506,395 acaweb_fx.pg_toast.pg_toast_2619 2 2 320 0 62 0 0 224 58 247,722 acaweb_fx.pg_catalog.pg_attribute 2 2 1,580 0 309 0 134 704 254 1,547,539 acaweb_fx.public.relevance_keylevels_results 2 2 7,613 0 252 0 148 2,360 237 851,834 acaweb_fx.pg_catalog.pg_class 2 2 935 0 109 0 0 293 108 554,103 acaweb_fx.public.relevance_fibonacci_results 2 2 2,532 0 35 2 89 450 21 109,000 acaweb_fx.pg_catalog.pg_index 1 1 98 0 12 0 0 34 9 69,284 acaweb_fx.public.autochartist_symbolupdates 1 1 23,605 0 6,025 2 36,951 9,498 5,394 3,064,201 acaweb_fx.public.solr_imports 1 1 66 0 1 0 0 6 1 8,901 acaweb_fx.public.latest_t15_candle_view 1 1 66 0 1 0 0 6 1 9,067 acaweb_fx.pg_catalog.pg_depend 1 1 414 0 65 0 59 160 58 303,245 acaweb_fx.pg_catalog.pg_type 1 1 128 0 26 0 0 50 17 115,013 acaweb_fx.pg_catalog.pg_statistic 1 1 1,006 0 156 0 582 471 138 598,743 acaweb_fx.public.relevance_consecutivecandles_results 1 1 79 0 3 0 0 20 2 15,489 acaweb_fx.public.symbollatestupdatetime 1 0 1,501 0 144 0 638 1,058 139 429,745 acaweb_fx.public.correlating_signals 1 1 192 0 13 0 0 50 12 63,091 Total 46 39 66,383 53,073 7,449 6 39,380 26,848 6,639 10,281,755 Tuples removed per table
Key values
- public.solr_relevance_old (45338) Main table with removed tuples on database acaweb_fx
- 79704 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain acaweb_fx.public.solr_relevance_old 19 17 45,338 132,466 15,348 0 4,054 acaweb_fx.public.symbollatestupdatetime 1 0 18,632 89,637 120 0 1,714 acaweb_fx.public.autochartist_symbolupdates 1 1 5,629 63,139 226 0 40,691 acaweb_fx.public.relevance_keylevels_results 2 2 3,523 26,554 0 0 558 acaweb_fx.pg_catalog.pg_attribute 2 2 2,411 21,901 252 16 500 acaweb_fx.public.relevance_autochartist_results 3 3 1,445 28,743 1,358 0 1,140 acaweb_fx.pg_catalog.pg_statistic 1 1 607 3,676 0 0 1,194 acaweb_fx.pg_catalog.pg_depend 1 1 508 14,647 0 0 135 acaweb_fx.public.relevance_fibonacci_results 2 2 478 3,332 0 0 204 acaweb_fx.pg_catalog.pg_class 2 2 320 3,298 0 0 300 acaweb_fx.public.datafeeds_latestrun 4 0 245 56 0 0 64 acaweb_fx.pg_toast.pg_toast_2619 2 2 141 348 8 0 104 acaweb_fx.pg_catalog.pg_type 1 1 136 1,446 0 0 38 acaweb_fx.public.correlating_signals 1 1 71 372 0 0 19 acaweb_fx.public.relevance_consecutivecandles_results 1 1 69 292 0 0 7 acaweb_fx.public.latest_t15_candle_view 1 1 63 14 0 0 1 acaweb_fx.public.solr_imports 1 1 51 1 0 0 2 acaweb_fx.pg_catalog.pg_index 1 1 37 813 0 1 22 Total 46 39 79,704 390,735 17,312 17 50,747 Pages removed per table
Key values
- pg_catalog.pg_attribute (16) Main table with removed pages on database acaweb_fx
- 17 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed acaweb_fx.pg_catalog.pg_attribute 2 2 2411 16 acaweb_fx.pg_catalog.pg_index 1 1 37 1 acaweb_fx.pg_toast.pg_toast_2619 2 2 141 0 acaweb_fx.public.autochartist_symbolupdates 1 1 5629 0 acaweb_fx.public.datafeeds_latestrun 4 0 245 0 acaweb_fx.public.solr_imports 1 1 51 0 acaweb_fx.public.latest_t15_candle_view 1 1 63 0 acaweb_fx.pg_catalog.pg_depend 1 1 508 0 acaweb_fx.public.relevance_keylevels_results 2 2 3523 0 acaweb_fx.pg_catalog.pg_class 2 2 320 0 acaweb_fx.public.relevance_fibonacci_results 2 2 478 0 acaweb_fx.pg_catalog.pg_type 1 1 136 0 acaweb_fx.pg_catalog.pg_statistic 1 1 607 0 acaweb_fx.public.relevance_consecutivecandles_results 1 1 69 0 acaweb_fx.public.symbollatestupdatetime 1 0 18632 0 acaweb_fx.public.relevance_autochartist_results 3 3 1445 0 acaweb_fx.public.solr_relevance_old 19 17 45338 0 acaweb_fx.public.correlating_signals 1 1 71 0 Total 46 39 79,704 17 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Dec 30 09 46 58 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 88,165 Total read queries
- 46,803 Total write queries
Queries by database
Key values
- unknown Main database
- 275,711 Requests
- 1h29m58s (unknown)
- Main time consuming database
Database Request type Count Duration acaweb_fx Total 918 0ms copy from 80 0ms copy to 26 0ms cte 104 0ms ddl 16 0ms delete 16 0ms others 203 0ms select 102 0ms tcl 332 0ms update 39 0ms socialmedia Total 96 0ms select 96 0ms unknown Total 275,711 1h29m58s copy from 16 0ms cte 11,846 0ms insert 31,618 0ms others 3,191 0ms select 87,967 0ms tcl 368 0ms update 2,342 0ms Queries by user
Key values
- unknown Main user
- 275,711 Requests
User Request type Count Duration postgres Total 1,014 0ms copy from 80 0ms copy to 26 0ms cte 104 0ms ddl 16 0ms delete 16 0ms others 203 0ms select 198 0ms tcl 332 0ms update 39 0ms unknown Total 275,711 1h29m58s copy from 16 0ms cte 11,846 0ms insert 31,618 0ms others 3,191 0ms select 87,967 0ms tcl 368 0ms update 2,342 0ms Duration by user
Key values
- 1h29m58s (unknown) Main time consuming user
User Request type Count Duration postgres Total 1,014 0ms copy from 80 0ms copy to 26 0ms cte 104 0ms ddl 16 0ms delete 16 0ms others 203 0ms select 198 0ms tcl 332 0ms update 39 0ms unknown Total 275,711 1h29m58s copy from 16 0ms cte 11,846 0ms insert 31,618 0ms others 3,191 0ms select 87,967 0ms tcl 368 0ms update 2,342 0ms Queries by host
Key values
- unknown Main host
- 276,725 Requests
- 1h29m58s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 276,338 Requests
- 1h29m58s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-12-30 09:22:10 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 102,200 0-1ms duration
Slowest individual queries
Rank Duration Query NO DATASET
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 1 0ms 0ms 0ms insert into t30 (symbolid, pricedatetime, open, high, low, close, volume, bsf, sastdatetimereceived) values (?, ?::timestamp without time zone, ?.?, ?.?, ?.?, ?, ?, ?, ?::timestamp without time zone) on conflict (symbolid, pricedatetime) do nothing;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 30 09 1 0ms 0ms 2 0ms 45 0ms 0ms 0ms select key, value from datasources ds inner join datasourceparams dsp on ds.id = dsp.datasourceid where ds.name = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 30 09 45 0ms 0ms 3 0ms 42 0ms 0ms 0ms with rar_max as ( select resultuid from relevance_bigmovement_results order by resultuid desc limit ? ) select bmr.symbolid, patternstarttime, patternendtime, timegranularity, ? as direction, case when bmr.old_resultuid = ? then bmr.old_resultuid else bmr.resultuid end as uid, s.exchange, s.symbol, s.longname, s.shortname, dtt.timezone, bmr.patternmovement, bmr.statisticalmovement, bmr.fromprice, bmr.toprice, bmr.percentile, bmr.patternlengthbars, case when rbr.age is not null then rbr.age when bmr.resultuid <= rm.resultuid then ? else ? end as age, case when rbr.relevant is not null then rbr.relevant when bmr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from bigmovement_results bmr inner join downloadersymbolsettings dss on bmr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join symbols s on bmr.symbolid = s.symbolid inner join rar_max rm on ? = ? left outer join relevance_bigmovement_results rbr on rbr.resultuid = bmr.resultuid left join currencypips cps on cps.symbol = s.symbol where (bmr.old_resultuid = ? or bmr.resultuid = ?) and dtt.dayofweek = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 30 09 42 0ms 0ms 4 0ms 2,167 0ms 0ms 0ms insert into t60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 30 09 2,167 0ms 0ms 5 0ms 48 0ms 0ms 0ms select count(*) from datafeeds_latestrun where feedname ilike ? and ((latestrxtime > current_timestamp - interval ? and latestdbwritetime > current_timestamp - interval ?) or (latestdbwritetime > current_timestamp - interval ? and lateststartuptime > current_timestamp - interval ?));Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 30 09 48 0ms 0ms 6 0ms 4 0ms 0ms 0ms select updaterelevantforrelevantresults ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 30 09 4 0ms 0ms 7 0ms 18 0ms 0ms 0ms select cast(count(*) / cast(setting as numeric) * ? as int) from pg_stat_activity, pg_settings where name = ? group by setting;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 30 09 18 0ms 0ms 8 0ms 350 0ms 0ms 0ms commit;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 30 09 350 0ms 0ms 9 0ms 282 0ms 0ms 0ms with rar_max as ( select resultuid from relevance_keylevels_results order by resultuid desc limit ? ), kr as ( select a.*, rr.age, rr.relevant from keylevels_results a left outer join relevance_keylevels_results rr on a.resultuid = rr.resultuid where case when false = ? then true else a.resultuid > ( select min(resultuid) from relevance_keylevels_results) end ), all_results as ( select kr.resultuid as resultuid, kr.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, p.patternname as pattern_name, kr.breakout as breakout, kr.atbaridentified as identified, dtt.timezone as timezone, kr.patternlengthbars as length, g.basegroupname, newlevels.filtered, case when kr.age is not null then kr.age when kr.resultuid <= rm.resultuid then ? else ? end as age, case when kr.relevant is not null then kr.relevant when kr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from kr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = kr.symbolid inner join symbols s on bsl.symbolid = s.symbolid and s.nonliquid = ? inner join symbolgroup sg on s.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 hrspatterns p on kr.patternid = p.patternid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join rar_max rm on ? = ? left outer join autochartist_symbolupdates au on dss.symbolid = au.symbolid left outer join relevance_keylevels_results rar on rar.resultuid = kr.resultuid left join lateral calc_kl_signal_filter (kr.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 = ? where kr.gmttimefound > now() - interval ? and dss.enabled = ? and s.deleted = ? and (kr.simulation = ? or kr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or p.patternname in (...)) and (? = ? or kr.patternclassid in (...)) and (? = ? or kr.patternlengthbars <= ?) and kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, ?::timestamp without time zone) -- to make sure patternstarttime is in our t-tables ), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 30 09 282 0ms 0ms 10 0ms 240 0ms 0ms 0ms select count(*), sum(size), extract(epoch from now() - min(modification)) from pg_ls_waldir ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 30 09 240 0ms 0ms 11 0ms 240 0ms 0ms 0ms select system_identifier from pg_control_system ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 30 09 240 0ms 0ms 12 0ms 4 0ms 0ms 0ms select groupid, exchange, groupname, symbol, longname from prfsymboltree where brokerid = ? order by groupname, symbol;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 30 09 4 0ms 0ms 13 0ms 4 0ms 0ms 0ms insert into t15 (symbolid, pricedatetime, open, high, low, close, volume, bsf, sastdatetimereceived) values (?, ?::timestamp without time zone, ?, ?.?, ?.?, ?.?, ?, ?, ?::timestamp without time zone) on conflict (symbolid, pricedatetime) do nothing;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 30 09 4 0ms 0ms 14 0ms 12 0ms 0ms 0ms select updatedatafeedslatestrun (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 30 09 12 0ms 0ms 15 0ms 1 0ms 0ms 0ms insert into t15 (symbolid, pricedatetime, open, high, low, close, volume, bsf, sastdatetimereceived) values (?, ?::timestamp without time zone, ?.?, ?, ?, ?.?, ?, ?, ?::timestamp without time zone) on conflict (symbolid, pricedatetime) do nothing;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 30 09 1 0ms 0ms 16 0ms 1 0ms 0ms 0ms insert into t15 (symbolid, pricedatetime, open, high, low, close, volume, bsf, sastdatetimereceived) values (?, ?::timestamp without time zone, ?.?, ?.?, ?.?, ?, ?, ?, ?::timestamp without time zone) on conflict (symbolid, pricedatetime) do nothing;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 30 09 1 0ms 0ms 17 0ms 258 0ms 0ms 0ms with rar_max as ( select resultuid from relevance_fibonacci_results order by resultuid desc limit ? ), 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 = ? 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 ? else ? end as age, case when fr.relevant is not null then fr.relevant when fr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from fr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = fr.symbolid inner join symbols s on fr.symbolid = s.symbolid and s.nonliquid = ? 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 = ? inner join rar_max rm on ? = ? 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 = ? where fr.gmttimefound > now() - interval ? and dss.enabled = ? and s.deleted = ? and (fr.simulation = ? or fr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or fr.pattern in (...)) and (? = ? or fr.patternlengthbars <= ?) and (? = ? or (? = ? and fr.timed > cast(? as timestamp)) or (? = ? and fr.timed < cast(? as timestamp))) ), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 30 09 258 0ms 0ms 18 0ms 3 0ms 0ms 0ms insert into t15 (symbolid, pricedatetime, open, high, low, close, volume, bsf, sastdatetimereceived) values (?, ?::timestamp without time zone, ?.?, ?.?, ?, ?.?, ?, ?, ?::timestamp without time zone) on conflict (symbolid, pricedatetime) do nothing;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 30 09 3 0ms 0ms 19 0ms 12 0ms 0ms 0ms select distinct classname, to_char(created_datetime, ?), to_char(cleared_datetime, ?), action_to_take, description, created_datetime from datafeed_restarter_events where (is_current_entry = ? or cleared_datetime > current_timestamp - interval ?) order by created_datetime desc;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 30 09 12 0ms 0ms 20 0ms 16 0ms 0ms 0ms with max_ra as ( select resultuid from relevance_fibonacci_results order by resultuid desc limit ?) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then ? else ? end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then ? else ? end as age, so.result_uid from max_ra, solr_relevance_old so left outer join relevance_fibonacci_results ra on so.result_uid = ra.resultuid and so.uuid ilike ?) sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike ?; update solr_relevance_old set newrelevant = ? where result_uid in ( select result_uid from solr_relevance_old s left outer join fibonacci_results a on a.resultuid = s.result_uid where s.uuid ilike ? and a.resultuid is null);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 30 09 16 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 40,262 0ms 0ms 0ms 0ms select ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 30 09 40,262 0ms 0ms 2 12,796 0ms 0ms 0ms 0ms select distinct on (coalesce(bim.code, s.symbol) , s.exchange, s.timegranularity, df.timezone) s.symbolid as id, coalesce(bim.code, s.symbol) as name, s.symbol as symbol, dss.downloadersymbol as ticker, s.exchange as exchange, s.timegranularity as interval, df.timezone as timezone from symbols s inner join downloadersymbolsettings dss on dss.symbolid = s.symbolid inner join datafeedstimetable df on df.classname ilike dss.classname left join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = s.symbolid left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = ? and bim.type = ? where s.symbolid = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 30 09 12,796 0ms 0ms 3 9,294 0ms 0ms 0ms 0ms select s.symbolid as id, s.symbol as name, s.exchange as exchange, s.timegranularity as interval, dtt.timezone as timezone from symbols s inner join downloadersymbolsettings dss on dss.symbolid = s.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where bsl.brokerid = ? and (? = ? or s.timegranularity = ?) and (s.symbol = ? or dss.downloadersymbol = ?) and dss.enabled = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 30 09 9,294 0ms 0ms 4 8,412 0ms 0ms 0ms 0ms insert into executionlogs (executionid, status, message, details, detailtype) values (null, ?, ?, null, null);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 30 09 8,412 0ms 0ms 5 6,192 0ms 0ms 0ms 0ms insert into autochartist_results (resultid, symbolid, bandwidth, pattern, qtytp, gmttimefound, direction, initialtrend, breakout, volumeincrease, noise, symmetry, predictionpricefrom, predictionpriceto, predictiontimefrom, predictiontimeto, patternstarttime, patternendtime, patternstartprice, patternendprice, resx0, resx1, supportx0, supportx1, resy0, resy1, supporty0, supporty1, supportgradient, resgradient, riskreward, patternquality, trendchange, maxmovementafterbreakout, latestbaratbreakouttime, latestbaratbreakoutprice, patternlengthbars, temporarypattern, relevancestartdistance, simulation, writtendatetime) values (?, ?, ?.?, ?, ?, ?::timestamp without time zone, ?, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?::timestamp without time zone, ?::timestamp without time zone, ?::timestamp without time zone, ?::timestamp without time zone, ?.?, ?.?, ?::timestamp without time zone, ?::timestamp without time zone, ?::timestamp without time zone, ?::timestamp without time zone, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?, ?.?, ?::timestamp without time zone, ?.?, ?, ?, ?.?, ?, current_timestamp::timestamp without time zone) on conflict do nothing;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 30 09 6,192 0ms 0ms 6 5,779 0ms 0ms 0ms 0ms insert into t15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 30 09 5,779 0ms 0ms 7 5,609 0ms 0ms 0ms 0ms with rar_max as ( select resultuid from relevance_autochartist_results order by resultuid desc limit ? ) select a.symbolid, pattern, patternid, resy0, resy1, resx0, resx1, supporty0, supporty1, supportx0, supportx1, predictiontimeto, patternstarttime, timegranularity, patternendtime, direction, trendchange, patternlengthbars, patternquality, case when a.old_resultuid = ? then a.old_resultuid else a.resultuid end as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, s.exchange, s.symbol, s.longname, s.shortname, breakout, dtt.timezone, patternstartprice, patternendprice, qtytp, newlevels.profit, newlevels.stop, newlevels.filtered, case when rar.age is not null then rar.age when a.resultuid <= rm.resultuid then ? else ? end as age, case when rar.relevant is not null then rar.relevant when a.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from autochartist_results a inner join downloadersymbolsettings dss on a.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join patterns p on p.patternname = a.pattern inner join rar_max rm on ? = ? left outer join relevance_autochartist_results rar on rar.resultuid = a.resultuid left join lateral calc_cp_signal (a.resultuid) newlevels on true left join currencypips cps on cps.symbol = s.symbol where (a.old_resultuid = ? or a.resultuid = ?) and dtt.dayofweek = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 30 09 5,609 0ms 0ms 8 5,126 0ms 0ms 0ms 0ms select category, name, sum(total) as total, sum(correct) as correct, (cast(sum(correct) as float) / cast(sum(total) as float)) * ?.? as percentage, min("from") AS "from", max("to") AS "to" from ( select category, name, total, correct, percentage, "from", "to" from stats_summary where statsid = ? and category = lower(?) union select category, name, total, correct, percentage, "from", "to" from stats_hrs_summary where statsid = ? and category = lower(?) order by correct desc) as summdata group by category, name having sum(total) > ? order by name;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 30 09 5,126 0ms 0ms 9 3,287 0ms 0ms 0ms 0ms insert into t30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 30 09 3,287 0ms 0ms 10 2,871 0ms 0ms 0ms 0ms insert into keylevels_results (bandwidth, breakout, patternid, gmttimefound, approachingtimestamp, approachingregion, qtytp, patternlengthbars, patternprice, x0, x1, x2, x3, x4, x5, x6, x7, x8, x9, breakoutbars, breakoutprice, patternendtime, atbaridentified, atpriceidentified, errormargin, direction, symbolid, predictionpricefrom, predictionpriceto, predictiontimefrom, predictiontimebars, uniquepointsvalue, furthestprice, relevancestartdistance, patternclassid, patternstarttime, stoplosslevel, simulation, writtendatetime) values (?.?, ?, ?, ?::timestamp without time zone, ?, ?.?, ?, ?, ?.?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?.?, ?::timestamp without time zone, ?, ?.?, ?.?, ?, ?, ?.?, ?.?, ?::timestamp without time zone, ?, ?, ?.?, ?.?, ?, ?, ?.?, ?, current_timestamp::timestamp without time zone) on conflict do nothing;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 30 09 2,871 0ms 0ms 11 2,796 0ms 0ms 0ms 0ms select category, name, sum(total) as total, sum(correct) as correct, (cast(sum(correct) as float) / cast(sum(total) as float)) * ?.? as percentage, min("from") AS "from", max("to") AS "to" from ( select category, name, total, correct, percentage, "from", "to" from stats_hrsapproaches_summary where statsid = ? and category = lower(?) order by correct desc) as summdata group by category, name having sum(total) > ? order by name;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 30 09 2,796 0ms 0ms 12 2,672 0ms 0ms 0ms 0ms with rar_max as ( select resultuid from relevance_keylevels_results order by resultuid desc limit ? ) select case when a.old_resultuid = ? then a.old_resultuid else a.resultuid end as ruid, s.symbolid as sid, s.symbol as sym, longname, shortname, exchange as e, timegranularity as tg, a.patternid as pid, a.direction as d, a.patternprice as pp, atbaridentified as pet, case when (x9 != ?) then x9 when (x8 != ?) then x8 when (x7 != ?) then x7 when (x6 != ?) then x6 when (x5 != ?) then x5 when (x4 != ?) then x4 when (x3 != ?) then x3 when (x2 != ?) then x2 end as pst, patternprice as patp, x0, x1, x2, case when (x3 != ?) then x3 else ? end as x3, case when (x4 != ?) then x4 else ? end as x4, case when (x5 != ?) then x5 else ? end as x5, case when (x6 != ?) then x6 else ? end as x6, case when (x7 != ?) then x7 else ? end as x7, case when (x8 != ?) then x8 else ? end as x8, errormargin as erm, breakoutprice as pe, breakoutbars as be, breakout, atbaridentified as atbar, atpriceidentified as atprice, patternlengthbars as l, bandwidth as bw, qtytp as qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzos, dtt.timezone as timezone, approachingtimestamp as apt, approachingregion as apr, predictionpricefrom as ppf, predictionpriceto as ppt, predictiontimefrom as ptf, predictiontimebars as ptb, furthestprice as fp, newlevels.filtered, a.uniquepointsvalue as upv, case when rar.age is not null then rar.age when a.resultuid <= rm.resultuid then ? else ? end as age, case when rar.relevant is not null then rar.relevant when a.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from keylevels_results a inner join downloadersymbolsettings dss on a.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join hrspatterns p on a.patternid = p.patternid inner join rar_max rm on ? = ? left outer join relevance_keylevels_results rar on a.resultuid = rar.resultuid left join lateral calc_kl_signal_filter (a.resultuid) newlevels on true left join currencypips cps on cps.symbol = s.symbol where (a.old_resultuid = ? or a.resultuid = ?) and dtt.dayofweek = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 30 09 2,672 0ms 0ms 13 2,167 0ms 0ms 0ms 0ms insert into t60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 30 09 2,167 0ms 0ms 14 1,854 0ms 0ms 0ms 0ms insert into fibonacci_results (bandwidth, pattern, gmttimefound, direction, patternstarttime, patternendtime, patternstartprice, patternendprice, qtytp, pricex, timex, pricea, timea, priceb, timeb, pricec, timec, priced, timed, averagequality, timequality, errormargin, patternlengthbars, target10, target06, target16, target07, target12, target05, target03, symbolid, noise, ratiosfound, temporarypattern, uniqueindex, completed, simulation, writtendatetime) values (?.?, ?, ?::timestamp without time zone, ?, ?::timestamp without time zone, ?::timestamp without time zone, ?.?, ?.?, ?, ?.?, ?::timestamp without time zone, ?.?, ?::timestamp without time zone, ?.?, ?::timestamp without time zone, ?.?, ?::timestamp without time zone, ?.?, ?::timestamp without time zone, ?.?, ?.?, ?.?, ?, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?, ?.?, ?, ?, ?, ?, ?, current_timestamp::timestamp without time zone) on conflict do nothing;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 30 09 1,854 0ms 0ms 15 1,761 0ms 0ms 0ms 0ms update patternresultsrelevance set relevant = ?, saxo_relevant = ?, notrelevantpricedatetime = ?, reason = ? where uniqueindex = ? and relevant = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 30 09 1,761 0ms 0ms 16 1,688 0ms 0ms 0ms 0ms select case when a.old_resultuid = ? then a.old_resultuid else a.resultuid end as resultuid, s.symbol, pattern as patternname, timegranularity as interval, patternlengthbars as length, patternendtime, direction, breakout, predictiontimeto, predictionpricefrom, predictionpriceto, patternstartprice, resy1, supporty1, dtt.timezone, cps.pip, newlevels.profit from autochartist_results a inner join downloadersymbolsettings dss on a.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join patterns p on p.patternname = a.pattern left join currencypips cps on cps.symbol = s.symbol left join lateral calc_cp_signal (a.resultuid) newlevels on true where (a.old_resultuid = ? or a.resultuid = ?) and dtt.dayofweek = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 30 09 1,688 0ms 0ms 17 1,382 0ms 0ms 0ms 0ms set extra_float_digits = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 30 09 1,382 0ms 0ms 18 1,347 0ms 0ms 0ms 0ms set application_name = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 30 09 1,347 0ms 0ms 19 1,337 0ms 0ms 0ms 0ms with rar_max as ( select resultuid from relevance_fibonacci_results order by resultuid desc limit ? ) select case when a.old_resultuid = ? then a.old_resultuid else a.resultuid end as ruid, s.symbolid as sid, s.symbol as sym, exchange as e, longname as lo, shortname as sho, timegranularity as tg, p.patternid as pid, direction as d, patternstarttime as pst, patternendtime as pet, patternstartprice as psp, patternendprice as pep, pricex as px, timex as tx, pricea as pa, timea as ta, priceb as pb, timeb as tb, pricec as pc, timec as tc, priced as pd, timed as td, averagequality as aq, timequality as tq, ? - errormargin as rq, ? - noise as c, target10 as t10, target06 as t06, target16 as t16, target07 as t07, target12 as t12, target03 as t03, target05 as t05, patternlengthbars as l, temporarypattern as tp, bandwidth as bw, qtytp as qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzos, dtt.timezone as tz, case when rar.age is not null then rar.age when a.resultuid <= rm.resultuid then ? else ? end as age, case when rar.relevant is not null then rar.relevant when a.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip, newlevels.filtered from fibonacci_results a inner join downloadersymbolsettings dss on a.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join fibonaccipatterns p on a.pattern = p.patternname inner join rar_max rm on ? = ? left outer join relevance_fibonacci_results rar on a.resultuid = rar.resultuid left join currencypips cps on cps.symbol = s.symbol left join lateral calc_fib_signal_filter (a.resultuid) newlevels on true where (a.old_resultuid = ? or a.resultuid = ?) and dtt.dayofweek = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 30 09 1,337 0ms 0ms 20 840 0ms 0ms 0ms 0ms select symbolid, pricedatetime, classname, downloadfrequency, downloadersymbol, open, high, low, close, volume, bsf, sastdatetimereceived from ( select pricedatetime, dss.classname, dss.downloadfrequency, dss.symbolid, dss.downloadersymbol, t.open, t.high, t.low, t.close, t.volume, t.bsf, t.sastdatetimereceived, row_number() over (partition by t.symbolid order by t.pricedatetime desc) as rn from t15 t, downloadersymbolsettings dss, symbols s where dss.classname = ? and dss.downloadfrequency = ? and dss.symbolid = t.symbolid and s.symbolid = dss.symbolid and dss.enabled = ? and s.deleted = ? and dss.downloadersymbol in (...) and t.pricedatetime > now() - interval ?) as ranked_candles_table where rn = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 30 09 840 0ms 0ms Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 0ms 0ms 0ms 1 0ms insert into t30 (symbolid, pricedatetime, open, high, low, close, volume, bsf, sastdatetimereceived) values (?, ?::timestamp without time zone, ?.?, ?.?, ?.?, ?, ?, ?, ?::timestamp without time zone) on conflict (symbolid, pricedatetime) do nothing;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 30 09 1 0ms 0ms 2 0ms 0ms 0ms 45 0ms select key, value from datasources ds inner join datasourceparams dsp on ds.id = dsp.datasourceid where ds.name = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 30 09 45 0ms 0ms 3 0ms 0ms 0ms 42 0ms with rar_max as ( select resultuid from relevance_bigmovement_results order by resultuid desc limit ? ) select bmr.symbolid, patternstarttime, patternendtime, timegranularity, ? as direction, case when bmr.old_resultuid = ? then bmr.old_resultuid else bmr.resultuid end as uid, s.exchange, s.symbol, s.longname, s.shortname, dtt.timezone, bmr.patternmovement, bmr.statisticalmovement, bmr.fromprice, bmr.toprice, bmr.percentile, bmr.patternlengthbars, case when rbr.age is not null then rbr.age when bmr.resultuid <= rm.resultuid then ? else ? end as age, case when rbr.relevant is not null then rbr.relevant when bmr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from bigmovement_results bmr inner join downloadersymbolsettings dss on bmr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join symbols s on bmr.symbolid = s.symbolid inner join rar_max rm on ? = ? left outer join relevance_bigmovement_results rbr on rbr.resultuid = bmr.resultuid left join currencypips cps on cps.symbol = s.symbol where (bmr.old_resultuid = ? or bmr.resultuid = ?) and dtt.dayofweek = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 30 09 42 0ms 0ms 4 0ms 0ms 0ms 2,167 0ms insert into t60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 30 09 2,167 0ms 0ms 5 0ms 0ms 0ms 48 0ms select count(*) from datafeeds_latestrun where feedname ilike ? and ((latestrxtime > current_timestamp - interval ? and latestdbwritetime > current_timestamp - interval ?) or (latestdbwritetime > current_timestamp - interval ? and lateststartuptime > current_timestamp - interval ?));Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 30 09 48 0ms 0ms 6 0ms 0ms 0ms 4 0ms select updaterelevantforrelevantresults ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 30 09 4 0ms 0ms 7 0ms 0ms 0ms 18 0ms select cast(count(*) / cast(setting as numeric) * ? as int) from pg_stat_activity, pg_settings where name = ? group by setting;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 30 09 18 0ms 0ms 8 0ms 0ms 0ms 350 0ms commit;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 30 09 350 0ms 0ms 9 0ms 0ms 0ms 282 0ms with rar_max as ( select resultuid from relevance_keylevels_results order by resultuid desc limit ? ), kr as ( select a.*, rr.age, rr.relevant from keylevels_results a left outer join relevance_keylevels_results rr on a.resultuid = rr.resultuid where case when false = ? then true else a.resultuid > ( select min(resultuid) from relevance_keylevels_results) end ), all_results as ( select kr.resultuid as resultuid, kr.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, p.patternname as pattern_name, kr.breakout as breakout, kr.atbaridentified as identified, dtt.timezone as timezone, kr.patternlengthbars as length, g.basegroupname, newlevels.filtered, case when kr.age is not null then kr.age when kr.resultuid <= rm.resultuid then ? else ? end as age, case when kr.relevant is not null then kr.relevant when kr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from kr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = kr.symbolid inner join symbols s on bsl.symbolid = s.symbolid and s.nonliquid = ? inner join symbolgroup sg on s.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 hrspatterns p on kr.patternid = p.patternid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join rar_max rm on ? = ? left outer join autochartist_symbolupdates au on dss.symbolid = au.symbolid left outer join relevance_keylevels_results rar on rar.resultuid = kr.resultuid left join lateral calc_kl_signal_filter (kr.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 = ? where kr.gmttimefound > now() - interval ? and dss.enabled = ? and s.deleted = ? and (kr.simulation = ? or kr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or p.patternname in (...)) and (? = ? or kr.patternclassid in (...)) and (? = ? or kr.patternlengthbars <= ?) and kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, ?::timestamp without time zone) -- to make sure patternstarttime is in our t-tables ), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 30 09 282 0ms 0ms 10 0ms 0ms 0ms 240 0ms select count(*), sum(size), extract(epoch from now() - min(modification)) from pg_ls_waldir ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 30 09 240 0ms 0ms 11 0ms 0ms 0ms 240 0ms select system_identifier from pg_control_system ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 30 09 240 0ms 0ms 12 0ms 0ms 0ms 4 0ms select groupid, exchange, groupname, symbol, longname from prfsymboltree where brokerid = ? order by groupname, symbol;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 30 09 4 0ms 0ms 13 0ms 0ms 0ms 4 0ms insert into t15 (symbolid, pricedatetime, open, high, low, close, volume, bsf, sastdatetimereceived) values (?, ?::timestamp without time zone, ?, ?.?, ?.?, ?.?, ?, ?, ?::timestamp without time zone) on conflict (symbolid, pricedatetime) do nothing;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 30 09 4 0ms 0ms 14 0ms 0ms 0ms 12 0ms select updatedatafeedslatestrun (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 30 09 12 0ms 0ms 15 0ms 0ms 0ms 1 0ms insert into t15 (symbolid, pricedatetime, open, high, low, close, volume, bsf, sastdatetimereceived) values (?, ?::timestamp without time zone, ?.?, ?, ?, ?.?, ?, ?, ?::timestamp without time zone) on conflict (symbolid, pricedatetime) do nothing;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 30 09 1 0ms 0ms 16 0ms 0ms 0ms 1 0ms insert into t15 (symbolid, pricedatetime, open, high, low, close, volume, bsf, sastdatetimereceived) values (?, ?::timestamp without time zone, ?.?, ?.?, ?.?, ?, ?, ?, ?::timestamp without time zone) on conflict (symbolid, pricedatetime) do nothing;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 30 09 1 0ms 0ms 17 0ms 0ms 0ms 258 0ms with rar_max as ( select resultuid from relevance_fibonacci_results order by resultuid desc limit ? ), 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 = ? 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 ? else ? end as age, case when fr.relevant is not null then fr.relevant when fr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from fr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = fr.symbolid inner join symbols s on fr.symbolid = s.symbolid and s.nonliquid = ? 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 = ? inner join rar_max rm on ? = ? 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 = ? where fr.gmttimefound > now() - interval ? and dss.enabled = ? and s.deleted = ? and (fr.simulation = ? or fr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or fr.pattern in (...)) and (? = ? or fr.patternlengthbars <= ?) and (? = ? or (? = ? and fr.timed > cast(? as timestamp)) or (? = ? and fr.timed < cast(? as timestamp))) ), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 30 09 258 0ms 0ms 18 0ms 0ms 0ms 3 0ms insert into t15 (symbolid, pricedatetime, open, high, low, close, volume, bsf, sastdatetimereceived) values (?, ?::timestamp without time zone, ?.?, ?.?, ?, ?.?, ?, ?, ?::timestamp without time zone) on conflict (symbolid, pricedatetime) do nothing;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 30 09 3 0ms 0ms 19 0ms 0ms 0ms 12 0ms select distinct classname, to_char(created_datetime, ?), to_char(cleared_datetime, ?), action_to_take, description, created_datetime from datafeed_restarter_events where (is_current_entry = ? or cleared_datetime > current_timestamp - interval ?) order by created_datetime desc;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 30 09 12 0ms 0ms 20 0ms 0ms 0ms 16 0ms with max_ra as ( select resultuid from relevance_fibonacci_results order by resultuid desc limit ?) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then ? else ? end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then ? else ? end as age, so.result_uid from max_ra, solr_relevance_old so left outer join relevance_fibonacci_results ra on so.result_uid = ra.resultuid and so.uuid ilike ?) sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike ?; update solr_relevance_old set newrelevant = ? where result_uid in ( select result_uid from solr_relevance_old s left outer join fibonacci_results a on a.resultuid = s.result_uid where s.uuid ilike ? and a.resultuid is null);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 30 09 16 0ms 0ms Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1s326ms 1,896 0ms 10ms 0ms WITH rar_max as ( ;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Dec 30 09 1,896 1s326ms 0ms -
WITH rar_max as ( ;
Date: 2025-12-30 09:10:51 Duration: 10ms Database: postgres
-
WITH rar_max as ( ;
Date: 2025-12-30 09:10:50 Duration: 7ms Database: postgres
-
WITH rar_max as ( ;
Date: 2025-12-30 09:10:51 Duration: 5ms Database: postgres
2 1s104ms 963 0ms 12ms 1ms SELECT symbolid, ;Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 09 963 1s104ms 1ms -
SELECT symbolid, ;
Date: 2025-12-30 09:30:54 Duration: 12ms Database: postgres
-
SELECT symbolid, ;
Date: 2025-12-30 09:30:52 Duration: 8ms Database: postgres
-
SELECT symbolid, ;
Date: 2025-12-30 09:30:54 Duration: 2ms Database: postgres
3 633ms 2,737 0ms 5ms 0ms SELECT ;Times Reported Time consuming prepare #3
Day Hour Count Duration Avg duration 09 2,737 633ms 0ms -
SELECT ;
Date: 2025-12-30 09:35:31 Duration: 5ms Database: postgres
-
SELECT ;
Date: 2025-12-30 09:30:04 Duration: 4ms Database: postgres
-
SELECT ;
Date: 2025-12-30 09:02:23 Duration: 2ms Database: postgres
4 506ms 507 0ms 3ms 0ms SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;Times Reported Time consuming prepare #4
Day Hour Count Duration Avg duration 09 507 506ms 0ms -
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2025-12-30 09:30:53 Duration: 3ms Database: postgres
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2025-12-30 09:30:52 Duration: 1ms Database: postgres
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2025-12-30 09:15:38 Duration: 1ms Database: postgres
5 255ms 3,130 0ms 0ms 0ms INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming prepare #5
Day Hour Count Duration Avg duration 09 3,130 255ms 0ms -
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2025-12-30 09:40:42 Duration: 0ms Database: postgres
-
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2025-12-30 09:30:54 Duration: 0ms Database: postgres
-
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2025-12-30 09:41:56 Duration: 0ms Database: postgres
6 187ms 2,003 0ms 0ms 0ms INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming prepare #6
Day Hour Count Duration Avg duration 09 2,003 187ms 0ms -
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2025-12-30 09:11:56 Duration: 0ms Database: postgres
-
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2025-12-30 09:16:23 Duration: 0ms Database: postgres
-
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2025-12-30 09:01:08 Duration: 0ms Database: postgres
7 172ms 1,382 0ms 0ms 0ms SET extra_float_digits = 3;Times Reported Time consuming prepare #7
Day Hour Count Duration Avg duration 09 1,382 172ms 0ms -
SET extra_float_digits = 3;
Date: 2025-12-30 09:30:05 Duration: 0ms Database: postgres
-
SET extra_float_digits = 3;
Date: 2025-12-30 09:01:13 Duration: 0ms Database: postgres
-
SET extra_float_digits = 3;
Date: 2025-12-30 09:30:04 Duration: 0ms Database: postgres
8 128ms 866 0ms 0ms 0ms INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming prepare #8
Day Hour Count Duration Avg duration 09 866 128ms 0ms -
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2025-12-30 09:55:56 Duration: 0ms Database: postgres
-
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2025-12-30 09:26:55 Duration: 0ms Database: postgres
-
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2025-12-30 09:26:43 Duration: 0ms Database: postgres
9 114ms 740 0ms 0ms 0ms select category, ;Times Reported Time consuming prepare #9
Day Hour Count Duration Avg duration 09 740 114ms 0ms -
select category, ;
Date: 2025-12-30 09:43:24 Duration: 0ms Database: postgres
-
select category, ;
Date: 2025-12-30 09:10:53 Duration: 0ms Database: postgres
-
select category, ;
Date: 2025-12-30 09:10:53 Duration: 0ms Database: postgres
10 50ms 39 0ms 4ms 1ms WITH last_candle AS ( ;Times Reported Time consuming prepare #10
Day Hour Count Duration Avg duration 09 39 50ms 1ms -
WITH last_candle AS ( ;
Date: 2025-12-30 09:02:10 Duration: 4ms Database: postgres
-
WITH last_candle AS ( ;
Date: 2025-12-30 09:32:00 Duration: 3ms Database: postgres
-
WITH last_candle AS ( ;
Date: 2025-12-30 09:16:00 Duration: 3ms Database: postgres
11 40ms 8 4ms 6ms 5ms with sym_info as ( ;Times Reported Time consuming prepare #11
Day Hour Count Duration Avg duration 09 8 40ms 5ms -
with sym_info as ( ;
Date: 2025-12-30 09:36:52 Duration: 6ms Database: postgres
-
with sym_info as ( ;
Date: 2025-12-30 09:06:57 Duration: 6ms Database: postgres
-
with sym_info as ( ;
Date: 2025-12-30 09:36:43 Duration: 4ms Database: postgres
12 40ms 18 1ms 2ms 2ms select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;Times Reported Time consuming prepare #12
Day Hour Count Duration Avg duration 09 18 40ms 2ms -
select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;
Date: 2025-12-30 09:31:01 Duration: 2ms Database: postgres
-
select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;
Date: 2025-12-30 09:41:04 Duration: 2ms Database: postgres
-
select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;
Date: 2025-12-30 09:51:00 Duration: 2ms Database: postgres
13 38ms 894 0ms 1ms 0ms select 1;Times Reported Time consuming prepare #13
Day Hour Count Duration Avg duration 09 894 38ms 0ms -
select 1;
Date: 2025-12-30 09:10:50 Duration: 1ms Database: postgres
-
select 1;
Date: 2025-12-30 09:35:40 Duration: 0ms Database: postgres
-
select 1;
Date: 2025-12-30 09:20:44 Duration: 0ms Database: postgres
14 36ms 244 0ms 0ms 0ms SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'PARTITIONED TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS, '' as TYPE_CAT, '' as TYPE_SCHEM, '' as TYPE_NAME, '' AS SELF_REFERENCING_COL_NAME, '' AS REF_GENERATION FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = 'pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'PROBABLYNOT' AND (false OR (c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME;Times Reported Time consuming prepare #14
Day Hour Count Duration Avg duration 09 244 36ms 0ms -
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'PARTITIONED TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS, '' as TYPE_CAT, '' as TYPE_SCHEM, '' as TYPE_NAME, '' AS SELF_REFERENCING_COL_NAME, '' AS REF_GENERATION FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = 'pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'PROBABLYNOT' AND (false OR (c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME;
Date: 2025-12-30 09:13:18 Duration: 0ms Database: postgres
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'PARTITIONED TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS, '' as TYPE_CAT, '' as TYPE_SCHEM, '' as TYPE_NAME, '' AS SELF_REFERENCING_COL_NAME, '' AS REF_GENERATION FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = 'pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'PROBABLYNOT' AND (false OR (c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME;
Date: 2025-12-30 09:13:18 Duration: 0ms Database: postgres
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'PARTITIONED TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS, '' as TYPE_CAT, '' as TYPE_SCHEM, '' as TYPE_NAME, '' AS SELF_REFERENCING_COL_NAME, '' AS REF_GENERATION FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = 'pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'PROBABLYNOT' AND (false OR (c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME;
Date: 2025-12-30 09:13:18 Duration: 0ms Database: postgres
15 27ms 14 0ms 5ms 1ms with wh_patitioned as ( ;Times Reported Time consuming prepare #15
Day Hour Count Duration Avg duration 09 14 27ms 1ms -
with wh_patitioned as ( ;
Date: 2025-12-30 09:02:10 Duration: 5ms Database: postgres
-
with wh_patitioned as ( ;
Date: 2025-12-30 09:02:23 Duration: 5ms Database: postgres
-
with wh_patitioned as ( ;
Date: 2025-12-30 09:09:32 Duration: 1ms Database: postgres
16 25ms 1,347 0ms 5ms 0ms SET application_name = 'PostgreSQL JDBC Driver';Times Reported Time consuming prepare #16
Day Hour Count Duration Avg duration 09 1,347 25ms 0ms -
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2025-12-30 09:10:51 Duration: 5ms Database: postgres
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2025-12-30 09:10:51 Duration: 4ms Database: postgres
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2025-12-30 09:30:04 Duration: 0ms Database: postgres
17 25ms 40 0ms 1ms 0ms select distinct s.statsid as statsid, sy.exchange as name;Times Reported Time consuming prepare #17
Day Hour Count Duration Avg duration 09 40 25ms 0ms -
select distinct s.statsid as statsid, sy.exchange as name;
Date: 2025-12-30 09:10:52 Duration: 1ms Database: postgres
-
select distinct s.statsid as statsid, sy.exchange as name;
Date: 2025-12-30 09:10:53 Duration: 1ms Database: postgres
-
select distinct s.statsid as statsid, sy.exchange as name;
Date: 2025-12-30 09:10:54 Duration: 1ms Database: postgres
18 16ms 6 2ms 3ms 2ms select client_addr, count(1) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by client_addr, setting having (client_addr is not null OR (client_addr is null and count(1) > (cast(setting as numeric) / 3 * 2))) order by count desc;Times Reported Time consuming prepare #18
Day Hour Count Duration Avg duration 09 6 16ms 2ms -
select client_addr, count(1) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by client_addr, setting having (client_addr is not null OR (client_addr is null and count(1) > (cast(setting as numeric) / 3 * 2))) order by count desc;
Date: 2025-12-30 09:30:05 Duration: 3ms Database: postgres
-
select client_addr, count(1) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by client_addr, setting having (client_addr is not null OR (client_addr is null and count(1) > (cast(setting as numeric) / 3 * 2))) order by count desc;
Date: 2025-12-30 09:50:04 Duration: 3ms Database: postgres
-
select client_addr, count(1) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by client_addr, setting having (client_addr is not null OR (client_addr is null and count(1) > (cast(setting as numeric) / 3 * 2))) order by count desc;
Date: 2025-12-30 09:10:04 Duration: 3ms Database: postgres
19 15ms 12 0ms 2ms 1ms select distinct classname, to_char(created_datetime, 'yyyy-mm-dd HH24:MI'), to_char(cleared_datetime, 'yyyy-mm-dd HH24:MI'), action_to_take, description, created_datetime from datafeed_restarter_events where (is_current_entry = 1 OR cleared_datetime > current_timestamp - interval '17 hour') order by created_datetime desc;Times Reported Time consuming prepare #19
Day Hour Count Duration Avg duration 09 12 15ms 1ms -
select distinct classname, to_char(created_datetime, 'yyyy-mm-dd HH24:MI'), to_char(cleared_datetime, 'yyyy-mm-dd HH24:MI'), action_to_take, description, created_datetime from datafeed_restarter_events where (is_current_entry = 1 OR cleared_datetime > current_timestamp - interval '17 hour') order by created_datetime desc;
Date: 2025-12-30 09:31:21 Duration: 2ms Database: postgres
-
select distinct classname, to_char(created_datetime, 'yyyy-mm-dd HH24:MI'), to_char(cleared_datetime, 'yyyy-mm-dd HH24:MI'), action_to_take, description, created_datetime from datafeed_restarter_events where (is_current_entry = 1 OR cleared_datetime > current_timestamp - interval '17 hour') order by created_datetime desc;
Date: 2025-12-30 09:21:19 Duration: 1ms Database: postgres
-
select distinct classname, to_char(created_datetime, 'yyyy-mm-dd HH24:MI'), to_char(cleared_datetime, 'yyyy-mm-dd HH24:MI'), action_to_take, description, created_datetime from datafeed_restarter_events where (is_current_entry = 1 OR cleared_datetime > current_timestamp - interval '17 hour') order by created_datetime desc;
Date: 2025-12-30 09:01:15 Duration: 1ms Database: postgres
20 13ms 24 0ms 0ms 0ms select count(*) from datafeed_restarter_events where is_current_entry = 1;Times Reported Time consuming prepare #20
Day Hour Count Duration Avg duration 09 24 13ms 0ms -
select count(*) from datafeed_restarter_events where is_current_entry = 1;
Date: 2025-12-30 09:50:02 Duration: 0ms Database: postgres
-
select count(*) from datafeed_restarter_events where is_current_entry = 1;
Date: 2025-12-30 09:05:31 Duration: 0ms Database: postgres
-
select count(*) from datafeed_restarter_events where is_current_entry = 1;
Date: 2025-12-30 09:30:02 Duration: 0ms Database: postgres
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 24s774ms 10,958 0ms 57ms 2ms WITH rar_max as ( ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Dec 30 09 10,958 24s774ms 2ms -
WITH rar_max as ( ;
Date: 2025-12-30 09:10:51 Duration: 57ms Database: postgres parameters: $1 = 't', $2 = '627', $3 = '7', $4 = '15', $5 = '30', $6 = '60', $7 = '120', $8 = '240', $9 = '480', $10 = '1440', $11 = '0', $12 = '', $13 = '213', $14 = '#ADBE', $15 = '#ALVG', $16 = '#AMZN', $17 = '#APPL', $18 = '#BA', $19 = '#BABA', $20 = '#BAYGn', $21 = '#BMWG', $22 = '#BNPP', $23 = '#CAT', $24 = '#CBKG', $25 = '#DAIGn', $26 = '#DIS', $27 = '#EA', $28 = '#FB', $29 = '#FDX', $30 = '#GE', $31 = '#GM', $32 = '#GOOGL', $33 = '#GS', $34 = '#INTC', $35 = '#JPM', $36 = '#KO', $37 = '#META', $38 = '#MSFT', $39 = '#NFLX', $40 = '#TSLA', $41 = '#VOWG', $42 = '#WMT', $43 = '#XOM', $44 = 'AUDCAD', $45 = 'AUDCHF', $46 = 'AUDJPY', $47 = 'AUDNZD', $48 = 'AUDUSD', $49 = 'AUS_200', $50 = 'BTCEUR', $51 = 'BTCGBP', $52 = 'BTCUSD', $53 = 'CADCHF', $54 = 'CADJPY', $55 = 'CHFJPY', $56 = 'CL_BRENT', $57 = 'DASHUSD', $58 = 'EOSUSD', $59 = 'ESP_35', $60 = 'ETHEUR', $61 = 'ETHGBP', $62 = 'ETHUSD', $63 = 'EURAUD', $64 = 'EURCAD', $65 = 'EURCHF', $66 = 'EURGBP', $67 = 'EURJPY', $68 = 'EURMXN', $69 = 'EURNOK', $70 = 'EURNZD', $71 = 'EURPLN', $72 = 'EURSEK', $73 = 'EURTRY', $74 = 'EURUSD', $75 = 'EUR_50', $76 = 'FRA_40', $77 = 'GBPAUD', $78 = 'GBPCAD', $79 = 'GBPCHF', $80 = 'GBPJPY', $81 = 'GBPNZD', $82 = 'GBPUSD', $83 = 'GBPZAR', $84 = 'GBR_100', $85 = 'HKDJPY', $86 = 'HKG_50', $87 = 'IOTAUSD', $88 = 'LTCEUR', $89 = 'LTCUSD', $90 = 'NAS100', $91 = 'NEOUSD', $92 = 'NOKJPY', $93 = 'NZDCAD', $94 = 'NZDCHF', $95 = 'NZDJPY', $96 = 'NZDUSD', $97 = 'OMGUSD', $98 = 'SPX500', $99 = 'TRXUSD', $100 = 'US30', $101 = 'USDCAD', $102 = 'USDCHF', $103 = 'USDCNH', $104 = 'USDDKK', $105 = 'USDJPY', $106 = 'USDMXN', $107 = 'USDNOK', $108 = 'USDPLN', $109 = 'USDSEK', $110 = 'USDSGD', $111 = 'USDZAR', $112 = 'USOIL', $113 = 'XAGUSD', $114 = 'XAUEUR', $115 = 'XAUUSD', $116 = 'XMRUSD', $117 = 'XPTUSD', $118 = 'XRPUSD', $119 = 'ZARJPY', $120 = 'ZECUSD', $121 = 'AUDCAD', $122 = 'AUDCHF', $123 = 'AUDJPY', $124 = 'AUDNZD', $125 = 'AUDUSD', $126 = 'CADCHF', $127 = 'CADJPY', $128 = 'CHFJPY', $129 = 'EURAUD', $130 = 'EURCAD', $131 = 'EURCHF', $132 = 'EURGBP', $133 = 'EURJPY', $134 = 'EURMXN', $135 = 'EURNOK', $136 = 'EURNZD', $137 = 'EURPLN', $138 = 'EURSEK', $139 = 'EURTRY', $140 = 'EURUSD', $141 = 'GBPAUD', $142 = 'GBPCAD', $143 = 'GBPCHF', $144 = 'GBPJPY', $145 = 'GBPNZD', $146 = 'GBPUSD', $147 = 'GBPZAR', $148 = 'HKDJPY', $149 = 'NOKJPY', $150 = 'NZDCAD', $151 = 'NZDCHF', $152 = 'NZDJPY', $153 = 'NZDUSD', $154 = 'USDCAD', $155 = 'USDCHF', $156 = 'USDCNH', $157 = 'USDDKK', $158 = 'USDJPY', $159 = 'USDMXN', $160 = 'USDNOK', $161 = 'USDPLN', $162 = 'USDSEK', $163 = 'USDSGD', $164 = 'USDZAR', $165 = 'ZARJPY', $166 = 'BTCEUR', $167 = 'BTCGBP', $168 = 'BTCUSD', $169 = 'DASHUSD', $170 = 'EOSUSD', $171 = 'ETHEUR', $172 = 'ETHGBP', $173 = 'ETHUSD', $174 = 'IOTAUSD', $175 = 'LTCEUR', $176 = 'LTCUSD', $177 = 'NEOUSD', $178 = 'OMGUSD', $179 = 'TRXUSD', $180 = 'XMRUSD', $181 = 'XRPUSD', $182 = 'ZECUSD', $183 = 'XAGUSD', $184 = 'XAUEUR', $185 = 'XAUUSD', $186 = 'XPTUSD', $187 = 'CL_BRENT', $188 = 'USOIL', $189 = '#ALVG', $190 = '#BAYGn', $191 = '#BMWG', $192 = '#BNPP', $193 = '#CBKG', $194 = '#DAIGn', $195 = '#VOWG', $196 = 'AUS_200', $197 = 'ESP_35', $198 = 'EUR_50', $199 = 'FRA_40', $200 = 'GBR_100', $201 = 'HKG_50', $202 = 'NAS100', $203 = 'SPX500', $204 = 'US30', $205 = '#ADBE', $206 = '#AMZN', $207 = '#APPL', $208 = '#BA', $209 = '#BABA', $210 = '#CAT', $211 = '#DIS', $212 = '#EA', $213 = '#FB', $214 = '#FDX', $215 = '#GE', $216 = '#GM', $217 = '#GOOGL', $218 = '#GS', $219 = '#INTC', $220 = '#JPM', $221 = '#KO', $222 = '#MSFT', $223 = '#NFLX', $224 = '#TSLA', $225 = '#WMT', $226 = '#XOM', $227 = '0', $228 = '', $229 = '0', $230 = '0', $231 = '0', $232 = '700', $233 = '700', $234 = 't', $235 = '10', $236 = '10'
-
WITH rar_max as ( ;
Date: 2025-12-30 09:10:50 Duration: 48ms Database: postgres parameters: $1 = 't', $2 = '627', $3 = '7', $4 = '15', $5 = '30', $6 = '60', $7 = '120', $8 = '240', $9 = '480', $10 = '1440', $11 = '0', $12 = '', $13 = '213', $14 = '#ADBE', $15 = '#ALVG', $16 = '#AMZN', $17 = '#APPL', $18 = '#BA', $19 = '#BABA', $20 = '#BAYGn', $21 = '#BMWG', $22 = '#BNPP', $23 = '#CAT', $24 = '#CBKG', $25 = '#DAIGn', $26 = '#DIS', $27 = '#EA', $28 = '#FB', $29 = '#FDX', $30 = '#GE', $31 = '#GM', $32 = '#GOOGL', $33 = '#GS', $34 = '#INTC', $35 = '#JPM', $36 = '#KO', $37 = '#META', $38 = '#MSFT', $39 = '#NFLX', $40 = '#TSLA', $41 = '#VOWG', $42 = '#WMT', $43 = '#XOM', $44 = 'AUDCAD', $45 = 'AUDCHF', $46 = 'AUDJPY', $47 = 'AUDNZD', $48 = 'AUDUSD', $49 = 'AUS_200', $50 = 'BTCEUR', $51 = 'BTCGBP', $52 = 'BTCUSD', $53 = 'CADCHF', $54 = 'CADJPY', $55 = 'CHFJPY', $56 = 'CL_BRENT', $57 = 'DASHUSD', $58 = 'EOSUSD', $59 = 'ESP_35', $60 = 'ETHEUR', $61 = 'ETHGBP', $62 = 'ETHUSD', $63 = 'EURAUD', $64 = 'EURCAD', $65 = 'EURCHF', $66 = 'EURGBP', $67 = 'EURJPY', $68 = 'EURMXN', $69 = 'EURNOK', $70 = 'EURNZD', $71 = 'EURPLN', $72 = 'EURSEK', $73 = 'EURTRY', $74 = 'EURUSD', $75 = 'EUR_50', $76 = 'FRA_40', $77 = 'GBPAUD', $78 = 'GBPCAD', $79 = 'GBPCHF', $80 = 'GBPJPY', $81 = 'GBPNZD', $82 = 'GBPUSD', $83 = 'GBPZAR', $84 = 'GBR_100', $85 = 'HKDJPY', $86 = 'HKG_50', $87 = 'IOTAUSD', $88 = 'LTCEUR', $89 = 'LTCUSD', $90 = 'NAS100', $91 = 'NEOUSD', $92 = 'NOKJPY', $93 = 'NZDCAD', $94 = 'NZDCHF', $95 = 'NZDJPY', $96 = 'NZDUSD', $97 = 'OMGUSD', $98 = 'SPX500', $99 = 'TRXUSD', $100 = 'US30', $101 = 'USDCAD', $102 = 'USDCHF', $103 = 'USDCNH', $104 = 'USDDKK', $105 = 'USDJPY', $106 = 'USDMXN', $107 = 'USDNOK', $108 = 'USDPLN', $109 = 'USDSEK', $110 = 'USDSGD', $111 = 'USDZAR', $112 = 'USOIL', $113 = 'XAGUSD', $114 = 'XAUEUR', $115 = 'XAUUSD', $116 = 'XMRUSD', $117 = 'XPTUSD', $118 = 'XRPUSD', $119 = 'ZARJPY', $120 = 'ZECUSD', $121 = 'AUDCAD', $122 = 'AUDCHF', $123 = 'AUDJPY', $124 = 'AUDNZD', $125 = 'AUDUSD', $126 = 'CADCHF', $127 = 'CADJPY', $128 = 'CHFJPY', $129 = 'EURAUD', $130 = 'EURCAD', $131 = 'EURCHF', $132 = 'EURGBP', $133 = 'EURJPY', $134 = 'EURMXN', $135 = 'EURNOK', $136 = 'EURNZD', $137 = 'EURPLN', $138 = 'EURSEK', $139 = 'EURTRY', $140 = 'EURUSD', $141 = 'GBPAUD', $142 = 'GBPCAD', $143 = 'GBPCHF', $144 = 'GBPJPY', $145 = 'GBPNZD', $146 = 'GBPUSD', $147 = 'GBPZAR', $148 = 'HKDJPY', $149 = 'NOKJPY', $150 = 'NZDCAD', $151 = 'NZDCHF', $152 = 'NZDJPY', $153 = 'NZDUSD', $154 = 'USDCAD', $155 = 'USDCHF', $156 = 'USDCNH', $157 = 'USDDKK', $158 = 'USDJPY', $159 = 'USDMXN', $160 = 'USDNOK', $161 = 'USDPLN', $162 = 'USDSEK', $163 = 'USDSGD', $164 = 'USDZAR', $165 = 'ZARJPY', $166 = 'BTCEUR', $167 = 'BTCGBP', $168 = 'BTCUSD', $169 = 'DASHUSD', $170 = 'EOSUSD', $171 = 'ETHEUR', $172 = 'ETHGBP', $173 = 'ETHUSD', $174 = 'IOTAUSD', $175 = 'LTCEUR', $176 = 'LTCUSD', $177 = 'NEOUSD', $178 = 'OMGUSD', $179 = 'TRXUSD', $180 = 'XMRUSD', $181 = 'XRPUSD', $182 = 'ZECUSD', $183 = 'XAGUSD', $184 = 'XAUEUR', $185 = 'XAUUSD', $186 = 'XPTUSD', $187 = 'CL_BRENT', $188 = 'USOIL', $189 = '#ALVG', $190 = '#BAYGn', $191 = '#BMWG', $192 = '#BNPP', $193 = '#CBKG', $194 = '#DAIGn', $195 = '#VOWG', $196 = 'AUS_200', $197 = 'ESP_35', $198 = 'EUR_50', $199 = 'FRA_40', $200 = 'GBR_100', $201 = 'HKG_50', $202 = 'NAS100', $203 = 'SPX500', $204 = 'US30', $205 = '#ADBE', $206 = '#AMZN', $207 = '#APPL', $208 = '#BA', $209 = '#BABA', $210 = '#CAT', $211 = '#DIS', $212 = '#EA', $213 = '#FB', $214 = '#FDX', $215 = '#GE', $216 = '#GM', $217 = '#GOOGL', $218 = '#GS', $219 = '#INTC', $220 = '#JPM', $221 = '#KO', $222 = '#MSFT', $223 = '#NFLX', $224 = '#TSLA', $225 = '#WMT', $226 = '#XOM', $227 = '0', $228 = '', $229 = '0', $230 = '0', $231 = '0', $232 = '700', $233 = '700', $234 = 't', $235 = '10', $236 = '10'
-
WITH rar_max as ( ;
Date: 2025-12-30 09:01:26 Duration: 48ms Database: postgres parameters: $1 = 't', $2 = '667', $3 = '7', $4 = '15', $5 = '30', $6 = '60', $7 = '120', $8 = '240', $9 = '480', $10 = '1440', $11 = '0', $12 = '', $13 = '84', $14 = 'AUDCAD', $15 = 'AUDCHF', $16 = 'AUDJPY', $17 = 'AUDNZD', $18 = 'AUDSGD', $19 = 'CADCHF', $20 = 'CADJPY', $21 = 'CHFJPY', $22 = 'EURAUD', $23 = 'EURCAD', $24 = 'EURCHF', $25 = 'EURCZK', $26 = 'EURGBP', $27 = 'EURHUF', $28 = 'EURJPY', $29 = 'EURNOK', $30 = 'EURNZD', $31 = 'EURPLN', $32 = 'EURSEK', $33 = 'EURSGD', $34 = 'EURTRY', $35 = 'EURZAR', $36 = 'GBPAUD', $37 = 'GBPCAD', $38 = 'GBPCHF', $39 = 'GBPJPY', $40 = 'GBPNZD', $41 = 'GBPPLN', $42 = 'GBPSEK', $43 = 'GBPSGD', $44 = 'NZDCAD', $45 = 'NZDCHF', $46 = 'NZDJPY', $47 = 'NZDSGD', $48 = 'USDCNH', $49 = 'USDCZK', $50 = 'USDHUF', $51 = 'USDNOK', $52 = 'USDPLN', $53 = 'USDSEK', $54 = 'USDSGD', $55 = 'USDTRY', $56 = 'USDZAR', $57 = 'WTI', $58 = 'XBRUSD', $59 = 'XTIUSD', $60 = 'BTCUSD', $61 = 'XAGAUD', $62 = 'XAGUSD', $63 = 'XAUAUD', $64 = 'XAUUSD', $65 = 'XPTUSD', $66 = 'XPDUSD', $67 = 'AUDUSD', $68 = 'EURUSD', $69 = 'GBPUSD', $70 = 'NZDUSD', $71 = 'USDCAD', $72 = 'USDCHF', $73 = 'USDHKD', $74 = 'USDJPY', $75 = 'AUS200', $76 = 'CHINA300', $77 = 'CHINA50', $78 = 'DJ30', $79 = 'ESP35t', $80 = 'EUR50', $81 = 'EURO50', $82 = 'FRA40', $83 = 'GDAXI', $84 = 'GDAXIm', $85 = 'HK50', $86 = 'ITA40', $87 = 'J225', $88 = 'JP225', $89 = 'NAS100', $90 = 'SING30', $91 = 'SPA35', $92 = 'STOXX50', $93 = 'SUI20', $94 = 'UK100', $95 = 'US100', $96 = 'US30', $97 = 'US500', $98 = '0', $99 = '', $100 = '700', $101 = '700', $102 = '0', $103 = '0', $104 = '0', $105 = 't', $106 = '10', $107 = '10'
2 9s562ms 27,113 0ms 13ms 0ms SELECT ;Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 09 27,113 9s562ms 0ms -
SELECT ;
Date: 2025-12-30 09:30:04 Duration: 13ms Database: postgres parameters: $1 = '558', $2 = '0', $3 = '0', $4 = 'AUDJPY', $5 = 'AUDJPY'
-
SELECT ;
Date: 2025-12-30 09:30:05 Duration: 13ms Database: postgres parameters: $1 = '558', $2 = '0', $3 = '0', $4 = 'USDNOK', $5 = 'USDNOK'
-
SELECT ;
Date: 2025-12-30 09:00:05 Duration: 11ms Database: postgres parameters: $1 = '667', $2 = '0', $3 = '0', $4 = 'BTCUSD', $5 = 'BTCUSD'
3 2s55ms 963 0ms 4ms 2ms SELECT symbolid, ;Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 09 963 2s55ms 2ms -
SELECT symbolid, ;
Date: 2025-12-30 09:45:40 Duration: 4ms Database: postgres parameters: $1 = 'ICMARKETS-AU-MT5', $2 = '15', $3 = 'USDMXN', $4 = 'USTEC', $5 = 'USDDKK', $6 = 'USDHKD', $7 = 'USDTRY', $8 = 'USDHUF', $9 = 'USDSEK', $10 = 'USDJPY', $11 = 'USDPLN', $12 = 'USDCZK', $13 = 'USDTHB', $14 = 'USDSGD', $15 = 'USDZAR', $16 = 'USDNOK'
-
SELECT symbolid, ;
Date: 2025-12-30 09:30:54 Duration: 4ms Database: postgres parameters: $1 = 'PEPPERSTONE', $2 = '15', $3 = 'GBPMXN', $4 = 'GBPSGD', $5 = 'GBPTRY', $6 = 'GER40', $7 = 'GBPNOK', $8 = 'GBPSEK', $9 = 'GBPNZD', $10 = 'GBPUSD'
-
SELECT symbolid, ;
Date: 2025-12-30 09:45:37 Duration: 4ms Database: postgres parameters: $1 = 'MILLENNIUMPF', $2 = '15', $3 = 'XAUUSD.FX'
4 1s277ms 189 0ms 27ms 6ms select distinct s.statsid as statsid, sy.exchange as name;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 09 189 1s277ms 6ms -
select distinct s.statsid as statsid, sy.exchange as name;
Date: 2025-12-30 09:00:43 Duration: 27ms Database: postgres parameters: $1 = '489', $2 = '489'
-
select distinct s.statsid as statsid, sy.exchange as name;
Date: 2025-12-30 09:00:43 Duration: 22ms Database: postgres parameters: $1 = '489', $2 = '489'
-
select distinct s.statsid as statsid, sy.exchange as name;
Date: 2025-12-30 09:10:52 Duration: 21ms Database: postgres parameters: $1 = '489', $2 = '489'
5 844ms 507 1ms 3ms 1ms SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 09 507 844ms 1ms -
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2025-12-30 09:30:51 Duration: 3ms Database: postgres parameters: $1 = 'DXFEED_FX'
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2025-12-30 09:30:53 Duration: 3ms Database: postgres parameters: $1 = 'AXIORY'
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2025-12-30 09:00:05 Duration: 2ms Database: postgres parameters: $1 = 'HOTFOREX'
6 687ms 8,854 0ms 1ms 0ms select category, ;Times Reported Time consuming bind #6
Day Hour Count Duration Avg duration 09 8,854 687ms 0ms -
select category, ;
Date: 2025-12-30 09:59:17 Duration: 1ms Database: postgres parameters: $1 = '515852059324736307', $2 = 'symbol', $3 = 'USDMXN', $4 = 'AUDJPY', $5 = 'CHFZAR', $6 = 'CADJPY', $7 = 'USDZAR', $8 = 'ZARJPY', $9 = 'CHFJPY', $10 = 'NZDJPY', $11 = 'USDJPY', $12 = 'AUDZAR', $13 = 'USDHUF', $14 = 'GBPJPY', $15 = 'TRYJPY', $16 = 'EURCNH', $17 = 'EURMXN', $18 = 'GBPZAR', $19 = 'EURNOK', $20 = 'EURHKD', $21 = 'SGDJPY', $22 = 'USDCZK', $23 = 'EURJPY', $24 = 'USDNOK', $25 = 'EURSEK', $26 = 'CHFHUF', $27 = 'EURZAR', $28 = 'NZDSEK', $29 = 'USDDKK', $30 = 'USDSEK', $31 = 'EURTRY', $32 = 'USDPLN', $33 = 'EURHUF', $34 = 'EURCZK', $35 = 'USDCNH', $36 = 'GBPNZD', $37 = 'USDILS', $38 = 'EURPLN', $39 = 'TRYJPY', $40 = 'EURCZK', $41 = 'EURNZD', $42 = 'EURGBP', $43 = 'CHFHUF', $44 = 'GBPAUD', $45 = 'GBPCAD', $46 = 'EURHUF', $47 = 'EURAUD', $48 = 'ZARJPY', $49 = 'USDZAR', $50 = 'GBPCAD', $51 = 'EURCAD', $52 = 'USDCAD', $53 = '515852059324736307', $54 = 'symbol', $55 = 'USDMXN', $56 = 'AUDJPY', $57 = 'CHFZAR', $58 = 'CADJPY', $59 = 'USDZAR', $60 = 'ZARJPY', $61 = 'CHFJPY', $62 = 'NZDJPY', $63 = 'USDJPY', $64 = 'AUDZAR', $65 = 'USDHUF', $66 = 'GBPJPY', $67 = 'TRYJPY', $68 = 'EURCNH', $69 = 'EURMXN', $70 = 'GBPZAR', $71 = 'EURNOK', $72 = 'EURHKD', $73 = 'SGDJPY', $74 = 'USDCZK', $75 = 'EURJPY', $76 = 'USDNOK', $77 = 'EURSEK', $78 = 'CHFHUF', $79 = 'EURZAR', $80 = 'NZDSEK', $81 = 'USDDKK', $82 = 'USDSEK', $83 = 'EURTRY', $84 = 'USDPLN', $85 = 'EURHUF', $86 = 'EURCZK', $87 = 'USDCNH', $88 = 'GBPNZD', $89 = 'USDILS', $90 = 'EURPLN', $91 = 'TRYJPY', $92 = 'EURCZK', $93 = 'EURNZD', $94 = 'EURGBP', $95 = 'CHFHUF', $96 = 'GBPAUD', $97 = 'GBPCAD', $98 = 'EURHUF', $99 = 'EURAUD', $100 = 'ZARJPY', $101 = 'USDZAR', $102 = 'GBPCAD', $103 = 'EURCAD', $104 = 'USDCAD'
-
select category, ;
Date: 2025-12-30 09:50:59 Duration: 1ms Database: postgres parameters: $1 = '515852059313898307', $2 = 'symbol', $3 = 'BTCUSD', $4 = 'AUDJPY', $5 = 'USDMXN', $6 = 'USDZAR', $7 = 'CADJPY', $8 = 'GBPJPY', $9 = 'USDJPY', $10 = 'USDTHB', $11 = 'NZDJPY', $12 = 'USDHUF', $13 = 'EURZAR', $14 = 'CHFJPY', $15 = 'EURJPY', $16 = 'SGDJPY', $17 = 'SEKJPY', $18 = 'EURTRY', $19 = 'EURHKD', $20 = 'USDSEK', $21 = 'NOKJPY', $22 = 'EURNOK', $23 = 'USDCZK', $24 = 'USDNOK', $25 = 'USDPLN', $26 = 'EURSEK', $27 = 'USDDKK', $28 = 'GBPSEK', $29 = 'GBPDKK', $30 = 'GBPNOK', $31 = 'BTCUSD', $32 = 'GBPAUD', $33 = 'EURPLN', $34 = 'GBPNZD', $35 = 'EURAUD', $36 = 'EURNZD', $37 = 'USDCNH', $38 = 'USDTRY', $39 = 'GBPCAD', $40 = 'EURGBP', $41 = 'GBPNOK', $42 = 'USDZAR', $43 = 'USDHUF', $44 = 'SEKJPY', $45 = 'EURCAD', $46 = 'GBPSGD', $47 = 'GBPCAD', $48 = 'USDCAD', $49 = 'GBPUSD', $50 = 'USDSGD', $51 = 'EURNOK', $52 = 'NOKJPY', $53 = '515852059313898307', $54 = 'symbol', $55 = 'BTCUSD', $56 = 'AUDJPY', $57 = 'USDMXN', $58 = 'USDZAR', $59 = 'CADJPY', $60 = 'GBPJPY', $61 = 'USDJPY', $62 = 'USDTHB', $63 = 'NZDJPY', $64 = 'USDHUF', $65 = 'EURZAR', $66 = 'CHFJPY', $67 = 'EURJPY', $68 = 'SGDJPY', $69 = 'SEKJPY', $70 = 'EURTRY', $71 = 'EURHKD', $72 = 'USDSEK', $73 = 'NOKJPY', $74 = 'EURNOK', $75 = 'USDCZK', $76 = 'USDNOK', $77 = 'USDPLN', $78 = 'EURSEK', $79 = 'USDDKK', $80 = 'GBPSEK', $81 = 'GBPDKK', $82 = 'GBPNOK', $83 = 'BTCUSD', $84 = 'GBPAUD', $85 = 'EURPLN', $86 = 'GBPNZD', $87 = 'EURAUD', $88 = 'EURNZD', $89 = 'USDCNH', $90 = 'USDTRY', $91 = 'GBPCAD', $92 = 'EURGBP', $93 = 'GBPNOK', $94 = 'USDZAR', $95 = 'USDHUF', $96 = 'SEKJPY', $97 = 'EURCAD', $98 = 'GBPSGD', $99 = 'GBPCAD', $100 = 'USDCAD', $101 = 'GBPUSD', $102 = 'USDSGD', $103 = 'EURNOK', $104 = 'NOKJPY'
-
select category, ;
Date: 2025-12-30 09:50:45 Duration: 1ms Database: postgres parameters: $1 = '515852059305993307', $2 = 'symbol', $3 = 'XAGEUR', $4 = 'XAUUSD', $5 = 'UK100', $6 = 'XNGUSD', $7 = 'XTIUSD', $8 = 'US2000', $9 = 'XAGUSD', $10 = 'JP225', $11 = 'US30', $12 = 'XBRUSD', $13 = 'XAUEUR', $14 = 'US500', $15 = 'XPTUSD', $16 = 'USTEC', $17 = 'AUS200', $18 = 'XPDUSD', $19 = 'F40', $20 = 'CHINA50', $21 = 'STOXX50', $22 = 'US2000', $23 = 'HK50', $24 = 'IT40', $25 = 'XNGUSD', $26 = 'XPDUSD', $27 = 'XAGUSD', $28 = 'XTIUSD', $29 = 'XAGEUR', $30 = 'UK100', $31 = 'XBRUSD', $32 = 'XAUEUR', $33 = 'US500', $34 = 'XPTUSD', $35 = 'XAUUSD', $36 = 'AUS200', $37 = 'JP225', $38 = 'US30', $39 = 'USTEC', $40 = 'CHINA50', $41 = 'ES35', $42 = 'STOXX50', $43 = 'F40', $44 = 'HK50', $45 = 'IT40', $46 = 'ES35', $47 = '515852059305993307', $48 = 'symbol', $49 = 'XAGEUR', $50 = 'XAUUSD', $51 = 'UK100', $52 = 'XNGUSD', $53 = 'XTIUSD', $54 = 'US2000', $55 = 'XAGUSD', $56 = 'JP225', $57 = 'US30', $58 = 'XBRUSD', $59 = 'XAUEUR', $60 = 'US500', $61 = 'XPTUSD', $62 = 'USTEC', $63 = 'AUS200', $64 = 'XPDUSD', $65 = 'F40', $66 = 'CHINA50', $67 = 'STOXX50', $68 = 'US2000', $69 = 'HK50', $70 = 'IT40', $71 = 'XNGUSD', $72 = 'XPDUSD', $73 = 'XAGUSD', $74 = 'XTIUSD', $75 = 'XAGEUR', $76 = 'UK100', $77 = 'XBRUSD', $78 = 'XAUEUR', $79 = 'US500', $80 = 'XPTUSD', $81 = 'XAUUSD', $82 = 'AUS200', $83 = 'JP225', $84 = 'US30', $85 = 'USTEC', $86 = 'CHINA50', $87 = 'ES35', $88 = 'STOXX50', $89 = 'F40', $90 = 'HK50', $91 = 'IT40', $92 = 'ES35'
7 623ms 40,139 0ms 8ms 0ms select 1;Times Reported Time consuming bind #7
Day Hour Count Duration Avg duration 09 40,139 623ms 0ms -
select 1;
Date: 2025-12-30 09:35:40 Duration: 8ms Database: postgres
-
select 1;
Date: 2025-12-30 09:02:23 Duration: 2ms Database: postgres
-
select 1;
Date: 2025-12-30 09:35:40 Duration: 1ms Database: postgres
8 580ms 21 17ms 54ms 27ms with wh_patitioned as ( ;Times Reported Time consuming bind #8
Day Hour Count Duration Avg duration 09 21 580ms 27ms -
with wh_patitioned as ( ;
Date: 2025-12-30 09:02:10 Duration: 54ms Database: postgres parameters: $1 = '558', $2 = '558', $3 = '558', $4 = '558', $5 = '558', $6 = '558', $7 = '558', $8 = '558', $9 = '558'
-
with wh_patitioned as ( ;
Date: 2025-12-30 09:02:23 Duration: 53ms Database: postgres parameters: $1 = '558', $2 = '558', $3 = '558', $4 = '558', $5 = '558', $6 = '558', $7 = '558', $8 = '558', $9 = '558'
-
with wh_patitioned as ( ;
Date: 2025-12-30 09:31:35 Duration: 40ms Database: postgres parameters: $1 = '558', $2 = '558', $3 = '558', $4 = '558', $5 = '558', $6 = '558', $7 = '558', $8 = '558', $9 = '558'
9 368ms 49 4ms 14ms 7ms WITH last_candle AS ( ;Times Reported Time consuming bind #9
Day Hour Count Duration Avg duration 09 49 368ms 7ms -
WITH last_candle AS ( ;
Date: 2025-12-30 09:02:10 Duration: 14ms Database: postgres parameters: $1 = '558', $2 = '558'
-
WITH last_candle AS ( ;
Date: 2025-12-30 09:32:00 Duration: 12ms Database: postgres parameters: $1 = '558', $2 = '558'
-
WITH last_candle AS ( ;
Date: 2025-12-30 09:32:00 Duration: 12ms Database: postgres parameters: $1 = '558', $2 = '558'
10 346ms 30 0ms 19ms 11ms WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;Times Reported Time consuming bind #10
Day Hour Count Duration Avg duration 09 30 346ms 11ms -
WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;
Date: 2025-12-30 09:36:25 Duration: 19ms Database: postgres parameters: $1 = '689', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'
-
WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;
Date: 2025-12-30 09:30:56 Duration: 19ms Database: postgres parameters: $1 = '689', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'
-
WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;
Date: 2025-12-30 09:30:55 Duration: 19ms Database: postgres parameters: $1 = '689', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'
11 324ms 466 0ms 1ms 0ms SELECT absolutetimezoneoffset;Times Reported Time consuming bind #11
Day Hour Count Duration Avg duration 09 466 324ms 0ms -
SELECT absolutetimezoneoffset;
Date: 2025-12-30 09:01:16 Duration: 1ms Database: postgres parameters: $1 = '932', $2 = 'Commodities'
-
SELECT absolutetimezoneoffset;
Date: 2025-12-30 09:01:13 Duration: 1ms Database: postgres parameters: $1 = '914', $2 = 'Metals'
-
SELECT absolutetimezoneoffset;
Date: 2025-12-30 09:01:16 Duration: 1ms Database: postgres parameters: $1 = '932', $2 = 'Forex'
12 241ms 8 28ms 34ms 30ms with sym_info as ( ;Times Reported Time consuming bind #12
Day Hour Count Duration Avg duration 09 8 241ms 30ms -
with sym_info as ( ;
Date: 2025-12-30 09:06:57 Duration: 34ms Database: postgres parameters: $1 = '692', $2 = 'Forex', $3 = 'Forex', $4 = '692', $5 = 'Forex', $6 = '692', $7 = '692', $8 = 'Forex', $9 = '692'
-
with sym_info as ( ;
Date: 2025-12-30 09:36:52 Duration: 34ms Database: postgres parameters: $1 = '627', $2 = 'Forex', $3 = 'Forex', $4 = '627', $5 = 'Forex', $6 = '627', $7 = '627', $8 = 'Forex', $9 = '627'
-
with sym_info as ( ;
Date: 2025-12-30 09:06:43 Duration: 29ms Database: postgres parameters: $1 = '620', $2 = 'Forex', $3 = 'Forex', $4 = '620', $5 = 'Forex', $6 = '620', $7 = '620', $8 = 'Forex', $9 = '620'
13 240ms 5,779 0ms 0ms 0ms INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming bind #13
Day Hour Count Duration Avg duration 09 5,779 240ms 0ms -
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2025-12-30 09:55:56 Duration: 0ms Database: postgres parameters: $1 = '2025-12-30 09:15:00', $2 = '25489.3', $3 = '25489.3', $4 = '25469.3', $5 = '25471.17', $6 = '2458', $7 = '515840248038958300', $8 = '0', $9 = '2025-12-30 09:55:56.975', $10 = '2025-12-30 09:55:56.906', $11 = '25489.3', $12 = '25489.3', $13 = '25469.3', $14 = '25471.17', $15 = '2458', $16 = '0', $17 = '2025-12-30 09:55:56.975', $18 = '2025-12-30 09:55:56.906'
-
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2025-12-30 09:26:55 Duration: 0ms Database: postgres parameters: $1 = '2025-12-30 09:00:00', $2 = '25498.92', $3 = '25501.92', $4 = '25488.3', $5 = '25488.92', $6 = '1603', $7 = '515840248038958300', $8 = '0', $9 = '2025-12-30 09:26:55.344', $10 = '2025-12-30 09:26:55.275', $11 = '25498.92', $12 = '25501.92', $13 = '25488.3', $14 = '25488.92', $15 = '1603', $16 = '0', $17 = '2025-12-30 09:26:55.344', $18 = '2025-12-30 09:26:55.275'
-
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2025-12-30 09:26:43 Duration: 0ms Database: postgres parameters: $1 = '2025-12-30 09:00:00', $2 = '8709.9', $3 = '8711.9', $4 = '8701.9', $5 = '8702.6', $6 = '519', $7 = '515840248015086300', $8 = '0', $9 = '2025-12-30 09:26:43.249', $10 = '2025-12-30 09:26:43.179', $11 = '8709.9', $12 = '8711.9', $13 = '8701.9', $14 = '8702.6', $15 = '519', $16 = '0', $17 = '2025-12-30 09:26:43.249', $18 = '2025-12-30 09:26:43.179'
14 230ms 3,287 0ms 0ms 0ms INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming bind #14
Day Hour Count Duration Avg duration 09 3,287 230ms 0ms -
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2025-12-30 09:15:39 Duration: 0ms Database: postgres parameters: $1 = '2025-12-30 08:30:00', $2 = '50407.5', $3 = '50442.5', $4 = '50370.5', $5 = '50407.5', $6 = '293', $7 = '515840245921466300', $8 = '0', $9 = '2025-12-30 09:15:39.179', $10 = '2025-12-30 09:15:39.08', $11 = '50407.5', $12 = '50442.5', $13 = '50370.5', $14 = '50407.5', $15 = '293', $16 = '0', $17 = '2025-12-30 09:15:39.179', $18 = '2025-12-30 09:15:39.08'
-
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2025-12-30 09:40:42 Duration: 0ms Database: postgres parameters: $1 = '2025-12-30 08:30:00', $2 = '8713.4', $3 = '8714.55', $4 = '8707.4', $5 = '8710', $6 = '621', $7 = '515840248015340300', $8 = '0', $9 = '2025-12-30 09:40:42.127', $10 = '2025-12-30 09:40:42.043', $11 = '8713.4', $12 = '8714.55', $13 = '8707.4', $14 = '8710', $15 = '621', $16 = '0', $17 = '2025-12-30 09:40:42.127', $18 = '2025-12-30 09:40:42.043'
-
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2025-12-30 09:15:39 Duration: 0ms Database: postgres parameters: $1 = '2025-12-30 09:30:00', $2 = '0.1232295', $3 = '0.123615', $4 = '0.123185', $5 = '0.1233095', $6 = '1464', $7 = '515840249471412300', $8 = '0', $9 = '2025-12-30 09:15:39.179', $10 = '2025-12-30 09:15:39.17', $11 = '0.1232295', $12 = '0.123615', $13 = '0.123185', $14 = '0.1233095', $15 = '1464', $16 = '0', $17 = '2025-12-30 09:15:39.179', $18 = '2025-12-30 09:15:39.17'
15 165ms 2,167 0ms 0ms 0ms INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming bind #15
Day Hour Count Duration Avg duration 09 2,167 165ms 0ms -
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2025-12-30 09:02:25 Duration: 0ms Database: postgres parameters: $1 = '2025-12-29 22:00:00', $2 = '233.725', $3 = '234.925', $4 = '233.34', $5 = '233.745', $6 = '1519', $7 = '515840249423562300', $8 = '0', $9 = '2025-12-30 09:02:25.914', $10 = '2025-12-30 09:02:25.913', $11 = '233.725', $12 = '234.925', $13 = '233.34', $14 = '233.745', $15 = '1519', $16 = '0', $17 = '2025-12-30 09:02:25.914', $18 = '2025-12-30 09:02:25.913'
-
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2025-12-30 09:15:39 Duration: 0ms Database: postgres parameters: $1 = '2025-12-30 08:00:00', $2 = '50398', $3 = '50442.5', $4 = '50320.5', $5 = '50407.5', $6 = '1104', $7 = '515840245921646300', $8 = '0', $9 = '2025-12-30 09:15:39.174', $10 = '2025-12-30 09:15:39.174', $11 = '50398', $12 = '50442.5', $13 = '50320.5', $14 = '50407.5', $15 = '1104', $16 = '0', $17 = '2025-12-30 09:15:39.175', $18 = '2025-12-30 09:15:39.174'
-
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2025-12-30 09:01:08 Duration: 0ms Database: postgres parameters: $1 = '2025-12-30 08:00:00', $2 = '1.15425', $3 = '1.15467', $4 = '1.154', $5 = '1.15459', $6 = '3434', $7 = '515840230431131300', $8 = '0', $9 = '2025-12-30 09:01:08.877', $10 = '2025-12-30 09:01:08.876', $11 = '1.15425', $12 = '1.15467', $13 = '1.154', $14 = '1.15459', $15 = '3434', $16 = '0', $17 = '2025-12-30 09:01:08.877', $18 = '2025-12-30 09:01:08.876'
16 91ms 244 0ms 1ms 0ms SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'PARTITIONED TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS, '' as TYPE_CAT, '' as TYPE_SCHEM, '' as TYPE_NAME, '' AS SELF_REFERENCING_COL_NAME, '' AS REF_GENERATION FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = 'pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'PROBABLYNOT' AND (false OR (c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME;Times Reported Time consuming bind #16
Day Hour Count Duration Avg duration 09 244 91ms 0ms -
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'PARTITIONED TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS, '' as TYPE_CAT, '' as TYPE_SCHEM, '' as TYPE_NAME, '' AS SELF_REFERENCING_COL_NAME, '' AS REF_GENERATION FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = 'pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'PROBABLYNOT' AND (false OR (c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME;
Date: 2025-12-30 09:13:18 Duration: 1ms Database: postgres
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'PARTITIONED TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS, '' as TYPE_CAT, '' as TYPE_SCHEM, '' as TYPE_NAME, '' AS SELF_REFERENCING_COL_NAME, '' AS REF_GENERATION FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = 'pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'PROBABLYNOT' AND (false OR (c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME;
Date: 2025-12-30 09:13:18 Duration: 0ms Database: postgres
-
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'PARTITIONED TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS, '' as TYPE_CAT, '' as TYPE_SCHEM, '' as TYPE_NAME, '' AS SELF_REFERENCING_COL_NAME, '' AS REF_GENERATION FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = 'pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'PROBABLYNOT' AND (false OR (c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME;
Date: 2025-12-30 09:13:18 Duration: 0ms Database: postgres
17 80ms 14 3ms 9ms 5ms SELECT DISTINCT ON (basegroupname, symbol) ;Times Reported Time consuming bind #17
Day Hour Count Duration Avg duration 09 14 80ms 5ms -
SELECT DISTINCT ON (basegroupname, symbol) ;
Date: 2025-12-30 09:10:50 Duration: 9ms Database: postgres parameters: $1 = '627', $2 = '627'
-
SELECT DISTINCT ON (basegroupname, symbol) ;
Date: 2025-12-30 09:10:50 Duration: 9ms Database: postgres parameters: $1 = '627', $2 = '627'
-
SELECT DISTINCT ON (basegroupname, symbol) ;
Date: 2025-12-30 09:10:51 Duration: 7ms Database: postgres parameters: $1 = '958', $2 = '958'
18 64ms 76 0ms 1ms 0ms SELECT timegranularity FROM brokersymbollist bsl INNER JOIN symbols s ON bsl.symbolid = s.symbolid INNER JOIN downloadersymbolsettings dss on s.symbolid = dss.symbolid LEFT OUTER JOIN brokerinstrumentmapping bdfi ON bdfi.brokerid = $1 AND dss.datafeedinstrumentid = bdfi.datafeedinstrumentid WHERE s.nonliquid = 0 and s.deleted = 0 and dss.enabled = 1 AND s.symbol ILIKE $2 AND bsl.brokerid = $3 AND timegranularity >= 15 ORDER BY timegranularity LIMIT 1;Times Reported Time consuming bind #18
Day Hour Count Duration Avg duration 09 76 64ms 0ms -
SELECT timegranularity FROM brokersymbollist bsl INNER JOIN symbols s ON bsl.symbolid = s.symbolid INNER JOIN downloadersymbolsettings dss on s.symbolid = dss.symbolid LEFT OUTER JOIN brokerinstrumentmapping bdfi ON bdfi.brokerid = $1 AND dss.datafeedinstrumentid = bdfi.datafeedinstrumentid WHERE s.nonliquid = 0 and s.deleted = 0 and dss.enabled = 1 AND s.symbol ILIKE $2 AND bsl.brokerid = $3 AND timegranularity >= 15 ORDER BY timegranularity LIMIT 1;
Date: 2025-12-30 09:05:34 Duration: 1ms Database: postgres parameters: $1 = '558', $2 = 'JP225', $3 = '558'
-
SELECT timegranularity FROM brokersymbollist bsl INNER JOIN symbols s ON bsl.symbolid = s.symbolid INNER JOIN downloadersymbolsettings dss on s.symbolid = dss.symbolid LEFT OUTER JOIN brokerinstrumentmapping bdfi ON bdfi.brokerid = $1 AND dss.datafeedinstrumentid = bdfi.datafeedinstrumentid WHERE s.nonliquid = 0 and s.deleted = 0 and dss.enabled = 1 AND s.symbol ILIKE $2 AND bsl.brokerid = $3 AND timegranularity >= 15 ORDER BY timegranularity LIMIT 1;
Date: 2025-12-30 09:46:07 Duration: 1ms Database: postgres parameters: $1 = '689', $2 = 'XAUUSD', $3 = '689'
-
SELECT timegranularity FROM brokersymbollist bsl INNER JOIN symbols s ON bsl.symbolid = s.symbolid INNER JOIN downloadersymbolsettings dss on s.symbolid = dss.symbolid LEFT OUTER JOIN brokerinstrumentmapping bdfi ON bdfi.brokerid = $1 AND dss.datafeedinstrumentid = bdfi.datafeedinstrumentid WHERE s.nonliquid = 0 and s.deleted = 0 and dss.enabled = 1 AND s.symbol ILIKE $2 AND bsl.brokerid = $3 AND timegranularity >= 15 ORDER BY timegranularity LIMIT 1;
Date: 2025-12-30 09:09:04 Duration: 1ms Database: postgres parameters: $1 = '558', $2 = 'USDSGD', $3 = '558'
19 46ms 932 0ms 0ms 0ms select distinct category;Times Reported Time consuming bind #19
Day Hour Count Duration Avg duration 09 932 46ms 0ms -
select distinct category;
Date: 2025-12-30 09:43:24 Duration: 0ms Database: postgres parameters: $1 = '515852059317765307'
-
select distinct category;
Date: 2025-12-30 09:10:54 Duration: 0ms Database: postgres parameters: $1 = '601729875347685307', $2 = '601729875347685307'
-
select distinct category;
Date: 2025-12-30 09:01:16 Duration: 0ms Database: postgres parameters: $1 = '604544041467024307', $2 = '604544041467024307'
20 40ms 12 1ms 6ms 3ms WITH pre_symbols AS ( /* find relevant symbols */ ;Times Reported Time consuming bind #20
Day Hour Count Duration Avg duration 09 12 40ms 3ms -
WITH pre_symbols AS ( /* find relevant symbols */ ;
Date: 2025-12-30 09:13:17 Duration: 6ms Database: postgres parameters: $1 = '1018', $2 = 'ICMARKETS-AU-MT5', $3 = 'AAPL.NAS', $4 = 'ABBV.NYSE', $5 = 'AMCR.NYSE', $6 = 'AMP.NYSE', $7 = 'AMZN.NAS', $8 = 'ANZ.ASX', $9 = 'AUDJPY', $10 = 'AUDUSD', $11 = 'AUS200', $12 = 'BABA.NYSE', $13 = 'BIIB.NAS', $14 = 'BXB.ASX', $15 = 'CBA.ASX', $16 = 'CHINA50', $17 = 'CSL.ASX', $18 = 'DE30', $19 = 'ES35', $20 = 'EURCHF', $21 = 'EURGBP', $22 = 'EURUSD', $23 = 'F40', $24 = 'FMG.ASX', $25 = 'GBPJPY', $26 = 'GBPUSD', $27 = 'GOOG.NAS', $28 = 'HK50', $29 = 'IT40', $30 = 'JP225', $31 = 'KO.NYSE', $32 = 'MQG.ASX', $33 = 'MSFT.NAS', $34 = 'NAB.ASX', $35 = 'NFLX.NAS', $36 = 'PYPL.NAS', $37 = 'QBE.ASX', $38 = 'STOXX50', $39 = 'SUN.ASX', $40 = 'TCL.ASX', $41 = 'TLS.ASX', $42 = 'TSLA.NAS', $43 = 'UK100', $44 = 'UNH.NYSE', $45 = 'US2000', $46 = 'US30', $47 = 'US500', $48 = 'USDCAD', $49 = 'USDCHF', $50 = 'USDCNH', $51 = 'USDJPY', $52 = 'USTEC', $53 = 'WBC.ASX', $54 = 'WES.ASX', $55 = 'WOW.ASX', $56 = 'WPL.ASX', $57 = 'XAUEUR', $58 = 'XAUUSD', $59 = 'XBRUSD', $60 = 'XTIUSD', $61 = 'AAPL.NAS', $62 = 'ABBV.NYSE', $63 = 'AMCR.NYSE', $64 = 'AMP.NYSE', $65 = 'AMZN.NAS', $66 = 'ANZ.ASX', $67 = 'AUDJPY', $68 = 'AUDUSD', $69 = 'AUS200', $70 = 'BABA.NYSE', $71 = 'BIIB.NAS', $72 = 'BXB.ASX', $73 = 'CBA.ASX', $74 = 'CHINA50', $75 = 'CSL.ASX', $76 = 'DE30', $77 = 'ES35', $78 = 'EURCHF', $79 = 'EURGBP', $80 = 'EURUSD', $81 = 'F40', $82 = 'FMG.ASX', $83 = 'GBPJPY', $84 = 'GBPUSD', $85 = 'GOOG.NAS', $86 = 'HK50', $87 = 'IT40', $88 = 'JP225', $89 = 'KO.NYSE', $90 = 'MQG.ASX', $91 = 'MSFT.NAS', $92 = 'NAB.ASX', $93 = 'NFLX.NAS', $94 = 'PYPL.NAS', $95 = 'QBE.ASX', $96 = 'STOXX50', $97 = 'SUN.ASX', $98 = 'TCL.ASX', $99 = 'TLS.ASX', $100 = 'TSLA.NAS', $101 = 'UK100', $102 = 'UNH.NYSE', $103 = 'US2000', $104 = 'US30', $105 = 'US500', $106 = 'USDCAD', $107 = 'USDCHF', $108 = 'USDCNH', $109 = 'USDJPY', $110 = 'USTEC', $111 = 'WBC.ASX', $112 = 'WES.ASX', $113 = 'WOW.ASX', $114 = 'WPL.ASX', $115 = 'XAUEUR', $116 = 'XAUUSD', $117 = 'XBRUSD', $118 = 'XTIUSD', $119 = '5'
-
WITH pre_symbols AS ( /* find relevant symbols */ ;
Date: 2025-12-30 09:00:47 Duration: 6ms Database: postgres parameters: $1 = '619', $2 = 'AXIORY', $3 = 'EURUSD', $4 = 'USDJPY', $5 = 'GBPUSD', $6 = 'AUDUSD', $7 = 'USDCHF', $8 = 'USDCAD', $9 = 'NZDUSD', $10 = 'GBPJPY', $11 = 'EURJPY', $12 = 'EURCHF', $13 = 'GBPCHF', $14 = 'EURCAD', $15 = 'GBPCAD', $16 = 'EURNZD', $17 = 'GBPNZD', $18 = 'CADJPY', $19 = 'CADCHF', $20 = 'CHFJPY', $21 = 'NZDJPY', $22 = 'XAUUSD', $23 = 'XAGUSD', $24 = 'EURUSD', $25 = 'USDJPY', $26 = 'GBPUSD', $27 = 'AUDUSD', $28 = 'USDCHF', $29 = 'USDCAD', $30 = 'NZDUSD', $31 = 'GBPJPY', $32 = 'EURJPY', $33 = 'EURCHF', $34 = 'GBPCHF', $35 = 'EURCAD', $36 = 'GBPCAD', $37 = 'EURNZD', $38 = 'GBPNZD', $39 = 'CADJPY', $40 = 'CADCHF', $41 = 'CHFJPY', $42 = 'NZDJPY', $43 = 'XAUUSD', $44 = 'XAGUSD', $45 = '5'
-
WITH pre_symbols AS ( /* find relevant symbols */ ;
Date: 2025-12-30 09:13:17 Duration: 5ms Database: postgres parameters: $1 = '1018', $2 = 'ICMARKETS-AU-MT5', $3 = 'AAPL.NAS', $4 = 'ABBV.NYSE', $5 = 'AMCR.NYSE', $6 = 'AMP.NYSE', $7 = 'AMZN.NAS', $8 = 'ANZ.ASX', $9 = 'AUDJPY', $10 = 'AUDUSD', $11 = 'AUS200', $12 = 'BABA.NYSE', $13 = 'BIIB.NAS', $14 = 'BXB.ASX', $15 = 'CBA.ASX', $16 = 'CHINA50', $17 = 'CSL.ASX', $18 = 'DE30', $19 = 'ES35', $20 = 'EURCHF', $21 = 'EURGBP', $22 = 'EURUSD', $23 = 'F40', $24 = 'FMG.ASX', $25 = 'GBPJPY', $26 = 'GBPUSD', $27 = 'GOOG.NAS', $28 = 'HK50', $29 = 'IT40', $30 = 'JP225', $31 = 'KO.NYSE', $32 = 'MQG.ASX', $33 = 'MSFT.NAS', $34 = 'NAB.ASX', $35 = 'NFLX.NAS', $36 = 'PYPL.NAS', $37 = 'QBE.ASX', $38 = 'STOXX50', $39 = 'SUN.ASX', $40 = 'TCL.ASX', $41 = 'TLS.ASX', $42 = 'TSLA.NAS', $43 = 'UK100', $44 = 'UNH.NYSE', $45 = 'US2000', $46 = 'US30', $47 = 'US500', $48 = 'USDCAD', $49 = 'USDCHF', $50 = 'USDCNH', $51 = 'USDJPY', $52 = 'USTEC', $53 = 'WBC.ASX', $54 = 'WES.ASX', $55 = 'WOW.ASX', $56 = 'WPL.ASX', $57 = 'XAUEUR', $58 = 'XAUUSD', $59 = 'XBRUSD', $60 = 'XTIUSD', $61 = 'AAPL.NAS', $62 = 'ABBV.NYSE', $63 = 'AMCR.NYSE', $64 = 'AMP.NYSE', $65 = 'AMZN.NAS', $66 = 'ANZ.ASX', $67 = 'AUDJPY', $68 = 'AUDUSD', $69 = 'AUS200', $70 = 'BABA.NYSE', $71 = 'BIIB.NAS', $72 = 'BXB.ASX', $73 = 'CBA.ASX', $74 = 'CHINA50', $75 = 'CSL.ASX', $76 = 'DE30', $77 = 'ES35', $78 = 'EURCHF', $79 = 'EURGBP', $80 = 'EURUSD', $81 = 'F40', $82 = 'FMG.ASX', $83 = 'GBPJPY', $84 = 'GBPUSD', $85 = 'GOOG.NAS', $86 = 'HK50', $87 = 'IT40', $88 = 'JP225', $89 = 'KO.NYSE', $90 = 'MQG.ASX', $91 = 'MSFT.NAS', $92 = 'NAB.ASX', $93 = 'NFLX.NAS', $94 = 'PYPL.NAS', $95 = 'QBE.ASX', $96 = 'STOXX50', $97 = 'SUN.ASX', $98 = 'TCL.ASX', $99 = 'TLS.ASX', $100 = 'TSLA.NAS', $101 = 'UK100', $102 = 'UNH.NYSE', $103 = 'US2000', $104 = 'US30', $105 = 'US500', $106 = 'USDCAD', $107 = 'USDCHF', $108 = 'USDCNH', $109 = 'USDJPY', $110 = 'USTEC', $111 = 'WBC.ASX', $112 = 'WES.ASX', $113 = 'WOW.ASX', $114 = 'WPL.ASX', $115 = 'XAUEUR', $116 = 'XAUUSD', $117 = 'XBRUSD', $118 = 'XTIUSD'
-
Events
Log levels
Key values
- 538,694 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 1 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 1 Max number of times the same event was reported
- 1 Total events found
Rank Times reported Error 1 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Dec 30 09 1 - ERROR: relation "t0" does not exist at character 83
Statement: SELECT * FROM ( SELECT PriceDateTime, Open, High, Low, Close, Volume, BSF FROM T0 WHERE symbolid = $1 AND (BSF = 0 OR BSF IS NULL) ORDER BY PriceDateTime DESC LIMIT 1050 ) a ORDER BY PriceDateTime ASC
Date: 2025-12-30 09:41:37