pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Fri Jan 24 04:59:57 2025
Log file: /home/postgres/pg_data/data/pg_log/postgresql-2025-01-24_060000.log
Parsed 1,821,662 log entries in 55s
Log start from 2025-01-24 06:00:00 to 2025-01-24 06:59:55

Global Stats

979 Number of unique normalized queries
125,447 Number of queries
2h28m Total query duration
2025-01-24 06:00:00 First query
2025-01-24 06:59:55 Last query
3,066 queries/s at 2025-01-24 06:05:02 Query peak

2h28m Total query duration
9s168ms Prepare/parse total duration
1m29s Bind total duration
2h26m21s Execute total duration

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

35 Total number of automatic vacuums
51 Total number of automatic analyzes

647 Number temporary file
122.80 MiB Max size of temporary file
4.27 MiB Average size of temporary file

3,563 Total number of sessions
13 sessions at 2025-01-24 06:56:12 Session peak
2d21h42m38s Total duration of sessions
1m10s Average duration of sessions
35 Average queries per session
2s492ms Average queries duration per session
1m7s Average idle time per session

3,563 Total number of connections
28 connections/s at 2025-01-24 06:13:48 Connection peak
5 Total number of databases

SQL Traffic

Key values

3,066 queries/s Query Peak
2025-01-24 06:05:02 Date

SELECT Traffic

Key values

3,046 queries/s Query Peak
2025-01-24 06:05:02 Date

INSERT/UPDATE/DELETE Traffic

Key values

133 queries/s Query Peak
2025-01-24 06:11:37 Date

Queries duration

Key values

2h28m 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)
Jan 24	06	125,447	0ms	13m16s	70ms	4m33s	5m7s	15m48s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 24	06	92,304	597	24ms	1m2s	1m53s	2m48s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 24	06	21,623	2,404	13	78	1ms	618ms	1s182ms	2s489ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Jan 24	06	23,530	102,544	4.36	19.36%

Day	Hour	Count	Average / Second
Jan 24	06	3,563	0.99/s

Day	Hour	Count	Average Duration	Average idle time
Jan 24	06	3,563	1m10s	1m7s

↑ Back to the top of the General Activity table

Established Connections

Key values

28 connections Connection Peak
2025-01-24 06:13:48 Date

Connections per database

Key values

acaweb_fx Main Database
3,563 connections Total

Chart
Table

Database	User	Count
acaweb_fx		3,492
	pg_dump	1
	postgres	3,149
	psql	342
acaweb_fx_integer		1
	pg_dump	1
postgres		3
	pg_dump	1
	psql	2
socialmedia		66
	pg_dump	1
	postgres	65
translations		1
	pg_dump	1

Connections per user

Key values

postgres Main User
3,563 connections Total

Chart
Table

User	Count
pg_dump	5
postgres	3,214
psql	344

Connections per host

Key values

192.168.4.142 Main host with 1099 connections
3,563 Total connections

Chart
Table

Host	Count
127.0.0.1	120
192.168.0.216	92
192.168.1.145	146
192.168.1.20	179
192.168.1.23	760
192.168.1.231	20
192.168.1.250	256
192.168.1.90	52
192.168.2.126	62
192.168.2.182	12
192.168.2.205	12
192.168.2.82	48
192.168.3.199	60
192.168.4.142	1,099
192.168.4.150	10
192.168.4.196	4
192.168.4.206	4
192.168.4.229	1
192.168.4.238	8
192.168.4.33	65
192.168.4.98	318
[local]	235

Simultaneous sessions

Key values

13 sessions Session Peak
2025-01-24 06:56:12 Date

Histogram of session times

Key values

2,897 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	2,897	81.31%
500ms-1s	163	4.57%
1s-30s	278	7.80%
30s-1m	14	0.39%
1m-10m	108	3.03%
10m-30m	90	2.53%
30m-1h	2	0.06%
1h-8h	11	0.31%
> 8h	0	0.00%

Sessions per database

Key values

acaweb_fx Main Database
3,563 sessions Total

Chart
Table

Database	User	Count	Total Duration
acaweb_fx	3,492	2d21h22m55s	1m11s
acaweb_fx_integer	1	19m16s	19m16s
postgres	3	253ms	84ms
socialmedia	66	26s59ms	394ms
translations	1	161ms	161ms

Sessions per user

Key values

postgres Main User
3,563 sessions Total

Chart
Table

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

Sessions per host

Key values

