pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sat Nov 1 05:59:34 2025
Log file: /home/postgres/pg_data/data/pg_log/postgresql-2025-11-01_070000.log
Parsed 539,528 log entries in 33s
Log start from 2025-11-01 07:00:00 to 2025-11-01 07:59:31

Global Stats

2,705 Number of unique normalized queries
45,329 Number of queries
2h59m1s Total query duration
2025-11-01 07:00:00 First query
2025-11-01 07:59:31 Last query
296 queries/s at 2025-11-01 07:41:38 Query peak

2h59m1s Total query duration
3s766ms Prepare/parse total duration
28s672ms Bind total duration
2h58m29s 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

6 Total number of automatic vacuums
12 Total number of automatic analyzes

133 Number temporary file
8.24 MiB Max size of temporary file
4.44 MiB Average size of temporary file

1,714 Total number of sessions
13 sessions at 2025-11-01 07:57:02 Session peak
1d2h10m2s Total duration of sessions
54s960ms Average duration of sessions
26 Average queries per session
6s266ms Average queries duration per session
48s693ms Average idle time per session

1,704 Total number of connections
27 connections/s at 2025-11-01 07:53:50 Connection peak
2 Total number of databases

SQL Traffic

Key values

296 queries/s Query Peak
2025-11-01 07:41:38 Date

SELECT Traffic

Key values

252 queries/s Query Peak
2025-11-01 07:41:38 Date

INSERT/UPDATE/DELETE Traffic

Key values

246 queries/s Query Peak
2025-11-01 07:12:11 Date

Queries duration

Key values

2h59m1s 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)
Nov 01	07	45,329	0ms	54s316ms	236ms	5m46s	6m19s	6m33s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Nov 01	07	12,696	0	6ms	1s198ms	1s953ms	5s673ms

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Nov 01	07	25,898	926	0	0	1ms	179ms	359ms	3s208ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Nov 01	07	11,058	23,116	2.09	25.76%

Day	Hour	Count	Average / Second
Nov 01	07	1,704	0.47/s

Day	Hour	Count	Average Duration	Average idle time
Nov 01	07	1,714	54s960ms	48s712ms

↑ Back to the top of the General Activity table

Established Connections

Key values

27 connections Connection Peak
2025-11-01 07:53:50 Date

Connections per database

Key values

acaweb_fx Main Database
1,704 connections Total

Chart
Table

Database	User	Count
acaweb_fx		1,615
	postgres	1,549
	psql	66
socialmedia		89
	postgres	89

Connections per user

Key values

postgres Main User
1,704 connections Total

Chart
Table

User	Count
postgres	1,638
psql	66

Connections per host

Key values

192.168.4.142 Main host with 765 connections
1,704 Total connections

Chart
Table

Host	Count
192.168.0.114	2
192.168.0.216	114
192.168.0.74	98
192.168.1.15	40
192.168.1.20	20
192.168.1.231	10
192.168.1.239	50
192.168.1.90	7
192.168.2.126	19
192.168.2.205	12
192.168.2.82	44
192.168.3.199	38
192.168.4.142	765
192.168.4.33	89
192.168.4.98	330
[local]	66

Simultaneous sessions

Key values

13 sessions Session Peak
2025-11-01 07:57:02 Date

Histogram of session times

Key values

1,276 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	1,276	74.45%
500ms-1s	118	6.88%
1s-30s	249	14.53%
30s-1m	7	0.41%
1m-10m	22	1.28%
10m-30m	31	1.81%
30m-1h	9	0.53%
1h-8h	2	0.12%
> 8h	0	0.00%

Sessions per database

Key values

acaweb_fx Main Database
1,714 sessions Total

Chart
Table

Database	User	Count	Total Duration	Average Duration
acaweb_fx	1,625	1d2h8m41s	57s920ms
socialmedia	89	1m21s	914ms

Sessions per user

Key values

postgres Main User
1,714 sessions Total

Chart
Table

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

Sessions per host

Key values

192.168.4.142 Main Host
1,714 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
192.168.0.114	2	10m	5m
192.168.0.216	114	5m45s	3s26ms
192.168.0.74	98	2h32m56s	1m33s
192.168.1.15	40	4h29m16s	6m43s
192.168.1.20	20	9h53m44s	29m41s
192.168.1.231	20	5h15m48s	15m47s
192.168.1.239	50	437ms	8ms
192.168.1.90	7	142ms	20ms
192.168.2.126	19	6s407ms	337ms
192.168.2.205	12	509ms	42ms
192.168.2.82	44	3h29m34s	4m45s
192.168.3.199	38	21s391ms	562ms
192.168.4.142	765	10m5s	791ms
192.168.4.33	89	1m21s	914ms
192.168.4.98	330	15s244ms	46ms
[local]	66	45s307ms	686ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
1,714 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	943	22h21m52s	1m25s
[unknown]	705	3h47m24s	19s354ms
psql	66	45s307ms	686ms

Checkpoints Buffers

Key values

2,639 buffers Checkpoint Peak
2025-11-01 07:05:02 Date
209.544 seconds Highest write time
0.014 seconds Sync time

Checkpoints Wal files

Key values

1 files Wal files usage Peak
2025-11-01 07:05:02 Date

Checkpoints distance

Key values

25.95 Mo Distance Peak
2025-11-01 07:05:02 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Nov 01	07	13,936	1,337.943s	0.045s	1,338.354s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Nov 01	07	0	0	6	1,118	0.013s	0s

