pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sun Feb 15 13:59:16 2026
Log file: /home/postgres/pg_data/data/pg_log/postgresql-2026-02-15_150000.log
Parsed 446,659 log entries in 15s
Log start from 2026-02-15 15:00:00 to 2026-02-15 15:59:11

Global Stats

167 Number of unique normalized queries
66,815 Number of queries
1h17m57s Total query duration
2026-02-15 15:00:00 First query
2026-02-15 15:59:11 Last query
1,482 queries/s at 2026-02-15 15:15:03 Query peak

1h17m57s Total query duration
2s455ms Prepare/parse total duration
19s20ms Bind total duration
1h17m36s Execute total duration

2 Number of events
2 Number of unique normalized events
1 Max number of times the same event was reported
0 Number of cancellation

37 Total number of automatic vacuums
46 Total number of automatic analyzes

678 Number temporary file
139.91 MiB Max size of temporary file
4.88 MiB Average size of temporary file

1,796 Total number of sessions
13 sessions at 2026-02-15 15:58:48 Session peak
20h14m53s Total duration of sessions
40s586ms Average duration of sessions
37 Average queries per session
2s604ms Average queries duration per session
37s982ms Average idle time per session

1,796 Total number of connections
28 connections/s at 2026-02-15 15:33:48 Connection peak
3 Total number of databases

SQL Traffic

Key values

1,482 queries/s Query Peak
2026-02-15 15:15:03 Date

SELECT Traffic

Key values

725 queries/s Query Peak
2026-02-15 15:15:03 Date

INSERT/UPDATE/DELETE Traffic

Key values

87 queries/s Query Peak
2026-02-15 15:43:49 Date

Queries duration

Key values

1h17m57s 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

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 15	15	66,815	0ms	20s211ms	69ms	2m37s	3m32s	4m30s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 15	15	15,256	26	0ms	0ms	0ms	0ms

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 15	15	12,270	622	16	96	0ms	0ms	0ms	0ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Feb 15	15	9,021	19,062	2.11	29.02%

Day	Hour	Count	Average / Second
Feb 15	15	1,796	0.50/s

Day	Hour	Count	Average Duration	Average idle time
Feb 15	15	1,796	40s586ms	37s994ms

↑ Back to the top of the General Activity table

Established Connections

Key values

28 connections Connection Peak
2026-02-15 15:33:48 Date

Connections per database

Key values

acaweb_fx Main Database
1,796 connections Total

Chart
Table

Database	User	Count
acaweb_fx		1,725
	postgres	1,383
	psql	342
socialmedia		71
	postgres	71

Connections per user

Key values

postgres Main User
1,796 connections Total

Chart
Table

User	Count
postgres	1,454
psql	342

Connections per host

Key values

192.168.4.142 Main host with 757 connections
1,796 Total connections

Chart
Table

Host	Count
127.0.0.1	105
192.168.0.114	3
192.168.0.216	116
192.168.0.74	16
192.168.1.145	1
192.168.1.15	22
192.168.1.20	21
192.168.1.239	56
192.168.1.90	6
192.168.2.126	18
192.168.3.199	38
192.168.4.142	757
192.168.4.33	70
192.168.4.98	330
[local]	237

Simultaneous sessions

Key values

13 sessions Session Peak
2026-02-15 15:58:48 Date

Histogram of session times

Key values

1,402 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	1,402	78.06%
500ms-1s	136	7.57%
1s-30s	218	12.14%
30s-1m	10	0.56%
1m-10m	6	0.33%
10m-30m	20	1.11%
30m-1h	0	0.00%
1h-8h	4	0.22%
> 8h	0	0.00%

Sessions per database

Key values

acaweb_fx Main Database
1,796 sessions Total

Chart
Table

Database	User	Count	Total Duration	Average Duration
acaweb_fx	1,725	20h8m46s	42s44ms
socialmedia	71	6m7s	5s171ms

Sessions per user

Key values

postgres Main User
1,796 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
postgres	1	0ms	0ms

Sessions per host

Key values

192.168.4.142 Main Host
1,796 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	105	3s375ms	32ms
192.168.0.114	3	15m	5m
192.168.0.216	116	8m26s	4s362ms
192.168.0.74	16	8m54s	33s399ms
192.168.1.145	1	18ms	18ms
192.168.1.15	22	7h30m30s	20m28s
192.168.1.20	21	11h59m51s	34m16s
192.168.1.239	56	311ms	5ms
192.168.1.90	6	49ms	8ms
192.168.2.126	18	5s160ms	286ms
192.168.3.199	38	21s698ms	571ms
192.168.4.142	757	7m23s	585ms
192.168.4.33	70	1m7s	957ms
192.168.4.98	330	14s972ms	45ms
[local]	237	2m55s	740ms

Sessions per application

Key values

unknown Main Host
1,796 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
unknown	1,796	20h14m53s	40s586ms

Checkpoints Buffers

Key values

22,871 buffers Checkpoint Peak
2026-02-15 15:06:42 Date
209.926 seconds Highest write time
0.004 seconds Sync time

Checkpoints Wal files

Key values

5 files Wal files usage Peak
2026-02-15 15:06:42 Date

Checkpoints distance

Key values

168.04 Mo Distance Peak
2026-02-15 15:06:42 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Feb 15	15	38,349	1,773.408s	0.031s	1,773.802s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Feb 15	15	0	0	18	1,342	0.004s	0s

Day	Hour	Count	Avg time (sec)
Feb 15	15	0	0s

Day	Hour	Mean distance	Mean estimate
Feb 15	15	22,614.85 kB	135,330.85 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (12) Main checkpoint cause
12 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	12
Total	12

Size of temporary files

Key values

102.15 MiB Temp Files size Peak
2026-02-15 15:32:19 Date

Number of temporary files

Key values

