pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Tue Aug 5 04:59:56 2025
Log file: /home/postgres/pg_data/data/pg_log/postgresql-2025-08-05_060000.log
Parsed 2,127,336 log entries in 55s
Log start from 2025-08-05 06:00:00 to 2025-08-05 06:59:53

Global Stats

1,065 Number of unique normalized queries
124,408 Number of queries
3h58m4s Total query duration
2025-08-05 06:00:00 First query
2025-08-05 06:59:53 Last query
3,272 queries/s at 2025-08-05 06:05:02 Query peak

3h58m4s Total query duration
16s106ms Prepare/parse total duration
1m31s Bind total duration
3h56m16s Execute total duration

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

35 Total number of automatic vacuums
54 Total number of automatic analyzes

558 Number temporary file
152.29 MiB Max size of temporary file
7.61 MiB Average size of temporary file

5,814 Total number of sessions
13 sessions at 2025-08-05 06:56:15 Session peak
3d4m30s Total duration of sessions
44s628ms Average duration of sessions
21 Average queries per session
2s456ms Average queries duration per session
42s171ms Average idle time per session

5,814 Total number of connections
60 connections/s at 2025-08-05 06:31:21 Connection peak
5 Total number of databases

SQL Traffic

Key values

3,272 queries/s Query Peak
2025-08-05 06:05:02 Date

SELECT Traffic

Key values

2,986 queries/s Query Peak
2025-08-05 06:05:02 Date

INSERT/UPDATE/DELETE Traffic

Key values

218 queries/s Query Peak
2025-08-05 06:15:51 Date

Queries duration

Key values

3h58m4s 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)
Aug 05	06	124,408	0ms	14m30s	113ms	6m15s	7m	25m29s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Aug 05	06	72,712	600	36ms	1m15s	2m3s	3m49s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Aug 05	06	30,276	2,901	13	78	2ms	694ms	2s317ms	4s573ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Aug 05	06	35,163	91,861	2.61	30.87%

Day	Hour	Count	Average / Second
Aug 05	06	5,814	1.61/s

Day	Hour	Count	Average Duration	Average idle time
Aug 05	06	5,814	44s628ms	42s190ms

↑ Back to the top of the General Activity table

Established Connections

Key values

60 connections Connection Peak
2025-08-05 06:31:21 Date

Connections per database

Key values

acaweb_fx Main Database
5,814 connections Total

Chart
Table

Database	User	Count
acaweb_fx		5,717
	pg_dump	1
	postgres	5,369
	psql	347
acaweb_fx_integer		1
	pg_dump	1
postgres		3
	pg_dump	1
	psql	2
socialmedia		92
	pg_dump	1
	postgres	91
translations		1
	pg_dump	1

Connections per user

Key values

postgres Main User
5,814 connections Total

Chart
Table

User	Count
pg_dump	5
postgres	5,460
psql	349

Connections per host

Key values

192.168.1.15 Main host with 2916 connections
5,814 Total connections

Chart
Table

Host	Count
127.0.0.1	116
192.168.0.114	2
192.168.0.216	102
192.168.0.74	288
192.168.1.145	108
192.168.1.15	2,916
192.168.1.20	122
192.168.1.231	20
192.168.1.239	14
192.168.1.90	60
192.168.2.126	62
192.168.2.182	12
192.168.2.205	12
192.168.2.82	47
192.168.3.199	36
192.168.4.142	1,207
192.168.4.150	10
192.168.4.198	1
192.168.4.238	16
192.168.4.33	91
192.168.4.44	4
192.168.4.98	330
[local]	238

Simultaneous sessions

Key values

13 sessions Session Peak
2025-08-05 06:56:15 Date

Histogram of session times

Key values

5,088 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	5,088	87.51%
500ms-1s	186	3.20%
1s-30s	269	4.63%
30s-1m	122	2.10%
1m-10m	48	0.83%
10m-30m	80	1.38%
30m-1h	5	0.09%
1h-8h	16	0.28%
> 8h	0	0.00%

Sessions per database

Key values

acaweb_fx Main Database
5,814 sessions Total

Chart
Table

Database	User	Count	Total Duration
acaweb_fx	5,717	2d23h39m32s	45s123ms
acaweb_fx_integer	1	20m55s	20m55s
postgres	3	282ms	94ms
socialmedia	92	4m2s	2s632ms
translations	1	223ms	223ms

Sessions per user

Key values

postgres Main User
5,814 sessions Total

Chart
Table

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

Sessions per host

Key values

192.168.1.15 Main Host
5,814 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	116	36m22s	18s818ms
192.168.0.114	2	10m	5m
192.168.0.216	102	2m3s	1s214ms
192.168.0.74	288	5h58m16s	1m14s
192.168.1.145	108	8h23m59s	4m39s
192.168.1.15	2,916	9h14m41s	11s413ms
192.168.1.20	122	17h10m34s	8m26s
192.168.1.231	20	9h53m21s	29m40s
192.168.1.239	14	106ms	7ms
192.168.1.90	60	54s938ms	915ms
192.168.2.126	62	6s274ms	101ms
192.168.2.182	12	3s713ms	309ms
192.168.2.205	12	523ms	43ms
192.168.2.82	47	5s967ms	126ms
192.168.3.199	36	1s336ms	37ms
192.168.4.142	1,207	8m19s	414ms
192.168.4.150	10	20h5s	2h
192.168.4.198	1	292ms	292ms
192.168.4.238	16	28s729ms	1s795ms
192.168.4.33	91	3m22s	2s226ms
192.168.4.44	4	41ms	10ms
192.168.4.98	330	30s	90ms
[local]	238	21m11s	5s342ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
5,814 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	4,699	2d22h49m46s	54s264ms
[unknown]	761	17m9s	1s352ms
pg_dump	5	36m15s	7m15s
psql	349	21m18s	3s663ms

