pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Wed May 8 04:59:52 2024
Log file: /home/postgres/pg_data/data/pg_log/postgresql-2024-05-08_060000.log
Parsed 1,596,920 log entries in 51s
Log start from 2024-05-08 06:00:00 to 2024-05-08 06:59:50

Global Stats

1,048 Number of unique normalized queries
113,423 Number of queries
2h24m26s Total query duration
2024-05-08 06:00:00 First query
2024-05-08 06:59:50 Last query
3,399 queries/s at 2024-05-08 06:45:04 Query peak

2h24m26s Total query duration
6s289ms Prepare/parse total duration
1m54s Bind total duration
2h22m25s Execute total duration

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

37 Total number of automatic vacuums
54 Total number of automatic analyzes

391 Number temporary file
77.52 MiB Max size of temporary file
4.62 MiB Average size of temporary file

2,689 Total number of sessions
12 sessions at 2024-05-08 06:57:13 Session peak
2d21h13m41s Total duration of sessions
1m32s Average duration of sessions
42 Average queries per session
3s223ms Average queries duration per session
1m29s Average idle time per session

2,688 Total number of connections
25 connections/s at 2024-05-08 06:38:48 Connection peak
4 Total number of databases

SQL Traffic

Key values

3,399 queries/s Query Peak
2024-05-08 06:45:04 Date

SELECT Traffic

Key values

3,351 queries/s Query Peak
2024-05-08 06:45:04 Date

INSERT/UPDATE/DELETE Traffic

Key values

128 queries/s Query Peak
2024-05-08 06:06:33 Date

Queries duration

Key values

2h24m26s 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)
May 08	06	113,423	0ms	13m17s	75ms	4m18s	4m30s	16m5s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
May 08	06	86,814	579	25ms	1m10s	1m50s	2m42s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
May 08	06	17,780	2,168	13	78	2ms	636ms	1s154ms	3s84ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
May 08	06	18,271	92,158	5.04	16.40%

Day	Hour	Count	Average / Second
May 08	06	2,688	0.75/s

Day	Hour	Count	Average Duration	Average idle time
May 08	06	2,689	1m32s	1m29s

↑ Back to the top of the General Activity table

Established Connections

Key values

25 connections Connection Peak
2024-05-08 06:38:48 Date

Connections per database

Key values

acaweb_fx Main Database
2,688 connections Total

Chart
Table

Database	User	Count
acaweb_fx		2,683
	pg_dump	1
	postgres	2,336
	psql	346
acaweb_fx_integer		1
	pg_dump	1
postgres		3
	pg_dump	1
	psql	2
translations		1
	pg_dump	1

Connections per user

Key values

postgres Main User
2,688 connections Total

Chart
Table

User	Count
pg_dump	4
postgres	2,336
psql	348

Connections per host

Key values

192.168.4.142 Main host with 1218 connections
2,688 Total connections

Chart
Table

Host	Count
127.0.0.1	124
192.168.0.216	80
192.168.0.42	27
192.168.1.145	121
192.168.1.20	126
192.168.1.23	5
192.168.1.250	163
192.168.1.90	56
192.168.2.126	64
192.168.2.182	12
192.168.2.205	16
192.168.2.82	48
192.168.3.199	60
192.168.4.106	1
192.168.4.142	1,218
192.168.4.150	10
192.168.4.238	8
192.168.4.241	4
192.168.4.34	4
192.168.4.98	306
[local]	235

Simultaneous sessions

Key values

12 sessions Session Peak
2024-05-08 06:57:13 Date

Histogram of session times

Key values

2,250 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	2,250	83.67%
500ms-1s	122	4.54%
1s-30s	175	6.51%
30s-1m	12	0.45%
1m-10m	41	1.52%
10m-30m	71	2.64%
30m-1h	3	0.11%
1h-8h	14	0.52%
> 8h	1	0.04%

Sessions per database

Key values

acaweb_fx Main Database
2,689 sessions Total

Chart
Table

Database	User	Count	Total Duration
acaweb_fx	2,684	2d20h54m35s	1m32s
acaweb_fx_integer	1	19m5s	19m5s
postgres	3	220ms	73ms
translations	1	144ms	144ms

Sessions per user

Key values

postgres Main User
2,689 sessions Total

Chart
Table

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

Sessions per host

Key values

