pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Thu Dec 11 04:59:53 2025
Log file: /home/postgres/pg_data/data/pg_log/postgresql-2025-12-11_060000.log
Parsed 2,013,446 log entries in 51s
Log start from 2025-12-11 06:00:00 to 2025-12-11 06:59:51

Global Stats

1,016 Number of unique normalized queries
110,143 Number of queries
3h52m12s Total query duration
2025-12-11 06:00:00 First query
2025-12-11 06:59:51 Last query
3,104 queries/s at 2025-12-11 06:05:02 Query peak

3h52m12s Total query duration
1m23s Prepare/parse total duration
1m2s Bind total duration
3h49m46s Execute total duration

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

37 Total number of automatic vacuums
48 Total number of automatic analyzes

755 Number temporary file
127.61 MiB Max size of temporary file
6.93 MiB Average size of temporary file

3,473 Total number of sessions
14 sessions at 2025-12-11 06:57:09 Session peak
2d15h40m21s Total duration of sessions
1m6s Average duration of sessions
31 Average queries per session
4s11ms Average queries duration per session
1m1s Average idle time per session

3,474 Total number of connections
30 connections/s at 2025-12-11 06:40:02 Connection peak
5 Total number of databases

SQL Traffic

Key values

3,104 queries/s Query Peak
2025-12-11 06:05:02 Date

SELECT Traffic

Key values

3,100 queries/s Query Peak
2025-12-11 06:05:02 Date

INSERT/UPDATE/DELETE Traffic

Key values

172 queries/s Query Peak
2025-12-11 06:00:53 Date

Queries duration

Key values

3h52m12s 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)
Dec 11	06	110,143	0ms	14m47s	125ms	5m43s	6m43s	19m41s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 11	06	64,191	601	39ms	1m19s	1m55s	2m58s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 11	06	26,074	1,879	13	78	2ms	712ms	2s22ms	5s582ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Dec 11	06	23,786	83,059	3.49	22.80%

Day	Hour	Count	Average / Second
Dec 11	06	3,474	0.96/s

Day	Hour	Count	Average Duration	Average idle time
Dec 11	06	3,473	1m6s	1m2s

↑ Back to the top of the General Activity table

Established Connections

Key values

30 connections Connection Peak
2025-12-11 06:40:02 Date

Connections per database

Key values

acaweb_fx Main Database
3,474 connections Total

Chart
Table

Database	User	Count
acaweb_fx		3,382
	pg_dump	1
	postgres	3,033
	psql	348
acaweb_fx_integer		1
	pg_dump	1
postgres		3
	pg_dump	1
	psql	2
socialmedia		87
	pg_dump	1
	postgres	86
translations		1
	pg_dump	1

Connections per user

Key values

postgres Main User
3,474 connections Total

Chart
Table

User	Count
pg_dump	5
postgres	3,119
psql	350

Connections per host

Key values

192.168.4.142 Main host with 971 connections
3,474 Total connections

Chart
Table

Host	Count
127.0.0.1	117
192.168.0.114	2
192.168.0.216	101
192.168.0.74	432
192.168.1.145	28
192.168.1.15	840
192.168.1.20	56
192.168.1.231	20
192.168.1.239	2
192.168.1.90	58
192.168.2.126	62
192.168.2.182	12
192.168.2.82	48
192.168.3.199	36
192.168.4.105	4
192.168.4.142	971
192.168.4.150	10
192.168.4.164	1
192.168.4.238	14
192.168.4.33	86
192.168.4.96	6
192.168.4.98	330
[local]	238

Simultaneous sessions

Key values

14 sessions Session Peak
2025-12-11 06:57:09 Date

Histogram of session times

Key values

2,700 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	2,700	77.74%
500ms-1s	162	4.66%
1s-30s	377	10.86%
30s-1m	46	1.32%
1m-10m	119	3.43%
10m-30m	53	1.53%
30m-1h	2	0.06%
1h-8h	13	0.37%
> 8h	1	0.03%

Sessions per database

Key values

acaweb_fx Main Database
3,473 sessions Total

Chart
Table

Database	User	Count	Total Duration
acaweb_fx	3,381	2d15h16m53s	1m7s
acaweb_fx_integer	1	20m34s	20m34s
postgres	3	313ms	104ms
socialmedia	87	2m53s	1s994ms
translations	1	213ms	213ms

Sessions per user

Key values

