pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Mon Aug 4 04:59:48 2025
Log file: /home/postgres/pg_data/data/pg_log/postgresql-2025-08-04_060000.log
Parsed 1,559,935 log entries in 46s
Log start from 2025-08-04 06:00:00 to 2025-08-04 06:59:46

Global Stats

1,017 Number of unique normalized queries
102,576 Number of queries
3h42m35s Total query duration
2025-08-04 06:00:00 First query
2025-08-04 06:59:46 Last query
2,364 queries/s at 2025-08-04 06:19:29 Query peak

3h42m35s Total query duration
6s12ms Prepare/parse total duration
54s185ms Bind total duration
3h41m35s Execute total duration

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

41 Total number of automatic vacuums
55 Total number of automatic analyzes

873 Number temporary file
173.51 MiB Max size of temporary file
5.19 MiB Average size of temporary file

2,869 Total number of sessions
13 sessions at 2025-08-04 06:56:14 Session peak
2d7h38m55s Total duration of sessions
1m9s Average duration of sessions
35 Average queries per session
4s655ms Average queries duration per session
1m5s Average idle time per session

2,870 Total number of connections
40 connections/s at 2025-08-04 06:38:48 Connection peak
5 Total number of databases

SQL Traffic

Key values

2,364 queries/s Query Peak
2025-08-04 06:19:29 Date

SELECT Traffic

Key values

2,348 queries/s Query Peak
2025-08-04 06:19:29 Date

INSERT/UPDATE/DELETE Traffic

Key values

225 queries/s Query Peak
2025-08-04 06:00:59 Date

Queries duration

Key values

3h42m35s 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 04	06	102,576	0ms	14m17s	129ms	5m56s	7m2s	21m16s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Aug 04	06	59,076	600	42ms	1m12s	2m1s	2m58s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Aug 04	06	29,197	1,711	13	78	2ms	436ms	2s230ms	4s599ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Aug 04	06	16,891	72,958	4.32	17.23%

Day	Hour	Count	Average / Second
Aug 04	06	2,870	0.80/s

Day	Hour	Count	Average Duration	Average idle time
Aug 04	06	2,869	1m9s	1m5s

↑ Back to the top of the General Activity table

Established Connections

Key values

40 connections Connection Peak
2025-08-04 06:38:48 Date

Connections per database

Key values

acaweb_fx Main Database
2,870 connections Total

Chart
Table

Database	User	Count
acaweb_fx		2,768
	pg_dump	1
	postgres	2,419
	psql	348
acaweb_fx_integer		1
	pg_dump	1
postgres		3
	pg_dump	1
	psql	2
socialmedia		97
	pg_dump	1
	postgres	96
translations		1
	pg_dump	1

Connections per user

Key values

postgres Main User
2,870 connections Total

Chart
Table

User	Count
pg_dump	5
postgres	2,515
psql	350

Connections per host

Key values

192.168.4.142 Main host with 1123 connections
2,870 Total connections

Chart
Table

Host	Count
127.0.0.1	117
192.168.0.114	1
192.168.0.216	100
192.168.0.74	91
192.168.1.145	37
192.168.1.15	392
192.168.1.20	63
192.168.1.239	7
192.168.1.90	55
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.102	6
192.168.4.142	1,123
192.168.4.150	10
192.168.4.168	20
192.168.4.238	14
192.168.4.33	96
192.168.4.73	1
192.168.4.98	330
[local]	238

Simultaneous sessions

Key values

13 sessions Session Peak
2025-08-04 06:56:14 Date

Histogram of session times

Key values

2,228 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	2,228	77.66%
500ms-1s	188	6.55%
1s-30s	303	10.56%
30s-1m	31	1.08%
1m-10m	55	1.92%
10m-30m	43	1.50%
30m-1h	6	0.21%
1h-8h	15	0.52%
> 8h	0	0.00%

Sessions per database

Key values

acaweb_fx Main Database
2,869 sessions Total

Chart
Table

Database	User	Count	Total Duration
acaweb_fx	2,767	2d7h14m1s	1m11s
acaweb_fx_integer	1	20m22s	20m22s
postgres	3	269ms	89ms
socialmedia	97	4m31s	2s795ms
translations	1	224ms	224ms

Sessions per user

Key values

postgres Main User
2,869 sessions Total

Chart
Table

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

Sessions per host

Key values

192.168.4.142 Main Host
2,869 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	117	35m47s	18s354ms
192.168.0.114	1	5m7s	5m7s
192.168.0.216	100	43s280ms	432ms
192.168.0.74	91	8h1m52s	5m17s
192.168.1.145	37	5h12m58s	8m27s
192.168.1.15	391	5h40m20s	52s226ms
192.168.1.20	63	15h20m50s	14m36s
192.168.1.239	7	70ms	10ms
192.168.1.90	55	1m14s	1s357ms
192.168.2.126	62	6s181ms	99ms
192.168.2.182	12	4s560ms	380ms
192.168.2.205	12	605ms	50ms
192.168.2.82	47	7s331ms	155ms
192.168.3.199	36	1s275ms	35ms
192.168.4.102	6	80ms	13ms
192.168.4.142	1,123	10m3s	537ms
192.168.4.150	10	20h4m16s	2h25s
192.168.4.168	20	2s299ms	114ms
192.168.4.238	14	25s22ms	1s787ms
192.168.4.33	96	3m44s	2s342ms
192.168.4.73	1	245ms	245ms
192.168.4.98	330	25s677ms	77ms
[local]	238	20m42s	5s219ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
2,869 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	1,739	2d6h30m47s	1m52s
[unknown]	775	11m38s	900ms
pg_dump	5	35m36s	7m7s
psql	350	20m53s	3s581ms

