pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Tue Jan 6 05:00:09 2026
Log file: /home/postgres/pg_data/data/pg_log/postgresql-2026-01-06_060000.log, ..., /home/postgres/pg_data/data/pg_log/postgresql-2026-01-06_065546.log
Parsed 3,087,760 log entries in 1m8s
Log start from 2026-01-06 06:00:00 to 2026-01-06 06:59:59

Global Stats

1,046 Number of unique normalized queries
321,888 Number of queries
3h3m56s Total query duration
2026-01-06 06:00:00 First query
2026-01-06 06:59:59 Last query
6,081 queries/s at 2026-01-06 06:05:02 Query peak

3h3m56s Total query duration
16s494ms Prepare/parse total duration
1m18s Bind total duration
3h2m21s Execute total duration

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

37 Total number of automatic vacuums
51 Total number of automatic analyzes

585 Number temporary file
162.48 MiB Max size of temporary file
7.96 MiB Average size of temporary file

6,826 Total number of sessions
12 sessions at 2026-01-06 06:53:31 Session peak
2d10h38m25s Total duration of sessions
30s926ms Average duration of sessions
47 Average queries per session
1s616ms Average queries duration per session
29s309ms Average idle time per session

6,826 Total number of connections
51 connections/s at 2026-01-06 06:24:05 Connection peak
6 Total number of databases

SQL Traffic

Key values

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

SELECT Traffic

Key values

3,021 queries/s Query Peak
2026-01-06 06:05:02 Date

INSERT/UPDATE/DELETE Traffic

Key values

202 queries/s Query Peak
2026-01-06 06:00:53 Date

Queries duration

Key values

3h3m56s 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 06	06	321,888	0ms	14m11s	33ms	5m14s	6m40s	19m7s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 06	06	105,735	601	0ms	0ms	0ms	0ms

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 06	06	29,432	1,996	13	78	0ms	0ms	0ms	0ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Jan 06	06	40,907	123,705	3.02	27.61%

Day	Hour	Count	Average / Second
Jan 06	06	6,826	1.90/s

Day	Hour	Count	Average Duration	Average idle time
Jan 06	06	6,826	30s926ms	29s323ms

↑ Back to the top of the General Activity table

Established Connections

Key values

51 connections Connection Peak
2026-01-06 06:24:05 Date

Connections per database

Key values

acaweb_fx Main Database
6,826 connections Total

Chart
Table

Database	User	Count
acaweb_fx		6,729
	pg_dump	1
	postgres	6,381
	psql	347
acaweb_fx_integer		1
	pg_dump	1
postgres		3
	pg_dump	1
	psql	2
socialmedia		92
	pg_dump	1
	postgres	91
translations		1
	pg_dump	1

Connections per user

Key values

postgres Main User
6,826 connections Total

Chart
Table

User	Count
pg_dump	5
postgres	6,472
psql	349

Connections per host

Key values

192.168.0.74 Main host with 4060 connections
6,826 Total connections

Chart
Table

Host	Count
127.0.0.1	116
192.168.0.114	1
192.168.0.216	101
192.168.0.74	4,060
192.168.1.145	27
192.168.1.15	370
192.168.1.20	63
192.168.1.231	20
192.168.1.239	1
192.168.1.90	52
192.168.2.126	62
192.168.2.182	12
192.168.2.82	48
192.168.3.199	36
192.168.4.142	1,167
192.168.4.150	10
192.168.4.228	4
192.168.4.238	16
192.168.4.33	91
192.168.4.45	1
192.168.4.98	330
[local]	238

Simultaneous sessions

Key values

12 sessions Session Peak
2026-01-06 06:53:31 Date

Histogram of session times

Key values

5,874 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	5,874	86.05%
500ms-1s	182	2.67%
1s-30s	563	8.25%
30s-1m	71	1.04%
1m-10m	55	0.81%
10m-30m	62	0.91%
30m-1h	7	0.10%
1h-8h	12	0.18%
> 8h	0	0.00%

Sessions per database

Key values

acaweb_fx Main Database
6,826 sessions Total

Chart
Table

Database	User	Count	Total Duration
acaweb_fx	6,729	2d10h14m57s	31s163ms
acaweb_fx_integer	1	19m44s	19m44s
postgres	3	280ms	93ms
socialmedia	92	3m42s	2s416ms
translations	1	174ms	174ms

Sessions per user

Key values

postgres Main User
6,826 sessions Total

Chart
Table

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

Sessions per host

Key values

192.168.0.74 Main Host
6,826 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	116	36m3s	18s649ms
192.168.0.114	1	5m	5m
192.168.0.216	101	1m2s	619ms
192.168.0.74	4,060	4h20m39s	3s852ms
192.168.1.145	27	5h11m13s	11m31s
192.168.1.15	370	3h48m24s	37s39ms
192.168.1.20	63	14h3m51s	13m23s
192.168.1.231	20	9h50m49s	29m32s
192.168.1.239	1	7ms	7ms
192.168.1.90	52	1m4s	1s241ms
192.168.2.126	62	6s517ms	105ms
192.168.2.182	12	1s268ms	105ms
192.168.2.82	48	11s152ms	232ms
192.168.3.199	36	1s445ms	40ms
192.168.4.142	1,167	8m23s	431ms
192.168.4.150	10	20h7m28s	2h44s
192.168.4.228	4	26s106ms	6s526ms
192.168.4.238	16	22s308ms	1s394ms
192.168.4.33	91	1m52s	1s238ms
192.168.4.45	1	185ms	185ms
192.168.4.98	330	25s386ms	76ms
[local]	238	20m56s	5s280ms

Sessions per application

Key values

