pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Thu Jul 31 04:59:43 2025
Log file: /home/postgres/pg_data/data/pg_log/postgresql-2025-07-31_060000.log
Parsed 1,340,323 log entries in 42s
Log start from 2025-07-31 06:00:00 to 2025-07-31 06:59:39

Global Stats

1,157 Number of unique normalized queries
98,149 Number of queries
3h39m8s Total query duration
2025-07-31 06:00:00 First query
2025-07-31 06:59:38 Last query
3,049 queries/s at 2025-07-31 06:19:32 Query peak

3h39m8s Total query duration
3m36s Prepare/parse total duration
54s31ms Bind total duration
3h34m37s Execute total duration

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

38 Total number of automatic vacuums
51 Total number of automatic analyzes

616 Number temporary file
152.81 MiB Max size of temporary file
7.03 MiB Average size of temporary file

2,841 Total number of sessions
13 sessions at 2025-07-31 06:56:13 Session peak
2d22h28m53s Total duration of sessions
1m29s Average duration of sessions
34 Average queries per session
4s628ms Average queries duration per session
1m24s Average idle time per session

2,848 Total number of connections
42 connections/s at 2025-07-31 06:34:07 Connection peak
5 Total number of databases

SQL Traffic

Key values

3,049 queries/s Query Peak
2025-07-31 06:19:32 Date

SELECT Traffic

Key values

3,036 queries/s Query Peak
2025-07-31 06:19:32 Date

INSERT/UPDATE/DELETE Traffic

Key values

194 queries/s Query Peak
2025-07-31 06:00:57 Date

Queries duration

Key values

3h39m8s 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)
Jul 31	06	98,149	0ms	14m20s	131ms	6m11s	6m24s	22m13s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 31	06	57,388	600	47ms	1m19s	2m21s	3m55s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 31	06	29,521	2,061	13	78	2ms	918ms	1s846ms	4s692ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Jul 31	06	17,646	67,199	3.81	18.86%

Day	Hour	Count	Average / Second
Jul 31	06	2,848	0.79/s

Day	Hour	Count	Average Duration	Average idle time
Jul 31	06	2,841	1m29s	1m24s

↑ Back to the top of the General Activity table

Established Connections

Key values

42 connections Connection Peak
2025-07-31 06:34:07 Date

Connections per database

Key values

acaweb_fx Main Database
2,848 connections Total

Chart
Table

Database	User	Count
acaweb_fx		2,751
	pg_dump	1
	postgres	2,403
	psql	347
acaweb_fx_integer		1
	pg_dump	1
postgres		3
	pg_dump	1
	psql	2
socialmedia		92
	pg_dump	1
	postgres	91
translations		1
	pg_dump	1

Connections per user

Key values

postgres Main User
2,848 connections Total

Chart
Table

User	Count
pg_dump	5
postgres	2,494
psql	349

Connections per host

Key values

192.168.4.142 Main host with 1180 connections
2,848 Total connections

Chart
Table

Host	Count
127.0.0.1	116
192.168.0.216	100
192.168.0.74	149
192.168.1.145	99
192.168.1.15	128
192.168.1.20	125
192.168.1.231	20
192.168.1.239	12
192.168.1.90	64
192.168.2.126	62
192.168.2.182	12
192.168.2.205	12
192.168.2.82	47
192.168.3.199	36
192.168.4.142	1,180
192.168.4.150	10
192.168.4.17	1
192.168.4.238	16
192.168.4.33	91
192.168.4.98	330
[local]	238

Simultaneous sessions

Key values

13 sessions Session Peak
2025-07-31 06:56:13 Date

Histogram of session times

Key values

2,242 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	2,242	78.92%
500ms-1s	193	6.79%
1s-30s	258	9.08%
30s-1m	19	0.67%
1m-10m	31	1.09%
10m-30m	79	2.78%
30m-1h	7	0.25%
1h-8h	11	0.39%
> 8h	1	0.04%

Sessions per database

Key values

acaweb_fx Main Database
2,841 sessions Total

Chart
Table

Database	User	Count	Total Duration
acaweb_fx	2,744	2d22h2m24s	1m31s
acaweb_fx_integer	1	20m26s	20m26s
postgres	3	275ms	91ms
socialmedia	92	6m1s	3s931ms
translations	1	192ms	192ms

Sessions per user

Key values

postgres Main User
2,841 sessions Total

Chart
Table

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

Sessions per host

Key values

192.168.4.142 Main Host
2,841 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	116	35m51s	18s550ms
192.168.0.216	100	43s106ms	431ms
192.168.0.74	149	13h54m49s	5m36s
192.168.1.145	99	6h24m45s	3m53s
192.168.1.15	121	3h21m7s	1m39s
192.168.1.20	125	15h17m38s	7m20s
192.168.1.231	20	9h52m8s	29m36s
192.168.1.239	12	135ms	11ms
192.168.1.90	64	4m31s	4s245ms
192.168.2.126	62	5s954ms	96ms
192.168.2.182	12	2s606ms	217ms
192.168.2.205	12	504ms	42ms
192.168.2.82	47	6s849ms	145ms
192.168.3.199	36	1s88ms	30ms
192.168.4.142	1,180	8m39s	439ms
192.168.4.150	10	20h20m15s	2h2m1s
192.168.4.17	1	284ms	284ms
192.168.4.238	16	31s59ms	1s941ms
192.168.4.33	91	5m18s	3s496ms
192.168.4.98	330	28s379ms	85ms
[local]	238	21m47s	5s493ms