Checkpoints Buffers

Key values

20,230 buffers Checkpoint Peak
2025-08-04 06:07:18 Date
210.018 seconds Highest write time
0.009 seconds Sync time

Checkpoints Wal files

Key values

6 files Wal files usage Peak
2025-08-04 06:07:18 Date

Checkpoints distance

Key values

178.96 Mo Distance Peak
2025-08-04 06:07:18 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Aug 04	06	49,797	1,727.131s	0.049s	1,727.483s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Aug 04	06	0	0	21	1,876	0.008s	0s

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

Day	Hour	Mean distance	Mean estimate
Aug 04	06	27,699.17 kB	65,505.33 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

168.14 MiB Temp Files size Peak
2025-08-04 06:00:10 Date

Number of temporary files

Key values

63 per second Temp Files Peak
2025-08-04 06:47:24 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Aug 04	06	873	4.42 GiB	5.19 MiB

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)


Date: 2025-08-04 06:00:06
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.0.74
Application: PostgreSQL JDBC Driver
Date: 2025-08-04 06:40:30
Duration: 28s64ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.90
Application: [unknown]
Date: 2025-08-04 06:41:16
Duration: 4s541ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-08-04 06:19:33
Duration: 3s328ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-08-04 06:32:42
Duration: 10s15ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-08-04 06:35:38
Duration: 6s817ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-08-04 06:32:32
Duration: 30s363ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-08-04 06:45:05
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.15
Application: PostgreSQL JDBC Driver

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	160	705.21 MiB	3.02 MiB	7.86 MiB	4.41 MiB	with rar_max as ( ; WITH rar_max as ( ; Date: 2025-08-04 06:00:06 Duration: 0ms Database: acaweb_fx User: postgres Remote: 192.168.0.74 Application: PostgreSQL JDBC Driver
2	38	1.66 GiB	3.83 MiB	173.51 MiB	44.62 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-04 06:40:30 Duration: 28s64ms 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-04 06:30:15 Duration: 12s564ms 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-04 06:20:12 Duration: 10s437ms Database: acaweb_fx User: postgres Remote: 192.168.1.90 Application: [unknown]
3	13	396.70 MiB	30.52 MiB	30.52 MiB	30.52 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-04 06:41:16 Duration: 4s541ms 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-04 06:33:15 Duration: 3s806ms 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-04 06:26:13 Duration: 2s377ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
4	13	711.94 MiB	54.76 MiB	54.77 MiB	54.76 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-04 06:19:33 Duration: 3s328ms 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-04 06:56:18 Duration: 3s313ms 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-04 06:46:17 Duration: 3s312ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
5	8	634.83 MiB	79.33 MiB	79.37 MiB	79.35 MiB	select updateresultsmaterializedview (); select updateresultsmaterializedview (); Date: 2025-08-04 06:32:42 Duration: 10s15ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateresultsmaterializedview (); Date: 2025-08-04 06:17:40 Duration: 8s258ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateresultsmaterializedview (); Date: 2025-08-04 06:47:36 Duration: 8s45ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
6	4	41.47 MiB	10.36 MiB	10.37 MiB	10.37 MiB	select updaterelevantforrelevantresults (); select updaterelevantforrelevantresults (); Date: 2025-08-04 06:35:38 Duration: 6s817ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updaterelevantforrelevantresults (); Date: 2025-08-04 06:20:37 Duration: 5s955ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updaterelevantforrelevantresults (); Date: 2025-08-04 06:05:32 Duration: 1s277ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
7	4	341.40 MiB	85.31 MiB	85.40 MiB	85.35 MiB	select updateageforrelevantresults (); select updateageforrelevantresults (); Date: 2025-08-04 06:32:32 Duration: 30s363ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateageforrelevantresults (); Date: 2025-08-04 06:17:32 Duration: 30s20ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateageforrelevantresults (); Date: 2025-08-04 06:47:28 Duration: 25s589ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
8	1	3.11 MiB	3.11 MiB	3.11 MiB	3.11 MiB	select resultuid from relevance_autochartist_results order by resultuid desc limit ?), ar as ( select a., rr.age, rr.relevant from autochartist_results a left outer join relevance_autochartist_results rr on a.resultuid = rr.resultuid where case when false = ? then true else a.resultuid > ( select min(resultuid) from relevance_autochartist_results) end), all_results as ( select ar.resultuid as resultuid, ar.direction as direction, ar.predictiontimeto as predictiontimeto, ar.predictionpricefrom as predictionpricefrom, ar.predictionpriceto as predictionpriceto, cp.pip as pip, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, ar.pattern as pattern_name, ar.breakout as breakout, ar.patternendtime as identified, dtt.timezone as timezone, ar.patternlengthbars as length, g.basegroupname, newlevels.profit, newlevels.stop, newlevels.filtered, case when ar.age is not null then ar.age when ar.resultuid <= rm.resultuid then ? else ? end as age, case when ar.relevant is not null then ar.relevant when ar.resultuid <= rm.resultuid then ? else ? end as relevant from ar inner join symbols s on ar.symbolid = s.symbolid and s.nonliquid = ? inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = s.symbolid inner join symbolgroup sg on bsl.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join downloadersymbolsettings dss on sg.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join rar_max rm on ? = ? left outer join autochartist_symbolupdates au on dss.symbolid = au.symbolid left outer join currencypips cp on s.symbol = cp.symbol left join lateral calc_cp_signal (ar.resultuid) newlevels on true left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where ar.gmttimefound > now() - interval ? and dss.enabled = ? and s.deleted = ? and (ar.simulation = ? or ar.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ar.pattern in (...)) and (? = ? or (? = ? and ar.breakout >= ?) or (? = ? and ar.breakout < ?)) and (? = ? or ar.patternlengthbars <= ?) and newlevels.filtered = false and ar.patternstarttime >= coalesce(au.earliestpricedatetime, ?::timestamp without time zone) -- to make sure patternstarttime is in our t-tables ), results as ( select distinct on (symbolid) from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc ; SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1), ar AS ( SELECT a., rr.age, rr.relevant from autochartist_results a LEFT OUTER JOIN relevance_autochartist_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_autochartist_results) END), all_results AS ( SELECT ar.resultuid AS resultuid, ar.direction AS direction, ar.predictiontimeto AS predictiontimeto, ar.predictionpricefrom AS predictionpricefrom, ar.predictionpriceto AS predictionpriceto, cp.pip AS pip, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, ar.pattern AS pattern_name, ar.breakout AS breakout, ar.patternendtime AS identified, dtt.timezone AS timezone, ar.patternlengthbars AS length, g.basegroupname, newLevels.profit, newLevels.stop, newLevels.filtered, CASE WHEN ar.age IS NOT NULL THEN ar.age WHEN ar.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN ar.relevant IS NOT NULL THEN ar.relevant WHEN ar.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM ar INNER JOIN symbols s ON ar.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = s.symbolid INNER JOIN symbolgroup sg on bsl.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON sg.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN currencypips cp ON s.symbol = cp.symbol LEFT JOIN LATERAL calc_cp_signal (ar.resultuid) newLevels on true LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE ar.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (ar.simulation = 0 OR ar.simulation IS NULL) AND ($3 = 0 OR s.timegranularity in ($4)) AND ($5 = 0 OR s.exchange in ($6)) AND ($7 = 0 OR coalesce(bim.code, s.symbol) in ($8)) AND ($9 = 0 OR ar.pattern in ($10)) AND ($11 = 0 OR ($12 = 1 AND ar.breakout >= 0) OR ($13 = 2 AND ar.breakout < 0)) AND ($14 = 0 OR ar.patternlengthbars <= $15) and newLevels.filtered = false AND ar.patternstarttime >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = $16 OR relevant = 1) AND ($17 = 0 OR age <= $18) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; Date: 2025-08-04 06:45:05 Duration: 0ms Database: acaweb_fx User: postgres Remote: 192.168.1.15 Application: PostgreSQL JDBC Driver

