pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Tue Oct 14 04:59:58 2025
Log file: /home/postgres/pg_data/data/pg_log/postgresql-2025-10-14_060000.log
Parsed 2,200,263 log entries in 57s
Log start from 2025-10-14 06:00:00 to 2025-10-14 06:59:55

Global Stats

1,126 Number of unique normalized queries
126,707 Number of queries
4h14m3s Total query duration
2025-10-14 06:00:00 First query
2025-10-14 06:59:55 Last query
3,503 queries/s at 2025-10-14 06:05:02 Query peak

4h14m3s Total query duration
47s834ms Prepare/parse total duration
1m28s Bind total duration
4h11m47s 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

40 Total number of automatic vacuums
50 Total number of automatic analyzes

734 Number temporary file
163.95 MiB Max size of temporary file
6.56 MiB Average size of temporary file

4,691 Total number of sessions
12 sessions at 2025-10-14 06:53:01 Session peak
2d23h7m38s Total duration of sessions
54s585ms Average duration of sessions
27 Average queries per session
3s249ms Average queries duration per session
51s335ms Average idle time per session

4,691 Total number of connections
46 connections/s at 2025-10-14 06:07:09 Connection peak
5 Total number of databases

SQL Traffic

Key values

3,503 queries/s Query Peak
2025-10-14 06:05:02 Date

SELECT Traffic

Key values

3,211 queries/s Query Peak
2025-10-14 06:05:02 Date

INSERT/UPDATE/DELETE Traffic

Key values

204 queries/s Query Peak
2025-10-14 06:00:54 Date

Queries duration

Key values

4h14m3s Total query duration

Prepared queries ratio

Key values

0.00 Ratio of bind vs prepare
0.00 % Ratio between prepared and "usual" statements

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Oct 14	06	126,707	0ms	15m6s	119ms	6m40s	7m49s	22m11s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Oct 14	06	72,669	600	35ms	1m11s	2m10s	3m4s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Oct 14	06	31,275	3,822	12	72	2ms	622ms	2s480ms	5s15ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Oct 14	06	32,077	92,775	2.89	27.09%

Day	Hour	Count	Average / Second
Oct 14	06	4,691	1.30/s

Day	Hour	Count	Average Duration	Average idle time
Oct 14	06	4,691	54s585ms	51s364ms

↑ Back to the top of the General Activity table

Established Connections

Key values

46 connections Connection Peak
2025-10-14 06:07:09 Date

Connections per database

Key values

acaweb_fx Main Database
4,691 connections Total

Chart
Table

Database	User	Count
acaweb_fx		4,591
	pg_dump	1
	postgres	4,256
	psql	334
acaweb_fx_integer		1
	pg_dump	1
postgres		3
	pg_dump	1
	psql	2
socialmedia		95
	pg_dump	1
	postgres	94
translations		1
	pg_dump	1

Connections per user

Key values

postgres Main User
4,691 connections Total

Chart
Table

User	Count
pg_dump	5
postgres	4,350
psql	336

Connections per host

Key values

192.168.0.74 Main host with 1484 connections
4,691 Total connections

Chart
Table

Host	Count
127.0.0.1	115
192.168.0.114	2
192.168.0.216	101
192.168.0.74	1,484
192.168.1.145	86
192.168.1.15	807
192.168.1.20	114
192.168.1.231	20
192.168.1.239	1
192.168.1.90	58
192.168.2.126	62
192.168.2.182	12
192.168.2.82	48
192.168.3.199	33
192.168.4.142	1,072
192.168.4.150	10
192.168.4.238	12
192.168.4.246	1
192.168.4.33	93
192.168.4.86	4
192.168.4.98	330
[local]	226

Simultaneous sessions

Key values

12 sessions Session Peak
2025-10-14 06:53:01 Date

Histogram of session times

Key values

3,837 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	3,837	81.79%
500ms-1s	156	3.33%
1s-30s	427	9.10%
30s-1m	101	2.15%
1m-10m	89	1.90%
10m-30m	61	1.30%
30m-1h	4	0.09%
1h-8h	15	0.32%
> 8h	1	0.02%

Sessions per database

Key values

acaweb_fx Main Database
4,691 sessions Total

Chart
Table

Database	User	Count	Total Duration
acaweb_fx	4,591	2d22h32m11s	55s310ms
acaweb_fx_integer	1	20m44s	20m44s
postgres	3	428ms	142ms
socialmedia	95	14m40s	9s273ms
translations	1	232ms	232ms

Sessions per user

Key values

postgres Main User
4,691 sessions Total

Chart
Table

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

Sessions per host

Key values

