pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Thu Nov 9 04:59:55 2023
Log file: /home/postgres/pg_data/data/pg_log/postgresql-2023-11-09_060000.log
Parsed 1,676,007 log entries in 54s
Log start from 2023-11-09 06:00:00 to 2023-11-09 06:59:52

Global Stats

942 Number of unique normalized queries
122,765 Number of queries
2h56m45s Total query duration
2023-11-09 06:00:00 First query
2023-11-09 06:59:52 Last query
3,081 queries/s at 2023-11-09 06:45:04 Query peak

2h56m45s Total query duration
1m48s Prepare/parse total duration
1m20s Bind total duration
2h53m35s Execute total duration

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

40 Total number of automatic vacuums
56 Total number of automatic analyzes

440 Number temporary file
75.42 MiB Max size of temporary file
3.90 MiB Average size of temporary file

3,092 Total number of sessions
13 sessions at 2023-11-09 06:56:12 Session peak
4d21h43m5s Total duration of sessions
2m17s Average duration of sessions
39 Average queries per session
3s429ms Average queries duration per session
2m13s Average idle time per session

3,094 Total number of connections
27 connections/s at 2023-11-09 06:48:48 Connection peak
4 Total number of databases

SQL Traffic

Key values

3,081 queries/s Query Peak
2023-11-09 06:45:04 Date

SELECT Traffic

Key values

3,046 queries/s Query Peak
2023-11-09 06:45:04 Date

INSERT/UPDATE/DELETE Traffic

Key values

214 queries/s Query Peak
2023-11-09 06:02:44 Date

Queries duration

Key values

2h56m45s 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)
Nov 09	06	122,765	0ms	14m16s	84ms	4m39s	6m24s	30m58s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Nov 09	06	83,076	579	37ms	1m9s	2m19s	2m49s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Nov 09	06	30,061	2,628	13	78	1ms	725ms	1s230ms	2s890ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Nov 09	06	21,158	95,763	4.53	17.58%

Day	Hour	Count	Average / Second
Nov 09	06	3,094	0.86/s

Day	Hour	Count	Average Duration	Average idle time
Nov 09	06	3,092	2m17s	2m13s

↑ Back to the top of the General Activity table

Established Connections

Key values

27 connections Connection Peak
2023-11-09 06:48:48 Date

Connections per database

Key values

acaweb_fx Main Database
3,094 connections Total

Chart
Table

Database	User	Count
acaweb_fx		3,089
	pg_dump	1
	postgres	2,742
	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
3,094 connections Total

Chart
Table

User	Count
pg_dump	4
postgres	2,742
psql	348

Connections per host

Key values

192.168.4.142 Main host with 1416 connections
3,094 Total connections

Chart
Table

Host	Count
127.0.0.1	122
172.10.1.90	12
182.165.1.42	12
192.168.0.216	124
192.168.0.42	149
192.168.1.145	97
192.168.1.20	115
192.168.1.23	3
192.168.1.231	20
192.168.1.239	42
192.168.1.25	60
192.168.1.250	150
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.134	1
192.168.4.142	1,416
192.168.4.150	10
192.168.4.238	16
192.168.4.98	306
[local]	235

Simultaneous sessions

Key values

13 sessions Session Peak
2023-11-09 06:56:12 Date

Histogram of session times

Key values

2,465 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	2,465	79.72%
500ms-1s	176	5.69%
1s-30s	299	9.67%
30s-1m	9	0.29%
1m-10m	52	1.68%
10m-30m	73	2.36%
30m-1h	2	0.06%
1h-8h	14	0.45%
> 8h	2	0.06%

Sessions per database

Key values

acaweb_fx Main Database
3,092 sessions Total

Chart
Table

Database	User	Count	Total Duration
acaweb_fx	3,087	4d21h23m53s	2m16s
acaweb_fx_integer	1	19m10s	19m10s
postgres	3	193ms	64ms
translations	1	126ms	126ms

Sessions per user

Key values

postgres Main User
3,092 sessions Total

Chart
Table

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

Sessions per host

Key values

