ZEMM PG Report-
Global information
- Generated on Sun Mar 15 06:01:25 2026
- Log file: /var/log/postgresql/postgresql-2026-03-06_225012.csv, ..., /var/log/postgresql/postgresql-2026-03-15_000000.csv
- Parsed 262,365 log entries in 1m24s
- Log start from 2026-03-12 00:00:01 to 2026-03-12 23:59:25
-
Overview
Global Stats
- 1,602 Number of unique normalized queries
- 19,008 Number of queries
- 5h48m17s Total query duration
- 2026-03-12 00:00:01 First query
- 2026-03-12 23:59:01 Last query
- 1,298 queries/s at 2026-03-12 15:12:47 Query peak
- 5h48m17s Total query duration
- 22s939ms Prepare/parse total duration
- 0ms Bind total duration
- 5h47m54s Execute total duration
- 61 Number of events
- 8 Number of unique normalized events
- 38 Max number of times the same event was reported
- 0 Number of cancellation
- 125 Total number of automatic vacuums
- 213 Total number of automatic analyzes
- 179 Number temporary file
- 26.12 MiB Max size of temporary file
- 4.99 MiB Average size of temporary file
- 25,340 Total number of sessions
- 5 sessions at 2026-03-12 15:11:55 Session peak
- 1h13m50s Total duration of sessions
- 174ms Average duration of sessions
- 0 Average queries per session
- 824ms Average queries duration per session
- 0ms Average idle time per session
- 25,378 Total number of connections
- 29 connections/s at 2026-03-12 09:42:12 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 1,298 queries/s Query Peak
- 2026-03-12 15:12:47 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-03-12 11:19:46 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1,134 queries/s Query Peak
- 2026-03-12 15:12:47 Date
Queries duration
Key values
- 5h48m17s 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 12 00 720 0ms 0ms 0ms 0ms 0ms 0ms 01 721 0ms 772ms 373ms 9s264ms 9s264ms 9s264ms 02 720 772ms 772ms 772ms 9s264ms 9s264ms 9s264ms 03 720 772ms 772ms 772ms 9s264ms 9s264ms 9s264ms 04 720 772ms 772ms 772ms 9s264ms 9s264ms 9s264ms 05 720 772ms 772ms 772ms 9s264ms 9s264ms 9s264ms 06 720 772ms 772ms 772ms 9s264ms 9s264ms 9s264ms 07 720 772ms 772ms 772ms 9s264ms 9s264ms 9s264ms 08 727 545ms 1s529ms 812ms 14s270ms 14s270ms 14s270ms 09 748 563ms 6s688ms 1s5ms 19s688ms 19s688ms 42s4ms 10 723 788ms 935ms 814ms 10s399ms 11s231ms 12s25ms 11 733 632ms 2s317ms 1s326ms 27s810ms 27s810ms 29s354ms 12 729 641ms 1s2ms 933ms 12s25ms 12s25ms 14s744ms 13 745 538ms 1s628ms 758ms 10s688ms 11s244ms 14s459ms 14 726 633ms 817ms 775ms 9s811ms 9s811ms 12s132ms 15 2,330 512ms 22s939ms 2s742ms 4m35s 4m37s 25m25s 16 722 632ms 868ms 794ms 10s420ms 10s420ms 11s242ms 17 725 659ms 822ms 736ms 9s864ms 10s512ms 11s121ms 18 721 802ms 805ms 804ms 9s661ms 9s661ms 10s438ms 19 720 805ms 805ms 805ms 9s661ms 9s661ms 9s661ms 20 724 805ms 3s643ms 1s795ms 43s243ms 43s373ms 50s616ms 21 724 630ms 3s603ms 2s59ms 43s243ms 43s243ms 45s863ms 22 724 630ms 687ms 630ms 7s565ms 7s565ms 10s202ms 23 726 540ms 1s973ms 899ms 17s451ms 17s451ms 23s818ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 12 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 7 0 914ms 0ms 0ms 2s224ms 09 13 13 1s454ms 0ms 788ms 6s362ms 10 1 0 935ms 0ms 0ms 0ms 11 11 0 692ms 0ms 0ms 2s650ms 12 8 0 677ms 0ms 0ms 1s374ms 13 21 0 709ms 0ms 1s349ms 1s864ms 14 4 0 661ms 0ms 0ms 0ms 15 12 23 2s114ms 0ms 1s995ms 12s963ms 16 0 0 0ms 0ms 0ms 0ms 17 2 0 680ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 4 0 3s625ms 0ms 0ms 7s243ms 21 4 0 655ms 0ms 0ms 0ms 22 4 0 659ms 0ms 0ms 0ms 23 1 5 1s303ms 0ms 0ms 1s454ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 12 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 1 0 0 772ms 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 7 2s237ms 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 12 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 1 0 0.00 0.05% 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 12 00 244 0.07/s 01 247 0.07/s 02 247 0.07/s 03 244 0.07/s 04 244 0.07/s 05 260 0.07/s 06 386 0.11/s 07 929 0.26/s 08 1,388 0.39/s 09 3,200 0.89/s 10 1,953 0.54/s 11 1,914 0.53/s 12 1,833 0.51/s 13 3,138 0.87/s 14 2,286 0.64/s 15 1,290 0.36/s 16 937 0.26/s 17 1,499 0.42/s 18 662 0.18/s 19 576 0.16/s 20 800 0.22/s 21 282 0.08/s 22 343 0.10/s 23 476 0.13/s Day Hour Count Average Duration Average idle time Mar 12 00 244 53ms 53ms 01 247 59ms 0ms 02 247 53ms 0ms 03 244 54ms 0ms 04 244 53ms 0ms 05 260 53ms 0ms 06 386 59ms 0ms 07 929 76ms 0ms 08 1,386 87ms 0ms 09 3,198 126ms 0ms 10 1,952 77ms 0ms 11 1,914 104ms 0ms 12 1,833 114ms 0ms 13 3,138 131ms 0ms 14 2,286 146ms 0ms 15 1,279 1s155ms 0ms 16 920 148ms 0ms 17 1,499 142ms 0ms 18 662 249ms 0ms 19 576 256ms 0ms 20 798 221ms 0ms 21 279 80ms 0ms 22 343 73ms 0ms 23 476 110ms 0ms -
Connections
Established Connections
Key values
- 29 connections Connection Peak
- 2026-03-12 09:42:12 Date
Connections per database
Key values
- zemm_monitoring Main Database
- 25,378 connections Total
Connections per user
Key values
- labanimal Main User
- 25,378 connections Total
-
Sessions
Simultaneous sessions
Key values
- 5 sessions Session Peak
- 2026-03-12 15:11:55 Date
Histogram of session times
Key values
- 24,237 0-500ms duration
Sessions per database
Key values
- zemm_monitoring Main Database
- 25,340 sessions Total
Sessions per user
Key values
- labanimal Main User
- 25,340 sessions Total
Sessions per host
Key values
- ::1 Main Host
- 25,340 sessions Total
Sessions per application
Key values
- Main Application
- 25,340 sessions Total
Application Count Total Duration Average Duration 20,763 38m54s 112ms DBeaver 26.0.0 - Main 'zemm_produktiv_7' 2 8m39s 4m19s DBeaver 26.0.0 - Main 'zemm_produktiv_8' 2 9m24s 4m42s _backend_cage_autocomplete_api.php_q_2025_limit_12_zemm_produkt 14 338ms 24ms _backend_cage_autocomplete_api.php_q_55-065_limit_12_zemm_produ 14 625ms 44ms _backend_wean_api.php_litter_id_10130227_zemm_produktiv_7_local 70 9s811ms 140ms _backend_wean_api.php_litter_id_10130236_zemm_produktiv_7_local 70 10s184ms 145ms _backend_wean_api.php_litter_id_10130257_zemm_produktiv_7_local 84 11s954ms 142ms _backend_wean_api.php_litter_id_10131338_zemm_produktiv_8_local 2 277ms 138ms _backend_wean_api.php_litter_id_10131339_zemm_produktiv_8_local 2 271ms 135ms _backend_wean_api.php_litter_id_10131341_zemm_produktiv_8_local 2 272ms 136ms _backend_wean_api.php_litter_id_10131342_zemm_produktiv_8_local 6 827ms 137ms _backend_wean_api.php_litter_id_10131343_zemm_produktiv_8_local 3 419ms 139ms _backend_wean_api.php_litter_id_10131346_zemm_produktiv_8_local 14 1s932ms 138ms _backend_wean_api.php_litter_id_10131362_zemm_produktiv_8_local 2 275ms 137ms _backend_wean_api.php_litter_id_10131439_zemm_produktiv_8_local 6 828ms 138ms _backend_wean_api.php_litter_id_10131586_zemm_produktiv_8_local 2 267ms 133ms _backend_wean_api.php_litter_id_10131592_zemm_produktiv_8_local 2 277ms 138ms _backend_wean_api.php_litter_id_10131611_zemm_produktiv_8_local 6 832ms 138ms _backend_wean_api.php_litter_id_10131651_zemm_produktiv_8_local 2 277ms 138ms _desktop__zemm_produktiv_7_localhost_5432 15 4s285ms 285ms _desktop__zemm_produktiv_8_localhost_5432 21 1s317ms 62ms _desktop_index.php_aid_10243781_command_animals_edit_subcommand 1 84ms 84ms _desktop_index.php_animal_name_34_animal_id_2026_2F000_2F5291_s 1 47ms 47ms _desktop_index.php_animal_name_3_animal_id_2024_2F001_2F9509_sp 2 128ms 64ms _desktop_index.php_cages_empty__25_val4_cages_search_command_an 1 50ms 50ms _desktop_index.php_cages_name_32_2A_cages_empty_false_val4_cage 1 174ms 174ms _desktop_index.php_command_animals_breedings_subcommand_select_ 15 605ms 40ms _desktop_index.php_command_animals_create_subcommand_init_zemm_ 15 718ms 47ms _desktop_index.php_command_animals_edit_subcommand_init_id_1024 1 99ms 99ms _desktop_index.php_command_animals_edit_subcommand_init_id_1029 2 195ms 97ms _desktop_index.php_command_animals_edit_subcommand_init_id_1030 1 90ms 90ms _desktop_index.php_command_animals_edit_subcommand_link_init_va 14 1s195ms 85ms _desktop_index.php_command_animals_edit_subcommand_m_init_scree 14 1s434ms 102ms _desktop_index.php_command_animals_litters_edit_subcommand_init 14 1s288ms 92ms _desktop_index.php_command_animals_litters_edit_subcommand_m_in 14 4s203ms 300ms _desktop_index.php_command_animals_litters_subcommand_init_zemm 1 48ms 48ms _desktop_index.php_command_animals_litters_subcommand_select_ze 15 546ms 36ms _desktop_index.php_command_animals_subcommand_init_zemm_produkt 13 609ms 46ms _desktop_index.php_command_animals_subcommand_select_zemm_produ 15 847ms 56ms _desktop_index.php_command_cages_subcommand_init_zemm_produktiv 4 169ms 42ms _desktop_index.php_command_home_subcommand_init_zemm_produktiv_ 1 89ms 89ms _desktop_index.php_command_login_subcommand_init_zemm_produktiv 286 8s893ms 31ms _desktop_index.php_command_reports_subcommand_animals_per_room_ 4 444ms 111ms _desktop_index.php_command_reports_subcommand_animals_per_user_ 9 994ms 110ms _desktop_index.php_command_reports_subcommand_fates_zemm_produk 17 1s752ms 103ms _desktop_index.php_command_reports_subcommand_init_zemm_produkt 33 8s857ms 268ms _desktop_index.php_command_reports_subcommand_room_utilisation_ 1 117ms 117ms _desktop_index.php_command_reports_subcommand_task_status_zemm_ 3 338ms 112ms _desktop_index.php_command_strains_subcommand_create_zemm_produ 1 49ms 49ms _desktop_index.php_command_strains_subcommand_init_zemm_produkt 1 72ms 72ms _desktop_index.php_command_strains_subcommand_view_id_10100392_ 1 48ms 48ms _desktop_index.php_command_strains_subcommand_view_id_10100395_ 2 99ms 49ms _desktop_index.php_command_tasks_subcommand_create_task_id_48_z 1 57ms 57ms _desktop_index.php_command_tasks_subcommand_create_task_id_50_z 1 55ms 55ms _desktop_index.php_command_tasks_subcommand_edit_id_10126484_ze 8 539ms 67ms _desktop_index.php_command_tasks_subcommand_edit_id_10134267_ze 6 427ms 71ms _desktop_index.php_command_tasks_subcommand_edit_id_10140889_ze 2 164ms 82ms _desktop_index.php_command_tasks_subcommand_edit_id_10141526_ze 1 83ms 83ms _desktop_index.php_command_tasks_subcommand_edit_id_10141527_ze 1 85ms 85ms _desktop_index.php_command_tasks_subcommand_edit_id_10141528_ze 1 86ms 86ms _desktop_index.php_command_tasks_subcommand_edit_id_10141530_ze 1 86ms 86ms _desktop_index.php_command_tasks_subcommand_edit_id_10141531_ze 1 88ms 88ms _desktop_index.php_command_tasks_subcommand_edit_id_10141536_ze 1 85ms 85ms _desktop_index.php_command_tasks_subcommand_edit_id_10141537_ze 1 84ms 84ms _desktop_index.php_command_tasks_subcommand_edit_id_10141538_ze 1 88ms 88ms _desktop_index.php_command_tasks_subcommand_edit_id_10141560_ze 5 471ms 94ms _desktop_index.php_command_tasks_subcommand_edit_id_10141565_ze 1 86ms 86ms _desktop_index.php_command_tasks_subcommand_edit_id_10141569_ze 1 81ms 81ms _desktop_index.php_command_tasks_subcommand_edit_id_10141572_ze 2 172ms 86ms _desktop_index.php_command_tasks_subcommand_edit_id_10141592_ze 2 178ms 89ms _desktop_index.php_command_tasks_subcommand_init_search_zemm_pr 14 457ms 32ms _desktop_index.php_command_tasks_subcommand_init_zemm_produktiv 1 102ms 102ms _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv 116 9s465ms 81ms _desktop_index.php_command_tasks_subcommand_search_zemm_produkt 20 787ms 39ms _desktop_index.php_m_action_animals_3Am_delete_row_animals_1027 1 598ms 598ms _desktop_index.php_m_action_animals_3Am_delete_row_animals_1029 2 92ms 46ms _desktop_index.php_m_action_animals_3Am_delete_val4_animals_lis 1 33ms 33ms _desktop_index.php_m_action_animals_3Am_send_animal_card_row_an 1 695ms 695ms _desktop_index.php_m_action_animals_edit_3Alink_init_row_animal 3 162ms 54ms _desktop_index.php_name_Genotypisierungsproben_20genommen_instr 5 348ms 69ms _desktop_index.php_name_Projektwechsel_20lebender_20Tiere_instr 2 105ms 52ms _desktop_index.php_name_Verpaarungen_20zur_20Zucht_instructions 1 48ms 48ms _desktop_index.php_name_Zusammensetzen_20bitte_add_link_animals 1 68ms 68ms _desktop_index.php_search_id_10140151_search_status_2_no_subtas 1 51ms 51ms _desktop_index.php_search_id_10141592_search_status__25_no_subt 2 132ms 66ms _desktop_index.php_search_name_Genotypisierungsproben_20genomme 1 54ms 54ms _desktop_index.php_search_status_1_deadline_from_2026-04-01_no_ 4 215ms 53ms _desktop_index.php_sire_name_85_20Z_dam_name_76_20Z_sire_id_202 1 149ms 149ms _desktop_index.php_view_animal_name_on_view_animal_id_on_animal 4 801ms 200ms _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b 27 14s354ms 531ms _desktop_index.php_view_animal_name_on_view_animal_id_on_view_s 1 593ms 593ms _desktop_index.php_zemm_produktiv_7_localhost_5432 288 1m10s 246ms _desktop_index.php_zemm_produktiv_8_localhost_5432 3,053 9m55s 195ms backend:zemm_produktiv_7@localhost 14 10s719ms 765ms backend:zemm_produktiv_8@localhost 53 7s706ms 145ms expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 1 793ms 793ms notification:zemm_produktiv_7@localhost:5432 2 513ms 256ms notification:zemm_produktiv_8@h2940066.stratoserver.net:5432 2 475ms 237ms notification:zemm_produktiv_8@localhost:5432 3 692ms 230ms pg_dump 6 2m31s 25s278ms pg_restore 1 38s23ms 38s23ms psql 16 182ms 11ms taskscron:zemm_produktiv_7@zemm.fbiscience.eu 24 642ms 26ms taskscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 24 21s265ms 886ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 164,158 buffers Checkpoint Peak
- 2026-03-12 15:20:40 Date
- 270.073 seconds Highest write time
- 0.113 seconds Sync time
Checkpoints Wal files
Key values
- 84 files Wal files usage Peak
- 2026-03-12 15:20:40 Date
Checkpoints distance
Key values
- 2,705.66 Mo Distance Peak
- 2026-03-12 15:20:40 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Mar 12 00 1,811 181.693s 0.072s 181.82s 01 20,148 442.722s 0.084s 442.859s 02 1,769 177.479s 0.081s 177.615s 03 1,772 177.771s 0.071s 177.905s 04 1,926 193.189s 0.065s 193.314s 05 1,772 177.772s 0.07s 177.905s 06 2,376 238.373s 0.1s 238.537s 07 3,382 339.228s 0.147s 339.434s 08 9,428 629.479s 0.159s 629.696s 09 6,294 630.696s 0.22s 630.975s 10 21,686 969.044s 0.187s 969.298s 11 48,322 937.062s 0.151s 937.27s 12 17,250 667.005s 0.179s 667.247s 13 41,607 1,302.811s 0.255s 1,303.134s 14 6,090 610.419s 0.255s 610.741s 15 167,490 603.772s 0.21s 604.11s 16 2,907 291.526s 0.085s 291.669s 17 4,272 427.981s 0.122s 428.161s 18 2,158 216.45s 0.073s 216.584s 19 2,405 241.109s 0.076s 241.24s 20 8,211 497.276s 0.093s 497.437s 21 2,098 210.428s 0.064s 210.543s 22 2,061 206.738s 0.076s 206.873s 23 2,129 213.561s 0.08s 213.701s Day Hour Added Removed Recycled Synced files Longest sync Average sync Mar 12 00 0 0 0 309 0.002s 0.012s 01 0 0 7 319 0.002s 0.011s 02 0 0 1 315 0.002s 0.012s 03 0 0 0 311 0.002s 0.012s 04 0 0 1 311 0.002s 0.012s 05 0 0 1 318 0.002s 0.012s 06 0 0 0 522 0.002s 0.012s 07 0 0 2 810 0.002s 0.012s 08 0 0 2 909 0.002s 0.012s 09 0 0 1 1,176 0.004s 0.012s 10 0 0 10 1,077 0.004s 0.012s 11 0 0 10 862 0.002s 0.011s 12 0 0 5 979 0.004s 0.013s 13 0 0 19 1,461 0.006s 0.012s 14 0 0 2 1,006 0.043s 0.014s 15 0 0 86 1,236 0.002s 0.012s 16 0 1 0 424 0.002s 0.012s 17 0 1 0 653 0.002s 0.012s 18 0 1 0 333 0.002s 0.012s 19 0 0 0 373 0.002s 0.012s 20 0 3 0 492 0.002s 0.012s 21 0 0 0 304 0.001s 0.012s 22 0 1 0 373 0.002s 0.012s 23 0 1 0 371 0.002s 0.012s Day Hour Count Avg time (sec) Mar 12 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 12 00 942.92 kB 1,037.17 kB 01 9,676.64 kB 36,344.36 kB 02 939.42 kB 34,527.33 kB 03 935.83 kB 10,423.75 kB 04 954.25 kB 3,624.25 kB 05 916.00 kB 1,688.58 kB 06 1,060.67 kB 1,303.08 kB 07 1,399.58 kB 1,866.00 kB 08 2,913.25 kB 10,968.17 kB 09 2,222.42 kB 5,453.00 kB 10 12,790.08 kB 49,732.00 kB 11 16,084.18 kB 52,463.45 kB 12 5,865.08 kB 33,839.08 kB 13 25,913.67 kB 54,217.25 kB 14 2,922.00 kB 57,908.00 kB 15 116,725.67 kB 713,963.42 kB 16 1,228.00 kB 321,881.25 kB 17 1,695.50 kB 92,011.17 kB 18 1,076.25 kB 26,936.58 kB 19 1,117.33 kB 8,376.92 kB 20 2,814.75 kB 10,237.17 kB 21 1,034.83 kB 7,404.17 kB 22 1,035.50 kB 2,832.25 kB 23 1,046.67 kB 1,539.17 kB -
Temporary Files
Size of temporary files
Key values
- 170.06 MiB Temp Files size Peak
- 2026-03-12 15:13:07 Date
Number of temporary files
Key values
- 48 per second Temp Files Peak
- 2026-03-12 15:13:05 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Mar 12 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 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 179 892.78 MiB 4.99 MiB 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 10 42.39 MiB 8.00 KiB 9.34 MiB 4.24 MiB alter table only public.diary add constraint diary_pkey primary key (id);-
ALTER TABLE ONLY public.diary ADD CONSTRAINT diary_pkey PRIMARY KEY (id);
Date: 2026-03-12 15:13:05 Duration: 787ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
2 10 126.25 MiB 8.00 KiB 25.79 MiB 12.62 MiB alter table only public."targetgroupMembers" add constraint "targetgroupMembers_pkey" primary key (id);-
ALTER TABLE ONLY public."targetgroupMembers" ADD CONSTRAINT "targetgroupMembers_pkey" PRIMARY KEY (id);
Date: 2026-03-12 15:13:05 Duration: 787ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
3 8 11.59 MiB 8.00 KiB 4.13 MiB 1.45 MiB alter table only public.animals add constraint animals_pkey primary key (id);-
ALTER TABLE ONLY public.animals ADD CONSTRAINT animals_pkey PRIMARY KEY (id);
Date: 2026-03-12 15:13:04 Duration: 787ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
4 8 11.59 MiB 8.00 KiB 4.21 MiB 1.45 MiB alter table only public.animals_search_mview add constraint animals_search_mview_pkey primary key (id);-
ALTER TABLE ONLY public.animals_search_mview ADD CONSTRAINT animals_search_mview_pkey PRIMARY KEY (id);
Date: 2026-03-12 15:13:04 Duration: 787ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
5 8 43.81 MiB 8.00 KiB 12.48 MiB 5.48 MiB alter table only public.targetgroups add constraint targetgroups_pkey primary key (id);-
ALTER TABLE ONLY public.targetgroups ADD CONSTRAINT targetgroups_pkey PRIMARY KEY (id);
Date: 2026-03-12 15:13:07 Duration: 1s421ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
6 8 13.84 MiB 8.00 KiB 5.91 MiB 1.73 MiB alter table only public.cost_history add constraint cost_history_pkey primary key (id);-
ALTER TABLE ONLY public.cost_history ADD CONSTRAINT cost_history_pkey PRIMARY KEY (id);
Date: 2026-03-12 15:13:05 Duration: 787ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
7 6 1.72 MiB 8.00 KiB 1.68 MiB 293.33 KiB alter table only public.login_tracker add constraint login_tracker_pkey primary key (id);-
ALTER TABLE ONLY public.login_tracker ADD CONSTRAINT login_tracker_pkey PRIMARY KEY (id);
Date: 2026-03-12 15:13:05 Duration: 787ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
8 6 9.29 MiB 8.00 KiB 9.23 MiB 1.55 MiB alter table only public.tasks_changes add constraint tasks_changes_index01 primary key (id, task);-
ALTER TABLE ONLY public.tasks_changes ADD CONSTRAINT tasks_changes_index01 PRIMARY KEY (id, task);
Date: 2026-03-12 15:13:07 Duration: 1s421ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
9 6 3.72 MiB 8.00 KiB 2.61 MiB 634.67 KiB create unique index idxsessionid on public.login_tracker using btree (sessionid);-
CREATE UNIQUE INDEX idxsessionid ON public.login_tracker USING btree (sessionid);
Date: 2026-03-12 15:13:10 Duration: 961ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
10 6 1.12 MiB 8.00 KiB 1.08 MiB 190.67 KiB alter table only public.tasks add constraint tasks_pkey primary key (id);-
ALTER TABLE ONLY public.tasks ADD CONSTRAINT tasks_pkey PRIMARY KEY (id);
Date: 2026-03-12 15:13:08 Duration: 1s421ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
11 5 126.20 MiB 24.86 MiB 26.12 MiB 25.24 MiB create index "targetgroupMembers_FKIndex1" on public."targetgroupMembers" using btree (targetgroup);-
CREATE INDEX "targetgroupMembers_FKIndex1" ON public."targetgroupMembers" USING btree (targetgroup);
Date: 2026-03-12 15:13:10 Duration: 961ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
12 5 126.20 MiB 24.16 MiB 25.86 MiB 25.24 MiB create index "targetgroupMembers_FKIndex2" on public."targetgroupMembers" using btree ("group");-
CREATE INDEX "targetgroupMembers_FKIndex2" ON public."targetgroupMembers" USING btree ("group");
Date: 2026-03-12 15:13:12 Duration: 1s393ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
13 5 126.21 MiB 24.37 MiB 25.69 MiB 25.24 MiB create index "targetgroupMembers_user_idx" on public."targetgroupMembers" using btree ("user");-
CREATE INDEX "targetgroupMembers_user_idx" ON public."targetgroupMembers" USING btree ("user");
Date: 2026-03-12 15:13:13 Duration: 1s375ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
14 5 42.36 MiB 7.76 MiB 10.31 MiB 8.47 MiB create index diary_animalid_idx on public.diary using btree ("animalID");-
CREATE INDEX diary_animalid_idx ON public.diary USING btree ("animalID");
Date: 2026-03-12 15:13:09 Duration: 961ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
15 4 1.81 MiB 8.00 KiB 1.79 MiB 464.00 KiB alter table only public.litters_search_mview add constraint litters_search_mview_pkey primary key (id);-
ALTER TABLE ONLY public.litters_search_mview ADD CONSTRAINT litters_search_mview_pkey PRIMARY KEY (id);
Date: 2026-03-12 15:13:05 Duration: 787ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
16 4 3.71 MiB 8.00 KiB 3.30 MiB 950.00 KiB alter table only public.monitoring_session_activity add constraint monitoring_session_activity_pkey primary key (session_id);-
ALTER TABLE ONLY public.monitoring_session_activity ADD CONSTRAINT monitoring_session_activity_pkey PRIMARY KEY (session_id);
Date: 2026-03-12 15:13:05 Duration: 787ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
17 4 1.81 MiB 8.00 KiB 1.61 MiB 464.00 KiB alter table only public.litters add constraint litters_pkey primary key (id);-
ALTER TABLE ONLY public.litters ADD CONSTRAINT litters_pkey PRIMARY KEY (id);
Date: 2026-03-12 15:13:05 Duration: 787ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
18 4 2.30 MiB 8.00 KiB 1.84 MiB 588.00 KiB alter table only public.fem_numbers add constraint pkey primary key (id);-
ALTER TABLE ONLY public.fem_numbers ADD CONSTRAINT pkey PRIMARY KEY (id);
Date: 2026-03-12 15:13:05 Duration: 787ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
19 4 25.43 MiB 5.84 MiB 7.71 MiB 6.36 MiB create index animals_mview_idx on public.animals_search_mview using btree (id nulls first, owner nulls first, editor nulls first, tourist nulls first);-
CREATE INDEX animals_mview_idx ON public.animals_search_mview USING btree (id NULLS FIRST, owner NULLS FIRST, editor NULLS FIRST, tourist NULLS FIRST);
Date: 2026-03-12 15:13:09 Duration: 961ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
20 4 13.80 MiB 2.91 MiB 4.95 MiB 3.45 MiB create index cost_history_animal_idx on public.cost_history using btree (animal);-
CREATE INDEX cost_history_animal_idx ON public.cost_history USING btree (animal);
Date: 2026-03-12 15:13:09 Duration: 961ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
21 4 11.55 MiB 2.59 MiB 3.73 MiB 2.89 MiB create index animals_curcage_active_idx on public.animals using btree ("curCage") where (not deleted);-
CREATE INDEX animals_curcage_active_idx ON public.animals USING btree ("curCage") WHERE (NOT deleted);
Date: 2026-03-12 15:13:09 Duration: 961ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
22 4 11.56 MiB 2.45 MiB 4.20 MiB 2.89 MiB create index "animals_FKIndex11" on public.animals using btree (species);-
CREATE INDEX "animals_FKIndex11" ON public.animals USING btree (species);
Date: 2026-03-12 15:13:08 Duration: 1s421ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
23 4 11.56 MiB 2.41 MiB 4.29 MiB 2.89 MiB create index "animals_FKIndex2" on public.animals using btree ("homeCage");-
CREATE INDEX "animals_FKIndex2" ON public.animals USING btree ("homeCage");
Date: 2026-03-12 15:13:08 Duration: 1s421ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
24 4 16.19 MiB 3.42 MiB 5.23 MiB 4.05 MiB create index animals_animalid_idx on public.animals using btree ("animalID");-
CREATE INDEX animals_animalid_idx ON public.animals USING btree ("animalID");
Date: 2026-03-12 15:13:08 Duration: 1s421ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
25 4 3.48 MiB 8.00 KiB 2.43 MiB 890.00 KiB alter table only public.litter_history add constraint litter_history_pkey primary key (id);-
ALTER TABLE ONLY public.litter_history ADD CONSTRAINT litter_history_pkey PRIMARY KEY (id);
Date: 2026-03-12 15:13:05 Duration: 787ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
26 4 3.20 MiB 8.00 KiB 2.43 MiB 820.00 KiB alter table only public.fem_numbers add constraint main_ukey unique (year, th, num);-
ALTER TABLE ONLY public.fem_numbers ADD CONSTRAINT main_ukey UNIQUE (year, th, num);
Date: 2026-03-12 15:13:05 Duration: 787ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
27 4 78.38 MiB 18.86 MiB 21.03 MiB 19.59 MiB create index titleindex on public.targetgroups using btree (title);-
CREATE INDEX titleindex ON public.targetgroups USING btree (title);
Date: 2026-03-12 15:13:15 Duration: 1s178ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
28 3 1.09 MiB 144.00 KiB 816.00 KiB 370.67 KiB create index tasks_editor_idx on public.tasks using btree (editor);-
CREATE INDEX tasks_editor_idx ON public.tasks USING btree (editor);
Date: 2026-03-12 15:13:14 Duration: 1s178ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
29 3 1.09 MiB 128.00 KiB 824.00 KiB 370.67 KiB create index tasks_owner_index on public.tasks using btree (owner);-
CREATE INDEX tasks_owner_index ON public.tasks USING btree (owner);
Date: 2026-03-12 15:13:14 Duration: 1s178ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
30 3 1.68 MiB 152.00 KiB 1.30 MiB 573.33 KiB create index login_tracker_user_idx on public.login_tracker using btree ("user");-
CREATE INDEX login_tracker_user_idx ON public.login_tracker USING btree ("user");
Date: 2026-03-12 15:13:10 Duration: 961ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
31 3 6.62 MiB 1.79 MiB 2.97 MiB 2.21 MiB create index tasks_changes_deleted_idx on public.tasks_changes using btree (deleted);-
CREATE INDEX tasks_changes_deleted_idx ON public.tasks_changes USING btree (deleted);
Date: 2026-03-12 15:13:14 Duration: 1s178ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
32 3 1.09 MiB 56.00 KiB 984.00 KiB 370.67 KiB create index tasks_done_idx on public.tasks using btree (done);-
CREATE INDEX tasks_done_idx ON public.tasks USING btree (done);
Date: 2026-03-12 15:13:14 Duration: 1s178ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
33 3 1.09 MiB 160.00 KiB 776.00 KiB 370.67 KiB create index tasks_task_status_idx on public.tasks using btree (task_status);-
CREATE INDEX tasks_task_status_idx ON public.tasks USING btree (task_status);
Date: 2026-03-12 15:13:15 Duration: 1s178ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
34 3 1.52 MiB 96.00 KiB 1.33 MiB 517.33 KiB create index tasks_id_parent_idx on public.tasks using btree (id, parent);-
CREATE INDEX tasks_id_parent_idx ON public.tasks USING btree (id, parent);
Date: 2026-03-12 15:13:14 Duration: 1s178ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
35 3 1.09 MiB 168.00 KiB 776.00 KiB 370.67 KiB create index tasks_active_index on public.tasks using btree (active);-
CREATE INDEX tasks_active_index ON public.tasks USING btree (active);
Date: 2026-03-12 15:13:14 Duration: 1s178ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
36 3 3.00 MiB 448.00 KiB 2.02 MiB 1.00 MiB create index login_tracker_loginname_timestamp_idx on public.login_tracker using btree (loginname, "timestamp" desc);-
CREATE INDEX login_tracker_loginname_timestamp_idx ON public.login_tracker USING btree (loginname, "timestamp" DESC);
Date: 2026-03-12 15:13:10 Duration: 961ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
37 2 1.68 MiB 208.00 KiB 1.48 MiB 860.00 KiB create index monitoring_session_activity_user_idx on public.monitoring_session_activity using btree (user_id);-
CREATE INDEX monitoring_session_activity_user_idx ON public.monitoring_session_activity USING btree (user_id);
Date: 2026-03-12 15:13:10 Duration: 961ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
38 2 1.79 MiB 216.00 KiB 1.58 MiB 916.00 KiB create index litters_dam_index on public.litters using btree (dam);-
CREATE INDEX litters_dam_index ON public.litters USING btree (dam);
Date: 2026-03-12 15:13:10 Duration: 961ms Database: zemm_produktiv_7 User: labanimal Application: pg_restore Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
Queries generating the largest temporary files
Rank Size Query 1 26.12 MiB CREATE INDEX "targetgroupMembers_FKIndex1" ON public."targetgroupMembers" USING btree (targetgroup);[ Date: 2026-03-12 15:13:12 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
2 25.86 MiB CREATE INDEX "targetgroupMembers_FKIndex2" ON public."targetgroupMembers" USING btree ("group");[ Date: 2026-03-12 15:13:13 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
3 25.79 MiB ALTER TABLE ONLY public."targetgroupMembers" ADD CONSTRAINT "targetgroupMembers_pkey" PRIMARY KEY (id);[ Date: 2026-03-12 15:13:07 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
4 25.73 MiB CREATE INDEX "targetgroupMembers_FKIndex2" ON public."targetgroupMembers" USING btree ("group");[ Date: 2026-03-12 15:13:13 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
5 25.69 MiB CREATE INDEX "targetgroupMembers_FKIndex2" ON public."targetgroupMembers" USING btree ("group");[ Date: 2026-03-12 15:13:13 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
6 25.69 MiB CREATE INDEX "targetgroupMembers_user_idx" ON public."targetgroupMembers" USING btree ("user");[ Date: 2026-03-12 15:13:14 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
7 25.57 MiB CREATE INDEX "targetgroupMembers_user_idx" ON public."targetgroupMembers" USING btree ("user");[ Date: 2026-03-12 15:13:14 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
8 25.50 MiB ALTER TABLE ONLY public."targetgroupMembers" ADD CONSTRAINT "targetgroupMembers_pkey" PRIMARY KEY (id);[ Date: 2026-03-12 15:13:07 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
9 25.31 MiB CREATE INDEX "targetgroupMembers_user_idx" ON public."targetgroupMembers" USING btree ("user");[ Date: 2026-03-12 15:13:14 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
10 25.27 MiB CREATE INDEX "targetgroupMembers_user_idx" ON public."targetgroupMembers" USING btree ("user");[ Date: 2026-03-12 15:13:14 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
11 25.16 MiB ALTER TABLE ONLY public."targetgroupMembers" ADD CONSTRAINT "targetgroupMembers_pkey" PRIMARY KEY (id);[ Date: 2026-03-12 15:13:07 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
12 25.12 MiB CREATE INDEX "targetgroupMembers_FKIndex1" ON public."targetgroupMembers" USING btree (targetgroup);[ Date: 2026-03-12 15:13:12 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
13 25.10 MiB CREATE INDEX "targetgroupMembers_FKIndex1" ON public."targetgroupMembers" USING btree (targetgroup);[ Date: 2026-03-12 15:13:12 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
14 25.00 MiB CREATE INDEX "targetgroupMembers_FKIndex1" ON public."targetgroupMembers" USING btree (targetgroup);[ Date: 2026-03-12 15:13:12 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
15 24.96 MiB ALTER TABLE ONLY public."targetgroupMembers" ADD CONSTRAINT "targetgroupMembers_pkey" PRIMARY KEY (id);[ Date: 2026-03-12 15:13:07 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
16 24.86 MiB CREATE INDEX "targetgroupMembers_FKIndex1" ON public."targetgroupMembers" USING btree (targetgroup);[ Date: 2026-03-12 15:13:12 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
17 24.80 MiB ALTER TABLE ONLY public."targetgroupMembers" ADD CONSTRAINT "targetgroupMembers_pkey" PRIMARY KEY (id);[ Date: 2026-03-12 15:13:07 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
18 24.77 MiB CREATE INDEX "targetgroupMembers_FKIndex2" ON public."targetgroupMembers" USING btree ("group");[ Date: 2026-03-12 15:13:13 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
19 24.37 MiB CREATE INDEX "targetgroupMembers_user_idx" ON public."targetgroupMembers" USING btree ("user");[ Date: 2026-03-12 15:13:14 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
20 24.16 MiB CREATE INDEX "targetgroupMembers_FKIndex2" ON public."targetgroupMembers" USING btree ("group");[ Date: 2026-03-12 15:13:13 - Database: zemm_produktiv_7 - User: labanimal - Application: pg_restore ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 11.10 sec Highest CPU-cost vacuum
Table observability.db_top_queries
Database zemm_monitoring - 2026-03-12 11:16:12 Date
- 0 sec Highest CPU-cost analyze
Table
Database zemm_monitoring - Date
Average Autovacuum Duration
Key values
- 11.10 sec Highest CPU-cost vacuum
Table observability.db_top_queries
Database zemm_monitoring - 2026-03-12 11:16:12 Date
Analyzes per table
Key values
- pg_catalog.pg_type (40) Main table analyzed (database zemm_produktiv_8)
- 213 analyzes Total
Table Number of analyzes zemm_produktiv_8.pg_catalog.pg_type 40 zemm_produktiv_8.pg_catalog.pg_attribute 31 zemm_produktiv_8.pg_catalog.pg_class 22 zemm_produktiv_8.pg_catalog.pg_depend 20 zemm_produktiv_8.public.breedingsdams 13 zemm_produktiv_8.public.breedingssires 13 zemm_produktiv_7.pg_catalog.pg_type 4 template1.pg_catalog.pg_shdepend 3 zemm_produktiv_7.pg_catalog.pg_attribute 3 zemm_produktiv_7.pg_catalog.pg_class 2 zemm_produktiv_8.public.tmptasks 2 zemm_produktiv_7.pg_catalog.pg_depend 2 zemm_produktiv_8.public.cages_search_mview 2 zemm_monitoring.observability.metrics_timeseries 2 zemm_produktiv_7.public.taskattachment 1 zemm_produktiv_7.public.diary 1 zemm_produktiv_7.pg_catalog.pg_sequence 1 zemm_produktiv_7.public.scoresheet_response 1 zemm_monitoring.observability.nginx_counters 1 fbi_unibi.pg_catalog.pg_shdepend 1 zemm_produktiv_7.public.breedings 1 zemm_produktiv_7.public.scoresheet_answer 1 zemm_produktiv_8.public.tasks 1 zemm_produktiv_7.public.breedingssires 1 zemm_produktiv_7.public.question 1 zemm_produktiv_7.public.targetgroups 1 zemm_produktiv_7.public.user_ui_prefs 1 zemm_produktiv_7.public.stresslevel_response 1 zemm_produktiv_7.public.license_history 1 zemm_produktiv_7.public.fem_numbers 1 zemm_produktiv_7.public.targetgroupMembers 1 zemm_produktiv_7.public.tasks_changes 1 zemm_produktiv_7.public.animals_search_mview 1 zemm_produktiv_7.public.scoresheet_diary 1 zemm_produktiv_7.pg_catalog.pg_constraint 1 zemm_produktiv_7.public.choice 1 zemm_produktiv_8.pg_catalog.pg_shdepend 1 zemm_produktiv_7.public.strains 1 zemm_produktiv_7.public.roles_users 1 zemm_test_2.pg_catalog.pg_shdepend 1 zemm_produktiv_7.public.litters 1 zemm_produktiv_7.pg_catalog.pg_attrdef 1 zemm_produktiv_7.public.litters_search_mview 1 zemm_produktiv_7.public.users 1 zemm_produktiv_7.public.sys_screens 1 zemm_produktiv_7.public.groups 1 invdb.pg_catalog.pg_shdepend 1 zemm_produktiv_7.public.tmptasks 1 zemm_produktiv_7.public.sys_actions 1 zemm_produktiv_7.public.breedingsdams 1 zemm_produktiv_7.public.cost_history 1 zemm_produktiv_7.public.cages_search_mview 1 zemm_produktiv_7.public.licenses 1 zemm_produktiv_7.public.groupMembers 1 zemm_produktiv_7.public.litter_history 1 zemm_monitoring.observability.phpfpm_counters 1 zemm_produktiv_7.pg_catalog.pg_index 1 zemm_produktiv_7.public.animals 1 zemm_produktiv_7.pg_catalog.pg_proc 1 zemm_produktiv_8.public.users 1 zemm_produktiv_7.public.locations 1 zemm_produktiv_7.public.cages 1 zemm_produktiv_7.public.documents 1 fbi_ci_db.pg_catalog.pg_shdepend 1 zemm_produktiv_7.public.tasks 1 zemm_produktiv_7.public.monitoring_session_activity 1 zemm_produktiv_7.pg_catalog.pg_trigger 1 zemm_produktiv_7.public.login_tracker 1 Total 213 Vacuums per table
Key values
- pg_catalog.pg_type (14) Main table vacuumed on database zemm_produktiv_8
- 125 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples zemm_produktiv_8.pg_catalog.pg_type 14 14 0 0 0 0 0 718 164 151,314 0 0 zemm_produktiv_8.public.breedingsdams 13 0 0 0 0 0 0 2,561 52 159,679 0 0 zemm_produktiv_8.public.breedingssires 13 0 0 0 0 0 0 1,911 52 121,329 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 10 10 0 0 0 0 0 1,400 473 304,581 0 0 zemm_monitoring.pg_toast.pg_toast_67431 9 0 0 0 0 0 0 4,019 1,367 3,089,878 1,319 7,914 zemm_produktiv_8.pg_catalog.pg_class 7 7 0 0 0 0 0 690 222 267,733 0 0 zemm_produktiv_8.pg_catalog.pg_depend 5 5 0 0 0 0 0 614 192 205,615 0 0 zemm_test_3.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 350 92 180,377 0 0 zemm_produktiv_8.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 543 139 712,839 35 103 zemm_produktiv_7.pg_catalog.pg_depend 2 2 0 0 0 0 0 219 49 84,714 0 0 zemm_produktiv_7.pg_catalog.pg_statistic 2 2 0 0 0 0 0 390 17 51,153 4 22 zemm_produktiv_7.pg_catalog.pg_class 1 1 0 0 0 0 0 92 9 22,958 0 0 zemm_produktiv_7.public.strains 1 0 0 0 0 0 0 61 6 4,508 0 0 zemm_produktiv_7.public.tasks_changes 1 0 0 0 0 0 0 3,758 4 222,378 0 0 zemm_produktiv_7.pg_catalog.pg_constraint 1 1 0 0 0 0 0 70 8 17,800 0 0 zemm_produktiv_7.public.scoresheet_diary 1 0 0 0 0 0 0 10 4 1,246 0 0 zemm_produktiv_7.public.animals_search_mview 1 0 0 0 0 0 0 22,902 9 1,352,439 0 0 zemm_produktiv_7.public.license_history 1 0 0 0 0 0 0 173 6 11,030 0 0 zemm_produktiv_7.public.targetgroupMembers 1 0 0 0 0 0 0 42,062 5 2,482,383 0 0 zemm_produktiv_7.public.fem_numbers 1 0 0 0 0 0 0 997 4 59,484 0 0 zemm_produktiv_7.public.users 1 0 0 0 0 0 0 65 6 4,760 0 0 zemm_produktiv_7.public.litters_search_mview 1 0 0 0 0 0 0 2,491 4 147,625 0 0 zemm_produktiv_7.pg_catalog.pg_attrdef 1 1 0 0 0 0 0 28 3 2,963 0 0 zemm_produktiv_7.public.litters 1 0 0 0 0 0 0 1,081 4 64,435 0 0 zemm_monitoring.observability.db_top_queries 1 0 0 0 0 0 0 74,513 43,764 159,684,052 15,374 149,088 zemm_produktiv_8.public.tmptasks 1 1 0 0 0 0 0 74 29 20,140 0 0 zemm_produktiv_7.pg_catalog.pg_sequence 1 1 0 0 0 0 0 13 5 3,620 0 0 zemm_produktiv_7.public.taskattachment 1 0 0 0 0 0 0 297 6 18,750 0 0 zemm_produktiv_7.public.diary 1 0 0 0 0 0 0 31,637 11 1,868,030 0 0 zemm_produktiv_7.public.user_ui_prefs 1 0 0 0 0 0 0 116 6 8,015 0 0 zemm_monitoring.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 82 19 122,773 4 16 zemm_produktiv_7.public.stresslevel_response 1 0 0 0 0 0 0 16 6 1,755 0 0 zemm_produktiv_7.public.targetgroups 1 0 0 0 0 0 0 16,081 7 949,774 0 0 zemm_produktiv_7.public.breedingssires 1 0 0 0 0 0 0 151 6 9,732 0 0 zemm_produktiv_7.public.scoresheet_answer 1 0 0 0 0 0 0 36 6 2,968 0 0 zemm_produktiv_8.public.tasks 1 1 0 0 0 0 0 39,643 61 2,905,124 0 0 zemm_produktiv_7.pg_catalog.pg_type 1 1 0 0 0 0 0 42 4 8,552 0 0 zemm_produktiv_7.public.breedings 1 0 0 0 0 0 0 225 6 14,373 0 0 zemm_produktiv_7.public.cages 1 0 0 0 0 0 0 185 6 11,987 0 0 zemm_produktiv_7.public.login_tracker 1 0 0 0 0 0 0 3,251 4 192,465 0 0 zemm_produktiv_7.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 288 11 72,087 0 0 zemm_produktiv_7.public.monitoring_session_activity 1 0 0 0 0 0 0 1,045 4 62,311 0 0 zemm_produktiv_7.pg_catalog.pg_trigger 1 1 0 0 0 0 0 44 6 10,966 0 0 zemm_produktiv_7.public.tasks 1 0 0 0 0 0 0 8,628 6 509,934 0 0 zemm_produktiv_7.pg_catalog.pg_attribute 1 1 0 0 0 0 0 459 11 68,793 0 0 zemm_produktiv_7.public.cages_search_mview 1 0 0 0 0 0 0 209 6 13,446 0 0 zemm_produktiv_7.public.breedingsdams 1 0 0 0 0 0 0 201 6 12,682 0 0 zemm_produktiv_7.public.cost_history 1 0 0 0 0 0 0 9,309 6 550,113 0 0 zemm_produktiv_7.public.tmptasks 1 0 0 0 0 0 0 107 6 7,324 0 0 zemm_produktiv_8.public.users 1 1 0 0 0 0 0 213 98 231,739 57 223 zemm_produktiv_7.public.animals 1 0 0 0 0 0 0 15,891 7 938,564 0 0 zemm_produktiv_7.public.litter_history 1 0 0 0 0 0 0 1,674 4 99,422 0 0 zemm_produktiv_7.pg_catalog.pg_index 1 1 0 0 0 0 0 36 3 4,580 0 0 zemm_produktiv_7.public.groupMembers 1 0 0 0 0 0 0 9 4 1,187 0 0 Total 125 60 0 0 0 0 0 291,680 47,015 178,128,479 16,793 157,366 Vacuum throughput per table
Key values
- observability.db_top_queries (11.1) Max CPU elapsed for vacuum on database zemm_monitoring
- observability.db_top_queries (2.848 ms) Max I/O read time for vacuum on database zemm_monitoring
- public.targetgroupMembers (0.383 ms) Max I/O write time for vacuum on database zemm_monitoring
I/O timing (ms) CPU (s) Table read write elapsed zemm_produktiv_8.pg_catalog.pg_type 0 0 0 zemm_produktiv_8.public.breedingsdams 0 0.208 0 zemm_produktiv_8.public.breedingssires 0 0.293 0 zemm_produktiv_8.pg_catalog.pg_attribute 0 0 0.1 zemm_monitoring.pg_toast.pg_toast_67431 0 0 0.27 zemm_produktiv_8.pg_catalog.pg_class 0 0 0.01 zemm_produktiv_8.pg_catalog.pg_depend 0 0 0.04 zemm_test_3.pg_catalog.pg_shdepend 0 0 0.01 zemm_produktiv_8.pg_toast.pg_toast_2619 0 0 0.03 zemm_produktiv_7.pg_catalog.pg_depend 0 0.076 0.01 zemm_produktiv_7.pg_catalog.pg_statistic 0 0.039 0 zemm_produktiv_7.pg_catalog.pg_class 0 0 0 zemm_produktiv_7.public.strains 0.034 0.036 0 zemm_produktiv_7.public.tasks_changes 0.046 0.034 0.47 zemm_produktiv_7.pg_catalog.pg_constraint 0 0 0 zemm_produktiv_7.public.scoresheet_diary 0 0.047 0 zemm_produktiv_7.public.animals_search_mview 0.062 0.209 4.87 zemm_produktiv_7.public.license_history 0 0.042 0.01 zemm_produktiv_7.public.targetgroupMembers 0 0.383 10.31 zemm_produktiv_7.public.fem_numbers 0.026 0.034 0.02 zemm_produktiv_7.public.users 0 0.048 0.01 zemm_produktiv_7.public.litters_search_mview 0.039 0.038 0.16 zemm_produktiv_7.pg_catalog.pg_attrdef 0 0.019 0 zemm_produktiv_7.public.litters 0 0.036 0.02 zemm_monitoring.observability.db_top_queries 2.848 0.046 11.1 zemm_produktiv_8.public.tmptasks 0 0 0.01 zemm_produktiv_7.pg_catalog.pg_sequence 0 0.021 0 zemm_produktiv_7.public.taskattachment 0.015 0.034 0.01 zemm_produktiv_7.public.diary 0 0.242 7.21 zemm_produktiv_7.public.user_ui_prefs 0 0.035 0.01 zemm_monitoring.pg_toast.pg_toast_2619 0 0 0 zemm_produktiv_7.public.stresslevel_response 0 0.056 0 zemm_produktiv_7.public.targetgroups 0 0.108 3.41 zemm_produktiv_7.public.breedingssires 0 0.037 0 zemm_produktiv_7.public.scoresheet_answer 0 0.049 0 zemm_produktiv_8.public.tasks 0 0 0.55 zemm_produktiv_7.pg_catalog.pg_type 0 0 0 zemm_produktiv_7.public.breedings 0 0.034 0.01 zemm_produktiv_7.public.cages 0 0.034 0.01 zemm_produktiv_7.public.login_tracker 0 0.035 0.07 zemm_produktiv_7.pg_toast.pg_toast_2619 0 0 0 zemm_produktiv_7.public.monitoring_session_activity 0.031 0.041 0.02 zemm_produktiv_7.pg_catalog.pg_trigger 0 0.016 0 zemm_produktiv_7.public.tasks 0 0.102 1.56 zemm_produktiv_7.pg_catalog.pg_attribute 0 0 0.01 zemm_produktiv_7.public.cages_search_mview 0.032 0.036 0.01 zemm_produktiv_7.public.breedingsdams 0 0.037 0.01 zemm_produktiv_7.public.cost_history 0 0.098 1.75 zemm_produktiv_7.public.tmptasks 0.014 0.036 0 zemm_produktiv_8.public.users 0 0 0.02 zemm_produktiv_7.public.animals 0 0.127 3.25 zemm_produktiv_7.public.litter_history 0 0.05 0.04 zemm_produktiv_7.pg_catalog.pg_index 0 0 0 zemm_produktiv_7.public.groupMembers 0 0.046 0 Total 3.147 2.862 45.4 Tuples removed per table
Key values
- public.tasks (53163) Main table with removed tuples on database zemm_produktiv_8
- 82893 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain zemm_produktiv_8.public.tasks 1 1 53,163 56,181 0 0 16,512 zemm_produktiv_8.pg_catalog.pg_attribute 10 10 10,485 56,117 0 0 1,840 zemm_produktiv_8.pg_catalog.pg_depend 5 5 4,323 20,855 0 0 275 zemm_produktiv_7.pg_catalog.pg_attribute 1 1 3,864 6,455 0 0 182 zemm_produktiv_8.pg_catalog.pg_type 14 14 2,800 11,634 0 0 434 zemm_produktiv_7.pg_catalog.pg_depend 2 2 2,507 8,342 0 3 81 zemm_test_3.pg_catalog.pg_shdepend 4 4 1,730 15,370 0 0 152 zemm_produktiv_8.pg_catalog.pg_class 7 7 1,035 6,258 0 0 294 zemm_produktiv_7.pg_catalog.pg_statistic 2 2 835 1,512 0 0 191 zemm_produktiv_7.pg_catalog.pg_constraint 1 1 411 605 0 0 24 zemm_produktiv_7.pg_toast.pg_toast_2619 1 1 316 287 0 0 129 zemm_produktiv_8.pg_toast.pg_toast_2619 3 3 301 876 0 0 318 zemm_produktiv_7.pg_catalog.pg_trigger 1 1 294 323 0 0 14 zemm_produktiv_7.pg_catalog.pg_type 1 1 234 831 0 0 27 zemm_produktiv_7.pg_catalog.pg_index 1 1 208 388 0 0 14 zemm_produktiv_8.public.users 1 1 168 742 0 0 108 zemm_produktiv_7.pg_catalog.pg_sequence 1 1 105 88 0 0 3 zemm_produktiv_8.public.tmptasks 1 1 68 818 0 18 99 zemm_monitoring.pg_toast.pg_toast_2619 1 1 46 63 0 0 30 zemm_monitoring.pg_toast.pg_toast_67431 9 0 0 858,252 0 0 143,642 zemm_produktiv_7.pg_catalog.pg_class 1 1 0 894 0 0 39 zemm_produktiv_7.public.strains 1 0 0 2,260 0 11 53 zemm_produktiv_7.public.tasks_changes 1 0 0 345,897 0 0 3,800 zemm_produktiv_7.public.scoresheet_diary 1 0 0 1,057 0 0 6 zemm_produktiv_7.public.animals_search_mview 1 0 0 604,376 0 0 22,912 zemm_produktiv_7.public.license_history 1 0 0 22,337 0 27 165 zemm_produktiv_7.public.targetgroupMembers 1 0 0 6,602,979 0 0 42,096 zemm_produktiv_7.public.fem_numbers 1 0 0 119,042 0 0 1,032 zemm_produktiv_7.public.users 1 0 0 742 0 7 57 zemm_produktiv_7.public.litters_search_mview 1 0 0 93,436 0 0 2,512 zemm_produktiv_7.pg_catalog.pg_attrdef 1 1 0 143 0 0 15 zemm_produktiv_7.public.litters 1 0 0 93,434 0 0 1,104 zemm_monitoring.observability.db_top_queries 1 0 0 2,813,086 0 0 286,271 zemm_produktiv_7.public.taskattachment 1 0 0 16,558 0 55 289 zemm_produktiv_7.public.diary 1 0 0 2,215,111 0 0 31,648 zemm_produktiv_7.public.user_ui_prefs 1 0 0 740 0 30 106 zemm_produktiv_7.public.stresslevel_response 1 0 0 1,663 0 2 8 zemm_produktiv_7.public.targetgroups 1 0 0 2,290,118 0 0 16,128 zemm_produktiv_7.public.breedingssires 1 0 0 22,358 0 33 143 zemm_produktiv_7.public.scoresheet_answer 1 0 0 3,387 0 4 28 zemm_produktiv_7.public.breedings 1 0 0 22,346 0 55 217 zemm_produktiv_8.public.breedingsdams 13 0 0 392,725 0 0 2,509 zemm_produktiv_7.public.cages 1 0 0 13,626 0 47 177 zemm_produktiv_7.public.login_tracker 1 0 0 87,565 0 0 3,272 zemm_produktiv_7.public.monitoring_session_activity 1 0 0 87,565 0 0 1,096 zemm_produktiv_7.public.tasks 1 0 0 56,192 0 0 8,656 zemm_produktiv_7.public.cages_search_mview 1 0 0 13,629 0 47 201 zemm_produktiv_7.public.breedingsdams 1 0 0 30,217 0 47 193 zemm_produktiv_7.public.cost_history 1 0 0 721,623 0 0 9,328 zemm_produktiv_7.public.tmptasks 1 0 0 1,002 0 45 99 zemm_produktiv_8.public.breedingssires 13 0 0 290,588 0 0 1,859 zemm_produktiv_7.public.animals 1 0 0 604,376 0 0 15,904 zemm_produktiv_7.public.litter_history 1 0 0 180,823 0 0 1,680 zemm_produktiv_7.public.groupMembers 1 0 0 761 0 0 5 Total 125 60 82,893 18,798,653 0 431 617,977 Pages removed per table
Key values
- public.taskattachment (55) Main table with removed pages on database zemm_produktiv_7
- 431 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed zemm_produktiv_7.public.taskattachment 1 0 0 55 zemm_produktiv_7.public.breedings 1 0 0 55 zemm_produktiv_7.public.cages 1 0 0 47 zemm_produktiv_7.public.cages_search_mview 1 0 0 47 zemm_produktiv_7.public.breedingsdams 1 0 0 47 zemm_produktiv_7.public.tmptasks 1 0 0 45 zemm_produktiv_7.public.breedingssires 1 0 0 33 zemm_produktiv_7.public.user_ui_prefs 1 0 0 30 zemm_produktiv_7.public.license_history 1 0 0 27 zemm_produktiv_8.public.tmptasks 1 1 68 18 zemm_produktiv_7.public.strains 1 0 0 11 zemm_produktiv_7.public.users 1 0 0 7 zemm_produktiv_7.public.scoresheet_answer 1 0 0 4 zemm_produktiv_7.pg_catalog.pg_depend 2 2 2507 3 zemm_produktiv_7.public.stresslevel_response 1 0 0 2 zemm_monitoring.pg_toast.pg_toast_67431 9 0 0 0 zemm_produktiv_7.pg_catalog.pg_class 1 1 0 0 zemm_produktiv_7.public.tasks_changes 1 0 0 0 zemm_produktiv_7.pg_catalog.pg_constraint 1 1 411 0 zemm_produktiv_7.public.scoresheet_diary 1 0 0 0 zemm_produktiv_7.public.animals_search_mview 1 0 0 0 zemm_test_3.pg_catalog.pg_shdepend 4 4 1730 0 zemm_produktiv_7.public.targetgroupMembers 1 0 0 0 zemm_produktiv_7.public.fem_numbers 1 0 0 0 zemm_produktiv_7.public.litters_search_mview 1 0 0 0 zemm_produktiv_7.pg_catalog.pg_attrdef 1 1 0 0 zemm_produktiv_7.public.litters 1 0 0 0 zemm_monitoring.observability.db_top_queries 1 0 0 0 zemm_produktiv_7.pg_catalog.pg_sequence 1 1 105 0 zemm_produktiv_7.public.diary 1 0 0 0 zemm_monitoring.pg_toast.pg_toast_2619 1 1 46 0 zemm_produktiv_8.pg_toast.pg_toast_2619 3 3 301 0 zemm_produktiv_8.pg_catalog.pg_class 7 7 1035 0 zemm_produktiv_7.public.targetgroups 1 0 0 0 zemm_produktiv_7.pg_catalog.pg_statistic 2 2 835 0 zemm_produktiv_8.public.tasks 1 1 53163 0 zemm_produktiv_7.pg_catalog.pg_type 1 1 234 0 zemm_produktiv_8.public.breedingsdams 13 0 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 10 10 10485 0 zemm_produktiv_7.public.login_tracker 1 0 0 0 zemm_produktiv_7.pg_toast.pg_toast_2619 1 1 316 0 zemm_produktiv_7.public.monitoring_session_activity 1 0 0 0 zemm_produktiv_7.pg_catalog.pg_trigger 1 1 294 0 zemm_produktiv_8.pg_catalog.pg_depend 5 5 4323 0 zemm_produktiv_7.public.tasks 1 0 0 0 zemm_produktiv_7.pg_catalog.pg_attribute 1 1 3864 0 zemm_produktiv_7.public.cost_history 1 0 0 0 zemm_produktiv_8.public.breedingssires 13 0 0 0 zemm_produktiv_8.public.users 1 1 168 0 zemm_produktiv_7.public.animals 1 0 0 0 zemm_produktiv_7.public.litter_history 1 0 0 0 zemm_produktiv_7.pg_catalog.pg_index 1 1 208 0 zemm_produktiv_8.pg_catalog.pg_type 14 14 2800 0 zemm_produktiv_7.public.groupMembers 1 0 0 0 Total 125 60 82,893 431 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Mar 12 00 0 0 01 2 1 02 0 0 03 0 0 04 1 0 05 0 0 06 3 4 07 5 16 08 5 8 09 9 19 10 4 14 11 8 16 12 4 8 13 27 47 14 4 12 15 45 55 16 1 0 17 3 4 18 0 1 19 2 1 20 1 3 21 1 0 22 0 0 23 0 4 - 11.10 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessShareLock Main Lock Type
- 1 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 22s938ms 22s938ms 22s938ms 22s938ms select queryid::text as fingerprint, query as query, mean_exec_time as mean_time_ms, total_exec_time as total_time_ms, calls, rows as rows_returned from pg_stat_statements where dbid = ( select oid from pg_database where datname = current_database()) order by total_exec_time desc limit ?;-
SELECT queryid::text AS fingerprint, query AS query, mean_exec_time AS mean_time_ms, total_exec_time AS total_time_ms, calls, rows AS rows_returned FROM pg_stat_statements WHERE dbid = ( SELECT oid FROM pg_database WHERE datname = current_database()) ORDER BY total_exec_time DESC LIMIT 50;
Date: 2026-03-12 15:13:25 Database: zemm_produktiv_7 User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
Queries that waited the most
Rank Wait time Query 1 22s938ms SELECT queryid::text AS fingerprint, query AS query, mean_exec_time AS mean_time_ms, total_exec_time AS total_time_ms, calls, rows AS rows_returned FROM pg_stat_statements WHERE dbid = ( SELECT oid FROM pg_database WHERE datname = current_database()) ORDER BY total_exec_time DESC LIMIT 50;[ Date: 2026-03-12 15:13:25 - Database: zemm_produktiv_7 - User: labanimal ]
-
Queries
Queries by type
Key values
- 92 Total read queries
- 18,741 Total write queries
Queries by database
Key values
- zemm_monitoring Main database
- 17,280 Requests
- 5h15m11s (zemm_monitoring)
- Main time consuming database
Queries by user
Key values
- labanimal Main user
- 106,706 Requests
User Request type Count Duration labanimal Total 106,706 1d20h3m59s copy from 7 15s665ms copy to 68 3m17s cte 101 1m54s ddl 105,913 1d19h42m57s others 168 3m4s select 431 12m7s update 5 5s544ms postgres Total 3,556 1h2m23s copy from 19 54s373ms copy to 95 3m8s cte 5 10s291ms ddl 2,728 45m51s others 679 11m32s update 1 599ms Duration by user
Key values
- 1d20h3m59s (labanimal) Main time consuming user
User Request type Count Duration labanimal Total 106,706 1d20h3m59s copy from 7 15s665ms copy to 68 3m17s cte 101 1m54s ddl 105,913 1d19h42m57s others 168 3m4s select 431 12m7s update 5 5s544ms postgres Total 3,556 1h2m23s copy from 19 54s373ms copy to 95 3m8s cte 5 10s291ms ddl 2,728 45m51s others 679 11m32s update 1 599ms Queries by host
Key values
- unknown Main host
- 106,699 Requests
- 1d20h54s (unknown)
- Main time consuming host
Host Request type Count Duration 81.169.238.237 Total 7 3m4s select 2 2m59s update 5 5s544ms [local] Total 3,556 1h2m23s copy from 19 54s373ms copy to 95 3m8s cte 5 10s291ms ddl 2,728 45m51s others 679 11m32s update 1 599ms unknown Total 106,699 1d20h54s copy from 7 15s665ms copy to 68 3m17s cte 101 1m54s ddl 105,913 1d19h42m57s others 168 3m4s select 429 9m8s Queries by application
Key values
- unknown Main application
- 17,280 Requests
- 5h15m11s (unknown)
- Main time consuming application
Application Request type Count Duration _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b Total 2 1s374ms select 2 1s374ms _desktop_index.php_zemm_produktiv_7_localhost_5432 Total 15 12s180ms cte 15 12s180ms _desktop_index.php_zemm_produktiv_8_localhost_5432 Total 94 1m23s cte 4 7s130ms select 90 1m16s expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 Total 1 772ms update 1 772ms pg_dump Total 41 1m41s copy to 41 1m41s pg_restore Total 1,575 29m25s copy from 7 15s665ms ddl 1,393 25m54s others 164 3m1s unknown Total 17,280 5h15m11s ddl 17,280 5h15m11s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-03-12 16:37:01 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 110 500-1000ms duration
Slowest individual queries
Rank Duration Query 1 22s939ms CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-03-12 15:14:01 - Database: zemm_monitoring - User: labanimal ]
2 22s939ms 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-12 15:14:01 - Database: zemm_monitoring - User: labanimal ]
3 22s939ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-03-12 15:14:01 - Database: zemm_monitoring - User: labanimal ]
4 22s939ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-03-12 15:14:01 - Database: zemm_monitoring - User: labanimal ]
5 22s939ms 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-12 15:14:01 - Database: zemm_monitoring - User: labanimal ]
6 22s939ms CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);[ Date: 2026-03-12 15:14:01 - Database: zemm_monitoring - User: labanimal ]
7 22s939ms CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);[ Date: 2026-03-12 15:14:01 - Database: zemm_monitoring - User: labanimal ]
8 22s939ms 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-12 15:14:01 - Database: zemm_monitoring - User: labanimal ]
9 22s939ms CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);[ Date: 2026-03-12 15:14:01 - Database: zemm_monitoring - User: labanimal ]
10 22s939ms 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-12 15:14:01 - Database: zemm_monitoring - User: labanimal ]
11 22s939ms 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-12 15:14:01 - Database: zemm_monitoring - User: labanimal ]
12 22s939ms 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-12 15:14:01 - Database: zemm_monitoring - User: labanimal ]
13 22s939ms CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-03-12 15:15:01 - Database: zemm_monitoring - User: labanimal ]
14 22s939ms 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-12 15:15:01 - Database: zemm_monitoring - User: labanimal ]
15 22s939ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-03-12 15:15:01 - Database: zemm_monitoring - User: labanimal ]
16 22s939ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-03-12 15:15:01 - Database: zemm_monitoring - User: labanimal ]
17 22s939ms 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-12 15:15:01 - Database: zemm_monitoring - User: labanimal ]
18 22s939ms CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);[ Date: 2026-03-12 15:15:01 - Database: zemm_monitoring - User: labanimal ]
19 22s939ms CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);[ Date: 2026-03-12 15:15:01 - Database: zemm_monitoring - User: labanimal ]
20 22s939ms 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-12 15:15:01 - Database: zemm_monitoring - User: labanimal ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 26m15s 1,440 541ms 22s939ms 1s94ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
2 26m15s 1,440 541ms 22s939ms 1s94ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
3 26m15s 1,440 541ms 22s939ms 1s94ms 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 #3
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
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-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
4 26m15s 1,440 541ms 22s939ms 1s94ms 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 #4
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
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-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
5 26m15s 1,440 541ms 22s939ms 1s94ms 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 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
6 26m15s 1,440 541ms 22s939ms 1s94ms 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 #6
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
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-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
7 26m15s 1,440 541ms 22s939ms 1s94ms 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 #7
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
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-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
8 26m15s 1,440 541ms 22s939ms 1s94ms 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 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
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-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
9 26m15s 1,440 541ms 22s939ms 1s94ms 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 #9
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
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-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
10 26m15s 1,440 541ms 22s939ms 1s94ms 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 #10
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
11 26m15s 1,440 541ms 22s939ms 1s94ms create schema if not exists observability;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
12 26m15s 1,440 541ms 22s939ms 1s94ms 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 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
13 29s378ms 6 1s323ms 6s692ms 4s896ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 12 09 2 8s12ms 4s6ms 15 3 20s43ms 6s681ms 23 1 1s323ms 1s323ms [ User: labanimal - Total duration: 26s732ms - Times executed: 4 ]
[ User: postgres - Total duration: 2s646ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 29s378ms - Times executed: 6 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-12 15:12:16 Duration: 6s692ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-12 09:33:41 Duration: 6s688ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-12 15:12:43 Duration: 6s687ms Database: zemm_produktiv_7 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
14 22s255ms 6 1s287ms 4s937ms 3s709ms copy public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 12 09 2 6s217ms 3s108ms 15 3 14s739ms 4s913ms 23 1 1s299ms 1s299ms [ User: labanimal - Total duration: 19s669ms - Times executed: 4 ]
[ User: postgres - Total duration: 2s586ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 22s255ms - Times executed: 6 ]
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-12 15:12:02 Duration: 4s937ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 09:33:27 Duration: 4s929ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:12:29 Duration: 4s910ms Database: zemm_produktiv_7 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
15 19s962ms 29 674ms 743ms 688ms select count(distinct animal_id) AS "count" from ( select animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, ?) as is_owner, user_is_tgm (animals_search_mview.editor, ?) as is_editor, user_is_tgm (animals_search_mview.tourist, ?) as is_tourist, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join animals a on a."animalID" = animals_search_mview.animal_id left join breedings b on b.id = animals_search_mview.last_mating) data where fate = ? and alive = ? and deleted = ? and (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 12 09 5 3s514ms 702ms 11 5 3s418ms 683ms 12 4 2s789ms 697ms 13 2 1s374ms 687ms 14 2 1s367ms 683ms 15 6 4s73ms 678ms 17 1 701ms 701ms 21 2 1s355ms 677ms 22 2 1s368ms 684ms [ User: labanimal - Total duration: 19s962ms - Times executed: 29 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 19s263ms - Times executed: 28 ]
[ Application: _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b - Total duration: 698ms - Times executed: 1 ]
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 478) AS is_owner, user_is_tgm (animals_search_mview.editor, 478) AS is_editor, user_is_tgm (animals_search_mview.tourist, 478) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-12 09:42:42 Duration: 743ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 478) AS is_owner, user_is_tgm (animals_search_mview.editor, 478) AS is_editor, user_is_tgm (animals_search_mview.tourist, 478) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-12 09:40:21 Duration: 709ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-12 12:44:26 Duration: 708ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
16 17s592ms 6 1s973ms 3s580ms 2s932ms 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 #16
Day Hour Count Duration Avg duration Mar 12 09 2 5s354ms 2s677ms 15 3 10s263ms 3s421ms 23 1 1s973ms 1s973ms [ User: labanimal - Total duration: 13s644ms - Times executed: 4 ]
[ User: postgres - Total duration: 3s948ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 17s592ms - Times executed: 6 ]
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-12 15:12:07 Duration: 3s580ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 09:33:32 Duration: 3s380ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:10:03 Duration: 3s358ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
17 17s365ms 27 629ms 684ms 643ms select distinct * from ( select animals_search_mview.*, b.unbreeding_date, fates.loc as fate_name, user_is_tgm (animals_search_mview.owner, ?) as is_owner, user_is_tgm (animals_search_mview.editor, ?) as is_editor, user_is_tgm (animals_search_mview.tourist, ?) as is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, string_agg(l."application_id" || ? || l."title" || ? || date(lh."timestamp")::varchar, ?) as licensehistory, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview inner join fates on fates.id = animals_search_mview.fate left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join licenses l on l.id = lh.licid left join breedings b on b.id = animals_search_mview.last_mating group by animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data where data.fate = ? and data.alive = ? and data.deleted = ? and (is_owner or is_editor or is_tourist) and (data.straindeleted = ? or data.straindeleted is null) order by data.cage_name, data.animal_id, data.name;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 12 09 3 1s969ms 656ms 11 5 3s196ms 639ms 12 4 2s629ms 657ms 13 2 1s287ms 643ms 14 2 1s277ms 638ms 15 6 3s812ms 635ms 17 1 659ms 659ms 21 2 1s265ms 632ms 22 2 1s268ms 634ms [ User: labanimal - Total duration: 17s365ms - Times executed: 27 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 16s690ms - Times executed: 26 ]
[ Application: _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b - Total duration: 675ms - Times executed: 1 ]
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 478) AS is_owner, user_is_tgm (animals_search_mview.editor, 478) AS is_editor, user_is_tgm (animals_search_mview.tourist, 478) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-12 09:42:43 Duration: 684ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-12 12:46:06 Duration: 675ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-12 12:44:26 Duration: 665ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
18 14s735ms 6 1s213ms 3s149ms 2s455ms 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 12 09 2 4s271ms 2s135ms 15 3 9s232ms 3s77ms 23 1 1s231ms 1s231ms [ User: labanimal - Total duration: 12s291ms - Times executed: 4 ]
[ User: postgres - Total duration: 2s444ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 14s735ms - Times executed: 6 ]
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-12 15:11:57 Duration: 3s149ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 09:33:22 Duration: 3s58ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:09:53 Duration: 3s46ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
19 14s500ms 4 3s603ms 3s643ms 3s625ms select * from litters_search_mview l where not (deleted) and case when user_is_tgm (l.owner, ?) then true when user_is_tgm (l.editor, ?) then true when user_is_tgm (l.tourist, ?) then true else false end and (offspring - case when male_wean is null then ? else male_wean end - case when female_wean is null then ? else female_wean end - case when male_dead is null then ? else male_dead end - case when female_dead is null then ? else female_dead end - case when female_deceased is null then ? else female_deceased end - case when male_deceased is null then ? else male_deceased end) <= ? order by bday desc, dam_name, sire_name;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 12 20 4 14s500ms 3s625ms [ User: labanimal - Total duration: 14s500ms - Times executed: 4 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 14s500ms - Times executed: 4 ]
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) <= 0 ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-12 20:38:24 Duration: 3s643ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) <= 0 ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-12 20:41:17 Duration: 3s639ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) <= 0 ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-12 20:38:28 Duration: 3s614ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
20 14s498ms 16 790ms 2s317ms 906ms 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 #20
Day Hour Count Duration Avg duration Mar 12 09 1 811ms 811ms 10 2 1s604ms 802ms 11 1 2s317ms 2s317ms 12 1 802ms 802ms 13 3 2s431ms 810ms 14 2 1s608ms 804ms 16 2 1s690ms 845ms 17 3 2s425ms 808ms 18 1 805ms 805ms [ User: labanimal - Total duration: 14s498ms - Times executed: 16 ]
[ Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 - Total duration: 12s180ms - Times executed: 15 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 2s317ms - 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-12 11:28:13 Duration: 2s317ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 16:17:41 Duration: 868ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 13:08:56 Duration: 823ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,440 26m15s 541ms 22s939ms 1s94ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
2 1,440 26m15s 541ms 22s939ms 1s94ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
3 1,440 26m15s 541ms 22s939ms 1s94ms 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 #3
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
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-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
4 1,440 26m15s 541ms 22s939ms 1s94ms 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 #4
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
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-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
5 1,440 26m15s 541ms 22s939ms 1s94ms 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 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
6 1,440 26m15s 541ms 22s939ms 1s94ms 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 #6
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
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-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
7 1,440 26m15s 541ms 22s939ms 1s94ms 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 #7
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
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-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
8 1,440 26m15s 541ms 22s939ms 1s94ms 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 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
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-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
9 1,440 26m15s 541ms 22s939ms 1s94ms 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 #9
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
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-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
10 1,440 26m15s 541ms 22s939ms 1s94ms 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 #10
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
11 1,440 26m15s 541ms 22s939ms 1s94ms create schema if not exists observability;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
12 1,440 26m15s 541ms 22s939ms 1s94ms 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 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
13 29 19s962ms 674ms 743ms 688ms select count(distinct animal_id) AS "count" from ( select animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, ?) as is_owner, user_is_tgm (animals_search_mview.editor, ?) as is_editor, user_is_tgm (animals_search_mview.tourist, ?) as is_tourist, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join animals a on a."animalID" = animals_search_mview.animal_id left join breedings b on b.id = animals_search_mview.last_mating) data where fate = ? and alive = ? and deleted = ? and (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 12 09 5 3s514ms 702ms 11 5 3s418ms 683ms 12 4 2s789ms 697ms 13 2 1s374ms 687ms 14 2 1s367ms 683ms 15 6 4s73ms 678ms 17 1 701ms 701ms 21 2 1s355ms 677ms 22 2 1s368ms 684ms [ User: labanimal - Total duration: 19s962ms - Times executed: 29 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 19s263ms - Times executed: 28 ]
[ Application: _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b - Total duration: 698ms - Times executed: 1 ]
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 478) AS is_owner, user_is_tgm (animals_search_mview.editor, 478) AS is_editor, user_is_tgm (animals_search_mview.tourist, 478) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-12 09:42:42 Duration: 743ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 478) AS is_owner, user_is_tgm (animals_search_mview.editor, 478) AS is_editor, user_is_tgm (animals_search_mview.tourist, 478) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-12 09:40:21 Duration: 709ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-12 12:44:26 Duration: 708ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
14 27 17s365ms 629ms 684ms 643ms select distinct * from ( select animals_search_mview.*, b.unbreeding_date, fates.loc as fate_name, user_is_tgm (animals_search_mview.owner, ?) as is_owner, user_is_tgm (animals_search_mview.editor, ?) as is_editor, user_is_tgm (animals_search_mview.tourist, ?) as is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, string_agg(l."application_id" || ? || l."title" || ? || date(lh."timestamp")::varchar, ?) as licensehistory, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview inner join fates on fates.id = animals_search_mview.fate left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join licenses l on l.id = lh.licid left join breedings b on b.id = animals_search_mview.last_mating group by animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data where data.fate = ? and data.alive = ? and data.deleted = ? and (is_owner or is_editor or is_tourist) and (data.straindeleted = ? or data.straindeleted is null) order by data.cage_name, data.animal_id, data.name;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 12 09 3 1s969ms 656ms 11 5 3s196ms 639ms 12 4 2s629ms 657ms 13 2 1s287ms 643ms 14 2 1s277ms 638ms 15 6 3s812ms 635ms 17 1 659ms 659ms 21 2 1s265ms 632ms 22 2 1s268ms 634ms [ User: labanimal - Total duration: 17s365ms - Times executed: 27 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 16s690ms - Times executed: 26 ]
[ Application: _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b - Total duration: 675ms - Times executed: 1 ]
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 478) AS is_owner, user_is_tgm (animals_search_mview.editor, 478) AS is_editor, user_is_tgm (animals_search_mview.tourist, 478) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-12 09:42:43 Duration: 684ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-12 12:46:06 Duration: 675ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, strains.deleted as straindeleted, STRING_AGG(l."application_id" || ':' || l."title" || ' - ' || Date(lh."timestamp")::varchar, '; ') AS licensehistory, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview INNER JOIN fates ON fates.id = animals_search_mview.fate LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN licenses l ON l.id = lh.licid left join breedings b ON b.id = animals_search_mview.last_mating GROUP BY animals_search_mview.id, b.unbreeding_date, fates.loc, strains.cancel_criteria, strains.symtoms, strains.reduce_severity_by, strains.sym_immune, straindeleted) data WHERE data.fate = 5 AND data.alive = 't' AND data.deleted = 'f' AND (is_owner OR is_editor OR is_tourist) and (data.straindeleted = 'f' or data.straindeleted is null) ORDER BY data.cage_name, data.animal_id, data.name;
Date: 2026-03-12 12:44:26 Duration: 665ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
15 16 14s498ms 790ms 2s317ms 906ms 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 #15
Day Hour Count Duration Avg duration Mar 12 09 1 811ms 811ms 10 2 1s604ms 802ms 11 1 2s317ms 2s317ms 12 1 802ms 802ms 13 3 2s431ms 810ms 14 2 1s608ms 804ms 16 2 1s690ms 845ms 17 3 2s425ms 808ms 18 1 805ms 805ms [ User: labanimal - Total duration: 14s498ms - Times executed: 16 ]
[ Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 - Total duration: 12s180ms - Times executed: 15 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 2s317ms - 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-12 11:28:13 Duration: 2s317ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 16:17:41 Duration: 868ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 13:08:56 Duration: 823ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
16 12 10s333ms 764ms 1s2ms 861ms select p_update_breedings (?, null, ?, ?::date, null, ?::text, ?::text, null) as id;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 12 09 2 1s713ms 856ms 10 1 935ms 935ms 11 1 1s2ms 1s2ms 13 8 6s682ms 835ms [ User: labanimal - Total duration: 10s333ms - Times executed: 12 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 10s333ms - Times executed: 12 ]
-
SELECT p_update_breedings (269, NULL, 7818, '2026-03-12'::date, NULL, '10293707'::text, '10279061;10279062'::text, NULL) AS id;
Date: 2026-03-12 11:51:52 Duration: 1s2ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
SELECT p_update_breedings (142, NULL, 12675, '2026-03-12'::date, NULL, '10285269'::text, '10285272'::text, NULL) AS id;
Date: 2026-03-12 13:34:23 Duration: 984ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
SELECT p_update_breedings (142, NULL, 2998, '2026-03-12'::date, NULL, '10290097'::text, '10290101'::text, NULL) AS id;
Date: 2026-03-12 13:37:38 Duration: 940ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
17 6 29s378ms 1s323ms 6s692ms 4s896ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 12 09 2 8s12ms 4s6ms 15 3 20s43ms 6s681ms 23 1 1s323ms 1s323ms [ User: labanimal - Total duration: 26s732ms - Times executed: 4 ]
[ User: postgres - Total duration: 2s646ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 29s378ms - Times executed: 6 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-12 15:12:16 Duration: 6s692ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-12 09:33:41 Duration: 6s688ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-12 15:12:43 Duration: 6s687ms Database: zemm_produktiv_7 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
18 6 22s255ms 1s287ms 4s937ms 3s709ms 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 #18
Day Hour Count Duration Avg duration Mar 12 09 2 6s217ms 3s108ms 15 3 14s739ms 4s913ms 23 1 1s299ms 1s299ms [ User: labanimal - Total duration: 19s669ms - Times executed: 4 ]
[ User: postgres - Total duration: 2s586ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 22s255ms - Times executed: 6 ]
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-12 15:12:02 Duration: 4s937ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 09:33:27 Duration: 4s929ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:12:29 Duration: 4s910ms Database: zemm_produktiv_7 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
19 6 17s592ms 1s973ms 3s580ms 2s932ms 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 #19
Day Hour Count Duration Avg duration Mar 12 09 2 5s354ms 2s677ms 15 3 10s263ms 3s421ms 23 1 1s973ms 1s973ms [ User: labanimal - Total duration: 13s644ms - Times executed: 4 ]
[ User: postgres - Total duration: 3s948ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 17s592ms - Times executed: 6 ]
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-12 15:12:07 Duration: 3s580ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 09:33:32 Duration: 3s380ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:10:03 Duration: 3s358ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
20 6 14s735ms 1s213ms 3s149ms 2s455ms 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 #20
Day Hour Count Duration Avg duration Mar 12 09 2 4s271ms 2s135ms 15 3 9s232ms 3s77ms 23 1 1s231ms 1s231ms [ User: labanimal - Total duration: 12s291ms - Times executed: 4 ]
[ User: postgres - Total duration: 2s444ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 14s735ms - Times executed: 6 ]
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-12 15:11:57 Duration: 3s149ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 09:33:22 Duration: 3s58ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:09:53 Duration: 3s46ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1s323ms 6s692ms 4s896ms 6 29s378ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 12 09 2 8s12ms 4s6ms 15 3 20s43ms 6s681ms 23 1 1s323ms 1s323ms [ User: labanimal - Total duration: 26s732ms - Times executed: 4 ]
[ User: postgres - Total duration: 2s646ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 29s378ms - Times executed: 6 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-12 15:12:16 Duration: 6s692ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-12 09:33:41 Duration: 6s688ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-03-12 15:12:43 Duration: 6s687ms Database: zemm_produktiv_7 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
2 1s287ms 4s937ms 3s709ms 6 22s255ms 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 #2
Day Hour Count Duration Avg duration Mar 12 09 2 6s217ms 3s108ms 15 3 14s739ms 4s913ms 23 1 1s299ms 1s299ms [ User: labanimal - Total duration: 19s669ms - Times executed: 4 ]
[ User: postgres - Total duration: 2s586ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 22s255ms - Times executed: 6 ]
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-03-12 15:12:02 Duration: 4s937ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 09:33:27 Duration: 4s929ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:12:29 Duration: 4s910ms Database: zemm_produktiv_7 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
3 3s603ms 3s643ms 3s625ms 4 14s500ms select * from litters_search_mview l where not (deleted) and case when user_is_tgm (l.owner, ?) then true when user_is_tgm (l.editor, ?) then true when user_is_tgm (l.tourist, ?) then true else false end and (offspring - case when male_wean is null then ? else male_wean end - case when female_wean is null then ? else female_wean end - case when male_dead is null then ? else male_dead end - case when female_dead is null then ? else female_dead end - case when female_deceased is null then ? else female_deceased end - case when male_deceased is null then ? else male_deceased end) <= ? order by bday desc, dam_name, sire_name;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 12 20 4 14s500ms 3s625ms [ User: labanimal - Total duration: 14s500ms - Times executed: 4 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 14s500ms - Times executed: 4 ]
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) <= 0 ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-12 20:38:24 Duration: 3s643ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) <= 0 ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-12 20:41:17 Duration: 3s639ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND CASE WHEN user_is_tgm (l.owner, 438) THEN TRUE WHEN user_is_tgm (l.editor, 438) THEN TRUE WHEN user_is_tgm (l.tourist, 438) THEN TRUE ELSE FALSE END AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) <= 0 ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-03-12 20:38:28 Duration: 3s614ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
4 1s973ms 3s580ms 2s932ms 6 17s592ms 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 #4
Day Hour Count Duration Avg duration Mar 12 09 2 5s354ms 2s677ms 15 3 10s263ms 3s421ms 23 1 1s973ms 1s973ms [ User: labanimal - Total duration: 13s644ms - Times executed: 4 ]
[ User: postgres - Total duration: 3s948ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 17s592ms - Times executed: 6 ]
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-03-12 15:12:07 Duration: 3s580ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 09:33:32 Duration: 3s380ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:10:03 Duration: 3s358ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
5 1s213ms 3s149ms 2s455ms 6 14s735ms 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 #5
Day Hour Count Duration Avg duration Mar 12 09 2 4s271ms 2s135ms 15 3 9s232ms 3s77ms 23 1 1s231ms 1s231ms [ User: labanimal - Total duration: 12s291ms - Times executed: 4 ]
[ User: postgres - Total duration: 2s444ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 14s735ms - Times executed: 6 ]
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-03-12 15:11:57 Duration: 3s149ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 09:33:22 Duration: 3s58ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:09:53 Duration: 3s46ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
6 541ms 22s939ms 1s94ms 1,440 26m15s create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
7 541ms 22s939ms 1s94ms 1,440 26m15s 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 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
8 541ms 22s939ms 1s94ms 1,440 26m15s 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 #8
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
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-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
9 541ms 22s939ms 1s94ms 1,440 26m15s 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 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
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-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
10 541ms 22s939ms 1s94ms 1,440 26m15s create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
11 541ms 22s939ms 1s94ms 1,440 26m15s 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 #11
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
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-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
12 541ms 22s939ms 1s94ms 1,440 26m15s 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 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
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-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
13 541ms 22s939ms 1s94ms 1,440 26m15s 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 #13
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
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-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
14 541ms 22s939ms 1s94ms 1,440 26m15s 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 #14
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
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-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
15 541ms 22s939ms 1s94ms 1,440 26m15s 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 #15
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-03-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
16 541ms 22s939ms 1s94ms 1,440 26m15s create schema if not exists observability;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
17 541ms 22s939ms 1s94ms 1,440 26m15s create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 12 00 60 0ms 0ms 01 60 22s389ms 373ms 02 60 46s322ms 772ms 03 60 46s322ms 772ms 04 60 46s322ms 772ms 05 60 46s322ms 772ms 06 60 46s322ms 772ms 07 60 46s322ms 772ms 08 60 48s703ms 811ms 09 60 59s334ms 988ms 10 60 48s844ms 814ms 11 60 1m20s 1s334ms 12 60 56s202ms 936ms 13 60 45s483ms 758ms 14 60 46s538ms 775ms 15 60 6m19s 6s321ms 16 60 47s665ms 794ms 17 60 44s156ms 735ms 18 60 48s283ms 804ms 19 60 48s307ms 805ms 20 60 1m47s 1s785ms 21 60 2m4s 2s67ms 22 60 37s823ms 630ms 23 60 53s771ms 896ms [ User: labanimal - Total duration: 26m15s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-12 15:28:01 Duration: 22s939ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-12 15:13:01 Duration: 4s364ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-12 20:41:01 Duration: 3s614ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
18 790ms 2s317ms 906ms 16 14s498ms 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 #18
Day Hour Count Duration Avg duration Mar 12 09 1 811ms 811ms 10 2 1s604ms 802ms 11 1 2s317ms 2s317ms 12 1 802ms 802ms 13 3 2s431ms 810ms 14 2 1s608ms 804ms 16 2 1s690ms 845ms 17 3 2s425ms 808ms 18 1 805ms 805ms [ User: labanimal - Total duration: 14s498ms - Times executed: 16 ]
[ Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 - Total duration: 12s180ms - Times executed: 15 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 2s317ms - 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-12 11:28:13 Duration: 2s317ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 16:17:41 Duration: 868ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_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-12 13:08:56 Duration: 823ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
19 764ms 1s2ms 861ms 12 10s333ms select p_update_breedings (?, null, ?, ?::date, null, ?::text, ?::text, null) as id;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 12 09 2 1s713ms 856ms 10 1 935ms 935ms 11 1 1s2ms 1s2ms 13 8 6s682ms 835ms [ User: labanimal - Total duration: 10s333ms - Times executed: 12 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 10s333ms - Times executed: 12 ]
-
SELECT p_update_breedings (269, NULL, 7818, '2026-03-12'::date, NULL, '10293707'::text, '10279061;10279062'::text, NULL) AS id;
Date: 2026-03-12 11:51:52 Duration: 1s2ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
SELECT p_update_breedings (142, NULL, 12675, '2026-03-12'::date, NULL, '10285269'::text, '10285272'::text, NULL) AS id;
Date: 2026-03-12 13:34:23 Duration: 984ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
SELECT p_update_breedings (142, NULL, 2998, '2026-03-12'::date, NULL, '10290097'::text, '10290101'::text, NULL) AS id;
Date: 2026-03-12 13:37:38 Duration: 940ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
20 674ms 743ms 688ms 29 19s962ms select count(distinct animal_id) AS "count" from ( select animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, ?) as is_owner, user_is_tgm (animals_search_mview.editor, ?) as is_editor, user_is_tgm (animals_search_mview.tourist, ?) as is_tourist, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join animals a on a."animalID" = animals_search_mview.animal_id left join breedings b on b.id = animals_search_mview.last_mating) data where fate = ? and alive = ? and deleted = ? and (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 12 09 5 3s514ms 702ms 11 5 3s418ms 683ms 12 4 2s789ms 697ms 13 2 1s374ms 687ms 14 2 1s367ms 683ms 15 6 4s73ms 678ms 17 1 701ms 701ms 21 2 1s355ms 677ms 22 2 1s368ms 684ms [ User: labanimal - Total duration: 19s962ms - Times executed: 29 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 19s263ms - Times executed: 28 ]
[ Application: _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b - Total duration: 698ms - Times executed: 1 ]
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 478) AS is_owner, user_is_tgm (animals_search_mview.editor, 478) AS is_editor, user_is_tgm (animals_search_mview.tourist, 478) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-12 09:42:42 Duration: 743ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 478) AS is_owner, user_is_tgm (animals_search_mview.editor, 478) AS is_editor, user_is_tgm (animals_search_mview.tourist, 478) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-12 09:40:21 Duration: 709ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 332) AS is_owner, user_is_tgm (animals_search_mview.editor, 332) AS is_editor, user_is_tgm (animals_search_mview.tourist, 332) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-03-12 12:44:26 Duration: 708ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-12_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
- 121,648 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 7 FATAL entries
- 15 ERROR entries
- 0 WARNING entries
- 39 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 38 Max number of times the same event was reported
- 61 Total events found
Rank Times reported Error 1 38 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 12 08 2 09 2 10 1 15 11 16 17 20 2 21 3 - FATAL: database "monitoring" does not exist
- FATAL: database "monitoring" does not exist
- FATAL: database "monitoring" does not exist
Date: 2026-03-12 08:24:50 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
Date: 2026-03-12 08:24:51 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
Date: 2026-03-12 09:19:04 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
2 8 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 12 10 4 13 4 - ERROR: relation "task" does not exist
- ERROR: relation "taskhistory" does not exist
- ERROR: relation "taskattachment_old" does not exist
Statement: select * from task where cast(row() as text) like '%895846823332f2631192128503fef565%' limit 1
Date: 2026-03-12 10:04:34 Database: zemm_produktiv_7 Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
Statement: select * from taskhistory where cast(row() as text) like '%895846823332f2631192128503fef565%' limit 1
Date: 2026-03-12 10:04:34 Database: zemm_produktiv_7 Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
Statement: select * from taskattachment_old where file_upload = '895846823332f2631192128503fef565' limit 5
Date: 2026-03-12 10:21:26 Database: zemm_produktiv_7 Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
3 4 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 12 13 4 - ERROR: column "taskid" does not exist
- ERROR: column "taskid" does not exist
- ERROR: column "taskid" does not exist
Statement: select id, taskid, file_name, file_upload from documents where file_name = $1 order by id desc limit 10
Date: 2026-03-12 13:42:58 Database: zemm_produktiv_7 Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
Statement: select id, taskid, file_name, file_upload from documents where file_name = $1 order by id desc limit 10
Date: 2026-03-12 13:42:58 Database: zemm_produktiv_7 Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
Statement: select id, taskid, file_name, file_upload from documents where file_name = $1 order by id desc limit 10
Date: 2026-03-12 13:42:58 Database: zemm_produktiv_7 Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
4 4 FATAL: Peer authentication failed for user "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Mar 12 13 1 16 3 - FATAL: Peer authentication failed for user "timestamp,"
- FATAL: Peer authentication failed for user "labanimal"
- 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-12 13:52:28 Database: zemm_produktiv_8 Application: User: timestamp, Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
Detail: Connection matched file "/etc/postgresql/18/main/pg_hba.conf" line 18: "local all all peer"
Date: 2026-03-12 16:28:10 Database: zemm_produktiv_7 Application: User: labanimal Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
Detail: Connection matched file "/etc/postgresql/18/main/pg_hba.conf" line 18: "local all all peer"
Date: 2026-03-12 16:28:10 Database: zemm_produktiv_7 Application: User: labanimal Remote: [local] Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
5 3 LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #5
Day Hour Count Mar 12 15 3 - LOG: process 1541631 still waiting for AccessShareLock on relation 111838 of database 111793 after 1000.067 ms
- LOG: process 1541631 still waiting for AccessShareLock on relation 111838 of database 111793 after 9997.871 ms
- LOG: process 1541631 still waiting for AccessShareLock on relation 111838 of database 111793 after 22937.724 ms
Detail: Process holding the lock: 1541529. Wait queue: 1541631.
Statement: SELECT queryid::text AS fingerprint, query AS query, mean_exec_time AS mean_time_ms, total_exec_time AS total_time_ms, calls, rows AS rows_returned FROM pg_stat_statements WHERE dbid = (SELECT oid FROM pg_database WHERE datname = current_database()) ORDER BY total_exec_time DESC LIMIT 50Date: 2026-03-12 15:13:03 Database: zemm_produktiv_7 Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
Detail: Process holding the lock: 1541529. Wait queue: 1541631.
Statement: SELECT queryid::text AS fingerprint, query AS query, mean_exec_time AS mean_time_ms, total_exec_time AS total_time_ms, calls, rows AS rows_returned FROM pg_stat_statements WHERE dbid = (SELECT oid FROM pg_database WHERE datname = current_database()) ORDER BY total_exec_time DESC LIMIT 50Date: 2026-03-12 15:13:12 Database: zemm_produktiv_7 Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
Detail: Process holding the lock: 1541529. Wait queue: 1541631.
Statement: SELECT queryid::text AS fingerprint, query AS query, mean_exec_time AS mean_time_ms, total_exec_time AS total_time_ms, calls, rows AS rows_returned FROM pg_stat_statements WHERE dbid = (SELECT oid FROM pg_database WHERE datname = current_database()) ORDER BY total_exec_time DESC LIMIT 50Date: 2026-03-12 15:13:25 Database: zemm_produktiv_7 Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
6 2 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Mar 12 13 2 - ERROR: syntax error at or near ";"
- ERROR: syntax error at or near ";"
Statement: SELECT a.id, a.name, a.species, a."animalID", a.species as "species", a.sex as "sex" , a.sterile, a."birthDate", a."arrivalDate", a.alive, a."outgoingDate", a."deathDate" , a.fate, a.comments, cages."cageName", a."homeCage", a.project , a.breeding AS breeding, cages.breeding AS breeding_cage, a.dummy_line_info, a.dummy_strain_info , a.dummy_gen_info as gene_1, a.gen_1_typ as gene_1_type, a.gen_2_info as gene_2, a.gen_2_typ as gene_2_type, a.gen_3_info as gene_3, a.gen_3_typ as gene_3_type, a.gen_4_info as gene_4, a.gen_4_typ as gene_4_type, a.gen_5_info as gene_5, a.gen_5_typ as gene_5_type , a.generation, a.dummy_backcross_info, a.cohort, a.litter, a.genecomment , fat.name as sire_name , fat.id as sire_db_id , fat."animalID" as sire_id , mot.name as dam_name , mot.id as dam_db_id , mot."animalID" as dam_id , tr.rfid as rfid , tr.insertion_date as transpondered_at , owner.is_owner AS is_owner , editor.is_editor AS is_editor , tourist.is_tourist AS is_tourist FROM animals AS a LEFT OUTER JOIN cages ON cages.id=a."homeCage" LEFT OUTER JOIN fates ON fates.id=a.fate LEFT OUTER JOIN animals fat ON CAST(a."parentMale" AS BIGINT) = fat.id LEFT OUTER JOIN animals mot ON CAST(a."parentFemale" AS BIGINT) = mot.id LEFT OUTER JOIN transponders tr ON tr.maps_to = a.id AND tr.extraction_date IS NULL LEFT JOIN (SELECT animals.id AS animal, MAX(CASE WHEN ow.user = 10100134 OR owg.user = 10100134 THEN 1 ELSE 0 END) AS is_owner FROM animals LEFT OUTER JOIN "targetgroupMembers" ow ON ow.targetgroup = animals.owner LEFT OUTER JOIN "groupMembers" owg ON owg.group = ow.group GROUP BY animals.id) owner ON owner.animal = a.id LEFT JOIN (SELECT animals.id AS animal, MAX(CASE WHEN ed.user = 10100134 OR edg.user = 10100134 THEN 1 ELSE 0 END) AS is_editor FROM animals LEFT OUTER JOIN "targetgroupMembers" ed ON ed.targetgroup = animals.editor LEFT OUTER JOIN "groupMembers" edg ON edg.group = ed.group GROUP BY animals.id) editor ON editor.animal = a.id LEFT JOIN (SELECT animals.id AS animal, MAX(CASE WHEN tou.user = 10100134 OR toug.user = 10100134 THEN 1 ELSE 0 END) AS is_tourist FROM animals LEFT OUTER JOIN "targetgroupMembers" tou ON tou.targetgroup = animals.tourist LEFT OUTER JOIN "groupMembers" toug ON toug.group = tou.group GROUP BY animals.id) tourist ON tourist.animal = a.id WHERE a.id= ;
Date: 2026-03-12 13:26:16 Database: zemm_produktiv_8 Application: _desktop_index.php_view_animal_name_on_view_animal_id_on_animal User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
Statement: SELECT a.id, a.name, a.species, a."animalID", a.species as "species", a.sex as "sex" , a.sterile, a."birthDate", a."arrivalDate", a.alive, a."outgoingDate", a."deathDate" , a.fate, a.comments, cages."cageName", a."homeCage", a.project , a.breeding AS breeding, cages.breeding AS breeding_cage, a.dummy_line_info, a.dummy_strain_info , a.dummy_gen_info as gene_1, a.gen_1_typ as gene_1_type, a.gen_2_info as gene_2, a.gen_2_typ as gene_2_type, a.gen_3_info as gene_3, a.gen_3_typ as gene_3_type, a.gen_4_info as gene_4, a.gen_4_typ as gene_4_type, a.gen_5_info as gene_5, a.gen_5_typ as gene_5_type , a.generation, a.dummy_backcross_info, a.cohort, a.litter, a.genecomment , fat.name as sire_name , fat.id as sire_db_id , fat."animalID" as sire_id , mot.name as dam_name , mot.id as dam_db_id , mot."animalID" as dam_id , tr.rfid as rfid , tr.insertion_date as transpondered_at , owner.is_owner AS is_owner , editor.is_editor AS is_editor , tourist.is_tourist AS is_tourist FROM animals AS a LEFT OUTER JOIN cages ON cages.id=a."homeCage" LEFT OUTER JOIN fates ON fates.id=a.fate LEFT OUTER JOIN animals fat ON CAST(a."parentMale" AS BIGINT) = fat.id LEFT OUTER JOIN animals mot ON CAST(a."parentFemale" AS BIGINT) = mot.id LEFT OUTER JOIN transponders tr ON tr.maps_to = a.id AND tr.extraction_date IS NULL LEFT JOIN (SELECT animals.id AS animal, MAX(CASE WHEN ow.user = 10100134 OR owg.user = 10100134 THEN 1 ELSE 0 END) AS is_owner FROM animals LEFT OUTER JOIN "targetgroupMembers" ow ON ow.targetgroup = animals.owner LEFT OUTER JOIN "groupMembers" owg ON owg.group = ow.group GROUP BY animals.id) owner ON owner.animal = a.id LEFT JOIN (SELECT animals.id AS animal, MAX(CASE WHEN ed.user = 10100134 OR edg.user = 10100134 THEN 1 ELSE 0 END) AS is_editor FROM animals LEFT OUTER JOIN "targetgroupMembers" ed ON ed.targetgroup = animals.editor LEFT OUTER JOIN "groupMembers" edg ON edg.group = ed.group GROUP BY animals.id) editor ON editor.animal = a.id LEFT JOIN (SELECT animals.id AS animal, MAX(CASE WHEN tou.user = 10100134 OR toug.user = 10100134 THEN 1 ELSE 0 END) AS is_tourist FROM animals LEFT OUTER JOIN "targetgroupMembers" tou ON tou.targetgroup = animals.tourist LEFT OUTER JOIN "groupMembers" toug ON toug.group = tou.group GROUP BY animals.id) tourist ON tourist.animal = a.id WHERE a.id= ;
Date: 2026-03-12 13:45:32 Database: zemm_produktiv_8 Application: _desktop_index.php_m_action_animals_3Am_delete_val4_animals_lis User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
7 1 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #7
Day Hour Count Mar 12 15 1 - FATAL: terminating connection due to administrator command
Date: 2026-03-12 15:12:47 Database: zemm_produktiv_7 Application: DBeaver 26.0.0 - Main 'zemm_produktiv_7' User: labanimal Remote: 94.31.109.76 Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv
8 1 ERROR: invalid input syntax for type date: ...
Times Reported Most Frequent Error / Event #8
Day Hour Count Mar 12 14 1 - ERROR: invalid input syntax for type date: "2025-03012"
Statement: SELECT p_update_animals(454, '10293836', NULL, NULL, NULL, false,NULL, NULL, false, NULL, '2025-03012', NULL, 1, NULL, 9628, NULL, false,NULL,NULL,NULL, NULL,NULL,NULL,0);
Date: 2026-03-12 14:08:31 Database: zemm_produktiv_8 Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-12_000000.csv