pgBadger :: PostgreSQL Log Analyzer

Global information
- Generated on Thu May 26 21:46:48 2022
- Log file: /var/log/postgresql/postgresql-13-main.log.1, ..., /var/log/postgresql/postgresql-13-main.log
- Parsed 249,328 log entries in 13s
- Log start from 2022-05-25 15:01:23 to 2022-05-26 21:46:24

Global Stats

21 Number of unique normalized queries
5,728 Number of queries
18h29m50s Total query duration
2022-05-25 15:40:07 First query
2022-05-26 21:43:35 Last query
10 queries/s at 2022-05-25 15:40:47 Query peak

18h29m50s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
18h29m50s Execute total duration

29,007 Number of events
12 Number of unique normalized events
23,283 Max number of times the same event was reported
0 Number of cancellation

1,676 Total number of automatic vacuums
3,994 Total number of automatic analyzes

5 Number temporary file
5.52 MiB Max size of temporary file
5.52 MiB Average size of temporary file

0 Total number of sessions
0 sessions at Session peak
0ms Total duration of sessions
0ms Average duration of sessions
5,728 Average queries per session
18h29m50s Average queries duration per session

0 Total number of connections
2 Total number of databases

SQL Traffic

Key values

10 queries/s Query Peak
2022-05-25 15:40:47 Date

SELECT Traffic

Key values

1 queries/s Query Peak
2022-05-26 02:28:54 Date

INSERT/UPDATE/DELETE Traffic

Key values

10 queries/s Query Peak
2022-05-25 15:40:47 Date

Queries duration

Key values

18h29m50s Total query duration

Prepared queries ratio

Key values

0.00 Ratio of bind vs prepare
0.00 % Ratio between prepared and "usual" statements

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
May 25	15	119	0ms	19s786ms	7s574ms	40s293ms	5m41s	6m14s
	16	231	0ms	16s406ms	6s317ms	1m21s	1m55s	3m47s
	17	181	0ms	22s606ms	6s278ms	58s746ms	1m11s	4m
	18	218	0ms	14s907ms	5s891ms	1m14s	1m30s	1m46s
	19	126	0ms	11s359ms	5s606ms	48s943ms	1m18s	1m29s
	20	34	0ms	8s449ms	5s157ms	13s206ms	21s716ms	40s73ms
	21	82	0ms	12s893ms	6s33ms	31s264ms	1m9s	1m37s
	22	78	0ms	11s168ms	5s922ms	20s504ms	38s264ms	2m31s
	23	42	0ms	11s739ms	5s726ms	15s996ms	32s912ms	51s469ms
May 26	00	202	0ms	2m33s	23s878ms	1m18s	10m40s	42m4s
	01	37	0ms	35s74ms	12s952ms	4s115ms	21s961ms	5m52s
	02	934	0ms	6m55s	24s678ms	19m14s	28m50s	31m31s
	03	374	0ms	1m55s	12s633ms	2m33s	5m43s	17m29s
	04	33	0ms	19s545ms	6s687ms	14s949ms	22s905ms	1m3s
	05	2	0ms	4s301ms	4s206ms	0ms	0ms	4s301ms
	06	18	0ms	13s727ms	5s995ms	5s311ms	18s559ms	33s328ms
	07	3	0ms	6s997ms	6s55ms	0ms	0ms	13s962ms
	08	155	0ms	12s306ms	6s300ms	49s287ms	1m1s	1m39s
	09	122	0ms	25s137ms	6s700ms	42s149ms	1m3s	1m56s
	10	283	0ms	22s586ms	7s59ms	1m24s	2m32s	5m44s
	11	803	0ms	1m34s	14s217ms	9m46s	19m13s	35m9s
	12	309	0ms	25s376ms	7s96ms	1m37s	2m33s	5m19s
	13	329	0ms	40s23ms	7s820ms	1m41s	5m9s	8m51s
	14	182	0ms	18s142ms	6s594ms	1m4s	1m25s	3m39s
	15	89	0ms	11s674ms	5s260ms	30s380ms	33s978ms	38s748ms
	16	125	0ms	18s838ms	6s375ms	40s81ms	57s861ms	3m27s
	17	114	0ms	24s412ms	6s956ms	39s112ms	52s513ms	3m30s
	18	209	0ms	11s926ms	5s826ms	1m8s	1m33s	1m49s
	19	86	0ms	11s949ms	6s492ms	41s730ms	1m6s	1m14s
	20	130	0ms	21s287ms	6s636ms	27s265ms	1m6s	4m48s
	21	78	0ms	10s600ms	5s469ms	33s559ms	37s72ms	41s58ms

Day	Hour	SELECT	COPY TO	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
May 25	15	1	0	6s246ms	0ms	0ms	6s246ms
	16	2	0	7s753ms	0ms	0ms	5s977ms
	17	0	0	0ms	0ms	0ms	0ms
	18	0	0	0ms	0ms	0ms	0ms
	19	0	0	0ms	0ms	0ms	0ms
	20	0	0	0ms	0ms	0ms	0ms
	21	0	0	0ms	0ms	0ms	0ms
	22	0	0	0ms	0ms	0ms	0ms
	23	0	0	0ms	0ms	0ms	0ms
May 26	00	0	0	0ms	0ms	0ms	0ms
	01	0	0	0ms	0ms	0ms	0ms
	02	3	7	41s502ms	0ms	0ms	55s345ms
	03	0	0	0ms	0ms	0ms	0ms
	04	0	0	0ms	0ms	0ms	0ms
	05	0	0	0ms	0ms	0ms	0ms
	06	0	0	0ms	0ms	0ms	0ms
	07	0	0	0ms	0ms	0ms	0ms
	08	0	0	0ms	0ms	0ms	0ms
	09	0	0	0ms	0ms	0ms	0ms
	10	0	0	0ms	0ms	0ms	0ms
	11	0	0	0ms	0ms	0ms	0ms
	12	0	0	0ms	0ms	0ms	0ms
	13	0	0	0ms	0ms	0ms	0ms
	14	0	0	0ms	0ms	0ms	0ms
	15	0	0	0ms	0ms	0ms	0ms
	16	0	0	0ms	0ms	0ms	0ms
	17	0	0	0ms	0ms	0ms	0ms
	18	0	0	0ms	0ms	0ms	0ms
	19	0	0	0ms	0ms	0ms	0ms
	20	0	0	0ms	0ms	0ms	0ms
	21	0	0	0ms	0ms	0ms	0ms

Day	Hour	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
May 25	15	118	0	7s585ms	4s728ms	18s103ms	5m41s
	16	229	0	6s304ms	10s126ms	47s215ms	1m55s
	17	181	0	6s278ms	5s562ms	33s14ms	1m11s
	18	218	0	5s891ms	17s827ms	49s730ms	1m30s
	19	126	0	5s606ms	4s934ms	17s870ms	1m18s
	20	34	0	5s157ms	0ms	4s567ms	21s716ms
	21	82	0	6s33ms	0ms	8s814ms	1m9s
	22	78	0	5s922ms	0ms	5s840ms	38s264ms
	23	42	0	5s726ms	0ms	4s969ms	32s912ms
May 26	00	202	0	23s878ms	0ms	4s104ms	10m40s
	01	36	1	12s952ms	0ms	0ms	35s74ms
	02	924	0	24s496ms	6m33s	9m19s	28m50s
	03	374	0	12s633ms	51s366ms	1m50s	5m43s
	04	33	0	6s687ms	0ms	4s572ms	22s905ms
	05	2	0	4s206ms	0ms	0ms	0ms
	06	18	0	5s995ms	0ms	0ms	18s559ms
	07	3	0	6s55ms	0ms	0ms	0ms
	08	155	0	6s300ms	13s46ms	33s889ms	1m1s
	09	122	0	6s700ms	8s947ms	22s121ms	1m3s
	10	283	0	7s59ms	24s81ms	51s526ms	2m32s
	11	803	0	14s217ms	1m9s	2m36s	19m13s
	12	309	0	7s96ms	22s227ms	58s330ms	2m33s
	13	329	0	7s820ms	22s306ms	42s733ms	5m9s
	14	182	0	6s594ms	9s938ms	38s959ms	1m25s
	15	89	0	5s260ms	4s730ms	17s763ms	33s978ms
	16	125	0	6s375ms	4s514ms	25s60ms	57s861ms
	17	114	0	6s956ms	4s682ms	23s105ms	52s513ms
	18	209	0	5s826ms	17s164ms	34s649ms	1m33s
	19	86	0	6s492ms	4s298ms	11s286ms	1m6s
	20	130	0	6s636ms	4s282ms	20s686ms	1m6s
	21	78	0	5s469ms	4s334ms	19s741ms	38s449ms

Day	Hour	Bind	Bind/Prepare	Percentage of prepare
May 25	15	119	119.00	0.00%
	16	231	231.00	0.00%
	17	181	181.00	0.00%
	18	218	218.00	0.00%
	19	126	126.00	0.00%
	20	34	34.00	0.00%
	21	82	82.00	0.00%
	22	78	78.00	0.00%
	23	42	42.00	0.00%
May 26	00	202	202.00	0.00%
	01	37	37.00	0.00%
	02	924	924.00	0.00%
	03	374	374.00	0.00%
	04	33	33.00	0.00%
	05	2	2.00	0.00%
	06	18	18.00	0.00%
	07	3	3.00	0.00%
	08	155	155.00	0.00%
	09	122	122.00	0.00%
	10	283	283.00	0.00%
	11	803	803.00	0.00%
	12	309	309.00	0.00%
	13	329	329.00	0.00%
	14	182	182.00	0.00%
	15	89	89.00	0.00%
	16	125	125.00	0.00%
	17	114	114.00	0.00%
	18	209	209.00	0.00%
	19	86	86.00	0.00%
	20	130	130.00	0.00%
	21	78	78.00	0.00%

Day	Hour	Average / Second
May 25	15	0.00/s
	16	0.00/s
	17	0.00/s
	18	0.00/s
	19	0.00/s
	20	0.00/s
	21	0.00/s
	22	0.00/s
	23	0.00/s
May 26	00	0.00/s
	01	0.00/s
	02	0.00/s
	03	0.00/s
	04	0.00/s
	05	0.00/s
	06	0.00/s
	07	0.00/s
	08	0.00/s
	09	0.00/s
	10	0.00/s
	11	0.00/s
	12	0.00/s
	13	0.00/s
	14	0.00/s
	15	0.00/s
	16	0.00/s
	17	0.00/s
	18	0.00/s
	19	0.00/s
	20	0.00/s
	21	0.00/s

Day	Hour	Average Duration
May 25	15	0ms
	16	0ms
	17	0ms
	18	0ms
	19	0ms
	20	0ms
	21	0ms
	22	0ms
	23	0ms
May 26	00	0ms
	01	0ms
	02	0ms
	03	0ms
	04	0ms
	05	0ms
	06	0ms
	07	0ms
	08	0ms
	09	0ms
	10	0ms
	11	0ms
	12	0ms
	13	0ms
	14	0ms
	15	0ms
	16	0ms
	17	0ms
	18	0ms
	19	0ms
	20	0ms
	21	0ms

↑ Back to the top of the General Activity table

Connections
Established Connections
Key values
- 0 connections Connection Peak
- Date
Connections per database
Key values
- unknown Main Database
- 0 connections Total
- Chart
- Table
Connections per database

NO DATASET

Database User Count
Connections per user
Key values
- unknown Main User
- 0 connections Total
- Chart
- Table
Connections per user

NO DATASET

User Count
Connections per host
Key values
- unknown Main host with 0 connections
- 0 Total connections
- Chart
- Table
Connections per host

NO DATASET

Host Count
Sessions
Simultaneous sessions
Key values
- 0 sessions Session Peak
- Date
Histogram of session times
Key values
- duration
- Chart
- Table
NO DATASET

Range Count Percentage

NO DATASET
Sessions per database
Key values
- unknown Main Database
- 0 sessions Total
- Chart
- Table
Sessions per database

NO DATASET

Database User Count Total Duration Average Duration

NO DATASET
Sessions per user
Key values
- unknown Main User
- 0 sessions Total
- Chart
- Table
Sessions per user

NO DATASET

User Count Total Duration Average Duration

NO DATASET
Sessions per host
Key values
- unknown Main Host
- 0 sessions Total
- Chart
- Table
Connections per host

NO DATASET

Host Count Total Duration Average Duration

NO DATASET
Sessions per application
Key values
- unknown Main Host
- 0 sessions Total
- Chart
- Table
Sessions per application

NO DATASET

Application Count Total Duration Average Duration

NO DATASET

Range	Count	Percentage
NO DATASET

Database	User	Count	Total Duration	Average Duration
NO DATASET

User	Count	Total Duration	Average Duration
NO DATASET

Host	Count	Total Duration	Average Duration
NO DATASET

Application	Count	Total Duration	Average Duration
NO DATASET

Checkpoints Buffers

Key values

36,872 buffers Checkpoint Peak
2022-05-26 13:50:18 Date
291.433 seconds Highest write time
11.775 seconds Sync time

Checkpoints Wal files

Key values

14 files Wal files usage Peak
2022-05-26 13:50:18 Date

Checkpoints distance

Key values

473.54 Mo Distance Peak
2022-05-26 13:50:18 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
May 25	15	3,280	198.935s	5.03s	223.979s
	16	6,416	701.318s	7.38s	745.89s
	17	6,435	708.411s	11.175s	758.563s
	18	5,868	631.119s	7.534s	680.659s
	19	5,202	562.131s	7.978s	614.87s
	20	5,727	614.154s	5.68s	645.179s
	21	5,136	543.966s	6.013s	584.028s
	22	7,625	806.767s	8.171s	860.322s
	23	10,084	1,076.749s	7.534s	1,123.616s
May 26	00	9,699	1,119.733s	8.468s	1,189.11s
	01	7,491	819.47s	9.95s	898.896s
	02	8,186	1,156.948s	32.906s	1,427.459s
	03	6,913	949.258s	15.863s	1,103.124s
	04	10,600	1,009.684s	12.684s	1,111.675s
	05	7,739	833.555s	8.943s	907.758s
	06	6,810	747.395s	8.142s	807.367s
	07	7,758	816.181s	10.765s	898.079s
	08	8,206	906.391s	13.004s	994.166s
	09	9,369	1,057.809s	6.186s	1,114.544s
	10	18,000	1,513.475s	13.313s	1,611.803s
	11	12,501	1,439.719s	14.729s	1,559.362s
	12	9,626	1,045.665s	5.438s	1,109.031s
	13	61,281	1,405.061s	5.962s	1,485.183s
	14	10,566	1,135.19s	7.764s	1,181.866s
	15	12,468	1,094.656s	5.954s	1,144.759s
	16	11,258	1,180.84s	8.178s	1,257.905s
	17	14,010	1,350.947s	6.589s	1,403.172s
	18	12,434	1,313.03s	7.981s	1,376.155s
	19	11,342	1,212.161s	8.727s	1,263.863s
	20	13,496	1,183.118s	5.083s	1,233.485s
	21	8,671	915.754s	4.293s	957.008s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
May 25	15	3	292	2.078s	0.12s
	16	2	773	1.138s	0.131s
	17	3	797	2.690s	0.224s
	18	3	737	1.204s	0.131s
	19	2	653	1.746s	0.193s
	20	3	665	1.009s	0.123s
	21	2	561	1.023s	0.167s
	22	4	594	2.716s	0.287s
	23	5	889	1.099s	0.105s
May 26	00	4	705	1.797s	0.162s
	01	4	484	3.222s	0.389s
	02	3	660	11.775s	0.638s
	03	2	592	4.463s	0.344s
	04	4	630	1.918s	0.247s
	05	4	556	2.037s	0.21s
	06	3	563	2.838s	0.261s
	07	4	618	1.648s	0.212s
	08	3	895	2.179s	0.197s
	09	4	843	0.908s	0.092s
	10	7	1,002	2.894s	0.19s
	11	6	800	2.787s	0.244s
	12	4	826	0.900s	0.094s
	13	22	1,355	1.323s	0.085s
	14	5	1,060	1.591s	0.105s
	15	5	834	0.969s	0.099s
	16	6	901	1.651s	0.116s
	17	6	997	1.606s	0.094s
	18	5	964	1.401s	0.106s
	19	5	1,020	1.455s	0.106s
	20	6	958	1.243s	0.078s
	21	4	644	0.869s	0.067s

Day	Hour	Avg time (sec)
May 25	15	0s
	16	0s
	17	0s
	18	0s
	19	0s
	20	0s
	21	0s
	22	0s
	23	0s
May 26	00	0s
	01	0s
	02	0s
	03	0s
	04	0s
	05	0s
	06	0s
	07	0s
	08	0s
	09	0s
	10	0s
	11	0s
	12	0s
	13	0s
	14	0s
	15	0s
	16	0s
	17	0s
	18	0s
	19	0s
	20	0s
	21	0s

Day	Hour	Mean distance	Mean estimate
May 25	15	4,177.50 kB	5,025.67 kB
	16	3,912.33 kB	4,984.33 kB
	17	3,915.83 kB	5,568.17 kB
	18	3,657.42 kB	4,834.00 kB
	19	3,271.00 kB	4,372.75 kB
	20	3,503.17 kB	4,303.75 kB
	21	3,232.92 kB	3,843.08 kB
	22	4,930.75 kB	6,761.08 kB
	23	6,670.50 kB	8,652.75 kB
May 26	00	6,186.17 kB	10,770.83 kB
	01	4,932.42 kB	12,219.83 kB
	02	3,593.92 kB	7,303.83 kB
	03	3,663.08 kB	5,419.92 kB
	04	5,277.50 kB	10,119.50 kB
	05	5,084.92 kB	9,715.00 kB
	06	4,460.17 kB	6,580.33 kB
	07	4,853.33 kB	6,076.33 kB
	08	4,950.33 kB	5,752.17 kB
	09	5,898.09 kB	7,392.00 kB
	10	8,692.54 kB	20,596.46 kB
	11	7,856.50 kB	11,267.08 kB
	12	6,010.50 kB	8,055.00 kB
	13	30,111.83 kB	60,911.25 kB
	14	6,670.42 kB	111,894.83 kB
	15	6,809.25 kB	36,728.50 kB
	16	7,359.42 kB	15,261.75 kB
	17	8,361.58 kB	15,911.08 kB
	18	7,741.00 kB	10,712.08 kB
	19	6,948.00 kB	8,611.50 kB
	20	7,411.08 kB	16,251.50 kB
	21	7,260.22 kB	10,442.22 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (361) Main checkpoint cause
