pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Thu Dec 18 11:00:16 2025
Log file: /home/postgres/pg_data/data/pg_log/postgresql-2025-12-18_120000.log, ..., /home/postgres/pg_data/data/pg_log/postgresql-2025-12-18_124728.log
Parsed 3,480,602 log entries in 1m15s
Log start from 2025-12-18 12:00:00 to 2025-12-18 13:00:00

Global Stats

249 Number of unique normalized queries
331,162 Number of queries
2h28m38s Total query duration
2025-12-18 12:00:00 First query
2025-12-18 13:00:00 Last query
5,919 queries/s at 2025-12-18 12:00:04 Query peak

2h28m38s Total query duration
16s29ms Prepare/parse total duration
1m23s Bind total duration
2h26m59s Execute total duration

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

36 Total number of automatic vacuums
55 Total number of automatic analyzes

637 Number temporary file
198.34 MiB Max size of temporary file
7.75 MiB Average size of temporary file

7,100 Total number of sessions
16 sessions at 2025-12-18 12:31:08 Session peak
1d6h45m27s Total duration of sessions
15s595ms Average duration of sessions
46 Average queries per session
1s256ms Average queries duration per session
14s339ms Average idle time per session

7,114 Total number of connections
72 connections/s at 2025-12-18 12:31:39 Connection peak
3 Total number of databases

SQL Traffic

Key values

5,919 queries/s Query Peak
2025-12-18 12:00:04 Date

SELECT Traffic

Key values

2,897 queries/s Query Peak
2025-12-18 12:00:04 Date

INSERT/UPDATE/DELETE Traffic

Key values

153 queries/s Query Peak
2025-12-18 12:00:58 Date

Queries duration

Key values

2h28m38s 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)
Dec 18	12	331,161	0ms	46s244ms	26ms	4m59s	5m22s	5m57s
	13	1	0ms	0ms	0ms	0ms	0ms	0ms

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 18	12	106,544	26	0ms	0ms	0ms	0ms
	13	1	0	0ms	0ms	0ms	0ms

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 18	12	32,228	2,334	16	96	0ms	0ms	0ms	0ms
	13	0	0	0	0	0ms	0ms	0ms	0ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Dec 18	12	44,359	140,760	3.17	28.97%
	13	0	0	0.00	0.00%

Day	Hour	Count	Average / Second
Dec 18	12	7,114	1.98/s
	13	0	0.00/s

Day	Hour	Count	Average Duration	Average idle time
Dec 18	12	7,100	15s595ms	14s353ms
	13	0	0ms	0ms

↑ Back to the top of the General Activity table

Established Connections

Key values

72 connections Connection Peak
2025-12-18 12:31:39 Date

Connections per database

Key values

acaweb_fx Main Database
7,114 connections Total

Chart
Table

Database	User	Count
acaweb_fx		7,014
	postgres	6,627
	psql	387
socialmedia		100
	postgres	100

Connections per user

Key values

postgres Main User
7,114 connections Total

Chart
Table

User	Count
postgres	6,727
psql	387

Connections per host

Key values

192.168.0.74 Main host with 2807 connections
7,114 Total connections

Chart
Table

Host	Count
127.0.0.1	113
182.165.1.42	1
192.168.0.114	7
192.168.0.216	102
192.168.0.236	2
192.168.0.42	1
192.168.0.74	2,807
192.168.1.127	1
192.168.1.145	55
192.168.1.15	1,605
192.168.1.20	90
192.168.1.239	33
192.168.1.90	65
192.168.2.126	63
192.168.2.182	12
192.168.2.82	48
192.168.3.199	36
192.168.4.142	1,340
192.168.4.150	10
192.168.4.17	4
192.168.4.21	1
192.168.4.238	16
192.168.4.33	94
192.168.4.94	4
192.168.4.98	330
[local]	274

Simultaneous sessions

Key values

16 sessions Session Peak
2025-12-18 12:31:08 Date

Histogram of session times

Key values

5,987 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	5,987	84.32%
500ms-1s	292	4.11%
1s-30s	588	8.28%
30s-1m	102	1.44%
1m-10m	80	1.13%
10m-30m	42	0.59%
30m-1h	5	0.07%
1h-8h	4	0.06%
> 8h	0	0.00%

Sessions per database

Key values

acaweb_fx Main Database
7,100 sessions Total

Chart
Table

Database	User	Count	Total Duration	Average Duration
acaweb_fx	7,000	1d5h52m33s	15s364ms
socialmedia	100	52m54s	31s741ms

Sessions per user

Key values

postgres Main User
7,100 sessions Total

Chart
Table

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

Sessions per host

Key values

192.168.0.74 Main Host
7,100 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	113	12s4ms	106ms
192.168.0.114	7	46m51s	6m41s
192.168.0.216	102	1m43s	1s10ms
192.168.0.74	2,807	6h2m57s	7s758ms
192.168.1.127	1	118ms	118ms
192.168.1.145	55	4h21m27s	4m45s
192.168.1.15	1,605	5h23m41s	12s100ms
192.168.1.20	90	13h32m54s	9m1s
192.168.1.239	33	278ms	8ms
192.168.1.90	65	36s408ms	560ms
192.168.2.126	63	7s650ms	121ms
192.168.2.182	12	897ms	74ms
192.168.2.82	48	31s318ms	652ms
192.168.3.199	36	1s279ms	35ms
192.168.4.142	1,340	13m40s	612ms
192.168.4.17	4	22s696ms	5s674ms
192.168.4.21	1	208ms	208ms
192.168.4.238	16	20s269ms	1s266ms
192.168.4.33	94	16m2s	10s244ms
192.168.4.94	4	39ms	9ms
192.168.4.98	330	14s823ms	44ms
[local]	274	3m40s	805ms

Sessions per application

Key values

unknown Main Host
7,100 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
unknown	7,100	1d6h45m27s	15s595ms

Checkpoints Buffers

Key values

12,319 buffers Checkpoint Peak
2025-12-18 12:05:18 Date
210.033 seconds Highest write time
0.015 seconds Sync time

Checkpoints Wal files

Key values

5 files Wal files usage Peak
2025-12-18 12:10:18 Date

Checkpoints distance

Key values

159.26 Mo Distance Peak
2025-12-18 12:10:18 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Dec 18	12	59,182	2,051.756s	0.07s	2,052.163s
	13	0	0s	0s	0s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Dec 18	12	0	0	27	2,083	0.007s	0s
	13	0	0	0	0	0s	0s

Day	Hour	Count	Avg time (sec)
Dec 18	12	0	0s
	13	0	0s

Day	Hour	Mean distance	Mean estimate
Dec 18	12	36,338.42 kB	62,940.50 kB
	13	0.00 kB	0.00 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (12) Main checkpoint cause
12 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	12
Total	12

Size of temporary files

Key values

184.05 MiB Temp Files size Peak
2025-12-18 12:50:07 Date

Number of temporary files

Key values

31 per second Temp Files Peak
2025-12-18 12:17:14 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Dec 18	12	637	4.82 GiB	7.75 MiB
	13	0	0	0

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	30	1.66 GiB	3.52 MiB	198.34 MiB	56.59 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = ? ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = ? ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = ?) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, ?::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> ? ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = ?) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = ? where (ok.r is null or ok.r = ?) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = ?) and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > ? ? and last.eventtimestamp > current_timestamp - interval ? and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval ?) and last.eventtimestamp > current_timestamp - interval ? and broker.r = ?; with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; Date: 2025-12-18 12:50:05 Duration: 0ms
2	20	174.65 MiB	8.72 MiB	8.74 MiB	8.73 MiB	jr.resultuid as resultuid, jr.direction as direction, jr.patternendtime as identified, jr.patternlengthbars as length, jr.patternstarttime as patternstarttime, case when jr.trendchangeid = ? then ? else ? end as trendchange, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, jp.patternname as pattern_name, dtt.timezone as timezone, ? as age, cps.pip, g.basegroupname from japsticks_results jr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = jr.symbolid inner join relevance_japsticks_results rar on rar.resultuid = jr.resultuid inner join symbols s on jr.symbolid = s.symbolid and s.nonliquid = ? inner join japsticks_patterns jp on jr.patternid = jp.id inner join downloadersymbolsettings dss on jr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on s.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where jr.gmttimefound > now() - interval ? and s.deleted = ? and (jr.simulation = ? or jr.simulation is null) and (rar.relevant = ?) --and (semicolon_age = ? or rar.age <= semicolon_age) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or jp.patternname in (...)) and (? = ? or jr.patternlengthbars <= ?) ), results as ( select distinct on (symbolid) * from all_results order by symbolid, resultuid ) select * from results order by identified desc, length desc ; jr.resultuid AS resultuid, jr.direction AS direction, jr.patternendtime AS identified, jr.patternlengthbars AS length, jr.patternstarttime AS patternstarttime, case when jr.trendchangeid = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; Date: 2025-12-18 12:52:39 Duration: 0ms
3	20	63.66 MiB	3.12 MiB	3.25 MiB	3.18 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: 2025-12-18 12:47:40 Duration: 0ms
4	16	502.73 MiB	31.41 MiB	31.42 MiB	31.42 MiB	update solr_relevance_old set new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total from ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total from whatshot_probability where type = ?) sub where result_uid = sub.resultuid; UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type = 'cp') sub WHERE result_uid = sub.resultuid; Date: 2025-12-18 12:48:12 Duration: 0ms
5	16	1.10 GiB	70.57 MiB	70.58 MiB	70.58 MiB	with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit ?) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then ? else ? end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then ? else ? end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike ? inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike ?) sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike ?; update solr_relevance_old set newrelevant = ? where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike ? and a.resultuid is null); update solr_relevance_old set new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total from ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total from whatshot_probability where type in (...)) sub where result_uid = sub.resultuid; with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid; Date: 2025-12-18 12:48:15 Duration: 0ms
6	8	950.22 MiB	118.74 MiB	118.80 MiB	118.78 MiB	select updateresultsmaterializedview (); select updateresultsmaterializedview (); Date: 2025-12-18 12:50:32 Duration: 0ms
7	4	230.06 MiB	57.43 MiB	57.65 MiB	57.51 MiB	select updateageforrelevantresults (); select updateageforrelevantresults (); Date: 2025-12-18 12:02:06 Duration: 0ms
8	2	11.85 MiB	5.92 MiB	5.92 MiB	5.92 MiB	select count() from ( select from patternresultsage pa inner join relevance_autochartist_results a on pa.resultuid = a.resultuid where pa.type = ? and abs(pa.age - a.age) > ? union all select * from patternresultsage pa inner join relevance_fibonacci_results a on pa.resultuid = a.resultuid where pa.type = ? and abs(pa.age - a.age) > ? union all select * from patternresultsage pa inner join relevance_keylevels_results a on pa.resultuid = a.resultuid where pa.type = ? and abs(pa.age - a.age) > ? union all select * from patternresultsage pa inner join relevance_consecutivecandles_results a on pa.resultuid = a.resultuid where pa.type = ? and abs(pa.age - a.age) > ? union all select * from patternresultsage pa inner join relevance_bigmovement_results a on pa.resultuid = a.resultuid where pa.type = ? and abs(pa.age - a.age) > ?) a; select count() from ( select from patternresultsage pa inner join relevance_autochartist_results a on pa.resultuid = a.resultuid where pa.type = 0 and abs(pa.age - a.age) > 1 union all select * from patternresultsage pa inner join relevance_fibonacci_results a on pa.resultuid = a.resultuid where pa.type = 1 and abs(pa.age - a.age) > 1 union all select * from patternresultsage pa inner join relevance_keylevels_results a on pa.resultuid = a.resultuid where pa.type = 2 and abs(pa.age - a.age) > 1 union all select * from patternresultsage pa inner join relevance_consecutivecandles_results a on pa.resultuid = a.resultuid where pa.type = 4 and abs(pa.age - a.age) > 1 union all select * from patternresultsage pa inner join relevance_bigmovement_results a on pa.resultuid = a.resultuid where pa.type = 5 and abs(pa.age - a.age) > 1) a; Date: 2025-12-18 12:25:01 Duration: 0ms
9	1	8.72 MiB	8.72 MiB	8.72 MiB	8.72 MiB	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 = ?; 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 = $1 AND bsl.symbolid = s.symbolid LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = $2 AND bim.TYPE = 'OUTBOUND' WHERE s.symbolid = $3; Date: 2025-12-18 12:02:39 Duration: 0ms

Queries generating the largest temporary files

Rank	Size	Query
1	198.34 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2025-12-18 12:30:04 ]
2	187.52 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2025-12-18 12:00:05 ]
3	163.68 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2025-12-18 12:20:05 ]
4	122.22 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2025-12-18 12:40:04 ]
5	118.80 MiB	select updateresultsmaterializedview (); [ Date: 2025-12-18 12:02:16 ]
6	118.79 MiB	select updateresultsmaterializedview (); [ Date: 2025-12-18 12:47:19 ]
7	118.79 MiB	select updateresultsmaterializedview (); [ Date: 2025-12-18 12:17:19 ]
8	118.79 MiB	select updateresultsmaterializedview (); [ Date: 2025-12-18 12:32:22 ]
9	118.77 MiB	select updateresultsmaterializedview (); [ Date: 2025-12-18 12:50:32 ]
10	118.77 MiB	select updateresultsmaterializedview (); [ Date: 2025-12-18 12:35:32 ]
11	118.77 MiB	select updateresultsmaterializedview (); [ Date: 2025-12-18 12:20:32 ]
12	118.74 MiB	select updateresultsmaterializedview (); [ Date: 2025-12-18 12:05:33 ]
13	118.30 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2025-12-18 12:10:04 ]
14	91.86 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2025-12-18 12:10:05 ]
15	85.84 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2025-12-18 12:50:04 ]
16	81.86 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2025-12-18 12:50:04 ]
17	75.19 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2025-12-18 12:40:05 ]
18	70.58 MiB	with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid; [ Date: 2025-12-18 12:11:15 ]
19	70.58 MiB	with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid; [ Date: 2025-12-18 12:16:15 ]
20	70.58 MiB	with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid; [ Date: 2025-12-18 12:18:15 ]

Vacuums / Analyzes Distribution

Key values

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

Analyzes per table

Key values

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

Chart
Table

Table	Number of analyzes
acaweb_fx.public.solr_relevance_old	16
acaweb_fx.pg_catalog.pg_attribute	5
acaweb_fx.public.datafeeds_latestrun	4
acaweb_fx.public.relevance_keylevels_results	4
acaweb_fx.pg_catalog.pg_class	4
acaweb_fx.public.relevance_fibonacci_results	4
acaweb_fx.pg_catalog.pg_type	4
acaweb_fx.public.relevance_autochartist_results	4
acaweb_fx.pg_catalog.pg_index	2
acaweb_fx.public.latest_t15_candle_view	2
acaweb_fx.public.autochartist_symbolupdates	1
acaweb_fx.pg_catalog.pg_depend	1
acaweb_fx.public.latest_candle_datetime_per_receng	1
acaweb_fx.public.relevance_consecutivecandles_results	1
acaweb_fx.public.symbollatestupdatetime	1
socialmedia.public.processstatevariables	1
Total	55

Vacuums per table

Key values

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

Chart
Table

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
acaweb_fx.public.solr_relevance_old	16	16	13,274	0	83	0	0	9,584	2,196	9,831,909
acaweb_fx.public.datafeeds_latestrun	5	0	586	0	15	0	0	73	13	79,332
acaweb_fx.pg_toast.pg_toast_2619	2	2	282	0	54	0	0	224	54	243,724
acaweb_fx.public.relevance_keylevels_results	2	2	8,422	0	406	4	120	2,630	377	988,133
acaweb_fx.public.relevance_autochartist_results	2	2	7,162	0	283	0	484	1,766	274	588,379
acaweb_fx.public.relevance_fibonacci_results	2	2	2,598	0	102	2	107	480	85	164,278
acaweb_fx.pg_catalog.pg_type	1	1	133	0	21	0	0	48	16	112,366
acaweb_fx.public.autochartist_symbolupdates	1	1	26,589	0	716	6	37,409	8,212	599	709,776
acaweb_fx.pg_catalog.pg_attribute	1	1	824	0	184	0	67	368	145	838,897
acaweb_fx.pg_catalog.pg_statistic	1	1	1,002	0	157	0	582	476	140	553,006
acaweb_fx.public.relevance_consecutivecandles_results	1	1	74	0	6	0	0	22	4	24,387
acaweb_fx.public.latest_t15_candle_view	1	1	66	0	1	0	0	6	4	11,707
acaweb_fx.pg_catalog.pg_class	1	1	460	0	39	0	0	151	38	222,024
Total	36	31	61,472	43,799	2,067	12	38,769	24,040	3,945	14,367,918

