pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Thu Jan 4 05:00:00 2024
Log file: /home/postgres/pg_data/data/pg_log/postgresql-2024-01-04_060000.log
Parsed 1,948,978 log entries in 59s
Log start from 2024-01-04 06:00:00 to 2024-01-04 06:59:58

Global Stats

930 Number of unique normalized queries
131,010 Number of queries
2h24m23s Total query duration
2024-01-04 06:00:00 First query
2024-01-04 06:59:58 Last query
3,068 queries/s at 2024-01-04 06:05:02 Query peak

2h24m23s Total query duration
1m49s Prepare/parse total duration
1m48s Bind total duration
2h20m45s Execute total duration

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

41 Total number of automatic vacuums
55 Total number of automatic analyzes

537 Number temporary file
66.35 MiB Max size of temporary file
2.81 MiB Average size of temporary file

4,117 Total number of sessions
13 sessions at 2024-01-04 06:56:13 Session peak
2d2h25m4s Total duration of sessions
44s86ms Average duration of sessions
31 Average queries per session
2s104ms Average queries duration per session
41s982ms Average idle time per session

4,127 Total number of connections
45 connections/s at 2024-01-04 06:28:48 Connection peak
4 Total number of databases

SQL Traffic

Key values

3,068 queries/s Query Peak
2024-01-04 06:05:02 Date

SELECT Traffic

Key values

3,042 queries/s Query Peak
2024-01-04 06:45:05 Date

INSERT/UPDATE/DELETE Traffic

Key values

146 queries/s Query Peak
2024-01-04 06:02:49 Date

Queries duration

Key values

2h24m23s 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 04	06	131,010	0ms	13m46s	64ms	4m25s	5m31s	28m57s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 04	06	94,547	579	30ms	1m18s	2m4s	2m48s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 04	06	24,472	1,855	13	78	1ms	744ms	1s243ms	2s253ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Jan 04	06	27,162	109,105	4.02	21.41%

Day	Hour	Count	Average / Second
Jan 04	06	4,127	1.15/s

Day	Hour	Count	Average Duration	Average idle time
Jan 04	06	4,117	44s86ms	42s35ms

↑ Back to the top of the General Activity table

Established Connections

Key values

45 connections Connection Peak
2024-01-04 06:28:48 Date

Connections per database

Key values

acaweb_fx Main Database
4,127 connections Total

Chart
Table

Database	User	Count
acaweb_fx		4,122
	pg_dump	1
	postgres	3,775
	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
4,127 connections Total

Chart
Table

User	Count
pg_dump	4
postgres	3,775
psql	348

Connections per host

Key values

192.168.4.142 Main host with 1591 connections
4,127 Total connections

Chart
Table

Host	Count
127.0.0.1	122
172.10.1.90	12
192.168.0.216	123
192.168.0.42	107
192.168.1.145	106
192.168.1.20	117
192.168.1.23	806
192.168.1.231	20
192.168.1.239	42
192.168.1.25	60
192.168.1.250	253
192.168.2.126	70
192.168.2.182	12
192.168.2.205	14
192.168.2.82	48
192.168.3.199	60
192.168.4.142	1,591
192.168.4.150	10
192.168.4.238	12
192.168.4.95	1
192.168.4.98	306
[local]	235

Simultaneous sessions

Key values

13 sessions Session Peak
2024-01-04 06:56:13 Date

Histogram of session times

Key values

3,512 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	3,512	85.30%
500ms-1s	183	4.44%
1s-30s	250	6.07%
30s-1m	9	0.22%
1m-10m	63	1.53%
10m-30m	92	2.23%
30m-1h	6	0.15%
1h-8h	2	0.05%
> 8h	0	0.00%

Sessions per database

Key values

acaweb_fx Main Database
4,117 sessions Total

Chart
Table

Database	User	Count	Total Duration
acaweb_fx	4,112	2d2h5m58s	43s861ms
acaweb_fx_integer	1	19m6s	19m6s
postgres	3	182ms	60ms
translations	1	126ms	126ms

Sessions per user

Key values

postgres Main User
4,117 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
4,117 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	122	59m49s	29s421ms
172.10.1.90	12	7s295ms	607ms
192.168.0.216	123	1m31s	745ms
192.168.0.42	107	2h23m55s	1m20s
192.168.1.145	106	4h4m21s	2m18s
192.168.1.20	117	14h58m3s	7m40s
192.168.1.23	806	1h32m6s	6s857ms
192.168.1.231	20	9h52m54s	29m38s
192.168.1.239	42	221ms	5ms
192.168.1.25	60	33s8ms	550ms
192.168.1.250	253	14h59m40s	3m33s
192.168.2.126	70	6s189ms	88ms
192.168.2.182	12	685ms	57ms
192.168.2.205	14	1h	4m17s
192.168.2.82	48	1s844ms	38ms
192.168.3.199	60	880ms	14ms
192.168.4.142	1,591	12m27s	470ms
192.168.4.238	12	2s281ms	190ms
192.168.4.95	1	167ms	167ms
192.168.4.98	306	22s22ms	71ms
[local]	235	18m57s	4s840ms

