pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sat Mar 14 22:59:17 2026
Log file: /home/postgres/pg_data/data/pg_log/postgresql-2026-03-15_000000.log
Parsed 440,572 log entries in 16s
Log start from 2026-03-15 00:00:00 to 2026-03-15 00:59:15

Global Stats

164 Number of unique normalized queries
75,677 Number of queries
1h17m48s Total query duration
2026-03-15 00:00:00 First query
2026-03-15 00:59:15 Last query
733 queries/s at 2026-03-15 00:30:04 Query peak

1h17m48s Total query duration
2s330ms Prepare/parse total duration
13s822ms Bind total duration
1h17m31s Execute total duration

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

10 Total number of automatic vacuums
19 Total number of automatic analyzes

1,059 Number temporary file
618.59 MiB Max size of temporary file
137.77 MiB Average size of temporary file

1,586 Total number of sessions
12 sessions at 2026-03-15 00:56:12 Session peak
13h9m52s Total duration of sessions
29s881ms Average duration of sessions
47 Average queries per session
2s943ms Average queries duration per session
26s938ms Average idle time per session

1,586 Total number of connections
29 connections/s at 2026-03-15 00:08:50 Connection peak
3 Total number of databases

SQL Traffic

Key values

733 queries/s Query Peak
2026-03-15 00:30:04 Date

SELECT Traffic

Key values

365 queries/s Query Peak
2026-03-15 00:30:04 Date

INSERT/UPDATE/DELETE Traffic

Key values

110 queries/s Query Peak
2026-03-15 00:08:50 Date

Queries duration

Key values

1h17m48s 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)
Mar 15	00	75,677	0ms	24s809ms	61ms	2m20s	2m30s	2m49s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Mar 15	00	18,999	0	0ms	0ms	0ms	0ms

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Mar 15	00	13,275	922	0	0	0ms	0ms	0ms	0ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Mar 15	00	9,310	19,306	2.07	26.10%

Day	Hour	Count	Average / Second
Mar 15	00	1,586	0.44/s

Day	Hour	Count	Average Duration	Average idle time
Mar 15	00	1,586	29s881ms	26s948ms

↑ Back to the top of the General Activity table

Established Connections

Key values

29 connections Connection Peak
2026-03-15 00:08:50 Date

Connections per database

Key values

acaweb_fx Main Database
1,586 connections Total

Chart
Table

Database	User	Count
acaweb_fx		1,404
	postgres	1,368
	psql	36
socialmedia		182
	postgres	182

Connections per user

Key values

postgres Main User
1,586 connections Total

Chart
Table

User	Count
postgres	1,550
psql	36

Connections per host

Key values

192.168.4.142 Main host with 728 connections
1,586 Total connections

Chart
Table

Host	Count
192.168.0.114	2
192.168.0.216	118
192.168.0.74	7
192.168.1.145	1
192.168.1.15	20
192.168.1.20	21
192.168.1.239	56
192.168.1.90	28
192.168.2.126	18
192.168.3.199	39
192.168.4.142	728
192.168.4.33	182
192.168.4.98	330
[local]	36

Simultaneous sessions

Key values

12 sessions Session Peak
2026-03-15 00:56:12 Date

Histogram of session times

Key values

1,254 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	1,254	79.07%
500ms-1s	107	6.75%
1s-30s	191	12.04%
30s-1m	9	0.57%
1m-10m	2	0.13%
10m-30m	21	1.32%
30m-1h	1	0.06%
1h-8h	1	0.06%
> 8h	0	0.00%

Sessions per database

Key values

acaweb_fx Main Database
1,586 sessions Total

Chart
Table

Database	User	Count	Total Duration	Average Duration
acaweb_fx	1,404	13h7m8s	33s638ms
socialmedia	182	2m43s	897ms

Sessions per user

Key values

postgres Main User
1,586 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
1,586 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
192.168.0.114	2	10m	5m
192.168.0.216	118	7m27s	3s792ms
192.168.0.74	7	53m21s	7m37s
192.168.1.145	1	87ms	87ms
192.168.1.15	20	1h53m24s	5m40s
192.168.1.20	21	9h52m18s	28m12s
192.168.1.239	56	343ms	6ms
192.168.1.90	28	492ms	17ms
192.168.2.126	18	5s659ms	314ms
192.168.3.199	39	32s535ms	834ms
192.168.4.142	728	8m31s	702ms
192.168.4.33	182	2m43s	897ms
192.168.4.98	330	13s56ms	39ms
[local]	36	1m13s	2s47ms

Sessions per application

Key values

unknown Main Host
1,586 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
unknown	1,586	13h9m52s	29s881ms

Checkpoints Buffers

Key values

2,207 buffers Checkpoint Peak
2026-03-15 00:37:36 Date
210.009 seconds Highest write time
1.209 seconds Sync time

Checkpoints Wal files

Key values

1 files Wal files usage Peak
2026-03-15 00:51:40 Date

Checkpoints distance

Key values

25.02 Mo Distance Peak
2026-03-15 00:37:36 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Mar 15	00	12,050	1,188.103s	1.791s	1,191.187s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Mar 15	00	0	0	5	1,220	1.209s	0.022s

Day	Hour	Count	Avg time (sec)
Mar 15	00	0	0s

Day	Hour	Mean distance	Mean estimate
Mar 15	00	7,577.36 kB	11,455.36 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

625.53 MiB Temp Files size Peak
2026-03-15 00:16:43 Date

Number of temporary files

Key values

