ZEMM PG Report-
Global information
- Generated on Mon Jun 15 06:05:34 2026
- Log file: /var/log/postgresql/postgresql-2026-05-13_000000.csv, ..., /var/log/postgresql/postgresql-2026-06-15_000000.csv
- Parsed 288,977 log entries in 5m33s
- Log start from 2026-06-03 00:00:01 to 2026-06-03 23:59:04
-
Overview
Global Stats
- 50 Number of unique normalized queries
- 24,617 Number of queries
- 6h55m35s Total query duration
- 2026-06-03 00:00:01 First query
- 2026-06-03 23:59:02 Last query
- 19 queries/s at 2026-06-03 13:20:01 Query peak
- 6h55m35s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 6h55m35s Execute total duration
- 4 Number of events
- 3 Number of unique normalized events
- 2 Max number of times the same event was reported
- 0 Number of cancellation
- 101 Total number of automatic vacuums
- 224 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 26,661 Total number of sessions
- 20 sessions at 2026-06-03 14:31:36 Session peak
- 1h34m50s Total duration of sessions
- 213ms Average duration of sessions
- 0 Average queries per session
- 935ms Average queries duration per session
- 0ms Average idle time per session
- 26,661 Total number of connections
- 37 connections/s at 2026-06-03 14:48:55 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 19 queries/s Query Peak
- 2026-06-03 13:20:01 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-06-03 09:39:57 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 17 queries/s Query Peak
- 2026-06-03 22:31:01 Date
Queries duration
Key values
- 6h55m35s 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) Jun 03 00 1,020 0ms 0ms 0ms 0ms 0ms 0ms 01 1,021 0ms 1s95ms 530ms 18s625ms 18s625ms 18s625ms 02 1,020 1s95ms 1s95ms 1s95ms 18s625ms 18s625ms 18s625ms 03 1,020 1s95ms 1s95ms 1s95ms 18s625ms 18s625ms 18s625ms 04 1,020 1s95ms 1s95ms 1s95ms 18s625ms 18s625ms 18s625ms 05 1,020 1s95ms 1s95ms 1s95ms 18s625ms 18s625ms 18s625ms 06 1,020 0ms 1s95ms 383ms 18s625ms 18s625ms 18s625ms 07 1,029 0ms 890ms 558ms 15s133ms 15s133ms 16s20ms 08 1,030 519ms 2s40ms 762ms 34s688ms 34s688ms 34s688ms 09 1,034 596ms 3s117ms 1s836ms 52s991ms 52s991ms 55s853ms 10 1,041 587ms 2s931ms 2s467ms 51s789ms 52s22ms 52s738ms 11 1,024 2s350ms 2s958ms 2s733ms 50s295ms 52s117ms 53s157ms 12 1,031 502ms 2s350ms 1s416ms 39s952ms 39s952ms 40s454ms 13 1,044 520ms 1s68ms 764ms 18s157ms 18s157ms 20s257ms 14 1,044 528ms 3s5ms 1s561ms 51s91ms 51s91ms 51s694ms 15 1,024 698ms 1s889ms 1s281ms 32s117ms 32s117ms 33s595ms 16 1,020 698ms 698ms 698ms 11s879ms 11s879ms 11s879ms 17 1,028 698ms 829ms 705ms 12s769ms 12s769ms 16s244ms 18 1,022 677ms 751ms 737ms 12s769ms 12s769ms 14s192ms 19 1,020 677ms 677ms 677ms 11s519ms 11s519ms 11s519ms 20 1,020 677ms 677ms 677ms 11s519ms 11s519ms 11s519ms 21 1,020 677ms 677ms 677ms 11s519ms 11s519ms 11s519ms 22 1,020 677ms 677ms 677ms 11s519ms 11s519ms 11s519ms 23 1,025 551ms 2s98ms 729ms 11s519ms 24s66ms 24s66ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 03 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 9 0 787ms 0ms 736ms 1s478ms 08 7 0 592ms 0ms 521ms 634ms 09 8 0 716ms 0ms 0ms 1s436ms 10 8 0 795ms 0ms 0ms 2s124ms 11 0 0 0ms 0ms 0ms 0ms 12 9 0 861ms 0ms 502ms 1s434ms 13 23 0 712ms 0ms 0ms 4s355ms 14 17 0 980ms 0ms 1s553ms 2s892ms 15 2 0 739ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 8 0 789ms 0ms 0ms 3s138ms 18 2 0 711ms 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 1s327ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 03 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 1 0 0 1s95ms 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 Jun 03 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 6 6.00 0.00% 10 0 11 11.00 0.00% 11 0 3 3.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 2 2.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 Jun 03 00 543 0.15/s 01 546 0.15/s 02 543 0.15/s 03 543 0.15/s 04 543 0.15/s 05 543 0.15/s 06 877 0.24/s 07 1,736 0.48/s 08 1,611 0.45/s 09 2,381 0.66/s 10 1,848 0.51/s 11 1,483 0.41/s 12 2,069 0.57/s 13 2,092 0.58/s 14 2,205 0.61/s 15 1,114 0.31/s 16 1,679 0.47/s 17 990 0.28/s 18 576 0.16/s 19 546 0.15/s 20 558 0.15/s 21 543 0.15/s 22 546 0.15/s 23 546 0.15/s Day Hour Count Average Duration Average idle time Jun 03 00 543 239ms 239ms 01 546 241ms 0ms 02 543 241ms 0ms 03 543 241ms 0ms 04 543 244ms 0ms 05 543 245ms 0ms 06 877 175ms 0ms 07 1,736 210ms 0ms 08 1,611 185ms 0ms 09 2,381 169ms 0ms 10 1,848 174ms 0ms 11 1,483 168ms 0ms 12 2,069 176ms 0ms 13 2,092 172ms 0ms 14 2,205 401ms 0ms 15 1,114 180ms 0ms 16 1,679 164ms 0ms 17 990 185ms 0ms 18 576 243ms 0ms 19 546 250ms 0ms 20 558 244ms 0ms 21 543 250ms 0ms 22 546 250ms 0ms 23 546 269ms 0ms -
Connections
Established Connections
Key values
- 37 connections Connection Peak
- 2026-06-03 14:48:55 Date
Connections per database
Key values
- zemm_monitoring Main Database
- 26,661 connections Total
Connections per user
Key values
- labanimal Main User
- 26,661 connections Total
-
Sessions
Simultaneous sessions
Key values
- 20 sessions Session Peak
- 2026-06-03 14:31:36 Date
Histogram of session times
Key values
- 24,355 0-500ms duration
Sessions per database
Key values
- zemm_monitoring Main Database
- 26,661 sessions Total
Sessions per user
Key values
- labanimal Main User
- 26,661 sessions Total
Sessions per host
Key values
- ::1 Main Host
- 26,661 sessions Total
Sessions per application
Key values
- Main Application
- 26,661 sessions Total
Application Count Total Duration Average Duration 21,009 1h20m2s 228ms _desktop__zemm_produktiv_8_localhost_5432 12 677ms 56ms _desktop_index.php_cage_name_50-447_cage_type_9_cage_location_5 1 44ms 44ms _desktop_index.php_cages_name_51_cages_empty__25_val4_cages_sea 2 89ms 44ms _desktop_index.php_cages_name_53_2A_cages_empty_false_val4_cage 1 82ms 82ms _desktop_index.php_command_animals_breedings_subcommand_add_bre 3 126ms 42ms _desktop_index.php_command_animals_create_multiple_subcommand_i 1 35ms 35ms _desktop_index.php_command_animals_edit_subcommand_init_id_1023 1 98ms 98ms _desktop_index.php_command_animals_edit_subcommand_init_id_1026 1 98ms 98ms _desktop_index.php_command_animals_edit_subcommand_init_id_1027 1 88ms 88ms _desktop_index.php_command_animals_edit_subcommand_init_id_1028 1 88ms 88ms _desktop_index.php_command_animals_edit_subcommand_init_id_1030 4 364ms 91ms _desktop_index.php_command_animals_litters_subcommand_init_zemm 1 34ms 34ms _desktop_index.php_command_animals_subcommand_found_val1_101000 1 43ms 43ms _desktop_index.php_command_animals_subcommand_found_val1_101001 1 49ms 49ms _desktop_index.php_command_animals_subcommand_found_val1_101003 1 45ms 45ms _desktop_index.php_command_animals_subcommand_init_zemm_produkt 32 1s405ms 43ms _desktop_index.php_command_cages_subcommand_init_zemm_produktiv 1 37ms 37ms _desktop_index.php_command_login_subcommand_init_zemm_dev_local 6 201ms 33ms _desktop_index.php_command_login_subcommand_init_zemm_produktiv 1,727 50s862ms 29ms _desktop_index.php_command_login_subcommand_init_zemm_test_loca 2 62ms 31ms _desktop_index.php_command_reports_subcommand_animals_per_room_ 6 656ms 109ms _desktop_index.php_command_reports_subcommand_animals_per_user_ 10 1s95ms 109ms _desktop_index.php_command_reports_subcommand_fates_zemm_produk 1 102ms 102ms _desktop_index.php_command_reports_subcommand_init_zemm_produkt 4 518ms 129ms _desktop_index.php_command_reports_subcommand_task_status_zemm_ 5 551ms 110ms _desktop_index.php_command_tasks_subcommand_create_task_id_53_z 1 54ms 54ms _desktop_index.php_command_tasks_subcommand_edit_id_10142733_ze 1 80ms 80ms _desktop_index.php_command_tasks_subcommand_edit_id_10143254_ze 2 159ms 79ms _desktop_index.php_command_tasks_subcommand_edit_id_10143256_ze 1 84ms 84ms _desktop_index.php_command_tasks_subcommand_edit_id_10143260_ze 1 83ms 83ms _desktop_index.php_command_tasks_subcommand_edit_id_10143366_ze 2 157ms 78ms _desktop_index.php_command_tasks_subcommand_edit_id_10143372_ze 1 86ms 86ms _desktop_index.php_command_tasks_subcommand_found_val1_404_val2 1 43ms 43ms _desktop_index.php_command_tasks_subcommand_init_template_zemm_ 26 1s70ms 41ms _desktop_index.php_command_tasks_subcommand_init_zemm_produktiv 67 5s703ms 85ms _desktop_index.php_command_tasks_subcommand_open_legacy_1_id_10 41 2s534ms 61ms _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv 2 3s768ms 1s884ms _desktop_index.php_command_tasks_subcommand_search_zemm_produkt 4 167ms 41ms _desktop_index.php_m_action_animals_3Am_delete_row_animals_1028 3 285ms 95ms _desktop_index.php_m_action_animals_3Am_delete_row_animals_1029 1 48ms 48ms _desktop_index.php_m_action_animals_3Am_delete_row_animals_1030 4 3s219ms 804ms _desktop_index.php_m_action_animals_3Am_delete_val4_animals_lis 5 456ms 91ms _desktop_index.php_m_action_animals_edit_3Alink_init_val4_repla 4 371ms 92ms _desktop_index.php_name_Barber_20Tiere_20_3E_3E_20Opfer_instruc 2 134ms 67ms _desktop_index.php_name_Genotypisierungsproben_20genommen_instr 2 86ms 43ms _desktop_index.php_name_Neue_20Aufgabe_add_link_animals_task_st 5 216ms 43ms _desktop_index.php_name_Verpaarung_20trennen_instructions_Bitte 1 61ms 61ms _desktop_index.php_name_Verpaarungen_20f_C3_BCr_20OE_20B6_instr 1 60ms 60ms _desktop_index.php_name_Verpaarungen_20f_C3_BCr_20OE_20Cxcr3_20 2 111ms 55ms _desktop_index.php_name_Verpaarungen_20f_C3_BCr_20OE_20NKp46_in 1 62ms 62ms _desktop_index.php_name_Verpaarungen_20f_C3_BCr_20OE_20Prf_20Eo 1 50ms 50ms _desktop_index.php_name_Verpaarungen_20zur_20Zucht_instructions 1 64ms 64ms _desktop_index.php_num_animals_6_species_9_sex_m_sterile_false_ 1 36ms 36ms _desktop_index.php_sire_strain_B6a.Acta2-RFP_current_only__25_v 1 1s163ms 1s163ms _desktop_index.php_view_animal_name_on_view_animal_id_on_animal 1 280ms 280ms _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b 24 10s759ms 448ms _desktop_index.php_zemm_produktiv_8_localhost_5432 3,539 12m54s 218ms backend:zemm_produktiv_8@localhost 47 3s125ms 66ms bounces:zemm_produktiv_8@h2940066.stratoserver.net:5432 1 61ms 61ms expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 1 1s112ms 1s112ms pg_dump 1 10s688ms 10s688ms psql 3 10ms 3ms taskscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 24 9s168ms 382ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 19,607 buffers Checkpoint Peak
- 2026-06-03 01:39:00 Date
- 269.947 seconds Highest write time
- 0.032 seconds Sync time
Checkpoints Wal files
Key values
- 7 files Wal files usage Peak
- 2026-06-03 01:39:00 Date
Checkpoints distance
Key values
- 218.88 Mo Distance Peak
- 2026-06-03 01:39:00 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 03 00 7,656 766.454s 0.103s 766.611s 01 27,117 1,021.647s 0.102s 1,021.826s 02 12,822 1,123.373s 0.102s 1,123.538s 03 8,484 848.875s 0.1s 849.031s 04 7,604 760.815s 0.098s 760.99s 05 8,274 827.945s 0.108s 828.11s 06 8,909 826.233s 0.167s 826.462s 07 12,659 1,267.048s 0.281s 1,267.382s 08 11,451 1,146.226s 0.247s 1,146.544s 09 22,487 1,401.869s 0.242s 1,402.171s 10 9,922 993.479s 0.2s 993.737s 11 11,058 1,106.183s 0.186s 1,106.419s 12 12,075 1,207.897s 0.279s 1,208.229s 13 10,712 1,071.676s 0.248s 1,071.979s 14 14,534 1,321.767s 0.269s 1,322.101s 15 8,984 898.606s 0.178s 898.843s 16 9,453 945.794s 0.191s 946.063s 17 9,097 910.214s 0.184s 910.46s 18 8,449 846.2s 0.125s 846.385s 19 8,232 823.441s 0.1s 823.601s 20 8,219 822.715s 0.106s 822.878s 21 8,039 804.482s 0.105s 804.645s 22 7,488 749.789s 0.101s 749.95s 23 10,516 1,052.026s 0.111s 1,052.196s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 03 00 0 0 2 543 0.002s 0.012s 01 0 0 8 550 0.002s 0.012s 02 0 0 2 531 0.001s 0.012s 03 0 0 2 534 0.001s 0.012s 04 0 0 2 531 0.001s 0.012s 05 0 0 1 527 0.007s 0.012s 06 0 0 2 870 0.005s 0.013s 07 0 0 3 1,601 0.003s 0.012s 08 0 0 2 1,460 0.002s 0.012s 09 0 0 6 1,370 0.004s 0.012s 10 0 0 2 1,136 0.002s 0.012s 11 0 0 2 1,069 0.002s 0.012s 12 0 0 3 1,665 0.002s 0.012s 13 0 0 2 1,507 0.002s 0.012s 14 0 0 6 1,604 0.002s 0.012s 15 0 0 2 980 0.002s 0.012s 16 0 0 2 1,092 0.002s 0.012s 17 0 0 1 1,014 0.004s 0.012s 18 0 0 2 605 0.004s 0.012s 19 0 0 2 534 0.001s 0.012s 20 0 0 2 531 0.003s 0.012s 21 0 0 1 525 0.003s 0.012s 22 0 0 2 533 0.002s 0.012s 23 0 0 2 556 0.003s 0.012s Day Hour Count Avg time (sec) Jun 03 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 Jun 03 00 2,150.25 kB 3,270.00 kB 01 11,394.92 kB 40,170.92 kB 02 2,992.17 kB 41,411.75 kB 03 2,408.08 kB 13,468.92 kB 04 2,181.42 kB 5,450.25 kB 05 2,317.75 kB 3,197.42 kB 06 2,361.85 kB 2,789.69 kB 07 3,721.17 kB 5,389.92 kB 08 3,266.42 kB 4,658.50 kB 09 7,524.67 kB 18,623.67 kB 10 2,762.08 kB 11,560.50 kB 11 3,064.25 kB 5,335.58 kB 12 3,548.67 kB 4,112.25 kB 13 3,172.50 kB 3,992.00 kB 14 7,672.00 kB 20,292.67 kB 15 2,591.08 kB 20,012.67 kB 16 2,773.00 kB 7,524.50 kB 17 2,585.08 kB 4,096.17 kB 18 2,349.83 kB 3,321.25 kB 19 2,354.50 kB 3,071.42 kB 20 2,305.08 kB 3,077.92 kB 21 2,267.00 kB 2,883.17 kB 22 2,113.42 kB 2,973.33 kB 23 2,708.33 kB 3,670.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 Jun 03 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.88 sec Highest CPU-cost vacuum
Table observability.uptime_checks
Database zemm_monitoring - 2026-06-03 02:08:20 Date
- 0 sec Highest CPU-cost analyze
Table
Database zemm_monitoring - Date
Average Autovacuum Duration
Key values
- 0.88 sec Highest CPU-cost vacuum
Table observability.uptime_checks
Database zemm_monitoring - 2026-06-03 02:08:20 Date
Analyzes per table
Key values
- pg_catalog.pg_type (62) Main table analyzed (database zemm_produktiv_8)
- 224 analyzes Total
Table Number of analyzes zemm_produktiv_8.pg_catalog.pg_type 62 zemm_produktiv_8.pg_catalog.pg_attribute 46 zemm_produktiv_8.pg_catalog.pg_class 36 zemm_produktiv_8.pg_catalog.pg_depend 32 template0.pg_catalog.pg_shdepend 6 postgres.pg_catalog.pg_shdepend 5 zemm_produktiv_8.public.cages_search_mview 4 invdb.pg_catalog.pg_shdepend 4 fbi_ci_db.pg_catalog.pg_shdepend 3 zemm_produktiv_8.pg_catalog.pg_shdepend 3 zemm_produktiv_8.public.tmptasks 3 zemm_produktiv_8.public.users 2 fbi_unibi.pg_catalog.pg_shdepend 2 zemm_monitoring.pg_catalog.pg_shdepend 2 template1.pg_catalog.pg_shdepend 2 zemm_monitoring.observability.metrics_timeseries 2 fbi_unire.pg_catalog.pg_shdepend 2 zemm_test.pg_catalog.pg_shdepend 1 labanimal.pg_catalog.pg_shdepend 1 zemm_dev.pg_catalog.pg_shdepend 1 zemm_produktiv_8.public.cages 1 zemm_produktiv_8.public.tasks 1 zemm_produktiv_8.public.login_tracker 1 zemm_produktiv_8.public.monitoring_session_activity 1 zemm_produktiv_8.public.cost_history 1 Total 224 Vacuums per table
Key values
- pg_catalog.pg_type (24) Main table vacuumed on database zemm_produktiv_8
- 101 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples zemm_produktiv_8.pg_catalog.pg_type 24 24 0 0 0 0 0 1,343 230 334,540 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 21 21 0 0 0 0 0 4,341 645 942,034 0 0 zemm_produktiv_8.pg_catalog.pg_class 14 14 0 0 0 0 0 1,200 291 382,114 0 0 zemm_produktiv_8.pg_catalog.pg_depend 14 14 0 0 0 0 0 2,130 350 625,484 0 0 zemm_produktiv_8.pg_toast.pg_toast_2619 5 5 0 0 0 0 0 994 228 1,177,559 41 123 zemm_monitoring.pg_toast.pg_toast_181881 3 0 0 0 0 0 0 942 321 1,581,449 309 1,644 labanimal.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 200 29 73,331 0 0 template0.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 211 62 140,212 0 0 fbi_ci_db.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 216 24 69,015 0 0 zemm_monitoring.pg_toast.pg_toast_67431 3 0 0 0 0 0 0 5,430 2,086 6,238,207 1,246 7,476 invdb.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 155 4 26,905 0 0 zemm_produktiv_8.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 150 22 63,959 0 0 zemm_monitoring.observability.uptime_checks 1 0 0 0 0 0 0 3,910 3,671 5,756,003 119 2,380 zemm_produktiv_8.public.tmptasks 1 1 0 0 0 0 0 92 31 18,755 0 0 zemm_produktiv_8.public.cages_search_mview 1 1 0 0 0 0 0 764 382 1,263,240 47 204 zemm_produktiv_8.public.tasks 1 1 0 0 0 0 0 51,088 51 3,852,282 0 0 Total 101 94 0 0 0 0 0 73,166 8,427 22,545,089 1,762 11,827 Vacuum throughput per table
Key values
- observability.uptime_checks (0.88) Max CPU elapsed for vacuum on database zemm_monitoring
- pg_toast.pg_toast_67431 (1.775 ms) Max I/O read time for vacuum on database zemm_monitoring
- pg_toast.pg_toast_67431 (0.035 ms) Max I/O write time for vacuum on database zemm_monitoring
I/O timing (ms) CPU (s) Table read write elapsed zemm_produktiv_8.pg_catalog.pg_type 0.34 0 0.01 zemm_produktiv_8.pg_catalog.pg_attribute 0.736 0.024 0.21 zemm_produktiv_8.pg_catalog.pg_class 0.441 0 0.01 zemm_produktiv_8.pg_catalog.pg_depend 0.349 0 0.12 zemm_produktiv_8.pg_toast.pg_toast_2619 0.465 0 0.05 zemm_monitoring.pg_toast.pg_toast_181881 0.466 0 0.06 labanimal.pg_catalog.pg_shdepend 0.039 0 0 template0.pg_catalog.pg_shdepend 0.131 0 0 fbi_ci_db.pg_catalog.pg_shdepend 0 0 0 zemm_monitoring.pg_toast.pg_toast_67431 1.775 0.035 0.53 invdb.pg_catalog.pg_shdepend 0 0 0 zemm_produktiv_8.pg_catalog.pg_shdepend 0 0 0 zemm_monitoring.observability.uptime_checks 0.385 0 0.88 zemm_produktiv_8.public.tmptasks 0.142 0 0.01 zemm_produktiv_8.public.cages_search_mview 0.617 0 0.1 zemm_produktiv_8.public.tasks 0 0 0.66 Total 5.886 0.059 2.64 Tuples removed per table
Key values
- public.tasks (54842) Main table with removed tuples on database zemm_produktiv_8
- 95874 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain zemm_produktiv_8.public.tasks 1 1 54,842 57,960 0 0 17,131 zemm_produktiv_8.pg_catalog.pg_attribute 21 21 19,579 115,119 0 123 3,987 zemm_produktiv_8.pg_catalog.pg_depend 14 14 7,520 59,612 9 17 787 zemm_monitoring.pg_toast.pg_toast_67431 3 0 5,036 1,966,368 0 0 393,429 zemm_produktiv_8.pg_catalog.pg_type 24 24 3,941 19,944 0 16 760 zemm_produktiv_8.pg_catalog.pg_class 14 14 1,895 12,642 0 0 588 zemm_produktiv_8.pg_toast.pg_toast_2619 5 5 566 1,460 0 0 530 template0.pg_catalog.pg_shdepend 3 3 524 14,115 0 0 114 invdb.pg_catalog.pg_shdepend 2 2 515 9,410 0 0 77 fbi_ci_db.pg_catalog.pg_shdepend 3 3 450 14,115 0 0 115 labanimal.pg_catalog.pg_shdepend 3 3 389 14,115 0 0 116 zemm_produktiv_8.public.cages_search_mview 1 1 267 13,885 0 0 234 zemm_produktiv_8.pg_catalog.pg_shdepend 2 2 263 9,431 21 0 76 zemm_produktiv_8.public.tmptasks 1 1 87 814 0 10 115 zemm_monitoring.pg_toast.pg_toast_181881 3 0 0 77,225 0 0 14,057 zemm_monitoring.observability.uptime_checks 1 0 0 403,328 0 0 20,280 Total 101 94 95,874 2,789,543 30 166 452,396 Pages removed per table
Key values
- pg_catalog.pg_attribute (123) Main table with removed pages on database zemm_produktiv_8
- 166 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed zemm_produktiv_8.pg_catalog.pg_attribute 21 21 19579 123 zemm_produktiv_8.pg_catalog.pg_depend 14 14 7520 17 zemm_produktiv_8.pg_catalog.pg_type 24 24 3941 16 zemm_produktiv_8.public.tmptasks 1 1 87 10 zemm_monitoring.pg_toast.pg_toast_181881 3 0 0 0 zemm_monitoring.observability.uptime_checks 1 0 0 0 labanimal.pg_catalog.pg_shdepend 3 3 389 0 zemm_produktiv_8.pg_toast.pg_toast_2619 5 5 566 0 invdb.pg_catalog.pg_shdepend 2 2 515 0 template0.pg_catalog.pg_shdepend 3 3 524 0 zemm_produktiv_8.pg_catalog.pg_class 14 14 1895 0 zemm_produktiv_8.public.cages_search_mview 1 1 267 0 zemm_produktiv_8.public.tasks 1 1 54842 0 fbi_ci_db.pg_catalog.pg_shdepend 3 3 450 0 zemm_produktiv_8.pg_catalog.pg_shdepend 2 2 263 0 zemm_monitoring.pg_toast.pg_toast_67431 3 0 5036 0 Total 101 94 95,874 166 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 03 00 0 0 01 2 1 02 2 0 03 0 0 04 0 0 05 0 0 06 5 8 07 10 30 08 5 15 09 8 16 10 1 7 11 6 18 12 8 24 13 6 16 14 36 59 15 3 9 16 5 14 17 3 6 18 0 0 19 1 0 20 0 0 21 0 0 22 0 0 23 0 1 - 0.88 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
- 93 Total read queries
- 24,524 Total write queries
Queries by database
Key values
- zemm_monitoring Main database
- 24,502 Requests
- 6h53m51s (zemm_monitoring)
- Main time consuming database
Queries by user
Key values
- monitoring_admin Main user
- 541,140 Requests
User Request type Count Duration labanimal Total 1,897 42m36s copy to 8 22s808ms cte 321 7m4s select 1,546 34m45s update 22 23s995ms monitoring_admin Total 541,140 30d19h58m30s cte 1,796 4h4m19s ddl 538,488 30d15h41m52s delete 1 603ms select 850 12m13s postgres Total 115 2m37s copy to 115 2m37s Duration by user
Key values
- 30d19h58m30s (monitoring_admin) Main time consuming user
User Request type Count Duration labanimal Total 1,897 42m36s copy to 8 22s808ms cte 321 7m4s select 1,546 34m45s update 22 23s995ms monitoring_admin Total 541,140 30d19h58m30s cte 1,796 4h4m19s ddl 538,488 30d15h41m52s delete 1 603ms select 850 12m13s postgres Total 115 2m37s copy to 115 2m37s Queries by host
Key values
- unknown Main host
- 543,015 Requests
- 30d20h40m42s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 24,502 Requests
- 6h53m51s (unknown)
- Main time consuming application
Application Request type Count Duration _desktop_index.php_sire_strain_B6a.Acta2-RFP_current_only__25_v Total 1 1s119ms cte 1 1s119ms _desktop_index.php_zemm_produktiv_8_localhost_5432 Total 108 1m35s cte 15 21s661ms select 93 1m13s expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 Total 1 1s95ms update 1 1s95ms pg_dump Total 5 6s636ms copy to 5 6s636ms unknown Total 24,502 6h53m51s cte 22 1m1s ddl 24,480 6h52m50s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-03 09:30:47 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 86 500-1000ms duration
Slowest individual queries
Rank Duration Query 1 3s117ms WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at >= '2026-05-31 21:19:25+02' AND collected_at <= '2026-06-02 21:19:25+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 21:19:25+02' AND '2026-06-03 09:19:25+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 21:19:25+02' AND '2026-06-03 09:19:25+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';[ Date: 2026-06-03 09:19:28 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
2 3s117ms CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-06-03 09:20:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
3 3s117ms 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-06-03 09:20:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
4 3s117ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-06-03 09:20:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
5 3s117ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-06-03 09:20:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
6 3s117ms 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-06-03 09:20:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
7 3s117ms CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);[ Date: 2026-06-03 09:20:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
8 3s117ms CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);[ Date: 2026-06-03 09:20:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
9 3s117ms 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-06-03 09:20:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
10 3s117ms CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);[ Date: 2026-06-03 09:20:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
11 3s117ms 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-06-03 09:20:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
12 3s117ms 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-06-03 09:20:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
13 3s117ms 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-06-03 09:20:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
14 3s117ms 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-06-03 09:20:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
15 3s117ms ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;[ Date: 2026-06-03 09:20:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
16 3s117ms ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;[ Date: 2026-06-03 09:20:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
17 3s117ms CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);[ Date: 2026-06-03 09:20:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
18 3s117ms CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);[ Date: 2026-06-03 09:20:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
19 3s117ms CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-06-03 09:21:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
20 3s117ms 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-06-03 09:21:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 24m17s 1,440 502ms 3s117ms 1s11ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
2 24m17s 1,440 502ms 3s117ms 1s11ms 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 #2
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
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-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
3 24m17s 1,440 502ms 3s117ms 1s11ms 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 #3
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
4 24m17s 1,440 502ms 3s117ms 1s11ms create schema if not exists observability;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
5 24m17s 1,440 502ms 3s117ms 1s11ms 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 #5
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
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-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
6 24m17s 1,440 502ms 3s117ms 1s11ms create index if not exists idx_uptime_checks_key on observability.uptime_checks (check_key, checked_at desc);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
7 24m17s 1,440 502ms 3s117ms 1s11ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
8 24m17s 1,440 502ms 3s117ms 1s11ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
9 24m17s 1,440 502ms 3s117ms 1s11ms create table if not exists observability.phpfpm_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
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-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
10 24m17s 1,440 502ms 3s117ms 1s11ms alter table observability.uptime_checks add column if not exists label text;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
11 24m17s 1,440 502ms 3s117ms 1s11ms create table if not exists observability.db_top_queries ( id bigserial primary key, tenant_key text not null, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz not null default now() );Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
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-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
12 24m17s 1,440 502ms 3s117ms 1s11ms 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 #12
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
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-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
13 24m17s 1,440 502ms 3s117ms 1s11ms create index if not exists idx_uptime_checks_endpoint on observability.uptime_checks (endpoint, checked_at desc);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
14 24m17s 1,440 502ms 3s117ms 1s11ms alter table observability.uptime_checks add column if not exists payload jsonb;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
15 24m17s 1,440 502ms 3s117ms 1s11ms 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 #15
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
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-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
16 24m17s 1,440 502ms 3s117ms 1s11ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
17 24m17s 1,440 502ms 3s117ms 1s11ms 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 #17
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
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-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
18 1m1s 22 1s420ms 3s117ms 2s778ms with start_snap as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at >= ? and collected_at <= ? order by tenant_key, fingerprint, collected_at desc ), fallback_start as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at between ? and ? order by tenant_key, fingerprint, collected_at asc ), end_snap as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at between ? and ? order by tenant_key, fingerprint, collected_at desc ), deltas as ( select e.tenant_key, e.fingerprint, e.query, e.collected_at as last_seen, greatest (coalesce(e.total_time_ms, ?) - coalesce(s.total_time_ms, fs.total_time_ms, ?), ?) as total_time_ms, greatest (coalesce(e.calls, ?) - coalesce(s.calls, fs.calls, ?), ?) as calls, greatest (coalesce(e.rows_returned, ?) - coalesce(s.rows_returned, fs.rows_returned, ?), ?) as rows_returned from end_snap e left join start_snap s on s.tenant_key = e.tenant_key and s.fingerprint = e.fingerprint left join fallback_start fs on fs.tenant_key = e.tenant_key and fs.fingerprint = e.fingerprint and s.tenant_key is null ) select fingerprint, max(query) as query, max(last_seen) as last_seen, sum(total_time_ms) as total_time_ms, sum(calls) as calls, sum(rows_returned) as rows_returned, case when sum(calls) > ? then sum(total_time_ms) / sum(calls) else ? end as mean_time_ms, array_agg(distinct tenant_key order by tenant_key) as tenant_keys from deltas where total_time_ms > ? or calls > ? group by fingerprint order by total_time_ms desc, calls desc limit ? offset ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 03 10 6 17s560ms 2s926ms 11 11 30s225ms 2s747ms 12 3 8s724ms 2s908ms 15 2 4s609ms 2s304ms [ User: monitoring_admin - Total duration: 1m1s - Times executed: 22 ]
-
WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at >= '2026-05-31 21:19:25+02' AND collected_at <= '2026-06-02 21:19:25+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 21:19:25+02' AND '2026-06-03 09:19:25+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 21:19:25+02' AND '2026-06-03 09:19:25+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-06-03 09:19:28 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at >= '2026-06-01 02:31:54+02' AND collected_at <= '2026-06-03 02:31:54+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-03 02:31:54+02' AND '2026-06-03 14:31:54+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-03 02:31:54+02' AND '2026-06-03 14:31:54+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-06-03 14:31:57 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at >= '2026-05-31 21:45:00+02' AND collected_at <= '2026-06-02 21:45:00+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 21:45:00+02' AND '2026-06-03 09:45:00+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 21:45:00+02' AND '2026-06-03 09:45:00+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-06-03 09:45:03 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
19 17s344ms 23 742ms 787ms 754ms 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 #19
Day Hour Count Duration Avg duration Jun 03 08 1 787ms 787ms 10 4 2s997ms 749ms 11 2 1s508ms 754ms 13 2 1s493ms 746ms 14 11 8s297ms 754ms 15 2 1s513ms 756ms 19 1 745ms 745ms [ User: labanimal - Total duration: 17s344ms - Times executed: 23 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 17s344ms - Times executed: 23 ]
-
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-06-03 07:19:42 Duration: 787ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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, 10100189) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100189) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100189) 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-06-03 13:19:56 Duration: 769ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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, 10100189) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100189) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100189) 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-06-03 13:24:12 Duration: 761ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
20 15s799ms 23 677ms 708ms 686ms 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 Jun 03 08 1 691ms 691ms 10 4 2s735ms 683ms 11 2 1s371ms 685ms 13 2 1s371ms 685ms 14 11 7s573ms 688ms 15 2 1s378ms 689ms 19 1 677ms 677ms [ User: labanimal - Total duration: 15s799ms - Times executed: 23 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 15s799ms - Times executed: 23 ]
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100189) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100189) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100189) 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-06-03 13:19:57 Duration: 708ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100189) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100189) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100189) 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-06-03 13:24:13 Duration: 700ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100189) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100189) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100189) 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-06-03 13:24:18 Duration: 692ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,440 24m17s 502ms 3s117ms 1s11ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
2 1,440 24m17s 502ms 3s117ms 1s11ms 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 #2
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
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-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
3 1,440 24m17s 502ms 3s117ms 1s11ms 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 #3
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
4 1,440 24m17s 502ms 3s117ms 1s11ms create schema if not exists observability;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
5 1,440 24m17s 502ms 3s117ms 1s11ms 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 #5
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
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-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
6 1,440 24m17s 502ms 3s117ms 1s11ms create index if not exists idx_uptime_checks_key on observability.uptime_checks (check_key, checked_at desc);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
7 1,440 24m17s 502ms 3s117ms 1s11ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
8 1,440 24m17s 502ms 3s117ms 1s11ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
9 1,440 24m17s 502ms 3s117ms 1s11ms create table if not exists observability.phpfpm_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
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-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
10 1,440 24m17s 502ms 3s117ms 1s11ms alter table observability.uptime_checks add column if not exists label text;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
11 1,440 24m17s 502ms 3s117ms 1s11ms create table if not exists observability.db_top_queries ( id bigserial primary key, tenant_key text not null, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz not null default now() );Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
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-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
12 1,440 24m17s 502ms 3s117ms 1s11ms 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 #12
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
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-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
13 1,440 24m17s 502ms 3s117ms 1s11ms create index if not exists idx_uptime_checks_endpoint on observability.uptime_checks (endpoint, checked_at desc);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
14 1,440 24m17s 502ms 3s117ms 1s11ms alter table observability.uptime_checks add column if not exists payload jsonb;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
15 1,440 24m17s 502ms 3s117ms 1s11ms 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 #15
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
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-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
16 1,440 24m17s 502ms 3s117ms 1s11ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
17 1,440 24m17s 502ms 3s117ms 1s11ms 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 #17
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
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-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
18 23 17s344ms 742ms 787ms 754ms 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 Jun 03 08 1 787ms 787ms 10 4 2s997ms 749ms 11 2 1s508ms 754ms 13 2 1s493ms 746ms 14 11 8s297ms 754ms 15 2 1s513ms 756ms 19 1 745ms 745ms [ User: labanimal - Total duration: 17s344ms - Times executed: 23 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 17s344ms - Times executed: 23 ]
-
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-06-03 07:19:42 Duration: 787ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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, 10100189) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100189) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100189) 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-06-03 13:19:56 Duration: 769ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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, 10100189) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100189) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100189) 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-06-03 13:24:12 Duration: 761ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
19 23 15s799ms 677ms 708ms 686ms 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 #19
Day Hour Count Duration Avg duration Jun 03 08 1 691ms 691ms 10 4 2s735ms 683ms 11 2 1s371ms 685ms 13 2 1s371ms 685ms 14 11 7s573ms 688ms 15 2 1s378ms 689ms 19 1 677ms 677ms [ User: labanimal - Total duration: 15s799ms - Times executed: 23 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 15s799ms - Times executed: 23 ]
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100189) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100189) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100189) 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-06-03 13:19:57 Duration: 708ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100189) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100189) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100189) 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-06-03 13:24:13 Duration: 700ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100189) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100189) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100189) 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-06-03 13:24:18 Duration: 692ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
20 22 1m1s 1s420ms 3s117ms 2s778ms with start_snap as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at >= ? and collected_at <= ? order by tenant_key, fingerprint, collected_at desc ), fallback_start as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at between ? and ? order by tenant_key, fingerprint, collected_at asc ), end_snap as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at between ? and ? order by tenant_key, fingerprint, collected_at desc ), deltas as ( select e.tenant_key, e.fingerprint, e.query, e.collected_at as last_seen, greatest (coalesce(e.total_time_ms, ?) - coalesce(s.total_time_ms, fs.total_time_ms, ?), ?) as total_time_ms, greatest (coalesce(e.calls, ?) - coalesce(s.calls, fs.calls, ?), ?) as calls, greatest (coalesce(e.rows_returned, ?) - coalesce(s.rows_returned, fs.rows_returned, ?), ?) as rows_returned from end_snap e left join start_snap s on s.tenant_key = e.tenant_key and s.fingerprint = e.fingerprint left join fallback_start fs on fs.tenant_key = e.tenant_key and fs.fingerprint = e.fingerprint and s.tenant_key is null ) select fingerprint, max(query) as query, max(last_seen) as last_seen, sum(total_time_ms) as total_time_ms, sum(calls) as calls, sum(rows_returned) as rows_returned, case when sum(calls) > ? then sum(total_time_ms) / sum(calls) else ? end as mean_time_ms, array_agg(distinct tenant_key order by tenant_key) as tenant_keys from deltas where total_time_ms > ? or calls > ? group by fingerprint order by total_time_ms desc, calls desc limit ? offset ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 03 10 6 17s560ms 2s926ms 11 11 30s225ms 2s747ms 12 3 8s724ms 2s908ms 15 2 4s609ms 2s304ms [ User: monitoring_admin - Total duration: 1m1s - Times executed: 22 ]
-
WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at >= '2026-05-31 21:19:25+02' AND collected_at <= '2026-06-02 21:19:25+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 21:19:25+02' AND '2026-06-03 09:19:25+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 21:19:25+02' AND '2026-06-03 09:19:25+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-06-03 09:19:28 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at >= '2026-06-01 02:31:54+02' AND collected_at <= '2026-06-03 02:31:54+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-03 02:31:54+02' AND '2026-06-03 14:31:54+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-03 02:31:54+02' AND '2026-06-03 14:31:54+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-06-03 14:31:57 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at >= '2026-05-31 21:45:00+02' AND collected_at <= '2026-06-02 21:45:00+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 21:45:00+02' AND '2026-06-03 09:45:00+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 21:45:00+02' AND '2026-06-03 09:45:00+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-06-03 09:45:03 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1s420ms 3s117ms 2s778ms 22 1m1s with start_snap as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at >= ? and collected_at <= ? order by tenant_key, fingerprint, collected_at desc ), fallback_start as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at between ? and ? order by tenant_key, fingerprint, collected_at asc ), end_snap as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at between ? and ? order by tenant_key, fingerprint, collected_at desc ), deltas as ( select e.tenant_key, e.fingerprint, e.query, e.collected_at as last_seen, greatest (coalesce(e.total_time_ms, ?) - coalesce(s.total_time_ms, fs.total_time_ms, ?), ?) as total_time_ms, greatest (coalesce(e.calls, ?) - coalesce(s.calls, fs.calls, ?), ?) as calls, greatest (coalesce(e.rows_returned, ?) - coalesce(s.rows_returned, fs.rows_returned, ?), ?) as rows_returned from end_snap e left join start_snap s on s.tenant_key = e.tenant_key and s.fingerprint = e.fingerprint left join fallback_start fs on fs.tenant_key = e.tenant_key and fs.fingerprint = e.fingerprint and s.tenant_key is null ) select fingerprint, max(query) as query, max(last_seen) as last_seen, sum(total_time_ms) as total_time_ms, sum(calls) as calls, sum(rows_returned) as rows_returned, case when sum(calls) > ? then sum(total_time_ms) / sum(calls) else ? end as mean_time_ms, array_agg(distinct tenant_key order by tenant_key) as tenant_keys from deltas where total_time_ms > ? or calls > ? group by fingerprint order by total_time_ms desc, calls desc limit ? offset ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 03 10 6 17s560ms 2s926ms 11 11 30s225ms 2s747ms 12 3 8s724ms 2s908ms 15 2 4s609ms 2s304ms [ User: monitoring_admin - Total duration: 1m1s - Times executed: 22 ]
-
WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at >= '2026-05-31 21:19:25+02' AND collected_at <= '2026-06-02 21:19:25+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 21:19:25+02' AND '2026-06-03 09:19:25+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 21:19:25+02' AND '2026-06-03 09:19:25+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-06-03 09:19:28 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at >= '2026-06-01 02:31:54+02' AND collected_at <= '2026-06-03 02:31:54+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-03 02:31:54+02' AND '2026-06-03 14:31:54+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-03 02:31:54+02' AND '2026-06-03 14:31:54+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-06-03 14:31:57 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
WITH start_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at >= '2026-05-31 21:45:00+02' AND collected_at <= '2026-06-02 21:45:00+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 21:45:00+02' AND '2026-06-03 09:45:00+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 21:45:00+02' AND '2026-06-03 09:45:00+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-06-03 09:45:03 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
2 502ms 3s117ms 1s11ms 1,440 24m17s create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
3 502ms 3s117ms 1s11ms 1,440 24m17s create table if not exists observability.app_events ( id bigserial primary key, tenant_key text not null, event_type text not null, severity text not null, message text not null, payload jsonb, occurred_at timestamptz not null default now(), created_at timestamptz not null default now() );Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
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-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
4 502ms 3s117ms 1s11ms 1,440 24m17s 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 #4
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
5 502ms 3s117ms 1s11ms 1,440 24m17s create schema if not exists observability;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
6 502ms 3s117ms 1s11ms 1,440 24m17s 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 Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
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-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
7 502ms 3s117ms 1s11ms 1,440 24m17s create index if not exists idx_uptime_checks_key on observability.uptime_checks (check_key, checked_at desc);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
8 502ms 3s117ms 1s11ms 1,440 24m17s 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 Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
9 502ms 3s117ms 1s11ms 1,440 24m17s create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
10 502ms 3s117ms 1s11ms 1,440 24m17s create table if not exists observability.phpfpm_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
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-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
11 502ms 3s117ms 1s11ms 1,440 24m17s alter table observability.uptime_checks add column if not exists label text;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
12 502ms 3s117ms 1s11ms 1,440 24m17s 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 #12
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
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-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
13 502ms 3s117ms 1s11ms 1,440 24m17s 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 Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
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-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
14 502ms 3s117ms 1s11ms 1,440 24m17s create index if not exists idx_uptime_checks_endpoint on observability.uptime_checks (endpoint, checked_at desc);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
15 502ms 3s117ms 1s11ms 1,440 24m17s alter table observability.uptime_checks add column if not exists payload jsonb;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
16 502ms 3s117ms 1s11ms 1,440 24m17s 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 #16
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
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-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
17 502ms 3s117ms 1s11ms 1,440 24m17s create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
18 502ms 3s117ms 1s11ms 1,440 24m17s 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 #18
Day Hour Count Duration Avg duration Jun 03 01 60 0ms 0ms 02 60 31s772ms 529ms 03 60 1m5s 1s95ms 04 60 1m5s 1s95ms 05 60 1m5s 1s95ms 06 60 1m5s 1s95ms 07 60 23s7ms 383ms 08 60 33s386ms 556ms 09 60 45s628ms 760ms 10 60 1m50s 1s838ms 11 60 2m28s 2s480ms 12 60 2m44s 2s733ms 13 60 1m25s 1s421ms 14 60 45s895ms 764ms 15 60 1m34s 1s572ms 16 60 1m16s 1s281ms 17 60 41s927ms 698ms 18 60 42s313ms 705ms 19 60 44s259ms 737ms 20 60 40s658ms 677ms 21 60 40s658ms 677ms 22 60 40s658ms 677ms 23 60 40s658ms 677ms 00 60 43s610ms 726ms [ User: monitoring_admin - Total duration: 24m17s - Times executed: 1297 ]
-
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-06-03 09:29:01 Duration: 3s117ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 14:45:01 Duration: 3s5ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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-06-03 09:50:01 Duration: 2s988ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
19 742ms 787ms 754ms 23 17s344ms 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 #19
Day Hour Count Duration Avg duration Jun 03 08 1 787ms 787ms 10 4 2s997ms 749ms 11 2 1s508ms 754ms 13 2 1s493ms 746ms 14 11 8s297ms 754ms 15 2 1s513ms 756ms 19 1 745ms 745ms [ User: labanimal - Total duration: 17s344ms - Times executed: 23 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 17s344ms - Times executed: 23 ]
-
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-06-03 07:19:42 Duration: 787ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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, 10100189) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100189) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100189) 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-06-03 13:19:56 Duration: 769ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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, 10100189) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100189) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100189) 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-06-03 13:24:12 Duration: 761ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
20 677ms 708ms 686ms 23 15s799ms 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 Jun 03 08 1 691ms 691ms 10 4 2s735ms 683ms 11 2 1s371ms 685ms 13 2 1s371ms 685ms 14 11 7s573ms 688ms 15 2 1s378ms 689ms 19 1 677ms 677ms [ User: labanimal - Total duration: 15s799ms - Times executed: 23 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 15s799ms - Times executed: 23 ]
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100189) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100189) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100189) 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-06-03 13:19:57 Duration: 708ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100189) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100189) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100189) 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-06-03 13:24:13 Duration: 700ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
-
SELECT DISTINCT * FROM ( SELECT animals_search_mview.*, b.unbreeding_date, fates.loc AS fate_name, user_is_tgm (animals_search_mview.owner, 10100189) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100189) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100189) 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-06-03 13:24:18 Duration: 692ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-03_062044.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
- 132,178 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 4 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2 Max number of times the same event was reported
- 4 Total events found
Rank Times reported Error 1 2 ERROR: invalid input syntax for type date: ...
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 03 10 1 13 1 - ERROR: invalid input syntax for type date: ""
- ERROR: invalid input syntax for type date: "2026-06.03"
Statement: SELECT p_update_animals(456, '10299753', '', NULL, '', false,'', '', false, '', '', NULL, 0, 'Barberopfer Gesicht und entzündete Augen', NULL, '', false,'','',NULL, '','',NULL,0);
Date: 2026-06-03 09:10:56 Database: zemm_produktiv_8 Application: _desktop_index.php_m_action_animals_3Am_delete_row_animals_1029 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
Statement: UPDATE breedings SET id = id, unbreeding_date = '2026-06.03'::DATE WHERE id IN (10111518);
Date: 2026-06-03 12:32:44 Database: zemm_produktiv_8 Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
2 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 03 07 1 - LOG: database system was shut down at 2026-06-03 06:20:42 CEST
Date: 2026-06-03 06:20:44 Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv
3 1 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 03 13 1 - ERROR: syntax error at or near "an"
Statement: 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, 492) AS is_owner, user_is_tgm(animals_search_mview.editor, 492) AS is_editor, user_is_tgm(animals_search_mview.tourist, 492) 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 animal_id LIKE 'javascript:SetAndSubmitwId('an' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist)
Date: 2026-06-03 12:25:36 Database: zemm_produktiv_8 Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-06-03_062044.csv