192.168.4.142 Main Host
2,689 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	124	1h7m41s	32s753ms
192.168.0.216	80	1s69ms	13ms
192.168.0.42	27	2h50m3s	6m17s
192.168.1.145	121	4h10m16s	2m4s
192.168.1.20	126	14h33m15s	6m55s
192.168.1.23	5	2h9m45s	25m57s
192.168.1.250	164	22h40m44s	8m17s
192.168.1.90	56	37s283ms	665ms
192.168.2.126	64	6s865ms	107ms
192.168.2.182	12	878ms	73ms
192.168.2.205	16	1h	3m45s
192.168.2.82	48	1s892ms	39ms
192.168.3.199	60	909ms	15ms
192.168.4.106	1	181ms	181ms
192.168.4.142	1,218	9m57s	490ms
192.168.4.150	10	20h13m4s	2h1m18s
192.168.4.238	8	1s982ms	247ms
192.168.4.241	4	57ms	14ms
192.168.4.34	4	57ms	14ms
192.168.4.98	306	21s905ms	71ms
[local]	235	17m38s	4s503ms

Sessions per application

Key values

[unknown] Main Host
2,689 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	470	2d18h37m12s	8m30s
[unknown]	1,867	1h46m9s	3s411ms
pg_dump	4	32m33s	8m8s
psql	348	17m46s	3s64ms

Checkpoints Buffers

Key values

9,999 buffers Checkpoint Peak
2024-05-08 06:10:21 Date
209.982 seconds Highest write time
0.013 seconds Sync time

Checkpoints Wal files

Key values

4 files Wal files usage Peak
2024-05-08 06:25:21 Date

Checkpoints distance

Key values

118.83 Mo Distance Peak
2024-05-08 06:10:21 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
May 08	06	45,705	2,299.98s	0.076s	2,300.252s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
May 08	06	0	0	23	2,281	0.004s	0s

Day	Hour	Count	Avg time (sec)
May 08	06	0	0s

Day	Hour	Mean distance	Mean estimate
May 08	06	32,282.17 kB	50,393.25 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

104.07 MiB Temp Files size Peak
2024-05-08 06:10:06 Date

Number of temporary files

Key values

30 per second Temp Files Peak
2024-05-08 06:02:10 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
May 08	06	391	1.77 GiB	4.62 MiB

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	75	314.59 MiB	3.02 MiB	8.40 MiB	4.19 MiB	with rar_max as ( ; WITH rar_max as ( ; Date: 2024-05-08 06:00:42 Duration: 0ms Database: acaweb_fx User: postgres Remote: 192.168.1.250 Application: PostgreSQL JDBC Driver
2	42	1.21 GiB	3.83 MiB	77.52 MiB	29.44 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: 2024-05-08 06:30:10 Duration: 8s223ms 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: 2024-05-08 06:00:09 Duration: 6s583ms 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: 2024-05-08 06:40:08 Duration: 6s112ms Database: acaweb_fx User: postgres Remote: 192.168.1.90 Application: [unknown]
3	13	33.85 MiB	1.76 MiB	2.76 MiB	2.60 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: 2024-05-08 06:33:17 Duration: 2s472ms 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: 2024-05-08 06:41:18 Duration: 2s71ms 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: 2024-05-08 06:26:16 Duration: 1s582ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
4	4	223.57 MiB	55.84 MiB	55.96 MiB	55.89 MiB	select updateageforrelevantresults (); select updateageforrelevantresults (); Date: 2024-05-08 06:32:32 Duration: 29s774ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateageforrelevantresults (); Date: 2024-05-08 06:47:31 Duration: 28s196ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateageforrelevantresults (); Date: 2024-05-08 06:17:30 Duration: 27s607ms Database: acaweb_fx User: postgres Remote: [local] Application: psql

Queries generating the largest temporary files

Rank	Size	Query
1	77.52 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: 2024-05-08 06:40:05 ]
2	74.77 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2024-05-08 06:00:07 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
3	73.52 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: 2024-05-08 06:30:09 ]
4	70.34 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: 2024-05-08 06:10:05 ]
5	63.55 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: 2024-05-08 06:50:03 ]
6	63.22 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: 2024-05-08 06:20:07 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
7	62.36 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: 2024-05-08 06:10:06 ]
8	55.96 MiB	select updateageforrelevantresults (); [ Date: 2024-05-08 06:17:20 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
9	55.91 MiB	select updateageforrelevantresults (); [ Date: 2024-05-08 06:47:21 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
10	55.85 MiB	select updateageforrelevantresults (); [ Date: 2024-05-08 06:32:22 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
11	55.84 MiB	select updateageforrelevantresults (); [ Date: 2024-05-08 06:02:05 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
12	55.78 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: 2024-05-08 06:30:07 ]
13	54.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: 2024-05-08 06:50:04 ]
14	43.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: 2024-05-08 06:40:06 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
15	42.05 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2024-05-08 06:20:04 ]
16	40.81 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2024-05-08 06:50:05 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.90 - Application: [unknown] ]
17	37.78 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: 2024-05-08 06:20:05 ]
18	37.39 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: 2024-05-08 06:40:06 ]
19	36.82 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: 2024-05-08 06:30:07 ]
20	33.33 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: 2024-05-08 06:00:06 ]

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)
54 analyzes Total

