ZEMM PG Report-
Global information
- Generated on Thu Apr 30 06:05:45 2026
- Log file: /var/log/postgresql/postgresql-2026-03-25_000000.csv, ..., /var/log/postgresql/postgresql-2026-04-30_000000.csv
- Parsed 214,609 log entries in 5m44s
- Log start from 2026-04-06 00:00:01 to 2026-04-06 23:59:59
-
Overview
Global Stats
- 26 Number of unique normalized queries
- 19,076 Number of queries
- 1d7h51m30s Total query duration
- 2026-04-06 00:00:01 First query
- 2026-04-06 23:59:01 Last query
- 14 queries/s at 2026-04-06 00:24:01 Query peak
- 1d7h51m30s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 1d7h51m30s Execute total duration
- 117 Number of events
- 13 Number of unique normalized events
- 61 Max number of times the same event was reported
- 0 Number of cancellation
- 12 Total number of automatic vacuums
- 18 Total number of automatic analyzes
- 320 Number temporary file
- 511.88 MiB Max size of temporary file
- 111.88 MiB Average size of temporary file
- 19,376 Total number of sessions
- 62 sessions at 2026-04-06 13:02:50 Session peak
- 1h24m22s Total duration of sessions
- 261ms Average duration of sessions
- 0 Average queries per session
- 5s919ms Average queries duration per session
- 0ms Average idle time per session
- 19,380 Total number of connections
- 41 connections/s at 2026-04-06 00:29:03 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 14 queries/s Query Peak
- 2026-04-06 00:24:01 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-04-06 01:48:37 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 14 queries/s Query Peak
- 2026-04-06 00:24:01 Date
Queries duration
Key values
- 1d7h51m30s 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) Apr 06 00 810 0ms 39s967ms 15s311ms 8m31s 8m36s 10m9s 01 821 695ms 40s291ms 5s446ms 4m10s 4m10s 4m13s 02 792 885ms 2s896ms 2s303ms 39s234ms 42s242ms 43s79ms 03 824 663ms 43s372ms 6s211ms 1m40s 9m2s 9m8s 04 786 5s61ms 5s93ms 5s79ms 1m11s 1m11s 1m11s 05 786 5s61ms 5s93ms 5s80ms 1m10s 1m11s 1m11s 06 786 5s56ms 5s250ms 5s98ms 1m10s 1m11s 1m11s 07 783 2s930ms 5s267ms 3s514ms 1m8s 1m11s 1m13s 08 782 2s930ms 3s61ms 2s935ms 38s703ms 38s703ms 44s128ms 09 786 2s968ms 3s40ms 2s988ms 41s577ms 41s722ms 42s499ms 10 795 2s832ms 5s366ms 3s100ms 42s221ms 45s155ms 1m41s 11 793 1s910ms 5s708ms 5s115ms 1m14s 1m15s 1m16s 12 801 547ms 6s795ms 5s72ms 1m14s 1m15s 1m38s 13 793 2s882ms 3s62ms 2s966ms 41s818ms 41s855ms 41s996ms 14 789 2s882ms 2s952ms 2s917ms 40s628ms 40s968ms 41s310ms 15 796 852ms 3s367ms 2s576ms 41s212ms 42s876ms 44s637ms 16 792 2s861ms 2s988ms 2s912ms 40s828ms 41s39ms 41s766ms 17 793 855ms 2s987ms 2s786ms 40s972ms 41s244ms 41s370ms 18 795 831ms 3s96ms 2s754ms 40s818ms 41s473ms 43s152ms 19 801 834ms 3s55ms 2s476ms 40s947ms 41s228ms 43s497ms 20 793 2s843ms 2s945ms 2s911ms 41s9ms 41s123ms 42s696ms 21 795 837ms 2s949ms 2s830ms 40s699ms 41s156ms 41s253ms 22 793 2s882ms 30s144ms 24s378ms 6m48s 6m50s 7m1s 23 791 574ms 29s572ms 27s321ms 6m48s 6m51s 6m53s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Apr 06 00 0 0 0ms 0ms 0ms 0ms 01 1 0 695ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 8 2s979ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 8 2s802ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 5 1s340ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Apr 06 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 1 0 0 1s104ms 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 Apr 06 00 0 30 30.00 0.00% 01 0 39 39.00 0.00% 02 0 10 10.00 0.00% 03 0 36 36.00 0.00% 04 0 6 6.00 0.00% 05 0 6 6.00 0.00% 06 0 6 6.00 0.00% 07 0 3 3.00 0.00% 08 0 2 2.00 0.00% 09 0 6 6.00 0.00% 10 0 15 15.00 0.00% 11 0 12 12.00 0.00% 12 0 13 13.00 0.00% 13 0 13 13.00 0.00% 14 0 9 9.00 0.00% 15 0 12 12.00 0.00% 16 0 12 12.00 0.00% 17 0 12 12.00 0.00% 18 0 12 12.00 0.00% 19 0 17 17.00 0.00% 20 0 12 12.00 0.00% 21 0 12 12.00 0.00% 22 0 13 13.00 0.00% 23 0 6 6.00 0.00% Day Hour Count Average / Second Apr 06 00 1,374 0.38/s 01 1,476 0.41/s 02 670 0.19/s 03 1,341 0.37/s 04 418 0.12/s 05 421 0.12/s 06 421 0.12/s 07 362 0.10/s 08 285 0.08/s 09 680 0.19/s 10 757 0.21/s 11 962 0.27/s 12 837 0.23/s 13 638 0.18/s 14 549 0.15/s 15 1,364 0.38/s 16 623 0.17/s 17 797 0.22/s 18 1,162 0.32/s 19 1,452 0.40/s 20 626 0.17/s 21 975 0.27/s 22 710 0.20/s 23 480 0.13/s Day Hour Count Average Duration Average idle time Apr 06 00 1,374 375ms 0ms 01 1,476 241ms 0ms 02 670 210ms 0ms 03 1,341 342ms 0ms 04 418 281ms 0ms 05 421 279ms 0ms 06 421 279ms 0ms 07 362 260ms 0ms 08 285 282ms 0ms 09 680 209ms 0ms 10 757 217ms 0ms 11 962 227ms 0ms 12 837 281ms 0ms 13 638 226ms 0ms 14 549 226ms 0ms 15 1,364 186ms 0ms 16 623 221ms 0ms 17 797 208ms 0ms 18 1,162 192ms 0ms 19 1,451 199ms 0ms 20 626 221ms 0ms 21 975 198ms 0ms 22 708 491ms 0ms 23 479 585ms 0ms -
Connections
Established Connections
Key values
- 41 connections Connection Peak
- 2026-04-06 00:29:03 Date
Connections per database
Key values
- zemm_monitoring Main Database
- 19,380 connections Total
Database User Count labanimal 1 labanimal 1 postgres 2 labanimal 2 template1 55 postgres 55 zemm_dev 1 labanimal 1 zemm_monitoring 11,159 deploy 1 labanimal 11,154 mcp_ro 4 zemm_produktiv_7 4,835 labanimal 4,695 mcp_ro 34 postgres 106 zemm_produktiv_8 3,324 labanimal 3,284 mcp_ro 1 postgres 39 zemm_test_2 1 labanimal 1 zemm_test_3 2 labanimal 2 Connections per user
Key values
- labanimal Main User
- 19,380 connections Total
-
Sessions
Simultaneous sessions
Key values
- 62 sessions Session Peak
- 2026-04-06 13:02:50 Date
Histogram of session times
Key values
- 17,282 0-500ms duration
Sessions per database
Key values
- zemm_monitoring Main Database
- 19,376 sessions Total
Sessions per user
Key values
- labanimal Main User
- 19,376 sessions Total
Sessions per host
Key values
- ::1 Main Host
- 19,376 sessions Total
Sessions per application
Key values
- Main Application
- 19,376 sessions Total
Application Count Total Duration Average Duration 17,821 1h20m 269ms _backend_cage_autocomplete_api.php_q_2025_limit_12_zemm_produkt 17 404ms 23ms _backend_cage_autocomplete_api.php_q_55-065_limit_12_zemm_produ 16 446ms 27ms _backend_cage_autocomplete_api.php_q_Kadavertruhe_limit_12_zemm 1 37ms 37ms _backend_wean_api.php_litter_id_10130227_zemm_produktiv_7_local 80 11s490ms 143ms _backend_wean_api.php_litter_id_10130227_zemm_produktiv_8_local 5 757ms 151ms _backend_wean_api.php_litter_id_10130236_zemm_produktiv_7_local 80 11s975ms 149ms _backend_wean_api.php_litter_id_10130236_zemm_produktiv_8_local 5 731ms 146ms _backend_wean_api.php_litter_id_10130257_zemm_produktiv_7_local 96 14s79ms 146ms _backend_wean_api.php_litter_id_10130257_zemm_produktiv_8_local 6 875ms 145ms _backend_wean_api.php_litter_id_10131721_zemm_produktiv_7_local 2 287ms 143ms _desktop__zemm_produktiv_7_localhost_5432 16 1s64ms 66ms _desktop__zemm_produktiv_8_localhost_5432 1 58ms 58ms _desktop_index.php_command_animals_breedings_subcommand_select_ 17 880ms 51ms _desktop_index.php_command_animals_create_subcommand_init_zemm_ 17 1s68ms 62ms _desktop_index.php_command_animals_edit_subcommand_link_init_va 17 1s919ms 112ms _desktop_index.php_command_animals_edit_subcommand_m_init_scree 17 2s237ms 131ms _desktop_index.php_command_animals_litters_edit_subcommand_init 17 1s890ms 111ms _desktop_index.php_command_animals_litters_edit_subcommand_m_in 17 5s499ms 323ms _desktop_index.php_command_animals_litters_subcommand_select_ze 17 798ms 46ms _desktop_index.php_command_animals_subcommand_select_zemm_produ 17 1s171ms 68ms _desktop_index.php_command_login_subcommand_init_zemm_produktiv 99 2s748ms 27ms _desktop_index.php_command_reports_subcommand_fates_zemm_produk 17 2s98ms 123ms _desktop_index.php_command_reports_subcommand_init_zemm_produkt 34 10s284ms 302ms _desktop_index.php_command_tasks_subcommand_edit_id_10126210_ze 2 179ms 89ms _desktop_index.php_command_tasks_subcommand_edit_id_10126211_ze 1 88ms 88ms _desktop_index.php_command_tasks_subcommand_edit_id_10134267_ze 17 1s474ms 86ms _desktop_index.php_command_tasks_subcommand_edit_id_10141965_ze 1 88ms 88ms _desktop_index.php_command_tasks_subcommand_init_search_zemm_pr 17 824ms 48ms _desktop_index.php_command_tasks_subcommand_open_zemm_produktiv 6 562ms 93ms _desktop_index.php_command_tasks_subcommand_search_zemm_produkt 21 967ms 46ms _desktop_index.php_name_Tiertransfer_20in_20EG_20R_C3_A4ume_204 1 57ms 57ms _desktop_index.php_search_status__25_issuer_user_name_Sch_C3_A4 4 456ms 114ms _desktop_index.php_zemm_produktiv_7_localhost_5432 349 1m31s 260ms _desktop_index.php_zemm_produktiv_8_localhost_5432 66 9s542ms 144ms backend:zemm_produktiv_7@localhost 2 222ms 111ms expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 1 1s132ms 1s132ms pg_dump 3 1m7s 22s587ms psql 405 9s631ms 23ms taskscron:zemm_produktiv_7@zemm.fbiscience.eu 24 2s 83ms taskscron:zemm_produktiv_8@h2940066.stratoserver.net:5432 24 3s114ms 129ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 19,771 buffers Checkpoint Peak
- 2026-04-06 21:41:59 Date
- 269.961 seconds Highest write time
- 0.029 seconds Sync time
Checkpoints Wal files
Key values
- 7 files Wal files usage Peak
- 2026-04-06 01:36:38 Date
Checkpoints distance
Key values
- 207.07 Mo Distance Peak
- 2026-04-06 01:36:38 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Apr 06 00 3,209 321.742s 0.077s 321.875s 01 21,933 591.208s 0.079s 591.348s 02 3,695 370.164s 0.096s 370.313s 03 3,590 359.721s 0.077s 359.851s 04 2,821 282.864s 0.073s 282.987s 05 3,128 313.524s 0.073s 313.647s 06 3,346 335.464s 0.072s 335.588s 07 5,578 495.415s 0.076s 495.552s 08 4,320 432.192s 0.073s 432.315s 09 4,067 407.31s 0.108s 407.477s 10 3,972 397.763s 0.075s 397.896s 11 3,795 380.419s 0.094s 380.563s 12 5,124 513.025s 0.087s 513.164s 13 3,967 397.473s 0.077s 397.602s 14 3,980 398.826s 0.083s 398.965s 15 4,712 472.951s 0.129s 473.281s 16 3,699 370.585s 0.064s 370.707s 17 3,973 398.187s 0.075s 398.316s 18 4,574 458.332s 0.09s 458.48s 19 4,365 437.511s 0.099s 437.665s 20 2,842 284.874s 0.064s 284.999s 21 22,531 545.851s 0.095s 546.001s 22 2,933 294.079s 0.07s 294.202s 23 3,488 349.368s 0.081s 349.498s Day Hour Added Removed Recycled Synced files Longest sync Average sync Apr 06 00 0 0 1 393 0.001s 0.012s 01 0 0 7 404 0.002s 0.012s 02 0 0 1 456 0.003s 0.012s 03 0 0 1 380 0.002s 0.012s 04 0 0 1 352 0.002s 0.012s 05 0 0 1 352 0.002s 0.012s 06 0 0 1 341 0.002s 0.012s 07 0 0 2 365 0.002s 0.012s 08 0 0 1 353 0.002s 0.012s 09 0 0 1 592 0.001s 0.012s 10 0 0 1 383 0.002s 0.012s 11 0 0 1 484 0.002s 0.012s 12 0 0 1 447 0.002s 0.012s 13 0 0 1 362 0.002s 0.012s 14 0 0 2 404 0.003s 0.012s 15 0 0 1 491 0.009s 0.012s 16 0 0 1 310 0.002s 0.012s 17 0 0 1 356 0.004s 0.012s 18 0 0 2 467 0.003s 0.012s 19 0 0 1 469 0.003s 0.012s 20 0 0 1 333 0.001s 0.012s 21 0 0 3 390 0.016s 0.012s 22 0 0 1 315 0.002s 0.012s 23 0 0 1 330 0.002s 0.012s Day Hour Count Avg time (sec) Apr 06 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 Apr 06 00 1,303.67 kB 2,004.75 kB 01 10,096.58 kB 42,345.75 kB 02 1,434.08 kB 34,699.83 kB 03 1,403.50 kB 10,817.75 kB 04 1,214.42 kB 3,935.75 kB 05 1,280.25 kB 2,006.83 kB 06 1,333.92 kB 1,689.25 kB 07 1,976.00 kB 6,393.50 kB 08 1,620.00 kB 4,231.67 kB 09 1,537.42 kB 4,433.33 kB 10 1,482.58 kB 2,331.42 kB 11 1,547.08 kB 2,498.83 kB 12 1,829.83 kB 2,857.75 kB 13 1,504.75 kB 4,372.67 kB 14 1,501.50 kB 2,357.92 kB 15 2,098.75 kB 3,305.92 kB 16 1,450.75 kB 2,275.25 kB 17 1,622.75 kB 2,002.17 kB 18 1,959.67 kB 3,073.50 kB 19 2,007.83 kB 3,557.00 kB 20 1,206.67 kB 2,690.08 kB 21 3,604.75 kB 10,782.67 kB 22 1,259.00 kB 10,837.08 kB 23 1,400.42 kB 4,020.42 kB -
Temporary Files
Size of temporary files
Key values
- 511.88 MiB Temp Files size Peak
- 2026-04-06 23:50:29 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2026-04-06 00:21:30 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Apr 06 00 34 6.29 GiB 189.39 MiB 01 38 3.94 GiB 106.04 MiB 02 9 410.11 MiB 45.57 MiB 03 40 4.71 GiB 120.52 MiB 04 6 824.77 MiB 137.46 MiB 05 6 825.98 MiB 137.66 MiB 06 6 827.18 MiB 137.86 MiB 07 2 276.00 MiB 138.00 MiB 08 2 91.05 MiB 45.52 MiB 09 6 273.39 MiB 45.57 MiB 10 15 1.17 GiB 79.60 MiB 11 12 1.78 GiB 152.14 MiB 12 12 1.58 GiB 134.53 MiB 13 13 592.20 MiB 45.55 MiB 14 9 410.00 MiB 45.56 MiB 15 12 547.09 MiB 45.59 MiB 16 12 546.84 MiB 45.57 MiB 17 12 546.59 MiB 45.55 MiB 18 11 501.25 MiB 45.57 MiB 19 16 728.89 MiB 45.56 MiB 20 12 546.81 MiB 45.57 MiB 21 12 546.65 MiB 45.55 MiB 22 17 4.21 GiB 253.79 MiB 23 6 3.00 GiB 511.62 MiB Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 966.48 MiB 45.26 MiB 90.39 MiB 60.41 MiB 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 <= ? 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 ?;-
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', 'test', 'dev') AND collected_at <= '2026-04-05 15:12:52+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 15:12:52+02' AND '2026-04-06 03:12:52+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 15:12:52+02' AND '2026-04-06 03:12:52+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-04-06 03:13:35 Duration: 43s372ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-06_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', 'test', 'dev') AND collected_at <= '2026-04-05 15:12:57+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 15:12:57+02' AND '2026-04-06 03:12:57+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 15:12:57+02' AND '2026-04-06 03:12:57+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-04-06 03:13:39 Duration: 41s736ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-06_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', 'test', 'dev') AND collected_at <= '2026-04-05 13:15:52+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 13:15:52+02' AND '2026-04-06 01:15:52+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 13:15:52+02' AND '2026-04-06 01:15:52+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-04-06 01:16:32 Duration: 40s291ms Database: zemm_monitoring User: labanimal Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
Queries generating the largest temporary files
Rank Size Query 1 90.39 MiB 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 ($1, $2) AND collected_at <= $3 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 ($4, $5) AND collected_at BETWEEN $6 AND $7 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 ($8, $9) AND collected_at BETWEEN $10 AND $11 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 $12 OFFSET $13;[ Date: 2026-04-06 03:13:12 - Queryid: 453632 ]
2 89.36 MiB 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 ($1, $2) AND collected_at <= $3 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 ($4, $5) AND collected_at BETWEEN $6 AND $7 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 ($8, $9) AND collected_at BETWEEN $10 AND $11 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 $12 OFFSET $13;[ Date: 2026-04-06 03:13:12 - Queryid: 453632 ]
3 86.59 MiB 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 ($1, $2) AND collected_at <= $3 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 ($4, $5) AND collected_at BETWEEN $6 AND $7 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 ($8, $9) AND collected_at BETWEEN $10 AND $11 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 $12 OFFSET $13;[ Date: 2026-04-06 03:13:12 - Queryid: 453632 ]
4 77.55 MiB 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 ($1, $2) AND collected_at <= $3 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 ($4, $5) AND collected_at BETWEEN $6 AND $7 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 ($8, $9) AND collected_at BETWEEN $10 AND $11 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 $12 OFFSET $13;[ Date: 2026-04-06 00:21:30 - Queryid: 373442 ]
5 70.62 MiB 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 ($1, $2) AND collected_at <= $3 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 ($4, $5) AND collected_at BETWEEN $6 AND $7 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 ($8, $9) AND collected_at BETWEEN $10 AND $11 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 $12 OFFSET $13;[ Date: 2026-04-06 00:21:30 - Queryid: 373442 ]
6 66.03 MiB 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 ($1, $2) AND collected_at <= $3 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 ($4, $5) AND collected_at BETWEEN $6 AND $7 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 ($8, $9) AND collected_at BETWEEN $10 AND $11 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 $12 OFFSET $13;[ Date: 2026-04-06 03:13:08 - Queryid: 453497 ]
7 61.23 MiB 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 ($1, $2) AND collected_at <= $3 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 ($4, $5) AND collected_at BETWEEN $6 AND $7 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 ($8, $9) AND collected_at BETWEEN $10 AND $11 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 $12 OFFSET $13;[ Date: 2026-04-06 22:10:27 - Queryid: 956136 ]
8 60.38 MiB 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 ($1, $2) AND collected_at <= $3 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 ($4, $5) AND collected_at BETWEEN $6 AND $7 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 ($8, $9) AND collected_at BETWEEN $10 AND $11 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 $12 OFFSET $13;[ Date: 2026-04-06 22:10:27 - Queryid: 956136 ]
9 46.89 MiB 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 ($1, $2) AND collected_at <= $3 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 ($4, $5) AND collected_at BETWEEN $6 AND $7 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 ($8, $9) AND collected_at BETWEEN $10 AND $11 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 $12 OFFSET $13;[ Date: 2026-04-06 22:10:27 - Queryid: 956136 ]
10 45.50 MiB 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 ($1) AND collected_at <= $2 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 ($3) AND collected_at BETWEEN $4 AND $5 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 ($6) AND collected_at BETWEEN $7 AND $8 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 $9 OFFSET $10;[ Date: 2026-04-06 00:16:06 - Queryid: 372089 ]
11 45.41 MiB 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 ($1, $2) AND collected_at <= $3 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 ($4, $5) AND collected_at BETWEEN $6 AND $7 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 ($8, $9) AND collected_at BETWEEN $10 AND $11 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 $12 OFFSET $13;[ Date: 2026-04-06 03:13:08 - Queryid: 453497 ]
12 45.38 MiB 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 ($1, $2) AND collected_at <= $3 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 ($4, $5) AND collected_at BETWEEN $6 AND $7 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 ($8, $9) AND collected_at BETWEEN $10 AND $11 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 $12 OFFSET $13;[ Date: 2026-04-06 22:10:27 - Queryid: 956136 ]
13 45.34 MiB 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 ($1, $2) AND collected_at <= $3 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 ($4, $5) AND collected_at BETWEEN $6 AND $7 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 ($8, $9) AND collected_at BETWEEN $10 AND $11 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 $12 OFFSET $13;[ Date: 2026-04-06 03:13:08 - Queryid: 453497 ]
14 45.29 MiB 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 ($1, $2) AND collected_at <= $3 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 ($4, $5) AND collected_at BETWEEN $6 AND $7 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 ($8, $9) AND collected_at BETWEEN $10 AND $11 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 $12 OFFSET $13;[ Date: 2026-04-06 00:21:30 - Queryid: 373442 ]
15 45.26 MiB 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 ($1, $2) AND collected_at <= $3 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 ($4, $5) AND collected_at BETWEEN $6 AND $7 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 ($8, $9) AND collected_at BETWEEN $10 AND $11 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 $12 OFFSET $13;[ Date: 2026-04-06 00:21:30 - Queryid: 373442 ]
16 45.26 MiB 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 ($1, $2) AND collected_at <= $3 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 ($4, $5) AND collected_at BETWEEN $6 AND $7 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 ($8, $9) AND collected_at BETWEEN $10 AND $11 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 $12 OFFSET $13;[ Date: 2026-04-06 03:13:08 - Queryid: 453497 ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 4.55 sec Highest CPU-cost vacuum
Table observability.app_events
Database zemm_monitoring - 2026-04-06 21:35:10 Date
- 0 sec Highest CPU-cost analyze
Table
Database zemm_monitoring - Date
Average Autovacuum Duration
Key values
- 4.55 sec Highest CPU-cost vacuum
Table observability.app_events
Database zemm_monitoring - 2026-04-06 21:35:10 Date
Analyzes per table
Key values
- pg_catalog.pg_type (4) Main table analyzed (database zemm_produktiv_7)
- 18 analyzes Total
Table Number of analyzes zemm_produktiv_7.pg_catalog.pg_type 4 zemm_produktiv_8.pg_catalog.pg_type 2 zemm_produktiv_7.pg_catalog.pg_class 2 zemm_monitoring.observability.metrics_timeseries 2 zemm_produktiv_7.pg_catalog.pg_attribute 2 zemm_produktiv_8.public.tasks 1 zemm_produktiv_8.pg_catalog.pg_depend 1 zemm_monitoring.pg_catalog.pg_shdepend 1 zemm_produktiv_8.pg_catalog.pg_attribute 1 zemm_produktiv_7.pg_catalog.pg_depend 1 zemm_produktiv_8.pg_catalog.pg_class 1 Total 18 Vacuums per table
Key values
- pg_toast.pg_toast_67431 (6) Main table vacuumed on database zemm_monitoring
- 12 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples zemm_monitoring.pg_toast.pg_toast_67431 6 0 0 0 0 0 0 4,673 1,574 3,579,156 1,544 9,264 zemm_produktiv_8.pg_catalog.pg_attribute 1 1 0 0 0 0 0 118 43 29,625 0 0 zemm_produktiv_7.pg_catalog.pg_depend 1 1 0 0 0 0 0 135 55 89,571 6 465 zemm_monitoring.observability.app_events 1 0 0 0 0 0 0 19,371 19,190 25,121,168 0 0 zemm_produktiv_7.pg_catalog.pg_type 1 1 0 0 0 0 0 47 11 12,968 1 37 zemm_produktiv_8.public.tasks 1 1 0 0 0 0 0 48,086 34 3,531,910 0 0 fbi_ci_db.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 96 33 60,170 0 0 Total 12 5 0 0 0 0 0 72,526 20,940 32,424,568 1,551 9,766 Vacuum throughput per table
Key values
- observability.app_events (4.55) Max CPU elapsed for vacuum on database zemm_monitoring
- pg_catalog.pg_attribute (2.115 ms) Max I/O read time for vacuum on database zemm_monitoring
- observability.app_events (0.045 ms) Max I/O write time for vacuum on database zemm_monitoring
I/O timing (ms) CPU (s) Table read write elapsed zemm_monitoring.pg_toast.pg_toast_67431 0.94 0 0.36 zemm_produktiv_8.pg_catalog.pg_attribute 2.115 0 0.01 zemm_produktiv_7.pg_catalog.pg_depend 0.977 0 0.01 zemm_monitoring.observability.app_events 1.869 0.045 4.55 zemm_produktiv_7.pg_catalog.pg_type 0.74 0 0 zemm_produktiv_8.public.tasks 0.193 0 0.61 fbi_ci_db.pg_catalog.pg_shdepend 1.622 0 0.01 Total 8.456 0.045 5.55 Tuples removed per table
Key values
- public.tasks (53602) Main table with removed tuples on database zemm_produktiv_8
- 55583 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain zemm_produktiv_8.public.tasks 1 1 53,602 56,669 0 0 16,677 zemm_produktiv_8.pg_catalog.pg_attribute 1 1 930 5,864 0 0 184 zemm_produktiv_7.pg_catalog.pg_depend 1 1 538 4,171 0 0 51 fbi_ci_db.pg_catalog.pg_shdepend 1 1 375 3,849 0 0 38 zemm_produktiv_7.pg_catalog.pg_type 1 1 138 831 0 0 27 zemm_monitoring.observability.app_events 1 0 0 799,530 0 0 72,065 zemm_monitoring.pg_toast.pg_toast_67431 6 0 0 1,864,290 0 0 311,833 Total 12 5 55,583 2,735,204 0 0 400,875 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Pages removed per tables
NO DATASET
Table Number of vacuums Index scans Tuples removed Pages removed zemm_produktiv_8.pg_catalog.pg_attribute 1 1 930 0 zemm_produktiv_7.pg_catalog.pg_depend 1 1 538 0 zemm_monitoring.observability.app_events 1 0 0 0 zemm_produktiv_7.pg_catalog.pg_type 1 1 138 0 zemm_produktiv_8.public.tasks 1 1 53602 0 zemm_monitoring.pg_toast.pg_toast_67431 6 0 0 0 fbi_ci_db.pg_catalog.pg_shdepend 1 1 375 0 Total 12 5 55,583 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Apr 06 00 0 0 01 1 1 02 1 1 03 0 0 04 0 0 05 0 1 06 1 0 07 0 0 08 0 0 09 1 2 10 1 0 11 0 3 12 0 2 13 0 0 14 2 1 15 1 2 16 0 0 17 0 0 18 1 2 19 1 1 20 0 1 21 1 1 22 0 0 23 1 0 - 4.55 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
- 1 Total read queries
- 19,075 Total write queries
Queries by database
Key values
- zemm_monitoring Main database
- 19,035 Requests
- 1d7h50m14s (zemm_monitoring)
- Main time consuming database
Queries by user
Key values
- labanimal Main user
- 264,130 Requests
User Request type Count Duration deploy Total 48 14m17s cte 4 1m18s ddl 27 4m22s others 2 1s624ms select 9 6m3s labanimal Total 264,130 6d18h39m42s copy from 8 18s286ms copy to 80 3m44s cte 1,059 1h14m5s ddl 261,903 6d17h1m9s others 164 1m26s select 889 18m28s tcl 2 1s129ms update 14 15s34ms postgres Total 71 1m33s copy to 71 1m33s Duration by user
Key values
- 6d18h39m42s (labanimal) Main time consuming user
User Request type Count Duration deploy Total 48 14m17s cte 4 1m18s ddl 27 4m22s others 2 1s624ms select 9 6m3s labanimal Total 264,130 6d18h39m42s copy from 8 18s286ms copy to 80 3m44s cte 1,059 1h14m5s ddl 261,903 6d17h1m9s others 164 1m26s select 889 18m28s tcl 2 1s129ms update 14 15s34ms postgres Total 71 1m33s copy to 71 1m33s Queries by host
Key values
- unknown Main host
- 264,115 Requests
- 6d18h36m30s (unknown)
- Main time consuming host
Host Request type Count Duration 81.169.238.237 Total 15 3m11s select 1 2m56s update 14 15s34ms [local] Total 119 15m50s copy to 71 1m33s cte 4 1m18s ddl 27 4m22s others 2 1s624ms select 9 6m3s unknown Total 264,115 6d18h36m30s copy from 8 18s286ms copy to 80 3m44s cte 1,059 1h14m5s ddl 261,903 6d17h1m9s others 164 1m26s select 888 15m31s tcl 2 1s129ms Queries by application
Key values
- unknown Main application
- 19,034 Requests
- 1d7h50m13s (unknown)
- Main time consuming application
Application Request type Count Duration _desktop_index.php_zemm_produktiv_7_localhost_5432 Total 16 14s76ms cte 16 14s76ms _desktop_index.php_zemm_produktiv_8_localhost_5432 Total 1 1s910ms cte 1 1s910ms expire_tasks:zemm_produktiv_8@h2940066.stratoserver.net:5432 Total 1 1s104ms update 1 1s104ms pg_dump Total 21 52s953ms copy to 21 52s953ms psql Total 3 6s483ms ddl 2 5s787ms select 1 695ms unknown Total 19,034 1d7h50m13s cte 314 31m47s ddl 18,720 1d7h18m26s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-04-06 09:42:01 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 307 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 43s372ms 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', 'test', 'dev') AND collected_at <= '2026-04-05 15:12:52+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 15:12:52+02' AND '2026-04-06 03:12:52+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 15:12:52+02' AND '2026-04-06 03:12:52+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-04-06 03:13:35 - Database: zemm_monitoring - User: labanimal - Bind query: yes ]
2 41s736ms 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', 'test', 'dev') AND collected_at <= '2026-04-05 15:12:57+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 15:12:57+02' AND '2026-04-06 03:12:57+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 15:12:57+02' AND '2026-04-06 03:12:57+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-04-06 03:13:39 - Database: zemm_monitoring - User: labanimal - Bind query: yes ]
3 41s736ms CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-04-06 03:14:02 - Database: zemm_monitoring - User: labanimal - Bind query: yes ]
4 41s736ms 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-04-06 03:14:02 - Database: zemm_monitoring - User: labanimal - Bind query: yes ]
5 41s736ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-04-06 03:14:02 - Database: zemm_monitoring - User: labanimal - Bind query: yes ]
6 41s736ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-04-06 03:14:02 - Database: zemm_monitoring - User: labanimal - Bind query: yes ]
7 41s736ms 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-04-06 03:14:02 - Database: zemm_monitoring - User: labanimal - Bind query: yes ]
8 41s736ms CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);[ Date: 2026-04-06 03:14:02 - Database: zemm_monitoring - User: labanimal - Bind query: yes ]
9 41s736ms CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);[ Date: 2026-04-06 03:14:02 - Database: zemm_monitoring - User: labanimal - Bind query: yes ]
10 41s736ms 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-04-06 03:14:02 - Database: zemm_monitoring - User: labanimal - Bind query: yes ]
11 41s736ms CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);[ Date: 2026-04-06 03:14:02 - Database: zemm_monitoring - User: labanimal - Bind query: yes ]
12 41s736ms 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-04-06 03:14:02 - Database: zemm_monitoring - User: labanimal - Bind query: yes ]
13 41s736ms 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-04-06 03:14:02 - Database: zemm_monitoring - User: labanimal - Bind query: yes ]
14 41s736ms 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-04-06 03:14:02 - Database: zemm_monitoring - User: labanimal - Bind query: yes ]
15 41s736ms 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-04-06 03:14:02 - Database: zemm_monitoring - User: labanimal - Bind query: yes ]
16 41s736ms CREATE SCHEMA IF NOT EXISTS observability;[ Date: 2026-04-06 03:15:01 - Database: zemm_monitoring - User: labanimal - Bind query: yes ]
17 41s736ms 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-04-06 03:15:01 - Database: zemm_monitoring - User: labanimal - Bind query: yes ]
18 41s736ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);[ Date: 2026-04-06 03:15:01 - Database: zemm_monitoring - User: labanimal - Bind query: yes ]
19 41s736ms CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);[ Date: 2026-04-06 03:15:01 - Database: zemm_monitoring - User: labanimal - Bind query: yes ]
20 41s736ms 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-04-06 03:15:01 - Database: zemm_monitoring - User: labanimal - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h24m29s 1,440 663ms 41s736ms 6s20ms create table if not exists observability.uptime_checks ( id bigserial primary key, endpoint text not null, status text not null, latency_ms double precision, checked_at timestamptz not null default now() );Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
2 2h24m29s 1,440 663ms 41s736ms 6s20ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
3 2h24m29s 1,440 663ms 41s736ms 6s20ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
4 2h24m29s 1,440 663ms 41s736ms 6s20ms create index if not exists idx_db_top_queries_tenant on observability.db_top_queries (tenant_key, collected_at desc);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
5 2h24m29s 1,440 663ms 41s736ms 6s20ms 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 #5
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
6 2h24m29s 1,440 663ms 41s736ms 6s20ms 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 #6
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
7 2h24m29s 1,440 663ms 41s736ms 6s20ms create schema if not exists observability;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
8 2h24m29s 1,440 663ms 41s736ms 6s20ms create table if not exists observability.nginx_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
9 2h24m29s 1,440 663ms 41s736ms 6s20ms create table if not exists observability.system_metrics ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
10 2h24m29s 1,440 663ms 41s736ms 6s20ms create table if not exists observability.metrics_timeseries ( id bigserial primary key, tenant_key text not null, metric_name text not null, bucket_start timestamptz not null, bucket_width_seconds integer not null default ?, sum_value double precision not null default ?, count_value bigint not null default ?, histogram jsonb, created_at timestamptz not null default now(), updated_at timestamptz not null default now(), unique (tenant_key, metric_name, bucket_start, bucket_width_seconds) );Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
11 2h24m29s 1,440 663ms 41s736ms 6s20ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
12 2h24m29s 1,440 663ms 41s736ms 6s20ms 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 #12
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
13 2h24m29s 1,440 663ms 41s736ms 6s20ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
14 31m47s 314 2s733ms 43s372ms 6s73ms 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 <= ? 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 #14
Day Hour Count Duration Avg duration Apr 06 01 30 6m8s 12s267ms 02 39 3m20s 5s130ms 03 10 28s170ms 2s817ms 04 36 4m20s 7s243ms 05 6 30s475ms 5s79ms 06 6 30s487ms 5s81ms 07 6 30s643ms 5s107ms 08 3 13s448ms 4s482ms 09 2 6s38ms 3s19ms 10 6 17s934ms 2s989ms 11 15 55s969ms 3s731ms 12 12 1m4s 5s367ms 13 13 1m2s 4s835ms 14 13 38s505ms 2s961ms 15 9 26s251ms 2s916ms 16 12 35s777ms 2s981ms 17 12 34s982ms 2s915ms 18 12 35s131ms 2s927ms 19 12 35s191ms 2s932ms 20 17 49s955ms 2s938ms 21 12 34s932ms 2s911ms 22 12 34s824ms 2s902ms 23 13 3m56s 18s163ms 00 6 2m55s 29s332ms [ User: labanimal - Total duration: 31m47s - Times executed: 314 ]
-
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', 'test', 'dev') AND collected_at <= '2026-04-05 15:12:52+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 15:12:52+02' AND '2026-04-06 03:12:52+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 15:12:52+02' AND '2026-04-06 03:12:52+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-04-06 03:13:35 Duration: 43s372ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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', 'test', 'dev') AND collected_at <= '2026-04-05 15:12:57+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 15:12:57+02' AND '2026-04-06 03:12:57+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 15:12:57+02' AND '2026-04-06 03:12:57+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-04-06 03:13:39 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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', 'test', 'dev') AND collected_at <= '2026-04-05 13:15:52+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 13:15:52+02' AND '2026-04-06 01:15:52+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 13:15:52+02' AND '2026-04-06 01:15:52+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-04-06 01:16:32 Duration: 40s291ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
15 15s987ms 17 831ms 1s910ms 940ms with damdam as ( select breedingid, string_agg(cast(dam as text), ?) as dam from breedingsdams inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as dam on dam.id = breedingsdams.dam and case when user_is_tgm (dam.owner, ?) then true when user_is_tgm (dam.editor, ?) then true when user_is_tgm (dam.tourist, ?) then true else false end group by breedingid ), siresire as ( select breedingid, string_agg(cast(sire as text), ?) as sire from breedingssires inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as sire on sire.id = breedingssires.sire and case when user_is_tgm (sire.owner, ?) then true when user_is_tgm (sire.editor, ?) then true when user_is_tgm (sire.tourist, ?) then true else false end group by breedingid ), cagess as ( select id, "cageName" from cages) ( select breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire from damdam, siresire, cagess, breedings where breedings.deleted != true and cagess.id = breedings.cage and damdam.breedingid = breedings.id and siresire.breedingid = breedings.id and breedings."unbreeding_date" is null group by breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire order by breeding_date, plug_date);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Apr 06 03 2 1s985ms 992ms 12 1 1s910ms 1s910ms 16 4 3s643ms 910ms 18 1 855ms 855ms 19 3 2s518ms 839ms 20 4 3s374ms 843ms 22 2 1s699ms 849ms [ User: labanimal - Total duration: 15s987ms - Times executed: 17 ]
[ Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 - Total duration: 14s76ms - Times executed: 16 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 1s910ms - Times executed: 1 ]
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-06 11:23:12 Duration: 1s910ms 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-04-06_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-06 02:42:30 Duration: 1s100ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-06 15:14:29 Duration: 1s60ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
16 15s311ms 3 1s397ms 7s119ms 5s103ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Apr 06 04 1 7s119ms 7s119ms 13 1 6s795ms 6s795ms 00 1 1s397ms 1s397ms [ User: labanimal - Total duration: 13s914ms - Times executed: 2 ]
[ User: postgres - Total duration: 1s397ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 15s311ms - Times executed: 3 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-04-06 03:12:55 Duration: 7s119ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-04-06 12:52:30 Duration: 6s795ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-04-06 23:55:11 Duration: 1s397ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
17 11s291ms 3 1s387ms 4s982ms 3s763ms copy public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Apr 06 04 1 4s921ms 4s921ms 13 1 4s982ms 4s982ms 00 1 1s387ms 1s387ms [ User: labanimal - Total duration: 9s903ms - Times executed: 2 ]
[ User: postgres - Total duration: 1s387ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 11s291ms - Times executed: 3 ]
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-04-06 12:52:16 Duration: 4s982ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-04-06 03:12:40 Duration: 4s921ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-04-06 23:55:06 Duration: 1s387ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
18 8s936ms 3 2s68ms 3s495ms 2s978ms copy public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Apr 06 04 1 3s495ms 3s495ms 13 1 3s372ms 3s372ms 00 1 2s68ms 2s68ms [ User: labanimal - Total duration: 6s867ms - Times executed: 2 ]
[ User: postgres - Total duration: 2s68ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 8s936ms - Times executed: 3 ]
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-04-06 03:12:45 Duration: 3s495ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-04-06 12:52:21 Duration: 3s372ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-04-06 23:55:09 Duration: 2s68ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
19 7s398ms 3 1s276ms 3s69ms 2s466ms copy public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Apr 06 04 1 3s69ms 3s69ms 13 1 3s52ms 3s52ms 00 1 1s276ms 1s276ms [ User: labanimal - Total duration: 6s121ms - Times executed: 2 ]
[ User: postgres - Total duration: 1s276ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 7s398ms - Times executed: 3 ]
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-04-06 03:12:35 Duration: 3s69ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-04-06 12:52:11 Duration: 3s52ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-04-06 23:55:04 Duration: 1s276ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
20 5s787ms 2 2s843ms 2s944ms 2s893ms alter table public.cages add column if not exists cagetalker_id text;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Apr 06 21 1 2s843ms 2s843ms 22 1 2s944ms 2s944ms [ User: labanimal - Total duration: 5s787ms - Times executed: 2 ]
[ Application: psql - Total duration: 5s787ms - Times executed: 2 ]
-
ALTER TABLE public.cages ADD COLUMN IF NOT EXISTS cagetalker_id text;
Date: 2026-04-06 21:28:50 Duration: 2s944ms Database: zemm_produktiv_8 User: labanimal Application: psql Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
ALTER TABLE public.cages ADD COLUMN IF NOT EXISTS cagetalker_id text;
Date: 2026-04-06 20:36:29 Duration: 2s843ms Database: zemm_produktiv_7 User: labanimal Application: psql Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,440 2h24m29s 663ms 41s736ms 6s20ms create table if not exists observability.uptime_checks ( id bigserial primary key, endpoint text not null, status text not null, latency_ms double precision, checked_at timestamptz not null default now() );Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
2 1,440 2h24m29s 663ms 41s736ms 6s20ms create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
3 1,440 2h24m29s 663ms 41s736ms 6s20ms create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
4 1,440 2h24m29s 663ms 41s736ms 6s20ms create index if not exists idx_db_top_queries_tenant on observability.db_top_queries (tenant_key, collected_at desc);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
5 1,440 2h24m29s 663ms 41s736ms 6s20ms 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 #5
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
6 1,440 2h24m29s 663ms 41s736ms 6s20ms 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 #6
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
7 1,440 2h24m29s 663ms 41s736ms 6s20ms create schema if not exists observability;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
8 1,440 2h24m29s 663ms 41s736ms 6s20ms create table if not exists observability.nginx_counters ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
9 1,440 2h24m29s 663ms 41s736ms 6s20ms create table if not exists observability.system_metrics ( id bigserial primary key, payload jsonb not null, collected_at timestamptz not null default now() );Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
10 1,440 2h24m29s 663ms 41s736ms 6s20ms create table if not exists observability.metrics_timeseries ( id bigserial primary key, tenant_key text not null, metric_name text not null, bucket_start timestamptz not null, bucket_width_seconds integer not null default ?, sum_value double precision not null default ?, count_value bigint not null default ?, histogram jsonb, created_at timestamptz not null default now(), updated_at timestamptz not null default now(), unique (tenant_key, metric_name, bucket_start, bucket_width_seconds) );Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
11 1,440 2h24m29s 663ms 41s736ms 6s20ms create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
12 1,440 2h24m29s 663ms 41s736ms 6s20ms 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 #12
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
13 1,440 2h24m29s 663ms 41s736ms 6s20ms create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
14 314 31m47s 2s733ms 43s372ms 6s73ms 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 <= ? 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 #14
Day Hour Count Duration Avg duration Apr 06 01 30 6m8s 12s267ms 02 39 3m20s 5s130ms 03 10 28s170ms 2s817ms 04 36 4m20s 7s243ms 05 6 30s475ms 5s79ms 06 6 30s487ms 5s81ms 07 6 30s643ms 5s107ms 08 3 13s448ms 4s482ms 09 2 6s38ms 3s19ms 10 6 17s934ms 2s989ms 11 15 55s969ms 3s731ms 12 12 1m4s 5s367ms 13 13 1m2s 4s835ms 14 13 38s505ms 2s961ms 15 9 26s251ms 2s916ms 16 12 35s777ms 2s981ms 17 12 34s982ms 2s915ms 18 12 35s131ms 2s927ms 19 12 35s191ms 2s932ms 20 17 49s955ms 2s938ms 21 12 34s932ms 2s911ms 22 12 34s824ms 2s902ms 23 13 3m56s 18s163ms 00 6 2m55s 29s332ms [ User: labanimal - Total duration: 31m47s - Times executed: 314 ]
-
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', 'test', 'dev') AND collected_at <= '2026-04-05 15:12:52+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 15:12:52+02' AND '2026-04-06 03:12:52+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 15:12:52+02' AND '2026-04-06 03:12:52+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-04-06 03:13:35 Duration: 43s372ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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', 'test', 'dev') AND collected_at <= '2026-04-05 15:12:57+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 15:12:57+02' AND '2026-04-06 03:12:57+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 15:12:57+02' AND '2026-04-06 03:12:57+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-04-06 03:13:39 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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', 'test', 'dev') AND collected_at <= '2026-04-05 13:15:52+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 13:15:52+02' AND '2026-04-06 01:15:52+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 13:15:52+02' AND '2026-04-06 01:15:52+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-04-06 01:16:32 Duration: 40s291ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
15 17 15s987ms 831ms 1s910ms 940ms with damdam as ( select breedingid, string_agg(cast(dam as text), ?) as dam from breedingsdams inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as dam on dam.id = breedingsdams.dam and case when user_is_tgm (dam.owner, ?) then true when user_is_tgm (dam.editor, ?) then true when user_is_tgm (dam.tourist, ?) then true else false end group by breedingid ), siresire as ( select breedingid, string_agg(cast(sire as text), ?) as sire from breedingssires inner join ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" from animals) as sire on sire.id = breedingssires.sire and case when user_is_tgm (sire.owner, ?) then true when user_is_tgm (sire.editor, ?) then true when user_is_tgm (sire.tourist, ?) then true else false end group by breedingid ), cagess as ( select id, "cageName" from cages) ( select breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire from damdam, siresire, cagess, breedings where breedings.deleted != true and cagess.id = breedings.cage and damdam.breedingid = breedings.id and siresire.breedingid = breedings.id and breedings."unbreeding_date" is null group by breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire order by breeding_date, plug_date);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Apr 06 03 2 1s985ms 992ms 12 1 1s910ms 1s910ms 16 4 3s643ms 910ms 18 1 855ms 855ms 19 3 2s518ms 839ms 20 4 3s374ms 843ms 22 2 1s699ms 849ms [ User: labanimal - Total duration: 15s987ms - Times executed: 17 ]
[ Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 - Total duration: 14s76ms - Times executed: 16 ]
[ Application: _desktop_index.php_zemm_produktiv_8_localhost_5432 - Total duration: 1s910ms - Times executed: 1 ]
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-06 11:23:12 Duration: 1s910ms 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-04-06_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-06 02:42:30 Duration: 1s100ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
WITH damdam AS ( SELECT breedingid, string_agg(cast(dam as text), ';') AS dam FROM breedingsdams INNER JOIN ( SELECT id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS dam ON dam.id = breedingsdams.dam AND CASE WHEN user_is_tgm (dam.owner, 1) THEN TRUE WHEN user_is_tgm (dam.editor, 1) THEN TRUE WHEN user_is_tgm (dam.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), siresire AS ( SELECT breedingid, string_agg(cast(sire as text), ';') AS sire FROM breedingssires INNER JOIN ( select id, owner, editor, tourist, "animalID", name, "dummy_strain_info", generation, "dummy_line_info", "dummy_backcross_info" FROM animals) AS sire ON sire.id = breedingssires.sire AND CASE WHEN user_is_tgm (sire.owner, 1) THEN TRUE WHEN user_is_tgm (sire.editor, 1) THEN TRUE WHEN user_is_tgm (sire.tourist, 1) THEN TRUE ELSE FALSE END GROUP BY breedingid ), cagess AS ( select id, "cageName" FROM cages) ( SELECT breedings.id, breedings.breeding_date, breedings.unbreeding_date, breedings.plug_date, cagess."cageName" as cage_name, breedings.deleted, damdam.dam, siresire.sire FROM damdam, siresire, cagess, breedings WHERE breedings.deleted != true AND cagess.id = breedings.cage AND damdam.breedingid = breedings.id AND siresire.breedingid = breedings.id AND breedings."unbreeding_date" IS NULL GROUP BY breedings.id, cagess."cageName", breeding_date, unbreeding_date, plug_date, damdam.dam, siresire.sire ORDER BY breeding_date, plug_date);
Date: 2026-04-06 15:14:29 Duration: 1s60ms Database: zemm_produktiv_7 User: labanimal Application: _desktop_index.php_zemm_produktiv_7_localhost_5432 Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
16 3 15s311ms 1s397ms 7s119ms 5s103ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Apr 06 04 1 7s119ms 7s119ms 13 1 6s795ms 6s795ms 00 1 1s397ms 1s397ms [ User: labanimal - Total duration: 13s914ms - Times executed: 2 ]
[ User: postgres - Total duration: 1s397ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 15s311ms - Times executed: 3 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-04-06 03:12:55 Duration: 7s119ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-04-06 12:52:30 Duration: 6s795ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-04-06 23:55:11 Duration: 1s397ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
17 3 11s291ms 1s387ms 4s982ms 3s763ms copy public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Apr 06 04 1 4s921ms 4s921ms 13 1 4s982ms 4s982ms 00 1 1s387ms 1s387ms [ User: labanimal - Total duration: 9s903ms - Times executed: 2 ]
[ User: postgres - Total duration: 1s387ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 11s291ms - Times executed: 3 ]
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-04-06 12:52:16 Duration: 4s982ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-04-06 03:12:40 Duration: 4s921ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-04-06 23:55:06 Duration: 1s387ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
18 3 8s936ms 2s68ms 3s495ms 2s978ms copy public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Apr 06 04 1 3s495ms 3s495ms 13 1 3s372ms 3s372ms 00 1 2s68ms 2s68ms [ User: labanimal - Total duration: 6s867ms - Times executed: 2 ]
[ User: postgres - Total duration: 2s68ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 8s936ms - Times executed: 3 ]
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-04-06 03:12:45 Duration: 3s495ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-04-06 12:52:21 Duration: 3s372ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-04-06 23:55:09 Duration: 2s68ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
19 3 7s398ms 1s276ms 3s69ms 2s466ms copy public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Apr 06 04 1 3s69ms 3s69ms 13 1 3s52ms 3s52ms 00 1 1s276ms 1s276ms [ User: labanimal - Total duration: 6s121ms - Times executed: 2 ]
[ User: postgres - Total duration: 1s276ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 7s398ms - Times executed: 3 ]
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-04-06 03:12:35 Duration: 3s69ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-04-06 12:52:11 Duration: 3s52ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-04-06 23:55:04 Duration: 1s276ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
20 3 2s904ms 574ms 1s171ms 968ms copy public.cost_history (id, service, fromdate, todate, animal, animalgroup, comment, deleted, invoice, amount, license, kostenstelle_erb, drittmittel, kostenstelle_anf, finanzstelle_anf, kostenkategorie, extern_anf, form_text, mat_nr, supersedes, price) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Apr 06 04 1 1s158ms 1s158ms 13 1 1s171ms 1s171ms 00 1 574ms 574ms [ User: labanimal - Total duration: 2s330ms - Times executed: 2 ]
[ User: postgres - Total duration: 574ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 2s904ms - Times executed: 3 ]
-
COPY public.cost_history (id, service, fromdate, todate, animal, animalgroup, comment, deleted, invoice, amount, license, kostenstelle_erb, drittmittel, kostenstelle_anf, finanzstelle_anf, kostenkategorie, extern_anf, form_text, mat_nr, supersedes, price) TO stdout;
Date: 2026-04-06 12:52:18 Duration: 1s171ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public.cost_history (id, service, fromdate, todate, animal, animalgroup, comment, deleted, invoice, amount, license, kostenstelle_erb, drittmittel, kostenstelle_anf, finanzstelle_anf, kostenkategorie, extern_anf, form_text, mat_nr, supersedes, price) TO stdout;
Date: 2026-04-06 03:12:42 Duration: 1s158ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public.cost_history (id, service, fromdate, todate, animal, animalgroup, comment, deleted, invoice, amount, license, kostenstelle_erb, drittmittel, kostenstelle_anf, finanzstelle_anf, kostenkategorie, extern_anf, form_text, mat_nr, supersedes, price) TO stdout;
Date: 2026-04-06 23:55:06 Duration: 574ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2s733ms 43s372ms 6s73ms 314 31m47s 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 <= ? order by tenant_key, fingerprint, collected_at desc ), fallback_start as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at between ? and ? order by tenant_key, fingerprint, collected_at asc ), end_snap as ( select distinct on (tenant_key, fingerprint) tenant_key, fingerprint, query, total_time_ms, calls, rows_returned, collected_at from observability.db_top_queries where tenant_key in (...) and collected_at between ? and ? order by tenant_key, fingerprint, collected_at desc ), deltas as ( select e.tenant_key, e.fingerprint, e.query, e.collected_at as last_seen, greatest (coalesce(e.total_time_ms, ?) - coalesce(s.total_time_ms, fs.total_time_ms, ?), ?) as total_time_ms, greatest (coalesce(e.calls, ?) - coalesce(s.calls, fs.calls, ?), ?) as calls, greatest (coalesce(e.rows_returned, ?) - coalesce(s.rows_returned, fs.rows_returned, ?), ?) as rows_returned from end_snap e left join start_snap s on s.tenant_key = e.tenant_key and s.fingerprint = e.fingerprint left join fallback_start fs on fs.tenant_key = e.tenant_key and fs.fingerprint = e.fingerprint and s.tenant_key is null ) select fingerprint, max(query) as query, max(last_seen) as last_seen, sum(total_time_ms) as total_time_ms, sum(calls) as calls, sum(rows_returned) as rows_returned, case when sum(calls) > ? then sum(total_time_ms) / sum(calls) else ? end as mean_time_ms, array_agg(distinct tenant_key order by tenant_key) as tenant_keys from deltas where total_time_ms > ? or calls > ? group by fingerprint order by total_time_ms desc, calls desc limit ? offset ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Apr 06 01 30 6m8s 12s267ms 02 39 3m20s 5s130ms 03 10 28s170ms 2s817ms 04 36 4m20s 7s243ms 05 6 30s475ms 5s79ms 06 6 30s487ms 5s81ms 07 6 30s643ms 5s107ms 08 3 13s448ms 4s482ms 09 2 6s38ms 3s19ms 10 6 17s934ms 2s989ms 11 15 55s969ms 3s731ms 12 12 1m4s 5s367ms 13 13 1m2s 4s835ms 14 13 38s505ms 2s961ms 15 9 26s251ms 2s916ms 16 12 35s777ms 2s981ms 17 12 34s982ms 2s915ms 18 12 35s131ms 2s927ms 19 12 35s191ms 2s932ms 20 17 49s955ms 2s938ms 21 12 34s932ms 2s911ms 22 12 34s824ms 2s902ms 23 13 3m56s 18s163ms 00 6 2m55s 29s332ms [ User: labanimal - Total duration: 31m47s - Times executed: 314 ]
-
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', 'test', 'dev') AND collected_at <= '2026-04-05 15:12:52+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 15:12:52+02' AND '2026-04-06 03:12:52+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 15:12:52+02' AND '2026-04-06 03:12:52+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-04-06 03:13:35 Duration: 43s372ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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', 'test', 'dev') AND collected_at <= '2026-04-05 15:12:57+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 15:12:57+02' AND '2026-04-06 03:12:57+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 15:12:57+02' AND '2026-04-06 03:12:57+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-04-06 03:13:39 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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', 'test', 'dev') AND collected_at <= '2026-04-05 13:15:52+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 13:15:52+02' AND '2026-04-06 01:15:52+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', 'test', 'dev') AND collected_at BETWEEN '2026-04-05 13:15:52+02' AND '2026-04-06 01:15:52+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-04-06 01:16:32 Duration: 40s291ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
2 663ms 41s736ms 6s20ms 1,440 2h24m29s 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 #2
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE TABLE IF NOT EXISTS observability.uptime_checks ( id bigserial PRIMARY KEY, endpoint text NOT NULL, status text NOT NULL, latency_ms double precision, checked_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
3 663ms 41s736ms 6s20ms 1,440 2h24m29s create index if not exists idx_metrics_timeseries_bucket on observability.metrics_timeseries (bucket_start);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_bucket ON observability.metrics_timeseries (bucket_start);
Date: 2026-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
4 663ms 41s736ms 6s20ms 1,440 2h24m29s create index if not exists idx_metrics_timeseries_metric on observability.metrics_timeseries (metric_name);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_metrics_timeseries_metric ON observability.metrics_timeseries (metric_name);
Date: 2026-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
5 663ms 41s736ms 6s20ms 1,440 2h24m29s 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 #5
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_db_top_queries_tenant ON observability.db_top_queries (tenant_key, collected_at DESC);
Date: 2026-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
6 663ms 41s736ms 6s20ms 1,440 2h24m29s 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 #6
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE TABLE IF NOT EXISTS observability.db_top_queries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, fingerprint text, query text, mean_time_ms double precision, total_time_ms double precision, calls bigint, rows_returned bigint, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
7 663ms 41s736ms 6s20ms 1,440 2h24m29s 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 Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE TABLE IF NOT EXISTS observability.phpfpm_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
8 663ms 41s736ms 6s20ms 1,440 2h24m29s create schema if not exists observability;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE SCHEMA IF NOT EXISTS observability;
Date: 2026-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
9 663ms 41s736ms 6s20ms 1,440 2h24m29s 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 #9
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE TABLE IF NOT EXISTS observability.nginx_counters ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
10 663ms 41s736ms 6s20ms 1,440 2h24m29s 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 #10
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE TABLE IF NOT EXISTS observability.system_metrics ( id bigserial PRIMARY KEY, payload jsonb NOT NULL, collected_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
11 663ms 41s736ms 6s20ms 1,440 2h24m29s create table if not exists observability.metrics_timeseries ( id bigserial primary key, tenant_key text not null, metric_name text not null, bucket_start timestamptz not null, bucket_width_seconds integer not null default ?, sum_value double precision not null default ?, count_value bigint not null default ?, histogram jsonb, created_at timestamptz not null default now(), updated_at timestamptz not null default now(), unique (tenant_key, metric_name, bucket_start, bucket_width_seconds) );Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE TABLE IF NOT EXISTS observability.metrics_timeseries ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, metric_name text NOT NULL, bucket_start timestamptz NOT NULL, bucket_width_seconds integer NOT NULL DEFAULT 60, sum_value double precision NOT NULL DEFAULT 0, count_value bigint NOT NULL DEFAULT 0, histogram jsonb, created_at timestamptz NOT NULL DEFAULT NOW(), updated_at timestamptz NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, metric_name, bucket_start, bucket_width_seconds) );
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
12 663ms 41s736ms 6s20ms 1,440 2h24m29s create index if not exists idx_app_events_type on observability.app_events (event_type);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_type ON observability.app_events (event_type);
Date: 2026-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
13 663ms 41s736ms 6s20ms 1,440 2h24m29s 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 #13
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE TABLE IF NOT EXISTS observability.app_events ( id bigserial PRIMARY KEY, tenant_key text NOT NULL, event_type text NOT NULL, severity text NOT NULL, message text NOT NULL, payload jsonb, occurred_at timestamptz NOT NULL DEFAULT NOW(), created_at timestamptz NOT NULL DEFAULT NOW() );
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
14 663ms 41s736ms 6s20ms 1,440 2h24m29s create index if not exists idx_app_events_tenant on observability.app_events (tenant_key, occurred_at desc);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Apr 06 01 60 15m25s 15s428ms 02 60 5m28s 5s473ms 03 60 2m18s 2s300ms 04 60 6m11s 6s197ms 05 60 5m4s 5s79ms 06 60 5m4s 5s80ms 07 60 5m5s 5s98ms 08 60 3m30s 3s510ms 09 60 2m56s 2s935ms 10 60 2m59s 2s988ms 11 60 3m5s 3s88ms 12 60 5m6s 5s115ms 13 60 5m5s 5s99ms 14 60 2m57s 2s966ms 15 60 2m55s 2s917ms 16 60 2m34s 2s578ms 17 60 2m54s 2s912ms 18 60 2m47s 2s787ms 19 60 2m45s 2s758ms 20 60 2m28s 2s475ms 21 60 2m54s 2s911ms 22 60 2m50s 2s834ms 23 60 24m28s 24s482ms 00 60 27m28s 27s472ms [ User: labanimal - Total duration: 2h24m29s - Times executed: 1438 ]
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-06 03:16:01 Duration: 41s736ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-06 00:09:01 Duration: 39s515ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
CREATE INDEX IF NOT EXISTS idx_app_events_tenant ON observability.app_events (tenant_key, occurred_at DESC);
Date: 2026-04-06 00:06:01 Duration: 39s366ms Database: zemm_monitoring User: labanimal Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
15 1s397ms 7s119ms 5s103ms 3 15s311ms copy public."targetgroupMembers" (id, targetgroup, "user", "group") to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Apr 06 04 1 7s119ms 7s119ms 13 1 6s795ms 6s795ms 00 1 1s397ms 1s397ms [ User: labanimal - Total duration: 13s914ms - Times executed: 2 ]
[ User: postgres - Total duration: 1s397ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 15s311ms - Times executed: 3 ]
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-04-06 03:12:55 Duration: 7s119ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-04-06 12:52:30 Duration: 6s795ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public."targetgroupMembers" (id, targetgroup, "user", "group") TO stdout;
Date: 2026-04-06 23:55:11 Duration: 1s397ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
16 1s387ms 4s982ms 3s763ms 3 11s291ms copy public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Apr 06 04 1 4s921ms 4s921ms 13 1 4s982ms 4s982ms 00 1 1s387ms 1s387ms [ User: labanimal - Total duration: 9s903ms - Times executed: 2 ]
[ User: postgres - Total duration: 1s387ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 11s291ms - Times executed: 3 ]
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-04-06 12:52:16 Duration: 4s982ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-04-06 03:12:40 Duration: 4s921ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public.animals_search_mview (id, name, animal_id, deleted, alive, birth_date, arrival_date, death_date, outgoing_date, cage, comments, sterile, breeding, fate, last_mating, last_mating_date, breeding_cage, sex, strain, line, gene_1_info, gene_1_type, gene_2_info, gene_2_type, gene_3_info, gene_3_type, gene_4_info, gene_4_type, gene_5_info, gene_5_type, backcross, generation, project, project_name, species, species_name, cage_name, location, location_name, dam, dam_name, dam_id, sire, sire_name, sire_id, cohort, litter, rfid, owner, editor, tourist, breeding_status, workgroup_infos, experiment, experiment_name) TO stdout;
Date: 2026-04-06 23:55:06 Duration: 1s387ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
17 2s68ms 3s495ms 2s978ms 3 8s936ms copy public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Apr 06 04 1 3s495ms 3s495ms 13 1 3s372ms 3s372ms 00 1 2s68ms 2s68ms [ User: labanimal - Total duration: 6s867ms - Times executed: 2 ]
[ User: postgres - Total duration: 2s68ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 8s936ms - Times executed: 3 ]
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-04-06 03:12:45 Duration: 3s495ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-04-06 12:52:21 Duration: 3s372ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public.diary (id, "animalID", date, "entrybyID", "cageID", weight, temperature, "fDeprivation", "wDeprivation", "sDeprivation", "feedingClass", health, comments, "breedingInfo", deleted, "inOutDate", "inOutFlag", text, sdesc, treatment, tailcut_id, tailcut_result, file_name, file_content, file_type, upload_name, old_gene_type, old_gene_info, old_gene2_type, old_gene2_info, old_gene3_info, old_gene3_type, old_gene4_info, old_gene4_type, old_gene5_info, old_gene5_type) TO stdout;
Date: 2026-04-06 23:55:09 Duration: 2s68ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
18 2s843ms 2s944ms 2s893ms 2 5s787ms alter table public.cages add column if not exists cagetalker_id text;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Apr 06 21 1 2s843ms 2s843ms 22 1 2s944ms 2s944ms [ User: labanimal - Total duration: 5s787ms - Times executed: 2 ]
[ Application: psql - Total duration: 5s787ms - Times executed: 2 ]
-
ALTER TABLE public.cages ADD COLUMN IF NOT EXISTS cagetalker_id text;
Date: 2026-04-06 21:28:50 Duration: 2s944ms Database: zemm_produktiv_8 User: labanimal Application: psql Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
ALTER TABLE public.cages ADD COLUMN IF NOT EXISTS cagetalker_id text;
Date: 2026-04-06 20:36:29 Duration: 2s843ms Database: zemm_produktiv_7 User: labanimal Application: psql Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
19 1s276ms 3s69ms 2s466ms 3 7s398ms copy public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Apr 06 04 1 3s69ms 3s69ms 13 1 3s52ms 3s52ms 00 1 1s276ms 1s276ms [ User: labanimal - Total duration: 6s121ms - Times executed: 2 ]
[ User: postgres - Total duration: 1s276ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 7s398ms - Times executed: 3 ]
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-04-06 03:12:35 Duration: 3s69ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-04-06 12:52:11 Duration: 3s52ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public.animals (id, species, transgen, "homeCage", tourist, editor, owner, comments, pregnant, name, sex, "standardDescription", "parentFemale", "parentMale", "parentFoster", colour, "plannedUseFor", deleted, generation, chimare, "birthDate", "arrivalDate", "outgoingDate", "deathDate", breedstatus_2, "healthState", breeder, restrictions, "geneStatus", "geneFlanking", "geneDeleted", "fromOrder_2", "group", "fromOrder", strain, "breedStatus", "FEMnumber", genotype, inbreeding, identification, jax, "KOgene", "feedingClass", dummy_gen_info, breeding, sterile, project, dummy_line_info, dummy_strain_info, "bredWith", "curCage", dummy_backcross_info, fate, "fateComment", alive, reciever, "animalID", litter, weight_at_arrival, cohort, gen_2_info, gen_3_info, gen_4_info, gen_5_info, gen_1_typ, gen_2_typ, gen_3_typ, gen_4_typ, gen_5_typ, "latestMatingDate", "latestMating", genecomment, recycle) TO stdout;
Date: 2026-04-06 23:55:04 Duration: 1s276ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
20 574ms 1s171ms 968ms 3 2s904ms copy public.cost_history (id, service, fromdate, todate, animal, animalgroup, comment, deleted, invoice, amount, license, kostenstelle_erb, drittmittel, kostenstelle_anf, finanzstelle_anf, kostenkategorie, extern_anf, form_text, mat_nr, supersedes, price) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Apr 06 04 1 1s158ms 1s158ms 13 1 1s171ms 1s171ms 00 1 574ms 574ms [ User: labanimal - Total duration: 2s330ms - Times executed: 2 ]
[ User: postgres - Total duration: 574ms - Times executed: 1 ]
[ Application: pg_dump - Total duration: 2s904ms - Times executed: 3 ]
-
COPY public.cost_history (id, service, fromdate, todate, animal, animalgroup, comment, deleted, invoice, amount, license, kostenstelle_erb, drittmittel, kostenstelle_anf, finanzstelle_anf, kostenkategorie, extern_anf, form_text, mat_nr, supersedes, price) TO stdout;
Date: 2026-04-06 12:52:18 Duration: 1s171ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public.cost_history (id, service, fromdate, todate, animal, animalgroup, comment, deleted, invoice, amount, license, kostenstelle_erb, drittmittel, kostenstelle_anf, finanzstelle_anf, kostenkategorie, extern_anf, form_text, mat_nr, supersedes, price) TO stdout;
Date: 2026-04-06 03:12:42 Duration: 1s158ms Database: zemm_produktiv_8 User: labanimal Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
-
COPY public.cost_history (id, service, fromdate, todate, animal, animalgroup, comment, deleted, invoice, amount, license, kostenstelle_erb, drittmittel, kostenstelle_anf, finanzstelle_anf, kostenkategorie, extern_anf, form_text, mat_nr, supersedes, price) TO stdout;
Date: 2026-04-06 23:55:06 Duration: 574ms Database: zemm_produktiv_8 User: postgres Remote: [local] Application: pg_dump Bind query: yes Log file: /var/log/postgresql/postgresql-2026-04-06_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
- 97,708 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 6 FATAL entries
- 80 ERROR entries
- 0 WARNING entries
- 31 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 61 Max number of times the same event was reported
- 117 Total events found
Rank Times reported Error 1 61 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Apr 06 02 15 03 2 10 6 11 1 12 23 13 9 14 4 20 1 - ERROR: column "lang" does not exist
- ERROR: column "ts" does not exist
- ERROR: column "ts" does not exist
Statement: SELECT username, lastlogin, lang, authlevel FROM users WHERE lastlogin >= '2026-04-05 15:00:00' AND lastlogin <= '2026-04-06 03:00:00' ORDER BY lastlogin DESC LIMIT 20;
Date: 2026-04-06 01:11:31 Database: zemm_produktiv_7 Application: psql User: mcp_ro Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
Statement: SELECT * FROM login WHERE ts >= '2026-04-05 15:00:00' ORDER BY ts ASC;
Date: 2026-04-06 01:12:13 Database: zemm_produktiv_7 Application: psql User: mcp_ro Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
Statement: SELECT * FROM login ORDER BY ts DESC LIMIT 20;
Date: 2026-04-06 01:12:13 Database: zemm_produktiv_7 Application: psql User: mcp_ro Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
2 16 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Apr 06 02 2 03 2 10 1 12 6 13 3 14 2 - ERROR: relation "observability_events" does not exist
- ERROR: relation "observability_events" does not exist
- ERROR: relation "litter" does not exist
Statement: SELECT tenant_key, COUNT(*) as events, MAX(created_at) as last_event FROM observability_events GROUP BY tenant_key ORDER BY last_event DESC;
Date: 2026-04-06 01:47:14 Database: zemm_monitoring Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
Statement: SELECT tenant_key, COUNT(*) as events, MAX(created_at) as last_event FROM observability_events GROUP BY tenant_key ORDER BY last_event DESC;
Date: 2026-04-06 01:47:19 Database: zemm_monitoring Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
Statement: SELECT tbl, cnt FROM ( SELECT 1 as ord, 'animals (non-deleted)' as tbl, count(*)::text as cnt FROM animals WHERE deleted = false UNION ALL SELECT 2, 'animals (all)', count(*)::text FROM animals UNION ALL SELECT 3, 'cages (non-deleted)', count(*)::text FROM cages WHERE deleted = false UNION ALL SELECT 4, 'cages (all)', count(*)::text FROM cages UNION ALL SELECT 5, 'breedings', count(*)::text FROM breedings UNION ALL SELECT 6, 'litter', count(*)::text FROM litter UNION ALL SELECT 7, 'users (non-deleted)', count(*)::text FROM users WHERE deleted = false UNION ALL SELECT 8, 'users (all)', count(*)::text FROM users UNION ALL SELECT 9, 'login_tracker', count(*)::text FROM login_tracker UNION ALL SELECT 10, 'mutations', count(*)::text FROM mutations UNION ALL SELECT 11, 'strains', count(*)::text FROM strains ) x ORDER BY ord;
Date: 2026-04-06 02:07:54 Database: zemm_produktiv_7 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
3 10 ERROR: duplicate key value violates unique constraint "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Apr 06 01 2 02 1 03 1 04 1 10 1 13 1 23 3 - ERROR: duplicate key value violates unique constraint "metrics_timeseries_tenant_key_metric_name_bucket_start_buck_key"
- ERROR: duplicate key value violates unique constraint "metrics_timeseries_tenant_key_metric_name_bucket_start_buck_key"
- ERROR: duplicate key value violates unique constraint "metrics_timeseries_tenant_key_metric_name_bucket_start_buck_key"
Detail: Key (tenant_key, metric_name, bucket_start, bucket_width_seconds)=(prod, http_requests_total, 2026-04-06 00:00:00+02, 60) already exists.
Statement: INSERT INTO observability.metrics_timeseries (tenant_key, metric_name, bucket_start, bucket_width_seconds, sum_value, count_value, histogram) VALUES ($1, $2, $3, $4, $5, $6, $7)Date: 2026-04-06 00:00:58 Database: zemm_monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
Detail: Key (tenant_key, metric_name, bucket_start, bucket_width_seconds)=(prod, http_requests_total, 2026-04-06 00:49:00+02, 60) already exists.
Statement: INSERT INTO observability.metrics_timeseries (tenant_key, metric_name, bucket_start, bucket_width_seconds, sum_value, count_value, histogram) VALUES ($1, $2, $3, $4, $5, $6, $7)Date: 2026-04-06 00:49:03 Database: zemm_monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
Detail: Key (tenant_key, metric_name, bucket_start, bucket_width_seconds)=(prod, http_requests_total, 2026-04-06 01:34:00+02, 60) already exists.
Statement: INSERT INTO observability.metrics_timeseries (tenant_key, metric_name, bucket_start, bucket_width_seconds, sum_value, count_value, histogram) VALUES ($1, $2, $3, $4, $5, $6, $7)Date: 2026-04-06 01:34:00 Database: zemm_monitoring Application: User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
4 8 ERROR: permission denied for table ...
Times Reported Most Frequent Error / Event #4
Day Hour Count Apr 06 02 8 - ERROR: permission denied for table users
- ERROR: permission denied for table users
- ERROR: permission denied for table login
Statement: SELECT username, lastlogin, authlevel FROM users WHERE lastlogin IS NOT NULL ORDER BY lastlogin DESC LIMIT 10;
Date: 2026-04-06 01:11:31 Database: zemm_produktiv_7 Application: psql User: mcp_ro Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
Statement: SELECT COUNT(*) FROM users;
Date: 2026-04-06 01:11:40 Database: zemm_produktiv_7 Application: psql User: mcp_ro Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
Statement: SELECT * FROM login LIMIT 3;
Date: 2026-04-06 01:12:20 Database: zemm_produktiv_7 Application: psql User: mcp_ro Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
5 5 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Apr 06 03 4 13 1 - ERROR: syntax error at or near "2"
- ERROR: syntax error at or near "2"
- ERROR: syntax error at or near "19"
Statement: SELECT 'animals (non-deleted)' as tbl, count(*) FROM animals WHERE deleted = false UNION ALL SELECT 'animals (all)', count(*) FROM animals UNION ALL SELECT 'cages (non-deleted)', count(*) FROM cages WHERE deleted = false UNION ALL SELECT 'cages (all)', count(*) FROM cages UNION ALL SELECT 'breedings', count(*) FROM breedings UNION ALL SELECT 'litter', count(*) FROM litter UNION ALL SELECT 'users (non-deleted)', count(*) FROM users WHERE deleted = false UNION ALL SELECT 'users (all)', count(*) FROM users UNION ALL SELECT 'login_tracker', count(*) FROM login_tracker UNION ALL SELECT 'tasks', count(*) FROM tasks 2>/dev/null ORDER BY 1;
Date: 2026-04-06 02:07:43 Database: zemm_produktiv_7 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
Statement: SELECT 'animals (non-deleted)' as tbl, count(*) FROM animals WHERE deleted = false UNION ALL SELECT 'animals (all)', count(*) FROM animals UNION ALL SELECT 'cages (non-deleted)', count(*) FROM cages WHERE deleted = false UNION ALL SELECT 'cages (all)', count(*) FROM cages UNION ALL SELECT 'breedings', count(*) FROM breedings UNION ALL SELECT 'litter', count(*) FROM litter UNION ALL SELECT 'users (non-deleted)', count(*) FROM users WHERE deleted = false UNION ALL SELECT 'users (all)', count(*) FROM users UNION ALL SELECT 'login_tracker', count(*) FROM login_tracker UNION ALL SELECT 'tasks', count(*) FROM tasks 2>/dev/null ORDER BY 1;
Date: 2026-04-06 02:07:43 Database: zemm_produktiv_8 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
Statement: SELECT id, "loginname", ip, "hostname", "timestamp", left("sessionbrowser",40) as browser FROM login_tracker WHERE "timestamp" >= 2026-04-05 19:00:00 ORDER BY "timestamp";
Date: 2026-04-06 02:09:23 Database: zemm_produktiv_7 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
6 5 FATAL: Peer authentication failed for user "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Apr 06 01 4 18 1 - FATAL: Peer authentication failed for user "labanimal"
- FATAL: Peer authentication failed for user "labanimal"
- FATAL: Peer authentication failed for user "postgres"
Detail: Connection matched file "/etc/postgresql/18/main/pg_hba.conf" line 18: "local all all peer"
Date: 2026-04-06 00:45:38 Database: zemm_produktiv_8 Application: User: labanimal Remote: [local] Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
Detail: Connection matched file "/etc/postgresql/18/main/pg_hba.conf" line 18: "local all all peer"
Date: 2026-04-06 00:45:38 Database: zemm_produktiv_7 Application: User: labanimal Remote: [local] Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
Detail: Connection matched file "/etc/postgresql/18/main/pg_hba.conf" line 16: "local all postgres peer"
Date: 2026-04-06 00:45:38 Database: postgres Application: User: postgres Remote: [local] Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
7 3 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #7
Day Hour Count Apr 06 13 3 - LOG: could not receive data from client: Connection reset by peer
- LOG: could not receive data from client: Connection reset by peer
- LOG: could not receive data from client: Connection reset by peer
Date: 2026-04-06 12:22:35 Database: zemm_produktiv_8 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
Date: 2026-04-06 12:22:35 Database: zemm_produktiv_8 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
Date: 2026-04-06 12:22:35 Database: zemm_produktiv_8 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
8 2 ERROR: column reference "..." is ambiguous
Times Reported Most Frequent Error / Event #8
Day Hour Count Apr 06 03 2 - ERROR: column reference "start_value" is ambiguous
- ERROR: column reference "start_value" is ambiguous
Statement: SELECT sequence_name, last_value, start_value FROM information_schema.sequences s JOIN pg_sequences ps ON ps.schemaname=s.sequence_schema AND ps.sequencename=s.sequence_name WHERE sequence_name IN ('animals_id_seq','cages_id_seq','login_tracker_id_seq','users_id_seq') ORDER BY sequence_name;
Date: 2026-04-06 02:09:57 Database: zemm_produktiv_7 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
Statement: SELECT sequence_name, last_value, start_value FROM information_schema.sequences s JOIN pg_sequences ps ON ps.schemaname=s.sequence_schema AND ps.sequencename=s.sequence_name WHERE sequence_name IN ('animals_id_seq','cages_id_seq','login_tracker_id_seq','users_id_seq') ORDER BY sequence_name;
Date: 2026-04-06 02:09:57 Database: zemm_produktiv_8 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
9 2 FATAL: password authentication failed for user "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Apr 06 01 2 - FATAL: password authentication failed for user "postgres"
- FATAL: password authentication failed for user "postgres"
Detail: User "postgres" has no password assigned. Connection matched file "/etc/postgresql/18/main/pg_hba.conf" line 27: "host all all ::1/128 scram-sha-256"
Date: 2026-04-06 00:34:50 Database: postgres Application: User: postgres Remote: ::1 Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
Detail: User "postgres" has no password assigned. Connection matched file "/etc/postgresql/18/main/pg_hba.conf" line 27: "host all all ::1/128 scram-sha-256"
Date: 2026-04-06 00:34:50 Database: postgres Application: User: postgres Remote: ::1 Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
10 2 ERROR: current transaction is aborted, commands ignored until end of transaction block
Times Reported Most Frequent Error / Event #10
Day Hour Count Apr 06 13 2 - ERROR: current transaction is aborted, commands ignored until end of transaction block
- ERROR: current transaction is aborted, commands ignored until end of transaction block
Statement: INSERT INTO litter_history (id, litter, "splitMale", "splitFemale", timestamp, "byID") VALUES (nextval('litter_history_id_seq'), 10131721, 2, 0, '2026-04-06 09:17:00.043', 452), (nextval('litter_history_id_seq'), 10131721, 0, 4, '2026-04-06 09:17:00.297', 452);
Date: 2026-04-06 12:51:10 Database: zemm_produktiv_8 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
Statement: DO $$ DECLARE v_split_m int; v_split_f int; v_lh_count int; v_animals int; v_fem_count int; BEGIN SELECT "splitMale", "splitFemale" INTO v_split_m, v_split_f FROM litters WHERE id = 10131721; IF v_split_m <> 2 OR v_split_f <> 4 THEN RAISE EXCEPTION 'POST-CHECK FAILED: litters splitMale=% splitFemale=%, expected 2/4', v_split_m, v_split_f; END IF; SELECT COUNT(*) INTO v_lh_count FROM litter_history WHERE litter = 10131721; IF v_lh_count <> 2 THEN RAISE EXCEPTION 'POST-CHECK FAILED: litter_history count=%, expected 2', v_lh_count; END IF; SELECT COUNT(*) INTO v_animals FROM animals WHERE litter = 10131721; IF v_animals <> 6 THEN RAISE EXCEPTION 'POST-CHECK FAILED: animals count=%, expected 6', v_animals; END IF; SELECT COUNT(*) INTO v_fem_count FROM fem_numbers WHERE year = 2026 AND th = 0 AND num BETWEEN 8515 AND 8520 AND used = true; IF v_fem_count <> 6 THEN RAISE EXCEPTION 'POST-CHECK FAILED: fem_numbers used count=%, expected 6', v_fem_count; END IF; RAISE NOTICE 'All post-checks passed. Safe to COMMIT.'; END; $$;
Date: 2026-04-06 12:51:10 Database: zemm_produktiv_8 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
11 1 ERROR: UPDATE litters affected 0 rows — litter 10131721 may not exist in ZP8.
Times Reported Most Frequent Error / Event #11
Day Hour Count Apr 06 13 1 - ERROR: UPDATE litters affected 0 rows — litter 10131721 may not exist in ZP8.
Context: PL/pgSQL function inline_code_block line 4 at RAISE
Statement: DO $$ BEGIN IF NOT FOUND THEN RAISE EXCEPTION 'UPDATE litters affected 0 rows — litter 10131721 may not exist in ZP8.'; END IF; END; $$;Date: 2026-04-06 12:51:10 Database: zemm_produktiv_8 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
12 1 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Apr 06 20 1 - FATAL: database "zemm_dev" does not exist
Date: 2026-04-06 19:33:31 Database: zemm_dev Application: psql SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256) User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv
13 1 ERROR: column "..." must appear in the GROUP BY clause or be used in an aggregate function
Times Reported Most Frequent Error / Event #13
Day Hour Count Apr 06 03 1 - ERROR: column "x.schemaname" must appear in the GROUP BY clause or be used in an aggregate function
Statement: SELECT schemaname||'.'||tablename as table_name, operation, count(*) FROM ( SELECT 'animals' as tablename, 'public' as schemaname, null::text as operation FROM animals WHERE 1=0 ) x WHERE 1=0; -- G-7 is already confirmed GREEN from previous session audit
Date: 2026-04-06 02:42:14 Database: zemm_produktiv_7 Application: psql User: labanimal Remote: Log file: /var/log/postgresql/postgresql-2026-04-06_000000.csv