192.168.0.74 Main Host
4,691 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	115	37m39s	19s645ms
192.168.0.114	2	10m1s	5m
192.168.0.216	101	1m23s	831ms
192.168.0.74	1,484	3h46m56s	9s175ms
192.168.1.145	86	13h34m31s	9m28s
192.168.1.15	807	4h32m5s	20s230ms
192.168.1.20	114	17h39m13s	9m17s
192.168.1.231	20	9h52m11s	29m36s
192.168.1.239	1	24ms	24ms
192.168.1.90	58	1m26s	1s498ms
192.168.2.126	62	6s747ms	108ms
192.168.2.182	12	1s617ms	134ms
192.168.2.82	48	6s976ms	145ms
192.168.3.199	33	1s38ms	31ms
192.168.4.142	1,072	9m42s	543ms
192.168.4.150	10	20h9m29s	2h56s
192.168.4.238	12	17s285ms	1s440ms
192.168.4.246	1	207ms	207ms
192.168.4.33	93	8m15s	5s331ms
192.168.4.86	4	39ms	9ms
192.168.4.98	330	30s253ms	91ms
[local]	226	23m35s	6s264ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
4,691 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	3,616	2d21h45m2s	1m9s
[unknown]	734	21m20s	1s744ms
pg_dump	5	37m26s	7m29s
psql	336	23m48s	4s252ms

Checkpoints Buffers

Key values

16,101 buffers Checkpoint Peak
2025-10-14 06:06:42 Date
209.866 seconds Highest write time
0.025 seconds Sync time

Checkpoints Wal files

Key values

6 files Wal files usage Peak
2025-10-14 06:06:42 Date

Checkpoints distance

Key values

203.58 Mo Distance Peak
2025-10-14 06:06:42 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Oct 14	06	48,082	1,797.452s	0.074s	1,797.885s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Oct 14	06	0	0	24	1,877	0.008s	0s

Day	Hour	Count	Avg time (sec)
Oct 14	06	0	0s

Day	Hour	Mean distance	Mean estimate
Oct 14	06	33,572.58 kB	75,514.75 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

182.24 MiB Temp Files size Peak
2025-10-14 06:20:11 Date

Number of temporary files

Key values

31 per second Temp Files Peak
2025-10-14 06:47:33 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Oct 14	06	734	4.70 GiB	6.56 MiB

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)