Chart
Table

Table	Number of analyzes
acaweb_fx.public.solr_relevance_old	13
acaweb_fx.pg_catalog.pg_attribute	6
acaweb_fx.pg_catalog.pg_type	4
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_index	2
acaweb_fx.public.autochartist_symbolupdates	2
acaweb_fx.public.relevance_bigmovement_results	2
acaweb_fx.public.latest_t15_candle_view	2
acaweb_fx.public.symbollatestupdatetime	1
acaweb_fx.pg_catalog.pg_depend	1
acaweb_fx.public.latest_candle_datetime_per_receng	1
Total	54

Vacuums per table

Key values

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

Chart
Table

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
acaweb_fx.public.solr_relevance_old	13	13	9,749	0	45	0	0	7,409	13	1,368,873
acaweb_fx.public.datafeeds_latestrun	3	0	373	0	7	0	0	57	8	46,797
acaweb_fx.public.relevance_keylevels_results	3	3	11,408	0	606	1	172	2,516	375	1,261,829
acaweb_fx.public.relevance_autochartist_results	3	3	10,799	0	324	2	732	1,730	215	599,518
acaweb_fx.public.relevance_fibonacci_results	3	3	3,832	0	127	2	147	546	78	191,399
acaweb_fx.pg_toast.pg_toast_2619	2	2	275	0	48	0	0	218	42	191,247
acaweb_fx.pg_catalog.pg_attribute	2	2	1,556	0	299	0	128	698	253	1,534,479
acaweb_fx.pg_catalog.pg_index	1	1	95	0	15	0	0	33	12	84,485
acaweb_fx.pg_catalog.pg_type	1	1	135	0	20	0	0	58	17	115,148
acaweb_fx.public.autochartist_symbolupdates	1	1	8,787	0	837	0	9,529	3,087	850	491,475
acaweb_fx.public.solr_imports	1	1	41	0	1	0	0	6	1	8,856
acaweb_fx.pg_catalog.pg_statistic	1	1	904	0	257	0	679	520	224	883,774
acaweb_fx.public.relevance_bigmovement_results	1	1	168	0	7	0	0	41	4	20,789
acaweb_fx.public.latest_t15_candle_view	1	1	65	0	1	0	0	6	1	9,013
acaweb_fx.pg_catalog.pg_class	1	1	382	0	40	0	39	135	41	189,894
Total	37	34	48,569	36,366	2,634	5	11,426	17,060	2,134	6,997,576

Tuples removed per table

Key values

public.solr_relevance_old (66827) Main table with removed tuples on database acaweb_fx
79384 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	66,827	67,886	0	0	2,364
acaweb_fx.public.relevance_keylevels_results	3	3	3,527	36,873	2,241	0	837
acaweb_fx.pg_catalog.pg_attribute	2	2	2,418	19,164	504	0	472
acaweb_fx.public.autochartist_symbolupdates	1	1	2,301	51,933	1,819	0	11,334
acaweb_fx.public.relevance_autochartist_results	3	3	2,159	23,718	1,242	0	1,140
acaweb_fx.pg_catalog.pg_statistic	1	1	648	4,341	0	0	1,194
acaweb_fx.public.relevance_fibonacci_results	3	3	404	4,222	257	0	306
acaweb_fx.pg_catalog.pg_class	1	1	302	1,990	0	0	150
acaweb_fx.pg_catalog.pg_type	1	1	195	1,298	0	0	37
acaweb_fx.public.datafeeds_latestrun	3	0	176	39	0	0	54
acaweb_fx.pg_toast.pg_toast_2619	2	2	168	345	3	0	102
acaweb_fx.public.relevance_bigmovement_results	1	1	100	802	0	0	19
acaweb_fx.public.latest_t15_candle_view	1	1	56	13	0	0	1
acaweb_fx.public.solr_imports	1	1	52	1	0	0	1
acaweb_fx.pg_catalog.pg_index	1	1	51	811	0	1	22
Total	37	34	79,384	213,436	6,066	1	18,033