62 per second Temp Files Peak
2026-02-15 15:02:08 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Feb 15	15	678	3.23 GiB	4.88 MiB

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	48	217.05 MiB	4.50 MiB	4.55 MiB	4.52 MiB	select resultuid from relevance_fibonacci_results order by resultuid desc limit ?), fr as ( select a., rr.age, rr.relevant from fibonacci_results a left outer join relevance_fibonacci_results rr on a.resultuid = rr.resultuid where case when false = ? then true else a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) end), all_results as ( select fr.resultuid as resultuid, fr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, fr.pattern as pattern_name, fr.timed as timed, fr.patternendtime as identified, dtt.timezone as timezone, fr.patternlengthbars as length, g.basegroupname, newlevels.filtered, case when fr.age is not null then fr.age when fr.resultuid <= rm.resultuid then ? else ? end as age, case when fr.relevant is not null then fr.relevant when fr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from fr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = fr.symbolid inner join symbols s on fr.symbolid = s.symbolid and s.nonliquid = ? inner join symbolgroup sg on fr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join downloadersymbolsettings dss on fr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join rar_max rm on ? = ? left join lateral calc_fib_signal_filter (fr.resultuid) newlevels on true left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where fr.gmttimefound > now() - interval ? and dss.enabled = ? and s.deleted = ? and (fr.simulation = ? or fr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or fr.pattern in (...)) and (? = ? or fr.patternlengthbars <= ?) and (? = ? or (? = ? and fr.timed > cast(? as timestamp)) or (? = ? and fr.timed < cast(? as timestamp)))), results as ( select distinct on (symbolid) from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc; SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), fr AS ( SELECT a., rr.age, rr.relevant from fibonacci_results a LEFT OUTER JOIN relevance_fibonacci_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) END), all_results AS ( SELECT fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN fr.age IS NOT NULL THEN fr.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN fr.relevant IS NOT NULL THEN fr.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT JOIN LATERAL calc_fib_signal_filter (fr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($3 = 0 OR s.timegranularity in ($4, $5, $6, $7, $8, $9, $10)) AND ($11 = 0 OR s.exchange in ($12)) AND ($13 = 0 OR coalesce(bim.code, s.symbol) in ($14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226)) AND ($227 = 0 OR fr.pattern in ($228)) AND ($229 = 0 OR fr.patternlengthbars <= $230) AND ($231 = 0 OR ($232 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($233 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = $234 OR relevant = 1) AND ($235 = 0 OR age <= $236) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; Date: 2026-02-15 15:00:46 Duration: 0ms
2	24	82.91 MiB	3.45 MiB	3.45 MiB	3.45 MiB	jr.resultuid as resultuid, jr.direction as direction, jr.patternendtime as identified, jr.patternlengthbars as length, jr.patternstarttime as patternstarttime, case when jr.trendchangeid = ? then ? else ? end as trendchange, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, jp.patternname as pattern_name, dtt.timezone as timezone, ? as age, cps.pip, g.basegroupname from japsticks_results jr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = jr.symbolid inner join relevance_japsticks_results rar on rar.resultuid = jr.resultuid inner join symbols s on jr.symbolid = s.symbolid and s.nonliquid = ? inner join japsticks_patterns jp on jr.patternid = jp.id inner join downloadersymbolsettings dss on jr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on s.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where jr.gmttimefound > now() - interval ? and s.deleted = ? and (jr.simulation = ? or jr.simulation is null) and (rar.relevant = ?) --and (semicolon_age = ? or rar.age <= semicolon_age) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or jp.patternname in (...)) and (? = ? or jr.patternlengthbars <= ?) ), results as ( select distinct on (symbolid) * from all_results order by symbolid, resultuid ) select * from results order by identified desc, length desc ; jr.resultuid AS resultuid, jr.direction AS direction, jr.patternendtime AS identified, jr.patternlengthbars AS length, jr.patternstarttime AS patternstarttime, case when jr.trendchangeid = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; Date: 2026-02-15 15:02:22 Duration: 0ms
3	16	738.12 MiB	46.13 MiB	46.13 MiB	46.13 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-02-15 15:01:12 Duration: 0ms
4	16	1.22 GiB	78.30 MiB	78.30 MiB	78.30 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-02-15 15:01:15 Duration: 0ms
5	12	37.19 MiB	3.10 MiB	3.10 MiB	3.10 MiB	select resultuid from relevance_consecutivecandles_results order by resultuid desc limit ?), all_results as ( select ccr.resultuid as resultuid, ccr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, ccr.patternendtime as identified, dtt.timezone as timezone, ccr.qtyconsecutivecandles as length, g.basegroupname, case when rcr.age is not null then rcr.age when ccr.resultuid <= rm.resultuid then ? else ? end as age, case when rcr.relevant is not null then rcr.relevant when ccr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip, newlevels.filtered from consecutivecandles_results ccr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = ccr.symbolid inner join symbols s on ccr.symbolid = s.symbolid and s.nonliquid = ? inner join downloadersymbolsettings dss on ccr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on ccr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join rar_max rm on ? = ? left outer join relevance_consecutivecandles_results rcr on rcr.resultuid = ccr.resultuid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? left join lateral calc_cc_signal_filter (ccr.resultuid) newlevels on true where ccr.gmttimefound > now() - interval ? and s.deleted = ? and (ccr.simulation = ? or ccr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ccr.patternlengthbars <= ?)), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc; SELECT resultuid FROM relevance_consecutivecandles_results ORDER BY resultuid DESC LIMIT 1), all_results AS ( SELECT ccr.resultuid AS resultuid, ccr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, ccr.patternendtime AS identified, dtt.timezone AS timezone, ccr.qtyconsecutivecandles AS length, g.basegroupname, CASE WHEN rcr.age IS NOT NULL THEN rcr.age WHEN ccr.resultuid <= rm.resultuid THEN 1 ELSE 0 END as age, CASE WHEN rcr.relevant IS NOT NULL THEN rcr.relevant WHEN ccr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip, newLevels.filtered FROM consecutivecandles_results ccr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = ccr.symbolid INNER JOIN symbols s ON ccr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN downloadersymbolsettings dss ON ccr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on ccr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_consecutivecandles_results rcr ON rcr.resultuid = ccr.resultuid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' LEFT JOIN LATERAL calc_cc_signal_filter (ccr.resultuid) newLevels on true WHERE ccr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (ccr.simulation = 0 OR ccr.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3, $4, $5, $6, $7, $8, $9)) AND ($10 = 0 OR s.exchange in ($11)) AND ($12 = 0 OR coalesce(bim.code, s.symbol) in ($13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322)) AND ($323 = 0 OR ccr.patternlengthbars <= $324)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $325 OR relevant = 1) AND ($326 = 0 OR age <= $327) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; Date: 2026-02-15 15:02:32 Duration: 0ms
6	4	559.63 MiB	139.91 MiB	139.91 MiB	139.91 MiB	select updateresultsmaterializedview (); select updateresultsmaterializedview (); Date: 2026-02-15 15:02:12 Duration: 0ms
7	4	357.30 MiB	89.32 MiB	89.33 MiB	89.33 MiB	select updateageforrelevantresults (); select updateageforrelevantresults (); Date: 2026-02-15 15:02:04 Duration: 0ms
8	1	64.38 MiB	64.38 MiB	64.38 MiB	64.38 MiB	select cleanuppatternresultsrelevance (); select cleanuppatternresultsrelevance (); Date: 2026-02-15 15:00:06 Duration: 0ms

Queries generating the largest temporary files

Rank	Size	Query
1	139.91 MiB	select updateresultsmaterializedview (); [ Date: 2026-02-15 15:17:11 ]
2	139.91 MiB	select updateresultsmaterializedview (); [ Date: 2026-02-15 15:32:13 ]
3	139.91 MiB	select updateresultsmaterializedview (); [ Date: 2026-02-15 15:47:11 ]
4	139.91 MiB	select updateresultsmaterializedview (); [ Date: 2026-02-15 15:02:12 ]
5	89.33 MiB	select updateageforrelevantresults (); [ Date: 2026-02-15 15:02:04 ]
6	89.33 MiB	select updateageforrelevantresults (); [ Date: 2026-02-15 15:32:04 ]
7	89.32 MiB	select updateageforrelevantresults (); [ Date: 2026-02-15 15:47:04 ]
8	89.32 MiB	select updateageforrelevantresults (); [ Date: 2026-02-15 15:17:04 ]
9	78.30 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-02-15 15:01:15 ]
10	78.30 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-02-15 15:03:15 ]
11	78.30 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-02-15 15:05:15 ]
12	78.30 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-02-15 15:11:15 ]
13	78.30 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-02-15 15:16:15 ]
14	78.30 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-02-15 15:18:15 ]
15	78.30 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-02-15 15:20:15 ]
16	78.30 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-02-15 15:26:15 ]
17	78.30 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-02-15 15:31:15 ]
18	78.30 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-02-15 15:33:15 ]
19	78.30 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-02-15 15:35:15 ]
20	78.30 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-02-15 15:41:15 ]

Vacuums / Analyzes Distribution

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date
0 sec Highest CPU-cost analyze
Table
Database
Date

Analyzes per table

Key values

public.solr_relevance_old (16) Main table analyzed (database acaweb_fx)
46 analyzes Total

Chart
Table

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.public.latest_t15_candle_view	2
acaweb_fx.pg_catalog.pg_depend	2
acaweb_fx.pg_catalog.pg_index	1
acaweb_fx.public.prfsymboltree	1
acaweb_fx.public.mat_ps_hourly_symbolid_max_enddate	1
acaweb_fx.public.autochartist_symbolupdates	1
socialmedia.public.processes	1
acaweb_fx.public.mat_ps_daily_symbolid_max_enddate	1
acaweb_fx.public.latest_candle_datetime_per_receng	1
Total	46

Vacuums per table

Key values

public.solr_relevance_old (20) Main table vacuumed on database acaweb_fx
37 vacuums Total

Chart
Table

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
acaweb_fx.public.solr_relevance_old	20	18	15,237	0	62	0	164	8,774	292	2,572,257
acaweb_fx.pg_catalog.pg_type	3	3	544	0	70	0	0	208	64	284,479
acaweb_fx.pg_catalog.pg_attribute	3	3	2,840	0	323	0	201	1,124	372	2,072,070
acaweb_fx.public.datafeeds_latestrun	2	0	244	0	3	0	0	26	3	23,210
acaweb_fx.pg_catalog.pg_class	2	2	975	0	94	0	0	302	129	601,758
acaweb_fx.pg_catalog.pg_index	1	1	91	0	11	0	0	28	9	68,769
acaweb_fx.public.prfsymboltree	1	0	170	0	6	0	0	35	1	10,780
acaweb_fx.archive.patternresultsrelevance	1	1	7,690	0	4	0	0	4,676	2	597,350
acaweb_fx.public.solr_imports	1	1	56	0	2	0	0	6	4	14,459
acaweb_fx.pg_catalog.pg_statistic	1	1	1,028	0	192	0	606	503	173	678,548
acaweb_fx.pg_catalog.pg_depend	1	1	534	0	79	0	59	183	78	315,481
acaweb_fx.public.latest_t15_candle_view	1	1	94	0	1	0	0	6	1	9,061
Total	37	32	29,503	2,356	847	0	1,030	15,871	1,128	7,248,222

Tuples removed per table

Key values

archive.patternresultsrelevance (51861) Main table with removed tuples on database acaweb_fx
92311 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
acaweb_fx.archive.patternresultsrelevance	1	1	51,861	0	0	1,282	0
acaweb_fx.public.solr_relevance_old	20	18	31,949	146,889	16,692	0	4,140
acaweb_fx.pg_catalog.pg_attribute	3	3	5,732	33,577	1,572	20	798
acaweb_fx.pg_catalog.pg_type	3	3	977	4,514	176	0	132
acaweb_fx.pg_catalog.pg_depend	1	1	674	14,316	0	0	142
acaweb_fx.pg_catalog.pg_statistic	1	1	656	3,982	0	0	1,194
acaweb_fx.pg_catalog.pg_class	2	2	210	3,298	0	0	300
acaweb_fx.public.datafeeds_latestrun	2	0	121	28	0	0	32
acaweb_fx.public.latest_t15_candle_view	1	1	60	14	0	0	1
acaweb_fx.public.solr_imports	1	1	52	1	0	0	2
acaweb_fx.pg_catalog.pg_index	1	1	19	825	12	0	22
acaweb_fx.public.prfsymboltree	1	0	0	2,058	0	0	30
Total	37	32	92,311	209,502	18,452	1,302	6,793

Pages removed per table

Key values

archive.patternresultsrelevance (1282) Main table with removed pages on database acaweb_fx
1302 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
acaweb_fx.archive.patternresultsrelevance	1	1	51861	1282
acaweb_fx.pg_catalog.pg_attribute	3	3	5732	20
acaweb_fx.pg_catalog.pg_index	1	1	19	0
acaweb_fx.public.prfsymboltree	1	0	0	0
acaweb_fx.pg_catalog.pg_type	3	3	977	0
acaweb_fx.public.datafeeds_latestrun	2	0	121	0
acaweb_fx.public.solr_imports	1	1	52	0
acaweb_fx.pg_catalog.pg_statistic	1	1	656	0
acaweb_fx.pg_catalog.pg_depend	1	1	674	0
acaweb_fx.public.latest_t15_candle_view	1	1	60	0
acaweb_fx.public.solr_relevance_old	20	18	31949	0
acaweb_fx.pg_catalog.pg_class	2	2	210	0
Total	37	32	92,311	1,302

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Feb 15	15	37	46

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

NO DATASET

Type	Object	Count	Total Duration	Average Duration (s)
NO DATASET

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 by type

Key values

