ZEMM PG Report-
Global information
- Generated on Sun Mar 15 06:01:11 2026
- Log file: /var/log/postgresql/postgresql-2026-03-06_225012.csv, ..., /var/log/postgresql/postgresql-2026-03-15_000000.csv
- Parsed 191,720 log entries in 1m10s
- Log start from 2026-03-07 00:00:01 to 2026-03-07 23:59:49
-
Overview
Global Stats
- 29 Number of unique normalized queries
- 17,320 Number of queries
- 15h58m43s Total query duration
- 2026-03-07 00:00:01 First query
- 2026-03-07 23:59:01 Last query
- 12 queries/s at 2026-03-07 00:45:01 Query peak
- 15h58m43s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 15h58m43s Execute total duration
- 438 Number of events
- 9 Number of unique normalized events
- 413 Max number of times the same event was reported
- 0 Number of cancellation
- 15 Total number of automatic vacuums
- 15 Total number of automatic analyzes
- 22 Number temporary file
- 5.11 MiB Max size of temporary file
- 2.79 MiB Average size of temporary file
- 16,840 Total number of sessions
- 19 sessions at 2026-03-07 12:07:03 Session peak
- 18h42m1s Total duration of sessions
- 3s997ms Average duration of sessions
- 1 Average queries per session
- 3s415ms Average queries duration per session
- 581ms Average idle time per session
- 17,249 Total number of connections
- 37 connections/s at 2026-03-07 14:00:01 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 12 queries/s Query Peak
- 2026-03-07 00:45:01 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-03-07 14:01:19 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 12 queries/s Query Peak
- 2026-03-07 00:45:01 Date
Queries duration
Key values
- 15h58m43s 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 07 00 720 0ms 0ms 0ms 0ms 0ms 0ms 01 720 0ms 0ms 0ms 0ms 0ms 0ms 02 720 0ms 0ms 0ms 0ms 0ms 0ms 03 720 0ms 0ms 0ms 0ms 0ms 0ms 04 720 0ms 0ms 0ms 0ms 0ms 0ms 05 720 0ms 0ms 0ms 0ms 0ms 0ms 06 720 0ms 0ms 0ms 0ms 0ms 0ms 07 720 0ms 0ms 0ms 0ms 0ms 0ms 08 720 0ms 0ms 0ms 0ms 0ms 0ms 09 722 0ms 793ms 321ms 8s533ms 8s533ms 8s533ms 10 722 711ms 867ms 743ms 10s408ms 10s408ms 11s216ms 11 737 548ms 1s28ms 841ms 11s700ms 11s700ms 21s884ms 12 720 975ms 975ms 975ms 11s700ms 11s700ms 11s700ms 13 721 808ms 975ms 966ms 11s700ms 11s700ms 12s509ms 14 724 736ms 808ms 799ms 9s624ms 9s704ms 11s182ms 15 726 538ms 1s973ms 906ms 15s903ms 15s903ms 16s708ms 16 722 805ms 2m57s 1m6s 35m34s 35m34s 35m36s 17 720 2s174ms 2s174ms 2s174ms 26s95ms 26s95ms 26s95ms 18 721 793ms 2s174ms 1s896ms 26s95ms 26s95ms 26s889ms 19 720 793ms 793ms 793ms 9s522ms 9s522ms 9s522ms 20 720 793ms 793ms 793ms 9s522ms 9s522ms 9s522ms 21 720 793ms 793ms 793ms 9s522ms 9s522ms 9s522ms 22 720 793ms 793ms 793ms 9s522ms 9s522ms 9s522ms 23 725 538ms 1s966ms 832ms 9s522ms 15s907ms 15s907ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 07 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 2 0 752ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 2 0 739ms 0ms 0ms 0ms 15 0 5 1s270ms 0ms 0ms 0ms 16 1 0 2m57s 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 5 1s268ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 07 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Mar 07 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Mar 07 00 407 0.11/s 01 184 0.05/s 02 186 0.05/s 03 187 0.05/s 04 181 0.05/s 05 185 0.05/s 06 181 0.05/s 07 205 0.06/s 08 199 0.06/s 09 536 0.15/s 10 1,567 0.44/s 11 1,515 0.42/s 12 1,028 0.29/s 13 1,396 0.39/s 14 1,868 0.52/s 15 1,752 0.49/s 16 1,286 0.36/s 17 1,246 0.35/s 18 1,334 0.37/s 19 793 0.22/s 20 281 0.08/s 21 245 0.07/s 22 242 0.07/s 23 245 0.07/s Day Hour Count Average Duration Average idle time Mar 07 00 383 113ms 113ms 01 184 55ms 55ms 02 188 2m52s 2m52s 03 183 55ms 55ms 04 181 53ms 53ms 05 183 53ms 53ms 06 181 54ms 54ms 07 205 72ms 72ms 08 199 59ms 59ms 09 482 96ms 0ms 10 1,417 156ms 0ms 11 1,437 119ms 0ms 12 1,004 74ms 0ms 13 1,368 23s747ms 23s238ms 14 1,840 98ms 0ms 15 1,733 147ms 0ms 16 1,286 542ms 0ms 17 1,246 145ms 0ms 18 1,334 152ms 0ms 19 793 178ms 0ms 20 281 47ms 0ms 21 245 45ms 0ms 22 242 46ms 0ms 23 245 104ms 0ms -
Connections
Established Connections
Key values
- 37 connections Connection Peak
- 2026-03-07 14:00:01 Date
Connections per database
Key values
- zemm_monitoring Main Database
- 17,249 connections Total
Connections per user
Key values
- labanimal Main User
- 17,249 connections Total
-
Sessions
Simultaneous sessions
Key values
- 19 sessions Session Peak
- 2026-03-07 12:07:03 Date
Histogram of session times
Key values
- 15,795 0-500ms duration
Sessions per database
Key values
- zemm_monitoring Main Database
- 16,840 sessions Total
Sessions per user
Key values
- labanimal Main User
- 16,840 sessions Total
Sessions per host
Key values
- ::1 Main Host
- 16,840 sessions Total
Sessions per application
Key values
- Main Application
- 16,840 sessions Total
Application Count Total Duration Average Duration 15,646 28m43s 110ms DBeaver 25.3.4 - Main 'zemm_produktiv_7' 2 4h30m3s 2h15m1s DBeaver 25.3.4 - Main 'zemm_produktiv_8' 2 4h30m2s 2h15m1s DBeaver 25.3.4 - SQLEditor 'Script-230.sql' 2 4h30m2s 2h15m1s DBeaver 25.3.4 - SQLEditor 'Script-231.sql' 2 4h30m1s 2h15m _backend_cage_autocomplete_api.php_q_2025_limit_12_zemm_produkt 10 271ms 27ms _backend_cage_autocomplete_api.php_q_55-065_limit_12_zemm_produ 10 325ms 32ms _backend_wean_api.php_litter_id_10130227_zemm_produktiv_7_local 50 7s68ms 141ms _backend_wean_api.php_litter_id_10130236_zemm_produktiv_7_local 50 7s301ms 146ms _backend_wean_api.php_litter_id_10130257_zemm_produktiv_7_local 60 8s769ms 146ms _backend_wean_api.php_litter_id_10131529_zemm_produktiv_8_local 3 404ms 134ms _backend_wean_api.php_litter_id_10131577_zemm_produktiv_8_local 3 402ms 134ms _backend_wean_api.php_litter_id_10131582_zemm_produktiv_8_local 3 403ms 134ms _backend_wean_api.php_litter_id_10131586_zemm_produktiv_8_local 3 400ms 133ms _backend_wean_api.php_litter_id_10131592_zemm_produktiv_8_local 3 400ms 133ms _backend_wean_api.php_litter_id_10131594_zemm_produktiv_8_local 3 396ms 132ms _desktop__zemm_produktiv_7_localhost_5432 10 4s602ms 460ms _desktop__zemm_produktiv_8_localhost_5432 7 1s802ms 257ms _desktop_index.php_command_animals_breedings_subcommand_select_ 20 10s958ms 547ms _desktop_index.php_command_animals_create_subcommand_init_zemm_ 10 668ms 66ms _desktop_index.php_command_animals_edit_subcommand_init_id_1019 1 102ms 102ms _desktop_index.php_command_animals_edit_subcommand_init_id_1028 9 890ms 98ms _desktop_index.php_command_animals_edit_subcommand_init_id_1029 1 139ms 139ms _desktop_index.php_command_animals_edit_subcommand_link_init_va 30 3s167ms 105ms _desktop_index.php_command_animals_edit_subcommand_m_init_scree 30 3s311ms 110ms _desktop_index.php_command_animals_litters_edit_subcommand_init 10 1s119ms 111ms _desktop_index.php_command_animals_litters_edit_subcommand_m_in 50 11s801ms 236ms _desktop_index.php_command_animals_litters_subcommand_open_zemm 2 208ms 104ms _desktop_index.php_command_animals_litters_subcommand_select_ze 20 2s7ms 100ms _desktop_index.php_command_animals_subcommand_animals_per_user_ 3 1s595ms 531ms _desktop_index.php_command_animals_subcommand_init_zemm_produkt 7 1s936ms 276ms _desktop_index.php_command_animals_subcommand_open_zemm_produkt 15 2s733ms 182ms _desktop_index.php_command_animals_subcommand_select_zemm_produ 34 10s926ms 321ms _desktop_index.php_command_cages_subcommand_open_zemm_produktiv 17 2s787ms 163ms _desktop_index.php_command_documents_subcommand_init_zemm_produ 1 84ms 84ms _desktop_index.php_command_facility_subcommand_init_zemm_produk 20 5s774ms 288ms _desktop_index.php_command_home_subcommand_init_zemm_produktiv_ 4 456ms 114ms _desktop_index.php_command_login_subcommand_init_zemm_produktiv 334 56s818ms 170ms _desktop_index.php_command_reports_subcommand_animals_per_room_ 4 566ms 141ms _desktop_index.php_command_reports_subcommand_animals_per_user_ 7 2s208ms 315ms _desktop_index.php_command_reports_subcommand_annual_reports_ze 4 338ms 84ms _desktop_index.php_command_reports_subcommand_annual_year_2024_ 1 86ms 86ms _desktop_index.php_command_reports_subcommand_authority_meldung 14 4s256ms 304ms _desktop_index.php_command_reports_subcommand_fates_zemm_produk 15 1s773ms 118ms _desktop_index.php_command_reports_subcommand_init_zemm_produkt 21 6s239ms 297ms _desktop_index.php_command_reports_subcommand_room_utilisation_ 2 296ms 148ms _desktop_index.php_command_reports_subcommand_task_status_zemm_ 18 2s729ms 151ms _desktop_index.php_command_tasks_subcommand_edit_id_10126484_ze 10 901ms 90ms _desktop_index.php_command_tasks_subcommand_init_search_zemm_pr 20 1s534ms 76ms _desktop_index.php_command_tasks_subcommand_init_zemm_produktiv 25 2s808ms 112ms _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv 72 12s31ms 167ms _desktop_index.php_command_tasks_subcommand_search_zemm_produkt 30 2s469ms 82ms _desktop_index.php_zemm_produktiv_7_localhost_5432 2 979ms 489ms _desktop_index.php_zemm_produktiv_8_localhost_5432 42 10s405ms 247ms backend:zemm_produktiv_8@localhost 6 42s651ms 7s108ms expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 1 53ms 53ms fates3112:zemm_produktiv_8@h2940066.stratoserver.net:5432 1 2s211ms 2s211ms fatescron:zemm_produktiv_7@zemm.fbiscience.eu 1 1s190ms 1s190ms fatescron:zemm_produktiv_8@h2940066.stratoserver.net:5432 2 2s147ms 1s73ms notification:zemm_produktiv_8@h2940066.stratoserver.net:5432 4 5m34s 1m23s pg_dump 2 24s443ms 12s221ms psql 14 255ms 18ms strainscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 1 2m58s 2m58s taskscron:zemm_produktiv_7@zemm.fbiscience.eu 24 596ms 24ms taskscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 10 1s271ms 127ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 20,642 buffers Checkpoint Peak
- 2026-03-07 15:03:52 Date
- 269.926 seconds Highest write time
- 0.023 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-03-07 05:04:24 Date
Checkpoints distance
Key values
- 175.27 Mo Distance Peak
- 2026-03-07 15:03:52 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Mar 07 00 2,414 242.128s 0.08s 242.267s 01 1,615 162.071s 0.073s 162.209s 02 1,539 154.454s 0.065s 154.576s 03 2,107 211.318s 0.063s 211.436s 04 1,482 148.7s 0.063s 148.817s 05 1,583 158.829s 0.064s 158.949s 06 1,527 153.237s 0.063s 153.35s 07 1,552 155.737s 0.068s 155.861s 08 1,755 176.051s 0.067s 176.175s 09 5,769 444.947s 0.078s 445.086s 10 5,524 538.437s 0.139s 538.641s 11 3,118 312.591s 0.125s 312.779s 12 2,372 237.911s 0.078s 238.043s 13 8,223 556.572s 0.081s 556.719s 14 2,507 251.418s 0.081s 251.559s 15 24,363 642.076s 0.09s 642.259s 16 2,563 257.06s 0.075s 257.185s 17 2,206 221.235s 0.07s 221.358s 18 2,329 233.565s 0.069s 233.689s 19 2,943 294.947s 0.068s 295.073s 20 1,731 173.635s 0.066s 173.75s 21 1,538 154.28s 0.062s 154.396s 22 1,654 165.936s 0.061s 166.047s 23 1,535 154.028s 0.065s 154.15s Day Hour Added Removed Recycled Synced files Longest sync Average sync Mar 07 00 0 1 0 380 0.002s 0.012s 01 0 1 0 342 0.002s 0.012s 02 0 0 0 287 0.002s 0.012s 03 0 1 0 283 0.001s 0.012s 04 0 0 0 288 0.002s 0.012s 05 0 1 0 292 0.001s 0.012s 06 0 0 0 297 0.001s 0.012s 07 0 1 0 315 0.002s 0.012s 08 0 1 0 298 0.002s 0.012s 09 0 1 0 367 0.002s 0.012s 10 0 2 0 745 0.003s 0.012s 11 0 2 0 671 0.004s 0.012s 12 0 1 0 370 0.002s 0.012s 13 0 2 0 384 0.003s 0.012s 14 0 1 0 399 0.002s 0.011s 15 0 6 0 428 0.002s 0.013s 16 0 1 0 364 0.002s 0.012s 17 0 1 0 345 0.002s 0.012s 18 0 1 0 317 0.002s 0.012s 19 0 1 0 314 0.002s 0.012s 20 0 0 0 311 0.001s 0.012s 21 0 1 0 272 0.002s 0.012s 22 0 0 0 266 0.002s 0.012s 23 0 1 0 293 0.002s 0.012s Day Hour Count Avg time (sec) Mar 07 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Mar 07 00 1,035.58 kB 537,365.83 kB 01 805.00 kB 152,366.25 kB 02 782.92 kB 43,602.17 kB 03 928.92 kB 12,964.92 kB 04 768.92 kB 4,232.75 kB 05 801.17 kB 1,754.33 kB 06 782.08 kB 1,071.33 kB 07 782.83 kB 865.08 kB 08 856.83 kB 1,013.58 kB 09 2,071.25 kB 6,397.75 kB 10 1,904.67 kB 5,935.50 kB 11 3,295.92 kB 7,805.75 kB 12 1,146.00 kB 11,510.50 kB 13 2,816.75 kB 7,578.42 kB 14 1,241.45 kB 9,187.73 kB 15 8,185.69 kB 52,073.62 kB 16 1,127.75 kB 14,693.42 kB 17 1,039.75 kB 4,932.33 kB 18 1,051.00 kB 2,113.08 kB 19 1,266.25 kB 2,817.92 kB 20 874.00 kB 2,202.00 kB 21 831.83 kB 1,236.75 kB 22 856.42 kB 995.92 kB 23 826.00 kB 927.08 kB -
Temporary Files
Size of temporary files
Key values
- 16.17 MiB Temp Files size Peak
- 2026-03-07 11:46:09 Date
Number of temporary files
Key values
- 7 per second Temp Files Peak
- 2026-03-07 11:46:08 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Mar 07 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 22 61.38 MiB 2.79 MiB 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 32.34 MiB 3.18 MiB 5.11 MiB 4.04 MiB create index concurrently if not exists animals_animalid_idx on public.animals ("animalID");-
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
2 8 23.09 MiB 2.73 MiB 3.19 MiB 2.89 MiB create index concurrently if not exists animals_curcage_active_idx on public.animals ("curCage") where not deleted;-
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
3 6 5.95 MiB 816.00 KiB 1.22 MiB 1016.00 KiB create index concurrently if not exists login_tracker_loginname_timestamp_idx on public.login_tracker (loginname, "timestamp" desc);-
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
Queries generating the largest temporary files
Rank Size Query 1 5.11 MiB CREATE INDEX CONCURRENTLY IF NOT EXISTS animals_animalid_idx ON public.animals ("animalID");[ Date: 2026-03-07 11:46:12 - Database: zemm_produktiv_7 - User: labanimal ]
2 4.83 MiB CREATE INDEX CONCURRENTLY IF NOT EXISTS animals_animalid_idx ON public.animals ("animalID");[ Date: 2026-03-07 11:46:09 - Database: zemm_produktiv_8 - User: labanimal ]
3 4.02 MiB CREATE INDEX CONCURRENTLY IF NOT EXISTS animals_animalid_idx ON public.animals ("animalID");[ Date: 2026-03-07 11:46:12 - Database: zemm_produktiv_7 - User: labanimal ]
4 3.86 MiB CREATE INDEX CONCURRENTLY IF NOT EXISTS animals_animalid_idx ON public.animals ("animalID");[ Date: 2026-03-07 11:46:12 - Database: zemm_produktiv_7 - User: labanimal ]
5 3.82 MiB CREATE INDEX CONCURRENTLY IF NOT EXISTS animals_animalid_idx ON public.animals ("animalID");[ Date: 2026-03-07 11:46:09 - Database: zemm_produktiv_8 - User: labanimal ]
6 3.79 MiB CREATE INDEX CONCURRENTLY IF NOT EXISTS animals_animalid_idx ON public.animals ("animalID");[ Date: 2026-03-07 11:46:09 - Database: zemm_produktiv_8 - User: labanimal ]
7 3.73 MiB CREATE INDEX CONCURRENTLY IF NOT EXISTS animals_animalid_idx ON public.animals ("animalID");[ Date: 2026-03-07 11:46:09 - Database: zemm_produktiv_8 - User: labanimal ]
8 3.19 MiB CREATE INDEX CONCURRENTLY IF NOT EXISTS animals_curcage_active_idx ON public.animals ("curCage") WHERE NOT deleted;[ Date: 2026-03-07 11:46:11 - Database: zemm_produktiv_7 - User: labanimal ]
9 3.18 MiB CREATE INDEX CONCURRENTLY IF NOT EXISTS animals_animalid_idx ON public.animals ("animalID");[ Date: 2026-03-07 11:46:12 - Database: zemm_produktiv_7 - User: labanimal ]
10 3.16 MiB CREATE INDEX CONCURRENTLY IF NOT EXISTS animals_curcage_active_idx ON public.animals ("curCage") WHERE NOT deleted;[ Date: 2026-03-07 11:46:08 - Database: zemm_produktiv_8 - User: labanimal ]
11 2.84 MiB CREATE INDEX CONCURRENTLY IF NOT EXISTS animals_curcage_active_idx ON public.animals ("curCage") WHERE NOT deleted;[ Date: 2026-03-07 11:46:08 - Database: zemm_produktiv_8 - User: labanimal ]
12 2.82 MiB CREATE INDEX CONCURRENTLY IF NOT EXISTS animals_curcage_active_idx ON public.animals ("curCage") WHERE NOT deleted;[ Date: 2026-03-07 11:46:11 - Database: zemm_produktiv_7 - User: labanimal ]
13 2.80 MiB CREATE INDEX CONCURRENTLY IF NOT EXISTS animals_curcage_active_idx ON public.animals ("curCage") WHERE NOT deleted;[ Date: 2026-03-07 11:46:11 - Database: zemm_produktiv_7 - User: labanimal ]
14 2.79 MiB CREATE INDEX CONCURRENTLY IF NOT EXISTS animals_curcage_active_idx ON public.animals ("curCage") WHERE NOT deleted;[ Date: 2026-03-07 11:46:08 - Database: zemm_produktiv_8 - User: labanimal ]
15 2.75 MiB CREATE INDEX CONCURRENTLY IF NOT EXISTS animals_curcage_active_idx ON public.animals ("curCage") WHERE NOT deleted;[ Date: 2026-03-07 11:46:08 - Database: zemm_produktiv_8 - User: labanimal ]
16 2.73 MiB CREATE INDEX CONCURRENTLY IF NOT EXISTS animals_curcage_active_idx ON public.animals ("curCage") WHERE NOT deleted;[ Date: 2026-03-07 11:46:11 - Database: zemm_produktiv_7 - User: labanimal ]
17 1.22 MiB 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 - Database: zemm_produktiv_8 - User: labanimal ]
18 1.16 MiB 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 - Database: zemm_produktiv_7 - User: labanimal ]
19 984.00 KiB 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 - Database: zemm_produktiv_8 - User: labanimal ]
20 928.00 KiB 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 - Database: zemm_produktiv_7 - User: labanimal ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 7.62 sec Highest CPU-cost vacuum
Table observability.db_top_queries
Database zemm_monitoring - 2026-03-07 14:57:26 Date
- 0 sec Highest CPU-cost analyze
Table
Database zemm_monitoring - Date
Average Autovacuum Duration
Key values
- 7.62 sec Highest CPU-cost vacuum
Table observability.db_top_queries
Database zemm_monitoring - 2026-03-07 14:57:26 Date
Analyzes per table
Key values
- pg_catalog.pg_type (3) Main table analyzed (database zemm_produktiv_8)
- 15 analyzes Total
Table Number of analyzes zemm_produktiv_8.pg_catalog.pg_type 3 zemm_monitoring.observability.metrics_timeseries 2 zemm_produktiv_8.pg_catalog.pg_attribute 2 zemm_monitoring.observability.nginx_counters 1 zemm_test_2.pg_catalog.pg_shdepend 1 zemm_produktiv_7.pg_catalog.pg_attribute 1 zemm_produktiv_7.pg_catalog.pg_type 1 zemm_monitoring.observability.db_top_queries 1 zemm_monitoring.observability.phpfpm_counters 1 zemm_produktiv_8.pg_catalog.pg_depend 1 zemm_produktiv_8.pg_catalog.pg_class 1 Total 15 Vacuums per table
Key values
- pg_toast.pg_toast_67431 (11) Main table vacuumed on database zemm_monitoring
- 15 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples zemm_monitoring.pg_toast.pg_toast_67431 11 0 0 0 0 0 0 3,733 1,268 4,204,057 1,220 7,314 zemm_monitoring.observability.db_top_queries 1 0 0 0 0 0 0 31,245 26,934 89,984,371 2,132 22,246 zemm_monitoring.observability.app_events 1 0 0 0 0 0 0 308 305 403,537 0 0 zemm_monitoring.observability.phpfpm_counters 1 0 0 0 0 0 0 248 248 238,511 0 0 zemm_monitoring.observability.nginx_counters 1 0 0 0 0 0 0 119 119 193,298 0 0 Total 15 0 0 0 0 0 0 35,653 28,874 95,023,774 3,352 29,560 Vacuum throughput per table
Key values
- observability.db_top_queries (7.62) Max CPU elapsed for vacuum on database zemm_monitoring
- observability.db_top_queries (20.124 ms) Max I/O read time for vacuum on database zemm_monitoring
- observability.db_top_queries (42.487 ms) Max I/O write time for vacuum on database zemm_monitoring
I/O timing (ms) CPU (s) Table read write elapsed zemm_monitoring.pg_toast.pg_toast_67431 1.575 0 0.22 zemm_monitoring.observability.db_top_queries 20.124 42.487 7.62 zemm_monitoring.observability.app_events 1.887 0 0.07 zemm_monitoring.observability.phpfpm_counters 0.502 0 0.06 zemm_monitoring.observability.nginx_counters 0.524 0 0.02 Total 24.612 42.487 7.99 Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain zemm_monitoring.observability.db_top_queries 1 0 0 1,757,458 0 0 184,333 zemm_monitoring.observability.app_events 1 0 0 46,631 0 0 1,728 zemm_monitoring.observability.phpfpm_counters 1 0 0 18,709 0 0 1,142 zemm_monitoring.observability.nginx_counters 1 0 0 18,707 0 0 530 zemm_monitoring.pg_toast.pg_toast_67431 11 0 0 581,394 0 0 97,238 Total 15 0 0 2,422,899 0 0 284,971 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Pages removed per tables
NO DATASET
Table Number of vacuums Index scans Tuples removed Pages removed zemm_monitoring.observability.db_top_queries 1 0 0 0 zemm_monitoring.observability.app_events 1 0 0 0 zemm_monitoring.observability.phpfpm_counters 1 0 0 0 zemm_monitoring.observability.nginx_counters 1 0 0 0 zemm_monitoring.pg_toast.pg_toast_67431 11 0 0 0 Total 15 0 0 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Mar 07 00 1 0 01 0 0 02 1 0 03 0 0 04 0 0 05 1 0 06 0 1 07 0 0 08 1 0 09 0 0 10 0 5 11 1 1 12 0 0 13 1 1 14 4 1 15 0 0 16 1 1 17 0 1 18 2 0 19 0 1 20 1 1 21 0 0 22 1 0 23 0 2 - 7.62 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 5 Total read queries
- 17,309 Total write queries
Queries by database
Key values
- zemm_monitoring Main database
- 17,280 Requests
- 15h55m7s (zemm_monitoring)
- Main time consuming database
Queries by user
Key values
- labanimal Main user
- 18,138 Requests
User Request type Count Duration labanimal Total 18,138 16h22m43s cte 11 10s258ms ddl 18,116 16h19m26s others 4 3s68ms select 5 3m postgres Total 3,525 1h1m44s copy from 19 54s373ms copy to 65 2m30s cte 5 10s291ms ddl 2,728 45m51s others 679 11m32s Duration by user
Key values
- 16h22m43s (labanimal) Main time consuming user
User Request type Count Duration labanimal Total 18,138 16h22m43s cte 11 10s258ms ddl 18,116 16h19m26s others 4 3s68ms select 5 3m postgres Total 3,525 1h1m44s copy from 19 54s373ms copy to 65 2m30s cte 5 10s291ms ddl 2,728 45m51s others 679 11m32s Queries by host
Key values
- unknown Main host
- 18,137 Requests
- 16h19m45s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 17,294 Requests
- 15h55m19s (unknown)
- Main time consuming application
Application Request type Count Duration _desktop_index.php_command_animals_breedings_subcommand_select_ Total 10 8s83ms cte 10 8s83ms _desktop_index.php_command_facility_subcommand_init_zemm_produk Total 2 1s504ms select 2 1s504ms _desktop_index.php_command_login_subcommand_init_zemm_produktiv Total 1 2s174ms cte 1 2s174ms _desktop_index.php_zemm_produktiv_8_localhost_5432 Total 2 1s478ms select 2 1s478ms pg_dump Total 10 12s696ms copy to 10 12s696ms strainscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 Total 1 2m57s select 1 2m57s unknown Total 17,294 15h55m19s ddl 17,288 15h55m14s others 4 3s68ms Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-03-07 13:26:10 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 21 500-1000ms duration
Slowest individual queries
Rank Duration Query 1 2m57s SELECT str.name AS Linie, str.comments AS Eigentuemer, ( SELECT COUNT(a.animal_id) FROM animals_search_mview a WHERE a.alive = 't' AND a.deleted = 'f' AND a.strain = str.name AND a.outgoing_date IS NULL AND a.death_date IS NULL) AS tiere_lebend, ( SELECT MAX(a.death_date) FROM animals_search_mview a WHERE a.deleted = 'f' AND a.strain = str.name) AS zuletzt_gestorbenes_tier, ( SELECT MAX(a.outgoing_date) FROM animals_search_mview a WHERE a.alive = 't' AND a.deleted = 'f' AND a.strain = str.name) AS zuletzt_lebend_verlassenes_Tier FROM strains str WHERE str.deleted = '0' AND str.active = '1' GROUP BY str.name, str.comments;[ Date: 2026-03-07 16:27:35 - Database: zemm_produktiv_8 - User: labanimal - Remote: 81.169.238.237 - Application: strainscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 ]
2 2m57s CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-03-07 16:28:01 - Database: zemm_monitoring - User: labanimal ]
3 2m57s 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-07 16:28:01 - Database: zemm_monitoring - User: labanimal ]
4 2m57s CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-03-07 16:28:01 - Database: zemm_monitoring - User: labanimal ]
5 2m57s CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-03-07 16:28:01 - Database: zemm_monitoring - User: labanimal ]
6 2m57s 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-07 16:28:01 - Database: zemm_monitoring - User: labanimal ]
7 2m57s CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);[ Date: 2026-03-07 16:28:01 - Database: zemm_monitoring - User: labanimal ]
8 2m57s CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);[ Date: 2026-03-07 16:28:01 - Database: zemm_monitoring - User: labanimal ]
9 2m57s 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-07 16:28:01 - Database: zemm_monitoring - User: labanimal ]
10 2m57s CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);[ Date: 2026-03-07 16:28:01 - Database: zemm_monitoring - User: labanimal ]
11 2m57s 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-07 16:28:01 - Database: zemm_monitoring - User: labanimal ]
12 2m57s 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-07 16:28:01 - Database: zemm_monitoring - User: labanimal ]
13 2m57s 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-07 16:28:01 - Database: zemm_monitoring - User: labanimal ]
14 2m57s CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-03-07 16:29:01 - Database: zemm_monitoring - User: labanimal ]
15 2m57s 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-07 16:29:01 - Database: zemm_monitoring - User: labanimal ]
16 2m57s CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-03-07 16:29:01 - Database: zemm_monitoring - User: labanimal ]
17 2m57s CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-03-07 16:29:01 - Database: zemm_monitoring - User: labanimal ]
18 2m57s 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-07 16:29:01 - Database: zemm_monitoring - User: labanimal ]
19 2m57s CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);[ Date: 2026-03-07 16:29:01 - Database: zemm_monitoring - User: labanimal ]
20 2m57s CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);[ Date: 2026-03-07 16:29:01 - Database: zemm_monitoring - User: labanimal ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h19m35s 1,440 711ms 2m57s 3s316ms 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 #1
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
2 1h19m35s 1,440 711ms 2m57s 3s316ms 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 #2
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
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-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
3 1h19m35s 1,440 711ms 2m57s 3s316ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
4 1h19m35s 1,440 711ms 2m57s 3s316ms 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 #4
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
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-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
5 1h19m35s 1,440 711ms 2m57s 3s316ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
6 1h19m35s 1,440 711ms 2m57s 3s316ms 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 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
7 1h19m35s 1,440 711ms 2m57s 3s316ms 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 #7
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
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-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
8 1h19m35s 1,440 711ms 2m57s 3s316ms 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 #8
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
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-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
9 1h19m35s 1,440 711ms 2m57s 3s316ms 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 #9
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
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-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
10 1h19m35s 1,440 711ms 2m57s 3s316ms create schema if not exists observability;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
11 1h19m35s 1,440 711ms 2m57s 3s316ms 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 #11
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
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-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
12 1h19m35s 1,440 711ms 2m57s 3s316ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
13 2m57s 1 2m57s 2m57s 2m57s select str.name as linie, str.comments as eigentuemer, ( select count(a.animal_id) from animals_search_mview a where a.alive = ? and a.deleted = ? and a.strain = str.name and a.outgoing_date is null and a.death_date is null) as tiere_lebend, ( select max(a.death_date) from animals_search_mview a where a.deleted = ? and a.strain = str.name) as zuletzt_gestorbenes_tier, ( select max(a.outgoing_date) from animals_search_mview a where a.alive = ? and a.deleted = ? and a.strain = str.name) as zuletzt_lebend_verlassenes_tier from strains str where str.deleted = ? and str.active = ? group by str.name, str.comments;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 07 16 1 2m57s 2m57s [ User: labanimal - Total duration: 2m57s - Times executed: 1 ]
[ Application: strainscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 - Total duration: 2m57s - Times executed: 1 ]
-
SELECT str.name AS Linie, str.comments AS Eigentuemer, ( SELECT COUNT(a.animal_id) FROM animals_search_mview a WHERE a.alive = 't' AND a.deleted = 'f' AND a.strain = str.name AND a.outgoing_date IS NULL AND a.death_date IS NULL) AS tiere_lebend, ( SELECT MAX(a.death_date) FROM animals_search_mview a WHERE a.deleted = 'f' AND a.strain = str.name) AS zuletzt_gestorbenes_tier, ( SELECT MAX(a.outgoing_date) FROM animals_search_mview a WHERE a.alive = 't' AND a.deleted = 'f' AND a.strain = str.name) AS zuletzt_lebend_verlassenes_Tier FROM strains str WHERE str.deleted = '0' AND str.active = '1' GROUP BY str.name, str.comments;
Date: 2026-03-07 16:27:35 Duration: 2m57s Database: zemm_produktiv_8 User: labanimal Remote: 81.169.238.237 Application: strainscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
14 10s258ms 11 790ms 2s174ms 932ms with damdam as ( select breedingid, string_agg(cast(dam as text), ?) as dam from breedingsdams inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as dam on dam.id = breedingsdams.dam and case when user_is_tgm (dam.owner, ?) then true when user_is_tgm (dam.editor, ?) then true when user_is_tgm (dam.tourist, ?) then true else false end group by breedingid ), siresire as ( select breedingid, string_agg(cast(sire as text), ?) as sire from breedingssires inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as sire on sire.id = breedingssires.sire and case when user_is_tgm (sire.owner, ?) then true when user_is_tgm (sire.editor, ?) then true when user_is_tgm (sire.tourist, ?) then true else false end group by breedingid ), cagess as ( select id, "cageName" from cages) ( select breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire from damdam, siresire, cagess, breedings where breedings.deleted != true and cagess.id = breedings.cage and damdam.breedingid = breedings.id and siresire.breedingid = breedings.id and breedings."unbreeding_date" is null group by breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire order by breeding_date, plug_date);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 07 10 2 1s675ms 837ms 11 3 2s400ms 800ms 13 1 808ms 808ms 14 2 1s600ms 800ms 15 1 805ms 805ms 16 1 2s174ms 2s174ms 18 1 793ms 793ms [ User: labanimal - Total duration: 10s258ms - Times executed: 11 ]
[ Application: _desktop_index.php_command_animals_breedings_subcommand_select_ - Total duration: 8s83ms - Times executed: 10 ]
[ Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv - Total duration: 2s174ms - Times executed: 1 ]
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 490) THEN TRUE WHEN user_is_tgm (dam.editor, 490) THEN TRUE WHEN user_is_tgm (dam.tourist, 490) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 490) THEN TRUE WHEN user_is_tgm (sire.editor, 490) THEN TRUE WHEN user_is_tgm (sire.tourist, 490) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-07 16:49:18 Duration: 2s174ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-07 10:46:47 Duration: 867ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_command_animals_breedings_subcommand_select_ Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-07 13:56:11 Duration: 808ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_command_animals_breedings_subcommand_select_ Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
15 3s940ms 2 1s966ms 1s973ms 1s970ms 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 #15
Day Hour Count Duration Avg duration Mar 07 15 1 1s973ms 1s973ms 23 1 1s966ms 1s966ms [ User: postgres - Total duration: 3s940ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 3s940ms - Times executed: 2 ]
-
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-07 15:45:57 Duration: 1s973ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:55:08 Duration: 1s966ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
16 2s650ms 2 1s325ms 1s325ms 1s325ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 07 15 1 1s325ms 1s325ms 23 1 1s325ms 1s325ms [ User: postgres - Total duration: 2s650ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2s650ms - Times executed: 2 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-07 23:55:10 Duration: 1s325ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-07 15:45:59 Duration: 1s325ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
17 2s585ms 2 1s288ms 1s297ms 1s292ms 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 #17
Day Hour Count Duration Avg duration Mar 07 15 1 1s297ms 1s297ms 23 1 1s288ms 1s288ms [ User: postgres - Total duration: 2s585ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2s585ms - Times executed: 2 ]
-
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-07 15:45:54 Duration: 1s297ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:55:05 Duration: 1s288ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
18 2s442ms 2 1s219ms 1s222ms 1s221ms 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 #18
Day Hour Count Duration Avg duration Mar 07 15 1 1s219ms 1s219ms 23 1 1s222ms 1s222ms [ User: postgres - Total duration: 2s442ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2s442ms - Times executed: 2 ]
-
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-07 23:55:03 Duration: 1s222ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 15:45:53 Duration: 1s219ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
19 1s962ms 2 975ms 987ms 981ms analyze public.animals;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 07 11 2 1s962ms 981ms [ User: labanimal - Total duration: 1s962ms - Times executed: 2 ]
-
ANALYZE public.animals;
Date: 2026-03-07 11:46:10 Duration: 987ms Database: zemm_produktiv_8 User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
ANALYZE public.animals;
Date: 2026-03-07 11:46:13 Duration: 975ms Database: zemm_produktiv_7 User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
20 1s790ms 2 802ms 987ms 895ms create index concurrently if not exists scoresheet_diary_animals_id_idx on public.scoresheet_diary (animals_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 07 11 2 1s790ms 895ms [ User: labanimal - Total duration: 1s790ms - Times executed: 2 ]
-
CREATE INDEX CONCURRENTLY IF NOT EXISTS scoresheet_diary_animals_id_idx ON public.scoresheet_diary (animals_id);
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 scoresheet_diary_animals_id_idx ON public.scoresheet_diary (animals_id);
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
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,440 1h19m35s 711ms 2m57s 3s316ms 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 #1
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
2 1,440 1h19m35s 711ms 2m57s 3s316ms 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 #2
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
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-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
3 1,440 1h19m35s 711ms 2m57s 3s316ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
4 1,440 1h19m35s 711ms 2m57s 3s316ms 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 #4
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
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-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
5 1,440 1h19m35s 711ms 2m57s 3s316ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
6 1,440 1h19m35s 711ms 2m57s 3s316ms 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 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
7 1,440 1h19m35s 711ms 2m57s 3s316ms 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 #7
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
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-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
8 1,440 1h19m35s 711ms 2m57s 3s316ms 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 #8
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
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-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
9 1,440 1h19m35s 711ms 2m57s 3s316ms 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 #9
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
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-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
10 1,440 1h19m35s 711ms 2m57s 3s316ms create schema if not exists observability;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
11 1,440 1h19m35s 711ms 2m57s 3s316ms 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 #11
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
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-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
12 1,440 1h19m35s 711ms 2m57s 3s316ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
13 11 10s258ms 790ms 2s174ms 932ms with damdam as ( select breedingid, string_agg(cast(dam as text), ?) as dam from breedingsdams inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as dam on dam.id = breedingsdams.dam and case when user_is_tgm (dam.owner, ?) then true when user_is_tgm (dam.editor, ?) then true when user_is_tgm (dam.tourist, ?) then true else false end group by breedingid ), siresire as ( select breedingid, string_agg(cast(sire as text), ?) as sire from breedingssires inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as sire on sire.id = breedingssires.sire and case when user_is_tgm (sire.owner, ?) then true when user_is_tgm (sire.editor, ?) then true when user_is_tgm (sire.tourist, ?) then true else false end group by breedingid ), cagess as ( select id, "cageName" from cages) ( select breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire from damdam, siresire, cagess, breedings where breedings.deleted != true and cagess.id = breedings.cage and damdam.breedingid = breedings.id and siresire.breedingid = breedings.id and breedings."unbreeding_date" is null group by breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire order by breeding_date, plug_date);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 07 10 2 1s675ms 837ms 11 3 2s400ms 800ms 13 1 808ms 808ms 14 2 1s600ms 800ms 15 1 805ms 805ms 16 1 2s174ms 2s174ms 18 1 793ms 793ms [ User: labanimal - Total duration: 10s258ms - Times executed: 11 ]
[ Application: _desktop_index.php_command_animals_breedings_subcommand_select_ - Total duration: 8s83ms - Times executed: 10 ]
[ Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv - Total duration: 2s174ms - Times executed: 1 ]
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 490) THEN TRUE WHEN user_is_tgm (dam.editor, 490) THEN TRUE WHEN user_is_tgm (dam.tourist, 490) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 490) THEN TRUE WHEN user_is_tgm (sire.editor, 490) THEN TRUE WHEN user_is_tgm (sire.tourist, 490) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-07 16:49:18 Duration: 2s174ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-07 10:46:47 Duration: 867ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_command_animals_breedings_subcommand_select_ Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-07 13:56:11 Duration: 808ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_command_animals_breedings_subcommand_select_ Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
14 2 3s940ms 1s966ms 1s973ms 1s970ms 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 #14
Day Hour Count Duration Avg duration Mar 07 15 1 1s973ms 1s973ms 23 1 1s966ms 1s966ms [ User: postgres - Total duration: 3s940ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 3s940ms - Times executed: 2 ]
-
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-07 15:45:57 Duration: 1s973ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:55:08 Duration: 1s966ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
15 2 2s650ms 1s325ms 1s325ms 1s325ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 07 15 1 1s325ms 1s325ms 23 1 1s325ms 1s325ms [ User: postgres - Total duration: 2s650ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2s650ms - Times executed: 2 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-07 23:55:10 Duration: 1s325ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-07 15:45:59 Duration: 1s325ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
16 2 2s585ms 1s288ms 1s297ms 1s292ms 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 #16
Day Hour Count Duration Avg duration Mar 07 15 1 1s297ms 1s297ms 23 1 1s288ms 1s288ms [ User: postgres - Total duration: 2s585ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2s585ms - Times executed: 2 ]
-
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-07 15:45:54 Duration: 1s297ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:55:05 Duration: 1s288ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
17 2 2s442ms 1s219ms 1s222ms 1s221ms 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 07 15 1 1s219ms 1s219ms 23 1 1s222ms 1s222ms [ User: postgres - Total duration: 2s442ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2s442ms - Times executed: 2 ]
-
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-07 23:55:03 Duration: 1s222ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 15:45:53 Duration: 1s219ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
18 2 1s962ms 975ms 987ms 981ms analyze public.animals;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 07 11 2 1s962ms 981ms [ User: labanimal - Total duration: 1s962ms - Times executed: 2 ]
-
ANALYZE public.animals;
Date: 2026-03-07 11:46:10 Duration: 987ms Database: zemm_produktiv_8 User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
ANALYZE public.animals;
Date: 2026-03-07 11:46:13 Duration: 975ms Database: zemm_produktiv_7 User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
19 2 1s790ms 802ms 987ms 895ms create index concurrently if not exists scoresheet_diary_animals_id_idx on public.scoresheet_diary (animals_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 07 11 2 1s790ms 895ms [ User: labanimal - Total duration: 1s790ms - Times executed: 2 ]
-
CREATE INDEX CONCURRENTLY IF NOT EXISTS scoresheet_diary_animals_id_idx ON public.scoresheet_diary (animals_id);
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 scoresheet_diary_animals_id_idx ON public.scoresheet_diary (animals_id);
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
20 2 1s790ms 802ms 987ms 895ms create index concurrently if not exists animals_animalid_idx on public.animals ("animalID");Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 07 11 2 1s790ms 895ms [ User: labanimal - Total duration: 1s790ms - Times executed: 2 ]
-
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
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m57s 2m57s 2m57s 1 2m57s select str.name as linie, str.comments as eigentuemer, ( select count(a.animal_id) from animals_search_mview a where a.alive = ? and a.deleted = ? and a.strain = str.name and a.outgoing_date is null and a.death_date is null) as tiere_lebend, ( select max(a.death_date) from animals_search_mview a where a.deleted = ? and a.strain = str.name) as zuletzt_gestorbenes_tier, ( select max(a.outgoing_date) from animals_search_mview a where a.alive = ? and a.deleted = ? and a.strain = str.name) as zuletzt_lebend_verlassenes_tier from strains str where str.deleted = ? and str.active = ? group by str.name, str.comments;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 07 16 1 2m57s 2m57s [ User: labanimal - Total duration: 2m57s - Times executed: 1 ]
[ Application: strainscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 - Total duration: 2m57s - Times executed: 1 ]
-
SELECT str.name AS Linie, str.comments AS Eigentuemer, ( SELECT COUNT(a.animal_id) FROM animals_search_mview a WHERE a.alive = 't' AND a.deleted = 'f' AND a.strain = str.name AND a.outgoing_date IS NULL AND a.death_date IS NULL) AS tiere_lebend, ( SELECT MAX(a.death_date) FROM animals_search_mview a WHERE a.deleted = 'f' AND a.strain = str.name) AS zuletzt_gestorbenes_tier, ( SELECT MAX(a.outgoing_date) FROM animals_search_mview a WHERE a.alive = 't' AND a.deleted = 'f' AND a.strain = str.name) AS zuletzt_lebend_verlassenes_Tier FROM strains str WHERE str.deleted = '0' AND str.active = '1' GROUP BY str.name, str.comments;
Date: 2026-03-07 16:27:35 Duration: 2m57s Database: zemm_produktiv_8 User: labanimal Remote: 81.169.238.237 Application: strainscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
2 711ms 2m57s 3s316ms 1,440 1h19m35s 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 #2
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
3 711ms 2m57s 3s316ms 1,440 1h19m35s 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 #3
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
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-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
4 711ms 2m57s 3s316ms 1,440 1h19m35s create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
5 711ms 2m57s 3s316ms 1,440 1h19m35s 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 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
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-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
6 711ms 2m57s 3s316ms 1,440 1h19m35s create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
7 711ms 2m57s 3s316ms 1,440 1h19m35s create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
8 711ms 2m57s 3s316ms 1,440 1h19m35s 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 #8
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
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-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
9 711ms 2m57s 3s316ms 1,440 1h19m35s 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 #9
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
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-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
10 711ms 2m57s 3s316ms 1,440 1h19m35s 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 #10
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
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-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
11 711ms 2m57s 3s316ms 1,440 1h19m35s create schema if not exists observability;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
12 711ms 2m57s 3s316ms 1,440 1h19m35s 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 #12
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
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-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
13 711ms 2m57s 3s316ms 1,440 1h19m35s create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 07 00 60 0ms 0ms 01 60 0ms 0ms 02 60 0ms 0ms 03 60 0ms 0ms 04 60 0ms 0ms 05 60 0ms 0ms 06 60 0ms 0ms 07 60 0ms 0ms 08 60 0ms 0ms 09 60 19s201ms 320ms 10 60 44s581ms 743ms 11 60 50s443ms 840ms 12 60 58s503ms 975ms 13 60 58s4ms 966ms 14 60 47s988ms 799ms 15 60 54s230ms 903ms 16 60 1h5m58s 1m5s 17 60 2m10s 2s174ms 18 60 1m53s 1s898ms 19 60 47s610ms 793ms 20 60 47s610ms 793ms 21 60 47s610ms 793ms 22 60 47s610ms 793ms 23 60 49s738ms 828ms [ User: labanimal - Total duration: 1h19m35s - Times executed: 867 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-07 16:49:01 Duration: 2m57s Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-07 18:47:01 Duration: 2s174ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-07 23:59:01 Duration: 1s325ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
14 1s966ms 1s973ms 1s970ms 2 3s940ms 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 #14
Day Hour Count Duration Avg duration Mar 07 15 1 1s973ms 1s973ms 23 1 1s966ms 1s966ms [ User: postgres - Total duration: 3s940ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 3s940ms - Times executed: 2 ]
-
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-07 15:45:57 Duration: 1s973ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:55:08 Duration: 1s966ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
15 1s325ms 1s325ms 1s325ms 2 2s650ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 07 15 1 1s325ms 1s325ms 23 1 1s325ms 1s325ms [ User: postgres - Total duration: 2s650ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2s650ms - Times executed: 2 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-07 23:55:10 Duration: 1s325ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-07 15:45:59 Duration: 1s325ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
16 1s288ms 1s297ms 1s292ms 2 2s585ms 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 #16
Day Hour Count Duration Avg duration Mar 07 15 1 1s297ms 1s297ms 23 1 1s288ms 1s288ms [ User: postgres - Total duration: 2s585ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2s585ms - Times executed: 2 ]
-
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-07 15:45:54 Duration: 1s297ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 23:55:05 Duration: 1s288ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
17 1s219ms 1s222ms 1s221ms 2 2s442ms 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 07 15 1 1s219ms 1s219ms 23 1 1s222ms 1s222ms [ User: postgres - Total duration: 2s442ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2s442ms - Times executed: 2 ]
-
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-07 23:55:03 Duration: 1s222ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 15:45:53 Duration: 1s219ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
18 975ms 987ms 981ms 2 1s962ms analyze public.animals;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 07 11 2 1s962ms 981ms [ User: labanimal - Total duration: 1s962ms - Times executed: 2 ]
-
ANALYZE public.animals;
Date: 2026-03-07 11:46:10 Duration: 987ms Database: zemm_produktiv_8 User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
ANALYZE public.animals;
Date: 2026-03-07 11:46:13 Duration: 975ms Database: zemm_produktiv_7 User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
19 790ms 2s174ms 932ms 11 10s258ms with damdam as ( select breedingid, string_agg(cast(dam as text), ?) as dam from breedingsdams inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as dam on dam.id = breedingsdams.dam and case when user_is_tgm (dam.owner, ?) then true when user_is_tgm (dam.editor, ?) then true when user_is_tgm (dam.tourist, ?) then true else false end group by breedingid ), siresire as ( select breedingid, string_agg(cast(sire as text), ?) as sire from breedingssires inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as sire on sire.id = breedingssires.sire and case when user_is_tgm (sire.owner, ?) then true when user_is_tgm (sire.editor, ?) then true when user_is_tgm (sire.tourist, ?) then true else false end group by breedingid ), cagess as ( select id, "cageName" from cages) ( select breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire from damdam, siresire, cagess, breedings where breedings.deleted != true and cagess.id = breedings.cage and damdam.breedingid = breedings.id and siresire.breedingid = breedings.id and breedings."unbreeding_date" is null group by breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire order by breeding_date, plug_date);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 07 10 2 1s675ms 837ms 11 3 2s400ms 800ms 13 1 808ms 808ms 14 2 1s600ms 800ms 15 1 805ms 805ms 16 1 2s174ms 2s174ms 18 1 793ms 793ms [ User: labanimal - Total duration: 10s258ms - Times executed: 11 ]
[ Application: _desktop_index.php_command_animals_breedings_subcommand_select_ - Total duration: 8s83ms - Times executed: 10 ]
[ Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv - Total duration: 2s174ms - Times executed: 1 ]
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 490) THEN TRUE WHEN user_is_tgm (dam.editor, 490) THEN TRUE WHEN user_is_tgm (dam.tourist, 490) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 490) THEN TRUE WHEN user_is_tgm (sire.editor, 490) THEN TRUE WHEN user_is_tgm (sire.tourist, 490) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-07 16:49:18 Duration: 2s174ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_command_login_subcommand_init_zemm_produktiv Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-07 10:46:47 Duration: 867ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_command_animals_breedings_subcommand_select_ Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-03-07 13:56:11 Duration: 808ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_command_animals_breedings_subcommand_select_ Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
20 802ms 987ms 895ms 2 1s790ms create index concurrently if not exists scoresheet_diary_animals_id_idx on public.scoresheet_diary (animals_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 07 11 2 1s790ms 895ms [ User: labanimal - Total duration: 1s790ms - Times executed: 2 ]
-
CREATE INDEX CONCURRENTLY IF NOT EXISTS scoresheet_diary_animals_id_idx ON public.scoresheet_diary (animals_id);
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 scoresheet_diary_animals_id_idx ON public.scoresheet_diary (animals_id);
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
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
- 86,981 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 26 FATAL entries
- 2 ERROR entries
- 0 WARNING entries
- 410 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 413 Max number of times the same event was reported
- 438 Total events found
Rank Times reported Error 1 413 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 07 00 24 02 2 03 4 05 2 09 54 10 146 11 78 12 24 13 32 14 28 15 19 - FATAL: database "monitoring" does not exist
- FATAL: database "monitoring" does not exist
- FATAL: database "monitoring" does not exist
Date: 2026-03-07 00:00:25 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
Date: 2026-03-07 00:00:55 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
Date: 2026-03-07 00:01:25 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
2 8 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 07 02 4 13 4 - LOG: could not receive data from client: Connection timed out
- LOG: could not receive data from client: Connection timed out
- LOG: could not receive data from client: Connection timed out
Date: 2026-03-07 02:14:12 Database: zemm_produktiv_8 Application: DBeaver 25.3.4 - SQLEditor 'Script-231.sql' User: labanimal Remote: 94.31.109.76 Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
Date: 2026-03-07 02:14:12 Database: zemm_produktiv_8 Application: DBeaver 25.3.4 - SQLEditor 'Script-230.sql' User: labanimal Remote: 94.31.109.76 Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
Date: 2026-03-07 02:14:12 Database: zemm_produktiv_8 Application: DBeaver 25.3.4 - Main 'zemm_produktiv_8' User: labanimal Remote: 94.31.109.76 Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
3 6 ERROR: COALESCE could not convert type timestamp without time zone to time without time zone
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 07 11 6 - ERROR: COALESCE could not convert type timestamp without time zone to time without time zone
- ERROR: COALESCE could not convert type timestamp without time zone to time without time zone
- ERROR: COALESCE could not convert type timestamp without time zone to time without time zone
Statement: SELECT u.id AS user_id, u."name" AS username, MAX(lt.timestamp) AS last_login, COALESCE( SUM( CASE WHEN lt.timestamp IS NULL THEN 0 ELSE GREATEST( EXTRACT( EPOCH FROM ( LEAST(COALESCE(lt.logout, CURRENT_TIMESTAMP::timestamp), $1::timestamp) - lt.timestamp ) ), 0 ) END ), 0 ) AS active_duration_seconds, COUNT(*) AS total_logins, MAX(lt.logout) AS last_action_timestamp, MIN(lt.timestamp) AS first_login_date, ( SELECT screen FROM monitoring_session_activity WHERE user_id = u.id ORDER BY updated_at DESC LIMIT 1 ) AS last_screen FROM login_tracker lt INNER JOIN users u ON u.id = lt.user WHERE lt.timestamp BETWEEN $2 AND $3 GROUP BY u.id, u."name" ORDER BY total_logins DESC LIMIT $4
Date: 2026-03-07 11:48:34 Database: zemm_produktiv_7 Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
Statement: SELECT u.id AS user_id, u."name" AS username, MAX(lt.timestamp) AS last_login, COALESCE( SUM( CASE WHEN lt.timestamp IS NULL THEN 0 ELSE GREATEST( EXTRACT( EPOCH FROM ( LEAST(COALESCE(lt.logout, CURRENT_TIMESTAMP::timestamp), $1::timestamp) - lt.timestamp ) ), 0 ) END ), 0 ) AS active_duration_seconds, COUNT(*) AS total_logins, MAX(lt.logout) AS last_action_timestamp, MIN(lt.timestamp) AS first_login_date, ( SELECT screen FROM monitoring_session_activity WHERE user_id = u.id ORDER BY updated_at DESC LIMIT 1 ) AS last_screen FROM login_tracker lt INNER JOIN users u ON u.id = lt.user WHERE lt.timestamp BETWEEN $2 AND $3 GROUP BY u.id, u."name" ORDER BY total_logins DESC LIMIT $4
Date: 2026-03-07 11:48:34 Database: zemm_produktiv_8 Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
Statement: SELECT u.id AS user_id, u."name" AS username, MAX(lt.timestamp) AS last_login, COALESCE( SUM( CASE WHEN lt.timestamp IS NULL THEN 0 ELSE GREATEST( EXTRACT( EPOCH FROM ( LEAST(COALESCE(lt.logout, CURRENT_TIMESTAMP::timestamp), $1::timestamp) - lt.timestamp ) ), 0 ) END ), 0 ) AS active_duration_seconds, COUNT(*) AS total_logins, MAX(lt.logout) AS last_action_timestamp, MIN(lt.timestamp) AS first_login_date, ( SELECT screen FROM monitoring_session_activity WHERE user_id = u.id ORDER BY updated_at DESC LIMIT 1 ) AS last_screen FROM login_tracker lt INNER JOIN users u ON u.id = lt.user WHERE lt.timestamp BETWEEN $2 AND $3 GROUP BY u.id, u."name" ORDER BY total_logins DESC LIMIT $4
Date: 2026-03-07 11:48:56 Database: zemm_produktiv_7 Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
4 3 ERROR: invalid input syntax for type boolean: ...
Times Reported Most Frequent Error / Event #4
Day Hour Count Mar 07 00 1 07 2 - ERROR: invalid input syntax for type boolean: ""
- 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-07 00:04:40 Database: zemm_produktiv_8 Application: _desktop_index.php_command_reports_subcommand_authority_meldung User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 07:44:46 Database: zemm_produktiv_8 Application: _desktop_index.php_command_reports_subcommand_authority_meldung User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-07_000000.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-07 07:44: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-07_000000.csv
5 3 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Mar 07 00 1 07 1 11 1 - ERROR: column "license" does not exist
- ERROR: column "license" does not exist
- ERROR: column "attrelid" does not exist
Statement: SELECT COUNT(*) as cnt FROM animals WHERE license = 10100118 AND NOT deleted
Date: 2026-03-07 00:00:44 Database: zemm_produktiv_8 Application: _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
Statement: SELECT COUNT(*) as cnt FROM animals WHERE license = 10100023 AND NOT deleted
Date: 2026-03-07 07:49:41 Database: zemm_produktiv_8 Application: _desktop_index.php_command_facility_subcommand_init_zemm_produk User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
Statement: SELECT attrelid::regclass::text AS table_name, attname, n_distinct, most_common_vals FROM pg_stats WHERE schemaname='public' AND ((tablename='login_tracker' AND attname IN ('loginname')) OR (tablename='scoresheet_diary' AND attname IN ('animals_id')) OR (tablename='animals' AND attname IN ('curCage','homeCage','alive','fate','deleted','animalID'))) ORDER BY table_name, attname;
Date: 2026-03-07 11:32:29 Database: zemm_produktiv_8 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
6 2 ERROR: duplicate key value violates unique constraint "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Mar 07 19 2 - ERROR: duplicate key value violates unique constraint "metrics_timeseries_tenant_key_metric_name_bucket_start_buck_key"
- ERROR: duplicate key value violates unique constraint "metrics_timeseries_tenant_key_metric_name_bucket_start_buck_key"
Detail: Key (tenant_key, metric_name, bucket_start, bucket_width_seconds)=(prod, http_requests_total, 2026-03-07 19:22:00+01, 60) already exists.
Statement: INSERT INTO observability.metrics_timeseries (tenant_key, metric_name, bucket_start, bucket_width_seconds, sum_value, count_value, histogram) VALUES ($1, $2, $3, $4, $5, $6, $7)Date: 2026-03-07 19:22:01 Database: zemm_monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
Detail: Key (tenant_key, metric_name, bucket_start, bucket_width_seconds)=(prod, http_requests_total, 2026-03-07 19:23:00+01, 60) already exists.
Statement: INSERT INTO observability.metrics_timeseries (tenant_key, metric_name, bucket_start, bucket_width_seconds, sum_value, count_value, histogram) VALUES ($1, $2, $3, $4, $5, $6, $7)Date: 2026-03-07 19:23:01 Database: zemm_monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
7 1 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #7
Day Hour Count Mar 07 16 1 - LOG: could not receive data from client: Connection reset by peer
Date: 2026-03-07 16:23:59 Database: zemm_produktiv_8 Application: notification:zemm_produktiv_8@h2940066.stratoserver.net:5432 User: labanimal Remote: 81.169.238.237 Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
8 1 ERROR: invalid UNION/INTERSECT/EXCEPT ORDER BY clause
Times Reported Most Frequent Error / Event #8
Day Hour Count Mar 07 10 1 - ERROR: invalid UNION/INTERSECT/EXCEPT ORDER BY clause
Detail: Only result column names can be used, not expressions or functions.
Hint: Add the expression/function to every SELECT, or move the UNION into a FROM clause.
Statement: WITH target AS (SELECT DISTINCT sys_id, sub_command FROM sys_actions WHERE command='reports' AND sub_command IN ('annual_reports','authority_meldungen')) SELECT 'role' AS kind, r.id::text AS principal_id, r.role AS principal_name, t.sub_command FROM roles r CROSS JOIN target t WHERE position(':'||t.sys_id::text||':' in ':'||coalesce(r.actions,'')||':') > 0 UNION ALL SELECT 'user' AS kind, u.id::text AS principal_id, u.name AS principal_name, t.sub_command FROM users u CROSS JOIN target t WHERE position(':'||t.sys_id::text||':' in ':'||coalesce(u.actions,'')||':') > 0 ORDER BY 1,2::int,4;Date: 2026-03-07 10:56:31 Database: zemm_produktiv_8 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv
9 1 FATAL: Peer authentication failed for user "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Mar 07 10 1 - FATAL: Peer authentication failed for user "labanimal"
Detail: Connection matched file "/etc/postgresql/18/main/pg_hba.conf" line 18: "local all all peer"
Date: 2026-03-07 10:56:01 Database: zemm_produktiv_8 Application: User: labanimal Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-07_000000.csv