pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sat Feb 21 04:59:24 2026
Log file: /home/postgres/pg_data/data/pg_log/postgresql-2026-02-21_060000.log
Parsed 743,154 log entries in 22s
Log start from 2026-02-21 06:00:00 to 2026-02-21 06:59:22

Global Stats

976 Number of unique normalized queries
125,924 Number of queries
2h6m11s Total query duration
2026-02-21 06:00:00 First query
2026-02-21 06:59:22 Last query
6,184 queries/s at 2026-02-21 06:05:01 Query peak

2h6m11s Total query duration
3s70ms Prepare/parse total duration
18s605ms Bind total duration
2h5m49s Execute total duration

988 Number of events
8 Number of unique normalized events
426 Max number of times the same event was reported
0 Number of cancellation

16 Total number of automatic vacuums
22 Total number of automatic analyzes

97 Number temporary file
24.06 MiB Max size of temporary file
4.84 MiB Average size of temporary file

2,631 Total number of sessions
13 sessions at 2026-02-21 06:53:48 Session peak
1d11h53m30s Total duration of sessions
49s110ms Average duration of sessions
47 Average queries per session
2s877ms Average queries duration per session
46s232ms Average idle time per session

2,632 Total number of connections
262 connections/s at 2026-02-21 06:40:09 Connection peak
6 Total number of databases

SQL Traffic

Key values

6,184 queries/s Query Peak
2026-02-21 06:05:01 Date

SELECT Traffic

Key values

2,912 queries/s Query Peak
2026-02-21 06:19:01 Date

INSERT/UPDATE/DELETE Traffic

Key values

105 queries/s Query Peak
2026-02-21 06:08:49 Date

Queries duration

Key values

2h6m11s 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 21	06	125,924	0ms	3m12s	59ms	3m39s	4m17s	17m23s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 21	06	41,195	575	0ms	0ms	0ms	0ms

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 21	06	13,336	579	504	0	0ms	0ms	0ms	0ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Feb 21	06	11,080	27,258	2.46	18.53%

Day	Hour	Count	Average / Second
Feb 21	06	2,632	0.73/s

Day	Hour	Count	Average Duration	Average idle time
Feb 21	06	2,631	49s110ms	46s241ms

↑ Back to the top of the General Activity table

Established Connections

Key values

262 connections Connection Peak
2026-02-21 06:40:09 Date

Connections per database

Key values

acaweb_fx Main Database
2,632 connections Total

Chart
Table

Database	User	Count
acaweb_fx		2,555
	pg_dump	1
	postgres	1,579
	psql	975
acaweb_fx_integer		1
	pg_dump	1
postgres		3
	pg_dump	1
	psql	2
socialmedia		72
	pg_dump	1
	postgres	71
translations		1
	pg_dump	1

Connections per user

Key values

postgres Main User
2,632 connections Total

Chart
Table

User	Count
pg_dump	5
postgres	1,650
psql	977

Connections per host

Key values

127.0.0.1 Main host with 946 connections
2,632 Total connections

Chart
Table

Host	Count
127.0.0.1	946
192.168.0.114	5
192.168.0.216	116
192.168.1.145	115
192.168.1.15	9
192.168.1.20	130
192.168.1.231	20
192.168.1.239	56
192.168.1.90	6
192.168.2.126	18
192.168.3.199	38
192.168.4.142	736
192.168.4.33	71
192.168.4.98	330
[local]	36

Simultaneous sessions

Key values

13 sessions Session Peak
2026-02-21 06:53:48 Date

Histogram of session times

Key values

2,232 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	2,232	84.83%
500ms-1s	136	5.17%
1s-30s	193	7.34%
30s-1m	8	0.30%
1m-10m	5	0.19%
10m-30m	51	1.94%
30m-1h	0	0.00%
1h-8h	6	0.23%
> 8h	0	0.00%

Sessions per database

Key values

acaweb_fx Main Database
2,631 sessions Total

Chart
Table

Database	User	Count	Total Duration
acaweb_fx	2,554	1d11h31m16s	50s69ms
acaweb_fx_integer	1	19m2s	19m2s
postgres	3	272ms	90ms
socialmedia	72	3m10s	2s648ms
translations	1	169ms	169ms

Sessions per user

Key values

postgres Main User
2,631 sessions Total

Chart
Table

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

Sessions per host

Key values

127.0.0.1 Main Host
2,631 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	946	35m45s	2s267ms
192.168.0.114	4	28m12s	7m3s
192.168.0.216	116	7m26s	3s846ms
192.168.1.145	115	3h42m20s	1m56s
192.168.1.15	9	4h44m15s	31m35s
192.168.1.20	130	16h8m26s	7m26s
192.168.1.231	20	9h54m35s	29m43s
192.168.1.239	56	404ms	7ms
192.168.1.90	6	42ms	7ms
192.168.2.126	18	4s559ms	253ms
192.168.3.199	38	22s175ms	583ms
192.168.4.142	736	7m4s	577ms
192.168.4.33	71	1m7s	951ms
192.168.4.98	330	14s150ms	42ms
[local]	36	3m34s	5s959ms

Sessions per application

Key values

unknown Main Host
2,631 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
unknown	2,631	1d11h53m30s	49s110ms

Checkpoints Buffers

Key values

41,189 buffers Checkpoint Peak
2026-02-21 06:47:39 Date
209.600 seconds Highest write time
0.006 seconds Sync time

Checkpoints Wal files

Key values

22 files Wal files usage Peak
2026-02-21 06:47:39 Date

Checkpoints distance

Key values

704.16 Mo Distance Peak
2026-02-21 06:47:39 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Feb 21	06	53,489	1,309.615s	0.036s	1,309.945s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Feb 21	06	0	0	28	1,144	0.004s	0s

Day	Hour	Count	Avg time (sec)
Feb 21	06	0	0s

Day	Hour	Mean distance	Mean estimate
Feb 21	06	41,838.45 kB	101,163.73 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

22.30 MiB Temp Files size Peak
2026-02-21 06:40:44 Date

Number of temporary files

Key values