192.168.4.142 Main Host
3,092 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	122	1h31s	29s764ms
172.10.1.90	12	7s307ms	608ms
182.165.1.42	12	2d8h6m25s	4h40m32s
192.168.0.216	124	2m2s	985ms
192.168.0.42	149	1h48m8s	43s550ms
192.168.1.145	96	6h27m8s	4m1s
192.168.1.20	114	15h4m43s	7m56s
192.168.1.23	3	1h28m1s	29m20s
192.168.1.231	20	9h52m33s	29m37s
192.168.1.239	42	235ms	5ms
192.168.1.25	60	33s472ms	557ms
192.168.1.250	150	4h9m27s	1m39s
192.168.2.126	70	6s278ms	89ms
192.168.2.182	12	2s971ms	247ms
192.168.2.205	14	1h	4m17s
192.168.2.82	48	2s865ms	59ms
192.168.3.199	60	1s892ms	31ms
192.168.4.134	1	158ms	158ms
192.168.4.142	1,416	14m59s	634ms
192.168.4.150	10	20h7m13s	2h43s
192.168.4.238	16	4s616ms	288ms
192.168.4.98	306	26s523ms	86ms
[local]	235	20m22s	5s203ms

Sessions per application

Key values

[unknown] Main Host
3,092 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	559	2d10h57m22s	6m19s
[unknown]	2,181	2d9h51m30s	1m35s
pg_dump	4	33m37s	8m24s
psql	348	20m34s	3s548ms

Checkpoints Buffers

Key values

8,960 buffers Checkpoint Peak
2023-11-09 06:06:09 Date
209.951 seconds Highest write time
0.015 seconds Sync time

Checkpoints Wal files

Key values

5 files Wal files usage Peak
2023-11-09 06:16:09 Date

Checkpoints distance

Key values

152.25 Mo Distance Peak
2023-11-09 06:16:09 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Nov 09	06	44,615	2,237.219s	0.07s	2,237.479s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Nov 09	06	0	0	35	2,187	0.006s	0s

Day	Hour	Count	Avg time (sec)
Nov 09	06	0	0s

Day	Hour	Mean distance	Mean estimate
Nov 09	06	48,573.33 kB	66,486.00 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.45 MiB Temp Files size Peak
2023-11-09 06:30:08 Date

Number of temporary files

Key values

