pgBadger-
Global information
- Generated on Sun Mar 1 09:59:18 2026
- Log file: /home/postgres/pg_data/data/pg_log/postgresql-2026-03-01_110000.log
- Parsed 492,499 log entries in 17s
- Log start from 2026-03-01 11:00:00 to 2026-03-01 11:59:16
-
Overview
Global Stats
- 190 Number of unique normalized queries
- 91,295 Number of queries
- 1h8m45s Total query duration
- 2026-03-01 11:00:00 First query
- 2026-03-01 11:59:16 Last query
- 950 queries/s at 2026-03-01 11:30:03 Query peak
- 1h8m45s Total query duration
- 2s513ms Prepare/parse total duration
- 14s316ms Bind total duration
- 1h8m28s Execute total duration
- 548 Number of events
- 4 Number of unique normalized events
- 356 Max number of times the same event was reported
- 0 Number of cancellation
- 31 Total number of automatic vacuums
- 41 Total number of automatic analyzes
- 451 Number temporary file
- 137.66 MiB Max size of temporary file
- 7.03 MiB Average size of temporary file
- 1,880 Total number of sessions
- 13 sessions at 2026-03-01 11:58:48 Session peak
- 14h2m20s Total duration of sessions
- 26s883ms Average duration of sessions
- 48 Average queries per session
- 2s194ms Average queries duration per session
- 24s689ms Average idle time per session
- 1,881 Total number of connections
- 28 connections/s at 2026-03-01 11:03:48 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 950 queries/s Query Peak
- 2026-03-01 11:30:03 Date
SELECT Traffic
Key values
- 472 queries/s Query Peak
- 2026-03-01 11:30:03 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 114 queries/s Query Peak
- 2026-03-01 11:38:49 Date
Queries duration
Key values
- 1h8m45s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 01 11 91,295 0ms 24s780ms 45ms 2m37s 2m42s 3m40s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 01 11 27,130 26 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 01 11 12,307 516 16 96 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Mar 01 11 9,320 19,535 2.10 21.63% Day Hour Count Average / Second Mar 01 11 1,881 0.52/s Day Hour Count Average Duration Average idle time Mar 01 11 1,880 26s883ms 24s697ms -
Connections
Established Connections
Key values
- 28 connections Connection Peak
- 2026-03-01 11:03:48 Date
Connections per database
Key values
- acaweb_fx Main Database
- 1,881 connections Total
Connections per user
Key values
- postgres Main User
- 1,881 connections Total
Connections per host
Key values
- 192.168.4.142 Main host with 801 connections
- 1,881 Total connections
-
Sessions
Simultaneous sessions
Key values
- 13 sessions Session Peak
- 2026-03-01 11:58:48 Date
Histogram of session times
Key values
- 1,497 0-500ms duration
Sessions per database
Key values
- acaweb_fx Main Database
- 1,880 sessions Total
Sessions per user
Key values
- postgres Main User
- 1,880 sessions Total
Sessions per host
Key values
- 192.168.4.142 Main Host
- 1,880 sessions Total
Host Count Total Duration Average Duration 127.0.0.1 102 2s601ms 25ms 192.168.0.114 3 33m55s 11m18s 192.168.0.216 116 7m5s 3s669ms 192.168.0.74 52 1h34m52s 1m49s 192.168.1.145 3 52ms 17ms 192.168.1.15 24 1h42m54s 4m17s 192.168.1.20 23 9h52m12s 25m44s 192.168.1.239 54 322ms 5ms 192.168.1.90 8 966ms 120ms 192.168.2.126 20 6s433ms 321ms 192.168.3.199 38 21s380ms 562ms 192.168.4.142 801 6m55s 518ms 192.168.4.33 69 39s339ms 570ms 192.168.4.98 330 13s393ms 40ms [local] 237 3m1s 764ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 2,802 buffers Checkpoint Peak
- 2026-03-01 11:09:18 Date
- 209.912 seconds Highest write time
- 0.005 seconds Sync time
Checkpoints Wal files
Key values
- 2 files Wal files usage Peak
- 2026-03-01 11:39:18 Date
Checkpoints distance
Key values
- 68.85 Mo Distance Peak
- 2026-03-01 11:09:18 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Mar 01 11 14,545 1,501.827s 0.026s 1,502.123s Day Hour Added Removed Recycled Synced files Longest sync Average sync Mar 01 11 0 0 11 1,131 0.003s 0s Day Hour Count Avg time (sec) Mar 01 11 0 0s Day Hour Mean distance Mean estimate Mar 01 11 15,480.83 kB 28,540.75 kB -
Temporary Files
Size of temporary files
Key values
- 104.33 MiB Temp Files size Peak
- 2026-03-01 11:47:17 Date
Number of temporary files
Key values
- 30 per second Temp Files Peak
- 2026-03-01 11:32:08 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Mar 01 11 451 3.10 GiB 7.03 MiB Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 60 228.46 MiB 3.41 MiB 4.20 MiB 3.81 MiB select resultuid from relevance_consecutivecandles_results order by resultuid desc limit ?), all_results as ( select ccr.resultuid as resultuid, ccr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, ccr.patternendtime as identified, dtt.timezone as timezone, ccr.qtyconsecutivecandles as length, g.basegroupname, case when rcr.age is not null then rcr.age when ccr.resultuid <= rm.resultuid then ? else ? end as age, case when rcr.relevant is not null then rcr.relevant when ccr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip, newlevels.filtered from consecutivecandles_results ccr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = ccr.symbolid inner join symbols s on ccr.symbolid = s.symbolid and s.nonliquid = ? inner join downloadersymbolsettings dss on ccr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on ccr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join rar_max rm on ? = ? left outer join relevance_consecutivecandles_results rcr on rcr.resultuid = ccr.resultuid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? left join lateral calc_cc_signal_filter (ccr.resultuid) newlevels on true where ccr.gmttimefound > now() - interval ? and s.deleted = ? and (ccr.simulation = ? or ccr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ccr.patternlengthbars <= ?)), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc;-
SELECT resultuid FROM relevance_consecutivecandles_results ORDER BY resultuid DESC LIMIT 1), all_results AS ( SELECT ccr.resultuid AS resultuid, ccr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, ccr.patternendtime AS identified, dtt.timezone AS timezone, ccr.qtyconsecutivecandles AS length, g.basegroupname, CASE WHEN rcr.age IS NOT NULL THEN rcr.age WHEN ccr.resultuid <= rm.resultuid THEN 1 ELSE 0 END as age, CASE WHEN rcr.relevant IS NOT NULL THEN rcr.relevant WHEN ccr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip, newLevels.filtered FROM consecutivecandles_results ccr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = ccr.symbolid INNER JOIN symbols s ON ccr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN downloadersymbolsettings dss ON ccr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on ccr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_consecutivecandles_results rcr ON rcr.resultuid = ccr.resultuid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' LEFT JOIN LATERAL calc_cc_signal_filter (ccr.resultuid) newLevels on true WHERE ccr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (ccr.simulation = 0 OR ccr.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3, $4, $5, $6, $7, $8, $9)) AND ($10 = 0 OR s.exchange in ($11)) AND ($12 = 0 OR coalesce(bim.code, s.symbol) in ($13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225)) AND ($226 = 0 OR ccr.patternlengthbars <= $227)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $228 OR relevant = 1) AND ($229 = 0 OR age <= $230) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;
Date: 2026-03-01 11:01:06 Duration: 0ms
2 60 242.81 MiB 4.03 MiB 4.06 MiB 4.05 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-03-01 11:00:47 Duration: 0ms
3 16 621.75 MiB 38.86 MiB 38.86 MiB 38.86 MiB update solr_relevance_old set new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total from ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total from whatshot_probability where type = ?) sub where result_uid = sub.resultuid;-
UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type = 'cp') sub WHERE result_uid = sub.resultuid;
Date: 2026-03-01 11:01:13 Duration: 0ms
4 16 1.16 GiB 74.51 MiB 74.51 MiB 74.51 MiB with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit ?) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then ? else ? end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then ? else ? end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike ? inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike ?) sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike ?; update solr_relevance_old set newrelevant = ? where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike ? and a.resultuid is null); update solr_relevance_old set new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total from ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total from whatshot_probability where type in (...)) sub where result_uid = sub.resultuid;-
with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;
Date: 2026-03-01 11:01:16 Duration: 0ms
5 4 550.64 MiB 137.66 MiB 137.66 MiB 137.66 MiB select updateresultsmaterializedview ();-
select updateresultsmaterializedview ();
Date: 2026-03-01 11:02:13 Duration: 0ms
6 4 333.58 MiB 83.39 MiB 83.40 MiB 83.39 MiB select updateageforrelevantresults ();-
select updateageforrelevantresults ();
Date: 2026-03-01 11:02:04 Duration: 0ms
Queries generating the largest temporary files
Rank Size Query 1 137.66 MiB select updateresultsmaterializedview ();[ Date: 2026-03-01 11:17:13 ]
2 137.66 MiB select updateresultsmaterializedview ();[ Date: 2026-03-01 11:02:13 ]
3 137.66 MiB select updateresultsmaterializedview ();[ Date: 2026-03-01 11:32:13 ]
4 137.66 MiB select updateresultsmaterializedview ();[ Date: 2026-03-01 11:47:13 ]
5 83.40 MiB select updateageforrelevantresults ();[ Date: 2026-03-01 11:02:04 ]
6 83.40 MiB select updateageforrelevantresults ();[ Date: 2026-03-01 11:32:04 ]
7 83.39 MiB select updateageforrelevantresults ();[ Date: 2026-03-01 11:17:04 ]
8 83.39 MiB select updateageforrelevantresults ();[ Date: 2026-03-01 11:47:04 ]
9 74.51 MiB with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;[ Date: 2026-03-01 11:01:16 ]
10 74.51 MiB with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;[ Date: 2026-03-01 11:03:15 ]
11 74.51 MiB with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;[ Date: 2026-03-01 11:05:16 ]
12 74.51 MiB with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;[ Date: 2026-03-01 11:11:15 ]
13 74.51 MiB with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;[ Date: 2026-03-01 11:16:15 ]
14 74.51 MiB with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;[ Date: 2026-03-01 11:18:15 ]
15 74.51 MiB with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;[ Date: 2026-03-01 11:20:16 ]
16 74.51 MiB with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;[ Date: 2026-03-01 11:26:15 ]
17 74.51 MiB with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;[ Date: 2026-03-01 11:31:15 ]
18 74.51 MiB with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;[ Date: 2026-03-01 11:33:15 ]
19 74.51 MiB with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;[ Date: 2026-03-01 11:35:15 ]
20 74.51 MiB with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;[ Date: 2026-03-01 11:41:15 ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Analyzes per table
Key values
- public.solr_relevance_old (16) Main table analyzed (database acaweb_fx)
- 41 analyzes Total
Table Number of analyzes acaweb_fx.public.solr_relevance_old 16 acaweb_fx.pg_catalog.pg_attribute 8 acaweb_fx.pg_catalog.pg_type 4 acaweb_fx.pg_catalog.pg_class 4 acaweb_fx.public.datafeeds_latestrun 3 acaweb_fx.pg_catalog.pg_depend 2 acaweb_fx.pg_catalog.pg_index 1 acaweb_fx.public.solr_imports 1 acaweb_fx.public.latest_t15_candle_view 1 acaweb_fx.public.latest_candle_datetime_per_receng 1 Total 41 Vacuums per table
Key values
- public.solr_relevance_old (16) Main table vacuumed on database acaweb_fx
- 31 vacuums Total
Index Buffer usage Skipped WAL usage Table Vacuums scans hits misses dirtied pins frozen records full page bytes acaweb_fx.public.solr_relevance_old 16 16 13,116 0 49 0 0 7,933 16 1,475,769 acaweb_fx.public.datafeeds_latestrun 3 0 369 0 4 0 0 37 5 33,630 acaweb_fx.pg_catalog.pg_attribute 3 3 3,377 0 369 0 201 1,072 364 2,158,181 acaweb_fx.pg_catalog.pg_type 2 2 403 0 24 0 0 150 24 134,967 acaweb_fx.pg_catalog.pg_class 2 2 1,104 0 123 0 0 273 121 603,143 acaweb_fx.pg_toast.pg_toast_2619 1 1 174 0 34 0 0 103 30 118,800 acaweb_fx.pg_catalog.pg_depend 1 1 559 0 73 0 59 188 70 362,230 acaweb_fx.public.latest_t15_candle_view 1 1 72 0 1 0 0 6 1 9,049 acaweb_fx.public.relevance_keylevels_results 1 1 3,399 0 319 0 96 719 310 1,489,055 acaweb_fx.public.relevance_fibonacci_results 1 1 1,131 0 64 0 47 176 57 269,375 Total 31 28 23,704 6,192 1,060 0 403 10,657 998 6,654,199 Tuples removed per table
Key values
- public.solr_relevance_old (8952) Main table with removed tuples on database acaweb_fx
- 17438 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain acaweb_fx.public.solr_relevance_old 16 16 8,952 99,945 0 0 3,251 acaweb_fx.pg_catalog.pg_attribute 3 3 5,116 32,146 0 17 782 acaweb_fx.pg_catalog.pg_depend 1 1 1,086 14,341 0 0 144 acaweb_fx.public.relevance_keylevels_results 1 1 802 13,026 0 0 279 acaweb_fx.pg_catalog.pg_type 2 2 751 2,896 0 0 88 acaweb_fx.pg_catalog.pg_class 2 2 250 3,300 0 0 300 acaweb_fx.public.relevance_fibonacci_results 1 1 182 1,488 0 0 102 acaweb_fx.public.datafeeds_latestrun 3 0 166 42 0 0 48 acaweb_fx.pg_toast.pg_toast_2619 1 1 75 164 0 0 51 acaweb_fx.public.latest_t15_candle_view 1 1 58 12 0 0 1 Total 31 28 17,438 167,360 0 17 5,046 Pages removed per table
Key values
- pg_catalog.pg_attribute (17) Main table with removed pages on database acaweb_fx
- 17 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed acaweb_fx.pg_catalog.pg_attribute 3 3 5116 17 acaweb_fx.pg_toast.pg_toast_2619 1 1 75 0 acaweb_fx.pg_catalog.pg_type 2 2 751 0 acaweb_fx.public.datafeeds_latestrun 3 0 166 0 acaweb_fx.pg_catalog.pg_depend 1 1 1086 0 acaweb_fx.public.latest_t15_candle_view 1 1 58 0 acaweb_fx.public.relevance_keylevels_results 1 1 802 0 acaweb_fx.public.solr_relevance_old 16 16 8952 0 acaweb_fx.pg_catalog.pg_class 2 2 250 0 acaweb_fx.public.relevance_fibonacci_results 1 1 182 0 Total 31 28 17,438 17 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Mar 01 11 31 41 - 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
- 27,130 Total read queries
- 15,966 Total write queries
Queries by database
Key values
- unknown Main database
- 90,346 Requests
- 1h8m28s (unknown)
- Main time consuming database
Database Request type Count Duration acaweb_fx Total 880 0ms copy from 80 0ms copy to 26 0ms cte 100 0ms ddl 16 0ms delete 16 0ms others 212 0ms select 65 0ms tcl 333 0ms update 32 0ms socialmedia Total 69 0ms select 69 0ms unknown Total 90,346 1h8m28s copy from 16 0ms cte 1,697 0ms insert 12,307 0ms others 2,537 0ms select 26,996 0ms tcl 859 0ms update 484 0ms Queries by user
Key values
- unknown Main user
- 90,346 Requests
User Request type Count Duration postgres Total 949 0ms copy from 80 0ms copy to 26 0ms cte 100 0ms ddl 16 0ms delete 16 0ms others 212 0ms select 134 0ms tcl 333 0ms update 32 0ms unknown Total 90,346 1h8m28s copy from 16 0ms cte 1,697 0ms insert 12,307 0ms others 2,537 0ms select 26,996 0ms tcl 859 0ms update 484 0ms Duration by user
Key values
- 1h8m28s (unknown) Main time consuming user
User Request type Count Duration postgres Total 949 0ms copy from 80 0ms copy to 26 0ms cte 100 0ms ddl 16 0ms delete 16 0ms others 212 0ms select 134 0ms tcl 333 0ms update 32 0ms unknown Total 90,346 1h8m28s copy from 16 0ms cte 1,697 0ms insert 12,307 0ms others 2,537 0ms select 26,996 0ms tcl 859 0ms update 484 0ms Queries by host
Key values
- unknown Main host
- 91,295 Requests
- 1h8m28s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 90,956 Requests
- 1h8m28s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-03-01 11:44:51 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 27,344 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 10 0ms 0ms 0ms select key, value from datasources ds inner join datasourceparams dsp on ds.id = dsp.datasourceid where ds.name = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 01 11 10 0ms 0ms 2 0ms 120 0ms 0ms 0ms with rar_max as ( select resultuid from relevance_consecutivecandles_results order by resultuid desc limit ? ), all_results as ( select ccr.resultuid as resultuid, ccr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, ccr.patternendtime as identified, dtt.timezone as timezone, ccr.qtyconsecutivecandles as length, g.basegroupname, case when rcr.age is not null then rcr.age when ccr.resultuid <= rm.resultuid then ? else ? end as age, case when rcr.relevant is not null then rcr.relevant when ccr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip, newlevels.filtered from consecutivecandles_results ccr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = ccr.symbolid inner join symbols s on ccr.symbolid = s.symbolid and s.nonliquid = ? inner join downloadersymbolsettings dss on ccr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on ccr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join rar_max rm on ? = ? left outer join relevance_consecutivecandles_results rcr on rcr.resultuid = ccr.resultuid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? left join lateral calc_cc_signal_filter (ccr.resultuid) newlevels on true where ccr.gmttimefound > now() - interval ? and s.deleted = ? and (ccr.simulation = ? or ccr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ccr.patternlengthbars <= ?) ), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 01 11 120 0ms 0ms 3 0ms 2,399 0ms 0ms 0ms insert into t60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 01 11 2,399 0ms 0ms 4 0ms 9 0ms 0ms 0ms select case when a.old_resultuid = ? then a.old_resultuid else a.resultuid end as resultuid, s.symbol, timegranularity as interval, direction as direction, patternendtime as patternendtime, patternstartprice as psp, patternendprice as pep, target03 as t03, target16 as t16, patternlengthbars as length, p.patternname as patternname, dtt.timezone, cps.pip from fibonacci_results a inner join downloadersymbolsettings dss on a.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join fibonaccipatterns p on a.pattern = p.patternname left join currencypips cps on cps.symbol = s.symbol where (a.old_resultuid = ? or a.resultuid = ?) and dtt.dayofweek = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 01 11 9 0ms 0ms 5 0ms 88 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 Mar 01 11 88 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 Mar 01 11 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 Mar 01 11 237 0ms 0ms 8 0ms 6 0ms 0ms 0ms select distinct s.statsid as statsid, sy.exchange as name from stats s inner join broker b on s.brokerid = b.brokerid inner join brokerconfig bc on b.brokerid = bc.brokerid inner join stats_symbols ss on s.statsid = ss.statsid inner join downloadersymbolsettings dss on ss.symbolid = dss.symbolid inner join symbols sy on dss.symbolid = sy.symbolid where dss.enabled = ? and s.brokerid is not null and b.brokerid = ? and s.groupingtype ilike ? and s.description ilike ? || b.name || ? and s.description ilike ? || sy.exchange || ? and s.description not ilike ? || ? || ? union all select distinct s.statsid as statsid, basegroupname as name from stats s inner join broker b on s.brokerid = b.brokerid inner join brokerconfig bc on b.brokerid = bc.brokerid inner join stats_symbols ss on s.statsid = ss.statsid inner join downloadersymbolsettings dss on ss.symbolid = dss.symbolid inner join symbolgroup sg on dss.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bg.brokerid = b.brokerid where dss.enabled = ? and s.brokerid is not null and b.brokerid = ? and s.groupingtype not ilike ? and s.description ilike ? || b.name || ? and s.description ilike ? || g.basegroupname || ? and s.description not ilike ? || ? || ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 01 11 6 0ms 0ms 9 0ms 22 0ms 0ms 0ms select category, name, sum(total) as total, sum(correct) as correct, (cast(sum(correct) as float) / cast(sum(total) as float)) * ?.? as percentage, min("from") AS "from", max("to") AS "to" from ( select category, name, total, correct, percentage, "from", "to" from stats_summary where statsid = ? and category = lower(?) and name in (...) union select category, name, total, correct, percentage, "from", "to" from stats_hrs_summary where statsid = ? and category = lower(?) and name in (...) order by correct desc) as summdata group by category, name having sum(total) > ? order by name;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 01 11 22 0ms 0ms 10 0ms 7 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 #10
Day Hour Count Duration Avg duration Mar 01 11 7 0ms 0ms 11 0ms 444 0ms 0ms 0ms commit;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 01 11 444 0ms 0ms 12 0ms 168 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 #12
Day Hour Count Duration Avg duration Mar 01 11 168 0ms 0ms 13 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 #13
Day Hour Count Duration Avg duration Mar 01 11 3 0ms 0ms 14 0ms 237 0ms 0ms 0ms select count(*), sum(size), extract(epoch from now() - min(modification)) from pg_ls_waldir ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 01 11 237 0ms 0ms 15 0ms 24 0ms 0ms 0ms select * from ( select pricedatetime, open, high, low, close, volume, bsf from t30 where symbolid = ? and (bsf = ? or bsf is null) order by pricedatetime desc limit ?) a order by pricedatetime asc;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 01 11 24 0ms 0ms 16 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 #16
Day Hour Count Duration Avg duration Mar 01 11 6 0ms 0ms 17 0ms 10 0ms 0ms 0ms update executions set isrunning = false, has_results = false, response = ? where id = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 01 11 10 0ms 0ms 18 0ms 237 0ms 0ms 0ms select system_identifier from pg_control_system ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 01 11 237 0ms 0ms 19 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 #19
Day Hour Count Duration Avg duration Mar 01 11 237 0ms 0ms 20 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 #20
Day Hour Count Duration Avg duration Mar 01 11 2 0ms 0ms Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 4,091 0ms 0ms 0ms 0ms insert into executionlogs (executionid, status, message, details, detailtype) values (null, ?, ?, null, null);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 01 11 4,091 0ms 0ms 2 3,755 0ms 0ms 0ms 0ms select ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 01 11 3,755 0ms 0ms 3 3,268 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 #3
Day Hour Count Duration Avg duration Mar 01 11 3,268 0ms 0ms 4 2,798 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 #4
Day Hour Count Duration Avg duration Mar 01 11 2,798 0ms 0ms 5 2,428 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 #5
Day Hour Count Duration Avg duration Mar 01 11 2,428 0ms 0ms 6 2,399 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 #6
Day Hour Count Duration Avg duration Mar 01 11 2,399 0ms 0ms 7 1,587 0ms 0ms 0ms 0ms select distinct on (coalesce(bim.code, s.symbol) , s.exchange, s.timegranularity, df.timezone) s.symbolid as id, coalesce(bim.code, s.symbol) as name, s.symbol as symbol, dss.downloadersymbol as ticker, s.exchange as exchange, s.timegranularity as interval, df.timezone as timezone from symbols s inner join downloadersymbolsettings dss on dss.symbolid = s.symbolid inner join datafeedstimetable df on df.classname ilike dss.classname left join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = s.symbolid left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = ? and bim.type = ? where s.symbolid = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 01 11 1,587 0ms 0ms 8 1,407 0ms 0ms 0ms 0ms select s.symbolid as id, s.symbol as name, s.exchange as exchange, s.timegranularity as interval, dtt.timezone as timezone from symbols s inner join downloadersymbolsettings dss on dss.symbolid = s.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where bsl.brokerid = ? and (? = ? or s.timegranularity = ?) and (s.symbol = ? or dss.downloadersymbol = ?) and dss.enabled = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 01 11 1,407 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 Mar 01 11 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 Mar 01 11 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 Mar 01 11 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 Mar 01 11 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 Mar 01 11 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 Mar 01 11 1,185 0ms 0ms 15 968 0ms 0ms 0ms 0ms select datetimeupdate from latest_candle_datetime_per_receng where recognitionengine ilike ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 01 11 968 0ms 0ms 16 916 0ms 0ms 0ms 0ms set extra_float_digits = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 01 11 916 0ms 0ms 17 904 0ms 0ms 0ms 0ms set application_name = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 01 11 904 0ms 0ms 18 605 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 Mar 01 11 605 0ms 0ms 19 596 0ms 0ms 0ms 0ms begin;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 01 11 596 0ms 0ms 20 474 0ms 0ms 0ms 0ms set statement_timeout = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 01 11 474 0ms 0ms Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 0ms 0ms 0ms 10 0ms select key, value from datasources ds inner join datasourceparams dsp on ds.id = dsp.datasourceid where ds.name = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 01 11 10 0ms 0ms 2 0ms 0ms 0ms 120 0ms with rar_max as ( select resultuid from relevance_consecutivecandles_results order by resultuid desc limit ? ), all_results as ( select ccr.resultuid as resultuid, ccr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, ccr.patternendtime as identified, dtt.timezone as timezone, ccr.qtyconsecutivecandles as length, g.basegroupname, case when rcr.age is not null then rcr.age when ccr.resultuid <= rm.resultuid then ? else ? end as age, case when rcr.relevant is not null then rcr.relevant when ccr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip, newlevels.filtered from consecutivecandles_results ccr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = ccr.symbolid inner join symbols s on ccr.symbolid = s.symbolid and s.nonliquid = ? inner join downloadersymbolsettings dss on ccr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on ccr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join rar_max rm on ? = ? left outer join relevance_consecutivecandles_results rcr on rcr.resultuid = ccr.resultuid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? left join lateral calc_cc_signal_filter (ccr.resultuid) newlevels on true where ccr.gmttimefound > now() - interval ? and s.deleted = ? and (ccr.simulation = ? or ccr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ccr.patternlengthbars <= ?) ), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 01 11 120 0ms 0ms 3 0ms 0ms 0ms 2,399 0ms insert into t60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 01 11 2,399 0ms 0ms 4 0ms 0ms 0ms 9 0ms select case when a.old_resultuid = ? then a.old_resultuid else a.resultuid end as resultuid, s.symbol, timegranularity as interval, direction as direction, patternendtime as patternendtime, patternstartprice as psp, patternendprice as pep, target03 as t03, target16 as t16, patternlengthbars as length, p.patternname as patternname, dtt.timezone, cps.pip from fibonacci_results a inner join downloadersymbolsettings dss on a.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join fibonaccipatterns p on a.pattern = p.patternname left join currencypips cps on cps.symbol = s.symbol where (a.old_resultuid = ? or a.resultuid = ?) and dtt.dayofweek = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 01 11 9 0ms 0ms 5 0ms 0ms 0ms 88 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 Mar 01 11 88 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 Mar 01 11 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 Mar 01 11 237 0ms 0ms 8 0ms 0ms 0ms 6 0ms select distinct s.statsid as statsid, sy.exchange as name from stats s inner join broker b on s.brokerid = b.brokerid inner join brokerconfig bc on b.brokerid = bc.brokerid inner join stats_symbols ss on s.statsid = ss.statsid inner join downloadersymbolsettings dss on ss.symbolid = dss.symbolid inner join symbols sy on dss.symbolid = sy.symbolid where dss.enabled = ? and s.brokerid is not null and b.brokerid = ? and s.groupingtype ilike ? and s.description ilike ? || b.name || ? and s.description ilike ? || sy.exchange || ? and s.description not ilike ? || ? || ? union all select distinct s.statsid as statsid, basegroupname as name from stats s inner join broker b on s.brokerid = b.brokerid inner join brokerconfig bc on b.brokerid = bc.brokerid inner join stats_symbols ss on s.statsid = ss.statsid inner join downloadersymbolsettings dss on ss.symbolid = dss.symbolid inner join symbolgroup sg on dss.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bg.brokerid = b.brokerid where dss.enabled = ? and s.brokerid is not null and b.brokerid = ? and s.groupingtype not ilike ? and s.description ilike ? || b.name || ? and s.description ilike ? || g.basegroupname || ? and s.description not ilike ? || ? || ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 01 11 6 0ms 0ms 9 0ms 0ms 0ms 22 0ms select category, name, sum(total) as total, sum(correct) as correct, (cast(sum(correct) as float) / cast(sum(total) as float)) * ?.? as percentage, min("from") AS "from", max("to") AS "to" from ( select category, name, total, correct, percentage, "from", "to" from stats_summary where statsid = ? and category = lower(?) and name in (...) union select category, name, total, correct, percentage, "from", "to" from stats_hrs_summary where statsid = ? and category = lower(?) and name in (...) order by correct desc) as summdata group by category, name having sum(total) > ? order by name;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 01 11 22 0ms 0ms 10 0ms 0ms 0ms 7 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 #10
Day Hour Count Duration Avg duration Mar 01 11 7 0ms 0ms 11 0ms 0ms 0ms 444 0ms commit;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 01 11 444 0ms 0ms 12 0ms 0ms 0ms 168 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 #12
Day Hour Count Duration Avg duration Mar 01 11 168 0ms 0ms 13 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 #13
Day Hour Count Duration Avg duration Mar 01 11 3 0ms 0ms 14 0ms 0ms 0ms 237 0ms select count(*), sum(size), extract(epoch from now() - min(modification)) from pg_ls_waldir ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 01 11 237 0ms 0ms 15 0ms 0ms 0ms 24 0ms select * from ( select pricedatetime, open, high, low, close, volume, bsf from t30 where symbolid = ? and (bsf = ? or bsf is null) order by pricedatetime desc limit ?) a order by pricedatetime asc;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 01 11 24 0ms 0ms 16 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 #16
Day Hour Count Duration Avg duration Mar 01 11 6 0ms 0ms 17 0ms 0ms 0ms 10 0ms update executions set isrunning = false, has_results = false, response = ? where id = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 01 11 10 0ms 0ms 18 0ms 0ms 0ms 237 0ms select system_identifier from pg_control_system ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 01 11 237 0ms 0ms 19 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 #19
Day Hour Count Duration Avg duration Mar 01 11 237 0ms 0ms 20 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 #20
Day Hour Count Duration Avg duration Mar 01 11 2 0ms 0ms Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1s86ms 708 0ms 10ms 1ms SELECT symbolid, ;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Mar 01 11 708 1s86ms 1ms -
SELECT symbolid, ;
Date: 2026-03-01 11:45:58 Duration: 10ms Database: postgres
-
SELECT symbolid, ;
Date: 2026-03-01 11:15:51 Duration: 3ms Database: postgres
-
SELECT symbolid, ;
Date: 2026-03-01 11:01:01 Duration: 2ms Database: postgres
2 345ms 351 0ms 7ms 0ms WITH rar_max as ( ;Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 11 351 345ms 0ms -
WITH rar_max as ( ;
Date: 2026-03-01 11:45:47 Duration: 7ms Database: postgres
-
WITH rar_max as ( ;
Date: 2026-03-01 11:45:47 Duration: 7ms Database: postgres
-
WITH rar_max as ( ;
Date: 2026-03-01 11:27:53 Duration: 6ms Database: postgres
3 218ms 2,311 0ms 0ms 0ms INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming prepare #3
Day Hour Count Duration Avg duration 11 2,311 218ms 0ms -
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:11:47 Duration: 0ms Database: postgres
-
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:11:01 Duration: 0ms Database: postgres
-
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:11:03 Duration: 0ms Database: postgres
4 190ms 2,404 0ms 0ms 0ms INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming prepare #4
Day Hour Count Duration Avg duration 11 2,404 190ms 0ms -
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:41:00 Duration: 0ms Database: postgres
-
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:01:03 Duration: 0ms Database: postgres
-
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:11:45 Duration: 0ms Database: postgres
5 161ms 356 0ms 8ms 0ms SELECT ;Times Reported Time consuming prepare #5
Day Hour Count Duration Avg duration 11 356 161ms 0ms -
SELECT ;
Date: 2026-03-01 11:45:47 Duration: 8ms Database: postgres
-
SELECT ;
Date: 2026-03-01 11:45:47 Duration: 3ms Database: postgres
-
SELECT ;
Date: 2026-03-01 11:34:26 Duration: 2ms Database: postgres
6 124ms 916 0ms 0ms 0ms SET extra_float_digits = 3;Times Reported Time consuming prepare #6
Day Hour Count Duration Avg duration 11 916 124ms 0ms -
SET extra_float_digits = 3;
Date: 2026-03-01 11:34:26 Duration: 0ms Database: postgres
-
SET extra_float_digits = 3;
Date: 2026-03-01 11:01:01 Duration: 0ms Database: postgres
-
SET extra_float_digits = 3;
Date: 2026-03-01 11:30:41 Duration: 0ms Database: postgres
7 119ms 110 0ms 1ms 1ms SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;Times Reported Time consuming prepare #7
Day Hour Count Duration Avg duration 11 110 119ms 1ms -
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-01 11:17:24 Duration: 1ms Database: postgres
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-01 11:45:53 Duration: 1ms Database: postgres
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-01 11:15:55 Duration: 1ms Database: postgres
8 113ms 687 0ms 0ms 0ms INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming prepare #8
Day Hour Count Duration Avg duration 11 687 113ms 0ms -
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:26:47 Duration: 0ms Database: postgres
-
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:31:53 Duration: 0ms Database: postgres
-
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:01:49 Duration: 0ms Database: postgres
9 43ms 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 11 18 43ms 2ms -
select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;
Date: 2026-03-01 11:51:14 Duration: 2ms Database: postgres
-
select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;
Date: 2026-03-01 11:20:03 Duration: 2ms Database: postgres
-
select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;
Date: 2026-03-01 11:01:23 Duration: 2ms Database: postgres
10 17ms 128 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 #10
Day Hour Count Duration Avg duration 11 128 17ms 0ms -
INSERT INTO T240 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:05:33 Duration: 0ms Database: postgres
-
INSERT INTO T240 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:16:52 Duration: 0ms Database: postgres
-
INSERT INTO T240 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:01:29 Duration: 0ms Database: postgres
11 13ms 6 2ms 2ms 2ms select client_addr, count(1) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by client_addr, setting having (client_addr is not null OR (client_addr is null and count(1) > (cast(setting as numeric) / 3 * 2))) order by count desc;Times Reported Time consuming prepare #11
Day Hour Count Duration Avg duration 11 6 13ms 2ms -
select client_addr, count(1) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by client_addr, setting having (client_addr is not null OR (client_addr is null and count(1) > (cast(setting as numeric) / 3 * 2))) order by count desc;
Date: 2026-03-01 11:10: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-03-01 11: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-03-01 11:50:04 Duration: 2ms Database: postgres
12 9ms 904 0ms 0ms 0ms SET application_name = 'PostgreSQL JDBC Driver';Times Reported Time consuming prepare #12
Day Hour Count Duration Avg duration 11 904 9ms 0ms -
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2026-03-01 11:26:39 Duration: 0ms Database: postgres
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2026-03-01 11:17:46 Duration: 0ms Database: postgres
-
SET application_name = 'PostgreSQL JDBC Driver';
Date: 2026-03-01 11:26:17 Duration: 0ms Database: postgres
13 7ms 177 0ms 0ms 0ms select 1;Times Reported Time consuming prepare #13
Day Hour Count Duration Avg duration 11 177 7ms 0ms -
select 1;
Date: 2026-03-01 11:25:48 Duration: 0ms Database: postgres
-
select 1;
Date: 2026-03-01 11:25:48 Duration: 0ms Database: postgres
-
select 1;
Date: 2026-03-01 11:45:47 Duration: 0ms Database: postgres
14 6ms 34 0ms 0ms 0ms select category, ;Times Reported Time consuming prepare #14
Day Hour Count Duration Avg duration 11 34 6ms 0ms -
select category, ;
Date: 2026-03-01 11:58:03 Duration: 0ms Database: postgres
-
select category, ;
Date: 2026-03-01 11:18:17 Duration: 0ms Database: postgres
-
select category, ;
Date: 2026-03-01 11:18:53 Duration: 0ms Database: postgres
15 5ms 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 #15
Day Hour Count Duration Avg duration 11 36 5ms 0ms -
INSERT INTO T1440_underlying (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:31:24 Duration: 0ms Database: postgres
-
INSERT INTO T1440_underlying (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:01:25 Duration: 0ms Database: postgres
-
INSERT INTO T1440_underlying (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:30:32 Duration: 0ms Database: postgres
16 3ms 2 1ms 1ms 1ms select count(*) from ( select max(lastupdated) from sa_hist_consecutivecandles where symbolid in ( select symbolid from t1440 group by symbolid order by max(sastdatetimereceived) desc limit 30) group by symbolid having max(lastupdated) > current_timestamp - interval '24 hours' order by max(lastupdated) desc limit 30) as k;Times Reported Time consuming prepare #16
Day Hour Count Duration Avg duration 11 2 3ms 1ms -
select count(*) from ( select max(lastupdated) from sa_hist_consecutivecandles where symbolid in ( select symbolid from t1440 group by symbolid order by max(sastdatetimereceived) desc limit 30) group by symbolid having max(lastupdated) > current_timestamp - interval '24 hours' order by max(lastupdated) desc limit 30) as k;
Date: 2026-03-01 11:01:01 Duration: 1ms Database: postgres
-
select count(*) from ( select max(lastupdated) from sa_hist_consecutivecandles where symbolid in ( select symbolid from t1440 group by symbolid order by max(sastdatetimereceived) desc limit 30) group by symbolid having max(lastupdated) > current_timestamp - interval '24 hours' order by max(lastupdated) desc limit 30) as k;
Date: 2026-03-01 11:01:02 Duration: 1ms Database: postgres
17 3ms 2 1ms 1ms 1ms select count(*) from ( select max(lastupdated) from sa_hist_bigmove where symbolid in ( select symbolid from t1440 group by symbolid order by max(sastdatetimereceived) desc limit 30) group by symbolid having max(lastupdated) > current_timestamp - interval '24 hours' order by max(lastupdated) desc limit 30) as k;Times Reported Time consuming prepare #17
Day Hour Count Duration Avg duration 11 2 3ms 1ms -
select count(*) from ( select max(lastupdated) from sa_hist_bigmove where symbolid in ( select symbolid from t1440 group by symbolid order by max(sastdatetimereceived) desc limit 30) group by symbolid having max(lastupdated) > current_timestamp - interval '24 hours' order by max(lastupdated) desc limit 30) as k;
Date: 2026-03-01 11:00:45 Duration: 1ms Database: postgres
-
select count(*) from ( select max(lastupdated) from sa_hist_bigmove where symbolid in ( select symbolid from t1440 group by symbolid order by max(sastdatetimereceived) desc limit 30) group by symbolid having max(lastupdated) > current_timestamp - interval '24 hours' order by max(lastupdated) desc limit 30) as k;
Date: 2026-03-01 11:00:45 Duration: 1ms Database: postgres
18 2ms 2 0ms 1ms 1ms WITH last_candle AS ( ;Times Reported Time consuming prepare #18
Day Hour Count Duration Avg duration 11 2 2ms 1ms -
WITH last_candle AS ( ;
Date: 2026-03-01 11:40:00 Duration: 1ms Database: postgres
-
WITH last_candle AS ( ;
Date: 2026-03-01 11:44:00 Duration: 0ms Database: postgres
19 2ms 1 2ms 2ms 2ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 634 LIMIT $1;Times Reported Time consuming prepare #19
Day Hour Count Duration Avg duration 11 1 2ms 2ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 634 LIMIT $1;
Date: 2026-03-01 11:30:09 Duration: 2ms Database: postgres
20 2ms 1 2ms 2ms 2ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 972 LIMIT $1;Times Reported Time consuming prepare #20
Day Hour Count Duration Avg duration 11 1 2ms 2ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 972 LIMIT $1;
Date: 2026-03-01 11:44:53 Duration: 2ms Database: postgres
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 9s236ms 871 0ms 57ms 10ms WITH rar_max as ( ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Mar 01 11 871 9s236ms 10ms -
WITH rar_max as ( ;
Date: 2026-03-01 11:45:47 Duration: 57ms Database: postgres parameters: $1 = '607753279912680303', $2 = '607753279912680303', $3 = '607753279912680303'
-
WITH rar_max as ( ;
Date: 2026-03-01 11:46:06 Duration: 54ms 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 = '160', $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 = 'AUDSGD', $95 = 'CHFSGD', $96 = 'EURDKK', $97 = 'EURHKD', $98 = 'EURNOK', $99 = 'EURPLN', $100 = 'EURSEK', $101 = 'EURSGD', $102 = 'EURTRY', $103 = 'EURZAR', $104 = 'GBPDKK', $105 = 'GBPNOK', $106 = 'GBPSEK', $107 = 'GBPSGD', $108 = 'NOKJPY', $109 = 'NOKSEK', $110 = 'SEKJPY', $111 = 'SGDJPY', $112 = 'USDCNH', $113 = 'USDCZK', $114 = 'USDDKK', $115 = 'USDHKD', $116 = 'USDHUF', $117 = 'USDMXN', $118 = 'USDNOK', $119 = 'USDPLN', $120 = 'USDRUB', $121 = 'USDSEK', $122 = 'USDTHB', $123 = 'USDTRY', $124 = 'USDZAR', $125 = 'AUDUSD', $126 = 'EURUSD', $127 = 'GBPUSD', $128 = 'USDCAD', $129 = 'USDCHF', $130 = 'USDJPY', $131 = 'AUDCAD', $132 = 'AUDCHF', $133 = 'AUDJPY', $134 = 'AUDNZD', $135 = 'CADCHF', $136 = 'CADJPY', $137 = 'CHFJPY', $138 = 'EURAUD', $139 = 'EURCAD', $140 = 'EURCHF', $141 = 'EURGBP', $142 = 'EURJPY', $143 = 'EURNZD', $144 = 'GBPAUD', $145 = 'GBPCAD', $146 = 'GBPCHF', $147 = 'GBPJPY', $148 = 'GBPNZD', $149 = 'NZDCAD', $150 = 'NZDCHF', $151 = 'NZDJPY', $152 = 'NZDUSD', $153 = 'USDSGD', $154 = 'AUS200', $155 = 'DE30', $156 = 'ES35', $157 = 'F40', $158 = 'HK50', $159 = 'IT40', $160 = 'JP225', $161 = 'STOXX50', $162 = 'UK100', $163 = 'US2000', $164 = 'US30', $165 = 'US500', $166 = 'CHINA50', $167 = 'USTEC', $168 = 'XAGEUR', $169 = 'XAGUSD', $170 = 'XAUUSD', $171 = 'XAUEUR', $172 = 'XPDUSD', $173 = 'XPTUSD', $174 = '0', $175 = '', $176 = '0', $177 = '0', $178 = '0', $179 = '700', $180 = '700', $181 = 't', $182 = '10', $183 = '10'
-
WITH rar_max as ( ;
Date: 2026-03-01 11:45:47 Duration: 50ms Database: postgres parameters: $1 = '607752695400215303', $2 = '607752695400215303', $3 = '607752695400215303'
2 1s841ms 708 0ms 6ms 2ms SELECT symbolid, ;Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 11 708 1s841ms 2ms -
SELECT symbolid, ;
Date: 2026-03-01 11:05:35 Duration: 6ms Database: postgres parameters: $1 = 'MILLENNIUMPF', $2 = '15', $3 = 'USDJPY', $4 = 'R_SSI', $5 = 'USDCAD.ID', $6 = 'USDCHF.ID', $7 = 'USDCHF', $8 = 'USDCHF.FX', $9 = 'USDCAD.FX', $10 = 'USDJPY.FX', $11 = 'USDCAD', $12 = 'SP500'
-
SELECT symbolid, ;
Date: 2026-03-01 11:15:51 Duration: 3ms Database: postgres parameters: $1 = 'BDSWISS', $2 = '15', $3 = 'ETHEUR', $4 = 'ETHUSD'
-
SELECT symbolid, ;
Date: 2026-03-01 11:31:17 Duration: 3ms Database: postgres parameters: $1 = 'MILLENNIUMPF', $2 = '15', $3 = 'GBPUSD.ID', $4 = 'NZDUSD', $5 = 'NZDCAD.FX', $6 = 'NASDAQ100', $7 = 'NZDJPY', $8 = 'GBPUSD.FX', $9 = 'NZDJPY.FX', $10 = 'NZDUSD.FX', $11 = 'NZDJPY.ID', $12 = 'GBPUSD'
3 1s180ms 3,369 0ms 10ms 0ms SELECT ;Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 11 3,369 1s180ms 0ms -
SELECT ;
Date: 2026-03-01 11:45:47 Duration: 10ms Database: postgres parameters: $1 = '558', $2 = '558', $3 = '515840243278350300'
-
SELECT ;
Date: 2026-03-01 11:25:48 Duration: 7ms Database: postgres parameters: $1 = '689', $2 = '689', $3 = '515840245954282300'
-
SELECT ;
Date: 2026-03-01 11:26:39 Duration: 6ms Database: postgres parameters: $1 = '689', $2 = '689', $3 = '515840245871314300'
4 212ms 12 0ms 24ms 17ms with wh_patitioned as ( ;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 11 12 212ms 17ms -
with wh_patitioned as ( ;
Date: 2026-03-01 11: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-03-01 11:35: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-03-01 11:55:02 Duration: 24ms Database: postgres parameters: $1 = '558', $2 = '558', $3 = '558', $4 = '558', $5 = '558', $6 = '558', $7 = '558', $8 = '558', $9 = '558'
5 204ms 30 4ms 14ms 6ms WITH last_candle AS ( ;Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 11 30 204ms 6ms -
WITH last_candle AS ( ;
Date: 2026-03-01 11:52:00 Duration: 14ms Database: postgres parameters: $1 = '558', $2 = '558'
-
WITH last_candle AS ( ;
Date: 2026-03-01 11:52:00 Duration: 10ms Database: postgres parameters: $1 = '558', $2 = '558'
-
WITH last_candle AS ( ;
Date: 2026-03-01 11:24:00 Duration: 9ms Database: postgres parameters: $1 = '558', $2 = '558'
6 188ms 2,399 0ms 0ms 0ms INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming bind #6
Day Hour Count Duration Avg duration 11 2,399 188ms 0ms -
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:11:47 Duration: 0ms Database: postgres parameters: $1 = '2026-02-27 20:00:00', $2 = '9191.4', $3 = '9203.4', $4 = '9184.3', $5 = '9196.4', $6 = '8819', $7 = '515840248015562300', $8 = '0', $9 = '2026-03-01 11:11:47.652', $10 = '2026-03-01 11:11:47.579', $11 = '9191.4', $12 = '9203.4', $13 = '9184.3', $14 = '9196.4', $15 = '8819', $16 = '0', $17 = '2026-03-01 11:11:47.652', $18 = '2026-03-01 11:11:47.579'
-
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:11:01 Duration: 0ms Database: postgres parameters: $1 = '2026-02-27 17:00:00', $2 = '26519.3', $3 = '26586.3', $4 = '26474.7', $5 = '26583.1', $6 = '19413', $7 = '515840247933961300', $8 = '0', $9 = '2026-03-01 11:11:01.211', $10 = '2026-03-01 11:11:01.123', $11 = '26519.3', $12 = '26586.3', $13 = '26474.7', $14 = '26583.1', $15 = '19413', $16 = '0', $17 = '2026-03-01 11:11:01.211', $18 = '2026-03-01 11:11:01.123'
-
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:11:03 Duration: 0ms Database: postgres parameters: $1 = '2026-02-27 22:00:00', $2 = '24849.72', $3 = '24971.47', $4 = '24847.85', $5 = '24931.9', $6 = '29803', $7 = '515840248039327300', $8 = '0', $9 = '2026-03-01 11:11:03.267', $10 = '2026-03-01 11:11:03.164', $11 = '24849.72', $12 = '24971.47', $13 = '24847.85', $14 = '24931.9', $15 = '29803', $16 = '0', $17 = '2026-03-01 11:11:03.267', $18 = '2026-03-01 11:11:03.164'
7 187ms 110 1ms 2ms 1ms SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;Times Reported Time consuming bind #7
Day Hour Count Duration Avg duration 11 110 187ms 1ms -
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-01 11:46:00 Duration: 2ms Database: postgres parameters: $1 = 'GLOBALGTMT5'
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-01 11:46:12 Duration: 2ms Database: postgres parameters: $1 = 'ATFX'
-
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;
Date: 2026-03-01 11:45:53 Duration: 2ms Database: postgres parameters: $1 = 'BDSWISS'
8 168ms 2,428 0ms 0ms 0ms INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming bind #8
Day Hour Count Duration Avg duration 11 2,428 168ms 0ms -
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:41:00 Duration: 0ms Database: postgres parameters: $1 = '2026-02-27 18:00:00', $2 = '26583.3', $3 = '26614.8', $4 = '26536.8', $5 = '26539', $6 = '8584', $7 = '515840247933633300', $8 = '0', $9 = '2026-03-01 11:41:00.416', $10 = '2026-03-01 11:41:00.343', $11 = '26583.3', $12 = '26614.8', $13 = '26536.8', $14 = '26539', $15 = '8584', $16 = '0', $17 = '2026-03-01 11:41:00.416', $18 = '2026-03-01 11:41:00.343'
-
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:01:03 Duration: 0ms Database: postgres parameters: $1 = '2026-02-27 23:00:00', $2 = '24931.78', $3 = '24935.03', $4 = '24891.15', $5 = '24920.03', $6 = '8919', $7 = '515840248039147300', $8 = '0', $9 = '2026-03-01 11:01:03.283', $10 = '2026-03-01 11:01:03.2', $11 = '24931.78', $12 = '24935.03', $13 = '24891.15', $14 = '24920.03', $15 = '8919', $16 = '0', $17 = '2026-03-01 11:01:03.283', $18 = '2026-03-01 11:01:03.2'
-
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:11:45 Duration: 0ms Database: postgres parameters: $1 = '2026-02-27 21:00:00', $2 = '9196.25', $3 = '9197.45', $4 = '9185.4', $5 = '9190.4', $6 = '3873', $7 = '515840248015340300', $8 = '0', $9 = '2026-03-01 11:11:45.652', $10 = '2026-03-01 11:11:45.552', $11 = '9196.25', $12 = '9197.45', $13 = '9185.4', $14 = '9190.4', $15 = '3873', $16 = '0', $17 = '2026-03-01 11:11:45.652', $18 = '2026-03-01 11:11:45.552'
9 145ms 3,654 0ms 7ms 0ms select 1;Times Reported Time consuming bind #9
Day Hour Count Duration Avg duration 11 3,654 145ms 0ms -
select 1;
Date: 2026-03-01 11:40:43 Duration: 7ms Database: postgres
-
select 1;
Date: 2026-03-01 11:50:52 Duration: 6ms Database: postgres
-
select 1;
Date: 2026-03-01 11:53:12 Duration: 3ms Database: postgres
10 132ms 2,798 0ms 0ms 0ms INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;Times Reported Time consuming bind #10
Day Hour Count Duration Avg duration 11 2,798 132ms 0ms -
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:26:47 Duration: 0ms Database: postgres parameters: $1 = '2026-02-27 21:30:00', $2 = '9190.45', $3 = '9191.45', $4 = '9179.9', $5 = '9180.4', $6 = '1867', $7 = '515840248015086300', $8 = '0', $9 = '2026-03-01 11:26:46.999', $10 = '2026-03-01 11:26:46.916', $11 = '9190.45', $12 = '9191.45', $13 = '9179.9', $14 = '9180.4', $15 = '1867', $16 = '0', $17 = '2026-03-01 11:26:46.999', $18 = '2026-03-01 11:26:46.916'
-
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:31:53 Duration: 0ms Database: postgres parameters: $1 = '2026-02-28 00:45:00', $2 = '48896.3', $3 = '48896.3', $4 = '48866.3', $5 = '48879.44', $6 = '539', $7 = '515840249387894300', $8 = '0', $9 = '2026-03-01 11:31:53.003', $10 = '2026-03-01 11:31:52.948', $11 = '48896.3', $12 = '48896.3', $13 = '48866.3', $14 = '48879.44', $15 = '539', $16 = '0', $17 = '2026-03-01 11:31:53.003', $18 = '2026-03-01 11:31:52.948'
-
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;
Date: 2026-03-01 11:26:02 Duration: 0ms Database: postgres parameters: $1 = '2026-02-27 23:15:00', $2 = '24916.03', $3 = '24928.03', $4 = '24891.15', $5 = '24920.03', $6 = '3923', $7 = '515840248038958300', $8 = '0', $9 = '2026-03-01 11:26:02.728', $10 = '2026-03-01 11:26:02.657', $11 = '24916.03', $12 = '24928.03', $13 = '24891.15', $14 = '24920.03', $15 = '3923', $16 = '0', $17 = '2026-03-01 11:26:02.728', $18 = '2026-03-01 11:26:02.657'
11 46ms 418 0ms 0ms 0ms select category, ;Times Reported Time consuming bind #11
Day Hour Count Duration Avg duration 11 418 46ms 0ms -
select category, ;
Date: 2026-03-01 11:18:14 Duration: 0ms Database: postgres parameters: $1 = '604104683404416307', $2 = 'initialtrend', $3 = '604104683404416307', $4 = 'initialtrend'
-
select category, ;
Date: 2026-03-01 11:19:05 Duration: 0ms Database: postgres parameters: $1 = '604104683406582307', $2 = 'symbol', $3 = 'AUDJPY', $4 = 'NZDJPY', $5 = 'GBPJPY', $6 = 'CHFJPY', $7 = 'CADJPY', $8 = 'EURJPY', $9 = 'GBPAUD', $10 = 'GBPNZD', $11 = 'EURAUD', $12 = 'EURNZD', $13 = 'GBPCAD', $14 = 'EURGBP', $15 = 'GBPCAD', $16 = 'EURCAD', $17 = 'CADJPY', $18 = 'AUDNZD', $19 = 'CADCHF', $20 = 'EURCAD', $21 = 'NZDJPY', $22 = 'EURJPY', $23 = 'EURNZD', $24 = 'GBPCHF', $25 = 'EURCHF', $26 = 'USDSGD', $27 = 'AUDJPY', $28 = 'AUDCAD', $29 = 'AUDCHF', $30 = 'NZDUSD', $31 = 'GBPCHF', $32 = 'NZDCHF', $33 = 'GBPAUD', $34 = 'GBPJPY', $35 = 'NZDCAD', $36 = 'EURAUD', $37 = 'CHFJPY', $38 = 'GBPNZD', $39 = 'NZDCAD', $40 = 'AUDCAD', $41 = 'USDSGD', $42 = 'NZDUSD', $43 = 'AUDCHF', $44 = 'EURCHF', $45 = 'CADCHF', $46 = 'NZDCHF', $47 = 'AUDNZD', $48 = 'EURGBP', $49 = '604104683406582307', $50 = 'symbol', $51 = 'AUDJPY', $52 = 'NZDJPY', $53 = 'GBPJPY', $54 = 'CHFJPY', $55 = 'CADJPY', $56 = 'EURJPY', $57 = 'GBPAUD', $58 = 'GBPNZD', $59 = 'EURAUD', $60 = 'EURNZD', $61 = 'GBPCAD', $62 = 'EURGBP', $63 = 'GBPCAD', $64 = 'EURCAD', $65 = 'CADJPY', $66 = 'AUDNZD', $67 = 'CADCHF', $68 = 'EURCAD', $69 = 'NZDJPY', $70 = 'EURJPY', $71 = 'EURNZD', $72 = 'GBPCHF', $73 = 'EURCHF', $74 = 'USDSGD', $75 = 'AUDJPY', $76 = 'AUDCAD', $77 = 'AUDCHF', $78 = 'NZDUSD', $79 = 'GBPCHF', $80 = 'NZDCHF', $81 = 'GBPAUD', $82 = 'GBPJPY', $83 = 'NZDCAD', $84 = 'EURAUD', $85 = 'CHFJPY', $86 = 'GBPNZD', $87 = 'NZDCAD', $88 = 'AUDCAD', $89 = 'USDSGD', $90 = 'NZDUSD', $91 = 'AUDCHF', $92 = 'EURCHF', $93 = 'CADCHF', $94 = 'NZDCHF', $95 = 'AUDNZD', $96 = 'EURGBP'
-
select category, ;
Date: 2026-03-01 11:48:58 Duration: 0ms Database: postgres parameters: $1 = '605717914809373307', $2 = 'symbol', $3 = 'AUDJPY', $4 = 'NZDJPY', $5 = 'GBPJPY', $6 = 'CHFJPY', $7 = 'CADJPY', $8 = 'EURJPY', $9 = 'GBPAUD', $10 = 'GBPNZD', $11 = 'EURAUD', $12 = 'EURNZD', $13 = 'GBPCAD', $14 = 'EURCAD', $15 = 'EURGBP', $16 = 'CADCHF', $17 = 'EURCHF', $18 = 'AUDCHF', $19 = 'GBPCHF', $20 = 'EURNZD', $21 = 'CADJPY', $22 = 'GBPJPY', $23 = 'GBPCAD', $24 = 'AUDJPY', $25 = 'NZDCAD', $26 = 'USDSGD', $27 = 'EURCAD', $28 = 'CHFJPY', $29 = 'NZDUSD', $30 = 'EURAUD', $31 = 'GBPNZD', $32 = 'AUDCAD', $33 = 'AUDNZD', $34 = 'GBPAUD', $35 = 'NZDJPY', $36 = 'USDSGD', $37 = 'AUDCAD', $38 = 'GBPCHF', $39 = 'NZDCHF', $40 = 'NZDUSD', $41 = 'EURJPY', $42 = 'NZDCAD', $43 = 'AUDCHF', $44 = 'EURCHF', $45 = 'AUDNZD', $46 = 'NZDCHF', $47 = 'CADCHF', $48 = 'EURGBP', $49 = '605717914809373307', $50 = 'symbol', $51 = 'AUDJPY', $52 = 'NZDJPY', $53 = 'GBPJPY', $54 = 'CHFJPY', $55 = 'CADJPY', $56 = 'EURJPY', $57 = 'GBPAUD', $58 = 'GBPNZD', $59 = 'EURAUD', $60 = 'EURNZD', $61 = 'GBPCAD', $62 = 'EURCAD', $63 = 'EURGBP', $64 = 'CADCHF', $65 = 'EURCHF', $66 = 'AUDCHF', $67 = 'GBPCHF', $68 = 'EURNZD', $69 = 'CADJPY', $70 = 'GBPJPY', $71 = 'GBPCAD', $72 = 'AUDJPY', $73 = 'NZDCAD', $74 = 'USDSGD', $75 = 'EURCAD', $76 = 'CHFJPY', $77 = 'NZDUSD', $78 = 'EURAUD', $79 = 'GBPNZD', $80 = 'AUDCAD', $81 = 'AUDNZD', $82 = 'GBPAUD', $83 = 'NZDJPY', $84 = 'USDSGD', $85 = 'AUDCAD', $86 = 'GBPCHF', $87 = 'NZDCHF', $88 = 'NZDUSD', $89 = 'EURJPY', $90 = 'NZDCAD', $91 = 'AUDCHF', $92 = 'EURCHF', $93 = 'AUDNZD', $94 = 'NZDCHF', $95 = 'CADCHF', $96 = 'EURGBP'
12 44ms 6 0ms 11ms 7ms select distinct s.statsid as statsid, sy.exchange as name;Times Reported Time consuming bind #12
Day Hour Count Duration Avg duration 11 6 44ms 7ms -
select distinct s.statsid as statsid, sy.exchange as name;
Date: 2026-03-01 11:57:33 Duration: 11ms Database: postgres parameters: $1 = '1018', $2 = '1018'
-
select distinct s.statsid as statsid, sy.exchange as name;
Date: 2026-03-01 11:47:52 Duration: 11ms Database: postgres parameters: $1 = '972', $2 = '972'
-
select distinct s.statsid as statsid, sy.exchange as name;
Date: 2026-03-01 11:28:20 Duration: 11ms Database: postgres parameters: $1 = '932', $2 = '932'
13 36ms 1 36ms 36ms 36ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 633 LIMIT $1;Times Reported Time consuming bind #13
Day Hour Count Duration Avg duration 11 1 36ms 36ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 633 LIMIT $1;
Date: 2026-03-01 11:30:33 Duration: 36ms Database: postgres parameters: $1 = '50'
14 36ms 1 36ms 36ms 36ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 631 LIMIT $1;Times Reported Time consuming bind #14
Day Hour Count Duration Avg duration 11 1 36ms 36ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 631 LIMIT $1;
Date: 2026-03-01 11:30:34 Duration: 36ms Database: postgres parameters: $1 = '50'
15 33ms 79 0ms 3ms 0ms /*server.CPResult*/ SELECT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, symbol, longname, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, breakout, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM autochartist_results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join patterns p on p.patternname = a.pattern where resultuid = $1;Times Reported Time consuming bind #15
Day Hour Count Duration Avg duration 11 79 33ms 0ms -
/*server.CPResult*/ SELECT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, symbol, longname, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, breakout, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM autochartist_results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join patterns p on p.patternname = a.pattern where resultuid = $1;
Date: 2026-03-01 11:23:59 Duration: 3ms Database: postgres parameters: $1 = '607753274854194301'
-
/*server.CPResult*/ SELECT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, symbol, longname, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, breakout, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM autochartist_results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join patterns p on p.patternname = a.pattern where resultuid = $1;
Date: 2026-03-01 11:47:37 Duration: 3ms Database: postgres parameters: $1 = '607753573306366301'
-
/*server.CPResult*/ SELECT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, symbol, longname, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, breakout, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM autochartist_results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join patterns p on p.patternname = a.pattern where resultuid = $1;
Date: 2026-03-01 11:50:38 Duration: 2ms Database: postgres parameters: $1 = '607753454856257301'
16 33ms 1 33ms 33ms 33ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 1504 LIMIT $1;Times Reported Time consuming bind #16
Day Hour Count Duration Avg duration 11 1 33ms 33ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 1504 LIMIT $1;
Date: 2026-03-01 11:52:35 Duration: 33ms Database: postgres parameters: $1 = '50'
17 24ms 1 24ms 24ms 24ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 634 LIMIT $1;Times Reported Time consuming bind #17
Day Hour Count Duration Avg duration 11 1 24ms 24ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 634 LIMIT $1;
Date: 2026-03-01 11:30:09 Duration: 24ms Database: postgres parameters: $1 = '50'
18 23ms 1 23ms 23ms 23ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 972 LIMIT $1;Times Reported Time consuming bind #18
Day Hour Count Duration Avg duration 11 1 23ms 23ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 972 LIMIT $1;
Date: 2026-03-01 11:44:53 Duration: 23ms Database: postgres parameters: $1 = '50'
19 23ms 1 23ms 23ms 23ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 632 LIMIT $1;Times Reported Time consuming bind #19
Day Hour Count Duration Avg duration 11 1 23ms 23ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 632 LIMIT $1;
Date: 2026-03-01 11:19:54 Duration: 23ms Database: postgres parameters: $1 = '50'
20 23ms 1 23ms 23ms 23ms SELECT * FROM broker_stats_groups_view WHERE brokerid = 1436 LIMIT $1;Times Reported Time consuming bind #20
Day Hour Count Duration Avg duration 11 1 23ms 23ms -
SELECT * FROM broker_stats_groups_view WHERE brokerid = 1436 LIMIT $1;
Date: 2026-03-01 11:51:36 Duration: 23ms Database: postgres parameters: $1 = '50'
-
Events
Log levels
Key values
- 156,219 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 548 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 356 Max number of times the same event was reported
- 548 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 Mar 01 11 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-03-01 11:00:02
2 76 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 01 11 76 - ERROR: syntax error at or near "group" at character 55
- ERROR: syntax error at or near "group" at character 61
Statement: SELECT * FROM broker_stats_timezone_offset_view WHERE group" = 'Commodities' LIMIT $1
Date: 2026-03-01 11:19:55
Statement: SELECT * FROM broker_stats_timezone_offset_count_view WHERE group" = 'Commodities' LIMIT $1
Date: 2026-03-01 11:19:55
3 76 ERROR: function broker_stats_get_symbols_function(...) does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 01 11 76 - ERROR: function broker_stats_get_symbols_function(bigint, integer) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM broker_stats_get_symbols_function(601729875359289307,632) WHERE lower(category) = 'symbol' ORDER BY correct DESC LIMIT $1Date: 2026-03-01 11:19:55
4 40 ERROR: schema "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Mar 01 11 40 - 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-03-01 11:00:35