pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sat Jun 10 03:03:37 2023
Log file: /home/postgres/pg_data/data/pg_log/postgresql-2023-06-10_040000.log, ..., /home/postgres/pg_data/data/pg_log/postgresql-2023-06-10_044848.log
Parsed 1,406,434 log entries in 4m36s
Log start from 2023-06-10 04:00:00 to 2023-06-10 05:00:00

Global Stats

25,639 Number of unique normalized queries
202,151 Number of queries
1h23m17s Total query duration
2023-06-10 04:00:00 First query
2023-06-10 05:00:00 Last query
3,649 queries/s at 2023-06-10 04:49:47 Query peak

1h23m17s Total query duration
15s60ms Prepare/parse total duration
4m9s Bind total duration
1h18m53s Execute total duration

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

43 Total number of automatic vacuums
84 Total number of automatic analyzes

718 Number temporary file
214.23 MiB Max size of temporary file
5.19 MiB Average size of temporary file

5,449 Total number of sessions
19 sessions at 2023-06-10 04:01:20 Session peak
1d7h17m21s Total duration of sessions
20s671ms Average duration of sessions
37 Average queries per session
917ms Average queries duration per session
19s754ms Average idle time per session

5,449 Total number of connections
72 connections/s at 2023-06-10 04:17:49 Connection peak
1 Total number of databases

SQL Traffic

Key values

3,649 queries/s Query Peak
2023-06-10 04:49:47 Date

SELECT Traffic

Key values

321 queries/s Query Peak
2023-06-10 04:32:10 Date

INSERT/UPDATE/DELETE Traffic

Key values

3,636 queries/s Query Peak
2023-06-10 04:49:47 Date

Queries duration

Key values

1h23m17s 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)
Jun 10	04	202,150	0ms	39s725ms	23ms	2m11s	3m27s	9m48s
	05	1	0ms	0ms	0ms	0ms	0ms	0ms

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jun 10	04	58,544	0	34ms	42s215ms	1m32s	3m55s
	05	1	0	0ms	0ms	0ms	0ms

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jun 10	04	133,775	1,121	512	0	1ms	2s198ms	4s728ms	8s354ms
	05	0	0	0	0	0ms	0ms	0ms	0ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Jun 10	04	36,369	155,004	4.26	18.55%
	05	0	0	0.00	0.00%

Day	Hour	Count	Average / Second
Jun 10	04	5,449	1.51/s
	05	0	0.00/s

Day	Hour	Count	Average Duration	Average idle time
Jun 10	04	5,449	20s671ms	19s803ms
	05	0	0ms	0ms

↑ Back to the top of the General Activity table

Established Connections

Key values

72 connections Connection Peak
2023-06-10 04:17:49 Date

Connections per database

Key values

acaweb_fx Main Database
5,449 connections Total

Chart
Table

Database	User	Count
acaweb_fx		5,449
	postgres	4,258
	psql	1,191

Connections per user

Key values

postgres Main User
5,449 connections Total

Chart
Table

User	Count
postgres	4,258
psql	1,191

Connections per host

Key values

192.168.2.44 Main host with 1637 connections
5,449 Total connections

Chart
Table

Host	Count
127.0.0.1	1
192.168.0.216	170
192.168.0.239	528
192.168.0.42	93
192.168.1.135	17
192.168.1.145	1
192.168.1.20	1
192.168.1.201	459
192.168.1.23	1,109
192.168.1.239	151
192.168.1.25	6
192.168.1.250	22
192.168.1.44	54
192.168.2.126	18
192.168.2.205	20
192.168.2.44	1,637
192.168.2.82	44
192.168.3.199	91
192.168.4.142	654
192.168.4.98	307
[local]	66

Simultaneous sessions

Key values

19 sessions Session Peak
2023-06-10 04:01:20 Date

Histogram of session times

Key values

4,317 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	4,317	79.23%
500ms-1s	139	2.55%
1s-30s	733	13.45%
30s-1m	93	1.71%
1m-10m	141	2.59%
10m-30m	12	0.22%
30m-1h	9	0.17%
1h-8h	5	0.09%
> 8h	0	0.00%

Sessions per database

Key values

acaweb_fx Main Database
5,449 sessions Total

Chart
Table

Database	User	Count	Total Duration	Average Duration
acaweb_fx	5,449	1d7h17m21s	20s671ms

Sessions per user

Key values

postgres Main User
5,449 sessions Total

Chart
Table

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

Sessions per host

Key values

192.168.2.44 Main Host
5,449 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	1	59m46s	59m46s
192.168.0.216	170	2h18m46s	48s977ms
192.168.0.239	528	2h4m28s	14s143ms
192.168.0.42	93	1h34m12s	1m
192.168.1.135	17	5h5m36s	17m58s
192.168.1.145	1	1h20m4s	1h20m4s
192.168.1.20	1	3h50m5s	3h50m5s
192.168.1.201	459	2h8m19s	16s773ms
192.168.1.23	1,109	1h49m27s	5s921ms
192.168.1.239	151	1s6ms	6ms
192.168.1.25	6	44ms	7ms
192.168.1.250	22	2h55m29s	7m58s
192.168.1.44	54	1s73ms	19ms
192.168.2.126	18	5s53ms	280ms
192.168.2.205	20	480ms	24ms
192.168.2.44	1,637	2h14m10s	4s917ms
192.168.2.82	44	3h29m21s	4m45s
192.168.3.199	91	5m3s	3s335ms
192.168.4.142	654	1h21m16s	7s456ms
192.168.4.98	307	15s837ms	51ms
[local]	66	50s927ms	771ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
5,449 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	2,230	20h47m42s	33s570ms
[unknown]	1,974	10h5m33s	18s405ms
dreamfactory	54	1s73ms	19ms
psql	1,191	24m4s	1s213ms

Checkpoints Buffers

Key values

14,243 buffers Checkpoint Peak
2023-06-10 04:53:34 Date
209.949 seconds Highest write time
0.052 seconds Sync time

Checkpoints Wal files

Key values

15 files Wal files usage Peak
2023-06-10 04:23:34 Date

