pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Mon Oct 20 05:00:00 2025
Log file: /home/postgres/pg_data/data/pg_log/postgresql-2025-10-20_060000.log
Parsed 2,372,831 log entries in 59s
Log start from 2025-10-20 06:00:00 to 2025-10-20 06:59:58

Global Stats

1,035 Number of unique normalized queries
127,835 Number of queries
4h6m9s Total query duration
2025-10-20 06:00:00 First query
2025-10-20 06:59:58 Last query
2,324 queries/s at 2025-10-20 06:20:46 Query peak

4h6m9s Total query duration
2m28s Prepare/parse total duration
1m36s Bind total duration
4h2m5s Execute total duration

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

39 Total number of automatic vacuums
52 Total number of automatic analyzes

647 Number temporary file
161.72 MiB Max size of temporary file
7.08 MiB Average size of temporary file

6,287 Total number of sessions
13 sessions at 2025-10-20 06:56:13 Session peak
2d15h25m2s Total duration of sessions
36s313ms Average duration of sessions
20 Average queries per session
2s349ms Average queries duration per session
33s964ms Average idle time per session

6,288 Total number of connections
55 connections/s at 2025-10-20 06:17:08 Connection peak
5 Total number of databases

SQL Traffic

Key values

2,324 queries/s Query Peak
2025-10-20 06:20:46 Date

SELECT Traffic

Key values

2,309 queries/s Query Peak
2025-10-20 06:20:46 Date

INSERT/UPDATE/DELETE Traffic

Key values

184 queries/s Query Peak
2025-10-20 06:00:56 Date

Queries duration

Key values

4h6m9s 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 20	06	127,835	0ms	15m33s	113ms	7m4s	7m40s	22m25s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Oct 20	06	74,897	600	34ms	1m16s	2m5s	2m57s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Oct 20	06	28,530	2,230	12	72	2ms	546ms	2s154ms	4s986ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Oct 20	06	40,052	97,674	2.44	34.40%

Day	Hour	Count	Average / Second
Oct 20	06	6,288	1.75/s

Day	Hour	Count	Average Duration	Average idle time
Oct 20	06	6,287	36s313ms	34s3ms

↑ Back to the top of the General Activity table

Established Connections

Key values

55 connections Connection Peak
2025-10-20 06:17:08 Date

Connections per database

Key values

acaweb_fx Main Database
6,288 connections Total

Chart
Table

Database	User	Count
acaweb_fx		6,182
	pg_dump	1
	postgres	5,848
	psql	333
acaweb_fx_integer		1
	pg_dump	1
postgres		3
	pg_dump	1
	psql	2
socialmedia		101
	pg_dump	1
	postgres	100
translations		1
	pg_dump	1

Connections per user

Key values

postgres Main User
6,288 connections Total

Chart
Table

User	Count
pg_dump	5
postgres	5,948
psql	335

Connections per host

Key values

192.168.1.15 Main host with 2885 connections
6,288 Total connections

Chart
Table

Host	Count
127.0.0.1	114
192.168.0.114	1
192.168.0.216	100
192.168.0.74	891
192.168.1.145	87
192.168.1.15	2,885
192.168.1.20	105
192.168.1.23	1
192.168.1.90	72
192.168.2.126	62
192.168.2.182	12
192.168.2.205	12
192.168.2.82	48
192.168.4.142	1,179
192.168.4.150	10
192.168.4.168	29
192.168.4.196	1
192.168.4.238	16
192.168.4.28	4
192.168.4.33	99
192.168.4.80	4
192.168.4.98	330
[local]	226

Simultaneous sessions

Key values

13 sessions Session Peak
2025-10-20 06:56:13 Date

Histogram of session times

Key values

5,397 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	5,397	85.84%
500ms-1s	201	3.20%
1s-30s	350	5.57%
30s-1m	188	2.99%
1m-10m	93	1.48%
10m-30m	36	0.57%
30m-1h	4	0.06%
1h-8h	18	0.29%
> 8h	0	0.00%

Sessions per database

Key values

acaweb_fx Main Database
6,287 sessions Total

Chart
Table

Database	User	Count	Total Duration
acaweb_fx	6,181	2d14h50m13s	36s598ms
acaweb_fx_integer	1	20m53s	20m53s
postgres	3	323ms	107ms
socialmedia	101	13m55s	8s268ms
translations	1	218ms	218ms

Sessions per user

Key values

postgres Main User
6,287 sessions Total

Chart
Table

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

Sessions per host

Key values