364 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	361
shutdown immediate	2
end-of-recovery immediate	1
Total	364

Day	Hour	Count	Total size	Average size
May 25	15	0	0	0
	16	0	0	0
	17	2	11.05 MiB	5.52 MiB
	18	0	0	0
	19	1	5.52 MiB	5.52 MiB
	20	0	0	0
	21	0	0	0
	22	0	0	0
	23	0	0	0
May 26	00	0	0	0
	01	0	0	0
	02	0	0	0
	03	0	0	0
	04	0	0	0
	05	0	0	0
	06	0	0	0
	07	0	0	0
	08	1	5.52 MiB	5.52 MiB
	09	0	0	0
	10	0	0	0
	11	1	5.52 MiB	5.52 MiB
	12	0	0	0
	13	0	0	0
	14	0	0	0
	15	0	0	0
	16	0	0	0
	17	0	0	0
	18	0	0	0
	19	0	0	0
	20	0	0	0
	21	0	0	0

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.oc_jobs (1772) Main table analyzed (database nextcloud)
3,994 analyzes Total

Chart
Table

Table	Number of analyzes
nextcloud.public.oc_jobs	1772
nextcloud.public.oc_authtoken	1047
nextcloud.public.oc_calendarsubscriptions	1006
nextcloud.public.oc_appconfig	105
nextcloud.public.oc_calendarobjects	16
nextcloud.public.oc_text_sessions	12
nextcloud.public.oc_calendarchanges	12
nextcloud.public.oc_calendarobjects_props	11
nextcloud.public.oc_text_documents	4
nextcloud.public.oc_preferences	3
nextcloud.public.oc_user_status	3
nextcloud.public.oc_bruteforce_attempts	2
nextcloud.public.oc_text_steps	1
Total	3,994

Vacuums per table

Key values

public.oc_jobs (449) Main table vacuumed on database nextcloud
1,676 vacuums Total

