pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Thu Dec 14 04:59:52 2023
Log file: /home/postgres/pg_data/data/pg_log/postgresql-2023-12-14_060000.log
Parsed 1,615,772 log entries in 51s
Log start from 2023-12-14 06:00:00 to 2023-12-14 06:59:50

Global Stats

947 Number of unique normalized queries
109,948 Number of queries
3h31m30s Total query duration
2023-12-14 06:00:00 First query
2023-12-14 06:59:50 Last query
3,100 queries/s at 2023-12-14 06:19:34 Query peak

3h31m30s Total query duration
2m8s Prepare/parse total duration
2m9s Bind total duration
3h27m11s Execute total duration

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

41 Total number of automatic vacuums
58 Total number of automatic analyzes

467 Number temporary file
76.09 MiB Max size of temporary file
3.94 MiB Average size of temporary file

3,141 Total number of sessions
13 sessions at 2023-12-14 06:56:14 Session peak
3d2h59m45s Total duration of sessions
1m25s Average duration of sessions
35 Average queries per session
4s40ms Average queries duration per session
1m21s Average idle time per session

3,140 Total number of connections
28 connections/s at 2023-12-14 06:18:48 Connection peak
4 Total number of databases

SQL Traffic

Key values

3,100 queries/s Query Peak
2023-12-14 06:19:34 Date

SELECT Traffic

Key values

3,028 queries/s Query Peak
2023-12-14 06:19:34 Date

INSERT/UPDATE/DELETE Traffic

Key values

144 queries/s Query Peak
2023-12-14 06:03:11 Date

Queries duration

Key values

3h31m30s 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)
Dec 14	06	109,948	0ms	14m22s	113ms	5m50s	6m40s	37m15s

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 14	06	80,081	579	43ms	1m17s	2m15s	2m53s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 14	06	20,315	1,601	13	78	2ms	610ms	1s324ms	2s412ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Dec 14	06	25,296	90,432	3.57	23.57%

Day	Hour	Count	Average / Second
Dec 14	06	3,140	0.87/s

Day	Hour	Count	Average Duration	Average idle time
Dec 14	06	3,141	1m25s	1m21s

↑ Back to the top of the General Activity table

Established Connections

Key values

28 connections Connection Peak
2023-12-14 06:18:48 Date

Connections per database

Key values

acaweb_fx Main Database
3,140 connections Total

Chart
Table

Database	User	Count
acaweb_fx		3,135
	pg_dump	1
	postgres	2,788
	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,140 connections Total

Chart
Table

User	Count
pg_dump	4
postgres	2,788
psql	348

Connections per host

Key values

192.168.4.142 Main host with 1337 connections
3,140 Total connections

Chart
Table

Host	Count
127.0.0.1	125
172.10.1.90	12
182.165.1.42	43
192.168.0.216	127
192.168.0.42	54
192.168.1.145	105
192.168.1.20	128
192.168.1.23	68
192.168.1.231	20
192.168.1.239	54
192.168.1.25	60
192.168.1.250	231
192.168.2.126	71
192.168.2.182	12
192.168.2.205	14
192.168.2.82	48
192.168.3.199	63
192.168.4.142	1,337
192.168.4.150	10
192.168.4.238	16
192.168.4.30	1
192.168.4.98	306
[local]	235

Simultaneous sessions

Key values

13 sessions Session Peak
2023-12-14 06:56:14 Date

Histogram of session times

Key values

2,522 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	2,522	80.29%
500ms-1s	121	3.85%
1s-30s	282	8.98%
30s-1m	23	0.73%
1m-10m	80	2.55%
10m-30m	93	2.96%
30m-1h	8	0.25%
1h-8h	12	0.38%
> 8h	0	0.00%

Sessions per database

Key values

acaweb_fx Main Database
3,141 sessions Total

Chart
Table

Database	User	Count	Total Duration
acaweb_fx	3,136	3d2h40m11s	1m25s
acaweb_fx_integer	1	19m33s	19m33s
postgres	3	193ms	64ms
translations	1	127ms	127ms

Sessions per user

Key values

postgres Main User
3,141 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,141 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
127.0.0.1	125	1h21m24s	39s78ms
172.10.1.90	12	7s284ms	607ms
182.165.1.42	43	4h38m18s	6m28s
192.168.0.216	127	3m2s	1s439ms
192.168.0.42	54	1h39m58s	1m51s
192.168.1.145	105	4h24m32s	2m31s
192.168.1.20	128	14h50m16s	6m57s
192.168.1.23	68	2h33m30s	2m15s
192.168.1.231	20	9h53m18s	29m39s
192.168.1.239	54	278ms	5ms
192.168.1.25	60	32s966ms	549ms
192.168.1.250	232	14h3m42s	3m38s
192.168.2.126	71	5s917ms	83ms
192.168.2.182	12	1s770ms	147ms
192.168.2.205	14	1h	4m17s
192.168.2.82	48	2s984ms	62ms
192.168.3.199	63	1m4s	1s19ms
192.168.4.142	1,337	8m18s	372ms
192.168.4.150	10	20h45s	2h4s
192.168.4.238	16	4s895ms	305ms
192.168.4.30	1	167ms	167ms
192.168.4.98	306	20s614ms	67ms
[local]	235	20m15s	5s171ms