Checkpoints Buffers

Key values

15,227 buffers Checkpoint Peak
2025-08-05 06:07:29 Date
209.953 seconds Highest write time
0.025 seconds Sync time

Checkpoints Wal files

Key values

7 files Wal files usage Peak
2025-08-05 06:07:29 Date

Checkpoints distance

Key values

215.83 Mo Distance Peak
2025-08-05 06:07:29 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Aug 05	06	38,577	1,676.605s	0.067s	1,676.96s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Aug 05	06	0	0	22	1,893	0.006s	0s

Day	Hour	Count	Avg time (sec)
Aug 05	06	0	0s

Day	Hour	Mean distance	Mean estimate
Aug 05	06	33,657.55 kB	78,492.09 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

169.01 MiB Temp Files size Peak
2025-08-05 06:30:12 Date

Number of temporary files

Key values

30 per second Temp Files Peak
2025-08-05 06:17:20 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Aug 05	06	558	4.15 GiB	7.61 MiB

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)


Date: 2025-08-05 06:00:43
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.0.74
Application: PostgreSQL JDBC Driver
Date: 2025-08-05 06:40:13
Duration: 10s712ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.90
Application: [unknown]
Date: 2025-08-05 06:31:17
Duration: 4s963ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-08-05 06:26:22
Duration: 5s646ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-08-05 06:32:40
Duration: 7s14ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-08-05 06:32:33
Duration: 30s879ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-08-05 06:15:02
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.0.74
Application: PostgreSQL JDBC Driver

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	146	644.24 MiB	3.03 MiB	8.47 MiB	4.41 MiB	with rar_max as ( ; WITH rar_max as ( ; Date: 2025-08-05 06:00:43 Duration: 0ms Database: acaweb_fx User: postgres Remote: 192.168.0.74 Application: PostgreSQL JDBC Driver
2	40	1.66 GiB	7.33 MiB	152.29 MiB	42.49 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = ? ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = ? ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = ?) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, ?::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> ? ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = ?) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = ? where (ok.r is null or ok.r = ?) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = ?) and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > ? ? and last.eventtimestamp > current_timestamp - interval ? and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval ?) and last.eventtimestamp > current_timestamp - interval ? and broker.r = ?; with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; Date: 2025-08-05 06:40:13 Duration: 10s712ms Database: acaweb_fx User: postgres Remote: 192.168.1.90 Application: [unknown] with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; Date: 2025-08-05 06:30:12 Duration: 9s608ms Database: acaweb_fx User: postgres Remote: 192.168.1.90 Application: [unknown] with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; Date: 2025-08-05 06:20:10 Duration: 8s425ms Database: acaweb_fx User: postgres Remote: 192.168.1.90 Application: [unknown]
3	13	396.91 MiB	30.53 MiB	30.53 MiB	30.53 MiB	update solr_relevance_old set new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total from ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total from whatshot_probability where type = ?) sub where result_uid = sub.resultuid; UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type = 'cp') sub WHERE result_uid = sub.resultuid; Date: 2025-08-05 06:31:17 Duration: 4s963ms Database: acaweb_fx User: postgres Remote: [local] Application: psql UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type = 'cp') sub WHERE result_uid = sub.resultuid; Date: 2025-08-05 06:41:16 Duration: 4s466ms Database: acaweb_fx User: postgres Remote: [local] Application: psql UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type = 'cp') sub WHERE result_uid = sub.resultuid; Date: 2025-08-05 06:26:16 Duration: 4s386ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
4	13	712.24 MiB	54.78 MiB	54.79 MiB	54.79 MiB	with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit ?) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then ? else ? end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then ? else ? end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike ? inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike ?) sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike ?; update solr_relevance_old set newrelevant = ? where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike ? and a.resultuid is null); update solr_relevance_old set new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total from ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total from whatshot_probability where type in (...)) sub where result_uid = sub.resultuid; with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid; Date: 2025-08-05 06:26:22 Duration: 5s646ms Database: acaweb_fx User: postgres Remote: [local] Application: psql with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid; Date: 2025-08-05 06:31:23 Duration: 5s498ms Database: acaweb_fx User: postgres Remote: [local] Application: psql with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid; Date: 2025-08-05 06:41:20 Duration: 4s137ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
5	8	459.61 MiB	57.45 MiB	57.46 MiB	57.45 MiB	select updateresultsmaterializedview (); select updateresultsmaterializedview (); Date: 2025-08-05 06:32:40 Duration: 7s14ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateresultsmaterializedview (); Date: 2025-08-05 06:47:36 Duration: 6s78ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateresultsmaterializedview (); Date: 2025-08-05 06:17:31 Duration: 5s820ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
6	4	325.26 MiB	81.24 MiB	81.41 MiB	81.31 MiB	select updateageforrelevantresults (); select updateageforrelevantresults (); Date: 2025-08-05 06:32:33 Duration: 30s879ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateageforrelevantresults (); Date: 2025-08-05 06:47:30 Duration: 28s736ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateageforrelevantresults (); Date: 2025-08-05 06:17:25 Duration: 22s854ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
7	1	8.47 MiB	8.47 MiB	8.47 MiB	8.47 MiB	jr.resultuid as resultuid, jr.direction as direction, jr.patternendtime as identified, jr.patternlengthbars as length, jr.patternstarttime as patternstarttime, case when jr.trendchangeid = ? then ? else ? end as trendchange, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, jp.patternname as pattern_name, dtt.timezone as timezone, ? as age, cps.pip, g.basegroupname from japsticks_results jr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = jr.symbolid inner join relevance_japsticks_results rar on rar.resultuid = jr.resultuid inner join symbols s on jr.symbolid = s.symbolid and s.nonliquid = ? inner join japsticks_patterns jp on jr.patternid = jp.id inner join downloadersymbolsettings dss on jr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on s.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where jr.gmttimefound > now() - interval ? and s.deleted = ? and (jr.simulation = ? or jr.simulation is null) and (rar.relevant = ?) --and (semicolon_age = ? or rar.age <= semicolon_age) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or jp.patternname in (...)) and (? = ? or jr.patternlengthbars <= ?) ), results as ( select distinct on (symbolid) * from all_results order by symbolid, resultuid ) select * from results order by identified desc, length desc ; jr.resultuid AS resultuid, jr.direction AS direction, jr.patternendtime AS identified, jr.patternlengthbars AS length, jr.patternstarttime AS patternstarttime, case when jr.trendchangeid = 1 then 'Continuation' else 'Reversal' end AS trendchange, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; Date: 2025-08-05 06:15:02 Duration: 0ms Database: acaweb_fx User: postgres Remote: 192.168.0.74 Application: PostgreSQL JDBC Driver