Chart
Table

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
nextcloud.public.oc_jobs	449	273	73,306	0	1,125	244	1,350	12,486	1,648	5,669,038
nextcloud.pg_toast.pg_toast_2619	361	361	104,992	0	9,939	0	42,347	64,298	9,580	20,395,141
nextcloud.public.oc_authtoken	167	167	269,651	0	16,745	0	66,812	82,737	18,171	90,821,686
nextcloud.public.oc_calendarsubscriptions	161	6	18,090	0	372	0	0	1,247	416	2,150,372
nextcloud.public.oc_appconfig	24	24	3,349	0	169	0	0	360	144	1,017,816
nextcloud.pg_catalog.pg_statistic	22	19	5,891	0	643	0	0	2,415	511	2,660,414
nextcloud.public.oc_text_sessions	10	10	839	0	47	0	0	90	30	216,298
nextcloud.public.oc_calendarobjects	4	4	82,213	0	15,112	0	14,055	33,380	14,996	57,751,015
nextcloud.public.oc_calendarchanges	3	3	23,856	0	5,389	0	1,125	11,927	5,263	31,703,671
nextcloud.public.oc_calendarobjects_props	3	3	28,719	0	5,006	0	1,677	10,594	4,933	23,926,632
nextcloud.public.oc_user_status	2	2	323	0	36	0	0	73	42	247,666
nextcloud.pg_toast.pg_toast_3596	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_16808	1	0	25	0	0	0	0	1	0	188
template0.pg_toast.pg_toast_3381	1	0	24	0	0	0	0	1	0	188
nextcloud.public.oc_calendar_resources_md	1	0	42	0	0	0	0	1	0	188
template0.pg_toast.pg_toast_2619	1	0	27	0	0	0	0	1	0	188
template0.pg_catalog.pg_statistic_ext_data	1	0	3	0	0	0	0	1	0	221
nextcloud.pg_toast.pg_toast_17087	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_17063	1	0	25	0	0	0	0	1	0	188
template0.pg_toast.pg_toast_2618	1	0	25	0	0	0	59	1	0	188
nextcloud.pg_toast.pg_toast_16953	1	0	25	0	0	0	0	1	0	188
template0.pg_toast.pg_toast_1247	1	0	23	0	0	0	0	1	0	188
nextcloud.pg_catalog.pg_init_privs	1	1	42	0	6	0	0	5	3	21,295
nextcloud.pg_toast.pg_toast_13300	1	0	25	0	0	0	0	1	0	188
template0.pg_toast.pg_toast_6000	1	0	24	0	0	0	0	1	0	188
nextcloud.public.oc_bruteforce_attempts	1	1	98	0	8	0	0	30	12	54,605
template0.pg_catalog.pg_policy	1	0	34	0	0	0	0	1	0	233
template1.pg_toast.pg_toast_2615	1	0	23	0	0	0	0	1	0	188
template0.pg_catalog.pg_statistic	1	0	35	0	1	0	0	1	1	697
template1.pg_catalog.pg_database	1	0	8	0	2	0	0	4	2	9,844
template0.pg_catalog.pg_replication_origin	1	0	5	0	0	0	0	1	0	233
template0.pg_catalog.pg_operator	1	0	24	0	0	0	0	1	0	233
template1.pg_catalog.pg_ts_template	1	0	8	0	0	0	0	1	0	233
template1.pg_catalog.pg_statistic_ext_data	1	0	3	0	0	0	0	1	0	221
nextcloud.public.oc_flow_operations	1	0	28	0	0	0	0	1	0	188
template0.pg_toast.pg_toast_1262	1	0	24	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_3456	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_catalog.pg_subscription	1	0	6	0	0	0	0	1	0	221
nextcloud.pg_toast.pg_toast_16540	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_17295	1	0	25	0	0	0	0	1	0	188
template1.pg_catalog.pg_attribute	1	0	9	0	0	0	52	1	0	233
nextcloud.public.oc_talk_commands	1	0	29	0	5	0	0	3	2	8,577
nextcloud.pg_toast.pg_toast_6000	1	0	26	0	0	0	0	1	0	188
template1.pg_catalog.pg_attrdef	1	0	39	0	0	0	0	1	0	233
template1.pg_toast.pg_toast_3350	1	0	23	0	1	0	0	1	1	8,177
template1.pg_catalog.pg_foreign_table	1	0	4	0	1	0	0	1	1	5,413
nextcloud.pg_catalog.pg_ts_config	1	0	9	0	0	0	0	1	0	233
template1.pg_toast.pg_toast_3118	1	0	24	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_3592	1	0	26	0	0	0	0	1	0	188
template0.pg_toast.pg_toast_3429	1	0	23	0	0	0	0	1	0	188
template1.pg_catalog.pg_type	1	0	42	0	1	0	0	1	1	697
nextcloud.pg_toast.pg_toast_17308	1	0	26	0	0	0	0	1	0	188
nextcloud.public.oc_user_transfer_owner	1	0	28	0	5	0	0	3	2	8,601
template0.pg_toast.pg_toast_826	1	0	23	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_17162	1	0	25	0	0	0	0	1	0	188
template0.pg_catalog.pg_enum	1	0	34	0	1	0	0	1	1	8,057
nextcloud.pg_catalog.pg_attrdef	1	0	79	0	34	0	0	61	31	253,034
template0.pg_toast.pg_toast_1260	1	0	24	0	0	0	0	1	0	188
nextcloud.public.oc_passwords_tag_rv	1	1	82	0	8	0	0	12	5	13,338
nextcloud.public.oc_known_users	1	0	51	0	0	0	0	1	0	188
nextcloud.pg_catalog.pg_amproc	1	0	28	0	0	0	0	1	0	233
template1.pg_toast.pg_toast_2396	1	0	24	0	0	0	0	1	0	188
nextcloud.public.oc_systemtag_group	1	0	28	0	0	0	0	1	0	188
template0.pg_catalog.pg_ts_config_map	1	0	7	0	0	0	0	1	0	233
nextcloud.public.oc_text_documents	1	1	43	0	5	0	0	8	2	16,589
template1.pg_toast.pg_toast_3466	1	0	23	0	0	0	0	1	0	188
nextcloud.public.oc_files_trash	1	1	6,434	0	3,795	0	0	8,393	3,745	23,777,939
template1.pg_catalog.pg_shdepend	1	1	56	0	8	0	0	9	5	34,591
nextcloud.public.oc_storages_credentials	1	0	54	0	0	0	0	1	0	188
nextcloud.pg_catalog.pg_largeobject_metadata	1	0	23	0	0	0	0	1	0	233
template1.pg_catalog.pg_replication_origin	1	0	3	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_16888	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_catalog.pg_publication	1	0	6	0	0	0	0	1	0	233
nextcloud.pg_catalog.pg_authid	1	0	13	0	1	0	0	1	1	7,685
nextcloud.pg_toast.pg_toast_17514	1	0	25	0	0	0	0	1	0	188
template1.pg_catalog.pg_range	1	0	6	0	0	0	0	1	0	233
nextcloud.pg_catalog.pg_constraint	1	0	79	0	7	0	0	7	4	29,882
nextcloud.public.oc_federated_reshares	1	0	31	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_17055	1	0	25	0	0	0	0	1	0	188
template0.pg_catalog.pg_language	1	0	5	0	0	0	0	1	0	233
template0.pg_toast.pg_toast_2396	1	0	25	0	0	0	0	1	0	188
template0.pg_toast.pg_toast_3600	1	0	23	0	0	0	0	1	0	188
template1.pg_toast.pg_toast_3596	1	0	23	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_17148	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_2964	1	0	26	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_17004	1	0	25	0	0	0	0	1	0	188
template0.pg_toast.pg_toast_2328	1	0	23	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_3429	1	0	25	0	0	0	0	1	0	188
template0.pg_toast.pg_toast_1418	1	0	24	0	0	0	0	1	0	188
template1.pg_catalog.pg_largeobject	1	0	28	0	1	0	0	1	1	7,125
template0.pg_catalog.pg_inherits	1	0	34	0	0	0	0	1	0	233
nextcloud.pg_catalog.pg_operator	1	0	48	0	0	0	0	1	0	233
template0.pg_catalog.pg_constraint	1	0	58	0	0	0	0	1	0	233
nextcloud.pg_catalog.pg_type	1	1	73	0	22	0	0	39	19	124,385
nextcloud.pg_toast.pg_toast_16450	1	0	25	0	0	0	0	1	0	188
template1.pg_catalog.pg_language	1	0	9	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_17195	1	0	25	0	0	0	0	1	0	188
template0.pg_catalog.pg_event_trigger	1	0	3	0	0	0	0	1	0	233
nextcloud.pg_catalog.pg_class	1	1	126	0	29	0	0	76	26	174,293
nextcloud.public.oc_oauth2_access_tokens	1	0	51	0	0	0	0	1	0	188
template1.pg_toast.pg_toast_1418	1	0	24	0	0	0	0	1	0	188
template1.pg_catalog.pg_operator	1	0	40	0	0	0	0	1	0	233
template0.pg_toast.pg_toast_2604	1	0	23	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_17344	1	0	25	0	0	0	0	1	0	188
nextcloud.public.oc_music_artists	1	1	63	0	10	0	0	17	7	37,476
nextcloud.pg_toast.pg_toast_13310	1	0	25	0	0	0	0	1	0	188
nextcloud.public.oc_directlink	1	1	80	0	8	0	0	13	5	9,674
nextcloud.information_schema.sql_features	1	0	18	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_3118	1	0	26	0	0	0	0	1	0	188
nextcloud.public.oc_oauth2_clients	1	0	39	0	0	0	0	1	0	188
template0.pg_toast.pg_toast_2606	1	0	23	0	0	0	0	1	0	188
nextcloud.public.oc_users	1	1	150	0	51	0	0	108	48	320,924
nextcloud.public.oc_addressbooks	1	1	190	0	44	0	0	81	41	261,290
template1.pg_catalog.pg_ts_dict	1	0	8	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_17016	1	0	25	0	0	0	0	1	0	188
nextcloud.public.oc_music_tracks	1	1	142	0	22	0	0	47	19	112,517
template1.pg_toast.pg_toast_2619	1	1	40	0	10	0	0	18	7	28,092
template1.information_schema.sql_parts	1	0	10	0	0	0	0	1	0	188
template0.pg_toast.pg_toast_3394	1	0	23	0	0	0	0	1	0	188
nextcloud.public.oc_passwords_password_rv	1	1	1,100	0	429	0	0	1,037	426	3,004,029
template0.pg_toast.pg_toast_13295	1	0	23	0	0	0	0	1	0	188
template1.pg_toast.pg_toast_1417	1	0	23	0	0	0	0	1	0	188
nextcloud.public.oc_activity	1	1	130,861	0	47,759	0	13,017	91,596	47,809	234,478,489
nextcloud.pg_toast.pg_toast_16686	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_2604	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_2328	1	0	25	0	0	0	0	1	0	188
template1.pg_toast.pg_toast_3256	1	0	24	0	0	0	0	1	0	188
template0.pg_toast.pg_toast_3256	1	0	24	0	0	0	0	1	0	188
template1.pg_catalog.pg_trigger	1	0	32	0	0	0	0	1	0	233
template1.pg_catalog.pg_statistic	1	0	72	0	1	0	0	1	1	697
template0.pg_catalog.pg_subscription_rel	1	0	3	0	0	0	0	1	0	233
template1.pg_catalog.pg_event_trigger	1	0	5	0	0	0	0	1	0	233
nextcloud.pg_catalog.pg_shdepend	1	0	57	0	0	0	0	1	0	233
template1.pg_catalog.pg_ts_config_map	1	0	7	0	0	0	0	1	0	233
template1.pg_catalog.pg_subscription_rel	1	0	3	0	0	0	0	1	0	233
nextcloud.pg_catalog.pg_database	1	0	13	0	0	0	0	1	0	233
nextcloud.public.oc_flow_operations_scope	1	0	48	0	0	0	0	1	0	188
template1.pg_toast.pg_toast_826	1	0	23	0	0	0	0	1	0	188
nextcloud.public.oc_share_external	1	1	75	0	8	0	0	12	5	18,228
template0.pg_catalog.pg_depend	1	0	45	0	0	0	56	1	0	233
nextcloud.pg_toast.pg_toast_3350	1	0	25	0	1	0	0	1	1	8,177
template0.pg_catalog.pg_statistic_ext	1	0	14	0	0	0	0	1	0	233
nextcloud.public.oc_passwords_tag	1	1	82	0	8	0	0	12	5	10,762
nextcloud.public.oc_passwords_challenge	1	0	84	0	5	0	0	3	2	14,141
template0.pg_catalog.pg_partitioned_table	1	0	3	0	0	0	0	1	0	233
nextcloud.public.oc_talk_participants	1	0	95	0	5	0	0	3	2	12,021
nextcloud.pg_catalog.pg_description	1	0	32	0	5	0	41	3	2	12,254
template0.pg_catalog.pg_namespace	1	0	7	0	0	0	0	1	0	233
template0.pg_catalog.pg_publication	1	0	3	0	0	0	0	1	0	233
template1.pg_toast.pg_toast_6100	1	0	23	0	0	0	0	1	0	188
nextcloud.pg_catalog.pg_subscription_rel	1	0	4	0	0	0	0	1	0	233
nextcloud.pg_catalog.pg_partitioned_table	1	0	5	0	0	0	0	1	0	233
template0.pg_toast.pg_toast_2620	1	0	23	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_17492	1	0	25	0	0	0	0	1	0	188
template1.pg_toast.pg_toast_1213	1	0	23	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_17579	1	0	25	0	0	0	0	1	0	188
template1.pg_toast.pg_toast_3592	1	0	23	0	0	0	0	1	0	188
nextcloud.public.oc_mimetypes	1	0	47	0	6	0	0	4	2	16,728
template1.pg_toast.pg_toast_2612	1	0	23	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_3381	1	0	26	0	0	0	0	1	0	188
template1.pg_catalog.pg_authid	1	0	8	0	6	0	0	3	3	14,690
nextcloud.pg_catalog.pg_index	1	1	51	0	16	0	0	27	13	89,606
nextcloud.pg_catalog.pg_amop	1	0	36	0	0	0	0	1	0	233
nextcloud.pg_catalog.pg_range	1	0	7	0	0	0	0	1	0	233
template0.pg_toast.pg_toast_1417	1	0	23	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_17035	1	0	25	0	0	0	0	1	0	188
template1.pg_toast.pg_toast_13295	1	0	23	0	0	0	0	1	0	188
template0.pg_toast.pg_toast_13305	1	0	23	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_1260	1	0	26	0	0	0	0	1	0	188
nextcloud.pg_catalog.pg_user_mapping	1	0	4	0	0	0	0	1	0	221
template0.pg_toast.pg_toast_3079	1	0	23	0	0	0	0	1	0	188
nextcloud.pg_catalog.pg_foreign_table	1	0	5	0	0	0	0	1	0	233
nextcloud.pg_catalog.pg_transform	1	0	6	0	0	0	0	1	0	233
nextcloud.public.oc_music_playlists	1	0	33	0	5	0	0	3	2	8,821
template1.pg_catalog.pg_rewrite	1	0	42	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_826	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_17224	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_catalog.pg_tablespace	1	0	25	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_17363	1	0	25	0	0	0	0	1	0	188
template0.pg_toast.pg_toast_2615	1	0	23	0	0	0	0	1	0	188
template1.pg_catalog.pg_sequence	1	0	3	0	0	0	0	1	0	233
nextcloud.public.oc_migrations	1	0	30	0	6	0	0	5	3	18,189
nextcloud.pg_toast.pg_toast_17254	1	0	29	0	5	0	0	3	2	13,269
nextcloud.pg_catalog.pg_enum	1	0	36	0	0	0	0	1	0	233
template1.pg_toast.pg_toast_1255	1	0	23	0	0	0	0	1	0	188
template1.pg_catalog.pg_class	1	0	51	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_16504	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_catalog.pg_publication_rel	1	0	6	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_16523	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_catalog.pg_depend	1	1	106	0	30	0	56	48	27	195,675
nextcloud.pg_toast.pg_toast_17392	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_1417	1	0	25	0	0	0	0	1	0	188
nextcloud.public.oc_calendar_rooms_md	1	0	43	0	0	0	0	1	0	188
template1.pg_catalog.pg_foreign_data_wrapper	1	0	5	0	0	0	0	1	0	233
template1.pg_toast.pg_toast_1247	1	0	23	0	0	0	0	1	0	188
template1.pg_catalog.pg_largeobject_metadata	1	0	21	0	0	0	0	1	0	233
nextcloud.public.oc_accounts	1	1	318	0	109	0	0	245	106	779,846
nextcloud.public.oc_passwords_folder_rv	1	0	244	0	92	0	0	177	89	685,065
nextcloud.public.oc_systemtag_object_mapping	1	0	35	0	5	0	0	3	2	9,253
nextcloud.pg_toast.pg_toast_16491	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_16617	1	0	25	0	0	0	0	1	0	188
nextcloud.public.oc_termsofservice_terms	1	0	56	0	5	0	0	3	2	8,793
nextcloud.pg_toast.pg_toast_17535	1	0	25	0	0	0	0	1	0	188
nextcloud.public.oc_collres_resources	1	0	32	0	5	0	0	3	2	8,837
nextcloud.public.oc_quicknotes_tags	1	0	29	0	5	0	0	3	2	12,477
nextcloud.public.oc_talk_guests	1	0	28	0	5	0	0	3	2	8,677
nextcloud.pg_catalog.pg_shseclabel	1	0	5	0	0	0	0	1	0	233
template1.pg_toast.pg_toast_3079	1	0	23	0	0	0	0	1	0	188
template0.pg_toast.pg_toast_3456	1	0	23	0	0	0	0	1	0	188
template0.pg_catalog.pg_range	1	0	5	0	0	0	0	1	0	233
template1.pg_catalog.pg_foreign_server	1	0	5	0	0	0	0	1	0	233
nextcloud.pg_catalog.pg_language	1	0	10	0	0	0	0	1	0	233
nextcloud.pg_catalog.pg_aggregate	1	0	10	0	0	0	0	1	0	233
template1.pg_toast.pg_toast_3394	1	0	23	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_17425	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_catalog.pg_attribute	1	1	276	0	105	0	35	234	101	789,832
nextcloud.public.oc_twofactor_u2f_registrations	1	1	62	0	8	0	0	13	5	14,297
template0.pg_toast.pg_toast_2612	1	0	23	0	0	0	0	1	0	188
template0.pg_catalog.pg_ts_parser	1	0	5	0	0	0	0	1	0	233
template0.pg_catalog.pg_opclass	1	0	8	0	0	0	0	1	0	233
template0.pg_catalog.pg_collation	1	0	29	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_16418	1	0	26	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_17136	1	0	25	0	0	0	0	1	0	188
nextcloud.public.oc_mounts	1	1	198	0	64	0	0	106	61	377,584
template1.pg_catalog.pg_publication	1	0	5	0	0	0	0	1	0	233
nextcloud.public.oc_calendar_invitations	1	1	63	0	14	0	0	18	11	68,669
nextcloud.public.oc_schedulingobjects	1	0	238	0	102	0	0	197	99	791,385
nextcloud.pg_catalog.pg_opfamily	1	0	25	0	0	0	0	1	0	233
template0.pg_catalog.pg_rewrite	1	0	27	0	0	0	0	1	0	233
template0.pg_catalog.pg_proc	1	0	5	0	0	0	80	1	0	233
template1.pg_toast.pg_toast_1262	1	0	23	0	0	0	0	1	0	188
template1.pg_toast.pg_toast_6000	1	0	23	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_17456	1	0	25	0	0	0	0	1	0	188
template0.pg_catalog.pg_cast	1	0	17	0	0	0	0	1	0	233
template0.pg_catalog.pg_sequence	1	0	3	0	0	0	0	1	0	233
template1.pg_catalog.pg_index	1	0	14	0	0	0	0	1	0	233
nextcloud.public.oc_twofactor_totp_secrets	1	1	55	0	7	0	0	8	4	12,941
template0.pg_catalog.pg_extension	1	0	33	0	0	0	0	1	0	233
template1.pg_toast.pg_toast_3429	1	0	23	0	0	0	0	1	0	188
template0.pg_toast.pg_toast_3466	1	0	23	0	0	0	0	1	0	188
template0.pg_toast.pg_toast_1255	1	0	23	0	0	0	0	1	0	188
nextcloud.pg_catalog.pg_am	1	0	43	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_2618	1	0	29	0	5	0	59	2	1	8,444
template1.pg_catalog.pg_statistic_ext	1	0	17	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_16592	1	1	1,060	0	604	0	0	1,142	411	1,393,792
nextcloud.public.oc_passwords_password	1	1	169	0	45	0	0	98	42	296,920
template1.pg_toast.pg_toast_13305	1	0	23	0	0	0	0	1	0	188
template0.pg_toast.pg_toast_3592	1	0	24	0	0	0	0	1	0	188
nextcloud.pg_catalog.pg_sequence	1	0	10	0	6	0	0	6	3	17,772
template1.pg_toast.pg_toast_13300	1	0	23	0	0	0	0	1	0	188
nextcloud.pg_catalog.pg_conversion	1	0	12	0	0	0	0	1	0	233
template0.pg_catalog.pg_trigger	1	0	32	0	0	0	0	1	0	233
template1.pg_catalog.pg_namespace	1	0	9	0	0	0	0	1	0	233
template1.pg_toast.pg_toast_2600	1	0	24	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_2606	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_catalog.pg_proc	1	1	147	0	9	0	32	13	6	41,192
nextcloud.pg_toast.pg_toast_2609	1	0	26	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_16513	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_16876	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_3256	1	0	26	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_17209	1	0	25	0	0	0	0	1	0	188
template0.pg_catalog.pg_index	1	0	14	0	0	0	0	1	0	233
template0.pg_catalog.pg_attrdef	1	0	34	0	0	0	0	1	0	233
nextcloud.information_schema.sql_implementation_info	1	0	11	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_3600	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_catalog.pg_policy	1	0	39	0	0	0	0	1	0	233
nextcloud.public.oc_talk_rooms	1	0	56	0	5	0	0	3	2	10,629
template0.pg_toast.pg_toast_3596	1	0	23	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_2600	1	0	26	0	0	0	0	1	0	188
nextcloud.pg_catalog.pg_shdescription	1	0	33	0	0	0	0	1	0	233
nextcloud.public.oc_quicknotes_attach	1	0	66	0	5	0	0	3	2	9,637
nextcloud.pg_toast.pg_toast_16437	1	0	25	0	0	0	0	1	0	188
template0.pg_catalog.pg_amop	1	0	21	0	0	0	0	1	0	233
template0.pg_catalog.pg_aggregate	1	0	6	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_16553	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_16965	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_catalog.pg_inherits	1	0	46	0	0	0	0	1	0	233
nextcloud.public.oc_quicknotes_notes	1	1	72	0	18	0	0	45	15	102,286
template0.pg_toast.pg_toast_2609	1	0	24	0	0	0	0	1	0	188
nextcloud.information_schema.sql_sizing	1	0	11	0	0	0	0	1	0	233
template0.pg_toast.pg_toast_3118	1	0	24	0	0	0	0	1	0	188
nextcloud.public.oc_notifications_pushtokens	1	1	82	0	25	0	0	56	22	153,404
template1.pg_catalog.pg_policy	1	0	36	0	0	0	0	1	0	233
template1.pg_catalog.pg_init_privs	1	0	33	0	0	0	0	1	0	233
template0.pg_catalog.pg_user_mapping	1	0	3	0	0	0	0	1	0	221
nextcloud.public.oc_vcategory_to_object	1	1	66	0	8	0	0	13	5	30,419
template1.pg_catalog.pg_collation	1	0	56	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_16800	1	0	25	0	0	0	0	1	0	188
nextcloud.public.oc_comments_read_markers	1	1	67	0	8	0	0	10	5	25,791
template1.pg_catalog.pg_ts_parser	1	0	8	0	0	0	0	1	0	233
template0.pg_toast.pg_toast_13310	1	0	22	0	0	0	0	1	0	188
template1.pg_catalog.pg_transform	1	0	5	0	0	0	0	1	0	233
template0.pg_catalog.pg_amproc	1	0	24	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_16562	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_16786	1	0	25	0	0	0	0	1	0	188
template0.pg_catalog.pg_class	1	0	48	0	0	0	0	1	0	233
template0.pg_catalog.pg_db_role_setting	1	0	4	0	0	0	0	1	0	233
nextcloud.public.oc_calendars	1	1	313	0	110	0	0	280	107	582,214
template0.pg_toast.pg_toast_2600	1	0	24	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_1247	1	0	25	0	0	0	0	1	0	188
nextcloud.public.oc_calendar_appt_bookings	1	0	42	0	0	0	0	1	0	188
template1.information_schema.sql_features	1	0	17	0	0	0	0	1	0	233
nextcloud.pg_catalog.pg_ts_dict	1	0	9	0	0	0	0	1	0	233
nextcloud.information_schema.sql_parts	1	0	11	0	0	0	0	1	0	188
nextcloud.public.oc_quicknotes_shares	1	0	28	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_3394	1	0	25	0	0	0	0	1	0	188
template0.pg_toast.pg_toast_1213	1	0	24	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_17071	1	0	33	0	7	0	0	6	3	24,408
nextcloud.public.oc_twofactor_providers	1	1	126	0	47	0	0	81	44	330,072
nextcloud.pg_toast.pg_toast_2620	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_16717	1	0	25	0	0	0	0	1	0	188
template1.pg_catalog.pg_depend	1	0	48	0	0	0	56	1	0	233
nextcloud.pg_catalog.pg_opclass	1	0	11	0	0	0	0	1	0	233
template0.pg_catalog.pg_publication_rel	1	0	3	0	0	0	0	1	0	233
template1.pg_toast.pg_toast_2964	1	0	23	0	0	0	0	1	0	188
template1.pg_toast.pg_toast_3600	1	0	23	0	0	0	0	1	0	188
template0.information_schema.sql_parts	1	0	10	0	0	0	0	1	0	188
nextcloud.public.oc_music_radio_stations	1	0	31	0	5	0	0	3	2	11,081
nextcloud.public.oc_music_ampache_sessions	1	0	39	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_2612	1	0	25	0	0	0	0	1	0	188
template0.pg_catalog.pg_transform	1	0	3	0	0	0	0	1	0	233
nextcloud.pg_catalog.pg_foreign_server	1	0	6	0	0	0	0	1	0	233
nextcloud.public.oc_comments	1	1	144	0	20	0	0	34	17	125,656
nextcloud.pg_catalog.pg_ts_template	1	0	9	0	0	0	0	1	0	233
nextcloud.pg_catalog.pg_ts_config_map	1	0	8	0	0	0	0	1	0	233
nextcloud.public.oc_group_user	1	0	46	0	5	0	0	3	2	9,109
nextcloud.pg_toast.pg_toast_17101	1	0	31	0	6	0	0	4	2	16,176
template0.pg_catalog.pg_database	1	0	12	0	0	0	0	1	0	233
nextcloud.public.oc_preferences	1	1	2,738	0	1,406	0	0	2,918	1,403	9,539,392
template0.pg_catalog.pg_foreign_table	1	0	3	0	1	0	0	1	1	5,413
nextcloud.pg_catalog.pg_seclabel	1	0	33	0	0	0	0	1	0	233
nextcloud.public.oc_calendar_appt_configs	1	0	41	0	0	0	0	1	0	188
template0.pg_catalog.pg_authid	1	0	12	0	1	0	0	1	1	4,869
template1.pg_catalog.pg_cast	1	0	22	0	0	0	0	1	0	233
nextcloud.public.oc_ratelimit_entries	1	0	34	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_17319	1	0	25	0	0	0	0	1	0	188
template1.pg_toast.pg_toast_2620	1	0	23	0	0	0	0	1	0	188
template1.pg_toast.pg_toast_2604	1	0	23	0	0	0	0	1	0	188
template1.pg_catalog.pg_opfamily	1	0	11	0	0	0	0	1	0	233
template1.pg_toast.pg_toast_13310	1	0	23	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_3079	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_2615	1	0	25	0	0	0	0	1	0	188
nextcloud.public.oc_properties	1	1	184	0	52	0	0	107	49	317,226
nextcloud.pg_catalog.pg_foreign_data_wrapper	1	0	6	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_16387	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_16634	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_16856	1	0	25	0	0	0	0	1	0	188
nextcloud.public.oc_quicknotes_colors	1	0	30	0	5	0	0	3	2	9,009
nextcloud.public.oc_music_ampache_users	1	0	45	0	5	0	0	3	2	8,641
template1.pg_catalog.pg_conversion	1	0	11	0	0	0	0	1	0	233
template1.pg_toast.pg_toast_2606	1	0	23	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_16465	1	0	25	0	0	0	0	1	0	188
template0.pg_catalog.pg_subscription	1	0	5	0	0	0	0	1	0	221
nextcloud.pg_catalog.pg_db_role_setting	1	0	5	0	0	0	0	1	0	233
nextcloud.public.oc_privacy_admins	1	0	28	0	0	0	0	1	0	188
template1.pg_toast.pg_toast_3381	1	0	24	0	0	0	0	1	0	188
template0.pg_catalog.pg_tablespace	1	0	23	0	0	0	0	1	0	233
template0.pg_catalog.pg_conversion	1	0	6	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_3466	1	0	25	0	0	0	0	1	0	188
nextcloud.public.oc_storages	1	1	101	0	24	0	0	44	21	148,896
nextcloud.pg_catalog.pg_statistic_ext_data	1	0	4	0	0	0	0	1	0	221
nextcloud.pg_toast.pg_toast_6100	1	0	26	0	0	0	0	1	0	188
nextcloud.public.oc_notifications	1	1	1,005	0	487	0	0	1,014	473	3,235,387
template1.pg_catalog.pg_enum	1	0	34	0	1	0	0	1	1	8,057
nextcloud.pg_catalog.pg_replication_origin	1	0	6	0	0	0	0	1	0	233
nextcloud.public.oc_passwords_folder	1	0	80	0	12	0	0	17	9	69,021
template0.pg_toast.pg_toast_3350	1	0	23	0	1	0	0	1	1	8,177
nextcloud.public.oc_music_podcast_episodes	1	0	53	0	0	0	0	1	0	188
template1.pg_toast.pg_toast_2609	1	0	24	0	0	0	0	1	0	188
template0.information_schema.sql_features	1	0	16	0	0	0	0	1	0	233
nextcloud.pg_catalog.pg_ts_parser	1	0	9	0	0	0	0	1	0	233
template0.pg_catalog.pg_ts_config	1	0	5	0	0	0	0	1	0	233
nextcloud.pg_catalog.pg_trigger	1	0	38	0	0	0	0	1	0	233
template1.pg_catalog.pg_inherits	1	0	36	0	0	0	0	1	0	233
template1.information_schema.sql_implementation_info	1	0	17	0	1	0	0	1	1	7,921
template0.pg_catalog.pg_opfamily	1	0	7	0	0	0	0	1	0	233
nextcloud.pg_catalog.pg_largeobject	1	0	25	0	1	0	0	1	1	7,849
nextcloud.public.oc_webauthn	1	1	70	0	8	0	0	12	5	16,380
nextcloud.pg_toast.pg_toast_17445	1	0	25	0	0	0	0	1	0	188
template0.pg_catalog.pg_foreign_data_wrapper	1	0	3	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_17483	1	1	52	0	12	0	0	26	9	10,252
nextcloud.pg_toast.pg_toast_2396	1	0	27	0	0	0	0	1	0	188
template1.pg_catalog.pg_aggregate	1	0	8	0	0	0	0	1	0	233
template1.pg_catalog.pg_publication_rel	1	0	5	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_17174	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_16757	1	0	25	0	0	0	0	1	0	188
template0.pg_toast.pg_toast_13300	1	0	23	0	0	0	0	1	0	188
template0.pg_catalog.pg_attribute	1	0	7	0	0	0	52	1	0	233
nextcloud.public.oc_announcements	1	0	38	0	6	0	0	5	3	18,549
template0.pg_catalog.pg_largeobject	1	0	23	0	1	0	0	1	1	7,125
nextcloud.pg_toast.pg_toast_1213	1	0	26	0	0	0	0	1	0	188
template0.pg_catalog.pg_largeobject_metadata	1	0	20	0	0	0	0	1	0	233
template0.pg_catalog.pg_shdescription	1	0	31	0	0	0	0	1	0	233
nextcloud.public.oc_flow_checks	1	0	38	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_1418	1	0	26	0	0	0	0	1	0	188
template1.pg_catalog.pg_partitioned_table	1	0	4	0	0	0	0	1	0	233
template0.information_schema.sql_sizing	1	0	9	0	0	0	0	1	0	233
nextcloud.public.oc_whats_new	1	0	62	0	5	0	0	4	2	11,691
nextcloud.public.oc_calendar_rooms	1	0	70	0	0	0	0	1	0	188
template0.pg_catalog.pg_seclabel	1	0	35	0	0	0	0	1	0	233
nextcloud.pg_catalog.pg_namespace	1	0	10	0	1	0	0	1	1	8,057
nextcloud.public.oc_dav_cal_proxy	1	0	73	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_17571	1	0	25	0	0	0	0	1	0	188
template1.information_schema.sql_sizing	1	0	10	0	0	0	0	1	0	233
template0.pg_catalog.pg_default_acl	1	0	14	0	0	0	0	1	0	233
template1.pg_catalog.pg_constraint	1	0	69	0	0	0	0	1	0	233
template0.pg_catalog.pg_auth_members	1	0	12	0	0	0	0	1	0	233
nextcloud.public.oc_trusted_servers	1	0	42	0	0	0	0	1	0	188
template1.pg_catalog.pg_opclass	1	0	10	0	0	0	0	1	0	233
template1.pg_catalog.pg_amop	1	0	30	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_17047	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_catalog.pg_collation	1	0	57	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_17525	1	0	25	0	0	0	0	1	0	188
template1.pg_catalog.pg_shdescription	1	0	25	0	0	0	0	1	0	233
nextcloud.public.oc_passwords_share	1	0	67	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_17120	1	1	473	0	222	0	0	440	219	1,662,220
template1.pg_catalog.pg_extension	1	0	36	0	0	0	0	1	0	233
nextcloud.pg_catalog.pg_event_trigger	1	0	6	0	0	0	0	1	0	233
template1.pg_catalog.pg_proc	1	0	9	0	0	0	80	1	0	233
nextcloud.pg_catalog.pg_rewrite	1	1	56	0	7	0	0	7	4	21,230
nextcloud.public.oc_talk_signaling	1	0	25	0	0	0	0	1	0	188
template1.pg_catalog.pg_auth_members	1	0	5	0	0	0	0	1	0	233
template1.pg_catalog.pg_description	1	0	28	0	0	0	41	1	0	233
template0.pg_catalog.pg_type	1	0	14	0	0	0	0	1	0	233
nextcloud.public.oc_twofactor_backupcodes	1	1	65	0	12	0	0	21	9	62,603
template0.pg_catalog.pg_shdepend	1	0	54	0	0	0	0	1	0	233
template1.pg_catalog.pg_db_role_setting	1	0	4	0	0	0	0	1	0	233
template0.pg_catalog.pg_init_privs	1	0	29	0	0	0	0	1	0	233
template0.pg_toast.pg_toast_2964	1	0	24	0	0	0	0	1	0	188
nextcloud.pg_catalog.pg_statistic_ext	1	0	19	0	0	0	0	1	0	233
template1.pg_toast.pg_toast_3456	1	0	23	0	0	0	0	1	0	188
nextcloud.public.oc_passwords_registration	1	0	69	0	0	0	0	1	0	188
template1.pg_catalog.pg_shseclabel	1	0	3	0	0	0	0	1	0	233
template1.pg_catalog.pg_seclabel	1	0	35	0	0	0	0	1	0	233
template0.pg_toast.pg_toast_6100	1	0	24	0	0	0	0	1	0	188
nextcloud.public.oc_passwords_keychain	1	0	67	0	5	0	0	3	2	13,853
nextcloud.public.oc_quicknotes_note_tags	1	1	38	0	7	0	0	11	4	26,550
nextcloud.pg_toast.pg_toast_16575	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_16401	1	0	25	0	0	0	0	1	0	188
nextcloud.public.oc_systemtag	1	0	49	0	5	0	0	3	2	10,181
template1.pg_catalog.pg_default_acl	1	0	16	0	0	0	0	1	0	233
template0.pg_catalog.pg_description	1	0	28	0	0	0	41	1	0	233
template1.pg_catalog.pg_am	1	0	31	0	0	0	0	1	0	233
template1.pg_catalog.pg_subscription	1	0	5	0	0	0	0	1	0	221
template1.pg_catalog.pg_ts_config	1	0	8	0	0	0	0	1	0	233
nextcloud.public.oc_music_bookmarks	1	0	45	0	0	0	0	1	0	188
template1.pg_toast.pg_toast_1260	1	0	23	0	0	0	0	1	0	188
nextcloud.public.oc_music_genres	1	0	48	0	5	0	0	4	2	15,295
nextcloud.public.oc_groups	1	0	30	0	5	0	0	3	2	8,629
template1.pg_catalog.pg_amproc	1	0	26	0	0	0	0	1	0	233
nextcloud.public.oc_group_admin	1	0	43	0	0	0	0	1	0	188
template1.pg_toast.pg_toast_2328	1	0	23	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_16985	1	0	25	0	0	0	0	1	0	188
template0.pg_catalog.pg_am	1	0	28	0	0	0	0	1	0	233
nextcloud.pg_catalog.pg_cast	1	0	24	0	0	0	0	1	0	233
template0.pg_catalog.pg_foreign_server	1	0	3	0	0	0	0	1	0	233
nextcloud.public.oc_share	1	1	388	0	118	0	0	238	115	761,717
template1.pg_catalog.pg_tablespace	1	0	19	0	0	0	0	1	0	233
template1.pg_catalog.pg_user_mapping	1	0	3	0	0	0	0	1	0	221
nextcloud.public.oc_collres_collections	1	0	28	0	5	0	0	3	2	8,681
nextcloud.pg_catalog.pg_extension	1	0	39	0	5	0	0	3	2	8,820
nextcloud.public.oc_passwords_pw_tag_rel	1	0	68	0	5	0	0	3	2	13,897
nextcloud.pg_catalog.pg_auth_members	1	0	13	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_13305	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_catalog.pg_default_acl	1	0	18	0	0	0	0	1	0	233
template1.pg_toast.pg_toast_2618	1	0	26	0	0	0	59	1	0	188
nextcloud.public.oc_music_podcast_channels	1	0	46	0	0	0	0	1	0	188
template0.pg_catalog.pg_ts_dict	1	0	5	0	0	0	0	1	0	233
nextcloud.pg_toast.pg_toast_1262	1	0	26	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_13295	1	0	25	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_16532	1	0	25	0	0	0	0	1	0	188
template0.pg_catalog.pg_ts_template	1	0	5	0	0	0	0	1	0	233
nextcloud.public.oc_addressbookchanges	1	1	2,273	0	1,029	0	0	2,092	992	7,795,207
nextcloud.pg_toast.pg_toast_17408	1	0	25	0	0	0	0	1	0	188
nextcloud.public.oc_calendar_resources	1	0	70	0	0	0	0	1	0	188
nextcloud.pg_toast.pg_toast_16728	1	0	25	0	0	0	0	1	0	188
template0.information_schema.sql_implementation_info	1	0	15	0	1	0	0	1	1	7,921
nextcloud.public.oc_announcements_map	1	0	47	0	5	0	0	3	2	10,025
nextcloud.public.oc_vcategory	1	1	90	0	9	0	0	14	6	25,951
nextcloud.pg_toast.pg_toast_1255	1	0	25	0	0	0	0	1	0	188
template0.pg_catalog.pg_shseclabel	1	0	4	0	0	0	0	1	0	233
Total	1,676	921	772,719	123,199	111,903	244	141,182	331,496	112,560	530,536,955