Sessions per application

Key values

[unknown] Main Host
3,141 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
PostgreSQL JDBC Driver	634	2d19h26m7s	6m22s
[unknown]	2,155	6h39m	11s109ms
pg_dump	4	34m5s	8m31s
psql	348	20m30s	3s536ms

Checkpoints Buffers

Key values

11,526 buffers Checkpoint Peak
2023-12-14 06:07:33 Date
210.040 seconds Highest write time
0.011 seconds Sync time

Checkpoints Wal files

Key values

5 files Wal files usage Peak
2023-12-14 06:07:33 Date

Checkpoints distance

Key values

170.14 Mo Distance Peak
2023-12-14 06:07:33 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Dec 14	06	35,496	1,735.019s	0.033s	1,735.202s

Day	Hour	Added	Removed	Recycled	Synced files	Longest sync	Average sync
Dec 14	06	0	0	26	1,799	0.003s	0s

Day	Hour	Count	Avg time (sec)
Dec 14	06	0	0s

Day	Hour	Mean distance	Mean estimate
Dec 14	06	39,313.18 kB	69,249.82 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

103.48 MiB Temp Files size Peak
2023-12-14 06:10:04 Date

Number of temporary files

Key values

30 per second Temp Files Peak
2023-12-14 06:32:16 Date

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Dec 14	06	467	1.80 GiB	3.94 MiB

↑ Back to the top of the Temporary Files Activity table

Queries generating the most temporary files (N)


Date: 2023-12-14 06:00:09
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.250
Application: PostgreSQL JDBC Driver
Date: 2023-12-14 06:30:09
Duration: 6s785ms
Database: acaweb_fx
User: postgres
Remote: 192.168.1.25
Application: [unknown]
Date: 2023-12-14 06:02:45
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.0.42
Application: PostgreSQL JDBC Driver
Date: 2023-12-14 06:02:45
Duration: 0ms
Database: acaweb_fx
User: postgres
Remote: 192.168.0.42
Application: PostgreSQL JDBC Driver
Date: 2023-12-14 06:47:27
Duration: 24s307ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql
Date: 2023-12-14 06:06:09
Duration: 5s366ms
Database: acaweb_fx
User: postgres
Remote: [local]
Application: psql