Tuples removed per table

Key values

public.solr_relevance_old (66952) Main table with removed tuples on database acaweb_fx
79520 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
acaweb_fx.public.solr_relevance_old	16	16	66,952	90,360	0	0	3,231
acaweb_fx.public.autochartist_symbolupdates	1	1	5,497	56,706	589	0	40,691
acaweb_fx.public.relevance_keylevels_results	2	2	2,710	24,039	0	0	558
acaweb_fx.public.relevance_autochartist_results	2	2	1,454	17,224	0	0	760
acaweb_fx.pg_catalog.pg_attribute	1	1	1,349	10,679	137	16	240
acaweb_fx.pg_catalog.pg_statistic	1	1	537	3,688	0	0	1,194
acaweb_fx.public.datafeeds_latestrun	5	0	277	81	11	0	80
acaweb_fx.public.relevance_fibonacci_results	2	2	273	2,389	0	0	204
acaweb_fx.pg_catalog.pg_class	1	1	165	1,647	5	0	150
acaweb_fx.pg_toast.pg_toast_2619	2	2	141	337	2	0	106
acaweb_fx.public.relevance_consecutivecandles_results	1	1	66	274	0	0	7
acaweb_fx.public.latest_t15_candle_view	1	1	62	14	0	0	1
acaweb_fx.pg_catalog.pg_type	1	1	37	1,435	3	0	38
Total	36	31	79,520	208,873	747	16	47,260

Pages removed per table

Key values

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

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
acaweb_fx.pg_catalog.pg_attribute	1	1	1349	16
acaweb_fx.pg_toast.pg_toast_2619	2	2	141	0
acaweb_fx.pg_catalog.pg_type	1	1	37	0
acaweb_fx.public.datafeeds_latestrun	5	0	277	0
acaweb_fx.public.autochartist_symbolupdates	1	1	5497	0
acaweb_fx.pg_catalog.pg_statistic	1	1	537	0
acaweb_fx.public.relevance_consecutivecandles_results	1	1	66	0
acaweb_fx.public.latest_t15_candle_view	1	1	62	0
acaweb_fx.public.relevance_keylevels_results	2	2	2710	0
acaweb_fx.pg_catalog.pg_class	1	1	165	0
acaweb_fx.public.solr_relevance_old	16	16	66952	0
acaweb_fx.public.relevance_autochartist_results	2	2	1454	0
acaweb_fx.public.relevance_fibonacci_results	2	2	273	0
Total	36	31	79,520	16

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Dec 18	12	36	55
	13	0	0

↑ 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

106,545 Total read queries
46,564 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	106,545	32.17%
INSERT	32,228	9.73%
UPDATE	2,334	0.70%
DELETE	16	0.00%
COPY FROM	96	0.03%
COPY TO	26	0.01%
CTE	11,038	3.33%
DDL	16	0.00%
TCL	810	0.24%
CURSOR	0	0.00%
OTHERS	178,053	53.77%

Queries by database

Key values

unknown Main database
330,112 Requests
2h26m59s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
acaweb_fx	Total	950	0ms
	copy from	80	0ms
	copy to	26	0ms
	cte	104	0ms
	ddl	16	0ms
	delete	16	0ms
	others	235	0ms
	select	102	0ms
	tcl	332	0ms
	update	39	0ms
socialmedia	Total	100	0ms
	others	1	0ms
	select	94	0ms
	tcl	5	0ms
unknown	Total	330,112	2h26m59s
	copy from	16	0ms
	cte	10,934	0ms
	insert	32,228	0ms
	others	12,237	0ms
	select	106,349	0ms
	tcl	473	0ms
	update	2,295	0ms

Queries by user

Key values

unknown Main user
330,112 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	1,050	0ms
	copy from	80	0ms
	copy to	26	0ms
	cte	104	0ms
	ddl	16	0ms
	delete	16	0ms
	others	236	0ms
	select	196	0ms
	tcl	337	0ms
	update	39	0ms
unknown	Total	330,112	2h26m59s
	copy from	16	0ms
	cte	10,934	0ms
	insert	32,228	0ms
	others	12,237	0ms
	select	106,349	0ms
	tcl	473	0ms
	update	2,295	0ms

Duration by user

Key values

2h26m59s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	1,050	0ms
	copy from	80	0ms
	copy to	26	0ms
	cte	104	0ms
	ddl	16	0ms
	delete	16	0ms
	others	236	0ms
	select	196	0ms
	tcl	337	0ms
	update	39	0ms
unknown	Total	330,112	2h26m59s
	copy from	16	0ms
	cte	10,934	0ms
	insert	32,228	0ms
	others	12,237	0ms
	select	106,349	0ms
	tcl	473	0ms
	update	2,295	0ms

Queries by host

Key values

unknown Main host
331,162 Requests
2h26m59s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	331,162	2h26m59s
	copy from	96	0ms
	copy to	26	0ms
	cte	11,038	0ms
	ddl	16	0ms
	delete	16	0ms
	insert	32,228	0ms
	others	12,473	0ms
	select	106,545	0ms
	tcl	810	0ms
	update	2,334	0ms

Queries by application

Key values

unknown Main application
330,775 Requests
2h26m59s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
psql	Total	387	0ms
	copy from	80	0ms
	copy to	26	0ms
	cte	104	0ms
	ddl	16	0ms
	delete	16	0ms
	others	4	0ms
	select	102	0ms
	update	39	0ms
unknown	Total	330,775	2h26m59s
	copy from	16	0ms
	cte	10,934	0ms
	insert	32,228	0ms
	others	12,469	0ms
	select	106,443	0ms
	tcl	810	0ms
	update	2,295	0ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-12-18 12:37:36 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

109,546 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	109,546	66.16%
1-5ms	51,817	31.29%
5-10ms	1,673	1.01%
10-25ms	514	0.31%
25-50ms	259	0.16%
50-100ms	139	0.08%
100-500ms	352	0.21%
500-1000ms	139	0.08%
1000-10000ms	859	0.52%
> 10000ms	282	0.17%

Slowest individual queries

Rank	Duration	Query
NO DATASET

Time consuming queries

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

0ms

3

Details

0ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 18	12	3	0ms	0ms

2

0ms

61

Details

0ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 18	12	61	0ms	0ms

3

0ms

262

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

Day	Hour	Count	Duration	Avg duration
Dec 18	12	262	0ms	0ms

4

0ms

3

Details

0ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 18	12	3	0ms	0ms

5

0ms

12

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

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

6

0ms

2,196

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

Day	Hour	Count	Duration	Avg duration
Dec 18	12	2,196	0ms	0ms

7

0ms

48

Details

0ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 18	12	48	0ms	0ms

8

0ms

4

Details

0ms

select updaterelevantforrelevantresults ();

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 18	12	4	0ms	0ms

9

0ms

25

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

Day	Hour	Count	Duration	Avg duration
Dec 18	12	25	0ms	0ms

10

0ms

1

Details

0ms

set datestyle = iso;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 18	12	1	0ms	0ms

11

0ms

1,649

Details

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 18	12	1,649	0ms	0ms

12

0ms

30

Details

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 18	12	30	0ms	0ms

13

0ms

1

Details

0ms

set client_encoding to ?;

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 18	12	1	0ms	0ms

14

0ms

2

Details

0ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 18	12	2	0ms	0ms

15

0ms

1

Details

0ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Dec 18	12	1	0ms	0ms

16

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

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

17

0ms

4

Details

0ms

select category, name, sum(total) as total, sum(correct) as correct, (cast(sum(correct) as float) / cast(sum(total) as float)) * ?.? as percentage, min("from") AS "from", max("to") AS "to" from ( select category, name, total, correct, percentage, "from", "to" from stats_summary where statsid = ? and category = lower(?) and name in (...) union select category, name, total, correct, percentage, "from", "to" from stats_hrs_summary where statsid = ? and category = lower(?) and name in (...) order by correct desc) as summdata group by category, name having sum(total) > ? order by name;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 18	12	4	0ms	0ms

18

0ms

66

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

Day	Hour	Count	Duration	Avg duration
Dec 18	12	66	0ms	0ms

19

0ms

1

Details

0ms

select distinct s.statsid as statsid, sy.exchange as name from stats s inner join broker b on s.brokerid = b.brokerid inner join brokerconfig bc on b.brokerid = bc.brokerid inner join stats_symbols ss on s.statsid = ss.statsid inner join downloadersymbolsettings dss on ss.symbolid = dss.symbolid inner join symbols sy on dss.symbolid = sy.symbolid where dss.enabled = ? and s.brokerid is not null and b.brokerid = ? and s.groupingtype ilike ? and s.description ilike ? || b.name || ? and s.description ilike ? || sy.exchange || ? and s.description not ilike ? || ? || ? union all select distinct s.statsid as statsid, basegroupname as name from stats s inner join broker b on s.brokerid = b.brokerid inner join brokerconfig bc on b.brokerid = bc.brokerid inner join stats_symbols ss on s.statsid = ss.statsid inner join downloadersymbolsettings dss on ss.symbolid = dss.symbolid inner join symbolgroup sg on dss.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bg.brokerid = b.brokerid where dss.enabled = ? and s.brokerid is not null and b.brokerid = ? and s.groupingtype not ilike ? and s.description ilike ? || b.name || ? and s.description ilike ? || g.basegroupname || ? and s.description not ilike ? || ? || ?;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 18	12	1	0ms	0ms

20

0ms

1

Details

0ms

