pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Mon Feb 16 10:59:40 2026
Log file: /home/postgres/pg_data/data/pg_log/postgresql-2026-02-16_120000.log
Parsed 1,496,736 log entries in 38s
Log start from 2026-02-16 12:00:00 to 2026-02-16 12:59:38

Global Stats

315 Number of unique normalized queries
176,669 Number of queries
1h50m9s Total query duration
2026-02-16 12:00:00 First query
2026-02-16 12:59:38 Last query
4,942 queries/s at 2026-02-16 12:45:04 Query peak

1h50m9s Total query duration
7s356ms Prepare/parse total duration
49s126ms Bind total duration
1h49m13s Execute total duration

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

42 Total number of automatic vacuums
56 Total number of automatic analyzes

891 Number temporary file
170.10 MiB Max size of temporary file
6.34 MiB Average size of temporary file

2,889 Total number of sessions
12 sessions at 2026-02-16 12:55:56 Session peak
2d5h51m37s Total duration of sessions
1m7s Average duration of sessions
61 Average queries per session
2s287ms Average queries duration per session
1m4s Average idle time per session

2,903 Total number of connections
27 connections/s at 2026-02-16 12:18:48 Connection peak
3 Total number of databases

SQL Traffic

Key values

4,942 queries/s Query Peak
2026-02-16 12:45:04 Date

SELECT Traffic

Key values

2,432 queries/s Query Peak
2026-02-16 12:45:04 Date

INSERT/UPDATE/DELETE Traffic

Key values

160 queries/s Query Peak
2026-02-16 12:00:56 Date

Queries duration

Key values

1h50m9s Total query duration

Prepared queries ratio

Key values

0.00 Ratio of bind vs prepare
0.00 % Ratio between prepared and "usual" statements

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 16	12	176,669	0ms	27s907ms	37ms	5m9s	5m23s	6m22s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 16	12	50,613	26	0ms	0ms	0ms	0ms

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 16	12	26,126	2,074	16	96	0ms	0ms	0ms	0ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Feb 16	12	19,606	63,013	3.21	23.39%

Day	Hour	Count	Average / Second
Feb 16	12	2,903	0.81/s

Day	Hour	Count	Average Duration	Average idle time
Feb 16	12	2,889	1m7s	1m4s

↑ Back to the top of the General Activity table

Established Connections

Key values

27 connections Connection Peak
2026-02-16 12:18:48 Date

Connections per database

Key values

acaweb_fx Main Database
2,903 connections Total

Chart
Table

Database	User	Count
acaweb_fx		2,819
	postgres	2,461
	psql	358
socialmedia		84
	postgres	84

Connections per user

Key values

postgres Main User
2,903 connections Total

Chart
Table

User	Count
postgres	2,545
psql	358

Connections per host

Key values

192.168.4.142 Main host with 1212 connections
2,903 Total connections

Chart
Table

Host	Count
104.30.164.187	2
127.0.0.1	114
182.165.1.54	2
192.168.0.114	20
192.168.0.216	104
192.168.0.74	209
192.168.1.145	65
192.168.1.15	230
192.168.1.20	80
192.168.1.231	20
192.168.1.239	15
192.168.1.90	58
192.168.2.126	40
192.168.2.182	12
192.168.3.199	36
192.168.4.142	1,212
192.168.4.150	10
192.168.4.224	7
192.168.4.238	16
192.168.4.33	76
192.168.4.57	1
192.168.4.98	330
[local]	244

Simultaneous sessions

Key values

12 sessions Session Peak
2026-02-16 12:55:56 Date

Histogram of session times

Key values

2,368 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	2,368	81.97%
500ms-1s	125	4.33%
1s-30s	279	9.66%
30s-1m	5	0.17%
1m-10m	42	1.45%
10m-30m	48	1.66%
30m-1h	8	0.28%
1h-8h	14	0.48%
> 8h	0	0.00%

Sessions per database

Key values

acaweb_fx Main Database
2,889 sessions Total

Chart
Table

Database	User	Count	Total Duration	Average Duration
acaweb_fx	2,805	2d4h51m36s	1m7s
socialmedia	84	1h	42s864ms

Sessions per user

Key values

postgres Main User
2,889 sessions Total

Chart
Table

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

Sessions per host

Key values

192.168.4.142 Main Host
2,889 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
104.30.164.187	1	19s627ms	19s627ms
127.0.0.1	114	13s162ms	115ms
182.165.1.54	1	1s562ms	1s562ms
192.168.0.114	20	1h43m8s	5m9s
192.168.0.216	104	1m53s	1s90ms
192.168.0.74	209	4h46m15s	1m22s
192.168.1.145	65	4h23m13s	4m2s
192.168.1.15	229	3h45m52s	59s180ms
192.168.1.20	79	13h39m9s	10m22s
192.168.1.231	10	4h56m34s	29m39s
192.168.1.239	15	113ms	7ms
192.168.1.90	58	35s123ms	605ms
192.168.2.126	40	7s17ms	175ms
192.168.2.182	12	993ms	82ms
192.168.3.199	36	1s335ms	37ms
192.168.4.142	1,212	8m48s	436ms
192.168.4.150	10	20h3m35s	2h21s
192.168.4.224	7	42s638ms	6s91ms
192.168.4.238	16	20s672ms	1s292ms
192.168.4.33	76	17m2s	13s450ms
192.168.4.57	1	207ms	207ms
192.168.4.98	330	15s821ms	47ms
[local]	244	3m25s	843ms

Sessions per application

Key values

unknown Main Host
2,889 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
unknown	2,889	2d5h51m37s	1m7s

Checkpoints Buffers

Key values

15,646 buffers Checkpoint Peak
2026-02-16 12:06:53 Date
209.994 seconds Highest write time
0.010 seconds Sync time

Checkpoints Wal files

Key values

7 files Wal files usage Peak
2026-02-16 12:06:53 Date

Checkpoints distance

Key values

218.00 Mo Distance Peak
2026-02-16 12:06:53 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Feb 16	12	52,830	1,967.898s	0.041s	1,968.242s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Feb 16	12	0	0	26	2,080	0.006s	0s

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

Day	Hour	Mean distance	Mean estimate
Feb 16	12	35,120.92 kB	78,940.00 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (12) Main checkpoint cause
12 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	12
Total	12

Size of temporary files

Key values

184.96 MiB Temp Files size Peak
2026-02-16 12:50:07 Date

Number of temporary files

Key values

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

Temporary Files Activity

Temp Files

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

Queries generating the largest temporary files

Rank	Size	Query
1	170.10 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2026-02-16 12:40:05 ]
2	137.09 MiB	select updateresultsmaterializedview (); [ Date: 2026-02-16 12:32:17 ]
3	137.09 MiB	select updateresultsmaterializedview (); [ Date: 2026-02-16 12:47:12 ]
4	137.08 MiB	select updateresultsmaterializedview (); [ Date: 2026-02-16 12:17:15 ]
5	137.08 MiB	select updateresultsmaterializedview (); [ Date: 2026-02-16 12:50:32 ]
6	137.07 MiB	select updateresultsmaterializedview (); [ Date: 2026-02-16 12:35:32 ]
7	137.06 MiB	select updateresultsmaterializedview (); [ Date: 2026-02-16 12:02:12 ]
8	137.06 MiB	select updateresultsmaterializedview (); [ Date: 2026-02-16 12:20:33 ]
9	137.06 MiB	select updateresultsmaterializedview (); [ Date: 2026-02-16 12:05:32 ]
10	113.65 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2026-02-16 12:00:04 ]
11	109.73 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2026-02-16 12:00:05 ]
12	95.41 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2026-02-16 12:30:05 ]
13	93.30 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2026-02-16 12:30:04 ]
14	90.36 MiB	select updateageforrelevantresults (); [ Date: 2026-02-16 12:02:04 ]
15	90.25 MiB	select updateageforrelevantresults (); [ Date: 2026-02-16 12:32:05 ]
16	90.20 MiB	select updateageforrelevantresults (); [ Date: 2026-02-16 12:17:05 ]
17	90.19 MiB	select updateageforrelevantresults (); [ Date: 2026-02-16 12:47:04 ]
18	88.76 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2026-02-16 12:50:04 ]
19	87.34 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2026-02-16 12:20:04 ]
20	87.28 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2026-02-16 12:10:03 ]