Rank	Count	Total size	Min size	Max size	Avg size	Query
1	73	349.39 MiB	3.09 MiB	9.28 MiB	4.79 MiB	with rar_max as ( ; WITH rar_max as ( ; Date: 2023-12-14 06:00:09 Duration: 0ms Database: acaweb_fx User: postgres Remote: 192.168.1.250 Application: PostgreSQL JDBC Driver
2	42	1.06 GiB	3.42 MiB	76.09 MiB	25.92 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-12-14 06:30:09 Duration: 6s785ms 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-12-14 06:20:08 Duration: 5s861ms 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-12-14 06:40:08 Duration: 5s585ms Database: acaweb_fx User: postgres Remote: 192.168.1.25 Application: [unknown]
3	15	66.57 MiB	3.98 MiB	4.84 MiB	4.44 MiB	select distinct patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzos, dftt.timezone as tz, longname, case when rar.age is not null then rar.age when a.resultuid <= ( select resultuid from relevance_autochartist_results order by resultuid desc limit ?) then ? else ? end as age, case when rar.relevant is not null then rar.relevant when a.resultuid <= ( select resultuid from relevance_autochartist_results order by resultuid desc limit ?) then ? else ? end as relevant from symbols s inner join brokersymbollist b on s.symbolid = b.symbolid inner join downloadersymbolsettings dss on dss.symbolid = s.symbolid inner join datafeedstimetable dftt on dftt.classname = dss.classname inner join autochartist_results a on a.symbolid = s.symbolid inner join patterns p on a.pattern = p.patternname left outer join relevance_autochartist_results rar on rar.resultuid = a.resultuid where b.brokerid = ? and (((s.symbol ilike ? and timegranularity <= ?); /server.CPResultList/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 125 AND (((s.symbol ilike '%gbpusd%' AND timegranularity <= 1440); Date: 2023-12-14 06:02:45 Duration: 0ms Database: acaweb_fx User: postgres Remote: 192.168.0.42 Application: PostgreSQL JDBC Driver
4	8	39.96 MiB	4.98 MiB	5.00 MiB	5.00 MiB	select distinct patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzos, dftt.timezone as tz, longname, case when rar.age is not null then rar.age when a.resultuid <= ( select resultuid from relevance_autochartist_results order by resultuid desc limit ?) then ? else ? end as age, case when rar.relevant is not null then rar.relevant when a.resultuid <= ( select resultuid from relevance_autochartist_results order by resultuid desc limit ?) then ? else ? end as relevant from symbols s inner join brokersymbollist b on s.symbolid = b.symbolid inner join downloadersymbolsettings dss on dss.symbolid = s.symbolid inner join datafeedstimetable dftt on dftt.classname = dss.classname inner join autochartist_results a on a.symbolid = s.symbolid inner join patterns p on a.pattern = p.patternname left outer join relevance_autochartist_results rar on rar.resultuid = a.resultuid where b.brokerid = ? and (((s.symbol ilike ? and timegranularity = ?); /server.CPResultList/ SELECT DISTINCT patternid, resy0, resy1, supporty0, supporty1, predictiontimeto, patternstarttime, s.symbolid, resx0, resx1, supportx0, supportx1, s.symbol, shortname, timegranularity, patternendtime, pattern, a.direction, trendchange, patternlengthbars, patternquality, a.resultuid as uid, breakout, initialtrend, volumeincrease, symmetry as uniformity, predictionpricefrom, predictionpriceto, noise, exchange, gmttimefound, dftt.absolutetimezoneoffset as tzOs, dftt.timezone as tz, longname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN a.resultuid <= ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1) THEN 0 ELSE 1 END as relevant FROM symbols s INNER JOIN brokersymbollist b ON s.symbolid = b.symbolid INNER JOIN downloadersymbolsettings dss ON dss.symbolid = s.symbolid INNER JOIN datafeedstimetable dftt ON dftt.classname = dss.classname INNER JOIN autochartist_results a ON a.symbolid = s.symbolid INNER JOIN Patterns p ON a.pattern = p.patternname LEFT OUTER JOIN relevance_autochartist_results rar ON rar.resultuid = a.resultuid WHERE b.brokerid = 125 AND (((s.symbol ilike '%audusd%' AND timegranularity = 30); Date: 2023-12-14 06:02:45 Duration: 0ms Database: acaweb_fx User: postgres Remote: 192.168.0.42 Application: PostgreSQL JDBC Driver
5	4	287.91 MiB	71.94 MiB	72.01 MiB	71.98 MiB	select updateageforrelevantresults (); select updateageforrelevantresults (); Date: 2023-12-14 06:47:27 Duration: 24s307ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateageforrelevantresults (); Date: 2023-12-14 06:32:25 Duration: 22s652ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select updateageforrelevantresults (); Date: 2023-12-14 06:17:17 Duration: 15s82ms Database: acaweb_fx User: postgres Remote: [local] Application: psql
6	3	8.22 MiB	2.04 MiB	3.22 MiB	2.74 MiB	select fixcandlegaps (?, false); select fixcandlegaps ('LEGACYFXMT5', false); Date: 2023-12-14 06:06:09 Duration: 5s366ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select fixcandlegaps ('GKFXPRIME', false); Date: 2023-12-14 06:06:24 Duration: 3s804ms Database: acaweb_fx User: postgres Remote: [local] Application: psql select fixcandlegaps ('ATFX', false); Date: 2023-12-14 06:06:16 Duration: 3s702ms Database: acaweb_fx User: postgres Remote: [local] Application: psql

Queries generating the largest temporary files

Rank	Size	Query
1	76.09 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2023-12-14 06:30:07 ]
2	72.01 MiB	select updateageforrelevantresults (); [ Date: 2023-12-14 06:17:09 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
3	72.00 MiB	select updateageforrelevantresults (); [ Date: 2023-12-14 06:47:18 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
4	71.96 MiB	select updateageforrelevantresults (); [ Date: 2023-12-14 06:32:16 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
5	71.94 MiB	select updateageforrelevantresults (); [ Date: 2023-12-14 06:02:05 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
6	70.91 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2023-12-14 06:50:04 ]
7	61.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-12-14 06:20:05 ]
8	52.51 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-12-14 06:40:06 ]
9	51.17 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-12-14 06:40:06 ]
10	50.60 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-12-14 06:00:05 ]
11	47.33 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2023-12-14 06:20:06 ]
12	45.96 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-12-14 06:50:04 ]
13	45.05 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2023-12-14 06:00:03 ]
14	43.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-12-14 06:10:04 ]
15	42.52 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2023-12-14 06:10:03 ]
16	38.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-12-14 06:10:05 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.25 - Application: [unknown] ]
17	38.51 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-12-14 06:30:09 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.25 - Application: [unknown] ]
18	36.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-12-14 06:00:04 ]
19	36.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-12-14 06:20:06 ]
20	29.63 MiB	with rankedmt4 as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select from rankedmt4 where r = 1 ), ok_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = 'OK' ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = 1) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, '1900-01-01'::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select , row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> '' ), broker as ( select , row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = 1) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = 1 where (ok.r is null or ok.r = 1) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = 'OK') and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > 60 60 and last.eventtimestamp > current_timestamp - interval '1 day' and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval '10 hours') and last.eventtimestamp > current_timestamp - interval '1 hour' and broker.r = 1; [ Date: 2023-12-14 06:40:07 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.25 - Application: [unknown] ]

Vacuums / Analyzes Distribution

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date
0 sec Highest CPU-cost analyze
Table
Database
Date

Analyzes per table

Key values

public.solr_relevance_old (13) Main table analyzed (database acaweb_fx)
58 analyzes Total

Chart
Table

Table	Number of analyzes
acaweb_fx.public.solr_relevance_old	13
acaweb_fx.pg_catalog.pg_attribute	6
acaweb_fx.public.datafeeds_latestrun	4
acaweb_fx.pg_catalog.pg_class	4
acaweb_fx.public.relevance_fibonacci_results	4
acaweb_fx.pg_catalog.pg_type	4
acaweb_fx.public.relevance_bigmovement_results	4
acaweb_fx.public.relevance_keylevels_results	3
acaweb_fx.public.relevance_consecutivecandles_results	3
acaweb_fx.public.relevance_autochartist_results	3
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	2
acaweb_fx.pg_catalog.pg_index	1
acaweb_fx.public.symbollatestupdatetime	1
Total	58