6 per second Temp Files Peak
2026-03-15 00:16:43 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Mar 15	00	1,059	142.48 GiB	137.77 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	237	142.19 GiB	363.13 MiB	618.59 MiB	614.34 MiB	classname, case when latestdbwritetime < current_timestamp - interval ? then ? else ? end as is_stale from latest_t15_candle_view order by classname; classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname; Date: 2026-03-15 00:00:14 Duration: 0ms
2	78	138.10 MiB	137.65 KiB	4.02 MiB	1.77 MiB	with rar_max as ( select resultuid from relevance_autochartist_results order by resultuid desc limit ? ), ar as ( select a., rr.age, rr.relevant from autochartist_results a left outer join relevance_autochartist_results rr on a.resultuid = rr.resultuid where case when false = ? then true else a.resultuid > ( select min(resultuid) from relevance_autochartist_results) end ), all_results as ( select ar.resultuid as resultuid, ar.direction as direction, ar.predictiontimeto as predictiontimeto, ar.predictionpricefrom as predictionpricefrom, ar.predictionpriceto as predictionpriceto, cp.pip as pip, 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, ar.pattern as pattern_name, ar.breakout as breakout, ar.patternendtime as identified, dtt.timezone as timezone, ar.patternlengthbars as length, g.basegroupname, newlevels.profit, newlevels.stop, newlevels.filtered, case when ar.age is not null then ar.age when ar.resultuid <= rm.resultuid then ? else ? end as age, case when ar.relevant is not null then ar.relevant when ar.resultuid <= rm.resultuid then ? else ? end as relevant from ar inner join symbols s on ar.symbolid = s.symbolid and s.nonliquid = ? inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = s.symbolid inner join symbolgroup sg on bsl.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 sg.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 currencypips cp on s.symbol = cp.symbol left join lateral calc_cp_signal (ar.resultuid) newlevels on true left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where ar.gmttimefound > now() - interval ? and dss.enabled = ? and s.deleted = ? and (ar.simulation = ? or ar.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ar.pattern in (...)) and (? = ? or (? = ? and ar.breakout >= ?) or (? = ? and ar.breakout < ?)) and (? = ? or ar.patternlengthbars <= ?) and newlevels.filtered = false and ar.patternstarttime >= 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 ; WITH rar_max as ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1 ), ar AS ( SELECT a., rr.age, rr.relevant from autochartist_results a LEFT OUTER JOIN relevance_autochartist_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_autochartist_results) END ), all_results AS ( SELECT ar.resultuid AS resultuid, ar.direction AS direction, ar.predictiontimeto AS predictiontimeto, ar.predictionpricefrom AS predictionpricefrom, ar.predictionpriceto AS predictionpriceto, cp.pip AS pip, 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, ar.pattern AS pattern_name, ar.breakout AS breakout, ar.patternendtime AS identified, dtt.timezone AS timezone, ar.patternlengthbars AS length, g.basegroupname, newLevels.profit, newLevels.stop, newLevels.filtered, CASE WHEN ar.age IS NOT NULL THEN ar.age WHEN ar.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN ar.relevant IS NOT NULL THEN ar.relevant WHEN ar.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM ar INNER JOIN symbols s ON ar.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = s.symbolid INNER JOIN symbolgroup sg on bsl.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 sg.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 OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN currencypips cp ON s.symbol = cp.symbol LEFT JOIN LATERAL calc_cp_signal (ar.resultuid) newLevels on true LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE ar.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (ar.simulation = 0 OR ar.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 ar.pattern in ($325)) AND ($326 = 0 OR ($327 = 1 AND ar.breakout >= 0) OR ($328 = 2 AND ar.breakout < 0)) AND ($329 = 0 OR ar.patternlengthbars <= $330) and newLevels.filtered = false AND ar.patternstarttime >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), 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-03-15 00:00:52 Duration: 0ms
3	29	145.70 MiB	4.92 MiB	5.52 MiB	5.02 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-03-15 00:01:07 Duration: 0ms
4	5	19.10 MiB	3.82 MiB	3.82 MiB	3.82 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-03-15 00:01:28 Duration: 0ms

Queries generating the largest temporary files

Rank	Size	Query
1	618.59 MiB	classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname; [ Date: 2026-03-15 00:00:14 ]
2	618.59 MiB	classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname; [ Date: 2026-03-15 00:00:28 ]
3	618.59 MiB	classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname; [ Date: 2026-03-15 00:00:43 ]
4	618.59 MiB	classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname; [ Date: 2026-03-15 00:00:59 ]
5	618.59 MiB	classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname; [ Date: 2026-03-15 00:01:14 ]
6	618.59 MiB	classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname; [ Date: 2026-03-15 00:01:28 ]
7	618.59 MiB	classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname; [ Date: 2026-03-15 00:01:43 ]
8	618.59 MiB	classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname; [ Date: 2026-03-15 00:02:29 ]
9	618.59 MiB	classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname; [ Date: 2026-03-15 00:02:43 ]
10	618.59 MiB	classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname; [ Date: 2026-03-15 00:02:58 ]
11	618.59 MiB	classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname; [ Date: 2026-03-15 00:03:12 ]
12	618.59 MiB	classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname; [ Date: 2026-03-15 00:03:28 ]
13	618.59 MiB	classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname; [ Date: 2026-03-15 00:03:43 ]
14	618.59 MiB	classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname; [ Date: 2026-03-15 00:03:58 ]
15	618.59 MiB	classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname; [ Date: 2026-03-15 00:04:12 ]
16	618.59 MiB	classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname; [ Date: 2026-03-15 00:04:27 ]
17	618.59 MiB	classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname; [ Date: 2026-03-15 00:04:42 ]
18	618.59 MiB	classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname; [ Date: 2026-03-15 00:04:57 ]
19	618.59 MiB	classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname; [ Date: 2026-03-15 00:05:12 ]
20	618.59 MiB	classname, CASE WHEN latestdbwritetime < current_timestamp - interval '18 hours' THEN 1 ELSE 0 END AS is_stale FROM latest_t15_candle_view order by classname; [ Date: 2026-03-15 00:05:27 ]

Vacuums / Analyzes Distribution

Key values

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

Analyzes per table

Key values

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

Chart
Table

Table	Number of analyzes
acaweb_fx.pg_catalog.pg_type	4
acaweb_fx.pg_catalog.pg_attribute	4
acaweb_fx.pg_catalog.pg_class	3
acaweb_fx.public.datafeeds_latestrun	2
socialmedia.public.processes	2
acaweb_fx.pg_catalog.pg_depend	2
acaweb_fx.public.latest_t15_candle_view	1
acaweb_fx.public.latest_candle_datetime_per_receng	1
Total	19

Vacuums per table

Key values

public.datafeeds_latestrun (3) Main table vacuumed on database acaweb_fx
10 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.datafeeds_latestrun	3	0	369	0	10	0	0	37	23	50,156
acaweb_fx.pg_catalog.pg_type	2	2	464	0	39	0	0	146	42	236,864
acaweb_fx.pg_catalog.pg_attribute	2	2	2,461	0	219	0	134	728	217	1,389,666
acaweb_fx.public.latest_t15_candle_view	1	1	94	0	1	0	0	6	1	9,049
acaweb_fx.pg_catalog.pg_statistic	1	1	1,044	0	80	0	628	312	74	408,990
acaweb_fx.pg_catalog.pg_class	1	1	364	0	47	0	78	121	48	271,118
Total	10	7	4,796	177	396	0	840	1,350	405	2,365,843

Tuples removed per table

Key values

pg_catalog.pg_attribute (3690) Main table with removed tuples on database acaweb_fx
5494 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
acaweb_fx.pg_catalog.pg_attribute	2	2	3,690	21,338	0	0	534
acaweb_fx.pg_catalog.pg_statistic	1	1	795	4,075	0	0	1,194
acaweb_fx.pg_catalog.pg_type	2	2	704	2,910	0	0	90
acaweb_fx.public.datafeeds_latestrun	3	0	170	42	0	0	48
acaweb_fx.pg_catalog.pg_class	1	1	77	2,594	0	0	150
acaweb_fx.public.latest_t15_candle_view	1	1	58	12	0	0	1
Total	10	7	5,494	30,971	0	0	2,017

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.public.latest_t15_candle_view	1	1	58
acaweb_fx.pg_catalog.pg_type	2	2	704
acaweb_fx.public.datafeeds_latestrun	3	0	170
acaweb_fx.pg_catalog.pg_statistic	1	1	795
acaweb_fx.pg_catalog.pg_attribute	2	2	3690
acaweb_fx.pg_catalog.pg_class	1	1	77
Total	10	7	5,494

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Mar 15	00	10	19