update executions set isrunning = false, has_results = true, response = ? 'Connor Boulevard, Irving, TX, United States, ? ", " Phone ": " ? ? ? ", " WebURL ": " https: // www.caterpillar.com ", " LogoURL ": " https: // eodhistoricaldata.com / img / logos / US / Cat.png ", " FullTimeEmployees ": ?, " UpdatedAt ": " ? - 12 - 17 ", " MarketCapitalization ": ?, " MarketCapitalizationMln ": ?.?, " EBITDA ": ?, " PERatio ": ?.?, " PEGRatio ": ?.?, " WallStreetTargetPrice ": ?.?, " BookValue ": ?.?, " DividendShare ": ?.?, " DividendYield ": ?.?, " EarningsShare ": ?.?, " EPSEstimateCurrentYear ": ?.?, " EPSEstimateNextYear ": ?.?, " EPSEstimateNextQuarter ": ?.?, " EPSEstimateCurrentQuarter ": ?.?, " MostRecentQuarter ": " ? - 09 - 30 ", " ProfitMargin ": ?.?, " OperatingMarginTTM ": ?.?, " ReturnOnAssetsTTM ": ?.?, " ReturnOnEquityTTM ": ?.?, " RevenueTTM ": ?, " RevenuePerShareTTM ": ?.?, " QuarterlyRevenueGrowthYOY ": ?.?, " GrossProfitTTM ": ?, " DilutedEpsTTM ": ?.?, " QuarterlyEarningsGrowthYOY ": ?.? }, " ? ": { " earningsimpactid ": " % % OBJNAME ? % % earningsimpactid.visible ": false, " sample_size ": " % % OBJNAME ? % % sample_size.visible ": false, " impactcompany ": " % % OBJNAME ? % % impactcompany.visible ": false, " impactcompany_name ": " % % OBJNAME ? % % impactcompany_name.visible ": false, " impactcompany_sector ": " % % OBJNAME ? % % impactcompany_sector.visible ": false, " impactcompany_industry ": " % % OBJNAME ? % % impactcompany_industry.visible ": false, " opportunities ": " % % OBJNAME ? % % opportunities.visible ": false, " Code ": " % % OBJNAME ? % % Code.visible ": false, " Type ": " % % OBJNAME ? % % Type.visible ": false, " Name ": " % % OBJNAME ? % % Name.visible ": false, " Exchange ": " % % OBJNAME ? % % Exchange.visible ": false, " CurrencyCode ": " % % OBJNAME ? % % CurrencyCode.visible ": false, " CurrencyName ": " % % OBJNAME ? % % CurrencyName.visible ": false, " CurrencySymbol ": " % % OBJNAME ? % % CurrencySymbol.visible ": false, " CountryName ": " % % OBJNAME ? % % CountryName.visible ": false, " CountryISO ": " % % OBJNAME ? % % CountryISO.visible ": false, " OpenFigi ": " % % OBJNAME ? % % OpenFigi.visible ": false, " ISIN ": " % % OBJNAME ? % % ISIN.visible ": false, " LEI ": " % % OBJNAME ? % % LEI.visible ": false, " PrimaryTicker ": " % % OBJNAME ? % % PrimaryTicker.visible ": false, " CUSIP ": " % % OBJNAME ? % % CUSIP.visible ": false, " CIK ": " % % OBJNAME ? % % CIK.visible ": false, " EmployerIdNumber ": " % % OBJNAME ? % % EmployerIdNumber.visible ": false, " FiscalYearEnd ": " % % OBJNAME ? % % FiscalYearEnd.visible ": false, " IPODate ": " % % OBJNAME ? % % IPODate.visible ": false, " InternationalDomestic ": " % % OBJNAME ? % % InternationalDomestic.visible ": false, " Sector ": " % % OBJNAME ? % % Sector.visible ": false, " Industry ": " % % OBJNAME ? % % Industry.visible ": false, " GicSector ": " % % OBJNAME ? % % GicSector.visible ": false, " GicGroup ": " % % OBJNAME ? % % GicGroup.visible ": false, " GicIndustry ": " % % OBJNAME ? % % GicIndustry.visible ": false, " GicSubIndustry ": " % % OBJNAME ? % % GicSubIndustry.visible ": false, " HomeCategory ": " % % OBJNAME ? % % HomeCategory.visible ": false, " IsDelisted ": " % % OBJNAME ? % % IsDelisted.visible ": false, " Description ": " % % OBJNAME ? % % Description.visible ": false, " Address ": " % % OBJNAME ? % % Address.visible ": false, " Phone ": " % % OBJNAME ? % % Phone.visible ": false, " WebURL ": " % % OBJNAME ? % % WebURL.visible ": false, " LogoURL ": " % % OBJNAME ? % % LogoURL.visible ": false, " FullTimeEmployees ": " % % OBJNAME ? % % FullTimeEmployees.visible ": false, " UpdatedAt ": " % % OBJNAME ? % % UpdatedAt.visible ": false, " MarketCapitalization ": " % % OBJNAME ? % % MarketCapitalization.visible ": false, " MarketCapitalizationMln ": " % % OBJNAME ? % % MarketCapitalizationMln.visible ": false, " EBITDA ": " % % OBJNAME ? % % EBITDA.visible ": false, " PERatio ": " % % OBJNAME ? % % PERatio.visible ": false, " PEGRatio ": " % % OBJNAME ? % % PEGRatio.visible ": false, " WallStreetTargetPrice ": " % % OBJNAME ? % % WallStreetTargetPrice.visible ": false, " BookValue ": " % % OBJNAME ? % % BookValue.visible ": false, " DividendShare ": " % % OBJNAME ? % % DividendShare.visible ": false, " DividendYield ": " % % OBJNAME ? % % DividendYield.visible ": false, " EarningsShare ": " % % OBJNAME ? % % EarningsShare.visible ": false, " EPSEstimateCurrentYear ": " % % OBJNAME ? % % EPSEstimateCurrentYear.visible ": false, " EPSEstimateNextYear ": " % % OBJNAME ? % % EPSEstimateNextYear.visible ": false, " EPSEstimateNextQuarter ": " % % OBJNAME ? % % EPSEstimateNextQuarter.visible ": false, " EPSEstimateCurrentQuarter ": " % % OBJNAME ? % % EPSEstimateCurrentQuarter.visible ": false, " MostRecentQuarter ": " % % OBJNAME ? % % MostRecentQuarter.visible ": false, " ProfitMargin ": " % % OBJNAME ? % % ProfitMargin.visible ": false, " OperatingMarginTTM ": " % % OBJNAME ? % % OperatingMarginTTM.visible ": false, " ReturnOnAssetsTTM ": " % % OBJNAME ? % % ReturnOnAssetsTTM.visible ": false, " ReturnOnEquityTTM ": " % % OBJNAME ? % % ReturnOnEquityTTM.visible ": false, " RevenueTTM ": " % % OBJNAME ? % % RevenueTTM.visible ": false, " RevenuePerShareTTM ": " % % OBJNAME ? % % RevenuePerShareTTM.visible ": false, " QuarterlyRevenueGrowthYOY ": " % % OBJNAME ? % % QuarterlyRevenueGrowthYOY.visible ": false, " GrossProfitTTM ": " % % OBJNAME ? % % GrossProfitTTM.visible ": false, " DilutedEpsTTM ": " % % OBJNAME ? % % DilutedEpsTTM.visible ": false, " QuarterlyEarningsGrowthYOY ": " % % OBJNAME ? % % QuarterlyEarningsGrowthYOY.visible ": false, " Shape.visible ": false, " bgshape.visible ": false }, " ? ": { " earningsimpactid ": " % % OBJNAME ? % % earningsimpactid.visible ": false, " sample_size ": " % % OBJNAME ? % % sample_size.visible ": false, " impactcompany ": " % % OBJNAME ? % % impactcompany.visible ": false, " impactcompany_name ": " % % OBJNAME ? % % impactcompany_name.visible ": false, " impactcompany_sector ": " % % OBJNAME ? % % impactcompany_sector.visible ": false, " impactcompany_industry ": " % % OBJNAME ? % % impactcompany_industry.visible ": false, " opportunities ": " % % OBJNAME ? % % opportunities.visible ": false, " Code ": " % % OBJNAME ? % % Code.visible ": false, " Type ": " % % OBJNAME ? % % Type.visible ": false, " Name ": " % % OBJNAME ? % % Name.visible ": false, " Exchange ": " % % OBJNAME ? % % Exchange.visible ": false, " CurrencyCode ": " % % OBJNAME ? % % CurrencyCode.visible ": false, " CurrencyName ": " % % OBJNAME ? % % CurrencyName.visible ": false, " CurrencySymbol ": " % % OBJNAME ? % % CurrencySymbol.visible ": false, " CountryName ": " % % OBJNAME ? % % CountryName.visible ": false, " CountryISO ": " % % OBJNAME ? % % CountryISO.visible ": false, " OpenFigi ": " % % OBJNAME ? % % OpenFigi.visible ": false, " ISIN ": " % % OBJNAME ? % % ISIN.visible ": false, " LEI ": " % % OBJNAME ? % % LEI.visible ": false, " PrimaryTicker ": " % % OBJNAME ? % % PrimaryTicker.visible ": false, " CUSIP ": " % % OBJNAME ? % % CUSIP.visible ": false, " CIK ": " % % OBJNAME ? % % CIK.visible ": false, " EmployerIdNumber ": " % % OBJNAME ? % % EmployerIdNumber.visible ": false, " FiscalYearEnd ": " % % OBJNAME ? % % FiscalYearEnd.visible ": false, " IPODate ": " % % OBJNAME ? % % IPODate.visible ": false, " InternationalDomestic ": " % % OBJNAME ? % % InternationalDomestic.visible ": false, " Sector ": " % % OBJNAME ? % % Sector.visible ": false, " Industry ": " % % OBJNAME ? % % Industry.visible ": false, " GicSector ": " % % OBJNAME ? % % GicSector.visible ": false, " GicGroup ": " % % OBJNAME ? % % GicGroup.visible ": false, " GicIndustry ": " % % OBJNAME ? % % GicIndustry.visible ": false, " GicSubIndustry ": " % % OBJNAME ? % % GicSubIndustry.visible ": false, " HomeCategory ": " % % OBJNAME ? % % HomeCategory.visible ": false, " IsDelisted ": " % % OBJNAME ? % % IsDelisted.visible ": false, " Description ": " % % OBJNAME ? % % Description.visible ": false, " Address ": " % % OBJNAME ? % % Address.visible ": false, " Phone ": " % % OBJNAME ? % % Phone.visible ": false, " WebURL ": " % % OBJNAME ? % % WebURL.visible ": false, " LogoURL ": " % % OBJNAME ? % % LogoURL.visible ": false, " FullTimeEmployees ": " % % OBJNAME ? % % FullTimeEmployees.visible ": false, " UpdatedAt ": " % % OBJNAME ? % % UpdatedAt.visible ": false, " MarketCapitalization ": " % % OBJNAME ? % % MarketCapitalization.visible ": false, " MarketCapitalizationMln ": " % % OBJNAME ? % % MarketCapitalizationMln.visible ": false, " EBITDA ": " % % OBJNAME ? % % EBITDA.visible ": false, " PERatio ": " % % OBJNAME ? % % PERatio.visible ": false, " PEGRatio ": " % % OBJNAME ? % % PEGRatio.visible ": false, " WallStreetTargetPrice ": " % % OBJNAME ? % % WallStreetTargetPrice.visible ": false, " BookValue ": " % % OBJNAME ? % % BookValue.visible ": false, " DividendShare ": " % % OBJNAME ? % % DividendShare.visible ": false, " DividendYield ": " % % OBJNAME ? % % DividendYield.visible ": false, " EarningsShare ": " % % OBJNAME ? % % EarningsShare.visible ": false, " EPSEstimateCurrentYear ": " % % OBJNAME ? % % EPSEstimateCurrentYear.visible ": false, " EPSEstimateNextYear ": " % % OBJNAME ? % % EPSEstimateNextYear.visible ": false, " EPSEstimateNextQuarter ": " % % OBJNAME ? % % EPSEstimateNextQuarter.visible ": false, " EPSEstimateCurrentQuarter ": " % % OBJNAME ? % % EPSEstimateCurrentQuarter.visible ": false, " MostRecentQuarter ": " % % OBJNAME ? % % MostRecentQuarter.visible ": false, " ProfitMargin ": " % % OBJNAME ? % % ProfitMargin.visible ": false, " OperatingMarginTTM ": " % % OBJNAME ? % % OperatingMarginTTM.visible ": false, " ReturnOnAssetsTTM ": " % % OBJNAME ? % % ReturnOnAssetsTTM.visible ": false, " ReturnOnEquityTTM ": " % % OBJNAME ? % % ReturnOnEquityTTM.visible ": false, " RevenueTTM ": " % % OBJNAME ? % % RevenueTTM.visible ": false, " RevenuePerShareTTM ": " % % OBJNAME ? % % RevenuePerShareTTM.visible ": false, " QuarterlyRevenueGrowthYOY ": " % % OBJNAME ? % % QuarterlyRevenueGrowthYOY.visible ": false, " GrossProfitTTM ": " % % OBJNAME ? % % GrossProfitTTM.visible ": false, " DilutedEpsTTM ": " % % OBJNAME ? % % DilutedEpsTTM.visible ": false, " QuarterlyEarningsGrowthYOY ": " % % OBJNAME ? % % QuarterlyEarningsGrowthYOY.visible ": false, " Shape.visible ": false, " bgshape.visible ": false }, " ? ": { " earningsimpactid ": " % % OBJNAME ? % % earningsimpactid.visible ": false, " sample_size ": " % % OBJNAME ? % % sample_size.visible ": false, " impactcompany ": " % % OBJNAME ? % % impactcompany.visible ": false, " impactcompany_name ": " % % OBJNAME ? % % impactcompany_name.visible ": false, " impactcompany_sector ": " % % OBJNAME ? % % impactcompany_sector.visible ": false, " impactcompany_industry ": " % % OBJNAME ? % % impactcompany_industry.visible ": false, " opportunities ": " % % OBJNAME ? % % opportunities.visible ": false, " Code ": " % % OBJNAME ? % % Code.visible ": false, " Type ": " % % OBJNAME ? % % Type.visible ": false, " Name ": " % % OBJNAME ? % % Name.visible ": false, " Exchange ": " % % OBJNAME ? % % Exchange.visible ": false, " CurrencyCode ": " % % OBJNAME ? % % CurrencyCode.visible ": false, " CurrencyName ": " % % OBJNAME ? % % CurrencyName.visible ": false, " CurrencySymbol ": " % % OBJNAME ? % % CurrencySymbol.visible ": false, " CountryName ": " % % OBJNAME ? % % CountryName.visible ": false, " CountryISO ": " % % OBJNAME ? % % CountryISO.visible ": false, " OpenFigi ": " % % OBJNAME ? % % OpenFigi.visible ": false, " ISIN ": " % % OBJNAME ? % % ISIN.visible ": false, " LEI ": " % % OBJNAME ? % % LEI.visible ": false, " PrimaryTicker ": " % % OBJNAME ? % % PrimaryTicker.visible ": false, " CUSIP ": " % % OBJNAME ? % % CUSIP.visible ": false, " CIK ": " % % OBJNAME ? % % CIK.visible ": false, " EmployerIdNumber ": " % % OBJNAME ? % % EmployerIdNumber.visible ": false, " FiscalYearEnd ": " % % OBJNAME ? % % FiscalYearEnd.visible ": false, " IPODate ": " % % OBJNAME ? % % IPODate.visible ": false, " InternationalDomestic ": " % % OBJNAME ? % % InternationalDomestic.visible ": false, " Sector ": " % % OBJNAME ? % % Sector.visible ": false, " Industry ": " % % OBJNAME ? % % Industry.visible ": false, " GicSector ": " % % OBJNAME ? % % GicSector.visible ": false, " GicGroup ": " % % OBJNAME ? % % GicGroup.visible ": false, " GicIndustry ": " % % OBJNAME ? % % GicIndustry.visible ": false, " GicSubIndustry ": " % % OBJNAME ? % % GicSubIndustry.visible ": false, " HomeCategory ": " % % OBJNAME ? % % HomeCategory.visible ": false, " IsDelisted ": " % % OBJNAME ? % % IsDelisted.visible ": false, " Description ": " % % OBJNAME ? % % Description.visible ": false, " Address ": " % % OBJNAME ? % % Address.visible ": false, " Phone ": " % % OBJNAME ? % % Phone.visible ": false, " WebURL ": " % % OBJNAME ? % % WebURL.visible ": false, " LogoURL ": " % % OBJNAME ? % % LogoURL.visible ": false, " FullTimeEmployees ": " % % OBJNAME ? % % FullTimeEmployees.visible ": false, " UpdatedAt ": " % % OBJNAME ? % % UpdatedAt.visible ": false, " MarketCapitalization ": " % % OBJNAME ? % % MarketCapitalization.visible ": false, " MarketCapitalizationMln ": " % % OBJNAME ? % % MarketCapitalizationMln.visible ": false, " EBITDA ": " % % OBJNAME ? % % EBITDA.visible ": false, " PERatio ": " % % OBJNAME ? % % PERatio.visible ": false, " PEGRatio ": " % % OBJNAME ? % % PEGRatio.visible ": false, " WallStreetTargetPrice ": " % % OBJNAME ? % % WallStreetTargetPrice.visible ": false, " BookValue ": " % % OBJNAME ? % % BookValue.visible ": false, " DividendShare ": " % % OBJNAME ? % % DividendShare.visible ": false, " DividendYield ": " % % OBJNAME ? % % DividendYield.visible ": false, " EarningsShare ": " % % OBJNAME ? % % EarningsShare.visible ": false, " EPSEstimateCurrentYear ": " % % OBJNAME ? % % EPSEstimateCurrentYear.visible ": false, " EPSEstimateNextYear ": " % % OBJNAME ? % % EPSEstimateNextYear.visible ": false, " EPSEstimateNextQuarter ": " % % OBJNAME ? % % EPSEstimateNextQuarter.visible ": false, " EPSEstimateCurrentQuarter ": " % % OBJNAME ? % % EPSEstimateCurrentQuarter.visible ": false, " MostRecentQuarter ": " % % OBJNAME ? % % MostRecentQuarter.visible ": false, " ProfitMargin ": " % % OBJNAME ? % % ProfitMargin.visible ": false, " OperatingMarginTTM ": " % % OBJNAME ? % % OperatingMarginTTM.visible ": false, " ReturnOnAssetsTTM ": " % % OBJNAME ? % % ReturnOnAssetsTTM.visible ": false, " ReturnOnEquityTTM ": " % % OBJNAME ? % % ReturnOnEquityTTM.visible ": false, " RevenueTTM ": " % % OBJNAME ? % % RevenueTTM.visible ": false, " RevenuePerShareTTM ": " % % OBJNAME ? % % RevenuePerShareTTM.visible ": false, " QuarterlyRevenueGrowthYOY ": " % % OBJNAME ? % % QuarterlyRevenueGrowthYOY.visible ": false, " GrossProfitTTM ": " % % OBJNAME ? % % GrossProfitTTM.visible ": false, " DilutedEpsTTM ": " % % OBJNAME ? % % DilutedEpsTTM.visible ": false, " QuarterlyEarningsGrowthYOY ": " % % OBJNAME ? % % QuarterlyEarningsGrowthYOY.visible ": false, " Shape.visible ": false, " bgshape.visible ": false }, " ? ": { " earningsimpactid ": " % % OBJNAME ? % % earningsimpactid.visible ": false, " sample_size ": " % % OBJNAME ? % % sample_size.visible ": false, " impactcompany ": " % % OBJNAME ? % % impactcompany.visible ": false, " impactcompany_name ": " % % OBJNAME ? % % impactcompany_name.visible ": false, " impactcompany_sector ": " % % OBJNAME ? % % impactcompany_sector.visible ": false, " impactcompany_industry ": " % % OBJNAME ? % % impactcompany_industry.visible ": false, " opportunities ": " % % OBJNAME ? % % opportunities.visible ": false, " Code ": " % % OBJNAME ? % % Code.visible ": false, " Type ": " % % OBJNAME ? % % Type.visible ": false, " Name ": " % % OBJNAME ? % % Name.visible ": false, " Exchange ": " % % OBJNAME ? % % Exchange.visible ": false, " CurrencyCode ": " % % OBJNAME ? % % CurrencyCode.visible ": false, " CurrencyName ": " % % OBJNAME ? % % CurrencyName.visible ": false, " CurrencySymbol ": " % % OBJNAME ? % % CurrencySymbol.visible ": false, " CountryName ": " % % OBJNAME ? % % CountryName.visible ": false, " CountryISO ": " % % OBJNAME ? % % CountryISO.visible ": false, " OpenFigi ": " % % OBJNAME ? % % OpenFigi.visible ": false, " ISIN ": " % % OBJNAME ? % % ISIN.visible ": false, " LEI ": " % % OBJNAME ? % % LEI.visible ": false, " PrimaryTicker ": " % % OBJNAME ? % % PrimaryTicker.visible ": false, " CUSIP ": " % % OBJNAME ? % % CUSIP.visible ": false, " CIK ": " % % OBJNAME ? % % CIK.visible ": false, " EmployerIdNumber ": " % % OBJNAME ? % % EmployerIdNumber.visible ": false, " FiscalYearEnd ": " % % OBJNAME ? % % FiscalYearEnd.visible ": false, " IPODate ": " % % OBJNAME ? % % IPODate.visible ": false, " InternationalDomestic ": " % % OBJNAME ? % % InternationalDomestic.visible ": false, " Sector ": " % % OBJNAME ? % % Sector.visible ": false, " Industry ": " % % OBJNAME ? % % Industry.visible ": false, " GicSector ": " % % OBJNAME ? % % GicSector.visible ": false, " GicGroup ": " % % OBJNAME ? % % GicGroup.visible ": false, " GicIndustry ": " % % OBJNAME ? % % GicIndustry.visible ": false, " GicSubIndustry ": " % % OBJNAME ? % % GicSubIndustry.visible ": false, " HomeCategory ": " % % OBJNAME ? % % HomeCategory.visible ": false, " IsDelisted ": " % % OBJNAME ? % % IsDelisted.visible ": false, " Description ": " % % OBJNAME ? % % Description.visible ": false, " Address ": " % % OBJNAME ? % % Address.visible ": false, " Phone ": " % % OBJNAME ? % % Phone.visible ": false, " WebURL ": " % % OBJNAME ? % % WebURL.visible ": false, " LogoURL ": " % % OBJNAME ? % % LogoURL.visible ": false, " FullTimeEmployees ": " % % OBJNAME ? % % FullTimeEmployees.visible ": false, " UpdatedAt ": " % % OBJNAME ? % % UpdatedAt.visible ": false, " MarketCapitalization ": " % % OBJNAME ? % % MarketCapitalization.visible ": false, " MarketCapitalizationMln ": " % % OBJNAME ? % % MarketCapitalizationMln.visible ": false, " EBITDA ": " % % OBJNAME ? % % EBITDA.visible ": false, " PERatio ": " % % OBJNAME ? % % PERatio.visible ": false, " PEGRatio ": " % % OBJNAME ? % % PEGRatio.visible ": false, " WallStreetTargetPrice ": " % % OBJNAME ? % % WallStreetTargetPrice.visible ": false, " BookValue ": " % % OBJNAME ? % % BookValue.visible ": false, " DividendShare ": " % % OBJNAME ? % % DividendShare.visible ": false, " DividendYield ": " % % OBJNAME ? % % DividendYield.visible ": false, " EarningsShare ": " % % OBJNAME ? % % EarningsShare.visible ": false, " EPSEstimateCurrentYear ": " % % OBJNAME ? % % EPSEstimateCurrentYear.visible ": false, " EPSEstimateNextYear ": " % % OBJNAME ? % % EPSEstimateNextYear.visible ": false, " EPSEstimateNextQuarter ": " % % OBJNAME ? % % EPSEstimateNextQuarter.visible ": false, " EPSEstimateCurrentQuarter ": " % % OBJNAME ? % % EPSEstimateCurrentQuarter.visible ": false, " MostRecentQuarter ": " % % OBJNAME ? % % MostRecentQuarter.visible ": false, " ProfitMargin ": " % % OBJNAME ? % % ProfitMargin.visible ": false, " OperatingMarginTTM ": " % % OBJNAME ? % % OperatingMarginTTM.visible ": false, " ReturnOnAssetsTTM ": " % % OBJNAME ? % % ReturnOnAssetsTTM.visible ": false, " ReturnOnEquityTTM ": " % % OBJNAME ? % % ReturnOnEquityTTM.visible ": false, " RevenueTTM ": " % % OBJNAME ? % % RevenueTTM.visible ": false, " RevenuePerShareTTM ": " % % OBJNAME ? % % RevenuePerShareTTM.visible ": false, " QuarterlyRevenueGrowthYOY ": " % % OBJNAME ? % % QuarterlyRevenueGrowthYOY.visible ": false, " GrossProfitTTM ": " % % OBJNAME ? % % GrossProfitTTM.visible ": false, " DilutedEpsTTM ": " % % OBJNAME ? % % DilutedEpsTTM.visible ": false, " QuarterlyEarningsGrowthYOY ": " % % OBJNAME ? % % QuarterlyEarningsGrowthYOY.visible ": false, " Shape.visible ": false, " bgshape.visible ": false }, " ? ": { " earningsimpactid ": " % % OBJNAME ? % % earningsimpactid.visible ": false, " sample_size ": " % % OBJNAME ? % % sample_size.visible ": false, " impactcompany ": " % % OBJNAME ? % % impactcompany.visible ": false, " impactcompany_name ": " % % OBJNAME ? % % impactcompany_name.visible ": false, " impactcompany_sector ": " % % OBJNAME ? % % impactcompany_sector.visible ": false, " impactcompany_industry ": " % % OBJNAME ? % % impactcompany_industry.visible ": false, " opportunities ": " % % OBJNAME ? % % opportunities.visible ": false, " Code ": " % % OBJNAME ? % % Code.visible ": false, " Type ": " % % OBJNAME ? % % Type.visible ": false, " Name ": " % % OBJNAME ? % % Name.visible ": false, " Exchange ": " % % OBJNAME ? % % Exchange.visible ": false, " CurrencyCode ": " % % OBJNAME ? % % CurrencyCode.visible ": false, " CurrencyName ": " % % OBJNAME ? % % CurrencyName.visible ": false, " CurrencySymbol ": " % % OBJNAME ? % % CurrencySymbol.visible ": false, " CountryName ": " % % OBJNAME ? % % CountryName.visible ": false, " CountryISO ": " % % OBJNAME ? % % CountryISO.visible ": false, " OpenFigi ": " % % OBJNAME ? % % OpenFigi.visible ": false, " ISIN ": " % % OBJNAME ? % % ISIN.visible ": false, " LEI ": " % % OBJNAME ? % % LEI.visible ": false, " PrimaryTicker ": " % % OBJNAME ? % % PrimaryTicker.visible ": false, " CUSIP ": " % % OBJNAME ? % % CUSIP.visible ": false, " CIK ": " % % OBJNAME ? % % CIK.visible ": false, " EmployerIdNumber ": " % % OBJNAME ? % % EmployerIdNumber.visible ": false, " FiscalYearEnd ": " % % OBJNAME ? % % FiscalYearEnd.visible ": false, " IPODate ": " % % OBJNAME ? % % IPODate.visible ": false, " InternationalDomestic ": " % % OBJNAME ? % % InternationalDomestic.visible ": false, " Sector ": " % % OBJNAME ? % % Sector.visible ": false, " Industry ": " % % OBJNAME ? % % Industry.visible ": false, " GicSector ": " % % OBJNAME ? % % GicSector.visible ": false, " GicGroup ": " % % OBJNAME ? % % GicGroup.visible ": false, " GicIndustry ": " % % OBJNAME ? % % GicIndustry.visible ": false, " GicSubIndustry ": " % % OBJNAME ? % % GicSubIndustry.visible ": false, " HomeCategory ": " % % OBJNAME ? % % HomeCategory.visible ": false, " IsDelisted ": " % % OBJNAME ? % % IsDelisted.visible ": false, " Description ": " % % OBJNAME ? % % Description.visible ": false, " Address ": " % % OBJNAME ? % % Address.visible ": false, " Phone ": " % % OBJNAME ? % % Phone.visible ": false, " WebURL ": " % % OBJNAME ? % % WebURL.visible ": false, " LogoURL ": " % % OBJNAME ? % % LogoURL.visible ": false, " FullTimeEmployees ": " % % OBJNAME ? % % FullTimeEmployees.visible ": false, " UpdatedAt ": " % % OBJNAME ? % % UpdatedAt.visible ": false, " MarketCapitalization ": " % % OBJNAME ? % % MarketCapitalization.visible ": false, " MarketCapitalizationMln ": " % % OBJNAME ? % % MarketCapitalizationMln.visible ": false, " EBITDA ": " % % OBJNAME ? % % EBITDA.visible ": false, " PERatio ": " % % OBJNAME ? % % PERatio.visible ": false, " PEGRatio ": " % % OBJNAME ? % % PEGRatio.visible ": false, " WallStreetTargetPrice ": " % % OBJNAME ? % % WallStreetTargetPrice.visible ": false, " BookValue ": " % % OBJNAME ? % % BookValue.visible ": false, " DividendShare ": " % % OBJNAME ? % % DividendShare.visible ": false, " DividendYield ": " % % OBJNAME ? % % DividendYield.visible ": false, " EarningsShare ": " % % OBJNAME ? % % EarningsShare.visible ": false, " EPSEstimateCurrentYear ": " % % OBJNAME ? % % EPSEstimateCurrentYear.visible ": false, " EPSEstimateNextYear ": " % % OBJNAME ? % % EPSEstimateNextYear.visible ": false, " EPSEstimateNextQuarter ": " % % OBJNAME ? % % EPSEstimateNextQuarter.visible ": false, " EPSEstimateCurrentQuarter ": " % % OBJNAME ? % % EPSEstimateCurrentQuarter.visible ": false, " MostRecentQuarter ": " % % OBJNAME ? % % MostRecentQuarter.visible ": false, " ProfitMargin ": " % % OBJNAME ? % % ProfitMargin.visible ": false, " OperatingMarginTTM ": " % % OBJNAME ? % % OperatingMarginTTM.visible ": false, " ReturnOnAssetsTTM ": " % % OBJNAME ? % % ReturnOnAssetsTTM.visible ": false, " ReturnOnEquityTTM ": " % % OBJNAME ? % % ReturnOnEquityTTM.visible ": false, " RevenueTTM ": " % % OBJNAME ? % % RevenueTTM.visible ": false, " RevenuePerShareTTM ": " % % OBJNAME ? % % RevenuePerShareTTM.visible ": false, " QuarterlyRevenueGrowthYOY ": " % % OBJNAME ? % % QuarterlyRevenueGrowthYOY.visible ": false, " GrossProfitTTM ": " % % OBJNAME ? % % GrossProfitTTM.visible ": false, " DilutedEpsTTM ": " % % OBJNAME ? % % DilutedEpsTTM.visible ": false, " QuarterlyEarningsGrowthYOY ": " % % OBJNAME ? % % QuarterlyEarningsGrowthYOY.visible ": false, " Shape.visible ": false, " bgshape.visible ": false } } }, " text ": { " title ": " u062a u0623 u062b u06cc u0631 u0627 u0646 u062a u0634 u0627 u0631 u06af u0632 u0627 u0631 u0634 u0633 u0648 u062f FedEx Corporation (FDX) ", " short_text ": " FedEx Corporation (FDX) u0627 u0645 u0631 u0648 u0632 u06af u0632 u0627 u0631 u0634 u0633 u0648 u062f u062e u0648 u062f u0631 u0627 u0645 u0646 u062a u0634 u0631 u0645 u06cc u200c u06a9 u0646 u062f u0648 u0628 u0631 u0633 u0647 u0627 u0645 u0632 u06cc u0631 u062a u0623 u062b u06cc u0631 u062e u0648 u0627 u0647 u062f u06af u0630 u0627 u0634 u062a: n - Quanta Services Inc (PWR) n - Lockheed Martin Corporation (LMT) n - Huntington Ingalls Industries Inc (HII) n - General Electric Company (GE) n - Caterpillar Inc (CAT) n ", " long_text ": " u0634 u0631 u06a9 u062a fedex corporation (fdx) u0627 u0645 u0631 u0648 u0632 u06af u0632 u0627 u0631 u0634 u062f u0631 u0622 u0645 u062f u062e u0648 u062f u0631 u0627 u0645 u0646 u062a u0634 u0631 u0645 u06cc u200c u06a9 u0646 u062f. n u0648 u0642 u062a u06cc u0633 u0648 u062f u0647 u0631 u0633 u0647 u0645 (eps) > u0627 u0632 u0645 u0642 u062f u0627 u0631 u067e u06cc u0634 u200c u0628 u06cc u0646 u06cc u200c u0634 u062f u0647 u0628 u0627 u0634 u062f u060c u0627 u062d u062a u0645 u0627 u0644 u200f u200e75 % u200e u200f u0648 u062c u0648 u062f u062f u0627 u0631 u062f u06a9 u0647 fdx u062f u0631 u0645 u0627 u0647 u067e u0633 u0627 u0632 u0627 u0646 u062a u0634 u0627 u0631 u0627 u06cc u0646 u06af u0632 u0627 u0631 u0634 u060c u0628 u0647 u200c u0637 u0648 u0631 u0645 u06cc u0627 u0646 u06af u06cc u0646 u200f u200e ? % u200e u200f u0646 u0648 u0633 u0627 u0646 u062f u0627 u0634 u062a u0647 u0628 u0627 u0634 u062f. n u062f u0631 u06af u0632 u0627 u0631 u0634 u200c u0647 u0627 u06cc u062f u0631 u0622 u0645 u062f u06cc u06af u0630 u0634 u062a u0647 u06a9 u0647 eps > u0627 u0632 u067e u06cc u0634 u200c u0628 u06cc u0646 u06cc u0647 u0627 u0628 u0648 u062f u0647 u0627 u0633 u062a u060c u0633 u0647 u0627 u0645 u200c u0647 u0627 u06cc u0632 u06cc u0631 u062a u062d u062a u062a u0623 u062b u06cc u0631 u0642 u0631 u0627 u0631 u06af u0631 u0641 u062a u0647 u200c u0627 u0646 u062f: n - quanta services inc uff08pwr uff09 uff1a u0627 u062d u062a u0645 u0627 u0644 u200f u200e75 u066a u200e u200f u0628 u0631 u0627 u06cc u062d u0631 u06a9 u062a u200f u200e ? u066a u200e u200f u062f u0631 u0645 u0627 u0647 u0628 u0639 u062f u0627 u0632 u0627 u06cc u0646 u06af u0632 u0627 u0631 u0634 u061c u06d4 n - lockheed martin corporation uff08lmt uff09 uff1a u0627 u062d u062a u0645 u0627 u0644 u200f u200e75 u066a u200e u200f u0628 u0631 u0627 u06cc u062d u0631 u06a9 u062a u200f u200e ? u066a u200e u200f u062f u0631 u0645 u0627 u0647 u0628 u0639 u062f u0627 u0632 u0627 u06cc u0646 u06af u0632 u0627 u0631 u0634 u061c u06d4 n - huntington ingalls industries inc uff08hii uff09 uff1a u0627 u062d u062a u0645 u0627 u0644 u200f u200e75 u066a u200e u200f u0628 u0631 u0627 u0[...];

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 18	12	1	0ms	0ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

