pgBadger-
Global information
- Generated on Thu Jul 23 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 37,340 log entries in 9s
- Log start from 2026-07-23 00:02:01 to 2026-07-23 23:49:48
-
Overview
Global Stats
- 400 Number of unique normalized queries
- 6,055 Number of queries
- 7h52m57s Total query duration
- 2026-07-23 00:02:22 First query
- 2026-07-23 23:49:47 Last query
- 6 queries/s at 2026-07-23 11:07:47 Query peak
- 7h52m57s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h52m57s Execute total duration
- 2,422 Number of events
- 14 Number of unique normalized events
- 2,264 Max number of times the same event was reported
- 0 Number of cancellation
- 484 Total number of automatic vacuums
- 1,148 Total number of automatic analyzes
- 15 Number temporary file
- 236.72 MiB Max size of temporary file
- 109.24 MiB Average size of temporary file
- 346 Total number of sessions
- 11 sessions at 2026-07-23 18:25:04 Session peak
- 12d19h22m31s Total duration of sessions
- 53m18s Average duration of sessions
- 17 Average queries per session
- 1m22s Average queries duration per session
- 51m56s Average idle time per session
- 380 Total number of connections
- 4 connections/s at 2026-07-23 07:40:49 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-07-23 11:07:47 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-23 11:07:47 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-23 10:57:14 Date
Queries duration
Key values
- 7h52m57s 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) Jul 23 00 29 0ms 20s673ms 4s221ms 26s295ms 1m11s 1m11s 01 31 0ms 3s125ms 1s7ms 4s629ms 5s997ms 6s99ms 02 17 0ms 3s992ms 1s720ms 6s90ms 6s507ms 6s507ms 03 25 0ms 3s18ms 1s34ms 4s758ms 6s304ms 6s304ms 04 21 0ms 2s911ms 1s275ms 4s513ms 4s694ms 4s694ms 05 30 0ms 8m54s 36s935ms 2m32s 4m13s 8m54s 06 33 0ms 37s407ms 3s991ms 28s212ms 38s344ms 38s344ms 07 234 0ms 7m57s 8s90ms 45s873ms 5m 8m2s 08 530 150ms 7m9s 2s671ms 35s980ms 1m31s 7m52s 09 563 150ms 8m6s 3s942ms 1m9s 5m47s 8m11s 10 584 150ms 7m51s 3s598ms 51s512ms 4m36s 8m27s 11 643 150ms 9m42s 3s762ms 1m 5m37s 9m45s 12 192 0ms 7m20s 5s758ms 12s744ms 2m51s 7m59s 13 453 151ms 6m3s 2s446ms 28s357ms 53s398ms 6m57s 14 730 150ms 6m53s 3s638ms 1m14s 5m11s 6m57s 15 660 150ms 8m19s 3s597ms 1m16s 5m9s 8m54s 16 418 0ms 7m56s 4s587ms 48s584ms 4m29s 8m1s 17 294 0ms 6m47s 5s22ms 57s126ms 3m46s 7m37s 18 26 0ms 5m33s 22s752ms 43s740ms 3m9s 5m33s 19 21 0ms 5m30s 28s740ms 45s734ms 3m22s 5m30s 20 121 0ms 7m22s 11s93ms 1m35s 3m50s 7m22s 21 35 0ms 6m10s 19s131ms 18s171ms 3m33s 6m46s 22 29 0ms 5m44s 21s828ms 3m25s 5m44s 5m44s 23 336 0ms 1m33s 7s64ms 1m5s 1m8s 1m33s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 23 00 7 0 3s992ms 150ms 1s227ms 26s295ms 01 13 0 320ms 238ms 362ms 1s524ms 02 0 0 0ms 0ms 0ms 0ms 03 10 0 338ms 200ms 1s19ms 1s311ms 04 3 0 322ms 0ms 169ms 798ms 05 9 0 405ms 0ms 938ms 1s184ms 06 12 0 3s710ms 936ms 14s2ms 24s409ms 07 155 0 10s61ms 3s817ms 13s563ms 5m20s 08 411 0 2s524ms 6s795ms 16s353ms 4m8s 09 438 0 4s574ms 10s254ms 59s331ms 6m44s 10 431 0 3s899ms 14s642ms 35s963ms 5m35s 11 481 0 4s260ms 29s137ms 54s627ms 6m17s 12 122 0 7s795ms 3s356ms 4s808ms 3m54s 13 331 0 2s578ms 5s27ms 8s905ms 3m45s 14 526 0 3s885ms 13s155ms 54s696ms 5m39s 15 511 0 3s968ms 16s882ms 1m4s 5m21s 16 317 0 5s120ms 23s50ms 29s140ms 5m12s 17 178 0 7s60ms 10s622ms 46s814ms 4m18s 18 11 0 51s751ms 0ms 43s740ms 5m33s 19 6 0 1m36s 0ms 45s734ms 5m30s 20 12 93 12s451ms 1m11s 1m35s 7m22s 21 13 0 48s984ms 1s182ms 18s171ms 6m46s 22 8 0 1m14s 1s904ms 3m25s 5m44s 23 10 326 7s64ms 1m3s 1m5s 1m33s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 23 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 Jul 23 00 0 1 1.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 2 2.00 0.00% 04 0 1 1.00 0.00% 05 0 3 3.00 0.00% 06 0 2 2.00 0.00% 07 0 10 10.00 0.00% 08 0 13 13.00 0.00% 09 0 13 13.00 0.00% 10 0 12 12.00 0.00% 11 0 19 19.00 0.00% 12 0 9 9.00 0.00% 13 0 11 11.00 0.00% 14 0 16 16.00 0.00% 15 0 14 14.00 0.00% 16 0 9 9.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 1 1.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 Jul 23 00 15 0.00/s 01 11 0.00/s 02 7 0.00/s 03 12 0.00/s 04 7 0.00/s 05 8 0.00/s 06 12 0.00/s 07 18 0.01/s 08 23 0.01/s 09 19 0.01/s 10 23 0.01/s 11 21 0.01/s 12 16 0.00/s 13 20 0.01/s 14 23 0.01/s 15 18 0.01/s 16 21 0.01/s 17 14 0.00/s 18 27 0.01/s 19 17 0.00/s 20 14 0.00/s 21 10 0.00/s 22 10 0.00/s 23 14 0.00/s Day Hour Count Average Duration Average idle time Jul 23 00 4 1h45s 1h14s 01 14 1h1m13s 1h1m11s 02 10 1h36s 1h33s 03 12 20m27s 20m25s 04 7 1h1m17s 1h1m13s 05 7 1h1m15s 58m37s 06 8 56m52s 56m36s 07 12 57m55s 55m18s 08 20 54m25s 53m14s 09 22 56m35s 54m54s 10 20 52m2s 50m17s 11 22 52m20s 50m30s 12 21 53m50s 52m58s 13 14 57m24s 56m5s 14 20 57m57s 55m44s 15 24 56m39s 55m 16 17 55m29s 53m36s 17 23 53m6s 52m2s 18 16 45m52s 45m15s 19 9 54m46s 53m39s 20 11 44m19s 42m17s 21 10 55m13s 54m6s 22 8 1h45s 59m26s 23 15 39m3s 36m25s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-07-23 07:40:49 Date
Connections per database
Key values
- rio Main Database
- 380 connections Total
Connections per user
Key values
- intelifix Main User
- 380 connections Total
-
Sessions
Simultaneous sessions
Key values
- 11 sessions Session Peak
- 2026-07-23 18:25:04 Date
Histogram of session times
Key values
- 277 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 346 sessions Total
Sessions per user
Key values
- intelifix Main User
- 346 sessions Total
Sessions per host
Key values
- [local] Main Host
- 346 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 68,225 buffers Checkpoint Peak
- 2026-07-23 00:09:40 Date
- 270.051 seconds Highest write time
- 0.120 seconds Sync time
Checkpoints Wal files
Key values
- 14 files Wal files usage Peak
- 2026-07-23 12:19:38 Date
Checkpoints distance
Key values
- 450.85 Mo Distance Peak
- 2026-07-23 12:19:38 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 23 00 84,000 671.754s 0.051s 671.893s 01 2,848 286.231s 0.047s 286.354s 02 1,807 181.55s 0.035s 181.634s 03 2,528 253.823s 0.04s 253.932s 04 2,591 260.694s 0.049s 260.807s 05 11,677 1,117.1s 0.109s 1,117.268s 06 8,777 655.681s 0.023s 655.739s 07 34,440 2,330.03s 0.368s 2,330.555s 08 48,297 3,066.886s 0.533s 3,067.613s 09 58,007 3,238.951s 0.57s 3,239.706s 10 77,199 3,238.94s 0.61s 3,239.769s 11 61,955 3,238.454s 0.872s 3,239.616s 12 43,440 1,951.415s 0.2s 1,951.74s 13 25,260 2,413.191s 0.533s 2,413.885s 14 56,849 3,238.82s 0.684s 3,239.728s 15 65,658 3,238.702s 0.686s 3,239.618s 16 49,680 2,934.988s 0.466s 2,935.627s 17 33,782 2,370.856s 0.293s 2,371.312s 18 1,337 133.782s 0.019s 133.823s 19 22 2.229s 0.004s 2.238s 20 1,558 204.26s 0.048s 204.332s 21 3,181 319.756s 0.08s 319.921s 22 1,971 198.316s 0.063s 198.449s 23 559 58.288s 0.035s 58.359s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 23 00 0 0 12 550 0.006s 0.008s 01 0 0 0 590 0.002s 0.012s 02 0 0 1 517 0.004s 0.007s 03 0 0 1 592 0.002s 0.01s 04 0 0 1 706 0.004s 0.01s 05 0 0 4 770 0.010s 0.007s 06 0 0 2 319 0.003s 0.004s 07 0 0 26 4,020 0.015s 0.012s 08 0 0 31 6,207 0.013s 0.012s 09 0 0 25 6,212 0.010s 0.012s 10 0 0 46 6,388 0.009s 0.012s 11 0 0 37 7,907 0.009s 0.012s 12 0 0 21 2,840 0.008s 0.012s 13 0 0 15 5,857 0.006s 0.012s 14 0 0 47 7,507 0.006s 0.012s 15 0 0 40 7,268 0.006s 0.012s 16 0 0 28 5,296 0.004s 0.011s 17 0 0 31 3,682 0.008s 0.012s 18 0 0 0 133 0.003s 0.004s 19 0 0 0 3 0.002s 0.002s 20 0 0 1 88 0.009s 0.003s 21 0 0 1 576 0.007s 0.011s 22 0 0 1 428 0.008s 0.01s 23 0 0 0 34 0.011s 0.01s Day Hour Count Avg time (sec) Jul 23 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 Jul 23 00 22,850.12 kB 77,681.50 kB 01 1,400.40 kB 31,848.30 kB 02 1,309.00 kB 13,389.14 kB 03 1,266.10 kB 2,493.60 kB 04 1,319.30 kB 2,619.00 kB 05 11,180.43 kB 15,905.14 kB 06 8,112.25 kB 15,740.75 kB 07 34,802.17 kB 62,045.92 kB 08 42,492.92 kB 80,097.08 kB 09 34,238.75 kB 74,006.67 kB 10 62,667.42 kB 76,703.42 kB 11 50,713.17 kB 100,331.17 kB 12 28,342.42 kB 135,305.08 kB 13 21,174.42 kB 69,357.25 kB 14 64,301.50 kB 133,607.00 kB 15 54,460.92 kB 94,162.50 kB 16 41,726.91 kB 82,841.09 kB 17 41,622.00 kB 86,357.00 kB 18 1,357.50 kB 47,114.25 kB 19 173.00 kB 36,006.00 kB 20 4,723.67 kB 30,399.33 kB 21 1,783.78 kB 17,453.11 kB 22 1,177.11 kB 7,669.11 kB 23 287.20 kB 3,972.20 kB -
Temporary Files
Size of temporary files
Key values
- 473.44 MiB Temp Files size Peak
- 2026-07-23 05:32:12 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-23 05:30:42 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 23 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.07 GiB 110.06 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 1 104.00 MiB 104.00 MiB 13 0 0 0 14 2 220.00 MiB 110.00 MiB 15 1 104.00 MiB 104.00 MiB 16 0 0 0 17 1 110.00 MiB 110.00 MiB 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 919.51 MiB 70.61 MiB 236.72 MiB 114.94 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-23 05:32:22 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-23 05:32:12 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 5 538.00 MiB 104.00 MiB 110.00 MiB 107.60 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027450, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-23 09:36:06 Duration: 6m39s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027463, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-23 11:19:44 Duration: 6m9s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027449, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-23 09:00:32 Duration: 5m39s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 2 181.06 MiB 90.53 MiB 90.53 MiB 90.53 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-23 05:30:45 Duration: 43s701ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-23 05:30:42 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 236.72 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-23 05:32:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 236.72 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-23 05:32:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 110.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(7,401,''/var/www/html/uploads/APlanilha para criação de lotes Recebimento - NF15078.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-23 14:43:45 - Database: brasilia - User: intelifix - Remote: [local] - Application: [unknown] ]
4 110.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(7,401,''/var/www/html/uploads/APlanilha para criação de lotes Recebimento - NF15078.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-23 14:48:35 - Database: brasilia - User: intelifix - Remote: [local] - Application: [unknown] ]
5 110.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(7,422,''/var/www/html/uploads/APlanilha para criação de lotes Recebimento - NF15078.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-23 17:00:45 - Database: brasilia - User: intelifix - Remote: [local] - Application: [unknown] ]
6 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-23 12:11:28 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-23 15:33:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 90.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-23 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 90.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-23 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 78.11 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-23 05:32:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 78.03 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-23 05:32:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 78.03 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-23 05:32:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 70.68 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-23 05:32:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 70.61 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-23 05:32:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 70.61 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-23 05:32:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 1.98 sec Highest CPU-cost vacuum
Table public.rs_mv_codigos_barra
Database rio - 2026-07-23 05:32:42 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 1.98 sec Highest CPU-cost vacuum
Table public.rs_mv_codigos_barra
Database rio - 2026-07-23 05:32:42 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (119) Main table analyzed (database rio)
- 1,148 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 119 brasilia.pg_catalog.pg_attribute 72 rio.pg_catalog.pg_class 61 rio.pg_catalog.pg_type 52 rio.public.usuarios 47 brasilia.pg_catalog.pg_class 44 brasilia.pg_catalog.pg_type 41 rio.pg_catalog.pg_index 35 rio.public.temp0000286222 31 brasilia.pg_catalog.pg_index 30 contagem.pg_catalog.pg_attribute 27 rio.pg_catalog.pg_depend 27 brasilia.pg_catalog.pg_depend 26 rio.public.temp0000286274 26 rio.public.temp0000286226 24 rio.public.temp0000286296 20 rio.public.temp0000286248 20 rio.public.temp0000286212 19 rio.public.temp0000286210 19 contagem.pg_catalog.pg_class 18 contagem.public.usuarios 18 rio.public.temp0000286216 18 brasilia.public.temp0000236738 17 contagem.public.temp0000226620 14 contagem.pg_catalog.pg_type 14 brasilia.public.temp0000236770 11 rio.public.temp0000286304 10 brasilia.public.usuarios 10 rio.public.temp0000286094 10 brasilia.public.temp0000236774 10 brasilia.public.temp0000236784 9 rio.public.temp0000286112 9 contagem.pg_catalog.pg_index 9 brasilia.public.temp0000236728 9 rio.public.temp0000286256 9 rio.public.temp0000286288 9 rio.public.temp0000286236 9 rio.public.temp0000286238 9 rio.public.temp0000286116 8 contagem.pg_catalog.pg_depend 7 brasilia.public.temp0000236764 7 rio.public.temp0000286244 7 rio.public.temp0000286326 6 rio.public.temp0000286320 6 rio.public.temp0000284750 5 contagem.pg_catalog.pg_shdepend 5 rio.pg_catalog.pg_shdepend 5 rio.public.temp0000286170 5 rio.public.temp0000286220 5 contagem.public.temp0000226678 5 rio.public.temp0000286290 5 rio.public.temp0000286240 5 rio.public.temp0000286242 4 postgres.pg_catalog.pg_shdepend 4 rio.public.temp0000285960 4 contagem.public.temp0000226658 4 brasilia.public.temp0000236758 4 brasilia.public.temp0000236720 4 brasilia.pg_catalog.pg_shdepend 3 brasilia.public.temp0000236756 3 brasilia.public.temp0000236744 3 rio.public.temp0000286334 3 rio.public.temp0000285404 3 brasilia.public.temp0000236754 3 brasilia.public.temp0000236746 3 rio.public.temp0000286234 3 rio.public.temp0000286280 3 brasilia.public.nf_entrada 3 rio.public.temp0000286312 3 rio.public.temp0000286272 3 brasilia.public.temp0000236762 3 brasilia.public.temp0000236776 3 brasilia.public.temp0000236714 3 rio.public.tmp_drill_0320 3 rio.public.temp0000286230 2 brasilia.public.temp0000236742 2 template1.pg_catalog.pg_shdepend 2 contagem.public.temp0000226686 2 brasilia.public.temp0000236786 2 rio.public.temp0000286270 1 brasilia.public.temp0000236792 1 rio.public.temp0000286282 1 contagem.public.temp0000226682 1 rio.public.temp0000286254 1 rio.public.temp0000286330 1 rio.public.temp0000286214 1 brasilia.public.temp0000236778 1 brasilia.public.temp0000236772 1 contagem.public.nf_entrada 1 rio.public.temp0000286310 1 rio.public.temp0000286268 1 rio.public.temp0000286260 1 brasilia.public.temp0000236722 1 brasilia.public.temp0000236780 1 brasilia.public.temp0000236740 1 rio.public.temp0000286328 1 contagem.public.parametros 1 brasilia.public.temp0000236724 1 brasilia.public.temp0000236760 1 brasilia.public.temp0000236768 1 brasilia.public.temp0000236718 1 brasilia.public.temp0000236790 1 Total 1,148 Vacuums per table
Key values
- pg_catalog.pg_attribute (41) Main table vacuumed on database rio
- 484 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 41 41 0 0 0 0 0 22,579 6,004 9,076,080 322 7,775 brasilia.pg_catalog.pg_attribute 35 32 0 0 0 0 0 17,434 3,227 6,199,221 88 2,332 rio.public.temp0000286222 31 0 0 0 0 0 0 17,960 3,567 5,513,676 0 0 brasilia.pg_catalog.pg_class 26 24 0 0 0 0 0 4,833 848 1,564,856 21 88 rio.pg_catalog.pg_class 25 24 0 0 0 0 0 4,560 1,480 2,287,045 89 330 rio.public.temp0000286296 21 0 0 0 0 0 0 25,440 177 1,678,950 0 0 rio.pg_catalog.pg_type 20 20 0 0 0 0 0 1,934 599 778,773 55 183 rio.public.temp0000286248 20 0 0 0 0 0 0 28,472 3,419 5,988,359 0 0 brasilia.pg_catalog.pg_type 20 20 0 0 0 0 0 1,939 411 669,319 18 56 rio.public.temp0000286274 19 0 0 0 0 0 0 10,888 91 656,874 0 0 contagem.public.usuarios 18 0 0 0 0 0 0 90 73 36,541 1 1 brasilia.public.temp0000236738 14 0 0 0 0 0 0 2,696 81 174,759 0 0 brasilia.pg_catalog.pg_index 14 14 0 0 0 0 0 795 163 161,648 22 36 rio.pg_catalog.pg_index 13 13 0 0 0 0 0 768 217 213,942 29 48 brasilia.pg_catalog.pg_depend 10 10 0 0 0 0 0 2,779 788 1,341,633 24 219 contagem.pg_catalog.pg_attribute 10 10 0 0 0 0 0 5,589 1,634 2,924,621 8 204 rio.pg_catalog.pg_depend 10 10 0 0 0 0 0 3,386 1,133 1,524,088 77 583 rio.public.temp0000286112 9 0 0 0 0 0 0 737 158 253,858 0 0 rio.pg_catalog.pg_statistic 8 8 0 0 0 0 0 9,181 1,858 8,654,484 780 3,582 rio.public.usuarios 8 6 0 0 0 0 0 167 66 123,577 10 11 brasilia.public.temp0000236784 8 0 0 0 0 0 0 1,474 281 462,609 0 0 template1.pg_catalog.pg_shdepend 8 8 0 0 0 0 0 1,043 340 578,786 103 220 contagem.pg_catalog.pg_class 6 6 0 0 0 0 0 1,025 301 444,727 6 19 rio.public.temp0000286326 5 0 0 0 0 0 0 8,382 20 497,553 0 0 rio.public.temp0000286170 5 0 0 0 0 0 0 502 27 34,008 0 0 contagem.pg_catalog.pg_type 5 5 0 0 0 0 0 479 157 241,012 4 8 rio.public.temp0000284750 4 0 0 0 0 0 0 250 69 92,248 0 0 rio.public.temp0000286320 4 0 0 0 0 0 0 591 24 38,968 0 0 brasilia.pg_catalog.pg_statistic 4 4 0 0 0 0 0 5,198 840 3,604,344 407 3,097 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 2,072 440 2,439,603 138 393 rio.public.temp0000286312 3 0 0 0 0 0 0 5,028 12 298,461 0 0 rio.public.temp0000286272 3 0 0 0 0 0 0 3,354 11 199,630 0 0 contagem.pg_catalog.pg_index 3 3 0 0 0 0 0 167 48 44,524 3 3 brasilia.public.temp0000236756 3 0 0 0 0 0 0 729 18 46,428 0 0 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 919 280 590,461 2 12 rio.public.temp0000285960 3 0 0 0 0 0 0 297 107 176,507 0 0 rio.public.tmp_drill_0320 3 3 0 0 0 0 0 1,743 9 302,291 0 0 brasilia.public.temp0000236764 3 0 0 0 0 0 0 494 17 32,501 0 0 brasilia.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 519 117 502,387 34 79 postgres.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 472 167 261,569 24 43 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,972 598 2,018,291 497 3,402 contagem.public.temp0000226686 2 0 0 0 0 0 0 114 11 8,549 0 0 brasilia.public.temp0000236746 2 0 0 0 0 0 0 251 11 17,004 0 0 rio.public.temp0000285404 2 0 0 0 0 0 0 69 11 5,757 0 0 rio.public.temp0000286268 1 0 0 0 0 0 0 91 6 6,294 0 0 rio.public.temp0000286260 1 0 0 0 0 0 0 85 6 5,925 0 0 brasilia.public.temp0000236758 1 0 0 0 0 0 0 243 242 384,335 0 0 brasilia.public.temp0000236744 1 0 0 0 0 0 0 245 6 15,676 0 0 rio.public.temp0000286288 1 0 0 0 0 0 0 91 6 6,294 0 0 rio.public.temp0000286310 1 0 0 0 0 0 0 8 5 1,391 0 0 rio.public.temp0000286230 1 0 0 0 0 0 0 55 6 4,089 0 0 rio.public.temp0000286290 1 0 0 0 0 0 0 91 6 6,294 0 0 rio.public.temp0000286270 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000286240 1 0 0 0 0 0 0 8 5 1,289 0 0 rio.public.temp0000286234 1 0 0 0 0 0 0 79 6 5,560 0 0 brasilia.public.temp0000236772 1 0 0 0 0 0 0 8 6 3,670 0 0 rio.public.temp0000286280 1 0 0 0 0 0 0 91 6 6,294 0 0 rio.public.rs_mv_codigos_barra 1 1 0 0 0 0 0 4,288 3,067 12,241,447 0 0 rio.public.temp0000286238 1 0 0 0 0 0 0 8 5 1,289 0 0 rio.public.temp0000286328 1 0 0 0 0 0 0 94 6 6,476 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 138 34 89,854 11 19 rio.public.temp0000286282 1 0 0 0 0 0 0 91 6 6,294 0 0 rio.public.temp0000286330 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000286254 1 0 0 0 0 0 0 84 6 5,853 0 0 rio.public.temp0000286214 1 0 0 0 0 0 0 1,673 4 99,310 0 0 Total 484 278 0 0 0 0 0 207,850 33,350 75,659,704 2,773 22,743 Vacuum throughput per table
Key values
- pg_catalog.pg_attribute (3.34) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 3.34 brasilia.pg_catalog.pg_attribute 0 0 1.94 rio.public.temp0000286222 0 0 0.99 brasilia.pg_catalog.pg_class 0 0 0.56 rio.pg_catalog.pg_class 0 0 0.77 rio.public.temp0000286296 0 0 0.85 rio.pg_catalog.pg_type 0 0 0.26 rio.public.temp0000286248 0 0 1.09 brasilia.pg_catalog.pg_type 0 0 0.22 rio.public.temp0000286274 0 0 0.52 contagem.public.usuarios 0 0 0 brasilia.public.temp0000236738 0 0 0.25 brasilia.pg_catalog.pg_index 0 0 0.12 rio.pg_catalog.pg_index 0 0 0.14 brasilia.pg_catalog.pg_depend 0 0 0.45 contagem.pg_catalog.pg_attribute 0 0 0.98 rio.pg_catalog.pg_depend 0 0 0.74 rio.public.temp0000286112 0 0 0.09 rio.pg_catalog.pg_statistic 0 0 1.12 rio.public.usuarios 0 0 0.01 brasilia.public.temp0000236784 0 0 0.13 template1.pg_catalog.pg_shdepend 0 0 0.26 contagem.pg_catalog.pg_class 0 0 0.37 rio.public.temp0000286326 0 0 0.24 rio.public.temp0000286170 0 0 0.08 contagem.pg_catalog.pg_type 0 0 0.2 rio.public.temp0000284750 0 0 0.06 rio.public.temp0000286320 0 0 0.07 brasilia.pg_catalog.pg_statistic 0 0 0.51 rio.pg_toast.pg_toast_2619 0 0 0.23 rio.public.temp0000286312 0 0 0.14 rio.public.temp0000286272 0 0 0.15 contagem.pg_catalog.pg_index 0 0 0.1 brasilia.public.temp0000236756 0 0 0.05 contagem.pg_catalog.pg_depend 0 0 0.15 rio.public.temp0000285960 0 0 0.05 rio.public.tmp_drill_0320 0 0 0.07 brasilia.public.temp0000236764 0 0 0.05 brasilia.pg_toast.pg_toast_2619 0 0 0.06 postgres.pg_catalog.pg_shdepend 0 0 0.15 contagem.pg_catalog.pg_statistic 0 0 0.2 contagem.public.temp0000226686 0 0 0.02 brasilia.public.temp0000236746 0 0 0.04 rio.public.temp0000285404 0 0 0.04 rio.public.temp0000286268 0 0 0.01 rio.public.temp0000286260 0 0 0.02 brasilia.public.temp0000236758 0 0 0.03 brasilia.public.temp0000236744 0 0 0.03 rio.public.temp0000286288 0 0 0.01 rio.public.temp0000286310 0 0 0.03 rio.public.temp0000286230 0 0 0.02 rio.public.temp0000286290 0 0 0.02 rio.public.temp0000286270 0 0 0.05 rio.public.temp0000286240 0 0 0.02 rio.public.temp0000286234 0 0 0.02 brasilia.public.temp0000236772 0 0 0.01 rio.public.temp0000286280 0 0 0.02 rio.public.rs_mv_codigos_barra 0 0 1.98 rio.public.temp0000286238 0 0 0.01 rio.public.temp0000286328 0 0 0.02 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000286282 0 0 0.02 rio.public.temp0000286330 0 0 0.05 rio.public.temp0000286254 0 0 0.02 rio.public.temp0000286214 0 0 0.05 Total 0 0 20.3 Tuples removed per table
Key values
- pg_catalog.pg_attribute (168980) Main table with removed tuples on database brasilia
- 493414 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain brasilia.pg_catalog.pg_attribute 35 32 168,980 813,352 15,913 202 22,924 rio.pg_catalog.pg_attribute 41 41 168,018 994,440 31,871 269 24,208 contagem.pg_catalog.pg_attribute 10 10 37,145 231,200 34 0 5,367 rio.public.tmp_drill_0320 3 3 25,624 26,584 0 0 670 rio.pg_catalog.pg_statistic 8 8 13,706 67,594 719 0 10,288 rio.pg_catalog.pg_depend 10 10 9,963 183,449 3,510 0 1,870 brasilia.pg_catalog.pg_type 20 20 8,340 44,298 10 29 1,441 brasilia.pg_catalog.pg_statistic 4 4 8,317 33,264 0 0 4,288 rio.pg_catalog.pg_type 20 20 6,688 46,862 1,500 4 1,478 brasilia.pg_catalog.pg_class 26 24 6,617 96,540 3,121 44 3,608 template1.pg_catalog.pg_shdepend 8 8 6,467 109,530 849 0 952 brasilia.pg_catalog.pg_depend 10 10 5,649 178,132 0 11 1,821 contagem.pg_catalog.pg_statistic 2 2 5,328 14,853 0 0 2,022 brasilia.pg_catalog.pg_index 14 14 5,302 26,291 2 12 787 rio.pg_catalog.pg_class 25 24 3,930 91,821 4,737 35 3,481 rio.pg_catalog.pg_index 13 13 2,848 24,941 85 6 698 postgres.pg_catalog.pg_shdepend 3 3 2,227 40,678 22 0 357 contagem.pg_catalog.pg_depend 3 3 1,868 57,385 6 0 520 contagem.pg_catalog.pg_type 5 5 1,499 11,233 2 13 321 rio.pg_toast.pg_toast_2619 4 4 1,224 2,623 1 8 1,140 contagem.public.usuarios 18 0 1,133 414 0 0 36 contagem.pg_catalog.pg_class 6 6 872 21,947 4 1 780 contagem.pg_catalog.pg_index 3 3 712 5,689 1 11 148 rio.public.usuarios 8 6 406 4,993 921 0 144 brasilia.pg_toast.pg_toast_2619 3 3 295 431 3 0 207 rio.public.rs_mv_codigos_barra 1 1 129 4,039,441 0 0 26,761 contagem.pg_toast.pg_toast_2619 1 1 127 118 0 0 59 rio.public.temp0000286312 3 0 0 70,790 0 0 5,184 rio.public.temp0000286268 1 0 0 1,582 0 45 83 rio.public.temp0000286272 3 0 0 70,731 0 0 5,184 rio.public.temp0000286260 1 0 0 1,475 0 51 77 rio.public.temp0000284750 4 0 0 9,889 0 102 218 rio.public.temp0000286274 19 0 0 208,834 0 300 13,332 brasilia.public.temp0000236756 3 0 0 9,397 0 63 705 brasilia.public.temp0000236758 1 0 0 3,132 0 21 235 brasilia.public.temp0000236744 1 0 0 3,130 0 21 235 contagem.public.temp0000226686 2 0 0 2,560 0 60 196 brasilia.public.temp0000236784 8 0 0 25,062 0 168 1,880 rio.public.temp0000286326 5 0 0 118,014 0 0 8,640 rio.public.temp0000286288 1 0 0 1,600 0 45 83 rio.public.temp0000286310 1 0 0 6,103 0 54 138 rio.public.temp0000286112 9 0 0 45,074 0 134 1,018 rio.public.temp0000286296 21 0 0 363,561 0 263 26,425 rio.public.temp0000286230 1 0 0 2,111 0 17 47 rio.public.temp0000286290 1 0 0 1,600 0 45 83 rio.public.temp0000286320 4 0 0 22,429 0 146 558 rio.public.temp0000286270 1 0 0 23,576 0 0 1,728 rio.public.temp0000285960 3 0 0 12,179 0 111 273 rio.public.temp0000286170 5 0 0 24,263 0 157 547 rio.public.temp0000286240 1 0 0 1,366 0 57 71 rio.public.temp0000286234 1 0 0 1,365 0 57 71 brasilia.public.temp0000236772 1 0 0 3,134 0 21 235 rio.public.temp0000286280 1 0 0 1,600 0 45 83 brasilia.public.temp0000236764 3 0 0 9,402 0 63 705 rio.public.temp0000286238 1 0 0 1,365 0 57 71 brasilia.public.temp0000236738 14 0 0 43,830 0 295 3,289 rio.public.temp0000286328 1 0 0 1,619 0 42 86 rio.public.temp0000286222 31 0 0 308,755 0 1,078 22,090 rio.public.temp0000286282 1 0 0 1,600 0 45 83 rio.public.temp0000286330 1 0 0 23,601 0 0 1,728 rio.public.temp0000286254 1 0 0 3,399 0 52 76 rio.public.temp0000286248 20 0 0 471,351 0 0 34,560 brasilia.public.temp0000236746 2 0 0 6,262 0 42 470 rio.public.temp0000286214 1 0 0 23,553 0 0 1,728 rio.public.temp0000285404 2 0 0 5,962 0 58 134 Total 484 278 493,414 9,103,359 63,311 4,360 248,725 Pages removed per table
Key values
- public.temp0000286222 (1078) Main table with removed pages on database rio
- 4360 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000286222 31 0 0 1078 rio.public.temp0000286274 19 0 0 300 brasilia.public.temp0000236738 14 0 0 295 rio.pg_catalog.pg_attribute 41 41 168018 269 rio.public.temp0000286296 21 0 0 263 brasilia.pg_catalog.pg_attribute 35 32 168980 202 brasilia.public.temp0000236784 8 0 0 168 rio.public.temp0000286170 5 0 0 157 rio.public.temp0000286320 4 0 0 146 rio.public.temp0000286112 9 0 0 134 rio.public.temp0000285960 3 0 0 111 rio.public.temp0000284750 4 0 0 102 brasilia.public.temp0000236756 3 0 0 63 brasilia.public.temp0000236764 3 0 0 63 contagem.public.temp0000226686 2 0 0 60 rio.public.temp0000285404 2 0 0 58 rio.public.temp0000286240 1 0 0 57 rio.public.temp0000286234 1 0 0 57 rio.public.temp0000286238 1 0 0 57 rio.public.temp0000286310 1 0 0 54 rio.public.temp0000286254 1 0 0 52 rio.public.temp0000286260 1 0 0 51 rio.public.temp0000286268 1 0 0 45 rio.public.temp0000286288 1 0 0 45 rio.public.temp0000286290 1 0 0 45 rio.public.temp0000286280 1 0 0 45 rio.public.temp0000286282 1 0 0 45 brasilia.pg_catalog.pg_class 26 24 6617 44 rio.public.temp0000286328 1 0 0 42 brasilia.public.temp0000236746 2 0 0 42 rio.pg_catalog.pg_class 25 24 3930 35 brasilia.pg_catalog.pg_type 20 20 8340 29 brasilia.public.temp0000236758 1 0 0 21 brasilia.public.temp0000236744 1 0 0 21 brasilia.public.temp0000236772 1 0 0 21 rio.public.temp0000286230 1 0 0 17 contagem.pg_catalog.pg_type 5 5 1499 13 brasilia.pg_catalog.pg_index 14 14 5302 12 contagem.pg_catalog.pg_index 3 3 712 11 brasilia.pg_catalog.pg_depend 10 10 5649 11 rio.pg_toast.pg_toast_2619 4 4 1224 8 rio.pg_catalog.pg_index 13 13 2848 6 rio.pg_catalog.pg_type 20 20 6688 4 contagem.pg_catalog.pg_class 6 6 872 1 rio.public.temp0000286312 3 0 0 0 rio.public.temp0000286272 3 0 0 0 contagem.pg_catalog.pg_statistic 2 2 5328 0 rio.pg_catalog.pg_statistic 8 8 13706 0 rio.public.usuarios 8 6 406 0 rio.public.temp0000286326 5 0 0 0 contagem.pg_catalog.pg_depend 3 3 1868 0 contagem.public.usuarios 18 0 1133 0 rio.public.temp0000286270 1 0 0 0 rio.public.tmp_drill_0320 3 3 25624 0 template1.pg_catalog.pg_shdepend 8 8 6467 0 brasilia.pg_catalog.pg_statistic 4 4 8317 0 rio.public.rs_mv_codigos_barra 1 1 129 0 brasilia.pg_toast.pg_toast_2619 3 3 295 0 contagem.pg_toast.pg_toast_2619 1 1 127 0 contagem.pg_catalog.pg_attribute 10 10 37145 0 rio.pg_catalog.pg_depend 10 10 9963 0 rio.public.temp0000286330 1 0 0 0 postgres.pg_catalog.pg_shdepend 3 3 2227 0 rio.public.temp0000286248 20 0 0 0 rio.public.temp0000286214 1 0 0 0 Total 484 278 493,414 4,360 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 23 00 0 0 01 0 1 02 0 0 03 0 5 04 0 6 05 7 12 06 1 1 07 25 41 08 31 74 09 44 109 10 59 136 11 67 156 12 14 30 13 38 93 14 62 153 15 41 145 16 36 85 17 57 92 18 0 1 19 0 0 20 0 0 21 2 8 22 0 0 23 0 0 - 1.98 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 2 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 1s888ms 1s888ms 1s888ms 1s888ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (269622, 450, 'CP2409325YU,08C7F52C22ED,544D4242007818B2,08C7F52C22F0$CP234532WDM,08C7F5065F28,544D42420073B35D,08C7F5065F2B$CP2407320ET,08C7F5293AEE,544D42420077CED7,08C7F5293AF1$CP232532C1F,D4925ECC7533,544D4242006D4691,D4925ECC7536$CP23453248P,08C7F5027603,544D424200734420,08C7F5027606$CP2303327YS,D4925E14C624,544D42420062D515,D4925E14C627$CP2303326HQ,D4925E148F82,544D42420062CF03,D4925E148F85$CP230332802,D4925E14C7A7,544D42420062D540,D4925E14C7AA$CP2407328RC,08C7F52A7972,544D42420077F23B,08C7F52A7975$CP2303327EY,D4925E14B28F,544D42420062D2E8,D4925E14B292$CP234232R6M,D4925EF93C9C,544D424200724C79,D4925EF93C9F$CP23433242F,D4925EFEDE8D,544D42420072BA9A,D4925EFEDE90$CP240432NVM,08C7F52859A1,544D4242007777EA,08C7F52859A4$CP2319322JD,D4925E9FE6A4,544D42420069938E,D4925E9FE6A7$CP2345323FM,08C7F50257C7,544D4242007340C4,08C7F50257CA$CP2317324L7,D4925E950EF7,544D424200682C61,D4925E950EFA$CP234232PR4,D4925EF9057C,544D424200724659,D4925EF9057F$CP240332CKK,08C7F522B057,544D42420076D6E4,08C7F522B05A$CP23463208F,08C7F506D609,544D42420073B7E4,08C7F506D60C$CP2409325GJ,08C7F52C112C,544D4242007816B9,08C7F52C112F$CP232532CT0,D4925ECC92D6,544D4242006D49DC,D4925ECC92D9$CP234232NG5,D4925EF8D4DD,544D4242007240F2,D4925EF8D4E0$CP23103220B,D4925E33B9D1,544D42420065B863,D4925E33B9D4$CP230232GR2,D4925E08A26C,544D42420061DD51,D4925E08A26F$CP2301329KU,D4925E02D29C,544D4242006138BB,D4925E02D29F$CP24093225L,08C7F52B91A0,544D42420078088D,08C7F52B91A3$CP2322320DR,D4925EB2E584,544D4242006B8D84,D4925EB2E587$CP2305325S6,D4925E19680E,544D424200638FF9,D4925E196811$CP230232EDY,D4925E0848F3,544D42420061D360,D4925E0848F6$CP2407328Y1,08C7F52A8005,544D42420077F2F6,08C7F52A8008$CP230132FWV,D4925E03C51E,544D4242006153AD,D4925E03C521$CP22413219B,A0B53CC26B86,544D4242005E958D,A0B53CC26B89$CP230232FKE,D4925E0875BD,544D42420061D85A,D4925E0875C0$CP24093232V,08C7F52BB4BF,544D424200780C74,08C7F52BB4C2$CP23013233P,D4925E01DA3B,544D424200611D22,D4925E01DA3E$CP2239324LU,A0B53CC0C8D3,544D4242005E80B8,A0B53CC0C8D6$CP232232DFN,D4925EBD727D,544D4242006BC510,D4925EBD7280$CP2317324ZL,D4925E951D58,544D424200682DFA,D4925E951D5B$CP2319327A2,D4925EA09C81,544D42420069A7C3,D4925EA09C84$CP2319321SC,D4925E9FC9E2,544D42420069905C,D4925E9FC9E5', '',0298,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-07-23 11:03:07 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48123, 417, 'ZTE3ANNRCB22309,D831391FD9DC,D831391FD9DD,ZTEGDD2A0CBA$ZTE3ANNR2Q33441,F4E84F83C3C6,F4E84F83C3C7,ZTEGD97AF55B$ZTE3ANNR3Y35325,4896D952FCA6,4896D952FCA7,ZTEGD97EBAB2$ZTE3ANNR1Y33352,14CA56CFB82B,14CA56CFB82C,ZTEGD970F8A3$ZTE3ANNR7B31796,3891484BD5DF,3891484BD5E0,ZTEGDB080D94$ZTE3ANNR7B32314,3891484BE203,3891484BE204,ZTEGDB080F9A$ZTE3ANNQCA02866,14CA56D28807,14CA56D28808,ZTEGD971709D$ZTE3ANNQ7104022,C4EBFF8A26AC,C4EBFF8A26AD,ZTEGD70A2C88$ZTE3ANNRAD22101,D89A0DAFE061,D89A0DAFE062,ZTEGDB175260$ZTE3ANNQ8F09377,689E29FCFEA3,689E29FCFEA4,ZTEGD7BA2171$ZTE3ANNR8C36316,38914851DA2F,38914851DA30,ZTEGDB090E4C$ZTE3ANNRC501188,6C11BA6245AF,6C11BA6245B0,ZTEGDC6E1A63$ZTE3ANNT3H45683,D831399AF24A,D831399AF24B,ZTEGDD328312$ZTE3ANNQ3621170,3CF9F0A6C59A,3CF9F0A6C59B,ZTEGD640B64D$ZTE3ANNRCP46282,6C11BA6D678B,6C11BA6D678C,ZTEGDC6FF55D$ZTE3ANNQ3R00355,3CF9F0A28818,3CF9F0A28819,ZTEGD6400162$ZTE3ANNRB716825,5872C98FC387,5872C98FC388,ZTEGDC616C8C$ZTE3ANNQ3R00275,3CF9F0A28638,3CF9F0A28639,ZTEGD6400112$ZTE3ANNQ9J32083,843C992EC127,843C992EC128,ZTEGD7BB85FE$ZTE3ANNRAD22809,D89A0DAFF0F9,D89A0DAFF0FA,ZTEGDB175524$ZTE3ANNRCP03462,6C11BA697BF3,6C11BA697BF4,ZTEGDC6F4E19$ZTE3ANNR6R52825,48D6823A5AD8,48D6823A5AD9,ZTEGDB01F92C$ZTE3ANNRCB19333,D831391F941C,D831391F941D,ZTEGDD2A011A$ZTE3ANNQ3R00408,3CF9F0A28956,3CF9F0A28957,ZTEGD6400197$ZTE3ANNR8C35599,38914851C961,38914851C962,ZTEGDB090B7F$ZTE3ANNR2Q00900,F4E84F80C918,F4E84F80C919,ZTEGD97A763E', '',0323,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-23 11:27:28 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (269617, 450, '2102313BFARYM6900859,20AB48C2326E,4857544342EC15A6,20AB48C23271BFARYN7902061,ECA1D1F2E8B1,48575443A68FEBAA,ECA1D1F2E8B4BFARYN7902911,ECA1D1F326FB,48575443A69395AA,ECA1D1F326FEBFARYM6920740,B0761B174FEA,485754436AFEFEA6,B0761B174FEDBFARYMA907210,CCB182BEEED7,48575443858E03A7,CCB182BEEEDABFARYMA900990,CCB1827E71B7,48575443807A2CA7,CCB1827E71BABFARYN2918750,88892FFDD097,48575443EB8477A8,88892FFDD09ABFARYN2905372,88892F877054,48575443E52C06A8,88892F877057BFARYMA955415,C40D96B29DD0,48575443E33FEBA7,C40D96B29DD3BFARYMA944200,C40D969D1539,48575443E11C8AA7,C40D969D153CBFARYM6908781,CCD73C7521A7,48575443635DCCA6,CCD73C7521AABFARYM9910452,C0F6C2705BD8,48575443257337A7,C0F6C2705BDBBFARYM6905149,20AB48B97D18,48575443431E75A6,20AB48B97D1BBFARYM9909107,C0F6C26FC86C,485754432569B9A7,C0F6C26FC86FBFARYN5915134,14AB0227B35E,485754436A651DAA,14AB0227B361BFARYN5906752,B0ECDD4B418C,485754435CF9F2AA,B0ECDD4B418FBFARYN2924564,88892FFF03C9,48575443EB968FA8,88892FFF03CCBFARYM7900349,F09BB8C40C11,485754437D5D2BA6,F09BB8C40C14BFARYM6935477,F09BB855A7F4,4857544377589CA6,F09BB855A7F7BFARYM8902060,1C3D2F46DD5F,48575443D52F7CA6,1C3D2F46DD62BFARYN2935666,A4178B02B81E,48575443EBBF16A8,A4178B02B821BFARYN2920664,88892FFE25DB,48575443EB8981A8,88892FFE25DEBFARYMA948562,C40D96A9238E,48575443E28FB4A7,C40D96A92391BFARYM4903315,80E1BFFAC241,48575443C3D3E7A5,80E1BFFAC244BFARYN2907542,88892F88BBD4,48575443E53F98A8,88892F88BBD7BFARYN2913637,88892F8A4736,48575443E556DEA8,88892F8A4739BFARYN7902290,ECA1D1F3064F,48575443A691A9AA,ECA1D1F30652BFARYN1915729,C4FBAAFB801E,48575443D3D641A8,C4FBAAFB8021BFARYM8957710,2868D21782A3,48575443FAA2A5A6,2868D21782A6BFARYMA903894,CCB1827F751C,4857544380FBC8A7,CCB1827F751FBFARYM8909425,1C3D2F467264,48575443D5291CA6,1C3D2F467267BFARYM8900082,1C3D2F464775,48575443D52693A6,1C3D2F464778BFARYM6903423,20AB48B91C9E,485754434317FCA6,20AB48B91CA1BFARYN2904275,88892F86E414,48575443E523C6A8,88892F86E417BFARYM9908230,C0F6C2705A51,4857544325731EA7,C0F6C2705A54BFARYN2914668,88892F89655D,48575443E54993A8,88892F896560BFARYM6903439,20AB48B9261D,4857544343189CA6,20AB48B92620BFARYN2904394,88892F877907,48575443E52C89A8,88892F87790A', '',0189,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-07-23 11:45:09 Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000286296;-
DROP TABLE IF EXISTS temp0000286296;
Date: 2026-07-23 15:47:47 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000286296;
Date: 2026-07-23 14:37:47 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000286296;
Date: 2026-07-23 14:22:46 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 1s888ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48156, 418, '2102312JCYRYK9015962,D0C65B26A7DB,485754438BFC0A9F', '',0147,00,'[{"item":"0","qrcode":""}]','', '', 00);[ Date: 2026-07-23 14:45:03 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
2 1s1ms DROP TABLE IF EXISTS temp0000286296;[ Date: 2026-07-23 15:47:47 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,015 Total read queries
- 1,553 Total write queries
Queries by database
Key values
- rio Main database
- 3,994 Requests
- 5h41m4s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 5,897 Requests
User Request type Count Duration etiquetas Total 40 7s744ms select 40 7s744ms intelifix Total 5,897 7h51m8s copy to 419 48m45s ddl 1,134 47m54s others 485 37m45s select 3,857 5h36m42s lenon Total 118 1m41s select 118 1m41s Duration by user
Key values
- 7h51m8s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 40 7s744ms select 40 7s744ms intelifix Total 5,897 7h51m8s copy to 419 48m45s ddl 1,134 47m54s others 485 37m45s select 3,857 5h36m42s lenon Total 118 1m41s select 118 1m41s Queries by host
Key values
- [local] Main host
- 6,055 Requests
- 7h52m57s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,911 Requests
- 4h51s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-23 09:53:05 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,144 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-23 11:14:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m54s analyze verbose;[ Date: 2026-07-23 05:08:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-23 15:13:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-23 09:13:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 7m57s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-23 07:12:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 7m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-23 16:12:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 7m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-23 10:12:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 7m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-23 20:12:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 7m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-23 12:12:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-23 08:12:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-23 14:11:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-23 17:11:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m39s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027450, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-23 09:36:06 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 6m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-23 21:11:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 6m9s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027463, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-23 11:19:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 6m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-23 13:11:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-23 22:10:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m39s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027449, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-23 09:00:32 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 5m36s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027481, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-23 14:28:53 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-23 18:10:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h1m30s 48 1s263ms 9m42s 2m31s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 23 07 3 8m35s 2m51s 08 3 7m33s 2m31s 09 3 8m57s 2m59s 10 3 8m24s 2m48s 11 3 10m16s 3m25s 12 3 7m43s 2m34s 13 3 6m23s 2m7s 14 3 7m16s 2m25s 15 3 8m43s 2m54s 16 3 8m29s 2m49s 17 3 7m10s 2m23s 18 3 5m50s 1m56s 19 3 5m46s 1m55s 20 3 7m44s 2m34s 21 3 6m30s 2m10s 22 3 6m3s 2m1s [ User: intelifix - Total duration: 2h1m30s - Times executed: 48 ]
[ Application: psql - Total duration: 2h1m30s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-23 11:14:44 Duration: 9m42s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-23 15:13:21 Duration: 8m19s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-23 09:13:07 Duration: 8m6s Database: rio User: intelifix Remote: [local] Application: psql
2 1h26m41s 331 150ms 6m39s 15s713ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 23 07 13 10m24s 48s33ms 08 54 1m2s 1s153ms 09 21 13m58s 39s919ms 10 23 8m19s 21s735ms 11 29 8m55s 18s453ms 12 15 1m5s 4s335ms 13 29 20s529ms 707ms 14 38 15m44s 24s852ms 15 44 12m3s 16s435ms 16 30 8m20s 16s668ms 17 35 6m27s 11s80ms [ User: intelifix - Total duration: 1h26m41s - Times executed: 331 ]
[ Application: [unknown] - Total duration: 1h26m41s - Times executed: 331 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027450, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-23 09:36:06 Duration: 6m39s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027463, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-23 11:19:44 Duration: 6m9s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027449, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-23 09:00:32 Duration: 5m39s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h15m45s 47 248ms 5m28s 1m36s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 23 07 3 5m15s 1m45s 08 3 4m39s 1m33s 09 2 5m56s 2m58s 10 3 5m8s 1m42s 11 3 6m26s 2m8s 12 3 4m31s 1m30s 13 3 4m14s 1m24s 14 3 4m45s 1m35s 15 3 5m23s 1m47s 16 3 5m1s 1m40s 17 3 4m10s 1m23s 18 3 3m36s 1m12s 19 3 3m52s 1m17s 20 3 4m45s 1m35s 21 3 4m2s 1m20s 22 3 3m55s 1m18s [ User: intelifix - Total duration: 1h15m45s - Times executed: 47 ]
[ Application: psql - Total duration: 1h15m45s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-23 11:21:40 Duration: 5m28s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-23 09:19:47 Duration: 4m53s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-23 15:19:05 Duration: 4m33s Database: brasilia User: intelifix Remote: [local] Application: psql
4 16m46s 1,192 150ms 5s44ms 844ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 23 07 43 37s630ms 875ms 08 100 1m16s 767ms 09 124 1m32s 746ms 10 118 1m54s 972ms 11 138 2m26s 1s64ms 12 59 44s521ms 754ms 13 112 1m27s 783ms 14 185 2m33s 828ms 15 191 2m29s 783ms 16 90 1m21s 911ms 17 32 20s838ms 651ms [ User: intelifix - Total duration: 16m46s - Times executed: 1192 ]
[ Application: [unknown] - Total duration: 16m46s - Times executed: 1192 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (269622, 450, 'CP2409325YU,08C7F52C22ED,544D4242007818B2,08C7F52C22F0$CP234532WDM,08C7F5065F28,544D42420073B35D,08C7F5065F2B$CP2407320ET,08C7F5293AEE,544D42420077CED7,08C7F5293AF1$CP232532C1F,D4925ECC7533,544D4242006D4691,D4925ECC7536$CP23453248P,08C7F5027603,544D424200734420,08C7F5027606$CP2303327YS,D4925E14C624,544D42420062D515,D4925E14C627$CP2303326HQ,D4925E148F82,544D42420062CF03,D4925E148F85$CP230332802,D4925E14C7A7,544D42420062D540,D4925E14C7AA$CP2407328RC,08C7F52A7972,544D42420077F23B,08C7F52A7975$CP2303327EY,D4925E14B28F,544D42420062D2E8,D4925E14B292$CP234232R6M,D4925EF93C9C,544D424200724C79,D4925EF93C9F$CP23433242F,D4925EFEDE8D,544D42420072BA9A,D4925EFEDE90$CP240432NVM,08C7F52859A1,544D4242007777EA,08C7F52859A4$CP2319322JD,D4925E9FE6A4,544D42420069938E,D4925E9FE6A7$CP2345323FM,08C7F50257C7,544D4242007340C4,08C7F50257CA$CP2317324L7,D4925E950EF7,544D424200682C61,D4925E950EFA$CP234232PR4,D4925EF9057C,544D424200724659,D4925EF9057F$CP240332CKK,08C7F522B057,544D42420076D6E4,08C7F522B05A$CP23463208F,08C7F506D609,544D42420073B7E4,08C7F506D60C$CP2409325GJ,08C7F52C112C,544D4242007816B9,08C7F52C112F$CP232532CT0,D4925ECC92D6,544D4242006D49DC,D4925ECC92D9$CP234232NG5,D4925EF8D4DD,544D4242007240F2,D4925EF8D4E0$CP23103220B,D4925E33B9D1,544D42420065B863,D4925E33B9D4$CP230232GR2,D4925E08A26C,544D42420061DD51,D4925E08A26F$CP2301329KU,D4925E02D29C,544D4242006138BB,D4925E02D29F$CP24093225L,08C7F52B91A0,544D42420078088D,08C7F52B91A3$CP2322320DR,D4925EB2E584,544D4242006B8D84,D4925EB2E587$CP2305325S6,D4925E19680E,544D424200638FF9,D4925E196811$CP230232EDY,D4925E0848F3,544D42420061D360,D4925E0848F6$CP2407328Y1,08C7F52A8005,544D42420077F2F6,08C7F52A8008$CP230132FWV,D4925E03C51E,544D4242006153AD,D4925E03C521$CP22413219B,A0B53CC26B86,544D4242005E958D,A0B53CC26B89$CP230232FKE,D4925E0875BD,544D42420061D85A,D4925E0875C0$CP24093232V,08C7F52BB4BF,544D424200780C74,08C7F52BB4C2$CP23013233P,D4925E01DA3B,544D424200611D22,D4925E01DA3E$CP2239324LU,A0B53CC0C8D3,544D4242005E80B8,A0B53CC0C8D6$CP232232DFN,D4925EBD727D,544D4242006BC510,D4925EBD7280$CP2317324ZL,D4925E951D58,544D424200682DFA,D4925E951D5B$CP2319327A2,D4925EA09C81,544D42420069A7C3,D4925EA09C84$CP2319321SC,D4925E9FC9E2,544D42420069905C,D4925E9FC9E5', '',0298,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-07-23 11:03:07 Duration: 5s44ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48123, 417, 'ZTE3ANNRCB22309,D831391FD9DC,D831391FD9DD,ZTEGDD2A0CBA$ZTE3ANNR2Q33441,F4E84F83C3C6,F4E84F83C3C7,ZTEGD97AF55B$ZTE3ANNR3Y35325,4896D952FCA6,4896D952FCA7,ZTEGD97EBAB2$ZTE3ANNR1Y33352,14CA56CFB82B,14CA56CFB82C,ZTEGD970F8A3$ZTE3ANNR7B31796,3891484BD5DF,3891484BD5E0,ZTEGDB080D94$ZTE3ANNR7B32314,3891484BE203,3891484BE204,ZTEGDB080F9A$ZTE3ANNQCA02866,14CA56D28807,14CA56D28808,ZTEGD971709D$ZTE3ANNQ7104022,C4EBFF8A26AC,C4EBFF8A26AD,ZTEGD70A2C88$ZTE3ANNRAD22101,D89A0DAFE061,D89A0DAFE062,ZTEGDB175260$ZTE3ANNQ8F09377,689E29FCFEA3,689E29FCFEA4,ZTEGD7BA2171$ZTE3ANNR8C36316,38914851DA2F,38914851DA30,ZTEGDB090E4C$ZTE3ANNRC501188,6C11BA6245AF,6C11BA6245B0,ZTEGDC6E1A63$ZTE3ANNT3H45683,D831399AF24A,D831399AF24B,ZTEGDD328312$ZTE3ANNQ3621170,3CF9F0A6C59A,3CF9F0A6C59B,ZTEGD640B64D$ZTE3ANNRCP46282,6C11BA6D678B,6C11BA6D678C,ZTEGDC6FF55D$ZTE3ANNQ3R00355,3CF9F0A28818,3CF9F0A28819,ZTEGD6400162$ZTE3ANNRB716825,5872C98FC387,5872C98FC388,ZTEGDC616C8C$ZTE3ANNQ3R00275,3CF9F0A28638,3CF9F0A28639,ZTEGD6400112$ZTE3ANNQ9J32083,843C992EC127,843C992EC128,ZTEGD7BB85FE$ZTE3ANNRAD22809,D89A0DAFF0F9,D89A0DAFF0FA,ZTEGDB175524$ZTE3ANNRCP03462,6C11BA697BF3,6C11BA697BF4,ZTEGDC6F4E19$ZTE3ANNR6R52825,48D6823A5AD8,48D6823A5AD9,ZTEGDB01F92C$ZTE3ANNRCB19333,D831391F941C,D831391F941D,ZTEGDD2A011A$ZTE3ANNQ3R00408,3CF9F0A28956,3CF9F0A28957,ZTEGD6400197$ZTE3ANNR8C35599,38914851C961,38914851C962,ZTEGDB090B7F$ZTE3ANNR2Q00900,F4E84F80C918,F4E84F80C919,ZTEGD97A763E', '',0323,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-23 11:27:28 Duration: 4s572ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (269617, 450, '2102313BFARYM6900859,20AB48C2326E,4857544342EC15A6,20AB48C23271BFARYN7902061,ECA1D1F2E8B1,48575443A68FEBAA,ECA1D1F2E8B4BFARYN7902911,ECA1D1F326FB,48575443A69395AA,ECA1D1F326FEBFARYM6920740,B0761B174FEA,485754436AFEFEA6,B0761B174FEDBFARYMA907210,CCB182BEEED7,48575443858E03A7,CCB182BEEEDABFARYMA900990,CCB1827E71B7,48575443807A2CA7,CCB1827E71BABFARYN2918750,88892FFDD097,48575443EB8477A8,88892FFDD09ABFARYN2905372,88892F877054,48575443E52C06A8,88892F877057BFARYMA955415,C40D96B29DD0,48575443E33FEBA7,C40D96B29DD3BFARYMA944200,C40D969D1539,48575443E11C8AA7,C40D969D153CBFARYM6908781,CCD73C7521A7,48575443635DCCA6,CCD73C7521AABFARYM9910452,C0F6C2705BD8,48575443257337A7,C0F6C2705BDBBFARYM6905149,20AB48B97D18,48575443431E75A6,20AB48B97D1BBFARYM9909107,C0F6C26FC86C,485754432569B9A7,C0F6C26FC86FBFARYN5915134,14AB0227B35E,485754436A651DAA,14AB0227B361BFARYN5906752,B0ECDD4B418C,485754435CF9F2AA,B0ECDD4B418FBFARYN2924564,88892FFF03C9,48575443EB968FA8,88892FFF03CCBFARYM7900349,F09BB8C40C11,485754437D5D2BA6,F09BB8C40C14BFARYM6935477,F09BB855A7F4,4857544377589CA6,F09BB855A7F7BFARYM8902060,1C3D2F46DD5F,48575443D52F7CA6,1C3D2F46DD62BFARYN2935666,A4178B02B81E,48575443EBBF16A8,A4178B02B821BFARYN2920664,88892FFE25DB,48575443EB8981A8,88892FFE25DEBFARYMA948562,C40D96A9238E,48575443E28FB4A7,C40D96A92391BFARYM4903315,80E1BFFAC241,48575443C3D3E7A5,80E1BFFAC244BFARYN2907542,88892F88BBD4,48575443E53F98A8,88892F88BBD7BFARYN2913637,88892F8A4736,48575443E556DEA8,88892F8A4739BFARYN7902290,ECA1D1F3064F,48575443A691A9AA,ECA1D1F30652BFARYN1915729,C4FBAAFB801E,48575443D3D641A8,C4FBAAFB8021BFARYM8957710,2868D21782A3,48575443FAA2A5A6,2868D21782A6BFARYMA903894,CCB1827F751C,4857544380FBC8A7,CCB1827F751FBFARYM8909425,1C3D2F467264,48575443D5291CA6,1C3D2F467267BFARYM8900082,1C3D2F464775,48575443D52693A6,1C3D2F464778BFARYM6903423,20AB48B91C9E,485754434317FCA6,20AB48B91CA1BFARYN2904275,88892F86E414,48575443E523C6A8,88892F86E417BFARYM9908230,C0F6C2705A51,4857544325731EA7,C0F6C2705A54BFARYN2914668,88892F89655D,48575443E54993A8,88892F896560BFARYM6903439,20AB48B9261D,4857544343189CA6,20AB48B92620BFARYN2904394,88892F877907,48575443E52C89A8,88892F87790A', '',0189,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-07-23 11:45:09 Duration: 4s205ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 15m41s 69 1s629ms 44s7ms 13s648ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 23 06 3 17s586ms 5s862ms 07 2 9s363ms 4s681ms 08 1 44s7ms 44s7ms 09 3 38s733ms 12s911ms 10 6 1m45s 17s620ms 11 10 2m55s 17s534ms 13 1 21s805ms 21s805ms 14 7 1m37s 13s968ms 15 20 3m16s 9s841ms 16 8 2m19s 17s404ms 17 8 1m35s 11s920ms [ User: intelifix - Total duration: 15m41s - Times executed: 69 ]
[ Application: [unknown] - Total duration: 15m41s - Times executed: 69 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-23', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-23 08:46:36 Duration: 44s7ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-23', 0320, '', '', 0, 6, '2026-07-01');
Date: 2026-07-23 10:25:47 Duration: 35s630ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-23', 0320, '', '', 0, 6, '2026-07-01');
Date: 2026-07-23 11:32:06 Duration: 32s699ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 15m36s 3 2m27s 8m54s 5m12s analyze verbose;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 23 05 3 15m36s 5m12s [ User: intelifix - Total duration: 15m36s - Times executed: 3 ]
[ Application: psql - Total duration: 15m36s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-23 05:08:56 Duration: 8m54s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-23 05:13:10 Duration: 4m13s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-23 05:15:38 Duration: 2m27s Database: contagem User: intelifix Remote: [local] Application: psql
7 8m19s 272 162ms 9s37ms 1s836ms call rs_giga_triagem (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 23 00 12 26s257ms 2s188ms 01 12 19s111ms 1s592ms 02 12 21s200ms 1s766ms 03 10 14s470ms 1s447ms 04 12 17s508ms 1s459ms 05 12 20s354ms 1s696ms 06 12 19s382ms 1s615ms 07 11 19s804ms 1s800ms 08 12 21s782ms 1s815ms 09 12 24s583ms 2s48ms 10 12 19s578ms 1s631ms 11 12 28s898ms 2s408ms 12 12 20s378ms 1s698ms 13 12 22s39ms 1s836ms 14 12 23s559ms 1s963ms 15 12 23s136ms 1s928ms 16 12 23s729ms 1s977ms 17 12 21s759ms 1s813ms 18 12 18s982ms 1s581ms 19 11 20s886ms 1s898ms 20 12 31s600ms 2s633ms 21 12 19s787ms 1s648ms 22 12 20s825ms 1s735ms [ User: intelifix - Total duration: 8m19s - Times executed: 272 ]
[ Application: psql - Total duration: 8m19s - Times executed: 272 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-23 00:05:21 Duration: 9s37ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-23 20:15:09 Duration: 7s936ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-23 20:05:08 Duration: 7s121ms Database: rio User: intelifix Remote: [local] Application: psql
8 8m11s 993 150ms 6s689ms 495ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 23 07 27 17s591ms 651ms 08 134 1m6s 499ms 09 168 1m14s 440ms 10 145 1m15s 517ms 11 117 1m13s 630ms 12 3 1s834ms 611ms 13 90 43s589ms 484ms 14 131 50s721ms 387ms 15 98 43s937ms 448ms 16 79 43s804ms 554ms 17 1 563ms 563ms [ User: intelifix - Total duration: 8m11s - Times executed: 993 ]
[ Application: [unknown] - Total duration: 8m11s - Times executed: 993 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243120", "modelo" : "155", "itens" : "64FD966C58AC,D833B7318177,94988F9473F6,64FD966C492B,94988F95A66E,64FD96556266,64FD9656645C", "usuario" : "414", "caixa" : "2914525", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-23 11:31:40 Duration: 6s689ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "270193", "modelo" : "464", "itens" : "241761587885,241767582130,241744924262,241764634962,241779244850,241764516061,241778989315,241777662833,241760180813,241742604765,241779101728,241813171428,241814105772,241768658687,241767399710,241768772336,241760177680,241779082837,241767832738,241778870011,241778774445,241744203653,241768011117,241776850521,241759901313,241745487279,241745908588,241767407791,241771339814,241760058499,241745706874,241770520509,241743295674,241739559002,241742841635,241739441617,241744200421,241746657281,241771254856,241746638693,241765416082,241764422338,241762511422,241762563043,241771182223,241765608806,241777485767,241778614957,241742963442,241775273857,241772335051,241767718911,241746138386,241767399508,241747537681,241744866781,241777658690,241778869202,241778983759,241760168891", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-23 11:43:55 Duration: 2s420ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "270218", "modelo" : "464", "itens" : "241768808197,241745550317,241773830114,241762793548,241744171327,241771165678,241768082437,241742284352,241763980623,241763976682,241775325859,241778941331,241762323951,241740651320,241772663546,241767948709,241778593743,241762348094,241777832244,241765425454,241744188095,241743248699,241771358098,241747665270,241745558094,241777740720,241771355876,241742135673,241768826583,241770027979,241744330916,241739566275,241746011428,241814111632,241744013556,241778896174,241761433146,241764813543,241770060206,241764106066,241767939112,241762525362,241772404957,241779343951,241768971828,241768876262,241778861020,241745806581,241773841933,241773869511,863400605703063,241759734450", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-23 13:20:37 Duration: 2s250ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 8m9s 40 9s835ms 15s463ms 12s241ms create table temp0000286222 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 23 07 17 3m12s 11s314ms 08 14 2m55s 12s504ms 09 3 39s908ms 13s302ms 10 3 38s686ms 12s895ms 11 3 43s640ms 14s546ms [ User: intelifix - Total duration: 8m9s - Times executed: 40 ]
[ Application: [unknown] - Total duration: 8m9s - Times executed: 40 ]
-
CREATE TABLE temp0000286222 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 10:39:32 Duration: 15s463ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286222 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 11:13:30 Duration: 14s850ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286222 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 11:13:13 Duration: 14s771ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 7m47s 38 9s617ms 35s207ms 12s297ms create table temp0000286296 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 23 14 20 3m56s 11s824ms 15 10 2m21s 14s149ms 16 8 1m29s 11s165ms [ User: intelifix - Total duration: 7m47s - Times executed: 38 ]
[ Application: [unknown] - Total duration: 7m47s - Times executed: 38 ]
-
CREATE TABLE temp0000286296 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 15:18:19 Duration: 35s207ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286296 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 14:21:14 Duration: 14s850ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286296 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 14:22:29 Duration: 13s375ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 7m7s 153 165ms 11s210ms 2s795ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 23 00 6 18s492ms 3s82ms 01 6 7s942ms 1s323ms 02 5 8s53ms 1s610ms 03 5 8s9ms 1s601ms 04 6 8s304ms 1s384ms 05 4 7s799ms 1s949ms 06 3 3s647ms 1s215ms 07 10 30s264ms 3s26ms 08 12 46s636ms 3s886ms 09 12 42s220ms 3s518ms 10 12 36s281ms 3s23ms 11 12 51s263ms 4s271ms 12 7 31s875ms 4s553ms 13 4 3s797ms 949ms 14 10 35s220ms 3s522ms 15 12 38s6ms 3s167ms 16 10 26s768ms 2s676ms 17 5 4s61ms 812ms 20 1 235ms 235ms 21 5 9s405ms 1s881ms 22 6 9s468ms 1s578ms [ User: intelifix - Total duration: 7m7s - Times executed: 153 ]
[ Application: psql - Total duration: 7m7s - Times executed: 153 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-23 00:05:12 Duration: 11s210ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-23 11:25:10 Duration: 9s137ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-23 10:15:09 Duration: 8s7ms Database: rio User: intelifix Remote: [local] Application: psql
12 6m39s 32 9s992ms 16s339ms 12s475ms create table temp0000286248 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 23 08 3 35s264ms 11s754ms 09 2 24s747ms 12s373ms 10 18 3m31s 11s741ms 11 9 2m7s 14s205ms [ User: intelifix - Total duration: 6m39s - Times executed: 32 ]
[ Application: [unknown] - Total duration: 6m39s - Times executed: 32 ]
-
CREATE TABLE temp0000286248 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 11:24:39 Duration: 16s339ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286248 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 11:26:20 Duration: 15s692ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286248 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 11:12:53 Duration: 15s335ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 4m31s 23 10s100ms 13s542ms 11s806ms create table temp0000286274 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 23 13 9 1m43s 11s521ms 14 14 2m47s 11s989ms [ User: intelifix - Total duration: 4m31s - Times executed: 23 ]
[ Application: [unknown] - Total duration: 4m31s - Times executed: 23 ]
-
CREATE TABLE temp0000286274 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 14:21:24 Duration: 13s542ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286274 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 14:03:09 Duration: 13s451ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286274 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 14:07:11 Duration: 13s129ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 3m17s 4 4s561ms 1m34s 49s460ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 23 20 2 1m39s 49s550ms 23 2 1m38s 49s370ms [ User: intelifix - Total duration: 3m17s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m17s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-23 20:08:59 Duration: 1m34s 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-07-23 23:17:34 Duration: 1m33s 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-07-23 23:37:39 Duration: 5s215ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 2m13s 64 176ms 1m17s 2s93ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 23 07 6 3s390ms 565ms 08 6 4s410ms 735ms 09 2 6s251ms 3s125ms 10 9 17s433ms 1s937ms 11 5 5s281ms 1s56ms 12 1 1m17s 1m17s 13 4 940ms 235ms 14 16 5s300ms 331ms 15 5 3s434ms 686ms 16 4 3s329ms 832ms 17 6 7s93ms 1s182ms [ User: intelifix - Total duration: 2m13s - Times executed: 64 ]
[ Application: psql - Total duration: 2m13s - Times executed: 64 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027466);
Date: 2026-07-23 12:13:31 Duration: 1m17s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027460);
Date: 2026-07-23 10:51:29 Duration: 5s988ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027451);
Date: 2026-07-23 09:59:55 Duration: 5s731ms Database: rio User: intelifix Remote: [local] Application: psql
16 2m5s 31 756ms 11s875ms 4s63ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 23 08 3 9s306ms 3s102ms 09 1 4s665ms 4s665ms 10 3 22s704ms 7s568ms 11 2 13s619ms 6s809ms 12 3 15s10ms 5s3ms 13 3 16s122ms 5s374ms 14 2 12s504ms 6s252ms 15 1 6s757ms 6s757ms 16 2 14s49ms 7s24ms 17 2 2s151ms 1s75ms 18 2 2s366ms 1s183ms 19 2 2s191ms 1s95ms 20 2 1s575ms 787ms 21 1 1s83ms 1s83ms 22 2 1s852ms 926ms [ User: intelifix - Total duration: 2m5s - Times executed: 31 ]
[ Application: psql - Total duration: 2m5s - Times executed: 31 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-07-23 12:00:13 Duration: 11s875ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-07-23 13:40:12 Duration: 11s271ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-07-23 11:20:11 Duration: 9s808ms Database: rio User: intelifix Remote: [local] Application: psql
17 2m2s 4 426ms 1m4s 30s716ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 23 20 2 58s322ms 29s161ms 23 2 1m4s 32s271ms [ User: intelifix - Total duration: 2m2s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m2s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-23 23:13:59 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-23 20:05:37 Duration: 57s896ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-23 23:37:03 Duration: 451ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 1m48s 38 181ms 12s958ms 2s853ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 23 07 3 17s17ms 5s672ms 08 3 8s706ms 2s902ms 09 3 8s358ms 2s786ms 10 7 13s650ms 1s950ms 11 5 10s444ms 2s88ms 12 1 3s73ms 3s73ms 13 2 6s453ms 3s226ms 14 5 21s652ms 4s330ms 15 3 6s313ms 2s104ms 16 2 6s285ms 3s142ms 17 4 6s467ms 1s616ms [ User: intelifix - Total duration: 1m48s - Times executed: 38 ]
[ Application: psql - Total duration: 1m48s - Times executed: 38 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027439);
Date: 2026-07-23 07:16:47 Duration: 12s958ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027458);
Date: 2026-07-23 10:39:50 Duration: 9s958ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027463);
Date: 2026-07-23 11:13:08 Duration: 8s672ms Database: rio User: intelifix Remote: [local] Application: psql
19 1m45s 30 2s722ms 9s236ms 3s526ms create table temp0000286222 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 23 07 14 51s301ms 3s664ms 08 6 20s34ms 3s339ms 09 10 34s469ms 3s446ms [ User: intelifix - Total duration: 1m45s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 1m45s - Times executed: 30 ]
-
CREATE TABLE temp0000286222 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"18-07-2026", "ate" :"23-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-23 07:22:55 Duration: 9s236ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286222 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"18-07-2026", "ate" :"23-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-23 08:19:47 Duration: 4s501ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286222 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"18-07-2026", "ate" :"23-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-23 09:05:20 Duration: 3s989ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 1m39s 6 2s849ms 40s771ms 16s661ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 23 20 3 47s189ms 15s729ms 23 3 52s782ms 17s594ms [ User: intelifix - Total duration: 1m39s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m39s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-23 23:14:41 Duration: 40s771ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-23 20:06:13 Duration: 34s1ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-23 20:10:25 Duration: 10s337ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,192 16m46s 150ms 5s44ms 844ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 23 07 43 37s630ms 875ms 08 100 1m16s 767ms 09 124 1m32s 746ms 10 118 1m54s 972ms 11 138 2m26s 1s64ms 12 59 44s521ms 754ms 13 112 1m27s 783ms 14 185 2m33s 828ms 15 191 2m29s 783ms 16 90 1m21s 911ms 17 32 20s838ms 651ms [ User: intelifix - Total duration: 16m46s - Times executed: 1192 ]
[ Application: [unknown] - Total duration: 16m46s - Times executed: 1192 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (269622, 450, 'CP2409325YU,08C7F52C22ED,544D4242007818B2,08C7F52C22F0$CP234532WDM,08C7F5065F28,544D42420073B35D,08C7F5065F2B$CP2407320ET,08C7F5293AEE,544D42420077CED7,08C7F5293AF1$CP232532C1F,D4925ECC7533,544D4242006D4691,D4925ECC7536$CP23453248P,08C7F5027603,544D424200734420,08C7F5027606$CP2303327YS,D4925E14C624,544D42420062D515,D4925E14C627$CP2303326HQ,D4925E148F82,544D42420062CF03,D4925E148F85$CP230332802,D4925E14C7A7,544D42420062D540,D4925E14C7AA$CP2407328RC,08C7F52A7972,544D42420077F23B,08C7F52A7975$CP2303327EY,D4925E14B28F,544D42420062D2E8,D4925E14B292$CP234232R6M,D4925EF93C9C,544D424200724C79,D4925EF93C9F$CP23433242F,D4925EFEDE8D,544D42420072BA9A,D4925EFEDE90$CP240432NVM,08C7F52859A1,544D4242007777EA,08C7F52859A4$CP2319322JD,D4925E9FE6A4,544D42420069938E,D4925E9FE6A7$CP2345323FM,08C7F50257C7,544D4242007340C4,08C7F50257CA$CP2317324L7,D4925E950EF7,544D424200682C61,D4925E950EFA$CP234232PR4,D4925EF9057C,544D424200724659,D4925EF9057F$CP240332CKK,08C7F522B057,544D42420076D6E4,08C7F522B05A$CP23463208F,08C7F506D609,544D42420073B7E4,08C7F506D60C$CP2409325GJ,08C7F52C112C,544D4242007816B9,08C7F52C112F$CP232532CT0,D4925ECC92D6,544D4242006D49DC,D4925ECC92D9$CP234232NG5,D4925EF8D4DD,544D4242007240F2,D4925EF8D4E0$CP23103220B,D4925E33B9D1,544D42420065B863,D4925E33B9D4$CP230232GR2,D4925E08A26C,544D42420061DD51,D4925E08A26F$CP2301329KU,D4925E02D29C,544D4242006138BB,D4925E02D29F$CP24093225L,08C7F52B91A0,544D42420078088D,08C7F52B91A3$CP2322320DR,D4925EB2E584,544D4242006B8D84,D4925EB2E587$CP2305325S6,D4925E19680E,544D424200638FF9,D4925E196811$CP230232EDY,D4925E0848F3,544D42420061D360,D4925E0848F6$CP2407328Y1,08C7F52A8005,544D42420077F2F6,08C7F52A8008$CP230132FWV,D4925E03C51E,544D4242006153AD,D4925E03C521$CP22413219B,A0B53CC26B86,544D4242005E958D,A0B53CC26B89$CP230232FKE,D4925E0875BD,544D42420061D85A,D4925E0875C0$CP24093232V,08C7F52BB4BF,544D424200780C74,08C7F52BB4C2$CP23013233P,D4925E01DA3B,544D424200611D22,D4925E01DA3E$CP2239324LU,A0B53CC0C8D3,544D4242005E80B8,A0B53CC0C8D6$CP232232DFN,D4925EBD727D,544D4242006BC510,D4925EBD7280$CP2317324ZL,D4925E951D58,544D424200682DFA,D4925E951D5B$CP2319327A2,D4925EA09C81,544D42420069A7C3,D4925EA09C84$CP2319321SC,D4925E9FC9E2,544D42420069905C,D4925E9FC9E5', '',0298,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-07-23 11:03:07 Duration: 5s44ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48123, 417, 'ZTE3ANNRCB22309,D831391FD9DC,D831391FD9DD,ZTEGDD2A0CBA$ZTE3ANNR2Q33441,F4E84F83C3C6,F4E84F83C3C7,ZTEGD97AF55B$ZTE3ANNR3Y35325,4896D952FCA6,4896D952FCA7,ZTEGD97EBAB2$ZTE3ANNR1Y33352,14CA56CFB82B,14CA56CFB82C,ZTEGD970F8A3$ZTE3ANNR7B31796,3891484BD5DF,3891484BD5E0,ZTEGDB080D94$ZTE3ANNR7B32314,3891484BE203,3891484BE204,ZTEGDB080F9A$ZTE3ANNQCA02866,14CA56D28807,14CA56D28808,ZTEGD971709D$ZTE3ANNQ7104022,C4EBFF8A26AC,C4EBFF8A26AD,ZTEGD70A2C88$ZTE3ANNRAD22101,D89A0DAFE061,D89A0DAFE062,ZTEGDB175260$ZTE3ANNQ8F09377,689E29FCFEA3,689E29FCFEA4,ZTEGD7BA2171$ZTE3ANNR8C36316,38914851DA2F,38914851DA30,ZTEGDB090E4C$ZTE3ANNRC501188,6C11BA6245AF,6C11BA6245B0,ZTEGDC6E1A63$ZTE3ANNT3H45683,D831399AF24A,D831399AF24B,ZTEGDD328312$ZTE3ANNQ3621170,3CF9F0A6C59A,3CF9F0A6C59B,ZTEGD640B64D$ZTE3ANNRCP46282,6C11BA6D678B,6C11BA6D678C,ZTEGDC6FF55D$ZTE3ANNQ3R00355,3CF9F0A28818,3CF9F0A28819,ZTEGD6400162$ZTE3ANNRB716825,5872C98FC387,5872C98FC388,ZTEGDC616C8C$ZTE3ANNQ3R00275,3CF9F0A28638,3CF9F0A28639,ZTEGD6400112$ZTE3ANNQ9J32083,843C992EC127,843C992EC128,ZTEGD7BB85FE$ZTE3ANNRAD22809,D89A0DAFF0F9,D89A0DAFF0FA,ZTEGDB175524$ZTE3ANNRCP03462,6C11BA697BF3,6C11BA697BF4,ZTEGDC6F4E19$ZTE3ANNR6R52825,48D6823A5AD8,48D6823A5AD9,ZTEGDB01F92C$ZTE3ANNRCB19333,D831391F941C,D831391F941D,ZTEGDD2A011A$ZTE3ANNQ3R00408,3CF9F0A28956,3CF9F0A28957,ZTEGD6400197$ZTE3ANNR8C35599,38914851C961,38914851C962,ZTEGDB090B7F$ZTE3ANNR2Q00900,F4E84F80C918,F4E84F80C919,ZTEGD97A763E', '',0323,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-23 11:27:28 Duration: 4s572ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (269617, 450, '2102313BFARYM6900859,20AB48C2326E,4857544342EC15A6,20AB48C23271BFARYN7902061,ECA1D1F2E8B1,48575443A68FEBAA,ECA1D1F2E8B4BFARYN7902911,ECA1D1F326FB,48575443A69395AA,ECA1D1F326FEBFARYM6920740,B0761B174FEA,485754436AFEFEA6,B0761B174FEDBFARYMA907210,CCB182BEEED7,48575443858E03A7,CCB182BEEEDABFARYMA900990,CCB1827E71B7,48575443807A2CA7,CCB1827E71BABFARYN2918750,88892FFDD097,48575443EB8477A8,88892FFDD09ABFARYN2905372,88892F877054,48575443E52C06A8,88892F877057BFARYMA955415,C40D96B29DD0,48575443E33FEBA7,C40D96B29DD3BFARYMA944200,C40D969D1539,48575443E11C8AA7,C40D969D153CBFARYM6908781,CCD73C7521A7,48575443635DCCA6,CCD73C7521AABFARYM9910452,C0F6C2705BD8,48575443257337A7,C0F6C2705BDBBFARYM6905149,20AB48B97D18,48575443431E75A6,20AB48B97D1BBFARYM9909107,C0F6C26FC86C,485754432569B9A7,C0F6C26FC86FBFARYN5915134,14AB0227B35E,485754436A651DAA,14AB0227B361BFARYN5906752,B0ECDD4B418C,485754435CF9F2AA,B0ECDD4B418FBFARYN2924564,88892FFF03C9,48575443EB968FA8,88892FFF03CCBFARYM7900349,F09BB8C40C11,485754437D5D2BA6,F09BB8C40C14BFARYM6935477,F09BB855A7F4,4857544377589CA6,F09BB855A7F7BFARYM8902060,1C3D2F46DD5F,48575443D52F7CA6,1C3D2F46DD62BFARYN2935666,A4178B02B81E,48575443EBBF16A8,A4178B02B821BFARYN2920664,88892FFE25DB,48575443EB8981A8,88892FFE25DEBFARYMA948562,C40D96A9238E,48575443E28FB4A7,C40D96A92391BFARYM4903315,80E1BFFAC241,48575443C3D3E7A5,80E1BFFAC244BFARYN2907542,88892F88BBD4,48575443E53F98A8,88892F88BBD7BFARYN2913637,88892F8A4736,48575443E556DEA8,88892F8A4739BFARYN7902290,ECA1D1F3064F,48575443A691A9AA,ECA1D1F30652BFARYN1915729,C4FBAAFB801E,48575443D3D641A8,C4FBAAFB8021BFARYM8957710,2868D21782A3,48575443FAA2A5A6,2868D21782A6BFARYMA903894,CCB1827F751C,4857544380FBC8A7,CCB1827F751FBFARYM8909425,1C3D2F467264,48575443D5291CA6,1C3D2F467267BFARYM8900082,1C3D2F464775,48575443D52693A6,1C3D2F464778BFARYM6903423,20AB48B91C9E,485754434317FCA6,20AB48B91CA1BFARYN2904275,88892F86E414,48575443E523C6A8,88892F86E417BFARYM9908230,C0F6C2705A51,4857544325731EA7,C0F6C2705A54BFARYN2914668,88892F89655D,48575443E54993A8,88892F896560BFARYM6903439,20AB48B9261D,4857544343189CA6,20AB48B92620BFARYN2904394,88892F877907,48575443E52C89A8,88892F87790A', '',0189,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-07-23 11:45:09 Duration: 4s205ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 993 8m11s 150ms 6s689ms 495ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 23 07 27 17s591ms 651ms 08 134 1m6s 499ms 09 168 1m14s 440ms 10 145 1m15s 517ms 11 117 1m13s 630ms 12 3 1s834ms 611ms 13 90 43s589ms 484ms 14 131 50s721ms 387ms 15 98 43s937ms 448ms 16 79 43s804ms 554ms 17 1 563ms 563ms [ User: intelifix - Total duration: 8m11s - Times executed: 993 ]
[ Application: [unknown] - Total duration: 8m11s - Times executed: 993 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243120", "modelo" : "155", "itens" : "64FD966C58AC,D833B7318177,94988F9473F6,64FD966C492B,94988F95A66E,64FD96556266,64FD9656645C", "usuario" : "414", "caixa" : "2914525", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-23 11:31:40 Duration: 6s689ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "270193", "modelo" : "464", "itens" : "241761587885,241767582130,241744924262,241764634962,241779244850,241764516061,241778989315,241777662833,241760180813,241742604765,241779101728,241813171428,241814105772,241768658687,241767399710,241768772336,241760177680,241779082837,241767832738,241778870011,241778774445,241744203653,241768011117,241776850521,241759901313,241745487279,241745908588,241767407791,241771339814,241760058499,241745706874,241770520509,241743295674,241739559002,241742841635,241739441617,241744200421,241746657281,241771254856,241746638693,241765416082,241764422338,241762511422,241762563043,241771182223,241765608806,241777485767,241778614957,241742963442,241775273857,241772335051,241767718911,241746138386,241767399508,241747537681,241744866781,241777658690,241778869202,241778983759,241760168891", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-23 11:43:55 Duration: 2s420ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "270218", "modelo" : "464", "itens" : "241768808197,241745550317,241773830114,241762793548,241744171327,241771165678,241768082437,241742284352,241763980623,241763976682,241775325859,241778941331,241762323951,241740651320,241772663546,241767948709,241778593743,241762348094,241777832244,241765425454,241744188095,241743248699,241771358098,241747665270,241745558094,241777740720,241771355876,241742135673,241768826583,241770027979,241744330916,241739566275,241746011428,241814111632,241744013556,241778896174,241761433146,241764813543,241770060206,241764106066,241767939112,241762525362,241772404957,241779343951,241768971828,241768876262,241778861020,241745806581,241773841933,241773869511,863400605703063,241759734450", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-23 13:20:37 Duration: 2s250ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 331 1h26m41s 150ms 6m39s 15s713ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 23 07 13 10m24s 48s33ms 08 54 1m2s 1s153ms 09 21 13m58s 39s919ms 10 23 8m19s 21s735ms 11 29 8m55s 18s453ms 12 15 1m5s 4s335ms 13 29 20s529ms 707ms 14 38 15m44s 24s852ms 15 44 12m3s 16s435ms 16 30 8m20s 16s668ms 17 35 6m27s 11s80ms [ User: intelifix - Total duration: 1h26m41s - Times executed: 331 ]
[ Application: [unknown] - Total duration: 1h26m41s - Times executed: 331 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027450, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-23 09:36:06 Duration: 6m39s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027463, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-23 11:19:44 Duration: 6m9s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027449, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-23 09:00:32 Duration: 5m39s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 272 8m19s 162ms 9s37ms 1s836ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 23 00 12 26s257ms 2s188ms 01 12 19s111ms 1s592ms 02 12 21s200ms 1s766ms 03 10 14s470ms 1s447ms 04 12 17s508ms 1s459ms 05 12 20s354ms 1s696ms 06 12 19s382ms 1s615ms 07 11 19s804ms 1s800ms 08 12 21s782ms 1s815ms 09 12 24s583ms 2s48ms 10 12 19s578ms 1s631ms 11 12 28s898ms 2s408ms 12 12 20s378ms 1s698ms 13 12 22s39ms 1s836ms 14 12 23s559ms 1s963ms 15 12 23s136ms 1s928ms 16 12 23s729ms 1s977ms 17 12 21s759ms 1s813ms 18 12 18s982ms 1s581ms 19 11 20s886ms 1s898ms 20 12 31s600ms 2s633ms 21 12 19s787ms 1s648ms 22 12 20s825ms 1s735ms [ User: intelifix - Total duration: 8m19s - Times executed: 272 ]
[ Application: psql - Total duration: 8m19s - Times executed: 272 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-23 00:05:21 Duration: 9s37ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-23 20:15:09 Duration: 7s936ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-23 20:05:08 Duration: 7s121ms Database: rio User: intelifix Remote: [local] Application: psql
5 153 7m7s 165ms 11s210ms 2s795ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 23 00 6 18s492ms 3s82ms 01 6 7s942ms 1s323ms 02 5 8s53ms 1s610ms 03 5 8s9ms 1s601ms 04 6 8s304ms 1s384ms 05 4 7s799ms 1s949ms 06 3 3s647ms 1s215ms 07 10 30s264ms 3s26ms 08 12 46s636ms 3s886ms 09 12 42s220ms 3s518ms 10 12 36s281ms 3s23ms 11 12 51s263ms 4s271ms 12 7 31s875ms 4s553ms 13 4 3s797ms 949ms 14 10 35s220ms 3s522ms 15 12 38s6ms 3s167ms 16 10 26s768ms 2s676ms 17 5 4s61ms 812ms 20 1 235ms 235ms 21 5 9s405ms 1s881ms 22 6 9s468ms 1s578ms [ User: intelifix - Total duration: 7m7s - Times executed: 153 ]
[ Application: psql - Total duration: 7m7s - Times executed: 153 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-23 00:05:12 Duration: 11s210ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-23 11:25:10 Duration: 9s137ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-23 10:15:09 Duration: 8s7ms Database: rio User: intelifix Remote: [local] Application: psql
6 133 1m16s 152ms 2s710ms 572ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 23 07 7 2s944ms 420ms 08 33 14s591ms 442ms 10 2 1s548ms 774ms 11 2 3s974ms 1s987ms 12 6 12s311ms 2s51ms 13 22 13s214ms 600ms 14 23 12s190ms 530ms 15 17 6s626ms 389ms 16 8 3s193ms 399ms 17 13 5s562ms 427ms [ User: intelifix - Total duration: 1m16s - Times executed: 133 ]
[ Application: [unknown] - Total duration: 1m16s - Times executed: 133 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0129060) LIMIT 1;
Date: 2026-07-23 12:01:16 Duration: 2s710ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0128418) LIMIT 1;
Date: 2026-07-23 12:19:59 Duration: 2s237ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0128824) LIMIT 1;
Date: 2026-07-23 12:03:41 Duration: 2s102ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
7 131 27s809ms 150ms 424ms 212ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 23 00 1 274ms 274ms 01 6 1s116ms 186ms 03 3 747ms 249ms 05 3 589ms 196ms 07 8 1s385ms 173ms 08 7 1s431ms 204ms 09 11 2s540ms 230ms 10 21 4s851ms 231ms 11 15 3s350ms 223ms 12 4 841ms 210ms 13 3 820ms 273ms 14 14 2s712ms 193ms 15 22 4s254ms 193ms 16 12 2s567ms 213ms 17 1 326ms 326ms [ User: intelifix - Total duration: 27s809ms - Times executed: 131 ]
[ Application: [unknown] - Total duration: 27s809ms - Times executed: 131 ]
-
SELECT * FROM RS_TRIAGEM (373, 5, '70', 2, '216913078087,229738968889,229671053553,229815919105,229668251125,229751149191,229673574259,229748591839,229686342329,229785634668,229815011329', NULL, NULL, 0141, 00);
Date: 2026-07-23 10:06:48 Duration: 424ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (310, 5, '87', 2, '6802B8ACD6AC,B4F26733AB65,6802B8DB6FDA,6802B8F058BE,B4F26749D8A4,6802B864A0F7,6802B8F084D7,6802B8A3C5A9,B4F2674F4643,6802B8A3C735,B4F2670BD861,6802B8BE2CC9,6802B8A3AE84,6802B8CB4EC7,B4F2670BB224,6802B8E03C75,6802B8DB5930,6802B8A0F64B,6802B8DE9D1C,6802B823B245,6802B8ACDF64,6802B8A3D58A,6802B8CA2918,6802B8A3FF8D,B4F2670C2928,6802B8A23E26', NULL, NULL, 0156, 00);
Date: 2026-07-23 10:26:22 Duration: 402ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (373, 5, '70', 2, '229786362326,229728476878,229741423451,229780617780,216945409818,229865164360,229740257590,229736245762,229746827782,229670270817,229805388403,229924940621,216941869304,229780745369,229728598305,216938538181,229752724161,229671968097', NULL, NULL, 0141, 00);
Date: 2026-07-23 09:22:55 Duration: 383ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 112 50s609ms 303ms 804ms 451ms 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 Jul 23 00 1 507ms 507ms 01 2 1s39ms 519ms 03 2 866ms 433ms 04 1 328ms 328ms 05 3 1s323ms 441ms 06 2 796ms 398ms 07 8 3s224ms 403ms 08 10 4s494ms 449ms 09 9 3s997ms 444ms 10 7 3s395ms 485ms 11 11 5s994ms 544ms 12 7 2s738ms 391ms 13 10 3s811ms 381ms 14 11 5s404ms 491ms 15 7 3s320ms 474ms 16 7 3s226ms 460ms 17 8 3s309ms 413ms 18 1 383ms 383ms 20 1 402ms 402ms 21 2 1s192ms 596ms 22 1 394ms 394ms 23 1 458ms 458ms [ User: lenon - Total duration: 50s609ms - Times executed: 112 ]
[ Application: [unknown] - Total duration: 50s609ms - Times executed: 112 ]
-
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-07-23 11:08:35 Duration: 804ms 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-07-23 11:07:06 Duration: 761ms Database: rio 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-07-23 14:42:27 Duration: 666ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
9 108 44s637ms 254ms 956ms 413ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 23 07 4 1s810ms 452ms 08 7 2s802ms 400ms 09 8 3s531ms 441ms 10 17 6s986ms 410ms 11 12 5s468ms 455ms 12 4 1s649ms 412ms 13 6 2s440ms 406ms 14 11 4s560ms 414ms 15 18 7s687ms 427ms 16 9 3s552ms 394ms 17 12 4s147ms 345ms [ User: intelifix - Total duration: 44s637ms - Times executed: 108 ]
[ Application: [unknown] - Total duration: 44s637ms - Times executed: 108 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-23 15:16:46 Duration: 956ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-07-23 11:19:28 Duration: 683ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-23 14:38:48 Duration: 625ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 100 56s828ms 380ms 973ms 568ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 23 00 1 720ms 720ms 01 2 1s329ms 664ms 03 2 1s96ms 548ms 04 1 470ms 470ms 05 3 1s740ms 580ms 07 7 3s579ms 511ms 08 10 5s724ms 572ms 09 9 4s994ms 554ms 10 7 4s328ms 618ms 11 10 6s285ms 628ms 12 5 2s460ms 492ms 13 10 4s951ms 495ms 14 11 6s580ms 598ms 15 7 4s139ms 591ms 16 6 3s490ms 581ms 17 6 3s84ms 514ms 18 1 529ms 529ms 21 1 631ms 631ms 23 1 692ms 692ms [ User: intelifix - Total duration: 56s828ms - Times executed: 100 ]
[ Application: [unknown] - Total duration: 56s828ms - Times executed: 100 ]
-
select * from rs_menu_grants (418, 18, 1);
Date: 2026-07-23 11:08:35 Duration: 973ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (401, 72, 1);
Date: 2026-07-23 14:42:27 Duration: 860ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (366, 62, 1);
Date: 2026-07-23 10:06:11 Duration: 775ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 94 20s426ms 150ms 368ms 217ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 23 07 7 1s833ms 261ms 08 4 1s43ms 260ms 09 8 1s880ms 235ms 10 4 950ms 237ms 11 19 3s647ms 191ms 13 11 2s158ms 196ms 14 19 3s719ms 195ms 15 15 3s423ms 228ms 16 6 1s418ms 236ms 17 1 350ms 350ms [ User: intelifix - Total duration: 20s426ms - Times executed: 94 ]
[ Application: [unknown] - Total duration: 20s426ms - Times executed: 94 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"299", "usuario" :"184", "tipo" :"N", "itens" :"01", "nota-fiscal" :"6969", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-07-23 14:00:11 Duration: 368ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"313", "usuario" :"507", "tipo" :"N", "itens" :"002", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-07-23 07:23:02 Duration: 363ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"298", "usuario" :"184", "tipo" :"N", "itens" :"01", "nota-fiscal" :"6969", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-07-23 17:12:31 Duration: 350ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 77 14s474ms 150ms 353ms 187ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 23 00 1 150ms 150ms 08 2 540ms 270ms 09 2 642ms 321ms 10 2 324ms 162ms 11 6 1s68ms 178ms 13 1 152ms 152ms 14 7 1s349ms 192ms 15 24 4s362ms 181ms 16 20 3s592ms 179ms 17 12 2s290ms 190ms [ User: intelifix - Total duration: 14s474ms - Times executed: 77 ]
[ Application: [unknown] - Total duration: 14s474ms - Times executed: 77 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "383", "data-de" : "2026-07-01", "data-ate" : "2026-07-23", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 437 }');
Date: 2026-07-23 09:48:52 Duration: 353ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "432", "data-de" : "2026-07-22", "data-ate" : "2026-07-22", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 503 }');
Date: 2026-07-23 08:00:31 Duration: 338ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "383", "data-de" : "2026-07-20", "data-ate" : "2026-07-23", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 437 }');
Date: 2026-07-23 09:48:34 Duration: 289ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 69 15m41s 1s629ms 44s7ms 13s648ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 23 06 3 17s586ms 5s862ms 07 2 9s363ms 4s681ms 08 1 44s7ms 44s7ms 09 3 38s733ms 12s911ms 10 6 1m45s 17s620ms 11 10 2m55s 17s534ms 13 1 21s805ms 21s805ms 14 7 1m37s 13s968ms 15 20 3m16s 9s841ms 16 8 2m19s 17s404ms 17 8 1m35s 11s920ms [ User: intelifix - Total duration: 15m41s - Times executed: 69 ]
[ Application: [unknown] - Total duration: 15m41s - Times executed: 69 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-23', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-23 08:46:36 Duration: 44s7ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-23', 0320, '', '', 0, 6, '2026-07-01');
Date: 2026-07-23 10:25:47 Duration: 35s630ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-23', 0320, '', '', 0, 6, '2026-07-01');
Date: 2026-07-23 11:32:06 Duration: 32s699ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 68 10s979ms 150ms 204ms 161ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 23 03 2 307ms 153ms 07 1 166ms 166ms 08 5 809ms 161ms 09 10 1s588ms 158ms 10 9 1s418ms 157ms 11 25 4s51ms 162ms 12 2 377ms 188ms 13 4 662ms 165ms 14 5 796ms 159ms 15 4 640ms 160ms 17 1 159ms 159ms [ User: intelifix - Total duration: 10s979ms - Times executed: 68 ]
[ Application: [unknown] - Total duration: 10s979ms - Times executed: 68 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0153;
Date: 2026-07-23 11:20:15 Duration: 204ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0134;
Date: 2026-07-23 12:42:39 Duration: 193ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0145;
Date: 2026-07-23 12:33:44 Duration: 184ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 64 2m13s 176ms 1m17s 2s93ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 23 07 6 3s390ms 565ms 08 6 4s410ms 735ms 09 2 6s251ms 3s125ms 10 9 17s433ms 1s937ms 11 5 5s281ms 1s56ms 12 1 1m17s 1m17s 13 4 940ms 235ms 14 16 5s300ms 331ms 15 5 3s434ms 686ms 16 4 3s329ms 832ms 17 6 7s93ms 1s182ms [ User: intelifix - Total duration: 2m13s - Times executed: 64 ]
[ Application: psql - Total duration: 2m13s - Times executed: 64 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027466);
Date: 2026-07-23 12:13:31 Duration: 1m17s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027460);
Date: 2026-07-23 10:51:29 Duration: 5s988ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027451);
Date: 2026-07-23 09:59:55 Duration: 5s731ms Database: rio User: intelifix Remote: [local] Application: psql
16 52 17s258ms 151ms 575ms 331ms create table temp0000286116 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 23 08 2 615ms 307ms 09 3 749ms 249ms 10 4 1s198ms 299ms 11 4 1s331ms 332ms 12 5 1s378ms 275ms 13 6 1s957ms 326ms 14 4 1s560ms 390ms 15 11 4s355ms 395ms 16 9 3s483ms 387ms 17 4 628ms 157ms [ User: intelifix - Total duration: 17s258ms - Times executed: 52 ]
[ Application: [unknown] - Total duration: 17s258ms - Times executed: 52 ]
-
CREATE TABLE temp0000286116 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"18-07-2026", "ate" :"23-07-2026", "nota-fiscal":"82160", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-23 16:40:11 Duration: 575ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286116 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"18-07-2026", "ate" :"23-07-2026", "nota-fiscal":"82160", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-23 14:52:44 Duration: 555ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286116 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"18-07-2026", "ate" :"23-07-2026", "nota-fiscal":"82160", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-23 16:16:17 Duration: 494ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 48 2h1m30s 1s263ms 9m42s 2m31s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 23 07 3 8m35s 2m51s 08 3 7m33s 2m31s 09 3 8m57s 2m59s 10 3 8m24s 2m48s 11 3 10m16s 3m25s 12 3 7m43s 2m34s 13 3 6m23s 2m7s 14 3 7m16s 2m25s 15 3 8m43s 2m54s 16 3 8m29s 2m49s 17 3 7m10s 2m23s 18 3 5m50s 1m56s 19 3 5m46s 1m55s 20 3 7m44s 2m34s 21 3 6m30s 2m10s 22 3 6m3s 2m1s [ User: intelifix - Total duration: 2h1m30s - Times executed: 48 ]
[ Application: psql - Total duration: 2h1m30s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-23 11:14:44 Duration: 9m42s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-23 15:13:21 Duration: 8m19s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-23 09:13:07 Duration: 8m6s Database: rio User: intelifix Remote: [local] Application: psql
18 47 1h15m45s 248ms 5m28s 1m36s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 23 07 3 5m15s 1m45s 08 3 4m39s 1m33s 09 2 5m56s 2m58s 10 3 5m8s 1m42s 11 3 6m26s 2m8s 12 3 4m31s 1m30s 13 3 4m14s 1m24s 14 3 4m45s 1m35s 15 3 5m23s 1m47s 16 3 5m1s 1m40s 17 3 4m10s 1m23s 18 3 3m36s 1m12s 19 3 3m52s 1m17s 20 3 4m45s 1m35s 21 3 4m2s 1m20s 22 3 3m55s 1m18s [ User: intelifix - Total duration: 1h15m45s - Times executed: 47 ]
[ Application: psql - Total duration: 1h15m45s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-23 11:21:40 Duration: 5m28s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-23 09:19:47 Duration: 4m53s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-23 15:19:05 Duration: 4m33s Database: brasilia User: intelifix Remote: [local] Application: psql
19 43 9s565ms 154ms 517ms 222ms create table temp0000236770 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 23 14 7 1s874ms 267ms 15 9 1s899ms 211ms 16 7 1s616ms 230ms 17 20 4s175ms 208ms [ User: intelifix - Total duration: 9s565ms - Times executed: 43 ]
[ Application: [unknown] - Total duration: 9s565ms - Times executed: 43 ]
-
CREATE TABLE temp0000236770 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "18-07-2026", "data-ate" : "23-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-23 14:31:53 Duration: 517ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000236770 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "23-07-2026", "data-ate" : "23-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-23 16:14:36 Duration: 422ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000236770 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "23-07-2026", "data-ate" : "23-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-23 17:00:04 Duration: 330ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
20 41 15s1ms 176ms 3s266ms 365ms create table temp0000286236 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 23 08 6 4s420ms 736ms 09 6 1s655ms 275ms 10 7 1s992ms 284ms 11 9 2s805ms 311ms 12 2 659ms 329ms 13 1 372ms 372ms 14 6 1s826ms 304ms 15 4 1s269ms 317ms [ User: intelifix - Total duration: 15s1ms - Times executed: 41 ]
[ Application: [unknown] - Total duration: 15s1ms - Times executed: 41 ]
-
CREATE TABLE temp0000286236 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"18-07-2026", "ate" :"23-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-23 08:02:50 Duration: 3s266ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286236 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"18-07-2026", "ate" :"23-07-2026", "nota-fiscal":"82160", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-23 15:03:54 Duration: 435ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286236 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"18-07-2026", "ate" :"23-07-2026", "nota-fiscal":"82160", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-23 11:18:49 Duration: 406ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m27s 8m54s 5m12s 3 15m36s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 23 05 3 15m36s 5m12s [ User: intelifix - Total duration: 15m36s - Times executed: 3 ]
[ Application: psql - Total duration: 15m36s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-23 05:08:56 Duration: 8m54s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-23 05:13:10 Duration: 4m13s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-23 05:15:38 Duration: 2m27s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s263ms 9m42s 2m31s 48 2h1m30s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 23 07 3 8m35s 2m51s 08 3 7m33s 2m31s 09 3 8m57s 2m59s 10 3 8m24s 2m48s 11 3 10m16s 3m25s 12 3 7m43s 2m34s 13 3 6m23s 2m7s 14 3 7m16s 2m25s 15 3 8m43s 2m54s 16 3 8m29s 2m49s 17 3 7m10s 2m23s 18 3 5m50s 1m56s 19 3 5m46s 1m55s 20 3 7m44s 2m34s 21 3 6m30s 2m10s 22 3 6m3s 2m1s [ User: intelifix - Total duration: 2h1m30s - Times executed: 48 ]
[ Application: psql - Total duration: 2h1m30s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-23 11:14:44 Duration: 9m42s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-23 15:13:21 Duration: 8m19s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-23 09:13:07 Duration: 8m6s Database: rio User: intelifix Remote: [local] Application: psql
3 248ms 5m28s 1m36s 47 1h15m45s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 23 07 3 5m15s 1m45s 08 3 4m39s 1m33s 09 2 5m56s 2m58s 10 3 5m8s 1m42s 11 3 6m26s 2m8s 12 3 4m31s 1m30s 13 3 4m14s 1m24s 14 3 4m45s 1m35s 15 3 5m23s 1m47s 16 3 5m1s 1m40s 17 3 4m10s 1m23s 18 3 3m36s 1m12s 19 3 3m52s 1m17s 20 3 4m45s 1m35s 21 3 4m2s 1m20s 22 3 3m55s 1m18s [ User: intelifix - Total duration: 1h15m45s - Times executed: 47 ]
[ Application: psql - Total duration: 1h15m45s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-23 11:21:40 Duration: 5m28s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-23 09:19:47 Duration: 4m53s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-23 15:19:05 Duration: 4m33s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s561ms 1m34s 49s460ms 4 3m17s 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 Jul 23 20 2 1m39s 49s550ms 23 2 1m38s 49s370ms [ User: intelifix - Total duration: 3m17s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m17s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-23 20:08:59 Duration: 1m34s 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-07-23 23:17:34 Duration: 1m33s 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-07-23 23:37:39 Duration: 5s215ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 426ms 1m4s 30s716ms 4 2m2s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 23 20 2 58s322ms 29s161ms 23 2 1m4s 32s271ms [ User: intelifix - Total duration: 2m2s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m2s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-23 23:13:59 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-23 20:05:37 Duration: 57s896ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-23 23:37:03 Duration: 451ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 2s849ms 40s771ms 16s661ms 6 1m39s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 23 20 3 47s189ms 15s729ms 23 3 52s782ms 17s594ms [ User: intelifix - Total duration: 1m39s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m39s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-23 23:14:41 Duration: 40s771ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-23 20:06:13 Duration: 34s1ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-23 20:10:25 Duration: 10s337ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 150ms 6m39s 15s713ms 331 1h26m41s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 23 07 13 10m24s 48s33ms 08 54 1m2s 1s153ms 09 21 13m58s 39s919ms 10 23 8m19s 21s735ms 11 29 8m55s 18s453ms 12 15 1m5s 4s335ms 13 29 20s529ms 707ms 14 38 15m44s 24s852ms 15 44 12m3s 16s435ms 16 30 8m20s 16s668ms 17 35 6m27s 11s80ms [ User: intelifix - Total duration: 1h26m41s - Times executed: 331 ]
[ Application: [unknown] - Total duration: 1h26m41s - Times executed: 331 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027450, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-23 09:36:06 Duration: 6m39s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027463, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-23 11:19:44 Duration: 6m9s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027449, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-23 09:00:32 Duration: 5m39s Database: rio User: intelifix Remote: [local] Application: [unknown]
8 1s629ms 44s7ms 13s648ms 69 15m41s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 23 06 3 17s586ms 5s862ms 07 2 9s363ms 4s681ms 08 1 44s7ms 44s7ms 09 3 38s733ms 12s911ms 10 6 1m45s 17s620ms 11 10 2m55s 17s534ms 13 1 21s805ms 21s805ms 14 7 1m37s 13s968ms 15 20 3m16s 9s841ms 16 8 2m19s 17s404ms 17 8 1m35s 11s920ms [ User: intelifix - Total duration: 15m41s - Times executed: 69 ]
[ Application: [unknown] - Total duration: 15m41s - Times executed: 69 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-23', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-23 08:46:36 Duration: 44s7ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-23', 0320, '', '', 0, 6, '2026-07-01');
Date: 2026-07-23 10:25:47 Duration: 35s630ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-23', 0320, '', '', 0, 6, '2026-07-01');
Date: 2026-07-23 11:32:06 Duration: 32s699ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 9s992ms 16s339ms 12s475ms 32 6m39s create table temp0000286248 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 23 08 3 35s264ms 11s754ms 09 2 24s747ms 12s373ms 10 18 3m31s 11s741ms 11 9 2m7s 14s205ms [ User: intelifix - Total duration: 6m39s - Times executed: 32 ]
[ Application: [unknown] - Total duration: 6m39s - Times executed: 32 ]
-
CREATE TABLE temp0000286248 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 11:24:39 Duration: 16s339ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286248 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 11:26:20 Duration: 15s692ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286248 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 11:12:53 Duration: 15s335ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 9s617ms 35s207ms 12s297ms 38 7m47s create table temp0000286296 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 23 14 20 3m56s 11s824ms 15 10 2m21s 14s149ms 16 8 1m29s 11s165ms [ User: intelifix - Total duration: 7m47s - Times executed: 38 ]
[ Application: [unknown] - Total duration: 7m47s - Times executed: 38 ]
-
CREATE TABLE temp0000286296 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 15:18:19 Duration: 35s207ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286296 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 14:21:14 Duration: 14s850ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286296 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 14:22:29 Duration: 13s375ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 9s835ms 15s463ms 12s241ms 40 8m9s create table temp0000286222 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 23 07 17 3m12s 11s314ms 08 14 2m55s 12s504ms 09 3 39s908ms 13s302ms 10 3 38s686ms 12s895ms 11 3 43s640ms 14s546ms [ User: intelifix - Total duration: 8m9s - Times executed: 40 ]
[ Application: [unknown] - Total duration: 8m9s - Times executed: 40 ]
-
CREATE TABLE temp0000286222 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 10:39:32 Duration: 15s463ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286222 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 11:13:30 Duration: 14s850ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286222 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 11:13:13 Duration: 14s771ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 10s100ms 13s542ms 11s806ms 23 4m31s create table temp0000286274 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 23 13 9 1m43s 11s521ms 14 14 2m47s 11s989ms [ User: intelifix - Total duration: 4m31s - Times executed: 23 ]
[ Application: [unknown] - Total duration: 4m31s - Times executed: 23 ]
-
CREATE TABLE temp0000286274 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 14:21:24 Duration: 13s542ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286274 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 14:03:09 Duration: 13s451ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286274 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-23 14:07:11 Duration: 13s129ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 756ms 11s875ms 4s63ms 31 2m5s 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 #13
Day Hour Count Duration Avg duration Jul 23 08 3 9s306ms 3s102ms 09 1 4s665ms 4s665ms 10 3 22s704ms 7s568ms 11 2 13s619ms 6s809ms 12 3 15s10ms 5s3ms 13 3 16s122ms 5s374ms 14 2 12s504ms 6s252ms 15 1 6s757ms 6s757ms 16 2 14s49ms 7s24ms 17 2 2s151ms 1s75ms 18 2 2s366ms 1s183ms 19 2 2s191ms 1s95ms 20 2 1s575ms 787ms 21 1 1s83ms 1s83ms 22 2 1s852ms 926ms [ User: intelifix - Total duration: 2m5s - Times executed: 31 ]
[ Application: psql - Total duration: 2m5s - Times executed: 31 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-07-23 12:00:13 Duration: 11s875ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-07-23 13:40:12 Duration: 11s271ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-07-23 11:20:11 Duration: 9s808ms Database: rio User: intelifix Remote: [local] Application: psql
14 2s722ms 9s236ms 3s526ms 30 1m45s create table temp0000286222 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 23 07 14 51s301ms 3s664ms 08 6 20s34ms 3s339ms 09 10 34s469ms 3s446ms [ User: intelifix - Total duration: 1m45s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 1m45s - Times executed: 30 ]
-
CREATE TABLE temp0000286222 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"18-07-2026", "ate" :"23-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-23 07:22:55 Duration: 9s236ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286222 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"18-07-2026", "ate" :"23-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-23 08:19:47 Duration: 4s501ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286222 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"18-07-2026", "ate" :"23-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-23 09:05:20 Duration: 3s989ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 181ms 12s958ms 2s853ms 38 1m48s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 23 07 3 17s17ms 5s672ms 08 3 8s706ms 2s902ms 09 3 8s358ms 2s786ms 10 7 13s650ms 1s950ms 11 5 10s444ms 2s88ms 12 1 3s73ms 3s73ms 13 2 6s453ms 3s226ms 14 5 21s652ms 4s330ms 15 3 6s313ms 2s104ms 16 2 6s285ms 3s142ms 17 4 6s467ms 1s616ms [ User: intelifix - Total duration: 1m48s - Times executed: 38 ]
[ Application: psql - Total duration: 1m48s - Times executed: 38 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027439);
Date: 2026-07-23 07:16:47 Duration: 12s958ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027458);
Date: 2026-07-23 10:39:50 Duration: 9s958ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027463);
Date: 2026-07-23 11:13:08 Duration: 8s672ms Database: rio User: intelifix Remote: [local] Application: psql
16 165ms 11s210ms 2s795ms 153 7m7s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 23 00 6 18s492ms 3s82ms 01 6 7s942ms 1s323ms 02 5 8s53ms 1s610ms 03 5 8s9ms 1s601ms 04 6 8s304ms 1s384ms 05 4 7s799ms 1s949ms 06 3 3s647ms 1s215ms 07 10 30s264ms 3s26ms 08 12 46s636ms 3s886ms 09 12 42s220ms 3s518ms 10 12 36s281ms 3s23ms 11 12 51s263ms 4s271ms 12 7 31s875ms 4s553ms 13 4 3s797ms 949ms 14 10 35s220ms 3s522ms 15 12 38s6ms 3s167ms 16 10 26s768ms 2s676ms 17 5 4s61ms 812ms 20 1 235ms 235ms 21 5 9s405ms 1s881ms 22 6 9s468ms 1s578ms [ User: intelifix - Total duration: 7m7s - Times executed: 153 ]
[ Application: psql - Total duration: 7m7s - Times executed: 153 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-23 00:05:12 Duration: 11s210ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-23 11:25:10 Duration: 9s137ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-23 10:15:09 Duration: 8s7ms Database: rio User: intelifix Remote: [local] Application: psql
17 176ms 1m17s 2s93ms 64 2m13s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 23 07 6 3s390ms 565ms 08 6 4s410ms 735ms 09 2 6s251ms 3s125ms 10 9 17s433ms 1s937ms 11 5 5s281ms 1s56ms 12 1 1m17s 1m17s 13 4 940ms 235ms 14 16 5s300ms 331ms 15 5 3s434ms 686ms 16 4 3s329ms 832ms 17 6 7s93ms 1s182ms [ User: intelifix - Total duration: 2m13s - Times executed: 64 ]
[ Application: psql - Total duration: 2m13s - Times executed: 64 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027466);
Date: 2026-07-23 12:13:31 Duration: 1m17s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027460);
Date: 2026-07-23 10:51:29 Duration: 5s988ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027451);
Date: 2026-07-23 09:59:55 Duration: 5s731ms Database: rio User: intelifix Remote: [local] Application: psql
18 162ms 9s37ms 1s836ms 272 8m19s call rs_giga_triagem (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 23 00 12 26s257ms 2s188ms 01 12 19s111ms 1s592ms 02 12 21s200ms 1s766ms 03 10 14s470ms 1s447ms 04 12 17s508ms 1s459ms 05 12 20s354ms 1s696ms 06 12 19s382ms 1s615ms 07 11 19s804ms 1s800ms 08 12 21s782ms 1s815ms 09 12 24s583ms 2s48ms 10 12 19s578ms 1s631ms 11 12 28s898ms 2s408ms 12 12 20s378ms 1s698ms 13 12 22s39ms 1s836ms 14 12 23s559ms 1s963ms 15 12 23s136ms 1s928ms 16 12 23s729ms 1s977ms 17 12 21s759ms 1s813ms 18 12 18s982ms 1s581ms 19 11 20s886ms 1s898ms 20 12 31s600ms 2s633ms 21 12 19s787ms 1s648ms 22 12 20s825ms 1s735ms [ User: intelifix - Total duration: 8m19s - Times executed: 272 ]
[ Application: psql - Total duration: 8m19s - Times executed: 272 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-23 00:05:21 Duration: 9s37ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-23 20:15:09 Duration: 7s936ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-23 20:05:08 Duration: 7s121ms Database: rio User: intelifix Remote: [local] Application: psql
19 150ms 5s44ms 844ms 1,192 16m46s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 23 07 43 37s630ms 875ms 08 100 1m16s 767ms 09 124 1m32s 746ms 10 118 1m54s 972ms 11 138 2m26s 1s64ms 12 59 44s521ms 754ms 13 112 1m27s 783ms 14 185 2m33s 828ms 15 191 2m29s 783ms 16 90 1m21s 911ms 17 32 20s838ms 651ms [ User: intelifix - Total duration: 16m46s - Times executed: 1192 ]
[ Application: [unknown] - Total duration: 16m46s - Times executed: 1192 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (269622, 450, 'CP2409325YU,08C7F52C22ED,544D4242007818B2,08C7F52C22F0$CP234532WDM,08C7F5065F28,544D42420073B35D,08C7F5065F2B$CP2407320ET,08C7F5293AEE,544D42420077CED7,08C7F5293AF1$CP232532C1F,D4925ECC7533,544D4242006D4691,D4925ECC7536$CP23453248P,08C7F5027603,544D424200734420,08C7F5027606$CP2303327YS,D4925E14C624,544D42420062D515,D4925E14C627$CP2303326HQ,D4925E148F82,544D42420062CF03,D4925E148F85$CP230332802,D4925E14C7A7,544D42420062D540,D4925E14C7AA$CP2407328RC,08C7F52A7972,544D42420077F23B,08C7F52A7975$CP2303327EY,D4925E14B28F,544D42420062D2E8,D4925E14B292$CP234232R6M,D4925EF93C9C,544D424200724C79,D4925EF93C9F$CP23433242F,D4925EFEDE8D,544D42420072BA9A,D4925EFEDE90$CP240432NVM,08C7F52859A1,544D4242007777EA,08C7F52859A4$CP2319322JD,D4925E9FE6A4,544D42420069938E,D4925E9FE6A7$CP2345323FM,08C7F50257C7,544D4242007340C4,08C7F50257CA$CP2317324L7,D4925E950EF7,544D424200682C61,D4925E950EFA$CP234232PR4,D4925EF9057C,544D424200724659,D4925EF9057F$CP240332CKK,08C7F522B057,544D42420076D6E4,08C7F522B05A$CP23463208F,08C7F506D609,544D42420073B7E4,08C7F506D60C$CP2409325GJ,08C7F52C112C,544D4242007816B9,08C7F52C112F$CP232532CT0,D4925ECC92D6,544D4242006D49DC,D4925ECC92D9$CP234232NG5,D4925EF8D4DD,544D4242007240F2,D4925EF8D4E0$CP23103220B,D4925E33B9D1,544D42420065B863,D4925E33B9D4$CP230232GR2,D4925E08A26C,544D42420061DD51,D4925E08A26F$CP2301329KU,D4925E02D29C,544D4242006138BB,D4925E02D29F$CP24093225L,08C7F52B91A0,544D42420078088D,08C7F52B91A3$CP2322320DR,D4925EB2E584,544D4242006B8D84,D4925EB2E587$CP2305325S6,D4925E19680E,544D424200638FF9,D4925E196811$CP230232EDY,D4925E0848F3,544D42420061D360,D4925E0848F6$CP2407328Y1,08C7F52A8005,544D42420077F2F6,08C7F52A8008$CP230132FWV,D4925E03C51E,544D4242006153AD,D4925E03C521$CP22413219B,A0B53CC26B86,544D4242005E958D,A0B53CC26B89$CP230232FKE,D4925E0875BD,544D42420061D85A,D4925E0875C0$CP24093232V,08C7F52BB4BF,544D424200780C74,08C7F52BB4C2$CP23013233P,D4925E01DA3B,544D424200611D22,D4925E01DA3E$CP2239324LU,A0B53CC0C8D3,544D4242005E80B8,A0B53CC0C8D6$CP232232DFN,D4925EBD727D,544D4242006BC510,D4925EBD7280$CP2317324ZL,D4925E951D58,544D424200682DFA,D4925E951D5B$CP2319327A2,D4925EA09C81,544D42420069A7C3,D4925EA09C84$CP2319321SC,D4925E9FC9E2,544D42420069905C,D4925E9FC9E5', '',0298,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-07-23 11:03:07 Duration: 5s44ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48123, 417, 'ZTE3ANNRCB22309,D831391FD9DC,D831391FD9DD,ZTEGDD2A0CBA$ZTE3ANNR2Q33441,F4E84F83C3C6,F4E84F83C3C7,ZTEGD97AF55B$ZTE3ANNR3Y35325,4896D952FCA6,4896D952FCA7,ZTEGD97EBAB2$ZTE3ANNR1Y33352,14CA56CFB82B,14CA56CFB82C,ZTEGD970F8A3$ZTE3ANNR7B31796,3891484BD5DF,3891484BD5E0,ZTEGDB080D94$ZTE3ANNR7B32314,3891484BE203,3891484BE204,ZTEGDB080F9A$ZTE3ANNQCA02866,14CA56D28807,14CA56D28808,ZTEGD971709D$ZTE3ANNQ7104022,C4EBFF8A26AC,C4EBFF8A26AD,ZTEGD70A2C88$ZTE3ANNRAD22101,D89A0DAFE061,D89A0DAFE062,ZTEGDB175260$ZTE3ANNQ8F09377,689E29FCFEA3,689E29FCFEA4,ZTEGD7BA2171$ZTE3ANNR8C36316,38914851DA2F,38914851DA30,ZTEGDB090E4C$ZTE3ANNRC501188,6C11BA6245AF,6C11BA6245B0,ZTEGDC6E1A63$ZTE3ANNT3H45683,D831399AF24A,D831399AF24B,ZTEGDD328312$ZTE3ANNQ3621170,3CF9F0A6C59A,3CF9F0A6C59B,ZTEGD640B64D$ZTE3ANNRCP46282,6C11BA6D678B,6C11BA6D678C,ZTEGDC6FF55D$ZTE3ANNQ3R00355,3CF9F0A28818,3CF9F0A28819,ZTEGD6400162$ZTE3ANNRB716825,5872C98FC387,5872C98FC388,ZTEGDC616C8C$ZTE3ANNQ3R00275,3CF9F0A28638,3CF9F0A28639,ZTEGD6400112$ZTE3ANNQ9J32083,843C992EC127,843C992EC128,ZTEGD7BB85FE$ZTE3ANNRAD22809,D89A0DAFF0F9,D89A0DAFF0FA,ZTEGDB175524$ZTE3ANNRCP03462,6C11BA697BF3,6C11BA697BF4,ZTEGDC6F4E19$ZTE3ANNR6R52825,48D6823A5AD8,48D6823A5AD9,ZTEGDB01F92C$ZTE3ANNRCB19333,D831391F941C,D831391F941D,ZTEGDD2A011A$ZTE3ANNQ3R00408,3CF9F0A28956,3CF9F0A28957,ZTEGD6400197$ZTE3ANNR8C35599,38914851C961,38914851C962,ZTEGDB090B7F$ZTE3ANNR2Q00900,F4E84F80C918,F4E84F80C919,ZTEGD97A763E', '',0323,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-23 11:27:28 Duration: 4s572ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (269617, 450, '2102313BFARYM6900859,20AB48C2326E,4857544342EC15A6,20AB48C23271BFARYN7902061,ECA1D1F2E8B1,48575443A68FEBAA,ECA1D1F2E8B4BFARYN7902911,ECA1D1F326FB,48575443A69395AA,ECA1D1F326FEBFARYM6920740,B0761B174FEA,485754436AFEFEA6,B0761B174FEDBFARYMA907210,CCB182BEEED7,48575443858E03A7,CCB182BEEEDABFARYMA900990,CCB1827E71B7,48575443807A2CA7,CCB1827E71BABFARYN2918750,88892FFDD097,48575443EB8477A8,88892FFDD09ABFARYN2905372,88892F877054,48575443E52C06A8,88892F877057BFARYMA955415,C40D96B29DD0,48575443E33FEBA7,C40D96B29DD3BFARYMA944200,C40D969D1539,48575443E11C8AA7,C40D969D153CBFARYM6908781,CCD73C7521A7,48575443635DCCA6,CCD73C7521AABFARYM9910452,C0F6C2705BD8,48575443257337A7,C0F6C2705BDBBFARYM6905149,20AB48B97D18,48575443431E75A6,20AB48B97D1BBFARYM9909107,C0F6C26FC86C,485754432569B9A7,C0F6C26FC86FBFARYN5915134,14AB0227B35E,485754436A651DAA,14AB0227B361BFARYN5906752,B0ECDD4B418C,485754435CF9F2AA,B0ECDD4B418FBFARYN2924564,88892FFF03C9,48575443EB968FA8,88892FFF03CCBFARYM7900349,F09BB8C40C11,485754437D5D2BA6,F09BB8C40C14BFARYM6935477,F09BB855A7F4,4857544377589CA6,F09BB855A7F7BFARYM8902060,1C3D2F46DD5F,48575443D52F7CA6,1C3D2F46DD62BFARYN2935666,A4178B02B81E,48575443EBBF16A8,A4178B02B821BFARYN2920664,88892FFE25DB,48575443EB8981A8,88892FFE25DEBFARYMA948562,C40D96A9238E,48575443E28FB4A7,C40D96A92391BFARYM4903315,80E1BFFAC241,48575443C3D3E7A5,80E1BFFAC244BFARYN2907542,88892F88BBD4,48575443E53F98A8,88892F88BBD7BFARYN2913637,88892F8A4736,48575443E556DEA8,88892F8A4739BFARYN7902290,ECA1D1F3064F,48575443A691A9AA,ECA1D1F30652BFARYN1915729,C4FBAAFB801E,48575443D3D641A8,C4FBAAFB8021BFARYM8957710,2868D21782A3,48575443FAA2A5A6,2868D21782A6BFARYMA903894,CCB1827F751C,4857544380FBC8A7,CCB1827F751FBFARYM8909425,1C3D2F467264,48575443D5291CA6,1C3D2F467267BFARYM8900082,1C3D2F464775,48575443D52693A6,1C3D2F464778BFARYM6903423,20AB48B91C9E,485754434317FCA6,20AB48B91CA1BFARYN2904275,88892F86E414,48575443E523C6A8,88892F86E417BFARYM9908230,C0F6C2705A51,4857544325731EA7,C0F6C2705A54BFARYN2914668,88892F89655D,48575443E54993A8,88892F896560BFARYM6903439,20AB48B9261D,4857544343189CA6,20AB48B92620BFARYN2904394,88892F877907,48575443E52C89A8,88892F87790A', '',0189,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-07-23 11:45:09 Duration: 4s205ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 152ms 2s710ms 572ms 133 1m16s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 23 07 7 2s944ms 420ms 08 33 14s591ms 442ms 10 2 1s548ms 774ms 11 2 3s974ms 1s987ms 12 6 12s311ms 2s51ms 13 22 13s214ms 600ms 14 23 12s190ms 530ms 15 17 6s626ms 389ms 16 8 3s193ms 399ms 17 13 5s562ms 427ms [ User: intelifix - Total duration: 1m16s - Times executed: 133 ]
[ Application: [unknown] - Total duration: 1m16s - Times executed: 133 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0129060) LIMIT 1;
Date: 2026-07-23 12:01:16 Duration: 2s710ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0128418) LIMIT 1;
Date: 2026-07-23 12:19:59 Duration: 2s237ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0128824) LIMIT 1;
Date: 2026-07-23 12:03:41 Duration: 2s102ms Database: brasilia 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 8 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 23 16 1 0ms 0ms 18 1 0ms 0ms 19 2 0ms 0ms 20 1 0ms 0ms 21 2 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 5m55s - Times executed: 8 ]
[ Application: psql - Total duration: 5m55s - Times executed: 7 ]
[ Application: [unknown] - Total duration: 479ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 14,726 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 43 FATAL entries
- 2376 ERROR entries
- 0 WARNING entries
- 3 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2,264 Max number of times the same event was reported
- 2,422 Total events found
Rank Times reported Error 1 2,264 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 23 07 200 08 306 09 329 10 249 11 287 12 100 13 135 14 260 15 240 16 146 17 12 - ERROR: prepared statement "_PLAN0000000029F76130" does not exist
- ERROR: prepared statement "_PLAN00000000313A42A0" does not exist
- ERROR: prepared statement "_PLAN00000000313A4BC0" does not exist
Statement: DEALLOCATE "_PLAN0000000029F76130"
Date: 2026-07-23 07:06:05 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000313A42A0"
Date: 2026-07-23 07:09:05 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000313A4BC0"
Date: 2026-07-23 07:09:09 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 Jul 23 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-07-23 00:05: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-07-23 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-07-23 01:05:02 Database: brasilia Application: psql User: intelifix Remote: [local]
3 44 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 23 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 2 19 3 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-23 08:00:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-23 08:20:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-23 08:40:06 Database: brasilia Application: psql User: intelifix Remote: [local]
4 32 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 23 00 1 01 1 06 1 10 1 18 14 19 8 20 1 21 2 22 1 23 2 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-07-23 00:02:28 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-23 01:27:43 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-23 06:02:26 Database: testes Application: [unknown] User: lenon Remote: [local]
5 8 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 23 09 1 10 4 11 3 - ERROR: syntax error at or near "229856237293" at character 41
- ERROR: syntax error at or near "229729567983" at character 32
- ERROR: syntax error at or near "229729567983" at character 44
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''229856237293');
Date: 2026-07-23 09:54:14 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT RS_SERIAL_TEMPORARIO( ''229729567983' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''229729567983' )
Date: 2026-07-23 10:07:26 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT SAIDA FROM RS_SMARTCARD_TELA( 00, ''229729567983' )
Date: 2026-07-23 10:07:26 Database: rio Application: [unknown] User: intelifix Remote: [local]
6 8 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 23 13 4 14 2 15 2 - ERROR: trailing junk after numeric literal at or near "48295245DA8F" at character 27
- ERROR: trailing junk after numeric literal at or near "48295245DA8F" at character 27
- ERROR: trailing junk after numeric literal at or near "48295245DA8F" at character 27
Statement: select * from rs_caixa_qr(48295245DA8F)
Date: 2026-07-23 13:19:25 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(48295245DA8F)
Date: 2026-07-23 13:19:26 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(48295245DA8F)
Date: 2026-07-23 13:20:03 Database: rio Application: [unknown] User: etiquetas Remote: [local]
7 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 23 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-23 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-23 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-23 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
8 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 23 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-07-23 05:32:22 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-23 05:32:22 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-23 05:32:22 Database: contagem Application: psql User: intelifix Remote: [local]
9 4 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 23 03 4 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-23 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-23 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-23 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
10 1 ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(...) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(...) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(...) line 48 at assignment
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 23 18 1 - ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-23 18:20:04 Database: brasilia Application: psql User: intelifix Remote: [local]
11 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 23 03 1 - LOG: database system was shut down at 2026-07-23 03:05:01 -03
Date: 2026-07-23 03:05:02
12 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 23 15 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000286296"
Date: 2026-07-23 15:47:47
13 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #13
Day Hour Count Jul 23 15 1 - LOG: process 2798774 still waiting for AccessExclusiveLock on relation 2866768 of database 358220 after 1000.095 ms
Detail: Process holding the lock: 2857706. Wait queue: 2798774.
Statement: DROP TABLE IF EXISTS temp0000286296;Date: 2026-07-23 15:47:47 Database: rio Application: [unknown] User: intelifix Remote: [local]
14 1 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #14
Day Hour Count Jul 23 14 1 - LOG: process 2776713 still waiting for ShareLock on transaction 3189494 after 1000.088 ms
Detail: Process holding the lock: 2754953. Wait queue: 2776713.
Context: while updating tuple (1,51) in relation "usuarios" SQL statement "UPDATE USUARIOS SET EQ_CODIGO = NULL, USU_CHECK_IN = NULL WHERE USU_ID = nUser" PL/pgSQL function rs_tecnico_check_out(integer) line 28 at SQL statement SQL statement "SELECT RS_TECNICO_CHECK_OUT( nTecnico )" PL/pgSQL function rs_baixa(integer,integer,integer,integer,character varying,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1129 at PERFORM PL/pgSQL function rs_fluxo_encerra(integer,integer,boolean) line 169 at assignment PL/pgSQL function rs_cria_fluxo_fechado(integer,character varying,integer,boolean) line 94 at assignment PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1095 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(48156,418,'2102312JCYRYK9015962,D0C65B26A7DB,485754438BFC0A9F','',0147,00,'[{"item":"0","qrcode":""}]','','',00);Date: 2026-07-23 14:45:02 Database: contagem Application: [unknown] User: intelifix Remote: [local]