Pages removed per table

Key values

pg_catalog.pg_index (1) Main table with removed pages on database acaweb_fx
1 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
acaweb_fx.pg_catalog.pg_index	1	1	51	1
acaweb_fx.pg_toast.pg_toast_2619	2	2	168	0
acaweb_fx.pg_catalog.pg_type	1	1	195	0
acaweb_fx.public.autochartist_symbolupdates	1	1	2301	0
acaweb_fx.public.datafeeds_latestrun	3	0	176	0
acaweb_fx.public.solr_imports	1	1	52	0
acaweb_fx.pg_catalog.pg_attribute	2	2	2418	0
acaweb_fx.pg_catalog.pg_statistic	1	1	648	0
acaweb_fx.public.relevance_bigmovement_results	1	1	100	0
acaweb_fx.public.latest_t15_candle_view	1	1	56	0
acaweb_fx.public.relevance_keylevels_results	3	3	3527	0
acaweb_fx.pg_catalog.pg_class	1	1	302	0
acaweb_fx.public.relevance_autochartist_results	3	3	2159	0
acaweb_fx.public.solr_relevance_old	13	13	66827	0
acaweb_fx.public.relevance_fibonacci_results	3	3	404	0
Total	37	34	79,384	1

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
May 08	06	37	54

↑ 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	14m44s	7m22s
	relation	2	14m44s	7m22s
	Total	2	14m44s	7m22s

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	1	13m17s	13m17s	13m17s	13m17s	truncate table solr_relevance_old; TRUNCATE TABLE solr_relevance_old; Date: 2024-05-08 06:18:28 Database: acaweb_fx User: postgres Remote: [local] Application: psql TRUNCATE TABLE solr_relevance_old; Date: 2024-05-08 06:46:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql TRUNCATE TABLE solr_relevance_old; Date: 2024-05-08 06:26: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: 2024-05-08 06:18:29 Database: acaweb_fx User: postgres Remote: [local] Application: psql refresh materialized view latest_candle_datetime_per_receng; Date: 2024-05-08 06:32:02 Database: acaweb_fx User: postgres Remote: [local] Application: psql refresh materialized view latest_candle_datetime_per_receng; Date: 2024-05-08 06:47:02 Database: acaweb_fx User: postgres Remote: [local] Application: psql

Rank

Count

Total time

Min time

Max time

Avg duration

Query

1

13m17s

truncate table solr_relevance_old;

TRUNCATE TABLE solr_relevance_old;

Date: 2024-05-08 06:18:28 Database: acaweb_fx User: postgres Remote: [local] Application: psql
TRUNCATE TABLE solr_relevance_old;

Date: 2024-05-08 06:46:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql
TRUNCATE TABLE solr_relevance_old;

Date: 2024-05-08 06:26: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: 2024-05-08 06:18:29 Database: acaweb_fx User: postgres Remote: [local] Application: psql
refresh materialized view latest_candle_datetime_per_receng;

Date: 2024-05-08 06:32:02 Database: acaweb_fx User: postgres Remote: [local] Application: psql
refresh materialized view latest_candle_datetime_per_receng;

Date: 2024-05-08 06:47:02 Database: acaweb_fx User: postgres Remote: [local] Application: psql

Queries that waited the most

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

Rank

Wait time

Query

1

13m17s

TRUNCATE TABLE solr_relevance_old;

