pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sun Oct 2 10:00:02 2022
Log file: /home/postgres/pg_data/data/pg_log/postgresql-2022-10-02_110000.log, ..., /home/postgres/pg_data/data/pg_log/postgresql-2022-10-02_114337.log
Parsed 1,070,143 log entries in 1m1s
Log start from 2022-10-02 11:00:00 to 2022-10-02 11:59:59

Global Stats

2,269 Number of unique normalized queries
105,310 Number of queries
59m35s Total query duration
2022-10-02 11:00:00 First query
2022-10-02 11:59:59 Last query
358 queries/s at 2022-10-02 11:01:54 Query peak

59m35s Total query duration
21s72ms Prepare/parse total duration
5m45s Bind total duration
53m28s Execute total duration

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

26 Total number of automatic vacuums
38 Total number of automatic analyzes

190 Number temporary file
12.24 MiB Max size of temporary file
7.95 MiB Average size of temporary file

5,368 Total number of sessions
11 sessions at 2022-10-02 11:41:16 Session peak
1d6h30m54s Total duration of sessions
20s464ms Average duration of sessions
19 Average queries per session
666ms Average queries duration per session
19s798ms Average idle time per session

5,368 Total number of connections
43 connections/s at 2022-10-02 11:12:20 Connection peak
1 Total number of databases

SQL Traffic

Key values

358 queries/s Query Peak
2022-10-02 11:01:54 Date

SELECT Traffic

Key values

135 queries/s Query Peak
2022-10-02 11:40:06 Date

INSERT/UPDATE/DELETE Traffic

Key values

329 queries/s Query Peak
2022-10-02 11:31:53 Date

Queries duration

Key values

59m35s 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)
Oct 02	11	105,310	0ms	32s250ms	30ms	1m44s	1m54s	2m7s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Oct 02	11	74,827	26	9ms	13s869ms	34s552ms	49s317ms

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Oct 02	11	18,911	430	16	96	3ms	991ms	1s496ms	3s953ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Oct 02	11	49,445	93,452	1.89	50.75%

Day	Hour	Count	Average / Second
Oct 02	11	5,368	1.49/s

Day	Hour	Count	Average Duration	Average idle time
Oct 02	11	5,368	20s464ms	19s866ms

↑ Back to the top of the General Activity table

Established Connections

Key values

43 connections Connection Peak
2022-10-02 11:12:20 Date

Connections per database

Key values

acaweb_fx Main Database
5,368 connections Total

Chart
Table

Database	User	Count
acaweb_fx		5,368
	postgres	4,993
	psql	375

Connections per user

Key values

postgres Main User
5,368 connections Total

Chart
Table

User	Count
postgres	4,993
psql	375

Connections per host

Key values

192.168.1.23 Main host with 1631 connections
5,368 Total connections

Chart
Table

Host	Count
127.0.0.1	111
172.10.1.90	23
192.168.0.216	176
192.168.0.239	227
192.168.0.42	270
192.168.1.135	13
192.168.1.201	842
192.168.1.23	1,631
192.168.1.239	166
192.168.1.25	6
192.168.1.250	194
192.168.1.44	139
192.168.1.45	21
192.168.2.126	18
192.168.2.205	28
192.168.2.82	40
192.168.3.199	93
192.168.4.142	1,002
192.168.4.98	104
[local]	264

Simultaneous sessions

Key values

11 sessions Session Peak
2022-10-02 11:41:16 Date

Histogram of session times

Key values

4,775 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	4,775	88.95%
500ms-1s	67	1.25%
1s-30s	281	5.23%
30s-1m	76	1.42%
1m-10m	119	2.22%
10m-30m	40	0.75%
30m-1h	10	0.19%
1h-8h	0	0.00%
> 8h	0	0.00%

Sessions per database

Key values

acaweb_fx Main Database
5,368 sessions Total

Chart
Table

Database	User	Count	Total Duration	Average Duration
acaweb_fx	5,368	1d6h30m54s	20s464ms

Sessions per user

Key values

postgres Main User
5,368 sessions Total

Chart
Table

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

Sessions per host

Key values

192.168.1.23 Main Host
5,368 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	111	2s960ms	26ms
172.10.1.90	23	1m27s	3s793ms
192.168.0.216	176	19m25s	6s619ms
192.168.0.239	227	2h4m34s	32s925ms
192.168.0.42	270	1h58m58s	26s439ms
192.168.1.135	13	2h39m27s	12m15s
192.168.1.201	842	2h8m3s	9s125ms
192.168.1.23	1,631	2h1m25s	4s467ms
192.168.1.239	166	1s29ms	6ms
192.168.1.25	6	42ms	7ms
192.168.1.250	194	13h46m14s	4m15s
192.168.1.44	139	4s46ms	29ms
192.168.1.45	21	1h24m9s	4m
192.168.2.126	18	5s273ms	292ms
192.168.2.205	28	2h4m	4m25s
192.168.2.82	40	1h44m38s	2m36s
192.168.3.199	93	5m50s	3s765ms
192.168.4.142	1,002	7m34s	453ms
192.168.4.98	104	30s213ms	290ms
[local]	264	4m19s	983ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
5,368 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	3,198	1d2h2m54s	29s322ms
[unknown]	1,656	4h23m32s	9s548ms
dreamfactory	139	4s46ms	29ms
psql	375	4m22s	700ms

Checkpoints Buffers

Key values

1,485 buffers Checkpoint Peak
2022-10-02 11:38:56 Date
209.963 seconds Highest write time
0.023 seconds Sync time

Checkpoints Wal files

Key values

6 files Wal files usage Peak
2022-10-02 11:38:56 Date

Checkpoints distance

Key values

178.50 Mo Distance Peak
2022-10-02 11:38:56 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Oct 02	11	8,222	1,512.693s	0.058s	1,512.954s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Oct 02	11	0	0	30	1,488	0.004s	0s

Day	Hour	Count	Avg time (sec)
Oct 02	11	0	0s

Day	Hour	Mean distance	Mean estimate
Oct 02	11	40,482.08 kB	79,037.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

27.71 MiB Temp Files size Peak
2022-10-02 11:32:49 Date

