pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Fri Jan 23 02:59:51 2026
Log file: /home/postgres/pg_data/data/pg_log/postgresql-2026-01-23_040000.log
Parsed 2,238,408 log entries in 50s
Log start from 2026-01-23 04:00:00 to 2026-01-23 04:59:48

Global Stats

242 Number of unique normalized queries
224,892 Number of queries
2h23m20s Total query duration
2026-01-23 04:00:00 First query
2026-01-23 04:59:48 Last query
3,652 queries/s at 2026-01-23 04:45:04 Query peak

2h23m20s Total query duration
16s226ms Prepare/parse total duration
1m15s Bind total duration
2h21m49s Execute total duration

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

39 Total number of automatic vacuums
56 Total number of automatic analyzes

903 Number temporary file
353.84 MiB Max size of temporary file
6.43 MiB Average size of temporary file

6,060 Total number of sessions
14 sessions at 2026-01-23 04:51:11 Session peak
15d20h39m21s Total duration of sessions
3m46s Average duration of sessions
37 Average queries per session
1s419ms Average queries duration per session
3m44s Average idle time per session

6,062 Total number of connections
43 connections/s at 2026-01-23 04:42:39 Connection peak
3 Total number of databases

SQL Traffic

Key values

3,652 queries/s Query Peak
2026-01-23 04:45:04 Date

SELECT Traffic

Key values

1,796 queries/s Query Peak
2026-01-23 04:45:04 Date

INSERT/UPDATE/DELETE Traffic

Key values

182 queries/s Query Peak
2026-01-23 04:30:51 Date

Queries duration

Key values

2h23m20s 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)
Jan 23	04	224,892	0ms	43s771ms	37ms	4m15s	5m1s	6m4s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 23	04	61,215	26	0ms	0ms	0ms	0ms

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 23	04	30,139	2,225	16	96	0ms	0ms	0ms	0ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Jan 23	04	37,893	84,373	2.23	37.15%

Day	Hour	Count	Average / Second
Jan 23	04	6,062	1.68/s

Day	Hour	Count	Average Duration	Average idle time
Jan 23	04	6,060	3m46s	3m44s

↑ Back to the top of the General Activity table

Established Connections

Key values

43 connections Connection Peak
2026-01-23 04:42:39 Date

Connections per database

Key values

acaweb_fx Main Database
6,062 connections Total

Chart
Table

Database	User	Count
acaweb_fx		5,968
	postgres	5,578
	psql	390
socialmedia		94
	postgres	94

Connections per user

Key values

postgres Main User
6,062 connections Total

Chart
Table

User	Count
postgres	5,672
psql	390

Connections per host

Key values

192.168.1.15 Main host with 2018 connections
6,062 Total connections

Chart
Table

Host	Count
127.0.0.1	113
182.165.1.42	112
192.168.0.114	6
192.168.0.216	101
192.168.0.74	1,296
192.168.1.145	133
192.168.1.15	2,018
192.168.1.20	139
192.168.1.231	20
192.168.1.239	4
192.168.1.90	64
192.168.2.126	62
192.168.2.182	12
192.168.2.82	48
192.168.3.199	36
192.168.4.103	4
192.168.4.142	1,167
192.168.4.143	4
192.168.4.150	10
192.168.4.238	16
192.168.4.33	89
192.168.4.34	1
192.168.4.98	330
[local]	277

Simultaneous sessions

Key values

14 sessions Session Peak
2026-01-23 04:51:11 Date

Histogram of session times

Key values

4,997 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	4,997	82.46%
500ms-1s	182	3.00%
1s-30s	647	10.68%
30s-1m	101	1.67%
1m-10m	58	0.96%
10m-30m	58	0.96%
30m-1h	4	0.07%
1h-8h	11	0.18%
> 8h	2	0.03%

Sessions per database

Key values

acaweb_fx Main Database
6,060 sessions Total

Chart
Table

Database	User	Count	Total Duration	Average Duration
acaweb_fx	5,966	15d20h13m2s	3m49s
socialmedia	94	26m19s	16s801ms

Sessions per user

Key values

postgres Main User
6,060 sessions Total

Chart
Table

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

Sessions per host

Key values

192.168.1.15 Main Host
6,060 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	113	11s770ms	104ms
182.165.1.42	112	13d14h48m13s	2h55m4s
192.168.0.114	6	30m	5m
192.168.0.216	101	52s181ms	516ms
192.168.0.74	1,295	3h7m6s	8s669ms
192.168.1.145	133	4h11m12s	1m53s
192.168.1.15	2,017	2h12m39s	3s946ms
192.168.1.20	139	13h33m18s	5m51s
192.168.1.231	20	9h52m40s	29m38s
192.168.1.239	4	227ms	56ms
192.168.1.90	64	39s579ms	618ms
192.168.2.126	62	6s670ms	107ms
192.168.2.182	12	984ms	82ms
192.168.2.82	48	13s748ms	286ms
192.168.3.199	36	1s425ms	39ms
192.168.4.103	4	19s849ms	4s962ms
192.168.4.142	1,167	11m16s	580ms
192.168.4.143	4	33ms	8ms
192.168.4.150	10	20h4m46s	2h28s
192.168.4.238	16	21s625ms	1s351ms
192.168.4.33	89	1m18s	886ms
192.168.4.34	1	162ms	162ms
192.168.4.98	330	18s400ms	55ms
[local]	277	3m40s	794ms

Sessions per application

Key values

unknown Main Host
6,060 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
unknown	6,060	15d20h39m21s	3m46s

Checkpoints Buffers

Key values

11,310 buffers Checkpoint Peak
2026-01-23 04:06:52 Date
210.070 seconds Highest write time
0.006 seconds Sync time

Checkpoints Wal files

Key values

7 files Wal files usage Peak
2026-01-23 04:06:52 Date

Checkpoints distance

Key values

228.39 Mo Distance Peak
2026-01-23 04:06:52 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jan 23	04	42,126	1,739.111s	0.055s	1,739.468s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Jan 23	04	0	0	23	1,884	0.005s	0s

Day	Hour	Count	Avg time (sec)
Jan 23	04	0	0s

Day	Hour	Mean distance	Mean estimate
Jan 23	04	32,501.42 kB	80,814.00 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

353.84 MiB Temp Files size Peak
2026-01-23 04:05:09 Date

Number of temporary files

Key values