15,256 Total read queries
15,831 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	15,256	22.83%
INSERT	12,270	18.36%
UPDATE	622	0.93%
DELETE	16	0.02%
COPY FROM	96	0.14%
COPY TO	26	0.04%
CTE	2,109	3.16%
DDL	16	0.02%
TCL	676	1.01%
CURSOR	0	0.00%
OTHERS	35,728	53.47%

Queries by database

Key values

unknown Main database
65,860 Requests
1h17m36s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
acaweb_fx	Total	884	0ms
	copy from	80	0ms
	copy to	26	0ms
	cte	100	0ms
	ddl	16	0ms
	delete	16	0ms
	others	214	0ms
	select	65	0ms
	tcl	332	0ms
	update	35	0ms
socialmedia	Total	71	0ms
	select	70	0ms
	tcl	1	0ms
unknown	Total	65,860	1h17m36s
	copy from	16	0ms
	cte	2,009	0ms
	insert	12,270	0ms
	others	2,107	0ms
	select	15,121	0ms
	tcl	343	0ms
	update	587	0ms

Queries by user

Key values

unknown Main user
65,860 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	955	0ms
	copy from	80	0ms
	copy to	26	0ms
	cte	100	0ms
	ddl	16	0ms
	delete	16	0ms
	others	214	0ms
	select	135	0ms
	tcl	333	0ms
	update	35	0ms
unknown	Total	65,860	1h17m36s
	copy from	16	0ms
	cte	2,009	0ms
	insert	12,270	0ms
	others	2,107	0ms
	select	15,121	0ms
	tcl	343	0ms
	update	587	0ms

Duration by user

Key values

1h17m36s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	955	0ms
	copy from	80	0ms
	copy to	26	0ms
	cte	100	0ms
	ddl	16	0ms
	delete	16	0ms
	others	214	0ms
	select	135	0ms
	tcl	333	0ms
	update	35	0ms
unknown	Total	65,860	1h17m36s
	copy from	16	0ms
	cte	2,009	0ms
	insert	12,270	0ms
	others	2,107	0ms
	select	15,121	0ms
	tcl	343	0ms
	update	587	0ms

Queries by host

Key values

unknown Main host
66,815 Requests
1h17m36s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	66,815	1h17m36s
	copy from	96	0ms
	copy to	26	0ms
	cte	2,109	0ms
	ddl	16	0ms
	delete	16	0ms
	insert	12,270	0ms
	others	2,321	0ms
	select	15,256	0ms
	tcl	676	0ms
	update	622	0ms

Queries by application

Key values

unknown Main application
66,473 Requests
1h17m36s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
psql	Total	342	0ms
	copy from	80	0ms
	copy to	26	0ms
	cte	100	0ms
	ddl	16	0ms
	delete	16	0ms
	others	4	0ms
	select	65	0ms
	update	35	0ms
unknown	Total	66,473	1h17m36s
	copy from	16	0ms
	cte	2,009	0ms
	insert	12,270	0ms
	others	2,317	0ms
	select	15,191	0ms
	tcl	676	0ms
	update	587	0ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-02-15 15:17:37 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

23,330 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	23,330	69.84%
1-5ms	8,053	24.11%
5-10ms	231	0.69%
10-25ms	384	1.15%
25-50ms	234	0.70%
50-100ms	138	0.41%
100-500ms	217	0.65%
500-1000ms	71	0.21%
1000-10000ms	621	1.86%
> 10000ms	128	0.38%

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

12

Details

0ms

select key, value from datasources ds inner join datasourceparams dsp on ds.id = dsp.datasourceid where ds.name = ?;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Feb 15	15	12	0ms	0ms

2

0ms

168

Details

0ms

with rar_max as ( select resultuid from relevance_consecutivecandles_results order by resultuid desc limit ? ), all_results as ( select ccr.resultuid as resultuid, ccr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, ccr.patternendtime as identified, dtt.timezone as timezone, ccr.qtyconsecutivecandles as length, g.basegroupname, case when rcr.age is not null then rcr.age when ccr.resultuid <= rm.resultuid then ? else ? end as age, case when rcr.relevant is not null then rcr.relevant when ccr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip, newlevels.filtered from consecutivecandles_results ccr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = ccr.symbolid inner join symbols s on ccr.symbolid = s.symbolid and s.nonliquid = ? inner join downloadersymbolsettings dss on ccr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on ccr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join rar_max rm on ? = ? left outer join relevance_consecutivecandles_results rcr on rcr.resultuid = ccr.resultuid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? left join lateral calc_cc_signal_filter (ccr.resultuid) newlevels on true where ccr.gmttimefound > now() - interval ? and s.deleted = ? and (ccr.simulation = ? or ccr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ccr.patternlengthbars <= ?) ), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Feb 15	15	168	0ms	0ms

3

0ms

2,414

Details

0ms

insert into t60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Feb 15	15	2,414	0ms	0ms

4

0ms

31

Details

0ms

select case when a.old_resultuid = ? then a.old_resultuid else a.resultuid end as resultuid, s.symbol, timegranularity as interval, direction as direction, patternendtime as patternendtime, patternstartprice as psp, patternendprice as pep, target03 as t03, target16 as t16, patternlengthbars as length, p.patternname as patternname, dtt.timezone, cps.pip from fibonacci_results a inner join downloadersymbolsettings dss on a.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join fibonaccipatterns p on a.pattern = p.patternname left join currencypips cps on cps.symbol = s.symbol where (a.old_resultuid = ? or a.resultuid = ?) and dtt.dayofweek = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 15	15	31	0ms	0ms

5

0ms

186

Details

0ms

update patternresultsrelevance set relevant = ?, saxo_relevant = ?, notrelevantpricedatetime = ?, reason = ? where uniqueindex = ? and relevant = ?;

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Feb 15	15	186	0ms	0ms

6

0ms

1

Details

0ms

insert into resultmedia (processresultsid, type, name, filename) values (?, ?, ?, ?) returning id;

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Feb 15	15	1	0ms	0ms

7

0ms

18

Details

0ms

select cast(count(*) / cast(setting as numeric) * ? as int) from pg_stat_activity, pg_settings where name = ? group by setting;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Feb 15	15	18	0ms	0ms

8

0ms

237

Details

0ms

select v.datname, c.relname, v.phase, v.heap_blks_total, v.heap_blks_scanned, v.heap_blks_vacuumed, v.index_vacuum_count, v.max_dead_tuples, v.num_dead_tuples from pg_stat_progress_vacuum as v join pg_class c on c.oid = v.relid;

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Feb 15	15	237	0ms	0ms

9

0ms

19

Details

0ms

select * from ( select pricedatetime, open, high, low, close, volume, bsf from t60 where symbolid = ? and (bsf = ? or bsf is null) order by pricedatetime desc limit ?) a order by pricedatetime asc;

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Feb 15	15	19	0ms	0ms

10

0ms

338

Details

0ms

commit;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Feb 15	15	338	0ms	0ms

11

0ms

3

Details

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 #11

Day	Hour	Count	Duration	Avg duration
Feb 15	15	3	0ms	0ms

12

0ms

240

Details

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
Feb 15	15	240	0ms	0ms

13

0ms

237

Details

0ms

select count(*), sum(size), extract(epoch from now() - min(modification)) from pg_ls_waldir ();

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Feb 15	15	237	0ms	0ms

14

0ms

10

Details

0ms

select * from ( select pricedatetime, open, high, low, close, volume, bsf from t30 where symbolid = ? and (bsf = ? or bsf is null) order by pricedatetime desc limit ?) a order by pricedatetime asc;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Feb 15	15	10	0ms	0ms

15

0ms

6

Details

0ms

select pid, datname, client_addr from pg_stat_activity where query ilike ? and pid <> pg_backend_pid() and state = ? and datname = ?;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Feb 15	15	6	0ms	0ms

16

0ms

1

Details

0ms

select name, value from systemsettings limit ? offset ?;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Feb 15	15	1	0ms	0ms

17

0ms

10

Details

0ms

update executions set isrunning = false, has_results = false, response = ? where id = ?;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Feb 15	15	10	0ms	0ms

18

0ms

237

Details

0ms

select system_identifier from pg_control_system ();

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Feb 15	15	237	0ms	0ms

19

0ms

3

Details

0ms

select groupid, exchange, groupname, symbol, longname from prfsymboltree where brokerid = ? order by groupname, symbol;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Feb 15	15	3	0ms	0ms

20

0ms

237

Details

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 #20

Day	Hour	Count	Duration	Avg duration
Feb 15	15	237	0ms	0ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

3,798

Details

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
Feb 15	15	3,798	0ms	0ms

2

3,661

Details

0ms

select ?;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Feb 15	15	3,661	0ms	0ms

3

2,819

Details

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 #3

Day	Hour	Count	Duration	Avg duration
Feb 15	15	2,819	0ms	0ms

4

2,446

Details

0ms

insert into t30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 15	15	2,446	0ms	0ms

5

2,414

Details

0ms

insert into t60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Feb 15	15	2,414	0ms	0ms

6

1,461

Details

0ms

select distinct on (coalesce(bim.code, s.symbol) , s.exchange, s.timegranularity, df.timezone) s.symbolid as id, coalesce(bim.code, s.symbol) as name, s.symbol as symbol, dss.downloadersymbol as ticker, s.exchange as exchange, s.timegranularity as interval, df.timezone as timezone from symbols s inner join downloadersymbolsettings dss on dss.symbolid = s.symbolid inner join datafeedstimetable df on df.classname ilike dss.classname left join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = s.symbolid left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = ? and bim.type = ? where s.symbolid = ?;

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Feb 15	15	1,461	0ms	0ms

7

1,327

Details

0ms

