ZEMM PG Report-
Global information
- Generated on Thu Apr 30 06:05:11 2026
- Log file: /var/log/postgresql/postgresql-2026-03-25_000000.csv, ..., /var/log/postgresql/postgresql-2026-04-30_000000.csv
- Parsed 207,761 log entries in 5m10s
- Log start from 2026-03-26 00:00:01 to 2026-03-26 23:59:23
-
Overview
Global Stats
- 54 Number of unique normalized queries
- 18,845 Number of queries
- 3h51m14s Total query duration
- 2026-03-26 00:00:01 First query
- 2026-03-26 23:59:01 Last query
- 14 queries/s at 2026-03-26 14:48:01 Query peak
- 3h51m14s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 3h51m14s Execute total duration
- 12 Number of events
- 1 Number of unique normalized events
- 12 Max number of times the same event was reported
- 0 Number of cancellation
- 107 Total number of automatic vacuums
- 202 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 18,668 Total number of sessions
- 4 sessions at 2026-03-26 09:22:38 Session peak
- 59m39s Total duration of sessions
- 191ms Average duration of sessions
- 1 Average queries per session
- 743ms Average queries duration per session
- 0ms Average idle time per session
- 18,680 Total number of connections
- 12 connections/s at 2026-03-26 18:55:04 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 14 queries/s Query Peak
- 2026-03-26 14:48:01 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-03-26 06:46:07 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 13 queries/s Query Peak
- 2026-03-26 14:21:01 Date
Queries duration
Key values
- 3h51m14s 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 26 00 780 0ms 0ms 0ms 0ms 0ms 0ms 01 781 0ms 790ms 382ms 10s274ms 10s274ms 10s274ms 02 780 790ms 790ms 790ms 10s274ms 10s274ms 10s274ms 03 780 790ms 790ms 790ms 10s274ms 10s274ms 10s274ms 04 780 790ms 790ms 790ms 10s274ms 10s274ms 10s274ms 05 780 790ms 790ms 790ms 10s274ms 10s274ms 10s274ms 06 800 509ms 1s471ms 850ms 19s76ms 19s123ms 20s155ms 07 787 631ms 1s657ms 754ms 9s762ms 21s547ms 21s547ms 08 786 639ms 1s657ms 734ms 11s227ms 21s547ms 22s913ms 09 792 637ms 2s295ms 1s426ms 29s837ms 29s837ms 29s837ms 10 786 663ms 2s295ms 979ms 29s837ms 29s837ms 31s664ms 11 784 630ms 699ms 648ms 8s625ms 8s625ms 11s293ms 12 797 645ms 1s734ms 961ms 15s353ms 18s986ms 23s556ms 13 793 586ms 1s613ms 890ms 18s786ms 18s786ms 23s703ms 14 792 555ms 1s631ms 816ms 12s805ms 13s201ms 15s602ms 15 802 552ms 1s737ms 905ms 14s556ms 22s582ms 24s246ms 16 780 634ms 634ms 634ms 8s252ms 8s252ms 8s252ms 17 780 634ms 634ms 634ms 8s252ms 8s252ms 8s252ms 18 780 634ms 634ms 634ms 8s252ms 8s252ms 8s252ms 19 780 634ms 634ms 634ms 8s252ms 8s252ms 8s252ms 20 780 634ms 634ms 634ms 8s252ms 8s252ms 8s252ms 21 780 634ms 634ms 634ms 8s252ms 8s252ms 8s252ms 22 780 634ms 634ms 634ms 8s252ms 8s252ms 8s252ms 23 785 549ms 1s974ms 686ms 8s252ms 17s559ms 17s559ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 26 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 19 0 797ms 569ms 1s79ms 2s39ms 07 6 0 663ms 0ms 0ms 1s330ms 08 6 0 680ms 0ms 0ms 1s366ms 09 9 0 707ms 0ms 0ms 2s713ms 10 6 0 767ms 0ms 0ms 1s393ms 11 4 0 667ms 0ms 0ms 0ms 12 16 0 912ms 0ms 1s65ms 2s55ms 13 10 0 748ms 0ms 937ms 1s351ms 14 11 0 794ms 0ms 918ms 1s541ms 15 16 0 745ms 0ms 952ms 2s676ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 5 1s284ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 26 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 1 0 0 790ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Mar 26 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Mar 26 00 244 0.07/s 01 247 0.07/s 02 244 0.07/s 03 245 0.07/s 04 244 0.07/s 05 288 0.08/s 06 1,166 0.32/s 07 1,697 0.47/s 08 1,619 0.45/s 09 2,152 0.60/s 10 1,305 0.36/s 11 1,195 0.33/s 12 1,769 0.49/s 13 1,328 0.37/s 14 902 0.25/s 15 1,211 0.34/s 16 934 0.26/s 17 341 0.09/s 18 276 0.08/s 19 284 0.08/s 20 244 0.07/s 21 244 0.07/s 22 244 0.07/s 23 257 0.07/s Day Hour Count Average Duration Average idle time Mar 26 00 244 286ms 286ms 01 247 288ms 0ms 02 244 288ms 0ms 03 245 291ms 0ms 04 244 294ms 0ms 05 286 263ms 0ms 06 1,166 231ms 0ms 07 1,695 134ms 0ms 08 1,619 141ms 0ms 09 2,152 149ms 0ms 10 1,305 179ms 0ms 11 1,195 154ms 0ms 12 1,767 185ms 0ms 13 1,328 178ms 0ms 14 902 178ms 0ms 15 1,211 222ms 0ms 16 932 172ms 0ms 17 341 245ms 0ms 18 272 268ms 0ms 19 284 261ms 0ms 20 244 297ms 0ms 21 244 287ms 0ms 22 244 286ms 0ms 23 257 326ms 0ms -
Connections
Established Connections
Key values
- 12 connections Connection Peak
- 2026-03-26 18:55:04 Date
Connections per database
Key values
- zemm_monitoring Main Database
- 18,680 connections Total
Connections per user
Key values
- labanimal Main User
- 18,680 connections Total
-
Sessions
Simultaneous sessions
Key values
- 4 sessions Session Peak
- 2026-03-26 09:22:38 Date
Histogram of session times
Key values
- 16,511 0-500ms duration
Sessions per database
Key values
- zemm_monitoring Main Database
- 18,668 sessions Total
Sessions per user
Key values
- labanimal Main User
- 18,668 sessions Total
Sessions per host
Key values
- ::1 Main Host
- 18,668 sessions Total
Sessions per application
Key values
- Main Application
- 18,668 sessions Total
Application Count Total Duration Average Duration 14,500 46m11s 191ms _backend_cage_autocomplete_api.php_q_52-003_limit_12_zemm_produ 1 28ms 28ms _backend_cage_autocomplete_api.php_q_52-004_limit_12_zemm_produ 1 29ms 29ms _backend_cage_autocomplete_api.php_q_52-008_limit_12_zemm_produ 2 56ms 28ms _backend_cage_autocomplete_api.php_q_52-00_limit_12_zemm_produk 2 60ms 30ms _backend_wean_api.php_litter_id_10131392_zemm_produktiv_8_local 2 277ms 138ms _backend_wean_api.php_litter_id_10131492_zemm_produktiv_8_local 2 282ms 141ms _backend_wean_api.php_litter_id_10131496_zemm_produktiv_8_local 2 278ms 139ms _backend_wean_api.php_litter_id_10131497_zemm_produktiv_8_local 2 280ms 140ms _backend_wean_api.php_litter_id_10131499_zemm_produktiv_8_local 2 282ms 141ms _backend_wean_api.php_litter_id_10131503_zemm_produktiv_8_local 19 2s661ms 140ms _backend_wean_api.php_litter_id_10131504_zemm_produktiv_8_local 2 282ms 141ms _backend_wean_api.php_litter_id_10131506_zemm_produktiv_8_local 4 552ms 138ms _backend_wean_api.php_litter_id_10131508_zemm_produktiv_8_local 2 279ms 139ms _backend_wean_api.php_litter_id_10131584_zemm_produktiv_8_local 5 697ms 139ms _backend_wean_api.php_litter_id_10131585_zemm_produktiv_8_local 2 277ms 138ms _backend_wean_api.php_litter_id_10131615_zemm_produktiv_8_local 2 281ms 140ms _backend_wean_api.php_litter_id_10131617_zemm_produktiv_8_local 2 281ms 140ms _backend_wean_api.php_litter_id_10131618_zemm_produktiv_8_local 2 278ms 139ms _backend_wean_api.php_litter_id_10131619_zemm_produktiv_8_local 3 421ms 140ms _backend_wean_api.php_litter_id_10131620_zemm_produktiv_8_local 2 276ms 138ms _backend_wean_api.php_litter_id_10131621_zemm_produktiv_8_local 3 420ms 140ms _backend_wean_api.php_litter_id_10131622_zemm_produktiv_8_local 2 278ms 139ms _backend_wean_api.php_litter_id_10131623_zemm_produktiv_8_local 2 277ms 138ms _backend_wean_api.php_litter_id_10131662_zemm_produktiv_8_local 2 275ms 137ms _backend_wean_api.php_litter_id_10131672_zemm_produktiv_8_local 2 277ms 138ms _backend_wean_api.php_litter_id_10131674_zemm_produktiv_8_local 2 282ms 141ms _backend_wean_api.php_litter_id_10131677_zemm_produktiv_8_local 2 281ms 140ms _backend_wean_api.php_litter_id_10131678_zemm_produktiv_8_local 2 283ms 141ms _backend_wean_api.php_litter_id_10131725_zemm_produktiv_8_local 2 280ms 140ms _backend_wean_api.php_litter_id_10131776_zemm_produktiv_8_local 2 280ms 140ms _backend_wean_api.php_litter_id_10131778_zemm_produktiv_8_local 2 282ms 141ms _backend_wean_api.php_litter_id_10131814_zemm_produktiv_8_local 2 283ms 141ms _backend_wean_api.php_litter_id_10131815_zemm_produktiv_8_local 2 277ms 138ms _backend_wean_api.php_litter_id_10131816_zemm_produktiv_8_local 2 282ms 141ms _backend_wean_api.php_litter_id_10131842_zemm_produktiv_8_local 1 139ms 139ms _backend_wean_api.php_litter_id_10131910_zemm_produktiv_8_local 2 282ms 141ms _backend_wean_api.php_litter_id_10131913_zemm_produktiv_8_local 2 283ms 141ms _backend_wean_api.php_litter_id_10131915_zemm_produktiv_8_local 2 281ms 140ms _desktop__zemm_produktiv_8_localhost_5432 6 373ms 62ms _desktop_index.php_animal_name_16_animal_id_2025_2F001_2F2954_s 1 103ms 103ms _desktop_index.php_animal_name_89_20Z_animal_id_2025_2F002_2F31 1 42ms 42ms _desktop_index.php_cage_name_51-327_current_only_true_val4_anim 1 103ms 103ms _desktop_index.php_cage_name_71_2A_unweaned_only_true_val4_anim 5 560ms 112ms _desktop_index.php_cages_empty__25_val4_cages_search_command_an 3 131ms 43ms _desktop_index.php_cages_name_46-157_cages_empty__25_val4_cages 1 72ms 72ms _desktop_index.php_cages_name_46_2A_cages_empty_false_val4_cage 1 440ms 440ms _desktop_index.php_cages_name_51_2A_cages_empty__25_val4_cages_ 4 3s539ms 884ms _desktop_index.php_command_animals_edit_subcommand_init_id_1027 2 200ms 100ms _desktop_index.php_command_animals_edit_subcommand_init_id_1029 5 568ms 113ms _desktop_index.php_command_animals_edit_subcommand_init_id_1030 2 199ms 99ms _desktop_index.php_command_animals_litters_edit_subcommand_init 1 102ms 102ms _desktop_index.php_command_animals_subcommand_found_val1_1344_v 1 46ms 46ms _desktop_index.php_command_animals_subcommand_found_val1_1745_v 1 38ms 38ms _desktop_index.php_command_animals_subcommand_init_zemm_produkt 37 1s673ms 45ms _desktop_index.php_command_cages_subcommand_init_zemm_produktiv 4 161ms 40ms _desktop_index.php_command_documents_subcommand_edit_id_69_zemm 1 45ms 45ms _desktop_index.php_command_documents_subcommand_init_zemm_produ 3 133ms 44ms _desktop_index.php_command_login_subcommand_init_zemm_produktiv 242 7s434ms 30ms _desktop_index.php_command_reports_subcommand_animals_per_room_ 4 535ms 133ms _desktop_index.php_command_reports_subcommand_animals_per_user_ 11 1s190ms 108ms _desktop_index.php_command_reports_subcommand_fates_zemm_produk 3 303ms 101ms _desktop_index.php_command_reports_subcommand_init_zemm_produkt 3 357ms 119ms _desktop_index.php_command_reports_subcommand_task_status_zemm_ 5 573ms 114ms _desktop_index.php_command_tasks_subcommand_create_task_id_49_z 2 117ms 58ms _desktop_index.php_command_tasks_subcommand_edit_id_10141875_ze 4 320ms 80ms _desktop_index.php_command_tasks_subcommand_edit_id_10141877_ze 1 85ms 85ms _desktop_index.php_command_tasks_subcommand_edit_id_10141878_ze 1 81ms 81ms _desktop_index.php_command_tasks_subcommand_edit_id_10141909_ze 9 755ms 83ms _desktop_index.php_command_tasks_subcommand_edit_id_10141910_ze 1 86ms 86ms _desktop_index.php_command_tasks_subcommand_edit_id_10141911_ze 1 83ms 83ms _desktop_index.php_command_tasks_subcommand_edit_id_10141930_ze 1 86ms 86ms _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv 102 9s363ms 91ms _desktop_index.php_command_tasks_subcommand_search_zemm_produkt 8 348ms 43ms _desktop_index.php_m_action_animals_3Am_delete_row_animals_1029 1 44ms 44ms _desktop_index.php_m_action_animals_3Am_delete_val4_animals_lis 1 44ms 44ms _desktop_index.php_name_Tiertransport_20innerhalb_20W_C3_BCrzbu 6 339ms 56ms _desktop_index.php_name_Verpaarungen_20zur_20Zucht_instructions 2 130ms 65ms _desktop_index.php_reference_Formulare_20ZEMM_title_Anmeldung_2 2 76ms 38ms _desktop_index.php_search_status_2_issuer_user_name_Herbel_2C_2 1 40ms 40ms _desktop_index.php_search_status_2_no_subtasks_true_command_gro 1 67ms 67ms _desktop_index.php_search_status__25_issued_from_2025-09-19_iss 2 334ms 167ms _desktop_index.php_unweaned_only_true_val4_animals_litters_sear 1 141ms 141ms _desktop_index.php_view_animal_name_on_view_animal_id_on_animal 1 259ms 259ms _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b 50 21s208ms 424ms _desktop_index.php_zemm_produktiv_8_localhost_5432 3,431 11m54s 208ms backend:zemm_produktiv_8@localhost 44 3s535ms 80ms expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 1 807ms 807ms pg_dump 1 13s512ms 13s512ms taskscron:zemm_produktiv_7@zemm.fbiscience.eu 24 580ms 24ms taskscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 24 9s343ms 389ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 18,616 buffers Checkpoint Peak
- 2026-03-26 01:37:50 Date
- 270.001 seconds Highest write time
- 0.028 seconds Sync time
Checkpoints Wal files
Key values
- 7 files Wal files usage Peak
- 2026-03-26 15:38:00 Date
Checkpoints distance
Key values
- 224.15 Mo Distance Peak
- 2026-03-26 15:38:00 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Mar 26 00 2,103 210.933s 0.073s 211.063s 01 20,704 478.83s 0.077s 478.966s 02 2,087 209.355s 0.074s 209.481s 03 2,094 210.061s 0.074s 210.188s 04 2,082 208.865s 0.07s 208.99s 05 2,341 234.709s 0.079s 234.842s 06 6,896 691.032s 0.227s 691.325s 07 5,523 553.338s 0.22s 553.609s 08 5,549 555.921s 0.208s 556.181s 09 20,468 835.923s 0.238s 836.219s 10 18,309 777.569s 0.191s 777.814s 11 3,777 378.635s 0.168s 378.853s 12 18,199 769.255s 0.239s 769.551s 13 28,868 917.557s 0.209s 917.822s 14 78,608 1,743.397s 0.179s 1,743.648s 15 45,486 1,435.388s 0.198s 1,435.655s 16 5,974 598.345s 0.165s 598.564s 17 2,560 256.777s 0.088s 256.914s 18 5,726 484.728s 0.079s 484.857s 19 2,560 256.78s 0.079s 256.912s 20 2,315 232.203s 0.072s 232.329s 21 2,316 232.314s 0.072s 232.434s 22 2,699 270.648s 0.073s 270.777s 23 2,563 257.04s 0.079s 257.174s Day Hour Added Removed Recycled Synced files Longest sync Average sync Mar 26 00 0 0 1 345 0.001s 0.012s 01 0 0 6 372 0.001s 0.012s 02 0 0 1 346 0.001s 0.012s 03 0 0 1 348 0.001s 0.012s 04 0 0 0 338 0.001s 0.012s 05 0 0 1 361 0.003s 0.012s 06 0 0 3 1,206 0.003s 0.012s 07 0 0 2 1,205 0.003s 0.012s 08 0 0 1 1,103 0.003s 0.012s 09 0 0 6 1,331 0.003s 0.012s 10 0 0 5 1,072 0.003s 0.012s 11 0 0 2 914 0.003s 0.012s 12 0 0 5 1,363 0.003s 0.012s 13 0 0 8 1,171 0.002s 0.012s 14 0 0 25 1,026 0.002s 0.012s 15 0 0 20 1,115 0.003s 0.012s 16 0 0 3 843 0.006s 0.012s 17 0 0 0 443 0.002s 0.012s 18 0 0 2 382 0.001s 0.012s 19 0 0 1 383 0.001s 0.012s 20 0 0 1 343 0.001s 0.012s 21 0 0 0 340 0.001s 0.012s 22 0 0 1 345 0.001s 0.012s 23 0 0 1 369 0.002s 0.012s Day Hour Count Avg time (sec) Mar 26 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 26 00 1,026.58 kB 1,185.42 kB 01 8,611.08 kB 36,450.00 kB 02 1,025.92 kB 29,857.50 kB 03 1,030.00 kB 9,169.75 kB 04 1,037.00 kB 3,330.83 kB 05 1,094.75 kB 1,715.00 kB 06 3,715.50 kB 11,867.33 kB 07 2,377.58 kB 6,049.50 kB 08 2,358.92 kB 4,421.92 kB 09 8,114.33 kB 33,454.75 kB 10 6,826.92 kB 36,827.58 kB 11 1,533.42 kB 13,444.92 kB 12 6,830.58 kB 20,456.58 kB 13 11,076.00 kB 39,894.33 kB 14 34,330.58 kB 65,450.58 kB 15 28,087.75 kB 74,347.92 kB 16 3,078.58 kB 44,608.58 kB 17 1,143.25 kB 13,781.92 kB 18 2,060.50 kB 8,126.33 kB 19 1,144.50 kB 3,266.83 kB 20 1,100.42 kB 1,719.08 kB 21 1,098.75 kB 1,276.75 kB 22 1,147.42 kB 1,205.17 kB 23 1,133.00 kB 1,379.42 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Mar 26 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 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 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.57 sec Highest CPU-cost vacuum
Table public.tasks
Database zemm_produktiv_8 - 2026-03-26 01:30:08 Date
- 0 sec Highest CPU-cost analyze
Table
Database zemm_produktiv_8 - Date
Average Autovacuum Duration
Key values
- 0.57 sec Highest CPU-cost vacuum
Table public.tasks
Database zemm_produktiv_8 - 2026-03-26 01:30:08 Date
Analyzes per table
Key values
- pg_catalog.pg_type (50) Main table analyzed (database zemm_produktiv_8)
- 202 analyzes Total
Table Number of analyzes zemm_produktiv_8.pg_catalog.pg_type 50 zemm_produktiv_8.pg_catalog.pg_attribute 37 zemm_produktiv_8.pg_catalog.pg_class 27 zemm_produktiv_8.pg_catalog.pg_depend 24 zemm_produktiv_8.public.breedingssires 21 zemm_produktiv_8.public.breedingsdams 21 zemm_produktiv_8.pg_catalog.pg_shdepend 3 zemm_produktiv_8.public.tmptasks 3 zemm_produktiv_8.public.cages_search_mview 2 zemm_produktiv_8.public.users 2 fbi_ci_db.pg_catalog.pg_shdepend 2 zemm_monitoring.observability.db_top_queries 1 zemm_produktiv_8.public.tasks 1 bucardo.pg_catalog.pg_shdepend 1 zemm_monitoring.observability.system_metrics 1 zemm_monitoring.observability.metrics_timeseries 1 zemm_produktiv_8.public.monitoring_session_activity 1 fbi_unire.pg_catalog.pg_shdepend 1 zemm_monitoring.pg_catalog.pg_shdepend 1 zemm_monitoring.observability.app_events 1 zemm_test_3.pg_catalog.pg_shdepend 1 Total 202 Vacuums per table
Key values
- public.breedingssires (21) Main table vacuumed on database zemm_produktiv_8
- 107 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.public.breedingssires 21 0 0 0 0 0 0 3,108 84 197,232 0 0 zemm_produktiv_8.public.breedingsdams 21 0 0 0 0 0 0 4,158 84 259,182 0 0 zemm_produktiv_8.pg_catalog.pg_type 16 16 0 0 0 0 0 857 195 206,320 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 13 13 0 0 0 0 0 1,745 578 381,861 0 0 zemm_produktiv_8.pg_catalog.pg_class 9 9 0 0 0 0 0 885 292 345,543 0 0 zemm_monitoring.pg_toast.pg_toast_67431 7 0 0 0 0 0 0 4,401 1,479 3,354,175 1,451 8,706 zemm_produktiv_8.pg_catalog.pg_depend 6 6 0 0 0 0 0 756 228 264,729 0 0 bucardo.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 357 113 218,114 0 0 zemm_produktiv_8.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 757 180 861,398 33 101 zemm_produktiv_8.public.cages_search_mview 1 1 0 0 0 0 0 599 307 1,079,070 39 1,115 zemm_produktiv_8.public.tasks 1 1 0 0 0 0 0 42,385 50 3,105,981 2 6 zemm_monitoring.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 106 23 143,008 7 23 zemm_monitoring.pg_toast.pg_toast_67411 1 0 0 0 0 0 0 2,946 786 5,965,471 784 3,136 zemm_produktiv_8.public.user_ui_prefs 1 1 0 0 0 0 0 187 83 131,318 2 14 zemm_monitoring.observability.nginx_counters 1 0 0 0 0 0 0 260 260 426,483 0 0 Total 107 56 0 0 0 0 0 63,507 4,742 16,939,885 2,318 13,101 Vacuum throughput per table
Key values
- public.tasks (0.57) Max CPU elapsed for vacuum on database zemm_produktiv_8
- public.user_ui_prefs (0.954 ms) Max I/O read time for vacuum on database zemm_produktiv_8
- public.breedingssires (0.611 ms) Max I/O write time for vacuum on database zemm_produktiv_8
I/O timing (ms) CPU (s) Table read write elapsed zemm_produktiv_8.public.breedingssires 0 0.611 0 zemm_produktiv_8.public.breedingsdams 0 0.338 0 zemm_produktiv_8.pg_catalog.pg_type 0 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 0 0 0.13 zemm_produktiv_8.pg_catalog.pg_class 0 0 0.04 zemm_monitoring.pg_toast.pg_toast_67431 0 0 0.34 zemm_produktiv_8.pg_catalog.pg_depend 0 0 0.05 bucardo.pg_catalog.pg_shdepend 0 0 0.01 zemm_produktiv_8.pg_toast.pg_toast_2619 0 0 0.03 zemm_produktiv_8.public.cages_search_mview 0.3 0 0.08 zemm_produktiv_8.public.tasks 0.136 0 0.57 zemm_monitoring.pg_toast.pg_toast_2619 0 0 0 zemm_monitoring.pg_toast.pg_toast_67411 0 0 0.2 zemm_produktiv_8.public.user_ui_prefs 0.954 0 0.03 zemm_monitoring.observability.nginx_counters 0.058 0 0.06 Total 1.448 0.949000000000001 1.54 Tuples removed per table
Key values
- public.tasks (53485) Main table with removed tuples on database zemm_produktiv_8
- 78782 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain zemm_produktiv_8.public.tasks 1 1 53,485 56,503 0 0 16,628 zemm_produktiv_8.pg_catalog.pg_attribute 13 13 13,437 73,779 0 0 2,392 zemm_produktiv_8.pg_catalog.pg_depend 6 6 5,137 25,026 0 0 330 zemm_produktiv_8.pg_catalog.pg_type 16 16 3,300 13,296 0 0 496 bucardo.pg_catalog.pg_shdepend 4 4 1,501 15,396 0 0 152 zemm_produktiv_8.pg_catalog.pg_class 9 9 1,304 8,046 0 0 378 zemm_produktiv_8.pg_toast.pg_toast_2619 4 4 435 1,138 0 0 424 zemm_produktiv_8.public.cages_search_mview 1 1 119 13,629 0 0 219 zemm_monitoring.pg_toast.pg_toast_2619 1 1 63 82 0 0 37 zemm_produktiv_8.public.user_ui_prefs 1 1 1 741 0 0 116 zemm_produktiv_8.public.breedingssires 21 0 0 471,766 0 0 3,024 zemm_monitoring.pg_toast.pg_toast_67411 1 0 0 48,551 0 0 11,734 zemm_monitoring.pg_toast.pg_toast_67431 7 0 0 1,512,550 0 0 253,081 zemm_monitoring.observability.nginx_counters 1 0 0 46,584 0 0 1,321 zemm_produktiv_8.public.breedingsdams 21 0 0 637,497 0 0 4,074 Total 107 56 78,782 2,924,584 0 0 294,406 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Pages removed per tables
NO DATASET
Table Number of vacuums Index scans Tuples removed Pages removed zemm_produktiv_8.public.cages_search_mview 1 1 119 0 zemm_produktiv_8.public.tasks 1 1 53485 0 zemm_produktiv_8.public.breedingssires 21 0 0 0 bucardo.pg_catalog.pg_shdepend 4 4 1501 0 zemm_monitoring.pg_toast.pg_toast_2619 1 1 63 0 zemm_produktiv_8.pg_catalog.pg_class 9 9 1304 0 zemm_monitoring.pg_toast.pg_toast_67411 1 0 0 0 zemm_produktiv_8.pg_catalog.pg_type 16 16 3300 0 zemm_monitoring.pg_toast.pg_toast_67431 7 0 0 0 zemm_produktiv_8.public.user_ui_prefs 1 1 1 0 zemm_monitoring.observability.nginx_counters 1 0 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 13 13 13437 0 zemm_produktiv_8.public.breedingsdams 21 0 0 0 zemm_produktiv_8.pg_toast.pg_toast_2619 4 4 435 0 zemm_produktiv_8.pg_catalog.pg_depend 6 6 5137 0 Total 107 56 78,782 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Mar 26 00 0 0 01 3 1 02 0 0 03 0 0 04 0 0 05 1 0 06 3 10 07 6 20 08 8 18 09 9 24 10 7 17 11 5 15 12 7 15 13 11 22 14 20 25 15 19 25 16 3 7 17 1 1 18 1 2 19 1 0 20 0 0 21 0 0 22 2 0 23 0 0 - 0.57 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 103 Total read queries
- 18,742 Total write queries
Queries by database
Key values
- zemm_monitoring Main database
- 18,720 Requests
- 3h49m21s (zemm_monitoring)
- Main time consuming database
Queries by user
Key values
- labanimal Main user
- 37,729 Requests
User Request type Count Duration labanimal Total 37,729 8h3m41s cte 37 56s78ms ddl 37,440 7h58m42s select 250 4m1s update 2 1s731ms postgres Total 10 13s17ms copy to 10 13s17ms Duration by user
Key values
- 8h3m41s (labanimal) Main time consuming user
User Request type Count Duration labanimal Total 37,729 8h3m41s cte 37 56s78ms ddl 37,440 7h58m42s select 250 4m1s update 2 1s731ms postgres Total 10 13s17ms copy to 10 13s17ms Queries by host
Key values
- unknown Main host
- 37,727 Requests
- 8h3m40s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 18,720 Requests
- 3h49m21s (unknown)
- Main time consuming application
Application Request type Count Duration _desktop_index.php_zemm_produktiv_8_localhost_5432 Total 119 1m44s cte 16 25s299ms select 103 1m19s expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 Total 1 790ms update 1 790ms pg_dump Total 5 6s423ms copy to 5 6s423ms unknown Total 18,720 3h49m21s ddl 18,720 3h49m21s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-03-26 07:38:07 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 98 500-1000ms duration
Slowest individual queries
Rank Duration Query 1 2s295ms 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, 10100003) THEN TRUE WHEN user_is_tgm (dam.editor, 10100003) THEN TRUE WHEN user_is_tgm (dam.tourist, 10100003) 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, 10100003) THEN TRUE WHEN user_is_tgm (sire.editor, 10100003) THEN TRUE WHEN user_is_tgm (sire.tourist, 10100003) 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-26 09:34:34 - Database: zemm_produktiv_8 - User: labanimal - Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 ]
2 2s295ms CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-03-26 09:35:01 - Database: zemm_monitoring - User: labanimal ]
3 2s295ms 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-26 09:35:01 - Database: zemm_monitoring - User: labanimal ]
4 2s295ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-03-26 09:35:01 - Database: zemm_monitoring - User: labanimal ]
5 2s295ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-03-26 09:35:01 - Database: zemm_monitoring - User: labanimal ]
6 2s295ms 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-26 09:35:01 - Database: zemm_monitoring - User: labanimal ]
7 2s295ms CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);[ Date: 2026-03-26 09:35:01 - Database: zemm_monitoring - User: labanimal ]
8 2s295ms CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);[ Date: 2026-03-26 09:35:01 - Database: zemm_monitoring - User: labanimal ]
9 2s295ms 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-26 09:35:01 - Database: zemm_monitoring - User: labanimal ]
10 2s295ms CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);[ Date: 2026-03-26 09:35:01 - Database: zemm_monitoring - User: labanimal ]
11 2s295ms 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-26 09:35:01 - Database: zemm_monitoring - User: labanimal ]
12 2s295ms 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-26 09:35:01 - Database: zemm_monitoring - User: labanimal ]
13 2s295ms CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-03-26 09:35:01 - Database: zemm_monitoring - User: labanimal ]
14 2s295ms 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-26 09:35:01 - Database: zemm_monitoring - User: labanimal ]
15 2s295ms CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-03-26 09:36:01 - Database: zemm_monitoring - User: labanimal ]
16 2s295ms 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-26 09:36:01 - Database: zemm_monitoring - User: labanimal ]
17 2s295ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-03-26 09:36:01 - Database: zemm_monitoring - User: labanimal ]
18 2s295ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-03-26 09:36:01 - Database: zemm_monitoring - User: labanimal ]
19 2s295ms 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-26 09:36:01 - Database: zemm_monitoring - User: labanimal ]
20 2s295ms CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);[ Date: 2026-03-26 09:36:01 - Database: zemm_monitoring - User: labanimal ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 17m38s 1,440 509ms 2s295ms 735ms 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 #1
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - 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-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
2 17m38s 1,440 509ms 2s295ms 735ms create schema if not exists observability;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
3 17m38s 1,440 509ms 2s295ms 735ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
4 17m38s 1,440 509ms 2s295ms 735ms create table if not exists observability.app_events ( id bigserial primary key, tenant_key text not null, event_type text not null, severity text not null, message text not null, payload jsonb, occurred_at timestamptz not null default now(), created_at timestamptz not null default now() );Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - 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-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
5 17m38s 1,440 509ms 2s295ms 735ms 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 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
6 17m38s 1,440 509ms 2s295ms 735ms 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 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - 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-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
7 17m38s 1,440 509ms 2s295ms 735ms 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 #7
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - 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-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
8 17m38s 1,440 509ms 2s295ms 735ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
9 17m38s 1,440 509ms 2s295ms 735ms create table if not exists observability.system_metrics ( 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 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
10 17m38s 1,440 509ms 2s295ms 735ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
11 17m38s 1,440 509ms 2s295ms 735ms create table if not exists observability.uptime_checks ( id bigserial primary key, endpoint text not null, status text not null, latency_ms double precision, checked_at timestamptz not null default now() );Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - 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-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
12 17m38s 1,440 509ms 2s295ms 735ms 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 #12
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - 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-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
13 17m38s 1,440 509ms 2s295ms 735ms 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 #13
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - 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-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
14 19s696ms 12 1s445ms 1s737ms 1s641ms 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 cagess."cageName" like (?) and damdam.breedingid = breedings.id and siresire.breedingid = breedings.id and breedings."unbreeding_date" is null group by breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire order by breeding_date, plug_date);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 26 07 1 1s657ms 1s657ms 09 1 1s593ms 1s593ms 12 1 1s734ms 1s734ms 13 3 4s653ms 1s551ms 14 1 1s631ms 1s631ms 15 5 8s425ms 1s685ms [ User: labanimal - Total duration: 19s696ms - Times executed: 12 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 19s696ms - Times executed: 12 ]
-
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, 28) THEN TRUE WHEN user_is_tgm (dam.editor, 28) THEN TRUE WHEN user_is_tgm (dam.tourist, 28) 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, 28) THEN TRUE WHEN user_is_tgm (sire.editor, 28) THEN TRUE WHEN user_is_tgm (sire.tourist, 28) 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 cagess."cageName" like ('71%') 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-26 15:24:45 Duration: 1s737ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_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, 456) THEN TRUE WHEN user_is_tgm (dam.editor, 456) THEN TRUE WHEN user_is_tgm (dam.tourist, 456) 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, 456) THEN TRUE WHEN user_is_tgm (sire.editor, 456) THEN TRUE WHEN user_is_tgm (sire.tourist, 456) 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 cagess."cageName" like ('51-337') 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-26 12:42:57 Duration: 1s734ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_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, 456) THEN TRUE WHEN user_is_tgm (dam.editor, 456) THEN TRUE WHEN user_is_tgm (dam.tourist, 456) 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, 456) THEN TRUE WHEN user_is_tgm (sire.editor, 456) THEN TRUE WHEN user_is_tgm (sire.tourist, 456) 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 cagess."cageName" like ('51-203') 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-26 15:31:45 Duration: 1s713ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
15 14s439ms 16 772ms 996ms 902ms select p_update_breedings (?, null, ?, ?::date, null, ?::text, ?::text, null) as id;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 26 09 1 931ms 931ms 10 1 951ms 951ms 13 3 2s888ms 962ms 14 7 6s276ms 896ms 15 4 3s390ms 847ms [ User: labanimal - Total duration: 14s439ms - Times executed: 16 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 14s439ms - Times executed: 16 ]
-
SELECT p_update_breedings (269, NULL, 14446, '2026-03-26'::date, NULL, '10291413'::text, '10290893'::text, NULL) AS id;
Date: 2026-03-26 13:30:14 Duration: 996ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT p_update_breedings (183, NULL, 15607, '2026-03-26'::date, NULL, '10288991'::text, '10288999'::text, NULL) AS id;
Date: 2026-03-26 14:14:25 Duration: 985ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT p_update_breedings (183, NULL, 10859, '2026-03-26'::date, NULL, '10282909'::text, '10285530'::text, NULL) AS id;
Date: 2026-03-26 13:59:08 Duration: 955ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
16 12s673ms 18 688ms 729ms 704ms 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 #16
Day Hour Count Duration Avg duration Mar 26 07 3 2s76ms 692ms 08 2 1s417ms 708ms 09 4 2s841ms 710ms 10 2 1s447ms 723ms 11 2 1s392ms 696ms 13 3 2s98ms 699ms 15 2 1s400ms 700ms [ User: labanimal - Total duration: 12s673ms - Times executed: 18 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 12s673ms - Times executed: 18 ]
-
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-26 10:23:02 Duration: 729ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_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, 490) AS is_owner, user_is_tgm (animals_search_mview.editor, 490) AS is_editor, user_is_tgm (animals_search_mview.tourist, 490) 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-26 08:44:30 Duration: 718ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_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, 615) AS is_owner, user_is_tgm (animals_search_mview.editor, 615) AS is_editor, user_is_tgm (animals_search_mview.tourist, 615) 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-26 09:19:18 Duration: 717ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
17 11s590ms 18 630ms 665ms 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 26 07 3 1s904ms 634ms 08 2 1s299ms 649ms 09 4 2s593ms 648ms 10 2 1s329ms 664ms 11 2 1s275ms 637ms 13 3 1s911ms 637ms 15 2 1s275ms 637ms [ User: labanimal - Total duration: 11s590ms - Times executed: 18 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 11s590ms - Times executed: 18 ]
-
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-26 10:22:58 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-26_000000.csv
-
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-26 10:23:03 Duration: 663ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 490) AS is_owner, user_is_tgm (animals_search_mview.editor, 490) AS is_editor, user_is_tgm (animals_search_mview.tourist, 490) 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-26 08:44:31 Duration: 660ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
18 5s244ms 6 764ms 1s6ms 874ms select p_update_breedings (?, ?, ?, ?::date, null, ?::text, ?::text, ?::date) as id;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 26 12 1 1s6ms 1s6ms 14 1 767ms 767ms 15 4 3s471ms 867ms [ User: labanimal - Total duration: 5s244ms - Times executed: 6 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 5s244ms - Times executed: 6 ]
-
SELECT p_update_breedings (456, 10110999, 13373, '2026-02-11'::date, NULL, '10292049'::text, '10292052'::text, '2026-03-26'::date) AS id;
Date: 2026-03-26 12:43:14 Duration: 1s6ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT p_update_breedings (456, 10110995, 7401, '2026-02-11'::date, NULL, '10292020'::text, '10292023'::text, '2026-03-26'::date) AS id;
Date: 2026-03-26 15:28:00 Duration: 985ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT p_update_breedings (456, 10110826, 13367, '2026-01-15'::date, NULL, '10286042'::text, '10283651'::text, '2026-03-26'::date) AS id;
Date: 2026-03-26 15:45:43 Duration: 952ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
19 4s898ms 4 983ms 1s467ms 1s224ms select * from p_wean_females (?, ?, ?, null, ?, ?, null, ?, ?, ?, ?, null, null, null, null, null, null, null, null, null, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 26 06 1 1s467ms 1s467ms 12 3 3s431ms 1s143ms [ User: labanimal - Total duration: 4s898ms - Times executed: 4 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 4s898ms - Times executed: 4 ]
-
SELECT * FROM p_wean_females (270, 10131615, 6, NULL, '52-187', 'B6.Trem2H157Y', NULL, 'F12', '2026-03-09', 'Trem2.H157Y(tg/tg)', 'w', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '56', 64);
Date: 2026-03-26 06:38:38 Duration: 1s467ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT * FROM p_wean_females (456, 10131674, 6, NULL, '51-178', 'B6a.TNF R1 ko', NULL, 'F28', '2026-03-05', 'TNF R1 ko', 'tgtg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '20', 18);
Date: 2026-03-26 12:44:48 Duration: 1s460ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT * FROM p_wean_females (456, 10131725, 4, NULL, '51-513', 'B6.RCL-Gi-DREADD', NULL, 'F11', '2026-03-01', 'R26-Gi-DREADD(tg/tg)', 'tgtg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '10000012', 43);
Date: 2026-03-26 12:51:54 Duration: 987ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
20 3s332ms 5 586ms 875ms 666ms select p_update_animals (?, cast(? as character varying), null, null, null, null, null, null, null, null, null, ?, null, null, ?, null, true, null, null, null, null, null, null, null);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 26 10 1 875ms 875ms 13 1 586ms 586ms 14 1 590ms 590ms 15 2 1s279ms 639ms [ User: labanimal - Total duration: 3s332ms - Times executed: 5 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 3s332ms - Times executed: 5 ]
-
SELECT p_update_animals (142, CAST('10297878;10286669;10289801' AS character varying), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10111301, NULL, NULL, 10236, NULL, TRUE, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
Date: 2026-03-26 10:09:10 Duration: 875ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT p_update_animals (28, CAST('10299093;10297996' AS character varying), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10111313, NULL, NULL, 8517, NULL, TRUE, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
Date: 2026-03-26 15:31:51 Duration: 690ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT p_update_animals (456, CAST('10296199;10296209' AS character varying), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10111308, NULL, NULL, 16035, NULL, TRUE, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
Date: 2026-03-26 14:31:28 Duration: 590ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,440 17m38s 509ms 2s295ms 735ms 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 #1
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - 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-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
2 1,440 17m38s 509ms 2s295ms 735ms create schema if not exists observability;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
3 1,440 17m38s 509ms 2s295ms 735ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
4 1,440 17m38s 509ms 2s295ms 735ms create table if not exists observability.app_events ( id bigserial primary key, tenant_key text not null, event_type text not null, severity text not null, message text not null, payload jsonb, occurred_at timestamptz not null default now(), created_at timestamptz not null default now() );Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - 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-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
5 1,440 17m38s 509ms 2s295ms 735ms 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 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
6 1,440 17m38s 509ms 2s295ms 735ms 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 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - 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-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
7 1,440 17m38s 509ms 2s295ms 735ms 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 #7
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - 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-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
8 1,440 17m38s 509ms 2s295ms 735ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
9 1,440 17m38s 509ms 2s295ms 735ms create table if not exists observability.system_metrics ( 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 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
10 1,440 17m38s 509ms 2s295ms 735ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
11 1,440 17m38s 509ms 2s295ms 735ms create table if not exists observability.uptime_checks ( id bigserial primary key, endpoint text not null, status text not null, latency_ms double precision, checked_at timestamptz not null default now() );Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - 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-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
12 1,440 17m38s 509ms 2s295ms 735ms 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 #12
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - 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-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
13 1,440 17m38s 509ms 2s295ms 735ms 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 #13
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - 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-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
14 18 12s673ms 688ms 729ms 704ms 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 #14
Day Hour Count Duration Avg duration Mar 26 07 3 2s76ms 692ms 08 2 1s417ms 708ms 09 4 2s841ms 710ms 10 2 1s447ms 723ms 11 2 1s392ms 696ms 13 3 2s98ms 699ms 15 2 1s400ms 700ms [ User: labanimal - Total duration: 12s673ms - Times executed: 18 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 12s673ms - Times executed: 18 ]
-
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-26 10:23:02 Duration: 729ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_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, 490) AS is_owner, user_is_tgm (animals_search_mview.editor, 490) AS is_editor, user_is_tgm (animals_search_mview.tourist, 490) 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-26 08:44:30 Duration: 718ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_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, 615) AS is_owner, user_is_tgm (animals_search_mview.editor, 615) AS is_editor, user_is_tgm (animals_search_mview.tourist, 615) 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-26 09:19:18 Duration: 717ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
15 18 11s590ms 630ms 665ms 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 #15
Day Hour Count Duration Avg duration Mar 26 07 3 1s904ms 634ms 08 2 1s299ms 649ms 09 4 2s593ms 648ms 10 2 1s329ms 664ms 11 2 1s275ms 637ms 13 3 1s911ms 637ms 15 2 1s275ms 637ms [ User: labanimal - Total duration: 11s590ms - Times executed: 18 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 11s590ms - Times executed: 18 ]
-
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-26 10:22:58 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-26_000000.csv
-
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-26 10:23:03 Duration: 663ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 490) AS is_owner, user_is_tgm (animals_search_mview.editor, 490) AS is_editor, user_is_tgm (animals_search_mview.tourist, 490) 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-26 08:44:31 Duration: 660ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
16 16 14s439ms 772ms 996ms 902ms 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 26 09 1 931ms 931ms 10 1 951ms 951ms 13 3 2s888ms 962ms 14 7 6s276ms 896ms 15 4 3s390ms 847ms [ User: labanimal - Total duration: 14s439ms - Times executed: 16 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 14s439ms - Times executed: 16 ]
-
SELECT p_update_breedings (269, NULL, 14446, '2026-03-26'::date, NULL, '10291413'::text, '10290893'::text, NULL) AS id;
Date: 2026-03-26 13:30:14 Duration: 996ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT p_update_breedings (183, NULL, 15607, '2026-03-26'::date, NULL, '10288991'::text, '10288999'::text, NULL) AS id;
Date: 2026-03-26 14:14:25 Duration: 985ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT p_update_breedings (183, NULL, 10859, '2026-03-26'::date, NULL, '10282909'::text, '10285530'::text, NULL) AS id;
Date: 2026-03-26 13:59:08 Duration: 955ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
17 12 19s696ms 1s445ms 1s737ms 1s641ms 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 cagess."cageName" like (?) 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 #17
Day Hour Count Duration Avg duration Mar 26 07 1 1s657ms 1s657ms 09 1 1s593ms 1s593ms 12 1 1s734ms 1s734ms 13 3 4s653ms 1s551ms 14 1 1s631ms 1s631ms 15 5 8s425ms 1s685ms [ User: labanimal - Total duration: 19s696ms - Times executed: 12 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 19s696ms - Times executed: 12 ]
-
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, 28) THEN TRUE WHEN user_is_tgm (dam.editor, 28) THEN TRUE WHEN user_is_tgm (dam.tourist, 28) 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, 28) THEN TRUE WHEN user_is_tgm (sire.editor, 28) THEN TRUE WHEN user_is_tgm (sire.tourist, 28) 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 cagess."cageName" like ('71%') 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-26 15:24:45 Duration: 1s737ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_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, 456) THEN TRUE WHEN user_is_tgm (dam.editor, 456) THEN TRUE WHEN user_is_tgm (dam.tourist, 456) 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, 456) THEN TRUE WHEN user_is_tgm (sire.editor, 456) THEN TRUE WHEN user_is_tgm (sire.tourist, 456) 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 cagess."cageName" like ('51-337') 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-26 12:42:57 Duration: 1s734ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_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, 456) THEN TRUE WHEN user_is_tgm (dam.editor, 456) THEN TRUE WHEN user_is_tgm (dam.tourist, 456) 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, 456) THEN TRUE WHEN user_is_tgm (sire.editor, 456) THEN TRUE WHEN user_is_tgm (sire.tourist, 456) 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 cagess."cageName" like ('51-203') 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-26 15:31:45 Duration: 1s713ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
18 6 5s244ms 764ms 1s6ms 874ms select p_update_breedings (?, ?, ?, ?::date, null, ?::text, ?::text, ?::date) as id;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 26 12 1 1s6ms 1s6ms 14 1 767ms 767ms 15 4 3s471ms 867ms [ User: labanimal - Total duration: 5s244ms - Times executed: 6 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 5s244ms - Times executed: 6 ]
-
SELECT p_update_breedings (456, 10110999, 13373, '2026-02-11'::date, NULL, '10292049'::text, '10292052'::text, '2026-03-26'::date) AS id;
Date: 2026-03-26 12:43:14 Duration: 1s6ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT p_update_breedings (456, 10110995, 7401, '2026-02-11'::date, NULL, '10292020'::text, '10292023'::text, '2026-03-26'::date) AS id;
Date: 2026-03-26 15:28:00 Duration: 985ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT p_update_breedings (456, 10110826, 13367, '2026-01-15'::date, NULL, '10286042'::text, '10283651'::text, '2026-03-26'::date) AS id;
Date: 2026-03-26 15:45:43 Duration: 952ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
19 5 3s332ms 586ms 875ms 666ms select p_update_animals (?, cast(? as character varying), null, null, null, null, null, null, null, null, null, ?, null, null, ?, null, true, null, null, null, null, null, null, null);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 26 10 1 875ms 875ms 13 1 586ms 586ms 14 1 590ms 590ms 15 2 1s279ms 639ms [ User: labanimal - Total duration: 3s332ms - Times executed: 5 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 3s332ms - Times executed: 5 ]
-
SELECT p_update_animals (142, CAST('10297878;10286669;10289801' AS character varying), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10111301, NULL, NULL, 10236, NULL, TRUE, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
Date: 2026-03-26 10:09:10 Duration: 875ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT p_update_animals (28, CAST('10299093;10297996' AS character varying), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10111313, NULL, NULL, 8517, NULL, TRUE, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
Date: 2026-03-26 15:31:51 Duration: 690ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT p_update_animals (456, CAST('10296199;10296209' AS character varying), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10111308, NULL, NULL, 16035, NULL, TRUE, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
Date: 2026-03-26 14:31:28 Duration: 590ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
20 4 4s898ms 983ms 1s467ms 1s224ms select * from p_wean_females (?, ?, ?, null, ?, ?, null, ?, ?, ?, ?, null, null, null, null, null, null, null, null, null, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 26 06 1 1s467ms 1s467ms 12 3 3s431ms 1s143ms [ User: labanimal - Total duration: 4s898ms - Times executed: 4 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 4s898ms - Times executed: 4 ]
-
SELECT * FROM p_wean_females (270, 10131615, 6, NULL, '52-187', 'B6.Trem2H157Y', NULL, 'F12', '2026-03-09', 'Trem2.H157Y(tg/tg)', 'w', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '56', 64);
Date: 2026-03-26 06:38:38 Duration: 1s467ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT * FROM p_wean_females (456, 10131674, 6, NULL, '51-178', 'B6a.TNF R1 ko', NULL, 'F28', '2026-03-05', 'TNF R1 ko', 'tgtg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '20', 18);
Date: 2026-03-26 12:44:48 Duration: 1s460ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT * FROM p_wean_females (456, 10131725, 4, NULL, '51-513', 'B6.RCL-Gi-DREADD', NULL, 'F11', '2026-03-01', 'R26-Gi-DREADD(tg/tg)', 'tgtg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '10000012', 43);
Date: 2026-03-26 12:51:54 Duration: 987ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1s445ms 1s737ms 1s641ms 12 19s696ms 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 cagess."cageName" like (?) 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 #1
Day Hour Count Duration Avg duration Mar 26 07 1 1s657ms 1s657ms 09 1 1s593ms 1s593ms 12 1 1s734ms 1s734ms 13 3 4s653ms 1s551ms 14 1 1s631ms 1s631ms 15 5 8s425ms 1s685ms [ User: labanimal - Total duration: 19s696ms - Times executed: 12 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 19s696ms - Times executed: 12 ]
-
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, 28) THEN TRUE WHEN user_is_tgm (dam.editor, 28) THEN TRUE WHEN user_is_tgm (dam.tourist, 28) 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, 28) THEN TRUE WHEN user_is_tgm (sire.editor, 28) THEN TRUE WHEN user_is_tgm (sire.tourist, 28) 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 cagess."cageName" like ('71%') 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-26 15:24:45 Duration: 1s737ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_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, 456) THEN TRUE WHEN user_is_tgm (dam.editor, 456) THEN TRUE WHEN user_is_tgm (dam.tourist, 456) 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, 456) THEN TRUE WHEN user_is_tgm (sire.editor, 456) THEN TRUE WHEN user_is_tgm (sire.tourist, 456) 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 cagess."cageName" like ('51-337') 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-26 12:42:57 Duration: 1s734ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_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, 456) THEN TRUE WHEN user_is_tgm (dam.editor, 456) THEN TRUE WHEN user_is_tgm (dam.tourist, 456) 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, 456) THEN TRUE WHEN user_is_tgm (sire.editor, 456) THEN TRUE WHEN user_is_tgm (sire.tourist, 456) 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 cagess."cageName" like ('51-203') 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-26 15:31:45 Duration: 1s713ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
2 983ms 1s467ms 1s224ms 4 4s898ms select * from p_wean_females (?, ?, ?, null, ?, ?, null, ?, ?, ?, ?, null, null, null, null, null, null, null, null, null, ?, ?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 26 06 1 1s467ms 1s467ms 12 3 3s431ms 1s143ms [ User: labanimal - Total duration: 4s898ms - Times executed: 4 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 4s898ms - Times executed: 4 ]
-
SELECT * FROM p_wean_females (270, 10131615, 6, NULL, '52-187', 'B6.Trem2H157Y', NULL, 'F12', '2026-03-09', 'Trem2.H157Y(tg/tg)', 'w', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '56', 64);
Date: 2026-03-26 06:38:38 Duration: 1s467ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT * FROM p_wean_females (456, 10131674, 6, NULL, '51-178', 'B6a.TNF R1 ko', NULL, 'F28', '2026-03-05', 'TNF R1 ko', 'tgtg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '20', 18);
Date: 2026-03-26 12:44:48 Duration: 1s460ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT * FROM p_wean_females (456, 10131725, 4, NULL, '51-513', 'B6.RCL-Gi-DREADD', NULL, 'F11', '2026-03-01', 'R26-Gi-DREADD(tg/tg)', 'tgtg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '10000012', 43);
Date: 2026-03-26 12:51:54 Duration: 987ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
3 772ms 996ms 902ms 16 14s439ms select p_update_breedings (?, null, ?, ?::date, null, ?::text, ?::text, null) as id;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 26 09 1 931ms 931ms 10 1 951ms 951ms 13 3 2s888ms 962ms 14 7 6s276ms 896ms 15 4 3s390ms 847ms [ User: labanimal - Total duration: 14s439ms - Times executed: 16 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 14s439ms - Times executed: 16 ]
-
SELECT p_update_breedings (269, NULL, 14446, '2026-03-26'::date, NULL, '10291413'::text, '10290893'::text, NULL) AS id;
Date: 2026-03-26 13:30:14 Duration: 996ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT p_update_breedings (183, NULL, 15607, '2026-03-26'::date, NULL, '10288991'::text, '10288999'::text, NULL) AS id;
Date: 2026-03-26 14:14:25 Duration: 985ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT p_update_breedings (183, NULL, 10859, '2026-03-26'::date, NULL, '10282909'::text, '10285530'::text, NULL) AS id;
Date: 2026-03-26 13:59:08 Duration: 955ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
4 764ms 1s6ms 874ms 6 5s244ms select p_update_breedings (?, ?, ?, ?::date, null, ?::text, ?::text, ?::date) as id;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 26 12 1 1s6ms 1s6ms 14 1 767ms 767ms 15 4 3s471ms 867ms [ User: labanimal - Total duration: 5s244ms - Times executed: 6 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 5s244ms - Times executed: 6 ]
-
SELECT p_update_breedings (456, 10110999, 13373, '2026-02-11'::date, NULL, '10292049'::text, '10292052'::text, '2026-03-26'::date) AS id;
Date: 2026-03-26 12:43:14 Duration: 1s6ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT p_update_breedings (456, 10110995, 7401, '2026-02-11'::date, NULL, '10292020'::text, '10292023'::text, '2026-03-26'::date) AS id;
Date: 2026-03-26 15:28:00 Duration: 985ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT p_update_breedings (456, 10110826, 13367, '2026-01-15'::date, NULL, '10286042'::text, '10283651'::text, '2026-03-26'::date) AS id;
Date: 2026-03-26 15:45:43 Duration: 952ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
5 509ms 2s295ms 735ms 1,440 17m38s 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 #5
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - 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-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
6 509ms 2s295ms 735ms 1,440 17m38s create schema if not exists observability;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-03-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
7 509ms 2s295ms 735ms 1,440 17m38s create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-03-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
8 509ms 2s295ms 735ms 1,440 17m38s 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 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - 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-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
9 509ms 2s295ms 735ms 1,440 17m38s create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-03-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
10 509ms 2s295ms 735ms 1,440 17m38s 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 #10
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - 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-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
11 509ms 2s295ms 735ms 1,440 17m38s 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 #11
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - 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-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
12 509ms 2s295ms 735ms 1,440 17m38s 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 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-03-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
13 509ms 2s295ms 735ms 1,440 17m38s create table if not exists observability.system_metrics ( 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 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-03-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
14 509ms 2s295ms 735ms 1,440 17m38s create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-03-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
15 509ms 2s295ms 735ms 1,440 17m38s 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 #15
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - 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-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
16 509ms 2s295ms 735ms 1,440 17m38s 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 #16
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - 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-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
17 509ms 2s295ms 735ms 1,440 17m38s 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 #17
Day Hour Count Duration Avg duration Mar 26 00 60 0ms 0ms 01 60 22s920ms 382ms 02 60 47s422ms 790ms 03 60 47s422ms 790ms 04 60 47s422ms 790ms 05 60 47s422ms 790ms 06 60 51s125ms 852ms 07 60 45s252ms 754ms 08 60 44s69ms 734ms 09 60 1m25s 1s433ms 10 60 58s886ms 981ms 11 60 38s875ms 647ms 12 60 57s687ms 961ms 13 60 53s362ms 889ms 14 60 48s963ms 816ms 15 60 54s198ms 903ms 16 60 38s89ms 634ms 17 60 38s89ms 634ms 18 60 38s89ms 634ms 19 60 38s89ms 634ms 20 60 38s89ms 634ms 21 60 38s89ms 634ms 22 60 38s89ms 634ms 23 60 40s953ms 682ms [ User: labanimal - Total duration: 17m38s - 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-26 10:09:01 Duration: 2s295ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 15:27:02 Duration: 1s737ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_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-26 12:43:01 Duration: 1s734ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
18 688ms 729ms 704ms 18 12s673ms 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 #18
Day Hour Count Duration Avg duration Mar 26 07 3 2s76ms 692ms 08 2 1s417ms 708ms 09 4 2s841ms 710ms 10 2 1s447ms 723ms 11 2 1s392ms 696ms 13 3 2s98ms 699ms 15 2 1s400ms 700ms [ User: labanimal - Total duration: 12s673ms - Times executed: 18 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 12s673ms - Times executed: 18 ]
-
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-26 10:23:02 Duration: 729ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_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, 490) AS is_owner, user_is_tgm (animals_search_mview.editor, 490) AS is_editor, user_is_tgm (animals_search_mview.tourist, 490) 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-26 08:44:30 Duration: 718ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_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, 615) AS is_owner, user_is_tgm (animals_search_mview.editor, 615) AS is_editor, user_is_tgm (animals_search_mview.tourist, 615) 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-26 09:19:18 Duration: 717ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
19 586ms 875ms 666ms 5 3s332ms select p_update_animals (?, cast(? as character varying), null, null, null, null, null, null, null, null, null, ?, null, null, ?, null, true, null, null, null, null, null, null, null);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 26 10 1 875ms 875ms 13 1 586ms 586ms 14 1 590ms 590ms 15 2 1s279ms 639ms [ User: labanimal - Total duration: 3s332ms - Times executed: 5 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 3s332ms - Times executed: 5 ]
-
SELECT p_update_animals (142, CAST('10297878;10286669;10289801' AS character varying), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10111301, NULL, NULL, 10236, NULL, TRUE, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
Date: 2026-03-26 10:09:10 Duration: 875ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT p_update_animals (28, CAST('10299093;10297996' AS character varying), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10111313, NULL, NULL, 8517, NULL, TRUE, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
Date: 2026-03-26 15:31:51 Duration: 690ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT p_update_animals (456, CAST('10296199;10296209' AS character varying), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10111308, NULL, NULL, 16035, NULL, TRUE, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
Date: 2026-03-26 14:31:28 Duration: 590ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
20 630ms 665ms 643ms 18 11s590ms 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 #20
Day Hour Count Duration Avg duration Mar 26 07 3 1s904ms 634ms 08 2 1s299ms 649ms 09 4 2s593ms 648ms 10 2 1s329ms 664ms 11 2 1s275ms 637ms 13 3 1s911ms 637ms 15 2 1s275ms 637ms [ User: labanimal - Total duration: 11s590ms - Times executed: 18 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 11s590ms - Times executed: 18 ]
-
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-26 10:22:58 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-26_000000.csv
-
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-26 10:23:03 Duration: 663ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 490) AS is_owner, user_is_tgm (animals_search_mview.editor, 490) AS is_editor, user_is_tgm (animals_search_mview.tourist, 490) 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-26 08:44:31 Duration: 660ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-03-26_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
- 94,452 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 12 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 12 Max number of times the same event was reported
- 12 Total events found
Rank Times reported Error 1 12 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 26 05 2 07 2 12 2 16 2 18 4 - FATAL: database "monitoring" does not exist
- FATAL: database "monitoring" does not exist
- FATAL: database "monitoring" does not exist
Date: 2026-03-26 05:36:01 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
Date: 2026-03-26 05:36:01 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv
Date: 2026-03-26 07:33:48 Database: monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-03-26_000000.csv