↑ 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

18,999 Total read queries
16,673 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	18,999	25.11%
INSERT	13,275	17.54%
UPDATE	922	1.22%
DELETE	0	0.00%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	1,812	2.39%
DDL	0	0.00%
TCL	664	0.88%
CURSOR	0	0.00%
OTHERS	40,005	52.86%

Queries by database

Key values

unknown Main database
74,914 Requests
1h17m31s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
acaweb_fx	Total	581	0ms
	others	217	0ms
	select	4	0ms
	tcl	332	0ms
	update	28	0ms
socialmedia	Total	182	0ms
	select	182	0ms
unknown	Total	74,914	1h17m31s
	cte	1,812	0ms
	insert	13,275	0ms
	others	2,068	0ms
	select	18,813	0ms
	tcl	332	0ms
	update	894	0ms

Queries by user

Key values

unknown Main user
74,914 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	763	0ms
	others	217	0ms
	select	186	0ms
	tcl	332	0ms
	update	28	0ms
unknown	Total	74,914	1h17m31s
	cte	1,812	0ms
	insert	13,275	0ms
	others	2,068	0ms
	select	18,813	0ms
	tcl	332	0ms
	update	894	0ms

Duration by user

Key values

1h17m31s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	763	0ms
	others	217	0ms
	select	186	0ms
	tcl	332	0ms
	update	28	0ms
unknown	Total	74,914	1h17m31s
	cte	1,812	0ms
	insert	13,275	0ms
	others	2,068	0ms
	select	18,813	0ms
	tcl	332	0ms
	update	894	0ms

Queries by host

Key values

unknown Main host
75,677 Requests
1h17m31s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	75,677	1h17m31s
	cte	1,812	0ms
	insert	13,275	0ms
	others	2,285	0ms
	select	18,999	0ms
	tcl	664	0ms
	update	922	0ms

Queries by application

Key values

unknown Main application
75,641 Requests
1h17m31s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
psql	Total	36	0ms
	others	4	0ms
	select	4	0ms
	update	28	0ms
unknown	Total	75,641	1h17m31s
	cte	1,812	0ms
	insert	13,275	0ms
	others	2,281	0ms
	select	18,995	0ms
	tcl	664	0ms
	update	894	0ms

Number of cancelled queries

Key values

1 per second Cancelled query Peak
2026-03-15 00:31:58 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

25,055 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	25,055	66.42%
1-5ms	8,934	23.69%
5-10ms	669	1.77%
10-25ms	757	2.01%
25-50ms	250	0.66%
50-100ms	140	0.37%
100-500ms	629	1.67%
500-1000ms	444	1.18%
1000-10000ms	750	1.99%
> 10000ms	92	0.24%

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

126

Details

0ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Mar 15	00	126	0ms	0ms

2

0ms

127

Details

0ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Mar 15	00	127	0ms	0ms

3

0ms

4

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
Mar 15	00	4	0ms	0ms

4

0ms

2,452

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
Mar 15	00	2,452	0ms	0ms

5

0ms

27

Details

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Mar 15	00	27	0ms	0ms

6

0ms

237

Details

0ms

select * from ( select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity union select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity union select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity union select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity union select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity) as k order by timegranularity;

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Mar 15	00	237	0ms	0ms

7

0ms

295

Details

0ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Mar 15	00	295	0ms	0ms

8

0ms

3

Details

0ms

insert into resultmedia (processresultsid, type, name, filename) values (?, ?, ?, ?) returning id;

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Mar 15	00	3	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
Mar 15	00	18	0ms	0ms

10

0ms

237

Details

0ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Mar 15	00	237	0ms	0ms

11

0ms

55

Details

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Mar 15	00	55	0ms	0ms

12

0ms

15

Details

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Mar 15	00	15	0ms	0ms

13

0ms

332

Details

0ms

commit;

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Mar 15	00	332	0ms	0ms

14

0ms

196

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

Day	Hour	Count	Duration	Avg duration
Mar 15	00	196	0ms	0ms

15

0ms

1

Details

0ms

select psd.symbolid, psd.hourlysymbolid as intervalsymbolid, s.symbol, dtt.timezone, dtt.absolutetimezoneoffset, psh.hour as index, psh.ave, psh.stddev, ((psh.ave - psh.stddev) / ?.?) as low, ((psh.ave + psh.stddev) / ?.?) as high, ee.timezone as exchangetimezone, ee.mon_t1start as exchangestart, ee.mon_t1end as exchangeend from powerstats_symboldata psd inner join powerstats_hourly psh on psd.hourlysymbolid = psh.symbolid inner join symbols s on psh.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join mat_ps_hourly_symbolid_max_enddate e on psh.enddate = e.enddate and psh.symbolid = e.symbolid inner join exchanges ee on ee.exchange = s.exchange where psd.symbolid = ? and dtt.dayofweek = ? order by hour asc;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Mar 15	00	1	0ms	0ms

16

0ms

237

Details

0ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Mar 15	00	237	0ms	0ms

17

0ms

14

Details

0ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Mar 15	00	14	0ms	0ms

18

0ms

6

Details

0ms

select pid, datname, client_addr from pg_stat_activity where query ilike ? and pid <> pg_backend_pid() and state = ? and datname = ?;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Mar 15	00	6	0ms	0ms

19

0ms

120

Details

0ms

update executions set isrunning = false, has_results = false, response = ? where id = ?;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Mar 15	00	120	0ms	0ms

20

0ms

237

Details

0ms

select system_identifier from pg_control_system ();

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Mar 15	00	237	0ms	0ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

3,238

Details

0ms

select ?;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Mar 15	00	3,238	0ms	0ms

2

2,906

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

Day	Hour	Count	Duration	Avg duration
Mar 15	00	2,906	0ms	0ms

3

2,901

Details

0ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Mar 15	00	2,901	0ms	0ms

4

2,485

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

Day	Hour	Count	Duration	Avg duration
Mar 15	00	2,485	0ms	0ms

5

2,452

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

Day	Hour	Count	Duration	Avg duration
Mar 15	00	2,452	0ms	0ms

6

1,513

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

Day	Hour	Count	Duration	Avg duration
Mar 15	00	1,513	0ms	0ms

7

1,443

Details

0ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Mar 15	00	1,443	0ms	0ms

8

976

Details

0ms

select datetimeupdate from latest_candle_datetime_per_receng where recognitionengine ilike ?;

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Mar 15	00	976	0ms	0ms

9

811

Details

0ms

set extra_float_digits = ?;

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Mar 15	00	811	0ms	0ms

10

799

Details

0ms

set application_name = ?;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Mar 15	00	799	0ms	0ms

11

621

Details

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Mar 15	00	621	0ms	0ms

12

576

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

Day	Hour	Count	Duration	Avg duration
Mar 15	00	576	0ms	0ms

13

493

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

Day	Hour	Count	Duration	Avg duration
Mar 15	00	493	0ms	0ms

14

420

Details

0ms