unknown Main Host
6,826 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
unknown	6,826	2d10h38m25s	30s926ms

Checkpoints Buffers

Key values

10,707 buffers Checkpoint Peak
2026-01-06 06:09:00 Date
209.920 seconds Highest write time
0.013 seconds Sync time

Checkpoints Wal files

Key values

4 files Wal files usage Peak
2026-01-06 06:39:00 Date

Checkpoints distance

Key values

140.42 Mo Distance Peak
2026-01-06 06:09:00 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jan 06	06	38,304	2,057.242s	0.077s	2,057.672s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Jan 06	06	0	0	21	2,022	0.007s	0s

Day	Hour	Count	Avg time (sec)
Jan 06	06	0	0s

Day	Hour	Mean distance	Mean estimate
Jan 06	06	28,959.92 kB	58,089.50 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (12) Main checkpoint cause
12 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	12
Total	12

Size of temporary files

Key values

184.74 MiB Temp Files size Peak
2026-01-06 06:00:08 Date

Number of temporary files

Key values

30 per second Temp Files Peak
2026-01-06 06:47:26 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jan 06	06	585	4.55 GiB	7.96 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	30	1.66 GiB	2.64 MiB	162.48 MiB	56.70 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = ? ), 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-06 06:00:05 Duration: 0ms
2	23	154.89 MiB	6.73 MiB	6.74 MiB	6.73 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-06 06:58:29 Duration: 0ms
3	13	500.60 MiB	38.51 MiB	38.51 MiB	38.51 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-06 06:56:12 Duration: 0ms
4	13	919.73 MiB	70.74 MiB	70.75 MiB	70.75 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-06 06:56:16 Duration: 0ms
5	8	947.16 MiB	118.38 MiB	118.41 MiB	118.40 MiB	select updateresultsmaterializedview (); select updateresultsmaterializedview (); Date: 2026-01-06 06:02:13 Duration: 0ms
6	4	321.37 MiB	80.30 MiB	80.40 MiB	80.34 MiB	select updateageforrelevantresults (); select updateageforrelevantresults (); Date: 2026-01-06 06:02:04 Duration: 0ms
7	1	3.03 MiB	3.03 MiB	3.03 MiB	3.03 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-06 06:02:25 Duration: 0ms

Queries generating the largest temporary files

Rank	Size	Query
1	162.48 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-06 06:50:08 ]
2	130.85 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-06 06:20:07 ]
3	118.41 MiB	select updateresultsmaterializedview (); [ Date: 2026-01-06 06:47:31 ]
4	118.41 MiB	select updateresultsmaterializedview (); [ Date: 2026-01-06 06:32:35 ]
5	118.40 MiB	select updateresultsmaterializedview (); [ Date: 2026-01-06 06:50:36 ]
6	118.40 MiB	select updateresultsmaterializedview (); [ Date: 2026-01-06 06:17:29 ]
7	118.39 MiB	select updateresultsmaterializedview (); [ Date: 2026-01-06 06:02:13 ]
8	118.39 MiB	select updateresultsmaterializedview (); [ Date: 2026-01-06 06:05:33 ]
9	118.38 MiB	select updateresultsmaterializedview (); [ Date: 2026-01-06 06:20:43 ]
10	118.38 MiB	select updateresultsmaterializedview (); [ Date: 2026-01-06 06:35:42 ]
11	107.93 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-06 06:10:06 ]
12	97.83 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-06 06:40:24 ]
13	97.62 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-06 06:00:04 ]
14	89.90 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-06 06:30:08 ]
15	89.78 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-06 06:10:06 ]
16	88.91 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-06 06:20:07 ]
17	80.40 MiB	select updateageforrelevantresults (); [ Date: 2026-01-06 06:02:04 ]
18	80.37 MiB	select updateageforrelevantresults (); [ Date: 2026-01-06 06:32:22 ]
19	80.30 MiB	select updateageforrelevantresults (); [ Date: 2026-01-06 06:47:20 ]
20	80.30 MiB	select updateageforrelevantresults (); [ Date: 2026-01-06 06:17:11 ]

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 (13) Main table analyzed (database acaweb_fx)
51 analyzes Total

Chart
Table

Table	Number of analyzes
acaweb_fx.public.solr_relevance_old	13
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_autochartist_results	4
acaweb_fx.public.relevance_fibonacci_results	4
acaweb_fx.pg_catalog.pg_type	3
acaweb_fx.public.latest_t15_candle_view	3
acaweb_fx.pg_catalog.pg_index	2
acaweb_fx.public.autochartist_symbolupdates	1
acaweb_fx.public.solr_imports	1
acaweb_fx.public.symbollatestupdatetime	1
acaweb_fx.pg_catalog.pg_depend	1
acaweb_fx.public.latest_candle_datetime_per_receng	1
Total	51

Vacuums per table

Key values

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