31 per second Temp Files Peak
2023-11-09 06:02:05 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Nov 09	06	440	1.67 GiB	3.90 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	74	354.84 MiB	4.13 MiB	7.88 MiB	4.80 MiB	with rar_max as ( ; WITH rar_max as ( ; Date: 2023-11-09 06:00:18 Duration: 0ms Database: acaweb_fx User: postgres Remote: 192.168.1.250 Application: PostgreSQL JDBC Driver
2	42	1.03 GiB	3.21 MiB	73.23 MiB	25.00 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = ? ), 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: 2023-11-09 06:30:09 Duration: 6s413ms 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: 2023-11-09 06:00:08 Duration: 6s348ms 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: 2023-11-09 06:40:08 Duration: 5s760ms Database: acaweb_fx User: postgres Remote: 192.168.1.25 Application: [unknown]
3	4	301.30 MiB	75.23 MiB	75.42 MiB	75.32 MiB	select updateageforrelevantresults (); select updateageforrelevantresults (); Date: 2023-11-09 06:32:36 Duration: 34s102ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateageforrelevantresults (); Date: 2023-11-09 06:47:29 Duration: 26s731ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateageforrelevantresults (); Date: 2023-11-09 06:17:28 Duration: 25s861ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
4	2	8.93 MiB	4.14 MiB	4.80 MiB	4.47 MiB	select resultuid from relevance_fibonacci_results order by resultuid desc limit ?), fr as ( select a., rr.age, rr.relevant from fibonacci_results a left outer join relevance_fibonacci_results rr on a.resultuid = rr.resultuid where case when false = ? then true else a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) end), all_results as ( select fr.resultuid as resultuid, fr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, fr.pattern as pattern_name, fr.timed as timed, fr.patternendtime as identified, dtt.timezone as timezone, fr.patternlengthbars as length, g.basegroupname, newlevels.filtered, case when fr.age is not null then fr.age when fr.resultuid <= rm.resultuid then ? else ? end as age, case when fr.relevant is not null then fr.relevant when fr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from fr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = fr.symbolid inner join symbols s on fr.symbolid = s.symbolid and s.nonliquid = ? inner join symbolgroup sg on fr.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join downloadersymbolsettings dss on fr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join rar_max rm on ? = ? left join lateral calc_fib_signal_filter (fr.resultuid) newlevels on true left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where fr.gmttimefound > now() - interval ? and dss.enabled = ? and s.deleted = ? and (fr.simulation = ? or fr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or fr.pattern in (...)) and (? = ? or fr.patternlengthbars <= ?) and (? = ? or (? = ? and fr.timed > cast(? as timestamp)) or (? = ? and fr.timed < cast(? as timestamp)))), results as ( select distinct on (symbolid) from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc; SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), fr AS ( SELECT a., rr.age, rr.relevant from fibonacci_results a LEFT OUTER JOIN relevance_fibonacci_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) END), all_results AS ( SELECT fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN fr.age IS NOT NULL THEN fr.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN fr.relevant IS NOT NULL THEN fr.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT JOIN LATERAL calc_fib_signal_filter (fr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($3 = 0 OR s.timegranularity in ($4, $5, $6, $7, $8, $9, $10)) AND ($11 = 0 OR s.exchange in ($12)) AND ($13 = 0 OR coalesce(bim.code, s.symbol) in ($14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242)) AND ($243 = 0 OR fr.pattern in ($244)) AND ($245 = 0 OR fr.patternlengthbars <= $246) AND ($247 = 0 OR ($248 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($249 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) FROM all_results WHERE (FALSE = $250 OR relevant = 1) AND ($251 = 0 OR age <= $252) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC; Date: 2023-11-09 06:02:05 Duration: 0ms Database: acaweb_fx User: postgres Remote: 192.168.1.20 Application: PostgreSQL JDBC Driver

Queries generating the largest temporary files

Rank	Size	Query
1	75.42 MiB	select updateageforrelevantresults (); [ Date: 2023-11-09 06:17:15 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	75.36 MiB	select updateageforrelevantresults (); [ Date: 2023-11-09 06:47:19 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
3	75.30 MiB	select updateageforrelevantresults (); [ Date: 2023-11-09 06:32:23 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
4	75.23 MiB	select updateageforrelevantresults (); [ Date: 2023-11-09 06:02:05 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
5	73.23 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: 2023-11-09 06:30:07 ]
6	70.70 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: 2023-11-09 06:20:04 ]
7	51.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: 2023-11-09 06:10:05 ]
8	51.30 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: 2023-11-09 06:00:05 ]
9	51.18 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2023-11-09 06:50:03 ]
10	48.27 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: 2023-11-09 06:00:05 ]
11	45.49 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: 2023-11-09 06:40:06 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.25 - Application: [unknown] ]
12	41.67 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: 2023-11-09 06:50:04 ]
13	41.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: 2023-11-09 06:00:05 ]
14	36.98 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: 2023-11-09 06:10:06 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.25 - Application: [unknown] ]
15	36.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: 2023-11-09 06:50:03 ]
16	35.41 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2023-11-09 06:40:06 ]
17	35.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: 2023-11-09 06:20:06 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.25 - Application: [unknown] ]
18	33.48 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2023-11-09 06:10:06 ]
19	32.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: 2023-11-09 06:40:06 ]
20	26.66 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2023-11-09 06:50:04 ]

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)
56 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.pg_catalog.pg_index	2
acaweb_fx.public.autochartist_symbolupdates	2
acaweb_fx.pg_catalog.pg_depend	2
acaweb_fx.public.latest_t15_candle_view	2
acaweb_fx.public.latest_candle_datetime_per_receng	1
acaweb_fx.public.relevance_consecutivecandles_results	1
acaweb_fx.public.symbollatestupdatetime	1
acaweb_fx.public.relevance_bigmovement_results	1
Total	56

Vacuums per table

Key values

public.solr_relevance_old (13) Main table vacuumed on database acaweb_fx
40 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	15,643	0	41	0	0	11,982	13	2,116,164
acaweb_fx.public.datafeeds_latestrun	6	0	681	0	17	0	0	70	13	68,880
acaweb_fx.public.relevance_keylevels_results	4	3	16,694	0	743	2	192	3,457	1,833	6,311,394
acaweb_fx.public.relevance_autochartist_results	4	3	14,436	0	943	4	708	2,464	1,692	5,296,339
acaweb_fx.public.relevance_fibonacci_results	4	4	5,640	0	192	2	99	761	309	1,378,924
acaweb_fx.pg_toast.pg_toast_2619	2	2	269	0	67	0	0	169	52	233,876
acaweb_fx.pg_catalog.pg_attribute	2	2	1,614	0	391	0	128	798	300	1,735,270
acaweb_fx.pg_catalog.pg_type	1	1	137	0	24	0	0	56	18	107,856
acaweb_fx.public.autochartist_symbolupdates	1	1	7,436	0	208	0	9,860	3,640	2,018	1,713,046
acaweb_fx.pg_catalog.pg_statistic	1	1	819	0	264	0	677	523	227	892,331
acaweb_fx.public.latest_t15_candle_view	1	1	61	0	2	0	0	6	4	16,701
acaweb_fx.pg_catalog.pg_class	1	1	372	0	22	0	39	123	19	114,390
Total	40	32	63,802	39,246	2,914	8	11,703	24,049	6,498	19,985,171

