ZEMM PG Report-
Global information
- Generated on Mon Jun 15 06:04:59 2026
- Log file: /var/log/postgresql/postgresql-2026-05-13_000000.csv, ..., /var/log/postgresql/postgresql-2026-06-15_000000.csv
- Parsed 345,487 log entries in 4m58s
- Log start from 2026-05-21 00:00:01 to 2026-05-21 23:59:34
-
Overview
Global Stats
- 81 Number of unique normalized queries
- 25,146 Number of queries
- 8h31m36s Total query duration
- 2026-05-21 00:00:01 First query
- 2026-05-21 23:59:34 Last query
- 19 queries/s at 2026-05-21 00:47:02 Query peak
- 8h31m36s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h31m36s Execute total duration
- 3 Number of events
- 3 Number of unique normalized events
- 1 Max number of times the same event was reported
- 0 Number of cancellation
- 67 Total number of automatic vacuums
- 158 Total number of automatic analyzes
- 163 Number temporary file
- 119.62 MiB Max size of temporary file
- 118.85 MiB Average size of temporary file
- 33,511 Total number of sessions
- 8 sessions at 2026-05-21 14:00:40 Session peak
- 1h52m9s Total duration of sessions
- 200ms Average duration of sessions
- 0 Average queries per session
- 916ms Average queries duration per session
- 0ms Average idle time per session
- 33,511 Total number of connections
- 30 connections/s at 2026-05-21 06:22:23 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 19 queries/s Query Peak
- 2026-05-21 00:47:02 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-05-21 12:52:11 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 18 queries/s Query Peak
- 2026-05-21 00:27:01 Date
Queries duration
Key values
- 8h31m36s 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) May 21 00 1,040 0ms 2s568ms 1s530ms 42s22ms 43s573ms 43s659ms 01 1,040 965ms 2s568ms 1s743ms 41s988ms 43s206ms 43s659ms 02 1,038 743ms 2s342ms 1s452ms 39s534ms 39s818ms 40s579ms 03 1,038 738ms 1s479ms 1s101ms 25s151ms 25s521ms 25s894ms 04 1,038 750ms 1s465ms 1s98ms 24s919ms 25s363ms 25s671ms 05 1,038 744ms 1s452ms 1s104ms 25s198ms 25s272ms 25s482ms 06 1,067 505ms 3s104ms 1s123ms 25s281ms 38s865ms 54s485ms 07 1,061 505ms 5s753ms 1s403ms 39s996ms 40s435ms 1m40s 08 1,090 505ms 3s107ms 1s153ms 36s440ms 41s816ms 55s644ms 09 1,049 724ms 8s722ms 1s195ms 25s215ms 25s562ms 32s658ms 10 1,059 509ms 1s975ms 1s188ms 25s309ms 26s741ms 34s202ms 11 1,068 712ms 2s525ms 1s135ms 25s748ms 26s523ms 45s330ms 12 1,056 507ms 2s195ms 1s363ms 33s12ms 36s440ms 38s860ms 13 1,049 501ms 2s474ms 832ms 23s238ms 28s40ms 48s196ms 14 1,042 604ms 1s477ms 1s159ms 24s291ms 24s607ms 25s233ms 15 1,038 930ms 1s439ms 1s178ms 24s467ms 25s194ms 25s414ms 16 1,042 721ms 1s414ms 1s154ms 24s39ms 24s512ms 24s916ms 17 1,040 719ms 1s414ms 1s159ms 24s160ms 24s493ms 24s990ms 18 1,040 918ms 1s432ms 1s192ms 24s566ms 25s294ms 26s695ms 19 1,050 579ms 6s781ms 1s280ms 25s781ms 26s348ms 45s870ms 20 1,044 566ms 1s447ms 1s263ms 24s601ms 26s436ms 26s975ms 21 1,038 905ms 1s412ms 1s159ms 24s228ms 24s700ms 24s926ms 22 1,038 905ms 1s414ms 1s170ms 24s214ms 24s856ms 24s990ms 23 1,043 573ms 2s118ms 1s158ms 24s153ms 24s624ms 30s374ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 21 00 12 0 1s183ms 722ms 1s321ms 1s374ms 01 12 0 1s246ms 965ms 1s298ms 1s380ms 02 12 0 1s39ms 743ms 1s161ms 1s297ms 03 12 0 775ms 738ms 772ms 819ms 04 12 0 771ms 750ms 768ms 802ms 05 12 0 774ms 744ms 777ms 793ms 06 39 0 934ms 1s127ms 1s965ms 2s839ms 07 31 0 975ms 1s270ms 1s780ms 3s744ms 08 52 0 769ms 1s470ms 2s117ms 3s455ms 09 18 0 778ms 769ms 804ms 1s511ms 10 27 0 832ms 962ms 1s39ms 1s505ms 11 37 0 835ms 985ms 1s522ms 3s59ms 12 24 0 1s58ms 967ms 1s532ms 2s894ms 13 25 0 807ms 0ms 1s217ms 3s668ms 14 15 0 966ms 934ms 957ms 1s43ms 15 12 0 972ms 930ms 985ms 1s16ms 16 16 0 916ms 942ms 977ms 993ms 17 14 0 932ms 944ms 969ms 985ms 18 13 0 971ms 939ms 975ms 1s7ms 19 12 8 1s723ms 942ms 977ms 991ms 20 14 0 957ms 941ms 964ms 1s3ms 21 12 0 949ms 905ms 949ms 983ms 22 12 0 953ms 932ms 952ms 982ms 23 12 5 1s68ms 930ms 960ms 988ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 21 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 1 0 0 1s347ms 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 May 21 00 0 18 18.00 0.00% 01 0 18 18.00 0.00% 02 0 18 18.00 0.00% 03 0 18 18.00 0.00% 04 0 18 18.00 0.00% 05 0 18 18.00 0.00% 06 0 20 20.00 0.00% 07 0 18 18.00 0.00% 08 0 21 21.00 0.00% 09 0 24 24.00 0.00% 10 0 19 19.00 0.00% 11 0 23 23.00 0.00% 12 0 21 21.00 0.00% 13 0 1 1.00 0.00% 14 0 22 22.00 0.00% 15 0 18 18.00 0.00% 16 0 18 18.00 0.00% 17 0 18 18.00 0.00% 18 0 20 20.00 0.00% 19 0 22 22.00 0.00% 20 0 23 23.00 0.00% 21 0 18 18.00 0.00% 22 0 18 18.00 0.00% 23 0 18 18.00 0.00% Day Hour Count Average / Second May 21 00 963 0.27/s 01 961 0.27/s 02 936 0.26/s 03 888 0.25/s 04 892 0.25/s 05 873 0.24/s 06 2,049 0.57/s 07 2,558 0.71/s 08 2,219 0.62/s 09 1,998 0.56/s 10 2,581 0.72/s 11 2,063 0.57/s 12 2,085 0.58/s 13 2,096 0.58/s 14 1,780 0.49/s 15 1,349 0.37/s 16 1,266 0.35/s 17 948 0.26/s 18 888 0.25/s 19 923 0.26/s 20 919 0.26/s 21 763 0.21/s 22 756 0.21/s 23 757 0.21/s Day Hour Count Average Duration Average idle time May 21 00 963 286ms 0ms 01 961 287ms 0ms 02 936 247ms 0ms 03 888 202ms 0ms 04 892 201ms 0ms 05 873 204ms 0ms 06 2,049 197ms 0ms 07 2,558 181ms 0ms 08 2,219 222ms 0ms 09 1,998 196ms 0ms 10 2,581 155ms 0ms 11 2,063 164ms 0ms 12 2,085 191ms 0ms 13 2,096 175ms 0ms 14 1,780 164ms 0ms 15 1,349 180ms 0ms 16 1,266 189ms 0ms 17 948 217ms 0ms 18 888 224ms 0ms 19 923 274ms 0ms 20 919 209ms 0ms 21 763 223ms 0ms 22 756 221ms 0ms 23 757 236ms 0ms -
Connections
Established Connections
Key values
- 30 connections Connection Peak
- 2026-05-21 06:22:23 Date
Connections per database
Key values
- zemm_monitoring Main Database
- 33,511 connections Total
Connections per user
Key values
- labanimal Main User
- 33,511 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-05-21 14:00:40 Date
Histogram of session times
Key values
- 30,171 0-500ms duration
Sessions per database
Key values
- zemm_monitoring Main Database
- 33,511 sessions Total
Sessions per user
Key values
- labanimal Main User
- 33,511 sessions Total
Sessions per host
Key values
- ::1 Main Host
- 33,511 sessions Total
Sessions per application
Key values
- Main Application
- 33,511 sessions Total
Application Count Total Duration Average Duration 27,994 1h36m21s 206ms _backend_cage_autocomplete_api.php_q_2025_limit_12_zemm_dev_loc 1 31ms 31ms _backend_cage_autocomplete_api.php_q_Kadavertruhe_limit_12_zemm 1 35ms 35ms _backend_wean_api.php_litter_id_10130227_zemm_dev_localhost_543 5 737ms 147ms _backend_wean_api.php_litter_id_10130236_zemm_dev_localhost_543 5 703ms 140ms _backend_wean_api.php_litter_id_10130257_zemm_dev_localhost_543 6 895ms 149ms _desktop__command_tasks_command_tasks_subcommand_open_screen__q 1 211ms 211ms _desktop__zemm_dev_localhost_5432 1 89ms 89ms _desktop__zemm_produktiv_8_localhost_5432 19 1s5ms 52ms _desktop_index.php_animal_name_6_animal_id_2025_2F002_2F9765_sp 1 90ms 90ms _desktop_index.php_cage_name_51-059_breeding_date_2026-03-18_un 1 1s86ms 1s86ms _desktop_index.php_cage_name_51_2A_current_only_true_val4_anima 2 2s67ms 1s33ms _desktop_index.php_cage_name_54-126_current_only_true_val4_anim 1 81ms 81ms _desktop_index.php_cages_name_51_2A_cages_empty_false_val4_cage 1 102ms 102ms _desktop_index.php_cages_name_55-103_cages_empty__25_val4_cages 1 46ms 46ms _desktop_index.php_command_animals_breedings_subcommand_edit_id 4 3s500ms 875ms _desktop_index.php_command_animals_breedings_subcommand_init_ze 7 305ms 43ms _desktop_index.php_command_animals_breedings_subcommand_select_ 1 53ms 53ms _desktop_index.php_command_animals_create_subcommand_init_zemm_ 1 54ms 54ms _desktop_index.php_command_animals_edit_subcommand_init_id_1029 2 182ms 91ms _desktop_index.php_command_animals_edit_subcommand_init_id_1030 1 97ms 97ms _desktop_index.php_command_animals_edit_subcommand_link_init_va 1 100ms 100ms _desktop_index.php_command_animals_edit_subcommand_m_init_scree 1 122ms 122ms _desktop_index.php_command_animals_litters_create_subcommand_se 1 176ms 176ms _desktop_index.php_command_animals_litters_edit_subcommand_init 1 101ms 101ms _desktop_index.php_command_animals_litters_edit_subcommand_m_in 1 379ms 379ms _desktop_index.php_command_animals_litters_subcommand_select_ze 1 44ms 44ms _desktop_index.php_command_animals_subcommand_init_zemm_produkt 30 1s339ms 44ms _desktop_index.php_command_animals_subcommand_select_zemm_dev_l 1 67ms 67ms _desktop_index.php_command_login_subcommand_init_zemm_dev_local 19 622ms 32ms _desktop_index.php_command_login_subcommand_init_zemm_produktiv 1,669 49s536ms 29ms _desktop_index.php_command_login_subcommand_init_zemm_test_loca 12 370ms 30ms _desktop_index.php_command_reports_subcommand_animals_per_room_ 3 411ms 137ms _desktop_index.php_command_reports_subcommand_animals_per_user_ 9 994ms 110ms _desktop_index.php_command_reports_subcommand_fates_zemm_dev_lo 1 140ms 140ms _desktop_index.php_command_reports_subcommand_init_zemm_dev_loc 2 1s731ms 865ms _desktop_index.php_command_reports_subcommand_init_zemm_produkt 1 123ms 123ms _desktop_index.php_command_strains_subcommand_edit_id_1433_zemm 1 49ms 49ms _desktop_index.php_command_strains_subcommand_init_zemm_produkt 1 68ms 68ms _desktop_index.php_command_strains_subcommand_view_id_10100166_ 1 45ms 45ms _desktop_index.php_command_tasks_subcommand_edit_id_10134267_ze 1 109ms 109ms _desktop_index.php_command_tasks_subcommand_edit_id_10142775_ze 1 91ms 91ms _desktop_index.php_command_tasks_subcommand_edit_id_10143025_ze 1 83ms 83ms _desktop_index.php_command_tasks_subcommand_edit_id_10143101_ze 1 82ms 82ms _desktop_index.php_command_tasks_subcommand_edit_id_10143135_ze 1 83ms 83ms _desktop_index.php_command_tasks_subcommand_edit_id_10143140_ze 1 85ms 85ms _desktop_index.php_command_tasks_subcommand_found_val1_10100033 2 89ms 44ms _desktop_index.php_command_tasks_subcommand_found_val1_50_val2_ 2 87ms 43ms _desktop_index.php_command_tasks_subcommand_init_search_zemm_de 1 47ms 47ms _desktop_index.php_command_tasks_subcommand_init_zemm_produktiv 51 3s753ms 73ms _desktop_index.php_command_tasks_subcommand_open_legacy_1_id_10 23 1s416ms 61ms _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv 1 407ms 407ms _desktop_index.php_command_tasks_subcommand_search_zemm_produkt 2 73ms 36ms _desktop_index.php_current_only_true_val4_animals_breedings_sea 1 2s515ms 2s515ms _desktop_index.php_dam_id_2025_2F001_2F6672_current_only_true_v 1 1s302ms 1s302ms _desktop_index.php_m_action_animals_3Am_delete_val4_animals_lis 1 99ms 99ms _desktop_index.php_m_action_animals_litters_edit_3Am_init_val4_ 2 74ms 37ms _desktop_index.php_m_action_cages_3Am_delete_command_animals_su 2 92ms 46ms _desktop_index.php_name_Abt_C3_B6ten_20v._20Tieren_20ohne_20Ver 2 131ms 65ms _desktop_index.php_name_Genotypisierungsproben_20genommen_instr 2 134ms 67ms _desktop_index.php_search_id_10143084_search_status__25_deadlin 1 52ms 52ms _desktop_index.php_search_name_Verpaarungen_20zur_20Zucht_searc 1 80ms 80ms _desktop_index.php_search_status_2_no_subtasks_true_command_tas 1 54ms 54ms _desktop_index.php_search_status__25_issuer_user_name_Dey_20Sar 2 146ms 73ms _desktop_index.php_view_animal_name_on_view_animal_id_on_animal 3 815ms 271ms _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b 23 15s259ms 663ms _desktop_index.php_zemm_dev_localhost_5432 16 13s563ms 847ms _desktop_index.php_zemm_produktiv_8_localhost_5432 3,407 12m47s 225ms backend:zemm_produktiv_8@localhost 103 13s348ms 129ms bounces:zemm_produktiv_8@h2940066.stratoserver.net:5432 1 70ms 70ms expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 1 1s373ms 1s373ms pg_dump 2 39s180ms 19s590ms psql 15 262ms 17ms taskscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 24 17s339ms 722ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 19,550 buffers Checkpoint Peak
- 2026-05-21 01:35:21 Date
- 269.271 seconds Highest write time
- 0.344 seconds Sync time
Checkpoints Wal files
Key values
- 6 files Wal files usage Peak
- 2026-05-21 01:35:21 Date
Checkpoints distance
Key values
- 192.94 Mo Distance Peak
- 2026-05-21 01:35:21 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time May 21 00 7,397 741.203s 0.115s 741.395s 01 26,205 936.181s 0.107s 936.355s 02 7,565 757.876s 0.101s 758.075s 03 8,394 839.86s 0.1s 840.015s 04 8,315 831.939s 0.097s 832.091s 05 6,906 691.21s 0.087s 691.348s 06 10,870 1,037.469s 0.21s 1,037.741s 07 11,071 1,107.86s 0.257s 1,108.192s 08 11,167 1,118.401s 0.259s 1,118.721s 09 9,402 940.863s 0.205s 941.126s 10 11,103 1,111.238s 0.255s 1,111.545s 11 9,595 960.169s 0.22s 960.445s 12 9,855 986.154s 0.235s 986.445s 13 9,903 990.858s 0.261s 991.171s 14 9,887 988.677s 0.188s 988.926s 15 9,028 903.44s 0.142s 903.641s 16 8,698 870.759s 0.118s 870.931s 17 7,179 718.963s 0.098s 719.118s 18 8,807 881.51s 0.106s 881.677s 19 8,329 833.466s 0.112s 833.635s 20 7,919 792.705s 0.106s 792.867s 21 8,424 842.992s 0.1s 843.15s 22 7,496 750.437s 0.438s 750.93s 23 8,423 843.195s 0.102s 843.356s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 21 00 0 0 2 470 0.006s 0.012s 01 0 0 7 459 0.007s 0.011s 02 0 0 2 466 0.009s 0.012s 03 0 0 1 481 0.003s 0.012s 04 0 0 2 467 0.005s 0.012s 05 0 0 1 455 0.001s 0.012s 06 0 0 3 1,235 0.002s 0.013s 07 0 0 2 1,435 0.004s 0.012s 08 0 0 3 1,454 0.004s 0.012s 09 0 0 2 1,158 0.003s 0.012s 10 0 0 2 1,478 0.002s 0.012s 11 0 0 2 1,238 0.004s 0.012s 12 0 0 2 1,428 0.001s 0.012s 13 0 0 2 1,519 0.002s 0.012s 14 0 0 2 1,040 0.011s 0.012s 15 0 0 2 783 0.002s 0.012s 16 0 0 2 640 0.001s 0.012s 17 0 0 2 510 0.002s 0.011s 18 0 0 1 556 0.003s 0.013s 19 0 0 2 570 0.003s 0.012s 20 0 0 2 550 0.002s 0.012s 21 0 0 1 524 0.002s 0.012s 22 0 0 2 501 0.146s 0.02s 23 0 0 2 511 0.003s 0.012s Day Hour Count Avg time (sec) May 21 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 May 21 00 2,069.92 kB 2,742.67 kB 01 10,996.45 kB 38,801.36 kB 02 2,098.25 kB 36,279.58 kB 03 2,299.92 kB 11,787.33 kB 04 2,292.42 kB 4,971.58 kB 05 1,937.58 kB 2,913.17 kB 06 2,870.62 kB 3,620.92 kB 07 3,222.67 kB 4,187.00 kB 08 3,496.75 kB 6,217.58 kB 09 2,835.92 kB 4,570.92 kB 10 3,161.42 kB 3,781.00 kB 11 2,743.75 kB 3,631.08 kB 12 2,856.33 kB 3,702.25 kB 13 3,070.50 kB 3,575.50 kB 14 2,740.83 kB 4,799.92 kB 15 2,643.08 kB 3,836.75 kB 16 2,447.83 kB 3,246.08 kB 17 2,261.82 kB 2,923.18 kB 18 2,272.15 kB 3,042.85 kB 19 2,256.92 kB 3,107.92 kB 20 2,147.17 kB 2,895.00 kB 21 2,309.58 kB 2,971.33 kB 22 2,134.42 kB 3,026.75 kB 23 2,254.92 kB 3,198.92 kB -
Temporary Files
Size of temporary files
Key values
- 119.62 MiB Temp Files size Peak
- 2026-05-21 23:59:34 Date
Number of temporary files
Key values
- 1 per second Temp Files Peak
- 2026-05-21 23:39:33 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size May 21 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 11 1.27 GiB 118.09 MiB 11 13 1.50 GiB 118.20 MiB 12 12 1.39 GiB 118.31 MiB 13 1 118.38 MiB 118.38 MiB 14 15 1.74 GiB 118.52 MiB 15 12 1.39 GiB 118.64 MiB 16 12 1.39 GiB 118.76 MiB 17 12 1.39 GiB 118.87 MiB 18 13 1.51 GiB 118.98 MiB 19 12 1.40 GiB 119.10 MiB 20 14 1.63 GiB 119.22 MiB 21 12 1.40 GiB 119.33 MiB 22 12 1.40 GiB 119.45 MiB 23 12 1.40 GiB 119.56 MiB -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.63 sec Highest CPU-cost vacuum
Table public.tasks
Database zemm_produktiv_8 - 2026-05-21 01:30:25 Date
- 0 sec Highest CPU-cost analyze
Table
Database zemm_produktiv_8 - Date
Average Autovacuum Duration
Key values
- 0.63 sec Highest CPU-cost vacuum
Table public.tasks
Database zemm_produktiv_8 - 2026-05-21 01:30:25 Date
Analyzes per table
Key values
- pg_catalog.pg_type (48) Main table analyzed (database zemm_produktiv_8)
- 158 analyzes Total
Table Number of analyzes zemm_produktiv_8.pg_catalog.pg_type 48 zemm_produktiv_8.pg_catalog.pg_attribute 38 zemm_produktiv_8.pg_catalog.pg_class 26 zemm_produktiv_8.pg_catalog.pg_depend 24 zemm_produktiv_8.public.cages_search_mview 3 zemm_test.pg_catalog.pg_shdepend 2 zemm_produktiv_8.public.tmptasks 2 invdb.pg_catalog.pg_shdepend 2 zemm_monitoring.observability.metrics_timeseries 2 zemm_produktiv_8.public.cages 1 zemm_produktiv_8.public.tasks 1 zemm_produktiv_8.public.users 1 zemm_dev.pg_catalog.pg_shdepend 1 zemm_dev.pg_catalog.pg_type 1 fbi_ci_db.pg_catalog.pg_shdepend 1 zemm_produktiv_8.public.monitoring_session_activity 1 zemm_produktiv_8.public.login_tracker 1 labanimal.pg_catalog.pg_shdepend 1 zemm_monitoring.pg_catalog.pg_shdepend 1 zemm_monitoring.observability.uptime_checks 1 Total 158 Vacuums per table
Key values
- pg_catalog.pg_type (17) Main table vacuumed on database zemm_produktiv_8
- 67 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 17 17 0 0 0 0 0 873 185 221,144 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 14 14 0 0 0 0 0 1,583 512 373,007 0 0 zemm_produktiv_8.pg_catalog.pg_class 9 9 0 0 0 0 0 783 228 264,475 0 0 zemm_produktiv_8.pg_catalog.pg_depend 8 8 0 0 0 0 0 1,015 333 398,682 0 0 zemm_monitoring.pg_toast.pg_toast_67431 4 0 0 0 0 0 0 4,589 1,542 3,509,623 1,520 9,120 zemm_produktiv_8.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 540 135 712,318 30 110 zemm_monitoring.pg_toast.pg_toast_181881 3 0 0 0 0 0 0 762 262 1,317,433 249 1,494 zemm_monitoring.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 137 48 97,284 0 0 zemm_produktiv_8.pg_catalog.pg_statistic 1 1 0 0 0 0 0 213 42 139,410 18 59 zemm_dev.pg_catalog.pg_class 1 1 0 0 0 0 0 73 34 66,975 4 48 zemm_produktiv_8.public.cages_search_mview 1 1 0 0 0 0 0 714 389 1,292,150 35 109 zemm_produktiv_8.public.users 1 1 0 0 0 0 0 168 80 203,377 49 134 zemm_produktiv_8.public.tasks 1 1 0 0 0 0 0 48,227 43 3,558,624 2 3 invdb.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 75 21 48,178 0 0 zemm_produktiv_8.public.tmptasks 1 1 0 0 0 0 0 66 22 18,477 0 0 Total 67 60 0 0 0 0 0 59,818 3,876 12,221,157 1,907 11,077 Vacuum throughput per table
Key values
- public.tasks (0.63) Max CPU elapsed for vacuum on database zemm_produktiv_8
- pg_toast.pg_toast_67431 (4.428 ms) Max I/O read time for vacuum on database zemm_produktiv_8
- pg_toast.pg_toast_181881 (0.022 ms) Max I/O write time for vacuum on database zemm_produktiv_8
I/O timing (ms) CPU (s) Table read write elapsed zemm_produktiv_8.pg_catalog.pg_type 1.582 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 3.217 0 0.11 zemm_produktiv_8.pg_catalog.pg_class 2.71 0 0.01 zemm_produktiv_8.pg_catalog.pg_depend 1.994 0 0.07 zemm_monitoring.pg_toast.pg_toast_67431 4.428 0 0.37 zemm_produktiv_8.pg_toast.pg_toast_2619 0.875 0 0.03 zemm_monitoring.pg_toast.pg_toast_181881 0 0.022 0.06 zemm_monitoring.pg_catalog.pg_shdepend 0.947 0 0 zemm_produktiv_8.pg_catalog.pg_statistic 0.641 0 0.01 zemm_dev.pg_catalog.pg_class 0.647 0 0.01 zemm_produktiv_8.public.cages_search_mview 0 0 0.1 zemm_produktiv_8.public.users 1.637 0 0.02 zemm_produktiv_8.public.tasks 0 0 0.63 invdb.pg_catalog.pg_shdepend 0 0 0 zemm_produktiv_8.public.tmptasks 0.346 0 0 Total 19.024 0.022 1.42 Tuples removed per table
Key values
- public.tasks (54552) Main table with removed tuples on database zemm_produktiv_8
- 79545 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain zemm_produktiv_8.public.tasks 1 1 54,552 57,695 0 0 17,011 zemm_produktiv_8.pg_catalog.pg_attribute 14 14 11,781 77,695 0 0 2,576 zemm_produktiv_8.pg_catalog.pg_depend 8 8 6,657 33,576 0 0 440 zemm_produktiv_8.pg_catalog.pg_type 17 17 3,246 14,127 0 0 527 zemm_produktiv_8.pg_catalog.pg_class 9 9 1,483 8,127 0 0 378 zemm_monitoring.pg_catalog.pg_shdepend 2 2 463 9,410 0 0 76 zemm_produktiv_8.pg_toast.pg_toast_2619 3 3 334 879 0 0 318 zemm_produktiv_8.pg_catalog.pg_statistic 1 1 263 1,269 0 0 143 zemm_produktiv_8.public.cages_search_mview 1 1 218 13,885 0 0 234 invdb.pg_catalog.pg_shdepend 1 1 189 4,705 0 0 38 zemm_produktiv_8.public.users 1 1 185 758 0 0 108 zemm_dev.pg_catalog.pg_class 1 1 98 1,202 0 0 39 zemm_produktiv_8.public.tmptasks 1 1 76 859 0 0 117 zemm_monitoring.pg_toast.pg_toast_67431 4 0 0 2,751,502 0 0 466,907 zemm_monitoring.pg_toast.pg_toast_181881 3 0 0 3,006 0 0 504 Total 67 60 79,545 2,978,695 0 0 489,416 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Pages removed per tables
NO DATASET
Table Number of vacuums Index scans Tuples removed Pages removed zemm_produktiv_8.pg_catalog.pg_attribute 14 14 11781 0 zemm_monitoring.pg_toast.pg_toast_67431 4 0 0 0 zemm_produktiv_8.pg_catalog.pg_statistic 1 1 263 0 zemm_dev.pg_catalog.pg_class 1 1 98 0 zemm_produktiv_8.pg_catalog.pg_type 17 17 3246 0 zemm_produktiv_8.pg_catalog.pg_class 9 9 1483 0 zemm_produktiv_8.public.cages_search_mview 1 1 218 0 zemm_produktiv_8.public.users 1 1 185 0 zemm_produktiv_8.pg_catalog.pg_depend 8 8 6657 0 zemm_produktiv_8.public.tasks 1 1 54552 0 zemm_produktiv_8.pg_toast.pg_toast_2619 3 3 334 0 invdb.pg_catalog.pg_shdepend 1 1 189 0 zemm_produktiv_8.public.tmptasks 1 1 76 0 zemm_monitoring.pg_toast.pg_toast_181881 3 0 0 0 zemm_monitoring.pg_catalog.pg_shdepend 2 2 463 0 Total 67 60 79,545 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs May 21 00 0 0 01 1 1 02 0 0 03 0 1 04 1 0 05 0 0 06 4 7 07 8 20 08 4 15 09 9 16 10 9 22 11 5 16 12 4 14 13 8 22 14 3 9 15 7 14 16 1 1 17 1 0 18 0 0 19 0 0 20 0 0 21 0 0 22 1 0 23 1 0 - 0.63 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 1 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 1s95ms 1s95ms 1s95ms 1s95ms alter table observability.uptime_checks add column if not exists label text;-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-05-21 07:32:01 Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-05-21 08:26:01 Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-05-21 06:59:01 Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
Queries that waited the most
Rank Wait time Query 1 1s95ms ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;[ Date: 2026-05-21 01:02:03 - Database: zemm_monitoring - User: monitoring_admin ]
-
Queries
Queries by type
Key values
- 457 Total read queries
- 24,685 Total write queries
Queries by database
Key values
- zemm_monitoring Main database
- 24,934 Requests
- 8h27m42s (zemm_monitoring)
- Main time consuming database
Queries by user
Key values
- monitoring_admin Main user
- 221,556 Requests
User Request type Count Duration labanimal Total 935 24m20s copy to 8 22s808ms cte 141 3m23s select 777 20m23s update 9 9s966ms monitoring_admin Total 221,556 4d15h14m2s cte 398 49m2s ddl 220,333 4d14h13m12s select 821 11m44s postgres Total 46 1m6s copy to 46 1m6s Duration by user
Key values
- 4d15h14m2s (monitoring_admin) Main time consuming user
User Request type Count Duration labanimal Total 935 24m20s copy to 8 22s808ms cte 141 3m23s select 777 20m23s update 9 9s966ms monitoring_admin Total 221,556 4d15h14m2s cte 398 49m2s ddl 220,333 4d14h13m12s select 821 11m44s postgres Total 46 1m6s copy to 46 1m6s Queries by host
Key values
- unknown Main host
- 222,482 Requests
- 4d15h38m12s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 24,934 Requests
- 8h27m42s (unknown)
- Main time consuming application
Application Request type Count Duration _desktop_index.php_cage_name_51-059_breeding_date_2026-03-18_un Total 1 704ms select 1 704ms _desktop_index.php_cage_name_51_2A_current_only_true_val4_anima Total 1 1s940ms cte 1 1s940ms _desktop_index.php_command_animals_breedings_subcommand_edit_id Total 4 2s488ms select 4 2s488ms _desktop_index.php_command_reports_subcommand_init_zemm_dev_loc Total 2 1s605ms select 2 1s605ms _desktop_index.php_current_only_true_val4_animals_breedings_sea Total 1 2s468ms cte 1 2s468ms _desktop_index.php_dam_id_2025_2F001_2F6672_current_only_true_v Total 1 1s253ms cte 1 1s253ms _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b Total 4 3s67ms select 4 3s67ms _desktop_index.php_zemm_dev_localhost_5432 Total 1 8s722ms cte 1 8s722ms _desktop_index.php_zemm_produktiv_8_localhost_5432 Total 183 3m1s cte 26 48s498ms select 157 2m13s expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 Total 1 1s347ms update 1 1s347ms pg_dump Total 13 29s502ms copy to 13 29s502ms unknown Total 24,934 8h27m42s cte 161 4m3s ddl 24,480 8h19m1s select 289 4m34s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-05-21 01:01:03 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 393 500-1000ms duration
Slowest individual queries
Rank Duration Query 1 8s722ms WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);[ Date: 2026-05-21 09:29:41 - Database: zemm_dev - User: labanimal - Application: _desktop_index.php_zemm_dev_localhost_5432 - Bind query: yes ]
2 6s781ms COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;[ Date: 2026-05-21 19:34:38 - Database: zemm_produktiv_8 - User: labanimal - Application: pg_dump - Bind query: yes ]
3 5s753ms WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 269) THEN TRUE WHEN user_is_tgm (dam.editor, 269) THEN TRUE WHEN user_is_tgm (dam.tourist, 269) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 269) THEN TRUE WHEN user_is_tgm (sire.editor, 269) THEN TRUE WHEN user_is_tgm (sire.tourist, 269) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND cagess."cageName" like ('61%') AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);[ Date: 2026-05-21 07:31:43 - Database: zemm_produktiv_8 - User: labanimal - Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Bind query: yes ]
4 5s753ms CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-05-21 07:32:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
5 5s753ms 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-05-21 07:32:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
6 5s753ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-05-21 07:32:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
7 5s753ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-05-21 07:32:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
8 5s753ms 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-05-21 07:32:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
9 5s753ms CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);[ Date: 2026-05-21 07:32:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
10 5s753ms CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);[ Date: 2026-05-21 07:32:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
11 5s753ms 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-05-21 07:32:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
12 5s753ms CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);[ Date: 2026-05-21 07:32:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
13 5s753ms 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-05-21 07:32:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
14 5s753ms 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-05-21 07:32:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
15 5s753ms 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-05-21 07:32:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
16 5s753ms 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-05-21 07:32:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
17 5s753ms ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;[ Date: 2026-05-21 07:32:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
18 5s753ms ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;[ Date: 2026-05-21 07:32:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
19 5s753ms CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);[ Date: 2026-05-21 07:32:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
20 5s753ms CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);[ Date: 2026-05-21 07:32: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 29m21s 1,440 501ms 5s753ms 1s223ms 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 #1
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
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-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
2 29m21s 1,440 501ms 5s753ms 1s223ms 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 #2
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
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-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
3 29m21s 1,440 501ms 5s753ms 1s223ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
4 29m21s 1,440 501ms 5s753ms 1s223ms 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 #4
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
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-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
5 29m21s 1,440 501ms 5s753ms 1s223ms create schema if not exists observability;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
6 29m21s 1,440 501ms 5s753ms 1s223ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
7 29m21s 1,440 501ms 5s753ms 1s223ms 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 #7
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
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-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
8 29m21s 1,440 501ms 5s753ms 1s223ms 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 #8
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
9 29m21s 1,440 501ms 5s753ms 1s223ms create table if not exists observability.system_metrics ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
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-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
10 29m21s 1,440 501ms 5s753ms 1s223ms 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 #10
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
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-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
11 29m21s 1,440 501ms 5s753ms 1s223ms alter table observability.uptime_checks add column if not exists label text;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
12 29m21s 1,440 501ms 5s753ms 1s223ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
13 29m21s 1,440 501ms 5s753ms 1s223ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
14 29m21s 1,440 501ms 5s753ms 1s223ms 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 #14
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
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-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
15 29m18s 1,440 501ms 5s753ms 1s221ms create index if not exists idx_uptime_checks_endpoint on observability.uptime_checks (endpoint, checked_at desc);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 21 01 60 1m30s 1s514ms 02 60 1m43s 1s727ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m15s 1s256ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m18s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
16 29m18s 1,440 501ms 5s753ms 1s221ms alter table observability.uptime_checks add column if not exists payload jsonb;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 21 01 60 1m30s 1s514ms 02 60 1m43s 1s727ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m15s 1s256ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m18s - Times executed: 1438 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
17 29m18s 1,440 501ms 5s753ms 1s221ms create index if not exists idx_uptime_checks_key on observability.uptime_checks (check_key, checked_at desc);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 21 01 60 1m30s 1s514ms 02 60 1m43s 1s727ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m15s 1s256ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m18s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
18 4m32s 287 722ms 1s470ms 948ms select distinct on (coalesce(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at from observability.uptime_checks order by coalesce(check_key, endpoint), checked_at desc;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 21 01 12 14s200ms 1s183ms 02 12 14s959ms 1s246ms 03 12 12s469ms 1s39ms 04 12 9s304ms 775ms 05 12 9s259ms 771ms 06 12 9s296ms 774ms 07 12 9s531ms 794ms 08 12 12s154ms 1s12ms 09 14 13s121ms 937ms 10 14 10s885ms 777ms 11 11 10s643ms 967ms 12 13 12s598ms 969ms 13 12 11s463ms 955ms 14 1 972ms 972ms 15 15 14s490ms 966ms 16 12 11s666ms 972ms 17 12 11s594ms 966ms 18 12 11s543ms 961ms 19 13 12s626ms 971ms 20 12 11s657ms 971ms 21 14 13s400ms 957ms 22 12 11s388ms 949ms 23 12 11s438ms 953ms 00 12 11s467ms 955ms [ User: monitoring_admin - Total duration: 4m32s - Times executed: 287 ]
-
SELECT DISTINCT ON (COALESCE(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at FROM observability.uptime_checks ORDER BY COALESCE(check_key, endpoint), checked_at DESC;
Date: 2026-05-21 08:32:46 Duration: 1s470ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
SELECT DISTINCT ON (COALESCE(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at FROM observability.uptime_checks ORDER BY COALESCE(check_key, endpoint), checked_at DESC;
Date: 2026-05-21 01:17:05 Duration: 1s447ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_000000.csv
-
SELECT DISTINCT ON (COALESCE(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at FROM observability.uptime_checks ORDER BY COALESCE(check_key, endpoint), checked_at DESC;
Date: 2026-05-21 00:57:03 Duration: 1s406ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_000000.csv
19 4m3s 161 1s328ms 3s104ms 1s512ms 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 #19
Day Hour Count Duration Avg duration May 21 01 6 13s749ms 2s291ms 02 6 13s451ms 2s241ms 03 6 10s988ms 1s831ms 04 6 8s721ms 1s453ms 05 6 8s636ms 1s439ms 06 6 8s639ms 1s439ms 07 6 10s340ms 1s723ms 08 6 10s568ms 1s761ms 09 7 11s470ms 1s638ms 10 10 13s663ms 1s366ms 11 8 10s968ms 1s371ms 12 10 13s768ms 1s376ms 13 9 12s281ms 1s364ms 15 7 9s851ms 1s407ms 16 6 8s473ms 1s412ms 17 6 8s314ms 1s385ms 18 6 8s308ms 1s384ms 19 7 9s798ms 1s399ms 20 10 14s15ms 1s401ms 21 9 12s453ms 1s383ms 22 6 8s370ms 1s395ms 23 6 8s370ms 1s395ms 00 6 8s256ms 1s376ms [ User: monitoring_admin - Total duration: 4m3s - Times executed: 161 ]
-
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-19 00:57:25+02' AND collected_at <= '2026-05-21 00:57: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-05-21 00:57:25+02' AND '2026-05-21 06:57: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-05-21 00:57:25+02' AND '2026-05-21 06:57: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-05-21 06:57:28 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-18 18:57:01+02' AND collected_at <= '2026-05-20 18:57:01+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-05-20 18:57:01+02' AND '2026-05-21 00:57:01+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-05-20 18:57:01+02' AND '2026-05-21 00:57:01+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-05-21 00:57:03 Duration: 2s568ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_000000.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-18 18:47:00+02' AND collected_at <= '2026-05-20 18:47: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-05-20 18:47:00+02' AND '2026-05-21 00:47: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-05-20 18:47:00+02' AND '2026-05-21 00:47: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-05-21 00:47:03 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_000000.csv
20 36s897ms 16 1s636ms 5s753ms 2s306ms with damdam as ( select breedingid, string_agg(cast(dam as text), ?) as dam from breedingsdams inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as dam on dam.id = breedingsdams.dam and case when user_is_tgm (dam.owner, ?) then true when user_is_tgm (dam.editor, ?) then true when user_is_tgm (dam.tourist, ?) then true else false end group by breedingid ), siresire as ( select breedingid, string_agg(cast(sire as text), ?) as sire from breedingssires inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as sire on sire.id = breedingssires.sire and case when user_is_tgm (sire.owner, ?) then true when user_is_tgm (sire.editor, ?) then true when user_is_tgm (sire.tourist, ?) then true else false end group by breedingid ), cagess as ( select id, "cageName" from cages) ( select breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire from damdam, siresire, cagess, breedings where breedings.deleted != true and cagess.id = breedings.cage and cagess."cageName" like (?) and damdam.breedingid = breedings.id and siresire.breedingid = breedings.id and breedings."unbreeding_date" is null group by breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire order by breeding_date, plug_date);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 21 08 4 10s939ms 2s734ms 09 6 14s405ms 2s400ms 11 3 5s869ms 1s956ms 13 1 1s926ms 1s926ms 14 2 3s755ms 1s877ms [ User: labanimal - Total duration: 36s897ms - Times executed: 16 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 34s957ms - Times executed: 15 ]
[ Application: _desktop_index.php_cage_name_51_2A_current_only_true_val4_anima - Total duration: 1s940ms - Times executed: 1 ]
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 269) THEN TRUE WHEN user_is_tgm (dam.editor, 269) THEN TRUE WHEN user_is_tgm (dam.tourist, 269) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 269) THEN TRUE WHEN user_is_tgm (sire.editor, 269) THEN TRUE WHEN user_is_tgm (sire.tourist, 269) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND cagess."cageName" like ('61%') AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-05-21 07:31:43 Duration: 5s753ms 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-05-21_065307.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 456) THEN TRUE WHEN user_is_tgm (dam.editor, 456) THEN TRUE WHEN user_is_tgm (dam.tourist, 456) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 456) THEN TRUE WHEN user_is_tgm (sire.editor, 456) THEN TRUE WHEN user_is_tgm (sire.tourist, 456) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND cagess."cageName" like ('51%') AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-05-21 08:25:31 Duration: 3s107ms 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-05-21_065307.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 456) THEN TRUE WHEN user_is_tgm (dam.editor, 456) THEN TRUE WHEN user_is_tgm (dam.tourist, 456) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 456) THEN TRUE WHEN user_is_tgm (sire.editor, 456) THEN TRUE WHEN user_is_tgm (sire.tourist, 456) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND cagess."cageName" like ('51%') AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-05-21 08:20:40 Duration: 3s30ms 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-05-21_065307.csv
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,440 29m21s 501ms 5s753ms 1s223ms 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 #1
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
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-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
2 1,440 29m21s 501ms 5s753ms 1s223ms 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 #2
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
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-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
3 1,440 29m21s 501ms 5s753ms 1s223ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
4 1,440 29m21s 501ms 5s753ms 1s223ms 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 #4
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
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-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
5 1,440 29m21s 501ms 5s753ms 1s223ms create schema if not exists observability;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
6 1,440 29m21s 501ms 5s753ms 1s223ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
7 1,440 29m21s 501ms 5s753ms 1s223ms 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 #7
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
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-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
8 1,440 29m21s 501ms 5s753ms 1s223ms 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 #8
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
9 1,440 29m21s 501ms 5s753ms 1s223ms create table if not exists observability.system_metrics ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
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-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
10 1,440 29m21s 501ms 5s753ms 1s223ms 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 #10
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
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-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
11 1,440 29m21s 501ms 5s753ms 1s223ms alter table observability.uptime_checks add column if not exists label text;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
12 1,440 29m21s 501ms 5s753ms 1s223ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
13 1,440 29m21s 501ms 5s753ms 1s223ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
14 1,440 29m21s 501ms 5s753ms 1s223ms 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 #14
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
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-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
15 1,440 29m18s 501ms 5s753ms 1s221ms create index if not exists idx_uptime_checks_endpoint on observability.uptime_checks (endpoint, checked_at desc);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 21 01 60 1m30s 1s514ms 02 60 1m43s 1s727ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m15s 1s256ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m18s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
16 1,440 29m18s 501ms 5s753ms 1s221ms alter table observability.uptime_checks add column if not exists payload jsonb;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 21 01 60 1m30s 1s514ms 02 60 1m43s 1s727ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m15s 1s256ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m18s - Times executed: 1438 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
17 1,440 29m18s 501ms 5s753ms 1s221ms create index if not exists idx_uptime_checks_key on observability.uptime_checks (check_key, checked_at desc);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 21 01 60 1m30s 1s514ms 02 60 1m43s 1s727ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m15s 1s256ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m18s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
18 287 4m32s 722ms 1s470ms 948ms select distinct on (coalesce(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at from observability.uptime_checks order by coalesce(check_key, endpoint), checked_at desc;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 21 01 12 14s200ms 1s183ms 02 12 14s959ms 1s246ms 03 12 12s469ms 1s39ms 04 12 9s304ms 775ms 05 12 9s259ms 771ms 06 12 9s296ms 774ms 07 12 9s531ms 794ms 08 12 12s154ms 1s12ms 09 14 13s121ms 937ms 10 14 10s885ms 777ms 11 11 10s643ms 967ms 12 13 12s598ms 969ms 13 12 11s463ms 955ms 14 1 972ms 972ms 15 15 14s490ms 966ms 16 12 11s666ms 972ms 17 12 11s594ms 966ms 18 12 11s543ms 961ms 19 13 12s626ms 971ms 20 12 11s657ms 971ms 21 14 13s400ms 957ms 22 12 11s388ms 949ms 23 12 11s438ms 953ms 00 12 11s467ms 955ms [ User: monitoring_admin - Total duration: 4m32s - Times executed: 287 ]
-
SELECT DISTINCT ON (COALESCE(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at FROM observability.uptime_checks ORDER BY COALESCE(check_key, endpoint), checked_at DESC;
Date: 2026-05-21 08:32:46 Duration: 1s470ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
SELECT DISTINCT ON (COALESCE(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at FROM observability.uptime_checks ORDER BY COALESCE(check_key, endpoint), checked_at DESC;
Date: 2026-05-21 01:17:05 Duration: 1s447ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_000000.csv
-
SELECT DISTINCT ON (COALESCE(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at FROM observability.uptime_checks ORDER BY COALESCE(check_key, endpoint), checked_at DESC;
Date: 2026-05-21 00:57:03 Duration: 1s406ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_000000.csv
19 161 4m3s 1s328ms 3s104ms 1s512ms 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 #19
Day Hour Count Duration Avg duration May 21 01 6 13s749ms 2s291ms 02 6 13s451ms 2s241ms 03 6 10s988ms 1s831ms 04 6 8s721ms 1s453ms 05 6 8s636ms 1s439ms 06 6 8s639ms 1s439ms 07 6 10s340ms 1s723ms 08 6 10s568ms 1s761ms 09 7 11s470ms 1s638ms 10 10 13s663ms 1s366ms 11 8 10s968ms 1s371ms 12 10 13s768ms 1s376ms 13 9 12s281ms 1s364ms 15 7 9s851ms 1s407ms 16 6 8s473ms 1s412ms 17 6 8s314ms 1s385ms 18 6 8s308ms 1s384ms 19 7 9s798ms 1s399ms 20 10 14s15ms 1s401ms 21 9 12s453ms 1s383ms 22 6 8s370ms 1s395ms 23 6 8s370ms 1s395ms 00 6 8s256ms 1s376ms [ User: monitoring_admin - Total duration: 4m3s - Times executed: 161 ]
-
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-19 00:57:25+02' AND collected_at <= '2026-05-21 00:57: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-05-21 00:57:25+02' AND '2026-05-21 06:57: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-05-21 00:57:25+02' AND '2026-05-21 06:57: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-05-21 06:57:28 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-18 18:57:01+02' AND collected_at <= '2026-05-20 18:57:01+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-05-20 18:57:01+02' AND '2026-05-21 00:57:01+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-05-20 18:57:01+02' AND '2026-05-21 00:57:01+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-05-21 00:57:03 Duration: 2s568ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_000000.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-18 18:47:00+02' AND collected_at <= '2026-05-20 18:47: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-05-20 18:47:00+02' AND '2026-05-21 00:47: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-05-20 18:47:00+02' AND '2026-05-21 00:47: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-05-21 00:47:03 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_000000.csv
20 33 26s959ms 786ms 1s220ms 816ms select count(distinct animal_id) AS "count" from ( select animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, ?) as is_owner, user_is_tgm (animals_search_mview.editor, ?) as is_editor, user_is_tgm (animals_search_mview.tourist, ?) as is_tourist, case when not exists ( select ? from scoresheet_diary sd where sd.animals_id = animals_search_mview.id) then ? else ? end as isscored from animals_search_mview left join strains on strains.name = animals_search_mview.strain left join license_history lh on lh.anid = animals_search_mview.id left join animals a on a."animalID" = animals_search_mview.animal_id left join breedings b on b.id = animals_search_mview.last_mating) data where fate = ? and alive = ? and deleted = ? and (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 21 08 2 1s638ms 819ms 09 7 6s133ms 876ms 10 1 790ms 790ms 11 1 786ms 786ms 12 12 9s599ms 799ms 13 1 805ms 805ms 14 6 4s803ms 800ms 17 2 1s608ms 804ms 18 1 794ms 794ms [ User: labanimal - Total duration: 26s959ms - Times executed: 33 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 25s359ms - Times executed: 31 ]
[ Application: _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b - Total duration: 1s600ms - Times executed: 2 ]
-
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, 452) AS is_owner, user_is_tgm (animals_search_mview.editor, 452) AS is_editor, user_is_tgm (animals_search_mview.tourist, 452) 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-05-21 08:31:15 Duration: 1s220ms 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-05-21_065307.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, 156) AS is_owner, user_is_tgm (animals_search_mview.editor, 156) AS is_editor, user_is_tgm (animals_search_mview.tourist, 156) 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-05-21 08:36:30 Duration: 884ms 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-05-21_065307.csv
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 490) AS is_owner, user_is_tgm (animals_search_mview.editor, 490) AS is_editor, user_is_tgm (animals_search_mview.tourist, 490) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-05-21 08:11:46 Duration: 830ms 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-05-21_065307.csv
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1s636ms 5s753ms 2s306ms 16 36s897ms with damdam as ( select breedingid, string_agg(cast(dam as text), ?) as dam from breedingsdams inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as dam on dam.id = breedingsdams.dam and case when user_is_tgm (dam.owner, ?) then true when user_is_tgm (dam.editor, ?) then true when user_is_tgm (dam.tourist, ?) then true else false end group by breedingid ), siresire as ( select breedingid, string_agg(cast(sire as text), ?) as sire from breedingssires inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as sire on sire.id = breedingssires.sire and case when user_is_tgm (sire.owner, ?) then true when user_is_tgm (sire.editor, ?) then true when user_is_tgm (sire.tourist, ?) then true else false end group by breedingid ), cagess as ( select id, "cageName" from cages) ( select breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire from damdam, siresire, cagess, breedings where breedings.deleted != true and cagess.id = breedings.cage and cagess."cageName" like (?) and damdam.breedingid = breedings.id and siresire.breedingid = breedings.id and breedings."unbreeding_date" is null group by breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire order by breeding_date, plug_date);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 21 08 4 10s939ms 2s734ms 09 6 14s405ms 2s400ms 11 3 5s869ms 1s956ms 13 1 1s926ms 1s926ms 14 2 3s755ms 1s877ms [ User: labanimal - Total duration: 36s897ms - Times executed: 16 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 34s957ms - Times executed: 15 ]
[ Application: _desktop_index.php_cage_name_51_2A_current_only_true_val4_anima - Total duration: 1s940ms - Times executed: 1 ]
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 269) THEN TRUE WHEN user_is_tgm (dam.editor, 269) THEN TRUE WHEN user_is_tgm (dam.tourist, 269) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 269) THEN TRUE WHEN user_is_tgm (sire.editor, 269) THEN TRUE WHEN user_is_tgm (sire.tourist, 269) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND cagess."cageName" like ('61%') AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-05-21 07:31:43 Duration: 5s753ms 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-05-21_065307.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 456) THEN TRUE WHEN user_is_tgm (dam.editor, 456) THEN TRUE WHEN user_is_tgm (dam.tourist, 456) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 456) THEN TRUE WHEN user_is_tgm (sire.editor, 456) THEN TRUE WHEN user_is_tgm (sire.tourist, 456) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND cagess."cageName" like ('51%') AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-05-21 08:25:31 Duration: 3s107ms 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-05-21_065307.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 456) THEN TRUE WHEN user_is_tgm (dam.editor, 456) THEN TRUE WHEN user_is_tgm (dam.tourist, 456) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 456) THEN TRUE WHEN user_is_tgm (sire.editor, 456) THEN TRUE WHEN user_is_tgm (sire.tourist, 456) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND cagess."cageName" like ('51%') AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-05-21 08:20:40 Duration: 3s30ms 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-05-21_065307.csv
2 1s328ms 3s104ms 1s512ms 161 4m3s 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 #2
Day Hour Count Duration Avg duration May 21 01 6 13s749ms 2s291ms 02 6 13s451ms 2s241ms 03 6 10s988ms 1s831ms 04 6 8s721ms 1s453ms 05 6 8s636ms 1s439ms 06 6 8s639ms 1s439ms 07 6 10s340ms 1s723ms 08 6 10s568ms 1s761ms 09 7 11s470ms 1s638ms 10 10 13s663ms 1s366ms 11 8 10s968ms 1s371ms 12 10 13s768ms 1s376ms 13 9 12s281ms 1s364ms 15 7 9s851ms 1s407ms 16 6 8s473ms 1s412ms 17 6 8s314ms 1s385ms 18 6 8s308ms 1s384ms 19 7 9s798ms 1s399ms 20 10 14s15ms 1s401ms 21 9 12s453ms 1s383ms 22 6 8s370ms 1s395ms 23 6 8s370ms 1s395ms 00 6 8s256ms 1s376ms [ User: monitoring_admin - Total duration: 4m3s - Times executed: 161 ]
-
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-19 00:57:25+02' AND collected_at <= '2026-05-21 00:57: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-05-21 00:57:25+02' AND '2026-05-21 06:57: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-05-21 00:57:25+02' AND '2026-05-21 06:57: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-05-21 06:57:28 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-18 18:57:01+02' AND collected_at <= '2026-05-20 18:57:01+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-05-20 18:57:01+02' AND '2026-05-21 00:57:01+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-05-20 18:57:01+02' AND '2026-05-21 00:57:01+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-05-21 00:57:03 Duration: 2s568ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_000000.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-18 18:47:00+02' AND collected_at <= '2026-05-20 18:47: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-05-20 18:47:00+02' AND '2026-05-21 00:47: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-05-20 18:47:00+02' AND '2026-05-21 00:47: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-05-21 00:47:03 Duration: 2s471ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_000000.csv
3 501ms 5s753ms 1s223ms 1,440 29m21s 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 #3
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
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-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
4 501ms 5s753ms 1s223ms 1,440 29m21s 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 #4
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
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-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
5 501ms 5s753ms 1s223ms 1,440 29m21s create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
6 501ms 5s753ms 1s223ms 1,440 29m21s 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 May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
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-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
7 501ms 5s753ms 1s223ms 1,440 29m21s create schema if not exists observability;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
8 501ms 5s753ms 1s223ms 1,440 29m21s create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
9 501ms 5s753ms 1s223ms 1,440 29m21s 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 #9
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
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-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
10 501ms 5s753ms 1s223ms 1,440 29m21s create index if not exists idx_db_top_queries_tenant on observability.db_top_queries (tenant_key, collected_at desc);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
11 501ms 5s753ms 1s223ms 1,440 29m21s 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 #11
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
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-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
12 501ms 5s753ms 1s223ms 1,440 29m21s 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 May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
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-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
13 501ms 5s753ms 1s223ms 1,440 29m21s alter table observability.uptime_checks add column if not exists label text;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
14 501ms 5s753ms 1s223ms 1,440 29m21s create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
15 501ms 5s753ms 1s223ms 1,440 29m21s create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
16 501ms 5s753ms 1s223ms 1,440 29m21s create table if not exists observability.phpfpm_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 21 01 60 1m32s 1s534ms 02 60 1m45s 1s751ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m16s 1s270ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m21s - Times executed: 1438 ]
-
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-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.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-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
17 501ms 5s753ms 1s221ms 1,440 29m18s create index if not exists idx_uptime_checks_endpoint on observability.uptime_checks (endpoint, checked_at desc);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 21 01 60 1m30s 1s514ms 02 60 1m43s 1s727ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m15s 1s256ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m18s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
18 501ms 5s753ms 1s221ms 1,440 29m18s alter table observability.uptime_checks add column if not exists payload jsonb;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 21 01 60 1m30s 1s514ms 02 60 1m43s 1s727ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m15s 1s256ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m18s - Times executed: 1438 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
19 501ms 5s753ms 1s221ms 1,440 29m18s create index if not exists idx_uptime_checks_key on observability.uptime_checks (check_key, checked_at desc);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 21 01 60 1m30s 1s514ms 02 60 1m43s 1s727ms 03 60 1m27s 1s455ms 04 60 1m6s 1s103ms 05 60 1m6s 1s100ms 06 60 1m6s 1s106ms 07 60 1m7s 1s127ms 08 60 1m24s 1s409ms 09 60 1m9s 1s162ms 10 60 1m11s 1s193ms 11 60 1m11s 1s194ms 12 60 1m8s 1s142ms 13 60 1m22s 1s370ms 14 60 49s666ms 827ms 15 60 1m9s 1s160ms 16 60 1m10s 1s179ms 17 60 1m9s 1s156ms 18 60 1m9s 1s161ms 19 60 1m11s 1s194ms 20 60 1m16s 1s270ms 21 60 1m15s 1s256ms 22 60 1m9s 1s160ms 23 60 1m10s 1s171ms 00 60 1m9s 1s158ms [ User: monitoring_admin - Total duration: 29m18s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-05-21 07:32:01 Duration: 5s753ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-05-21 08:26:01 Duration: 3s107ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-05-21 06:59:01 Duration: 3s104ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
20 722ms 1s470ms 948ms 287 4m32s select distinct on (coalesce(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at from observability.uptime_checks order by coalesce(check_key, endpoint), checked_at desc;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 21 01 12 14s200ms 1s183ms 02 12 14s959ms 1s246ms 03 12 12s469ms 1s39ms 04 12 9s304ms 775ms 05 12 9s259ms 771ms 06 12 9s296ms 774ms 07 12 9s531ms 794ms 08 12 12s154ms 1s12ms 09 14 13s121ms 937ms 10 14 10s885ms 777ms 11 11 10s643ms 967ms 12 13 12s598ms 969ms 13 12 11s463ms 955ms 14 1 972ms 972ms 15 15 14s490ms 966ms 16 12 11s666ms 972ms 17 12 11s594ms 966ms 18 12 11s543ms 961ms 19 13 12s626ms 971ms 20 12 11s657ms 971ms 21 14 13s400ms 957ms 22 12 11s388ms 949ms 23 12 11s438ms 953ms 00 12 11s467ms 955ms [ User: monitoring_admin - Total duration: 4m32s - Times executed: 287 ]
-
SELECT DISTINCT ON (COALESCE(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at FROM observability.uptime_checks ORDER BY COALESCE(check_key, endpoint), checked_at DESC;
Date: 2026-05-21 08:32:46 Duration: 1s470ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
-
SELECT DISTINCT ON (COALESCE(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at FROM observability.uptime_checks ORDER BY COALESCE(check_key, endpoint), checked_at DESC;
Date: 2026-05-21 01:17:05 Duration: 1s447ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_000000.csv
-
SELECT DISTINCT ON (COALESCE(check_key, endpoint) ) check_key, label, endpoint, status, latency_ms, payload, checked_at FROM observability.uptime_checks ORDER BY COALESCE(check_key, endpoint), checked_at DESC;
Date: 2026-05-21 00:57:03 Duration: 1s406ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-05-21_000000.csv
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 160,169 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
- 3 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1 Max number of times the same event was reported
- 3 Total events found
Rank Times reported Error 1 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #1
Day Hour Count May 21 02 1 - LOG: process 1530186 still waiting for AccessExclusiveLock on relation 67471 of database 51653 after 1000.056 ms
Detail: Process holding the lock: 1530125. Wait queue: 1530186.
Statement: ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label TEXTDate: 2026-05-21 01:02:02 Database: zemm_monitoring Application: User: monitoring_admin Remote: Log file: /var/log/postgresql/postgresql-2026-05-21_000000.csv
2 1 ERROR: invalid input syntax for type date: ...
Times Reported Most Frequent Error / Event #2
Day Hour Count May 21 09 1 - ERROR: invalid input syntax for type date: ""
Statement: SELECT p_update_breedings(456, 10111240, 7405, '2026-03-18'::DATE, ''::DATE, '10287591'::TEXT, '10290989'::TEXT, '2026-05-21'::DATE) AS id
Date: 2026-05-21 08:24:38 Database: zemm_produktiv_8 Application: _desktop_index.php_cage_name_51-059_breeding_date_2026-03-18_un User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv
3 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #3
Day Hour Count May 21 07 1 - LOG: database system was shut down at 2026-05-21 06:53:04 CEST
Date: 2026-05-21 06:53:07 Log file: /var/log/postgresql/postgresql-2026-05-21_065307.csv