Chart
Table

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
acaweb_fx.public.solr_relevance_old	13	13	9,998	0	44	0	0	7,499	742	4,051,379
acaweb_fx.public.datafeeds_latestrun	5	0	603	0	5	0	0	62	4	37,941
acaweb_fx.pg_toast.pg_toast_2619	2	2	279	0	49	0	0	179	41	168,861
acaweb_fx.pg_catalog.pg_attribute	2	2	1,481	0	320	0	134	702	266	1,617,881
acaweb_fx.pg_catalog.pg_statistic	2	2	2,065	0	279	0	1,166	933	280	1,103,342
acaweb_fx.public.latest_t15_candle_view	2	2	183	0	8	0	0	12	2	17,137
acaweb_fx.public.relevance_keylevels_results	2	2	7,434	0	328	4	226	1,654	334	1,007,977
acaweb_fx.public.relevance_autochartist_results	2	2	6,913	0	138	4	492	1,485	125	391,454
acaweb_fx.public.relevance_fibonacci_results	2	2	2,458	0	40	2	127	381	26	89,923
acaweb_fx.pg_catalog.pg_index	1	1	95	0	15	0	0	31	12	84,605
acaweb_fx.pg_catalog.pg_type	1	1	177	0	24	0	0	43	19	126,395
acaweb_fx.public.autochartist_symbolupdates	1	1	23,836	0	2,371	5	37,914	6,902	3,094	1,278,921
acaweb_fx.public.relevance_consecutivecandles_results	1	1	72	0	10	1	0	23	6	34,809
acaweb_fx.pg_catalog.pg_class	1	1	457	0	63	0	0	158	62	294,378
Total	37	32	56,051	46,322	3,694	16	40,059	20,064	5,013	10,305,003

Tuples removed per table

Key values

public.solr_relevance_old (56428) Main table with removed tuples on database acaweb_fx
70822 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
acaweb_fx.public.solr_relevance_old	13	13	56,428	69,147	0	0	2,420
acaweb_fx.public.autochartist_symbolupdates	1	1	5,951	53,037	50	0	40,691
acaweb_fx.public.relevance_autochartist_results	2	2	2,660	16,754	0	0	760
acaweb_fx.pg_catalog.pg_attribute	2	2	2,346	22,408	828	0	520
acaweb_fx.public.relevance_keylevels_results	2	2	1,083	22,973	0	0	558
acaweb_fx.pg_catalog.pg_statistic	2	2	995	7,378	0	0	2,388
acaweb_fx.public.relevance_fibonacci_results	2	2	571	2,702	0	0	204
acaweb_fx.pg_catalog.pg_class	1	1	268	1,649	0	0	150
acaweb_fx.public.datafeeds_latestrun	5	0	241	129	59	0	80
acaweb_fx.pg_toast.pg_toast_2619	2	2	109	377	39	0	106
acaweb_fx.public.latest_t15_candle_view	2	2	101	51	23	0	2
acaweb_fx.public.relevance_consecutivecandles_results	1	1	53	285	0	0	7
acaweb_fx.pg_catalog.pg_index	1	1	14	813	0	1	22
acaweb_fx.pg_catalog.pg_type	1	1	2	1,485	39	0	38
Total	37	32	70,822	199,188	1,038	1	47,946

Pages removed per table

Key values

pg_catalog.pg_index (1) Main table with removed pages on database acaweb_fx
1 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
acaweb_fx.pg_catalog.pg_index	1	1	14	1
acaweb_fx.pg_toast.pg_toast_2619	2	2	109	0
acaweb_fx.pg_catalog.pg_type	1	1	2	0
acaweb_fx.public.autochartist_symbolupdates	1	1	5951	0
acaweb_fx.public.datafeeds_latestrun	5	0	241	0
acaweb_fx.pg_catalog.pg_attribute	2	2	2346	0
acaweb_fx.pg_catalog.pg_statistic	2	2	995	0
acaweb_fx.public.relevance_consecutivecandles_results	1	1	53	0
acaweb_fx.public.latest_t15_candle_view	2	2	101	0
acaweb_fx.public.relevance_keylevels_results	2	2	1083	0
acaweb_fx.pg_catalog.pg_class	1	1	268	0
acaweb_fx.public.solr_relevance_old	13	13	56428	0
acaweb_fx.public.relevance_autochartist_results	2	2	2660	0
acaweb_fx.public.relevance_fibonacci_results	2	2	571	0
Total	37	32	70,822	1

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jan 06	06	37	51

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

AccessExclusiveLock Main Lock Type
2 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
AccessExclusiveLock		2	16m33s	8m16s
	relation	2	16m33s	8m16s
	Total	2	16m33s	8m16s

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	1	14m11s	14m11s	14m11s	14m11s	truncate table solr_relevance_old; TRUNCATE TABLE solr_relevance_old; Date: 2026-01-06 06:19:23
2	1	2m21s	2m21s	2m21s	2m21s	refresh materialized view latest_candle_datetime_per_receng; refresh materialized view latest_candle_datetime_per_receng; Date: 2026-01-06 06:19:23

Queries that waited the most

Rank	Wait time	Query
1	14m11s	TRUNCATE TABLE solr_relevance_old; [ Date: 2026-01-06 06:19:23 ]
2	2m21s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2026-01-06 06:19:23 ]

Queries by type

Key values

105,735 Total read queries
42,434 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	105,735	32.85%
INSERT	29,432	9.14%
UPDATE	1,996	0.62%
DELETE	13	0.00%
COPY FROM	78	0.02%
COPY TO	601	0.19%
CTE	9,634	2.99%
DDL	13	0.00%
TCL	667	0.21%
CURSOR	0	0.00%
OTHERS	173,719	53.97%

Queries by database

Key values

unknown Main database
320,914 Requests
3h2m21s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
acaweb_fx	Total	877	0ms
	copy from	65	0ms
	copy to	26	0ms
	cte	85	0ms
	ddl	13	0ms
	delete	13	0ms
	others	202	0ms
	select	103	0ms
	tcl	331	0ms
	update	39	0ms
acaweb_fx_integer	Total	1	0ms
	select	1	0ms
postgres	Total	3	0ms
	select	3	0ms
socialmedia	Total	92	0ms
	select	92	0ms
translations	Total	1	0ms
	select	1	0ms
unknown	Total	320,914	3h2m21s
	copy from	13	0ms
	copy to	575	0ms
	cte	9,549	0ms
	insert	29,432	0ms
	others	12,572	0ms
	select	105,535	0ms
	tcl	336	0ms
	update	1,957	0ms