192.168.1.15 Main Host
6,287 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	114	38m6s	20s53ms
192.168.0.114	1	5m	5m
192.168.0.216	100	42s549ms	425ms
192.168.0.74	891	11h48m42s	47s724ms
192.168.1.145	87	5h50m38s	4m1s
192.168.1.15	2,884	7h10m45s	8s961ms
192.168.1.20	105	16h57m37s	9m41s
192.168.1.23	1	44ms	44ms
192.168.1.90	72	3m1s	2s522ms
192.168.2.126	62	6s250ms	100ms
192.168.2.182	12	773ms	64ms
192.168.2.205	12	441ms	36ms
192.168.2.82	48	7s39ms	146ms
192.168.4.142	1,179	9m4s	461ms
192.168.4.150	10	20h7m56s	2h47s
192.168.4.168	29	2s904ms	100ms
192.168.4.196	1	296ms	296ms
192.168.4.238	16	22s42ms	1s377ms
192.168.4.28	4	74ms	18ms
192.168.4.33	99	7m42s	4s667ms
192.168.4.80	4	40ms	10ms
192.168.4.98	330	31s459ms	95ms
[local]	226	24m34s	6s524ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
6,287 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	5,202	2d14h7m16s	42s990ms
[unknown]	745	15m5s	1s215ms
pg_dump	5	37m50s	7m34s
psql	335	24m50s	4s448ms

Checkpoints Buffers

Key values

13,394 buffers Checkpoint Peak
2025-10-20 06:08:06 Date
209.972 seconds Highest write time
0.014 seconds Sync time

Checkpoints Wal files

Key values

7 files Wal files usage Peak
2025-10-20 06:08:06 Date

Checkpoints distance

Key values

232.67 Mo Distance Peak
2025-10-20 06:08:06 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Oct 20	06	33,331	1,625.367s	0.067s	1,625.741s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Oct 20	06	0	0	23	1,822	0.006s	0s

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

Day	Hour	Mean distance	Mean estimate
Oct 20	06	31,304.67 kB	83,062.92 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

179.06 MiB Temp Files size Peak
2025-10-20 06:00:07 Date

Number of temporary files

Key values

30 per second Temp Files Peak
2025-10-20 06:32:35 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Oct 20	06	647	4.48 GiB	7.08 MiB

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)