Tuples removed per table

Key values

pg_toast.pg_toast_2619 (57924) Main table with removed tuples on database nextcloud
235833 tuples Total removed

Chart
Table

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
nextcloud.pg_toast.pg_toast_2619	361	361	57,924	178,206	1,891	0	82,669
nextcloud.public.oc_jobs	449	273	40,431	54,660	5,620	0	19,756
nextcloud.public.oc_activity	1	1	34,910	845,244	0	0	46,397
nextcloud.public.oc_authtoken	167	167	27,859	409,691	1,158	0	144,956
nextcloud.public.oc_calendarobjects_props	3	3	17,903	673,035	0	0	9,705
nextcloud.public.oc_calendarchanges	3	3	13,519	574,602	0	0	9,690
nextcloud.public.oc_calendarsubscriptions	161	6	11,399	9,416	1,366	0	3,381
nextcloud.public.oc_calendarobjects	4	4	10,409	268,942	0	0	46,724
nextcloud.public.oc_files_trash	1	1	9,697	148,252	0	0	2,186
nextcloud.pg_catalog.pg_statistic	22	19	5,969	24,574	0	0	2,398
nextcloud.public.oc_appconfig	24	24	2,688	7,861	13	0	120
nextcloud.public.oc_preferences	1	1	1,069	82,843	1	0	873
nextcloud.pg_toast.pg_toast_16592	1	1	965	1,487	0	0	531
nextcloud.public.oc_bruteforce_attempts	1	1	155	277	0	0	7
nextcloud.public.oc_text_sessions	10	10	95	56	0	0	10
nextcloud.public.oc_calendars	1	1	94	2,234	0	0	77
nextcloud.public.oc_addressbooks	1	1	93	1,531	0	0	19
nextcloud.public.oc_notifications	1	1	79	18,487	0	0	290
nextcloud.public.oc_user_status	2	2	52	2,056	0	0	22
nextcloud.public.oc_properties	1	1	51	1,029	0	0	25
nextcloud.public.oc_storages	1	1	39	1,583	0	0	13
nextcloud.public.oc_music_tracks	1	1	37	441	0	0	10
nextcloud.public.oc_music_artists	1	1	29	140	0	0	3
nextcloud.public.oc_quicknotes_notes	1	1	29	300	0	0	13
nextcloud.public.oc_whats_new	1	0	28	30	0	0	1
nextcloud.pg_catalog.pg_attribute	1	1	23	6,665	0	0	125
nextcloud.public.oc_passwords_password_rv	1	1	21	1,834	0	0	399
nextcloud.pg_catalog.pg_depend	1	1	21	9,843	0	0	73
nextcloud.pg_toast.pg_toast_17483	1	1	20	0	0	7	0
nextcloud.pg_catalog.pg_class	1	1	19	1,080	0	0	27
nextcloud.public.oc_directlink	1	1	19	0	0	1	0
nextcloud.public.oc_twofactor_backupcodes	1	1	19	264	0	0	6
nextcloud.public.oc_music_genres	1	0	19	76	0	0	1
nextcloud.public.oc_text_documents	1	1	18	16	0	0	1
nextcloud.pg_catalog.pg_type	1	1	16	832	0	0	20
nextcloud.public.oc_share	1	1	12	2,629	0	0	58
nextcloud.public.oc_twofactor_u2f_registrations	1	1	10	5	0	1	1
nextcloud.pg_catalog.pg_sequence	1	0	10	101	0	0	2
template1.pg_toast.pg_toast_2619	1	1	8	12	0	0	5
nextcloud.public.oc_accounts	1	1	8	1,509	0	0	96
nextcloud.public.oc_vcategory_to_object	1	1	8	178	0	0	2
nextcloud.public.oc_twofactor_providers	1	1	8	4,394	0	0	28
nextcloud.public.oc_notifications_pushtokens	1	1	7	150	0	0	20
nextcloud.public.oc_addressbookchanges	1	1	7	78,622	0	0	983
nextcloud.public.oc_share_external	1	1	6	28	0	0	1
nextcloud.public.oc_mounts	1	1	6	1,752	0	0	19
nextcloud.public.oc_vcategory	1	1	6	86	0	0	1
nextcloud.public.oc_users	1	1	4	1,509	0	0	30
nextcloud.pg_catalog.pg_extension	1	0	4	2	0	0	1
nextcloud.public.oc_quicknotes_note_tags	1	1	3	205	0	0	2
nextcloud.public.oc_webauthn	1	1	2	8	0	0	1
template1.pg_catalog.pg_database	1	0	1	4	0	0	1
nextcloud.public.oc_passwords_tag_rv	1	1	1	4	0	0	1
template1.pg_catalog.pg_shdepend	1	1	1	236	0	0	2
nextcloud.public.oc_passwords_tag	1	1	1	4	0	0	1
nextcloud.pg_catalog.pg_index	1	1	1	551	0	0	13
nextcloud.pg_toast.pg_toast_17120	1	1	1	1,520	0	0	217
nextcloud.pg_toast.pg_toast_3596	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_16808	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_3381	1	0	0	0	0	0	0
nextcloud.public.oc_calendar_resources_md	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_2619	1	0	0	12	0	0	3
template0.pg_catalog.pg_statistic_ext_data	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_17087	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_17063	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_2618	1	0	0	261	0	0	60
nextcloud.pg_toast.pg_toast_16953	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_1247	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_init_privs	1	1	0	178	0	0	2
nextcloud.pg_toast.pg_toast_13300	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_6000	1	0	0	0	0	0	0
template0.pg_catalog.pg_policy	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_2615	1	0	0	0	0	0	0
template0.pg_catalog.pg_statistic	1	0	0	402	0	0	18
template0.pg_catalog.pg_replication_origin	1	0	0	0	0	0	0
template0.pg_catalog.pg_operator	1	0	0	784	0	0	14
template1.pg_catalog.pg_ts_template	1	0	0	5	0	0	1
template1.pg_catalog.pg_statistic_ext_data	1	0	0	0	0	0	0
nextcloud.public.oc_flow_operations	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_1262	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_3456	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_subscription	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_16540	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_17295	1	0	0	0	0	0	0
template1.pg_catalog.pg_attribute	1	0	0	2,816	0	0	53
nextcloud.public.oc_talk_commands	1	0	0	1	0	0	1
nextcloud.pg_toast.pg_toast_6000	1	0	0	0	0	0	0
template1.pg_catalog.pg_attrdef	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_3350	1	0	0	0	0	0	0
template1.pg_catalog.pg_foreign_table	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_ts_config	1	0	0	23	0	0	1
template1.pg_toast.pg_toast_3118	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_3592	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_3429	1	0	0	0	0	0	0
template1.pg_catalog.pg_type	1	0	0	411	0	0	10
nextcloud.pg_toast.pg_toast_17308	1	0	0	0	0	0	0
nextcloud.public.oc_user_transfer_owner	1	0	0	1	0	0	1
template0.pg_toast.pg_toast_826	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_17162	1	0	0	0	0	0	0
template0.pg_catalog.pg_enum	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_attrdef	1	0	0	515	0	0	30
template0.pg_toast.pg_toast_1260	1	0	0	0	0	0	0
nextcloud.public.oc_known_users	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_amproc	1	0	0	483	0	0	4
template1.pg_toast.pg_toast_2396	1	0	0	0	0	0	0
nextcloud.public.oc_systemtag_group	1	0	0	0	0	0	0
template0.pg_catalog.pg_ts_config_map	1	0	0	437	0	0	3
template1.pg_toast.pg_toast_3466	1	0	0	0	0	0	0
nextcloud.public.oc_storages_credentials	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_largeobject_metadata	1	0	0	0	0	0	0
template1.pg_catalog.pg_replication_origin	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_16888	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_publication	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_authid	1	0	0	12	0	0	1
nextcloud.pg_toast.pg_toast_17514	1	0	0	0	0	0	0
template1.pg_catalog.pg_range	1	0	0	6	0	0	1
nextcloud.pg_catalog.pg_constraint	1	0	0	120	0	0	3
nextcloud.public.oc_federated_reshares	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_17055	1	0	0	0	0	0	0
template0.pg_catalog.pg_language	1	0	0	4	0	0	1
template0.pg_toast.pg_toast_2396	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_3600	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_3596	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_17148	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_2964	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_17004	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_2328	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_3429	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_1418	1	0	0	0	0	0	0
template1.pg_catalog.pg_largeobject	1	0	0	0	0	0	0
template0.pg_catalog.pg_inherits	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_operator	1	0	0	784	0	0	14
template0.pg_catalog.pg_constraint	1	0	0	2	0	0	1
nextcloud.pg_toast.pg_toast_16450	1	0	0	0	0	0	0
template1.pg_catalog.pg_language	1	0	0	4	0	0	1
nextcloud.pg_toast.pg_toast_17195	1	0	0	0	0	0	0
template0.pg_catalog.pg_event_trigger	1	0	0	0	0	0	0
nextcloud.public.oc_oauth2_access_tokens	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_1418	1	0	0	0	0	0	0
template1.pg_catalog.pg_operator	1	0	0	784	0	0	14
template0.pg_toast.pg_toast_2604	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_17344	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_13310	1	0	0	0	0	0	0
nextcloud.information_schema.sql_features	1	0	0	712	0	0	8
nextcloud.pg_toast.pg_toast_3118	1	0	0	0	0	0	0
nextcloud.public.oc_oauth2_clients	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_2606	1	0	0	0	0	0	0
template1.pg_catalog.pg_ts_dict	1	0	0	23	0	0	1
nextcloud.pg_toast.pg_toast_17016	1	0	0	0	0	0	0
template1.information_schema.sql_parts	1	0	0	10	0	0	1
template0.pg_toast.pg_toast_3394	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_13295	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_1417	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_16686	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_2604	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_2328	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_3256	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_3256	1	0	0	0	0	0	0
template1.pg_catalog.pg_trigger	1	0	0	0	0	0	0
template1.pg_catalog.pg_statistic	1	0	0	405	0	0	29
template0.pg_catalog.pg_subscription_rel	1	0	0	0	0	0	0
template1.pg_catalog.pg_event_trigger	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_shdepend	1	0	0	236	0	0	2
template1.pg_catalog.pg_ts_config_map	1	0	0	437	0	0	3
template1.pg_catalog.pg_subscription_rel	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_database	1	0	0	4	0	0	1
nextcloud.public.oc_flow_operations_scope	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_826	1	0	0	0	0	0	0
template0.pg_catalog.pg_depend	1	0	0	7,700	0	0	57
nextcloud.pg_toast.pg_toast_3350	1	0	0	0	0	0	0
template0.pg_catalog.pg_statistic_ext	1	0	0	0	0	0	0
nextcloud.public.oc_passwords_challenge	1	0	0	4	0	0	1
template0.pg_catalog.pg_partitioned_table	1	0	0	0	0	0	0
nextcloud.public.oc_talk_participants	1	0	0	20	0	0	1
nextcloud.pg_catalog.pg_description	1	0	0	4,817	0	0	42
template0.pg_catalog.pg_namespace	1	0	0	4	0	0	1
template0.pg_catalog.pg_publication	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_6100	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_subscription_rel	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_partitioned_table	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_2620	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_17492	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_1213	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_17579	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_3592	1	0	0	0	0	0	0
nextcloud.public.oc_mimetypes	1	0	0	129	0	0	2
template1.pg_toast.pg_toast_2612	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_3381	1	0	0	0	0	0	0
template1.pg_catalog.pg_authid	1	0	0	12	0	0	1
nextcloud.pg_catalog.pg_amop	1	0	0	723	0	0	6
nextcloud.pg_catalog.pg_range	1	0	0	6	0	0	1
template0.pg_toast.pg_toast_1417	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_17035	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_13295	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_13305	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_1260	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_user_mapping	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_3079	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_foreign_table	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_transform	1	0	0	0	0	0	0
nextcloud.public.oc_music_playlists	1	0	0	4	0	0	1
template1.pg_catalog.pg_rewrite	1	0	0	130	0	0	12
nextcloud.pg_toast.pg_toast_826	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_17224	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_tablespace	1	0	0	2	0	0	1
nextcloud.pg_toast.pg_toast_17363	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_2615	1	0	0	0	0	0	0
template1.pg_catalog.pg_sequence	1	0	0	0	0	0	0
nextcloud.public.oc_migrations	1	0	0	153	0	0	2
nextcloud.pg_toast.pg_toast_17254	1	0	0	4	0	0	1
nextcloud.pg_catalog.pg_enum	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_1255	1	0	0	0	0	0	0
template1.pg_catalog.pg_class	1	0	0	386	0	0	13
nextcloud.pg_toast.pg_toast_16504	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_publication_rel	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_16523	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_17392	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_1417	1	0	0	0	0	0	0
nextcloud.public.oc_calendar_rooms_md	1	0	0	0	0	0	0
template1.pg_catalog.pg_foreign_data_wrapper	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_1247	1	0	0	0	0	0	0
template1.pg_catalog.pg_largeobject_metadata	1	0	0	0	0	0	0
nextcloud.public.oc_passwords_folder_rv	1	0	0	450	0	0	88
nextcloud.public.oc_systemtag_object_mapping	1	0	0	14	0	0	1
nextcloud.pg_toast.pg_toast_16491	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_16617	1	0	0	0	0	0	0
nextcloud.public.oc_termsofservice_terms	1	0	0	1	0	0	1
nextcloud.pg_toast.pg_toast_17535	1	0	0	0	0	0	0
nextcloud.public.oc_collres_resources	1	0	0	6	0	0	1
nextcloud.public.oc_quicknotes_tags	1	0	0	72	0	0	1
nextcloud.public.oc_talk_guests	1	0	0	2	0	0	1
nextcloud.pg_catalog.pg_shseclabel	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_3079	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_3456	1	0	0	0	0	0	0
template0.pg_catalog.pg_range	1	0	0	6	0	0	1
template1.pg_catalog.pg_foreign_server	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_language	1	0	0	4	0	0	1
nextcloud.pg_catalog.pg_aggregate	1	0	0	138	0	0	2
template1.pg_toast.pg_toast_3394	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_17425	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_2612	1	0	0	0	0	0	0
template0.pg_catalog.pg_ts_parser	1	0	0	1	0	0	1
template0.pg_catalog.pg_opclass	1	0	0	130	0	0	2
template0.pg_catalog.pg_collation	1	0	0	790	0	0	25
nextcloud.pg_toast.pg_toast_16418	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_17136	1	0	0	0	0	0	0
template1.pg_catalog.pg_publication	1	0	0	0	0	0	0
nextcloud.public.oc_calendar_invitations	1	1	0	138	0	0	4
nextcloud.public.oc_schedulingobjects	1	0	0	618	0	0	98
nextcloud.pg_catalog.pg_opfamily	1	0	0	109	0	0	2
template0.pg_catalog.pg_rewrite	1	0	0	130	0	0	12
template0.pg_catalog.pg_proc	1	0	0	3,006	0	0	81
template1.pg_toast.pg_toast_1262	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_6000	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_17456	1	0	0	0	0	0	0
template0.pg_catalog.pg_cast	1	0	0	224	0	0	2
template0.pg_catalog.pg_sequence	1	0	0	0	0	0	0
template1.pg_catalog.pg_index	1	0	0	154	0	0	4
nextcloud.public.oc_twofactor_totp_secrets	1	1	0	11	0	0	1
template0.pg_catalog.pg_extension	1	0	0	1	0	0	1
template1.pg_toast.pg_toast_3429	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_3466	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_1255	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_am	1	0	0	7	0	0	1
nextcloud.pg_toast.pg_toast_2618	1	0	0	263	0	0	60
template1.pg_catalog.pg_statistic_ext	1	0	0	0	0	0	0
nextcloud.public.oc_passwords_password	1	1	0	1,470	0	0	28
template1.pg_toast.pg_toast_13305	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_3592	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_13300	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_conversion	1	0	0	128	0	0	2
template0.pg_catalog.pg_trigger	1	0	0	0	0	0	0
template1.pg_catalog.pg_namespace	1	0	0	4	0	0	1
template1.pg_toast.pg_toast_2600	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_2606	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_proc	1	1	0	3,032	0	0	81
nextcloud.pg_toast.pg_toast_2609	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_16513	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_16876	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_3256	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_17209	1	0	0	0	0	0	0
template0.pg_catalog.pg_index	1	0	0	154	0	0	4
template0.pg_catalog.pg_attrdef	1	0	0	0	0	0	0
nextcloud.information_schema.sql_implementation_info	1	0	0	12	0	0	1
nextcloud.pg_toast.pg_toast_3600	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_policy	1	0	0	0	0	0	0
nextcloud.public.oc_talk_rooms	1	0	0	18	0	0	1
template0.pg_toast.pg_toast_3596	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_2600	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_shdescription	1	0	0	3	0	0	1
nextcloud.public.oc_quicknotes_attach	1	0	0	16	0	0	1
nextcloud.pg_toast.pg_toast_16437	1	0	0	0	0	0	0
template0.pg_catalog.pg_amop	1	0	0	723	0	0	6
template0.pg_catalog.pg_aggregate	1	0	0	138	0	0	2
nextcloud.pg_toast.pg_toast_16553	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_16965	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_inherits	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_2609	1	0	0	0	0	0	0
nextcloud.information_schema.sql_sizing	1	0	0	23	0	0	1
template0.pg_toast.pg_toast_3118	1	0	0	0	0	0	0
template1.pg_catalog.pg_policy	1	0	0	0	0	0	0
template1.pg_catalog.pg_init_privs	1	0	0	176	0	0	2
template0.pg_catalog.pg_user_mapping	1	0	0	0	0	0	0
template1.pg_catalog.pg_collation	1	0	0	790	0	0	25
nextcloud.pg_toast.pg_toast_16800	1	0	0	0	0	0	0
nextcloud.public.oc_comments_read_markers	1	1	0	129	0	0	2
template1.pg_catalog.pg_ts_parser	1	0	0	1	0	0	1
template0.pg_toast.pg_toast_13310	1	0	0	0	0	0	0
template1.pg_catalog.pg_transform	1	0	0	0	0	0	0
template0.pg_catalog.pg_amproc	1	0	0	483	0	0	4
nextcloud.pg_toast.pg_toast_16562	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_16786	1	0	0	0	0	0	0
template0.pg_catalog.pg_class	1	0	0	386	0	0	13
template0.pg_catalog.pg_db_role_setting	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_2600	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_1247	1	0	0	0	0	0	0
nextcloud.public.oc_calendar_appt_bookings	1	0	0	0	0	0	0
template1.information_schema.sql_features	1	0	0	712	0	0	8
nextcloud.pg_catalog.pg_ts_dict	1	0	0	23	0	0	1
nextcloud.information_schema.sql_parts	1	0	0	10	0	0	1
nextcloud.public.oc_quicknotes_shares	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_3394	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_1213	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_17071	1	0	0	12	0	0	3
nextcloud.pg_toast.pg_toast_2620	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_16717	1	0	0	0	0	0	0
template1.pg_catalog.pg_depend	1	0	0	7,700	0	0	57
nextcloud.pg_catalog.pg_opclass	1	0	0	130	0	0	2
template0.pg_catalog.pg_publication_rel	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_2964	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_3600	1	0	0	0	0	0	0
template0.information_schema.sql_parts	1	0	0	10	0	0	1
nextcloud.public.oc_music_radio_stations	1	0	0	21	0	0	1
nextcloud.public.oc_music_ampache_sessions	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_2612	1	0	0	0	0	0	0
template0.pg_catalog.pg_transform	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_foreign_server	1	0	0	0	0	0	0
nextcloud.public.oc_comments	1	1	0	512	0	0	11
nextcloud.pg_catalog.pg_ts_template	1	0	0	5	0	0	1
nextcloud.pg_catalog.pg_ts_config_map	1	0	0	437	0	0	3
nextcloud.public.oc_group_user	1	0	0	12	0	0	1
nextcloud.pg_toast.pg_toast_17101	1	0	0	8	0	0	2
template0.pg_catalog.pg_database	1	0	0	4	0	0	1
template0.pg_catalog.pg_foreign_table	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_seclabel	1	0	0	0	0	0	0
nextcloud.public.oc_calendar_appt_configs	1	0	0	0	0	0	0
template0.pg_catalog.pg_authid	1	0	0	12	0	0	1
template1.pg_catalog.pg_cast	1	0	0	224	0	0	2
nextcloud.public.oc_ratelimit_entries	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_17319	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_2620	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_2604	1	0	0	0	0	0	0
template1.pg_catalog.pg_opfamily	1	0	0	109	0	0	2
template1.pg_toast.pg_toast_13310	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_3079	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_2615	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_foreign_data_wrapper	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_16387	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_16634	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_16856	1	0	0	0	0	0	0
nextcloud.public.oc_quicknotes_colors	1	0	0	11	0	0	1
nextcloud.public.oc_music_ampache_users	1	0	0	1	0	0	1
template1.pg_catalog.pg_conversion	1	0	0	128	0	0	2
template1.pg_toast.pg_toast_2606	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_16465	1	0	0	0	0	0	0
template0.pg_catalog.pg_subscription	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_db_role_setting	1	0	0	0	0	0	0
nextcloud.public.oc_privacy_admins	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_3381	1	0	0	0	0	0	0
template0.pg_catalog.pg_tablespace	1	0	0	2	0	0	1
template0.pg_catalog.pg_conversion	1	0	0	128	0	0	2
nextcloud.pg_toast.pg_toast_3466	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_statistic_ext_data	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_6100	1	0	0	0	0	0	0
template1.pg_catalog.pg_enum	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_replication_origin	1	0	0	0	0	0	0
nextcloud.public.oc_passwords_folder	1	0	0	425	0	0	8
template0.pg_toast.pg_toast_3350	1	0	0	0	0	0	0
nextcloud.public.oc_music_podcast_episodes	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_2609	1	0	0	0	0	0	0
template0.information_schema.sql_features	1	0	0	712	0	0	8
nextcloud.pg_catalog.pg_ts_parser	1	0	0	1	0	0	1
template0.pg_catalog.pg_ts_config	1	0	0	23	0	0	1
nextcloud.pg_catalog.pg_trigger	1	0	0	0	0	0	0
template1.pg_catalog.pg_inherits	1	0	0	0	0	0	0
template1.information_schema.sql_implementation_info	1	0	0	12	0	0	1
template0.pg_catalog.pg_opfamily	1	0	0	109	0	0	2
nextcloud.pg_catalog.pg_largeobject	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_17445	1	0	0	0	0	0	0
template0.pg_catalog.pg_foreign_data_wrapper	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_2396	1	0	0	0	0	0	0
template1.pg_catalog.pg_aggregate	1	0	0	138	0	0	2
template1.pg_catalog.pg_publication_rel	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_17174	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_16757	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_13300	1	0	0	0	0	0	0
template0.pg_catalog.pg_attribute	1	0	0	2,816	0	0	53
nextcloud.public.oc_announcements	1	0	0	29	0	0	2
template0.pg_catalog.pg_largeobject	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_1213	1	0	0	0	0	0	0
template0.pg_catalog.pg_largeobject_metadata	1	0	0	0	0	0	0
template0.pg_catalog.pg_shdescription	1	0	0	3	0	0	1
nextcloud.public.oc_flow_checks	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_1418	1	0	0	0	0	0	0
template1.pg_catalog.pg_partitioned_table	1	0	0	0	0	0	0
template0.information_schema.sql_sizing	1	0	0	23	0	0	1
nextcloud.public.oc_calendar_rooms	1	0	0	0	0	0	0
template0.pg_catalog.pg_seclabel	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_namespace	1	0	0	4	0	0	1
nextcloud.public.oc_dav_cal_proxy	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_17571	1	0	0	0	0	0	0
template1.information_schema.sql_sizing	1	0	0	23	0	0	1
template0.pg_catalog.pg_default_acl	1	0	0	0	0	0	0
template1.pg_catalog.pg_constraint	1	0	0	2	0	0	1
template0.pg_catalog.pg_auth_members	1	0	0	3	0	0	1
nextcloud.public.oc_trusted_servers	1	0	0	0	0	0	0
template1.pg_catalog.pg_opclass	1	0	0	130	0	0	2
template1.pg_catalog.pg_amop	1	0	0	723	0	0	6
nextcloud.pg_toast.pg_toast_17047	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_collation	1	0	0	790	0	0	25
nextcloud.pg_toast.pg_toast_17525	1	0	0	0	0	0	0
template1.pg_catalog.pg_shdescription	1	0	0	3	0	0	1
nextcloud.public.oc_passwords_share	1	0	0	0	0	0	0
template1.pg_catalog.pg_extension	1	0	0	1	0	0	1
nextcloud.pg_catalog.pg_event_trigger	1	0	0	0	0	0	0
template1.pg_catalog.pg_proc	1	0	0	3,006	0	0	81
nextcloud.pg_catalog.pg_rewrite	1	1	0	131	0	0	12
nextcloud.public.oc_talk_signaling	1	0	0	0	0	0	0
template1.pg_catalog.pg_auth_members	1	0	0	3	0	0	1
template1.pg_catalog.pg_description	1	0	0	4,776	0	0	42
template0.pg_catalog.pg_type	1	0	0	411	0	0	10
template0.pg_catalog.pg_shdepend	1	0	0	236	0	0	2
template1.pg_catalog.pg_db_role_setting	1	0	0	0	0	0	0
template0.pg_catalog.pg_init_privs	1	0	0	176	0	0	2
template0.pg_toast.pg_toast_2964	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_statistic_ext	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_3456	1	0	0	0	0	0	0
nextcloud.public.oc_passwords_registration	1	0	0	0	0	0	0
template1.pg_catalog.pg_shseclabel	1	0	0	0	0	0	0
template1.pg_catalog.pg_seclabel	1	0	0	0	0	0	0
template0.pg_toast.pg_toast_6100	1	0	0	0	0	0	0
nextcloud.public.oc_passwords_keychain	1	0	0	8	0	0	1
nextcloud.pg_toast.pg_toast_16575	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_16401	1	0	0	0	0	0	0
nextcloud.public.oc_systemtag	1	0	0	32	0	0	1
template1.pg_catalog.pg_default_acl	1	0	0	0	0	0	0
template0.pg_catalog.pg_description	1	0	0	4,776	0	0	42
template1.pg_catalog.pg_am	1	0	0	7	0	0	1
template1.pg_catalog.pg_subscription	1	0	0	0	0	0	0
template1.pg_catalog.pg_ts_config	1	0	0	23	0	0	1
nextcloud.public.oc_music_bookmarks	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_1260	1	0	0	0	0	0	0
nextcloud.public.oc_groups	1	0	0	2	0	0	1
template1.pg_catalog.pg_amproc	1	0	0	483	0	0	4
nextcloud.public.oc_group_admin	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_2328	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_16985	1	0	0	0	0	0	0
template0.pg_catalog.pg_am	1	0	0	7	0	0	1
nextcloud.pg_catalog.pg_cast	1	0	0	224	0	0	2
template0.pg_catalog.pg_foreign_server	1	0	0	0	0	0	0
template1.pg_catalog.pg_tablespace	1	0	0	2	0	0	1
template1.pg_catalog.pg_user_mapping	1	0	0	0	0	0	0
nextcloud.public.oc_collres_collections	1	0	0	3	0	0	1
nextcloud.public.oc_passwords_pw_tag_rel	1	0	0	17	0	0	1
nextcloud.pg_catalog.pg_auth_members	1	0	0	3	0	0	1
nextcloud.pg_toast.pg_toast_13305	1	0	0	0	0	0	0
nextcloud.pg_catalog.pg_default_acl	1	0	0	0	0	0	0
template1.pg_toast.pg_toast_2618	1	0	0	261	0	0	60
nextcloud.public.oc_music_podcast_channels	1	0	0	0	0	0	0
template0.pg_catalog.pg_ts_dict	1	0	0	23	0	0	1
nextcloud.pg_toast.pg_toast_1262	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_13295	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_16532	1	0	0	0	0	0	0
template0.pg_catalog.pg_ts_template	1	0	0	5	0	0	1
nextcloud.pg_toast.pg_toast_17408	1	0	0	0	0	0	0
nextcloud.public.oc_calendar_resources	1	0	0	0	0	0	0
nextcloud.pg_toast.pg_toast_16728	1	0	0	0	0	0	0
template0.information_schema.sql_implementation_info	1	0	0	12	0	0	1
nextcloud.public.oc_announcements_map	1	0	0	29	0	0	1
nextcloud.pg_toast.pg_toast_1255	1	0	0	0	0	0	0
template0.pg_catalog.pg_shseclabel	1	0	0	0	0	0	0
Total	1,676	921	235,833	3,489,860	10,049	9	373,500