Sessions per application

Key values

PostgreSQL JDBC Driver Main Host
2,841 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	1,733	2d21h23m26s	2m24s
[unknown]	754	7m47s	620ms
pg_dump	5	35m40s	7m8s
psql	349	21m58s	3s778ms

Checkpoints Buffers

Key values

20,009 buffers Checkpoint Peak
2025-07-31 06:06:16 Date
209.884 seconds Highest write time
0.056 seconds Sync time

Checkpoints Wal files

Key values

6 files Wal files usage Peak
2025-07-31 06:06:16 Date

Checkpoints distance

Key values

176.15 Mo Distance Peak
2025-07-31 06:06:16 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jul 31	06	51,418	1,886.08s	0.123s	1,886.586s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Jul 31	06	0	0	23	2,011	0.056s	0s

Day	Hour	Count	Avg time (sec)
Jul 31	06	0	0s

Day	Hour	Mean distance	Mean estimate
Jul 31	06	31,003.58 kB	64,934.83 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

167.21 MiB Temp Files size Peak
2025-07-31 06:20:12 Date

Number of temporary files

Key values

30 per second Temp Files Peak
2025-07-31 06:02:10 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jul 31	06	616	4.23 GiB	7.03 MiB

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)


Date: 2025-07-31 06:00:44
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 182.165.1.42
Application: [unknown]
Date: 2025-07-31 06:40:27
Duration: 24s864ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.90
Application: [unknown]
Date: 2025-07-31 06:41:16
Duration: 4s240ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-07-31 06:33:16
Duration: 3s354ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-07-31 06:47:47
Duration: 10s337ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-07-31 06:17:42
Duration: 40s412ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-07-31 06:20:38
Duration: 7s15ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-07-31 06:15:49
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	122	547.31 MiB	3.02 MiB	8.36 MiB	4.49 MiB	with rar_max as ( ; WITH rar_max as ( ; Date: 2025-07-31 06:00:44 Duration: 0ms Database: acaweb_fx User: postgres Remote: 182.165.1.42 Application: [unknown]
2	42	1.64 GiB	4.24 MiB	152.81 MiB	39.97 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-07-31 06:40:27 Duration: 24s864ms 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-07-31 06:20:12 Duration: 9s906ms 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-07-31 06:30:11 Duration: 8s957ms Database: acaweb_fx User: postgres Remote: 192.168.1.90 Application: [unknown]
3	13	370.89 MiB	28.52 MiB	28.53 MiB	28.53 MiB	update solr_relevance_old set new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total from ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total from whatshot_probability where type = ?) sub where result_uid = sub.resultuid; UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type = 'cp') sub WHERE result_uid = sub.resultuid; Date: 2025-07-31 06:41:16 Duration: 4s240ms 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-07-31 06:26:15 Duration: 2s888ms 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-07-31 06:31:14 Duration: 2s211ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
4	13	711.34 MiB	54.72 MiB	54.72 MiB	54.72 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-07-31 06:33:16 Duration: 3s354ms 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-07-31 06:31:17 Duration: 2s980ms 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-07-31 06:26:18 Duration: 2s970ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
5	8	632.77 MiB	79.07 MiB	79.11 MiB	79.10 MiB	select updateresultsmaterializedview (); select updateresultsmaterializedview (); Date: 2025-07-31 06:47:47 Duration: 10s337ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateresultsmaterializedview (); Date: 2025-07-31 06:32:47 Duration: 8s697ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateresultsmaterializedview (); Date: 2025-07-31 06:17:50 Duration: 8s470ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
6	4	336.44 MiB	84.06 MiB	84.19 MiB	84.11 MiB	select updateageforrelevantresults (); select updateageforrelevantresults (); Date: 2025-07-31 06:17:42 Duration: 40s412ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateageforrelevantresults (); Date: 2025-07-31 06:32:38 Duration: 36s138ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateageforrelevantresults (); Date: 2025-07-31 06:47:37 Duration: 34s629ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
7	4	47.41 MiB	11.85 MiB	11.85 MiB	11.85 MiB	select updaterelevantforrelevantresults (); select updaterelevantforrelevantresults (); Date: 2025-07-31 06:20:38 Duration: 7s15ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updaterelevantforrelevantresults (); Date: 2025-07-31 06:35:38 Duration: 6s509ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updaterelevantforrelevantresults (); Date: 2025-07-31 06:05:33 Duration: 1s997ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
8	1	3.83 MiB	3.83 MiB	3.83 MiB	3.83 MiB	select resultuid from relevance_fibonacci_results order by resultuid desc limit ?), fr as ( select a., rr.age, rr.relevant from fibonacci_results a left outer join relevance_fibonacci_results rr on a.resultuid = rr.resultuid where case when false = ? then true else a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) end), all_results as ( select fr.resultuid as resultuid, fr.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, fr.pattern as pattern_name, fr.timed as timed, fr.patternendtime as identified, dtt.timezone as timezone, fr.patternlengthbars as length, g.basegroupname, newlevels.filtered, case when fr.age is not null then fr.age when fr.resultuid <= rm.resultuid then ? else ? end as age, case when fr.relevant is not null then fr.relevant when fr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from fr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = fr.symbolid inner join symbols s on fr.symbolid = s.symbolid and s.nonliquid = ? inner join symbolgroup sg on fr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join downloadersymbolsettings dss on fr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join rar_max rm on ? = ? left join lateral calc_fib_signal_filter (fr.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 = ? where fr.gmttimefound > now() - interval ? and dss.enabled = ? and s.deleted = ? and (fr.simulation = ? or fr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or fr.pattern in (...)) and (? = ? or fr.patternlengthbars <= ?) and (? = ? or (? = ? and fr.timed > cast(? as timestamp)) or (? = ? and fr.timed < cast(? as timestamp)))), 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_fibonacci_results ORDER BY resultuid DESC LIMIT 1), fr AS ( SELECT a., rr.age, rr.relevant from fibonacci_results a LEFT OUTER JOIN relevance_fibonacci_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) END), all_results AS ( SELECT fr.resultuid AS resultuid, fr.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, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN fr.age IS NOT NULL THEN fr.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN fr.relevant IS NOT NULL THEN fr.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.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 JOIN LATERAL calc_fib_signal_filter (fr.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 fr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($3 = 0 OR s.timegranularity in ($4, $5, $6, $7, $8, $9, $10)) AND ($11 = 0 OR s.exchange in ($12)) AND ($13 = 0 OR coalesce(bim.code, s.symbol) in ($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, $323)) AND ($324 = 0 OR fr.pattern in ($325)) AND ($326 = 0 OR fr.patternlengthbars <= $327) AND ($328 = 0 OR ($329 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($330 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = $331 OR relevant = 1) AND ($332 = 0 OR age <= $333) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; Date: 2025-07-31 06:15:49 Duration: 0ms Database: acaweb_fx User: postgres Remote: 182.165.1.42 Application: [unknown]

Queries generating the largest temporary files


[ Date: 2025-07-31 06:20:08 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
[ Date: 2025-07-31 06:40:26 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
[ Date: 2025-07-31 06:10:04 ]
[ Date: 2025-07-31 06:30:10 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
[ Date: 2025-07-31 06:00:04 ]
[ Date: 2025-07-31 06:50:04 ]
[ Date: 2025-07-31 06:00:04 ]
[ Date: 2025-07-31 06:02:05 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-07-31 06:32:24 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-07-31 06:47:22 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-07-31 06:17:26 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-07-31 06:32:40 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-07-31 06:47:39 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-07-31 06:50:32 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-07-31 06:35:38 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-07-31 06:17:44 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-07-31 06:02:16 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-07-31 06:20:39 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-07-31 06:05:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-07-31 06:50:06 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]

Rank	Size	Query
1	152.81 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-07-31 06:20:08 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
2	142.66 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-07-31 06:40:26 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
3	137.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-07-31 06:10:04 ]
4	126.18 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-07-31 06:30:10 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
5	99.05 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-07-31 06:00:04 ]
6	89.11 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-07-31 06:50:04 ]
7	88.00 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-07-31 06:00:04 ]
8	84.19 MiB	select updateageforrelevantresults (); [ Date: 2025-07-31 06:02:05 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
9	84.12 MiB	select updateageforrelevantresults (); [ Date: 2025-07-31 06:32:24 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
10	84.07 MiB	select updateageforrelevantresults (); [ Date: 2025-07-31 06:47:22 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
11	84.06 MiB	select updateageforrelevantresults (); [ Date: 2025-07-31 06:17:26 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
12	79.11 MiB	select updateresultsmaterializedview (); [ Date: 2025-07-31 06:32:40 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
13	79.11 MiB	select updateresultsmaterializedview (); [ Date: 2025-07-31 06:47:39 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
14	79.10 MiB	select updateresultsmaterializedview (); [ Date: 2025-07-31 06:50:32 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
15	79.10 MiB	select updateresultsmaterializedview (); [ Date: 2025-07-31 06:35:38 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
16	79.10 MiB	select updateresultsmaterializedview (); [ Date: 2025-07-31 06:17:44 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
17	79.09 MiB	select updateresultsmaterializedview (); [ Date: 2025-07-31 06:02:16 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
18	79.09 MiB	select updateresultsmaterializedview (); [ Date: 2025-07-31 06:20:39 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
19	79.07 MiB	select updateresultsmaterializedview (); [ Date: 2025-07-31 06:05:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
20	70.75 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-07-31 06:50:06 - 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)
51 analyzes Total

Chart
Table

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

Vacuums per table

Key values

public.solr_relevance_old (14) Main table vacuumed on database acaweb_fx
38 vacuums Total

Chart
Table

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
acaweb_fx.public.solr_relevance_old	14	13	11,125	0	42	0	73	7,941	12	1,343,430
acaweb_fx.public.datafeeds_latestrun	5	0	580	0	14	0	0	61	11	61,432
acaweb_fx.pg_toast.pg_toast_2619	3	3	484	0	86	0	0	303	80	364,235
acaweb_fx.public.relevance_autochartist_results	3	3	10,689	0	167	4	693	1,933	1,045	2,684,928
acaweb_fx.public.relevance_fibonacci_results	3	3	3,926	0	178	3	180	478	229	615,637
acaweb_fx.public.latest_t15_candle_view	2	2	162	0	8	0	0	12	2	17,145
acaweb_fx.public.relevance_keylevels_results	2	2	7,521	0	668	2	183	1,713	997	2,846,337
acaweb_fx.pg_catalog.pg_type	1	1	144	0	25	0	0	52	22	108,879
acaweb_fx.public.autochartist_symbolupdates	1	1	25,978	0	1,352	0	38,161	7,223	177	540,290
acaweb_fx.pg_catalog.pg_statistic	1	1	854	0	156	0	665	528	146	634,745
acaweb_fx.pg_catalog.pg_attribute	1	1	748	0	182	0	67	379	149	878,372
acaweb_fx.public.solr_imports	1	1	38	0	3	0	0	6	1	5,933
acaweb_fx.pg_catalog.pg_class	1	1	358	0	25	0	40	140	23	122,257
Total	38	32	62,607	47,024	2,906	9	40,062	20,769	2,894	10,223,620

Tuples removed per table

Key values

public.solr_relevance_old (66337) Main table with removed tuples on database acaweb_fx
79186 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
acaweb_fx.public.solr_relevance_old	14	13	66,337	91,936	8,869	0	2,893
acaweb_fx.public.autochartist_symbolupdates	1	1	5,918	48,003	3	0	40,691
acaweb_fx.public.relevance_autochartist_results	3	3	2,027	27,714	1,600	0	1,140
acaweb_fx.pg_catalog.pg_attribute	1	1	1,642	9,401	28	0	250
acaweb_fx.public.relevance_keylevels_results	2	2	949	24,831	848	0	558
acaweb_fx.pg_catalog.pg_statistic	1	1	822	4,345	0	0	1,194
acaweb_fx.public.relevance_fibonacci_results	3	3	497	4,166	245	0	306
acaweb_fx.pg_catalog.pg_class	1	1	285	1,947	0	0	150
acaweb_fx.public.datafeeds_latestrun	5	0	240	145	75	0	80
acaweb_fx.pg_toast.pg_toast_2619	3	3	180	546	30	0	162
acaweb_fx.pg_catalog.pg_type	1	1	144	1,338	0	0	38
acaweb_fx.public.latest_t15_candle_view	2	2	101	52	24	0	2
acaweb_fx.public.solr_imports	1	1	44	9	8	0	2
Total	38	32	79,186	214,433	11,730	0	47,466

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	3	3	180
acaweb_fx.pg_catalog.pg_type	1	1	144
acaweb_fx.public.datafeeds_latestrun	5	0	240
acaweb_fx.public.autochartist_symbolupdates	1	1	5918
acaweb_fx.pg_catalog.pg_statistic	1	1	822
acaweb_fx.pg_catalog.pg_attribute	1	1	1642
acaweb_fx.public.solr_imports	1	1	44
acaweb_fx.public.latest_t15_candle_view	2	2	101
acaweb_fx.public.relevance_keylevels_results	2	2	949
acaweb_fx.pg_catalog.pg_class	1	1	285
acaweb_fx.public.solr_relevance_old	14	13	66337
acaweb_fx.public.relevance_autochartist_results	3	3	2027
acaweb_fx.public.relevance_fibonacci_results	3	3	497
Total	38	32	79,186

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jul 31	06	38	51

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

AccessShareLock Main Lock Type
6 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
AccessExclusiveLock		2	16m50s	8m25s
	relation	2	16m50s	8m25s
AccessShareLock		4	8m1s	2m
	relation	4	8m1s	2m
	Total	6	24m52s	4m8s

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	1	14m20s	14m20s	14m20s	14m20s	truncate table solr_relevance_old; TRUNCATE TABLE solr_relevance_old; Date: 2025-07-31 06:19:31 Database: acaweb_fx User: postgres Remote: [local] Application: psql TRUNCATE TABLE solr_relevance_old; Date: 2025-07-31 06:20:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql TRUNCATE TABLE solr_relevance_old; Date: 2025-07-31 06:26:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql
2	2	4m30s	2m15s	2m15s	2m15s	select datetimeupdate from latest_candle_datetime_per_receng where recognitionengine ilike ?; SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 2'; Date: 2025-07-31 06:19:32 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: [unknown] SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 3'; Date: 2025-07-31 06:19:32 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: [unknown] SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 2'; Date: 2025-07-31 06:32:04 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: [unknown]
3	2	3m30s	1m27s	2m2s	1m45s	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-07-31 06:19:32 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-07-31 06:56:55 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-07-31 06:08:01 Database: acaweb_fx User: postgres Remote: 192.168.1.90 Application: PostgreSQL JDBC Driver Bind query: yes
4	1	2m30s	2m30s	2m30s	2m30s	refresh materialized view latest_candle_datetime_per_receng; refresh materialized view latest_candle_datetime_per_receng; Date: 2025-07-31 06:19:32 Database: acaweb_fx User: postgres Remote: [local] Application: psql refresh materialized view latest_candle_datetime_per_receng; Date: 2025-07-31 06:32:01 Database: acaweb_fx User: postgres Remote: [local] Application: psql refresh materialized view latest_candle_datetime_per_receng; Date: 2025-07-31 06:47:02 Database: acaweb_fx User: postgres Remote: [local] Application: psql

Queries that waited the most


[ Date: 2025-07-31 06:19:31 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-07-31 06:19:31 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-07-31 06:19:32 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2025-07-31 06:19:32 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2025-07-31 06:19:32 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: PostgreSQL JDBC Driver ]
[ Date: 2025-07-31 06:19:32 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: PostgreSQL JDBC Driver ]

Rank	Wait time	Query
1	14m20s	TRUNCATE TABLE solr_relevance_old; [ Date: 2025-07-31 06:19:31 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	2m30s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2025-07-31 06:19:31 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
3	2m15s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 2'; [ Date: 2025-07-31 06:19:32 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
4	2m15s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 3'; [ Date: 2025-07-31 06:19:32 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
5	2m2s	select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng; [ Date: 2025-07-31 06:19:32 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: PostgreSQL JDBC Driver ]
6	1m27s	select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng; [ Date: 2025-07-31 06:19:32 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: PostgreSQL JDBC Driver ]

Queries by type

Key values

57,388 Total read queries
36,187 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	57,388	58.47%
INSERT	29,521	30.08%
UPDATE	2,061	2.10%
DELETE	13	0.01%
COPY FROM	78	0.08%
COPY TO	600	0.61%
CTE	3,236	3.30%
DDL	13	0.01%
TCL	665	0.68%
CURSOR	0	0.00%
OTHERS	4,574	4.66%

Queries by database

Key values

acaweb_fx Main database
85,834 Requests
3h13m33s (acaweb_fx)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
acaweb_fx	Total	85,834	3h13m33s
	copy from	78	5s127ms
	copy to	305	14m28s
	cte	3,232	2h30m33s
	ddl	13	14m20s
	delete	13	20ms
	insert	21,986	34s479ms
	others	4,243	2m55s
	select	53,356	10m7s
	tcl	661	190ms
	update	1,947	27s788ms
acaweb_fx_integer	Total	3,589	20m11s
	copy to	276	20m9s
	cte	1	5ms
	others	285	20ms
	select	3,026	1s114ms
	tcl	1	0ms
postgres	Total	367	247ms
	cte	1	1ms
	others	9	0ms
	select	356	245ms
	tcl	1	0ms
socialmedia	Total	8,312	52s241ms
	copy to	19	42s820ms
	cte	1	1ms
	insert	7,535	8s715ms
	others	28	0ms
	select	614	512ms
	tcl	1	0ms
	update	114	190ms
translations	Total	47	181ms
	cte	1	1ms
	others	9	0ms
	select	36	179ms
	tcl	1	0ms

Queries by user

Key values

postgres Main user
98,149 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	98,149	3h34m37s
	copy from	78	5s127ms
	copy to	600	35m21s
	cte	3,236	2h30m33s
	ddl	13	14m20s
	delete	13	20ms
	insert	29,521	43s195ms
	others	4,574	2m55s
	select	57,388	10m9s
	tcl	665	190ms
	update	2,061	27s979ms

Duration by user

Key values

3h34m37s (postgres) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	98,149	3h34m37s
	copy from	78	5s127ms
	copy to	600	35m21s
	cte	3,236	2h30m33s
	ddl	13	14m20s
	delete	13	20ms
	insert	29,521	43s195ms
	others	4,574	2m55s
	select	57,388	10m9s
	tcl	665	190ms
	update	2,061	27s979ms

Queries by host

Key values

127.0.0.1 Main host
19,576 Requests
40m36s (127.0.0.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	19,576	40m36s
	copy to	600	35m21s
	cte	25	257ms
	insert	9,116	14s397ms
	others	619	25ms
	select	7,811	4m59s
	tcl	5	0ms
	update	1,400	1s597ms
182.165.1.42	Total	218	8m13s
	cte	60	8m13s
	select	158	252ms
192.168.0.216	Total	400	384ms
	others	200	20ms
	select	192	226ms
	update	8	137ms
192.168.0.236	Total	44	27ms
	cte	4	2ms
	select	40	25ms
192.168.0.239	Total	260	2s906ms
	select	260	2s906ms
192.168.0.42	Total	1,162	2s159ms
	insert	369	55ms
	select	793	2s103ms
192.168.0.74	Total	6,273	39m34s
	cte	793	39m27s
	others	298	3ms
	select	5,182	7s341ms
192.168.1.135	Total	134	645ms
	cte	8	266ms
	select	126	379ms
192.168.1.145	Total	16,019	35m6s
	cte	766	34m48s
	others	198	2ms
	select	15,055	17s134ms
192.168.1.15	Total	6,835	29m19s
	cte	681	29m15s
	others	256	3ms
	select	5,898	4s15ms
192.168.1.20	Total	18,227	37m6s
	cte	794	36m46s
	others	250	2ms
	select	17,183	20s249ms
192.168.1.201	Total	1,155	8s1ms
	select	1,155	8s1ms
192.168.1.23	Total	1,318	11s977ms
	select	1,318	11s977ms
192.168.1.231	Total	40	0ms
	others	40	0ms
192.168.1.239	Total	48	31ms
	others	24	2ms
	select	24	29ms
192.168.1.49	Total	10	1ms
	cte	1	0ms
	select	9	1ms
192.168.1.90	Total	120	59s106ms
	cte	6	59s2ms
	others	32	0ms
	select	82	103ms
192.168.1.97	Total	28	54ms
	cte	3	0ms
	select	25	53ms
192.168.2.126	Total	80	65ms
	others	18	0ms
	select	62	64ms
192.168.2.182	Total	48	286ms
	others	24	2ms
	select	12	11ms
	update	12	272ms
192.168.2.205	Total	137	121ms
	insert	89	10ms
	others	24	2ms
	select	20	21ms
	update	4	86ms
192.168.2.82	Total	1,379	4s623ms
	insert	960	3s837ms
	others	94	10ms
	select	192	111ms
	update	133	663ms
192.168.3.199	Total	144	194ms
	others	72	7ms
	select	60	65ms
	update	12	121ms
192.168.4.142	Total	15,114	17s618ms
	insert	11,452	16s178ms
	others	2,360	29ms
	select	1,302	1s410ms
192.168.4.150	Total	22	1s598ms
	others	21	0ms
	select	1	1s598ms
192.168.4.17	Total	3	132ms
	cte	1	132ms
	others	2	0ms
192.168.4.238	Total	48	29s683ms
	cte	16	29s682ms
	others	32	0ms
192.168.4.33	Total	8,021	9s156ms
	insert	7,535	8s715ms
	select	372	250ms
	update	114	190ms
192.168.4.98	Total	996	23s744ms
	others	6	22s817ms
	select	6	31ms
	tcl	660	190ms
	update	324	704ms
[local]	Total	290	21m46s
	copy from	78	5s127ms
	cte	78	32s104ms
	ddl	13	14m20s
	delete	13	20ms
	others	4	2m32s
	select	50	3m51s
	update	54	24s204ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
64,930 Requests
2h22m22s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	64,930	2h22m22s
	cte	3,059	2h20m49s
	insert	11,821	16s233ms
	others	1,741	25ms
	select	48,309	1m17s
[unknown]	Total	24,620	15m3s
	cte	74	9m12s
	insert	17,700	26s961ms
	others	2,210	22s881ms
	select	1,980	4m57s
	tcl	660	190ms
	update	1,996	3s751ms
pg_dump	Total	8,198	35m13s
	copy to	574	35m11s
	cte	5	15ms
	others	619	25ms
	select	6,995	2s648ms
	tcl	5	0ms
psql	Total	401	21m57s
	copy from	78	5s127ms
	copy to	26	10s64ms
	cte	98	32s346ms
	ddl	13	14m20s
	delete	13	20ms
	others	4	2m32s
	select	104	3m52s
	update	65	24s227ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-07-31 06:42:22 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

58,702 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	58,702	59.81%
1-5ms	33,504	34.14%
5-10ms	2,103	2.14%
10-25ms	1,106	1.13%
25-50ms	417	0.42%
50-100ms	278	0.28%
100-500ms	537	0.55%
500-1000ms	146	0.15%
1000-10000ms	1,030	1.05%
> 10000ms	326	0.33%

Slowest individual queries


[ Date: 2025-07-31 06:19:31 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-07-31 06:08:29 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-07-31 06:32:43 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-07-31 06:14:20 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-07-31 06:19:32 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-07-31 06:21:54 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-07-31 06:19:32 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2025-07-31 06:19:32 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2025-07-31 06:37:14 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-07-31 06:25:02 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-07-31 06:28:40 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-07-31 06:23:21 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-07-31 06:17:04 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-07-31 06:11:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-07-31 06:29:50 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-07-31 06:15:30 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-07-31 06:39:02 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-07-31 06:18:10 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-07-31 06:33:44 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-07-31 06:26:16 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]

Rank	Duration	Query
1	14m20s	TRUNCATE TABLE solr_relevance_old; [ Date: 2025-07-31 06:19:31 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	3m26s	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-07-31 06:08:29 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
3	2m48s	COPY public.researchreports (researchreportid, type, createddatetime, language, filename, xml) TO stdout; [ Date: 2025-07-31 06:32:43 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
4	2m41s	COPY public.researchreports (researchreportid, type, createddatetime, language, filename, xml) TO stdout; [ Date: 2025-07-31 06:14:20 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
5	2m31s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2025-07-31 06:19:32 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
6	2m21s	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-07-31 06:21:54 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
7	2m15s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 2'; [ Date: 2025-07-31 06:19:32 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
8	2m15s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ICMARKETS-AU-MT5 - 3'; [ Date: 2025-07-31 06:19:32 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
9	2m	COPY public.t15_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2025-07-31 06:37:14 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
10	1m41s	COPY public.autochartist_results (resultid, bandwidth, pattern, gmttimefound, direction, initialtrend, breakout, volumeincrease, noise, symmetry, patternstarttime, patternendtime, patternstartprice, patternendprice, resx0, resx1, supportx0, supportx1, resy0, resy1, supporty0, supporty1, supportgradient, resgradient, riskreward, qtytp, predictionpricefrom, predictionpriceto, predictiontimefrom, predictiontimeto, patternquality, trendchange, maxmovementafterbreakout, latestbaratbreakouttime, latestbaratbreakoutprice, patternlengthbars, temporarypattern, symbolid, resultuid, relevancestartdistance, simulation, writtendatetime, old_resultuid) TO stdout; [ Date: 2025-07-31 06:25:02 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
11	1m23s	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-07-31 06:28:40 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
12	1m19s	COPY public.authenticationlog (attemptid, username, password, brokerid, authclass, attemptdatetime, success, fingerprint, accounttype) TO stdout; [ Date: 2025-07-31 06:23:21 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
13	1m10s	COPY public.t15_hve (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived, pricesadjusted, relevanceprocessed, recengprocessedadjusted) TO stdout; [ Date: 2025-07-31 06:17:04 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
14	1m10s	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-07-31 06:11:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
15	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-07-31 06:29:50 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
16	1m7s	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-07-31 06:15:30 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
17	1m5s	COPY public.t30_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2025-07-31 06:39:02 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
18	1m5s	COPY public.t15_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2025-07-31 06:18:10 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
19	57s991ms	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-07-31 06:33:44 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
20	50s928ms	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-07-31 06:26:16 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]

Time consuming queries


[ User: postgres - Total duration: 1h4m13s - Times executed: 437 ]
[ User: postgres - Total duration: 1h41s - Times executed: 436 ]
[ User: postgres - Total duration: 20m5s - Times executed: 395 ]
[ User: postgres - Total duration: 14m20s - Times executed: 13 ]
[ User: postgres - Total duration: 5m48s - Times executed: 2 ]
[ User: postgres - Total duration: 5m30s - Times executed: 2 ]
[ User: postgres - Total duration: 4m30s - Times executed: 230 ]
[ User: postgres - Total duration: 3m5s - Times executed: 2 ]
[ User: postgres - Total duration: 2m32s - Times executed: 4 ]
[ User: postgres - Total duration: 2m19s - Times executed: 2 ]
[ User: postgres - Total duration: 2m5s - Times executed: 4 ]
[ User: postgres - Total duration: 2m5s - Times executed: 2 ]
[ User: postgres - Total duration: 2m4s - Times executed: 252 ]
[ User: postgres - Total duration: 1m59s - Times executed: 2 ]
[ User: postgres - Total duration: 1m57s - Times executed: 2 ]
[ User: postgres - Total duration: 1m53s - Times executed: 2 ]
[ User: postgres - Total duration: 1m28s - Times executed: 2 ]
[ User: postgres - Total duration: 1m23s - Times executed: 2 ]
[ User: postgres - Total duration: 1m22s - Times executed: 121 ]
[ User: postgres - Total duration: 59s98ms - Times executed: 2 ]

Most frequent queries (N)


[ User: postgres - Total duration: 89ms - Times executed: 20446 ]
[ User: postgres - Total duration: 15s417ms - Times executed: 11324 ]
[ User: postgres - Total duration: 21s39ms - Times executed: 9656 ]
[ User: postgres - Total duration: 8s160ms - Times executed: 7144 ]
[ User: postgres - Total duration: 11s415ms - Times executed: 5576 ]
[ User: postgres - Total duration: 7s733ms - Times executed: 5027 ]
[ User: postgres - Total duration: 3s213ms - Times executed: 3285 ]
[ User: postgres - Total duration: 2s74ms - Times executed: 2679 ]
[ User: postgres - Total duration: 1s25ms - Times executed: 2242 ]
[ User: postgres - Total duration: 17ms - Times executed: 1766 ]
[ User: postgres - Total duration: 25ms - Times executed: 1740 ]
[ User: postgres - Total duration: 25ms - Times executed: 1642 ]
[ User: postgres - Total duration: 1s574ms - Times executed: 1389 ]
[ User: postgres - Total duration: 4s350ms - Times executed: 1336 ]
[ User: postgres - Total duration: 121ms - Times executed: 921 ]
[ User: postgres - Total duration: 95ms - Times executed: 803 ]
[ User: postgres - Total duration: 224ms - Times executed: 756 ]
[ User: postgres - Total duration: 237ms - Times executed: 730 ]
[ User: postgres - Total duration: 88ms - Times executed: 645 ]
[ User: postgres - Total duration: 1s119ms - Times executed: 603 ]

Normalized slowest queries (N)


[ User: postgres - Total duration: 5m48s - Times executed: 2 ]
[ User: postgres - Total duration: 5m30s - Times executed: 2 ]
[ User: postgres - Total duration: 3m5s - Times executed: 2 ]
[ User: postgres - Total duration: 2m19s - Times executed: 2 ]
[ User: postgres - Total duration: 14m20s - Times executed: 13 ]
[ User: postgres - Total duration: 2m5s - Times executed: 2 ]
[ User: postgres - Total duration: 1m59s - Times executed: 2 ]
[ User: postgres - Total duration: 1m57s - Times executed: 2 ]
[ User: postgres - Total duration: 1m53s - Times executed: 2 ]
[ User: postgres - Total duration: 1m28s - Times executed: 2 ]
[ User: postgres - Total duration: 1m23s - Times executed: 2 ]
[ User: postgres - Total duration: 2m32s - Times executed: 4 ]
[ User: postgres - Total duration: 2m5s - Times executed: 4 ]
[ User: postgres - Total duration: 59s98ms - Times executed: 2 ]
[ User: postgres - Total duration: 1h4m13s - Times executed: 437 ]
[ User: postgres - Total duration: 1h41s - Times executed: 436 ]
[ User: postgres - Total duration: 20m5s - Times executed: 395 ]
[ User: postgres - Total duration: 4m30s - Times executed: 230 ]
[ User: postgres - Total duration: 1m22s - Times executed: 121 ]
[ User: postgres - Total duration: 2m4s - Times executed: 252 ]

Time consuming prepare


[ User: postgres - Total duration: 0ms - Times executed: 12 ]
[ User: postgres - Total duration: 1h56m52s - Times executed: 2298 ]
[ User: postgres - Total duration: 11s674ms - Times executed: 3192 ]
[ User: postgres - Total duration: 1s119ms - Times executed: 603 ]
[ User: postgres - Total duration: 4s831ms - Times executed: 1061 ]
[ User: postgres - Total duration: 2s943ms - Times executed: 2860 ]
[ User: postgres - Total duration: 17ms - Times executed: 1766 ]
[ User: postgres - Total duration: 936ms - Times executed: 1793 ]
[ User: postgres - Total duration: 29s682ms - Times executed: 16 ]
[ User: postgres - Total duration: 43s865ms - Times executed: 70 ]
[ User: postgres - Total duration: 7ms - Times executed: 1445 ]
[ User: postgres - Total duration: 32ms - Times executed: 18 ]
[ User: postgres - Total duration: 418ms - Times executed: 156 ]
[ User: postgres - Total duration: 0ms - Times executed: 4 ]
[ User: postgres - Total duration: 105ms - Times executed: 193 ]
[ User: postgres - Total duration: 25ms - Times executed: 1740 ]
[ User: postgres - Total duration: 11ms - Times executed: 6 ]
[ User: postgres - Total duration: 38ms - Times executed: 12 ]
[ User: postgres - Total duration: 58ms - Times executed: 24 ]
[ User: postgres - Total duration: 59s2ms - Times executed: 6 ]

Time consuming bind


[ User: postgres - Total duration: 2h27m9s - Times executed: 2911 ]
[ User: postgres - Total duration: 46s976ms - Times executed: 23899 ]
[ User: postgres - Total duration: 1s119ms - Times executed: 603 ]
[ User: postgres - Total duration: 1m22s - Times executed: 121 ]
[ User: postgres - Total duration: 646ms - Times executed: 31 ]
[ User: postgres - Total duration: 29s682ms - Times executed: 16 ]
[ User: postgres - Total duration: 0ms - Times executed: 47 ]
[ User: postgres - Total duration: 11s415ms - Times executed: 5576 ]
[ User: postgres - Total duration: 76ms - Times executed: 20300 ]
[ User: postgres - Total duration: 3s213ms - Times executed: 3285 ]
[ User: postgres - Total duration: 1s25ms - Times executed: 2242 ]
[ User: postgres - Total duration: 223ms - Times executed: 29 ]
[ User: postgres - Total duration: 162ms - Times executed: 1387 ]
[ User: postgres - Total duration: 877ms - Times executed: 75 ]
[ User: postgres - Total duration: 59s2ms - Times executed: 6 ]
[ User: postgres - Total duration: 132ms - Times executed: 1 ]
[ User: postgres - Total duration: 1s1ms - Times executed: 12 ]
[ User: postgres - Total duration: 284ms - Times executed: 73 ]
[ User: postgres - Total duration: 418ms - Times executed: 156 ]
[ User: postgres - Total duration: 32ms - Times executed: 364 ]

Log levels

Key values

279,651 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	356	0.13%
DETAIL	86,495	30.93%
ERROR	5	0.00%
LOG	192,297	68.76%
STATEMENT	498	0.18%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
11 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

7 Max number of times the same event was reported
11 Total events found

Rank

Times reported

Error

1

7

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jul 31	06	7

LOG: process 29368 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.060 ms at character 28
LOG: process 25614 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.050 ms at character 28
LOG: process 18485 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.063 ms at character 77

2

4

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jul 31	06	4

LOG: process 14511 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 1000.056 ms
LOG: process 14511 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 52178.458 ms
LOG: process 18353 still waiting for AccessExclusiveLock on relation 5894441 of database 5881926 after 1000.058 ms

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