Date: 2025-10-14 06:00:13
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.15
Application: PostgreSQL JDBC Driver
Date: 2025-10-14 06:30:12
Duration: 9s738ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.90
Application: [unknown]
Date: 2025-10-14 06:41:16
Duration: 4s651ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-10-14 06:31:21
Duration: 5s82ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-10-14 06:17:53
Duration: 12s704ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-10-14 06:17:40
Duration: 38s858ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-10-14 06:20:40
Duration: 8s754ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	165	721.89 MiB	3.16 MiB	8.31 MiB	4.38 MiB	with rar_max as ( ; WITH rar_max as ( ; Date: 2025-10-14 06:00:13 Duration: 0ms Database: acaweb_fx User: postgres Remote: 192.168.1.15 Application: PostgreSQL JDBC Driver
2	40	1.72 GiB	2.64 MiB	163.95 MiB	44.01 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-10-14 06:30:12 Duration: 9s738ms 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-10-14 06:40:12 Duration: 9s466ms 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-10-14 06:20:11 Duration: 9s406ms Database: acaweb_fx User: postgres Remote: 192.168.1.90 Application: [unknown]
3	12	372.27 MiB	31.02 MiB	31.02 MiB	31.02 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-10-14 06:41:16 Duration: 4s651ms 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-10-14 06:31:15 Duration: 3s794ms 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-10-14 06:26:16 Duration: 3s558ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
4	12	753.08 MiB	62.75 MiB	62.76 MiB	62.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-10-14 06:31:21 Duration: 5s82ms 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-10-14 06:41:21 Duration: 4s941ms 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-10-14 06:26:21 Duration: 4s489ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
5	8	810.66 MiB	101.32 MiB	101.35 MiB	101.33 MiB	select updateresultsmaterializedview (); select updateresultsmaterializedview (); Date: 2025-10-14 06:17:53 Duration: 12s704ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateresultsmaterializedview (); Date: 2025-10-14 06:32:50 Duration: 11s567ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateresultsmaterializedview (); Date: 2025-10-14 06:47:53 Duration: 11s537ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
6	4	328.59 MiB	82.11 MiB	82.21 MiB	82.15 MiB	select updateageforrelevantresults (); select updateageforrelevantresults (); Date: 2025-10-14 06:17:40 Duration: 38s858ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateageforrelevantresults (); Date: 2025-10-14 06:47:41 Duration: 38s635ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateageforrelevantresults (); Date: 2025-10-14 06:32:38 Duration: 35s856ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
7	4	67.67 MiB	16.91 MiB	16.92 MiB	16.92 MiB	select updaterelevantforrelevantresults (); select updaterelevantforrelevantresults (); Date: 2025-10-14 06:20:40 Duration: 8s754ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updaterelevantforrelevantresults (); Date: 2025-10-14 06:35:38 Duration: 6s892ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updaterelevantforrelevantresults (); Date: 2025-10-14 06:50:33 Duration: 1s543ms Database: acaweb_fx User: postgres Remote: [local] Application: psql

Queries generating the largest temporary files


[ Date: 2025-10-14 06:30:08 ]
[ Date: 2025-10-14 06:50:10 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
[ Date: 2025-10-14 06:10:07 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
[ Date: 2025-10-14 06:20:08 ]
[ Date: 2025-10-14 06:00:04 ]
[ Date: 2025-10-14 06:32:40 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-14 06:47:43 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-14 06:17:43 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-14 06:35:38 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-14 06:20:40 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-14 06:50:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-14 06:02:23 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-14 06:05:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-14 06:40:09 ]
[ Date: 2025-10-14 06:00:04 ]
[ Date: 2025-10-14 06:02:06 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-14 06:32:23 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-14 06:17:23 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-14 06:47:24 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-14 06:40:09 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]

Rank	Size	Query
1	163.95 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-10-14 06:30:08 ]
2	150.85 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-10-14 06:50:10 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
3	143.24 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-10-14 06:10:07 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
4	133.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-10-14 06:20:08 ]
5	112.47 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-10-14 06:00:04 ]
6	101.35 MiB	select updateresultsmaterializedview (); [ Date: 2025-10-14 06:32:40 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
7	101.34 MiB	select updateresultsmaterializedview (); [ Date: 2025-10-14 06:47:43 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
8	101.34 MiB	select updateresultsmaterializedview (); [ Date: 2025-10-14 06:17:43 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
9	101.33 MiB	select updateresultsmaterializedview (); [ Date: 2025-10-14 06:35:38 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
10	101.33 MiB	select updateresultsmaterializedview (); [ Date: 2025-10-14 06:20:40 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
11	101.33 MiB	select updateresultsmaterializedview (); [ Date: 2025-10-14 06:50:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
12	101.32 MiB	select updateresultsmaterializedview (); [ Date: 2025-10-14 06:02:23 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
13	101.32 MiB	select updateresultsmaterializedview (); [ Date: 2025-10-14 06:05:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
14	88.53 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-10-14 06:40:09 ]
15	85.79 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-10-14 06:00:04 ]
16	82.21 MiB	select updateageforrelevantresults (); [ Date: 2025-10-14 06:02:06 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
17	82.16 MiB	select updateageforrelevantresults (); [ Date: 2025-10-14 06:32:23 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
18	82.11 MiB	select updateageforrelevantresults (); [ Date: 2025-10-14 06:17:23 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
19	82.11 MiB	select updateageforrelevantresults (); [ Date: 2025-10-14 06:47:24 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
20	73.17 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-10-14 06:40:09 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]

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)
50 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.public.relevance_keylevels_results	4
acaweb_fx.pg_catalog.pg_class	4
acaweb_fx.public.relevance_autochartist_results	4
acaweb_fx.pg_catalog.pg_type	3
acaweb_fx.public.latest_t15_candle_view	3
acaweb_fx.public.relevance_fibonacci_results	3
acaweb_fx.pg_catalog.pg_index	2
acaweb_fx.public.autochartist_symbolupdates	1
acaweb_fx.public.relevance_consecutivecandles_results	1
acaweb_fx.public.symbollatestupdatetime	1
acaweb_fx.pg_catalog.pg_depend	1
acaweb_fx.public.latest_candle_datetime_per_receng	1
Total	50

Vacuums per table

Key values

public.solr_relevance_old (14) Main table vacuumed on database acaweb_fx
40 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	12	11,275	0	45	0	0	8,008	98	1,458,856
acaweb_fx.public.datafeeds_latestrun	6	0	707	0	18	0	0	54	10	58,964
acaweb_fx.public.relevance_autochartist_results	3	3	10,471	0	311	4	714	1,959	1,126	3,230,094
acaweb_fx.pg_toast.pg_toast_2619	2	2	295	0	50	0	0	182	46	167,826
acaweb_fx.pg_catalog.pg_attribute	2	2	1,535	0	377	0	134	746	292	1,732,764
acaweb_fx.public.latest_t15_candle_view	2	2	157	0	8	0	0	12	2	17,161
acaweb_fx.public.relevance_keylevels_results	2	2	7,822	0	267	4	186	2,021	958	3,424,410
acaweb_fx.public.relevance_fibonacci_results	2	2	2,528	0	117	2	93	470	150	437,963
acaweb_fx.pg_catalog.pg_index	1	1	92	0	12	0	0	28	12	87,345
acaweb_fx.pg_catalog.pg_type	1	1	127	0	24	0	0	46	21	118,966
acaweb_fx.public.autochartist_symbolupdates	1	1	26,911	0	6,892	1	36,248	9,833	6,746	3,517,978
acaweb_fx.public.solr_imports	1	1	49	0	2	0	0	6	2	15,737
acaweb_fx.pg_catalog.pg_statistic	1	1	921	0	216	0	582	341	176	612,730
acaweb_fx.public.symbollatestupdatetime	1	0	1,441	0	235	0	620	823	235	600,719
acaweb_fx.pg_catalog.pg_class	1	1	457	0	38	0	0	163	38	210,166
Total	40	31	64,788	50,684	8,612	11	38,577	24,692	9,912	15,691,679

Tuples removed per table

Key values

public.solr_relevance_old (73517) Main table with removed tuples on database acaweb_fx
105312 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	12	73,517	94,929	14,896	0	2,903
acaweb_fx.public.symbollatestupdatetime	1	0	16,508	94,443	2,401	0	1,714
acaweb_fx.public.autochartist_symbolupdates	1	1	5,763	64,457	148	0	40,691
acaweb_fx.public.relevance_keylevels_results	2	2	3,268	24,878	0	0	558
acaweb_fx.pg_catalog.pg_attribute	2	2	2,241	19,824	806	0	480
acaweb_fx.public.relevance_autochartist_results	3	3	2,210	27,481	1,385	0	1,140
acaweb_fx.public.relevance_fibonacci_results	2	2	493	2,814	12	0	204
acaweb_fx.pg_catalog.pg_statistic	1	1	465	3,835	146	0	1,194
acaweb_fx.pg_catalog.pg_class	1	1	298	1,596	0	0	150
acaweb_fx.public.datafeeds_latestrun	6	0	205	246	162	0	96
acaweb_fx.pg_toast.pg_toast_2619	2	2	135	365	16	0	100
acaweb_fx.public.latest_t15_candle_view	2	2	105	39	11	0	2
acaweb_fx.public.solr_imports	1	1	52	1	0	0	2
acaweb_fx.pg_catalog.pg_type	1	1	34	1,395	55	0	38
acaweb_fx.pg_catalog.pg_index	1	1	18	825	12	0	22
Total	40	31	105,312	337,128	20,050	0	49,294

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_toast.pg_toast_2619	2	2	135
acaweb_fx.pg_catalog.pg_index	1	1	18
acaweb_fx.pg_catalog.pg_type	1	1	34
acaweb_fx.public.datafeeds_latestrun	6	0	205
acaweb_fx.public.autochartist_symbolupdates	1	1	5763
acaweb_fx.public.solr_imports	1	1	52
acaweb_fx.pg_catalog.pg_statistic	1	1	465
acaweb_fx.pg_catalog.pg_attribute	2	2	2241
acaweb_fx.public.symbollatestupdatetime	1	0	16508
acaweb_fx.public.latest_t15_candle_view	2	2	105
acaweb_fx.public.relevance_keylevels_results	2	2	3268
acaweb_fx.pg_catalog.pg_class	1	1	298
acaweb_fx.public.solr_relevance_old	14	12	73517
acaweb_fx.public.relevance_autochartist_results	3	3	2210
acaweb_fx.public.relevance_fibonacci_results	2	2	493
Total	40	31	105,312

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Oct 14	06	40	50

↑ 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	18m24s	9m12s
	relation	2	18m24s	9m12s
AccessShareLock		1	33s825ms	33s825ms
	relation	1	33s825ms	33s825ms
	Total	3	18m58s	6m19s

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	1	15m6s	15m6s	15m6s	15m6s	truncate table solr_relevance_old; TRUNCATE TABLE solr_relevance_old; Date: 2025-10-14 06:20:18 Database: acaweb_fx User: postgres Remote: [local] Application: psql TRUNCATE TABLE solr_relevance_old; Date: 2025-10-14 06:41:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql TRUNCATE TABLE solr_relevance_old; Date: 2025-10-14 06:26:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql
2	1	3m17s	3m17s	3m17s	3m17s	refresh materialized view latest_candle_datetime_per_receng; refresh materialized view latest_candle_datetime_per_receng; Date: 2025-10-14 06:20:19 Database: acaweb_fx User: postgres Remote: [local] Application: psql refresh materialized view latest_candle_datetime_per_receng; Date: 2025-10-14 06:47:03 Database: acaweb_fx User: postgres Remote: [local] Application: psql refresh materialized view latest_candle_datetime_per_receng; Date: 2025-10-14 06:32:03 Database: acaweb_fx User: postgres Remote: [local] Application: psql
3	1	33s825ms	33s825ms	33s825ms	33s825ms	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-10-14 06:09: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-10-14 06:20:19 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-10-14 06:50:10 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

15m6s

truncate table solr_relevance_old;

TRUNCATE TABLE solr_relevance_old;

Date: 2025-10-14 06:20:18 Database: acaweb_fx User: postgres Remote: [local] Application: psql
TRUNCATE TABLE solr_relevance_old;

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

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

2

1

3m17s

refresh materialized view latest_candle_datetime_per_receng;

refresh materialized view latest_candle_datetime_per_receng;

Date: 2025-10-14 06:20:19 Database: acaweb_fx User: postgres Remote: [local] Application: psql
refresh materialized view latest_candle_datetime_per_receng;

Date: 2025-10-14 06:47:03 Database: acaweb_fx User: postgres Remote: [local] Application: psql
refresh materialized view latest_candle_datetime_per_receng;

Date: 2025-10-14 06:32:03 Database: acaweb_fx User: postgres Remote: [local] Application: psql

3

1

33s825ms

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-10-14 06:09: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-10-14 06:20:19 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-10-14 06:50:10 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	15m6s	TRUNCATE TABLE solr_relevance_old; [ Date: 2025-10-14 06:20:18 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	3m17s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2025-10-14 06:20:18 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
3	33s825ms	select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng; [ Date: 2025-10-14 06:20:19 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: PostgreSQL JDBC Driver ]

Rank

Wait time

Query

1

15m6s

TRUNCATE TABLE solr_relevance_old;

[ Date: 2025-10-14 06:20:18 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

2

3m17s

refresh materialized view latest_candle_datetime_per_receng;

[ Date: 2025-10-14 06:20:18 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

3

33s825ms

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

[ Date: 2025-10-14 06:20:19 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: PostgreSQL JDBC Driver ]

Queries by type

Key values

72,669 Total read queries
45,745 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	72,669	57.35%
INSERT	31,275	24.68%
UPDATE	3,822	3.02%
DELETE	12	0.01%
COPY FROM	72	0.06%
COPY TO	600	0.47%
CTE	9,257	7.31%
DDL	12	0.01%
TCL	695	0.55%
CURSOR	0	0.00%
OTHERS	8,293	6.55%

Queries by database

Key values

acaweb_fx Main database
113,595 Requests
3h49m44s (acaweb_fx)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
acaweb_fx	Total	113,595	3h49m44s
	copy from	72	5s239ms
	copy to	305	15m14s
	cte	9,253	3h8m9s
	ddl	12	15m7s
	delete	12	20ms
	insert	23,102	36s630ms
	others	7,948	3m46s
	select	68,520	6m11s
	tcl	663	188ms
	update	3,708	33s943ms
acaweb_fx_integer	Total	3,589	20m28s
	copy to	276	20m26s
	cte	1	5ms
	others	285	20ms
	select	3,026	1s258ms
	tcl	1	0ms
postgres	Total	367	341ms
	cte	1	2ms
	others	9	0ms
	select	356	338ms
	tcl	1	0ms
socialmedia	Total	9,109	1m34s
	copy to	19	1m22s
	cte	1	2ms
	insert	8,173	9s482ms
	others	42	0ms
	select	731	1s753ms
	tcl	29	0ms
	update	114	233ms
translations	Total	47	219ms
	cte	1	2ms
	others	9	0ms
	select	36	216ms
	tcl	1	0ms

Queries by user

Key values

postgres Main user
126,707 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	126,707	4h11m47s
	copy from	72	5s239ms
	copy to	600	37m4s
	cte	9,257	3h8m9s
	ddl	12	15m7s
	delete	12	20ms
	insert	31,275	46s113ms
	others	8,293	3m46s
	select	72,669	6m15s
	tcl	695	188ms
	update	3,822	34s176ms

Duration by user

Key values

4h11m47s (postgres) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	126,707	4h11m47s
	copy from	72	5s239ms
	copy to	600	37m4s
	cte	9,257	3h8m9s
	ddl	12	15m7s
	delete	12	20ms
	insert	31,275	46s113ms
	others	8,293	3m46s
	select	72,669	6m15s
	tcl	695	188ms
	update	3,822	34s176ms

Queries by host

Key values

192.168.1.15 Main host
26,560 Requests
56m20s (192.168.1.15)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	21,951	38m6s
	copy to	600	37m4s
	cte	24	258ms
	insert	9,924	18s631ms
	others	619	25ms
	select	7,604	39s447ms
	tcl	5	0ms
	update	3,175	3s908ms
182.165.1.42	Total	120	9m13s
	cte	60	9m13s
	select	60	0ms
192.168.0.114	Total	75	150ms
	others	15	0ms
	select	30	149ms
	tcl	30	0ms
192.168.0.216	Total	404	438ms
	others	202	22ms
	select	194	258ms
	update	8	157ms
192.168.0.23	Total	6	5ms
	select	6	5ms
192.168.0.236	Total	20	3ms
	cte	3	0ms
	select	17	2ms
192.168.0.239	Total	387	3s773ms
	select	387	3s773ms
192.168.0.42	Total	1,294	2s999ms
	insert	422	66ms
	select	872	2s932ms
192.168.0.74	Total	18,016	55m15s
	cte	3,054	54m57s
	others	2,968	35ms
	select	11,994	17s803ms
192.168.1.135	Total	72	416ms
	cte	6	159ms
	select	66	256ms
192.168.1.145	Total	12,991	33m19s
	cte	849	33m2s
	others	172	1ms
	select	11,970	16s422ms
192.168.1.15	Total	26,560	56m20s
	cte	4,313	55m59s
	others	1,614	20ms
	select	20,633	20s592ms
192.168.1.20	Total	14,560	33m26s
	cte	853	33m8s
	others	228	2ms
	select	13,479	17s858ms
192.168.1.201	Total	1,769	8s678ms
	select	1,769	8s678ms
192.168.1.210	Total	10	3ms
	select	10	3ms
192.168.1.23	Total	1,562	7s919ms
	select	1,562	7s919ms
192.168.1.231	Total	40	0ms
	others	40	0ms
192.168.1.239	Total	4	7ms
	others	2	0ms
	select	2	6ms
192.168.1.90	Total	90	51s71ms
	cte	6	50s976ms
	others	20	0ms
	select	64	95ms
192.168.1.97	Total	24	3ms
	cte	4	0ms
	select	20	2ms
192.168.2.126	Total	80	77ms
	others	18	0ms
	select	62	76ms
192.168.2.182	Total	48	343ms
	others	24	2ms
	select	12	11ms
	update	12	328ms
192.168.2.82	Total	1,315	4s306ms
	insert	910	3s345ms
	others	96	11ms
	select	183	114ms
	update	126	835ms
192.168.3.199	Total	132	195ms
	others	66	7ms
	select	55	60ms
	update	11	127ms
192.168.4.142	Total	15,086	15s751ms
	insert	11,846	14s586ms
	others	2,144	24ms
	select	1,096	1s140ms
192.168.4.150	Total	22	2s275ms
	others	21	0ms
	select	1	2s275ms
192.168.4.238	Total	36	16s382ms
	cte	12	16s382ms
	others	24	0ms
192.168.4.246	Total	3	66ms
	cte	1	66ms
	others	2	0ms
192.168.4.33	Total	8,688	10s10ms
	insert	8,173	9s482ms
	select	401	294ms
	update	114	233ms
192.168.4.86	Total	12	1ms
	others	8	0ms
	select	4	1ms
192.168.4.98	Total	996	25s861ms
	others	6	25s7ms
	select	6	32ms
	tcl	660	188ms
	update	324	632ms
3.216.59.87	Total	60	1s54ms
	select	60	1s54ms
[local]	Total	274	23m34s
	copy from	72	5s239ms
	cte	72	39s250ms
	ddl	12	15m7s
	delete	12	20ms
	others	4	3m20s
	select	50	3m54s
	update	52	27s952ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
88,840 Requests
2h59m19s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	88,840	2h59m19s
	cte	9,088	2h57m24s
	insert	12,268	14s653ms
	others	3,617	44ms
	select	63,867	1m39s
[unknown]	Total	29,101	11m45s
	cte	73	10m4s
	insert	19,007	31s459ms
	others	4,053	25s92ms
	select	1,519	37s179ms
	tcl	690	188ms
	update	3,759	6s189ms
pgAdmin 4 - DB:socialmedia	Total	60	1s54ms
	select	60	1s54ms
pg_dump	Total	8,322	36m56s
	copy to	574	36m52s
	cte	5	19ms
	others	619	25ms
	select	7,119	3s97ms
	tcl	5	0ms
psql	Total	384	23m46s
	copy from	72	5s239ms
	copy to	26	11s450ms
	cte	91	39s490ms
	ddl	12	15m7s
	delete	12	20ms
	others	4	3m20s
	select	104	3m54s
	update	63	27s987ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-10-14 06:40:02 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

77,928 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	77,928	61.50%
1-5ms	41,125	32.46%
5-10ms	2,990	2.36%
10-25ms	1,254	0.99%
25-50ms	492	0.39%
50-100ms	398	0.31%
100-500ms	689	0.54%
500-1000ms	252	0.20%
1000-10000ms	1,184	0.93%
> 10000ms	395	0.31%

Slowest individual queries


[ Date: 2025-10-14 06:20:18 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-14 06:08:32 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-14 06:20:19 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-14 06:33:50 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-14 06:14:45 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-14 06:22:59 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-14 06:38:26 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-14 06:26:02 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-14 06:16:16 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-14 06:11:49 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-14 06:42:23 - Database: socialmedia - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-14 06:24:19 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-14 06:30:44 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-14 06:29:34 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-14 06:18:54 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-14 06:42:01 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-10-14 06:42:03 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-10-14 06:17:45 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-14 06:40:01 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-14 06:36:22 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]

Rank	Duration	Query
1	15m6s	TRUNCATE TABLE solr_relevance_old; [ Date: 2025-10-14 06:20:18 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	3m29s	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-10-14 06:08:32 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
3	3m18s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2025-10-14 06:20:19 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
4	3m2s	COPY public.researchreports (researchreportid, type, createddatetime, language, filename, xml) TO stdout; [ Date: 2025-10-14 06:33:50 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
5	2m51s	COPY public.researchreports (researchreportid, type, createddatetime, language, filename, xml) TO stdout; [ Date: 2025-10-14 06:14:45 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
6	2m38s	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-10-14 06:22:59 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
7	2m4s	COPY public.t15_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2025-10-14 06:38:26 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
8	1m43s	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-10-14 06:26:02 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
9	1m24s	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-10-14 06:16:16 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
10	1m21s	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-10-14 06:11:49 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
11	1m18s	COPY public.executionlogs (id, executionid, eventdate, status, message, details, detailtype) TO stdout; [ Date: 2025-10-14 06:42:23 - Database: socialmedia - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
12	1m11s	COPY public.authenticationlog (attemptid, username, password, brokerid, authclass, attemptdatetime, success, fingerprint, accounttype) TO stdout; [ Date: 2025-10-14 06:24:19 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
13	1m9s	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-10-14 06:30:44 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
14	1m8s	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-10-14 06:29:34 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
15	1m7s	COPY public.t15_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2025-10-14 06:18:54 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
16	1m1s	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-10-14 06:42:01 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17	1m	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-10-14 06:42:03 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.15 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18	59s32ms	COPY public.t15_hve (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived, pricesadjusted, relevanceprocessed, recengprocessedadjusted) TO stdout; [ Date: 2025-10-14 06:17:45 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
19	58s137ms	COPY public.t30_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2025-10-14 06:40:01 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
20	56s419ms	COPY public.t15_hve (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived, pricesadjusted, relevanceprocessed, recengprocessedadjusted) TO stdout; [ Date: 2025-10-14 06:36:22 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]

Time consuming queries


[ User: postgres - Total duration: 1h21m6s - Times executed: 530 ]
[ User: postgres - Total duration: 1h14m28s - Times executed: 529 ]
[ User: postgres - Total duration: 26m10s - Times executed: 481 ]
[ User: postgres - Total duration: 15m7s - Times executed: 12 ]
[ User: postgres - Total duration: 6m7s - Times executed: 2 ]
[ User: postgres - Total duration: 5m54s - Times executed: 2 ]
[ User: postgres - Total duration: 3m20s - Times executed: 4 ]
[ User: postgres - Total duration: 3m12s - Times executed: 2 ]
[ User: postgres - Total duration: 2m42s - Times executed: 344 ]
[ User: postgres - Total duration: 2m31s - Times executed: 2 ]
[ User: postgres - Total duration: 2m14s - Times executed: 2 ]
[ User: postgres - Total duration: 2m12s - Times executed: 4 ]
[ User: postgres - Total duration: 1m58s - Times executed: 2 ]
[ User: postgres - Total duration: 1m55s - Times executed: 2 ]
[ User: postgres - Total duration: 1m38s - Times executed: 2 ]
[ User: postgres - Total duration: 1m28s - Times executed: 150 ]
[ User: postgres - Total duration: 1m21s - Times executed: 2 ]
[ User: postgres - Total duration: 1m18s - Times executed: 1 ]
[ User: postgres - Total duration: 1m16s - Times executed: 2 ]
[ User: postgres - Total duration: 1m1s - Times executed: 8 ]

Most frequent queries (N)


[ User: postgres - Total duration: 158ms - Times executed: 32686 ]
[ User: postgres - Total duration: 28s234ms - Times executed: 18781 ]
[ User: postgres - Total duration: 8s999ms - Times executed: 7866 ]
[ User: postgres - Total duration: 16s741ms - Times executed: 6824 ]
[ User: postgres - Total duration: 9s803ms - Times executed: 5601 ]
[ User: postgres - Total duration: 9s614ms - Times executed: 4704 ]
[ User: postgres - Total duration: 8s439ms - Times executed: 4644 ]
[ User: postgres - Total duration: 40ms - Times executed: 3642 ]
[ User: postgres - Total duration: 44ms - Times executed: 3616 ]
[ User: postgres - Total duration: 3s157ms - Times executed: 3356 ]
[ User: postgres - Total duration: 3s873ms - Times executed: 3164 ]
[ User: postgres - Total duration: 7s187ms - Times executed: 3059 ]
[ User: postgres - Total duration: 1s179ms - Times executed: 2324 ]
[ User: postgres - Total duration: 1s472ms - Times executed: 2053 ]
[ User: postgres - Total duration: 1s775ms - Times executed: 1782 ]
[ User: postgres - Total duration: 31ms - Times executed: 1647 ]
[ User: postgres - Total duration: 132ms - Times executed: 922 ]
[ User: postgres - Total duration: 256ms - Times executed: 731 ]
[ User: postgres - Total duration: 103ms - Times executed: 646 ]
[ User: postgres - Total duration: 316ms - Times executed: 626 ]

Normalized slowest queries (N)


[ User: postgres - Total duration: 6m7s - Times executed: 2 ]
[ User: postgres - Total duration: 5m54s - Times executed: 2 ]
[ User: postgres - Total duration: 3m12s - Times executed: 2 ]
[ User: postgres - Total duration: 1m18s - Times executed: 1 ]
[ User: postgres - Total duration: 15m7s - Times executed: 12 ]
[ User: postgres - Total duration: 2m31s - Times executed: 2 ]
[ User: postgres - Total duration: 2m14s - Times executed: 2 ]
[ User: postgres - Total duration: 1m58s - Times executed: 2 ]
[ User: postgres - Total duration: 1m55s - Times executed: 2 ]
[ User: postgres - Total duration: 3m20s - Times executed: 4 ]
[ User: postgres - Total duration: 1m38s - Times executed: 2 ]
[ User: postgres - Total duration: 1m21s - Times executed: 2 ]
[ User: postgres - Total duration: 1m16s - Times executed: 2 ]
[ User: postgres - Total duration: 2m12s - Times executed: 4 ]
[ User: postgres - Total duration: 1h21m6s - Times executed: 530 ]
[ User: postgres - Total duration: 1h14m28s - Times executed: 529 ]
[ User: postgres - Total duration: 1m1s - Times executed: 8 ]
[ User: postgres - Total duration: 26m10s - Times executed: 481 ]
[ User: postgres - Total duration: 1m28s - Times executed: 150 ]
[ User: postgres - Total duration: 2m42s - Times executed: 344 ]

Time consuming prepare


[ User: postgres - Total duration: 0ms - Times executed: 6 ]
[ User: postgres - Total duration: 2h4m3s - Times executed: 5318 ]
[ User: postgres - Total duration: 32s379ms - Times executed: 6298 ]
[ User: postgres - Total duration: 929ms - Times executed: 499 ]
[ User: postgres - Total duration: 40ms - Times executed: 3642 ]
[ User: postgres - Total duration: 4s144ms - Times executed: 956 ]
[ User: postgres - Total duration: 29ms - Times executed: 5695 ]
[ User: postgres - Total duration: 2s680ms - Times executed: 3052 ]
[ User: postgres - Total duration: 1s120ms - Times executed: 2172 ]
[ User: postgres - Total duration: 16s382ms - Times executed: 12 ]
[ User: postgres - Total duration: 31s564ms - Times executed: 46 ]
[ User: postgres - Total duration: 37ms - Times executed: 18 ]
[ User: postgres - Total duration: 44ms - Times executed: 3616 ]
[ User: postgres - Total duration: 333ms - Times executed: 264 ]
[ User: postgres - Total duration: 112ms - Times executed: 301 ]
[ User: postgres - Total duration: 50s976ms - Times executed: 6 ]
[ User: postgres - Total duration: 72ms - Times executed: 24 ]
[ User: postgres - Total duration: 10ms - Times executed: 6 ]
[ User: postgres - Total duration: 0ms - Times executed: 24 ]
[ User: postgres - Total duration: 115ms - Times executed: 6 ]

Time consuming bind


[ User: postgres - Total duration: 3h4m24s - Times executed: 8897 ]
[ User: postgres - Total duration: 1m10s - Times executed: 28462 ]
[ User: postgres - Total duration: 1m28s - Times executed: 150 ]
[ User: postgres - Total duration: 929ms - Times executed: 499 ]
[ User: postgres - Total duration: 680ms - Times executed: 25 ]
[ User: postgres - Total duration: 146ms - Times executed: 32563 ]
[ User: postgres - Total duration: 1ms - Times executed: 68 ]
[ User: postgres - Total duration: 9s803ms - Times executed: 5601 ]
[ User: postgres - Total duration: 16s382ms - Times executed: 12 ]
[ User: postgres - Total duration: 3s157ms - Times executed: 3356 ]
[ User: postgres - Total duration: 1s179ms - Times executed: 2324 ]
[ User: postgres - Total duration: 1s146ms - Times executed: 106 ]
[ User: postgres - Total duration: 50s976ms - Times executed: 6 ]
[ User: postgres - Total duration: 66ms - Times executed: 1 ]
[ User: postgres - Total duration: 1s717ms - Times executed: 9 ]
[ User: postgres - Total duration: 43ms - Times executed: 480 ]
[ User: postgres - Total duration: 333ms - Times executed: 264 ]
[ User: postgres - Total duration: 112ms - Times executed: 301 ]
[ User: postgres - Total duration: 40ms - Times executed: 3642 ]
[ User: postgres - Total duration: 17ms - Times executed: 270 ]

Log levels

Key values

373,115 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	428	0.11%
DETAIL	105,613	28.31%
ERROR	1	0.00%
LOG	266,508	71.43%
STATEMENT	565	0.15%

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
Oct 14	06	4

LOG: process 6720 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 1000.045 ms
LOG: process 6720 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 51215.426 ms
LOG: process 11050 still waiting for AccessExclusiveLock on relation 5894441 of database 5881926 after 1000.044 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
Oct 14	06	1

LOG: process 11989 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.054 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

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