Pages removed per table

Key values

pg_toast.pg_toast_17483 (7) Main table with removed pages on database nextcloud
9 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
nextcloud.pg_toast.pg_toast_17483	1	1	20	7
nextcloud.public.oc_directlink	1	1	19	1
nextcloud.public.oc_twofactor_u2f_registrations	1	1	10	1
nextcloud.pg_toast.pg_toast_3596	1	0	0	0
nextcloud.pg_toast.pg_toast_16808	1	0	0	0
template0.pg_toast.pg_toast_3381	1	0	0	0
nextcloud.public.oc_calendar_resources_md	1	0	0	0
template0.pg_toast.pg_toast_2619	1	0	0	0
template0.pg_catalog.pg_statistic_ext_data	1	0	0	0
nextcloud.pg_toast.pg_toast_17087	1	0	0	0
nextcloud.pg_toast.pg_toast_17063	1	0	0	0
template0.pg_toast.pg_toast_2618	1	0	0	0
nextcloud.pg_toast.pg_toast_16953	1	0	0	0
template0.pg_toast.pg_toast_1247	1	0	0	0
nextcloud.pg_catalog.pg_init_privs	1	1	0	0
nextcloud.pg_toast.pg_toast_13300	1	0	0	0
template0.pg_toast.pg_toast_6000	1	0	0	0
nextcloud.public.oc_bruteforce_attempts	1	1	155	0
template0.pg_catalog.pg_policy	1	0	0	0
template1.pg_toast.pg_toast_2615	1	0	0	0
template0.pg_catalog.pg_statistic	1	0	0	0
template1.pg_catalog.pg_database	1	0	1	0
template0.pg_catalog.pg_replication_origin	1	0	0	0
template0.pg_catalog.pg_operator	1	0	0	0
template1.pg_catalog.pg_ts_template	1	0	0	0
template1.pg_catalog.pg_statistic_ext_data	1	0	0	0
nextcloud.public.oc_flow_operations	1	0	0	0
template0.pg_toast.pg_toast_1262	1	0	0	0
nextcloud.pg_toast.pg_toast_3456	1	0	0	0
nextcloud.pg_catalog.pg_subscription	1	0	0	0
nextcloud.pg_toast.pg_toast_16540	1	0	0	0
nextcloud.public.oc_user_status	2	2	52	0
nextcloud.pg_toast.pg_toast_17295	1	0	0	0
template1.pg_catalog.pg_attribute	1	0	0	0
nextcloud.public.oc_talk_commands	1	0	0	0
nextcloud.public.oc_calendarchanges	3	3	13519	0
nextcloud.pg_toast.pg_toast_6000	1	0	0	0
template1.pg_catalog.pg_attrdef	1	0	0	0
template1.pg_toast.pg_toast_3350	1	0	0	0
template1.pg_catalog.pg_foreign_table	1	0	0	0
nextcloud.pg_catalog.pg_ts_config	1	0	0	0
template1.pg_toast.pg_toast_3118	1	0	0	0
nextcloud.pg_toast.pg_toast_3592	1	0	0	0
template0.pg_toast.pg_toast_3429	1	0	0	0
template1.pg_catalog.pg_type	1	0	0	0
nextcloud.pg_toast.pg_toast_17308	1	0	0	0
nextcloud.public.oc_user_transfer_owner	1	0	0	0
template0.pg_toast.pg_toast_826	1	0	0	0
nextcloud.pg_toast.pg_toast_17162	1	0	0	0
template0.pg_catalog.pg_enum	1	0	0	0
nextcloud.pg_catalog.pg_attrdef	1	0	0	0
template0.pg_toast.pg_toast_1260	1	0	0	0
nextcloud.public.oc_passwords_tag_rv	1	1	1	0
nextcloud.public.oc_known_users	1	0	0	0
nextcloud.pg_catalog.pg_amproc	1	0	0	0
template1.pg_toast.pg_toast_2396	1	0	0	0
nextcloud.public.oc_systemtag_group	1	0	0	0
template0.pg_catalog.pg_ts_config_map	1	0	0	0
nextcloud.public.oc_text_documents	1	1	18	0
nextcloud.public.oc_calendarsubscriptions	161	6	11399	0
template1.pg_toast.pg_toast_3466	1	0	0	0
nextcloud.public.oc_files_trash	1	1	9697	0
template1.pg_catalog.pg_shdepend	1	1	1	0
nextcloud.public.oc_storages_credentials	1	0	0	0
nextcloud.pg_catalog.pg_largeobject_metadata	1	0	0	0
template1.pg_catalog.pg_replication_origin	1	0	0	0
nextcloud.pg_toast.pg_toast_16888	1	0	0	0
nextcloud.pg_catalog.pg_publication	1	0	0	0
nextcloud.pg_catalog.pg_authid	1	0	0	0
nextcloud.pg_toast.pg_toast_17514	1	0	0	0
template1.pg_catalog.pg_range	1	0	0	0
nextcloud.pg_catalog.pg_constraint	1	0	0	0
nextcloud.public.oc_federated_reshares	1	0	0	0
nextcloud.pg_toast.pg_toast_17055	1	0	0	0
template0.pg_catalog.pg_language	1	0	0	0
template0.pg_toast.pg_toast_2396	1	0	0	0
template0.pg_toast.pg_toast_3600	1	0	0	0
template1.pg_toast.pg_toast_3596	1	0	0	0
nextcloud.pg_toast.pg_toast_17148	1	0	0	0
nextcloud.pg_toast.pg_toast_2964	1	0	0	0
nextcloud.pg_toast.pg_toast_17004	1	0	0	0
template0.pg_toast.pg_toast_2328	1	0	0	0
nextcloud.pg_toast.pg_toast_3429	1	0	0	0
template0.pg_toast.pg_toast_1418	1	0	0	0
template1.pg_catalog.pg_largeobject	1	0	0	0
template0.pg_catalog.pg_inherits	1	0	0	0
nextcloud.pg_catalog.pg_operator	1	0	0	0
template0.pg_catalog.pg_constraint	1	0	0	0
nextcloud.pg_catalog.pg_type	1	1	16	0
nextcloud.pg_toast.pg_toast_16450	1	0	0	0
template1.pg_catalog.pg_language	1	0	0	0
nextcloud.pg_toast.pg_toast_17195	1	0	0	0
template0.pg_catalog.pg_event_trigger	1	0	0	0
nextcloud.pg_catalog.pg_class	1	1	19	0
nextcloud.public.oc_oauth2_access_tokens	1	0	0	0
template1.pg_toast.pg_toast_1418	1	0	0	0
template1.pg_catalog.pg_operator	1	0	0	0
template0.pg_toast.pg_toast_2604	1	0	0	0
nextcloud.pg_toast.pg_toast_17344	1	0	0	0
nextcloud.public.oc_music_artists	1	1	29	0
nextcloud.pg_toast.pg_toast_13310	1	0	0	0
nextcloud.information_schema.sql_features	1	0	0	0
nextcloud.pg_toast.pg_toast_3118	1	0	0	0
nextcloud.public.oc_oauth2_clients	1	0	0	0
template0.pg_toast.pg_toast_2606	1	0	0	0
nextcloud.public.oc_users	1	1	4	0
nextcloud.public.oc_addressbooks	1	1	93	0
template1.pg_catalog.pg_ts_dict	1	0	0	0
nextcloud.pg_toast.pg_toast_17016	1	0	0	0
nextcloud.public.oc_music_tracks	1	1	37	0
template1.pg_toast.pg_toast_2619	1	1	8	0
template1.information_schema.sql_parts	1	0	0	0
template0.pg_toast.pg_toast_3394	1	0	0	0
nextcloud.public.oc_passwords_password_rv	1	1	21	0
template0.pg_toast.pg_toast_13295	1	0	0	0
template1.pg_toast.pg_toast_1417	1	0	0	0
nextcloud.public.oc_activity	1	1	34910	0
nextcloud.pg_toast.pg_toast_16686	1	0	0	0
nextcloud.pg_toast.pg_toast_2604	1	0	0	0
nextcloud.pg_toast.pg_toast_2328	1	0	0	0
template1.pg_toast.pg_toast_3256	1	0	0	0
template0.pg_toast.pg_toast_3256	1	0	0	0
template1.pg_catalog.pg_trigger	1	0	0	0
template1.pg_catalog.pg_statistic	1	0	0	0
template0.pg_catalog.pg_subscription_rel	1	0	0	0
template1.pg_catalog.pg_event_trigger	1	0	0	0
nextcloud.pg_catalog.pg_shdepend	1	0	0	0
template1.pg_catalog.pg_ts_config_map	1	0	0	0
template1.pg_catalog.pg_subscription_rel	1	0	0	0
nextcloud.pg_catalog.pg_database	1	0	0	0
nextcloud.public.oc_flow_operations_scope	1	0	0	0
template1.pg_toast.pg_toast_826	1	0	0	0
nextcloud.public.oc_share_external	1	1	6	0
template0.pg_catalog.pg_depend	1	0	0	0
nextcloud.pg_toast.pg_toast_3350	1	0	0	0
template0.pg_catalog.pg_statistic_ext	1	0	0	0
nextcloud.public.oc_passwords_tag	1	1	1	0
nextcloud.public.oc_passwords_challenge	1	0	0	0
template0.pg_catalog.pg_partitioned_table	1	0	0	0
nextcloud.public.oc_talk_participants	1	0	0	0
nextcloud.pg_catalog.pg_description	1	0	0	0
template0.pg_catalog.pg_namespace	1	0	0	0
template0.pg_catalog.pg_publication	1	0	0	0
template1.pg_toast.pg_toast_6100	1	0	0	0
nextcloud.pg_catalog.pg_subscription_rel	1	0	0	0
nextcloud.pg_catalog.pg_partitioned_table	1	0	0	0
template0.pg_toast.pg_toast_2620	1	0	0	0
nextcloud.pg_toast.pg_toast_17492	1	0	0	0
template1.pg_toast.pg_toast_1213	1	0	0	0
nextcloud.pg_toast.pg_toast_17579	1	0	0	0
template1.pg_toast.pg_toast_3592	1	0	0	0
nextcloud.public.oc_mimetypes	1	0	0	0
template1.pg_toast.pg_toast_2612	1	0	0	0
nextcloud.public.oc_appconfig	24	24	2688	0
nextcloud.pg_toast.pg_toast_3381	1	0	0	0
template1.pg_catalog.pg_authid	1	0	0	0
nextcloud.pg_catalog.pg_index	1	1	1	0
nextcloud.pg_catalog.pg_amop	1	0	0	0
nextcloud.public.oc_text_sessions	10	10	95	0
nextcloud.pg_catalog.pg_range	1	0	0	0
template0.pg_toast.pg_toast_1417	1	0	0	0
nextcloud.pg_toast.pg_toast_17035	1	0	0	0
template1.pg_toast.pg_toast_13295	1	0	0	0
template0.pg_toast.pg_toast_13305	1	0	0	0
nextcloud.pg_toast.pg_toast_1260	1	0	0	0
nextcloud.pg_catalog.pg_user_mapping	1	0	0	0
template0.pg_toast.pg_toast_3079	1	0	0	0
nextcloud.pg_catalog.pg_foreign_table	1	0	0	0
nextcloud.pg_catalog.pg_transform	1	0	0	0
nextcloud.public.oc_music_playlists	1	0	0	0
template1.pg_catalog.pg_rewrite	1	0	0	0
nextcloud.pg_toast.pg_toast_826	1	0	0	0
nextcloud.pg_toast.pg_toast_17224	1	0	0	0
nextcloud.pg_catalog.pg_tablespace	1	0	0	0
nextcloud.pg_toast.pg_toast_17363	1	0	0	0
template0.pg_toast.pg_toast_2615	1	0	0	0
template1.pg_catalog.pg_sequence	1	0	0	0
nextcloud.public.oc_migrations	1	0	0	0
nextcloud.pg_toast.pg_toast_17254	1	0	0	0
nextcloud.pg_catalog.pg_enum	1	0	0	0
template1.pg_toast.pg_toast_1255	1	0	0	0
template1.pg_catalog.pg_class	1	0	0	0
nextcloud.pg_toast.pg_toast_16504	1	0	0	0
nextcloud.pg_catalog.pg_publication_rel	1	0	0	0
nextcloud.pg_toast.pg_toast_16523	1	0	0	0
nextcloud.pg_catalog.pg_depend	1	1	21	0
nextcloud.pg_toast.pg_toast_17392	1	0	0	0
nextcloud.pg_toast.pg_toast_1417	1	0	0	0
nextcloud.public.oc_calendar_rooms_md	1	0	0	0
template1.pg_catalog.pg_foreign_data_wrapper	1	0	0	0
template1.pg_toast.pg_toast_1247	1	0	0	0
template1.pg_catalog.pg_largeobject_metadata	1	0	0	0
nextcloud.public.oc_accounts	1	1	8	0
nextcloud.public.oc_passwords_folder_rv	1	0	0	0
nextcloud.public.oc_systemtag_object_mapping	1	0	0	0
nextcloud.pg_toast.pg_toast_16491	1	0	0	0
nextcloud.pg_toast.pg_toast_16617	1	0	0	0
nextcloud.public.oc_termsofservice_terms	1	0	0	0
nextcloud.pg_toast.pg_toast_17535	1	0	0	0
nextcloud.public.oc_collres_resources	1	0	0	0
nextcloud.public.oc_quicknotes_tags	1	0	0	0
nextcloud.public.oc_talk_guests	1	0	0	0
nextcloud.pg_catalog.pg_shseclabel	1	0	0	0
template1.pg_toast.pg_toast_3079	1	0	0	0
template0.pg_toast.pg_toast_3456	1	0	0	0
template0.pg_catalog.pg_range	1	0	0	0
template1.pg_catalog.pg_foreign_server	1	0	0	0
nextcloud.pg_catalog.pg_language	1	0	0	0
nextcloud.pg_catalog.pg_aggregate	1	0	0	0
nextcloud.public.oc_jobs	449	273	40431	0
template1.pg_toast.pg_toast_3394	1	0	0	0
nextcloud.pg_toast.pg_toast_17425	1	0	0	0
nextcloud.pg_catalog.pg_attribute	1	1	23	0
template0.pg_toast.pg_toast_2612	1	0	0	0
template0.pg_catalog.pg_ts_parser	1	0	0	0
template0.pg_catalog.pg_opclass	1	0	0	0
template0.pg_catalog.pg_collation	1	0	0	0
nextcloud.pg_toast.pg_toast_16418	1	0	0	0
nextcloud.pg_toast.pg_toast_17136	1	0	0	0
nextcloud.public.oc_mounts	1	1	6	0
template1.pg_catalog.pg_publication	1	0	0	0
nextcloud.public.oc_calendar_invitations	1	1	0	0
nextcloud.public.oc_schedulingobjects	1	0	0	0
nextcloud.pg_catalog.pg_opfamily	1	0	0	0
template0.pg_catalog.pg_rewrite	1	0	0	0
template0.pg_catalog.pg_proc	1	0	0	0
template1.pg_toast.pg_toast_1262	1	0	0	0
template1.pg_toast.pg_toast_6000	1	0	0	0
nextcloud.pg_toast.pg_toast_17456	1	0	0	0
template0.pg_catalog.pg_cast	1	0	0	0
template0.pg_catalog.pg_sequence	1	0	0	0
template1.pg_catalog.pg_index	1	0	0	0
nextcloud.public.oc_twofactor_totp_secrets	1	1	0	0
template0.pg_catalog.pg_extension	1	0	0	0
template1.pg_toast.pg_toast_3429	1	0	0	0
template0.pg_toast.pg_toast_3466	1	0	0	0
template0.pg_toast.pg_toast_1255	1	0	0	0
nextcloud.pg_catalog.pg_am	1	0	0	0
nextcloud.pg_toast.pg_toast_2618	1	0	0	0
template1.pg_catalog.pg_statistic_ext	1	0	0	0
nextcloud.pg_toast.pg_toast_16592	1	1	965	0
nextcloud.public.oc_passwords_password	1	1	0	0
template1.pg_toast.pg_toast_13305	1	0	0	0
template0.pg_toast.pg_toast_3592	1	0	0	0
nextcloud.pg_catalog.pg_sequence	1	0	10	0
template1.pg_toast.pg_toast_13300	1	0	0	0
nextcloud.pg_catalog.pg_conversion	1	0	0	0
template0.pg_catalog.pg_trigger	1	0	0	0
template1.pg_catalog.pg_namespace	1	0	0	0
template1.pg_toast.pg_toast_2600	1	0	0	0
nextcloud.pg_toast.pg_toast_2606	1	0	0	0
nextcloud.pg_catalog.pg_proc	1	1	0	0
nextcloud.pg_toast.pg_toast_2609	1	0	0	0
nextcloud.pg_toast.pg_toast_16513	1	0	0	0
nextcloud.pg_toast.pg_toast_16876	1	0	0	0
nextcloud.pg_toast.pg_toast_3256	1	0	0	0
nextcloud.pg_toast.pg_toast_17209	1	0	0	0
template0.pg_catalog.pg_index	1	0	0	0
template0.pg_catalog.pg_attrdef	1	0	0	0
nextcloud.information_schema.sql_implementation_info	1	0	0	0
nextcloud.pg_toast.pg_toast_3600	1	0	0	0
nextcloud.pg_catalog.pg_policy	1	0	0	0
nextcloud.public.oc_talk_rooms	1	0	0	0
template0.pg_toast.pg_toast_3596	1	0	0	0
nextcloud.pg_toast.pg_toast_2600	1	0	0	0
nextcloud.pg_catalog.pg_shdescription	1	0	0	0
nextcloud.public.oc_quicknotes_attach	1	0	0	0
nextcloud.pg_toast.pg_toast_16437	1	0	0	0
template0.pg_catalog.pg_amop	1	0	0	0
template0.pg_catalog.pg_aggregate	1	0	0	0
nextcloud.pg_toast.pg_toast_16553	1	0	0	0
nextcloud.pg_toast.pg_toast_16965	1	0	0	0
nextcloud.pg_catalog.pg_inherits	1	0	0	0
nextcloud.public.oc_quicknotes_notes	1	1	29	0
template0.pg_toast.pg_toast_2609	1	0	0	0
nextcloud.information_schema.sql_sizing	1	0	0	0
template0.pg_toast.pg_toast_3118	1	0	0	0
nextcloud.public.oc_notifications_pushtokens	1	1	7	0
template1.pg_catalog.pg_policy	1	0	0	0
template1.pg_catalog.pg_init_privs	1	0	0	0
template0.pg_catalog.pg_user_mapping	1	0	0	0
nextcloud.public.oc_vcategory_to_object	1	1	8	0
template1.pg_catalog.pg_collation	1	0	0	0
nextcloud.pg_toast.pg_toast_16800	1	0	0	0
nextcloud.public.oc_comments_read_markers	1	1	0	0
template1.pg_catalog.pg_ts_parser	1	0	0	0
template0.pg_toast.pg_toast_13310	1	0	0	0
template1.pg_catalog.pg_transform	1	0	0	0
template0.pg_catalog.pg_amproc	1	0	0	0
nextcloud.pg_toast.pg_toast_16562	1	0	0	0
nextcloud.pg_toast.pg_toast_16786	1	0	0	0
template0.pg_catalog.pg_class	1	0	0	0
template0.pg_catalog.pg_db_role_setting	1	0	0	0
nextcloud.public.oc_calendars	1	1	94	0
nextcloud.pg_toast.pg_toast_2619	361	361	57924	0
template0.pg_toast.pg_toast_2600	1	0	0	0
nextcloud.pg_toast.pg_toast_1247	1	0	0	0
nextcloud.public.oc_calendar_appt_bookings	1	0	0	0
template1.information_schema.sql_features	1	0	0	0
nextcloud.pg_catalog.pg_ts_dict	1	0	0	0
nextcloud.information_schema.sql_parts	1	0	0	0
nextcloud.public.oc_quicknotes_shares	1	0	0	0
nextcloud.pg_toast.pg_toast_3394	1	0	0	0
template0.pg_toast.pg_toast_1213	1	0	0	0
nextcloud.pg_toast.pg_toast_17071	1	0	0	0
nextcloud.public.oc_twofactor_providers	1	1	8	0
nextcloud.pg_toast.pg_toast_2620	1	0	0	0
nextcloud.pg_toast.pg_toast_16717	1	0	0	0
template1.pg_catalog.pg_depend	1	0	0	0
nextcloud.pg_catalog.pg_opclass	1	0	0	0
template0.pg_catalog.pg_publication_rel	1	0	0	0
template1.pg_toast.pg_toast_2964	1	0	0	0
template1.pg_toast.pg_toast_3600	1	0	0	0
template0.information_schema.sql_parts	1	0	0	0
nextcloud.public.oc_music_radio_stations	1	0	0	0
nextcloud.public.oc_music_ampache_sessions	1	0	0	0
nextcloud.pg_toast.pg_toast_2612	1	0	0	0
template0.pg_catalog.pg_transform	1	0	0	0
nextcloud.pg_catalog.pg_foreign_server	1	0	0	0
nextcloud.public.oc_comments	1	1	0	0
nextcloud.pg_catalog.pg_ts_template	1	0	0	0
nextcloud.pg_catalog.pg_ts_config_map	1	0	0	0
nextcloud.public.oc_group_user	1	0	0	0
nextcloud.pg_toast.pg_toast_17101	1	0	0	0
template0.pg_catalog.pg_database	1	0	0	0
nextcloud.public.oc_preferences	1	1	1069	0
template0.pg_catalog.pg_foreign_table	1	0	0	0
nextcloud.pg_catalog.pg_seclabel	1	0	0	0
nextcloud.public.oc_calendar_appt_configs	1	0	0	0
template0.pg_catalog.pg_authid	1	0	0	0
template1.pg_catalog.pg_cast	1	0	0	0
nextcloud.public.oc_ratelimit_entries	1	0	0	0
nextcloud.pg_toast.pg_toast_17319	1	0	0	0
template1.pg_toast.pg_toast_2620	1	0	0	0
template1.pg_toast.pg_toast_2604	1	0	0	0
template1.pg_catalog.pg_opfamily	1	0	0	0
template1.pg_toast.pg_toast_13310	1	0	0	0
nextcloud.pg_toast.pg_toast_3079	1	0	0	0
nextcloud.pg_toast.pg_toast_2615	1	0	0	0
nextcloud.public.oc_properties	1	1	51	0
nextcloud.pg_catalog.pg_foreign_data_wrapper	1	0	0	0
nextcloud.pg_toast.pg_toast_16387	1	0	0	0
nextcloud.pg_toast.pg_toast_16634	1	0	0	0
nextcloud.pg_toast.pg_toast_16856	1	0	0	0
nextcloud.public.oc_quicknotes_colors	1	0	0	0
nextcloud.public.oc_music_ampache_users	1	0	0	0
nextcloud.pg_catalog.pg_statistic	22	19	5969	0
template1.pg_catalog.pg_conversion	1	0	0	0
template1.pg_toast.pg_toast_2606	1	0	0	0
nextcloud.pg_toast.pg_toast_16465	1	0	0	0
template0.pg_catalog.pg_subscription	1	0	0	0
nextcloud.pg_catalog.pg_db_role_setting	1	0	0	0
nextcloud.public.oc_privacy_admins	1	0	0	0
template1.pg_toast.pg_toast_3381	1	0	0	0
template0.pg_catalog.pg_tablespace	1	0	0	0
template0.pg_catalog.pg_conversion	1	0	0	0
nextcloud.pg_toast.pg_toast_3466	1	0	0	0
nextcloud.public.oc_storages	1	1	39	0
nextcloud.pg_catalog.pg_statistic_ext_data	1	0	0	0
nextcloud.pg_toast.pg_toast_6100	1	0	0	0
nextcloud.public.oc_notifications	1	1	79	0
template1.pg_catalog.pg_enum	1	0	0	0
nextcloud.pg_catalog.pg_replication_origin	1	0	0	0
nextcloud.public.oc_passwords_folder	1	0	0	0
template0.pg_toast.pg_toast_3350	1	0	0	0
nextcloud.public.oc_music_podcast_episodes	1	0	0	0
template1.pg_toast.pg_toast_2609	1	0	0	0
template0.information_schema.sql_features	1	0	0	0
nextcloud.pg_catalog.pg_ts_parser	1	0	0	0
template0.pg_catalog.pg_ts_config	1	0	0	0
nextcloud.pg_catalog.pg_trigger	1	0	0	0
template1.pg_catalog.pg_inherits	1	0	0	0
template1.information_schema.sql_implementation_info	1	0	0	0
template0.pg_catalog.pg_opfamily	1	0	0	0
nextcloud.pg_catalog.pg_largeobject	1	0	0	0
nextcloud.public.oc_webauthn	1	1	2	0
nextcloud.pg_toast.pg_toast_17445	1	0	0	0
template0.pg_catalog.pg_foreign_data_wrapper	1	0	0	0
nextcloud.pg_toast.pg_toast_2396	1	0	0	0
template1.pg_catalog.pg_aggregate	1	0	0	0
template1.pg_catalog.pg_publication_rel	1	0	0	0
nextcloud.pg_toast.pg_toast_17174	1	0	0	0
nextcloud.pg_toast.pg_toast_16757	1	0	0	0
template0.pg_toast.pg_toast_13300	1	0	0	0
template0.pg_catalog.pg_attribute	1	0	0	0
nextcloud.public.oc_announcements	1	0	0	0
template0.pg_catalog.pg_largeobject	1	0	0	0
nextcloud.pg_toast.pg_toast_1213	1	0	0	0
template0.pg_catalog.pg_largeobject_metadata	1	0	0	0
template0.pg_catalog.pg_shdescription	1	0	0	0
nextcloud.public.oc_flow_checks	1	0	0	0
nextcloud.pg_toast.pg_toast_1418	1	0	0	0
template1.pg_catalog.pg_partitioned_table	1	0	0	0
template0.information_schema.sql_sizing	1	0	0	0
nextcloud.public.oc_whats_new	1	0	28	0
nextcloud.public.oc_calendar_rooms	1	0	0	0
template0.pg_catalog.pg_seclabel	1	0	0	0
nextcloud.pg_catalog.pg_namespace	1	0	0	0
nextcloud.public.oc_dav_cal_proxy	1	0	0	0
nextcloud.pg_toast.pg_toast_17571	1	0	0	0
template1.information_schema.sql_sizing	1	0	0	0
template0.pg_catalog.pg_default_acl	1	0	0	0
template1.pg_catalog.pg_constraint	1	0	0	0
template0.pg_catalog.pg_auth_members	1	0	0	0
nextcloud.public.oc_trusted_servers	1	0	0	0
template1.pg_catalog.pg_opclass	1	0	0	0
template1.pg_catalog.pg_amop	1	0	0	0
nextcloud.pg_toast.pg_toast_17047	1	0	0	0
nextcloud.pg_catalog.pg_collation	1	0	0	0
nextcloud.pg_toast.pg_toast_17525	1	0	0	0
template1.pg_catalog.pg_shdescription	1	0	0	0
nextcloud.public.oc_passwords_share	1	0	0	0
nextcloud.pg_toast.pg_toast_17120	1	1	1	0
template1.pg_catalog.pg_extension	1	0	0	0
nextcloud.pg_catalog.pg_event_trigger	1	0	0	0
template1.pg_catalog.pg_proc	1	0	0	0
nextcloud.pg_catalog.pg_rewrite	1	1	0	0
nextcloud.public.oc_talk_signaling	1	0	0	0
template1.pg_catalog.pg_auth_members	1	0	0	0
template1.pg_catalog.pg_description	1	0	0	0
template0.pg_catalog.pg_type	1	0	0	0
nextcloud.public.oc_twofactor_backupcodes	1	1	19	0
template0.pg_catalog.pg_shdepend	1	0	0	0
template1.pg_catalog.pg_db_role_setting	1	0	0	0
template0.pg_catalog.pg_init_privs	1	0	0	0
template0.pg_toast.pg_toast_2964	1	0	0	0
nextcloud.pg_catalog.pg_statistic_ext	1	0	0	0
template1.pg_toast.pg_toast_3456	1	0	0	0
nextcloud.public.oc_authtoken	167	167	27859	0
nextcloud.public.oc_passwords_registration	1	0	0	0
template1.pg_catalog.pg_shseclabel	1	0	0	0
template1.pg_catalog.pg_seclabel	1	0	0	0
template0.pg_toast.pg_toast_6100	1	0	0	0
nextcloud.public.oc_passwords_keychain	1	0	0	0
nextcloud.public.oc_quicknotes_note_tags	1	1	3	0
nextcloud.pg_toast.pg_toast_16575	1	0	0	0
nextcloud.pg_toast.pg_toast_16401	1	0	0	0
nextcloud.public.oc_systemtag	1	0	0	0
template1.pg_catalog.pg_default_acl	1	0	0	0
template0.pg_catalog.pg_description	1	0	0	0
template1.pg_catalog.pg_am	1	0	0	0
template1.pg_catalog.pg_subscription	1	0	0	0
template1.pg_catalog.pg_ts_config	1	0	0	0
nextcloud.public.oc_music_bookmarks	1	0	0	0
template1.pg_toast.pg_toast_1260	1	0	0	0
nextcloud.public.oc_music_genres	1	0	19	0
nextcloud.public.oc_groups	1	0	0	0
template1.pg_catalog.pg_amproc	1	0	0	0
nextcloud.public.oc_group_admin	1	0	0	0
template1.pg_toast.pg_toast_2328	1	0	0	0
nextcloud.pg_toast.pg_toast_16985	1	0	0	0
template0.pg_catalog.pg_am	1	0	0	0
nextcloud.pg_catalog.pg_cast	1	0	0	0
template0.pg_catalog.pg_foreign_server	1	0	0	0
nextcloud.public.oc_share	1	1	12	0
template1.pg_catalog.pg_tablespace	1	0	0	0
template1.pg_catalog.pg_user_mapping	1	0	0	0
nextcloud.public.oc_collres_collections	1	0	0	0
nextcloud.public.oc_calendarobjects_props	3	3	17903	0
nextcloud.pg_catalog.pg_extension	1	0	4	0
nextcloud.public.oc_passwords_pw_tag_rel	1	0	0	0
nextcloud.pg_catalog.pg_auth_members	1	0	0	0
nextcloud.pg_toast.pg_toast_13305	1	0	0	0
nextcloud.pg_catalog.pg_default_acl	1	0	0	0
template1.pg_toast.pg_toast_2618	1	0	0	0
nextcloud.public.oc_music_podcast_channels	1	0	0	0
template0.pg_catalog.pg_ts_dict	1	0	0	0
nextcloud.pg_toast.pg_toast_1262	1	0	0	0
nextcloud.pg_toast.pg_toast_13295	1	0	0	0
nextcloud.pg_toast.pg_toast_16532	1	0	0	0
template0.pg_catalog.pg_ts_template	1	0	0	0
nextcloud.public.oc_addressbookchanges	1	1	7	0
nextcloud.pg_toast.pg_toast_17408	1	0	0	0
nextcloud.public.oc_calendar_resources	1	0	0	0
nextcloud.pg_toast.pg_toast_16728	1	0	0	0
template0.information_schema.sql_implementation_info	1	0	0	0
nextcloud.public.oc_announcements_map	1	0	0	0
nextcloud.public.oc_vcategory	1	1	6	0
nextcloud.pg_toast.pg_toast_1255	1	0	0	0
nextcloud.public.oc_calendarobjects	4	4	10409	0
template0.pg_catalog.pg_shseclabel	1	0	0	0
Total	1,676	921	235,833	9

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
May 25	15	15	34
	16	39	105
	17	36	106
	18	39	107
	19	37	104
	20	33	102
	21	34	103
	22	34	132
	23	32	137