Sessions per application

Key values

[unknown] Main Host
4,117 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	1,422	1d23h51m5s	2m1s
[unknown]	2,343	1h41m52s	2s608ms
pg_dump	4	33m3s	8m15s
psql	348	19m3s	3s285ms

Checkpoints Buffers

Key values

8,479 buffers Checkpoint Peak
2024-01-04 06:06:37 Date
209.995 seconds Highest write time
0.010 seconds Sync time

Checkpoints Wal files

Key values

4 files Wal files usage Peak
2024-01-04 06:06:37 Date

Checkpoints distance

Key values

128.75 Mo Distance Peak
2024-01-04 06:06:37 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jan 04	06	42,716	2,067.667s	0.046s	2,067.89s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Jan 04	06	0	0	29	2,042	0.007s	0s

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

Day	Hour	Mean distance	Mean estimate
Jan 04	06	39,911.42 kB	55,748.58 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

98.05 MiB Temp Files size Peak
2024-01-04 06:40:06 Date

Number of temporary files

Key values

62 per second Temp Files Peak
2024-01-04 06:17:24 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jan 04	06	537	1.48 GiB	2.81 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	41	1.08 GiB	3.83 MiB	62.46 MiB	26.93 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-01-04 06:30:09 Duration: 6s720ms Database: acaweb_fx User: postgres Remote: 192.168.1.25 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-01-04 06:20:08 Duration: 5s856ms Database: acaweb_fx User: postgres Remote: 192.168.1.25 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-01-04 06:40:07 Duration: 5s551ms Database: acaweb_fx User: postgres Remote: 192.168.1.25 Application: [unknown]
2	27	126.81 MiB	3.86 MiB	7.08 MiB	4.70 MiB	with rar_max as ( ; WITH rar_max as ( ; Date: 2024-01-04 06:02:34 Duration: 0ms Database: acaweb_fx User: postgres Remote: 192.168.1.250 Application: PostgreSQL JDBC Driver
3	4	265.10 MiB	66.21 MiB	66.35 MiB	66.27 MiB	select updateageforrelevantresults (); select updateageforrelevantresults (); Date: 2024-01-04 06:17:28 Duration: 25s930ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateageforrelevantresults (); Date: 2024-01-04 06:47:27 Duration: 25s741ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateageforrelevantresults (); Date: 2024-01-04 06:32:28 Duration: 25s730ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
4	1	7.07 MiB	7.07 MiB	7.07 MiB	7.07 MiB	jr.resultuid as resultuid, jr.direction as direction, jr.patternendtime as identified, jr.patternlengthbars as length, jr.patternstarttime as patternstarttime, case when jr.trendchangeid = ? then ? else ? end as trendchange, 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, jp.patternname as pattern_name, dtt.timezone as timezone, ? as age, cps.pip, g.basegroupname from japsticks_results jr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = jr.symbolid inner join relevance_japsticks_results rar on rar.resultuid = jr.resultuid inner join symbols s on jr.symbolid = s.symbolid and s.nonliquid = ? inner join japsticks_patterns jp on jr.patternid = jp.id inner join downloadersymbolsettings dss on jr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? 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 left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where jr.gmttimefound > now() - interval ? and s.deleted = ? and (jr.simulation = ? or jr.simulation is null) and (rar.relevant = ?) --and (semicolon_age = ? or rar.age <= semicolon_age) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or jp.patternname in (...)) and (? = ? or jr.patternlengthbars <= ?) ), results as ( select distinct on (symbolid) * from all_results order by symbolid, resultuid ) select * from results order by identified desc, length desc ; jr.resultuid AS resultuid, jr.direction AS direction, jr.patternendtime AS identified, jr.patternlengthbars AS length, jr.patternstarttime AS patternstarttime, case when jr.trendchangeid = 1 then 'Continuation' else 'Reversal' end AS trendchange, 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, jp.patternname AS pattern_name, dtt.timezone AS timezone, 0 AS age, cps.pip, g.basegroupname FROM japsticks_results jr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = jr.symbolid INNER JOIN relevance_japsticks_results rar ON rar.resultuid = jr.resultuid INNER JOIN symbols s ON jr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN japsticks_patterns jp ON jr.patternid = jp.id INNER JOIN downloadersymbolsettings dss ON jr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 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 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 jr.gmttimefound > now() - INTERVAL '7 DAYS' AND s.deleted = 0 AND (jr.simulation = 0 OR jr.simulation IS NULL) AND (rar.relevant = 1) --AND (semicolon_age = 0 OR rar.age <= semicolon_age) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR coalesce(bim.code, s.symbol) in ($7)) AND ($8 = 0 OR jp.patternname in ($9)) AND ($10 = 0 OR jr.patternlengthbars <= $11)), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; Date: 2024-01-04 06:26:37 Duration: 0ms Database: acaweb_fx User: postgres Remote: 192.168.1.250 Application: PostgreSQL JDBC Driver