Vacuums / Analyzes Distribution

Key values

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

Analyzes per table

Key values

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

Chart
Table

Table	Number of analyzes
acaweb_fx.public.solr_relevance_old	16
acaweb_fx.pg_catalog.pg_attribute	8
acaweb_fx.pg_catalog.pg_type	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.datafeeds_latestrun	3
acaweb_fx.public.relevance_fibonacci_results	3
acaweb_fx.pg_catalog.pg_index	2
acaweb_fx.public.autochartist_symbolupdates	2
acaweb_fx.public.latest_t15_candle_view	2
acaweb_fx.pg_catalog.pg_depend	2
acaweb_fx.public.relevance_consecutivecandles_results	1
acaweb_fx.public.latest_candle_datetime_per_receng	1
Total	56

Vacuums per table

Key values

public.solr_relevance_old (16) Main table vacuumed on database acaweb_fx
42 vacuums Total

Chart
Table

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
acaweb_fx.public.solr_relevance_old	16	16	13,405	0	63	0	0	9,282	1,209	5,562,637
acaweb_fx.pg_catalog.pg_attribute	4	4	3,447	0	581	0	268	1,361	542	3,025,469
acaweb_fx.public.datafeeds_latestrun	3	0	350	0	12	0	0	39	6	40,624
acaweb_fx.pg_toast.pg_toast_2619	2	2	272	0	61	0	0	197	58	200,950
acaweb_fx.pg_catalog.pg_type	2	2	290	0	53	0	0	146	34	190,259
acaweb_fx.public.latest_t15_candle_view	2	2	159	0	2	0	0	12	2	18,044
acaweb_fx.public.relevance_keylevels_results	2	2	7,923	0	354	2	142	2,311	344	1,041,213
acaweb_fx.public.relevance_autochartist_results	2	2	6,821	0	206	0	465	1,375	192	474,855
acaweb_fx.pg_catalog.pg_class	2	2	936	0	104	0	0	312	102	552,870
acaweb_fx.public.relevance_fibonacci_results	2	2	2,491	0	87	0	80	456	138	415,466
acaweb_fx.pg_catalog.pg_index	1	1	104	0	16	0	0	28	15	91,826
acaweb_fx.public.autochartist_symbolupdates	1	1	23,608	0	3,986	2	38,242	6,908	3,921	1,780,439
acaweb_fx.public.solr_imports	1	1	65	0	1	0	0	6	1	8,929
acaweb_fx.pg_catalog.pg_statistic	1	1	997	0	190	0	582	469	180	670,775
acaweb_fx.pg_catalog.pg_depend	1	1	385	0	72	0	59	172	71	350,188
Total	42	39	61,253	46,809	5,788	4	39,838	23,074	6,815	14,424,544

Tuples removed per table

Key values

public.solr_relevance_old (47650) Main table with removed tuples on database acaweb_fx
64078 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
acaweb_fx.public.solr_relevance_old	16	16	47,650	95,951	0	0	3,334
acaweb_fx.public.autochartist_symbolupdates	1	1	5,658	50,394	1	0	40,691
acaweb_fx.pg_catalog.pg_attribute	4	4	5,190	43,101	0	0	1,048
acaweb_fx.public.relevance_keylevels_results	2	2	2,184	25,222	0	0	558
acaweb_fx.public.relevance_autochartist_results	2	2	891	16,726	0	0	760
acaweb_fx.pg_catalog.pg_type	2	2	717	2,896	0	0	87
acaweb_fx.pg_catalog.pg_statistic	1	1	560	3,744	0	0	1,194
acaweb_fx.pg_catalog.pg_class	2	2	278	3,300	0	0	300
acaweb_fx.pg_catalog.pg_depend	1	1	242	14,427	0	0	142
acaweb_fx.public.relevance_fibonacci_results	2	2	223	2,962	0	0	204
acaweb_fx.public.datafeeds_latestrun	3	0	164	42	0	0	48
acaweb_fx.pg_toast.pg_toast_2619	2	2	143	336	0	0	106
acaweb_fx.public.latest_t15_candle_view	2	2	107	28	0	0	2
acaweb_fx.public.solr_imports	1	1	52	1	0	0	2
acaweb_fx.pg_catalog.pg_index	1	1	19	813	0	0	22
Total	42	39	64,078	259,943	1	0	48,498

Pages removed per table

Key values

unknown (0) Main table with removed pages on database unknown
0 pages Total removed

Chart
Table

Pages removed per tables

NO DATASET

Table	Number of vacuums	Index scans	Tuples removed
acaweb_fx.pg_catalog.pg_index	1	1	19
acaweb_fx.pg_toast.pg_toast_2619	2	2	143
acaweb_fx.pg_catalog.pg_type	2	2	717
acaweb_fx.public.autochartist_symbolupdates	1	1	5658
acaweb_fx.public.datafeeds_latestrun	3	0	164
acaweb_fx.public.solr_imports	1	1	52
acaweb_fx.pg_catalog.pg_statistic	1	1	560
acaweb_fx.pg_catalog.pg_attribute	4	4	5190
acaweb_fx.public.latest_t15_candle_view	2	2	107
acaweb_fx.pg_catalog.pg_depend	1	1	242
acaweb_fx.public.relevance_keylevels_results	2	2	2184
acaweb_fx.public.solr_relevance_old	16	16	47650
acaweb_fx.public.relevance_autochartist_results	2	2	891
acaweb_fx.pg_catalog.pg_class	2	2	278
acaweb_fx.public.relevance_fibonacci_results	2	2	223
Total	42	39	64,078

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Feb 16	12	42	56

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

NO DATASET

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

Most frequent waiting queries (N)

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

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

50,613 Total read queries
33,218 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	50,613	28.65%
INSERT	26,126	14.79%
UPDATE	2,074	1.17%
DELETE	16	0.01%
COPY FROM	96	0.05%
COPY TO	26	0.01%
CTE	4,005	2.27%
DDL	21	0.01%
TCL	854	0.48%
CURSOR	0	0.00%
OTHERS	92,838	52.55%

Queries by database

Key values

unknown Main database
175,718 Requests
1h49m13s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
acaweb_fx	Total	867	0ms
	copy from	80	0ms
	copy to	26	0ms
	cte	104	0ms
	ddl	16	0ms
	delete	16	0ms
	others	171	0ms
	select	72	0ms
	tcl	342	0ms
	update	40	0ms
socialmedia	Total	84	0ms
	select	76	0ms
	tcl	8	0ms
unknown	Total	175,718	1h49m13s
	copy from	16	0ms
	cte	3,901	0ms
	ddl	5	0ms
	insert	26,126	0ms
	others	4,333	0ms
	select	50,465	0ms
	tcl	504	0ms
	update	2,034	0ms

Queries by user

Key values

unknown Main user
175,718 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	951	0ms
	copy from	80	0ms
	copy to	26	0ms
	cte	104	0ms
	ddl	16	0ms
	delete	16	0ms
	others	171	0ms
	select	148	0ms
	tcl	350	0ms
	update	40	0ms
unknown	Total	175,718	1h49m13s
	copy from	16	0ms
	cte	3,901	0ms
	ddl	5	0ms
	insert	26,126	0ms
	others	4,333	0ms
	select	50,465	0ms
	tcl	504	0ms
	update	2,034	0ms

Duration by user

Key values

1h49m13s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	951	0ms
	copy from	80	0ms
	copy to	26	0ms
	cte	104	0ms
	ddl	16	0ms
	delete	16	0ms
	others	171	0ms
	select	148	0ms
	tcl	350	0ms
	update	40	0ms
unknown	Total	175,718	1h49m13s
	copy from	16	0ms
	cte	3,901	0ms
	ddl	5	0ms
	insert	26,126	0ms
	others	4,333	0ms
	select	50,465	0ms
	tcl	504	0ms
	update	2,034	0ms

Queries by host

Key values

unknown Main host
176,669 Requests
1h49m13s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	176,669	1h49m13s
	copy from	96	0ms
	copy to	26	0ms
	cte	4,005	0ms
	ddl	21	0ms
	delete	16	0ms
	insert	26,126	0ms
	others	4,504	0ms
	select	50,613	0ms
	tcl	854	0ms
	update	2,074	0ms