May 26	00	37	127
	01	31	120
	02	63	93
	03	30	114
	04	25	127
	05	30	143
	06	31	124
	07	35	147
	08	38	150
	09	39	143
	10	50	155
	11	59	155
	12	41	143
	13	524	156
	14	45	152
	15	45	153
	16	43	151
	17	45	150
	18	55	151
	19	37	151
	20	44	145
	21	30	114

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

ShareLock Main Lock Type
28,169 locks Total

Chart
Table

Type	Object	Count	Total Duration	Average Duration (s)
ExclusiveLock		4,879	2h35m49s	1s916ms
	tuple	4,879	2h35m49s	1s916ms
ShareLock		23,290	13h22m	2s66ms
	transaction	23,290	13h22m	2s66ms
	Total	28,169	15h57m49s	2s40ms

Most frequent waiting queries (N)


Date: 2022-05-26 02:34:24
Database: nextcloud
User: nextcloud
Remote: ::1
Application: [unknown]
Bind query: yes
Date: 2022-05-26 02:33:28
Database: nextcloud
User: nextcloud
Remote: ::1
Application: [unknown]
Bind query: yes
Date: 2022-05-26 13:24:52
Database: nextcloud
User: nextcloud
Remote: ::1
Application: [unknown]
Date: 2022-05-26 02:30:47
Database: nextcloud
User: nextcloud
Remote: ::1
Application: [unknown]
Bind query: yes
Date: 2022-05-26 15:50:34
Database: nextcloud
User: nextcloud
Remote: ::1
Application: [unknown]
Date: 2022-05-25 15:42:56
Database: nextcloud
User: nextcloud
Remote: ::1
Application: [unknown]
Date: 2022-05-26 13:19:06
Database: nextcloud
User: nextcloud
Remote: ::1
Application: [unknown]
Date: 2022-05-26 19:44:46
Database: nextcloud
User: nextcloud
Remote: ::1
Application: [unknown]

