ZEMM PG Report-
Global information
- Generated on Sun Mar 15 06:01:09 2026
- Log file: /var/log/postgresql/postgresql-2026-03-06_225012.csv, ..., /var/log/postgresql/postgresql-2026-03-15_000000.csv
- Parsed 39,086 log entries in 1m8s
- Log start from 2026-03-06 22:50:12 to 2026-03-06 23:59:55
-
Overview
Global Stats
- 2,442 Number of unique normalized queries
- 4,343 Number of queries
- 1h25m44s Total query duration
- 2026-03-06 22:50:27 First query
- 2026-03-06 23:59:01 Last query
- 774 queries/s at 2026-03-06 23:11:23 Query peak
- 1h25m44s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 1h25m44s Execute total duration
- 299 Number of events
- 10 Number of unique normalized events
- 271 Max number of times the same event was reported
- 0 Number of cancellation
- 136 Total number of automatic vacuums
- 181 Total number of automatic analyzes
- 406 Number temporary file
- 70.44 MiB Max size of temporary file
- 8.18 MiB Average size of temporary file
- 2,738 Total number of sessions
- 16 sessions at 2026-03-06 23:58:56 Session peak
- 11m49s Total duration of sessions
- 258ms Average duration of sessions
- 1 Average queries per session
- 1s878ms Average queries duration per session
- 0ms Average idle time per session
- 3,013 Total number of connections
- 49 connections/s at 2026-03-06 23:46:46 Connection peak
- 12 Total number of databases
SQL Traffic
Key values
- 774 queries/s Query Peak
- 2026-03-06 23:11:23 Date
SELECT Traffic
Key values
- 0 queries/s Query Peak
- Date
INSERT/UPDATE/DELETE Traffic
Key values
- 642 queries/s Query Peak
- 2026-03-06 23:12:42 Date
Queries duration
Key values
- 1h25m44s 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
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 06 22 123 0ms 2s503ms 46ms 5s695ms 5s695ms 5s695ms 23 4,220 512ms 14s201ms 1s217ms 1m22s 12m30s 28m40s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 06 22 0 0 0ms 0ms 0ms 0ms 23 0 55 2s512ms 0ms 7s891ms 33s532ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 06 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 19 2s861ms 0ms 0ms 8s18ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Mar 06 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Mar 06 22 439 0.12/s 23 2,574 0.71/s Day Hour Count Average Duration Average idle time Mar 06 22 399 225ms 211ms 23 2,339 264ms 0ms -
Connections
Established Connections
Key values
- 49 connections Connection Peak
- 2026-03-06 23:46:46 Date
Connections per database
Key values
- zemm_monitoring Main Database
- 3,013 connections Total
Database User Count bucardo 1 postgres 1 config_file 1 postgres 1 fbi_ci_db 1 postgres 1 fbi_unibi 1 postgres 1 fbi_unire 1 postgres 1 fbi_zemm 1 postgres 1 invdb 1 postgres 1 labanimal 1 postgres 1 monitoring 268 labanimal 268 postgres 23 postgres 23 template1 28 postgres 28 zemm_monitoring 2,179 labanimal 2,178 postgres 1 zemm_produktiv_7 164 labanimal 157 postgres 7 zemm_produktiv_8 341 labanimal 253 postgres 88 zemm_test_2 1 postgres 1 zemm_test_3 1 postgres 1 Connections per user
Key values
- labanimal Main User
- 3,013 connections Total
-
Sessions
Simultaneous sessions
Key values
- 16 sessions Session Peak
- 2026-03-06 23:58:56 Date
Histogram of session times
Key values
- 2,540 0-500ms duration
Sessions per database
Key values
- zemm_monitoring Main Database
- 2,738 sessions Total
Database Count Total Duration Average Duration bucardo 1 36ms 36ms fbi_ci_db 1 16ms 16ms fbi_unibi 1 55ms 55ms fbi_unire 1 60ms 60ms invdb 1 41ms 41ms labanimal 1 15ms 15ms postgres 23 1s916ms 83ms template1 28 152ms 5ms zemm_monitoring 2,179 5m42s 157ms zemm_produktiv_7 163 1m49s 674ms zemm_produktiv_8 337 4m14s 754ms zemm_test_2 1 39ms 39ms zemm_test_3 1 36ms 36ms Sessions per user
Key values
- labanimal Main User
- 2,738 sessions Total
Sessions per host
Key values
- ::1 Main Host
- 2,738 sessions Total
Sessions per application
Key values
- Main Application
- 2,738 sessions Total
Application Count Total Duration Average Duration 2,596 5m55s 136ms _desktop_index.php_command_login_subcommand_init_zemm_produktiv 6 951ms 158ms _desktop_index.php_command_reports_subcommand_animals_per_user_ 3 360ms 120ms _desktop_index.php_command_reports_subcommand_authority_meldung 4 423ms 105ms _desktop_index.php_command_reports_subcommand_fates_zemm_produk 1 163ms 163ms createdb 2 207ms 103ms dropdb 2 1s586ms 793ms pg_dump 6 3m23s 33s937ms pg_restore 2 2m2s 1m1s psql 115 24s112ms 209ms taskscron:zemm_produktiv_7@zemm.fbiscience.eu 1 41ms 41ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 227,360 buffers Checkpoint Peak
- 2026-03-06 23:16:44 Date
- 269.871 seconds Highest write time
- 0.259 seconds Sync time
Checkpoints Wal files
Key values
- 134 files Wal files usage Peak
- 2026-03-06 23:16:44 Date
Checkpoints distance
Key values
- 4,306.89 Mo Distance Peak
- 2026-03-06 23:16:44 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Mar 06 22 944 15.956s 0.062s 16.032s 23 382,371 954.482s 0.569s 956.292s Day Hour Added Removed Recycled Synced files Longest sync Average sync Mar 06 22 0 0 0 363 0.003s 0.003s 23 0 74 234 3,471 0.002s 0.014s Day Hour Count Avg time (sec) Mar 06 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Mar 06 22 1,023.00 kB 1,023.00 kB 23 360,324.36 kB 1,206,499.29 kB -
Temporary Files
Size of temporary files
Key values
- 308.77 MiB Temp Files size Peak
- 2026-03-06 23:12:30 Date
Number of temporary files
Key values
- 44 per second Temp Files Peak
- 2026-03-06 23:12:08 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Mar 06 22 0 0 0 23 406 3.24 GiB 8.18 MiB Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 20 252.12 MiB 8.00 KiB 25.64 MiB 12.61 MiB alter table only public."targetgroupMembers" add constraint "targetgroupMembers_pkey" primary key (id);-
ALTER TABLE ONLY public."targetgroupMembers" ADD CONSTRAINT "targetgroupMembers_pkey" PRIMARY KEY (id);
Date: 2026-03-06 23:12:09 Duration: 1s90ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
ALTER TABLE ONLY public."targetgroupMembers" ADD CONSTRAINT "targetgroupMembers_pkey" PRIMARY KEY (id);
Date: 2026-03-06 23:39:25 Duration: 517ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
2 20 84.69 MiB 8.00 KiB 9.51 MiB 4.23 MiB alter table only public.diary add constraint diary_pkey primary key (id);-
ALTER TABLE ONLY public.diary ADD CONSTRAINT diary_pkey PRIMARY KEY (id);
Date: 2026-03-06 23:12:08 Duration: 1s90ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
ALTER TABLE ONLY public.diary ADD CONSTRAINT diary_pkey PRIMARY KEY (id);
Date: 2026-03-06 23:39:24 Duration: 707ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
3 16 87.46 MiB 8.00 KiB 11.98 MiB 5.47 MiB alter table only public.targetgroups add constraint targetgroups_pkey primary key (id);-
ALTER TABLE ONLY public.targetgroups ADD CONSTRAINT targetgroups_pkey PRIMARY KEY (id);
Date: 2026-03-06 23:39:26 Duration: 1s351ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
ALTER TABLE ONLY public.targetgroups ADD CONSTRAINT targetgroups_pkey PRIMARY KEY (id);
Date: 2026-03-06 23:12:10 Duration: 1s103ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
4 16 23.18 MiB 8.00 KiB 3.62 MiB 1.45 MiB alter table only public.animals_search_mview add constraint animals_search_mview_pkey primary key (id);-
ALTER TABLE ONLY public.animals_search_mview ADD CONSTRAINT animals_search_mview_pkey PRIMARY KEY (id);
Date: 2026-03-06 23:12:07 Duration: 1s90ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
ALTER TABLE ONLY public.animals_search_mview ADD CONSTRAINT animals_search_mview_pkey PRIMARY KEY (id);
Date: 2026-03-06 23:39:23 Duration: 707ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
5 16 27.65 MiB 8.00 KiB 5.83 MiB 1.73 MiB alter table only public.cost_history add constraint cost_history_pkey primary key (id);-
ALTER TABLE ONLY public.cost_history ADD CONSTRAINT cost_history_pkey PRIMARY KEY (id);
Date: 2026-03-06 23:12:08 Duration: 1s90ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
ALTER TABLE ONLY public.cost_history ADD CONSTRAINT cost_history_pkey PRIMARY KEY (id);
Date: 2026-03-06 23:39:23 Duration: 707ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
6 16 23.18 MiB 8.00 KiB 4.24 MiB 1.45 MiB alter table only public.animals add constraint animals_pkey primary key (id);-
ALTER TABLE ONLY public.animals ADD CONSTRAINT animals_pkey PRIMARY KEY (id);
Date: 2026-03-06 23:12:07 Duration: 1s90ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
ALTER TABLE ONLY public.animals ADD CONSTRAINT animals_pkey PRIMARY KEY (id);
Date: 2026-03-06 23:39:23 Duration: 707ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
7 12 2.22 MiB 8.00 KiB 808.00 KiB 189.33 KiB alter table only public.tasks add constraint tasks_pkey primary key (id);-
ALTER TABLE ONLY public.tasks ADD CONSTRAINT tasks_pkey PRIMARY KEY (id);
Date: 2026-03-06 23:39:27 Duration: 1s351ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
ALTER TABLE ONLY public.tasks ADD CONSTRAINT tasks_pkey PRIMARY KEY (id);
Date: 2026-03-06 23:12:10 Duration: 1s103ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
8 12 7.37 MiB 8.00 KiB 2.47 MiB 628.67 KiB create unique index idxsessionid on public.login_tracker using btree (sessionid);-
CREATE UNIQUE INDEX idxsessionid ON public.login_tracker USING btree (sessionid);
Date: 2026-03-06 23:39:29 Duration: 1s351ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE UNIQUE INDEX idxsessionid ON public.login_tracker USING btree (sessionid);
Date: 2026-03-06 23:12:33 Duration: 639ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
9 12 3.41 MiB 8.00 KiB 1.66 MiB 290.67 KiB alter table only public.login_tracker add constraint login_tracker_pkey primary key (id);-
ALTER TABLE ONLY public.login_tracker ADD CONSTRAINT login_tracker_pkey PRIMARY KEY (id);
Date: 2026-03-06 23:12:08 Duration: 1s90ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
ALTER TABLE ONLY public.login_tracker ADD CONSTRAINT login_tracker_pkey PRIMARY KEY (id);
Date: 2026-03-06 23:39:24 Duration: 517ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
10 12 15.72 MiB 8.00 KiB 7.82 MiB 1.31 MiB alter table only public.tasks_changes add constraint tasks_changes_index01 primary key (id, task);-
ALTER TABLE ONLY public.tasks_changes ADD CONSTRAINT tasks_changes_index01 PRIMARY KEY (id, task);
Date: 2026-03-06 23:39:26 Duration: 1s351ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
ALTER TABLE ONLY public.tasks_changes ADD CONSTRAINT tasks_changes_index01 PRIMARY KEY (id, task);
Date: 2026-03-06 23:12:10 Duration: 1s103ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
11 10 252.07 MiB 23.16 MiB 26.20 MiB 25.21 MiB create index "targetgroupMembers_FKIndex1" on public."targetgroupMembers" using btree (targetgroup);-
CREATE INDEX "targetgroupMembers_FKIndex1" ON public."targetgroupMembers" USING btree (targetgroup);
Date: 2026-03-06 23:39:29 Duration: 1s351ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX "targetgroupMembers_FKIndex1" ON public."targetgroupMembers" USING btree (targetgroup);
Date: 2026-03-06 23:12:33 Duration: 639ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
12 10 252.05 MiB 22.59 MiB 27.05 MiB 25.20 MiB create index "targetgroupMembers_FKIndex2" on public."targetgroupMembers" using btree ("group");-
CREATE INDEX "targetgroupMembers_FKIndex2" ON public."targetgroupMembers" USING btree ("group");
Date: 2026-03-06 23:12:35 Duration: 1s433ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX "targetgroupMembers_FKIndex2" ON public."targetgroupMembers" USING btree ("group");
Date: 2026-03-06 23:39:30 Duration: 1s236ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
13 8 6.95 MiB 8.00 KiB 2.31 MiB 890.00 KiB alter table only public.litter_history add constraint litter_history_pkey primary key (id);-
ALTER TABLE ONLY public.litter_history ADD CONSTRAINT litter_history_pkey PRIMARY KEY (id);
Date: 2026-03-06 23:12:08 Duration: 1s90ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
ALTER TABLE ONLY public.litter_history ADD CONSTRAINT litter_history_pkey PRIMARY KEY (id);
Date: 2026-03-06 23:39:24 Duration: 517ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
14 8 23.11 MiB 2.38 MiB 4.13 MiB 2.89 MiB create index "animals_FKIndex2" on public.animals using btree ("homeCage");-
CREATE INDEX "animals_FKIndex2" ON public.animals USING btree ("homeCage");
Date: 2026-03-06 23:39:27 Duration: 1s351ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX "animals_FKIndex2" ON public.animals USING btree ("homeCage");
Date: 2026-03-06 23:12:32 Duration: 665ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
15 8 23.12 MiB 2.43 MiB 4.09 MiB 2.89 MiB create index "animals_FKIndex11" on public.animals using btree (species);-
CREATE INDEX "animals_FKIndex11" ON public.animals USING btree (species);
Date: 2026-03-06 23:39:27 Duration: 1s351ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX "animals_FKIndex11" ON public.animals USING btree (species);
Date: 2026-03-06 23:12:32 Duration: 665ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
16 8 156.47 MiB 17.88 MiB 23.91 MiB 19.56 MiB create index titleindex on public.targetgroups using btree (title);-
CREATE INDEX titleindex ON public.targetgroups USING btree (title);
Date: 2026-03-06 23:12:37 Duration: 1s386ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX titleindex ON public.targetgroups USING btree (title);
Date: 2026-03-06 23:39:33 Duration: 1s172ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
17 8 6.40 MiB 8.00 KiB 2.30 MiB 819.00 KiB alter table only public.fem_numbers add constraint main_ukey unique (year, th, num);-
ALTER TABLE ONLY public.fem_numbers ADD CONSTRAINT main_ukey UNIQUE (year, th, num);
Date: 2026-03-06 23:12:08 Duration: 1s90ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
ALTER TABLE ONLY public.fem_numbers ADD CONSTRAINT main_ukey UNIQUE (year, th, num);
Date: 2026-03-06 23:39:24 Duration: 517ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
18 8 4.58 MiB 8.00 KiB 1.89 MiB 586.00 KiB alter table only public.fem_numbers add constraint pkey primary key (id);-
ALTER TABLE ONLY public.fem_numbers ADD CONSTRAINT pkey PRIMARY KEY (id);
Date: 2026-03-06 23:12:09 Duration: 1s90ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
ALTER TABLE ONLY public.fem_numbers ADD CONSTRAINT pkey PRIMARY KEY (id);
Date: 2026-03-06 23:39:25 Duration: 517ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
19 8 7.35 MiB 8.00 KiB 3.11 MiB 941.00 KiB alter table only public.monitoring_session_activity add constraint monitoring_session_activity_pkey primary key (session_id);-
ALTER TABLE ONLY public.monitoring_session_activity ADD CONSTRAINT monitoring_session_activity_pkey PRIMARY KEY (session_id);
Date: 2026-03-06 23:12:09 Duration: 1s90ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
ALTER TABLE ONLY public.monitoring_session_activity ADD CONSTRAINT monitoring_session_activity_pkey PRIMARY KEY (session_id);
Date: 2026-03-06 23:39:24 Duration: 517ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
20 8 3.62 MiB 8.00 KiB 1.51 MiB 463.00 KiB alter table only public.litters add constraint litters_pkey primary key (id);-
ALTER TABLE ONLY public.litters ADD CONSTRAINT litters_pkey PRIMARY KEY (id);
Date: 2026-03-06 23:12:08 Duration: 1s90ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
ALTER TABLE ONLY public.litters ADD CONSTRAINT litters_pkey PRIMARY KEY (id);
Date: 2026-03-06 23:39:24 Duration: 517ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
21 8 3.62 MiB 8.00 KiB 1.79 MiB 464.00 KiB alter table only public.litters_search_mview add constraint litters_search_mview_pkey primary key (id);-
ALTER TABLE ONLY public.litters_search_mview ADD CONSTRAINT litters_search_mview_pkey PRIMARY KEY (id);
Date: 2026-03-06 23:12:08 Duration: 1s90ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
ALTER TABLE ONLY public.litters_search_mview ADD CONSTRAINT litters_search_mview_pkey PRIMARY KEY (id);
Date: 2026-03-06 23:39:24 Duration: 517ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
22 8 50.80 MiB 5.83 MiB 7.51 MiB 6.35 MiB create index animals_mview_idx on public.animals_search_mview using btree (id nulls first, owner nulls first, editor nulls first, tourist nulls first);-
CREATE INDEX animals_mview_idx ON public.animals_search_mview USING btree (id NULLS FIRST, owner NULLS FIRST, editor NULLS FIRST, tourist NULLS FIRST);
Date: 2026-03-06 23:39:27 Duration: 1s351ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX animals_mview_idx ON public.animals_search_mview USING btree (id NULLS FIRST, owner NULLS FIRST, editor NULLS FIRST, tourist NULLS FIRST);
Date: 2026-03-06 23:12:32 Duration: 665ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
23 6 2.16 MiB 152.00 KiB 752.00 KiB 369.33 KiB create index tasks_active_index on public.tasks using btree (active);-
CREATE INDEX tasks_active_index ON public.tasks USING btree (active);
Date: 2026-03-06 23:12:36 Duration: 1s386ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX tasks_active_index ON public.tasks USING btree (active);
Date: 2026-03-06 23:39:33 Duration: 1s172ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
24 6 2.16 MiB 128.00 KiB 848.00 KiB 369.33 KiB create index tasks_owner_index on public.tasks using btree (owner);-
CREATE INDEX tasks_owner_index ON public.tasks USING btree (owner);
Date: 2026-03-06 23:12:37 Duration: 1s386ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX tasks_owner_index ON public.tasks USING btree (owner);
Date: 2026-03-06 23:39:33 Duration: 1s172ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
25 6 2.16 MiB 128.00 KiB 832.00 KiB 369.33 KiB create index tasks_editor_idx on public.tasks using btree (editor);-
CREATE INDEX tasks_editor_idx ON public.tasks USING btree (editor);
Date: 2026-03-06 23:12:36 Duration: 1s386ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX tasks_editor_idx ON public.tasks USING btree (editor);
Date: 2026-03-06 23:39:33 Duration: 1s172ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
26 6 3.02 MiB 72.00 KiB 1.36 MiB 516.00 KiB create index tasks_id_parent_idx on public.tasks using btree (id, parent);-
CREATE INDEX tasks_id_parent_idx ON public.tasks USING btree (id, parent);
Date: 2026-03-06 23:12:36 Duration: 1s386ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX tasks_id_parent_idx ON public.tasks USING btree (id, parent);
Date: 2026-03-06 23:39:33 Duration: 1s172ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
27 6 2.16 MiB 144.00 KiB 824.00 KiB 369.33 KiB create index tasks_task_status_idx on public.tasks using btree (task_status);-
CREATE INDEX tasks_task_status_idx ON public.tasks USING btree (task_status);
Date: 2026-03-06 23:12:37 Duration: 1s386ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX tasks_task_status_idx ON public.tasks USING btree (task_status);
Date: 2026-03-06 23:39:33 Duration: 1s172ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
28 6 2.16 MiB 48.00 KiB 968.00 KiB 369.33 KiB create index tasks_done_idx on public.tasks using btree (done);-
CREATE INDEX tasks_done_idx ON public.tasks USING btree (done);
Date: 2026-03-06 23:12:36 Duration: 1s386ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX tasks_done_idx ON public.tasks USING btree (done);
Date: 2026-03-06 23:39:33 Duration: 1s172ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
29 6 11.18 MiB 1.41 MiB 2.74 MiB 1.86 MiB create index tasks_changes_deleted_idx on public.tasks_changes using btree (deleted);-
CREATE INDEX tasks_changes_deleted_idx ON public.tasks_changes USING btree (deleted);
Date: 2026-03-06 23:12:36 Duration: 1s386ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX tasks_changes_deleted_idx ON public.tasks_changes USING btree (deleted);
Date: 2026-03-06 23:39:33 Duration: 1s172ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
30 5 299.19 MiB 58.38 MiB 61.05 MiB 59.84 MiB create index dex2_public_cost_history on bucardo.delta_public_cost_history using btree (id);-
CREATE INDEX dex2_public_cost_history ON bucardo.delta_public_cost_history USING btree (id);
Date: 2026-03-06 23:12:27 Duration: 540ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
31 5 295.52 MiB 57.89 MiB 61.18 MiB 59.10 MiB create index dex2_public_animals_search_mview on bucardo.delta_public_animals_search_mview using btree (id);-
CREATE INDEX dex2_public_animals_search_mview ON bucardo.delta_public_animals_search_mview USING btree (id);
Date: 2026-03-06 23:12:23 Duration: 1s381ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
32 5 126.03 MiB 24.41 MiB 25.59 MiB 25.21 MiB create index "targetgroupMembers_user_idx" on public."targetgroupMembers" using btree ("user");-
CREATE INDEX "targetgroupMembers_user_idx" ON public."targetgroupMembers" USING btree ("user");
Date: 2026-03-06 23:39:32 Duration: 1s301ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
33 5 42.30 MiB 7.98 MiB 10.05 MiB 8.46 MiB create index diary_animalid_idx on public.diary using btree ("animalID");-
CREATE INDEX diary_animalid_idx ON public.diary USING btree ("animalID");
Date: 2026-03-06 23:39:28 Duration: 1s351ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
34 5 126.02 MiB 24.70 MiB 26.05 MiB 25.20 MiB create index concurrently if not exists "targetgroupMembers_user_idx" on public."targetgroupMembers" using btree ("user");-
CREATE INDEX CONCURRENTLY IF NOT EXISTS "targetgroupMembers_user_idx" ON public."targetgroupMembers" USING btree ("user");
Date: 2026-03-06 23:26:26 Duration: 621ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
35 5 299.19 MiB 56.52 MiB 62.29 MiB 59.84 MiB create index dex1_public_cost_history on bucardo.delta_public_cost_history using btree (txntime);-
CREATE INDEX dex1_public_cost_history ON bucardo.delta_public_cost_history USING btree (txntime);
Date: 2026-03-06 23:12:17 Duration: 1s470ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
36 5 295.52 MiB 57.02 MiB 61.65 MiB 59.10 MiB create index dex1_public_animals_search_mview on bucardo.delta_public_animals_search_mview using btree (txntime);-
CREATE INDEX dex1_public_animals_search_mview ON bucardo.delta_public_animals_search_mview USING btree (txntime);
Date: 2026-03-06 23:12:11 Duration: 1s103ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
37 5 42.30 MiB 8.13 MiB 9.16 MiB 8.46 MiB create index concurrently if not exists diary_animalid_idx on public.diary using btree ("animalID");-
CREATE INDEX CONCURRENTLY IF NOT EXISTS diary_animalID_idx ON public.diary USING btree ("animalID");
Date: 2026-03-06 23:26:28 Duration: 1s837ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
38 4 3.58 MiB 224.00 KiB 1.57 MiB 916.00 KiB create index litters_dam_index on public.litters using btree (dam);-
CREATE INDEX litters_dam_index ON public.litters USING btree (dam);
Date: 2026-03-06 23:39:29 Duration: 1s351ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX litters_dam_index ON public.litters USING btree (dam);
Date: 2026-03-06 23:12:33 Duration: 639ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
39 4 47.97 MiB 11.35 MiB 12.80 MiB 11.99 MiB create index dex1_public_cages_search_mview on bucardo.delta_public_cages_search_mview using btree (txntime);-
CREATE INDEX dex1_public_cages_search_mview ON bucardo.delta_public_cages_search_mview USING btree (txntime);
Date: 2026-03-06 23:12:15 Duration: 4s101ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
40 4 35.62 MiB 8.28 MiB 10.04 MiB 8.90 MiB create index "dex2_public_targetgroupMembers" on bucardo."delta_public_targetgroupMembers" using btree (id);-
CREATE INDEX "dex2_public_targetgroupMembers" ON bucardo."delta_public_targetgroupMembers" USING btree (id);
Date: 2026-03-06 23:12:31 Duration: 3s203ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
41 4 13.80 MiB 3.22 MiB 3.98 MiB 3.45 MiB create index concurrently if not exists cost_history_animal_idx on public.cost_history using btree (animal);-
CREATE INDEX CONCURRENTLY IF NOT EXISTS cost_history_animal_idx ON public.cost_history USING btree (animal);
Date: 2026-03-06 23:26:28 Duration: 760ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
42 4 47.97 MiB 9.70 MiB 13.95 MiB 11.99 MiB create index dex2_public_cages_search_mview on bucardo.delta_public_cages_search_mview using btree (id);-
CREATE INDEX dex2_public_cages_search_mview ON bucardo.delta_public_cages_search_mview USING btree (id);
Date: 2026-03-06 23:12:26 Duration: 3s329ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
43 4 35.62 MiB 4.85 MiB 12.19 MiB 8.91 MiB create index "dex1_public_targetgroupMembers" on bucardo."delta_public_targetgroupMembers" using btree (txntime);-
CREATE INDEX "dex1_public_targetgroupMembers" ON bucardo."delta_public_targetgroupMembers" USING btree (txntime);
Date: 2026-03-06 23:12:21 Duration: 3s718ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
44 4 3.34 MiB 152.00 KiB 1.52 MiB 854.00 KiB create index monitoring_session_activity_user_idx on public.monitoring_session_activity using btree (user_id);-
CREATE INDEX monitoring_session_activity_user_idx ON public.monitoring_session_activity USING btree (user_id);
Date: 2026-03-06 23:39:29 Duration: 1s351ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX monitoring_session_activity_user_idx ON public.monitoring_session_activity USING btree (user_id);
Date: 2026-03-06 23:12:33 Duration: 639ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
45 4 13.80 MiB 2.95 MiB 4.90 MiB 3.45 MiB create index cost_history_animal_idx on public.cost_history using btree (animal);-
CREATE INDEX cost_history_animal_idx ON public.cost_history USING btree (animal);
Date: 2026-03-06 23:39:28 Duration: 1s351ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
46 3 1.67 MiB 184.00 KiB 1.05 MiB 570.67 KiB create index concurrently if not exists login_tracker_user_idx on public.login_tracker using btree ("user");-
CREATE INDEX CONCURRENTLY IF NOT EXISTS login_tracker_user_idx ON public.login_tracker USING btree ("user");
Date: 2026-03-06 23:26:29 Duration: 760ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
47 3 1.68 MiB 144.00 KiB 1.32 MiB 573.33 KiB create index login_tracker_user_idx on public.login_tracker using btree ("user");-
CREATE INDEX login_tracker_user_idx ON public.login_tracker USING btree ("user");
Date: 2026-03-06 23:39:29 Duration: 1s351ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
48 3 13.95 MiB 448.00 KiB 13.02 MiB 4.65 MiB create index dex1_public_animals on bucardo.delta_public_animals using btree (txntime);-
CREATE INDEX dex1_public_animals ON bucardo.delta_public_animals USING btree (txntime);
Date: 2026-03-06 23:12:11 Duration: 1s103ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
49 3 13.95 MiB 3.90 MiB 6.05 MiB 4.65 MiB create index dex2_public_animals on bucardo.delta_public_animals using btree (id);-
CREATE INDEX dex2_public_animals ON bucardo.delta_public_animals USING btree (id);
Date: 2026-03-06 23:12:23 Duration: 1s381ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
50 2 6.44 MiB 2.92 MiB 3.52 MiB 3.22 MiB create index dex2_public_targetgroups on bucardo.delta_public_targetgroups using btree (id);-
CREATE INDEX dex2_public_targetgroups ON bucardo.delta_public_targetgroups USING btree (id);
Date: 2026-03-06 23:12:32 Duration: 665ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
51 2 4.47 MiB 1.38 MiB 3.09 MiB 2.23 MiB create index dex2_public_tmptasks on bucardo.delta_public_tmptasks using btree (pk_id);-
CREATE INDEX dex2_public_tmptasks ON bucardo.delta_public_tmptasks USING btree (pk_id);
Date: 2026-03-06 23:12:32 Duration: 665ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
52 2 6.44 MiB 2.29 MiB 4.15 MiB 3.22 MiB create index dex1_public_targetgroups on bucardo.delta_public_targetgroups using btree (txntime);-
CREATE INDEX dex1_public_targetgroups ON bucardo.delta_public_targetgroups USING btree (txntime);
Date: 2026-03-06 23:12:22 Duration: 1s381ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
53 2 4.46 MiB 1.43 MiB 3.03 MiB 2.23 MiB create index dex1_public_tmptasks on bucardo.delta_public_tmptasks using btree (txntime);-
CREATE INDEX dex1_public_tmptasks ON bucardo.delta_public_tmptasks USING btree (txntime);
Date: 2026-03-06 23:12:23 Duration: 1s381ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
54 2 9.59 MiB 4.76 MiB 4.83 MiB 4.79 MiB create index dex2_public_diary on bucardo.delta_public_diary using btree (id);-
CREATE INDEX dex2_public_diary ON bucardo.delta_public_diary USING btree (id);
Date: 2026-03-06 23:12:30 Duration: 3s203ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
55 2 4.55 MiB 1.30 MiB 3.26 MiB 2.28 MiB create index bucardo_truncate_trigger_index on bucardo.bucardo_truncate_trigger using btree (sync, tablename) where (replicated is null);-
CREATE INDEX bucardo_truncate_trigger_index ON bucardo.bucardo_truncate_trigger USING btree (sync, tablename) WHERE (replicated IS NULL);
Date: 2026-03-06 23:12:11 Duration: 1s103ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
56 2 126.68 MiB 56.24 MiB 70.44 MiB 63.34 MiB with p as ( select id, count(*) as row_count, count(distinct project) as project_variants, count(distinct species) as species_variants, count(distinct fate) as fate_variants, count(distinct alive) as alive_variants, count(distinct coalesce("deathDate"::text, ?)) as death_variants, count(distinct coalesce("outgoingDate"::text, ?)) as outgoing_variants, count(distinct coalesce("homeCage"::text, ?)) as cage_variants, count(distinct coalesce(sex::text, ?)) as sex_variants, count(distinct coalesce(deleted::text, ?)) as deleted_variants from animals group by id having count(*) > ? ) select ?, count(*) from p union all select ?, count(*) from p where project_variants > ? union all select ?, count(*) from p where species_variants > ? union all select ?, count(*) from p where fate_variants > ? union all select ?, count(*) from p where alive_variants > ? union all select ?, count(*) from p where death_variants > ? union all select ?, count(*) from p where outgoing_variants > ? union all select ?, count(*) from p where cage_variants > ? union all select ?, count(*) from p where sex_variants > ? union all select ?, count(*) from p where deleted_variants > ?;-
with p as ( select id, count(*) as row_count, count(distinct project) as project_variants, count(distinct species) as species_variants, count(distinct fate) as fate_variants, count(distinct alive) as alive_variants, count(distinct coalesce("deathDate"::text, '')) as death_variants, count(distinct coalesce("outgoingDate"::text,'')) as outgoing_variants, count(distinct coalesce("homeCage"::text, '')) as cage_variants, count(distinct coalesce(sex::text,'')) as sex_variants, count(distinct coalesce(deleted::text, '')) as deleted_variants from animals group by id having count(*) > 1 ) select 'dup_ids_total', count(*) from p union all select 'project_variants_gt1', count(*) from p where project_variants > 1 union all select 'species_variants_gt1', count(*) from p where species_variants > 1 union all select 'fate_variants_gt1', count(*) from p where fate_variants > 1 union all select 'alive_variants_gt1', count(*) from p where alive_variants > 1 union all select 'death_variants_gt1', count(*) from p where death_variants > 1 union all select 'outgoing_variants_gt1', count(*) from p where outgoing_variants > 1 union all select 'cage_variants_gt1', count(*) from p where cage_variants > 1 union all select 'sex_variants_gt1', count(*) from p where sex_variants > 1 union all select 'deleted_variants_gt1', count(*) from p where deleted_variants > 1;
Date: 2026-03-06 23:00:13 Duration: 4s596ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
with p as ( select id, count(*) as row_count, count(distinct project) as project_variants, count(distinct species) as species_variants, count(distinct fate) as fate_variants, count(distinct alive) as alive_variants, count(distinct coalesce("deathDate"::text, '')) as death_variants, count(distinct coalesce("outgoingDate"::text,'')) as outgoing_variants, count(distinct coalesce("homeCage"::text, '')) as cage_variants, count(distinct coalesce(sex::text,'')) as sex_variants, count(distinct coalesce(deleted::text, '')) as deleted_variants from animals group by id having count(*) > 1 ) select 'dup_ids_total', count(*) from p union all select 'project_variants_gt1', count(*) from p where project_variants > 1 union all select 'species_variants_gt1', count(*) from p where species_variants > 1 union all select 'fate_variants_gt1', count(*) from p where fate_variants > 1 union all select 'alive_variants_gt1', count(*) from p where alive_variants > 1 union all select 'death_variants_gt1', count(*) from p where death_variants > 1 union all select 'outgoing_variants_gt1', count(*) from p where outgoing_variants > 1 union all select 'cage_variants_gt1', count(*) from p where cage_variants > 1 union all select 'sex_variants_gt1', count(*) from p where sex_variants > 1 union all select 'deleted_variants_gt1', count(*) from p where deleted_variants > 1;
Date: 2026-03-06 23:00:13 Duration: 0ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: psql
57 2 10.14 MiB 4.08 MiB 6.06 MiB 5.07 MiB create index dex2_public_login_tracker on bucardo.delta_public_login_tracker using btree (id);-
CREATE INDEX dex2_public_login_tracker ON bucardo.delta_public_login_tracker USING btree (id);
Date: 2026-03-06 23:12:31 Duration: 3s203ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
58 2 10.15 MiB 8.00 KiB 10.14 MiB 5.07 MiB create index dex1_public_login_tracker on bucardo.delta_public_login_tracker using btree (txntime);-
CREATE INDEX dex1_public_login_tracker ON bucardo.delta_public_login_tracker USING btree (txntime);
Date: 2026-03-06 23:12:21 Duration: 3s718ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
59 2 6.21 MiB 2.02 MiB 4.19 MiB 3.11 MiB create index dex2_public_tasks_changes on bucardo.delta_public_tasks_changes using btree (id, task);-
CREATE INDEX dex2_public_tasks_changes ON bucardo.delta_public_tasks_changes USING btree (id, task);
Date: 2026-03-06 23:12:32 Duration: 665ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
60 2 8.32 MiB 8.00 KiB 8.31 MiB 4.16 MiB create index dex1_public_cages on bucardo.delta_public_cages using btree (txntime);-
CREATE INDEX dex1_public_cages ON bucardo.delta_public_cages USING btree (txntime);
Date: 2026-03-06 23:12:15 Duration: 4s101ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
61 2 9.59 MiB 8.00 KiB 9.58 MiB 4.79 MiB create index dex1_public_diary on bucardo.delta_public_diary using btree (txntime);-
CREATE INDEX dex1_public_diary ON bucardo.delta_public_diary USING btree (txntime);
Date: 2026-03-06 23:12:20 Duration: 3s718ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
62 2 4.45 MiB 1.43 MiB 3.02 MiB 2.22 MiB create index dex1_public_tasks_changes on bucardo.delta_public_tasks_changes using btree (txntime);-
CREATE INDEX dex1_public_tasks_changes ON bucardo.delta_public_tasks_changes USING btree (txntime);
Date: 2026-03-06 23:12:22 Duration: 1s381ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
63 2 8.32 MiB 3.23 MiB 5.09 MiB 4.16 MiB create index dex2_public_cages on bucardo.delta_public_cages using btree (id);-
CREATE INDEX dex2_public_cages ON bucardo.delta_public_cages USING btree (id);
Date: 2026-03-06 23:12:26 Duration: 3s329ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
Queries generating the largest temporary files
Rank Size Query 1 70.44 MiB with p as ( select id, count(*) as row_count, count(distinct project) as project_variants, count(distinct species) as species_variants, count(distinct fate) as fate_variants, count(distinct alive) as alive_variants, count(distinct coalesce("deathDate"::text, '')) as death_variants, count(distinct coalesce("outgoingDate"::text,'')) as outgoing_variants, count(distinct coalesce("homeCage"::text, '')) as cage_variants, count(distinct coalesce(sex::text,'')) as sex_variants, count(distinct coalesce(deleted::text, '')) as deleted_variants from animals group by id having count(*) > 1 ) select 'dup_ids_total', count(*) from p union all select 'project_variants_gt1', count(*) from p where project_variants > 1 union all select 'species_variants_gt1', count(*) from p where species_variants > 1 union all select 'fate_variants_gt1', count(*) from p where fate_variants > 1 union all select 'alive_variants_gt1', count(*) from p where alive_variants > 1 union all select 'death_variants_gt1', count(*) from p where death_variants > 1 union all select 'outgoing_variants_gt1', count(*) from p where outgoing_variants > 1 union all select 'cage_variants_gt1', count(*) from p where cage_variants > 1 union all select 'sex_variants_gt1', count(*) from p where sex_variants > 1 union all select 'deleted_variants_gt1', count(*) from p where deleted_variants > 1;[ Date: 2026-03-06 23:00:13 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: psql ]
2 62.29 MiB CREATE INDEX dex1_public_cost_history ON bucardo.delta_public_cost_history USING btree (txntime);[ Date: 2026-03-06 23:12:20 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
3 61.65 MiB CREATE INDEX dex1_public_animals_search_mview ON bucardo.delta_public_animals_search_mview USING btree (txntime);[ Date: 2026-03-06 23:12:15 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
4 61.18 MiB CREATE INDEX dex2_public_animals_search_mview ON bucardo.delta_public_animals_search_mview USING btree (id);[ Date: 2026-03-06 23:12:26 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
5 61.05 MiB CREATE INDEX dex2_public_cost_history ON bucardo.delta_public_cost_history USING btree (id);[ Date: 2026-03-06 23:12:30 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
6 60.71 MiB CREATE INDEX dex1_public_cost_history ON bucardo.delta_public_cost_history USING btree (txntime);[ Date: 2026-03-06 23:12:20 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
7 60.60 MiB CREATE INDEX dex1_public_cost_history ON bucardo.delta_public_cost_history USING btree (txntime);[ Date: 2026-03-06 23:12:20 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
8 60.09 MiB CREATE INDEX dex2_public_cost_history ON bucardo.delta_public_cost_history USING btree (id);[ Date: 2026-03-06 23:12:30 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
9 59.97 MiB CREATE INDEX dex1_public_animals_search_mview ON bucardo.delta_public_animals_search_mview USING btree (txntime);[ Date: 2026-03-06 23:12:15 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
10 59.92 MiB CREATE INDEX dex2_public_cost_history ON bucardo.delta_public_cost_history USING btree (id);[ Date: 2026-03-06 23:12:30 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
11 59.75 MiB CREATE INDEX dex2_public_cost_history ON bucardo.delta_public_cost_history USING btree (id);[ Date: 2026-03-06 23:12:30 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
12 59.63 MiB CREATE INDEX dex1_public_animals_search_mview ON bucardo.delta_public_animals_search_mview USING btree (txntime);[ Date: 2026-03-06 23:12:15 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
13 59.16 MiB CREATE INDEX dex2_public_animals_search_mview ON bucardo.delta_public_animals_search_mview USING btree (id);[ Date: 2026-03-06 23:12:26 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
14 59.06 MiB CREATE INDEX dex1_public_cost_history ON bucardo.delta_public_cost_history USING btree (txntime);[ Date: 2026-03-06 23:12:20 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
15 58.99 MiB CREATE INDEX dex2_public_animals_search_mview ON bucardo.delta_public_animals_search_mview USING btree (id);[ Date: 2026-03-06 23:12:26 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
16 58.38 MiB CREATE INDEX dex2_public_cost_history ON bucardo.delta_public_cost_history USING btree (id);[ Date: 2026-03-06 23:12:30 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
17 58.30 MiB CREATE INDEX dex2_public_animals_search_mview ON bucardo.delta_public_animals_search_mview USING btree (id);[ Date: 2026-03-06 23:12:26 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
18 57.89 MiB CREATE INDEX dex2_public_animals_search_mview ON bucardo.delta_public_animals_search_mview USING btree (id);[ Date: 2026-03-06 23:12:26 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
19 57.25 MiB CREATE INDEX dex1_public_animals_search_mview ON bucardo.delta_public_animals_search_mview USING btree (txntime);[ Date: 2026-03-06 23:12:15 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
20 57.02 MiB CREATE INDEX dex1_public_animals_search_mview ON bucardo.delta_public_animals_search_mview USING btree (txntime);[ Date: 2026-03-06 23:12:15 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 9.36 sec Highest CPU-cost vacuum
Table bucardo.delta_public_animals_search_mview
Database zemm_produktiv_8 - 2026-03-06 23:13:03 Date
- 0 sec Highest CPU-cost analyze
Table
Database zemm_produktiv_8 - Date
Average Autovacuum Duration
Key values
- 9.36 sec Highest CPU-cost vacuum
Table bucardo.delta_public_animals_search_mview
Database zemm_produktiv_8 - 2026-03-06 23:13:03 Date
Analyzes per table
Key values
- pg_catalog.pg_depend (3) Main table analyzed (database zemm_produktiv_8)
- 181 analyzes Total
Table Number of analyzes zemm_produktiv_8.pg_catalog.pg_depend 3 zemm_produktiv_8.pg_catalog.pg_class 3 zemm_produktiv_8.pg_catalog.pg_index 3 zemm_produktiv_8.pg_catalog.pg_trigger 2 template0.pg_catalog.pg_shdepend 2 zemm_produktiv_8.pg_catalog.pg_attribute 2 zemm_produktiv_8.pg_catalog.pg_constraint 2 zemm_produktiv_7.pg_catalog.pg_constraint 2 zemm_produktiv_7.pg_catalog.pg_class 2 zemm_produktiv_8.pg_catalog.pg_type 2 zemm_produktiv_8.public.users 2 zemm_produktiv_8.pg_catalog.pg_attrdef 2 zemm_produktiv_7.pg_catalog.pg_depend 2 zemm_produktiv_7.public.groupMembers 1 zemm_test_2.pg_catalog.pg_attribute 1 zemm_produktiv_8.bucardo.track_public_animals 1 zemm_produktiv_7.pg_catalog.pg_index 1 zemm_produktiv_8.bucardo.delta_public_targetgroups 1 zemm_produktiv_8.public.strains 1 zemm_produktiv_8.pg_catalog.pg_proc 1 zemm_produktiv_8.bucardo.delta_public_scoresheet_response 1 zemm_produktiv_8.public.monitoring_session_activity 1 zemm_produktiv_8.bucardo.delta_public_stress_levels 1 zemm_produktiv_7.public.animals 1 zemm_produktiv_8.bucardo.delta_public_fem_numbers 1 zemm_produktiv_8.bucardo.track_public_tasks 1 zemm_produktiv_8.public.breedingssires 1 zemm_test_3.pg_catalog.pg_attribute 1 zemm_produktiv_7.public.tmptasks 1 zemm_produktiv_7.public.sys_actions 1 zemm_produktiv_8.public.locations 1 zemm_produktiv_8.bucardo.track_public_targetgroupMembers 1 zemm_produktiv_7.public.breedingsdams 1 zemm_produktiv_8.bucardo.delta_public_breedings 1 zemm_produktiv_8.public.scoresheet_answer 1 zemm_produktiv_8.bucardo.track_public_license_history 1 zemm_produktiv_8.public.fem_numbers 1 zemm_produktiv_8.bucardo.delta_public_cages 1 zemm_produktiv_8.bucardo.delta_public_stresslevel_response 1 invdb.pg_catalog.pg_attribute 1 zemm_produktiv_8.bucardo.track_public_diary 1 zemm_produktiv_7.public.monitoring_session_activity 1 zemm_produktiv_7.public.tasks 1 zemm_produktiv_8.public.taskattachment 1 zemm_produktiv_8.public.diary 1 zemm_produktiv_8.bucardo.delta_public_animals 1 zemm_produktiv_8.public.cages 1 zemm_produktiv_8.public.animals 1 zemm_produktiv_8.pg_catalog.pg_sequence 1 zemm_produktiv_8.bucardo.track_public_roles_users 1 zemm_produktiv_8.bucardo.delta_public_litters_search_mview 1 zemm_produktiv_8.public.cost_history 1 zemm_produktiv_7.public.cages 1 zemm_produktiv_8.public.scoresheet_response 1 zemm_produktiv_7.public.documents 1 zemm_produktiv_8.bucardo.delta_public_strains 1 zemm_produktiv_8.public.stresslevel_response 1 zemm_produktiv_8.public.scoresheet_diary 1 zemm_produktiv_8.bucardo.track_public_cages 1 zemm_produktiv_8.bucardo.delta_public_tasks 1 zemm_produktiv_7.pg_catalog.pg_type 1 zemm_produktiv_7.public.scoresheet_answer 1 zemm_produktiv_7.public.breedings 1 zemm_produktiv_8.public.breedingsdams 1 zemm_produktiv_8.bucardo.delta_public_users 1 zemm_produktiv_8.bucardo.delta_public_question 1 zemm_produktiv_8.public.licenses 1 zemm_produktiv_8.public.animals_search_mview 1 zemm_produktiv_8.public.groupMembers 1 zemm_produktiv_7.public.user_ui_prefs 1 zemm_produktiv_8.public.tasks_changes 1 zemm_produktiv_7.public.stresslevel_response 1 zemm_produktiv_8.bucardo.track_public_tmptasks 1 zemm_produktiv_8.bucardo.delta_public_animals_search_mview 1 zemm_produktiv_7.public.taskattachment 1 zemm_produktiv_7.public.diary 1 zemm_produktiv_8.bucardo.delta_public_licenses 1 zemm_produktiv_7.pg_catalog.pg_sequence 1 zemm_produktiv_8.bucardo.delta_public_targetgroupMembers 1 zemm_produktiv_8.public.question 1 zemm_produktiv_7.public.litters 1 zemm_produktiv_8.public.tmptasks 1 zemm_produktiv_7.public.litters_search_mview 1 zemm_produktiv_7.public.sys_screens 1 zemm_produktiv_8.bucardo.track_public_litter_history 1 zemm_produktiv_8.bucardo.delta_public_breedingsdams 1 zemm_produktiv_8.bucardo.track_public_breedings 1 zemm_produktiv_8.bucardo.bucardo_delta_targets 1 zemm_produktiv_8.bucardo.delta_public_diary 1 zemm_produktiv_7.public.groups 1 zemm_produktiv_7.public.license_history 1 zemm_produktiv_7.public.targetgroupMembers 1 zemm_produktiv_8.bucardo.delta_public_license_history 1 zemm_produktiv_8.public.breedings 1 zemm_produktiv_8.bucardo.delta_public_documents 1 zemm_produktiv_7.public.tasks_changes 1 zemm_produktiv_7.public.choice 1 zemm_produktiv_7.public.scoresheet_diary 1 zemm_produktiv_7.public.animals_search_mview 1 zemm_produktiv_8.pg_catalog.pg_shdepend 1 zemm_produktiv_8.bucardo.track_public_animals_search_mview 1 zemm_produktiv_7.public.strains 1 zemm_produktiv_7.public.roles_users 1 zemm_produktiv_7.public.licenses 1 zemm_produktiv_8.bucardo.delta_public_scoresheet_diary 1 zemm_produktiv_7.public.litter_history 1 zemm_produktiv_8.bucardo.delta_public_breedingssires 1 zemm_produktiv_8.bucardo.track_public_fem_numbers 1 zemm_produktiv_8.public.litters_search_mview 1 zemm_produktiv_8.bucardo.bucardo_delta_names 1 zemm_produktiv_8.public.sys_actions 1 zemm_produktiv_8.bucardo.delta_public_choice 1 zemm_produktiv_8.bucardo.delta_public_tasks_changes 1 zemm_produktiv_8.bucardo.delta_public_cages_search_mview 1 zemm_produktiv_8.public.license_history 1 zemm_produktiv_8.bucardo.delta_public_litters 1 zemm_produktiv_7.public.cost_history 1 zemm_produktiv_7.public.cages_search_mview 1 zemm_produktiv_8.public.targetgroupMembers 1 zemm_produktiv_8.public.sys_screens 1 zemm_produktiv_7.pg_catalog.pg_attribute 1 zemm_produktiv_8.bucardo.track_public_groupMembers 1 zemm_produktiv_8.public.targetgroups 1 zemm_produktiv_7.pg_catalog.pg_trigger 1 zemm_produktiv_8.bucardo.track_public_litters 1 zemm_produktiv_7.public.login_tracker 1 zemm_produktiv_7.public.locations 1 zemm_produktiv_8.bucardo.track_public_litters_search_mview 1 zemm_produktiv_8.public.litters 1 zemm_produktiv_8.bucardo.delta_public_tmptasks 1 zemm_produktiv_8.public.groups 1 zemm_produktiv_8.bucardo.delta_public_groupMembers 1 postgres.pg_catalog.pg_attribute 1 zemm_produktiv_8.public.tasks 1 zemm_produktiv_7.public.breedingssires 1 zemm_produktiv_8.public.login_tracker 1 zemm_produktiv_7.public.question 1 zemm_produktiv_7.public.targetgroups 1 bucardo.pg_catalog.pg_attribute 1 zemm_produktiv_8.bucardo.bucardo_truncate_trigger 1 zemm_produktiv_8.bucardo.delta_public_cost_history 1 zemm_produktiv_7.pg_catalog.pg_shdepend 1 zemm_produktiv_8.public.roles_users 1 zemm_produktiv_8.bucardo.track_public_targetgroups 1 zemm_produktiv_8.bucardo.delta_public_roles_users 1 zemm_produktiv_8.public.documents 1 zemm_produktiv_7.public.scoresheet_response 1 zemm_produktiv_7.pg_catalog.pg_attrdef 1 zemm_monitoring.observability.db_top_queries 1 zemm_produktiv_8.bucardo.track_public_cages_search_mview 1 zemm_produktiv_8.bucardo.delta_public_login_tracker 1 zemm_produktiv_8.bucardo.track_public_users 1 zemm_produktiv_7.public.users 1 zemm_produktiv_8.public.user_ui_prefs 1 zemm_produktiv_8.bucardo.delta_public_litter_history 1 zemm_produktiv_8.bucardo.track_public_tasks_changes 1 zemm_produktiv_8.public.cages_search_mview 1 postgres.pg_catalog.pg_shdepend 1 zemm_produktiv_8.public.choice 1 zemm_produktiv_7.public.fem_numbers 1 zemm_produktiv_8.bucardo.track_public_taskattachment 1 zemm_produktiv_8.bucardo.track_public_cost_history 1 zemm_produktiv_8.public.litter_history 1 zemm_produktiv_8.bucardo.delta_public_scoresheet_answer 1 zemm_produktiv_8.bucardo.delta_public_taskattachment 1 Total 181 Vacuums per table
Key values
- pg_catalog.pg_statistic (3) Main table vacuumed on database zemm_produktiv_8
- 136 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples zemm_produktiv_8.pg_catalog.pg_statistic 3 3 0 0 0 0 0 543 8 51,687 2 28 zemm_produktiv_8.pg_catalog.pg_depend 3 2 0 0 0 0 0 291 53 175,622 27 3,253 zemm_produktiv_8.pg_catalog.pg_class 2 2 0 0 0 0 0 178 37 107,695 2 90 template0.pg_catalog.pg_shdepend 2 1 0 0 0 0 0 94 21 41,860 9 766 zemm_produktiv_8.pg_catalog.pg_trigger 2 1 0 0 0 0 0 75 3 9,886 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 2 2 0 0 0 0 0 764 174 434,682 72 4,115 zemm_produktiv_8.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 358 4 23,140 0 0 zemm_produktiv_8.public.users 2 1 0 0 0 0 0 254 63 221,285 0 0 zemm_produktiv_8.pg_catalog.pg_type 2 2 0 0 0 0 0 81 17 27,580 0 0 zemm_produktiv_8.pg_catalog.pg_index 2 1 0 0 0 0 0 66 8 17,531 0 0 zemm_produktiv_8.bucardo.delta_public_targetgroupMembers 1 0 0 0 0 0 0 3,961 2,041 5,530,028 0 0 zemm_produktiv_7.public.diary 1 0 0 0 0 0 0 31,590 1 1,864,127 0 0 zemm_produktiv_7.public.taskattachment 1 0 0 0 0 0 0 293 3 18,192 0 0 zemm_produktiv_8.bucardo.track_public_tmptasks 1 0 0 0 0 0 0 62 60 123,557 0 0 zemm_produktiv_7.public.stresslevel_response 1 0 0 0 0 0 0 13 3 1,239 0 0 zemm_produktiv_8.bucardo.delta_public_animals_search_mview 1 0 0 0 0 0 0 37,970 37,971 102,519,765 0 0 zemm_monitoring.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 80 14 88,212 5 10 zemm_produktiv_7.public.user_ui_prefs 1 0 0 0 0 0 0 113 3 7,398 0 0 zemm_produktiv_8.public.groupMembers 1 0 0 0 0 0 0 9 9 14,014 0 0 zemm_produktiv_8.public.tasks_changes 1 0 0 0 0 0 0 3,145 3,144 9,441,548 0 0 zemm_produktiv_8.public.animals_search_mview 1 0 0 0 0 0 0 22,862 22,862 97,600,376 0 0 zemm_produktiv_8.bucardo.delta_public_users 1 0 0 0 0 0 0 760 760 2,724,905 0 0 zemm_produktiv_8.public.breedingsdams 1 0 0 0 0 0 0 198 196 677,924 0 0 zemm_produktiv_7.public.scoresheet_answer 1 0 0 0 0 0 0 33 3 2,452 0 0 zemm_produktiv_7.public.breedings 1 0 0 0 0 0 0 222 3 13,803 0 0 zemm_produktiv_7.pg_catalog.pg_class 1 1 0 0 0 0 0 61 0 6,775 0 0 zemm_produktiv_8.bucardo.track_public_animals_search_mview 1 0 0 0 0 0 0 207 205 437,676 0 0 zemm_produktiv_7.public.strains 1 0 0 0 0 0 0 57 3 3,930 0 0 zemm_produktiv_7.public.scoresheet_diary 1 0 0 0 0 0 0 10 4 1,246 0 0 zemm_produktiv_7.public.animals_search_mview 1 0 0 0 0 0 0 22,862 1 1,349,122 0 0 zemm_produktiv_8.public.breedings 1 0 0 0 0 0 0 222 220 884,908 0 0 zemm_produktiv_7.public.tasks_changes 1 0 0 0 0 0 0 3,144 1 185,813 0 0 zemm_produktiv_7.public.targetgroupMembers 1 0 0 0 0 0 0 41,999 2 2,478,323 0 0 zemm_produktiv_8.bucardo.delta_public_license_history 1 0 0 0 0 0 0 68 67 233,832 0 0 zemm_produktiv_7.public.license_history 1 0 0 0 0 0 0 169 3 10,450 0 0 zemm_produktiv_8.bucardo.delta_public_diary 1 0 0 0 0 0 0 4,054 2,710 9,774,899 672 124,320 zemm_produktiv_8.bucardo.track_public_breedings 1 0 0 0 0 0 0 11 11 16,536 0 0 zemm_produktiv_8.bucardo.delta_public_breedingsdams 1 0 0 0 0 0 0 169 3 10,397 0 0 zemm_produktiv_8.bucardo.track_public_litter_history 1 0 0 0 0 0 0 12 12 17,842 0 0 zemm_produktiv_7.public.litters_search_mview 1 0 0 0 0 0 0 2,485 1 146,932 0 0 zemm_produktiv_8.public.tmptasks 1 0 0 0 0 0 0 104 102 274,491 0 0 zemm_produktiv_7.public.litters 1 0 0 0 0 0 0 1,077 1 63,860 0 0 zemm_produktiv_8.bucardo.delta_public_cages 1 0 0 0 0 0 0 2,352 1 139,032 0 0 zemm_produktiv_8.public.fem_numbers 1 0 0 0 0 0 0 990 990 2,409,335 0 0 zemm_produktiv_8.bucardo.delta_public_stresslevel_response 1 0 0 0 0 0 0 14 12 29,832 0 0 zemm_produktiv_8.bucardo.track_public_targetgroupMembers 1 0 0 0 0 0 0 50 48 102,105 0 0 zemm_produktiv_7.public.breedingsdams 1 0 0 0 0 0 0 198 3 12,162 0 0 zemm_produktiv_8.public.scoresheet_answer 1 0 0 0 0 0 0 33 31 82,485 0 0 zemm_produktiv_8.bucardo.delta_public_breedings 1 0 0 0 0 0 0 180 3 11,047 0 0 zemm_produktiv_8.bucardo.track_public_license_history 1 0 0 0 0 0 0 9 9 11,618 0 0 zemm_produktiv_7.public.tmptasks 1 0 0 0 0 0 0 104 3 6,808 0 0 zemm_produktiv_8.public.breedingssires 1 0 0 0 0 0 0 148 146 501,131 0 0 zemm_produktiv_8.bucardo.delta_public_fem_numbers 1 0 0 0 0 0 0 976 977 2,288,277 0 0 zemm_produktiv_8.bucardo.track_public_tasks 1 0 0 0 0 0 0 34 32 65,879 0 0 zemm_produktiv_7.public.animals 1 0 0 0 0 0 0 15,868 1 936,476 0 0 zemm_produktiv_8.bucardo.delta_public_scoresheet_response 1 0 0 0 0 0 0 4 4 12,375 0 0 zemm_produktiv_8.public.monitoring_session_activity 1 0 0 0 0 0 0 1,030 1,030 4,285,423 0 0 zemm_produktiv_8.public.strains 1 0 0 0 0 0 0 57 55 244,964 0 0 zemm_produktiv_8.bucardo.delta_public_targetgroups 1 0 0 0 0 0 0 1,820 1,820 4,941,246 0 0 zemm_produktiv_7.public.groupMembers 1 0 0 0 0 0 0 9 4 1,187 0 0 zemm_produktiv_8.bucardo.track_public_animals 1 0 0 0 0 0 0 207 205 437,628 0 0 zemm_produktiv_8.bucardo.delta_public_tasks 1 0 0 0 0 0 0 920 920 2,693,046 0 0 zemm_produktiv_8.public.scoresheet_diary 1 0 0 0 0 0 0 10 10 22,033 0 0 zemm_produktiv_8.bucardo.track_public_cages 1 0 0 0 0 0 0 91 89 189,052 0 0 zemm_produktiv_8.bucardo.delta_public_strains 1 0 0 0 0 0 0 7 7 20,741 0 0 zemm_produktiv_8.public.stresslevel_response 1 0 0 0 0 0 0 13 11 22,275 0 0 zemm_produktiv_7.public.cages 1 0 0 0 0 0 0 171 3 10,808 0 0 zemm_produktiv_8.bucardo.delta_public_litters_search_mview 1 0 0 0 0 0 0 927 927 2,503,378 0 0 zemm_produktiv_8.public.cost_history 1 0 0 0 0 0 0 9,298 9,298 23,456,137 0 0 zemm_produktiv_8.public.diary 1 0 0 0 0 0 0 31,590 31,590 60,276,030 0 0 zemm_produktiv_8.public.cages 1 0 0 0 0 0 0 171 169 566,611 0 0 zemm_produktiv_8.public.animals 1 0 0 0 0 0 0 15,868 15,868 48,663,461 0 0 zemm_produktiv_8.bucardo.delta_public_animals 1 0 0 0 0 0 0 3,943 1 232,901 0 0 zemm_produktiv_8.public.taskattachment 1 0 0 0 0 0 0 293 291 1,191,678 0 0 zemm_produktiv_7.public.monitoring_session_activity 1 0 0 0 0 0 0 1,030 1 61,087 0 0 zemm_produktiv_7.public.tasks 1 0 0 0 0 0 0 8,416 1 496,861 0 0 zemm_produktiv_8.bucardo.track_public_diary 1 0 0 0 0 0 0 154 152 325,496 0 0 zemm_produktiv_8.bucardo.delta_public_roles_users 1 0 0 0 0 0 0 30 28 79,546 0 0 zemm_produktiv_8.bucardo.track_public_targetgroups 1 0 0 0 0 0 0 18 16 29,877 0 0 zemm_produktiv_8.bucardo.delta_public_cost_history 1 0 0 0 0 0 0 80,465 2,031 9,900,516 0 0 zemm_produktiv_8.bucardo.bucardo_truncate_trigger 1 0 0 0 0 0 0 1,526 1 90,298 0 0 zemm_produktiv_7.public.targetgroups 1 0 0 0 0 0 0 16,046 1 947,031 0 0 zemm_produktiv_7.public.breedingssires 1 0 0 0 0 0 0 148 3 9,212 0 0 zemm_produktiv_8.public.login_tracker 1 0 0 0 0 0 0 3,218 3,218 8,616,213 0 0 zemm_produktiv_7.pg_catalog.pg_statistic 1 1 0 0 0 0 0 118 0 8,362 0 0 zemm_produktiv_8.public.tasks 1 0 0 0 0 0 0 8,417 8,416 24,130,624 0 0 zemm_produktiv_8.bucardo.delta_public_taskattachment 1 0 0 0 0 0 0 27 25 86,270 0 0 zemm_produktiv_8.public.litter_history 1 0 0 0 0 0 0 1,670 1,670 5,101,464 0 0 zemm_produktiv_8.bucardo.delta_public_scoresheet_answer 1 0 0 0 0 0 0 24 22 51,778 0 0 zemm_produktiv_8.bucardo.track_public_cost_history 1 0 0 0 0 0 0 51 49 101,855 0 0 zemm_produktiv_7.public.fem_numbers 1 0 0 0 0 0 0 990 1 58,727 0 0 postgres.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 100 19 32,244 0 0 zemm_produktiv_8.bucardo.track_public_tasks_changes 1 0 0 0 0 0 0 28 26 52,660 0 0 zemm_produktiv_8.public.cages_search_mview 1 0 0 0 0 0 0 192 190 667,411 0 0 zemm_produktiv_8.bucardo.delta_public_litter_history 1 0 0 0 0 0 0 154 154 573,077 0 0 zemm_produktiv_8.public.user_ui_prefs 1 0 0 0 0 0 0 178 21 52,323 0 0 zemm_produktiv_7.pg_catalog.pg_depend 1 1 0 0 0 0 0 32 0 2,788 0 0 zemm_produktiv_8.bucardo.delta_public_login_tracker 1 0 0 0 0 0 0 4,596 2,868 9,895,840 864 159,840 zemm_produktiv_8.bucardo.track_public_users 1 0 0 0 0 0 0 56 54 117,835 0 0 zemm_produktiv_7.public.users 1 0 0 0 0 0 0 56 1 3,637 0 0 zemm_produktiv_8.pg_catalog.pg_attrdef 1 1 0 0 0 0 0 21 13 13,210 0 0 zemm_produktiv_8.bucardo.track_public_cages_search_mview 1 0 0 0 0 0 0 207 205 437,666 0 0 zemm_produktiv_7.public.cages_search_mview 1 0 0 0 0 0 0 192 3 12,082 0 0 zemm_produktiv_8.bucardo.delta_public_litters 1 0 0 0 0 0 0 324 322 999,735 0 0 zemm_produktiv_7.public.cost_history 1 0 0 0 0 0 0 9,298 1 548,899 0 0 zemm_produktiv_8.public.license_history 1 0 0 0 0 0 0 169 167 475,570 0 0 zemm_produktiv_8.bucardo.delta_public_tasks_changes 1 0 0 0 0 0 0 1,479 1,479 3,978,850 0 0 zemm_produktiv_8.bucardo.delta_public_choice 1 0 0 0 0 0 0 8 8 10,692 0 0 zemm_produktiv_8.bucardo.delta_public_cages_search_mview 1 0 0 0 0 0 0 4,243 2,013 4,887,205 0 0 zemm_produktiv_8.bucardo.bucardo_delta_names 1 0 0 0 0 0 0 15 3 1,320 0 0 zemm_produktiv_8.public.litters_search_mview 1 0 0 0 0 0 0 2,485 2,485 10,770,505 0 0 zemm_produktiv_8.bucardo.delta_public_breedingssires 1 0 0 0 0 0 0 126 3 7,860 0 0 zemm_produktiv_8.bucardo.track_public_fem_numbers 1 0 0 0 0 0 0 11 11 16,644 0 0 zemm_produktiv_7.public.litter_history 1 0 0 0 0 0 0 1,670 1 98,847 0 0 zemm_produktiv_8.bucardo.delta_public_scoresheet_diary 1 0 0 0 0 0 0 10 10 19,842 0 0 zemm_produktiv_8.bucardo.delta_public_groupMembers 1 0 0 0 0 0 0 35 33 83,759 0 0 zemm_produktiv_8.bucardo.delta_public_tmptasks 1 0 0 0 0 0 0 1,261 1,261 3,955,895 0 0 zemm_produktiv_8.public.litters 1 0 0 0 0 0 0 1,077 1,077 4,060,242 0 0 zemm_produktiv_8.bucardo.track_public_litters_search_mview 1 0 0 0 0 0 0 22 20 34,757 0 0 zemm_produktiv_7.public.login_tracker 1 0 0 0 0 0 0 3,218 1 190,195 0 0 zemm_produktiv_8.bucardo.track_public_litters 1 0 0 0 0 0 0 18 16 29,604 0 0 zemm_produktiv_8.public.targetgroups 1 0 0 0 0 0 0 16,046 16,046 41,384,818 0 0 zemm_produktiv_8.public.targetgroupMembers 1 0 0 0 0 0 0 41,999 42,000 131,551,631 0 0 zemm_produktiv_7.pg_catalog.pg_attribute 1 1 0 0 0 0 0 129 0 9,301 0 0 Total 136 24 0 0 0 0 0 479,914 221,511 659,074,862 1,653 292,422 Vacuum throughput per table
Key values
- bucardo.delta_public_animals_search_mview (9.36) Max CPU elapsed for vacuum on database zemm_produktiv_8
- public.animals (5.089 ms) Max I/O read time for vacuum on database zemm_produktiv_8
- public.animals (71.97 ms) Max I/O write time for vacuum on database zemm_produktiv_8
I/O timing (ms) CPU (s) Table read write elapsed zemm_produktiv_8.pg_catalog.pg_statistic 0 0 0.02 zemm_produktiv_8.pg_catalog.pg_depend 0 0 0.01 zemm_produktiv_8.pg_catalog.pg_class 0 0 0 template0.pg_catalog.pg_shdepend 1.932 0 0.01 zemm_produktiv_8.pg_catalog.pg_trigger 0 0.02 0 zemm_produktiv_8.pg_catalog.pg_attribute 0 0 0.04 zemm_produktiv_8.pg_toast.pg_toast_2619 0 0 0 zemm_produktiv_8.public.users 0.057 0.028 0 zemm_produktiv_8.pg_catalog.pg_type 0 0 0 zemm_produktiv_8.pg_catalog.pg_index 0 0 0 zemm_produktiv_8.bucardo.delta_public_targetgroupMembers 0.043 0 0.55 zemm_produktiv_7.public.diary 0 0.015 0.81 zemm_produktiv_7.public.taskattachment 0.018 0.011 0.01 zemm_produktiv_8.bucardo.track_public_tmptasks 0 0.018 0 zemm_produktiv_7.public.stresslevel_response 0 0.013 0 zemm_produktiv_8.bucardo.delta_public_animals_search_mview 0.065 0.038 9.36 zemm_monitoring.pg_toast.pg_toast_2619 0.483 0 0 zemm_produktiv_7.public.user_ui_prefs 0 0.014 0 zemm_produktiv_8.public.groupMembers 0.014 0.015 0 zemm_produktiv_8.public.tasks_changes 0.05 0.028 0.12 zemm_produktiv_8.public.animals_search_mview 0.055 0.019 1.09 zemm_produktiv_8.bucardo.delta_public_users 0 0.018 0.03 zemm_produktiv_8.public.breedingsdams 0.014 0.021 0.04 zemm_produktiv_7.public.scoresheet_answer 0 0.015 0 zemm_produktiv_7.public.breedings 0 0.02 0.01 zemm_produktiv_7.pg_catalog.pg_class 0 0 0 zemm_produktiv_8.bucardo.track_public_animals_search_mview 0 0.015 0.01 zemm_produktiv_7.public.strains 0.03 0.014 0 zemm_produktiv_7.public.scoresheet_diary 0 0.014 0 zemm_produktiv_7.public.animals_search_mview 0.067 0.013 0.55 zemm_produktiv_8.public.breedings 0.029 0.014 0.01 zemm_produktiv_7.public.tasks_changes 0.054 0.016 0.07 zemm_produktiv_7.public.targetgroupMembers 0 0.048 1.22 zemm_produktiv_8.bucardo.delta_public_license_history 0 0.015 0 zemm_produktiv_7.public.license_history 0 0.014 0 zemm_produktiv_8.bucardo.delta_public_diary 0.269 2.281 0.72 zemm_produktiv_8.bucardo.track_public_breedings 0 0.015 0 zemm_produktiv_8.bucardo.delta_public_breedingsdams 0 0.029 0.04 zemm_produktiv_8.bucardo.track_public_litter_history 0 0.013 0 zemm_produktiv_7.public.litters_search_mview 0.038 0.015 0.06 zemm_produktiv_8.public.tmptasks 0.019 0.026 0.03 zemm_produktiv_7.public.litters 0 0.016 0.02 zemm_produktiv_8.bucardo.delta_public_cages 0.202 0.875 0.15 zemm_produktiv_8.public.fem_numbers 0.027 0.016 0.03 zemm_produktiv_8.bucardo.delta_public_stresslevel_response 0 0.023 0 zemm_produktiv_8.bucardo.track_public_targetgroupMembers 0 0.018 0 zemm_produktiv_7.public.breedingsdams 0 0.014 0 zemm_produktiv_8.public.scoresheet_answer 0.012 0.016 0 zemm_produktiv_8.bucardo.delta_public_breedings 0 0.025 0.01 zemm_produktiv_8.bucardo.track_public_license_history 0 0.014 0 zemm_produktiv_7.public.tmptasks 0.014 0.014 0 zemm_produktiv_8.public.breedingssires 0.019 0.026 0.01 zemm_produktiv_8.bucardo.delta_public_fem_numbers 0 0.021 0.03 zemm_produktiv_8.bucardo.track_public_tasks 0 0.012 0 zemm_produktiv_7.public.animals 5.089 71.97 4.81 zemm_produktiv_8.bucardo.delta_public_scoresheet_response 0 0.017 0 zemm_produktiv_8.public.monitoring_session_activity 0.047 0.014 0.03 zemm_produktiv_8.public.strains 0.029 0.013 0 zemm_produktiv_8.bucardo.delta_public_targetgroups 0 0.028 0.07 zemm_produktiv_7.public.groupMembers 0 0.016 0 zemm_produktiv_8.bucardo.track_public_animals 0 0.032 0.01 zemm_produktiv_8.bucardo.delta_public_tasks 0 0.021 0.03 zemm_produktiv_8.public.scoresheet_diary 0.013 0.016 0 zemm_produktiv_8.bucardo.track_public_cages 0 0.011 0 zemm_produktiv_8.bucardo.delta_public_strains 0 0.019 0 zemm_produktiv_8.public.stresslevel_response 0.012 0.014 0 zemm_produktiv_7.public.cages 0 0.016 0.01 zemm_produktiv_8.bucardo.delta_public_litters_search_mview 0 0.015 0.03 zemm_produktiv_8.public.cost_history 0.053 0.014 0.34 zemm_produktiv_8.public.diary 0.046 0.016 1.16 zemm_produktiv_8.public.cages 0.025 0.017 0.01 zemm_produktiv_8.public.animals 0.044 0.017 0.69 zemm_produktiv_8.bucardo.delta_public_animals 0.768 8.035 0.68 zemm_produktiv_8.public.taskattachment 0.031 0.026 0.11 zemm_produktiv_7.public.monitoring_session_activity 0.029 0.013 0.02 zemm_produktiv_7.public.tasks 0 0.019 0.19 zemm_produktiv_8.bucardo.track_public_diary 0 0.018 0.01 zemm_produktiv_8.bucardo.delta_public_roles_users 0 0.023 0.03 zemm_produktiv_8.bucardo.track_public_targetgroups 0 0.014 0 zemm_produktiv_8.bucardo.delta_public_cost_history 0.026 0.062 2.9 zemm_produktiv_8.bucardo.bucardo_truncate_trigger 0 0.023 0.04 zemm_produktiv_7.public.targetgroups 0 0.015 0.45 zemm_produktiv_7.public.breedingssires 0 0.017 0 zemm_produktiv_8.public.login_tracker 0.051 0.019 0.1 zemm_produktiv_7.pg_catalog.pg_statistic 0 0 0 zemm_produktiv_8.public.tasks 0.122 0.032 0.33 zemm_produktiv_8.bucardo.delta_public_taskattachment 0 0.019 0 zemm_produktiv_8.public.litter_history 0.03 0.014 0.05 zemm_produktiv_8.bucardo.delta_public_scoresheet_answer 0 0.028 0 zemm_produktiv_8.bucardo.track_public_cost_history 0 0.02 0 zemm_produktiv_7.public.fem_numbers 0.028 0.014 0.02 postgres.pg_catalog.pg_shdepend 0 0 0.01 zemm_produktiv_8.bucardo.track_public_tasks_changes 0 0.018 0 zemm_produktiv_8.public.cages_search_mview 0.021 0.021 0.01 zemm_produktiv_8.bucardo.delta_public_litter_history 0 0.015 0 zemm_produktiv_8.public.user_ui_prefs 0 0.174 0.02 zemm_produktiv_7.pg_catalog.pg_depend 0 0 0 zemm_produktiv_8.bucardo.delta_public_login_tracker 0.346 3.043 0.36 zemm_produktiv_8.bucardo.track_public_users 0 0.021 0 zemm_produktiv_7.public.users 0 0.016 0 zemm_produktiv_8.pg_catalog.pg_attrdef 0 0.023 0 zemm_produktiv_8.bucardo.track_public_cages_search_mview 0 0.014 0.01 zemm_produktiv_7.public.cages_search_mview 0.029 0.014 0 zemm_produktiv_8.bucardo.delta_public_litters 0 0.017 0.01 zemm_produktiv_7.public.cost_history 0 0.025 0.24 zemm_produktiv_8.public.license_history 0.022 0.011 0.01 zemm_produktiv_8.bucardo.delta_public_tasks_changes 0 0.02 0.05 zemm_produktiv_8.bucardo.delta_public_choice 0 0.027 0 zemm_produktiv_8.bucardo.delta_public_cages_search_mview 0.049 0 0.55 zemm_produktiv_8.bucardo.bucardo_delta_names 0 0.015 0.11 zemm_produktiv_8.public.litters_search_mview 0.041 0.016 0.1 zemm_produktiv_8.bucardo.delta_public_breedingssires 0 0.028 0 zemm_produktiv_8.bucardo.track_public_fem_numbers 0 0.017 0 zemm_produktiv_7.public.litter_history 0 0.015 0.04 zemm_produktiv_8.bucardo.delta_public_scoresheet_diary 0 0.024 0 zemm_produktiv_8.bucardo.delta_public_groupMembers 0 0.02 0 zemm_produktiv_8.bucardo.delta_public_tmptasks 0 0.015 0.04 zemm_produktiv_8.public.litters 0.037 0.019 0.04 zemm_produktiv_8.bucardo.track_public_litters_search_mview 0 0.015 0 zemm_produktiv_7.public.login_tracker 0 0.015 0.07 zemm_produktiv_8.bucardo.track_public_litters 0 0.014 0 zemm_produktiv_8.public.targetgroups 0.054 0.015 0.58 zemm_produktiv_8.public.targetgroupMembers 0.078 0.055 1.71 zemm_produktiv_7.pg_catalog.pg_attribute 0 0 0 Total 10.631 88.344 31.14 Tuples removed per table
Key values
- pg_catalog.pg_attribute (4388) Main table with removed tuples on database zemm_produktiv_8
- 12173 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain zemm_produktiv_8.pg_catalog.pg_attribute 2 2 4,388 16,591 0 0 367 zemm_produktiv_8.pg_catalog.pg_depend 3 2 3,430 16,579 0 0 148 template0.pg_catalog.pg_shdepend 2 1 954 8,384 0 0 76 postgres.pg_catalog.pg_shdepend 1 1 807 3,659 0 0 38 zemm_produktiv_8.pg_catalog.pg_statistic 3 3 790 2,873 0 0 289 zemm_produktiv_8.pg_catalog.pg_type 2 2 496 2,138 0 0 62 zemm_produktiv_8.pg_catalog.pg_index 2 1 398 1,142 0 0 36 zemm_produktiv_8.pg_toast.pg_toast_2619 2 2 297 577 0 0 188 zemm_produktiv_7.pg_catalog.pg_attribute 1 1 173 6,348 0 0 115 zemm_produktiv_7.pg_catalog.pg_class 1 1 130 890 0 0 27 zemm_produktiv_7.pg_catalog.pg_statistic 1 1 88 1,062 0 0 89 zemm_produktiv_8.pg_catalog.pg_attrdef 1 1 78 135 0 0 10 zemm_monitoring.pg_toast.pg_toast_2619 1 1 65 50 0 0 25 zemm_produktiv_7.pg_catalog.pg_depend 1 1 54 3,324 0 0 25 zemm_produktiv_8.pg_catalog.pg_class 2 2 25 2,270 0 0 76 zemm_produktiv_8.bucardo.delta_public_targetgroupMembers 1 0 0 1,862,141 0 0 10,080 zemm_produktiv_7.public.diary 1 0 0 2,212,532 0 0 31,648 zemm_produktiv_7.public.taskattachment 1 0 0 16,534 0 56 288 zemm_produktiv_8.bucardo.track_public_tmptasks 1 0 0 7,644 0 7 57 zemm_produktiv_7.public.stresslevel_response 1 0 0 1,663 0 2 8 zemm_produktiv_8.bucardo.delta_public_animals_search_mview 1 0 0 15,459,390 0 0 83,616 zemm_produktiv_7.public.user_ui_prefs 1 0 0 740 0 30 106 zemm_produktiv_8.public.groupMembers 1 0 0 758 0 0 5 zemm_produktiv_8.public.tasks_changes 1 0 0 292,092 0 0 3,160 zemm_produktiv_8.public.animals_search_mview 1 0 0 603,982 0 0 22,912 zemm_produktiv_8.bucardo.delta_public_users 1 0 0 140,341 0 0 800 zemm_produktiv_8.public.breedingsdams 1 0 0 30,174 0 47 193 zemm_produktiv_7.public.scoresheet_answer 1 0 0 3,387 0 4 28 zemm_produktiv_7.public.breedings 1 0 0 22,312 0 55 217 zemm_produktiv_8.bucardo.track_public_animals_search_mview 1 0 0 27,434 0 54 202 zemm_produktiv_7.public.strains 1 0 0 2,253 0 12 52 zemm_produktiv_7.public.scoresheet_diary 1 0 0 1,057 0 0 6 zemm_produktiv_7.public.animals_search_mview 1 0 0 603,982 0 0 22,912 zemm_produktiv_8.public.breedings 1 0 0 22,312 0 55 217 zemm_produktiv_7.public.tasks_changes 1 0 0 292,092 0 0 3,160 zemm_produktiv_7.public.targetgroupMembers 1 0 0 6,593,644 0 0 42,032 zemm_produktiv_8.bucardo.delta_public_license_history 1 0 0 11,588 0 33 63 zemm_produktiv_7.public.license_history 1 0 0 22,303 0 28 164 zemm_produktiv_8.bucardo.delta_public_diary 1 0 0 501,060 0 0 2,720 zemm_produktiv_8.bucardo.track_public_breedings 1 0 0 931 0 0 7 zemm_produktiv_8.bucardo.delta_public_breedingsdams 1 0 0 30,174 0 60 164 zemm_produktiv_8.bucardo.track_public_litter_history 1 0 0 1,011 0 0 8 zemm_produktiv_7.public.litters_search_mview 1 0 0 93,359 0 0 2,512 zemm_produktiv_8.public.tmptasks 1 0 0 1,002 0 45 99 zemm_produktiv_7.public.litters 1 0 0 93,357 0 0 1,104 zemm_produktiv_8.bucardo.delta_public_cages 1 0 0 434,888 0 0 2,400 zemm_produktiv_8.public.fem_numbers 1 0 0 118,648 0 0 1,032 zemm_produktiv_8.bucardo.delta_public_stresslevel_response 1 0 0 1,663 0 3 9 zemm_produktiv_8.bucardo.track_public_targetgroupMembers 1 0 0 6,095 0 19 45 zemm_produktiv_7.public.breedingsdams 1 0 0 30,174 0 47 193 zemm_produktiv_8.public.scoresheet_answer 1 0 0 3,387 0 4 28 zemm_produktiv_8.bucardo.delta_public_breedings 1 0 0 32,350 0 49 175 zemm_produktiv_8.bucardo.track_public_license_history 1 0 0 662 0 0 5 zemm_produktiv_7.public.tmptasks 1 0 0 1,002 0 45 99 zemm_produktiv_8.public.breedingssires 1 0 0 22,324 0 33 143 zemm_produktiv_8.bucardo.delta_public_fem_numbers 1 0 0 180,212 0 0 992 zemm_produktiv_8.bucardo.track_public_tasks 1 0 0 3,818 0 3 29 zemm_produktiv_7.public.animals 1 0 0 603,982 0 0 15,904 zemm_produktiv_8.bucardo.delta_public_scoresheet_response 1 0 0 555 0 0 3 zemm_produktiv_8.public.monitoring_session_activity 1 0 0 86,819 0 0 1,032 zemm_produktiv_8.public.strains 1 0 0 2,253 0 12 52 zemm_produktiv_8.bucardo.delta_public_targetgroups 1 0 0 336,378 0 0 1,824 zemm_produktiv_7.public.groupMembers 1 0 0 758 0 0 5 zemm_produktiv_8.pg_catalog.pg_trigger 2 1 0 1,312 0 0 44 zemm_produktiv_8.bucardo.track_public_animals 1 0 0 27,431 0 54 202 zemm_produktiv_8.bucardo.delta_public_tasks 1 0 0 169,858 0 0 928 zemm_produktiv_8.public.scoresheet_diary 1 0 0 1,057 0 0 6 zemm_produktiv_8.bucardo.track_public_cages 1 0 0 11,571 0 42 86 zemm_produktiv_8.bucardo.delta_public_strains 1 0 0 1,110 0 0 6 zemm_produktiv_8.public.stresslevel_response 1 0 0 1,663 0 2 8 zemm_produktiv_7.public.cages 1 0 0 12,780 0 58 166 zemm_produktiv_8.bucardo.delta_public_litters_search_mview 1 0 0 171,260 0 0 928 zemm_produktiv_8.public.cost_history 1 0 0 721,128 0 0 9,328 zemm_produktiv_8.public.diary 1 0 0 2,212,532 0 0 31,648 zemm_produktiv_8.public.cages 1 0 0 12,780 0 58 166 zemm_produktiv_8.public.animals 1 0 0 603,982 0 0 15,904 zemm_produktiv_8.bucardo.delta_public_animals 1 0 0 729,238 0 0 4,000 zemm_produktiv_8.public.taskattachment 1 0 0 16,534 0 56 288 zemm_produktiv_7.public.monitoring_session_activity 1 0 0 86,819 0 0 1,032 zemm_produktiv_7.public.tasks 1 0 0 56,067 0 0 8,464 zemm_produktiv_8.bucardo.track_public_diary 1 0 0 20,256 0 43 149 zemm_produktiv_8.bucardo.delta_public_roles_users 1 0 0 4,515 0 23 25 zemm_produktiv_8.bucardo.track_public_targetgroups 1 0 0 1,719 0 3 13 zemm_produktiv_8.bucardo.delta_public_cost_history 1 0 0 15,654,384 0 0 84,640 zemm_produktiv_8.bucardo.bucardo_truncate_trigger 1 0 0 161,640 0 0 1,544 zemm_produktiv_7.public.targetgroups 1 0 0 2,285,994 0 0 16,064 zemm_produktiv_7.public.breedingssires 1 0 0 22,324 0 33 143 zemm_produktiv_8.public.login_tracker 1 0 0 86,819 0 0 3,272 zemm_produktiv_8.public.tasks 1 0 0 56,067 0 0 8,464 zemm_produktiv_8.bucardo.delta_public_taskattachment 1 0 0 4,053 0 2 22 zemm_produktiv_8.public.litter_history 1 0 0 180,715 0 0 1,680 zemm_produktiv_8.bucardo.delta_public_scoresheet_answer 1 0 0 3,387 0 5 19 zemm_produktiv_8.bucardo.track_public_cost_history 1 0 0 6,185 0 18 46 zemm_produktiv_7.public.fem_numbers 1 0 0 118,648 0 0 1,032 zemm_produktiv_8.bucardo.track_public_tasks_changes 1 0 0 3,046 0 9 23 zemm_produktiv_8.public.cages_search_mview 1 0 0 12,783 0 61 187 zemm_produktiv_8.bucardo.delta_public_litter_history 1 0 0 28,179 0 0 160 zemm_produktiv_8.public.user_ui_prefs 1 0 0 740 0 0 106 zemm_produktiv_8.bucardo.delta_public_login_tracker 1 0 0 530,311 0 0 2,912 zemm_produktiv_8.bucardo.track_public_users 1 0 0 6,897 0 13 51 zemm_produktiv_7.public.users 1 0 0 740 0 0 56 zemm_produktiv_8.bucardo.track_public_cages_search_mview 1 0 0 27,434 0 54 202 zemm_produktiv_7.public.cages_search_mview 1 0 0 12,783 0 61 187 zemm_produktiv_8.bucardo.delta_public_litters 1 0 0 58,952 0 33 319 zemm_produktiv_7.public.cost_history 1 0 0 721,128 0 0 9,328 zemm_produktiv_8.public.license_history 1 0 0 22,303 0 28 164 zemm_produktiv_8.bucardo.delta_public_tasks_changes 1 0 0 231,958 0 0 1,520 zemm_produktiv_8.bucardo.delta_public_choice 1 0 0 563 0 0 4 zemm_produktiv_8.bucardo.delta_public_cages_search_mview 1 0 0 2,504,515 0 0 13,600 zemm_produktiv_8.public.users 2 1 0 1,480 0 3 165 zemm_produktiv_8.bucardo.bucardo_delta_names 1 0 0 618 0 8 10 zemm_produktiv_8.public.litters_search_mview 1 0 0 93,359 0 0 2,512 zemm_produktiv_8.bucardo.delta_public_breedingssires 1 0 0 22,324 0 39 121 zemm_produktiv_8.bucardo.track_public_fem_numbers 1 0 0 943 0 0 7 zemm_produktiv_7.public.litter_history 1 0 0 180,715 0 0 1,680 zemm_produktiv_8.bucardo.delta_public_scoresheet_diary 1 0 0 1,057 0 0 6 zemm_produktiv_8.bucardo.delta_public_groupMembers 1 0 0 4,608 0 26 30 zemm_produktiv_8.bucardo.delta_public_tmptasks 1 0 0 233,083 0 0 1,312 zemm_produktiv_8.public.litters 1 0 0 93,357 0 0 1,104 zemm_produktiv_8.bucardo.track_public_litters_search_mview 1 0 0 1,993 0 1 15 zemm_produktiv_7.public.login_tracker 1 0 0 86,819 0 0 3,272 zemm_produktiv_8.bucardo.track_public_litters 1 0 0 1,709 0 3 13 zemm_produktiv_8.public.targetgroups 1 0 0 2,285,994 0 0 16,064 zemm_produktiv_8.public.targetgroupMembers 1 0 0 6,593,644 0 0 42,032 Total 136 24 12,173 68,091,102 0 1,439 541,560 Pages removed per table
Key values
- public.cages_search_mview (61) Main table with removed pages on database zemm_produktiv_8
- 1439 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed zemm_produktiv_8.public.cages_search_mview 1 0 0 61 zemm_produktiv_7.public.cages_search_mview 1 0 0 61 zemm_produktiv_8.bucardo.delta_public_breedingsdams 1 0 0 60 zemm_produktiv_7.public.cages 1 0 0 58 zemm_produktiv_8.public.cages 1 0 0 58 zemm_produktiv_7.public.taskattachment 1 0 0 56 zemm_produktiv_8.public.taskattachment 1 0 0 56 zemm_produktiv_7.public.breedings 1 0 0 55 zemm_produktiv_8.public.breedings 1 0 0 55 zemm_produktiv_8.bucardo.track_public_animals_search_mview 1 0 0 54 zemm_produktiv_8.bucardo.track_public_animals 1 0 0 54 zemm_produktiv_8.bucardo.track_public_cages_search_mview 1 0 0 54 zemm_produktiv_8.bucardo.delta_public_breedings 1 0 0 49 zemm_produktiv_8.public.breedingsdams 1 0 0 47 zemm_produktiv_7.public.breedingsdams 1 0 0 47 zemm_produktiv_8.public.tmptasks 1 0 0 45 zemm_produktiv_7.public.tmptasks 1 0 0 45 zemm_produktiv_8.bucardo.track_public_diary 1 0 0 43 zemm_produktiv_8.bucardo.track_public_cages 1 0 0 42 zemm_produktiv_8.bucardo.delta_public_breedingssires 1 0 0 39 zemm_produktiv_8.bucardo.delta_public_license_history 1 0 0 33 zemm_produktiv_8.public.breedingssires 1 0 0 33 zemm_produktiv_7.public.breedingssires 1 0 0 33 zemm_produktiv_8.bucardo.delta_public_litters 1 0 0 33 zemm_produktiv_7.public.user_ui_prefs 1 0 0 30 zemm_produktiv_7.public.license_history 1 0 0 28 zemm_produktiv_8.public.license_history 1 0 0 28 zemm_produktiv_8.bucardo.delta_public_groupMembers 1 0 0 26 zemm_produktiv_8.bucardo.delta_public_roles_users 1 0 0 23 zemm_produktiv_8.bucardo.track_public_targetgroupMembers 1 0 0 19 zemm_produktiv_8.bucardo.track_public_cost_history 1 0 0 18 zemm_produktiv_8.bucardo.track_public_users 1 0 0 13 zemm_produktiv_7.public.strains 1 0 0 12 zemm_produktiv_8.public.strains 1 0 0 12 zemm_produktiv_8.bucardo.track_public_tasks_changes 1 0 0 9 zemm_produktiv_8.bucardo.bucardo_delta_names 1 0 0 8 zemm_produktiv_8.bucardo.track_public_tmptasks 1 0 0 7 zemm_produktiv_8.bucardo.delta_public_scoresheet_answer 1 0 0 5 zemm_produktiv_7.public.scoresheet_answer 1 0 0 4 zemm_produktiv_8.public.scoresheet_answer 1 0 0 4 zemm_produktiv_8.bucardo.delta_public_stresslevel_response 1 0 0 3 zemm_produktiv_8.bucardo.track_public_tasks 1 0 0 3 zemm_produktiv_8.bucardo.track_public_targetgroups 1 0 0 3 zemm_produktiv_8.public.users 2 1 0 3 zemm_produktiv_8.bucardo.track_public_litters 1 0 0 3 zemm_produktiv_7.public.stresslevel_response 1 0 0 2 zemm_produktiv_8.public.stresslevel_response 1 0 0 2 zemm_produktiv_8.bucardo.delta_public_taskattachment 1 0 0 2 zemm_produktiv_8.bucardo.track_public_litters_search_mview 1 0 0 1 zemm_produktiv_8.bucardo.delta_public_targetgroupMembers 1 0 0 0 zemm_produktiv_7.public.diary 1 0 0 0 zemm_produktiv_8.bucardo.delta_public_animals_search_mview 1 0 0 0 zemm_produktiv_8.pg_catalog.pg_class 2 2 25 0 zemm_monitoring.pg_toast.pg_toast_2619 1 1 65 0 zemm_produktiv_8.public.groupMembers 1 0 0 0 zemm_produktiv_8.public.tasks_changes 1 0 0 0 zemm_produktiv_8.public.animals_search_mview 1 0 0 0 zemm_produktiv_8.bucardo.delta_public_users 1 0 0 0 zemm_produktiv_8.pg_catalog.pg_statistic 3 3 790 0 zemm_produktiv_7.pg_catalog.pg_class 1 1 130 0 zemm_produktiv_7.public.scoresheet_diary 1 0 0 0 zemm_produktiv_7.public.animals_search_mview 1 0 0 0 zemm_produktiv_7.public.tasks_changes 1 0 0 0 zemm_produktiv_7.public.targetgroupMembers 1 0 0 0 zemm_produktiv_8.bucardo.delta_public_diary 1 0 0 0 zemm_produktiv_8.bucardo.track_public_breedings 1 0 0 0 zemm_produktiv_8.bucardo.track_public_litter_history 1 0 0 0 zemm_produktiv_7.public.litters_search_mview 1 0 0 0 zemm_produktiv_7.public.litters 1 0 0 0 zemm_produktiv_8.bucardo.delta_public_cages 1 0 0 0 zemm_produktiv_8.public.fem_numbers 1 0 0 0 zemm_produktiv_8.bucardo.track_public_license_history 1 0 0 0 template0.pg_catalog.pg_shdepend 2 1 954 0 zemm_produktiv_8.bucardo.delta_public_fem_numbers 1 0 0 0 zemm_produktiv_7.public.animals 1 0 0 0 zemm_produktiv_8.bucardo.delta_public_scoresheet_response 1 0 0 0 zemm_produktiv_8.public.monitoring_session_activity 1 0 0 0 zemm_produktiv_8.bucardo.delta_public_targetgroups 1 0 0 0 zemm_produktiv_7.public.groupMembers 1 0 0 0 zemm_produktiv_8.pg_catalog.pg_trigger 2 1 0 0 zemm_produktiv_8.bucardo.delta_public_tasks 1 0 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 2 2 4388 0 zemm_produktiv_8.public.scoresheet_diary 1 0 0 0 zemm_produktiv_8.bucardo.delta_public_strains 1 0 0 0 zemm_produktiv_8.bucardo.delta_public_litters_search_mview 1 0 0 0 zemm_produktiv_8.public.cost_history 1 0 0 0 zemm_produktiv_8.public.diary 1 0 0 0 zemm_produktiv_8.public.animals 1 0 0 0 zemm_produktiv_8.bucardo.delta_public_animals 1 0 0 0 zemm_produktiv_7.public.monitoring_session_activity 1 0 0 0 zemm_produktiv_7.public.tasks 1 0 0 0 zemm_produktiv_8.pg_catalog.pg_depend 3 2 3430 0 zemm_produktiv_8.bucardo.delta_public_cost_history 1 0 0 0 zemm_produktiv_8.bucardo.bucardo_truncate_trigger 1 0 0 0 zemm_produktiv_8.pg_toast.pg_toast_2619 2 2 297 0 zemm_produktiv_7.public.targetgroups 1 0 0 0 zemm_produktiv_8.public.login_tracker 1 0 0 0 zemm_produktiv_7.pg_catalog.pg_statistic 1 1 88 0 zemm_produktiv_8.public.tasks 1 0 0 0 zemm_produktiv_8.public.litter_history 1 0 0 0 zemm_produktiv_7.public.fem_numbers 1 0 0 0 postgres.pg_catalog.pg_shdepend 1 1 807 0 zemm_produktiv_8.bucardo.delta_public_litter_history 1 0 0 0 zemm_produktiv_8.public.user_ui_prefs 1 0 0 0 zemm_produktiv_7.pg_catalog.pg_depend 1 1 54 0 zemm_produktiv_8.bucardo.delta_public_login_tracker 1 0 0 0 zemm_produktiv_7.public.users 1 0 0 0 zemm_produktiv_8.pg_catalog.pg_attrdef 1 1 78 0 zemm_produktiv_7.public.cost_history 1 0 0 0 zemm_produktiv_8.bucardo.delta_public_tasks_changes 1 0 0 0 zemm_produktiv_8.bucardo.delta_public_choice 1 0 0 0 zemm_produktiv_8.bucardo.delta_public_cages_search_mview 1 0 0 0 zemm_produktiv_8.public.litters_search_mview 1 0 0 0 zemm_produktiv_8.bucardo.track_public_fem_numbers 1 0 0 0 zemm_produktiv_7.public.litter_history 1 0 0 0 zemm_produktiv_8.bucardo.delta_public_scoresheet_diary 1 0 0 0 zemm_produktiv_8.pg_catalog.pg_type 2 2 496 0 zemm_produktiv_8.bucardo.delta_public_tmptasks 1 0 0 0 zemm_produktiv_8.public.litters 1 0 0 0 zemm_produktiv_7.public.login_tracker 1 0 0 0 zemm_produktiv_8.pg_catalog.pg_index 2 1 398 0 zemm_produktiv_8.public.targetgroups 1 0 0 0 zemm_produktiv_8.public.targetgroupMembers 1 0 0 0 zemm_produktiv_7.pg_catalog.pg_attribute 1 1 173 0 Total 136 24 12,173 1,439 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Mar 06 22 0 4 23 136 177 - 9.36 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 4 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 1s22ms 1s22ms 1s22ms 1s22ms create index dex1_public_animals_search_mview on bucardo.delta_public_animals_search_mview using btree (txntime);-
CREATE INDEX dex1_public_animals_search_mview ON bucardo.delta_public_animals_search_mview USING btree (txntime);
Date: 2026-03-06 23:12:11 Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
2 1 1s 1s 1s 1s create index "dex1_public_targetgroupMembers" on bucardo."delta_public_targetgroupMembers" using btree (txntime);-
CREATE INDEX "dex1_public_targetgroupMembers" ON bucardo."delta_public_targetgroupMembers" USING btree (txntime);
Date: 2026-03-06 23:12:21 Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
3 1 1s 1s 1s 1s create index dex1_public_cages_search_mview on bucardo.delta_public_cages_search_mview using btree (txntime);-
CREATE INDEX dex1_public_cages_search_mview ON bucardo.delta_public_cages_search_mview USING btree (txntime);
Date: 2026-03-06 23:12:15 Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
4 1 1s 1s 1s 1s create index dex1_public_cost_history on bucardo.delta_public_cost_history using btree (txntime);-
CREATE INDEX dex1_public_cost_history ON bucardo.delta_public_cost_history USING btree (txntime);
Date: 2026-03-06 23:12:17 Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
Queries that waited the most
Rank Wait time Query 1 1s22ms CREATE INDEX dex1_public_animals_search_mview ON bucardo.delta_public_animals_search_mview USING btree (txntime);[ Date: 2026-03-06 23:12:12 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
2 1s CREATE INDEX "dex1_public_targetgroupMembers" ON bucardo."delta_public_targetgroupMembers" USING btree (txntime);[ Date: 2026-03-06 23:12:22 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
3 1s CREATE INDEX dex1_public_cages_search_mview ON bucardo.delta_public_cages_search_mview USING btree (txntime);[ Date: 2026-03-06 23:12:16 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
4 1s CREATE INDEX dex1_public_cost_history ON bucardo.delta_public_cost_history USING btree (txntime);[ Date: 2026-03-06 23:12:18 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
-
Queries
Queries by type
Key values
- 0 Total read queries
- 3,635 Total write queries
Queries by database
Key values
- zemm_produktiv_8 Main database
- 2,421 Requests
- 42m47s (zemm_produktiv_8)
- Main time consuming database
Database Request type Count Duration bucardo Total 1 0ms ddl 1 0ms fbi_ci_db Total 1 0ms ddl 1 0ms fbi_unibi Total 1 0ms ddl 1 0ms fbi_unire Total 1 0ms ddl 1 0ms invdb Total 1 0ms ddl 1 0ms labanimal Total 1 0ms ddl 1 0ms postgres Total 7 5s746ms ddl 5 4s167ms zemm_monitoring Total 829 24m12s ddl 829 24m12s zemm_produktiv_7 Total 1,078 18m38s copy from 7 14s157ms copy to 18 1m2s ddl 705 11m15s others 339 5m54s zemm_produktiv_8 Total 2,421 42m47s copy from 12 40s216ms copy to 37 1m15s cte 5 10s291ms ddl 2,009 34m31s others 340 5m37s zemm_test_2 Total 1 0ms ddl 1 0ms zemm_test_3 Total 1 0ms ddl 1 0ms Queries by user
Key values
- postgres Main user
- 3,515 Requests
User Request type Count Duration labanimal Total 828 24m12s ddl 828 24m12s postgres Total 3,515 1h1m32s copy from 19 54s373ms copy to 55 2m18s cte 5 10s291ms ddl 2,728 45m51s others 679 11m32s Duration by user
Key values
- 1h1m32s (postgres) Main time consuming user
User Request type Count Duration labanimal Total 828 24m12s ddl 828 24m12s postgres Total 3,515 1h1m32s copy from 19 54s373ms copy to 55 2m18s cte 5 10s291ms ddl 2,728 45m51s others 679 11m32s Queries by host
Key values
- [local] Main host
- 3,515 Requests
- 1h1m32s ([local])
- Main time consuming host
Queries by application
Key values
- pg_restore Main application
- 3,380 Requests
- 58m12s (pg_restore)
- Main time consuming application
Application Request type Count Duration createdb Total 2 1s579ms ddl 2 1s579ms dropdb Total 4 3s613ms ddl 2 2s33ms pg_dump Total 55 2m18s copy to 55 2m18s pg_restore Total 3,380 58m12s copy from 19 54s373ms ddl 2,666 45m16s others 671 11m21s psql Total 74 55s904ms cte 5 10s291ms ddl 58 31s370ms others 8 10s969ms unknown Total 828 24m12s ddl 828 24m12s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-03-06 23:39:48 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 74 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 14s201ms COPY bucardo.delta_public_cost_history (id, txntime) TO stdout;[ Date: 2026-03-06 23:37:44 - Database: zemm_produktiv_7 - User: postgres - Remote: [local] - Application: pg_dump ]
2 14s181ms COPY bucardo.delta_public_animals_search_mview (id, txntime) TO stdout;[ Date: 2026-03-06 23:37:27 - Database: zemm_produktiv_7 - User: postgres - Remote: [local] - Application: pg_dump ]
3 11s441ms COPY bucardo.delta_public_cost_history (id, txntime) FROM stdin;[ Date: 2026-03-06 23:11:48 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
4 11s30ms COPY bucardo.delta_public_animals_search_mview (id, txntime) FROM stdin;[ Date: 2026-03-06 23:11:35 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_restore ]
5 6s835ms COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;[ Date: 2026-03-06 23:24:18 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_dump ]
6 6s824ms COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;[ Date: 2026-03-06 23:39:02 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: pg_dump ]
7 6s743ms COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;[ Date: 2026-03-06 23:38:15 - Database: zemm_produktiv_7 - User: postgres - Remote: [local] - Application: pg_dump ]
8 6s685ms VACUUM (ANALYZE);[ Date: 2026-03-06 23:17:52 - Database: zemm_produktiv_8 - User: postgres - Remote: [local] - Application: psql ]
9 6s685ms CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-03-06 23:18:01 - Database: zemm_monitoring - User: labanimal ]
10 6s685ms CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );[ Date: 2026-03-06 23:18:01 - Database: zemm_monitoring - User: labanimal ]
11 6s685ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-03-06 23:18:01 - Database: zemm_monitoring - User: labanimal ]
12 6s685ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-03-06 23:18:01 - Database: zemm_monitoring - User: labanimal ]
13 6s685ms CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-03-06 23:18:01 - Database: zemm_monitoring - User: labanimal ]
14 6s685ms CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);[ Date: 2026-03-06 23:18:01 - Database: zemm_monitoring - User: labanimal ]
15 6s685ms CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);[ Date: 2026-03-06 23:18:01 - Database: zemm_monitoring - User: labanimal ]
16 6s685ms CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-03-06 23:18:01 - Database: zemm_monitoring - User: labanimal ]
17 6s685ms CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);[ Date: 2026-03-06 23:18:01 - Database: zemm_monitoring - User: labanimal ]
18 6s685ms CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-03-06 23:18:01 - Database: zemm_monitoring - User: labanimal ]
19 6s685ms CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-03-06 23:18:01 - Database: zemm_monitoring - User: labanimal ]
20 6s685ms CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-03-06 23:18:01 - Database: zemm_monitoring - User: labanimal ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2m1s 69 0ms 6s685ms 1s754ms create table if not exists observability.metrics_timeseries ( id bigserial primary key, tenant_key text not null, metric_name text not null, bucket_start timestamptz not null, bucket_width_seconds integer not null default ?, sum_value double precision not null default ?, count_value bigint not null default ?, histogram jsonb, created_at timestamptz not null default now(), updated_at timestamptz not null default now(), unique (tenant_key, metric_name, bucket_start, bucket_width_seconds) );Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
2 2m1s 69 0ms 6s685ms 1s754ms create table if not exists observability.uptime_checks ( id bigserial primary key, endpoint text not null, status text not null, latency_ms double precision, checked_at timestamptz not null default now() );Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
3 2m1s 69 0ms 6s685ms 1s754ms create table if not exists observability.phpfpm_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
4 2m1s 69 0ms 6s685ms 1s754ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
5 2m1s 69 0ms 6s685ms 1s754ms create table if not exists observability.app_events ( id bigserial primary key, tenant_key text not null, event_type text not null, severity text not null, message text not null, payload jsonb, occurred_at timestamptz not null default now(), created_at timestamptz not null default now() );Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
6 2m1s 69 0ms 6s685ms 1s754ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
7 2m1s 69 0ms 6s685ms 1s754ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
8 2m1s 69 0ms 6s685ms 1s754ms create schema if not exists observability;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
9 2m1s 69 0ms 6s685ms 1s754ms create index if not exists idx_db_top_queries_tenant on observability.db_top_queries (tenant_key, collected_at desc);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
10 2m1s 69 0ms 6s685ms 1s754ms create table if not exists observability.nginx_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
11 2m1s 69 0ms 6s685ms 1s754ms create table if not exists observability.db_top_queries ( id bigserial primary key, tenant_key text not null, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz not null default now() );Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
12 2m1s 69 0ms 6s685ms 1s754ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
13 24s489ms 6 1s321ms 6s835ms 4s81ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 06 23 6 24s489ms 4s81ms [ User: postgres - Total duration: 24s489ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 24s489ms - Times executed: 6 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-06 23:24:18 Duration: 6s835ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-06 23:39:02 Duration: 6s824ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-06 23:38:15 Duration: 6s743ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
14 18s813ms 6 1s290ms 4s986ms 3s135ms copy public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 06 23 6 18s813ms 3s135ms [ User: postgres - Total duration: 18s813ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 18s813ms - Times executed: 6 ]
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-06 23:38:48 Duration: 4s986ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-06 23:24:05 Duration: 4s971ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-06 23:38:02 Duration: 4s971ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
15 18s168ms 2 3s986ms 14s181ms 9s84ms copy bucardo.delta_public_animals_search_mview (id, txntime) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 06 23 2 18s168ms 9s84ms [ User: postgres - Total duration: 18s168ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 18s168ms - Times executed: 2 ]
-
COPY bucardo.delta_public_animals_search_mview (id, txntime) TO stdout;
Date: 2026-03-06 23:37:27 Duration: 14s181ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY bucardo.delta_public_animals_search_mview (id, txntime) TO stdout;
Date: 2026-03-06 23:09:46 Duration: 3s986ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
16 18s150ms 2 3s949ms 14s201ms 9s75ms copy bucardo.delta_public_cost_history (id, txntime) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 06 23 2 18s150ms 9s75ms [ User: postgres - Total duration: 18s150ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 18s150ms - Times executed: 2 ]
-
COPY bucardo.delta_public_cost_history (id, txntime) TO stdout;
Date: 2026-03-06 23:37:44 Duration: 14s201ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY bucardo.delta_public_cost_history (id, txntime) TO stdout;
Date: 2026-03-06 23:09:55 Duration: 3s949ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
17 17s51ms 6 1s219ms 5s994ms 2s841ms copy public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 06 23 6 17s51ms 2s841ms [ User: postgres - Total duration: 17s51ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 17s51ms - Times executed: 6 ]
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-06 23:37:57 Duration: 5s994ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-06 23:38:43 Duration: 3s48ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-06 23:24:00 Duration: 3s43ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
18 15s608ms 6 1s962ms 3s172ms 2s601ms copy public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 06 23 6 15s608ms 2s601ms [ User: postgres - Total duration: 15s608ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 15s608ms - Times executed: 6 ]
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-06 23:24:09 Duration: 3s172ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-06 23:38:53 Duration: 3s171ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-06 23:38:06 Duration: 3s133ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
19 11s441ms 1 11s441ms 11s441ms 11s441ms copy bucardo.delta_public_cost_history (id, txntime) from stdin;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 06 23 1 11s441ms 11s441ms [ User: postgres - Total duration: 11s441ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 11s441ms - Times executed: 1 ]
-
COPY bucardo.delta_public_cost_history (id, txntime) FROM stdin;
Date: 2026-03-06 23:11:48 Duration: 11s441ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
20 11s30ms 1 11s30ms 11s30ms 11s30ms copy bucardo.delta_public_animals_search_mview (id, txntime) from stdin;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 06 23 1 11s30ms 11s30ms [ User: postgres - Total duration: 11s30ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 11s30ms - Times executed: 1 ]
-
COPY bucardo.delta_public_animals_search_mview (id, txntime) FROM stdin;
Date: 2026-03-06 23:11:35 Duration: 11s30ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 69 2m1s 0ms 6s685ms 1s754ms create table if not exists observability.metrics_timeseries ( id bigserial primary key, tenant_key text not null, metric_name text not null, bucket_start timestamptz not null, bucket_width_seconds integer not null default ?, sum_value double precision not null default ?, count_value bigint not null default ?, histogram jsonb, created_at timestamptz not null default now(), updated_at timestamptz not null default now(), unique (tenant_key, metric_name, bucket_start, bucket_width_seconds) );Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
2 69 2m1s 0ms 6s685ms 1s754ms create table if not exists observability.uptime_checks ( id bigserial primary key, endpoint text not null, status text not null, latency_ms double precision, checked_at timestamptz not null default now() );Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
3 69 2m1s 0ms 6s685ms 1s754ms create table if not exists observability.phpfpm_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
4 69 2m1s 0ms 6s685ms 1s754ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
5 69 2m1s 0ms 6s685ms 1s754ms create table if not exists observability.app_events ( id bigserial primary key, tenant_key text not null, event_type text not null, severity text not null, message text not null, payload jsonb, occurred_at timestamptz not null default now(), created_at timestamptz not null default now() );Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
6 69 2m1s 0ms 6s685ms 1s754ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
7 69 2m1s 0ms 6s685ms 1s754ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
8 69 2m1s 0ms 6s685ms 1s754ms create schema if not exists observability;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
9 69 2m1s 0ms 6s685ms 1s754ms create index if not exists idx_db_top_queries_tenant on observability.db_top_queries (tenant_key, collected_at desc);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
10 69 2m1s 0ms 6s685ms 1s754ms create table if not exists observability.nginx_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
11 69 2m1s 0ms 6s685ms 1s754ms create table if not exists observability.db_top_queries ( id bigserial primary key, tenant_key text not null, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz not null default now() );Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
12 69 2m1s 0ms 6s685ms 1s754ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
13 14 1s660ms 0ms 553ms 118ms create extension if not exists pg_stat_statements;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 06 22 11 0ms 0ms 23 3 1s660ms 553ms [ User: postgres - Total duration: 1s660ms - Times executed: 3 ]
[ Application: psql - Total duration: 1s660ms - Times executed: 3 ]
-
CREATE EXTENSION IF NOT EXISTS pg_stat_statements;
Date: 2026-03-06 23:33:48 Duration: 553ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: psql Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
14 6 24s489ms 1s321ms 6s835ms 4s81ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 06 23 6 24s489ms 4s81ms [ User: postgres - Total duration: 24s489ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 24s489ms - Times executed: 6 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-06 23:24:18 Duration: 6s835ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-06 23:39:02 Duration: 6s824ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-06 23:38:15 Duration: 6s743ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
15 6 18s813ms 1s290ms 4s986ms 3s135ms copy public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 06 23 6 18s813ms 3s135ms [ User: postgres - Total duration: 18s813ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 18s813ms - Times executed: 6 ]
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-06 23:38:48 Duration: 4s986ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-06 23:24:05 Duration: 4s971ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-06 23:38:02 Duration: 4s971ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
16 6 17s51ms 1s219ms 5s994ms 2s841ms copy public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 06 23 6 17s51ms 2s841ms [ User: postgres - Total duration: 17s51ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 17s51ms - Times executed: 6 ]
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-06 23:37:57 Duration: 5s994ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-06 23:38:43 Duration: 3s48ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-06 23:24:00 Duration: 3s43ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
17 6 15s608ms 1s962ms 3s172ms 2s601ms copy public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 06 23 6 15s608ms 2s601ms [ User: postgres - Total duration: 15s608ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 15s608ms - Times executed: 6 ]
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-06 23:24:09 Duration: 3s172ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-06 23:38:53 Duration: 3s171ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-06 23:38:06 Duration: 3s133ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
18 6 5s337ms 536ms 1s229ms 889ms copy public.cost_history (id, service, fromdate, todate, animal, animalgroup, comment, deleted, invoice, amount, license, kostenstelle_erb, drittmittel, kostenstelle_anf, finanzstelle_anf, kostenkategorie, extern_anf, form_text, mat_nr, supersedes, price) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 06 23 6 5s337ms 889ms [ User: postgres - Total duration: 5s337ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 5s337ms - Times executed: 6 ]
-
COPY public.cost_history (id, service, fromdate, todate, animal, animalgroup, comment, deleted, invoice, amount, license, kostenstelle_erb, drittmittel, kostenstelle_anf, finanzstelle_anf, kostenkategorie, extern_anf, form_text, mat_nr, supersedes, price) TO stdout;
Date: 2026-03-06 23:38:03 Duration: 1s229ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.cost_history (id, service, fromdate, todate, animal, animalgroup, comment, deleted, invoice, amount, license, kostenstelle_erb, drittmittel, kostenstelle_anf, finanzstelle_anf, kostenkategorie, extern_anf, form_text, mat_nr, supersedes, price) TO stdout;
Date: 2026-03-06 23:38:50 Duration: 1s209ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.cost_history (id, service, fromdate, todate, animal, animalgroup, comment, deleted, invoice, amount, license, kostenstelle_erb, drittmittel, kostenstelle_anf, finanzstelle_anf, kostenkategorie, extern_anf, form_text, mat_nr, supersedes, price) TO stdout;
Date: 2026-03-06 23:24:06 Duration: 1s207ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
19 3 3s918ms 1s294ms 1s320ms 1s306ms copy public.targetgroups (id, title) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 06 23 3 3s918ms 1s306ms [ User: postgres - Total duration: 3s918ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 3s918ms - Times executed: 3 ]
-
COPY public.targetgroups (id, title) TO stdout;
Date: 2026-03-06 23:38:16 Duration: 1s320ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.targetgroups (id, title) TO stdout;
Date: 2026-03-06 23:24:20 Duration: 1s304ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.targetgroups (id, title) TO stdout;
Date: 2026-03-06 23:39:03 Duration: 1s294ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
20 3 3s306ms 1s98ms 1s109ms 1s102ms copy public.tasks (id, name, "order", parent, method, "entryValue", "returnedValue", agent, done, deadline, loc, instructions, comment, owner, active, deadline_notified, deleted, editor, task_status, link, prio_owner, prio_editor, prio_agent, time_issued, issuer, time_completed, completed_by) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 06 23 3 3s306ms 1s102ms [ User: postgres - Total duration: 3s306ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 3s306ms - Times executed: 3 ]
-
COPY public.tasks (id, name, "order", parent, method, "entryValue", "returnedValue", agent, done, deadline, loc, instructions, comment, owner, active, deadline_notified, deleted, editor, task_status, link, prio_owner, prio_editor, prio_agent, time_issued, issuer, time_completed, completed_by) TO stdout;
Date: 2026-03-06 23:38:18 Duration: 1s109ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.tasks (id, name, "order", parent, method, "entryValue", "returnedValue", agent, done, deadline, loc, instructions, comment, owner, active, deadline_notified, deleted, editor, task_status, link, prio_owner, prio_editor, prio_agent, time_issued, issuer, time_completed, completed_by) TO stdout;
Date: 2026-03-06 23:39:04 Duration: 1s98ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.tasks (id, name, "order", parent, method, "entryValue", "returnedValue", agent, done, deadline, loc, instructions, comment, owner, active, deadline_notified, deleted, editor, task_status, link, prio_owner, prio_editor, prio_agent, time_issued, issuer, time_completed, completed_by) TO stdout;
Date: 2026-03-06 23:24:21 Duration: 1s98ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 11s441ms 11s441ms 11s441ms 1 11s441ms copy bucardo.delta_public_cost_history (id, txntime) from stdin;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 06 23 1 11s441ms 11s441ms [ User: postgres - Total duration: 11s441ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 11s441ms - Times executed: 1 ]
-
COPY bucardo.delta_public_cost_history (id, txntime) FROM stdin;
Date: 2026-03-06 23:11:48 Duration: 11s441ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
2 11s30ms 11s30ms 11s30ms 1 11s30ms copy bucardo.delta_public_animals_search_mview (id, txntime) from stdin;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 06 23 1 11s30ms 11s30ms [ User: postgres - Total duration: 11s30ms - Times executed: 1 ]
[ Application: pg_restore - Total duration: 11s30ms - Times executed: 1 ]
-
COPY bucardo.delta_public_animals_search_mview (id, txntime) FROM stdin;
Date: 2026-03-06 23:11:35 Duration: 11s30ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
3 3s986ms 14s181ms 9s84ms 2 18s168ms copy bucardo.delta_public_animals_search_mview (id, txntime) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 06 23 2 18s168ms 9s84ms [ User: postgres - Total duration: 18s168ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 18s168ms - Times executed: 2 ]
-
COPY bucardo.delta_public_animals_search_mview (id, txntime) TO stdout;
Date: 2026-03-06 23:37:27 Duration: 14s181ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY bucardo.delta_public_animals_search_mview (id, txntime) TO stdout;
Date: 2026-03-06 23:09:46 Duration: 3s986ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
4 3s949ms 14s201ms 9s75ms 2 18s150ms copy bucardo.delta_public_cost_history (id, txntime) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 06 23 2 18s150ms 9s75ms [ User: postgres - Total duration: 18s150ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 18s150ms - Times executed: 2 ]
-
COPY bucardo.delta_public_cost_history (id, txntime) TO stdout;
Date: 2026-03-06 23:37:44 Duration: 14s201ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY bucardo.delta_public_cost_history (id, txntime) TO stdout;
Date: 2026-03-06 23:09:55 Duration: 3s949ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
5 1s321ms 6s835ms 4s81ms 6 24s489ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 06 23 6 24s489ms 4s81ms [ User: postgres - Total duration: 24s489ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 24s489ms - Times executed: 6 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-06 23:24:18 Duration: 6s835ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-06 23:39:02 Duration: 6s824ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-06 23:38:15 Duration: 6s743ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
6 1s290ms 4s986ms 3s135ms 6 18s813ms copy public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 06 23 6 18s813ms 3s135ms [ User: postgres - Total duration: 18s813ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 18s813ms - Times executed: 6 ]
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-06 23:38:48 Duration: 4s986ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-06 23:24:05 Duration: 4s971ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-06 23:38:02 Duration: 4s971ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
7 1s219ms 5s994ms 2s841ms 6 17s51ms copy public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 06 23 6 17s51ms 2s841ms [ User: postgres - Total duration: 17s51ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 17s51ms - Times executed: 6 ]
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-06 23:37:57 Duration: 5s994ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-06 23:38:43 Duration: 3s48ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-06 23:24:00 Duration: 3s43ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
8 1s962ms 3s172ms 2s601ms 6 15s608ms copy public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 06 23 6 15s608ms 2s601ms [ User: postgres - Total duration: 15s608ms - Times executed: 6 ]
[ Application: pg_dump - Total duration: 15s608ms - Times executed: 6 ]
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-06 23:24:09 Duration: 3s172ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-06 23:38:53 Duration: 3s171ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-06 23:38:06 Duration: 3s133ms Database: zemm_produktiv_7 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
9 0ms 6s685ms 1s754ms 69 2m1s create table if not exists observability.metrics_timeseries ( id bigserial primary key, tenant_key text not null, metric_name text not null, bucket_start timestamptz not null, bucket_width_seconds integer not null default ?, sum_value double precision not null default ?, count_value bigint not null default ?, histogram jsonb, created_at timestamptz not null default now(), updated_at timestamptz not null default now(), unique (tenant_key, metric_name, bucket_start, bucket_width_seconds) );Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
10 0ms 6s685ms 1s754ms 69 2m1s create table if not exists observability.uptime_checks ( id bigserial primary key, endpoint text not null, status text not null, latency_ms double precision, checked_at timestamptz not null default now() );Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
11 0ms 6s685ms 1s754ms 69 2m1s create table if not exists observability.phpfpm_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
12 0ms 6s685ms 1s754ms 69 2m1s create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
13 0ms 6s685ms 1s754ms 69 2m1s create table if not exists observability.app_events ( id bigserial primary key, tenant_key text not null, event_type text not null, severity text not null, message text not null, payload jsonb, occurred_at timestamptz not null default now(), created_at timestamptz not null default now() );Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
14 0ms 6s685ms 1s754ms 69 2m1s create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
15 0ms 6s685ms 1s754ms 69 2m1s create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
16 0ms 6s685ms 1s754ms 69 2m1s create schema if not exists observability;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
17 0ms 6s685ms 1s754ms 69 2m1s create index if not exists idx_db_top_queries_tenant on observability.db_top_queries (tenant_key, collected_at desc);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
18 0ms 6s685ms 1s754ms 69 2m1s create table if not exists observability.nginx_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
19 0ms 6s685ms 1s754ms 69 2m1s create table if not exists observability.db_top_queries ( id bigserial primary key, tenant_key text not null, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz not null default now() );Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
20 0ms 6s685ms 1s754ms 69 2m1s create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 06 22 9 0ms 0ms 23 60 2m1s 2s17ms [ User: labanimal - Total duration: 2m1s - Times executed: 60 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-06 23:21:01 Duration: 6s685ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-06 23:38:01 Duration: 5s994ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-06 23:09:01 Duration: 4s596ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
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
-
Events
Log levels
Key values
- 17,222 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 299 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 271 Max number of times the same event was reported
- 299 Total events found
Rank Times reported Error 1 271 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 06 22 40 23 231 - FATAL: database "monitoring" does not exist
- FATAL: database "fbi_zemm" does not exist
- FATAL: database "monitoring" does not exist
Date: 2026-03-06 22:52:24 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-06_225214.csv
Date: 2026-03-06 22:50:17 Database: fbi_zemm Application: psql User: postgres Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-06_225012.csv
Date: 2026-03-06 22:50:24 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-06_225012.csv
2 7 LOG: skipping analyze of "..." --- lock not available
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 06 23 7 - LOG: skipping analyze of "delta_public_cost_history" --- lock not available
- LOG: skipping analyze of "targetgroups" --- lock not available
- LOG: skipping analyze of "taskattachment" --- lock not available
Date: 2026-03-06 23:12:27 Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
Date: 2026-03-06 23:12:41 Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
Date: 2026-03-06 23:12:41 Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
3 4 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 06 23 4 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: while scanning block 45614 of relation "bucardo.delta_public_animals_search_mview" automatic vacuum of table "zemm_produktiv_8.bucardo.delta_public_animals_search_mview"
Date: 2026-03-06 23:12:12 Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
Context: while scanning block 9322 of relation "bucardo.delta_public_cages_search_mview" automatic vacuum of table "zemm_produktiv_8.bucardo.delta_public_cages_search_mview"
Date: 2026-03-06 23:12:16 Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
Context: while scanning block 4156 of relation "bucardo.delta_public_cost_history" automatic vacuum of table "zemm_produktiv_8.bucardo.delta_public_cost_history"
Date: 2026-03-06 23:12:18 Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
4 4 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #4
Day Hour Count Mar 06 23 4 - LOG: process 2444132 still waiting for ShareLock on relation 107640 of database 107134 after 1000.055 ms
- LOG: process 2444132 still waiting for ShareLock on relation 107675 of database 107134 after 1000.063 ms
- LOG: process 2444132 still waiting for ShareLock on relation 107715 of database 107134 after 1000.059 ms
Detail: Process holding the lock: 2444361. Wait queue: 2444132.
Statement: CREATE INDEX dex1_public_animals_search_mview ON bucardo.delta_public_animals_search_mview USING btree (txntime);Date: 2026-03-06 23:12:12 Database: zemm_produktiv_8 Application: pg_restore User: postgres Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
Detail: Process holding the lock: 2444361. Wait queue: 2444132.
Statement: CREATE INDEX dex1_public_cages_search_mview ON bucardo.delta_public_cages_search_mview USING btree (txntime);Date: 2026-03-06 23:12:16 Database: zemm_produktiv_8 Application: pg_restore User: postgres Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
Detail: Process holding the lock: 2444361. Wait queue: 2444132.
Statement: CREATE INDEX dex1_public_cost_history ON bucardo.delta_public_cost_history USING btree (txntime);Date: 2026-03-06 23:12:18 Database: zemm_produktiv_8 Application: pg_restore User: postgres Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
5 4 FATAL: Peer authentication failed for user "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Mar 06 23 4 - FATAL: Peer authentication failed for user "id,"
- FATAL: Peer authentication failed for user "id,"
- FATAL: Peer authentication failed for user "from"
Detail: Connection matched file "/etc/postgresql/18/main/pg_hba.conf" line 18: "local all all peer"
Date: 2026-03-06 23:00:45 Database: zemm_produktiv_8 Application: User: id, Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
Detail: Connection matched file "/etc/postgresql/18/main/pg_hba.conf" line 18: "local all all peer"
Date: 2026-03-06 23:00:45 Database: zemm_produktiv_8 Application: User: id, Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
Detail: Connection matched file "/etc/postgresql/18/main/pg_hba.conf" line 18: "local all all peer"
Date: 2026-03-06 23:09:09 Database: datname Application: User: from Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
6 3 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #6
Day Hour Count Mar 06 22 3 - LOG: database system was shut down at 2026-03-06 22:52:14 CET
- LOG: database system was shut down at 2026-03-06 22:50:09 CET
- LOG: database system was shut down at 2026-03-06 22:52:39 CET
Date: 2026-03-06 22:52:14 Log file: /var/log/postgresql/postgresql-2026-03-06_225214.csv
Date: 2026-03-06 22:50:12 Log file: /var/log/postgresql/postgresql-2026-03-06_225012.csv
Date: 2026-03-06 22:52:39 Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
7 2 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Mar 06 23 2 - ERROR: syntax error at or near "SQL"
- ERROR: syntax error at or near "\"
Statement: SQL
Date: 2026-03-06 23:13:12 Database: zemm_produktiv_8 Application: psql User: postgres Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
Statement: ANALYZE public.\ targetgroupMembers\; ANALYZE public.diary; ANALYZE public.cost_history; ANALYZE public.license_history; ANALYZE public.login_tracker;
Date: 2026-03-06 23:27:06 Database: zemm_produktiv_8 Application: psql User: postgres Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
8 2 ERROR: invalid input syntax for type boolean: ...
Times Reported Most Frequent Error / Event #8
Day Hour Count Mar 06 23 2 - ERROR: invalid input syntax for type boolean: ""
- ERROR: invalid input syntax for type boolean: ""
Statement: SELECT a.id AS animal_id, COALESCE(a."animalID", a.identification, '') AS animal_identifier, a.fate, COALESCE(a."fateComment", '') AS fate_comment, a."deathDate" AS death_date, a."outgoingDate" AS outgoing_date, a."birthDate" AS birth_date, COALESCE(a.sex, '') AS sex, COALESCE(a.transgen, 0) AS transgen, COALESCE(a."geneStatus", '') AS gene_status, COALESCE(a."geneFlanking", '') AS gene_flanking, COALESCE(a."geneDeleted", '') AS gene_deleted, COALESCE(a.genecomment, '') AS gene_comment, COALESCE(a.project, '') AS project_id, COALESCE(a."plannedUseFor", '') AS planned_use_for, COALESCE(l.id, 0) AS license_id, COALESCE(l.application_id, '') AS application_id, COALESCE(l.az, '') AS az, COALESCE(l.title, '') AS license_title, COALESCE(l.category, 0) AS license_category, COALESCE(l.permission, '') AS permission, COALESCE(g.name, '') AS workgroup, COALESCE(s.line_abnormality, '') AS line_abnormality, COALESCE(s.cancel_criteria, '') AS cancel_criteria, COALESCE(s.severityid, 0) AS strain_severityid, COALESCE(stress.max_score, 0)::numeric AS stress_hint_score FROM animals a LEFT JOIN licenses l ON (a.project ~ '^[0-9]+$' AND l.id = CAST(a.project AS BIGINT)) LEFT JOIN groups g ON g.id = l.workgroup LEFT JOIN strains s ON s.id = a.strain LEFT JOIN ( SELECT sd.animals_id AS animal_id, MAX(sl."maxvalue") AS max_score FROM scoresheet_diary sd INNER JOIN stresslevel_response slr ON slr.scoresheet_response_id = sd.scoresheet_response_id INNER JOIN stress_levels sl ON sl.id = slr.stresslevel_id GROUP BY sd.animals_id ) stress ON stress.animal_id = a.id WHERE NOT(a.deleted) AND ( (a."deathDate" IS NOT NULL AND a."deathDate" >= '2026-01-01'::DATE AND a."deathDate" <= '2026-12-31'::DATE) OR (a."outgoingDate" IS NOT NULL AND a."outgoingDate" >= '2026-01-01'::DATE AND a."outgoingDate" <= '2026-12-31'::DATE) OR (a.fate IN (1, 10, 11, 13, 14, 15, 9, 4) AND a."deathDate" IS NULL AND a."outgoingDate" IS NULL) ) ORDER BY g.name, l.application_id, a.id
Date: 2026-03-06 23:56:48 Database: zemm_produktiv_8 Application: _desktop_index.php_command_reports_subcommand_authority_meldung User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
Statement: SELECT a.id AS animal_id, COALESCE(a."animalID", a.identification, '') AS animal_identifier, a.fate, COALESCE(a."fateComment", '') AS fate_comment, a."deathDate" AS death_date, a."outgoingDate" AS outgoing_date, a."birthDate" AS birth_date, COALESCE(a.sex, '') AS sex, COALESCE(a.transgen, 0) AS transgen, COALESCE(a."geneStatus", '') AS gene_status, COALESCE(a."geneFlanking", '') AS gene_flanking, COALESCE(a."geneDeleted", '') AS gene_deleted, COALESCE(a.genecomment, '') AS gene_comment, COALESCE(a.project, '') AS project_id, COALESCE(a."plannedUseFor", '') AS planned_use_for, COALESCE(l.id, 0) AS license_id, COALESCE(l.application_id, '') AS application_id, COALESCE(l.az, '') AS az, COALESCE(l.title, '') AS license_title, COALESCE(l.category, 0) AS license_category, COALESCE(l.permission, '') AS permission, COALESCE(g.name, '') AS workgroup, COALESCE(s.line_abnormality, '') AS line_abnormality, COALESCE(s.cancel_criteria, '') AS cancel_criteria, COALESCE(s.severityid, 0) AS strain_severityid, COALESCE(stress.max_score, 0)::numeric AS stress_hint_score FROM animals a LEFT JOIN licenses l ON (a.project ~ '^[0-9]+$' AND l.id = CAST(a.project AS BIGINT)) LEFT JOIN groups g ON g.id = l.workgroup LEFT JOIN strains s ON s.id = a.strain LEFT JOIN ( SELECT sd.animals_id AS animal_id, MAX(sl."maxvalue") AS max_score FROM scoresheet_diary sd INNER JOIN stresslevel_response slr ON slr.scoresheet_response_id = sd.scoresheet_response_id INNER JOIN stress_levels sl ON sl.id = slr.stresslevel_id GROUP BY sd.animals_id ) stress ON stress.animal_id = a.id WHERE NOT(a.deleted) AND ( (a."deathDate" IS NOT NULL AND a."deathDate" >= '2026-01-01'::DATE AND a."deathDate" <= '2026-12-31'::DATE) OR (a."outgoingDate" IS NOT NULL AND a."outgoingDate" >= '2026-01-01'::DATE AND a."outgoingDate" <= '2026-12-31'::DATE) OR (a.fate IN (1, 10, 11, 13, 14, 15, 9, 4) AND a."deathDate" IS NULL AND a."outgoingDate" IS NULL) ) ORDER BY g.name, l.application_id, a.id
Date: 2026-03-06 23:56:49 Database: zemm_produktiv_8 Application: _desktop_index.php_command_reports_subcommand_authority_meldung User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
9 1 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Mar 06 23 1 - ERROR: column "table_name" does not exist
Statement: select table_name, n_live_tup from pg_stat_user_tables where schemaname='public' and table_name in ('tmptasks','tasks_changes','login_tracker','scoresheet_diary') order by 1;
Date: 2026-03-06 23:17:11 Database: zemm_produktiv_8 Application: psql User: postgres Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv
10 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Mar 06 23 1 - ERROR: relation "pg_stat_statements" does not exist
Statement: select queryid, calls, round(total_exec_time::numeric,2) as total_ms, round(mean_exec_time::numeric,2) as mean_ms, rows, left(regexp_replace(query, '\s+', ' ', 'g'), 300) as query from pg_stat_statements where dbid = (select oid from pg_database where datname='zemm_produktiv_8') order by total_exec_time desc limit 20;
Date: 2026-03-06 23:31:05 Database: postgres Application: psql User: postgres Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-06_225239.csv