Queries by application

Key values

unknown Main application
176,311 Requests
1h49m13s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
psql	Total	358	0ms
	copy from	80	0ms
	copy to	26	0ms
	cte	104	0ms
	ddl	16	0ms
	delete	16	0ms
	others	4	0ms
	select	72	0ms
	update	40	0ms
unknown	Total	176,311	1h49m13s
	copy from	16	0ms
	cte	3,901	0ms
	ddl	5	0ms
	insert	26,126	0ms
	others	4,500	0ms
	select	50,541	0ms
	tcl	854	0ms
	update	2,034	0ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-02-16 12:15:53 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

61,733 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	61,733	69.89%
1-5ms	22,466	25.43%
5-10ms	1,550	1.75%
10-25ms	580	0.66%
25-50ms	346	0.39%
50-100ms	181	0.20%
100-500ms	407	0.46%
500-1000ms	84	0.10%
1000-10000ms	824	0.93%
> 10000ms	163	0.18%

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

select o.oid as id, o.xmin as state_number, opfname as name, opfmethod as access_method_id, pg_catalog.pg_get_userbyid(o.opfowner) AS "owner" from pg_catalog.pg_opfamily o where opfnamespace = ?::oid -- and opfname in ( :[*f_names] ) and pg_catalog.age(xmin) <= coalesce(nullif(greatest(pg_catalog.age(?::varchar::xid), ?), ?), ?);

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Feb 16	12	1	0ms	0ms

2

0ms

28

Details

0ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Feb 16	12	28	0ms	0ms

3

0ms

25

Details

0ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Feb 16	12	25	0ms	0ms

4

0ms

2,002

Details

0ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 16	12	2,002	0ms	0ms

5

0ms

4

Details

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Feb 16	12	4	0ms	0ms

6

0ms

4

Details

0ms

select updaterelevantforrelevantresults ();

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Feb 16	12	4	0ms	0ms

7

0ms

1

Details

0ms

select distinct connamespace as schema_id from pg_catalog.pg_constraint f, pg_catalog.pg_class o where f.contype = ? and f.confrelid = o.oid and o.relnamespace in (...);

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Feb 16	12	1	0ms	0ms

8

0ms

2

Details

0ms

select count(*) from ( select count(a.resultuid) from autochartist_results a inner join relevance_autochartist_results ra on a.resultuid = ra.resultuid join downloadersymbolsettings dss on dss.symbolid = a.symbolid where a.patternendtime < current_timestamp - interval ? and enabled = ? union select count(a.resultuid) from fibonacci_results a inner join relevance_fibonacci_results ra on a.resultuid = ra.resultuid join downloadersymbolsettings dss on dss.symbolid = a.symbolid where a.patternendtime < current_timestamp - interval ? and enabled = ? union select count(a.resultuid) from keylevels_results a inner join relevance_keylevels_results ra on a.resultuid = ra.resultuid join downloadersymbolsettings dss on dss.symbolid = a.symbolid where a.patternendtime < current_timestamp - interval ? and enabled = ? union select count(a.resultuid) from japsticks_results a inner join relevance_japsticks_results ra on a.resultuid = ra.resultuid join downloadersymbolsettings dss on dss.symbolid = a.symbolid where a.patternendtime < current_timestamp - interval ? and enabled = ? union select count(a.resultuid) from consecutivecandles_results a inner join relevance_consecutivecandles_results ra on a.resultuid = ra.resultuid join downloadersymbolsettings dss on dss.symbolid = a.symbolid where a.patternendtime < current_timestamp - interval ? and enabled = ? union select count(a.resultuid) from bigmovement_results a inner join relevance_bigmovement_results ra on a.resultuid = ra.resultuid join downloadersymbolsettings dss on dss.symbolid = a.symbolid where a.patternendtime < current_timestamp - interval ? and enabled = ?) a where count > ?;

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Feb 16	12	2	0ms	0ms

9

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

Day	Hour	Count	Duration	Avg duration
Feb 16	12	18	0ms	0ms

10

0ms

1

Details

0ms

with system_languages as ( select oid as lang from pg_catalog.pg_language where lanname in (...)) select oid as id, pg_catalog.pg_get_function_arguments(oid) as arguments_def, pg_catalog.pg_get_function_result(oid) as result_def, null as sqlbody_def, prosrc as source_text from pg_catalog.pg_proc where pronamespace = ?::oid -- and pg_proc.proname in ( :[*f_names] ) and pg_catalog.age(xmin) <= coalesce(nullif(greatest(pg_catalog.age(?::varchar::xid), ?), ?), ?) and not (prokind = ?) and prolang not in (select lang from system_languages) and prosrc is not null;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Feb 16	12	1	0ms	0ms

11

0ms

427

Details

0ms

commit;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Feb 16	12	427	0ms	0ms

12

0ms

304

Details

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Feb 16	12	304	0ms	0ms

13

0ms

239

Details

0ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Feb 16	12	239	0ms	0ms

14

0ms

1

Details

0ms

select t.oid as object_id, t.spcacl as acl from pg_catalog.pg_tablespace t union all select t.oid as object_id, t.datacl as acl from pg_catalog.pg_database t;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Feb 16	12	1	0ms	0ms

15

0ms

239

Details

0ms

select system_identifier from pg_control_system ();

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Feb 16	12	239	0ms	0ms

16

0ms

9

Details

0ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Feb 16	12	9	0ms	0ms

17

0ms

1

Details

0ms

select p.oid as aggregate_id, p.xmin as state_number, p.proname as aggregate_name, p.proargnames as arg_names, p.proargmodes as arg_modes, p.proargtypes::int[] as in_arg_types, p.proallargtypes::int[] as all_arg_types, a.aggtransfn::oid as transition_function_id, a.aggtransfn::regproc::text as transition_function_name, a.aggtranstype as transition_type, a.aggfinalfn::oid as final_function_id, case when a.aggfinalfn::oid = ? then null else a.aggfinalfn::regproc::varchar end as final_function_name, case when a.aggfinalfn::oid = ? then ? else p.prorettype end as final_return_type, a.agginitval as initial_value, a.aggsortop as sort_operator_id, case when a.aggsortop = ? then null else a.aggsortop::regoper::varchar end as sort_operator_name, pg_catalog.pg_get_userbyid(p.proowner) AS "owner", a.aggfinalextra as final_extra, a.aggtransspace as state_size, a.aggmtransfn::oid as moving_transition_id, case when a.aggmtransfn::oid = ? then null else a.aggmtransfn::regproc::varchar end as moving_transition_name, a.aggminvtransfn::oid as inverse_transition_id, case when a.aggminvtransfn::oid = ? then null else a.aggminvtransfn::regproc::varchar end as inverse_transition_name, a.aggmtranstype::oid as moving_state_type, a.aggmtransspace as moving_state_size, a.aggmfinalfn::oid as moving_final_id, case when a.aggmfinalfn::oid = ? then null else a.aggmfinalfn::regproc::varchar end as moving_final_name, a.aggmfinalextra as moving_final_extra, a.aggminitval as moving_initial_value, a.aggkind as aggregate_kind, a.aggnumdirectargs as direct_args, a.aggcombinefn::oid as combine_function_id, case when a.aggcombinefn::oid = ? then null else a.aggcombinefn::regproc::varchar end as combine_function_name, a.aggserialfn::oid as serialization_function_id, case when a.aggserialfn::oid = ? then null else a.aggserialfn::regproc::varchar end as serialization_function_name, a.aggdeserialfn::oid as deserialization_function_id, case when a.aggdeserialfn::oid = ? then null else a.aggdeserialfn::regproc::varchar end as deserialization_function_name, p.proparallel as concurrency_kind from pg_catalog.pg_aggregate a join pg_catalog.pg_proc p on a.aggfnoid = p.oid where p.pronamespace = ?::oid -- and p.proname in ( :[*f_names] ) and (pg_catalog.age(a.xmin) <= coalesce(nullif(greatest(pg_catalog.age(?::varchar::xid), ?), ?), ?) or pg_catalog.age(p.xmin) <= coalesce(nullif(greatest(pg_catalog.age(?::varchar::xid), ?), ?), ?)) order by p.oid;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Feb 16	12	1	0ms	0ms