Vacuums per table

Key values

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

Chart
Table

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
acaweb_fx.public.solr_relevance_old	13	13	13,328	0	54	0	0	10,256	1,073	5,606,390
acaweb_fx.public.datafeeds_latestrun	5	0	535	0	17	0	0	76	42	81,318
acaweb_fx.public.relevance_bigmovement_results	4	2	874	0	38	0	0	222	76	340,180
acaweb_fx.pg_toast.pg_toast_2619	2	2	298	0	57	0	0	170	46	195,784
acaweb_fx.pg_catalog.pg_type	2	2	274	0	48	0	0	105	35	219,219
acaweb_fx.pg_catalog.pg_attribute	2	2	1,607	0	363	0	128	742	294	1,742,450
acaweb_fx.public.latest_t15_candle_view	2	2	154	0	5	0	0	12	2	18,050
acaweb_fx.public.relevance_keylevels_results	2	2	7,330	0	514	4	86	1,541	512	1,380,966
acaweb_fx.public.relevance_autochartist_results	2	2	6,721	0	375	2	420	1,129	320	938,742
acaweb_fx.pg_catalog.pg_class	2	2	748	0	75	0	78	235	73	320,218
acaweb_fx.public.relevance_fibonacci_results	2	2	2,395	0	51	1	98	262	32	56,467
acaweb_fx.pg_catalog.pg_index	1	1	98	0	10	0	0	36	11	83,473
acaweb_fx.public.autochartist_symbolupdates	1	1	6,006	0	441	4	9,933	2,915	411	462,024
acaweb_fx.pg_catalog.pg_statistic	1	1	866	0	272	0	648	550	235	883,858
Total	41	34	41,234	26,227	2,320	11	11,391	18,251	3,162	12,329,139

Tuples removed per table

Key values

public.solr_relevance_old (94056) Main table with removed tuples on database acaweb_fx
105005 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	94,056	100,053	0	0	3,347
acaweb_fx.public.autochartist_symbolupdates	1	1	3,407	45,792	250	0	11,334
acaweb_fx.pg_catalog.pg_attribute	2	2	2,602	18,613	137	0	484
acaweb_fx.public.relevance_bigmovement_results	4	2	1,009	11,473	1,838	0	212
acaweb_fx.public.relevance_keylevels_results	2	2	930	24,434	1,068	0	596
acaweb_fx.pg_catalog.pg_statistic	1	1	804	4,168	0	0	1,194
acaweb_fx.public.relevance_autochartist_results	2	2	678	18,075	605	0	760
acaweb_fx.pg_catalog.pg_class	2	2	472	4,101	145	0	300
acaweb_fx.public.datafeeds_latestrun	5	0	277	170	70	0	90
acaweb_fx.public.relevance_fibonacci_results	2	2	271	2,776	153	0	204
acaweb_fx.pg_catalog.pg_type	2	2	183	2,670	94	2	71
acaweb_fx.public.latest_t15_candle_view	2	2	127	38	0	0	2
acaweb_fx.pg_toast.pg_toast_2619	2	2	124	366	32	0	104
acaweb_fx.pg_catalog.pg_index	1	1	65	806	0	1	22
Total	41	34	105,005	233,535	4,392	3	18,720

Pages removed per table

Key values

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

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
acaweb_fx.pg_catalog.pg_type	2	2	183	2
acaweb_fx.pg_catalog.pg_index	1	1	65	1
acaweb_fx.pg_toast.pg_toast_2619	2	2	124	0
acaweb_fx.public.datafeeds_latestrun	5	0	277	0
acaweb_fx.public.autochartist_symbolupdates	1	1	3407	0
acaweb_fx.pg_catalog.pg_statistic	1	1	804	0
acaweb_fx.pg_catalog.pg_attribute	2	2	2602	0
acaweb_fx.public.relevance_bigmovement_results	4	2	1009	0
acaweb_fx.public.latest_t15_candle_view	2	2	127	0
acaweb_fx.public.relevance_keylevels_results	2	2	930	0
acaweb_fx.public.relevance_autochartist_results	2	2	678	0
acaweb_fx.pg_catalog.pg_class	2	2	472	0
acaweb_fx.public.solr_relevance_old	13	13	94056	0
acaweb_fx.public.relevance_fibonacci_results	2	2	271	0
Total	41	34	105,005	3

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Dec 14	06	41	58

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

AccessShareLock Main Lock Type
12 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
AccessExclusiveLock		2	16m54s	8m27s
	relation	2	16m54s	8m27s