192.168.4.142 Main Host
3,563 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	120	1h3m12s	31s600ms
192.168.0.216	92	41s531ms	451ms
192.168.1.145	146	3h58m37s	1m38s
192.168.1.20	179	14h2m32s	4m42s
192.168.1.23	760	2h35s	9s520ms
192.168.1.231	20	9h51m47s	29m35s
192.168.1.250	256	17h55m19s	4m12s
192.168.1.90	52	45s429ms	873ms
192.168.2.126	62	6s428ms	103ms
192.168.2.182	12	783ms	65ms
192.168.2.205	12	359ms	29ms
192.168.2.82	48	14s417ms	300ms
192.168.3.199	60	930ms	15ms
192.168.4.142	1,099	15m24s	841ms
192.168.4.150	10	20h15m6s	2h1m30s
192.168.4.196	4	37ms	9ms
192.168.4.206	4	32ms	8ms
192.168.4.229	1	216ms	216ms
192.168.4.238	8	11s916ms	1s489ms
192.168.4.33	65	4s671ms	71ms
192.168.4.98	318	23s333ms	73ms
[local]	235	17m32s	4s478ms

Sessions per application

Key values

[unknown] Main Host
3,563 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	1,388	2d20h4m11s	2m56s
[unknown]	1,826	47m42s	1s567ms
pg_dump	5	33m4s	6m36s
psql	344	17m39s	3s79ms

Checkpoints Buffers

Key values

9,524 buffers Checkpoint Peak
2025-01-24 06:45:49 Date
209.924 seconds Highest write time
0.013 seconds Sync time

Checkpoints Wal files

Key values

3 files Wal files usage Peak
2025-01-24 06:15:49 Date

Checkpoints distance

Key values

95.57 Mo Distance Peak
2025-01-24 06:15:49 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jan 24	06	55,369	2,518.617s	0.074s	2,519.026s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Jan 24	06	0	0	24	2,316	0.007s	0s

Day	Hour	Count	Avg time (sec)
Jan 24	06	0	0s

Day	Hour	Mean distance	Mean estimate
Jan 24	06	33,345.25 kB	46,394.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

135.25 MiB Temp Files size Peak
2025-01-24 06:20:10 Date

Number of temporary files

Key values

62 per second Temp Files Peak
2025-01-24 06:47:25 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jan 24	06	647	2.70 GiB	4.27 MiB

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)


Date: 2025-01-24 06:00:38
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.250
Application: PostgreSQL JDBC Driver
Date: 2025-01-24 06:30:12
Duration: 9s104ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.90
Application: [unknown]
Date: 2025-01-24 06:41:14
Duration: 3s49ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-01-24 06:31:18
Duration: 4s191ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2025-01-24 06:32:28
Duration: 25s432ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	109	446.85 MiB	3.09 MiB	8.76 MiB	4.10 MiB	with rar_max as ( ; WITH rar_max as ( ; Date: 2025-01-24 06:00:38 Duration: 0ms Database: acaweb_fx User: postgres Remote: 192.168.1.250 Application: PostgreSQL JDBC Driver
2	40	1.46 GiB	2.59 MiB	122.80 MiB	37.41 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-01-24 06:30:12 Duration: 9s104ms 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-01-24 06:40:10 Duration: 8s516ms 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-01-24 06:20:10 Duration: 8s210ms Database: acaweb_fx User: postgres Remote: 192.168.1.90 Application: [unknown]
3	13	197.34 MiB	15.18 MiB	15.18 MiB	15.18 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-01-24 06:41:14 Duration: 3s49ms 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-01-24 06:31:13 Duration: 2s265ms 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-01-24 06:18:30 Duration: 1s580ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
4	13	407.55 MiB	31.34 MiB	31.35 MiB	31.35 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-01-24 06:31:18 Duration: 4s191ms 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-01-24 06:26:15 Duration: 2s499ms 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-01-24 06:35:14 Duration: 1s576ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
5	4	217.71 MiB	54.38 MiB	54.51 MiB	54.43 MiB	select updateageforrelevantresults (); select updateageforrelevantresults (); Date: 2025-01-24 06:32:28 Duration: 25s432ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateageforrelevantresults (); Date: 2025-01-24 06:47:27 Duration: 25s105ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateageforrelevantresults (); Date: 2025-01-24 06:17:25 Duration: 23s37ms Database: acaweb_fx User: postgres Remote: [local] Application: psql

Queries generating the largest temporary files

Rank	Size	Query
1	122.80 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-01-24 06:30:09 ]
2	113.91 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-01-24 06:50:05 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
3	111.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-01-24 06:40:08 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
4	101.46 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-01-24 06:10:05 ]
5	79.12 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-01-24 06:00:04 ]
6	76.48 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-01-24 06:10:06 ]
7	73.41 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-01-24 06:20:08 ]
8	68.02 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-01-24 06:00:04 ]
9	67.43 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-01-24 06:20:08 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
10	54.51 MiB	select updateageforrelevantresults (); [ Date: 2025-01-24 06:17:19 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
11	54.44 MiB	select updateageforrelevantresults (); [ Date: 2025-01-24 06:47:20 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
12	54.39 MiB	select updateageforrelevantresults (); [ Date: 2025-01-24 06:02:04 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
13	54.38 MiB	select updateageforrelevantresults (); [ Date: 2025-01-24 06:32:20 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
14	52.02 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-01-24 06:30:08 ]
15	48.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-01-24 06:50:04 ]
16	48.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-01-24 06:50:04 ]
17	48.25 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-01-24 06:40:07 ]
18	48.16 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-01-24 06:00:04 ]
19	38.37 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-01-24 06:20:07 ]
20	35.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-01-24 06:30:09 ]

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 (13) Main table analyzed (database acaweb_fx)
51 analyzes Total