insert into t1440_underlying (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
Mar 15	00	420	0ms	0ms

15

332

Details

0ms

commit;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Mar 15	00	332	0ms	0ms

16

332

Details

0ms

update datafeeds_latestrun set latestrxtime = subquery.latestrxtime, latestdbwritetime = subquery.latestdbwritetime from ( select latestrxtime, latestdbwritetime from latest_t15_candle_view where classname ilike ?) as subquery where datafeeds_latestrun.feedname ilike ?;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Mar 15	00	332	0ms	0ms

17

332

Details

0ms

begin;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Mar 15	00	332	0ms	0ms

18

295

Details

0ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Mar 15	00	295	0ms	0ms

19

237

Details

0ms

select * from ( select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity union select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity union select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity union select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity union select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity) as k order by timegranularity;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Mar 15	00	237	0ms	0ms

20

237

Details

0ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Mar 15	00	237	0ms	0ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

126

Details

0ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Mar 15	00	126	0ms	0ms

2

0ms

127

Details

0ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Mar 15	00	127	0ms	0ms

3

0ms

4

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
Mar 15	00	4	0ms	0ms

4

0ms

2,452

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
Mar 15	00	2,452	0ms	0ms

5

0ms

27

Details

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Mar 15	00	27	0ms	0ms

6

0ms

237

Details

0ms

select * from ( select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity union select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity union select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity union select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity union select timegranularity, extract(day from (max(patternendtime) - min(patternendtime))) from fibonacci_results a inner join symbols s on a.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid where timegranularity = ? and (dss.archive is null or dss.archive is true) group by timegranularity) as k order by timegranularity;

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Mar 15	00	237	0ms	0ms

7

0ms

295

Details

0ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Mar 15	00	295	0ms	0ms

8

0ms

3

Details

0ms

insert into resultmedia (processresultsid, type, name, filename) values (?, ?, ?, ?) returning id;

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Mar 15	00	3	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
Mar 15	00	18	0ms	0ms

10

0ms

237

Details

0ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Mar 15	00	237	0ms	0ms

11

0ms

55

Details

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Mar 15	00	55	0ms	0ms

12

0ms

15

Details

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Mar 15	00	15	0ms	0ms

13

0ms

332

Details

0ms

commit;

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Mar 15	00	332	0ms	0ms

14

0ms

196

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

Day	Hour	Count	Duration	Avg duration
Mar 15	00	196	0ms	0ms

15

0ms

1

Details

0ms

select psd.symbolid, psd.hourlysymbolid as intervalsymbolid, s.symbol, dtt.timezone, dtt.absolutetimezoneoffset, psh.hour as index, psh.ave, psh.stddev, ((psh.ave - psh.stddev) / ?.?) as low, ((psh.ave + psh.stddev) / ?.?) as high, ee.timezone as exchangetimezone, ee.mon_t1start as exchangestart, ee.mon_t1end as exchangeend from powerstats_symboldata psd inner join powerstats_hourly psh on psd.hourlysymbolid = psh.symbolid inner join symbols s on psh.symbolid = s.symbolid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join mat_ps_hourly_symbolid_max_enddate e on psh.enddate = e.enddate and psh.symbolid = e.symbolid inner join exchanges ee on ee.exchange = s.exchange where psd.symbolid = ? and dtt.dayofweek = ? order by hour asc;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Mar 15	00	1	0ms	0ms

16

0ms

237

Details

0ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Mar 15	00	237	0ms	0ms

17

0ms

14

Details

0ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Mar 15	00	14	0ms	0ms

18

0ms

6

Details

0ms

select pid, datname, client_addr from pg_stat_activity where query ilike ? and pid <> pg_backend_pid() and state = ? and datname = ?;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Mar 15	00	6	0ms	0ms

19

0ms

120

Details

0ms

update executions set isrunning = false, has_results = false, response = ? where id = ?;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Mar 15	00	120	0ms	0ms

20

0ms

237

Details

0ms

select system_identifier from pg_control_system ();

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Mar 15	00	237	0ms	0ms

Time consuming prepare


Date: 2026-03-15 00:31:20
Duration: 2ms
Database: postgres
Date: 2026-03-15 00:10:32
Duration: 0ms
Database: postgres
Date: 2026-03-15 00:57:06
Duration: 11ms
Database: postgres
Date: 2026-03-15 00:07:20
Duration: 0ms
Database: postgres
Date: 2026-03-15 00:31:01
Duration: 1ms
Database: postgres
Date: 2026-03-15 00:17:51
Duration: 1ms
Database: postgres
Date: 2026-03-15 00:17:01
Duration: 0ms
Database: postgres
Date: 2026-03-15 00:57:14
Duration: 2ms
Database: postgres
Date: 2026-03-15 00:11:57
Duration: 0ms
Database: postgres
Date: 2026-03-15 00:01:54
Duration: 0ms
Database: postgres
Date: 2026-03-15 00:11:01
Duration: 2ms
Database: postgres
Date: 2026-03-15 00:04:08
Duration: 1ms
Database: postgres
Date: 2026-03-15 00:39:21
Duration: 2ms
Database: postgres
Date: 2026-03-15 00:00:04
Duration: 2ms
Database: postgres
Date: 2026-03-15 00:24:12
Duration: 0ms
Database: postgres
Date: 2026-03-15 00:04:08
Duration: 0ms
Database: postgres
Date: 2026-03-15 00:38:32
Duration: 0ms
Database: postgres
Date: 2026-03-15 00:37:19
Duration: 1ms
Database: postgres
Date: 2026-03-15 00:06:00
Duration: 0ms
Database: postgres
Date: 2026-03-15 00:36:43
Duration: 0ms
Database: postgres

Time consuming bind

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

9s425ms

913

Details

0ms

58ms

10ms

WITH rar_max as ( ;

Times Reported Time consuming bind #1

Day	Hour	Count	Duration	Avg duration
Mar 15	00	913	9s425ms	10ms

WITH rar_max as ( ;

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

Date: 2026-03-15 00:57:06 Duration: 44ms Database: postgres parameters: $1 = '607833438894815303', $2 = '607833438894815303', $3 = '607833438894815303'
WITH rar_max as ( ;

Date: 2026-03-15 00:38:32 Duration: 36ms Database: postgres parameters: $1 = '607833444059636301', $2 = '607833444059636301', $3 = '607833444059636301'

2

1s776ms

654

Details

0ms

8ms

2ms

SELECT symbolid, ;

Times Reported Time consuming bind #2

Day	Hour	Count	Duration	Avg duration
	00	654	1s776ms	2ms

SELECT symbolid, ;

Date: 2026-03-15 00:02:00 Duration: 8ms Database: postgres parameters: $1 = 'BDSWISS', $2 = '60', $3 = 'SPX500'
SELECT symbolid, ;

Date: 2026-03-15 00:00:36 Duration: 4ms Database: postgres parameters: $1 = 'FPMARKETS', $2 = '15', $3 = 'XPTUSD', $4 = 'XPDUSD', $5 = 'XBRUSD'
SELECT symbolid, ;

Date: 2026-03-15 00:21:58 Duration: 4ms Database: postgres parameters: $1 = 'GLOBALGTMT5', $2 = '15', $3 = 'DOTBTC', $4 = 'BTCXAU', $5 = 'BTCZAR', $6 = 'ETHJPY', $7 = 'DOGUSD'

3

1s129ms

3,431

Details

0ms

5ms

0ms

SELECT ;

Times Reported Time consuming bind #3

Day	Hour	Count	Duration	Avg duration
	00	3,431	1s129ms	0ms

SELECT ;

Date: 2026-03-15 00:24:33 Duration: 5ms Database: postgres parameters: $1 = '515840243198780300'
SELECT ;

Date: 2026-03-15 00:51:02 Duration: 3ms Database: postgres parameters: $1 = '607836855069067303', $2 = '607836855069067303', $3 = '607836855069067303'
SELECT ;

Date: 2026-03-15 00:11:00 Duration: 3ms Database: postgres parameters: $1 = '607836679305980301', $2 = '607836679305980301', $3 = '607836679305980301'

4

283ms

45

Details

4ms

14ms

6ms

WITH last_candle AS ( ;

Times Reported Time consuming bind #4

Day	Hour	Count	Duration	Avg duration
	00	45	283ms	6ms

WITH last_candle AS ( ;

Date: 2026-03-15 00:08:10 Duration: 14ms Database: postgres parameters: $1 = '667', $2 = '667'
WITH last_candle AS ( ;

Date: 2026-03-15 00:36:00 Duration: 9ms Database: postgres parameters: $1 = '558', $2 = '558'
WITH last_candle AS ( ;

Date: 2026-03-15 00:36:09 Duration: 9ms Database: postgres parameters: $1 = '667', $2 = '667'

5

207ms

115

Details

1ms

2ms

1ms

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

Times Reported Time consuming bind #5

Day	Hour	Count	Duration	Avg duration
	00	115	207ms	1ms

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

Date: 2026-03-15 00:01:43 Duration: 2ms Database: postgres parameters: $1 = 'AXIORY'
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;

Date: 2026-03-15 00:45:58 Duration: 2ms Database: postgres parameters: $1 = 'ICMARKETS'
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;

Date: 2026-03-15 00:31:01 Duration: 2ms Database: postgres parameters: $1 = 'ICMARKETS'

6

192ms

2,452

Details

0ms

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

Times Reported Time consuming bind #6

Day	Hour	Count	Duration	Avg duration
	00	2,452	192ms	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-03-15 00:01:08 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 22:00:00', $2 = '0.55363', $3 = '0.553695', $4 = '0.55307', $5 = '0.5531', $6 = '6129', $7 = '515840230422578300', $8 = '0', $9 = '2026-03-15 00:01:08.697', $10 = '2026-03-15 00:01:08.697', $11 = '0.55363', $12 = '0.553695', $13 = '0.55307', $14 = '0.5531', $15 = '6129', $16 = '0', $17 = '2026-03-15 00:01:08.697', $18 = '2026-03-15 00:01:08.697'
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-03-15 00:47:53 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 22:00:00', $2 = '499.44', $3 = '499.83', $4 = '496.865', $5 = '497.725', $6 = '936', $7 = '515840249431852300', $8 = '0', $9 = '2026-03-15 00:47:53.27', $10 = '2026-03-15 00:47:53.27', $11 = '499.44', $12 = '499.83', $13 = '496.865', $14 = '497.725', $15 = '936', $16 = '0', $17 = '2026-03-15 00:47:53.27', $18 = '2026-03-15 00:47:53.27'
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-03-15 00:10:32 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 20:00:00', $2 = '198.77', $3 = '199.23', $4 = '198.77', $5 = '199.13', $6 = '315', $7 = '515840247929791300', $8 = '0', $9 = '2026-03-15 00:10:32.582', $10 = '2026-03-15 00:10:32.513', $11 = '198.77', $12 = '199.23', $13 = '198.77', $14 = '199.13', $15 = '315', $16 = '0', $17 = '2026-03-15 00:10:32.582', $18 = '2026-03-15 00:10:32.513'

7

165ms

2,485

Details

0ms

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

Times Reported Time consuming bind #7

Day	Hour	Count	Duration	Avg duration
	00	2,485	165ms	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-03-15 00:11:41 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 21:00:00', $2 = '8570.4', $3 = '8571.7', $4 = '8542.25', $5 = '8542.75', $6 = '5165', $7 = '515840248015340300', $8 = '0', $9 = '2026-03-15 00:11:41.509', $10 = '2026-03-15 00:11:41.399', $11 = '8570.4', $12 = '8571.7', $13 = '8542.25', $14 = '8542.75', $15 = '5165', $16 = '0', $17 = '2026-03-15 00:11:41.509', $18 = '2026-03-15 00:11:41.399'
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-03-15 00:16:50 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 22:30:00', $2 = '1.32333', $3 = '1.32361', $4 = '1.32264', $5 = '1.32287', $6 = '3310', $7 = '515840230504277300', $8 = '0', $9 = '2026-03-15 00:16:50.388', $10 = '2026-03-15 00:16:50.284', $11 = '1.32333', $12 = '1.32361', $13 = '1.32264', $14 = '1.32287', $15 = '3310', $16 = '0', $17 = '2026-03-15 00:16:50.388', $18 = '2026-03-15 00:16:50.284'
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-03-15 00:40:40 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 21:00:00', $2 = '8570.4', $3 = '8571.7', $4 = '8542.25', $5 = '8542.75', $6 = '5165', $7 = '515840248015340300', $8 = '0', $9 = '2026-03-15 00:40:40.607', $10 = '2026-03-15 00:40:40.52', $11 = '8570.4', $12 = '8571.7', $13 = '8542.25', $14 = '8542.75', $15 = '5165', $16 = '0', $17 = '2026-03-15 00:40:40.607', $18 = '2026-03-15 00:40:40.52'

8

125ms

2,906

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

Day	Hour	Count	Duration	Avg duration
	00	2,906	125ms	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-03-15 00:46:37 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 23:00:00', $2 = '26.375', $3 = '26.525', $4 = '26.325', $5 = '26.475', $6 = '84', $7 = '515840249466545300', $8 = '0', $9 = '2026-03-15 00:46:37.68', $10 = '2026-03-15 00:46:37.593', $11 = '26.375', $12 = '26.525', $13 = '26.325', $14 = '26.475', $15 = '84', $16 = '0', $17 = '2026-03-15 00:46:37.68', $18 = '2026-03-15 00:46:37.593'
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-03-15 00:56:42 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 21:30:00', $2 = '8542.4', $3 = '8543.4', $4 = '8536.4', $5 = '8541.95', $6 = '2997', $7 = '515840248015086300', $8 = '0', $9 = '2026-03-15 00:56:42.544', $10 = '2026-03-15 00:56:42.468', $11 = '8542.4', $12 = '8543.4', $13 = '8536.4', $14 = '8541.95', $15 = '2997', $16 = '0', $17 = '2026-03-15 00:56:42.544', $18 = '2026-03-15 00:56:42.468'
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-03-15 00:32:11 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 22:15:00', $2 = '8552.5', $3 = '8553', $4 = '8540.5', $5 = '8540.5', $6 = '179', $7 = '515840245910095300', $8 = '0', $9 = '2026-03-15 00:32:11.302', $10 = '2026-03-15 00:32:11.217', $11 = '8552.5', $12 = '8553', $13 = '8540.5', $14 = '8540.5', $15 = '179', $16 = '0', $17 = '2026-03-15 00:32:11.302', $18 = '2026-03-15 00:32:11.217'

9

124ms

3,130

Details

0ms

13ms

0ms

select 1;

Times Reported Time consuming bind #9

Day	Hour	Count	Duration	Avg duration
	00	3,130	124ms	0ms

select 1;

Date: 2026-03-15 00:06:36 Duration: 13ms Database: postgres
select 1;

Date: 2026-03-15 00:37:37 Duration: 6ms Database: postgres
select 1;

Date: 2026-03-15 00:06:39 Duration: 6ms Database: postgres

10

94ms

12

Details

0ms

24ms

7ms

with wh_patitioned as ( ;

Times Reported Time consuming bind #10

Day	Hour	Count	Duration	Avg duration
	00	12	94ms	7ms

with wh_patitioned as ( ;

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

11

47ms

23

Details

0ms

11ms

2ms

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

Times Reported Time consuming bind #11

Day	Hour	Count	Duration	Avg duration
	00	23	47ms	2ms

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

Date: 2026-03-15 00:07:28 Duration: 11ms Database: postgres parameters: $1 = '667', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'
WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;

Date: 2026-03-15 00:39:30 Duration: 11ms Database: postgres parameters: $1 = '667', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'
WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;

Date: 2026-03-15 00:40:12 Duration: 11ms Database: postgres parameters: $1 = '667', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'

12

44ms

576

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

Day	Hour	Count	Duration	Avg duration
	00	576	44ms	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-03-15 00:11:41 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 16:00:00', $2 = '8612.4', $3 = '8624.4', $4 = '8552.1', $5 = '8559.2', $6 = '68705', $7 = '515840248015766300', $8 = '0', $9 = '2026-03-15 00:11:41.558', $10 = '2026-03-15 00:11:41.419', $11 = '8612.4', $12 = '8624.4', $13 = '8552.1', $14 = '8559.2', $15 = '68705', $16 = '0', $17 = '2026-03-15 00:11:41.558', $18 = '2026-03-15 00:11:41.419'
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-03-15 00:11:57 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 12:00:00', $2 = '25497.3', $3 = '25760.3', $4 = '25467.3', $5 = '25631.3', $6 = '61438', $7 = '515840247934272300', $8 = '0', $9 = '2026-03-15 00:11:57.646', $10 = '2026-03-15 00:11:57.54', $11 = '25497.3', $12 = '25760.3', $13 = '25467.3', $14 = '25631.3', $15 = '61438', $16 = '0', $17 = '2026-03-15 00:11:57.646', $18 = '2026-03-15 00:11:57.54'
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-03-15 00:01:54 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 20:00:00', $2 = '111.828', $3 = '111.952', $4 = '111.4955', $5 = '111.5065', $6 = '28230', $7 = '515840249384281300', $8 = '0', $9 = '2026-03-15 00:01:54.131', $10 = '2026-03-15 00:01:54.016', $11 = '111.828', $12 = '111.952', $13 = '111.4955', $14 = '111.5065', $15 = '28230', $16 = '0', $17 = '2026-03-15 00:01:54.131', $18 = '2026-03-15 00:01:54.016'

13

41ms

420

Details

0ms

INSERT INTO T1440_underlying (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
	00	420	41ms	0ms

INSERT INTO T1440_underlying (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-03-15 00:01:54 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 00:00:00', $2 = '1.15118', $3 = '1.152985', $4 = '1.141105', $5 = '1.141615', $6 = '98442', $7 = '515840249373173300', $8 = '0', $9 = '2026-03-15 00:01:54.354', $10 = '2026-03-15 00:01:54.353', $11 = '1.15118', $12 = '1.152985', $13 = '1.141105', $14 = '1.141615', $15 = '98442', $16 = '0', $17 = '2026-03-15 00:01:54.354', $18 = '2026-03-15 00:01:54.353'
INSERT INTO T1440_underlying (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-03-15 00:31:38 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 00:00:00', $2 = '83.714', $3 = '85.4695', $4 = '79.439', $5 = '80.559', $6 = '331462', $7 = '515840249469364300', $8 = '0', $9 = '2026-03-15 00:31:38.239', $10 = '2026-03-15 00:31:38.238', $11 = '83.714', $12 = '85.4695', $13 = '79.439', $14 = '80.559', $15 = '331462', $16 = '0', $17 = '2026-03-15 00:31:38.239', $18 = '2026-03-15 00:31:38.238'
INSERT INTO T1440_underlying (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-03-15 00:22:10 Duration: 0ms Database: postgres parameters: $1 = '2026-03-13 00:00:00', $2 = '101.775', $3 = '103.925', $4 = '97.815', $5 = '103.815', $6 = '62052', $7 = '515840249390663300', $8 = '0', $9 = '2026-03-15 00:22:10.717', $10 = '2026-03-15 00:22:10.717', $11 = '101.775', $12 = '103.925', $13 = '97.815', $14 = '103.815', $15 = '62052', $16 = '0', $17 = '2026-03-15 00:22:10.717', $18 = '2026-03-15 00:22:10.717'

14

24ms

66

Details

0ms

5ms

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

Day	Hour	Count	Duration	Avg duration
	00	66	24ms	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-03-15 00:36:43 Duration: 5ms Database: postgres parameters: $1 = '607810023930613301'
/*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-03-15 00:35:07 Duration: 4ms Database: postgres parameters: $1 = '607832431913525301'
/*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-03-15 00:37:10 Duration: 2ms Database: postgres parameters: $1 = '607832488479539301'

15

18ms

4

Details

3ms

5ms

4ms

SELECT DISTINCT ON (basegroupname, symbol) ;

Times Reported Time consuming bind #15

Day	Hour	Count	Duration	Avg duration
	00	4	18ms	4ms

SELECT DISTINCT ON (basegroupname, symbol) ;

Date: 2026-03-15 00:38:26 Duration: 5ms Database: postgres parameters: $1 = '667', $2 = '667'
SELECT DISTINCT ON (basegroupname, symbol) ;

Date: 2026-03-15 00:57:01 Duration: 5ms Database: postgres parameters: $1 = '667', $2 = '667'
SELECT DISTINCT ON (basegroupname, symbol) ;

Date: 2026-03-15 00:06:00 Duration: 3ms Database: postgres parameters: $1 = '627', $2 = '627'

16

14ms

22

Details

0ms

select feedname, to_char(latestrxtime, 'yyyy-mm-dd HH24:MI'), to_char(LatestDBWriteTime, 'yyyy-mm-dd HH24:MI'), to_char(LatestStartupTime, 'yyyy-mm-dd HH24:MI'), StartupTimeInMinutes, dm.source_type, dm.transport_type, case when latestrxtime < (CURRENT_TIMESTAMP - 5 * interval '1 minute') then 'X' else 'OK' end, case when (feedname ilike '%_EOD' OR feedname ilike 'IQFEED_DAILIES' or feedname ilike 'YAHOO%' or feedname ilike 'QUANDL_FUTURES%' or feedname ilike 'BAR_CHART') then case when LatestDBWriteTime < (CURRENT_TIMESTAMP - 24 * interval '1 hour') then 'X' else 'OK' end else case when (LatestDBWriteTime < (CURRENT_TIMESTAMP - 15 * interval '1 minute') and LatestStartupTime < (CURRENT_TIMESTAMP - 30 * interval '1 minute')) OR latestrxtime < CURRENT_TIMESTAMP - interval '2 hour' then 'X' else 'OK' end end as statusDB, comment from datafeeds_latestrun dlr left outer join datafeeds df on dlr.feedname ilike df.name inner join datafeeds_metadata dm on df.metadata_id = dm.id order by feedname;

Times Reported Time consuming bind #16

Day	Hour	Count	Duration	Avg duration
	00	22	14ms	0ms

select feedname, to_char(latestrxtime, 'yyyy-mm-dd HH24:MI'), to_char(LatestDBWriteTime, 'yyyy-mm-dd HH24:MI'), to_char(LatestStartupTime, 'yyyy-mm-dd HH24:MI'), StartupTimeInMinutes, dm.source_type, dm.transport_type, case when latestrxtime < (CURRENT_TIMESTAMP - 5 * interval '1 minute') then 'X' else 'OK' end, case when (feedname ilike '%_EOD' OR feedname ilike 'IQFEED_DAILIES' or feedname ilike 'YAHOO%' or feedname ilike 'QUANDL_FUTURES%' or feedname ilike 'BAR_CHART') then case when LatestDBWriteTime < (CURRENT_TIMESTAMP - 24 * interval '1 hour') then 'X' else 'OK' end else case when (LatestDBWriteTime < (CURRENT_TIMESTAMP - 15 * interval '1 minute') and LatestStartupTime < (CURRENT_TIMESTAMP - 30 * interval '1 minute')) OR latestrxtime < CURRENT_TIMESTAMP - interval '2 hour' then 'X' else 'OK' end end as statusDB, comment from datafeeds_latestrun dlr left outer join datafeeds df on dlr.feedname ilike df.name inner join datafeeds_metadata dm on df.metadata_id = dm.id order by feedname;

Date: 2026-03-15 00:39:21 Duration: 0ms Database: postgres
select feedname, to_char(latestrxtime, 'yyyy-mm-dd HH24:MI'), to_char(LatestDBWriteTime, 'yyyy-mm-dd HH24:MI'), to_char(LatestStartupTime, 'yyyy-mm-dd HH24:MI'), StartupTimeInMinutes, dm.source_type, dm.transport_type, case when latestrxtime < (CURRENT_TIMESTAMP - 5 * interval '1 minute') then 'X' else 'OK' end, case when (feedname ilike '%_EOD' OR feedname ilike 'IQFEED_DAILIES' or feedname ilike 'YAHOO%' or feedname ilike 'QUANDL_FUTURES%' or feedname ilike 'BAR_CHART') then case when LatestDBWriteTime < (CURRENT_TIMESTAMP - 24 * interval '1 hour') then 'X' else 'OK' end else case when (LatestDBWriteTime < (CURRENT_TIMESTAMP - 15 * interval '1 minute') and LatestStartupTime < (CURRENT_TIMESTAMP - 30 * interval '1 minute')) OR latestrxtime < CURRENT_TIMESTAMP - interval '2 hour' then 'X' else 'OK' end end as statusDB, comment from datafeeds_latestrun dlr left outer join datafeeds df on dlr.feedname ilike df.name inner join datafeeds_metadata dm on df.metadata_id = dm.id order by feedname;

Date: 2026-03-15 00:04:08 Duration: 0ms Database: postgres
select feedname, to_char(latestrxtime, 'yyyy-mm-dd HH24:MI'), to_char(LatestDBWriteTime, 'yyyy-mm-dd HH24:MI'), to_char(LatestStartupTime, 'yyyy-mm-dd HH24:MI'), StartupTimeInMinutes, dm.source_type, dm.transport_type, case when latestrxtime < (CURRENT_TIMESTAMP - 5 * interval '1 minute') then 'X' else 'OK' end, case when (feedname ilike '%_EOD' OR feedname ilike 'IQFEED_DAILIES' or feedname ilike 'YAHOO%' or feedname ilike 'QUANDL_FUTURES%' or feedname ilike 'BAR_CHART') then case when LatestDBWriteTime < (CURRENT_TIMESTAMP - 24 * interval '1 hour') then 'X' else 'OK' end else case when (LatestDBWriteTime < (CURRENT_TIMESTAMP - 15 * interval '1 minute') and LatestStartupTime < (CURRENT_TIMESTAMP - 30 * interval '1 minute')) OR latestrxtime < CURRENT_TIMESTAMP - interval '2 hour' then 'X' else 'OK' end end as statusDB, comment from datafeeds_latestrun dlr left outer join datafeeds df on dlr.feedname ilike df.name inner join datafeeds_metadata dm on df.metadata_id = dm.id order by feedname;

Date: 2026-03-15 00:49:23 Duration: 0ms Database: postgres

17

12ms

18

Details

0ms

select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;

Times Reported Time consuming bind #17

Day	Hour	Count	Duration	Avg duration
	00	18	12ms	0ms

select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;

Date: 2026-03-15 00:11:01 Duration: 0ms Database: postgres
select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;

Date: 2026-03-15 00:40:03 Duration: 0ms Database: postgres
select cast(count(*) / cast(setting as numeric) * 100 as int) from pg_stat_activity, pg_settings WHERE name = 'max_connections' group by setting;

Date: 2026-03-15 00:11:01 Duration: 0ms Database: postgres

18

11ms

22

Details

0ms

select distinct classname, to_char(created_datetime, 'yyyy-mm-dd HH24:MI'), to_char(cleared_datetime, 'yyyy-mm-dd HH24:MI'), action_to_take, description, created_datetime from datafeed_restarter_events where (is_current_entry = 1 OR cleared_datetime > current_timestamp - interval '17 hour') order by created_datetime desc;

Times Reported Time consuming bind #18

Day	Hour	Count	Duration	Avg duration
	00	22	11ms	0ms

select distinct classname, to_char(created_datetime, 'yyyy-mm-dd HH24:MI'), to_char(cleared_datetime, 'yyyy-mm-dd HH24:MI'), action_to_take, description, created_datetime from datafeed_restarter_events where (is_current_entry = 1 OR cleared_datetime > current_timestamp - interval '17 hour') order by created_datetime desc;

Date: 2026-03-15 00:04:08 Duration: 0ms Database: postgres
select distinct classname, to_char(created_datetime, 'yyyy-mm-dd HH24:MI'), to_char(cleared_datetime, 'yyyy-mm-dd HH24:MI'), action_to_take, description, created_datetime from datafeed_restarter_events where (is_current_entry = 1 OR cleared_datetime > current_timestamp - interval '17 hour') order by created_datetime desc;

Date: 2026-03-15 00:49:23 Duration: 0ms Database: postgres
select distinct classname, to_char(created_datetime, 'yyyy-mm-dd HH24:MI'), to_char(cleared_datetime, 'yyyy-mm-dd HH24:MI'), action_to_take, description, created_datetime from datafeed_restarter_events where (is_current_entry = 1 OR cleared_datetime > current_timestamp - interval '17 hour') order by created_datetime desc;

Date: 2026-03-15 00:44:22 Duration: 0ms Database: postgres

19

11ms

12

Details

0ms

1ms

0ms

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

Times Reported Time consuming bind #19

Day	Hour	Count	Duration	Avg duration
	00	12	11ms	0ms

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

Date: 2026-03-15 00:00:49 Duration: 1ms Database: postgres parameters: $1 = '538', $2 = 'CADCHF', $3 = '538'
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-03-15 00:06:33 Duration: 1ms Database: postgres parameters: $1 = '558', $2 = 'EURUSD', $3 = '558'
SELECT timegranularity FROM brokersymbollist bsl INNER JOIN symbols s ON bsl.symbolid = s.symbolid INNER JOIN downloadersymbolsettings dss on s.symbolid = dss.symbolid LEFT OUTER JOIN brokerinstrumentmapping bdfi ON bdfi.brokerid = $1 AND dss.datafeedinstrumentid = bdfi.datafeedinstrumentid WHERE s.nonliquid = 0 and s.deleted = 0 and dss.enabled = 1 AND s.symbol ILIKE $2 AND bsl.brokerid = $3 AND timegranularity >= 15 ORDER BY timegranularity LIMIT 1;

Date: 2026-03-15 00:40:18 Duration: 1ms Database: postgres parameters: $1 = '558', $2 = 'BTCUSD', $3 = '558'

20

9ms

11

Details

0ms

4ms

0ms

/*server.FibonacciResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, symbol AS sym, Exchange AS e, longname as lo, shortname as sho, timegranularity AS tg, p.PatternID AS pid, Direction AS d, PatternStartTime AS pst, PatternEndTime AS pet, PatternStartPrice AS psp, PatternEndPrice AS pep, priceX as px, timeX as tx, priceA as pa, timeA as ta, priceB as pb, timeB as tb, priceC as pc, timeC as tc, priceD as pd, timeD as td, averagequality as aq, timequality as tq, 1 - errormargin as rq, 1 - noise as c, target10 as t10, target06 as t06, target16 as t16, target07 as t07, target12 as t12, target03 as t03, target05 as t05, PatternLengthBars AS l, temporarypattern as tp, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM Fibonacci_Results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid INNER JOIN fibonaccipatterns p on a.pattern = p.patternname where resultuid = $1 and dtt.dayofweek = 3;

Times Reported Time consuming bind #20

Day	Hour	Count	Duration	Avg duration
	00	11	9ms	0ms

/*server.FibonacciResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, symbol AS sym, Exchange AS e, longname as lo, shortname as sho, timegranularity AS tg, p.PatternID AS pid, Direction AS d, PatternStartTime AS pst, PatternEndTime AS pet, PatternStartPrice AS psp, PatternEndPrice AS pep, priceX as px, timeX as tx, priceA as pa, timeA as ta, priceB as pb, timeB as tb, priceC as pc, timeC as tc, priceD as pd, timeD as td, averagequality as aq, timequality as tq, 1 - errormargin as rq, 1 - noise as c, target10 as t10, target06 as t06, target16 as t16, target07 as t07, target12 as t12, target03 as t03, target05 as t05, PatternLengthBars AS l, temporarypattern as tp, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM Fibonacci_Results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid INNER JOIN fibonaccipatterns p on a.pattern = p.patternname where resultuid = $1 and dtt.dayofweek = 3;

Date: 2026-03-15 00:36:57 Duration: 4ms Database: postgres parameters: $1 = '607832606094655302'
/*server.FibonacciResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, symbol AS sym, Exchange AS e, longname as lo, shortname as sho, timegranularity AS tg, p.PatternID AS pid, Direction AS d, PatternStartTime AS pst, PatternEndTime AS pet, PatternStartPrice AS psp, PatternEndPrice AS pep, priceX as px, timeX as tx, priceA as pa, timeA as ta, priceB as pb, timeB as tb, priceC as pc, timeC as tc, priceD as pd, timeD as td, averagequality as aq, timequality as tq, 1 - errormargin as rq, 1 - noise as c, target10 as t10, target06 as t06, target16 as t16, target07 as t07, target12 as t12, target03 as t03, target05 as t05, PatternLengthBars AS l, temporarypattern as tp, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM Fibonacci_Results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid INNER JOIN fibonaccipatterns p on a.pattern = p.patternname where resultuid = $1 and dtt.dayofweek = 3;

Date: 2026-03-15 00:49:09 Duration: 2ms Database: postgres parameters: $1 = '607832608082291302'
/*server.FibonacciResult*/ SELECT ResultUID AS ruid, s.symbolid AS sid, symbol AS sym, Exchange AS e, longname as lo, shortname as sho, timegranularity AS tg, p.PatternID AS pid, Direction AS d, PatternStartTime AS pst, PatternEndTime AS pet, PatternStartPrice AS psp, PatternEndPrice AS pep, priceX as px, timeX as tx, priceA as pa, timeA as ta, priceB as pb, timeB as tb, priceC as pc, timeC as tc, priceD as pd, timeD as td, averagequality as aq, timequality as tq, 1 - errormargin as rq, 1 - noise as c, target10 as t10, target06 as t06, target16 as t16, target07 as t07, target12 as t12, target03 as t03, target05 as t05, PatternLengthBars AS l, temporarypattern as tp, Bandwidth AS bw, QtyTP AS qtp, p.patternname as patternname, dtt.absolutetimezoneoffset as tzOs, dtt.timezone as tz FROM Fibonacci_Results a INNER JOIN downloadersymbolsettings dss on a.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname inner join symbols s on a.symbolid = s.symbolid INNER JOIN fibonaccipatterns p on a.pattern = p.patternname where resultuid = $1 and dtt.dayofweek = 3;

Date: 2026-03-15 00:10:18 Duration: 1ms Database: postgres parameters: $1 = '607832200659655302'

Log levels

Key values

139,678 Log entries

Chart
Table

Type	Count	Percentage
DETAIL	28,952	20.73%
ERROR	237	0.17%
LOG	110,174	78.88%
STATEMENT	315	0.23%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
237 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

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

Rank

Times reported

Error

1

237

Details

ERROR: canceling statement due to statement timeout

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Mar 15	00	237

ERROR: canceling statement due to statement timeout

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