ZEMM PG Report-
Global information
- Generated on Mon Jun 15 06:05:31 2026
- Log file: /var/log/postgresql/postgresql-2026-05-13_000000.csv, ..., /var/log/postgresql/postgresql-2026-06-15_000000.csv
- Parsed 314,155 log entries in 5m30s
- Log start from 2026-06-02 00:00:01 to 2026-06-02 23:59:29
-
Overview
Global Stats
- 38 Number of unique normalized queries
- 24,679 Number of queries
- 23h21m27s Total query duration
- 2026-06-02 00:00:01 First query
- 2026-06-02 23:59:01 Last query
- 18 queries/s at 2026-06-02 11:44:01 Query peak
- 23h21m27s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 23h21m27s Execute total duration
- 0 Number of events
- 0 Number of unique normalized events
- 0 Max number of times the same event was reported
- 0 Number of cancellation
- 79 Total number of automatic vacuums
- 196 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 29,802 Total number of sessions
- 6 sessions at 2026-06-02 14:28:17 Session peak
- 1h36m49s Total duration of sessions
- 194ms Average duration of sessions
- 0 Average queries per session
- 2s821ms Average queries duration per session
- 0ms Average idle time per session
- 29,802 Total number of connections
- 37 connections/s at 2026-06-02 09:41:03 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 18 queries/s Query Peak
- 2026-06-02 11:44:01 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-06-02 13:59:42 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 18 queries/s Query Peak
- 2026-06-02 11:44:01 Date
Queries duration
Key values
- 23h21m27s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 02 00 1,020 0ms 0ms 0ms 0ms 0ms 0ms 01 1,021 0ms 923ms 446ms 15s698ms 15s698ms 15s698ms 02 1,020 923ms 923ms 923ms 15s698ms 15s698ms 15s698ms 03 1,020 923ms 923ms 923ms 15s698ms 15s698ms 15s698ms 04 1,020 923ms 923ms 923ms 15s698ms 15s698ms 15s698ms 05 1,021 923ms 2s908ms 1s156ms 49s440ms 49s440ms 49s440ms 06 1,022 727ms 2s908ms 2s504ms 49s440ms 49s440ms 50s947ms 07 1,032 698ms 2s826ms 953ms 46s885ms 46s885ms 49s711ms 08 1,029 519ms 2s919ms 2s604ms 50s921ms 52s195ms 52s540ms 09 1,038 689ms 2s964ms 2s380ms 51s195ms 52s246ms 52s814ms 10 1,034 695ms 3s71ms 2s809ms 52s211ms 52s211ms 55s78ms 11 1,060 710ms 2s959ms 2s200ms 51s881ms 52s245ms 52s285ms 12 1,030 2s907ms 2s978ms 2s939ms 52s773ms 53s193ms 53s549ms 13 1,055 602ms 26s925ms 2s380ms 52s760ms 53s423ms 1m17s 14 1,033 502ms 2s960ms 2s394ms 52s569ms 52s733ms 53s259ms 15 1,032 704ms 2s970ms 2s690ms 52s63ms 52s432ms 53s165ms 16 1,029 2s874ms 2s988ms 2s955ms 53s286ms 53s464ms 53s769ms 17 1,036 696ms 3s4ms 2s587ms 53s322ms 53s760ms 54s23ms 18 1,022 2s983ms 8s526ms 6s39ms 2m24s 2m24s 2m24s 19 1,020 8s526ms 8s526ms 8s526ms 2m24s 2m24s 2m24s 20 1,020 8s526ms 8s526ms 8s526ms 2m24s 2m24s 2m24s 21 1,020 8s526ms 8s526ms 8s526ms 2m24s 2m24s 2m24s 22 1,020 8s526ms 8s526ms 8s526ms 2m24s 2m24s 2m24s 23 1,025 542ms 8s526ms 8s17ms 2m24s 2m24s 2m31s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 02 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 2 0 753ms 0ms 0ms 0ms 07 10 0 742ms 0ms 0ms 2s956ms 08 2 0 519ms 0ms 0ms 0ms 09 12 0 761ms 0ms 0ms 2s881ms 10 4 0 731ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 11 0 3s109ms 0ms 0ms 2s909ms 14 3 0 584ms 0ms 0ms 502ms 15 5 0 887ms 0ms 0ms 1s508ms 16 0 0 0ms 0ms 0ms 0ms 17 6 0 729ms 0ms 0ms 1s461ms 18 1 0 8s526ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 5 1s294ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 02 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 1 0 0 923ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jun 02 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 1 1.00 0.00% 06 0 0 0.00 0.00% 07 0 2 2.00 0.00% 08 0 6 6.00 0.00% 09 0 6 6.00 0.00% 10 0 10 10.00 0.00% 11 0 8 8.00 0.00% 12 0 10 10.00 0.00% 13 0 12 12.00 0.00% 14 0 9 9.00 0.00% 15 0 7 7.00 0.00% 16 0 9 9.00 0.00% 17 0 10 10.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jun 02 00 555 0.15/s 01 546 0.15/s 02 543 0.15/s 03 543 0.15/s 04 549 0.15/s 05 572 0.16/s 06 1,396 0.39/s 07 1,793 0.50/s 08 1,774 0.49/s 09 3,327 0.92/s 10 1,793 0.50/s 11 2,526 0.70/s 12 2,245 0.62/s 13 2,854 0.79/s 14 1,533 0.43/s 15 1,628 0.45/s 16 989 0.27/s 17 1,209 0.34/s 18 674 0.19/s 19 547 0.15/s 20 555 0.15/s 21 549 0.15/s 22 553 0.15/s 23 549 0.15/s Day Hour Count Average Duration Average idle time Jun 02 00 555 239ms 239ms 01 546 243ms 0ms 02 543 245ms 0ms 03 543 244ms 0ms 04 549 238ms 0ms 05 572 239ms 0ms 06 1,396 148ms 0ms 07 1,793 157ms 0ms 08 1,774 167ms 0ms 09 3,327 129ms 0ms 10 1,793 186ms 0ms 11 2,526 179ms 0ms 12 2,245 144ms 0ms 13 2,854 226ms 0ms 14 1,533 194ms 0ms 15 1,628 187ms 0ms 16 989 265ms 0ms 17 1,209 254ms 0ms 18 674 283ms 0ms 19 547 240ms 0ms 20 555 238ms 0ms 21 549 241ms 0ms 22 553 236ms 0ms 23 549 255ms 0ms -
Connections
Established Connections
Key values
- 37 connections Connection Peak
- 2026-06-02 09:41:03 Date
Connections per database
Key values
- zemm_monitoring Main Database
- 29,802 connections Total
Connections per user
Key values
- labanimal Main User
- 29,802 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2026-06-02 14:28:17 Date
Histogram of session times
Key values
- 27,178 0-500ms duration
Sessions per database
Key values
- zemm_monitoring Main Database
- 29,802 sessions Total
Sessions per user
Key values
- labanimal Main User
- 29,802 sessions Total
Sessions per host
Key values
- ::1 Main Host
- 29,802 sessions Total
Sessions per application
Key values
- Main Application
- 29,802 sessions Total
Application Count Total Duration Average Duration 24,106 1h23m57s 208ms _desktop__zemm_produktiv_8_localhost_5432 23 1s367ms 59ms _desktop_index.php_cage_name_46_2A_unweaned_only_true_val4_anim 12 18s283ms 1s523ms _desktop_index.php_cages_name_A15.415-_2A_cages_empty__25_val4_ 5 337ms 67ms _desktop_index.php_command_animals_edit_subcommand_init_id_1027 1 100ms 100ms _desktop_index.php_command_animals_edit_subcommand_init_id_1030 4 355ms 88ms _desktop_index.php_command_animals_litters_edit_subcommand_init 1 91ms 91ms _desktop_index.php_command_animals_subcommand_found_val1_101000 2 94ms 47ms _desktop_index.php_command_animals_subcommand_found_val1_101001 1 46ms 46ms _desktop_index.php_command_animals_subcommand_found_val1_101002 2 81ms 40ms _desktop_index.php_command_animals_subcommand_found_val1_101003 2 93ms 46ms _desktop_index.php_command_animals_subcommand_found_val1_101004 1 47ms 47ms _desktop_index.php_command_animals_subcommand_found_val1_1357_v 1 44ms 44ms _desktop_index.php_command_animals_subcommand_found_val1_1491_v 5 202ms 40ms _desktop_index.php_command_animals_subcommand_found_val1_1641_v 1 44ms 44ms _desktop_index.php_command_animals_subcommand_found_val1_1669_v 1 34ms 34ms _desktop_index.php_command_animals_subcommand_found_val1_1674_v 1 32ms 32ms _desktop_index.php_command_animals_subcommand_init_zemm_produkt 16 713ms 44ms _desktop_index.php_command_cages_subcommand_init_zemm_produktiv 1 39ms 39ms _desktop_index.php_command_login_subcommand_init__zemm_dev_loca 1 35ms 35ms _desktop_index.php_command_login_subcommand_init__zemm_produkti 1 33ms 33ms _desktop_index.php_command_login_subcommand_init__zemm_test_loc 1 26ms 26ms _desktop_index.php_command_login_subcommand_init_zemm_produktiv 1,697 49s992ms 29ms _desktop_index.php_command_login_subcommand_init_zemm_test_loca 5 165ms 33ms _desktop_index.php_command_reports_subcommand_animals_per_user_ 6 657ms 109ms _desktop_index.php_command_tasks_subcommand_edit_id_10143168_ze 1 84ms 84ms _desktop_index.php_command_tasks_subcommand_edit_id_10143304_ze 1 82ms 82ms _desktop_index.php_command_tasks_subcommand_edit_id_10143305_ze 1 82ms 82ms _desktop_index.php_command_tasks_subcommand_edit_id_10143306_ze 1 82ms 82ms _desktop_index.php_command_tasks_subcommand_edit_id_10143324_ze 1 80ms 80ms _desktop_index.php_command_tasks_subcommand_edit_id_10143325_ze 1 81ms 81ms _desktop_index.php_command_tasks_subcommand_edit_id_10143368_ze 2 161ms 80ms _desktop_index.php_command_tasks_subcommand_init_zemm_produktiv 93 7s320ms 78ms _desktop_index.php_command_tasks_subcommand_open_legacy_1_id_10 33 1s905ms 57ms _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv 4 4s229ms 1s57ms _desktop_index.php_m_action_animals_edit_3Alink_init_row_animal 1 75ms 75ms _desktop_index.php_name_Abt_C3_B6ten_20alter_20Zuchtpaare_instr 1 41ms 41ms _desktop_index.php_name_Genotypisierungsproben_20genommen_instr 1 68ms 68ms _desktop_index.php_name_Neue_20Aufgabe_add_link_animals_task_st 2 86ms 43ms _desktop_index.php_name_Nova_20Tarefa_add_link_animals_task_sta 1 44ms 44ms _desktop_index.php_search_status__25_issuer_user_name_Jansen_2C 4 228ms 57ms _desktop_index.php_view_animal_name_on_view_animal_id_on_animal 2 548ms 274ms _desktop_index.php_view_animal_name_on_view_animal_id_on_view_b 42 22s995ms 547ms _desktop_index.php_zemm_produktiv_8_localhost_5432 3,655 10m31s 172ms backend:zemm_produktiv_8@localhost 29 2s741ms 94ms bounces:zemm_produktiv_8@h2940066.stratoserver.net:5432 1 59ms 59ms expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 1 940ms 940ms pg_dump 1 10s646ms 10s646ms psql 2 13ms 6ms taskscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 24 14s768ms 615ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 19,629 buffers Checkpoint Peak
- 2026-06-02 01:38:37 Date
- 269.604 seconds Highest write time
- 0.029 seconds Sync time
Checkpoints Wal files
Key values
- 6 files Wal files usage Peak
- 2026-06-02 01:38:37 Date
Checkpoints distance
Key values
- 186.98 Mo Distance Peak
- 2026-06-02 01:38:37 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 02 00 9,299 930.513s 0.109s 930.688s 01 27,190 1,026.243s 0.107s 1,026.406s 02 8,729 873.402s 0.101s 873.552s 03 8,411 841.768s 0.107s 841.928s 04 8,273 827.432s 0.099s 827.587s 05 12,959 1,035.708s 0.104s 1,035.865s 06 10,198 1,020.641s 0.203s 1,020.894s 07 10,970 1,098.28s 0.217s 1,098.554s 08 11,365 1,137.374s 0.234s 1,137.659s 09 12,446 1,245.949s 0.24s 1,246.241s 10 10,366 1,037.414s 0.189s 1,037.655s 11 11,026 1,103.79s 0.234s 1,104.075s 12 10,942 1,094.337s 0.219s 1,094.609s 13 12,808 1,281.442s 0.252s 1,281.748s 14 13,949 1,168.778s 0.207s 1,169.045s 15 10,037 1,004.2s 0.182s 1,004.434s 16 10,839 1,084.828s 0.116s 1,084.999s 17 9,576 958.29s 0.122s 958.468s 18 16,087 1,061.278s 0.109s 1,061.438s 19 8,497 850.295s 0.107s 850.46s 20 8,574 858.304s 0.11s 858.473s 21 8,468 847.059s 0.104s 847.222s 22 8,213 821.918s 0.096s 822.068s 23 9,490 948.998s 0.1s 949.154s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 02 00 0 0 2 560 0.003s 0.012s 01 0 0 8 553 0.003s 0.012s 02 0 0 1 535 0.002s 0.012s 03 0 0 2 547 0.004s 0.012s 04 0 0 2 524 0.002s 0.012s 05 0 0 2 534 0.002s 0.012s 06 0 0 3 1,175 0.002s 0.012s 07 0 0 2 1,218 0.007s 0.012s 08 0 0 2 1,266 0.004s 0.012s 09 0 0 3 1,433 0.002s 0.012s 10 0 0 2 1,029 0.004s 0.012s 11 0 0 2 1,344 0.002s 0.012s 12 0 0 3 1,215 0.004s 0.012s 13 0 0 3 1,487 0.002s 0.012s 14 0 0 2 1,174 0.003s 0.012s 15 0 0 2 1,038 0.002s 0.012s 16 0 0 2 606 0.004s 0.012s 17 0 0 2 654 0.002s 0.012s 18 0 0 3 585 0.001s 0.012s 19 0 0 1 571 0.004s 0.012s 20 0 0 2 573 0.002s 0.012s 21 0 0 2 557 0.001s 0.012s 22 0 0 1 522 0.001s 0.012s 23 0 0 2 532 0.001s 0.012s Day Hour Count Avg time (sec) Jun 02 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jun 02 00 2,547.17 kB 3,331.75 kB 01 10,129.42 kB 34,756.58 kB 02 2,471.00 kB 35,433.58 kB 03 2,345.83 kB 11,744.67 kB 04 2,326.75 kB 4,971.08 kB 05 3,557.58 kB 4,354.83 kB 06 2,902.42 kB 10,282.67 kB 07 3,118.67 kB 5,236.75 kB 08 3,355.33 kB 5,711.00 kB 09 3,699.75 kB 5,165.92 kB 10 2,909.50 kB 4,335.75 kB 11 3,213.08 kB 3,854.08 kB 12 3,139.50 kB 3,583.50 kB 13 3,761.00 kB 4,546.33 kB 14 3,252.83 kB 5,071.50 kB 15 2,752.08 kB 5,215.58 kB 16 2,588.17 kB 3,414.67 kB 17 2,587.17 kB 3,259.75 kB 18 3,962.42 kB 9,165.58 kB 19 2,303.92 kB 9,021.25 kB 20 2,284.83 kB 4,251.33 kB 21 2,253.25 kB 3,126.92 kB 22 2,229.33 kB 2,947.83 kB 23 2,525.67 kB 2,903.25 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 02 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 2.28 sec Highest CPU-cost vacuum
Table observability.metrics_timeseries
Database zemm_monitoring - 2026-06-02 18:31:24 Date
- 0 sec Highest CPU-cost analyze
Table
Database zemm_monitoring - Date
Average Autovacuum Duration
Key values
- 2.28 sec Highest CPU-cost vacuum
Table observability.metrics_timeseries
Database zemm_monitoring - 2026-06-02 18:31:24 Date
Analyzes per table
Key values
- pg_catalog.pg_type (62) Main table analyzed (database zemm_produktiv_8)
- 196 analyzes Total
Table Number of analyzes zemm_produktiv_8.pg_catalog.pg_type 62 zemm_produktiv_8.pg_catalog.pg_attribute 47 zemm_produktiv_8.pg_catalog.pg_class 33 zemm_produktiv_8.pg_catalog.pg_depend 30 fbi_unibi.pg_catalog.pg_shdepend 3 zemm_monitoring.pg_catalog.pg_shdepend 3 zemm_monitoring.observability.metrics_timeseries 3 zemm_produktiv_8.public.tmptasks 3 zemm_produktiv_8.public.cages_search_mview 2 labanimal.pg_catalog.pg_shdepend 2 zemm_produktiv_8.public.roles_users 1 template0.pg_catalog.pg_shdepend 1 zemm_produktiv_8.public.tasks 1 zemm_dev.pg_catalog.pg_shdepend 1 zemm_produktiv_8.public.users 1 zemm_monitoring.observability.system_metrics 1 zemm_produktiv_8.public.groupMembers 1 postgres.pg_catalog.pg_shdepend 1 Total 196 Vacuums per table
Key values
- pg_catalog.pg_type (22) Main table vacuumed on database zemm_produktiv_8
- 79 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 22 22 0 0 0 0 0 1,161 265 288,435 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 17 17 0 0 0 0 0 2,156 644 477,537 0 0 zemm_produktiv_8.pg_catalog.pg_class 11 11 0 0 0 0 0 1,040 331 392,214 0 0 zemm_produktiv_8.pg_catalog.pg_depend 9 9 0 0 0 0 0 1,184 318 426,146 0 0 fbi_ci_db.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 350 114 240,963 0 0 zemm_produktiv_8.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 785 178 978,726 37 110 zemm_monitoring.pg_toast.pg_toast_181881 4 0 0 0 0 0 0 1,207 412 2,036,241 397 2,191 zemm_monitoring.pg_toast.pg_toast_67431 3 1 0 0 0 0 0 13,439 5,337 9,419,764 1,756 10,494 zemm_produktiv_8.public.tasks 1 1 0 0 0 0 0 48,103 55 3,541,284 2 3 zemm_produktiv_8.public.tmptasks 1 1 0 0 0 0 0 76 27 18,598 0 0 zemm_monitoring.observability.metrics_timeseries 1 1 0 0 0 0 0 16,961 7,702 19,373,291 1,898 44,061 zemm_monitoring.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 97 25 138,757 7 25 Total 79 73 0 0 0 0 0 86,559 15,408 37,331,956 4,097 56,884 Vacuum throughput per table
Key values
- observability.metrics_timeseries (2.28) Max CPU elapsed for vacuum on database zemm_monitoring
- observability.metrics_timeseries (2.102 ms) Max I/O read time for vacuum on database zemm_monitoring
- observability.metrics_timeseries (1.216 ms) Max I/O write time for vacuum on database zemm_monitoring
I/O timing (ms) CPU (s) Table read write elapsed zemm_produktiv_8.pg_catalog.pg_type 0 0 0 zemm_produktiv_8.pg_catalog.pg_attribute 0 0 0.17 zemm_produktiv_8.pg_catalog.pg_class 0 0 0 zemm_produktiv_8.pg_catalog.pg_depend 0 0 0.07 fbi_ci_db.pg_catalog.pg_shdepend 0.617 0 0 zemm_produktiv_8.pg_toast.pg_toast_2619 0 0 0.04 zemm_monitoring.pg_toast.pg_toast_181881 0 0 0.08 zemm_monitoring.pg_toast.pg_toast_67431 0.561 0.093 1.39 zemm_produktiv_8.public.tasks 0 0 0.61 zemm_produktiv_8.public.tmptasks 0.3 0 0 zemm_monitoring.observability.metrics_timeseries 2.102 1.216 2.28 zemm_monitoring.pg_toast.pg_toast_2619 0 0 0 Total 3.58 1.309 4.64 Tuples removed per table
Key values
- public.tasks (54838) Main table with removed tuples on database zemm_produktiv_8
- 124998 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain zemm_produktiv_8.public.tasks 1 1 54,838 57,916 0 0 17,131 zemm_monitoring.observability.metrics_timeseries 1 1 32,740 385,541 0 0 8,322 zemm_produktiv_8.pg_catalog.pg_attribute 17 17 15,765 92,275 0 0 3,128 zemm_monitoring.pg_toast.pg_toast_67431 3 1 7,036 1,976,357 0 0 392,686 zemm_produktiv_8.pg_catalog.pg_depend 9 9 6,848 37,773 0 0 495 zemm_produktiv_8.pg_catalog.pg_type 22 22 4,336 18,282 0 0 682 zemm_produktiv_8.pg_catalog.pg_class 11 11 1,726 9,933 0 0 462 fbi_ci_db.pg_catalog.pg_shdepend 5 5 1,116 23,525 0 0 190 zemm_produktiv_8.pg_toast.pg_toast_2619 4 4 460 1,155 0 0 424 zemm_produktiv_8.public.tmptasks 1 1 72 827 0 0 121 zemm_monitoring.pg_toast.pg_toast_2619 1 1 61 83 0 0 38 zemm_monitoring.pg_toast.pg_toast_181881 4 0 0 95,246 0 0 17,314 Total 79 73 124,998 2,698,913 0 0 440,993 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_type 22 22 4336 0 zemm_monitoring.pg_toast.pg_toast_67431 3 1 7036 0 zemm_produktiv_8.pg_catalog.pg_attribute 17 17 15765 0 fbi_ci_db.pg_catalog.pg_shdepend 5 5 1116 0 zemm_produktiv_8.pg_catalog.pg_depend 9 9 6848 0 zemm_produktiv_8.public.tasks 1 1 54838 0 zemm_produktiv_8.pg_catalog.pg_class 11 11 1726 0 zemm_produktiv_8.public.tmptasks 1 1 72 0 zemm_produktiv_8.pg_toast.pg_toast_2619 4 4 460 0 zemm_monitoring.observability.metrics_timeseries 1 1 32740 0 zemm_monitoring.pg_toast.pg_toast_2619 1 1 61 0 zemm_monitoring.pg_toast.pg_toast_181881 4 0 0 0 Total 79 73 124,998 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 02 00 1 1 01 2 1 02 1 1 03 0 0 04 0 0 05 1 0 06 7 20 07 4 13 08 8 14 09 15 47 10 4 10 11 8 19 12 9 28 13 7 21 14 4 8 15 4 12 16 1 0 17 0 0 18 1 0 19 0 0 20 1 0 21 0 0 22 0 0 23 1 1 - 2.28 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 56 Total read queries
- 24,623 Total write queries
Queries by database
Key values
- zemm_monitoring Main database
- 24,571 Requests
- 23h19m25s (zemm_monitoring)
- Main time consuming database
Queries by user
Key values
- monitoring_admin Main user
- 516,638 Requests
User Request type Count Duration labanimal Total 1,787 40m59s copy to 8 22s808ms cte 305 6m41s select 1,453 33m32s update 21 22s900ms monitoring_admin Total 516,638 30d13h4m38s cte 1,774 4h3m18s ddl 514,008 30d8h49m1s delete 1 603ms select 850 12m13s postgres Total 110 2m30s copy to 110 2m30s Duration by user
Key values
- 30d13h4m38s (monitoring_admin) Main time consuming user
User Request type Count Duration labanimal Total 1,787 40m59s copy to 8 22s808ms cte 305 6m41s select 1,453 33m32s update 21 22s900ms monitoring_admin Total 516,638 30d13h4m38s cte 1,774 4h3m18s ddl 514,008 30d8h49m1s delete 1 603ms select 850 12m13s postgres Total 110 2m30s copy to 110 2m30s Queries by host
Key values
- unknown Main host
- 518,404 Requests
- 30d13h45m14s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 24,571 Requests
- 23h19m25s (unknown)
- Main time consuming application
Application Request type Count Duration _desktop_index.php_cage_name_46_2A_unweaned_only_true_val4_anim Total 24 17s798ms cte 24 17s798ms _desktop_index.php_zemm_produktiv_8_localhost_5432 Total 78 1m37s cte 22 21s806ms select 56 1m15s expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 Total 1 923ms update 1 923ms pg_dump Total 5 6s472ms copy to 5 6s472ms unknown Total 24,571 23h19m25s cte 91 4m26s ddl 24,480 23h14m58s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-02 09:11:15 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 103 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 26s925ms SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 492) AS is_owner, user_is_tgm (animals_search_mview.editor, 492) AS is_editor, user_is_tgm (animals_search_mview.tourist, 492) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE (is_owner OR is_editor OR is_tourist);[ Date: 2026-06-02 13:44:07 - Database: zemm_produktiv_8 - User: labanimal - Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Bind query: yes ]
2 8s526ms SELECT a.id, a.name, a."animalID", a.dummy_strain_info, a."birthDate", a.sex, tr.rfid FROM animals a LEFT OUTER JOIN cages c ON c.id = a."homeCage" LEFT OUTER JOIN ( SELECT max(id) AS id, maps_to FROM transponders WHERE extraction_date IS NULL GROUP BY maps_to) tr_sel ON tr_sel.maps_to = a.id LEFT OUTER JOIN transponders tr ON tr.id = tr_sel.id WHERE NOT (a.deleted) AND c.id = 12632 AND CASE WHEN user_is_tgm (a.owner, 574) THEN TRUE WHEN user_is_tgm (a.editor, 574) THEN TRUE WHEN user_is_tgm (a.tourist, 574) THEN TRUE ELSE FALSE END ORDER BY a.id;[ Date: 2026-06-02 18:26:28 - Database: zemm_produktiv_8 - User: labanimal - Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Bind query: yes ]
3 8s526ms CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-06-02 18:27:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
4 8s526ms CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );[ Date: 2026-06-02 18:27:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
5 8s526ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-06-02 18:27:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
6 8s526ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-06-02 18:27:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
7 8s526ms CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-06-02 18:27:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
8 8s526ms CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);[ Date: 2026-06-02 18:27:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
9 8s526ms CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);[ Date: 2026-06-02 18:27:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
10 8s526ms CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-06-02 18:27:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
11 8s526ms CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);[ Date: 2026-06-02 18:27:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
12 8s526ms CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-06-02 18:27:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
13 8s526ms CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-06-02 18:27:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
14 8s526ms CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-06-02 18:27:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
15 8s526ms CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );[ Date: 2026-06-02 18:27:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
16 8s526ms ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;[ Date: 2026-06-02 18:27:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
17 8s526ms ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;[ Date: 2026-06-02 18:27:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
18 8s526ms CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);[ Date: 2026-06-02 18:27:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
19 8s526ms CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);[ Date: 2026-06-02 18:27:01 - Database: zemm_monitoring - User: monitoring_admin - Bind query: yes ]
20 8s526ms CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-06-02 18:28: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 1h22m3s 1,440 502ms 8s526ms 3s419ms 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 #1
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
2 1h22m3s 1,440 502ms 8s526ms 3s419ms 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 #2
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
3 1h22m3s 1,440 502ms 8s526ms 3s419ms 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 Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
4 1h22m3s 1,440 502ms 8s526ms 3s419ms alter table observability.uptime_checks add column if not exists label text;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
5 1h22m3s 1,440 502ms 8s526ms 3s419ms create table if not exists observability.nginx_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
6 1h22m3s 1,440 502ms 8s526ms 3s419ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
7 1h22m3s 1,440 502ms 8s526ms 3s419ms 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 #7
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
8 1h22m3s 1,440 502ms 8s526ms 3s419ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
9 1h22m3s 1,440 502ms 8s526ms 3s419ms alter table observability.uptime_checks add column if not exists payload jsonb;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
10 1h22m3s 1,440 502ms 8s526ms 3s419ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
11 1h22m3s 1,440 502ms 8s526ms 3s419ms create schema if not exists observability;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
12 1h22m3s 1,440 502ms 8s526ms 3s419ms 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 #12
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
13 1h22m3s 1,440 502ms 8s526ms 3s419ms create index if not exists idx_uptime_checks_key on observability.uptime_checks (check_key, checked_at desc);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
14 1h22m3s 1,440 502ms 8s526ms 3s419ms 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 #14
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
15 1h22m3s 1,440 502ms 8s526ms 3s419ms 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 Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
16 1h22m3s 1,440 502ms 8s526ms 3s419ms 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 #16
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
17 1h22m3s 1,440 502ms 8s526ms 3s419ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
18 4m26s 91 2s757ms 3s71ms 2s926ms with start_snap as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at >= ? and collected_at <= ? order by tenant_key, fingerprint, collected_at desc ), fallback_start as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at between ? and ? order by tenant_key, fingerprint, collected_at asc ), end_snap as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at between ? and ? order by tenant_key, fingerprint, collected_at desc ), deltas as ( select e.tenant_key, e.fingerprint, e.query, e.collected_at as last_seen, greatest (coalesce(e.total_time_ms, ?) - coalesce(s.total_time_ms, fs.total_time_ms, ?), ?) as total_time_ms, greatest (coalesce(e.calls, ?) - coalesce(s.calls, fs.calls, ?), ?) as calls, greatest (coalesce(e.rows_returned, ?) - coalesce(s.rows_returned, fs.rows_returned, ?), ?) as rows_returned from end_snap e left join start_snap s on s.tenant_key = e.tenant_key and s.fingerprint = e.fingerprint left join fallback_start fs on fs.tenant_key = e.tenant_key and fs.fingerprint = e.fingerprint and s.tenant_key is null ) select fingerprint, max(query) as query, max(last_seen) as last_seen, sum(total_time_ms) as total_time_ms, sum(calls) as calls, sum(rows_returned) as rows_returned, case when sum(calls) > ? then sum(total_time_ms) / sum(calls) else ? end as mean_time_ms, array_agg(distinct tenant_key order by tenant_key) as tenant_keys from deltas where total_time_ms > ? or calls > ? group by fingerprint order by total_time_ms desc, calls desc limit ? offset ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 02 06 1 2s908ms 2s908ms 08 2 5s583ms 2s791ms 09 6 17s351ms 2s891ms 10 6 17s431ms 2s905ms 11 10 28s950ms 2s895ms 12 8 23s132ms 2s891ms 13 10 29s335ms 2s933ms 14 12 35s425ms 2s952ms 15 9 26s385ms 2s931ms 16 7 20s469ms 2s924ms 17 9 26s586ms 2s954ms 18 10 29s733ms 2s973ms 19 1 3s3ms 3s3ms [ User: monitoring_admin - Total duration: 4m26s - Times executed: 91 ]
-
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-30 22:27:00+02' AND collected_at <= '2026-06-01 22:27:00+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-01 22:27:00+02' AND '2026-06-02 10:27:00+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-01 22:27:00+02' AND '2026-06-02 10:27:00+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-06-02 10:27:03 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_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-31 01:36:53+02' AND collected_at <= '2026-06-02 01:36:53+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 01:36:53+02' AND '2026-06-02 13:36:53+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 01:36:53+02' AND '2026-06-02 13:36:53+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-06-02 13:36:56 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_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-31 05:42:34+02' AND collected_at <= '2026-06-02 05:42:34+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 05:42:34+02' AND '2026-06-02 17:42:34+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 05:42:34+02' AND '2026-06-02 17:42:34+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-06-02 17:42:37 Duration: 3s4ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
19 29s58ms 40 618ms 784ms 726ms with readable_targetgroups as materialized ( select tgm.targetgroup from "targetgroupMembers" tgm where tgm."user" = ? union select tgm.targetgroup from "targetgroupMembers" tgm join "groupMembers" gm on gm."group" = tgm."group" where gm."user" = ? ) select * from litters_search_mview l where not (deleted) and (l.owner in ( select targetgroup from readable_targetgroups) or l.editor in ( select targetgroup from readable_targetgroups) or l.tourist in ( select targetgroup from readable_targetgroups)) and (offspring - case when male_wean is null then ? else male_wean end - case when female_wean is null then ? else female_wean end - case when male_dead is null then ? else male_dead end - case when female_dead is null then ? else female_dead end - case when female_deceased is null then ? else female_deceased end - case when male_deceased is null then ? else male_deceased end) > ? and "cageName" like ? order by bday desc, dam_name, sire_name;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 02 12 32 23s724ms 741ms 14 8 5s333ms 666ms [ User: labanimal - Total duration: 29s58ms - Times executed: 40 ]
[ Application: _desktop_index.php_cage_name_46_2A_unweaned_only_true_val4_anim - Total duration: 17s798ms - Times executed: 24 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 11s259ms - Times executed: 16 ]
-
WITH readable_targetgroups AS MATERIALIZED ( SELECT tgm.targetgroup FROM "targetgroupMembers" tgm WHERE tgm."user" = 457 UNION SELECT tgm.targetgroup FROM "targetgroupMembers" tgm JOIN "groupMembers" gm ON gm."group" = tgm."group" WHERE gm."user" = 457 ) SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND (l.owner IN ( SELECT targetgroup FROM readable_targetgroups) OR l.editor IN ( SELECT targetgroup FROM readable_targetgroups) OR l.tourist IN ( SELECT targetgroup FROM readable_targetgroups)) AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) > 0 AND "cageName" LIKE '46%' ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-06-02 11:44:01 Duration: 784ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_cage_name_46_2A_unweaned_only_true_val4_anim Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
WITH readable_targetgroups AS MATERIALIZED ( SELECT tgm.targetgroup FROM "targetgroupMembers" tgm WHERE tgm."user" = 457 UNION SELECT tgm.targetgroup FROM "targetgroupMembers" tgm JOIN "groupMembers" gm ON gm."group" = tgm."group" WHERE gm."user" = 457 ) SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND (l.owner IN ( SELECT targetgroup FROM readable_targetgroups) OR l.editor IN ( SELECT targetgroup FROM readable_targetgroups) OR l.tourist IN ( SELECT targetgroup FROM readable_targetgroups)) AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) > 0 AND "cageName" LIKE '46%' ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-06-02 11:43:33 Duration: 775ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_cage_name_46_2A_unweaned_only_true_val4_anim Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
WITH readable_targetgroups AS MATERIALIZED ( SELECT tgm.targetgroup FROM "targetgroupMembers" tgm WHERE tgm."user" = 457 UNION SELECT tgm.targetgroup FROM "targetgroupMembers" tgm JOIN "groupMembers" gm ON gm."group" = tgm."group" WHERE gm."user" = 457 ) SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND (l.owner IN ( SELECT targetgroup FROM readable_targetgroups) OR l.editor IN ( SELECT targetgroup FROM readable_targetgroups) OR l.tourist IN ( SELECT targetgroup FROM readable_targetgroups)) AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) > 0 AND "cageName" LIKE '46%' ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-06-02 11:38:25 Duration: 768ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
20 26s925ms 1 26s925ms 26s925ms 26s925ms 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 (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 02 14 1 26s925ms 26s925ms [ User: labanimal - Total duration: 26s925ms - Times executed: 1 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 26s925ms - Times executed: 1 ]
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 492) AS is_owner, user_is_tgm (animals_search_mview.editor, 492) AS is_editor, user_is_tgm (animals_search_mview.tourist, 492) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE (is_owner OR is_editor OR is_tourist);
Date: 2026-06-02 13:44:07 Duration: 26s925ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,440 1h22m3s 502ms 8s526ms 3s419ms 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 #1
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
2 1,440 1h22m3s 502ms 8s526ms 3s419ms 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 #2
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
3 1,440 1h22m3s 502ms 8s526ms 3s419ms 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 Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
4 1,440 1h22m3s 502ms 8s526ms 3s419ms alter table observability.uptime_checks add column if not exists label text;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
5 1,440 1h22m3s 502ms 8s526ms 3s419ms create table if not exists observability.nginx_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
6 1,440 1h22m3s 502ms 8s526ms 3s419ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
7 1,440 1h22m3s 502ms 8s526ms 3s419ms 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 #7
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
8 1,440 1h22m3s 502ms 8s526ms 3s419ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
9 1,440 1h22m3s 502ms 8s526ms 3s419ms alter table observability.uptime_checks add column if not exists payload jsonb;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
10 1,440 1h22m3s 502ms 8s526ms 3s419ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
11 1,440 1h22m3s 502ms 8s526ms 3s419ms create schema if not exists observability;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
12 1,440 1h22m3s 502ms 8s526ms 3s419ms 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 #12
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
13 1,440 1h22m3s 502ms 8s526ms 3s419ms create index if not exists idx_uptime_checks_key on observability.uptime_checks (check_key, checked_at desc);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
14 1,440 1h22m3s 502ms 8s526ms 3s419ms 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 #14
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
15 1,440 1h22m3s 502ms 8s526ms 3s419ms 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 Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
16 1,440 1h22m3s 502ms 8s526ms 3s419ms 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 #16
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
17 1,440 1h22m3s 502ms 8s526ms 3s419ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
18 91 4m26s 2s757ms 3s71ms 2s926ms with start_snap as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at >= ? and collected_at <= ? order by tenant_key, fingerprint, collected_at desc ), fallback_start as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at between ? and ? order by tenant_key, fingerprint, collected_at asc ), end_snap as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at between ? and ? order by tenant_key, fingerprint, collected_at desc ), deltas as ( select e.tenant_key, e.fingerprint, e.query, e.collected_at as last_seen, greatest (coalesce(e.total_time_ms, ?) - coalesce(s.total_time_ms, fs.total_time_ms, ?), ?) as total_time_ms, greatest (coalesce(e.calls, ?) - coalesce(s.calls, fs.calls, ?), ?) as calls, greatest (coalesce(e.rows_returned, ?) - coalesce(s.rows_returned, fs.rows_returned, ?), ?) as rows_returned from end_snap e left join start_snap s on s.tenant_key = e.tenant_key and s.fingerprint = e.fingerprint left join fallback_start fs on fs.tenant_key = e.tenant_key and fs.fingerprint = e.fingerprint and s.tenant_key is null ) select fingerprint, max(query) as query, max(last_seen) as last_seen, sum(total_time_ms) as total_time_ms, sum(calls) as calls, sum(rows_returned) as rows_returned, case when sum(calls) > ? then sum(total_time_ms) / sum(calls) else ? end as mean_time_ms, array_agg(distinct tenant_key order by tenant_key) as tenant_keys from deltas where total_time_ms > ? or calls > ? group by fingerprint order by total_time_ms desc, calls desc limit ? offset ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 02 06 1 2s908ms 2s908ms 08 2 5s583ms 2s791ms 09 6 17s351ms 2s891ms 10 6 17s431ms 2s905ms 11 10 28s950ms 2s895ms 12 8 23s132ms 2s891ms 13 10 29s335ms 2s933ms 14 12 35s425ms 2s952ms 15 9 26s385ms 2s931ms 16 7 20s469ms 2s924ms 17 9 26s586ms 2s954ms 18 10 29s733ms 2s973ms 19 1 3s3ms 3s3ms [ User: monitoring_admin - Total duration: 4m26s - Times executed: 91 ]
-
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-30 22:27:00+02' AND collected_at <= '2026-06-01 22:27:00+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-01 22:27:00+02' AND '2026-06-02 10:27:00+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-01 22:27:00+02' AND '2026-06-02 10:27:00+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-06-02 10:27:03 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_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-31 01:36:53+02' AND collected_at <= '2026-06-02 01:36:53+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 01:36:53+02' AND '2026-06-02 13:36:53+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 01:36:53+02' AND '2026-06-02 13:36:53+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-06-02 13:36:56 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_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-31 05:42:34+02' AND collected_at <= '2026-06-02 05:42:34+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 05:42:34+02' AND '2026-06-02 17:42:34+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 05:42:34+02' AND '2026-06-02 17:42:34+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-06-02 17:42:37 Duration: 3s4ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
19 40 29s58ms 618ms 784ms 726ms with readable_targetgroups as materialized ( select tgm.targetgroup from "targetgroupMembers" tgm where tgm."user" = ? union select tgm.targetgroup from "targetgroupMembers" tgm join "groupMembers" gm on gm."group" = tgm."group" where gm."user" = ? ) select * from litters_search_mview l where not (deleted) and (l.owner in ( select targetgroup from readable_targetgroups) or l.editor in ( select targetgroup from readable_targetgroups) or l.tourist in ( select targetgroup from readable_targetgroups)) and (offspring - case when male_wean is null then ? else male_wean end - case when female_wean is null then ? else female_wean end - case when male_dead is null then ? else male_dead end - case when female_dead is null then ? else female_dead end - case when female_deceased is null then ? else female_deceased end - case when male_deceased is null then ? else male_deceased end) > ? and "cageName" like ? order by bday desc, dam_name, sire_name;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 02 12 32 23s724ms 741ms 14 8 5s333ms 666ms [ User: labanimal - Total duration: 29s58ms - Times executed: 40 ]
[ Application: _desktop_index.php_cage_name_46_2A_unweaned_only_true_val4_anim - Total duration: 17s798ms - Times executed: 24 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 11s259ms - Times executed: 16 ]
-
WITH readable_targetgroups AS MATERIALIZED ( SELECT tgm.targetgroup FROM "targetgroupMembers" tgm WHERE tgm."user" = 457 UNION SELECT tgm.targetgroup FROM "targetgroupMembers" tgm JOIN "groupMembers" gm ON gm."group" = tgm."group" WHERE gm."user" = 457 ) SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND (l.owner IN ( SELECT targetgroup FROM readable_targetgroups) OR l.editor IN ( SELECT targetgroup FROM readable_targetgroups) OR l.tourist IN ( SELECT targetgroup FROM readable_targetgroups)) AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) > 0 AND "cageName" LIKE '46%' ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-06-02 11:44:01 Duration: 784ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_cage_name_46_2A_unweaned_only_true_val4_anim Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
WITH readable_targetgroups AS MATERIALIZED ( SELECT tgm.targetgroup FROM "targetgroupMembers" tgm WHERE tgm."user" = 457 UNION SELECT tgm.targetgroup FROM "targetgroupMembers" tgm JOIN "groupMembers" gm ON gm."group" = tgm."group" WHERE gm."user" = 457 ) SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND (l.owner IN ( SELECT targetgroup FROM readable_targetgroups) OR l.editor IN ( SELECT targetgroup FROM readable_targetgroups) OR l.tourist IN ( SELECT targetgroup FROM readable_targetgroups)) AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) > 0 AND "cageName" LIKE '46%' ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-06-02 11:43:33 Duration: 775ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_cage_name_46_2A_unweaned_only_true_val4_anim Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
WITH readable_targetgroups AS MATERIALIZED ( SELECT tgm.targetgroup FROM "targetgroupMembers" tgm WHERE tgm."user" = 457 UNION SELECT tgm.targetgroup FROM "targetgroupMembers" tgm JOIN "groupMembers" gm ON gm."group" = tgm."group" WHERE gm."user" = 457 ) SELECT * FROM litters_search_mview l WHERE NOT (deleted) AND (l.owner IN ( SELECT targetgroup FROM readable_targetgroups) OR l.editor IN ( SELECT targetgroup FROM readable_targetgroups) OR l.tourist IN ( SELECT targetgroup FROM readable_targetgroups)) AND (offspring - CASE WHEN male_wean IS NULL THEN 0 ELSE male_wean END - CASE WHEN female_wean IS NULL THEN 0 ELSE female_wean END - CASE WHEN male_dead IS NULL THEN 0 ELSE male_dead END - CASE WHEN female_dead IS NULL THEN 0 ELSE female_dead END - CASE WHEN female_deceased IS NULL THEN 0 ELSE female_deceased END - CASE WHEN male_deceased IS NULL THEN 0 ELSE male_deceased END) > 0 AND "cageName" LIKE '46%' ORDER BY bday DESC, dam_name, sire_name;
Date: 2026-06-02 11:38:25 Duration: 768ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
20 20 15s193ms 746ms 782ms 759ms 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 Jun 02 07 1 779ms 779ms 08 5 3s846ms 769ms 10 4 3s18ms 754ms 11 2 1s522ms 761ms 14 3 2s246ms 748ms 16 2 1s509ms 754ms 18 3 2s269ms 756ms [ User: labanimal - Total duration: 15s193ms - Times executed: 20 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 15s193ms - Times executed: 20 ]
-
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, 10100040) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100040) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100040) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-06-02 07:46:46 Duration: 782ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 490) AS is_owner, user_is_tgm (animals_search_mview.editor, 490) AS is_editor, user_is_tgm (animals_search_mview.tourist, 490) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-06-02 06:48:04 Duration: 779ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 10100040) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100040) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100040) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-06-02 07:28:30 Duration: 779ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 26s925ms 26s925ms 26s925ms 1 26s925ms 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 (is_owner or is_editor or is_tourist);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 02 14 1 26s925ms 26s925ms [ User: labanimal - Total duration: 26s925ms - Times executed: 1 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 26s925ms - Times executed: 1 ]
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 492) AS is_owner, user_is_tgm (animals_search_mview.editor, 492) AS is_editor, user_is_tgm (animals_search_mview.tourist, 492) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE (is_owner OR is_editor OR is_tourist);
Date: 2026-06-02 13:44:07 Duration: 26s925ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
2 502ms 8s526ms 3s419ms 1,440 1h22m3s 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 #2
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
3 502ms 8s526ms 3s419ms 1,440 1h22m3s 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 #3
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
4 502ms 8s526ms 3s419ms 1,440 1h22m3s 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 #4
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
5 502ms 8s526ms 3s419ms 1,440 1h22m3s alter table observability.uptime_checks add column if not exists label text;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS label text;
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
6 502ms 8s526ms 3s419ms 1,440 1h22m3s 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 #6
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
7 502ms 8s526ms 3s419ms 1,440 1h22m3s create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
8 502ms 8s526ms 3s419ms 1,440 1h22m3s 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 #8
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
9 502ms 8s526ms 3s419ms 1,440 1h22m3s create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
10 502ms 8s526ms 3s419ms 1,440 1h22m3s alter table observability.uptime_checks add column if not exists payload jsonb;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
ALTER TABLE observability.uptime_checks ADD COLUMN IF NOT EXISTS payload jsonb;
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
11 502ms 8s526ms 3s419ms 1,440 1h22m3s create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
12 502ms 8s526ms 3s419ms 1,440 1h22m3s create schema if not exists observability;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
13 502ms 8s526ms 3s419ms 1,440 1h22m3s 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 #13
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
14 502ms 8s526ms 3s419ms 1,440 1h22m3s create index if not exists idx_uptime_checks_key on observability.uptime_checks (check_key, checked_at desc);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_key ON observability.uptime_checks (check_key, checked_at DESC);
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
15 502ms 8s526ms 3s419ms 1,440 1h22m3s 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 #15
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
16 502ms 8s526ms 3s419ms 1,440 1h22m3s create index if not exists idx_uptime_checks_endpoint on observability.uptime_checks (endpoint, checked_at desc);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_uptime_checks_endpoint ON observability.uptime_checks (endpoint, checked_at DESC);
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
17 502ms 8s526ms 3s419ms 1,440 1h22m3s 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 #17
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
18 502ms 8s526ms 3s419ms 1,440 1h22m3s create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 02 01 60 0ms 0ms 02 60 26s780ms 446ms 03 60 55s407ms 923ms 04 60 55s407ms 923ms 05 60 55s407ms 923ms 06 60 1m9s 1s155ms 07 60 2m30s 2s508ms 08 60 57s129ms 952ms 09 60 2m36s 2s607ms 10 60 2m23s 2s396ms 11 60 2m49s 2s816ms 12 60 2m14s 2s240ms 13 60 2m56s 2s939ms 14 60 2m22s 2s381ms 15 60 2m23s 2s395ms 16 60 2m41s 2s697ms 17 60 2m57s 2s955ms 18 60 2m35s 2s594ms 19 60 6m2s 6s40ms 20 60 8m31s 8s526ms 21 60 8m31s 8s526ms 22 60 8m31s 8s526ms 23 60 8m31s 8s526ms 00 60 8m3s 8s50ms [ User: monitoring_admin - Total duration: 1h22m3s - Times executed: 1349 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-06-02 23:55:01 Duration: 8s526ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-06-02 10:32:01 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-06-02 13:37:01 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
19 2s757ms 3s71ms 2s926ms 91 4m26s 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 Jun 02 06 1 2s908ms 2s908ms 08 2 5s583ms 2s791ms 09 6 17s351ms 2s891ms 10 6 17s431ms 2s905ms 11 10 28s950ms 2s895ms 12 8 23s132ms 2s891ms 13 10 29s335ms 2s933ms 14 12 35s425ms 2s952ms 15 9 26s385ms 2s931ms 16 7 20s469ms 2s924ms 17 9 26s586ms 2s954ms 18 10 29s733ms 2s973ms 19 1 3s3ms 3s3ms [ User: monitoring_admin - Total duration: 4m26s - Times executed: 91 ]
-
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-30 22:27:00+02' AND collected_at <= '2026-06-01 22:27:00+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-01 22:27:00+02' AND '2026-06-02 10:27:00+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-01 22:27:00+02' AND '2026-06-02 10:27:00+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-06-02 10:27:03 Duration: 3s71ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_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-31 01:36:53+02' AND collected_at <= '2026-06-02 01:36:53+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 01:36:53+02' AND '2026-06-02 13:36:53+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 01:36:53+02' AND '2026-06-02 13:36:53+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-06-02 13:36:56 Duration: 3s56ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_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-31 05:42:34+02' AND collected_at <= '2026-06-02 05:42:34+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), fallback_start AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 05:42:34+02' AND '2026-06-02 17:42:34+02' ORDER BY tenant_key, fingerprint, collected_at ASC ), end_snap AS ( SELECT DISTINCT ON (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at FROM observability.db_top_queries WHERE tenant_key IN ('prod', 'live') AND collected_at BETWEEN '2026-06-02 05:42:34+02' AND '2026-06-02 17:42:34+02' ORDER BY tenant_key, fingerprint, collected_at DESC ), deltas AS ( SELECT e.tenant_key, e.fingerprint, e.query, e.collected_at AS last_seen, GREATEST (COALESCE(e.total_time_ms, 0) - COALESCE(s.total_time_ms, fs.total_time_ms, 0), 0) AS total_time_ms, GREATEST (COALESCE(e.calls, 0) - COALESCE(s.calls, fs.calls, 0), 0) AS calls, GREATEST (COALESCE(e.rows_returned, 0) - COALESCE(s.rows_returned, fs.rows_returned, 0), 0) AS rows_returned FROM end_snap e LEFT JOIN start_snap s ON s.tenant_key = e.tenant_key AND s.fingerprint = e.fingerprint LEFT JOIN fallback_start fs ON fs.tenant_key = e.tenant_key AND fs.fingerprint = e.fingerprint AND s.tenant_key IS NULL ) SELECT fingerprint, MAX(query) AS query, MAX(last_seen) AS last_seen, SUM(total_time_ms) AS total_time_ms, SUM(calls) AS calls, SUM(rows_returned) AS rows_returned, CASE WHEN SUM(calls) > 0 THEN SUM(total_time_ms) / SUM(calls) ELSE 0 END AS mean_time_ms, array_agg(DISTINCT tenant_key ORDER BY tenant_key) AS tenant_keys FROM deltas WHERE total_time_ms > 0 OR calls > 0 GROUP BY fingerprint ORDER BY total_time_ms DESC, calls DESC LIMIT '20' OFFSET '0';
Date: 2026-06-02 17:42:37 Duration: 3s4ms Database: zemm_monitoring User: monitoring_admin Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
20 746ms 782ms 759ms 20 15s193ms 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 Jun 02 07 1 779ms 779ms 08 5 3s846ms 769ms 10 4 3s18ms 754ms 11 2 1s522ms 761ms 14 3 2s246ms 748ms 16 2 1s509ms 754ms 18 3 2s269ms 756ms [ User: labanimal - Total duration: 15s193ms - Times executed: 20 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 15s193ms - Times executed: 20 ]
-
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, 10100040) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100040) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100040) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-06-02 07:46:46 Duration: 782ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 490) AS is_owner, user_is_tgm (animals_search_mview.editor, 490) AS is_editor, user_is_tgm (animals_search_mview.tourist, 490) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-06-02 06:48:04 Duration: 779ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_000000.csv
-
SELECT COUNT(DISTINCT animal_id) AS "count" FROM ( SELECT animals_search_mview.*, b.unbreeding_date, a.id as animal, user_is_tgm (animals_search_mview.owner, 10100040) AS is_owner, user_is_tgm (animals_search_mview.editor, 10100040) AS is_editor, user_is_tgm (animals_search_mview.tourist, 10100040) AS is_tourist, CASE WHEN NOT EXISTS ( SELECT 1 FROM scoresheet_diary sd WHERE sd.animals_id = animals_search_mview.id) THEN 'f' ELSE 't' END AS isscored FROM animals_search_mview LEFT JOIN strains ON strains.name = animals_search_mview.strain LEFT JOIN license_history lh ON lh.anid = animals_search_mview.id LEFT JOIN animals a ON a."animalID" = animals_search_mview.animal_id LEFT JOIN breedings b ON b.id = animals_search_mview.last_mating) data WHERE fate = 5 AND alive = 't' AND deleted = 'f' AND (is_owner OR is_editor OR is_tourist);
Date: 2026-06-02 07:28:30 Duration: 779ms Database: zemm_produktiv_8 User: labanimal Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-06-02_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
- 144,738 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
- 0 EVENTLOG entries
Events per 5 minutes
NO DATASET
Most Frequent Errors/Events
Key values
- 0 Max number of times the same event was reported
- 0 Total events found
Rank Times reported Error NO DATASET