[ Date: 2024-05-08 06:18:28 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

2

1m27s

refresh materialized view latest_candle_datetime_per_receng;

[ Date: 2024-05-08 06:18:28 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

Queries by type

Key values

86,814 Total read queries
24,597 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	86,814	76.54%
INSERT	17,780	15.68%
UPDATE	2,168	1.91%
DELETE	13	0.01%
COPY FROM	78	0.07%
COPY TO	579	0.51%
CTE	3,350	2.95%
DDL	13	0.01%
TCL	616	0.54%
CURSOR	0	0.00%
OTHERS	2,012	1.77%

Queries by database

Key values

acaweb_fx Main database
109,425 Requests
2h3m34s (acaweb_fx)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
acaweb_fx	Total	109,425	2h3m34s
	copy from	78	4s459ms
	copy to	303	13m23s
	cte	3,347	1h28m39s
	ddl	13	13m17s
	delete	13	19ms
	insert	17,780	28s536ms
	others	1,709	1m45s
	select	83,401	5m34s
	tcl	613	133ms
	update	2,168	20s439ms
acaweb_fx_integer	Total	3,584	18m51s
	copy to	276	18m50s
	cte	1	5ms
	others	285	15ms
	select	3,021	1s22ms
	tcl	1	0ms
postgres	Total	367	193ms
	cte	1	1ms
	others	9	0ms
	select	356	191ms
	tcl	1	0ms
translations	Total	47	137ms
	cte	1	1ms
	others	9	0ms
	select	36	135ms
	tcl	1	0ms

Queries by user

Key values

postgres Main user
113,423 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	113,423	2h22m25s
	copy from	78	4s459ms
	copy to	579	32m13s
	cte	3,350	1h28m39s
	ddl	13	13m17s
	delete	13	19ms
	insert	17,780	28s536ms
	others	2,012	1m45s
	select	86,814	5m35s
	tcl	616	133ms
	update	2,168	20s439ms

Duration by user

Key values

2h22m25s (postgres) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	113,423	2h22m25s
	copy from	78	4s459ms
	copy to	579	32m13s
	cte	3,350	1h28m39s
	ddl	13	13m17s
	delete	13	19ms
	insert	17,780	28s536ms
	others	2,012	1m45s
	select	86,814	5m35s
	tcl	616	133ms
	update	2,168	20s439ms

Queries by host

Key values

192.168.1.20 Main host
29,625 Requests
39m58s (192.168.1.250)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	18,480	33m
	copy to	579	32m13s
	cte	24	234ms
	insert	8,606	12s24ms
	others	610	19ms
	select	6,972	33s240ms
	tcl	4	0ms
	update	1,685	1s323ms
182.165.1.42	Total	268	7m3s
	cte	120	7m3s
	select	148	56ms
185.10.0.66	Total	1,620	3s267ms
	select	1,620	3s267ms
192.168.0.216	Total	320	256ms
	others	160	12ms
	select	152	135ms
	update	8	108ms
192.168.0.236	Total	52	19ms
	cte	6	2ms
	select	46	16ms
192.168.0.239	Total	427	2s159ms
	select	427	2s159ms
192.168.0.42	Total	3,994	20s962ms
	cte	6	7ms
	insert	78	23ms
	others	54	0ms
	select	3,855	20s931ms
	update	1	0ms
192.168.1.135	Total	154	327ms
	cte	7	155ms
	select	147	171ms
192.168.1.145	Total	25,612	21m6s
	cte	640	20m25s
	others	242	2ms
	select	24,730	41s504ms
192.168.1.20	Total	29,625	21m13s
	cte	647	20m23s
	others	252	2ms
	select	28,726	50s349ms
192.168.1.201	Total	1,572	4s388ms
	select	1,572	4s388ms
192.168.1.23	Total	10,167	38s893ms
	cte	6	21ms
	others	10	0ms
	select	10,151	38s872ms
192.168.1.250	Total	9,037	39m58s
	cte	1,791	39m51s
	others	326	3ms
	select	6,920	6s294ms
192.168.1.90	Total	64	35s327ms
	cte	6	35s264ms
	others	8	0ms
	select	50	62ms
192.168.1.97	Total	72	44ms
	cte	10	5ms
	select	62	39ms
192.168.2.126	Total	81	74ms
	others	17	0ms
	select	64	74ms
192.168.2.182	Total	48	300ms
	others	24	2ms
	select	12	10ms
	update	12	287ms
192.168.2.205	Total	146	129ms
	insert	88	18ms
	others	28	2ms
	select	26	39ms
	update	4	68ms
192.168.2.82	Total	945	3s233ms
	insert	605	2s476ms
	others	96	9ms
	select	152	93ms
	update	92	655ms
192.168.3.199	Total	240	223ms
	others	120	8ms
	select	108	91ms
	update	12	123ms
192.168.4.106	Total	3	50ms
	cte	1	50ms
	others	2	0ms
192.168.4.142	Total	9,215	14s624ms
	insert	8,403	13s994ms
	select	812	630ms
192.168.4.150	Total	22	1s103ms
	others	21	0ms
	select	1	1s103ms
192.168.4.238	Total	24	1s62ms
	cte	8	1s62ms
	others	16	0ms
192.168.4.241	Total	12	21ms
	others	8	0ms
	select	4	21ms
192.168.4.34	Total	12	20ms
	others	8	0ms
	select	4	20ms
192.168.4.98	Total	924	18s357ms
	others	6	17s650ms
	select	6	34ms
	tcl	612	133ms
	update	300	539ms
[local]	Total	287	17m38s
	copy from	78	4s459ms
	cte	78	18s397ms
	ddl	13	13m17s
	delete	13	19ms
	others	4	1m28s
	select	47	2m11s
	update	54	17s332ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
81,840 Requests
1h23m30s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	81,840	1h23m30s
	cte	3,106	1h20m41s
	insert	78	23ms
	others	477	5ms
	select	78,178	2m49s
	update	1	0ms
[unknown]	Total	23,490	9m
	cte	142	7m38s
	insert	17,702	28s513ms
	others	942	17s690ms
	select	1,992	32s221ms
	tcl	612	133ms
	update	2,100	3s84ms
pg_dump	Total	7,693	32m8s
	copy to	553	32m6s
	cte	4	17ms
	others	589	19ms
	select	6,543	2s93ms
	tcl	4	0ms
psql	Total	400	17m45s
	copy from	78	4s459ms
	copy to	26	7s217ms
	cte	98	18s614ms
	ddl	13	13m17s
	delete	13	19ms
	others	4	1m28s
	select	101	2m11s
	update	67	17s354ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2024-05-08 06:17:44 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

64,937 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	64,937	57.25%
1-5ms	40,045	35.31%
5-10ms	3,971	3.50%
10-25ms	1,693	1.49%
25-50ms	568	0.50%
50-100ms	379	0.33%
100-500ms	626	0.55%
500-1000ms	211	0.19%
1000-10000ms	790	0.70%
> 10000ms	203	0.18%

Slowest individual queries


[ Date: 2024-05-08 06:18:28 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2024-05-08 06:07:50 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-05-08 06:30:47 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-05-08 06:13:28 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-05-08 06:20:40 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-05-08 06:34:59 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-05-08 06:23:42 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-05-08 06:18:29 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2024-05-08 06:22:03 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-05-08 06:28:01 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-05-08 06:26:51 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-05-08 06:10:44 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-05-08 06:14:36 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-05-08 06:16:47 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-05-08 06:36:34 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-05-08 06:15:42 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-05-08 06:33:07 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-05-08 06:31:38 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-05-08 06:24:51 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-05-08 06:25:39 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]

Rank	Duration	Query
1	13m17s	TRUNCATE TABLE solr_relevance_old; [ Date: 2024-05-08 06:18:28 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	2m48s	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: 2024-05-08 06:07:50 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
3	2m41s	COPY public.researchreports (researchreportid, type, createddatetime, language, filename, xml) TO stdout; [ Date: 2024-05-08 06:30:47 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
4	2m40s	COPY public.researchreports (researchreportid, type, createddatetime, language, filename, xml) TO stdout; [ Date: 2024-05-08 06:13:28 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
5	2m10s	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: 2024-05-08 06:20:40 - 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: 2024-05-08 06:34:59 - 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: 2024-05-08 06:23:42 - 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: 2024-05-08 06:18:29 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
9	1m16s	COPY public.authenticationlog (attemptid, username, password, brokerid, authclass, attemptdatetime, success, fingerprint, accounttype) TO stdout; [ Date: 2024-05-08 06:22:03 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
10	1m9s	COPY public.powerstats_trumpet_test (symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) TO stdout; [ Date: 2024-05-08 06:28:01 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
11	1m8s	COPY public.powerstats_trumpet (symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) TO stdout; [ Date: 2024-05-08 06:26:51 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
12	1m7s	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: 2024-05-08 06:10:44 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
13	1m6s	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: 2024-05-08 06:14:36 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
14	1m5s	COPY public.t15_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2024-05-08 06:16:47 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
15	58s874ms	COPY public.t30_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2024-05-08 06:36:34 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
16	51s394ms	COPY public.t15_hve (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived, pricesadjusted, relevanceprocessed, recengprocessedadjusted) TO stdout; [ Date: 2024-05-08 06:15:42 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
17	49s132ms	COPY public.t15_hve (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived, pricesadjusted, relevanceprocessed, recengprocessedadjusted) TO stdout; [ Date: 2024-05-08 06:33:07 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
18	48s170ms	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: 2024-05-08 06:31:38 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
19	46s869ms	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: 2024-05-08 06:24:51 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
20	39s408ms	COPY public.patternresultsrelevance (resultuid, type, relevant, reason, notrelevantpricedatetime, uniqueindex, saxo_relevant, datetimerelevantupdated) TO stdout; [ Date: 2024-05-08 06:25:39 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]

Time consuming queries


[ User: postgres - Total duration: 36m52s - Times executed: 316 ]
[ User: postgres - Total duration: 35m11s - Times executed: 315 ]
[ User: postgres - Total duration: 13m17s - Times executed: 13 ]
[ User: postgres - Total duration: 12m22s - Times executed: 315 ]
[ User: postgres - Total duration: 5m21s - Times executed: 2 ]
[ User: postgres - Total duration: 4m58s - Times executed: 2 ]
[ User: postgres - Total duration: 2m55s - Times executed: 2 ]
[ User: postgres - Total duration: 2m17s - Times executed: 2 ]
[ User: postgres - Total duration: 1m58s - Times executed: 263 ]
[ User: postgres - Total duration: 1m54s - Times executed: 2 ]
[ User: postgres - Total duration: 1m54s - Times executed: 2 ]
[ User: postgres - Total duration: 1m40s - Times executed: 2 ]
[ User: postgres - Total duration: 1m39s - Times executed: 2 ]
[ User: postgres - Total duration: 1m36s - Times executed: 4 ]
[ User: postgres - Total duration: 1m28s - Times executed: 2 ]
[ User: postgres - Total duration: 1m28s - Times executed: 4 ]
[ User: postgres - Total duration: 1m16s - Times executed: 2 ]
[ User: postgres - Total duration: 1m3s - Times executed: 135 ]
[ User: postgres - Total duration: 59s578ms - Times executed: 16589 ]
[ User: postgres - Total duration: 50s243ms - Times executed: 2 ]

Most frequent queries (N)


[ User: postgres - Total duration: 164ms - Times executed: 32365 ]
[ User: postgres - Total duration: 30s212ms - Times executed: 18840 ]
[ User: postgres - Total duration: 59s578ms - Times executed: 16589 ]
[ User: postgres - Total duration: 6s224ms - Times executed: 4872 ]
[ User: postgres - Total duration: 8s874ms - Times executed: 4682 ]
[ User: postgres - Total duration: 3s231ms - Times executed: 2359 ]
[ User: postgres - Total duration: 1s321ms - Times executed: 2044 ]
[ User: postgres - Total duration: 1s301ms - Times executed: 1672 ]
[ User: postgres - Total duration: 4s258ms - Times executed: 1600 ]
[ User: postgres - Total duration: 23ms - Times executed: 1540 ]
[ User: postgres - Total duration: 1s850ms - Times executed: 1325 ]
[ User: postgres - Total duration: 26s601ms - Times executed: 950 ]
[ User: postgres - Total duration: 96ms - Times executed: 859 ]
[ User: postgres - Total duration: 568ms - Times executed: 811 ]
[ User: postgres - Total duration: 3s709ms - Times executed: 791 ]
[ User: postgres - Total duration: 200ms - Times executed: 684 ]
[ User: postgres - Total duration: 21ms - Times executed: 681 ]
[ User: postgres - Total duration: 1s592ms - Times executed: 597 ]
[ User: postgres - Total duration: 78ms - Times executed: 594 ]
[ User: postgres - Total duration: 51ms - Times executed: 560 ]

Normalized slowest queries (N)


[ User: postgres - Total duration: 5m21s - Times executed: 2 ]
[ User: postgres - Total duration: 4m58s - Times executed: 2 ]
[ User: postgres - Total duration: 2m55s - Times executed: 2 ]
[ User: postgres - Total duration: 2m17s - Times executed: 2 ]
[ User: postgres - Total duration: 13m17s - Times executed: 13 ]
[ User: postgres - Total duration: 1m54s - Times executed: 2 ]
[ User: postgres - Total duration: 1m54s - Times executed: 2 ]
[ User: postgres - Total duration: 1m40s - Times executed: 2 ]
[ User: postgres - Total duration: 1m39s - Times executed: 2 ]
[ User: postgres - Total duration: 1m28s - Times executed: 2 ]
[ User: postgres - Total duration: 1m16s - Times executed: 2 ]
[ User: postgres - Total duration: 50s243ms - Times executed: 2 ]
[ User: postgres - Total duration: 1m36s - Times executed: 4 ]
[ User: postgres - Total duration: 1m28s - Times executed: 4 ]
[ User: postgres - Total duration: 36m52s - Times executed: 316 ]
[ User: postgres - Total duration: 35m11s - Times executed: 315 ]
[ User: postgres - Total duration: 12m22s - Times executed: 315 ]
[ User: postgres - Total duration: 1m3s - Times executed: 135 ]
[ User: postgres - Total duration: 1m58s - Times executed: 263 ]
[ User: postgres - Total duration: 26s601ms - Times executed: 950 ]

Time consuming prepare


[ User: postgres - Total duration: 1h18m13s - Times executed: 1935 ]
[ User: postgres - Total duration: 10s192ms - Times executed: 3077 ]
[ User: postgres - Total duration: 5s471ms - Times executed: 1854 ]
[ User: postgres - Total duration: 564ms - Times executed: 405 ]
[ User: postgres - Total duration: 3s54ms - Times executed: 2229 ]
[ User: postgres - Total duration: 1s812ms - Times executed: 1217 ]
[ User: postgres - Total duration: 6ms - Times executed: 1364 ]
[ User: postgres - Total duration: 28s50ms - Times executed: 56 ]
[ User: postgres - Total duration: 4ms - Times executed: 501 ]
[ User: postgres - Total duration: 32ms - Times executed: 18 ]
[ User: postgres - Total duration: 1s62ms - Times executed: 8 ]
[ User: postgres - Total duration: 281ms - Times executed: 18 ]
[ User: postgres - Total duration: 67ms - Times executed: 52 ]
[ User: postgres - Total duration: 71ms - Times executed: 60 ]
[ User: postgres - Total duration: 120ms - Times executed: 60 ]
[ User: postgres - Total duration: 93ms - Times executed: 60 ]
[ User: postgres - Total duration: 94ms - Times executed: 60 ]
[ User: postgres - Total duration: 63ms - Times executed: 60 ]
[ User: postgres - Total duration: 3ms - Times executed: 7 ]
[ User: postgres - Total duration: 82ms - Times executed: 60 ]

Time consuming bind


[ User: postgres - Total duration: 1h26m25s - Times executed: 3051 ]
[ User: postgres - Total duration: 1m36s - Times executed: 37345 ]
[ User: postgres - Total duration: 1m3s - Times executed: 134 ]
[ User: postgres - Total duration: 11ms - Times executed: 30 ]
[ User: postgres - Total duration: 18ms - Times executed: 30 ]
[ User: postgres - Total duration: 17ms - Times executed: 30 ]
[ User: postgres - Total duration: 564ms - Times executed: 405 ]
[ User: postgres - Total duration: 556ms - Times executed: 46 ]
[ User: postgres - Total duration: 2ms - Times executed: 30 ]
[ User: postgres - Total duration: 1ms - Times executed: 30 ]
[ User: postgres - Total duration: 155ms - Times executed: 32249 ]
[ User: postgres - Total duration: 19ms - Times executed: 30 ]
[ User: postgres - Total duration: 5ms - Times executed: 30 ]
[ User: postgres - Total duration: 205ms - Times executed: 30 ]
[ User: postgres - Total duration: 33ms - Times executed: 30 ]
[ User: postgres - Total duration: 10ms - Times executed: 30 ]
[ User: postgres - Total duration: 38ms - Times executed: 30 ]
[ User: postgres - Total duration: 100ms - Times executed: 30 ]
[ User: postgres - Total duration: 13ms - Times executed: 30 ]
[ User: postgres - Total duration: 4s740ms - Times executed: 66 ]

Log levels

Key values

342,446 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	184	0.05%
DETAIL	109,495	31.97%
ERROR	4	0.00%
LOG	232,450	67.88%
STATEMENT	313	0.09%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
7 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

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

LOG: process 29869 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 1000.050 ms
LOG: process 29869 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 51555.761 ms
LOG: process 31622 still waiting for AccessExclusiveLock on relation 5894441 of database 5881926 after 1000.062 ms

2

3

Details

ERROR: relation "..." does not exist

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
May 08	06	3

ERROR: relation "t0" does not exist at character 83

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

Queries generating the most temporary files (N)

Queries generating the largest temporary files

Vacuums

Vacuums / Analyzes Distribution

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Autovacuum Activity

Locks

Locks by types

Key values

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values

Queries by user

Key values

Duration by user

Key values