18

0ms

1

Details

0ms

select t.oid as object_id, t.fdwacl as acl from pg_catalog.pg_foreign_data_wrapper t union all select t.oid as object_id, t.lanacl as acl from pg_catalog.pg_language t union all select t.oid as object_id, t.nspacl as acl from pg_catalog.pg_namespace t union all select t.oid as object_id, t.srvacl as acl from pg_catalog.pg_foreign_server t;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Feb 16	12	1	0ms	0ms

19

0ms

1

Details

0ms

select pg_amop.oid from pg_catalog.pg_amop join pg_catalog.pg_opfamily on pg_opfamily.oid = amopfamily where opfnamespace = ?::oid;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Feb 16	12	1	0ms	0ms

20

0ms

1

Details

0ms

select p.oid from pg_catalog.pg_policy p join pg_catalog.pg_class c on polrelid = c.oid where relnamespace = ?::oid;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 16	12	1	0ms	0ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

18,154

Details

0ms

select ?;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Feb 16	12	18,154	0ms	0ms

2

9,385

Details

0ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Feb 16	12	9,385	0ms	0ms

3

7,609

Details

0ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Feb 16	12	7,609	0ms	0ms

4

5,509

Details

0ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 16	12	5,509	0ms	0ms

5

5,153

Details

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Feb 16	12	5,153	0ms	0ms

6

3,810

Details

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Feb 16	12	3,810	0ms	0ms

7

3,085

Details

0ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Feb 16	12	3,085	0ms	0ms

8

2,464

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

Day	Hour	Count	Duration	Avg duration
Feb 16	12	2,464	0ms	0ms

9

2,371

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

Day	Hour	Count	Duration	Avg duration
Feb 16	12	2,371	0ms	0ms

10

2,002

Details

0ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Feb 16	12	2,002	0ms	0ms

11

1,908

Details

0ms

set extra_float_digits = ?;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Feb 16	12	1,908	0ms	0ms

12

1,884

Details

0ms

set application_name = ?;

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Feb 16	12	1,884	0ms	0ms

13

1,602

Details

0ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Feb 16	12	1,602	0ms	0ms

14

1,133

Details

0ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Feb 16	12	1,133	0ms	0ms

15

1,018

Details

0ms

select case when a.old_resultuid = ? then a.old_resultuid else a.resultuid end as resultuid, s.symbol, pattern as patternname, timegranularity as interval, patternlengthbars as length, patternendtime, direction, breakout, predictiontimeto, predictionpricefrom, predictionpriceto, patternstartprice, resy1, supporty1, dtt.timezone, cps.pip, newlevels.profit from autochartist_results a inner join downloadersymbolsettings dss on a.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid inner join patterns p on p.patternname = a.pattern left join currencypips cps on cps.symbol = s.symbol left join lateral calc_cp_signal (a.resultuid) newlevels on true where (a.old_resultuid = ? or a.resultuid = ?) and dtt.dayofweek = ?;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Feb 16	12	1,018	0ms	0ms

16

956

Details

0ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Feb 16	12	956	0ms	0ms

17

747

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

Day	Hour	Count	Duration	Avg duration
Feb 16	12	747	0ms	0ms

18

597

Details

0ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Feb 16	12	597	0ms	0ms

19

486

Details

0ms

select case when a.old_resultuid = ? then a.old_resultuid else a.resultuid end as resultuid, s.symbol, a.patternprice, atbaridentified as patternendtime, breakout, p.patternname, dtt.timezone, a.direction, case when a.patternclassid = ? then a.predictionpricefrom else a.patternprice end as predictionpricefrom, case when a.patternclassid = ? then a.predictionpriceto else a.patternprice end as predictionpriceto, s.timegranularity as interval, patternlengthbars as length, 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 left join currencypips cps on cps.symbol = s.symbol where (a.old_resultuid = ? or a.resultuid = ?) and dtt.dayofweek = ?;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Feb 16	12	486	0ms	0ms

20

427

Details

0ms

commit;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 16	12	427	0ms	0ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

1

Details

0ms

select o.oid as id, o.xmin as state_number, opfname as name, opfmethod as access_method_id, pg_catalog.pg_get_userbyid(o.opfowner) AS "owner" from pg_catalog.pg_opfamily o where opfnamespace = ?::oid -- and opfname in ( :[*f_names] ) and pg_catalog.age(xmin) <= coalesce(nullif(greatest(pg_catalog.age(?::varchar::xid), ?), ?), ?);

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Feb 16	12	1	0ms	0ms

2

0ms

28

Details

0ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Feb 16	12	28	0ms	0ms

3

0ms

25

Details

0ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Feb 16	12	25	0ms	0ms

4

0ms

2,002

Details

0ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 16	12	2,002	0ms	0ms

5

0ms

4

Details

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Feb 16	12	4	0ms	0ms

6

0ms

4

Details

0ms

select updaterelevantforrelevantresults ();

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Feb 16	12	4	0ms	0ms

7

0ms

1

Details

0ms

select distinct connamespace as schema_id from pg_catalog.pg_constraint f, pg_catalog.pg_class o where f.contype = ? and f.confrelid = o.oid and o.relnamespace in (...);

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Feb 16	12	1	0ms	0ms

8

0ms

2

Details

0ms

select count(*) from ( select count(a.resultuid) from autochartist_results a inner join relevance_autochartist_results ra on a.resultuid = ra.resultuid join downloadersymbolsettings dss on dss.symbolid = a.symbolid where a.patternendtime < current_timestamp - interval ? and enabled = ? union select count(a.resultuid) from fibonacci_results a inner join relevance_fibonacci_results ra on a.resultuid = ra.resultuid join downloadersymbolsettings dss on dss.symbolid = a.symbolid where a.patternendtime < current_timestamp - interval ? and enabled = ? union select count(a.resultuid) from keylevels_results a inner join relevance_keylevels_results ra on a.resultuid = ra.resultuid join downloadersymbolsettings dss on dss.symbolid = a.symbolid where a.patternendtime < current_timestamp - interval ? and enabled = ? union select count(a.resultuid) from japsticks_results a inner join relevance_japsticks_results ra on a.resultuid = ra.resultuid join downloadersymbolsettings dss on dss.symbolid = a.symbolid where a.patternendtime < current_timestamp - interval ? and enabled = ? union select count(a.resultuid) from consecutivecandles_results a inner join relevance_consecutivecandles_results ra on a.resultuid = ra.resultuid join downloadersymbolsettings dss on dss.symbolid = a.symbolid where a.patternendtime < current_timestamp - interval ? and enabled = ? union select count(a.resultuid) from bigmovement_results a inner join relevance_bigmovement_results ra on a.resultuid = ra.resultuid join downloadersymbolsettings dss on dss.symbolid = a.symbolid where a.patternendtime < current_timestamp - interval ? and enabled = ?) a where count > ?;

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Feb 16	12	2	0ms	0ms

9

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

Day	Hour	Count	Duration	Avg duration
Feb 16	12	18	0ms	0ms

10

0ms

1

Details

0ms

with system_languages as ( select oid as lang from pg_catalog.pg_language where lanname in (...)) select oid as id, pg_catalog.pg_get_function_arguments(oid) as arguments_def, pg_catalog.pg_get_function_result(oid) as result_def, null as sqlbody_def, prosrc as source_text from pg_catalog.pg_proc where pronamespace = ?::oid -- and pg_proc.proname in ( :[*f_names] ) and pg_catalog.age(xmin) <= coalesce(nullif(greatest(pg_catalog.age(?::varchar::xid), ?), ?), ?) and not (prokind = ?) and prolang not in (select lang from system_languages) and prosrc is not null;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Feb 16	12	1	0ms	0ms

11

0ms

427

Details

0ms

commit;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Feb 16	12	427	0ms	0ms

12

0ms

304

Details

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Feb 16	12	304	0ms	0ms

13

0ms

239

Details

0ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Feb 16	12	239	0ms	0ms

14

0ms

1

Details

0ms

select t.oid as object_id, t.spcacl as acl from pg_catalog.pg_tablespace t union all select t.oid as object_id, t.datacl as acl from pg_catalog.pg_database t;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Feb 16	12	1	0ms	0ms

15

0ms

239

Details

0ms