select s.symbolid as id, s.symbol as name, s.exchange as exchange, s.timegranularity as interval, dtt.timezone as timezone from symbols s inner join downloadersymbolsettings dss on dss.symbolid = s.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where bsl.brokerid = ? and (? = ? or s.timegranularity = ?) and (s.symbol = ? or dss.downloadersymbol = ?) and dss.enabled = ?;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Feb 15	15	1,327	0ms	0ms

8

971

Details

0ms

select datetimeupdate from latest_candle_datetime_per_receng where recognitionengine ilike ?;

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Feb 15	15	971	0ms	0ms

9

829

Details

0ms

set extra_float_digits = ?;

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Feb 15	15	829	0ms	0ms

10

817

Details

0ms

set application_name = ?;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Feb 15	15	817	0ms	0ms

11

592

Details

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 #11

Day	Hour	Count	Duration	Avg duration
Feb 15	15	592	0ms	0ms

12

338

Details

0ms

commit;

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Feb 15	15	338	0ms	0ms

13

338

Details

0ms

begin;

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Feb 15	15	338	0ms	0ms

14

332

Details

0ms

update datafeeds_latestrun set latestrxtime = subquery.latestrxtime, latestdbwritetime = subquery.latestdbwritetime from ( select latestrxtime, latestdbwritetime from latest_t15_candle_view where classname ilike ?) as subquery where datafeeds_latestrun.feedname ilike ?;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Feb 15	15	332	0ms	0ms

15

240

Details

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 #15

Day	Hour	Count	Duration	Avg duration
Feb 15	15	240	0ms	0ms

16

240

Details

0ms