Queries generating the largest temporary files

Rank	Size	Query
1	66.35 MiB	select updateageforrelevantresults (); [ Date: 2024-01-04 06:17:18 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	66.30 MiB	select updateageforrelevantresults (); [ Date: 2024-01-04 06:47:18 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
3	66.23 MiB	select updateageforrelevantresults (); [ Date: 2024-01-04 06:32:19 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
4	66.21 MiB	select updateageforrelevantresults (); [ Date: 2024-01-04 06:02:06 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
5	62.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: 2024-01-04 06:50:04 ]
6	61.32 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-01-04 06:40:06 ]
7	60.26 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-01-04 06:30:07 ]
8	54.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: 2024-01-04 06:20:05 ]
9	50.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: 2024-01-04 06:20:06 ]
10	48.53 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2024-01-04 06:00:04 ]
11	48.09 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-01-04 06:10:05 ]
12	45.53 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2024-01-04 06:30:07 ]
13	45.10 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-01-04 06:30:07 ]
14	43.84 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2024-01-04 06:50:04 ]
15	42.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: 2024-01-04 06:00:04 ]
16	41.47 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2024-01-04 06:10:05 ]
17	40.93 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-01-04 06:00:04 ]
18	37.09 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-01-04 06:40:06 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.25 - Application: [unknown] ]
19	36.24 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2024-01-04 06:50:04 ]
20	35.83 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-01-04 06:40: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)
55 analyzes Total

Chart
Table

Table	Number of analyzes
acaweb_fx.public.solr_relevance_old	13
acaweb_fx.pg_catalog.pg_attribute	7
acaweb_fx.public.datafeeds_latestrun	4
acaweb_fx.public.relevance_keylevels_results	4
acaweb_fx.pg_catalog.pg_class	4
acaweb_fx.public.relevance_fibonacci_results	4
acaweb_fx.pg_catalog.pg_type	4
acaweb_fx.public.relevance_autochartist_results	4
acaweb_fx.public.latest_t15_candle_view	3
acaweb_fx.public.latest_candle_datetime_per_receng	2
acaweb_fx.pg_catalog.pg_index	1
acaweb_fx.public.autochartist_symbolupdates	1
acaweb_fx.public.solr_imports	1
acaweb_fx.pg_catalog.pg_depend	1
acaweb_fx.public.symbollatestupdatetime	1
acaweb_fx.public.relevance_bigmovement_results	1
Total	55

Vacuums per table

Key values

public.solr_relevance_old (13) Main table vacuumed on database acaweb_fx
41 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	12,737	0	42	0	0	9,273	13	1,679,757
acaweb_fx.public.datafeeds_latestrun	5	0	540	0	15	0	0	70	12	66,109
acaweb_fx.public.relevance_keylevels_results	4	4	16,022	0	793	2	300	2,880	955	3,270,159
acaweb_fx.public.relevance_autochartist_results	3	2	11,504	0	298	4	690	1,331	644	2,254,415
acaweb_fx.public.relevance_fibonacci_results	3	3	3,865	0	101	2	117	630	190	886,255
acaweb_fx.pg_toast.pg_toast_2619	2	2	264	0	60	0	0	197	53	209,475
acaweb_fx.pg_catalog.pg_attribute	2	2	1,573	0	330	0	128	729	277	1,679,146
acaweb_fx.public.latest_t15_candle_view	2	2	158	0	8	0	0	13	2	15,073
acaweb_fx.pg_catalog.pg_class	2	2	748	0	75	0	78	234	73	328,756
acaweb_fx.pg_catalog.pg_type	1	1	128	0	22	0	0	52	17	108,404
acaweb_fx.public.autochartist_symbolupdates	1	1	8,981	0	2,110	0	8,922	4,371	2,259	1,426,483
acaweb_fx.pg_catalog.pg_statistic	1	1	831	0	195	0	677	510	181	754,147
acaweb_fx.public.symbollatestupdatetime	1	0	1,564	0	415	0	412	1,268	474	1,025,760
acaweb_fx.pg_catalog.pg_depend	1	1	348	0	109	0	58	200	91	495,664
Total	41	34	59,263	39,465	4,573	8	11,382	21,758	5,241	14,199,603