51,030

Details

0ms

select ?;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 18	12	51,030	0ms	0ms

2

37,170

Details

0ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 18	12	37,170	0ms	0ms

3

9,703

Details

0ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 18	12	9,703	0ms	0ms

4

8,406

Details

0ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 18	12	8,406	0ms	0ms

5

6,053

Details

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Dec 18	12	6,053	0ms	0ms

6

6,042

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

Day	Hour	Count	Duration	Avg duration
Dec 18	12	6,042	0ms	0ms

7

5,974

Details

0ms

set extra_float_digits = ?;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 18	12	5,974	0ms	0ms

8

5,945

Details

0ms

set application_name = ?;

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 18	12	5,945	0ms	0ms

9

5,600

Details

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Dec 18	12	5,600	0ms	0ms

10

3,396

Details

0ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 18	12	3,396	0ms	0ms

11

2,902

Details

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 18	12	2,902	0ms	0ms

12

2,196

Details

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 18	12	2,196	0ms	0ms

13

2,037

Details

0ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 18	12	2,037	0ms	0ms

14

1,821

Details

0ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 18	12	1,821	0ms	0ms

15

1,649

Details

0ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Dec 18	12	1,649	0ms	0ms

16

1,311

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

Day	Hour	Count	Duration	Avg duration
Dec 18	12	1,311	0ms	0ms

17

1,135

Details

0ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 18	12	1,135	0ms	0ms

18

649

Details

0ms

select downloadersymbol, spike_threshold from price_datafeed_spike_threshold where classname = ?;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Dec 18	12	649	0ms	0ms

19

649

Details

0ms

select s.symbolid, dss.downloadfrequency, dss.downloadersymbol from downloadersymbolsettings dss inner join symbols s on dss.symbolid = s.symbolid where dss.classname = ? and s.deleted = ? and dss.enabled = ?;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 18	12	649	0ms	0ms

20

524

Details

0ms

select datetimeupdate from latest_candle_datetime_per_receng where recognitionengine ilike ?;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 18	12	524	0ms	0ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

3

Details

0ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 18	12	3	0ms	0ms

2

0ms

61

Details

0ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 18	12	61	0ms	0ms

3

0ms

262

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

Day	Hour	Count	Duration	Avg duration
Dec 18	12	262	0ms	0ms

4

0ms

3

Details

0ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 18	12	3	0ms	0ms

5

0ms

12

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

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

6

0ms

2,196

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

Day	Hour	Count	Duration	Avg duration
Dec 18	12	2,196	0ms	0ms

7

0ms

48

Details

0ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 18	12	48	0ms	0ms

8

0ms

4

Details

0ms

select updaterelevantforrelevantresults ();

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 18	12	4	0ms	0ms

9

0ms

25

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

Day	Hour	Count	Duration	Avg duration
Dec 18	12	25	0ms	0ms

10

0ms

1

Details

0ms

set datestyle = iso;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 18	12	1	0ms	0ms

11

0ms

1,649

Details

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 18	12	1,649	0ms	0ms

12

0ms

30

Details

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 18	12	30	0ms	0ms

13

0ms

1

Details

0ms

set client_encoding to ?;

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 18	12	1	0ms	0ms

14

0ms

2

Details

0ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 18	12	2	0ms	0ms

15

0ms

1

Details

0ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Dec 18	12	1	0ms	0ms

16

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

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

17

0ms

4

Details

0ms

select category, name, sum(total) as total, sum(correct) as correct, (cast(sum(correct) as float) / cast(sum(total) as float)) * ?.? as percentage, min("from") AS "from", max("to") AS "to" from ( select category, name, total, correct, percentage, "from", "to" from stats_summary where statsid = ? and category = lower(?) and name in (...) union select category, name, total, correct, percentage, "from", "to" from stats_hrs_summary where statsid = ? and category = lower(?) and name in (...) order by correct desc) as summdata group by category, name having sum(total) > ? order by name;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 18	12	4	0ms	0ms

18

0ms

66

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

Day	Hour	Count	Duration	Avg duration
Dec 18	12	66	0ms	0ms

19

0ms

1

Details

0ms