Queries by user

Key values

unknown Main user
320,914 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	974	0ms
	copy from	65	0ms
	copy to	26	0ms
	cte	85	0ms
	ddl	13	0ms
	delete	13	0ms
	others	202	0ms
	select	200	0ms
	tcl	331	0ms
	update	39	0ms
unknown	Total	320,914	3h2m21s
	copy from	13	0ms
	copy to	575	0ms
	cte	9,549	0ms
	insert	29,432	0ms
	others	12,572	0ms
	select	105,535	0ms
	tcl	336	0ms
	update	1,957	0ms

Duration by user

Key values

3h2m21s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	974	0ms
	copy from	65	0ms
	copy to	26	0ms
	cte	85	0ms
	ddl	13	0ms
	delete	13	0ms
	others	202	0ms
	select	200	0ms
	tcl	331	0ms
	update	39	0ms
unknown	Total	320,914	3h2m21s
	copy from	13	0ms
	copy to	575	0ms
	cte	9,549	0ms
	insert	29,432	0ms
	others	12,572	0ms
	select	105,535	0ms
	tcl	336	0ms
	update	1,957	0ms

Queries by host

Key values

unknown Main host
321,888 Requests
3h2m21s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	321,888	3h2m21s
	copy from	78	0ms
	copy to	601	0ms
	cte	9,634	0ms
	ddl	13	0ms
	delete	13	0ms
	insert	29,432	0ms
	others	12,774	0ms
	select	105,735	0ms
	tcl	667	0ms
	update	1,996	0ms

Queries by application

Key values

unknown Main application
321,534 Requests
3h2m21s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
pg_dump	Total	5	0ms
	select	5	0ms
psql	Total	349	0ms
	copy from	65	0ms
	copy to	26	0ms
	cte	85	0ms
	ddl	13	0ms
	delete	13	0ms
	others	4	0ms
	select	104	0ms
	update	39	0ms
unknown	Total	321,534	3h2m21s
	copy from	13	0ms
	copy to	575	0ms
	cte	9,549	0ms
	insert	29,432	0ms
	others	12,770	0ms
	select	105,626	0ms
	tcl	667	0ms
	update	1,957	0ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-01-06 06:33:21 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

105,736 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	105,736	65.70%
1-5ms	49,031	30.46%
5-10ms	1,916	1.19%
10-25ms	1,394	0.87%
25-50ms	431	0.27%
50-100ms	341	0.21%
100-500ms	587	0.36%
500-1000ms	195	0.12%
1000-10000ms	1,037	0.64%
> 10000ms	277	0.17%

Slowest individual queries

Rank	Duration	Query
NO DATASET

Time consuming queries

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

0ms

1

Details

0ms

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

Day	Hour	Count	Duration	Avg duration
Jan 06	06	1	0ms	0ms

2

0ms

1

Details

0ms

lock table public.stats_hrs_summary_by_groups in access share mode;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 06	06	1	0ms	0ms

3

0ms

2

Details

0ms

lock table public.timezones_korean in access share mode;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 06	06	2	0ms	0ms

4

0ms

32

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

Day	Hour	Count	Duration	Avg duration
Jan 06	06	32	0ms	0ms

5

0ms

2

Details

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 06	06	2	0ms	0ms

6

0ms

1

Details

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 06	06	1	0ms	0ms

7

0ms

2,104

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

Day	Hour	Count	Duration	Avg duration
Jan 06	06	2,104	0ms	0ms

8

0ms

975

Details

0ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 06	06	975	0ms	0ms

9

0ms

2

Details

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 06	06	2	0ms	0ms

10

0ms

2

Details

0ms

lock table public.futures_symbols in access share mode;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 06	06	2	0ms	0ms

11

0ms

2

Details

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 06	06	2	0ms	0ms

12

0ms

2

Details

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 06	06	2	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 06	06	18	0ms	0ms

14

0ms

5

Details

0ms

select s.tableoid, s.oid, s.subname, ( select rolname from pg_catalog.pg_roles where oid = s.subowner) as rolname, s.subconninfo, s.subslotname, s.subsynccommit, s.subpublications from pg_subscription s where s.subdbid = ( select oid from pg_database where datname = current_database());

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 06	06	5	0ms	0ms

15

0ms

1

Details

0ms

select usename, array_to_string(array ( select quote_ident(option_name) || ? || quote_literal(option_value) from pg_options_to_table(umoptions) order by option_name), e ?) as umoptions from pg_user_mappings where srvid = ? order by usename;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 06	06	1	0ms	0ms

16

0ms

2

Details

0ms

copy archive.sa_hist_consecutivecandles (id, symbolid, datetime, image, qty, percentile, direction, lastupdated, height) to stdout;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 06	06	2	0ms	0ms

17

0ms

1

Details

0ms

copy public.commoncontenttypeparams (id, name, required, description, "default", type) to stdout;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 06	06	1	0ms	0ms

18

0ms

434

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

Day	Hour	Count	Duration	Avg duration
Jan 06	06	434	0ms	0ms

19

0ms

2

Details

0ms

lock table public.powerstats in access share mode;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 06	06	2	0ms	0ms

20

0ms

4

Details

0ms

select oid, enumlabel from pg_catalog.pg_enum where enumtypid = ? order by enumsortorder;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 06	06	4	0ms	0ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

45,473

Details

0ms

select ?;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 06	06	45,473	0ms	0ms

2

33,794

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 06	06	33,794	0ms	0ms

3

8,342

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 06	06	8,342	0ms	0ms

4

7,000

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

Day	Hour	Count	Duration	Avg duration
Jan 06	06	7,000	0ms	0ms