62 per second Temp Files Peak
2026-01-23 04:02:11 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jan 23	04	903	5.67 GiB	6.43 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	29	1.65 GiB	3.31 MiB	197.24 MiB	58.17 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-01-23 04:00:06 Duration: 0ms
2	22	169.00 MiB	7.68 MiB	7.70 MiB	7.68 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-01-23 04:00:41 Duration: 0ms
3	16	737.12 MiB	46.07 MiB	46.07 MiB	46.07 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-01-23 04:01:13 Duration: 0ms
4	16	1.22 GiB	78.18 MiB	78.18 MiB	78.18 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-01-23 04:01:16 Duration: 0ms
5	14	44.22 MiB	3.16 MiB	3.16 MiB	3.16 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-01-23 04:02:43 Duration: 0ms
6	8	1.04 GiB	132.55 MiB	132.60 MiB	132.57 MiB	select updateresultsmaterializedview (); select updateresultsmaterializedview (); Date: 2026-01-23 04:02:19 Duration: 0ms
7	4	372.19 MiB	93.00 MiB	93.13 MiB	93.05 MiB	select updateageforrelevantresults (); select updateageforrelevantresults (); Date: 2026-01-23 04:02:05 Duration: 0ms

Queries generating the largest temporary files

Rank	Size	Query
1	197.24 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-01-23 04:40:04 ]
2	171.22 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-01-23 04:20:06 ]
3	159.36 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-01-23 04:10:05 ]
4	132.60 MiB	select updateresultsmaterializedview (); [ Date: 2026-01-23 04:02:19 ]
5	132.59 MiB	select updateresultsmaterializedview (); [ Date: 2026-01-23 04:17:26 ]
6	132.57 MiB	select updateresultsmaterializedview (); [ Date: 2026-01-23 04:32:28 ]
7	132.57 MiB	select updateresultsmaterializedview (); [ Date: 2026-01-23 04:05:33 ]
8	132.57 MiB	select updateresultsmaterializedview (); [ Date: 2026-01-23 04:47:27 ]
9	132.56 MiB	select updateresultsmaterializedview (); [ Date: 2026-01-23 04:50:32 ]
10	132.55 MiB	select updateresultsmaterializedview (); [ Date: 2026-01-23 04:35:32 ]
11	132.55 MiB	select updateresultsmaterializedview (); [ Date: 2026-01-23 04:20:32 ]
12	110.94 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-01-23 04:50:05 ]
13	107.02 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-01-23 04:30:04 ]
14	104.24 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-01-23 04:30:05 ]
15	103.40 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-01-23 04:00:06 ]
16	98.19 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-01-23 04:00:05 ]
17	93.13 MiB	select updateageforrelevantresults (); [ Date: 2026-01-23 04:02:05 ]
18	93.06 MiB	select updateageforrelevantresults (); [ Date: 2026-01-23 04:32:07 ]
19	93.01 MiB	select updateageforrelevantresults (); [ Date: 2026-01-23 04:17:07 ]
20	93.00 MiB	select updateageforrelevantresults (); [ Date: 2026-01-23 04:47: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 (16) Main table analyzed (database acaweb_fx)
56 analyzes Total

Chart
Table

Table	Number of analyzes
acaweb_fx.public.solr_relevance_old	16
acaweb_fx.pg_catalog.pg_attribute	5
acaweb_fx.public.datafeeds_latestrun	4
acaweb_fx.public.relevance_keylevels_results	4
acaweb_fx.pg_catalog.pg_class	4
acaweb_fx.public.relevance_fibonacci_results	4
acaweb_fx.public.relevance_autochartist_results	4
acaweb_fx.pg_catalog.pg_type	3
acaweb_fx.public.latest_t15_candle_view	2
acaweb_fx.pg_catalog.pg_index	1
acaweb_fx.public.autochartist_symbolupdates	1
acaweb_fx.public.solr_imports	1
socialmedia.public.processes	1
acaweb_fx.pg_catalog.pg_depend	1
acaweb_fx.public.latest_candle_datetime_per_receng	1
acaweb_fx.public.sa_hist_bigmove	1
acaweb_fx.public.relevance_consecutivecandles_results	1
acaweb_fx.public.symbollatestupdatetime	1
acaweb_fx.public.bigmovement_results_underlying	1
Total	56

Vacuums per table

Key values

public.solr_relevance_old (16) Main table vacuumed on database acaweb_fx
39 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	16	16	11,575	0	68	0	0	8,279	1,018	4,821,295
acaweb_fx.public.datafeeds_latestrun	4	0	481	0	12	0	0	60	12	56,490
acaweb_fx.pg_toast.pg_toast_2619	2	2	302	0	67	0	0	208	62	227,325
acaweb_fx.pg_catalog.pg_statistic	2	2	1,971	0	423	0	1,162	972	385	1,457,889
acaweb_fx.public.relevance_keylevels_results	2	2	7,344	0	323	4	216	1,780	855	2,602,622
acaweb_fx.pg_catalog.pg_class	2	2	899	0	132	0	0	308	125	618,647
acaweb_fx.public.relevance_autochartist_results	2	2	6,870	0	182	2	488	1,402	168	456,995
acaweb_fx.public.relevance_fibonacci_results	2	2	2,541	0	79	2	112	451	65	203,757
acaweb_fx.public.sa_hist_bigmove	1	1	4,344	0	847	0	220	1,480	843	2,564,079
acaweb_fx.pg_catalog.pg_type	1	1	138	0	21	0	0	53	17	115,797
acaweb_fx.public.autochartist_symbolupdates	1	1	25,723	0	750	6	38,137	7,662	699	760,340
acaweb_fx.pg_catalog.pg_attribute	1	1	747	0	183	0	67	365	141	842,890
acaweb_fx.public.relevance_consecutivecandles_results	1	1	77	0	5	0	0	24	2	18,519
acaweb_fx.public.symbollatestupdatetime	1	0	1,700	0	170	0	519	1,252	169	595,426
acaweb_fx.public.latest_t15_candle_view	1	1	66	0	1	0	0	6	1	9,079
Total	39	34	64,778	48,984	3,263	14	40,921	24,302	4,562	15,351,150

Tuples removed per table

Key values

public.solr_relevance_old (54750) Main table with removed tuples on database acaweb_fx
97422 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
acaweb_fx.public.solr_relevance_old	16	16	54,750	81,172	0	0	2,744
acaweb_fx.public.symbollatestupdatetime	1	0	18,663	97,473	23	0	1,714
acaweb_fx.public.sa_hist_bigmove	1	1	12,220	50,427	0	240	1,078
acaweb_fx.public.autochartist_symbolupdates	1	1	5,697	49,090	68	0	40,691
acaweb_fx.pg_catalog.pg_attribute	1	1	1,370	11,085	137	0	261
acaweb_fx.public.relevance_autochartist_results	2	2	1,355	15,525	0	0	760
acaweb_fx.pg_catalog.pg_statistic	2	2	1,117	7,393	0	0	2,388
acaweb_fx.public.relevance_keylevels_results	2	2	994	23,441	0	0	558
acaweb_fx.public.relevance_fibonacci_results	2	2	318	2,837	0	0	204
acaweb_fx.pg_catalog.pg_class	2	2	291	3,298	0	0	300
acaweb_fx.public.datafeeds_latestrun	4	0	241	56	0	0	64
acaweb_fx.pg_toast.pg_toast_2619	2	2	145	341	0	4	102
acaweb_fx.pg_catalog.pg_type	1	1	134	1,449	3	0	39
acaweb_fx.public.relevance_consecutivecandles_results	1	1	64	377	0	0	8
acaweb_fx.public.latest_t15_candle_view	1	1	63	14	0	0	1
Total	39	34	97,422	343,978	231	244	50,912

Pages removed per table

Key values

public.sa_hist_bigmove (240) Main table with removed pages on database acaweb_fx
244 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
acaweb_fx.public.sa_hist_bigmove	1	1	12220	240
acaweb_fx.pg_toast.pg_toast_2619	2	2	145	4
acaweb_fx.pg_catalog.pg_type	1	1	134	0
acaweb_fx.public.datafeeds_latestrun	4	0	241	0
acaweb_fx.public.autochartist_symbolupdates	1	1	5697	0
acaweb_fx.pg_catalog.pg_attribute	1	1	1370	0
acaweb_fx.pg_catalog.pg_statistic	2	2	1117	0
acaweb_fx.public.relevance_consecutivecandles_results	1	1	64	0
acaweb_fx.public.symbollatestupdatetime	1	0	18663	0
acaweb_fx.public.latest_t15_candle_view	1	1	63	0
acaweb_fx.public.relevance_keylevels_results	2	2	994	0
acaweb_fx.pg_catalog.pg_class	2	2	291	0
acaweb_fx.public.solr_relevance_old	16	16	54750	0
acaweb_fx.public.relevance_autochartist_results	2	2	1355	0
acaweb_fx.public.relevance_fibonacci_results	2	2	318	0
Total	39	34	97,422	244

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jan 23	04	39	56

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

NO DATASET

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

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
NO DATASET

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

61,215 Total read queries
40,796 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	61,215	27.22%
INSERT	30,139	13.40%
UPDATE	2,225	0.99%
DELETE	16	0.01%
COPY FROM	96	0.04%
COPY TO	26	0.01%
CTE	7,584	3.37%
DDL	16	0.01%
TCL	694	0.31%
CURSOR	0	0.00%
OTHERS	122,881	54.64%

Queries by database

Key values

unknown Main database
223,876 Requests
2h21m49s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
acaweb_fx	Total	922	0ms
	copy from	80	0ms
	copy to	26	0ms
	cte	104	0ms
	ddl	16	0ms
	delete	16	0ms
	others	206	0ms
	select	104	0ms
	tcl	331	0ms
	update	39	0ms
socialmedia	Total	94	0ms
	select	89	0ms
	tcl	5	0ms
unknown	Total	223,876	2h21m49s
	copy from	16	0ms
	cte	7,480	0ms
	insert	30,139	0ms
	others	10,247	0ms
	select	61,022	0ms
	tcl	358	0ms
	update	2,186	0ms

Queries by user

Key values

unknown Main user
223,876 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	1,016	0ms
	copy from	80	0ms
	copy to	26	0ms
	cte	104	0ms
	ddl	16	0ms
	delete	16	0ms
	others	206	0ms
	select	193	0ms
	tcl	336	0ms
	update	39	0ms
unknown	Total	223,876	2h21m49s
	copy from	16	0ms
	cte	7,480	0ms
	insert	30,139	0ms
	others	10,247	0ms
	select	61,022	0ms
	tcl	358	0ms
	update	2,186	0ms

Duration by user

Key values

2h21m49s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	1,016	0ms
	copy from	80	0ms
	copy to	26	0ms
	cte	104	0ms
	ddl	16	0ms
	delete	16	0ms
	others	206	0ms
	select	193	0ms
	tcl	336	0ms
	update	39	0ms
unknown	Total	223,876	2h21m49s
	copy from	16	0ms
	cte	7,480	0ms
	insert	30,139	0ms
	others	10,247	0ms
	select	61,022	0ms
	tcl	358	0ms
	update	2,186	0ms

Queries by host

Key values

unknown Main host
224,892 Requests
2h21m49s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	224,892	2h21m49s
	copy from	96	0ms
	copy to	26	0ms
	cte	7,584	0ms
	ddl	16	0ms
	delete	16	0ms
	insert	30,139	0ms
	others	10,453	0ms
	select	61,215	0ms
	tcl	694	0ms
	update	2,225	0ms

Queries by application

Key values

unknown Main application
224,502 Requests
2h21m49s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
psql	Total	390	0ms
	copy from	80	0ms
	copy to	26	0ms
	cte	104	0ms
	ddl	16	0ms
	delete	16	0ms
	others	5	0ms
	select	104	0ms
	update	39	0ms
unknown	Total	224,502	2h21m49s
	copy from	16	0ms
	cte	7,480	0ms
	insert	30,139	0ms
	others	10,448	0ms
	select	61,111	0ms
	tcl	694	0ms
	update	2,186	0ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-01-23 04:41:29 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

72,601 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	72,601	64.58%
1-5ms	34,394	30.59%
5-10ms	2,050	1.82%
10-25ms	807	0.72%
25-50ms	286	0.25%
50-100ms	300	0.27%
100-500ms	484	0.43%
500-1000ms	232	0.21%
1000-10000ms	990	0.88%
> 10000ms	284	0.25%

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

28

Details

0ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 23	04	28	0ms	0ms

2

0ms

328

Details

0ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 23	04	328	0ms	0ms

3

0ms

55

Details

0ms

with rar_max as ( select resultuid from relevance_bigmovement_results order by resultuid desc limit ? ) select bmr.symbolid, patternstarttime, patternendtime, timegranularity, ? as direction, case when bmr.old_resultuid = ? then bmr.old_resultuid else bmr.resultuid end as uid, s.exchange, s.symbol, s.longname, s.shortname, dtt.timezone, bmr.patternmovement, bmr.statisticalmovement, bmr.fromprice, bmr.toprice, bmr.percentile, bmr.patternlengthbars, case when rbr.age is not null then rbr.age when bmr.resultuid <= rm.resultuid then ? else ? end as age, case when rbr.relevant is not null then rbr.relevant when bmr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from bigmovement_results bmr inner join downloadersymbolsettings dss on bmr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join symbols s on bmr.symbolid = s.symbolid inner join rar_max rm on ? = ? left outer join relevance_bigmovement_results rbr on rbr.resultuid = bmr.resultuid left join currencypips cps on cps.symbol = s.symbol where (bmr.old_resultuid = ? or bmr.resultuid = ?) and dtt.dayofweek = ?;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 23	04	55	0ms	0ms

4

0ms

2,207

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

Day	Hour	Count	Duration	Avg duration
Jan 23	04	2,207	0ms	0ms

5

0ms

48

Details

0ms

select count(*) from datafeeds_latestrun where feedname ilike ? and ((latestrxtime > current_timestamp - interval ? and latestdbwritetime > current_timestamp - interval ?) or (latestdbwritetime > current_timestamp - interval ? and lateststartuptime > current_timestamp - interval ?));

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 23	04	48	0ms	0ms

6

0ms

121

Details

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 23	04	121	0ms	0ms

7

0ms

4

Details

0ms

select updaterelevantforrelevantresults ();

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 23	04	4	0ms	0ms

8

0ms

1

Details

0ms

select count(*) from autochartist_stocklist where base_engine = recognitionengine and base_engine ilike ?;

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 23	04	1	0ms	0ms

9

0ms

1,646

Details

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 23	04	1,646	0ms	0ms

10

0ms

4

Details

0ms

select t.pricedatetime as pricedatetime, t.open as open, t.high as high, t.low as low, t.close "..." close, t.volume as volume, t.bsf as bsf from t1440 t where symbolid = ? and (bsf = ? or bsf is null) order by pricedatetime desc limit ?;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 23	04	4	0ms	0ms

11

0ms

3

Details

0ms

insert into t15 (symbolid, pricedatetime, open, high, low, close, volume, bsf, sastdatetimereceived) values (?, ?::timestamp without time zone, ?.?, ?, ?.?, ?, ?, ?, ?::timestamp without time zone) on conflict (symbolid, pricedatetime) do nothing;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 23	04	3	0ms	0ms

12

0ms

240

Details

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 23	04	240	0ms	0ms

13

0ms

18

Details

0ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 23	04	18	0ms	0ms

14

0ms

52

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

Day	Hour	Count	Duration	Avg duration
Jan 23	04	52	0ms	0ms

15

0ms

1

Details

0ms

select count(*) from autochartist_stocklist where base_engine = recognitionengine and enabled = ?;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 23	04	1	0ms	0ms

16

0ms

1

Details

0ms

insert into t30 (symbolid, pricedatetime, open, high, low, close, volume, bsf, sastdatetimereceived) values (?, ?::timestamp without time zone, ?, ?.?, ?, ?, ?, ?, ?::timestamp without time zone) on conflict (symbolid, pricedatetime) do nothing;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 23	04	1	0ms	0ms

17

0ms

16

Details

0ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 23	04	16	0ms	0ms

18

0ms

2

Details

0ms

with pre_symbols as ( select s.symbolid, s.symbol, s.timegranularity, dss.downloadersymbol, dtt.timezone, s.exchange, s.longname 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 and brokerid = ? where dss.classname in (...) and (dss.downloadersymbol in (...) or s.symbol in (...)) and dss.enabled = ? and s.nonliquid = ? and s.deleted = ? ), report_symbols as ( select ps1.*, ps2.symbolid as price_symbol_id from pre_symbols ps1 inner join pre_symbols ps2 on ps1.symbol = ps2.symbol and ps1.downloadersymbol = ps2.downloadersymbol and ps2.timegranularity = ? ), rbr_max as ( select resultuid from relevance_bigmovement_results order by resultuid desc limit ? ) select bmr.resultuid as ruid, ? as direction, rs.symbol as sym, rs.downloadersymbol, rs.symbolid as sid, rs.timegranularity as tg, rs.timezone, rs.exchange as e, rs.longname, bmr.patternendtime as pet, lpi.latestpricedatetime as lpdt, bmr.patternlengthbars as l, bmr.breakout >= ? as complete, rbr.age as age from bigmovement_results bmr inner join report_symbols rs on rs.symbolid = bmr.symbolid inner join autochartist_symbolupdates lpi on lpi.symbolid = rs.price_symbol_id inner join rbr_max rm on ? = ? left outer join relevance_bigmovement_results rbr on rbr.resultuid = bmr.resultuid where patternendtime >= (now() - ? * interval ?) -- results can't be more than ? days old and (bmr.resultuid > rm.resultuid or rbr.relevant = ?) ;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 23	04	2	0ms	0ms

19

0ms

347

Details

0ms

commit;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 23	04	347	0ms	0ms

20

0ms

463

Details

0ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 23	04	463	0ms	0ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

26,895

Details

0ms

select ?;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 23	04	26,895	0ms	0ms

2

16,253

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
Jan 23	04	16,253	0ms	0ms

3

7,730

Details

0ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 23	04	7,730	0ms	0ms

4

5,861

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
Jan 23	04	5,861	0ms	0ms

5

4,958

Details

0ms

set extra_float_digits = ?;

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 23	04	4,958	0ms	0ms

6

4,820

Details

0ms

set application_name = ?;

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 23	04	4,820	0ms	0ms

7

4,673

Details

0ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 23	04	4,673	0ms	0ms

8

4,461

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

Day	Hour	Count	Duration	Avg duration
Jan 23	04	4,461	0ms	0ms

9

3,326

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

Day	Hour	Count	Duration	Avg duration
Jan 23	04	3,326	0ms	0ms

10

3,050

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

Day	Hour	Count	Duration	Avg duration
Jan 23	04	3,050	0ms	0ms

11

2,592

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

Day	Hour	Count	Duration	Avg duration
Jan 23	04	2,592	0ms	0ms

12

2,207

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

Day	Hour	Count	Duration	Avg duration
Jan 23	04	2,207	0ms	0ms

13

1,646

Details

0ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 23	04	1,646	0ms	0ms

14

1,273

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
Jan 23	04	1,273	0ms	0ms

15

1,190

Details

0ms

insert into t240 (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 #15

Day	Hour	Count	Duration	Avg duration
Jan 23	04	1,190	0ms	0ms

16

1,084

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

Day	Hour	Count	Duration	Avg duration
Jan 23	04	1,084	0ms	0ms

17

988

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

Day	Hour	Count	Duration	Avg duration
Jan 23	04	988	0ms	0ms

18

642

Details

0ms

select case when a.old_resultuid = ? then a.old_resultuid else a.resultuid end as resultuid, s.symbol, pattern as patternname, timegranularity as interval, patternlengthbars as length, patternendtime, direction, breakout, predictiontimeto, predictionpricefrom, predictionpriceto, patternstartprice, resy1, supporty1, dtt.timezone, cps.pip, newlevels.profit 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 left join currencypips cps on cps.symbol = s.symbol left join lateral calc_cp_signal (a.resultuid) newlevels on true where (a.old_resultuid = ? or a.resultuid = ?) and dtt.dayofweek = ?;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 23	04	642	0ms	0ms

19

634

Details

0ms

insert into authenticationlog (username, password, brokerid, authclass, attemptdatetime, success, fingerprint, accounttype) values (?, ?, ?, ?, current_timestamp, ?, ?, ?);

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 23	04	634	0ms	0ms

20

524

Details

0ms

select downloadersymbol, spike_threshold from price_datafeed_spike_threshold where classname = ?;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 23	04	524	0ms	0ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

28

Details

0ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 23	04	28	0ms	0ms

2

0ms

328

Details

0ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 23	04	328	0ms	0ms

3

0ms

55

Details

0ms

with rar_max as ( select resultuid from relevance_bigmovement_results order by resultuid desc limit ? ) select bmr.symbolid, patternstarttime, patternendtime, timegranularity, ? as direction, case when bmr.old_resultuid = ? then bmr.old_resultuid else bmr.resultuid end as uid, s.exchange, s.symbol, s.longname, s.shortname, dtt.timezone, bmr.patternmovement, bmr.statisticalmovement, bmr.fromprice, bmr.toprice, bmr.percentile, bmr.patternlengthbars, case when rbr.age is not null then rbr.age when bmr.resultuid <= rm.resultuid then ? else ? end as age, case when rbr.relevant is not null then rbr.relevant when bmr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from bigmovement_results bmr inner join downloadersymbolsettings dss on bmr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join symbols s on bmr.symbolid = s.symbolid inner join rar_max rm on ? = ? left outer join relevance_bigmovement_results rbr on rbr.resultuid = bmr.resultuid left join currencypips cps on cps.symbol = s.symbol where (bmr.old_resultuid = ? or bmr.resultuid = ?) and dtt.dayofweek = ?;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 23	04	55	0ms	0ms

4

0ms

2,207

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

Day	Hour	Count	Duration	Avg duration
Jan 23	04	2,207	0ms	0ms

5

0ms

48

Details

0ms

select count(*) from datafeeds_latestrun where feedname ilike ? and ((latestrxtime > current_timestamp - interval ? and latestdbwritetime > current_timestamp - interval ?) or (latestdbwritetime > current_timestamp - interval ? and lateststartuptime > current_timestamp - interval ?));

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 23	04	48	0ms	0ms

6

0ms

121

Details

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 23	04	121	0ms	0ms

7

0ms

4

Details

0ms

select updaterelevantforrelevantresults ();

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 23	04	4	0ms	0ms

8

0ms

1

Details

0ms

select count(*) from autochartist_stocklist where base_engine = recognitionengine and base_engine ilike ?;

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 23	04	1	0ms	0ms

9

0ms

1,646

Details

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 23	04	1,646	0ms	0ms

10

0ms

4

Details

0ms

select t.pricedatetime as pricedatetime, t.open as open, t.high as high, t.low as low, t.close "..." close, t.volume as volume, t.bsf as bsf from t1440 t where symbolid = ? and (bsf = ? or bsf is null) order by pricedatetime desc limit ?;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 23	04	4	0ms	0ms

11

0ms

3

Details

0ms

insert into t15 (symbolid, pricedatetime, open, high, low, close, volume, bsf, sastdatetimereceived) values (?, ?::timestamp without time zone, ?.?, ?, ?.?, ?, ?, ?, ?::timestamp without time zone) on conflict (symbolid, pricedatetime) do nothing;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 23	04	3	0ms	0ms

12

0ms

240

Details

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 23	04	240	0ms	0ms

13

0ms

18

Details

0ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 23	04	18	0ms	0ms

14

0ms

52

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

Day	Hour	Count	Duration	Avg duration
Jan 23	04	52	0ms	0ms

15

0ms

1

Details

0ms

select count(*) from autochartist_stocklist where base_engine = recognitionengine and enabled = ?;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 23	04	1	0ms	0ms

16

0ms

1

Details

0ms

insert into t30 (symbolid, pricedatetime, open, high, low, close, volume, bsf, sastdatetimereceived) values (?, ?::timestamp without time zone, ?, ?.?, ?, ?, ?, ?, ?::timestamp without time zone) on conflict (symbolid, pricedatetime) do nothing;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 23	04	1	0ms	0ms

17

0ms

16

Details

0ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 23	04	16	0ms	0ms

18

0ms

2

Details

0ms

with pre_symbols as ( select s.symbolid, s.symbol, s.timegranularity, dss.downloadersymbol, dtt.timezone, s.exchange, s.longname 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 and brokerid = ? where dss.classname in (...) and (dss.downloadersymbol in (...) or s.symbol in (...)) and dss.enabled = ? and s.nonliquid = ? and s.deleted = ? ), report_symbols as ( select ps1.*, ps2.symbolid as price_symbol_id from pre_symbols ps1 inner join pre_symbols ps2 on ps1.symbol = ps2.symbol and ps1.downloadersymbol = ps2.downloadersymbol and ps2.timegranularity = ? ), rbr_max as ( select resultuid from relevance_bigmovement_results order by resultuid desc limit ? ) select bmr.resultuid as ruid, ? as direction, rs.symbol as sym, rs.downloadersymbol, rs.symbolid as sid, rs.timegranularity as tg, rs.timezone, rs.exchange as e, rs.longname, bmr.patternendtime as pet, lpi.latestpricedatetime as lpdt, bmr.patternlengthbars as l, bmr.breakout >= ? as complete, rbr.age as age from bigmovement_results bmr inner join report_symbols rs on rs.symbolid = bmr.symbolid inner join autochartist_symbolupdates lpi on lpi.symbolid = rs.price_symbol_id inner join rbr_max rm on ? = ? left outer join relevance_bigmovement_results rbr on rbr.resultuid = bmr.resultuid where patternendtime >= (now() - ? * interval ?) -- results can't be more than ? days old and (bmr.resultuid > rm.resultuid or rbr.relevant = ?) ;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 23	04	2	0ms	0ms

19

0ms

347

Details

0ms

commit;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 23	04	347	0ms	0ms

20

0ms

463

Details

0ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 23	04	463	0ms	0ms

Time consuming prepare


Date: 2026-01-23 04:46:14
Duration: 22ms
Database: postgres
Date: 2026-01-23 04:25:39
Duration: 11ms
Database: postgres
Date: 2026-01-23 04:01:16
Duration: 4ms
Database: postgres
Date: 2026-01-23 04:24:39
Duration: 5ms
Database: postgres
Date: 2026-01-23 04:46:07
Duration: 1ms
Database: postgres
Date: 2026-01-23 04:48:03
Duration: 5ms
Database: postgres
Date: 2026-01-23 04:41:20
Duration: 0ms
Database: postgres
Date: 2026-01-23 04:11:23
Duration: 0ms
Database: postgres
Date: 2026-01-23 04:46:16
Duration: 1ms
Database: postgres
Date: 2026-01-23 04:47:24
Duration: 0ms
Database: postgres
Date: 2026-01-23 04:06:59
Duration: 7ms
Database: postgres
Date: 2026-01-23 04:07:56
Duration: 2ms
Database: postgres
Date: 2026-01-23 04:21:00
Duration: 2ms
Database: postgres
Date: 2026-01-23 04:13:16
Duration: 0ms
Database: postgres
Date: 2026-01-23 04:32:00
Duration: 3ms
Database: postgres
Date: 2026-01-23 04:20:05
Duration: 4ms
Database: postgres
Date: 2026-01-23 04:40:03
Duration: 0ms
Database: postgres
Date: 2026-01-23 04:57:18
Duration: 1ms
Database: postgres
Date: 2026-01-23 04:20:03
Duration: 3ms
Database: postgres
Date: 2026-01-23 04:22:05
Duration: 2ms
Database: postgres

Time consuming bind

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

49s199ms

6,491

Details

0ms

58ms

7ms

WITH rar_max as ( ;

Times Reported Time consuming bind #1

Day	Hour	Count	Duration	Avg duration
Jan 23	04	6,491	49s199ms	7ms

WITH rar_max as ( ;

Date: 2026-01-23 04:25:39 Duration: 58ms Database: postgres parameters: $1 = '607549691654320303', $2 = '607549691654320303', $3 = '607549691654320303'
WITH rar_max as ( ;

Date: 2026-01-23 04:25:39 Duration: 47ms Database: postgres parameters: $1 = '607548842582311301', $2 = '607548842582311301', $3 = '607548842582311301'
WITH rar_max as ( ;

Date: 2026-01-23 04:37:30 Duration: 46ms Database: postgres parameters: $1 = '607549691211035303', $2 = '607549691211035303', $3 = '607549691211035303'

2

18s744ms

24,576

Details

0ms

37ms

0ms

SELECT ;

Times Reported Time consuming bind #2

Day	Hour	Count	Duration	Avg duration
	04	24,576	18s744ms	0ms

SELECT ;

Date: 2026-01-23 04:47:07 Duration: 37ms Database: postgres parameters: $1 = '958', $2 = '958', $3 = '515840249414067300'
SELECT ;

Date: 2026-01-23 04:47:07 Duration: 36ms Database: postgres parameters: $1 = '958', $2 = '958', $3 = '515840249417025300'
SELECT ;

Date: 2026-01-23 04:26:09 Duration: 35ms Database: postgres parameters: $1 = '958', $2 = '958', $3 = '515840249443731300'

3

2s761ms

1,140

Details

0ms

7ms

2ms

SELECT symbolid, ;

Times Reported Time consuming bind #3

Day	Hour	Count	Duration	Avg duration
	04	1,140	2s761ms	2ms

SELECT symbolid, ;

Date: 2026-01-23 04:00:02 Duration: 7ms Database: postgres parameters: $1 = 'BDSWISS', $2 = '240', $3 = '#FDX', $4 = '#DIS', $5 = '#EA', $6 = '#FB'
SELECT symbolid, ;

Date: 2026-01-23 04:15:59 Duration: 5ms Database: postgres parameters: $1 = 'AXIORY', $2 = '15', $3 = 'EURCZK', $4 = 'EURDKK'
SELECT symbolid, ;

Date: 2026-01-23 04:32:19 Duration: 4ms Database: postgres parameters: $1 = 'GLOBALGTMT5', $2 = '15', $3 = 'NZDUSD', $4 = 'LTCUSD', $5 = 'MATUSD'

4

889ms

524

Details

1ms

3ms

1ms

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

Times Reported Time consuming bind #4

Day	Hour	Count	Duration	Avg duration
	04	524	889ms	1ms

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

Date: 2026-01-23 04:16:03 Duration: 3ms Database: postgres parameters: $1 = 'FPMARKETS'
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;

Date: 2026-01-23 04:32:19 Duration: 2ms Database: postgres parameters: $1 = 'BDSWISS'
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;

Date: 2026-01-23 04:01:13 Duration: 2ms Database: postgres parameters: $1 = 'GLOBALGTMT5'

5

759ms

105

Details

4ms

18ms

7ms

WITH last_candle AS ( ;

Times Reported Time consuming bind #5

Day	Hour	Count	Duration	Avg duration
	04	105	759ms	7ms

WITH last_candle AS ( ;

Date: 2026-01-23 04:20:01 Duration: 18ms Database: postgres parameters: $1 = '958', $2 = '958'
WITH last_candle AS ( ;

Date: 2026-01-23 04:20:01 Duration: 17ms Database: postgres parameters: $1 = '958', $2 = '958'
WITH last_candle AS ( ;

Date: 2026-01-23 04:48:02 Duration: 16ms Database: postgres parameters: $1 = '958', $2 = '958'

6

676ms

26,781

Details

0ms

6ms

0ms

select 1;

Times Reported Time consuming bind #6

Day	Hour	Count	Duration	Avg duration
	04	26,781	676ms	0ms

select 1;

Date: 2026-01-23 04:43:40 Duration: 6ms Database: postgres
select 1;

Date: 2026-01-23 04:51:01 Duration: 4ms Database: postgres
select 1;

Date: 2026-01-23 04:25:09 Duration: 3ms Database: postgres

7

531ms

16

Details

28ms

45ms

33ms

with sym_info as ( ;

Times Reported Time consuming bind #7

Day	Hour	Count	Duration	Avg duration
	04	16	531ms	33ms

with sym_info as ( ;

Date: 2026-01-23 04:51:56 Duration: 45ms 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-01-23 04:21:52 Duration: 44ms 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-01-23 04:06:59 Duration: 44ms Database: postgres parameters: $1 = '692', $2 = 'Forex', $3 = 'Forex', $4 = '692', $5 = 'Forex', $6 = '692', $7 = '692', $8 = 'Forex', $9 = '692'

8

417ms

22

Details

0ms

47ms

18ms

with wh_patitioned as ( ;

Times Reported Time consuming bind #8

Day	Hour	Count	Duration	Avg duration
	04	22	417ms	18ms

with wh_patitioned as ( ;

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

Date: 2026-01-23 04:40:03 Duration: 46ms 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-01-23 04:20:01 Duration: 40ms Database: postgres parameters: $1 = '558', $2 = '558', $3 = '558', $4 = '558', $5 = '558', $6 = '558', $7 = '558', $8 = '558', $9 = '558'

9

288ms

65

Details

0ms

18ms

4ms

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

Times Reported Time consuming bind #9

Day	Hour	Count	Duration	Avg duration
	04	65	288ms	4ms

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

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

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

Date: 2026-01-23 04:36:49 Duration: 18ms Database: postgres parameters: $1 = '667', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'

10

266ms

5,861

Details

0ms

2ms

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
	04	5,861	266ms	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-01-23 04:15:52 Duration: 2ms Database: postgres parameters: $1 = '2026-01-22 22:45:00', $2 = '177.69', $3 = '177.92', $4 = '177.295', $5 = '177.295', $6 = '426', $7 = '515840249416656300', $8 = '0', $9 = '2026-01-23 04:15:52.376', $10 = '2026-01-23 04:15:52.054', $11 = '177.69', $12 = '177.92', $13 = '177.295', $14 = '177.295', $15 = '426', $16 = '0', $17 = '2026-01-23 04:15:52.376', $18 = '2026-01-23 04:15:52.054'
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-01-23 04:15:52 Duration: 0ms Database: postgres parameters: $1 = '2026-01-23 02:00:00', $2 = '1.17493', $3 = '1.175005', $4 = '1.174625', $5 = '1.174855', $6 = '6421800000', $7 = '515840249732670300', $8 = '0', $9 = '2026-01-23 04:15:52.341', $10 = '2026-01-23 04:15:52.052', $11 = '1.17493', $12 = '1.175005', $13 = '1.174625', $14 = '1.174855', $15 = '6421800000', $16 = '0', $17 = '2026-01-23 04:15:52.341', $18 = '2026-01-23 04:15:52.052'
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-01-23 04:01:15 Duration: 0ms Database: postgres parameters: $1 = '2026-01-23 03:45:00', $2 = '1.971455', $3 = '1.97225', $4 = '1.971375', $5 = '1.97198', $6 = '976', $7 = '515840230477727300', $8 = '0', $9 = '2026-01-23 04:01:15.281', $10 = '2026-01-23 04:01:15.203', $11 = '1.971455', $12 = '1.97225', $13 = '1.971375', $14 = '1.97198', $15 = '976', $16 = '0', $17 = '2026-01-23 04:01:15.281', $18 = '2026-01-23 04:01:15.203'

11

243ms

3,326

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
	04	3,326	243ms	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-01-23 04:30:58 Duration: 0ms Database: postgres parameters: $1 = '2026-01-23 04:00:00', $2 = '115.046', $3 = '115.053', $4 = '114.971', $5 = '114.977', $6 = '2491', $7 = '515840233461736300', $8 = '0', $9 = '2026-01-23 04:30:58.785', $10 = '2026-01-23 04:30:58.784', $11 = '115.046', $12 = '115.053', $13 = '114.971', $14 = '114.977', $15 = '2491', $16 = '0', $17 = '2026-01-23 04:30:58.785', $18 = '2026-01-23 04:30:58.784'
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-01-23 04:41:20 Duration: 0ms Database: postgres parameters: $1 = '2026-01-23 04:00:00', $2 = '25534.53', $3 = '25542.65', $4 = '25524.15', $5 = '25528.03', $6 = '4704', $7 = '515840248039147300', $8 = '0', $9 = '2026-01-23 04:41:20.535', $10 = '2026-01-23 04:41:20.422', $11 = '25534.53', $12 = '25542.65', $13 = '25524.15', $14 = '25528.03', $15 = '4704', $16 = '0', $17 = '2026-01-23 04:41:20.535', $18 = '2026-01-23 04:41:20.422'
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-01-23 04:41:10 Duration: 0ms Database: postgres parameters: $1 = '2026-01-23 03:30:00', $2 = '8886.4', $3 = '8886.95', $4 = '8875', $5 = '8882.5', $6 = '2147', $7 = '515840248015340300', $8 = '0', $9 = '2026-01-23 04:41:10.404', $10 = '2026-01-23 04:41:10.336', $11 = '8886.4', $12 = '8886.95', $13 = '8875', $14 = '8882.5', $15 = '2147', $16 = '0', $17 = '2026-01-23 04:41:10.404', $18 = '2026-01-23 04:41:10.336'

12

168ms

2,207

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
	04	2,207	168ms	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-01-23 04:11:23 Duration: 0ms Database: postgres parameters: $1 = '2026-01-23 03:00:00', $2 = '49391.05', $3 = '49421.15', $4 = '49383.55', $5 = '49405.05', $6 = '10232', $7 = '515840248000890300', $8 = '0', $9 = '2026-01-23 04:11:23.023', $10 = '2026-01-23 04:11:22.923', $11 = '49391.05', $12 = '49421.15', $13 = '49383.55', $14 = '49405.05', $15 = '10232', $16 = '0', $17 = '2026-01-23 04:11:23.023', $18 = '2026-01-23 04:11:22.923'
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-01-23 04:01:05 Duration: 0ms Database: postgres parameters: $1 = '2026-01-23 03:00:00', $2 = '0.54008', $3 = '0.540915', $4 = '0.540045', $5 = '0.540515', $6 = '4174', $7 = '515840230422578300', $8 = '0', $9 = '2026-01-23 04:01:05.541', $10 = '2026-01-23 04:01:05.452', $11 = '0.54008', $12 = '0.540915', $13 = '0.540045', $14 = '0.540515', $15 = '4174', $16 = '0', $17 = '2026-01-23 04:01:05.541', $18 = '2026-01-23 04:01:05.452'
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-01-23 04:01:13 Duration: 0ms Database: postgres parameters: $1 = '2026-01-23 04:00:00', $2 = '213.9485', $3 = '214.1595', $4 = '213.9435', $5 = '214.1315', $6 = '9145', $7 = '515840249381832300', $8 = '0', $9 = '2026-01-23 04:01:13.841', $10 = '2026-01-23 04:01:13.841', $11 = '213.9485', $12 = '214.1595', $13 = '213.9435', $14 = '214.1315', $15 = '9145', $16 = '0', $17 = '2026-01-23 04:01:13.841', $18 = '2026-01-23 04:01:13.841'

13

104ms

1,190

Details

0ms

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

Times Reported Time consuming bind #13

Day	Hour	Count	Duration	Avg duration
	04	1,190	104ms	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-01-23 04:01:17 Duration: 0ms Database: postgres parameters: $1 = '2026-01-23 00:00:00', $2 = '213.717', $3 = '214.1625', $4 = '213.717', $5 = '214.1305', $6 = '13563', $7 = '515840230496544300', $8 = '0', $9 = '2026-01-23 04:01:17.342', $10 = '2026-01-23 04:01:17.341', $11 = '213.717', $12 = '214.1625', $13 = '213.717', $14 = '214.1305', $15 = '13563', $16 = '0', $17 = '2026-01-23 04:01:17.342', $18 = '2026-01-23 04:01:17.341'
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-01-23 04:01:13 Duration: 0ms Database: postgres parameters: $1 = '2026-01-23 00:00:00', $2 = '186.137', $3 = '186.426', $4 = '186.137', $5 = '186.389', $6 = '14461', $7 = '515840230417229300', $8 = '0', $9 = '2026-01-23 04:01:13.387', $10 = '2026-01-23 04:01:13.386', $11 = '186.137', $12 = '186.426', $13 = '186.137', $14 = '186.389', $15 = '14461', $16 = '0', $17 = '2026-01-23 04:01:13.387', $18 = '2026-01-23 04:01:13.386'
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-01-23 04:31:01 Duration: 0ms Database: postgres parameters: $1 = '2026-01-23 00:00:00', $2 = '8838.15', $3 = '8883.05', $4 = '8833.05', $5 = '8873.05', $6 = '1748', $7 = '500991628266415200', $8 = '0', $9 = '2026-01-23 04:31:01.978', $10 = '2026-01-23 04:31:01.977', $11 = '8838.15', $12 = '8883.05', $13 = '8833.05', $14 = '8873.05', $15 = '1748', $16 = '0', $17 = '2026-01-23 04:31:01.978', $18 = '2026-01-23 04:31:01.977'

14

97ms

219

Details

0ms

1ms

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

Day	Hour	Count	Duration	Avg duration
	04	219	97ms	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-01-23 04:13:16 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-01-23 04:13:17 Duration: 0ms 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-01-23 04:13:16 Duration: 0ms Database: postgres

15

64ms

71

Details

0ms

1ms

0ms

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

Day	Hour	Count	Duration	Avg duration
	04	71	64ms	0ms

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-01-23 04:31:02 Duration: 1ms Database: postgres parameters: $1 = '558', $2 = 'BTCUSD', $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-01-23 04:10:03 Duration: 1ms Database: postgres parameters: $1 = '689', $2 = 'XAUUSD', $3 = '689'
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-01-23 04:55:03 Duration: 1ms Database: postgres parameters: $1 = '689', $2 = 'XAUUSD', $3 = '689'

16

48ms

9

Details

3ms

9ms

5ms

SELECT DISTINCT ON (basegroupname, symbol) ;

Times Reported Time consuming bind #16

Day	Hour	Count	Duration	Avg duration
	04	9	48ms	5ms

SELECT DISTINCT ON (basegroupname, symbol) ;

Date: 2026-01-23 04:11:00 Duration: 9ms Database: postgres parameters: $1 = '627', $2 = '627'
SELECT DISTINCT ON (basegroupname, symbol) ;

Date: 2026-01-23 04:53:01 Duration: 6ms Database: postgres parameters: $1 = '667', $2 = '667'
SELECT DISTINCT ON (basegroupname, symbol) ;

Date: 2026-01-23 04:36:13 Duration: 5ms Database: postgres parameters: $1 = '538', $2 = '538'

17

43ms

8

Details

2ms

10ms

5ms

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

Times Reported Time consuming bind #17

Day	Hour	Count	Duration	Avg duration
	04	8	43ms	5ms

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

Date: 2026-01-23 04:13:15 Duration: 10ms 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-01-23 04:13:15 Duration: 7ms 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-01-23 04:13:15 Duration: 6ms 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'

18

36ms

11

Details

1ms

6ms

3ms

WITH rcr_max as ( ;

Times Reported Time consuming bind #18

Day	Hour	Count	Duration	Avg duration
	04	11	36ms	3ms

WITH rcr_max as ( ;

Date: 2026-01-23 04:37:36 Duration: 6ms Database: postgres parameters: $1 = '607550731487868305', $2 = '607550731487868305', $3 = '607550731487868305'
WITH rcr_max as ( ;

Date: 2026-01-23 04:22:05 Duration: 6ms Database: postgres parameters: $1 = '607550731487868305', $2 = '607550731487868305', $3 = '607550731487868305'
WITH rcr_max as ( ;

Date: 2026-01-23 04:21:03 Duration: 5ms Database: postgres parameters: $1 = '607550731487868305', $2 = '607550731487868305', $3 = '607550731487868305'

19

31ms

1

Details

31ms

with maxwhid as ( ;

Times Reported Time consuming bind #19

Day	Hour	Count	Duration	Avg duration
	04	1	31ms	31ms

with maxwhid as ( ;

Date: 2026-01-23 04:13:17 Duration: 31ms 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'

20

25ms

4,958

Details

0ms

1ms

0ms

SET extra_float_digits = 3;

Times Reported Time consuming bind #20

Day	Hour	Count	Duration	Avg duration
	04	4,958	25ms	0ms

SET extra_float_digits = 3;

Date: 2026-01-23 04:06:25 Duration: 1ms Database: postgres
SET extra_float_digits = 3;

Date: 2026-01-23 04:53:35 Duration: 0ms Database: postgres
SET extra_float_digits = 3;

Date: 2026-01-23 04:39:39 Duration: 0ms Database: postgres

Log levels

Key values

462,882 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	703	0.15%
DETAIL	94,845	20.49%
ERROR	35	0.01%
HINT	34	0.01%
LOG	366,387	79.15%
STATEMENT	878	0.19%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
35 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

34 Max number of times the same event was reported
35 Total events found

Rank

Times reported

Error

1

34

Details

ERROR: function fixcandlegaps(...) is not unique

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jan 23	04	34

ERROR: function fixcandlegaps(unknown, boolean) is not unique at character 8

2

1

Details

ERROR: duplicate key value violates unique constraint "..."

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jan 23	04	1

ERROR: duplicate key value violates unique constraint "ar_idx_sa_hist_conscandles_symbolid_datetime_direction"

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

Queries generating the most temporary files (N)

Queries generating the largest temporary files

Vacuums

Vacuums / Analyzes Distribution

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Autovacuum Activity

Locks

Locks by types

Key values

Type of locks

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values

Queries by user

Key values

Duration by user