select distinct s.statsid as statsid, sy.exchange as name from stats s inner join broker b on s.brokerid = b.brokerid inner join brokerconfig bc on b.brokerid = bc.brokerid inner join stats_symbols ss on s.statsid = ss.statsid inner join downloadersymbolsettings dss on ss.symbolid = dss.symbolid inner join symbols sy on dss.symbolid = sy.symbolid where dss.enabled = ? and s.brokerid is not null and b.brokerid = ? and s.groupingtype ilike ? and s.description ilike ? || b.name || ? and s.description ilike ? || sy.exchange || ? and s.description not ilike ? || ? || ? union all select distinct s.statsid as statsid, basegroupname as name from stats s inner join broker b on s.brokerid = b.brokerid inner join brokerconfig bc on b.brokerid = bc.brokerid inner join stats_symbols ss on s.statsid = ss.statsid inner join downloadersymbolsettings dss on ss.symbolid = dss.symbolid inner join symbolgroup sg on dss.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bg.brokerid = b.brokerid where dss.enabled = ? and s.brokerid is not null and b.brokerid = ? and s.groupingtype not ilike ? and s.description ilike ? || b.name || ? and s.description ilike ? || g.basegroupname || ? and s.description not ilike ? || ? || ?;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 18	12	1	0ms	0ms

20

0ms

1

Details

0ms