Checkpoints distance

Key values

470.54 Mo Distance Peak
2023-06-10 04:23:34 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jun 10	04	54,915	2,518.716s	0.139s	2,519.123s
	05	0	0s	0s	0s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Jun 10	04	0	0	74	1,523	0.033s	0s
	05	0	0	0	0	0s	0s

Day	Hour	Count	Avg time (sec)
Jun 10	04	0	0s
	05	0	0s

Day	Hour	Mean distance	Mean estimate
Jun 10	04	101,066.73 kB	168,525.82 kB
	05	0.00 kB	0.00 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (12) Main checkpoint cause
12 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	12
Total	12

Size of temporary files

Key values

178.29 MiB Temp Files size Peak
2023-06-10 04:01:06 Date

Number of temporary files

Key values

12 per second Temp Files Peak
2023-06-10 04:07:50 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jun 10	04	718	3.64 GiB	5.19 MiB
	05	0	0	0

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)


Date: 2023-06-10 04:49:02
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.250
Application: PostgreSQL JDBC Driver
Date: 2023-06-10 04:01:33
Duration: 26s810ms
Database: acaweb_fx
User: postgres
Remote: 192.168.2.44
Application: psql
Date: 2023-06-10 04:01:48
Duration: 39s725ms
Database: acaweb_fx
User: postgres
Remote: 192.168.2.44
Application: psql
Date: 2023-06-10 04:52:19
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.23
Application: PostgreSQL JDBC Driver
Date: 2023-06-10 04:50:32
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.20
Application: PostgreSQL JDBC Driver
Date: 2023-06-10 04:47:00
Duration: 5s362ms
Database: acaweb_fx
User: postgres
Remote: 192.168.2.44
Application: psql
Date: 2023-06-10 04:01:06
Duration: 26s840ms
Database: acaweb_fx
User: postgres
Remote: 192.168.2.44
Application: psql
Date: 2023-06-10 04:00:13
Duration: 11s590ms
Database: acaweb_fx
User: postgres
Remote: 192.168.2.44
Application: psql
Date: 2023-06-10 04:50:47
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 182.165.1.42
Application: [unknown]
Date: 2023-06-10 04:05:03
Duration: 2s169ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2023-06-10 04:46:19
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.135
Application: PostgreSQL JDBC Driver
Date: 2023-06-10 04:00:34
Duration: 20s831ms
Database: acaweb_fx
User: postgres
Remote: 192.168.2.44
Application: psql
Date: 2023-06-10 04:19:44
Duration: 97ms
Database: acaweb_fx
User: postgres
Remote: 192.168.0.239
Application: PostgreSQL JDBC Driver
Date: 2023-06-10 04:29:09
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.250
Application: PostgreSQL JDBC Driver

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

Queries generating the largest temporary files


[ Date: 2023-06-10 04:00:47 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:00:13 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:46:59 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:04:33 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:12:17 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:14:36 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:03:46 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:04:01 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:01:34 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:14:20 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:14:22 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:05:23 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:08:33 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:04:39 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:04:31 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:05:22 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:04:30 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:08:29 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:08:30 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:13:52 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]