Chart
Table

Table	Number of analyzes
acaweb_fx.public.solr_relevance_old	13
acaweb_fx.pg_catalog.pg_attribute	6
acaweb_fx.public.datafeeds_latestrun	4
acaweb_fx.public.relevance_keylevels_results	4
acaweb_fx.pg_catalog.pg_class	4
acaweb_fx.public.relevance_autochartist_results	4
acaweb_fx.public.relevance_fibonacci_results	4
acaweb_fx.pg_catalog.pg_type	3
acaweb_fx.pg_catalog.pg_index	2
acaweb_fx.public.latest_t15_candle_view	2
acaweb_fx.public.autochartist_symbolupdates	1
acaweb_fx.public.symbollatestupdatetime	1
acaweb_fx.public.relevance_bigmovement_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 (13) Main table vacuumed on database acaweb_fx
35 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	11,334	0	40	0	0	8,667	13	1,580,147
acaweb_fx.public.datafeeds_latestrun	4	0	416	0	12	0	0	60	12	61,632
acaweb_fx.public.relevance_keylevels_results	3	3	11,080	0	522	2	169	2,467	369	1,319,118
acaweb_fx.public.relevance_autochartist_results	3	3	10,800	0	309	2	630	1,649	213	738,140
acaweb_fx.pg_toast.pg_toast_2619	2	2	293	0	81	0	0	207	56	246,940
acaweb_fx.pg_catalog.pg_attribute	2	2	1,600	0	355	0	128	796	292	1,726,405
acaweb_fx.pg_catalog.pg_class	2	2	726	0	85	0	82	245	80	374,496
acaweb_fx.public.relevance_fibonacci_results	2	2	2,469	0	107	0	104	380	177	461,511
acaweb_fx.pg_catalog.pg_type	1	1	176	0	16	0	0	50	14	88,006
acaweb_fx.public.autochartist_symbolupdates	1	1	24,593	0	2,611	3	36,799	6,783	3,460	1,385,714
acaweb_fx.public.relevance_bigmovement_results	1	1	162	0	16	0	0	37	13	61,019
acaweb_fx.public.latest_t15_candle_view	1	1	92	0	3	0	0	6	0	867
Total	35	31	63,741	54,232	4,157	7	37,912	21,347	4,699	8,043,995

Tuples removed per table

Key values

public.solr_relevance_old (78316) Main table with removed tuples on database acaweb_fx
94081 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	78,316	80,827	0	0	2,822
acaweb_fx.public.autochartist_symbolupdates	1	1	5,462	49,211	68	0	40,691
acaweb_fx.public.relevance_keylevels_results	3	3	3,408	38,148	2,259	0	837
acaweb_fx.pg_catalog.pg_attribute	2	2	3,348	18,882	0	0	484
acaweb_fx.public.relevance_autochartist_results	3	3	2,100	26,991	1,417	0	1,140
acaweb_fx.pg_catalog.pg_class	2	2	492	3,965	75	0	300
acaweb_fx.public.relevance_fibonacci_results	2	2	437	2,578	0	0	204
acaweb_fx.public.datafeeds_latestrun	4	0	209	96	40	0	64
acaweb_fx.pg_toast.pg_toast_2619	2	2	148	356	16	0	100
acaweb_fx.public.relevance_bigmovement_results	1	1	72	818	49	0	15
acaweb_fx.pg_catalog.pg_type	1	1	46	1,373	39	0	38
acaweb_fx.public.latest_t15_candle_view	1	1	43	30	16	0	1
Total	35	31	94,081	223,275	3,979	0	46,696