AccessShareLock		10	20m39s	2m3s
	relation	10	20m39s	2m3s
	Total	12	37m33s	3m7s

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	8	18m38s	2m10s	2m31s	2m19s	select datetimeupdate from latest_candle_datetime_per_receng where recognitionengine ilike ?; SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ADSSECURITIES - 1'; Date: 2023-12-14 06:19:34 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: [unknown] SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'LEADERCAPITAL2 - 1'; Date: 2023-12-14 06:19:34 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: [unknown] SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'BDSWISS - 1'; Date: 2023-12-14 06:19:34 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: [unknown]
2	1	14m22s	14m22s	14m22s	14m22s	truncate table solr_relevance_old; TRUNCATE TABLE solr_relevance_old; Date: 2023-12-14 06:19:33 Database: acaweb_fx User: postgres Remote: [local] Application: psql TRUNCATE TABLE solr_relevance_old; Date: 2023-12-14 06:26:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql TRUNCATE TABLE solr_relevance_old; Date: 2023-12-14 06:31:11 Database: acaweb_fx User: postgres Remote: [local] Application: psql
3	1	2m32s	2m32s	2m32s	2m32s	refresh materialized view latest_candle_datetime_per_receng; refresh materialized view latest_candle_datetime_per_receng; Date: 2023-12-14 06:19:34 Database: acaweb_fx User: postgres Remote: [local] Application: psql refresh materialized view latest_candle_datetime_per_receng; Date: 2023-12-14 06:32:02 Database: acaweb_fx User: postgres Remote: [local] Application: psql refresh materialized view latest_candle_datetime_per_receng; Date: 2023-12-14 06:02:02 Database: acaweb_fx User: postgres Remote: [local] Application: psql
4	2	2m	45s407ms	1m15s	1m	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-12-14 06:19:34 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-12-14 06:19:34 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-12-14 06:56:38 Database: acaweb_fx User: postgres Remote: 127.0.0.1 Application: PostgreSQL JDBC Driver Bind query: yes

Queries that waited the most


[ Date: 2023-12-14 06:19:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2023-12-14 06:19:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: PostgreSQL JDBC Driver ]
[ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: PostgreSQL JDBC Driver ]