Tuples removed per table

Key values

public.solr_relevance_old (91286) Main table with removed tuples on database acaweb_fx
110615 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	91,286	111,131	0	0	4,025
acaweb_fx.public.autochartist_symbolupdates	1	1	5,632	47,435	28	0	11,334
acaweb_fx.public.relevance_keylevels_results	4	3	4,097	62,076	5,786	0	1,192
acaweb_fx.public.relevance_autochartist_results	4	3	3,877	46,573	3,784	0	1,520
acaweb_fx.pg_catalog.pg_attribute	2	2	3,300	18,476	0	0	484
acaweb_fx.pg_catalog.pg_statistic	1	1	767	4,251	0	0	1,194
acaweb_fx.public.relevance_fibonacci_results	4	4	716	8,259	826	0	408
acaweb_fx.public.datafeeds_latestrun	6	0	269	241	121	0	108
acaweb_fx.pg_catalog.pg_class	1	1	264	1,978	0	0	150
acaweb_fx.pg_catalog.pg_type	1	1	220	1,288	0	2	35
acaweb_fx.pg_toast.pg_toast_2619	2	2	118	387	55	0	100
acaweb_fx.public.latest_t15_candle_view	1	1	69	19	0	0	1
Total	40	32	110,615	302,114	10,600	2	20,551

Pages removed per table

Key values

pg_catalog.pg_type (2) Main table with removed pages on database acaweb_fx
2 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
acaweb_fx.pg_catalog.pg_type	1	1	220	2
acaweb_fx.pg_toast.pg_toast_2619	2	2	118	0
acaweb_fx.public.datafeeds_latestrun	6	0	269	0
acaweb_fx.public.autochartist_symbolupdates	1	1	5632	0
acaweb_fx.pg_catalog.pg_statistic	1	1	767	0
acaweb_fx.pg_catalog.pg_attribute	2	2	3300	0
acaweb_fx.public.latest_t15_candle_view	1	1	69	0
acaweb_fx.public.relevance_keylevels_results	4	3	4097	0
acaweb_fx.pg_catalog.pg_class	1	1	264	0
acaweb_fx.public.solr_relevance_old	13	13	91286	0
acaweb_fx.public.relevance_autochartist_results	4	3	3877	0
acaweb_fx.public.relevance_fibonacci_results	4	4	716	0
Total	40	32	110,615	2

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Nov 09	06	40	56

↑ 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	16m42s	8m21s
	relation	2	16m42s	8m21s
AccessShareLock		7	14m28s	2m4s
	relation	7	14m28s	2m4s
	Total	9	31m10s	3m27s

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	1	14m15s	14m15s	14m15s	14m15s	truncate table solr_relevance_old; TRUNCATE TABLE solr_relevance_old; Date: 2023-11-09 06:19:27 Database: acaweb_fx User: postgres Remote: [local] Application: psql TRUNCATE TABLE solr_relevance_old; Date: 2023-11-09 06:26:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql TRUNCATE TABLE solr_relevance_old; Date: 2023-11-09 06:56:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql
2	6	12m46s	1m56s	2m23s	2m7s	select datetimeupdate from latest_candle_datetime_per_receng where recognitionengine ilike ?; SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'DKFX - 1'; Date: 2023-11-09 06:19:27 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: 2023-11-09 06:19:27 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: [unknown] SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ADSSECURITIES - 1'; Date: 2023-11-09 06:19:27 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: [unknown]
3	1	2m26s	2m26s	2m26s	2m26s	refresh materialized view latest_candle_datetime_per_receng; refresh materialized view latest_candle_datetime_per_receng; Date: 2023-11-09 06:19:27 Database: acaweb_fx User: postgres Remote: [local] Application: psql refresh materialized view latest_candle_datetime_per_receng; Date: 2023-11-09 06:32:02 Database: acaweb_fx User: postgres Remote: [local] Application: psql refresh materialized view latest_candle_datetime_per_receng; Date: 2023-11-09 06:47:02 Database: acaweb_fx User: postgres Remote: [local] Application: psql
4	1	1m41s	1m41s	1m41s	1m41s	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: 2023-11-09 06:19:27 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: 2023-11-09 06:07:41 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: 2023-11-09 06:12:44 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: PostgreSQL JDBC Driver Bind query: yes

