pgBadger-
Global information
- Generated on Tue Aug 11 23:50:11 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 43,040 log entries in 9s
- Log start from 2026-08-11 00:00:35 to 2026-08-11 23:49:58
-
Overview
Global Stats
- 337 Number of unique normalized queries
- 6,041 Number of queries
- 8h8m25s Total query duration
- 2026-08-11 00:02:11 First query
- 2026-08-11 23:43:54 Last query
- 6 queries/s at 2026-08-11 09:55:15 Query peak
- 8h8m25s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h8m25s Execute total duration
- 4,133 Number of events
- 13 Number of unique normalized events
- 4,033 Max number of times the same event was reported
- 0 Number of cancellation
- 485 Total number of automatic vacuums
- 1,061 Total number of automatic analyzes
- 10 Number temporary file
- 239.81 MiB Max size of temporary file
- 111.47 MiB Average size of temporary file
- 379 Total number of sessions
- 9 sessions at 2026-08-11 13:05:10 Session peak
- 13d22h15m52s Total duration of sessions
- 52m55s Average duration of sessions
- 15 Average queries per session
- 1m17s Average queries duration per session
- 51m37s Average idle time per session
- 388 Total number of connections
- 5 connections/s at 2026-08-11 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-08-11 09:55:15 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-11 15:42:16 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-11 23:43:48 Date
Queries duration
Key values
- 8h8m25s 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 11 00 29 0ms 17s54ms 4s119ms 5s284ms 7s10ms 1m15s 01 49 0ms 4s208ms 831ms 4s179ms 6s420ms 6s963ms 02 17 0ms 4s171ms 2s64ms 3s614ms 6s447ms 7s134ms 03 25 0ms 8s298ms 1s887ms 5s406ms 7s454ms 10s635ms 04 31 0ms 4s112ms 1s339ms 5s52ms 6s577ms 7s584ms 05 38 0ms 9m8s 30s639ms 11s871ms 2m35s 9m8s 06 22 0ms 8s606ms 2s667ms 4s23ms 4s998ms 28s96ms 07 125 0ms 9m11s 9s37ms 31s901ms 1m33s 9m12s 08 505 150ms 6m13s 4s452ms 1m26s 4m54s 6m16s 09 614 150ms 9m34s 4s55ms 1m22s 4m50s 9m43s 10 610 150ms 8m23s 3s884ms 1m52s 5m7s 8m55s 11 460 150ms 8m40s 4s440ms 58s570ms 5m10s 8m52s 12 198 0ms 8m21s 11s70ms 1m7s 5m5s 8m21s 13 457 150ms 6m42s 2s577ms 25s197ms 1m14s 6m42s 14 828 151ms 8m57s 3s72ms 53s546ms 4m18s 10m58s 15 619 150ms 9m3s 4s188ms 1m50s 5m22s 9m12s 16 539 150ms 9m2s 3s614ms 35s380ms 4m45s 9m17s 17 301 0ms 7m46s 3s556ms 17s390ms 51s948ms 7m49s 18 29 0ms 5m51s 22s292ms 6s164ms 53s990ms 5m51s 19 24 0ms 5m52s 26s695ms 7s85ms 52s72ms 5m52s 20 111 0ms 8m19s 12s305ms 59s231ms 1m50s 8m19s 21 39 0ms 6m1s 17s239ms 7s366ms 22s93ms 6m50s 22 33 0ms 5m45s 19s581ms 7s246ms 50s530ms 5m45s 23 338 0ms 1m21s 5s980ms 1m4s 1m10s 1m48s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 11 00 7 0 2s44ms 0ms 0ms 1s334ms 01 30 0 236ms 244ms 363ms 842ms 02 0 0 0ms 0ms 0ms 0ms 03 6 0 330ms 0ms 0ms 382ms 04 13 0 293ms 186ms 245ms 323ms 05 16 0 349ms 0ms 244ms 1s113ms 06 5 0 1s741ms 0ms 0ms 1s82ms 07 68 0 14s673ms 1s174ms 31s901ms 3m51s 08 367 0 4s680ms 12s200ms 1m24s 5m44s 09 453 0 4s64ms 7s91ms 41s890ms 6m29s 10 483 0 3s942ms 10s620ms 1m17s 5m21s 11 362 0 5s76ms 12s816ms 39s292ms 5m40s 12 116 0 16s209ms 6s953ms 1m7s 5m7s 13 342 0 2s910ms 9s760ms 21s383ms 3m27s 14 612 0 3s56ms 12s510ms 23s408ms 6m15s 15 474 0 4s380ms 13s501ms 1m4s 5m47s 16 419 0 4s132ms 14s551ms 27s731ms 5m44s 17 181 0 5s429ms 6s548ms 17s390ms 3m41s 18 11 0 54s603ms 0ms 1s717ms 3m6s 19 6 0 1m38s 0ms 0ms 3m7s 20 12 78 14s443ms 10s448ms 59s231ms 3m22s 21 14 0 42s762ms 0ms 234ms 3m5s 22 8 0 1m13s 0ms 0ms 3m11s 23 13 325 5s980ms 1m1s 1m4s 1m47s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 11 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 11 00 0 2 2.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 1 1.00 0.00% 05 0 3 3.00 0.00% 06 0 1 1.00 0.00% 07 0 7 7.00 0.00% 08 0 16 16.00 0.00% 09 0 11 11.00 0.00% 10 0 13 13.00 0.00% 11 0 11 11.00 0.00% 12 0 11 11.00 0.00% 13 0 10 10.00 0.00% 14 0 15 15.00 0.00% 15 0 17 17.00 0.00% 16 0 11 11.00 0.00% 17 0 9 9.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 2 2.00 0.00% 22 0 1 1.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Aug 11 00 17 0.00/s 01 11 0.00/s 02 9 0.00/s 03 19 0.01/s 04 13 0.00/s 05 11 0.00/s 06 14 0.00/s 07 16 0.00/s 08 19 0.01/s 09 20 0.01/s 10 23 0.01/s 11 18 0.01/s 12 18 0.01/s 13 24 0.01/s 14 23 0.01/s 15 26 0.01/s 16 20 0.01/s 17 17 0.00/s 18 10 0.00/s 19 9 0.00/s 20 14 0.00/s 21 12 0.00/s 22 10 0.00/s 23 15 0.00/s Day Hour Count Average Duration Average idle time Aug 11 00 8 57m55s 57m40s 01 16 1h33s 1h31s 02 11 1h16s 1h13s 03 19 20m27s 20m25s 04 9 1h2m40s 1h2m35s 05 10 55m36s 53m39s 06 10 57m32s 57m26s 07 14 57m6s 55m45s 08 16 57m31s 55m10s 09 21 54m49s 52m50s 10 19 54m29s 52m24s 11 21 57m47s 56m10s 12 23 49m14s 47m38s 13 17 49m35s 48m25s 14 20 59m58s 57m50s 15 28 48m23s 46m50s 16 23 53m53s 52m28s 17 19 54m26s 53m30s 18 16 57m23s 56m42s 19 9 1h 58m49s 20 12 46m25s 44m31s 21 10 57m 55m53s 22 12 1h36s 59m42s 23 16 39m59s 37m53s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-08-11 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 388 connections Total
Connections per user
Key values
- intelifix Main User
- 388 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2026-08-11 13:05:10 Date
Histogram of session times
Key values
- 304 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 379 sessions Total
Sessions per user
Key values
- intelifix Main User
- 379 sessions Total
Sessions per host
Key values
- [local] Main Host
- 379 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 34,368 buffers Checkpoint Peak
- 2026-08-11 00:09:45 Date
- 270.019 seconds Highest write time
- 0.180 seconds Sync time
Checkpoints Wal files
Key values
- 15 files Wal files usage Peak
- 2026-08-11 11:04:36 Date
Checkpoints distance
Key values
- 507.49 Mo Distance Peak
- 2026-08-11 11:04:36 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 11 00 53,701 636.601s 0.103s 636.768s 01 3,723 373.665s 0.261s 373.997s 02 1,614 162.114s 0.09s 162.242s 03 2,173 218.15s 0.25s 218.456s 04 2,857 286.726s 0.165s 286.953s 05 9,480 932.031s 0.283s 932.392s 06 3,930 269.795s 0.004s 269.81s 07 12,583 1,189.587s 0.175s 1,189.951s 08 78,894 3,078.442s 0.538s 3,079.189s 09 57,391 3,238.584s 0.78s 3,239.608s 10 70,749 3,238.641s 0.898s 3,239.757s 11 80,359 3,031.712s 0.597s 3,032.505s 12 46,002 2,881.21s 0.348s 2,881.71s 13 38,535 2,966.595s 0.626s 2,967.376s 14 64,423 3,238.43s 0.994s 3,239.674s 15 64,779 3,238.739s 0.74s 3,239.687s 16 52,242 3,238.775s 0.699s 3,239.671s 17 29,368 2,612.082s 0.278s 2,612.564s 18 2,075 208.354s 0.084s 208.548s 19 29 2.933s 0.066s 3.006s 20 688 130.723s 0.09s 130.838s 21 2,447 245.747s 0.048s 245.866s 22 2,285 229.591s 0.045s 229.688s 23 296 29.768s 0.076s 29.878s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 11 00 0 0 10 453 0.065s 0.008s 01 0 0 1 737 0.062s 0.012s 02 0 0 1 339 0.065s 0.005s 03 0 0 0 488 0.064s 0.009s 04 0 0 1 525 0.062s 0.009s 05 0 0 4 726 0.063s 0.008s 06 0 0 1 11 0.001s 0.001s 07 0 0 4 1,546 0.064s 0.012s 08 0 0 51 5,260 0.011s 0.012s 09 0 0 55 7,209 0.063s 0.012s 10 0 0 43 7,213 0.059s 0.012s 11 0 0 38 6,160 0.063s 0.012s 12 0 0 30 3,857 0.062s 0.012s 13 0 0 16 6,030 0.059s 0.012s 14 0 0 56 7,577 0.063s 0.012s 15 0 0 38 6,994 0.065s 0.012s 16 0 0 25 6,017 0.060s 0.012s 17 0 0 14 4,478 0.009s 0.012s 18 0 0 1 335 0.062s 0.01s 19 0 0 0 8 0.063s 0.009s 20 0 0 1 87 0.063s 0.005s 21 0 0 1 455 0.017s 0.008s 22 0 0 0 473 0.006s 0.007s 23 0 0 1 34 0.063s 0.012s Day Hour Count Avg time (sec) Aug 11 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 11 00 23,406.57 kB 70,751.86 kB 01 1,806.40 kB 32,432.70 kB 02 1,720.80 kB 15,223.40 kB 03 1,434.25 kB 3,230.88 kB 04 1,645.56 kB 2,403.78 kB 05 8,087.12 kB 15,591.38 kB 06 8,797.00 kB 13,963.00 kB 07 6,196.75 kB 11,822.17 kB 08 69,836.67 kB 108,730.67 kB 09 74,597.42 kB 131,523.33 kB 10 58,188.58 kB 140,371.33 kB 11 52,989.50 kB 168,287.92 kB 12 40,251.58 kB 81,277.42 kB 13 21,884.75 kB 43,774.75 kB 14 77,179.17 kB 105,001.17 kB 15 51,517.00 kB 106,984.33 kB 16 34,237.67 kB 85,202.50 kB 17 18,964.67 kB 42,759.33 kB 18 1,014.38 kB 25,609.62 kB 19 200.00 kB 15,635.00 kB 20 7,505.00 kB 17,691.33 kB 21 1,694.43 kB 11,240.14 kB 22 1,748.86 kB 6,256.71 kB 23 167.40 kB 3,775.60 kB -
Temporary Files
Size of temporary files
Key values
- 479.62 MiB Temp Files size Peak
- 2026-08-11 05:31:57 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-11 05:31:57 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 11 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.09 GiB 111.47 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 931.57 MiB 71.53 MiB 239.81 MiB 116.45 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-11 05:32:04 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-11 05:31:57 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 183.11 MiB 91.55 MiB 91.55 MiB 91.55 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-11 05:30:40 Duration: 38s409ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-11 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 239.81 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-11 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 239.81 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-11 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 91.55 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-11 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 91.55 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-11 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 79.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-11 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 79.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-11 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 79.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-11 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 71.61 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-11 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 71.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-11 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 71.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-11 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 8.22 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-11 10:58:51 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 8.22 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-11 10:58:51 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (107) Main table analyzed (database rio)
- 1,061 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 107 rio.public.temp0000288012 70 rio.pg_catalog.pg_class 59 rio.public.usuarios 49 rio.pg_catalog.pg_type 48 contagem.pg_catalog.pg_attribute 47 rio.public.temp0000288072 43 brasilia.pg_catalog.pg_attribute 39 brasilia.public.temp0000237926 37 contagem.public.usuarios 37 rio.pg_catalog.pg_index 35 rio.public.temp0000288002 31 brasilia.public.temp0000237928 30 rio.public.temp0000288026 24 brasilia.public.temp0000237900 24 rio.public.temp0000287821 24 rio.pg_catalog.pg_depend 24 contagem.pg_catalog.pg_class 21 rio.public.temp0000287998 21 rio.public.temp0000288032 20 contagem.pg_catalog.pg_type 17 brasilia.pg_catalog.pg_class 16 brasilia.pg_catalog.pg_type 13 contagem.public.temp0000226800 11 contagem.public.temp0000226818 11 contagem.pg_catalog.pg_index 11 rio.public.temp0000287388 11 contagem.pg_catalog.pg_depend 9 brasilia.public.temp0000237896 9 brasilia.public.usuarios 9 contagem.public.temp0000226812 9 rio.public.temp0000287406 9 rio.public.temp0000288068 9 brasilia.pg_catalog.pg_index 8 rio.public.temp0000287877 8 rio.public.temp0000287986 7 rio.public.temp0000287312 7 rio.public.temp0000288006 5 brasilia.pg_catalog.pg_depend 5 contagem.pg_catalog.pg_shdepend 5 rio.public.temp0000288000 4 brasilia.public.temp0000237918 4 rio.public.temp0000288028 4 brasilia.public.temp0000237914 4 rio.public.temp0000288052 3 rio.public.temp0000288054 3 rio.public.temp0000288058 3 brasilia.pg_catalog.pg_shdepend 3 brasilia.public.temp0000237924 3 contagem.public.temp0000226820 3 rio.public.tmp_drill_0302 2 rio.public.temp0000288014 2 rio.pg_catalog.pg_shdepend 2 brasilia.public.temp0000237892 2 contagem.public.temp0000226816 2 rio.public.temp0000288064 2 rio.public.temp0000288106 2 brasilia.public.temp0000237962 2 rio.public.tmp_drill_0320 2 brasilia.public.temp0000237952 2 rio.public.temp0000288094 2 brasilia.public.temp0000237904 1 rio.public.temp0000288030 1 contagem.public.nf_entrada 1 rio.public.temp0000288092 1 brasilia.public.temp0000237894 1 rio.public.temp0000288060 1 rio.public.temp0000288018 1 postgres.pg_catalog.pg_shdepend 1 contagem.public.temp0000226814 1 rio.public.temp0000288022 1 brasilia.public.temp0000237940 1 rio.public.temp0000288020 1 rio.public.temp0000288066 1 rio.public.temp0000287996 1 rio.public.temp0000288036 1 brasilia.public.temp0000237956 1 brasilia.public.temp0000237902 1 brasilia.public.temp0000237916 1 contagem.auditor.auditor_2026_08 1 rio.public.temp0000288016 1 rio.public.temp0000288080 1 brasilia.public.temp0000237930 1 brasilia.public.temp0000237910 1 rio.auditor.auditor_2026_08 1 brasilia.auditor.auditor_2026_08 1 rio.public.temp0000288062 1 Total 1,061 Vacuums per table
Key values
- public.temp0000288012 (71) Main table vacuumed on database rio
- 485 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000288012 71 0 0 0 0 0 0 46,319 2,064 4,995,109 0 0 rio.pg_catalog.pg_attribute 44 36 0 0 0 0 0 20,295 5,521 8,256,602 336 8,127 contagem.public.usuarios 36 0 0 0 0 0 0 181 134 67,661 0 0 rio.pg_catalog.pg_class 28 22 0 0 0 0 0 4,599 1,555 2,300,653 77 258 brasilia.public.temp0000237926 25 0 0 0 0 0 0 5,961 1,354 2,260,425 0 0 rio.pg_catalog.pg_type 24 20 0 0 0 0 0 2,138 668 834,345 74 209 rio.public.temp0000288072 22 0 0 0 0 0 0 2,137 228 363,661 0 0 rio.public.temp0000288032 20 0 0 0 0 0 0 20,656 1,785 3,438,938 0 0 rio.public.temp0000288026 16 0 0 0 0 0 0 5,625 79 344,024 0 0 rio.public.temp0000287821 16 0 0 0 0 0 0 1,178 253 362,697 0 0 contagem.pg_catalog.pg_attribute 16 16 0 0 0 0 0 8,762 2,370 4,271,613 30 798 rio.pg_catalog.pg_index 16 13 0 0 0 0 0 889 263 259,101 45 86 rio.pg_catalog.pg_depend 11 11 0 0 0 0 0 3,349 1,230 1,674,699 68 577 brasilia.pg_catalog.pg_attribute 11 11 0 0 0 0 0 5,497 1,780 2,679,180 52 1,587 rio.public.temp0000287388 11 0 0 0 0 0 0 1,250 208 344,258 0 0 contagem.pg_catalog.pg_class 7 7 0 0 0 0 0 1,104 275 385,788 13 32 contagem.pg_catalog.pg_type 7 7 0 0 0 0 0 669 201 293,532 5 10 rio.public.temp0000287312 7 0 0 0 0 0 0 609 39 41,919 0 0 rio.public.temp0000287877 7 0 0 0 0 0 0 539 39 38,360 0 0 rio.public.temp0000287406 7 0 0 0 0 0 0 671 40 46,157 0 0 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 9,566 2,031 9,558,107 922 4,012 brasilia.pg_catalog.pg_type 4 4 0 0 0 0 0 326 135 179,197 14 48 rio.public.temp0000288028 4 0 0 0 0 0 0 313 22 21,783 0 0 contagem.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,180 361 665,696 7 42 rio.public.usuarios 4 4 0 0 0 0 0 88 25 45,876 3 5 brasilia.pg_catalog.pg_class 4 4 0 0 0 0 0 703 298 451,591 18 57 brasilia.public.temp0000237914 4 0 0 0 0 0 0 993 265 439,743 0 0 brasilia.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 612 200 312,792 34 64 brasilia.pg_catalog.pg_statistic 4 4 0 0 0 0 0 4,995 850 3,753,862 487 2,975 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 209 78 72,971 5 6 rio.public.tmp_drill_0302 3 2 0 0 0 0 0 140 44 78,823 0 0 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,738 355 2,063,329 125 411 contagem.public.temp0000226820 3 0 0 0 0 0 0 266 18 18,448 0 0 brasilia.public.temp0000237892 2 0 0 0 0 0 0 496 12 31,560 0 0 brasilia.pg_catalog.pg_index 2 2 0 0 0 0 0 132 46 24,424 8 17 rio.public.tmp_drill_0320 2 2 0 0 0 0 0 53 7 11,137 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 283 54 211,174 29 51 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,834 240 929,487 173 1,346 postgres.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 265 91 161,479 21 51 rio.public.temp0000288014 2 0 0 0 0 0 0 1,782 8 106,344 0 0 rio.auditor.auditor_2026_08 2 0 0 0 0 0 0 89,505 45,082 60,735,599 21,283 506,087 rio.public.temp0000288058 2 0 0 0 0 0 0 129 11 9,433 0 0 brasilia.pg_catalog.pg_depend 2 2 0 0 0 0 0 601 236 300,533 15 120 rio.public.temp0000288036 1 0 0 0 0 0 0 4 3 774 0 0 brasilia.public.temp0000237902 1 0 0 0 0 0 0 248 6 15,780 0 0 rio.public.temp0000288016 1 0 0 0 0 0 0 4 3 774 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 137 25 86,208 16 39 rio.public.temp0000288060 1 0 0 0 0 0 0 8 5 1,295 0 0 contagem.auditor.auditor_2026_08 1 0 0 0 0 0 0 14,609 10,174 12,410,696 2,196 37,982 rio.public.temp0000288092 1 0 0 0 0 0 0 8 5 1,297 0 0 rio.public.temp0000288018 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000288080 1 0 0 0 0 0 0 83 6 5,799 0 0 brasilia.auditor.auditor_2026_08 1 0 0 0 0 0 0 19,165 11,342 14,315,996 3,906 69,594 rio.public.temp0000288062 1 0 0 0 0 0 0 8 5 1,295 0 0 Total 485 196 0 0 0 0 0 283,915 92,132 140,282,798 29,962 634,591 Vacuum throughput per table
Key values
- public.usuarios (14.86) 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.public.temp0000288012 0 0 2.1 rio.pg_catalog.pg_attribute 0 0 2.97 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_class 0 0 0.99 brasilia.public.temp0000237926 0 0 0.53 rio.pg_catalog.pg_type 0 0 0.34 rio.public.temp0000288072 0 0 0.2 rio.public.temp0000288032 0 0 0.95 rio.public.temp0000288026 0 0 0.36 rio.public.temp0000287821 0 0 0.18 contagem.pg_catalog.pg_attribute 0 0 1.47 rio.pg_catalog.pg_index 0 0 0.17 rio.pg_catalog.pg_depend 0 0 0.73 brasilia.pg_catalog.pg_attribute 0 0 1.28 rio.public.temp0000287388 0 0 0.11 contagem.pg_catalog.pg_class 0 0 0.26 contagem.pg_catalog.pg_type 0 0 0.19 rio.public.temp0000287312 0 0 0.07 rio.public.temp0000287877 0 0 0.14 rio.public.temp0000287406 0 0 0.12 rio.pg_catalog.pg_statistic 0 0 1.06 brasilia.pg_catalog.pg_type 0 0 0.17 rio.public.temp0000288028 0 0 0.04 contagem.pg_catalog.pg_depend 0 0 0.34 rio.public.usuarios 0 0 14.86 brasilia.pg_catalog.pg_class 0 0 0.34 brasilia.public.temp0000237914 0 0 0.09 brasilia.pg_catalog.pg_shdepend 0 0 0.16 brasilia.pg_catalog.pg_statistic 0 0 0.43 contagem.pg_catalog.pg_index 0 0 0.23 rio.public.tmp_drill_0302 0 0 0.03 rio.pg_toast.pg_toast_2619 0 0 0.14 contagem.public.temp0000226820 0 0 0.05 brasilia.public.temp0000237892 0 0 0.03 brasilia.pg_catalog.pg_index 0 0 0.06 rio.public.tmp_drill_0320 0 0 0 brasilia.pg_toast.pg_toast_2619 0 0 0.02 contagem.pg_catalog.pg_statistic 0 0 0.2 postgres.pg_catalog.pg_shdepend 0 0 0.16 rio.public.temp0000288014 0 0 0.04 rio.auditor.auditor_2026_08 0 0 11.22 rio.public.temp0000288058 0 0 0.02 brasilia.pg_catalog.pg_depend 0 0 0.25 rio.public.temp0000288036 0 0 0.04 brasilia.public.temp0000237902 0 0 0.01 rio.public.temp0000288016 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0.01 rio.public.temp0000288060 0 0 0.01 contagem.auditor.auditor_2026_08 0 0 3.6 rio.public.temp0000288092 0 0 0.01 rio.public.temp0000288018 0 0 0 rio.public.temp0000288080 0 0 0.02 brasilia.auditor.auditor_2026_08 0 0 3.84 rio.public.temp0000288062 0 0 0.01 Total 0 0 50.65 Tuples removed per table
Key values
- pg_catalog.pg_attribute (159808) Main table with removed tuples on database rio
- 333319 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 44 36 159,808 1,126,629 86,602 137 27,618 contagem.pg_catalog.pg_attribute 16 16 54,097 377,496 0 57 8,637 brasilia.pg_catalog.pg_attribute 11 11 37,141 235,665 0 0 6,215 rio.pg_catalog.pg_statistic 7 7 12,702 58,216 34 0 9,002 rio.pg_catalog.pg_depend 11 11 10,156 214,981 6,028 0 2,057 rio.auditor.auditor_2026_08 2 0 9,277 11,136,957 0 0 528,288 brasilia.pg_catalog.pg_statistic 4 4 7,563 33,429 0 0 4,288 rio.pg_catalog.pg_type 24 20 7,487 59,970 5,572 17 1,773 contagem.pg_catalog.pg_statistic 2 2 5,273 14,911 0 0 2,022 rio.pg_catalog.pg_index 16 13 3,599 32,779 2,205 0 928 brasilia.pg_catalog.pg_shdepend 4 4 3,370 54,542 272 0 476 brasilia.pg_catalog.pg_depend 2 2 3,093 35,943 0 0 354 contagem.pg_catalog.pg_depend 4 4 3,052 75,469 0 0 704 rio.pg_catalog.pg_class 28 22 3,032 112,090 17,162 47 3,679 contagem.public.usuarios 36 0 2,310 871 7 0 72 postgres.pg_catalog.pg_shdepend 2 2 1,886 27,466 259 0 238 contagem.pg_catalog.pg_type 7 7 1,790 15,759 0 15 438 contagem.pg_catalog.pg_class 7 7 1,746 23,642 0 0 854 rio.pg_toast.pg_toast_2619 3 3 1,035 2,126 0 0 816 brasilia.pg_catalog.pg_class 4 4 957 13,574 4 0 416 contagem.pg_catalog.pg_index 4 4 761 7,592 0 6 202 rio.public.tmp_drill_0302 3 2 760 3,040 760 0 63 brasilia.pg_catalog.pg_type 4 4 724 8,888 0 0 256 brasilia.auditor.auditor_2026_08 1 0 720 1,486,839 0 0 66,762 brasilia.pg_catalog.pg_index 2 2 523 3,763 0 5 108 rio.public.usuarios 4 4 182 2,484 448 1 66 brasilia.pg_toast.pg_toast_2619 2 2 177 280 0 0 118 contagem.pg_toast.pg_toast_2619 1 1 98 114 0 4 47 rio.public.temp0000288026 16 0 0 143,626 0 557 9,363 rio.public.temp0000288012 71 0 0 819,934 0 1,848 55,112 rio.public.temp0000287821 16 0 0 66,621 0 496 1,488 brasilia.public.temp0000237926 25 0 0 79,900 0 400 6,000 brasilia.public.temp0000237892 2 0 0 6,392 0 32 480 rio.public.temp0000288036 1 0 0 24,215 0 0 1,728 brasilia.public.temp0000237902 1 0 0 3,196 0 16 240 rio.public.temp0000288016 1 0 0 1,198 0 0 64 rio.public.temp0000288028 4 0 0 5,757 0 161 287 rio.public.temp0000288060 1 0 0 1,534 0 53 75 contagem.auditor.auditor_2026_08 1 0 0 1,228,059 0 0 55,056 rio.public.temp0000287312 7 0 0 29,912 0 164 668 rio.public.temp0000288092 1 0 0 1,575 0 51 77 rio.public.temp0000287877 7 0 0 40,225 0 379 901 rio.public.tmp_drill_0320 2 2 0 447 0 0 13 rio.public.temp0000287406 7 0 0 38,807 0 286 866 rio.public.temp0000288018 1 0 0 1,198 0 0 64 rio.public.temp0000288032 20 0 0 484,557 0 0 34,560 rio.public.temp0000288080 1 0 0 1,535 0 53 75 brasilia.public.temp0000237914 4 0 0 12,784 0 64 960 rio.public.temp0000288014 2 0 0 25,402 0 0 1,792 rio.public.temp0000288072 22 0 0 124,252 0 482 4,190 rio.public.temp0000288062 1 0 0 1,534 0 53 75 contagem.public.temp0000226820 3 0 0 3,692 0 78 242 rio.public.temp0000288058 2 0 0 9,959 0 34 222 rio.public.temp0000287388 11 0 0 52,781 0 352 1,184 Total 485 196 333,319 18,374,607 119,353 5,848 842,279 Pages removed per table
Key values
- public.temp0000288012 (1848) Main table with removed pages on database rio
- 5848 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000288012 71 0 0 1848 rio.public.temp0000288026 16 0 0 557 rio.public.temp0000287821 16 0 0 496 rio.public.temp0000288072 22 0 0 482 brasilia.public.temp0000237926 25 0 0 400 rio.public.temp0000287877 7 0 0 379 rio.public.temp0000287388 11 0 0 352 rio.public.temp0000287406 7 0 0 286 rio.public.temp0000287312 7 0 0 164 rio.public.temp0000288028 4 0 0 161 rio.pg_catalog.pg_attribute 44 36 159808 137 contagem.public.temp0000226820 3 0 0 78 brasilia.public.temp0000237914 4 0 0 64 contagem.pg_catalog.pg_attribute 16 16 54097 57 rio.public.temp0000288060 1 0 0 53 rio.public.temp0000288080 1 0 0 53 rio.public.temp0000288062 1 0 0 53 rio.public.temp0000288092 1 0 0 51 rio.pg_catalog.pg_class 28 22 3032 47 rio.public.temp0000288058 2 0 0 34 brasilia.public.temp0000237892 2 0 0 32 rio.pg_catalog.pg_type 24 20 7487 17 brasilia.public.temp0000237902 1 0 0 16 contagem.pg_catalog.pg_type 7 7 1790 15 contagem.pg_catalog.pg_index 4 4 761 6 brasilia.pg_catalog.pg_index 2 2 523 5 contagem.pg_toast.pg_toast_2619 1 1 98 4 rio.public.usuarios 4 4 182 1 contagem.pg_catalog.pg_class 7 7 1746 0 brasilia.pg_catalog.pg_type 4 4 724 0 rio.pg_catalog.pg_depend 11 11 10156 0 rio.public.temp0000288036 1 0 0 0 rio.public.temp0000288016 1 0 0 0 contagem.auditor.auditor_2026_08 1 0 0 0 rio.public.tmp_drill_0302 3 2 760 0 contagem.pg_catalog.pg_depend 4 4 3052 0 brasilia.pg_catalog.pg_attribute 11 11 37141 0 rio.public.tmp_drill_0320 2 2 0 0 brasilia.pg_toast.pg_toast_2619 2 2 177 0 rio.pg_toast.pg_toast_2619 3 3 1035 0 brasilia.pg_catalog.pg_class 4 4 957 0 contagem.public.usuarios 36 0 2310 0 rio.public.temp0000288018 1 0 0 0 contagem.pg_catalog.pg_statistic 2 2 5273 0 postgres.pg_catalog.pg_shdepend 2 2 1886 0 rio.public.temp0000288032 20 0 0 0 rio.pg_catalog.pg_statistic 7 7 12702 0 brasilia.pg_catalog.pg_shdepend 4 4 3370 0 rio.public.temp0000288014 2 0 0 0 rio.auditor.auditor_2026_08 2 0 9277 0 brasilia.auditor.auditor_2026_08 1 0 720 0 brasilia.pg_catalog.pg_statistic 4 4 7563 0 brasilia.pg_catalog.pg_depend 2 2 3093 0 rio.pg_catalog.pg_index 16 13 3599 0 Total 485 196 333,319 5,848 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 11 00 1 0 01 0 2 02 0 0 03 0 4 04 0 0 05 6 2 06 0 0 07 3 16 08 67 100 09 75 137 10 69 133 11 34 92 12 14 51 13 42 106 14 70 154 15 50 119 16 29 80 17 21 57 18 2 2 19 0 0 20 0 0 21 2 3 22 0 3 23 0 0 - 8.22 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 3 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 2m48s 2m48s 2m48s 2m48s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-11 15:18:01 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-11 20:05:15 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-11 00:05:26 Database: rio User: intelifix Remote: [local] Application: psql
2 1 1s671ms 1s671ms 1s671ms 1s671ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276679, 508, '922081098783,D833B7CA50A1,B0BBE54B5D5C,345D9EB43D19,ACD75BB5EA37,D0CF0EFDE8B2,943C96AB59FD,64FD965656B0,209A7DBB1A2C,5CFA259B8CE9,582FF7971C3E,E8D2FFA7289D,3453D2A7C01B,94988F95B111,ACD75BB80D6B,582FF78CE0E2,F081751CBC18,8CFDDE8DF3FC,44D454952050,5CFA25156292,CC5830E2146D,943C96ADB91A,44D454A3264B,8CFDDE8E03FB,CC5830E361A3,5447CC775E65,209A7DBB1C08,E4C0E23FF897,582FF78CF1DD,841EA38E0587,8CFDDE87AA98,64FD9656551A,48295246064F,94988F30E607,E4C0E2410E2F,582FF78CD7DC,841EA391B129,5447CC7815ED,E4C0E24018AA', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-11 13:47:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276685, 450, 'ZTE3ANNR9315732,D89A0D83D0C3,D89A0D83D0C4,ZTEGDB14B173$ZTE3ANNR2Q18136,F4E84F825D10,F4E84F825D11,ZTEGD97AB992$ZTE3ANNR2Q36862,F4E84F8413F4,F4E84F8413F5,ZTEGD97B02B8$ZTE3ANNR6R14571,48D68236DA44,48D68236DA45,ZTEGDB0163BE$ZTE3ANNRC511703,6C11BA633C21,6C11BA633C22,ZTEGDC6E4376$ZTE3ANNQ3R06957,3CF9F0A322D4,3CF9F0A322D5,ZTEGD6401B2C$ZTE3ANNR9F49748,D89A0DA76BDB,D89A0DA76BDC,ZTEGDB15E99F$ZTE3ANNR3Y16586,4896D9514574,4896D9514575,ZTEGD97E717F$ZTE3ANNQ9329656,843C99354C4D,843C99354C4E,ZTEGD7BC2FCF$ZTE3ANNRB717952,5872C98FDDF1,5872C98FDDF2,ZTEGDC6170F3$ZTE3ANNRC525777,6C11BA6485FD,6C11BA6485FE,ZTEGDC6E7A70$ZTE3ANNRCP18552,6C11BA6ADD9F,6C11BA6ADDA0,ZTEGDC6F890B$ZTE3ANNR9319938,D89A0D843357,D89A0D843358,ZTEGDB14C1E1$ZTE3ANNRB708811,5872C98F07B3,5872C98F07B4,ZTEGDC614D3E$ZTE3ANNQ7915207,C4EBFF8D827A,C4EBFF8D827B,ZTEGD70ABBD5$ZTE3ANNQ9J03333,843C992C1F53,843C992C1F54,ZTEGD7BB15B0$ZTE3ANNQ9J19654,843C992D9DD9,843C992D9DDA,ZTEGD7BB5571$ZTE3ANNQ4N03631,3CF9F0A8E6C8,3CF9F0A8E6C9,ZTEGD641112A$ZTE3ANNQ9J26235,843C992E3817,843C992E3818,ZTEGD7BB6F26$ZTE3ANNR8C09816,3891484F6D17,3891484F6D18,ZTEGDB08A6C8$ZTE3ANNQ8128785,689E29BE8171,689E29BE8172,ZTEGD7B7AB01$ZTE3ANNRAM13946,5872C9887F15,5872C9887F16,ZTEGDC603679$ZTE3ANNR9F51887,D89A0DA79DFD,D89A0DA79DFE,ZTEGDB15F1FA$ZTE3ANNRCP17688,6C11BA6AC95F,6C11BA6AC960,ZTEGDC6F85AB$ZTE3ANNR4N01462,4896D9557D5C,4896D9557D5D,ZTEGD97F257B$ZTE3ANNR2Q26335,F4E84F831D3A,F4E84F831D3B,ZTEGD97AD999$ZTE3ANNQ5N17373,3CF9F0AE5CA4,3CF9F0AE5CA5,ZTEGD641FA24$ZTE3ANNRAD13688,D89A0DAF1B33,D89A0DAF1B34,ZTEGDB173183$ZTE3ANNR5W64233,48D682346540,48D682346541,ZTEGDB00FAE8$ZTE3ANNQ8128286,689E29BE75BF,689E29BE75C0,ZTEGD7B7A90E$ZTE3ANNQ8M03304,843C991F155B,843C991F155C,ZTEGD7BA5455$ZTE3ANNT2V82387,D831399319CA,D831399319CB,ZTEGDD313452$ZTE3ANNT2V74912,D83139926A98,D83139926A99,ZTEGDD31171F$ZTE3ANNR6R17751,48D6823724CC,48D6823724CD,ZTEGDB01702A$ZTE3ANNR1Y28431,14CA56CF44D5,14CA56CF44D6,ZTEGD970E56A$ZTE3ANNR9F51709,D89A0DA799D1,D89A0DA799D2,ZTEGDB15F148$ZTE3ANNR5W43019,48D68232740C,48D68232740D,ZTEGDB00A80A$ZTE3ANNR9F30065,D89A0DA59E89,D89A0DA59E8A,ZTEGDB159CBC$ZTE3ANNT4P10324,F00C514C9896,F00C514C9897,ZTEGDE341EEA$ZTE3ANNR2Q24632,F4E84F82F550,F4E84F82F551,ZTEGD97AD2F2', '',0318,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-11 15:42:28 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276685, 450, 'ZTE3ANNT4P23284,F00C514DC856,F00C514DC857,ZTEGDE34518A$ZTE3ANNRAD16240,D89A0DAF5703,D89A0DAF5704,ZTEGDB173B7B$ZTE3ANNR2Q20197,F4E84F828D5E,F4E84F828D5F,ZTEGD97AC19F$ZTE3ANNRB707919,5872C98EF2CB,5872C98EF2CC,ZTEGDC6149C2$ZTE3ANNR9W55343,D89A0DAD6D3D,D89A0DAD6D3E,ZTEGDB16E9DA$ZTE3ANNR1Y25742,14CA56CF05CF,14CA56CF05D0,ZTEGD970DAE9$ZTE3ANNQ7914697,C4EBFF8D7686,C4EBFF8D7687,ZTEGD70AB9D7$ZTE3ANNRB722599,5872C9904ADB,5872C9904ADC,ZTEGDC61831A$ZTE3ANNQCA23280,14CA56D4667B,14CA56D4667C,ZTEGD971C05B$ZTE3ANNR6R17367,48D682371BCC,48D682371BCD,ZTEGDB016EAA$ZTE3ANNR8C19664,3891485053E7,3891485053E8,ZTEGDB08CD40$ZTE3ANNT2V31948,D831398E7BA0,D831398E7BA1,ZTEGDD306F4B$ZTE3ANNQ3R04450,3CF9F0A2E812,3CF9F0A2E813,ZTEGD6401161$ZTE3ANNQ8128329,689E29BE76C1,689E29BE76C2,ZTEGD7B7A939$ZTE3ANNQCA23349,14CA56D46819,14CA56D4681A,ZTEGD971C0A0$ZTE3ANNRCP17466,6C11BA6AC42B,6C11BA6AC42C,ZTEGDC6F84CD$ZTE3ANNR8C10942,3891484F877B,3891484F877C,ZTEGDB08AB2E$ZTE3ANNR9F14281,D89A0DA42C99,D89A0DA42C9A,ZTEGDB155F14$ZTE3ANNR6R44331,48D6823993C4,48D6823993C5,ZTEGDB01D7FE$ZTE3ANNR9318172,D89A0D8409F3,D89A0D8409F4,ZTEGDB14BAFB$ZTE3ANNR8C19245,389148504A15,389148504A16,ZTEGDB08CB9D$ZTE3ANNRB724925,5872C990815F,5872C9908160,ZTEGDC618C30$ZTE3ANNRB733111,5872C991413B,5872C991413C,ZTEGDC61AC2A$ZTE3ANNR5W33239,48D682318ED4,48D682318ED5,ZTEGDB0081D6$ZTE3ANNRCP45488,6C11BA6D54EF,6C11BA6D54F0,ZTEGDC6FF243$ZTE3ANNT4P26820,F00C514E1B36,F00C514E1B37,ZTEGDE345F5A$ZTE3ANNQ7111336,C4EBFF8AD218,C4EBFF8AD219,ZTEGD70A491A$ZTE3ANNRB708941,5872C98F0ABF,5872C98F0AC0,ZTEGDC614DC0$ZTE3ANNQ8M24008,843C9920FA9B,843C9920FA9C,ZTEGD7BAA535$ZTE3ANNRCB15669,D831391F3E3C,D831391F3E3D,ZTEGDD29F2CA$ZTE3ANNR9W55304,D89A0DAD6C53,D89A0DAD6C54,ZTEGDB16E9B3$ZTE3ANNQ9J29519,843C992E850F,843C992E8510,ZTEGD7BB7BFA$ZTE3ANNR8C53814,38914853744B,38914853744C,ZTEGDB0952A6$ZTE3ANNQ4A02454,3CF9F0AA31CA,3CF9F0AA31CB,ZTEGD6414855$ZTE3ANNT4P23964,F00C514DD846,F00C514DD847,ZTEGDE345432$ZTE3ANNT4P23285,F00C514DC85C,F00C514DC85D,ZTEGDE34518B$ZTE3ANNT4P27137,F00C514E22A4,F00C514E22A5,ZTEGDE346097$ZTE3ANNT2V69681,D8313991EFFE,D8313991EFFF,ZTEGDD3102B0$ZTE3ANNR9F10396,D89A0DA3D18B,D89A0DA3D18C,ZTEGDB154FE7', '',0318,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-11 15:49:20 Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000288012;-
DROP TABLE IF EXISTS temp0000288012;
Date: 2026-08-11 14:32:46 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000288012;
Date: 2026-08-11 09:16:43 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 2m48s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-11 15:17:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1s671ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276683, 503, '929240188137,9C24722FEBCD', '',0302,00,'[{"item":"0","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);[ Date: 2026-08-11 16:32:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 1s1ms DROP TABLE IF EXISTS temp0000288012;[ Date: 2026-08-11 14:32:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,018 Total read queries
- 1,472 Total write queries
Queries by database
Key values
- rio Main database
- 3,793 Requests
- 6h9m37s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 5,888 Requests
User Request type Count Duration etiquetas Total 41 7s943ms select 41 7s943ms intelifix Total 5,888 8h7m10s copy to 403 41m57s ddl 1,069 48m5s others 551 47m21s select 3,865 5h49m44s lenon Total 112 1m7s select 112 1m7s Duration by user
Key values
- 8h7m10s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 41 7s943ms select 41 7s943ms intelifix Total 5,888 8h7m10s copy to 403 41m57s ddl 1,069 48m5s others 551 47m21s select 3,865 5h49m44s lenon Total 112 1m7s select 112 1m7s Queries by host
Key values
- [local] Main host
- 6,041 Requests
- 8h8m25s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,851 Requests
- 4h21m29s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-11 04:03:29 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,897 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-11 09:14:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-11 07:14:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m8s analyze verbose;[ Date: 2026-08-11 05:09:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 9m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-11 15:14:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 9m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-11 16:14:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m57s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-11 14:13:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-11 11:13:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-11 10:13:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 8m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-11 12:13:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 8m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-11 20:13:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-11 17:12:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-11 13:11:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m22s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028280, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-11 09:55:06 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 6m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-11 08:11:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 6m8s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028313, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-11 14:30:06 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 6m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-11 21:11:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-11 19:10:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-11 18:10:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-11 22:10:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m42s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028257, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-11 08:09:13 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h12m26s 48 1s557ms 9m34s 2m45s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 11 07 3 9m52s 3m17s 08 3 6m33s 2m11s 09 3 10m17s 3m25s 10 3 8m54s 2m58s 11 3 9m24s 3m8s 12 3 9m6s 3m2s 13 3 7m4s 2m21s 14 3 9m42s 3m14s 15 3 9m44s 3m14s 16 3 9m43s 3m14s 17 3 8m23s 2m47s 18 3 6m12s 2m4s 19 3 6m12s 2m4s 20 3 8m49s 2m56s 21 3 6m19s 2m6s 22 3 6m4s 2m1s [ User: intelifix - Total duration: 2h12m26s - Times executed: 48 ]
[ Application: psql - Total duration: 2h12m26s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-11 09:14:35 Duration: 9m34s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-11 07:14:12 Duration: 9m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-11 15:14:05 Duration: 9m3s Database: rio User: intelifix Remote: [local] Application: psql
2 1h29m58s 274 151ms 6m22s 19s703ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 11 07 7 39s907ms 5s701ms 08 37 11m37s 18s839ms 09 17 10m28s 36s986ms 10 47 11m24s 14s563ms 11 26 11m42s 27s13ms 12 10 15m16s 1m31s 13 23 1m41s 4s394ms 14 36 7m49s 13s34ms 15 19 11m58s 37s837ms 16 37 6m30s 10s561ms 17 15 49s319ms 3s287ms [ User: intelifix - Total duration: 1h29m58s - Times executed: 274 ]
[ Application: [unknown] - Total duration: 1h29m58s - Times executed: 274 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028280, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-11 09:55:06 Duration: 6m22s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028313, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-11 14:30:06 Duration: 6m8s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028257, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-11 08:09:13 Duration: 5m42s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h13m58s 48 206ms 4m26s 1m32s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 11 07 3 4m57s 1m39s 08 3 4m1s 1m20s 09 3 5m37s 1m52s 10 3 5m6s 1m42s 11 3 5m4s 1m41s 12 3 5m25s 1m48s 13 3 4m1s 1m20s 14 3 5m23s 1m47s 15 3 5m30s 1m50s 16 3 5m32s 1m50s 17 3 4m12s 1m24s 18 3 3m39s 1m13s 19 3 3m39s 1m13s 20 3 4m27s 1m29s 21 3 3m35s 1m11s 22 3 3m42s 1m14s [ User: intelifix - Total duration: 1h13m58s - Times executed: 48 ]
[ Application: psql - Total duration: 1h13m58s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-11 09:20:48 Duration: 4m26s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-11 15:20:09 Duration: 4m23s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-11 16:20:10 Duration: 4m19s Database: brasilia User: intelifix Remote: [local] Application: psql
4 21m34s 1,395 150ms 5s764ms 928ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 11 08 95 51s374ms 540ms 09 156 1m45s 679ms 10 151 1m59s 793ms 11 114 1m35s 837ms 12 33 28s647ms 868ms 13 100 1m18s 787ms 14 251 4m19s 1s34ms 15 185 3m42s 1s203ms 16 226 3m59s 1s60ms 17 84 1m32s 1s102ms [ User: intelifix - Total duration: 21m34s - Times executed: 1395 ]
[ Application: [unknown] - Total duration: 21m34s - Times executed: 1395 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276679, 508, '922081098783,D833B7CA50A1,B0BBE54B5D5C,345D9EB43D19,ACD75BB5EA37,D0CF0EFDE8B2,943C96AB59FD,64FD965656B0,209A7DBB1A2C,5CFA259B8CE9,582FF7971C3E,E8D2FFA7289D,3453D2A7C01B,94988F95B111,ACD75BB80D6B,582FF78CE0E2,F081751CBC18,8CFDDE8DF3FC,44D454952050,5CFA25156292,CC5830E2146D,943C96ADB91A,44D454A3264B,8CFDDE8E03FB,CC5830E361A3,5447CC775E65,209A7DBB1C08,E4C0E23FF897,582FF78CF1DD,841EA38E0587,8CFDDE87AA98,64FD9656551A,48295246064F,94988F30E607,E4C0E2410E2F,582FF78CD7DC,841EA391B129,5447CC7815ED,E4C0E24018AA', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-11 13:47:44 Duration: 5s764ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276685, 450, 'ZTE3ANNR9315732,D89A0D83D0C3,D89A0D83D0C4,ZTEGDB14B173$ZTE3ANNR2Q18136,F4E84F825D10,F4E84F825D11,ZTEGD97AB992$ZTE3ANNR2Q36862,F4E84F8413F4,F4E84F8413F5,ZTEGD97B02B8$ZTE3ANNR6R14571,48D68236DA44,48D68236DA45,ZTEGDB0163BE$ZTE3ANNRC511703,6C11BA633C21,6C11BA633C22,ZTEGDC6E4376$ZTE3ANNQ3R06957,3CF9F0A322D4,3CF9F0A322D5,ZTEGD6401B2C$ZTE3ANNR9F49748,D89A0DA76BDB,D89A0DA76BDC,ZTEGDB15E99F$ZTE3ANNR3Y16586,4896D9514574,4896D9514575,ZTEGD97E717F$ZTE3ANNQ9329656,843C99354C4D,843C99354C4E,ZTEGD7BC2FCF$ZTE3ANNRB717952,5872C98FDDF1,5872C98FDDF2,ZTEGDC6170F3$ZTE3ANNRC525777,6C11BA6485FD,6C11BA6485FE,ZTEGDC6E7A70$ZTE3ANNRCP18552,6C11BA6ADD9F,6C11BA6ADDA0,ZTEGDC6F890B$ZTE3ANNR9319938,D89A0D843357,D89A0D843358,ZTEGDB14C1E1$ZTE3ANNRB708811,5872C98F07B3,5872C98F07B4,ZTEGDC614D3E$ZTE3ANNQ7915207,C4EBFF8D827A,C4EBFF8D827B,ZTEGD70ABBD5$ZTE3ANNQ9J03333,843C992C1F53,843C992C1F54,ZTEGD7BB15B0$ZTE3ANNQ9J19654,843C992D9DD9,843C992D9DDA,ZTEGD7BB5571$ZTE3ANNQ4N03631,3CF9F0A8E6C8,3CF9F0A8E6C9,ZTEGD641112A$ZTE3ANNQ9J26235,843C992E3817,843C992E3818,ZTEGD7BB6F26$ZTE3ANNR8C09816,3891484F6D17,3891484F6D18,ZTEGDB08A6C8$ZTE3ANNQ8128785,689E29BE8171,689E29BE8172,ZTEGD7B7AB01$ZTE3ANNRAM13946,5872C9887F15,5872C9887F16,ZTEGDC603679$ZTE3ANNR9F51887,D89A0DA79DFD,D89A0DA79DFE,ZTEGDB15F1FA$ZTE3ANNRCP17688,6C11BA6AC95F,6C11BA6AC960,ZTEGDC6F85AB$ZTE3ANNR4N01462,4896D9557D5C,4896D9557D5D,ZTEGD97F257B$ZTE3ANNR2Q26335,F4E84F831D3A,F4E84F831D3B,ZTEGD97AD999$ZTE3ANNQ5N17373,3CF9F0AE5CA4,3CF9F0AE5CA5,ZTEGD641FA24$ZTE3ANNRAD13688,D89A0DAF1B33,D89A0DAF1B34,ZTEGDB173183$ZTE3ANNR5W64233,48D682346540,48D682346541,ZTEGDB00FAE8$ZTE3ANNQ8128286,689E29BE75BF,689E29BE75C0,ZTEGD7B7A90E$ZTE3ANNQ8M03304,843C991F155B,843C991F155C,ZTEGD7BA5455$ZTE3ANNT2V82387,D831399319CA,D831399319CB,ZTEGDD313452$ZTE3ANNT2V74912,D83139926A98,D83139926A99,ZTEGDD31171F$ZTE3ANNR6R17751,48D6823724CC,48D6823724CD,ZTEGDB01702A$ZTE3ANNR1Y28431,14CA56CF44D5,14CA56CF44D6,ZTEGD970E56A$ZTE3ANNR9F51709,D89A0DA799D1,D89A0DA799D2,ZTEGDB15F148$ZTE3ANNR5W43019,48D68232740C,48D68232740D,ZTEGDB00A80A$ZTE3ANNR9F30065,D89A0DA59E89,D89A0DA59E8A,ZTEGDB159CBC$ZTE3ANNT4P10324,F00C514C9896,F00C514C9897,ZTEGDE341EEA$ZTE3ANNR2Q24632,F4E84F82F550,F4E84F82F551,ZTEGD97AD2F2', '',0318,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-11 15:42:28 Duration: 5s537ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276685, 450, 'ZTE3ANNT4P23284,F00C514DC856,F00C514DC857,ZTEGDE34518A$ZTE3ANNRAD16240,D89A0DAF5703,D89A0DAF5704,ZTEGDB173B7B$ZTE3ANNR2Q20197,F4E84F828D5E,F4E84F828D5F,ZTEGD97AC19F$ZTE3ANNRB707919,5872C98EF2CB,5872C98EF2CC,ZTEGDC6149C2$ZTE3ANNR9W55343,D89A0DAD6D3D,D89A0DAD6D3E,ZTEGDB16E9DA$ZTE3ANNR1Y25742,14CA56CF05CF,14CA56CF05D0,ZTEGD970DAE9$ZTE3ANNQ7914697,C4EBFF8D7686,C4EBFF8D7687,ZTEGD70AB9D7$ZTE3ANNRB722599,5872C9904ADB,5872C9904ADC,ZTEGDC61831A$ZTE3ANNQCA23280,14CA56D4667B,14CA56D4667C,ZTEGD971C05B$ZTE3ANNR6R17367,48D682371BCC,48D682371BCD,ZTEGDB016EAA$ZTE3ANNR8C19664,3891485053E7,3891485053E8,ZTEGDB08CD40$ZTE3ANNT2V31948,D831398E7BA0,D831398E7BA1,ZTEGDD306F4B$ZTE3ANNQ3R04450,3CF9F0A2E812,3CF9F0A2E813,ZTEGD6401161$ZTE3ANNQ8128329,689E29BE76C1,689E29BE76C2,ZTEGD7B7A939$ZTE3ANNQCA23349,14CA56D46819,14CA56D4681A,ZTEGD971C0A0$ZTE3ANNRCP17466,6C11BA6AC42B,6C11BA6AC42C,ZTEGDC6F84CD$ZTE3ANNR8C10942,3891484F877B,3891484F877C,ZTEGDB08AB2E$ZTE3ANNR9F14281,D89A0DA42C99,D89A0DA42C9A,ZTEGDB155F14$ZTE3ANNR6R44331,48D6823993C4,48D6823993C5,ZTEGDB01D7FE$ZTE3ANNR9318172,D89A0D8409F3,D89A0D8409F4,ZTEGDB14BAFB$ZTE3ANNR8C19245,389148504A15,389148504A16,ZTEGDB08CB9D$ZTE3ANNRB724925,5872C990815F,5872C9908160,ZTEGDC618C30$ZTE3ANNRB733111,5872C991413B,5872C991413C,ZTEGDC61AC2A$ZTE3ANNR5W33239,48D682318ED4,48D682318ED5,ZTEGDB0081D6$ZTE3ANNRCP45488,6C11BA6D54EF,6C11BA6D54F0,ZTEGDC6FF243$ZTE3ANNT4P26820,F00C514E1B36,F00C514E1B37,ZTEGDE345F5A$ZTE3ANNQ7111336,C4EBFF8AD218,C4EBFF8AD219,ZTEGD70A491A$ZTE3ANNRB708941,5872C98F0ABF,5872C98F0AC0,ZTEGDC614DC0$ZTE3ANNQ8M24008,843C9920FA9B,843C9920FA9C,ZTEGD7BAA535$ZTE3ANNRCB15669,D831391F3E3C,D831391F3E3D,ZTEGDD29F2CA$ZTE3ANNR9W55304,D89A0DAD6C53,D89A0DAD6C54,ZTEGDB16E9B3$ZTE3ANNQ9J29519,843C992E850F,843C992E8510,ZTEGD7BB7BFA$ZTE3ANNR8C53814,38914853744B,38914853744C,ZTEGDB0952A6$ZTE3ANNQ4A02454,3CF9F0AA31CA,3CF9F0AA31CB,ZTEGD6414855$ZTE3ANNT4P23964,F00C514DD846,F00C514DD847,ZTEGDE345432$ZTE3ANNT4P23285,F00C514DC85C,F00C514DC85D,ZTEGDE34518B$ZTE3ANNT4P27137,F00C514E22A4,F00C514E22A5,ZTEGDE346097$ZTE3ANNT2V69681,D8313991EFFE,D8313991EFFF,ZTEGDD3102B0$ZTE3ANNR9F10396,D89A0DA3D18B,D89A0DA3D18C,ZTEGDB154FE7', '',0318,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-11 15:49:20 Duration: 5s453ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 20m1s 99 9s620ms 37s824ms 12s139ms create table temp0000288012 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 11 08 15 3m15s 13s12ms 09 14 2m45s 11s806ms 10 17 3m22s 11s913ms 11 3 48s607ms 16s202ms 12 16 3m3s 11s450ms 14 14 2m53s 12s393ms 15 15 2m56s 11s765ms 16 5 56s938ms 11s387ms [ User: intelifix - Total duration: 20m1s - Times executed: 99 ]
[ Application: [unknown] - Total duration: 20m1s - Times executed: 99 ]
-
CREATE TABLE temp0000288012 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 08:01:21 Duration: 37s824ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288012 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 11:48:32 Duration: 24s234ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288012 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 10:12:51 Duration: 14s358ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 16m28s 3 2m35s 9m8s 5m29s analyze verbose;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 11 05 3 16m28s 5m29s [ User: intelifix - Total duration: 16m28s - Times executed: 3 ]
[ Application: psql - Total duration: 16m28s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-11 05:09:09 Duration: 9m8s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-11 05:13:55 Duration: 4m45s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-11 05:16:30 Duration: 2m35s Database: contagem User: intelifix Remote: [local] Application: psql
7 14m4s 275 209ms 2m54s 3s69ms call rs_giga_triagem (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 11 00 12 34s209ms 2s850ms 01 12 24s508ms 2s42ms 02 12 24s682ms 2s56ms 03 12 32s669ms 2s722ms 04 12 26s11ms 2s167ms 05 12 30s638ms 2s553ms 06 12 25s330ms 2s110ms 07 12 28s485ms 2s373ms 08 12 26s495ms 2s207ms 09 11 26s417ms 2s401ms 10 12 29s927ms 2s493ms 11 12 25s220ms 2s101ms 12 12 27s350ms 2s279ms 13 12 28s124ms 2s343ms 14 12 36s499ms 3s41ms 15 12 3m23s 16s942ms 16 12 35s452ms 2s954ms 17 12 29s438ms 2s453ms 18 12 26s639ms 2s219ms 19 12 26s515ms 2s209ms 20 12 42s352ms 3s529ms 21 12 27s516ms 2s293ms 22 12 26s411ms 2s200ms [ User: intelifix - Total duration: 14m4s - Times executed: 275 ]
[ Application: psql - Total duration: 14m4s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-11 15:18:01 Duration: 2m54s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-11 20:05:15 Duration: 13s461ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-11 00:05:26 Duration: 11s129ms Database: rio User: intelifix Remote: [local] Application: psql
8 8m46s 991 150ms 2s668ms 531ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 11 07 20 6s686ms 334ms 08 111 56s945ms 513ms 09 147 1m22s 564ms 10 126 1m 480ms 11 118 57s959ms 491ms 12 15 10s463ms 697ms 13 123 1m10s 569ms 14 141 1m8s 488ms 15 133 1m15s 566ms 16 41 26s572ms 648ms 17 16 10s78ms 629ms [ User: intelifix - Total duration: 8m46s - Times executed: 991 ]
[ Application: [unknown] - Total duration: 8m46s - Times executed: 991 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "276721", "modelo" : "464", "itens" : "241738285959,241762764858,241776135366,241812920820,241747702143,241812914051,241813146475,241812715973,241815766888,241744335057,241765408809,241745702834,241746092345,241762641536,241759880526,241765516069,241759921214,241765525565,241765412951,241813963031,241764203450,241761152838,241747222747,241762552638,241812747693,241812712640,241740705264,241739548596,241763331839,241764397688,241778910924,241748151738,241767763741,241772397481,241813857891,241774160202,241745982637,241742109812,241770067882,241759696062,241770585464,241764596978,241777962032,241771108804,241771262332,241746492642,241760062642,241760007989,241762562033,241769016478,241762549506,241760033952,241779263236,241765238185,241769978806,241779147388,241759533342,241814588603,241740757390,241746423140", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-11 13:18:01 Duration: 2s668ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "276536", "modelo" : "464", "itens" : "241745642020,241759007173,241771010209,241775312929,241813144758,241771461622,241747345362,241778680823,241776640624,241764818189,241777711424,241778768181,241765549406,241775262139,241776822942,241744731112,241742809611,241746489308,241762766979,241747499798,241770069903,241746383843,241744754144,241744745860,241771206265,241759932528,241740770322,241769979311,241815843742,241746196978,241777698997,241742581329,241738562429,863400612818305,241762773950,241762852039,241760230919,241778862939,241738339702,241740724660,241744298992,241744752427,241778766363,241778740526,241812923648,863400615314106,241767702647,241778778586,241771323853,241813709112,241770067579,241738269516,241778916883,863400604106079,241776781726,241740796485,241815549617,241769986988,241777915764", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-11 09:20:33 Duration: 2s233ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "276339", "modelo" : "464", "itens" : "241759831834,241744036464,241744731516,241746395258,241762712429,241742765364,241767912847,241764731212,241778108588,241767485880,241759856078,241769214758,241746640311,241772613440,241775601925,241779271722,241742279907,241762475559,241778975879,241778628695,241743721934,241762541425,241779108495,241762346882,241763501833,241770673251,241762419213,241767911332,241762710409,241764412236,241813985558,241771282233,241745663941,241778620312,241747420926,241742834866,241770581828,241746634451,241746453244,241764152536,241758974062,241815767494,241765568195,241814301931,241775623240,241814373453,241814363755,241777490516,241738894661,241778888800,241761428094,241761404355,241759858503,241764576976,241776673556,241739922528,241742843958,241742773042,241774181820,241778764040", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-11 09:14:41 Duration: 2s67ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 7m58s 166 221ms 14s407ms 2s882ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 11 00 6 22s268ms 3s711ms 01 6 8s872ms 1s478ms 02 5 10s421ms 2s84ms 03 6 12s62ms 2s10ms 04 6 11s698ms 1s949ms 05 4 4s769ms 1s192ms 06 1 351ms 351ms 07 10 37s832ms 3s783ms 08 12 55s863ms 4s655ms 09 11 50s226ms 4s566ms 10 12 43s73ms 3s589ms 11 12 45s887ms 3s823ms 12 12 35s369ms 2s947ms 13 10 10s325ms 1s32ms 14 12 35s56ms 2s921ms 15 12 37s734ms 3s144ms 16 10 27s738ms 2s773ms 17 6 7s517ms 1s252ms 20 1 524ms 524ms 21 6 9s683ms 1s613ms 22 6 11s156ms 1s859ms [ User: intelifix - Total duration: 7m58s - Times executed: 166 ]
[ Application: psql - Total duration: 7m58s - Times executed: 166 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-11 00:05:15 Duration: 14s407ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-11 08:45:11 Duration: 10s440ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-11 08:05:11 Duration: 9s771ms Database: rio User: intelifix Remote: [local] Application: psql
10 7m16s 74 1s288ms 24s476ms 5s896ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 11 07 3 9s841ms 3s280ms 08 2 27s740ms 13s870ms 09 2 7s775ms 3s887ms 10 1 5s387ms 5s387ms 11 6 57s392ms 9s565ms 12 3 24s626ms 8s208ms 13 3 35s98ms 11s699ms 14 13 1m17s 5s951ms 15 11 36s198ms 3s290ms 16 13 1m37s 7s536ms 17 16 51s348ms 3s209ms 18 1 5s615ms 5s615ms [ User: intelifix - Total duration: 7m16s - Times executed: 74 ]
[ Application: [unknown] - Total duration: 7m16s - Times executed: 74 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-11', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-11 08:45:07 Duration: 24s476ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-11', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-11 16:00:22 Duration: 22s940ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-11', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-11 13:17:26 Duration: 19s226ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 5m8s 24 10s356ms 40s145ms 12s859ms create table temp0000288032 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 11 08 10 1m54s 11s462ms 09 2 22s934ms 11s467ms 10 6 1m8s 11s335ms 11 1 11s555ms 11s555ms 12 1 12s990ms 12s990ms 13 3 1m4s 21s658ms 14 1 13s530ms 13s530ms [ User: intelifix - Total duration: 5m8s - Times executed: 24 ]
[ Application: [unknown] - Total duration: 5m8s - Times executed: 24 ]
-
CREATE TABLE temp0000288032 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 13:48:25 Duration: 40s145ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288032 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 14:01:05 Duration: 13s530ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288032 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 12:25:16 Duration: 12s990ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 5m2s 75 163ms 1m27s 4s30ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 11 08 11 2m35s 14s115ms 09 18 8s885ms 493ms 10 11 1m57s 10s686ms 11 3 2s535ms 845ms 12 6 3s771ms 628ms 13 2 3s712ms 1s856ms 14 17 6s398ms 376ms 15 5 2s645ms 529ms 16 2 1s500ms 750ms [ User: intelifix - Total duration: 5m2s - Times executed: 75 ]
[ Application: psql - Total duration: 5m2s - Times executed: 75 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028263);
Date: 2026-08-11 08:47:42 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028294);
Date: 2026-08-11 10:58:33 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028262);
Date: 2026-08-11 08:42:55 Duration: 43s274ms Database: rio User: intelifix Remote: [local] Application: psql
13 4m17s 21 10s571ms 14s252ms 12s261ms create table temp0000288072 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 11 14 21 4m17s 12s261ms [ User: intelifix - Total duration: 4m17s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 4m17s - Times executed: 21 ]
-
CREATE TABLE temp0000288072 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 14:18:49 Duration: 14s252ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288072 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 14:41:12 Duration: 13s542ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288072 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 14:47:53 Duration: 13s476ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 3m23s 18 10s14ms 13s189ms 11s318ms create table temp0000288026 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 11 09 18 3m23s 11s318ms [ User: intelifix - Total duration: 3m23s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 3m23s - Times executed: 18 ]
-
CREATE TABLE temp0000288026 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 09:46:04 Duration: 13s189ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288026 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 09:07:36 Duration: 13s74ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288026 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 09:46:26 Duration: 12s172ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 3m14s 55 2s942ms 5s478ms 3s534ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 11 08 5 19s422ms 3s884ms 09 4 14s231ms 3s557ms 10 5 17s577ms 3s515ms 11 5 18s791ms 3s758ms 12 4 14s90ms 3s522ms 13 3 9s840ms 3s280ms 14 3 10s248ms 3s416ms 15 3 9s636ms 3s212ms 16 3 10s11ms 3s337ms 17 3 10s688ms 3s562ms 18 3 9s492ms 3s164ms 19 3 11s57ms 3s685ms 20 4 15s247ms 3s811ms 21 4 13s562ms 3s390ms 22 3 10s506ms 3s502ms [ User: intelifix - Total duration: 3m14s - Times executed: 55 ]
[ Application: psql - Total duration: 3m14s - Times executed: 55 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-11 11:20:10 Duration: 5s478ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-11 08:00:06 Duration: 5s153ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-11 20:00:10 Duration: 4s851ms Database: brasilia User: intelifix Remote: [local] Application: psql
16 3m2s 125 155ms 15s241ms 1s460ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 11 07 6 42s307ms 7s51ms 08 21 10s605ms 505ms 10 19 9s922ms 522ms 11 9 13s293ms 1s477ms 12 1 3s452ms 3s452ms 13 15 11s135ms 742ms 14 22 12s587ms 572ms 15 8 1m3s 7s993ms 16 24 15s271ms 636ms [ User: intelifix - Total duration: 3m2s - Times executed: 125 ]
[ Application: [unknown] - Total duration: 3m2s - Times executed: 125 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (051812) LIMIT 1;
Date: 2026-08-11 15:42:16 Duration: 15s241ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (051812) LIMIT 1;
Date: 2026-08-11 07:51:58 Duration: 13s544ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (051328) LIMIT 1;
Date: 2026-08-11 15:40:49 Duration: 12s249ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
17 2m48s 53 2s103ms 4s533ms 3s182ms create table temp0000288012 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 11 08 14 35s510ms 2s536ms 09 9 25s700ms 2s855ms 10 4 13s410ms 3s352ms 12 3 8s755ms 2s918ms 14 4 13s826ms 3s456ms 15 9 34s520ms 3s835ms 16 10 36s930ms 3s693ms [ User: intelifix - Total duration: 2m48s - Times executed: 53 ]
[ Application: [unknown] - Total duration: 2m48s - Times executed: 53 ]
-
CREATE TABLE temp0000288012 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"06-08-2026", "ate" :"11-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-11 15:24:33 Duration: 4s533ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288012 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-08-2026", "ate" :"11-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-11 15:24:20 Duration: 4s418ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288012 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-08-2026", "ate" :"11-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-11 10:20:52 Duration: 4s258ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 2m48s 4 4s343ms 1m21s 42s94ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 11 20 2 1m22s 41s474ms 23 2 1m25s 42s715ms [ User: intelifix - Total duration: 2m48s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m48s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-11 23:16:26 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-11 20:08:19 Duration: 1m18s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-11 20:10:00 Duration: 4s364ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 2m12s 35 2s909ms 18s909ms 3s794ms 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 #19
Day Hour Count Duration Avg duration Aug 11 08 1 3s801ms 3s801ms 09 2 6s343ms 3s171ms 10 1 3s421ms 3s421ms 11 1 3s639ms 3s639ms 12 2 6s641ms 3s320ms 13 3 9s640ms 3s213ms 14 3 9s881ms 3s293ms 15 3 9s928ms 3s309ms 16 3 9s814ms 3s271ms 17 3 9s568ms 3s189ms 18 3 9s719ms 3s239ms 19 3 11s9ms 3s669ms 20 2 6s837ms 3s418ms 21 2 22s605ms 11s302ms 22 3 9s952ms 3s317ms [ User: intelifix - Total duration: 2m12s - Times executed: 35 ]
[ Application: psql - Total duration: 2m12s - Times executed: 35 ]
-
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-11 21:20:20 Duration: 18s909ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-11 19:20:05 Duration: 3s949ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-11 08:20:05 Duration: 3s801ms Database: rio User: intelifix Remote: [local] Application: psql
20 2m7s 41 153ms 15s403ms 3s109ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 11 08 7 33s373ms 4s767ms 09 5 18s908ms 3s781ms 10 8 17s400ms 2s175ms 11 1 9s445ms 9s445ms 12 4 7s538ms 1s884ms 13 1 463ms 463ms 14 10 25s326ms 2s532ms 15 4 9s138ms 2s284ms 16 1 5s911ms 5s911ms [ User: intelifix - Total duration: 2m7s - Times executed: 41 ]
[ Application: psql - Total duration: 2m7s - Times executed: 41 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028257);
Date: 2026-08-11 08:03:13 Duration: 15s403ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028275);
Date: 2026-08-11 09:17:55 Duration: 13s900ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028298);
Date: 2026-08-11 11:48:50 Duration: 9s445ms Database: rio User: intelifix Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,395 21m34s 150ms 5s764ms 928ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 11 08 95 51s374ms 540ms 09 156 1m45s 679ms 10 151 1m59s 793ms 11 114 1m35s 837ms 12 33 28s647ms 868ms 13 100 1m18s 787ms 14 251 4m19s 1s34ms 15 185 3m42s 1s203ms 16 226 3m59s 1s60ms 17 84 1m32s 1s102ms [ User: intelifix - Total duration: 21m34s - Times executed: 1395 ]
[ Application: [unknown] - Total duration: 21m34s - Times executed: 1395 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276679, 508, '922081098783,D833B7CA50A1,B0BBE54B5D5C,345D9EB43D19,ACD75BB5EA37,D0CF0EFDE8B2,943C96AB59FD,64FD965656B0,209A7DBB1A2C,5CFA259B8CE9,582FF7971C3E,E8D2FFA7289D,3453D2A7C01B,94988F95B111,ACD75BB80D6B,582FF78CE0E2,F081751CBC18,8CFDDE8DF3FC,44D454952050,5CFA25156292,CC5830E2146D,943C96ADB91A,44D454A3264B,8CFDDE8E03FB,CC5830E361A3,5447CC775E65,209A7DBB1C08,E4C0E23FF897,582FF78CF1DD,841EA38E0587,8CFDDE87AA98,64FD9656551A,48295246064F,94988F30E607,E4C0E2410E2F,582FF78CD7DC,841EA391B129,5447CC7815ED,E4C0E24018AA', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-11 13:47:44 Duration: 5s764ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276685, 450, 'ZTE3ANNR9315732,D89A0D83D0C3,D89A0D83D0C4,ZTEGDB14B173$ZTE3ANNR2Q18136,F4E84F825D10,F4E84F825D11,ZTEGD97AB992$ZTE3ANNR2Q36862,F4E84F8413F4,F4E84F8413F5,ZTEGD97B02B8$ZTE3ANNR6R14571,48D68236DA44,48D68236DA45,ZTEGDB0163BE$ZTE3ANNRC511703,6C11BA633C21,6C11BA633C22,ZTEGDC6E4376$ZTE3ANNQ3R06957,3CF9F0A322D4,3CF9F0A322D5,ZTEGD6401B2C$ZTE3ANNR9F49748,D89A0DA76BDB,D89A0DA76BDC,ZTEGDB15E99F$ZTE3ANNR3Y16586,4896D9514574,4896D9514575,ZTEGD97E717F$ZTE3ANNQ9329656,843C99354C4D,843C99354C4E,ZTEGD7BC2FCF$ZTE3ANNRB717952,5872C98FDDF1,5872C98FDDF2,ZTEGDC6170F3$ZTE3ANNRC525777,6C11BA6485FD,6C11BA6485FE,ZTEGDC6E7A70$ZTE3ANNRCP18552,6C11BA6ADD9F,6C11BA6ADDA0,ZTEGDC6F890B$ZTE3ANNR9319938,D89A0D843357,D89A0D843358,ZTEGDB14C1E1$ZTE3ANNRB708811,5872C98F07B3,5872C98F07B4,ZTEGDC614D3E$ZTE3ANNQ7915207,C4EBFF8D827A,C4EBFF8D827B,ZTEGD70ABBD5$ZTE3ANNQ9J03333,843C992C1F53,843C992C1F54,ZTEGD7BB15B0$ZTE3ANNQ9J19654,843C992D9DD9,843C992D9DDA,ZTEGD7BB5571$ZTE3ANNQ4N03631,3CF9F0A8E6C8,3CF9F0A8E6C9,ZTEGD641112A$ZTE3ANNQ9J26235,843C992E3817,843C992E3818,ZTEGD7BB6F26$ZTE3ANNR8C09816,3891484F6D17,3891484F6D18,ZTEGDB08A6C8$ZTE3ANNQ8128785,689E29BE8171,689E29BE8172,ZTEGD7B7AB01$ZTE3ANNRAM13946,5872C9887F15,5872C9887F16,ZTEGDC603679$ZTE3ANNR9F51887,D89A0DA79DFD,D89A0DA79DFE,ZTEGDB15F1FA$ZTE3ANNRCP17688,6C11BA6AC95F,6C11BA6AC960,ZTEGDC6F85AB$ZTE3ANNR4N01462,4896D9557D5C,4896D9557D5D,ZTEGD97F257B$ZTE3ANNR2Q26335,F4E84F831D3A,F4E84F831D3B,ZTEGD97AD999$ZTE3ANNQ5N17373,3CF9F0AE5CA4,3CF9F0AE5CA5,ZTEGD641FA24$ZTE3ANNRAD13688,D89A0DAF1B33,D89A0DAF1B34,ZTEGDB173183$ZTE3ANNR5W64233,48D682346540,48D682346541,ZTEGDB00FAE8$ZTE3ANNQ8128286,689E29BE75BF,689E29BE75C0,ZTEGD7B7A90E$ZTE3ANNQ8M03304,843C991F155B,843C991F155C,ZTEGD7BA5455$ZTE3ANNT2V82387,D831399319CA,D831399319CB,ZTEGDD313452$ZTE3ANNT2V74912,D83139926A98,D83139926A99,ZTEGDD31171F$ZTE3ANNR6R17751,48D6823724CC,48D6823724CD,ZTEGDB01702A$ZTE3ANNR1Y28431,14CA56CF44D5,14CA56CF44D6,ZTEGD970E56A$ZTE3ANNR9F51709,D89A0DA799D1,D89A0DA799D2,ZTEGDB15F148$ZTE3ANNR5W43019,48D68232740C,48D68232740D,ZTEGDB00A80A$ZTE3ANNR9F30065,D89A0DA59E89,D89A0DA59E8A,ZTEGDB159CBC$ZTE3ANNT4P10324,F00C514C9896,F00C514C9897,ZTEGDE341EEA$ZTE3ANNR2Q24632,F4E84F82F550,F4E84F82F551,ZTEGD97AD2F2', '',0318,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-11 15:42:28 Duration: 5s537ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276685, 450, 'ZTE3ANNT4P23284,F00C514DC856,F00C514DC857,ZTEGDE34518A$ZTE3ANNRAD16240,D89A0DAF5703,D89A0DAF5704,ZTEGDB173B7B$ZTE3ANNR2Q20197,F4E84F828D5E,F4E84F828D5F,ZTEGD97AC19F$ZTE3ANNRB707919,5872C98EF2CB,5872C98EF2CC,ZTEGDC6149C2$ZTE3ANNR9W55343,D89A0DAD6D3D,D89A0DAD6D3E,ZTEGDB16E9DA$ZTE3ANNR1Y25742,14CA56CF05CF,14CA56CF05D0,ZTEGD970DAE9$ZTE3ANNQ7914697,C4EBFF8D7686,C4EBFF8D7687,ZTEGD70AB9D7$ZTE3ANNRB722599,5872C9904ADB,5872C9904ADC,ZTEGDC61831A$ZTE3ANNQCA23280,14CA56D4667B,14CA56D4667C,ZTEGD971C05B$ZTE3ANNR6R17367,48D682371BCC,48D682371BCD,ZTEGDB016EAA$ZTE3ANNR8C19664,3891485053E7,3891485053E8,ZTEGDB08CD40$ZTE3ANNT2V31948,D831398E7BA0,D831398E7BA1,ZTEGDD306F4B$ZTE3ANNQ3R04450,3CF9F0A2E812,3CF9F0A2E813,ZTEGD6401161$ZTE3ANNQ8128329,689E29BE76C1,689E29BE76C2,ZTEGD7B7A939$ZTE3ANNQCA23349,14CA56D46819,14CA56D4681A,ZTEGD971C0A0$ZTE3ANNRCP17466,6C11BA6AC42B,6C11BA6AC42C,ZTEGDC6F84CD$ZTE3ANNR8C10942,3891484F877B,3891484F877C,ZTEGDB08AB2E$ZTE3ANNR9F14281,D89A0DA42C99,D89A0DA42C9A,ZTEGDB155F14$ZTE3ANNR6R44331,48D6823993C4,48D6823993C5,ZTEGDB01D7FE$ZTE3ANNR9318172,D89A0D8409F3,D89A0D8409F4,ZTEGDB14BAFB$ZTE3ANNR8C19245,389148504A15,389148504A16,ZTEGDB08CB9D$ZTE3ANNRB724925,5872C990815F,5872C9908160,ZTEGDC618C30$ZTE3ANNRB733111,5872C991413B,5872C991413C,ZTEGDC61AC2A$ZTE3ANNR5W33239,48D682318ED4,48D682318ED5,ZTEGDB0081D6$ZTE3ANNRCP45488,6C11BA6D54EF,6C11BA6D54F0,ZTEGDC6FF243$ZTE3ANNT4P26820,F00C514E1B36,F00C514E1B37,ZTEGDE345F5A$ZTE3ANNQ7111336,C4EBFF8AD218,C4EBFF8AD219,ZTEGD70A491A$ZTE3ANNRB708941,5872C98F0ABF,5872C98F0AC0,ZTEGDC614DC0$ZTE3ANNQ8M24008,843C9920FA9B,843C9920FA9C,ZTEGD7BAA535$ZTE3ANNRCB15669,D831391F3E3C,D831391F3E3D,ZTEGDD29F2CA$ZTE3ANNR9W55304,D89A0DAD6C53,D89A0DAD6C54,ZTEGDB16E9B3$ZTE3ANNQ9J29519,843C992E850F,843C992E8510,ZTEGD7BB7BFA$ZTE3ANNR8C53814,38914853744B,38914853744C,ZTEGDB0952A6$ZTE3ANNQ4A02454,3CF9F0AA31CA,3CF9F0AA31CB,ZTEGD6414855$ZTE3ANNT4P23964,F00C514DD846,F00C514DD847,ZTEGDE345432$ZTE3ANNT4P23285,F00C514DC85C,F00C514DC85D,ZTEGDE34518B$ZTE3ANNT4P27137,F00C514E22A4,F00C514E22A5,ZTEGDE346097$ZTE3ANNT2V69681,D8313991EFFE,D8313991EFFF,ZTEGDD3102B0$ZTE3ANNR9F10396,D89A0DA3D18B,D89A0DA3D18C,ZTEGDB154FE7', '',0318,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-11 15:49:20 Duration: 5s453ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 991 8m46s 150ms 2s668ms 531ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 11 07 20 6s686ms 334ms 08 111 56s945ms 513ms 09 147 1m22s 564ms 10 126 1m 480ms 11 118 57s959ms 491ms 12 15 10s463ms 697ms 13 123 1m10s 569ms 14 141 1m8s 488ms 15 133 1m15s 566ms 16 41 26s572ms 648ms 17 16 10s78ms 629ms [ User: intelifix - Total duration: 8m46s - Times executed: 991 ]
[ Application: [unknown] - Total duration: 8m46s - Times executed: 991 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "276721", "modelo" : "464", "itens" : "241738285959,241762764858,241776135366,241812920820,241747702143,241812914051,241813146475,241812715973,241815766888,241744335057,241765408809,241745702834,241746092345,241762641536,241759880526,241765516069,241759921214,241765525565,241765412951,241813963031,241764203450,241761152838,241747222747,241762552638,241812747693,241812712640,241740705264,241739548596,241763331839,241764397688,241778910924,241748151738,241767763741,241772397481,241813857891,241774160202,241745982637,241742109812,241770067882,241759696062,241770585464,241764596978,241777962032,241771108804,241771262332,241746492642,241760062642,241760007989,241762562033,241769016478,241762549506,241760033952,241779263236,241765238185,241769978806,241779147388,241759533342,241814588603,241740757390,241746423140", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-11 13:18:01 Duration: 2s668ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "276536", "modelo" : "464", "itens" : "241745642020,241759007173,241771010209,241775312929,241813144758,241771461622,241747345362,241778680823,241776640624,241764818189,241777711424,241778768181,241765549406,241775262139,241776822942,241744731112,241742809611,241746489308,241762766979,241747499798,241770069903,241746383843,241744754144,241744745860,241771206265,241759932528,241740770322,241769979311,241815843742,241746196978,241777698997,241742581329,241738562429,863400612818305,241762773950,241762852039,241760230919,241778862939,241738339702,241740724660,241744298992,241744752427,241778766363,241778740526,241812923648,863400615314106,241767702647,241778778586,241771323853,241813709112,241770067579,241738269516,241778916883,863400604106079,241776781726,241740796485,241815549617,241769986988,241777915764", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-11 09:20:33 Duration: 2s233ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "276339", "modelo" : "464", "itens" : "241759831834,241744036464,241744731516,241746395258,241762712429,241742765364,241767912847,241764731212,241778108588,241767485880,241759856078,241769214758,241746640311,241772613440,241775601925,241779271722,241742279907,241762475559,241778975879,241778628695,241743721934,241762541425,241779108495,241762346882,241763501833,241770673251,241762419213,241767911332,241762710409,241764412236,241813985558,241771282233,241745663941,241778620312,241747420926,241742834866,241770581828,241746634451,241746453244,241764152536,241758974062,241815767494,241765568195,241814301931,241775623240,241814373453,241814363755,241777490516,241738894661,241778888800,241761428094,241761404355,241759858503,241764576976,241776673556,241739922528,241742843958,241742773042,241774181820,241778764040", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-11 09:14:41 Duration: 2s67ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 275 14m4s 209ms 2m54s 3s69ms call rs_giga_triagem (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 11 00 12 34s209ms 2s850ms 01 12 24s508ms 2s42ms 02 12 24s682ms 2s56ms 03 12 32s669ms 2s722ms 04 12 26s11ms 2s167ms 05 12 30s638ms 2s553ms 06 12 25s330ms 2s110ms 07 12 28s485ms 2s373ms 08 12 26s495ms 2s207ms 09 11 26s417ms 2s401ms 10 12 29s927ms 2s493ms 11 12 25s220ms 2s101ms 12 12 27s350ms 2s279ms 13 12 28s124ms 2s343ms 14 12 36s499ms 3s41ms 15 12 3m23s 16s942ms 16 12 35s452ms 2s954ms 17 12 29s438ms 2s453ms 18 12 26s639ms 2s219ms 19 12 26s515ms 2s209ms 20 12 42s352ms 3s529ms 21 12 27s516ms 2s293ms 22 12 26s411ms 2s200ms [ User: intelifix - Total duration: 14m4s - Times executed: 275 ]
[ Application: psql - Total duration: 14m4s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-11 15:18:01 Duration: 2m54s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-11 20:05:15 Duration: 13s461ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-11 00:05:26 Duration: 11s129ms Database: rio User: intelifix Remote: [local] Application: psql
4 274 1h29m58s 151ms 6m22s 19s703ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 11 07 7 39s907ms 5s701ms 08 37 11m37s 18s839ms 09 17 10m28s 36s986ms 10 47 11m24s 14s563ms 11 26 11m42s 27s13ms 12 10 15m16s 1m31s 13 23 1m41s 4s394ms 14 36 7m49s 13s34ms 15 19 11m58s 37s837ms 16 37 6m30s 10s561ms 17 15 49s319ms 3s287ms [ User: intelifix - Total duration: 1h29m58s - Times executed: 274 ]
[ Application: [unknown] - Total duration: 1h29m58s - Times executed: 274 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028280, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-11 09:55:06 Duration: 6m22s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028313, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-11 14:30:06 Duration: 6m8s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028257, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-11 08:09:13 Duration: 5m42s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 166 7m58s 221ms 14s407ms 2s882ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 11 00 6 22s268ms 3s711ms 01 6 8s872ms 1s478ms 02 5 10s421ms 2s84ms 03 6 12s62ms 2s10ms 04 6 11s698ms 1s949ms 05 4 4s769ms 1s192ms 06 1 351ms 351ms 07 10 37s832ms 3s783ms 08 12 55s863ms 4s655ms 09 11 50s226ms 4s566ms 10 12 43s73ms 3s589ms 11 12 45s887ms 3s823ms 12 12 35s369ms 2s947ms 13 10 10s325ms 1s32ms 14 12 35s56ms 2s921ms 15 12 37s734ms 3s144ms 16 10 27s738ms 2s773ms 17 6 7s517ms 1s252ms 20 1 524ms 524ms 21 6 9s683ms 1s613ms 22 6 11s156ms 1s859ms [ User: intelifix - Total duration: 7m58s - Times executed: 166 ]
[ Application: psql - Total duration: 7m58s - Times executed: 166 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-11 00:05:15 Duration: 14s407ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-11 08:45:11 Duration: 10s440ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-11 08:05:11 Duration: 9s771ms Database: rio User: intelifix Remote: [local] Application: psql
6 128 27s69ms 150ms 409ms 211ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 11 01 23 4s867ms 211ms 03 3 551ms 183ms 04 9 2s205ms 245ms 05 10 2s447ms 244ms 07 10 2s148ms 214ms 08 11 2s290ms 208ms 09 10 2s132ms 213ms 10 11 2s145ms 195ms 11 10 2s19ms 201ms 12 6 1s59ms 176ms 13 1 168ms 168ms 14 10 2s140ms 214ms 15 12 2s507ms 208ms 16 2 385ms 192ms [ User: intelifix - Total duration: 27s69ms - Times executed: 128 ]
[ Application: [unknown] - Total duration: 27s69ms - Times executed: 128 ]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241759932730,241742832644,241759949296,241770230223,241774136383,241768648080,241738401527,241764679411,241743312444,241761495475,241746196978,241815843742,241775224963,241776125668,241738812027,241743843640,241766440313,241738274062', NULL, NULL, 0464, 00);
Date: 2026-08-11 05:05:03 Duration: 409ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '95', 2, '241606158193,241602988805,241607038290,241707365669,241614672235,241677202131,241663225772,241619538197,241675283537,241645973045,241652407690,241677193039,241614665264,241657657787,241699115874', NULL, NULL, 0320, 00);
Date: 2026-08-11 01:19:28 Duration: 348ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241778768181,241777711424,241764818189,241776640624,241778680823,241747345362,241771461622,241813144758,241775312929,241771010209,241759007173,241745642020,241774227278,241745331732,241743990120,241747427390,241768004449', NULL, NULL, 0464, 00);
Date: 2026-08-11 04:46:16 Duration: 315ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 125 3m2s 155ms 15s241ms 1s460ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 11 07 6 42s307ms 7s51ms 08 21 10s605ms 505ms 10 19 9s922ms 522ms 11 9 13s293ms 1s477ms 12 1 3s452ms 3s452ms 13 15 11s135ms 742ms 14 22 12s587ms 572ms 15 8 1m3s 7s993ms 16 24 15s271ms 636ms [ User: intelifix - Total duration: 3m2s - Times executed: 125 ]
[ Application: [unknown] - Total duration: 3m2s - Times executed: 125 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (051812) LIMIT 1;
Date: 2026-08-11 15:42:16 Duration: 15s241ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (051812) LIMIT 1;
Date: 2026-08-11 07:51:58 Duration: 13s544ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (051328) LIMIT 1;
Date: 2026-08-11 15:40:49 Duration: 12s249ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
8 106 46s691ms 268ms 784ms 440ms 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 #8
Day Hour Count Duration Avg duration Aug 11 00 1 444ms 444ms 01 2 715ms 357ms 03 1 564ms 564ms 04 1 487ms 487ms 05 3 1s410ms 470ms 06 1 381ms 381ms 07 5 2s53ms 410ms 08 10 4s461ms 446ms 09 8 3s781ms 472ms 10 10 4s811ms 481ms 11 8 4s67ms 508ms 12 7 2s810ms 401ms 13 9 3s477ms 386ms 14 11 4s344ms 394ms 15 11 4s781ms 434ms 16 6 3s16ms 502ms 17 8 3s387ms 423ms 18 1 386ms 386ms 21 2 825ms 412ms 22 1 480ms 480ms [ User: lenon - Total duration: 46s691ms - Times executed: 106 ]
[ Application: [unknown] - Total duration: 46s691ms - Times executed: 106 ]
-
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-11 11:55:15 Duration: 784ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-11 15:42:16 Duration: 700ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-11 09:05:03 Duration: 694ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
9 99 20m1s 9s620ms 37s824ms 12s139ms create table temp0000288012 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 11 08 15 3m15s 13s12ms 09 14 2m45s 11s806ms 10 17 3m22s 11s913ms 11 3 48s607ms 16s202ms 12 16 3m3s 11s450ms 14 14 2m53s 12s393ms 15 15 2m56s 11s765ms 16 5 56s938ms 11s387ms [ User: intelifix - Total duration: 20m1s - Times executed: 99 ]
[ Application: [unknown] - Total duration: 20m1s - Times executed: 99 ]
-
CREATE TABLE temp0000288012 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 08:01:21 Duration: 37s824ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288012 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 11:48:32 Duration: 24s234ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288012 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 10:12:51 Duration: 14s358ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 96 53s371ms 350ms 929ms 555ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 11 00 1 718ms 718ms 01 2 925ms 462ms 03 1 697ms 697ms 04 1 617ms 617ms 05 3 1s728ms 576ms 07 2 1s165ms 582ms 08 9 4s899ms 544ms 09 7 4s119ms 588ms 10 10 5s813ms 581ms 11 7 4s470ms 638ms 12 7 3s478ms 496ms 13 9 4s580ms 508ms 14 10 5s124ms 512ms 15 11 5s898ms 536ms 16 6 3s813ms 635ms 17 8 4s253ms 531ms 18 1 453ms 453ms 22 1 612ms 612ms [ User: intelifix - Total duration: 53s371ms - Times executed: 96 ]
[ Application: [unknown] - Total duration: 53s371ms - Times executed: 96 ]
-
select * from rs_menu_grants (406, 18, 1);
Date: 2026-08-11 11:55:15 Duration: 929ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (503, 18, 1);
Date: 2026-08-11 16:32:08 Duration: 844ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (417, 81, 1);
Date: 2026-08-11 10:58:27 Duration: 780ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 90 39s620ms 311ms 1s311ms 440ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 11 07 1 349ms 349ms 08 10 4s111ms 411ms 09 16 7s81ms 442ms 10 19 8s606ms 452ms 11 17 6s904ms 406ms 12 3 1s228ms 409ms 13 2 1s542ms 771ms 14 7 2s729ms 389ms 15 4 1s987ms 496ms 16 5 2s988ms 597ms 17 6 2s90ms 348ms [ User: intelifix - Total duration: 39s620ms - Times executed: 90 ]
[ Application: [unknown] - Total duration: 39s620ms - Times executed: 90 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 085;
Date: 2026-08-11 16:42:18 Duration: 1s311ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-11 13:53:36 Duration: 1s197ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-08-11 10:11:29 Duration: 697ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 85 18s453ms 151ms 746ms 217ms create table temp0000237928 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 11 13 11 2s721ms 247ms 14 14 3s99ms 221ms 15 9 1s734ms 192ms 16 15 3s157ms 210ms 17 36 7s740ms 215ms [ User: intelifix - Total duration: 18s453ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 18s453ms - Times executed: 85 ]
-
CREATE TABLE temp0000237928 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"06-08-2026", "ate" :"11-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-11 13:41:38 Duration: 746ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000237928 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"06-08-2026", "ate" :"11-08-2026", "nota-fiscal":"6952", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-11 14:50:17 Duration: 320ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000237928 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"06-08-2026", "ate" :"11-08-2026", "nota-fiscal":"454", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-11 17:32:50 Duration: 252ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
13 75 5m2s 163ms 1m27s 4s30ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 11 08 11 2m35s 14s115ms 09 18 8s885ms 493ms 10 11 1m57s 10s686ms 11 3 2s535ms 845ms 12 6 3s771ms 628ms 13 2 3s712ms 1s856ms 14 17 6s398ms 376ms 15 5 2s645ms 529ms 16 2 1s500ms 750ms [ User: intelifix - Total duration: 5m2s - Times executed: 75 ]
[ Application: psql - Total duration: 5m2s - Times executed: 75 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028263);
Date: 2026-08-11 08:47:42 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028294);
Date: 2026-08-11 10:58:33 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028262);
Date: 2026-08-11 08:42:55 Duration: 43s274ms Database: rio User: intelifix Remote: [local] Application: psql
14 74 7m16s 1s288ms 24s476ms 5s896ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 11 07 3 9s841ms 3s280ms 08 2 27s740ms 13s870ms 09 2 7s775ms 3s887ms 10 1 5s387ms 5s387ms 11 6 57s392ms 9s565ms 12 3 24s626ms 8s208ms 13 3 35s98ms 11s699ms 14 13 1m17s 5s951ms 15 11 36s198ms 3s290ms 16 13 1m37s 7s536ms 17 16 51s348ms 3s209ms 18 1 5s615ms 5s615ms [ User: intelifix - Total duration: 7m16s - Times executed: 74 ]
[ Application: [unknown] - Total duration: 7m16s - Times executed: 74 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-11', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-11 08:45:07 Duration: 24s476ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-11', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-11 16:00:22 Duration: 22s940ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-11', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-11 13:17:26 Duration: 19s226ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 74 17s239ms 150ms 2s426ms 232ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 11 01 1 244ms 244ms 04 1 323ms 323ms 07 2 305ms 152ms 09 2 325ms 162ms 10 1 2s426ms 2s426ms 11 5 1s62ms 212ms 12 3 707ms 235ms 13 4 700ms 175ms 14 17 3s507ms 206ms 15 23 4s634ms 201ms 16 12 2s485ms 207ms 17 3 516ms 172ms [ User: intelifix - Total duration: 17s239ms - Times executed: 74 ]
[ Application: [unknown] - Total duration: 17s239ms - Times executed: 74 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-08-11", "data-ate" : "2026-08-11", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 507 }');
Date: 2026-08-11 10:54:38 Duration: 2s426ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "382", "data-de" : "2026-08-11", "data-ate" : "2026-08-11", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 433 }');
Date: 2026-08-11 15:37:48 Duration: 637ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "332", "data-de" : "2026-08-11", "data-ate" : "2026-08-11", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 401 }');
Date: 2026-08-11 11:52:17 Duration: 406ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
16 59 25s18ms 151ms 1s512ms 424ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 11 08 2 396ms 198ms 09 2 2s182ms 1s91ms 10 14 5s837ms 416ms 11 6 2s219ms 369ms 13 4 3s748ms 937ms 14 13 4s885ms 375ms 15 10 2s969ms 296ms 16 7 2s628ms 375ms 17 1 151ms 151ms [ User: intelifix - Total duration: 25s18ms - Times executed: 59 ]
[ Application: [unknown] - Total duration: 25s18ms - Times executed: 59 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '230014768791,230010201220,230012395979,230037542530,230050003443,230053538805,229988847788,230032395877,229988362837,230051046384,230046985359,229989994556,230051356268,230006349912,229977288590,230045096768,229973729512,229977623248,230014476788,229990556182,230037460020,230014342735,229990242033,230006874363,230042228497,230014199915,230019430213,230042312648,229971615568,230014240122,229975240917,229990311333,230014546974,230037928909,229991354756,229986397897,230030083957,230028699916,229989017277,230053387678,229990133032,229986797689,229985847585,229976852230,229971231839,230026857996,230041234652,229985266788,229990279915,229967854550,229964969106,229982572227,229981478090,230024735971,230027397173,229987019103,230014433451', '','DEFAULT',056,0295,'', '','', 00);
Date: 2026-08-11 09:43:10 Duration: 1s512ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '230048878596,241657917083,241656440711,241726823438,241679870910,241622295672,241630343450,241706977797,241645613032,241674249205,241673267077,241691114162,241696906567,241645943143,241650338599,230043525661,241655508284,241617372128,241675374152,241659690108,241709343539,241679561127,241713315868,241668156567,241703953451,241659693340,241675283638,241649607484,241610161840,230040122636,241622600910,241688858183,241608111011,241649641327,241710284955,241694839597,241706545454,241672755456,241615194160,241630916266,241704237092,241629143849,241698530812,241631802728', '','DEFAULT',056,0320,'', '','', 00);
Date: 2026-08-11 13:45:55 Duration: 1s393ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '241631778102,241701933254,241691740621,241599297389,241660761638,241710272227,241709233450,241639043345,241649381829,241732996969,241592630926,241680662738,241671969712,241649680220,241597547678,241677828386,241658588596,241713322536,241628096081,241654921730,241660264967,241669973333,241617499009,241695209208,241730294854,230049417897,241673167595,241616731426,241672728305,241703687891,241636132444,241637559900,241700239609,241694679605,241706629200,241657195767,241608914658,230048410011,241731227986,241674216474,241699371534,241714927282,241592196180,241635938989,241646357885,241604810925,241654928295,241598571225,241635763238', '','DEFAULT',056,0320,'', '','', 00);
Date: 2026-08-11 13:55:00 Duration: 1s204ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 55 3m14s 2s942ms 5s478ms 3s534ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 11 08 5 19s422ms 3s884ms 09 4 14s231ms 3s557ms 10 5 17s577ms 3s515ms 11 5 18s791ms 3s758ms 12 4 14s90ms 3s522ms 13 3 9s840ms 3s280ms 14 3 10s248ms 3s416ms 15 3 9s636ms 3s212ms 16 3 10s11ms 3s337ms 17 3 10s688ms 3s562ms 18 3 9s492ms 3s164ms 19 3 11s57ms 3s685ms 20 4 15s247ms 3s811ms 21 4 13s562ms 3s390ms 22 3 10s506ms 3s502ms [ User: intelifix - Total duration: 3m14s - Times executed: 55 ]
[ Application: psql - Total duration: 3m14s - Times executed: 55 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-11 11:20:10 Duration: 5s478ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-11 08:00:06 Duration: 5s153ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-11 20:00:10 Duration: 4s851ms Database: brasilia User: intelifix Remote: [local] Application: psql
18 54 12s737ms 150ms 1s82ms 235ms select * from rs_lote_saida_manutencao (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 11 07 1 448ms 448ms 08 1 196ms 196ms 09 14 2s839ms 202ms 10 6 1s404ms 234ms 11 5 1s22ms 204ms 13 7 1s879ms 268ms 14 4 742ms 185ms 15 5 1s937ms 387ms 16 3 530ms 176ms 17 8 1s737ms 217ms [ User: intelifix - Total duration: 12s737ms - Times executed: 54 ]
[ Application: [unknown] - Total duration: 12s737ms - Times executed: 54 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "132590", "oficina" : "7", "cliente" : "11", "usuario" : "427", "nf" : "", "data-saida" : "2026-08-11", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "COSMÉTICO CHOCALHO", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-11 15:58:29 Duration: 1s82ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "276601", "oficina" : "6", "cliente" : "5", "usuario" : "418", "nf" : "", "data-saida" : "2026-08-11", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "S", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-11 13:14:29 Duration: 549ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "276151", "oficina" : "6", "cliente" : "5", "usuario" : "418", "nf" : "", "data-saida" : "2026-08-11", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-11 07:59:02 Duration: 448ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 53 2m48s 2s103ms 4s533ms 3s182ms create table temp0000288012 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 11 08 14 35s510ms 2s536ms 09 9 25s700ms 2s855ms 10 4 13s410ms 3s352ms 12 3 8s755ms 2s918ms 14 4 13s826ms 3s456ms 15 9 34s520ms 3s835ms 16 10 36s930ms 3s693ms [ User: intelifix - Total duration: 2m48s - Times executed: 53 ]
[ Application: [unknown] - Total duration: 2m48s - Times executed: 53 ]
-
CREATE TABLE temp0000288012 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"06-08-2026", "ate" :"11-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-11 15:24:33 Duration: 4s533ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288012 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-08-2026", "ate" :"11-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-11 15:24:20 Duration: 4s418ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288012 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-08-2026", "ate" :"11-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-11 10:20:52 Duration: 4s258ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 48 2h12m26s 1s557ms 9m34s 2m45s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 11 07 3 9m52s 3m17s 08 3 6m33s 2m11s 09 3 10m17s 3m25s 10 3 8m54s 2m58s 11 3 9m24s 3m8s 12 3 9m6s 3m2s 13 3 7m4s 2m21s 14 3 9m42s 3m14s 15 3 9m44s 3m14s 16 3 9m43s 3m14s 17 3 8m23s 2m47s 18 3 6m12s 2m4s 19 3 6m12s 2m4s 20 3 8m49s 2m56s 21 3 6m19s 2m6s 22 3 6m4s 2m1s [ User: intelifix - Total duration: 2h12m26s - Times executed: 48 ]
[ Application: psql - Total duration: 2h12m26s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-11 09:14:35 Duration: 9m34s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-11 07:14:12 Duration: 9m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-11 15:14:05 Duration: 9m3s Database: rio User: intelifix Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m35s 9m8s 5m29s 3 16m28s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 11 05 3 16m28s 5m29s [ User: intelifix - Total duration: 16m28s - Times executed: 3 ]
[ Application: psql - Total duration: 16m28s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-11 05:09:09 Duration: 9m8s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-11 05:13:55 Duration: 4m45s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-11 05:16:30 Duration: 2m35s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s557ms 9m34s 2m45s 48 2h12m26s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 11 07 3 9m52s 3m17s 08 3 6m33s 2m11s 09 3 10m17s 3m25s 10 3 8m54s 2m58s 11 3 9m24s 3m8s 12 3 9m6s 3m2s 13 3 7m4s 2m21s 14 3 9m42s 3m14s 15 3 9m44s 3m14s 16 3 9m43s 3m14s 17 3 8m23s 2m47s 18 3 6m12s 2m4s 19 3 6m12s 2m4s 20 3 8m49s 2m56s 21 3 6m19s 2m6s 22 3 6m4s 2m1s [ User: intelifix - Total duration: 2h12m26s - Times executed: 48 ]
[ Application: psql - Total duration: 2h12m26s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-11 09:14:35 Duration: 9m34s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-11 07:14:12 Duration: 9m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-11 15:14:05 Duration: 9m3s Database: rio User: intelifix Remote: [local] Application: psql
3 206ms 4m26s 1m32s 48 1h13m58s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 11 07 3 4m57s 1m39s 08 3 4m1s 1m20s 09 3 5m37s 1m52s 10 3 5m6s 1m42s 11 3 5m4s 1m41s 12 3 5m25s 1m48s 13 3 4m1s 1m20s 14 3 5m23s 1m47s 15 3 5m30s 1m50s 16 3 5m32s 1m50s 17 3 4m12s 1m24s 18 3 3m39s 1m13s 19 3 3m39s 1m13s 20 3 4m27s 1m29s 21 3 3m35s 1m11s 22 3 3m42s 1m14s [ User: intelifix - Total duration: 1h13m58s - Times executed: 48 ]
[ Application: psql - Total duration: 1h13m58s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-11 09:20:48 Duration: 4m26s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-11 15:20:09 Duration: 4m23s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-11 16:20:10 Duration: 4m19s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s343ms 1m21s 42s94ms 4 2m48s 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 11 20 2 1m22s 41s474ms 23 2 1m25s 42s715ms [ User: intelifix - Total duration: 2m48s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m48s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-11 23:16:26 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-11 20:08:19 Duration: 1m18s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-11 20:10:00 Duration: 4s364ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 151ms 6m22s 19s703ms 274 1h29m58s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 11 07 7 39s907ms 5s701ms 08 37 11m37s 18s839ms 09 17 10m28s 36s986ms 10 47 11m24s 14s563ms 11 26 11m42s 27s13ms 12 10 15m16s 1m31s 13 23 1m41s 4s394ms 14 36 7m49s 13s34ms 15 19 11m58s 37s837ms 16 37 6m30s 10s561ms 17 15 49s319ms 3s287ms [ User: intelifix - Total duration: 1h29m58s - Times executed: 274 ]
[ Application: [unknown] - Total duration: 1h29m58s - Times executed: 274 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028280, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-11 09:55:06 Duration: 6m22s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028313, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-11 14:30:06 Duration: 6m8s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028257, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-11 08:09:13 Duration: 5m42s Database: rio User: intelifix Remote: [local] Application: [unknown]
6 10s356ms 40s145ms 12s859ms 24 5m8s create table temp0000288032 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 11 08 10 1m54s 11s462ms 09 2 22s934ms 11s467ms 10 6 1m8s 11s335ms 11 1 11s555ms 11s555ms 12 1 12s990ms 12s990ms 13 3 1m4s 21s658ms 14 1 13s530ms 13s530ms [ User: intelifix - Total duration: 5m8s - Times executed: 24 ]
[ Application: [unknown] - Total duration: 5m8s - Times executed: 24 ]
-
CREATE TABLE temp0000288032 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 13:48:25 Duration: 40s145ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288032 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 14:01:05 Duration: 13s530ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288032 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 12:25:16 Duration: 12s990ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 10s571ms 14s252ms 12s261ms 21 4m17s create table temp0000288072 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 11 14 21 4m17s 12s261ms [ User: intelifix - Total duration: 4m17s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 4m17s - Times executed: 21 ]
-
CREATE TABLE temp0000288072 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 14:18:49 Duration: 14s252ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288072 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 14:41:12 Duration: 13s542ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288072 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 14:47:53 Duration: 13s476ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 9s620ms 37s824ms 12s139ms 99 20m1s create table temp0000288012 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 11 08 15 3m15s 13s12ms 09 14 2m45s 11s806ms 10 17 3m22s 11s913ms 11 3 48s607ms 16s202ms 12 16 3m3s 11s450ms 14 14 2m53s 12s393ms 15 15 2m56s 11s765ms 16 5 56s938ms 11s387ms [ User: intelifix - Total duration: 20m1s - Times executed: 99 ]
[ Application: [unknown] - Total duration: 20m1s - Times executed: 99 ]
-
CREATE TABLE temp0000288012 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 08:01:21 Duration: 37s824ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288012 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 11:48:32 Duration: 24s234ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288012 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 10:12:51 Duration: 14s358ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s14ms 13s189ms 11s318ms 18 3m23s create table temp0000288026 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 11 09 18 3m23s 11s318ms [ User: intelifix - Total duration: 3m23s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 3m23s - Times executed: 18 ]
-
CREATE TABLE temp0000288026 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 09:46:04 Duration: 13s189ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288026 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 09:07:36 Duration: 13s74ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288026 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-11 09:46:26 Duration: 12s172ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 1s288ms 24s476ms 5s896ms 74 7m16s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 11 07 3 9s841ms 3s280ms 08 2 27s740ms 13s870ms 09 2 7s775ms 3s887ms 10 1 5s387ms 5s387ms 11 6 57s392ms 9s565ms 12 3 24s626ms 8s208ms 13 3 35s98ms 11s699ms 14 13 1m17s 5s951ms 15 11 36s198ms 3s290ms 16 13 1m37s 7s536ms 17 16 51s348ms 3s209ms 18 1 5s615ms 5s615ms [ User: intelifix - Total duration: 7m16s - Times executed: 74 ]
[ Application: [unknown] - Total duration: 7m16s - Times executed: 74 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-11', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-11 08:45:07 Duration: 24s476ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-11', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-11 16:00:22 Duration: 22s940ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-11', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-11 13:17:26 Duration: 19s226ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 163ms 1m27s 4s30ms 75 5m2s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 11 08 11 2m35s 14s115ms 09 18 8s885ms 493ms 10 11 1m57s 10s686ms 11 3 2s535ms 845ms 12 6 3s771ms 628ms 13 2 3s712ms 1s856ms 14 17 6s398ms 376ms 15 5 2s645ms 529ms 16 2 1s500ms 750ms [ User: intelifix - Total duration: 5m2s - Times executed: 75 ]
[ Application: psql - Total duration: 5m2s - Times executed: 75 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028263);
Date: 2026-08-11 08:47:42 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028294);
Date: 2026-08-11 10:58:33 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028262);
Date: 2026-08-11 08:42:55 Duration: 43s274ms Database: rio User: intelifix Remote: [local] Application: psql
12 2s909ms 18s909ms 3s794ms 35 2m12s 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 #12
Day Hour Count Duration Avg duration Aug 11 08 1 3s801ms 3s801ms 09 2 6s343ms 3s171ms 10 1 3s421ms 3s421ms 11 1 3s639ms 3s639ms 12 2 6s641ms 3s320ms 13 3 9s640ms 3s213ms 14 3 9s881ms 3s293ms 15 3 9s928ms 3s309ms 16 3 9s814ms 3s271ms 17 3 9s568ms 3s189ms 18 3 9s719ms 3s239ms 19 3 11s9ms 3s669ms 20 2 6s837ms 3s418ms 21 2 22s605ms 11s302ms 22 3 9s952ms 3s317ms [ User: intelifix - Total duration: 2m12s - Times executed: 35 ]
[ Application: psql - Total duration: 2m12s - Times executed: 35 ]
-
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-11 21:20:20 Duration: 18s909ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-11 19:20:05 Duration: 3s949ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-11 08:20:05 Duration: 3s801ms Database: rio User: intelifix Remote: [local] Application: psql
13 2s942ms 5s478ms 3s534ms 55 3m14s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 11 08 5 19s422ms 3s884ms 09 4 14s231ms 3s557ms 10 5 17s577ms 3s515ms 11 5 18s791ms 3s758ms 12 4 14s90ms 3s522ms 13 3 9s840ms 3s280ms 14 3 10s248ms 3s416ms 15 3 9s636ms 3s212ms 16 3 10s11ms 3s337ms 17 3 10s688ms 3s562ms 18 3 9s492ms 3s164ms 19 3 11s57ms 3s685ms 20 4 15s247ms 3s811ms 21 4 13s562ms 3s390ms 22 3 10s506ms 3s502ms [ User: intelifix - Total duration: 3m14s - Times executed: 55 ]
[ Application: psql - Total duration: 3m14s - Times executed: 55 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-11 11:20:10 Duration: 5s478ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-11 08:00:06 Duration: 5s153ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-11 20:00:10 Duration: 4s851ms Database: brasilia User: intelifix Remote: [local] Application: psql
14 2s103ms 4s533ms 3s182ms 53 2m48s create table temp0000288012 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 11 08 14 35s510ms 2s536ms 09 9 25s700ms 2s855ms 10 4 13s410ms 3s352ms 12 3 8s755ms 2s918ms 14 4 13s826ms 3s456ms 15 9 34s520ms 3s835ms 16 10 36s930ms 3s693ms [ User: intelifix - Total duration: 2m48s - Times executed: 53 ]
[ Application: [unknown] - Total duration: 2m48s - Times executed: 53 ]
-
CREATE TABLE temp0000288012 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"06-08-2026", "ate" :"11-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-11 15:24:33 Duration: 4s533ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288012 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-08-2026", "ate" :"11-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-11 15:24:20 Duration: 4s418ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288012 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-08-2026", "ate" :"11-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-11 10:20:52 Duration: 4s258ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 153ms 15s403ms 3s109ms 41 2m7s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 11 08 7 33s373ms 4s767ms 09 5 18s908ms 3s781ms 10 8 17s400ms 2s175ms 11 1 9s445ms 9s445ms 12 4 7s538ms 1s884ms 13 1 463ms 463ms 14 10 25s326ms 2s532ms 15 4 9s138ms 2s284ms 16 1 5s911ms 5s911ms [ User: intelifix - Total duration: 2m7s - Times executed: 41 ]
[ Application: psql - Total duration: 2m7s - Times executed: 41 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028257);
Date: 2026-08-11 08:03:13 Duration: 15s403ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028275);
Date: 2026-08-11 09:17:55 Duration: 13s900ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028298);
Date: 2026-08-11 11:48:50 Duration: 9s445ms Database: rio User: intelifix Remote: [local] Application: psql
16 209ms 2m54s 3s69ms 275 14m4s call rs_giga_triagem (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 11 00 12 34s209ms 2s850ms 01 12 24s508ms 2s42ms 02 12 24s682ms 2s56ms 03 12 32s669ms 2s722ms 04 12 26s11ms 2s167ms 05 12 30s638ms 2s553ms 06 12 25s330ms 2s110ms 07 12 28s485ms 2s373ms 08 12 26s495ms 2s207ms 09 11 26s417ms 2s401ms 10 12 29s927ms 2s493ms 11 12 25s220ms 2s101ms 12 12 27s350ms 2s279ms 13 12 28s124ms 2s343ms 14 12 36s499ms 3s41ms 15 12 3m23s 16s942ms 16 12 35s452ms 2s954ms 17 12 29s438ms 2s453ms 18 12 26s639ms 2s219ms 19 12 26s515ms 2s209ms 20 12 42s352ms 3s529ms 21 12 27s516ms 2s293ms 22 12 26s411ms 2s200ms [ User: intelifix - Total duration: 14m4s - Times executed: 275 ]
[ Application: psql - Total duration: 14m4s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-11 15:18:01 Duration: 2m54s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-11 20:05:15 Duration: 13s461ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-11 00:05:26 Duration: 11s129ms Database: rio User: intelifix Remote: [local] Application: psql
17 221ms 14s407ms 2s882ms 166 7m58s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 11 00 6 22s268ms 3s711ms 01 6 8s872ms 1s478ms 02 5 10s421ms 2s84ms 03 6 12s62ms 2s10ms 04 6 11s698ms 1s949ms 05 4 4s769ms 1s192ms 06 1 351ms 351ms 07 10 37s832ms 3s783ms 08 12 55s863ms 4s655ms 09 11 50s226ms 4s566ms 10 12 43s73ms 3s589ms 11 12 45s887ms 3s823ms 12 12 35s369ms 2s947ms 13 10 10s325ms 1s32ms 14 12 35s56ms 2s921ms 15 12 37s734ms 3s144ms 16 10 27s738ms 2s773ms 17 6 7s517ms 1s252ms 20 1 524ms 524ms 21 6 9s683ms 1s613ms 22 6 11s156ms 1s859ms [ User: intelifix - Total duration: 7m58s - Times executed: 166 ]
[ Application: psql - Total duration: 7m58s - Times executed: 166 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-11 00:05:15 Duration: 14s407ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-11 08:45:11 Duration: 10s440ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-11 08:05:11 Duration: 9s771ms Database: rio User: intelifix Remote: [local] Application: psql
18 155ms 15s241ms 1s460ms 125 3m2s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 11 07 6 42s307ms 7s51ms 08 21 10s605ms 505ms 10 19 9s922ms 522ms 11 9 13s293ms 1s477ms 12 1 3s452ms 3s452ms 13 15 11s135ms 742ms 14 22 12s587ms 572ms 15 8 1m3s 7s993ms 16 24 15s271ms 636ms [ User: intelifix - Total duration: 3m2s - Times executed: 125 ]
[ Application: [unknown] - Total duration: 3m2s - Times executed: 125 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (051812) LIMIT 1;
Date: 2026-08-11 15:42:16 Duration: 15s241ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (051812) LIMIT 1;
Date: 2026-08-11 07:51:58 Duration: 13s544ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (051328) LIMIT 1;
Date: 2026-08-11 15:40:49 Duration: 12s249ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 150ms 5s764ms 928ms 1,395 21m34s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 11 08 95 51s374ms 540ms 09 156 1m45s 679ms 10 151 1m59s 793ms 11 114 1m35s 837ms 12 33 28s647ms 868ms 13 100 1m18s 787ms 14 251 4m19s 1s34ms 15 185 3m42s 1s203ms 16 226 3m59s 1s60ms 17 84 1m32s 1s102ms [ User: intelifix - Total duration: 21m34s - Times executed: 1395 ]
[ Application: [unknown] - Total duration: 21m34s - Times executed: 1395 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276679, 508, '922081098783,D833B7CA50A1,B0BBE54B5D5C,345D9EB43D19,ACD75BB5EA37,D0CF0EFDE8B2,943C96AB59FD,64FD965656B0,209A7DBB1A2C,5CFA259B8CE9,582FF7971C3E,E8D2FFA7289D,3453D2A7C01B,94988F95B111,ACD75BB80D6B,582FF78CE0E2,F081751CBC18,8CFDDE8DF3FC,44D454952050,5CFA25156292,CC5830E2146D,943C96ADB91A,44D454A3264B,8CFDDE8E03FB,CC5830E361A3,5447CC775E65,209A7DBB1C08,E4C0E23FF897,582FF78CF1DD,841EA38E0587,8CFDDE87AA98,64FD9656551A,48295246064F,94988F30E607,E4C0E2410E2F,582FF78CD7DC,841EA391B129,5447CC7815ED,E4C0E24018AA', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-11 13:47:44 Duration: 5s764ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276685, 450, 'ZTE3ANNR9315732,D89A0D83D0C3,D89A0D83D0C4,ZTEGDB14B173$ZTE3ANNR2Q18136,F4E84F825D10,F4E84F825D11,ZTEGD97AB992$ZTE3ANNR2Q36862,F4E84F8413F4,F4E84F8413F5,ZTEGD97B02B8$ZTE3ANNR6R14571,48D68236DA44,48D68236DA45,ZTEGDB0163BE$ZTE3ANNRC511703,6C11BA633C21,6C11BA633C22,ZTEGDC6E4376$ZTE3ANNQ3R06957,3CF9F0A322D4,3CF9F0A322D5,ZTEGD6401B2C$ZTE3ANNR9F49748,D89A0DA76BDB,D89A0DA76BDC,ZTEGDB15E99F$ZTE3ANNR3Y16586,4896D9514574,4896D9514575,ZTEGD97E717F$ZTE3ANNQ9329656,843C99354C4D,843C99354C4E,ZTEGD7BC2FCF$ZTE3ANNRB717952,5872C98FDDF1,5872C98FDDF2,ZTEGDC6170F3$ZTE3ANNRC525777,6C11BA6485FD,6C11BA6485FE,ZTEGDC6E7A70$ZTE3ANNRCP18552,6C11BA6ADD9F,6C11BA6ADDA0,ZTEGDC6F890B$ZTE3ANNR9319938,D89A0D843357,D89A0D843358,ZTEGDB14C1E1$ZTE3ANNRB708811,5872C98F07B3,5872C98F07B4,ZTEGDC614D3E$ZTE3ANNQ7915207,C4EBFF8D827A,C4EBFF8D827B,ZTEGD70ABBD5$ZTE3ANNQ9J03333,843C992C1F53,843C992C1F54,ZTEGD7BB15B0$ZTE3ANNQ9J19654,843C992D9DD9,843C992D9DDA,ZTEGD7BB5571$ZTE3ANNQ4N03631,3CF9F0A8E6C8,3CF9F0A8E6C9,ZTEGD641112A$ZTE3ANNQ9J26235,843C992E3817,843C992E3818,ZTEGD7BB6F26$ZTE3ANNR8C09816,3891484F6D17,3891484F6D18,ZTEGDB08A6C8$ZTE3ANNQ8128785,689E29BE8171,689E29BE8172,ZTEGD7B7AB01$ZTE3ANNRAM13946,5872C9887F15,5872C9887F16,ZTEGDC603679$ZTE3ANNR9F51887,D89A0DA79DFD,D89A0DA79DFE,ZTEGDB15F1FA$ZTE3ANNRCP17688,6C11BA6AC95F,6C11BA6AC960,ZTEGDC6F85AB$ZTE3ANNR4N01462,4896D9557D5C,4896D9557D5D,ZTEGD97F257B$ZTE3ANNR2Q26335,F4E84F831D3A,F4E84F831D3B,ZTEGD97AD999$ZTE3ANNQ5N17373,3CF9F0AE5CA4,3CF9F0AE5CA5,ZTEGD641FA24$ZTE3ANNRAD13688,D89A0DAF1B33,D89A0DAF1B34,ZTEGDB173183$ZTE3ANNR5W64233,48D682346540,48D682346541,ZTEGDB00FAE8$ZTE3ANNQ8128286,689E29BE75BF,689E29BE75C0,ZTEGD7B7A90E$ZTE3ANNQ8M03304,843C991F155B,843C991F155C,ZTEGD7BA5455$ZTE3ANNT2V82387,D831399319CA,D831399319CB,ZTEGDD313452$ZTE3ANNT2V74912,D83139926A98,D83139926A99,ZTEGDD31171F$ZTE3ANNR6R17751,48D6823724CC,48D6823724CD,ZTEGDB01702A$ZTE3ANNR1Y28431,14CA56CF44D5,14CA56CF44D6,ZTEGD970E56A$ZTE3ANNR9F51709,D89A0DA799D1,D89A0DA799D2,ZTEGDB15F148$ZTE3ANNR5W43019,48D68232740C,48D68232740D,ZTEGDB00A80A$ZTE3ANNR9F30065,D89A0DA59E89,D89A0DA59E8A,ZTEGDB159CBC$ZTE3ANNT4P10324,F00C514C9896,F00C514C9897,ZTEGDE341EEA$ZTE3ANNR2Q24632,F4E84F82F550,F4E84F82F551,ZTEGD97AD2F2', '',0318,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-11 15:42:28 Duration: 5s537ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276685, 450, 'ZTE3ANNT4P23284,F00C514DC856,F00C514DC857,ZTEGDE34518A$ZTE3ANNRAD16240,D89A0DAF5703,D89A0DAF5704,ZTEGDB173B7B$ZTE3ANNR2Q20197,F4E84F828D5E,F4E84F828D5F,ZTEGD97AC19F$ZTE3ANNRB707919,5872C98EF2CB,5872C98EF2CC,ZTEGDC6149C2$ZTE3ANNR9W55343,D89A0DAD6D3D,D89A0DAD6D3E,ZTEGDB16E9DA$ZTE3ANNR1Y25742,14CA56CF05CF,14CA56CF05D0,ZTEGD970DAE9$ZTE3ANNQ7914697,C4EBFF8D7686,C4EBFF8D7687,ZTEGD70AB9D7$ZTE3ANNRB722599,5872C9904ADB,5872C9904ADC,ZTEGDC61831A$ZTE3ANNQCA23280,14CA56D4667B,14CA56D4667C,ZTEGD971C05B$ZTE3ANNR6R17367,48D682371BCC,48D682371BCD,ZTEGDB016EAA$ZTE3ANNR8C19664,3891485053E7,3891485053E8,ZTEGDB08CD40$ZTE3ANNT2V31948,D831398E7BA0,D831398E7BA1,ZTEGDD306F4B$ZTE3ANNQ3R04450,3CF9F0A2E812,3CF9F0A2E813,ZTEGD6401161$ZTE3ANNQ8128329,689E29BE76C1,689E29BE76C2,ZTEGD7B7A939$ZTE3ANNQCA23349,14CA56D46819,14CA56D4681A,ZTEGD971C0A0$ZTE3ANNRCP17466,6C11BA6AC42B,6C11BA6AC42C,ZTEGDC6F84CD$ZTE3ANNR8C10942,3891484F877B,3891484F877C,ZTEGDB08AB2E$ZTE3ANNR9F14281,D89A0DA42C99,D89A0DA42C9A,ZTEGDB155F14$ZTE3ANNR6R44331,48D6823993C4,48D6823993C5,ZTEGDB01D7FE$ZTE3ANNR9318172,D89A0D8409F3,D89A0D8409F4,ZTEGDB14BAFB$ZTE3ANNR8C19245,389148504A15,389148504A16,ZTEGDB08CB9D$ZTE3ANNRB724925,5872C990815F,5872C9908160,ZTEGDC618C30$ZTE3ANNRB733111,5872C991413B,5872C991413C,ZTEGDC61AC2A$ZTE3ANNR5W33239,48D682318ED4,48D682318ED5,ZTEGDB0081D6$ZTE3ANNRCP45488,6C11BA6D54EF,6C11BA6D54F0,ZTEGDC6FF243$ZTE3ANNT4P26820,F00C514E1B36,F00C514E1B37,ZTEGDE345F5A$ZTE3ANNQ7111336,C4EBFF8AD218,C4EBFF8AD219,ZTEGD70A491A$ZTE3ANNRB708941,5872C98F0ABF,5872C98F0AC0,ZTEGDC614DC0$ZTE3ANNQ8M24008,843C9920FA9B,843C9920FA9C,ZTEGD7BAA535$ZTE3ANNRCB15669,D831391F3E3C,D831391F3E3D,ZTEGDD29F2CA$ZTE3ANNR9W55304,D89A0DAD6C53,D89A0DAD6C54,ZTEGDB16E9B3$ZTE3ANNQ9J29519,843C992E850F,843C992E8510,ZTEGD7BB7BFA$ZTE3ANNR8C53814,38914853744B,38914853744C,ZTEGDB0952A6$ZTE3ANNQ4A02454,3CF9F0AA31CA,3CF9F0AA31CB,ZTEGD6414855$ZTE3ANNT4P23964,F00C514DD846,F00C514DD847,ZTEGDE345432$ZTE3ANNT4P23285,F00C514DC85C,F00C514DC85D,ZTEGDE34518B$ZTE3ANNT4P27137,F00C514E22A4,F00C514E22A5,ZTEGDE346097$ZTE3ANNT2V69681,D8313991EFFE,D8313991EFFF,ZTEGDD3102B0$ZTE3ANNR9F10396,D89A0DA3D18B,D89A0DA3D18C,ZTEGDB154FE7', '',0318,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-11 15:49:20 Duration: 5s453ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 350ms 929ms 555ms 96 53s371ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 11 00 1 718ms 718ms 01 2 925ms 462ms 03 1 697ms 697ms 04 1 617ms 617ms 05 3 1s728ms 576ms 07 2 1s165ms 582ms 08 9 4s899ms 544ms 09 7 4s119ms 588ms 10 10 5s813ms 581ms 11 7 4s470ms 638ms 12 7 3s478ms 496ms 13 9 4s580ms 508ms 14 10 5s124ms 512ms 15 11 5s898ms 536ms 16 6 3s813ms 635ms 17 8 4s253ms 531ms 18 1 453ms 453ms 22 1 612ms 612ms [ User: intelifix - Total duration: 53s371ms - Times executed: 96 ]
[ Application: [unknown] - Total duration: 53s371ms - Times executed: 96 ]
-
select * from rs_menu_grants (406, 18, 1);
Date: 2026-08-11 11:55:15 Duration: 929ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (503, 18, 1);
Date: 2026-08-11 16:32:08 Duration: 844ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (417, 81, 1);
Date: 2026-08-11 10:58:27 Duration: 780ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 4 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 11 08 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms [ User: intelifix - Total duration: 5m55s - Times executed: 4 ]
[ Application: psql - Total duration: 5m55s - Times executed: 3 ]
[ Application: [unknown] - Total duration: 519ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 18,010 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 21 FATAL entries
- 4107 ERROR entries
- 0 WARNING entries
- 5 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,033 Max number of times the same event was reported
- 4,133 Total events found
Rank Times reported Error 1 4,033 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 11 00 59 01 60 02 60 03 55 04 60 05 59 06 60 07 180 08 289 09 410 10 403 11 368 12 224 13 230 14 362 15 363 16 234 17 209 18 60 19 59 20 60 21 59 22 60 23 50 - ERROR: prepared statement "_PLAN00000000296C6130" does not exist
- ERROR: prepared statement "_PLAN0000000029755BA0" does not exist
- ERROR: prepared statement "_PLAN00000000296C4EF0" does not exist
Statement: DEALLOCATE "_PLAN00000000296C6130"
Date: 2026-08-11 00:00:35 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029755BA0"
Date: 2026-08-11 00:01:36 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000296C4EF0"
Date: 2026-08-11 00:02:39 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 11 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-11 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-11 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-11 01:05:02 Database: brasilia Application: psql User: intelifix Remote: [local]
3 11 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 11 08 3 11 3 12 3 14 2 - ERROR: column "_f" does not exist at character 27
- ERROR: column "_f" does not exist at character 27
- ERROR: column "_f" does not exist at character 27
Statement: SELECT * FROM RS_ETIQUETA(_f)
Date: 2026-08-11 08:46:17 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(_f)
Date: 2026-08-11 08:46:17 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(_f)
Date: 2026-08-11 08:46:17 Database: rio Application: [unknown] User: etiquetas Remote: [local]
4 10 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 11 10 2 13 2 15 1 16 1 17 4 - ERROR: syntax error at or near "]" at character 35
- ERROR: syntax error at or near "]" at character 35
- ERROR: syntax error at or near ")" at character 34
Statement: select * from rs_caixa_qr(3429620 ])
Date: 2026-08-11 10:18:09 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(3429620 ])
Date: 2026-08-11 10:18:09 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(126671,)
Date: 2026-08-11 13:34:46 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
5 9 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 11 00 1 04 4 06 1 13 1 20 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-08-11 00:02:15 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-11 04:42:32 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-11 04:42:47 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
6 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 11 03 9 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-08-11 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-08-11 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-11 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
7 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 11 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-11 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-11 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-11 05:32:05 Database: contagem Application: psql User: intelifix Remote: [local]
8 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 11 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-11 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-11 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-11 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
9 3 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #9
Day Hour Count Aug 11 15 2 16 1 - LOG: process 579151 still waiting for ShareLock on transaction 4212719 after 1000.080 ms
- LOG: process 579151 still waiting for ShareLock on transaction 4212719 after 41180.908 ms
- LOG: process 666381 still waiting for ShareLock on transaction 4219874 after 1000.175 ms
Detail: Process holding the lock: 538946. Wait queue: 579151.
Context: while updating tuple (76439,5) 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-11 15:15:10 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 538946. Wait queue: 579151.
Context: while updating tuple (76439,5) 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-11 15:15:50 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 636345. Wait queue: 666381.
Context: while updating tuple (19598,48) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(276683,503,'929240188137,9C24722FEBCD','',0302,00,'[{"item":"0","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',00);Date: 2026-08-11 16:32:21 Database: rio Application: [unknown] User: intelifix Remote: [local]
10 2 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #10
Day Hour Count Aug 11 08 2 - ERROR: trailing junk after numeric literal at or near "24E4CE8B9C78" at character 27
- ERROR: trailing junk after numeric literal at or near "24E4CE8B9C78" at character 27
Statement: select * from rs_caixa_qr(24E4CE8B9C78)
Date: 2026-08-11 08:48:26 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(24E4CE8B9C78)
Date: 2026-08-11 08:48:26 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
11 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #11
Day Hour Count Aug 11 14 1 - LOG: process 497765 still waiting for AccessExclusiveLock on relation 3685166 of database 358220 after 1000.122 ms
Detail: Process holding the lock: 530319. Wait queue: 497765.
Statement: DROP TABLE IF EXISTS temp0000288012;Date: 2026-08-11 14:32:46 Database: rio Application: [unknown] User: intelifix Remote: [local]
12 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #12
Day Hour Count Aug 11 03 1 - LOG: database system was shut down at 2026-08-11 03:05:01 -03
Date: 2026-08-11 03:05:02
13 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #13
Day Hour Count Aug 11 14 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000288012"
Date: 2026-08-11 14:32:46