Number of temporary files

Key values

3 per second Temp Files Peak
2022-10-02 11:32:49 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Oct 02	11	190	1.47 GiB	7.95 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	129	903.51 MiB	3.23 MiB	10.93 MiB	7.00 MiB	with rar_max as ( ; WITH rar_max as ( ; Date: 2022-10-02 11:45:38 Duration: 0ms Database: acaweb_fx User: postgres Remote: 192.168.1.250 Application: PostgreSQL JDBC Driver
2	56	559.05 MiB	7.59 MiB	12.24 MiB	9.98 MiB	select distinct patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzos, dftt.timezone as tz, longname, case when rar.age is not null then rar.age when a.resultuid <= ( select resultuid from relevance_autochartist_results order by resultuid desc limit ?) then ? else ? end as age, case when rar.relevant is not null then rar.relevant when a.resultuid <= ( select resultuid from relevance_autochartist_results order by resultuid desc limit ?) then ? else ? end as relevant from symbols s inner join brokersymbollist b on s.symbolid = b.symbolid inner join downloadersymbolsettings dss on dss.symbolid = s.symbolid inner join datafeedstimetable dftt on dftt.classname = dss.classname inner join autochartist_results a on a.symbolid = s.symbolid inner join patterns p on a.pattern = p.patternname left outer join relevance_autochartist_results rar on rar.resultuid = a.resultuid where b.brokerid = ? and (((s.symbol ilike ? and timegranularity = ?); /server.CPResultList/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 700 AND (((s.symbol ilike '%gbpcad%' AND timegranularity = 240); Date: 2022-10-02 11:44:50 Duration: 0ms Database: acaweb_fx User: postgres Remote: 192.168.0.42 Application: PostgreSQL JDBC Driver
3	1	7.34 MiB	7.34 MiB	7.34 MiB	7.34 MiB	select distinct patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzos, dftt.timezone as tz, longname from symbols s inner join brokersymbollist b on s.symbolid = b.symbolid inner join symbolgroup sg on s.symbolid = sg.symbolid inner join downloadersymbolsettings dss on dss.symbolid = s.symbolid inner join datafeedstimetable dftt on dftt.classname = dss.classname inner join autochartist_results a on a.symbolid = s.symbolid inner join patterns p on a.pattern = p.patternname where b.brokerid = ? and sg.groupid = ? and breakout = ? and patternlengthbars >= ? and patternquality >= ?.? and initialtrend >= ?.? and symmetry >= ?.? and noise <= ?.? and volumeincrease >= ?.? and temporarypattern = ? and patternid & ? > ? and s.nonliquid = ? and s.deleted = ? and dss.enabled = ? and a.resultuid > ? and s.nonliquid = ? and dftt.dayofweek = ? order by patternendtime desc, patternquality desc limit ?; /server.CPResultList/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN symbolgroup sg ON s.symbolid = sg.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname WHERE b.brokerid = 667 AND sg.groupid = 500996399199151208 AND breakout = - 1 AND patternlengthbars >= 20 AND patternquality >= 0.3 AND initialtrend >= 0.0 AND symmetry >= 0.0 AND noise <= 1.0 AND volumeincrease >= 0.0 AND TemporaryPattern = 0 AND PatternID & 65535 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND a.resultuid > 0 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY PatternEndTime DESC, PatternQuality DESC LIMIT 50; Date: 2022-10-02 11:36:06 Duration: 319ms Database: acaweb_fx User: postgres Remote: 192.168.0.239 Application: PostgreSQL JDBC Driver /server.CPResultList/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN symbolgroup sg ON s.symbolid = sg.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname WHERE b.brokerid = 667 AND sg.groupid = 500996399201641208 AND breakout = - 1 AND patternlengthbars >= 20 AND patternquality >= 0.3 AND initialtrend >= 0.0 AND symmetry >= 0.0 AND noise <= 1.0 AND volumeincrease >= 0.0 AND TemporaryPattern = 0 AND PatternID & 65535 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND a.resultuid > 0 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY PatternEndTime DESC, PatternQuality DESC LIMIT 50; Date: 2022-10-02 11:36:06 Duration: 99ms Database: acaweb_fx User: postgres Remote: 192.168.0.239 Application: PostgreSQL JDBC Driver /server.CPResultList/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN symbolgroup sg ON s.symbolid = sg.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname WHERE b.brokerid = 667 AND sg.groupid = 500996399199757208 AND breakout = - 1 AND patternlengthbars >= 20 AND patternquality >= 0.3 AND initialtrend >= 0.0 AND symmetry >= 0.0 AND noise <= 1.0 AND volumeincrease >= 0.0 AND TemporaryPattern = 0 AND PatternID & 65535 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND a.resultuid > 0 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY PatternEndTime DESC, PatternQuality DESC LIMIT 50; Date: 2022-10-02 11:36:06 Duration: 63ms Database: acaweb_fx User: postgres Remote: 192.168.0.239 Application: PostgreSQL JDBC Driver

Queries generating the largest temporary files


[ Date: 2022-10-02 11:02:12 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
[ Date: 2022-10-02 11:06:12 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
[ Date: 2022-10-02 11:10:13 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
[ Date: 2022-10-02 11:14:13 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
[ Date: 2022-10-02 11:18:14 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
[ Date: 2022-10-02 11:22:14 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
[ Date: 2022-10-02 11:26:14 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
[ Date: 2022-10-02 11:30:14 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
[ Date: 2022-10-02 11:34:15 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
[ Date: 2022-10-02 11:38:15 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
[ Date: 2022-10-02 11:42:16 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
[ Date: 2022-10-02 11:46:16 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
[ Date: 2022-10-02 11:50:16 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
[ Date: 2022-10-02 11:54:17 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
[ Date: 2022-10-02 11:58:17 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
[ Date: 2022-10-02 11:01:26 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver ]
[ Date: 2022-10-02 11:06:56 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver ]
[ Date: 2022-10-02 11:11:29 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver ]
[ Date: 2022-10-02 11:16:29 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver ]
[ Date: 2022-10-02 11:21:54 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver ]

Rank	Size	Query
1	12.24 MiB	/server.CPResultList/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 700 AND (((s.symbol ilike '%usdjpy%' AND timegranularity = 240); [ Date: 2022-10-02 11:02:12 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
2	12.24 MiB	/server.CPResultList/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 700 AND (((s.symbol ilike '%usdjpy%' AND timegranularity = 240); [ Date: 2022-10-02 11:06:12 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
3	12.24 MiB	/server.CPResultList/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 700 AND (((s.symbol ilike '%usdjpy%' AND timegranularity = 240); [ Date: 2022-10-02 11:10:13 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
4	12.24 MiB	/server.CPResultList/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 700 AND (((s.symbol ilike '%usdjpy%' AND timegranularity = 240); [ Date: 2022-10-02 11:14:13 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
5	12.24 MiB	/server.CPResultList/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 700 AND (((s.symbol ilike '%usdjpy%' AND timegranularity = 240); [ Date: 2022-10-02 11:18:14 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
6	12.24 MiB	/server.CPResultList/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 700 AND (((s.symbol ilike '%usdjpy%' AND timegranularity = 240); [ Date: 2022-10-02 11:22:14 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
7	12.24 MiB	/server.CPResultList/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 700 AND (((s.symbol ilike '%usdjpy%' AND timegranularity = 240); [ Date: 2022-10-02 11:26:14 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
8	12.24 MiB	/server.CPResultList/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 700 AND (((s.symbol ilike '%usdjpy%' AND timegranularity = 240); [ Date: 2022-10-02 11:30:14 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
9	12.24 MiB	/server.CPResultList/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 700 AND (((s.symbol ilike '%usdjpy%' AND timegranularity = 240); [ Date: 2022-10-02 11:34:15 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
10	12.24 MiB	/server.CPResultList/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 700 AND (((s.symbol ilike '%usdjpy%' AND timegranularity = 240); [ Date: 2022-10-02 11:38:15 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
11	12.24 MiB	/server.CPResultList/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 700 AND (((s.symbol ilike '%usdjpy%' AND timegranularity = 240); [ Date: 2022-10-02 11:42:16 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
12	12.24 MiB	/server.CPResultList/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 700 AND (((s.symbol ilike '%usdjpy%' AND timegranularity = 240); [ Date: 2022-10-02 11:46:16 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
13	12.24 MiB	/server.CPResultList/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 700 AND (((s.symbol ilike '%usdjpy%' AND timegranularity = 240); [ Date: 2022-10-02 11:50:16 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
14	12.24 MiB	/server.CPResultList/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 700 AND (((s.symbol ilike '%usdjpy%' AND timegranularity = 240); [ Date: 2022-10-02 11:54:17 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
15	12.24 MiB	/server.CPResultList/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 700 AND (((s.symbol ilike '%usdjpy%' AND timegranularity = 240); [ Date: 2022-10-02 11:58:17 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.42 - Application: PostgreSQL JDBC Driver ]
16	10.93 MiB	WITH rar_max as ( ; [ Date: 2022-10-02 11:01:26 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver ]
17	10.93 MiB	WITH rar_max as ( ; [ Date: 2022-10-02 11:06:56 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver ]
18	10.93 MiB	WITH rar_max as ( ; [ Date: 2022-10-02 11:11:29 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver ]
19	10.93 MiB	WITH rar_max as ( ; [ Date: 2022-10-02 11:16:29 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver ]
20	10.93 MiB	WITH rar_max as ( ; [ Date: 2022-10-02 11:21:54 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - 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.solr_relevance_old (16) Main table analyzed (database acaweb_fx)
38 analyzes Total

Chart
Table

Table	Number of analyzes
acaweb_fx.public.solr_relevance_old	16
acaweb_fx.pg_catalog.pg_attribute	5
acaweb_fx.public.datafeeds_latestrun	4
acaweb_fx.pg_catalog.pg_index	2
acaweb_fx.pg_catalog.pg_type	2
acaweb_fx.public.latest_t15_candle_view	2
acaweb_fx.pg_catalog.pg_class	2
acaweb_fx.public.latest_candle_datetime_per_receng	2
acaweb_fx.pg_catalog.pg_depend	1
acaweb_fx.public.relevance_autochartist_results	1
acaweb_fx.public.relevance_fibonacci_results	1
Total	38

Vacuums per table

Key values

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

Chart
Table

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
acaweb_fx.public.solr_relevance_old	16	16	39,456	0	343	0	0	28,706	3,351	17,113,353
acaweb_fx.public.datafeeds_latestrun	3	0	330	0	23	0	0	98	21	53,360
acaweb_fx.pg_toast.pg_toast_2619	1	1	124	0	32	0	0	101	30	131,485
acaweb_fx.pg_catalog.pg_type	1	1	101	0	20	0	0	56	19	122,067
acaweb_fx.pg_catalog.pg_attribute	1	1	495	0	200	0	53	382	145	898,275
acaweb_fx.pg_catalog.pg_statistic	1	1	458	0	132	0	0	307	89	497,390
acaweb_fx.public.solr_imports	1	1	62	0	3	0	0	6	2	14,229
acaweb_fx.public.latest_t15_candle_view	1	1	91	0	4	0	0	5	1	5,819
acaweb_fx.pg_catalog.pg_class	1	1	204	0	19	0	0	74	14	87,114
Total	26	23	41,321	722	776	0	53	29,735	3,672	18,923,092

Tuples removed per table

Key values

public.solr_relevance_old (167847) Main table with removed tuples on database acaweb_fx
169927 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
acaweb_fx.public.solr_relevance_old	16	16	167,847	306,842	0	0	10,484
acaweb_fx.pg_catalog.pg_attribute	1	1	1,318	9,150	0	0	230
acaweb_fx.pg_catalog.pg_statistic	1	1	277	1,800	0	0	249
acaweb_fx.public.datafeeds_latestrun	3	0	130	90	12	0	66
acaweb_fx.pg_catalog.pg_class	1	1	93	1,541	0	0	58
acaweb_fx.pg_catalog.pg_type	1	1	85	1,268	0	0	36
acaweb_fx.pg_toast.pg_toast_2619	1	1	74	178	2	3	47
acaweb_fx.public.solr_imports	1	1	52	1	0	0	1
acaweb_fx.public.latest_t15_candle_view	1	1	51	43	17	0	1
Total	26	23	169,927	320,913	31	3	11,172

Pages removed per table

Key values

pg_toast.pg_toast_2619 (3) Main table with removed pages on database acaweb_fx
3 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
acaweb_fx.pg_toast.pg_toast_2619	1	1	74	3
acaweb_fx.pg_catalog.pg_type	1	1	85	0
acaweb_fx.public.datafeeds_latestrun	3	0	130	0
acaweb_fx.pg_catalog.pg_attribute	1	1	1318	0
acaweb_fx.pg_catalog.pg_statistic	1	1	277	0
acaweb_fx.public.solr_imports	1	1	52	0
acaweb_fx.public.latest_t15_candle_view	1	1	51	0
acaweb_fx.pg_catalog.pg_class	1	1	93	0
acaweb_fx.public.solr_relevance_old	16	16	167847	0
Total	26	23	169,927	3

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Oct 02	11	26	38

↑ 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

74,827 Total read queries
22,606 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	74,827	71.05%
INSERT	18,911	17.96%
UPDATE	430	0.41%
DELETE	16	0.02%
COPY FROM	96	0.09%
COPY TO	26	0.02%
CTE	2,903	2.76%
DDL	16	0.02%
TCL	208	0.20%
CURSOR	0	0.00%
OTHERS	7,877	7.48%

Queries by database

Key values

acaweb_fx Main database
105,310 Requests
53m28s (acaweb_fx)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
acaweb_fx	Total	105,310	53m28s
	copy from	96	15s507ms
	copy to	26	2s340ms
	cte	2,903	39m18s
	ddl	16	365ms
	delete	16	23ms
	insert	18,911	27s311ms
	others	7,877	29s54ms
	select	74,827	12m25s
	tcl	208	102ms
	update	430	29s994ms

Queries by user

Key values

postgres Main user
105,310 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	105,310	53m28s
	copy from	96	15s507ms
	copy to	26	2s340ms
	cte	2,903	39m18s
	ddl	16	365ms
	delete	16	23ms
	insert	18,911	27s311ms
	others	7,877	29s54ms
	select	74,827	12m25s
	tcl	208	102ms
	update	430	29s994ms

Duration by user

Key values

53m28s (postgres) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	105,310	53m28s
	copy from	96	15s507ms
	copy to	26	2s340ms
	cte	2,903	39m18s
	ddl	16	365ms
	delete	16	23ms
	insert	18,911	27s311ms
	others	7,877	29s54ms
	select	74,827	12m25s
	tcl	208	102ms
	update	430	29s994ms

Queries by host

Key values

192.168.1.23 Main host
26,188 Requests
27m31s (192.168.1.250)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	4,756	15s62ms
	copy to	26	2s340ms
	cte	20	241ms
	insert	1,430	2s531ms
	select	3,162	9s668ms
	update	118	280ms
172.10.1.90	Total	92	129ms
	others	46	5ms
	select	42	55ms
	update	4	68ms
182.165.1.42	Total	26	125ms
	select	26	125ms
192.168.0.216	Total	704	538ms
	others	352	31ms
	select	344	408ms
	update	8	99ms
192.168.0.23	Total	9,945	59s258ms
	select	9,945	59s258ms
192.168.0.236	Total	22	127ms
	cte	2	1ms
	select	20	125ms
192.168.0.239	Total	5,945	35s166ms
	others	454	4ms
	select	5,491	35s161ms
192.168.0.42	Total	9,428	1m42s
	insert	8	53ms
	others	540	5ms
	select	8,880	1m42s
192.168.1.135	Total	1,478	11m53s
	cte	623	11m51s
	others	26	0ms
	select	829	1s703ms
192.168.1.201	Total	9,936	1m
	cte	6	33ms
	insert	5	14ms
	others	1,684	17ms
	select	8,234	1m
	update	7	0ms
192.168.1.210	Total	24	9ms
	select	24	9ms
192.168.1.23	Total	26,188	3m16s
	cte	7	103ms
	others	3,262	33ms
	select	22,902	3m16s
	update	17	0ms
192.168.1.239	Total	664	386ms
	others	332	26ms
	select	332	359ms
192.168.1.25	Total	6	7ms
	select	6	7ms
192.168.1.250	Total	10,012	27m31s
	cte	2,137	26m44s
	others	388	3ms
	select	7,487	46s795ms
192.168.1.44	Total	457	129ms
	insert	30	113ms
	others	417	3ms
	select	10	11ms
192.168.1.45	Total	2,537	33s63ms
	cte	9	81ms
	others	42	0ms
	select	2,486	32s981ms
192.168.1.97	Total	22	464ms
	cte	3	2ms
	select	19	461ms
192.168.2.126	Total	30	23ms
	others	12	0ms
	select	18	23ms
192.168.2.205	Total	104	3s473ms
	insert	4	3s320ms
	others	48	4ms
	select	48	78ms
	update	4	68ms
192.168.2.82	Total	4,534	37s968ms
	insert	3,995	13s122ms
	others	80	7ms
	select	359	24s521ms
	update	100	316ms
192.168.3.199	Total	372	357ms
	others	186	16ms
	select	174	196ms
	update	12	144ms
192.168.4.142	Total	17,388	9s829ms
	insert	13,439	8s154ms
	select	3,949	1s674ms
192.168.4.98	Total	312	28s729ms
	others	4	28s356ms
	tcl	208	102ms
	update	100	269ms
[local]	Total	328	4m19s
	copy from	96	15s507ms
	cte	96	41s641ms
	ddl	16	365ms
	delete	16	23ms
	others	4	534ms
	select	40	2m52s
	update	60	28s746ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
72,295 Requests
47m32s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	72,295	47m32s
	cte	2,782	38m36s
	insert	13	68ms
	others	3,198	37ms
	select	66,278	8m55s
	update	24	1ms
[unknown]	Total	32,397	1m34s
	cte	5	4ms
	insert	18,868	27s129ms
	others	4,536	28s481ms
	select	8,447	37s570ms
	tcl	208	102ms
	update	333	1s219ms
dreamfactory	Total	179	126ms
	insert	30	113ms
	others	139	1ms
	select	10	11ms
psql	Total	439	4m22s
	copy from	96	15s507ms
	copy to	26	2s340ms
	cte	116	41s883ms
	ddl	16	365ms
	delete	16	23ms
	others	4	534ms
	select	92	2m52s
	update	73	28s774ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2022-10-02 11:25:28 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

73,077 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	73,077	69.39%
1-5ms	17,003	16.15%
5-10ms	5,446	5.17%
10-25ms	4,333	4.11%
25-50ms	2,053	1.95%
50-100ms	1,222	1.16%
100-500ms	1,487	1.41%
500-1000ms	200	0.19%
1000-10000ms	416	0.40%
> 10000ms	73	0.07%

Slowest individual queries


[ Date: 2022-10-02 11:47:34 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2022-10-02 11:37:01 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2022-10-02 11:21:54 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2022-10-02 11:02:31 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2022-10-02 11:06:56 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2022-10-02 11:32:31 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2022-10-02 11:17:30 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2022-10-02 11:51:54 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2022-10-02 11:26:50 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2022-10-02 11:07:18 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2022-10-02 11:52:15 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2022-10-02 11:37:20 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2022-10-02 11:16:29 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2022-10-02 11:22:12 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2022-10-02 11:41:33 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2022-10-02 11:41:50 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2022-10-02 11:46:32 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2022-10-02 11:01:26 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2022-10-02 11:18:04 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.250 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2022-10-02 11:02:38 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.250 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Rank	Duration	Query
1	32s250ms	select updateageforrelevantresults (); [ Date: 2022-10-02 11:47:34 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	31s276ms	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 ), results AS ( SELECT DISTINCT ON (s.symbolid) 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, 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 = '689' 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 currencypips cp ON s.symbol = cp.symbol LEFT JOIN LATERAL calc_cp_signal (ar.resultuid) newLevels on true WHERE ar.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND (ar.simulation = 0 OR ar.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR s.symbol in ('')) 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 ('0' = 0 OR ar.patternlengthbars <= '0') and newLevels.filtered = false ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT from results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY identified DESC, length DESC; [ Date: 2022-10-02 11:37:01 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3	29s943ms	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 ), results AS ( SELECT DISTINCT ON (s.symbolid) 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, 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 = '689' 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 currencypips cp ON s.symbol = cp.symbol LEFT JOIN LATERAL calc_cp_signal (ar.resultuid) newLevels on true WHERE ar.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND (ar.simulation = 0 OR ar.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR s.symbol in ('')) 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 ('0' = 0 OR ar.patternlengthbars <= '0') and newLevels.filtered = false ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT from results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY identified DESC, length DESC; [ Date: 2022-10-02 11:21:54 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4	29s312ms	select updateageforrelevantresults (); [ Date: 2022-10-02 11:02:31 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
5	28s596ms	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 ), results AS ( SELECT DISTINCT ON (s.symbolid) 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, 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 = '689' 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 currencypips cp ON s.symbol = cp.symbol LEFT JOIN LATERAL calc_cp_signal (ar.resultuid) newLevels on true WHERE ar.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND (ar.simulation = 0 OR ar.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR s.symbol in ('')) 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 ('0' = 0 OR ar.patternlengthbars <= '0') and newLevels.filtered = false ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT from results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY identified DESC, length DESC; [ Date: 2022-10-02 11:06:56 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6	28s545ms	select updateageforrelevantresults (); [ Date: 2022-10-02 11:32:31 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
7	27s751ms	select updateageforrelevantresults (); [ Date: 2022-10-02 11:17:30 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
8	27s130ms	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 ), results AS ( SELECT DISTINCT ON (s.symbolid) 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, 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 = '689' 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 currencypips cp ON s.symbol = cp.symbol LEFT JOIN LATERAL calc_cp_signal (ar.resultuid) newLevels on true WHERE ar.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND (ar.simulation = 0 OR ar.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR s.symbol in ('')) 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 ('0' = 0 OR ar.patternlengthbars <= '0') and newLevels.filtered = false ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT from results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY identified DESC, length DESC; [ Date: 2022-10-02 11:51:54 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9	23s614ms	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 ), results AS ( SELECT DISTINCT ON (s.symbolid) kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, 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 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 relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 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 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') ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT from results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY identified DESC, length DESC; [ Date: 2022-10-02 11:26:50 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10	21s418ms	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 ), results AS ( SELECT DISTINCT ON (s.symbolid) kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, 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 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 relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 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 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') ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT from results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY identified DESC, length DESC; [ Date: 2022-10-02 11:07:18 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11	20s511ms	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 ), results AS ( SELECT DISTINCT ON (s.symbolid) kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, 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 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 relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 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 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') ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT from results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY identified DESC, length DESC; [ Date: 2022-10-02 11:52:15 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12	18s883ms	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 ), results AS ( SELECT DISTINCT ON (s.symbolid) kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, 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 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 relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 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 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') ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT from results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY identified DESC, length DESC; [ Date: 2022-10-02 11:37:20 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13	18s447ms	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 ), results AS ( SELECT DISTINCT ON (s.symbolid) 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, 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 = '689' 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 currencypips cp ON s.symbol = cp.symbol LEFT JOIN LATERAL calc_cp_signal (ar.resultuid) newLevels on true WHERE ar.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND (ar.simulation = 0 OR ar.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR s.symbol in ('')) 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 ('0' = 0 OR ar.patternlengthbars <= '0') and newLevels.filtered = false ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT from results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY identified DESC, length DESC; [ Date: 2022-10-02 11:16:29 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14	18s195ms	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 ), results AS ( SELECT DISTINCT ON (s.symbolid) kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, 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 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 relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 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 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') ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT from results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY identified DESC, length DESC; [ Date: 2022-10-02 11:22:12 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15	17s473ms	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 ), results AS ( SELECT DISTINCT ON (s.symbolid) 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, 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 = '689' 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 currencypips cp ON s.symbol = cp.symbol LEFT JOIN LATERAL calc_cp_signal (ar.resultuid) newLevels on true WHERE ar.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND (ar.simulation = 0 OR ar.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR s.symbol in ('')) 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 ('0' = 0 OR ar.patternlengthbars <= '0') and newLevels.filtered = false ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT from results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY identified DESC, length DESC; [ Date: 2022-10-02 11:41:33 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16	17s44ms	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 ), results AS ( SELECT DISTINCT ON (s.symbolid) kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, 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 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 relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 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 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') ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT from results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY identified DESC, length DESC; [ Date: 2022-10-02 11:41:50 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17	16s786ms	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 ), results AS ( SELECT DISTINCT ON (s.symbolid) 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, 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 = '689' 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 currencypips cp ON s.symbol = cp.symbol LEFT JOIN LATERAL calc_cp_signal (ar.resultuid) newLevels on true WHERE ar.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND (ar.simulation = 0 OR ar.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR s.symbol in ('')) 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 ('0' = 0 OR ar.patternlengthbars <= '0') and newLevels.filtered = false ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT from results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY identified DESC, length DESC; [ Date: 2022-10-02 11:46:32 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18	16s594ms	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 ), results AS ( SELECT DISTINCT ON (s.symbolid) 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, 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 = '689' 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 currencypips cp ON s.symbol = cp.symbol LEFT JOIN LATERAL calc_cp_signal (ar.resultuid) newLevels on true WHERE ar.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND (ar.simulation = 0 OR ar.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR s.symbol in ('')) 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 ('0' = 0 OR ar.patternlengthbars <= '0') and newLevels.filtered = false ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT from results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY identified DESC, length DESC; [ Date: 2022-10-02 11:01:26 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.135 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19	16s51ms	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 = '758' 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 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 (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 ('208' = 0 OR coalesce(bim.code, s.symbol) in ('BCHEUR', 'BCHUSD', 'BTCEUR', 'BTCUSD', 'ETHEUR', 'ETHUSD', 'LTCEUR', 'LTCUSD', 'USDRON', 'XRPUSD', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURCZK', 'EURGBP', 'EURHUF', 'EURJPY', 'EURMXN', 'EURNOK', 'EURNZD', 'EURPLN', 'EURSEK', 'EURTRY', 'EURUSD', 'EURZAR', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GBPZAR', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDCZK', 'USDHUF', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDTRY', 'USDZAR', 'AA', 'AAPL', 'AC.pa', 'ACA.pa', 'ACB', 'ACKB.br', 'AD.as', 'ADBE', 'ADS.de', 'AGS.br', 'AI.pa', 'AIG', 'AIR.pa', 'ALV.de', 'AMZN', 'AXP', 'BA', 'BABA', 'BAC', 'BAS.de', 'BAYN.de', 'BIDU', 'BMW.de', 'BN.pa', 'BNP.pa', 'BRKB', 'C', 'CA.pa', 'CAP.pa', 'CAT', 'CBK.de', 'CGC', 'CRON', 'CS.pa', 'CSCO', 'CVX', 'DAI.de', 'DBK.de', 'DIS', 'DLTR', 'DPW.de', 'DTE.de', 'EBAY', 'EDF.pa', 'EL.pa', 'EN.pa', 'EOAN.de', 'FEYE', 'FP.pa', 'FSLR', 'GE', 'GILD', 'GLE.pa', 'GM', 'GOOG', 'GS', 'HAS', 'HEIA.as', 'HEN3.de', 'HOG', 'HPQ', 'HSY', 'IBE.mc', 'IBM', 'IFX.de', 'INGA.as', 'INTC', 'JNJ', 'JPM', 'KO', 'LHA.de', 'LLOY.l', 'LMT', 'LR.pa', 'LVS', 'LYFT', 'M', 'MC.pa', 'ML.pa', 'MMM', 'MRK.de', 'MS', 'MSFT', 'NFLX', 'NKE', 'NOV', 'NOVN.vx', 'NVDA', 'ORA.pa', 'PANW', 'PFE', 'PG', 'PM', 'PUB.pa', 'PYPL', 'QCOM', 'RACE', 'REGN', 'RI.pa', 'RNO.pa', 'RWE.de', 'SAF.pa', 'SAN.pa', 'SAP.de', 'SBUX', 'SGO.pa', 'SIE.de', 'SMSN.l', 'SNAP', 'SRE', 'SU.pa', 'T', 'TEF.mc', 'TEVA', 'TGT', 'TKA.de', 'TWTR', 'UBER', 'UBSG.vx', 'UNA.as', 'URW.as', 'V', 'VIE.pa', 'VIV.pa', 'VK.pa', 'VOW3.de', 'VZ', 'WMT', 'XOM', 'XAGUSD', 'XAUUSD', 'BRENT', 'COCOA', 'COFFEE', 'CORN', 'COTTON', 'NGAS', 'SUGAR', 'USDX', 'WHEAT', 'WTI', 'FRENCH40', 'GERMAN30', 'JPN225', 'NETHERLAND25', 'SPANISH35', 'SWISS20', 'UK100', 'US30', 'US500', 'USTECH100', 'USVIX')) 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 ('400' = 0 OR ar.patternlengthbars <= '400') and newLevels.filtered = false ), 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: 2022-10-02 11:18:04 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.250 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20	15s647ms	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 = '758' 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 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 (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 ('208' = 0 OR coalesce(bim.code, s.symbol) in ('BCHEUR', 'BCHUSD', 'BTCEUR', 'BTCUSD', 'ETHEUR', 'ETHUSD', 'LTCEUR', 'LTCUSD', 'USDRON', 'XRPUSD', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURCZK', 'EURGBP', 'EURHUF', 'EURJPY', 'EURMXN', 'EURNOK', 'EURNZD', 'EURPLN', 'EURSEK', 'EURTRY', 'EURUSD', 'EURZAR', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GBPZAR', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDCZK', 'USDHUF', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDTRY', 'USDZAR', 'AA', 'AAPL', 'AC.pa', 'ACA.pa', 'ACB', 'ACKB.br', 'AD.as', 'ADBE', 'ADS.de', 'AGS.br', 'AI.pa', 'AIG', 'AIR.pa', 'ALV.de', 'AMZN', 'AXP', 'BA', 'BABA', 'BAC', 'BAS.de', 'BAYN.de', 'BIDU', 'BMW.de', 'BN.pa', 'BNP.pa', 'BRKB', 'C', 'CA.pa', 'CAP.pa', 'CAT', 'CBK.de', 'CGC', 'CRON', 'CS.pa', 'CSCO', 'CVX', 'DAI.de', 'DBK.de', 'DIS', 'DLTR', 'DPW.de', 'DTE.de', 'EBAY', 'EDF.pa', 'EL.pa', 'EN.pa', 'EOAN.de', 'FEYE', 'FP.pa', 'FSLR', 'GE', 'GILD', 'GLE.pa', 'GM', 'GOOG', 'GS', 'HAS', 'HEIA.as', 'HEN3.de', 'HOG', 'HPQ', 'HSY', 'IBE.mc', 'IBM', 'IFX.de', 'INGA.as', 'INTC', 'JNJ', 'JPM', 'KO', 'LHA.de', 'LLOY.l', 'LMT', 'LR.pa', 'LVS', 'LYFT', 'M', 'MC.pa', 'ML.pa', 'MMM', 'MRK.de', 'MS', 'MSFT', 'NFLX', 'NKE', 'NOV', 'NOVN.vx', 'NVDA', 'ORA.pa', 'PANW', 'PFE', 'PG', 'PM', 'PUB.pa', 'PYPL', 'QCOM', 'RACE', 'REGN', 'RI.pa', 'RNO.pa', 'RWE.de', 'SAF.pa', 'SAN.pa', 'SAP.de', 'SBUX', 'SGO.pa', 'SIE.de', 'SMSN.l', 'SNAP', 'SRE', 'SU.pa', 'T', 'TEF.mc', 'TEVA', 'TGT', 'TKA.de', 'TWTR', 'UBER', 'UBSG.vx', 'UNA.as', 'URW.as', 'V', 'VIE.pa', 'VIV.pa', 'VK.pa', 'VOW3.de', 'VZ', 'WMT', 'XOM', 'XAGUSD', 'XAUUSD', 'BRENT', 'COCOA', 'COFFEE', 'CORN', 'COTTON', 'NGAS', 'SUGAR', 'USDX', 'WHEAT', 'WTI', 'FRENCH40', 'GERMAN30', 'JPN225', 'NETHERLAND25', 'SPANISH35', 'SWISS20', 'UK100', 'US30', 'US500', 'USTECH100', 'USVIX')) 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 ('400' = 0 OR ar.patternlengthbars <= '400') and newLevels.filtered = false ), 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: 2022-10-02 11:02:38 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.250 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

Time consuming queries


[ User: postgres - Total duration: 12m14s - Times executed: 105 ]
[ User: postgres - Total duration: 9m5s - Times executed: 105 ]
[ User: postgres - Total duration: 7m15s - Times executed: 156 ]
[ User: postgres - Total duration: 4m18s - Times executed: 105 ]
[ User: postgres - Total duration: 4m16s - Times executed: 156 ]
[ User: postgres - Total duration: 3m50s - Times executed: 5017 ]
[ User: postgres - Total duration: 1m57s - Times executed: 4 ]
[ User: postgres - Total duration: 52s822ms - Times executed: 115 ]
[ User: postgres - Total duration: 42s366ms - Times executed: 1394 ]
[ User: postgres - Total duration: 41s858ms - Times executed: 96 ]
[ User: postgres - Total duration: 35s878ms - Times executed: 16 ]
[ User: postgres - Total duration: 30s323ms - Times executed: 1050 ]
[ User: postgres - Total duration: 28s356ms - Times executed: 4 ]
[ User: postgres - Total duration: 27s450ms - Times executed: 16 ]
[ User: postgres - Total duration: 27s429ms - Times executed: 4 ]
[ User: postgres - Total duration: 27s140ms - Times executed: 31 ]
[ User: postgres - Total duration: 24s362ms - Times executed: 779 ]
[ User: postgres - Total duration: 24s97ms - Times executed: 194 ]
[ User: postgres - Total duration: 23s771ms - Times executed: 180 ]
[ User: postgres - Total duration: 18s109ms - Times executed: 156 ]

Most frequent queries (N)


[ User: postgres - Total duration: 176ms - Times executed: 34552 ]
[ User: postgres - Total duration: 6s836ms - Times executed: 9282 ]
[ User: postgres - Total duration: 3m50s - Times executed: 5017 ]
[ User: postgres - Total duration: 1s366ms - Times executed: 3829 ]
[ User: postgres - Total duration: 29ms - Times executed: 3210 ]
[ User: postgres - Total duration: 37ms - Times executed: 3198 ]
[ User: postgres - Total duration: 549ms - Times executed: 2837 ]
[ User: postgres - Total duration: 14s103ms - Times executed: 2760 ]
[ User: postgres - Total duration: 7s563ms - Times executed: 2746 ]
[ User: postgres - Total duration: 3s591ms - Times executed: 2746 ]
[ User: postgres - Total duration: 752ms - Times executed: 2030 ]
[ User: postgres - Total duration: 6s466ms - Times executed: 1953 ]
[ User: postgres - Total duration: 8s760ms - Times executed: 1878 ]
[ User: postgres - Total duration: 12s21ms - Times executed: 1694 ]
[ User: postgres - Total duration: 426ms - Times executed: 1495 ]
[ User: postgres - Total duration: 42s366ms - Times executed: 1394 ]
[ User: postgres - Total duration: 1s572ms - Times executed: 1160 ]
[ User: postgres - Total duration: 1s284ms - Times executed: 1072 ]
[ User: postgres - Total duration: 30s323ms - Times executed: 1050 ]
[ User: postgres - Total duration: 2s789ms - Times executed: 936 ]

Normalized slowest queries (N)


[ User: postgres - Total duration: 1m57s - Times executed: 4 ]
[ User: postgres - Total duration: 28s356ms - Times executed: 4 ]
[ User: postgres - Total duration: 12m14s - Times executed: 105 ]
[ User: postgres - Total duration: 27s429ms - Times executed: 4 ]
[ User: postgres - Total duration: 9m5s - Times executed: 105 ]
[ User: postgres - Total duration: 7m15s - Times executed: 156 ]
[ User: postgres - Total duration: 4m18s - Times executed: 105 ]
[ User: postgres - Total duration: 35s878ms - Times executed: 16 ]
[ User: postgres - Total duration: 27s450ms - Times executed: 16 ]
[ User: postgres - Total duration: 4m16s - Times executed: 156 ]
[ User: postgres - Total duration: 27s140ms - Times executed: 31 ]
[ User: postgres - Total duration: 52s822ms - Times executed: 115 ]
[ User: postgres - Total duration: 41s858ms - Times executed: 96 ]
[ User: postgres - Total duration: 23s771ms - Times executed: 180 ]
[ User: postgres - Total duration: 24s97ms - Times executed: 194 ]
[ User: postgres - Total duration: 18s109ms - Times executed: 156 ]
[ User: postgres - Total duration: 3m50s - Times executed: 5017 ]
[ User: postgres - Total duration: 24s362ms - Times executed: 779 ]
[ User: postgres - Total duration: 42s366ms - Times executed: 1394 ]
[ User: postgres - Total duration: 30s323ms - Times executed: 1050 ]

Time consuming prepare


[ User: postgres - Total duration: 5s851ms - Times executed: 4288 ]
[ User: postgres - Total duration: 30m51s - Times executed: 1091 ]
[ User: postgres - Total duration: 3s92ms - Times executed: 1314 ]
[ User: postgres - Total duration: 29ms - Times executed: 3210 ]
[ User: postgres - Total duration: 29ms - Times executed: 5023 ]
[ User: postgres - Total duration: 662ms - Times executed: 1854 ]
[ User: postgres - Total duration: 30s14ms - Times executed: 199 ]
[ User: postgres - Total duration: 369ms - Times executed: 1389 ]
[ User: postgres - Total duration: 297ms - Times executed: 101 ]
[ User: postgres - Total duration: 31ms - Times executed: 68 ]
[ User: postgres - Total duration: 187ms - Times executed: 60 ]
[ User: postgres - Total duration: 781ms - Times executed: 75 ]
[ User: postgres - Total duration: 3s897ms - Times executed: 68 ]
[ User: postgres - Total duration: 1s304ms - Times executed: 60 ]
[ User: postgres - Total duration: 185ms - Times executed: 30 ]
[ User: postgres - Total duration: 703ms - Times executed: 60 ]
[ User: postgres - Total duration: 1s309ms - Times executed: 75 ]
[ User: postgres - Total duration: 283ms - Times executed: 30 ]
[ User: postgres - Total duration: 115ms - Times executed: 30 ]
[ User: postgres - Total duration: 122ms - Times executed: 30 ]

Time consuming bind


[ User: postgres - Total duration: 38m28s - Times executed: 2743 ]
[ User: postgres - Total duration: 7s766ms - Times executed: 5234 ]
[ User: postgres - Total duration: 42s366ms - Times executed: 1394 ]
[ User: postgres - Total duration: 781ms - Times executed: 75 ]
[ User: postgres - Total duration: 1s309ms - Times executed: 75 ]
[ User: postgres - Total duration: 3s897ms - Times executed: 68 ]
[ User: postgres - Total duration: 2s184ms - Times executed: 75 ]
[ User: postgres - Total duration: 31ms - Times executed: 68 ]
[ User: postgres - Total duration: 9s912ms - Times executed: 75 ]
[ User: postgres - Total duration: 2s335ms - Times executed: 75 ]
[ User: postgres - Total duration: 999ms - Times executed: 75 ]
[ User: postgres - Total duration: 2s437ms - Times executed: 75 ]
[ User: postgres - Total duration: 1s510ms - Times executed: 75 ]
[ User: postgres - Total duration: 2s691ms - Times executed: 75 ]
[ User: postgres - Total duration: 5s900ms - Times executed: 75 ]
[ User: postgres - Total duration: 5s686ms - Times executed: 75 ]
[ User: postgres - Total duration: 1s408ms - Times executed: 69 ]
[ User: postgres - Total duration: 888ms - Times executed: 75 ]
[ User: postgres - Total duration: 3s225ms - Times executed: 75 ]
[ User: postgres - Total duration: 1s415ms - Times executed: 75 ]

Log levels

Key values

333,527 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	102	0.03%
DETAIL	68,500	20.54%
ERROR	107	0.03%
LOG	264,711	79.37%
STATEMENT	107	0.03%

Events distribution

Key values

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

Most Frequent Errors/Events

Key values

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

Rank

Times reported

Error

1

102

Details

ERROR: Downloader symbol ... on classname ... already exists. Use the add_downloadersymboltobroker_retool function instead.

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Oct 02	11	102

ERROR: Downloader symbol [F_HALKB1022] on classname [LEADERCAPITAL2] already exists. Use the add_downloadersymboltobroker_retool function instead.
ERROR: Downloader symbol [F_AEFES1022] on classname [LEADERCAPITAL2] already exists. Use the add_downloadersymboltobroker_retool function instead.
ERROR: Downloader symbol [F_AKBNK1022] on classname [LEADERCAPITAL2] already exists. Use the add_downloadersymboltobroker_retool function instead.

2

3

Details

ERROR: relation "..." does not exist

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Oct 02	11	3

ERROR: relation "t0" does not exist at character 83
ERROR: relation "timezones_th_th" does not exist at character 191

3

2

Details

ERROR: duplicate key value violates unique constraint "..."

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Oct 02	11	2

ERROR: duplicate key value violates unique constraint "idx_uniq_mt4datafeederrors_des"

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

Queries generating the most temporary files (N)

Queries generating the largest temporary files

Vacuums

Vacuums / Analyzes Distribution

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Autovacuum Activity

Locks

Locks by types

Key values

Type of locks

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values

Queries by user

Key values

Duration by user