select system_identifier from pg_control_system ();

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Feb 16	12	239	0ms	0ms

16

0ms

9

Details

0ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Feb 16	12	9	0ms	0ms

17

0ms

1

Details

0ms

select p.oid as aggregate_id, p.xmin as state_number, p.proname as aggregate_name, p.proargnames as arg_names, p.proargmodes as arg_modes, p.proargtypes::int[] as in_arg_types, p.proallargtypes::int[] as all_arg_types, a.aggtransfn::oid as transition_function_id, a.aggtransfn::regproc::text as transition_function_name, a.aggtranstype as transition_type, a.aggfinalfn::oid as final_function_id, case when a.aggfinalfn::oid = ? then null else a.aggfinalfn::regproc::varchar end as final_function_name, case when a.aggfinalfn::oid = ? then ? else p.prorettype end as final_return_type, a.agginitval as initial_value, a.aggsortop as sort_operator_id, case when a.aggsortop = ? then null else a.aggsortop::regoper::varchar end as sort_operator_name, pg_catalog.pg_get_userbyid(p.proowner) AS "owner", a.aggfinalextra as final_extra, a.aggtransspace as state_size, a.aggmtransfn::oid as moving_transition_id, case when a.aggmtransfn::oid = ? then null else a.aggmtransfn::regproc::varchar end as moving_transition_name, a.aggminvtransfn::oid as inverse_transition_id, case when a.aggminvtransfn::oid = ? then null else a.aggminvtransfn::regproc::varchar end as inverse_transition_name, a.aggmtranstype::oid as moving_state_type, a.aggmtransspace as moving_state_size, a.aggmfinalfn::oid as moving_final_id, case when a.aggmfinalfn::oid = ? then null else a.aggmfinalfn::regproc::varchar end as moving_final_name, a.aggmfinalextra as moving_final_extra, a.aggminitval as moving_initial_value, a.aggkind as aggregate_kind, a.aggnumdirectargs as direct_args, a.aggcombinefn::oid as combine_function_id, case when a.aggcombinefn::oid = ? then null else a.aggcombinefn::regproc::varchar end as combine_function_name, a.aggserialfn::oid as serialization_function_id, case when a.aggserialfn::oid = ? then null else a.aggserialfn::regproc::varchar end as serialization_function_name, a.aggdeserialfn::oid as deserialization_function_id, case when a.aggdeserialfn::oid = ? then null else a.aggdeserialfn::regproc::varchar end as deserialization_function_name, p.proparallel as concurrency_kind from pg_catalog.pg_aggregate a join pg_catalog.pg_proc p on a.aggfnoid = p.oid where p.pronamespace = ?::oid -- and p.proname in ( :[*f_names] ) and (pg_catalog.age(a.xmin) <= coalesce(nullif(greatest(pg_catalog.age(?::varchar::xid), ?), ?), ?) or pg_catalog.age(p.xmin) <= coalesce(nullif(greatest(pg_catalog.age(?::varchar::xid), ?), ?), ?)) order by p.oid;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Feb 16	12	1	0ms	0ms

18

0ms

1

Details

0ms

select t.oid as object_id, t.fdwacl as acl from pg_catalog.pg_foreign_data_wrapper t union all select t.oid as object_id, t.lanacl as acl from pg_catalog.pg_language t union all select t.oid as object_id, t.nspacl as acl from pg_catalog.pg_namespace t union all select t.oid as object_id, t.srvacl as acl from pg_catalog.pg_foreign_server t;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Feb 16	12	1	0ms	0ms

19

0ms

1

Details

0ms

select pg_amop.oid from pg_catalog.pg_amop join pg_catalog.pg_opfamily on pg_opfamily.oid = amopfamily where opfnamespace = ?::oid;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Feb 16	12	1	0ms	0ms

20

0ms

1

Details

0ms

select p.oid from pg_catalog.pg_policy p join pg_catalog.pg_class c on polrelid = c.oid where relnamespace = ?::oid;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 16	12	1	0ms	0ms

Time consuming prepare


Date: 2026-02-16 12:00:45
Duration: 20ms
Database: postgres
Date: 2026-02-16 12:31:03
Duration: 5ms
Database: postgres
Date: 2026-02-16 12:47:10
Duration: 9ms
Database: postgres
Date: 2026-02-16 12:45:56
Duration: 1ms
Database: postgres
Date: 2026-02-16 12:00:41
Duration: 4ms
Database: postgres
Date: 2026-02-16 12:40:54
Duration: 0ms
Database: postgres
Date: 2026-02-16 12:00:34
Duration: 1ms
Database: postgres
Date: 2026-02-16 12:01:10
Duration: 0ms
Database: postgres
Date: 2026-02-16 12:02:13
Duration: 0ms
Database: postgres
Date: 2026-02-16 12:51:47
Duration: 7ms
Database: postgres
Date: 2026-02-16 12:31:00
Duration: 5ms
Database: postgres
Date: 2026-02-16 12:12:02
Duration: 0ms
Database: postgres
Date: 2026-02-16 12:16:00
Duration: 11ms
Database: postgres
Date: 2026-02-16 12:01:54
Duration: 3ms
Database: postgres
Date: 2026-02-16 12:26:04
Duration: 1ms
Database: postgres
Date: 2026-02-16 12:21:54
Duration: 1ms
Database: postgres
Date: 2026-02-16 12:30:50
Duration: 1ms
Database: postgres
Date: 2026-02-16 12:48:23
Duration: 2ms
Database: postgres
Date: 2026-02-16 12:11:59
Duration: 3ms
Database: postgres
Date: 2026-02-16 12:50:04
Duration: 3ms
Database: postgres

Time consuming bind

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

32s784ms

2,977

Details

0ms

65ms

11ms