5

5,808

Details

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 06	06	5,808	0ms	0ms

6

5,764

Details

0ms

set extra_float_digits = ?;

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 06	06	5,764	0ms	0ms

7

5,738

Details

0ms

set application_name = ?;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 06	06	5,738	0ms	0ms

8

5,566

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

Day	Hour	Count	Duration	Avg duration
Jan 06	06	5,566	0ms	0ms

9

4,517

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

Day	Hour	Count	Duration	Avg duration
Jan 06	06	4,517	0ms	0ms

10

3,227

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

Day	Hour	Count	Duration	Avg duration
Jan 06	06	3,227	0ms	0ms

11

2,356

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

12

2,104

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

13

1,736

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

Day	Hour	Count	Duration	Avg duration
Jan 06	06	1,736	0ms	0ms

14

1,650

Details

0ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 06	06	1,650	0ms	0ms

15

1,418

Details

0ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 06	06	1,418	0ms	0ms

16

1,034

Details

0ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 06	06	1,034	0ms	0ms

17

975

Details

0ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 06	06	975	0ms	0ms

18

805

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

Day	Hour	Count	Duration	Avg duration
Jan 06	06	805	0ms	0ms

19

785

Details

0ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 06	06	785	0ms	0ms

20

654

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 t60 t where t.symbolid = ? and (bsf = ? or bsf is null) and pricedatetime >= ? and pricedatetime <= ? order by pricedatetime desc limit ?;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 06	06	654	0ms	0ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

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

Day	Hour	Count	Duration	Avg duration
Jan 06	06	1	0ms	0ms

2

0ms

1

Details

0ms

lock table public.stats_hrs_summary_by_groups in access share mode;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 06	06	1	0ms	0ms

3

0ms

2

Details

0ms

lock table public.timezones_korean in access share mode;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 06	06	2	0ms	0ms

4

0ms

32

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

Day	Hour	Count	Duration	Avg duration
Jan 06	06	32	0ms	0ms

5

0ms

2

Details

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 06	06	2	0ms	0ms

6

0ms

1

Details

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 06	06	1	0ms	0ms

7

0ms

2,104

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

Day	Hour	Count	Duration	Avg duration
Jan 06	06	2,104	0ms	0ms

8

0ms

975

Details

0ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 06	06	975	0ms	0ms

9

0ms

2

Details

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 06	06	2	0ms	0ms

10

0ms

2

Details

0ms

lock table public.futures_symbols in access share mode;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 06	06	2	0ms	0ms

11

0ms

2

Details

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 06	06	2	0ms	0ms

12

0ms

2

Details

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 06	06	2	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 06	06	18	0ms	0ms

14

0ms

5

Details

0ms

select s.tableoid, s.oid, s.subname, ( select rolname from pg_catalog.pg_roles where oid = s.subowner) as rolname, s.subconninfo, s.subslotname, s.subsynccommit, s.subpublications from pg_subscription s where s.subdbid = ( select oid from pg_database where datname = current_database());

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 06	06	5	0ms	0ms

15

0ms

1

Details

0ms

select usename, array_to_string(array ( select quote_ident(option_name) || ? || quote_literal(option_value) from pg_options_to_table(umoptions) order by option_name), e ?) as umoptions from pg_user_mappings where srvid = ? order by usename;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 06	06	1	0ms	0ms

16

0ms

2

Details

0ms

copy archive.sa_hist_consecutivecandles (id, symbolid, datetime, image, qty, percentile, direction, lastupdated, height) to stdout;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 06	06	2	0ms	0ms

17

0ms

1

Details

0ms

copy public.commoncontenttypeparams (id, name, required, description, "default", type) to stdout;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 06	06	1	0ms	0ms

18

0ms

434

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

Day	Hour	Count	Duration	Avg duration
Jan 06	06	434	0ms	0ms

19

0ms

2

Details

0ms

lock table public.powerstats in access share mode;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 06	06	2	0ms	0ms

20

0ms

4

Details

0ms

select oid, enumlabel from pg_catalog.pg_enum where enumtypid = ? order by enumsortorder;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 06	06	4	0ms	0ms

Time consuming prepare


Date: 2026-01-06 06:05:40
Duration: 18ms
Database: postgres
Date: 2026-01-06 06:33:15
Duration: 19ms
Database: postgres
Date: 2026-01-06 06:16:31
Duration: 14ms
Database: postgres
Date: 2026-01-06 06:06:31
Duration: 7ms
Database: postgres
Date: 2026-01-06 06:17:35
Duration: 4ms
Database: postgres
Date: 2026-01-06 06:42:14
Duration: 20ms
Database: postgres
Date: 2026-01-06 06:11:52
Duration: 0ms
Database: postgres
Date: 2026-01-06 06:11:33
Duration: 0ms
Database: postgres
Date: 2026-01-06 06:00:04
Duration: 0ms
Database: postgres
Date: 2026-01-06 06:21:39
Duration: 8ms
Database: postgres
Date: 2026-01-06 06:40:03
Duration: 45ms
Database: postgres
Date: 2026-01-06 06:05:40
Duration: 4ms
Database: postgres
Date: 2026-01-06 06:32:00
Duration: 8ms
Database: postgres
Date: 2026-01-06 06:12:53
Duration: 0ms
Database: postgres
Date: 2026-01-06 06:40:10
Duration: 15ms
Database: postgres
Date: 2026-01-06 06:20:02
Duration: 3ms
Database: postgres
Date: 2026-01-06 06:10:04
Duration: 3ms
Database: postgres
Date: 2026-01-06 06:15:00
Duration: 0ms
Database: postgres
Date: 2026-01-06 06:16:23
Duration: 0ms
Database: postgres
Date: 2026-01-06 06:12:50
Duration: 3ms
Database: postgres