Queries generating the largest temporary files


[ Date: 2025-08-05 06:30:09 ]
[ Date: 2025-08-05 06:40:09 ]
[ Date: 2025-08-05 06:00:09 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
[ Date: 2025-08-05 06:50:07 ]
[ Date: 2025-08-05 06:10:06 ]
[ Date: 2025-08-05 06:20:07 ]
[ Date: 2025-08-05 06:50:08 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
[ Date: 2025-08-05 06:20:06 ]
[ Date: 2025-08-05 06:02:04 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-05 06:32:23 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-05 06:47:21 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-05 06:17:12 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-05 06:10:07 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
[ Date: 2025-08-05 06:30:08 ]
[ Date: 2025-08-05 06:02:14 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-05 06:47:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-05 06:32:36 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-05 06:17:27 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-05 06:50:34 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-05 06:05:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

Rank	Size	Query
1	152.29 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2025-08-05 06:30:09 ]
2	144.96 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2025-08-05 06:40:09 ]
3	127.03 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2025-08-05 06:00:09 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
4	95.55 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2025-08-05 06:50:07 ]
5	92.78 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2025-08-05 06:10:06 ]
6	92.34 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2025-08-05 06:20:07 ]
7	88.20 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2025-08-05 06:50:08 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
8	88.19 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2025-08-05 06:20:06 ]
9	81.41 MiB	select updateageforrelevantresults (); [ Date: 2025-08-05 06:02:04 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
10	81.33 MiB	select updateageforrelevantresults (); [ Date: 2025-08-05 06:32:23 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
11	81.27 MiB	select updateageforrelevantresults (); [ Date: 2025-08-05 06:47:21 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
12	81.24 MiB	select updateageforrelevantresults (); [ Date: 2025-08-05 06:17:12 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
13	77.70 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2025-08-05 06:10:07 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
14	66.39 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2025-08-05 06:30:08 ]
15	57.46 MiB	select updateresultsmaterializedview (); [ Date: 2025-08-05 06:02:14 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
16	57.46 MiB	select updateresultsmaterializedview (); [ Date: 2025-08-05 06:47:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
17	57.45 MiB	select updateresultsmaterializedview (); [ Date: 2025-08-05 06:32:36 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
18	57.45 MiB	select updateresultsmaterializedview (); [ Date: 2025-08-05 06:17:27 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
19	57.45 MiB	select updateresultsmaterializedview (); [ Date: 2025-08-05 06:50:34 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
20	57.45 MiB	select updateresultsmaterializedview (); [ Date: 2025-08-05 06:05:33 - Database: acaweb_fx - User: postgres - Remote: [local] - 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.solr_relevance_old (13) Main table analyzed (database acaweb_fx)
54 analyzes Total

Chart
Table

Table	Number of analyzes
acaweb_fx.public.solr_relevance_old	13
acaweb_fx.pg_catalog.pg_attribute	6
acaweb_fx.public.datafeeds_latestrun	5
acaweb_fx.pg_catalog.pg_type	4
acaweb_fx.public.relevance_keylevels_results	4
acaweb_fx.pg_catalog.pg_class	4
acaweb_fx.public.relevance_autochartist_results	4
acaweb_fx.public.relevance_fibonacci_results	4
acaweb_fx.public.latest_t15_candle_view	3
acaweb_fx.pg_catalog.pg_index	2
acaweb_fx.public.autochartist_symbolupdates	1
acaweb_fx.public.t60	1
socialmedia.public.processes	1
acaweb_fx.pg_catalog.pg_depend	1
acaweb_fx.public.latest_candle_datetime_per_receng	1
Total	54

Vacuums per table

Key values

public.solr_relevance_old (13) Main table vacuumed on database acaweb_fx
35 vacuums Total

Chart
Table

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
acaweb_fx.public.solr_relevance_old	13	13	10,110	0	50	0	0	7,667	815	3,916,923
acaweb_fx.public.datafeeds_latestrun	5	0	535	0	22	0	0	60	37	66,348
acaweb_fx.pg_toast.pg_toast_2619	2	2	310	0	56	0	0	175	63	267,012
acaweb_fx.pg_catalog.pg_attribute	2	2	1,448	0	316	0	134	686	255	1,573,902
acaweb_fx.public.relevance_keylevels_results	2	2	8,076	0	326	4	152	2,349	277	850,921
acaweb_fx.public.relevance_autochartist_results	2	2	6,933	0	188	2	486	1,444	173	417,001
acaweb_fx.pg_catalog.pg_class	2	2	707	0	80	0	80	244	75	331,835
acaweb_fx.public.relevance_fibonacci_results	2	2	2,584	0	88	1	108	501	56	146,951
acaweb_fx.pg_catalog.pg_index	1	1	95	0	15	0	0	33	12	84,851
acaweb_fx.pg_catalog.pg_type	1	1	121	0	18	0	0	52	16	99,375
acaweb_fx.public.autochartist_symbolupdates	1	1	26,037	0	678	5	37,302	6,771	620	618,546
acaweb_fx.pg_catalog.pg_statistic	1	1	839	0	164	0	677	519	155	665,441
acaweb_fx.public.latest_t15_candle_view	1	1	78	0	1	0	0	6	1	9,061
Total	35	30	57,873	45,149	2,002	12	38,939	20,507	2,555	9,048,167

Tuples removed per table

Key values

public.solr_relevance_old (66871) Main table with removed tuples on database acaweb_fx
82924 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
acaweb_fx.public.solr_relevance_old	13	13	66,871	66,722	0	0	2,442
acaweb_fx.public.autochartist_symbolupdates	1	1	5,840	48,112	1,093	0	40,691
acaweb_fx.public.relevance_keylevels_results	2	2	3,773	25,004	0	0	558
acaweb_fx.pg_catalog.pg_attribute	2	2	2,379	19,991	1,245	0	500
acaweb_fx.public.relevance_autochartist_results	2	2	1,608	15,798	0	0	760
acaweb_fx.pg_catalog.pg_statistic	1	1	805	4,360	0	0	1,194
acaweb_fx.public.relevance_fibonacci_results	2	2	523	2,914	0	0	204
acaweb_fx.pg_catalog.pg_class	2	2	498	4,039	145	0	300
acaweb_fx.public.datafeeds_latestrun	5	0	213	167	97	0	80
acaweb_fx.pg_catalog.pg_type	1	1	184	1,341	3	0	38
acaweb_fx.pg_toast.pg_toast_2619	2	2	115	389	47	0	104
acaweb_fx.public.latest_t15_candle_view	1	1	64	14	0	0	1
acaweb_fx.pg_catalog.pg_index	1	1	51	813	0	1	22
Total	35	30	82,924	189,664	2,630	1	46,894

Pages removed per table

Key values

pg_catalog.pg_index (1) Main table with removed pages on database acaweb_fx
1 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
acaweb_fx.pg_catalog.pg_index	1	1	51	1
acaweb_fx.pg_toast.pg_toast_2619	2	2	115	0
acaweb_fx.pg_catalog.pg_type	1	1	184	0
acaweb_fx.public.datafeeds_latestrun	5	0	213	0
acaweb_fx.public.autochartist_symbolupdates	1	1	5840	0
acaweb_fx.pg_catalog.pg_statistic	1	1	805	0
acaweb_fx.pg_catalog.pg_attribute	2	2	2379	0
acaweb_fx.public.latest_t15_candle_view	1	1	64	0
acaweb_fx.public.relevance_keylevels_results	2	2	3773	0
acaweb_fx.public.solr_relevance_old	13	13	66871	0
acaweb_fx.public.relevance_autochartist_results	2	2	1608	0
acaweb_fx.pg_catalog.pg_class	2	2	498	0
acaweb_fx.public.relevance_fibonacci_results	2	2	523	0
Total	35	30	82,924	1

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Aug 05	06	35	54

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

AccessShareLock Main Lock Type
5 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
AccessExclusiveLock		2	17m10s	8m35s
	relation	2	17m10s	8m35s
AccessShareLock		3	4m16s	1m25s
	relation	3	4m16s	1m25s
	Total	5	21m26s	4m17s

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	1	14m30s	14m30s	14m30s	14m30s	truncate table solr_relevance_old; TRUNCATE TABLE solr_relevance_old; Date: 2025-08-05 06:19:42 Database: acaweb_fx User: postgres Remote: [local] Application: psql TRUNCATE TABLE solr_relevance_old; Date: 2025-08-05 06:56:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql TRUNCATE TABLE solr_relevance_old; Date: 2025-08-05 06:26:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql
2	3	4m16s	28s282ms	2m39s	1m25s	select datetimeupdate from latest_candle_datetime_per_receng where recognitionengine ilike ?; SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 3'; Date: 2025-08-05 06:19:42 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: [unknown] SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 1'; Date: 2025-08-05 06:19:42 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: [unknown] SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 4'; Date: 2025-08-05 06:19:42 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: [unknown]
3	1	2m40s	2m40s	2m40s	2m40s	refresh materialized view latest_candle_datetime_per_receng; refresh materialized view latest_candle_datetime_per_receng; Date: 2025-08-05 06:19:42 Database: acaweb_fx User: postgres Remote: [local] Application: psql refresh materialized view latest_candle_datetime_per_receng; Date: 2025-08-05 06:32:02 Database: acaweb_fx User: postgres Remote: [local] Application: psql refresh materialized view latest_candle_datetime_per_receng; Date: 2025-08-05 06:47:01 Database: acaweb_fx User: postgres Remote: [local] Application: psql

Rank

Count

Total time

Min time

Max time

Avg duration

Query

1

14m30s

truncate table solr_relevance_old;

TRUNCATE TABLE solr_relevance_old;

Date: 2025-08-05 06:19:42 Database: acaweb_fx User: postgres Remote: [local] Application: psql
TRUNCATE TABLE solr_relevance_old;

Date: 2025-08-05 06:56:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql
TRUNCATE TABLE solr_relevance_old;

Date: 2025-08-05 06:26:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql

2

3

4m16s

28s282ms

2m39s

1m25s

select datetimeupdate from latest_candle_datetime_per_receng where recognitionengine ilike ?;

SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 3';

Date: 2025-08-05 06:19:42 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: [unknown]
SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 1';

Date: 2025-08-05 06:19:42 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: [unknown]
SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 4';

Date: 2025-08-05 06:19:42 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: [unknown]

3

1

2m40s

refresh materialized view latest_candle_datetime_per_receng;

refresh materialized view latest_candle_datetime_per_receng;

Date: 2025-08-05 06:19:42 Database: acaweb_fx User: postgres Remote: [local] Application: psql
refresh materialized view latest_candle_datetime_per_receng;

Date: 2025-08-05 06:32:02 Database: acaweb_fx User: postgres Remote: [local] Application: psql
refresh materialized view latest_candle_datetime_per_receng;

Date: 2025-08-05 06:47:01 Database: acaweb_fx User: postgres Remote: [local] Application: psql

Queries that waited the most


[ Date: 2025-08-05 06:19:41 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-05 06:19:41 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-05 06:19:42 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2025-08-05 06:19:42 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2025-08-05 06:19:42 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]

Rank	Wait time	Query
1	14m30s	TRUNCATE TABLE solr_relevance_old; [ Date: 2025-08-05 06:19:41 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	2m40s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2025-08-05 06:19:41 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
3	2m39s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 3'; [ Date: 2025-08-05 06:19:42 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
4	1m7s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 1'; [ Date: 2025-08-05 06:19:42 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
5	28s282ms	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 4'; [ Date: 2025-08-05 06:19:42 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]

Queries by type

Key values

72,712 Total read queries
41,193 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	72,712	58.45%
INSERT	30,276	24.34%
UPDATE	2,901	2.33%
DELETE	13	0.01%
COPY FROM	78	0.06%
COPY TO	600	0.48%
CTE	6,643	5.34%
DDL	13	0.01%
TCL	669	0.54%
CURSOR	0	0.00%
OTHERS	10,503	8.44%

Queries by database

Key values

acaweb_fx Main database
112,247 Requests
3h34m47s (acaweb_fx)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
acaweb_fx	Total	112,247	3h34m47s
	copy from	78	4s247ms
	copy to	305	14m32s
	cte	6,639	2h52m17s
	ddl	13	14m30s
	delete	13	20ms
	insert	22,843	33s931ms
	others	10,172	3m7s
	select	68,684	9m8s
	tcl	665	191ms
	update	2,835	32s482ms
acaweb_fx_integer	Total	3,589	20m40s
	copy to	276	20m38s
	cte	1	5ms
	others	285	22ms
	select	3,026	1s213ms
	tcl	1	0ms
postgres	Total	367	245ms
	cte	1	1ms
	others	9	0ms
	select	356	243ms
	tcl	1	0ms
socialmedia	Total	8,158	48s473ms
	copy to	19	39s60ms
	cte	1	1ms
	insert	7,433	8s770ms
	others	28	0ms
	select	610	525ms
	tcl	1	0ms
	update	66	113ms
translations	Total	47	211ms
	cte	1	2ms
	others	9	0ms
	select	36	209ms
	tcl	1	0ms

Queries by user

Key values

postgres Main user
124,408 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	124,408	3h56m16s
	copy from	78	4s247ms
	copy to	600	35m50s
	cte	6,643	2h52m17s
	ddl	13	14m30s
	delete	13	20ms
	insert	30,276	42s702ms
	others	10,503	3m7s
	select	72,712	9m10s
	tcl	669	191ms
	update	2,901	32s596ms

Duration by user

Key values

3h56m16s (postgres) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	124,408	3h56m16s
	copy from	78	4s247ms
	copy to	600	35m50s
	cte	6,643	2h52m17s
	ddl	13	14m30s
	delete	13	20ms
	insert	30,276	42s702ms
	others	10,503	3m7s
	select	72,712	9m10s
	tcl	669	191ms
	update	2,901	32s596ms

Queries by host

Key values

192.168.1.15 Main host
25,494 Requests
43m38s (192.168.0.74)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	21,486	40m47s
	copy to	600	35m50s
	cte	25	256ms
	insert	10,170	15s376ms
	others	619	27ms
	select	7,779	4m38s
	tcl	5	0ms
	update	2,288	2s16ms
182.165.1.42	Total	186	8m28s
	cte	60	8m28s
	select	126	179ms
192.168.0.114	Total	10	146ms
	others	2	0ms
	select	4	145ms
	tcl	4	0ms
192.168.0.216	Total	408	392ms
	others	204	26ms
	select	196	231ms
	update	8	134ms
192.168.0.236	Total	22	9ms
	cte	3	4ms
	select	19	5ms
192.168.0.239	Total	383	4s596ms
	select	383	4s596ms
192.168.0.42	Total	1,063	6s221ms
	insert	307	43ms
	select	756	6s178ms
192.168.0.74	Total	5,781	43m38s
	cte	1,058	43m32s
	others	576	9ms
	select	4,147	6s95ms
192.168.1.135	Total	114	310ms
	cte	5	159ms
	select	109	151ms
192.168.1.145	Total	20,180	38m4s
	cte	964	37m39s
	others	216	2ms
	select	19,000	24s709ms
192.168.1.15	Total	25,494	43m27s
	cte	3,464	43m12s
	others	5,832	87ms
	select	16,198	15s121ms
192.168.1.20	Total	20,507	37m50s
	cte	953	37m24s
	others	244	3ms
	select	19,310	25s826ms
192.168.1.201	Total	1,341	9s724ms
	select	1,341	9s724ms
192.168.1.210	Total	88	22ms
	select	88	22ms
192.168.1.23	Total	1,276	9s855ms
	select	1,276	9s855ms
192.168.1.231	Total	40	0ms
	others	40	0ms
192.168.1.239	Total	56	39ms
	others	28	2ms
	select	28	36ms
192.168.1.49	Total	58	22ms
	cte	7	3ms
	select	51	19ms
192.168.1.90	Total	97	52s753ms
	cte	6	52s655ms
	others	23	0ms
	select	67	97ms
	update	1	0ms
192.168.1.97	Total	32	33ms
	cte	3	2ms
	select	29	31ms
192.168.2.126	Total	80	87ms
	others	18	0ms
	select	62	86ms
192.168.2.182	Total	48	366ms
	others	24	2ms
	select	12	13ms
	update	12	350ms
192.168.2.205	Total	138	128ms
	insert	90	16ms
	others	24	2ms
	select	20	20ms
	update	4	88ms
192.168.2.82	Total	1,196	3s773ms
	insert	778	2s804ms
	others	94	10ms
	select	192	115ms
	update	132	842ms
192.168.3.199	Total	144	268ms
	others	72	8ms
	select	60	70ms
	update	12	190ms
192.168.4.142	Total	14,942	16s817ms
	insert	11,498	15s690ms
	others	2,414	34ms
	select	1,030	1s92ms
192.168.4.150	Total	22	2s545ms
	others	21	0ms
	select	1	2s545ms
192.168.4.198	Total	3	145ms
	cte	1	145ms
	others	2	0ms
192.168.4.238	Total	48	27s454ms
	cte	16	27s454ms
	others	32	0ms
192.168.4.33	Total	7,867	9s161ms
	insert	7,433	8s770ms
	select	368	276ms
	update	66	113ms
192.168.4.44	Total	12	1ms
	others	8	0ms
	select	4	1ms
192.168.4.98	Total	996	25s450ms
	others	6	24s516ms
	select	6	41ms
	tcl	660	190ms
	update	324	700ms
[local]	Total	290	21m10s
	copy from	78	4s247ms
	cte	78	40s601ms
	ddl	13	14m30s
	delete	13	20ms
	others	4	2m42s
	select	50	2m44s
	update	54	28s159ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
86,630 Requests
2h44m18s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	86,630	2h44m18s
	cte	6,461	2h42m16s
	insert	11,805	15s733ms
	others	4,700	87ms
	select	63,664	1m45s
[unknown]	Total	29,179	14m54s
	cte	79	9m20s
	insert	18,471	26s968ms
	others	5,180	24s621ms
	select	1,949	4m37s
	tcl	664	191ms
	update	2,836	4s410ms
pg_dump	Total	8,198	35m47s
	copy to	574	35m44s
	cte	5	15ms
	others	619	27ms
	select	6,995	2s773ms
	tcl	5	0ms
psql	Total	401	21m17s
	copy from	78	4s247ms
	copy to	26	5s995ms
	cte	98	40s842ms
	ddl	13	14m30s
	delete	13	20ms
	others	4	2m42s
	select	104	2m44s
	update	65	28s185ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-08-05 06:31:48 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

73,454 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	73,454	59.04%
1-5ms	44,062	35.42%
5-10ms	2,648	2.13%
10-25ms	1,222	0.98%
25-50ms	406	0.33%
50-100ms	303	0.24%
100-500ms	628	0.50%
500-1000ms	198	0.16%
1000-10000ms	1,103	0.89%
> 10000ms	384	0.31%

Slowest individual queries


[ Date: 2025-08-05 06:19:42 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-05 06:08:20 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-05 06:33:30 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-05 06:14:29 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-05 06:19:42 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-05 06:19:42 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2025-08-05 06:22:02 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-05 06:37:56 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-05 06:25:05 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-05 06:29:04 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-05 06:11:33 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-05 06:23:23 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-05 06:15:44 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-05 06:26:41 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-05 06:30:13 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-05 06:27:01 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-08-05 06:19:42 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2025-08-05 06:27:04 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-08-05 06:18:08 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-05 06:39:39 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]

Rank	Duration	Query
1	14m30s	TRUNCATE TABLE solr_relevance_old; [ Date: 2025-08-05 06:19:42 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	3m17s	COPY archive.stats_success (resultuid, atbaridentified, type, minprice, maxprice, correct, symbol, "interval", pattern, direction, hourofday, quality, breakout, clarity, initialtrend, volumeincrease, symmetry, qtytp, trendchange, patternlengthbars, symbolid) TO stdout; [ Date: 2025-08-05 06:08:20 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
3	3m13s	COPY public.researchreports (researchreportid, type, createddatetime, language, filename, xml) TO stdout; [ Date: 2025-08-05 06:33:30 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
4	2m51s	COPY public.researchreports (researchreportid, type, createddatetime, language, filename, xml) TO stdout; [ Date: 2025-08-05 06:14:29 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
5	2m41s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2025-08-05 06:19:42 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
6	2m39s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 3'; [ Date: 2025-08-05 06:19:42 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
7	2m19s	COPY archive.stats_success (resultuid, atbaridentified, type, minprice, maxprice, correct, symbol, "interval", pattern, direction, hourofday, quality, breakout, clarity, initialtrend, volumeincrease, symmetry, qtytp, trendchange, patternlengthbars, symbolid) TO stdout; [ Date: 2025-08-05 06:22:02 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
8	1m52s	COPY public.t15_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2025-08-05 06:37:56 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
9	1m41s	COPY public.autochartist_results (resultid, bandwidth, pattern, gmttimefound, direction, initialtrend, breakout, volumeincrease, noise, symmetry, patternstarttime, patternendtime, patternstartprice, patternendprice, resx0, resx1, supportx0, supportx1, resy0, resy1, supporty0, supporty1, supportgradient, resgradient, riskreward, qtytp, predictionpricefrom, predictionpriceto, predictiontimefrom, predictiontimeto, patternquality, trendchange, maxmovementafterbreakout, latestbaratbreakouttime, latestbaratbreakoutprice, patternlengthbars, temporarypattern, symbolid, resultuid, relevancestartdistance, simulation, writtendatetime, old_resultuid) TO stdout; [ Date: 2025-08-05 06:25:05 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
10	1m15s	COPY public.powerstats_trumpet (symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) TO stdout; [ Date: 2025-08-05 06:29:04 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
11	1m15s	COPY public.powerstats_trumpet_test (symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) TO stdout; [ Date: 2025-08-05 06:11:33 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
12	1m13s	COPY public.authenticationlog (attemptid, username, password, brokerid, authclass, attemptdatetime, success, fingerprint, accounttype) TO stdout; [ Date: 2025-08-05 06:23:23 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
13	1m11s	COPY public.stats_success (resultuid, atbaridentified, type, minprice, maxprice, correct, symbol, "interval", pattern, direction, hourofday, quality, breakout, clarity, initialtrend, volumeincrease, symmetry, qtytp, trendchange, patternlengthbars, symbolid) TO stdout; [ Date: 2025-08-05 06:15:44 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
14	1m11s	COPY public.keylevels_results (bandwidth, patternid, gmttimefound, approachingtimestamp, isrelevant, qtytp, patternlengthbars, symbolid, resultuid, patternprice, breakout, x0, x1, x2, x3, x4, x5, x6, x7, x8, x9, breakoutbars, breakoutprice, atbaridentified, atpriceidentified, approachingregion, errormargin, direction, predictionpricefrom, predictionpriceto, predictiontimefrom, predictiontimebars, uniquepointsvalue, furthestprice, patternendtime, relevancestartdistance, simulation, patternclassid, patternstarttime, stoplosslevel, writtendatetime, old_resultuid) TO stdout; [ Date: 2025-08-05 06:26:41 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
15	1m8s	COPY public.powerstats_trumpet_test (symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) TO stdout; [ Date: 2025-08-05 06:30:13 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
16	1m8s	WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a., rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR coalesce(bim.code, s.symbol) in ('')) AND ('0' = 0 OR p.patternname in ('')) AND ('0' = 0 OR kr.patternclassid in ('0')) AND ('0' = 0 OR kr.patternlengthbars <= '0') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200; [ Date: 2025-08-05 06:27:01 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17	1m7s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 1'; [ Date: 2025-08-05 06:19:42 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
18	1m7s	WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a., rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR coalesce(bim.code, s.symbol) in ('')) AND ('0' = 0 OR p.patternname in ('')) AND ('0' = 0 OR kr.patternclassid in ('0')) AND ('0' = 0 OR kr.patternlengthbars <= '0') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200; [ Date: 2025-08-05 06:27:04 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19	1m4s	COPY public.t15_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2025-08-05 06:18:08 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
20	1m3s	COPY public.t30_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2025-08-05 06:39:39 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]

Time consuming queries


[ User: postgres - Total duration: 1h11m56s - Times executed: 494 ]
[ User: postgres - Total duration: 1h11m45s - Times executed: 495 ]
[ User: postgres - Total duration: 22m28s - Times executed: 453 ]
[ User: postgres - Total duration: 14m30s - Times executed: 13 ]
[ User: postgres - Total duration: 6m5s - Times executed: 2 ]
[ User: postgres - Total duration: 5m36s - Times executed: 2 ]
[ User: postgres - Total duration: 4m16s - Times executed: 261 ]
[ User: postgres - Total duration: 2m56s - Times executed: 2 ]
[ User: postgres - Total duration: 2m42s - Times executed: 4 ]
[ User: postgres - Total duration: 2m25s - Times executed: 305 ]
[ User: postgres - Total duration: 2m24s - Times executed: 2 ]
[ User: postgres - Total duration: 2m5s - Times executed: 2 ]
[ User: postgres - Total duration: 1m56s - Times executed: 2 ]
[ User: postgres - Total duration: 1m50s - Times executed: 2 ]
[ User: postgres - Total duration: 1m47s - Times executed: 2 ]
[ User: postgres - Total duration: 1m34s - Times executed: 4 ]
[ User: postgres - Total duration: 1m32s - Times executed: 2 ]
[ User: postgres - Total duration: 1m24s - Times executed: 150 ]
[ User: postgres - Total duration: 1m17s - Times executed: 2 ]
[ User: postgres - Total duration: 1m11s - Times executed: 1 ]

Most frequent queries (N)


[ User: postgres - Total duration: 167ms - Times executed: 29119 ]
[ User: postgres - Total duration: 30s468ms - Times executed: 18938 ]
[ User: postgres - Total duration: 28s462ms - Times executed: 11283 ]
[ User: postgres - Total duration: 8s340ms - Times executed: 7142 ]
[ User: postgres - Total duration: 11s173ms - Times executed: 5865 ]
[ User: postgres - Total duration: 7s476ms - Times executed: 5510 ]
[ User: postgres - Total duration: 50ms - Times executed: 4726 ]
[ User: postgres - Total duration: 87ms - Times executed: 4699 ]
[ User: postgres - Total duration: 3s337ms - Times executed: 3379 ]
[ User: postgres - Total duration: 1s887ms - Times executed: 2676 ]
[ User: postgres - Total duration: 7s613ms - Times executed: 2575 ]
[ User: postgres - Total duration: 1s990ms - Times executed: 2277 ]
[ User: postgres - Total duration: 1s71ms - Times executed: 2193 ]
[ User: postgres - Total duration: 5s868ms - Times executed: 1942 ]
[ User: postgres - Total duration: 30ms - Times executed: 1642 ]
[ User: postgres - Total duration: 2s51ms - Times executed: 1460 ]
[ User: postgres - Total duration: 134ms - Times executed: 921 ]
[ User: postgres - Total duration: 227ms - Times executed: 730 ]
[ User: postgres - Total duration: 93ms - Times executed: 645 ]
[ User: postgres - Total duration: 44ms - Times executed: 574 ]

Normalized slowest queries (N)


[ User: postgres - Total duration: 6m5s - Times executed: 2 ]
[ User: postgres - Total duration: 5m36s - Times executed: 2 ]
[ User: postgres - Total duration: 2m56s - Times executed: 2 ]
[ User: postgres - Total duration: 2m24s - Times executed: 2 ]
[ User: postgres - Total duration: 1m11s - Times executed: 1 ]
[ User: postgres - Total duration: 14m30s - Times executed: 13 ]
[ User: postgres - Total duration: 2m5s - Times executed: 2 ]
[ User: postgres - Total duration: 1m56s - Times executed: 2 ]
[ User: postgres - Total duration: 1m50s - Times executed: 2 ]
[ User: postgres - Total duration: 1m47s - Times executed: 2 ]
[ User: postgres - Total duration: 1m32s - Times executed: 2 ]
[ User: postgres - Total duration: 2m42s - Times executed: 4 ]
[ User: postgres - Total duration: 1m17s - Times executed: 2 ]
[ User: postgres - Total duration: 1m34s - Times executed: 4 ]
[ User: postgres - Total duration: 1h11m56s - Times executed: 494 ]
[ User: postgres - Total duration: 1h11m45s - Times executed: 495 ]
[ User: postgres - Total duration: 22m28s - Times executed: 453 ]
[ User: postgres - Total duration: 4m16s - Times executed: 261 ]
[ User: postgres - Total duration: 1m24s - Times executed: 150 ]
[ User: postgres - Total duration: 2m25s - Times executed: 305 ]

Time consuming prepare


[ User: postgres - Total duration: 2h17m57s - Times executed: 5226 ]
[ User: postgres - Total duration: 20s104ms - Times executed: 7083 ]
[ User: postgres - Total duration: 50ms - Times executed: 4726 ]
[ User: postgres - Total duration: 961ms - Times executed: 504 ]
[ User: postgres - Total duration: 4s715ms - Times executed: 1080 ]
[ User: postgres - Total duration: 56ms - Times executed: 6859 ]
[ User: postgres - Total duration: 2s860ms - Times executed: 2788 ]
[ User: postgres - Total duration: 970ms - Times executed: 1753 ]
[ User: postgres - Total duration: 27s454ms - Times executed: 16 ]
[ User: postgres - Total duration: 26s - Times executed: 47 ]
[ User: postgres - Total duration: 87ms - Times executed: 4699 ]
[ User: postgres - Total duration: 34ms - Times executed: 18 ]
[ User: postgres - Total duration: 429ms - Times executed: 17 ]
[ User: postgres - Total duration: 52s655ms - Times executed: 6 ]
[ User: postgres - Total duration: 12ms - Times executed: 6 ]
[ User: postgres - Total duration: 0ms - Times executed: 39 ]
[ User: postgres - Total duration: 74ms - Times executed: 24 ]
[ User: postgres - Total duration: 30ms - Times executed: 7 ]
[ User: postgres - Total duration: 16ms - Times executed: 90 ]
[ User: postgres - Total duration: 0ms - Times executed: 4 ]

Time consuming bind


[ User: postgres - Total duration: 2h48m47s - Times executed: 6282 ]
[ User: postgres - Total duration: 1m10s - Times executed: 32286 ]
[ User: postgres - Total duration: 1m24s - Times executed: 150 ]
[ User: postgres - Total duration: 961ms - Times executed: 504 ]
[ User: postgres - Total duration: 793ms - Times executed: 27 ]
[ User: postgres - Total duration: 1ms - Times executed: 57 ]
[ User: postgres - Total duration: 153ms - Times executed: 28980 ]
[ User: postgres - Total duration: 27s454ms - Times executed: 16 ]
[ User: postgres - Total duration: 11s173ms - Times executed: 5865 ]
[ User: postgres - Total duration: 3s337ms - Times executed: 3379 ]
[ User: postgres - Total duration: 1s71ms - Times executed: 2193 ]
[ User: postgres - Total duration: 1s12ms - Times executed: 82 ]
[ User: postgres - Total duration: 52s655ms - Times executed: 6 ]
[ User: postgres - Total duration: 145ms - Times executed: 1 ]
[ User: postgres - Total duration: 1s379ms - Times executed: 11 ]
[ User: postgres - Total duration: 31ms - Times executed: 343 ]
[ User: postgres - Total duration: 87ms - Times executed: 4699 ]
[ User: postgres - Total duration: 50ms - Times executed: 4726 ]
[ User: postgres - Total duration: 19ms - Times executed: 510 ]
[ User: postgres - Total duration: 16ms - Times executed: 244 ]

Log levels

Key values

376,900 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	268	0.07%
DETAIL	106,639	28.29%
ERROR	3	0.00%
LOG	269,577	71.52%
STATEMENT	413	0.11%

Events distribution

Key values

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

Most Frequent Errors/Events

Key values

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

Rank

Times reported

Error

1

4

Details

LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... ms

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Aug 05	06	4

LOG: process 11216 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.063 ms at character 28
LOG: process 11216 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 59563.499 ms at character 28
LOG: process 12735 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.053 ms at character 28

2

4

Details

LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Aug 05	06	4

LOG: process 15903 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 1000.060 ms
LOG: process 15903 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 50956.718 ms
LOG: process 19712 still waiting for AccessExclusiveLock on relation 5894441 of database 5881926 after 1000.055 ms

3

1

Details

ERROR: relation "..." does not exist

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Aug 05	06	1

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

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

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

Key values