pgBadger-
Global information
- Generated on Sun Mar 29 09:59:20 2026
- Log file: /home/postgres/pg_data/data/pg_log/postgresql-2026-03-29_110000.log
- Parsed 535,732 log entries in 18s
- Log start from 2026-03-29 11:00:00 to 2026-03-29 11:59:16
-
Overview
Global Stats
- 197 Number of unique normalized queries
- 80,863 Number of queries
- 1h26m23s Total query duration
- 2026-03-29 11:00:00 First query
- 2026-03-29 11:59:16 Last query
- 1,692 queries/s at 2026-03-29 11:45:04 Query peak
- 1h26m23s Total query duration
- 3s67ms Prepare/parse total duration
- 19s521ms Bind total duration
- 1h26m 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
- 31 Total number of automatic vacuums
- 46 Total number of automatic analyzes
- 1,509 Number temporary file
- 597.97 MiB Max size of temporary file
- 83.15 MiB Average size of temporary file
- 1,813 Total number of sessions
- 12 sessions at 2026-03-29 11:54:08 Session peak
- 18h4m9s Total duration of sessions
- 35s879ms Average duration of sessions
- 44 Average queries per session
- 2s859ms Average queries duration per session
- 33s20ms Average idle time per session
- 1,816 Total number of connections
- 27 connections/s at 2026-03-29 11:18:48 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 1,692 queries/s Query Peak
- 2026-03-29 11:45:04 Date
SELECT Traffic
Key values
- 828 queries/s Query Peak
- 2026-03-29 11:45:04 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 81 queries/s Query Peak
- 2026-03-29 11:18:48 Date
Queries duration
Key values
- 1h26m23s 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 29 11 80,863 0ms 22s203ms 63ms 3m56s 4m14s 4m56s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 29 11 22,277 26 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 29 11 11,804 501 16 96 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Mar 29 11 9,743 22,614 2.32 25.69% Day Hour Count Average / Second Mar 29 11 1,816 0.50/s Day Hour Count Average Duration Average idle time Mar 29 11 1,813 35s879ms 33s32ms -
Connections
Established Connections
Key values
- 27 connections Connection Peak
- 2026-03-29 11:18:48 Date
Connections per database
Key values
- acaweb_fx Main Database
- 1,816 connections Total
Connections per user
Key values
- postgres Main User
- 1,816 connections Total
Connections per host
Key values
- 192.168.4.142 Main host with 799 connections
- 1,816 Total connections
-
Sessions
Simultaneous sessions
Key values
- 12 sessions Session Peak
- 2026-03-29 11:54:08 Date
Histogram of session times
Key values
- 1,462 0-500ms duration
Sessions per database
Key values
- acaweb_fx Main Database
- 1,813 sessions Total
Sessions per user
Key values
- postgres Main User
- 1,813 sessions Total
Sessions per host
Key values
- 192.168.4.142 Main Host
- 1,813 sessions Total
Host Count Total Duration Average Duration 127.0.0.1 106 5s302ms 50ms 192.168.0.114 5 41m10s 8m14s 192.168.0.216 116 7m47s 4s27ms 192.168.1.145 2 33m33s 16m46s 192.168.1.15 18 4h11m27s 13m58s 192.168.1.20 22 12h17m18s 33m30s 192.168.1.239 54 317ms 5ms 192.168.1.90 6 54ms 9ms 192.168.2.126 18 5s820ms 323ms 192.168.3.199 39 32s804ms 841ms 192.168.4.142 799 7m18s 548ms 192.168.4.33 61 24s634ms 403ms 192.168.4.98 330 15s14ms 45ms [local] 237 4m10s 1s56ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 2,360 buffers Checkpoint Peak
- 2026-03-29 11:06:25 Date
- 206.920 seconds Highest write time
- 0.783 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2026-03-29 11:13:53 Date
Checkpoints distance
Key values
- 43.73 Mo Distance Peak
- 2026-03-29 11:06:25 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Mar 29 11 14,848 1,480.965s 1.667s 1,533.659s Day Hour Added Removed Recycled Synced files Longest sync Average sync Mar 29 11 0 0 10 1,377 0.502s 0.021s Day Hour Count Avg time (sec) Mar 29 11 0 0s Day Hour Mean distance Mean estimate Mar 29 11 14,286.33 kB 19,229.50 kB -
Temporary Files
Size of temporary files
Key values
- 597.97 MiB Temp Files size Peak
- 2026-03-29 11:17:16 Date
Number of temporary files
Key values
- 30 per second Temp Files Peak
- 2026-03-29 11:17:09 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Mar 29 11 1,509 122.54 GiB 83.15 MiB Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 236 119.07 GiB 275.54 MiB 597.97 MiB 516.62 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-29 11:00:13 Duration: 0ms
2 120 202.24 MiB 137.65 KiB 3.81 MiB 1.69 MiB with rar_max as ( select resultuid from relevance_autochartist_results order by resultuid desc limit ? ), ar as ( select a.*, rr.age, rr.relevant from autochartist_results a left outer join relevance_autochartist_results rr on a.resultuid = rr.resultuid where case when false = ? then true else a.resultuid > ( select min(resultuid) from relevance_autochartist_results) end ), all_results as ( select ar.resultuid as resultuid, ar.direction as direction, ar.predictiontimeto as predictiontimeto, ar.predictionpricefrom as predictionpricefrom, ar.predictionpriceto as predictionpriceto, cp.pip as pip, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, ar.pattern as pattern_name, ar.breakout as breakout, ar.patternendtime as identified, dtt.timezone as timezone, ar.patternlengthbars as length, g.basegroupname, newlevels.profit, newlevels.stop, newlevels.filtered, case when ar.age is not null then ar.age when ar.resultuid <= rm.resultuid then ? else ? end as age, case when ar.relevant is not null then ar.relevant when ar.resultuid <= rm.resultuid then ? else ? end as relevant from ar inner join symbols s on ar.symbolid = s.symbolid and s.nonliquid = ? inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = s.symbolid inner join symbolgroup sg on bsl.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join downloadersymbolsettings dss on sg.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join rar_max rm on ? = ? left outer join autochartist_symbolupdates au on dss.symbolid = au.symbolid left outer join currencypips cp on s.symbol = cp.symbol left join lateral calc_cp_signal (ar.resultuid) newlevels on true left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where ar.gmttimefound > now() - interval ? and dss.enabled = ? and s.deleted = ? and (ar.simulation = ? or ar.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ar.pattern in (...)) and (? = ? or (? = ? and ar.breakout >= ?) or (? = ? and ar.breakout < ?)) and (? = ? or ar.patternlengthbars <= ?) and newlevels.filtered = false and ar.patternstarttime >= coalesce(au.earliestpricedatetime, ?::timestamp without time zone) -- to make sure patternstarttime is in our t-tables ), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc ;-
WITH rar_max as ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1 ), ar AS ( SELECT a.*, rr.age, rr.relevant from autochartist_results a LEFT OUTER JOIN relevance_autochartist_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_autochartist_results) END ), all_results AS ( SELECT ar.resultuid AS resultuid, ar.direction AS direction, ar.predictiontimeto AS predictiontimeto, ar.predictionpricefrom AS predictionpricefrom, ar.predictionpriceto AS predictionpriceto, cp.pip AS pip, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, ar.pattern AS pattern_name, ar.breakout AS breakout, ar.patternendtime AS identified, dtt.timezone AS timezone, ar.patternlengthbars AS length, g.basegroupname, newLevels.profit, newLevels.stop, newLevels.filtered, CASE WHEN ar.age IS NOT NULL THEN ar.age WHEN ar.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN ar.relevant IS NOT NULL THEN ar.relevant WHEN ar.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM ar INNER JOIN symbols s ON ar.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = s.symbolid INNER JOIN symbolgroup sg on bsl.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON sg.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN currencypips cp ON s.symbol = cp.symbol LEFT JOIN LATERAL calc_cp_signal (ar.resultuid) newLevels on true LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE ar.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (ar.simulation = 0 OR ar.simulation IS NULL) AND ($3 = 0 OR s.timegranularity in ($4, $5, $6, $7, $8, $9, $10)) AND ($11 = 0 OR s.exchange in ($12)) AND ($13 = 0 OR coalesce(bim.code, s.symbol) in ($14, $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, $323)) AND ($324 = 0 OR ar.pattern in ($325)) AND ($326 = 0 OR ($327 = 1 AND ar.breakout >= 0) OR ($328 = 2 AND ar.breakout < 0)) AND ($329 = 0 OR ar.patternlengthbars <= $330) 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 = $331 OR relevant = 1) AND ($332 = 0 OR age <= $333) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;
Date: 2026-03-29 11:00:35 Duration: 0ms
3 36 171.54 MiB 4.72 MiB 4.85 MiB 4.77 MiB select resultuid from relevance_fibonacci_results order by resultuid desc limit ?), fr as ( select a.*, rr.age, rr.relevant from fibonacci_results a left outer join relevance_fibonacci_results rr on a.resultuid = rr.resultuid where case when false = ? then true else a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) end), all_results as ( select fr.resultuid as resultuid, fr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, fr.pattern as pattern_name, fr.timed as timed, fr.patternendtime as identified, dtt.timezone as timezone, fr.patternlengthbars as length, g.basegroupname, newlevels.filtered, case when fr.age is not null then fr.age when fr.resultuid <= rm.resultuid then ? else ? end as age, case when fr.relevant is not null then fr.relevant when fr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from fr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = fr.symbolid inner join symbols s on fr.symbolid = s.symbolid and s.nonliquid = ? inner join symbolgroup sg on fr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join downloadersymbolsettings dss on fr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join rar_max rm on ? = ? left join lateral calc_fib_signal_filter (fr.resultuid) newlevels on true left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where fr.gmttimefound > now() - interval ? and dss.enabled = ? and s.deleted = ? and (fr.simulation = ? or fr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or fr.pattern in (...)) and (? = ? or fr.patternlengthbars <= ?) and (? = ? or (? = ? and fr.timed > cast(? as timestamp)) or (? = ? and fr.timed < cast(? as timestamp)))), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc;-
SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), fr AS ( SELECT a.*, rr.age, rr.relevant from fibonacci_results a LEFT OUTER JOIN relevance_fibonacci_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) END), all_results AS ( SELECT fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN fr.age IS NOT NULL THEN fr.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN fr.relevant IS NOT NULL THEN fr.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT JOIN LATERAL calc_fib_signal_filter (fr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($3 = 0 OR s.timegranularity in ($4, $5, $6, $7, $8, $9, $10)) AND ($11 = 0 OR s.exchange in ($12)) AND ($13 = 0 OR coalesce(bim.code, s.symbol) in ($14, $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, $323)) AND ($324 = 0 OR fr.pattern in ($325)) AND ($326 = 0 OR fr.patternlengthbars <= $327) AND ($328 = 0 OR ($329 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($330 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $331 OR relevant = 1) AND ($332 = 0 OR age <= $333) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;
Date: 2026-03-29 11:00:48 Duration: 0ms
4 16 48.92 MiB 3.06 MiB 3.06 MiB 3.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-29 11:25:28 Duration: 0ms
5 16 624.25 MiB 39.02 MiB 39.02 MiB 39.02 MiB update solr_relevance_old set new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total from ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total from whatshot_probability where type = ?) sub where result_uid = sub.resultuid;-
UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type = 'cp') sub WHERE result_uid = sub.resultuid;
Date: 2026-03-29 11:01:16 Duration: 0ms
6 16 1.23 GiB 78.70 MiB 78.70 MiB 78.70 MiB with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit ?) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then ? else ? end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then ? else ? end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike ? inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike ?) sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike ?; update solr_relevance_old set newrelevant = ? where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike ? and a.resultuid is null); update solr_relevance_old set new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total from ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total from whatshot_probability where type in (...)) sub where result_uid = sub.resultuid;-
with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;
Date: 2026-03-29 11:01:19 Duration: 0ms
7 12 36.28 MiB 3.02 MiB 3.02 MiB 3.02 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-29 11:01:09 Duration: 0ms
8 4 594.83 MiB 148.71 MiB 148.71 MiB 148.71 MiB select updateresultsmaterializedview ();-
select updateresultsmaterializedview ();
Date: 2026-03-29 11:02:15 Duration: 0ms
9 4 313.19 MiB 78.29 MiB 78.31 MiB 78.30 MiB select updateageforrelevantresults ();-
select updateageforrelevantresults ();
Date: 2026-03-29 11:02:05 Duration: 0ms
Queries generating the largest temporary files
Rank Size Query 1 597.97 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-29 11:17:16 ]
2 591.97 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-29 11:03:14 ]
3 591.97 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-29 11:04:43 ]
4 585.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-29 11:37:44 ]
5 582.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-29 11:14:58 ]
6 582.98 MiB classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname;[ Date: 2026-03-29 11:54:28 ]
7 579.99 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-29 11:09:43 ]
8 579.99 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-29 11:19:43 ]
9 577.00 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-29 11:45:28 ]
10 574.01 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-29 11:44:58 ]
11 571.01 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-29 11:07:30 ]
12 571.01 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-29 11:33:13 ]
13 565.02 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-29 11:04:14 ]
14 565.02 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-29 11:09:13 ]
15 565.02 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-29 11:19:58 ]
16 565.02 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-29 11:39:43 ]
17 565.02 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-29 11:51:29 ]
18 562.02 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-29 11:02:14 ]
19 562.02 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-29 11:14:45 ]
20 562.02 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-29 11:17:43 ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Analyzes per table
Key values
- public.solr_relevance_old (16) Main table analyzed (database acaweb_fx)
- 46 analyzes Total
Table Number of analyzes acaweb_fx.public.solr_relevance_old 16 acaweb_fx.pg_catalog.pg_attribute 8 acaweb_fx.pg_catalog.pg_type 4 acaweb_fx.pg_catalog.pg_class 4 acaweb_fx.public.datafeeds_latestrun 3 acaweb_fx.pg_catalog.pg_depend 2 acaweb_fx.public.latest_t15_candle_view 2 acaweb_fx.pg_catalog.pg_index 1 acaweb_fx.public.autochartist_symbolupdates 1 acaweb_fx.public.solr_imports 1 acaweb_fx.public.relevance_keylevels_results 1 acaweb_fx.public.latest_candle_datetime_per_receng 1 acaweb_fx.public.relevance_autochartist_results 1 acaweb_fx.public.relevance_fibonacci_results 1 Total 46 Vacuums per table
Key values
- public.solr_relevance_old (16) Main table vacuumed on database acaweb_fx
- 31 vacuums Total
Index Buffer usage Skipped WAL usage Table Vacuums scans hits misses dirtied pins frozen records full page bytes acaweb_fx.public.solr_relevance_old 16 16 11,539 0 48 0 0 7,801 16 1,358,889 acaweb_fx.public.datafeeds_latestrun 3 0 350 0 8 0 0 37 7 38,263 acaweb_fx.pg_catalog.pg_attribute 3 3 2,838 0 372 0 201 1,089 366 2,103,333 acaweb_fx.pg_catalog.pg_type 2 2 364 0 41 0 0 152 38 196,026 acaweb_fx.pg_catalog.pg_class 2 2 899 0 94 0 0 274 124 607,707 acaweb_fx.pg_toast.pg_toast_2619 1 1 166 0 37 0 0 116 42 160,457 acaweb_fx.pg_catalog.pg_index 1 1 106 0 11 0 0 27 15 93,108 acaweb_fx.pg_catalog.pg_statistic 1 1 965 0 145 0 594 375 119 472,103 acaweb_fx.public.latest_t15_candle_view 1 1 93 0 1 0 0 6 1 9,049 acaweb_fx.public.relevance_keylevels_results 1 1 3,475 0 290 0 118 576 344 1,525,758 Total 31 28 20,795 5,589 1,047 0 913 10,453 1,072 6,564,693 Tuples removed per table
Key values
- public.solr_relevance_old (39227) Main table with removed tuples on database acaweb_fx
- 47121 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain acaweb_fx.public.solr_relevance_old 16 16 39,227 82,915 0 0 2,789 acaweb_fx.pg_catalog.pg_attribute 3 3 5,212 32,252 0 21 782 acaweb_fx.pg_catalog.pg_type 2 2 754 2,910 0 0 88 acaweb_fx.public.relevance_keylevels_results 1 1 720 11,877 0 0 279 acaweb_fx.pg_catalog.pg_statistic 1 1 671 3,793 0 0 1,194 acaweb_fx.pg_catalog.pg_class 2 2 228 3,312 0 0 300 acaweb_fx.public.datafeeds_latestrun 3 0 167 42 0 0 48 acaweb_fx.pg_toast.pg_toast_2619 1 1 81 167 0 0 51 acaweb_fx.public.latest_t15_candle_view 1 1 58 12 0 0 1 acaweb_fx.pg_catalog.pg_index 1 1 3 815 0 0 22 Total 31 28 47,121 138,095 0 21 5,554 Pages removed per table
Key values
- pg_catalog.pg_attribute (21) Main table with removed pages on database acaweb_fx
- 21 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed acaweb_fx.pg_catalog.pg_attribute 3 3 5212 21 acaweb_fx.pg_toast.pg_toast_2619 1 1 81 0 acaweb_fx.pg_catalog.pg_index 1 1 3 0 acaweb_fx.pg_catalog.pg_type 2 2 754 0 acaweb_fx.public.datafeeds_latestrun 3 0 167 0 acaweb_fx.pg_catalog.pg_statistic 1 1 671 0 acaweb_fx.public.latest_t15_candle_view 1 1 58 0 acaweb_fx.public.relevance_keylevels_results 1 1 720 0 acaweb_fx.public.solr_relevance_old 16 16 39227 0 acaweb_fx.pg_catalog.pg_class 2 2 228 0 Total 31 28 47,121 21 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Mar 29 11 31 46 - 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
- 22,277 Total read queries
- 15,642 Total write queries
Queries by database
Key values
- unknown Main database
- 79,915 Requests
- 1h26m (unknown)
- Main time consuming database
Database Request type Count Duration acaweb_fx Total 887 0ms copy from 80 0ms copy to 26 0ms cte 100 0ms ddl 16 0ms delete 16 0ms others 213 0ms select 65 0ms tcl 335 0ms update 36 0ms socialmedia Total 61 0ms select 61 0ms unknown Total 79,915 1h26m copy from 16 0ms cte 1,891 0ms insert 11,804 0ms others 2,418 0ms select 22,151 0ms tcl 857 0ms update 465 0ms Queries by user
Key values
- unknown Main user
- 79,915 Requests
User Request type Count Duration postgres Total 948 0ms copy from 80 0ms copy to 26 0ms cte 100 0ms ddl 16 0ms delete 16 0ms others 213 0ms select 126 0ms tcl 335 0ms update 36 0ms unknown Total 79,915 1h26m copy from 16 0ms cte 1,891 0ms insert 11,804 0ms others 2,418 0ms select 22,151 0ms tcl 857 0ms update 465 0ms Duration by user
Key values
- 1h26m (unknown) Main time consuming user
User Request type Count Duration postgres Total 948 0ms copy from 80 0ms copy to 26 0ms cte 100 0ms ddl 16 0ms delete 16 0ms others 213 0ms select 126 0ms tcl 335 0ms update 36 0ms unknown Total 79,915 1h26m copy from 16 0ms cte 1,891 0ms insert 11,804 0ms others 2,418 0ms select 22,151 0ms tcl 857 0ms update 465 0ms Queries by host
Key values
- unknown Main host
- 80,863 Requests
- 1h26m (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 80,520 Requests
- 1h26m (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 1 per second Cancelled query Peak
- 2026-03-29 11:44:28 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 27,595 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 29 11 2 0ms 0ms 2 0ms 130 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 29 11 130 0ms 0ms 3 0ms 2 0ms 0ms 0ms select trumpetsymbolid as sid, trumpettimegranularity as tg from brokersymbollist bsl left join powerstats_symboldata psd on bsl.symbolid = psd.symbolid left join downloadersymbolsettings dss on psd.symbolid = dss.symbolid left join symbols s on dss.symbolid = s.symbolid left outer join brokerinstrumentmap bdfi on code = ? and bdfi.brokerid = ? and dss.datafeedinstrumentid = bdfi.datafeedinstrumentid where (code = ? or s.symbol = ?) and bsl.brokerid = ? and dss.classname <> ? group by trumpetsymbolid, trumpettimegranularity;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 29 11 2 0ms 0ms 4 0ms 2,427 0ms 0ms 0ms insert into t60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 29 11 2,427 0ms 0ms 5 0ms 25 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 #5
Day Hour Count Duration Avg duration Mar 29 11 25 0ms 0ms 6 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 #6
Day Hour Count Duration Avg duration Mar 29 11 237 0ms 0ms 7 0ms 85 0ms 0ms 0ms update patternresultsrelevance set relevant = ?, saxo_relevant = ?, notrelevantpricedatetime = ?, reason = ? where uniqueindex = ? and relevant = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 29 11 85 0ms 0ms 8 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 #8
Day Hour Count Duration Avg duration Mar 29 11 18 0ms 0ms 9 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 #9
Day Hour Count Duration Avg duration Mar 29 11 237 0ms 0ms 10 0ms 5 0ms 0ms 0ms select distinct s.statsid as statsid, sy.exchange as name from stats s inner join broker b on s.brokerid = b.brokerid inner join brokerconfig bc on b.brokerid = bc.brokerid inner join stats_symbols ss on s.statsid = ss.statsid inner join downloadersymbolsettings dss on ss.symbolid = dss.symbolid inner join symbols sy on dss.symbolid = sy.symbolid where dss.enabled = ? and s.brokerid is not null and b.brokerid = ? and s.groupingtype ilike ? and s.description ilike ? || b.name || ? and s.description ilike ? || sy.exchange || ? and s.description not ilike ? || ? || ? union all select distinct s.statsid as statsid, basegroupname as name from stats s inner join broker b on s.brokerid = b.brokerid inner join brokerconfig bc on b.brokerid = bc.brokerid inner join stats_symbols ss on s.statsid = ss.statsid inner join downloadersymbolsettings dss on ss.symbolid = dss.symbolid inner join symbolgroup sg on dss.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bg.brokerid = b.brokerid where dss.enabled = ? and s.brokerid is not null and b.brokerid = ? and s.groupingtype not ilike ? and s.description ilike ? || b.name || ? and s.description ilike ? || g.basegroupname || ? and s.description not ilike ? || ? || ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 29 11 5 0ms 0ms 11 0ms 22 0ms 0ms 0ms select category, name, sum(total) as total, sum(correct) as correct, (cast(sum(correct) as float) / cast(sum(total) as float)) * ?.? as percentage, min("from") AS "from", max("to") AS "to" from ( select category, name, total, correct, percentage, "from", "to" from stats_summary where statsid = ? and category = lower(?) and name in (...) union select category, name, total, correct, percentage, "from", "to" from stats_hrs_summary where statsid = ? and category = lower(?) and name in (...) order by correct desc) as summdata group by category, name having sum(total) > ? order by name;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 29 11 22 0ms 0ms 12 0ms 13 0ms 0ms 0ms select * from ( select pricedatetime, open, high, low, close, volume, bsf from t60 where symbolid = ? and (bsf = ? or bsf is null) order by pricedatetime desc limit ?) a order by pricedatetime asc;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 29 11 13 0ms 0ms 13 0ms 444 0ms 0ms 0ms commit;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 29 11 444 0ms 0ms 14 0ms 200 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 #14
Day Hour Count Duration Avg duration Mar 29 11 200 0ms 0ms 15 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 #15
Day Hour Count Duration Avg duration Mar 29 11 2 0ms 0ms 16 0ms 2 0ms 0ms 0ms select (cast(substring(tz.gmoffset from ? for ?) as float) * ? + cast(substring(tz.gmoffset from ? for ?) as float)) / ? as offset from timezones tz where tz.timezone = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 29 11 2 0ms 0ms 17 0ms 237 0ms 0ms 0ms select count(*), sum(size), extract(epoch from now() - min(modification)) from pg_ls_waldir ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 29 11 237 0ms 0ms 18 0ms 13 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 #18
Day Hour Count Duration Avg duration Mar 29 11 13 0ms 0ms 19 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 #19
Day Hour Count Duration Avg duration Mar 29 11 6 0ms 0ms 20 0ms 2 0ms 0ms 0ms update executions set isrunning = false, has_results = false, response = ? where id = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 29 11 2 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 4,637 0ms 0ms 0ms 0ms select ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 29 11 4,637 0ms 0ms 2 2,900 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 29 11 2,900 0ms 0ms 3 2,442 0ms 0ms 0ms 0ms insert into t30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 29 11 2,442 0ms 0ms 4 2,427 0ms 0ms 0ms 0ms insert into t60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 29 11 2,427 0ms 0ms 5 2,423 0ms 0ms 0ms 0ms insert into executionlogs (executionid, status, message, details, detailtype) values (null, ?, ?, null, null);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 29 11 2,423 0ms 0ms 6 2,396 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 29 11 2,396 0ms 0ms 7 2,294 0ms 0ms 0ms 0ms select s.symbolid as id, s.symbol as name, s.exchange as exchange, s.timegranularity as interval, dtt.timezone as timezone from symbols s inner join downloadersymbolsettings dss on dss.symbolid = s.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where bsl.brokerid = ? and (? = ? or s.timegranularity = ?) and (s.symbol = ? or dss.downloadersymbol = ?) and dss.enabled = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 29 11 2,294 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 29 11 966 0ms 0ms 9 856 0ms 0ms 0ms 0ms set extra_float_digits = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 29 11 856 0ms 0ms 10 844 0ms 0ms 0ms 0ms set application_name = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 29 11 844 0ms 0ms 11 633 0ms 0ms 0ms 0ms insert into autochartist_results (resultid, symbolid, bandwidth, pattern, qtytp, gmttimefound, direction, initialtrend, breakout, volumeincrease, noise, symmetry, predictionpricefrom, predictionpriceto, predictiontimefrom, predictiontimeto, patternstarttime, patternendtime, patternstartprice, patternendprice, resx0, resx1, supportx0, supportx1, resy0, resy1, supporty0, supporty1, supportgradient, resgradient, riskreward, patternquality, trendchange, maxmovementafterbreakout, latestbaratbreakouttime, latestbaratbreakoutprice, patternlengthbars, temporarypattern, relevancestartdistance, simulation, writtendatetime) values (?, ?, ?.?, ?, ?, ?::timestamp without time zone, ?, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?::timestamp without time zone, ?::timestamp without time zone, ?::timestamp without time zone, ?::timestamp without time zone, ?.?, ?.?, ?::timestamp without time zone, ?::timestamp without time zone, ?::timestamp without time zone, ?::timestamp without time zone, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?, ?.?, ?::timestamp without time zone, ?.?, ?, ?, ?.?, ?, current_timestamp::timestamp without time zone) on conflict do nothing;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 29 11 633 0ms 0ms 12 596 0ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 29 11 596 0ms 0ms 13 586 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 #13
Day Hour Count Duration Avg duration Mar 29 11 586 0ms 0ms 14 475 0ms 0ms 0ms 0ms set statement_timeout = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 29 11 475 0ms 0ms 15 444 0ms 0ms 0ms 0ms commit;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 29 11 444 0ms 0ms 16 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 #16
Day Hour Count Duration Avg duration Mar 29 11 350 0ms 0ms 17 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 #17
Day Hour Count Duration Avg duration Mar 29 11 332 0ms 0ms 18 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 #18
Day Hour Count Duration Avg duration Mar 29 11 288 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 29 11 266 0ms 0ms 20 242 0ms 0ms 0ms 0ms select category, name, sum(total) as total, sum(correct) as correct, (cast(sum(correct) as float) / cast(sum(total) as float)) * ?.? as percentage, min("from") AS "from", max("to") AS "to" from ( select category, name, total, correct, percentage, "from", "to" from stats_summary where statsid = ? and category = lower(?) union select category, name, total, correct, percentage, "from", "to" from stats_hrs_summary where statsid = ? and category = lower(?) order by correct desc) as summdata group by category, name having sum(total) > ? order by name;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 29 11 242 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 29 11 2 0ms 0ms 2 0ms 0ms 0ms 130 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 29 11 130 0ms 0ms 3 0ms 0ms 0ms 2 0ms select trumpetsymbolid as sid, trumpettimegranularity as tg from brokersymbollist bsl left join powerstats_symboldata psd on bsl.symbolid = psd.symbolid left join downloadersymbolsettings dss on psd.symbolid = dss.symbolid left join symbols s on dss.symbolid = s.symbolid left outer join brokerinstrumentmap bdfi on code = ? and bdfi.brokerid = ? and dss.datafeedinstrumentid = bdfi.datafeedinstrumentid where (code = ? or s.symbol = ?) and bsl.brokerid = ? and dss.classname <> ? group by trumpetsymbolid, trumpettimegranularity;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 29 11 2 0ms 0ms 4 0ms 0ms 0ms 2,427 0ms insert into t60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 29 11 2,427 0ms 0ms 5 0ms 0ms 0ms 25 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 #5
Day Hour Count Duration Avg duration Mar 29 11 25 0ms 0ms 6 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 #6
Day Hour Count Duration Avg duration Mar 29 11 237 0ms 0ms 7 0ms 0ms 0ms 85 0ms update patternresultsrelevance set relevant = ?, saxo_relevant = ?, notrelevantpricedatetime = ?, reason = ? where uniqueindex = ? and relevant = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 29 11 85 0ms 0ms 8 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 #8
Day Hour Count Duration Avg duration Mar 29 11 18 0ms 0ms 9 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 #9
Day Hour Count Duration Avg duration Mar 29 11 237 0ms 0ms 10 0ms 0ms 0ms 5 0ms select distinct s.statsid as statsid, sy.exchange as name from stats s inner join broker b on s.brokerid = b.brokerid inner join brokerconfig bc on b.brokerid = bc.brokerid inner join stats_symbols ss on s.statsid = ss.statsid inner join downloadersymbolsettings dss on ss.symbolid = dss.symbolid inner join symbols sy on dss.symbolid = sy.symbolid where dss.enabled = ? and s.brokerid is not null and b.brokerid = ? and s.groupingtype ilike ? and s.description ilike ? || b.name || ? and s.description ilike ? || sy.exchange || ? and s.description not ilike ? || ? || ? union all select distinct s.statsid as statsid, basegroupname as name from stats s inner join broker b on s.brokerid = b.brokerid inner join brokerconfig bc on b.brokerid = bc.brokerid inner join stats_symbols ss on s.statsid = ss.statsid inner join downloadersymbolsettings dss on ss.symbolid = dss.symbolid inner join symbolgroup sg on dss.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bg.brokerid = b.brokerid where dss.enabled = ? and s.brokerid is not null and b.brokerid = ? and s.groupingtype not ilike ? and s.description ilike ? || b.name || ? and s.description ilike ? || g.basegroupname || ? and s.description not ilike ? || ? || ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 29 11 5 0ms 0ms 11 0ms 0ms 0ms 22 0ms select category, name, sum(total) as total, sum(correct) as correct, (cast(sum(correct) as float) / cast(sum(total) as float)) * ?.? as percentage, min("from") AS "from", max("to") AS "to" from ( select category, name, total, correct, percentage, "from", "to" from stats_summary where statsid = ? and category = lower(?) and name in (...) union select category, name, total, correct, percentage, "from", "to" from stats_hrs_summary where statsid = ? and category = lower(?) and name in (...) order by correct desc) as summdata group by category, name having sum(total) > ? order by name;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 29 11 22 0ms 0ms 12 0ms 0ms 0ms 13 0ms select * from ( select pricedatetime, open, high, low, close, volume, bsf from t60 where symbolid = ? and (bsf = ? or bsf is null) order by pricedatetime desc limit ?) a order by pricedatetime asc;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 29 11 13 0ms 0ms 13 0ms 0ms 0ms 444 0ms commit;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 29 11 444 0ms 0ms 14 0ms 0ms 0ms 200 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 #14
Day Hour Count Duration Avg duration Mar 29 11 200 0ms 0ms 15 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 #15
Day Hour Count Duration Avg duration Mar 29 11 2 0ms 0ms 16 0ms 0ms 0ms 2 0ms select (cast(substring(tz.gmoffset from ? for ?) as float) * ? + cast(substring(tz.gmoffset from ? for ?) as float)) / ? as offset from timezones tz where tz.timezone = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 29 11 2 0ms 0ms 17 0ms 0ms 0ms 237 0ms select count(*), sum(size), extract(epoch from now() - min(modification)) from pg_ls_waldir ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 29 11 237 0ms 0ms 18 0ms 0ms 0ms 13 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 #18
Day Hour Count Duration Avg duration Mar 29 11 13 0ms 0ms 19 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 #19
Day Hour Count Duration Avg duration Mar 29 11 6 0ms 0ms 20 0ms 0ms 0ms 2 0ms update executions set isrunning = false, has_results = false, response = ? where id = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 29 11 2 0ms 0ms Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1s348ms 686 0ms 7ms 1ms SELECT symbolid, ;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Mar 29 11 686 1s348ms 1ms -
SELECT symbolid, ;
Date: 2026-03-29 11:35:53 Duration: 7ms Database: postgres
-
SELECT symbolid, ;
Date: 2026-03-29 11:32:24 Duration: 3ms Database: postgres
-
SELECT symbolid, ;
Date: 2026-03-29 11:31:28 Duration: 3ms Database: postgres
2 427ms 542 0ms 5ms 0ms WITH rar_max as ( ;Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 11 542 427ms 0ms -
WITH rar_max as ( ;
Date: 2026-03-29 11:30:39 Duration: 5ms Database: postgres
-
WITH rar_max as ( ;
Date: 2026-03-29 11:26:56 Duration: 3ms Database: postgres
-
WITH rar_max as ( ;
Date: 2026-03-29 11:35:41 Duration: 3ms Database: postgres
3 280ms 2,332 0ms 0ms 0ms INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming prepare #3
Day Hour Count Duration Avg duration 11 2,332 280ms 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-29 11:11:59 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-29 11:11:55 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-29 11:11:13 Duration: 0ms Database: postgres
4 233ms 2,413 0ms 0ms 0ms INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming prepare #4
Day Hour Count Duration Avg duration 11 2,413 233ms 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-29 11:32:14 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-29 11:41:02 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-29 11:11:15 Duration: 0ms Database: postgres
5 159ms 686 0ms 2ms 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 #5
Day Hour Count Duration Avg duration 11 686 159ms 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-29 11:46:22 Duration: 2ms 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-29 11:17:03 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-29 11:01:55 Duration: 0ms Database: postgres
6 140ms 856 0ms 0ms 0ms SET extra_float_digits = 3;Times Reported Time consuming prepare #6
Day Hour Count Duration Avg duration 11 856 140ms 0ms -
SET extra_float_digits = 3;
Date: 2026-03-29 11:10:54 Duration: 0ms Database: postgres
-
SET extra_float_digits = 3;
Date: 2026-03-29 11:16:36 Duration: 0ms Database: postgres
-
SET extra_float_digits = 3;
Date: 2026-03-29 11:30:02 Duration: 0ms Database: postgres
7 114ms 352 0ms 4ms 0ms SELECT ;Times Reported Time consuming prepare #7
Day Hour Count Duration Avg duration 11 352 114ms 0ms -
SELECT ;
Date: 2026-03-29 11:30:39 Duration: 4ms Database: postgres
-
SELECT ;
Date: 2026-03-29 11:26:42 Duration: 3ms Database: postgres
-
SELECT ;
Date: 2026-03-29 11:26:55 Duration: 2ms Database: postgres
8 112ms 87 1ms 1ms 1ms SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;Times Reported Time consuming prepare #8
Day Hour Count Duration Avg duration 11 87 112ms 1ms -
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-29 11:31:19 Duration: 1ms Database: postgres
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-29 11:01:13 Duration: 1ms Database: postgres
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-29 11:32:22 Duration: 1ms Database: postgres
9 57ms 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 11 288 57ms 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-29 11:47:14 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-29 11:31:00 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-29 11:46:29 Duration: 0ms Database: postgres
10 49ms 18 2ms 3ms 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 #10
Day Hour Count Duration Avg duration 11 18 49ms 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-29 11:51:01 Duration: 3ms 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-29 11:11:01 Duration: 3ms 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-29 11:51:01 Duration: 3ms Database: postgres
11 47ms 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 prepare #11
Day Hour Count Duration Avg duration 11 350 47ms 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-29 11:01:57 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-29 11:01:59 Duration: 0ms Database: postgres
-
INSERT INTO T240 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-29 11:01:23 Duration: 0ms Database: postgres
12 15ms 6 2ms 2ms 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 #12
Day Hour Count Duration Avg duration 11 6 15ms 2ms -
select client_addr, count(1) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by client_addr, setting having (client_addr is not null OR (client_addr is null and count(1) > (cast(setting as numeric) / 3 * 2))) order by count desc;
Date: 2026-03-29 11:20:05 Duration: 2ms Database: postgres
-
select client_addr, count(1) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by client_addr, setting having (client_addr is not null OR (client_addr is null and count(1) > (cast(setting as numeric) / 3 * 2))) order by count desc;
Date: 2026-03-29 11:00:05 Duration: 2ms Database: postgres
-
select client_addr, count(1) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by client_addr, setting having (client_addr is not null OR (client_addr is null and count(1) > (cast(setting as numeric) / 3 * 2))) order by count desc;
Date: 2026-03-29 11:40:05 Duration: 2ms Database: postgres
13 11ms 844 0ms 0ms 0ms SET application_name = 'PostgreSQL JDBC Driver';Times Reported Time consuming prepare #13
Day Hour Count Duration Avg duration 11 844 11ms 0ms -
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2026-03-29 11:26:56 Duration: 0ms Database: postgres
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2026-03-29 11:47:18 Duration: 0ms Database: postgres
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2026-03-29 11:02:03 Duration: 0ms Database: postgres
14 7ms 16 0ms 0ms 0ms WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;Times Reported Time consuming prepare #14
Day Hour Count Duration Avg duration 11 16 7ms 0ms -
WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;
Date: 2026-03-29 11:42:08 Duration: 0ms Database: postgres
-
WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;
Date: 2026-03-29 11:25:36 Duration: 0ms Database: postgres
-
WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;
Date: 2026-03-29 11:51:40 Duration: 0ms Database: postgres
15 7ms 34 0ms 0ms 0ms select category, ;Times Reported Time consuming prepare #15
Day Hour Count Duration Avg duration 11 34 7ms 0ms -
select category, ;
Date: 2026-03-29 11:46:19 Duration: 0ms Database: postgres
-
select category, ;
Date: 2026-03-29 11:46:07 Duration: 0ms Database: postgres
-
select category, ;
Date: 2026-03-29 11:36:43 Duration: 0ms Database: postgres
16 6ms 2 2ms 3ms 3ms with wh_patitioned as ( ;Times Reported Time consuming prepare #16
Day Hour Count Duration Avg duration 11 2 6ms 3ms -
with wh_patitioned as ( ;
Date: 2026-03-29 11:07:27 Duration: 3ms Database: postgres
-
with wh_patitioned as ( ;
Date: 2026-03-29 11:07:28 Duration: 2ms Database: postgres
17 4ms 92 0ms 1ms 0ms select 1;Times Reported Time consuming prepare #17
Day Hour Count Duration Avg duration 11 92 4ms 0ms -
select 1;
Date: 2026-03-29 11:07:28 Duration: 1ms Database: postgres
-
select 1;
Date: 2026-03-29 11:26:56 Duration: 0ms Database: postgres
-
select 1;
Date: 2026-03-29 11:26:56 Duration: 0ms Database: postgres
18 4ms 1 4ms 4ms 4ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 632 LIMIT $1;Times Reported Time consuming prepare #18
Day Hour Count Duration Avg duration 11 1 4ms 4ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 632 LIMIT $1;
Date: 2026-03-29 11:07:09 Duration: 4ms Database: postgres
19 3ms 3 0ms 1ms 1ms SELECT groupid, ;Times Reported Time consuming prepare #19
Day Hour Count Duration Avg duration 11 3 3ms 1ms -
SELECT groupid, ;
Date: 2026-03-29 11:41:00 Duration: 1ms Database: postgres
-
SELECT groupid, ;
Date: 2026-03-29 11:26:55 Duration: 1ms Database: postgres
-
SELECT groupid, ;
Date: 2026-03-29 11:26:54 Duration: 0ms Database: postgres
20 3ms 1 3ms 3ms 3ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 631 LIMIT $1;Times Reported Time consuming prepare #20
Day Hour Count Duration Avg duration 11 1 3ms 3ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 631 LIMIT $1;
Date: 2026-03-29 11:14:15 Duration: 3ms Database: postgres
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 12s998ms 953 0ms 47ms 13ms WITH rar_max as ( ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Mar 29 11 953 12s998ms 13ms -
WITH rar_max as ( ;
Date: 2026-03-29 11:50:52 Duration: 47ms Database: postgres parameters: $1 = 't', $2 = '667', $3 = '7', $4 = '15', $5 = '30', $6 = '60', $7 = '120', $8 = '240', $9 = '480', $10 = '1440', $11 = '0', $12 = '', $13 = '84', $14 = 'AUDCAD', $15 = 'AUDCHF', $16 = 'AUDJPY', $17 = 'AUDNZD', $18 = 'AUDSGD', $19 = 'CADCHF', $20 = 'CADJPY', $21 = 'CHFJPY', $22 = 'EURAUD', $23 = 'EURCAD', $24 = 'EURCHF', $25 = 'EURCZK', $26 = 'EURGBP', $27 = 'EURHUF', $28 = 'EURJPY', $29 = 'EURNOK', $30 = 'EURNZD', $31 = 'EURPLN', $32 = 'EURSEK', $33 = 'EURSGD', $34 = 'EURTRY', $35 = 'EURZAR', $36 = 'GBPAUD', $37 = 'GBPCAD', $38 = 'GBPCHF', $39 = 'GBPJPY', $40 = 'GBPNZD', $41 = 'GBPPLN', $42 = 'GBPSEK', $43 = 'GBPSGD', $44 = 'NZDCAD', $45 = 'NZDCHF', $46 = 'NZDJPY', $47 = 'NZDSGD', $48 = 'USDCNH', $49 = 'USDCZK', $50 = 'USDHUF', $51 = 'USDNOK', $52 = 'USDPLN', $53 = 'USDSEK', $54 = 'USDSGD', $55 = 'USDTRY', $56 = 'USDZAR', $57 = 'WTI', $58 = 'XBRUSD', $59 = 'XTIUSD', $60 = 'BTCUSD', $61 = 'XAGAUD', $62 = 'XAGUSD', $63 = 'XAUAUD', $64 = 'XAUUSD', $65 = 'XPTUSD', $66 = 'XPDUSD', $67 = 'AUDUSD', $68 = 'EURUSD', $69 = 'GBPUSD', $70 = 'NZDUSD', $71 = 'USDCAD', $72 = 'USDCHF', $73 = 'USDHKD', $74 = 'USDJPY', $75 = 'AUS200', $76 = 'CHINA300', $77 = 'CHINA50', $78 = 'DJ30', $79 = 'ESP35t', $80 = 'EUR50', $81 = 'EURO50', $82 = 'FRA40', $83 = 'GDAXI', $84 = 'GDAXIm', $85 = 'HK50', $86 = 'ITA40', $87 = 'J225', $88 = 'JP225', $89 = 'NAS100', $90 = 'SING30', $91 = 'SPA35', $92 = 'STOXX50', $93 = 'SUI20', $94 = 'UK100', $95 = 'US100', $96 = 'US30', $97 = 'US500', $98 = '0', $99 = '', $100 = '700', $101 = '700', $102 = '0', $103 = '0', $104 = '0', $105 = 't', $106 = '10', $107 = '10'
-
WITH rar_max as ( ;
Date: 2026-03-29 11:47:08 Duration: 46ms Database: postgres parameters: $1 = '667', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '0', $10 = 't', $11 = '0', $12 = '0'
-
WITH rar_max as ( ;
Date: 2026-03-29 11:47:08 Duration: 42ms Database: postgres parameters: $1 = '667', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '0', $10 = 't', $11 = '0', $12 = '0'
2 2s104ms 686 0ms 9ms 3ms SELECT symbolid, ;Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 11 686 2s104ms 3ms -
SELECT symbolid, ;
Date: 2026-03-29 11:46:13 Duration: 9ms Database: postgres parameters: $1 = 'BDSWISS', $2 = '15', $3 = 'NAS100'
-
SELECT symbolid, ;
Date: 2026-03-29 11:31:24 Duration: 5ms Database: postgres parameters: $1 = 'GLOBALGTMT5', $2 = '15', $3 = 'SHBUSD', $4 = 'SOLUSD', $5 = 'UKOil'
-
SELECT symbolid, ;
Date: 2026-03-29 11:31:00 Duration: 5ms Database: postgres parameters: $1 = 'BDSWISS', $2 = '15', $3 = 'BTCGBP', $4 = 'AUS_200', $5 = 'BTCEUR'
3 1s777ms 5,155 0ms 8ms 0ms SELECT ;Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 11 5,155 1s777ms 0ms -
SELECT ;
Date: 2026-03-29 11:26:55 Duration: 8ms Database: postgres parameters: $1 = '500991628203869200'
-
SELECT ;
Date: 2026-03-29 11:36:06 Duration: 6ms Database: postgres parameters: $1 = '607920549044487301', $2 = '607920549044487301', $3 = '607920549044487301'
-
SELECT ;
Date: 2026-03-29 11:26:00 Duration: 6ms Database: postgres parameters: $1 = '607919901303410301', $2 = '607919901303410301', $3 = '607919901303410301'
4 327ms 45 4ms 18ms 7ms WITH last_candle AS ( ;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 11 45 327ms 7ms -
WITH last_candle AS ( ;
Date: 2026-03-29 11:12:00 Duration: 18ms Database: postgres parameters: $1 = '558', $2 = '558'
-
WITH last_candle AS ( ;
Date: 2026-03-29 11:52:00 Duration: 14ms Database: postgres parameters: $1 = '558', $2 = '558'
-
WITH last_candle AS ( ;
Date: 2026-03-29 11:08:00 Duration: 12ms Database: postgres parameters: $1 = '558', $2 = '558'
5 224ms 16 10ms 35ms 14ms WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 11 16 224ms 14ms -
WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;
Date: 2026-03-29 11:42:08 Duration: 35ms 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-29 11:47:08 Duration: 23ms 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-29 11:51:40 Duration: 17ms Database: postgres parameters: $1 = '667', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'
6 221ms 2,427 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 11 2,427 221ms 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-29 11:11:17 Duration: 0ms Database: postgres parameters: $1 = '2026-03-27 21:00:00', $2 = '45188.35', $3 = '45231.35', $4 = '45057.25', $5 = '45097.75', $6 = '16178', $7 = '515840248000890300', $8 = '0', $9 = '2026-03-29 11:11:17.175', $10 = '2026-03-29 11:11:17.075', $11 = '45188.35', $12 = '45231.35', $13 = '45057.25', $14 = '45097.75', $15 = '16178', $16 = '0', $17 = '2026-03-29 11:11:17.175', $18 = '2026-03-29 11:11:17.075'
-
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-29 11:11:49 Duration: 0ms Database: postgres parameters: $1 = '2026-03-27 20:00:00', $2 = '249.38', $3 = '249.48', $4 = '248.21', $5 = '248.41', $6 = '5589', $7 = '515840247917405300', $8 = '0', $9 = '2026-03-29 11:11:49.386', $10 = '2026-03-29 11:11:49.317', $11 = '249.38', $12 = '249.48', $13 = '248.21', $14 = '248.41', $15 = '5589', $16 = '0', $17 = '2026-03-29 11:11:49.386', $18 = '2026-03-29 11:11:49.317'
-
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-29 11:11:57 Duration: 0ms Database: postgres parameters: $1 = '2026-03-27 20:00:00', $2 = '358.76', $3 = '359.28', $4 = '356.87', $5 = '357.51', $6 = '5291', $7 = '515840247896450300', $8 = '0', $9 = '2026-03-29 11:11:57.477', $10 = '2026-03-29 11:11:57.403', $11 = '358.76', $12 = '359.28', $13 = '356.87', $14 = '357.51', $15 = '5291', $16 = '0', $17 = '2026-03-29 11:11:57.477', $18 = '2026-03-29 11:11:57.403'
7 196ms 4,528 0ms 12ms 0ms select 1;Times Reported Time consuming bind #7
Day Hour Count Duration Avg duration 11 4,528 196ms 0ms -
select 1;
Date: 2026-03-29 11:50:54 Duration: 12ms Database: postgres
-
select 1;
Date: 2026-03-29 11:50:54 Duration: 11ms Database: postgres
-
select 1;
Date: 2026-03-29 11:51:00 Duration: 6ms Database: postgres
8 193ms 2,442 0ms 0ms 0ms INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming bind #8
Day Hour Count Duration Avg duration 11 2,442 193ms 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-29 11:30:22 Duration: 0ms Database: postgres parameters: $1 = '2026-03-27 22:30:00', $2 = '4523.31', $3 = '4526.4', $4 = '4501', $5 = '4514.61', $6 = '9255', $7 = '515840230627771300', $8 = '0', $9 = '2026-03-29 11:30:22.383', $10 = '2026-03-29 11:30:22.375', $11 = '4523.31', $12 = '4526.4', $13 = '4501', $14 = '4514.61', $15 = '9255', $16 = '0', $17 = '2026-03-29 11:30:22.383', $18 = '2026-03-29 11:30:22.375'
-
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-29 11:32:14 Duration: 0ms Database: postgres parameters: $1 = '2026-03-27 22:00:00', $2 = '23103.6', $3 = '23113.5', $4 = '23046.6', $5 = '23063.2', $6 = '9223', $7 = '515840248039147300', $8 = '0', $9 = '2026-03-29 11:32:14.913', $10 = '2026-03-29 11:32:14.807', $11 = '23103.6', $12 = '23113.5', $13 = '23046.6', $14 = '23063.2', $15 = '9223', $16 = '0', $17 = '2026-03-29 11:32:14.913', $18 = '2026-03-29 11:32:14.807'
-
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-29 11:32:16 Duration: 0ms Database: postgres parameters: $1 = '2026-03-27 22:00:00', $2 = '6358.3', $3 = '6361.3', $4 = '6345.3', $5 = '6350.8', $6 = '2487', $7 = '515840248032224300', $8 = '0', $9 = '2026-03-29 11:32:16.925', $10 = '2026-03-29 11:32:16.832', $11 = '6358.3', $12 = '6361.3', $13 = '6345.3', $14 = '6350.8', $15 = '2487', $16 = '0', $17 = '2026-03-29 11:32:16.925', $18 = '2026-03-29 11:32:16.832'
9 177ms 87 1ms 2ms 2ms SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;Times Reported Time consuming bind #9
Day Hour Count Duration Avg duration 11 87 177ms 2ms -
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-29 11:01:21 Duration: 2ms Database: postgres parameters: $1 = 'ATFX'
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-29 11:01:13 Duration: 2ms Database: postgres parameters: $1 = 'ATFX'
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-29 11:32:22 Duration: 2ms Database: postgres parameters: $1 = 'PEPPERSTONEMT5'
10 161ms 2,900 0ms 0ms 0ms INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming bind #10
Day Hour Count Duration Avg duration 11 2,900 161ms 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-29 11:00:07 Duration: 0ms Database: postgres parameters: $1 = '2026-03-27 22:45:00', $2 = '0.954005', $3 = '0.954385', $4 = '0.953835', $5 = '0.95415', $6 = '1054', $7 = '515840230419121300', $8 = '0', $9 = '2026-03-29 11:00:07.793', $10 = '2026-03-29 11:00:07.676', $11 = '0.954005', $12 = '0.954385', $13 = '0.953835', $14 = '0.95415', $15 = '1054', $16 = '0', $17 = '2026-03-29 11:00:07.793', $18 = '2026-03-29 11:00:07.676'
-
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-29 11:47:14 Duration: 0ms Database: postgres parameters: $1 = '2026-03-27 23:45:00', $2 = '1.151345', $3 = '1.15143', $4 = '1.150825', $5 = '1.15086', $6 = '736', $7 = '515840249372435300', $8 = '0', $9 = '2026-03-29 11:47:14.361', $10 = '2026-03-29 11:47:14.29', $11 = '1.151345', $12 = '1.15143', $13 = '1.150825', $14 = '1.15086', $15 = '736', $16 = '0', $17 = '2026-03-29 11:47:14.361', $18 = '2026-03-29 11:47:14.29'
-
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-29 11:01:59 Duration: 0ms Database: postgres parameters: $1 = '2026-03-27 23:45:00', $2 = '0.687805', $3 = '0.688025', $4 = '0.687275', $5 = '0.687405', $6 = '725', $7 = '515840249374319300', $8 = '0', $9 = '2026-03-29 11:01:59.451', $10 = '2026-03-29 11:01:59.384', $11 = '0.687805', $12 = '0.688025', $13 = '0.687275', $14 = '0.687405', $15 = '725', $16 = '0', $17 = '2026-03-29 11:01:59.451', $18 = '2026-03-29 11:01:59.384'
11 142ms 5 20ms 35ms 28ms with wh_patitioned as ( ;Times Reported Time consuming bind #11
Day Hour Count Duration Avg duration 11 5 142ms 28ms -
with wh_patitioned as ( ;
Date: 2026-03-29 11:11:57 Duration: 35ms 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-29 11:07:28 Duration: 31ms 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-29 11:25:07 Duration: 28ms Database: postgres parameters: $1 = '667', $2 = '667', $3 = '667', $4 = '667', $5 = '667', $6 = '667', $7 = '667', $8 = '667', $9 = '667'
12 76ms 1 76ms 76ms 76ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 1018 LIMIT $1;Times Reported Time consuming bind #12
Day Hour Count Duration Avg duration 11 1 76ms 76ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 1018 LIMIT $1;
Date: 2026-03-29 11:26:07 Duration: 76ms Database: postgres parameters: $1 = '50'
13 69ms 1 69ms 69ms 69ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 888 LIMIT $1;Times Reported Time consuming bind #13
Day Hour Count Duration Avg duration 11 1 69ms 69ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 888 LIMIT $1;
Date: 2026-03-29 11:16:10 Duration: 69ms Database: postgres parameters: $1 = '50'
14 57ms 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 #14
Day Hour Count Duration Avg duration 11 288 57ms 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-29 11:31:24 Duration: 0ms Database: postgres parameters: $1 = '2026-03-27 00:00:00', $2 = '104.205', $3 = '110.72', $4 = '102.9', $5 = '110.635', $6 = '33408', $7 = '515840249390663300', $8 = '0', $9 = '2026-03-29 11:31:24.352', $10 = '2026-03-29 11:31:24.351', $11 = '104.205', $12 = '110.72', $13 = '102.9', $14 = '110.635', $15 = '33408', $16 = '0', $17 = '2026-03-29 11:31:24.352', $18 = '2026-03-29 11:31:24.351'
-
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-29 11:47:14 Duration: 0ms Database: postgres parameters: $1 = '2026-03-27 00:00:00', $2 = '213.01', $3 = '213.104', $4 = '212.236', $5 = '212.5615', $6 = '190323', $7 = '515840249382462300', $8 = '0', $9 = '2026-03-29 11:47:14.399', $10 = '2026-03-29 11:47:14.399', $11 = '213.01', $12 = '213.104', $13 = '212.236', $14 = '212.5615', $15 = '190323', $16 = '0', $17 = '2026-03-29 11:47:14.399', $18 = '2026-03-29 11:47:14.399'
-
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-29 11:30:27 Duration: 0ms Database: postgres parameters: $1 = '2026-03-27 00:00:00', $2 = '1.386145', $3 = '1.38956', $4 = '1.38452', $5 = '1.38923', $6 = '59938', $7 = '515840249464481300', $8 = '0', $9 = '2026-03-29 11:30:27.786', $10 = '2026-03-29 11:30:27.786', $11 = '1.386145', $12 = '1.38956', $13 = '1.38452', $14 = '1.38923', $15 = '59938', $16 = '0', $17 = '2026-03-29 11:30:27.786', $18 = '2026-03-29 11:30:27.786'
15 52ms 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 #15
Day Hour Count Duration Avg duration 11 350 52ms 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-29 11:31:28 Duration: 0ms Database: postgres parameters: $1 = '2026-03-27 20:00:00', $2 = '0.79686', $3 = '0.799355', $4 = '0.796375', $5 = '0.799035', $6 = '7148', $7 = '515840249378973300', $8 = '0', $9 = '2026-03-29 11:31:28.336', $10 = '2026-03-29 11:31:28.316', $11 = '0.79686', $12 = '0.799355', $13 = '0.796375', $14 = '0.799035', $15 = '7148', $16 = '0', $17 = '2026-03-29 11:31:28.336', $18 = '2026-03-29 11:31:28.316'
-
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-29 11:01:57 Duration: 0ms Database: postgres parameters: $1 = '2026-03-29 08:00:00', $2 = '0.2460685', $3 = '0.2469135', $4 = '0.2432755', $5 = '0.2456585', $6 = '3645', $7 = '515840249401591300', $8 = '0', $9 = '2026-03-29 11:01:57.427', $10 = '2026-03-29 11:01:57.427', $11 = '0.2460685', $12 = '0.2469135', $13 = '0.2432755', $14 = '0.2456585', $15 = '3645', $16 = '0', $17 = '2026-03-29 11:01:57.427', $18 = '2026-03-29 11:01:57.427'
-
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-29 11:01:59 Duration: 0ms Database: postgres parameters: $1 = '2026-03-29 08:00:00', $2 = '10699526.5', $3 = '10721948', $4 = '10670625.5', $5 = '10697625.5', $6 = '10510', $7 = '515840249393808300', $8 = '0', $9 = '2026-03-29 11:01:59.473', $10 = '2026-03-29 11:01:59.473', $11 = '10699526.5', $12 = '10721948', $13 = '10670625.5', $14 = '10697625.5', $15 = '10510', $16 = '0', $17 = '2026-03-29 11:01:59.473', $18 = '2026-03-29 11:01:59.473'
16 51ms 418 0ms 0ms 0ms select category, ;Times Reported Time consuming bind #16
Day Hour Count Duration Avg duration 11 418 51ms 0ms -
select category, ;
Date: 2026-03-29 11:36:31 Duration: 0ms Database: postgres parameters: $1 = '605717914804453307', $2 = 'symbol', $3 = 'Corn_Z5', $4 = 'BRENT_X5', $5 = 'WTI_U5', $6 = 'Corn_Z5', $7 = 'BRENT_U5', $8 = 'WTI_Q5', $9 = 'Corn_U5', $10 = 'Wheat_U5', $11 = 'Wheat_N5', $12 = 'BRENT_X5', $13 = 'BRENT_Q5', $14 = 'WTI_U5', $15 = 'BRENT_N5', $16 = 'BRENT_U5', $17 = 'Corn_U5', $18 = 'WTI_N5', $19 = 'Corn_N5', $20 = 'WTI_Q5', $21 = 'Sugar_V5', $22 = 'Wheat_U5', $23 = 'WTI_M5', $24 = 'Corn_N5', $25 = 'BRENT_Q5', $26 = 'Wheat_N5', $27 = 'BRENT_M5', $28 = 'WTI_K5', $29 = 'BRENT_V5', $30 = 'Wheat_K5', $31 = 'WTI_N5', $32 = 'Coffee_U5', $33 = 'Sugar_N5', $34 = 'Sugar_V5', $35 = 'WTI_M5', $36 = 'BRENT_N5', $37 = 'BRENT_M5', $38 = 'BRENT_V5', $39 = 'Corn_K5', $40 = 'Coffee_N5', $41 = 'WTI_K5', $42 = 'Corn_K5', $43 = 'Coffee_U5', $44 = 'Sugar_K5', $45 = 'BRENT_K5', $46 = 'Sugar_N5', $47 = 'Coffee_N5', $48 = 'Wheat_K5', $49 = 'BRENT_K5', $50 = 'Coffee_K5', $51 = 'Sugar_K5', $52 = 'Coffee_K5', $53 = '605717914804453307', $54 = 'symbol', $55 = 'Corn_Z5', $56 = 'BRENT_X5', $57 = 'WTI_U5', $58 = 'Corn_Z5', $59 = 'BRENT_U5', $60 = 'WTI_Q5', $61 = 'Corn_U5', $62 = 'Wheat_U5', $63 = 'Wheat_N5', $64 = 'BRENT_X5', $65 = 'BRENT_Q5', $66 = 'WTI_U5', $67 = 'BRENT_N5', $68 = 'BRENT_U5', $69 = 'Corn_U5', $70 = 'WTI_N5', $71 = 'Corn_N5', $72 = 'WTI_Q5', $73 = 'Sugar_V5', $74 = 'Wheat_U5', $75 = 'WTI_M5', $76 = 'Corn_N5', $77 = 'BRENT_Q5', $78 = 'Wheat_N5', $79 = 'BRENT_M5', $80 = 'WTI_K5', $81 = 'BRENT_V5', $82 = 'Wheat_K5', $83 = 'WTI_N5', $84 = 'Coffee_U5', $85 = 'Sugar_N5', $86 = 'Sugar_V5', $87 = 'WTI_M5', $88 = 'BRENT_N5', $89 = 'BRENT_M5', $90 = 'BRENT_V5', $91 = 'Corn_K5', $92 = 'Coffee_N5', $93 = 'WTI_K5', $94 = 'Corn_K5', $95 = 'Coffee_U5', $96 = 'Sugar_K5', $97 = 'BRENT_K5', $98 = 'Sugar_N5', $99 = 'Coffee_N5', $100 = 'Wheat_K5', $101 = 'BRENT_K5', $102 = 'Coffee_K5', $103 = 'Sugar_K5', $104 = 'Coffee_K5'
-
select category, ;
Date: 2026-03-29 11:46:19 Duration: 0ms Database: postgres parameters: $1 = '606605126049202307', $2 = 'symbol', $3 = 'US30', $4 = 'UK100', $5 = 'US500', $6 = 'USTEC', $7 = 'US2000', $8 = 'JP225', $9 = 'DE30', $10 = 'AUS200', $11 = 'CHINA50', $12 = 'F40', $13 = 'STOXX50', $14 = 'HK50', $15 = 'IT40', $16 = 'US2000', $17 = 'US30', $18 = 'ES35', $19 = 'AUS200', $20 = 'USTEC', $21 = 'UK100', $22 = 'JP225', $23 = 'US500', $24 = 'CHINA50', $25 = 'DE30', $26 = 'STOXX50', $27 = 'F40', $28 = 'ES35', $29 = 'HK50', $30 = 'IT40', $31 = '606605126049202307', $32 = 'symbol', $33 = 'US30', $34 = 'UK100', $35 = 'US500', $36 = 'USTEC', $37 = 'US2000', $38 = 'JP225', $39 = 'DE30', $40 = 'AUS200', $41 = 'CHINA50', $42 = 'F40', $43 = 'STOXX50', $44 = 'HK50', $45 = 'IT40', $46 = 'US2000', $47 = 'US30', $48 = 'ES35', $49 = 'AUS200', $50 = 'USTEC', $51 = 'UK100', $52 = 'JP225', $53 = 'US500', $54 = 'CHINA50', $55 = 'DE30', $56 = 'STOXX50', $57 = 'F40', $58 = 'ES35', $59 = 'HK50', $60 = 'IT40'
-
select category, ;
Date: 2026-03-29 11:36:28 Duration: 0ms Database: postgres parameters: $1 = '605717914804453307', $2 = 'initialtrend', $3 = '605717914804453307', $4 = 'initialtrend'
17 37ms 5 0ms 19ms 7ms select distinct s.statsid as statsid, sy.exchange as name;Times Reported Time consuming bind #17
Day Hour Count Duration Avg duration 11 5 37ms 7ms -
select distinct s.statsid as statsid, sy.exchange as name;
Date: 2026-03-29 11:36:25 Duration: 19ms Database: postgres parameters: $1 = '972', $2 = '972'
-
select distinct s.statsid as statsid, sy.exchange as name;
Date: 2026-03-29 11:07:37 Duration: 17ms Database: postgres parameters: $1 = '914', $2 = '914'
-
select distinct s.statsid as statsid, sy.exchange as name;
Date: 2026-03-29 11:45:50 Duration: 0ms Database: postgres parameters: $1 = '1018', $2 = '1018'
18 35ms 1 35ms 35ms 35ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 1471 LIMIT $1;Times Reported Time consuming bind #18
Day Hour Count Duration Avg duration 11 1 35ms 35ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 1471 LIMIT $1;
Date: 2026-03-29 11:29:07 Duration: 35ms Database: postgres parameters: $1 = '50'
19 35ms 1 35ms 35ms 35ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 1505 LIMIT $1;Times Reported Time consuming bind #19
Day Hour Count Duration Avg duration 11 1 35ms 35ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 1505 LIMIT $1;
Date: 2026-03-29 11:29:36 Duration: 35ms Database: postgres parameters: $1 = '50'
20 33ms 1 33ms 33ms 33ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 932 LIMIT $1;Times Reported Time consuming bind #20
Day Hour Count Duration Avg duration 11 1 33ms 33ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 932 LIMIT $1;
Date: 2026-03-29 11:20:07 Duration: 33ms Database: postgres parameters: $1 = '50'
-
Events
Log levels
Key values
- 154,743 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 29 11 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-29 11:00:13
2 76 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 29 11 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-29 11:07:09
Statement: SELECT * FROM broker_stats_timezone_offset_count_view WHERE group" = 'Commodities' LIMIT $1
Date: 2026-03-29 11:07:09
3 76 ERROR: function broker_stats_get_symbols_function(...) does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 29 11 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(601729875359289307,632) WHERE lower(category) = 'symbol' ORDER BY correct DESC LIMIT $1Date: 2026-03-29 11:07:09