update executions set isrunning = false, has_results = true, response = ? 'Connor Boulevard, Irving, TX, United States, ? ", " Phone ": " ? ? ? ", " WebURL ": " https: // www.caterpillar.com ", " LogoURL ": " https: // eodhistoricaldata.com / img / logos / US / Cat.png ", " FullTimeEmployees ": ?, " UpdatedAt ": " ? - 12 - 17 ", " MarketCapitalization ": ?, " MarketCapitalizationMln ": ?.?, " EBITDA ": ?, " PERatio ": ?.?, " PEGRatio ": ?.?, " WallStreetTargetPrice ": ?.?, " BookValue ": ?.?, " DividendShare ": ?.?, " DividendYield ": ?.?, " EarningsShare ": ?.?, " EPSEstimateCurrentYear ": ?.?, " EPSEstimateNextYear ": ?.?, " EPSEstimateNextQuarter ": ?.?, " EPSEstimateCurrentQuarter ": ?.?, " MostRecentQuarter ": " ? - 09 - 30 ", " ProfitMargin ": ?.?, " OperatingMarginTTM ": ?.?, " ReturnOnAssetsTTM ": ?.?, " ReturnOnEquityTTM ": ?.?, " RevenueTTM ": ?, " RevenuePerShareTTM ": ?.?, " QuarterlyRevenueGrowthYOY ": ?.?, " GrossProfitTTM ": ?, " DilutedEpsTTM ": ?.?, " QuarterlyEarningsGrowthYOY ": ?.? }, " ? ": { " earningsimpactid ": " % % OBJNAME ? % % earningsimpactid.visible ": false, " sample_size ": " % % OBJNAME ? % % sample_size.visible ": false, " impactcompany ": " % % OBJNAME ? % % impactcompany.visible ": false, " impactcompany_name ": " % % OBJNAME ? % % impactcompany_name.visible ": false, " impactcompany_sector ": " % % OBJNAME ? % % impactcompany_sector.visible ": false, " impactcompany_industry ": " % % OBJNAME ? % % impactcompany_industry.visible ": false, " opportunities ": " % % OBJNAME ? % % opportunities.visible ": false, " Code ": " % % OBJNAME ? % % Code.visible ": false, " Type ": " % % OBJNAME ? % % Type.visible ": false, " Name ": " % % OBJNAME ? % % Name.visible ": false, " Exchange ": " % % OBJNAME ? % % Exchange.visible ": false, " CurrencyCode ": " % % OBJNAME ? % % CurrencyCode.visible ": false, " CurrencyName ": " % % OBJNAME ? % % CurrencyName.visible ": false, " CurrencySymbol ": " % % OBJNAME ? % % CurrencySymbol.visible ": false, " CountryName ": " % % OBJNAME ? % % CountryName.visible ": false, " CountryISO ": " % % OBJNAME ? % % CountryISO.visible ": false, " OpenFigi ": " % % OBJNAME ? % % OpenFigi.visible ": false, " ISIN ": " % % OBJNAME ? % % ISIN.visible ": false, " LEI ": " % % OBJNAME ? % % LEI.visible ": false, " PrimaryTicker ": " % % OBJNAME ? % % PrimaryTicker.visible ": false, " CUSIP ": " % % OBJNAME ? % % CUSIP.visible ": false, " CIK ": " % % OBJNAME ? % % CIK.visible ": false, " EmployerIdNumber ": " % % OBJNAME ? % % EmployerIdNumber.visible ": false, " FiscalYearEnd ": " % % OBJNAME ? % % FiscalYearEnd.visible ": false, " IPODate ": " % % OBJNAME ? % % IPODate.visible ": false, " InternationalDomestic ": " % % OBJNAME ? % % InternationalDomestic.visible ": false, " Sector ": " % % OBJNAME ? % % Sector.visible ": false, " Industry ": " % % OBJNAME ? % % Industry.visible ": false, " GicSector ": " % % OBJNAME ? % % GicSector.visible ": false, " GicGroup ": " % % OBJNAME ? % % GicGroup.visible ": false, " GicIndustry ": " % % OBJNAME ? % % GicIndustry.visible ": false, " GicSubIndustry ": " % % OBJNAME ? % % GicSubIndustry.visible ": false, " HomeCategory ": " % % OBJNAME ? % % HomeCategory.visible ": false, " IsDelisted ": " % % OBJNAME ? % % IsDelisted.visible ": false, " Description ": " % % OBJNAME ? % % Description.visible ": false, " Address ": " % % OBJNAME ? % % Address.visible ": false, " Phone ": " % % OBJNAME ? % % Phone.visible ": false, " WebURL ": " % % OBJNAME ? % % WebURL.visible ": false, " LogoURL ": " % % OBJNAME ? % % LogoURL.visible ": false, " FullTimeEmployees ": " % % OBJNAME ? % % FullTimeEmployees.visible ": false, " UpdatedAt ": " % % OBJNAME ? % % UpdatedAt.visible ": false, " MarketCapitalization ": " % % OBJNAME ? % % MarketCapitalization.visible ": false, " MarketCapitalizationMln ": " % % OBJNAME ? % % MarketCapitalizationMln.visible ": false, " EBITDA ": " % % OBJNAME ? % % EBITDA.visible ": false, " PERatio ": " % % OBJNAME ? % % PERatio.visible ": false, " PEGRatio ": " % % OBJNAME ? % % PEGRatio.visible ": false, " WallStreetTargetPrice ": " % % OBJNAME ? % % WallStreetTargetPrice.visible ": false, " BookValue ": " % % OBJNAME ? % % BookValue.visible ": false, " DividendShare ": " % % OBJNAME ? % % DividendShare.visible ": false, " DividendYield ": " % % OBJNAME ? % % DividendYield.visible ": false, " EarningsShare ": " % % OBJNAME ? % % EarningsShare.visible ": false, " EPSEstimateCurrentYear ": " % % OBJNAME ? % % EPSEstimateCurrentYear.visible ": false, " EPSEstimateNextYear ": " % % OBJNAME ? % % EPSEstimateNextYear.visible ": false, " EPSEstimateNextQuarter ": " % % OBJNAME ? % % EPSEstimateNextQuarter.visible ": false, " EPSEstimateCurrentQuarter ": " % % OBJNAME ? % % EPSEstimateCurrentQuarter.visible ": false, " MostRecentQuarter ": " % % OBJNAME ? % % MostRecentQuarter.visible ": false, " ProfitMargin ": " % % OBJNAME ? % % ProfitMargin.visible ": false, " OperatingMarginTTM ": " % % OBJNAME ? % % OperatingMarginTTM.visible ": false, " ReturnOnAssetsTTM ": " % % OBJNAME ? % % ReturnOnAssetsTTM.visible ": false, " ReturnOnEquityTTM ": " % % OBJNAME ? % % ReturnOnEquityTTM.visible ": false, " RevenueTTM ": " % % OBJNAME ? % % RevenueTTM.visible ": false, " RevenuePerShareTTM ": " % % OBJNAME ? % % RevenuePerShareTTM.visible ": false, " QuarterlyRevenueGrowthYOY ": " % % OBJNAME ? % % QuarterlyRevenueGrowthYOY.visible ": false, " GrossProfitTTM ": " % % OBJNAME ? % % GrossProfitTTM.visible ": false, " DilutedEpsTTM ": " % % OBJNAME ? % % DilutedEpsTTM.visible ": false, " QuarterlyEarningsGrowthYOY ": " % % OBJNAME ? % % QuarterlyEarningsGrowthYOY.visible ": false, " Shape.visible ": false, " bgshape.visible ": false }, " ? ": { " earningsimpactid ": " % % OBJNAME ? % % earningsimpactid.visible ": false, " sample_size ": " % % OBJNAME ? % % sample_size.visible ": false, " impactcompany ": " % % OBJNAME ? % % impactcompany.visible ": false, " impactcompany_name ": " % % OBJNAME ? % % impactcompany_name.visible ": false, " impactcompany_sector ": " % % OBJNAME ? % % impactcompany_sector.visible ": false, " impactcompany_industry ": " % % OBJNAME ? % % impactcompany_industry.visible ": false, " opportunities ": " % % OBJNAME ? % % opportunities.visible ": false, " Code ": " % % OBJNAME ? % % Code.visible ": false, " Type ": " % % OBJNAME ? % % Type.visible ": false, " Name ": " % % OBJNAME ? % % Name.visible ": false, " Exchange ": " % % OBJNAME ? % % Exchange.visible ": false, " CurrencyCode ": " % % OBJNAME ? % % CurrencyCode.visible ": false, " CurrencyName ": " % % OBJNAME ? % % CurrencyName.visible ": false, " CurrencySymbol ": " % % OBJNAME ? % % CurrencySymbol.visible ": false, " CountryName ": " % % OBJNAME ? % % CountryName.visible ": false, " CountryISO ": " % % OBJNAME ? % % CountryISO.visible ": false, " OpenFigi ": " % % OBJNAME ? % % OpenFigi.visible ": false, " ISIN ": " % % OBJNAME ? % % ISIN.visible ": false, " LEI ": " % % OBJNAME ? % % LEI.visible ": false, " PrimaryTicker ": " % % OBJNAME ? % % PrimaryTicker.visible ": false, " CUSIP ": " % % OBJNAME ? % % CUSIP.visible ": false, " CIK ": " % % OBJNAME ? % % CIK.visible ": false, " EmployerIdNumber ": " % % OBJNAME ? % % EmployerIdNumber.visible ": false, " FiscalYearEnd ": " % % OBJNAME ? % % FiscalYearEnd.visible ": false, " IPODate ": " % % OBJNAME ? % % IPODate.visible ": false, " InternationalDomestic ": " % % OBJNAME ? % % InternationalDomestic.visible ": false, " Sector ": " % % OBJNAME ? % % Sector.visible ": false, " Industry ": " % % OBJNAME ? % % Industry.visible ": false, " GicSector ": " % % OBJNAME ? % % GicSector.visible ": false, " GicGroup ": " % % OBJNAME ? % % GicGroup.visible ": false, " GicIndustry ": " % % OBJNAME ? % % GicIndustry.visible ": false, " GicSubIndustry ": " % % OBJNAME ? % % GicSubIndustry.visible ": false, " HomeCategory ": " % % OBJNAME ? % % HomeCategory.visible ": false, " IsDelisted ": " % % OBJNAME ? % % IsDelisted.visible ": false, " Description ": " % % OBJNAME ? % % Description.visible ": false, " Address ": " % % OBJNAME ? % % Address.visible ": false, " Phone ": " % % OBJNAME ? % % Phone.visible ": false, " WebURL ": " % % OBJNAME ? % % WebURL.visible ": false, " LogoURL ": " % % OBJNAME ? % % LogoURL.visible ": false, " FullTimeEmployees ": " % % OBJNAME ? % % FullTimeEmployees.visible ": false, " UpdatedAt ": " % % OBJNAME ? % % UpdatedAt.visible ": false, " MarketCapitalization ": " % % OBJNAME ? % % MarketCapitalization.visible ": false, " MarketCapitalizationMln ": " % % OBJNAME ? % % MarketCapitalizationMln.visible ": false, " EBITDA ": " % % OBJNAME ? % % EBITDA.visible ": false, " PERatio ": " % % OBJNAME ? % % PERatio.visible ": false, " PEGRatio ": " % % OBJNAME ? % % PEGRatio.visible ": false, " WallStreetTargetPrice ": " % % OBJNAME ? % % WallStreetTargetPrice.visible ": false, " BookValue ": " % % OBJNAME ? % % BookValue.visible ": false, " DividendShare ": " % % OBJNAME ? % % DividendShare.visible ": false, " DividendYield ": " % % OBJNAME ? % % DividendYield.visible ": false, " EarningsShare ": " % % OBJNAME ? % % EarningsShare.visible ": false, " EPSEstimateCurrentYear ": " % % OBJNAME ? % % EPSEstimateCurrentYear.visible ": false, " EPSEstimateNextYear ": " % % OBJNAME ? % % EPSEstimateNextYear.visible ": false, " EPSEstimateNextQuarter ": " % % OBJNAME ? % % EPSEstimateNextQuarter.visible ": false, " EPSEstimateCurrentQuarter ": " % % OBJNAME ? % % EPSEstimateCurrentQuarter.visible ": false, " MostRecentQuarter ": " % % OBJNAME ? % % MostRecentQuarter.visible ": false, " ProfitMargin ": " % % OBJNAME ? % % ProfitMargin.visible ": false, " OperatingMarginTTM ": " % % OBJNAME ? % % OperatingMarginTTM.visible ": false, " ReturnOnAssetsTTM ": " % % OBJNAME ? % % ReturnOnAssetsTTM.visible ": false, " ReturnOnEquityTTM ": " % % OBJNAME ? % % ReturnOnEquityTTM.visible ": false, " RevenueTTM ": " % % OBJNAME ? % % RevenueTTM.visible ": false, " RevenuePerShareTTM ": " % % OBJNAME ? % % RevenuePerShareTTM.visible ": false, " QuarterlyRevenueGrowthYOY ": " % % OBJNAME ? % % QuarterlyRevenueGrowthYOY.visible ": false, " GrossProfitTTM ": " % % OBJNAME ? % % GrossProfitTTM.visible ": false, " DilutedEpsTTM ": " % % OBJNAME ? % % DilutedEpsTTM.visible ": false, " QuarterlyEarningsGrowthYOY ": " % % OBJNAME ? % % QuarterlyEarningsGrowthYOY.visible ": false, " Shape.visible ": false, " bgshape.visible ": false }, " ? ": { " earningsimpactid ": " % % OBJNAME ? % % earningsimpactid.visible ": false, " sample_size ": " % % OBJNAME ? % % sample_size.visible ": false, " impactcompany ": " % % OBJNAME ? % % impactcompany.visible ": false, " impactcompany_name ": " % % OBJNAME ? % % impactcompany_name.visible ": false, " impactcompany_sector ": " % % OBJNAME ? % % impactcompany_sector.visible ": false, " impactcompany_industry ": " % % OBJNAME ? % % impactcompany_industry.visible ": false, " opportunities ": " % % OBJNAME ? % % opportunities.visible ": false, " Code ": " % % OBJNAME ? % % Code.visible ": false, " Type ": " % % OBJNAME ? % % Type.visible ": false, " Name ": " % % OBJNAME ? % % Name.visible ": false, " Exchange ": " % % OBJNAME ? % % Exchange.visible ": false, " CurrencyCode ": " % % OBJNAME ? % % CurrencyCode.visible ": false, " CurrencyName ": " % % OBJNAME ? % % CurrencyName.visible ": false, " CurrencySymbol ": " % % OBJNAME ? % % CurrencySymbol.visible ": false, " CountryName ": " % % OBJNAME ? % % CountryName.visible ": false, " CountryISO ": " % % OBJNAME ? % % CountryISO.visible ": false, " OpenFigi ": " % % OBJNAME ? % % OpenFigi.visible ": false, " ISIN ": " % % OBJNAME ? % % ISIN.visible ": false, " LEI ": " % % OBJNAME ? % % LEI.visible ": false, " PrimaryTicker ": " % % OBJNAME ? % % PrimaryTicker.visible ": false, " CUSIP ": " % % OBJNAME ? % % CUSIP.visible ": false, " CIK ": " % % OBJNAME ? % % CIK.visible ": false, " EmployerIdNumber ": " % % OBJNAME ? % % EmployerIdNumber.visible ": false, " FiscalYearEnd ": " % % OBJNAME ? % % FiscalYearEnd.visible ": false, " IPODate ": " % % OBJNAME ? % % IPODate.visible ": false, " InternationalDomestic ": " % % OBJNAME ? % % InternationalDomestic.visible ": false, " Sector ": " % % OBJNAME ? % % Sector.visible ": false, " Industry ": " % % OBJNAME ? % % Industry.visible ": false, " GicSector ": " % % OBJNAME ? % % GicSector.visible ": false, " GicGroup ": " % % OBJNAME ? % % GicGroup.visible ": false, " GicIndustry ": " % % OBJNAME ? % % GicIndustry.visible ": false, " GicSubIndustry ": " % % OBJNAME ? % % GicSubIndustry.visible ": false, " HomeCategory ": " % % OBJNAME ? % % HomeCategory.visible ": false, " IsDelisted ": " % % OBJNAME ? % % IsDelisted.visible ": false, " Description ": " % % OBJNAME ? % % Description.visible ": false, " Address ": " % % OBJNAME ? % % Address.visible ": false, " Phone ": " % % OBJNAME ? % % Phone.visible ": false, " WebURL ": " % % OBJNAME ? % % WebURL.visible ": false, " LogoURL ": " % % OBJNAME ? % % LogoURL.visible ": false, " FullTimeEmployees ": " % % OBJNAME ? % % FullTimeEmployees.visible ": false, " UpdatedAt ": " % % OBJNAME ? % % UpdatedAt.visible ": false, " MarketCapitalization ": " % % OBJNAME ? % % MarketCapitalization.visible ": false, " MarketCapitalizationMln ": " % % OBJNAME ? % % MarketCapitalizationMln.visible ": false, " EBITDA ": " % % OBJNAME ? % % EBITDA.visible ": false, " PERatio ": " % % OBJNAME ? % % PERatio.visible ": false, " PEGRatio ": " % % OBJNAME ? % % PEGRatio.visible ": false, " WallStreetTargetPrice ": " % % OBJNAME ? % % WallStreetTargetPrice.visible ": false, " BookValue ": " % % OBJNAME ? % % BookValue.visible ": false, " DividendShare ": " % % OBJNAME ? % % DividendShare.visible ": false, " DividendYield ": " % % OBJNAME ? % % DividendYield.visible ": false, " EarningsShare ": " % % OBJNAME ? % % EarningsShare.visible ": false, " EPSEstimateCurrentYear ": " % % OBJNAME ? % % EPSEstimateCurrentYear.visible ": false, " EPSEstimateNextYear ": " % % OBJNAME ? % % EPSEstimateNextYear.visible ": false, " EPSEstimateNextQuarter ": " % % OBJNAME ? % % EPSEstimateNextQuarter.visible ": false, " EPSEstimateCurrentQuarter ": " % % OBJNAME ? % % EPSEstimateCurrentQuarter.visible ": false, " MostRecentQuarter ": " % % OBJNAME ? % % MostRecentQuarter.visible ": false, " ProfitMargin ": " % % OBJNAME ? % % ProfitMargin.visible ": false, " OperatingMarginTTM ": " % % OBJNAME ? % % OperatingMarginTTM.visible ": false, " ReturnOnAssetsTTM ": " % % OBJNAME ? % % ReturnOnAssetsTTM.visible ": false, " ReturnOnEquityTTM ": " % % OBJNAME ? % % ReturnOnEquityTTM.visible ": false, " RevenueTTM ": " % % OBJNAME ? % % RevenueTTM.visible ": false, " RevenuePerShareTTM ": " % % OBJNAME ? % % RevenuePerShareTTM.visible ": false, " QuarterlyRevenueGrowthYOY ": " % % OBJNAME ? % % QuarterlyRevenueGrowthYOY.visible ": false, " GrossProfitTTM ": " % % OBJNAME ? % % GrossProfitTTM.visible ": false, " DilutedEpsTTM ": " % % OBJNAME ? % % DilutedEpsTTM.visible ": false, " QuarterlyEarningsGrowthYOY ": " % % OBJNAME ? % % QuarterlyEarningsGrowthYOY.visible ": false, " Shape.visible ": false, " bgshape.visible ": false }, " ? ": { " earningsimpactid ": " % % OBJNAME ? % % earningsimpactid.visible ": false, " sample_size ": " % % OBJNAME ? % % sample_size.visible ": false, " impactcompany ": " % % OBJNAME ? % % impactcompany.visible ": false, " impactcompany_name ": " % % OBJNAME ? % % impactcompany_name.visible ": false, " impactcompany_sector ": " % % OBJNAME ? % % impactcompany_sector.visible ": false, " impactcompany_industry ": " % % OBJNAME ? % % impactcompany_industry.visible ": false, " opportunities ": " % % OBJNAME ? % % opportunities.visible ": false, " Code ": " % % OBJNAME ? % % Code.visible ": false, " Type ": " % % OBJNAME ? % % Type.visible ": false, " Name ": " % % OBJNAME ? % % Name.visible ": false, " Exchange ": " % % OBJNAME ? % % Exchange.visible ": false, " CurrencyCode ": " % % OBJNAME ? % % CurrencyCode.visible ": false, " CurrencyName ": " % % OBJNAME ? % % CurrencyName.visible ": false, " CurrencySymbol ": " % % OBJNAME ? % % CurrencySymbol.visible ": false, " CountryName ": " % % OBJNAME ? % % CountryName.visible ": false, " CountryISO ": " % % OBJNAME ? % % CountryISO.visible ": false, " OpenFigi ": " % % OBJNAME ? % % OpenFigi.visible ": false, " ISIN ": " % % OBJNAME ? % % ISIN.visible ": false, " LEI ": " % % OBJNAME ? % % LEI.visible ": false, " PrimaryTicker ": " % % OBJNAME ? % % PrimaryTicker.visible ": false, " CUSIP ": " % % OBJNAME ? % % CUSIP.visible ": false, " CIK ": " % % OBJNAME ? % % CIK.visible ": false, " EmployerIdNumber ": " % % OBJNAME ? % % EmployerIdNumber.visible ": false, " FiscalYearEnd ": " % % OBJNAME ? % % FiscalYearEnd.visible ": false, " IPODate ": " % % OBJNAME ? % % IPODate.visible ": false, " InternationalDomestic ": " % % OBJNAME ? % % InternationalDomestic.visible ": false, " Sector ": " % % OBJNAME ? % % Sector.visible ": false, " Industry ": " % % OBJNAME ? % % Industry.visible ": false, " GicSector ": " % % OBJNAME ? % % GicSector.visible ": false, " GicGroup ": " % % OBJNAME ? % % GicGroup.visible ": false, " GicIndustry ": " % % OBJNAME ? % % GicIndustry.visible ": false, " GicSubIndustry ": " % % OBJNAME ? % % GicSubIndustry.visible ": false, " HomeCategory ": " % % OBJNAME ? % % HomeCategory.visible ": false, " IsDelisted ": " % % OBJNAME ? % % IsDelisted.visible ": false, " Description ": " % % OBJNAME ? % % Description.visible ": false, " Address ": " % % OBJNAME ? % % Address.visible ": false, " Phone ": " % % OBJNAME ? % % Phone.visible ": false, " WebURL ": " % % OBJNAME ? % % WebURL.visible ": false, " LogoURL ": " % % OBJNAME ? % % LogoURL.visible ": false, " FullTimeEmployees ": " % % OBJNAME ? % % FullTimeEmployees.visible ": false, " UpdatedAt ": " % % OBJNAME ? % % UpdatedAt.visible ": false, " MarketCapitalization ": " % % OBJNAME ? % % MarketCapitalization.visible ": false, " MarketCapitalizationMln ": " % % OBJNAME ? % % MarketCapitalizationMln.visible ": false, " EBITDA ": " % % OBJNAME ? % % EBITDA.visible ": false, " PERatio ": " % % OBJNAME ? % % PERatio.visible ": false, " PEGRatio ": " % % OBJNAME ? % % PEGRatio.visible ": false, " WallStreetTargetPrice ": " % % OBJNAME ? % % WallStreetTargetPrice.visible ": false, " BookValue ": " % % OBJNAME ? % % BookValue.visible ": false, " DividendShare ": " % % OBJNAME ? % % DividendShare.visible ": false, " DividendYield ": " % % OBJNAME ? % % DividendYield.visible ": false, " EarningsShare ": " % % OBJNAME ? % % EarningsShare.visible ": false, " EPSEstimateCurrentYear ": " % % OBJNAME ? % % EPSEstimateCurrentYear.visible ": false, " EPSEstimateNextYear ": " % % OBJNAME ? % % EPSEstimateNextYear.visible ": false, " EPSEstimateNextQuarter ": " % % OBJNAME ? % % EPSEstimateNextQuarter.visible ": false, " EPSEstimateCurrentQuarter ": " % % OBJNAME ? % % EPSEstimateCurrentQuarter.visible ": false, " MostRecentQuarter ": " % % OBJNAME ? % % MostRecentQuarter.visible ": false, " ProfitMargin ": " % % OBJNAME ? % % ProfitMargin.visible ": false, " OperatingMarginTTM ": " % % OBJNAME ? % % OperatingMarginTTM.visible ": false, " ReturnOnAssetsTTM ": " % % OBJNAME ? % % ReturnOnAssetsTTM.visible ": false, " ReturnOnEquityTTM ": " % % OBJNAME ? % % ReturnOnEquityTTM.visible ": false, " RevenueTTM ": " % % OBJNAME ? % % RevenueTTM.visible ": false, " RevenuePerShareTTM ": " % % OBJNAME ? % % RevenuePerShareTTM.visible ": false, " QuarterlyRevenueGrowthYOY ": " % % OBJNAME ? % % QuarterlyRevenueGrowthYOY.visible ": false, " GrossProfitTTM ": " % % OBJNAME ? % % GrossProfitTTM.visible ": false, " DilutedEpsTTM ": " % % OBJNAME ? % % DilutedEpsTTM.visible ": false, " QuarterlyEarningsGrowthYOY ": " % % OBJNAME ? % % QuarterlyEarningsGrowthYOY.visible ": false, " Shape.visible ": false, " bgshape.visible ": false }, " ? ": { " earningsimpactid ": " % % OBJNAME ? % % earningsimpactid.visible ": false, " sample_size ": " % % OBJNAME ? % % sample_size.visible ": false, " impactcompany ": " % % OBJNAME ? % % impactcompany.visible ": false, " impactcompany_name ": " % % OBJNAME ? % % impactcompany_name.visible ": false, " impactcompany_sector ": " % % OBJNAME ? % % impactcompany_sector.visible ": false, " impactcompany_industry ": " % % OBJNAME ? % % impactcompany_industry.visible ": false, " opportunities ": " % % OBJNAME ? % % opportunities.visible ": false, " Code ": " % % OBJNAME ? % % Code.visible ": false, " Type ": " % % OBJNAME ? % % Type.visible ": false, " Name ": " % % OBJNAME ? % % Name.visible ": false, " Exchange ": " % % OBJNAME ? % % Exchange.visible ": false, " CurrencyCode ": " % % OBJNAME ? % % CurrencyCode.visible ": false, " CurrencyName ": " % % OBJNAME ? % % CurrencyName.visible ": false, " CurrencySymbol ": " % % OBJNAME ? % % CurrencySymbol.visible ": false, " CountryName ": " % % OBJNAME ? % % CountryName.visible ": false, " CountryISO ": " % % OBJNAME ? % % CountryISO.visible ": false, " OpenFigi ": " % % OBJNAME ? % % OpenFigi.visible ": false, " ISIN ": " % % OBJNAME ? % % ISIN.visible ": false, " LEI ": " % % OBJNAME ? % % LEI.visible ": false, " PrimaryTicker ": " % % OBJNAME ? % % PrimaryTicker.visible ": false, " CUSIP ": " % % OBJNAME ? % % CUSIP.visible ": false, " CIK ": " % % OBJNAME ? % % CIK.visible ": false, " EmployerIdNumber ": " % % OBJNAME ? % % EmployerIdNumber.visible ": false, " FiscalYearEnd ": " % % OBJNAME ? % % FiscalYearEnd.visible ": false, " IPODate ": " % % OBJNAME ? % % IPODate.visible ": false, " InternationalDomestic ": " % % OBJNAME ? % % InternationalDomestic.visible ": false, " Sector ": " % % OBJNAME ? % % Sector.visible ": false, " Industry ": " % % OBJNAME ? % % Industry.visible ": false, " GicSector ": " % % OBJNAME ? % % GicSector.visible ": false, " GicGroup ": " % % OBJNAME ? % % GicGroup.visible ": false, " GicIndustry ": " % % OBJNAME ? % % GicIndustry.visible ": false, " GicSubIndustry ": " % % OBJNAME ? % % GicSubIndustry.visible ": false, " HomeCategory ": " % % OBJNAME ? % % HomeCategory.visible ": false, " IsDelisted ": " % % OBJNAME ? % % IsDelisted.visible ": false, " Description ": " % % OBJNAME ? % % Description.visible ": false, " Address ": " % % OBJNAME ? % % Address.visible ": false, " Phone ": " % % OBJNAME ? % % Phone.visible ": false, " WebURL ": " % % OBJNAME ? % % WebURL.visible ": false, " LogoURL ": " % % OBJNAME ? % % LogoURL.visible ": false, " FullTimeEmployees ": " % % OBJNAME ? % % FullTimeEmployees.visible ": false, " UpdatedAt ": " % % OBJNAME ? % % UpdatedAt.visible ": false, " MarketCapitalization ": " % % OBJNAME ? % % MarketCapitalization.visible ": false, " MarketCapitalizationMln ": " % % OBJNAME ? % % MarketCapitalizationMln.visible ": false, " EBITDA ": " % % OBJNAME ? % % EBITDA.visible ": false, " PERatio ": " % % OBJNAME ? % % PERatio.visible ": false, " PEGRatio ": " % % OBJNAME ? % % PEGRatio.visible ": false, " WallStreetTargetPrice ": " % % OBJNAME ? % % WallStreetTargetPrice.visible ": false, " BookValue ": " % % OBJNAME ? % % BookValue.visible ": false, " DividendShare ": " % % OBJNAME ? % % DividendShare.visible ": false, " DividendYield ": " % % OBJNAME ? % % DividendYield.visible ": false, " EarningsShare ": " % % OBJNAME ? % % EarningsShare.visible ": false, " EPSEstimateCurrentYear ": " % % OBJNAME ? % % EPSEstimateCurrentYear.visible ": false, " EPSEstimateNextYear ": " % % OBJNAME ? % % EPSEstimateNextYear.visible ": false, " EPSEstimateNextQuarter ": " % % OBJNAME ? % % EPSEstimateNextQuarter.visible ": false, " EPSEstimateCurrentQuarter ": " % % OBJNAME ? % % EPSEstimateCurrentQuarter.visible ": false, " MostRecentQuarter ": " % % OBJNAME ? % % MostRecentQuarter.visible ": false, " ProfitMargin ": " % % OBJNAME ? % % ProfitMargin.visible ": false, " OperatingMarginTTM ": " % % OBJNAME ? % % OperatingMarginTTM.visible ": false, " ReturnOnAssetsTTM ": " % % OBJNAME ? % % ReturnOnAssetsTTM.visible ": false, " ReturnOnEquityTTM ": " % % OBJNAME ? % % ReturnOnEquityTTM.visible ": false, " RevenueTTM ": " % % OBJNAME ? % % RevenueTTM.visible ": false, " RevenuePerShareTTM ": " % % OBJNAME ? % % RevenuePerShareTTM.visible ": false, " QuarterlyRevenueGrowthYOY ": " % % OBJNAME ? % % QuarterlyRevenueGrowthYOY.visible ": false, " GrossProfitTTM ": " % % OBJNAME ? % % GrossProfitTTM.visible ": false, " DilutedEpsTTM ": " % % OBJNAME ? % % DilutedEpsTTM.visible ": false, " QuarterlyEarningsGrowthYOY ": " % % OBJNAME ? % % QuarterlyEarningsGrowthYOY.visible ": false, " Shape.visible ": false, " bgshape.visible ": false } } }, " text ": { " title ": " u062a u0623 u062b u06cc u0631 u0627 u0646 u062a u0634 u0627 u0631 u06af u0632 u0627 u0631 u0634 u0633 u0648 u062f FedEx Corporation (FDX) ", " short_text ": " FedEx Corporation (FDX) u0627 u0645 u0631 u0648 u0632 u06af u0632 u0627 u0631 u0634 u0633 u0648 u062f u062e u0648 u062f u0631 u0627 u0645 u0646 u062a u0634 u0631 u0645 u06cc u200c u06a9 u0646 u062f u0648 u0628 u0631 u0633 u0647 u0627 u0645 u0632 u06cc u0631 u062a u0623 u062b u06cc u0631 u062e u0648 u0627 u0647 u062f u06af u0630 u0627 u0634 u062a: n - Quanta Services Inc (PWR) n - Lockheed Martin Corporation (LMT) n - Huntington Ingalls Industries Inc (HII) n - General Electric Company (GE) n - Caterpillar Inc (CAT) n ", " long_text ": " u0634 u0631 u06a9 u062a fedex corporation (fdx) u0627 u0645 u0631 u0648 u0632 u06af u0632 u0627 u0631 u0634 u062f u0631 u0622 u0645 u062f u062e u0648 u062f u0631 u0627 u0645 u0646 u062a u0634 u0631 u0645 u06cc u200c u06a9 u0646 u062f. n u0648 u0642 u062a u06cc u0633 u0648 u062f u0647 u0631 u0633 u0647 u0645 (eps) > u0627 u0632 u0645 u0642 u062f u0627 u0631 u067e u06cc u0634 u200c u0628 u06cc u0646 u06cc u200c u0634 u062f u0647 u0628 u0627 u0634 u062f u060c u0627 u062d u062a u0645 u0627 u0644 u200f u200e75 % u200e u200f u0648 u062c u0648 u062f u062f u0627 u0631 u062f u06a9 u0647 fdx u062f u0631 u0645 u0627 u0647 u067e u0633 u0627 u0632 u0627 u0646 u062a u0634 u0627 u0631 u0627 u06cc u0646 u06af u0632 u0627 u0631 u0634 u060c u0628 u0647 u200c u0637 u0648 u0631 u0645 u06cc u0627 u0646 u06af u06cc u0646 u200f u200e ? % u200e u200f u0646 u0648 u0633 u0627 u0646 u062f u0627 u0634 u062a u0647 u0628 u0627 u0634 u062f. n u062f u0631 u06af u0632 u0627 u0631 u0634 u200c u0647 u0627 u06cc u062f u0631 u0622 u0645 u062f u06cc u06af u0630 u0634 u062a u0647 u06a9 u0647 eps > u0627 u0632 u067e u06cc u0634 u200c u0628 u06cc u0646 u06cc u0647 u0627 u0628 u0648 u062f u0647 u0627 u0633 u062a u060c u0633 u0647 u0627 u0645 u200c u0647 u0627 u06cc u0632 u06cc u0631 u062a u062d u062a u062a u0623 u062b u06cc u0631 u0642 u0631 u0627 u0631 u06af u0631 u0641 u062a u0647 u200c u0627 u0646 u062f: n - quanta services inc uff08pwr uff09 uff1a u0627 u062d u062a u0645 u0627 u0644 u200f u200e75 u066a u200e u200f u0628 u0631 u0627 u06cc u062d u0631 u06a9 u062a u200f u200e ? u066a u200e u200f u062f u0631 u0645 u0627 u0647 u0628 u0639 u062f u0627 u0632 u0627 u06cc u0646 u06af u0632 u0627 u0631 u0634 u061c u06d4 n - lockheed martin corporation uff08lmt uff09 uff1a u0627 u062d u062a u0645 u0627 u0644 u200f u200e75 u066a u200e u200f u0628 u0631 u0627 u06cc u062d u0631 u06a9 u062a u200f u200e ? u066a u200e u200f u062f u0631 u0645 u0627 u0647 u0628 u0639 u062f u0627 u0632 u0627 u06cc u0646 u06af u0632 u0627 u0631 u0634 u061c u06d4 n - huntington ingalls industries inc uff08hii uff09 uff1a u0627 u062d u062a u0645 u0627 u0644 u200f u200e75 u066a u200e u200f u0628 u0631 u0627 u0[...];

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 18	12	1	0ms	0ms