with rar_max as ( 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;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Feb 15	15	240	0ms	0ms

17

240

Details

0ms

with rar_max as ( select resultuid from relevance_autochartist_results order by resultuid desc limit ? ), ar as ( select a.*, rr.age, rr.relevant from autochartist_results a left outer join relevance_autochartist_results rr on a.resultuid = rr.resultuid where case when false = ? then true else a.resultuid > ( select min(resultuid) from relevance_autochartist_results) end ), all_results as ( select ar.resultuid as resultuid, ar.direction as direction, ar.predictiontimeto as predictiontimeto, ar.predictionpricefrom as predictionpricefrom, ar.predictionpriceto as predictionpriceto, cp.pip as pip, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, ar.pattern as pattern_name, ar.breakout as breakout, ar.patternendtime as identified, dtt.timezone as timezone, ar.patternlengthbars as length, g.basegroupname, newlevels.profit, newlevels.stop, newlevels.filtered, case when ar.age is not null then ar.age when ar.resultuid <= rm.resultuid then ? else ? end as age, case when ar.relevant is not null then ar.relevant when ar.resultuid <= rm.resultuid then ? else ? end as relevant from ar inner join symbols s on ar.symbolid = s.symbolid and s.nonliquid = ? inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = s.symbolid inner join symbolgroup sg on bsl.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join downloadersymbolsettings dss on sg.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join rar_max rm on ? = ? left outer join autochartist_symbolupdates au on dss.symbolid = au.symbolid left outer join currencypips cp on s.symbol = cp.symbol left join lateral calc_cp_signal (ar.resultuid) newlevels on true left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where ar.gmttimefound > now() - interval ? and dss.enabled = ? and s.deleted = ? and (ar.simulation = ? or ar.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ar.pattern in (...)) and (? = ? or (? = ? and ar.breakout >= ?) or (? = ? and ar.breakout < ?)) and (? = ? or ar.patternlengthbars <= ?) and newlevels.filtered = false and ar.patternstarttime >= coalesce(au.earliestpricedatetime, ?::timestamp without time zone) -- to make sure patternstarttime is in our t-tables ), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Feb 15	15	240	0ms	0ms

18

237

Details

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 #18

Day	Hour	Count	Duration	Avg duration
Feb 15	15	237	0ms	0ms

19

237

Details

0ms

select count(*), sum(size), extract(epoch from now() - min(modification)) from pg_ls_waldir ();

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Feb 15	15	237	0ms	0ms

20

237

Details

0ms

select system_identifier from pg_control_system ();

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 15	15	237	0ms	0ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

12

Details

0ms

select key, value from datasources ds inner join datasourceparams dsp on ds.id = dsp.datasourceid where ds.name = ?;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Feb 15	15	12	0ms	0ms

2

0ms

168

Details

0ms

with rar_max as ( select resultuid from relevance_consecutivecandles_results order by resultuid desc limit ? ), all_results as ( select ccr.resultuid as resultuid, ccr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, ccr.patternendtime as identified, dtt.timezone as timezone, ccr.qtyconsecutivecandles as length, g.basegroupname, case when rcr.age is not null then rcr.age when ccr.resultuid <= rm.resultuid then ? else ? end as age, case when rcr.relevant is not null then rcr.relevant when ccr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip, newlevels.filtered from consecutivecandles_results ccr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = ccr.symbolid inner join symbols s on ccr.symbolid = s.symbolid and s.nonliquid = ? inner join downloadersymbolsettings dss on ccr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on ccr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join rar_max rm on ? = ? left outer join relevance_consecutivecandles_results rcr on rcr.resultuid = ccr.resultuid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? left join lateral calc_cc_signal_filter (ccr.resultuid) newlevels on true where ccr.gmttimefound > now() - interval ? and s.deleted = ? and (ccr.simulation = ? or ccr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ccr.patternlengthbars <= ?) ), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Feb 15	15	168	0ms	0ms

3

0ms

2,414

Details

0ms

insert into t60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Feb 15	15	2,414	0ms	0ms

4

0ms

31

Details

0ms

select case when a.old_resultuid = ? then a.old_resultuid else a.resultuid end as resultuid, s.symbol, timegranularity as interval, direction as direction, patternendtime as patternendtime, patternstartprice as psp, patternendprice as pep, target03 as t03, target16 as t16, patternlengthbars as length, p.patternname as patternname, dtt.timezone, cps.pip from fibonacci_results a inner join downloadersymbolsettings dss on a.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join fibonaccipatterns p on a.pattern = p.patternname left join currencypips cps on cps.symbol = s.symbol where (a.old_resultuid = ? or a.resultuid = ?) and dtt.dayofweek = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 15	15	31	0ms	0ms

5

0ms

186

Details

0ms

update patternresultsrelevance set relevant = ?, saxo_relevant = ?, notrelevantpricedatetime = ?, reason = ? where uniqueindex = ? and relevant = ?;

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Feb 15	15	186	0ms	0ms

6

0ms

1

Details

0ms

insert into resultmedia (processresultsid, type, name, filename) values (?, ?, ?, ?) returning id;

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Feb 15	15	1	0ms	0ms

7

0ms

18

Details

0ms

select cast(count(*) / cast(setting as numeric) * ? as int) from pg_stat_activity, pg_settings where name = ? group by setting;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Feb 15	15	18	0ms	0ms

8

0ms

237

Details

0ms

select v.datname, c.relname, v.phase, v.heap_blks_total, v.heap_blks_scanned, v.heap_blks_vacuumed, v.index_vacuum_count, v.max_dead_tuples, v.num_dead_tuples from pg_stat_progress_vacuum as v join pg_class c on c.oid = v.relid;

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Feb 15	15	237	0ms	0ms

9

0ms

19

Details

0ms

select * from ( select pricedatetime, open, high, low, close, volume, bsf from t60 where symbolid = ? and (bsf = ? or bsf is null) order by pricedatetime desc limit ?) a order by pricedatetime asc;

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Feb 15	15	19	0ms	0ms

10

0ms

338

Details

0ms

commit;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Feb 15	15	338	0ms	0ms

11

0ms

3

Details

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 #11

Day	Hour	Count	Duration	Avg duration
Feb 15	15	3	0ms	0ms

12

0ms

240

Details

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
Feb 15	15	240	0ms	0ms

13

0ms

237

Details

0ms

select count(*), sum(size), extract(epoch from now() - min(modification)) from pg_ls_waldir ();

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Feb 15	15	237	0ms	0ms

14

0ms

10

Details

0ms

select * from ( select pricedatetime, open, high, low, close, volume, bsf from t30 where symbolid = ? and (bsf = ? or bsf is null) order by pricedatetime desc limit ?) a order by pricedatetime asc;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Feb 15	15	10	0ms	0ms

15

0ms

6

Details

0ms

select pid, datname, client_addr from pg_stat_activity where query ilike ? and pid <> pg_backend_pid() and state = ? and datname = ?;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Feb 15	15	6	0ms	0ms

16

0ms

1

Details

0ms

select name, value from systemsettings limit ? offset ?;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Feb 15	15	1	0ms	0ms

17

0ms

10

Details

0ms

update executions set isrunning = false, has_results = false, response = ? where id = ?;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Feb 15	15	10	0ms	0ms

18

0ms

237

Details

0ms

select system_identifier from pg_control_system ();

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Feb 15	15	237	0ms	0ms

19

0ms

3

Details

0ms

select groupid, exchange, groupname, symbol, longname from prfsymboltree where brokerid = ? order by groupname, symbol;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Feb 15	15	3	0ms	0ms

20

0ms

237

Details

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 #20

Day	Hour	Count	Duration	Avg duration
Feb 15	15	237	0ms	0ms

Time consuming prepare


Date: 2026-02-15 15:00:53
Duration: 2ms
Database: postgres
Date: 2026-02-15 15:20:13
Duration: 6ms
Database: postgres
Date: 2026-02-15 15:10:28
Duration: 0ms
Database: postgres
Date: 2026-02-15 15:40:55
Duration: 0ms
Database: postgres
Date: 2026-02-15 15:00:33
Duration: 1ms
Database: postgres
Date: 2026-02-15 15:20:13
Duration: 0ms
Database: postgres
Date: 2026-02-15 15:56:52
Duration: 0ms
Database: postgres
Date: 2026-02-15 15:03:20
Duration: 1ms
Database: postgres
Date: 2026-02-15 15:21:01
Duration: 3ms
Database: postgres
Date: 2026-02-15 15:02:23
Duration: 0ms
Database: postgres
Date: 2026-02-15 15:50:04
Duration: 2ms
Database: postgres
Date: 2026-02-15 15:31:24
Duration: 0ms
Database: postgres
Date: 2026-02-15 15:02:53
Duration: 0ms
Database: postgres
Date: 2026-02-15 15:12:46
Duration: 1ms
Database: postgres
Date: 2026-02-15 15:15:02
Duration: 1ms
Database: postgres
Date: 2026-02-15 15:07:52
Duration: 1ms
Database: postgres
Date: 2026-02-15 15:04:02
Duration: 1ms
Database: postgres
Date: 2026-02-15 15:05:58
Duration: 1ms
Database: postgres
Date: 2026-02-15 15:26:00
Duration: 0ms
Database: postgres
Date: 2026-02-15 15:54:54
Duration: 0ms
Database: postgres

Time consuming bind

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

14s521ms

1,202

Details

0ms

60ms

12ms

WITH rar_max as ( ;

Times Reported Time consuming bind #1

Day	Hour	Count	Duration	Avg duration
Feb 15	15	1,202	14s521ms	12ms

WITH rar_max as ( ;

Date: 2026-02-15 15:50:52 Duration: 60ms Database: postgres parameters: $1 = 't', $2 = '667', $3 = '7', $4 = '15', $5 = '30', $6 = '60', $7 = '120', $8 = '240', $9 = '480', $10 = '1440', $11 = '0', $12 = '', $13 = '0', $14 = '', $15 = '0', $16 = '', $17 = '0', $18 = '0', $19 = '0', $20 = '700', $21 = '700', $22 = 't', $23 = '10', $24 = '10'
WITH rar_max as ( ;

Date: 2026-02-15 15:46:25 Duration: 54ms Database: postgres parameters: $1 = 't', $2 = '667', $3 = '7', $4 = '15', $5 = '30', $6 = '60', $7 = '120', $8 = '240', $9 = '480', $10 = '1440', $11 = '0', $12 = '', $13 = '84', $14 = 'AUDCAD', $15 = 'AUDCHF', $16 = 'AUDJPY', $17 = 'AUDNZD', $18 = 'AUDSGD', $19 = 'CADCHF', $20 = 'CADJPY', $21 = 'CHFJPY', $22 = 'EURAUD', $23 = 'EURCAD', $24 = 'EURCHF', $25 = 'EURCZK', $26 = 'EURGBP', $27 = 'EURHUF', $28 = 'EURJPY', $29 = 'EURNOK', $30 = 'EURNZD', $31 = 'EURPLN', $32 = 'EURSEK', $33 = 'EURSGD', $34 = 'EURTRY', $35 = 'EURZAR', $36 = 'GBPAUD', $37 = 'GBPCAD', $38 = 'GBPCHF', $39 = 'GBPJPY', $40 = 'GBPNZD', $41 = 'GBPPLN', $42 = 'GBPSEK', $43 = 'GBPSGD', $44 = 'NZDCAD', $45 = 'NZDCHF', $46 = 'NZDJPY', $47 = 'NZDSGD', $48 = 'USDCNH', $49 = 'USDCZK', $50 = 'USDHUF', $51 = 'USDNOK', $52 = 'USDPLN', $53 = 'USDSEK', $54 = 'USDSGD', $55 = 'USDTRY', $56 = 'USDZAR', $57 = 'WTI', $58 = 'XBRUSD', $59 = 'XTIUSD', $60 = 'BTCUSD', $61 = 'XAGAUD', $62 = 'XAGUSD', $63 = 'XAUAUD', $64 = 'XAUUSD', $65 = 'XPTUSD', $66 = 'XPDUSD', $67 = 'AUDUSD', $68 = 'EURUSD', $69 = 'GBPUSD', $70 = 'NZDUSD', $71 = 'USDCAD', $72 = 'USDCHF', $73 = 'USDHKD', $74 = 'USDJPY', $75 = 'AUS200', $76 = 'CHINA300', $77 = 'CHINA50', $78 = 'DJ30', $79 = 'ESP35t', $80 = 'EUR50', $81 = 'EURO50', $82 = 'FRA40', $83 = 'GDAXI', $84 = 'GDAXIm', $85 = 'HK50', $86 = 'ITA40', $87 = 'J225', $88 = 'JP225', $89 = 'NAS100', $90 = 'SING30', $91 = 'SPA35', $92 = 'STOXX50', $93 = 'SUI20', $94 = 'UK100', $95 = 'US100', $96 = 'US30', $97 = 'US500', $98 = '0', $99 = '', $100 = '0', $101 = '0', $102 = '0', $103 = '500', $104 = '500', $105 = 't', $106 = '10', $107 = '10'
WITH rar_max as ( ;

Date: 2026-02-15 15:51:00 Duration: 47ms Database: postgres parameters: $1 = 't', $2 = '667', $3 = '7', $4 = '15', $5 = '30', $6 = '60', $7 = '120', $8 = '240', $9 = '480', $10 = '1440', $11 = '0', $12 = '', $13 = '0', $14 = '', $15 = '0', $16 = '', $17 = '700', $18 = '700', $19 = '0', $20 = '0', $21 = '0', $22 = 't', $23 = '10', $24 = '10'

2

1s763ms

687

Details

1ms

3ms

2ms

SELECT symbolid, ;

Times Reported Time consuming bind #2

Day	Hour	Count	Duration	Avg duration
	15	687	1s763ms	2ms

SELECT symbolid, ;

Date: 2026-02-15 15:31:26 Duration: 3ms Database: postgres parameters: $1 = 'PEPPERSTONEMT5', $2 = '15', $3 = 'SPY.US', $4 = 'INTC.US', $5 = 'ORCL.US', $6 = 'PTON.US', $7 = 'TMUS.US', $8 = 'UBER.US', $9 = 'SPCE.US', $10 = 'META.US', $11 = 'T.US', $12 = 'MRNA.US', $13 = 'TSLA.US', $14 = 'MA.US', $15 = 'PFE.US', $16 = 'NVDA.US', $17 = 'MCD.US', $18 = 'LMT.US', $19 = 'GS.US', $20 = 'GOOG.US', $21 = 'IBM.US', $22 = 'JPM.US', $23 = 'QCOM.US', $24 = 'NFLX.US', $25 = 'PLTR.US', $26 = 'SNAP.US', $27 = 'MSFT.US', $28 = 'PYPL.US', $29 = 'PG.US', $30 = 'NKE.US'
SELECT symbolid, ;

Date: 2026-02-15 15:30:52 Duration: 3ms Database: postgres parameters: $1 = 'GLOBALGTMT5', $2 = '15', $3 = '#AAPL'
SELECT symbolid, ;

Date: 2026-02-15 15:02:26 Duration: 3ms Database: postgres parameters: $1 = 'BDSWISS', $2 = '60', $3 = '#BA', $4 = '#APPL', $5 = '#AMZN', $6 = '#BABA'

3

1s78ms

3,347

Details

0ms

6ms

0ms

SELECT ;

Times Reported Time consuming bind #3

Day	Hour	Count	Duration	Avg duration
	15	3,347	1s78ms	0ms

SELECT ;

Date: 2026-02-15 15:00:15 Duration: 6ms Database: postgres parameters: $1 = '515840243198780300'
SELECT ;

Date: 2026-02-15 15:54:54 Duration: 6ms Database: postgres parameters: $1 = '500991628203869200'
SELECT ;

Date: 2026-02-15 15:00:15 Duration: 5ms Database: postgres parameters: $1 = '515840243198780300'

4

292ms

45

Details

4ms

14ms

6ms

WITH last_candle AS ( ;

Times Reported Time consuming bind #4

Day	Hour	Count	Duration	Avg duration
	15	45	292ms	6ms

WITH last_candle AS ( ;

Date: 2026-02-15 15:24:01 Duration: 14ms Database: postgres parameters: $1 = '667', $2 = '667'
WITH last_candle AS ( ;

Date: 2026-02-15 15:52:00 Duration: 9ms Database: postgres parameters: $1 = '558', $2 = '558'
WITH last_candle AS ( ;

Date: 2026-02-15 15:52:00 Duration: 9ms Database: postgres parameters: $1 = '558', $2 = '558'

5

228ms

141

Details

1ms

2ms

1ms

SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;

Times Reported Time consuming bind #5

Day	Hour	Count	Duration	Avg duration
	15	141	228ms	1ms

SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;

Date: 2026-02-15 15:15:44 Duration: 2ms Database: postgres parameters: $1 = 'AXIORY'
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;

Date: 2026-02-15 15:00:33 Duration: 2ms Database: postgres parameters: $1 = 'BDSWISS'
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;

Date: 2026-02-15 15:02:10 Duration: 2ms Database: postgres parameters: $1 = 'MILLENNIUMPF'

6

204ms

2,414

Details

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
	15	2,414	204ms	0ms

INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-15 15:10:28 Duration: 0ms Database: postgres parameters: $1 = '2026-02-13 21:00:00', $2 = '110.51', $3 = '110.85', $4 = '110.02', $5 = '110.13', $6 = '4173', $7 = '515840247879403300', $8 = '0', $9 = '2026-02-15 15:10:28.762', $10 = '2026-02-15 15:10:28.697', $11 = '110.51', $12 = '110.85', $13 = '110.02', $14 = '110.13', $15 = '4173', $16 = '0', $17 = '2026-02-15 15:10:28.762', $18 = '2026-02-15 15:10:28.697'
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-15 15:17:09 Duration: 0ms Database: postgres parameters: $1 = '2026-02-14 00:00:00', $2 = '0.86953', $3 = '0.869775', $4 = '0.86911', $5 = '0.86924', $6 = '2317', $7 = '515840249376834300', $8 = '0', $9 = '2026-02-15 15:17:09.118', $10 = '2026-02-15 15:17:09.117', $11 = '0.86953', $12 = '0.869775', $13 = '0.86911', $14 = '0.86924', $15 = '2317', $16 = '0', $17 = '2026-02-15 15:17:09.118', $18 = '2026-02-15 15:17:09.117'
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-15 15:11:57 Duration: 0ms Database: postgres parameters: $1 = '2026-02-13 22:00:00', $2 = '49531.9', $3 = '49556.1', $4 = '49347', $5 = '49451.6', $6 = '29211', $7 = '515840248000890300', $8 = '0', $9 = '2026-02-15 15:11:57.491', $10 = '2026-02-15 15:11:57.41', $11 = '49531.9', $12 = '49556.1', $13 = '49347', $14 = '49451.6', $15 = '29211', $16 = '0', $17 = '2026-02-15 15:11:57.491', $18 = '2026-02-15 15:11:57.41'

7

184ms

11

Details

0ms

25ms

16ms

with wh_patitioned as ( ;

Times Reported Time consuming bind #7

Day	Hour	Count	Duration	Avg duration
	15	11	184ms	16ms

with wh_patitioned as ( ;

Date: 2026-02-15 15:15:02 Duration: 25ms Database: postgres parameters: $1 = '558', $2 = '558', $3 = '558', $4 = '558', $5 = '558', $6 = '558', $7 = '558', $8 = '558', $9 = '558'
with wh_patitioned as ( ;

Date: 2026-02-15 15:50:02 Duration: 23ms Database: postgres parameters: $1 = '558', $2 = '558', $3 = '558', $4 = '558', $5 = '558', $6 = '558', $7 = '558', $8 = '558', $9 = '558'
with wh_patitioned as ( ;

Date: 2026-02-15 15:25:02 Duration: 23ms Database: postgres parameters: $1 = '558', $2 = '558', $3 = '558', $4 = '558', $5 = '558', $6 = '558', $7 = '558', $8 = '558', $9 = '558'

8

177ms

2,446

Details

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
	15	2,446	177ms	0ms

INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-15 15:40:55 Duration: 0ms Database: postgres parameters: $1 = '2026-02-13 23:00:00', $2 = '49452.55', $3 = '49489.25', $4 = '49439.55', $5 = '49449.75', $6 = '4581', $7 = '515840248000726300', $8 = '0', $9 = '2026-02-15 15:40:55.903', $10 = '2026-02-15 15:40:55.819', $11 = '49452.55', $12 = '49489.25', $13 = '49439.55', $14 = '49449.75', $15 = '4581', $16 = '0', $17 = '2026-02-15 15:40:55.903', $18 = '2026-02-15 15:40:55.819'
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-15 15:40:39 Duration: 0ms Database: postgres parameters: $1 = '2026-02-13 21:00:00', $2 = '8962.55', $3 = '8964.95', $4 = '8953.4', $5 = '8956.5', $6 = '3960', $7 = '515840248015340300', $8 = '0', $9 = '2026-02-15 15:40:39.742', $10 = '2026-02-15 15:40:39.651', $11 = '8962.55', $12 = '8964.95', $13 = '8953.4', $14 = '8956.5', $15 = '3960', $16 = '0', $17 = '2026-02-15 15:40:39.742', $18 = '2026-02-15 15:40:39.651'
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-15 15:40:51 Duration: 0ms Database: postgres parameters: $1 = '2026-02-13 18:00:00', $2 = '26526.5', $3 = '26553.3', $4 = '26497.8', $5 = '26538.3', $6 = '9022', $7 = '515840247933633300', $8 = '0', $9 = '2026-02-15 15:40:51.831', $10 = '2026-02-15 15:40:51.759', $11 = '26526.5', $12 = '26553.3', $13 = '26497.8', $14 = '26538.3', $15 = '9022', $16 = '0', $17 = '2026-02-15 15:40:51.831', $18 = '2026-02-15 15:40:51.759'

9

134ms

2,819

Details

0ms

INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Times Reported Time consuming bind #9

Day	Hour	Count	Duration	Avg duration
	15	2,819	134ms	0ms

INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-15 15:32:23 Duration: 0ms Database: postgres parameters: $1 = '2026-02-14 00:45:00', $2 = '67.26', $3 = '67.33', $4 = '67.185', $5 = '67.185', $6 = '69', $7 = '515840249389884300', $8 = '0', $9 = '2026-02-15 15:32:23.305', $10 = '2026-02-15 15:32:23.257', $11 = '67.26', $12 = '67.33', $13 = '67.185', $14 = '67.185', $15 = '69', $16 = '0', $17 = '2026-02-15 15:32:23.305', $18 = '2026-02-15 15:32:23.257'
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-15 15:32:08 Duration: 0ms Database: postgres parameters: $1 = '2026-02-13 22:45:00', $2 = '0.96279', $3 = '0.963495', $4 = '0.96278', $5 = '0.96344', $6 = '1499', $7 = '515840230419121300', $8 = '0', $9 = '2026-02-15 15:32:08.961', $10 = '2026-02-15 15:32:08.898', $11 = '0.96279', $12 = '0.963495', $13 = '0.96278', $14 = '0.96344', $15 = '1499', $16 = '0', $17 = '2026-02-15 15:32:08.961', $18 = '2026-02-15 15:32:08.898'
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-15 15:33:46 Duration: 0ms Database: postgres parameters: $1 = '2026-02-13 23:30:00', $2 = '57459.5', $3 = '57469.5', $4 = '57429.5', $5 = '57442.5', $6 = '56', $7 = '515840245921261300', $8 = '0', $9 = '2026-02-15 15:33:46.445', $10 = '2026-02-15 15:33:46.359', $11 = '57459.5', $12 = '57469.5', $13 = '57429.5', $14 = '57442.5', $15 = '56', $16 = '0', $17 = '2026-02-15 15:33:46.445', $18 = '2026-02-15 15:33:46.359'

10

129ms

24

Details

0ms

19ms

5ms

WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;

Times Reported Time consuming bind #10

Day	Hour	Count	Duration	Avg duration
	15	24	129ms	5ms

WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;

Date: 2026-02-15 15:51:43 Duration: 19ms Database: postgres parameters: $1 = '667', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'
WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;

Date: 2026-02-15 15:32:21 Duration: 18ms Database: postgres parameters: $1 = '667', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'
WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;

Date: 2026-02-15 15:02:33 Duration: 18ms Database: postgres parameters: $1 = '667', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'

11

126ms

3,561

Details

0ms

7ms

0ms

select 1;

Times Reported Time consuming bind #11

Day	Hour	Count	Duration	Avg duration
	15	3,561	126ms	0ms

select 1;

Date: 2026-02-15 15:51:28 Duration: 7ms Database: postgres
select 1;

Date: 2026-02-15 15:50:48 Duration: 3ms Database: postgres
select 1;

Date: 2026-02-15 15:50:52 Duration: 2ms Database: postgres

12

28ms

70

Details

0ms

4ms

0ms

/*server.CPResult*/ SELECT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, symbol, longname, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, breakout, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM autochartist_results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join patterns p on p.patternname = a.pattern where resultuid = $1;

Times Reported Time consuming bind #12

Day	Hour	Count	Duration	Avg duration
	15	70	28ms	0ms

/*server.CPResult*/ SELECT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, symbol, longname, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, breakout, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM autochartist_results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join patterns p on p.patternname = a.pattern where resultuid = $1;

Date: 2026-02-15 15:21:01 Duration: 4ms Database: postgres parameters: $1 = '607674006801852301'
/*server.CPResult*/ SELECT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, symbol, longname, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, breakout, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM autochartist_results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join patterns p on p.patternname = a.pattern where resultuid = $1;

Date: 2026-02-15 15:56:51 Duration: 4ms Database: postgres parameters: $1 = '607674239559539301'
/*server.CPResult*/ SELECT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, symbol, longname, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, breakout, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM autochartist_results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join patterns p on p.patternname = a.pattern where resultuid = $1;

Date: 2026-02-15 15:50:18 Duration: 2ms Database: postgres parameters: $1 = '607674183011591301'

13

25ms

6

Details

3ms

6ms

4ms

SELECT DISTINCT ON (basegroupname, symbol) ;

Times Reported Time consuming bind #13

Day	Hour	Count	Duration	Avg duration
	15	6	25ms	4ms

SELECT DISTINCT ON (basegroupname, symbol) ;

Date: 2026-02-15 15:26:00 Duration: 6ms Database: postgres parameters: $1 = '627', $2 = '627'
SELECT DISTINCT ON (basegroupname, symbol) ;

Date: 2026-02-15 15:21:05 Duration: 6ms Database: postgres parameters: $1 = '627', $2 = '627'
SELECT DISTINCT ON (basegroupname, symbol) ;

Date: 2026-02-15 15:12:44 Duration: 3ms Database: postgres parameters: $1 = '667', $2 = '667'

14

19ms

128

Details

0ms

INSERT INTO T240 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Times Reported Time consuming bind #14

Day	Hour	Count	Duration	Avg duration
	15	128	19ms	0ms

INSERT INTO T240 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-15 15:01:56 Duration: 0ms Database: postgres parameters: $1 = '2026-02-15 12:00:00', $2 = '85276.5', $3 = '85927', $4 = '84644', $5 = '84694', $6 = '7052', $7 = '515840249400231300', $8 = '0', $9 = '2026-02-15 15:01:56.41', $10 = '2026-02-15 15:01:56.41', $11 = '85276.5', $12 = '85927', $13 = '84644', $14 = '84694', $15 = '7052', $16 = '0', $17 = '2026-02-15 15:01:56.41', $18 = '2026-02-15 15:01:56.41'
INSERT INTO T240 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-15 15:02:23 Duration: 0ms Database: postgres parameters: $1 = '2026-02-13 16:00:00', $2 = '57420', $3 = '57685', $4 = '57025', $5 = '57615', $6 = '6368', $7 = '515840230561612300', $8 = '0', $9 = '2026-02-15 15:02:23.085', $10 = '2026-02-15 15:02:23.084', $11 = '57420', $12 = '57685', $13 = '57025', $14 = '57615', $15 = '6368', $16 = '0', $17 = '2026-02-15 15:02:23.085', $18 = '2026-02-15 15:02:23.084'
INSERT INTO T240 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-15 15:31:22 Duration: 0ms Database: postgres parameters: $1 = '2026-02-13 16:00:00', $2 = '57420', $3 = '57685', $4 = '57025', $5 = '57615', $6 = '6368', $7 = '515840230561612300', $8 = '0', $9 = '2026-02-15 15:31:22.824', $10 = '2026-02-15 15:31:22.823', $11 = '57420', $12 = '57685', $13 = '57025', $14 = '57615', $15 = '6368', $16 = '0', $17 = '2026-02-15 15:31:22.824', $18 = '2026-02-15 15:31:22.823'

15

15ms

84

Details

0ms

SELECT * FROM ( SELECT PriceDateTime, Open, High, Low, Close, Volume, BSF FROM T15 WHERE symbolid = $1 AND (BSF = 0 OR BSF IS NULL) ORDER BY PriceDateTime DESC LIMIT 1050) a ORDER BY PriceDateTime ASC;

Times Reported Time consuming bind #15

Day	Hour	Count	Duration	Avg duration
	15	84	15ms	0ms

SELECT * FROM ( SELECT PriceDateTime, Open, High, Low, Close, Volume, BSF FROM T15 WHERE symbolid = $1 AND (BSF = 0 OR BSF IS NULL) ORDER BY PriceDateTime DESC LIMIT 1050) a ORDER BY PriceDateTime ASC;

Date: 2026-02-15 15:21:01 Duration: 0ms Database: postgres parameters: $1 = '515840243260614300'
SELECT * FROM ( SELECT PriceDateTime, Open, High, Low, Close, Volume, BSF FROM T15 WHERE symbolid = $1 AND (BSF = 0 OR BSF IS NULL) ORDER BY PriceDateTime DESC LIMIT 1050) a ORDER BY PriceDateTime ASC;

Date: 2026-02-15 15:56:51 Duration: 0ms Database: postgres parameters: $1 = '500991627560118200'
SELECT * FROM ( SELECT PriceDateTime, Open, High, Low, Close, Volume, BSF FROM T15 WHERE symbolid = $1 AND (BSF = 0 OR BSF IS NULL) ORDER BY PriceDateTime DESC LIMIT 1050) a ORDER BY PriceDateTime ASC;

Date: 2026-02-15 15:36:17 Duration: 0ms Database: postgres parameters: $1 = '515840233926223300'

16

14ms

35

Details

0ms

4ms

0ms

/*server.KeyLevelResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, symbol AS sym, longname, shortname, Exchange AS e, timegranularity AS tg, a.PatternID AS pid, a.direction AS d, a.patternprice as pp, atbaridentified AS pet, CASE WHEN (x9 != '') THEN x9 WHEN (x8 != '') THEN x8 WHEN (x7 != '') THEN x7 WHEN (x6 != '') THEN x6 WHEN (x5 != '') THEN x5 WHEN (x4 != '') THEN x4 WHEN (x3 != '') THEN x3 WHEN (x2 != '') THEN x2 END AS pst, PatternPrice AS patp, x0, x1, x2, CASE WHEN (x3 != '') THEN x3 ELSE '1900-01-01' END as x3, CASE WHEN (x4 != '') THEN x4 ELSE '1900-01-01' END as x4, CASE WHEN (x5 != '') THEN x5 ELSE '1900-01-01' END as x5, CASE WHEN (x6 != '') THEN x6 ELSE '1900-01-01' END as x6, CASE WHEN (x7 != '') THEN x7 ELSE '1900-01-01' END as x7, CASE WHEN (x8 != '') THEN x8 ELSE '1900-01-01' END as x8, CASE WHEN (x9 != '') THEN x9 ELSE '1900-01-01' END as x9, errorMargin as erm, breakoutprice as pE, breakoutbars as be, breakout, atbaridentified as atBar, PatternLengthBars AS l, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz, approachingtimestamp AS apt, approachingregion as apr, predictionpricefrom as ppf, predictionpriceto as ppt, predictiontimefrom as ptf, predictiontimebars as ptb FROM keylevels_results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid INNER JOIN hrspatterns p on a.patternid = p.patternid where resultuid = $1 and dtt.dayofweek = 3;

Times Reported Time consuming bind #16

Day	Hour	Count	Duration	Avg duration
	15	35	14ms	0ms

/*server.KeyLevelResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, symbol AS sym, longname, shortname, Exchange AS e, timegranularity AS tg, a.PatternID AS pid, a.direction AS d, a.patternprice as pp, atbaridentified AS pet, CASE WHEN (x9 != '') THEN x9 WHEN (x8 != '') THEN x8 WHEN (x7 != '') THEN x7 WHEN (x6 != '') THEN x6 WHEN (x5 != '') THEN x5 WHEN (x4 != '') THEN x4 WHEN (x3 != '') THEN x3 WHEN (x2 != '') THEN x2 END AS pst, PatternPrice AS patp, x0, x1, x2, CASE WHEN (x3 != '') THEN x3 ELSE '1900-01-01' END as x3, CASE WHEN (x4 != '') THEN x4 ELSE '1900-01-01' END as x4, CASE WHEN (x5 != '') THEN x5 ELSE '1900-01-01' END as x5, CASE WHEN (x6 != '') THEN x6 ELSE '1900-01-01' END as x6, CASE WHEN (x7 != '') THEN x7 ELSE '1900-01-01' END as x7, CASE WHEN (x8 != '') THEN x8 ELSE '1900-01-01' END as x8, CASE WHEN (x9 != '') THEN x9 ELSE '1900-01-01' END as x9, errorMargin as erm, breakoutprice as pE, breakoutbars as be, breakout, atbaridentified as atBar, PatternLengthBars AS l, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz, approachingtimestamp AS apt, approachingregion as apr, predictionpricefrom as ppf, predictionpriceto as ppt, predictiontimefrom as ptf, predictiontimebars as ptb FROM keylevels_results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid INNER JOIN hrspatterns p on a.patternid = p.patternid where resultuid = $1 and dtt.dayofweek = 3;

Date: 2026-02-15 15:31:25 Duration: 4ms Database: postgres parameters: $1 = '600687905493217303'
/*server.KeyLevelResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, symbol AS sym, longname, shortname, Exchange AS e, timegranularity AS tg, a.PatternID AS pid, a.direction AS d, a.patternprice as pp, atbaridentified AS pet, CASE WHEN (x9 != '') THEN x9 WHEN (x8 != '') THEN x8 WHEN (x7 != '') THEN x7 WHEN (x6 != '') THEN x6 WHEN (x5 != '') THEN x5 WHEN (x4 != '') THEN x4 WHEN (x3 != '') THEN x3 WHEN (x2 != '') THEN x2 END AS pst, PatternPrice AS patp, x0, x1, x2, CASE WHEN (x3 != '') THEN x3 ELSE '1900-01-01' END as x3, CASE WHEN (x4 != '') THEN x4 ELSE '1900-01-01' END as x4, CASE WHEN (x5 != '') THEN x5 ELSE '1900-01-01' END as x5, CASE WHEN (x6 != '') THEN x6 ELSE '1900-01-01' END as x6, CASE WHEN (x7 != '') THEN x7 ELSE '1900-01-01' END as x7, CASE WHEN (x8 != '') THEN x8 ELSE '1900-01-01' END as x8, CASE WHEN (x9 != '') THEN x9 ELSE '1900-01-01' END as x9, errorMargin as erm, breakoutprice as pE, breakoutbars as be, breakout, atbaridentified as atBar, PatternLengthBars AS l, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz, approachingtimestamp AS apt, approachingregion as apr, predictionpricefrom as ppf, predictionpriceto as ppt, predictiontimefrom as ptf, predictiontimebars as ptb FROM keylevels_results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid INNER JOIN hrspatterns p on a.patternid = p.patternid where resultuid = $1 and dtt.dayofweek = 3;

Date: 2026-02-15 15:24:08 Duration: 1ms Database: postgres parameters: $1 = '607674179945046303'
/*server.KeyLevelResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, symbol AS sym, longname, shortname, Exchange AS e, timegranularity AS tg, a.PatternID AS pid, a.direction AS d, a.patternprice as pp, atbaridentified AS pet, CASE WHEN (x9 != '') THEN x9 WHEN (x8 != '') THEN x8 WHEN (x7 != '') THEN x7 WHEN (x6 != '') THEN x6 WHEN (x5 != '') THEN x5 WHEN (x4 != '') THEN x4 WHEN (x3 != '') THEN x3 WHEN (x2 != '') THEN x2 END AS pst, PatternPrice AS patp, x0, x1, x2, CASE WHEN (x3 != '') THEN x3 ELSE '1900-01-01' END as x3, CASE WHEN (x4 != '') THEN x4 ELSE '1900-01-01' END as x4, CASE WHEN (x5 != '') THEN x5 ELSE '1900-01-01' END as x5, CASE WHEN (x6 != '') THEN x6 ELSE '1900-01-01' END as x6, CASE WHEN (x7 != '') THEN x7 ELSE '1900-01-01' END as x7, CASE WHEN (x8 != '') THEN x8 ELSE '1900-01-01' END as x8, CASE WHEN (x9 != '') THEN x9 ELSE '1900-01-01' END as x9, errorMargin as erm, breakoutprice as pE, breakoutbars as be, breakout, atbaridentified as atBar, PatternLengthBars AS l, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz, approachingtimestamp AS apt, approachingregion as apr, predictionpricefrom as ppf, predictionpriceto as ppt, predictiontimefrom as ptf, predictiontimebars as ptb FROM keylevels_results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid INNER JOIN hrspatterns p on a.patternid = p.patternid where resultuid = $1 and dtt.dayofweek = 3;

Date: 2026-02-15 15:52:17 Duration: 1ms Database: postgres parameters: $1 = '607674298055219303'

17

12ms

18

Details

0ms

select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;

Times Reported Time consuming bind #17

Day	Hour	Count	Duration	Avg duration
	15	18	12ms	0ms

select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;

Date: 2026-02-15 15:41:11 Duration: 0ms Database: postgres
select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;

Date: 2026-02-15 15:21:01 Duration: 0ms Database: postgres
select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;

Date: 2026-02-15 15:11:01 Duration: 0ms Database: postgres

18

9ms

24

Details

0ms

2ms

0ms

/*server.FibonacciResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, symbol AS sym, Exchange AS e, longname as lo, shortname as sho, timegranularity AS tg, p.PatternID AS pid, Direction AS d, PatternStartTime AS pst, PatternEndTime AS pet, PatternStartPrice AS psp, PatternEndPrice AS pep, priceX as px, timeX as tx, priceA as pa, timeA as ta, priceB as pb, timeB as tb, priceC as pc, timeC as tc, priceD as pd, timeD as td, averagequality as aq, timequality as tq, 1 - errormargin as rq, 1 - noise as c, target10 as t10, target06 as t06, target16 as t16, target07 as t07, target12 as t12, target03 as t03, target05 as t05, PatternLengthBars AS l, temporarypattern as tp, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM Fibonacci_Results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid INNER JOIN fibonaccipatterns p on a.pattern = p.patternname where resultuid = $1 and dtt.dayofweek = 3;

Times Reported Time consuming bind #18

Day	Hour	Count	Duration	Avg duration
	15	24	9ms	0ms

/*server.FibonacciResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, symbol AS sym, Exchange AS e, longname as lo, shortname as sho, timegranularity AS tg, p.PatternID AS pid, Direction AS d, PatternStartTime AS pst, PatternEndTime AS pet, PatternStartPrice AS psp, PatternEndPrice AS pep, priceX as px, timeX as tx, priceA as pa, timeA as ta, priceB as pb, timeB as tb, priceC as pc, timeC as tc, priceD as pd, timeD as td, averagequality as aq, timequality as tq, 1 - errormargin as rq, 1 - noise as c, target10 as t10, target06 as t06, target16 as t16, target07 as t07, target12 as t12, target03 as t03, target05 as t05, PatternLengthBars AS l, temporarypattern as tp, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM Fibonacci_Results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid INNER JOIN fibonaccipatterns p on a.pattern = p.patternname where resultuid = $1 and dtt.dayofweek = 3;

Date: 2026-02-15 15:21:50 Duration: 2ms Database: postgres parameters: $1 = '607674124924010302'
/*server.FibonacciResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, symbol AS sym, Exchange AS e, longname as lo, shortname as sho, timegranularity AS tg, p.PatternID AS pid, Direction AS d, PatternStartTime AS pst, PatternEndTime AS pet, PatternStartPrice AS psp, PatternEndPrice AS pep, priceX as px, timeX as tx, priceA as pa, timeA as ta, priceB as pb, timeB as tb, priceC as pc, timeC as tc, priceD as pd, timeD as td, averagequality as aq, timequality as tq, 1 - errormargin as rq, 1 - noise as c, target10 as t10, target06 as t06, target16 as t16, target07 as t07, target12 as t12, target03 as t03, target05 as t05, PatternLengthBars AS l, temporarypattern as tp, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM Fibonacci_Results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid INNER JOIN fibonaccipatterns p on a.pattern = p.patternname where resultuid = $1 and dtt.dayofweek = 3;

Date: 2026-02-15 15:52:02 Duration: 1ms Database: postgres parameters: $1 = '607674300660673302'
/*server.FibonacciResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, symbol AS sym, Exchange AS e, longname as lo, shortname as sho, timegranularity AS tg, p.PatternID AS pid, Direction AS d, PatternStartTime AS pst, PatternEndTime AS pet, PatternStartPrice AS psp, PatternEndPrice AS pep, priceX as px, timeX as tx, priceA as pa, timeA as ta, priceB as pb, timeB as tb, priceC as pc, timeC as tc, priceD as pd, timeD as td, averagequality as aq, timequality as tq, 1 - errormargin as rq, 1 - noise as c, target10 as t10, target06 as t06, target16 as t16, target07 as t07, target12 as t12, target03 as t03, target05 as t05, PatternLengthBars AS l, temporarypattern as tp, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM Fibonacci_Results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid INNER JOIN fibonaccipatterns p on a.pattern = p.patternname where resultuid = $1 and dtt.dayofweek = 3;

Date: 2026-02-15 15:39:21 Duration: 1ms Database: postgres parameters: $1 = '607674127982294302'

19

8ms

36

Details

0ms

INSERT INTO T1440_underlying (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Times Reported Time consuming bind #19

Day	Hour	Count	Duration	Avg duration
	15	36	8ms	0ms

INSERT INTO T1440_underlying (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-15 15:45:58 Duration: 0ms Database: postgres parameters: $1 = '2026-02-13 00:00:00', $2 = '256.964', $3 = '269.783', $4 = '256.9295', $5 = '269.0435', $6 = '98967', $7 = '515840249404368300', $8 = '0', $9 = '2026-02-15 15:45:58.195', $10 = '2026-02-15 15:45:58.194', $11 = '256.964', $12 = '269.783', $13 = '256.9295', $14 = '269.0435', $15 = '98967', $16 = '0', $17 = '2026-02-15 15:45:58.195', $18 = '2026-02-15 15:45:58.194'
INSERT INTO T1440_underlying (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-15 15:00:53 Duration: 0ms Database: postgres parameters: $1 = '2026-02-13 00:00:00', $2 = '262.07', $3 = '262.085', $4 = '255.47', $5 = '255.69', $6 = '11983', $7 = '515840249386902300', $8 = '0', $9 = '2026-02-15 15:00:53.535', $10 = '2026-02-15 15:00:53.534', $11 = '262.07', $12 = '262.085', $13 = '255.47', $14 = '255.69', $15 = '11983', $16 = '0', $17 = '2026-02-15 15:00:53.535', $18 = '2026-02-15 15:00:53.534'
INSERT INTO T1440_underlying (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-15 15:15:53 Duration: 0ms Database: postgres parameters: $1 = '2026-02-13 00:00:00', $2 = '262.07', $3 = '262.085', $4 = '255.47', $5 = '255.69', $6 = '11983', $7 = '515840249386902300', $8 = '0', $9 = '2026-02-15 15:15:53.101', $10 = '2026-02-15 15:15:53.1', $11 = '262.07', $12 = '262.085', $13 = '255.47', $14 = '255.69', $15 = '11983', $16 = '0', $17 = '2026-02-15 15:15:53.101', $18 = '2026-02-15 15:15:53.1'

20

6ms

118

Details

0ms

SELECT df.absolutetimezoneoffset FROM datafeedstimetable df INNER JOIN downloadersymbolsettings dss ON df.classname = dss.classname WHERE dss.symbolid = $1 GROUP BY df.absolutetimezoneoffset LIMIT 1;

Times Reported Time consuming bind #20

Day	Hour	Count	Duration	Avg duration
	15	118	6ms	0ms

SELECT df.absolutetimezoneoffset FROM datafeedstimetable df INNER JOIN downloadersymbolsettings dss ON df.classname = dss.classname WHERE dss.symbolid = $1 GROUP BY df.absolutetimezoneoffset LIMIT 1;

Date: 2026-02-15 15:21:01 Duration: 0ms Database: postgres parameters: $1 = '515840243260614300'
SELECT df.absolutetimezoneoffset FROM datafeedstimetable df INNER JOIN downloadersymbolsettings dss ON df.classname = dss.classname WHERE dss.symbolid = $1 GROUP BY df.absolutetimezoneoffset LIMIT 1;

Date: 2026-02-15 15:56:51 Duration: 0ms Database: postgres parameters: $1 = '500991627560118200'
SELECT df.absolutetimezoneoffset FROM datafeedstimetable df INNER JOIN downloadersymbolsettings dss ON df.classname = dss.classname WHERE dss.symbolid = $1 GROUP BY df.absolutetimezoneoffset LIMIT 1;

Date: 2026-02-15 15:50:18 Duration: 0ms Database: postgres parameters: $1 = '515840233910322300'

Log levels

Key values

129,883 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	559	0.43%
DETAIL	27,646	21.29%
ERROR	2	0.00%
LOG	101,084	77.83%
STATEMENT	592	0.46%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
2 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

1 Max number of times the same event was reported
2 Total events found

Rank

Times reported

Error

1

Details

ERROR: value too long for type character varying(...)

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Feb 15	15	1

ERROR: value too long for type character varying(255)

2

1

Details

ERROR: relation "..." does not exist

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Feb 15	15	1

ERROR: relation "t0" does not exist at character 83

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

Queries generating the most temporary files (N)

Queries generating the largest temporary files

Vacuums

Vacuums / Analyzes Distribution

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Autovacuum Activity

Locks

Locks by types

Key values

Type of locks

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values

Queries by user

Key values

Duration by user