pgBadger-
Global information
- Generated on Wed Feb 11 23:59:37 2026
- Log file: /home/postgres/pg_data/data/pg_log/postgresql-2026-02-12_010000.log
- Parsed 1,492,359 log entries in 36s
- Log start from 2026-02-12 01:00:00 to 2026-02-12 01:59:34
-
Overview
Global Stats
- 209 Number of unique normalized queries
- 158,609 Number of queries
- 2h26m53s Total query duration
- 2026-02-12 01:00:00 First query
- 2026-02-12 01:59:34 Last query
- 2,840 queries/s at 2026-02-12 01:15:04 Query peak
- 2h26m53s Total query duration
- 8s315ms Prepare/parse total duration
- 50s494ms Bind total duration
- 2h25m54s Execute total duration
- 0 Number of events
- 0 Number of unique normalized events
- 0 Max number of times the same event was reported
- 0 Number of cancellation
- 340 Total number of automatic vacuums
- 61 Total number of automatic analyzes
- 994 Number temporary file
- 198.95 MiB Max size of temporary file
- 5.98 MiB Average size of temporary file
- 3,266 Total number of sessions
- 13 sessions at 2026-02-12 01:56:45 Session peak
- 3d7h46m21s Total duration of sessions
- 1m27s Average duration of sessions
- 48 Average queries per session
- 2s698ms Average queries duration per session
- 1m25s Average idle time per session
- 3,266 Total number of connections
- 28 connections/s at 2026-02-12 01:53:50 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 2,840 queries/s Query Peak
- 2026-02-12 01:15:04 Date
SELECT Traffic
Key values
- 1,386 queries/s Query Peak
- 2026-02-12 01:15:04 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 164 queries/s Query Peak
- 2026-02-12 01:00:51 Date
Queries duration
Key values
- 2h26m53s 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) Feb 12 01 158,609 0ms 38s592ms 55ms 3m47s 4m9s 4m56s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Feb 12 01 42,205 26 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Feb 12 01 23,876 1,412 16 96 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Feb 12 01 23,283 57,980 2.49 31.43% Day Hour Count Average / Second Feb 12 01 3,266 0.91/s Day Hour Count Average Duration Average idle time Feb 12 01 3,266 1m27s 1m25s -
Connections
Established Connections
Key values
- 28 connections Connection Peak
- 2026-02-12 01:53:50 Date
Connections per database
Key values
- acaweb_fx Main Database
- 3,266 connections Total
Connections per user
Key values
- postgres Main User
- 3,266 connections Total
Connections per host
Key values
- 192.168.4.142 Main host with 1010 connections
- 3,266 Total connections
Host Count 127.0.0.1 114 192.168.0.114 13 192.168.0.216 107 192.168.0.74 340 192.168.1.145 86 192.168.1.15 652 192.168.1.20 96 192.168.1.231 20 192.168.1.239 14 192.168.1.90 62 192.168.2.126 36 192.168.2.182 12 192.168.3.199 36 192.168.4.142 1,010 192.168.4.150 10 192.168.4.216 1 192.168.4.222 1 192.168.4.238 12 192.168.4.33 70 192.168.4.98 330 [local] 244 -
Sessions
Simultaneous sessions
Key values
- 13 sessions Session Peak
- 2026-02-12 01:56:45 Date
Histogram of session times
Key values
- 2,615 0-500ms duration
Sessions per database
Key values
- acaweb_fx Main Database
- 3,266 sessions Total
Sessions per user
Key values
- postgres Main User
- 3,266 sessions Total
Sessions per host
Key values
- 192.168.4.142 Main Host
- 3,266 sessions Total
Host Count Total Duration Average Duration 127.0.0.1 114 9s221ms 80ms 192.168.0.114 13 1h8m14s 5m14s 192.168.0.216 107 3m53s 2s184ms 192.168.0.74 340 13h9m19s 2m19s 192.168.1.145 86 3h13m27s 2m14s 192.168.1.15 652 16h50m16s 1m32s 192.168.1.20 96 15h7m14s 9m27s 192.168.1.231 20 9h53m39s 29m40s 192.168.1.239 14 95ms 6ms 192.168.1.90 62 34s700ms 559ms 192.168.2.126 36 5s917ms 164ms 192.168.2.182 12 3s370ms 280ms 192.168.3.199 36 1s409ms 39ms 192.168.4.142 1,010 11m52s 705ms 192.168.4.150 10 20h30s 2h3s 192.168.4.216 1 191ms 191ms 192.168.4.222 1 49s417ms 49s417ms 192.168.4.238 12 17s406ms 1s450ms 192.168.4.33 70 1m3s 909ms 192.168.4.98 330 18s973ms 57ms [local] 244 4m27s 1s98ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 11,090 buffers Checkpoint Peak
- 2026-02-12 01:05:59 Date
- 210.033 seconds Highest write time
- 0.011 seconds Sync time
Checkpoints Wal files
Key values
- 5 files Wal files usage Peak
- 2026-02-12 01:05:59 Date
Checkpoints distance
Key values
- 149.87 Mo Distance Peak
- 2026-02-12 01:05:59 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Feb 12 01 48,143 1,970.237s 0.067s 1,970.638s Day Hour Added Removed Recycled Synced files Longest sync Average sync Feb 12 01 0 0 24 2,212 0.009s 0s Day Hour Count Avg time (sec) Feb 12 01 0 0s Day Hour Mean distance Mean estimate Feb 12 01 32,167.83 kB 59,385.92 kB -
Temporary Files
Size of temporary files
Key values
- 183.92 MiB Temp Files size Peak
- 2026-02-12 01:10:08 Date
Number of temporary files
Key values
- 62 per second Temp Files Peak
- 2026-02-12 01:02:13 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Feb 12 01 994 5.80 GiB 5.98 MiB Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 93 403.69 MiB 4.28 MiB 4.41 MiB 4.34 MiB 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;-
SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), fr AS ( SELECT a.*, rr.age, rr.relevant from fibonacci_results a LEFT OUTER JOIN relevance_fibonacci_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) END), all_results AS ( SELECT fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN fr.age IS NOT NULL THEN fr.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN fr.relevant IS NOT NULL THEN fr.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT JOIN LATERAL calc_fib_signal_filter (fr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($3 = 0 OR s.timegranularity in ($4)) AND ($5 = 0 OR s.exchange in ($6)) AND ($7 = 0 OR coalesce(bim.code, s.symbol) in ($8)) AND ($9 = 0 OR fr.pattern in ($10)) AND ($11 = 0 OR fr.patternlengthbars <= $12) AND ($13 = 0 OR ($14 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($15 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $16 OR relevant = 1) AND ($17 = 0 OR age <= $18) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;
Date: 2026-02-12 01:00:43 Duration: 0ms
2 40 232.68 MiB 3.12 MiB 8.53 MiB 5.82 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: 2026-02-12 01:01:27 Duration: 0ms
3 28 1.65 GiB 3.83 MiB 198.95 MiB 60.47 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: 2026-02-12 01:00:08 Duration: 0ms
4 25 79.58 MiB 3.04 MiB 3.31 MiB 3.18 MiB select resultuid from relevance_consecutivecandles_results order by resultuid desc limit ?), all_results as ( select ccr.resultuid as resultuid, ccr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, ccr.patternendtime as identified, dtt.timezone as timezone, ccr.qtyconsecutivecandles as length, g.basegroupname, case when rcr.age is not null then rcr.age when ccr.resultuid <= rm.resultuid then ? else ? end as age, case when rcr.relevant is not null then rcr.relevant when ccr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip, newlevels.filtered from consecutivecandles_results ccr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = ccr.symbolid inner join symbols s on ccr.symbolid = s.symbolid and s.nonliquid = ? inner join downloadersymbolsettings dss on ccr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on ccr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join rar_max rm on ? = ? left outer join relevance_consecutivecandles_results rcr on rcr.resultuid = ccr.resultuid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? left join lateral calc_cc_signal_filter (ccr.resultuid) newlevels on true where ccr.gmttimefound > now() - interval ? and s.deleted = ? and (ccr.simulation = ? or ccr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ccr.patternlengthbars <= ?)), 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;-
SELECT resultuid FROM relevance_consecutivecandles_results ORDER BY resultuid DESC LIMIT 1), all_results AS ( SELECT ccr.resultuid AS resultuid, ccr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, ccr.patternendtime AS identified, dtt.timezone AS timezone, ccr.qtyconsecutivecandles AS length, g.basegroupname, CASE WHEN rcr.age IS NOT NULL THEN rcr.age WHEN ccr.resultuid <= rm.resultuid THEN 1 ELSE 0 END as age, CASE WHEN rcr.relevant IS NOT NULL THEN rcr.relevant WHEN ccr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip, newLevels.filtered FROM consecutivecandles_results ccr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = ccr.symbolid INNER JOIN symbols s ON ccr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN downloadersymbolsettings dss ON ccr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on ccr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_consecutivecandles_results rcr ON rcr.resultuid = ccr.resultuid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' LEFT JOIN LATERAL calc_cc_signal_filter (ccr.resultuid) newLevels on true WHERE ccr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (ccr.simulation = 0 OR ccr.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3, $4, $5, $6, $7, $8, $9)) AND ($10 = 0 OR s.exchange in ($11)) AND ($12 = 0 OR coalesce(bim.code, s.symbol) in ($13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322)) AND ($323 = 0 OR ccr.patternlengthbars <= $324)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $325 OR relevant = 1) AND ($326 = 0 OR age <= $327) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;
Date: 2026-02-12 01:01:07 Duration: 0ms
5 16 621.25 MiB 38.83 MiB 38.83 MiB 38.83 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: 2026-02-12 01:01:13 Duration: 0ms
6 16 1.15 GiB 72.52 MiB 73.51 MiB 73.32 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: 2026-02-12 01:01:16 Duration: 0ms
7 8 1.08 GiB 137.62 MiB 137.67 MiB 137.65 MiB select updateresultsmaterializedview ();-
select updateresultsmaterializedview ();
Date: 2026-02-12 01:02:19 Duration: 0ms
8 4 367.69 MiB 91.88 MiB 91.96 MiB 91.92 MiB select updateageforrelevantresults ();-
select updateageforrelevantresults ();
Date: 2026-02-12 01:02:07 Duration: 0ms
9 1 4.40 MiB 4.40 MiB 4.40 MiB 4.40 MiB from downloadersymbolsettings dss inner join symbols s on dss.symbolid = s.symbolid where dss.classname = ? and s.deleted = ? and dss.enabled = ?;-
FROM downloadersymbolsettings dss INNER JOIN symbols s ON dss.symbolid = s.symbolid WHERE dss.classname = $1 AND s.deleted = 0 AND dss.enabled = 1;
Date: 2026-02-12 01:12:12 Duration: 0ms
Queries generating the largest temporary files
Rank Size Query 1 198.95 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: 2026-02-12 01:10:04 ]
2 137.67 MiB select updateresultsmaterializedview ();[ Date: 2026-02-12 01:32:16 ]
3 137.66 MiB select updateresultsmaterializedview ();[ Date: 2026-02-12 01:47:16 ]
4 137.65 MiB select updateresultsmaterializedview ();[ Date: 2026-02-12 01:35:32 ]
5 137.65 MiB select updateresultsmaterializedview ();[ Date: 2026-02-12 01:50:32 ]
6 137.64 MiB select updateresultsmaterializedview ();[ Date: 2026-02-12 01:02:19 ]
7 137.64 MiB select updateresultsmaterializedview ();[ Date: 2026-02-12 01:17:21 ]
8 137.63 MiB select updateresultsmaterializedview ();[ Date: 2026-02-12 01:20:32 ]
9 137.62 MiB select updateresultsmaterializedview ();[ Date: 2026-02-12 01:05:33 ]
10 115.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 = 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: 2026-02-12 01:30:04 ]
11 107.91 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: 2026-02-12 01:40:05 ]
12 98.99 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: 2026-02-12 01:40:06 ]
13 97.50 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: 2026-02-12 01:20:04 ]
14 97.02 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: 2026-02-12 01:50:04 ]
15 96.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: 2026-02-12 01:00:06 ]
16 91.96 MiB select updateageforrelevantresults ();[ Date: 2026-02-12 01:32:05 ]
17 91.96 MiB select updateageforrelevantresults ();[ Date: 2026-02-12 01:02:07 ]
18 91.90 MiB select updateageforrelevantresults ();[ Date: 2026-02-12 01:47:06 ]
19 91.88 MiB select updateageforrelevantresults ();[ Date: 2026-02-12 01:17:06 ]
20 89.44 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: 2026-02-12 01:00:04 ]
-
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)
- 61 analyzes Total
Table Number of analyzes acaweb_fx.public.solr_relevance_old 16 acaweb_fx.pg_catalog.pg_attribute 8 acaweb_fx.pg_catalog.pg_class 5 acaweb_fx.public.relevance_keylevels_results 4 acaweb_fx.public.relevance_fibonacci_results 4 acaweb_fx.pg_catalog.pg_type 4 acaweb_fx.public.relevance_autochartist_results 4 acaweb_fx.public.datafeeds_latestrun 3 acaweb_fx.pg_catalog.pg_index 2 acaweb_fx.public.autochartist_symbolupdates 2 acaweb_fx.public.latest_t15_candle_view 2 acaweb_fx.pg_catalog.pg_depend 2 acaweb_fx.public.keylevels_results 1 socialmedia.public.processes 1 acaweb_fx.public.latest_candle_datetime_per_receng 1 acaweb_fx.public.relevance_consecutivecandles_results 1 acaweb_fx.public.symbollatestupdatetime 1 Total 61 Vacuums per table
Key values
- public.solr_relevance_old (16) Main table vacuumed on database acaweb_fx
- 340 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 16 16 12,727 0 50 0 0 9,466 16 1,660,995 acaweb_fx.pg_catalog.pg_class 3 3 1,383 0 98 0 0 416 90 477,532 acaweb_fx.public.datafeeds_latestrun 3 0 360 0 7 0 0 33 5 32,051 acaweb_fx.pg_catalog.pg_attribute 3 3 2,522 0 471 0 201 1,070 428 2,454,280 acaweb_fx.public.relevance_fibonacci_results 3 3 3,785 0 154 2 141 542 199 668,427 acaweb_fx.pg_catalog.pg_type 3 3 483 0 96 0 0 219 74 355,633 acaweb_fx.public.relevance_keylevels_results 3 3 11,345 0 1,136 5 268 2,687 1,758 5,531,553 acaweb_fx.public.latest_t15_candle_view 2 2 145 0 2 0 0 12 2 18,062 acaweb_fx.pg_toast.pg_toast_2619 2 2 282 0 69 0 0 202 68 245,499 acaweb_fx.public.relevance_autochartist_results 2 2 6,602 0 470 4 488 1,238 902 2,677,737 acaweb_fx.pg_toast.pg_toast_5894536 1 0 29 0 1 0 0 1 1 7,285 acaweb_fx.public.relevance_autochartist_results_hve 1 0 162 0 1 0 215 1 1 6,053 acaweb_fx.public.sa_hist_highesthigh60 1 0 64 0 1 0 0 1 1 7,917 acaweb_fx.public.stats_chartpatterns_emerging_quantities 1 0 31 0 0 0 211 1 0 257 acaweb_fx.public.usage_latestlogin 1 0 41 0 0 0 1,211 1 0 257 acaweb_fx.public.timezones_italian 1 0 13 0 0 0 0 1 0 257 acaweb_fx.public.dataversion 1 0 48 0 1 0 0 1 1 4,505 acaweb_fx.public.emailtemplate 1 0 26 0 0 0 0 1 0 257 acaweb_fx.public.powerstats_consecutivebearcandles 1 0 32 0 0 0 0 1 0 257 acaweb_fx.public.t15_hve 1 0 101 0 1 0 129,864 1 1 6,889 acaweb_fx.pg_toast.pg_toast_5882804 1 0 28 0 0 0 0 1 0 188 acaweb_fx.public.stats_hrs_tmp 1 0 28 0 1 0 1,057 1 0 257 acaweb_fx.public.futures_symbol_groups 1 0 66 0 0 0 0 1 0 257 acaweb_fx.public.autochartist_symbolupdates_new 1 0 80 0 0 0 0 1 0 257 acaweb_fx.public.market_report_results 1 0 33 0 0 0 0 1 0 257 acaweb_fx.public.autochartist_symbolupdates_20191017a 1 0 65 0 0 0 1,432 1 0 257 acaweb_fx.public.broker_clones 1 0 30 0 1 0 0 1 1 5,905 acaweb_fx.public.highesthighandlowestlow_results 1 0 66 0 0 0 0 1 0 257 acaweb_fx.public.usage_history 1 0 47 0 0 0 0 1 0 257 acaweb_fx.pg_toast.pg_toast_5884020 1 0 29 0 0 0 0 1 0 188 acaweb_fx.public.default_corr_signals_symbols 1 0 9 0 0 0 0 1 0 245 acaweb_fx.public.groups 1 1 201 0 16 2 53 31 12 82,804 acaweb_fx.public.sa_analysistypes 1 0 74 0 0 0 0 1 0 257 acaweb_fx.public.futures_symbols 1 0 38 0 0 0 0 1 0 257 acaweb_fx.public.positionserrors 1 0 10 0 1 0 0 1 0 257 acaweb_fx.public.broker_powerstats 1 0 16 0 10 0 0 14 5 40,660 acaweb_fx.public.japsticks_patterns 1 0 47 0 0 0 0 1 0 269 acaweb_fx.public.timezones_chinese_traditional 1 0 38 0 0 0 0 1 0 257 acaweb_fx.public.performancestats_latestrun 1 0 11 0 0 0 0 1 0 257 acaweb_fx.public.timezones_luxemburg 1 0 13 0 0 0 0 1 0 257 acaweb_fx.pg_toast.pg_toast_5894565 1 0 29 0 1 0 0 1 1 7,313 acaweb_fx.public.timezones_chinese_simplified 1 0 13 0 1 0 0 1 1 2,525 acaweb_fx.public.datafeedchecks 1 0 26 0 0 0 0 1 0 257 acaweb_fx.public.t60_stock_split 1 0 32 0 1 0 212 1 1 4,897 acaweb_fx.pg_toast.pg_toast_5882791 1 0 29 0 0 0 0 1 0 188 acaweb_fx.pg_toast.pg_toast_5883895 1 0 29 0 0 0 0 1 0 188 acaweb_fx.public.best5trades 1 0 11 0 2 0 0 1 1 5,573 acaweb_fx.public.brokermt4authservers 1 0 9 0 0 0 0 1 0 257 acaweb_fx.pg_toast.pg_toast_5894424 1 0 29 0 0 0 0 1 0 188 acaweb_fx.public.keylevelssearches 1 0 30 0 0 0 0 1 0 257 acaweb_fx.public.filters 1 0 38 0 0 0 30,417 1 0 257 acaweb_fx.public.server_loadavg 1 1 42 0 17 0 90 25 13 103,490 acaweb_fx.pg_toast.pg_toast_5882891 1 0 29 0 1 0 0 1 1 7,861 acaweb_fx.public.t5 1 0 37 0 0 0 7,010 1 0 257 acaweb_fx.archive.futures_rolled_over_futures 1 0 11 0 0 0 0 1 0 188 acaweb_fx.public.powerstats 1 0 59 0 0 0 0 1 0 257 acaweb_fx.public.v_datafeedinstrumentid 1 0 28 0 0 0 0 1 0 257 acaweb_fx.pg_toast.pg_toast_5882490 1 0 28 0 1 0 0 1 1 6,525 acaweb_fx.public.stats_fibonaccipatterns_complete_quantities 1 0 31 0 0 0 117 1 0 257 acaweb_fx.public.sa_hist_correlation 1 0 99 0 0 0 0 1 0 257 acaweb_fx.public.relevance_autochartist_results_old 1 0 123 0 0 0 9,876 1 0 257 acaweb_fx.public.powerstats_consecutivebullcandles 1 0 34 0 0 0 0 1 0 257 acaweb_fx.public.ss_marketreportresources 1 0 51 0 2 0 204 1 1 6,889 acaweb_fx.pg_toast.pg_toast_5882630 1 0 29 0 0 0 0 1 0 188 acaweb_fx.public.spcall 1 0 9 0 0 0 0 1 0 257 acaweb_fx.public.futures_rolled_over_futures 1 0 31 0 0 0 0 1 0 257 acaweb_fx.public.brokerusers 1 0 72 0 0 0 977 1 0 257 acaweb_fx.pg_toast.pg_toast_5883471 1 0 30 0 1 0 0 1 1 5,989 acaweb_fx.public.timezones_turkish 1 0 13 0 0 0 0 1 0 257 acaweb_fx.pg_toast.pg_toast_5882662 1 0 29 0 1 0 0 1 1 7,261 acaweb_fx.public.relevance_consecutivecandles_results 1 1 78 0 9 0 0 22 7 30,008 acaweb_fx.pg_toast.pg_toast_5883002 1 0 29 0 1 0 0 1 1 4,897 acaweb_fx.pg_toast.pg_toast_5882695 1 0 29 0 0 0 0 1 0 188 acaweb_fx.pg_toast.pg_toast_5882995 1 0 28 0 0 0 0 1 0 188 acaweb_fx.public.t240_fps 1 0 82 0 1 0 0 1 1 3,353 acaweb_fx.public.translation_groupings 1 0 33 0 0 0 0 1 0 245 acaweb_fx.public.stats_symbols 1 1 1,759 0 265 0 932 489 225 1,548,353 acaweb_fx_integer.public.latest_candle_datetime_per_receng 1 0 53 0 2 0 0 2 1 6,635 acaweb_fx.public.fibsearches 1 0 26 0 1 0 9,557 1 1 3,325 acaweb_fx.public.nd_test 1 0 13 0 0 0 0 1 0 257 acaweb_fx.public.patternresults_symbolupdates 1 0 66 0 2 0 252 1 1 7,313 acaweb_fx_integer.public.latest_t15_candle_view 1 0 68 0 1 0 0 1 1 5,265 acaweb_fx.public.sa_correlationsymbols 1 0 47 0 0 0 0 1 0 257 acaweb_fx.public.stats_chartpatterns_complete_quantities 1 0 30 0 0 0 214 1 0 257 acaweb_fx.public.t1440_fps 1 0 87 0 0 0 0 1 0 257 acaweb_fx.pg_toast.pg_toast_5883457 1 0 30 0 0 0 0 1 0 188 acaweb_fx.public.futures_downloadersymbol 1 0 49 0 0 0 0 1 0 257 acaweb_fx.public.whatshot_pref 1 0 66 0 7 0 2,482 13 7 39,146 acaweb_fx.public.t60_fps 1 0 81 0 0 0 0 1 0 257 acaweb_fx.public.skrilltransactions 1 0 26 0 0 0 0 1 0 257 acaweb_fx.public.timezones_swedish 1 0 13 0 0 0 0 1 0 257 acaweb_fx.public.tmp_admiralusers 1 0 11 0 0 0 91 1 0 257 acaweb_fx.pg_toast.pg_toast_5883089 1 0 29 0 1 0 0 1 1 5,269 acaweb_fx.public.latestbrokerresults 1 0 40 0 5 0 0 3 2 9,710 acaweb_fx.public.correlation_results 1 0 49 0 1 0 0 1 1 6,053 acaweb_fx.pg_toast.pg_toast_5883917 1 0 29 0 1 0 0 1 1 5,573 acaweb_fx.pg_toast.pg_toast_5882480 1 0 30 0 0 0 0 1 0 188 acaweb_fx.public.timezones_dutch 1 0 13 0 0 0 0 1 0 257 acaweb_fx.public.t15_stock_split 1 0 87 0 0 0 477 1 0 245 acaweb_fx.public.brokerinstrumentmap 1 1 544 0 12 0 600 24 11 87,586 acaweb_fx.public.datafeedstimetable_history 1 0 26 0 6 0 1,119 4 2 16,761 acaweb_fx.pg_toast.pg_toast_5894713 1 0 29 0 1 0 0 1 1 4,685 acaweb_fx.public.keylevels_patternclasses 1 0 26 0 0 0 0 1 0 257 acaweb_fx.public.nd_broker_test 1 0 28 0 0 0 0 1 0 257 acaweb_fx.public.futures_brokersymbollist 1 0 66 0 0 0 0 1 0 257 acaweb_fx.public.keylevelspatterns 1 0 29 0 1 0 0 1 0 257 acaweb_fx.public.futures_symbol_frontmonth 1 0 42 0 0 0 0 1 0 257 acaweb_fx.public.currencypips 1 0 44 0 5 0 0 3 2 15,770 acaweb_fx.public.timezones_farsi 1 0 14 0 0 0 0 1 0 257 acaweb_fx.pg_toast.pg_toast_5883983 1 0 29 0 0 0 0 1 0 188 acaweb_fx.public.hrssearches 1 0 57 0 0 0 4,640 1 0 257 acaweb_fx.public.brokerconfig 1 1 99 0 84 0 0 118 40 302,441 acaweb_fx.public.timezones_russian 1 0 14 0 0 0 0 1 0 257 acaweb_fx.public.symbolsconfig 1 0 26 0 0 0 0 2 0 313 acaweb_fx.public.exchanges_symbol_trading_times 1 0 89 0 1 0 0 1 1 6,329 acaweb_fx.public.symbolgroup 1 1 1,744 0 131 0 2,160 225 125 854,713 acaweb_fx.public.fibonacci_results_relevance 1 0 85 0 1 0 17,626 1 1 6,213 acaweb_fx.public.powerstats_trumpet_test 1 0 85 0 0 0 113,672 1 0 269 acaweb_fx.pg_toast.pg_toast_5882414 1 0 28 0 1 0 0 1 1 6,853 acaweb_fx.pg_toast.pg_toast_5882871 1 0 29 0 1 0 0 1 1 5,733 acaweb_fx.public.backup_groups 1 0 27 0 0 0 0 1 0 245 acaweb_fx.pg_toast.pg_toast_5894654 1 0 30 0 0 0 0 1 0 188 acaweb_fx.public.v_serverdays 1 0 9 0 0 0 0 1 0 245 acaweb_fx.public.tmp_nd 1 0 13 0 0 0 0 1 0 257 acaweb_fx.pg_toast.pg_toast_5882330 1 0 27 0 0 0 0 1 0 188 acaweb_fx.pg_toast.pg_toast_5894500 1 0 29 0 1 0 0 1 1 6,889 acaweb_fx.pg_toast.pg_toast_5882900 1 0 28 0 0 0 0 1 0 188 acaweb_fx.pg_toast.pg_toast_5882907 1 0 29 0 1 0 0 1 1 4,805 acaweb_fx.pg_toast.pg_toast_5883887 1 0 29 0 0 0 0 1 0 188 acaweb_fx.public.timezones_korean 1 0 14 0 0 0 0 1 0 257 acaweb_fx.pg_toast.pg_toast_5882469 1 0 29 0 1 0 0 1 1 5,269 acaweb_fx.pg_toast.pg_toast_5883592 1 0 29 0 0 0 0 1 0 188 acaweb_fx.pg_toast.pg_toast_5883167 1 0 29 0 0 0 0 1 0 188 acaweb_fx.pg_toast.pg_toast_5883062 1 0 29 0 1 0 0 1 1 7,545 acaweb_fx.public.whatshot_groups 1 1 41 0 6 0 0 8 4 20,085 acaweb_fx.pg_catalog.pg_statistic 1 1 1,058 0 105 0 551 469 89 365,660 acaweb_fx.public.datafeedinstrumentmappingconfig 1 0 41 0 1 0 0 1 1 6,053 acaweb_fx.pg_toast.pg_toast_5882566 1 0 29 0 0 0 0 1 0 188 acaweb_fx.pg_toast.pg_toast_5882935 1 0 28 0 0 0 0 1 0 188 acaweb_fx.public.timezones_greek 1 0 14 0 0 0 0 1 0 257 acaweb_fx.public.brokerdatafeedinstrumentlist 1 1 147 0 8 0 367 8 6 27,768 acaweb_fx.pg_toast.pg_toast_5882927 1 0 29 0 1 0 0 1 0 188 acaweb_fx.public.ws_symbols_temp 1 0 57 0 1 0 138 1 1 7,917 acaweb_fx.public.datafeedstimetable 1 1 124 0 26 0 0 33 20 128,513 acaweb_fx.public.translation_placeholder_examples 1 0 32 0 0 0 0 1 0 245 acaweb_fx.public.t1440_stock_split 1 0 31 0 0 0 105 1 0 245 acaweb_fx.import.historicaldatadump 1 0 10 0 1 0 23,174 1 1 6,853 acaweb_fx.public.fibonaccipatterns 1 0 31 0 1 0 0 1 1 4,505 acaweb_fx_integer.public.solr_relevance_old 1 0 79 0 1 0 631 1 1 429 acaweb_fx.public.translation_groups 1 0 36 0 0 0 0 1 0 245 acaweb_fx.public.timezones 1 0 34 0 0 0 0 1 0 257 acaweb_fx.pg_toast.pg_toast_5883448 1 0 28 0 1 0 0 1 1 6,121 acaweb_fx.public.broker_mt4group 1 0 55 0 1 0 38 2 1 5,933 acaweb_fx.public.performancestats_satellites 1 0 11 0 0 0 0 1 0 257 acaweb_fx.public.hrs_results 1 0 61 0 1 0 0 1 1 6,889 acaweb_fx.public.whatshot_correlatingsignals 1 0 47 0 1 0 0 2 0 313 acaweb_fx.public.researchreports 1 0 24 0 0 0 5,079 1 0 257 acaweb_fx.public.satelliteservers 1 0 29 0 1 0 0 1 0 257 acaweb_fx.public.powerstats_consecutivebulldistribution 1 0 34 0 0 0 0 1 0 257 acaweb_fx.pg_toast.pg_toast_5883082 1 0 29 0 1 0 0 1 1 6,329 acaweb_fx.public.autochartist_latestrun 1 0 26 0 5 0 0 3 2 12,462 acaweb_fx.public.timezones_french 1 0 30 0 1 0 0 1 1 4,257 acaweb_fx.public.backup_brokergroups 1 0 33 0 2 0 0 1 1 6,165 acaweb_fx.pg_toast.pg_toast_5894331 1 0 29 0 0 0 0 1 0 188 acaweb_fx.public.powerstats_avgmovement 1 0 32 0 2 0 0 1 1 5,669 acaweb_fx.public.organisationexchangepermissions 1 0 28 0 0 0 0 1 0 257 acaweb_fx.public.futures_brokerinstrumentmapping 1 0 31 0 0 0 0 1 0 257 acaweb_fx.public.solr_groupnames 1 0 32 0 0 0 2,482 1 0 257 acaweb_fx.public.relevance_japsticks_results 1 0 29 0 1 0 0 1 1 1,725 acaweb_fx.public.geoip 1 0 12 0 0 0 1,230 1 0 257 acaweb_fx_integer.pg_toast.pg_toast_52893 1 0 31 0 1 0 0 1 1 433 acaweb_fx.public.solr_imports 1 1 43 0 2 0 0 6 1 8,911 acaweb_fx.public.instruments 1 1 181 0 40 0 0 70 31 231,945 acaweb_fx.public.datafeeds_kinesis_run 1 0 24 0 2 0 0 1 1 6,801 acaweb_fx.pg_toast.pg_toast_5894595 1 0 29 0 1 0 0 1 1 7,913 acaweb_fx.public.whatshot_archive 1 0 26 0 0 0 0 1 0 257 acaweb_fx.public.timezones_hungarian 1 0 13 0 0 0 0 1 0 257 acaweb_fx.public.futures_symbol_templates 1 0 49 0 0 0 0 1 0 257 acaweb_fx.pg_toast.pg_toast_5882783 1 0 51 0 1 0 0 1 1 5,669 acaweb_fx.public.whatshot_archive_probability 1 0 30 0 1 0 0 1 1 3,205 acaweb_fx.public.timezones_japanese 1 0 14 0 0 0 0 1 0 257 acaweb_fx.public.symbols_preprocessed_newsymbols 1 0 34 0 0 0 0 1 0 257 acaweb_fx.public.powerstats_consecutivebeardistribution 1 0 34 0 1 0 0 1 1 4,805 acaweb_fx.public.powerstats_avgmovementperdayofweek 1 0 32 0 1 0 0 1 0 257 acaweb_fx.pg_toast.pg_toast_5882602 1 0 29 0 1 0 0 1 1 6,525 acaweb_fx.public.patternresultsrelevance_types 1 0 11 0 0 0 0 1 0 245 acaweb_fx.public.brokergroups 1 1 54 0 5 0 56 9 3 18,291 acaweb_fx.public.symbols 1 1 11,639 0 1,562 5 4,961 1,803 1,155 3,816,696 acaweb_fx.pg_toast.pg_toast_5883315 1 0 29 0 1 0 0 1 1 4,517 acaweb_fx.pg_toast.pg_toast_5894669 1 0 29 0 0 0 0 1 0 188 acaweb_fx.public.intervalperiods 1 0 37 0 0 0 0 1 0 257 acaweb_fx.public.v_datafeed_timezone 1 0 11 0 0 0 0 1 0 245 acaweb_fx.archive.whatshot_correlatingsignals 1 0 9 0 1 0 0 1 1 5,733 acaweb_fx.public.datafeeds 1 0 114 0 3 0 0 4 2 14,656 acaweb_fx.pg_toast.pg_toast_5883907 1 0 29 0 1 0 0 1 1 5,441 acaweb_fx.public.hve_correlating_signals 1 0 27 0 0 0 35 1 0 245 acaweb_fx.pg_toast.pg_toast_5882671 1 0 29 0 0 0 0 1 0 188 acaweb_fx.public.t15_fps 1 0 82 0 0 0 0 1 0 257 acaweb_fx.public.cpsearches 1 0 46 0 0 0 24,617 1 0 257 acaweb_fx.public.broker_datafeeds_old 1 0 30 0 1 0 0 1 0 245 acaweb_fx.public.ac_emerging_unique 1 0 11 0 1 0 1,407 1 1 5,573 acaweb_fx.public.relevance_fibonacci_results_old 1 0 134 0 0 0 3,494 1 0 257 acaweb_fx.public.disableddelete 1 0 12 0 1 0 0 1 1 7,113 acaweb_fx.public.whatshot_archive_correlatingsignals 1 0 28 0 0 0 0 1 0 257 acaweb_fx.public.relevance_highesthighandlowestlow_results 1 0 28 0 0 0 0 1 0 269 acaweb_fx.pg_toast.pg_toast_5883483 1 0 29 0 0 0 0 1 0 188 acaweb_fx.public.relevance_keylevels_results_old 1 0 78 0 0 0 3,389 1 0 257 acaweb_fx.public.relevance_bigmovement_results_old 1 0 53 0 0 0 0 1 0 269 acaweb_fx.public.t240_stock_split 1 0 32 0 0 0 193 1 0 245 acaweb_fx.public.futures_month_code 1 0 49 0 0 0 0 1 0 257 acaweb_fx.pg_toast.pg_toast_5883432 1 0 29 0 0 0 0 1 0 188 acaweb_fx.public.datafeeds_metadata 1 0 28 0 1 0 0 1 1 5,269 acaweb_fx.public.fxdd 1 0 11 0 0 0 0 1 0 257 acaweb_fx.public.datafeedinstruments 1 0 119 0 29 0 234 55 28 214,498 acaweb_fx.public.sa_analysistypesintervals 1 0 30 0 0 0 0 1 0 257 acaweb_fx.pg_toast.pg_toast_5883380 1 0 30 0 1 0 108,532 1 1 7,913 acaweb_fx.pg_toast.pg_toast_5882551 1 0 29 0 1 0 0 1 1 4,505 acaweb_fx.public.datafeed_restarter_events 1 1 87 0 22 0 347 40 18 134,819 acaweb_fx.pg_toast.pg_toast_5883875 1 0 29 0 1 0 0 1 1 5,469 acaweb_fx.public.genericsearches 1 0 49 0 0 0 0 1 0 257 acaweb_fx.public.autochartist_datareload 1 0 24 0 0 0 0 1 0 257 acaweb_fx.public.language_locales 1 0 27 0 0 0 0 1 0 245 acaweb_fx.public.v_frontmonth_downloadersymbol 1 0 9 0 0 0 0 1 0 245 acaweb_fx.pg_toast.pg_toast_5882706 1 0 29 0 0 0 0 1 0 188 acaweb_fx.public.timezones_arabic 1 0 14 0 0 0 0 1 0 257 acaweb_fx.public.latestspruntime 1 0 11 0 0 0 2,083 1 0 257 acaweb_fx.public.usersessions 1 0 90 0 0 0 0 1 0 257 acaweb_fx.public.translation_keys 1 0 28 0 0 0 0 1 0 245 acaweb_fx.pg_toast.pg_toast_5883500 1 0 34 0 1 0 0 1 1 8,001 acaweb_fx.public.powerstats_intervals 1 0 33 0 0 0 0 1 0 257 acaweb_fx.pg_toast.pg_toast_5882825 1 0 29 0 1 0 0 1 1 7,617 acaweb_fx.public.timezones_indonesian 1 0 13 0 1 0 0 1 1 3,205 acaweb_fx.public.usertimezones 1 0 31 0 0 0 0 1 0 257 acaweb_fx_integer.archive.fibonacci_results 1 0 84 0 1 0 0 1 1 1,841 acaweb_fx.pg_toast.pg_toast_5883688 1 0 29 0 0 0 0 1 0 188 acaweb_fx.public.translations 1 0 26 0 0 0 0 1 0 245 acaweb_fx.public.cachedump 1 0 62 0 1 0 0 1 1 6,801 acaweb_fx.public.t30_fps 1 0 81 0 0 0 0 1 0 257 acaweb_fx.pg_toast.pg_toast_5894580 1 0 29 0 1 0 0 1 1 6,853 acaweb_fx.public.translation_types 1 0 58 0 0 0 0 1 0 245 acaweb_fx.public.marketreportsubscriptions 1 0 13 0 0 0 0 1 0 257 acaweb_fx.public.timezones_polish 1 0 13 0 0 0 0 1 0 257 acaweb_fx.pg_toast.pg_toast_5883867 1 0 29 0 1 0 0 1 1 5,877 acaweb_fx.public.v_statsid 1 0 9 0 0 0 0 1 0 245 acaweb_fx.public.futures_symbol_codes 1 0 30 0 0 0 0 1 0 257 acaweb_fx.public.iqfeedsymbollist_test 1 0 15 0 0 0 0 1 0 257 acaweb_fx.pg_toast.pg_toast_5882964 1 0 29 0 0 0 0 1 0 188 acaweb_fx.pg_toast.pg_toast_5882812 1 0 30 0 1 0 0 1 0 188 acaweb_fx.public.keylevels_results_relevance 1 0 32 0 1 0 17,621 1 1 5,073 acaweb_fx.public.downloadersymbolsettings_rest 1 0 27 0 1 0 371 1 0 257 acaweb_fx.pg_toast.pg_toast_5882853 1 0 29 0 0 0 0 1 0 188 acaweb_fx.public.timezones_german 1 0 13 0 0 0 0 1 0 257 acaweb_fx.public.powerstats_avgmovementintervalperday 1 0 31 0 0 0 0 1 0 257 acaweb_fx.pg_toast.pg_toast_5882542 1 0 29 0 0 0 0 1 0 188 acaweb_fx.public.intervals 1 0 85 0 3 0 0 3 3 15,762 acaweb_fx.pg_toast.pg_toast_5882955 1 0 29 0 1 0 0 1 1 4,685 acaweb_fx.pg_toast.pg_toast_5883148 1 0 29 0 1 0 0 1 1 6,229 acaweb_fx.pg_toast.pg_toast_5883881 1 0 29 0 0 0 0 1 0 188 acaweb_fx.public.timezones_spanish 1 0 13 0 0 0 0 1 0 257 acaweb_fx.public.users_old 1 0 87 0 0 0 4,673 1 0 257 acaweb_fx.pg_toast.pg_toast_5894684 1 0 29 0 1 0 0 1 1 4,897 acaweb_fx.public.fxdd_adminusers 1 0 26 0 0 0 0 1 0 257 acaweb_fx.public.stats_summary_emerging_2d 1 0 38 0 1 0 0 1 1 7,285 acaweb_fx.public.powerstats_avgmovementperhour 1 0 32 0 0 0 0 1 0 257 acaweb_fx.public.translations_history 1 0 29 0 1 0 0 1 1 5,441 acaweb_fx.public.fxdd_users 1 0 49 0 0 0 0 1 0 257 acaweb_fx.public.japsticks_results 1 0 117 0 0 0 0 1 0 269 acaweb_fx.pg_toast.pg_toast_5883937 1 0 29 0 0 0 0 1 0 188 acaweb_fx.public.hrspatterns 1 0 25 0 0 1 0 1 0 257 acaweb_fx.pg_toast.pg_toast_5882741 1 0 29 0 1 0 0 1 1 5,905 acaweb_fx.public.symbolchanges 1 0 55 0 1 0 0 1 1 6,801 acaweb_fx.pg_toast.pg_toast_5894625 1 0 29 0 0 0 0 1 0 188 acaweb_fx.pg_toast.pg_toast_5894610 1 0 29 0 1 0 0 1 1 7,917 acaweb_fx.public.backup_symbolgroup 1 0 28 0 1 0 33 1 1 4,685 acaweb_fx.public.stats_summary_emerging 1 0 34 0 2 0 0 1 0 257 acaweb_fx.public.latestquotes 1 0 36 0 1 0 0 1 1 3,369 acaweb_fx.public.stats_fibonaccipatterns_emerging_quantities 1 0 31 0 0 0 551 1 0 257 acaweb_fx.public.satelliteauthentication 1 0 33 0 0 0 0 1 0 257 acaweb_fx.public.t30_stock_split 1 0 31 0 0 0 296 1 1 8,073 acaweb_fx.public.patterns 1 0 53 0 0 0 0 1 0 257 acaweb_fx.public.autochartist_resultchanges 1 0 28 0 0 0 404 1 0 257 acaweb_fx.public.autochartist_symbolupdates 1 1 21,586 0 3,734 0 38,248 5,753 3,700 1,762,122 acaweb_fx.pg_toast.pg_toast_5883951 1 0 34 0 0 0 0 1 0 188 acaweb_fx.pg_catalog.pg_depend 1 1 405 0 83 0 59 192 64 328,945 acaweb_fx.public.positions 1 0 164 0 1 0 0 1 0 257 acaweb_fx.public.stats_tmp 1 0 28 0 1 0 1,157 2 0 329 acaweb_fx.public.powerstats_hourly_test 1 0 67 0 0 0 6,310 1 0 269 acaweb_fx.public.timezones_portuguese 1 0 13 0 0 0 0 1 0 257 acaweb_fx.public.exchanges 1 0 51 0 3 0 0 5 3 24,898 acaweb_fx.public.powerstats_daily_test 1 0 69 0 0 0 2,092 1 0 269 acaweb_fx.pg_toast.pg_toast_5882983 1 0 29 0 1 0 0 1 1 7,861 acaweb_fx.public.recognitionengineconfig 1 0 31 0 5 0 0 3 2 9,454 acaweb_fx.pg_toast.pg_toast_5883046 1 0 29 0 0 0 0 1 0 188 acaweb_fx.pg_toast.pg_toast_5883901 1 0 28 0 0 0 0 1 0 188 acaweb_fx.public.translationsmap 1 0 57 0 0 0 0 1 0 257 acaweb_fx.public.symbolexpectedpatterncount 1 0 51 0 1 0 391 2 1 6,520 acaweb_fx.pg_toast.pg_toast_5882587 1 0 29 0 0 0 0 1 0 188 acaweb_fx.public.sa_hist_highesthigh 1 0 52 0 0 0 0 1 0 257 acaweb_fx.public.symbolupdatetime 1 0 13 0 0 0 0 1 0 257 acaweb_fx_integer.pg_toast.pg_toast_51802 1 0 32 0 0 0 0 1 0 188 acaweb_fx.pg_toast.pg_toast_5883158 1 0 28 0 0 0 0 1 0 188 acaweb_fx.pg_toast.pg_toast_5883605 1 0 29 0 2 0 0 1 1 5,073 acaweb_fx.public.timezones_romanian 1 0 26 0 0 0 0 1 0 269 acaweb_fx.public.exchangesisodata 1 0 77 0 1 0 0 1 1 3,369 acaweb_fx.pg_toast.pg_toast_5882833 1 0 29 0 1 0 0 1 1 7,805 acaweb_fx.public.users 1 0 133 0 0 0 8,448 1 0 257 acaweb_fx.public.brokersymbollist 1 1 1,539 0 132 0 1,224 232 119 872,004 acaweb_fx.public.splits 1 0 29 0 1 0 0 1 1 6,853 acaweb_fx.public.broker_fibonaccipatterns 1 0 42 0 0 0 0 1 0 257 acaweb_fx.public.relevance_correlation_results 1 0 28 0 0 0 0 1 0 269 Total 340 56 91,607 75,914 9,001 19 602,887 25,828 9,330 25,804,122 Tuples removed per table
Key values
- public.solr_relevance_old (70412) Main table with removed tuples on database acaweb_fx
- 89287 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain acaweb_fx.public.solr_relevance_old 16 16 70,412 89,974 0 0 3,121 acaweb_fx.public.autochartist_symbolupdates 1 1 5,883 48,393 8 0 40,691 acaweb_fx.pg_catalog.pg_attribute 3 3 4,536 32,514 145 0 783 acaweb_fx.public.relevance_keylevels_results 3 3 2,478 36,915 1,268 0 837 acaweb_fx.pg_catalog.pg_depend 1 1 1,167 14,410 0 0 140 acaweb_fx.pg_catalog.pg_type 3 3 997 4,341 3 0 132 acaweb_fx.public.relevance_autochartist_results 2 2 833 17,581 421 0 760 acaweb_fx.pg_catalog.pg_statistic 1 1 641 3,642 0 0 1,194 acaweb_fx.public.brokersymbollist 1 1 577 191,489 0 0 1,342 acaweb_fx.pg_catalog.pg_class 3 3 395 4,952 5 0 450 acaweb_fx.public.relevance_fibonacci_results 3 3 234 5,118 247 0 306 acaweb_fx.public.datafeeds_latestrun 3 0 153 55 13 0 48 acaweb_fx.public.stats_symbols 1 1 150 131,894 0 0 1,271 acaweb_fx.public.instruments 1 1 149 12,168 0 0 125 acaweb_fx.pg_toast.pg_toast_2619 2 2 148 347 14 0 108 acaweb_fx.public.symbolgroup 1 1 123 311,805 0 0 2,248 acaweb_fx.public.latest_t15_candle_view 2 2 110 28 0 0 2 acaweb_fx.public.brokerdatafeedinstrumentlist 1 1 98 27,914 0 0 369 acaweb_fx.public.relevance_consecutivecandles_results 1 1 69 248 0 0 7 acaweb_fx.public.solr_imports 1 1 51 1 0 0 2 acaweb_fx.public.datafeedstimetable 1 1 32 516 0 0 8 acaweb_fx.public.groups 1 1 16 7,318 0 0 113 acaweb_fx.public.brokergroups 1 1 10 4,395 0 0 58 acaweb_fx.public.symbols 1 1 8 184,650 0 0 5,907 acaweb_fx.public.datafeed_restarter_events 1 1 7 10,752 0 0 371 acaweb_fx.public.brokerconfig 1 1 5 1,259 0 0 61 acaweb_fx.public.whatshot_groups 1 1 4 556 0 0 5 acaweb_fx.public.datafeeds 1 0 1 83 0 0 2 acaweb_fx.pg_toast.pg_toast_5894536 1 0 0 0 0 0 0 acaweb_fx.public.relevance_autochartist_results_hve 1 0 0 12,597 0 0 216 acaweb_fx.public.sa_hist_highesthigh60 1 0 0 0 0 0 0 acaweb_fx.public.stats_chartpatterns_emerging_quantities 1 0 0 14,987 0 0 212 acaweb_fx.public.usage_latestlogin 1 0 0 161,515 0 0 1,212 acaweb_fx.public.timezones_italian 1 0 0 405 0 0 3 acaweb_fx.public.dataversion 1 0 0 0 0 0 0 acaweb_fx.public.emailtemplate 1 0 0 0 0 0 0 acaweb_fx.public.powerstats_consecutivebearcandles 1 0 0 0 0 0 0 acaweb_fx.public.t15_hve 1 0 0 9,739,830 0 0 129,865 acaweb_fx.pg_toast.pg_toast_5882804 1 0 0 0 0 0 0 acaweb_fx.public.stats_hrs_tmp 1 0 0 124,466 0 0 1,058 acaweb_fx.public.futures_symbol_groups 1 0 0 0 0 0 0 acaweb_fx.public.autochartist_symbolupdates_new 1 0 0 0 0 0 0 acaweb_fx.public.market_report_results 1 0 0 0 0 0 0 acaweb_fx.public.autochartist_symbolupdates_20191017a 1 0 0 123,356 0 0 1,433 acaweb_fx.public.broker_clones 1 0 0 2 0 0 1 acaweb_fx.public.highesthighandlowestlow_results 1 0 0 0 0 0 0 acaweb_fx.public.usage_history 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5884020 1 0 0 0 0 0 0 acaweb_fx.public.default_corr_signals_symbols 1 0 0 0 0 0 0 acaweb_fx.public.sa_analysistypes 1 0 0 6 0 0 1 acaweb_fx.public.futures_symbols 1 0 0 1,080 0 0 12 acaweb_fx.public.positionserrors 1 0 0 0 0 0 0 acaweb_fx.public.broker_powerstats 1 0 0 1,102 0 0 6 acaweb_fx.public.japsticks_patterns 1 0 0 0 0 0 0 acaweb_fx.public.timezones_chinese_traditional 1 0 0 405 0 0 3 acaweb_fx.public.performancestats_latestrun 1 0 0 1 0 0 1 acaweb_fx.public.timezones_luxemburg 1 0 0 405 0 0 3 acaweb_fx.pg_toast.pg_toast_5894565 1 0 0 0 0 0 0 acaweb_fx.public.timezones_chinese_simplified 1 0 0 405 0 0 3 acaweb_fx.public.datafeedchecks 1 0 0 24 0 0 1 acaweb_fx.public.t60_stock_split 1 0 0 11,174 0 0 213 acaweb_fx.pg_toast.pg_toast_5882791 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5883895 1 0 0 0 0 0 0 acaweb_fx.public.best5trades 1 0 0 0 0 0 0 acaweb_fx.public.brokermt4authservers 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5894424 1 0 0 0 0 0 0 acaweb_fx.public.keylevelssearches 1 0 0 0 0 0 0 acaweb_fx.public.filters 1 0 0 2,425,892 0 0 30,418 acaweb_fx.public.server_loadavg 1 1 0 10,031 0 0 100 acaweb_fx.pg_toast.pg_toast_5882891 1 0 0 0 0 0 0 acaweb_fx.public.t5 1 0 0 506,435 0 0 7,011 acaweb_fx.archive.futures_rolled_over_futures 1 0 0 3 0 0 1 acaweb_fx.public.powerstats 1 0 0 0 0 0 0 acaweb_fx.public.v_datafeedinstrumentid 1 0 0 1 0 0 1 acaweb_fx.pg_toast.pg_toast_5882490 1 0 0 0 0 0 0 acaweb_fx.public.stats_fibonaccipatterns_complete_quantities 1 0 0 8,807 0 0 118 acaweb_fx.public.sa_hist_correlation 1 0 0 0 0 0 0 acaweb_fx.public.relevance_autochartist_results_old 1 0 0 466,390 0 0 9,877 acaweb_fx.public.powerstats_consecutivebullcandles 1 0 0 0 0 0 0 acaweb_fx.public.ss_marketreportresources 1 0 0 10,216 0 0 205 acaweb_fx.pg_toast.pg_toast_5882630 1 0 0 0 0 0 0 acaweb_fx.public.spcall 1 0 0 0 0 0 0 acaweb_fx.public.futures_rolled_over_futures 1 0 0 0 0 0 0 acaweb_fx.public.brokerusers 1 0 0 63,988 0 0 978 acaweb_fx.pg_toast.pg_toast_5883471 1 0 0 0 0 0 0 acaweb_fx.public.timezones_turkish 1 0 0 405 0 0 3 acaweb_fx.pg_toast.pg_toast_5882662 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5883002 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5882695 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5882995 1 0 0 0 0 0 0 acaweb_fx.public.t240_fps 1 0 0 0 0 0 0 acaweb_fx.public.translation_groupings 1 0 0 0 0 0 0 acaweb_fx_integer.public.latest_candle_datetime_per_receng 1 0 0 33 0 0 1 acaweb_fx.public.fibsearches 1 0 0 252,645 0 0 9,558 acaweb_fx.public.nd_test 1 0 0 11 0 0 1 acaweb_fx.public.patternresults_symbolupdates 1 0 0 29,518 0 0 253 acaweb_fx_integer.public.latest_t15_candle_view 1 0 0 31 0 0 1 acaweb_fx.public.sa_correlationsymbols 1 0 0 0 0 0 0 acaweb_fx.public.stats_chartpatterns_complete_quantities 1 0 0 15,022 0 0 215 acaweb_fx.public.t1440_fps 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5883457 1 0 0 0 0 0 0 acaweb_fx.public.futures_downloadersymbol 1 0 0 253 0 0 3 acaweb_fx.public.whatshot_pref 1 0 0 209,781 0 0 2,511 acaweb_fx.public.t60_fps 1 0 0 0 0 0 0 acaweb_fx.public.skrilltransactions 1 0 0 0 0 0 0 acaweb_fx.public.timezones_swedish 1 0 0 405 0 0 3 acaweb_fx.public.tmp_admiralusers 1 0 0 12,224 0 0 92 acaweb_fx.pg_toast.pg_toast_5883089 1 0 0 0 0 0 0 acaweb_fx.public.latestbrokerresults 1 0 0 229 0 0 2 acaweb_fx.public.correlation_results 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5883917 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5882480 1 0 0 0 0 0 0 acaweb_fx.public.timezones_dutch 1 0 0 405 0 0 3 acaweb_fx.public.t15_stock_split 1 0 0 24,948 0 0 478 acaweb_fx.public.brokerinstrumentmap 1 1 0 43,177 0 0 613 acaweb_fx.public.datafeedstimetable_history 1 0 0 101,163 0 0 1,121 acaweb_fx.pg_toast.pg_toast_5894713 1 0 0 0 0 0 0 acaweb_fx.public.keylevels_patternclasses 1 0 0 3 0 0 1 acaweb_fx.public.nd_broker_test 1 0 0 0 0 0 0 acaweb_fx.public.futures_brokersymbollist 1 0 0 0 0 0 0 acaweb_fx.public.keylevelspatterns 1 0 0 2 0 0 1 acaweb_fx.public.futures_symbol_frontmonth 1 0 0 25 0 0 1 acaweb_fx.public.currencypips 1 0 0 295 0 0 2 acaweb_fx.public.timezones_farsi 1 0 0 426 0 0 4 acaweb_fx.pg_toast.pg_toast_5883983 1 0 0 0 0 0 0 acaweb_fx.public.hrssearches 1 0 0 122,005 0 0 4,641 acaweb_fx.public.timezones_russian 1 0 0 405 0 0 4 acaweb_fx.public.symbolsconfig 1 0 0 0 0 0 0 acaweb_fx.public.exchanges_symbol_trading_times 1 0 0 0 0 0 0 acaweb_fx.public.fibonacci_results_relevance 1 0 0 512,572 0 0 17,627 acaweb_fx.public.powerstats_trumpet_test 1 0 0 5,305,182 0 0 113,673 acaweb_fx.pg_toast.pg_toast_5882414 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5882871 1 0 0 0 0 0 0 acaweb_fx.public.backup_groups 1 0 0 141 0 0 2 acaweb_fx.pg_toast.pg_toast_5894654 1 0 0 0 0 0 0 acaweb_fx.public.v_serverdays 1 0 0 1 0 0 1 acaweb_fx.public.tmp_nd 1 0 0 563 0 0 3 acaweb_fx.pg_toast.pg_toast_5882330 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5894500 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5882900 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5882907 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5883887 1 0 0 0 0 0 0 acaweb_fx.public.timezones_korean 1 0 0 405 0 0 4 acaweb_fx.pg_toast.pg_toast_5882469 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5883592 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5883167 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5883062 1 0 0 0 0 0 0 acaweb_fx.public.datafeedinstrumentmappingconfig 1 0 0 23 0 0 1 acaweb_fx.pg_toast.pg_toast_5882566 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5882935 1 0 0 0 0 0 0 acaweb_fx.public.timezones_greek 1 0 0 405 0 0 4 acaweb_fx.pg_toast.pg_toast_5882927 1 0 0 0 0 0 0 acaweb_fx.public.ws_symbols_temp 1 0 0 6,820 0 0 139 acaweb_fx.public.translation_placeholder_examples 1 0 0 0 0 0 0 acaweb_fx.public.t1440_stock_split 1 0 0 5,429 0 0 106 acaweb_fx.import.historicaldatadump 1 0 0 1,871,842 0 0 23,175 acaweb_fx.public.fibonaccipatterns 1 0 0 6 0 0 1 acaweb_fx_integer.public.solr_relevance_old 1 0 0 26,018 0 0 632 acaweb_fx.public.translation_groups 1 0 0 0 0 0 0 acaweb_fx.public.timezones 1 0 0 426 0 0 12 acaweb_fx.pg_toast.pg_toast_5883448 1 0 0 0 0 0 0 acaweb_fx.public.broker_mt4group 1 0 0 1,623 0 0 39 acaweb_fx.public.performancestats_satellites 1 0 0 2 0 0 1 acaweb_fx.public.hrs_results 1 0 0 0 0 0 0 acaweb_fx.public.whatshot_correlatingsignals 1 0 0 0 0 0 0 acaweb_fx.public.researchreports 1 0 0 318,073 0 0 5,080 acaweb_fx.public.satelliteservers 1 0 0 5 0 0 1 acaweb_fx.public.powerstats_consecutivebulldistribution 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5883082 1 0 0 0 0 0 0 acaweb_fx.public.autochartist_latestrun 1 0 0 55 0 0 1 acaweb_fx.public.timezones_french 1 0 0 405 0 0 3 acaweb_fx.public.backup_brokergroups 1 0 0 141 0 0 2 acaweb_fx.pg_toast.pg_toast_5894331 1 0 0 0 0 0 0 acaweb_fx.public.powerstats_avgmovement 1 0 0 0 0 0 0 acaweb_fx.public.organisationexchangepermissions 1 0 0 332 0 0 2 acaweb_fx.public.futures_brokerinstrumentmapping 1 0 0 0 0 0 0 acaweb_fx.public.solr_groupnames 1 0 0 87,318 0 0 2,483 acaweb_fx.public.relevance_japsticks_results 1 0 0 0 0 0 0 acaweb_fx.public.geoip 1 0 0 106,078 0 0 1,231 acaweb_fx_integer.pg_toast.pg_toast_52893 1 0 0 0 0 0 0 acaweb_fx.public.datafeeds_kinesis_run 1 0 0 8 0 0 1 acaweb_fx.pg_toast.pg_toast_5894595 1 0 0 0 0 0 0 acaweb_fx.public.whatshot_archive 1 0 0 0 0 0 0 acaweb_fx.public.timezones_hungarian 1 0 0 405 0 0 3 acaweb_fx.public.futures_symbol_templates 1 0 0 27 0 0 1 acaweb_fx.pg_toast.pg_toast_5882783 1 0 0 0 0 0 0 acaweb_fx.public.whatshot_archive_probability 1 0 0 0 0 0 0 acaweb_fx.public.timezones_japanese 1 0 0 405 0 0 4 acaweb_fx.public.symbols_preprocessed_newsymbols 1 0 0 0 0 0 0 acaweb_fx.public.powerstats_consecutivebeardistribution 1 0 0 0 0 0 0 acaweb_fx.public.powerstats_avgmovementperdayofweek 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5882602 1 0 0 0 0 0 0 acaweb_fx.public.patternresultsrelevance_types 1 0 0 6 0 0 1 acaweb_fx.pg_toast.pg_toast_5883315 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5894669 1 0 0 0 0 0 0 acaweb_fx.public.intervalperiods 1 0 0 175 0 0 2 acaweb_fx.public.v_datafeed_timezone 1 0 0 1 0 0 1 acaweb_fx.archive.whatshot_correlatingsignals 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5883907 1 0 0 0 0 0 0 acaweb_fx.public.hve_correlating_signals 1 0 0 2,507 0 0 36 acaweb_fx.pg_toast.pg_toast_5882671 1 0 0 0 0 0 0 acaweb_fx.public.t15_fps 1 0 0 0 0 0 0 acaweb_fx.public.cpsearches 1 0 0 559,867 0 0 24,618 acaweb_fx.public.broker_datafeeds_old 1 0 0 281 0 0 3 acaweb_fx.public.ac_emerging_unique 1 0 0 317,551 0 0 1,408 acaweb_fx.public.relevance_fibonacci_results_old 1 0 0 110,483 0 0 3,495 acaweb_fx.public.disableddelete 1 0 0 28 0 0 1 acaweb_fx.public.whatshot_archive_correlatingsignals 1 0 0 0 0 0 0 acaweb_fx.public.relevance_highesthighandlowestlow_results 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5883483 1 0 0 0 0 0 0 acaweb_fx.public.relevance_keylevels_results_old 1 0 0 204,628 0 0 3,390 acaweb_fx.public.relevance_bigmovement_results_old 1 0 0 2,199 0 0 28 acaweb_fx.public.t240_stock_split 1 0 0 10,175 0 0 194 acaweb_fx.public.futures_month_code 1 0 0 12 0 0 1 acaweb_fx.pg_toast.pg_toast_5883432 1 0 0 0 0 0 0 acaweb_fx.public.datafeeds_metadata 1 0 0 7 0 0 1 acaweb_fx.public.fxdd 1 0 0 20 0 0 1 acaweb_fx.public.datafeedinstruments 1 0 0 15,343 0 0 299 acaweb_fx.public.sa_analysistypesintervals 1 0 0 13 0 0 1 acaweb_fx.pg_toast.pg_toast_5883380 1 0 0 434,147 0 0 108,533 acaweb_fx.pg_toast.pg_toast_5882551 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5883875 1 0 0 0 0 0 0 acaweb_fx.public.genericsearches 1 0 0 0 0 0 0 acaweb_fx.public.autochartist_datareload 1 0 0 55 0 0 1 acaweb_fx.public.language_locales 1 0 0 2 0 0 1 acaweb_fx.public.v_frontmonth_downloadersymbol 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5882706 1 0 0 0 0 0 0 acaweb_fx.public.timezones_arabic 1 0 0 405 0 0 4 acaweb_fx.public.latestspruntime 1 0 0 240,462 0 0 2,084 acaweb_fx.public.usersessions 1 0 0 0 0 0 0 acaweb_fx.public.translation_keys 1 0 0 1 0 0 1 acaweb_fx.pg_toast.pg_toast_5883500 1 0 0 0 0 0 0 acaweb_fx.public.powerstats_intervals 1 0 0 480 0 0 3 acaweb_fx.pg_toast.pg_toast_5882825 1 0 0 0 0 0 0 acaweb_fx.public.timezones_indonesian 1 0 0 426 0 0 3 acaweb_fx.public.usertimezones 1 0 0 0 0 0 0 acaweb_fx_integer.archive.fibonacci_results 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5883688 1 0 0 0 0 0 0 acaweb_fx.public.translations 1 0 0 2 0 0 1 acaweb_fx.public.cachedump 1 0 0 0 0 0 0 acaweb_fx.public.t30_fps 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5894580 1 0 0 0 0 0 0 acaweb_fx.public.translation_types 1 0 0 1 0 0 1 acaweb_fx.public.marketreportsubscriptions 1 0 0 12 0 0 1 acaweb_fx.public.timezones_polish 1 0 0 405 0 0 3 acaweb_fx.pg_toast.pg_toast_5883867 1 0 0 0 0 0 0 acaweb_fx.public.v_statsid 1 0 0 0 0 0 0 acaweb_fx.public.futures_symbol_codes 1 0 0 0 0 0 0 acaweb_fx.public.iqfeedsymbollist_test 1 0 0 1,000 0 0 5 acaweb_fx.pg_toast.pg_toast_5882964 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5882812 1 0 0 0 0 0 0 acaweb_fx.public.keylevels_results_relevance 1 0 0 606,658 0 0 17,622 acaweb_fx.public.downloadersymbolsettings_rest 1 0 0 20,219 0 0 372 acaweb_fx.pg_toast.pg_toast_5882853 1 0 0 0 0 0 0 acaweb_fx.public.timezones_german 1 0 0 405 0 0 3 acaweb_fx.public.powerstats_avgmovementintervalperday 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5882542 1 0 0 0 0 0 0 acaweb_fx.public.intervals 1 0 0 6 0 0 1 acaweb_fx.pg_toast.pg_toast_5882955 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5883148 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5883881 1 0 0 0 0 0 0 acaweb_fx.public.timezones_spanish 1 0 0 405 0 0 3 acaweb_fx.public.users_old 1 0 0 312,347 0 0 4,674 acaweb_fx.pg_toast.pg_toast_5894684 1 0 0 0 0 0 0 acaweb_fx.public.fxdd_adminusers 1 0 0 4 0 0 1 acaweb_fx.public.stats_summary_emerging_2d 1 0 0 0 0 0 0 acaweb_fx.public.powerstats_avgmovementperhour 1 0 0 0 0 0 0 acaweb_fx.public.translations_history 1 0 0 0 0 0 0 acaweb_fx.public.fxdd_users 1 0 0 1,645 0 0 23 acaweb_fx.public.japsticks_results 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5883937 1 0 0 0 0 0 0 acaweb_fx.public.hrspatterns 1 0 0 2 0 0 1 acaweb_fx.pg_toast.pg_toast_5882741 1 0 0 0 0 0 0 acaweb_fx.public.symbolchanges 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5894625 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5894610 1 0 0 0 0 0 0 acaweb_fx.public.backup_symbolgroup 1 0 0 3,254 0 0 34 acaweb_fx.public.stats_summary_emerging 1 0 0 0 0 0 0 acaweb_fx.public.latestquotes 1 0 0 0 0 0 0 acaweb_fx.public.stats_fibonaccipatterns_emerging_quantities 1 0 0 39,758 0 0 552 acaweb_fx.public.satelliteauthentication 1 0 0 15 0 0 1 acaweb_fx.public.t30_stock_split 1 0 0 15,468 0 0 297 acaweb_fx.public.patterns 1 0 0 16 0 0 1 acaweb_fx.public.autochartist_resultchanges 1 0 0 74,687 0 0 405 acaweb_fx.pg_toast.pg_toast_5883951 1 0 0 0 0 0 0 acaweb_fx.public.positions 1 0 0 0 0 0 0 acaweb_fx.public.stats_tmp 1 0 0 135,131 0 0 1,158 acaweb_fx.public.powerstats_hourly_test 1 0 0 567,998 0 0 6,311 acaweb_fx.public.timezones_portuguese 1 0 0 405 0 0 3 acaweb_fx.public.exchanges 1 0 0 129 0 0 3 acaweb_fx.public.powerstats_daily_test 1 0 0 188,351 0 0 2,093 acaweb_fx.pg_toast.pg_toast_5882983 1 0 0 0 0 0 0 acaweb_fx.public.recognitionengineconfig 1 0 0 86 0 0 2 acaweb_fx.pg_toast.pg_toast_5883046 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5883901 1 0 0 0 0 0 0 acaweb_fx.public.translationsmap 1 0 0 0 0 0 0 acaweb_fx.public.symbolexpectedpatterncount 1 0 0 46,050 0 0 392 acaweb_fx.pg_toast.pg_toast_5882587 1 0 0 0 0 0 0 acaweb_fx.public.sa_hist_highesthigh 1 0 0 0 0 0 0 acaweb_fx.public.symbolupdatetime 1 0 0 0 0 0 0 acaweb_fx_integer.pg_toast.pg_toast_51802 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5883158 1 0 0 0 0 0 0 acaweb_fx.pg_toast.pg_toast_5883605 1 0 0 0 0 0 0 acaweb_fx.public.timezones_romanian 1 0 0 426 0 0 3 acaweb_fx.public.exchangesisodata 1 0 0 1,127 0 0 26 acaweb_fx.pg_toast.pg_toast_5882833 1 0 0 0 0 0 0 acaweb_fx.public.users 1 0 0 466,027 0 0 8,449 acaweb_fx.public.splits 1 0 0 0 0 0 0 acaweb_fx.public.broker_fibonaccipatterns 1 0 0 12 0 0 1 acaweb_fx.public.relevance_correlation_results 1 0 0 0 0 0 0 Total 340 56 89,287 28,266,287 2,124 0 613,709 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Pages removed per tables
NO DATASET
Table Number of vacuums Index scans Tuples removed Pages removed acaweb_fx.pg_toast.pg_toast_5894536 1 0 0 0 acaweb_fx.public.relevance_autochartist_results_hve 1 0 0 0 acaweb_fx.public.sa_hist_highesthigh60 1 0 0 0 acaweb_fx.public.stats_chartpatterns_emerging_quantities 1 0 0 0 acaweb_fx.public.usage_latestlogin 1 0 0 0 acaweb_fx.public.timezones_italian 1 0 0 0 acaweb_fx.public.dataversion 1 0 0 0 acaweb_fx.public.emailtemplate 1 0 0 0 acaweb_fx.public.powerstats_consecutivebearcandles 1 0 0 0 acaweb_fx.public.t15_hve 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882804 1 0 0 0 acaweb_fx.public.stats_hrs_tmp 1 0 0 0 acaweb_fx.public.futures_symbol_groups 1 0 0 0 acaweb_fx.public.autochartist_symbolupdates_new 1 0 0 0 acaweb_fx.public.market_report_results 1 0 0 0 acaweb_fx.public.autochartist_symbolupdates_20191017a 1 0 0 0 acaweb_fx.public.solr_relevance_old 16 16 70412 0 acaweb_fx.public.broker_clones 1 0 0 0 acaweb_fx.public.highesthighandlowestlow_results 1 0 0 0 acaweb_fx.public.usage_history 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5884020 1 0 0 0 acaweb_fx.public.latest_t15_candle_view 2 2 110 0 acaweb_fx.public.default_corr_signals_symbols 1 0 0 0 acaweb_fx.public.groups 1 1 16 0 acaweb_fx.public.sa_analysistypes 1 0 0 0 acaweb_fx.public.futures_symbols 1 0 0 0 acaweb_fx.public.positionserrors 1 0 0 0 acaweb_fx.public.broker_powerstats 1 0 0 0 acaweb_fx.public.japsticks_patterns 1 0 0 0 acaweb_fx.public.timezones_chinese_traditional 1 0 0 0 acaweb_fx.public.performancestats_latestrun 1 0 0 0 acaweb_fx.public.timezones_luxemburg 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5894565 1 0 0 0 acaweb_fx.public.timezones_chinese_simplified 1 0 0 0 acaweb_fx.public.datafeedchecks 1 0 0 0 acaweb_fx.public.t60_stock_split 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882791 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883895 1 0 0 0 acaweb_fx.public.best5trades 1 0 0 0 acaweb_fx.public.brokermt4authservers 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5894424 1 0 0 0 acaweb_fx.public.keylevelssearches 1 0 0 0 acaweb_fx.public.filters 1 0 0 0 acaweb_fx.public.server_loadavg 1 1 0 0 acaweb_fx.pg_toast.pg_toast_5882891 1 0 0 0 acaweb_fx.public.t5 1 0 0 0 acaweb_fx.archive.futures_rolled_over_futures 1 0 0 0 acaweb_fx.public.powerstats 1 0 0 0 acaweb_fx.public.v_datafeedinstrumentid 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882490 1 0 0 0 acaweb_fx.public.stats_fibonaccipatterns_complete_quantities 1 0 0 0 acaweb_fx.public.sa_hist_correlation 1 0 0 0 acaweb_fx.public.relevance_autochartist_results_old 1 0 0 0 acaweb_fx.public.powerstats_consecutivebullcandles 1 0 0 0 acaweb_fx.public.ss_marketreportresources 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882630 1 0 0 0 acaweb_fx.public.spcall 1 0 0 0 acaweb_fx.public.futures_rolled_over_futures 1 0 0 0 acaweb_fx.public.brokerusers 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883471 1 0 0 0 acaweb_fx.public.timezones_turkish 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882662 1 0 0 0 acaweb_fx.public.relevance_consecutivecandles_results 1 1 69 0 acaweb_fx.pg_toast.pg_toast_5883002 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882695 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882995 1 0 0 0 acaweb_fx.public.t240_fps 1 0 0 0 acaweb_fx.public.translation_groupings 1 0 0 0 acaweb_fx.public.stats_symbols 1 1 150 0 acaweb_fx_integer.public.latest_candle_datetime_per_receng 1 0 0 0 acaweb_fx.public.fibsearches 1 0 0 0 acaweb_fx.public.nd_test 1 0 0 0 acaweb_fx.public.patternresults_symbolupdates 1 0 0 0 acaweb_fx_integer.public.latest_t15_candle_view 1 0 0 0 acaweb_fx.public.sa_correlationsymbols 1 0 0 0 acaweb_fx.public.stats_chartpatterns_complete_quantities 1 0 0 0 acaweb_fx.public.t1440_fps 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883457 1 0 0 0 acaweb_fx.public.futures_downloadersymbol 1 0 0 0 acaweb_fx.public.whatshot_pref 1 0 0 0 acaweb_fx.public.t60_fps 1 0 0 0 acaweb_fx.public.skrilltransactions 1 0 0 0 acaweb_fx.public.timezones_swedish 1 0 0 0 acaweb_fx.public.tmp_admiralusers 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883089 1 0 0 0 acaweb_fx.public.latestbrokerresults 1 0 0 0 acaweb_fx.public.correlation_results 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883917 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882480 1 0 0 0 acaweb_fx.public.timezones_dutch 1 0 0 0 acaweb_fx.public.t15_stock_split 1 0 0 0 acaweb_fx.public.brokerinstrumentmap 1 1 0 0 acaweb_fx.public.datafeedstimetable_history 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5894713 1 0 0 0 acaweb_fx.public.keylevels_patternclasses 1 0 0 0 acaweb_fx.public.nd_broker_test 1 0 0 0 acaweb_fx.public.futures_brokersymbollist 1 0 0 0 acaweb_fx.public.keylevelspatterns 1 0 0 0 acaweb_fx.public.futures_symbol_frontmonth 1 0 0 0 acaweb_fx.public.currencypips 1 0 0 0 acaweb_fx.public.timezones_farsi 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883983 1 0 0 0 acaweb_fx.public.hrssearches 1 0 0 0 acaweb_fx.public.brokerconfig 1 1 5 0 acaweb_fx.public.timezones_russian 1 0 0 0 acaweb_fx.public.symbolsconfig 1 0 0 0 acaweb_fx.public.exchanges_symbol_trading_times 1 0 0 0 acaweb_fx.public.symbolgroup 1 1 123 0 acaweb_fx.public.fibonacci_results_relevance 1 0 0 0 acaweb_fx.public.powerstats_trumpet_test 1 0 0 0 acaweb_fx.pg_catalog.pg_class 3 3 395 0 acaweb_fx.pg_toast.pg_toast_5882414 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882871 1 0 0 0 acaweb_fx.public.backup_groups 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5894654 1 0 0 0 acaweb_fx.public.v_serverdays 1 0 0 0 acaweb_fx.public.tmp_nd 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882330 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5894500 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882900 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882907 1 0 0 0 acaweb_fx.public.datafeeds_latestrun 3 0 153 0 acaweb_fx.pg_toast.pg_toast_5883887 1 0 0 0 acaweb_fx.pg_catalog.pg_attribute 3 3 4536 0 acaweb_fx.public.timezones_korean 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882469 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883592 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883167 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883062 1 0 0 0 acaweb_fx.public.whatshot_groups 1 1 4 0 acaweb_fx.pg_catalog.pg_statistic 1 1 641 0 acaweb_fx.public.datafeedinstrumentmappingconfig 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882566 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882935 1 0 0 0 acaweb_fx.public.timezones_greek 1 0 0 0 acaweb_fx.public.brokerdatafeedinstrumentlist 1 1 98 0 acaweb_fx.pg_toast.pg_toast_5882927 1 0 0 0 acaweb_fx.public.ws_symbols_temp 1 0 0 0 acaweb_fx.public.datafeedstimetable 1 1 32 0 acaweb_fx.public.translation_placeholder_examples 1 0 0 0 acaweb_fx.public.t1440_stock_split 1 0 0 0 acaweb_fx.import.historicaldatadump 1 0 0 0 acaweb_fx.public.fibonaccipatterns 1 0 0 0 acaweb_fx_integer.public.solr_relevance_old 1 0 0 0 acaweb_fx.public.translation_groups 1 0 0 0 acaweb_fx.public.timezones 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883448 1 0 0 0 acaweb_fx.public.broker_mt4group 1 0 0 0 acaweb_fx.public.performancestats_satellites 1 0 0 0 acaweb_fx.public.relevance_fibonacci_results 3 3 234 0 acaweb_fx.public.hrs_results 1 0 0 0 acaweb_fx.public.whatshot_correlatingsignals 1 0 0 0 acaweb_fx.public.researchreports 1 0 0 0 acaweb_fx.public.satelliteservers 1 0 0 0 acaweb_fx.public.powerstats_consecutivebulldistribution 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883082 1 0 0 0 acaweb_fx.public.autochartist_latestrun 1 0 0 0 acaweb_fx.public.timezones_french 1 0 0 0 acaweb_fx.public.backup_brokergroups 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5894331 1 0 0 0 acaweb_fx.public.powerstats_avgmovement 1 0 0 0 acaweb_fx.public.organisationexchangepermissions 1 0 0 0 acaweb_fx.public.futures_brokerinstrumentmapping 1 0 0 0 acaweb_fx.public.solr_groupnames 1 0 0 0 acaweb_fx.public.relevance_japsticks_results 1 0 0 0 acaweb_fx.public.geoip 1 0 0 0 acaweb_fx_integer.pg_toast.pg_toast_52893 1 0 0 0 acaweb_fx.public.solr_imports 1 1 51 0 acaweb_fx.public.instruments 1 1 149 0 acaweb_fx.public.datafeeds_kinesis_run 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5894595 1 0 0 0 acaweb_fx.public.whatshot_archive 1 0 0 0 acaweb_fx.public.timezones_hungarian 1 0 0 0 acaweb_fx.public.futures_symbol_templates 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882783 1 0 0 0 acaweb_fx.public.whatshot_archive_probability 1 0 0 0 acaweb_fx.public.timezones_japanese 1 0 0 0 acaweb_fx.public.symbols_preprocessed_newsymbols 1 0 0 0 acaweb_fx.public.powerstats_consecutivebeardistribution 1 0 0 0 acaweb_fx.public.powerstats_avgmovementperdayofweek 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882602 1 0 0 0 acaweb_fx.public.patternresultsrelevance_types 1 0 0 0 acaweb_fx.public.brokergroups 1 1 10 0 acaweb_fx.public.symbols 1 1 8 0 acaweb_fx.pg_toast.pg_toast_5883315 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5894669 1 0 0 0 acaweb_fx.public.intervalperiods 1 0 0 0 acaweb_fx.public.v_datafeed_timezone 1 0 0 0 acaweb_fx.archive.whatshot_correlatingsignals 1 0 0 0 acaweb_fx.public.datafeeds 1 0 1 0 acaweb_fx.pg_toast.pg_toast_5883907 1 0 0 0 acaweb_fx.public.hve_correlating_signals 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882671 1 0 0 0 acaweb_fx.public.t15_fps 1 0 0 0 acaweb_fx.public.cpsearches 1 0 0 0 acaweb_fx.public.broker_datafeeds_old 1 0 0 0 acaweb_fx.public.ac_emerging_unique 1 0 0 0 acaweb_fx.public.relevance_fibonacci_results_old 1 0 0 0 acaweb_fx.public.disableddelete 1 0 0 0 acaweb_fx.public.whatshot_archive_correlatingsignals 1 0 0 0 acaweb_fx.public.relevance_highesthighandlowestlow_results 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883483 1 0 0 0 acaweb_fx.public.relevance_keylevels_results_old 1 0 0 0 acaweb_fx.public.relevance_bigmovement_results_old 1 0 0 0 acaweb_fx.public.t240_stock_split 1 0 0 0 acaweb_fx.public.futures_month_code 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883432 1 0 0 0 acaweb_fx.public.datafeeds_metadata 1 0 0 0 acaweb_fx.public.fxdd 1 0 0 0 acaweb_fx.public.datafeedinstruments 1 0 0 0 acaweb_fx.public.sa_analysistypesintervals 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883380 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882551 1 0 0 0 acaweb_fx.public.datafeed_restarter_events 1 1 7 0 acaweb_fx.pg_toast.pg_toast_5883875 1 0 0 0 acaweb_fx.public.genericsearches 1 0 0 0 acaweb_fx.public.autochartist_datareload 1 0 0 0 acaweb_fx.public.language_locales 1 0 0 0 acaweb_fx.public.v_frontmonth_downloadersymbol 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882706 1 0 0 0 acaweb_fx.public.timezones_arabic 1 0 0 0 acaweb_fx.public.latestspruntime 1 0 0 0 acaweb_fx.public.usersessions 1 0 0 0 acaweb_fx.public.translation_keys 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883500 1 0 0 0 acaweb_fx.public.powerstats_intervals 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882825 1 0 0 0 acaweb_fx.public.timezones_indonesian 1 0 0 0 acaweb_fx.public.usertimezones 1 0 0 0 acaweb_fx_integer.archive.fibonacci_results 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883688 1 0 0 0 acaweb_fx.public.translations 1 0 0 0 acaweb_fx.public.cachedump 1 0 0 0 acaweb_fx.public.t30_fps 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5894580 1 0 0 0 acaweb_fx.public.translation_types 1 0 0 0 acaweb_fx.public.marketreportsubscriptions 1 0 0 0 acaweb_fx.public.timezones_polish 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883867 1 0 0 0 acaweb_fx.public.v_statsid 1 0 0 0 acaweb_fx.public.futures_symbol_codes 1 0 0 0 acaweb_fx.public.iqfeedsymbollist_test 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882964 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882812 1 0 0 0 acaweb_fx.public.keylevels_results_relevance 1 0 0 0 acaweb_fx.public.downloadersymbolsettings_rest 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882853 1 0 0 0 acaweb_fx.pg_catalog.pg_type 3 3 997 0 acaweb_fx.public.timezones_german 1 0 0 0 acaweb_fx.public.powerstats_avgmovementintervalperday 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882542 1 0 0 0 acaweb_fx.public.intervals 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882955 1 0 0 0 acaweb_fx.pg_toast.pg_toast_2619 2 2 148 0 acaweb_fx.pg_toast.pg_toast_5883148 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883881 1 0 0 0 acaweb_fx.public.timezones_spanish 1 0 0 0 acaweb_fx.public.users_old 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5894684 1 0 0 0 acaweb_fx.public.fxdd_adminusers 1 0 0 0 acaweb_fx.public.stats_summary_emerging_2d 1 0 0 0 acaweb_fx.public.powerstats_avgmovementperhour 1 0 0 0 acaweb_fx.public.translations_history 1 0 0 0 acaweb_fx.public.fxdd_users 1 0 0 0 acaweb_fx.public.japsticks_results 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883937 1 0 0 0 acaweb_fx.public.hrspatterns 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882741 1 0 0 0 acaweb_fx.public.symbolchanges 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5894625 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5894610 1 0 0 0 acaweb_fx.public.backup_symbolgroup 1 0 0 0 acaweb_fx.public.stats_summary_emerging 1 0 0 0 acaweb_fx.public.latestquotes 1 0 0 0 acaweb_fx.public.stats_fibonaccipatterns_emerging_quantities 1 0 0 0 acaweb_fx.public.satelliteauthentication 1 0 0 0 acaweb_fx.public.t30_stock_split 1 0 0 0 acaweb_fx.public.patterns 1 0 0 0 acaweb_fx.public.autochartist_resultchanges 1 0 0 0 acaweb_fx.public.autochartist_symbolupdates 1 1 5883 0 acaweb_fx.pg_toast.pg_toast_5883951 1 0 0 0 acaweb_fx.pg_catalog.pg_depend 1 1 1167 0 acaweb_fx.public.positions 1 0 0 0 acaweb_fx.public.stats_tmp 1 0 0 0 acaweb_fx.public.relevance_keylevels_results 3 3 2478 0 acaweb_fx.public.powerstats_hourly_test 1 0 0 0 acaweb_fx.public.timezones_portuguese 1 0 0 0 acaweb_fx.public.exchanges 1 0 0 0 acaweb_fx.public.powerstats_daily_test 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882983 1 0 0 0 acaweb_fx.public.recognitionengineconfig 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883046 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883901 1 0 0 0 acaweb_fx.public.translationsmap 1 0 0 0 acaweb_fx.public.symbolexpectedpatterncount 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882587 1 0 0 0 acaweb_fx.public.sa_hist_highesthigh 1 0 0 0 acaweb_fx.public.symbolupdatetime 1 0 0 0 acaweb_fx.public.relevance_autochartist_results 2 2 833 0 acaweb_fx_integer.pg_toast.pg_toast_51802 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883158 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5883605 1 0 0 0 acaweb_fx.public.timezones_romanian 1 0 0 0 acaweb_fx.public.exchangesisodata 1 0 0 0 acaweb_fx.pg_toast.pg_toast_5882833 1 0 0 0 acaweb_fx.public.users 1 0 0 0 acaweb_fx.public.brokersymbollist 1 1 577 0 acaweb_fx.public.splits 1 0 0 0 acaweb_fx.public.broker_fibonaccipatterns 1 0 0 0 acaweb_fx.public.relevance_correlation_results 1 0 0 0 Total 340 56 89,287 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Feb 12 01 340 61 - 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
- 42,205 Total read queries
- 31,884 Total write queries
Queries by database
Key values
- unknown Main database
- 157,669 Requests
- 2h25m54s (unknown)
- Main time consuming database
Database Request type Count Duration acaweb_fx Total 858 0ms copy from 80 0ms copy to 26 0ms cte 104 0ms ddl 16 0ms delete 16 0ms others 173 0ms select 72 0ms tcl 331 0ms update 40 0ms socialmedia Total 82 0ms select 70 0ms tcl 12 0ms unknown Total 157,669 2h25m54s copy from 16 0ms cte 5,530 0ms insert 23,876 0ms others 5,043 0ms select 42,063 0ms tcl 465 0ms update 1,372 0ms Queries by user
Key values
- unknown Main user
- 157,669 Requests
User Request type Count Duration postgres Total 940 0ms copy from 80 0ms copy to 26 0ms cte 104 0ms ddl 16 0ms delete 16 0ms others 173 0ms select 142 0ms tcl 343 0ms update 40 0ms unknown Total 157,669 2h25m54s copy from 16 0ms cte 5,530 0ms insert 23,876 0ms others 5,043 0ms select 42,063 0ms tcl 465 0ms update 1,372 0ms Duration by user
Key values
- 2h25m54s (unknown) Main time consuming user
User Request type Count Duration postgres Total 940 0ms copy from 80 0ms copy to 26 0ms cte 104 0ms ddl 16 0ms delete 16 0ms others 173 0ms select 142 0ms tcl 343 0ms update 40 0ms unknown Total 157,669 2h25m54s copy from 16 0ms cte 5,530 0ms insert 23,876 0ms others 5,043 0ms select 42,063 0ms tcl 465 0ms update 1,372 0ms Queries by host
Key values
- unknown Main host
- 158,609 Requests
- 2h25m54s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 158,251 Requests
- 2h25m54s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-02-12 01:59:13 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 53,477 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 11 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 #1
Day Hour Count Duration Avg duration Feb 12 01 11 0ms 0ms 2 0ms 273 0ms 0ms 0ms with rar_max as ( select resultuid from relevance_consecutivecandles_results order by resultuid desc limit ? ), all_results as ( select ccr.resultuid as resultuid, ccr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, ccr.patternendtime as identified, dtt.timezone as timezone, ccr.qtyconsecutivecandles as length, g.basegroupname, case when rcr.age is not null then rcr.age when ccr.resultuid <= rm.resultuid then ? else ? end as age, case when rcr.relevant is not null then rcr.relevant when ccr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip, newlevels.filtered from consecutivecandles_results ccr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = ccr.symbolid inner join symbols s on ccr.symbolid = s.symbolid and s.nonliquid = ? inner join downloadersymbolsettings dss on ccr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on ccr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join rar_max rm on ? = ? left outer join relevance_consecutivecandles_results rcr on rcr.resultuid = ccr.resultuid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? left join lateral calc_cc_signal_filter (ccr.resultuid) newlevels on true where ccr.gmttimefound > now() - interval ? and s.deleted = ? and (ccr.simulation = ? or ccr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ccr.patternlengthbars <= ?) ), 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 #2
Day Hour Count Duration Avg duration Feb 12 01 273 0ms 0ms 3 0ms 51 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 Feb 12 01 51 0ms 0ms 4 0ms 2,496 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 Feb 12 01 2,496 0ms 0ms 5 0ms 4 0ms 0ms 0ms select psd.symbolid, psd.hourlysymbolid as intervalsymbolid, s.symbol, dtt.timezone, dtt.absolutetimezoneoffset, psh.hour as index, psh.ave, psh.stddev, (psh.ave - psh.stddev / ?.?) as low, (psh.ave + psh.stddev / ?.?) as high, ee.timezone as exchangetimezone, ee.mon_t1start as exchangestart, ee.mon_t1end as exchangeend from powerstats_symboldata psd inner join powerstats_hourly psh on psd.hourlysymbolid = psh.symbolid inner join symbols s on psh.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join mat_ps_hourly_symbolid_max_enddate e on psh.enddate = e.enddate and psh.symbolid = e.symbolid inner join exchanges ee on ee.exchange = s.exchange where psd.symbolid = ? and dtt.dayofweek = ? order by hour asc;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Feb 12 01 4 0ms 0ms 6 0ms 183 0ms 0ms 0ms select case when a.old_resultuid = ? then a.old_resultuid else a.resultuid end as resultuid, s.symbol, timegranularity as interval, direction as direction, patternendtime as patternendtime, patternstartprice as psp, patternendprice as pep, target03 as t03, target16 as t16, patternlengthbars as length, p.patternname as patternname, dtt.timezone, cps.pip 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 left join currencypips cps on cps.symbol = s.symbol where (a.old_resultuid = ? or a.resultuid = ?) and dtt.dayofweek = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Feb 12 01 183 0ms 0ms 7 0ms 4 0ms 0ms 0ms select updaterelevantforrelevantresults ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Feb 12 01 4 0ms 0ms 8 0ms 957 0ms 0ms 0ms update patternresultsrelevance set relevant = ?, saxo_relevant = ?, notrelevantpricedatetime = ?, reason = ? where uniqueindex = ? and relevant = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Feb 12 01 957 0ms 0ms 9 0ms 1 0ms 0ms 0ms insert into resultmedia (processresultsid, type, name, filename) values (?, ?, ?, ?) returning id;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Feb 12 01 1 0ms 0ms 10 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 #10
Day Hour Count Duration Avg duration Feb 12 01 18 0ms 0ms 11 0ms 239 0ms 0ms 0ms select v.datname, c.relname, v.phase, v.heap_blks_total, v.heap_blks_scanned, v.heap_blks_vacuumed, v.index_vacuum_count, v.max_dead_tuples, v.num_dead_tuples from pg_stat_progress_vacuum as v join pg_class c on c.oid = v.relid;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Feb 12 01 239 0ms 0ms 12 0ms 35 0ms 0ms 0ms select * from ( select pricedatetime, open, high, low, close, volume, bsf from t60 where symbolid = ? and (bsf = ? or bsf is null) order by pricedatetime desc limit ?) a order by pricedatetime asc;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Feb 12 01 35 0ms 0ms 13 0ms 404 0ms 0ms 0ms commit;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Feb 12 01 404 0ms 0ms 14 0ms 1 0ms 0ms 0ms with pre_symbols as ( select s.symbolid, s.symbol, s.timegranularity, dss.downloadersymbol, dtt.timezone, s.exchange, s.longname 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 and brokerid = ? where dss.classname in (...) and (dss.downloadersymbol in (...) or s.symbol in (...)) and dss.enabled = ? and s.nonliquid = ? and s.deleted = ? ), report_symbols as ( select ps1.*, ps2.symbolid as price_symbol_id from pre_symbols ps1 inner join pre_symbols ps2 on ps1.symbol = ps2.symbol and ps1.downloadersymbol = ps2.downloadersymbol and ps2.timegranularity = ? ), rbr_max as ( select resultuid from relevance_bigmovement_results order by resultuid desc limit ? ) select bmr.resultuid as ruid, ? as direction, rs.symbol as sym, rs.downloadersymbol, rs.symbolid as sid, rs.timegranularity as tg, rs.timezone, rs.exchange as e, rs.longname, bmr.patternendtime as pet, lpi.latestpricedatetime as lpdt, bmr.patternlengthbars as l, bmr.breakout >= ? as complete, rbr.age as age from bigmovement_results bmr inner join report_symbols rs on rs.symbolid = bmr.symbolid inner join autochartist_symbolupdates lpi on lpi.symbolid = rs.price_symbol_id inner join rbr_max rm on ? = ? left outer join relevance_bigmovement_results rbr on rbr.resultuid = bmr.resultuid where patternendtime >= (now() - ? * interval ?) -- results can't be more than ? days old and (bmr.resultuid > rm.resultuid or rbr.relevant = ?) ;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Feb 12 01 1 0ms 0ms 15 0ms 432 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 #15
Day Hour Count Duration Avg duration Feb 12 01 432 0ms 0ms 16 0ms 14 0ms 0ms 0ms select psd.symbolid, psd.hourlysymbolid as intervalsymbolid, s.symbol, dtt.timezone, dtt.absolutetimezoneoffset, psh.hour as index, psh.ave, psh.stddev, ((psh.ave - psh.stddev) / ?.?) as low, ((psh.ave + psh.stddev) / ?.?) as high, ee.timezone as exchangetimezone, ee.mon_t1start as exchangestart, ee.mon_t1end as exchangeend from powerstats_symboldata psd inner join powerstats_hourly psh on psd.hourlysymbolid = psh.symbolid inner join symbols s on psh.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join mat_ps_hourly_symbolid_max_enddate e on psh.enddate = e.enddate and psh.symbolid = e.symbolid inner join exchanges ee on ee.exchange = s.exchange where psd.symbolid = ? and dtt.dayofweek = ? order by hour asc;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Feb 12 01 14 0ms 0ms 17 0ms 4 0ms 0ms 0ms select (cast(substring(tz.gmoffset from ? for ?) as float) * ? + cast(substring(tz.gmoffset from ? for ?) as float)) / ? as offset from timezones tz where tz.timezone = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Feb 12 01 4 0ms 0ms 18 0ms 239 0ms 0ms 0ms select count(*), sum(size), extract(epoch from now() - min(modification)) from pg_ls_waldir ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Feb 12 01 239 0ms 0ms 19 0ms 55 0ms 0ms 0ms select * from ( select pricedatetime, open, high, low, close, volume, bsf from t30 where symbolid = ? and (bsf = ? or bsf is null) order by pricedatetime desc limit ?) a order by pricedatetime asc;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Feb 12 01 55 0ms 0ms 20 0ms 6 0ms 0ms 0ms select pid, datname, client_addr from pg_stat_activity where query ilike ? and pid <> pg_backend_pid() and state = ? and datname = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Feb 12 01 6 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 16,697 0ms 0ms 0ms 0ms select ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Feb 12 01 16,697 0ms 0ms 2 8,803 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 Feb 12 01 8,803 0ms 0ms 3 5,205 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 #3
Day Hour Count Duration Avg duration Feb 12 01 5,205 0ms 0ms 4 4,702 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 #4
Day Hour Count Duration Avg duration Feb 12 01 4,702 0ms 0ms 5 4,135 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 Feb 12 01 4,135 0ms 0ms 6 3,857 0ms 0ms 0ms 0ms insert into executionlogs (executionid, status, message, details, detailtype) values (null, ?, ?, null, null);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Feb 12 01 3,857 0ms 0ms 7 3,378 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 #7
Day Hour Count Duration Avg duration Feb 12 01 3,378 0ms 0ms 8 2,496 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 #8
Day Hour Count Duration Avg duration Feb 12 01 2,496 0ms 0ms 9 2,290 0ms 0ms 0ms 0ms set extra_float_digits = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Feb 12 01 2,290 0ms 0ms 10 2,264 0ms 0ms 0ms 0ms set application_name = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Feb 12 01 2,264 0ms 0ms 11 1,443 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 #11
Day Hour Count Duration Avg duration Feb 12 01 1,443 0ms 0ms 12 1,361 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 #12
Day Hour Count Duration Avg duration Feb 12 01 1,361 0ms 0ms 13 1,254 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 #13
Day Hour Count Duration Avg duration Feb 12 01 1,254 0ms 0ms 14 1,004 0ms 0ms 0ms 0ms insert into t1440_underlying (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 #14
Day Hour Count Duration Avg duration Feb 12 01 1,004 0ms 0ms 15 959 0ms 0ms 0ms 0ms insert into t240 (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 #15
Day Hour Count Duration Avg duration Feb 12 01 959 0ms 0ms 16 957 0ms 0ms 0ms 0ms update patternresultsrelevance set relevant = ?, saxo_relevant = ?, notrelevantpricedatetime = ?, reason = ? where uniqueindex = ? and relevant = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Feb 12 01 957 0ms 0ms 17 955 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 #17
Day Hour Count Duration Avg duration Feb 12 01 955 0ms 0ms 18 869 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 #18
Day Hour Count Duration Avg duration Feb 12 01 869 0ms 0ms 19 635 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 #19
Day Hour Count Duration Avg duration Feb 12 01 635 0ms 0ms 20 432 0ms 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 #20
Day Hour Count Duration Avg duration Feb 12 01 432 0ms 0ms Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 0ms 0ms 0ms 11 0ms select key, value from datasources ds inner join datasourceparams dsp on ds.id = dsp.datasourceid where ds.name = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Feb 12 01 11 0ms 0ms 2 0ms 0ms 0ms 273 0ms with rar_max as ( select resultuid from relevance_consecutivecandles_results order by resultuid desc limit ? ), all_results as ( select ccr.resultuid as resultuid, ccr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, ccr.patternendtime as identified, dtt.timezone as timezone, ccr.qtyconsecutivecandles as length, g.basegroupname, case when rcr.age is not null then rcr.age when ccr.resultuid <= rm.resultuid then ? else ? end as age, case when rcr.relevant is not null then rcr.relevant when ccr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip, newlevels.filtered from consecutivecandles_results ccr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = ccr.symbolid inner join symbols s on ccr.symbolid = s.symbolid and s.nonliquid = ? inner join downloadersymbolsettings dss on ccr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on ccr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join rar_max rm on ? = ? left outer join relevance_consecutivecandles_results rcr on rcr.resultuid = ccr.resultuid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? left join lateral calc_cc_signal_filter (ccr.resultuid) newlevels on true where ccr.gmttimefound > now() - interval ? and s.deleted = ? and (ccr.simulation = ? or ccr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ccr.patternlengthbars <= ?) ), 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 #2
Day Hour Count Duration Avg duration Feb 12 01 273 0ms 0ms 3 0ms 0ms 0ms 51 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 Feb 12 01 51 0ms 0ms 4 0ms 0ms 0ms 2,496 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 Feb 12 01 2,496 0ms 0ms 5 0ms 0ms 0ms 4 0ms select psd.symbolid, psd.hourlysymbolid as intervalsymbolid, s.symbol, dtt.timezone, dtt.absolutetimezoneoffset, psh.hour as index, psh.ave, psh.stddev, (psh.ave - psh.stddev / ?.?) as low, (psh.ave + psh.stddev / ?.?) as high, ee.timezone as exchangetimezone, ee.mon_t1start as exchangestart, ee.mon_t1end as exchangeend from powerstats_symboldata psd inner join powerstats_hourly psh on psd.hourlysymbolid = psh.symbolid inner join symbols s on psh.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join mat_ps_hourly_symbolid_max_enddate e on psh.enddate = e.enddate and psh.symbolid = e.symbolid inner join exchanges ee on ee.exchange = s.exchange where psd.symbolid = ? and dtt.dayofweek = ? order by hour asc;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Feb 12 01 4 0ms 0ms 6 0ms 0ms 0ms 183 0ms select case when a.old_resultuid = ? then a.old_resultuid else a.resultuid end as resultuid, s.symbol, timegranularity as interval, direction as direction, patternendtime as patternendtime, patternstartprice as psp, patternendprice as pep, target03 as t03, target16 as t16, patternlengthbars as length, p.patternname as patternname, dtt.timezone, cps.pip 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 left join currencypips cps on cps.symbol = s.symbol where (a.old_resultuid = ? or a.resultuid = ?) and dtt.dayofweek = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Feb 12 01 183 0ms 0ms 7 0ms 0ms 0ms 4 0ms select updaterelevantforrelevantresults ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Feb 12 01 4 0ms 0ms 8 0ms 0ms 0ms 957 0ms update patternresultsrelevance set relevant = ?, saxo_relevant = ?, notrelevantpricedatetime = ?, reason = ? where uniqueindex = ? and relevant = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Feb 12 01 957 0ms 0ms 9 0ms 0ms 0ms 1 0ms insert into resultmedia (processresultsid, type, name, filename) values (?, ?, ?, ?) returning id;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Feb 12 01 1 0ms 0ms 10 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 #10
Day Hour Count Duration Avg duration Feb 12 01 18 0ms 0ms 11 0ms 0ms 0ms 239 0ms select v.datname, c.relname, v.phase, v.heap_blks_total, v.heap_blks_scanned, v.heap_blks_vacuumed, v.index_vacuum_count, v.max_dead_tuples, v.num_dead_tuples from pg_stat_progress_vacuum as v join pg_class c on c.oid = v.relid;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Feb 12 01 239 0ms 0ms 12 0ms 0ms 0ms 35 0ms select * from ( select pricedatetime, open, high, low, close, volume, bsf from t60 where symbolid = ? and (bsf = ? or bsf is null) order by pricedatetime desc limit ?) a order by pricedatetime asc;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Feb 12 01 35 0ms 0ms 13 0ms 0ms 0ms 404 0ms commit;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Feb 12 01 404 0ms 0ms 14 0ms 0ms 0ms 1 0ms with pre_symbols as ( select s.symbolid, s.symbol, s.timegranularity, dss.downloadersymbol, dtt.timezone, s.exchange, s.longname 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 and brokerid = ? where dss.classname in (...) and (dss.downloadersymbol in (...) or s.symbol in (...)) and dss.enabled = ? and s.nonliquid = ? and s.deleted = ? ), report_symbols as ( select ps1.*, ps2.symbolid as price_symbol_id from pre_symbols ps1 inner join pre_symbols ps2 on ps1.symbol = ps2.symbol and ps1.downloadersymbol = ps2.downloadersymbol and ps2.timegranularity = ? ), rbr_max as ( select resultuid from relevance_bigmovement_results order by resultuid desc limit ? ) select bmr.resultuid as ruid, ? as direction, rs.symbol as sym, rs.downloadersymbol, rs.symbolid as sid, rs.timegranularity as tg, rs.timezone, rs.exchange as e, rs.longname, bmr.patternendtime as pet, lpi.latestpricedatetime as lpdt, bmr.patternlengthbars as l, bmr.breakout >= ? as complete, rbr.age as age from bigmovement_results bmr inner join report_symbols rs on rs.symbolid = bmr.symbolid inner join autochartist_symbolupdates lpi on lpi.symbolid = rs.price_symbol_id inner join rbr_max rm on ? = ? left outer join relevance_bigmovement_results rbr on rbr.resultuid = bmr.resultuid where patternendtime >= (now() - ? * interval ?) -- results can't be more than ? days old and (bmr.resultuid > rm.resultuid or rbr.relevant = ?) ;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Feb 12 01 1 0ms 0ms 15 0ms 0ms 0ms 432 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 #15
Day Hour Count Duration Avg duration Feb 12 01 432 0ms 0ms 16 0ms 0ms 0ms 14 0ms select psd.symbolid, psd.hourlysymbolid as intervalsymbolid, s.symbol, dtt.timezone, dtt.absolutetimezoneoffset, psh.hour as index, psh.ave, psh.stddev, ((psh.ave - psh.stddev) / ?.?) as low, ((psh.ave + psh.stddev) / ?.?) as high, ee.timezone as exchangetimezone, ee.mon_t1start as exchangestart, ee.mon_t1end as exchangeend from powerstats_symboldata psd inner join powerstats_hourly psh on psd.hourlysymbolid = psh.symbolid inner join symbols s on psh.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join mat_ps_hourly_symbolid_max_enddate e on psh.enddate = e.enddate and psh.symbolid = e.symbolid inner join exchanges ee on ee.exchange = s.exchange where psd.symbolid = ? and dtt.dayofweek = ? order by hour asc;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Feb 12 01 14 0ms 0ms 17 0ms 0ms 0ms 4 0ms select (cast(substring(tz.gmoffset from ? for ?) as float) * ? + cast(substring(tz.gmoffset from ? for ?) as float)) / ? as offset from timezones tz where tz.timezone = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Feb 12 01 4 0ms 0ms 18 0ms 0ms 0ms 239 0ms select count(*), sum(size), extract(epoch from now() - min(modification)) from pg_ls_waldir ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Feb 12 01 239 0ms 0ms 19 0ms 0ms 0ms 55 0ms select * from ( select pricedatetime, open, high, low, close, volume, bsf from t30 where symbolid = ? and (bsf = ? or bsf is null) order by pricedatetime desc limit ?) a order by pricedatetime asc;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Feb 12 01 55 0ms 0ms 20 0ms 0ms 0ms 6 0ms select pid, datname, client_addr from pg_stat_activity where query ilike ? and pid <> pg_backend_pid() and state = ? and datname = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Feb 12 01 6 0ms 0ms Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 3s229ms 2,858 0ms 13ms 1ms WITH rar_max as ( ;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Feb 12 01 2,858 3s229ms 1ms -
WITH rar_max as ( ;
Date: 2026-02-12 01:45:44 Duration: 13ms Database: postgres
-
WITH rar_max as ( ;
Date: 2026-02-12 01:15:59 Duration: 12ms Database: postgres
-
WITH rar_max as ( ;
Date: 2026-02-12 01:00:44 Duration: 12ms Database: postgres
2 1s596ms 3,458 0ms 10ms 0ms SELECT ;Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 01 3,458 1s596ms 0ms -
SELECT ;
Date: 2026-02-12 01:13:01 Duration: 10ms Database: postgres
-
SELECT ;
Date: 2026-02-12 01:46:52 Duration: 9ms Database: postgres
-
SELECT ;
Date: 2026-02-12 01:00:50 Duration: 7ms Database: postgres
3 1s408ms 986 0ms 3ms 1ms SELECT symbolid, ;Times Reported Time consuming prepare #3
Day Hour Count Duration Avg duration 01 986 1s408ms 1ms -
SELECT symbolid, ;
Date: 2026-02-12 01:02:11 Duration: 3ms Database: postgres
-
SELECT symbolid, ;
Date: 2026-02-12 01:15:53 Duration: 2ms Database: postgres
-
SELECT symbolid, ;
Date: 2026-02-12 01:01:53 Duration: 2ms Database: postgres
4 380ms 358 0ms 3ms 1ms SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;Times Reported Time consuming prepare #4
Day Hour Count Duration Avg duration 01 358 380ms 1ms -
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-02-12 01:00:56 Duration: 3ms Database: postgres
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-02-12 01:01:22 Duration: 1ms Database: postgres
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-02-12 01:15:35 Duration: 1ms Database: postgres
5 358ms 2,290 0ms 9ms 0ms SET extra_float_digits = 3;Times Reported Time consuming prepare #5
Day Hour Count Duration Avg duration 01 2,290 358ms 0ms -
SET extra_float_digits = 3;
Date: 2026-02-12 01:56:11 Duration: 9ms Database: postgres
-
SET extra_float_digits = 3;
Date: 2026-02-12 01:31:04 Duration: 4ms Database: postgres
-
SET extra_float_digits = 3;
Date: 2026-02-12 01:11:30 Duration: 3ms Database: postgres
6 261ms 3,081 0ms 1ms 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 #6
Day Hour Count Duration Avg duration 01 3,081 261ms 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: 2026-02-12 01:17:30 Duration: 1ms 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: 2026-02-12 01:00:59 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: 2026-02-12 01:00:51 Duration: 0ms Database: postgres
7 222ms 2,318 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 #7
Day Hour Count Duration Avg duration 01 2,318 222ms 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: 2026-02-12 01:35:22 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: 2026-02-12 01:11:48 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: 2026-02-12 01:02:48 Duration: 0ms Database: postgres
8 152ms 2,547 0ms 7ms 0ms select 1;Times Reported Time consuming prepare #8
Day Hour Count Duration Avg duration 01 2,547 152ms 0ms -
select 1;
Date: 2026-02-12 01:45:59 Duration: 7ms Database: postgres
-
select 1;
Date: 2026-02-12 01:45:27 Duration: 5ms Database: postgres
-
select 1;
Date: 2026-02-12 01:45:27 Duration: 5ms Database: postgres
9 137ms 890 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 #9
Day Hour Count Duration Avg duration 01 890 137ms 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: 2026-02-12 01:16:34 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: 2026-02-12 01:26:39 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: 2026-02-12 01:35:58 Duration: 0ms Database: postgres
10 110ms 949 0ms 1ms 0ms INSERT INTO T1440_underlying (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 #10
Day Hour Count Duration Avg duration 01 949 110ms 0ms -
INSERT INTO T1440_underlying (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: 2026-02-12 01:05:22 Duration: 1ms Database: postgres
-
INSERT INTO T1440_underlying (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: 2026-02-12 01:01:56 Duration: 0ms Database: postgres
-
INSERT INTO T1440_underlying (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: 2026-02-12 01:35:58 Duration: 0ms Database: postgres
11 87ms 959 0ms 0ms 0ms INSERT INTO T240 (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 #11
Day Hour Count Duration Avg duration 01 959 87ms 0ms -
INSERT INTO T240 (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: 2026-02-12 01:46:59 Duration: 0ms Database: postgres
-
INSERT INTO T240 (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: 2026-02-12 01:15:58 Duration: 0ms Database: postgres
-
INSERT INTO T240 (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: 2026-02-12 01:32:01 Duration: 0ms Database: postgres
12 76ms 12 4ms 7ms 6ms with sym_info as ( ;Times Reported Time consuming prepare #12
Day Hour Count Duration Avg duration 01 12 76ms 6ms -
with sym_info as ( ;
Date: 2026-02-12 01:51:42 Duration: 7ms Database: postgres
-
with sym_info as ( ;
Date: 2026-02-12 01:21:46 Duration: 7ms Database: postgres
-
with sym_info as ( ;
Date: 2026-02-12 01:36:42 Duration: 7ms Database: postgres
13 44ms 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 #13
Day Hour Count Duration Avg duration 01 18 44ms 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: 2026-02-12 01:20:02 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: 2026-02-12 01:11: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: 2026-02-12 01:50:02 Duration: 2ms Database: postgres
14 36ms 33 0ms 3ms 1ms WITH last_candle AS ( ;Times Reported Time consuming prepare #14
Day Hour Count Duration Avg duration 01 33 36ms 1ms -
WITH last_candle AS ( ;
Date: 2026-02-12 01:28:01 Duration: 3ms Database: postgres
-
WITH last_candle AS ( ;
Date: 2026-02-12 01:56:05 Duration: 3ms Database: postgres
-
WITH last_candle AS ( ;
Date: 2026-02-12 01:40:02 Duration: 3ms Database: postgres
15 36ms 36 0ms 1ms 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 #15
Day Hour Count Duration Avg duration 01 36 36ms 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: 2026-02-12 01:33:01 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: 2026-02-12 01:30:05 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: 2026-02-12 01:40:06 Duration: 1ms Database: postgres
16 32ms 2,264 0ms 3ms 0ms SET application_name = 'PostgreSQL JDBC Driver';Times Reported Time consuming prepare #16
Day Hour Count Duration Avg duration 01 2,264 32ms 0ms -
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2026-02-12 01:15:59 Duration: 3ms Database: postgres
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2026-02-12 01:32:31 Duration: 0ms Database: postgres
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2026-02-12 01:16:02 Duration: 0ms Database: postgres
17 29ms 36 0ms 1ms 0ms select feedname, to_char(latestrxtime, 'yyyy-mm-dd HH24:MI'), to_char(LatestDBWriteTime, 'yyyy-mm-dd HH24:MI'), to_char(LatestStartupTime, 'yyyy-mm-dd HH24:MI'), StartupTimeInMinutes, dm.source_type, dm.transport_type, case when latestrxtime < (CURRENT_TIMESTAMP - 5 * interval '1 minute') then 'X' else 'OK' end, case when (feedname ilike '%_EOD' OR feedname ilike 'IQFEED_DAILIES' or feedname ilike 'YAHOO%' or feedname ilike 'QUANDL_FUTURES%' or feedname ilike 'BAR_CHART') then case when LatestDBWriteTime < (CURRENT_TIMESTAMP - 24 * interval '1 hour') then 'X' else 'OK' end else case when (LatestDBWriteTime < (CURRENT_TIMESTAMP - 15 * interval '1 minute') and LatestStartupTime < (CURRENT_TIMESTAMP - 30 * interval '1 minute')) OR latestrxtime < CURRENT_TIMESTAMP - interval '2 hour' then 'X' else 'OK' end end as statusDB, comment from datafeeds_latestrun dlr left outer join datafeeds df on dlr.feedname ilike df.name inner join datafeeds_metadata dm on df.metadata_id = dm.id order by feedname;Times Reported Time consuming prepare #17
Day Hour Count Duration Avg duration 01 36 29ms 0ms -
select feedname, to_char(latestrxtime, 'yyyy-mm-dd HH24:MI'), to_char(LatestDBWriteTime, 'yyyy-mm-dd HH24:MI'), to_char(LatestStartupTime, 'yyyy-mm-dd HH24:MI'), StartupTimeInMinutes, dm.source_type, dm.transport_type, case when latestrxtime < (CURRENT_TIMESTAMP - 5 * interval '1 minute') then 'X' else 'OK' end, case when (feedname ilike '%_EOD' OR feedname ilike 'IQFEED_DAILIES' or feedname ilike 'YAHOO%' or feedname ilike 'QUANDL_FUTURES%' or feedname ilike 'BAR_CHART') then case when LatestDBWriteTime < (CURRENT_TIMESTAMP - 24 * interval '1 hour') then 'X' else 'OK' end else case when (LatestDBWriteTime < (CURRENT_TIMESTAMP - 15 * interval '1 minute') and LatestStartupTime < (CURRENT_TIMESTAMP - 30 * interval '1 minute')) OR latestrxtime < CURRENT_TIMESTAMP - interval '2 hour' then 'X' else 'OK' end end as statusDB, comment from datafeeds_latestrun dlr left outer join datafeeds df on dlr.feedname ilike df.name inner join datafeeds_metadata dm on df.metadata_id = dm.id order by feedname;
Date: 2026-02-12 01:33:01 Duration: 1ms Database: postgres
-
select feedname, to_char(latestrxtime, 'yyyy-mm-dd HH24:MI'), to_char(LatestDBWriteTime, 'yyyy-mm-dd HH24:MI'), to_char(LatestStartupTime, 'yyyy-mm-dd HH24:MI'), StartupTimeInMinutes, dm.source_type, dm.transport_type, case when latestrxtime < (CURRENT_TIMESTAMP - 5 * interval '1 minute') then 'X' else 'OK' end, case when (feedname ilike '%_EOD' OR feedname ilike 'IQFEED_DAILIES' or feedname ilike 'YAHOO%' or feedname ilike 'QUANDL_FUTURES%' or feedname ilike 'BAR_CHART') then case when LatestDBWriteTime < (CURRENT_TIMESTAMP - 24 * interval '1 hour') then 'X' else 'OK' end else case when (LatestDBWriteTime < (CURRENT_TIMESTAMP - 15 * interval '1 minute') and LatestStartupTime < (CURRENT_TIMESTAMP - 30 * interval '1 minute')) OR latestrxtime < CURRENT_TIMESTAMP - interval '2 hour' then 'X' else 'OK' end end as statusDB, comment from datafeeds_latestrun dlr left outer join datafeeds df on dlr.feedname ilike df.name inner join datafeeds_metadata dm on df.metadata_id = dm.id order by feedname;
Date: 2026-02-12 01:40:06 Duration: 1ms Database: postgres
-
select feedname, to_char(latestrxtime, 'yyyy-mm-dd HH24:MI'), to_char(LatestDBWriteTime, 'yyyy-mm-dd HH24:MI'), to_char(LatestStartupTime, 'yyyy-mm-dd HH24:MI'), StartupTimeInMinutes, dm.source_type, dm.transport_type, case when latestrxtime < (CURRENT_TIMESTAMP - 5 * interval '1 minute') then 'X' else 'OK' end, case when (feedname ilike '%_EOD' OR feedname ilike 'IQFEED_DAILIES' or feedname ilike 'YAHOO%' or feedname ilike 'QUANDL_FUTURES%' or feedname ilike 'BAR_CHART') then case when LatestDBWriteTime < (CURRENT_TIMESTAMP - 24 * interval '1 hour') then 'X' else 'OK' end else case when (LatestDBWriteTime < (CURRENT_TIMESTAMP - 15 * interval '1 minute') and LatestStartupTime < (CURRENT_TIMESTAMP - 30 * interval '1 minute')) OR latestrxtime < CURRENT_TIMESTAMP - interval '2 hour' then 'X' else 'OK' end end as statusDB, comment from datafeeds_latestrun dlr left outer join datafeeds df on dlr.feedname ilike df.name inner join datafeeds_metadata dm on df.metadata_id = dm.id order by feedname;
Date: 2026-02-12 01:07:57 Duration: 1ms Database: postgres
18 16ms 6 2ms 3ms 2ms 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;Times Reported Time consuming prepare #18
Day Hour Count Duration Avg duration 01 6 16ms 2ms -
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: 2026-02-12 01:20:02 Duration: 3ms Database: postgres
-
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: 2026-02-12 01:40:03 Duration: 3ms Database: postgres
-
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: 2026-02-12 01:50:02 Duration: 2ms Database: postgres
19 15ms 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 #19
Day Hour Count Duration Avg duration 01 6 15ms 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: 2026-02-12 01: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: 2026-02-12 01:20:04 Duration: 2ms 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: 2026-02-12 01:10:05 Duration: 2ms Database: postgres
20 15ms 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 01 24 15ms 0ms -
select count(*) from datafeed_restarter_events where is_current_entry = 1;
Date: 2026-02-12 01:40:03 Duration: 0ms Database: postgres
-
select count(*) from datafeed_restarter_events where is_current_entry = 1;
Date: 2026-02-12 01:35:00 Duration: 0ms Database: postgres
-
select count(*) from datafeed_restarter_events where is_current_entry = 1;
Date: 2026-02-12 01:25:02 Duration: 0ms Database: postgres
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 35s331ms 4,561 0ms 41ms 7ms WITH rar_max as ( ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Feb 12 01 4,561 35s331ms 7ms -
WITH rar_max as ( ;
Date: 2026-02-12 01:11:02 Duration: 41ms Database: postgres parameters: $1 = '607629552599234301', $2 = '607629552599234301', $3 = '607629552599234301'
-
WITH rar_max as ( ;
Date: 2026-02-12 01:17:12 Duration: 40ms Database: postgres parameters: $1 = 't', $2 = '621', $3 = '7', $4 = '15', $5 = '30', $6 = '60', $7 = '120', $8 = '240', $9 = '480', $10 = '1440', $11 = '0', $12 = '', $13 = '1', $14 = 'EURUSD', $15 = '0', $16 = '', $17 = '0', $18 = '0', $19 = '0', $20 = '0', $21 = '0', $22 = 't', $23 = '10', $24 = '10'
-
WITH rar_max as ( ;
Date: 2026-02-12 01:45:44 Duration: 33ms Database: postgres parameters: $1 = '607663036700884301', $2 = '607663036700884301', $3 = '607663036700884301'
2 7s962ms 16,253 0ms 24ms 0ms SELECT ;Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 01 16,253 7s962ms 0ms -
SELECT ;
Date: 2026-02-12 01:11:02 Duration: 24ms Database: postgres parameters: $1 = '958', $2 = '958', $3 = '515840249425602300'
-
SELECT ;
Date: 2026-02-12 01:45:44 Duration: 17ms Database: postgres parameters: $1 = '667', $2 = '667', $3 = '500991628215411200'
-
SELECT ;
Date: 2026-02-12 01:11:02 Duration: 15ms Database: postgres parameters: $1 = '958', $2 = '958', $3 = '515840232246478300'
3 2s420ms 986 1ms 8ms 2ms SELECT symbolid, ;Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 01 986 2s420ms 2ms -
SELECT symbolid, ;
Date: 2026-02-12 01:15:53 Duration: 8ms Database: postgres parameters: $1 = 'BDSWISS', $2 = '15', $3 = 'USDMXN', $4 = 'USOIL', $5 = 'USDPLN', $6 = 'USDSGD', $7 = 'XAGUSD', $8 = 'USDZAR', $9 = 'USDNOK', $10 = 'USDSEK'
-
SELECT symbolid, ;
Date: 2026-02-12 01:47:18 Duration: 7ms Database: postgres parameters: $1 = 'MILLENNIUMPF', $2 = '15', $3 = 'USDJPY', $4 = 'USDJPY.FX'
-
SELECT symbolid, ;
Date: 2026-02-12 01:46:32 Duration: 3ms Database: postgres parameters: $1 = 'MILLENNIUMPF', $2 = '15', $3 = 'EURGBP', $4 = 'EURGBP.ID', $5 = 'EURJPY', $6 = 'EURJPY.FX', $7 = 'EURGBP.FX'
4 1s37ms 135 4ms 22ms 7ms WITH last_candle AS ( ;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 01 135 1s37ms 7ms -
WITH last_candle AS ( ;
Date: 2026-02-12 01:24:00 Duration: 22ms Database: postgres parameters: $1 = '558', $2 = '558'
-
WITH last_candle AS ( ;
Date: 2026-02-12 01:56:07 Duration: 17ms Database: postgres parameters: $1 = '667', $2 = '667'
-
WITH last_candle AS ( ;
Date: 2026-02-12 01:52:00 Duration: 16ms Database: postgres parameters: $1 = '538', $2 = '538'
5 603ms 358 1ms 2ms 1ms SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 01 358 603ms 1ms -
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-02-12 01:01:22 Duration: 2ms Database: postgres parameters: $1 = 'Alpari'
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-02-12 01:30:56 Duration: 2ms Database: postgres parameters: $1 = 'BDSWISS'
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-02-12 01:00:40 Duration: 2ms Database: postgres parameters: $1 = 'MILLENNIUMPF'
6 539ms 16,573 0ms 7ms 0ms select 1;Times Reported Time consuming bind #6
Day Hour Count Duration Avg duration 01 16,573 539ms 0ms -
select 1;
Date: 2026-02-12 01:22:12 Duration: 7ms Database: postgres
-
select 1;
Date: 2026-02-12 01:05:29 Duration: 7ms Database: postgres
-
select 1;
Date: 2026-02-12 01:13:01 Duration: 6ms Database: postgres
7 496ms 12 28ms 55ms 41ms with sym_info as ( ;Times Reported Time consuming bind #7
Day Hour Count Duration Avg duration 01 12 496ms 41ms -
with sym_info as ( ;
Date: 2026-02-12 01:21:46 Duration: 55ms Database: postgres parameters: $1 = '620', $2 = 'Forex', $3 = 'Forex', $4 = '620', $5 = 'Forex', $6 = '620', $7 = '620', $8 = 'Forex', $9 = '620'
-
with sym_info as ( ;
Date: 2026-02-12 01:51:42 Duration: 44ms Database: postgres parameters: $1 = '620', $2 = 'Forex', $3 = 'Forex', $4 = '620', $5 = 'Forex', $6 = '620', $7 = '620', $8 = 'Forex', $9 = '620'
-
with sym_info as ( ;
Date: 2026-02-12 01:21:55 Duration: 44ms Database: postgres parameters: $1 = '627', $2 = 'Forex', $3 = 'Forex', $4 = '627', $5 = 'Forex', $6 = '627', $7 = '627', $8 = 'Forex', $9 = '627'
8 428ms 18 0ms 40ms 23ms with wh_patitioned as ( ;Times Reported Time consuming bind #8
Day Hour Count Duration Avg duration 01 18 428ms 23ms -
with wh_patitioned as ( ;
Date: 2026-02-12 01:39:50 Duration: 40ms Database: postgres parameters: $1 = '621', $2 = '621', $3 = '621', $4 = '621', $5 = '621', $6 = '621', $7 = '621', $8 = '621', $9 = '621'
-
with wh_patitioned as ( ;
Date: 2026-02-12 01:50:02 Duration: 37ms 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: 2026-02-12 01:25:03 Duration: 36ms Database: postgres parameters: $1 = '558', $2 = '558', $3 = '558', $4 = '558', $5 = '558', $6 = '558', $7 = '558', $8 = '558', $9 = '558'
9 310ms 60 0ms 19ms 5ms WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;Times Reported Time consuming bind #9
Day Hour Count Duration Avg duration 01 60 310ms 5ms -
WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;
Date: 2026-02-12 01:51:09 Duration: 19ms Database: postgres parameters: $1 = '667', $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: 2026-02-12 01:17:41 Duration: 18ms Database: postgres parameters: $1 = '489', $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: 2026-02-12 01:06:44 Duration: 18ms Database: postgres parameters: $1 = '667', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'
10 241ms 3,378 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 #10
Day Hour Count Duration Avg duration 01 3,378 241ms 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: 2026-02-12 01:47:02 Duration: 0ms Database: postgres parameters: $1 = '2026-02-11 23:30:00', $2 = '5.865e-06', $3 = '5.925e-06', $4 = '5.865e-06', $5 = '5.92e-06', $6 = '189', $7 = '515840249472255300', $8 = '0', $9 = '2026-02-12 01:47:02.72', $10 = '2026-02-12 01:47:02.399', $11 = '5.865e-06', $12 = '5.925e-06', $13 = '5.865e-06', $14 = '5.92e-06', $15 = '189', $16 = '0', $17 = '2026-02-12 01:47:02.72', $18 = '2026-02-12 01:47:02.399'
-
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: 2026-02-12 01:41:38 Duration: 0ms Database: postgres parameters: $1 = '2026-02-12 00:30:00', $2 = '9041.05', $3 = '9050.9', $4 = '9034.9', $5 = '9048.4', $6 = '4263', $7 = '515840248015340300', $8 = '0', $9 = '2026-02-12 01:41:38.237', $10 = '2026-02-12 01:41:38.139', $11 = '9041.05', $12 = '9050.9', $13 = '9034.9', $14 = '9048.4', $15 = '4263', $16 = '0', $17 = '2026-02-12 01:41:38.237', $18 = '2026-02-12 01:41:38.139'
-
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: 2026-02-12 01:16:27 Duration: 0ms Database: postgres parameters: $1 = '2026-02-11 23:30:00', $2 = '181.756', $3 = '181.936', $4 = '181.754', $5 = '181.8805', $6 = '4979', $7 = '515840249379890300', $8 = '0', $9 = '2026-02-12 01:16:27.275', $10 = '2026-02-12 01:16:26.962', $11 = '181.756', $12 = '181.936', $13 = '181.754', $14 = '181.8805', $15 = '4979', $16 = '0', $17 = '2026-02-12 01:16:27.275', $18 = '2026-02-12 01:16:26.962'
11 214ms 5,205 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 #11
Day Hour Count Duration Avg duration 01 5,205 214ms 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: 2026-02-12 01:00:59 Duration: 0ms Database: postgres parameters: $1 = '2026-02-12 00:00:00', $2 = '1.35699', $3 = '1.35739', $4 = '1.35699', $5 = '1.357075', $6 = '86', $7 = '515840230581642300', $8 = '0', $9 = '2026-02-12 01:00:59.338', $10 = '2026-02-12 01:00:58.914', $11 = '1.35699', $12 = '1.35739', $13 = '1.35699', $14 = '1.357075', $15 = '86', $16 = '0', $17 = '2026-02-12 01:00:59.338', $18 = '2026-02-12 01:00:58.914'
-
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: 2026-02-12 01:26:49 Duration: 0ms Database: postgres parameters: $1 = '2026-02-12 01:00:00', $2 = '25197.78', $3 = '25198.28', $4 = '25167.78', $5 = '25177.03', $6 = '3412', $7 = '515840248038958300', $8 = '0', $9 = '2026-02-12 01:26:49.142', $10 = '2026-02-12 01:26:49.07', $11 = '25197.78', $12 = '25198.28', $13 = '25167.78', $14 = '25177.03', $15 = '3412', $16 = '0', $17 = '2026-02-12 01:26:49.142', $18 = '2026-02-12 01:26:49.07'
-
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: 2026-02-12 01:47:27 Duration: 0ms Database: postgres parameters: $1 = '2026-02-12 01:30:00', $2 = '5069.02', $3 = '5069.85', $4 = '5060.27', $5 = '5063.35', $6 = '1999', $7 = '515840230627575300', $8 = '0', $9 = '2026-02-12 01:47:27.049', $10 = '2026-02-12 01:47:26.972', $11 = '5069.02', $12 = '5069.85', $13 = '5060.27', $14 = '5063.35', $15 = '1999', $16 = '0', $17 = '2026-02-12 01:47:27.049', $18 = '2026-02-12 01:47:26.972'
12 190ms 2,496 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 #12
Day Hour Count Duration Avg duration 01 2,496 190ms 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: 2026-02-12 01:02:48 Duration: 0ms Database: postgres parameters: $1 = '2026-02-11 17:00:00', $2 = '27076.8', $3 = '27097.3', $4 = '26982.7', $5 = '27092.3', $6 = '22642', $7 = '515840247933961300', $8 = '0', $9 = '2026-02-12 01:02:48.39', $10 = '2026-02-12 01:02:48.298', $11 = '27076.8', $12 = '27097.3', $13 = '26982.7', $14 = '27092.3', $15 = '22642', $16 = '0', $17 = '2026-02-12 01:02:48.39', $18 = '2026-02-12 01:02:48.298'
-
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: 2026-02-12 01:11:48 Duration: 0ms Database: postgres parameters: $1 = '2026-02-11 17:00:00', $2 = '27076.8', $3 = '27097.3', $4 = '26982.7', $5 = '27092.3', $6 = '22642', $7 = '515840247933961300', $8 = '0', $9 = '2026-02-12 01:11:48.106', $10 = '2026-02-12 01:11:48.006', $11 = '27076.8', $12 = '27097.3', $13 = '26982.7', $14 = '27092.3', $15 = '22642', $16 = '0', $17 = '2026-02-12 01:11:48.106', $18 = '2026-02-12 01:11:48.006'
-
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: 2026-02-12 01:00:51 Duration: 0ms Database: postgres parameters: $1 = '2026-02-11 22:00:00', $2 = '112.8685', $3 = '112.936', $4 = '112.8075', $5 = '112.8275', $6 = '5403900000', $7 = '515840249744442300', $8 = '0', $9 = '2026-02-12 01:00:51.341', $10 = '2026-02-12 01:00:51.34', $11 = '112.8685', $12 = '112.936', $13 = '112.8075', $14 = '112.8275', $15 = '5403900000', $16 = '0', $17 = '2026-02-12 01:00:51.341', $18 = '2026-02-12 01:00:51.34'
13 99ms 1,004 0ms 0ms 0ms INSERT INTO T1440_underlying (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 01 1,004 99ms 0ms -
INSERT INTO T1440_underlying (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: 2026-02-12 01:00:56 Duration: 0ms Database: postgres parameters: $1 = '2026-02-11 00:00:00', $2 = '68.75', $3 = '70.28', $4 = '68.595', $5 = '69.395', $6 = '16585', $7 = '515840249390663300', $8 = '0', $9 = '2026-02-12 01:00:56.861', $10 = '2026-02-12 01:00:56.86', $11 = '68.75', $12 = '70.28', $13 = '68.595', $14 = '69.395', $15 = '16585', $16 = '0', $17 = '2026-02-12 01:00:56.861', $18 = '2026-02-12 01:00:56.86'
-
INSERT INTO T1440_underlying (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: 2026-02-12 01:46:00 Duration: 0ms Database: postgres parameters: $1 = '2026-02-11 00:00:00', $2 = '247.6585', $3 = '247.7045', $4 = '236.7485', $5 = '245.263', $6 = '124244', $7 = '515840249404368300', $8 = '0', $9 = '2026-02-12 01:46:00.499', $10 = '2026-02-12 01:46:00.498', $11 = '247.6585', $12 = '247.7045', $13 = '236.7485', $14 = '245.263', $15 = '124244', $16 = '0', $17 = '2026-02-12 01:46:00.499', $18 = '2026-02-12 01:46:00.498'
-
INSERT INTO T1440_underlying (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: 2026-02-12 01:46:00 Duration: 0ms Database: postgres parameters: $1 = '2026-02-11 00:00:00', $2 = '80.9845', $3 = '86.3115', $4 = '80.5925', $5 = '84.4945', $6 = '239632', $7 = '515840249469364300', $8 = '0', $9 = '2026-02-12 01:46:00.357', $10 = '2026-02-12 01:46:00.356', $11 = '80.9845', $12 = '86.3115', $13 = '80.5925', $14 = '84.4945', $15 = '239632', $16 = '0', $17 = '2026-02-12 01:46:00.357', $18 = '2026-02-12 01:46:00.356'
14 83ms 959 0ms 0ms 0ms INSERT INTO T240 (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 01 959 83ms 0ms -
INSERT INTO T240 (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: 2026-02-12 01:15:58 Duration: 0ms Database: postgres parameters: $1 = '2026-02-11 16:00:00', $2 = '58415', $3 = '58515', $4 = '57750', $5 = '58095', $6 = '5967', $7 = '515840230561612300', $8 = '0', $9 = '2026-02-12 01:15:58.749', $10 = '2026-02-12 01:15:58.748', $11 = '58415', $12 = '58515', $13 = '57750', $14 = '58095', $15 = '5967', $16 = '0', $17 = '2026-02-12 01:15:58.749', $18 = '2026-02-12 01:15:58.748'
-
INSERT INTO T240 (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: 2026-02-12 01:32:01 Duration: 0ms Database: postgres parameters: $1 = '2026-02-11 16:00:00', $2 = '58412.5', $3 = '58512.5', $4 = '57747.5', $5 = '58092.5', $6 = '5967', $7 = '515840230556263300', $8 = '0', $9 = '2026-02-12 01:32:01.032', $10 = '2026-02-12 01:32:01.031', $11 = '58412.5', $12 = '58512.5', $13 = '57747.5', $14 = '58092.5', $15 = '5967', $16 = '0', $17 = '2026-02-12 01:32:01.032', $18 = '2026-02-12 01:32:01.031'
-
INSERT INTO T240 (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: 2026-02-12 01:46:59 Duration: 0ms Database: postgres parameters: $1 = '2026-02-11 16:00:00', $2 = '58415', $3 = '58515', $4 = '57750', $5 = '58095', $6 = '5967', $7 = '515840230561612300', $8 = '0', $9 = '2026-02-12 01:46:59.107', $10 = '2026-02-12 01:46:59.106', $11 = '58415', $12 = '58515', $13 = '57750', $14 = '58095', $15 = '5967', $16 = '0', $17 = '2026-02-12 01:46:59.107', $18 = '2026-02-12 01:46:59.106'
15 60ms 248 0ms 4ms 0ms /*server.CPResult*/ SELECT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, symbol, longname, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, breakout, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz 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 where resultuid = $1;Times Reported Time consuming bind #15
Day Hour Count Duration Avg duration 01 248 60ms 0ms -
/*server.CPResult*/ SELECT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, symbol, longname, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, breakout, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz 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 where resultuid = $1;
Date: 2026-02-12 01:36:47 Duration: 4ms Database: postgres parameters: $1 = '607663387571313301'
-
/*server.CPResult*/ SELECT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, symbol, longname, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, breakout, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz 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 where resultuid = $1;
Date: 2026-02-12 01:02:51 Duration: 3ms Database: postgres parameters: $1 = '607651765420637301'
-
/*server.CPResult*/ SELECT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, symbol, longname, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, breakout, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz 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 where resultuid = $1;
Date: 2026-02-12 01:20:43 Duration: 3ms Database: postgres parameters: $1 = '607663327916856301'
16 43ms 79 0ms 2ms 0ms /*server.KeyLevelResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, 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 '1900-01-01' END as x3, CASE WHEN (x4 != '') THEN x4 ELSE '1900-01-01' END as x4, CASE WHEN (x5 != '') THEN x5 ELSE '1900-01-01' END as x5, CASE WHEN (x6 != '') THEN x6 ELSE '1900-01-01' END as x6, CASE WHEN (x7 != '') THEN x7 ELSE '1900-01-01' END as x7, CASE WHEN (x8 != '') THEN x8 ELSE '1900-01-01' END as x8, CASE WHEN (x9 != '') THEN x9 ELSE '1900-01-01' END as x9, errorMargin as erm, breakoutprice as pE, breakoutbars as be, breakout, atbaridentified as atBar, PatternLengthBars AS l, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz, approachingtimestamp AS apt, approachingregion as apr, predictionpricefrom as ppf, predictionpriceto as ppt, predictiontimefrom as ptf, predictiontimebars as ptb 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 where resultuid = $1 and dtt.dayofweek = 3;Times Reported Time consuming bind #16
Day Hour Count Duration Avg duration 01 79 43ms 0ms -
/*server.KeyLevelResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, 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 '1900-01-01' END as x3, CASE WHEN (x4 != '') THEN x4 ELSE '1900-01-01' END as x4, CASE WHEN (x5 != '') THEN x5 ELSE '1900-01-01' END as x5, CASE WHEN (x6 != '') THEN x6 ELSE '1900-01-01' END as x6, CASE WHEN (x7 != '') THEN x7 ELSE '1900-01-01' END as x7, CASE WHEN (x8 != '') THEN x8 ELSE '1900-01-01' END as x8, CASE WHEN (x9 != '') THEN x9 ELSE '1900-01-01' END as x9, errorMargin as erm, breakoutprice as pE, breakoutbars as be, breakout, atbaridentified as atBar, PatternLengthBars AS l, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz, approachingtimestamp AS apt, approachingregion as apr, predictionpricefrom as ppf, predictionpriceto as ppt, predictiontimefrom as ptf, predictiontimebars as ptb 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 where resultuid = $1 and dtt.dayofweek = 3;
Date: 2026-02-12 01:35:44 Duration: 2ms Database: postgres parameters: $1 = '607663389239556303'
-
/*server.KeyLevelResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, 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 '1900-01-01' END as x3, CASE WHEN (x4 != '') THEN x4 ELSE '1900-01-01' END as x4, CASE WHEN (x5 != '') THEN x5 ELSE '1900-01-01' END as x5, CASE WHEN (x6 != '') THEN x6 ELSE '1900-01-01' END as x6, CASE WHEN (x7 != '') THEN x7 ELSE '1900-01-01' END as x7, CASE WHEN (x8 != '') THEN x8 ELSE '1900-01-01' END as x8, CASE WHEN (x9 != '') THEN x9 ELSE '1900-01-01' END as x9, errorMargin as erm, breakoutprice as pE, breakoutbars as be, breakout, atbaridentified as atBar, PatternLengthBars AS l, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz, approachingtimestamp AS apt, approachingregion as apr, predictionpricefrom as ppf, predictionpriceto as ppt, predictiontimefrom as ptf, predictiontimebars as ptb 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 where resultuid = $1 and dtt.dayofweek = 3;
Date: 2026-02-12 01:50:47 Duration: 2ms Database: postgres parameters: $1 = '607662919191257303'
-
/*server.KeyLevelResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, 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 '1900-01-01' END as x3, CASE WHEN (x4 != '') THEN x4 ELSE '1900-01-01' END as x4, CASE WHEN (x5 != '') THEN x5 ELSE '1900-01-01' END as x5, CASE WHEN (x6 != '') THEN x6 ELSE '1900-01-01' END as x6, CASE WHEN (x7 != '') THEN x7 ELSE '1900-01-01' END as x7, CASE WHEN (x8 != '') THEN x8 ELSE '1900-01-01' END as x8, CASE WHEN (x9 != '') THEN x9 ELSE '1900-01-01' END as x9, errorMargin as erm, breakoutprice as pE, breakoutbars as be, breakout, atbaridentified as atBar, PatternLengthBars AS l, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz, approachingtimestamp AS apt, approachingregion as apr, predictionpricefrom as ppf, predictionpriceto as ppt, predictiontimefrom as ptf, predictiontimebars as ptb 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 where resultuid = $1 and dtt.dayofweek = 3;
Date: 2026-02-12 01:36:59 Duration: 2ms Database: postgres parameters: $1 = '607662445884583303'
17 39ms 8 3ms 6ms 4ms SELECT DISTINCT ON (basegroupname, symbol) ;Times Reported Time consuming bind #17
Day Hour Count Duration Avg duration 01 8 39ms 4ms -
SELECT DISTINCT ON (basegroupname, symbol) ;
Date: 2026-02-12 01:51:03 Duration: 6ms Database: postgres parameters: $1 = '627', $2 = '627'
-
SELECT DISTINCT ON (basegroupname, symbol) ;
Date: 2026-02-12 01:00:40 Duration: 6ms Database: postgres parameters: $1 = '667', $2 = '667'
-
SELECT DISTINCT ON (basegroupname, symbol) ;
Date: 2026-02-12 01:01:01 Duration: 6ms Database: postgres parameters: $1 = '627', $2 = '627'
18 37ms 33 0ms 1ms 1ms 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 01 33 37ms 1ms -
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: 2026-02-12 01:02:04 Duration: 1ms Database: postgres parameters: $1 = '621', $2 = 'GBPAUD', $3 = '621'
-
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: 2026-02-12 01:16:37 Duration: 1ms Database: postgres parameters: $1 = '558', $2 = 'USDPLN.a', $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: 2026-02-12 01:45:58 Duration: 1ms Database: postgres parameters: $1 = '621', $2 = 'GBPAUD', $3 = '621'
19 33ms 64 0ms 3ms 0ms /*server.FibonacciResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, 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, 1 - errormargin as rq, 1 - 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 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 where resultuid = $1 and dtt.dayofweek = 3;Times Reported Time consuming bind #19
Day Hour Count Duration Avg duration 01 64 33ms 0ms -
/*server.FibonacciResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, 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, 1 - errormargin as rq, 1 - 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 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 where resultuid = $1 and dtt.dayofweek = 3;
Date: 2026-02-12 01:01:42 Duration: 3ms Database: postgres parameters: $1 = '607663091546409302'
-
/*server.FibonacciResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, 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, 1 - errormargin as rq, 1 - 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 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 where resultuid = $1 and dtt.dayofweek = 3;
Date: 2026-02-12 01:50:22 Duration: 2ms Database: postgres parameters: $1 = '607663092244503302'
-
/*server.FibonacciResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, 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, 1 - errormargin as rq, 1 - 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 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 where resultuid = $1 and dtt.dayofweek = 3;
Date: 2026-02-12 01:21:05 Duration: 2ms Database: postgres parameters: $1 = '607663328155628302'
20 31ms 1 31ms 31ms 31ms with maxwhid as ( ;Times Reported Time consuming bind #20
Day Hour Count Duration Avg duration 01 1 31ms 31ms -
with maxwhid as ( ;
Date: 2026-02-12 01:13:11 Duration: 31ms Database: postgres parameters: $1 = '335', $2 = '621', $3 = '637', $4 = '642', $5 = '660', $6 = '666', $7 = '643', $8 = '630', $9 = '680', $10 = '641', $11 = '431', $12 = '622', $13 = '489', $14 = '529', $15 = '576', $16 = '665', $17 = '667', $18 = '558', $19 = '620', $20 = '125', $21 = '488', $22 = '567', $23 = '689', $24 = '700', $25 = '758', $26 = '763', $27 = '765', $28 = '817', $29 = '914', $30 = '972'
-
Events
Log levels
Key values
- 325,746 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Errors per 5 minutes
NO DATASET
Most Frequent Errors/Events
Key values
- 0 Max number of times the same event was reported
- 0 Total events found
Rank Times reported Error NO DATASET