Queries generating the largest temporary files


[ Date: 2025-08-04 06:40:25 ]
[ Date: 2025-08-04 06:10:06 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
[ Date: 2025-08-04 06:20:09 ]
[ Date: 2025-08-04 06:30:09 ]
[ Date: 2025-08-04 06:00:05 ]
[ Date: 2025-08-04 06:30:09 ]
[ Date: 2025-08-04 06:02:04 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-04 06:32:22 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-04 06:47:19 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-04 06:17:22 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-04 06:00:05 ]
[ Date: 2025-08-04 06:50:04 ]
[ Date: 2025-08-04 06:02:13 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-04 06:47:30 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-04 06:32:34 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-04 06:17:34 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-04 06:50:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-04 06:35:38 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-04 06:20:37 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-04 06:05:32 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

Rank	Size	Query
1	173.51 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-04 06:40:25 ]
2	147.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-04 06:10:06 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
3	145.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-04 06:20:09 ]
4	111.54 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-04 06:30:09 ]
5	101.57 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-04 06:00:05 ]
6	99.22 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2025-08-04 06:30:09 ]
7	85.40 MiB	select updateageforrelevantresults (); [ Date: 2025-08-04 06:02:04 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
8	85.37 MiB	select updateageforrelevantresults (); [ Date: 2025-08-04 06:32:22 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
9	85.33 MiB	select updateageforrelevantresults (); [ Date: 2025-08-04 06:47:19 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
10	85.31 MiB	select updateageforrelevantresults (); [ Date: 2025-08-04 06:17:22 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
11	84.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-04 06:00:05 ]
12	80.27 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-04 06:50:04 ]
13	79.37 MiB	select updateresultsmaterializedview (); [ Date: 2025-08-04 06:02:13 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
14	79.37 MiB	select updateresultsmaterializedview (); [ Date: 2025-08-04 06:47:30 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
15	79.37 MiB	select updateresultsmaterializedview (); [ Date: 2025-08-04 06:32:34 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
16	79.35 MiB	select updateresultsmaterializedview (); [ Date: 2025-08-04 06:17:34 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
17	79.35 MiB	select updateresultsmaterializedview (); [ Date: 2025-08-04 06:50:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
18	79.35 MiB	select updateresultsmaterializedview (); [ Date: 2025-08-04 06:35:38 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
19	79.34 MiB	select updateresultsmaterializedview (); [ Date: 2025-08-04 06:20:37 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
20	79.33 MiB	select updateresultsmaterializedview (); [ Date: 2025-08-04 06:05:32 - 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 (12) Main table analyzed (database acaweb_fx)
55 analyzes Total

Chart
Table

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

Vacuums per table

Key values

public.solr_relevance_old (15) Main table vacuumed on database acaweb_fx
41 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	15	13	9,945	0	36	0	57	6,514	12	1,183,672
acaweb_fx.public.datafeeds_latestrun	5	0	575	0	44	0	0	63	33	73,228
acaweb_fx.public.relevance_keylevels_results	3	3	11,735	0	490	2	274	2,238	466	1,277,455
acaweb_fx.public.relevance_fibonacci_results	3	3	3,936	0	50	0	180	476	36	107,259
acaweb_fx.pg_toast.pg_toast_2619	2	2	337	0	75	0	0	207	70	296,187
acaweb_fx.pg_catalog.pg_attribute	2	2	1,707	0	289	0	134	792	270	1,613,628
acaweb_fx.public.latest_t15_candle_view	2	2	136	0	8	0	0	12	2	17,091
acaweb_fx.pg_catalog.pg_class	2	2	725	0	49	0	80	244	45	244,485
acaweb_fx.public.relevance_autochartist_results	2	2	6,686	0	338	0	511	1,199	467	1,120,554
acaweb_fx.pg_catalog.pg_index	1	1	91	0	16	0	0	32	13	93,051
acaweb_fx.pg_catalog.pg_type	1	1	175	0	15	0	0	46	13	78,333
acaweb_fx.public.autochartist_symbolupdates	1	1	26,208	0	734	0	37,415	6,877	313	553,872
acaweb_fx.pg_catalog.pg_statistic	1	1	855	0	189	0	665	530	187	758,404
acaweb_fx.public.relevance_consecutivecandles_results	1	1	78	0	9	0	0	27	4	26,011
Total	41	34	63,189	49,453	2,342	2	39,316	19,257	1,931	7,443,230

Tuples removed per table

Key values

public.solr_relevance_old (53376) Main table with removed tuples on database acaweb_fx
70324 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
acaweb_fx.public.solr_relevance_old	15	13	53,376	87,922	13,163	0	2,548
acaweb_fx.public.autochartist_symbolupdates	1	1	7,223	46,678	1	0	40,691
acaweb_fx.pg_catalog.pg_attribute	2	2	3,221	18,998	252	0	500
acaweb_fx.public.relevance_keylevels_results	3	3	2,589	37,517	2,513	0	837
acaweb_fx.public.relevance_autochartist_results	2	2	1,554	14,987	72	0	760
acaweb_fx.pg_catalog.pg_statistic	1	1	804	4,418	36	0	1,194
acaweb_fx.public.relevance_fibonacci_results	3	3	470	4,103	284	0	306
acaweb_fx.pg_catalog.pg_class	2	2	464	3,948	54	0	300
acaweb_fx.public.datafeeds_latestrun	5	0	216	158	88	0	80
acaweb_fx.pg_toast.pg_toast_2619	2	2	135	372	24	0	106
acaweb_fx.public.latest_t15_candle_view	2	2	92	53	25	0	2
acaweb_fx.public.relevance_consecutivecandles_results	1	1	88	287	0	0	8
acaweb_fx.pg_catalog.pg_index	1	1	65	827	14	0	23
acaweb_fx.pg_catalog.pg_type	1	1	27	1,377	39	0	38
Total	41	34	70,324	221,645	16,565	0	47,393

Pages removed per table

Key values

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

Chart
Table

Pages removed per tables

NO DATASET

Table	Number of vacuums	Index scans	Tuples removed
acaweb_fx.pg_catalog.pg_index	1	1	65
acaweb_fx.pg_toast.pg_toast_2619	2	2	135
acaweb_fx.pg_catalog.pg_type	1	1	27
acaweb_fx.public.datafeeds_latestrun	5	0	216
acaweb_fx.public.autochartist_symbolupdates	1	1	7223
acaweb_fx.pg_catalog.pg_statistic	1	1	804
acaweb_fx.pg_catalog.pg_attribute	2	2	3221
acaweb_fx.public.relevance_consecutivecandles_results	1	1	88
acaweb_fx.public.latest_t15_candle_view	2	2	92
acaweb_fx.public.relevance_keylevels_results	3	3	2589
acaweb_fx.public.solr_relevance_old	15	13	53376
acaweb_fx.pg_catalog.pg_class	2	2	464
acaweb_fx.public.relevance_autochartist_results	2	2	1554
acaweb_fx.public.relevance_fibonacci_results	3	3	470
Total	41	34	70,324

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Aug 04	06	41	55

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

AccessExclusiveLock Main Lock Type
3 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
AccessExclusiveLock		2	16m43s	8m21s
	relation	2	16m43s	8m21s
AccessShareLock		1	1m57s	1m57s
	relation	1	1m57s	1m57s
	Total	3	18m40s	6m13s

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	1	14m16s	14m16s	14m16s	14m16s	truncate table solr_relevance_old; TRUNCATE TABLE solr_relevance_old; Date: 2025-08-04 06:19:28 Database: acaweb_fx User: postgres Remote: [local] Application: psql TRUNCATE TABLE solr_relevance_old; Date: 2025-08-04 06:20:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql TRUNCATE TABLE solr_relevance_old; Date: 2025-08-04 06:26:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql
2	1	2m26s	2m26s	2m26s	2m26s	refresh materialized view latest_candle_datetime_per_receng; refresh materialized view latest_candle_datetime_per_receng; Date: 2025-08-04 06:19:28 Database: acaweb_fx User: postgres Remote: [local] Application: psql refresh materialized view latest_candle_datetime_per_receng; Date: 2025-08-04 06:47:02 Database: acaweb_fx User: postgres Remote: [local] Application: psql refresh materialized view latest_candle_datetime_per_receng; Date: 2025-08-04 06:32:01 Database: acaweb_fx User: postgres Remote: [local] Application: psql
3	1	1m57s	1m57s	1m57s	1m57s	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-04 06:19:28 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 - 2'; Date: 2025-08-04 06:03:19 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 - 3'; Date: 2025-08-04 06:32:29 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: [unknown]

Rank

Count

Total time

Min time

Max time

Avg duration

Query

1

14m16s

truncate table solr_relevance_old;

TRUNCATE TABLE solr_relevance_old;

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

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

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

2

1

2m26s

refresh materialized view latest_candle_datetime_per_receng;

refresh materialized view latest_candle_datetime_per_receng;

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

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

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

3

1

1m57s

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-04 06:19:28 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 - 2';

Date: 2025-08-04 06:03:19 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 - 3';

Date: 2025-08-04 06:32:29 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: [unknown]

Queries that waited the most

Rank	Wait time	Query
1	14m16s	TRUNCATE TABLE solr_relevance_old; [ Date: 2025-08-04 06:19:28 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	2m26s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2025-08-04 06:19:28 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
3	1m57s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 3'; [ Date: 2025-08-04 06:19:28 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]

Rank

Wait time

Query

1

14m16s

TRUNCATE TABLE solr_relevance_old;

[ Date: 2025-08-04 06:19:28 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

2

2m26s

refresh materialized view latest_candle_datetime_per_receng;

[ Date: 2025-08-04 06:19:28 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

3

1m57s

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

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

Queries by type

Key values

59,076 Total read queries
38,934 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	59,076	57.59%
INSERT	29,197	28.46%
UPDATE	1,711	1.67%
DELETE	13	0.01%
COPY FROM	78	0.08%
COPY TO	600	0.58%
CTE	6,621	6.45%
DDL	13	0.01%
TCL	701	0.68%
CURSOR	0	0.00%
OTHERS	4,566	4.45%

Queries by database

Key values

acaweb_fx Main database
90,348 Requests
3h20m32s (acaweb_fx)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
acaweb_fx	Total	90,348	3h20m32s
	copy from	78	5s216ms
	copy to	305	14m24s
	cte	6,617	2h41m19s
	ddl	13	14m17s
	delete	13	21ms
	insert	21,761	30s288ms
	others	4,235	2m48s
	select	55,002	6m37s
	tcl	697	208ms
	update	1,627	30s654ms
acaweb_fx_integer	Total	3,589	20m7s
	copy to	276	20m6s
	cte	1	8ms
	others	285	22ms
	select	3,026	1s467ms
	tcl	1	0ms
postgres	Total	367	236ms
	cte	1	1ms
	others	9	0ms
	select	356	234ms
	tcl	1	0ms
socialmedia	Total	8,225	55s111ms
	copy to	19	45s458ms
	cte	1	1ms
	insert	7,436	8s942ms
	others	28	0ms
	select	656	537ms
	tcl	1	0ms
	update	84	171ms
translations	Total	47	212ms
	cte	1	2ms
	others	9	0ms
	select	36	209ms
	tcl	1	0ms

Queries by user

Key values

postgres Main user
102,576 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	102,576	3h41m35s
	copy from	78	5s216ms
	copy to	600	35m15s
	cte	6,621	2h41m19s
	ddl	13	14m17s
	delete	13	21ms
	insert	29,197	39s230ms
	others	4,566	2m48s
	select	59,076	6m39s
	tcl	701	208ms
	update	1,711	30s825ms

Duration by user

Key values

3h41m35s (postgres) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	102,576	3h41m35s
	copy from	78	5s216ms
	copy to	600	35m15s
	cte	6,621	2h41m19s
	ddl	13	14m17s
	delete	13	21ms
	insert	29,197	39s230ms
	others	4,566	2m48s
	select	59,076	6m39s
	tcl	701	208ms
	update	1,711	30s825ms

Queries by host

Key values

192.168.1.15 Main host
26,492 Requests
46m14s (192.168.0.74)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	18,447	37m53s
	copy to	600	35m15s
	cte	25	230ms
	insert	8,425	11s788ms
	others	619	29ms
	select	7,698	2m24s
	tcl	5	0ms
	update	1,075	1s152ms
182.165.1.42	Total	194	7m39s
	cte	60	7m39s
	select	134	182ms
192.168.0.114	Total	34	9ms
	others	2	0ms
	select	10	1ms
	tcl	16	7ms
	update	6	0ms
192.168.0.216	Total	400	427ms
	others	200	48ms
	select	192	240ms
	update	8	138ms
192.168.0.239	Total	341	4s695ms
	select	341	4s695ms
192.168.0.42	Total	899	5s687ms
	insert	268	47ms
	select	631	5s639ms
192.168.0.74	Total	6,281	46m14s
	cte	928	46m6s
	others	182	2ms
	select	5,171	8s98ms
192.168.1.135	Total	136	375ms
	cte	9	186ms
	select	127	188ms
192.168.1.145	Total	8,292	30m21s
	cte	589	30m9s
	others	74	0ms
	select	7,629	11s443ms
192.168.1.15	Total	26,492	44m40s
	cte	4,326	44m24s
	others	784	9ms
	select	21,382	15s389ms
192.168.1.20	Total	11,944	31m2s
	cte	585	30m45s
	others	126	1ms
	select	11,233	17s331ms
192.168.1.201	Total	1,169	7s912ms
	select	1,169	7s912ms
192.168.1.23	Total	1,319	12s409ms
	select	1,319	12s409ms
192.168.1.239	Total	28	25ms
	others	14	1ms
	select	14	23ms
192.168.1.49	Total	10	34ms
	cte	1	0ms
	select	9	33ms
192.168.1.90	Total	75	1m12s
	cte	6	1m12s
	others	14	0ms
	select	55	72ms
192.168.1.93	Total	2	2ms
	select	2	2ms
192.168.1.97	Total	8	24ms
	cte	1	0ms
	select	7	24ms
192.168.2.126	Total	80	83ms
	others	18	0ms
	select	62	83ms
192.168.2.182	Total	48	334ms
	others	24	2ms
	select	12	13ms
	update	12	318ms
192.168.2.205	Total	138	169ms
	insert	90	8ms
	others	24	2ms
	select	20	26ms
	update	4	131ms
192.168.2.82	Total	1,217	2s843ms
	insert	803	1s956ms
	others	94	11ms
	select	190	114ms
	update	130	760ms
192.168.3.199	Total	144	292ms
	others	72	8ms
	select	60	68ms
	update	12	215ms
192.168.4.102	Total	18	5ms
	others	12	0ms
	select	4	4ms
	update	2	0ms
192.168.4.142	Total	15,533	17s841ms
	insert	12,173	16s479ms
	others	2,246	28ms
	select	1,114	1s333ms
192.168.4.150	Total	22	1s141ms
	others	21	0ms
	select	1	1s141ms
192.168.4.168	Total	40	817ms
	select	20	816ms
	tcl	20	0ms
192.168.4.238	Total	42	24s165ms
	cte	12	24s158ms
	insert	2	7ms
	others	28	0ms
192.168.4.33	Total	7,934	9s409ms
	insert	7,436	8s942ms
	select	414	295ms
	update	84	171ms
192.168.4.73	Total	3	105ms
	cte	1	105ms
	others	2	0ms
192.168.4.98	Total	996	20s456ms
	others	6	19s539ms
	select	6	30ms
	tcl	660	200ms
	update	324	685ms
[local]	Total	290	20m41s
	copy from	78	5s216ms
	cte	78	35s921ms
	ddl	13	14m17s
	delete	13	21ms
	others	4	2m28s
	select	50	2m47s
	update	54	27s249ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
70,766 Requests
2h33m33s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	70,766	2h33m33s
	cte	6,450	2h31m51s
	insert	12,443	16s534ms
	others	1,741	25ms
	select	50,130	1m25s
	update	2	0ms
[unknown]	Total	23,210	12m1s
	cte	68	8m51s
	insert	16,754	22s696ms
	others	2,202	19s633ms
	select	1,847	2m23s
	tcl	696	208ms
	update	1,643	3s541ms
pg_dump	Total	8,198	35m8s
	copy to	574	35m5s
	cte	5	20ms
	others	619	29ms
	select	6,995	3s375ms
	tcl	5	0ms
psql	Total	402	20m52s
	copy from	78	5s216ms
	copy to	26	10s478ms
	cte	98	36s132ms
	ddl	13	14m17s
	delete	13	21ms
	others	4	2m28s
	select	104	2m47s
	update	66	27s283ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-08-04 06:56:58 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

63,556 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	63,556	61.96%
1-5ms	32,995	32.17%
5-10ms	2,120	2.07%
10-25ms	979	0.95%
25-50ms	433	0.42%
50-100ms	238	0.23%
100-500ms	633	0.62%
500-1000ms	153	0.15%
1000-10000ms	1,104	1.08%
> 10000ms	365	0.36%

Slowest individual queries


[ Date: 2025-08-04 06:19:28 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-04 06:08:22 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-04 06:32:40 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-04 06:14:30 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-04 06:19:28 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-08-04 06:21:48 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-04 06:37:08 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-04 06:19:28 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2025-08-04 06:25:14 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-04 06:23:33 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-04 06:11:45 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-04 06:28:31 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-04 06:15:43 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-04 06:29:40 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-04 06:18:02 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-04 06:38:53 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-04 06:16:57 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-08-04 06:36:28 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-08-04 06:23:04 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-08-04 06:35:04 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]

Rank	Duration	Query
1	14m17s	TRUNCATE TABLE solr_relevance_old; [ Date: 2025-08-04 06:19:28 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	3m19s	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-04 06:08:22 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
3	2m56s	COPY public.researchreports (researchreportid, type, createddatetime, language, filename, xml) TO stdout; [ Date: 2025-08-04 06:32:40 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
4	2m41s	COPY public.researchreports (researchreportid, type, createddatetime, language, filename, xml) TO stdout; [ Date: 2025-08-04 06:14:30 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
5	2m27s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2025-08-04 06:19:28 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
6	2m18s	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-04 06:21:48 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
7	2m3s	COPY public.t15_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2025-08-04 06:37:08 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
8	1m57s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 3'; [ Date: 2025-08-04 06:19:28 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
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-04 06:25:14 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
10	1m37s	COPY public.authenticationlog (attemptid, username, password, brokerid, authclass, attemptdatetime, success, fingerprint, accounttype) TO stdout; [ Date: 2025-08-04 06:23:33 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
11	1m19s	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-04 06:11:45 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
12	1m12s	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-04 06:28:31 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
13	1m9s	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-04 06:15:43 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
14	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-04 06:29:40 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
15	1m4s	COPY public.t15_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2025-08-04 06:18:02 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
16	59s478ms	COPY public.t30_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2025-08-04 06:38:53 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
17	57s797ms	COPY public.t15_hve (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived, pricesadjusted, relevanceprocessed, recengprocessedadjusted) TO stdout; [ Date: 2025-08-04 06:16:57 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
18	50s741ms	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-04 06:36:28 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19	50s662ms	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-04 06:23:04 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20	50s205ms	COPY public.t15_hve (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived, pricesadjusted, relevanceprocessed, recengprocessedadjusted) TO stdout; [ Date: 2025-08-04 06:35:04 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]

Time consuming queries


[ User: postgres - Total duration: 1h8m16s - Times executed: 453 ]
[ User: postgres - Total duration: 1h5m45s - Times executed: 454 ]
[ User: postgres - Total duration: 20m8s - Times executed: 428 ]
[ User: postgres - Total duration: 14m17s - Times executed: 13 ]
[ User: postgres - Total duration: 5m38s - Times executed: 2 ]
[ User: postgres - Total duration: 5m37s - Times executed: 2 ]
[ User: postgres - Total duration: 3m8s - Times executed: 2 ]
[ User: postgres - Total duration: 2m53s - Times executed: 294 ]
[ User: postgres - Total duration: 2m28s - Times executed: 2 ]
[ User: postgres - Total duration: 2m28s - Times executed: 4 ]
[ User: postgres - Total duration: 1m59s - Times executed: 2 ]
[ User: postgres - Total duration: 1m57s - Times executed: 2 ]
[ User: postgres - Total duration: 1m57s - Times executed: 122 ]
[ User: postgres - Total duration: 1m48s - Times executed: 2 ]
[ User: postgres - Total duration: 1m47s - Times executed: 2 ]
[ User: postgres - Total duration: 1m45s - Times executed: 141 ]
[ User: postgres - Total duration: 1m41s - Times executed: 2 ]
[ User: postgres - Total duration: 1m36s - Times executed: 4 ]
[ User: postgres - Total duration: 1m26s - Times executed: 2 ]
[ User: postgres - Total duration: 1m12s - Times executed: 6 ]

Most frequent queries (N)


[ User: postgres - Total duration: 125ms - Times executed: 25013 ]
[ User: postgres - Total duration: 21s178ms - Times executed: 14695 ]
[ User: postgres - Total duration: 8s356ms - Times executed: 7036 ]
[ User: postgres - Total duration: 11s396ms - Times executed: 6174 ]
[ User: postgres - Total duration: 15s101ms - Times executed: 5789 ]
[ User: postgres - Total duration: 5s107ms - Times executed: 4535 ]
[ User: postgres - Total duration: 3s524ms - Times executed: 3488 ]
[ User: postgres - Total duration: 1s477ms - Times executed: 2518 ]
[ User: postgres - Total duration: 1s233ms - Times executed: 2256 ]
[ User: postgres - Total duration: 2s171ms - Times executed: 2204 ]
[ User: postgres - Total duration: 915ms - Times executed: 1973 ]
[ User: postgres - Total duration: 18ms - Times executed: 1766 ]
[ User: postgres - Total duration: 25ms - Times executed: 1740 ]
[ User: postgres - Total duration: 40ms - Times executed: 1642 ]
[ User: postgres - Total duration: 5s40ms - Times executed: 1306 ]
[ User: postgres - Total duration: 1s117ms - Times executed: 1063 ]
[ User: postgres - Total duration: 180ms - Times executed: 921 ]
[ User: postgres - Total duration: 293ms - Times executed: 730 ]
[ User: postgres - Total duration: 131ms - Times executed: 645 ]
[ User: postgres - Total duration: 68ms - Times executed: 574 ]

Normalized slowest queries (N)


[ User: postgres - Total duration: 5m38s - Times executed: 2 ]
[ User: postgres - Total duration: 5m37s - Times executed: 2 ]
[ User: postgres - Total duration: 3m8s - Times executed: 2 ]
[ User: postgres - Total duration: 2m28s - Times executed: 2 ]
[ User: postgres - Total duration: 14m17s - Times executed: 13 ]
[ User: postgres - Total duration: 1m59s - Times executed: 2 ]
[ User: postgres - Total duration: 1m57s - Times executed: 2 ]
[ User: postgres - Total duration: 1m48s - Times executed: 2 ]
[ User: postgres - Total duration: 1m47s - Times executed: 2 ]
[ User: postgres - Total duration: 1m41s - Times executed: 2 ]
[ User: postgres - Total duration: 1m26s - Times executed: 2 ]
[ User: postgres - Total duration: 2m28s - Times executed: 4 ]
[ User: postgres - Total duration: 1m36s - Times executed: 4 ]
[ User: postgres - Total duration: 1m12s - Times executed: 6 ]
[ User: postgres - Total duration: 1h8m16s - Times executed: 453 ]
[ User: postgres - Total duration: 1h5m45s - Times executed: 454 ]
[ User: postgres - Total duration: 20m8s - Times executed: 428 ]
[ User: postgres - Total duration: 1m57s - Times executed: 122 ]
[ User: postgres - Total duration: 1m45s - Times executed: 141 ]
[ User: postgres - Total duration: 2m53s - Times executed: 294 ]

Time consuming prepare


[ User: postgres - Total duration: 1h46m31s - Times executed: 2750 ]
[ User: postgres - Total duration: 13s625ms - Times executed: 2673 ]
[ User: postgres - Total duration: 1s100ms - Times executed: 500 ]
[ User: postgres - Total duration: 5s123ms - Times executed: 1006 ]
[ User: postgres - Total duration: 3s143ms - Times executed: 2736 ]
[ User: postgres - Total duration: 18ms - Times executed: 1766 ]
[ User: postgres - Total duration: 1s40ms - Times executed: 1659 ]
[ User: postgres - Total duration: 7ms - Times executed: 1473 ]
[ User: postgres - Total duration: 24s158ms - Times executed: 12 ]
[ User: postgres - Total duration: 36ms - Times executed: 18 ]
[ User: postgres - Total duration: 16s307ms - Times executed: 25 ]
[ User: postgres - Total duration: 0ms - Times executed: 4 ]
[ User: postgres - Total duration: 25ms - Times executed: 1740 ]
[ User: postgres - Total duration: 1m12s - Times executed: 6 ]
[ User: postgres - Total duration: 171ms - Times executed: 159 ]
[ User: postgres - Total duration: 80ms - Times executed: 24 ]
[ User: postgres - Total duration: 12ms - Times executed: 6 ]
[ User: postgres - Total duration: 153ms - Times executed: 96 ]
[ User: postgres - Total duration: 0ms - Times executed: 28 ]
[ User: postgres - Total duration: 8ms - Times executed: 90 ]

Time consuming bind


[ User: postgres - Total duration: 2h36m14s - Times executed: 6268 ]
[ User: postgres - Total duration: 49s289ms - Times executed: 22930 ]
[ User: postgres - Total duration: 1m45s - Times executed: 141 ]
[ User: postgres - Total duration: 1s100ms - Times executed: 500 ]
[ User: postgres - Total duration: 564ms - Times executed: 30 ]
[ User: postgres - Total duration: 0ms - Times executed: 57 ]
[ User: postgres - Total duration: 11s396ms - Times executed: 6174 ]
[ User: postgres - Total duration: 111ms - Times executed: 24872 ]
[ User: postgres - Total duration: 24s158ms - Times executed: 12 ]
[ User: postgres - Total duration: 3s524ms - Times executed: 3488 ]
[ User: postgres - Total duration: 1s233ms - Times executed: 2256 ]
[ User: postgres - Total duration: 904ms - Times executed: 77 ]
[ User: postgres - Total duration: 1m12s - Times executed: 6 ]
[ User: postgres - Total duration: 2s965ms - Times executed: 12 ]
[ User: postgres - Total duration: 105ms - Times executed: 1 ]
[ User: postgres - Total duration: 26ms - Times executed: 292 ]
[ User: postgres - Total duration: 221ms - Times executed: 24 ]
[ User: postgres - Total duration: 17ms - Times executed: 478 ]
[ User: postgres - Total duration: 171ms - Times executed: 159 ]
[ User: postgres - Total duration: 244ms - Times executed: 77 ]

Log levels

Key values

292,228 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	564	0.19%
DETAIL	88,898	30.42%
ERROR	1	0.00%
LOG	202,056	69.14%
STATEMENT	709	0.24%

Events distribution

Key values

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

Most Frequent Errors/Events

Key values

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

Rank

Times reported

Error

1

4

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Aug 04	06	4

LOG: process 31231 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 1000.064 ms
LOG: process 31231 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 54944.459 ms
LOG: process 2675 still waiting for AccessExclusiveLock on relation 5894441 of database 5881926 after 1000.052 ms

2

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Aug 04	06	2

LOG: process 14032 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.059 ms at character 28
LOG: process 14032 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 34147.366 ms at character 28

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

Queries generating the most temporary files (N)

Queries generating the largest temporary files

Vacuums

Vacuums / Analyzes Distribution

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Pages removed per tables

Autovacuum Activity

Locks

Locks by types

Key values

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