Pages removed per table

Key values

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

Chart
Table

Pages removed per tables

NO DATASET

Table	Number of vacuums	Index scans	Tuples removed
acaweb_fx.pg_toast.pg_toast_2619	2	2	148
acaweb_fx.pg_catalog.pg_type	1	1	46
acaweb_fx.public.autochartist_symbolupdates	1	1	5462
acaweb_fx.public.datafeeds_latestrun	4	0	209
acaweb_fx.pg_catalog.pg_attribute	2	2	3348
acaweb_fx.public.relevance_bigmovement_results	1	1	72
acaweb_fx.public.latest_t15_candle_view	1	1	43
acaweb_fx.public.relevance_keylevels_results	3	3	3408
acaweb_fx.public.relevance_autochartist_results	3	3	2100
acaweb_fx.public.solr_relevance_old	13	13	78316
acaweb_fx.pg_catalog.pg_class	2	2	492
acaweb_fx.public.relevance_fibonacci_results	2	2	437
Total	35	31	94,081

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jan 24	06	35	51

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

AccessExclusiveLock Main Lock Type
2 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
AccessExclusiveLock		2	14m43s	7m21s
	relation	2	14m43s	7m21s
	Total	2	14m43s	7m21s

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	1	13m16s	13m16s	13m16s	13m16s	truncate table solr_relevance_old; TRUNCATE TABLE solr_relevance_old; Date: 2025-01-24 06:18:28 Database: acaweb_fx User: postgres Remote: [local] Application: psql TRUNCATE TABLE solr_relevance_old; Date: 2025-01-24 06:46:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql TRUNCATE TABLE solr_relevance_old; Date: 2025-01-24 06:33:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql
2	1	1m27s	1m27s	1m27s	1m27s	refresh materialized view latest_candle_datetime_per_receng; refresh materialized view latest_candle_datetime_per_receng; Date: 2025-01-24 06:18:28 Database: acaweb_fx User: postgres Remote: [local] Application: psql refresh materialized view latest_candle_datetime_per_receng; Date: 2025-01-24 06:32:02 Database: acaweb_fx User: postgres Remote: [local] Application: psql refresh materialized view latest_candle_datetime_per_receng; Date: 2025-01-24 06:47:01 Database: acaweb_fx User: postgres Remote: [local] Application: psql

Rank

Count

Total time

Min time

Max time

Avg duration

Query

1

13m16s

truncate table solr_relevance_old;

TRUNCATE TABLE solr_relevance_old;

Date: 2025-01-24 06:18:28 Database: acaweb_fx User: postgres Remote: [local] Application: psql
TRUNCATE TABLE solr_relevance_old;

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

Date: 2025-01-24 06:33:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql

2

1

1m27s

refresh materialized view latest_candle_datetime_per_receng;

refresh materialized view latest_candle_datetime_per_receng;

Date: 2025-01-24 06:18:28 Database: acaweb_fx User: postgres Remote: [local] Application: psql
refresh materialized view latest_candle_datetime_per_receng;

Date: 2025-01-24 06:32:02 Database: acaweb_fx User: postgres Remote: [local] Application: psql
refresh materialized view latest_candle_datetime_per_receng;

Date: 2025-01-24 06:47:01 Database: acaweb_fx User: postgres Remote: [local] Application: psql

Queries that waited the most