WITH rar_max as ( ;

Times Reported Time consuming bind #1

Day	Hour	Count	Duration	Avg duration
Feb 16	12	2,977	32s784ms	11ms

WITH rar_max as ( ;

Date: 2026-02-16 12:21:00 Duration: 65ms Database: postgres parameters: $1 = 't', $2 = '558', $3 = '7', $4 = '15', $5 = '30', $6 = '60', $7 = '120', $8 = '240', $9 = '480', $10 = '1440', $11 = '0', $12 = '', $13 = '80', $14 = 'AUDSGD', $15 = 'CHFSGD', $16 = 'EURDKK', $17 = 'EURHKD', $18 = 'EURNOK', $19 = 'EURPLN', $20 = 'EURSEK', $21 = 'EURSGD', $22 = 'EURTRY', $23 = 'EURZAR', $24 = 'GBPDKK', $25 = 'GBPNOK', $26 = 'GBPSEK', $27 = 'GBPSGD', $28 = 'NOKJPY', $29 = 'NOKSEK', $30 = 'SEKJPY', $31 = 'SGDJPY', $32 = 'USDCNH', $33 = 'USDCZK', $34 = 'USDDKK', $35 = 'USDHKD', $36 = 'USDHUF', $37 = 'USDMXN', $38 = 'USDNOK', $39 = 'USDPLN', $40 = 'USDRUB', $41 = 'USDSEK', $42 = 'USDTHB', $43 = 'USDTRY', $44 = 'USDZAR', $45 = 'AUDUSD', $46 = 'EURUSD', $47 = 'GBPUSD', $48 = 'USDCAD', $49 = 'USDCHF', $50 = 'USDJPY', $51 = 'AUDCAD', $52 = 'AUDCHF', $53 = 'AUDJPY', $54 = 'AUDNZD', $55 = 'CADCHF', $56 = 'CADJPY', $57 = 'CHFJPY', $58 = 'EURAUD', $59 = 'EURCAD', $60 = 'EURCHF', $61 = 'EURGBP', $62 = 'EURJPY', $63 = 'EURNZD', $64 = 'GBPAUD', $65 = 'GBPCAD', $66 = 'GBPCHF', $67 = 'GBPJPY', $68 = 'GBPNZD', $69 = 'NZDCAD', $70 = 'NZDCHF', $71 = 'NZDJPY', $72 = 'NZDUSD', $73 = 'USDSGD', $74 = 'AUS200', $75 = 'DE30', $76 = 'ES35', $77 = 'F40', $78 = 'HK50', $79 = 'IT40', $80 = 'JP225', $81 = 'STOXX50', $82 = 'UK100', $83 = 'US2000', $84 = 'US30', $85 = 'US500', $86 = 'CHINA50', $87 = 'USTEC', $88 = 'XAGEUR', $89 = 'XAGUSD', $90 = 'XAUUSD', $91 = 'XAUEUR', $92 = 'XPDUSD', $93 = 'XPTUSD', $94 = '0', $95 = '', $96 = '0', $97 = '0', $98 = '0', $99 = '0', $100 = '0', $101 = 't', $102 = '10', $103 = '10'
WITH rar_max as ( ;

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

Date: 2026-02-16 12:21:00 Duration: 58ms Database: postgres parameters: $1 = 't', $2 = '489', $3 = '0', $4 = '0', $5 = '0', $6 = '', $7 = '0', $8 = '', $9 = '0', $10 = '', $11 = '0', $12 = '0', $13 = '0', $14 = '0', $15 = '0', $16 = 't', $17 = '0', $18 = '0'

2

7s534ms

21,107

Details

0ms

20ms

0ms

SELECT ;

Times Reported Time consuming bind #2

Day	Hour	Count	Duration	Avg duration
	12	21,107	7s534ms	0ms

SELECT ;

Date: 2026-02-16 12:46:05 Duration: 20ms Database: postgres parameters: $1 = '667', $2 = '667', $3 = '500991628245542200'
SELECT ;

Date: 2026-02-16 12:01:04 Duration: 20ms Database: postgres parameters: $1 = '607673418973242302', $2 = '607673418973242302', $3 = '607673418973242302'
SELECT ;

Date: 2026-02-16 12:45:42 Duration: 19ms Database: postgres parameters: $1 = '667', $2 = '667', $3 = '500991628257264200'

3

3s9ms

1,166

Details

1ms

9ms

2ms

SELECT symbolid, ;

Times Reported Time consuming bind #3

Day	Hour	Count	Duration	Avg duration
	12	1,166	3s9ms	2ms

SELECT symbolid, ;

Date: 2026-02-16 12:16:00 Duration: 9ms Database: postgres parameters: $1 = 'ATFX', $2 = '15', $3 = '#BMW'
SELECT symbolid, ;

Date: 2026-02-16 12:15:57 Duration: 8ms Database: postgres parameters: $1 = 'GLOBALGTMT5', $2 = '15', $3 = 'EURAUD'
SELECT symbolid, ;

Date: 2026-02-16 12:45:51 Duration: 5ms Database: postgres parameters: $1 = 'DXFEED_FX', $2 = '15', $3 = 'AUD/JPY', $4 = 'GBP/AUD', $5 = 'AUD/USD', $6 = 'EUR/JPY', $7 = 'EUR/CHF', $8 = 'AUD/CHF', $9 = 'EUR/NZD', $10 = 'CAD/CHF', $11 = 'CHF/JPY', $12 = 'EUR/GBP'

4

679ms

396

Details

1ms

3ms

1ms

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

Times Reported Time consuming bind #4

Day	Hour	Count	Duration	Avg duration
	12	396	679ms	1ms

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

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

Date: 2026-02-16 12:00:57 Duration: 2ms Database: postgres parameters: $1 = 'Alpari'
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;

Date: 2026-02-16 12:31:05 Duration: 2ms Database: postgres parameters: $1 = 'ATFX'

5

655ms

16

Details

28ms

47ms

40ms

with sym_info as ( ;

Times Reported Time consuming bind #5

Day	Hour	Count	Duration	Avg duration
	12	16	655ms	40ms

with sym_info as ( ;

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

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

Date: 2026-02-16 12:06:46 Duration: 44ms Database: postgres parameters: $1 = '617', $2 = 'Forex', $3 = 'Forex', $4 = '617', $5 = 'Forex', $6 = '617', $7 = '617', $8 = 'Forex', $9 = '617'

6

641ms

25

Details

0ms

44ms

25ms

with wh_patitioned as ( ;

Times Reported Time consuming bind #6

Day	Hour	Count	Duration	Avg duration
	12	25	641ms	25ms

with wh_patitioned as ( ;

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

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

Date: 2026-02-16 12:20:59 Duration: 38ms Database: postgres parameters: $1 = '621', $2 = '621', $3 = '621', $4 = '621', $5 = '621', $6 = '621', $7 = '621', $8 = '621', $9 = '621'

7

510ms

18,047

Details

0ms

13ms

0ms

select 1;

Times Reported Time consuming bind #7

Day	Hour	Count	Duration	Avg duration
	12	18,047	510ms	0ms

select 1;

Date: 2026-02-16 12:21:07 Duration: 13ms Database: postgres
select 1;

Date: 2026-02-16 12:21:00 Duration: 12ms Database: postgres
select 1;

Date: 2026-02-16 12:20:58 Duration: 9ms Database: postgres

8

499ms

44

Details

0ms

26ms

11ms

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

Times Reported Time consuming bind #8

Day	Hour	Count	Duration	Avg duration
	12	44	499ms	11ms

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

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

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

Date: 2026-02-16 12:37:21 Duration: 20ms Database: postgres parameters: $1 = '667', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'

9

463ms

60

Details

4ms

23ms

7ms

WITH last_candle AS ( ;

Times Reported Time consuming bind #9

Day	Hour	Count	Duration	Avg duration
	12	60	463ms	7ms

WITH last_candle AS ( ;

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

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

Date: 2026-02-16 12:36:03 Duration: 14ms Database: postgres parameters: $1 = '538', $2 = '538'

10

244ms

5,509

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
	12	5,509	244ms	0ms

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

Date: 2026-02-16 12:01:10 Duration: 0ms Database: postgres parameters: $1 = '2026-02-16 11:30:00', $2 = '62.825', $3 = '62.825', $4 = '62.665', $5 = '62.695', $6 = '212', $7 = '515840230545597300', $8 = '0', $9 = '2026-02-16 12:01:10.864', $10 = '2026-02-16 12:01:10.672', $11 = '62.825', $12 = '62.825', $13 = '62.665', $14 = '62.695', $15 = '212', $16 = '0', $17 = '2026-02-16 12:01:10.864', $18 = '2026-02-16 12:01:10.672'
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-16 12:26:24 Duration: 0ms Database: postgres parameters: $1 = '2026-02-16 12:00:00', $2 = '24820.42', $3 = '24825.05', $4 = '24803.67', $5 = '24810.92', $6 = '3446', $7 = '515840248038958300', $8 = '0', $9 = '2026-02-16 12:26:24.898', $10 = '2026-02-16 12:26:24.828', $11 = '24820.42', $12 = '24825.05', $13 = '24803.67', $14 = '24810.92', $15 = '3446', $16 = '0', $17 = '2026-02-16 12:26:24.898', $18 = '2026-02-16 12:26:24.828'
INSERT INTO T15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-16 12:47:06 Duration: 0ms Database: postgres parameters: $1 = '2025-11-22 00:00:00', $2 = '21.535', $3 = '21.585', $4 = '21.455', $5 = '21.485', $6 = '104', $7 = '515840249466545300', $8 = '0', $9 = '2026-02-16 12:47:06.929', $10 = '2026-02-16 12:47:06.881', $11 = '21.535', $12 = '21.585', $13 = '21.455', $14 = '21.485', $15 = '104', $16 = '0', $17 = '2026-02-16 12:47:06.929', $18 = '2026-02-16 12:47:06.881'

11

236ms

3,085

Details

0ms

1ms

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
	12	3,085	236ms	0ms

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

Date: 2026-02-16 12:31:03 Duration: 1ms Database: postgres parameters: $1 = '2026-02-16 12:00:00', $2 = '30.09', $3 = '30.15', $4 = '30', $5 = '30.12', $6 = '554', $7 = '515840246009529300', $8 = '0', $9 = '2026-02-16 12:31:03.324', $10 = '2026-02-16 12:31:03.324', $11 = '30.09', $12 = '30.15', $13 = '30', $14 = '30.12', $15 = '554', $16 = '0', $17 = '2026-02-16 12:31:03.324', $18 = '2026-02-16 12:31:03.324'
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-16 12:00:59 Duration: 0ms Database: postgres parameters: $1 = '2026-02-16 11:30:00', $2 = '1.67291', $3 = '1.67509', $4 = '1.67291', $5 = '1.67474', $6 = '2244', $7 = '515840247941825300', $8 = '0', $9 = '2026-02-16 12:00:59.238', $10 = '2026-02-16 12:00:58.995', $11 = '1.67291', $12 = '1.67509', $13 = '1.67291', $14 = '1.67474', $15 = '2244', $16 = '0', $17 = '2026-02-16 12:00:59.238', $18 = '2026-02-16 12:00:58.995'
INSERT INTO T30 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-16 12:40:54 Duration: 0ms Database: postgres parameters: $1 = '2026-02-16 11:30:00', $2 = '8967.4', $3 = '8967.9', $4 = '8961.4', $5 = '8961.75', $6 = '1552', $7 = '515840248015340300', $8 = '0', $9 = '2026-02-16 12:40:54.331', $10 = '2026-02-16 12:40:54.245', $11 = '8967.4', $12 = '8967.9', $13 = '8961.4', $14 = '8961.75', $15 = '1552', $16 = '0', $17 = '2026-02-16 12:40:54.331', $18 = '2026-02-16 12:40:54.245'

12

212ms

341

Details

0ms

1ms

0ms

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

Times Reported Time consuming bind #12

Day	Hour	Count	Duration	Avg duration
	12	341	212ms	0ms

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

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

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

Date: 2026-02-16 12:12:02 Duration: 1ms Database: postgres

13

161ms

2,002

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

Day	Hour	Count	Duration	Avg duration
	12	2,002	161ms	0ms

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

Date: 2026-02-16 12:00:58 Duration: 0ms Database: postgres parameters: $1 = '2026-02-16 11:00:00', $2 = '1.173385', $3 = '1.17342', $4 = '1.17248', $5 = '1.17276', $6 = '4069', $7 = '515840230433482300', $8 = '0', $9 = '2026-02-16 12:00:58.495', $10 = '2026-02-16 12:00:58.481', $11 = '1.173385', $12 = '1.17342', $13 = '1.17248', $14 = '1.17276', $15 = '4069', $16 = '0', $17 = '2026-02-16 12:00:58.495', $18 = '2026-02-16 12:00:58.481'
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-16 12:11:25 Duration: 0ms Database: postgres parameters: $1 = '2026-02-16 11:00:00', $2 = '24825.92', $3 = '24846.3', $4 = '24817.17', $5 = '24820.8', $6 = '11728', $7 = '515840248039327300', $8 = '0', $9 = '2026-02-16 12:11:25.59', $10 = '2026-02-16 12:11:25.453', $11 = '24825.92', $12 = '24846.3', $13 = '24817.17', $14 = '24820.8', $15 = '11728', $16 = '0', $17 = '2026-02-16 12:11:25.59', $18 = '2026-02-16 12:11:25.453'
INSERT INTO T60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-16 12:11:56 Duration: 0ms Database: postgres parameters: $1 = '2026-02-16 11:00:00', $2 = '8966.4', $3 = '8971.9', $4 = '8961.4', $5 = '8961.75', $6 = '3253', $7 = '515840248015562300', $8 = '0', $9 = '2026-02-16 12:11:56.023', $10 = '2026-02-16 12:11:55.924', $11 = '8966.4', $12 = '8971.9', $13 = '8961.4', $14 = '8961.75', $15 = '3253', $16 = '0', $17 = '2026-02-16 12:11:56.023', $18 = '2026-02-16 12:11:55.924'

14

133ms

21

Details

0ms

21ms

6ms

select distinct s.statsid as statsid, sy.exchange as name;

Times Reported Time consuming bind #14

Day	Hour	Count	Duration	Avg duration
	12	21	133ms	6ms

select distinct s.statsid as statsid, sy.exchange as name;

Date: 2026-02-16 12:05:35 Duration: 21ms Database: postgres parameters: $1 = '1436', $2 = '1436'
select distinct s.statsid as statsid, sy.exchange as name;

Date: 2026-02-16 12:06:50 Duration: 18ms Database: postgres parameters: $1 = '1471', $2 = '1471'
select distinct s.statsid as statsid, sy.exchange as name;

Date: 2026-02-16 12:22:53 Duration: 13ms Database: postgres parameters: $1 = '619', $2 = '619'

15

131ms

1

Details

131ms

select * from ourfavourites_findlatest where "brokerid" = 621 LIMIT 1000 OFFSET 0;

Times Reported Time consuming bind #15

Day	Hour	Count	Duration	Avg duration
	12	1	131ms	131ms

select * from ourfavourites_findlatest where "brokerid" = 621 LIMIT 1000 OFFSET 0;

Date: 2026-02-16 12:15:43 Duration: 131ms Database: postgres

16

111ms

1,133

Details

0ms

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

Times Reported Time consuming bind #16

Day	Hour	Count	Duration	Avg duration
	12	1,133	111ms	0ms

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

Date: 2026-02-16 12:16:36 Duration: 0ms Database: postgres parameters: $1 = '2026-02-16 08:00:00', $2 = '6843.8', $3 = '6869.1', $4 = '6841.4', $5 = '6863.8', $6 = '12739', $7 = '515840245924751300', $8 = '0', $9 = '2026-02-16 12:16:36.388', $10 = '2026-02-16 12:16:36.387', $11 = '6843.8', $12 = '6869.1', $13 = '6841.4', $14 = '6863.8', $15 = '12739', $16 = '0', $17 = '2026-02-16 12:16:36.388', $18 = '2026-02-16 12:16:36.387'
INSERT INTO T240 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-16 12:00:32 Duration: 0ms Database: postgres parameters: $1 = '2026-02-16 08:00:00', $2 = '0.965015', $3 = '0.96559', $4 = '0.964275', $5 = '0.96465', $6 = '11720', $7 = '515840230419678300', $8 = '0', $9 = '2026-02-16 12:00:32.59', $10 = '2026-02-16 12:00:32.588', $11 = '0.965015', $12 = '0.96559', $13 = '0.964275', $14 = '0.96465', $15 = '11720', $16 = '0', $17 = '2026-02-16 12:00:32.59', $18 = '2026-02-16 12:00:32.588'
INSERT INTO T240 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) ON CONFLICT (pricedatetime, symbolid) DO UPDATE SET open = $11, high = $12, low = $13, close = $14, volume = $15, bsf = $16, sastdatetimewritten = $17, sastdatetimereceived = $18;

Date: 2026-02-16 12:00:58 Duration: 0ms Database: postgres parameters: $1 = '2026-02-16 08:00:00', $2 = '1.17423', $3 = '1.17425', $4 = '1.17248', $5 = '1.17276', $6 = '13094', $7 = '515840230433883300', $8 = '0', $9 = '2026-02-16 12:00:58.488', $10 = '2026-02-16 12:00:58.488', $11 = '1.17423', $12 = '1.17425', $13 = '1.17248', $14 = '1.17276', $15 = '13094', $16 = '0', $17 = '2026-02-16 12:00:58.488', $18 = '2026-02-16 12:00:58.488'

17

86ms

703

Details

0ms

1ms

0ms

select category, ;

Times Reported Time consuming bind #17

Day	Hour	Count	Duration	Avg duration
	12	703	86ms	0ms

select category, ;

Date: 2026-02-16 12:22:59 Duration: 1ms Database: postgres parameters: $1 = '515852059324253307', $2 = 'symbol', $3 = 'USDMXN', $4 = 'CHFZAR', $5 = 'AUDJPY', $6 = 'CHFJPY', $7 = 'USDZAR', $8 = 'USDJPY', $9 = 'CADJPY', $10 = 'ZARJPY', $11 = 'EURCNH', $12 = 'GBPZAR', $13 = 'NZDJPY', $14 = 'TRYJPY', $15 = 'USDHUF', $16 = 'AUDZAR', $17 = 'EURMXN', $18 = 'GBPJPY', $19 = 'EURZAR', $20 = 'EURNOK', $21 = 'USDNOK', $22 = 'SGDJPY', $23 = 'USDCZK', $24 = 'EURHKD', $25 = 'EURSEK', $26 = 'CHFHUF', $27 = 'USDDKK', $28 = 'USDSEK', $29 = 'NZDSEK', $30 = 'EURTRY', $31 = 'EURJPY', $32 = 'EURHUF', $33 = 'USDPLN', $34 = 'GBPNZD', $35 = 'USDCNH', $36 = 'EURCZK', $37 = 'USDILS', $38 = 'EURPLN', $39 = 'GBPAUD', $40 = 'EURGBP', $41 = 'TRYJPY', $42 = 'EURNZD', $43 = 'EURCZK', $44 = 'EURAUD', $45 = 'ZARJPY', $46 = 'CHFHUF', $47 = 'EURHUF', $48 = 'USDCAD', $49 = 'GBPCAD', $50 = 'EURDKK', $51 = 'USDZAR', $52 = 'EURCHF', $53 = '515852059324253307', $54 = 'symbol', $55 = 'USDMXN', $56 = 'CHFZAR', $57 = 'AUDJPY', $58 = 'CHFJPY', $59 = 'USDZAR', $60 = 'USDJPY', $61 = 'CADJPY', $62 = 'ZARJPY', $63 = 'EURCNH', $64 = 'GBPZAR', $65 = 'NZDJPY', $66 = 'TRYJPY', $67 = 'USDHUF', $68 = 'AUDZAR', $69 = 'EURMXN', $70 = 'GBPJPY', $71 = 'EURZAR', $72 = 'EURNOK', $73 = 'USDNOK', $74 = 'SGDJPY', $75 = 'USDCZK', $76 = 'EURHKD', $77 = 'EURSEK', $78 = 'CHFHUF', $79 = 'USDDKK', $80 = 'USDSEK', $81 = 'NZDSEK', $82 = 'EURTRY', $83 = 'EURJPY', $84 = 'EURHUF', $85 = 'USDPLN', $86 = 'GBPNZD', $87 = 'USDCNH', $88 = 'EURCZK', $89 = 'USDILS', $90 = 'EURPLN', $91 = 'GBPAUD', $92 = 'EURGBP', $93 = 'TRYJPY', $94 = 'EURNZD', $95 = 'EURCZK', $96 = 'EURAUD', $97 = 'ZARJPY', $98 = 'CHFHUF', $99 = 'EURHUF', $100 = 'USDCAD', $101 = 'GBPCAD', $102 = 'EURDKK', $103 = 'USDZAR', $104 = 'EURCHF'
select category, ;

Date: 2026-02-16 12:25:03 Duration: 0ms Database: postgres parameters: $1 = '515852059296080307', $2 = 'symbol', $3 = 'AUDJPY', $4 = 'NZDJPY', $5 = 'USDMXN', $6 = 'EURMXN', $7 = 'USDJPY', $8 = 'USDNOK', $9 = 'NOKJPY', $10 = 'GBPJPY', $11 = 'CADJPY', $12 = 'ZARJPY', $13 = 'USDZAR', $14 = 'CHFJPY', $15 = 'HKDJPY', $16 = 'EURNOK', $17 = 'GBPZAR', $18 = 'EURSEK', $19 = 'USDDKK', $20 = 'USDSEK', $21 = 'USDPLN', $22 = 'EURTRY', $23 = 'EURJPY', $24 = 'GBPAUD', $25 = 'USDCNH', $26 = 'GBPNZD', $27 = 'ZARJPY', $28 = 'EURPLN', $29 = 'EURAUD', $30 = 'EURNZD', $31 = 'EURGBP', $32 = 'GBPCAD', $33 = 'USDZAR', $34 = 'EURNOK', $35 = 'EURSEK', $36 = 'USDCAD', $37 = 'EURCAD', $38 = 'EURCHF', $39 = 'NOKJPY', $40 = 'USDMXN', $41 = 'GBPZAR', $42 = 'CADJPY', $43 = 'EURMXN', $44 = 'GBPUSD', $45 = 'HKDJPY', $46 = 'CADCHF', $47 = 'USDSEK', $48 = 'USDSGD', $49 = 'USDPLN', $50 = 'EURNZD', $51 = 'EURPLN', $52 = 'EURCAD', $53 = '515852059296080307', $54 = 'symbol', $55 = 'AUDJPY', $56 = 'NZDJPY', $57 = 'USDMXN', $58 = 'EURMXN', $59 = 'USDJPY', $60 = 'USDNOK', $61 = 'NOKJPY', $62 = 'GBPJPY', $63 = 'CADJPY', $64 = 'ZARJPY', $65 = 'USDZAR', $66 = 'CHFJPY', $67 = 'HKDJPY', $68 = 'EURNOK', $69 = 'GBPZAR', $70 = 'EURSEK', $71 = 'USDDKK', $72 = 'USDSEK', $73 = 'USDPLN', $74 = 'EURTRY', $75 = 'EURJPY', $76 = 'GBPAUD', $77 = 'USDCNH', $78 = 'GBPNZD', $79 = 'ZARJPY', $80 = 'EURPLN', $81 = 'EURAUD', $82 = 'EURNZD', $83 = 'EURGBP', $84 = 'GBPCAD', $85 = 'USDZAR', $86 = 'EURNOK', $87 = 'EURSEK', $88 = 'USDCAD', $89 = 'EURCAD', $90 = 'EURCHF', $91 = 'NOKJPY', $92 = 'USDMXN', $93 = 'GBPZAR', $94 = 'CADJPY', $95 = 'EURMXN', $96 = 'GBPUSD', $97 = 'HKDJPY', $98 = 'CADCHF', $99 = 'USDSEK', $100 = 'USDSGD', $101 = 'USDPLN', $102 = 'EURNZD', $103 = 'EURPLN', $104 = 'EURCAD'
select category, ;

Date: 2026-02-16 12:26:17 Duration: 0ms Database: postgres parameters: $1 = '601729875362372307', $2 = 'symbol', $3 = 'USA30', $4 = 'JPN225', $5 = 'UK100', $6 = 'USA100', $7 = 'AUS200', $8 = 'USDIndex', $9 = 'FRA40', $10 = 'NETH25', $11 = 'SUI20', $12 = 'UK100', $13 = 'USDIndex', $14 = 'USA30', $15 = 'JPN225', $16 = 'AUS200', $17 = 'USA100', $18 = 'SPA35', $19 = 'SUI20', $20 = 'FRA40', $21 = 'SPA35', $22 = 'NETH25', $23 = '601729875362372307', $24 = 'symbol', $25 = 'USA30', $26 = 'JPN225', $27 = 'UK100', $28 = 'USA100', $29 = 'AUS200', $30 = 'USDIndex', $31 = 'FRA40', $32 = 'NETH25', $33 = 'SUI20', $34 = 'UK100', $35 = 'USDIndex', $36 = 'USA30', $37 = 'JPN225', $38 = 'AUS200', $39 = 'USA100', $40 = 'SPA35', $41 = 'SUI20', $42 = 'FRA40', $43 = 'SPA35', $44 = 'NETH25'

18

59ms

54

Details

0ms

7ms

1ms

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

Times Reported Time consuming bind #18

Day	Hour	Count	Duration	Avg duration
	12	54	59ms	1ms

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

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

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

Date: 2026-02-16 12:35:17 Duration: 1ms Database: postgres parameters: $1 = '558', $2 = 'XAUUSD.a', $3 = '558'

19

54ms

8

Details

4ms

11ms

6ms

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

Times Reported Time consuming bind #19

Day	Hour	Count	Duration	Avg duration
	12	8	54ms	6ms

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

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

Date: 2026-02-16 12:11:59 Duration: 9ms 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'

20

52ms

296

Details

0ms

4ms

0ms

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

Times Reported Time consuming bind #20

Day	Hour	Count	Duration	Avg duration
	12	296	52ms	0ms

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

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

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

Date: 2026-02-16 12:20:21 Duration: 2ms Database: postgres parameters: $1 = '607688517034953301'

Log levels

Key values

351,476 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	636	0.18%
DETAIL	81,034	23.06%
ERROR	1	0.00%
LOG	269,027	76.54%
STATEMENT	778	0.22%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
1 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

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

Rank

Times reported

Error

1

Details

ERROR: role "..." does not exist

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Feb 16	12	1

ERROR: role "readaccess_options" does not exist

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

Pages removed per tables

Autovacuum Activity

Locks

Locks by types

Key values

Type of locks

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values

Queries by user

Key values