Time consuming prepare


Date: 2025-12-18 12:31:55
Duration: 18ms
Database: postgres
Date: 2025-12-18 12:57:30
Duration: 20ms
Database: postgres
Date: 2025-12-18 12:30:59
Duration: 3ms
Database: postgres
Date: 2025-12-18 12:56:10
Duration: 6ms
Database: postgres
Date: 2025-12-18 12:45:56
Duration: 1ms
Database: postgres
Date: 2025-12-18 12:46:50
Duration: 3ms
Database: postgres
Date: 2025-12-18 12:30:34
Duration: 0ms
Database: postgres
Date: 2025-12-18 12:01:34
Duration: 0ms
Database: postgres
Date: 2025-12-18 12:41:55
Duration: 0ms
Database: postgres
Date: 2025-12-18 12:01:08
Duration: 0ms
Database: postgres
Date: 2025-12-18 12:26:57
Duration: 4ms
Database: postgres
Date: 2025-12-18 12:21:43
Duration: 6ms
Database: postgres
Date: 2025-12-18 12:32:00
Duration: 3ms
Database: postgres
Date: 2025-12-18 12:01:04
Duration: 3ms
Database: postgres
Date: 2025-12-18 12:13:19
Duration: 0ms
Database: postgres
Date: 2025-12-18 12:53:30
Duration: 2ms
Database: postgres
Date: 2025-12-18 12:00:04
Duration: 3ms
Database: postgres
Date: 2025-12-18 12:00:03
Duration: 0ms
Database: postgres
Date: 2025-12-18 12:20:02
Duration: 2ms
Database: postgres
Date: 2025-12-18 12:13:18
Duration: 3ms
Database: postgres

Time consuming bind

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

48s586ms

10,737

Details

0ms

73ms

4ms