Rank	Wait time	Query
1	13m16s	TRUNCATE TABLE solr_relevance_old; [ Date: 2025-01-24 06:18:28 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	1m27s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2025-01-24 06:18:28 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

Rank

Wait time

Query

1

13m16s

TRUNCATE TABLE solr_relevance_old;

[ Date: 2025-01-24 06:18:28 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

2

1m27s

refresh materialized view latest_candle_datetime_per_receng;

[ Date: 2025-01-24 06:18:28 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

Queries by type

Key values

92,304 Total read queries
29,248 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	92,304	73.58%
INSERT	21,623	17.24%
UPDATE	2,404	1.92%
DELETE	13	0.01%
COPY FROM	78	0.06%
COPY TO	597	0.48%
CTE	3,879	3.09%
DDL	13	0.01%
TCL	641	0.51%
CURSOR	0	0.00%
OTHERS	3,895	3.10%

Queries by database

Key values

acaweb_fx Main database
121,043 Requests
2h7m1s (acaweb_fx)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
acaweb_fx	Total	121,043	2h7m1s
	copy from	78	4s309ms
	copy to	305	13m20s
	cte	3,875	1h32m23s
	ddl	13	13m16s
	delete	13	20ms
	insert	21,575	25s317ms
	others	3,567	1m47s
	select	88,586	5m26s
	tcl	637	180ms
	update	2,394	17s391ms
acaweb_fx_integer	Total	3,584	19m1s
	copy to	276	19m
	cte	1	5ms
	others	285	20ms
	select	3,021	1s107ms
	tcl	1	0ms
postgres	Total	367	229ms
	cte	1	1ms
	others	9	0ms
	select	356	227ms
	tcl	1	0ms
socialmedia	Total	406	17s586ms
	copy to	16	17s191ms
	cte	1	1ms
	insert	48	68ms
	others	25	0ms
	select	305	307ms
	tcl	1	0ms
	update	10	17ms
translations	Total	47	154ms
	cte	1	1ms
	others	9	0ms
	select	36	152ms
	tcl	1	0ms

Queries by user

Key values

postgres Main user
125,447 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	125,447	2h26m21s
	copy from	78	4s309ms
	copy to	597	32m38s
	cte	3,879	1h32m23s
	ddl	13	13m16s
	delete	13	20ms
	insert	21,623	25s386ms
	others	3,895	1m47s
	select	92,304	5m28s
	tcl	641	180ms
	update	2,404	17s408ms

Duration by user

Key values

2h26m21s (postgres) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	125,447	2h26m21s
	copy from	78	4s309ms
	copy to	597	32m38s
	cte	3,879	1h32m23s
	ddl	13	13m16s
	delete	13	20ms
	insert	21,623	25s386ms
	others	3,895	1m47s
	select	92,304	5m28s
	tcl	641	180ms
	update	2,404	17s408ms

Queries by host

Key values

192.168.1.20 Main host
37,771 Requests
33m22s (127.0.0.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	20,061	33m22s
	copy to	597	32m38s
	cte	25	238ms
	insert	9,548	11s779ms
	others	634	24ms
	select	7,361	30s238ms
	tcl	5	0ms
	update	1,891	1s705ms
182.165.1.42	Total	148	8m7s
	cte	60	8m7s
	select	88	59ms
192.168.0.216	Total	368	272ms
	others	184	15ms
	select	176	172ms
	update	8	83ms
192.168.0.239	Total	514	3s763ms
	select	514	3s763ms
192.168.0.42	Total	1,043	3s948ms
	insert	166	26ms
	select	877	3s921ms
192.168.1.135	Total	290	619ms
	cte	8	278ms
	select	282	340ms
192.168.1.145	Total	25,097	30m24s
	cte	838	29m48s
	others	292	3ms
	select	23,967	36s532ms
192.168.1.20	Total	37,771	30m45s
	cte	832	29m50s
	others	358	4ms
	select	36,581	54s899ms
192.168.1.201	Total	1,974	7s165ms
	select	1,974	7s165ms
192.168.1.23	Total	10,768	51s987ms
	cte	6	9ms
	others	1,520	16ms
	select	9,242	51s961ms
192.168.1.231	Total	40	0ms
	others	40	0ms
192.168.1.250	Total	12,164	23m31s
	cte	2,017	23m18s
	others	512	5ms
	select	9,635	13s318ms
192.168.1.90	Total	60	43s409ms
	cte	6	43s363ms
	others	8	0ms
	select	46	45ms
192.168.2.126	Total	80	64ms
	others	18	0ms
	select	62	64ms
192.168.2.182	Total	48	245ms
	others	24	2ms
	select	12	10ms
	update	12	232ms
192.168.2.205	Total	138	109ms
	insert	90	11ms
	others	24	2ms
	select	20	18ms
	update	4	76ms
192.168.2.82	Total	768	1s817ms
	insert	410	1s107ms
	others	96	9ms
	select	161	96ms
	update	101	604ms
192.168.3.199	Total	240	219ms
	others	120	10ms
	select	108	98ms
	update	12	110ms
192.168.4.142	Total	12,402	13s158ms
	insert	11,361	12s392ms
	select	1,041	766ms
192.168.4.150	Total	22	1s322ms
	others	21	0ms
	select	1	1s322ms
192.168.4.196	Total	12	1ms
	others	8	0ms
	select	4	1ms
192.168.4.206	Total	12	0ms
	others	8	0ms
	select	4	0ms
192.168.4.229	Total	3	59ms
	cte	1	59ms
	others	2	0ms
192.168.4.238	Total	24	11s448ms
	cte	8	11s448ms
	others	16	0ms
192.168.4.33	Total	153	182ms
	insert	48	68ms
	select	95	96ms
	update	10	17ms
192.168.4.98	Total	960	19s583ms
	others	6	18s801ms
	select	6	30ms
	tcl	636	180ms
	update	312	569ms
[local]	Total	287	17m31s
	copy from	78	4s309ms
	cte	78	24s826ms
	ddl	13	13m16s
	delete	13	20ms
	others	4	1m28s
	select	47	2m3s
	update	54	14s9ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
88,370 Requests
1h26m1s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	88,370	1h26m1s
	cte	3,710	1h23m8s
	insert	166	26ms
	others	1,395	18ms
	select	83,099	2m53s
[unknown]	Total	28,560	10m7s
	cte	66	8m50s
	insert	21,457	25s359ms
	others	1,880	18s854ms
	select	2,180	28s881ms
	tcl	636	180ms
	update	2,341	3s381ms
pg_dump	Total	8,121	32m34s
	copy to	571	32m32s
	cte	5	14ms
	others	616	24ms
	select	6,924	2s583ms
	tcl	5	0ms
psql	Total	396	17m38s
	copy from	78	4s309ms
	copy to	26	6s148ms
	cte	98	25s50ms
	ddl	13	13m16s
	delete	13	20ms
	others	4	1m28s
	select	101	2m3s
	update	63	14s27ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-01-24 06:57:43 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

76,019 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	76,019	60.60%
1-5ms	40,084	31.95%
5-10ms	5,297	4.22%
10-25ms	1,537	1.23%
25-50ms	590	0.47%
50-100ms	419	0.33%
100-500ms	481	0.38%
500-1000ms	166	0.13%
1000-10000ms	627	0.50%
> 10000ms	227	0.18%

Slowest individual queries


[ Date: 2025-01-24 06:18:28 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-01-24 06:08:15 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-01-24 06:30:52 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-01-24 06:13:59 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-01-24 06:20:41 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-01-24 06:35:10 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-01-24 06:23:41 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-01-24 06:18:28 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2025-01-24 06:22:03 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-01-24 06:11:12 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-01-24 06:26:55 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-01-24 06:28:03 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-01-24 06:16:17 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-01-24 06:17:16 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-01-24 06:36:49 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-01-24 06:14:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-01-24 06:31:49 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-01-24 06:33:19 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2025-01-24 06:16:31 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.250 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
[ Date: 2025-01-24 06:24:51 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]

Rank	Duration	Query
1	13m16s	TRUNCATE TABLE solr_relevance_old; [ Date: 2025-01-24 06:18:28 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	3m12s	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-01-24 06:08:15 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
3	2m45s	COPY public.researchreports (researchreportid, type, createddatetime, language, filename, xml) TO stdout; [ Date: 2025-01-24 06:30:52 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
4	2m42s	COPY public.researchreports (researchreportid, type, createddatetime, language, filename, xml) TO stdout; [ Date: 2025-01-24 06:13:59 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
5	2m12s	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-01-24 06:20:41 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
6	1m50s	COPY public.t15_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2025-01-24 06:35:10 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
7	1m38s	COPY public.autochartist_results (resultid, bandwidth, pattern, gmttimefound, direction, initialtrend, breakout, volumeincrease, noise, symmetry, patternstarttime, patternendtime, patternstartprice, patternendprice, resx0, resx1, supportx0, supportx1, resy0, resy1, supporty0, supporty1, supportgradient, resgradient, riskreward, qtytp, predictionpricefrom, predictionpriceto, predictiontimefrom, predictiontimeto, patternquality, trendchange, maxmovementafterbreakout, latestbaratbreakouttime, latestbaratbreakoutprice, patternlengthbars, temporarypattern, symbolid, resultuid, relevancestartdistance, simulation, writtendatetime, old_resultuid) TO stdout; [ Date: 2025-01-24 06:23:41 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
8	1m27s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2025-01-24 06:18:28 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
9	1m12s	COPY public.authenticationlog (attemptid, username, password, brokerid, authclass, attemptdatetime, success, fingerprint, accounttype) TO stdout; [ Date: 2025-01-24 06:22:03 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
10	1m11s	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-01-24 06:11:12 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
11	1m10s	COPY public.powerstats_trumpet (symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) TO stdout; [ Date: 2025-01-24 06:26:55 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
12	1m8s	COPY public.powerstats_trumpet_test (symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) TO stdout; [ Date: 2025-01-24 06:28:03 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
13	1m1s	COPY public.t15_hve (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived, pricesadjusted, relevanceprocessed, recengprocessedadjusted) TO stdout; [ Date: 2025-01-24 06:16:17 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
14	58s824ms	COPY public.t15_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2025-01-24 06:17:16 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
15	58s642ms	COPY public.t30_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2025-01-24 06:36:49 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
16	57s42ms	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-01-24 06:14:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
17	52s117ms	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-01-24 06:31:49 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
18	49s177ms	COPY public.t15_hve (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived, pricesadjusted, relevanceprocessed, recengprocessedadjusted) TO stdout; [ Date: 2025-01-24 06:33:19 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
19	48s131ms	WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a., rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('0' = 0 OR s.timegranularity in ('0')) AND ('0' = 0 OR s.exchange in ('')) AND ('0' = 0 OR coalesce(bim.code, s.symbol) in ('')) AND ('0' = 0 OR p.patternname in ('')) AND ('0' = 0 OR kr.patternclassid in ('0')) AND ('0' = 0 OR kr.patternlengthbars <= '0') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('0' = 0 OR age <= '0') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200; [ Date: 2025-01-24 06:16:31 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.250 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20	47s160ms	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-01-24 06:24:51 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]

Time consuming queries


[ User: postgres - Total duration: 39m43s - Times executed: 251 ]
[ User: postgres - Total duration: 36m56s - Times executed: 250 ]
[ User: postgres - Total duration: 13m16s - Times executed: 13 ]
[ User: postgres - Total duration: 11m53s - Times executed: 250 ]
[ User: postgres - Total duration: 5m27s - Times executed: 2 ]
[ User: postgres - Total duration: 5m24s - Times executed: 2 ]
[ User: postgres - Total duration: 2m49s - Times executed: 2 ]
[ User: postgres - Total duration: 2m20s - Times executed: 2 ]
[ User: postgres - Total duration: 1m52s - Times executed: 2 ]
[ User: postgres - Total duration: 1m50s - Times executed: 2 ]
[ User: postgres - Total duration: 1m49s - Times executed: 2 ]
[ User: postgres - Total duration: 1m37s - Times executed: 2 ]
[ User: postgres - Total duration: 1m28s - Times executed: 4 ]
[ User: postgres - Total duration: 1m20s - Times executed: 4 ]
[ User: postgres - Total duration: 1m20s - Times executed: 2 ]
[ User: postgres - Total duration: 1m15s - Times executed: 182 ]
[ User: postgres - Total duration: 1m14s - Times executed: 2 ]
[ User: postgres - Total duration: 1m1s - Times executed: 105 ]
[ User: postgres - Total duration: 1m - Times executed: 18381 ]
[ User: postgres - Total duration: 52s287ms - Times executed: 2 ]

Most frequent queries (N)


[ User: postgres - Total duration: 153ms - Times executed: 34158 ]
[ User: postgres - Total duration: 32s23ms - Times executed: 21873 ]
[ User: postgres - Total duration: 1m - Times executed: 18381 ]
[ User: postgres - Total duration: 6s207ms - Times executed: 5778 ]
[ User: postgres - Total duration: 8s453ms - Times executed: 5302 ]
[ User: postgres - Total duration: 2s640ms - Times executed: 3174 ]
[ User: postgres - Total duration: 923ms - Times executed: 2224 ]
[ User: postgres - Total duration: 4s197ms - Times executed: 1913 ]
[ User: postgres - Total duration: 1s686ms - Times executed: 1882 ]
[ User: postgres - Total duration: 1s240ms - Times executed: 1810 ]
[ User: postgres - Total duration: 26ms - Times executed: 1620 ]
[ User: postgres - Total duration: 13ms - Times executed: 1420 ]
[ User: postgres - Total duration: 18ms - Times executed: 1394 ]
[ User: postgres - Total duration: 663ms - Times executed: 1283 ]
[ User: postgres - Total duration: 877ms - Times executed: 947 ]
[ User: postgres - Total duration: 104ms - Times executed: 912 ]
[ User: postgres - Total duration: 254ms - Times executed: 723 ]
[ User: postgres - Total duration: 22ms - Times executed: 701 ]
[ User: postgres - Total duration: 4s652ms - Times executed: 674 ]
[ User: postgres - Total duration: 85ms - Times executed: 637 ]

Normalized slowest queries (N)


[ User: postgres - Total duration: 5m27s - Times executed: 2 ]
[ User: postgres - Total duration: 5m24s - Times executed: 2 ]
[ User: postgres - Total duration: 2m49s - Times executed: 2 ]
[ User: postgres - Total duration: 2m20s - Times executed: 2 ]
[ User: postgres - Total duration: 13m16s - Times executed: 13 ]
[ User: postgres - Total duration: 1m52s - Times executed: 2 ]
[ User: postgres - Total duration: 1m50s - Times executed: 2 ]
[ User: postgres - Total duration: 1m49s - Times executed: 2 ]
[ User: postgres - Total duration: 1m37s - Times executed: 2 ]
[ User: postgres - Total duration: 1m20s - Times executed: 2 ]
[ User: postgres - Total duration: 1m14s - Times executed: 2 ]
[ User: postgres - Total duration: 52s287ms - Times executed: 2 ]
[ User: postgres - Total duration: 1m28s - Times executed: 4 ]
[ User: postgres - Total duration: 1m20s - Times executed: 4 ]
[ User: postgres - Total duration: 39m43s - Times executed: 251 ]
[ User: postgres - Total duration: 36m56s - Times executed: 250 ]
[ User: postgres - Total duration: 11m53s - Times executed: 250 ]
[ User: postgres - Total duration: 1m1s - Times executed: 105 ]
[ User: postgres - Total duration: 1m15s - Times executed: 182 ]
[ User: postgres - Total duration: 4s652ms - Times executed: 674 ]

Time consuming prepare


[ User: postgres - Total duration: 1h3m41s - Times executed: 1982 ]
[ User: postgres - Total duration: 12s356ms - Times executed: 3461 ]
[ User: postgres - Total duration: 664ms - Times executed: 485 ]
[ User: postgres - Total duration: 4s831ms - Times executed: 1615 ]
[ User: postgres - Total duration: 2s492ms - Times executed: 3056 ]
[ User: postgres - Total duration: 836ms - Times executed: 2110 ]
[ User: postgres - Total duration: 13ms - Times executed: 1420 ]
[ User: postgres - Total duration: 518ms - Times executed: 60 ]
[ User: postgres - Total duration: 13ms - Times executed: 2705 ]
[ User: postgres - Total duration: 997ms - Times executed: 60 ]
[ User: postgres - Total duration: 1s233ms - Times executed: 60 ]
[ User: postgres - Total duration: 1s73ms - Times executed: 30 ]
[ User: postgres - Total duration: 420ms - Times executed: 30 ]
[ User: postgres - Total duration: 361ms - Times executed: 30 ]
[ User: postgres - Total duration: 385ms - Times executed: 30 ]
[ User: postgres - Total duration: 416ms - Times executed: 30 ]
[ User: postgres - Total duration: 312ms - Times executed: 45 ]
[ User: postgres - Total duration: 1s240ms - Times executed: 60 ]
[ User: postgres - Total duration: 30s225ms - Times executed: 53 ]
[ User: postgres - Total duration: 867ms - Times executed: 60 ]

Time consuming bind


[ User: postgres - Total duration: 1h30m - Times executed: 3587 ]
[ User: postgres - Total duration: 1m43s - Times executed: 42935 ]
[ User: postgres - Total duration: 1s74ms - Times executed: 46 ]
[ User: postgres - Total duration: 664ms - Times executed: 485 ]
[ User: postgres - Total duration: 518ms - Times executed: 60 ]
[ User: postgres - Total duration: 1m1s - Times executed: 104 ]
[ User: postgres - Total duration: 143ms - Times executed: 34037 ]
[ User: postgres - Total duration: 997ms - Times executed: 60 ]
[ User: postgres - Total duration: 1s233ms - Times executed: 60 ]
[ User: postgres - Total duration: 1s240ms - Times executed: 60 ]
[ User: postgres - Total duration: 110ms - Times executed: 60 ]
[ User: postgres - Total duration: 434ms - Times executed: 30 ]
[ User: postgres - Total duration: 771ms - Times executed: 30 ]
[ User: postgres - Total duration: 867ms - Times executed: 60 ]
[ User: postgres - Total duration: 1s393ms - Times executed: 30 ]
[ User: postgres - Total duration: 532ms - Times executed: 30 ]
[ User: postgres - Total duration: 275ms - Times executed: 60 ]
[ User: postgres - Total duration: 312ms - Times executed: 45 ]
[ User: postgres - Total duration: 84ms - Times executed: 60 ]
[ User: postgres - Total duration: 620ms - Times executed: 30 ]

Log levels

Key values

390,062 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	392	0.10%
DETAIL	126,142	32.34%
ERROR	1	0.00%
LOG	262,995	67.42%
STATEMENT	532	0.14%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
4 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

4 Max number of times the same event was reported
4 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
Jan 24	06	4

LOG: process 16268 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 1000.042 ms
LOG: process 16268 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 50657.017 ms
LOG: process 18316 still waiting for AccessExclusiveLock on relation 5894441 of database 5881926 after 1000.059 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