postgres Main User
3,473 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
3,473 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	117	37m24s	19s181ms
192.168.0.114	2	10m5s	5m2s
192.168.0.216	101	1m22s	820ms
192.168.0.74	432	13h46m10s	1m54s
192.168.1.145	28	2h13m54s	4m46s
192.168.1.15	839	3h42m42s	15s926ms
192.168.1.20	56	12h39m43s	13m33s
192.168.1.231	20	9h50m52s	29m32s
192.168.1.239	2	18ms	9ms
192.168.1.90	58	2m9s	2s228ms
192.168.2.126	62	6s451ms	104ms
192.168.2.182	12	1s76ms	89ms
192.168.2.82	48	11s836ms	246ms
192.168.3.199	36	1s484ms	41ms
192.168.4.105	4	25s270ms	6s317ms
192.168.4.142	971	9m38s	596ms
192.168.4.150	10	20h31s	2h3s
192.168.4.164	1	329ms	329ms
192.168.4.238	14	15s531ms	1s109ms
192.168.4.33	86	1m18s	907ms
192.168.4.96	6	66ms	11ms
192.168.4.98	330	35s551ms	107ms
[local]	238	22m50s	5s757ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
3,473 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	2,387	2d14h25m29s	1m34s
[unknown]	731	14m37s	1s200ms
pg_dump	5	37m7s	7m25s
psql	350	23m7s	3s963ms

Checkpoints Buffers

Key values

10,936 buffers Checkpoint Peak
2025-12-11 06:08:03 Date
210.034 seconds Highest write time
0.029 seconds Sync time

Checkpoints Wal files

Key values

5 files Wal files usage Peak
2025-12-11 06:08:03 Date

Checkpoints distance

Key values

174.79 Mo Distance Peak
2025-12-11 06:08:03 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Dec 11	06	30,599	1,777.264s	0.128s	1,777.723s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Dec 11	06	0	0	19	1,834	0.011s	0s

Day	Hour	Count	Avg time (sec)
Dec 11	06	0	0s

Day	Hour	Mean distance	Mean estimate
Dec 11	06	26,022.33 kB	62,702.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

252.43 MiB Temp Files size Peak
2025-12-11 06:20:15 Date

Number of temporary files

Key values

31 per second Temp Files Peak
2025-12-11 06:47:27 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Dec 11	06	755	5.11 GiB	6.93 MiB

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)