Day	Hour	Count	Avg time (sec)
Nov 01	07	0	0s

Day	Hour	Mean distance	Mean estimate
Nov 01	07	7,626.75 kB	138,419.58 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

8.24 MiB Temp Files size Peak
2025-11-01 07:26:16 Date

Number of temporary files

Key values

2 per second Temp Files Peak
2025-11-01 07:17:07 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Nov 01	07	133	590.03 MiB	4.44 MiB

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	132	586.10 MiB	3.27 MiB	8.24 MiB	4.44 MiB	with rar_max as ( ; WITH rar_max as ( ; Date: 2025-11-01 07:00:45 Duration: 0ms Database: acaweb_fx User: postgres Remote: 182.165.1.42 Application: [unknown]
2	1	3.93 MiB	3.93 MiB	3.93 MiB	3.93 MiB	select resultuid from relevance_fibonacci_results order by resultuid desc limit ?), fr as ( select a., rr.age, rr.relevant from fibonacci_results a left outer join relevance_fibonacci_results rr on a.resultuid = rr.resultuid where case when false = ? then true else a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) end), all_results as ( select fr.resultuid as resultuid, fr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, fr.pattern as pattern_name, fr.timed as timed, fr.patternendtime as identified, dtt.timezone as timezone, fr.patternlengthbars as length, g.basegroupname, newlevels.filtered, case when fr.age is not null then fr.age when fr.resultuid <= rm.resultuid then ? else ? end as age, case when fr.relevant is not null then fr.relevant when fr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from fr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = fr.symbolid inner join symbols s on fr.symbolid = s.symbolid and s.nonliquid = ? inner join symbolgroup sg on fr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join downloadersymbolsettings dss on fr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join rar_max rm on ? = ? left join lateral calc_fib_signal_filter (fr.resultuid) newlevels on true left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where fr.gmttimefound > now() - interval ? and dss.enabled = ? and s.deleted = ? and (fr.simulation = ? or fr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or fr.pattern in (...)) and (? = ? or fr.patternlengthbars <= ?) and (? = ? or (? = ? and fr.timed > cast(? as timestamp)) or (? = ? and fr.timed < cast(? as timestamp)))), results as ( select distinct on (symbolid) from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc; SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), fr AS ( SELECT a., rr.age, rr.relevant from fibonacci_results a LEFT OUTER JOIN relevance_fibonacci_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) END), all_results AS ( SELECT fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN fr.age IS NOT NULL THEN fr.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN fr.relevant IS NOT NULL THEN fr.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT JOIN LATERAL calc_fib_signal_filter (fr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($3 = 0 OR s.timegranularity in ($4, $5, $6, $7, $8, $9, $10)) AND ($11 = 0 OR s.exchange in ($12)) AND ($13 = 0 OR coalesce(bim.code, s.symbol) in ($14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323)) AND ($324 = 0 OR fr.pattern in ($325)) AND ($326 = 0 OR fr.patternlengthbars <= $327) AND ($328 = 0 OR ($329 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($330 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = $331 OR relevant = 1) AND ($332 = 0 OR age <= $333) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; Date: 2025-11-01 07:13:12 Duration: 0ms Database: acaweb_fx User: postgres Remote: 192.168.1.15 Application: PostgreSQL JDBC Driver

Queries generating the largest temporary files


[ Date: 2025-11-01 07:02:22 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver ]
[ Date: 2025-11-01 07:04:23 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver ]
[ Date: 2025-11-01 07:09:41 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver ]
[ Date: 2025-11-01 07:12:27 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver ]
[ Date: 2025-11-01 07:14:51 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver ]
[ Date: 2025-11-01 07:20:58 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver ]
[ Date: 2025-11-01 07:21:19 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver ]
[ Date: 2025-11-01 07:26:16 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver ]
[ Date: 2025-11-01 07:28:42 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver ]
[ Date: 2025-11-01 07:32:41 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver ]
[ Date: 2025-11-01 07:34:27 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver ]
[ Date: 2025-11-01 07:39:08 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver ]
[ Date: 2025-11-01 07:39:45 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver ]
[ Date: 2025-11-01 07:44:06 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver ]
[ Date: 2025-11-01 07:47:34 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver ]
[ Date: 2025-11-01 07:51:32 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver ]
[ Date: 2025-11-01 07:54:19 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver ]
[ Date: 2025-11-01 07:56:39 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver ]
[ Date: 2025-11-01 07:02:10 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.20 - Application: PostgreSQL JDBC Driver ]
[ Date: 2025-11-01 07:02:21 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.145 - Application: PostgreSQL JDBC Driver ]

Rank	Size	Query
1	8.24 MiB	WITH rar_max as ( ; [ Date: 2025-11-01 07:02:22 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver ]
2	8.24 MiB	WITH rar_max as ( ; [ Date: 2025-11-01 07:04:23 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver ]
3	8.24 MiB	WITH rar_max as ( ; [ Date: 2025-11-01 07:09:41 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver ]
4	8.24 MiB	WITH rar_max as ( ; [ Date: 2025-11-01 07:12:27 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver ]
5	8.24 MiB	WITH rar_max as ( ; [ Date: 2025-11-01 07:14:51 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver ]
6	8.24 MiB	WITH rar_max as ( ; [ Date: 2025-11-01 07:20:58 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver ]
7	8.24 MiB	WITH rar_max as ( ; [ Date: 2025-11-01 07:21:19 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver ]
8	8.24 MiB	WITH rar_max as ( ; [ Date: 2025-11-01 07:26:16 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver ]
9	8.24 MiB	WITH rar_max as ( ; [ Date: 2025-11-01 07:28:42 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver ]
10	8.24 MiB	WITH rar_max as ( ; [ Date: 2025-11-01 07:32:41 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver ]
11	8.24 MiB	WITH rar_max as ( ; [ Date: 2025-11-01 07:34:27 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver ]
12	8.24 MiB	WITH rar_max as ( ; [ Date: 2025-11-01 07:39:08 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver ]
13	8.24 MiB	WITH rar_max as ( ; [ Date: 2025-11-01 07:39:45 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver ]
14	8.24 MiB	WITH rar_max as ( ; [ Date: 2025-11-01 07:44:06 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver ]
15	8.24 MiB	WITH rar_max as ( ; [ Date: 2025-11-01 07:47:34 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver ]
16	8.24 MiB	WITH rar_max as ( ; [ Date: 2025-11-01 07:51:32 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver ]
17	8.24 MiB	WITH rar_max as ( ; [ Date: 2025-11-01 07:54:19 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver ]
18	8.24 MiB	WITH rar_max as ( ; [ Date: 2025-11-01 07:56:39 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver ]
19	3.99 MiB	WITH rar_max as ( ; [ Date: 2025-11-01 07:02:10 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.20 - Application: PostgreSQL JDBC Driver ]
20	3.99 MiB	WITH rar_max as ( ; [ Date: 2025-11-01 07:02:21 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.145 - Application: PostgreSQL JDBC Driver ]

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.datafeeds_latestrun (6) Main table analyzed (database acaweb_fx)
12 analyzes Total

Chart
Table

Table	Number of analyzes
acaweb_fx.public.datafeeds_latestrun	6
acaweb_fx.public.latest_t15_candle_view	2
acaweb_fx.pg_catalog.pg_depend	1
acaweb_fx.pg_catalog.pg_attribute	1
acaweb_fx.public.latest_candle_datetime_per_receng	1
socialmedia.public.processes	1
Total	12

Vacuums per table

Key values

public.datafeeds_latestrun (5) Main table vacuumed on database acaweb_fx
6 vacuums Total

Chart
Table

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
acaweb_fx.public.datafeeds_latestrun	5	0	615	0	21	0	0	73	18	76,398
acaweb_fx.public.latest_t15_candle_view	1	1	75	0	1	0	0	6	4	11,021
Total	6	1	690	0	22	0	0	79	22	87,419

Tuples removed per table

Key values

public.datafeeds_latestrun (296) Main table with removed tuples on database acaweb_fx
351 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
acaweb_fx.public.datafeeds_latestrun	5	0	296	76	6	0	80
acaweb_fx.public.latest_t15_candle_view	1	1	55	14	0	0	1
Total	6	1	351	90	6	0	81

Pages removed per table

Key values

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

Chart
Table

Pages removed per tables

NO DATASET

Table	Number of vacuums	Index scans	Tuples removed
acaweb_fx.public.latest_t15_candle_view	1	1	55
acaweb_fx.public.datafeeds_latestrun	5	0	296
Total	6	1	351

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Nov 01	07	6	12

↑ 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

12,696 Total read queries
30,227 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	12,696	28.01%
INSERT	25,898	57.13%
UPDATE	926	2.04%
DELETE	0	0.00%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	2,739	6.04%
DDL	0	0.00%
TCL	664	1.46%
CURSOR	0	0.00%
OTHERS	2,406	5.31%

Queries by database

Key values

acaweb_fx Main database
36,552 Requests
2h58m19s (acaweb_fx)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
acaweb_fx	Total	36,552	2h58m19s
	cte	2,739	2h56m22s
	insert	17,539	26s541ms
	others	2,406	8s425ms
	select	12,338	1m19s
	tcl	664	193ms
	update	866	1s727ms
socialmedia	Total	8,777	9s954ms
	insert	8,359	9s563ms
	select	358	282ms
	update	60	108ms

Queries by user

Key values

postgres Main user
45,329 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	45,329	2h58m29s
	cte	2,739	2h56m22s
	insert	25,898	36s105ms
	others	2,406	8s425ms
	select	12,696	1m19s
	tcl	664	193ms
	update	926	1s835ms

Duration by user

Key values

2h58m29s (postgres) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	45,329	2h58m29s
	cte	2,739	2h56m22s
	insert	25,898	36s105ms
	others	2,406	8s425ms
	select	12,696	1m19s
	tcl	664	193ms
	update	926	1s835ms

Queries by host

Key values

192.168.4.142 Main host
11,004 Requests
48m23s (192.168.1.15)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	2,400	14s112ms
	insert	1,057	1s370ms
	select	1,034	12s570ms
	update	309	171ms
182.165.1.42	Total	120	8m10s
	cte	60	8m10s
	select	60	0ms
192.168.0.114	Total	10	45ms
	others	2	0ms
	select	4	45ms
	tcl	4	0ms
192.168.0.216	Total	456	381ms
	others	228	21ms
	select	220	259ms
	update	8	100ms
192.168.0.239	Total	55	135ms
	select	55	135ms
192.168.0.42	Total	407	202ms
	insert	181	17ms
	select	226	184ms
192.168.0.74	Total	2,871	44m21s
	cte	786	44m19s
	others	196	2ms
	select	1,889	2s265ms
192.168.1.135	Total	42	53ms
	cte	3	14ms
	select	39	39ms
192.168.1.145	Total	2,696	37m36s
	cte	545	37m35s
	select	2,151	1s
192.168.1.15	Total	2,792	48m23s
	cte	815	48m21s
	others	80	0ms
	select	1,897	1s797ms
192.168.1.20	Total	1,771	37m55s
	cte	530	37m55s
	others	40	0ms
	select	1,201	427ms
192.168.1.201	Total	572	1s931ms
	select	572	1s931ms
192.168.1.210	Total	92	3ms
	select	92	3ms
192.168.1.23	Total	545	1s860ms
	select	545	1s860ms
192.168.1.231	Total	20	0ms
	others	20	0ms
192.168.1.239	Total	200	130ms
	others	100	9ms
	select	100	120ms
192.168.1.90	Total	7	89ms
	select	7	89ms
192.168.2.126	Total	31	50ms
	others	12	0ms
	select	19	50ms
192.168.2.205	Total	137	114ms
	insert	89	11ms
	others	24	2ms
	select	20	19ms
	update	4	81ms
192.168.2.82	Total	9,110	31s890ms
	insert	8,196	22s380ms
	others	88	9ms
	select	645	8s949ms
	update	181	550ms
192.168.3.199	Total	152	217ms
	others	76	7ms
	select	64	69ms
	update	12	140ms
192.168.4.142	Total	11,004	5s663ms
	insert	8,016	2s761ms
	others	1,530	19ms
	select	1,458	2s881ms
192.168.4.33	Total	8,777	9s954ms
	insert	8,359	9s563ms
	select	358	282ms
	update	60	108ms
192.168.4.98	Total	996	8s926ms
	others	6	8s91ms
	select	6	27ms
	tcl	660	193ms
	update	324	614ms
[local]	Total	66	45s116ms
	others	4	258ms
	select	34	44s790ms
	update	28	67ms

Queries by application

Key values

[unknown] Main application
23,329 Requests
2h48m27s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	21,934	2h48m27s
	cte	2,679	2h48m11s
	insert	8,197	2s779ms
	others	933	14ms
	select	10,125	12s527ms
[unknown]	Total	23,329	9m16s
	cte	60	8m10s
	insert	17,701	33s325ms
	others	1,469	8s152ms
	select	2,537	22s485ms
	tcl	664	193ms
	update	898	1s767ms
psql	Total	66	45s116ms
	others	4	258ms
	select	34	44s790ms
	update	28	67ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-11-01 07:53:33 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

23,037 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	23,037	50.82%
1-5ms	18,974	41.86%
5-10ms	488	1.08%
10-25ms	527	1.16%
25-50ms	192	0.42%
50-100ms	120	0.26%
100-500ms	422	0.93%
500-1000ms	125	0.28%
1000-10000ms	1,102	2.43%
> 10000ms	342	0.75%

Slowest individual queries


[ Date: 2025-11-01 07:56:39 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-11-01 07:51:32 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-11-01 07:02:22 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-11-01 07:26:16 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-11-01 07:47:34 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-11-01 07:32:41 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-11-01 07:21:19 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-11-01 07:20:58 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-11-01 07:12:27 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-11-01 07:04:23 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-11-01 07:39:45 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-11-01 07:14:51 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-11-01 07:44:06 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-11-01 07:39:08 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-11-01 07:34:27 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-11-01 07:09:41 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-11-01 07:54:19 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-11-01 07:28:42 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-11-01 07:32:19 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.145 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-11-01 07:32:17 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.20 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Rank	Duration	Query
1	54s316ms	WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a., rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR coalesce(bim.code, s.symbol) in ('')) AND ('0' = 0 OR p.patternname in ('')) AND ('0' = 0 OR kr.patternclassid in ('0')) AND ('0' = 0 OR kr.patternlengthbars <= '0') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200; [ Date: 2025-11-01 07:56:39 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2	49s95ms	WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a., rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR coalesce(bim.code, s.symbol) in ('')) AND ('0' = 0 OR p.patternname in ('')) AND ('0' = 0 OR kr.patternclassid in ('0')) AND ('0' = 0 OR kr.patternlengthbars <= '0') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200; [ Date: 2025-11-01 07:51:32 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3	42s939ms	WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a., rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR coalesce(bim.code, s.symbol) in ('')) AND ('0' = 0 OR p.patternname in ('')) AND ('0' = 0 OR kr.patternclassid in ('0')) AND ('0' = 0 OR kr.patternlengthbars <= '0') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200; [ Date: 2025-11-01 07:02:22 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4	41s446ms	WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a., rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR coalesce(bim.code, s.symbol) in ('')) AND ('0' = 0 OR p.patternname in ('')) AND ('0' = 0 OR kr.patternclassid in ('0')) AND ('0' = 0 OR kr.patternlengthbars <= '0') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200; [ Date: 2025-11-01 07:26:16 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5	38s214ms	WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a., rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR coalesce(bim.code, s.symbol) in ('')) AND ('0' = 0 OR p.patternname in ('')) AND ('0' = 0 OR kr.patternclassid in ('0')) AND ('0' = 0 OR kr.patternlengthbars <= '0') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200; [ Date: 2025-11-01 07:47:34 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6	36s377ms	WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a., rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR coalesce(bim.code, s.symbol) in ('')) AND ('0' = 0 OR p.patternname in ('')) AND ('0' = 0 OR kr.patternclassid in ('0')) AND ('0' = 0 OR kr.patternlengthbars <= '0') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200; [ Date: 2025-11-01 07:32:41 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7	34s755ms	WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a., rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR coalesce(bim.code, s.symbol) in ('')) AND ('0' = 0 OR p.patternname in ('')) AND ('0' = 0 OR kr.patternclassid in ('0')) AND ('0' = 0 OR kr.patternlengthbars <= '0') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200; [ Date: 2025-11-01 07:21:19 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8	33s80ms	WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a., rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR coalesce(bim.code, s.symbol) in ('')) AND ('0' = 0 OR p.patternname in ('')) AND ('0' = 0 OR kr.patternclassid in ('0')) AND ('0' = 0 OR kr.patternlengthbars <= '0') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200; [ Date: 2025-11-01 07:20:58 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9	32s621ms	WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a., rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR coalesce(bim.code, s.symbol) in ('')) AND ('0' = 0 OR p.patternname in ('')) AND ('0' = 0 OR kr.patternclassid in ('0')) AND ('0' = 0 OR kr.patternlengthbars <= '0') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200; [ Date: 2025-11-01 07:12:27 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10	31s334ms	WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a., rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR coalesce(bim.code, s.symbol) in ('')) AND ('0' = 0 OR p.patternname in ('')) AND ('0' = 0 OR kr.patternclassid in ('0')) AND ('0' = 0 OR kr.patternlengthbars <= '0') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200; [ Date: 2025-11-01 07:04:23 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11	31s295ms	WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a., rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR coalesce(bim.code, s.symbol) in ('')) AND ('0' = 0 OR p.patternname in ('')) AND ('0' = 0 OR kr.patternclassid in ('0')) AND ('0' = 0 OR kr.patternlengthbars <= '0') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200; [ Date: 2025-11-01 07:39:45 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12	31s293ms	WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a., rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR coalesce(bim.code, s.symbol) in ('')) AND ('0' = 0 OR p.patternname in ('')) AND ('0' = 0 OR kr.patternclassid in ('0')) AND ('0' = 0 OR kr.patternlengthbars <= '0') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200; [ Date: 2025-11-01 07:14:51 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13	31s262ms	WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a., rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR coalesce(bim.code, s.symbol) in ('')) AND ('0' = 0 OR p.patternname in ('')) AND ('0' = 0 OR kr.patternclassid in ('0')) AND ('0' = 0 OR kr.patternlengthbars <= '0') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200; [ Date: 2025-11-01 07:44:06 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14	31s227ms	WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a., rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR coalesce(bim.code, s.symbol) in ('')) AND ('0' = 0 OR p.patternname in ('')) AND ('0' = 0 OR kr.patternclassid in ('0')) AND ('0' = 0 OR kr.patternlengthbars <= '0') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200; [ Date: 2025-11-01 07:39:08 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15	31s157ms	WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a., rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR coalesce(bim.code, s.symbol) in ('')) AND ('0' = 0 OR p.patternname in ('')) AND ('0' = 0 OR kr.patternclassid in ('0')) AND ('0' = 0 OR kr.patternlengthbars <= '0') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200; [ Date: 2025-11-01 07:34:27 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16	31s29ms	WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a., rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR coalesce(bim.code, s.symbol) in ('')) AND ('0' = 0 OR p.patternname in ('')) AND ('0' = 0 OR kr.patternclassid in ('0')) AND ('0' = 0 OR kr.patternlengthbars <= '0') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200; [ Date: 2025-11-01 07:09:41 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17	31s16ms	WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a., rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR coalesce(bim.code, s.symbol) in ('')) AND ('0' = 0 OR p.patternname in ('')) AND ('0' = 0 OR kr.patternclassid in ('0')) AND ('0' = 0 OR kr.patternlengthbars <= '0') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200; [ Date: 2025-11-01 07:54:19 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18	30s535ms	WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a., rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR coalesce(bim.code, s.symbol) in ('')) AND ('0' = 0 OR p.patternname in ('')) AND ('0' = 0 OR kr.patternclassid in ('0')) AND ('0' = 0 OR kr.patternlengthbars <= '0') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200; [ Date: 2025-11-01 07:28:42 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19	25s613ms	WITH rar_max as ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1 ), ar AS ( SELECT a., rr.age, rr.relevant from autochartist_results a LEFT OUTER JOIN relevance_autochartist_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_autochartist_results) END ), all_results AS ( SELECT ar.resultuid AS resultuid, ar.direction AS direction, ar.predictiontimeto AS predictiontimeto, ar.predictionpricefrom AS predictionpricefrom, ar.predictionpriceto AS predictionpriceto, cp.pip AS pip, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, ar.pattern AS pattern_name, ar.breakout AS breakout, ar.patternendtime AS identified, dtt.timezone AS timezone, ar.patternlengthbars AS length, g.basegroupname, newLevels.profit, newLevels.stop, newLevels.filtered, CASE WHEN ar.age IS NOT NULL THEN ar.age WHEN ar.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN ar.relevant IS NOT NULL THEN ar.relevant WHEN ar.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM ar INNER JOIN symbols s ON ar.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN brokersymbollist bsl ON bsl.brokerid = '627' AND bsl.symbolid = s.symbolid INNER JOIN symbolgroup sg on bsl.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON sg.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN currencypips cp ON s.symbol = cp.symbol LEFT JOIN LATERAL calc_cp_signal (ar.resultuid) newLevels on true LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE ar.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (ar.simulation = 0 OR ar.simulation IS NULL) AND ('7' = 0 OR s.timegranularity in ('15', '30', '60', '120', '240', '480', '1440')) AND ('0' = 0 OR s.exchange in ('')) AND ('213' = 0 OR coalesce(bim.code, s.symbol) in ('#ADBE', '#ALVG', '#AMZN', '#APPL', '#BA', '#BABA', '#BAYGn', '#BMWG', '#BNPP', '#CAT', '#CBKG', '#DAIGn', '#DIS', '#EA', '#FB', '#FDX', '#GE', '#GM', '#GOOGL', '#GS', '#INTC', '#JPM', '#KO', '#META', '#MSFT', '#NFLX', '#TSLA', '#VOWG', '#WMT', '#XOM', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'AUS_200', 'BTCEUR', 'BTCGBP', 'BTCUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'CL_BRENT', 'DASHUSD', 'EOSUSD', 'ESP_35', 'ETHEUR', 'ETHGBP', 'ETHUSD', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURJPY', 'EURMXN', 'EURNOK', 'EURNZD', 'EURPLN', 'EURSEK', 'EURTRY', 'EURUSD', 'EUR_50', 'FRA_40', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GBPZAR', 'GBR_100', 'HKDJPY', 'HKG_50', 'IOTAUSD', 'LTCEUR', 'LTCUSD', 'NAS100', 'NEOUSD', 'NOKJPY', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'OMGUSD', 'SPX500', 'TRXUSD', 'US30', 'USDCAD', 'USDCHF', 'USDCNH', 'USDDKK', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDZAR', 'USOIL', 'XAGUSD', 'XAUEUR', 'XAUUSD', 'XMRUSD', 'XPTUSD', 'XRPUSD', 'ZARJPY', 'ZECUSD', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURJPY', 'EURMXN', 'EURNOK', 'EURNZD', 'EURPLN', 'EURSEK', 'EURTRY', 'EURUSD', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GBPZAR', 'HKDJPY', 'NOKJPY', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDCNH', 'USDDKK', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDZAR', 'ZARJPY', 'BTCEUR', 'BTCGBP', 'BTCUSD', 'DASHUSD', 'EOSUSD', 'ETHEUR', 'ETHGBP', 'ETHUSD', 'IOTAUSD', 'LTCEUR', 'LTCUSD', 'NEOUSD', 'OMGUSD', 'TRXUSD', 'XMRUSD', 'XRPUSD', 'ZECUSD', 'XAGUSD', 'XAUEUR', 'XAUUSD', 'XPTUSD', 'CL_BRENT', 'USOIL', '#ALVG', '#BAYGn', '#BMWG', '#BNPP', '#CBKG', '#DAIGn', '#VOWG', 'AUS_200', 'ESP_35', 'EUR_50', 'FRA_40', 'GBR_100', 'HKG_50', 'NAS100', 'SPX500', 'US30', '#ADBE', '#AMZN', '#APPL', '#BA', '#BABA', '#CAT', '#DIS', '#EA', '#FB', '#FDX', '#GE', '#GM', '#GOOGL', '#GS', '#INTC', '#JPM', '#KO', '#MSFT', '#NFLX', '#TSLA', '#WMT', '#XOM')) AND ('0' = 0 OR ar.pattern in ('')) AND ('0' = 0 OR ('0' = 1 AND ar.breakout >= 0) OR ('0' = 2 AND ar.breakout < 0)) AND ('500' = 0 OR ar.patternlengthbars <= '500') and newLevels.filtered = false AND ar.patternstarttime >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('10' = 0 OR age <= '10') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; [ Date: 2025-11-01 07:32:19 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.145 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20	25s526ms	WITH rar_max as ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1 ), ar AS ( SELECT a., rr.age, rr.relevant from autochartist_results a LEFT OUTER JOIN relevance_autochartist_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_autochartist_results) END ), all_results AS ( SELECT ar.resultuid AS resultuid, ar.direction AS direction, ar.predictiontimeto AS predictiontimeto, ar.predictionpricefrom AS predictionpricefrom, ar.predictionpriceto AS predictionpriceto, cp.pip AS pip, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, ar.pattern AS pattern_name, ar.breakout AS breakout, ar.patternendtime AS identified, dtt.timezone AS timezone, ar.patternlengthbars AS length, g.basegroupname, newLevels.profit, newLevels.stop, newLevels.filtered, CASE WHEN ar.age IS NOT NULL THEN ar.age WHEN ar.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN ar.relevant IS NOT NULL THEN ar.relevant WHEN ar.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM ar INNER JOIN symbols s ON ar.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN brokersymbollist bsl ON bsl.brokerid = '627' AND bsl.symbolid = s.symbolid INNER JOIN symbolgroup sg on bsl.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON sg.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN currencypips cp ON s.symbol = cp.symbol LEFT JOIN LATERAL calc_cp_signal (ar.resultuid) newLevels on true LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE ar.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (ar.simulation = 0 OR ar.simulation IS NULL) AND ('7' = 0 OR s.timegranularity in ('15', '30', '60', '120', '240', '480', '1440')) AND ('0' = 0 OR s.exchange in ('')) AND ('213' = 0 OR coalesce(bim.code, s.symbol) in ('#ADBE', '#ALVG', '#AMZN', '#APPL', '#BA', '#BABA', '#BAYGn', '#BMWG', '#BNPP', '#CAT', '#CBKG', '#DAIGn', '#DIS', '#EA', '#FB', '#FDX', '#GE', '#GM', '#GOOGL', '#GS', '#INTC', '#JPM', '#KO', '#META', '#MSFT', '#NFLX', '#TSLA', '#VOWG', '#WMT', '#XOM', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'AUS_200', 'BTCEUR', 'BTCGBP', 'BTCUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'CL_BRENT', 'DASHUSD', 'EOSUSD', 'ESP_35', 'ETHEUR', 'ETHGBP', 'ETHUSD', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURJPY', 'EURMXN', 'EURNOK', 'EURNZD', 'EURPLN', 'EURSEK', 'EURTRY', 'EURUSD', 'EUR_50', 'FRA_40', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GBPZAR', 'GBR_100', 'HKDJPY', 'HKG_50', 'IOTAUSD', 'LTCEUR', 'LTCUSD', 'NAS100', 'NEOUSD', 'NOKJPY', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'OMGUSD', 'SPX500', 'TRXUSD', 'US30', 'USDCAD', 'USDCHF', 'USDCNH', 'USDDKK', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDZAR', 'USOIL', 'XAGUSD', 'XAUEUR', 'XAUUSD', 'XMRUSD', 'XPTUSD', 'XRPUSD', 'ZARJPY', 'ZECUSD', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURJPY', 'EURMXN', 'EURNOK', 'EURNZD', 'EURPLN', 'EURSEK', 'EURTRY', 'EURUSD', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GBPZAR', 'HKDJPY', 'NOKJPY', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDCNH', 'USDDKK', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDZAR', 'ZARJPY', 'BTCEUR', 'BTCGBP', 'BTCUSD', 'DASHUSD', 'EOSUSD', 'ETHEUR', 'ETHGBP', 'ETHUSD', 'IOTAUSD', 'LTCEUR', 'LTCUSD', 'NEOUSD', 'OMGUSD', 'TRXUSD', 'XMRUSD', 'XRPUSD', 'ZECUSD', 'XAGUSD', 'XAUEUR', 'XAUUSD', 'XPTUSD', 'CL_BRENT', 'USOIL', '#ALVG', '#BAYGn', '#BMWG', '#BNPP', '#CBKG', '#DAIGn', '#VOWG', 'AUS_200', 'ESP_35', 'EUR_50', 'FRA_40', 'GBR_100', 'HKG_50', 'NAS100', 'SPX500', 'US30', '#ADBE', '#AMZN', '#APPL', '#BA', '#BABA', '#CAT', '#DIS', '#EA', '#FB', '#FDX', '#GE', '#GM', '#GOOGL', '#GS', '#INTC', '#JPM', '#KO', '#MSFT', '#NFLX', '#TSLA', '#WMT', '#XOM')) AND ('0' = 0 OR ar.pattern in ('')) AND ('0' = 0 OR ('0' = 1 AND ar.breakout >= 0) OR ('0' = 2 AND ar.breakout < 0)) AND ('500' = 0 OR ar.patternlengthbars <= '500') and newLevels.filtered = false AND ar.patternstarttime >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('10' = 0 OR age <= '10') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; [ Date: 2025-11-01 07:32:17 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.20 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Time consuming queries


[ User: postgres - Total duration: 1h15m54s - Times executed: 501 ]
[ User: postgres - Total duration: 1h12m18s - Times executed: 500 ]
[ User: postgres - Total duration: 25m4s - Times executed: 477 ]
[ User: postgres - Total duration: 2m15s - Times executed: 333 ]
[ User: postgres - Total duration: 44s790ms - Times executed: 34 ]
[ User: postgres - Total duration: 43s713ms - Times executed: 120 ]
[ User: postgres - Total duration: 9s234ms - Times executed: 8143 ]
[ User: postgres - Total duration: 8s91ms - Times executed: 6 ]
[ User: postgres - Total duration: 7s733ms - Times executed: 388 ]
[ User: postgres - Total duration: 6s246ms - Times executed: 58 ]
[ User: postgres - Total duration: 6s153ms - Times executed: 58 ]
[ User: postgres - Total duration: 4s662ms - Times executed: 333 ]
[ User: postgres - Total duration: 4s503ms - Times executed: 1339 ]
[ User: postgres - Total duration: 2s174ms - Times executed: 636 ]
[ User: postgres - Total duration: 2s47ms - Times executed: 600 ]
[ User: postgres - Total duration: 1s428ms - Times executed: 2688 ]
[ User: postgres - Total duration: 1s265ms - Times executed: 42 ]
[ User: postgres - Total duration: 1s153ms - Times executed: 1024 ]
[ User: postgres - Total duration: 1s108ms - Times executed: 40 ]
[ User: postgres - Total duration: 941ms - Times executed: 2 ]

Most frequent queries (N)


[ User: postgres - Total duration: 9s234ms - Times executed: 8143 ]
[ User: postgres - Total duration: 28ms - Times executed: 5508 ]
[ User: postgres - Total duration: 1s428ms - Times executed: 2688 ]
[ User: postgres - Total duration: 515ms - Times executed: 2304 ]
[ User: postgres - Total duration: 483ms - Times executed: 2287 ]
[ User: postgres - Total duration: 4s503ms - Times executed: 1339 ]
[ User: postgres - Total duration: 1s153ms - Times executed: 1024 ]
[ User: postgres - Total duration: 9ms - Times executed: 945 ]
[ User: postgres - Total duration: 14ms - Times executed: 933 ]
[ User: postgres - Total duration: 165ms - Times executed: 858 ]
[ User: postgres - Total duration: 793ms - Times executed: 736 ]
[ User: postgres - Total duration: 2s174ms - Times executed: 636 ]
[ User: postgres - Total duration: 764ms - Times executed: 619 ]
[ User: postgres - Total duration: 2s47ms - Times executed: 600 ]
[ User: postgres - Total duration: 1h15m54s - Times executed: 501 ]
[ User: postgres - Total duration: 1h12m18s - Times executed: 500 ]
[ User: postgres - Total duration: 25m4s - Times executed: 477 ]
[ User: postgres - Total duration: 137ms - Times executed: 419 ]
[ User: postgres - Total duration: 143ms - Times executed: 401 ]
[ User: postgres - Total duration: 7s733ms - Times executed: 388 ]

Normalized slowest queries (N)


[ User: postgres - Total duration: 1h15m54s - Times executed: 501 ]
[ User: postgres - Total duration: 1h12m18s - Times executed: 500 ]
[ User: postgres - Total duration: 25m4s - Times executed: 477 ]
[ User: postgres - Total duration: 8s91ms - Times executed: 6 ]
[ User: postgres - Total duration: 44s790ms - Times executed: 34 ]
[ User: postgres - Total duration: 941ms - Times executed: 2 ]
[ User: postgres - Total duration: 2m15s - Times executed: 333 ]
[ User: postgres - Total duration: 43s713ms - Times executed: 120 ]
[ User: postgres - Total duration: 6s246ms - Times executed: 58 ]
[ User: postgres - Total duration: 6s153ms - Times executed: 58 ]
[ User: postgres - Total duration: 1s265ms - Times executed: 42 ]
[ User: postgres - Total duration: 1s108ms - Times executed: 40 ]
[ User: postgres - Total duration: 7s733ms - Times executed: 388 ]
[ User: postgres - Total duration: 4s662ms - Times executed: 333 ]
[ User: postgres - Total duration: 2s174ms - Times executed: 636 ]
[ User: postgres - Total duration: 2s47ms - Times executed: 600 ]
[ User: postgres - Total duration: 4s503ms - Times executed: 1339 ]
[ User: postgres - Total duration: 764ms - Times executed: 619 ]
[ User: postgres - Total duration: 9s234ms - Times executed: 8143 ]
[ User: postgres - Total duration: 1s153ms - Times executed: 1024 ]

Time consuming prepare


[ User: postgres - Total duration: 2s347ms - Times executed: 746 ]
[ User: postgres - Total duration: 34m26s - Times executed: 809 ]
[ User: postgres - Total duration: 433ms - Times executed: 260 ]
[ User: postgres - Total duration: 2s960ms - Times executed: 969 ]
[ User: postgres - Total duration: 468ms - Times executed: 2194 ]
[ User: postgres - Total duration: 488ms - Times executed: 2274 ]
[ User: postgres - Total duration: 9ms - Times executed: 945 ]
[ User: postgres - Total duration: 1s108ms - Times executed: 650 ]
[ User: postgres - Total duration: 30ms - Times executed: 18 ]
[ User: postgres - Total duration: 191ms - Times executed: 336 ]
[ User: postgres - Total duration: 143ms - Times executed: 401 ]
[ User: postgres - Total duration: 1ms - Times executed: 418 ]
[ User: postgres - Total duration: 8ms - Times executed: 6 ]
[ User: postgres - Total duration: 14ms - Times executed: 933 ]
[ User: postgres - Total duration: 11ms - Times executed: 89 ]
[ User: postgres - Total duration: 44ms - Times executed: 2 ]
[ User: postgres - Total duration: 101ms - Times executed: 2 ]
[ User: postgres - Total duration: 898ms - Times executed: 3 ]
[ User: postgres - Total duration: 14ms - Times executed: 3 ]

Time consuming bind


[ User: postgres - Total duration: 2h55m37s - Times executed: 2543 ]
[ User: postgres - Total duration: 2s347ms - Times executed: 746 ]
[ User: postgres - Total duration: 4s628ms - Times executed: 2998 ]
[ User: postgres - Total duration: 43s295ms - Times executed: 119 ]
[ User: postgres - Total duration: 433ms - Times executed: 260 ]
[ User: postgres - Total duration: 483ms - Times executed: 2287 ]
[ User: postgres - Total duration: 515ms - Times executed: 2304 ]
[ User: postgres - Total duration: 1s428ms - Times executed: 2688 ]
[ User: postgres - Total duration: 24ms - Times executed: 5444 ]
[ User: postgres - Total duration: 143ms - Times executed: 401 ]
[ User: postgres - Total duration: 191ms - Times executed: 336 ]
[ User: postgres - Total duration: 932ms - Times executed: 5 ]
[ User: postgres - Total duration: 30ms - Times executed: 18 ]
[ User: postgres - Total duration: 14ms - Times executed: 161 ]
[ User: postgres - Total duration: 64ms - Times executed: 19 ]
[ User: postgres - Total duration: 7ms - Times executed: 205 ]
[ User: postgres - Total duration: 101ms - Times executed: 2 ]
[ User: postgres - Total duration: 1s265ms - Times executed: 42 ]
[ User: postgres - Total duration: 0ms - Times executed: 56 ]
[ User: postgres - Total duration: 44ms - Times executed: 2 ]

Log levels

Key values

116,346 Log entries

Chart
Table

Type	Count	Percentage
DETAIL	31,530	27.10%
LOG	84,816	72.90%

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

Pages removed per tables

Autovacuum Activity

Locks

Locks by types

Key values

Type of locks

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values

Queries by user

Key values