Date: 2025-10-20 06:00:46
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 182.165.1.42
Application: [unknown]
Date: 2025-10-20 06:40:13
Duration: 10s564ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.90
Application: [unknown]
Date: 2025-10-20 06:41:16
Duration: 4s913ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-10-20 06:31:21
Duration: 5s144ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-10-20 06:18:01
Duration: 11s177ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-10-20 06:17:50
Duration: 47s579ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-10-20 06:35:38
Duration: 7s93ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-10-20 06:41:17
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 182.165.1.42
Application: [unknown]

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	118	481.49 MiB	3.32 MiB	4.36 MiB	4.08 MiB	with rar_max as ( ; WITH rar_max as ( ; Date: 2025-10-20 06:00:46 Duration: 0ms Database: acaweb_fx User: postgres Remote: 182.165.1.42 Application: [unknown]
2	42	1.72 GiB	7.33 MiB	161.72 MiB	41.86 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-20 06:40:13 Duration: 10s564ms 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-20 06:50:11 Duration: 8s799ms 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-20 06:20:11 Duration: 8s726ms Database: acaweb_fx User: postgres Remote: 192.168.1.90 Application: [unknown]
3	12	372.56 MiB	31.05 MiB	31.05 MiB	31.05 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-20 06:41:16 Duration: 4s913ms 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-20 06:31:15 Duration: 3s881ms 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-20 06:20:48 Duration: 3s144ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
4	12	753.94 MiB	62.83 MiB	62.83 MiB	62.83 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-20 06:31:21 Duration: 5s144ms 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-20 06:41:20 Duration: 3s999ms 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-20 06:26:18 Duration: 3s750ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
5	8	814.05 MiB	101.74 MiB	101.78 MiB	101.76 MiB	select updateresultsmaterializedview (); select updateresultsmaterializedview (); Date: 2025-10-20 06:18:01 Duration: 11s177ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateresultsmaterializedview (); Date: 2025-10-20 06:32:54 Duration: 9s527ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateresultsmaterializedview (); Date: 2025-10-20 06:47:50 Duration: 7s602ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
6	4	347.60 MiB	86.85 MiB	86.96 MiB	86.90 MiB	select updateageforrelevantresults (); select updateageforrelevantresults (); Date: 2025-10-20 06:17:50 Duration: 47s579ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateageforrelevantresults (); Date: 2025-10-20 06:32:44 Duration: 42s634ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateageforrelevantresults (); Date: 2025-10-20 06:47:42 Duration: 40s467ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
7	4	47.33 MiB	11.83 MiB	11.84 MiB	11.83 MiB	select updaterelevantforrelevantresults (); select updaterelevantforrelevantresults (); Date: 2025-10-20 06:35:38 Duration: 7s93ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updaterelevantforrelevantresults (); Date: 2025-10-20 06:20:38 Duration: 6s465ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updaterelevantforrelevantresults (); Date: 2025-10-20 06:50:33 Duration: 1s613ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
8	1	3.32 MiB	3.32 MiB	3.32 MiB	3.32 MiB	select resultuid from relevance_consecutivecandles_results order by resultuid desc limit ?), all_results as ( select ccr.resultuid as resultuid, ccr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, ccr.patternendtime as identified, dtt.timezone as timezone, ccr.qtyconsecutivecandles as length, g.basegroupname, case when rcr.age is not null then rcr.age when ccr.resultuid <= rm.resultuid then ? else ? end as age, case when rcr.relevant is not null then rcr.relevant when ccr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip, newlevels.filtered from consecutivecandles_results ccr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = ccr.symbolid inner join symbols s on ccr.symbolid = s.symbolid and s.nonliquid = ? inner join downloadersymbolsettings dss on ccr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join symbolgroup sg on ccr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join rar_max rm on ? = ? left outer join relevance_consecutivecandles_results rcr on rcr.resultuid = ccr.resultuid left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? left join lateral calc_cc_signal_filter (ccr.resultuid) newlevels on true where ccr.gmttimefound > now() - interval ? and s.deleted = ? and (ccr.simulation = ? or ccr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or ccr.patternlengthbars <= ?)), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc; SELECT resultuid FROM relevance_consecutivecandles_results ORDER BY resultuid DESC LIMIT 1), all_results AS ( SELECT ccr.resultuid AS resultuid, ccr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, ccr.patternendtime AS identified, dtt.timezone AS timezone, ccr.qtyconsecutivecandles AS length, g.basegroupname, CASE WHEN rcr.age IS NOT NULL THEN rcr.age WHEN ccr.resultuid <= rm.resultuid THEN 1 ELSE 0 END as age, CASE WHEN rcr.relevant IS NOT NULL THEN rcr.relevant WHEN ccr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip, newLevels.filtered FROM consecutivecandles_results ccr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = ccr.symbolid INNER JOIN symbols s ON ccr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN downloadersymbolsettings dss ON ccr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN symbolgroup sg on ccr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_consecutivecandles_results rcr ON rcr.resultuid = ccr.resultuid LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' LEFT JOIN LATERAL calc_cc_signal_filter (ccr.resultuid) newLevels on true WHERE ccr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (ccr.simulation = 0 OR ccr.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3, $4, $5, $6, $7, $8, $9)) AND ($10 = 0 OR s.exchange in ($11)) AND ($12 = 0 OR coalesce(bim.code, s.symbol) in ($13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322)) AND ($323 = 0 OR ccr.patternlengthbars <= $324)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $325 OR relevant = 1) AND ($326 = 0 OR age <= $327) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; Date: 2025-10-20 06:41:17 Duration: 0ms Database: acaweb_fx User: postgres Remote: 182.165.1.42 Application: [unknown]

Queries generating the largest temporary files


[ Date: 2025-10-20 06:10:07 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
[ Date: 2025-10-20 06:50:07 ]
[ Date: 2025-10-20 06:00:03 ]
[ Date: 2025-10-20 06:30:07 ]
[ Date: 2025-10-20 06:32:47 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-20 06:02:19 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-20 06:17:52 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-20 06:47:43 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-20 06:35:39 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-20 06:50:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-20 06:20:38 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-20 06:05:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-20 06:02:06 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-20 06:32:25 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-20 06:47:26 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-20 06:17:25 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-20 06:20:07 ]
[ Date: 2025-10-20 06:50:08 ]
[ Date: 2025-10-20 06:40:10 ]
[ Date: 2025-10-20 06:20:08 ]

Rank	Size	Query
1	161.72 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-20 06:10:07 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
2	146.84 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-20 06:50:07 ]
3	107.73 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-20 06:00:03 ]
4	105.63 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-20 06:30:07 ]
5	101.78 MiB	select updateresultsmaterializedview (); [ Date: 2025-10-20 06:32:47 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
6	101.77 MiB	select updateresultsmaterializedview (); [ Date: 2025-10-20 06:02:19 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
7	101.77 MiB	select updateresultsmaterializedview (); [ Date: 2025-10-20 06:17:52 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
8	101.76 MiB	select updateresultsmaterializedview (); [ Date: 2025-10-20 06:47:43 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
9	101.75 MiB	select updateresultsmaterializedview (); [ Date: 2025-10-20 06:35:39 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
10	101.75 MiB	select updateresultsmaterializedview (); [ Date: 2025-10-20 06:50:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
11	101.74 MiB	select updateresultsmaterializedview (); [ Date: 2025-10-20 06:20:38 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
12	101.74 MiB	select updateresultsmaterializedview (); [ Date: 2025-10-20 06:05:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
13	86.96 MiB	select updateageforrelevantresults (); [ Date: 2025-10-20 06:02:06 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
14	86.93 MiB	select updateageforrelevantresults (); [ Date: 2025-10-20 06:32:25 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
15	86.86 MiB	select updateageforrelevantresults (); [ Date: 2025-10-20 06:47:26 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
16	86.85 MiB	select updateageforrelevantresults (); [ Date: 2025-10-20 06:17:25 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
17	85.77 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-20 06:20:07 ]
18	82.94 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-20 06:50:08 ]
19	72.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 = 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-20 06:40:10 ]
20	70.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-20 06:20:08 ]

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)
52 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_fibonacci_results	4
acaweb_fx.public.relevance_autochartist_results	4
acaweb_fx.pg_catalog.pg_type	3
acaweb_fx.pg_catalog.pg_index	2
acaweb_fx.public.autochartist_symbolupdates	2
acaweb_fx.public.latest_t15_candle_view	2
socialmedia.public.processes	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.symbollatestupdatetime	1
Total	52

Vacuums per table

Key values

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

Chart
Table

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
acaweb_fx.public.solr_relevance_old	13	13	9,801	0	41	0	62	7,186	12	1,288,779
acaweb_fx.public.datafeeds_latestrun	7	0	825	0	20	0	0	69	24	65,004
acaweb_fx.public.relevance_autochartist_results	3	3	10,236	0	378	7	730	1,906	362	927,579
acaweb_fx.pg_toast.pg_toast_2619	2	2	299	0	56	0	0	195	48	163,842
acaweb_fx.pg_catalog.pg_attribute	2	2	1,495	0	379	0	134	750	296	1,747,251
acaweb_fx.public.latest_t15_candle_view	2	2	162	0	9	0	0	12	5	19,335
acaweb_fx.public.relevance_keylevels_results	2	2	8,105	0	360	4	92	2,399	314	807,111
acaweb_fx.pg_catalog.pg_class	2	2	893	0	93	0	0	256	85	407,196
acaweb_fx.public.relevance_fibonacci_results	2	2	2,675	0	67	4	91	511	41	125,325
acaweb_fx_integer.public.bigmovement_results_underlying	1	0	130	0	1	0	886	1	1	5,665
acaweb_fx.pg_catalog.pg_type	1	1	124	0	29	0	0	47	24	136,381
acaweb_fx.public.autochartist_symbolupdates	1	1	24,340	0	3,833	1	37,843	7,355	2,187	1,179,290
acaweb_fx.pg_catalog.pg_statistic	1	1	1,023	0	150	0	582	374	139	592,724
Total	39	31	60,108	48,804	5,416	16	40,420	21,061	3,538	7,465,482

Tuples removed per table

Key values

public.solr_relevance_old (57868) Main table with removed tuples on database acaweb_fx
74006 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
acaweb_fx.public.solr_relevance_old	13	13	57,868	74,504	2,873	0	2,499
acaweb_fx.public.autochartist_symbolupdates	1	1	5,797	51,671	15	0	40,691
acaweb_fx.public.relevance_keylevels_results	2	2	4,281	24,259	0	0	558
acaweb_fx.pg_catalog.pg_attribute	2	2	2,553	19,366	274	0	474
acaweb_fx.public.relevance_autochartist_results	3	3	1,568	24,556	676	0	1,140
acaweb_fx.public.relevance_fibonacci_results	2	2	491	3,488	0	0	204
acaweb_fx.pg_catalog.pg_statistic	1	1	484	3,816	129	0	1,194
acaweb_fx.pg_catalog.pg_class	2	2	466	3,337	145	0	300
acaweb_fx.public.datafeeds_latestrun	7	0	227	270	172	0	112
acaweb_fx.pg_toast.pg_toast_2619	2	2	146	363	17	5	101
acaweb_fx.public.latest_t15_candle_view	2	2	101	52	24	0	2
acaweb_fx.pg_catalog.pg_type	1	1	24	1,390	50	0	38
acaweb_fx_integer.public.bigmovement_results_underlying	1	0	0	29,850	0	0	887
Total	39	31	74,006	236,922	4,375	5	48,200

Pages removed per table

Key values

pg_toast.pg_toast_2619 (5) Main table with removed pages on database acaweb_fx
5 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
acaweb_fx.pg_toast.pg_toast_2619	2	2	146	5
acaweb_fx_integer.public.bigmovement_results_underlying	1	0	0	0
acaweb_fx.pg_catalog.pg_type	1	1	24	0
acaweb_fx.public.autochartist_symbolupdates	1	1	5797	0
acaweb_fx.public.datafeeds_latestrun	7	0	227	0
acaweb_fx.pg_catalog.pg_statistic	1	1	484	0
acaweb_fx.pg_catalog.pg_attribute	2	2	2553	0
acaweb_fx.public.latest_t15_candle_view	2	2	101	0
acaweb_fx.public.relevance_keylevels_results	2	2	4281	0
acaweb_fx.pg_catalog.pg_class	2	2	466	0
acaweb_fx.public.solr_relevance_old	13	13	57868	0
acaweb_fx.public.relevance_autochartist_results	3	3	1568	0
acaweb_fx.public.relevance_fibonacci_results	2	2	491	0
Total	39	31	74,006	5

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Oct 20	06	39	52

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

AccessExclusiveLock Main Lock Type
4 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
AccessExclusiveLock		2	19m17s	9m38s
	relation	2	19m17s	9m38s
AccessShareLock		2	2m9s	1m4s
	relation	2	2m9s	1m4s
	Total	4	21m26s	5m21s

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	1	15m33s	15m33s	15m33s	15m33s	truncate table solr_relevance_old; TRUNCATE TABLE solr_relevance_old; Date: 2025-10-20 06:20:45 Database: acaweb_fx User: postgres Remote: [local] Application: psql TRUNCATE TABLE solr_relevance_old; Date: 2025-10-20 06:33:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql TRUNCATE TABLE solr_relevance_old; Date: 2025-10-20 06:31:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql
2	1	3m43s	3m43s	3m43s	3m43s	refresh materialized view latest_candle_datetime_per_receng; refresh materialized view latest_candle_datetime_per_receng; Date: 2025-10-20 06:20:46 Database: acaweb_fx User: postgres Remote: [local] Application: psql refresh materialized view latest_candle_datetime_per_receng; Date: 2025-10-20 06:47:02 Database: acaweb_fx User: postgres Remote: [local] Application: psql refresh materialized view latest_candle_datetime_per_receng; Date: 2025-10-20 06:32:02 Database: acaweb_fx User: postgres Remote: [local] Application: psql
3	2	2m9s	10s368ms	1m59s	1m4s	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-20 06:20:46 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-20 06:20:46 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-20 06:11:34 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

15m33s

truncate table solr_relevance_old;

TRUNCATE TABLE solr_relevance_old;

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

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

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

2

1

3m43s

refresh materialized view latest_candle_datetime_per_receng;

refresh materialized view latest_candle_datetime_per_receng;

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

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

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

3

2

2m9s

10s368ms

1m59s

1m4s

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-20 06:20:46 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-20 06:20:46 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-20 06:11:34 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	15m33s	TRUNCATE TABLE solr_relevance_old; [ Date: 2025-10-20 06:20:45 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	3m43s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2025-10-20 06:20:45 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
3	1m59s	select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng; [ Date: 2025-10-20 06:20:46 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: PostgreSQL JDBC Driver ]
4	10s368ms	select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng; [ Date: 2025-10-20 06:20:46 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: PostgreSQL JDBC Driver ]

Queries by type

Key values

74,897 Total read queries
41,526 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	74,897	58.59%
INSERT	28,530	22.32%
UPDATE	2,230	1.74%
DELETE	12	0.01%
COPY FROM	72	0.06%
COPY TO	600	0.47%
CTE	9,364	7.33%
DDL	12	0.01%
TCL	706	0.55%
CURSOR	0	0.00%
OTHERS	11,412	8.93%

Queries by database

Key values

acaweb_fx Main database
114,753 Requests
3h40m5s (acaweb_fx)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
acaweb_fx	Total	114,753	3h40m5s
	copy from	72	5s337ms
	copy to	305	15m44s
	cte	9,360	2h56m59s
	ddl	12	15m34s
	delete	12	21ms
	insert	20,309	35s175ms
	others	11,075	4m12s
	select	70,782	6m22s
	tcl	690	192ms
	update	2,136	31s329ms
acaweb_fx_integer	Total	3,589	20m36s
	copy to	276	20m35s
	cte	1	7ms
	others	285	20ms
	select	3,026	1s322ms
	tcl	1	0ms
postgres	Total	367	286ms
	cte	1	2ms
	others	9	0ms
	select	356	283ms
	tcl	1	0ms
socialmedia	Total	9,079	1m22s
	copy to	19	1m11s
	cte	1	2ms
	insert	8,221	9s922ms
	others	34	0ms
	select	697	707ms
	tcl	13	0ms
	update	94	204ms
translations	Total	47	206ms
	cte	1	2ms
	others	9	0ms
	select	36	203ms
	tcl	1	0ms

Queries by user

Key values

postgres Main user
127,835 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	127,835	4h2m5s
	copy from	72	5s337ms
	copy to	600	37m31s
	cte	9,364	2h56m59s
	ddl	12	15m34s
	delete	12	21ms
	insert	28,530	45s98ms
	others	11,412	4m12s
	select	74,897	6m24s
	tcl	706	193ms
	update	2,230	31s534ms

Duration by user

Key values

4h2m5s (postgres) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	127,835	4h2m5s
	copy from	72	5s337ms
	copy to	600	37m31s
	cte	9,364	2h56m59s
	ddl	12	15m34s
	delete	12	21ms
	insert	28,530	45s98ms
	others	11,412	4m12s
	select	74,897	6m24s
	tcl	706	193ms
	update	2,230	31s534ms

Queries by host

Key values

192.168.1.15 Main host
27,906 Requests
49m36s (192.168.0.74)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	18,376	38m40s
	copy to	600	37m31s
	cte	23	249ms
	insert	7,887	15s737ms
	others	619	26ms
	select	7,624	51s358ms
	tcl	5	0ms
	update	1,618	1s641ms
182.165.1.42	Total	192	10m27s
	cte	60	10m27s
	select	132	202ms
192.168.0.114	Total	30	49ms
	others	6	0ms
	select	12	49ms
	tcl	12	0ms
192.168.0.216	Total	400	332ms
	others	200	19ms
	select	192	210ms
	update	8	102ms
192.168.0.239	Total	429	2s847ms
	select	429	2s847ms
192.168.0.42	Total	833	4s326ms
	insert	180	32ms
	select	653	4s293ms
192.168.0.74	Total	24,753	49m36s
	cte	3,801	49m18s
	others	1,782	18ms
	select	19,170	17s652ms
192.168.1.135	Total	146	651ms
	cte	6	265ms
	select	140	385ms
192.168.1.145	Total	12,878	33m18s
	cte	731	33m5s
	others	174	1ms
	select	11,973	13s384ms
192.168.1.15	Total	27,906	48m14s
	cte	3,907	47m55s
	others	5,770	62ms
	select	18,229	18s807ms
192.168.1.20	Total	12,093	34m33s
	cte	741	34m20s
	others	210	2ms
	select	11,142	12s580ms
192.168.1.201	Total	1,463	8s650ms
	select	1,463	8s650ms
192.168.1.23	Total	1,740	10s727ms
	others	2	0ms
	select	1,738	10s727ms
192.168.1.90	Total	160	49s417ms
	cte	6	49s264ms
	others	48	0ms
	select	106	152ms
192.168.1.93	Total	4	1ms
	select	4	1ms
192.168.2.126	Total	80	69ms
	others	18	0ms
	select	62	69ms
192.168.2.182	Total	48	275ms
	others	24	2ms
	select	12	10ms
	update	12	261ms
192.168.2.205	Total	137	120ms
	insert	89	27ms
	others	24	2ms
	select	20	20ms
	update	4	70ms
192.168.2.82	Total	1,179	3s666ms
	insert	791	2s712ms
	others	96	11ms
	select	174	124ms
	update	118	817ms
192.168.4.142	Total	14,805	17s933ms
	insert	11,362	16s665ms
	others	2,358	26ms
	select	1,085	1s240ms
192.168.4.150	Total	22	1s243ms
	others	21	0ms
	select	1	1s242ms
192.168.4.168	Total	58	1s873ms
	select	29	1s872ms
	tcl	29	1ms
192.168.4.196	Total	3	154ms
	cte	1	154ms
	others	2	0ms
192.168.4.238	Total	48	20s590ms
	cte	16	20s590ms
	others	32	0ms
192.168.4.28	Total	12	1ms
	others	8	0ms
	select	4	1ms
192.168.4.33	Total	8,758	10s475ms
	insert	8,221	9s922ms
	select	443	348ms
	update	94	204ms
192.168.4.80	Total	12	1ms
	others	8	0ms
	select	4	1ms
192.168.4.98	Total	996	26s660ms
	others	6	25s777ms
	select	6	34ms
	tcl	660	191ms
	update	324	657ms
[local]	Total	274	24m33s
	copy from	72	5s337ms
	cte	72	40s976ms
	ddl	12	15m34s
	delete	12	21ms
	others	4	3m46s
	select	50	3m58s
	update	52	27s778ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
92,040 Requests
2h46m50s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	92,040	2h46m50s
	cte	9,203	2h45m1s
	insert	11,542	16s698ms
	others	5,204	59ms
	select	66,091	1m31s
[unknown]	Total	27,090	13m6s
	cte	66	11m16s
	insert	16,988	28s400ms
	others	5,585	25s867ms
	select	1,583	51s100ms
	tcl	701	193ms
	update	2,167	3s729ms
pg_dump	Total	8,322	37m20s
	copy to	574	37m17s
	cte	5	19ms
	others	619	26ms
	select	7,119	3s12ms
	tcl	5	0ms
psql	Total	383	24m48s
	copy from	72	5s337ms
	copy to	26	14s497ms
	cte	90	41s205ms
	ddl	12	15m34s
	delete	12	21ms
	others	4	3m46s
	select	104	3m58s
	update	63	27s804ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-10-20 06:35:44 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

79,920 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	79,920	62.52%
1-5ms	40,899	31.99%
5-10ms	2,567	2.01%
10-25ms	1,187	0.93%
25-50ms	450	0.35%
50-100ms	389	0.30%
100-500ms	731	0.57%
500-1000ms	208	0.16%
1000-10000ms	1,065	0.83%
> 10000ms	419	0.33%

Slowest individual queries


[ Date: 2025-10-20 06:20:45 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-20 06:08:47 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-20 06:20:46 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-10-20 06:34:14 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-20 06:15:11 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-20 06:23:27 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-20 06:38:56 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-20 06:26:40 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-20 06:12:19 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-20 06:16:46 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-20 06:31:11 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-20 06:24:46 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-20 06:29:56 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-20 06:18:19 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-20 06:42:46 - Database: socialmedia - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-20 06:19:20 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-20 06:36:50 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-20 06:40:32 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-20 06:27:54 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-10-20 06:35:07 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]

Rank	Duration	Query
1	15m33s	TRUNCATE TABLE solr_relevance_old; [ Date: 2025-10-20 06:20:45 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	3m45s	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-20 06:08:47 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
3	3m44s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2025-10-20 06:20:46 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
4	2m55s	COPY public.researchreports (researchreportid, type, createddatetime, language, filename, xml) TO stdout; [ Date: 2025-10-20 06:34:14 - 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-10-20 06:15:11 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
6	2m40s	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-20 06:23:27 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
7	2m5s	COPY public.t15_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2025-10-20 06:38:56 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
8	1m53s	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-20 06:26:40 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
9	1m33s	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-20 06:12:19 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
10	1m28s	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-20 06:16:46 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
11	1m15s	COPY public.powerstats_trumpet_test (symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) TO stdout; [ Date: 2025-10-20 06:31:11 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
12	1m12s	COPY public.authenticationlog (attemptid, username, password, brokerid, authclass, attemptdatetime, success, fingerprint, accounttype) TO stdout; [ Date: 2025-10-20 06:24:46 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
13	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-20 06:29:56 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
14	1m7s	COPY public.t15_hve (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived, pricesadjusted, relevanceprocessed, recengprocessedadjusted) TO stdout; [ Date: 2025-10-20 06:18:19 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
15	1m7s	COPY public.executionlogs (id, executionid, eventdate, status, message, details, detailtype) TO stdout; [ Date: 2025-10-20 06:42:46 - Database: socialmedia - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
16	1m1s	COPY public.t15_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2025-10-20 06:19:20 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
17	1m	COPY public.t15_hve (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived, pricesadjusted, relevanceprocessed, recengprocessedadjusted) TO stdout; [ Date: 2025-10-20 06:36:50 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
18	58s338ms	COPY public.t30_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2025-10-20 06:40:32 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
19	50s398ms	COPY public.keylevels_results (bandwidth, patternid, gmttimefound, approachingtimestamp, isrelevant, qtytp, patternlengthbars, symbolid, resultuid, patternprice, breakout, x0, x1, x2, x3, x4, x5, x6, x7, x8, x9, breakoutbars, breakoutprice, atbaridentified, atpriceidentified, approachingregion, errormargin, direction, predictionpricefrom, predictionpriceto, predictiontimefrom, predictiontimebars, uniquepointsvalue, furthestprice, patternendtime, relevancestartdistance, simulation, patternclassid, patternstarttime, stoplosslevel, writtendatetime, old_resultuid) TO stdout; [ Date: 2025-10-20 06:27:54 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
20	49s643ms	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-20 06:35:07 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]

Time consuming queries


[ User: postgres - Total duration: 1h16m19s - Times executed: 492 ]
[ User: postgres - Total duration: 1h11m10s - Times executed: 491 ]
[ User: postgres - Total duration: 23m11s - Times executed: 444 ]
[ User: postgres - Total duration: 15m34s - Times executed: 12 ]
[ User: postgres - Total duration: 6m25s - Times executed: 2 ]
[ User: postgres - Total duration: 5m42s - Times executed: 2 ]
[ User: postgres - Total duration: 3m46s - Times executed: 4 ]
[ User: postgres - Total duration: 3m6s - Times executed: 2 ]
[ User: postgres - Total duration: 2m48s - Times executed: 2 ]
[ User: postgres - Total duration: 2m40s - Times executed: 299 ]
[ User: postgres - Total duration: 2m27s - Times executed: 4 ]
[ User: postgres - Total duration: 2m17s - Times executed: 2 ]
[ User: postgres - Total duration: 2m9s - Times executed: 2 ]
[ User: postgres - Total duration: 2m8s - Times executed: 2 ]
[ User: postgres - Total duration: 1m38s - Times executed: 2 ]
[ User: postgres - Total duration: 1m21s - Times executed: 2 ]
[ User: postgres - Total duration: 1m20s - Times executed: 135 ]
[ User: postgres - Total duration: 1m17s - Times executed: 2 ]
[ User: postgres - Total duration: 1m7s - Times executed: 1 ]
[ User: postgres - Total duration: 54s49ms - Times executed: 2 ]

Most frequent queries (N)


[ User: postgres - Total duration: 159ms - Times executed: 34146 ]
[ User: postgres - Total duration: 30s239ms - Times executed: 20453 ]
[ User: postgres - Total duration: 9s226ms - Times executed: 7878 ]
[ User: postgres - Total duration: 11s500ms - Times executed: 6003 ]
[ User: postgres - Total duration: 11s851ms - Times executed: 5658 ]
[ User: postgres - Total duration: 53ms - Times executed: 5229 ]
[ User: postgres - Total duration: 59ms - Times executed: 5203 ]
[ User: postgres - Total duration: 9s767ms - Times executed: 4219 ]
[ User: postgres - Total duration: 6s332ms - Times executed: 3416 ]
[ User: postgres - Total duration: 3s356ms - Times executed: 3270 ]
[ User: postgres - Total duration: 2s753ms - Times executed: 2569 ]
[ User: postgres - Total duration: 1s745ms - Times executed: 2280 ]
[ User: postgres - Total duration: 1s231ms - Times executed: 2205 ]
[ User: postgres - Total duration: 7s452ms - Times executed: 2116 ]
[ User: postgres - Total duration: 32ms - Times executed: 1647 ]
[ User: postgres - Total duration: 1s615ms - Times executed: 1607 ]
[ User: postgres - Total duration: 118ms - Times executed: 922 ]
[ User: postgres - Total duration: 262ms - Times executed: 731 ]
[ User: postgres - Total duration: 107ms - Times executed: 646 ]
[ User: postgres - Total duration: 380ms - Times executed: 626 ]

Normalized slowest queries (N)


[ User: postgres - Total duration: 6m25s - Times executed: 2 ]
[ User: postgres - Total duration: 5m42s - Times executed: 2 ]
[ User: postgres - Total duration: 3m6s - Times executed: 2 ]
[ User: postgres - Total duration: 2m48s - Times executed: 2 ]
[ User: postgres - Total duration: 15m34s - Times executed: 12 ]
[ User: postgres - Total duration: 2m17s - Times executed: 2 ]
[ User: postgres - Total duration: 1m7s - Times executed: 1 ]
[ User: postgres - Total duration: 2m9s - Times executed: 2 ]
[ User: postgres - Total duration: 2m8s - Times executed: 2 ]
[ User: postgres - Total duration: 3m46s - Times executed: 4 ]
[ User: postgres - Total duration: 1m38s - Times executed: 2 ]
[ User: postgres - Total duration: 1m21s - Times executed: 2 ]
[ User: postgres - Total duration: 1m17s - Times executed: 2 ]
[ User: postgres - Total duration: 2m27s - Times executed: 4 ]
[ User: postgres - Total duration: 54s49ms - Times executed: 2 ]
[ User: postgres - Total duration: 1h16m19s - Times executed: 492 ]
[ User: postgres - Total duration: 1h11m10s - Times executed: 491 ]
[ User: postgres - Total duration: 23m11s - Times executed: 444 ]
[ User: postgres - Total duration: 1m20s - Times executed: 135 ]
[ User: postgres - Total duration: 2m40s - Times executed: 299 ]

Time consuming prepare


[ User: postgres - Total duration: 0ms - Times executed: 20 ]
[ User: postgres - Total duration: 2h9m37s - Times executed: 6293 ]
[ User: postgres - Total duration: 27s743ms - Times executed: 7854 ]
[ User: postgres - Total duration: 53ms - Times executed: 5229 ]
[ User: postgres - Total duration: 1s33ms - Times executed: 494 ]
[ User: postgres - Total duration: 5s251ms - Times executed: 1059 ]
[ User: postgres - Total duration: 33ms - Times executed: 8113 ]
[ User: postgres - Total duration: 3s147ms - Times executed: 3141 ]
[ User: postgres - Total duration: 1s144ms - Times executed: 2054 ]
[ User: postgres - Total duration: 20s590ms - Times executed: 16 ]
[ User: postgres - Total duration: 59ms - Times executed: 5203 ]
[ User: postgres - Total duration: 35ms - Times executed: 18 ]
[ User: postgres - Total duration: 13s73ms - Times executed: 16 ]
[ User: postgres - Total duration: 75ms - Times executed: 20 ]
[ User: postgres - Total duration: 49s264ms - Times executed: 6 ]
[ User: postgres - Total duration: 0ms - Times executed: 1 ]
[ User: postgres - Total duration: 11ms - Times executed: 6 ]
[ User: postgres - Total duration: 29ms - Times executed: 20 ]
[ User: postgres - Total duration: 61ms - Times executed: 24 ]
[ User: postgres - Total duration: 145ms - Times executed: 96 ]

Time consuming bind


[ User: postgres - Total duration: 2h53m47s - Times executed: 9039 ]
[ User: postgres - Total duration: 59s601ms - Times executed: 29165 ]
[ User: postgres - Total duration: 1m19s - Times executed: 134 ]
[ User: postgres - Total duration: 1s33ms - Times executed: 494 ]
[ User: postgres - Total duration: 147ms - Times executed: 34023 ]
[ User: postgres - Total duration: 20s590ms - Times executed: 16 ]
[ User: postgres - Total duration: 824ms - Times executed: 25 ]
[ User: postgres - Total duration: 11s851ms - Times executed: 5658 ]
[ User: postgres - Total duration: 0ms - Times executed: 47 ]
[ User: postgres - Total duration: 3s356ms - Times executed: 3270 ]
[ User: postgres - Total duration: 1s231ms - Times executed: 2205 ]
[ User: postgres - Total duration: 1s244ms - Times executed: 106 ]
[ User: postgres - Total duration: 2s729ms - Times executed: 13 ]
[ User: postgres - Total duration: 415ms - Times executed: 106 ]
[ User: postgres - Total duration: 154ms - Times executed: 1 ]
[ User: postgres - Total duration: 49s264ms - Times executed: 6 ]
[ User: postgres - Total duration: 42ms - Times executed: 444 ]
[ User: postgres - Total duration: 194ms - Times executed: 28 ]
[ User: postgres - Total duration: 53ms - Times executed: 5229 ]
[ User: postgres - Total duration: 21ms - Times executed: 571 ]

Log levels

Key values

392,212 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	388	0.10%
DETAIL	106,080	27.05%
ERROR	1	0.00%
LOG	285,218	72.72%
STATEMENT	525	0.13%

Events distribution

Key values

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

Most Frequent Errors/Events

Key values

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

Rank

Times reported

Error

1

4

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Oct 20	06	4

LOG: process 8607 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 1000.060 ms
LOG: process 8607 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 52440.299 ms
LOG: process 12903 still waiting for AccessExclusiveLock on relation 5894441 of database 5881926 after 1000.055 ms

2

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Oct 20	06	2

LOG: process 13667 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.072 ms at character 77
LOG: process 14264 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

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