pgBadger-
Global information
- Generated on Sat Feb 21 12:59:21 2026
- Log file: /home/postgres/pg_data/data/pg_log/postgresql-2026-02-21_140000.log
- Parsed 670,973 log entries in 20s
- Log start from 2026-02-21 14:00:00 to 2026-02-21 14:59:19
-
Overview
Global Stats
- 166 Number of unique normalized queries
- 103,340 Number of queries
- 48m34s Total query duration
- 2026-02-21 14:00:00 First query
- 2026-02-21 14:59:19 Last query
- 2,299 queries/s at 2026-02-21 14:00:04 Query peak
- 48m34s Total query duration
- 3s283ms Prepare/parse total duration
- 17s556ms Bind total duration
- 48m13s Execute total duration
- 394 Number of events
- 4 Number of unique normalized events
- 356 Max number of times the same event was reported
- 0 Number of cancellation
- 10 Total number of automatic vacuums
- 17 Total number of automatic analyzes
- 35 Number temporary file
- 4.33 MiB Max size of temporary file
- 3.76 MiB Average size of temporary file
- 1,729 Total number of sessions
- 12 sessions at 2026-02-21 14:57:49 Session peak
- 16h27m31s Total duration of sessions
- 34s269ms Average duration of sessions
- 59 Average queries per session
- 1s685ms Average queries duration per session
- 32s583ms Average idle time per session
- 1,730 Total number of connections
- 28 connections/s at 2026-02-21 14:03:48 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 2,299 queries/s Query Peak
- 2026-02-21 14:00:04 Date
SELECT Traffic
Key values
- 1,148 queries/s Query Peak
- 2026-02-21 14:00:04 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 121 queries/s Query Peak
- 2026-02-21 14:53:49 Date
Queries duration
Key values
- 48m34s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Feb 21 14 103,340 0ms 20s450ms 27ms 2m2s 2m12s 2m17s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Feb 21 14 32,832 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Feb 21 14 12,753 575 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Feb 21 14 10,531 26,671 2.53 21.46% Day Hour Count Average / Second Feb 21 14 1,730 0.48/s Day Hour Count Average Duration Average idle time Feb 21 14 1,729 34s269ms 32s595ms -
Connections
Established Connections
Key values
- 28 connections Connection Peak
- 2026-02-21 14:03:48 Date
Connections per database
Key values
- acaweb_fx Main Database
- 1,730 connections Total
Connections per user
Key values
- postgres Main User
- 1,730 connections Total
Connections per host
Key values
- 192.168.4.142 Main host with 786 connections
- 1,730 Total connections
-
Sessions
Simultaneous sessions
Key values
- 12 sessions Session Peak
- 2026-02-21 14:57:49 Date
Histogram of session times
Key values
- 1,348 0-500ms duration
Sessions per database
Key values
- acaweb_fx Main Database
- 1,729 sessions Total
Sessions per user
Key values
- postgres Main User
- 1,729 sessions Total
Sessions per host
Key values
- 192.168.4.142 Main Host
- 1,729 sessions Total
Host Count Total Duration Average Duration 192.168.0.114 3 15m 5m 192.168.0.216 116 7m26s 3s847ms 192.168.1.145 110 1h1m34s 33s584ms 192.168.1.15 34 2h13m20s 3m55s 192.168.1.20 123 12h40m27s 6m10s 192.168.1.239 56 334ms 5ms 192.168.1.90 6 42ms 7ms 192.168.2.126 18 5s126ms 284ms 192.168.3.199 38 21s697ms 570ms 192.168.4.142 786 6m58s 532ms 192.168.4.168 3 1s133ms 377ms 192.168.4.33 70 39s112ms 558ms 192.168.4.98 330 14s366ms 43ms [local] 36 1m21s 2s263ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 1,950 buffers Checkpoint Peak
- 2026-02-21 14:07:30 Date
- 195.318 seconds Highest write time
- 0.004 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2026-02-21 14:29:30 Date
Checkpoints distance
Key values
- 21.38 Mo Distance Peak
- 2026-02-21 14:07:30 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Feb 21 14 10,417 1,042.494s 0.029s 1,042.725s Day Hour Added Removed Recycled Synced files Longest sync Average sync Feb 21 14 0 0 5 982 0.004s 0s Day Hour Count Avg time (sec) Feb 21 14 0 0s Day Hour Mean distance Mean estimate Feb 21 14 6,449.82 kB 9,582.18 kB -
Temporary Files
Size of temporary files
Key values
- 4.33 MiB Temp Files size Peak
- 2026-02-21 14:45:46 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2026-02-21 14:10:45 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Feb 21 14 35 131.51 MiB 3.76 MiB Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 11 38.67 MiB 3.52 MiB 3.52 MiB 3.52 MiB jr.resultuid as resultuid, jr.direction as direction, jr.patternendtime as identified, jr.patternlengthbars as length, jr.patternstarttime as patternstarttime, case when jr.trendchangeid = ? then ? else ? end as trendchange, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, jp.patternname as pattern_name, dtt.timezone as timezone, ? as age, cps.pip, g.basegroupname from japsticks_results jr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = jr.symbolid inner join relevance_japsticks_results rar on rar.resultuid = jr.resultuid inner join symbols s on jr.symbolid = s.symbolid and s.nonliquid = ? inner join japsticks_patterns jp on jr.patternid = jp.id inner join downloadersymbolsettings dss on jr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on s.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where jr.gmttimefound > now() - interval ? and s.deleted = ? and (jr.simulation = ? or jr.simulation is null) and (rar.relevant = ?) --and (semicolon_age = ? or rar.age <= semicolon_age) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or jp.patternname in (...)) and (? = ? or jr.patternlengthbars <= ?) ), results as ( select distinct on (symbolid) * from all_results order by symbolid, resultuid ) select * from results order by identified desc, length desc ;-
jr.resultuid AS resultuid, jr.direction AS direction, jr.patternendtime AS identified, jr.patternlengthbars AS length, jr.patternstarttime AS patternstarttime, case when jr.trendchangeid = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;
Date: 2026-02-21 14:02:44 Duration: 0ms
2 8 27.28 MiB 3.41 MiB 3.41 MiB 3.41 MiB select resultuid from relevance_consecutivecandles_results order by resultuid desc limit ?), all_results as ( select ccr.resultuid as resultuid, ccr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, ccr.patternendtime as identified, dtt.timezone as timezone, ccr.qtyconsecutivecandles as length, g.basegroupname, case when rcr.age is not null then rcr.age when ccr.resultuid <= rm.resultuid then ? else ? end as age, case when rcr.relevant is not null then rcr.relevant when ccr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip, newlevels.filtered from consecutivecandles_results ccr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = ccr.symbolid inner join symbols s on ccr.symbolid = s.symbolid and s.nonliquid = ? inner join downloadersymbolsettings dss on ccr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on ccr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join rar_max rm on ? = ? left outer join relevance_consecutivecandles_results rcr on rcr.resultuid = ccr.resultuid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? left join lateral calc_cc_signal_filter (ccr.resultuid) newlevels on true where ccr.gmttimefound > now() - interval ? and s.deleted = ? and (ccr.simulation = ? or ccr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ccr.patternlengthbars <= ?)), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc;-
SELECT resultuid FROM relevance_consecutivecandles_results ORDER BY resultuid DESC LIMIT 1), all_results AS ( SELECT ccr.resultuid AS resultuid, ccr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, ccr.patternendtime AS identified, dtt.timezone AS timezone, ccr.qtyconsecutivecandles AS length, g.basegroupname, CASE WHEN rcr.age IS NOT NULL THEN rcr.age WHEN ccr.resultuid <= rm.resultuid THEN 1 ELSE 0 END as age, CASE WHEN rcr.relevant IS NOT NULL THEN rcr.relevant WHEN ccr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip, newLevels.filtered FROM consecutivecandles_results ccr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = ccr.symbolid INNER JOIN symbols s ON ccr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN downloadersymbolsettings dss ON ccr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on ccr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_consecutivecandles_results rcr ON rcr.resultuid = ccr.resultuid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' LEFT JOIN LATERAL calc_cc_signal_filter (ccr.resultuid) newLevels on true WHERE ccr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (ccr.simulation = 0 OR ccr.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3, $4, $5, $6, $7, $8, $9)) AND ($10 = 0 OR s.exchange in ($11)) AND ($12 = 0 OR coalesce(bim.code, s.symbol) in ($13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225)) AND ($226 = 0 OR ccr.patternlengthbars <= $227)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $228 OR relevant = 1) AND ($229 = 0 OR age <= $230) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;
Date: 2026-02-21 14:06:04 Duration: 0ms
3 8 34.61 MiB 4.32 MiB 4.33 MiB 4.33 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)) AND ($227 = 0 OR fr.pattern in ($228)) AND ($229 = 0 OR fr.patternlengthbars <= $230) AND ($231 = 0 OR ($232 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($233 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $234 OR relevant = 1) AND ($235 = 0 OR age <= $236) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;
Date: 2026-02-21 14:05:46 Duration: 0ms
Queries generating the largest temporary files
Rank Size Query 1 4.33 MiB 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)) AND ($227 = 0 OR fr.pattern in ($228)) AND ($229 = 0 OR fr.patternlengthbars <= $230) AND ($231 = 0 OR ($232 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($233 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $234 OR relevant = 1) AND ($235 = 0 OR age <= $236) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;[ Date: 2026-02-21 14:50:46 ]
2 4.33 MiB 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)) AND ($227 = 0 OR fr.pattern in ($228)) AND ($229 = 0 OR fr.patternlengthbars <= $230) AND ($231 = 0 OR ($232 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($233 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $234 OR relevant = 1) AND ($235 = 0 OR age <= $236) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;[ Date: 2026-02-21 14:55:46 ]
3 4.33 MiB 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)) AND ($227 = 0 OR fr.pattern in ($228)) AND ($229 = 0 OR fr.patternlengthbars <= $230) AND ($231 = 0 OR ($232 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($233 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $234 OR relevant = 1) AND ($235 = 0 OR age <= $236) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;[ Date: 2026-02-21 14:40:46 ]
4 4.33 MiB 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)) AND ($227 = 0 OR fr.pattern in ($228)) AND ($229 = 0 OR fr.patternlengthbars <= $230) AND ($231 = 0 OR ($232 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($233 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $234 OR relevant = 1) AND ($235 = 0 OR age <= $236) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;[ Date: 2026-02-21 14:35:46 ]
5 4.33 MiB 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)) AND ($227 = 0 OR fr.pattern in ($228)) AND ($229 = 0 OR fr.patternlengthbars <= $230) AND ($231 = 0 OR ($232 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($233 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $234 OR relevant = 1) AND ($235 = 0 OR age <= $236) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;[ Date: 2026-02-21 14:20:45 ]
6 4.33 MiB 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)) AND ($227 = 0 OR fr.pattern in ($228)) AND ($229 = 0 OR fr.patternlengthbars <= $230) AND ($231 = 0 OR ($232 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($233 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $234 OR relevant = 1) AND ($235 = 0 OR age <= $236) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;[ Date: 2026-02-21 14:25:47 ]
7 4.32 MiB 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)) AND ($227 = 0 OR fr.pattern in ($228)) AND ($229 = 0 OR fr.patternlengthbars <= $230) AND ($231 = 0 OR ($232 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($233 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $234 OR relevant = 1) AND ($235 = 0 OR age <= $236) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;[ Date: 2026-02-21 14:05:46 ]
8 4.32 MiB 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)) AND ($227 = 0 OR fr.pattern in ($228)) AND ($229 = 0 OR fr.patternlengthbars <= $230) AND ($231 = 0 OR ($232 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($233 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $234 OR relevant = 1) AND ($235 = 0 OR age <= $236) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;[ Date: 2026-02-21 14:10:45 ]
9 3.52 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 = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;[ Date: 2026-02-21 14:02:44 ]
10 3.52 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 = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;[ Date: 2026-02-21 14:07:36 ]
11 3.52 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 = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;[ Date: 2026-02-21 14:12:42 ]
12 3.52 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 = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;[ Date: 2026-02-21 14:17:51 ]
13 3.52 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 = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;[ Date: 2026-02-21 14:23:19 ]
14 3.52 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 = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;[ Date: 2026-02-21 14:27:53 ]
15 3.52 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 = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;[ Date: 2026-02-21 14:32:52 ]
16 3.52 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 = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;[ Date: 2026-02-21 14:37:52 ]
17 3.52 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 = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;[ Date: 2026-02-21 14:43:34 ]
18 3.52 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 = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;[ Date: 2026-02-21 14:49:27 ]
19 3.52 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 = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;[ Date: 2026-02-21 14:53:45 ]
20 3.41 MiB SELECT resultuid FROM relevance_consecutivecandles_results ORDER BY resultuid DESC LIMIT 1), all_results AS ( SELECT ccr.resultuid AS resultuid, ccr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, ccr.patternendtime AS identified, dtt.timezone AS timezone, ccr.qtyconsecutivecandles AS length, g.basegroupname, CASE WHEN rcr.age IS NOT NULL THEN rcr.age WHEN ccr.resultuid <= rm.resultuid THEN 1 ELSE 0 END as age, CASE WHEN rcr.relevant IS NOT NULL THEN rcr.relevant WHEN ccr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip, newLevels.filtered FROM consecutivecandles_results ccr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = ccr.symbolid INNER JOIN symbols s ON ccr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN downloadersymbolsettings dss ON ccr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on ccr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_consecutivecandles_results rcr ON rcr.resultuid = ccr.resultuid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' LEFT JOIN LATERAL calc_cc_signal_filter (ccr.resultuid) newLevels on true WHERE ccr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (ccr.simulation = 0 OR ccr.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3, $4, $5, $6, $7, $8, $9)) AND ($10 = 0 OR s.exchange in ($11)) AND ($12 = 0 OR coalesce(bim.code, s.symbol) in ($13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225)) AND ($226 = 0 OR ccr.patternlengthbars <= $227)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $228 OR relevant = 1) AND ($229 = 0 OR age <= $230) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;[ Date: 2026-02-21 14:36:04 ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Analyzes per table
Key values
- pg_catalog.pg_type (4) Main table analyzed (database acaweb_fx)
- 17 analyzes Total
Vacuums per table
Key values
- public.datafeeds_latestrun (3) Main table vacuumed on database acaweb_fx
- 10 vacuums Total
Index Buffer usage Skipped WAL usage Table Vacuums scans hits misses dirtied pins frozen records full page bytes acaweb_fx.public.datafeeds_latestrun 3 0 369 0 6 0 0 39 6 42,060 acaweb_fx.pg_catalog.pg_type 2 2 368 0 37 0 0 144 36 218,216 acaweb_fx.pg_catalog.pg_attribute 2 2 2,368 0 176 0 134 680 174 1,107,940 acaweb_fx.pg_catalog.pg_depend 1 1 606 0 73 0 59 167 70 354,265 acaweb_fx.public.latest_t15_candle_view 1 1 94 0 1 0 0 6 1 9,061 acaweb_fx.pg_catalog.pg_class 1 1 365 0 48 0 79 121 49 274,749 Total 10 7 4,170 487 341 0 272 1,157 336 2,006,291 Tuples removed per table
Key values
- pg_catalog.pg_attribute (3322) Main table with removed tuples on database acaweb_fx
- 4623 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain acaweb_fx.pg_catalog.pg_attribute 2 2 3,322 21,270 0 0 534 acaweb_fx.pg_catalog.pg_type 2 2 640 2,896 0 0 88 acaweb_fx.pg_catalog.pg_depend 1 1 344 14,386 0 0 143 acaweb_fx.public.datafeeds_latestrun 3 0 178 42 0 0 48 acaweb_fx.pg_catalog.pg_class 1 1 79 2,586 0 0 150 acaweb_fx.public.latest_t15_candle_view 1 1 60 14 0 0 1 Total 10 7 4,623 41,194 0 0 964 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Pages removed per tables
NO DATASET
Table Number of vacuums Index scans Tuples removed Pages removed acaweb_fx.pg_catalog.pg_depend 1 1 344 0 acaweb_fx.public.latest_t15_candle_view 1 1 60 0 acaweb_fx.pg_catalog.pg_type 2 2 640 0 acaweb_fx.public.datafeeds_latestrun 3 0 178 0 acaweb_fx.pg_catalog.pg_attribute 2 2 3322 0 acaweb_fx.pg_catalog.pg_class 1 1 79 0 Total 10 7 4,623 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Feb 21 14 10 17 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 32,832 Total read queries
- 16,239 Total write queries
Queries by database
Key values
- unknown Main database
- 102,688 Requests
- 48m13s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 102,688 Requests
User Request type Count Duration postgres Total 652 0ms others 214 0ms select 74 0ms tcl 336 0ms update 28 0ms unknown Total 102,688 48m13s cte 2,228 0ms insert 12,753 0ms others 2,581 0ms select 32,758 0ms tcl 347 0ms update 547 0ms Duration by user
Key values
- 48m13s (unknown) Main time consuming user
User Request type Count Duration postgres Total 652 0ms others 214 0ms select 74 0ms tcl 336 0ms update 28 0ms unknown Total 102,688 48m13s cte 2,228 0ms insert 12,753 0ms others 2,581 0ms select 32,758 0ms tcl 347 0ms update 547 0ms Queries by host
Key values
- unknown Main host
- 103,340 Requests
- 48m13s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 103,304 Requests
- 48m13s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-02-21 14:51:59 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 30,352 0-1ms duration
Slowest individual queries
Rank Duration Query NO DATASET
Time consuming queries
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 11 0ms 0ms 0ms select key, value from datasources ds inner join datasourceparams dsp on ds.id = dsp.datasourceid where ds.name = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Feb 21 14 11 0ms 0ms 2 0ms 127 0ms 0ms 0ms with rar_max as ( select resultuid from relevance_consecutivecandles_results order by resultuid desc limit ? ), all_results as ( select ccr.resultuid as resultuid, ccr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, ccr.patternendtime as identified, dtt.timezone as timezone, ccr.qtyconsecutivecandles as length, g.basegroupname, case when rcr.age is not null then rcr.age when ccr.resultuid <= rm.resultuid then ? else ? end as age, case when rcr.relevant is not null then rcr.relevant when ccr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip, newlevels.filtered from consecutivecandles_results ccr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = ccr.symbolid inner join symbols s on ccr.symbolid = s.symbolid and s.nonliquid = ? inner join downloadersymbolsettings dss on ccr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on ccr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join rar_max rm on ? = ? left outer join relevance_consecutivecandles_results rcr on rcr.resultuid = ccr.resultuid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? left join lateral calc_cc_signal_filter (ccr.resultuid) newlevels on true where ccr.gmttimefound > now() - interval ? and s.deleted = ? and (ccr.simulation = ? or ccr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ccr.patternlengthbars <= ?) ), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Feb 21 14 127 0ms 0ms 3 0ms 2,410 0ms 0ms 0ms insert into t60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Feb 21 14 2,410 0ms 0ms 4 0ms 17 0ms 0ms 0ms select case when a.old_resultuid = ? then a.old_resultuid else a.resultuid end as resultuid, s.symbol, timegranularity as interval, direction as direction, patternendtime as patternendtime, patternstartprice as psp, patternendprice as pep, target03 as t03, target16 as t16, patternlengthbars as length, p.patternname as patternname, dtt.timezone, cps.pip from fibonacci_results a inner join downloadersymbolsettings dss on a.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join fibonaccipatterns p on a.pattern = p.patternname left join currencypips cps on cps.symbol = s.symbol where (a.old_resultuid = ? or a.resultuid = ?) and dtt.dayofweek = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Feb 21 14 17 0ms 0ms 5 0ms 180 0ms 0ms 0ms update patternresultsrelevance set relevant = ?, saxo_relevant = ?, notrelevantpricedatetime = ?, reason = ? where uniqueindex = ? and relevant = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Feb 21 14 180 0ms 0ms 6 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 #6
Day Hour Count Duration Avg duration Feb 21 14 18 0ms 0ms 7 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 #7
Day Hour Count Duration Avg duration Feb 21 14 237 0ms 0ms 8 0ms 19 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 #8
Day Hour Count Duration Avg duration Feb 21 14 19 0ms 0ms 9 0ms 340 0ms 0ms 0ms commit;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Feb 21 14 340 0ms 0ms 10 0ms 3 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 #10
Day Hour Count Duration Avg duration Feb 21 14 3 0ms 0ms 11 0ms 176 0ms 0ms 0ms with rar_max as ( select resultuid from relevance_keylevels_results order by resultuid desc limit ? ), kr as ( select a.*, rr.age, rr.relevant from keylevels_results a left outer join relevance_keylevels_results rr on a.resultuid = rr.resultuid where case when false = ? then true else a.resultuid > ( select min(resultuid) from relevance_keylevels_results) end ), all_results as ( select kr.resultuid as resultuid, kr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, p.patternname as pattern_name, kr.breakout as breakout, kr.atbaridentified as identified, dtt.timezone as timezone, kr.patternlengthbars as length, g.basegroupname, newlevels.filtered, case when kr.age is not null then kr.age when kr.resultuid <= rm.resultuid then ? else ? end as age, case when kr.relevant is not null then kr.relevant when kr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from kr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = kr.symbolid inner join symbols s on bsl.symbolid = s.symbolid and s.nonliquid = ? inner join symbolgroup sg on s.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join hrspatterns p on kr.patternid = p.patternid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join rar_max rm on ? = ? left outer join autochartist_symbolupdates au on dss.symbolid = au.symbolid left outer join relevance_keylevels_results rar on rar.resultuid = kr.resultuid left join lateral calc_kl_signal_filter (kr.resultuid) newlevels on true left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where kr.gmttimefound > now() - interval ? and dss.enabled = ? and s.deleted = ? and (kr.simulation = ? or kr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or p.patternname in (...)) and (? = ? or kr.patternclassid in (...)) and (? = ? or kr.patternlengthbars <= ?) and kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, ?::timestamp without time zone) -- to make sure patternstarttime is in our t-tables ), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Feb 21 14 176 0ms 0ms 12 0ms 237 0ms 0ms 0ms select count(*), sum(size), extract(epoch from now() - min(modification)) from pg_ls_waldir ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Feb 21 14 237 0ms 0ms 13 0ms 16 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 #13
Day Hour Count Duration Avg duration Feb 21 14 16 0ms 0ms 14 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 #14
Day Hour Count Duration Avg duration Feb 21 14 6 0ms 0ms 15 0ms 1 0ms 0ms 0ms select name, value from systemsettings limit ? offset ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Feb 21 14 1 0ms 0ms 16 0ms 11 0ms 0ms 0ms update executions set isrunning = false, has_results = false, response = ? where id = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Feb 21 14 11 0ms 0ms 17 0ms 237 0ms 0ms 0ms select system_identifier from pg_control_system ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Feb 21 14 237 0ms 0ms 18 0ms 237 0ms 0ms 0ms select datname, confl_tablespace, confl_lock, confl_snapshot, confl_bufferpin, confl_deadlock from pg_stat_database_conflicts where datname not ilike ? and datname not ilike ? and datname not ilike ? and datname not ilike ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Feb 21 14 237 0ms 0ms 19 0ms 2 0ms 0ms 0ms select t.pricedatetime as pricedatetime, t.open as open, t.high as high, t.low as low, t.close "..." close, t.volume as volume, t.bsf as bsf from t15 t where symbolid = ? and (bsf = ? or bsf is null) order by pricedatetime desc limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Feb 21 14 2 0ms 0ms 20 0ms 127 0ms 0ms 0ms with rar_max as ( select resultuid from relevance_bigmovement_results order by resultuid desc limit ? ), all_results as ( select bmr.resultuid as resultuid, ? as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, bmr.patternendtime as identified, bmr.patternlengthbars, dtt.timezone as timezone, g.basegroupname, case when rbr.age is not null then rbr.age when bmr.resultuid <= rm.resultuid then ? else ? end as age, case when rbr.relevant is not null then rbr.relevant when bmr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from bigmovement_results bmr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = bmr.symbolid inner join symbols s on bmr.symbolid = s.symbolid and s.nonliquid = ? inner join downloadersymbolsettings dss on bmr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on bmr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join rar_max rm on ? = ? left outer join relevance_bigmovement_results rbr on rbr.resultuid = bmr.resultuid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where bmr.gmttimefound > now() - interval ? and s.deleted = ? and (bmr.simulation = ? or bmr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or bmr.patternlengthbars <= ?) ), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, interval desc;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Feb 21 14 127 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 6,461 0ms 0ms 0ms 0ms select ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Feb 21 14 6,461 0ms 0ms 2 4,211 0ms 0ms 0ms 0ms insert into executionlogs (executionid, status, message, details, detailtype) values (null, ?, ?, null, null);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Feb 21 14 4,211 0ms 0ms 3 3,635 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 #3
Day Hour Count Duration Avg duration Feb 21 14 3,635 0ms 0ms 4 3,270 0ms 0ms 0ms 0ms select datid, datname, pid, usesysid, usename, application_name, client_addr, client_hostname, client_port, backend_start, xact_start, query_start, state_change, wait_event_type, wait_event, state, backend_xid, backend_xmin, query, backend_type from pg_stat_activity where backend_type != ? or (coalesce(trim(query), ?) != ? and pid != pg_backend_pid() and query_start is not null and datname not ilike ? and datname not ilike ? and datname not ilike ? and datname not ilike ? and not (query_start < ?::timestamptz and state = ?));Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Feb 21 14 3,270 0ms 0ms 5 2,980 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 #5
Day Hour Count Duration Avg duration Feb 21 14 2,980 0ms 0ms 6 2,807 0ms 0ms 0ms 0ms insert into t15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Feb 21 14 2,807 0ms 0ms 7 2,440 0ms 0ms 0ms 0ms insert into t30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Feb 21 14 2,440 0ms 0ms 8 2,410 0ms 0ms 0ms 0ms insert into t60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Feb 21 14 2,410 0ms 0ms 9 1,185 0ms 0ms 0ms 0ms select relname, schemaname, heap_blks_read, heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read, toast_blks_hit, tidx_blks_read, tidx_blks_hit from pg_statio_user_tables where ((relname ~ ?));Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Feb 21 14 1,185 0ms 0ms 10 1,185 0ms 0ms 0ms 0ms select relname, schemaname, indexrelname, idx_scan, idx_tup_read, idx_tup_fetch, pg_relation_size(indexrelid) as index_size from pg_stat_user_indexes where ((relname ~ ?));Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Feb 21 14 1,185 0ms 0ms 11 1,185 0ms 0ms 0ms 0ms select n.nspname as schemaname, count(*) from ( select c.relnamespace from pg_class c where c.relkind in (...)) as subquery left join pg_namespace n on (n.oid = relnamespace) where n.nspname not in (...) group by n.nspname;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Feb 21 14 1,185 0ms 0ms 12 1,185 0ms 0ms 0ms 0ms select current_database(), s.schemaname, s.table, s.partition_of, s.relpages, s.reltuples, s.relallvisible, s.relation_size + s.toast_size, s.relation_size, s.index_size, s.toast_size, s.relation_size + s.index_size + s.toast_size from ( select n.nspname as schemaname, relname as table, i.inhparent::regclass as partition_of, c.relpages, c.reltuples, c.relallvisible, pg_relation_size(c.oid) as relation_size, case when c.relhasindex then pg_indexes_size(c.oid) else ? end as index_size, case when c.reltoastrelid > ? then pg_relation_size(c.reltoastrelid) else ? end as toast_size from pg_class c left join pg_namespace n on (n.oid = c.relnamespace) left join pg_inherits i on (i.inhrelid = c.oid) left join pg_locks l on c.oid = l.relation and l.locktype = ? where not (nspname = any (?)) and (l.relation is null or l.mode <> ? or not l.granted) and relkind = ? and ((relname ~ ?)) limit ?) as s;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Feb 21 14 1,185 0ms 0ms 13 1,185 0ms 0ms 0ms 0ms select mode, locktype, pn.nspname, pd.datname, pc.relname, granted, fastpath, count(*) as lock_count from pg_locks l join pg_database pd on (l.database = pd.oid) join pg_class pc on (l.relation = pc.oid) left join pg_namespace pn on (pn.oid = pc.relnamespace) where ((relname ~ ?)) and l.mode is not null and pc.relname not like ? escape ? group by pd.datname, pc.relname, pn.nspname, locktype, mode, granted, fastpath;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Feb 21 14 1,185 0ms 0ms 14 1,185 0ms 0ms 0ms 0ms select relname, schemaname, seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd, n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup, vacuum_count, autovacuum_count, analyze_count, autoanalyze_count, extract(epoch from age(current_timestamp, last_vacuum)), extract(epoch from age(current_timestamp, last_autovacuum)), extract(epoch from age(current_timestamp, last_analyze)), extract(epoch from age(current_timestamp, last_autoanalyze)) from pg_stat_user_tables where ((relname ~ ?));Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Feb 21 14 1,185 0ms 0ms 15 1,065 0ms 0ms 0ms 0ms set extra_float_digits = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Feb 21 14 1,065 0ms 0ms 16 1,053 0ms 0ms 0ms 0ms set application_name = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Feb 21 14 1,053 0ms 0ms 17 975 0ms 0ms 0ms 0ms select datetimeupdate from latest_candle_datetime_per_receng where recognitionengine ilike ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Feb 21 14 975 0ms 0ms 18 608 0ms 0ms 0ms 0ms select symbolid, pricedatetime, classname, downloadfrequency, downloadersymbol, open, high, low, close, volume, bsf, sastdatetimereceived from ( select pricedatetime, dss.classname, dss.downloadfrequency, dss.symbolid, dss.downloadersymbol, t.open, t.high, t.low, t.close, t.volume, t.bsf, t.sastdatetimereceived, row_number() over (partition by t.symbolid order by t.pricedatetime desc) as rn from t15 t, downloadersymbolsettings dss, symbols s where dss.classname = ? and dss.downloadfrequency = ? and dss.symbolid = t.symbolid and s.symbolid = dss.symbolid and dss.enabled = ? and s.deleted = ? and dss.downloadersymbol in (...) and t.pricedatetime > now() - interval ?) as ranked_candles_table where rn = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Feb 21 14 608 0ms 0ms 19 416 0ms 0ms 0ms 0ms insert into authenticationlog (username, password, brokerid, authclass, attemptdatetime, success, fingerprint, accounttype) values (?, ?, ?, ?, current_timestamp, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Feb 21 14 416 0ms 0ms 20 356 0ms 0ms 0ms 0ms select count(*) from pg_stat_statements (false);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Feb 21 14 356 0ms 0ms Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 0ms 0ms 0ms 11 0ms select key, value from datasources ds inner join datasourceparams dsp on ds.id = dsp.datasourceid where ds.name = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Feb 21 14 11 0ms 0ms 2 0ms 0ms 0ms 127 0ms with rar_max as ( select resultuid from relevance_consecutivecandles_results order by resultuid desc limit ? ), all_results as ( select ccr.resultuid as resultuid, ccr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, ccr.patternendtime as identified, dtt.timezone as timezone, ccr.qtyconsecutivecandles as length, g.basegroupname, case when rcr.age is not null then rcr.age when ccr.resultuid <= rm.resultuid then ? else ? end as age, case when rcr.relevant is not null then rcr.relevant when ccr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip, newlevels.filtered from consecutivecandles_results ccr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = ccr.symbolid inner join symbols s on ccr.symbolid = s.symbolid and s.nonliquid = ? inner join downloadersymbolsettings dss on ccr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on ccr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join rar_max rm on ? = ? left outer join relevance_consecutivecandles_results rcr on rcr.resultuid = ccr.resultuid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? left join lateral calc_cc_signal_filter (ccr.resultuid) newlevels on true where ccr.gmttimefound > now() - interval ? and s.deleted = ? and (ccr.simulation = ? or ccr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ccr.patternlengthbars <= ?) ), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Feb 21 14 127 0ms 0ms 3 0ms 0ms 0ms 2,410 0ms insert into t60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Feb 21 14 2,410 0ms 0ms 4 0ms 0ms 0ms 17 0ms select case when a.old_resultuid = ? then a.old_resultuid else a.resultuid end as resultuid, s.symbol, timegranularity as interval, direction as direction, patternendtime as patternendtime, patternstartprice as psp, patternendprice as pep, target03 as t03, target16 as t16, patternlengthbars as length, p.patternname as patternname, dtt.timezone, cps.pip from fibonacci_results a inner join downloadersymbolsettings dss on a.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join fibonaccipatterns p on a.pattern = p.patternname left join currencypips cps on cps.symbol = s.symbol where (a.old_resultuid = ? or a.resultuid = ?) and dtt.dayofweek = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Feb 21 14 17 0ms 0ms 5 0ms 0ms 0ms 180 0ms update patternresultsrelevance set relevant = ?, saxo_relevant = ?, notrelevantpricedatetime = ?, reason = ? where uniqueindex = ? and relevant = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Feb 21 14 180 0ms 0ms 6 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 #6
Day Hour Count Duration Avg duration Feb 21 14 18 0ms 0ms 7 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 #7
Day Hour Count Duration Avg duration Feb 21 14 237 0ms 0ms 8 0ms 0ms 0ms 19 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 #8
Day Hour Count Duration Avg duration Feb 21 14 19 0ms 0ms 9 0ms 0ms 0ms 340 0ms commit;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Feb 21 14 340 0ms 0ms 10 0ms 0ms 0ms 3 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 #10
Day Hour Count Duration Avg duration Feb 21 14 3 0ms 0ms 11 0ms 0ms 0ms 176 0ms with rar_max as ( select resultuid from relevance_keylevels_results order by resultuid desc limit ? ), kr as ( select a.*, rr.age, rr.relevant from keylevels_results a left outer join relevance_keylevels_results rr on a.resultuid = rr.resultuid where case when false = ? then true else a.resultuid > ( select min(resultuid) from relevance_keylevels_results) end ), all_results as ( select kr.resultuid as resultuid, kr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, p.patternname as pattern_name, kr.breakout as breakout, kr.atbaridentified as identified, dtt.timezone as timezone, kr.patternlengthbars as length, g.basegroupname, newlevels.filtered, case when kr.age is not null then kr.age when kr.resultuid <= rm.resultuid then ? else ? end as age, case when kr.relevant is not null then kr.relevant when kr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from kr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = kr.symbolid inner join symbols s on bsl.symbolid = s.symbolid and s.nonliquid = ? inner join symbolgroup sg on s.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join hrspatterns p on kr.patternid = p.patternid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join rar_max rm on ? = ? left outer join autochartist_symbolupdates au on dss.symbolid = au.symbolid left outer join relevance_keylevels_results rar on rar.resultuid = kr.resultuid left join lateral calc_kl_signal_filter (kr.resultuid) newlevels on true left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where kr.gmttimefound > now() - interval ? and dss.enabled = ? and s.deleted = ? and (kr.simulation = ? or kr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or p.patternname in (...)) and (? = ? or kr.patternclassid in (...)) and (? = ? or kr.patternlengthbars <= ?) and kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, ?::timestamp without time zone) -- to make sure patternstarttime is in our t-tables ), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Feb 21 14 176 0ms 0ms 12 0ms 0ms 0ms 237 0ms select count(*), sum(size), extract(epoch from now() - min(modification)) from pg_ls_waldir ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Feb 21 14 237 0ms 0ms 13 0ms 0ms 0ms 16 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 #13
Day Hour Count Duration Avg duration Feb 21 14 16 0ms 0ms 14 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 #14
Day Hour Count Duration Avg duration Feb 21 14 6 0ms 0ms 15 0ms 0ms 0ms 1 0ms select name, value from systemsettings limit ? offset ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Feb 21 14 1 0ms 0ms 16 0ms 0ms 0ms 11 0ms update executions set isrunning = false, has_results = false, response = ? where id = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Feb 21 14 11 0ms 0ms 17 0ms 0ms 0ms 237 0ms select system_identifier from pg_control_system ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Feb 21 14 237 0ms 0ms 18 0ms 0ms 0ms 237 0ms select datname, confl_tablespace, confl_lock, confl_snapshot, confl_bufferpin, confl_deadlock from pg_stat_database_conflicts where datname not ilike ? and datname not ilike ? and datname not ilike ? and datname not ilike ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Feb 21 14 237 0ms 0ms 19 0ms 0ms 0ms 2 0ms select t.pricedatetime as pricedatetime, t.open as open, t.high as high, t.low as low, t.close "..." close, t.volume as volume, t.bsf as bsf from t15 t where symbolid = ? and (bsf = ? or bsf is null) order by pricedatetime desc limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Feb 21 14 2 0ms 0ms 20 0ms 0ms 0ms 127 0ms with rar_max as ( select resultuid from relevance_bigmovement_results order by resultuid desc limit ? ), all_results as ( select bmr.resultuid as resultuid, ? as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, bmr.patternendtime as identified, bmr.patternlengthbars, dtt.timezone as timezone, g.basegroupname, case when rbr.age is not null then rbr.age when bmr.resultuid <= rm.resultuid then ? else ? end as age, case when rbr.relevant is not null then rbr.relevant when bmr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from bigmovement_results bmr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = bmr.symbolid inner join symbols s on bmr.symbolid = s.symbolid and s.nonliquid = ? inner join downloadersymbolsettings dss on bmr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on bmr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join rar_max rm on ? = ? left outer join relevance_bigmovement_results rbr on rbr.resultuid = bmr.resultuid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where bmr.gmttimefound > now() - interval ? and s.deleted = ? and (bmr.simulation = ? or bmr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or bmr.patternlengthbars <= ?) ), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, interval desc;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Feb 21 14 127 0ms 0ms Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1s54ms 702 0ms 3ms 1ms SELECT symbolid, ;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Feb 21 14 702 1s54ms 1ms -
SELECT symbolid, ;
Date: 2026-02-21 14:48:01 Duration: 3ms Database: postgres
-
SELECT symbolid, ;
Date: 2026-02-21 14:36:02 Duration: 2ms Database: postgres
-
SELECT symbolid, ;
Date: 2026-02-21 14:01:03 Duration: 2ms Database: postgres
2 1s1ms 838 0ms 16ms 1ms WITH rar_max as ( ;Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 14 838 1s1ms 1ms -
WITH rar_max as ( ;
Date: 2026-02-21 14:01:06 Duration: 16ms Database: postgres
-
WITH rar_max as ( ;
Date: 2026-02-21 14:46:04 Duration: 8ms Database: postgres
-
WITH rar_max as ( ;
Date: 2026-02-21 14:12:24 Duration: 6ms Database: postgres
3 256ms 2,319 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 14 2,319 256ms 0ms -
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:11:43 Duration: 0ms Database: postgres
-
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:02:32 Duration: 0ms Database: postgres
-
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:02:40 Duration: 0ms Database: postgres
4 217ms 671 0ms 6ms 0ms SELECT ;Times Reported Time consuming prepare #4
Day Hour Count Duration Avg duration 14 671 217ms 0ms -
SELECT ;
Date: 2026-02-21 14:12:29 Duration: 6ms Database: postgres
-
SELECT ;
Date: 2026-02-21 14:32:50 Duration: 3ms Database: postgres
-
SELECT ;
Date: 2026-02-21 14:01:01 Duration: 3ms Database: postgres
5 215ms 2,413 0ms 2ms 0ms INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming prepare #5
Day Hour Count Duration Avg duration 14 2,413 215ms 0ms -
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:01:05 Duration: 2ms Database: postgres
-
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:41:06 Duration: 0ms Database: postgres
-
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:41:03 Duration: 0ms Database: postgres
6 158ms 1,065 0ms 2ms 0ms SET extra_float_digits = 3;Times Reported Time consuming prepare #6
Day Hour Count Duration Avg duration 14 1,065 158ms 0ms -
SET extra_float_digits = 3;
Date: 2026-02-21 14:45:57 Duration: 2ms Database: postgres
-
SET extra_float_digits = 3;
Date: 2026-02-21 14:30:59 Duration: 1ms Database: postgres
-
SET extra_float_digits = 3;
Date: 2026-02-21 14:46:04 Duration: 0ms Database: postgres
7 134ms 132 0ms 1ms 1ms SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;Times Reported Time consuming prepare #7
Day Hour Count Duration Avg duration 14 132 134ms 1ms -
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-02-21 14:31:02 Duration: 1ms Database: postgres
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-02-21 14:30:37 Duration: 1ms Database: postgres
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-02-21 14:31:00 Duration: 1ms Database: postgres
8 124ms 676 0ms 1ms 0ms INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming prepare #8
Day Hour Count Duration Avg duration 14 676 124ms 0ms -
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:00:44 Duration: 1ms Database: postgres
-
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:26: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-02-21 14:20:09 Duration: 0ms Database: postgres
9 40ms 18 1ms 2ms 2ms select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;Times Reported Time consuming prepare #9
Day Hour Count Duration Avg duration 14 18 40ms 2ms -
select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;
Date: 2026-02-21 14:01:12 Duration: 2ms Database: postgres
-
select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;
Date: 2026-02-21 14:27:47 Duration: 2ms Database: postgres
-
select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;
Date: 2026-02-21 14:11:04 Duration: 2ms Database: postgres
10 26ms 511 0ms 0ms 0ms select 1;Times Reported Time consuming prepare #10
Day Hour Count Duration Avg duration 14 511 26ms 0ms -
select 1;
Date: 2026-02-21 14:12:24 Duration: 0ms Database: postgres
-
select 1;
Date: 2026-02-21 14:12:24 Duration: 0ms Database: postgres
-
select 1;
Date: 2026-02-21 14:16:04 Duration: 0ms Database: postgres
11 15ms 6 2ms 3ms 2ms select client_addr, count(1) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by client_addr, setting having (client_addr is not null OR (client_addr is null and count(1) > (cast(setting as numeric) / 3 * 2))) order by count desc;Times Reported Time consuming prepare #11
Day Hour Count Duration Avg duration 14 6 15ms 2ms -
select client_addr, count(1) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by client_addr, setting having (client_addr is not null OR (client_addr is null and count(1) > (cast(setting as numeric) / 3 * 2))) order by count desc;
Date: 2026-02-21 14:50:04 Duration: 3ms Database: postgres
-
select client_addr, count(1) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by client_addr, setting having (client_addr is not null OR (client_addr is null and count(1) > (cast(setting as numeric) / 3 * 2))) order by count desc;
Date: 2026-02-21 14:20:04 Duration: 2ms Database: postgres
-
select client_addr, count(1) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by client_addr, setting having (client_addr is not null OR (client_addr is null and count(1) > (cast(setting as numeric) / 3 * 2))) order by count desc;
Date: 2026-02-21 14:30:04 Duration: 2ms Database: postgres
12 12ms 1,053 0ms 0ms 0ms SET application_name = 'PostgreSQL JDBC Driver';Times Reported Time consuming prepare #12
Day Hour Count Duration Avg duration 14 1,053 12ms 0ms -
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2026-02-21 14:12:24 Duration: 0ms Database: postgres
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2026-02-21 14:12:24 Duration: 0ms Database: postgres
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2026-02-21 14:31:05 Duration: 0ms Database: postgres
13 10ms 68 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 #13
Day Hour Count Duration Avg duration 14 68 10ms 0ms -
INSERT INTO T240 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:50:05 Duration: 0ms Database: postgres
-
INSERT INTO T240 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:06:06 Duration: 0ms Database: postgres
-
INSERT INTO T240 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:36:04 Duration: 0ms Database: postgres
14 7ms 36 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 #14
Day Hour Count Duration Avg duration 14 36 7ms 0ms -
INSERT INTO T1440_underlying (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:30:58 Duration: 0ms Database: postgres
-
INSERT INTO T1440_underlying (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:01:04 Duration: 0ms Database: postgres
-
INSERT INTO T1440_underlying (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:31:04 Duration: 0ms Database: postgres
15 2ms 2 1ms 1ms 1ms select * from datafeed_symbols where classname ilike 'ICMARKETS-AU-MT5' limit 5000;Times Reported Time consuming prepare #15
Day Hour Count Duration Avg duration 14 2 2ms 1ms -
select * from datafeed_symbols where classname ilike 'ICMARKETS-AU-MT5' limit 5000;
Date: 2026-02-21 14:37:49 Duration: 1ms Database: postgres
-
select * from datafeed_symbols where classname ilike 'ICMARKETS-AU-MT5' limit 5000;
Date: 2026-02-21 14:07:51 Duration: 1ms Database: postgres
16 0ms 1 0ms 0ms 0ms /*server.KeyLevelResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, symbol AS sym, longname, shortname, Exchange AS e, timegranularity AS tg, a.PatternID AS pid, a.direction AS d, a.patternprice as pp, atbaridentified AS pet, CASE WHEN (x9 != '') THEN x9 WHEN (x8 != '') THEN x8 WHEN (x7 != '') THEN x7 WHEN (x6 != '') THEN x6 WHEN (x5 != '') THEN x5 WHEN (x4 != '') THEN x4 WHEN (x3 != '') THEN x3 WHEN (x2 != '') THEN x2 END AS pst, PatternPrice AS patp, x0, x1, x2, CASE WHEN (x3 != '') THEN x3 ELSE '1900-01-01' END as x3, CASE WHEN (x4 != '') THEN x4 ELSE '1900-01-01' END as x4, CASE WHEN (x5 != '') THEN x5 ELSE '1900-01-01' END as x5, CASE WHEN (x6 != '') THEN x6 ELSE '1900-01-01' END as x6, CASE WHEN (x7 != '') THEN x7 ELSE '1900-01-01' END as x7, CASE WHEN (x8 != '') THEN x8 ELSE '1900-01-01' END as x8, CASE WHEN (x9 != '') THEN x9 ELSE '1900-01-01' END as x9, errorMargin as erm, breakoutprice as pE, breakoutbars as be, breakout, atbaridentified as atBar, PatternLengthBars AS l, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz, approachingtimestamp AS apt, approachingregion as apr, predictionpricefrom as ppf, predictionpriceto as ppt, predictiontimefrom as ptf, predictiontimebars as ptb FROM keylevels_results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid INNER JOIN hrspatterns p on a.patternid = p.patternid where resultuid = $1 and dtt.dayofweek = 3;Times Reported Time consuming prepare #16
Day Hour Count Duration Avg duration 14 1 0ms 0ms -
/*server.KeyLevelResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, symbol AS sym, longname, shortname, Exchange AS e, timegranularity AS tg, a.PatternID AS pid, a.direction AS d, a.patternprice as pp, atbaridentified AS pet, CASE WHEN (x9 != '') THEN x9 WHEN (x8 != '') THEN x8 WHEN (x7 != '') THEN x7 WHEN (x6 != '') THEN x6 WHEN (x5 != '') THEN x5 WHEN (x4 != '') THEN x4 WHEN (x3 != '') THEN x3 WHEN (x2 != '') THEN x2 END AS pst, PatternPrice AS patp, x0, x1, x2, CASE WHEN (x3 != '') THEN x3 ELSE '1900-01-01' END as x3, CASE WHEN (x4 != '') THEN x4 ELSE '1900-01-01' END as x4, CASE WHEN (x5 != '') THEN x5 ELSE '1900-01-01' END as x5, CASE WHEN (x6 != '') THEN x6 ELSE '1900-01-01' END as x6, CASE WHEN (x7 != '') THEN x7 ELSE '1900-01-01' END as x7, CASE WHEN (x8 != '') THEN x8 ELSE '1900-01-01' END as x8, CASE WHEN (x9 != '') THEN x9 ELSE '1900-01-01' END as x9, errorMargin as erm, breakoutprice as pE, breakoutbars as be, breakout, atbaridentified as atBar, PatternLengthBars AS l, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz, approachingtimestamp AS apt, approachingregion as apr, predictionpricefrom as ppf, predictionpriceto as ppt, predictiontimefrom as ptf, predictiontimebars as ptb FROM keylevels_results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid INNER JOIN hrspatterns p on a.patternid = p.patternid where resultuid = $1 and dtt.dayofweek = 3;
Date: 2026-02-21 14:52:20 Duration: 0ms Database: postgres
17 0ms 1 0ms 0ms 0ms select brokerid from processes where "uuid" = '0aff8a66-2dcc-405a-80b8-9bf344f698d2' limit 1000;Times Reported Time consuming prepare #17
Day Hour Count Duration Avg duration 14 1 0ms 0ms -
select brokerid from processes where "uuid" = '0aff8a66-2dcc-405a-80b8-9bf344f698d2' limit 1000;
Date: 2026-02-21 14:06:35 Duration: 0ms Database: postgres
18 0ms 1 0ms 0ms 0ms SELECT g.groupname, bg.defaultsearchname, g.groupid, bg.searchdirection FROM brokergroups bg INNER JOIN groups g on bg.groupid = g.groupid WHERE bg.brokerid = $1 AND isdefaultsearch = 1 ORDER BY defaultsearchorder, defaultsearchname, groupname;Times Reported Time consuming prepare #18
Day Hour Count Duration Avg duration 14 1 0ms 0ms -
SELECT g.groupname, bg.defaultsearchname, g.groupid, bg.searchdirection FROM brokergroups bg INNER JOIN groups g on bg.groupid = g.groupid WHERE bg.brokerid = $1 AND isdefaultsearch = 1 ORDER BY defaultsearchorder, defaultsearchname, groupname;
Date: 2026-02-21 14:38:11 Duration: 0ms Database: postgres
19 0ms 1 0ms 0ms 0ms SELECT COUNT(*) AS total_records FROM process_media_view WHERE "process_uuid" = '0aff8a66-2dcc-405a-80b8-9bf344f698d2' AND "resultdate" <= '2026-02-20 22:01:04+00:00';Times Reported Time consuming prepare #19
Day Hour Count Duration Avg duration 14 1 0ms 0ms -
SELECT COUNT(*) AS total_records FROM process_media_view WHERE "process_uuid" = '0aff8a66-2dcc-405a-80b8-9bf344f698d2' AND "resultdate" <= '2026-02-20 22:01:04+00:00';
Date: 2026-02-21 14:06:35 Duration: 0ms Database: postgres
20 0ms 1 0ms 0ms 0ms select distinct processresult_id, resultdate, media_id, title, shorttext, longtext, type, filename from process_media_view where "process_uuid" = '0aff8a66-2dcc-405a-80b8-9bf344f698d2' AND "resultdate" <= '2026-02-20 22:01:04+00:00' order by resultdate desc, media_id asc LIMIT 1000 OFFSET 0;Times Reported Time consuming prepare #20
Day Hour Count Duration Avg duration 14 1 0ms 0ms -
select distinct processresult_id, resultdate, media_id, title, shorttext, longtext, type, filename from process_media_view where "process_uuid" = '0aff8a66-2dcc-405a-80b8-9bf344f698d2' AND "resultdate" <= '2026-02-20 22:01:04+00:00' order by resultdate desc, media_id asc LIMIT 1000 OFFSET 0;
Date: 2026-02-21 14:06:35 Duration: 0ms Database: postgres
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 12s39ms 1,411 0ms 34ms 8ms WITH rar_max as ( ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Feb 21 14 1,411 12s39ms 8ms -
WITH rar_max as ( ;
Date: 2026-02-21 14:16:04 Duration: 34ms Database: postgres parameters: $1 = '627', $2 = '7', $3 = '15', $4 = '30', $5 = '60', $6 = '120', $7 = '240', $8 = '480', $9 = '1440', $10 = '0', $11 = '', $12 = '213', $13 = '#ADBE', $14 = '#ALVG', $15 = '#AMZN', $16 = '#APPL', $17 = '#BA', $18 = '#BABA', $19 = '#BAYGn', $20 = '#BMWG', $21 = '#BNPP', $22 = '#CAT', $23 = '#CBKG', $24 = '#DAIGn', $25 = '#DIS', $26 = '#EA', $27 = '#FB', $28 = '#FDX', $29 = '#GE', $30 = '#GM', $31 = '#GOOGL', $32 = '#GS', $33 = '#INTC', $34 = '#JPM', $35 = '#KO', $36 = '#META', $37 = '#MSFT', $38 = '#NFLX', $39 = '#TSLA', $40 = '#VOWG', $41 = '#WMT', $42 = '#XOM', $43 = 'AUDCAD', $44 = 'AUDCHF', $45 = 'AUDJPY', $46 = 'AUDNZD', $47 = 'AUDUSD', $48 = 'AUS_200', $49 = 'BTCEUR', $50 = 'BTCGBP', $51 = 'BTCUSD', $52 = 'CADCHF', $53 = 'CADJPY', $54 = 'CHFJPY', $55 = 'CL_BRENT', $56 = 'DASHUSD', $57 = 'EOSUSD', $58 = 'ESP_35', $59 = 'ETHEUR', $60 = 'ETHGBP', $61 = 'ETHUSD', $62 = 'EURAUD', $63 = 'EURCAD', $64 = 'EURCHF', $65 = 'EURGBP', $66 = 'EURJPY', $67 = 'EURMXN', $68 = 'EURNOK', $69 = 'EURNZD', $70 = 'EURPLN', $71 = 'EURSEK', $72 = 'EURTRY', $73 = 'EURUSD', $74 = 'EUR_50', $75 = 'FRA_40', $76 = 'GBPAUD', $77 = 'GBPCAD', $78 = 'GBPCHF', $79 = 'GBPJPY', $80 = 'GBPNZD', $81 = 'GBPUSD', $82 = 'GBPZAR', $83 = 'GBR_100', $84 = 'HKDJPY', $85 = 'HKG_50', $86 = 'IOTAUSD', $87 = 'LTCEUR', $88 = 'LTCUSD', $89 = 'NAS100', $90 = 'NEOUSD', $91 = 'NOKJPY', $92 = 'NZDCAD', $93 = 'NZDCHF', $94 = 'NZDJPY', $95 = 'NZDUSD', $96 = 'OMGUSD', $97 = 'SPX500', $98 = 'TRXUSD', $99 = 'US30', $100 = 'USDCAD', $101 = 'USDCHF', $102 = 'USDCNH', $103 = 'USDDKK', $104 = 'USDJPY', $105 = 'USDMXN', $106 = 'USDNOK', $107 = 'USDPLN', $108 = 'USDSEK', $109 = 'USDSGD', $110 = 'USDZAR', $111 = 'USOIL', $112 = 'XAGUSD', $113 = 'XAUEUR', $114 = 'XAUUSD', $115 = 'XMRUSD', $116 = 'XPTUSD', $117 = 'XRPUSD', $118 = 'ZARJPY', $119 = 'ZECUSD', $120 = 'AUDCAD', $121 = 'AUDCHF', $122 = 'AUDJPY', $123 = 'AUDNZD', $124 = 'AUDUSD', $125 = 'CADCHF', $126 = 'CADJPY', $127 = 'CHFJPY', $128 = 'EURAUD', $129 = 'EURCAD', $130 = 'EURCHF', $131 = 'EURGBP', $132 = 'EURJPY', $133 = 'EURMXN', $134 = 'EURNOK', $135 = 'EURNZD', $136 = 'EURPLN', $137 = 'EURSEK', $138 = 'EURTRY', $139 = 'EURUSD', $140 = 'GBPAUD', $141 = 'GBPCAD', $142 = 'GBPCHF', $143 = 'GBPJPY', $144 = 'GBPNZD', $145 = 'GBPUSD', $146 = 'GBPZAR', $147 = 'HKDJPY', $148 = 'NOKJPY', $149 = 'NZDCAD', $150 = 'NZDCHF', $151 = 'NZDJPY', $152 = 'NZDUSD', $153 = 'USDCAD', $154 = 'USDCHF', $155 = 'USDCNH', $156 = 'USDDKK', $157 = 'USDJPY', $158 = 'USDMXN', $159 = 'USDNOK', $160 = 'USDPLN', $161 = 'USDSEK', $162 = 'USDSGD', $163 = 'USDZAR', $164 = 'ZARJPY', $165 = 'BTCEUR', $166 = 'BTCGBP', $167 = 'BTCUSD', $168 = 'DASHUSD', $169 = 'EOSUSD', $170 = 'ETHEUR', $171 = 'ETHGBP', $172 = 'ETHUSD', $173 = 'IOTAUSD', $174 = 'LTCEUR', $175 = 'LTCUSD', $176 = 'NEOUSD', $177 = 'OMGUSD', $178 = 'TRXUSD', $179 = 'XMRUSD', $180 = 'XRPUSD', $181 = 'ZECUSD', $182 = 'XAGUSD', $183 = 'XAUEUR', $184 = 'XAUUSD', $185 = 'XPTUSD', $186 = 'CL_BRENT', $187 = 'USOIL', $188 = '#ALVG', $189 = '#BAYGn', $190 = '#BMWG', $191 = '#BNPP', $192 = '#CBKG', $193 = '#DAIGn', $194 = '#VOWG', $195 = 'AUS_200', $196 = 'ESP_35', $197 = 'EUR_50', $198 = 'FRA_40', $199 = 'GBR_100', $200 = 'HKG_50', $201 = 'NAS100', $202 = 'SPX500', $203 = 'US30', $204 = '#ADBE', $205 = '#AMZN', $206 = '#APPL', $207 = '#BA', $208 = '#BABA', $209 = '#CAT', $210 = '#DIS', $211 = '#EA', $212 = '#FB', $213 = '#FDX', $214 = '#GE', $215 = '#GM', $216 = '#GOOGL', $217 = '#GS', $218 = '#INTC', $219 = '#JPM', $220 = '#KO', $221 = '#MSFT', $222 = '#NFLX', $223 = '#TSLA', $224 = '#WMT', $225 = '#XOM', $226 = '500', $227 = '500', $228 = 't', $229 = '10', $230 = '10'
-
WITH rar_max as ( ;
Date: 2026-02-21 14:31:05 Duration: 32ms Database: postgres parameters: $1 = '627', $2 = '7', $3 = '15', $4 = '30', $5 = '60', $6 = '120', $7 = '240', $8 = '480', $9 = '1440', $10 = '0', $11 = '', $12 = '213', $13 = '#ADBE', $14 = '#ALVG', $15 = '#AMZN', $16 = '#APPL', $17 = '#BA', $18 = '#BABA', $19 = '#BAYGn', $20 = '#BMWG', $21 = '#BNPP', $22 = '#CAT', $23 = '#CBKG', $24 = '#DAIGn', $25 = '#DIS', $26 = '#EA', $27 = '#FB', $28 = '#FDX', $29 = '#GE', $30 = '#GM', $31 = '#GOOGL', $32 = '#GS', $33 = '#INTC', $34 = '#JPM', $35 = '#KO', $36 = '#META', $37 = '#MSFT', $38 = '#NFLX', $39 = '#TSLA', $40 = '#VOWG', $41 = '#WMT', $42 = '#XOM', $43 = 'AUDCAD', $44 = 'AUDCHF', $45 = 'AUDJPY', $46 = 'AUDNZD', $47 = 'AUDUSD', $48 = 'AUS_200', $49 = 'BTCEUR', $50 = 'BTCGBP', $51 = 'BTCUSD', $52 = 'CADCHF', $53 = 'CADJPY', $54 = 'CHFJPY', $55 = 'CL_BRENT', $56 = 'DASHUSD', $57 = 'EOSUSD', $58 = 'ESP_35', $59 = 'ETHEUR', $60 = 'ETHGBP', $61 = 'ETHUSD', $62 = 'EURAUD', $63 = 'EURCAD', $64 = 'EURCHF', $65 = 'EURGBP', $66 = 'EURJPY', $67 = 'EURMXN', $68 = 'EURNOK', $69 = 'EURNZD', $70 = 'EURPLN', $71 = 'EURSEK', $72 = 'EURTRY', $73 = 'EURUSD', $74 = 'EUR_50', $75 = 'FRA_40', $76 = 'GBPAUD', $77 = 'GBPCAD', $78 = 'GBPCHF', $79 = 'GBPJPY', $80 = 'GBPNZD', $81 = 'GBPUSD', $82 = 'GBPZAR', $83 = 'GBR_100', $84 = 'HKDJPY', $85 = 'HKG_50', $86 = 'IOTAUSD', $87 = 'LTCEUR', $88 = 'LTCUSD', $89 = 'NAS100', $90 = 'NEOUSD', $91 = 'NOKJPY', $92 = 'NZDCAD', $93 = 'NZDCHF', $94 = 'NZDJPY', $95 = 'NZDUSD', $96 = 'OMGUSD', $97 = 'SPX500', $98 = 'TRXUSD', $99 = 'US30', $100 = 'USDCAD', $101 = 'USDCHF', $102 = 'USDCNH', $103 = 'USDDKK', $104 = 'USDJPY', $105 = 'USDMXN', $106 = 'USDNOK', $107 = 'USDPLN', $108 = 'USDSEK', $109 = 'USDSGD', $110 = 'USDZAR', $111 = 'USOIL', $112 = 'XAGUSD', $113 = 'XAUEUR', $114 = 'XAUUSD', $115 = 'XMRUSD', $116 = 'XPTUSD', $117 = 'XRPUSD', $118 = 'ZARJPY', $119 = 'ZECUSD', $120 = 'AUDCAD', $121 = 'AUDCHF', $122 = 'AUDJPY', $123 = 'AUDNZD', $124 = 'AUDUSD', $125 = 'CADCHF', $126 = 'CADJPY', $127 = 'CHFJPY', $128 = 'EURAUD', $129 = 'EURCAD', $130 = 'EURCHF', $131 = 'EURGBP', $132 = 'EURJPY', $133 = 'EURMXN', $134 = 'EURNOK', $135 = 'EURNZD', $136 = 'EURPLN', $137 = 'EURSEK', $138 = 'EURTRY', $139 = 'EURUSD', $140 = 'GBPAUD', $141 = 'GBPCAD', $142 = 'GBPCHF', $143 = 'GBPJPY', $144 = 'GBPNZD', $145 = 'GBPUSD', $146 = 'GBPZAR', $147 = 'HKDJPY', $148 = 'NOKJPY', $149 = 'NZDCAD', $150 = 'NZDCHF', $151 = 'NZDJPY', $152 = 'NZDUSD', $153 = 'USDCAD', $154 = 'USDCHF', $155 = 'USDCNH', $156 = 'USDDKK', $157 = 'USDJPY', $158 = 'USDMXN', $159 = 'USDNOK', $160 = 'USDPLN', $161 = 'USDSEK', $162 = 'USDSGD', $163 = 'USDZAR', $164 = 'ZARJPY', $165 = 'BTCEUR', $166 = 'BTCGBP', $167 = 'BTCUSD', $168 = 'DASHUSD', $169 = 'EOSUSD', $170 = 'ETHEUR', $171 = 'ETHGBP', $172 = 'ETHUSD', $173 = 'IOTAUSD', $174 = 'LTCEUR', $175 = 'LTCUSD', $176 = 'NEOUSD', $177 = 'OMGUSD', $178 = 'TRXUSD', $179 = 'XMRUSD', $180 = 'XRPUSD', $181 = 'ZECUSD', $182 = 'XAGUSD', $183 = 'XAUEUR', $184 = 'XAUUSD', $185 = 'XPTUSD', $186 = 'CL_BRENT', $187 = 'USOIL', $188 = '#ALVG', $189 = '#BAYGn', $190 = '#BMWG', $191 = '#BNPP', $192 = '#CBKG', $193 = '#DAIGn', $194 = '#VOWG', $195 = 'AUS_200', $196 = 'ESP_35', $197 = 'EUR_50', $198 = 'FRA_40', $199 = 'GBR_100', $200 = 'HKG_50', $201 = 'NAS100', $202 = 'SPX500', $203 = 'US30', $204 = '#ADBE', $205 = '#AMZN', $206 = '#APPL', $207 = '#BA', $208 = '#BABA', $209 = '#CAT', $210 = '#DIS', $211 = '#EA', $212 = '#FB', $213 = '#FDX', $214 = '#GE', $215 = '#GM', $216 = '#GOOGL', $217 = '#GS', $218 = '#INTC', $219 = '#JPM', $220 = '#KO', $221 = '#MSFT', $222 = '#NFLX', $223 = '#TSLA', $224 = '#WMT', $225 = '#XOM', $226 = '500', $227 = '500', $228 = 't', $229 = '10', $230 = '10'
-
WITH rar_max as ( ;
Date: 2026-02-21 14:20:58 Duration: 32ms Database: postgres parameters: $1 = 't', $2 = '558', $3 = '7', $4 = '15', $5 = '30', $6 = '60', $7 = '120', $8 = '240', $9 = '480', $10 = '1440', $11 = '0', $12 = '', $13 = '80', $14 = 'AUDSGD', $15 = 'CHFSGD', $16 = 'EURDKK', $17 = 'EURHKD', $18 = 'EURNOK', $19 = 'EURPLN', $20 = 'EURSEK', $21 = 'EURSGD', $22 = 'EURTRY', $23 = 'EURZAR', $24 = 'GBPDKK', $25 = 'GBPNOK', $26 = 'GBPSEK', $27 = 'GBPSGD', $28 = 'NOKJPY', $29 = 'NOKSEK', $30 = 'SEKJPY', $31 = 'SGDJPY', $32 = 'USDCNH', $33 = 'USDCZK', $34 = 'USDDKK', $35 = 'USDHKD', $36 = 'USDHUF', $37 = 'USDMXN', $38 = 'USDNOK', $39 = 'USDPLN', $40 = 'USDRUB', $41 = 'USDSEK', $42 = 'USDTHB', $43 = 'USDTRY', $44 = 'USDZAR', $45 = 'AUDUSD', $46 = 'EURUSD', $47 = 'GBPUSD', $48 = 'USDCAD', $49 = 'USDCHF', $50 = 'USDJPY', $51 = 'AUDCAD', $52 = 'AUDCHF', $53 = 'AUDJPY', $54 = 'AUDNZD', $55 = 'CADCHF', $56 = 'CADJPY', $57 = 'CHFJPY', $58 = 'EURAUD', $59 = 'EURCAD', $60 = 'EURCHF', $61 = 'EURGBP', $62 = 'EURJPY', $63 = 'EURNZD', $64 = 'GBPAUD', $65 = 'GBPCAD', $66 = 'GBPCHF', $67 = 'GBPJPY', $68 = 'GBPNZD', $69 = 'NZDCAD', $70 = 'NZDCHF', $71 = 'NZDJPY', $72 = 'NZDUSD', $73 = 'USDSGD', $74 = 'AUS200', $75 = 'DE30', $76 = 'ES35', $77 = 'F40', $78 = 'HK50', $79 = 'IT40', $80 = 'JP225', $81 = 'STOXX50', $82 = 'UK100', $83 = 'US2000', $84 = 'US30', $85 = 'US500', $86 = 'CHINA50', $87 = 'USTEC', $88 = 'XAGEUR', $89 = 'XAGUSD', $90 = 'XAUUSD', $91 = 'XAUEUR', $92 = 'XPDUSD', $93 = 'XPTUSD', $94 = '0', $95 = '', $96 = '0', $97 = '0', $98 = '0', $99 = '0', $100 = '0', $101 = 't', $102 = '10', $103 = '10'
2 2s368ms 7,271 0ms 7ms 0ms SELECT ;Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 14 7,271 2s368ms 0ms -
SELECT ;
Date: 2026-02-21 14:32:50 Duration: 7ms Database: postgres parameters: $1 = '667', $2 = '667', $3 = '500991628206777200'
-
SELECT ;
Date: 2026-02-21 14:30:16 Duration: 5ms Database: postgres parameters: $1 = '515840243198780300'
-
SELECT ;
Date: 2026-02-21 14:32:50 Duration: 4ms Database: postgres parameters: $1 = '667', $2 = '667', $3 = '500991628227617200'
3 1s752ms 702 1ms 5ms 2ms SELECT symbolid, ;Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 14 702 1s752ms 2ms -
SELECT symbolid, ;
Date: 2026-02-21 14:46:06 Duration: 5ms Database: postgres parameters: $1 = 'GLOBALGTMT5', $2 = '15', $3 = 'BTCUSD'
-
SELECT symbolid, ;
Date: 2026-02-21 14:36:02 Duration: 3ms Database: postgres parameters: $1 = 'MILLENNIUMPF', $2 = '15', $3 = 'NZDUSD', $4 = 'NZDCAD.FX', $5 = 'NASDAQ100', $6 = 'NZDUSD.ID', $7 = 'OIL', $8 = 'NZDJPY', $9 = 'NZDJPY.FX', $10 = 'NZDUSD.FX', $11 = 'NZDJPY.ID'
-
SELECT symbolid, ;
Date: 2026-02-21 14:35:55 Duration: 3ms Database: postgres parameters: $1 = 'MILLENNIUMPF', $2 = '15', $3 = 'EURCHF.FX', $4 = 'EURGBP', $5 = 'EURGBP.ID', $6 = 'EURJPY', $7 = 'EURJPY.FX', $8 = 'EURCAD.ID', $9 = 'EURGBP.FX', $10 = 'EURCHF.ID', $11 = 'EURCHF'
4 291ms 45 4ms 11ms 6ms WITH last_candle AS ( ;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 14 45 291ms 6ms -
WITH last_candle AS ( ;
Date: 2026-02-21 14:00:01 Duration: 11ms Database: postgres parameters: $1 = '667', $2 = '667'
-
WITH last_candle AS ( ;
Date: 2026-02-21 14:24:00 Duration: 9ms Database: postgres parameters: $1 = '558', $2 = '558'
-
WITH last_candle AS ( ;
Date: 2026-02-21 14:24:01 Duration: 9ms Database: postgres parameters: $1 = '667', $2 = '667'
5 212ms 132 1ms 2ms 1ms SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 14 132 212ms 1ms -
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-02-21 14:01:00 Duration: 2ms Database: postgres parameters: $1 = 'FPMARKETS'
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-02-21 14:00:44 Duration: 2ms Database: postgres parameters: $1 = 'AXIORY'
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-02-21 14:16:41 Duration: 2ms Database: postgres parameters: $1 = 'ICMARKETS'
6 198ms 2,410 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 14 2,410 198ms 0ms -
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:02:32 Duration: 0ms Database: postgres parameters: $1 = '2026-02-20 21:00:00', $2 = '115.25', $3 = '115.46', $4 = '114.91', $5 = '115.35', $6 = '2669', $7 = '515840247879403300', $8 = '0', $9 = '2026-02-21 14:02:32.265', $10 = '2026-02-21 14:02:32.2', $11 = '115.25', $12 = '115.46', $13 = '114.91', $14 = '115.35', $15 = '2669', $16 = '0', $17 = '2026-02-21 14:02:32.265', $18 = '2026-02-21 14:02:32.2'
-
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:11:43 Duration: 0ms Database: postgres parameters: $1 = '2026-02-20 20:00:00', $2 = '9069.4', $3 = '9092.4', $4 = '9062.6', $5 = '9088.05', $6 = '12608', $7 = '515840248015562300', $8 = '0', $9 = '2026-02-21 14:11:43.34', $10 = '2026-02-21 14:11:43.281', $11 = '9069.4', $12 = '9092.4', $13 = '9062.6', $14 = '9088.05', $15 = '12608', $16 = '0', $17 = '2026-02-21 14:11:43.34', $18 = '2026-02-21 14:11:43.281'
-
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:20:09 Duration: 0ms Database: postgres parameters: $1 = '2026-02-20 22:00:00', $2 = '5079.235', $3 = '5098.115', $4 = '5077.005', $5 = '5097.275', $6 = '15586', $7 = '515840230630393300', $8 = '0', $9 = '2026-02-21 14:20:09.183', $10 = '2026-02-21 14:20:09.182', $11 = '5079.235', $12 = '5098.115', $13 = '5077.005', $14 = '5097.275', $15 = '15586', $16 = '0', $17 = '2026-02-21 14:20:09.183', $18 = '2026-02-21 14:20:09.182'
7 174ms 2,440 0ms 0ms 0ms INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming bind #7
Day Hour Count Duration Avg duration 14 2,440 174ms 0ms -
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:42:02 Duration: 0ms Database: postgres parameters: $1 = '2026-02-20 18:00:00', $2 = '26772.3', $3 = '26786.8', $4 = '26722.3', $5 = '26764.5', $6 = '11131', $7 = '515840247933633300', $8 = '0', $9 = '2026-02-21 14:42:02.287', $10 = '2026-02-21 14:42:02.212', $11 = '26772.3', $12 = '26786.8', $13 = '26722.3', $14 = '26764.5', $15 = '11131', $16 = '0', $17 = '2026-02-21 14:42:02.287', $18 = '2026-02-21 14:42:02.212'
-
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:41:06 Duration: 0ms Database: postgres parameters: $1 = '2026-02-20 23:00:00', $2 = '49631.05', $3 = '49655.55', $4 = '49612.55', $5 = '49621.05', $6 = '5610', $7 = '515840248000726300', $8 = '0', $9 = '2026-02-21 14:41:06.005', $10 = '2026-02-21 14:41:05.911', $11 = '49631.05', $12 = '49655.55', $13 = '49612.55', $14 = '49621.05', $15 = '5610', $16 = '0', $17 = '2026-02-21 14:41:06.005', $18 = '2026-02-21 14:41:05.911'
-
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:41:03 Duration: 0ms Database: postgres parameters: $1 = '2026-02-20 23:00:00', $2 = '25019.53', $3 = '25023.4', $4 = '25002.15', $5 = '25007.28', $6 = '6068', $7 = '515840248039147300', $8 = '0', $9 = '2026-02-21 14:41:03.972', $10 = '2026-02-21 14:41:03.885', $11 = '25019.53', $12 = '25023.4', $13 = '25002.15', $14 = '25007.28', $15 = '6068', $16 = '0', $17 = '2026-02-21 14:41:03.972', $18 = '2026-02-21 14:41:03.885'
8 135ms 6,350 0ms 1ms 0ms select 1;Times Reported Time consuming bind #8
Day Hour Count Duration Avg duration 14 6,350 135ms 0ms -
select 1;
Date: 2026-02-21 14:06:19 Duration: 1ms Database: postgres
-
select 1;
Date: 2026-02-21 14:51:51 Duration: 1ms Database: postgres
-
select 1;
Date: 2026-02-21 14:05:41 Duration: 1ms Database: postgres
9 127ms 2,807 0ms 0ms 0ms INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming bind #9
Day Hour Count Duration Avg duration 14 2,807 127ms 0ms -
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:56:06 Duration: 0ms Database: postgres parameters: $1 = '2026-02-20 23:15:00', $2 = '49628.55', $3 = '49631.55', $4 = '49612.55', $5 = '49621.05', $6 = '2004', $7 = '515840248000537300', $8 = '0', $9 = '2026-02-21 14:56:06.145', $10 = '2026-02-21 14:56:06.077', $11 = '49628.55', $12 = '49631.55', $13 = '49612.55', $14 = '49621.05', $15 = '2004', $16 = '0', $17 = '2026-02-21 14:56:06.145', $18 = '2026-02-21 14:56:06.077'
-
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:41:03 Duration: 0ms Database: postgres parameters: $1 = '2026-02-20 23:15:00', $2 = '25006.15', $3 = '25009.78', $4 = '25002.15', $5 = '25007.28', $6 = '2174', $7 = '515840248038958300', $8 = '0', $9 = '2026-02-21 14:41:03.954', $10 = '2026-02-21 14:41:03.876', $11 = '25006.15', $12 = '25009.78', $13 = '25002.15', $14 = '25007.28', $15 = '2174', $16 = '0', $17 = '2026-02-21 14:41:03.954', $18 = '2026-02-21 14:41:03.876'
-
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:32:05 Duration: 0ms Database: postgres parameters: $1 = '2026-02-20 21:00:00', $2 = '46592.49', $3 = '46602.51', $4 = '46575.01', $5 = '46585.01', $6 = '358', $7 = '500991628285199200', $8 = '0', $9 = '2026-02-21 14:32:05.613', $10 = '2026-02-21 14:32:05.29', $11 = '46592.49', $12 = '46602.51', $13 = '46575.01', $14 = '46585.01', $15 = '358', $16 = '0', $17 = '2026-02-21 14:32:05.613', $18 = '2026-02-21 14:32:05.29'
10 76ms 15 0ms 24ms 5ms with wh_patitioned as ( ;Times Reported Time consuming bind #10
Day Hour Count Duration Avg duration 14 15 76ms 5ms -
with wh_patitioned as ( ;
Date: 2026-02-21 14:30:03 Duration: 24ms Database: postgres parameters: $1 = '558', $2 = '558', $3 = '558', $4 = '558', $5 = '558', $6 = '558', $7 = '558', $8 = '558', $9 = '558'
-
with wh_patitioned as ( ;
Date: 2026-02-21 14:25:02 Duration: 24ms Database: postgres parameters: $1 = '558', $2 = '558', $3 = '558', $4 = '558', $5 = '558', $6 = '558', $7 = '558', $8 = '558', $9 = '558'
-
with wh_patitioned as ( ;
Date: 2026-02-21 14:27:02 Duration: 22ms Database: postgres parameters: $1 = '558', $2 = '558', $3 = '558', $4 = '558', $5 = '558', $6 = '558', $7 = '558', $8 = '558', $9 = '558'
11 35ms 23 0ms 10ms 1ms WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;Times Reported Time consuming bind #11
Day Hour Count Duration Avg duration 14 23 35ms 1ms -
WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;
Date: 2026-02-21 14:21:41 Duration: 10ms Database: postgres parameters: $1 = '489', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'
-
WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;
Date: 2026-02-21 14:06:26 Duration: 10ms Database: postgres parameters: $1 = '489', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'
-
WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;
Date: 2026-02-21 14:51:58 Duration: 10ms Database: postgres parameters: $1 = '489', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'
12 16ms 55 0ms 4ms 0ms /*server.CPResult*/ SELECT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, symbol, longname, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, breakout, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM autochartist_results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join patterns p on p.patternname = a.pattern where resultuid = $1;Times Reported Time consuming bind #12
Day Hour Count Duration Avg duration 14 55 16ms 0ms -
/*server.CPResult*/ SELECT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, symbol, longname, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, breakout, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM autochartist_results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join patterns p on p.patternname = a.pattern where resultuid = $1;
Date: 2026-02-21 14:21:09 Duration: 4ms Database: postgres parameters: $1 = '607713937349505301'
-
/*server.CPResult*/ SELECT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, symbol, longname, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, breakout, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM autochartist_results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join patterns p on p.patternname = a.pattern where resultuid = $1;
Date: 2026-02-21 14:22:19 Duration: 3ms Database: postgres parameters: $1 = '607713760614899301'
-
/*server.CPResult*/ SELECT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, symbol, longname, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, breakout, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM autochartist_results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join patterns p on p.patternname = a.pattern where resultuid = $1;
Date: 2026-02-21 14:25:36 Duration: 2ms Database: postgres parameters: $1 = '607713876528419301'
13 12ms 18 0ms 0ms 0ms select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;Times Reported Time consuming bind #13
Day Hour Count Duration Avg duration 14 18 12ms 0ms -
select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;
Date: 2026-02-21 14:51:11 Duration: 0ms Database: postgres
-
select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;
Date: 2026-02-21 14:01:12 Duration: 0ms Database: postgres
-
select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;
Date: 2026-02-21 14:27:47 Duration: 0ms Database: postgres
14 11ms 68 0ms 0ms 0ms INSERT INTO T240 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming bind #14
Day Hour Count Duration Avg duration 14 68 11ms 0ms -
INSERT INTO T240 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:50:05 Duration: 0ms Database: postgres parameters: $1 = '2026-02-20 16:00:00', $2 = '56755', $3 = '57270', $4 = '56660', $5 = '57060', $6 = '5989', $7 = '515840230561612300', $8 = '0', $9 = '2026-02-21 14:50:05.651', $10 = '2026-02-21 14:50:05.651', $11 = '56755', $12 = '57270', $13 = '56660', $14 = '57060', $15 = '5989', $16 = '0', $17 = '2026-02-21 14:50:05.651', $18 = '2026-02-21 14:50:05.651'
-
INSERT INTO T240 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:06:06 Duration: 0ms Database: postgres parameters: $1 = '2026-02-20 16:00:00', $2 = '56755', $3 = '57270', $4 = '56660', $5 = '57060', $6 = '5989', $7 = '515840230561612300', $8 = '0', $9 = '2026-02-21 14:06:06.163', $10 = '2026-02-21 14:06:06.162', $11 = '56755', $12 = '57270', $13 = '56660', $14 = '57060', $15 = '5989', $16 = '0', $17 = '2026-02-21 14:06:06.163', $18 = '2026-02-21 14:06:06.162'
-
INSERT INTO T240 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:30:58 Duration: 0ms Database: postgres parameters: $1 = '2026-02-20 20:00:00', $2 = '209.235', $3 = '211.155', $4 = '206.87', $5 = '210.225', $6 = '8145', $7 = '515840249387582300', $8 = '0', $9 = '2026-02-21 14:30:58.147', $10 = '2026-02-21 14:30:58.068', $11 = '209.235', $12 = '211.155', $13 = '206.87', $14 = '210.225', $15 = '8145', $16 = '0', $17 = '2026-02-21 14:30:58.147', $18 = '2026-02-21 14:30:58.068'
15 10ms 22 0ms 3ms 0ms /*server.FibonacciResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, symbol AS sym, Exchange AS e, longname as lo, shortname as sho, timegranularity AS tg, p.PatternID AS pid, Direction AS d, PatternStartTime AS pst, PatternEndTime AS pet, PatternStartPrice AS psp, PatternEndPrice AS pep, priceX as px, timeX as tx, priceA as pa, timeA as ta, priceB as pb, timeB as tb, priceC as pc, timeC as tc, priceD as pd, timeD as td, averagequality as aq, timequality as tq, 1 - errormargin as rq, 1 - noise as c, target10 as t10, target06 as t06, target16 as t16, target07 as t07, target12 as t12, target03 as t03, target05 as t05, PatternLengthBars AS l, temporarypattern as tp, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM Fibonacci_Results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid INNER JOIN fibonaccipatterns p on a.pattern = p.patternname where resultuid = $1 and dtt.dayofweek = 3;Times Reported Time consuming bind #15
Day Hour Count Duration Avg duration 14 22 10ms 0ms -
/*server.FibonacciResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, symbol AS sym, Exchange AS e, longname as lo, shortname as sho, timegranularity AS tg, p.PatternID AS pid, Direction AS d, PatternStartTime AS pst, PatternEndTime AS pet, PatternStartPrice AS psp, PatternEndPrice AS pep, priceX as px, timeX as tx, priceA as pa, timeA as ta, priceB as pb, timeB as tb, priceC as pc, timeC as tc, priceD as pd, timeD as td, averagequality as aq, timequality as tq, 1 - errormargin as rq, 1 - noise as c, target10 as t10, target06 as t06, target16 as t16, target07 as t07, target12 as t12, target03 as t03, target05 as t05, PatternLengthBars AS l, temporarypattern as tp, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM Fibonacci_Results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid INNER JOIN fibonaccipatterns p on a.pattern = p.patternname where resultuid = $1 and dtt.dayofweek = 3;
Date: 2026-02-21 14:52:57 Duration: 3ms Database: postgres parameters: $1 = '607713935342476302'
-
/*server.FibonacciResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, symbol AS sym, Exchange AS e, longname as lo, shortname as sho, timegranularity AS tg, p.PatternID AS pid, Direction AS d, PatternStartTime AS pst, PatternEndTime AS pet, PatternStartPrice AS psp, PatternEndPrice AS pep, priceX as px, timeX as tx, priceA as pa, timeA as ta, priceB as pb, timeB as tb, priceC as pc, timeC as tc, priceD as pd, timeD as td, averagequality as aq, timequality as tq, 1 - errormargin as rq, 1 - noise as c, target10 as t10, target06 as t06, target16 as t16, target07 as t07, target12 as t12, target03 as t03, target05 as t05, PatternLengthBars AS l, temporarypattern as tp, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM Fibonacci_Results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid INNER JOIN fibonaccipatterns p on a.pattern = p.patternname where resultuid = $1 and dtt.dayofweek = 3;
Date: 2026-02-21 14:19:41 Duration: 2ms Database: postgres parameters: $1 = '607713935342476302'
-
/*server.FibonacciResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, symbol AS sym, Exchange AS e, longname as lo, shortname as sho, timegranularity AS tg, p.PatternID AS pid, Direction AS d, PatternStartTime AS pst, PatternEndTime AS pet, PatternStartPrice AS psp, PatternEndPrice AS pep, priceX as px, timeX as tx, priceA as pa, timeA as ta, priceB as pb, timeB as tb, priceC as pc, timeC as tc, priceD as pd, timeD as td, averagequality as aq, timequality as tq, 1 - errormargin as rq, 1 - noise as c, target10 as t10, target06 as t06, target16 as t16, target07 as t07, target12 as t12, target03 as t03, target05 as t05, PatternLengthBars AS l, temporarypattern as tp, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM Fibonacci_Results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid INNER JOIN fibonaccipatterns p on a.pattern = p.patternname where resultuid = $1 and dtt.dayofweek = 3;
Date: 2026-02-21 14:22:20 Duration: 1ms Database: postgres parameters: $1 = '607713936806956302'
16 8ms 19 0ms 1ms 0ms /*server.KeyLevelResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, symbol AS sym, longname, shortname, Exchange AS e, timegranularity AS tg, a.PatternID AS pid, a.direction AS d, a.patternprice as pp, atbaridentified AS pet, CASE WHEN (x9 != '') THEN x9 WHEN (x8 != '') THEN x8 WHEN (x7 != '') THEN x7 WHEN (x6 != '') THEN x6 WHEN (x5 != '') THEN x5 WHEN (x4 != '') THEN x4 WHEN (x3 != '') THEN x3 WHEN (x2 != '') THEN x2 END AS pst, PatternPrice AS patp, x0, x1, x2, CASE WHEN (x3 != '') THEN x3 ELSE '1900-01-01' END as x3, CASE WHEN (x4 != '') THEN x4 ELSE '1900-01-01' END as x4, CASE WHEN (x5 != '') THEN x5 ELSE '1900-01-01' END as x5, CASE WHEN (x6 != '') THEN x6 ELSE '1900-01-01' END as x6, CASE WHEN (x7 != '') THEN x7 ELSE '1900-01-01' END as x7, CASE WHEN (x8 != '') THEN x8 ELSE '1900-01-01' END as x8, CASE WHEN (x9 != '') THEN x9 ELSE '1900-01-01' END as x9, errorMargin as erm, breakoutprice as pE, breakoutbars as be, breakout, atbaridentified as atBar, PatternLengthBars AS l, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz, approachingtimestamp AS apt, approachingregion as apr, predictionpricefrom as ppf, predictionpriceto as ppt, predictiontimefrom as ptf, predictiontimebars as ptb FROM keylevels_results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid INNER JOIN hrspatterns p on a.patternid = p.patternid where resultuid = $1 and dtt.dayofweek = 3;Times Reported Time consuming bind #16
Day Hour Count Duration Avg duration 14 19 8ms 0ms -
/*server.KeyLevelResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, symbol AS sym, longname, shortname, Exchange AS e, timegranularity AS tg, a.PatternID AS pid, a.direction AS d, a.patternprice as pp, atbaridentified AS pet, CASE WHEN (x9 != '') THEN x9 WHEN (x8 != '') THEN x8 WHEN (x7 != '') THEN x7 WHEN (x6 != '') THEN x6 WHEN (x5 != '') THEN x5 WHEN (x4 != '') THEN x4 WHEN (x3 != '') THEN x3 WHEN (x2 != '') THEN x2 END AS pst, PatternPrice AS patp, x0, x1, x2, CASE WHEN (x3 != '') THEN x3 ELSE '1900-01-01' END as x3, CASE WHEN (x4 != '') THEN x4 ELSE '1900-01-01' END as x4, CASE WHEN (x5 != '') THEN x5 ELSE '1900-01-01' END as x5, CASE WHEN (x6 != '') THEN x6 ELSE '1900-01-01' END as x6, CASE WHEN (x7 != '') THEN x7 ELSE '1900-01-01' END as x7, CASE WHEN (x8 != '') THEN x8 ELSE '1900-01-01' END as x8, CASE WHEN (x9 != '') THEN x9 ELSE '1900-01-01' END as x9, errorMargin as erm, breakoutprice as pE, breakoutbars as be, breakout, atbaridentified as atBar, PatternLengthBars AS l, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz, approachingtimestamp AS apt, approachingregion as apr, predictionpricefrom as ppf, predictionpriceto as ppt, predictiontimefrom as ptf, predictiontimebars as ptb FROM keylevels_results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid INNER JOIN hrspatterns p on a.patternid = p.patternid where resultuid = $1 and dtt.dayofweek = 3;
Date: 2026-02-21 14:52:20 Duration: 1ms Database: postgres parameters: $1 = '600687905493217303'
-
/*server.KeyLevelResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, symbol AS sym, longname, shortname, Exchange AS e, timegranularity AS tg, a.PatternID AS pid, a.direction AS d, a.patternprice as pp, atbaridentified AS pet, CASE WHEN (x9 != '') THEN x9 WHEN (x8 != '') THEN x8 WHEN (x7 != '') THEN x7 WHEN (x6 != '') THEN x6 WHEN (x5 != '') THEN x5 WHEN (x4 != '') THEN x4 WHEN (x3 != '') THEN x3 WHEN (x2 != '') THEN x2 END AS pst, PatternPrice AS patp, x0, x1, x2, CASE WHEN (x3 != '') THEN x3 ELSE '1900-01-01' END as x3, CASE WHEN (x4 != '') THEN x4 ELSE '1900-01-01' END as x4, CASE WHEN (x5 != '') THEN x5 ELSE '1900-01-01' END as x5, CASE WHEN (x6 != '') THEN x6 ELSE '1900-01-01' END as x6, CASE WHEN (x7 != '') THEN x7 ELSE '1900-01-01' END as x7, CASE WHEN (x8 != '') THEN x8 ELSE '1900-01-01' END as x8, CASE WHEN (x9 != '') THEN x9 ELSE '1900-01-01' END as x9, errorMargin as erm, breakoutprice as pE, breakoutbars as be, breakout, atbaridentified as atBar, PatternLengthBars AS l, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz, approachingtimestamp AS apt, approachingregion as apr, predictionpricefrom as ppf, predictionpriceto as ppt, predictiontimefrom as ptf, predictiontimebars as ptb FROM keylevels_results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid INNER JOIN hrspatterns p on a.patternid = p.patternid where resultuid = $1 and dtt.dayofweek = 3;
Date: 2026-02-21 14:27:38 Duration: 1ms Database: postgres parameters: $1 = '607713055401158303'
-
/*server.KeyLevelResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, symbol AS sym, longname, shortname, Exchange AS e, timegranularity AS tg, a.PatternID AS pid, a.direction AS d, a.patternprice as pp, atbaridentified AS pet, CASE WHEN (x9 != '') THEN x9 WHEN (x8 != '') THEN x8 WHEN (x7 != '') THEN x7 WHEN (x6 != '') THEN x6 WHEN (x5 != '') THEN x5 WHEN (x4 != '') THEN x4 WHEN (x3 != '') THEN x3 WHEN (x2 != '') THEN x2 END AS pst, PatternPrice AS patp, x0, x1, x2, CASE WHEN (x3 != '') THEN x3 ELSE '1900-01-01' END as x3, CASE WHEN (x4 != '') THEN x4 ELSE '1900-01-01' END as x4, CASE WHEN (x5 != '') THEN x5 ELSE '1900-01-01' END as x5, CASE WHEN (x6 != '') THEN x6 ELSE '1900-01-01' END as x6, CASE WHEN (x7 != '') THEN x7 ELSE '1900-01-01' END as x7, CASE WHEN (x8 != '') THEN x8 ELSE '1900-01-01' END as x8, CASE WHEN (x9 != '') THEN x9 ELSE '1900-01-01' END as x9, errorMargin as erm, breakoutprice as pE, breakoutbars as be, breakout, atbaridentified as atBar, PatternLengthBars AS l, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz, approachingtimestamp AS apt, approachingregion as apr, predictionpricefrom as ppf, predictionpriceto as ppt, predictiontimefrom as ptf, predictiontimebars as ptb FROM keylevels_results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid INNER JOIN hrspatterns p on a.patternid = p.patternid where resultuid = $1 and dtt.dayofweek = 3;
Date: 2026-02-21 14:02:45 Duration: 1ms Database: postgres parameters: $1 = '607713764165735303'
17 8ms 36 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 #17
Day Hour Count Duration Avg duration 14 36 8ms 0ms -
INSERT INTO T1440_underlying (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:00:58 Duration: 0ms Database: postgres parameters: $1 = '2026-02-20 00:00:00', $2 = '204.88', $3 = '211.155', $4 = '203.82', $5 = '210.225', $6 = '13522', $7 = '515840249387738300', $8 = '0', $9 = '2026-02-21 14:00:58.242', $10 = '2026-02-21 14:00:58.241', $11 = '204.88', $12 = '211.155', $13 = '203.82', $14 = '210.225', $15 = '13522', $16 = '0', $17 = '2026-02-21 14:00:58.242', $18 = '2026-02-21 14:00:58.241'
-
INSERT INTO T1440_underlying (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:30:58 Duration: 0ms Database: postgres parameters: $1 = '2026-02-20 00:00:00', $2 = '204.88', $3 = '211.155', $4 = '203.82', $5 = '210.225', $6 = '13522', $7 = '515840249387738300', $8 = '0', $9 = '2026-02-21 14:30:58.127', $10 = '2026-02-21 14:30:58.126', $11 = '204.88', $12 = '211.155', $13 = '203.82', $14 = '210.225', $15 = '13522', $16 = '0', $17 = '2026-02-21 14:30:58.127', $18 = '2026-02-21 14:30:58.126'
-
INSERT INTO T1440_underlying (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-02-21 14:30:56 Duration: 0ms Database: postgres parameters: $1 = '2026-02-20 00:00:00', $2 = '259.095', $3 = '264.745', $4 = '258.28', $5 = '264.6', $6 = '13305', $7 = '515840249386902300', $8 = '0', $9 = '2026-02-21 14:30:56.024', $10 = '2026-02-21 14:30:56.023', $11 = '259.095', $12 = '264.745', $13 = '258.28', $14 = '264.6', $15 = '13305', $16 = '0', $17 = '2026-02-21 14:30:56.024', $18 = '2026-02-21 14:30:56.023'
18 7ms 55 0ms 0ms 0ms SELECT * FROM ( SELECT PriceDateTime, Open, High, Low, Close, Volume, BSF FROM T15 WHERE symbolid = $1 AND (BSF = 0 OR BSF IS NULL) ORDER BY PriceDateTime DESC LIMIT 1050) a ORDER BY PriceDateTime ASC;Times Reported Time consuming bind #18
Day Hour Count Duration Avg duration 14 55 7ms 0ms -
SELECT * FROM ( SELECT PriceDateTime, Open, High, Low, Close, Volume, BSF FROM T15 WHERE symbolid = $1 AND (BSF = 0 OR BSF IS NULL) ORDER BY PriceDateTime DESC LIMIT 1050) a ORDER BY PriceDateTime ASC;
Date: 2026-02-21 14:21:09 Duration: 0ms Database: postgres parameters: $1 = '515840243220334300'
-
SELECT * FROM ( SELECT PriceDateTime, Open, High, Low, Close, Volume, BSF FROM T15 WHERE symbolid = $1 AND (BSF = 0 OR BSF IS NULL) ORDER BY PriceDateTime DESC LIMIT 1050) a ORDER BY PriceDateTime ASC;
Date: 2026-02-21 14:22:19 Duration: 0ms Database: postgres parameters: $1 = '500991628208235200'
-
SELECT * FROM ( SELECT PriceDateTime, Open, High, Low, Close, Volume, BSF FROM T15 WHERE symbolid = $1 AND (BSF = 0 OR BSF IS NULL) ORDER BY PriceDateTime DESC LIMIT 1050) a ORDER BY PriceDateTime ASC;
Date: 2026-02-21 14:52:57 Duration: 0ms Database: postgres parameters: $1 = '515840243870885300'
19 6ms 2 3ms 3ms 3ms SELECT DISTINCT ON (basegroupname, symbol) ;Times Reported Time consuming bind #19
Day Hour Count Duration Avg duration 14 2 6ms 3ms -
SELECT DISTINCT ON (basegroupname, symbol) ;
Date: 2026-02-21 14:32:49 Duration: 3ms Database: postgres parameters: $1 = '667', $2 = '667'
-
SELECT DISTINCT ON (basegroupname, symbol) ;
Date: 2026-02-21 14:11:04 Duration: 3ms Database: postgres parameters: $1 = '627', $2 = '627'
20 6ms 416 0ms 0ms 0ms INSERT INTO authenticationlog (username, password, brokerid, authclass, attemptdatetime, success, fingerprint, accounttype) VALUES ($1, '',$2,$3, CURRENT_TIMESTAMP,1,'', $4);Times Reported Time consuming bind #20
Day Hour Count Duration Avg duration 14 416 6ms 0ms -
INSERT INTO authenticationlog (username, password, brokerid, authclass, attemptdatetime, success, fingerprint, accounttype) VALUES ($1, '',$2,$3, CURRENT_TIMESTAMP,1,'', $4);
Date: 2026-02-21 14:50:22 Duration: 0ms Database: postgres parameters: $1 = '54264048', $2 = '632', $3 = 'HotForexRealm', $4 = '1'
-
INSERT INTO authenticationlog (username, password, brokerid, authclass, attemptdatetime, success, fingerprint, accounttype) VALUES ($1, '',$2,$3, CURRENT_TIMESTAMP,1,'', $4);
Date: 2026-02-21 14:20:22 Duration: 0ms Database: postgres parameters: $1 = '54264048', $2 = '632', $3 = 'HotForexRealm', $4 = '1'
-
INSERT INTO authenticationlog (username, password, brokerid, authclass, attemptdatetime, success, fingerprint, accounttype) VALUES ($1, '',$2,$3, CURRENT_TIMESTAMP,1,'', $4);
Date: 2026-02-21 14:05:22 Duration: 0ms Database: postgres parameters: $1 = '54264048', $2 = '632', $3 = 'HotForexRealm', $4 = '1'
-
Events
Log levels
Key values
- 182,949 Log entries
Events distribution
Key values
- 0 PANIC entries
- 1 FATAL entries
- 393 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 356 Max number of times the same event was reported
- 394 Total events found
Rank Times reported Error 1 356 ERROR: pg_stat_statements must be loaded via shared_preload_libraries
Times Reported Most Frequent Error / Event #1
Day Hour Count Feb 21 14 356 - ERROR: pg_stat_statements must be loaded via shared_preload_libraries
Statement: /* service='datadog-agent' */ SELECT COUNT(*) FROM pg_stat_statements(false)
Date: 2026-02-21 14:00:04
2 36 ERROR: schema "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Feb 21 14 36 - ERROR: schema "datadog" does not exist at character 38
Statement: /* service='datadog-agent' */ SELECT datadog.explain_statement($stmt$SELECT * FROM pg_stat_activity$stmt$)
Date: 2026-02-21 14:00:52
3 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Feb 21 14 1 - ERROR: relation "t0" does not exist at character 83
Statement: SELECT * FROM ( SELECT PriceDateTime, Open, High, Low, Close, Volume, BSF FROM T0 WHERE symbolid = $1 AND (BSF = 0 OR BSF IS NULL) ORDER BY PriceDateTime DESC LIMIT 1050 ) a ORDER BY PriceDateTime ASC
Date: 2026-02-21 14:52:21
4 1 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Feb 21 14 1 - FATAL: database "acaweb_v" does not exist
Date: 2026-02-21 14:40:01 Database: acaweb_v Application: psql User: postgres Remote: