pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Thu Feb 12 04:59:45 2026
Log file: /home/postgres/pg_data/data/pg_log/postgresql-2026-02-12_060000.log
Parsed 1,939,204 log entries in 44s
Log start from 2026-02-12 06:00:00 to 2026-02-12 06:59:43

Global Stats

1,009 Number of unique normalized queries
208,082 Number of queries
4h7m29s Total query duration
2026-02-12 06:00:00 First query
2026-02-12 06:59:43 Last query
6,594 queries/s at 2026-02-12 06:05:02 Query peak

4h7m29s Total query duration
2m29s Prepare/parse total duration
1m8s Bind total duration
4h3m51s Execute total duration

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

47 Total number of automatic vacuums
53 Total number of automatic analyzes

759 Number temporary file
168.08 MiB Max size of temporary file
7.38 MiB Average size of temporary file

3,517 Total number of sessions
12 sessions at 2026-02-12 06:56:04 Session peak
4d2h30m18s Total duration of sessions
1m40s Average duration of sessions
59 Average queries per session
4s222ms Average queries duration per session
1m36s Average idle time per session

3,517 Total number of connections
27 connections/s at 2026-02-12 06:48:48 Connection peak
6 Total number of databases

SQL Traffic

Key values

6,594 queries/s Query Peak
2026-02-12 06:05:02 Date

SELECT Traffic

Key values

3,290 queries/s Query Peak
2026-02-12 06:05:02 Date

INSERT/UPDATE/DELETE Traffic

Key values

205 queries/s Query Peak
2026-02-12 06:00:51 Date

Queries duration

Key values

4h7m29s 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 12	06	208,082	0ms	14m38s	70ms	6m13s	8m2s	27m58s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 12	06	65,567	601	0ms	0ms	0ms	0ms

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 12	06	22,802	1,562	13	78	0ms	0ms	0ms	0ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Feb 12	06	25,445	73,508	2.89	26.05%

Day	Hour	Count	Average / Second
Feb 12	06	3,517	0.98/s

Day	Hour	Count	Average Duration	Average idle time
Feb 12	06	3,517	1m40s	1m36s

↑ Back to the top of the General Activity table

Established Connections

Key values

27 connections Connection Peak
2026-02-12 06:48:48 Date

Connections per database

Key values

acaweb_fx Main Database
3,517 connections Total

Chart
Table

Database	User	Count
acaweb_fx		3,440
	pg_dump	1
	postgres	3,125
	psql	314
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
3,517 connections Total

Chart
Table

User	Count
pg_dump	5
postgres	3,196
psql	316

Connections per host

Key values

192.168.4.142 Main host with 1147 connections
3,517 Total connections

Chart
Table

Host	Count
127.0.0.1	113
192.168.0.114	1
192.168.0.216	103
192.168.0.74	681
192.168.1.145	203
192.168.1.15	230
192.168.1.20	232
192.168.1.231	20
192.168.1.239	14
192.168.1.90	47
192.168.2.126	38
192.168.2.182	12
192.168.3.199	36
192.168.4.107	4
192.168.4.132	1
192.168.4.142	1,147
192.168.4.145	4
192.168.4.150	10
192.168.4.238	8
192.168.4.33	71
192.168.4.52	4
192.168.4.98	330
[local]	208

Simultaneous sessions

Key values

12 sessions Session Peak
2026-02-12 06:56:04 Date

Histogram of session times

Key values

2,792 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	2,792	79.39%
500ms-1s	134	3.81%
1s-30s	348	9.89%
30s-1m	42	1.19%
1m-10m	105	2.99%
10m-30m	78	2.22%
30m-1h	5	0.14%
1h-8h	12	0.34%
> 8h	1	0.03%

Sessions per database

Key values

acaweb_fx Main Database
3,517 sessions Total

Chart
Table

Database	User	Count	Total Duration
acaweb_fx	3,440	4d2h6m37s	1m42s
acaweb_fx_integer	1	20m26s	20m26s
postgres	3	338ms	112ms
socialmedia	72	3m13s	2s688ms
translations	1	205ms	205ms

Sessions per user

Key values

postgres Main User
3,517 sessions Total

Chart
Table

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

Sessions per host

Key values

192.168.4.142 Main Host
3,517 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	113	37m29s	19s908ms
192.168.0.114	1	5m	5m
192.168.0.216	103	1m13s	714ms
192.168.0.74	681	1d6h20m18s	2m40s
192.168.1.145	203	3h49m3s	1m7s
192.168.1.15	230	19h20m29s	5m2s
192.168.1.20	232	13h29m35s	3m29s
192.168.1.231	20	9h53m22s	29m40s
192.168.1.239	14	107ms	7ms
192.168.1.90	47	3m22s	4s314ms
192.168.2.126	38	6s36ms	158ms
192.168.2.182	12	1s23ms	85ms
192.168.3.199	36	1s361ms	37ms
192.168.4.107	4	31s567ms	7s891ms
192.168.4.132	1	245ms	245ms
192.168.4.142	1,147	8m16s	432ms
192.168.4.145	4	44ms	11ms
192.168.4.150	10	20h15m22s	2h1m32s
192.168.4.238	8	11s132ms	1s391ms
192.168.4.33	71	1m7s	948ms
192.168.4.52	4	47ms	11ms
192.168.4.98	330	29s604ms	89ms
[local]	208	24m15s	6s996ms

Sessions per application

Key values

unknown Main Host
3,517 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
unknown	3,517	4d2h30m18s	1m40s

Checkpoints Buffers

Key values

21,107 buffers Checkpoint Peak
2026-02-12 06:06:01 Date
209.922 seconds Highest write time
0.018 seconds Sync time

Checkpoints Wal files

Key values

9 files Wal files usage Peak
2026-02-12 06:06:01 Date

Checkpoints distance

Key values

294.41 Mo Distance Peak
2026-02-12 06:06:01 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Feb 12	06	48,561	1,923.302s	0.102s	1,923.881s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Feb 12	06	0	0	25	1,914	0.009s	0s

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

Day	Hour	Mean distance	Mean estimate
Feb 12	06	34,336.17 kB	99,695.50 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

183.75 MiB Temp Files size Peak
2026-02-12 06:30:12 Date

Number of temporary files

Key values

30 per second Temp Files Peak
2026-02-12 06:32:29 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Feb 12	06	759	5.47 GiB	7.38 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	98	421.45 MiB	4.25 MiB	4.36 MiB	4.30 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-12 06:00:34 Duration: 0ms
2	49	290.17 MiB	3.12 MiB	8.62 MiB	5.92 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-12 06:00:33 Duration: 0ms
3	30	1.64 GiB	2.64 MiB	168.08 MiB	56.10 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = ? ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = ? ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = ?) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, ?::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> ? ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = ?) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = ? where (ok.r is null or ok.r = ?) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = ?) and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > ? ? and last.eventtimestamp > current_timestamp - interval ? and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval ?) and last.eventtimestamp > current_timestamp - interval ? and broker.r = ?; with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; Date: 2026-02-12 06:00:09 Duration: 0ms
4	21	66.03 MiB	3.04 MiB	3.29 MiB	3.14 MiB	select resultuid from relevance_consecutivecandles_results order by resultuid desc limit ?), all_results as ( select ccr.resultuid as resultuid, ccr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, ccr.patternendtime as identified, dtt.timezone as timezone, ccr.qtyconsecutivecandles as length, g.basegroupname, case when rcr.age is not null then rcr.age when ccr.resultuid <= rm.resultuid then ? else ? end as age, case when rcr.relevant is not null then rcr.relevant when ccr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip, newlevels.filtered from consecutivecandles_results ccr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = ccr.symbolid inner join symbols s on ccr.symbolid = s.symbolid and s.nonliquid = ? inner join downloadersymbolsettings dss on ccr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on ccr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join rar_max rm on ? = ? left outer join relevance_consecutivecandles_results rcr on rcr.resultuid = ccr.resultuid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? left join lateral calc_cc_signal_filter (ccr.resultuid) newlevels on true where ccr.gmttimefound > now() - interval ? and s.deleted = ? and (ccr.simulation = ? or ccr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ccr.patternlengthbars <= ?)), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc; SELECT resultuid FROM relevance_consecutivecandles_results ORDER BY resultuid DESC LIMIT 1), all_results AS ( SELECT ccr.resultuid AS resultuid, ccr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, ccr.patternendtime AS identified, dtt.timezone AS timezone, ccr.qtyconsecutivecandles AS length, g.basegroupname, CASE WHEN rcr.age IS NOT NULL THEN rcr.age WHEN ccr.resultuid <= rm.resultuid THEN 1 ELSE 0 END as age, CASE WHEN rcr.relevant IS NOT NULL THEN rcr.relevant WHEN ccr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip, newLevels.filtered FROM consecutivecandles_results ccr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = ccr.symbolid INNER JOIN symbols s ON ccr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN downloadersymbolsettings dss ON ccr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on ccr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_consecutivecandles_results rcr ON rcr.resultuid = ccr.resultuid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' LEFT JOIN LATERAL calc_cc_signal_filter (ccr.resultuid) newLevels on true WHERE ccr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (ccr.simulation = 0 OR ccr.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3, $4, $5, $6, $7, $8, $9)) AND ($10 = 0 OR s.exchange in ($11)) AND ($12 = 0 OR coalesce(bim.code, s.symbol) in ($13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322)) AND ($323 = 0 OR ccr.patternlengthbars <= $324)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $325 OR relevant = 1) AND ($326 = 0 OR age <= $327) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; Date: 2026-02-12 06:01:20 Duration: 0ms
5	13	504.05 MiB	38.77 MiB	38.77 MiB	38.77 MiB	update solr_relevance_old set new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total from ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total from whatshot_probability where type = ?) sub where result_uid = sub.resultuid; UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type = 'cp') sub WHERE result_uid = sub.resultuid; Date: 2026-02-12 06:01:14 Duration: 0ms
6	13	929.91 MiB	71.53 MiB	71.53 MiB	71.53 MiB	with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit ?) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then ? else ? end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then ? else ? end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike ? inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike ?) sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike ?; update solr_relevance_old set newrelevant = ? where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike ? and a.resultuid is null); update solr_relevance_old set new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total from ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total from whatshot_probability where type in (...)) sub where result_uid = sub.resultuid; with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid; Date: 2026-02-12 06:01:18 Duration: 0ms
7	8	1.08 GiB	137.82 MiB	137.87 MiB	137.84 MiB	select updateresultsmaterializedview (); select updateresultsmaterializedview (); Date: 2026-02-12 06:02:17 Duration: 0ms
8	4	350.17 MiB	87.48 MiB	87.62 MiB	87.54 MiB	select updateageforrelevantresults (); select updateageforrelevantresults (); Date: 2026-02-12 06:02:08 Duration: 0ms

Queries generating the largest temporary files

Rank	Size	Query
1	168.08 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2026-02-12 06:40:09 ]
2	163.70 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2026-02-12 06:30:09 ]
3	162.84 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2026-02-12 06:10:07 ]
4	156.33 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2026-02-12 06:00:09 ]
5	137.87 MiB	select updateresultsmaterializedview (); [ Date: 2026-02-12 06:02:17 ]
6	137.86 MiB	select updateresultsmaterializedview (); [ Date: 2026-02-12 06:47:35 ]
7	137.84 MiB	select updateresultsmaterializedview (); [ Date: 2026-02-12 06:32:43 ]
8	137.84 MiB	select updateresultsmaterializedview (); [ Date: 2026-02-12 06:50:36 ]
9	137.83 MiB	select updateresultsmaterializedview (); [ Date: 2026-02-12 06:35:41 ]
10	137.83 MiB	select updateresultsmaterializedview (); [ Date: 2026-02-12 06:17:27 ]
11	137.82 MiB	select updateresultsmaterializedview (); [ Date: 2026-02-12 06:05:34 ]
12	137.82 MiB	select updateresultsmaterializedview (); [ Date: 2026-02-12 06:20:41 ]
13	131.60 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2026-02-12 06:20:09 ]
14	97.03 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2026-02-12 06:20:09 ]
15	90.63 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2026-02-12 06:50:09 ]
16	87.62 MiB	select updateageforrelevantresults (); [ Date: 2026-02-12 06:02:08 ]
17	87.55 MiB	select updateageforrelevantresults (); [ Date: 2026-02-12 06:32:20 ]
18	87.52 MiB	select updateageforrelevantresults (); [ Date: 2026-02-12 06:47:20 ]
19	87.48 MiB	select updateageforrelevantresults (); [ Date: 2026-02-12 06:17:12 ]
20	85.09 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2026-02-12 06:30:07 ]

Vacuums / Analyzes Distribution

Key values

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

Analyzes per table

Key values

public.solr_relevance_old (12) Main table analyzed (database acaweb_fx)
53 analyzes Total

Chart
Table

Table	Number of analyzes
acaweb_fx.public.solr_relevance_old	12
acaweb_fx.pg_catalog.pg_attribute	7
acaweb_fx.pg_catalog.pg_class	6
acaweb_fx.pg_catalog.pg_type	4
acaweb_fx.public.relevance_keylevels_results	4
acaweb_fx.public.relevance_fibonacci_results	4
acaweb_fx.public.datafeeds_latestrun	3
acaweb_fx.public.relevance_autochartist_results	3
acaweb_fx.pg_catalog.pg_index	2
acaweb_fx.pg_catalog.pg_depend	2
acaweb_fx.public.latest_t15_candle_view	2
acaweb_fx.public.autochartist_symbolupdates	1
acaweb_fx.public.solr_imports	1
socialmedia.public.processes	1
acaweb_fx.public.latest_candle_datetime_per_receng	1
Total	53

Vacuums per table

Key values

public.solr_relevance_old (17) Main table vacuumed on database acaweb_fx
47 vacuums Total

Chart
Table

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
acaweb_fx.public.solr_relevance_old	17	13	11,845	0	42	0	66	7,453	12	1,273,697
acaweb_fx.pg_catalog.pg_attribute	7	5	5,150	0	612	0	469	1,828	498	3,050,851
acaweb_fx.pg_catalog.pg_type	3	3	478	0	78	0	0	220	51	275,114
acaweb_fx.public.datafeeds_latestrun	3	0	360	0	6	0	0	39	6	40,624
acaweb_fx.pg_catalog.pg_class	3	3	1,360	0	90	0	0	432	87	517,269
acaweb_fx.pg_toast.pg_toast_2619	2	2	267	0	63	0	0	209	59	218,420
acaweb_fx.public.latest_t15_candle_view	2	2	138	0	9	0	0	13	3	25,256
acaweb_fx.public.relevance_keylevels_results	2	2	7,415	0	448	2	194	1,574	741	2,536,037
acaweb_fx.public.relevance_autochartist_results	2	2	6,382	0	299	2	488	1,208	589	1,798,218
acaweb_fx.public.relevance_fibonacci_results	2	2	2,342	0	57	4	94	360	79	364,080
acaweb_fx.public.autochartist_symbolupdates	1	1	19,965	0	4,318	1	38,535	5,434	4,526	2,162,451
acaweb_fx.public.t60	1	1	140,736	0	22,341	0	32,108	33,443	14,635	66,546,628
acaweb_fx.pg_catalog.pg_statistic	1	1	938	0	175	0	594	494	167	656,853
acaweb_fx.pg_catalog.pg_depend	1	1	395	0	66	0	59	173	60	311,337
Total	47	38	197,771	184,713	28,604	9	72,607	52,880	21,513	79,776,835

Tuples removed per table

Key values

public.solr_relevance_old (69688) Main table with removed tuples on database acaweb_fx
147737 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
acaweb_fx.public.solr_relevance_old	17	13	69,688	119,584	25,857	0	3,196
acaweb_fx.public.t60	1	1	56,518	1,475,193	141	0	52,453
acaweb_fx.pg_catalog.pg_attribute	7	5	8,999	81,733	6,895	24	1,845
acaweb_fx.public.autochartist_symbolupdates	1	1	5,375	48,948	0	0	40,691
acaweb_fx.public.relevance_keylevels_results	2	2	2,143	25,883	869	0	558
acaweb_fx.pg_catalog.pg_type	3	3	1,133	4,338	0	2	130
acaweb_fx.pg_catalog.pg_depend	1	1	1,130	14,410	0	0	140
acaweb_fx.pg_catalog.pg_statistic	1	1	707	3,769	0	0	1,194
acaweb_fx.public.relevance_autochartist_results	2	2	668	17,239	0	0	760
acaweb_fx.pg_catalog.pg_class	3	3	566	5,035	88	0	450
acaweb_fx.public.relevance_fibonacci_results	2	2	388	3,075	0	0	204
acaweb_fx.pg_toast.pg_toast_2619	2	2	168	346	12	0	108
acaweb_fx.public.datafeeds_latestrun	3	0	164	42	0	0	48
acaweb_fx.public.latest_t15_candle_view	2	2	90	51	23	0	2
Total	47	38	147,737	1,799,646	33,885	26	101,779

Pages removed per table

Key values

pg_catalog.pg_attribute (24) Main table with removed pages on database acaweb_fx
26 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
acaweb_fx.pg_catalog.pg_attribute	7	5	8999	24
acaweb_fx.pg_catalog.pg_type	3	3	1133	2
acaweb_fx.pg_toast.pg_toast_2619	2	2	168	0
acaweb_fx.public.autochartist_symbolupdates	1	1	5375	0
acaweb_fx.public.datafeeds_latestrun	3	0	164	0
acaweb_fx.public.t60	1	1	56518	0
acaweb_fx.pg_catalog.pg_statistic	1	1	707	0
acaweb_fx.pg_catalog.pg_depend	1	1	1130	0
acaweb_fx.public.latest_t15_candle_view	2	2	90	0
acaweb_fx.public.relevance_keylevels_results	2	2	2143	0
acaweb_fx.pg_catalog.pg_class	3	3	566	0
acaweb_fx.public.solr_relevance_old	17	13	69688	0
acaweb_fx.public.relevance_autochartist_results	2	2	668	0
acaweb_fx.public.relevance_fibonacci_results	2	2	388	0
Total	47	38	147,737	26

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Feb 12	06	47	53

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

AccessShareLock Main Lock Type
7 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
AccessExclusiveLock		2	17m27s	8m43s
	relation	2	17m27s	8m43s
AccessShareLock		5	8m39s	1m43s
	relation	5	8m39s	1m43s
	Total	7	26m6s	3m43s

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	1	14m38s	14m38s	14m38s	14m38s	truncate table solr_relevance_old; TRUNCATE TABLE solr_relevance_old; Date: 2026-02-12 06:19:50
2	3	6m20s	1m8s	2m39s	2m6s	select datetimeupdate from latest_candle_datetime_per_receng where recognitionengine ilike ?; SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'IQFEED_FX - 1'; Date: 2026-02-12 06:19:50
3	1	2m48s	2m48s	2m48s	2m48s	refresh materialized view latest_candle_datetime_per_receng; refresh materialized view latest_candle_datetime_per_receng; Date: 2026-02-12 06:19:50
4	2	2m19s	58s349ms	1m21s	1m9s	select recognitionengine, to_char(datetimeupdate, ?) from latest_candle_datetime_per_receng; select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng; Date: 2026-02-12 06:19:50

Queries that waited the most

Rank	Wait time	Query
1	14m38s	TRUNCATE TABLE solr_relevance_old; [ Date: 2026-02-12 06:19:50 ]
2	2m48s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2026-02-12 06:19:50 ]
3	2m39s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'PEPPERSTONE - 1'; [ Date: 2026-02-12 06:19:50 ]
4	2m31s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'IQFEED_FX - 1'; [ Date: 2026-02-12 06:19:50 ]
5	1m21s	select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng; [ Date: 2026-02-12 06:19:50 ]
6	1m8s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 1'; [ Date: 2026-02-12 06:19:50 ]
7	58s349ms	select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng; [ Date: 2026-02-12 06:19:50 ]

Queries by type

Key values

65,567 Total read queries
32,116 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	65,567	31.51%
INSERT	22,802	10.96%
UPDATE	1,562	0.75%
DELETE	13	0.01%
COPY FROM	78	0.04%
COPY TO	601	0.29%
CTE	6,380	3.07%
DDL	13	0.01%
TCL	667	0.32%
CURSOR	0	0.00%
OTHERS	110,399	53.06%

Queries by database

Key values

unknown Main database
207,194 Requests
4h3m51s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
acaweb_fx	Total	811	0ms
	copy from	65	0ms
	copy to	26	0ms
	cte	85	0ms
	ddl	13	0ms
	delete	13	0ms
	others	169	0ms
	select	73	0ms
	tcl	331	0ms
	update	36	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	207,194	4h3m51s
	copy from	13	0ms
	copy to	575	0ms
	cte	6,295	0ms
	insert	22,802	0ms
	others	6,188	0ms
	select	65,417	0ms
	tcl	336	0ms
	update	1,526	0ms

Queries by user

Key values

unknown Main user
207,194 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	888	0ms
	copy from	65	0ms
	copy to	26	0ms
	cte	85	0ms
	ddl	13	0ms
	delete	13	0ms
	others	169	0ms
	select	150	0ms
	tcl	331	0ms
	update	36	0ms
unknown	Total	207,194	4h3m51s
	copy from	13	0ms
	copy to	575	0ms
	cte	6,295	0ms
	insert	22,802	0ms
	others	6,188	0ms
	select	65,417	0ms
	tcl	336	0ms
	update	1,526	0ms

Duration by user

Key values

4h3m51s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	888	0ms
	copy from	65	0ms
	copy to	26	0ms
	cte	85	0ms
	ddl	13	0ms
	delete	13	0ms
	others	169	0ms
	select	150	0ms
	tcl	331	0ms
	update	36	0ms
unknown	Total	207,194	4h3m51s
	copy from	13	0ms
	copy to	575	0ms
	cte	6,295	0ms
	insert	22,802	0ms
	others	6,188	0ms
	select	65,417	0ms
	tcl	336	0ms
	update	1,526	0ms

Queries by host

Key values

unknown Main host
208,082 Requests
4h3m51s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	208,082	4h3m51s
	copy from	78	0ms
	copy to	601	0ms
	cte	6,380	0ms
	ddl	13	0ms
	delete	13	0ms
	insert	22,802	0ms
	others	6,357	0ms
	select	65,567	0ms
	tcl	667	0ms
	update	1,562	0ms

Queries by application

Key values

unknown Main application
207,761 Requests
4h3m51s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
pg_dump	Total	5	0ms
	select	5	0ms
psql	Total	316	0ms
	copy from	65	0ms
	copy to	26	0ms
	cte	85	0ms
	ddl	13	0ms
	delete	13	0ms
	others	4	0ms
	select	74	0ms
	update	36	0ms
unknown	Total	207,761	4h3m51s
	copy from	13	0ms
	copy to	575	0ms
	cte	6,295	0ms
	insert	22,802	0ms
	others	6,353	0ms
	select	65,488	0ms
	tcl	667	0ms
	update	1,526	0ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-02-12 06:11:02 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

65,008 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	65,008	62.48%
1-5ms	32,153	30.90%
5-10ms	2,196	2.11%
10-25ms	1,262	1.21%
25-50ms	555	0.53%
50-100ms	515	0.49%
100-500ms	706	0.68%
500-1000ms	211	0.20%
1000-10000ms	1,051	1.01%
> 10000ms	385	0.37%

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 12	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 12	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 12	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 12	06	2	0ms	0ms

5

0ms

12

Details

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Feb 12	06	12	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 12	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 12	06	1	0ms	0ms

8

0ms

2,173

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 12	06	2,173	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 12	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 12	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 12	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 12	06	1	0ms	0ms

13

0ms

975

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 12	06	975	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 12	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 12	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 12	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 12	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 12	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 12	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 12	06	1	0ms	0ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

22,891

Details

0ms

select ?;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Feb 12	06	22,891	0ms	0ms

2

14,021

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

Day	Hour	Count	Duration	Avg duration
Feb 12	06	14,021	0ms	0ms

3

8,459

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

Day	Hour	Count	Duration	Avg duration
Feb 12	06	8,459	0ms	0ms

4

5,078

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

Day	Hour	Count	Duration	Avg duration
Feb 12	06	5,078	0ms	0ms

5

4,555

Details

0ms

insert into autochartist_results (resultid, symbolid, bandwidth, pattern, qtytp, gmttimefound, direction, initialtrend, breakout, volumeincrease, noise, symmetry, predictionpricefrom, predictionpriceto, predictiontimefrom, predictiontimeto, patternstarttime, patternendtime, patternstartprice, patternendprice, resx0, resx1, supportx0, supportx1, resy0, resy1, supporty0, supporty1, supportgradient, resgradient, riskreward, patternquality, trendchange, maxmovementafterbreakout, latestbaratbreakouttime, latestbaratbreakoutprice, patternlengthbars, temporarypattern, relevancestartdistance, simulation, writtendatetime) values (?, ?, ?.?, ?, ?, ?::timestamp without time zone, ?, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?::timestamp without time zone, ?::timestamp without time zone, ?::timestamp without time zone, ?::timestamp without time zone, ?.?, ?.?, ?::timestamp without time zone, ?::timestamp without time zone, ?::timestamp without time zone, ?::timestamp without time zone, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?, ?.?, ?::timestamp without time zone, ?.?, ?, ?, ?.?, ?, current_timestamp::timestamp without time zone) on conflict do nothing;

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Feb 12	06	4,555	0ms	0ms

6

3,859

Details

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Feb 12	06	3,859	0ms	0ms

7

3,076

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 12	06	3,076	0ms	0ms

8

2,589

Details

0ms

set extra_float_digits = ?;

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Feb 12	06	2,589	0ms	0ms

9

2,563

Details

0ms

set application_name = ?;

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Feb 12	06	2,563	0ms	0ms

10

2,173

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

Day	Hour	Count	Duration	Avg duration
Feb 12	06	2,173	0ms	0ms

11

1,881

Details

0ms

with rar_max as ( select resultuid from relevance_autochartist_results order by resultuid desc limit ? ) select a.symbolid, pattern, patternid, resy0, resy1, resx0, resx1, supporty0, supporty1, supportx0, supportx1, predictiontimeto, patternstarttime, timegranularity, patternendtime, direction, trendchange, patternlengthbars, patternquality, case when a.old_resultuid = ? then a.old_resultuid else a.resultuid end as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, s.exchange, s.symbol, s.longname, s.shortname, breakout, dtt.timezone, patternstartprice, patternendprice, qtytp, newlevels.profit, newlevels.stop, newlevels.filtered, case when rar.age is not null then rar.age when a.resultuid <= rm.resultuid then ? else ? end as age, case when rar.relevant is not null then rar.relevant when a.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from autochartist_results a inner join downloadersymbolsettings dss on a.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join patterns p on p.patternname = a.pattern inner join rar_max rm on ? = ? left outer join relevance_autochartist_results rar on rar.resultuid = a.resultuid left join lateral calc_cp_signal (a.resultuid) newlevels on true left join currencypips cps on cps.symbol = s.symbol where (a.old_resultuid = ? or a.resultuid = ?) and dtt.dayofweek = ?;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Feb 12	06	1,881	0ms	0ms

12

1,759

Details

0ms

insert into fibonacci_results (bandwidth, pattern, gmttimefound, direction, patternstarttime, patternendtime, patternstartprice, patternendprice, qtytp, pricex, timex, pricea, timea, priceb, timeb, pricec, timec, priced, timed, averagequality, timequality, errormargin, patternlengthbars, target10, target06, target16, target07, target12, target05, target03, symbolid, noise, ratiosfound, temporarypattern, uniqueindex, completed, simulation, writtendatetime) values (?.?, ?, ?::timestamp without time zone, ?, ?::timestamp without time zone, ?::timestamp without time zone, ?.?, ?.?, ?, ?.?, ?::timestamp without time zone, ?.?, ?::timestamp without time zone, ?.?, ?::timestamp without time zone, ?.?, ?::timestamp without time zone, ?.?, ?::timestamp without time zone, ?.?, ?.?, ?.?, ?, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?, ?.?, ?, ?, ?, ?, ?, current_timestamp::timestamp without time zone) on conflict do nothing;

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Feb 12	06	1,759	0ms	0ms

13

1,663

Details

0ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Feb 12	06	1,663	0ms	0ms

14

1,425

Details

0ms

insert into keylevels_results (bandwidth, breakout, patternid, gmttimefound, approachingtimestamp, approachingregion, qtytp, patternlengthbars, patternprice, x0, x1, x2, x3, x4, x5, x6, x7, x8, x9, breakoutbars, breakoutprice, patternendtime, atbaridentified, atpriceidentified, errormargin, direction, symbolid, predictionpricefrom, predictionpriceto, predictiontimefrom, predictiontimebars, uniquepointsvalue, furthestprice, relevancestartdistance, patternclassid, patternstarttime, stoplosslevel, simulation, writtendatetime) values (?.?, ?, ?, ?::timestamp without time zone, ?, ?.?, ?, ?, ?.?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?.?, ?::timestamp without time zone, ?, ?.?, ?.?, ?, ?, ?.?, ?.?, ?::timestamp without time zone, ?, ?, ?.?, ?.?, ?, ?, ?.?, ?, current_timestamp::timestamp without time zone) on conflict do nothing;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Feb 12	06	1,425	0ms	0ms

15

1,115

Details

0ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Feb 12	06	1,115	0ms	0ms

16

1,020

Details

0ms

select symbolid, pricedatetime, classname, downloadfrequency, downloadersymbol, open, high, low, close, volume, bsf, sastdatetimereceived from ( select pricedatetime, dss.classname, dss.downloadfrequency, dss.symbolid, dss.downloadersymbol, t.open, t.high, t.low, t.close, t.volume, t.bsf, t.sastdatetimereceived, row_number() over (partition by t.symbolid order by t.pricedatetime desc) as rn from t15 t, downloadersymbolsettings dss, symbols s where dss.classname = ? and dss.downloadfrequency = ? and dss.symbolid = t.symbolid and s.symbolid = dss.symbolid and dss.enabled = ? and s.deleted = ? and dss.downloadersymbol in (...) and t.pricedatetime > now() - interval ?) as ranked_candles_table where rn = ?;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Feb 12	06	1,020	0ms	0ms

17

975

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

Day	Hour	Count	Duration	Avg duration
Feb 12	06	975	0ms	0ms

18

931

Details

0ms

with rar_max as ( select resultuid from relevance_keylevels_results order by resultuid desc limit ? ) select case when a.old_resultuid = ? then a.old_resultuid else a.resultuid end as ruid, s.symbolid as sid, s.symbol as sym, longname, shortname, exchange as e, timegranularity as tg, a.patternid as pid, a.direction as d, a.patternprice as pp, atbaridentified as pet, case when (x9 != ?) then x9 when (x8 != ?) then x8 when (x7 != ?) then x7 when (x6 != ?) then x6 when (x5 != ?) then x5 when (x4 != ?) then x4 when (x3 != ?) then x3 when (x2 != ?) then x2 end as pst, patternprice as patp, x0, x1, x2, case when (x3 != ?) then x3 else ? end as x3, case when (x4 != ?) then x4 else ? end as x4, case when (x5 != ?) then x5 else ? end as x5, case when (x6 != ?) then x6 else ? end as x6, case when (x7 != ?) then x7 else ? end as x7, case when (x8 != ?) then x8 else ? end as x8, errormargin as erm, breakoutprice as pe, breakoutbars as be, breakout, atbaridentified as atbar, atpriceidentified as atprice, patternlengthbars as l, bandwidth as bw, qtytp as qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzos, dtt.timezone as timezone, approachingtimestamp as apt, approachingregion as apr, predictionpricefrom as ppf, predictionpriceto as ppt, predictiontimefrom as ptf, predictiontimebars as ptb, furthestprice as fp, newlevels.filtered, a.uniquepointsvalue as upv, case when rar.age is not null then rar.age when a.resultuid <= rm.resultuid then ? else ? end as age, case when rar.relevant is not null then rar.relevant when a.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from keylevels_results a inner join downloadersymbolsettings dss on a.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join hrspatterns p on a.patternid = p.patternid inner join rar_max rm on ? = ? left outer join relevance_keylevels_results rar on a.resultuid = rar.resultuid left join lateral calc_kl_signal_filter (a.resultuid) newlevels on true left join currencypips cps on cps.symbol = s.symbol where (a.old_resultuid = ? or a.resultuid = ?) and dtt.dayofweek = ?;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Feb 12	06	931	0ms	0ms

19

785

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

Day	Hour	Count	Duration	Avg duration
Feb 12	06	785	0ms	0ms

20

677

Details

0ms

select at.attname, ( select pg_catalog.array_agg(acl order by row_n) from ( select acl, row_n from pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault(?, c.relowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, c.relowner))) as init (init_acl) where acl = init_acl)) as foo) as attacl, ( select pg_catalog.array_agg(acl order by row_n) from ( select acl, row_n from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, c.relowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault(?, c.relowner))) as permp (orig_acl) where acl = orig_acl)) as foo) as rattacl, null as initattacl, null as initrattacl from pg_catalog.pg_attribute at join pg_catalog.pg_class c on (at.attrelid = c.oid) left join pg_catalog.pg_init_privs pip on (at.attrelid = pip.objoid and pip.classoid = ?::pg_catalog.regclass and at.attnum = pip.objsubid) where at.attrelid = ?::pg_catalog.oid and not at.attisdropped and (( select pg_catalog.array_agg(acl order by row_n) from ( select acl, row_n from pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault(?, c.relowner))) with ordinality as perm (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, c.relowner))) as init (init_acl) where acl = init_acl)) as foo) is not null or ( select pg_catalog.array_agg(acl order by row_n) from ( select acl, row_n from pg_catalog.unnest(coalesce(pip.initprivs, pg_catalog.acldefault(?, c.relowner))) with ordinality as initp (acl, row_n) where not exists ( select ? from pg_catalog.unnest(coalesce(at.attacl, pg_catalog.acldefault(?, c.relowner))) as permp (orig_acl) where acl = orig_acl)) as foo) is not null or null is not null or null is not null) order by at.attnum;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 12	06	677	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 12	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 12	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 12	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 12	06	2	0ms	0ms

5

0ms

12

Details

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Feb 12	06	12	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 12	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 12	06	1	0ms	0ms

8

0ms

2,173

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 12	06	2,173	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 12	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 12	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 12	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 12	06	1	0ms	0ms

13

0ms

975

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 12	06	975	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 12	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 12	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 12	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 12	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 12	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 12	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 12	06	1	0ms	0ms

Time consuming prepare


Date: 2026-02-12 06:19:50
Duration: 1m21s
Database: postgres
Date: 2026-02-12 06:06:06
Duration: 17ms
Database: postgres
Date: 2026-02-12 06:16:02
Duration: 20ms
Database: postgres
Date: 2026-02-12 06:15:42
Duration: 4ms
Database: postgres
Date: 2026-02-12 06:00:51
Duration: 3ms
Database: postgres
Date: 2026-02-12 06:30:27
Duration: 5ms
Database: postgres
Date: 2026-02-12 06:10:44
Duration: 0ms
Database: postgres
Date: 2026-02-12 06:00:51
Duration: 0ms
Database: postgres
Date: 2026-02-12 06:37:13
Duration: 13ms
Database: postgres
Date: 2026-02-12 06:10:42
Duration: 0ms
Database: postgres
Date: 2026-02-12 06:20:08
Duration: 19ms
Database: postgres
Date: 2026-02-12 06:40:03
Duration: 6ms
Database: postgres
Date: 2026-02-12 06:06:57
Duration: 7ms
Database: postgres
Date: 2026-02-12 06:12:20
Duration: 0ms
Database: postgres
Date: 2026-02-12 06:00:45
Duration: 0ms
Database: postgres
Date: 2026-02-12 06:32:13
Duration: 0ms
Database: postgres
Date: 2026-02-12 06:12:19
Duration: 16ms
Database: postgres
Date: 2026-02-12 06:15:44
Duration: 0ms
Database: postgres
Date: 2026-02-12 06:50:49
Duration: 1ms
Database: postgres
Date: 2026-02-12 06:20:03
Duration: 4ms
Database: postgres

Time consuming bind

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

47s136ms

5,285

Details

0ms

105ms

8ms

WITH rar_max as ( ;

Times Reported Time consuming bind #1

Day	Hour	Count	Duration	Avg duration
Feb 12	06	5,285	47s136ms	8ms

WITH rar_max as ( ;

Date: 2026-02-12 06:27:32 Duration: 105ms Database: postgres parameters: $1 = '558', $2 = '7', $3 = '15', $4 = '30', $5 = '60', $6 = '120', $7 = '240', $8 = '480', $9 = '1440', $10 = '0', $11 = '', $12 = '160', $13 = 'AUDSGD', $14 = 'CHFSGD', $15 = 'EURDKK', $16 = 'EURHKD', $17 = 'EURNOK', $18 = 'EURPLN', $19 = 'EURSEK', $20 = 'EURSGD', $21 = 'EURTRY', $22 = 'EURZAR', $23 = 'GBPDKK', $24 = 'GBPNOK', $25 = 'GBPSEK', $26 = 'GBPSGD', $27 = 'NOKJPY', $28 = 'NOKSEK', $29 = 'SEKJPY', $30 = 'SGDJPY', $31 = 'USDCNH', $32 = 'USDCZK', $33 = 'USDDKK', $34 = 'USDHKD', $35 = 'USDHUF', $36 = 'USDMXN', $37 = 'USDNOK', $38 = 'USDPLN', $39 = 'USDRUB', $40 = 'USDSEK', $41 = 'USDTHB', $42 = 'USDTRY', $43 = 'USDZAR', $44 = 'AUDUSD', $45 = 'EURUSD', $46 = 'GBPUSD', $47 = 'USDCAD', $48 = 'USDCHF', $49 = 'USDJPY', $50 = 'AUDCAD', $51 = 'AUDCHF', $52 = 'AUDJPY', $53 = 'AUDNZD', $54 = 'CADCHF', $55 = 'CADJPY', $56 = 'CHFJPY', $57 = 'EURAUD', $58 = 'EURCAD', $59 = 'EURCHF', $60 = 'EURGBP', $61 = 'EURJPY', $62 = 'EURNZD', $63 = 'GBPAUD', $64 = 'GBPCAD', $65 = 'GBPCHF', $66 = 'GBPJPY', $67 = 'GBPNZD', $68 = 'NZDCAD', $69 = 'NZDCHF', $70 = 'NZDJPY', $71 = 'NZDUSD', $72 = 'USDSGD', $73 = 'AUS200', $74 = 'DE30', $75 = 'ES35', $76 = 'F40', $77 = 'HK50', $78 = 'IT40', $79 = 'JP225', $80 = 'STOXX50', $81 = 'UK100', $82 = 'US2000', $83 = 'US30', $84 = 'US500', $85 = 'CHINA50', $86 = 'USTEC', $87 = 'XAGEUR', $88 = 'XAGUSD', $89 = 'XAUUSD', $90 = 'XAUEUR', $91 = 'XPDUSD', $92 = 'XPTUSD', $93 = 'AUDSGD', $94 = 'CHFSGD', $95 = 'EURDKK', $96 = 'EURHKD', $97 = 'EURNOK', $98 = 'EURPLN', $99 = 'EURSEK', $100 = 'EURSGD', $101 = 'EURTRY', $102 = 'EURZAR', $103 = 'GBPDKK', $104 = 'GBPNOK', $105 = 'GBPSEK', $106 = 'GBPSGD', $107 = 'NOKJPY', $108 = 'NOKSEK', $109 = 'SEKJPY', $110 = 'SGDJPY', $111 = 'USDCNH', $112 = 'USDCZK', $113 = 'USDDKK', $114 = 'USDHKD', $115 = 'USDHUF', $116 = 'USDMXN', $117 = 'USDNOK', $118 = 'USDPLN', $119 = 'USDRUB', $120 = 'USDSEK', $121 = 'USDTHB', $122 = 'USDTRY', $123 = 'USDZAR', $124 = 'AUDUSD', $125 = 'EURUSD', $126 = 'GBPUSD', $127 = 'USDCAD', $128 = 'USDCHF', $129 = 'USDJPY', $130 = 'AUDCAD', $131 = 'AUDCHF', $132 = 'AUDJPY', $133 = 'AUDNZD', $134 = 'CADCHF', $135 = 'CADJPY', $136 = 'CHFJPY', $137 = 'EURAUD', $138 = 'EURCAD', $139 = 'EURCHF', $140 = 'EURGBP', $141 = 'EURJPY', $142 = 'EURNZD', $143 = 'GBPAUD', $144 = 'GBPCAD', $145 = 'GBPCHF', $146 = 'GBPJPY', $147 = 'GBPNZD', $148 = 'NZDCAD', $149 = 'NZDCHF', $150 = 'NZDJPY', $151 = 'NZDUSD', $152 = 'USDSGD', $153 = 'AUS200', $154 = 'DE30', $155 = 'ES35', $156 = 'F40', $157 = 'HK50', $158 = 'IT40', $159 = 'JP225', $160 = 'STOXX50', $161 = 'UK100', $162 = 'US2000', $163 = 'US30', $164 = 'US500', $165 = 'CHINA50', $166 = 'USTEC', $167 = 'XAGEUR', $168 = 'XAGUSD', $169 = 'XAUUSD', $170 = 'XAUEUR', $171 = 'XPDUSD', $172 = 'XPTUSD', $173 = '700', $174 = '700', $175 = 't', $176 = '10', $177 = '10'
WITH rar_max as ( ;

Date: 2026-02-12 06:37:42 Duration: 58ms Database: postgres parameters: $1 = '627', $2 = '7', $3 = '15', $4 = '30', $5 = '60', $6 = '120', $7 = '240', $8 = '480', $9 = '1440', $10 = '0', $11 = '', $12 = '213', $13 = '#ADBE', $14 = '#ALVG', $15 = '#AMZN', $16 = '#APPL', $17 = '#BA', $18 = '#BABA', $19 = '#BAYGn', $20 = '#BMWG', $21 = '#BNPP', $22 = '#CAT', $23 = '#CBKG', $24 = '#DAIGn', $25 = '#DIS', $26 = '#EA', $27 = '#FB', $28 = '#FDX', $29 = '#GE', $30 = '#GM', $31 = '#GOOGL', $32 = '#GS', $33 = '#INTC', $34 = '#JPM', $35 = '#KO', $36 = '#META', $37 = '#MSFT', $38 = '#NFLX', $39 = '#TSLA', $40 = '#VOWG', $41 = '#WMT', $42 = '#XOM', $43 = 'AUDCAD', $44 = 'AUDCHF', $45 = 'AUDJPY', $46 = 'AUDNZD', $47 = 'AUDUSD', $48 = 'AUS_200', $49 = 'BTCEUR', $50 = 'BTCGBP', $51 = 'BTCUSD', $52 = 'CADCHF', $53 = 'CADJPY', $54 = 'CHFJPY', $55 = 'CL_BRENT', $56 = 'DASHUSD', $57 = 'EOSUSD', $58 = 'ESP_35', $59 = 'ETHEUR', $60 = 'ETHGBP', $61 = 'ETHUSD', $62 = 'EURAUD', $63 = 'EURCAD', $64 = 'EURCHF', $65 = 'EURGBP', $66 = 'EURJPY', $67 = 'EURMXN', $68 = 'EURNOK', $69 = 'EURNZD', $70 = 'EURPLN', $71 = 'EURSEK', $72 = 'EURTRY', $73 = 'EURUSD', $74 = 'EUR_50', $75 = 'FRA_40', $76 = 'GBPAUD', $77 = 'GBPCAD', $78 = 'GBPCHF', $79 = 'GBPJPY', $80 = 'GBPNZD', $81 = 'GBPUSD', $82 = 'GBPZAR', $83 = 'GBR_100', $84 = 'HKDJPY', $85 = 'HKG_50', $86 = 'IOTAUSD', $87 = 'LTCEUR', $88 = 'LTCUSD', $89 = 'NAS100', $90 = 'NEOUSD', $91 = 'NOKJPY', $92 = 'NZDCAD', $93 = 'NZDCHF', $94 = 'NZDJPY', $95 = 'NZDUSD', $96 = 'OMGUSD', $97 = 'SPX500', $98 = 'TRXUSD', $99 = 'US30', $100 = 'USDCAD', $101 = 'USDCHF', $102 = 'USDCNH', $103 = 'USDDKK', $104 = 'USDJPY', $105 = 'USDMXN', $106 = 'USDNOK', $107 = 'USDPLN', $108 = 'USDSEK', $109 = 'USDSGD', $110 = 'USDZAR', $111 = 'USOIL', $112 = 'XAGUSD', $113 = 'XAUEUR', $114 = 'XAUUSD', $115 = 'XMRUSD', $116 = 'XPTUSD', $117 = 'XRPUSD', $118 = 'ZARJPY', $119 = 'ZECUSD', $120 = 'AUDCAD', $121 = 'AUDCHF', $122 = 'AUDJPY', $123 = 'AUDNZD', $124 = 'AUDUSD', $125 = 'CADCHF', $126 = 'CADJPY', $127 = 'CHFJPY', $128 = 'EURAUD', $129 = 'EURCAD', $130 = 'EURCHF', $131 = 'EURGBP', $132 = 'EURJPY', $133 = 'EURMXN', $134 = 'EURNOK', $135 = 'EURNZD', $136 = 'EURPLN', $137 = 'EURSEK', $138 = 'EURTRY', $139 = 'EURUSD', $140 = 'GBPAUD', $141 = 'GBPCAD', $142 = 'GBPCHF', $143 = 'GBPJPY', $144 = 'GBPNZD', $145 = 'GBPUSD', $146 = 'GBPZAR', $147 = 'HKDJPY', $148 = 'NOKJPY', $149 = 'NZDCAD', $150 = 'NZDCHF', $151 = 'NZDJPY', $152 = 'NZDUSD', $153 = 'USDCAD', $154 = 'USDCHF', $155 = 'USDCNH', $156 = 'USDDKK', $157 = 'USDJPY', $158 = 'USDMXN', $159 = 'USDNOK', $160 = 'USDPLN', $161 = 'USDSEK', $162 = 'USDSGD', $163 = 'USDZAR', $164 = 'ZARJPY', $165 = 'BTCEUR', $166 = 'BTCGBP', $167 = 'BTCUSD', $168 = 'DASHUSD', $169 = 'EOSUSD', $170 = 'ETHEUR', $171 = 'ETHGBP', $172 = 'ETHUSD', $173 = 'IOTAUSD', $174 = 'LTCEUR', $175 = 'LTCUSD', $176 = 'NEOUSD', $177 = 'OMGUSD', $178 = 'TRXUSD', $179 = 'XMRUSD', $180 = 'XRPUSD', $181 = 'ZECUSD', $182 = 'XAGUSD', $183 = 'XAUEUR', $184 = 'XAUUSD', $185 = 'XPTUSD', $186 = 'CL_BRENT', $187 = 'USOIL', $188 = '#ALVG', $189 = '#BAYGn', $190 = '#BMWG', $191 = '#BNPP', $192 = '#CBKG', $193 = '#DAIGn', $194 = '#VOWG', $195 = 'AUS_200', $196 = 'ESP_35', $197 = 'EUR_50', $198 = 'FRA_40', $199 = 'GBR_100', $200 = 'HKG_50', $201 = 'NAS100', $202 = 'SPX500', $203 = 'US30', $204 = '#ADBE', $205 = '#AMZN', $206 = '#APPL', $207 = '#BA', $208 = '#BABA', $209 = '#CAT', $210 = '#DIS', $211 = '#EA', $212 = '#FB', $213 = '#FDX', $214 = '#GE', $215 = '#GM', $216 = '#GOOGL', $217 = '#GS', $218 = '#INTC', $219 = '#JPM', $220 = '#KO', $221 = '#MSFT', $222 = '#NFLX', $223 = '#TSLA', $224 = '#WMT', $225 = '#XOM', $226 = '700', $227 = '700', $228 = 't', $229 = '10', $230 = '10'
WITH rar_max as ( ;

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

2

12s342ms

25,876

Details

0ms

26ms

0ms

SELECT ;

Times Reported Time consuming bind #2

Day	Hour	Count	Duration	Avg duration
	06	25,876	12s342ms	0ms

SELECT ;

Date: 2026-02-12 06:00:05 Duration: 26ms Database: postgres parameters: $1 = '558', $2 = '0', $3 = '0', $4 = 'NZDCHF', $5 = 'NZDCHF'
SELECT ;

Date: 2026-02-12 06:15:53 Duration: 19ms Database: postgres parameters: $1 = '667', $2 = '667', $3 = '500991628262786200'
SELECT ;

Date: 2026-02-12 06:01:02 Duration: 16ms Database: postgres parameters: $1 = '667', $2 = '667', $3 = '500991628266153200'

3

2s800ms

1,135

Details

0ms

17ms

2ms

SELECT symbolid, ;

Times Reported Time consuming bind #3

Day	Hour	Count	Duration	Avg duration
	06	1,135	2s800ms	2ms

SELECT symbolid, ;

Date: 2026-02-12 06:00:59 Duration: 17ms Database: postgres parameters: $1 = 'BDSWISS', $2 = '15', $3 = 'USDDKK', $4 = 'USDCHF', $5 = 'SPX500', $6 = 'USDCNH', $7 = 'US30', $8 = 'USDCAD', $9 = 'TRXUSD'
SELECT symbolid, ;

Date: 2026-02-12 06:00:59 Duration: 8ms Database: postgres parameters: $1 = 'BDSWISS', $2 = '60', $3 = 'USDDKK', $4 = 'USDCHF', $5 = 'SPX500', $6 = 'USDCNH', $7 = 'US30', $8 = 'USDCAD', $9 = 'TRXUSD'
SELECT symbolid, ;

Date: 2026-02-12 06:01:01 Duration: 5ms Database: postgres parameters: $1 = 'BDSWISS', $2 = '60', $3 = 'USDJPY', $4 = 'USDMXN', $5 = 'USDPLN', $6 = 'USDNOK'

4

1s209ms

135

Details

4ms

37ms

8ms

WITH last_candle AS ( ;

Times Reported Time consuming bind #4

Day	Hour	Count	Duration	Avg duration
	06	135	1s209ms	8ms

WITH last_candle AS ( ;

Date: 2026-02-12 06:20:08 Duration: 37ms Database: postgres parameters: $1 = '538', $2 = '538'
WITH last_candle AS ( ;

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

Date: 2026-02-12 06:36:00 Duration: 24ms Database: postgres parameters: $1 = '558', $2 = '558'

5

941ms

506

Details

1ms

15ms

1ms

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

Times Reported Time consuming bind #5

Day	Hour	Count	Duration	Avg duration
	06	506	941ms	1ms

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

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

Date: 2026-02-12 06:17:28 Duration: 12ms Database: postgres parameters: $1 = 'GLOBALGTMT5'
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;

Date: 2026-02-12 06:00:51 Duration: 3ms Database: postgres parameters: $1 = 'BDSWISS'

6

680ms

22,785

Details

0ms

14ms

0ms

select 1;

Times Reported Time consuming bind #6

Day	Hour	Count	Duration	Avg duration
	06	22,785	680ms	0ms

select 1;

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

Date: 2026-02-12 06:05:34 Duration: 13ms Database: postgres
select 1;

Date: 2026-02-12 06:05:52 Duration: 13ms Database: postgres

7

604ms

20

Details

0ms

54ms

30ms

with wh_patitioned as ( ;

Times Reported Time consuming bind #7

Day	Hour	Count	Duration	Avg duration
	06	20	604ms	30ms

with wh_patitioned as ( ;

Date: 2026-02-12 06:35:01 Duration: 54ms 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-12 06:15:04 Duration: 49ms 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-12 06:17:31 Duration: 45ms Database: postgres parameters: $1 = '627', $2 = '627', $3 = '627', $4 = '627', $5 = '627', $6 = '627', $7 = '627', $8 = '627', $9 = '627'

8

409ms

72

Details

0ms

33ms

5ms

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

Times Reported Time consuming bind #8

Day	Hour	Count	Duration	Avg duration
	06	72	409ms	5ms

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

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

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

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

9

392ms

8

Details

43ms

70ms

49ms

with sym_info as ( ;

Times Reported Time consuming bind #9

Day	Hour	Count	Duration	Avg duration
	06	8	392ms	49ms

with sym_info as ( ;

Date: 2026-02-12 06:06:57 Duration: 70ms Database: postgres parameters: $1 = '692', $2 = 'Forex', $3 = 'Forex', $4 = '692', $5 = 'Forex', $6 = '692', $7 = '692', $8 = 'Forex', $9 = '692'
with sym_info as ( ;

Date: 2026-02-12 06:06:45 Duration: 54ms Database: postgres parameters: $1 = '620', $2 = 'Forex', $3 = 'Forex', $4 = '620', $5 = 'Forex', $6 = '620', $7 = '620', $8 = 'Forex', $9 = '620'
with sym_info as ( ;

Date: 2026-02-12 06:36:42 Duration: 48ms Database: postgres parameters: $1 = '620', $2 = 'Forex', $3 = 'Forex', $4 = '620', $5 = 'Forex', $6 = '620', $7 = '620', $8 = 'Forex', $9 = '620'

10

280ms

5,078

Details

0ms

12ms

0ms

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

Times Reported Time consuming bind #10

Day	Hour	Count	Duration	Avg duration
	06	5,078	280ms	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-12 06:45:51 Duration: 12ms Database: postgres parameters: $1 = '2026-02-12 04:30:00', $2 = '152.62', $3 = '152.7485', $4 = '152.537', $5 = '152.7245', $6 = '9619400000', $7 = '515840249725633300', $8 = '0', $9 = '2026-02-12 06:45:51.918', $10 = '2026-02-12 06:45:51.818', $11 = '152.62', $12 = '152.7485', $13 = '152.537', $14 = '152.7245', $15 = '9619400000', $16 = '0', $17 = '2026-02-12 06:45:51.918', $18 = '2026-02-12 06:45:51.818'
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-12 06:36:54 Duration: 8ms Database: postgres parameters: $1 = '2026-02-12 06:00:00', $2 = '18.83161', $3 = '18.833645', $4 = '18.82554', $5 = '18.829875', $6 = '1613', $7 = '605679104073984300', $8 = '0', $9 = '2026-02-12 06:36:54.801', $10 = '2026-02-12 06:36:54.709', $11 = '18.83161', $12 = '18.833645', $13 = '18.82554', $14 = '18.829875', $15 = '1613', $16 = '0', $17 = '2026-02-12 06:36:54.801', $18 = '2026-02-12 06:36:54.709'
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-12 06:30:47 Duration: 0ms Database: postgres parameters: $1 = '2026-02-12 06:15:00', $2 = '1.49763', $3 = '1.49777', $4 = '1.49717', $5 = '1.49745', $6 = '1061', $7 = '515840243197371300', $8 = '0', $9 = '2026-02-12 06:30:47.988', $10 = '2026-02-12 06:30:47.653', $11 = '1.49763', $12 = '1.49777', $13 = '1.49717', $14 = '1.49745', $15 = '1061', $16 = '0', $17 = '2026-02-12 06:30:47.988', $18 = '2026-02-12 06:30:47.653'

11

256ms

3,076

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

Day	Hour	Count	Duration	Avg duration
	06	3,076	256ms	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-12 06:30:56 Duration: 0ms Database: postgres parameters: $1 = '2026-02-12 06:00:00', $2 = '6.29417', $3 = '6.29706', $4 = '6.29254', $5 = '6.29574', $6 = '1879', $7 = '515840243219023300', $8 = '0', $9 = '2026-02-12 06:30:56.169', $10 = '2026-02-12 06:30:56.168', $11 = '6.29417', $12 = '6.29706', $13 = '6.29254', $14 = '6.29574', $15 = '1879', $16 = '0', $17 = '2026-02-12 06:30:56.169', $18 = '2026-02-12 06:30:56.168'
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-12 06:01:29 Duration: 0ms Database: postgres parameters: $1 = '2026-02-11 23:30:00', $2 = '79.0394', $3 = '79.88825', $4 = '78.98525', $5 = '79.6401', $6 = '5316', $7 = '515840249476302300', $8 = '0', $9 = '2026-02-12 06:01:29.33', $10 = '2026-02-12 06:01:29.297', $11 = '79.0394', $12 = '79.88825', $13 = '78.98525', $14 = '79.6401', $15 = '5316', $16 = '0', $17 = '2026-02-12 06:01:29.33', $18 = '2026-02-12 06:01:29.297'
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-12 06:31:06 Duration: 0ms Database: postgres parameters: $1 = '2026-02-12 06:00:00', $2 = '14878', $3 = '14879', $4 = '14870.5', $5 = '14875', $6 = '228', $7 = '500991628278678200', $8 = '0', $9 = '2026-02-12 06:31:06.282', $10 = '2026-02-12 06:31:06.282', $11 = '14878', $12 = '14879', $13 = '14870.5', $14 = '14875', $15 = '228', $16 = '0', $17 = '2026-02-12 06:31:06.282', $18 = '2026-02-12 06:31:06.282'

12

193ms

2,173

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

Day	Hour	Count	Duration	Avg duration
	06	2,173	193ms	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-12 06:15:53 Duration: 0ms Database: postgres parameters: $1 = '2026-02-12 05:00:00', $2 = '181.1945', $3 = '181.1945', $4 = '180.8525', $5 = '181.0845', $6 = '7486', $7 = '515840230417057300', $8 = '0', $9 = '2026-02-12 06:15:53.023', $10 = '2026-02-12 06:15:53.023', $11 = '181.1945', $12 = '181.1945', $13 = '180.8525', $14 = '181.0845', $15 = '7486', $16 = '0', $17 = '2026-02-12 06:15:53.023', $18 = '2026-02-12 06:15:53.023'
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-12 06:00:51 Duration: 0ms Database: postgres parameters: $1 = '2026-02-12 05:00:00', $2 = '181.1945', $3 = '181.1945', $4 = '180.8525', $5 = '181.0845', $6 = '7482', $7 = '515840230417057300', $8 = '0', $9 = '2026-02-12 06:00:51.694', $10 = '2026-02-12 06:00:51.694', $11 = '181.1945', $12 = '181.1945', $13 = '180.8525', $14 = '181.0845', $15 = '7482', $16 = '0', $17 = '2026-02-12 06:00:51.694', $18 = '2026-02-12 06:00:51.694'
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-12 06:10:30 Duration: 0ms Database: postgres parameters: $1 = '2026-02-11 21:00:00', $2 = '279.52', $3 = '279.58', $4 = '274.7', $5 = '275.98', $6 = '7466', $7 = '515840247917405300', $8 = '0', $9 = '2026-02-12 06:10:30.659', $10 = '2026-02-12 06:10:30.572', $11 = '279.52', $12 = '279.58', $13 = '274.7', $14 = '275.98', $15 = '7466', $16 = '0', $17 = '2026-02-12 06:10:30.659', $18 = '2026-02-12 06:10:30.572'

13

132ms

217

Details

0ms

3ms

0ms

SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'PARTITIONED TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS, '' as TYPE_CAT, '' as TYPE_SCHEM, '' as TYPE_NAME, '' AS SELF_REFERENCING_COL_NAME, '' AS REF_GENERATION FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = 'pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'PROBABLYNOT' AND (false OR (c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME;

Times Reported Time consuming bind #13

Day	Hour	Count	Duration	Avg duration
	06	217	132ms	0ms

SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'PARTITIONED TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS, '' as TYPE_CAT, '' as TYPE_SCHEM, '' as TYPE_NAME, '' AS SELF_REFERENCING_COL_NAME, '' AS REF_GENERATION FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = 'pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'PROBABLYNOT' AND (false OR (c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME;

Date: 2026-02-12 06:12:20 Duration: 3ms Database: postgres
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'PARTITIONED TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS, '' as TYPE_CAT, '' as TYPE_SCHEM, '' as TYPE_NAME, '' AS SELF_REFERENCING_COL_NAME, '' AS REF_GENERATION FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = 'pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'PROBABLYNOT' AND (false OR (c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME;

Date: 2026-02-12 06:12:22 Duration: 1ms Database: postgres
SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'p' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' WHEN 'S' THEN 'TEMPORARY SEQUENCE' WHEN 'v' THEN 'TEMPORARY VIEW' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'p' THEN 'PARTITIONED TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' WHEN 'c' THEN 'TYPE' WHEN 'f' THEN 'FOREIGN TABLE' WHEN 'm' THEN 'MATERIALIZED VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS, '' as TYPE_CAT, '' as TYPE_SCHEM, '' as TYPE_NAME, '' AS SELF_REFERENCING_COL_NAME, '' AS REF_GENERATION FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid = dc.oid AND dc.relname = 'pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid = dc.relnamespace AND dn.nspname = 'pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'PROBABLYNOT' AND (false OR (c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema')) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME;

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

14

93ms

8

Details

3ms

21ms

11ms

WITH pre_symbols AS ( /* find relevant symbols */ ;

Times Reported Time consuming bind #14

Day	Hour	Count	Duration	Avg duration
	06	8	93ms	11ms

WITH pre_symbols AS ( /* find relevant symbols */ ;

Date: 2026-02-12 06:12:19 Duration: 21ms Database: postgres parameters: $1 = '1018', $2 = 'ICMARKETS-AU-MT5', $3 = 'AAPL.NAS', $4 = 'ABBV.NYSE', $5 = 'AMCR.NYSE', $6 = 'AMP.NYSE', $7 = 'AMZN.NAS', $8 = 'ANZ.ASX', $9 = 'AUDJPY', $10 = 'AUDUSD', $11 = 'AUS200', $12 = 'BABA.NYSE', $13 = 'BIIB.NAS', $14 = 'BXB.ASX', $15 = 'CBA.ASX', $16 = 'CHINA50', $17 = 'CSL.ASX', $18 = 'DE30', $19 = 'ES35', $20 = 'EURCHF', $21 = 'EURGBP', $22 = 'EURUSD', $23 = 'F40', $24 = 'FMG.ASX', $25 = 'GBPJPY', $26 = 'GBPUSD', $27 = 'GOOG.NAS', $28 = 'HK50', $29 = 'IT40', $30 = 'JP225', $31 = 'KO.NYSE', $32 = 'MQG.ASX', $33 = 'MSFT.NAS', $34 = 'NAB.ASX', $35 = 'NFLX.NAS', $36 = 'PYPL.NAS', $37 = 'QBE.ASX', $38 = 'STOXX50', $39 = 'SUN.ASX', $40 = 'TCL.ASX', $41 = 'TLS.ASX', $42 = 'TSLA.NAS', $43 = 'UK100', $44 = 'UNH.NYSE', $45 = 'US2000', $46 = 'US30', $47 = 'US500', $48 = 'USDCAD', $49 = 'USDCHF', $50 = 'USDCNH', $51 = 'USDJPY', $52 = 'USTEC', $53 = 'WBC.ASX', $54 = 'WES.ASX', $55 = 'WOW.ASX', $56 = 'WPL.ASX', $57 = 'XAUEUR', $58 = 'XAUUSD', $59 = 'XBRUSD', $60 = 'XTIUSD', $61 = 'AAPL.NAS', $62 = 'ABBV.NYSE', $63 = 'AMCR.NYSE', $64 = 'AMP.NYSE', $65 = 'AMZN.NAS', $66 = 'ANZ.ASX', $67 = 'AUDJPY', $68 = 'AUDUSD', $69 = 'AUS200', $70 = 'BABA.NYSE', $71 = 'BIIB.NAS', $72 = 'BXB.ASX', $73 = 'CBA.ASX', $74 = 'CHINA50', $75 = 'CSL.ASX', $76 = 'DE30', $77 = 'ES35', $78 = 'EURCHF', $79 = 'EURGBP', $80 = 'EURUSD', $81 = 'F40', $82 = 'FMG.ASX', $83 = 'GBPJPY', $84 = 'GBPUSD', $85 = 'GOOG.NAS', $86 = 'HK50', $87 = 'IT40', $88 = 'JP225', $89 = 'KO.NYSE', $90 = 'MQG.ASX', $91 = 'MSFT.NAS', $92 = 'NAB.ASX', $93 = 'NFLX.NAS', $94 = 'PYPL.NAS', $95 = 'QBE.ASX', $96 = 'STOXX50', $97 = 'SUN.ASX', $98 = 'TCL.ASX', $99 = 'TLS.ASX', $100 = 'TSLA.NAS', $101 = 'UK100', $102 = 'UNH.NYSE', $103 = 'US2000', $104 = 'US30', $105 = 'US500', $106 = 'USDCAD', $107 = 'USDCHF', $108 = 'USDCNH', $109 = 'USDJPY', $110 = 'USTEC', $111 = 'WBC.ASX', $112 = 'WES.ASX', $113 = 'WOW.ASX', $114 = 'WPL.ASX', $115 = 'XAUEUR', $116 = 'XAUUSD', $117 = 'XBRUSD', $118 = 'XTIUSD', $119 = '5'
WITH pre_symbols AS ( /* find relevant symbols */ ;

Date: 2026-02-12 06:12:20 Duration: 21ms Database: postgres parameters: $1 = '1018', $2 = 'ICMARKETS-AU-MT5', $3 = 'AAPL.NAS', $4 = 'ABBV.NYSE', $5 = 'AMCR.NYSE', $6 = 'AMP.NYSE', $7 = 'AMZN.NAS', $8 = 'ANZ.ASX', $9 = 'AUDJPY', $10 = 'AUDUSD', $11 = 'AUS200', $12 = 'BABA.NYSE', $13 = 'BIIB.NAS', $14 = 'BXB.ASX', $15 = 'CBA.ASX', $16 = 'CHINA50', $17 = 'CSL.ASX', $18 = 'DE30', $19 = 'ES35', $20 = 'EURCHF', $21 = 'EURGBP', $22 = 'EURUSD', $23 = 'F40', $24 = 'FMG.ASX', $25 = 'GBPJPY', $26 = 'GBPUSD', $27 = 'GOOG.NAS', $28 = 'HK50', $29 = 'IT40', $30 = 'JP225', $31 = 'KO.NYSE', $32 = 'MQG.ASX', $33 = 'MSFT.NAS', $34 = 'NAB.ASX', $35 = 'NFLX.NAS', $36 = 'PYPL.NAS', $37 = 'QBE.ASX', $38 = 'STOXX50', $39 = 'SUN.ASX', $40 = 'TCL.ASX', $41 = 'TLS.ASX', $42 = 'TSLA.NAS', $43 = 'UK100', $44 = 'UNH.NYSE', $45 = 'US2000', $46 = 'US30', $47 = 'US500', $48 = 'USDCAD', $49 = 'USDCHF', $50 = 'USDCNH', $51 = 'USDJPY', $52 = 'USTEC', $53 = 'WBC.ASX', $54 = 'WES.ASX', $55 = 'WOW.ASX', $56 = 'WPL.ASX', $57 = 'XAUEUR', $58 = 'XAUUSD', $59 = 'XBRUSD', $60 = 'XTIUSD', $61 = 'AAPL.NAS', $62 = 'ABBV.NYSE', $63 = 'AMCR.NYSE', $64 = 'AMP.NYSE', $65 = 'AMZN.NAS', $66 = 'ANZ.ASX', $67 = 'AUDJPY', $68 = 'AUDUSD', $69 = 'AUS200', $70 = 'BABA.NYSE', $71 = 'BIIB.NAS', $72 = 'BXB.ASX', $73 = 'CBA.ASX', $74 = 'CHINA50', $75 = 'CSL.ASX', $76 = 'DE30', $77 = 'ES35', $78 = 'EURCHF', $79 = 'EURGBP', $80 = 'EURUSD', $81 = 'F40', $82 = 'FMG.ASX', $83 = 'GBPJPY', $84 = 'GBPUSD', $85 = 'GOOG.NAS', $86 = 'HK50', $87 = 'IT40', $88 = 'JP225', $89 = 'KO.NYSE', $90 = 'MQG.ASX', $91 = 'MSFT.NAS', $92 = 'NAB.ASX', $93 = 'NFLX.NAS', $94 = 'PYPL.NAS', $95 = 'QBE.ASX', $96 = 'STOXX50', $97 = 'SUN.ASX', $98 = 'TCL.ASX', $99 = 'TLS.ASX', $100 = 'TSLA.NAS', $101 = 'UK100', $102 = 'UNH.NYSE', $103 = 'US2000', $104 = 'US30', $105 = 'US500', $106 = 'USDCAD', $107 = 'USDCHF', $108 = 'USDCNH', $109 = 'USDJPY', $110 = 'USTEC', $111 = 'WBC.ASX', $112 = 'WES.ASX', $113 = 'WOW.ASX', $114 = 'WPL.ASX', $115 = 'XAUEUR', $116 = 'XAUUSD', $117 = 'XBRUSD', $118 = 'XTIUSD'
WITH pre_symbols AS ( /* find relevant symbols */ ;

Date: 2026-02-12 06:12:19 Duration: 21ms Database: postgres parameters: $1 = '1018', $2 = 'ICMARKETS-AU-MT5', $3 = 'AAPL.NAS', $4 = 'ABBV.NYSE', $5 = 'AMCR.NYSE', $6 = 'AMP.NYSE', $7 = 'AMZN.NAS', $8 = 'ANZ.ASX', $9 = 'AUDJPY', $10 = 'AUDUSD', $11 = 'AUS200', $12 = 'BABA.NYSE', $13 = 'BIIB.NAS', $14 = 'BXB.ASX', $15 = 'CBA.ASX', $16 = 'CHINA50', $17 = 'CSL.ASX', $18 = 'DE30', $19 = 'ES35', $20 = 'EURCHF', $21 = 'EURGBP', $22 = 'EURUSD', $23 = 'F40', $24 = 'FMG.ASX', $25 = 'GBPJPY', $26 = 'GBPUSD', $27 = 'GOOG.NAS', $28 = 'HK50', $29 = 'IT40', $30 = 'JP225', $31 = 'KO.NYSE', $32 = 'MQG.ASX', $33 = 'MSFT.NAS', $34 = 'NAB.ASX', $35 = 'NFLX.NAS', $36 = 'PYPL.NAS', $37 = 'QBE.ASX', $38 = 'STOXX50', $39 = 'SUN.ASX', $40 = 'TCL.ASX', $41 = 'TLS.ASX', $42 = 'TSLA.NAS', $43 = 'UK100', $44 = 'UNH.NYSE', $45 = 'US2000', $46 = 'US30', $47 = 'US500', $48 = 'USDCAD', $49 = 'USDCHF', $50 = 'USDCNH', $51 = 'USDJPY', $52 = 'USTEC', $53 = 'WBC.ASX', $54 = 'WES.ASX', $55 = 'WOW.ASX', $56 = 'WPL.ASX', $57 = 'XAUEUR', $58 = 'XAUUSD', $59 = 'XBRUSD', $60 = 'XTIUSD', $61 = 'AAPL.NAS', $62 = 'ABBV.NYSE', $63 = 'AMCR.NYSE', $64 = 'AMP.NYSE', $65 = 'AMZN.NAS', $66 = 'ANZ.ASX', $67 = 'AUDJPY', $68 = 'AUDUSD', $69 = 'AUS200', $70 = 'BABA.NYSE', $71 = 'BIIB.NAS', $72 = 'BXB.ASX', $73 = 'CBA.ASX', $74 = 'CHINA50', $75 = 'CSL.ASX', $76 = 'DE30', $77 = 'ES35', $78 = 'EURCHF', $79 = 'EURGBP', $80 = 'EURUSD', $81 = 'F40', $82 = 'FMG.ASX', $83 = 'GBPJPY', $84 = 'GBPUSD', $85 = 'GOOG.NAS', $86 = 'HK50', $87 = 'IT40', $88 = 'JP225', $89 = 'KO.NYSE', $90 = 'MQG.ASX', $91 = 'MSFT.NAS', $92 = 'NAB.ASX', $93 = 'NFLX.NAS', $94 = 'PYPL.NAS', $95 = 'QBE.ASX', $96 = 'STOXX50', $97 = 'SUN.ASX', $98 = 'TCL.ASX', $99 = 'TLS.ASX', $100 = 'TSLA.NAS', $101 = 'UK100', $102 = 'UNH.NYSE', $103 = 'US2000', $104 = 'US30', $105 = 'US500', $106 = 'USDCAD', $107 = 'USDCHF', $108 = 'USDCNH', $109 = 'USDJPY', $110 = 'USTEC', $111 = 'WBC.ASX', $112 = 'WES.ASX', $113 = 'WOW.ASX', $114 = 'WPL.ASX', $115 = 'XAUEUR', $116 = 'XAUUSD', $117 = 'XBRUSD', $118 = 'XTIUSD', $119 = '5'

15

60ms

11

Details

3ms

6ms

5ms

SELECT DISTINCT ON (basegroupname, symbol) ;

Times Reported Time consuming bind #15

Day	Hour	Count	Duration	Avg duration
	06	11	60ms	5ms

SELECT DISTINCT ON (basegroupname, symbol) ;

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

Date: 2026-02-12 06:07:31 Duration: 6ms Database: postgres parameters: $1 = '689', $2 = '689'
SELECT DISTINCT ON (basegroupname, symbol) ;

Date: 2026-02-12 06:06:10 Duration: 6ms Database: postgres parameters: $1 = '538', $2 = '538'

16

59ms

6

Details

5ms

12ms

9ms

with rankedmt4 as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select * from rankedmt4 where r = 1 ), ok_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select *, row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 * 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1;

Times Reported Time consuming bind #16

Day	Hour	Count	Duration	Avg duration
	06	6	59ms	9ms

with rankedmt4 as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select * from rankedmt4 where r = 1 ), ok_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select *, row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 * 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1;

Date: 2026-02-12 06:40:02 Duration: 12ms Database: postgres
with rankedmt4 as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select * from rankedmt4 where r = 1 ), ok_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select *, row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 * 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1;

Date: 2026-02-12 06:30:02 Duration: 11ms Database: postgres
with rankedmt4 as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select * from rankedmt4 where r = 1 ), ok_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select *, row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 * 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1;

Date: 2026-02-12 06:20:03 Duration: 11ms Database: postgres

17

52ms

192

Details

0ms

4ms

0ms

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

Times Reported Time consuming bind #17

Day	Hour	Count	Duration	Avg duration
	06	192	52ms	0ms

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

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

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

Date: 2026-02-12 06:33:28 Duration: 4ms Database: postgres parameters: $1 = '607664331224822301'

18

51ms

1

Details

51ms

with maxwhid as ( ;

Times Reported Time consuming bind #18

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

with maxwhid as ( ;

Date: 2026-02-12 06:12:17 Duration: 51ms Database: postgres parameters: $1 = '335', $2 = '621', $3 = '637', $4 = '642', $5 = '666', $6 = '660', $7 = '643', $8 = '630', $9 = '680', $10 = '641', $11 = '431', $12 = '622', $13 = '489', $14 = '529', $15 = '576', $16 = '665', $17 = '667', $18 = '558', $19 = '620', $20 = '125', $21 = '488', $22 = '567', $23 = '689', $24 = '700', $25 = '758', $26 = '763', $27 = '765', $28 = '817', $29 = '914', $30 = '972'

19

51ms

45

Details

0ms

2ms

1ms

SELECT timegranularity FROM brokersymbollist bsl INNER JOIN symbols s ON bsl.symbolid = s.symbolid INNER JOIN downloadersymbolsettings dss on s.symbolid = dss.symbolid LEFT OUTER JOIN brokerinstrumentmapping bdfi ON bdfi.brokerid = $1 AND dss.datafeedinstrumentid = bdfi.datafeedinstrumentid WHERE s.nonliquid = 0 and s.deleted = 0 and dss.enabled = 1 AND s.symbol ILIKE $2 AND bsl.brokerid = $3 AND timegranularity >= 15 ORDER BY timegranularity LIMIT 1;

Times Reported Time consuming bind #19

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

SELECT timegranularity FROM brokersymbollist bsl INNER JOIN symbols s ON bsl.symbolid = s.symbolid INNER JOIN downloadersymbolsettings dss on s.symbolid = dss.symbolid LEFT OUTER JOIN brokerinstrumentmapping bdfi ON bdfi.brokerid = $1 AND dss.datafeedinstrumentid = bdfi.datafeedinstrumentid WHERE s.nonliquid = 0 and s.deleted = 0 and dss.enabled = 1 AND s.symbol ILIKE $2 AND bsl.brokerid = $3 AND timegranularity >= 15 ORDER BY timegranularity LIMIT 1;

Date: 2026-02-12 06:34:46 Duration: 2ms Database: postgres parameters: $1 = '558', $2 = 'EURUSD', $3 = '558'
SELECT timegranularity FROM brokersymbollist bsl INNER JOIN symbols s ON bsl.symbolid = s.symbolid INNER JOIN downloadersymbolsettings dss on s.symbolid = dss.symbolid LEFT OUTER JOIN brokerinstrumentmapping bdfi ON bdfi.brokerid = $1 AND dss.datafeedinstrumentid = bdfi.datafeedinstrumentid WHERE s.nonliquid = 0 and s.deleted = 0 and dss.enabled = 1 AND s.symbol ILIKE $2 AND bsl.brokerid = $3 AND timegranularity >= 15 ORDER BY timegranularity LIMIT 1;

Date: 2026-02-12 06:06:31 Duration: 2ms Database: postgres parameters: $1 = '489', $2 = 'XAUUSD', $3 = '489'
SELECT timegranularity FROM brokersymbollist bsl INNER JOIN symbols s ON bsl.symbolid = s.symbolid INNER JOIN downloadersymbolsettings dss on s.symbolid = dss.symbolid LEFT OUTER JOIN brokerinstrumentmapping bdfi ON bdfi.brokerid = $1 AND dss.datafeedinstrumentid = bdfi.datafeedinstrumentid WHERE s.nonliquid = 0 and s.deleted = 0 and dss.enabled = 1 AND s.symbol ILIKE $2 AND bsl.brokerid = $3 AND timegranularity >= 15 ORDER BY timegranularity LIMIT 1;

Date: 2026-02-12 06:34:03 Duration: 1ms Database: postgres parameters: $1 = '621', $2 = 'GBPAUD', $3 = '621'

20

43ms

361

Details

0ms

1ms

0ms

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

Times Reported Time consuming bind #20

Day	Hour	Count	Duration	Avg duration
	06	361	43ms	0ms

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

Date: 2026-02-12 06:01:26 Duration: 1ms Database: postgres parameters: $1 = '2026-02-11 20:00:00', $2 = '13.016', $3 = '13.3485', $4 = '12.996', $5 = '13.285', $6 = '38049', $7 = '515840249403393300', $8 = '0', $9 = '2026-02-12 06:01:26.828', $10 = '2026-02-12 06:01:26.717', $11 = '13.016', $12 = '13.3485', $13 = '12.996', $14 = '13.285', $15 = '38049', $16 = '0', $17 = '2026-02-12 06:01:26.828', $18 = '2026-02-12 06:01:26.717'
INSERT INTO T240 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-12 06:17:30 Duration: 0ms Database: postgres parameters: $1 = '2026-02-11 20:00:00', $2 = '50153.9', $3 = '50231.4', $4 = '50019.3', $5 = '50118.3', $6 = '54032', $7 = '515840249388410300', $8 = '0', $9 = '2026-02-12 06:17:30.647', $10 = '2026-02-12 06:17:30.627', $11 = '50153.9', $12 = '50231.4', $13 = '50019.3', $14 = '50118.3', $15 = '54032', $16 = '0', $17 = '2026-02-12 06:17:30.647', $18 = '2026-02-12 06:17:30.627'
INSERT INTO T240 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-12 06:46:52 Duration: 0ms Database: postgres parameters: $1 = '2026-02-11 20:00:00', $2 = '64.94', $3 = '65.055', $4 = '64.405', $5 = '64.91', $6 = '5186', $7 = '515840249468012300', $8 = '0', $9 = '2026-02-12 06:46:52.396', $10 = '2026-02-12 06:46:52.378', $11 = '64.94', $12 = '65.055', $13 = '64.405', $14 = '64.91', $15 = '5186', $16 = '0', $17 = '2026-02-12 06:46:52.396', $18 = '2026-02-12 06:46:52.378'

Log levels

Key values

409,938 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	417	0.10%
DETAIL	90,457	22.07%
ERROR	4	0.00%
LOG	318,504	77.70%
STATEMENT	556	0.14%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
9 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

7 Max number of times the same event was reported
9 Total events found

Rank

Times reported

Error

1

7

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Feb 12	06	7

LOG: process 29278 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.059 ms at character 28
LOG: process 29076 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.060 ms at character 28
LOG: process 29278 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 51928.853 ms at character 28

2

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Feb 12	06	2

LOG: process 25105 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 1000.059 ms
LOG: process 29696 still waiting for AccessExclusiveLock on relation 5894441 of database 5881926 after 1000.070 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