WITH rar_max as ( ;

Times Reported Time consuming bind #1

Day	Hour	Count	Duration	Avg duration
Dec 18	12	10,737	48s586ms	4ms

WITH rar_max as ( ;

Date: 2025-12-18 12:21:13 Duration: 73ms Database: postgres parameters: $1 = '689', $2 = '7', $3 = '15', $4 = '30', $5 = '60', $6 = '120', $7 = '240', $8 = '480', $9 = '1440', $10 = '0', $11 = '', $12 = '310', $13 = '#AAPL', $14 = '#ADS', $15 = '#AIG', $16 = '#ALV', $17 = '#AMZN', $18 = '#AXP', $19 = '#BA', $20 = '#BABA', $21 = '#BAC', $22 = '#BAS', $23 = '#BAYN', $24 = '#BEI', $25 = '#BIDU', $26 = '#BMW', $27 = '#C', $28 = '#CAT', $29 = '#CBK', $30 = '#CL', $31 = '#CSCO', $32 = '#CVX', $33 = '#DAI', $34 = '#DB1', $35 = '#DBK', $36 = '#DIS', $37 = '#DPW', $38 = '#DTE', $39 = '#EBAY', $40 = '#EON', $41 = '#F', $42 = '#FB', $43 = '#FDX', $44 = '#FME', $45 = '#GE', $46 = '#GM', $47 = '#GOOG', $48 = '#GS', $49 = '#HPQ', $50 = '#IBM', $51 = '#IFX', $52 = '#INTC', $53 = '#JD', $54 = '#JNJ', $55 = '#JPM', $56 = '#KO', $57 = '#LHA', $58 = '#LMT', $59 = '#MA', $60 = '#MCD', $61 = '#META', $62 = '#MMM', $63 = '#MSFT', $64 = '#MUV2', $65 = '#NFLX', $66 = '#NKE', $67 = '#NTES', $68 = '#ORCL', $69 = '#PFE', $70 = '#PG', $71 = '#QCOM', $72 = '#RACE', $73 = '#RWE', $74 = '#SAP', $75 = '#SIE', $76 = '#T', $77 = '#UBER', $78 = '#V', $79 = '#VOW', $80 = '#WB', $81 = '#XOM', $82 = 'AUDCAD', $83 = 'AUDCHF', $84 = 'AUDJPY', $85 = 'AUDNZD', $86 = 'AUDUSD', $87 = 'AUS200', $88 = 'BRENT', $89 = 'BTCUSD', $90 = 'CADCHF', $91 = 'CADJPY', $92 = 'CHFJPY', $93 = 'CHI50', $94 = 'ESP35', $95 = 'ETHUSD', $96 = 'EU50', $97 = 'EURAUD', $98 = 'EURCAD', $99 = 'EURCHF', $100 = 'EURGBP', $101 = 'EURHUF', $102 = 'EURJPY', $103 = 'EURNZD', $104 = 'EURPLN', $105 = 'EURUSD', $106 = 'FRA40', $107 = 'GBPAUD', $108 = 'GBPCAD', $109 = 'GBPCHF', $110 = 'GBPJPY', $111 = 'GBPNZD', $112 = 'GBPUSD', $113 = 'GER30', $114 = 'HK50', $115 = 'HKCH50', $116 = 'IT40', $117 = 'JP225', $118 = 'LTCUSD', $119 = 'NAS100', $120 = 'NZDCAD', $121 = 'NZDCHF', $122 = 'NZDJPY', $123 = 'NZDUSD', $124 = 'SPX500', $125 = 'UK100', $126 = 'US30', $127 = 'USDCAD', $128 = 'USDCHF', $129 = 'USDCNH', $130 = 'USDCZK', $131 = 'USDDKK', $132 = 'USDHKD', $133 = 'USDHUF', $134 = 'USDJPY', $135 = 'USDMXN', $136 = 'USDNOK', $137 = 'USDPLN', $138 = 'USDSEK', $139 = 'USDSGD', $140 = 'USDTRY', $141 = 'USDX', $142 = 'USDZAR', $143 = 'WTI', $144 = 'XAGUSD', $145 = 'XAUUSD', $146 = '#ADS', $147 = '#ALV', $148 = '#BAS', $149 = '#BAYN', $150 = '#BEI', $151 = '#BMW', $152 = '#CBK', $153 = '#DAI', $154 = '#DB1', $155 = '#DBK', $156 = '#DPW', $157 = '#DTE', $158 = '#EON', $159 = '#FME', $160 = '#IFX', $161 = '#LHA', $162 = '#MUV2', $163 = '#RWE', $164 = '#SAP', $165 = '#SIE', $166 = '#VOW', $167 = 'AUDCAD', $168 = 'AUDCHF', $169 = 'AUDJPY', $170 = 'AUDNZD', $171 = 'AUDUSD', $172 = 'CADCHF', $173 = 'CADJPY', $174 = 'CHFJPY', $175 = 'EURAUD', $176 = 'EURCAD', $177 = 'EURCHF', $178 = 'EURGBP', $179 = 'EURHUF', $180 = 'EURJPY', $181 = 'EURNZD', $182 = 'EURPLN', $183 = 'EURUSD', $184 = 'GBPAUD', $185 = 'GBPCAD', $186 = 'GBPCHF', $187 = 'GBPJPY', $188 = 'GBPNZD', $189 = 'GBPUSD', $190 = 'NZDCAD', $191 = 'NZDCHF', $192 = 'NZDJPY', $193 = 'NZDUSD', $194 = 'USDCAD', $195 = 'USDCHF', $196 = 'USDCNH', $197 = 'USDCZK', $198 = 'USDDKK', $199 = 'USDHKD', $200 = 'USDHUF', $201 = 'USDJPY', $202 = 'USDMXN', $203 = 'USDNOK', $204 = 'USDPLN', $205 = 'USDSEK', $206 = 'USDSGD', $207 = 'USDTRY', $208 = 'USDX', $209 = 'USDZAR', $210 = 'XAGUSD', $211 = 'XAUUSD', $212 = 'BTCUSD', $213 = 'ETHUSD', $214 = 'LTCUSD', $215 = 'AUDCAD', $216 = 'AUDCHF', $217 = 'AUDJPY', $218 = 'AUDNZD', $219 = 'CADCHF', $220 = 'CADJPY', $221 = 'CHFJPY', $222 = 'EURAUD', $223 = 'EURCAD', $224 = 'EURCHF', $225 = 'EURGBP', $226 = 'EURHUF', $227 = 'EURJPY', $228 = 'EURNZD', $229 = 'EURPLN', $230 = 'GBPAUD', $231 = 'GBPCAD', $232 = 'GBPCHF', $233 = 'GBPJPY', $234 = 'GBPNZD', $235 = 'NZDCAD', $236 = 'NZDCHF', $237 = 'NZDJPY', $238 = 'USDCNH', $239 = 'USDCZK', $240 = 'USDDKK', $241 = 'USDHKD', $242 = 'USDHUF', $243 = 'USDMXN', $244 = 'USDNOK', $245 = 'USDPLN', $246 = 'USDSEK', $247 = 'USDSGD', $248 = 'USDTRY', $249 = 'USDX', $250 = 'USDZAR', $251 = 'XAGUSD', $252 = 'XAUUSD', $253 = 'BRENT', $254 = 'WTI', $255 = 'AUS200', $256 = 'CHI50', $257 = 'ESP35', $258 = 'EU50', $259 = 'FRA40', $260 = 'GER30', $261 = 'HK50', $262 = 'HKCH50', $263 = 'IT40', $264 = 'JP225', $265 = 'NAS100', $266 = 'SPX500', $267 = 'UK100', $268 = 'US30', $269 = 'AUDUSD', $270 = 'EURUSD', $271 = 'GBPUSD', $272 = 'NZDUSD', $273 = 'USDCAD', $274 = 'USDCHF', $275 = 'USDJPY', $276 = '#AAPL', $277 = '#AIG', $278 = '#AMZN', $279 = '#AXP', $280 = '#BA', $281 = '#BABA', $282 = '#BAC', $283 = '#BIDU', $284 = '#C', $285 = '#CAT', $286 = '#CL', $287 = '#CSCO', $288 = '#CVX', $289 = '#DIS', $290 = '#EBAY', $291 = '#F', $292 = '#FB', $293 = '#FDX', $294 = '#GE', $295 = '#GM', $296 = '#GOOG', $297 = '#GS', $298 = '#HPQ', $299 = '#IBM', $300 = '#INTC', $301 = '#JD', $302 = '#JNJ', $303 = '#JPM', $304 = '#KO', $305 = '#LMT', $306 = '#MA', $307 = '#MCD', $308 = '#MMM', $309 = '#MSFT', $310 = '#NFLX', $311 = '#NKE', $312 = '#NTES', $313 = '#ORCL', $314 = '#PFE', $315 = '#PG', $316 = '#QCOM', $317 = '#RACE', $318 = '#T', $319 = '#UBER', $320 = '#V', $321 = '#WB', $322 = '#XOM', $323 = '400', $324 = '400', $325 = 't', $326 = '10', $327 = '10'
WITH rar_max as ( ;

Date: 2025-12-18 12:32:15 Duration: 54ms Database: postgres parameters: $1 = 't', $2 = '689', $3 = '0', $4 = '0', $5 = '0', $6 = '', $7 = '0', $8 = '', $9 = '0', $10 = '', $11 = '0', $12 = '0', $13 = '0', $14 = '0', $15 = '0', $16 = 't', $17 = '0', $18 = '0'
WITH rar_max as ( ;

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

2

25s884ms

49,534

Details

0ms

29ms

0ms

SELECT ;

Times Reported Time consuming bind #2

Day	Hour	Count	Duration	Avg duration
	12	49,534	25s884ms	0ms

SELECT ;

Date: 2025-12-18 12:56:40 Duration: 29ms Database: postgres parameters: $1 = '958', $2 = '958', $3 = '515840216985241300'
SELECT ;

Date: 2025-12-18 12:31:55 Duration: 29ms Database: postgres parameters: $1 = '958', $2 = '958', $3 = '515840249443731300'
SELECT ;

Date: 2025-12-18 12:31:55 Duration: 26ms Database: postgres parameters: $1 = '958', $2 = '958', $3 = '515840233385428300'

3

2s706ms

1,319

Details

0ms

19ms

2ms

SELECT symbolid, ;

Times Reported Time consuming bind #3

Day	Hour	Count	Duration	Avg duration
	12	1,319	2s706ms	2ms

SELECT symbolid, ;

Date: 2025-12-18 12:32:39 Duration: 19ms Database: postgres parameters: $1 = 'AXIORY', $2 = '15', $3 = 'ASX'
SELECT symbolid, ;

Date: 2025-12-18 12:31:55 Duration: 15ms Database: postgres parameters: $1 = 'BDSWISS', $2 = '15', $3 = 'SPX500', $4 = 'US30'
SELECT symbolid, ;

Date: 2025-12-18 12:46:11 Duration: 9ms Database: postgres parameters: $1 = 'ATFX', $2 = '15', $3 = '#FME'

4

1s12ms

50,950

Details

0ms

6ms

0ms

select 1;

Times Reported Time consuming bind #4

Day	Hour	Count	Duration	Avg duration
	12	50,950	1s12ms	0ms

select 1;

Date: 2025-12-18 12:12:15 Duration: 6ms Database: postgres
select 1;

Date: 2025-12-18 12:46:50 Duration: 4ms Database: postgres
select 1;

Date: 2025-12-18 12:34:09 Duration: 2ms Database: postgres

5

943ms

649

Details

1ms

5ms

1ms

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

Times Reported Time consuming bind #5

Day	Hour	Count	Duration	Avg duration
	12	649	943ms	1ms

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

Date: 2025-12-18 12:31:55 Duration: 5ms Database: postgres parameters: $1 = 'BDSWISS'
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;

Date: 2025-12-18 12:16:15 Duration: 1ms Database: postgres parameters: $1 = 'ICMARKETS-AU-MT5'
SELECT s.symbolid, dss.downloadfrequency, dss.downloadersymbol;

Date: 2025-12-18 12:15:24 Duration: 1ms Database: postgres parameters: $1 = 'PEPPERSTONEMT5'

6

700ms

23

Details

16ms

91ms

30ms

with wh_patitioned as ( ;

Times Reported Time consuming bind #6

Day	Hour	Count	Duration	Avg duration
	12	23	700ms	30ms

with wh_patitioned as ( ;

Date: 2025-12-18 12:33:09 Duration: 91ms 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: 2025-12-18 12:45:58 Duration: 47ms Database: postgres parameters: $1 = '558', $2 = '558', $3 = '558', $4 = '558', $5 = '558', $6 = '558', $7 = '558', $8 = '558', $9 = '558'
with wh_patitioned as ( ;

Date: 2025-12-18 12:10:53 Duration: 44ms Database: postgres parameters: $1 = '627', $2 = '627', $3 = '627', $4 = '627', $5 = '627', $6 = '627', $7 = '627', $8 = '627', $9 = '627'

7

663ms

16

Details

28ms

44ms

41ms

with sym_info as ( ;

Times Reported Time consuming bind #7

Day	Hour	Count	Duration	Avg duration
	12	16	663ms	41ms

with sym_info as ( ;

Date: 2025-12-18 12:36:52 Duration: 44ms Database: postgres parameters: $1 = '627', $2 = 'Forex', $3 = 'Forex', $4 = '627', $5 = 'Forex', $6 = '627', $7 = '627', $8 = 'Forex', $9 = '627'
with sym_info as ( ;

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

Date: 2025-12-18 12:06:44 Duration: 44ms Database: postgres parameters: $1 = '620', $2 = 'Forex', $3 = 'Forex', $4 = '620', $5 = 'Forex', $6 = '620', $7 = '620', $8 = 'Forex', $9 = '620'

8

481ms

46

Details

0ms

21ms

10ms

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

Times Reported Time consuming bind #8

Day	Hour	Count	Duration	Avg duration
	12	46	481ms	10ms

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

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

Date: 2025-12-18 12:12:48 Duration: 19ms Database: postgres parameters: $1 = '689', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'
WITH /*Latest.JapSticks*/ all_results AS ( SELECT ;

Date: 2025-12-18 12:18:39 Duration: 19ms Database: postgres parameters: $1 = '667', $2 = '0', $3 = '0', $4 = '0', $5 = '', $6 = '0', $7 = '', $8 = '0', $9 = '', $10 = '0', $11 = '0'

9

469ms

60

Details

4ms

13ms

7ms

WITH last_candle AS ( ;

Times Reported Time consuming bind #9

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

WITH last_candle AS ( ;

Date: 2025-12-18 12:28:02 Duration: 13ms Database: postgres parameters: $1 = '538', $2 = '538'
WITH last_candle AS ( ;

Date: 2025-12-18 12:32:00 Duration: 12ms Database: postgres parameters: $1 = '558', $2 = '558'
WITH last_candle AS ( ;

Date: 2025-12-18 12:16:00 Duration: 12ms Database: postgres parameters: $1 = '558', $2 = '558'

10

273ms

6,042

Details

0ms

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

Times Reported Time consuming bind #10

Day	Hour	Count	Duration	Avg duration
	12	6,042	273ms	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: 2025-12-18 12:11:56 Duration: 0ms Database: postgres parameters: $1 = '2025-12-18 11:45:00', $2 = '47941.9', $3 = '47955.7', $4 = '47934.65', $5 = '47954', $6 = '2264', $7 = '515840248000537300', $8 = '0', $9 = '2025-12-18 12:11:56.342', $10 = '2025-12-18 12:11:56.274', $11 = '47941.9', $12 = '47955.7', $13 = '47934.65', $14 = '47954', $15 = '2264', $16 = '0', $17 = '2025-12-18 12:11:56.342', $18 = '2025-12-18 12:11:56.274'
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: 2025-12-18 12:46:45 Duration: 0ms Database: postgres parameters: $1 = '2025-12-18 13:30:00', $2 = '155.951', $3 = '155.9525', $4 = '155.899', $5 = '155.906', $6 = '458', $7 = '515840249375237300', $8 = '0', $9 = '2025-12-18 12:46:45.897', $10 = '2025-12-18 12:46:45.847', $11 = '155.951', $12 = '155.9525', $13 = '155.899', $14 = '155.906', $15 = '458', $16 = '0', $17 = '2025-12-18 12:46:45.897', $18 = '2025-12-18 12:46:45.847'
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: 2025-12-18 12:41:53 Duration: 0ms Database: postgres parameters: $1 = '2025-12-18 12:15:00', $2 = '24837.3', $3 = '24858.3', $4 = '24824.8', $5 = '24856.17', $6 = '2610', $7 = '515840248038958300', $8 = '0', $9 = '2025-12-18 12:41:53.163', $10 = '2025-12-18 12:41:53.081', $11 = '24837.3', $12 = '24858.3', $13 = '24824.8', $14 = '24856.17', $15 = '2610', $16 = '0', $17 = '2025-12-18 12:41:53.163', $18 = '2025-12-18 12:41:53.081'

11

257ms

3,396

Details

0ms

4ms

0ms

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

Times Reported Time consuming bind #11

Day	Hour	Count	Duration	Avg duration
	12	3,396	257ms	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: 2025-12-18 12:32:51 Duration: 4ms Database: postgres parameters: $1 = '2025-12-17 22:30:00', $2 = '206.585', $3 = '206.79', $4 = '205.765', $5 = '206.27', $6 = '1043', $7 = '515840249438348300', $8 = '0', $9 = '2025-12-18 12:32:51.449', $10 = '2025-12-18 12:32:51.441', $11 = '206.585', $12 = '206.79', $13 = '205.765', $14 = '206.27', $15 = '1043', $16 = '0', $17 = '2025-12-18 12:32:51.449', $18 = '2025-12-18 12:32:51.441'
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: 2025-12-18 12:01:00 Duration: 1ms Database: postgres parameters: $1 = '2025-12-18 11:30:00', $2 = '4324.51', $3 = '4326.89', $4 = '4320.72', $5 = '4323.28', $6 = '7186', $7 = '515840233496175300', $8 = '0', $9 = '2025-12-18 12:01:00.393', $10 = '2025-12-18 12:01:00.371', $11 = '4324.51', $12 = '4326.89', $13 = '4320.72', $14 = '4323.28', $15 = '7186', $16 = '0', $17 = '2025-12-18 12:01:00.393', $18 = '2025-12-18 12:01:00.371'
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: 2025-12-18 12:10:55 Duration: 0ms Database: postgres parameters: $1 = '2025-12-18 11:00:00', $2 = '47885.55', $3 = '47916.4', $4 = '47880.9', $5 = '47915.05', $6 = '6223', $7 = '515840248000726300', $8 = '0', $9 = '2025-12-18 12:10:55.715', $10 = '2025-12-18 12:10:55.637', $11 = '47885.55', $12 = '47916.4', $13 = '47880.9', $14 = '47915.05', $15 = '6223', $16 = '0', $17 = '2025-12-18 12:10:55.715', $18 = '2025-12-18 12:10:55.637'

12

166ms

2,196

Details

0ms

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

Times Reported Time consuming bind #12

Day	Hour	Count	Duration	Avg duration
	12	2,196	166ms	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: 2025-12-18 12:01:04 Duration: 0ms Database: postgres parameters: $1 = '2025-12-18 11:00:00', $2 = '15182.5', $3 = '15188.5', $4 = '15175', $5 = '15188', $6 = '697', $7 = '500991628278916200', $8 = '0', $9 = '2025-12-18 12:01:04.591', $10 = '2025-12-18 12:01:04.498', $11 = '15182.5', $12 = '15188.5', $13 = '15175', $14 = '15188', $15 = '697', $16 = '0', $17 = '2025-12-18 12:01:04.591', $18 = '2025-12-18 12:01:04.498'
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: 2025-12-18 12:11:56 Duration: 0ms Database: postgres parameters: $1 = '2025-12-18 11:00:00', $2 = '47885.55', $3 = '47955.7', $4 = '47880.9', $5 = '47954', $6 = '11004', $7 = '515840248000890300', $8 = '0', $9 = '2025-12-18 12:11:56.414', $10 = '2025-12-18 12:11:56.308', $11 = '47885.55', $12 = '47955.7', $13 = '47880.9', $14 = '47954', $15 = '11004', $16 = '0', $17 = '2025-12-18 12:11:56.414', $18 = '2025-12-18 12:11:56.308'
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: 2025-12-18 12:16:02 Duration: 0ms Database: postgres parameters: $1 = '2025-12-18 11:00:00', $2 = '8601.45', $3 = '8611.45', $4 = '8599.45', $5 = '8609.45', $6 = '252', $7 = '500991628266153200', $8 = '0', $9 = '2025-12-18 12:16:02.607', $10 = '2025-12-18 12:16:02.587', $11 = '8601.45', $12 = '8611.45', $13 = '8599.45', $14 = '8609.45', $15 = '252', $16 = '0', $17 = '2025-12-18 12:16:02.607', $18 = '2025-12-18 12:16:02.587'

13

122ms

1,311

Details

0ms

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

Times Reported Time consuming bind #13

Day	Hour	Count	Duration	Avg duration
	12	1,311	122ms	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: 2025-12-18 12:17:09 Duration: 0ms Database: postgres parameters: $1 = '2025-12-18 08:00:00', $2 = '44242.51', $3 = '44352.51', $4 = '44202.51', $5 = '44347.49', $6 = '1972', $7 = '500991628285822200', $8 = '0', $9 = '2025-12-18 12:17:09.292', $10 = '2025-12-18 12:17:09.292', $11 = '44242.51', $12 = '44352.51', $13 = '44202.51', $14 = '44347.49', $15 = '1972', $16 = '0', $17 = '2025-12-18 12:17:09.292', $18 = '2025-12-18 12:17:09.292'
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: 2025-12-18 12:01:02 Duration: 0ms Database: postgres parameters: $1 = '2025-12-18 08:00:00', $2 = '34.73', $3 = '34.98', $4 = '34.61', $5 = '34.91', $6 = '1794', $7 = '515840246004073300', $8 = '0', $9 = '2025-12-18 12:01:02.907', $10 = '2025-12-18 12:01:02.906', $11 = '34.73', $12 = '34.98', $13 = '34.61', $14 = '34.91', $15 = '1794', $16 = '0', $17 = '2025-12-18 12:01:02.907', $18 = '2025-12-18 12:01:02.906'
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: 2025-12-18 12:01:08 Duration: 0ms Database: postgres parameters: $1 = '2025-12-18 08:00:00', $2 = '0.66062', $3 = '0.6614', $4 = '0.66044', $5 = '0.66066', $6 = '9880', $7 = '515840230435554300', $8 = '0', $9 = '2025-12-18 12:01:08.045', $10 = '2025-12-18 12:01:08.044', $11 = '0.66062', $12 = '0.6614', $13 = '0.66044', $14 = '0.66066', $15 = '9880', $16 = '0', $17 = '2025-12-18 12:01:08.045', $18 = '2025-12-18 12:01:08.044'

14

102ms

254

Details

0ms

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

Times Reported Time consuming bind #14

Day	Hour	Count	Duration	Avg duration
	12	254	102ms	0ms

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

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

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

Date: 2025-12-18 12:13:19 Duration: 0ms Database: postgres

15

71ms

77

Details

0ms

2ms

0ms

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

Times Reported Time consuming bind #15

Day	Hour	Count	Duration	Avg duration
	12	77	71ms	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: 2025-12-18 12:16:53 Duration: 2ms Database: postgres parameters: $1 = '689', $2 = 'XAUUSD', $3 = '689'
SELECT timegranularity FROM brokersymbollist bsl INNER JOIN symbols s ON bsl.symbolid = s.symbolid INNER JOIN downloadersymbolsettings dss on s.symbolid = dss.symbolid LEFT OUTER JOIN brokerinstrumentmapping bdfi ON bdfi.brokerid = $1 AND dss.datafeedinstrumentid = bdfi.datafeedinstrumentid WHERE s.nonliquid = 0 and s.deleted = 0 and dss.enabled = 1 AND s.symbol ILIKE $2 AND bsl.brokerid = $3 AND timegranularity >= 15 ORDER BY timegranularity LIMIT 1;

Date: 2025-12-18 12:17:01 Duration: 2ms Database: postgres parameters: $1 = '538', $2 = 'AUDCHFr', $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: 2025-12-18 12:00:44 Duration: 1ms Database: postgres parameters: $1 = '667', $2 = 'USDJPY', $3 = '667'

16

48ms

1

Details

48ms

with maxwhid as ( ;

Times Reported Time consuming bind #16

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

with maxwhid as ( ;

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

17

46ms

8

Details

3ms

10ms

5ms

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

Times Reported Time consuming bind #17

Day	Hour	Count	Duration	Avg duration
	12	8	46ms	5ms

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

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

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

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

18

46ms

9

Details

3ms

6ms

5ms

SELECT DISTINCT ON (basegroupname, symbol) ;

Times Reported Time consuming bind #18

Day	Hour	Count	Duration	Avg duration
	12	9	46ms	5ms

SELECT DISTINCT ON (basegroupname, symbol) ;

Date: 2025-12-18 12:11:54 Duration: 6ms Database: postgres parameters: $1 = '958', $2 = '958'
SELECT DISTINCT ON (basegroupname, symbol) ;

Date: 2025-12-18 12:27:02 Duration: 6ms Database: postgres parameters: $1 = '667', $2 = '667'
SELECT DISTINCT ON (basegroupname, symbol) ;

Date: 2025-12-18 12:27:03 Duration: 5ms Database: postgres parameters: $1 = '667', $2 = '667'

19

30ms

283

Details

0ms

1ms

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

Day	Hour	Count	Duration	Avg duration
	12	283	30ms	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: 2025-12-18 12:09:15 Duration: 1ms Database: postgres parameters: $1 = '607348361143086301'
/*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: 2025-12-18 12:10:00 Duration: 0ms Database: postgres parameters: $1 = '607348360973387301'
/*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: 2025-12-18 12:19:57 Duration: 0ms Database: postgres parameters: $1 = '607348656974377301'

20

28ms

5,974

Details

0ms

SET extra_float_digits = 3;

Times Reported Time consuming bind #20

Day	Hour	Count	Duration	Avg duration
	12	5,974	28ms	0ms

SET extra_float_digits = 3;

Date: 2025-12-18 12:47:41 Duration: 0ms Database: postgres
SET extra_float_digits = 3;

Date: 2025-12-18 12:33:09 Duration: 0ms Database: postgres
SET extra_float_digits = 3;

Date: 2025-12-18 12:32:39 Duration: 0ms Database: postgres

Log levels

Key values

694,162 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	414	0.06%
DETAIL	154,808	22.30%
LOG	538,374	77.56%
STATEMENT	566	0.08%

Events distribution

Key values

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

Errors per 5 minutes

NO DATASET

Most Frequent Errors/Events

Key values

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

Rank	Times reported	Error
NO DATASET

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

Queries generating the most temporary files (N)

Queries generating the largest temporary files

Vacuums

Vacuums / Analyzes Distribution

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Autovacuum Activity

Locks

Locks by types

Key values

Type of locks

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values

Queries by user

Key values

Duration by user