Rank	Count	Total time	Min time	Max time	Avg duration	Query
1	28,128	15h56m29s	1s	22s74ms	2s40ms	update "oc_jobs" set "reserved_at" = ?, "last_checked" = ? where ("class" = ?) and ("argument_hash" = ?); UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = '1653524849' WHERE ("class" = 'OC\BackgroundJob\Legacy\RegularJob') AND ("argument_hash" = '7163eea8efcbe5d300e3485a2e6f3590'); Date: 2022-05-26 02:34:24 Database: nextcloud User: nextcloud Remote: ::1 Application: [unknown] Bind query: yes UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = '1653524741' WHERE ("class" = 'OC\BackgroundJob\Legacy\RegularJob') AND ("argument_hash" = '7163eea8efcbe5d300e3485a2e6f3590'); Date: 2022-05-26 02:31:08 Database: nextcloud User: nextcloud Remote: ::1 Application: [unknown] Bind query: yes UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = '1653524962' WHERE ("class" = 'OC\BackgroundJob\Legacy\RegularJob') AND ("argument_hash" = '7163eea8efcbe5d300e3485a2e6f3590'); Date: 2022-05-26 02:34:34 Database: nextcloud User: nextcloud Remote: ::1 Application: [unknown] Bind query: yes
2	24	46s807ms	1s19ms	5s972ms	1s950ms	update "oc_authtoken" set "password" = ? where "id" = ?; UPDATE "oc_authtoken" SET "password" = 'ZTG63Cc5rkCOtXwHIr9tSVhmZ9P1dbtuDG6sL/wyd276zyAsLTv+T96TJ7kRdGKYg2u0C2cY7E9m1geRQOpm/O8b1RVNUEaRhK4vUEo/FgDrgw1Dj7GhL/WqIPR6Y06aQkXO53CMBsshVlQjRK0P4GADv24fVL9uvzHafmXTYfNuADJrr9RcHsJDs3rvXHdu2oPqO9ZcH66o4cBr7nXWXQz3pN3kZ2mNuoIe2T+v0tDUVBmuaFkaDLgW97xEERavXk02ne34jZr9p9/dX8Zc72SV8iJtoC4k/sKFumENXBXmbhrtWFAH+lJdi++035DQF+MWgtO0CSmQr/gj6jwVPg==' WHERE "id" = '284405'; Date: 2022-05-26 02:33:28 Database: nextcloud User: nextcloud Remote: ::1 Application: [unknown] Bind query: yes UPDATE "oc_authtoken" SET "password" = 'L9XuVf95pRbUa8NVVe8/hYRCTcObm+gGZIdBbT9zKD3aQy5n6d5l5oDp73PyeXggRSaTtKNRui2+XDBDUNQzIv6rM5WDc1gEOM/eXDILxySVztXO7C/OhxdM2ib5lnkt6O98x6yMntvgbUKnLr/jFoh1oOtMAcsTy1ZigF5nHmZX7OKlkSDNNHEDr+G1feKz4zTNwsTOhCcuPWsaZh8ABbZMFyGiSqOT9sE9fXgyOoFOG61YQLR5Gulv7Q3vGIRXpcoj+fobyk55LQm9AmanHNYKoH8y+Lo4qg/5EzUg/lOqDgZ/3KAJbChfBUdPwDIPZcNYbgW8VLh1joNc3ejAdQ==' WHERE "id" = '287527'; Date: 2022-05-26 02:33:14 Database: nextcloud User: nextcloud Remote: ::1 Application: [unknown] Bind query: yes UPDATE "oc_authtoken" SET "password" = $1 WHERE "id" = $2; Date: 2022-05-26 02:33:14 Database: nextcloud User: nextcloud Remote: ::1 Application: [unknown]
3	7	11s138ms	1s1ms	2s212ms	1s591ms	update "oc_filecache" set "mtime" = greatest ("mtime", ?), "etag" = ? where ("storage" = ?) and ("path_hash" in (...)); UPDATE "oc_filecache" SET "mtime" = GREATEST ("mtime", $1), "etag" = $2 WHERE ("storage" = $3) AND ("path_hash" IN ('d41d8cd98f00b204e9800998ecf8427e', '5128f35c9b4be13788ba41bdb6d1fc1f')); Date: 2022-05-26 13:24:52 Database: nextcloud User: nextcloud Remote: ::1 Application: [unknown]
4	2	6s919ms	1s530ms	5s389ms	3s459ms	update "oc_authtoken" set "last_activity" = ? where "id" = ?; UPDATE "oc_authtoken" SET "last_activity" = '1653525041' WHERE "id" = '300623'; Date: 2022-05-26 02:30:47 Database: nextcloud User: nextcloud Remote: ::1 Application: [unknown] Bind query: yes UPDATE "oc_authtoken" SET "last_activity" = $1 WHERE "id" = $2; Date: 2022-05-26 02:30:47 Database: nextcloud User: nextcloud Remote: ::1 Application: [unknown]
5	3	6s910ms	2s231ms	3s593ms	2s303ms	update "oc_preferences" set "configvalue" = ? where ("userid" = ?) and ("appid" = ?) and ("configkey" = ?); UPDATE "oc_preferences" SET "configvalue" = $1 WHERE ("userid" = $2) AND ("appid" = $3) AND ("configkey" = $4); Date: 2022-05-26 15:50:34 Database: nextcloud User: nextcloud Remote: ::1 Application: [unknown]
6	2	2s742ms	1s6ms	1s735ms	1s371ms	update "oc_filecache" set "size" = greatest ("size" + ?, ?) where ("storage" = ?) and ("path_hash" in (...)) and ("size" > ?); UPDATE "oc_filecache" SET "size" = GREATEST ("size" + $1, $2) WHERE ("storage" = $3) AND ("path_hash" IN ('d41d8cd98f00b204e9800998ecf8427e', '45b963397aa40d4a0063e0d85e4fe7a1', '4ba305b143aa731c7d1f2634fe04314f', '0f409a35f0180b95ec2746f13dbb9341')) AND ("size" > '-1'); Date: 2022-05-25 15:42:56 Database: nextcloud User: nextcloud Remote: ::1 Application: [unknown]
7	1	2s589ms	2s589ms	2s589ms	2s589ms	update "oc_filecache" set "mtime" = ?, "storage_mtime" = ? where ("fileid" = ?) and ((("mtime" <> ?) or ("mtime" is null)) or (("storage_mtime" <> ?) or ("storage_mtime" is null))); UPDATE "oc_filecache" SET "mtime" = $1, "storage_mtime" = $2 WHERE ("fileid" = $3) AND ((("mtime" <> $4) OR ("mtime" IS NULL)) OR (("storage_mtime" <> $5) OR ("storage_mtime" IS NULL))); Date: 2022-05-26 13:19:06 Database: nextcloud User: nextcloud Remote: ::1 Application: [unknown]
8	2	2s460ms	1s64ms	1s395ms	1s230ms	update "oc_filecache" set "size" = ? where ("fileid" = ?) and (("size" <> ?) or ("size" is null)); UPDATE "oc_filecache" SET "size" = $1 WHERE ("fileid" = $2) AND (("size" <> $3) OR ("size" IS NULL)); Date: 2022-05-26 19:44:46 Database: nextcloud User: nextcloud Remote: ::1 Application: [unknown]