Tuples removed per table

Key values

public.solr_relevance_old (63171) Main table with removed tuples on database acaweb_fx
96879 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	63,171	89,120	0	0	3,200
acaweb_fx.public.symbollatestupdatetime	1	0	17,535	75,907	0	0	1,714
acaweb_fx.public.autochartist_symbolupdates	1	1	4,451	50,801	1	0	11,334
acaweb_fx.public.relevance_keylevels_results	4	4	3,658	58,905	5,033	0	1,192
acaweb_fx.pg_catalog.pg_attribute	2	2	2,699	18,476	0	0	484
acaweb_fx.public.relevance_autochartist_results	3	2	2,150	31,726	2,762	0	1,140
acaweb_fx.pg_catalog.pg_statistic	1	1	780	4,311	0	0	1,194
acaweb_fx.public.relevance_fibonacci_results	3	3	687	5,452	425	0	306
acaweb_fx.pg_catalog.pg_depend	1	1	592	11,554	0	0	112
acaweb_fx.pg_catalog.pg_class	2	2	497	4,091	135	0	300
acaweb_fx.public.datafeeds_latestrun	5	0	231	202	102	0	90
acaweb_fx.pg_catalog.pg_type	1	1	187	1,288	0	0	36
acaweb_fx.pg_toast.pg_toast_2619	2	2	151	352	24	0	100
acaweb_fx.public.latest_t15_candle_view	2	2	90	57	19	0	2
Total	41	34	96,879	352,242	8,501	0	21,204

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	151
acaweb_fx.pg_catalog.pg_type	1	1	187
acaweb_fx.public.datafeeds_latestrun	5	0	231
acaweb_fx.public.autochartist_symbolupdates	1	1	4451
acaweb_fx.pg_catalog.pg_statistic	1	1	780
acaweb_fx.pg_catalog.pg_attribute	2	2	2699
acaweb_fx.public.symbollatestupdatetime	1	0	17535
acaweb_fx.public.latest_t15_candle_view	2	2	90
acaweb_fx.pg_catalog.pg_depend	1	1	592
acaweb_fx.public.relevance_keylevels_results	4	4	3658
acaweb_fx.public.solr_relevance_old	13	13	63171
acaweb_fx.pg_catalog.pg_class	2	2	497
acaweb_fx.public.relevance_autochartist_results	3	2	2150
acaweb_fx.public.relevance_fibonacci_results	3	3	687
Total	41	34	96,879

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jan 04	06	41	55

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

AccessShareLock Main Lock Type
9 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
AccessExclusiveLock		2	15m43s	7m51s
	relation	2	15m43s	7m51s
AccessShareLock		7	11m48s	1m41s
	relation	7	11m48s	1m41s
	Total	9	27m31s	3m3s

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	1	13m46s	13m46s	13m46s	13m46s	truncate table solr_relevance_old; TRUNCATE TABLE solr_relevance_old; Date: 2024-01-04 06:18:58 Database: acaweb_fx User: postgres Remote: [local] Application: psql TRUNCATE TABLE solr_relevance_old; Date: 2024-01-04 06:26:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql TRUNCATE TABLE solr_relevance_old; Date: 2024-01-04 06:33:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql
2	6	10m7s	1m30s	1m53s	1m41s	select datetimeupdate from latest_candle_datetime_per_receng where recognitionengine ilike ?; SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'LEADERCAPITAL2 - 2'; Date: 2024-01-04 06:18:58 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: [unknown] SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'XM - 1'; Date: 2024-01-04 06:18:58 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: [unknown] SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'LEADERCAPITAL2 - 1'; Date: 2024-01-04 06:18:58 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: [unknown]
3	1	1m56s	1m56s	1m56s	1m56s	refresh materialized view latest_candle_datetime_per_receng; refresh materialized view latest_candle_datetime_per_receng; Date: 2024-01-04 06:18:58 Database: acaweb_fx User: postgres Remote: [local] Application: psql refresh materialized view latest_candle_datetime_per_receng; Date: 2024-01-04 06:32:01 Database: acaweb_fx User: postgres Remote: [local] Application: psql refresh materialized view latest_candle_datetime_per_receng; Date: 2024-01-04 06:47:01 Database: acaweb_fx User: postgres Remote: [local] Application: psql
4	1	1m40s	1m40s	1m40s	1m40s	select recognitionengine, to_char(datetimeupdate, ?) from latest_candle_datetime_per_receng; select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng; Date: 2024-01-04 06:12:16 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: PostgreSQL JDBC Driver Bind query: yes select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng; Date: 2024-01-04 06:18:58 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: PostgreSQL JDBC Driver Bind query: yes select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng; Date: 2024-01-04 06:02:13 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: PostgreSQL JDBC Driver Bind query: yes

