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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

CREATE INDEX CONCURRENTLY IF NOT EXISTS animals_curcage_active_idx ON public.animals ("curCage") WHERE NOT deleted;

Date: 2026-03-07 11:46:11
Duration: 987ms
Database: zemm_produktiv_7
User: labanimal
Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv

CREATE INDEX CONCURRENTLY IF NOT EXISTS animals_curcage_active_idx ON public.animals ("curCage") WHERE NOT deleted;

Date: 2026-03-07 11:46:08
Duration: 802ms
Database: zemm_produktiv_8
User: labanimal
Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

CREATE INDEX CONCURRENTLY IF NOT EXISTS animals_animalid_idx ON public.animals ("animalID");

Date: 2026-03-07 11:46:11
Duration: 987ms
Database: zemm_produktiv_7
User: labanimal
Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv

CREATE INDEX CONCURRENTLY IF NOT EXISTS animals_animalid_idx ON public.animals ("animalID");

Date: 2026-03-07 11:46:08
Duration: 802ms
Database: zemm_produktiv_8
User: labanimal
Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

CREATE INDEX CONCURRENTLY IF NOT EXISTS login_tracker_loginname_timestamp_idx ON public.login_tracker (loginname, "timestamp" DESC);

Date: 2026-03-07 11:46:10
Duration: 987ms
Database: zemm_produktiv_7
User: labanimal
Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv

CREATE INDEX CONCURRENTLY IF NOT EXISTS login_tracker_loginname_timestamp_idx ON public.login_tracker (loginname, "timestamp" DESC);

Date: 2026-03-07 11:46:08
Duration: 802ms
Database: zemm_produktiv_8
User: labanimal
Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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

x Hide

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