Rank	Wait time	Query
1	14m22s	TRUNCATE TABLE solr_relevance_old; [ Date: 2023-12-14 06:19:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	2m32s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2023-12-14 06:19:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
3	2m31s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ADSSECURITIES - 1'; [ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
4	2m26s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'LEADERCAPITAL2 - 1'; [ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
5	2m20s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'BDSWISS - 1'; [ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
6	2m18s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'XM - 1'; [ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
7	2m18s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'LEADERCAPITAL2 - 2'; [ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
8	2m18s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'XM - 2'; [ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
9	2m12s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'DKFX - 1'; [ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
10	2m10s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'GO_MARKETS - 1'; [ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
11	1m15s	select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng; [ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: PostgreSQL JDBC Driver ]
12	45s407ms	select recognitionengine, to_char(datetimeupdate, 'yyyy-mm-dd HH24:MI') from latest_candle_datetime_per_receng; [ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: PostgreSQL JDBC Driver ]

Queries by type

Key values

80,081 Total read queries
27,244 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	80,081	72.84%
INSERT	20,315	18.48%
UPDATE	1,601	1.46%
DELETE	13	0.01%
COPY FROM	78	0.07%
COPY TO	579	0.53%
CTE	4,029	3.66%
DDL	13	0.01%
TCL	616	0.56%
CURSOR	0	0.00%
OTHERS	2,623	2.39%

Queries by database

Key values

acaweb_fx Main database
105,950 Requests
3h7m52s (acaweb_fx)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
acaweb_fx	Total	105,950	3h7m52s
	copy from	78	6s780ms
	copy to	303	14m34s
	cte	4,026	2h11m14s
	ddl	13	14m22s
	delete	13	18ms
	insert	20,315	19s495ms
	others	2,320	2m49s
	select	76,668	24m4s
	tcl	613	143ms
	update	1,601	20s171ms
acaweb_fx_integer	Total	3,584	19m18s
	copy to	276	19m17s
	cte	1	4ms
	others	285	15ms
	select	3,021	972ms
	tcl	1	0ms
postgres	Total	367	172ms
	cte	1	1ms
	others	9	0ms
	select	356	171ms
	tcl	1	0ms
translations	Total	47	121ms
	cte	1	1ms
	others	9	0ms
	select	36	119ms
	tcl	1	0ms

Queries by user

Key values

postgres Main user
109,948 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	109,948	3h27m11s
	copy from	78	6s780ms
	copy to	579	33m52s
	cte	4,029	2h11m14s
	ddl	13	14m22s
	delete	13	18ms
	insert	20,315	19s495ms
	others	2,623	2m49s
	select	80,081	24m5s
	tcl	616	143ms
	update	1,601	20s171ms

Duration by user

Key values

3h27m11s (postgres) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	109,948	3h27m11s
	copy from	78	6s780ms
	copy to	579	33m52s
	cte	4,029	2h11m14s
	ddl	13	14m22s
	delete	13	18ms
	insert	20,315	19s495ms
	others	2,623	2m49s
	select	80,081	24m5s
	tcl	616	143ms
	update	1,601	20s171ms

Queries by host

Key values

192.168.1.145 Main host
24,824 Requests
53m8s (127.0.0.1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
127.0.0.1	Total	16,823	53m8s
	copy to	579	33m52s
	cte	24	225ms
	insert	6,386	7s159ms
	others	619	19ms
	select	8,067	19m7s
	tcl	4	0ms
	update	1,144	617ms
172.10.1.90	Total	48	99ms
	others	24	2ms
	select	20	19ms
	update	4	77ms
182.165.1.42	Total	1,155	7m10s
	cte	155	7m6s
	others	43	0ms
	select	957	4s535ms
192.168.0.216	Total	508	324ms
	others	254	18ms
	select	246	214ms
	update	8	91ms
192.168.0.23	Total	108	343ms
	select	108	343ms
192.168.0.236	Total	30	16ms
	cte	3	0ms
	select	27	15ms
192.168.0.239	Total	147	1s158ms
	select	147	1s158ms
192.168.0.42	Total	4,059	19s518ms
	cte	7	22ms
	insert	67	20ms
	others	108	1ms
	select	3,877	19s474ms
192.168.1.135	Total	140	741ms
	cte	11	556ms
	select	129	185ms
192.168.1.145	Total	24,824	37m4s
	cte	921	36m28s
	others	210	2ms
	select	23,693	35s291ms
192.168.1.20	Total	24,364	37m13s
	cte	922	36m38s
	others	256	2ms
	select	23,186	34s105ms
192.168.1.201	Total	995	3s793ms
	select	995	3s793ms
192.168.1.210	Total	6	2ms
	select	6	2ms
192.168.1.23	Total	10,994	53s628ms
	cte	4	36ms
	others	136	1ms
	select	10,854	53s591ms
192.168.1.231	Total	40	0ms
	others	40	0ms
192.168.1.239	Total	216	103ms
	others	108	7ms
	select	108	96ms
192.168.1.25	Total	68	30s942ms
	cte	6	30s899ms
	others	8	0ms
	select	54	42ms
192.168.1.250	Total	8,389	49m53s
	cte	1,879	49m46s
	others	462	4ms
	select	6,048	7s38ms
192.168.1.93	Total	2	0ms
	select	2	0ms
192.168.1.97	Total	20	11ms
	cte	2	0ms
	select	18	11ms
192.168.2.126	Total	89	72ms
	others	18	0ms
	select	71	72ms
192.168.2.182	Total	48	281ms
	others	24	2ms
	select	12	9ms
	update	12	270ms
192.168.2.205	Total	142	158ms
	insert	89	14ms
	others	26	2ms
	select	23	33ms
	update	4	108ms
192.168.2.82	Total	407	1s88ms
	insert	125	317ms
	others	96	9ms
	select	123	88ms
	update	63	673ms
192.168.3.199	Total	252	244ms
	others	126	9ms
	select	114	104ms
	update	12	129ms
192.168.4.142	Total	14,790	13s19ms
	insert	13,648	11s983ms
	select	1,142	1s36ms
192.168.4.150	Total	22	1s826ms
	others	21	0ms
	select	1	1s826ms
192.168.4.238	Total	48	2s254ms
	cte	16	2s253ms
	others	32	0ms
192.168.4.30	Total	3	30ms
	cte	1	30ms
	others	2	0ms
192.168.4.98	Total	924	17s158ms
	others	6	16s410ms
	select	6	20ms
	tcl	612	143ms
	update	300	583ms
[local]	Total	287	20m14s
	copy from	78	6s780ms
	cte	78	40s245ms
	ddl	13	14m22s
	delete	13	18ms
	others	4	2m33s
	select	47	2m14s
	update	54	17s619ms

Queries by application

Key values

PostgreSQL JDBC Driver Main application
73,546 Requests
2h5m33s (PostgreSQL JDBC Driver)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
PostgreSQL JDBC Driver	Total	73,546	2h5m33s
	cte	3,761	2h2m57s
	insert	67	20ms
	others	644	7ms
	select	69,074	2m36s
[unknown]	Total	28,368	27m27s
	cte	166	7m37s
	insert	20,248	19s475ms
	others	1,386	16s468ms
	select	4,422	19m11s
	tcl	612	143ms
	update	1,534	2s529ms
pg_dump	Total	7,634	33m40s
	copy to	553	33m38s
	cte	4	10ms
	others	589	18ms
	select	6,484	1s965ms
	tcl	4	0ms
psql	Total	400	20m29s
	copy from	78	6s780ms
	copy to	26	14s468ms
	cte	98	40s460ms
	ddl	13	14m22s
	delete	13	18ms
	others	4	2m33s
	select	101	2m14s
	update	67	17s641ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2023-12-14 06:09:08 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

67,782 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	67,782	61.65%
1-5ms	33,971	30.90%
5-10ms	2,887	2.63%
10-25ms	1,310	1.19%
25-50ms	867	0.79%
50-100ms	502	0.46%
100-500ms	929	0.84%
500-1000ms	279	0.25%
1000-10000ms	1,221	1.11%
> 10000ms	200	0.18%

Slowest individual queries


[ Date: 2023-12-14 06:19:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2023-12-14 06:07:56 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2023-12-14 06:32:10 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2023-12-14 06:14:00 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
[ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-12-14 06:21:53 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
[ Date: 2023-12-14 06:36:32 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2023-12-14 06:24:56 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2023-12-14 06:17:40 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2023-12-14 06:23:15 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2023-12-14 06:11:16 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
[ Date: 2023-12-14 06:28:14 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]

Rank	Duration	Query
1	14m22s	TRUNCATE TABLE solr_relevance_old; [ Date: 2023-12-14 06:19:33 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
2	2m53s	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-12-14 06:07:56 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
3	2m44s	COPY public.researchreports (researchreportid, type, createddatetime, language, filename, xml) TO stdout; [ Date: 2023-12-14 06:32:10 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
4	2m40s	COPY public.researchreports (researchreportid, type, createddatetime, language, filename, xml) TO stdout; [ Date: 2023-12-14 06:14:00 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
5	2m32s	refresh materialized view latest_candle_datetime_per_receng; [ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]
6	2m31s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'ADSSECURITIES - 1'; [ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
7	2m26s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'LEADERCAPITAL2 - 1'; [ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
8	2m20s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'BDSWISS - 1'; [ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
9	2m18s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'XM - 1'; [ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
10	2m18s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'LEADERCAPITAL2 - 2'; [ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
11	2m18s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'XM - 2'; [ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
12	2m18s	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-12-14 06:21:53 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
13	2m12s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'DKFX - 1'; [ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
14	2m10s	SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'GO_MARKETS - 1'; [ Date: 2023-12-14 06:19:34 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]
15	1m59s	COPY public.t15_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2023-12-14 06:36:32 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
16	1m40s	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-12-14 06:24:56 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
17	1m17s	COPY public.t15_ps (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten) TO stdout; [ Date: 2023-12-14 06:17:40 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
18	1m14s	COPY public.authenticationlog (attemptid, username, password, brokerid, authclass, attemptdatetime, success, fingerprint, accounttype) TO stdout; [ Date: 2023-12-14 06:23:15 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
19	1m14s	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-12-14 06:11:16 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]
20	1m10s	COPY public.powerstats_trumpet (symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) TO stdout; [ Date: 2023-12-14 06:28:14 - Database: acaweb_fx_integer - User: postgres - Remote: 127.0.0.1 - Application: pg_dump ]

Time consuming queries


[ User: postgres - Total duration: 53m14s - Times executed: 464 ]
[ User: postgres - Total duration: 49m58s - Times executed: 465 ]
[ User: postgres - Total duration: 18m39s - Times executed: 920 ]
[ User: postgres - Total duration: 15m11s - Times executed: 465 ]
[ User: postgres - Total duration: 14m22s - Times executed: 13 ]
[ User: postgres - Total duration: 5m24s - Times executed: 2 ]
[ User: postgres - Total duration: 5m12s - Times executed: 2 ]
[ User: postgres - Total duration: 3m34s - Times executed: 12 ]
[ User: postgres - Total duration: 3m20s - Times executed: 12 ]
[ User: postgres - Total duration: 3m17s - Times executed: 2 ]
[ User: postgres - Total duration: 2m33s - Times executed: 4 ]
[ User: postgres - Total duration: 2m21s - Times executed: 2 ]
[ User: postgres - Total duration: 2m4s - Times executed: 2 ]
[ User: postgres - Total duration: 2m4s - Times executed: 312 ]
[ User: postgres - Total duration: 1m54s - Times executed: 2 ]
[ User: postgres - Total duration: 1m47s - Times executed: 2 ]
[ User: postgres - Total duration: 1m46s - Times executed: 2 ]
[ User: postgres - Total duration: 1m36s - Times executed: 224 ]
[ User: postgres - Total duration: 1m35s - Times executed: 2 ]
[ User: postgres - Total duration: 1m14s - Times executed: 2 ]

Most frequent queries (N)


[ User: postgres - Total duration: 126ms - Times executed: 30174 ]
[ User: postgres - Total duration: 22s237ms - Times executed: 15753 ]
[ User: postgres - Total duration: 44s79ms - Times executed: 13766 ]
[ User: postgres - Total duration: 8s550ms - Times executed: 7188 ]
[ User: postgres - Total duration: 2s440ms - Times executed: 4199 ]
[ User: postgres - Total duration: 3s728ms - Times executed: 2872 ]
[ User: postgres - Total duration: 1s124ms - Times executed: 2236 ]
[ User: postgres - Total duration: 892ms - Times executed: 2133 ]
[ User: postgres - Total duration: 22ms - Times executed: 1512 ]
[ User: postgres - Total duration: 595ms - Times executed: 1131 ]
[ User: postgres - Total duration: 18m39s - Times executed: 920 ]
[ User: postgres - Total duration: 99ms - Times executed: 854 ]
[ User: postgres - Total duration: 28s505ms - Times executed: 768 ]
[ User: postgres - Total duration: 4s430ms - Times executed: 744 ]
[ User: postgres - Total duration: 1s550ms - Times executed: 723 ]
[ User: postgres - Total duration: 6ms - Times executed: 712 ]
[ User: postgres - Total duration: 835ms - Times executed: 689 ]
[ User: postgres - Total duration: 2s556ms - Times executed: 686 ]
[ User: postgres - Total duration: 211ms - Times executed: 679 ]
[ User: postgres - Total duration: 438ms - Times executed: 651 ]

Normalized slowest queries (N)


[ User: postgres - Total duration: 5m24s - Times executed: 2 ]
[ User: postgres - Total duration: 5m12s - Times executed: 2 ]
[ User: postgres - Total duration: 3m17s - Times executed: 2 ]
[ User: postgres - Total duration: 2m21s - Times executed: 2 ]
[ User: postgres - Total duration: 14m22s - Times executed: 13 ]
[ User: postgres - Total duration: 2m4s - Times executed: 2 ]
[ User: postgres - Total duration: 1m54s - Times executed: 2 ]
[ User: postgres - Total duration: 1m47s - Times executed: 2 ]
[ User: postgres - Total duration: 1m46s - Times executed: 2 ]
[ User: postgres - Total duration: 1m35s - Times executed: 2 ]
[ User: postgres - Total duration: 2m33s - Times executed: 4 ]
[ User: postgres - Total duration: 1m14s - Times executed: 2 ]
[ User: postgres - Total duration: 3m34s - Times executed: 12 ]
[ User: postgres - Total duration: 3m20s - Times executed: 12 ]
[ User: postgres - Total duration: 53m14s - Times executed: 464 ]
[ User: postgres - Total duration: 49m58s - Times executed: 465 ]
[ User: postgres - Total duration: 15m11s - Times executed: 465 ]
[ User: postgres - Total duration: 18m39s - Times executed: 920 ]
[ User: postgres - Total duration: 1m36s - Times executed: 224 ]
[ User: postgres - Total duration: 2m4s - Times executed: 312 ]

Time consuming prepare


[ User: postgres - Total duration: 0ms - Times executed: 10 ]
[ User: postgres - Total duration: 1h48m58s - Times executed: 2891 ]
[ User: postgres - Total duration: 12s745ms - Times executed: 3309 ]
[ User: postgres - Total duration: 5s736ms - Times executed: 2488 ]
[ User: postgres - Total duration: 900ms - Times executed: 505 ]
[ User: postgres - Total duration: 2s440ms - Times executed: 4199 ]
[ User: postgres - Total duration: 892ms - Times executed: 2133 ]
[ User: postgres - Total duration: 2s253ms - Times executed: 16 ]
[ User: postgres - Total duration: 6ms - Times executed: 712 ]
[ User: postgres - Total duration: 8ms - Times executed: 1715 ]
[ User: postgres - Total duration: 2s426ms - Times executed: 106 ]
[ User: postgres - Total duration: 29s126ms - Times executed: 60 ]
[ User: postgres - Total duration: 36ms - Times executed: 18 ]
[ User: postgres - Total duration: 941ms - Times executed: 48 ]
[ User: postgres - Total duration: 51ms - Times executed: 38 ]
[ User: postgres - Total duration: 28ms - Times executed: 15 ]
[ User: postgres - Total duration: 64ms - Times executed: 34 ]
[ User: postgres - Total duration: 381ms - Times executed: 18 ]
[ User: postgres - Total duration: 40ms - Times executed: 60 ]
[ User: postgres - Total duration: 108ms - Times executed: 60 ]

Time consuming bind


[ User: postgres - Total duration: 2h8m6s - Times executed: 3600 ]
[ User: postgres - Total duration: 1m18s - Times executed: 32366 ]
[ User: postgres - Total duration: 2s253ms - Times executed: 16 ]
[ User: postgres - Total duration: 1m35s - Times executed: 223 ]
[ User: postgres - Total duration: 900ms - Times executed: 505 ]
[ User: postgres - Total duration: 51ms - Times executed: 38 ]
[ User: postgres - Total duration: 2s552ms - Times executed: 116 ]
[ User: postgres - Total duration: 48ms - Times executed: 38 ]
[ User: postgres - Total duration: 8s550ms - Times executed: 7188 ]
[ User: postgres - Total duration: 3s153ms - Times executed: 48 ]
[ User: postgres - Total duration: 21ms - Times executed: 30 ]
[ User: postgres - Total duration: 115ms - Times executed: 30025 ]
[ User: postgres - Total duration: 127ms - Times executed: 30 ]
[ User: postgres - Total duration: 7ms - Times executed: 30 ]
[ User: postgres - Total duration: 215ms - Times executed: 30 ]
[ User: postgres - Total duration: 29ms - Times executed: 30 ]
[ User: postgres - Total duration: 112ms - Times executed: 30 ]
[ User: postgres - Total duration: 421ms - Times executed: 30 ]
[ User: postgres - Total duration: 2s27ms - Times executed: 30 ]
[ User: postgres - Total duration: 3s359ms - Times executed: 30 ]

Log levels

Key values

345,777 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	254	0.07%
DETAIL	109,392	31.64%
ERROR	13	0.00%
LOG	235,728	68.17%
STATEMENT	390	0.11%

Events distribution

Key values

0 PANIC entries
0 FATAL entries
19 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

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

Rank

Times reported

Error

1

15

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Dec 14	06	15

LOG: process 7203 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.053 ms at character 28
LOG: process 6020 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.051 ms at character 28
LOG: process 6007 still waiting for AccessShareLock on relation 5894441 of database 5881926 after 1000.041 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
Dec 14	06	3

LOG: process 25534 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 1000.042 ms
LOG: process 25534 still waiting for AccessExclusiveLock on relation 5883477 of database 5881926 after 51930.975 ms
LOG: process 27116 still waiting for AccessExclusiveLock on relation 5894441 of database 5881926 after 1000.050 ms

3

1

Details

ERROR: relation "..." does not exist

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Dec 14	06	1

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

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Number of temporary files

Key values

Temporary Files Activity

Queries generating the most temporary files (N)

Queries generating the largest temporary files

Vacuums

Vacuums / Analyzes Distribution

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

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