Queries that waited the most


[ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
[ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
[ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
[ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
[ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
[ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
[ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
[ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
[ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
[ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
[ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
[ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
[ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
[ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
[ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
[ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
[ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
[ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
[ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
[ Date: 2022-05-26 02:28:48 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]

Rank	Wait time	Query
1	22s74ms	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = $1 WHERE ("class" = $2) AND ("argument_hash" = $3); [ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
2	22s74ms	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = $1 WHERE ("class" = $2) AND ("argument_hash" = $3); [ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
3	22s73ms	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = $1 WHERE ("class" = $2) AND ("argument_hash" = $3); [ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
4	22s73ms	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = $1 WHERE ("class" = $2) AND ("argument_hash" = $3); [ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
5	22s73ms	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = $1 WHERE ("class" = $2) AND ("argument_hash" = $3); [ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
6	22s72ms	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = $1 WHERE ("class" = $2) AND ("argument_hash" = $3); [ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
7	22s72ms	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = $1 WHERE ("class" = $2) AND ("argument_hash" = $3); [ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
8	22s72ms	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = $1 WHERE ("class" = $2) AND ("argument_hash" = $3); [ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
9	22s72ms	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = $1 WHERE ("class" = $2) AND ("argument_hash" = $3); [ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
10	22s72ms	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = $1 WHERE ("class" = $2) AND ("argument_hash" = $3); [ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
11	22s72ms	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = $1 WHERE ("class" = $2) AND ("argument_hash" = $3); [ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
12	22s71ms	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = $1 WHERE ("class" = $2) AND ("argument_hash" = $3); [ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
13	22s71ms	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = $1 WHERE ("class" = $2) AND ("argument_hash" = $3); [ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
14	22s71ms	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = $1 WHERE ("class" = $2) AND ("argument_hash" = $3); [ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
15	22s71ms	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = $1 WHERE ("class" = $2) AND ("argument_hash" = $3); [ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
16	22s71ms	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = $1 WHERE ("class" = $2) AND ("argument_hash" = $3); [ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
17	22s71ms	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = $1 WHERE ("class" = $2) AND ("argument_hash" = $3); [ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
18	22s71ms	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = $1 WHERE ("class" = $2) AND ("argument_hash" = $3); [ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
19	22s71ms	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = $1 WHERE ("class" = $2) AND ("argument_hash" = $3); [ Date: 2022-05-26 02:28:27 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]
20	15s597ms	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = $1 WHERE ("class" = $2) AND ("argument_hash" = $3); [ Date: 2022-05-26 02:28:48 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] ]

Queries by type

Key values

6 Total read queries
5,722 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	6	0.10%
INSERT	0	0.00%
UPDATE	5,714	99.76%
DELETE	1	0.02%
COPY FROM	0	0.00%
COPY TO	7	0.12%
CTE	0	0.00%
DDL	0	0.00%
TCL	0	0.00%
CURSOR	0	0.00%

Queries by database

Key values

nextcloud Main database
5,725 Requests
18h29m37s (nextcloud)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
nextcloud	Total	5,725	18h29m37s
	copy to	7	6m41s
	delete	1	35s74ms
	select	3	21s753ms
	update	5,714	18h21m58s
template1	Total	3	13s605ms
	select	3	13s605ms

Queries by user

Key values

nextcloud Main user
5,718 Requests

Queries Chart
Table

User	Request type	Count	Duration
nextcloud	Total	5,718	18h22m55s
	delete	1	35s74ms
	select	3	21s753ms
	update	5,714	18h21m58s
postgres	Total	10	6m55s
	copy to	7	6m41s
	select	3	13s605ms

Duration by user

Key values

18h22m55s (nextcloud) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
nextcloud	Total	5,718	18h22m55s
	delete	1	35s74ms
	select	3	21s753ms
	update	5,714	18h21m58s
postgres	Total	10	6m55s
	copy to	7	6m41s
	select	3	13s605ms

Queries by host

Key values

::1 Main host
5,718 Requests
18h22m55s (::1)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
::1	Total	5,718	18h22m55s
	delete	1	35s74ms
	select	3	21s753ms
	update	5,714	18h21m58s
[local]	Total	10	6m55s
	copy to	7	6m41s
	select	3	13s605ms

Queries by application

Key values

[unknown] Main application
5,718 Requests
18h22m55s ([unknown])
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
[unknown]	Total	5,718	18h22m55s
	delete	1	35s74ms
	select	3	21s753ms
	update	5,714	18h21m58s
pg_dump	Total	10	6m55s
	copy to	7	6m41s
	select	3	13s605ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2022-05-26 13:40:51 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Histogram of query times

Key values

4,299 1000-10000ms duration

Chart
Table

Range	Count	Percentage
0-1ms	0	0.00%
1-5ms	0	0.00%
5-10ms	0	0.00%
10-25ms	0	0.00%
25-50ms	0	0.00%
50-100ms	0	0.00%
100-500ms	0	0.00%
500-1000ms	0	0.00%
1000-10000ms	4,299	75.05%
> 10000ms	1,429	24.95%

Slowest individual queries


[ Date: 2022-05-26 02:34:24 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
[ Date: 2022-05-26 02:31:08 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
[ Date: 2022-05-26 02:34:34 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
[ Date: 2022-05-26 02:27:10 - Database: nextcloud - User: postgres - Remote: [local] - Application: pg_dump ]
[ Date: 2022-05-26 02:32:28 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
[ Date: 2022-05-26 02:32:30 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
[ Date: 2022-05-26 02:32:09 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
[ Date: 2022-05-26 02:30:58 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
[ Date: 2022-05-26 02:30:33 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
[ Date: 2022-05-26 02:35:23 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
[ Date: 2022-05-26 02:31:11 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
[ Date: 2022-05-26 02:32:32 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
[ Date: 2022-05-26 02:31:24 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
[ Date: 2022-05-26 02:30:52 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
[ Date: 2022-05-26 02:30:20 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
[ Date: 2022-05-26 02:31:19 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
[ Date: 2022-05-26 02:34:07 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
[ Date: 2022-05-26 02:31:47 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
[ Date: 2022-05-26 02:34:19 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
[ Date: 2022-05-26 02:32:41 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]

Rank	Duration	Query
1	6m55s	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = '1653524849' WHERE ("class" = 'OC\BackgroundJob\Legacy\RegularJob') AND ("argument_hash" = '7163eea8efcbe5d300e3485a2e6f3590'); [ Date: 2022-05-26 02:34:24 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
2	5m26s	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = '1653524741' WHERE ("class" = 'OC\BackgroundJob\Legacy\RegularJob') AND ("argument_hash" = '7163eea8efcbe5d300e3485a2e6f3590'); [ Date: 2022-05-26 02:31:08 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
3	5m12s	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = '1653524962' WHERE ("class" = 'OC\BackgroundJob\Legacy\RegularJob') AND ("argument_hash" = '7163eea8efcbe5d300e3485a2e6f3590'); [ Date: 2022-05-26 02:34:34 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
4	5m9s	COPY public.oc_cards (id, addressbookid, carddata, uri, lastmodified, etag, size, uid) TO stdout; [ Date: 2022-05-26 02:27:10 - Database: nextcloud - User: postgres - Remote: [local] - Application: pg_dump ]
5	5m	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = '1653524847' WHERE ("class" = 'OC\BackgroundJob\Legacy\RegularJob') AND ("argument_hash" = '7163eea8efcbe5d300e3485a2e6f3590'); [ Date: 2022-05-26 02:32:28 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
6	4m56s	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = '1653524853' WHERE ("class" = 'OC\BackgroundJob\Legacy\RegularJob') AND ("argument_hash" = '7163eea8efcbe5d300e3485a2e6f3590'); [ Date: 2022-05-26 02:32:30 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
7	4m35s	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = '1653524853' WHERE ("class" = 'OC\BackgroundJob\Legacy\RegularJob') AND ("argument_hash" = '7163eea8efcbe5d300e3485a2e6f3590'); [ Date: 2022-05-26 02:32:09 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
8	4m15s	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = '1653524802' WHERE ("class" = 'OC\BackgroundJob\Legacy\RegularJob') AND ("argument_hash" = '7163eea8efcbe5d300e3485a2e6f3590'); [ Date: 2022-05-26 02:30:58 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
9	4m11s	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = '1653524781' WHERE ("class" = 'OC\BackgroundJob\Legacy\RegularJob') AND ("argument_hash" = '7163eea8efcbe5d300e3485a2e6f3590'); [ Date: 2022-05-26 02:30:33 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
10	3m55s	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = '1653525088' WHERE ("class" = 'OC\BackgroundJob\Legacy\RegularJob') AND ("argument_hash" = '7163eea8efcbe5d300e3485a2e6f3590'); [ Date: 2022-05-26 02:35:23 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
11	3m41s	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = '1653524849' WHERE ("class" = 'OC\BackgroundJob\Legacy\RegularJob') AND ("argument_hash" = '7163eea8efcbe5d300e3485a2e6f3590'); [ Date: 2022-05-26 02:31:11 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
12	3m27s	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = '1653524944' WHERE ("class" = 'OC\BackgroundJob\Legacy\RegularJob') AND ("argument_hash" = '7163eea8efcbe5d300e3485a2e6f3590'); [ Date: 2022-05-26 02:32:32 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
13	3m24s	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = '1653524880' WHERE ("class" = 'OC\BackgroundJob\Legacy\RegularJob') AND ("argument_hash" = '7163eea8efcbe5d300e3485a2e6f3590'); [ Date: 2022-05-26 02:31:24 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
14	3m20s	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = '1653524851' WHERE ("class" = 'OC\BackgroundJob\Legacy\RegularJob') AND ("argument_hash" = '7163eea8efcbe5d300e3485a2e6f3590'); [ Date: 2022-05-26 02:30:52 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
15	3m20s	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = '1653524820' WHERE ("class" = 'OC\BackgroundJob\Legacy\RegularJob') AND ("argument_hash" = '7163eea8efcbe5d300e3485a2e6f3590'); [ Date: 2022-05-26 02:30:20 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
16	3m18s	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = '1653524880' WHERE ("class" = 'OC\BackgroundJob\Legacy\RegularJob') AND ("argument_hash" = '7163eea8efcbe5d300e3485a2e6f3590'); [ Date: 2022-05-26 02:31:19 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
17	3m13s	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = '1653525054' WHERE ("class" = 'OC\BackgroundJob\Legacy\RegularJob') AND ("argument_hash" = '7163eea8efcbe5d300e3485a2e6f3590'); [ Date: 2022-05-26 02:34:07 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
18	3m11s	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = '1653524915' WHERE ("class" = 'OC\BackgroundJob\Legacy\RegularJob') AND ("argument_hash" = '7163eea8efcbe5d300e3485a2e6f3590'); [ Date: 2022-05-26 02:31:47 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
19	3m9s	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = '1653525069' WHERE ("class" = 'OC\BackgroundJob\Legacy\RegularJob') AND ("argument_hash" = '7163eea8efcbe5d300e3485a2e6f3590'); [ Date: 2022-05-26 02:34:19 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]
20	3m8s	UPDATE "oc_jobs" SET "reserved_at" = '0', "last_checked" = '1653524972' WHERE ("class" = 'OC\BackgroundJob\Legacy\RegularJob') AND ("argument_hash" = '7163eea8efcbe5d300e3485a2e6f3590'); [ Date: 2022-05-26 02:32:41 - Database: nextcloud - User: nextcloud - Remote: ::1 - Application: [unknown] - Bind query: yes ]

Time consuming queries


[ User: nextcloud - Total duration: 18h21m41s - Times executed: 5711 ]
[ User: postgres - Total duration: 5m9s - Times executed: 1 ]
[ User: nextcloud - Total duration: 35s74ms - Times executed: 1 ]
[ User: postgres - Total duration: 27s375ms - Times executed: 1 ]
[ User: postgres - Total duration: 24s143ms - Times executed: 1 ]
[ User: postgres - Total duration: 21s804ms - Times executed: 1 ]
[ User: nextcloud - Total duration: 12s429ms - Times executed: 2 ]
[ User: nextcloud - Total duration: 12s224ms - Times executed: 2 ]
[ User: nextcloud - Total duration: 9s529ms - Times executed: 1 ]
[ User: postgres - Total duration: 7s644ms - Times executed: 1 ]
[ User: postgres - Total duration: 6s165ms - Times executed: 1 ]
[ User: nextcloud - Total duration: 5s389ms - Times executed: 1 ]
[ User: postgres - Total duration: 5s2ms - Times executed: 1 ]
[ User: postgres - Total duration: 4s481ms - Times executed: 1 ]
[ User: postgres - Total duration: 4s312ms - Times executed: 1 ]
[ User: postgres - Total duration: 4s122ms - Times executed: 1 ]

Most frequent queries (N)


[ User: nextcloud - Total duration: 18h21m41s - Times executed: 5711 ]
[ User: nextcloud - Total duration: 12s429ms - Times executed: 2 ]
[ User: nextcloud - Total duration: 12s224ms - Times executed: 2 ]
[ User: postgres - Total duration: 5m9s - Times executed: 1 ]
[ User: nextcloud - Total duration: 35s74ms - Times executed: 1 ]
[ User: postgres - Total duration: 27s375ms - Times executed: 1 ]
[ User: postgres - Total duration: 24s143ms - Times executed: 1 ]
[ User: postgres - Total duration: 21s804ms - Times executed: 1 ]
[ User: nextcloud - Total duration: 9s529ms - Times executed: 1 ]
[ User: postgres - Total duration: 7s644ms - Times executed: 1 ]
[ User: postgres - Total duration: 6s165ms - Times executed: 1 ]
[ User: nextcloud - Total duration: 5s389ms - Times executed: 1 ]
[ User: postgres - Total duration: 5s2ms - Times executed: 1 ]
[ User: postgres - Total duration: 4s481ms - Times executed: 1 ]
[ User: postgres - Total duration: 4s312ms - Times executed: 1 ]
[ User: postgres - Total duration: 4s122ms - Times executed: 1 ]

Normalized slowest queries (N)


[ User: postgres - Total duration: 5m9s - Times executed: 1 ]
[ User: nextcloud - Total duration: 35s74ms - Times executed: 1 ]
[ User: postgres - Total duration: 27s375ms - Times executed: 1 ]
[ User: postgres - Total duration: 24s143ms - Times executed: 1 ]
[ User: postgres - Total duration: 21s804ms - Times executed: 1 ]
[ User: nextcloud - Total duration: 18h21m41s - Times executed: 5711 ]
[ User: nextcloud - Total duration: 9s529ms - Times executed: 1 ]
[ User: postgres - Total duration: 7s644ms - Times executed: 1 ]
[ User: nextcloud - Total duration: 12s429ms - Times executed: 2 ]
[ User: postgres - Total duration: 6s165ms - Times executed: 1 ]
[ User: nextcloud - Total duration: 12s224ms - Times executed: 2 ]
[ User: nextcloud - Total duration: 5s389ms - Times executed: 1 ]
[ User: postgres - Total duration: 5s2ms - Times executed: 1 ]
[ User: postgres - Total duration: 4s481ms - Times executed: 1 ]
[ User: postgres - Total duration: 4s312ms - Times executed: 1 ]
[ User: postgres - Total duration: 4s122ms - Times executed: 1 ]

Time consuming prepare

Rank	Total duration	Times executed	Min duration	Max duration	Avg duration	Query
NO DATASET

Time consuming bind

Rank	Total duration	Times executed	Min duration	Max duration	Avg duration	Query
NO DATASET

Log levels

Key values

207,385 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	46,573	22.46%
DETAIL	34,413	16.59%
ERROR	28,689	13.83%
FATAL	311	0.15%
LOG	40,535	19.55%
STATEMENT	56,864	27.42%

Events distribution

Key values

0 PANIC entries
311 FATAL entries
28696 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

23,283 Max number of times the same event was reported
29,007 Total events found


Date: 2022-05-25 15:40:03
Database: nextcloud
Application: [unknown]
User: nextcloud
Remote: ::1
Date: 2022-05-25 15:40:09
Database: nextcloud
Application: [unknown]
User: nextcloud
Remote: ::1
Date: 2022-05-25 15:55:25
Database: nextcloud
Application: [unknown]
User: nextcloud
Remote: ::1
Date: 2022-05-25 15:01:41
Database: nextcloud
Application: [inconnu]
User: nextcloud
Remote: ::1
Date: 2022-05-25 15:01:24
Database: nextcloud
Application: [inconnu]
User: collectd
Remote: ::1
Date: 2022-05-25 15:01:41
Database: nextcloud
Application: [inconnu]
User: nextcloud
Remote: ::1
Date: 2022-05-25 15:39:51
Database: nextcloud
Application: [unknown]
User: nextcloud
Remote: ::1
Date: 2022-05-25 15:38:36
Database: nextcloud
Application: [inconnu]
User: nextcloud
Remote: ::1
Date: 2022-05-25 15:38:36
Database: nextcloud
Application: [inconnu]
User: nextcloud
Remote: ::1
Date: 2022-05-25 15:38:47
Date: 2022-05-25 15:38:36
Database: nextcloud
Application: [inconnu]
User: nextcloud
Remote: ::1
Date: 2022-05-25 15:39:51

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 database

Connections per user

Key values

Connections per user

Connections per host

Key values

Connections per host

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per database

Sessions per user

Key values

Sessions per user

Sessions per host

Key values

Connections per host

Sessions per application

Key values

Sessions per application

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

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