Queries that waited the most


[ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: PostgreSQL JDBC Driver ]

Rank	Wait time	Query
1	14m15s	TRUNCATE TABLE solr_relevance_old; [ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	2m26s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
3	2m23s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'DKFX - 1'; [ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
4	2m20s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'XM - 1'; [ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
5	2m6s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ADSSECURITIES - 1'; [ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
6	1m59s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'XM - 2'; [ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
7	1m58s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'LEADERCAPITAL2 - 1'; [ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
8	1m56s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'LEADERCAPITAL2 - 2'; [ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
9	1m41s	select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng; [ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: PostgreSQL JDBC Driver ]

Queries by type

Key values

83,076 Total read queries
37,292 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	83,076	67.67%
INSERT	30,061	24.49%
UPDATE	2,628	2.14%
DELETE	13	0.01%
COPY FROM	78	0.06%
COPY TO	579	0.47%
CTE	3,304	2.69%
DDL	13	0.01%
TCL	616	0.50%
CURSOR	0	0.00%
OTHERS	2,397	1.95%

Queries by database

Key values

acaweb_fx Main database
118,767 Requests
2h34m39s (acaweb_fx)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
acaweb_fx	Total	118,767	2h34m39s
	copy from	78	6s163ms
	copy to	303	14m25s
	cte	3,301	1h43m32s
	ddl	13	14m16s
	delete	13	18ms
	insert	30,061	28s565ms
	others	2,094	2m49s
	select	79,663	18m42s
	tcl	613	144ms
	update	2,628	17s509ms
acaweb_fx_integer	Total	3,584	18m56s
	copy to	276	18m55s
	cte	1	4ms
	others	285	13ms
	select	3,021	923ms
	tcl	1	0ms
postgres	Total	367	170ms
	cte	1	1ms
	others	9	0ms
	select	356	169ms
	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
122,765 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	122,765	2h53m35s
	copy from	78	6s163ms
	copy to	579	33m20s
	cte	3,304	1h43m32s
	ddl	13	14m16s
	delete	13	18ms
	insert	30,061	28s565ms
	others	2,397	2m49s
	select	83,076	18m43s
	tcl	616	144ms
	update	2,628	17s509ms

Duration by user

Key values

2h53m35s (postgres) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	122,765	2h53m35s
	copy from	78	6s163ms
	copy to	579	33m20s
	cte	3,304	1h43m32s
	ddl	13	14m16s
	delete	13	18ms
	insert	30,061	28s565ms
	others	2,397	2m49s
	select	83,076	18m43s
	tcl	616	144ms
	update	2,628	17s509ms

Queries by host

Key values

192.168.1.20 Main host
32,897 Requests
47m4s (127.0.0.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	24,365	47m4s
	copy to	579	33m20s
	cte	24	294ms
	insert	13,156	14s218ms
	others	604	17ms
	select	7,824	13m27s
	tcl	4	0ms
	update	2,174	1s613ms
172.10.1.90	Total	48	106ms
	others	24	2ms
	select	20	21ms
	update	4	82ms
182.165.1.42	Total	534	6m17s
	cte	86	6m16s
	others	12	0ms
	select	436	774ms
192.168.0.216	Total	496	330ms
	others	248	18ms
	select	240	203ms
	update	8	107ms
192.168.0.23	Total	238	837ms
	select	238	837ms
192.168.0.236	Total	4	0ms
	cte	1	0ms
	select	3	0ms
192.168.0.239	Total	130	421ms
	select	130	421ms
192.168.0.42	Total	3,074	14s371ms
	cte	2	4ms
	insert	152	42ms
	others	298	2ms
	select	2,622	14s322ms
192.168.1.135	Total	248	906ms
	cte	8	307ms
	select	240	598ms
192.168.1.145	Total	27,690	28m35s
	cte	739	27m56s
	others	194	1ms
	select	26,757	38s883ms
192.168.1.20	Total	32,897	28m42s
	cte	746	27m55s
	others	230	2ms
	select	31,921	47s685ms
192.168.1.201	Total	1,768	8s77ms
	select	1,768	8s77ms
192.168.1.210	Total	8	5ms
	select	8	5ms
192.168.1.23	Total	4,407	26s528ms
	cte	10	60ms
	others	6	0ms
	select	4,391	26s468ms
192.168.1.231	Total	40	0ms
	others	40	0ms
192.168.1.239	Total	168	84ms
	others	84	5ms
	select	84	78ms
192.168.1.25	Total	68	31s454ms
	cte	6	31s412ms
	others	8	0ms
	select	54	42ms
192.168.1.250	Total	6,356	40m23s
	cte	1,585	40m16s
	others	300	2ms
	select	4,471	7s494ms
192.168.1.97	Total	8	1ms
	cte	2	0ms
	select	6	0ms
192.168.2.126	Total	88	69ms
	others	18	0ms
	select	70	69ms
192.168.2.182	Total	48	257ms
	others	24	2ms
	select	12	9ms
	update	12	245ms
192.168.2.205	Total	142	124ms
	insert	89	15ms
	others	26	2ms
	select	23	30ms
	update	4	75ms
192.168.2.82	Total	399	1s42ms
	insert	123	323ms
	others	96	9ms
	select	120	90ms
	update	60	619ms
192.168.3.199	Total	240	218ms
	others	120	9ms
	select	108	89ms
	update	12	119ms
192.168.4.134	Total	3	41ms
	cte	1	41ms
	others	2	0ms
192.168.4.142	Total	18,017	15s414ms
	insert	16,541	13s965ms
	select	1,476	1s448ms
192.168.4.150	Total	22	3s436ms
	others	21	0ms
	select	1	3s436ms
192.168.4.238	Total	48	2s366ms
	cte	16	2s365ms
	others	32	0ms
192.168.4.98	Total	924	23s57ms
	others	6	22s299ms
	select	6	20ms
	tcl	612	144ms
	update	300	592ms
[local]	Total	287	20m22s
	copy from	78	6s163ms
	cte	78	33s320ms
	ddl	13	14m16s
	delete	13	18ms
	others	4	2m27s
	select	47	2m45s
	update	54	14s53ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
76,388 Requests
1h38m39s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	76,388	1h38m39s
	cte	3,107	1h36m10s
	insert	152	42ms
	others	567	5ms
	select	72,562	2m28s
[unknown]	Total	38,343	21m11s
	cte	95	6m48s
	insert	29,909	28s523ms
	others	1,237	22s356ms
	select	3,929	13m28s
	tcl	612	144ms
	update	2,561	3s436ms
pg_dump	Total	7,634	33m11s
	copy to	553	33m9s
	cte	4	15ms
	others	589	17ms
	select	6,484	1s932ms
	tcl	4	0ms
psql	Total	400	20m33s
	copy from	78	6s163ms
	copy to	26	11s155ms
	cte	98	33s599ms
	ddl	13	14m16s
	delete	13	18ms
	others	4	2m27s
	select	101	2m45s
	update	67	14s73ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2023-11-09 06:12:26 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

76,104 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	76,104	61.99%
1-5ms	39,180	31.91%
5-10ms	3,378	2.75%
10-25ms	947	0.77%
25-50ms	555	0.45%
50-100ms	408	0.33%
100-500ms	691	0.56%
500-1000ms	276	0.22%
1000-10000ms	1,000	0.81%
> 10000ms	226	0.18%

Slowest individual queries


[ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2023-11-09 06:31:46 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2023-11-09 06:07:46 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2023-11-09 06:13:55 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-11-09 06:21:39 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-11-09 06:36:06 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2023-11-09 06:24:36 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2023-11-09 06:17:32 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2023-11-09 06:11:08 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2023-11-09 06:22:58 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2023-11-09 06:27:50 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2023-11-09 06:28:57 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2023-11-09 06:15:02 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]

Rank	Duration	Query
1	14m16s	TRUNCATE TABLE solr_relevance_old; [ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	2m44s	COPY public.researchreports (researchreportid, type, createddatetime, language, filename, xml) TO stdout; [ Date: 2023-11-09 06:31:46 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
3	2m43s	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: 2023-11-09 06:07:46 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
4	2m41s	COPY public.researchreports (researchreportid, type, createddatetime, language, filename, xml) TO stdout; [ Date: 2023-11-09 06:13:55 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
5	2m26s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
6	2m23s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'DKFX - 1'; [ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
7	2m20s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'XM - 1'; [ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
8	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: 2023-11-09 06:21:39 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
9	2m6s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ADSSECURITIES - 1'; [ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
10	1m59s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'XM - 2'; [ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
11	1m58s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'LEADERCAPITAL2 - 1'; [ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
12	1m56s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'LEADERCAPITAL2 - 2'; [ Date: 2023-11-09 06:19:27 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
13	1m51s	COPY public.t15_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2023-11-09 06:36:06 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
14	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: 2023-11-09 06:24:36 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
15	1m20s	COPY public.t15_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2023-11-09 06:17:32 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
16	1m11s	COPY public.powerstats_trumpet_test (symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) TO stdout; [ Date: 2023-11-09 06:11:08 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
17	1m11s	COPY public.authenticationlog (attemptid, username, password, brokerid, authclass, attemptdatetime, success, fingerprint, accounttype) TO stdout; [ Date: 2023-11-09 06:22:58 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
18	1m9s	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: 2023-11-09 06:27:50 - Database: acaweb_fx_integer - 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: 2023-11-09 06:28:57 - 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: 2023-11-09 06:15:02 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]

Time consuming queries


[ User: postgres - Total duration: 43m3s - Times executed: 385 ]
[ User: postgres - Total duration: 35m55s - Times executed: 387 ]
[ User: postgres - Total duration: 14m16s - Times executed: 13 ]
[ User: postgres - Total duration: 13m44s - Times executed: 385 ]
[ User: postgres - Total duration: 12m46s - Times executed: 690 ]
[ User: postgres - Total duration: 5m26s - Times executed: 2 ]
[ User: postgres - Total duration: 4m54s - Times executed: 2 ]
[ User: postgres - Total duration: 3m17s - Times executed: 12 ]
[ User: postgres - Total duration: 3m11s - Times executed: 2 ]
[ User: postgres - Total duration: 2m49s - Times executed: 12 ]
[ User: postgres - Total duration: 2m27s - Times executed: 4 ]
[ User: postgres - Total duration: 2m19s - Times executed: 2 ]
[ User: postgres - Total duration: 2m3s - Times executed: 2 ]
[ User: postgres - Total duration: 1m58s - Times executed: 2 ]
[ User: postgres - Total duration: 1m47s - Times executed: 2 ]
[ User: postgres - Total duration: 1m42s - Times executed: 2 ]
[ User: postgres - Total duration: 1m39s - Times executed: 4 ]
[ User: postgres - Total duration: 1m37s - Times executed: 2 ]
[ User: postgres - Total duration: 1m36s - Times executed: 194 ]
[ User: postgres - Total duration: 1m33s - Times executed: 261 ]

Most frequent queries (N)


[ User: postgres - Total duration: 134ms - Times executed: 29115 ]
[ User: postgres - Total duration: 27s512ms - Times executed: 19667 ]
[ User: postgres - Total duration: 56s371ms - Times executed: 18032 ]
[ User: postgres - Total duration: 9s735ms - Times executed: 8487 ]
[ User: postgres - Total duration: 6s457ms - Times executed: 6745 ]
[ User: postgres - Total duration: 2s990ms - Times executed: 5107 ]
[ User: postgres - Total duration: 2s346ms - Times executed: 4304 ]
[ User: postgres - Total duration: 1s110ms - Times executed: 2813 ]
[ User: postgres - Total duration: 1s593ms - Times executed: 2161 ]
[ User: postgres - Total duration: 5s338ms - Times executed: 2057 ]
[ User: postgres - Total duration: 22ms - Times executed: 1512 ]
[ User: postgres - Total duration: 93ms - Times executed: 854 ]
[ User: postgres - Total duration: 4s295ms - Times executed: 838 ]
[ User: postgres - Total duration: 1s266ms - Times executed: 701 ]
[ User: postgres - Total duration: 162ms - Times executed: 701 ]
[ User: postgres - Total duration: 12m46s - Times executed: 690 ]
[ User: postgres - Total duration: 190ms - Times executed: 679 ]
[ User: postgres - Total duration: 546ms - Times executed: 631 ]
[ User: postgres - Total duration: 5ms - Times executed: 604 ]
[ User: postgres - Total duration: 73ms - Times executed: 583 ]

Normalized slowest queries (N)


[ User: postgres - Total duration: 5m26s - Times executed: 2 ]
[ User: postgres - Total duration: 4m54s - Times executed: 2 ]
[ User: postgres - Total duration: 3m11s - Times executed: 2 ]
[ User: postgres - Total duration: 2m19s - Times executed: 2 ]
[ User: postgres - Total duration: 14m16s - Times executed: 13 ]
[ User: postgres - Total duration: 2m3s - Times executed: 2 ]
[ User: postgres - Total duration: 1m58s - Times executed: 2 ]
[ User: postgres - Total duration: 1m47s - Times executed: 2 ]
[ User: postgres - Total duration: 1m42s - Times executed: 2 ]
[ User: postgres - Total duration: 1m37s - Times executed: 2 ]
[ User: postgres - Total duration: 2m27s - Times executed: 4 ]
[ User: postgres - Total duration: 1m39s - Times executed: 4 ]
[ User: postgres - Total duration: 3m17s - Times executed: 12 ]
[ User: postgres - Total duration: 2m49s - Times executed: 12 ]
[ User: postgres - Total duration: 43m3s - Times executed: 385 ]
[ User: postgres - Total duration: 35m55s - Times executed: 387 ]
[ User: postgres - Total duration: 13m44s - Times executed: 385 ]
[ User: postgres - Total duration: 12m46s - Times executed: 690 ]
[ User: postgres - Total duration: 1m36s - Times executed: 194 ]
[ User: postgres - Total duration: 1m33s - Times executed: 261 ]

Time consuming prepare


[ User: postgres - Total duration: 0ms - Times executed: 5 ]
[ User: postgres - Total duration: 1h17m45s - Times executed: 1940 ]
[ User: postgres - Total duration: 10s469ms - Times executed: 3330 ]
[ User: postgres - Total duration: 1s266ms - Times executed: 701 ]
[ User: postgres - Total duration: 5s917ms - Times executed: 2222 ]
[ User: postgres - Total duration: 2s841ms - Times executed: 4987 ]
[ User: postgres - Total duration: 1s73ms - Times executed: 2707 ]
[ User: postgres - Total duration: 2s365ms - Times executed: 16 ]
[ User: postgres - Total duration: 432ms - Times executed: 30 ]
[ User: postgres - Total duration: 5ms - Times executed: 604 ]
[ User: postgres - Total duration: 157ms - Times executed: 37 ]
[ User: postgres - Total duration: 164ms - Times executed: 30 ]
[ User: postgres - Total duration: 167ms - Times executed: 60 ]
[ User: postgres - Total duration: 11ms - Times executed: 1524 ]
[ User: postgres - Total duration: 35s333ms - Times executed: 49 ]
[ User: postgres - Total duration: 274ms - Times executed: 36 ]
[ User: postgres - Total duration: 34ms - Times executed: 18 ]
[ User: postgres - Total duration: 40ms - Times executed: 42 ]
[ User: postgres - Total duration: 252ms - Times executed: 36 ]
[ User: postgres - Total duration: 82ms - Times executed: 42 ]

Time consuming bind


[ User: postgres - Total duration: 1h40m31s - Times executed: 2921 ]
[ User: postgres - Total duration: 1m32s - Times executed: 39884 ]
[ User: postgres - Total duration: 1m36s - Times executed: 194 ]
[ User: postgres - Total duration: 2s365ms - Times executed: 16 ]
[ User: postgres - Total duration: 1s266ms - Times executed: 701 ]
[ User: postgres - Total duration: 5s176ms - Times executed: 66 ]
[ User: postgres - Total duration: 9s735ms - Times executed: 8487 ]
[ User: postgres - Total duration: 167ms - Times executed: 60 ]
[ User: postgres - Total duration: 777ms - Times executed: 28 ]
[ User: postgres - Total duration: 28ms - Times executed: 30 ]
[ User: postgres - Total duration: 117ms - Times executed: 28938 ]
[ User: postgres - Total duration: 432ms - Times executed: 30 ]
[ User: postgres - Total duration: 1ms - Times executed: 30 ]
[ User: postgres - Total duration: 19ms - Times executed: 59 ]
[ User: postgres - Total duration: 164ms - Times executed: 30 ]
[ User: postgres - Total duration: 40ms - Times executed: 42 ]
[ User: postgres - Total duration: 270ms - Times executed: 30 ]
[ User: postgres - Total duration: 82ms - Times executed: 42 ]
[ User: postgres - Total duration: 157ms - Times executed: 37 ]
[ User: postgres - Total duration: 98ms - Times executed: 44 ]

Log levels

Key values

378,636 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	248	0.07%
DETAIL	128,441	33.92%
ERROR	8	0.00%
LOG	249,564	65.91%
STATEMENT	375	0.10%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
14 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

11 Max number of times the same event was reported
14 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
Nov 09	06	11

LOG: process 9126 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.043 ms at character 28
LOG: process 8423 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.055 ms at character 28
LOG: process 9124 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.054 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
Nov 09	06	3

LOG: process 21464 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 1000.051 ms
LOG: process 21464 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 51219.678 ms
LOG: process 23022 still waiting for AccessExclusiveLock on relation 5894441 of database 5881926 after 1000.051 ms

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

Queries generating the most temporary files (N)

Queries generating the largest temporary files

Vacuums

Vacuums / Analyzes Distribution

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

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