pgBadger-
Global information
- Generated on Sat Mar 14 05:59:18 2026
- Log file: /home/postgres/pg_data/data/pg_log/postgresql-2026-03-14_070000.log
- Parsed 480,015 log entries in 17s
- Log start from 2026-03-14 07:00:00 to 2026-03-14 07:59:15
-
Overview
Global Stats
- 160 Number of unique normalized queries
- 72,800 Number of queries
- 1h46m46s Total query duration
- 2026-03-14 07:00:00 First query
- 2026-03-14 07:59:15 Last query
- 1,599 queries/s at 2026-03-14 07:15:04 Query peak
- 1h46m46s Total query duration
- 2s744ms Prepare/parse total duration
- 16s36ms Bind total duration
- 1h46m28s Execute total duration
- 389 Number of events
- 3 Number of unique normalized events
- 237 Max number of times the same event was reported
- 0 Number of cancellation
- 9 Total number of automatic vacuums
- 17 Total number of automatic analyzes
- 1,394 Number temporary file
- 618.59 MiB Max size of temporary file
- 94.74 MiB Average size of temporary file
- 1,540 Total number of sessions
- 12 sessions at 2026-03-14 07:54:28 Session peak
- 22h18m39s Total duration of sessions
- 52s155ms Average duration of sessions
- 47 Average queries per session
- 4s160ms Average queries duration per session
- 47s994ms Average idle time per session
- 1,540 Total number of connections
- 28 connections/s at 2026-03-14 07:03:48 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 1,599 queries/s Query Peak
- 2026-03-14 07:15:04 Date
SELECT Traffic
Key values
- 795 queries/s Query Peak
- 2026-03-14 07:15:04 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 115 queries/s Query Peak
- 2026-03-14 07:01:23 Date
Queries duration
Key values
- 1h46m46s 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 14 07 72,800 0ms 37s834ms 87ms 2m47s 3m7s 3m29s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 14 07 18,357 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 14 07 11,555 655 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Mar 14 07 9,770 19,208 1.97 28.88% Day Hour Count Average / Second Mar 14 07 1,540 0.43/s Day Hour Count Average Duration Average idle time Mar 14 07 1,540 52s155ms 48s7ms -
Connections
Established Connections
Key values
- 28 connections Connection Peak
- 2026-03-14 07:03:48 Date
Connections per database
Key values
- acaweb_fx Main Database
- 1,540 connections Total
Connections per user
Key values
- postgres Main User
- 1,540 connections Total
Connections per host
Key values
- 192.168.4.142 Main host with 763 connections
- 1,540 Total connections
-
Sessions
Simultaneous sessions
Key values
- 12 sessions Session Peak
- 2026-03-14 07:54:28 Date
Histogram of session times
Key values
- 1,198 0-500ms duration
Sessions per database
Key values
- acaweb_fx Main Database
- 1,540 sessions Total
Sessions per user
Key values
- postgres Main User
- 1,540 sessions Total
Sessions per host
Key values
- 192.168.4.142 Main Host
- 1,540 sessions Total
Host Count Total Duration Average Duration 192.168.0.114 4 44m25s 11m6s 192.168.0.216 116 6m16s 3s248ms 192.168.0.74 43 4h13m47s 5m54s 192.168.1.145 7 1h46m6s 15m9s 192.168.1.15 8 3h34m47s 26m50s 192.168.1.20 27 11h42m38s 26m1s 192.168.1.239 56 372ms 6ms 192.168.1.90 31 731ms 23ms 192.168.2.126 19 5s637ms 296ms 192.168.3.199 39 33s627ms 862ms 192.168.4.142 763 7m43s 607ms 192.168.4.33 61 24s879ms 407ms 192.168.4.98 330 13s470ms 40ms [local] 36 1m34s 2s637ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 2,289 buffers Checkpoint Peak
- 2026-03-14 07:07:19 Date
- 209.724 seconds Highest write time
- 2.787 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2026-03-14 07:21:17 Date
Checkpoints distance
Key values
- 24.25 Mo Distance Peak
- 2026-03-14 07:07:19 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Mar 14 07 10,416 1,024.652s 8.875s 1,037.056s Day Hour Added Removed Recycled Synced files Longest sync Average sync Mar 14 07 0 0 4 893 2.787s 0.09s Day Hour Count Avg time (sec) Mar 14 07 0 0s Day Hour Mean distance Mean estimate Mar 14 07 5,815.00 kB 142,028.92 kB -
Temporary Files
Size of temporary files
Key values
- 622.61 MiB Temp Files size Peak
- 2026-03-14 07:00:13 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2026-03-14 07:17:43 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Mar 14 07 1,394 128.98 GiB 94.74 MiB Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 250 427.48 MiB 137.65 KiB 4.02 MiB 1.71 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)) 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-14 07:00:13 Duration: 0ms
2 237 127.83 GiB 324.32 MiB 618.59 MiB 552.31 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-14 07:00:13 Duration: 0ms
3 105 188.11 MiB 137.65 KiB 4.18 MiB 1.79 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-14 07:00:42 Duration: 0ms
4 71 365.10 MiB 4.92 MiB 5.52 MiB 5.14 MiB select resultuid from relevance_fibonacci_results order by resultuid desc limit ?), fr as ( select a.*, rr.age, rr.relevant from fibonacci_results a left outer join relevance_fibonacci_results rr on a.resultuid = rr.resultuid where case when false = ? then true else a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) end), all_results as ( select fr.resultuid as resultuid, fr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, fr.pattern as pattern_name, fr.timed as timed, fr.patternendtime as identified, dtt.timezone as timezone, fr.patternlengthbars as length, g.basegroupname, newlevels.filtered, case when fr.age is not null then fr.age when fr.resultuid <= rm.resultuid then ? else ? end as age, case when fr.relevant is not null then fr.relevant when fr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from fr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = fr.symbolid inner join symbols s on fr.symbolid = s.symbolid and s.nonliquid = ? inner join symbolgroup sg on fr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join downloadersymbolsettings dss on fr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join rar_max rm on ? = ? left join lateral calc_fib_signal_filter (fr.resultuid) newlevels on true left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where fr.gmttimefound > now() - interval ? and dss.enabled = ? and s.deleted = ? and (fr.simulation = ? or fr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or fr.pattern in (...)) and (? = ? or fr.patternlengthbars <= ?) and (? = ? or (? = ? and fr.timed > cast(? as timestamp)) or (? = ? and fr.timed < cast(? as timestamp)))), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc;-
SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), fr AS ( SELECT a.*, rr.age, rr.relevant from fibonacci_results a LEFT OUTER JOIN relevance_fibonacci_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) END), all_results AS ( SELECT fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN fr.age IS NOT NULL THEN fr.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN fr.relevant IS NOT NULL THEN fr.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT JOIN LATERAL calc_fib_signal_filter (fr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($3 = 0 OR s.timegranularity in ($4)) AND ($5 = 0 OR s.exchange in ($6)) AND ($7 = 0 OR coalesce(bim.code, s.symbol) in ($8)) AND ($9 = 0 OR fr.pattern in ($10)) AND ($11 = 0 OR fr.patternlengthbars <= $12) AND ($13 = 0 OR ($14 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($15 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $16 OR relevant = 1) AND ($17 = 0 OR age <= $18) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;
Date: 2026-03-14 07:00:27 Duration: 0ms
5 17 153.95 MiB 9.06 MiB 9.06 MiB 9.06 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-14 07:01:08 Duration: 0ms
6 7 26.75 MiB 3.82 MiB 3.82 MiB 3.82 MiB select resultuid from relevance_consecutivecandles_results order by resultuid desc limit ?), all_results as ( select ccr.resultuid as resultuid, ccr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, ccr.patternendtime as identified, dtt.timezone as timezone, ccr.qtyconsecutivecandles as length, g.basegroupname, case when rcr.age is not null then rcr.age when ccr.resultuid <= rm.resultuid then ? else ? end as age, case when rcr.relevant is not null then rcr.relevant when ccr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip, newlevels.filtered from consecutivecandles_results ccr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = ccr.symbolid inner join symbols s on ccr.symbolid = s.symbolid and s.nonliquid = ? inner join downloadersymbolsettings dss on ccr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on ccr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join rar_max rm on ? = ? left outer join relevance_consecutivecandles_results rcr on rcr.resultuid = ccr.resultuid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? left join lateral calc_cc_signal_filter (ccr.resultuid) newlevels on true where ccr.gmttimefound > now() - interval ? and s.deleted = ? and (ccr.simulation = ? or ccr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ccr.patternlengthbars <= ?)), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc;-
SELECT resultuid FROM relevance_consecutivecandles_results ORDER BY resultuid DESC LIMIT 1), all_results AS ( SELECT ccr.resultuid AS resultuid, ccr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, ccr.patternendtime AS identified, dtt.timezone AS timezone, ccr.qtyconsecutivecandles AS length, g.basegroupname, CASE WHEN rcr.age IS NOT NULL THEN rcr.age WHEN ccr.resultuid <= rm.resultuid THEN 1 ELSE 0 END as age, CASE WHEN rcr.relevant IS NOT NULL THEN rcr.relevant WHEN ccr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip, newLevels.filtered FROM consecutivecandles_results ccr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = ccr.symbolid INNER JOIN symbols s ON ccr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN downloadersymbolsettings dss ON ccr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on ccr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_consecutivecandles_results rcr ON rcr.resultuid = ccr.resultuid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' LEFT JOIN LATERAL calc_cc_signal_filter (ccr.resultuid) newLevels on true WHERE ccr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (ccr.simulation = 0 OR ccr.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3, $4, $5, $6, $7, $8, $9)) AND ($10 = 0 OR s.exchange in ($11)) AND ($12 = 0 OR coalesce(bim.code, s.symbol) in ($13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322)) AND ($323 = 0 OR ccr.patternlengthbars <= $324)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $325 OR relevant = 1) AND ($326 = 0 OR age <= $327) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;
Date: 2026-03-14 07:02:57 Duration: 0ms
Queries generating the largest temporary files
Rank Size Query 1 618.59 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-14 07:00:13 ]
2 618.59 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-14 07:00:28 ]
3 618.59 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-14 07:00:43 ]
4 618.59 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-14 07:00:58 ]
5 618.59 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-14 07:01:12 ]
6 618.59 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-14 07:01:28 ]
7 618.59 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-14 07:01:42 ]
8 618.59 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-14 07:02:13 ]
9 618.59 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-14 07:02:28 ]
10 618.59 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-14 07:02:58 ]
11 618.59 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-14 07:03:14 ]
12 618.59 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-14 07:03:27 ]
13 618.59 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-14 07:03:42 ]
14 618.59 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-14 07:03:57 ]
15 618.59 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-14 07:04:12 ]
16 618.59 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-14 07:04:28 ]
17 618.59 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-14 07:04:42 ]
18 618.59 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-14 07:04:57 ]
19 594.62 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-14 07:39:28 ]
20 594.62 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-14 07:51:28 ]
-
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)
- 17 analyzes Total
Vacuums per table
Key values
- public.datafeeds_latestrun (3) Main table vacuumed on database acaweb_fx
- 9 vacuums Total
Index Buffer usage Skipped WAL usage Table Vacuums scans hits misses dirtied pins frozen records full page bytes acaweb_fx.public.datafeeds_latestrun 3 0 369 0 22 0 0 36 18 46,854 acaweb_fx.pg_catalog.pg_type 2 2 356 0 40 0 0 141 42 243,947 acaweb_fx.pg_catalog.pg_attribute 2 2 1,850 0 208 0 134 726 206 1,279,808 acaweb_fx.public.latest_t15_candle_view 1 1 94 0 4 0 0 6 1 9,061 acaweb_fx.pg_catalog.pg_class 1 1 259 0 42 0 78 114 43 236,143 Total 9 6 2,928 819 316 0 212 1,023 310 1,815,813 Tuples removed per table
Key values
- pg_catalog.pg_attribute (3623) Main table with removed tuples on database acaweb_fx
- 4571 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain acaweb_fx.pg_catalog.pg_attribute 2 2 3,623 21,338 0 0 534 acaweb_fx.pg_catalog.pg_type 2 2 662 2,910 0 0 90 acaweb_fx.public.datafeeds_latestrun 3 0 166 43 1 0 48 acaweb_fx.public.latest_t15_candle_view 1 1 60 12 0 0 1 acaweb_fx.pg_catalog.pg_class 1 1 60 2,591 0 0 150 Total 9 6 4,571 26,894 1 0 823 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.latest_t15_candle_view 1 1 60 0 acaweb_fx.pg_catalog.pg_type 2 2 662 0 acaweb_fx.public.datafeeds_latestrun 3 0 166 0 acaweb_fx.pg_catalog.pg_attribute 2 2 3623 0 acaweb_fx.pg_catalog.pg_class 1 1 60 0 Total 9 6 4,571 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Mar 14 07 9 17 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 18,357 Total read queries
- 15,471 Total write queries
Queries by database
Key values
- unknown Main database
- 72,158 Requests
- 1h46m28s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 72,158 Requests
User Request type Count Duration postgres Total 642 0ms others 215 0ms select 65 0ms tcl 334 0ms update 28 0ms unknown Total 72,158 1h46m28s cte 2,069 0ms insert 11,555 0ms others 2,476 0ms select 18,292 0ms tcl 858 0ms update 627 0ms Duration by user
Key values
- 1h46m28s (unknown) Main time consuming user
User Request type Count Duration postgres Total 642 0ms others 215 0ms select 65 0ms tcl 334 0ms update 28 0ms unknown Total 72,158 1h46m28s cte 2,069 0ms insert 11,555 0ms others 2,476 0ms select 18,292 0ms tcl 858 0ms update 627 0ms Queries by host
Key values
- unknown Main host
- 72,800 Requests
- 1h46m28s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 72,764 Requests
- 1h46m28s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 1 per second Cancelled query Peak
- 2026-03-14 07:32:58 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 24,697 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 2 0ms 0ms 0ms select key, value from datasources ds inner join datasourceparams dsp on ds.id = dsp.datasourceid where ds.name = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 14 07 2 0ms 0ms 2 0ms 140 0ms 0ms 0ms with rar_max as ( select resultuid from relevance_consecutivecandles_results order by resultuid desc limit ? ), all_results as ( select ccr.resultuid as resultuid, ccr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, ccr.patternendtime as identified, dtt.timezone as timezone, ccr.qtyconsecutivecandles as length, g.basegroupname, case when rcr.age is not null then rcr.age when ccr.resultuid <= rm.resultuid then ? else ? end as age, case when rcr.relevant is not null then rcr.relevant when ccr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip, newlevels.filtered from consecutivecandles_results ccr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = ccr.symbolid inner join symbols s on ccr.symbolid = s.symbolid and s.nonliquid = ? inner join downloadersymbolsettings dss on ccr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on ccr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join rar_max rm on ? = ? left outer join relevance_consecutivecandles_results rcr on rcr.resultuid = ccr.resultuid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? left join lateral calc_cc_signal_filter (ccr.resultuid) newlevels on true where ccr.gmttimefound > now() - interval ? and s.deleted = ? and (ccr.simulation = ? or ccr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ccr.patternlengthbars <= ?) ), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 14 07 140 0ms 0ms 3 0ms 2,411 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 #3
Day Hour Count Duration Avg duration Mar 14 07 2,411 0ms 0ms 4 0ms 19 0ms 0ms 0ms select case when a.old_resultuid = ? then a.old_resultuid else a.resultuid end as resultuid, s.symbol, timegranularity as interval, direction as direction, patternendtime as patternendtime, patternstartprice as psp, patternendprice as pep, target03 as t03, target16 as t16, patternlengthbars as length, p.patternname as patternname, dtt.timezone, cps.pip from fibonacci_results a inner join downloadersymbolsettings dss on a.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join fibonaccipatterns p on a.pattern = p.patternname left join currencypips cps on cps.symbol = s.symbol where (a.old_resultuid = ? or a.resultuid = ?) and dtt.dayofweek = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 14 07 19 0ms 0ms 5 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 #5
Day Hour Count Duration Avg duration Mar 14 07 237 0ms 0ms 6 0ms 279 0ms 0ms 0ms update patternresultsrelevance set relevant = ?, saxo_relevant = ?, notrelevantpricedatetime = ?, reason = ? where uniqueindex = ? and relevant = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 14 07 279 0ms 0ms 7 0ms 18 0ms 0ms 0ms select cast(count(*) / cast(setting as numeric) * ? as int) from pg_stat_activity, pg_settings where name = ? group by setting;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 14 07 18 0ms 0ms 8 0ms 237 0ms 0ms 0ms select v.datname, c.relname, v.phase, v.heap_blks_total, v.heap_blks_scanned, v.heap_blks_vacuumed, v.index_vacuum_count, v.max_dead_tuples, v.num_dead_tuples from pg_stat_progress_vacuum as v join pg_class c on c.oid = v.relid;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 14 07 237 0ms 0ms 9 0ms 21 0ms 0ms 0ms select * from ( select pricedatetime, open, high, low, close, volume, bsf from t60 where symbolid = ? and (bsf = ? or bsf is null) order by pricedatetime desc limit ?) a order by pricedatetime asc;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 14 07 21 0ms 0ms 10 0ms 444 0ms 0ms 0ms commit;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 14 07 444 0ms 0ms 11 0ms 216 0ms 0ms 0ms with rar_max as ( select resultuid from relevance_keylevels_results order by resultuid desc limit ? ), kr as ( select a.*, rr.age, rr.relevant from keylevels_results a left outer join relevance_keylevels_results rr on a.resultuid = rr.resultuid where case when false = ? then true else a.resultuid > ( select min(resultuid) from relevance_keylevels_results) end ), all_results as ( select kr.resultuid as resultuid, kr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, p.patternname as pattern_name, kr.breakout as breakout, kr.atbaridentified as identified, dtt.timezone as timezone, kr.patternlengthbars as length, g.basegroupname, newlevels.filtered, case when kr.age is not null then kr.age when kr.resultuid <= rm.resultuid then ? else ? end as age, case when kr.relevant is not null then kr.relevant when kr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from kr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = kr.symbolid inner join symbols s on bsl.symbolid = s.symbolid and s.nonliquid = ? inner join symbolgroup sg on s.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join hrspatterns p on kr.patternid = p.patternid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join rar_max rm on ? = ? left outer join autochartist_symbolupdates au on dss.symbolid = au.symbolid left outer join relevance_keylevels_results rar on rar.resultuid = kr.resultuid left join lateral calc_kl_signal_filter (kr.resultuid) newlevels on true left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where kr.gmttimefound > now() - interval ? and dss.enabled = ? and s.deleted = ? and (kr.simulation = ? or kr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or p.patternname in (...)) and (? = ? or kr.patternclassid in (...)) and (? = ? or kr.patternlengthbars <= ?) and kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, ?::timestamp without time zone) -- to make sure patternstarttime is in our t-tables ), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 14 07 216 0ms 0ms 12 0ms 2 0ms 0ms 0ms select psd.symbolid, psd.hourlysymbolid as intervalsymbolid, s.symbol, dtt.timezone, dtt.absolutetimezoneoffset, psh.hour as index, psh.ave, psh.stddev, ((psh.ave - psh.stddev) / ?.?) as low, ((psh.ave + psh.stddev) / ?.?) as high, ee.timezone as exchangetimezone, ee.mon_t1start as exchangestart, ee.mon_t1end as exchangeend from powerstats_symboldata psd inner join powerstats_hourly psh on psd.hourlysymbolid = psh.symbolid inner join symbols s on psh.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join mat_ps_hourly_symbolid_max_enddate e on psh.enddate = e.enddate and psh.symbolid = e.symbolid inner join exchanges ee on ee.exchange = s.exchange where psd.symbolid = ? and dtt.dayofweek = ? order by hour asc;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 14 07 2 0ms 0ms 13 0ms 237 0ms 0ms 0ms select count(*), sum(size), extract(epoch from now() - min(modification)) from pg_ls_waldir ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 14 07 237 0ms 0ms 14 0ms 24 0ms 0ms 0ms select * from ( select pricedatetime, open, high, low, close, volume, bsf from t30 where symbolid = ? and (bsf = ? or bsf is null) order by pricedatetime desc limit ?) a order by pricedatetime asc;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 14 07 24 0ms 0ms 15 0ms 6 0ms 0ms 0ms select pid, datname, client_addr from pg_stat_activity where query ilike ? and pid <> pg_backend_pid() and state = ? and datname = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 14 07 6 0ms 0ms 16 0ms 2 0ms 0ms 0ms update executions set isrunning = false, has_results = false, response = ? where id = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 14 07 2 0ms 0ms 17 0ms 237 0ms 0ms 0ms select system_identifier from pg_control_system ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 14 07 237 0ms 0ms 18 0ms 237 0ms 0ms 0ms select datname, confl_tablespace, confl_lock, confl_snapshot, confl_bufferpin, confl_deadlock from pg_stat_database_conflicts where datname not ilike ? and datname not ilike ? and datname not ilike ? and datname not ilike ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 14 07 237 0ms 0ms 19 0ms 36 0ms 0ms 0ms select * from broker_stats_breakout_categories_view where statsid = ? limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 14 07 36 0ms 0ms 20 0ms 140 0ms 0ms 0ms with rar_max as ( select resultuid from relevance_bigmovement_results order by resultuid desc limit ? ), all_results as ( select bmr.resultuid as resultuid, ? 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, bmr.patternendtime as identified, bmr.patternlengthbars, dtt.timezone as timezone, g.basegroupname, case when rbr.age is not null then rbr.age when bmr.resultuid <= rm.resultuid then ? else ? end as age, case when rbr.relevant is not null then rbr.relevant when bmr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from bigmovement_results bmr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = bmr.symbolid inner join symbols s on bmr.symbolid = s.symbolid and s.nonliquid = ? inner join downloadersymbolsettings dss on bmr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on bmr.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_bigmovement_results rbr on rbr.resultuid = bmr.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 = ? where bmr.gmttimefound > now() - interval ? and s.deleted = ? and (bmr.simulation = ? or bmr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or bmr.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, interval desc;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 14 07 140 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 3,358 0ms 0ms 0ms 0ms select ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 14 07 3,358 0ms 0ms 2 2,881 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 14 07 2,881 0ms 0ms 3 2,659 0ms 0ms 0ms 0ms insert into executionlogs (executionid, status, message, details, detailtype) values (null, ?, ?, null, null);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 14 07 2,659 0ms 0ms 4 2,440 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 #4
Day Hour Count Duration Avg duration Mar 14 07 2,440 0ms 0ms 5 2,411 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 #5
Day Hour Count Duration Avg duration Mar 14 07 2,411 0ms 0ms 6 1,451 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 #6
Day Hour Count Duration Avg duration Mar 14 07 1,451 0ms 0ms 7 1,262 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 #7
Day Hour Count Duration Avg duration Mar 14 07 1,262 0ms 0ms 8 966 0ms 0ms 0ms 0ms select datetimeupdate from latest_candle_datetime_per_receng where recognitionengine ilike ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 14 07 966 0ms 0ms 9 884 0ms 0ms 0ms 0ms set extra_float_digits = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 14 07 884 0ms 0ms 10 872 0ms 0ms 0ms 0ms set application_name = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 14 07 872 0ms 0ms 11 596 0ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 14 07 596 0ms 0ms 12 578 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 #12
Day Hour Count Duration Avg duration Mar 14 07 578 0ms 0ms 13 477 0ms 0ms 0ms 0ms set statement_timeout = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 14 07 477 0ms 0ms 14 444 0ms 0ms 0ms 0ms commit;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 14 07 444 0ms 0ms 15 350 0ms 0ms 0ms 0ms insert into t240 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 14 07 350 0ms 0ms 16 332 0ms 0ms 0ms 0ms update datafeeds_latestrun set latestrxtime = subquery.latestrxtime, latestdbwritetime = subquery.latestdbwritetime from ( select latestrxtime, latestdbwritetime from latest_t15_candle_view where classname ilike ?) as subquery where datafeeds_latestrun.feedname ilike ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 14 07 332 0ms 0ms 17 288 0ms 0ms 0ms 0ms insert into t1440_underlying (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 14 07 288 0ms 0ms 18 279 0ms 0ms 0ms 0ms update patternresultsrelevance set relevant = ?, saxo_relevant = ?, notrelevantpricedatetime = ?, reason = ? where uniqueindex = ? and relevant = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 14 07 279 0ms 0ms 19 266 0ms 0ms 0ms 0ms select pg_advisory_unlock_all(); close "..." unlisten *; reset all;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 14 07 266 0ms 0ms 20 237 0ms 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 #20
Day Hour Count Duration Avg duration Mar 14 07 237 0ms 0ms Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 0ms 0ms 0ms 2 0ms select key, value from datasources ds inner join datasourceparams dsp on ds.id = dsp.datasourceid where ds.name = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 14 07 2 0ms 0ms 2 0ms 0ms 0ms 140 0ms with rar_max as ( select resultuid from relevance_consecutivecandles_results order by resultuid desc limit ? ), all_results as ( select ccr.resultuid as resultuid, ccr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, ccr.patternendtime as identified, dtt.timezone as timezone, ccr.qtyconsecutivecandles as length, g.basegroupname, case when rcr.age is not null then rcr.age when ccr.resultuid <= rm.resultuid then ? else ? end as age, case when rcr.relevant is not null then rcr.relevant when ccr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip, newlevels.filtered from consecutivecandles_results ccr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = ccr.symbolid inner join symbols s on ccr.symbolid = s.symbolid and s.nonliquid = ? inner join downloadersymbolsettings dss on ccr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on ccr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join rar_max rm on ? = ? left outer join relevance_consecutivecandles_results rcr on rcr.resultuid = ccr.resultuid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? left join lateral calc_cc_signal_filter (ccr.resultuid) newlevels on true where ccr.gmttimefound > now() - interval ? and s.deleted = ? and (ccr.simulation = ? or ccr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ccr.patternlengthbars <= ?) ), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 14 07 140 0ms 0ms 3 0ms 0ms 0ms 2,411 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 #3
Day Hour Count Duration Avg duration Mar 14 07 2,411 0ms 0ms 4 0ms 0ms 0ms 19 0ms select case when a.old_resultuid = ? then a.old_resultuid else a.resultuid end as resultuid, s.symbol, timegranularity as interval, direction as direction, patternendtime as patternendtime, patternstartprice as psp, patternendprice as pep, target03 as t03, target16 as t16, patternlengthbars as length, p.patternname as patternname, dtt.timezone, cps.pip from fibonacci_results a inner join downloadersymbolsettings dss on a.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join fibonaccipatterns p on a.pattern = p.patternname left join currencypips cps on cps.symbol = s.symbol where (a.old_resultuid = ? or a.resultuid = ?) and dtt.dayofweek = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 14 07 19 0ms 0ms 5 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 #5
Day Hour Count Duration Avg duration Mar 14 07 237 0ms 0ms 6 0ms 0ms 0ms 279 0ms update patternresultsrelevance set relevant = ?, saxo_relevant = ?, notrelevantpricedatetime = ?, reason = ? where uniqueindex = ? and relevant = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 14 07 279 0ms 0ms 7 0ms 0ms 0ms 18 0ms select cast(count(*) / cast(setting as numeric) * ? as int) from pg_stat_activity, pg_settings where name = ? group by setting;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 14 07 18 0ms 0ms 8 0ms 0ms 0ms 237 0ms select v.datname, c.relname, v.phase, v.heap_blks_total, v.heap_blks_scanned, v.heap_blks_vacuumed, v.index_vacuum_count, v.max_dead_tuples, v.num_dead_tuples from pg_stat_progress_vacuum as v join pg_class c on c.oid = v.relid;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 14 07 237 0ms 0ms 9 0ms 0ms 0ms 21 0ms select * from ( select pricedatetime, open, high, low, close, volume, bsf from t60 where symbolid = ? and (bsf = ? or bsf is null) order by pricedatetime desc limit ?) a order by pricedatetime asc;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 14 07 21 0ms 0ms 10 0ms 0ms 0ms 444 0ms commit;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 14 07 444 0ms 0ms 11 0ms 0ms 0ms 216 0ms with rar_max as ( select resultuid from relevance_keylevels_results order by resultuid desc limit ? ), kr as ( select a.*, rr.age, rr.relevant from keylevels_results a left outer join relevance_keylevels_results rr on a.resultuid = rr.resultuid where case when false = ? then true else a.resultuid > ( select min(resultuid) from relevance_keylevels_results) end ), all_results as ( select kr.resultuid as resultuid, kr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, p.patternname as pattern_name, kr.breakout as breakout, kr.atbaridentified as identified, dtt.timezone as timezone, kr.patternlengthbars as length, g.basegroupname, newlevels.filtered, case when kr.age is not null then kr.age when kr.resultuid <= rm.resultuid then ? else ? end as age, case when kr.relevant is not null then kr.relevant when kr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from kr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = kr.symbolid inner join symbols s on bsl.symbolid = s.symbolid and s.nonliquid = ? inner join symbolgroup sg on s.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join hrspatterns p on kr.patternid = p.patternid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join rar_max rm on ? = ? left outer join autochartist_symbolupdates au on dss.symbolid = au.symbolid left outer join relevance_keylevels_results rar on rar.resultuid = kr.resultuid left join lateral calc_kl_signal_filter (kr.resultuid) newlevels on true left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where kr.gmttimefound > now() - interval ? and dss.enabled = ? and s.deleted = ? and (kr.simulation = ? or kr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or p.patternname in (...)) and (? = ? or kr.patternclassid in (...)) and (? = ? or kr.patternlengthbars <= ?) and kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, ?::timestamp without time zone) -- to make sure patternstarttime is in our t-tables ), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 14 07 216 0ms 0ms 12 0ms 0ms 0ms 2 0ms select psd.symbolid, psd.hourlysymbolid as intervalsymbolid, s.symbol, dtt.timezone, dtt.absolutetimezoneoffset, psh.hour as index, psh.ave, psh.stddev, ((psh.ave - psh.stddev) / ?.?) as low, ((psh.ave + psh.stddev) / ?.?) as high, ee.timezone as exchangetimezone, ee.mon_t1start as exchangestart, ee.mon_t1end as exchangeend from powerstats_symboldata psd inner join powerstats_hourly psh on psd.hourlysymbolid = psh.symbolid inner join symbols s on psh.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join mat_ps_hourly_symbolid_max_enddate e on psh.enddate = e.enddate and psh.symbolid = e.symbolid inner join exchanges ee on ee.exchange = s.exchange where psd.symbolid = ? and dtt.dayofweek = ? order by hour asc;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 14 07 2 0ms 0ms 13 0ms 0ms 0ms 237 0ms select count(*), sum(size), extract(epoch from now() - min(modification)) from pg_ls_waldir ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 14 07 237 0ms 0ms 14 0ms 0ms 0ms 24 0ms select * from ( select pricedatetime, open, high, low, close, volume, bsf from t30 where symbolid = ? and (bsf = ? or bsf is null) order by pricedatetime desc limit ?) a order by pricedatetime asc;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 14 07 24 0ms 0ms 15 0ms 0ms 0ms 6 0ms select pid, datname, client_addr from pg_stat_activity where query ilike ? and pid <> pg_backend_pid() and state = ? and datname = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 14 07 6 0ms 0ms 16 0ms 0ms 0ms 2 0ms update executions set isrunning = false, has_results = false, response = ? where id = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 14 07 2 0ms 0ms 17 0ms 0ms 0ms 237 0ms select system_identifier from pg_control_system ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 14 07 237 0ms 0ms 18 0ms 0ms 0ms 237 0ms select datname, confl_tablespace, confl_lock, confl_snapshot, confl_bufferpin, confl_deadlock from pg_stat_database_conflicts where datname not ilike ? and datname not ilike ? and datname not ilike ? and datname not ilike ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 14 07 237 0ms 0ms 19 0ms 0ms 0ms 36 0ms select * from broker_stats_breakout_categories_view where statsid = ? limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 14 07 36 0ms 0ms 20 0ms 0ms 0ms 140 0ms with rar_max as ( select resultuid from relevance_bigmovement_results order by resultuid desc limit ? ), all_results as ( select bmr.resultuid as resultuid, ? 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, bmr.patternendtime as identified, bmr.patternlengthbars, dtt.timezone as timezone, g.basegroupname, case when rbr.age is not null then rbr.age when bmr.resultuid <= rm.resultuid then ? else ? end as age, case when rbr.relevant is not null then rbr.relevant when bmr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from bigmovement_results bmr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = bmr.symbolid inner join symbols s on bmr.symbolid = s.symbolid and s.nonliquid = ? inner join downloadersymbolsettings dss on bmr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on bmr.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_bigmovement_results rbr on rbr.resultuid = bmr.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 = ? where bmr.gmttimefound > now() - interval ? and s.deleted = ? and (bmr.simulation = ? or bmr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or bmr.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, interval desc;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 14 07 140 0ms 0ms Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1s82ms 680 0ms 2ms 1ms SELECT symbolid, ;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Mar 14 07 680 1s82ms 1ms -
SELECT symbolid, ;
Date: 2026-03-14 07:17:52 Duration: 2ms Database: postgres
-
SELECT symbolid, ;
Date: 2026-03-14 07:36:51 Duration: 2ms Database: postgres
-
SELECT symbolid, ;
Date: 2026-03-14 07:11:01 Duration: 2ms Database: postgres
2 419ms 396 0ms 17ms 1ms WITH rar_max as ( ;Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 07 396 419ms 1ms -
WITH rar_max as ( ;
Date: 2026-03-14 07:07:39 Duration: 17ms Database: postgres
-
WITH rar_max as ( ;
Date: 2026-03-14 07:38:37 Duration: 8ms Database: postgres
-
WITH rar_max as ( ;
Date: 2026-03-14 07:38:37 Duration: 7ms Database: postgres
3 252ms 2,318 0ms 2ms 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 #3
Day Hour Count Duration Avg duration 07 2,318 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-14 07:02:57 Duration: 2ms 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-14 07:02:34 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-14 07:10:41 Duration: 0ms Database: postgres
4 213ms 2,418 0ms 1ms 0ms INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming prepare #4
Day Hour Count Duration Avg duration 07 2,418 213ms 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-14 07:02:53 Duration: 1ms Database: postgres
-
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-14 07:32:42 Duration: 0ms Database: postgres
-
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-14 07:41:01 Duration: 0ms Database: postgres
5 132ms 884 0ms 6ms 0ms SET extra_float_digits = 3;Times Reported Time consuming prepare #5
Day Hour Count Duration Avg duration 07 884 132ms 0ms -
SET extra_float_digits = 3;
Date: 2026-03-14 07:58:14 Duration: 6ms Database: postgres
-
SET extra_float_digits = 3;
Date: 2026-03-14 07:01:27 Duration: 0ms Database: postgres
-
SET extra_float_digits = 3;
Date: 2026-03-14 07:31:01 Duration: 0ms Database: postgres
6 127ms 118 0ms 1ms 1ms SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;Times Reported Time consuming prepare #6
Day Hour Count Duration Avg duration 07 118 127ms 1ms -
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-14 07:45:46 Duration: 1ms Database: postgres
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-14 07:00:32 Duration: 1ms Database: postgres
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-14 07:11:02 Duration: 1ms Database: postgres
7 127ms 411 0ms 4ms 0ms SELECT ;Times Reported Time consuming prepare #7
Day Hour Count Duration Avg duration 07 411 127ms 0ms -
SELECT ;
Date: 2026-03-14 07:38:37 Duration: 4ms Database: postgres
-
SELECT ;
Date: 2026-03-14 07:58:45 Duration: 1ms Database: postgres
-
SELECT ;
Date: 2026-03-14 07:58:45 Duration: 1ms Database: postgres
8 124ms 649 0ms 0ms 0ms INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming prepare #8
Day Hour Count Duration Avg duration 07 649 124ms 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-14 07:35:21 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-14 07:32:57 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-14 07:32:27 Duration: 0ms Database: postgres
9 45ms 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 #9
Day Hour Count Duration Avg duration 07 288 45ms 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-14 07:32:26 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-14 07:32:41 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-14 07:31:54 Duration: 0ms Database: postgres
10 44ms 350 0ms 1ms 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 #10
Day Hour Count Duration Avg duration 07 350 44ms 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-14 07:47:52 Duration: 1ms 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-14 07:32:51 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-14 07:02:25 Duration: 0ms Database: postgres
11 40ms 18 1ms 2ms 2ms select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;Times Reported Time consuming prepare #11
Day Hour Count Duration Avg duration 07 18 40ms 2ms -
select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;
Date: 2026-03-14 07:01: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-14 07:50: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-14 07:00:03 Duration: 2ms Database: postgres
12 27ms 24 0ms 1ms 1ms select distinct classname, to_char(created_datetime, 'yyyy-mm-dd HH24:MI'), to_char(cleared_datetime, 'yyyy-mm-dd HH24:MI'), action_to_take, description, created_datetime from datafeed_restarter_events where (is_current_entry = 1 OR cleared_datetime > current_timestamp - interval '17 hour') order by created_datetime desc;Times Reported Time consuming prepare #12
Day Hour Count Duration Avg duration 07 24 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-14 07:27:52 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-14 07:22:51 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-14 07:07:46 Duration: 1ms Database: postgres
13 22ms 24 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 #13
Day Hour Count Duration Avg duration 07 24 22ms 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-14 07:32:53 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-14 07:57:59 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-14 07:57:59 Duration: 1ms Database: postgres
14 17ms 6 2ms 3ms 2ms select client_addr, count(1) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by client_addr, setting having (client_addr is not null OR (client_addr is null and count(1) > (cast(setting as numeric) / 3 * 2))) order by count desc;Times Reported Time consuming prepare #14
Day Hour Count Duration Avg duration 07 6 17ms 2ms -
select client_addr, count(1) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by client_addr, setting having (client_addr is not null OR (client_addr is null and count(1) > (cast(setting as numeric) / 3 * 2))) order by count desc;
Date: 2026-03-14 07:00: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-14 07:10: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-14 07:40:05 Duration: 3ms Database: postgres
15 10ms 872 0ms 0ms 0ms SET application_name = 'PostgreSQL JDBC Driver';Times Reported Time consuming prepare #15
Day Hour Count Duration Avg duration 07 872 10ms 0ms -
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2026-03-14 07:50:06 Duration: 0ms Database: postgres
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2026-03-14 07:03:00 Duration: 0ms Database: postgres
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2026-03-14 07:30:36 Duration: 0ms Database: postgres
16 7ms 24 0ms 0ms 0ms select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng;Times Reported Time consuming prepare #16
Day Hour Count Duration Avg duration 07 24 7ms 0ms -
select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng;
Date: 2026-03-14 07:22:51 Duration: 0ms Database: postgres
-
select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng;
Date: 2026-03-14 07:17:49 Duration: 0ms Database: postgres
-
select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng;
Date: 2026-03-14 07:27:52 Duration: 0ms Database: postgres
17 7ms 167 0ms 0ms 0ms select 1;Times Reported Time consuming prepare #17
Day Hour Count Duration Avg duration 07 167 7ms 0ms -
select 1;
Date: 2026-03-14 07:07:26 Duration: 0ms Database: postgres
-
select 1;
Date: 2026-03-14 07:38:37 Duration: 0ms Database: postgres
-
select 1;
Date: 2026-03-14 07:53:25 Duration: 0ms Database: postgres
18 4ms 1 4ms 4ms 4ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 538 LIMIT $1;Times Reported Time consuming prepare #18
Day Hour Count Duration Avg duration 07 1 4ms 4ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 538 LIMIT $1;
Date: 2026-03-14 07:01:22 Duration: 4ms Database: postgres
19 3ms 1 3ms 3ms 3ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 632 LIMIT $1;Times Reported Time consuming prepare #19
Day Hour Count Duration Avg duration 07 1 3ms 3ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 632 LIMIT $1;
Date: 2026-03-14 07:01:22 Duration: 3ms Database: postgres
20 3ms 2 1ms 1ms 1ms select count(*) from ( select b.resultuid, classname, patternendtime from downloadersymbolsettings dss inner join autochartist_results b on dss.symbolid = b.symbolid inner join relevance_autochartist_results ar on b.resultuid = ar.resultuid where b.symbolid in ( select symbolid from symbols where timegranularity = 1440) and extract(minute from patternendtime) <> 0) as a;Times Reported Time consuming prepare #20
Day Hour Count Duration Avg duration 07 2 3ms 1ms -
select count(*) from ( select b.resultuid, classname, patternendtime from downloadersymbolsettings dss inner join autochartist_results b on dss.symbolid = b.symbolid inner join relevance_autochartist_results ar on b.resultuid = ar.resultuid where b.symbolid in ( select symbolid from symbols where timegranularity = 1440) and extract(minute from patternendtime) <> 0) as a;
Date: 2026-03-14 07:00:05 Duration: 1ms Database: postgres
-
select count(*) from ( select b.resultuid, classname, patternendtime from downloadersymbolsettings dss inner join autochartist_results b on dss.symbolid = b.symbolid inner join relevance_autochartist_results ar on b.resultuid = ar.resultuid where b.symbolid in ( select symbolid from symbols where timegranularity = 1440) and extract(minute from patternendtime) <> 0) as a;
Date: 2026-03-14 07:00:08 Duration: 1ms Database: postgres
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 10s770ms 1,156 0ms 54ms 9ms WITH rar_max as ( ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Mar 14 07 1,156 10s770ms 9ms -
WITH rar_max as ( ;
Date: 2026-03-14 07:38:37 Duration: 54ms Database: postgres parameters: $1 = '607833438742145301', $2 = '607833438742145301', $3 = '607833438742145301'
-
WITH rar_max as ( ;
Date: 2026-03-14 07:04:16 Duration: 43ms Database: postgres parameters: $1 = 't', $2 = '667', $3 = '7', $4 = '15', $5 = '30', $6 = '60', $7 = '120', $8 = '240', $9 = '480', $10 = '1440', $11 = '0', $12 = '', $13 = '84', $14 = 'AUDCAD', $15 = 'AUDCHF', $16 = 'AUDJPY', $17 = 'AUDNZD', $18 = 'AUDSGD', $19 = 'CADCHF', $20 = 'CADJPY', $21 = 'CHFJPY', $22 = 'EURAUD', $23 = 'EURCAD', $24 = 'EURCHF', $25 = 'EURCZK', $26 = 'EURGBP', $27 = 'EURHUF', $28 = 'EURJPY', $29 = 'EURNOK', $30 = 'EURNZD', $31 = 'EURPLN', $32 = 'EURSEK', $33 = 'EURSGD', $34 = 'EURTRY', $35 = 'EURZAR', $36 = 'GBPAUD', $37 = 'GBPCAD', $38 = 'GBPCHF', $39 = 'GBPJPY', $40 = 'GBPNZD', $41 = 'GBPPLN', $42 = 'GBPSEK', $43 = 'GBPSGD', $44 = 'NZDCAD', $45 = 'NZDCHF', $46 = 'NZDJPY', $47 = 'NZDSGD', $48 = 'USDCNH', $49 = 'USDCZK', $50 = 'USDHUF', $51 = 'USDNOK', $52 = 'USDPLN', $53 = 'USDSEK', $54 = 'USDSGD', $55 = 'USDTRY', $56 = 'USDZAR', $57 = 'WTI', $58 = 'XBRUSD', $59 = 'XTIUSD', $60 = 'BTCUSD', $61 = 'XAGAUD', $62 = 'XAGUSD', $63 = 'XAUAUD', $64 = 'XAUUSD', $65 = 'XPTUSD', $66 = 'XPDUSD', $67 = 'AUDUSD', $68 = 'EURUSD', $69 = 'GBPUSD', $70 = 'NZDUSD', $71 = 'USDCAD', $72 = 'USDCHF', $73 = 'USDHKD', $74 = 'USDJPY', $75 = 'AUS200', $76 = 'CHINA300', $77 = 'CHINA50', $78 = 'DJ30', $79 = 'ESP35t', $80 = 'EUR50', $81 = 'EURO50', $82 = 'FRA40', $83 = 'GDAXI', $84 = 'GDAXIm', $85 = 'HK50', $86 = 'ITA40', $87 = 'J225', $88 = 'JP225', $89 = 'NAS100', $90 = 'SING30', $91 = 'SPA35', $92 = 'STOXX50', $93 = 'SUI20', $94 = 'UK100', $95 = 'US100', $96 = 'US30', $97 = 'US500', $98 = '0', $99 = '', $100 = '0', $101 = '0', $102 = '0', $103 = '500', $104 = '500', $105 = 't', $106 = '10', $107 = '10'
-
WITH rar_max as ( ;
Date: 2026-03-14 07:59:15 Duration: 42ms Database: postgres parameters: $1 = 't', $2 = '667', $3 = '7', $4 = '15', $5 = '30', $6 = '60', $7 = '120', $8 = '240', $9 = '480', $10 = '1440', $11 = '0', $12 = '', $13 = '84', $14 = 'AUDCAD', $15 = 'AUDCHF', $16 = 'AUDJPY', $17 = 'AUDNZD', $18 = 'AUDSGD', $19 = 'CADCHF', $20 = 'CADJPY', $21 = 'CHFJPY', $22 = 'EURAUD', $23 = 'EURCAD', $24 = 'EURCHF', $25 = 'EURCZK', $26 = 'EURGBP', $27 = 'EURHUF', $28 = 'EURJPY', $29 = 'EURNOK', $30 = 'EURNZD', $31 = 'EURPLN', $32 = 'EURSEK', $33 = 'EURSGD', $34 = 'EURTRY', $35 = 'EURZAR', $36 = 'GBPAUD', $37 = 'GBPCAD', $38 = 'GBPCHF', $39 = 'GBPJPY', $40 = 'GBPNZD', $41 = 'GBPPLN', $42 = 'GBPSEK', $43 = 'GBPSGD', $44 = 'NZDCAD', $45 = 'NZDCHF', $46 = 'NZDJPY', $47 = 'NZDSGD', $48 = 'USDCNH', $49 = 'USDCZK', $50 = 'USDHUF', $51 = 'USDNOK', $52 = 'USDPLN', $53 = 'USDSEK', $54 = 'USDSGD', $55 = 'USDTRY', $56 = 'USDZAR', $57 = 'WTI', $58 = 'XBRUSD', $59 = 'XTIUSD', $60 = 'BTCUSD', $61 = 'XAGAUD', $62 = 'XAGUSD', $63 = 'XAUAUD', $64 = 'XAUUSD', $65 = 'XPTUSD', $66 = 'XPDUSD', $67 = 'AUDUSD', $68 = 'EURUSD', $69 = 'GBPUSD', $70 = 'NZDUSD', $71 = 'USDCAD', $72 = 'USDCHF', $73 = 'USDHKD', $74 = 'USDJPY', $75 = 'AUS200', $76 = 'CHINA300', $77 = 'CHINA50', $78 = 'DJ30', $79 = 'ESP35t', $80 = 'EUR50', $81 = 'EURO50', $82 = 'FRA40', $83 = 'GDAXI', $84 = 'GDAXIm', $85 = 'HK50', $86 = 'ITA40', $87 = 'J225', $88 = 'JP225', $89 = 'NAS100', $90 = 'SING30', $91 = 'SPA35', $92 = 'STOXX50', $93 = 'SUI20', $94 = 'UK100', $95 = 'US100', $96 = 'US30', $97 = 'US500', $98 = '0', $99 = '', $100 = '0', $101 = '0', $102 = '0', $103 = '500', $104 = '500', $105 = 't', $106 = '10', $107 = '10'
2 1s879ms 680 1ms 4ms 2ms SELECT symbolid, ;Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 07 680 1s879ms 2ms -
SELECT symbolid, ;
Date: 2026-03-14 07:15:35 Duration: 4ms Database: postgres parameters: $1 = 'GLOBALGTMT5', $2 = '15', $3 = 'DOGUSD'
-
SELECT symbolid, ;
Date: 2026-03-14 07:31:22 Duration: 4ms Database: postgres parameters: $1 = 'ATFX', $2 = '15', $3 = 'SPX500', $4 = 'US30'
-
SELECT symbolid, ;
Date: 2026-03-14 07:02:56 Duration: 4ms Database: postgres parameters: $1 = 'BDSWISS', $2 = '30', $3 = 'NAS100', $4 = 'HKG_50'
3 1s207ms 3,184 0ms 11ms 0ms SELECT ;Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 07 3,184 1s207ms 0ms -
SELECT ;
Date: 2026-03-14 07:03:49 Duration: 11ms Database: postgres parameters: $1 = '515840243198780300'
-
SELECT ;
Date: 2026-03-14 07:03:49 Duration: 9ms Database: postgres parameters: $1 = '515840243198780300'
-
SELECT ;
Date: 2026-03-14 07:53:26 Duration: 5ms Database: postgres parameters: $1 = '558', $2 = '1440', $3 = '1440', $4 = 'GBPJPY', $5 = 'GBPJPY'
4 286ms 45 4ms 9ms 6ms WITH last_candle AS ( ;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 07 45 286ms 6ms -
WITH last_candle AS ( ;
Date: 2026-03-14 07:32:00 Duration: 9ms Database: postgres parameters: $1 = '558', $2 = '558'
-
WITH last_candle AS ( ;
Date: 2026-03-14 07:08:00 Duration: 8ms Database: postgres parameters: $1 = '558', $2 = '558'
-
WITH last_candle AS ( ;
Date: 2026-03-14 07:24:00 Duration: 8ms Database: postgres parameters: $1 = '558', $2 = '558'
5 213ms 118 1ms 2ms 1ms SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 07 118 213ms 1ms -
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-14 07:46:12 Duration: 2ms Database: postgres parameters: $1 = 'ATFX'
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-14 07:45:46 Duration: 2ms Database: postgres parameters: $1 = 'AXIORY'
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-14 07:30:24 Duration: 2ms Database: postgres parameters: $1 = 'PEPPERSTONEMT5'
6 200ms 2,411 0ms 0ms 0ms INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming bind #6
Day Hour Count Duration Avg duration 07 2,411 200ms 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-14 07:32:26 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 23:00:00', $2 = '111.627', $3 = '111.6395', $4 = '111.4955', $5 = '111.5065', $6 = '4322', $7 = '515840249384093300', $8 = '0', $9 = '2026-03-14 07:32:26.893', $10 = '2026-03-14 07:32:26.764', $11 = '111.627', $12 = '111.6395', $13 = '111.4955', $14 = '111.5065', $15 = '4322', $16 = '0', $17 = '2026-03-14 07:32:26.893', $18 = '2026-03-14 07:32:26.764'
-
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-14 07:02:34 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 20:00:00', $2 = '198.77', $3 = '199.23', $4 = '198.77', $5 = '199.13', $6 = '315', $7 = '515840247929791300', $8 = '0', $9 = '2026-03-14 07:02:34.045', $10 = '2026-03-14 07:02:33.974', $11 = '198.77', $12 = '199.23', $13 = '198.77', $14 = '199.13', $15 = '315', $16 = '0', $17 = '2026-03-14 07:02:34.045', $18 = '2026-03-14 07:02:33.974'
-
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-14 07:10:41 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 20:00:00', $2 = '8559.4', $3 = '8579.95', $4 = '8548.4', $5 = '8569.9', $6 = '13086', $7 = '515840248015562300', $8 = '0', $9 = '2026-03-14 07:10:41.277', $10 = '2026-03-14 07:10:41.177', $11 = '8559.4', $12 = '8579.95', $13 = '8548.4', $14 = '8569.9', $15 = '13086', $16 = '0', $17 = '2026-03-14 07:10:41.277', $18 = '2026-03-14 07:10:41.177'
7 176ms 2,440 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 #7
Day Hour Count Duration Avg duration 07 2,440 176ms 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-14 07:35:21 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 22:30:00', $2 = '0.55348', $3 = '0.55352', $4 = '0.55307', $5 = '0.5531', $6 = '3293', $7 = '515840230422390300', $8 = '0', $9 = '2026-03-14 07:35:21.433', $10 = '2026-03-14 07:35:21.426', $11 = '0.55348', $12 = '0.55352', $13 = '0.55307', $14 = '0.5531', $15 = '3293', $16 = '0', $17 = '2026-03-14 07:35:21.433', $18 = '2026-03-14 07:35:21.426'
-
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-14 07:41:01 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 22:00:00', $2 = '46513.35', $3 = '46544.75', $4 = '46511.35', $5 = '46542.75', $6 = '1746', $7 = '515840248000726300', $8 = '0', $9 = '2026-03-14 07:41:01.168', $10 = '2026-03-14 07:41:01.074', $11 = '46513.35', $12 = '46544.75', $13 = '46511.35', $14 = '46542.75', $15 = '1746', $16 = '0', $17 = '2026-03-14 07:41:01.168', $18 = '2026-03-14 07:41:01.074'
-
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-14 07:40:42 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 21:00:00', $2 = '8570.4', $3 = '8571.7', $4 = '8542.25', $5 = '8542.75', $6 = '5165', $7 = '515840248015340300', $8 = '0', $9 = '2026-03-14 07:40:42.982', $10 = '2026-03-14 07:40:42.913', $11 = '8570.4', $12 = '8571.7', $13 = '8542.25', $14 = '8542.75', $15 = '5165', $16 = '0', $17 = '2026-03-14 07:40:42.982', $18 = '2026-03-14 07:40:42.913'
8 146ms 15 0ms 36ms 9ms with wh_patitioned as ( ;Times Reported Time consuming bind #8
Day Hour Count Duration Avg duration 07 15 146ms 9ms -
with wh_patitioned as ( ;
Date: 2026-03-14 07:03:48 Duration: 36ms 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-14 07:15:27 Duration: 32ms 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-14 07:10:02 Duration: 24ms Database: postgres parameters: $1 = '558', $2 = '558', $3 = '558', $4 = '558', $5 = '558', $6 = '558', $7 = '558', $8 = '558', $9 = '558'
9 142ms 2,881 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 #9
Day Hour Count Duration Avg duration 07 2,881 142ms 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-14 07:02:56 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 22:15:00', $2 = '24356.5', $3 = '24362.8', $4 = '24349.5', $5 = '24355', $6 = '1974', $7 = '515840248038958300', $8 = '0', $9 = '2026-03-14 07:02:56.28', $10 = '2026-03-14 07:02:56.213', $11 = '24356.5', $12 = '24362.8', $13 = '24349.5', $14 = '24355', $15 = '1974', $16 = '0', $17 = '2026-03-14 07:02:56.28', $18 = '2026-03-14 07:02:56.213'
-
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-14 07:35:21 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 22:45:00', $2 = '0.96046', $3 = '0.96052', $4 = '0.959665', $5 = '0.959725', $6 = '1283', $7 = '515840230419121300', $8 = '0', $9 = '2026-03-14 07:35:21.414', $10 = '2026-03-14 07:35:21.339', $11 = '0.96046', $12 = '0.96052', $13 = '0.959665', $14 = '0.959725', $15 = '1283', $16 = '0', $17 = '2026-03-14 07:35:21.414', $18 = '2026-03-14 07:35:21.339'
-
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-14 07:33:46 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 23:30:00', $2 = '53195.5', $3 = '53235.5', $4 = '53182.5', $5 = '53215.5', $6 = '355', $7 = '515840245921261300', $8 = '0', $9 = '2026-03-14 07:33:46.27', $10 = '2026-03-14 07:33:46.183', $11 = '53195.5', $12 = '53235.5', $13 = '53182.5', $14 = '53215.5', $15 = '355', $16 = '0', $17 = '2026-03-14 07:33:46.27', $18 = '2026-03-14 07:33:46.183'
10 88ms 3,258 0ms 5ms 0ms select 1;Times Reported Time consuming bind #10
Day Hour Count Duration Avg duration 07 3,258 88ms 0ms -
select 1;
Date: 2026-03-14 07:06:01 Duration: 5ms Database: postgres
-
select 1;
Date: 2026-03-14 07:38:37 Duration: 4ms Database: postgres
-
select 1;
Date: 2026-03-14 07:08:11 Duration: 1ms Database: postgres
11 59ms 33 0ms 11ms 1ms WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;Times Reported Time consuming bind #11
Day Hour Count Duration Avg duration 07 33 59ms 1ms -
WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;
Date: 2026-03-14 07:51:03 Duration: 11ms Database: postgres parameters: $1 = '689', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'
-
WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;
Date: 2026-03-14 07:06:27 Duration: 11ms 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-14 07:21:48 Duration: 11ms Database: postgres parameters: $1 = '689', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'
12 47ms 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 bind #12
Day Hour Count Duration Avg duration 07 288 47ms 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-14 07:32:26 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 00:00:00', $2 = '112.774', $3 = '112.892', $4 = '111.4955', $5 = '111.5065', $6 = '210828', $7 = '515840249384461300', $8 = '0', $9 = '2026-03-14 07:32:26.882', $10 = '2026-03-14 07:32:26.881', $11 = '112.774', $12 = '112.892', $13 = '111.4955', $14 = '111.5065', $15 = '210828', $16 = '0', $17 = '2026-03-14 07:32:26.882', $18 = '2026-03-14 07:32:26.881'
-
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-14 07:30:58 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 00:00:00', $2 = '5080.51', $3 = '5128.715', $4 = '5009.765', $5 = '5019.18', $6 = '525582', $7 = '515840249391588300', $8 = '0', $9 = '2026-03-14 07:30:58.071', $10 = '2026-03-14 07:30:58.07', $11 = '5080.51', $12 = '5128.715', $13 = '5009.765', $14 = '5019.18', $15 = '525582', $16 = '0', $17 = '2026-03-14 07:30:58.071', $18 = '2026-03-14 07:30:58.07'
-
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-14 07:46:50 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 00:00:00', $2 = '46744.65', $3 = '47123.25', $4 = '46421.75', $5 = '46474.7', $6 = '238469', $7 = '515840249388574300', $8 = '0', $9 = '2026-03-14 07:46:50.666', $10 = '2026-03-14 07:46:50.665', $11 = '46744.65', $12 = '47123.25', $13 = '46421.75', $14 = '46474.7', $15 = '238469', $16 = '0', $17 = '2026-03-14 07:46:50.666', $18 = '2026-03-14 07:46:50.665'
13 43ms 350 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 #13
Day Hour Count Duration Avg duration 07 350 43ms 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-14 07:16:50 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 20:00:00', $2 = '46630.75', $3 = '46743.25', $4 = '46474.7', $5 = '46474.7', $6 = '50664', $7 = '515840249388410300', $8 = '0', $9 = '2026-03-14 07:16:50.751', $10 = '2026-03-14 07:16:50.701', $11 = '46630.75', $12 = '46743.25', $13 = '46474.7', $14 = '46474.7', $15 = '50664', $16 = '0', $17 = '2026-03-14 07:16:50.751', $18 = '2026-03-14 07:16:50.701'
-
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-14 07:02:29 Duration: 0ms Database: postgres parameters: $1 = '2026-03-14 04:00:00', $2 = '73414', $3 = '73957.5', $4 = '73131', $5 = '73739.5', $6 = '4411', $7 = '515840249400231300', $8 = '0', $9 = '2026-03-14 07:02:29.563', $10 = '2026-03-14 07:02:29.563', $11 = '73414', $12 = '73957.5', $13 = '73131', $14 = '73739.5', $15 = '4411', $16 = '0', $17 = '2026-03-14 07:02:29.563', $18 = '2026-03-14 07:02:29.563'
-
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-14 07:02:35 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 20:00:00', $2 = '1215361.365', $3 = '1220662.695', $4 = '1197610.785', $5 = '1208363.04', $6 = '49905', $7 = '515840249474385300', $8 = '0', $9 = '2026-03-14 07:02:35.155', $10 = '2026-03-14 07:02:35.135', $11 = '1215361.365', $12 = '1220662.695', $13 = '1197610.785', $14 = '1208363.04', $15 = '49905', $16 = '0', $17 = '2026-03-14 07:02:35.155', $18 = '2026-03-14 07:02:35.135'
14 38ms 1 38ms 38ms 38ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 632 LIMIT $1;Times Reported Time consuming bind #14
Day Hour Count Duration Avg duration 07 1 38ms 38ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 632 LIMIT $1;
Date: 2026-03-14 07:01:22 Duration: 38ms Database: postgres parameters: $1 = '50'
15 37ms 1 37ms 37ms 37ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 1436 LIMIT $1;Times Reported Time consuming bind #15
Day Hour Count Duration Avg duration 07 1 37ms 37ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 1436 LIMIT $1;
Date: 2026-03-14 07:32:38 Duration: 37ms Database: postgres parameters: $1 = '50'
16 36ms 1 36ms 36ms 36ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 636 LIMIT $1;Times Reported Time consuming bind #16
Day Hour Count Duration Avg duration 07 1 36ms 36ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 636 LIMIT $1;
Date: 2026-03-14 07:11:21 Duration: 36ms Database: postgres parameters: $1 = '50'
17 36ms 1 36ms 36ms 36ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 1471 LIMIT $1;Times Reported Time consuming bind #17
Day Hour Count Duration Avg duration 07 1 36ms 36ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 1471 LIMIT $1;
Date: 2026-03-14 07:33:17 Duration: 36ms Database: postgres parameters: $1 = '50'
18 36ms 1 36ms 36ms 36ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 1505 LIMIT $1;Times Reported Time consuming bind #18
Day Hour Count Duration Avg duration 07 1 36ms 36ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 1505 LIMIT $1;
Date: 2026-03-14 07:33:43 Duration: 36ms Database: postgres parameters: $1 = '50'
19 36ms 1 36ms 36ms 36ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 1508 LIMIT $1;Times Reported Time consuming bind #19
Day Hour Count Duration Avg duration 07 1 36ms 36ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 1508 LIMIT $1;
Date: 2026-03-14 07:33:55 Duration: 36ms Database: postgres parameters: $1 = '50'
20 35ms 1 35ms 35ms 35ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 1504 LIMIT $1;Times Reported Time consuming bind #20
Day Hour Count Duration Avg duration 07 1 35ms 35ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 1504 LIMIT $1;
Date: 2026-03-14 07:33:38 Duration: 35ms Database: postgres parameters: $1 = '50'
-
Events
Log levels
Key values
- 137,255 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 389 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 237 Max number of times the same event was reported
- 389 Total events found
Rank Times reported Error 1 237 ERROR: canceling statement due to statement timeout
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 14 07 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-14 07:00:12
2 76 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 14 07 76 - ERROR: syntax error at or near "group" at character 55
- ERROR: syntax error at or near "group" at character 61
Statement: SELECT * FROM broker_stats_timezone_offset_view WHERE group" = 'Commodities' LIMIT $1
Date: 2026-03-14 07:01:23
Statement: SELECT * FROM broker_stats_timezone_offset_count_view WHERE group" = 'Commodities' LIMIT $1
Date: 2026-03-14 07:01:23
3 76 ERROR: function broker_stats_get_symbols_function(...) does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 14 07 76 - ERROR: function broker_stats_get_symbols_function(bigint, integer) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM broker_stats_get_symbols_function(601729875343618307,538) WHERE lower(category) = 'symbol' ORDER BY correct DESC LIMIT $1Date: 2026-03-14 07:01:23