Time consuming bind

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

47s623ms

8,599

Details

0ms

49ms

5ms

WITH rar_max as ( ;

Times Reported Time consuming bind #1

Day	Hour	Count	Duration	Avg duration
Jan 06	06	8,599	47s623ms	5ms

WITH rar_max as ( ;

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

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

Date: 2026-01-06 06:23:38 Duration: 47ms Database: postgres parameters: $1 = '607453318431553301', $2 = '607453318431553301', $3 = '607453318431553301'

2

22s692ms

43,537

Details

0ms

36ms

0ms

SELECT ;

Times Reported Time consuming bind #2

Day	Hour	Count	Duration	Avg duration
	06	43,537	22s692ms	0ms

SELECT ;

Date: 2026-01-06 06:24:05 Duration: 36ms Database: postgres parameters: $1 = '958', $2 = '958', $3 = '515840249420088300'
SELECT ;

Date: 2026-01-06 06:08:11 Duration: 33ms Database: postgres parameters: $1 = '958', $2 = '958', $3 = '515840249443731300'
SELECT ;

Date: 2026-01-06 06:08:11 Duration: 32ms Database: postgres parameters: $1 = '958', $2 = '958', $3 = '515840233380849300'

3

2s550ms

1,138

Details

1ms

10ms

2ms

SELECT symbolid, ;

Times Reported Time consuming bind #3

Day	Hour	Count	Duration	Avg duration
	06	1,138	2s550ms	2ms

SELECT symbolid, ;

Date: 2026-01-06 06:16:24 Duration: 10ms Database: postgres parameters: $1 = 'MILLENNIUMPF', $2 = '15', $3 = 'USDJPY', $4 = 'USDCAD.ID', $5 = 'USDCHF.ID', $6 = 'USDJPY.ID', $7 = 'USDCHF', $8 = 'USDCHF.FX', $9 = 'USDCAD.FX', $10 = 'USDJPY.FX'
SELECT symbolid, ;

Date: 2026-01-06 06:16:31 Duration: 10ms Database: postgres parameters: $1 = 'ICMARKETS', $2 = '15', $3 = 'EURDKK', $4 = 'EURCHF'
SELECT symbolid, ;

Date: 2026-01-06 06:32:11 Duration: 4ms Database: postgres parameters: $1 = 'MILLENNIUMPF', $2 = '15', $3 = 'EURCHF.FX', $4 = 'EURGBP', $5 = 'EURGBP.ID', $6 = 'EURGBP.FX', $7 = 'EURCHF.ID', $8 = 'EURCHF'

4

994ms

45,349

Details

0ms

12ms

0ms

select 1;

Times Reported Time consuming bind #4

Day	Hour	Count	Duration	Avg duration
	06	45,349	994ms	0ms

select 1;

Date: 2026-01-06 06:41:11 Duration: 12ms Database: postgres
select 1;

Date: 2026-01-06 06:47:44 Duration: 7ms Database: postgres
select 1;

Date: 2026-01-06 06:16:04 Duration: 3ms Database: postgres

5

896ms

546

Details

1ms

14ms

1ms

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

Times Reported Time consuming bind #5

Day	Hour	Count	Duration	Avg duration
	06	546	896ms	1ms

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

Date: 2026-01-06 06:16:28 Duration: 14ms Database: postgres parameters: $1 = 'MILLENNIUMPF'
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;

Date: 2026-01-06 06:17:35 Duration: 8ms Database: postgres parameters: $1 = 'ATFX'
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;

Date: 2026-01-06 06:17:03 Duration: 3ms Database: postgres parameters: $1 = 'MILLENNIUMPF'

6

714ms

16

Details

29ms

61ms

44ms

with sym_info as ( ;

Times Reported Time consuming bind #6

Day	Hour	Count	Duration	Avg duration
	06	16	714ms	44ms

with sym_info as ( ;

Date: 2026-01-06 06:36:42 Duration: 61ms Database: postgres parameters: $1 = '620', $2 = 'Forex', $3 = 'Forex', $4 = '620', $5 = 'Forex', $6 = '620', $7 = '620', $8 = 'Forex', $9 = '620'
with sym_info as ( ;

Date: 2026-01-06 06:21:40 Duration: 55ms Database: postgres parameters: $1 = '620', $2 = 'Forex', $3 = 'Forex', $4 = '620', $5 = 'Forex', $6 = '620', $7 = '620', $8 = 'Forex', $9 = '620'
with sym_info as ( ;

Date: 2026-01-06 06:06:53 Duration: 45ms Database: postgres parameters: $1 = '627', $2 = 'Forex', $3 = 'Forex', $4 = '627', $5 = 'Forex', $6 = '627', $7 = '627', $8 = 'Forex', $9 = '627'

7

539ms

60

Details

4ms

20ms

8ms

WITH last_candle AS ( ;

Times Reported Time consuming bind #7

Day	Hour	Count	Duration	Avg duration
	06	60	539ms	8ms

WITH last_candle AS ( ;

Date: 2026-01-06 06:00:01 Duration: 20ms Database: postgres parameters: $1 = '667', $2 = '667'
WITH last_candle AS ( ;

Date: 2026-01-06 06:36:00 Duration: 20ms Database: postgres parameters: $1 = '558', $2 = '558'
WITH last_candle AS ( ;

Date: 2026-01-06 06:36:00 Duration: 19ms Database: postgres parameters: $1 = '558', $2 = '558'

8

528ms

73

Details

0ms

20ms

7ms

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

Times Reported Time consuming bind #8

Day	Hour	Count	Duration	Avg duration
	06	73	528ms	7ms

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

Date: 2026-01-06 06:18:20 Duration: 20ms 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-06 06:51:19 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-06 06:06:59 Duration: 17ms Database: postgres parameters: $1 = '667', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'

9

426ms

19

Details

0ms

35ms

22ms

with wh_patitioned as ( ;

Times Reported Time consuming bind #9

Day	Hour	Count	Duration	Avg duration
	06	19	426ms	22ms

with wh_patitioned as ( ;

Date: 2026-01-06 06:25:01 Duration: 35ms 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-06 06:35:01 Duration: 32ms 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-06 06:47:55 Duration: 32ms Database: postgres parameters: $1 = '558', $2 = '558', $3 = '558', $4 = '558', $5 = '558', $6 = '558', $7 = '558', $8 = '558', $9 = '558'

10

251ms

5,566

Details

0ms

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

Times Reported Time consuming bind #10

Day	Hour	Count	Duration	Avg duration
	06	5,566	251ms	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-06 06:02:18 Duration: 0ms Database: postgres parameters: $1 = '2026-01-06 06:45:00', $2 = '0.79092', $3 = '0.791055', $4 = '0.790845', $5 = '0.791045', $6 = '236', $7 = '515840249377809300', $8 = '0', $9 = '2026-01-06 06:02:18.873', $10 = '2026-01-06 06:02:18.563', $11 = '0.79092', $12 = '0.791055', $13 = '0.790845', $14 = '0.791045', $15 = '236', $16 = '0', $17 = '2026-01-06 06:02:18.873', $18 = '2026-01-06 06:02:18.563'
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-06 06:32:42 Duration: 0ms Database: postgres parameters: $1 = '2026-01-06 06:00:00', $2 = '8695.4', $3 = '8701.4', $4 = '8694.4', $5 = '8694.4', $6 = '94', $7 = '515840238058964300', $8 = '0', $9 = '2026-01-06 06:32:42.512', $10 = '2026-01-06 06:32:42.476', $11 = '8695.4', $12 = '8701.4', $13 = '8694.4', $14 = '8694.4', $15 = '94', $16 = '0', $17 = '2026-01-06 06:32:42.512', $18 = '2026-01-06 06:32:42.476'
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-06 06:41:49 Duration: 0ms Database: postgres parameters: $1 = '2026-01-06 06:15:00', $2 = '25444.15', $3 = '25452.9', $4 = '25441.15', $5 = '25442.4', $6 = '1484', $7 = '515840248038958300', $8 = '0', $9 = '2026-01-06 06:41:49.195', $10 = '2026-01-06 06:41:49.11', $11 = '25444.15', $12 = '25452.9', $13 = '25441.15', $14 = '25442.4', $15 = '1484', $16 = '0', $17 = '2026-01-06 06:41:49.195', $18 = '2026-01-06 06:41:49.11'

11

240ms

3,227

Details

0ms

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

Times Reported Time consuming bind #11

Day	Hour	Count	Duration	Avg duration
	06	3,227	240ms	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-06 06:11:52 Duration: 0ms Database: postgres parameters: $1 = '2026-01-06 05:30:00', $2 = '48990.2', $3 = '49005.3', $4 = '48983.45', $5 = '49001.3', $6 = '2316', $7 = '515840248000726300', $8 = '0', $9 = '2026-01-06 06:11:52.101', $10 = '2026-01-06 06:11:51.994', $11 = '48990.2', $12 = '49005.3', $13 = '48983.45', $14 = '49001.3', $15 = '2316', $16 = '0', $17 = '2026-01-06 06:11:52.101', $18 = '2026-01-06 06:11:51.994'
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-06 06:41:49 Duration: 0ms Database: postgres parameters: $1 = '2026-01-06 05:00:00', $2 = '26821', $3 = '26882.7', $4 = '26794.8', $5 = '26871.2', $6 = '8552', $7 = '515840247933633300', $8 = '0', $9 = '2026-01-06 06:41:49.213', $10 = '2026-01-06 06:41:49.121', $11 = '26821', $12 = '26882.7', $13 = '26794.8', $14 = '26871.2', $15 = '8552', $16 = '0', $17 = '2026-01-06 06:41:49.213', $18 = '2026-01-06 06:41:49.121'
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-06 06:11:37 Duration: 0ms Database: postgres parameters: $1 = '2026-01-06 05:00:00', $2 = '8694.4', $3 = '8700.9', $4 = '8688.4', $5 = '8689.4', $6 = '2426', $7 = '515840248015340300', $8 = '0', $9 = '2026-01-06 06:11:37.929', $10 = '2026-01-06 06:11:37.822', $11 = '8694.4', $12 = '8700.9', $13 = '8688.4', $14 = '8689.4', $15 = '2426', $16 = '0', $17 = '2026-01-06 06:11:37.929', $18 = '2026-01-06 06:11:37.822'

12

170ms

2,104

Details

0ms

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

Times Reported Time consuming bind #12

Day	Hour	Count	Duration	Avg duration
	06	2,104	170ms	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-06 06:11:47 Duration: 0ms Database: postgres parameters: $1 = '2026-01-06 04:00:00', $2 = '26708.2', $3 = '26822.4', $4 = '26623.2', $5 = '26821.2', $6 = '23215', $7 = '515840247933961300', $8 = '0', $9 = '2026-01-06 06:11:47.995', $10 = '2026-01-06 06:11:47.918', $11 = '26708.2', $12 = '26822.4', $13 = '26623.2', $14 = '26821.2', $15 = '23215', $16 = '0', $17 = '2026-01-06 06:11:47.995', $18 = '2026-01-06 06:11:47.918'
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-06 06:11:33 Duration: 0ms Database: postgres parameters: $1 = '2026-01-05 21:00:00', $2 = '474.63', $3 = '474.81', $4 = '473.36', $5 = '473.63', $6 = '3776', $7 = '515840247896450300', $8 = '0', $9 = '2026-01-06 06:11:33.842', $10 = '2026-01-06 06:11:33.773', $11 = '474.63', $12 = '474.81', $13 = '473.36', $14 = '473.63', $15 = '3776', $16 = '0', $17 = '2026-01-06 06:11:33.842', $18 = '2026-01-06 06:11:33.773'
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-06 06:11:37 Duration: 0ms Database: postgres parameters: $1 = '2026-01-06 04:00:00', $2 = '8691.4', $3 = '8700.9', $4 = '8683.8', $5 = '8689.4', $6 = '4999', $7 = '515840248015562300', $8 = '0', $9 = '2026-01-06 06:11:37.965', $10 = '2026-01-06 06:11:37.83', $11 = '8691.4', $12 = '8700.9', $13 = '8683.8', $14 = '8689.4', $15 = '4999', $16 = '0', $17 = '2026-01-06 06:11:37.965', $18 = '2026-01-06 06:11:37.83'

13

113ms

213

Details

0ms

4ms

0ms

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

Times Reported Time consuming bind #13

Day	Hour	Count	Duration	Avg duration
	06	213	113ms	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-06 06:12:51 Duration: 4ms 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-06 06:12:53 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-06 06:12:52 Duration: 0ms Database: postgres

14

71ms

6

Details

3ms

39ms

11ms

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

Times Reported Time consuming bind #14

Day	Hour	Count	Duration	Avg duration
	06	6	71ms	11ms

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

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

Date: 2026-01-06 06:30:02 Duration: 7ms Database: postgres

15

58ms

63

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
	06	63	58ms	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-06 06:31:24 Duration: 1ms Database: postgres parameters: $1 = '558', $2 = 'GBPCHF', $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-06 06:47:21 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-06 06:06:52 Duration: 1ms Database: postgres parameters: $1 = '621', $2 = 'GBPJPY', $3 = '621'

16

54ms

9

Details

4ms

10ms

6ms

SELECT DISTINCT ON (basegroupname, symbol) ;

Times Reported Time consuming bind #16

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

SELECT DISTINCT ON (basegroupname, symbol) ;

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

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

Date: 2026-01-06 06:12:23 Duration: 6ms Database: postgres parameters: $1 = '958', $2 = '958'

17

47ms

1

Details

47ms

with maxwhid as ( ;

Times Reported Time consuming bind #17

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

with maxwhid as ( ;

Date: 2026-01-06 06:13:15 Duration: 47ms 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'

18

40ms

8

Details

2ms

11ms

5ms

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

Times Reported Time consuming bind #18

Day	Hour	Count	Duration	Avg duration
	06	8	40ms	5ms

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

Date: 2026-01-06 06:12:50 Duration: 11ms 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-06 06:12:50 Duration: 5ms 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-06 06:12:51 Duration: 5ms 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'

19

28ms

23

Details

0ms

4ms

1ms

WITH tr_max AS ( ;

Times Reported Time consuming bind #19

Day	Hour	Count	Duration	Avg duration
	06	23	28ms	1ms

WITH tr_max AS ( ;

Date: 2026-01-06 06:12:51 Duration: 4ms Database: postgres parameters: $1 = '606715250647000300', $2 = '606715250647000300', $3 = '606715250647000300', $4 = '1', $5 = '1', $6 = '1320', $7 = 't', $8 = '1320'
WITH tr_max AS ( ;

Date: 2026-01-06 06:12:52 Duration: 1ms Database: postgres parameters: $1 = '606715250653631300', $2 = '606715250653631300', $3 = '606715250653631300', $4 = '2', $5 = '2', $6 = '300', $7 = 't', $8 = '300'
WITH tr_max AS ( ;

Date: 2026-01-06 06:12:54 Duration: 1ms Database: postgres parameters: $1 = '605679104907764300', $2 = '605679104907764300', $3 = '605679104907764300', $4 = '1', $5 = '1', $6 = '1320', $7 = 't', $8 = '1320'

20

26ms

5,738

Details

0ms

3ms

0ms

SET application_name = 'PostgreSQL JDBC Driver';

Times Reported Time consuming bind #20

Day	Hour	Count	Duration	Avg duration
	06	5,738	26ms	0ms

SET application_name = 'PostgreSQL JDBC Driver';

Date: 2026-01-06 06:06:43 Duration: 3ms Database: postgres
SET application_name = 'PostgreSQL JDBC Driver';

Date: 2026-01-06 06:22:06 Duration: 0ms Database: postgres
SET application_name = 'PostgreSQL JDBC Driver';

Date: 2026-01-06 06:10:03 Duration: 0ms Database: postgres

Log levels

Key values

641,719 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	418	0.07%
DETAIL	133,044	20.73%
ERROR	1	0.00%
LOG	507,703	79.12%
STATEMENT	553	0.09%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
4 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

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

Rank

Times reported

Error

1

4

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jan 06	06	4

LOG: process 1932 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 1000.052 ms
LOG: process 1932 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 50895.148 ms
LOG: process 6597 still waiting for AccessExclusiveLock on relation 5894441 of database 5881926 after 1000.060 ms

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

Queries generating the most temporary files (N)

Queries generating the largest temporary files

Vacuums

Vacuums / Analyzes Distribution

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Autovacuum Activity

Locks

Locks by types

Key values

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values

Queries by user

Key values

Duration by user

Key values