Rank	Size	Query
1	214.23 MiB	select stats_calcstatsforallbrokers (); [ Date: 2023-06-10 04:00:47 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
2	210.19 MiB	select stats_populatestatssuccess_keylevels (vGetInt ('stats_latestresultuid_kl')); [ Date: 2023-06-10 04:00:13 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
3	45.87 MiB	select distinct ss.statsid from stats_success t inner join stats_symbols ss on t.symbolid = ss.symbolid where ss.statsid in ( select statsid from stats where (0 = 0 or brokerid = 0)) and atbaridentified >= (current_timestamp - interval '12 months') and atbaridentified <= current_timestamp and type = 'ekl' and pattern not ilike '%NON_LIQUID%' and (0 = 0 OR statsid >= 0) order by ss.statsid; [ Date: 2023-06-10 04:46:59 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
4	36.30 MiB	select stats_createSummaryTables_ChartPattens (cast(515852059314095307 as bigint)); [ Date: 2023-06-10 04:04:33 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
5	36.30 MiB	select stats_createSummaryTables_ChartPattens (cast(515852059330454307 as bigint)); [ Date: 2023-06-10 04:12:17 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
6	33.98 MiB	select distinct ss.statsid from stats_success t inner join stats_symbols ss on t.symbolid = ss.symbolid where ss.statsid in ( select statsid from stats where (0 = 0 or brokerid = 0)) and atbaridentified >= (current_timestamp - interval '12 months') and atbaridentified <= current_timestamp and type = 'cp' and pattern not ilike '%NON_LIQUID%' and (0 = 0 OR statsid >= 0) order by ss.statsid; [ Date: 2023-06-10 04:14:36 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
7	31.11 MiB	select stats_createSummaryTables_KeyLevels (cast(515852059304895307 as bigint)); [ Date: 2023-06-10 04:03:46 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
8	30.66 MiB	select stats_createSummaryTables_KeyLevels (cast(515852059306689307 as bigint)); [ Date: 2023-06-10 04:04:01 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
9	29.58 MiB	select stats_createSummaryTables_KeyLevels (cast(500996399105328207 as bigint)); [ Date: 2023-06-10 04:01:34 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
10	29.27 MiB	select stats_createSummaryTables_KeyLevels (cast(601729875339881307 as bigint)); [ Date: 2023-06-10 04:14:20 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
11	29.27 MiB	select stats_createSummaryTables_KeyLevels (cast(601729875357715307 as bigint)); [ Date: 2023-06-10 04:14:22 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
12	28.02 MiB	select stats_createSummaryTables_KeyLevels (cast(515852059320386307 as bigint)); [ Date: 2023-06-10 04:05:23 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
13	28.02 MiB	select stats_createSummaryTables_KeyLevels (cast(515852059325089307 as bigint)); [ Date: 2023-06-10 04:08:33 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
14	27.52 MiB	select stats_createSummaryTables_ChartPattens (cast(515852059315971307 as bigint)); [ Date: 2023-06-10 04:04:39 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
15	26.62 MiB	select stats_createSummaryTables_KeyLevels (cast(515852059313587307 as bigint)); [ Date: 2023-06-10 04:04:31 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
16	26.62 MiB	select stats_createSummaryTables_KeyLevels (cast(515852059320173307 as bigint)); [ Date: 2023-06-10 04:05:22 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
17	26.31 MiB	select stats_createSummaryTables_ChartPattens (cast(515852059313489307 as bigint)); [ Date: 2023-06-10 04:04:30 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
18	26.19 MiB	select stats_createSummaryTables_KeyLevels (cast(515852059324253307 as bigint)); [ Date: 2023-06-10 04:08:29 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
19	26.19 MiB	select stats_createSummaryTables_KeyLevels (cast(515852059324736307 as bigint)); [ Date: 2023-06-10 04:08:30 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
20	25.34 MiB	select stats_createSummaryTables_ChartPattens (cast(515852059331265307 as bigint)); [ Date: 2023-06-10 04:13:52 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]

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.stats_summary_2d (10) Main table analyzed (database acaweb_fx)
84 analyzes Total

Chart
Table

Table	Number of analyzes
acaweb_fx.public.stats_summary_2d	10
acaweb_fx.pg_catalog.pg_attribute	9
acaweb_fx.public.stats_hrs_summary_2d	8
acaweb_fx.public.stats_hrsapproaches_summary	8
acaweb_fx.public.stats_hrs_summary	8
acaweb_fx.public.stats_summary	8
acaweb_fx.public.datafeeds_latestrun	7
acaweb_fx.public.stats_hrsapproaches_summary_2d	5
acaweb_fx.pg_catalog.pg_type	5
acaweb_fx.public.latest_candle_datetime_per_receng	3
acaweb_fx.pg_catalog.pg_depend	2
acaweb_fx.public.latest_t15_candle_view	2
acaweb_fx.pg_catalog.pg_class	2
acaweb_fx.public.stats	2
acaweb_fx.public.consecutivecandles_results	1
acaweb_fx.public.sa_hist_bigmove	1
acaweb_fx.public.bigmovement_results_underlying	1
acaweb_fx.public.variables	1
acaweb_fx.public.sa_hist_consecutivecandles	1
Total	84

Vacuums per table

Key values

public.stats_summary_2d (6) Main table vacuumed on database acaweb_fx
43 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.stats_summary_2d	6	0	147,453	0	6,386	0	119,366	21,635	6	1,322,320
acaweb_fx.public.datafeeds_latestrun	5	0	582	0	13	0	0	93	14	81,256
acaweb_fx.public.stats_hrs_summary_2d	5	0	42,063	0	56	0	20,485	5,789	6	385,816
acaweb_fx.public.stats_hrsapproaches_summary_2d	4	0	31,412	0	196	0	23,821	2,943	12	250,928
acaweb_fx.pg_catalog.pg_attribute	3	3	2,607	0	226	0	177	1,207	415	2,526,340
acaweb_fx.public.stats_hrsapproaches_summary	3	3	2,953	0	602	0	324	2,810	955	4,847,490
acaweb_fx.public.stats_hrs_summary	3	3	2,968	0	663	0	303	2,773	937	4,705,456
acaweb_fx.public.stats_summary	3	3	4,358	0	1,340	0	578	4,318	1,114	5,720,690
acaweb_fx.pg_toast.pg_toast_2619	2	2	221	0	114	0	0	196	52	222,912
acaweb_fx.public.latest_t15_candle_view	2	2	166	0	8	0	0	12	2	15,387
acaweb_fx.public.bigmovement_results_underlying	2	1	6,730	0	1,693	0	0	2,919	1,525	4,671,265
acaweb_fx.pg_catalog.pg_class	1	1	505	0	51	0	0	282	49	196,765
acaweb_fx.pg_catalog.pg_type	1	1	130	0	22	0	0	50	21	120,840
acaweb_fx.pg_catalog.pg_statistic	1	1	883	0	188	0	619	504	131	560,358
acaweb_fx.public.stats	1	0	103	0	2	0	0	23	10	50,294
acaweb_fx.public.variables	1	0	35	0	2	0	0	3	1	3,987
Total	43	20	243,169	204,832	11,562	0	165,673	45,557	5,250	25,682,104

Tuples removed per table

Key values

public.stats_summary (24071) Main table with removed tuples on database acaweb_fx
62361 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
acaweb_fx.public.stats_summary	3	3	24,071	150,664	208	0	2,571
acaweb_fx.public.stats_hrsapproaches_summary	3	3	15,599	93,026	77	0	1,572
acaweb_fx.public.stats_hrs_summary	3	3	15,347	91,773	73	0	1,566
acaweb_fx.pg_catalog.pg_attribute	3	3	3,231	27,918	243	0	717
acaweb_fx.public.bigmovement_results_underlying	2	1	2,248	54,937	8,498	0	1,966
acaweb_fx.pg_catalog.pg_statistic	1	1	661	4,082	0	0	1,194
acaweb_fx.public.datafeeds_latestrun	5	0	325	125	0	0	90
acaweb_fx.pg_catalog.pg_class	1	1	277	1,579	18	0	150
acaweb_fx.pg_toast.pg_toast_2619	2	2	147	338	3	0	102
acaweb_fx.public.stats	1	0	135	407	2	0	12
acaweb_fx.public.latest_t15_candle_view	2	2	115	66	16	0	2
acaweb_fx.public.variables	1	0	107	2	0	0	4
acaweb_fx.pg_catalog.pg_type	1	1	98	1,290	4	0	36
acaweb_fx.public.stats_hrs_summary_2d	5	0	0	1,448,318	0	81	35,200
acaweb_fx.public.stats_summary_2d	6	0	0	7,009,800	0	409	178,596
acaweb_fx.public.stats_hrsapproaches_summary_2d	4	0	0	913,158	0	106	30,196
Total	43	20	62,361	9,797,483	9,142	596	253,974

Pages removed per table

Key values

public.stats_summary_2d (409) Main table with removed pages on database acaweb_fx
596 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
acaweb_fx.public.stats_summary_2d	6	0	0	409
acaweb_fx.public.stats_hrsapproaches_summary_2d	4	0	0	106
acaweb_fx.public.stats_hrs_summary_2d	5	0	0	81
acaweb_fx.pg_toast.pg_toast_2619	2	2	147	0
acaweb_fx.public.datafeeds_latestrun	5	0	325	0
acaweb_fx.pg_catalog.pg_attribute	3	3	3231	0
acaweb_fx.public.latest_t15_candle_view	2	2	115	0
acaweb_fx.pg_catalog.pg_class	1	1	277	0
acaweb_fx.pg_catalog.pg_type	1	1	98	0
acaweb_fx.pg_catalog.pg_statistic	1	1	661	0
acaweb_fx.public.bigmovement_results_underlying	2	1	2248	0
acaweb_fx.public.stats_hrsapproaches_summary	3	3	15599	0
acaweb_fx.public.stats	1	0	135	0
acaweb_fx.public.stats_hrs_summary	3	3	15347	0
acaweb_fx.public.variables	1	0	107	0
acaweb_fx.public.stats_summary	3	3	24071	0
Total	43	20	62,361	596

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jun 10	04	43	84
	05	0	0

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

NO DATASET

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

Most frequent waiting queries (N)

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

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

58,545 Total read queries
137,500 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	58,545	28.96%
INSERT	133,775	66.18%
UPDATE	1,121	0.55%
DELETE	512	0.25%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	1,478	0.73%
DDL	0	0.00%
TCL	614	0.30%
CURSOR	0	0.00%
OTHERS	6,106	3.02%

Queries by database

Key values

acaweb_fx Main database
202,151 Requests
1h18m53s (acaweb_fx)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
acaweb_fx	Total	202,151	1h18m53s
	cte	1,478	42m19s
	delete	512	571ms
	insert	133,775	2m34s
	others	6,106	12s46ms
	select	58,545	33m44s
	tcl	614	197ms
	update	1,121	1s890ms

Queries by user

Key values

postgres Main user
202,151 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	202,151	1h18m53s
	cte	1,478	42m19s
	delete	512	571ms
	insert	133,775	2m34s
	others	6,106	12s46ms
	select	58,545	33m44s
	tcl	614	197ms
	update	1,121	1s890ms

Duration by user

Key values

1h18m53s (postgres) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	202,151	1h18m53s
	cte	1,478	42m19s
	delete	512	571ms
	insert	133,775	2m34s
	others	6,106	12s46ms
	select	58,545	33m44s
	tcl	614	197ms
	update	1,121	1s890ms

Queries by host

Key values

192.168.4.142 Main host
102,935 Requests
30m43s (192.168.2.44)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	4,554	14s449ms
	insert	1,009	1s731ms
	others	4	0ms
	select	2,958	12s259ms
	update	583	458ms
182.165.1.42	Total	120	6m16s
	cte	60	6m16s
	select	60	0ms
192.168.0.216	Total	672	3s341ms
	insert	4	2s808ms
	others	332	26ms
	select	328	356ms
	update	8	150ms
192.168.0.239	Total	5,225	27s261ms
	others	1,056	14ms
	select	4,169	27s247ms
192.168.0.42	Total	2,253	17s764ms
	insert	1	10ms
	others	186	1ms
	select	2,066	17s752ms
192.168.1.135	Total	1,294	2m59s
	cte	534	2m58s
	others	34	0ms
	select	726	753ms
192.168.1.145	Total	424	5m20s
	cte	60	5m20s
	others	2	0ms
	select	362	341ms
192.168.1.20	Total	430	4m50s
	cte	60	4m50s
	others	2	0ms
	select	368	327ms
192.168.1.201	Total	19,577	1m13s
	cte	6	20ms
	insert	1	1ms
	others	918	9ms
	select	18,596	1m13s
	update	56	6ms
192.168.1.210	Total	56	2ms
	select	56	2ms
192.168.1.23	Total	17,844	1m31s
	cte	6	57ms
	others	2,218	26ms
	select	15,615	1m31s
	update	5	0ms
192.168.1.239	Total	604	264ms
	others	302	18ms
	select	302	245ms
192.168.1.25	Total	6	9ms
	select	6	9ms
192.168.1.250	Total	4,540	23m7s
	cte	752	22m53s
	others	44	0ms
	select	3,744	14s221ms
192.168.1.44	Total	204	298ms
	insert	18	48ms
	others	162	1ms
	select	24	248ms
192.168.1.45	Total	58	130ms
	select	58	130ms
192.168.2.126	Total	30	27ms
	others	12	0ms
	select	18	27ms
192.168.2.205	Total	80	120ms
	others	40	2ms
	select	36	29ms
	update	4	88ms
192.168.2.44	Total	31,972	30m43s
	delete	512	571ms
	insert	25,224	1m57s
	others	512	40ms
	select	5,724	28m44s
192.168.2.82	Total	7,915	32s346ms
	insert	7,109	21s382ms
	others	88	6ms
	select	592	10s602ms
	update	126	354ms
192.168.3.199	Total	364	302ms
	others	182	13ms
	select	171	163ms
	update	11	125ms
192.168.4.142	Total	102,935	11s755ms
	insert	100,409	11s29ms
	select	2,526	726ms
192.168.4.98	Total	928	12s140ms
	others	7	11s280ms
	select	7	22ms
	tcl	614	197ms
	update	300	640ms
[local]	Total	66	50s810ms
	others	5	602ms
	select	33	50s141ms
	update	28	66ms

Queries by application

Key values

[unknown] Main application
151,393 Requests
39m47s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	49,471	39m47s
	cte	1,418	36m2s
	insert	2	11ms
	others	2,230	31ms
	select	45,760	3m45s
	update	61	6ms
[unknown]	Total	151,393	15m8s
	cte	60	6m16s
	insert	133,755	2m34s
	others	3,817	11s411ms
	select	12,115	6m2s
	tcl	614	197ms
	update	1,032	1s817ms
dreamfactory	Total	96	297ms
	insert	18	48ms
	others	54	0ms
	select	24	248ms
psql	Total	1,191	23m57s
	delete	512	571ms
	others	5	602ms
	select	646	23m56s
	update	28	66ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2023-06-10 04:27:36 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

148,283 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	148,283	73.35%
1-5ms	36,424	18.02%
5-10ms	10,236	5.06%
10-25ms	2,941	1.45%
25-50ms	1,402	0.69%
50-100ms	817	0.40%
100-500ms	921	0.46%
500-1000ms	300	0.15%
1000-10000ms	716	0.35%
> 10000ms	111	0.05%

Slowest individual queries


[ Date: 2023-06-10 04:01:48 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:01:48 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:01:40 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:01:38 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:01:37 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:01:37 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:01:38 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:01:06 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:01:33 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:01:35 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:01:36 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:01:33 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:01:35 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:01:32 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:01:32 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:01:30 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
[ Date: 2023-06-10 04:05:53 - Database: acaweb_fx - User: postgres - Remote: 182.165.1.42 - Application: [unknown] - Bind query: yes ]
[ Date: 2023-06-10 04:00:52 - Database: acaweb_fx - User: postgres - Remote: 182.165.1.42 - Application: [unknown] - Bind query: yes ]
[ Date: 2023-06-10 04:20:52 - Database: acaweb_fx - User: postgres - Remote: 182.165.1.42 - Application: [unknown] - Bind query: yes ]
[ Date: 2023-06-10 04:01:28 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]

Rank	Duration	Query
1	39s725ms	select stats_createSummaryTables_KeyLevels (cast(500996399110219207 as bigint)); [ Date: 2023-06-10 04:01:48 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
2	38s443ms	select stats_createSummaryTables_KeyLevels (cast(500996399110424207 as bigint)); [ Date: 2023-06-10 04:01:48 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
3	33s552ms	select stats_createSummaryTables_KeyLevels (cast(500996399105328207 as bigint)); [ Date: 2023-06-10 04:01:40 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
4	31s273ms	select stats_createSummaryTables_KeyLevels (cast(500996399109416207 as bigint)); [ Date: 2023-06-10 04:01:38 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
5	29s735ms	select stats_createSummaryTables_KeyLevels (cast(500996399109818207 as bigint)); [ Date: 2023-06-10 04:01:37 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
6	29s231ms	select stats_createSummaryTables_KeyLevels (cast(500996399109916207 as bigint)); [ Date: 2023-06-10 04:01:37 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
7	28s68ms	select stats_createSummaryTables_KeyLevels (cast(515852059242301307 as bigint)); [ Date: 2023-06-10 04:01:38 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
8	26s840ms	select stats_calcstatsforallbrokers (); [ Date: 2023-06-10 04:01:06 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
9	26s810ms	select stats_createSummaryTables_ChartPattens (cast(500996399105328207 as bigint)); [ Date: 2023-06-10 04:01:33 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
10	26s154ms	select stats_createSummaryTables_ChartPattens (cast(500996399110219207 as bigint)); [ Date: 2023-06-10 04:01:35 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
11	25s557ms	select stats_createSummaryTables_ChartPattens (cast(515852059242301307 as bigint)); [ Date: 2023-06-10 04:01:36 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
12	25s432ms	select stats_createSummaryTables_ChartPattens (cast(500996399109416207 as bigint)); [ Date: 2023-06-10 04:01:33 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
13	25s237ms	select stats_createSummaryTables_ChartPattens (cast(500996399110424207 as bigint)); [ Date: 2023-06-10 04:01:35 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
14	24s822ms	select stats_createSummaryTables_ChartPattens (cast(500996399109818207 as bigint)); [ Date: 2023-06-10 04:01:32 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
15	24s208ms	select stats_createSummaryTables_ChartPattens (cast(500996399109916207 as bigint)); [ Date: 2023-06-10 04:01:32 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
16	22s983ms	select stats_createSummaryTables_KeyLevels (cast(500996399109302207 as bigint)); [ Date: 2023-06-10 04:01:30 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]
17	22s908ms	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 = '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 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 ('312' = 0 OR coalesce(bim.code, s.symbol) in ('#AAPL', '#ADS', '#AIG', '#ALV', '#AMZN', '#AXP', '#BA', '#BABA', '#BAC', '#BAS', '#BAYN', '#BEI', '#BIDU', '#BMW', '#C', '#CAT', '#CBK', '#CL', '#CSCO', '#CVX', '#DAI', '#DB1', '#DBK', '#DIS', '#DPW', '#DTE', '#EBAY', '#EON', '#F', '#FB', '#FDX', '#FME', '#GE', '#GM', '#GOOG', '#GS', '#HPQ', '#IBM', '#IFX', '#INTC', '#JD', '#JNJ', '#JPM', '#KO', '#LHA', '#LIN', '#LMT', '#MA', '#MCD', '#META', '#MMM', '#MSFT', '#MUV2', '#NFLX', '#NKE', '#NTES', '#ORCL', '#PFE', '#PG', '#QCOM', '#RACE', '#RWE', '#SAP', '#SIE', '#T', '#UBER', '#V', '#VOW', '#WB', '#XOM', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'AUS200', 'BRENT', 'BTCUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'CHI50', 'ESP35', 'ETHUSD', 'EU50', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURNZD', 'EURPLN', 'EURUSD', 'FRA40', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GER30', 'HK50', 'HKCH50', 'IT40', 'JP225', 'LTCUSD', 'NAS100', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'SPX500', 'UK100', 'US30', 'USDCAD', 'USDCHF', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHKD', 'USDHUF', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDTRY', 'USDX', 'USDZAR', 'WTI', 'XAGUSD', 'XAUUSD', '#ADS', '#ALV', '#BAS', '#BAYN', '#BEI', '#BMW', '#CBK', '#DAI', '#DB1', '#DBK', '#DPW', '#DTE', '#EON', '#FME', '#IFX', '#LHA', '#LIN', '#MUV2', '#RWE', '#SAP', '#SIE', '#VOW', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURNZD', 'EURPLN', 'EURUSD', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHKD', 'USDHUF', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDTRY', 'USDX', 'USDZAR', 'XAGUSD', 'XAUUSD', 'BTCUSD', 'ETHUSD', 'LTCUSD', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURNZD', 'EURPLN', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHKD', 'USDHUF', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDTRY', 'USDX', 'USDZAR', 'XAGUSD', 'XAUUSD', 'BRENT', 'WTI', 'AUS200', 'CHI50', 'ESP35', 'EU50', 'FRA40', 'GER30', 'HK50', 'HKCH50', 'IT40', 'JP225', 'NAS100', 'SPX500', 'UK100', 'US30', 'AUDUSD', 'EURUSD', 'GBPUSD', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDJPY', '#AAPL', '#AIG', '#AMZN', '#AXP', '#BA', '#BABA', '#BAC', '#BIDU', '#C', '#CAT', '#CL', '#CSCO', '#CVX', '#DIS', '#EBAY', '#F', '#FB', '#FDX', '#GE', '#GM', '#GOOG', '#GS', '#HPQ', '#IBM', '#INTC', '#JD', '#JNJ', '#JPM', '#KO', '#LMT', '#MA', '#MCD', '#MMM', '#MSFT', '#NFLX', '#NKE', '#NTES', '#ORCL', '#PFE', '#PG', '#QCOM', '#RACE', '#T', '#UBER', '#V', '#WB', '#XOM')) AND ('0' = 0 OR ar.pattern in ('')) AND ('0' = 0 OR ('0' = 1 AND ar.breakout >= 0) OR ('0' = 2 AND ar.breakout < 0)) AND ('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: 2023-06-10 04:05:53 - Database: acaweb_fx - User: postgres - Remote: 182.165.1.42 - Application: [unknown] - Bind query: yes ]
18	22s597ms	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 = '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 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 ('312' = 0 OR coalesce(bim.code, s.symbol) in ('#AAPL', '#ADS', '#AIG', '#ALV', '#AMZN', '#AXP', '#BA', '#BABA', '#BAC', '#BAS', '#BAYN', '#BEI', '#BIDU', '#BMW', '#C', '#CAT', '#CBK', '#CL', '#CSCO', '#CVX', '#DAI', '#DB1', '#DBK', '#DIS', '#DPW', '#DTE', '#EBAY', '#EON', '#F', '#FB', '#FDX', '#FME', '#GE', '#GM', '#GOOG', '#GS', '#HPQ', '#IBM', '#IFX', '#INTC', '#JD', '#JNJ', '#JPM', '#KO', '#LHA', '#LIN', '#LMT', '#MA', '#MCD', '#META', '#MMM', '#MSFT', '#MUV2', '#NFLX', '#NKE', '#NTES', '#ORCL', '#PFE', '#PG', '#QCOM', '#RACE', '#RWE', '#SAP', '#SIE', '#T', '#UBER', '#V', '#VOW', '#WB', '#XOM', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'AUS200', 'BRENT', 'BTCUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'CHI50', 'ESP35', 'ETHUSD', 'EU50', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURNZD', 'EURPLN', 'EURUSD', 'FRA40', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GER30', 'HK50', 'HKCH50', 'IT40', 'JP225', 'LTCUSD', 'NAS100', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'SPX500', 'UK100', 'US30', 'USDCAD', 'USDCHF', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHKD', 'USDHUF', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDTRY', 'USDX', 'USDZAR', 'WTI', 'XAGUSD', 'XAUUSD', '#ADS', '#ALV', '#BAS', '#BAYN', '#BEI', '#BMW', '#CBK', '#DAI', '#DB1', '#DBK', '#DPW', '#DTE', '#EON', '#FME', '#IFX', '#LHA', '#LIN', '#MUV2', '#RWE', '#SAP', '#SIE', '#VOW', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURNZD', 'EURPLN', 'EURUSD', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHKD', 'USDHUF', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDTRY', 'USDX', 'USDZAR', 'XAGUSD', 'XAUUSD', 'BTCUSD', 'ETHUSD', 'LTCUSD', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURNZD', 'EURPLN', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHKD', 'USDHUF', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDTRY', 'USDX', 'USDZAR', 'XAGUSD', 'XAUUSD', 'BRENT', 'WTI', 'AUS200', 'CHI50', 'ESP35', 'EU50', 'FRA40', 'GER30', 'HK50', 'HKCH50', 'IT40', 'JP225', 'NAS100', 'SPX500', 'UK100', 'US30', 'AUDUSD', 'EURUSD', 'GBPUSD', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDJPY', '#AAPL', '#AIG', '#AMZN', '#AXP', '#BA', '#BABA', '#BAC', '#BIDU', '#C', '#CAT', '#CL', '#CSCO', '#CVX', '#DIS', '#EBAY', '#F', '#FB', '#FDX', '#GE', '#GM', '#GOOG', '#GS', '#HPQ', '#IBM', '#INTC', '#JD', '#JNJ', '#JPM', '#KO', '#LMT', '#MA', '#MCD', '#MMM', '#MSFT', '#NFLX', '#NKE', '#NTES', '#ORCL', '#PFE', '#PG', '#QCOM', '#RACE', '#T', '#UBER', '#V', '#WB', '#XOM')) AND ('0' = 0 OR ar.pattern in ('')) AND ('0' = 0 OR ('0' = 1 AND ar.breakout >= 0) OR ('0' = 2 AND ar.breakout < 0)) AND ('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: 2023-06-10 04:00:52 - Database: acaweb_fx - User: postgres - Remote: 182.165.1.42 - Application: [unknown] - Bind query: yes ]
19	21s706ms	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 = '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 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 ('312' = 0 OR coalesce(bim.code, s.symbol) in ('#AAPL', '#ADS', '#AIG', '#ALV', '#AMZN', '#AXP', '#BA', '#BABA', '#BAC', '#BAS', '#BAYN', '#BEI', '#BIDU', '#BMW', '#C', '#CAT', '#CBK', '#CL', '#CSCO', '#CVX', '#DAI', '#DB1', '#DBK', '#DIS', '#DPW', '#DTE', '#EBAY', '#EON', '#F', '#FB', '#FDX', '#FME', '#GE', '#GM', '#GOOG', '#GS', '#HPQ', '#IBM', '#IFX', '#INTC', '#JD', '#JNJ', '#JPM', '#KO', '#LHA', '#LIN', '#LMT', '#MA', '#MCD', '#META', '#MMM', '#MSFT', '#MUV2', '#NFLX', '#NKE', '#NTES', '#ORCL', '#PFE', '#PG', '#QCOM', '#RACE', '#RWE', '#SAP', '#SIE', '#T', '#UBER', '#V', '#VOW', '#WB', '#XOM', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'AUS200', 'BRENT', 'BTCUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'CHI50', 'ESP35', 'ETHUSD', 'EU50', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURNZD', 'EURPLN', 'EURUSD', 'FRA40', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GER30', 'HK50', 'HKCH50', 'IT40', 'JP225', 'LTCUSD', 'NAS100', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'SPX500', 'UK100', 'US30', 'USDCAD', 'USDCHF', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHKD', 'USDHUF', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDTRY', 'USDX', 'USDZAR', 'WTI', 'XAGUSD', 'XAUUSD', '#ADS', '#ALV', '#BAS', '#BAYN', '#BEI', '#BMW', '#CBK', '#DAI', '#DB1', '#DBK', '#DPW', '#DTE', '#EON', '#FME', '#IFX', '#LHA', '#LIN', '#MUV2', '#RWE', '#SAP', '#SIE', '#VOW', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURNZD', 'EURPLN', 'EURUSD', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHKD', 'USDHUF', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDTRY', 'USDX', 'USDZAR', 'XAGUSD', 'XAUUSD', 'BTCUSD', 'ETHUSD', 'LTCUSD', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURNZD', 'EURPLN', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHKD', 'USDHUF', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDTRY', 'USDX', 'USDZAR', 'XAGUSD', 'XAUUSD', 'BRENT', 'WTI', 'AUS200', 'CHI50', 'ESP35', 'EU50', 'FRA40', 'GER30', 'HK50', 'HKCH50', 'IT40', 'JP225', 'NAS100', 'SPX500', 'UK100', 'US30', 'AUDUSD', 'EURUSD', 'GBPUSD', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDJPY', '#AAPL', '#AIG', '#AMZN', '#AXP', '#BA', '#BABA', '#BAC', '#BIDU', '#C', '#CAT', '#CL', '#CSCO', '#CVX', '#DIS', '#EBAY', '#F', '#FB', '#FDX', '#GE', '#GM', '#GOOG', '#GS', '#HPQ', '#IBM', '#INTC', '#JD', '#JNJ', '#JPM', '#KO', '#LMT', '#MA', '#MCD', '#MMM', '#MSFT', '#NFLX', '#NKE', '#NTES', '#ORCL', '#PFE', '#PG', '#QCOM', '#RACE', '#T', '#UBER', '#V', '#WB', '#XOM')) AND ('0' = 0 OR ar.pattern in ('')) AND ('0' = 0 OR ('0' = 1 AND ar.breakout >= 0) OR ('0' = 2 AND ar.breakout < 0)) AND ('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: 2023-06-10 04:20:52 - Database: acaweb_fx - User: postgres - Remote: 182.165.1.42 - Application: [unknown] - Bind query: yes ]
20	21s605ms	select stats_createSummaryTables_ChartPattens (cast(500996399109302207 as bigint)); [ Date: 2023-06-10 04:01:28 - Database: acaweb_fx - User: postgres - Remote: 192.168.2.44 - Application: psql ]

Time consuming queries


[ User: postgres - Total duration: 17m17s - Times executed: 131 ]
[ User: postgres - Total duration: 14m44s - Times executed: 246 ]
[ User: postgres - Total duration: 8m38s - Times executed: 131 ]
[ User: postgres - Total duration: 7m6s - Times executed: 246 ]
[ User: postgres - Total duration: 5m55s - Times executed: 131 ]
[ User: postgres - Total duration: 3m36s - Times executed: 12 ]
[ User: postgres - Total duration: 3m16s - Times executed: 309 ]
[ User: postgres - Total duration: 2m33s - Times executed: 12 ]
[ User: postgres - Total duration: 2m20s - Times executed: 203 ]
[ User: postgres - Total duration: 1m49s - Times executed: 132 ]
[ User: postgres - Total duration: 1m7s - Times executed: 2106 ]
[ User: postgres - Total duration: 1m2s - Times executed: 132 ]
[ User: postgres - Total duration: 56s769ms - Times executed: 106 ]
[ User: postgres - Total duration: 45s769ms - Times executed: 31 ]
[ User: postgres - Total duration: 26s840ms - Times executed: 1 ]
[ User: postgres - Total duration: 20s831ms - Times executed: 1 ]
[ User: postgres - Total duration: 18s539ms - Times executed: 615 ]
[ User: postgres - Total duration: 15s672ms - Times executed: 734 ]
[ User: postgres - Total duration: 14s721ms - Times executed: 430 ]
[ User: postgres - Total duration: 13s762ms - Times executed: 1149 ]

Most frequent queries (N)


[ User: postgres - Total duration: 7s296ms - Times executed: 55173 ]
[ User: postgres - Total duration: 1s946ms - Times executed: 27094 ]
[ User: postgres - Total duration: 142ms - Times executed: 23662 ]
[ User: postgres - Total duration: 1s94ms - Times executed: 13923 ]
[ User: postgres - Total duration: 481ms - Times executed: 4599 ]
[ User: postgres - Total duration: 359ms - Times executed: 3543 ]
[ User: postgres - Total duration: 436ms - Times executed: 2339 ]
[ User: postgres - Total duration: 19ms - Times executed: 2242 ]
[ User: postgres - Total duration: 31ms - Times executed: 2230 ]
[ User: postgres - Total duration: 1m7s - Times executed: 2106 ]
[ User: postgres - Total duration: 176ms - Times executed: 2064 ]
[ User: postgres - Total duration: 11s695ms - Times executed: 1555 ]
[ User: postgres - Total duration: 1s434ms - Times executed: 1244 ]
[ User: postgres - Total duration: 1s470ms - Times executed: 1243 ]
[ User: postgres - Total duration: 13s762ms - Times executed: 1149 ]
[ User: postgres - Total duration: 4s946ms - Times executed: 1056 ]
[ User: postgres - Total duration: 2s502ms - Times executed: 1044 ]
[ User: postgres - Total duration: 2s285ms - Times executed: 1040 ]
[ User: postgres - Total duration: 2s364ms - Times executed: 1020 ]
[ User: postgres - Total duration: 3s243ms - Times executed: 832 ]

Normalized slowest queries (N)


[ User: postgres - Total duration: 26s840ms - Times executed: 1 ]
[ User: postgres - Total duration: 20s831ms - Times executed: 1 ]
[ User: postgres - Total duration: 3m36s - Times executed: 12 ]
[ User: postgres - Total duration: 2m33s - Times executed: 12 ]
[ User: postgres - Total duration: 17m17s - Times executed: 131 ]
[ User: postgres - Total duration: 8m38s - Times executed: 131 ]
[ User: postgres - Total duration: 14m44s - Times executed: 246 ]
[ User: postgres - Total duration: 5m55s - Times executed: 131 ]
[ User: postgres - Total duration: 7m6s - Times executed: 246 ]
[ User: postgres - Total duration: 45s769ms - Times executed: 31 ]
[ User: postgres - Total duration: 1m49s - Times executed: 132 ]
[ User: postgres - Total duration: 2m20s - Times executed: 203 ]
[ User: postgres - Total duration: 3m16s - Times executed: 309 ]
[ User: postgres - Total duration: 56s769ms - Times executed: 106 ]
[ User: postgres - Total duration: 1m2s - Times executed: 132 ]
[ User: postgres - Total duration: 14s721ms - Times executed: 430 ]
[ User: postgres - Total duration: 1m7s - Times executed: 2106 ]
[ User: postgres - Total duration: 18s539ms - Times executed: 615 ]
[ User: postgres - Total duration: 15s672ms - Times executed: 734 ]
[ User: postgres - Total duration: 13s762ms - Times executed: 1149 ]

Time consuming prepare


[ User: postgres - Total duration: 17m42s - Times executed: 683 ]
[ User: postgres - Total duration: 1s514ms - Times executed: 2508 ]
[ User: postgres - Total duration: 48ms - Times executed: 3621 ]
[ User: postgres - Total duration: 19ms - Times executed: 2242 ]
[ User: postgres - Total duration: 478ms - Times executed: 231 ]
[ User: postgres - Total duration: 1s386ms - Times executed: 659 ]
[ User: postgres - Total duration: 424ms - Times executed: 1702 ]
[ User: postgres - Total duration: 287ms - Times executed: 1297 ]
[ User: postgres - Total duration: 14ms - Times executed: 58 ]
[ User: postgres - Total duration: 19ms - Times executed: 69 ]
[ User: postgres - Total duration: 536ms - Times executed: 30 ]
[ User: postgres - Total duration: 388ms - Times executed: 60 ]
[ User: postgres - Total duration: 171ms - Times executed: 497 ]
[ User: postgres - Total duration: 22ms - Times executed: 44 ]
[ User: postgres - Total duration: 10ms - Times executed: 169 ]
[ User: postgres - Total duration: 809ms - Times executed: 65 ]
[ User: postgres - Total duration: 295ms - Times executed: 60 ]
[ User: postgres - Total duration: 292ms - Times executed: 28 ]
[ User: postgres - Total duration: 456ms - Times executed: 60 ]
[ User: postgres - Total duration: 14ms - Times executed: 30 ]

Time consuming bind


[ User: postgres - Total duration: 42m1s - Times executed: 1445 ]
[ User: postgres - Total duration: 20ms - Times executed: 71 ]
[ User: postgres - Total duration: 277ms - Times executed: 71 ]
[ User: postgres - Total duration: 393ms - Times executed: 75 ]
[ User: postgres - Total duration: 865ms - Times executed: 71 ]
[ User: postgres - Total duration: 6s898ms - Times executed: 75 ]
[ User: postgres - Total duration: 662ms - Times executed: 75 ]
[ User: postgres - Total duration: 1s884ms - Times executed: 3061 ]
[ User: postgres - Total duration: 2s23ms - Times executed: 72 ]
[ User: postgres - Total duration: 6s816ms - Times executed: 75 ]
[ User: postgres - Total duration: 10s111ms - Times executed: 71 ]
[ User: postgres - Total duration: 4s919ms - Times executed: 75 ]
[ User: postgres - Total duration: 1s305ms - Times executed: 75 ]
[ User: postgres - Total duration: 1s974ms - Times executed: 74 ]
[ User: postgres - Total duration: 14ms - Times executed: 60 ]
[ User: postgres - Total duration: 1s318ms - Times executed: 75 ]
[ User: postgres - Total duration: 2s92ms - Times executed: 71 ]
[ User: postgres - Total duration: 629ms - Times executed: 71 ]
[ User: postgres - Total duration: 1s332ms - Times executed: 75 ]
[ User: postgres - Total duration: 2s308ms - Times executed: 75 ]

Log levels

Key values

640,384 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	549	0.09%
DETAIL	228,485	35.68%
ERROR	17	0.00%
LOG	410,777	64.15%
STATEMENT	556	0.09%

Events distribution

Key values

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

Most Frequent Errors/Events

Key values

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

Rank

Times reported

Error

1

16

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
Jun 10	04	16

ERROR: Downloader symbol [USDCHF.rs] on classname [VALBURYFUTURES] already exists. Use the add_downloadersymboltobroker_retool function instead.
ERROR: Downloader symbol [USDJPY.rs] on classname [VALBURYFUTURES] already exists. Use the add_downloadersymboltobroker_retool function instead.
ERROR: Downloader symbol [AUDNZD.rs] on classname [VALBURYFUTURES] already exists. Use the add_downloadersymboltobroker_retool function instead.

2

1

Details

ERROR: relation "..." does not exist

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jun 10	04	1

ERROR: relation "timezones_vi_vn" does not exist at character 191

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