pgBadger-
Global information
- Generated on Mon Aug 10 23:50:11 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 46,353 log entries in 9s
- Log start from 2026-08-10 00:00:36 to 2026-08-10 23:49:32
-
Overview
Global Stats
- 358 Number of unique normalized queries
- 6,890 Number of queries
- 8h48m8s Total query duration
- 2026-08-10 00:02:05 First query
- 2026-08-10 23:44:37 Last query
- 5 queries/s at 2026-08-10 09:24:05 Query peak
- 8h48m8s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h48m8s Execute total duration
- 4,365 Number of events
- 17 Number of unique normalized events
- 4,246 Max number of times the same event was reported
- 0 Number of cancellation
- 533 Total number of automatic vacuums
- 1,109 Total number of automatic analyzes
- 10 Number temporary file
- 239.57 MiB Max size of temporary file
- 111.38 MiB Average size of temporary file
- 365 Total number of sessions
- 8 sessions at 2026-08-10 11:23:25 Session peak
- 13d8h40m23s Total duration of sessions
- 52m42s Average duration of sessions
- 18 Average queries per session
- 1m26s Average queries duration per session
- 51m15s Average idle time per session
- 381 Total number of connections
- 5 connections/s at 2026-08-10 09:28:05 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-10 09:24:05 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-10 09:24:05 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-10 23:44:35 Date
Queries duration
Key values
- 8h48m8s 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) Aug 10 00 21 0ms 18s624ms 4s693ms 3s839ms 4s160ms 1m12s 01 12 0ms 4s208ms 2s116ms 3s863ms 4s209ms 4s796ms 02 12 0ms 4s328ms 2s146ms 4s101ms 4s325ms 4s688ms 03 13 0ms 3s988ms 1s612ms 1s56ms 3s829ms 4s668ms 04 12 0ms 4s144ms 2s37ms 3s498ms 4s112ms 4s665ms 05 17 0ms 9m20s 1m7s 4s282ms 2m29s 9m20s 06 18 0ms 9s99ms 3s100ms 3s979ms 4s523ms 29s375ms 07 126 0ms 13m19s 15s949ms 1m7s 4m20s 13m23s 08 515 0ms 5m57s 5s625ms 3m46s 6m1s 6m47s 09 881 150ms 12m44s 2s987ms 1m9s 5m38s 12m48s 10 717 150ms 9m59s 3s589ms 1m7s 5m40s 10m16s 11 677 150ms 9m36s 4s454ms 1m41s 6m51s 9m39s 12 254 0ms 9m8s 5s235ms 40s634ms 1m25s 9m57s 13 456 0ms 6m52s 2s811ms 40s525ms 1m4s 7m14s 14 648 150ms 8m59s 3s980ms 58s957ms 5m20s 9m45s 15 609 150ms 8m32s 3s748ms 1m21s 4m38s 8m38s 16 671 150ms 8m22s 2s182ms 32s885ms 1m21s 8m50s 17 653 0ms 7m5s 3s428ms 1m18s 3m48s 8m8s 18 36 0ms 7m23s 21s342ms 6s151ms 54s860ms 7m23s 19 24 0ms 5m46s 26s50ms 6s213ms 44s961ms 5m46s 20 123 0ms 6m30s 9s927ms 59s842ms 2m1s 6m30s 21 32 0ms 6m1s 20s806ms 6s517ms 7s347ms 6m48s 22 30 0ms 5m43s 21s563ms 6s924ms 46s487ms 5m43s 23 333 0ms 1m24s 6s197ms 1m4s 1m11s 1m51s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 10 00 4 0 1s681ms 0ms 0ms 154ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 190ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 3 0 1s994ms 0ms 0ms 0ms 07 80 0 21s840ms 3s52ms 32s684ms 7m21s 08 378 0 6s71ms 25s536ms 3m37s 5m39s 09 698 0 3s260ms 16s667ms 38s344ms 7m59s 10 537 0 3s699ms 17s989ms 48s837ms 6m21s 11 534 0 4s686ms 25s172ms 1m13s 7m50s 12 121 0 9s236ms 4s356ms 21s300ms 4m26s 13 283 0 3s646ms 7s452ms 16s422ms 4m30s 14 443 0 4s750ms 18s26ms 33s110ms 6m46s 15 482 0 4s29ms 16s876ms 1m17s 5m1s 16 491 0 2s453ms 9s924ms 15s810ms 4m1s 17 436 0 3s522ms 17s767ms 51s787ms 3m57s 18 15 0 48s103ms 0ms 2s583ms 3m32s 19 6 0 1m36s 0ms 0ms 3m9s 20 18 86 11s217ms 4s257ms 59s842ms 3m18s 21 9 0 1m7s 0ms 0ms 3m17s 22 6 0 1m37s 0ms 0ms 3m17s 23 8 325 6s197ms 1m 1m4s 1m50s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 10 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 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 Aug 10 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 12 12.00 0.00% 08 0 20 20.00 0.00% 09 0 13 13.00 0.00% 10 0 17 17.00 0.00% 11 0 19 19.00 0.00% 12 0 6 6.00 0.00% 13 0 12 12.00 0.00% 14 0 14 14.00 0.00% 15 0 12 12.00 0.00% 16 0 15 15.00 0.00% 17 0 8 8.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 2 2.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Aug 10 00 15 0.00/s 01 7 0.00/s 02 8 0.00/s 03 13 0.00/s 04 8 0.00/s 05 9 0.00/s 06 15 0.00/s 07 18 0.01/s 08 26 0.01/s 09 21 0.01/s 10 22 0.01/s 11 32 0.01/s 12 12 0.00/s 13 20 0.01/s 14 23 0.01/s 15 18 0.01/s 16 18 0.01/s 17 22 0.01/s 18 9 0.00/s 19 11 0.00/s 20 16 0.00/s 21 12 0.00/s 22 10 0.00/s 23 16 0.00/s Day Hour Count Average Duration Average idle time Aug 10 00 4 50m8s 49m43s 01 14 1h1m4s 1h1m3s 02 7 1h25s 1h22s 03 13 24m43s 24m41s 04 7 1h3m 1h2m56s 05 7 59m 56m17s 06 9 57m13s 57m7s 07 16 54m17s 52m11s 08 19 55m6s 52m34s 09 25 55m57s 54m12s 10 23 51m28s 49m36s 11 32 37m19s 35m44s 12 17 58m46s 57m28s 13 13 1h59s 59m21s 14 23 52m59s 51m7s 15 19 57m40s 55m40s 16 19 57m 55m42s 17 20 54m3s 52m11s 18 18 57m33s 56m50s 19 9 54m27s 53m17s 20 13 47m3s 45m29s 21 11 1h33s 59m32s 22 11 1h30s 59m32s 23 16 39m51s 37m42s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-08-10 09:28:05 Date
Connections per database
Key values
- rio Main Database
- 381 connections Total
Connections per user
Key values
- intelifix Main User
- 381 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-08-10 11:23:25 Date
Histogram of session times
Key values
- 296 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 365 sessions Total
Sessions per user
Key values
- intelifix Main User
- 365 sessions Total
Sessions per host
Key values
- [local] Main Host
- 365 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 365 sessions Total
Application Count Total Duration Average Duration [unknown] 321 12d7h47m18s 55m17s pgAdmin 4 - CONN:6048339 2 2m30s 1m15s pgAdmin 4 - CONN:6213491 2 9s446ms 4s723ms pgAdmin 4 - CONN:7526495 3 13s273ms 4s424ms pgAdmin 4 - DB:brasilia 1 13s543ms 13s543ms pgAdmin 4 - DB:contagem 1 1m53s 1m53s pgAdmin 4 - DB:postgres 1 2m35s 2m35s pgAdmin 4 - DB:rio 1 17s655ms 17s655ms pg_dump 9 43m10s 4m47s postgres_fdw 1 34m59s 34m59s psql 23 23h27m2s 1h1m10s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 15,779 buffers Checkpoint Peak
- 2026-08-10 14:49:40 Date
- 270.006 seconds Highest write time
- 0.184 seconds Sync time
Checkpoints Wal files
Key values
- 12 files Wal files usage Peak
- 2026-08-10 08:59:38 Date
Checkpoints distance
Key values
- 376.76 Mo Distance Peak
- 2026-08-10 08:59:38 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 10 00 6,874 269.538s 0.007s 269.566s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 8,889 0.433s 0.006s 0.459s 04 0 0s 0s 0s 05 6,295 631.105s 0.044s 631.224s 06 2,727 269.297s 0.004s 269.32s 07 26,471 1,664.216s 0.26s 1,664.578s 08 56,028 3,028.597s 0.708s 3,029.599s 09 67,299 3,238.517s 0.956s 3,239.693s 10 64,714 3,191.382s 0.93s 3,192.604s 11 70,726 3,238.556s 0.869s 3,239.684s 12 29,459 2,115.053s 0.469s 2,115.735s 13 25,540 2,352.167s 0.566s 2,352.95s 14 70,630 3,181.637s 0.731s 3,182.581s 15 58,764 3,238.61s 0.821s 3,239.639s 16 43,999 3,214.514s 0.982s 3,215.764s 17 55,803 2,806.404s 0.731s 2,807.368s 18 3,447 346.775s 0.177s 346.994s 19 42 4.271s 0.008s 4.3s 20 1,297 243.382s 0.02s 243.43s 21 3,047 305.62s 0.168s 305.867s 22 2,138 214.609s 0.052s 214.724s 23 387 38.912s 0.071s 39.016s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 10 00 0 0 2 34 0.003s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 3 27 0.002s 0.002s 04 0 0 0 0 0s 0s 05 0 0 2 135 0.007s 0.006s 06 0 0 1 10 0.001s 0.001s 07 0 0 12 2,345 0.062s 0.011s 08 0 0 40 5,215 0.062s 0.012s 09 0 0 31 7,875 0.062s 0.012s 10 0 0 36 7,719 0.062s 0.012s 11 0 0 43 7,221 0.010s 0.012s 12 0 0 17 4,155 0.064s 0.012s 13 0 0 14 5,749 0.037s 0.012s 14 0 0 40 7,309 0.030s 0.012s 15 0 0 35 7,264 0.060s 0.012s 16 0 0 24 7,127 0.062s 0.012s 17 0 0 56 6,649 0.059s 0.012s 18 0 0 3 690 0.063s 0.006s 19 0 0 0 12 0.003s 0.004s 20 0 0 1 83 0.003s 0.003s 21 0 0 1 433 0.063s 0.008s 22 0 0 1 414 0.022s 0.007s 23 0 0 0 35 0.063s 0.011s Day Hour Count Avg time (sec) Aug 10 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 Aug 10 00 34,508.00 kB 34,508.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 24,477.50 kB 24,477.50 kB 04 0.00 kB 0.00 kB 05 6,925.83 kB 10,176.83 kB 06 7,635.00 kB 11,265.00 kB 07 18,541.82 kB 38,794.27 kB 08 54,055.33 kB 88,444.75 kB 09 42,948.00 kB 124,871.33 kB 10 48,930.33 kB 83,770.17 kB 11 59,242.17 kB 81,536.75 kB 12 22,099.50 kB 92,742.92 kB 13 19,732.00 kB 41,735.83 kB 14 54,156.17 kB 92,433.67 kB 15 47,769.92 kB 93,360.67 kB 16 32,814.50 kB 72,905.17 kB 17 77,229.67 kB 111,596.00 kB 18 9,555.60 kB 105,987.20 kB 19 81.33 kB 69,252.00 kB 20 4,705.00 kB 51,685.67 kB 21 2,034.75 kB 30,378.62 kB 22 1,664.71 kB 14,777.71 kB 23 139.00 kB 8,190.00 kB -
Temporary Files
Size of temporary files
Key values
- 479.14 MiB Temp Files size Peak
- 2026-08-10 05:31:56 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-10 05:31:56 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 10 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.09 GiB 111.38 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 930.87 MiB 71.46 MiB 239.57 MiB 116.36 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-10 05:32:05 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-10 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 182.94 MiB 91.47 MiB 91.47 MiB 91.47 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-10 05:30:41 Duration: 38s986ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-10 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 239.57 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-10 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 239.57 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-10 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 91.47 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-10 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 91.47 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-10 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 79.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-10 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 79.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-10 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 79.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-10 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 71.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-10 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 71.46 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-10 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 71.46 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-10 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 7.13 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-10 11:25:51 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 7.13 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-10 11:25:51 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (127) Main table analyzed (database rio)
- 1,109 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 127 rio.pg_catalog.pg_class 66 rio.pg_catalog.pg_type 57 rio.public.temp0000287937 54 contagem.pg_catalog.pg_attribute 53 brasilia.pg_catalog.pg_attribute 53 rio.public.usuarios 49 rio.pg_catalog.pg_index 38 rio.public.temp0000287863 36 rio.pg_catalog.pg_depend 29 contagem.pg_catalog.pg_class 26 brasilia.pg_catalog.pg_class 26 contagem.public.usuarios 24 contagem.pg_catalog.pg_type 22 brasilia.pg_catalog.pg_type 21 rio.public.temp0000287897 21 rio.public.temp0000287388 20 rio.public.temp0000287889 17 rio.public.temp0000287969 16 contagem.public.temp0000226764 16 brasilia.public.temp0000237848 16 rio.public.temp0000287312 15 brasilia.public.temp0000237850 15 contagem.pg_catalog.pg_index 14 rio.public.temp0000287865 14 brasilia.public.temp0000237806 14 brasilia.pg_catalog.pg_index 12 rio.public.temp0000287895 11 rio.public.temp0000287984 11 contagem.pg_catalog.pg_depend 10 rio.public.temp0000287821 10 rio.public.temp0000287923 10 contagem.public.temp0000226788 10 brasilia.pg_catalog.pg_depend 9 brasilia.public.usuarios 9 rio.public.temp0000287949 8 rio.public.temp0000287931 7 rio.public.temp0000287933 7 contagem.public.temp0000226802 6 rio.public.temp0000287406 5 rio.public.temp0000287877 5 rio.pg_catalog.pg_shdepend 5 rio.public.tmp_drill_0320 5 rio.public.temp0000287861 5 brasilia.public.temp0000237854 5 brasilia.pg_catalog.pg_shdepend 4 brasilia.public.temp0000237808 4 rio.public.temp0000287869 4 contagem.public.temp0000226804 4 rio.public.tmp_drill_0175 4 rio.public.temp0000287871 4 brasilia.public.temp0000237830 3 postgres.pg_catalog.pg_shdepend 3 brasilia.public.temp0000237842 3 contagem.public.temp0000226806 3 contagem.public.temp0000226808 3 rio.public.temp0000287945 3 brasilia.public.temp0000237814 3 brasilia.public.temp0000237874 3 rio.public.temp0000287853 3 rio.public.temp0000287907 2 rio.public.temp0000287971 2 brasilia.public.temp0000237882 2 brasilia.public.temp0000237820 2 brasilia.public.temp0000237832 2 brasilia.public.temp0000237828 2 brasilia.public.temp0000237802 2 contagem.pg_catalog.pg_shdepend 2 brasilia.public.temp0000237866 2 brasilia.public.temp0000237858 2 contagem.public.temp0000226800 2 rio.public.temp0000287951 1 rio.public.temp0000287982 1 contagem.public.temp0000226798 1 contagem.public.temp0000226810 1 brasilia.public.temp0000237846 1 brasilia.public.temp0000237860 1 rio.public.temp0000287955 1 rio.public.temp0000287939 1 rio.public.temp0000287881 1 template1.pg_catalog.pg_shdepend 1 brasilia.public.temp0000237824 1 brasilia.public.temp0000237804 1 rio.public.temp0000287919 1 rio.public.temp0000287913 1 rio.public.temp0000287883 1 brasilia.public.temp0000237838 1 brasilia.public.temp0000237880 1 brasilia.public.temp0000237856 1 brasilia.public.temp0000237870 1 rio.public.temp0000287875 1 contagem.public.parametros 1 contagem.public.nf_entrada 1 contagem.auditor.auditor_2026_08 1 rio.public.temp0000287885 1 brasilia.public.temp0000237810 1 brasilia.auditor.auditor_2026_08 1 rio.auditor.auditor_2026_08 1 Total 1,109 Vacuums per table
Key values
- pg_catalog.pg_attribute (60) Main table vacuumed on database rio
- 533 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 60 48 0 0 0 0 0 26,246 6,836 10,466,369 386 9,481 rio.pg_catalog.pg_class 39 29 0 0 0 0 0 5,705 1,862 2,884,759 98 354 rio.public.temp0000287863 37 0 0 0 0 0 0 31,800 291 2,159,077 0 0 rio.pg_catalog.pg_type 34 25 0 0 0 0 0 2,345 648 892,778 65 200 rio.public.temp0000287937 27 0 0 0 0 0 0 7,172 605 1,298,260 0 0 contagem.public.usuarios 24 0 0 0 0 0 0 95 68 46,162 2 2 rio.public.temp0000287897 21 0 0 0 0 0 0 20,609 1,787 3,433,791 0 0 contagem.pg_catalog.pg_attribute 18 18 0 0 0 0 0 10,112 2,755 4,891,602 40 964 rio.public.tmp_drill_0175 16 3 0 0 0 0 0 534 77 148,442 1 77 rio.pg_catalog.pg_index 15 15 0 0 0 0 0 957 312 306,124 64 152 rio.public.temp0000287969 15 0 0 0 0 0 0 14,171 1,949 3,364,668 0 0 rio.pg_catalog.pg_depend 14 14 0 0 0 0 0 4,034 1,427 2,123,568 72 754 brasilia.pg_catalog.pg_attribute 14 14 0 0 0 0 0 6,805 1,817 2,998,104 60 1,643 rio.public.temp0000287388 14 0 0 0 0 0 0 810 262 387,364 0 0 rio.public.temp0000287312 12 0 0 0 0 0 0 448 65 35,897 0 0 brasilia.public.temp0000237848 12 0 0 0 0 0 0 2,738 71 175,314 0 0 rio.public.usuarios 11 4 0 0 0 0 0 135 45 87,758 3 5 rio.public.temp0000287984 10 0 0 0 0 0 0 17,163 5,179 7,643,872 0 0 contagem.pg_catalog.pg_class 8 8 0 0 0 0 0 1,409 314 509,042 12 37 rio.pg_catalog.pg_statistic 8 8 0 0 0 0 0 10,555 2,403 10,880,833 1,011 4,210 rio.public.temp0000287949 8 0 0 0 0 0 0 10,298 30 612,276 0 0 contagem.pg_catalog.pg_type 8 8 0 0 0 0 0 759 216 337,925 7 14 rio.public.temp0000287821 7 0 0 0 0 0 0 413 41 30,355 0 0 brasilia.pg_catalog.pg_class 7 7 0 0 0 0 0 1,181 504 777,308 33 109 brasilia.pg_catalog.pg_type 6 6 0 0 0 0 0 507 198 248,530 18 46 rio.public.tmp_drill_0320 5 5 0 0 0 0 0 2,935 48 535,408 0 0 contagem.pg_catalog.pg_index 5 5 0 0 0 0 0 253 79 87,011 6 9 contagem.pg_catalog.pg_depend 5 5 0 0 0 0 0 1,329 334 717,039 9 42 rio.public.temp0000287869 4 0 0 0 0 0 0 3,442 1,728 2,412,975 0 0 brasilia.pg_catalog.pg_statistic 4 4 0 0 0 0 0 4,596 712 2,938,194 385 2,643 contagem.public.temp0000226802 4 0 0 0 0 0 0 305 24 21,567 0 0 brasilia.pg_catalog.pg_index 4 4 0 0 0 0 0 294 104 69,269 21 24 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,978 437 2,383,408 114 324 rio.public.temp0000287871 4 0 0 0 0 0 0 24 16 4,087 0 0 contagem.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 544 155 280,956 30 71 postgres.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 405 98 208,700 14 40 brasilia.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 379 87 437,148 28 93 rio.public.temp0000287945 3 0 0 0 0 0 0 3,513 14 209,379 0 0 rio.public.temp0000287877 3 0 0 0 0 0 0 83 16 7,311 0 0 brasilia.public.temp0000237814 3 0 0 0 0 0 0 746 18 47,452 0 0 rio.public.temp0000287889 3 0 0 0 0 0 0 105 18 8,599 0 0 rio.public.temp0000287895 2 0 0 0 0 0 0 132 12 9,530 0 0 rio.public.temp0000287406 2 0 0 0 0 0 0 217 113 191,585 0 0 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 299 68 285,743 30 75 brasilia.pg_catalog.pg_depend 2 2 0 0 0 0 0 677 259 298,825 12 114 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,801 264 1,102,751 190 1,556 brasilia.public.temp0000237866 1 0 0 0 0 0 0 248 6 15,780 0 0 rio.public.temp0000287955 1 0 0 0 0 0 0 83 6 5,804 0 0 rio.public.temp0000287881 1 0 0 0 0 0 0 8 5 1,260 0 0 rio.public.temp0000287875 1 0 0 0 0 0 0 82 6 5,744 0 0 contagem.auditor.auditor_2026_08 1 0 0 0 0 0 0 6,818 5,987 8,191,754 362 6,192 contagem.public.temp0000226788 1 0 0 0 0 0 0 109 6 7,390 0 0 brasilia.auditor.auditor_2026_08 1 0 0 0 0 0 0 7,704 6,430 8,844,344 703 11,839 rio.public.temp0000287919 1 0 0 0 0 0 0 4 3 774 0 0 contagem.public.temp0000226800 1 0 0 0 0 0 0 43 6 3,362 0 0 contagem.public.fluxos 1 1 0 0 0 0 0 7,602 4,359 12,647,878 178 8,639 rio.auditor.auditor_2026_08 1 0 0 0 0 0 0 54,530 20,954 28,652,346 16,743 353,191 brasilia.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 132 27 57,249 0 0 rio.public.temp0000287951 1 0 0 0 0 0 0 82 6 5,741 0 0 rio.public.temp0000287982 1 0 0 0 0 0 0 87 6 6,048 0 0 contagem.public.temp0000226810 1 0 0 0 0 0 0 8 5 1,215 0 0 rio.public.equipamentos_referencia 1 0 0 0 0 0 0 383 366 1,237,959 11 1,989 brasilia.public.temp0000237880 1 0 0 0 0 0 0 248 6 15,780 0 0 Total 533 252 0 0 0 0 0 280,229 72,550 128,697,543 20,708 404,889 Vacuum throughput per table
Key values
- public.usuarios (14.9) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 3.8 rio.pg_catalog.pg_class 0 0 0.94 rio.public.temp0000287863 0 0 1.07 rio.pg_catalog.pg_type 0 0 0.39 rio.public.temp0000287937 0 0 0.58 contagem.public.usuarios 0 0 0 rio.public.temp0000287897 0 0 1.06 contagem.pg_catalog.pg_attribute 0 0 1.65 rio.public.tmp_drill_0175 0 0 0.03 rio.pg_catalog.pg_index 0 0 0.21 rio.public.temp0000287969 0 0 0.58 rio.pg_catalog.pg_depend 0 0 0.96 brasilia.pg_catalog.pg_attribute 0 0 1.32 rio.public.temp0000287388 0 0 0.17 rio.public.temp0000287312 0 0 0.2 brasilia.public.temp0000237848 0 0 0.23 rio.public.usuarios 0 0 14.9 rio.public.temp0000287984 0 0 0.57 contagem.pg_catalog.pg_class 0 0 0.34 rio.pg_catalog.pg_statistic 0 0 1.19 rio.public.temp0000287949 0 0 0.39 contagem.pg_catalog.pg_type 0 0 0.2 rio.public.temp0000287821 0 0 0.09 brasilia.pg_catalog.pg_class 0 0 0.7 brasilia.pg_catalog.pg_type 0 0 0.25 rio.public.tmp_drill_0320 0 0 0.1 contagem.pg_catalog.pg_index 0 0 0.05 contagem.pg_catalog.pg_depend 0 0 0.3 rio.public.temp0000287869 0 0 0.19 brasilia.pg_catalog.pg_statistic 0 0 0.42 contagem.public.temp0000226802 0 0 0.05 brasilia.pg_catalog.pg_index 0 0 0.07 rio.pg_toast.pg_toast_2619 0 0 0.24 rio.public.temp0000287871 0 0 0.02 contagem.pg_catalog.pg_shdepend 0 0 0.09 postgres.pg_catalog.pg_shdepend 0 0 0.19 brasilia.pg_toast.pg_toast_2619 0 0 0.04 rio.public.temp0000287945 0 0 0.12 rio.public.temp0000287877 0 0 0.04 brasilia.public.temp0000237814 0 0 0.05 rio.public.temp0000287889 0 0 0.02 rio.public.temp0000287895 0 0 0.02 rio.public.temp0000287406 0 0 0.03 contagem.pg_toast.pg_toast_2619 0 0 0.01 brasilia.pg_catalog.pg_depend 0 0 0.34 contagem.pg_catalog.pg_statistic 0 0 0.2 brasilia.public.temp0000237866 0 0 0.02 rio.public.temp0000287955 0 0 0.01 rio.public.temp0000287881 0 0 0 rio.public.temp0000287875 0 0 0.02 contagem.auditor.auditor_2026_08 0 0 2.1 contagem.public.temp0000226788 0 0 0.01 brasilia.auditor.auditor_2026_08 0 0 2.3 rio.public.temp0000287919 0 0 0.05 contagem.public.temp0000226800 0 0 0.02 contagem.public.fluxos 0 0 2.8 rio.auditor.auditor_2026_08 0 0 7.13 brasilia.pg_catalog.pg_shdepend 0 0 0.03 rio.public.temp0000287951 0 0 0.02 rio.public.temp0000287982 0 0 0.01 contagem.public.temp0000226810 0 0 0.01 rio.public.equipamentos_referencia 0 0 0.17 brasilia.public.temp0000237880 0 0 0.02 Total 0 0 49.13 Tuples removed per table
Key values
- pg_catalog.pg_attribute (211414) Main table with removed tuples on database rio
- 466478 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 60 48 211,414 1,516,320 126,950 491 36,310 contagem.pg_catalog.pg_attribute 18 18 67,226 431,027 0 114 9,704 brasilia.pg_catalog.pg_attribute 14 14 47,233 317,342 0 60 7,663 rio.public.tmp_drill_0320 5 5 43,391 44,167 0 0 1,113 rio.pg_catalog.pg_statistic 8 8 14,720 66,698 0 0 10,288 rio.pg_catalog.pg_depend 14 14 11,001 268,865 2,292 0 2,618 rio.pg_catalog.pg_type 34 25 9,703 86,424 8,720 24 2,468 brasilia.pg_catalog.pg_statistic 4 4 7,553 33,084 204 0 4,288 rio.public.tmp_drill_0175 16 3 5,916 50,945 21,547 0 746 contagem.pg_catalog.pg_statistic 2 2 5,418 14,902 0 0 2,022 contagem.pg_catalog.pg_depend 5 5 4,959 94,359 0 0 880 rio.pg_catalog.pg_index 15 15 4,611 29,053 116 0 857 contagem.pg_catalog.pg_shdepend 4 4 3,648 54,442 0 0 476 contagem.pg_catalog.pg_class 8 8 3,446 27,750 0 3 976 rio.pg_catalog.pg_class 39 29 3,315 156,829 22,398 83 5,105 rio.auditor.auditor_2026_08 1 0 3,026 4,835,625 0 0 230,801 postgres.pg_catalog.pg_shdepend 3 3 2,717 40,694 0 0 357 contagem.pg_catalog.pg_type 8 8 2,509 18,028 0 0 543 contagem.public.fluxos 1 1 2,411 452,669 0 0 5,562 brasilia.pg_catalog.pg_depend 2 2 2,276 35,373 0 14 354 brasilia.auditor.auditor_2026_08 1 0 1,425 1,318,033 0 0 55,855 contagem.public.usuarios 24 0 1,392 576 0 0 48 brasilia.pg_catalog.pg_class 7 7 1,381 23,734 0 0 728 contagem.pg_catalog.pg_index 5 5 1,285 9,497 0 0 260 brasilia.pg_catalog.pg_type 6 6 1,117 13,316 0 8 384 rio.pg_toast.pg_toast_2619 4 4 1,104 2,574 4 0 1,056 brasilia.pg_catalog.pg_index 4 4 871 7,520 0 0 236 brasilia.pg_catalog.pg_shdepend 1 1 766 13,582 0 0 119 rio.public.usuarios 11 4 242 7,714 2,115 0 187 brasilia.pg_toast.pg_toast_2619 3 3 187 398 0 26 119 contagem.pg_toast.pg_toast_2619 2 2 169 222 0 0 102 rio.public.equipamentos_referencia 1 0 46 5,285,248 0 0 28,571 brasilia.public.temp0000237866 1 0 0 3,196 0 16 240 rio.public.temp0000287869 4 0 0 73,663 0 6 5,242 rio.public.temp0000287895 2 0 0 2,250 0 12 116 rio.public.temp0000287897 21 0 0 507,489 0 0 36,288 rio.public.temp0000287955 1 0 0 1,440 0 53 75 rio.public.temp0000287312 12 0 0 27,672 0 314 614 rio.public.temp0000287881 1 0 0 1,123 0 6 58 rio.public.temp0000287875 1 0 0 1,401 0 54 74 rio.public.temp0000287821 7 0 0 18,928 0 308 428 contagem.auditor.auditor_2026_08 1 0 0 1,098,951 0 0 45,533 contagem.public.temp0000226802 4 0 0 4,783 0 113 271 contagem.public.temp0000226788 1 0 0 1,318 0 27 101 rio.public.temp0000287919 1 0 0 24,162 0 0 1,728 rio.public.temp0000287388 14 0 0 43,430 0 361 983 contagem.public.temp0000226800 1 0 0 1,074 0 29 35 rio.public.temp0000287984 10 0 0 241,906 0 0 17,280 rio.public.temp0000287406 2 0 0 8,850 0 55 201 rio.public.temp0000287937 27 0 0 188,605 0 760 10,568 rio.public.temp0000287951 1 0 0 1,411 0 54 74 rio.public.temp0000287982 1 0 0 1,513 0 49 79 brasilia.public.temp0000237848 12 0 0 38,352 0 192 2,880 rio.public.temp0000287969 15 0 0 232,898 0 223 16,033 rio.public.temp0000287945 3 0 0 49,761 0 54 3,530 rio.public.temp0000287877 3 0 0 7,390 0 89 167 contagem.public.temp0000226810 1 0 0 1,012 0 29 35 rio.public.temp0000287871 4 0 0 4,823 0 66 254 brasilia.public.temp0000237814 3 0 0 9,588 0 48 720 rio.public.temp0000287949 8 0 0 193,403 0 0 13,824 rio.public.temp0000287863 37 0 0 480,976 0 379 33,989 brasilia.public.temp0000237880 1 0 0 3,196 0 16 240 rio.public.temp0000287889 3 0 0 3,632 0 15 81 Total 533 252 466,478 18,535,206 184,346 4,151 602,537 Pages removed per table
Key values
- public.temp0000287937 (760) Main table with removed pages on database rio
- 4151 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000287937 27 0 0 760 rio.pg_catalog.pg_attribute 60 48 211414 491 rio.public.temp0000287863 37 0 0 379 rio.public.temp0000287388 14 0 0 361 rio.public.temp0000287312 12 0 0 314 rio.public.temp0000287821 7 0 0 308 rio.public.temp0000287969 15 0 0 223 brasilia.public.temp0000237848 12 0 0 192 contagem.pg_catalog.pg_attribute 18 18 67226 114 contagem.public.temp0000226802 4 0 0 113 rio.public.temp0000287877 3 0 0 89 rio.pg_catalog.pg_class 39 29 3315 83 rio.public.temp0000287871 4 0 0 66 brasilia.pg_catalog.pg_attribute 14 14 47233 60 rio.public.temp0000287406 2 0 0 55 rio.public.temp0000287875 1 0 0 54 rio.public.temp0000287951 1 0 0 54 rio.public.temp0000287945 3 0 0 54 rio.public.temp0000287955 1 0 0 53 rio.public.temp0000287982 1 0 0 49 brasilia.public.temp0000237814 3 0 0 48 contagem.public.temp0000226800 1 0 0 29 contagem.public.temp0000226810 1 0 0 29 contagem.public.temp0000226788 1 0 0 27 brasilia.pg_toast.pg_toast_2619 3 3 187 26 rio.pg_catalog.pg_type 34 25 9703 24 brasilia.public.temp0000237866 1 0 0 16 brasilia.public.temp0000237880 1 0 0 16 rio.public.temp0000287889 3 0 0 15 brasilia.pg_catalog.pg_depend 2 2 2276 14 rio.public.temp0000287895 2 0 0 12 brasilia.pg_catalog.pg_type 6 6 1117 8 rio.public.temp0000287869 4 0 0 6 rio.public.temp0000287881 1 0 0 6 contagem.pg_catalog.pg_class 8 8 3446 3 rio.public.tmp_drill_0320 5 5 43391 0 rio.public.temp0000287897 21 0 0 0 brasilia.pg_catalog.pg_statistic 4 4 7553 0 rio.pg_catalog.pg_depend 14 14 11001 0 postgres.pg_catalog.pg_shdepend 3 3 2717 0 contagem.auditor.auditor_2026_08 1 0 0 0 brasilia.pg_catalog.pg_class 7 7 1381 0 brasilia.pg_catalog.pg_index 4 4 871 0 brasilia.auditor.auditor_2026_08 1 0 1425 0 rio.public.temp0000287919 1 0 0 0 rio.public.usuarios 11 4 242 0 contagem.public.fluxos 1 1 2411 0 rio.auditor.auditor_2026_08 1 0 3026 0 rio.public.temp0000287984 10 0 0 0 contagem.public.usuarios 24 0 1392 0 brasilia.pg_catalog.pg_shdepend 1 1 766 0 rio.pg_catalog.pg_index 15 15 4611 0 rio.pg_toast.pg_toast_2619 4 4 1104 0 contagem.pg_toast.pg_toast_2619 2 2 169 0 rio.public.tmp_drill_0175 16 3 5916 0 rio.pg_catalog.pg_statistic 8 8 14720 0 rio.public.temp0000287949 8 0 0 0 contagem.pg_catalog.pg_type 8 8 2509 0 contagem.pg_catalog.pg_index 5 5 1285 0 rio.public.equipamentos_referencia 1 0 46 0 contagem.pg_catalog.pg_depend 5 5 4959 0 contagem.pg_catalog.pg_statistic 2 2 5418 0 contagem.pg_catalog.pg_shdepend 4 4 3648 0 Total 533 252 466,478 4,151 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 10 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 8 19 08 35 91 09 77 132 10 64 143 11 46 108 12 41 62 13 37 96 14 60 117 15 46 107 16 37 103 17 71 127 18 1 1 19 0 0 20 0 0 21 4 3 22 0 0 23 0 0 - 7.13 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 6 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 4 5m34s 21s660ms 2m13s 1m23s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-10 10:27:28 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-10 08:56:53 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-10 08:26:38 Database: rio User: intelifix Remote: [local] Application: psql
2 1 59s404ms 59s404ms 59s404ms 59s404ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (275749, 433, 'CP23213216A,D4925EAC04B9,544D4242006A89D2,D4925EAC04BC', '',0298,00,'[{"item":"0","qrcode":""}]','$$$$$$$','', 00);
Date: 2026-08-10 08:56:52 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276051, 404, 'CP2204LV55S,1C9D726AC8C4$CP2239LVLVM,B85E71BCC078$CP2051LV489,484BD4A60034$CP2523LV3KQ,B85E710E77D8$CP2248LV4BJ,B85E71E25B08$CP2147LV7EF,D4E2CB923024$CP2141LV36E,ECA81FF73C2C$CP2528LV4ZY,F8D2AC4B9B00$CP2239LV4E1,4075C3BF1F70$CP2125LV6BZ,08A7C071E5A4$CP2204LV589,1C9D726A156C$CP2115LV2AU,08A7C069542C$CP2226LV0RT,80DAC2CE8D20$CP2425LV38V,C4509CAB29C4$CP2143LV0HG,ECA81FFCA1C4$CP2431LV3UK,C4509CBF26D4$CP2530LV1DR,3C82C08B8B60$CP2147LV0N1,D4E2CB916A3C$CP2243LV5H1,B85E71D147C8$CP2143LV6AV,1C9ECC8D1354$CP2523LV13A,B85E710E8304$CP2248LV4TK,B85E71DA8874$CP2226LV995,80DAC2CF5570$CP2347LVAGG,400FC18371DC$CP2205LV2RE,1C9D7282C374$CP2114LV234,08A7C04F14E4$CP2302LVAUH,B85E71E91D6C$CP2243LV368,B85E71CFD8E8$CP2239LVP7Y,B85E71BEE0D8$CP2243LVAQB,B85E71D2A848$CP2134LV76C,ECA81F23C4D4$CP2104LV2AR,484BD4ACA714$CP2128LV6DM,08A7C07A0264$CP2048LV7TW,484BD4A13E94', '',0185,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-10 14:44:10 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (275457, 404, '732257053156,B4F267402426,B4F2673FA050,6802B8F93304,B4F2673F91C2,B4F26721A685,B4F26740383C,B4F267369790,B4F2673FD854,B4F267404C7C,B4F2673642A6,B4F2673FA041,B4F26721915B,B4F267402BD0,B4F26737D407,B4F2673F6AEF,B4F2673641E6,B4F26740298D,B4F2676C114C,B4F2676C1491,B4F26760939E,B4F267149530,B4F267405DA1,B4F2673E99E2,B4F2673FF891,B4F267606D9D,B4F2673FF918,B4F26758D1D5,B4F26758ED8C,B4F2674016E5,B4F2673FF90C,B4F267404EC5,B4F267606BA2,6802B8FEA95E,6802B8FEA901,6802B8F934BA,B4F2673FD88A', '',0300,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-10 09:28:59 Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1 1s5ms 1s5ms 1s5ms 1s5ms drop table if exists temp0000287863;-
DROP TABLE IF EXISTS temp0000287863;
Date: 2026-08-10 09:28:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000287863;
Date: 2026-08-10 10:20:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000287863;
Date: 2026-08-10 09:28:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 2m13s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-10 10:27:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1m38s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-10 08:56:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 1m20s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-10 08:26:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 59s404ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (275749, 433, 'CP23213216A,D4925EAC04B9,544D4242006A89D2,D4925EAC04BC', '',0298,00,'[{"item":"0","qrcode":""}]','$$$$$$$','', 00);[ Date: 2026-08-10 08:56:52 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 21s660ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-10 11:55:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 1s5ms DROP TABLE IF EXISTS temp0000287863;[ Date: 2026-08-10 09:28:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,553 Total read queries
- 1,829 Total write queries
Queries by database
Key values
- rio Main database
- 4,360 Requests
- 6h40m36s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,730 Requests
User Request type Count Duration etiquetas Total 57 12s885ms select 57 12s885ms intelifix Total 6,730 8h46m56s copy to 411 42m41s ddl 1,418 54m3s others 506 49m19s select 4,393 6h20m52s lenon Total 103 58s481ms select 103 58s481ms Duration by user
Key values
- 8h46m56s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 57 12s885ms select 57 12s885ms intelifix Total 6,730 8h46m56s copy to 411 42m41s ddl 1,418 54m3s others 506 49m19s select 4,393 6h20m52s lenon Total 103 58s481ms select 103 58s481ms Queries by host
Key values
- [local] Main host
- 6,890 Requests
- 8h48m8s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,759 Requests
- 4h34m12s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-10 17:43:06 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,465 100-500ms duration
Slowest individual queries
Rank Duration Query 1 13m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-10 07:18:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 12m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-10 09:17:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-10 10:15:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 9m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-10 11:14:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 9m20s analyze verbose;[ Date: 2026-08-10 05:09:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 9m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-10 12:14:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-10 14:14:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-10 15:13:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 8m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-10 16:13:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m53s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028207, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-10 09:38:14 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 7m39s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028215, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-10 11:25:09 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 7m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-10 18:12:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 7m20s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028197, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-10 07:42:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 7m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-10 17:12:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 6m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-10 13:11:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 6m43s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028228, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-10 14:34:05 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 6m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-10 20:11:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 6m16s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028209, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-10 10:27:24 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 6m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-10 21:11:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m57s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-10 08:10:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h19m24s 48 1s290ms 13m19s 2m54s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 10 07 3 14m4s 4m41s 08 3 6m17s 2m5s 09 3 13m28s 4m29s 10 3 10m36s 3m32s 11 3 10m12s 3m24s 12 3 9m37s 3m12s 13 3 7m14s 2m24s 14 3 9m31s 3m10s 15 3 9m2s 3m 16 3 8m54s 2m58s 17 3 7m25s 2m28s 18 3 7m45s 2m35s 19 3 6m3s 2m1s 20 3 6m50s 2m16s 21 3 6m19s 2m6s 22 3 6m 2m [ User: intelifix - Total duration: 2h19m24s - Times executed: 48 ]
[ Application: psql - Total duration: 2h19m24s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-10 07:18:21 Duration: 13m19s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-10 09:17:45 Duration: 12m44s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-10 10:15:01 Duration: 9m59s Database: rio User: intelifix Remote: [local] Application: psql
2 1h37m24s 355 151ms 7m53s 16s462ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 10 07 4 7m36s 1m54s 08 43 23m3s 32s163ms 09 55 9m14s 10s89ms 10 35 7m51s 13s482ms 11 28 17m4s 36s599ms 12 15 2m48s 11s231ms 13 23 41s597ms 1s808ms 14 29 13m40s 28s306ms 15 29 5m38s 11s685ms 16 24 51s536ms 2s147ms 17 68 8m48s 7s765ms 18 2 3s467ms 1s733ms [ User: intelifix - Total duration: 1h37m24s - Times executed: 355 ]
[ Application: [unknown] - Total duration: 1h37m24s - Times executed: 355 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028207, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-10 09:38:14 Duration: 7m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028215, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-10 11:25:09 Duration: 7m39s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028197, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-10 07:42:44 Duration: 7m20s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h18m25s 48 229ms 5m25s 1m38s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 10 07 3 6m8s 2m2s 08 3 4m7s 1m22s 09 3 6m38s 2m12s 10 3 6m36s 2m12s 11 3 5m47s 1m55s 12 3 5m5s 1m41s 13 3 5m4s 1m41s 14 3 5m31s 1m50s 15 3 4m51s 1m37s 16 3 4m39s 1m33s 17 3 4m24s 1m28s 18 3 4m5s 1m21s 19 3 3m38s 1m12s 20 3 4m11s 1m23s 21 3 3m47s 1m15s 22 3 3m47s 1m15s [ User: intelifix - Total duration: 1h18m25s - Times executed: 48 ]
[ Application: psql - Total duration: 1h18m25s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-10 10:22:06 Duration: 5m25s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-10 11:20:55 Duration: 4m57s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-10 09:25:01 Duration: 4m51s Database: brasilia User: intelifix Remote: [local] Application: psql
4 21m43s 1,529 150ms 59s786ms 852ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 10 07 19 13s394ms 704ms 08 80 2m8s 1s609ms 09 220 3m9s 859ms 10 178 2m15s 762ms 11 161 2m13s 829ms 12 53 37s552ms 708ms 13 77 54s589ms 708ms 14 175 2m46s 952ms 15 203 3m5s 913ms 16 253 3m23s 805ms 17 110 54s551ms 495ms [ User: intelifix - Total duration: 21m43s - Times executed: 1529 ]
[ Application: [unknown] - Total duration: 21m43s - Times executed: 1529 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (275749, 433, 'CP23213216A,D4925EAC04B9,544D4242006A89D2,D4925EAC04BC', '',0298,00,'[{"item":"0","qrcode":""}]','$$$$$$$','', 00);
Date: 2026-08-10 08:56:52 Duration: 59s786ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276051, 404, 'CP2204LV55S,1C9D726AC8C4$CP2239LVLVM,B85E71BCC078$CP2051LV489,484BD4A60034$CP2523LV3KQ,B85E710E77D8$CP2248LV4BJ,B85E71E25B08$CP2147LV7EF,D4E2CB923024$CP2141LV36E,ECA81FF73C2C$CP2528LV4ZY,F8D2AC4B9B00$CP2239LV4E1,4075C3BF1F70$CP2125LV6BZ,08A7C071E5A4$CP2204LV589,1C9D726A156C$CP2115LV2AU,08A7C069542C$CP2226LV0RT,80DAC2CE8D20$CP2425LV38V,C4509CAB29C4$CP2143LV0HG,ECA81FFCA1C4$CP2431LV3UK,C4509CBF26D4$CP2530LV1DR,3C82C08B8B60$CP2147LV0N1,D4E2CB916A3C$CP2243LV5H1,B85E71D147C8$CP2143LV6AV,1C9ECC8D1354$CP2523LV13A,B85E710E8304$CP2248LV4TK,B85E71DA8874$CP2226LV995,80DAC2CF5570$CP2347LVAGG,400FC18371DC$CP2205LV2RE,1C9D7282C374$CP2114LV234,08A7C04F14E4$CP2302LVAUH,B85E71E91D6C$CP2243LV368,B85E71CFD8E8$CP2239LVP7Y,B85E71BEE0D8$CP2243LVAQB,B85E71D2A848$CP2134LV76C,ECA81F23C4D4$CP2104LV2AR,484BD4ACA714$CP2128LV6DM,08A7C07A0264$CP2048LV7TW,484BD4A13E94', '',0185,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-10 14:44:10 Duration: 5s78ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (275457, 404, '732257053156,B4F267402426,B4F2673FA050,6802B8F93304,B4F2673F91C2,B4F26721A685,B4F26740383C,B4F267369790,B4F2673FD854,B4F267404C7C,B4F2673642A6,B4F2673FA041,B4F26721915B,B4F267402BD0,B4F26737D407,B4F2673F6AEF,B4F2673641E6,B4F26740298D,B4F2676C114C,B4F2676C1491,B4F26760939E,B4F267149530,B4F267405DA1,B4F2673E99E2,B4F2673FF891,B4F267606D9D,B4F2673FF918,B4F26758D1D5,B4F26758ED8C,B4F2674016E5,B4F2673FF90C,B4F267404EC5,B4F267606BA2,6802B8FEA95E,6802B8FEA901,6802B8F934BA,B4F2673FD88A', '',0300,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-10 09:28:59 Duration: 4s685ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 16m38s 275 201ms 2m19s 3s629ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 10 00 12 40s796ms 3s399ms 01 12 25s402ms 2s116ms 02 12 25s753ms 2s146ms 03 11 20s486ms 1s862ms 04 12 24s446ms 2s37ms 05 12 23s366ms 1s947ms 06 12 24s614ms 2s51ms 07 12 25s135ms 2s94ms 08 12 3m26s 17s182ms 09 12 35s952ms 2s996ms 10 12 2m46s 13s851ms 11 12 57s289ms 4s774ms 12 12 29s310ms 2s442ms 13 12 29s213ms 2s434ms 14 12 28s354ms 2s362ms 15 12 36s934ms 3s77ms 16 12 35s821ms 2s985ms 17 12 30s671ms 2s555ms 18 12 25s437ms 2s119ms 19 12 23s961ms 1s996ms 20 12 32s696ms 2s724ms 21 12 25s25ms 2s85ms 22 12 25s10ms 2s84ms [ User: intelifix - Total duration: 16m38s - Times executed: 275 ]
[ Application: psql - Total duration: 16m38s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-10 10:27:28 Duration: 2m19s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-10 08:56:53 Duration: 1m43s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-10 08:26:38 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
6 16m34s 3 2m29s 9m20s 5m31s analyze verbose;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 10 05 3 16m34s 5m31s [ User: intelifix - Total duration: 16m34s - Times executed: 3 ]
[ Application: psql - Total duration: 16m34s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-10 05:09:21 Duration: 9m20s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-10 05:14:05 Duration: 4m43s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-10 05:16:35 Duration: 2m29s Database: contagem User: intelifix Remote: [local] Application: psql
7 12m38s 69 978ms 3m40s 10s986ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 10 07 2 8s579ms 4s289ms 08 1 3s588ms 3s588ms 09 5 44s575ms 8s915ms 10 5 46s567ms 9s313ms 11 10 1m17s 7s772ms 12 1 2s902ms 2s902ms 13 8 1m9s 8s715ms 14 3 16s61ms 5s353ms 15 9 6m13s 41s534ms 16 5 38s504ms 7s700ms 17 18 1m10s 3s942ms 18 2 5s89ms 2s544ms [ User: intelifix - Total duration: 12m38s - Times executed: 69 ]
[ Application: [unknown] - Total duration: 12m38s - Times executed: 69 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-10', 099, '', '', 0, 6, '2026-01-01');
Date: 2026-08-10 15:35:07 Duration: 3m40s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-31', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-08-10 15:30:19 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-10', 0320, '', '', 0, 6, '2026-08-01');
Date: 2026-08-10 15:18:08 Duration: 24s962ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 12m35s 1,187 151ms 14s283ms 636ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 10 07 7 2s772ms 396ms 08 120 1m14s 620ms 09 197 2m9s 659ms 10 169 1m41s 600ms 11 182 2m35s 854ms 13 89 1m3s 708ms 14 116 1m8s 586ms 15 135 1m5s 483ms 16 113 1m 536ms 17 59 34s326ms 581ms [ User: intelifix - Total duration: 12m35s - Times executed: 1187 ]
[ Application: [unknown] - Total duration: 12m35s - Times executed: 1187 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243120", "modelo" : "263", "itens" : "229918628286,229912614647,229898101739,229912018090,229871470105,229899166174,229899314247,229899364555,229899371627,229899379708,229892794464,229892807899,229892814870,229892817092,229892818002,229892820303,229892822020,229892824242,229892825959,229915684453,229915717486,229896915977,229902158902,229910929309,229916399405,229901224153,229898096182,229913839200,229916349096,229914827590,229913533132,229913700624,229916527071,229913944665,229916281313,229915172529,229913808489,229913939614,229913806671,229916298990,229913521010,229913840110,229918192431,229913892943,229916200015", "usuario" : "414", "caixa" : "2916050", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-10 11:18:01 Duration: 14s283ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243120", "modelo" : "263", "itens" : "229897121935,229897132744,229895966681,229896008605,229896008807,229896010020,229896017393,229919811119,229897070819,229897236165,229897240207,229920566478,229920567690,229920570924,229919812533,229897036673,229897050716,229897053443,229897055463,229893593947,229898044056,229911346678,229870788690,229870802935,229870805561,229870821321,229870828189,229870859304,229870862739,229870863244,229870875770,229870877588,229870912037,229870936079,229870954667,229913120107,229913095457,229913069090,229871746674,229912762339,229913092124,229913092528,229871416485,229871703640,229908492023", "usuario" : "414", "caixa" : "2915401", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-10 11:25:10 Duration: 4s317ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "275776", "modelo" : "190", "itens" : "229894981120,229872568102,229913348590,229870567176,229874875678,229872483952,229872382023,229914688990,229875092546,229894438989,229885539198,229875226980,229907678902,229907712138,229862764653,229894551931,229875298705,229872545675,229863000412,229869517489,229894752231,229869816991,229894220002,229895201220,229875626570,229875762847,229875903343,229907768002,229862715759,229862447596,229873571421,229872945770,229872688595,229885861936,229869822929,229875894150,229886006169,229914143046,229869705364,229876972022,229870491031,229874930005,229876892340,229872034660,229869726073,229907864554,229868770515,229869919201", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-10 09:06:20 Duration: 3s712ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10m45s 45 9s791ms 54s361ms 14s353ms create table temp0000287863 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 10 07 9 2m20s 15s615ms 08 13 2m29s 11s467ms 09 6 1m55s 19s239ms 10 9 2m11s 14s615ms 11 8 1m49s 13s661ms [ User: intelifix - Total duration: 10m45s - Times executed: 45 ]
[ Application: [unknown] - Total duration: 10m45s - Times executed: 45 ]
-
CREATE TABLE temp0000287863 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 09:28:08 Duration: 54s361ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287863 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 07:33:07 Duration: 52s515ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287863 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 10:18:32 Duration: 18s661ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 7m30s 126 301ms 13s305ms 3s572ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 10 00 1 477ms 477ms 07 7 24s19ms 3s431ms 08 11 53s285ms 4s844ms 09 12 44s923ms 3s743ms 10 12 42s814ms 3s567ms 11 12 58s62ms 4s838ms 12 12 41s58ms 3s421ms 13 7 9s214ms 1s316ms 14 12 43s788ms 3s649ms 15 12 1m 5s14ms 16 11 38s382ms 3s489ms 17 6 7s156ms 1s192ms 21 5 13s397ms 2s679ms 22 6 13s440ms 2s240ms [ User: intelifix - Total duration: 7m30s - Times executed: 126 ]
[ Application: psql - Total duration: 7m30s - Times executed: 126 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-10 08:25:14 Duration: 13s305ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-10 15:55:14 Duration: 12s636ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-10 11:05:12 Duration: 10s672ms Database: rio User: intelifix Remote: [local] Application: psql
11 6m54s 31 10s942ms 15s931ms 13s380ms create table temp0000287897 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 10 08 6 1m14s 12s449ms 10 8 1m51s 13s952ms 11 11 2m30s 13s673ms 12 6 1m18s 13s11ms [ User: intelifix - Total duration: 6m54s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 6m54s - Times executed: 31 ]
-
CREATE TABLE temp0000287897 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 10:33:44 Duration: 15s931ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287897 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 11:05:09 Duration: 15s782ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287897 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 11:36:01 Duration: 15s Database: rio User: intelifix Remote: [local] Application: [unknown]
12 6m19s 30 9s904ms 32s775ms 12s652ms create table temp0000287937 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 10 15 2 46s22ms 23s11ms 17 28 5m33s 11s912ms [ User: intelifix - Total duration: 6m19s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 6m19s - Times executed: 30 ]
-
CREATE TABLE temp0000287937 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 15:21:00 Duration: 32s775ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287937 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 17:15:39 Duration: 21s975ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287937 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 17:31:12 Duration: 13s606ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 5m53s 25 10s511ms 55s356ms 14s141ms create table temp0000287969 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 10 14 16 3m24s 12s780ms 15 3 1m16s 25s612ms 16 6 1m12s 12s34ms [ User: intelifix - Total duration: 5m53s - Times executed: 25 ]
[ Application: [unknown] - Total duration: 5m53s - Times executed: 25 ]
-
CREATE TABLE temp0000287969 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 15:53:54 Duration: 55s356ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287969 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 14:25:17 Duration: 14s503ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287969 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 14:25:33 Duration: 14s347ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 4m50s 166 155ms 17s672ms 1s750ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 10 08 27 13s365ms 495ms 09 30 23s464ms 782ms 10 22 1m19s 3s596ms 11 7 58s423ms 8s346ms 12 3 9s266ms 3s88ms 13 15 16s817ms 1s121ms 14 12 21s114ms 1s759ms 15 10 16s879ms 1s687ms 16 4 5s14ms 1s253ms 17 35 46s678ms 1s333ms 18 1 436ms 436ms [ User: intelifix - Total duration: 4m50s - Times executed: 166 ]
[ Application: [unknown] - Total duration: 4m50s - Times executed: 166 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (051812) LIMIT 1;
Date: 2026-08-10 11:41:54 Duration: 17s672ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (051323) LIMIT 1;
Date: 2026-08-10 10:39:39 Duration: 16s611ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (051328) LIMIT 1;
Date: 2026-08-10 10:45:07 Duration: 15s555ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
15 3m36s 33 315ms 34s773ms 6s564ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 10 07 2 32s783ms 16s391ms 08 2 4s480ms 2s240ms 09 3 35s578ms 11s859ms 10 4 25s151ms 6s287ms 11 3 23s131ms 7s710ms 13 2 3s105ms 1s552ms 14 6 36s672ms 6s112ms 15 2 25s415ms 12s707ms 16 1 2s849ms 2s849ms 17 8 27s452ms 3s431ms [ User: intelifix - Total duration: 3m36s - Times executed: 33 ]
[ Application: psql - Total duration: 3m36s - Times executed: 33 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028207);
Date: 2026-08-10 09:30:25 Duration: 34s773ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028197);
Date: 2026-08-10 07:35:23 Duration: 30s591ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028238);
Date: 2026-08-10 17:24:30 Duration: 21s986ms Database: rio User: intelifix Remote: [local] Application: psql
16 3m10s 54 233ms 8s844ms 3s533ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 10 08 4 13s356ms 3s339ms 09 4 13s557ms 3s389ms 10 5 18s720ms 3s744ms 11 4 19s136ms 4s784ms 12 3 10s989ms 3s663ms 13 3 14s643ms 4s881ms 14 3 10s4ms 3s334ms 15 3 10s845ms 3s615ms 16 4 9s548ms 2s387ms 17 3 9s434ms 3s144ms 18 4 13s971ms 3s492ms 19 4 13s517ms 3s379ms 20 3 10s378ms 3s459ms 21 4 13s235ms 3s308ms 22 3 9s490ms 3s163ms [ User: intelifix - Total duration: 3m10s - Times executed: 54 ]
[ Application: psql - Total duration: 3m10s - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-10 11:00:13 Duration: 8s844ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-10 13:00:13 Duration: 8s3ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-10 10:40:06 Duration: 4s986ms Database: rio User: intelifix Remote: [local] Application: psql
17 3m8s 11 10s167ms 53s810ms 17s100ms create table temp0000287949 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 10 13 5 1m40s 20s132ms 14 6 1m27s 14s573ms [ User: intelifix - Total duration: 3m8s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 3m8s - Times executed: 11 ]
-
CREATE TABLE temp0000287949 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 13:39:29 Duration: 53s810ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287949 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 14:06:56 Duration: 15s600ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287949 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 14:06:28 Duration: 14s987ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 2m53s 60 195ms 24s585ms 2s890ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 10 07 4 2s839ms 709ms 08 6 23s641ms 3s940ms 09 2 1s107ms 553ms 10 6 48s912ms 8s152ms 11 7 12s55ms 1s722ms 12 1 4s629ms 4s629ms 13 2 8s574ms 4s287ms 14 9 41s913ms 4s657ms 15 2 1s100ms 550ms 16 2 662ms 331ms 17 19 27s988ms 1s473ms [ User: intelifix - Total duration: 2m53s - Times executed: 60 ]
[ Application: psql - Total duration: 2m53s - Times executed: 60 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028210);
Date: 2026-08-10 10:39:50 Duration: 24s585ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028224);
Date: 2026-08-10 14:02:38 Duration: 18s143ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028226);
Date: 2026-08-10 14:12:07 Duration: 17s151ms Database: rio User: intelifix Remote: [local] Application: psql
19 2m52s 4 4s385ms 1m24s 43s128ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 10 20 2 1m23s 41s914ms 23 2 1m28s 44s342ms [ User: intelifix - Total duration: 2m52s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m52s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-10 23:16:29 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-10 20:08:14 Duration: 1m19s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-10 23:34:43 Duration: 4s551ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 2m6s 37 2s864ms 4s523ms 3s423ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 10 08 2 7s602ms 3s801ms 09 2 6s237ms 3s118ms 10 1 3s369ms 3s369ms 11 2 6s182ms 3s91ms 12 3 10s405ms 3s468ms 13 3 10s34ms 3s344ms 14 3 9s653ms 3s217ms 15 3 11s389ms 3s796ms 16 3 9s499ms 3s166ms 17 3 10s241ms 3s413ms 18 2 6s435ms 3s217ms 19 2 6s342ms 3s171ms 20 3 11s128ms 3s709ms 21 2 6s510ms 3s255ms 22 3 11s633ms 3s877ms [ User: intelifix - Total duration: 2m6s - Times executed: 37 ]
[ Application: psql - Total duration: 2m6s - Times executed: 37 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-10 22:20:05 Duration: 4s523ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-10 15:00:06 Duration: 4s333ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-10 15:40:05 Duration: 4s190ms Database: rio User: intelifix Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,529 21m43s 150ms 59s786ms 852ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 10 07 19 13s394ms 704ms 08 80 2m8s 1s609ms 09 220 3m9s 859ms 10 178 2m15s 762ms 11 161 2m13s 829ms 12 53 37s552ms 708ms 13 77 54s589ms 708ms 14 175 2m46s 952ms 15 203 3m5s 913ms 16 253 3m23s 805ms 17 110 54s551ms 495ms [ User: intelifix - Total duration: 21m43s - Times executed: 1529 ]
[ Application: [unknown] - Total duration: 21m43s - Times executed: 1529 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (275749, 433, 'CP23213216A,D4925EAC04B9,544D4242006A89D2,D4925EAC04BC', '',0298,00,'[{"item":"0","qrcode":""}]','$$$$$$$','', 00);
Date: 2026-08-10 08:56:52 Duration: 59s786ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276051, 404, 'CP2204LV55S,1C9D726AC8C4$CP2239LVLVM,B85E71BCC078$CP2051LV489,484BD4A60034$CP2523LV3KQ,B85E710E77D8$CP2248LV4BJ,B85E71E25B08$CP2147LV7EF,D4E2CB923024$CP2141LV36E,ECA81FF73C2C$CP2528LV4ZY,F8D2AC4B9B00$CP2239LV4E1,4075C3BF1F70$CP2125LV6BZ,08A7C071E5A4$CP2204LV589,1C9D726A156C$CP2115LV2AU,08A7C069542C$CP2226LV0RT,80DAC2CE8D20$CP2425LV38V,C4509CAB29C4$CP2143LV0HG,ECA81FFCA1C4$CP2431LV3UK,C4509CBF26D4$CP2530LV1DR,3C82C08B8B60$CP2147LV0N1,D4E2CB916A3C$CP2243LV5H1,B85E71D147C8$CP2143LV6AV,1C9ECC8D1354$CP2523LV13A,B85E710E8304$CP2248LV4TK,B85E71DA8874$CP2226LV995,80DAC2CF5570$CP2347LVAGG,400FC18371DC$CP2205LV2RE,1C9D7282C374$CP2114LV234,08A7C04F14E4$CP2302LVAUH,B85E71E91D6C$CP2243LV368,B85E71CFD8E8$CP2239LVP7Y,B85E71BEE0D8$CP2243LVAQB,B85E71D2A848$CP2134LV76C,ECA81F23C4D4$CP2104LV2AR,484BD4ACA714$CP2128LV6DM,08A7C07A0264$CP2048LV7TW,484BD4A13E94', '',0185,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-10 14:44:10 Duration: 5s78ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (275457, 404, '732257053156,B4F267402426,B4F2673FA050,6802B8F93304,B4F2673F91C2,B4F26721A685,B4F26740383C,B4F267369790,B4F2673FD854,B4F267404C7C,B4F2673642A6,B4F2673FA041,B4F26721915B,B4F267402BD0,B4F26737D407,B4F2673F6AEF,B4F2673641E6,B4F26740298D,B4F2676C114C,B4F2676C1491,B4F26760939E,B4F267149530,B4F267405DA1,B4F2673E99E2,B4F2673FF891,B4F267606D9D,B4F2673FF918,B4F26758D1D5,B4F26758ED8C,B4F2674016E5,B4F2673FF90C,B4F267404EC5,B4F267606BA2,6802B8FEA95E,6802B8FEA901,6802B8F934BA,B4F2673FD88A', '',0300,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-10 09:28:59 Duration: 4s685ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1,187 12m35s 151ms 14s283ms 636ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 10 07 7 2s772ms 396ms 08 120 1m14s 620ms 09 197 2m9s 659ms 10 169 1m41s 600ms 11 182 2m35s 854ms 13 89 1m3s 708ms 14 116 1m8s 586ms 15 135 1m5s 483ms 16 113 1m 536ms 17 59 34s326ms 581ms [ User: intelifix - Total duration: 12m35s - Times executed: 1187 ]
[ Application: [unknown] - Total duration: 12m35s - Times executed: 1187 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243120", "modelo" : "263", "itens" : "229918628286,229912614647,229898101739,229912018090,229871470105,229899166174,229899314247,229899364555,229899371627,229899379708,229892794464,229892807899,229892814870,229892817092,229892818002,229892820303,229892822020,229892824242,229892825959,229915684453,229915717486,229896915977,229902158902,229910929309,229916399405,229901224153,229898096182,229913839200,229916349096,229914827590,229913533132,229913700624,229916527071,229913944665,229916281313,229915172529,229913808489,229913939614,229913806671,229916298990,229913521010,229913840110,229918192431,229913892943,229916200015", "usuario" : "414", "caixa" : "2916050", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-10 11:18:01 Duration: 14s283ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243120", "modelo" : "263", "itens" : "229897121935,229897132744,229895966681,229896008605,229896008807,229896010020,229896017393,229919811119,229897070819,229897236165,229897240207,229920566478,229920567690,229920570924,229919812533,229897036673,229897050716,229897053443,229897055463,229893593947,229898044056,229911346678,229870788690,229870802935,229870805561,229870821321,229870828189,229870859304,229870862739,229870863244,229870875770,229870877588,229870912037,229870936079,229870954667,229913120107,229913095457,229913069090,229871746674,229912762339,229913092124,229913092528,229871416485,229871703640,229908492023", "usuario" : "414", "caixa" : "2915401", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-10 11:25:10 Duration: 4s317ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "275776", "modelo" : "190", "itens" : "229894981120,229872568102,229913348590,229870567176,229874875678,229872483952,229872382023,229914688990,229875092546,229894438989,229885539198,229875226980,229907678902,229907712138,229862764653,229894551931,229875298705,229872545675,229863000412,229869517489,229894752231,229869816991,229894220002,229895201220,229875626570,229875762847,229875903343,229907768002,229862715759,229862447596,229873571421,229872945770,229872688595,229885861936,229869822929,229875894150,229886006169,229914143046,229869705364,229876972022,229870491031,229874930005,229876892340,229872034660,229869726073,229907864554,229868770515,229869919201", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-10 09:06:20 Duration: 3s712ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 355 1h37m24s 151ms 7m53s 16s462ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 10 07 4 7m36s 1m54s 08 43 23m3s 32s163ms 09 55 9m14s 10s89ms 10 35 7m51s 13s482ms 11 28 17m4s 36s599ms 12 15 2m48s 11s231ms 13 23 41s597ms 1s808ms 14 29 13m40s 28s306ms 15 29 5m38s 11s685ms 16 24 51s536ms 2s147ms 17 68 8m48s 7s765ms 18 2 3s467ms 1s733ms [ User: intelifix - Total duration: 1h37m24s - Times executed: 355 ]
[ Application: [unknown] - Total duration: 1h37m24s - Times executed: 355 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028207, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-10 09:38:14 Duration: 7m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028215, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-10 11:25:09 Duration: 7m39s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028197, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-10 07:42:44 Duration: 7m20s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 275 16m38s 201ms 2m19s 3s629ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 10 00 12 40s796ms 3s399ms 01 12 25s402ms 2s116ms 02 12 25s753ms 2s146ms 03 11 20s486ms 1s862ms 04 12 24s446ms 2s37ms 05 12 23s366ms 1s947ms 06 12 24s614ms 2s51ms 07 12 25s135ms 2s94ms 08 12 3m26s 17s182ms 09 12 35s952ms 2s996ms 10 12 2m46s 13s851ms 11 12 57s289ms 4s774ms 12 12 29s310ms 2s442ms 13 12 29s213ms 2s434ms 14 12 28s354ms 2s362ms 15 12 36s934ms 3s77ms 16 12 35s821ms 2s985ms 17 12 30s671ms 2s555ms 18 12 25s437ms 2s119ms 19 12 23s961ms 1s996ms 20 12 32s696ms 2s724ms 21 12 25s25ms 2s85ms 22 12 25s10ms 2s84ms [ User: intelifix - Total duration: 16m38s - Times executed: 275 ]
[ Application: psql - Total duration: 16m38s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-10 10:27:28 Duration: 2m19s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-10 08:56:53 Duration: 1m43s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-10 08:26:38 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
5 166 4m50s 155ms 17s672ms 1s750ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 10 08 27 13s365ms 495ms 09 30 23s464ms 782ms 10 22 1m19s 3s596ms 11 7 58s423ms 8s346ms 12 3 9s266ms 3s88ms 13 15 16s817ms 1s121ms 14 12 21s114ms 1s759ms 15 10 16s879ms 1s687ms 16 4 5s14ms 1s253ms 17 35 46s678ms 1s333ms 18 1 436ms 436ms [ User: intelifix - Total duration: 4m50s - Times executed: 166 ]
[ Application: [unknown] - Total duration: 4m50s - Times executed: 166 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (051812) LIMIT 1;
Date: 2026-08-10 11:41:54 Duration: 17s672ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (051323) LIMIT 1;
Date: 2026-08-10 10:39:39 Duration: 16s611ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (051328) LIMIT 1;
Date: 2026-08-10 10:45:07 Duration: 15s555ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
6 150 28s155ms 150ms 2s352ms 187ms create table temp0000287869 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 10 08 6 3s209ms 534ms 09 9 1s590ms 176ms 10 11 2s124ms 193ms 11 6 1s91ms 181ms 12 13 2s110ms 162ms 13 3 515ms 171ms 14 33 5s605ms 169ms 15 22 3s650ms 165ms 16 30 5s146ms 171ms 17 17 3s110ms 182ms [ User: intelifix - Total duration: 28s155ms - Times executed: 150 ]
[ Application: [unknown] - Total duration: 28s155ms - Times executed: 150 ]
-
CREATE TABLE temp0000287869 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-08-2026", "ate" :"10-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-10 08:05:45 Duration: 2s352ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287869 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-08-2026", "ate" :"10-08-2026", "nota-fiscal":"409", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-10 14:05:17 Duration: 250ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287869 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-08-2026", "ate" :"10-08-2026", "nota-fiscal":"1587", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-10 10:33:13 Duration: 242ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 126 7m30s 301ms 13s305ms 3s572ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 10 00 1 477ms 477ms 07 7 24s19ms 3s431ms 08 11 53s285ms 4s844ms 09 12 44s923ms 3s743ms 10 12 42s814ms 3s567ms 11 12 58s62ms 4s838ms 12 12 41s58ms 3s421ms 13 7 9s214ms 1s316ms 14 12 43s788ms 3s649ms 15 12 1m 5s14ms 16 11 38s382ms 3s489ms 17 6 7s156ms 1s192ms 21 5 13s397ms 2s679ms 22 6 13s440ms 2s240ms [ User: intelifix - Total duration: 7m30s - Times executed: 126 ]
[ Application: psql - Total duration: 7m30s - Times executed: 126 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-10 08:25:14 Duration: 13s305ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-10 15:55:14 Duration: 12s636ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-10 11:05:12 Duration: 10s672ms Database: rio User: intelifix Remote: [local] Application: psql
8 107 46s833ms 230ms 1s453ms 437ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 10 07 3 1s301ms 433ms 08 12 4s960ms 413ms 09 11 5s279ms 479ms 10 12 4s951ms 412ms 11 15 6s885ms 459ms 12 4 1s499ms 374ms 13 3 1s480ms 493ms 14 13 6s171ms 474ms 15 7 3s947ms 563ms 16 6 2s710ms 451ms 17 20 7s204ms 360ms 18 1 440ms 440ms [ User: intelifix - Total duration: 46s833ms - Times executed: 107 ]
[ Application: [unknown] - Total duration: 46s833ms - Times executed: 107 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-10 09:25:39 Duration: 1s453ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-10 15:51:30 Duration: 1s348ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-08-10 11:04:32 Duration: 750ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 103 54s423ms 153ms 1s780ms 528ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 10 08 2 814ms 407ms 09 98 52s331ms 533ms 13 3 1s277ms 425ms [ User: intelifix - Total duration: 54s423ms - Times executed: 103 ]
[ Application: [unknown] - Total duration: 54s423ms - Times executed: 103 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"51815","seriais":"226289330621","usuario":"416","observacao":""}');
Date: 2026-08-10 09:14:21 Duration: 1s780ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"51815","seriais":"226886997276","usuario":"416","observacao":""}');
Date: 2026-08-10 09:21:32 Duration: 1s598ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"51815","seriais":"246246505476","usuario":"416","observacao":""}');
Date: 2026-08-10 09:14:41 Duration: 1s175ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
10 99 25s297ms 157ms 1s21ms 255ms create table temp0000237806 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 10 08 7 2s538ms 362ms 09 15 4s106ms 273ms 10 7 1s885ms 269ms 11 4 992ms 248ms 12 66 15s774ms 239ms [ User: intelifix - Total duration: 25s297ms - Times executed: 99 ]
[ Application: [unknown] - Total duration: 25s297ms - Times executed: 99 ]
-
CREATE TABLE temp0000237806 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"05-08-2026", "ate" :"10-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-10 08:17:04 Duration: 1s21ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000237806 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"05-08-2026", "ate" :"10-08-2026", "nota-fiscal":"6283", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-10 10:36:36 Duration: 386ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000237806 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"05-08-2026", "ate" :"10-08-2026", "nota-fiscal":"6283", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-10 09:09:39 Duration: 347ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
11 97 45s927ms 283ms 814ms 473ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 10 07 8 3s404ms 425ms 08 14 6s351ms 453ms 09 8 3s889ms 486ms 10 9 4s285ms 476ms 11 9 4s924ms 547ms 12 3 1s361ms 453ms 13 10 4s597ms 459ms 14 10 4s753ms 475ms 15 7 3s230ms 461ms 16 9 4s336ms 481ms 17 8 4s9ms 501ms 18 1 329ms 329ms 20 1 455ms 455ms [ User: lenon - Total duration: 45s927ms - Times executed: 97 ]
[ Application: [unknown] - Total duration: 45s927ms - Times executed: 97 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-10 14:39:10 Duration: 814ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-10 16:58:54 Duration: 758ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-10 10:58:09 Duration: 755ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
12 87 51s154ms 350ms 888ms 587ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 10 07 4 2s289ms 572ms 08 12 6s698ms 558ms 09 8 4s900ms 612ms 10 7 3s838ms 548ms 11 9 6s47ms 671ms 12 3 1s637ms 545ms 13 9 5s193ms 577ms 14 10 5s687ms 568ms 15 7 4s169ms 595ms 16 9 5s229ms 581ms 17 8 4s993ms 624ms 18 1 468ms 468ms [ User: intelifix - Total duration: 51s154ms - Times executed: 87 ]
[ Application: [unknown] - Total duration: 51s154ms - Times executed: 87 ]
-
select * from rs_menu_grants (428, 21, 1);
Date: 2026-08-10 14:39:10 Duration: 888ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (406, 18, 1);
Date: 2026-08-10 09:43:34 Duration: 862ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (428, 19, 1);
Date: 2026-08-10 16:58:55 Duration: 830ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
13 87 16s724ms 151ms 321ms 192ms create table temp0000226764 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 10 08 15 3s157ms 210ms 09 1 216ms 216ms 11 8 1s796ms 224ms 12 2 395ms 197ms 13 46 8s520ms 185ms 14 15 2s637ms 175ms [ User: intelifix - Total duration: 16s724ms - Times executed: 87 ]
[ Application: [unknown] - Total duration: 16s724ms - Times executed: 87 ]
-
CREATE TABLE temp0000226764 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"05-08-2026", "ate" :"10-08-2026", "nota-fiscal":"17", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-10 11:48:24 Duration: 321ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226764 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"05-08-2026", "ate" :"10-08-2026", "nota-fiscal":"17", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-10 13:07:29 Duration: 305ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226764 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"05-08-2026", "ate" :"10-08-2026", "nota-fiscal":"17", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-10 11:50:55 Duration: 277ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
14 73 20s867ms 150ms 2s205ms 285ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 10 07 4 4s489ms 1s122ms 08 1 183ms 183ms 09 1 203ms 203ms 10 1 224ms 224ms 11 8 2s128ms 266ms 12 7 1s213ms 173ms 13 4 1s101ms 275ms 14 8 1s811ms 226ms 15 6 1s907ms 317ms 16 17 4s260ms 250ms 17 16 3s343ms 208ms [ User: intelifix - Total duration: 20s867ms - Times executed: 73 ]
[ Application: [unknown] - Total duration: 20s867ms - Times executed: 73 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "362", "data-de" : "2026-08-06", "data-ate" : "2026-08-06", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 414 }');
Date: 2026-08-10 07:18:34 Duration: 2s205ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "365", "data-de" : "2026-08-07", "data-ate" : "2026-08-07", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 416 }');
Date: 2026-08-10 07:20:37 Duration: 1s146ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "364", "data-de" : "2026-08-07", "data-ate" : "2026-08-07", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 416 }');
Date: 2026-08-10 07:20:41 Duration: 783ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 69 12m38s 978ms 3m40s 10s986ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 10 07 2 8s579ms 4s289ms 08 1 3s588ms 3s588ms 09 5 44s575ms 8s915ms 10 5 46s567ms 9s313ms 11 10 1m17s 7s772ms 12 1 2s902ms 2s902ms 13 8 1m9s 8s715ms 14 3 16s61ms 5s353ms 15 9 6m13s 41s534ms 16 5 38s504ms 7s700ms 17 18 1m10s 3s942ms 18 2 5s89ms 2s544ms [ User: intelifix - Total duration: 12m38s - Times executed: 69 ]
[ Application: [unknown] - Total duration: 12m38s - Times executed: 69 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-10', 099, '', '', 0, 6, '2026-01-01');
Date: 2026-08-10 15:35:07 Duration: 3m40s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-31', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-08-10 15:30:19 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-10', 0320, '', '', 0, 6, '2026-08-01');
Date: 2026-08-10 15:18:08 Duration: 24s962ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 63 22s812ms 161ms 2s894ms 362ms create table temp0000287895 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 10 08 13 10s69ms 774ms 09 34 8s310ms 244ms 10 16 4s432ms 277ms [ User: intelifix - Total duration: 22s812ms - Times executed: 63 ]
[ Application: [unknown] - Total duration: 22s812ms - Times executed: 63 ]
-
CREATE TABLE temp0000287895 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-08-2026", "ate" :"10-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-10 08:35:30 Duration: 2s894ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287895 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-08-2026", "ate" :"10-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-10 08:35:44 Duration: 2s513ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287895 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-08-2026", "ate" :"10-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-10 08:35:51 Duration: 2s155ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 61 14s327ms 151ms 416ms 234ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 10 08 6 1s458ms 243ms 09 1 151ms 151ms 10 2 552ms 276ms 11 2 454ms 227ms 12 15 3s438ms 229ms 14 14 3s607ms 257ms 15 12 2s593ms 216ms 16 8 1s825ms 228ms 17 1 244ms 244ms [ User: intelifix - Total duration: 14s327ms - Times executed: 61 ]
[ Application: [unknown] - Total duration: 14s327ms - Times executed: 61 ]
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '216629997890,216819358100,216618148383,216799024454,216910385872,216818546673,216736067894,216519125061,216613941229', NULL, NULL, 062, 00);
Date: 2026-08-10 12:09:59 Duration: 416ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (403, 5, '113', 3, '241772478095,241764145767,241778603239,241745670508,241771248592,241775855361,241738362533,241745659900,241776656382,241778628695,241767863044,241764412236', NULL, NULL, 0464, 00);
Date: 2026-08-10 15:38:53 Duration: 415ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '241681820921,241681844963,229951579505,230030849799', NULL, NULL, 0305, 00);
Date: 2026-08-10 15:22:30 Duration: 386ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 61 13s563ms 150ms 1s440ms 222ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 10 07 2 915ms 457ms 08 7 1s339ms 191ms 09 8 1s489ms 186ms 10 5 885ms 177ms 12 2 325ms 162ms 13 5 943ms 188ms 14 3 551ms 183ms 15 9 1s782ms 198ms 16 4 753ms 188ms 17 13 2s425ms 186ms 21 1 330ms 330ms 23 2 1s820ms 910ms [ User: intelifix - Total duration: 13s563ms - Times executed: 61 ]
[ Application: [unknown] - Total duration: 13s563ms - Times executed: 61 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('241715020828');
Date: 2026-08-10 23:31:40 Duration: 1s440ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('230017984347');
Date: 2026-08-10 07:04:20 Duration: 703ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('48570214FFF9');
Date: 2026-08-10 15:34:11 Duration: 385ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 60 2m53s 195ms 24s585ms 2s890ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 10 07 4 2s839ms 709ms 08 6 23s641ms 3s940ms 09 2 1s107ms 553ms 10 6 48s912ms 8s152ms 11 7 12s55ms 1s722ms 12 1 4s629ms 4s629ms 13 2 8s574ms 4s287ms 14 9 41s913ms 4s657ms 15 2 1s100ms 550ms 16 2 662ms 331ms 17 19 27s988ms 1s473ms [ User: intelifix - Total duration: 2m53s - Times executed: 60 ]
[ Application: psql - Total duration: 2m53s - Times executed: 60 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028210);
Date: 2026-08-10 10:39:50 Duration: 24s585ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028224);
Date: 2026-08-10 14:02:38 Duration: 18s143ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028226);
Date: 2026-08-10 14:12:07 Duration: 17s151ms Database: rio User: intelifix Remote: [local] Application: psql
20 60 23s496ms 154ms 3s427ms 391ms select * from rs_lote_saida_manutencao (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 10 07 1 209ms 209ms 08 2 333ms 166ms 09 6 1s298ms 216ms 10 13 3s488ms 268ms 11 11 12s10ms 1s91ms 13 5 1s255ms 251ms 14 4 1s430ms 357ms 15 5 975ms 195ms 16 2 434ms 217ms 17 11 2s59ms 187ms [ User: intelifix - Total duration: 23s496ms - Times executed: 60 ]
[ Application: [unknown] - Total duration: 23s496ms - Times executed: 60 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "48105", "oficina" : "2", "cliente" : "1", "usuario" : "409", "nf" : "000082953", "data-saida" : "2026-08-06", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "PRIORIDADE PAPEL -LOTE 25", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-10 11:04:53 Duration: 3s427ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "48104", "oficina" : "2", "cliente" : "1", "usuario" : "409", "nf" : "000082954", "data-saida" : "2026-08-06", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "PRIORIDADE RIO -LOTE 25", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-10 11:05:08 Duration: 2s658ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "48103", "oficina" : "2", "cliente" : "1", "usuario" : "409", "nf" : "000082953", "data-saida" : "2026-08-06", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "PRIORIDADE ECO -LOTE 25", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-10 11:05:21 Duration: 2s239ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m29s 9m20s 5m31s 3 16m34s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 10 05 3 16m34s 5m31s [ User: intelifix - Total duration: 16m34s - Times executed: 3 ]
[ Application: psql - Total duration: 16m34s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-10 05:09:21 Duration: 9m20s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-10 05:14:05 Duration: 4m43s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-10 05:16:35 Duration: 2m29s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s290ms 13m19s 2m54s 48 2h19m24s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 10 07 3 14m4s 4m41s 08 3 6m17s 2m5s 09 3 13m28s 4m29s 10 3 10m36s 3m32s 11 3 10m12s 3m24s 12 3 9m37s 3m12s 13 3 7m14s 2m24s 14 3 9m31s 3m10s 15 3 9m2s 3m 16 3 8m54s 2m58s 17 3 7m25s 2m28s 18 3 7m45s 2m35s 19 3 6m3s 2m1s 20 3 6m50s 2m16s 21 3 6m19s 2m6s 22 3 6m 2m [ User: intelifix - Total duration: 2h19m24s - Times executed: 48 ]
[ Application: psql - Total duration: 2h19m24s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-10 07:18:21 Duration: 13m19s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-10 09:17:45 Duration: 12m44s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-10 10:15:01 Duration: 9m59s Database: rio User: intelifix Remote: [local] Application: psql
3 229ms 5m25s 1m38s 48 1h18m25s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 10 07 3 6m8s 2m2s 08 3 4m7s 1m22s 09 3 6m38s 2m12s 10 3 6m36s 2m12s 11 3 5m47s 1m55s 12 3 5m5s 1m41s 13 3 5m4s 1m41s 14 3 5m31s 1m50s 15 3 4m51s 1m37s 16 3 4m39s 1m33s 17 3 4m24s 1m28s 18 3 4m5s 1m21s 19 3 3m38s 1m12s 20 3 4m11s 1m23s 21 3 3m47s 1m15s 22 3 3m47s 1m15s [ User: intelifix - Total duration: 1h18m25s - Times executed: 48 ]
[ Application: psql - Total duration: 1h18m25s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-10 10:22:06 Duration: 5m25s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-10 11:20:55 Duration: 4m57s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-10 09:25:01 Duration: 4m51s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s385ms 1m24s 43s128ms 4 2m52s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 10 20 2 1m23s 41s914ms 23 2 1m28s 44s342ms [ User: intelifix - Total duration: 2m52s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m52s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-10 23:16:29 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-10 20:08:14 Duration: 1m19s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-10 23:34:43 Duration: 4s551ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 10s167ms 53s810ms 17s100ms 11 3m8s create table temp0000287949 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 10 13 5 1m40s 20s132ms 14 6 1m27s 14s573ms [ User: intelifix - Total duration: 3m8s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 3m8s - Times executed: 11 ]
-
CREATE TABLE temp0000287949 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 13:39:29 Duration: 53s810ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287949 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 14:06:56 Duration: 15s600ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287949 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 14:06:28 Duration: 14s987ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 151ms 7m53s 16s462ms 355 1h37m24s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 10 07 4 7m36s 1m54s 08 43 23m3s 32s163ms 09 55 9m14s 10s89ms 10 35 7m51s 13s482ms 11 28 17m4s 36s599ms 12 15 2m48s 11s231ms 13 23 41s597ms 1s808ms 14 29 13m40s 28s306ms 15 29 5m38s 11s685ms 16 24 51s536ms 2s147ms 17 68 8m48s 7s765ms 18 2 3s467ms 1s733ms [ User: intelifix - Total duration: 1h37m24s - Times executed: 355 ]
[ Application: [unknown] - Total duration: 1h37m24s - Times executed: 355 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028207, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-10 09:38:14 Duration: 7m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028215, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-10 11:25:09 Duration: 7m39s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028197, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-10 07:42:44 Duration: 7m20s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 9s791ms 54s361ms 14s353ms 45 10m45s create table temp0000287863 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 10 07 9 2m20s 15s615ms 08 13 2m29s 11s467ms 09 6 1m55s 19s239ms 10 9 2m11s 14s615ms 11 8 1m49s 13s661ms [ User: intelifix - Total duration: 10m45s - Times executed: 45 ]
[ Application: [unknown] - Total duration: 10m45s - Times executed: 45 ]
-
CREATE TABLE temp0000287863 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 09:28:08 Duration: 54s361ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287863 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 07:33:07 Duration: 52s515ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287863 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 10:18:32 Duration: 18s661ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10s511ms 55s356ms 14s141ms 25 5m53s create table temp0000287969 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 10 14 16 3m24s 12s780ms 15 3 1m16s 25s612ms 16 6 1m12s 12s34ms [ User: intelifix - Total duration: 5m53s - Times executed: 25 ]
[ Application: [unknown] - Total duration: 5m53s - Times executed: 25 ]
-
CREATE TABLE temp0000287969 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 15:53:54 Duration: 55s356ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287969 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 14:25:17 Duration: 14s503ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287969 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 14:25:33 Duration: 14s347ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s942ms 15s931ms 13s380ms 31 6m54s create table temp0000287897 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 10 08 6 1m14s 12s449ms 10 8 1m51s 13s952ms 11 11 2m30s 13s673ms 12 6 1m18s 13s11ms [ User: intelifix - Total duration: 6m54s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 6m54s - Times executed: 31 ]
-
CREATE TABLE temp0000287897 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 10:33:44 Duration: 15s931ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287897 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 11:05:09 Duration: 15s782ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287897 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 11:36:01 Duration: 15s Database: rio User: intelifix Remote: [local] Application: [unknown]
10 9s904ms 32s775ms 12s652ms 30 6m19s create table temp0000287937 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 10 15 2 46s22ms 23s11ms 17 28 5m33s 11s912ms [ User: intelifix - Total duration: 6m19s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 6m19s - Times executed: 30 ]
-
CREATE TABLE temp0000287937 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 15:21:00 Duration: 32s775ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287937 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 17:15:39 Duration: 21s975ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287937 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-10 17:31:12 Duration: 13s606ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 978ms 3m40s 10s986ms 69 12m38s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 10 07 2 8s579ms 4s289ms 08 1 3s588ms 3s588ms 09 5 44s575ms 8s915ms 10 5 46s567ms 9s313ms 11 10 1m17s 7s772ms 12 1 2s902ms 2s902ms 13 8 1m9s 8s715ms 14 3 16s61ms 5s353ms 15 9 6m13s 41s534ms 16 5 38s504ms 7s700ms 17 18 1m10s 3s942ms 18 2 5s89ms 2s544ms [ User: intelifix - Total duration: 12m38s - Times executed: 69 ]
[ Application: [unknown] - Total duration: 12m38s - Times executed: 69 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-10', 099, '', '', 0, 6, '2026-01-01');
Date: 2026-08-10 15:35:07 Duration: 3m40s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-31', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-08-10 15:30:19 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-10', 0320, '', '', 0, 6, '2026-08-01');
Date: 2026-08-10 15:18:08 Duration: 24s962ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 315ms 34s773ms 6s564ms 33 3m36s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 10 07 2 32s783ms 16s391ms 08 2 4s480ms 2s240ms 09 3 35s578ms 11s859ms 10 4 25s151ms 6s287ms 11 3 23s131ms 7s710ms 13 2 3s105ms 1s552ms 14 6 36s672ms 6s112ms 15 2 25s415ms 12s707ms 16 1 2s849ms 2s849ms 17 8 27s452ms 3s431ms [ User: intelifix - Total duration: 3m36s - Times executed: 33 ]
[ Application: psql - Total duration: 3m36s - Times executed: 33 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028207);
Date: 2026-08-10 09:30:25 Duration: 34s773ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028197);
Date: 2026-08-10 07:35:23 Duration: 30s591ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028238);
Date: 2026-08-10 17:24:30 Duration: 21s986ms Database: rio User: intelifix Remote: [local] Application: psql
13 201ms 2m19s 3s629ms 275 16m38s call rs_giga_triagem (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 10 00 12 40s796ms 3s399ms 01 12 25s402ms 2s116ms 02 12 25s753ms 2s146ms 03 11 20s486ms 1s862ms 04 12 24s446ms 2s37ms 05 12 23s366ms 1s947ms 06 12 24s614ms 2s51ms 07 12 25s135ms 2s94ms 08 12 3m26s 17s182ms 09 12 35s952ms 2s996ms 10 12 2m46s 13s851ms 11 12 57s289ms 4s774ms 12 12 29s310ms 2s442ms 13 12 29s213ms 2s434ms 14 12 28s354ms 2s362ms 15 12 36s934ms 3s77ms 16 12 35s821ms 2s985ms 17 12 30s671ms 2s555ms 18 12 25s437ms 2s119ms 19 12 23s961ms 1s996ms 20 12 32s696ms 2s724ms 21 12 25s25ms 2s85ms 22 12 25s10ms 2s84ms [ User: intelifix - Total duration: 16m38s - Times executed: 275 ]
[ Application: psql - Total duration: 16m38s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-10 10:27:28 Duration: 2m19s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-10 08:56:53 Duration: 1m43s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-10 08:26:38 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
14 301ms 13s305ms 3s572ms 126 7m30s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 10 00 1 477ms 477ms 07 7 24s19ms 3s431ms 08 11 53s285ms 4s844ms 09 12 44s923ms 3s743ms 10 12 42s814ms 3s567ms 11 12 58s62ms 4s838ms 12 12 41s58ms 3s421ms 13 7 9s214ms 1s316ms 14 12 43s788ms 3s649ms 15 12 1m 5s14ms 16 11 38s382ms 3s489ms 17 6 7s156ms 1s192ms 21 5 13s397ms 2s679ms 22 6 13s440ms 2s240ms [ User: intelifix - Total duration: 7m30s - Times executed: 126 ]
[ Application: psql - Total duration: 7m30s - Times executed: 126 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-10 08:25:14 Duration: 13s305ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-10 15:55:14 Duration: 12s636ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-10 11:05:12 Duration: 10s672ms Database: rio User: intelifix Remote: [local] Application: psql
15 233ms 8s844ms 3s533ms 54 3m10s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 10 08 4 13s356ms 3s339ms 09 4 13s557ms 3s389ms 10 5 18s720ms 3s744ms 11 4 19s136ms 4s784ms 12 3 10s989ms 3s663ms 13 3 14s643ms 4s881ms 14 3 10s4ms 3s334ms 15 3 10s845ms 3s615ms 16 4 9s548ms 2s387ms 17 3 9s434ms 3s144ms 18 4 13s971ms 3s492ms 19 4 13s517ms 3s379ms 20 3 10s378ms 3s459ms 21 4 13s235ms 3s308ms 22 3 9s490ms 3s163ms [ User: intelifix - Total duration: 3m10s - Times executed: 54 ]
[ Application: psql - Total duration: 3m10s - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-10 11:00:13 Duration: 8s844ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-10 13:00:13 Duration: 8s3ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-10 10:40:06 Duration: 4s986ms Database: rio User: intelifix Remote: [local] Application: psql
16 2s864ms 4s523ms 3s423ms 37 2m6s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 10 08 2 7s602ms 3s801ms 09 2 6s237ms 3s118ms 10 1 3s369ms 3s369ms 11 2 6s182ms 3s91ms 12 3 10s405ms 3s468ms 13 3 10s34ms 3s344ms 14 3 9s653ms 3s217ms 15 3 11s389ms 3s796ms 16 3 9s499ms 3s166ms 17 3 10s241ms 3s413ms 18 2 6s435ms 3s217ms 19 2 6s342ms 3s171ms 20 3 11s128ms 3s709ms 21 2 6s510ms 3s255ms 22 3 11s633ms 3s877ms [ User: intelifix - Total duration: 2m6s - Times executed: 37 ]
[ Application: psql - Total duration: 2m6s - Times executed: 37 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-10 22:20:05 Duration: 4s523ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-10 15:00:06 Duration: 4s333ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-10 15:40:05 Duration: 4s190ms Database: rio User: intelifix Remote: [local] Application: psql
17 195ms 24s585ms 2s890ms 60 2m53s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 10 07 4 2s839ms 709ms 08 6 23s641ms 3s940ms 09 2 1s107ms 553ms 10 6 48s912ms 8s152ms 11 7 12s55ms 1s722ms 12 1 4s629ms 4s629ms 13 2 8s574ms 4s287ms 14 9 41s913ms 4s657ms 15 2 1s100ms 550ms 16 2 662ms 331ms 17 19 27s988ms 1s473ms [ User: intelifix - Total duration: 2m53s - Times executed: 60 ]
[ Application: psql - Total duration: 2m53s - Times executed: 60 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028210);
Date: 2026-08-10 10:39:50 Duration: 24s585ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028224);
Date: 2026-08-10 14:02:38 Duration: 18s143ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028226);
Date: 2026-08-10 14:12:07 Duration: 17s151ms Database: rio User: intelifix Remote: [local] Application: psql
18 155ms 17s672ms 1s750ms 166 4m50s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 10 08 27 13s365ms 495ms 09 30 23s464ms 782ms 10 22 1m19s 3s596ms 11 7 58s423ms 8s346ms 12 3 9s266ms 3s88ms 13 15 16s817ms 1s121ms 14 12 21s114ms 1s759ms 15 10 16s879ms 1s687ms 16 4 5s14ms 1s253ms 17 35 46s678ms 1s333ms 18 1 436ms 436ms [ User: intelifix - Total duration: 4m50s - Times executed: 166 ]
[ Application: [unknown] - Total duration: 4m50s - Times executed: 166 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (051812) LIMIT 1;
Date: 2026-08-10 11:41:54 Duration: 17s672ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (051323) LIMIT 1;
Date: 2026-08-10 10:39:39 Duration: 16s611ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (051328) LIMIT 1;
Date: 2026-08-10 10:45:07 Duration: 15s555ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 150ms 59s786ms 852ms 1,529 21m43s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 10 07 19 13s394ms 704ms 08 80 2m8s 1s609ms 09 220 3m9s 859ms 10 178 2m15s 762ms 11 161 2m13s 829ms 12 53 37s552ms 708ms 13 77 54s589ms 708ms 14 175 2m46s 952ms 15 203 3m5s 913ms 16 253 3m23s 805ms 17 110 54s551ms 495ms [ User: intelifix - Total duration: 21m43s - Times executed: 1529 ]
[ Application: [unknown] - Total duration: 21m43s - Times executed: 1529 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (275749, 433, 'CP23213216A,D4925EAC04B9,544D4242006A89D2,D4925EAC04BC', '',0298,00,'[{"item":"0","qrcode":""}]','$$$$$$$','', 00);
Date: 2026-08-10 08:56:52 Duration: 59s786ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276051, 404, 'CP2204LV55S,1C9D726AC8C4$CP2239LVLVM,B85E71BCC078$CP2051LV489,484BD4A60034$CP2523LV3KQ,B85E710E77D8$CP2248LV4BJ,B85E71E25B08$CP2147LV7EF,D4E2CB923024$CP2141LV36E,ECA81FF73C2C$CP2528LV4ZY,F8D2AC4B9B00$CP2239LV4E1,4075C3BF1F70$CP2125LV6BZ,08A7C071E5A4$CP2204LV589,1C9D726A156C$CP2115LV2AU,08A7C069542C$CP2226LV0RT,80DAC2CE8D20$CP2425LV38V,C4509CAB29C4$CP2143LV0HG,ECA81FFCA1C4$CP2431LV3UK,C4509CBF26D4$CP2530LV1DR,3C82C08B8B60$CP2147LV0N1,D4E2CB916A3C$CP2243LV5H1,B85E71D147C8$CP2143LV6AV,1C9ECC8D1354$CP2523LV13A,B85E710E8304$CP2248LV4TK,B85E71DA8874$CP2226LV995,80DAC2CF5570$CP2347LVAGG,400FC18371DC$CP2205LV2RE,1C9D7282C374$CP2114LV234,08A7C04F14E4$CP2302LVAUH,B85E71E91D6C$CP2243LV368,B85E71CFD8E8$CP2239LVP7Y,B85E71BEE0D8$CP2243LVAQB,B85E71D2A848$CP2134LV76C,ECA81F23C4D4$CP2104LV2AR,484BD4ACA714$CP2128LV6DM,08A7C07A0264$CP2048LV7TW,484BD4A13E94', '',0185,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-10 14:44:10 Duration: 5s78ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (275457, 404, '732257053156,B4F267402426,B4F2673FA050,6802B8F93304,B4F2673F91C2,B4F26721A685,B4F26740383C,B4F267369790,B4F2673FD854,B4F267404C7C,B4F2673642A6,B4F2673FA041,B4F26721915B,B4F267402BD0,B4F26737D407,B4F2673F6AEF,B4F2673641E6,B4F26740298D,B4F2676C114C,B4F2676C1491,B4F26760939E,B4F267149530,B4F267405DA1,B4F2673E99E2,B4F2673FF891,B4F267606D9D,B4F2673FF918,B4F26758D1D5,B4F26758ED8C,B4F2674016E5,B4F2673FF90C,B4F267404EC5,B4F267606BA2,6802B8FEA95E,6802B8FEA901,6802B8F934BA,B4F2673FD88A', '',0300,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-10 09:28:59 Duration: 4s685ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 151ms 14s283ms 636ms 1,187 12m35s select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 10 07 7 2s772ms 396ms 08 120 1m14s 620ms 09 197 2m9s 659ms 10 169 1m41s 600ms 11 182 2m35s 854ms 13 89 1m3s 708ms 14 116 1m8s 586ms 15 135 1m5s 483ms 16 113 1m 536ms 17 59 34s326ms 581ms [ User: intelifix - Total duration: 12m35s - Times executed: 1187 ]
[ Application: [unknown] - Total duration: 12m35s - Times executed: 1187 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243120", "modelo" : "263", "itens" : "229918628286,229912614647,229898101739,229912018090,229871470105,229899166174,229899314247,229899364555,229899371627,229899379708,229892794464,229892807899,229892814870,229892817092,229892818002,229892820303,229892822020,229892824242,229892825959,229915684453,229915717486,229896915977,229902158902,229910929309,229916399405,229901224153,229898096182,229913839200,229916349096,229914827590,229913533132,229913700624,229916527071,229913944665,229916281313,229915172529,229913808489,229913939614,229913806671,229916298990,229913521010,229913840110,229918192431,229913892943,229916200015", "usuario" : "414", "caixa" : "2916050", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-10 11:18:01 Duration: 14s283ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243120", "modelo" : "263", "itens" : "229897121935,229897132744,229895966681,229896008605,229896008807,229896010020,229896017393,229919811119,229897070819,229897236165,229897240207,229920566478,229920567690,229920570924,229919812533,229897036673,229897050716,229897053443,229897055463,229893593947,229898044056,229911346678,229870788690,229870802935,229870805561,229870821321,229870828189,229870859304,229870862739,229870863244,229870875770,229870877588,229870912037,229870936079,229870954667,229913120107,229913095457,229913069090,229871746674,229912762339,229913092124,229913092528,229871416485,229871703640,229908492023", "usuario" : "414", "caixa" : "2915401", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-10 11:25:10 Duration: 4s317ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "275776", "modelo" : "190", "itens" : "229894981120,229872568102,229913348590,229870567176,229874875678,229872483952,229872382023,229914688990,229875092546,229894438989,229885539198,229875226980,229907678902,229907712138,229862764653,229894551931,229875298705,229872545675,229863000412,229869517489,229894752231,229869816991,229894220002,229895201220,229875626570,229875762847,229875903343,229907768002,229862715759,229862447596,229873571421,229872945770,229872688595,229885861936,229869822929,229875894150,229886006169,229914143046,229869705364,229876972022,229870491031,229874930005,229876892340,229872034660,229869726073,229907864554,229868770515,229869919201", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-10 09:06:20 Duration: 3s712ms Database: rio User: intelifix Remote: [local] Application: [unknown]
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 1 0ms 6 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 10 17 1 0ms 0ms 18 1 0ms 0ms 19 2 0ms 0ms 20 2 0ms 0ms [ User: intelifix - Total duration: 15s134ms - Times executed: 6 ]
[ Application: psql - Total duration: 13s412ms - Times executed: 4 ]
[ Application: [unknown] - Total duration: 1s721ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 19,338 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 21 FATAL entries
- 4330 ERROR entries
- 0 WARNING entries
- 14 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,246 Max number of times the same event was reported
- 4,365 Total events found
Rank Times reported Error 1 4,246 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 10 00 59 01 60 02 60 03 59 04 60 05 59 06 60 07 142 08 324 09 418 10 467 11 428 12 301 13 175 14 381 15 380 16 277 17 189 18 59 19 60 20 59 21 60 22 59 23 50 - ERROR: prepared statement "_PLAN00000000297512A0" does not exist
- ERROR: prepared statement "_PLAN00000000298BDC90" does not exist
- ERROR: prepared statement "_PLAN00000000298BB810" does not exist
Statement: DEALLOCATE "_PLAN00000000297512A0"
Date: 2026-08-10 00:00:36 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000298BDC90"
Date: 2026-08-10 00:01:36 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000298BB810"
Date: 2026-08-10 00:02:36 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 44 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 10 00 2 01 2 02 2 03 1 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 1 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-10 00:05:03 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-10 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-10 01:05:02 Database: brasilia Application: psql User: intelifix Remote: [local]
3 12 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 10 08 7 10 3 11 2 - LOG: process 3249742 still waiting for ShareLock on transaction 4108782 after 1000.213 ms
- LOG: process 3267868 still waiting for ShareLock on transaction 4110961 after 1000.112 ms
- LOG: process 3267868 still waiting for ShareLock on transaction 4110961 after 5784.512 ms
Detail: Process holding the lock: 3243359. Wait queue: 3249742.
Context: while updating tuple (76103,41) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-08-10 08:25:18 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 3243359. Wait queue: 3267868.
Context: while updating tuple (76109,45) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-08-10 08:55:14 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 3243359. Wait queue: 3267868.
Context: while updating tuple (76109,45) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-08-10 08:55:19 Database: rio Application: psql User: intelifix Remote: [local]
4 12 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 10 00 1 02 1 04 1 06 1 13 1 15 1 17 1 20 1 21 2 23 2 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-08-10 00:02:08 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-10 02:50:51 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-10 04:11:52 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
5 10 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 10 08 4 10 2 11 2 14 2 - ERROR: syntax error at or near "PEÇAS" at character 30
- ERROR: syntax error at or near "PEÇAS" at character 30
- ERROR: syntax error at or near "]" at character 35
Statement: select * from rs_caixa_qr(10 PEÇAS)
Date: 2026-08-10 08:51:06 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(10 PEÇAS)
Date: 2026-08-10 08:51:06 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(3422150 ])
Date: 2026-08-10 08:59:42 Database: rio Application: [unknown] User: etiquetas Remote: [local]
6 8 ERROR: duplicate key value violates unique constraint "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 10 10 6 11 2 - ERROR: duplicate key value violates unique constraint "tecnologias_pkey"
- ERROR: duplicate key value violates unique constraint "tecnologias_pkey"
- ERROR: duplicate key value violates unique constraint "tecnologias_pkey"
Detail: Key (tcn_id)=(4) already exists.
Context: SQL statement "INSERT INTO TECNOLOGIAS ( TCN_ID, TCN_NOME, TCN_NFGVT, TCN_TRIAGEM, TCN_VALORADO, TCN_HOMOLOGADA, TCN_ORDEM, GRU_ID, TCN_ATIVA, TIPO, TIPO_EQUIP ) VALUES ( cDados.TCN_ID, cDados.TCN_NOME, cDados.TCN_NFGVT, cDados.TCN_TRIAGEM, cDados.TCN_VALORADO, cDados.TCN_HOMOLOGADA, cDados.TCN_ORDEM, cDados.GRU_ID, cDados.TCN_ATIVA, cDados.TIPO, cDados.TIPO_EQUIP )" PL/pgSQL function rs_tecnologia_manutencao(character varying) line 102 at SQL statement
Statement: SELECT * FROM RS_TECNOLOGIA_MANUTENCAO( '{"id" :"0", "nome" :"GPON WIFI 7", "usuario" :"80", "grupo" :"2", "triagem" :"S", "nfgvt" :"S", "valorado" :"S", "homologada" :"S", "ordem" :"100", "categorias" : [{"categoria":"3"},{"categoria":"16"},{"categoria":"17"},{"categoria":"18"},{"categoria":"19"},{"categoria":"20"},{"categoria":"2"},{"categoria":"11"}], "ativa" :"S"}' )Date: 2026-08-10 10:29:41 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Detail: Key (tcn_id)=(5) already exists.
Context: SQL statement "INSERT INTO TECNOLOGIAS ( TCN_ID, TCN_NOME, TCN_NFGVT, TCN_TRIAGEM, TCN_VALORADO, TCN_HOMOLOGADA, TCN_ORDEM, GRU_ID, TCN_ATIVA, TIPO, TIPO_EQUIP ) VALUES ( cDados.TCN_ID, cDados.TCN_NOME, cDados.TCN_NFGVT, cDados.TCN_TRIAGEM, cDados.TCN_VALORADO, cDados.TCN_HOMOLOGADA, cDados.TCN_ORDEM, cDados.GRU_ID, cDados.TCN_ATIVA, cDados.TIPO, cDados.TIPO_EQUIP )" PL/pgSQL function rs_tecnologia_manutencao(character varying) line 102 at SQL statement
Statement: SELECT * FROM RS_TECNOLOGIA_MANUTENCAO( '{"id" :"0", "nome" :"GPON WIFI 7", "usuario" :"80", "grupo" :"2", "triagem" :"S", "nfgvt" :"S", "valorado" :"N", "homologada" :"S", "ordem" :"100", "categorias" : [{"categoria":"3"},{"categoria":"16"},{"categoria":"17"},{"categoria":"18"},{"categoria":"19"},{"categoria":"20"},{"categoria":"2"},{"categoria":"11"}], "ativa" :"S"}' )Date: 2026-08-10 10:29:57 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Detail: Key (tcn_id)=(6) already exists.
Context: SQL statement "INSERT INTO TECNOLOGIAS ( TCN_ID, TCN_NOME, TCN_NFGVT, TCN_TRIAGEM, TCN_VALORADO, TCN_HOMOLOGADA, TCN_ORDEM, GRU_ID, TCN_ATIVA, TIPO, TIPO_EQUIP ) VALUES ( cDados.TCN_ID, cDados.TCN_NOME, cDados.TCN_NFGVT, cDados.TCN_TRIAGEM, cDados.TCN_VALORADO, cDados.TCN_HOMOLOGADA, cDados.TCN_ORDEM, cDados.GRU_ID, cDados.TCN_ATIVA, cDados.TIPO, cDados.TIPO_EQUIP )" PL/pgSQL function rs_tecnologia_manutencao(character varying) line 102 at SQL statement
Statement: SELECT * FROM RS_TECNOLOGIA_MANUTENCAO( '{"id" :"0", "nome" :"GPON WIFI 7", "usuario" :"80", "grupo" :"2", "triagem" :"N", "nfgvt" :"S", "valorado" :"N", "homologada" :"S", "ordem" :"100", "categorias" : [{"categoria":"3"},{"categoria":"16"},{"categoria":"17"},{"categoria":"18"},{"categoria":"19"},{"categoria":"20"},{"categoria":"2"},{"categoria":"11"}], "ativa" :"S"}' )Date: 2026-08-10 10:30:10 Database: contagem Application: [unknown] User: intelifix Remote: [local]
7 8 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 10 14 3 15 5 - ERROR: trailing junk after numeric literal at or near "80D04ABC4420" at character 27
- ERROR: trailing junk after numeric literal at or near "80D04ABC4420" at character 27
- ERROR: trailing junk after numeric literal at or near "80D04ABC4420" at character 27
Statement: SELECT * FROM RS_ETIQUETA(80D04ABC4420)
Date: 2026-08-10 14:28:50 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(80D04ABC4420)
Date: 2026-08-10 14:28:50 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(80D04ABC4420)
Date: 2026-08-10 14:28:50 Database: rio Application: [unknown] User: etiquetas Remote: [local]
8 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 10 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-08-10 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-10 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-08-10 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
9 5 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Aug 10 10 3 15 2 - ERROR: column "dc" does not exist at character 27
- ERROR: column "dc" does not exist at character 27
- ERROR: column "dc" does not exist at character 27
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-89-52-51)
Date: 2026-08-10 10:59:10 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-89-52-51)
Date: 2026-08-10 10:59:10 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-89-52-51)
Date: 2026-08-10 10:59:10 Database: rio Application: [unknown] User: etiquetas Remote: [local]
10 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Aug 10 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-10 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-10 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-10 05:32:05 Database: contagem Application: psql User: intelifix Remote: [local]
11 2 ERROR: invalid input syntax for type integer: ...
Times Reported Most Frequent Error / Event #11
Day Hour Count Aug 10 07 1 14 1 - ERROR: invalid input syntax for type integer: ""
- ERROR: invalid input syntax for type integer: ""
Context: PL/pgSQL function rs_pre_alerta_tela(text) line 30 at assignment
Statement: SELECT * FROM RS_PRE_ALERTA_TELA('{"barra1":"485754433024C9B8","barra2":"9025F2945305","barra3":"WIFITWPASCLARO_945305PAH%C=","lote":""}');Date: 2026-08-10 07:28:14 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL function rs_pre_alerta_tela(text) line 30 at assignment
Statement: SELECT * FROM RS_PRE_ALERTA_TELA('{"barra1":"485754436BB241B6","barra2":"905E44486785","barra3":"WIFITWPASCLARO_486785P9H","lote":""}');Date: 2026-08-10 14:52:35 Database: contagem Application: [unknown] User: intelifix Remote: [local]
12 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #12
Day Hour Count Aug 10 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-10 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-10 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
13 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #13
Day Hour Count Aug 10 09 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000287863"
Date: 2026-08-10 09:28:44
14 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #14
Day Hour Count Aug 10 03 1 - LOG: database system was shut down at 2026-08-10 03:05:01 -03
Date: 2026-08-10 03:05:02
15 1 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "...", line 21, in <module> os.chmod(...) PL/Python function "..." PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Times Reported Most Frequent Error / Event #15
Day Hour Count Aug 10 19 1 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-10 19:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
16 1 ERROR: unterminated quoted string at or near "..."id"..."0"..."nome"..."GPON WIFI 7"..."usuario"..."80"..."grupo"..."2"..."triagem"..."S"..."nfgvt"..."S"..."valorado"..."S"..."homologada"..."S"..."ordem"..."100"..."categorias"..."categoria"..."3"..."categoria"..."16"..."categoria"..."17"..."categoria"..."18"..."categoria"..."19"..."categoria"..."20"..."categoria"..."2"..."categoria"..."11"..."
Times Reported Most Frequent Error / Event #16
Day Hour Count Aug 10 11 1 - ERROR: unterminated quoted string at or near "'{"id" :"0",^M "nome" :"GPON WIFI 7",^M "usuario" :"80",^M "grupo" :"2",^M "triagem" :"S",^M "nfgvt" :"S",^M "valorado" :"S",^M "homologada" :"S",^M "ordem" :"100", ^M "categorias" : [{"categoria":"3"},{"categoria":"16"},{"categoria":"17"},{"categoria":"18"},{"categoria":"19"},{"categoria":"20"},{"categoria":"2"},{"categoria":"11"}], ^M " at character 42
Statement: SELECT * FROM RS_TECNOLOGIA_MANUTENCAO( '{"id" :"0",^M "nome" :"GPON WIFI 7",^M "usuario" :"80",^M "grupo" :"2",^M "triagem" :"S",^M "nfgvt" :"S",^M "valorado" :"S",^M "homologada" :"S",^M "ordem" :"100", ^M "categorias" : [{"categoria":"3"},{"categoria":"16"},{"categoria":"17"},{"categoria":"18"},{"categoria":"19"},{"categoria":"20"},{"categoria":"2"},{"categoria":"11"}], ^M
Date: 2026-08-10 11:21:27 Database: contagem Application: pgAdmin 4 - CONN:6048339 User: lenon Remote: 172.20.0.3
17 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #17
Day Hour Count Aug 10 09 1 - LOG: process 3324242 still waiting for AccessExclusiveLock on relation 3600595 of database 358220 after 1000.248 ms
Detail: Process holding the lock: 3325363. Wait queue: 3324242.
Statement: DROP TABLE IF EXISTS temp0000287863;Date: 2026-08-10 09:28:44 Database: rio Application: [unknown] User: intelifix Remote: [local]