2 per second Temp Files Peak
2026-02-21 06:40:16 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Feb 21	06	97	469.40 MiB	4.84 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	39	161.56 MiB	3.94 MiB	4.32 MiB	4.14 MiB	select resultuid from relevance_fibonacci_results order by resultuid desc limit ?), fr as ( select a., rr.age, rr.relevant from fibonacci_results a left outer join relevance_fibonacci_results rr on a.resultuid = rr.resultuid where case when false = ? then true else a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) end), all_results as ( select fr.resultuid as resultuid, fr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, fr.pattern as pattern_name, fr.timed as timed, fr.patternendtime as identified, dtt.timezone as timezone, fr.patternlengthbars as length, g.basegroupname, newlevels.filtered, case when fr.age is not null then fr.age when fr.resultuid <= rm.resultuid then ? else ? end as age, case when fr.relevant is not null then fr.relevant when fr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from fr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = fr.symbolid inner join symbols s on fr.symbolid = s.symbolid and s.nonliquid = ? inner join symbolgroup sg on fr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join downloadersymbolsettings dss on fr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join rar_max rm on ? = ? left join lateral calc_fib_signal_filter (fr.resultuid) newlevels on true left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where fr.gmttimefound > now() - interval ? and dss.enabled = ? and s.deleted = ? and (fr.simulation = ? or fr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or fr.pattern in (...)) and (? = ? or fr.patternlengthbars <= ?) and (? = ? or (? = ? and fr.timed > cast(? as timestamp)) or (? = ? and fr.timed < cast(? as timestamp)))), results as ( select distinct on (symbolid) from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc; SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), fr AS ( SELECT a., rr.age, rr.relevant from fibonacci_results a LEFT OUTER JOIN relevance_fibonacci_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) END), all_results AS ( SELECT fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN fr.age IS NOT NULL THEN fr.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN fr.relevant IS NOT NULL THEN fr.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT JOIN LATERAL calc_fib_signal_filter (fr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($3 = 0 OR s.timegranularity in ($4)) AND ($5 = 0 OR s.exchange in ($6)) AND ($7 = 0 OR coalesce(bim.code, s.symbol) in ($8)) AND ($9 = 0 OR fr.pattern in ($10)) AND ($11 = 0 OR fr.patternlengthbars <= $12) AND ($13 = 0 OR ($14 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($15 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = $16 OR relevant = 1) AND ($17 = 0 OR age <= $18) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; Date: 2026-02-21 06:03:09 Duration: 0ms
2	27	94.10 MiB	3.37 MiB	3.89 MiB	3.49 MiB	select resultuid from relevance_consecutivecandles_results order by resultuid desc limit ?), all_results as ( select ccr.resultuid as resultuid, ccr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, ccr.patternendtime as identified, dtt.timezone as timezone, ccr.qtyconsecutivecandles as length, g.basegroupname, case when rcr.age is not null then rcr.age when ccr.resultuid <= rm.resultuid then ? else ? end as age, case when rcr.relevant is not null then rcr.relevant when ccr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip, newlevels.filtered from consecutivecandles_results ccr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = ccr.symbolid inner join symbols s on ccr.symbolid = s.symbolid and s.nonliquid = ? inner join downloadersymbolsettings dss on ccr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on ccr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join rar_max rm on ? = ? left outer join relevance_consecutivecandles_results rcr on rcr.resultuid = ccr.resultuid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? left join lateral calc_cc_signal_filter (ccr.resultuid) newlevels on true where ccr.gmttimefound > now() - interval ? and s.deleted = ? and (ccr.simulation = ? or ccr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ccr.patternlengthbars <= ?)), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc; SELECT resultuid FROM relevance_consecutivecandles_results ORDER BY resultuid DESC LIMIT 1), all_results AS ( SELECT ccr.resultuid AS resultuid, ccr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, ccr.patternendtime AS identified, dtt.timezone AS timezone, ccr.qtyconsecutivecandles AS length, g.basegroupname, CASE WHEN rcr.age IS NOT NULL THEN rcr.age WHEN ccr.resultuid <= rm.resultuid THEN 1 ELSE 0 END as age, CASE WHEN rcr.relevant IS NOT NULL THEN rcr.relevant WHEN ccr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip, newLevels.filtered FROM consecutivecandles_results ccr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = ccr.symbolid INNER JOIN symbols s ON ccr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN downloadersymbolsettings dss ON ccr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on ccr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_consecutivecandles_results rcr ON rcr.resultuid = ccr.resultuid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' LEFT JOIN LATERAL calc_cc_signal_filter (ccr.resultuid) newLevels on true WHERE ccr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (ccr.simulation = 0 OR ccr.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3, $4, $5, $6, $7, $8, $9)) AND ($10 = 0 OR s.exchange in ($11)) AND ($12 = 0 OR coalesce(bim.code, s.symbol) in ($13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225)) AND ($226 = 0 OR ccr.patternlengthbars <= $227)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $228 OR relevant = 1) AND ($229 = 0 OR age <= $230) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; Date: 2026-02-21 06:03:57 Duration: 0ms
3	24	159.36 MiB	3.52 MiB	9.76 MiB	6.64 MiB	jr.resultuid as resultuid, jr.direction as direction, jr.patternendtime as identified, jr.patternlengthbars as length, jr.patternstarttime as patternstarttime, case when jr.trendchangeid = ? then ? else ? end as trendchange, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, jp.patternname as pattern_name, dtt.timezone as timezone, ? as age, cps.pip, g.basegroupname from japsticks_results jr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = jr.symbolid inner join relevance_japsticks_results rar on rar.resultuid = jr.resultuid inner join symbols s on jr.symbolid = s.symbolid and s.nonliquid = ? inner join japsticks_patterns jp on jr.patternid = jp.id inner join downloadersymbolsettings dss on jr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on s.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where jr.gmttimefound > now() - interval ? and s.deleted = ? and (jr.simulation = ? or jr.simulation is null) and (rar.relevant = ?) --and (semicolon_age = ? or rar.age <= semicolon_age) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or jp.patternname in (...)) and (? = ? or jr.patternlengthbars <= ?) ), results as ( select distinct on (symbolid) * from all_results order by symbolid, resultuid ) select * from results order by identified desc, length desc ; jr.resultuid AS resultuid, jr.direction AS direction, jr.patternendtime AS identified, jr.patternlengthbars AS length, jr.patternstarttime AS patternstarttime, case when jr.trendchangeid = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; Date: 2026-02-21 06:00:25 Duration: 0ms
4	3	49.58 MiB	10.07 MiB	24.06 MiB	16.53 MiB	select distinct ss.statsid from stats_success t inner join stats_symbols ss on t.symbolid = ss.symbolid where statsid in ( select statsid from stats where (? = ? or brokerid = ?)) and atbaridentified >= (current_timestamp - interval ?) and atbaridentified <= current_timestamp and type = ? and pattern not ilike ? and (? = ? or statsid >= ?) order by ss.statsid; select distinct ss.statsid from stats_success t inner join stats_symbols ss on t.symbolid = ss.symbolid where statsid in ( select statsid from stats where (0 = 0 or brokerid = 0)) and atbaridentified >= (current_timestamp - interval '12 months') and atbaridentified <= current_timestamp and type = 'cp' and pattern not ilike '%NON_LIQUID%' and (0 = 0 OR statsid >= 0) order by ss.statsid; Date: 2026-02-21 06:40:16 Duration: 0ms
5	1	4.80 MiB	4.80 MiB	4.80 MiB	4.80 MiB	select stats_calcstatsforallbrokers (); select stats_calcstatsforallbrokers (); Date: 2026-02-21 06:40:08 Duration: 0ms

Queries generating the largest temporary files

Rank	Size	Query
1	24.06 MiB	select distinct ss.statsid from stats_success t inner join stats_symbols ss on t.symbolid = ss.symbolid where statsid in ( select statsid from stats where (0 = 0 or brokerid = 0)) and atbaridentified >= (current_timestamp - interval '12 months') and atbaridentified <= current_timestamp and type = 'ekl' and pattern not ilike '%NON_LIQUID%' and (0 = 0 OR statsid >= 0) order by ss.statsid; [ Date: 2026-02-21 06:40:43 ]
2	15.44 MiB	select distinct ss.statsid from stats_success t inner join stats_symbols ss on t.symbolid = ss.symbolid where statsid in ( select statsid from stats where (0 = 0 or brokerid = 0)) and atbaridentified >= (current_timestamp - interval '12 months') and atbaridentified <= current_timestamp and type = 'cp' and pattern not ilike '%NON_LIQUID%' and (0 = 0 OR statsid >= 0) order by ss.statsid; [ Date: 2026-02-21 06:40:16 ]
3	10.07 MiB	select distinct ss.statsid from stats_success t inner join stats_symbols ss on t.symbolid = ss.symbolid where statsid in ( select statsid from stats where (0 = 0 or brokerid = 0)) and atbaridentified >= (current_timestamp - interval '12 months') and atbaridentified <= current_timestamp and type = 'kl' and pattern not ilike '%NON_LIQUID%' and (0 = 0 OR statsid >= 0) order by ss.statsid; [ Date: 2026-02-21 06:40:34 ]
4	9.76 MiB	jr.resultuid AS resultuid, jr.direction AS direction, jr.patternendtime AS identified, jr.patternlengthbars AS length, jr.patternstarttime AS patternstarttime, case when jr.trendchangeid = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; [ Date: 2026-02-21 06:03:59 ]
5	9.76 MiB	jr.resultuid AS resultuid, jr.direction AS direction, jr.patternendtime AS identified, jr.patternlengthbars AS length, jr.patternstarttime AS patternstarttime, case when jr.trendchangeid = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; [ Date: 2026-02-21 06:08:58 ]
6	9.76 MiB	jr.resultuid AS resultuid, jr.direction AS direction, jr.patternendtime AS identified, jr.patternlengthbars AS length, jr.patternstarttime AS patternstarttime, case when jr.trendchangeid = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; [ Date: 2026-02-21 06:14:30 ]
7	9.76 MiB	jr.resultuid AS resultuid, jr.direction AS direction, jr.patternendtime AS identified, jr.patternlengthbars AS length, jr.patternstarttime AS patternstarttime, case when jr.trendchangeid = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; [ Date: 2026-02-21 06:18:49 ]
8	9.76 MiB	jr.resultuid AS resultuid, jr.direction AS direction, jr.patternendtime AS identified, jr.patternlengthbars AS length, jr.patternstarttime AS patternstarttime, case when jr.trendchangeid = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; [ Date: 2026-02-21 06:23:47 ]
9	9.76 MiB	jr.resultuid AS resultuid, jr.direction AS direction, jr.patternendtime AS identified, jr.patternlengthbars AS length, jr.patternstarttime AS patternstarttime, case when jr.trendchangeid = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; [ Date: 2026-02-21 06:29:13 ]
10	9.76 MiB	jr.resultuid AS resultuid, jr.direction AS direction, jr.patternendtime AS identified, jr.patternlengthbars AS length, jr.patternstarttime AS patternstarttime, case when jr.trendchangeid = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; [ Date: 2026-02-21 06:34:05 ]
11	9.76 MiB	jr.resultuid AS resultuid, jr.direction AS direction, jr.patternendtime AS identified, jr.patternlengthbars AS length, jr.patternstarttime AS patternstarttime, case when jr.trendchangeid = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; [ Date: 2026-02-21 06:38:59 ]
12	9.76 MiB	jr.resultuid AS resultuid, jr.direction AS direction, jr.patternendtime AS identified, jr.patternlengthbars AS length, jr.patternstarttime AS patternstarttime, case when jr.trendchangeid = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; [ Date: 2026-02-21 06:43:50 ]
13	9.76 MiB	jr.resultuid AS resultuid, jr.direction AS direction, jr.patternendtime AS identified, jr.patternlengthbars AS length, jr.patternstarttime AS patternstarttime, case when jr.trendchangeid = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; [ Date: 2026-02-21 06:48:59 ]
14	9.76 MiB	jr.resultuid AS resultuid, jr.direction AS direction, jr.patternendtime AS identified, jr.patternlengthbars AS length, jr.patternstarttime AS patternstarttime, case when jr.trendchangeid = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; [ Date: 2026-02-21 06:54:18 ]
15	9.76 MiB	jr.resultuid AS resultuid, jr.direction AS direction, jr.patternendtime AS identified, jr.patternlengthbars AS length, jr.patternstarttime AS patternstarttime, case when jr.trendchangeid = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; [ Date: 2026-02-21 06:59:17 ]
16	4.80 MiB	select stats_calcstatsforallbrokers (); [ Date: 2026-02-21 06:40:08 ]
17	4.32 MiB	SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), fr AS ( SELECT a., rr.age, rr.relevant from fibonacci_results a LEFT OUTER JOIN relevance_fibonacci_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) END), all_results AS ( SELECT fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN fr.age IS NOT NULL THEN fr.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN fr.relevant IS NOT NULL THEN fr.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT JOIN LATERAL calc_fib_signal_filter (fr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($3 = 0 OR s.timegranularity in ($4, $5, $6, $7, $8, $9, $10)) AND ($11 = 0 OR s.exchange in ($12)) AND ($13 = 0 OR coalesce(bim.code, s.symbol) in ($14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226)) AND ($227 = 0 OR fr.pattern in ($228)) AND ($229 = 0 OR fr.patternlengthbars <= $230) AND ($231 = 0 OR ($232 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($233 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = $234 OR relevant = 1) AND ($235 = 0 OR age <= $236) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; [ Date: 2026-02-21 06:34:25 ]
18	4.32 MiB	SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), fr AS ( SELECT a., rr.age, rr.relevant from fibonacci_results a LEFT OUTER JOIN relevance_fibonacci_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) END), all_results AS ( SELECT fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN fr.age IS NOT NULL THEN fr.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN fr.relevant IS NOT NULL THEN fr.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT JOIN LATERAL calc_fib_signal_filter (fr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($3 = 0 OR s.timegranularity in ($4, $5, $6, $7, $8, $9, $10)) AND ($11 = 0 OR s.exchange in ($12)) AND ($13 = 0 OR coalesce(bim.code, s.symbol) in ($14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226)) AND ($227 = 0 OR fr.pattern in ($228)) AND ($229 = 0 OR fr.patternlengthbars <= $230) AND ($231 = 0 OR ($232 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($233 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = $234 OR relevant = 1) AND ($235 = 0 OR age <= $236) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; [ Date: 2026-02-21 06:34:32 ]
19	4.32 MiB	SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), fr AS ( SELECT a., rr.age, rr.relevant from fibonacci_results a LEFT OUTER JOIN relevance_fibonacci_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) END), all_results AS ( SELECT fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN fr.age IS NOT NULL THEN fr.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN fr.relevant IS NOT NULL THEN fr.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT JOIN LATERAL calc_fib_signal_filter (fr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($3 = 0 OR s.timegranularity in ($4, $5, $6, $7, $8, $9, $10)) AND ($11 = 0 OR s.exchange in ($12)) AND ($13 = 0 OR coalesce(bim.code, s.symbol) in ($14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226)) AND ($227 = 0 OR fr.pattern in ($228)) AND ($229 = 0 OR fr.patternlengthbars <= $230) AND ($231 = 0 OR ($232 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($233 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = $234 OR relevant = 1) AND ($235 = 0 OR age <= $236) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; [ Date: 2026-02-21 06:38:19 ]
20	4.32 MiB	SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), fr AS ( SELECT a., rr.age, rr.relevant from fibonacci_results a LEFT OUTER JOIN relevance_fibonacci_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) END), all_results AS ( SELECT fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN fr.age IS NOT NULL THEN fr.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN fr.relevant IS NOT NULL THEN fr.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT JOIN LATERAL calc_fib_signal_filter (fr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($3 = 0 OR s.timegranularity in ($4, $5, $6, $7, $8, $9, $10)) AND ($11 = 0 OR s.exchange in ($12)) AND ($13 = 0 OR coalesce(bim.code, s.symbol) in ($14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226)) AND ($227 = 0 OR fr.pattern in ($228)) AND ($229 = 0 OR fr.patternlengthbars <= $230) AND ($231 = 0 OR ($232 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($233 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = $234 OR relevant = 1) AND ($235 = 0 OR age <= $236) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; [ Date: 2026-02-21 06:38:35 ]

Vacuums / Analyzes Distribution

Key values

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

Analyzes per table

Key values

pg_catalog.pg_type (4) Main table analyzed (database acaweb_fx)
22 analyzes Total

Chart
Table

Table	Number of analyzes
acaweb_fx.pg_catalog.pg_type	4
acaweb_fx.pg_catalog.pg_attribute	4
acaweb_fx.public.datafeeds_latestrun	3
acaweb_fx.pg_catalog.pg_class	3
acaweb_fx.public.latest_t15_candle_view	2
acaweb_fx.public.stats_hrsapproaches_summary_2d	1
acaweb_fx.public.stats_hrs_summary_2d	1
acaweb_fx.public.stats_summary_2d	1
acaweb_fx.pg_catalog.pg_depend	1
acaweb_fx.public.variables	1
acaweb_fx.public.latest_candle_datetime_per_receng	1
Total	22

Vacuums per table

Key values

pg_catalog.pg_type (3) Main table vacuumed on database acaweb_fx
16 vacuums Total

Chart
Table

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
acaweb_fx.pg_catalog.pg_type	3	3	527	0	51	0	0	190	43	257,778
acaweb_fx.public.datafeeds_latestrun	2	0	240	0	10	0	0	26	16	33,772
acaweb_fx.pg_catalog.pg_attribute	2	2	1,646	0	232	0	134	755	195	1,238,850
acaweb_fx.public.stats_summary_2d	2	2	208,567	0	14,953	0	39,016	82,962	11,560	55,388,032
acaweb_fx.public.stats_hrsapproaches_summary_2d	1	1	38,576	0	3,397	0	3,820	19,365	3,381	13,631,383
acaweb_fx.public.autochartist_symbolupdates	1	1	19,939	0	5,388	4	38,485	6,117	5,149	2,509,118
acaweb_fx.public.stats_hrs_summary_2d	1	1	37,628	0	3,282	0	3,443	18,775	3,261	13,223,148
acaweb_fx.pg_catalog.pg_depend	1	1	597	0	64	0	59	153	65	338,754
acaweb_fx.public.latest_t15_candle_view	1	1	93	0	1	0	0	6	1	9,055
acaweb_fx.public.variables	1	1	308	0	3	0	215	28	2	14,618
acaweb_fx.pg_catalog.pg_class	1	1	255	0	46	0	79	122	47	265,002
Total	16	14	308,376	74,713	27,427	4	85,251	128,499	23,720	86,909,510

Tuples removed per table

Key values

public.stats_summary_2d (1119123) Main table with removed tuples on database acaweb_fx
1651848 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
acaweb_fx.public.stats_summary_2d	2	2	1,119,123	1,431,710	32,037	0	59,532
acaweb_fx.public.stats_hrsapproaches_summary_2d	1	1	263,586	203,173	0	0	7,549
acaweb_fx.public.stats_hrs_summary_2d	1	1	258,368	181,658	0	0	7,040
acaweb_fx.public.autochartist_symbolupdates	1	1	4,675	53,285	351	0	40,691
acaweb_fx.pg_catalog.pg_attribute	2	2	4,268	21,294	0	0	532
acaweb_fx.public.variables	1	1	785	4	0	216	7
acaweb_fx.pg_catalog.pg_type	3	3	665	4,520	176	0	132
acaweb_fx.pg_catalog.pg_class	1	1	151	2,584	0	0	150
acaweb_fx.public.datafeeds_latestrun	2	0	121	28	0	0	32
acaweb_fx.public.latest_t15_candle_view	1	1	59	14	0	0	1
acaweb_fx.pg_catalog.pg_depend	1	1	47	14,696	264	0	142
Total	16	14	1,651,848	1,912,966	32,828	216	115,808

Pages removed per table

Key values

public.variables (216) Main table with removed pages on database acaweb_fx
216 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
acaweb_fx.public.variables	1	1	785	216
acaweb_fx.public.stats_hrsapproaches_summary_2d	1	1	263586	0
acaweb_fx.pg_catalog.pg_type	3	3	665	0
acaweb_fx.public.datafeeds_latestrun	2	0	121	0
acaweb_fx.public.autochartist_symbolupdates	1	1	4675	0
acaweb_fx.public.stats_hrs_summary_2d	1	1	258368	0
acaweb_fx.pg_catalog.pg_attribute	2	2	4268	0
acaweb_fx.public.stats_summary_2d	2	2	1119123	0
acaweb_fx.pg_catalog.pg_depend	1	1	47	0
acaweb_fx.public.latest_t15_candle_view	1	1	59	0
acaweb_fx.pg_catalog.pg_class	1	1	151	0
Total	16	14	1,651,848	216

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Feb 21	06	16	22

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

AccessShareLock Main Lock Type
9 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
AccessExclusiveLock		1	1m58s	1m58s
	relation	1	1m58s	1m58s
AccessShareLock		8	13m47s	1m43s
	relation	8	13m47s	1m43s
	Total	9	15m46s	1m45s

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	8	13m47s	1m31s	1m59s	1m43s	select datetimeupdate from latest_candle_datetime_per_receng where recognitionengine ilike ?; SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'HOTFOREX - 1'; Date: 2026-02-21 06:19:00
2	1	1m58s	1m58s	1m58s	1m58s	refresh materialized view latest_candle_datetime_per_receng; refresh materialized view latest_candle_datetime_per_receng; Date: 2026-02-21 06:19:00

Queries that waited the most

Rank	Wait time	Query
1	1m59s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'HOTFOREX - 1'; [ Date: 2026-02-21 06:19:00 ]
2	1m58s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2026-02-21 06:19:00 ]
3	1m55s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'FPMARKETS - 1'; [ Date: 2026-02-21 06:19:00 ]
4	1m53s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'IQFEED_FX - 1'; [ Date: 2026-02-21 06:19:00 ]
5	1m40s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'AXIORY - 1'; [ Date: 2026-02-21 06:19:00 ]
6	1m38s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'Alpari - 1'; [ Date: 2026-02-21 06:19:00 ]
7	1m36s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ATFX - 1'; [ Date: 2026-02-21 06:19:00 ]
8	1m33s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'MILLENNIUMPF - 1'; [ Date: 2026-02-21 06:19:00 ]
9	1m31s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'PEPPERSTONE - 1'; [ Date: 2026-02-21 06:19:00 ]

Queries by type

Key values

41,195 Total read queries
18,595 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	41,195	32.71%
INSERT	13,336	10.59%
UPDATE	579	0.46%
DELETE	504	0.40%
COPY FROM	0	0.00%
COPY TO	575	0.46%
CTE	2,404	1.91%
DDL	0	0.00%
TCL	1,197	0.95%
CURSOR	0	0.00%
OTHERS	66,134	52.52%

Queries by database

Key values

unknown Main database
124,326 Requests
2h5m49s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
acaweb_fx	Total	1,521	0ms
	delete	504	0ms
	others	214	0ms
	select	440	0ms
	tcl	335	0ms
	update	28	0ms
acaweb_fx_integer	Total	1	0ms
	select	1	0ms
postgres	Total	3	0ms
	select	3	0ms
socialmedia	Total	72	0ms
	select	72	0ms
translations	Total	1	0ms
	select	1	0ms
unknown	Total	124,326	2h5m49s
	copy to	575	0ms
	cte	2,404	0ms
	insert	13,336	0ms
	others	3,372	0ms
	select	40,678	0ms
	tcl	862	0ms
	update	551	0ms

Queries by user

Key values

unknown Main user
124,326 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	1,598	0ms
	delete	504	0ms
	others	214	0ms
	select	517	0ms
	tcl	335	0ms
	update	28	0ms
unknown	Total	124,326	2h5m49s
	copy to	575	0ms
	cte	2,404	0ms
	insert	13,336	0ms
	others	3,372	0ms
	select	40,678	0ms
	tcl	862	0ms
	update	551	0ms

Duration by user

Key values

2h5m49s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	1,598	0ms
	delete	504	0ms
	others	214	0ms
	select	517	0ms
	tcl	335	0ms
	update	28	0ms
unknown	Total	124,326	2h5m49s
	copy to	575	0ms
	cte	2,404	0ms
	insert	13,336	0ms
	others	3,372	0ms
	select	40,678	0ms
	tcl	862	0ms
	update	551	0ms

Queries by host

Key values

unknown Main host
125,924 Requests
2h5m49s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	125,924	2h5m49s
	copy to	575	0ms
	cte	2,404	0ms
	delete	504	0ms
	insert	13,336	0ms
	others	3,586	0ms
	select	41,195	0ms
	tcl	1,197	0ms
	update	579	0ms

Queries by application

Key values

unknown Main application
124,942 Requests
2h5m49s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
pg_dump	Total	5	0ms
	select	5	0ms
psql	Total	977	0ms
	delete	504	0ms
	others	4	0ms
	select	441	0ms
	update	28	0ms
unknown	Total	124,942	2h5m49s
	copy to	575	0ms
	cte	2,404	0ms
	insert	13,336	0ms
	others	3,582	0ms
	select	40,749	0ms
	tcl	1,197	0ms
	update	551	0ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-02-21 06:34:42 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

39,467 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	39,467	63.10%
1-5ms	18,492	29.56%
5-10ms	1,523	2.43%
10-25ms	1,720	2.75%
25-50ms	212	0.34%
50-100ms	142	0.23%
100-500ms	225	0.36%
500-1000ms	55	0.09%
1000-10000ms	575	0.92%
> 10000ms	137	0.22%

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

1

Details

0ms

lock table public.stats_hrs_summary_by_groups in access share mode;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Feb 21	06	1	0ms	0ms

2

0ms

2

Details

0ms

copy public.powerstats_trumpet (symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) to stdout;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

3

0ms

2

Details

0ms

select last_value, is_called from public.stats_by_groups_statsid_seq;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

4

0ms

2

Details

0ms

lock table public.timezones_korean in access share mode;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

5

0ms

13

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

Day	Hour	Count	Duration	Avg duration
Feb 21	06	13	0ms	0ms

6

0ms

2

Details

0ms

copy public.t30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived, pricesadjusted, relevanceprocessed, recengprocessedadjusted, historical) to stdout;

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

7

0ms

1

Details

0ms

copy public.processresults (id, processid, resultdate, shorttext, longtext, title, test) to stdout;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Feb 21	06	1	0ms	0ms

8

0ms

2,442

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

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2,442	0ms	0ms

9

0ms

2

Details

0ms

select last_value, is_called from public.keylevels_results_resultuid_seq19;

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

10

0ms

2

Details

0ms

copy archive.whatshot (whid, brokerid, whdatetime, jobcompletiontime) to stdout;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

11

0ms

5

Details

0ms

set synchronize_seqscans to off;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Feb 21	06	5	0ms	0ms

12

0ms

1

Details

0ms

select last_value, is_called from public."ProcessLocaleParameters_id_seq";

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Feb 21	06	1	0ms	0ms

13

0ms

976

Details

0ms

select oid, tableoid, pol.polname, pol.polcmd, pol.polpermissive, case when pol.polroles = ? then null else pg_catalog.array_to_string(array ( select pg_catalog.quote_ident(rolname) from pg_catalog.pg_roles where oid = any (pol.polroles)), ?) end as polroles, pg_catalog.pg_get_expr(pol.polqual, pol.polrelid) as polqual, pg_catalog.pg_get_expr(pol.polwithcheck, pol.polrelid) as polwithcheck from pg_catalog.pg_policy pol where polrelid = ?;

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Feb 21	06	976	0ms	0ms

14

0ms

2

Details

0ms

lock table public.timezones_turkish in access share mode;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

15

0ms

2

Details

0ms

copy public.timezones_greek (timezoneid, timezone) to stdout;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

16

0ms

2

Details

0ms

lock table public.futures_symbols in access share mode;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

17

0ms

2

Details

0ms

copy archive.autochartist_results (resultid, bandwidth, pattern, gmttimefound, direction, initialtrend, breakout, volumeincrease, noise, symmetry, patternstarttime, patternendtime, patternstartprice, patternendprice, resx0, resx1, supportx0, supportx1, resy0, resy1, supporty0, supporty1, supportgradient, resgradient, riskreward, qtytp, predictionpricefrom, predictionpriceto, predictiontimefrom, predictiontimeto, patternquality, trendchange, maxmovementafterbreakout, latestbaratbreakouttime, latestbaratbreakoutprice, patternlengthbars, temporarypattern, symbolid, resultuid, relevancestartdistance, simulation, writtendatetime, old_resultuid) to stdout;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

18

0ms

2

Details

0ms

copy public.satelliteauthentication (id, satelliteserverid, brokerid, authenticationstatus, maketradeurl, notifications, validusername, validpassword, enabled) to stdout;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

19

0ms

2

Details

0ms

lock table archive.patternresultsage in access share mode;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

20

0ms

1

Details

0ms

copy public.processes (id, locale, region, schedule, enabled, live, lastmodified, lastrun, contenttypeid, brokerid, uuid) to stdout;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 21	06	1	0ms	0ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

6,425

Details

0ms

select ?;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Feb 21	06	6,425	0ms	0ms

2

4,213

Details

0ms

insert into executionlogs (executionid, status, message, details, detailtype) values (null, ?, ?, null, null);

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Feb 21	06	4,213	0ms	0ms

3

3,425

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

Day	Hour	Count	Duration	Avg duration
Feb 21	06	3,425	0ms	0ms

4

3,287

Details

0ms

select datid, datname, pid, usesysid, usename, application_name, client_addr, client_hostname, client_port, backend_start, xact_start, query_start, state_change, wait_event_type, wait_event, state, backend_xid, backend_xmin, query, backend_type from pg_stat_activity where backend_type != ? or (coalesce(trim(query), ?) != ? and pid != pg_backend_pid() and query_start is not null and datname not ilike ? and datname not ilike ? and datname not ilike ? and datname not ilike ? and not (query_start < ?::timestamptz and state = ?));

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 21	06	3,287	0ms	0ms

5

3,007

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

Day	Hour	Count	Duration	Avg duration
Feb 21	06	3,007	0ms	0ms

6

2,718

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

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2,718	0ms	0ms

7

2,529

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

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2,529	0ms	0ms

8

2,442

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

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2,442	0ms	0ms

9

1,664

Details

0ms

select pg_catalog.format_type(?::pg_catalog.oid, null);

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Feb 21	06	1,664	0ms	0ms

10

1,190

Details

0ms

select relname, schemaname, indexrelname, idx_scan, idx_tup_read, idx_tup_fetch, pg_relation_size(indexrelid) as index_size from pg_stat_user_indexes where ((relname ~ ?));

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Feb 21	06	1,190	0ms	0ms

11

1,190

Details

0ms

select relname, schemaname, heap_blks_read, heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read, toast_blks_hit, tidx_blks_read, tidx_blks_hit from pg_statio_user_tables where ((relname ~ ?));

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Feb 21	06	1,190	0ms	0ms

12

1,190

Details

0ms

select n.nspname as schemaname, count(*) from ( select c.relnamespace from pg_class c where c.relkind in (...)) as subquery left join pg_namespace n on (n.oid = relnamespace) where n.nspname not in (...) group by n.nspname;

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Feb 21	06	1,190	0ms	0ms

13

1,190

Details

0ms

select mode, locktype, pn.nspname, pd.datname, pc.relname, granted, fastpath, count(*) as lock_count from pg_locks l join pg_database pd on (l.database = pd.oid) join pg_class pc on (l.relation = pc.oid) left join pg_namespace pn on (pn.oid = pc.relnamespace) where ((relname ~ ?)) and l.mode is not null and pc.relname not like ? escape ? group by pd.datname, pc.relname, pn.nspname, locktype, mode, granted, fastpath;

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Feb 21	06	1,190	0ms	0ms

14

1,190

Details

0ms

select current_database(), s.schemaname, s.table, s.partition_of, s.relpages, s.reltuples, s.relallvisible, s.relation_size + s.toast_size, s.relation_size, s.index_size, s.toast_size, s.relation_size + s.index_size + s.toast_size from ( select n.nspname as schemaname, relname as table, i.inhparent::regclass as partition_of, c.relpages, c.reltuples, c.relallvisible, pg_relation_size(c.oid) as relation_size, case when c.relhasindex then pg_indexes_size(c.oid) else ? end as index_size, case when c.reltoastrelid > ? then pg_relation_size(c.reltoastrelid) else ? end as toast_size from pg_class c left join pg_namespace n on (n.oid = c.relnamespace) left join pg_inherits i on (i.inhrelid = c.oid) left join pg_locks l on c.oid = l.relation and l.locktype = ? where not (nspname = any (?)) and (l.relation is null or l.mode <> ? or not l.granted) and relkind = ? and ((relname ~ ?)) limit ?) as s;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Feb 21	06	1,190	0ms	0ms

15

1,190

Details

0ms

select relname, schemaname, seq_scan, seq_tup_read, idx_scan, idx_tup_fetch, n_tup_ins, n_tup_upd, n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup, vacuum_count, autovacuum_count, analyze_count, autoanalyze_count, extract(epoch from age(current_timestamp, last_vacuum)), extract(epoch from age(current_timestamp, last_autovacuum)), extract(epoch from age(current_timestamp, last_analyze)), extract(epoch from age(current_timestamp, last_autoanalyze)) from pg_stat_user_tables where ((relname ~ ?));

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Feb 21	06	1,190	0ms	0ms

16

1,022

Details

0ms

set extra_float_digits = ?;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Feb 21	06	1,022	0ms	0ms

17

1,010

Details

0ms

set application_name = ?;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Feb 21	06	1,010	0ms	0ms

18

976

Details

0ms

select oid, tableoid, pol.polname, pol.polcmd, pol.polpermissive, case when pol.polroles = ? then null else pg_catalog.array_to_string(array ( select pg_catalog.quote_ident(rolname) from pg_catalog.pg_roles where oid = any (pol.polroles)), ?) end as polroles, pg_catalog.pg_get_expr(pol.polqual, pol.polrelid) as polqual, pg_catalog.pg_get_expr(pol.polwithcheck, pol.polrelid) as polwithcheck from pg_catalog.pg_policy pol where polrelid = ?;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Feb 21	06	976	0ms	0ms

19

945

Details

0ms

select datetimeupdate from latest_candle_datetime_per_receng where recognitionengine ilike ?;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Feb 21	06	945	0ms	0ms

SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'HOTFOREX - 1';

Date: 2026-02-21 06:19:00 Duration: 0ms

20

786

Details

0ms

select a.attnum, a.attname, a.atttypmod, a.attstattarget, a.attstorage, t.typstorage, a.attnotnull, a.atthasdef, a.attisdropped, a.attlen, a.attalign, a.attislocal, pg_catalog.format_type(t.oid, a.atttypmod) as atttypname, a.attgenerated, case when a.atthasmissing and not a.attisdropped then a.attmissingval else null end as attmissingval, a.attidentity, pg_catalog.array_to_string(array ( select pg_catalog.quote_ident(option_name) || ? || pg_catalog.quote_literal(option_value) from pg_catalog.pg_options_to_table(attfdwoptions) order by option_name), e ?) as attfdwoptions, case when a.attcollation <> t.typcollation then a.attcollation else ? end as attcollation, array_to_string(a.attoptions, ?) as attoptions from pg_catalog.pg_attribute a left join pg_catalog.pg_type t on a.atttypid = t.oid where a.attrelid = ?::pg_catalog.oid and a.attnum > ?::pg_catalog.int2 order by a.attnum;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 21	06	786	0ms	0ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

1

Details

0ms

lock table public.stats_hrs_summary_by_groups in access share mode;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Feb 21	06	1	0ms	0ms

2

0ms

2

Details

0ms

copy public.powerstats_trumpet (symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) to stdout;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

3

0ms

2

Details

0ms

select last_value, is_called from public.stats_by_groups_statsid_seq;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

4

0ms

2

Details

0ms

lock table public.timezones_korean in access share mode;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

5

0ms

13

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

Day	Hour	Count	Duration	Avg duration
Feb 21	06	13	0ms	0ms

6

0ms

2

Details

0ms

copy public.t30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived, pricesadjusted, relevanceprocessed, recengprocessedadjusted, historical) to stdout;

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

7

0ms

1

Details

0ms

copy public.processresults (id, processid, resultdate, shorttext, longtext, title, test) to stdout;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Feb 21	06	1	0ms	0ms

8

0ms

2,442

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

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2,442	0ms	0ms

9

0ms

2

Details

0ms

select last_value, is_called from public.keylevels_results_resultuid_seq19;

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

10

0ms

2

Details

0ms

copy archive.whatshot (whid, brokerid, whdatetime, jobcompletiontime) to stdout;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

11

0ms

5

Details

0ms

set synchronize_seqscans to off;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Feb 21	06	5	0ms	0ms

12

0ms

1

Details

0ms

select last_value, is_called from public."ProcessLocaleParameters_id_seq";

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Feb 21	06	1	0ms	0ms

13

0ms

976

Details

0ms

select oid, tableoid, pol.polname, pol.polcmd, pol.polpermissive, case when pol.polroles = ? then null else pg_catalog.array_to_string(array ( select pg_catalog.quote_ident(rolname) from pg_catalog.pg_roles where oid = any (pol.polroles)), ?) end as polroles, pg_catalog.pg_get_expr(pol.polqual, pol.polrelid) as polqual, pg_catalog.pg_get_expr(pol.polwithcheck, pol.polrelid) as polwithcheck from pg_catalog.pg_policy pol where polrelid = ?;

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Feb 21	06	976	0ms	0ms

14

0ms

2

Details

0ms

lock table public.timezones_turkish in access share mode;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

15

0ms

2

Details

0ms

copy public.timezones_greek (timezoneid, timezone) to stdout;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

16

0ms

2

Details

0ms

lock table public.futures_symbols in access share mode;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

17

0ms

2

Details

0ms

copy archive.autochartist_results (resultid, bandwidth, pattern, gmttimefound, direction, initialtrend, breakout, volumeincrease, noise, symmetry, patternstarttime, patternendtime, patternstartprice, patternendprice, resx0, resx1, supportx0, supportx1, resy0, resy1, supporty0, supporty1, supportgradient, resgradient, riskreward, qtytp, predictionpricefrom, predictionpriceto, predictiontimefrom, predictiontimeto, patternquality, trendchange, maxmovementafterbreakout, latestbaratbreakouttime, latestbaratbreakoutprice, patternlengthbars, temporarypattern, symbolid, resultuid, relevancestartdistance, simulation, writtendatetime, old_resultuid) to stdout;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

18

0ms

2

Details

0ms

copy public.satelliteauthentication (id, satelliteserverid, brokerid, authenticationstatus, maketradeurl, notifications, validusername, validpassword, enabled) to stdout;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

19

0ms

2

Details

0ms

lock table archive.patternresultsage in access share mode;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Feb 21	06	2	0ms	0ms

20

0ms

1

Details

0ms

copy public.processes (id, locale, region, schedule, enabled, live, lastmodified, lastrun, contenttypeid, brokerid, uuid) to stdout;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 21	06	1	0ms	0ms

Time consuming prepare


Date: 2026-02-21 06:15:23
Duration: 5ms
Database: postgres
Date: 2026-02-21 06:02:03
Duration: 2ms
Database: postgres
Date: 2026-02-21 06:31:17
Duration: 1ms
Database: postgres
Date: 2026-02-21 06:11:30
Duration: 2ms
Database: postgres
Date: 2026-02-21 06:01:31
Duration: 0ms
Database: postgres
Date: 2026-02-21 06:41:42
Duration: 0ms
Database: postgres
Date: 2026-02-21 06:02:13
Duration: 0ms
Database: postgres
Date: 2026-02-21 06:04:51
Duration: 0ms
Database: postgres
Date: 2026-02-21 06:40:02
Duration: 9ms
Database: postgres
Date: 2026-02-21 06:11:30
Duration: 0ms
Database: postgres
Date: 2026-02-21 06:36:06
Duration: 0ms
Database: postgres
Date: 2026-02-21 06:01:56
Duration: 0ms
Database: postgres
Date: 2026-02-21 06:10:03
Duration: 2ms
Database: postgres
Date: 2026-02-21 06:01:10
Duration: 0ms
Database: postgres
Date: 2026-02-21 06:28:17
Duration: 7ms
Database: postgres
Date: 2026-02-21 06:04:01
Duration: 1ms
Database: postgres
Date: 2026-02-21 06:37:49
Duration: 4ms
Database: postgres
Date: 2026-02-21 06:28:17
Duration: 4ms
Database: postgres
Date: 2026-02-21 06:28:17
Duration: 4ms
Database: postgres
Date: 2026-02-21 06:37:48
Duration: 2ms
Database: postgres

Time consuming bind

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

12s359ms

1,580

Details

0ms

55ms

7ms

WITH rar_max as ( ;

Times Reported Time consuming bind #1

Day	Hour	Count	Duration	Avg duration
Feb 21	06	1,580	12s359ms	7ms

WITH rar_max as ( ;

Date: 2026-02-21 06:38:59 Duration: 55ms Database: postgres parameters: $1 = '689', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '0', $10 = 't', $11 = '0', $12 = '0'
WITH rar_max as ( ;

Date: 2026-02-21 06:15:23 Duration: 31ms Database: postgres parameters: $1 = '538', $2 = '7', $3 = '15', $4 = '30', $5 = '60', $6 = '120', $7 = '240', $8 = '480', $9 = '1440', $10 = '0', $11 = '', $12 = '125', $13 = 'ANGLO', $14 = 'BARC', $15 = 'BAY', $16 = 'BPLON', $17 = 'HSBCL', $18 = 'LLOY', $19 = 'RIO', $20 = 'RollsRoyce', $21 = 'TESCO', $22 = 'VOD', $23 = 'AUDCAD', $24 = 'AUDCHF', $25 = 'AUDJPY', $26 = 'AUDNZD', $27 = 'AUDUSD', $28 = 'CADCHF', $29 = 'CADJPY', $30 = 'CHFJPY', $31 = 'EURAUD', $32 = 'EURCAD', $33 = 'EURCHF', $34 = 'EURDKK', $35 = 'EURGBP', $36 = 'EURHUF', $37 = 'EURJPY', $38 = 'EURNOK', $39 = 'EURNZD', $40 = 'EURPLN', $41 = 'EURUSD', $42 = 'GBPAUD', $43 = 'GBPCAD', $44 = 'GBPCHF', $45 = 'GBPJPY', $46 = 'GBPNZD', $47 = 'GBPUSD', $48 = 'GBPZAR', $49 = 'NZDCAD', $50 = 'NZDCHF', $51 = 'NZDJPY', $52 = 'NZDUSD', $53 = 'USDCAD', $54 = 'USDCHF', $55 = 'USDCNH', $56 = 'USDCZK', $57 = 'USDDKK', $58 = 'USDHKD', $59 = 'USDHUF', $60 = 'USDJPY', $61 = 'USDMXN', $62 = 'USDNOK', $63 = 'USDPLN', $64 = 'USDSEK', $65 = 'USDSGD', $66 = 'USDTRY', $67 = 'USDZAR', $68 = 'XAGEUR', $69 = 'XAGUSD', $70 = 'XAUEUR', $71 = 'XAUUSD', $72 = 'ZARJPY', $73 = 'Cocoa', $74 = 'Coffee', $75 = 'Copper', $76 = 'Palladium', $77 = 'Platinum', $78 = 'Sugar', $79 = 'UKOIL', $80 = 'USOIL', $81 = 'AUS200', $82 = 'FRA40', $83 = 'JPN225', $84 = 'NETH25', $85 = 'SPA35', $86 = 'SUI20', $87 = 'UK100', $88 = 'USA100', $89 = 'USA30', $90 = 'USDIndex', $91 = 'ALCOA', $92 = 'ALIBABA', $93 = 'AMAZON', $94 = 'AMEX', $95 = 'APPLE', $96 = 'BBVA', $97 = 'BOA', $98 = 'BOEING', $99 = 'CHEVRON', $100 = 'CISCO', $101 = 'COKE', $102 = 'EBAY', $103 = 'GE', $104 = 'GOOGLE', $105 = 'GS', $106 = 'HLT', $107 = 'IBM', $108 = 'ILMN', $109 = 'INTEL', $110 = 'Iberdrola', $111 = 'MCARD', $112 = 'MCDON', $113 = 'META', $114 = 'MSFT', $115 = 'Mapfre', $116 = 'Netflix', $117 = 'PFIZER', $118 = 'QCOM', $119 = 'Santander', $120 = 'TEVA', $121 = 'Telefonica', $122 = 'Tesla', $123 = 'AUDUSD', $124 = 'EURGBP', $125 = 'EURUSD', $126 = 'GBPUSD', $127 = 'NZDUSD', $128 = 'USDCAD', $129 = 'USDCHF', $130 = 'USDJPY', $131 = 'Adidas', $132 = 'Bayer', $133 = 'Daimler', $134 = 'Danone', $135 = 'LVMH', $136 = 'Lufthansa', $137 = 'Volksw', $138 = '500', $139 = '500', $140 = 't', $141 = '10', $142 = '10'
WITH rar_max as ( ;

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

2

2s527ms

7,330

Details

0ms

17ms

0ms

SELECT ;

Times Reported Time consuming bind #2

Day	Hour	Count	Duration	Avg duration
	06	7,330	2s527ms	0ms

SELECT ;

Date: 2026-02-21 06:15:15 Duration: 17ms Database: postgres parameters: $1 = '515840243198780300'
SELECT ;

Date: 2026-02-21 06:15:15 Duration: 11ms Database: postgres parameters: $1 = '515840243198780300'
SELECT ;

Date: 2026-02-21 06:30:17 Duration: 10ms Database: postgres parameters: $1 = '515840243198780300'

3

1s413ms

709

Details

1ms

3ms

1ms

SELECT symbolid, ;

Times Reported Time consuming bind #3

Day	Hour	Count	Duration	Avg duration
	06	709	1s413ms	1ms

SELECT symbolid, ;

Date: 2026-02-21 06:15:18 Duration: 3ms Database: postgres parameters: $1 = 'MILLENNIUMPF', $2 = '15', $3 = 'NZDUSD', $4 = 'RK_HSI', $5 = 'NZDUSD.ID', $6 = 'OIL', $7 = 'R_SSI', $8 = 'RK_SSI', $9 = 'NZDUSD.FX', $10 = 'NZDJPY.ID', $11 = 'R_HSI', $12 = 'SP500'
SELECT symbolid, ;

Date: 2026-02-21 06:11:32 Duration: 3ms Database: postgres parameters: $1 = 'BDSWISS', $2 = '60', $3 = '#CAT', $4 = '#DIS', $5 = '#EA'
SELECT symbolid, ;

Date: 2026-02-21 06:11:26 Duration: 3ms Database: postgres parameters: $1 = 'BDSWISS', $2 = '60', $3 = '#ADBE', $4 = '#APPL', $5 = '#AMZN'

4

553ms

350

Details

1ms

2ms

1ms

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

Times Reported Time consuming bind #4

Day	Hour	Count	Duration	Avg duration
	06	350	553ms	1ms

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

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

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

Date: 2026-02-21 06:00:13 Duration: 2ms Database: postgres parameters: $1 = 'ATFX'

5

351ms

45

Details

4ms

30ms

7ms

WITH last_candle AS ( ;

Times Reported Time consuming bind #5

Day	Hour	Count	Duration	Avg duration
	06	45	351ms	7ms

WITH last_candle AS ( ;

Date: 2026-02-21 06:24:04 Duration: 30ms Database: postgres parameters: $1 = '558', $2 = '558'
WITH last_candle AS ( ;

Date: 2026-02-21 06:48:01 Duration: 28ms Database: postgres parameters: $1 = '558', $2 = '558'
WITH last_candle AS ( ;

Date: 2026-02-21 06:52:00 Duration: 11ms Database: postgres parameters: $1 = '558', $2 = '558'

6

177ms

2,442

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
	06	2,442	177ms	0ms

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

Date: 2026-02-21 06:01:31 Duration: 0ms Database: postgres parameters: $1 = '2026-02-20 21:00:00', $2 = '115.25', $3 = '115.46', $4 = '114.91', $5 = '115.35', $6 = '2669', $7 = '515840247879403300', $8 = '0', $9 = '2026-02-21 06:01:31.506', $10 = '2026-02-21 06:01:31.422', $11 = '115.25', $12 = '115.46', $13 = '114.91', $14 = '115.35', $15 = '2669', $16 = '0', $17 = '2026-02-21 06:01:31.506', $18 = '2026-02-21 06:01:31.422'
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-21 06:11:04 Duration: 0ms Database: postgres parameters: $1 = '2026-02-20 22:00:00', $2 = '49551.4', $3 = '49635.55', $4 = '49544', $5 = '49631.4', $6 = '26850', $7 = '515840248000890300', $8 = '0', $9 = '2026-02-21 06:11:04.528', $10 = '2026-02-21 06:11:04.452', $11 = '49551.4', $12 = '49635.55', $13 = '49544', $14 = '49631.4', $15 = '26850', $16 = '0', $17 = '2026-02-21 06:11:04.528', $18 = '2026-02-21 06:11:04.452'
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-21 06:01:17 Duration: 0ms Database: postgres parameters: $1 = '2026-02-20 22:00:00', $2 = '209.2025', $3 = '209.2175', $4 = '209.0525', $5 = '209.172', $6 = '5338', $7 = '515840230496331300', $8 = '0', $9 = '2026-02-21 06:01:17.396', $10 = '2026-02-21 06:01:17.395', $11 = '209.2025', $12 = '209.2175', $13 = '209.0525', $14 = '209.172', $15 = '5338', $16 = '0', $17 = '2026-02-21 06:01:17.396', $18 = '2026-02-21 06:01:17.395'

7

156ms

2,529

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

Day	Hour	Count	Duration	Avg duration
	06	2,529	156ms	0ms

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

Date: 2026-02-21 06:41:42 Duration: 0ms Database: postgres parameters: $1 = '2026-02-20 21:00:00', $2 = '9088.4', $3 = '9088.75', $4 = '9081.4', $5 = '9083.9', $6 = '4215', $7 = '515840248015340300', $8 = '0', $9 = '2026-02-21 06:41:42.286', $10 = '2026-02-21 06:41:42.163', $11 = '9088.4', $12 = '9088.75', $13 = '9081.4', $14 = '9083.9', $15 = '4215', $16 = '0', $17 = '2026-02-21 06:41:42.286', $18 = '2026-02-21 06:41:42.163'
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-21 06:15:20 Duration: 0ms Database: postgres parameters: $1 = '2026-02-21 00:30:00', $2 = '1.179035', $3 = '1.179065', $4 = '1.178', $5 = '1.178185', $6 = '1655', $7 = '515840249372632300', $8 = '0', $9 = '2026-02-21 06:15:20.438', $10 = '2026-02-21 06:15:20.401', $11 = '1.179035', $12 = '1.179065', $13 = '1.178', $14 = '1.178185', $15 = '1655', $16 = '0', $17 = '2026-02-21 06:15:20.438', $18 = '2026-02-21 06:15:20.401'
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-21 06:41:04 Duration: 0ms Database: postgres parameters: $1 = '2026-02-20 23:00:00', $2 = '49631.05', $3 = '49655.55', $4 = '49612.55', $5 = '49621.05', $6 = '5610', $7 = '515840248000726300', $8 = '0', $9 = '2026-02-21 06:41:04.049', $10 = '2026-02-21 06:41:03.963', $11 = '49631.05', $12 = '49655.55', $13 = '49612.55', $14 = '49621.05', $15 = '5610', $16 = '0', $17 = '2026-02-21 06:41:04.049', $18 = '2026-02-21 06:41:03.963'

8

116ms

6,315

Details

0ms

1ms

0ms

select 1;

Times Reported Time consuming bind #8

Day	Hour	Count	Duration	Avg duration
	06	6,315	116ms	0ms

select 1;

Date: 2026-02-21 06:14:08 Duration: 1ms Database: postgres
select 1;

Date: 2026-02-21 06:52:29 Duration: 1ms Database: postgres
select 1;

Date: 2026-02-21 06:50:51 Duration: 1ms Database: postgres

9

110ms

3,007

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
	06	3,007	110ms	0ms

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

Date: 2026-02-21 06:04:51 Duration: 0ms Database: postgres parameters: $1 = '2026-02-20 21:00:00', $2 = '46592.49', $3 = '46602.51', $4 = '46575.01', $5 = '46585.01', $6 = '358', $7 = '500991628285199200', $8 = '0', $9 = '2026-02-21 06:04:51.222', $10 = '2026-02-21 06:04:51.152', $11 = '46592.49', $12 = '46602.51', $13 = '46575.01', $14 = '46585.01', $15 = '358', $16 = '0', $17 = '2026-02-21 06:04:51.222', $18 = '2026-02-21 06:04:51.152'
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-21 06:32:40 Duration: 0ms Database: postgres parameters: $1 = '2025-11-22 00:00:00', $2 = '21.535', $3 = '21.585', $4 = '21.455', $5 = '21.485', $6 = '104', $7 = '515840249466545300', $8 = '0', $9 = '2026-02-21 06:32:40.726', $10 = '2026-02-21 06:32:40.695', $11 = '21.535', $12 = '21.585', $13 = '21.455', $14 = '21.485', $15 = '104', $16 = '0', $17 = '2026-02-21 06:32:40.726', $18 = '2026-02-21 06:32:40.695'
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-21 06:47:29 Duration: 0ms Database: postgres parameters: $1 = '2026-02-21 00:45:00', $2 = '71.275', $3 = '71.29', $4 = '71.205', $5 = '71.24', $6 = '43', $7 = '515840249389884300', $8 = '0', $9 = '2026-02-21 06:47:29.512', $10 = '2026-02-21 06:47:29.465', $11 = '71.275', $12 = '71.29', $13 = '71.205', $14 = '71.24', $15 = '43', $16 = '0', $17 = '2026-02-21 06:47:29.512', $18 = '2026-02-21 06:47:29.465'

10

96ms

12

Details

0ms

47ms

8ms

with wh_patitioned as ( ;

Times Reported Time consuming bind #10

Day	Hour	Count	Duration	Avg duration
	06	12	96ms	8ms

with wh_patitioned as ( ;

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

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

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

11

45ms

1

Details

45ms

select * from broker_stats_groups_view where brokerid = 538 limit 50;

Times Reported Time consuming bind #11

Day	Hour	Count	Duration	Avg duration
	06	1	45ms	45ms

select * from broker_stats_groups_view where brokerid = 538 limit 50;

Date: 2026-02-21 06:28:17 Duration: 45ms Database: postgres

12

40ms

24

Details

0ms

37ms

1ms

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

Times Reported Time consuming bind #12

Day	Hour	Count	Duration	Avg duration
	06	24	40ms	1ms

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

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

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

Date: 2026-02-21 06:29:13 Duration: 0ms Database: postgres parameters: $1 = '689', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'

13

38ms

1

Details

38ms

select * from broker_stats_groups_view where brokerid = 632 limit 50;

Times Reported Time consuming bind #13

Day	Hour	Count	Duration	Avg duration
	06	1	38ms	38ms

select * from broker_stats_groups_view where brokerid = 632 limit 50;

Date: 2026-02-21 06:28:17 Duration: 38ms Database: postgres

14

35ms

1

Details

35ms

select * from broker_stats_groups_view where brokerid = 634 limit 50;

Times Reported Time consuming bind #14

Day	Hour	Count	Duration	Avg duration
	06	1	35ms	35ms

select * from broker_stats_groups_view where brokerid = 634 limit 50;

Date: 2026-02-21 06:37:49 Duration: 35ms Database: postgres

15

34ms

1

Details

34ms

select * from broker_stats_groups_view where brokerid = 549 limit 50;

Times Reported Time consuming bind #15

Day	Hour	Count	Duration	Avg duration
	06	1	34ms	34ms

select * from broker_stats_groups_view where brokerid = 549 limit 50;

Date: 2026-02-21 06:38:06 Duration: 34ms Database: postgres

16

34ms

1

Details

34ms

select * from broker_stats_groups_view where brokerid = 631 limit 50;

Times Reported Time consuming bind #16

Day	Hour	Count	Duration	Avg duration
	06	1	34ms	34ms

select * from broker_stats_groups_view where brokerid = 631 limit 50;

Date: 2026-02-21 06:38:14 Duration: 34ms Database: postgres

17

33ms

1

Details

33ms

select * from broker_stats_groups_view where brokerid = 635 limit 50;

Times Reported Time consuming bind #17

Day	Hour	Count	Duration	Avg duration
	06	1	33ms	33ms

select * from broker_stats_groups_view where brokerid = 635 limit 50;

Date: 2026-02-21 06:38:06 Duration: 33ms Database: postgres

18

33ms

1

Details

33ms

select * from broker_stats_groups_view where brokerid = 633 limit 50;

Times Reported Time consuming bind #18

Day	Hour	Count	Duration	Avg duration
	06	1	33ms	33ms

select * from broker_stats_groups_view where brokerid = 633 limit 50;

Date: 2026-02-21 06:38:15 Duration: 33ms Database: postgres

19

32ms

1

Details

32ms

select * from broker_stats_groups_view where brokerid = 1505 limit 50;

Times Reported Time consuming bind #19

Day	Hour	Count	Duration	Avg duration
	06	1	32ms	32ms

select * from broker_stats_groups_view where brokerid = 1505 limit 50;

Date: 2026-02-21 06:58:21 Duration: 32ms Database: postgres

20

24ms

1

Details

24ms

select * from broker_stats_groups_view where brokerid = 972 limit 50;

Times Reported Time consuming bind #20

Day	Hour	Count	Duration	Avg duration
	06	1	24ms	24ms

select * from broker_stats_groups_view where brokerid = 972 limit 50;

Date: 2026-02-21 06:51:13 Duration: 24ms Database: postgres

Log levels

Key values

211,960 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	1	0.00%
DETAIL	37,555	17.72%
ERROR	984	0.46%
HINT	76	0.04%
LOG	172,340	81.31%
STATEMENT	1,004	0.47%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
988 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

426 Max number of times the same event was reported
988 Total events found

Rank

Times reported

Error

1

426

Details

ERROR: integer out of range

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Feb 21	06	426

ERROR: integer out of range

2

356

Details

ERROR: pg_stat_statements must be loaded via shared_preload_libraries

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Feb 21	06	356

ERROR: pg_stat_statements must be loaded via shared_preload_libraries

3

76

Details

ERROR: syntax error at or near "..."

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Feb 21	06	76

ERROR: syntax error at or near "group" at character 55
ERROR: syntax error at or near "group" at character 61

4

76

Details

ERROR: function broker_stats_get_symbols_function(...) does not exist

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Feb 21	06	76

ERROR: function broker_stats_get_symbols_function(bigint, integer) does not exist at character 15

5

41

Details

ERROR: schema "..." does not exist

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Feb 21	06	41

ERROR: schema "datadog" does not exist at character 38

6

8

Details

LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... ms

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Feb 21	06	8

LOG: process 22276 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.049 ms at character 28
LOG: process 22576 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.045 ms at character 28
LOG: process 22747 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.039 ms at character 28

7

4

Details

ERROR: relation "..." does not exist

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Feb 21	06	4

ERROR: relation "stats_by_groups" does not exist at character 32
ERROR: relation "stats_symbols_by_groups" does not exist at character 60

8

1

Details

LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Feb 21	06	1

LOG: process 25225 still waiting for AccessExclusiveLock on relation 5894441 of database 5881926 after 1000.049 ms

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

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

Key values