Queries that waited the most


[ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]

Rank	Wait time	Query
1	13m46s	TRUNCATE TABLE solr_relevance_old; [ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	1m56s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
3	1m53s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'LEADERCAPITAL2 - 2'; [ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
4	1m47s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'XM - 1'; [ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
5	1m46s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'LEADERCAPITAL2 - 1'; [ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
6	1m40s	select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng; [ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: PostgreSQL JDBC Driver ]
7	1m38s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ADSSECURITIES - 1'; [ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
8	1m30s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'XM - 2'; [ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
9	1m30s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'DKFX - 1'; [ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]

Queries by type

Key values

94,547 Total read queries
32,338 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	94,547	72.17%
INSERT	24,472	18.68%
UPDATE	1,855	1.42%
DELETE	13	0.01%
COPY FROM	78	0.06%
COPY TO	579	0.44%
CTE	4,712	3.60%
DDL	13	0.01%
TCL	616	0.47%
CURSOR	0	0.00%
OTHERS	4,125	3.15%

Queries by database

Key values

acaweb_fx Main database
127,012 Requests
2h1m54s (acaweb_fx)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
acaweb_fx	Total	127,012	2h1m54s
	copy from	78	6s21ms
	copy to	303	13m49s
	cte	4,709	1h15m43s
	ddl	13	13m46s
	delete	13	16ms
	insert	24,472	22s324ms
	others	3,822	2m15s
	select	91,134	15m30s
	tcl	613	139ms
	update	1,855	19s220ms
acaweb_fx_integer	Total	3,584	18m51s
	copy to	276	18m50s
	cte	1	4ms
	others	285	12ms
	select	3,021	928ms
	tcl	1	0ms
postgres	Total	367	161ms
	cte	1	1ms
	others	9	0ms
	select	356	159ms
	tcl	1	0ms
translations	Total	47	119ms
	cte	1	1ms
	others	9	0ms
	select	36	117ms
	tcl	1	0ms

Queries by user

Key values

postgres Main user
131,010 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	131,010	2h20m45s
	copy from	78	6s21ms
	copy to	579	32m39s
	cte	4,712	1h15m43s
	ddl	13	13m46s
	delete	13	16ms
	insert	24,472	22s324ms
	others	4,125	2m15s
	select	94,547	15m31s
	tcl	616	139ms
	update	1,855	19s220ms

Duration by user

Key values

2h20m45s (postgres) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	131,010	2h20m45s
	copy from	78	6s21ms
	copy to	579	32m39s
	cte	4,712	1h15m43s
	ddl	13	13m46s
	delete	13	16ms
	insert	24,472	22s324ms
	others	4,125	2m15s
	select	94,547	15m31s
	tcl	616	139ms
	update	1,855	19s220ms

Queries by host

Key values

192.168.1.20 Main host
33,701 Requests
43m31s (127.0.0.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	19,272	43m31s
	copy to	579	32m39s
	cte	24	244ms
	insert	8,822	9s189ms
	others	604	17ms
	select	7,838	10m41s
	tcl	4	0ms
	update	1,401	902ms
172.10.1.90	Total	48	103ms
	others	24	2ms
	select	20	19ms
	update	4	81ms
182.165.1.42	Total	36	66ms
	select	36	66ms
192.168.0.216	Total	492	305ms
	others	246	16ms
	select	238	187ms
	update	8	101ms
192.168.0.23	Total	68	218ms
	select	68	218ms
192.168.0.239	Total	215	1s751ms
	select	215	1s751ms
192.168.0.42	Total	1,859	9s652ms
	cte	1	0ms
	insert	21	19ms
	others	214	2ms
	select	1,622	9s629ms
	update	1	0ms
192.168.1.135	Total	252	722ms
	cte	8	375ms
	select	244	346ms
192.168.1.145	Total	33,265	21m44s
	cte	1,048	21m1s
	others	212	2ms
	select	32,005	43s386ms
192.168.1.20	Total	33,701	21m31s
	cte	1,042	20m49s
	others	234	2ms
	select	32,425	41s776ms
192.168.1.201	Total	1,298	3s436ms
	select	1,298	3s436ms
192.168.1.210	Total	2	0ms
	select	2	0ms
192.168.1.23	Total	10,508	45s92ms
	others	1,612	16ms
	select	8,896	45s75ms
192.168.1.231	Total	40	0ms
	others	40	0ms
192.168.1.239	Total	168	79ms
	others	84	5ms
	select	84	74ms
192.168.1.25	Total	68	31s204ms
	cte	6	31s162ms
	others	8	0ms
	select	54	41ms
192.168.1.250	Total	10,376	32m52s
	cte	2,492	32m45s
	others	506	4ms
	select	7,378	6s626ms
192.168.1.45	Total	60	171ms
	select	60	171ms
192.168.1.97	Total	6	8ms
	select	6	8ms
192.168.2.126	Total	88	71ms
	others	18	0ms
	select	70	71ms
192.168.2.182	Total	48	254ms
	others	24	1ms
	select	12	8ms
	update	12	243ms
192.168.2.205	Total	142	131ms
	insert	89	12ms
	others	26	2ms
	select	23	28ms
	update	4	87ms
192.168.2.82	Total	399	918ms
	insert	125	289ms
	others	96	7ms
	select	119	78ms
	update	59	543ms
192.168.3.199	Total	240	205ms
	others	120	8ms
	select	108	86ms
	update	12	110ms
192.168.4.142	Total	17,087	14s127ms
	insert	15,415	12s812ms
	select	1,672	1s315ms
192.168.4.150	Total	22	1s299ms
	others	21	0ms
	select	1	1s299ms
192.168.4.238	Total	36	712ms
	cte	12	712ms
	others	24	0ms
192.168.4.95	Total	3	27ms
	cte	1	27ms
	others	2	0ms
192.168.4.98	Total	924	18s297ms
	others	6	17s581ms
	select	6	19ms
	tcl	612	139ms
	update	300	556ms
[local]	Total	287	18m57s
	copy from	78	6s21ms
	cte	78	34s661ms
	ddl	13	13m46s
	delete	13	16ms
	others	4	1m57s
	select	47	2m15s
	update	54	16s593ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
90,293 Requests
1h17m11s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	90,293	1h17m11s
	cte	4,604	1h14m37s
	insert	21	19ms
	others	1,438	17ms
	select	84,229	2m33s
	update	1	0ms
[unknown]	Total	32,683	11m54s
	cte	6	31s162ms
	insert	24,451	22s304ms
	others	2,094	17s639ms
	select	3,733	10m40s
	tcl	612	139ms
	update	1,787	2s607ms
pg_dump	Total	7,634	32m36s
	copy to	553	32m34s
	cte	4	9ms
	others	589	16ms
	select	6,484	1s914ms
	tcl	4	0ms
psql	Total	400	19m2s
	copy from	78	6s21ms
	copy to	26	4s957ms
	cte	98	34s896ms
	ddl	13	13m46s
	delete	13	16ms
	others	4	1m57s
	select	101	2m15s
	update	67	16s612ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2024-01-04 06:48:32 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

82,688 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	82,688	63.12%
1-5ms	41,586	31.74%
5-10ms	2,403	1.83%
10-25ms	1,058	0.81%
25-50ms	826	0.63%
50-100ms	474	0.36%
100-500ms	636	0.49%
500-1000ms	210	0.16%
1000-10000ms	1,033	0.79%
> 10000ms	96	0.07%

Slowest individual queries


[ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2024-01-04 06:07:45 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-01-04 06:31:19 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-01-04 06:13:33 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-01-04 06:21:09 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2024-01-04 06:35:32 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2024-01-04 06:24:13 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2024-01-04 06:22:35 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-01-04 06:17:01 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-01-04 06:27:26 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-01-04 06:10:49 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-01-04 06:28:34 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2024-01-04 06:14:42 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]

Rank	Duration	Query
1	13m46s	TRUNCATE TABLE solr_relevance_old; [ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	2m42s	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-01-04 06:07:45 - 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-01-04 06:31:19 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
4	2m39s	COPY public.researchreports (researchreportid, type, createddatetime, language, filename, xml) TO stdout; [ Date: 2024-01-04 06:13:33 - 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-01-04 06:21:09 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
6	1m57s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
7	1m53s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'LEADERCAPITAL2 - 2'; [ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
8	1m51s	COPY public.t15_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2024-01-04 06:35:32 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
9	1m47s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'XM - 1'; [ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
10	1m46s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'LEADERCAPITAL2 - 1'; [ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
11	1m38s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ADSSECURITIES - 1'; [ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
12	1m37s	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-01-04 06:24:13 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
13	1m30s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'XM - 2'; [ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
14	1m30s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'DKFX - 1'; [ Date: 2024-01-04 06:18:58 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
15	1m18s	COPY public.authenticationlog (attemptid, username, password, brokerid, authclass, attemptdatetime, success, fingerprint, accounttype) TO stdout; [ Date: 2024-01-04 06:22:35 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
16	1m13s	COPY public.t15_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2024-01-04 06:17:01 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
17	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-01-04 06:27:26 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
18	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-01-04 06:10:49 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
19	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-01-04 06:28:34 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
20	1m4s	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-01-04 06:14:42 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]

Time consuming queries


[ User: postgres - Total duration: 32m4s - Times executed: 413 ]
[ User: postgres - Total duration: 30m34s - Times executed: 413 ]
[ User: postgres - Total duration: 13m46s - Times executed: 13 ]
[ User: postgres - Total duration: 10m7s - Times executed: 696 ]
[ User: postgres - Total duration: 9m10s - Times executed: 413 ]
[ User: postgres - Total duration: 5m20s - Times executed: 2 ]
[ User: postgres - Total duration: 4m52s - Times executed: 2 ]
[ User: postgres - Total duration: 3m4s - Times executed: 2 ]
[ User: postgres - Total duration: 2m14s - Times executed: 2 ]
[ User: postgres - Total duration: 1m59s - Times executed: 2 ]
[ User: postgres - Total duration: 1m57s - Times executed: 4 ]
[ User: postgres - Total duration: 1m52s - Times executed: 2 ]
[ User: postgres - Total duration: 1m44s - Times executed: 2 ]
[ User: postgres - Total duration: 1m39s - Times executed: 2 ]
[ User: postgres - Total duration: 1m35s - Times executed: 2 ]
[ User: postgres - Total duration: 1m28s - Times executed: 4 ]
[ User: postgres - Total duration: 1m22s - Times executed: 275 ]
[ User: postgres - Total duration: 1m18s - Times executed: 2 ]
[ User: postgres - Total duration: 1m11s - Times executed: 184 ]
[ User: postgres - Total duration: 55s888ms - Times executed: 19034 ]

Most frequent queries (N)


[ User: postgres - Total duration: 134ms - Times executed: 34854 ]
[ User: postgres - Total duration: 27s785ms - Times executed: 22101 ]
[ User: postgres - Total duration: 55s888ms - Times executed: 19034 ]
[ User: postgres - Total duration: 9s68ms - Times executed: 8008 ]
[ User: postgres - Total duration: 4s475ms - Times executed: 4887 ]
[ User: postgres - Total duration: 2s717ms - Times executed: 4730 ]
[ User: postgres - Total duration: 924ms - Times executed: 2548 ]
[ User: postgres - Total duration: 1s28ms - Times executed: 2324 ]
[ User: postgres - Total duration: 3s615ms - Times executed: 1574 ]
[ User: postgres - Total duration: 23ms - Times executed: 1512 ]
[ User: postgres - Total duration: 13ms - Times executed: 1463 ]
[ User: postgres - Total duration: 17ms - Times executed: 1437 ]
[ User: postgres - Total duration: 883ms - Times executed: 1388 ]
[ User: postgres - Total duration: 827ms - Times executed: 1350 ]
[ User: postgres - Total duration: 439ms - Times executed: 1031 ]
[ User: postgres - Total duration: 98ms - Times executed: 854 ]
[ User: postgres - Total duration: 1s125ms - Times executed: 726 ]
[ User: postgres - Total duration: 139ms - Times executed: 726 ]
[ User: postgres - Total duration: 2s317ms - Times executed: 704 ]
[ User: postgres - Total duration: 10m7s - Times executed: 696 ]

Normalized slowest queries (N)


[ User: postgres - Total duration: 5m20s - Times executed: 2 ]
[ User: postgres - Total duration: 4m52s - Times executed: 2 ]
[ User: postgres - Total duration: 3m4s - Times executed: 2 ]
[ User: postgres - Total duration: 2m14s - Times executed: 2 ]
[ User: postgres - Total duration: 13m46s - Times executed: 13 ]
[ User: postgres - Total duration: 1m59s - Times executed: 2 ]
[ User: postgres - Total duration: 1m52s - Times executed: 2 ]
[ User: postgres - Total duration: 1m44s - Times executed: 2 ]
[ User: postgres - Total duration: 1m39s - Times executed: 2 ]
[ User: postgres - Total duration: 1m35s - Times executed: 2 ]
[ User: postgres - Total duration: 1m18s - Times executed: 2 ]
[ User: postgres - Total duration: 1m57s - Times executed: 4 ]
[ User: postgres - Total duration: 1m28s - Times executed: 4 ]
[ User: postgres - Total duration: 32m4s - Times executed: 413 ]
[ User: postgres - Total duration: 30m34s - Times executed: 413 ]
[ User: postgres - Total duration: 9m10s - Times executed: 413 ]
[ User: postgres - Total duration: 10m7s - Times executed: 696 ]
[ User: postgres - Total duration: 1m11s - Times executed: 184 ]
[ User: postgres - Total duration: 1m22s - Times executed: 275 ]
[ User: postgres - Total duration: 2s317ms - Times executed: 704 ]

Time consuming prepare


[ User: postgres - Total duration: 0ms - Times executed: 5 ]
[ User: postgres - Total duration: 1h2m24s - Times executed: 2385 ]
[ User: postgres - Total duration: 9s743ms - Times executed: 3719 ]
[ User: postgres - Total duration: 1s125ms - Times executed: 726 ]
[ User: postgres - Total duration: 5s723ms - Times executed: 2631 ]
[ User: postgres - Total duration: 2s553ms - Times executed: 4613 ]
[ User: postgres - Total duration: 892ms - Times executed: 2438 ]
[ User: postgres - Total duration: 13ms - Times executed: 1463 ]
[ User: postgres - Total duration: 14ms - Times executed: 2732 ]
[ User: postgres - Total duration: 564ms - Times executed: 40 ]
[ User: postgres - Total duration: 829ms - Times executed: 40 ]
[ User: postgres - Total duration: 309ms - Times executed: 20 ]
[ User: postgres - Total duration: 339ms - Times executed: 40 ]
[ User: postgres - Total duration: 28s608ms - Times executed: 60 ]
[ User: postgres - Total duration: 718ms - Times executed: 40 ]
[ User: postgres - Total duration: 62ms - Times executed: 40 ]
[ User: postgres - Total duration: 434ms - Times executed: 40 ]
[ User: postgres - Total duration: 712ms - Times executed: 12 ]
[ User: postgres - Total duration: 15ms - Times executed: 30 ]
[ User: postgres - Total duration: 567ms - Times executed: 20 ]

Time consuming bind


[ User: postgres - Total duration: 1h13m23s - Times executed: 4337 ]
[ User: postgres - Total duration: 1m31s - Times executed: 44019 ]
[ User: postgres - Total duration: 1m11s - Times executed: 183 ]
[ User: postgres - Total duration: 1s125ms - Times executed: 726 ]
[ User: postgres - Total duration: 712ms - Times executed: 12 ]
[ User: postgres - Total duration: 1s391ms - Times executed: 34 ]
[ User: postgres - Total duration: 2s568ms - Times executed: 32 ]
[ User: postgres - Total duration: 9s68ms - Times executed: 8008 ]
[ User: postgres - Total duration: 15ms - Times executed: 30 ]
[ User: postgres - Total duration: 564ms - Times executed: 40 ]
[ User: postgres - Total duration: 339ms - Times executed: 40 ]
[ User: postgres - Total duration: 829ms - Times executed: 40 ]
[ User: postgres - Total duration: 123ms - Times executed: 34703 ]
[ User: postgres - Total duration: 310ms - Times executed: 19 ]
[ User: postgres - Total duration: 159ms - Times executed: 30 ]
[ User: postgres - Total duration: 11ms - Times executed: 30 ]
[ User: postgres - Total duration: 188ms - Times executed: 30 ]
[ User: postgres - Total duration: 298ms - Times executed: 16 ]
[ User: postgres - Total duration: 278ms - Times executed: 30 ]
[ User: postgres - Total duration: 62ms - Times executed: 40 ]

Log levels

Key values

418,860 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	392	0.09%
DETAIL	137,604	32.85%
ERROR	9	0.00%
LOG	280,334	66.93%
STATEMENT	521	0.12%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
15 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

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

Rank

Times reported

Error

1

11

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jan 04	06	11

LOG: process 10025 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.056 ms at character 28
LOG: process 10031 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.055 ms at character 28
LOG: process 10022 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.057 ms at character 28

2

3

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jan 04	06	3

LOG: process 22181 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 1000.055 ms
LOG: process 22181 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 50903.831 ms
LOG: process 23936 still waiting for AccessExclusiveLock on relation 5894441 of database 5881926 after 1000.055 ms

3

1

Details

ERROR: relation "..." does not exist

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Jan 04	06	1

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

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