Date: 2025-12-11 06:01:10
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 182.165.1.42
Application: [unknown]
Date: 2025-12-11 06:20:15
Duration: 13s376ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.90
Application: [unknown]
Date: 2025-12-11 06:31:17
Duration: 5s525ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-12-11 06:26:22
Duration: 4s913ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-12-11 06:17:53
Duration: 9s822ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-12-11 06:17:43
Duration: 40s199ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	203	857.15 MiB	3.27 MiB	9.89 MiB	4.22 MiB	with rar_max as ( ; WITH rar_max as ( ; Date: 2025-12-11 06:01:10 Duration: 0ms Database: acaweb_fx User: postgres Remote: 182.165.1.42 Application: [unknown]
2	42	1.75 GiB	3.64 MiB	127.61 MiB	42.59 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-12-11 06:20:15 Duration: 13s376ms 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-12-11 06:40:11 Duration: 9s420ms 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-12-11 06:30:12 Duration: 9s119ms Database: acaweb_fx User: postgres Remote: 192.168.1.90 Application: [unknown]
3	13	407.76 MiB	31.36 MiB	31.37 MiB	31.37 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-12-11 06:31:17 Duration: 5s525ms 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-12-11 06:26:17 Duration: 5s523ms 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-12-11 06:41:15 Duration: 3s395ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
4	13	891.30 MiB	68.55 MiB	68.56 MiB	68.56 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-12-11 06:26:22 Duration: 4s913ms 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-12-11 06:41:20 Duration: 4s697ms 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-12-11 06:20:15 Duration: 2s997ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
5	8	939.47 MiB	117.42 MiB	117.45 MiB	117.43 MiB	select updateresultsmaterializedview (); select updateresultsmaterializedview (); Date: 2025-12-11 06:17:53 Duration: 9s822ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateresultsmaterializedview (); Date: 2025-12-11 06:32:49 Duration: 8s430ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateresultsmaterializedview (); Date: 2025-12-11 06:20:42 Duration: 6s903ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
6	4	346.62 MiB	86.62 MiB	86.72 MiB	86.66 MiB	select updateageforrelevantresults (); select updateageforrelevantresults (); Date: 2025-12-11 06:17:43 Duration: 40s199ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateageforrelevantresults (); Date: 2025-12-11 06:32:41 Duration: 38s344ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateageforrelevantresults (); Date: 2025-12-11 06:47:35 Duration: 32s861ms Database: acaweb_fx User: postgres Remote: [local] Application: psql

Queries generating the largest temporary files


[ Date: 2025-12-11 06:30:09 ]
[ Date: 2025-12-11 06:32:43 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-12-11 06:02:15 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-12-11 06:47:37 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-12-11 06:17:45 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-12-11 06:20:37 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-12-11 06:35:41 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-12-11 06:05:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-12-11 06:50:36 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-12-11 06:20:12 ]
[ Date: 2025-12-11 06:00:04 ]
[ Date: 2025-12-11 06:10:06 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
[ Date: 2025-12-11 06:40:09 ]
[ Date: 2025-12-11 06:50:09 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
[ Date: 2025-12-11 06:10:05 ]
[ Date: 2025-12-11 06:40:08 ]
[ Date: 2025-12-11 06:02:05 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-12-11 06:32:22 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-12-11 06:47:21 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-12-11 06:17:21 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

Rank	Size	Query
1	127.61 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-12-11 06:30:09 ]
2	117.45 MiB	select updateresultsmaterializedview (); [ Date: 2025-12-11 06:32:43 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
3	117.44 MiB	select updateresultsmaterializedview (); [ Date: 2025-12-11 06:02:15 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
4	117.44 MiB	select updateresultsmaterializedview (); [ Date: 2025-12-11 06:47:37 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
5	117.43 MiB	select updateresultsmaterializedview (); [ Date: 2025-12-11 06:17:45 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
6	117.43 MiB	select updateresultsmaterializedview (); [ Date: 2025-12-11 06:20:37 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
7	117.43 MiB	select updateresultsmaterializedview (); [ Date: 2025-12-11 06:35:41 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
8	117.43 MiB	select updateresultsmaterializedview (); [ Date: 2025-12-11 06:05:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
9	117.42 MiB	select updateresultsmaterializedview (); [ Date: 2025-12-11 06:50:36 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
10	116.09 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-12-11 06:20:12 ]
11	101.92 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-12-11 06:00:04 ]
12	101.50 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-12-11 06:10:06 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
13	91.49 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 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-12-11 06:40:09 ]
14	90.98 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-12-11 06:50:09 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
15	88.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-12-11 06:10:05 ]
16	87.30 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-12-11 06:40:08 ]
17	86.72 MiB	select updateageforrelevantresults (); [ Date: 2025-12-11 06:02:05 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
18	86.66 MiB	select updateageforrelevantresults (); [ Date: 2025-12-11 06:32:22 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
19	86.62 MiB	select updateageforrelevantresults (); [ Date: 2025-12-11 06:47:21 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
20	86.62 MiB	select updateageforrelevantresults (); [ Date: 2025-12-11 06:17:21 - 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)
48 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	4
acaweb_fx.pg_catalog.pg_class	4
acaweb_fx.public.latest_t15_candle_view	3
acaweb_fx.public.relevance_keylevels_results	3
acaweb_fx.pg_catalog.pg_type	3
acaweb_fx.public.relevance_autochartist_results	3
acaweb_fx.pg_catalog.pg_index	2
acaweb_fx.public.relevance_fibonacci_results	2
acaweb_fx.public.autochartist_symbolupdates	1
acaweb_fx.public.solr_imports	1
acaweb_fx.pg_catalog.pg_depend	1
acaweb_fx.public.latest_candle_datetime_per_receng	1
acaweb_fx.public.relevance_consecutivecandles_results	1
acaweb_fx.public.t15	1
Total	48

Vacuums per table

Key values

public.solr_relevance_old (14) Main table vacuumed on database acaweb_fx
37 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	14	13	9,785	0	44	0	57	6,852	12	1,207,963
acaweb_fx.public.datafeeds_latestrun	5	0	588	0	18	0	0	55	17	72,719
acaweb_fx.pg_toast.pg_toast_2619	2	2	291	0	66	0	0	224	57	249,431
acaweb_fx.pg_catalog.pg_attribute	2	2	1,659	0	292	0	134	753	236	1,480,460
acaweb_fx.public.latest_t15_candle_view	2	2	138	0	8	0	0	12	2	17,611
acaweb_fx.public.relevance_keylevels_results	2	2	7,283	0	560	4	202	1,529	834	2,327,953
acaweb_fx.public.relevance_autochartist_results	2	2	6,598	0	325	5	496	974	310	863,653
acaweb_fx.pg_catalog.pg_class	2	2	904	0	98	0	0	298	97	465,397
acaweb_fx.pg_catalog.pg_type	1	1	129	0	19	0	0	44	19	131,939
acaweb_fx.public.autochartist_symbolupdates	1	1	21,413	0	4,957	8	38,063	6,575	4,845	2,081,305
acaweb_fx.pg_catalog.pg_statistic	1	1	1,005	0	134	0	582	571	121	585,200
acaweb_fx.public.solr_imports	1	1	65	0	3	0	0	6	1	7,902
acaweb_fx.pg_catalog.pg_depend	1	1	355	0	83	0	59	181	75	455,622
acaweb_fx.public.relevance_fibonacci_results	1	1	1,196	0	80	0	55	180	65	164,026
Total	37	31	51,409	47,968	6,687	17	39,648	18,254	6,691	10,111,181

Tuples removed per table

Key values

public.solr_relevance_old (60798) Main table with removed tuples on database acaweb_fx
72634 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
acaweb_fx.public.solr_relevance_old	14	13	60,798	82,418	8,418	0	2,461
acaweb_fx.public.autochartist_symbolupdates	1	1	5,101	48,560	333	0	40,691
acaweb_fx.pg_catalog.pg_attribute	2	2	2,597	21,717	389	16	492
acaweb_fx.public.relevance_keylevels_results	2	2	923	23,853	291	0	558
acaweb_fx.pg_catalog.pg_statistic	1	1	773	3,683	0	0	1,194
acaweb_fx.public.relevance_autochartist_results	2	2	729	16,890	1,147	0	760
acaweb_fx.pg_catalog.pg_class	2	2	524	3,343	59	0	300
acaweb_fx.pg_catalog.pg_depend	1	1	515	14,157	0	0	131
acaweb_fx.public.datafeeds_latestrun	5	0	215	154	84	0	80
acaweb_fx.pg_toast.pg_toast_2619	2	2	164	350	8	0	104
acaweb_fx.public.relevance_fibonacci_results	1	1	154	1,192	0	0	102
acaweb_fx.public.latest_t15_candle_view	2	2	92	53	25	0	2
acaweb_fx.public.solr_imports	1	1	48	5	4	0	2
acaweb_fx.pg_catalog.pg_type	1	1	1	1,526	94	0	39
Total	37	31	72,634	217,901	10,852	16	46,916

Pages removed per table

Key values

pg_catalog.pg_attribute (16) Main table with removed pages on database acaweb_fx
16 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
acaweb_fx.pg_catalog.pg_attribute	2	2	2597	16
acaweb_fx.pg_toast.pg_toast_2619	2	2	164	0
acaweb_fx.pg_catalog.pg_type	1	1	1	0
acaweb_fx.public.autochartist_symbolupdates	1	1	5101	0
acaweb_fx.public.datafeeds_latestrun	5	0	215	0
acaweb_fx.pg_catalog.pg_statistic	1	1	773	0
acaweb_fx.public.solr_imports	1	1	48	0
acaweb_fx.pg_catalog.pg_depend	1	1	515	0
acaweb_fx.public.latest_t15_candle_view	2	2	92	0
acaweb_fx.public.relevance_keylevels_results	2	2	923	0
acaweb_fx.public.solr_relevance_old	14	13	60798	0
acaweb_fx.public.relevance_autochartist_results	2	2	729	0
acaweb_fx.pg_catalog.pg_class	2	2	524	0
acaweb_fx.public.relevance_fibonacci_results	1	1	154	0
Total	37	31	72,634	16

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Dec 11	06	37	48

↑ 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	17m43s	8m51s
	relation	2	17m43s	8m51s
AccessShareLock		1	1m14s	1m14s
	relation	1	1m14s	1m14s
	Total	3	18m58s	6m19s

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	1	14m47s	14m47s	14m47s	14m47s	truncate table solr_relevance_old; TRUNCATE TABLE solr_relevance_old; Date: 2025-12-11 06:19:58 Database: acaweb_fx User: postgres Remote: [local] Application: psql TRUNCATE TABLE solr_relevance_old; Date: 2025-12-11 06:50:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql TRUNCATE TABLE solr_relevance_old; Date: 2025-12-11 06:20:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql
2	1	2m56s	2m56s	2m56s	2m56s	refresh materialized view latest_candle_datetime_per_receng; refresh materialized view latest_candle_datetime_per_receng; Date: 2025-12-11 06:19:59 Database: acaweb_fx User: postgres Remote: [local] Application: psql refresh materialized view latest_candle_datetime_per_receng; Date: 2025-12-11 06:47:02 Database: acaweb_fx User: postgres Remote: [local] Application: psql refresh materialized view latest_candle_datetime_per_receng; Date: 2025-12-11 06:32:02 Database: acaweb_fx User: postgres Remote: [local] Application: psql
3	1	1m14s	1m14s	1m14s	1m14s	select recognitionengine, to_char(datetimeupdate, ?) from latest_candle_datetime_per_receng; select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng; Date: 2025-12-11 06:08:44 Database: acaweb_fx User: postgres Remote: 192.168.1.90 Application: PostgreSQL JDBC Driver Bind query: yes select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng; Date: 2025-12-11 06:55:23 Database: acaweb_fx User: postgres Remote: 192.168.1.90 Application: PostgreSQL JDBC Driver Bind query: yes select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng; Date: 2025-12-11 06:03:44 Database: acaweb_fx User: postgres Remote: 192.168.1.90 Application: PostgreSQL JDBC Driver Bind query: yes

Rank

Count

Total time

Min time

Max time

Avg duration

Query

1

14m47s

truncate table solr_relevance_old;

TRUNCATE TABLE solr_relevance_old;

Date: 2025-12-11 06:19:58 Database: acaweb_fx User: postgres Remote: [local] Application: psql
TRUNCATE TABLE solr_relevance_old;

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

Date: 2025-12-11 06:20:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql

2

1

2m56s

refresh materialized view latest_candle_datetime_per_receng;

refresh materialized view latest_candle_datetime_per_receng;

Date: 2025-12-11 06:19:59 Database: acaweb_fx User: postgres Remote: [local] Application: psql
refresh materialized view latest_candle_datetime_per_receng;

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

Date: 2025-12-11 06:32:02 Database: acaweb_fx User: postgres Remote: [local] Application: psql

3

1

1m14s

select recognitionengine, to_char(datetimeupdate, ?) from latest_candle_datetime_per_receng;

select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng;

Date: 2025-12-11 06:08:44 Database: acaweb_fx User: postgres Remote: 192.168.1.90 Application: PostgreSQL JDBC Driver Bind query: yes
select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng;

Date: 2025-12-11 06:55:23 Database: acaweb_fx User: postgres Remote: 192.168.1.90 Application: PostgreSQL JDBC Driver Bind query: yes
select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng;

Date: 2025-12-11 06:03:44 Database: acaweb_fx User: postgres Remote: 192.168.1.90 Application: PostgreSQL JDBC Driver Bind query: yes

Queries that waited the most

Rank	Wait time	Query
1	14m47s	TRUNCATE TABLE solr_relevance_old; [ Date: 2025-12-11 06:19:58 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	2m56s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2025-12-11 06:19:58 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
3	1m14s	select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng; [ Date: 2025-12-11 06:19:59 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: PostgreSQL JDBC Driver ]

Rank

Wait time

Query

1

14m47s

TRUNCATE TABLE solr_relevance_old;

[ Date: 2025-12-11 06:19:58 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

2

2m56s

refresh materialized view latest_candle_datetime_per_receng;

[ Date: 2025-12-11 06:19:58 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

3

1m14s

select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng;

[ Date: 2025-12-11 06:19:59 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: PostgreSQL JDBC Driver ]

Queries by type

Key values

64,191 Total read queries
40,114 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	64,191	58.28%
INSERT	26,074	23.67%
UPDATE	1,879	1.71%
DELETE	13	0.01%
COPY FROM	78	0.07%
COPY TO	601	0.55%
CTE	10,773	9.78%
DDL	13	0.01%
TCL	683	0.62%
CURSOR	0	0.00%
OTHERS	5,838	5.30%

Queries by database

Key values

acaweb_fx Main database
97,312 Requests
3h27m41s (acaweb_fx)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
acaweb_fx	Total	97,312	3h27m41s
	copy from	78	5s219ms
	copy to	306	14m57s
	cte	10,769	2h47m35s
	ddl	13	14m47s
	delete	13	20ms
	insert	17,921	24s92ms
	others	5,507	3m28s
	select	60,203	5m49s
	tcl	679	201ms
	update	1,823	33s977ms
acaweb_fx_integer	Total	3,589	20m18s
	copy to	276	20m17s
	cte	1	5ms
	others	285	20ms
	select	3,026	1s125ms
	tcl	1	0ms
postgres	Total	367	276ms
	cte	1	2ms
	others	9	0ms
	select	356	273ms
	tcl	1	0ms
socialmedia	Total	8,828	1m45s
	copy to	19	1m34s
	cte	1	2ms
	insert	8,153	10s128ms
	others	28	0ms
	select	570	598ms
	tcl	1	0ms
	update	56	112ms
translations	Total	47	203ms
	cte	1	2ms
	others	9	0ms
	select	36	200ms
	tcl	1	0ms

Queries by user

Key values

postgres Main user
110,143 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	110,143	3h49m46s
	copy from	78	5s219ms
	copy to	601	36m50s
	cte	10,773	2h47m35s
	ddl	13	14m47s
	delete	13	20ms
	insert	26,074	34s220ms
	others	5,838	3m28s
	select	64,191	5m51s
	tcl	683	201ms
	update	1,879	34s90ms

Duration by user

Key values

3h49m46s (postgres) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	110,143	3h49m46s
	copy from	78	5s219ms
	copy to	601	36m50s
	cte	10,773	2h47m35s
	ddl	13	14m47s
	delete	13	20ms
	insert	26,074	34s220ms
	others	5,838	3m28s
	select	64,191	5m51s
	tcl	683	201ms
	update	1,879	34s90ms

Queries by host

Key values

192.168.0.74 Main host
24,019 Requests
52m21s (192.168.0.74)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	15,874	37m53s
	copy to	601	36m50s
	cte	25	226ms
	insert	5,525	9s962ms
	others	620	26ms
	select	7,785	52s123ms
	tcl	5	0ms
	update	1,313	1s382ms
182.165.1.42	Total	148	8m58s
	cte	60	8m58s
	select	88	81ms
192.168.0.114	Total	39	78ms
	others	3	0ms
	select	12	70ms
	tcl	18	6ms
	update	6	0ms
192.168.0.216	Total	404	347ms
	others	202	21ms
	select	194	235ms
	update	8	90ms
192.168.0.236	Total	18	21ms
	cte	1	0ms
	select	17	21ms
192.168.0.239	Total	213	2s939ms
	select	213	2s939ms
192.168.0.42	Total	893	4s23ms
	insert	273	44ms
	select	620	3s978ms
192.168.0.74	Total	24,019	52m21s
	cte	3,920	52m3s
	others	864	10ms
	select	19,235	18s70ms
192.168.1.135	Total	92	199ms
	cte	3	68ms
	select	89	131ms
192.168.1.145	Total	8,040	26m50s
	cte	1,435	26m44s
	others	56	0ms
	select	6,549	6s145ms
192.168.1.15	Total	23,751	52m7s
	cte	3,702	51m52s
	others	1,680	20ms
	select	18,369	15s513ms
192.168.1.20	Total	8,100	26m14s
	cte	1,434	26m7s
	others	112	1ms
	select	6,554	6s882ms
192.168.1.201	Total	1,140	7s388ms
	select	1,140	7s388ms
192.168.1.210	Total	12	2ms
	select	12	2ms
192.168.1.231	Total	40	0ms
	others	40	0ms
192.168.1.239	Total	8	9ms
	others	4	0ms
	select	4	8ms
192.168.1.90	Total	90	53s7ms
	cte	6	52s933ms
	others	20	0ms
	select	64	73ms
192.168.1.97	Total	10	9ms
	cte	1	0ms
	select	9	9ms
192.168.2.126	Total	80	62ms
	others	18	0ms
	select	62	62ms
192.168.2.182	Total	48	296ms
	others	24	2ms
	select	12	11ms
	update	12	282ms
192.168.2.82	Total	753	2s370ms
	insert	413	1s532ms
	others	96	11ms
	select	152	113ms
	update	92	712ms
192.168.3.199	Total	144	207ms
	others	72	8ms
	select	60	69ms
	update	12	130ms
192.168.4.105	Total	628	1s130ms
	cte	95	624ms
	others	12	0ms
	select	521	505ms
192.168.4.142	Total	15,691	21s544ms
	insert	11,708	12s545ms
	others	1,942	24ms
	select	2,041	8s973ms
192.168.4.150	Total	22	2s219ms
	others	21	0ms
	select	1	2s219ms
192.168.4.164	Total	3	158ms
	cte	1	158ms
	others	2	0ms
192.168.4.238	Total	42	14s639ms
	cte	12	14s632ms
	insert	2	6ms
	others	28	0ms
192.168.4.33	Total	8,537	10s529ms
	insert	8,153	10s128ms
	select	328	288ms
	update	56	112ms
192.168.4.96	Total	18	1ms
	others	12	0ms
	select	4	1ms
	update	2	0ms
192.168.4.98	Total	996	29s150ms
	others	6	28s244ms
	select	6	33ms
	tcl	660	194ms
	update	324	677ms
[local]	Total	290	22m49s
	copy from	78	5s219ms
	cte	78	40s956ms
	ddl	13	14m47s
	delete	13	20ms
	others	4	2m59s
	select	50	3m45s
	update	54	30s701ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
80,346 Requests
2h38m28s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	80,346	2h38m28s
	cte	10,602	2h37m2s
	insert	11,983	12s596ms
	others	2,393	35ms
	select	55,366	1m12s
	update	2	0ms
[unknown]	Total	20,925	11m34s
	cte	68	9m51s
	insert	14,091	21s623ms
	others	2,821	28s314ms
	select	1,456	49s932ms
	tcl	678	201ms
	update	1,811	3s361ms
pg_dump	Total	8,470	36m37s
	copy to	575	36m34s
	cte	5	19ms
	others	620	26ms
	select	7,265	3s21ms
	tcl	5	0ms
psql	Total	402	23m5s
	copy from	78	5s219ms
	copy to	26	15s656ms
	cte	98	41s162ms
	ddl	13	14m47s
	delete	13	20ms
	others	4	2m59s
	select	104	3m45s
	update	66	30s728ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-12-11 06:19:24 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

72,240 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	72,240	65.59%
1-5ms	32,201	29.24%
5-10ms	1,635	1.48%
10-25ms	939	0.85%
25-50ms	411	0.37%
50-100ms	387	0.35%
100-500ms	690	0.63%
500-1000ms	202	0.18%
1000-10000ms	1,090	0.99%
> 10000ms	348	0.32%

Slowest individual queries


[ Date: 2025-12-11 06:19:58 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-12-11 06:08:21 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-12-11 06:19:59 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-12-11 06:33:23 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-12-11 06:14:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-12-11 06:22:27 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-12-11 06:37:52 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-12-11 06:25:41 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-12-11 06:42:05 - Database: socialmedia - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-12-11 06:24:02 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-12-11 06:15:56 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-12-11 06:11:37 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-12-11 06:29:14 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-12-11 06:30:23 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-12-11 06:18:35 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-12-11 06:16:56 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-12-11 06:28:05 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-12-11 06:17:29 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-12-11 06:18:04 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-12-11 06:39:35 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]

Rank	Duration	Query
1	14m47s	TRUNCATE TABLE solr_relevance_old; [ Date: 2025-12-11 06:19:58 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	3m18s	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-12-11 06:08:21 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
3	2m57s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2025-12-11 06:19:59 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
4	2m55s	COPY public.researchreports (researchreportid, type, createddatetime, language, filename, xml) TO stdout; [ Date: 2025-12-11 06:33:23 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
5	2m46s	COPY public.researchreports (researchreportid, type, createddatetime, language, filename, xml) TO stdout; [ Date: 2025-12-11 06:14:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
6	2m27s	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-12-11 06:22:27 - 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-12-11 06:37:52 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
8	1m38s	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-12-11 06:25:41 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
9	1m31s	COPY public.executionlogs (id, executionid, eventdate, status, message, details, detailtype) TO stdout; [ Date: 2025-12-11 06:42:05 - Database: socialmedia - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
10	1m27s	COPY public.authenticationlog (attemptid, username, password, brokerid, authclass, attemptdatetime, success, fingerprint, accounttype) TO stdout; [ Date: 2025-12-11 06:24:02 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
11	1m20s	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-12-11 06:15:56 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
12	1m16s	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-12-11 06:11:37 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
13	1m10s	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-12-11 06:29:14 - Database: acaweb_fx_integer - 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-12-11 06:30:23 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
15	1m5s	COPY public.t15_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2025-12-11 06:18:35 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
16	1m5s	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-12-11 06:16:56 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17	1m4s	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-12-11 06:28:05 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18	1m	COPY public.t15_hve (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived, pricesadjusted, relevanceprocessed, recengprocessedadjusted) TO stdout; [ Date: 2025-12-11 06:17:29 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
19	59s942ms	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-12-11 06:18:04 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20	58s879ms	COPY public.t30_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2025-12-11 06:39:35 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]

Time consuming queries


[ User: postgres - Total duration: 1h20m58s - Times executed: 477 ]
[ User: postgres - Total duration: 58m46s - Times executed: 479 ]
[ User: postgres - Total duration: 21m41s - Times executed: 432 ]
[ User: postgres - Total duration: 14m47s - Times executed: 13 ]
[ User: postgres - Total duration: 5m45s - Times executed: 2 ]
[ User: postgres - Total duration: 5m41s - Times executed: 2 ]
[ User: postgres - Total duration: 3m9s - Times executed: 2 ]
[ User: postgres - Total duration: 2m59s - Times executed: 4 ]
[ User: postgres - Total duration: 2m48s - Times executed: 320 ]
[ User: postgres - Total duration: 2m24s - Times executed: 2 ]
[ User: postgres - Total duration: 2m10s - Times executed: 2 ]
[ User: postgres - Total duration: 2m3s - Times executed: 4 ]
[ User: postgres - Total duration: 1m54s - Times executed: 2 ]
[ User: postgres - Total duration: 1m51s - Times executed: 2 ]
[ User: postgres - Total duration: 1m40s - Times executed: 2 ]
[ User: postgres - Total duration: 1m32s - Times executed: 2 ]
[ User: postgres - Total duration: 1m31s - Times executed: 1 ]
[ User: postgres - Total duration: 1m22s - Times executed: 2 ]
[ User: postgres - Total duration: 1m8s - Times executed: 120 ]
[ User: postgres - Total duration: 57s477ms - Times executed: 2 ]

Most frequent queries (N)


[ User: postgres - Total duration: 153ms - Times executed: 30753 ]
[ User: postgres - Total duration: 23s398ms - Times executed: 17030 ]
[ User: postgres - Total duration: 9s862ms - Times executed: 7972 ]
[ User: postgres - Total duration: 5s957ms - Times executed: 6295 ]
[ User: postgres - Total duration: 7s701ms - Times executed: 5569 ]
[ User: postgres - Total duration: 3s268ms - Times executed: 3306 ]
[ User: postgres - Total duration: 3s901ms - Times executed: 2570 ]
[ User: postgres - Total duration: 24ms - Times executed: 2414 ]
[ User: postgres - Total duration: 35ms - Times executed: 2388 ]
[ User: postgres - Total duration: 3s869ms - Times executed: 2298 ]
[ User: postgres - Total duration: 1s86ms - Times executed: 2272 ]
[ User: postgres - Total duration: 1s85ms - Times executed: 1807 ]
[ User: postgres - Total duration: 1s324ms - Times executed: 1697 ]
[ User: postgres - Total duration: 33ms - Times executed: 1650 ]
[ User: postgres - Total duration: 1s356ms - Times executed: 1301 ]
[ User: postgres - Total duration: 3s927ms - Times executed: 1020 ]
[ User: postgres - Total duration: 128ms - Times executed: 968 ]
[ User: postgres - Total duration: 7s549ms - Times executed: 853 ]
[ User: postgres - Total duration: 251ms - Times executed: 777 ]
[ User: postgres - Total duration: 107ms - Times executed: 649 ]

Normalized slowest queries (N)


[ User: postgres - Total duration: 5m45s - Times executed: 2 ]
[ User: postgres - Total duration: 5m41s - Times executed: 2 ]
[ User: postgres - Total duration: 3m9s - Times executed: 2 ]
[ User: postgres - Total duration: 1m31s - Times executed: 1 ]
[ User: postgres - Total duration: 2m24s - Times executed: 2 ]
[ User: postgres - Total duration: 14m47s - Times executed: 13 ]
[ User: postgres - Total duration: 2m10s - Times executed: 2 ]
[ User: postgres - Total duration: 1m54s - Times executed: 2 ]
[ User: postgres - Total duration: 1m51s - Times executed: 2 ]
[ User: postgres - Total duration: 1m40s - Times executed: 2 ]
[ User: postgres - Total duration: 1m32s - Times executed: 2 ]
[ User: postgres - Total duration: 2m59s - Times executed: 4 ]
[ User: postgres - Total duration: 1m22s - Times executed: 2 ]
[ User: postgres - Total duration: 2m3s - Times executed: 4 ]
[ User: postgres - Total duration: 57s477ms - Times executed: 2 ]
[ User: postgres - Total duration: 1h20m58s - Times executed: 477 ]
[ User: postgres - Total duration: 58m46s - Times executed: 479 ]
[ User: postgres - Total duration: 21m41s - Times executed: 432 ]
[ User: postgres - Total duration: 1m8s - Times executed: 120 ]
[ User: postgres - Total duration: 2m48s - Times executed: 320 ]

Time consuming prepare


[ User: postgres - Total duration: 0ms - Times executed: 6 ]
[ User: postgres - Total duration: 1h51m5s - Times executed: 4033 ]
[ User: postgres - Total duration: 19s988ms - Times executed: 3752 ]
[ User: postgres - Total duration: 7s853ms - Times executed: 956 ]
[ User: postgres - Total duration: 1s22ms - Times executed: 523 ]
[ User: postgres - Total duration: 24ms - Times executed: 2414 ]
[ User: postgres - Total duration: 3s26ms - Times executed: 3168 ]
[ User: postgres - Total duration: 1s30ms - Times executed: 2115 ]
[ User: postgres - Total duration: 14ms - Times executed: 2645 ]
[ User: postgres - Total duration: 2s960ms - Times executed: 861 ]
[ User: postgres - Total duration: 14s632ms - Times executed: 12 ]
[ User: postgres - Total duration: 34ms - Times executed: 18 ]
[ User: postgres - Total duration: 351ms - Times executed: 250 ]
[ User: postgres - Total duration: 137ms - Times executed: 311 ]
[ User: postgres - Total duration: 35ms - Times executed: 2388 ]
[ User: postgres - Total duration: 7s667ms - Times executed: 15 ]
[ User: postgres - Total duration: 52s933ms - Times executed: 6 ]
[ User: postgres - Total duration: 1ms - Times executed: 115 ]
[ User: postgres - Total duration: 56ms - Times executed: 24 ]
[ User: postgres - Total duration: 10ms - Times executed: 6 ]

Time consuming bind


[ User: postgres - Total duration: 2h44m37s - Times executed: 10423 ]
[ User: postgres - Total duration: 46s128ms - Times executed: 22184 ]
[ User: postgres - Total duration: 7s853ms - Times executed: 956 ]
[ User: postgres - Total duration: 1s22ms - Times executed: 523 ]
[ User: postgres - Total duration: 1m8s - Times executed: 120 ]
[ User: postgres - Total duration: 143ms - Times executed: 30630 ]
[ User: postgres - Total duration: 1ms - Times executed: 63 ]
[ User: postgres - Total duration: 341ms - Times executed: 18 ]
[ User: postgres - Total duration: 14s632ms - Times executed: 12 ]
[ User: postgres - Total duration: 7s701ms - Times executed: 5569 ]
[ User: postgres - Total duration: 3s268ms - Times executed: 3306 ]
[ User: postgres - Total duration: 1s86ms - Times executed: 2272 ]
[ User: postgres - Total duration: 52s933ms - Times executed: 6 ]
[ User: postgres - Total duration: 158ms - Times executed: 1 ]
[ User: postgres - Total duration: 721ms - Times executed: 49 ]
[ User: postgres - Total duration: 802ms - Times executed: 9 ]
[ User: postgres - Total duration: 1ms - Times executed: 115 ]
[ User: postgres - Total duration: 137ms - Times executed: 311 ]
[ User: postgres - Total duration: 351ms - Times executed: 250 ]
[ User: postgres - Total duration: 509ms - Times executed: 4 ]

Log levels

Key values

324,005 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	412	0.13%
DETAIL	94,738	29.24%
ERROR	1	0.00%
LOG	228,306	70.46%
STATEMENT	548	0.17%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
5 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

4 Max number of times the same event was reported
5 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
Dec 11	06	4

LOG: process 23621 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 1000.055 ms
LOG: process 23621 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 51042.501 ms
LOG: process 28304 still waiting for AccessExclusiveLock on relation 5894441 of database 5881926 after 1000.058 ms

2

1

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Dec 11	06	1

LOG: process 28914 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.052 ms at character 77

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

Queries generating the most temporary files (N)

Queries generating the largest temporary files

Vacuums

Vacuums / Analyzes Distribution

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Autovacuum Activity

Locks

Locks by types

Key values

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values

Queries by user

Key values

Duration by user

Key values