pgBadger-
Global information
- Generated on Sat Mar 21 04:59:23 2026
- Log file: /home/postgres/pg_data/data/pg_log/postgresql-2026-03-21_060000.log
- Parsed 493,582 log entries in 22s
- Log start from 2026-03-21 06:00:00 to 2026-03-21 06:59:21
-
Overview
Global Stats
- 991 Number of unique normalized queries
- 90,504 Number of queries
- 2h50m4s Total query duration
- 2026-03-21 06:00:00 First query
- 2026-03-21 06:59:21 Last query
- 6,066 queries/s at 2026-03-21 06:05:02 Query peak
- 2h50m4s Total query duration
- 45s35ms Prepare/parse total duration
- 18s142ms Bind total duration
- 2h49m1s Execute total duration
- 679 Number of events
- 5 Number of unique normalized events
- 426 Max number of times the same event was reported
- 0 Number of cancellation
- 13 Total number of automatic vacuums
- 21 Total number of automatic analyzes
- 1,204 Number temporary file
- 621.98 MiB Max size of temporary file
- 119.17 MiB Average size of temporary file
- 2,426 Total number of sessions
- 12 sessions at 2026-03-21 06:58:49 Session peak
- 17h44m26s Total duration of sessions
- 26s325ms Average duration of sessions
- 37 Average queries per session
- 4s206ms Average queries duration per session
- 22s119ms Average idle time per session
- 2,426 Total number of connections
- 194 connections/s at 2026-03-21 06:40:13 Connection peak
- 6 Total number of databases
SQL Traffic
Key values
- 6,066 queries/s Query Peak
- 2026-03-21 06:05:02 Date
SELECT Traffic
Key values
- 2,740 queries/s Query Peak
- 2026-03-21 06:05:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 83 queries/s Query Peak
- 2026-03-21 06:03:48 Date
Queries duration
Key values
- 2h50m4s 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) Mar 21 06 90,504 0ms 3m30s 112ms 4m39s 5m55s 26m18s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 21 06 26,965 576 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 21 06 11,441 565 504 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Mar 21 06 9,188 19,983 2.17 21.54% Day Hour Count Average / Second Mar 21 06 2,426 0.67/s Day Hour Count Average Duration Average idle time Mar 21 06 2,426 26s325ms 22s145ms -
Connections
Established Connections
Key values
- 194 connections Connection Peak
- 2026-03-21 06:40:13 Date
Connections per database
Key values
- acaweb_fx Main Database
- 2,426 connections Total
Connections per user
Key values
- postgres Main User
- 2,426 connections Total
Connections per host
Key values
- 127.0.0.1 Main host with 946 connections
- 2,426 Total connections
-
Sessions
Simultaneous sessions
Key values
- 12 sessions Session Peak
- 2026-03-21 06:58:49 Date
Histogram of session times
Key values
- 2,099 0-500ms duration
Sessions per database
Key values
- acaweb_fx Main Database
- 2,426 sessions Total
Sessions per user
Key values
- postgres Main User
- 2,426 sessions Total
Sessions per host
Key values
- 127.0.0.1 Main Host
- 2,426 sessions Total
Host Count Total Duration Average Duration 127.0.0.1 946 39m9s 2s483ms 192.168.0.114 2 10m 5m 192.168.0.216 117 7m37s 3s907ms 192.168.1.145 3 1h8m19s 22m46s 192.168.1.15 1 5h32m11s 5h32m11s 192.168.1.20 23 9h52m46s 25m46s 192.168.1.239 58 342ms 5ms 192.168.1.90 26 42s867ms 1s648ms 192.168.2.126 18 5s612ms 311ms 192.168.3.199 39 33s21ms 846ms 192.168.4.142 765 7m4s 554ms 192.168.4.33 62 1m16s 1s232ms 192.168.4.98 330 16s674ms 50ms [local] 36 4m22s 7s297ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 30,254 buffers Checkpoint Peak
- 2026-03-21 06:49:13 Date
- 209.471 seconds Highest write time
- 2.523 seconds Sync time
Checkpoints Wal files
Key values
- 19 files Wal files usage Peak
- 2026-03-21 06:49:13 Date
Checkpoints distance
Key values
- 624.07 Mo Distance Peak
- 2026-03-21 06:49:13 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Mar 21 06 43,486 1,325.72s 4.301s 1,341.533s Day Hour Added Removed Recycled Synced files Longest sync Average sync Mar 21 06 0 0 27 1,247 1.852s 0.065s Day Hour Count Avg time (sec) Mar 21 06 0 0s Day Hour Mean distance Mean estimate Mar 21 06 37,181.75 kB 87,055.50 kB -
Temporary Files
Size of temporary files
Key values
- 630.66 MiB Temp Files size Peak
- 2026-03-21 06:56:00 Date
Number of temporary files
Key values
- 7 per second Temp Files Peak
- 2026-03-21 06:43:30 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Mar 21 06 1,204 140.12 GiB 119.17 MiB Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 237 139.44 GiB 412.26 MiB 621.98 MiB 602.45 MiB classname, case when latestdbwritetime < current_timestamp - interval ? then ? else ? end as is_stale from latest_t15_candle_view order by classname;-
classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;
Date: 2026-03-21 06:00:14 Duration: 0ms
2 144 239.54 MiB 137.65 KiB 3.87 MiB 1.66 MiB with rar_max as ( select resultuid from relevance_autochartist_results order by resultuid desc limit ? ), ar as ( select a.*, rr.age, rr.relevant from autochartist_results a left outer join relevance_autochartist_results rr on a.resultuid = rr.resultuid where case when false = ? then true else a.resultuid > ( select min(resultuid) from relevance_autochartist_results) end ), all_results as ( select ar.resultuid as resultuid, ar.direction as direction, ar.predictiontimeto as predictiontimeto, ar.predictionpricefrom as predictionpricefrom, ar.predictionpriceto as predictionpriceto, cp.pip as pip, 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, ar.pattern as pattern_name, ar.breakout as breakout, ar.patternendtime as identified, dtt.timezone as timezone, ar.patternlengthbars as length, g.basegroupname, newlevels.profit, newlevels.stop, newlevels.filtered, case when ar.age is not null then ar.age when ar.resultuid <= rm.resultuid then ? else ? end as age, case when ar.relevant is not null then ar.relevant when ar.resultuid <= rm.resultuid then ? else ? end as relevant from ar inner join symbols s on ar.symbolid = s.symbolid and s.nonliquid = ? inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = s.symbolid inner join symbolgroup sg on bsl.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 sg.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 currencypips cp on s.symbol = cp.symbol left join lateral calc_cp_signal (ar.resultuid) newlevels on true left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where ar.gmttimefound > now() - interval ? and dss.enabled = ? and s.deleted = ? and (ar.simulation = ? or ar.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ar.pattern in (...)) and (? = ? or (? = ? and ar.breakout >= ?) or (? = ? and ar.breakout < ?)) and (? = ? or ar.patternlengthbars <= ?) and newlevels.filtered = false and ar.patternstarttime >= 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 ;-
WITH rar_max as ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1 ), ar AS ( SELECT a.*, rr.age, rr.relevant from autochartist_results a LEFT OUTER JOIN relevance_autochartist_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_autochartist_results) END ), all_results AS ( SELECT ar.resultuid AS resultuid, ar.direction AS direction, ar.predictiontimeto AS predictiontimeto, ar.predictionpricefrom AS predictionpricefrom, ar.predictionpriceto AS predictionpriceto, cp.pip AS pip, 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, ar.pattern AS pattern_name, ar.breakout AS breakout, ar.patternendtime AS identified, dtt.timezone AS timezone, ar.patternlengthbars AS length, g.basegroupname, newLevels.profit, newLevels.stop, newLevels.filtered, CASE WHEN ar.age IS NOT NULL THEN ar.age WHEN ar.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN ar.relevant IS NOT NULL THEN ar.relevant WHEN ar.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM ar INNER JOIN symbols s ON ar.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = s.symbolid INNER JOIN symbolgroup sg on bsl.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 sg.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 OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN currencypips cp ON s.symbol = cp.symbol LEFT JOIN LATERAL calc_cp_signal (ar.resultuid) newLevels on true LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE ar.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (ar.simulation = 0 OR ar.simulation IS NULL) AND ($3 = 0 OR s.timegranularity in ($4, $5, $6, $7, $8, $9, $10)) AND ($11 = 0 OR s.exchange in ($12)) AND ($13 = 0 OR coalesce(bim.code, s.symbol) in ($14)) AND ($15 = 0 OR ar.pattern in ($16)) AND ($17 = 0 OR ($18 = 1 AND ar.breakout >= 0) OR ($19 = 2 AND ar.breakout < 0)) AND ($20 = 0 OR ar.patternlengthbars <= $21) and newLevels.filtered = false AND ar.patternstarttime >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $22 OR relevant = 1) AND ($23 = 0 OR age <= $24) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;
Date: 2026-03-21 06:00:16 Duration: 0ms
3 50 233.79 MiB 4.57 MiB 5.02 MiB 4.68 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, $5, $6, $7, $8, $9, $10)) AND ($11 = 0 OR s.exchange in ($12)) AND ($13 = 0 OR coalesce(bim.code, s.symbol) in ($14)) AND ($15 = 0 OR fr.pattern in ($16)) AND ($17 = 0 OR fr.patternlengthbars <= $18) AND ($19 = 0 OR ($20 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($21 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $22 OR relevant = 1) AND ($23 = 0 OR age <= $24) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;
Date: 2026-03-21 06:00:24 Duration: 0ms
4 23 85.71 MiB 3.00 MiB 8.55 MiB 3.73 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-03-21 06:00:10 Duration: 0ms
5 20 30.77 MiB 137.65 KiB 4.08 MiB 1.54 MiB 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 ? ;-
WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), 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 = $1 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 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 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 = 3 INNER JOIN rar_max rm ON 1 = 1 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 = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.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 p.patternname in ($10)) AND ($11 = 0 OR kr.patternclassid in ($12)) AND ($13 = 0 OR kr.patternlengthbars <= $14) AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $15 OR relevant = 1) AND ($16 = 0 OR age <= $17) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200;
Date: 2026-03-21 06:55:30 Duration: 0ms
6 10 36.14 MiB 3.03 MiB 3.87 MiB 3.61 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)) AND ($226 = 0 OR ccr.patternlengthbars <= $227)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $228 OR relevant = 1) AND ($229 = 0 OR age <= $230) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;
Date: 2026-03-21 06:03:22 Duration: 0ms
7 7 21.19 MiB 3.03 MiB 3.03 MiB 3.03 MiB select resultuid from relevance_autochartist_results order by resultuid desc limit ?), ar as ( select a.*, rr.age, rr.relevant from autochartist_results a left outer join relevance_autochartist_results rr on a.resultuid = rr.resultuid where case when false = ? then true else a.resultuid > ( select min(resultuid) from relevance_autochartist_results) end), all_results as ( select ar.resultuid as resultuid, ar.direction as direction, ar.predictiontimeto as predictiontimeto, ar.predictionpricefrom as predictionpricefrom, ar.predictionpriceto as predictionpriceto, cp.pip as pip, 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, ar.pattern as pattern_name, ar.breakout as breakout, ar.patternendtime as identified, dtt.timezone as timezone, ar.patternlengthbars as length, g.basegroupname, newlevels.profit, newlevels.stop, newlevels.filtered, case when ar.age is not null then ar.age when ar.resultuid <= rm.resultuid then ? else ? end as age, case when ar.relevant is not null then ar.relevant when ar.resultuid <= rm.resultuid then ? else ? end as relevant from ar inner join symbols s on ar.symbolid = s.symbolid and s.nonliquid = ? inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = s.symbolid inner join symbolgroup sg on bsl.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 sg.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 currencypips cp on s.symbol = cp.symbol left join lateral calc_cp_signal (ar.resultuid) newlevels on true left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where ar.gmttimefound > now() - interval ? and dss.enabled = ? and s.deleted = ? and (ar.simulation = ? or ar.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ar.pattern in (...)) and (? = ? or (? = ? and ar.breakout >= ?) or (? = ? and ar.breakout < ?)) and (? = ? or ar.patternlengthbars <= ?) and newlevels.filtered = false and ar.patternstarttime >= 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 ;-
SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1), ar AS ( SELECT a.*, rr.age, rr.relevant from autochartist_results a LEFT OUTER JOIN relevance_autochartist_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_autochartist_results) END), all_results AS ( SELECT ar.resultuid AS resultuid, ar.direction AS direction, ar.predictiontimeto AS predictiontimeto, ar.predictionpricefrom AS predictionpricefrom, ar.predictionpriceto AS predictionpriceto, cp.pip AS pip, 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, ar.pattern AS pattern_name, ar.breakout AS breakout, ar.patternendtime AS identified, dtt.timezone AS timezone, ar.patternlengthbars AS length, g.basegroupname, newLevels.profit, newLevels.stop, newLevels.filtered, CASE WHEN ar.age IS NOT NULL THEN ar.age WHEN ar.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN ar.relevant IS NOT NULL THEN ar.relevant WHEN ar.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM ar INNER JOIN symbols s ON ar.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = s.symbolid INNER JOIN symbolgroup sg on bsl.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 sg.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 OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN currencypips cp ON s.symbol = cp.symbol LEFT JOIN LATERAL calc_cp_signal (ar.resultuid) newLevels on true LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE ar.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (ar.simulation = 0 OR ar.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 ar.pattern in ($10)) AND ($11 = 0 OR ($12 = 1 AND ar.breakout >= 0) OR ($13 = 2 AND ar.breakout < 0)) AND ($14 = 0 OR ar.patternlengthbars <= $15) and newLevels.filtered = false AND ar.patternstarttime >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), 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-03-21 06:00:41 Duration: 0ms
8 3 48.65 MiB 9.84 MiB 23.66 MiB 16.22 MiB select distinct ss.statsid from stats_success t inner join stats_symbols ss on t.symbolid = ss.symbolid where statsid in ( select statsid from stats where (? = ? or brokerid = ?)) and atbaridentified >= (current_timestamp - interval ?) and atbaridentified <= current_timestamp and type = ? and pattern not ilike ? and (? = ? or statsid >= ?) order by ss.statsid;-
select distinct ss.statsid from stats_success t inner join stats_symbols ss on t.symbolid = ss.symbolid where statsid in ( select statsid from stats where (0 = 0 or brokerid = 0)) and atbaridentified >= (current_timestamp - interval '12 months') and atbaridentified <= current_timestamp and type = 'cp' and pattern not ilike '%NON_LIQUID%' and (0 = 0 OR statsid >= 0) order by ss.statsid;
Date: 2026-03-21 06:40:34 Duration: 0ms
9 1 4.43 MiB 4.43 MiB 4.43 MiB 4.43 MiB select stats_calcstatsforallbrokers ();-
select stats_calcstatsforallbrokers ();
Date: 2026-03-21 06:40:12 Duration: 0ms
Queries generating the largest temporary files
Rank Size Query 1 621.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-21 06:00:14 ]
2 621.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-21 06:00:29 ]
3 621.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-21 06:00:44 ]
4 621.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-21 06:00:59 ]
5 621.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-21 06:01:14 ]
6 621.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-21 06:01:28 ]
7 621.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-21 06:01:44 ]
8 621.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-21 06:01:59 ]
9 621.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-21 06:02:14 ]
10 621.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-21 06:02:29 ]
11 621.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-21 06:03:00 ]
12 621.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-21 06:03:14 ]
13 621.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-21 06:03:29 ]
14 621.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-21 06:03:44 ]
15 621.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-21 06:03:59 ]
16 621.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-21 06:04:13 ]
17 621.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-21 06:04:29 ]
18 621.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-21 06:04:44 ]
19 621.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-21 06:04:59 ]
20 621.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-21 06:05:15 ]
-
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
- pg_catalog.pg_type (4) Main table analyzed (database acaweb_fx)
- 21 analyzes Total
Table Number of analyzes acaweb_fx.pg_catalog.pg_type 4 acaweb_fx.pg_catalog.pg_attribute 4 acaweb_fx.public.datafeeds_latestrun 3 acaweb_fx.public.latest_t15_candle_view 2 acaweb_fx.pg_catalog.pg_class 2 acaweb_fx.public.stats_hrsapproaches_summary_2d 1 acaweb_fx.public.stats_hrs_summary_2d 1 acaweb_fx.public.stats_summary_2d 1 acaweb_fx.pg_catalog.pg_depend 1 acaweb_fx.public.variables 1 acaweb_fx.public.latest_candle_datetime_per_receng 1 Total 21 Vacuums per table
Key values
- pg_catalog.pg_type (2) Main table vacuumed on database acaweb_fx
- 13 vacuums Total
Index Buffer usage Skipped WAL usage Table Vacuums scans hits misses dirtied pins frozen records full page bytes acaweb_fx.pg_catalog.pg_type 2 2 281 0 72 0 0 132 48 245,204 acaweb_fx.public.datafeeds_latestrun 2 0 240 0 8 0 0 27 7 34,105 acaweb_fx.pg_catalog.pg_attribute 2 2 1,429 0 344 0 134 662 255 1,451,922 acaweb_fx.pg_catalog.pg_class 2 2 574 0 65 0 156 204 67 431,019 acaweb_fx.public.stats_hrsapproaches_summary_2d 1 1 38,430 0 3,371 0 3,836 19,250 3,357 13,665,451 acaweb_fx.public.stats_hrs_summary_2d 1 1 37,635 0 3,276 0 3,445 18,757 3,260 13,177,804 acaweb_fx.public.stats_summary_2d 1 1 171,962 0 12,267 0 14,234 79,274 14,101 55,512,246 acaweb_fx.public.latest_t15_candle_view 1 1 93 0 1 0 0 6 1 9,049 acaweb_fx.public.variables 1 1 147 0 2 0 0 23 2 14,035 Total 13 11 250,791 25,542 19,406 0 21,805 118,335 21,098 84,540,835 Tuples removed per table
Key values
- public.stats_summary_2d (1121701) Main table with removed tuples on database acaweb_fx
- 1649180 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain acaweb_fx.public.stats_summary_2d 1 1 1,121,701 729,211 0 0 29,766 acaweb_fx.public.stats_hrsapproaches_summary_2d 1 1 265,193 191,277 0 0 7,549 acaweb_fx.public.stats_hrs_summary_2d 1 1 258,009 172,238 0 0 7,040 acaweb_fx.pg_catalog.pg_attribute 2 2 2,858 22,634 1,320 0 536 acaweb_fx.public.variables 1 1 610 2 0 0 28 acaweb_fx.pg_catalog.pg_type 2 2 533 3,086 176 0 90 acaweb_fx.public.datafeeds_latestrun 2 0 114 28 0 0 32 acaweb_fx.pg_catalog.pg_class 2 2 104 5,364 176 0 300 acaweb_fx.public.latest_t15_candle_view 1 1 58 12 0 0 1 Total 13 11 1,649,180 1,123,852 1,672 0 45,342 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.public.stats_hrsapproaches_summary_2d 1 1 265193 0 acaweb_fx.pg_catalog.pg_type 2 2 533 0 acaweb_fx.public.datafeeds_latestrun 2 0 114 0 acaweb_fx.public.stats_hrs_summary_2d 1 1 258009 0 acaweb_fx.pg_catalog.pg_attribute 2 2 2858 0 acaweb_fx.public.stats_summary_2d 1 1 1121701 0 acaweb_fx.public.latest_t15_candle_view 1 1 58 0 acaweb_fx.public.variables 1 1 610 0 acaweb_fx.pg_catalog.pg_class 2 2 104 0 Total 13 11 1,649,180 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Mar 21 06 13 21 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessShareLock Main Lock Type
- 12 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 10 21m38s 1m1s 2m23s 2m9s select datetimeupdate from latest_candle_datetime_per_receng where recognitionengine ilike ?;-
SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 1';
Date: 2026-03-21 06:19:30
2 1 2m28s 2m28s 2m28s 2m28s refresh materialized view latest_candle_datetime_per_receng;-
refresh materialized view latest_candle_datetime_per_receng;
Date: 2026-03-21 06:19:30
3 1 42s354ms 42s354ms 42s354ms 42s354ms select recognitionengine, to_char(datetimeupdate, ?) from latest_candle_datetime_per_receng;-
select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng;
Date: 2026-03-21 06:19:30
Queries that waited the most
Rank Wait time Query 1 2m28s refresh materialized view latest_candle_datetime_per_receng;[ Date: 2026-03-21 06:19:30 ]
2 2m23s SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ATFX - 1';[ Date: 2026-03-21 06:19:30 ]
3 2m22s SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'FPMARKETS - 1';[ Date: 2026-03-21 06:19:30 ]
4 2m20s SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'Alpari - 1';[ Date: 2026-03-21 06:19:30 ]
5 2m19s SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'MILLENNIUMPF - 1';[ Date: 2026-03-21 06:19:30 ]
6 2m19s SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'IQFEED_FX - 1';[ Date: 2026-03-21 06:19:30 ]
7 2m19s SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'BDSWISS - 1';[ Date: 2026-03-21 06:19:30 ]
8 2m17s SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'AXIORY - 1';[ Date: 2026-03-21 06:19:30 ]
9 2m10s SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'HOTFOREX - 1';[ Date: 2026-03-21 06:19:30 ]
10 2m3s SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'PEPPERSTONE - 1';[ Date: 2026-03-21 06:19:30 ]
11 1m1s SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 1';[ Date: 2026-03-21 06:19:30 ]
12 42s354ms select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng;[ Date: 2026-03-21 06:19:30 ]
-
Queries
Queries by type
Key values
- 26,965 Total read queries
- 15,686 Total write queries
Queries by database
Key values
- unknown Main database
- 88,914 Requests
- 2h49m1s (unknown)
- Main time consuming database
Database Request type Count Duration acaweb_fx Total 1,522 0ms delete 504 0ms others 218 0ms select 440 0ms tcl 332 0ms update 28 0ms acaweb_fx_integer Total 1 0ms select 1 0ms postgres Total 3 0ms select 3 0ms socialmedia Total 63 0ms select 63 0ms translations Total 1 0ms select 1 0ms unknown Total 88,914 2h49m1s copy to 576 0ms cte 1,931 0ms insert 11,441 0ms others 2,717 0ms select 26,457 0ms tcl 337 0ms update 537 0ms Queries by user
Key values
- unknown Main user
- 88,914 Requests
User Request type Count Duration postgres Total 1,590 0ms delete 504 0ms others 218 0ms select 508 0ms tcl 332 0ms update 28 0ms unknown Total 88,914 2h49m1s copy to 576 0ms cte 1,931 0ms insert 11,441 0ms others 2,717 0ms select 26,457 0ms tcl 337 0ms update 537 0ms Duration by user
Key values
- 2h49m1s (unknown) Main time consuming user
User Request type Count Duration postgres Total 1,590 0ms delete 504 0ms others 218 0ms select 508 0ms tcl 332 0ms update 28 0ms unknown Total 88,914 2h49m1s copy to 576 0ms cte 1,931 0ms insert 11,441 0ms others 2,717 0ms select 26,457 0ms tcl 337 0ms update 537 0ms Queries by host
Key values
- unknown Main host
- 90,504 Requests
- 2h49m1s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 89,522 Requests
- 2h49m1s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 1 per second Cancelled query Peak
- 2026-03-21 06:25:29 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 31,923 0-1ms duration
Slowest individual queries
Rank Duration Query NO DATASET
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 1 0ms 0ms 0ms lock table public.stats_hrs_summary_by_groups in access share mode;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 21 06 1 0ms 0ms 2 0ms 2 0ms 0ms 0ms copy public.powerstats_trumpet (symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms 3 0ms 2 0ms 0ms 0ms select last_value, is_called from public.stats_by_groups_statsid_seq;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms 4 0ms 2 0ms 0ms 0ms lock table public.timezones_korean in access share mode;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms 5 0ms 4 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 #5
Day Hour Count Duration Avg duration Mar 21 06 4 0ms 0ms 6 0ms 2 0ms 0ms 0ms copy public.t30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived, pricesadjusted, relevanceprocessed, recengprocessedadjusted, historical) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms 7 0ms 1 0ms 0ms 0ms copy public.processresults (id, processid, resultdate, shorttext, longtext, title, test) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 21 06 1 0ms 0ms 8 0ms 2,430 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 Mar 21 06 2,430 0ms 0ms 9 0ms 2 0ms 0ms 0ms select last_value, is_called from public.keylevels_results_resultuid_seq19;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms 10 0ms 2 0ms 0ms 0ms copy archive.whatshot (whid, brokerid, whdatetime, jobcompletiontime) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms 11 0ms 5 0ms 0ms 0ms set synchronize_seqscans to off;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 21 06 5 0ms 0ms 12 0ms 237 0ms 0ms 0ms select * from ( select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity union select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity union select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity union select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity union select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity) as k order by timegranularity;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 21 06 237 0ms 0ms 13 0ms 1 0ms 0ms 0ms select last_value, is_called from public."ProcessLocaleParameters_id_seq";Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 21 06 1 0ms 0ms 14 0ms 979 0ms 0ms 0ms select oid, tableoid, pol.polname, pol.polcmd, pol.polpermissive, case when pol.polroles = ? then null else pg_catalog.array_to_string(array ( select pg_catalog.quote_ident(rolname) from pg_catalog.pg_roles where oid = any (pol.polroles)), ?) end as polroles, pg_catalog.pg_get_expr(pol.polqual, pol.polrelid) as polqual, pg_catalog.pg_get_expr(pol.polwithcheck, pol.polrelid) as polwithcheck from pg_catalog.pg_policy pol where polrelid = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 21 06 979 0ms 0ms 15 0ms 2 0ms 0ms 0ms lock table public.timezones_turkish in access share mode;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms 16 0ms 2 0ms 0ms 0ms copy public.timezones_greek (timezoneid, timezone) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms 17 0ms 2 0ms 0ms 0ms lock table public.futures_symbols in access share mode;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms 18 0ms 2 0ms 0ms 0ms copy archive.autochartist_results (resultid, bandwidth, pattern, gmttimefound, direction, initialtrend, breakout, volumeincrease, noise, symmetry, patternstarttime, patternendtime, patternstartprice, patternendprice, resx0, resx1, supportx0, supportx1, resy0, resy1, supporty0, supporty1, supportgradient, resgradient, riskreward, qtytp, predictionpricefrom, predictionpriceto, predictiontimefrom, predictiontimeto, patternquality, trendchange, maxmovementafterbreakout, latestbaratbreakouttime, latestbaratbreakoutprice, patternlengthbars, temporarypattern, symbolid, resultuid, relevancestartdistance, simulation, writtendatetime, old_resultuid) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms 19 0ms 2 0ms 0ms 0ms copy public.satelliteauthentication (id, satelliteserverid, brokerid, authenticationstatus, maketradeurl, notifications, validusername, validpassword, enabled) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms 20 0ms 2 0ms 0ms 0ms lock table archive.patternresultsage in access share mode;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 3,734 0ms 0ms 0ms 0ms select ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 21 06 3,734 0ms 0ms 2 2,896 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 #2
Day Hour Count Duration Avg duration Mar 21 06 2,896 0ms 0ms 3 2,451 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 #3
Day Hour Count Duration Avg duration Mar 21 06 2,451 0ms 0ms 4 2,430 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 #4
Day Hour Count Duration Avg duration Mar 21 06 2,430 0ms 0ms 5 2,425 0ms 0ms 0ms 0ms insert into executionlogs (executionid, status, message, details, detailtype) values (null, ?, ?, null, null);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 21 06 2,425 0ms 0ms 6 1,664 0ms 0ms 0ms 0ms select pg_catalog.format_type(?::pg_catalog.oid, null);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 21 06 1,664 0ms 0ms 7 1,352 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 #7
Day Hour Count Duration Avg duration Mar 21 06 1,352 0ms 0ms 8 1,311 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 #8
Day Hour Count Duration Avg duration Mar 21 06 1,311 0ms 0ms 9 1,009 0ms 0ms 0ms 0ms select datetimeupdate from latest_candle_datetime_per_receng where recognitionengine ilike ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 21 06 1,009 0ms 0ms -
SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 1';
Date: 2026-03-21 06:19:30 Duration: 0ms
10 979 0ms 0ms 0ms 0ms select oid, tableoid, pol.polname, pol.polcmd, pol.polpermissive, case when pol.polroles = ? then null else pg_catalog.array_to_string(array ( select pg_catalog.quote_ident(rolname) from pg_catalog.pg_roles where oid = any (pol.polroles)), ?) end as polroles, pg_catalog.pg_get_expr(pol.polqual, pol.polrelid) as polqual, pg_catalog.pg_get_expr(pol.polwithcheck, pol.polrelid) as polwithcheck from pg_catalog.pg_policy pol where polrelid = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 21 06 979 0ms 0ms 11 824 0ms 0ms 0ms 0ms set extra_float_digits = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 21 06 824 0ms 0ms 12 812 0ms 0ms 0ms 0ms set application_name = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 21 06 812 0ms 0ms 13 789 0ms 0ms 0ms 0ms select a.attnum, a.attname, a.atttypmod, a.attstattarget, a.attstorage, t.typstorage, a.attnotnull, a.atthasdef, a.attisdropped, a.attlen, a.attalign, a.attislocal, pg_catalog.format_type(t.oid, a.atttypmod) as atttypname, a.attgenerated, case when a.atthasmissing and not a.attisdropped then a.attmissingval else null end as attmissingval, a.attidentity, pg_catalog.array_to_string(array ( select pg_catalog.quote_ident(option_name) || ? || pg_catalog.quote_literal(option_value) from pg_catalog.pg_options_to_table(attfdwoptions) order by option_name), e ?) as attfdwoptions, case when a.attcollation <> t.typcollation then a.attcollation else ? end as attcollation, array_to_string(a.attoptions, ?) as attoptions from pg_catalog.pg_attribute a left join pg_catalog.pg_type t on a.atttypid = t.oid where a.attrelid = ?::pg_catalog.oid and a.attnum > ?::pg_catalog.int2 order by a.attnum;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 21 06 789 0ms 0ms 14 676 0ms 0ms 0ms 0ms select at.attname, ( select pg_catalog.array_agg(acl order by row_n) from ( select acl, row_n from pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault(?, c.relowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, c.relowner))) as init (init_acl) where acl = init_acl)) as foo) as attacl, ( select pg_catalog.array_agg(acl order by row_n) from ( select acl, row_n from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, c.relowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault(?, c.relowner))) as permp (orig_acl) where acl = orig_acl)) as foo) as rattacl, null as initattacl, null as initrattacl from pg_catalog.pg_attribute at join pg_catalog.pg_class c on (at.attrelid = c.oid) left join pg_catalog.pg_init_privs pip on (at.attrelid = pip.objoid and pip.classoid = ?::pg_catalog.regclass and at.attnum = pip.objsubid) where at.attrelid = ?::pg_catalog.oid and not at.attisdropped and (( select pg_catalog.array_agg(acl order by row_n) from ( select acl, row_n from pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault(?, c.relowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, c.relowner))) as init (init_acl) where acl = init_acl)) as foo) is not null or ( select pg_catalog.array_agg(acl order by row_n) from ( select acl, row_n from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, c.relowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault(?, c.relowner))) as permp (orig_acl) where acl = orig_acl)) as foo) is not null or null is not null or null is not null) order by at.attnum;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 21 06 676 0ms 0ms 15 653 0ms 0ms 0ms 0ms select proretset, prosrc, probin, pg_catalog.pg_get_function_arguments(oid) as funcargs, pg_catalog.pg_get_function_identity_arguments(oid) as funciargs, pg_catalog.pg_get_function_result(oid) as funcresult, array_to_string(protrftypes, ?) as protrftypes, prokind, provolatile, proisstrict, prosecdef, proleakproof, proconfig, procost, prorows, prosupport, proparallel, ( select lanname from pg_catalog.pg_language where oid = prolang) as lanname from pg_catalog.pg_proc where oid = ?::pg_catalog.oid;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 21 06 653 0ms 0ms 16 632 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 #16
Day Hour Count Duration Avg duration Mar 21 06 632 0ms 0ms 17 576 0ms 0ms 0ms 0ms select pr.tableoid, pr.oid, p.pubname from pg_publication_rel pr, pg_publication p where pr.prrelid = ? and p.oid = pr.prpubid;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 21 06 576 0ms 0ms 18 495 0ms 0ms 0ms 0ms select t.tableoid, t.oid, t.relname as indexname, inh.inhparent as parentidx, pg_catalog.pg_get_indexdef(i.indexrelid) as indexdef, i.indnkeyatts as indnkeyatts, i.indnatts as indnatts, i.indkey, i.indisclustered, i.indisreplident, c.contype, c.conname, c.condeferrable, c.condeferred, c.tableoid as contableoid, c.oid as conoid, pg_catalog.pg_get_constraintdef(c.oid, false) as condef, ( select spcname from pg_catalog.pg_tablespace s where s.oid = t.reltablespace) as tablespace, t.reloptions as indreloptions, ( select pg_catalog.array_agg(attnum order by attnum) from pg_catalog.pg_attribute where attrelid = i.indexrelid and attstattarget >= ?) as indstatcols, ( select pg_catalog.array_agg(attstattarget order by attnum) from pg_catalog.pg_attribute where attrelid = i.indexrelid and attstattarget >= ?) as indstatvals from pg_catalog.pg_index i join pg_catalog.pg_class t on (t.oid = i.indexrelid) join pg_catalog.pg_class t2 on (t2.oid = i.indrelid) left join pg_catalog.pg_constraint c on (i.indrelid = c.conrelid and i.indexrelid = c.conindid and c.contype in (...)) left join pg_catalog.pg_inherits inh on (inh.inhrelid = indexrelid) where i.indrelid = ?::pg_catalog.oid and (i.indisvalid or t2.relkind = ?) and i.indisready order by indexname;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 21 06 495 0ms 0ms 19 337 0ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 21 06 337 0ms 0ms 20 332 0ms 0ms 0ms 0ms commit;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 21 06 332 0ms 0ms Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 0ms 0ms 0ms 1 0ms lock table public.stats_hrs_summary_by_groups in access share mode;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 21 06 1 0ms 0ms 2 0ms 0ms 0ms 2 0ms copy public.powerstats_trumpet (symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms 3 0ms 0ms 0ms 2 0ms select last_value, is_called from public.stats_by_groups_statsid_seq;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms 4 0ms 0ms 0ms 2 0ms lock table public.timezones_korean in access share mode;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms 5 0ms 0ms 0ms 4 0ms select key, value from datasources ds inner join datasourceparams dsp on ds.id = dsp.datasourceid where ds.name = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 21 06 4 0ms 0ms 6 0ms 0ms 0ms 2 0ms copy public.t30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived, pricesadjusted, relevanceprocessed, recengprocessedadjusted, historical) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms 7 0ms 0ms 0ms 1 0ms copy public.processresults (id, processid, resultdate, shorttext, longtext, title, test) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 21 06 1 0ms 0ms 8 0ms 0ms 0ms 2,430 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 Mar 21 06 2,430 0ms 0ms 9 0ms 0ms 0ms 2 0ms select last_value, is_called from public.keylevels_results_resultuid_seq19;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms 10 0ms 0ms 0ms 2 0ms copy archive.whatshot (whid, brokerid, whdatetime, jobcompletiontime) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms 11 0ms 0ms 0ms 5 0ms set synchronize_seqscans to off;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 21 06 5 0ms 0ms 12 0ms 0ms 0ms 237 0ms select * from ( select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity union select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity union select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity union select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity union select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity) as k order by timegranularity;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 21 06 237 0ms 0ms 13 0ms 0ms 0ms 1 0ms select last_value, is_called from public."ProcessLocaleParameters_id_seq";Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 21 06 1 0ms 0ms 14 0ms 0ms 0ms 979 0ms select oid, tableoid, pol.polname, pol.polcmd, pol.polpermissive, case when pol.polroles = ? then null else pg_catalog.array_to_string(array ( select pg_catalog.quote_ident(rolname) from pg_catalog.pg_roles where oid = any (pol.polroles)), ?) end as polroles, pg_catalog.pg_get_expr(pol.polqual, pol.polrelid) as polqual, pg_catalog.pg_get_expr(pol.polwithcheck, pol.polrelid) as polwithcheck from pg_catalog.pg_policy pol where polrelid = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 21 06 979 0ms 0ms 15 0ms 0ms 0ms 2 0ms lock table public.timezones_turkish in access share mode;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms 16 0ms 0ms 0ms 2 0ms copy public.timezones_greek (timezoneid, timezone) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms 17 0ms 0ms 0ms 2 0ms lock table public.futures_symbols in access share mode;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms 18 0ms 0ms 0ms 2 0ms copy archive.autochartist_results (resultid, bandwidth, pattern, gmttimefound, direction, initialtrend, breakout, volumeincrease, noise, symmetry, patternstarttime, patternendtime, patternstartprice, patternendprice, resx0, resx1, supportx0, supportx1, resy0, resy1, supporty0, supporty1, supportgradient, resgradient, riskreward, qtytp, predictionpricefrom, predictionpriceto, predictiontimefrom, predictiontimeto, patternquality, trendchange, maxmovementafterbreakout, latestbaratbreakouttime, latestbaratbreakoutprice, patternlengthbars, temporarypattern, symbolid, resultuid, relevancestartdistance, simulation, writtendatetime, old_resultuid) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms 19 0ms 0ms 0ms 2 0ms copy public.satelliteauthentication (id, satelliteserverid, brokerid, authenticationstatus, maketradeurl, notifications, validusername, validpassword, enabled) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms 20 0ms 0ms 0ms 2 0ms lock table archive.patternresultsage in access share mode;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 21 06 2 0ms 0ms Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 42s364ms 20 0ms 42s356ms 2s118ms select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Mar 21 06 20 42s364ms 2s118ms -
select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng;
Date: 2026-03-21 06:19:30 Duration: 42s356ms Database: postgres
-
select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng;
Date: 2026-03-21 06:11:23 Duration: 2ms Database: postgres
-
select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng;
Date: 2026-03-21 06:06:22 Duration: 0ms Database: postgres
2 1s183ms 711 0ms 3ms 1ms SELECT symbolid, ;Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 06 711 1s183ms 1ms -
SELECT symbolid, ;
Date: 2026-03-21 06:10:08 Duration: 3ms Database: postgres
-
SELECT symbolid, ;
Date: 2026-03-21 06:32:59 Duration: 3ms Database: postgres
-
SELECT symbolid, ;
Date: 2026-03-21 06:00:08 Duration: 3ms Database: postgres
3 254ms 207 0ms 1ms 1ms SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;Times Reported Time consuming prepare #3
Day Hour Count Duration Avg duration 06 207 254ms 1ms -
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-21 06:19:42 Duration: 1ms Database: postgres
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-21 06:45:22 Duration: 1ms Database: postgres
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-21 06:15:53 Duration: 1ms Database: postgres
4 252ms 2,307 0ms 1ms 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 #4
Day Hour Count Duration Avg duration 06 2,307 252ms 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-03-21 06:10:08 Duration: 1ms 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-03-21 06:50:30 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-03-21 06:30:03 Duration: 0ms Database: postgres
5 208ms 2,407 0ms 0ms 0ms INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming prepare #5
Day Hour Count Duration Avg duration 06 2,407 208ms 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-03-21 06:10:10 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-03-21 06:11:00 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-03-21 06:33:37 Duration: 0ms Database: postgres
6 133ms 415 0ms 6ms 0ms SELECT ;Times Reported Time consuming prepare #6
Day Hour Count Duration Avg duration 06 415 133ms 0ms -
SELECT ;
Date: 2026-03-21 06:41:59 Duration: 6ms Database: postgres
-
SELECT ;
Date: 2026-03-21 06:33:59 Duration: 5ms Database: postgres
-
SELECT ;
Date: 2026-03-21 06:30:03 Duration: 1ms Database: postgres
7 129ms 824 0ms 0ms 0ms SET extra_float_digits = 3;Times Reported Time consuming prepare #7
Day Hour Count Duration Avg duration 06 824 129ms 0ms -
SET extra_float_digits = 3;
Date: 2026-03-21 06:30:05 Duration: 0ms Database: postgres
-
SET extra_float_digits = 3;
Date: 2026-03-21 06:23:21 Duration: 0ms Database: postgres
-
SET extra_float_digits = 3;
Date: 2026-03-21 06:11:06 Duration: 0ms Database: postgres
8 129ms 127 0ms 6ms 1ms WITH rar_max as ( ;Times Reported Time consuming prepare #8
Day Hour Count Duration Avg duration 06 127 129ms 1ms -
WITH rar_max as ( ;
Date: 2026-03-21 06:34:13 Duration: 6ms Database: postgres
-
WITH rar_max as ( ;
Date: 2026-03-21 06:34:52 Duration: 4ms Database: postgres
-
WITH rar_max as ( ;
Date: 2026-03-21 06:43:10 Duration: 4ms Database: postgres
9 118ms 681 0ms 1ms 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 06 681 118ms 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-03-21 06:15:07 Duration: 1ms 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-03-21 06:00:37 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-03-21 06:15:23 Duration: 0ms Database: postgres
10 92ms 18 2ms 32ms 5ms 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 #10
Day Hour Count Duration Avg duration 06 18 92ms 5ms -
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-03-21 06:40:03 Duration: 32ms 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-03-21 06:30:03 Duration: 12ms 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-03-21 06:20:03 Duration: 9ms Database: postgres
11 50ms 288 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 prepare #11
Day Hour Count Duration Avg duration 06 288 50ms 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-03-21 06:46:37 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-03-21 06:15:03 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-03-21 06:31:40 Duration: 0ms Database: postgres
12 36ms 297 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 #12
Day Hour Count Duration Avg duration 06 297 36ms 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-03-21 06:45:37 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-03-21 06:48:02 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-03-21 06:01:38 Duration: 0ms Database: postgres
13 27ms 20 1ms 2ms 1ms select distinct classname, to_char(created_datetime, 'yyyy-mm-dd HH24:MI'), to_char(cleared_datetime, 'yyyy-mm-dd HH24:MI'), action_to_take, description, created_datetime from datafeed_restarter_events where (is_current_entry = 1 OR cleared_datetime > current_timestamp - interval '17 hour') order by created_datetime desc;Times Reported Time consuming prepare #13
Day Hour Count Duration Avg duration 06 20 27ms 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-03-21 06:18:48 Duration: 2ms Database: postgres
-
select distinct classname, to_char(created_datetime, 'yyyy-mm-dd HH24:MI'), to_char(cleared_datetime, 'yyyy-mm-dd HH24:MI'), action_to_take, description, created_datetime from datafeed_restarter_events where (is_current_entry = 1 OR cleared_datetime > current_timestamp - interval '17 hour') order by created_datetime desc;
Date: 2026-03-21 06:52:39 Duration: 2ms Database: postgres
-
select distinct classname, to_char(created_datetime, 'yyyy-mm-dd HH24:MI'), to_char(cleared_datetime, 'yyyy-mm-dd HH24:MI'), action_to_take, description, created_datetime from datafeed_restarter_events where (is_current_entry = 1 OR cleared_datetime > current_timestamp - interval '17 hour') order by created_datetime desc;
Date: 2026-03-21 06:57:41 Duration: 1ms Database: postgres
14 18ms 6 2ms 3ms 3ms 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 #14
Day Hour Count Duration Avg duration 06 6 18ms 3ms -
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-03-21 06:20:05 Duration: 3ms Database: postgres
-
select client_addr, count(1) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by client_addr, setting having (client_addr is not null OR (client_addr is null and count(1) > (cast(setting as numeric) / 3 * 2))) order by count desc;
Date: 2026-03-21 06: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-03-21 06:00:04 Duration: 3ms Database: postgres
15 18ms 20 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 #15
Day Hour Count Duration Avg duration 06 20 18ms 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-03-21 06:18:48 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-03-21 06:11:23 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-03-21 06:01:21 Duration: 1ms Database: postgres
16 10ms 812 0ms 0ms 0ms SET application_name = 'PostgreSQL JDBC Driver';Times Reported Time consuming prepare #16
Day Hour Count Duration Avg duration 06 812 10ms 0ms -
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2026-03-21 06:17:08 Duration: 0ms Database: postgres
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2026-03-21 06:15:47 Duration: 0ms Database: postgres
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2026-03-21 06:01:11 Duration: 0ms Database: postgres
17 4ms 2 1ms 2ms 2ms SELECT * FROM datafeed_symbols WHERE classname ilike 'ICMARKETS-AU-MT5' LIMIT $1;Times Reported Time consuming prepare #17
Day Hour Count Duration Avg duration 06 2 4ms 2ms -
SELECT * FROM datafeed_symbols WHERE classname ilike 'ICMARKETS-AU-MT5' LIMIT $1;
Date: 2026-03-21 06:52:18 Duration: 2ms Database: postgres
-
SELECT * FROM datafeed_symbols WHERE classname ilike 'ICMARKETS-AU-MT5' LIMIT $1;
Date: 2026-03-21 06:22:51 Duration: 1ms Database: postgres
18 1ms 4 0ms 0ms 0ms SELECT DISTINCT ON (basegroupname, symbol) ;Times Reported Time consuming prepare #18
Day Hour Count Duration Avg duration 06 4 1ms 0ms -
SELECT DISTINCT ON (basegroupname, symbol) ;
Date: 2026-03-21 06:05:57 Duration: 0ms Database: postgres
-
SELECT DISTINCT ON (basegroupname, symbol) ;
Date: 2026-03-21 06:16:00 Duration: 0ms Database: postgres
-
SELECT DISTINCT ON (basegroupname, symbol) ;
Date: 2026-03-21 06:06:03 Duration: 0ms Database: postgres
19 0ms 17 0ms 0ms 0ms select 1;Times Reported Time consuming prepare #19
Day Hour Count Duration Avg duration 06 17 0ms 0ms -
select 1;
Date: 2026-03-21 06:43:10 Duration: 0ms Database: postgres
-
select 1;
Date: 2026-03-21 06:55:41 Duration: 0ms Database: postgres
-
select 1;
Date: 2026-03-21 06:43:10 Duration: 0ms Database: postgres
20 0ms 3 0ms 0ms 0ms SELECT DISTINCT ;Times Reported Time consuming prepare #20
Day Hour Count Duration Avg duration 06 3 0ms 0ms -
SELECT DISTINCT ;
Date: 2026-03-21 06:42:58 Duration: 0ms Database: postgres
-
SELECT DISTINCT ;
Date: 2026-03-21 06:33:59 Duration: 0ms Database: postgres
-
SELECT DISTINCT ;
Date: 2026-03-21 06:43:03 Duration: 0ms Database: postgres
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 12s515ms 1,018 0ms 56ms 12ms WITH rar_max as ( ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Mar 21 06 1,018 12s515ms 12ms -
WITH rar_max as ( ;
Date: 2026-03-21 06:35:54 Duration: 56ms Database: postgres parameters: $1 = '667', $2 = '7', $3 = '15', $4 = '30', $5 = '60', $6 = '120', $7 = '240', $8 = '480', $9 = '1440', $10 = '0', $11 = '', $12 = '84', $13 = 'AUDCAD', $14 = 'AUDCHF', $15 = 'AUDJPY', $16 = 'AUDNZD', $17 = 'AUDSGD', $18 = 'CADCHF', $19 = 'CADJPY', $20 = 'CHFJPY', $21 = 'EURAUD', $22 = 'EURCAD', $23 = 'EURCHF', $24 = 'EURCZK', $25 = 'EURGBP', $26 = 'EURHUF', $27 = 'EURJPY', $28 = 'EURNOK', $29 = 'EURNZD', $30 = 'EURPLN', $31 = 'EURSEK', $32 = 'EURSGD', $33 = 'EURTRY', $34 = 'EURZAR', $35 = 'GBPAUD', $36 = 'GBPCAD', $37 = 'GBPCHF', $38 = 'GBPJPY', $39 = 'GBPNZD', $40 = 'GBPPLN', $41 = 'GBPSEK', $42 = 'GBPSGD', $43 = 'NZDCAD', $44 = 'NZDCHF', $45 = 'NZDJPY', $46 = 'NZDSGD', $47 = 'USDCNH', $48 = 'USDCZK', $49 = 'USDHUF', $50 = 'USDNOK', $51 = 'USDPLN', $52 = 'USDSEK', $53 = 'USDSGD', $54 = 'USDTRY', $55 = 'USDZAR', $56 = 'WTI', $57 = 'XBRUSD', $58 = 'XTIUSD', $59 = 'BTCUSD', $60 = 'XAGAUD', $61 = 'XAGUSD', $62 = 'XAUAUD', $63 = 'XAUUSD', $64 = 'XPTUSD', $65 = 'XPDUSD', $66 = 'AUDUSD', $67 = 'EURUSD', $68 = 'GBPUSD', $69 = 'NZDUSD', $70 = 'USDCAD', $71 = 'USDCHF', $72 = 'USDHKD', $73 = 'USDJPY', $74 = 'AUS200', $75 = 'CHINA300', $76 = 'CHINA50', $77 = 'DJ30', $78 = 'ESP35t', $79 = 'EUR50', $80 = 'EURO50', $81 = 'FRA40', $82 = 'GDAXI', $83 = 'GDAXIm', $84 = 'HK50', $85 = 'ITA40', $86 = 'J225', $87 = 'JP225', $88 = 'NAS100', $89 = 'SING30', $90 = 'SPA35', $91 = 'STOXX50', $92 = 'SUI20', $93 = 'UK100', $94 = 'US100', $95 = 'US30', $96 = 'US500', $97 = '500', $98 = '500', $99 = 't', $100 = '10', $101 = '10'
-
WITH rar_max as ( ;
Date: 2026-03-21 06:20:25 Duration: 54ms Database: postgres parameters: $1 = '667', $2 = '7', $3 = '15', $4 = '30', $5 = '60', $6 = '120', $7 = '240', $8 = '480', $9 = '1440', $10 = '0', $11 = '', $12 = '84', $13 = 'AUDCAD', $14 = 'AUDCHF', $15 = 'AUDJPY', $16 = 'AUDNZD', $17 = 'AUDSGD', $18 = 'CADCHF', $19 = 'CADJPY', $20 = 'CHFJPY', $21 = 'EURAUD', $22 = 'EURCAD', $23 = 'EURCHF', $24 = 'EURCZK', $25 = 'EURGBP', $26 = 'EURHUF', $27 = 'EURJPY', $28 = 'EURNOK', $29 = 'EURNZD', $30 = 'EURPLN', $31 = 'EURSEK', $32 = 'EURSGD', $33 = 'EURTRY', $34 = 'EURZAR', $35 = 'GBPAUD', $36 = 'GBPCAD', $37 = 'GBPCHF', $38 = 'GBPJPY', $39 = 'GBPNZD', $40 = 'GBPPLN', $41 = 'GBPSEK', $42 = 'GBPSGD', $43 = 'NZDCAD', $44 = 'NZDCHF', $45 = 'NZDJPY', $46 = 'NZDSGD', $47 = 'USDCNH', $48 = 'USDCZK', $49 = 'USDHUF', $50 = 'USDNOK', $51 = 'USDPLN', $52 = 'USDSEK', $53 = 'USDSGD', $54 = 'USDTRY', $55 = 'USDZAR', $56 = 'WTI', $57 = 'XBRUSD', $58 = 'XTIUSD', $59 = 'BTCUSD', $60 = 'XAGAUD', $61 = 'XAGUSD', $62 = 'XAUAUD', $63 = 'XAUUSD', $64 = 'XPTUSD', $65 = 'XPDUSD', $66 = 'AUDUSD', $67 = 'EURUSD', $68 = 'GBPUSD', $69 = 'NZDUSD', $70 = 'USDCAD', $71 = 'USDCHF', $72 = 'USDHKD', $73 = 'USDJPY', $74 = 'AUS200', $75 = 'CHINA300', $76 = 'CHINA50', $77 = 'DJ30', $78 = 'ESP35t', $79 = 'EUR50', $80 = 'EURO50', $81 = 'FRA40', $82 = 'GDAXI', $83 = 'GDAXIm', $84 = 'HK50', $85 = 'ITA40', $86 = 'J225', $87 = 'JP225', $88 = 'NAS100', $89 = 'SING30', $90 = 'SPA35', $91 = 'STOXX50', $92 = 'SUI20', $93 = 'UK100', $94 = 'US100', $95 = 'US30', $96 = 'US500', $97 = '500', $98 = '500', $99 = 't', $100 = '10', $101 = '10'
-
WITH rar_max as ( ;
Date: 2026-03-21 06:20:37 Duration: 53ms Database: postgres parameters: $1 = 't', $2 = '667', $3 = '0', $4 = '0', $5 = '0', $6 = '', $7 = '0', $8 = '', $9 = '0', $10 = '', $11 = '0', $12 = '0', $13 = '0', $14 = '0', $15 = '0', $16 = 't', $17 = '0', $18 = '0'
2 1s989ms 711 0ms 26ms 2ms SELECT symbolid, ;Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 06 711 1s989ms 2ms -
SELECT symbolid, ;
Date: 2026-03-21 06:40:04 Duration: 26ms Database: postgres parameters: $1 = 'BDSWISS', $2 = '30', $3 = 'LTCUSD', $4 = 'NAS100', $5 = 'NEOUSD', $6 = 'IOTAUSD', $7 = 'LTCEUR', $8 = 'SPX500', $9 = 'HKG_50', $10 = 'US30', $11 = 'TRXUSD'
-
SELECT symbolid, ;
Date: 2026-03-21 06:16:27 Duration: 9ms Database: postgres parameters: $1 = 'GLOBALGTMT5', $2 = '15', $3 = 'BTCAPL', $4 = 'BTCUSD', $5 = 'BTCJPY'
-
SELECT symbolid, ;
Date: 2026-03-21 06:10:10 Duration: 8ms Database: postgres parameters: $1 = 'BDSWISS', $2 = '60', $3 = 'SPX500', $4 = 'US30'
3 1s317ms 3,565 0ms 29ms 0ms SELECT ;Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 06 3,565 1s317ms 0ms -
SELECT ;
Date: 2026-03-21 06:33:59 Duration: 29ms Database: postgres parameters: $1 = '607871067020144301', $2 = '607871067020144301', $3 = '607871067020144301'
-
SELECT ;
Date: 2026-03-21 06:33:59 Duration: 16ms Database: postgres parameters: $1 = '607871068455834302', $2 = '607871068455834302', $3 = '607871068455834302'
-
SELECT ;
Date: 2026-03-21 06:43:13 Duration: 14ms Database: postgres parameters: $1 = '515840243198780300'
4 495ms 60 4ms 47ms 8ms WITH last_candle AS ( ;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 06 60 495ms 8ms -
WITH last_candle AS ( ;
Date: 2026-03-21 06:12:00 Duration: 47ms Database: postgres parameters: $1 = '558', $2 = '558'
-
WITH last_candle AS ( ;
Date: 2026-03-21 06:40:00 Duration: 18ms Database: postgres parameters: $1 = '558', $2 = '558'
-
WITH last_candle AS ( ;
Date: 2026-03-21 06:24:00 Duration: 15ms Database: postgres parameters: $1 = '558', $2 = '558'
5 419ms 207 1ms 2ms 2ms SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 06 207 419ms 2ms -
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-21 06:17:54 Duration: 2ms Database: postgres parameters: $1 = 'MILLENNIUMPF'
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-21 06:31:39 Duration: 2ms Database: postgres parameters: $1 = 'AXIORY'
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-21 06:19:42 Duration: 2ms Database: postgres parameters: $1 = 'BDSWISS'
6 209ms 2,430 0ms 1ms 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 #6
Day Hour Count Duration Avg duration 06 2,430 209ms 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-03-21 06:30:03 Duration: 1ms Database: postgres parameters: $1 = '2026-03-20 23:00:00', $2 = '4501.25', $3 = '4514.62', $4 = '4489.105', $5 = '4490.78', $6 = '28444', $7 = '515840249391252300', $8 = '0', $9 = '2026-03-21 06:30:03.392', $10 = '2026-03-21 06:30:03.265', $11 = '4501.25', $12 = '4514.62', $13 = '4489.105', $14 = '4490.78', $15 = '28444', $16 = '0', $17 = '2026-03-21 06:30:03.392', $18 = '2026-03-21 06:30:03.265'
-
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-03-21 06:02:38 Duration: 0ms Database: postgres parameters: $1 = '2026-03-20 23:00:00', $2 = '0.866835', $3 = '0.86738', $4 = '0.866735', $5 = '0.86734', $6 = '3661', $7 = '515840249376834300', $8 = '0', $9 = '2026-03-21 06:02:38.827', $10 = '2026-03-21 06:02:38.796', $11 = '0.866835', $12 = '0.86738', $13 = '0.866735', $14 = '0.86734', $15 = '3661', $16 = '0', $17 = '2026-03-21 06:02:38.827', $18 = '2026-03-21 06:02:38.796'
-
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-03-21 06:10:08 Duration: 0ms Database: postgres parameters: $1 = '2026-03-20 17:00:00', $2 = '24969.8', $3 = '25008.39', $4 = '24882.3', $5 = '24913.8', $6 = '21343', $7 = '515840247933961300', $8 = '0', $9 = '2026-03-21 06:10:08.507', $10 = '2026-03-21 06:10:08.412', $11 = '24969.8', $12 = '25008.39', $13 = '24882.3', $14 = '24913.8', $15 = '21343', $16 = '0', $17 = '2026-03-21 06:10:08.507', $18 = '2026-03-21 06:10:08.412'
7 193ms 8 0ms 47ms 24ms with wh_patitioned as ( ;Times Reported Time consuming bind #7
Day Hour Count Duration Avg duration 06 8 193ms 24ms -
with wh_patitioned as ( ;
Date: 2026-03-21 06:42:55 Duration: 47ms 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-03-21 06:50:02 Duration: 41ms 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-03-21 06:05:02 Duration: 40ms Database: postgres parameters: $1 = '558', $2 = '558', $3 = '558', $4 = '558', $5 = '558', $6 = '558', $7 = '558', $8 = '558', $9 = '558'
8 187ms 2,451 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 #8
Day Hour Count Duration Avg duration 06 2,451 187ms 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-03-21 06:30:23 Duration: 0ms Database: postgres parameters: $1 = '2026-03-20 22:30:00', $2 = '212.3795', $3 = '212.5195', $4 = '212.226', $5 = '212.407', $6 = '5759', $7 = '515840230496135300', $8 = '0', $9 = '2026-03-21 06:30:23.25', $10 = '2026-03-21 06:30:23.145', $11 = '212.3795', $12 = '212.5195', $13 = '212.226', $14 = '212.407', $15 = '5759', $16 = '0', $17 = '2026-03-21 06:30:23.25', $18 = '2026-03-21 06:30:23.145'
-
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-03-21 06:01:38 Duration: 0ms Database: postgres parameters: $1 = '2026-03-20 23:30:00', $2 = '1.648455', $3 = '1.64858', $4 = '1.646065', $5 = '1.64755', $6 = '2975', $7 = '515840249382937300', $8 = '0', $9 = '2026-03-21 06:01:38.379', $10 = '2026-03-21 06:01:38.3', $11 = '1.648455', $12 = '1.64858', $13 = '1.646065', $14 = '1.64755', $15 = '2975', $16 = '0', $17 = '2026-03-21 06:01:38.379', $18 = '2026-03-21 06:01:38.3'
-
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-03-21 06:17:54 Duration: 0ms Database: postgres parameters: $1 = '2026-03-20 22:30:00', $2 = '212.3795', $3 = '212.5195', $4 = '212.226', $5 = '212.407', $6 = '5759', $7 = '515840230496135300', $8 = '0', $9 = '2026-03-21 06:17:54.743', $10 = '2026-03-21 06:17:54.734', $11 = '212.3795', $12 = '212.5195', $13 = '212.226', $14 = '212.407', $15 = '5759', $16 = '0', $17 = '2026-03-21 06:17:54.743', $18 = '2026-03-21 06:17:54.734'
9 166ms 3,622 0ms 13ms 0ms select 1;Times Reported Time consuming bind #9
Day Hour Count Duration Avg duration 06 3,622 166ms 0ms -
select 1;
Date: 2026-03-21 06:52:36 Duration: 13ms Database: postgres
-
select 1;
Date: 2026-03-21 06:52:53 Duration: 11ms Database: postgres
-
select 1;
Date: 2026-03-21 06:52:53 Duration: 9ms Database: postgres
10 144ms 2,896 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 #10
Day Hour Count Duration Avg duration 06 2,896 144ms 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-03-21 06:15:23 Duration: 0ms Database: postgres parameters: $1 = '2026-03-20 22:45:00', $2 = '247.73', $3 = '248.03', $4 = '246.06', $5 = '247.945', $6 = '552', $7 = '515840216708269300', $8 = '0', $9 = '2026-03-21 06:15:23.318', $10 = '2026-03-21 06:15:23.252', $11 = '247.73', $12 = '248.03', $13 = '246.06', $14 = '247.945', $15 = '552', $16 = '0', $17 = '2026-03-21 06:15:23.318', $18 = '2026-03-21 06:15:23.252'
-
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-03-21 06:00:37 Duration: 0ms Database: postgres parameters: $1 = '2026-03-20 23:30:00', $2 = '1924.72', $3 = '1929.62', $4 = '1921.01', $5 = '1925.59', $6 = '2661', $7 = '500991628263605200', $8 = '0', $9 = '2026-03-21 06:00:37.377', $10 = '2026-03-21 06:00:37.195', $11 = '1924.72', $12 = '1929.62', $13 = '1921.01', $14 = '1925.59', $15 = '2661', $16 = '0', $17 = '2026-03-21 06:00:37.377', $18 = '2026-03-21 06:00:37.195'
-
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-03-21 06:32:35 Duration: 0ms Database: postgres parameters: $1 = '2026-03-20 23:30:00', $2 = '45681.86', $3 = '45757.86', $4 = '45681.61', $5 = '45733.86', $6 = '1796', $7 = '500991628266833200', $8 = '0', $9 = '2026-03-21 06:32:35.748', $10 = '2026-03-21 06:32:35.672', $11 = '45681.86', $12 = '45757.86', $13 = '45681.61', $14 = '45733.86', $15 = '1796', $16 = '0', $17 = '2026-03-21 06:32:35.748', $18 = '2026-03-21 06:32:35.672'
11 95ms 23 0ms 19ms 4ms WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;Times Reported Time consuming bind #11
Day Hour Count Duration Avg duration 06 23 95ms 4ms -
WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;
Date: 2026-03-21 06:51:57 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-03-21 06:53:47 Duration: 18ms 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-03-21 06:20:52 Duration: 15ms Database: postgres parameters: $1 = '667', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'
12 73ms 16 0ms 67ms 4ms SELECT * FROM ( SELECT PriceDateTime, Open, High, Low, Close, Volume, BSF FROM T60 WHERE symbolid = $1 AND (BSF = 0 OR BSF IS NULL) ORDER BY PriceDateTime DESC LIMIT 1050) a ORDER BY PriceDateTime ASC;Times Reported Time consuming bind #12
Day Hour Count Duration Avg duration 06 16 73ms 4ms -
SELECT * FROM ( SELECT PriceDateTime, Open, High, Low, Close, Volume, BSF FROM T60 WHERE symbolid = $1 AND (BSF = 0 OR BSF IS NULL) ORDER BY PriceDateTime DESC LIMIT 1050) a ORDER BY PriceDateTime ASC;
Date: 2026-03-21 06:18:59 Duration: 67ms Database: postgres parameters: $1 = '515840243888981300'
-
SELECT * FROM ( SELECT PriceDateTime, Open, High, Low, Close, Volume, BSF FROM T60 WHERE symbolid = $1 AND (BSF = 0 OR BSF IS NULL) ORDER BY PriceDateTime DESC LIMIT 1050) a ORDER BY PriceDateTime ASC;
Date: 2026-03-21 06:31:26 Duration: 4ms Database: postgres parameters: $1 = '515840233926567300'
-
SELECT * FROM ( SELECT PriceDateTime, Open, High, Low, Close, Volume, BSF FROM T60 WHERE symbolid = $1 AND (BSF = 0 OR BSF IS NULL) ORDER BY PriceDateTime DESC LIMIT 1050) a ORDER BY PriceDateTime ASC;
Date: 2026-03-21 06:15:57 Duration: 0ms Database: postgres parameters: $1 = '500991628208653200'
13 56ms 288 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 bind #13
Day Hour Count Duration Avg duration 06 288 56ms 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-03-21 06:30:03 Duration: 1ms Database: postgres parameters: $1 = '2026-03-20 00:00:00', $2 = '4651.21', $3 = '4735.95', $4 = '4477.52', $5 = '4490.78', $6 = '761680', $7 = '515840249391588300', $8 = '0', $9 = '2026-03-21 06:30:03.36', $10 = '2026-03-21 06:30:03.359', $11 = '4651.21', $12 = '4735.95', $13 = '4477.52', $14 = '4490.78', $15 = '761680', $16 = '0', $17 = '2026-03-21 06:30:03.36', $18 = '2026-03-21 06:30:03.359'
-
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-03-21 06:15:03 Duration: 1ms Database: postgres parameters: $1 = '2026-03-20 00:00:00', $2 = '4651.21', $3 = '4735.95', $4 = '4477.52', $5 = '4490.78', $6 = '761680', $7 = '515840249391588300', $8 = '0', $9 = '2026-03-21 06:15:03.365', $10 = '2026-03-21 06:15:03.364', $11 = '4651.21', $12 = '4735.95', $13 = '4477.52', $14 = '4490.78', $15 = '761680', $16 = '0', $17 = '2026-03-21 06:15:03.365', $18 = '2026-03-21 06:15:03.364'
-
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-03-21 06:46:37 Duration: 0ms Database: postgres parameters: $1 = '2026-03-20 00:00:00', $2 = '1.635225', $3 = '1.64858', $4 = '1.62908', $5 = '1.64755', $6 = '212651', $7 = '515840249383486300', $8 = '0', $9 = '2026-03-21 06:46:37.639', $10 = '2026-03-21 06:46:37.638', $11 = '1.635225', $12 = '1.64858', $13 = '1.62908', $14 = '1.64755', $15 = '212651', $16 = '0', $17 = '2026-03-21 06:46:37.639', $18 = '2026-03-21 06:46:37.638'
14 53ms 80 0ms 26ms 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 #14
Day Hour Count Duration Avg duration 06 80 53ms 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-03-21 06:14:51 Duration: 26ms Database: postgres parameters: $1 = '607870413502668301'
-
/*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-03-21 06:35:56 Duration: 5ms Database: postgres parameters: $1 = '607872008861757301'
-
/*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-03-21 06:53:02 Duration: 4ms Database: postgres parameters: $1 = '607872007749734301'
15 41ms 316 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 #15
Day Hour Count Duration Avg duration 06 316 41ms 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-03-21 06:48:02 Duration: 0ms Database: postgres parameters: $1 = '2026-03-20 20:00:00', $2 = '69.745', $3 = '70.1735', $4 = '67.6865', $5 = '67.7985', $6 = '96465', $7 = '515840249469200300', $8 = '0', $9 = '2026-03-21 06:48:02.718', $10 = '2026-03-21 06:48:02.519', $11 = '69.745', $12 = '70.1735', $13 = '67.6865', $14 = '67.7985', $15 = '96465', $16 = '0', $17 = '2026-03-21 06:48:02.718', $18 = '2026-03-21 06:48:02.519'
-
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-03-21 06:15:39 Duration: 0ms Database: postgres parameters: $1 = '2026-03-20 20:00:00', $2 = '392.814', $3 = '393.7495', $4 = '392.306', $5 = '393.2185', $6 = '11682', $7 = '515840249385198300', $8 = '0', $9 = '2026-03-21 06:15:39.497', $10 = '2026-03-21 06:15:39.481', $11 = '392.814', $12 = '393.7495', $13 = '392.306', $14 = '393.2185', $15 = '11682', $16 = '0', $17 = '2026-03-21 06:15:39.497', $18 = '2026-03-21 06:15:39.481'
-
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-03-21 06:17:38 Duration: 0ms Database: postgres parameters: $1 = '2026-03-20 20:00:00', $2 = '0.86762', $3 = '0.86764', $4 = '0.86593', $5 = '0.86734', $6 = '14419', $7 = '515840249377113300', $8 = '0', $9 = '2026-03-21 06:17:38.935', $10 = '2026-03-21 06:17:38.876', $11 = '0.86762', $12 = '0.86764', $13 = '0.86593', $14 = '0.86734', $15 = '14419', $16 = '0', $17 = '2026-03-21 06:17:38.935', $18 = '2026-03-21 06:17:38.876'
16 30ms 24 0ms 21ms 1ms /*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 06 24 30ms 1ms -
/*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-03-21 06:15:16 Duration: 21ms Database: postgres parameters: $1 = '607872183641618303'
-
/*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-03-21 06:25:12 Duration: 3ms Database: postgres parameters: $1 = '607872189504130303'
-
/*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-03-21 06:53:11 Duration: 2ms Database: postgres parameters: $1 = '607871133555174303'
17 19ms 18 0ms 4ms 1ms 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 bind #17
Day Hour Count Duration Avg duration 06 18 19ms 1ms -
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-03-21 06:40:03 Duration: 4ms 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-03-21 06:30:03 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-03-21 06:20:03 Duration: 1ms Database: postgres
18 19ms 20 0ms 2ms 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 bind #18
Day Hour Count Duration Avg duration 06 20 19ms 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-03-21 06:11:23 Duration: 2ms 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-03-21 06:18:48 Duration: 2ms 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-03-21 06:16:24 Duration: 1ms Database: postgres
19 18ms 4 3ms 6ms 4ms SELECT DISTINCT ON (basegroupname, symbol) ;Times Reported Time consuming bind #19
Day Hour Count Duration Avg duration 06 4 18ms 4ms -
SELECT DISTINCT ON (basegroupname, symbol) ;
Date: 2026-03-21 06:16:00 Duration: 6ms Database: postgres parameters: $1 = '627', $2 = '627'
-
SELECT DISTINCT ON (basegroupname, symbol) ;
Date: 2026-03-21 06:05:57 Duration: 5ms Database: postgres parameters: $1 = '667', $2 = '667'
-
SELECT DISTINCT ON (basegroupname, symbol) ;
Date: 2026-03-21 06:33:58 Duration: 3ms Database: postgres parameters: $1 = '538', $2 = '538'
20 15ms 20 0ms 1ms 0ms 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 bind #20
Day Hour Count Duration Avg duration 06 20 15ms 0ms -
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-03-21 06:18:48 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-03-21 06:11:23 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-03-21 06:06:22 Duration: 0ms Database: postgres
-
Events
Log levels
Key values
- 159,075 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 679 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 426 Max number of times the same event was reported
- 679 Total events found
Rank Times reported Error 1 426 ERROR: integer out of range
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 21 06 426 - ERROR: integer out of range
Statement: select stats_createSummaryTables_ChartPattens(cast(500996399105328207 as int));
Date: 2026-03-21 06:40:12
2 237 ERROR: canceling statement due to statement timeout
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 21 06 237 - ERROR: canceling statement due to statement timeout
Statement: /* service='datadog-agent' */ select count(*) from (select *, row_number() over (partition by whid order by id desc) r from whatshot_probability where "type" = 'cp' union select *, row_number() over (partition by whid order by id desc) r from whatshot_probability where "type" = 'ekl' union select *, row_number() over (partition by whid order by id desc) r from whatshot_probability where type = 'kl') as k where r > 3;
Date: 2026-03-21 06:00:14
3 11 LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 21 06 11 - LOG: process 29216 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.095 ms at character 28
- LOG: process 25283 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.040 ms at character 28
- LOG: process 31420 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.059 ms at character 28
Detail: Process holding the lock: 18146. Wait queue: 23753, 29216, 25283.
Statement: SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ATFX - 1'Date: 2026-03-21 06:17:08
Detail: Process holding the lock: 18146. Wait queue: 23753, 29216, 25283.
Statement: SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'FPMARKETS - 1'Date: 2026-03-21 06:17:09
Detail: Process holding the lock: 18146. Wait queue: 23753, 29216, 25283, 31420, 29538, 29771, 25992.
Statement: SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'Alpari - 1'Date: 2026-03-21 06:17:11
4 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Mar 21 06 4 - ERROR: relation "stats_by_groups" does not exist at character 32
- ERROR: relation "stats_symbols_by_groups" does not exist at character 60
Statement: select distinct s.statsid from stats_by_groups s inner join stats_symbols_by_groups ss on s.statsid = ss.statsid inner join downloadersymbolsettings dss on ss.symbolid = dss.symbolid inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid where dss.enabled = 1 and (0 = 0 or s.brokerid = 0) order by s.statsid
Date: 2026-03-21 06:42:01
Statement: select distinct ss.statsid from stats_success t inner join stats_symbols_by_groups ss on t.symbolid = ss.symbolid where statsid in (select statsid from stats_by_groups where (0 = 0 or brokerid = 0) ) and atbaridentified >= (current_timestamp - interval '12 months') and atbaridentified <= current_timestamp and type = 'cp' and pattern not ilike '%NON_LIQUID%' and (0 = 0 OR statsid >= 0) order by ss.statsid;
Date: 2026-03-21 06:42:01
5 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #5
Day Hour Count Mar 21 06 1 - LOG: process 23753 still waiting for AccessExclusiveLock on relation 5894441 of database 5881926 after 1000.040 ms
Detail: Process holding the lock: 18146. Wait queue: 23753.
Statement: refresh materialized view latest_candle_datetime_per_recengDate: 2026-03-21 06:17:02