pgBadger-
Global information
- Generated on Sat Aug 29 23:50:15 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 35,410 log entries in 13s
- Log start from 2026-08-28 00:00:55 to 2026-08-28 23:59:46
-
Overview
Global Stats
- 349 Number of unique normalized queries
- 5,488 Number of queries
- 8h12s Total query duration
- 2026-08-28 00:02:34 First query
- 2026-08-28 23:52:26 Last query
- 5 queries/s at 2026-08-28 10:40:33 Query peak
- 8h12s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h12s Execute total duration
- 3,201 Number of events
- 14 Number of unique normalized events
- 3,150 Max number of times the same event was reported
- 0 Number of cancellation
- 332 Total number of automatic vacuums
- 726 Total number of automatic analyzes
- 12 Number temporary file
- 243.05 MiB Max size of temporary file
- 103.92 MiB Average size of temporary file
- 343 Total number of sessions
- 8 sessions at 2026-08-28 14:18:52 Session peak
- 13d27m18s Total duration of sessions
- 54m39s Average duration of sessions
- 16 Average queries per session
- 1m24s Average queries duration per session
- 53m15s Average idle time per session
- 357 Total number of connections
- 8 connections/s at 2026-08-28 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-28 10:40:33 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-28 10:40:33 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2026-08-28 23:51:14 Date
Queries duration
Key values
- 8h12s 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 28 00 28 0ms 31s916ms 6s754ms 8s272ms 21s313ms 1m15s 01 49 0ms 5s429ms 1s83ms 6s325ms 8s777ms 9s543ms 02 20 0ms 5s628ms 2s355ms 6s157ms 8s270ms 9s319ms 03 20 0ms 6s757ms 2s431ms 6s152ms 7s582ms 11s165ms 04 35 0ms 5s697ms 1s459ms 6s356ms 7s786ms 9s202ms 05 50 0ms 10m14s 27s745ms 10s531ms 3m 10m14s 06 31 0ms 1m33s 7s223ms 5s634ms 36s323ms 1m35s 07 371 0ms 9m45s 6s957ms 1m18s 5m39s 9m49s 08 499 150ms 7m15s 4s623ms 1m3s 6m36s 9m30s 09 608 150ms 7m15s 4s12ms 1m16s 5m48s 7m19s 10 624 150ms 7m13s 3s866ms 1m4s 5m41s 7m41s 11 493 150ms 7m33s 4s639ms 48s340ms 5m58s 7m38s 12 146 0ms 7m19s 7s900ms 39s160ms 2m28s 7m25s 13 251 0ms 6m8s 4s417ms 37s253ms 1m7s 6m45s 14 733 150ms 6m50s 4s453ms 1m40s 6m37s 9m48s 15 426 0ms 6m51s 3s123ms 45s987ms 1m4s 6m55s 16 281 0ms 6m4s 3s357ms 13s653ms 25s409ms 6m55s 17 247 0ms 6m1s 3s84ms 6s964ms 12s114ms 6m59s 18 71 0ms 5m44s 9s398ms 6s377ms 53s361ms 5m48s 19 24 0ms 5m56s 26s704ms 5s263ms 52s373ms 5m56s 20 124 0ms 5m54s 9s686ms 1m8s 1m33s 6m56s 21 30 0ms 5m48s 21s64ms 6s684ms 46s385ms 5m48s 22 30 0ms 5m38s 21s844ms 9s294ms 47s497ms 5m38s 23 297 0ms 1m37s 8s163ms 1m5s 1m11s 2m6s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 28 00 5 0 10s197ms 0ms 0ms 1s450ms 01 31 0 268ms 315ms 471ms 808ms 02 2 0 421ms 0ms 0ms 0ms 03 1 0 543ms 0ms 0ms 0ms 04 17 0 325ms 0ms 361ms 1s26ms 05 29 0 295ms 356ms 469ms 847ms 06 14 0 10s310ms 0ms 0ms 45s943ms 07 280 0 7s858ms 15s732ms 1m18s 7m26s 08 365 0 5s125ms 10s407ms 33s570ms 7m21s 09 460 0 4s580ms 19s23ms 48s394ms 6m1s 10 498 0 3s898ms 16s313ms 37s472ms 7m12s 11 406 0 5s151ms 13s607ms 48s340ms 6m6s 12 103 0 9s894ms 5s110ms 12s382ms 3m51s 13 184 0 5s85ms 5s787ms 27s308ms 3m21s 14 561 0 4s17ms 32s507ms 51s203ms 6m39s 15 339 0 3s393ms 11s272ms 36s315ms 3m59s 16 210 0 3s957ms 7s429ms 11s85ms 3m42s 17 206 0 3s456ms 2s607ms 5s314ms 3m26s 18 24 0 25s23ms 0ms 2s660ms 3m6s 19 6 0 1m40s 0ms 0ms 3m14s 20 17 86 11s203ms 31s158ms 1m2s 3m7s 21 9 0 1m4s 0ms 0ms 3m7s 22 6 0 1m39s 0ms 0ms 3m28s 23 25 272 8s163ms 1m3s 1m5s 1m15s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 28 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 28 00 0 1 1.00 0.00% 01 0 1 1.00 0.00% 02 0 1 1.00 0.00% 03 0 1 1.00 0.00% 04 0 3 3.00 0.00% 05 0 2 2.00 0.00% 06 0 2 2.00 0.00% 07 0 11 11.00 0.00% 08 0 11 11.00 0.00% 09 0 10 10.00 0.00% 10 0 11 11.00 0.00% 11 0 11 11.00 0.00% 12 0 5 5.00 0.00% 13 0 8 8.00 0.00% 14 0 9 9.00 0.00% 15 0 8 8.00 0.00% 16 0 6 6.00 0.00% 17 0 3 3.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 3 3.00 0.00% Day Hour Count Average / Second Aug 28 00 17 0.00/s 01 10 0.00/s 02 8 0.00/s 03 18 0.01/s 04 9 0.00/s 05 10 0.00/s 06 16 0.00/s 07 18 0.01/s 08 22 0.01/s 09 21 0.01/s 10 21 0.01/s 11 17 0.00/s 12 11 0.00/s 13 18 0.01/s 14 20 0.01/s 15 15 0.00/s 16 21 0.01/s 17 11 0.00/s 18 13 0.00/s 19 11 0.00/s 20 14 0.00/s 21 11 0.00/s 22 9 0.00/s 23 16 0.00/s Day Hour Count Average Duration Average idle time Aug 28 00 9 58m24s 58m3s 01 16 1h45s 1h42s 02 10 1h18s 1h13s 03 18 21m5s 21m3s 04 8 1h2m37s 1h2m31s 05 9 1h40s 58m6s 06 10 57m49s 57m27s 07 17 51m19s 48m48s 08 15 57m34s 55m 09 21 58m 56m4s 10 22 54m8s 52m18s 11 17 58m49s 56m35s 12 16 57m3s 55m51s 13 12 57m11s 55m39s 14 20 53m59s 51m15s 15 16 58m11s 56m47s 16 16 57m15s 56m16s 17 19 1h1m7s 1h27s 18 11 1h10s 59m9s 19 11 1h49s 59m50s 20 13 47m7s 45m34s 21 11 55m27s 54m30s 22 11 1h16s 59m17s 23 15 39m27s 36m45s -
Connections
Established Connections
Key values
- 8 connections Connection Peak
- 2026-08-28 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 357 connections Total
Connections per user
Key values
- intelifix Main User
- 357 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-08-28 14:18:52 Date
Histogram of session times
Key values
- 288 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 343 sessions Total
Sessions per user
Key values
- intelifix Main User
- 343 sessions Total
Sessions per host
Key values
- [local] Main Host
- 343 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 40,197 buffers Checkpoint Peak
- 2026-08-28 00:09:47 Date
- 270.030 seconds Highest write time
- 0.201 seconds Sync time
Checkpoints Wal files
Key values
- 10 files Wal files usage Peak
- 2026-08-28 14:29:38 Date
Checkpoints distance
Key values
- 314.92 Mo Distance Peak
- 2026-08-28 14:49:38 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 28 00 55,942 670.836s 0.097s 670.973s 01 3,613 362.338s 0.35s 362.793s 02 1,773 177.841s 0.08s 178.072s 03 1,887 189.379s 0.039s 189.51s 04 3,205 322.018s 0.235s 322.292s 05 9,794 978.026s 0.18s 978.261s 06 6,933 533.814s 0.006s 533.831s 07 43,146 2,705.611s 0.236s 2,705.952s 08 41,406 3,206.578s 0.346s 3,207.044s 09 47,706 3,239.326s 0.349s 3,239.803s 10 49,388 3,239.052s 0.49s 3,239.675s 11 58,691 3,239.027s 0.418s 3,239.591s 12 23,569 1,613.291s 0.158s 1,613.56s 13 21,915 1,495.525s 0.226s 1,495.827s 14 68,640 3,203.899s 0.666s 3,204.809s 15 34,541 2,927.856s 0.21s 2,928.182s 16 23,950 1,735.981s 0.338s 1,736.48s 17 9,630 978.114s 0.276s 978.465s 18 3,615 363.152s 0.055s 363.25s 19 25 2.52s 0.003s 2.529s 20 1,379 173.437s 0.013s 173.532s 21 2,051 205.704s 0.099s 205.864s 22 2,602 260.691s 0.058s 260.788s 23 379 38.075s 0.113s 38.31s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 28 00 0 0 10 508 0.063s 0.006s 01 0 0 1 751 0.065s 0.011s 02 0 0 0 395 0.063s 0.006s 03 0 0 1 362 0.005s 0.006s 04 0 0 1 687 0.065s 0.01s 05 0 0 4 715 0.062s 0.013s 06 0 0 1 184 0.002s 0.002s 07 0 0 28 3,778 0.062s 0.012s 08 0 0 31 5,346 0.063s 0.012s 09 0 0 34 5,413 0.033s 0.012s 10 0 0 35 5,652 0.034s 0.012s 11 0 0 28 5,010 0.063s 0.012s 12 0 0 12 2,246 0.061s 0.012s 13 0 0 14 3,134 0.051s 0.012s 14 0 0 73 5,761 0.065s 0.012s 15 0 0 17 4,851 0.013s 0.012s 16 0 0 17 3,467 0.064s 0.012s 17 0 0 3 2,665 0.065s 0.012s 18 0 0 1 721 0.004s 0.008s 19 0 0 0 5 0.003s 0.001s 20 0 0 1 80 0.004s 0.003s 21 0 0 1 327 0.065s 0.011s 22 0 0 0 488 0.017s 0.009s 23 0 0 0 98 0.064s 0.021s Day Hour Count Avg time (sec) Aug 28 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 28 00 26,502.33 kB 66,186.17 kB 01 1,988.89 kB 32,676.33 kB 02 1,499.33 kB 15,512.50 kB 03 1,479.29 kB 3,442.71 kB 04 2,012.12 kB 2,819.88 kB 05 7,938.44 kB 14,154.78 kB 06 9,788.50 kB 12,533.50 kB 07 37,540.33 kB 58,553.42 kB 08 42,771.17 kB 92,357.33 kB 09 45,585.00 kB 83,049.83 kB 10 47,999.17 kB 81,329.67 kB 11 38,103.08 kB 73,360.33 kB 12 17,350.00 kB 53,139.75 kB 13 18,905.25 kB 31,760.67 kB 14 99,632.17 kB 140,796.67 kB 15 22,888.92 kB 83,875.58 kB 16 22,771.50 kB 63,564.92 kB 17 4,424.33 kB 27,411.00 kB 18 2,639.71 kB 11,482.29 kB 19 194.00 kB 7,949.00 kB 20 5,358.00 kB 11,315.00 kB 21 1,028.22 kB 6,563.22 kB 22 1,657.25 kB 3,585.38 kB 23 217.33 kB 2,187.17 kB -
Temporary Files
Size of temporary files
Key values
- 486.09 MiB Temp Files size Peak
- 2026-08-28 05:32:06 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-28 05:32:14 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 28 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 12 1.22 GiB 103.92 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 944.23 MiB 72.49 MiB 243.05 MiB 118.03 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-28 05:32:15 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-28 05:32:06 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 302.86 MiB 56.29 MiB 92.64 MiB 75.72 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-28 05:30:45 Duration: 42s816ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-28 05:30:42 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 243.05 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-28 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 243.05 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-28 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 92.64 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-28 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 92.64 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-28 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 80.25 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-28 05:32:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 80.16 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-28 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 80.16 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-28 05:32:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 72.57 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-28 05:32:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 72.49 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-28 05:32:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 72.49 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-28 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 61.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-28 05:30:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 56.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-28 05:30:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.31 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-08-28 05:11:04 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.31 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database rio - 2026-08-28 05:11:04 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (85) Main table analyzed (database rio)
- 726 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 85 rio.pg_catalog.pg_class 50 brasilia.pg_catalog.pg_attribute 44 rio.public.usuarios 42 rio.pg_catalog.pg_type 39 rio.public.temp0000289984 31 rio.public.temp0000289914 29 rio.pg_catalog.pg_index 27 brasilia.pg_catalog.pg_class 22 rio.pg_catalog.pg_depend 20 rio.public.temp0000289924 19 brasilia.pg_catalog.pg_type 19 rio.public.temp0000289956 18 brasilia.public.temp0000239092 17 contagem.public.temp0000227001 17 rio.public.temp0000289968 14 rio.public.temp0000289448 14 rio.public.temp0000289916 12 rio.public.temp0000289938 12 contagem.public.temp0000226995 12 brasilia.pg_catalog.pg_index 12 contagem.public.temp0000226975 11 rio.public.temp0000289223 11 rio.public.temp0000289990 11 rio.public.temp0000289900 10 brasilia.pg_catalog.pg_depend 10 rio.public.temp0000289964 9 brasilia.public.usuarios 9 rio.public.temp0000289940 8 rio.public.temp0000289918 7 rio.public.temp0000289370 7 rio.public.temp0000289806 6 contagem.pg_catalog.pg_attribute 5 rio.public.tmp_drill_0320 5 brasilia.public.temp0000239166 5 rio.public.temp0000289954 5 brasilia.public.nf_entrada 4 rio.public.temp0000289730 4 brasilia.pg_catalog.pg_shdepend 3 contagem.pg_catalog.pg_class 2 brasilia.public.temp0000239150 2 contagem.pg_catalog.pg_type 2 contagem.pg_catalog.pg_shdepend 2 postgres.pg_catalog.pg_shdepend 2 rio.public.temp0000289902 2 rio.pg_catalog.pg_shdepend 2 brasilia.public.temp0000239114 2 brasilia.public.temp0000239120 2 brasilia.public.temp0000239098 1 rio.public.temp0000289920 1 contagem.public.usuarios 1 brasilia.public.temp0000239130 1 rio.public.temp0000289922 1 brasilia.public.temp0000239164 1 brasilia.public.temp0000239162 1 rio.public.temp0000289912 1 brasilia.public.temp0000239148 1 brasilia.public.temp0000239116 1 brasilia.public.temp0000239112 1 rio.public.temp0000289388 1 rio.public.temp0000289934 1 brasilia.public.temp0000239160 1 rio.public.temp0000289904 1 rio.public.temp0000289944 1 rio.public.temp0000289982 1 rio.public.temp0000289970 1 brasilia.public.temp0000239170 1 contagem.pg_catalog.pg_index 1 rio.public.temp0000289978 1 brasilia.public.temp0000239144 1 rio.public.temp0000289998 1 Total 726 Vacuums per table
Key values
- pg_catalog.pg_attribute (33) Main table vacuumed on database rio
- 332 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 33 29 0 0 0 0 0 15,950 4,504 6,419,142 261 6,370 rio.public.temp0000289914 30 0 0 0 0 0 0 27,126 3,736 6,338,721 0 0 rio.pg_catalog.pg_class 25 21 0 0 0 0 0 3,900 1,272 1,924,550 78 391 rio.public.temp0000289984 23 0 0 0 0 0 0 6,501 2,281 3,379,423 0 0 rio.pg_catalog.pg_type 18 18 0 0 0 0 0 1,536 445 597,812 58 209 brasilia.pg_catalog.pg_attribute 15 13 0 0 0 0 0 7,010 1,968 3,319,189 57 1,667 rio.public.temp0000289448 13 0 0 0 0 0 0 539 179 214,068 0 0 rio.public.temp0000289223 11 0 0 0 0 0 0 719 129 163,050 0 0 brasilia.pg_catalog.pg_class 11 9 0 0 0 0 0 1,873 502 815,796 17 69 rio.pg_catalog.pg_index 11 11 0 0 0 0 0 634 206 188,014 41 82 rio.public.temp0000289990 11 0 0 0 0 0 0 19,422 7,095 10,262,671 0 0 rio.public.temp0000289924 9 0 0 0 0 0 0 534 111 140,764 0 0 brasilia.pg_catalog.pg_type 9 7 0 0 0 0 0 726 228 332,580 12 50 rio.pg_catalog.pg_depend 9 9 0 0 0 0 0 2,867 1,050 1,540,363 67 550 rio.public.temp0000289964 9 0 0 0 0 0 0 8,840 3,553 5,072,904 0 0 rio.public.temp0000289370 7 0 0 0 0 0 0 485 38 34,327 0 0 rio.pg_catalog.pg_statistic 6 6 0 0 0 0 0 7,548 2,247 8,730,616 1,492 7,549 postgres.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 648 229 373,939 25 52 rio.public.tmp_drill_0320 5 5 0 0 0 0 0 1,738 15 295,635 0 0 brasilia.public.temp0000239166 5 0 0 0 0 0 0 1,245 20 76,470 0 0 brasilia.pg_catalog.pg_index 5 4 0 0 0 0 0 192 57 53,013 8 24 rio.public.temp0000289954 5 0 0 0 0 0 0 3,540 1,779 2,488,477 0 0 brasilia.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,170 366 567,026 9 120 rio.public.usuarios 4 4 0 0 0 0 0 102 43 80,672 3 3 rio.public.temp0000289968 4 0 0 0 0 0 0 32 21 6,119 0 0 rio.public.temp0000289730 4 0 0 0 0 0 0 3,535 1,775 2,483,227 0 0 rio.public.temp0000289806 4 0 0 0 0 0 0 337 124 198,347 0 0 rio.public.temp0000289938 4 0 0 0 0 0 0 397 198 322,802 0 0 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,719 476 2,332,903 151 516 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 237 63 241,123 17 40 contagem.pg_catalog.pg_attribute 2 2 0 0 0 0 0 1,002 355 571,057 6 145 contagem.public.usuarios 2 0 0 0 0 0 0 6 4 3,429 0 0 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,285 767 2,788,867 650 4,222 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,858 1,185 3,678,836 1,073 7,409 contagem.public.temp0000227001 2 0 0 0 0 0 0 143 12 10,202 0 0 brasilia.public.nf_entrada 2 2 0 0 0 0 0 358 153 383,550 12 17 rio.public.temp0000289912 1 0 0 0 0 0 0 83 82 163,889 0 0 brasilia.public.temp0000239148 1 0 0 0 0 0 0 249 249 397,632 0 0 brasilia.public.temp0000239098 1 0 0 0 0 0 0 248 4 15,235 0 0 contagem.pg_catalog.pg_type 1 1 0 0 0 0 0 72 32 49,765 0 0 contagem.pg_catalog.pg_class 1 1 0 0 0 0 0 105 43 52,159 2 6 rio.public.temp0000289922 1 0 0 0 0 0 0 8 6 2,139 0 0 rio.public.temp0000289918 1 0 0 0 0 0 0 83 6 5,807 0 0 rio.public.temp0000289940 1 0 0 0 0 0 0 86 6 5,991 0 0 contagem.pg_catalog.pg_index 1 1 0 0 0 0 0 37 16 14,654 0 0 contagem.public.temp0000226995 1 0 0 0 0 0 0 31 30 41,317 0 0 rio.public.temp0000289978 1 0 0 0 0 0 0 96 6 6,598 0 0 rio.public.temp0000289998 1 0 0 0 0 0 0 8 5 1,331 0 0 brasilia.public.temp0000239160 1 0 0 0 0 0 0 248 4 15,235 0 0 rio.public.temp0000289944 1 0 0 0 0 0 0 86 6 5,989 0 0 rio.public.temp0000289982 1 0 0 0 0 0 0 96 6 6,598 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 152 64 188,259 15 39 Total 332 162 0 0 0 0 0 130,442 37,751 67,402,282 4,054 29,530 Vacuum throughput per table
Key values
- pg_catalog.pg_attribute (2.62) 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 2.62 rio.public.temp0000289914 0 0 1.17 rio.pg_catalog.pg_class 0 0 0.83 rio.public.temp0000289984 0 0 0.65 rio.pg_catalog.pg_type 0 0 0.26 brasilia.pg_catalog.pg_attribute 0 0 1.44 rio.public.temp0000289448 0 0 0.1 rio.public.temp0000289223 0 0 0.06 brasilia.pg_catalog.pg_class 0 0 0.51 rio.pg_catalog.pg_index 0 0 0.18 rio.public.temp0000289990 0 0 0.68 rio.public.temp0000289924 0 0 0.07 brasilia.pg_catalog.pg_type 0 0 0.14 rio.pg_catalog.pg_depend 0 0 0.7 rio.public.temp0000289964 0 0 0.52 rio.public.temp0000289370 0 0 0.07 rio.pg_catalog.pg_statistic 0 0 1.05 postgres.pg_catalog.pg_shdepend 0 0 0.51 rio.public.tmp_drill_0320 0 0 0.05 brasilia.public.temp0000239166 0 0 0.01 brasilia.pg_catalog.pg_index 0 0 0.1 rio.public.temp0000289954 0 0 0.29 brasilia.pg_catalog.pg_depend 0 0 0.46 rio.public.usuarios 0 0 0 rio.public.temp0000289968 0 0 0.04 rio.public.temp0000289730 0 0 0.24 rio.public.temp0000289806 0 0 0.02 rio.public.temp0000289938 0 0 0.03 rio.pg_toast.pg_toast_2619 0 0 0.23 brasilia.pg_toast.pg_toast_2619 0 0 0.02 contagem.pg_catalog.pg_attribute 0 0 0.31 contagem.public.usuarios 0 0 0 brasilia.pg_catalog.pg_statistic 0 0 0.31 contagem.pg_catalog.pg_statistic 0 0 0.17 contagem.public.temp0000227001 0 0 0.02 brasilia.public.nf_entrada 0 0 0.1 rio.public.temp0000289912 0 0 0.01 brasilia.public.temp0000239148 0 0 0.01 brasilia.public.temp0000239098 0 0 0 contagem.pg_catalog.pg_type 0 0 0.06 contagem.pg_catalog.pg_class 0 0 0.12 rio.public.temp0000289922 0 0 0.01 rio.public.temp0000289918 0 0 0.01 rio.public.temp0000289940 0 0 0.01 contagem.pg_catalog.pg_index 0 0 0.07 contagem.public.temp0000226995 0 0 0.01 rio.public.temp0000289978 0 0 0.01 rio.public.temp0000289998 0 0 0.01 brasilia.public.temp0000239160 0 0 0 rio.public.temp0000289944 0 0 0.01 rio.public.temp0000289982 0 0 0.01 contagem.pg_toast.pg_toast_2619 0 0 0 Total 0 0 14.31 Tuples removed per table
Key values
- pg_catalog.pg_attribute (113238) Main table with removed tuples on database rio
- 262855 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 33 29 113,238 832,391 44,358 265 19,981 brasilia.pg_catalog.pg_attribute 15 13 63,212 345,093 16,674 0 8,982 rio.public.tmp_drill_0320 5 5 24,527 26,326 0 0 664 rio.pg_catalog.pg_statistic 6 6 11,406 48,909 223 0 7,716 rio.pg_catalog.pg_depend 9 9 8,187 172,885 1,193 0 1,647 rio.pg_catalog.pg_type 18 18 5,542 42,358 1,394 6 1,290 contagem.pg_catalog.pg_statistic 2 2 4,957 14,867 0 0 2,022 brasilia.pg_catalog.pg_statistic 2 2 4,892 15,288 0 0 2,144 contagem.pg_catalog.pg_attribute 2 2 4,375 47,217 0 0 1,052 brasilia.pg_catalog.pg_depend 4 4 4,155 74,196 2,383 34 699 postgres.pg_catalog.pg_shdepend 5 5 3,382 68,271 390 10 570 rio.pg_catalog.pg_class 25 21 2,955 92,995 7,315 27 2,919 brasilia.pg_catalog.pg_type 9 7 2,784 21,633 1,646 15 596 brasilia.pg_catalog.pg_class 11 9 2,773 42,804 4,083 24 1,381 rio.pg_catalog.pg_index 11 11 2,052 21,288 229 0 627 brasilia.pg_catalog.pg_index 5 4 1,384 9,880 455 3 259 brasilia.public.nf_entrada 2 2 1,176 10,227 617 0 304 rio.pg_toast.pg_toast_2619 3 3 1,048 2,294 11 7 844 rio.public.usuarios 4 4 183 2,454 418 0 84 brasilia.pg_toast.pg_toast_2619 2 2 158 248 0 29 76 contagem.pg_toast.pg_toast_2619 1 1 140 115 0 0 61 contagem.pg_catalog.pg_class 1 1 117 3,676 0 0 138 contagem.public.usuarios 2 0 112 48 0 0 4 contagem.pg_catalog.pg_type 1 1 56 2,239 0 0 59 contagem.pg_catalog.pg_index 1 1 44 1,897 0 0 46 rio.public.temp0000289924 9 0 0 23,344 0 182 522 rio.public.temp0000289912 1 0 0 1,139 0 53 75 brasilia.public.temp0000239148 1 0 0 3,268 0 0 256 rio.public.temp0000289223 11 0 0 37,795 0 440 840 brasilia.public.temp0000239098 1 0 0 3,261 0 0 256 rio.public.temp0000289984 23 0 0 228,040 0 495 14,097 rio.public.temp0000289914 30 0 0 510,233 0 480 36,640 rio.public.temp0000289968 4 0 0 14,339 0 194 318 rio.public.temp0000289964 9 0 0 224,239 0 0 16,128 rio.public.temp0000289922 1 0 0 1,144 0 52 76 rio.public.temp0000289918 1 0 0 1,139 0 53 75 rio.public.temp0000289940 1 0 0 1,188 0 50 78 rio.public.temp0000289730 4 0 0 99,591 0 0 7,168 brasilia.public.temp0000239166 5 0 0 16,318 0 0 1,280 contagem.public.temp0000226995 1 0 0 1,125 0 9 23 rio.public.temp0000289978 1 0 0 1,331 0 40 88 rio.public.temp0000289370 7 0 0 23,400 0 184 520 rio.public.temp0000289448 13 0 0 33,150 0 226 734 rio.public.temp0000289998 1 0 0 1,418 0 37 91 rio.public.temp0000289954 5 0 0 124,536 0 0 8,960 rio.public.temp0000289806 4 0 0 13,734 0 143 305 rio.public.temp0000289990 11 0 0 274,250 0 0 19,712 brasilia.public.temp0000239160 1 0 0 3,261 0 0 256 rio.public.temp0000289944 1 0 0 1,188 0 50 78 contagem.public.temp0000227001 2 0 0 2,472 0 33 127 rio.public.temp0000289938 4 0 0 16,494 0 147 365 rio.public.temp0000289982 1 0 0 1,331 0 40 88 Total 332 162 262,855 3,562,327 81,389 3,328 163,321 Pages removed per table
Key values
- public.temp0000289984 (495) Main table with removed pages on database rio
- 3328 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000289984 23 0 0 495 rio.public.temp0000289914 30 0 0 480 rio.public.temp0000289223 11 0 0 440 rio.pg_catalog.pg_attribute 33 29 113238 265 rio.public.temp0000289448 13 0 0 226 rio.public.temp0000289968 4 0 0 194 rio.public.temp0000289370 7 0 0 184 rio.public.temp0000289924 9 0 0 182 rio.public.temp0000289938 4 0 0 147 rio.public.temp0000289806 4 0 0 143 rio.public.temp0000289912 1 0 0 53 rio.public.temp0000289918 1 0 0 53 rio.public.temp0000289922 1 0 0 52 rio.public.temp0000289940 1 0 0 50 rio.public.temp0000289944 1 0 0 50 rio.public.temp0000289978 1 0 0 40 rio.public.temp0000289982 1 0 0 40 rio.public.temp0000289998 1 0 0 37 brasilia.pg_catalog.pg_depend 4 4 4155 34 contagem.public.temp0000227001 2 0 0 33 brasilia.pg_toast.pg_toast_2619 2 2 158 29 rio.pg_catalog.pg_class 25 21 2955 27 brasilia.pg_catalog.pg_class 11 9 2773 24 brasilia.pg_catalog.pg_type 9 7 2784 15 postgres.pg_catalog.pg_shdepend 5 5 3382 10 contagem.public.temp0000226995 1 0 0 9 rio.pg_toast.pg_toast_2619 3 3 1048 7 rio.pg_catalog.pg_type 18 18 5542 6 brasilia.pg_catalog.pg_index 5 4 1384 3 brasilia.public.temp0000239148 1 0 0 0 rio.public.usuarios 4 4 183 0 rio.pg_catalog.pg_statistic 6 6 11406 0 rio.pg_catalog.pg_index 11 11 2052 0 brasilia.public.temp0000239098 1 0 0 0 rio.pg_catalog.pg_depend 9 9 8187 0 contagem.pg_catalog.pg_attribute 2 2 4375 0 contagem.public.usuarios 2 0 112 0 contagem.pg_catalog.pg_type 1 1 56 0 brasilia.pg_catalog.pg_statistic 2 2 4892 0 contagem.pg_catalog.pg_class 1 1 117 0 contagem.pg_catalog.pg_statistic 2 2 4957 0 rio.public.temp0000289964 9 0 0 0 contagem.pg_catalog.pg_index 1 1 44 0 rio.public.temp0000289730 4 0 0 0 rio.public.tmp_drill_0320 5 5 24527 0 brasilia.public.temp0000239166 5 0 0 0 rio.public.temp0000289954 5 0 0 0 brasilia.pg_catalog.pg_attribute 15 13 63212 0 rio.public.temp0000289990 11 0 0 0 brasilia.public.temp0000239160 1 0 0 0 brasilia.public.nf_entrada 2 2 1176 0 contagem.pg_toast.pg_toast_2619 1 1 140 0 Total 332 162 262,855 3,328 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 28 00 0 0 01 0 6 02 0 0 03 0 0 04 0 5 05 6 3 06 0 1 07 35 53 08 29 74 09 39 85 10 41 88 11 18 54 12 9 22 13 17 45 14 69 119 15 25 69 16 38 65 17 4 29 18 0 6 19 0 0 20 0 0 21 2 2 22 0 0 23 0 0 - 0.31 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 2 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 2m20s 2m20s 2m20s 2m20s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-28 14:27:35 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-28 07:15:22 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-28 09:05:17 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
2 1 1s2ms 1s2ms 1s2ms 1s2ms drop table if exists temp0000289914;-
DROP TABLE IF EXISTS temp0000289914;
Date: 2026-08-28 14:30:12 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
DROP TABLE IF EXISTS temp0000289914;
Date: 2026-08-28 14:30:12 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Queries that waited the most
Rank Wait time Query 1 2m20s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-28 14:27:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1s2ms DROP TABLE IF EXISTS temp0000289914;[ Date: 2026-08-28 14:30:12 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 3,798 Total read queries
- 1,167 Total write queries
Queries by database
Key values
- rio Main database
- 3,619 Requests
- 6h2m15s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 5,371 Requests
User Request type Count Duration etiquetas Total 17 7s217ms select 17 7s217ms intelifix Total 5,371 7h57m48s copy to 358 49m31s ddl 809 39m53s others 523 52m6s select 3,681 5h36m16s lenon Total 100 2m16s select 100 2m16s Duration by user
Key values
- 7h57m48s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 17 7s217ms select 17 7s217ms intelifix Total 5,371 7h57m48s copy to 358 49m31s ddl 809 39m53s others 523 52m6s select 3,681 5h36m16s lenon Total 100 2m16s select 100 2m16s Queries by host
Key values
- [local] Main host
- 5,488 Requests
- 8h12s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,372 Requests
- 4h5m54s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-28 01:25:09 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,621 100-500ms duration
Slowest individual queries
Rank Duration Query 1 10m14s analyze verbose;[ Date: 2026-08-28 05:10:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-28 07:14:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-28 11:12:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 7m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-28 12:12:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 7m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-28 09:12:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 7m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-28 08:12:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 7m13s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-08-03''),DATE(''2026-08-27'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-08-28 10:45:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 7m13s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029201, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-28 07:20:13 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 6m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-28 15:11:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 6m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-28 14:11:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m46s analyze verbose;[ Date: 2026-08-28 05:17:01 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
12 6m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-28 10:11:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m25s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029211, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-28 08:54:54 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 6m20s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029236, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-28 14:27:33 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 6m11s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029242, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-28 14:38:13 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 6m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-28 13:11:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 6m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-28 16:11:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 6m2s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029225, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-28 11:53:26 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 6m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-28 17:11:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-28 19:10:57 - 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 1h54m6s 48 1s534ms 9m45s 2m22s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 28 07 3 10m43s 3m34s 08 3 7m35s 2m31s 09 3 8m12s 2m44s 10 3 7m4s 2m21s 11 3 8m30s 2m50s 12 3 7m41s 2m33s 13 3 6m30s 2m10s 14 3 7m13s 2m24s 15 3 7m12s 2m24s 16 3 6m23s 2m7s 17 3 6m22s 2m7s 18 3 6m4s 2m1s 19 3 6m15s 2m5s 20 3 6m12s 2m4s 21 3 6m5s 2m1s 22 3 5m55s 1m58s [ User: intelifix - Total duration: 1h54m6s - Times executed: 48 ]
[ Application: psql - Total duration: 1h54m6s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-28 07:14:46 Duration: 9m45s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-28 11:12:34 Duration: 7m33s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-28 12:12:21 Duration: 7m19s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
2 1h26m42s 236 150ms 7m13s 22s43ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 28 07 17 15m27s 54s535ms 08 21 12m52s 36s793ms 09 31 12m46s 24s713ms 10 32 13m57s 26s171ms 11 27 12m10s 27s55ms 12 4 2m57s 44s452ms 13 15 13s309ms 887ms 14 43 14m16s 19s909ms 15 22 1m13s 3s329ms 16 16 42s402ms 2s650ms 17 6 3s941ms 656ms 18 2 1s556ms 778ms [ User: intelifix - Total duration: 1h26m42s - Times executed: 236 ]
[ Application: [unknown] - Total duration: 1h26m42s - Times executed: 236 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-08-03''),DATE(''2026-08-27'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-08-28 10:45:51 Duration: 7m13s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029201, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-28 07:20:13 Duration: 7m13s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029211, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-28 08:54:54 Duration: 6m25s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
3 1h11m16s 47 272ms 4m50s 1m30s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 28 07 3 5m57s 1m59s 08 3 4m37s 1m32s 09 3 6m13s 2m4s 10 3 3m58s 1m19s 11 2 6m24s 3m12s 12 3 4m27s 1m29s 13 3 3m55s 1m18s 14 3 4m42s 1m34s 15 3 4m38s 1m32s 16 3 3m48s 1m16s 17 3 3m52s 1m17s 18 3 3m37s 1m12s 19 3 3m47s 1m15s 20 3 3m40s 1m13s 21 3 3m36s 1m12s 22 3 3m58s 1m19s [ User: intelifix - Total duration: 1h11m16s - Times executed: 47 ]
[ Application: psql - Total duration: 1h11m16s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-28 11:19:47 Duration: 4m50s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-28 09:19:13 Duration: 4m31s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-28 07:21:28 Duration: 4m19s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
4 24m 1,218 150ms 7s16ms 1s182ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 28 07 77 1m29s 1s156ms 08 126 2m13s 1s60ms 09 164 3m40s 1s346ms 10 219 3m26s 942ms 11 174 3m46s 1s299ms 12 47 1m15s 1s598ms 13 60 1m23s 1s392ms 14 201 3m59s 1s192ms 15 104 2m6s 1s217ms 16 29 27s692ms 954ms 17 17 12s94ms 711ms [ User: intelifix - Total duration: 24m - Times executed: 1218 ]
[ Application: [unknown] - Total duration: 24m - Times executed: 1218 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282319, 450, '834353951000256,241646529293,241694269913,241600839706,241708473544,241607307789,241694272944,241679468086,241658975761,241658967982,241651263247,241699868709,241655584353,241706827176,241608916577,241656986678,230048242542,241677537090,241593012736,241658170723,241709816469,241702765972,241703474358,241609868803,241691339010,241618354356,241621484044,241631609802,241668016677,241649738181,241682786884,241694761129,241712258302,241599644045,241630736877,241694311332,241694644652,241634549416,241592640624,241631713954', '',0320,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":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-28 09:39:32 Duration: 7s16ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282310, 450, 'CP2239LV3AD,4075C3BFB0FC$CP2301LV39G,B85E71E45EF8$CP2234LV8D9,4075C3B873DC$CP2134LV6BJ,ECA81F232904$CP2238LV27L,4075C3BEA590$CP2324LV0LK,CCF3C83731A4$CP2435LV6CQ,C4509CF258EC$CP2238LV6C5,4075C3BFBB74$CP2345LV46V,CCF3C84788EC$CP2302LV5WZ,B85E71E8F350$CP2204LV56Q,1C9D726A4FBC$CP2237LV7D9,4075C3BAE608$CP2429LV61B,C4509CBD6BF4$CP2439LV5DJ,C4509CF440E4$CP2233LVAN0,4075C3B4F75C$CP2218LV4MQ,00CB7ADDB8D4$CP2208LVA0F,3C82C0CA1E98$CP2208LVDNW,3C82C0CB4BD8$CP2143LV07E,ECA81FFC2004$CP2211LV1WK,3C82C0C54B20$CP2346LV7D7,400FC17F1144$CP2247LVA5R,B85E71EE7A64$CP2239LVMBG,B85E71BCB074$CP2131LVKL8,ECA81F1A753C$CP2522LV04E,B85E710CD248$CP2527LV7U1,F8D2AC48E7E8$CP2436LV2JY,C4509CF2BF04$CP2050LV49Q,484BD4A5AC1C$CP2529LV5YQ,3C82C08A6258$CP2249LVBD2,B85E71E1382C$CP2435LV27P,C4509CF124AC$CP2207LV7U4,3C82C06ABDF0$CP2439LV6Q6,C4509CF3CBB4$CP2210LV3MC,3C82C0CB73D8$CP2233LV5CD,4075C3B493AC$CP2242LV0RL,B85E71C9DA24$CP2120LV1DH,08A7C06BA3BC$CP2146LV309,D4E2CB903DC4$CP2234LV7NT,4075C3B8B310$CP2146LV1UE,D4E2CB8F4434', '',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":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-28 09:00:57 Duration: 6s463ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282273, 503, '833321946002018,230035540618,230027443340,230020625974,230006288188,230052563143,230053042539,229978507183,230053048498,230032458890,230050786684,229971105664,229975212833,229977504549,230054204863,229981879701', '',0295,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-28 08:06:14 Duration: 6s167ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
5 20m1s 3 3m 10m14s 6m40s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 28 05 3 20m1s 6m40s [ User: intelifix - Total duration: 20m1s - Times executed: 3 ]
[ Application: psql - Total duration: 20m1s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-28 05:10:15 Duration: 10m14s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
analyze verbose;
Date: 2026-08-28 05:17:01 Duration: 6m46s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
analyze verbose;
Date: 2026-08-28 05:20:02 Duration: 3m Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
6 17m54s 80 1s712ms 1m33s 13s436ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 28 06 1 1m33s 1m33s 07 5 54s632ms 10s926ms 08 7 2m3s 17s701ms 09 11 2m8s 11s684ms 10 5 1m19s 15s955ms 11 11 2m8s 11s696ms 12 1 7s659ms 7s659ms 13 5 1m5s 13s105ms 14 11 3m6s 16s957ms 15 8 2m20s 17s502ms 16 4 21s193ms 5s298ms 17 8 33s645ms 4s205ms 18 3 11s282ms 3s760ms [ User: intelifix - Total duration: 17m54s - Times executed: 80 ]
[ Application: [unknown] - Total duration: 17m54s - Times executed: 80 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-28', 0366, '', '', 0, 6, '2026-08-01');
Date: 2026-08-28 06:54:59 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-28', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-28 08:21:03 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-28', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-28 11:54:10 Duration: 33s903ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
7 16m6s 277 164ms 2m29s 3s490ms call rs_giga_triagem (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 28 00 12 40s300ms 3s358ms 01 12 30s833ms 2s569ms 02 12 31s613ms 2s634ms 03 12 30s643ms 2s553ms 04 12 30s849ms 2s570ms 05 12 33s290ms 2s774ms 06 12 32s875ms 2s739ms 07 13 46s207ms 3s554ms 08 12 36s289ms 3s24ms 09 12 44s46ms 3s670ms 10 12 40s69ms 3s339ms 11 12 38s217ms 3s184ms 12 12 35s733ms 2s977ms 13 12 37s744ms 3s145ms 14 12 3m5s 15s496ms 15 12 38s329ms 3s194ms 16 12 35s533ms 2s961ms 17 12 32s164ms 2s680ms 18 12 32s68ms 2s672ms 19 12 32s437ms 2s703ms 20 12 37s726ms 3s143ms 21 12 31s570ms 2s630ms 22 12 32s398ms 2s699ms [ User: intelifix - Total duration: 16m6s - Times executed: 277 ]
[ Application: psql - Total duration: 16m6s - Times executed: 277 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-28 14:27:35 Duration: 2m29s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-28 07:15:22 Duration: 15s771ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-28 09:05:17 Duration: 10s283ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
8 12m18s 58 10s468ms 21s534ms 12s737ms create table temp0000289914 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 28 07 12 2m25s 12s87ms 08 15 3m1s 12s107ms 09 8 1m46s 13s265ms 10 12 2m33s 12s805ms 11 3 44s223ms 14s741ms 14 8 1m48s 13s512ms [ User: intelifix - Total duration: 12m18s - Times executed: 58 ]
[ Application: [unknown] - Total duration: 12m18s - Times executed: 58 ]
-
CREATE TABLE temp0000289914 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 09:48:11 Duration: 21s534ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289914 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 11:46:37 Duration: 19s376ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289914 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 10:14:48 Duration: 18s664ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
9 8m25s 138 151ms 20s861ms 3s661ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 28 00 6 34s907ms 5s817ms 01 6 13s964ms 2s327ms 02 6 14s647ms 2s441ms 03 5 16s989ms 3s397ms 04 6 14s714ms 2s452ms 05 4 10s808ms 2s702ms 07 10 46s231ms 4s623ms 08 12 1m3s 5s280ms 09 12 1m2s 5s202ms 10 13 58s573ms 4s505ms 11 12 57s865ms 4s822ms 12 6 24s618ms 4s103ms 13 4 3s600ms 900ms 14 7 18s505ms 2s643ms 15 6 11s402ms 1s900ms 16 5 10s369ms 2s73ms 17 5 5s104ms 1s20ms 18 3 1s891ms 630ms 20 1 276ms 276ms 21 3 11s529ms 3s843ms 22 6 23s496ms 3s916ms [ User: intelifix - Total duration: 8m25s - Times executed: 138 ]
[ Application: psql - Total duration: 8m25s - Times executed: 138 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-28 00:05:22 Duration: 20s861ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-28 09:55:14 Duration: 12s27ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-28 08:05:11 Duration: 10s432ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
10 8m1s 865 150ms 2s239ms 556ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 28 07 104 1m 586ms 08 132 1m10s 532ms 09 146 1m14s 513ms 10 93 58s478ms 628ms 11 118 1m2s 529ms 12 6 3s830ms 638ms 13 45 24s621ms 547ms 14 134 1m20s 598ms 15 55 30s820ms 560ms 16 14 6s345ms 453ms 17 16 7s469ms 466ms 18 2 1s92ms 546ms [ User: intelifix - Total duration: 8m1s - Times executed: 865 ]
[ Application: [unknown] - Total duration: 8m1s - Times executed: 865 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "135129", "modelo" : "155", "itens" : "5CFA259CEE07,64FD9653C0B2,5447CC4A8C75,5447CC782CFA,943C96ABE27D,64FD966C6459,64FD965F6AAA,5447CCC9E2C5,64FD965FFB0A,5CFA258067CC", "usuario" : "428", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "elisa[[tela]]" }');
Date: 2026-08-28 09:01:33 Duration: 2s239ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "282775", "modelo" : "137", "itens" : "229880992740,229638488892,229704993644,229713732028,229676892327,229711711427,229793231414,229766138892,229711952337,229692903048,229705548603,229766120508,229700714360,216928724755,229643606272,229714778909,229702599314,229824928402,229700027491,229776869009", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "226178176068,246446997792,246508356070,246552342541,246494002021,246555849112,246606350214,246556647079,246533427282,246493820713,246536549999,246554258989,246521894956,246452821717,246480729198,246528923454,246519791115,246634278708,246521543351,246576413543,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-28 15:06:53 Duration: 2s223ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "135129", "modelo" : "155", "itens" : "ACD75BB7B42B,ACD75BB7BF1B,64FD966C6D7B,5CFA259C1921,ACD75BB69D97,B0FC88EA2306,5CFA25AD20F9,186A81D4118C,20B82BF9FBA1,D833B7CA5A2C", "usuario" : "428", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "bianca[[tela]]" }');
Date: 2026-08-28 09:50:28 Duration: 2s72ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
11 5m19s 24 10s585ms 15s533ms 13s302ms create table temp0000289984 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 28 14 24 5m19s 13s302ms [ User: intelifix - Total duration: 5m19s - Times executed: 24 ]
[ Application: [unknown] - Total duration: 5m19s - Times executed: 24 ]
-
CREATE TABLE temp0000289984 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 14:27:07 Duration: 15s533ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289984 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 14:19:06 Duration: 15s471ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289984 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 14:40:11 Duration: 14s615ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
12 4m5s 19 10s752ms 15s836ms 12s896ms create table temp0000289990 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 28 14 12 2m36s 13s51ms 15 4 53s638ms 13s409ms 16 3 34s769ms 11s589ms [ User: intelifix - Total duration: 4m5s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 4m5s - Times executed: 19 ]
-
CREATE TABLE temp0000289990 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 15:44:02 Duration: 15s836ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289990 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 14:40:47 Duration: 15s305ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289990 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 14:13:58 Duration: 15s276ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
13 3m22s 4 6s78ms 1m37s 50s526ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 28 20 2 1m38s 49s74ms 23 2 1m43s 51s978ms [ User: intelifix - Total duration: 3m22s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m22s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-28 23:17:25 Duration: 1m37s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-28 20:08:52 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-28 23:39:12 Duration: 6s256ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
14 3m11s 55 179ms 46s84ms 3s485ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 28 07 8 11s217ms 1s402ms 08 5 2s590ms 518ms 09 4 2s441ms 610ms 10 8 15s808ms 1s976ms 11 1 606ms 606ms 12 2 13s287ms 6s643ms 13 3 1m12s 24s54ms 14 21 1m9s 3s326ms 15 2 2s589ms 1s294ms 16 1 1s164ms 1s164ms [ User: intelifix - Total duration: 3m11s - Times executed: 55 ]
[ Application: psql - Total duration: 3m11s - Times executed: 55 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029230);
Date: 2026-08-28 13:53:33 Duration: 46s84ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029231);
Date: 2026-08-28 14:01:41 Duration: 30s940ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029228);
Date: 2026-08-28 13:41:17 Duration: 19s748ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
15 2m40s 12 11s47ms 19s358ms 13s392ms create table temp0000289964 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 28 10 4 55s290ms 13s822ms 12 4 53s250ms 13s312ms 13 4 52s173ms 13s43ms [ User: intelifix - Total duration: 2m40s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m40s - Times executed: 12 ]
-
CREATE TABLE temp0000289964 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 10:42:38 Duration: 19s358ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289964 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 12:03:23 Duration: 14s993ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289964 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 12:05:33 Duration: 13s764ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
16 2m22s 36 233ms 26s504ms 3s945ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 28 07 5 33s752ms 6s750ms 08 2 10s817ms 5s408ms 09 3 9s413ms 3s137ms 10 5 20s402ms 4s80ms 11 1 14s477ms 14s477ms 13 2 4s458ms 2s229ms 14 13 40s226ms 3s94ms 15 1 877ms 877ms 16 4 7s629ms 1s907ms [ User: intelifix - Total duration: 2m22s - Times executed: 36 ]
[ Application: psql - Total duration: 2m22s - Times executed: 36 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029201);
Date: 2026-08-28 07:12:42 Duration: 26s504ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029225);
Date: 2026-08-28 11:47:04 Duration: 14s477ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029232);
Date: 2026-08-28 14:04:27 Duration: 8s267ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
17 2m14s 37 755ms 11s133ms 3s635ms 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 #17
Day Hour Count Duration Avg duration Aug 28 08 3 22s180ms 7s393ms 09 2 9s934ms 4s967ms 10 3 17s40ms 5s680ms 11 3 15s540ms 5s180ms 12 1 8s389ms 8s389ms 13 3 2s903ms 967ms 14 2 20s310ms 10s155ms 15 2 19s50ms 9s525ms 16 3 3s54ms 1s18ms 17 3 3s204ms 1s68ms 18 1 960ms 960ms 19 3 2s711ms 903ms 20 3 4s794ms 1s598ms 21 2 1s815ms 907ms 22 3 2s619ms 873ms [ User: intelifix - Total duration: 2m14s - Times executed: 37 ]
[ Application: psql - Total duration: 2m14s - 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-28 15:20:12 Duration: 11s133ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
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-28 14:40:12 Duration: 10s821ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
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-28 14:00:10 Duration: 9s488ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
18 2m4s 4 423ms 1m7s 31s18ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 28 20 2 56s378ms 28s189ms 23 2 1m7s 33s847ms [ User: intelifix - Total duration: 2m4s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m4s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-28 23:13:48 Duration: 1m7s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-28 20:05:34 Duration: 55s954ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-28 23:38:32 Duration: 646ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
19 1m56s 25 3s823ms 5s735ms 4s647ms create table temp0000289984 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 28 14 25 1m56s 4s647ms [ User: intelifix - Total duration: 1m56s - Times executed: 25 ]
[ Application: [unknown] - Total duration: 1m56s - Times executed: 25 ]
-
CREATE TABLE temp0000289984 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"23-08-2026", "ate" :"28-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-28 14:18:07 Duration: 5s735ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289984 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-08-2026", "ate" :"28-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-28 14:27:39 Duration: 5s669ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289984 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-08-2026", "ate" :"28-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-28 14:19:19 Duration: 5s428ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
20 1m35s 295 150ms 991ms 323ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 28 15 71 34s233ms 482ms 16 90 27s495ms 305ms 17 134 33s827ms 252ms [ User: intelifix - Total duration: 1m35s - Times executed: 295 ]
[ Application: [unknown] - Total duration: 1m35s - Times executed: 295 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"55082","seriais":"CCF3C89715C4,B85E71E4D57C,B85E71C3F0B4,3C82C0C839E8,484BD4B1BF24,E4BFFAF127DC,ECA81FF7D73C,80DAC2CEC8F8,4075C3284CC4,C4509CBEFD7C,4075C3BB316C,C4509CEFAAF4,ECA81F20E184,4075C3BB4224,B85E71BB9478,08A7C06EBBD4,1C9D7285ECCC,CCF3C84679FC,08A7C071C5C4,B85E71BA94EC,08A7C04FFEB4,3C82C08C1AA8,4075C329D3B4,80DAC2CDF5E0,4075C3BA9734,ECA81F1EE654","usuario":"416","observacao":""}');
Date: 2026-08-28 15:29:50 Duration: 991ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"55082","seriais":"186A81D618DC,64FD9656A099,C4EB429F22B7,B0FC88E9B9B9,5CFA2516B24C,44D454601427,94988F2F852F,B0BBE54D3EE9,64FD9656934F,943C96AC5C7F,582FF7009444,5447CC77C9BF","usuario":"416","observacao":""}');
Date: 2026-08-28 15:28:23 Duration: 916ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"55082","seriais":"10A7932FDBC3,F8D2ACFAAADB,F8D2AC5C690B,F8D2ACEFD873,CCF3C85E8543,F8D2ACED7F6B,CCF3C8819C4B,10A7933540CB,F8D2ACF14AC3,48BDCE66876B,CCF3C87E89EB,48BDCE732D8B,CCF3C858EA83,CCF3C87B52CB,CCF3C8512D1B,CCF3C8837A0B,CCF3C87AB5F3","usuario":"416","observacao":""}');
Date: 2026-08-28 15:28:54 Duration: 890ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,218 24m 150ms 7s16ms 1s182ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 28 07 77 1m29s 1s156ms 08 126 2m13s 1s60ms 09 164 3m40s 1s346ms 10 219 3m26s 942ms 11 174 3m46s 1s299ms 12 47 1m15s 1s598ms 13 60 1m23s 1s392ms 14 201 3m59s 1s192ms 15 104 2m6s 1s217ms 16 29 27s692ms 954ms 17 17 12s94ms 711ms [ User: intelifix - Total duration: 24m - Times executed: 1218 ]
[ Application: [unknown] - Total duration: 24m - Times executed: 1218 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282319, 450, '834353951000256,241646529293,241694269913,241600839706,241708473544,241607307789,241694272944,241679468086,241658975761,241658967982,241651263247,241699868709,241655584353,241706827176,241608916577,241656986678,230048242542,241677537090,241593012736,241658170723,241709816469,241702765972,241703474358,241609868803,241691339010,241618354356,241621484044,241631609802,241668016677,241649738181,241682786884,241694761129,241712258302,241599644045,241630736877,241694311332,241694644652,241634549416,241592640624,241631713954', '',0320,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":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-28 09:39:32 Duration: 7s16ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282310, 450, 'CP2239LV3AD,4075C3BFB0FC$CP2301LV39G,B85E71E45EF8$CP2234LV8D9,4075C3B873DC$CP2134LV6BJ,ECA81F232904$CP2238LV27L,4075C3BEA590$CP2324LV0LK,CCF3C83731A4$CP2435LV6CQ,C4509CF258EC$CP2238LV6C5,4075C3BFBB74$CP2345LV46V,CCF3C84788EC$CP2302LV5WZ,B85E71E8F350$CP2204LV56Q,1C9D726A4FBC$CP2237LV7D9,4075C3BAE608$CP2429LV61B,C4509CBD6BF4$CP2439LV5DJ,C4509CF440E4$CP2233LVAN0,4075C3B4F75C$CP2218LV4MQ,00CB7ADDB8D4$CP2208LVA0F,3C82C0CA1E98$CP2208LVDNW,3C82C0CB4BD8$CP2143LV07E,ECA81FFC2004$CP2211LV1WK,3C82C0C54B20$CP2346LV7D7,400FC17F1144$CP2247LVA5R,B85E71EE7A64$CP2239LVMBG,B85E71BCB074$CP2131LVKL8,ECA81F1A753C$CP2522LV04E,B85E710CD248$CP2527LV7U1,F8D2AC48E7E8$CP2436LV2JY,C4509CF2BF04$CP2050LV49Q,484BD4A5AC1C$CP2529LV5YQ,3C82C08A6258$CP2249LVBD2,B85E71E1382C$CP2435LV27P,C4509CF124AC$CP2207LV7U4,3C82C06ABDF0$CP2439LV6Q6,C4509CF3CBB4$CP2210LV3MC,3C82C0CB73D8$CP2233LV5CD,4075C3B493AC$CP2242LV0RL,B85E71C9DA24$CP2120LV1DH,08A7C06BA3BC$CP2146LV309,D4E2CB903DC4$CP2234LV7NT,4075C3B8B310$CP2146LV1UE,D4E2CB8F4434', '',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":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-28 09:00:57 Duration: 6s463ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282273, 503, '833321946002018,230035540618,230027443340,230020625974,230006288188,230052563143,230053042539,229978507183,230053048498,230032458890,230050786684,229971105664,229975212833,229977504549,230054204863,229981879701', '',0295,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-28 08:06:14 Duration: 6s167ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
2 865 8m1s 150ms 2s239ms 556ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 28 07 104 1m 586ms 08 132 1m10s 532ms 09 146 1m14s 513ms 10 93 58s478ms 628ms 11 118 1m2s 529ms 12 6 3s830ms 638ms 13 45 24s621ms 547ms 14 134 1m20s 598ms 15 55 30s820ms 560ms 16 14 6s345ms 453ms 17 16 7s469ms 466ms 18 2 1s92ms 546ms [ User: intelifix - Total duration: 8m1s - Times executed: 865 ]
[ Application: [unknown] - Total duration: 8m1s - Times executed: 865 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "135129", "modelo" : "155", "itens" : "5CFA259CEE07,64FD9653C0B2,5447CC4A8C75,5447CC782CFA,943C96ABE27D,64FD966C6459,64FD965F6AAA,5447CCC9E2C5,64FD965FFB0A,5CFA258067CC", "usuario" : "428", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "elisa[[tela]]" }');
Date: 2026-08-28 09:01:33 Duration: 2s239ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "282775", "modelo" : "137", "itens" : "229880992740,229638488892,229704993644,229713732028,229676892327,229711711427,229793231414,229766138892,229711952337,229692903048,229705548603,229766120508,229700714360,216928724755,229643606272,229714778909,229702599314,229824928402,229700027491,229776869009", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "226178176068,246446997792,246508356070,246552342541,246494002021,246555849112,246606350214,246556647079,246533427282,246493820713,246536549999,246554258989,246521894956,246452821717,246480729198,246528923454,246519791115,246634278708,246521543351,246576413543,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-28 15:06:53 Duration: 2s223ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "135129", "modelo" : "155", "itens" : "ACD75BB7B42B,ACD75BB7BF1B,64FD966C6D7B,5CFA259C1921,ACD75BB69D97,B0FC88EA2306,5CFA25AD20F9,186A81D4118C,20B82BF9FBA1,D833B7CA5A2C", "usuario" : "428", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "bianca[[tela]]" }');
Date: 2026-08-28 09:50:28 Duration: 2s72ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
3 295 1m35s 150ms 991ms 323ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 28 15 71 34s233ms 482ms 16 90 27s495ms 305ms 17 134 33s827ms 252ms [ User: intelifix - Total duration: 1m35s - Times executed: 295 ]
[ Application: [unknown] - Total duration: 1m35s - Times executed: 295 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"55082","seriais":"CCF3C89715C4,B85E71E4D57C,B85E71C3F0B4,3C82C0C839E8,484BD4B1BF24,E4BFFAF127DC,ECA81FF7D73C,80DAC2CEC8F8,4075C3284CC4,C4509CBEFD7C,4075C3BB316C,C4509CEFAAF4,ECA81F20E184,4075C3BB4224,B85E71BB9478,08A7C06EBBD4,1C9D7285ECCC,CCF3C84679FC,08A7C071C5C4,B85E71BA94EC,08A7C04FFEB4,3C82C08C1AA8,4075C329D3B4,80DAC2CDF5E0,4075C3BA9734,ECA81F1EE654","usuario":"416","observacao":""}');
Date: 2026-08-28 15:29:50 Duration: 991ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"55082","seriais":"186A81D618DC,64FD9656A099,C4EB429F22B7,B0FC88E9B9B9,5CFA2516B24C,44D454601427,94988F2F852F,B0BBE54D3EE9,64FD9656934F,943C96AC5C7F,582FF7009444,5447CC77C9BF","usuario":"416","observacao":""}');
Date: 2026-08-28 15:28:23 Duration: 916ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"55082","seriais":"10A7932FDBC3,F8D2ACFAAADB,F8D2AC5C690B,F8D2ACEFD873,CCF3C85E8543,F8D2ACED7F6B,CCF3C8819C4B,10A7933540CB,F8D2ACF14AC3,48BDCE66876B,CCF3C87E89EB,48BDCE732D8B,CCF3C858EA83,CCF3C87B52CB,CCF3C8512D1B,CCF3C8837A0B,CCF3C87AB5F3","usuario":"416","observacao":""}');
Date: 2026-08-28 15:28:54 Duration: 890ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
4 277 16m6s 164ms 2m29s 3s490ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 28 00 12 40s300ms 3s358ms 01 12 30s833ms 2s569ms 02 12 31s613ms 2s634ms 03 12 30s643ms 2s553ms 04 12 30s849ms 2s570ms 05 12 33s290ms 2s774ms 06 12 32s875ms 2s739ms 07 13 46s207ms 3s554ms 08 12 36s289ms 3s24ms 09 12 44s46ms 3s670ms 10 12 40s69ms 3s339ms 11 12 38s217ms 3s184ms 12 12 35s733ms 2s977ms 13 12 37s744ms 3s145ms 14 12 3m5s 15s496ms 15 12 38s329ms 3s194ms 16 12 35s533ms 2s961ms 17 12 32s164ms 2s680ms 18 12 32s68ms 2s672ms 19 12 32s437ms 2s703ms 20 12 37s726ms 3s143ms 21 12 31s570ms 2s630ms 22 12 32s398ms 2s699ms [ User: intelifix - Total duration: 16m6s - Times executed: 277 ]
[ Application: psql - Total duration: 16m6s - Times executed: 277 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-28 14:27:35 Duration: 2m29s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-28 07:15:22 Duration: 15s771ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-28 09:05:17 Duration: 10s283ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
5 236 1h26m42s 150ms 7m13s 22s43ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 28 07 17 15m27s 54s535ms 08 21 12m52s 36s793ms 09 31 12m46s 24s713ms 10 32 13m57s 26s171ms 11 27 12m10s 27s55ms 12 4 2m57s 44s452ms 13 15 13s309ms 887ms 14 43 14m16s 19s909ms 15 22 1m13s 3s329ms 16 16 42s402ms 2s650ms 17 6 3s941ms 656ms 18 2 1s556ms 778ms [ User: intelifix - Total duration: 1h26m42s - Times executed: 236 ]
[ Application: [unknown] - Total duration: 1h26m42s - Times executed: 236 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-08-03''),DATE(''2026-08-27'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-08-28 10:45:51 Duration: 7m13s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029201, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-28 07:20:13 Duration: 7m13s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029211, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-28 08:54:54 Duration: 6m25s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
6 138 8m25s 151ms 20s861ms 3s661ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 28 00 6 34s907ms 5s817ms 01 6 13s964ms 2s327ms 02 6 14s647ms 2s441ms 03 5 16s989ms 3s397ms 04 6 14s714ms 2s452ms 05 4 10s808ms 2s702ms 07 10 46s231ms 4s623ms 08 12 1m3s 5s280ms 09 12 1m2s 5s202ms 10 13 58s573ms 4s505ms 11 12 57s865ms 4s822ms 12 6 24s618ms 4s103ms 13 4 3s600ms 900ms 14 7 18s505ms 2s643ms 15 6 11s402ms 1s900ms 16 5 10s369ms 2s73ms 17 5 5s104ms 1s20ms 18 3 1s891ms 630ms 20 1 276ms 276ms 21 3 11s529ms 3s843ms 22 6 23s496ms 3s916ms [ User: intelifix - Total duration: 8m25s - Times executed: 138 ]
[ Application: psql - Total duration: 8m25s - Times executed: 138 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-28 00:05:22 Duration: 20s861ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-28 09:55:14 Duration: 12s27ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-28 08:05:11 Duration: 10s432ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
7 109 27s651ms 151ms 616ms 253ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 28 01 26 6s764ms 260ms 04 9 2s461ms 273ms 05 22 6s243ms 283ms 07 9 2s456ms 272ms 08 6 1s331ms 221ms 09 3 570ms 190ms 10 10 2s595ms 259ms 11 11 2s870ms 260ms 12 3 556ms 185ms 13 1 158ms 158ms 14 6 1s70ms 178ms 15 3 571ms 190ms [ User: intelifix - Total duration: 27s651ms - Times executed: 109 ]
[ Application: [unknown] - Total duration: 27s651ms - Times executed: 109 ]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241704285660,241614933955,241603695675,241703437788,230047915259,241711204450,241727272629,241729933349,241604345166,241606127685,241604341126,241714990825,241689202034,230049054955,241654474963,241676834564,241732168190,241732169706,241698471839,241646168697', NULL, NULL, 0320, 00);
Date: 2026-08-28 05:14:38 Duration: 616ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '230011834353,230023221638,229963666565,230031811825,229989991122,230033806890,229975103855,230052797890,229967388488,230032462427', NULL, NULL, 0295, 00);
Date: 2026-08-28 10:20:42 Duration: 493ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241726967896,241708454249,241725877475,241674381014,241731985569,241670392443,241608838791,241608683951,241655247395,241731428993,241689199003,241665740216,241734224149,241655341827', NULL, NULL, 0320, 00);
Date: 2026-08-28 01:45:15 Duration: 482ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
8 101 41s112ms 206ms 909ms 407ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 28 07 10 4s244ms 424ms 08 13 4s561ms 350ms 09 14 5s803ms 414ms 10 12 4s658ms 388ms 11 5 2s906ms 581ms 12 2 884ms 442ms 13 4 1s659ms 414ms 14 13 5s698ms 438ms 15 12 4s745ms 395ms 16 10 3s658ms 365ms 17 5 1s969ms 393ms 18 1 322ms 322ms [ User: intelifix - Total duration: 41s112ms - Times executed: 101 ]
[ Application: [unknown] - Total duration: 41s112ms - Times executed: 101 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-28 11:03:55 Duration: 909ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-28 11:09:25 Duration: 664ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 085;
Date: 2026-08-28 09:10:26 Duration: 649ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
9 97 22s205ms 150ms 2s545ms 228ms create table temp0000239092 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 28 07 7 4s39ms 577ms 08 5 1s97ms 219ms 09 6 1s278ms 213ms 10 7 1s549ms 221ms 11 7 1s329ms 189ms 12 6 1s160ms 193ms 13 6 1s188ms 198ms 14 6 1s319ms 219ms 15 5 998ms 199ms 16 7 1s467ms 209ms 17 10 1s993ms 199ms 18 25 4s783ms 191ms [ User: intelifix - Total duration: 22s205ms - Times executed: 97 ]
[ Application: [unknown] - Total duration: 22s205ms - Times executed: 97 ]
-
CREATE TABLE temp0000239092 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "23-08-2026", "data-ate" : "28-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-28 07:07:51 Duration: 2s545ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000239092 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "23-08-2026", "data-ate" : "28-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-28 07:08:22 Duration: 581ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000239092 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "28-08-2026", "data-ate" : "28-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-28 10:14:35 Duration: 386ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
10 94 41s66ms 261ms 726ms 436ms 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 #10
Day Hour Count Duration Avg duration Aug 28 00 1 563ms 563ms 01 1 361ms 361ms 02 1 390ms 390ms 04 3 1s196ms 398ms 05 2 738ms 369ms 06 2 806ms 403ms 07 8 3s325ms 415ms 08 9 4s345ms 482ms 09 10 4s994ms 499ms 10 9 3s416ms 379ms 11 8 3s805ms 475ms 12 4 1s488ms 372ms 13 8 3s525ms 440ms 14 9 3s626ms 402ms 15 8 3s860ms 482ms 16 6 2s491ms 415ms 17 3 1s83ms 361ms 18 1 601ms 601ms 20 1 444ms 444ms [ User: lenon - Total duration: 41s66ms - Times executed: 94 ]
[ Application: [unknown] - Total duration: 41s66ms - Times executed: 94 ]
-
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-28 15:26:14 Duration: 726ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
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-28 07:40:44 Duration: 678ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
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-28 08:20:39 Duration: 661ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-28.log
11 81 44s199ms 151ms 887ms 545ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 28 00 1 887ms 887ms 01 1 491ms 491ms 02 1 453ms 453ms 04 3 1s551ms 517ms 05 2 1s8ms 504ms 06 1 596ms 596ms 07 6 2s982ms 497ms 08 7 4s271ms 610ms 09 10 6s266ms 626ms 10 7 3s359ms 479ms 11 8 4s957ms 619ms 12 3 1s97ms 365ms 13 5 2s509ms 501ms 14 9 4s538ms 504ms 15 8 4s557ms 569ms 16 5 2s505ms 501ms 17 3 1s426ms 475ms 18 1 735ms 735ms [ User: intelifix - Total duration: 44s199ms - Times executed: 81 ]
[ Application: [unknown] - Total duration: 44s199ms - Times executed: 81 ]
-
select * from rs_menu_grants (397, 0, 1);
Date: 2026-08-28 00:38:10 Duration: 887ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
select * from rs_menu_grants (406, 18, 1);
Date: 2026-08-28 08:13:50 Duration: 887ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
select * from rs_menu_grants (416, 0, 1);
Date: 2026-08-28 09:24:13 Duration: 831ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
12 80 17m54s 1s712ms 1m33s 13s436ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 28 06 1 1m33s 1m33s 07 5 54s632ms 10s926ms 08 7 2m3s 17s701ms 09 11 2m8s 11s684ms 10 5 1m19s 15s955ms 11 11 2m8s 11s696ms 12 1 7s659ms 7s659ms 13 5 1m5s 13s105ms 14 11 3m6s 16s957ms 15 8 2m20s 17s502ms 16 4 21s193ms 5s298ms 17 8 33s645ms 4s205ms 18 3 11s282ms 3s760ms [ User: intelifix - Total duration: 17m54s - Times executed: 80 ]
[ Application: [unknown] - Total duration: 17m54s - Times executed: 80 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-28', 0366, '', '', 0, 6, '2026-08-01');
Date: 2026-08-28 06:54:59 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-28', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-28 08:21:03 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-28', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-28 11:54:10 Duration: 33s903ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
13 69 16s791ms 151ms 1s477ms 243ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 28 01 1 305ms 305ms 05 1 175ms 175ms 06 1 1s477ms 1s477ms 07 1 260ms 260ms 08 1 162ms 162ms 09 6 1s672ms 278ms 10 6 1s46ms 174ms 11 7 1s634ms 233ms 12 11 3s754ms 341ms 13 2 454ms 227ms 14 14 2s398ms 171ms 15 9 1s648ms 183ms 16 5 1s25ms 205ms 17 4 773ms 193ms [ User: intelifix - Total duration: 16s791ms - Times executed: 69 ]
[ Application: [unknown] - Total duration: 16s791ms - Times executed: 69 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "362", "data-de" : "2026-08-27", "data-ate" : "2026-08-27", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 366 }');
Date: 2026-08-28 06:53:18 Duration: 1s477ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "363", "data-de" : "2026-08-28", "data-ate" : "2026-08-28", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 414 }');
Date: 2026-08-28 12:17:37 Duration: 699ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "434", "data-de" : "2026-08-28", "data-ate" : "2026-08-28", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 508 }');
Date: 2026-08-28 09:55:50 Duration: 482ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
14 58 12m18s 10s468ms 21s534ms 12s737ms create table temp0000289914 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 28 07 12 2m25s 12s87ms 08 15 3m1s 12s107ms 09 8 1m46s 13s265ms 10 12 2m33s 12s805ms 11 3 44s223ms 14s741ms 14 8 1m48s 13s512ms [ User: intelifix - Total duration: 12m18s - Times executed: 58 ]
[ Application: [unknown] - Total duration: 12m18s - Times executed: 58 ]
-
CREATE TABLE temp0000289914 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 09:48:11 Duration: 21s534ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289914 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 11:46:37 Duration: 19s376ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289914 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 10:14:48 Duration: 18s664ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
15 55 3m11s 179ms 46s84ms 3s485ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 28 07 8 11s217ms 1s402ms 08 5 2s590ms 518ms 09 4 2s441ms 610ms 10 8 15s808ms 1s976ms 11 1 606ms 606ms 12 2 13s287ms 6s643ms 13 3 1m12s 24s54ms 14 21 1m9s 3s326ms 15 2 2s589ms 1s294ms 16 1 1s164ms 1s164ms [ User: intelifix - Total duration: 3m11s - Times executed: 55 ]
[ Application: psql - Total duration: 3m11s - Times executed: 55 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029230);
Date: 2026-08-28 13:53:33 Duration: 46s84ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029231);
Date: 2026-08-28 14:01:41 Duration: 30s940ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029228);
Date: 2026-08-28 13:41:17 Duration: 19s748ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
16 53 1m29s 234ms 23s911ms 1s681ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 28 08 3 2s972ms 990ms 09 4 11s383ms 2s845ms 10 4 2s893ms 723ms 11 3 2s793ms 931ms 12 5 5s812ms 1s162ms 13 3 2s914ms 971ms 14 4 6s972ms 1s743ms 15 4 9s857ms 2s464ms 16 3 2s718ms 906ms 17 3 2s473ms 824ms 18 4 25s955ms 6s488ms 19 3 2s888ms 962ms 20 3 3s154ms 1s51ms 21 4 3s595ms 898ms 22 3 2s729ms 909ms [ User: intelifix - Total duration: 1m29s - Times executed: 53 ]
[ Application: psql - Total duration: 1m29s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-28 18:20:26 Duration: 23s911ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-28 09:00:10 Duration: 9s81ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-28 15:40:08 Duration: 6s989ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
17 48 1h54m6s 1s534ms 9m45s 2m22s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 28 07 3 10m43s 3m34s 08 3 7m35s 2m31s 09 3 8m12s 2m44s 10 3 7m4s 2m21s 11 3 8m30s 2m50s 12 3 7m41s 2m33s 13 3 6m30s 2m10s 14 3 7m13s 2m24s 15 3 7m12s 2m24s 16 3 6m23s 2m7s 17 3 6m22s 2m7s 18 3 6m4s 2m1s 19 3 6m15s 2m5s 20 3 6m12s 2m4s 21 3 6m5s 2m1s 22 3 5m55s 1m58s [ User: intelifix - Total duration: 1h54m6s - Times executed: 48 ]
[ Application: psql - Total duration: 1h54m6s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-28 07:14:46 Duration: 9m45s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-28 11:12:34 Duration: 7m33s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-28 12:12:21 Duration: 7m19s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
18 47 1h11m16s 272ms 4m50s 1m30s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 28 07 3 5m57s 1m59s 08 3 4m37s 1m32s 09 3 6m13s 2m4s 10 3 3m58s 1m19s 11 2 6m24s 3m12s 12 3 4m27s 1m29s 13 3 3m55s 1m18s 14 3 4m42s 1m34s 15 3 4m38s 1m32s 16 3 3m48s 1m16s 17 3 3m52s 1m17s 18 3 3m37s 1m12s 19 3 3m47s 1m15s 20 3 3m40s 1m13s 21 3 3m36s 1m12s 22 3 3m58s 1m19s [ User: intelifix - Total duration: 1h11m16s - Times executed: 47 ]
[ Application: psql - Total duration: 1h11m16s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-28 11:19:47 Duration: 4m50s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-28 09:19:13 Duration: 4m31s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-28 07:21:28 Duration: 4m19s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
19 47 33s21ms 180ms 2s540ms 702ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 28 09 8 7s540ms 942ms 10 15 8s610ms 574ms 11 3 3s944ms 1s314ms 13 11 7s210ms 655ms 14 10 5s715ms 571ms [ User: intelifix - Total duration: 33s21ms - Times executed: 47 ]
[ Application: [unknown] - Total duration: 33s21ms - Times executed: 47 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0282361) LIMIT 1;
Date: 2026-08-28 09:24:06 Duration: 2s540ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0282367) LIMIT 1;
Date: 2026-08-28 13:31:02 Duration: 2s292ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0282438) LIMIT 1;
Date: 2026-08-28 11:10:30 Duration: 1s881ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
20 47 20s339ms 167ms 3s26ms 432ms create table temp0000289918 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 28 07 7 4s740ms 677ms 08 8 2s582ms 322ms 09 11 4s844ms 440ms 10 12 4s278ms 356ms 11 8 3s562ms 445ms 12 1 330ms 330ms [ User: intelifix - Total duration: 20s339ms - Times executed: 47 ]
[ Application: [unknown] - Total duration: 20s339ms - Times executed: 47 ]
-
CREATE TABLE temp0000289918 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-08-2026", "ate" :"28-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-28 07:03:20 Duration: 3s26ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289918 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-08-2026", "ate" :"28-08-2026", "nota-fiscal":"83828", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-28 09:21:21 Duration: 1s439ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289918 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-08-2026", "ate" :"28-08-2026", "nota-fiscal":"83828", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-28 11:37:09 Duration: 586ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m 10m14s 6m40s 3 20m1s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 28 05 3 20m1s 6m40s [ User: intelifix - Total duration: 20m1s - Times executed: 3 ]
[ Application: psql - Total duration: 20m1s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-28 05:10:15 Duration: 10m14s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
analyze verbose;
Date: 2026-08-28 05:17:01 Duration: 6m46s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
analyze verbose;
Date: 2026-08-28 05:20:02 Duration: 3m Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
2 1s534ms 9m45s 2m22s 48 1h54m6s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 28 07 3 10m43s 3m34s 08 3 7m35s 2m31s 09 3 8m12s 2m44s 10 3 7m4s 2m21s 11 3 8m30s 2m50s 12 3 7m41s 2m33s 13 3 6m30s 2m10s 14 3 7m13s 2m24s 15 3 7m12s 2m24s 16 3 6m23s 2m7s 17 3 6m22s 2m7s 18 3 6m4s 2m1s 19 3 6m15s 2m5s 20 3 6m12s 2m4s 21 3 6m5s 2m1s 22 3 5m55s 1m58s [ User: intelifix - Total duration: 1h54m6s - Times executed: 48 ]
[ Application: psql - Total duration: 1h54m6s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-28 07:14:46 Duration: 9m45s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-28 11:12:34 Duration: 7m33s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-28 12:12:21 Duration: 7m19s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
3 272ms 4m50s 1m30s 47 1h11m16s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 28 07 3 5m57s 1m59s 08 3 4m37s 1m32s 09 3 6m13s 2m4s 10 3 3m58s 1m19s 11 2 6m24s 3m12s 12 3 4m27s 1m29s 13 3 3m55s 1m18s 14 3 4m42s 1m34s 15 3 4m38s 1m32s 16 3 3m48s 1m16s 17 3 3m52s 1m17s 18 3 3m37s 1m12s 19 3 3m47s 1m15s 20 3 3m40s 1m13s 21 3 3m36s 1m12s 22 3 3m58s 1m19s [ User: intelifix - Total duration: 1h11m16s - Times executed: 47 ]
[ Application: psql - Total duration: 1h11m16s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-28 11:19:47 Duration: 4m50s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-28 09:19:13 Duration: 4m31s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-28 07:21:28 Duration: 4m19s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
4 6s78ms 1m37s 50s526ms 4 3m22s 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 28 20 2 1m38s 49s74ms 23 2 1m43s 51s978ms [ User: intelifix - Total duration: 3m22s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m22s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-28 23:17:25 Duration: 1m37s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-28 20:08:52 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-28 23:39:12 Duration: 6s256ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
5 423ms 1m7s 31s18ms 4 2m4s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 28 20 2 56s378ms 28s189ms 23 2 1m7s 33s847ms [ User: intelifix - Total duration: 2m4s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m4s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-28 23:13:48 Duration: 1m7s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-28 20:05:34 Duration: 55s954ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-28 23:38:32 Duration: 646ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-28.log
6 150ms 7m13s 22s43ms 236 1h26m42s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 28 07 17 15m27s 54s535ms 08 21 12m52s 36s793ms 09 31 12m46s 24s713ms 10 32 13m57s 26s171ms 11 27 12m10s 27s55ms 12 4 2m57s 44s452ms 13 15 13s309ms 887ms 14 43 14m16s 19s909ms 15 22 1m13s 3s329ms 16 16 42s402ms 2s650ms 17 6 3s941ms 656ms 18 2 1s556ms 778ms [ User: intelifix - Total duration: 1h26m42s - Times executed: 236 ]
[ Application: [unknown] - Total duration: 1h26m42s - Times executed: 236 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-08-03''),DATE(''2026-08-27'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-08-28 10:45:51 Duration: 7m13s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029201, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-28 07:20:13 Duration: 7m13s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029211, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-28 08:54:54 Duration: 6m25s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
7 1s712ms 1m33s 13s436ms 80 17m54s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 28 06 1 1m33s 1m33s 07 5 54s632ms 10s926ms 08 7 2m3s 17s701ms 09 11 2m8s 11s684ms 10 5 1m19s 15s955ms 11 11 2m8s 11s696ms 12 1 7s659ms 7s659ms 13 5 1m5s 13s105ms 14 11 3m6s 16s957ms 15 8 2m20s 17s502ms 16 4 21s193ms 5s298ms 17 8 33s645ms 4s205ms 18 3 11s282ms 3s760ms [ User: intelifix - Total duration: 17m54s - Times executed: 80 ]
[ Application: [unknown] - Total duration: 17m54s - Times executed: 80 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-28', 0366, '', '', 0, 6, '2026-08-01');
Date: 2026-08-28 06:54:59 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-28', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-28 08:21:03 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-28', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-28 11:54:10 Duration: 33s903ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
8 11s47ms 19s358ms 13s392ms 12 2m40s create table temp0000289964 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 28 10 4 55s290ms 13s822ms 12 4 53s250ms 13s312ms 13 4 52s173ms 13s43ms [ User: intelifix - Total duration: 2m40s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m40s - Times executed: 12 ]
-
CREATE TABLE temp0000289964 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 10:42:38 Duration: 19s358ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289964 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 12:03:23 Duration: 14s993ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289964 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 12:05:33 Duration: 13s764ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
9 10s585ms 15s533ms 13s302ms 24 5m19s create table temp0000289984 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 28 14 24 5m19s 13s302ms [ User: intelifix - Total duration: 5m19s - Times executed: 24 ]
[ Application: [unknown] - Total duration: 5m19s - Times executed: 24 ]
-
CREATE TABLE temp0000289984 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 14:27:07 Duration: 15s533ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289984 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 14:19:06 Duration: 15s471ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289984 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 14:40:11 Duration: 14s615ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
10 10s752ms 15s836ms 12s896ms 19 4m5s create table temp0000289990 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 28 14 12 2m36s 13s51ms 15 4 53s638ms 13s409ms 16 3 34s769ms 11s589ms [ User: intelifix - Total duration: 4m5s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 4m5s - Times executed: 19 ]
-
CREATE TABLE temp0000289990 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 15:44:02 Duration: 15s836ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289990 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 14:40:47 Duration: 15s305ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289990 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 14:13:58 Duration: 15s276ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
11 10s468ms 21s534ms 12s737ms 58 12m18s create table temp0000289914 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 28 07 12 2m25s 12s87ms 08 15 3m1s 12s107ms 09 8 1m46s 13s265ms 10 12 2m33s 12s805ms 11 3 44s223ms 14s741ms 14 8 1m48s 13s512ms [ User: intelifix - Total duration: 12m18s - Times executed: 58 ]
[ Application: [unknown] - Total duration: 12m18s - Times executed: 58 ]
-
CREATE TABLE temp0000289914 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 09:48:11 Duration: 21s534ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289914 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 11:46:37 Duration: 19s376ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289914 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-28 10:14:48 Duration: 18s664ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
12 3s823ms 5s735ms 4s647ms 25 1m56s create table temp0000289984 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 28 14 25 1m56s 4s647ms [ User: intelifix - Total duration: 1m56s - Times executed: 25 ]
[ Application: [unknown] - Total duration: 1m56s - Times executed: 25 ]
-
CREATE TABLE temp0000289984 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"23-08-2026", "ate" :"28-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-28 14:18:07 Duration: 5s735ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289984 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-08-2026", "ate" :"28-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-28 14:27:39 Duration: 5s669ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CREATE TABLE temp0000289984 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-08-2026", "ate" :"28-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-28 14:19:19 Duration: 5s428ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
13 233ms 26s504ms 3s945ms 36 2m22s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 28 07 5 33s752ms 6s750ms 08 2 10s817ms 5s408ms 09 3 9s413ms 3s137ms 10 5 20s402ms 4s80ms 11 1 14s477ms 14s477ms 13 2 4s458ms 2s229ms 14 13 40s226ms 3s94ms 15 1 877ms 877ms 16 4 7s629ms 1s907ms [ User: intelifix - Total duration: 2m22s - Times executed: 36 ]
[ Application: psql - Total duration: 2m22s - Times executed: 36 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029201);
Date: 2026-08-28 07:12:42 Duration: 26s504ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029225);
Date: 2026-08-28 11:47:04 Duration: 14s477ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029232);
Date: 2026-08-28 14:04:27 Duration: 8s267ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
14 151ms 20s861ms 3s661ms 138 8m25s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 28 00 6 34s907ms 5s817ms 01 6 13s964ms 2s327ms 02 6 14s647ms 2s441ms 03 5 16s989ms 3s397ms 04 6 14s714ms 2s452ms 05 4 10s808ms 2s702ms 07 10 46s231ms 4s623ms 08 12 1m3s 5s280ms 09 12 1m2s 5s202ms 10 13 58s573ms 4s505ms 11 12 57s865ms 4s822ms 12 6 24s618ms 4s103ms 13 4 3s600ms 900ms 14 7 18s505ms 2s643ms 15 6 11s402ms 1s900ms 16 5 10s369ms 2s73ms 17 5 5s104ms 1s20ms 18 3 1s891ms 630ms 20 1 276ms 276ms 21 3 11s529ms 3s843ms 22 6 23s496ms 3s916ms [ User: intelifix - Total duration: 8m25s - Times executed: 138 ]
[ Application: psql - Total duration: 8m25s - Times executed: 138 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-28 00:05:22 Duration: 20s861ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-28 09:55:14 Duration: 12s27ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-28 08:05:11 Duration: 10s432ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
15 755ms 11s133ms 3s635ms 37 2m14s 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 #15
Day Hour Count Duration Avg duration Aug 28 08 3 22s180ms 7s393ms 09 2 9s934ms 4s967ms 10 3 17s40ms 5s680ms 11 3 15s540ms 5s180ms 12 1 8s389ms 8s389ms 13 3 2s903ms 967ms 14 2 20s310ms 10s155ms 15 2 19s50ms 9s525ms 16 3 3s54ms 1s18ms 17 3 3s204ms 1s68ms 18 1 960ms 960ms 19 3 2s711ms 903ms 20 3 4s794ms 1s598ms 21 2 1s815ms 907ms 22 3 2s619ms 873ms [ User: intelifix - Total duration: 2m14s - Times executed: 37 ]
[ Application: psql - Total duration: 2m14s - 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-28 15:20:12 Duration: 11s133ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
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-28 14:40:12 Duration: 10s821ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
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-28 14:00:10 Duration: 9s488ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
16 164ms 2m29s 3s490ms 277 16m6s call rs_giga_triagem (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 28 00 12 40s300ms 3s358ms 01 12 30s833ms 2s569ms 02 12 31s613ms 2s634ms 03 12 30s643ms 2s553ms 04 12 30s849ms 2s570ms 05 12 33s290ms 2s774ms 06 12 32s875ms 2s739ms 07 13 46s207ms 3s554ms 08 12 36s289ms 3s24ms 09 12 44s46ms 3s670ms 10 12 40s69ms 3s339ms 11 12 38s217ms 3s184ms 12 12 35s733ms 2s977ms 13 12 37s744ms 3s145ms 14 12 3m5s 15s496ms 15 12 38s329ms 3s194ms 16 12 35s533ms 2s961ms 17 12 32s164ms 2s680ms 18 12 32s68ms 2s672ms 19 12 32s437ms 2s703ms 20 12 37s726ms 3s143ms 21 12 31s570ms 2s630ms 22 12 32s398ms 2s699ms [ User: intelifix - Total duration: 16m6s - Times executed: 277 ]
[ Application: psql - Total duration: 16m6s - Times executed: 277 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-28 14:27:35 Duration: 2m29s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-28 07:15:22 Duration: 15s771ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-28 09:05:17 Duration: 10s283ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
17 179ms 46s84ms 3s485ms 55 3m11s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 28 07 8 11s217ms 1s402ms 08 5 2s590ms 518ms 09 4 2s441ms 610ms 10 8 15s808ms 1s976ms 11 1 606ms 606ms 12 2 13s287ms 6s643ms 13 3 1m12s 24s54ms 14 21 1m9s 3s326ms 15 2 2s589ms 1s294ms 16 1 1s164ms 1s164ms [ User: intelifix - Total duration: 3m11s - Times executed: 55 ]
[ Application: psql - Total duration: 3m11s - Times executed: 55 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029230);
Date: 2026-08-28 13:53:33 Duration: 46s84ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029231);
Date: 2026-08-28 14:01:41 Duration: 30s940ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029228);
Date: 2026-08-28 13:41:17 Duration: 19s748ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
18 234ms 23s911ms 1s681ms 53 1m29s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 28 08 3 2s972ms 990ms 09 4 11s383ms 2s845ms 10 4 2s893ms 723ms 11 3 2s793ms 931ms 12 5 5s812ms 1s162ms 13 3 2s914ms 971ms 14 4 6s972ms 1s743ms 15 4 9s857ms 2s464ms 16 3 2s718ms 906ms 17 3 2s473ms 824ms 18 4 25s955ms 6s488ms 19 3 2s888ms 962ms 20 3 3s154ms 1s51ms 21 4 3s595ms 898ms 22 3 2s729ms 909ms [ User: intelifix - Total duration: 1m29s - Times executed: 53 ]
[ Application: psql - Total duration: 1m29s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-28 18:20:26 Duration: 23s911ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-28 09:00:10 Duration: 9s81ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-28 15:40:08 Duration: 6s989ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-28.log
19 150ms 7s16ms 1s182ms 1,218 24m select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 28 07 77 1m29s 1s156ms 08 126 2m13s 1s60ms 09 164 3m40s 1s346ms 10 219 3m26s 942ms 11 174 3m46s 1s299ms 12 47 1m15s 1s598ms 13 60 1m23s 1s392ms 14 201 3m59s 1s192ms 15 104 2m6s 1s217ms 16 29 27s692ms 954ms 17 17 12s94ms 711ms [ User: intelifix - Total duration: 24m - Times executed: 1218 ]
[ Application: [unknown] - Total duration: 24m - Times executed: 1218 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282319, 450, '834353951000256,241646529293,241694269913,241600839706,241708473544,241607307789,241694272944,241679468086,241658975761,241658967982,241651263247,241699868709,241655584353,241706827176,241608916577,241656986678,230048242542,241677537090,241593012736,241658170723,241709816469,241702765972,241703474358,241609868803,241691339010,241618354356,241621484044,241631609802,241668016677,241649738181,241682786884,241694761129,241712258302,241599644045,241630736877,241694311332,241694644652,241634549416,241592640624,241631713954', '',0320,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":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-28 09:39:32 Duration: 7s16ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282310, 450, 'CP2239LV3AD,4075C3BFB0FC$CP2301LV39G,B85E71E45EF8$CP2234LV8D9,4075C3B873DC$CP2134LV6BJ,ECA81F232904$CP2238LV27L,4075C3BEA590$CP2324LV0LK,CCF3C83731A4$CP2435LV6CQ,C4509CF258EC$CP2238LV6C5,4075C3BFBB74$CP2345LV46V,CCF3C84788EC$CP2302LV5WZ,B85E71E8F350$CP2204LV56Q,1C9D726A4FBC$CP2237LV7D9,4075C3BAE608$CP2429LV61B,C4509CBD6BF4$CP2439LV5DJ,C4509CF440E4$CP2233LVAN0,4075C3B4F75C$CP2218LV4MQ,00CB7ADDB8D4$CP2208LVA0F,3C82C0CA1E98$CP2208LVDNW,3C82C0CB4BD8$CP2143LV07E,ECA81FFC2004$CP2211LV1WK,3C82C0C54B20$CP2346LV7D7,400FC17F1144$CP2247LVA5R,B85E71EE7A64$CP2239LVMBG,B85E71BCB074$CP2131LVKL8,ECA81F1A753C$CP2522LV04E,B85E710CD248$CP2527LV7U1,F8D2AC48E7E8$CP2436LV2JY,C4509CF2BF04$CP2050LV49Q,484BD4A5AC1C$CP2529LV5YQ,3C82C08A6258$CP2249LVBD2,B85E71E1382C$CP2435LV27P,C4509CF124AC$CP2207LV7U4,3C82C06ABDF0$CP2439LV6Q6,C4509CF3CBB4$CP2210LV3MC,3C82C0CB73D8$CP2233LV5CD,4075C3B493AC$CP2242LV0RL,B85E71C9DA24$CP2120LV1DH,08A7C06BA3BC$CP2146LV309,D4E2CB903DC4$CP2234LV7NT,4075C3B8B310$CP2146LV1UE,D4E2CB8F4434', '',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":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-28 09:00:57 Duration: 6s463ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282273, 503, '833321946002018,230035540618,230027443340,230020625974,230006288188,230052563143,230053042539,229978507183,230053048498,230032458890,230050786684,229971105664,229975212833,229977504549,230054204863,229981879701', '',0295,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-28 08:06:14 Duration: 6s167ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
20 180ms 2s540ms 702ms 47 33s21ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 28 09 8 7s540ms 942ms 10 15 8s610ms 574ms 11 3 3s944ms 1s314ms 13 11 7s210ms 655ms 14 10 5s715ms 571ms [ User: intelifix - Total duration: 33s21ms - Times executed: 47 ]
[ Application: [unknown] - Total duration: 33s21ms - Times executed: 47 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0282361) LIMIT 1;
Date: 2026-08-28 09:24:06 Duration: 2s540ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0282367) LIMIT 1;
Date: 2026-08-28 13:31:02 Duration: 2s292ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0282438) LIMIT 1;
Date: 2026-08-28 11:10:30 Duration: 1s881ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-28.log
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 2 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 28 11 1 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 1s310ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 865ms - Times executed: 1 ]
[ Application: psql - Total duration: 445ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 14,921 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 24 FATAL entries
- 3171 ERROR entries
- 0 WARNING entries
- 6 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,150 Max number of times the same event was reported
- 3,201 Total events found
Rank Times reported Error 1 3,150 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 28 00 59 01 60 02 59 03 55 04 59 05 60 06 59 07 223 08 321 09 322 10 227 11 301 12 180 13 123 14 268 15 169 16 104 17 142 18 62 19 60 20 59 21 60 22 59 23 59 - ERROR: prepared statement "_PLAN0000000029BE4750" does not exist
- ERROR: prepared statement "_PLAN0000000029A0F330" does not exist
- ERROR: prepared statement "_PLAN00000000299C6E40" does not exist
Statement: DEALLOCATE "_PLAN0000000029BE4750"
Date: 2026-08-28 00:00:55 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Statement: DEALLOCATE "_PLAN0000000029A0F330"
Date: 2026-08-28 00:01:55 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Statement: DEALLOCATE "_PLAN00000000299C6E40"
Date: 2026-08-28 00:02:56 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
2 14 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 28 00 1 06 3 08 1 10 2 11 1 14 1 16 1 18 2 19 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-08-28 00:02:52 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Date: 2026-08-28 06:02:48 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Date: 2026-08-28 06:56:15 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
3 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 28 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-28 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Date: 2026-08-28 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()
Date: 2026-08-28 03:05:01 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
4 6 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 28 05 4 07 2 - 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-28 05:32:15 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-28 05:32:15 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-28 05:32:15 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
5 5 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 28 09 5 - ERROR: trailing junk after numeric literal at or near "2035431687F2" at character 32
- ERROR: trailing junk after numeric literal at or near "2035431687F2" at character 44
- ERROR: trailing junk after numeric literal at or near "9D" at character 36
Statement: SELECT RS_SERIAL_TEMPORARIO( ''2035431687F2' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''2035431687F2' )
Date: 2026-08-28 09:01:32 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Statement: SELECT SAIDA FROM RS_SMARTCARD_TELA( 00, ''2035431687F2' )
Date: 2026-08-28 09:01:33 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-9D-D0-C9)
Date: 2026-08-28 09:17:30 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
6 4 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 28 07 1 09 3 - ERROR: column "controle" does not exist at character 36
- ERROR: column "dc" does not exist at character 27
- ERROR: column "dc" does not exist at character 27
Hint: Perhaps you meant to reference the column "temp0000239092.con_nome".
Statement: SELECT * FROM temp0000239092 WHERE CONTROLE='L'Date: 2026-08-28 07:28:10 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-B4-11-66)
Date: 2026-08-28 09:36:07 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-B4-11-66)
Date: 2026-08-28 09:36:08 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
7 4 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 28 08 2 09 2 - ERROR: syntax error at or near ":" at character 35
- ERROR: syntax error at or near ":" at character 35
- ERROR: syntax error at or near "B01FF41B028D" at character 32
Statement: select * from rs_caixa_qr(Mensagem: Dados gravados para o lote "282394"! Gerada caixa 3555806 com 9 itens. Total de 81 equipamento(s).)
Date: 2026-08-28 08:19:58 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Statement: select * from rs_caixa_qr(Mensagem: Dados gravados para o lote "282394"! Gerada caixa 3555806 com 9 itens. Total de 81 equipamento(s).)
Date: 2026-08-28 08:19:58 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Statement: SELECT RS_SERIAL_TEMPORARIO( ''B01FF41B028D' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''B01FF41B028D' )
Date: 2026-08-28 09:01:02 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
8 3 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 28 14 3 - LOG: process 3254130 still waiting for ShareLock on transaction 5235161 after 1000.098 ms
- LOG: process 3254130 still waiting for ShareLock on transaction 5235161 after 3934.316 ms
- LOG: process 3254130 still waiting for ShareLock on transaction 5235161 after 32746.776 ms
Detail: Process holding the lock: 3237502. Wait queue: 3254130.
Context: while updating tuple (78235,44) 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-28 14:25:13 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Detail: Process holding the lock: 3237502. Wait queue: 3254130.
Context: while updating tuple (78235,44) 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-28 14:25:16 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Detail: Process holding the lock: 3237502. Wait queue: 3254130.
Context: while updating tuple (78235,44) 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-28 14:25:45 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
9 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #9
Day Hour Count Aug 28 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-28 03:05:02 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Date: 2026-08-28 03:05:02 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
Date: 2026-08-28 03:05:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
10 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #10
Day Hour Count Aug 28 03 1 - LOG: database system was shut down at 2026-08-28 03:05:02 -03
Date: 2026-08-28 03:05:03 Log file: /usr/local/pgsql/data/log/serverlog-28.log
11 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #11
Day Hour Count Aug 28 14 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000289914"
Date: 2026-08-28 14:30:12 Log file: /usr/local/pgsql/data/log/serverlog-28.log
12 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #12
Day Hour Count Aug 28 14 1 - LOG: process 3251562 still waiting for AccessExclusiveLock on relation 4408010 of database 358220 after 1000.070 ms
Detail: Process holding the lock: 3283935. Wait queue: 3251562.
Statement: DROP TABLE IF EXISTS temp0000289914;Date: 2026-08-28 14:30:12 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log
13 1 LOG: skipping analyze of "..." --- lock not available
Times Reported Most Frequent Error / Event #13
Day Hour Count Aug 28 08 1 - LOG: skipping analyze of "temp0000289940" --- lock not available
Date: 2026-08-28 08:41:07 Log file: /usr/local/pgsql/data/log/serverlog-28.log
14 1 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #14
Day Hour Count Aug 28 15 1 - ERROR: unterminated quoted string at or near "'12'');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('12'');
Date: 2026-08-28 15:11:12 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-28.log