pgBadger-
Global information
- Generated on Wed Oct 7 23:50:12 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 37,910 log entries in 10s
- Log start from 2026-10-07 00:00:11 to 2026-10-07 23:45:22
-
Overview
Global Stats
- 338 Number of unique normalized queries
- 4,085 Number of queries
- 6h1m33s Total query duration
- 2026-10-07 00:02:06 First query
- 2026-10-07 23:42:20 Last query
- 5 queries/s at 2026-10-07 20:08:34 Query peak
- 6h1m33s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 6h1m33s Execute total duration
- 4,477 Number of events
- 13 Number of unique normalized events
- 4,394 Max number of times the same event was reported
- 0 Number of cancellation
- 319 Total number of automatic vacuums
- 931 Total number of automatic analyzes
- 21 Number temporary file
- 249.46 MiB Max size of temporary file
- 69.58 MiB Average size of temporary file
- 420 Total number of sessions
- 9 sessions at 2026-10-07 06:05:05 Session peak
- 13d8h43m14s Total duration of sessions
- 45m49s Average duration of sessions
- 9 Average queries per session
- 51s651ms Average queries duration per session
- 44m57s Average idle time per session
- 429 Total number of connections
- 5 connections/s at 2026-10-07 03:05:16 Connection peak
- 4 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-07 20:08:34 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-10-07 08:56:50 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-07 20:08:34 Date
Queries duration
Key values
- 6h1m33s 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) Oct 07 00 27 0ms 14s624ms 3s160ms 4s22ms 5s193ms 56s420ms 01 23 0ms 3s126ms 1s212ms 4s12ms 4s370ms 5s80ms 02 18 0ms 3s38ms 1s389ms 3s522ms 4s230ms 5s13ms 03 24 0ms 2s992ms 1s217ms 3s647ms 5s203ms 5s943ms 04 31 0ms 3s494ms 965ms 3s397ms 4s979ms 7s205ms 05 29 0ms 9m19s 43s560ms 4s669ms 2m36s 9m19s 06 25 0ms 12s842ms 3s29ms 3s6ms 12s842ms 26s595ms 07 109 0ms 6m27s 11s422ms 11s707ms 3m49s 6m29s 08 466 150ms 5m50s 2s976ms 27s761ms 3m34s 5m51s 09 493 0ms 5m49s 2s752ms 47s874ms 2m13s 5m54s 10 414 150ms 5m50s 4s558ms 55s346ms 5m40s 6m9s 11 334 150ms 5m40s 3s501ms 15s776ms 3m24s 5m52s 12 101 0ms 5m46s 7s264ms 8s818ms 51s752ms 5m49s 13 130 0ms 5m47s 5s791ms 8s190ms 47s873ms 5m47s 14 485 151ms 6m11s 5s619ms 1m19s 6m2s 6m38s 15 318 0ms 5m53s 4s435ms 38s679ms 3m42s 5m56s 16 262 0ms 5m8s 3s231ms 16s223ms 23s701ms 5m53s 17 237 0ms 5m28s 5s383ms 53s880ms 2m18s 5m28s 18 35 0ms 5m4s 17s339ms 23s954ms 3m14s 5m51s 19 24 0ms 5m5s 23s469ms 3m11s 5m49s 5m49s 20 113 0ms 5m14s 9s896ms 1m19s 3m11s 6m45s 21 30 0ms 5m9s 19s147ms 3m11s 5m52s 5m52s 22 34 0ms 5m5s 16s873ms 3m15s 5m47s 5m47s 23 323 0ms 1m1s 5s975ms 1m9s 1m13s 1m24s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 07 00 4 0 1s713ms 0ms 0ms 0ms 01 5 0 355ms 0ms 0ms 728ms 02 0 0 0ms 0ms 0ms 0ms 03 6 0 239ms 0ms 0ms 356ms 04 13 0 247ms 0ms 197ms 675ms 05 8 0 268ms 0ms 0ms 646ms 06 8 0 1s108ms 0ms 0ms 925ms 07 70 0 16s239ms 1s155ms 11s707ms 6m15s 08 323 0 3s509ms 4s865ms 16s928ms 5m34s 09 379 0 2s627ms 6s573ms 27s17ms 3m48s 10 315 0 4s776ms 5s493ms 21s212ms 5m45s 11 279 0 3s761ms 4s806ms 8s156ms 5m40s 12 68 0 9s857ms 1s347ms 2s275ms 3m58s 13 89 0 7s736ms 2s470ms 4s87ms 3m36s 14 323 0 5s339ms 11s282ms 49s317ms 6m2s 15 253 0 4s416ms 5s225ms 10s631ms 5m49s 16 211 0 3s513ms 8s406ms 12s600ms 3m11s 17 168 0 6s484ms 11s204ms 50s664ms 3m31s 18 14 0 40s248ms 1s989ms 7s528ms 5m51s 19 6 0 1m30s 0ms 3m11s 5m49s 20 10 83 11s742ms 1m13s 1m19s 5m44s 21 7 0 1m17s 0ms 3m11s 5m52s 22 8 0 1m7s 0ms 3m15s 5m47s 23 3 320 5s975ms 1m4s 1m9s 1m24s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 07 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 Oct 07 00 0 0 0.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 2 2.00 0.00% 05 0 2 2.00 0.00% 06 0 1 1.00 0.00% 07 0 7 7.00 0.00% 08 0 14 14.00 0.00% 09 0 13 13.00 0.00% 10 0 10 10.00 0.00% 11 0 9 9.00 0.00% 12 0 5 5.00 0.00% 13 0 7 7.00 0.00% 14 0 12 12.00 0.00% 15 0 8 8.00 0.00% 16 0 10 10.00 0.00% 17 0 7 7.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 0 0.00 0.00% 22 0 1 1.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Oct 07 00 16 0.00/s 01 10 0.00/s 02 7 0.00/s 03 20 0.01/s 04 9 0.00/s 05 10 0.00/s 06 16 0.00/s 07 17 0.00/s 08 23 0.01/s 09 25 0.01/s 10 27 0.01/s 11 24 0.01/s 12 16 0.00/s 13 19 0.01/s 14 28 0.01/s 15 40 0.01/s 16 32 0.01/s 17 30 0.01/s 18 10 0.00/s 19 9 0.00/s 20 11 0.00/s 21 9 0.00/s 22 12 0.00/s 23 9 0.00/s Day Hour Count Average Duration Average idle time Oct 07 00 5 50m 49m43s 01 15 1h1m58s 1h1m56s 02 10 1h18s 1h15s 03 15 23m9s 23m7s 04 11 1h2m11s 1h2m8s 05 10 55m36s 53m30s 06 9 58m26s 58m18s 07 17 56m17s 55m4s 08 17 52m51s 51m30s 09 25 51m41s 50m47s 10 25 45m17s 44m2s 11 25 44m4s 43m17s 12 19 56m1s 55m22s 13 12 1h58s 59m55s 14 28 44m52s 43m15s 15 43 27m32s 27m 16 28 32m 31m29s 17 35 34m19s 33m43s 18 16 57m15s 56m37s 19 10 55m18s 54m21s 20 11 44m28s 42m46s 21 8 53m45s 52m33s 22 9 1h20s 59m16s 23 17 41m4s 39m11s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-10-07 03:05:16 Date
Connections per database
Key values
- brasilia Main Database
- 429 connections Total
Connections per user
Key values
- intelifix Main User
- 429 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2026-10-07 06:05:05 Date
Histogram of session times
Key values
- 285 3600000-28800000ms duration
Sessions per database
Key values
- brasilia Main Database
- 420 sessions Total
Sessions per user
Key values
- intelifix Main User
- 420 sessions Total
Sessions per host
Key values
- [local] Main Host
- 420 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 25,110 buffers Checkpoint Peak
- 2026-10-07 00:09:43 Date
- 270.062 seconds Highest write time
- 0.049 seconds Sync time
Checkpoints Wal files
Key values
- 12 files Wal files usage Peak
- 2026-10-07 14:44:37 Date
Checkpoints distance
Key values
- 388.66 Mo Distance Peak
- 2026-10-07 14:54:37 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Oct 07 00 36,115 658.76s 0.013s 658.79s 01 2,674 268.138s 0.023s 268.186s 02 1,472 147.504s 0.011s 147.536s 03 1,962 195.667s 0.023s 195.715s 04 4,384 439.083s 0.019s 439.129s 05 9,481 940.861s 0.073s 940.969s 06 5,768 406.014s 0.005s 406.025s 07 19,542 1,618.457s 0.056s 1,618.562s 08 44,540 3,116.627s 0.143s 3,116.844s 09 63,532 3,239.446s 0.239s 3,239.765s 10 56,169 3,239.498s 0.109s 3,239.684s 11 43,466 3,168.449s 0.121s 3,168.635s 12 16,583 1,671.408s 0.05s 1,671.504s 13 12,302 1,283.618s 0.069s 1,283.728s 14 51,380 3,239.174s 0.134s 3,239.4s 15 43,632 3,133.104s 0.154s 3,133.342s 16 33,342 2,924.64s 0.117s 2,924.818s 17 42,249 2,687.393s 0.131s 2,687.589s 18 6,402 642.486s 0.038s 642.552s 19 52 5.239s 0.008s 5.256s 20 1,269 131.448s 0.009s 131.467s 21 2,680 268.446s 0.017s 268.488s 22 1,983 198.691s 0.017s 198.731s 23 375 37.708s 0.008s 37.727s Day Hour Added Removed Recycled Synced files Longest sync Average sync Oct 07 00 0 0 8 487 0.003s 0.006s 01 0 0 1 755 0.002s 0.01s 02 0 0 0 400 0.002s 0.007s 03 0 0 1 391 0.003s 0.008s 04 0 0 1 769 0.001s 0.01s 05 0 0 4 843 0.015s 0.011s 06 0 0 1 74 0.002s 0.002s 07 0 0 9 2,097 0.003s 0.011s 08 0 0 24 5,875 0.008s 0.012s 09 0 0 38 6,620 0.004s 0.012s 10 0 0 49 6,308 0.003s 0.012s 11 0 0 20 6,267 0.002s 0.012s 12 0 0 8 2,672 0.003s 0.012s 13 0 0 5 3,415 0.003s 0.012s 14 0 0 82 6,959 0.003s 0.012s 15 0 0 36 6,159 0.006s 0.012s 16 0 0 14 5,939 0.004s 0.012s 17 0 0 35 5,610 0.004s 0.012s 18 0 0 1 786 0.007s 0.013s 19 0 0 0 18 0.002s 0.004s 20 0 0 1 79 0.002s 0.003s 21 0 0 1 413 0.003s 0.008s 22 0 0 0 444 0.002s 0.008s 23 0 0 0 38 0.002s 0.005s Day Hour Count Avg time (sec) Oct 07 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 Oct 07 00 21,087.83 kB 52,807.67 kB 01 1,267.20 kB 24,609.70 kB 02 1,029.86 kB 10,456.00 kB 03 1,207.12 kB 2,790.50 kB 04 2,231.00 kB 3,333.10 kB 05 6,578.80 kB 14,707.20 kB 06 8,990.50 kB 11,567.00 kB 07 13,165.55 kB 27,441.91 kB 08 32,585.67 kB 47,853.50 kB 09 52,257.58 kB 80,187.92 kB 10 66,174.92 kB 125,103.00 kB 11 27,448.83 kB 77,100.75 kB 12 11,620.17 kB 40,503.33 kB 13 6,679.25 kB 25,805.08 kB 14 111,350.67 kB 137,500.33 kB 15 49,019.50 kB 130,559.17 kB 16 19,415.58 kB 54,009.83 kB 17 47,349.17 kB 100,646.83 kB 18 3,165.78 kB 48,313.33 kB 19 71.25 kB 24,261.75 kB 20 2,943.00 kB 17,419.67 kB 21 1,626.50 kB 10,538.88 kB 22 1,260.25 kB 5,437.00 kB 23 212.80 kB 3,097.80 kB -
Temporary Files
Size of temporary files
Key values
- 498.92 MiB Temp Files size Peak
- 2026-10-07 05:31:56 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-10-07 05:32:03 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 07 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.33 GiB 67.86 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 1 104.00 MiB 104.00 MiB 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.02 GiB 37.21 MiB 249.46 MiB 65.45 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-07 05:32:04 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-07 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 309.91 MiB 57.61 MiB 94.81 MiB 77.48 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-07 05:30:41 Duration: 39s375ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-07 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 1 104.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030786, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-07 07:36:24 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030811, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-07 14:26:26 Duration: 6m11s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030838, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-07 14:54:07 Duration: 5m58s Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 249.46 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-07 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 249.46 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-07 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 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-10-07 14:04:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 94.81 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-07 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 94.81 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-07 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 62.67 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-07 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 57.61 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-07 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 41.18 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-07 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 41.11 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-07 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 41.11 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-07 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 41.11 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-07 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 41.11 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-07 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 41.10 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-07 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 41.10 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-07 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 37.27 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-07 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 37.21 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-07 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 37.21 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-07 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 37.21 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-07 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 37.21 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-07 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 37.21 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-07 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 9.49 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_10
Database rio - 2026-10-07 09:11:44 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 9.49 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_10
Database rio - 2026-10-07 09:11:44 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (87) Main table analyzed (database rio)
- 931 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 87 rio.public.usuarios 48 rio.pg_catalog.pg_class 46 rio.public.temp0000293596 42 rio.pg_catalog.pg_type 39 rio.public.temp0000293656 36 contagem.pg_catalog.pg_attribute 32 brasilia.pg_catalog.pg_attribute 30 rio.pg_catalog.pg_index 28 brasilia.public.temp0000241730 28 brasilia.public.temp0000241762 27 contagem.public.usuarios 23 rio.public.temp0000293584 23 rio.pg_catalog.pg_depend 22 brasilia.public.temp0000241780 22 rio.public.temp0000293620 19 rio.public.temp0000293604 19 contagem.pg_catalog.pg_class 18 rio.public.temp0000293000 17 rio.public.temp0000293632 16 contagem.pg_catalog.pg_type 14 brasilia.pg_catalog.pg_class 13 brasilia.public.temp0000241760 12 brasilia.pg_catalog.pg_type 11 rio.public.temp0000293572 11 brasilia.public.temp0000241776 11 brasilia.public.temp0000241710 11 brasilia.public.temp0000241750 11 brasilia.public.usuarios 10 rio.public.temp0000292760 10 rio.public.temp0000293574 10 contagem.pg_catalog.pg_index 9 brasilia.public.temp0000241740 9 brasilia.public.temp0000241758 8 brasilia.public.temp0000241766 7 rio.public.temp0000293682 7 rio.public.temp0000292754 6 brasilia.pg_catalog.pg_index 6 brasilia.public.temp0000241734 6 contagem.pg_catalog.pg_depend 6 rio.public.temp0000292986 6 rio.public.temp0000293662 5 rio.public.tmp_drill_0320 5 brasilia.public.temp0000241788 5 rio.public.temp0000293586 5 rio.public.temp0000293592 4 rio.public.temp0000293612 4 brasilia.pg_catalog.pg_depend 4 contagem.public.temp0000227448 4 rio.public.temp0000293608 4 brasilia.pg_catalog.pg_shdepend 3 rio.public.temp0000293648 3 rio.public.temp0000293582 3 rio.public.temp0000293618 3 rio.public.temp0000293686 3 contagem.public.nf_entrada 3 rio.public.temp0000293666 3 rio.public.temp0000293492 3 brasilia.public.temp0000241728 2 rio.public.temp0000293668 2 contagem.public.temp0000227476 2 brasilia.public.temp0000241786 2 rio.public.temp0000293680 2 rio.public.temp0000293590 2 rio.public.temp0000293598 2 testes.pg_catalog.pg_shdepend 2 rio.public.temp0000293676 2 rio.public.temp0000293606 2 contagem.pg_catalog.pg_shdepend 2 rio.public.temp0000293580 1 rio.public.temp0000293614 1 rio.public.temp0000293688 1 brasilia.public.temp0000241744 1 rio.pg_catalog.pg_shdepend 1 contagem.auditor.auditor_2026_10 1 contagem.public.temp0000227468 1 rio.public.temp0000293658 1 contagem.public.temp0000227462 1 brasilia.public.temp0000241716 1 rio.public.temp0000293644 1 brasilia.public.temp0000241738 1 rio.public.temp0000293670 1 brasilia.auditor.auditor_2026_10 1 contagem.public.temp0000227450 1 rio.public.temp0000293660 1 rio.public.temp0000293616 1 rio.public.temp0000293610 1 brasilia.public.temp0000241714 1 brasilia.public.temp0000241746 1 brasilia.public.temp0000241790 1 rio.public.temp0000293678 1 brasilia.public.temp0000241712 1 rio.public.temp0000293634 1 brasilia.public.temp0000241770 1 brasilia.public.temp0000241764 1 contagem.public.temp0000227474 1 rio.auditor.auditor_2026_10 1 brasilia.public.temp0000241726 1 Total 931 Vacuums per table
Key values
- pg_catalog.pg_attribute (33) Main table vacuumed on database rio
- 319 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 33 29 0 0 0 0 0 17,997 4,877 7,770,440 264 6,650 rio.public.temp0000293596 23 0 0 0 0 0 0 42,531 3,781 7,300,211 0 0 contagem.public.usuarios 22 0 0 0 0 0 0 119 98 51,809 0 0 rio.pg_catalog.pg_class 21 17 0 0 0 0 0 3,375 994 1,611,999 66 258 rio.pg_catalog.pg_type 21 17 0 0 0 0 0 2,026 589 910,929 55 179 rio.public.temp0000293000 17 0 0 0 0 0 0 1,127 94 81,344 0 0 rio.public.temp0000293656 16 0 0 0 0 0 0 6,333 2,042 2,993,626 0 0 rio.pg_catalog.pg_depend 11 10 0 0 0 0 0 3,328 1,154 1,896,606 59 497 contagem.pg_catalog.pg_attribute 11 11 0 0 0 0 0 6,916 1,839 3,340,661 15 364 rio.public.temp0000292760 10 0 0 0 0 0 0 943 195 305,397 0 0 rio.pg_catalog.pg_index 9 9 0 0 0 0 0 564 179 191,436 35 84 brasilia.pg_catalog.pg_attribute 8 8 0 0 0 0 0 3,869 1,264 1,921,376 46 1,253 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 9,323 2,101 9,666,382 984 4,414 postgres.pg_catalog.pg_shdepend 7 7 0 0 0 0 0 1,791 660 1,432,945 77 147 brasilia.pg_catalog.pg_statistic 7 7 0 0 0 0 0 6,846 2,052 8,179,963 1,501 8,247 rio.public.temp0000293620 7 0 0 0 0 0 0 5,741 116 481,693 0 0 contagem.pg_catalog.pg_class 6 6 0 0 0 0 0 1,039 191 315,146 4 16 rio.public.temp0000292754 6 0 0 0 0 0 0 540 114 169,516 0 0 rio.public.tmp_drill_0320 6 5 0 0 0 0 0 1,929 50 387,251 1 54 rio.public.usuarios 6 5 0 0 0 0 0 176 59 134,116 14 22 rio.public.temp0000293662 5 0 0 0 0 0 0 9,249 20 548,706 0 0 contagem.pg_catalog.pg_type 5 5 0 0 0 0 0 428 120 181,331 6 18 brasilia.pg_catalog.pg_class 4 4 0 0 0 0 0 693 267 418,682 17 56 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 221 62 73,526 1 3 rio.public.temp0000293592 4 0 0 0 0 0 0 147 23 11,892 0 0 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 959 258 578,533 6 42 rio.public.temp0000293492 3 0 0 0 0 0 0 5,544 12 328,905 0 0 brasilia.pg_catalog.pg_type 3 3 0 0 0 0 0 270 114 153,178 10 32 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,697 331 1,916,481 133 397 rio.public.temp0000293686 3 0 0 0 0 0 0 5,555 1,859 2,721,387 0 0 rio.public.temp0000293682 2 0 0 0 0 0 0 8 6 1,548 0 0 brasilia.pg_catalog.pg_index 2 2 0 0 0 0 0 84 34 25,549 3 13 rio.auditor.auditor_2026_10 2 0 0 0 0 0 0 115,081 53,174 69,122,967 30,949 598,630 brasilia.public.temp0000241750 2 0 0 0 0 0 0 516 8 31,650 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 397 105 517,309 40 115 rio.public.temp0000293668 2 0 0 0 0 0 0 8 6 1,548 0 0 contagem.public.temp0000227462 1 0 0 0 0 0 0 118 6 7,936 0 0 contagem.public.temp0000227476 1 0 0 0 0 0 0 118 6 7,937 0 0 rio.public.temp0000293634 1 0 0 0 0 0 0 67 65 103,150 0 0 rio.public.temp0000292986 1 0 0 0 0 0 0 65 4 4,438 0 0 contagem.public.temp0000227474 1 0 0 0 0 0 0 118 6 7,937 0 0 brasilia.public.triagens 1 1 0 0 0 0 0 30,319 20,017 52,784,343 917 10,298 brasilia.public.temp0000241780 1 0 0 0 0 0 0 258 4 15,825 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 146 5 28,857 0 0 rio.public.temp0000293688 1 0 0 0 0 0 0 67 6 4,823 0 0 rio.public.temp0000293666 1 0 0 0 0 0 0 1,851 4 109,812 0 0 contagem.public.nf_entrada 1 1 0 0 0 0 0 109 53 102,708 4 6 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,259 6 159,290 0 0 contagem.auditor.auditor_2026_10 1 0 0 0 0 0 0 9,970 6,207 7,754,017 1,848 34,324 brasilia.auditor.auditor_2026_10 1 0 0 0 0 0 0 17,987 9,049 11,838,049 4,556 85,806 brasilia.pg_catalog.pg_depend 1 1 0 0 0 0 0 374 161 205,714 9 102 brasilia.public.temp0000241788 1 0 0 0 0 0 0 258 4 15,825 0 0 Total 319 169 0 0 0 0 0 321,454 114,451 198,926,699 41,620 752,027 Vacuum throughput per table
Key values
- auditor.auditor_2026_10 (17.42) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 2.05 rio.public.temp0000293596 0 0 1.46 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_class 0 0 0.57 rio.pg_catalog.pg_type 0 0 0.22 rio.public.temp0000293000 0 0 0.05 rio.public.temp0000293656 0 0 0.36 rio.pg_catalog.pg_depend 0 0 0.83 contagem.pg_catalog.pg_attribute 0 0 1.2 rio.public.temp0000292760 0 0 0.06 rio.pg_catalog.pg_index 0 0 0.07 brasilia.pg_catalog.pg_attribute 0 0 0.62 rio.pg_catalog.pg_statistic 0 0 1.17 postgres.pg_catalog.pg_shdepend 0 0 0.63 brasilia.pg_catalog.pg_statistic 0 0 0.83 rio.public.temp0000293620 0 0 0.13 contagem.pg_catalog.pg_class 0 0 0.36 rio.public.temp0000292754 0 0 0.01 rio.public.tmp_drill_0320 0 0 0.04 rio.public.usuarios 0 0 0 rio.public.temp0000293662 0 0 0.59 contagem.pg_catalog.pg_type 0 0 0.28 brasilia.pg_catalog.pg_class 0 0 0.24 contagem.pg_catalog.pg_index 0 0 0.13 rio.public.temp0000293592 0 0 0 contagem.pg_catalog.pg_depend 0 0 0.28 rio.public.temp0000293492 0 0 0.13 brasilia.pg_catalog.pg_type 0 0 0.17 rio.pg_toast.pg_toast_2619 0 0 0.23 rio.public.temp0000293686 0 0 0.14 rio.public.temp0000293682 0 0 0.08 brasilia.pg_catalog.pg_index 0 0 0.02 rio.auditor.auditor_2026_10 0 0 17.42 brasilia.public.temp0000241750 0 0 0 brasilia.pg_toast.pg_toast_2619 0 0 0.04 rio.public.temp0000293668 0 0 0.09 contagem.public.temp0000227462 0 0 0 contagem.public.temp0000227476 0 0 0 rio.public.temp0000293634 0 0 0.01 rio.public.temp0000292986 0 0 0 contagem.public.temp0000227474 0 0 0 brasilia.public.triagens 0 0 9.06 brasilia.public.temp0000241780 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000293688 0 0 0 rio.public.temp0000293666 0 0 0.04 contagem.public.nf_entrada 0 0 0.05 contagem.pg_catalog.pg_statistic 0 0 0.06 contagem.auditor.auditor_2026_10 0 0 1.8 brasilia.auditor.auditor_2026_10 0 0 2.75 brasilia.pg_catalog.pg_depend 0 0 0.17 brasilia.public.temp0000241788 0 0 0 Total 0 0 44.44 Tuples removed per table
Key values
- pg_catalog.pg_attribute (126884) Main table with removed tuples on database rio
- 297734 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 33 29 126,884 808,847 30,709 93 19,390 contagem.pg_catalog.pg_attribute 11 11 42,979 272,008 34 160 5,946 rio.public.tmp_drill_0320 6 5 27,891 30,006 416 0 748 brasilia.pg_catalog.pg_attribute 8 8 23,485 185,285 0 122 4,339 rio.pg_catalog.pg_statistic 7 7 12,529 58,154 34 0 9,002 brasilia.public.triagens 1 1 8,792 883,614 0 0 31,153 brasilia.pg_catalog.pg_statistic 7 7 8,519 62,955 81 0 7,497 rio.auditor.auditor_2026_10 2 0 6,745 7,699,132 0 0 373,375 rio.pg_catalog.pg_type 21 17 6,535 50,801 2,864 0 1,510 rio.pg_catalog.pg_depend 11 10 6,171 211,594 2,243 0 2,068 postgres.pg_catalog.pg_shdepend 7 7 5,216 126,283 4 0 1,050 contagem.pg_catalog.pg_statistic 1 1 4,198 7,274 0 0 1,011 rio.pg_catalog.pg_index 9 9 2,409 17,332 11 0 499 rio.pg_catalog.pg_class 21 17 2,077 82,885 6,975 17 2,598 contagem.pg_catalog.pg_depend 3 3 1,884 56,724 6 12 522 contagem.pg_catalog.pg_type 5 5 1,800 11,259 2 16 326 brasilia.auditor.auditor_2026_10 1 0 1,466 1,142,014 0 0 50,933 contagem.public.usuarios 22 0 1,397 528 0 0 44 contagem.pg_catalog.pg_class 6 6 1,376 20,465 4 21 712 rio.pg_toast.pg_toast_2619 3 3 975 2,129 4 14 770 contagem.pg_catalog.pg_index 4 4 952 7,590 1 5 205 brasilia.pg_catalog.pg_class 4 4 861 17,258 0 6 550 brasilia.pg_catalog.pg_depend 1 1 790 17,820 0 16 168 rio.public.usuarios 6 5 654 3,413 359 0 114 brasilia.pg_catalog.pg_type 3 3 345 6,651 0 15 180 contagem.public.nf_entrada 1 1 333 1,640 0 0 87 brasilia.pg_toast.pg_toast_2619 2 2 224 293 0 0 142 contagem.pg_toast.pg_toast_2619 1 1 143 115 0 0 60 brasilia.pg_catalog.pg_index 2 2 104 3,769 0 11 90 contagem.public.temp0000227462 1 0 0 1,409 0 18 110 contagem.public.temp0000227476 1 0 0 1,411 0 18 110 rio.public.temp0000292754 6 0 0 24,034 0 229 539 rio.public.temp0000293634 1 0 0 2,644 0 5 59 rio.public.temp0000293682 2 0 0 52,565 0 0 3,712 rio.public.temp0000292986 1 0 0 2,722 0 0 64 contagem.public.temp0000227474 1 0 0 1,411 0 18 110 rio.public.temp0000293596 23 0 0 603,550 0 0 42,688 rio.public.temp0000293492 3 0 0 78,663 0 0 5,568 brasilia.public.temp0000241780 1 0 0 3,387 0 0 256 rio.public.temp0000293662 5 0 0 131,254 0 0 9,280 rio.public.temp0000292760 10 0 0 43,750 0 361 983 brasilia.public.temp0000241750 2 0 0 6,774 0 0 512 rio.public.temp0000293592 4 0 0 6,995 0 68 156 rio.public.temp0000293688 1 0 0 1,066 0 5 59 rio.public.temp0000293666 1 0 0 26,282 0 0 1,856 rio.public.temp0000293686 3 0 0 78,854 0 0 5,568 rio.public.temp0000293620 7 0 0 93,608 0 178 5,902 rio.public.temp0000293668 2 0 0 52,471 0 0 3,712 contagem.auditor.auditor_2026_10 1 0 0 828,663 0 0 38,041 brasilia.public.temp0000241788 1 0 0 3,387 0 0 256 rio.public.temp0000293656 16 0 0 230,875 0 83 14,061 rio.public.temp0000293000 17 0 0 69,927 0 539 1,573 Total 319 169 297,734 14,133,540 43,747 2,030 650,264 Pages removed per table
Key values
- public.temp0000293000 (539) Main table with removed pages on database rio
- 2030 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000293000 17 0 0 539 rio.public.temp0000292760 10 0 0 361 rio.public.temp0000292754 6 0 0 229 rio.public.temp0000293620 7 0 0 178 contagem.pg_catalog.pg_attribute 11 11 42979 160 brasilia.pg_catalog.pg_attribute 8 8 23485 122 rio.pg_catalog.pg_attribute 33 29 126884 93 rio.public.temp0000293656 16 0 0 83 rio.public.temp0000293592 4 0 0 68 contagem.pg_catalog.pg_class 6 6 1376 21 contagem.public.temp0000227462 1 0 0 18 contagem.public.temp0000227476 1 0 0 18 contagem.public.temp0000227474 1 0 0 18 rio.pg_catalog.pg_class 21 17 2077 17 contagem.pg_catalog.pg_type 5 5 1800 16 brasilia.pg_catalog.pg_depend 1 1 790 16 brasilia.pg_catalog.pg_type 3 3 345 15 rio.pg_toast.pg_toast_2619 3 3 975 14 contagem.pg_catalog.pg_depend 3 3 1884 12 brasilia.pg_catalog.pg_index 2 2 104 11 brasilia.pg_catalog.pg_class 4 4 861 6 contagem.pg_catalog.pg_index 4 4 952 5 rio.public.temp0000293634 1 0 0 5 rio.public.temp0000293688 1 0 0 5 rio.pg_catalog.pg_index 9 9 2409 0 contagem.public.usuarios 22 0 1397 0 rio.pg_catalog.pg_statistic 7 7 12529 0 rio.pg_catalog.pg_depend 11 10 6171 0 rio.public.temp0000293682 2 0 0 0 rio.public.temp0000292986 1 0 0 0 postgres.pg_catalog.pg_shdepend 7 7 5216 0 brasilia.public.triagens 1 1 8792 0 rio.public.temp0000293596 23 0 0 0 rio.public.temp0000293492 3 0 0 0 brasilia.public.temp0000241780 1 0 0 0 rio.public.temp0000293662 5 0 0 0 rio.auditor.auditor_2026_10 2 0 6745 0 rio.public.tmp_drill_0320 6 5 27891 0 brasilia.public.temp0000241750 2 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 143 0 rio.pg_catalog.pg_type 21 17 6535 0 brasilia.pg_catalog.pg_statistic 7 7 8519 0 rio.public.temp0000293666 1 0 0 0 rio.public.temp0000293686 3 0 0 0 contagem.public.nf_entrada 1 1 333 0 brasilia.pg_toast.pg_toast_2619 2 2 224 0 rio.public.temp0000293668 2 0 0 0 contagem.pg_catalog.pg_statistic 1 1 4198 0 contagem.auditor.auditor_2026_10 1 0 0 0 brasilia.auditor.auditor_2026_10 1 0 1466 0 brasilia.public.temp0000241788 1 0 0 0 rio.public.usuarios 6 5 654 0 Total 319 169 297,734 2,030 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 07 00 0 0 01 0 4 02 0 0 03 0 0 04 1 8 05 6 11 06 0 1 07 6 16 08 26 98 09 35 108 10 32 88 11 27 90 12 3 28 13 9 28 14 64 142 15 23 82 16 24 101 17 63 118 18 0 5 19 0 0 20 0 0 21 0 3 22 0 0 23 0 0 - 9.49 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 1s41ms 1s41ms 1s41ms 1s41ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (293942, 404, 'SEIG62701707,2CD8AE797424,9D2618301707,2CD8AE797425$SEIG62414208,2CD8AE5B7168,9D2616114208,2CD8AE5B7169$SEIG62414201,2CD8AE5B711B,9D2616114201,2CD8AE5B711C$SEIG62413938,2CD8AE5B65CE,9D2616113938,2CD8AE5B65CF$SEIG62414155,2CD8AE5B6F21,9D2616114155,2CD8AE5B6F22$SEIG62701097,2CD8AE7959EE,9D2618301097,2CD8AE7959EF$SEIG62701514,2CD8AE796BD9,9D2618301514,2CD8AE796BDA$SEIG62701089,2CD8AE795996,9D2618301089,2CD8AE795997$SEIG62701056,2CD8AE79582B,9D2618301056,2CD8AE79582C$SEIG62701057,2CD8AE795836,9D2618301057,2CD8AE795837$SEIG62703178,2CD8AE79B359,9D2618303178,2CD8AE79B35A$SEIG62703194,2CD8AE79B409,9D2618303194,2CD8AE79B40A$SEIG62703195,2CD8AE79B414,9D2618303195,2CD8AE79B415$SEIG62700118,2CD8AE792FDD,9D2618300118,2CD8AE792FDE$SEIG62701054,2CD8AE795815,9D2618301054,2CD8AE795816$SEIG62701540,2CD8AE796CF7,9D2618301540,2CD8AE796CF8$SEIG62701099,2CD8AE795A04,9D2618301099,2CD8AE795A05$SEIG62703193,2CD8AE79B3FE,9D2618303193,2CD8AE79B3FF$SEIG62703201,2CD8AE79B456,9D2618303201,2CD8AE79B457$SEIG62413939,2CD8AE5B65D9,9D2616113939,2CD8AE5B65DA$SEIG62413953,2CD8AE5B6673,9D2616113953,2CD8AE5B6674$SEIG62414209,2CD8AE5B7173,9D2616114209,2CD8AE5B7174$SEIG62414162,2CD8AE5B6F6E,9D2616114162,2CD8AE5B6F6F$SEIG62414221,2CD8AE5B71F7,9D2616114221,2CD8AE5B71F8', '',0467,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-07 11:09:18 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (293940, 450, 'ZTE3ANNRAM21733,5872C9893597,5872C9893598,ZTEGDC6054E4$ZTE3ANNRCP17648,6C11BA6AC86F,6C11BA6AC870,ZTEGDC6F8583$ZTE3ANNQ4N02715,3CF9F0A8D150,3CF9F0A8D151,ZTEGD6410D96$ZTE3ANNR3J13429,F4E84F87891E,F4E84F87891F,ZTEGD97B963F$ZTE3ANNQ5N07788,3CF9F0AD7BFE,3CF9F0AD7BFF,ZTEGD641D4B3$ZTE3ANNQ8M44233,843C9922D4A1,843C9922D4A2,ZTEGD7BAF436$ZTE3ANNR9F29749,D89A0DA59721,D89A0DA59722,ZTEGDB159B80$ZTE3ANNQ9J13795,843C992D1487,843C992D1488,ZTEGD7BB3E8E$ZTE3ANNRB728610,5872C990D7BD,5872C990D7BE,ZTEGDC619A95$ZTE3ANNR2Q20095,F4E84F828AFA,F4E84F828AFB,ZTEGD97AC139$ZTE3ANNT2V30855,D831398E6202,D831398E6203,ZTEGDD306B06$ZTE3ANNQ5B07433,3CF9F0AF2DF0,3CF9F0AF2DF1,ZTEGD6421D06$ZTE3ANNR5W36063,48D68231D104,48D68231D105,ZTEGDB008CDE$ZTE3ANNR3Y38669,4896D9534B06,4896D9534B07,ZTEGD97EC7C2$ZTE3ANNT2V01612,D831398BB4A0,D831398BB4A1,ZTEGDD2FF8CB$ZTE3ANNT4Q02011,F00C5154FD7A,F00C5154FD7B,ZTEGDE358510$ZTE3ANNQ5200481,3CF9F0A7365C,3CF9F0A7365D,ZTEGD640C918$ZTE3ANNQ9J16949,843C992D5E73,843C992D5E74,ZTEGD7BB4AE0$ZTE3ANNRC509223,6C11BA630201,6C11BA630202,ZTEGDC6E39C6$ZTE3ANNRC573845,6C11BA68EC95,6C11BA68EC96,ZTEGDC6F3634$ZTE3ANNT4Q01033,F00C5154E68E,F00C5154E68F,ZTEGDE35813E$ZTE3ANNR5W35048,48D68231B93A,48D68231B93B,ZTEGDB0088E7$ZTE3ANNQ8F14384,689E29FD73FD,689E29FD73FE,ZTEGD7BA3500$ZTE3ANNT4Q00764,F00C5154E040,F00C5154E041,ZTEGDE358031$ZTE3ANNRC511486,6C11BA63370B,6C11BA63370C,ZTEGDC6E429D$ZTE3ANNR4N54703,4896D95A5D32,4896D95A5D33,ZTEGD97FF574$ZTE3ANNQ4N14549,3CF9F0A9E6AC,3CF9F0A9E6AD,ZTEGD6413BD0$ZTE3ANNRCP13777,6C11BA6A6DB5,6C11BA6A6DB6,ZTEGDC6F7664$ZTE3ANNR5W57180,48D68233BFF2,48D68233BFF3,ZTEGDB00DF5B$ZTE3ANNR3Y02230,4896D94FF4FC,4896D94FF4FD,ZTEGD97E396B$ZTE3ANNT4P25397,F00C514DF9DC,F00C514DF9DD,ZTEGDE3459CB$ZTE3ANNT3H09472,D8313997A198,D8313997A199,ZTEGDD31F59F$ZTE3ANNR7B48215,3891484D56B1,3891484D56B2,ZTEGDB084DB7$ZTE3ANNT3H48451,D831399B332A,D831399B332B,ZTEGDD328DE2$ZTE3ANNQ4N09386,3CF9F0A96DAA,3CF9F0A96DAB,ZTEGD64127A5$ZTE3ANNR2Q43327,F4E84F84AB7A,F4E84F84AB7B,ZTEGD97B1BF9$ZTE3ANNQ9J18963,843C992D8DA7,843C992D8DA8,ZTEGD7BB52BE$ZTE3ANNRAD16506,D89A0DAF5D3F,D89A0DAF5D40,ZTEGDB173C85$ZTE3ANNRAD12877,D89A0DAF0831,D89A0DAF0832,ZTEGDB172E58$ZTE3ANNR6R46940,48D68239D0EA,48D68239D0EB,ZTEGDB01E22F', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-07 14:06:14 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60352, 406, 'ZTE3ANNQ8M23715,843C9920F3BD,843C9920F3BE,ZTEGD7BAA410$ZTE3ANNT7U23425,589204022500,589204022501,ZTEGDF034875$ZTE3ANNR6R55252,48D6823A93BA,48D6823A93BB,ZTEGDB0202A7$ZTE3ANNRB721224,5872C9902AA1,5872C9902AA2,ZTEGDC617DBB$ZTE3ANNT3H72922,D831399D70B4,D831399D70B5,ZTEGDD32ED79$ZTE3ANNT7U23278,58920402218E,58920402218F,ZTEGDF0347E2$ZTE3ANNQ8M18921,843C99208361,843C99208362,ZTEGD7BA9156$ZTE3ANNT2V02328,D831398BC568,D831398BC569,ZTEGDD2FFB97$ZTE3ANNQ8M44747,843C9922E0AD,843C9922E0AE,ZTEGD7BAF638$ZTE3ANNR7B47517,3891484D4655,3891484D4656,ZTEGDB084AFD$ZTE3ANNR8C24248,38914850BF57,38914850BF58,ZTEGDB08DF28$ZTE3ANNR9W44587,D89A0DAC7125,D89A0DAC7126,ZTEGDB16BFD6$ZTE3ANNRAM63395,5872C98D060B,5872C98D060C,ZTEGDC60F7A2$ZTE3ANNR5W25386,48D68230D6C6,48D68230D6C7,ZTEGDB006329$ZTE3ANNRAD23611,D89A0DB003C5,D89A0DB003C6,ZTEGDB175846$ZTE3ANNQ4A00640,3CF9F0AA0746,3CF9F0AA0747,ZTEGD641413F$ZTE3ANNR3J05999,F4E84F86DAFA,F4E84F86DAFB,ZTEGD97B7939$ZTE3ANNT4Q06886,F00C51556FBC,F00C51556FBD,ZTEGDE35981B$ZTE3ANNR3J05786,F4E84F86D5FC,F4E84F86D5FD,ZTEGD97B7864$ZTE3ANNT3H23534,D8313998EB2C,D8313998EB2D,ZTEGDD322C8D$ZTE3ANNR4N10750,4896D956570C,4896D956570D,ZTEGD97F49C3$ZTE3ANNRC575768,6C11BA6919A7,6C11BA6919A8,ZTEGDC6F3DB7$ZTE3ANNRCB66148,D8313923DD56,D8313923DD57,ZTEGDD2AB7F9$ZTE3ANNQ8122625,689E29BDF111,689E29BDF112,ZTEGD7B792F1$ZTE3ANNT3J12733,D83139A115C0,D83139A115C1,ZTEGDD3388FB$ZTE3ANNT4Q05228,F00C515548E0,F00C515548E1,ZTEGDE3591A1$ZTE3ANNRAM35189,5872C98A70F7,5872C98A70F8,ZTEGDC608974$ZTE3ANNQ4N01586,3CF9F0A8B6DA,3CF9F0A8B6DB,ZTEGD641092D$ZTE3ANNQ9J21669,843C992DCD13,843C992DCD14,ZTEGD7BB5D50$ZTE3ANNRCP49336,6C11BA6DAF1F,6C11BA6DAF20,ZTEGDC70014B$ZTE3ANNRC554109,6C11BA671E05,6C11BA671E06,ZTEGDC6EE91C', '',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":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-07 13:18:08 Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 1 1s 1s 1s 1s drop table if exists temp0000293682;-
DROP TABLE IF EXISTS temp0000293682;
Date: 2026-10-07 17:05:41 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000293682;
Date: 2026-10-07 17:05:41 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 1s41ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (293940, 450, 'ZTE3ANNRAM21733,5872C9893597,5872C9893598,ZTEGDC6054E4$ZTE3ANNRCP17648,6C11BA6AC86F,6C11BA6AC870,ZTEGDC6F8583$ZTE3ANNQ4N02715,3CF9F0A8D150,3CF9F0A8D151,ZTEGD6410D96$ZTE3ANNR3J13429,F4E84F87891E,F4E84F87891F,ZTEGD97B963F$ZTE3ANNQ5N07788,3CF9F0AD7BFE,3CF9F0AD7BFF,ZTEGD641D4B3$ZTE3ANNQ8M44233,843C9922D4A1,843C9922D4A2,ZTEGD7BAF436$ZTE3ANNR9F29749,D89A0DA59721,D89A0DA59722,ZTEGDB159B80$ZTE3ANNQ9J13795,843C992D1487,843C992D1488,ZTEGD7BB3E8E$ZTE3ANNRB728610,5872C990D7BD,5872C990D7BE,ZTEGDC619A95$ZTE3ANNR2Q20095,F4E84F828AFA,F4E84F828AFB,ZTEGD97AC139$ZTE3ANNT2V30855,D831398E6202,D831398E6203,ZTEGDD306B06$ZTE3ANNQ5B07433,3CF9F0AF2DF0,3CF9F0AF2DF1,ZTEGD6421D06$ZTE3ANNR5W36063,48D68231D104,48D68231D105,ZTEGDB008CDE$ZTE3ANNR3Y38669,4896D9534B06,4896D9534B07,ZTEGD97EC7C2$ZTE3ANNT2V01612,D831398BB4A0,D831398BB4A1,ZTEGDD2FF8CB$ZTE3ANNT4Q02011,F00C5154FD7A,F00C5154FD7B,ZTEGDE358510$ZTE3ANNQ5200481,3CF9F0A7365C,3CF9F0A7365D,ZTEGD640C918$ZTE3ANNQ9J16949,843C992D5E73,843C992D5E74,ZTEGD7BB4AE0$ZTE3ANNRC509223,6C11BA630201,6C11BA630202,ZTEGDC6E39C6$ZTE3ANNRC573845,6C11BA68EC95,6C11BA68EC96,ZTEGDC6F3634$ZTE3ANNT4Q01033,F00C5154E68E,F00C5154E68F,ZTEGDE35813E$ZTE3ANNR5W35048,48D68231B93A,48D68231B93B,ZTEGDB0088E7$ZTE3ANNQ8F14384,689E29FD73FD,689E29FD73FE,ZTEGD7BA3500$ZTE3ANNT4Q00764,F00C5154E040,F00C5154E041,ZTEGDE358031$ZTE3ANNRC511486,6C11BA63370B,6C11BA63370C,ZTEGDC6E429D$ZTE3ANNR4N54703,4896D95A5D32,4896D95A5D33,ZTEGD97FF574$ZTE3ANNQ4N14549,3CF9F0A9E6AC,3CF9F0A9E6AD,ZTEGD6413BD0$ZTE3ANNRCP13777,6C11BA6A6DB5,6C11BA6A6DB6,ZTEGDC6F7664$ZTE3ANNR5W57180,48D68233BFF2,48D68233BFF3,ZTEGDB00DF5B$ZTE3ANNR3Y02230,4896D94FF4FC,4896D94FF4FD,ZTEGD97E396B$ZTE3ANNT4P25397,F00C514DF9DC,F00C514DF9DD,ZTEGDE3459CB$ZTE3ANNT3H09472,D8313997A198,D8313997A199,ZTEGDD31F59F$ZTE3ANNR7B48215,3891484D56B1,3891484D56B2,ZTEGDB084DB7$ZTE3ANNT3H48451,D831399B332A,D831399B332B,ZTEGDD328DE2$ZTE3ANNQ4N09386,3CF9F0A96DAA,3CF9F0A96DAB,ZTEGD64127A5$ZTE3ANNR2Q43327,F4E84F84AB7A,F4E84F84AB7B,ZTEGD97B1BF9$ZTE3ANNQ9J18963,843C992D8DA7,843C992D8DA8,ZTEGD7BB52BE$ZTE3ANNRAD16506,D89A0DAF5D3F,D89A0DAF5D40,ZTEGDB173C85$ZTE3ANNRAD12877,D89A0DAF0831,D89A0DAF0832,ZTEGDB172E58$ZTE3ANNR6R46940,48D68239D0EA,48D68239D0EB,ZTEGDB01E22F', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);[ Date: 2026-10-07 14:06:12 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 1s DROP TABLE IF EXISTS temp0000293682;[ Date: 2026-10-07 17:05:41 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 2,570 Total read queries
- 974 Total write queries
Queries by database
Key values
- rio Main database
- 2,437 Requests
- 4h23m51s (rio)
- Main time consuming database
Database Request type Count Duration brasilia Total 1,193 1h28m58s copy to 139 10m43s ddl 130 1m30s others 249 9m44s select 675 1h7m1s contagem Total 453 8m42s copy to 116 1m22s ddl 20 18s483ms others 6 2m53s select 311 4m7s rio Total 2,437 4h23m51s copy to 148 29m4s ddl 421 37m20s others 286 24m55s select 1,582 2h52m31s testes Total 2 684ms select 2 684ms Queries by user
Key values
- intelifix Main user
- 3,964 Requests
User Request type Count Duration etiquetas Total 11 2s40ms select 11 2s40ms intelifix Total 3,964 6h44s copy to 403 41m10s ddl 571 39m8s others 541 37m33s select 2,449 4h2m52s lenon Total 110 47s220ms select 110 47s220ms Duration by user
Key values
- 6h44s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 11 2s40ms select 11 2s40ms intelifix Total 3,964 6h44s copy to 403 41m10s ddl 571 39m8s others 541 37m33s select 2,449 4h2m52s lenon Total 110 47s220ms select 110 47s220ms Queries by host
Key values
- [local] Main host
- 4,085 Requests
- 6h1m33s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 2,961 Requests
- 3h17m31s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-10-07 10:54:36 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,057 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m19s analyze verbose;[ Date: 2026-10-07 05:09:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 6m41s analyze verbose;[ Date: 2026-10-07 05:16:02 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
3 6m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-07 07:11:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m12s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030786, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-07 07:36:24 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 6m11s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030811, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-07 14:26:26 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 5m58s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030838, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-07 14:54:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 5m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-07 15:10:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m50s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030795, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-07 10:05:27 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 5m50s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030787, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-07 08:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 5m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-07 09:10:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-07 13:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m47s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030858, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-07 15:48:50 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 5m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-07 12:10:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-07 14:10:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-07 10:10:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m40s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030807, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-07 10:56:10 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m40s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030808, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-07 11:23:02 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-07 08:10:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-07 17:10:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-07 11:10:18 - 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 1h33m29s 48 2s100ms 6m27s 1m56s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 07 07 3 6m59s 2m19s 08 3 5m50s 1m56s 09 3 6m7s 2m2s 10 3 6m 2m 11 3 5m37s 1m52s 12 3 6m7s 2m2s 13 3 6m5s 2m1s 14 3 6m5s 2m1s 15 3 6m11s 2m3s 16 3 5m26s 1m48s 17 3 5m51s 1m57s 18 3 5m24s 1m48s 19 3 5m22s 1m47s 20 3 5m32s 1m50s 21 3 5m26s 1m48s 22 3 5m21s 1m47s [ User: intelifix - Total duration: 1h33m29s - Times executed: 48 ]
[ Application: psql - Total duration: 1h33m29s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-07 07:11:28 Duration: 6m27s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-07 15:10:55 Duration: 5m53s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-07 09:10:50 Duration: 5m49s Database: rio User: intelifix Remote: [local] Application: psql
2 1h3m25s 48 218ms 3m54s 1m19s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 07 07 3 4m39s 1m33s 08 3 3m53s 1m17s 09 3 4m15s 1m25s 10 3 4m7s 1m22s 11 3 3m47s 1m15s 12 3 4m26s 1m28s 13 3 4m4s 1m21s 14 3 4m17s 1m25s 15 3 4m2s 1m20s 16 3 3m37s 1m12s 17 3 3m56s 1m18s 18 3 3m41s 1m13s 19 3 3m38s 1m12s 20 3 3m38s 1m12s 21 3 3m38s 1m12s 22 3 3m41s 1m13s [ User: intelifix - Total duration: 1h3m25s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m25s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-07 12:15:31 Duration: 3m54s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-07 14:15:20 Duration: 3m45s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-07 09:15:22 Duration: 3m42s Database: brasilia User: intelifix Remote: [local] Application: psql
3 59m13s 154 150ms 6m12s 23s77ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 07 07 11 6m28s 35s349ms 08 21 6m30s 18s609ms 09 19 2m10s 6s851ms 10 16 11m58s 44s907ms 11 11 5m46s 31s454ms 12 6 2s489ms 414ms 13 3 1s157ms 385ms 14 30 13m34s 27s139ms 15 15 5m59s 23s971ms 16 3 14s728ms 4s909ms 17 17 6m14s 22s23ms 18 2 13s8ms 6s504ms [ User: intelifix - Total duration: 59m13s - Times executed: 154 ]
[ Application: [unknown] - Total duration: 59m13s - Times executed: 154 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030786, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-07 07:36:24 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030811, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-07 14:26:26 Duration: 6m11s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030838, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-07 14:54:07 Duration: 5m58s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 18m37s 3 2m36s 9m19s 6m12s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 07 05 3 18m37s 6m12s [ User: intelifix - Total duration: 18m37s - Times executed: 3 ]
[ Application: psql - Total duration: 18m37s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-07 05:09:20 Duration: 9m19s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-07 05:16:02 Duration: 6m41s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-07 05:18:39 Duration: 2m36s Database: contagem User: intelifix Remote: [local] Application: psql
5 13m8s 66 10s384ms 21s443ms 11s942ms create table temp0000293596 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 07 07 3 43s320ms 14s440ms 08 6 1m7s 11s295ms 09 18 3m28s 11s601ms 10 11 2m6s 11s519ms 11 3 36s589ms 12s196ms 14 16 3m21s 12s601ms 15 9 1m43s 11s481ms [ User: intelifix - Total duration: 13m8s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 13m8s - Times executed: 66 ]
-
CREATE TABLE temp0000293596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 07:29:27 Duration: 21s443ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 09:28:15 Duration: 16s800ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 10:22:39 Duration: 15s697ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 10m4s 841 151ms 4s 718ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 07 07 6 6s659ms 1s109ms 08 90 1m3s 705ms 09 167 2m5s 754ms 10 118 1m25s 722ms 11 72 47s633ms 661ms 12 29 19s212ms 662ms 13 36 30s318ms 842ms 14 94 1m12s 767ms 15 79 52s915ms 669ms 16 87 1m 699ms 17 63 39s781ms 631ms [ User: intelifix - Total duration: 10m4s - Times executed: 841 ]
[ Application: [unknown] - Total duration: 10m4s - Times executed: 841 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (293942, 404, 'SEIG62701707,2CD8AE797424,9D2618301707,2CD8AE797425$SEIG62414208,2CD8AE5B7168,9D2616114208,2CD8AE5B7169$SEIG62414201,2CD8AE5B711B,9D2616114201,2CD8AE5B711C$SEIG62413938,2CD8AE5B65CE,9D2616113938,2CD8AE5B65CF$SEIG62414155,2CD8AE5B6F21,9D2616114155,2CD8AE5B6F22$SEIG62701097,2CD8AE7959EE,9D2618301097,2CD8AE7959EF$SEIG62701514,2CD8AE796BD9,9D2618301514,2CD8AE796BDA$SEIG62701089,2CD8AE795996,9D2618301089,2CD8AE795997$SEIG62701056,2CD8AE79582B,9D2618301056,2CD8AE79582C$SEIG62701057,2CD8AE795836,9D2618301057,2CD8AE795837$SEIG62703178,2CD8AE79B359,9D2618303178,2CD8AE79B35A$SEIG62703194,2CD8AE79B409,9D2618303194,2CD8AE79B40A$SEIG62703195,2CD8AE79B414,9D2618303195,2CD8AE79B415$SEIG62700118,2CD8AE792FDD,9D2618300118,2CD8AE792FDE$SEIG62701054,2CD8AE795815,9D2618301054,2CD8AE795816$SEIG62701540,2CD8AE796CF7,9D2618301540,2CD8AE796CF8$SEIG62701099,2CD8AE795A04,9D2618301099,2CD8AE795A05$SEIG62703193,2CD8AE79B3FE,9D2618303193,2CD8AE79B3FF$SEIG62703201,2CD8AE79B456,9D2618303201,2CD8AE79B457$SEIG62413939,2CD8AE5B65D9,9D2616113939,2CD8AE5B65DA$SEIG62413953,2CD8AE5B6673,9D2616113953,2CD8AE5B6674$SEIG62414209,2CD8AE5B7173,9D2616114209,2CD8AE5B7174$SEIG62414162,2CD8AE5B6F6E,9D2616114162,2CD8AE5B6F6F$SEIG62414221,2CD8AE5B71F7,9D2616114221,2CD8AE5B71F8', '',0467,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-07 11:09:18 Duration: 4s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (293940, 450, 'ZTE3ANNRAM21733,5872C9893597,5872C9893598,ZTEGDC6054E4$ZTE3ANNRCP17648,6C11BA6AC86F,6C11BA6AC870,ZTEGDC6F8583$ZTE3ANNQ4N02715,3CF9F0A8D150,3CF9F0A8D151,ZTEGD6410D96$ZTE3ANNR3J13429,F4E84F87891E,F4E84F87891F,ZTEGD97B963F$ZTE3ANNQ5N07788,3CF9F0AD7BFE,3CF9F0AD7BFF,ZTEGD641D4B3$ZTE3ANNQ8M44233,843C9922D4A1,843C9922D4A2,ZTEGD7BAF436$ZTE3ANNR9F29749,D89A0DA59721,D89A0DA59722,ZTEGDB159B80$ZTE3ANNQ9J13795,843C992D1487,843C992D1488,ZTEGD7BB3E8E$ZTE3ANNRB728610,5872C990D7BD,5872C990D7BE,ZTEGDC619A95$ZTE3ANNR2Q20095,F4E84F828AFA,F4E84F828AFB,ZTEGD97AC139$ZTE3ANNT2V30855,D831398E6202,D831398E6203,ZTEGDD306B06$ZTE3ANNQ5B07433,3CF9F0AF2DF0,3CF9F0AF2DF1,ZTEGD6421D06$ZTE3ANNR5W36063,48D68231D104,48D68231D105,ZTEGDB008CDE$ZTE3ANNR3Y38669,4896D9534B06,4896D9534B07,ZTEGD97EC7C2$ZTE3ANNT2V01612,D831398BB4A0,D831398BB4A1,ZTEGDD2FF8CB$ZTE3ANNT4Q02011,F00C5154FD7A,F00C5154FD7B,ZTEGDE358510$ZTE3ANNQ5200481,3CF9F0A7365C,3CF9F0A7365D,ZTEGD640C918$ZTE3ANNQ9J16949,843C992D5E73,843C992D5E74,ZTEGD7BB4AE0$ZTE3ANNRC509223,6C11BA630201,6C11BA630202,ZTEGDC6E39C6$ZTE3ANNRC573845,6C11BA68EC95,6C11BA68EC96,ZTEGDC6F3634$ZTE3ANNT4Q01033,F00C5154E68E,F00C5154E68F,ZTEGDE35813E$ZTE3ANNR5W35048,48D68231B93A,48D68231B93B,ZTEGDB0088E7$ZTE3ANNQ8F14384,689E29FD73FD,689E29FD73FE,ZTEGD7BA3500$ZTE3ANNT4Q00764,F00C5154E040,F00C5154E041,ZTEGDE358031$ZTE3ANNRC511486,6C11BA63370B,6C11BA63370C,ZTEGDC6E429D$ZTE3ANNR4N54703,4896D95A5D32,4896D95A5D33,ZTEGD97FF574$ZTE3ANNQ4N14549,3CF9F0A9E6AC,3CF9F0A9E6AD,ZTEGD6413BD0$ZTE3ANNRCP13777,6C11BA6A6DB5,6C11BA6A6DB6,ZTEGDC6F7664$ZTE3ANNR5W57180,48D68233BFF2,48D68233BFF3,ZTEGDB00DF5B$ZTE3ANNR3Y02230,4896D94FF4FC,4896D94FF4FD,ZTEGD97E396B$ZTE3ANNT4P25397,F00C514DF9DC,F00C514DF9DD,ZTEGDE3459CB$ZTE3ANNT3H09472,D8313997A198,D8313997A199,ZTEGDD31F59F$ZTE3ANNR7B48215,3891484D56B1,3891484D56B2,ZTEGDB084DB7$ZTE3ANNT3H48451,D831399B332A,D831399B332B,ZTEGDD328DE2$ZTE3ANNQ4N09386,3CF9F0A96DAA,3CF9F0A96DAB,ZTEGD64127A5$ZTE3ANNR2Q43327,F4E84F84AB7A,F4E84F84AB7B,ZTEGD97B1BF9$ZTE3ANNQ9J18963,843C992D8DA7,843C992D8DA8,ZTEGD7BB52BE$ZTE3ANNRAD16506,D89A0DAF5D3F,D89A0DAF5D40,ZTEGDB173C85$ZTE3ANNRAD12877,D89A0DAF0831,D89A0DAF0832,ZTEGDB172E58$ZTE3ANNR6R46940,48D68239D0EA,48D68239D0EB,ZTEGDB01E22F', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-07 14:06:14 Duration: 3s685ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60352, 406, 'ZTE3ANNQ8M23715,843C9920F3BD,843C9920F3BE,ZTEGD7BAA410$ZTE3ANNT7U23425,589204022500,589204022501,ZTEGDF034875$ZTE3ANNR6R55252,48D6823A93BA,48D6823A93BB,ZTEGDB0202A7$ZTE3ANNRB721224,5872C9902AA1,5872C9902AA2,ZTEGDC617DBB$ZTE3ANNT3H72922,D831399D70B4,D831399D70B5,ZTEGDD32ED79$ZTE3ANNT7U23278,58920402218E,58920402218F,ZTEGDF0347E2$ZTE3ANNQ8M18921,843C99208361,843C99208362,ZTEGD7BA9156$ZTE3ANNT2V02328,D831398BC568,D831398BC569,ZTEGDD2FFB97$ZTE3ANNQ8M44747,843C9922E0AD,843C9922E0AE,ZTEGD7BAF638$ZTE3ANNR7B47517,3891484D4655,3891484D4656,ZTEGDB084AFD$ZTE3ANNR8C24248,38914850BF57,38914850BF58,ZTEGDB08DF28$ZTE3ANNR9W44587,D89A0DAC7125,D89A0DAC7126,ZTEGDB16BFD6$ZTE3ANNRAM63395,5872C98D060B,5872C98D060C,ZTEGDC60F7A2$ZTE3ANNR5W25386,48D68230D6C6,48D68230D6C7,ZTEGDB006329$ZTE3ANNRAD23611,D89A0DB003C5,D89A0DB003C6,ZTEGDB175846$ZTE3ANNQ4A00640,3CF9F0AA0746,3CF9F0AA0747,ZTEGD641413F$ZTE3ANNR3J05999,F4E84F86DAFA,F4E84F86DAFB,ZTEGD97B7939$ZTE3ANNT4Q06886,F00C51556FBC,F00C51556FBD,ZTEGDE35981B$ZTE3ANNR3J05786,F4E84F86D5FC,F4E84F86D5FD,ZTEGD97B7864$ZTE3ANNT3H23534,D8313998EB2C,D8313998EB2D,ZTEGDD322C8D$ZTE3ANNR4N10750,4896D956570C,4896D956570D,ZTEGD97F49C3$ZTE3ANNRC575768,6C11BA6919A7,6C11BA6919A8,ZTEGDC6F3DB7$ZTE3ANNRCB66148,D8313923DD56,D8313923DD57,ZTEGDD2AB7F9$ZTE3ANNQ8122625,689E29BDF111,689E29BDF112,ZTEGD7B792F1$ZTE3ANNT3J12733,D83139A115C0,D83139A115C1,ZTEGDD3388FB$ZTE3ANNT4Q05228,F00C515548E0,F00C515548E1,ZTEGDE3591A1$ZTE3ANNRAM35189,5872C98A70F7,5872C98A70F8,ZTEGDC608974$ZTE3ANNQ4N01586,3CF9F0A8B6DA,3CF9F0A8B6DB,ZTEGD641092D$ZTE3ANNQ9J21669,843C992DCD13,843C992DCD14,ZTEGD7BB5D50$ZTE3ANNRCP49336,6C11BA6DAF1F,6C11BA6DAF20,ZTEGDC70014B$ZTE3ANNRC554109,6C11BA671E05,6C11BA671E06,ZTEGDC6EE91C', '',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":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-07 13:18:08 Duration: 3s10ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
7 9m34s 47 11s458ms 13s59ms 12s225ms create table temp0000293656 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 07 14 40 8m5s 12s144ms 15 7 1m28s 12s690ms [ User: intelifix - Total duration: 9m34s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 9m34s - Times executed: 47 ]
-
CREATE TABLE temp0000293656 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 15:02:33 Duration: 13s59ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293656 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 14:26:30 Duration: 12s986ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293656 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 15:04:14 Duration: 12s959ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 7m21s 275 185ms 6s385ms 1s606ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 07 00 12 23s477ms 1s956ms 01 12 18s841ms 1s570ms 02 12 18s676ms 1s556ms 03 12 18s689ms 1s557ms 04 12 17s698ms 1s474ms 05 12 17s467ms 1s455ms 06 12 17s924ms 1s493ms 07 12 18s276ms 1s523ms 08 12 20s763ms 1s730ms 09 12 19s906ms 1s658ms 10 12 21s764ms 1s813ms 11 12 18s645ms 1s553ms 12 12 20s513ms 1s709ms 13 12 20s74ms 1s672ms 14 12 22s87ms 1s840ms 15 12 20s251ms 1s687ms 16 12 18s341ms 1s528ms 17 12 17s866ms 1s488ms 18 12 17s571ms 1s464ms 19 11 17s404ms 1s582ms 20 12 20s728ms 1s727ms 21 12 17s355ms 1s446ms 22 12 17s417ms 1s451ms [ User: intelifix - Total duration: 7m21s - Times executed: 275 ]
[ Application: psql - Total duration: 7m21s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-07 00:05:20 Duration: 6s385ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-07 10:05:12 Duration: 5s550ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-07 08:35:09 Duration: 4s348ms Database: rio User: intelifix Remote: [local] Application: psql
9 5m20s 734 150ms 2s164ms 436ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 07 07 12 7s982ms 665ms 08 112 51s250ms 457ms 09 95 39s182ms 412ms 10 108 43s9ms 398ms 11 134 48s916ms 365ms 12 3 2s109ms 703ms 13 19 9s931ms 522ms 14 73 44s531ms 610ms 15 83 35s329ms 425ms 16 67 27s55ms 403ms 17 28 11s217ms 400ms [ User: intelifix - Total duration: 5m20s - Times executed: 734 ]
[ Application: [unknown] - Total duration: 5m20s - Times executed: 734 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "294173", "modelo" : "141", "itens" : "229783817677,229687227880,229784390518,229933597985,229810540612,229805528696,216942165169,229816616883,229810123545,229809000114,216940010616,229805358501,229813676484,229745216065,229753957681,229673164769,229728629395,229743673042,229752442843,229810616679,229933307171,229669514951,229932943747,229739954048,229739960211,229749359095,229737525775,229751557492", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246597155870,226403574452,246598222731,226001639008,246642932437,246596214858,246471125366,246630385353,246618888383,246627576684,246463934451,246575097791,246630783956,246543888708,246560997582,246491114455,246110126868,246544833839,246531734345,246642159802,246134801926,246515484252,226119073443,246569733138,246568932443,246529853657,246527643946,246629886382,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-07 14:41:40 Duration: 2s164ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "293982", "modelo" : "464", "itens" : "241742399313,241820207377,241764808390,241764692948,241827190417,241820508394,241777668287,241760237989,241764861932,241747550815,241760246778,241770195269,241775685468,241767383850,241738301618,241777809615,241742565064,241760120426,241764781318,241772252036,241814173052,241745407496,241813941739,241771278898,241813772631,241815558911,241818613137,241812751735,241763734863,241767660219,241764216986,241740745975,241818815154,241745810522,241764915775,241745396485,241777657579,241768700208,241812865965,241760107292,241762679899,241742525969,241777855253,241742142240,241778925470,241743179400,241743839093,241740639803,241760154345,241688088299,241815450214,241761401628,241813743739,241763382225,241759484852,241739643657,241738604150,241815457183,241770209917,241744698404", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-07 07:36:50 Duration: 1s821ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "294255", "modelo" : "129", "itens" : "D06EDE78C048,981E19B0E82D,B8668518FD87,E8ADA6BC2E92,34495B8E6894,ECBEDDFFCD0D,3093BCC5BA79,B866851D12C7,D06EDE78B50B,B866850CC553", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-07 17:11:32 Duration: 1s550ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 5m13s 158 157ms 12s12ms 1s983ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 07 00 6 18s121ms 3s20ms 01 6 7s269ms 1s211ms 02 6 6s339ms 1s56ms 03 5 8s727ms 1s745ms 04 6 9s5ms 1s500ms 05 4 2s986ms 746ms 07 12 29s594ms 2s466ms 08 12 36s461ms 3s38ms 09 12 31s271ms 2s605ms 10 12 28s568ms 2s380ms 11 12 25s134ms 2s94ms 12 11 27s236ms 2s476ms 13 7 5s66ms 723ms 14 11 24s127ms 2s193ms 15 12 26s319ms 2s193ms 16 9 10s710ms 1s190ms 17 4 2s18ms 504ms 21 5 7s197ms 1s439ms 22 6 7s178ms 1s196ms [ User: intelifix - Total duration: 5m13s - Times executed: 158 ]
[ Application: psql - Total duration: 5m13s - Times executed: 158 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-07 00:05:13 Duration: 12s12ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-07 08:15:08 Duration: 6s694ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-07 07:45:07 Duration: 6s370ms Database: rio User: intelifix Remote: [local] Application: psql
11 5m12s 57 1s410ms 12s590ms 5s485ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 07 07 1 6s443ms 6s443ms 08 2 10s391ms 5s195ms 09 3 24s579ms 8s193ms 10 4 13s665ms 3s416ms 11 7 22s345ms 3s192ms 12 2 4s606ms 2s303ms 13 4 30s504ms 7s626ms 14 9 59s646ms 6s627ms 15 4 26s254ms 6s563ms 16 13 1m23s 6s445ms 17 7 28s364ms 4s52ms 18 1 2s85ms 2s85ms [ User: intelifix - Total duration: 5m12s - Times executed: 57 ]
[ Application: [unknown] - Total duration: 5m12s - Times executed: 57 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-07', 0320, '', '', 0, 6, '2026-10-01');
Date: 2026-10-07 15:06:48 Duration: 12s590ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-07', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-07 13:36:04 Duration: 11s886ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-07', 0320, '', '', 0, 6, '2026-10-01');
Date: 2026-10-07 14:20:25 Duration: 11s591ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 2m11s 4 4s124ms 1m1s 32s957ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 07 20 2 1m6s 33s180ms 23 2 1m5s 32s734ms [ User: intelifix - Total duration: 2m11s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m11s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-07 20:08:33 Duration: 1m1s 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-10-07 23:16:32 Duration: 1m1s 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-10-07 20:10:30 Duration: 4s483ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1m50s 10 10s890ms 11s302ms 11s55ms create table temp0000293620 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 07 10 10 1m50s 11s55ms [ User: intelifix - Total duration: 1m50s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 1m50s - Times executed: 10 ]
-
CREATE TABLE temp0000293620 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 10:24:15 Duration: 11s302ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293620 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 10:24:33 Duration: 11s229ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293620 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 10:32:09 Duration: 11s58ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 1m46s 6 3s188ms 39s753ms 17s765ms 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 #14
Day Hour Count Duration Avg duration Oct 07 20 3 53s217ms 17s739ms 23 3 53s374ms 17s791ms [ User: intelifix - Total duration: 1m46s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m46s - 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-10-07 23:14:21 Duration: 39s753ms 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-10-07 20:06:22 Duration: 39s639ms 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-10-07 20:10:06 Duration: 10s389ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 1m44s 4 336ms 52s178ms 26s187ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 07 20 2 52s521ms 26s260ms 23 2 52s229ms 26s114ms [ User: intelifix - Total duration: 1m44s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m44s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-07 20:05:40 Duration: 52s178ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-07 23:13:39 Duration: 51s893ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-07 20:09:56 Duration: 343ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1m44s 35 606ms 9s599ms 2s984ms 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 Oct 07 08 3 10s698ms 3s566ms 09 3 13s810ms 4s603ms 10 2 8s831ms 4s415ms 11 2 16s13ms 8s6ms 12 3 5s263ms 1s754ms 13 3 3s965ms 1s321ms 14 2 7s704ms 3s852ms 15 1 7s762ms 7s762ms 16 2 9s608ms 4s804ms 17 3 11s213ms 3s737ms 18 2 1s522ms 761ms 19 2 1s607ms 803ms 20 3 2s736ms 912ms 21 2 2s51ms 1s25ms 22 2 1s680ms 840ms [ User: intelifix - Total duration: 1m44s - Times executed: 35 ]
[ Application: psql - Total duration: 1m44s - Times executed: 35 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-07 11:40:10 Duration: 9s599ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-07 15:20:09 Duration: 7s762ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-07 09:40:07 Duration: 6s514ms Database: rio User: intelifix Remote: [local] Application: psql
17 1m39s 29 219ms 15s191ms 3s416ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 07 07 1 15s191ms 15s191ms 08 2 3s965ms 1s982ms 09 4 13s622ms 3s405ms 10 4 15s714ms 3s928ms 11 1 3s658ms 3s658ms 14 12 34s934ms 2s911ms 15 3 10s568ms 3s522ms 17 2 1s430ms 715ms [ User: intelifix - Total duration: 1m39s - Times executed: 29 ]
[ Application: psql - Total duration: 1m39s - Times executed: 29 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030786);
Date: 2026-10-07 07:29:51 Duration: 15s191ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030798);
Date: 2026-10-07 10:24:32 Duration: 10s196ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030795);
Date: 2026-10-07 09:59:15 Duration: 7s727ms Database: rio User: intelifix Remote: [local] Application: psql
18 1m23s 53 569ms 21s24ms 1s580ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 07 08 3 2s539ms 846ms 09 3 2s14ms 671ms 10 3 5s561ms 1s853ms 11 4 6s891ms 1s722ms 12 3 2s829ms 943ms 13 3 2s465ms 821ms 14 4 5s720ms 1s430ms 15 5 12s982ms 2s596ms 16 4 6s419ms 1s604ms 17 3 2s167ms 722ms 18 3 22s307ms 7s435ms 19 4 3s262ms 815ms 20 3 2s462ms 820ms 21 4 3s20ms 755ms 22 4 3s105ms 776ms [ User: intelifix - Total duration: 1m23s - Times executed: 53 ]
[ Application: psql - Total duration: 1m23s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-07 18:00:23 Duration: 21s24ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-07 15:00:07 Duration: 5s683ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-07 15:40:06 Duration: 5s60ms Database: rio User: intelifix Remote: [local] Application: psql
19 1m23s 1 1m23s 1m23s 1m23s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 07 05 1 1m23s 1m23s [ User: intelifix - Total duration: 1m23s - Times executed: 1 ]
[ Application: psql - Total duration: 1m23s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-07 05:32:04 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-07 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
20 1m22s 6 2s274ms 31s364ms 13s780ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 07 20 3 41s403ms 13s801ms 23 3 41s278ms 13s759ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-07 23:14:55 Duration: 31s364ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-07 20:06:56 Duration: 31s334ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-07 20:10:15 Duration: 7s752ms 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 841 10m4s 151ms 4s 718ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 07 07 6 6s659ms 1s109ms 08 90 1m3s 705ms 09 167 2m5s 754ms 10 118 1m25s 722ms 11 72 47s633ms 661ms 12 29 19s212ms 662ms 13 36 30s318ms 842ms 14 94 1m12s 767ms 15 79 52s915ms 669ms 16 87 1m 699ms 17 63 39s781ms 631ms [ User: intelifix - Total duration: 10m4s - Times executed: 841 ]
[ Application: [unknown] - Total duration: 10m4s - Times executed: 841 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (293942, 404, 'SEIG62701707,2CD8AE797424,9D2618301707,2CD8AE797425$SEIG62414208,2CD8AE5B7168,9D2616114208,2CD8AE5B7169$SEIG62414201,2CD8AE5B711B,9D2616114201,2CD8AE5B711C$SEIG62413938,2CD8AE5B65CE,9D2616113938,2CD8AE5B65CF$SEIG62414155,2CD8AE5B6F21,9D2616114155,2CD8AE5B6F22$SEIG62701097,2CD8AE7959EE,9D2618301097,2CD8AE7959EF$SEIG62701514,2CD8AE796BD9,9D2618301514,2CD8AE796BDA$SEIG62701089,2CD8AE795996,9D2618301089,2CD8AE795997$SEIG62701056,2CD8AE79582B,9D2618301056,2CD8AE79582C$SEIG62701057,2CD8AE795836,9D2618301057,2CD8AE795837$SEIG62703178,2CD8AE79B359,9D2618303178,2CD8AE79B35A$SEIG62703194,2CD8AE79B409,9D2618303194,2CD8AE79B40A$SEIG62703195,2CD8AE79B414,9D2618303195,2CD8AE79B415$SEIG62700118,2CD8AE792FDD,9D2618300118,2CD8AE792FDE$SEIG62701054,2CD8AE795815,9D2618301054,2CD8AE795816$SEIG62701540,2CD8AE796CF7,9D2618301540,2CD8AE796CF8$SEIG62701099,2CD8AE795A04,9D2618301099,2CD8AE795A05$SEIG62703193,2CD8AE79B3FE,9D2618303193,2CD8AE79B3FF$SEIG62703201,2CD8AE79B456,9D2618303201,2CD8AE79B457$SEIG62413939,2CD8AE5B65D9,9D2616113939,2CD8AE5B65DA$SEIG62413953,2CD8AE5B6673,9D2616113953,2CD8AE5B6674$SEIG62414209,2CD8AE5B7173,9D2616114209,2CD8AE5B7174$SEIG62414162,2CD8AE5B6F6E,9D2616114162,2CD8AE5B6F6F$SEIG62414221,2CD8AE5B71F7,9D2616114221,2CD8AE5B71F8', '',0467,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-07 11:09:18 Duration: 4s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (293940, 450, 'ZTE3ANNRAM21733,5872C9893597,5872C9893598,ZTEGDC6054E4$ZTE3ANNRCP17648,6C11BA6AC86F,6C11BA6AC870,ZTEGDC6F8583$ZTE3ANNQ4N02715,3CF9F0A8D150,3CF9F0A8D151,ZTEGD6410D96$ZTE3ANNR3J13429,F4E84F87891E,F4E84F87891F,ZTEGD97B963F$ZTE3ANNQ5N07788,3CF9F0AD7BFE,3CF9F0AD7BFF,ZTEGD641D4B3$ZTE3ANNQ8M44233,843C9922D4A1,843C9922D4A2,ZTEGD7BAF436$ZTE3ANNR9F29749,D89A0DA59721,D89A0DA59722,ZTEGDB159B80$ZTE3ANNQ9J13795,843C992D1487,843C992D1488,ZTEGD7BB3E8E$ZTE3ANNRB728610,5872C990D7BD,5872C990D7BE,ZTEGDC619A95$ZTE3ANNR2Q20095,F4E84F828AFA,F4E84F828AFB,ZTEGD97AC139$ZTE3ANNT2V30855,D831398E6202,D831398E6203,ZTEGDD306B06$ZTE3ANNQ5B07433,3CF9F0AF2DF0,3CF9F0AF2DF1,ZTEGD6421D06$ZTE3ANNR5W36063,48D68231D104,48D68231D105,ZTEGDB008CDE$ZTE3ANNR3Y38669,4896D9534B06,4896D9534B07,ZTEGD97EC7C2$ZTE3ANNT2V01612,D831398BB4A0,D831398BB4A1,ZTEGDD2FF8CB$ZTE3ANNT4Q02011,F00C5154FD7A,F00C5154FD7B,ZTEGDE358510$ZTE3ANNQ5200481,3CF9F0A7365C,3CF9F0A7365D,ZTEGD640C918$ZTE3ANNQ9J16949,843C992D5E73,843C992D5E74,ZTEGD7BB4AE0$ZTE3ANNRC509223,6C11BA630201,6C11BA630202,ZTEGDC6E39C6$ZTE3ANNRC573845,6C11BA68EC95,6C11BA68EC96,ZTEGDC6F3634$ZTE3ANNT4Q01033,F00C5154E68E,F00C5154E68F,ZTEGDE35813E$ZTE3ANNR5W35048,48D68231B93A,48D68231B93B,ZTEGDB0088E7$ZTE3ANNQ8F14384,689E29FD73FD,689E29FD73FE,ZTEGD7BA3500$ZTE3ANNT4Q00764,F00C5154E040,F00C5154E041,ZTEGDE358031$ZTE3ANNRC511486,6C11BA63370B,6C11BA63370C,ZTEGDC6E429D$ZTE3ANNR4N54703,4896D95A5D32,4896D95A5D33,ZTEGD97FF574$ZTE3ANNQ4N14549,3CF9F0A9E6AC,3CF9F0A9E6AD,ZTEGD6413BD0$ZTE3ANNRCP13777,6C11BA6A6DB5,6C11BA6A6DB6,ZTEGDC6F7664$ZTE3ANNR5W57180,48D68233BFF2,48D68233BFF3,ZTEGDB00DF5B$ZTE3ANNR3Y02230,4896D94FF4FC,4896D94FF4FD,ZTEGD97E396B$ZTE3ANNT4P25397,F00C514DF9DC,F00C514DF9DD,ZTEGDE3459CB$ZTE3ANNT3H09472,D8313997A198,D8313997A199,ZTEGDD31F59F$ZTE3ANNR7B48215,3891484D56B1,3891484D56B2,ZTEGDB084DB7$ZTE3ANNT3H48451,D831399B332A,D831399B332B,ZTEGDD328DE2$ZTE3ANNQ4N09386,3CF9F0A96DAA,3CF9F0A96DAB,ZTEGD64127A5$ZTE3ANNR2Q43327,F4E84F84AB7A,F4E84F84AB7B,ZTEGD97B1BF9$ZTE3ANNQ9J18963,843C992D8DA7,843C992D8DA8,ZTEGD7BB52BE$ZTE3ANNRAD16506,D89A0DAF5D3F,D89A0DAF5D40,ZTEGDB173C85$ZTE3ANNRAD12877,D89A0DAF0831,D89A0DAF0832,ZTEGDB172E58$ZTE3ANNR6R46940,48D68239D0EA,48D68239D0EB,ZTEGDB01E22F', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-07 14:06:14 Duration: 3s685ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60352, 406, 'ZTE3ANNQ8M23715,843C9920F3BD,843C9920F3BE,ZTEGD7BAA410$ZTE3ANNT7U23425,589204022500,589204022501,ZTEGDF034875$ZTE3ANNR6R55252,48D6823A93BA,48D6823A93BB,ZTEGDB0202A7$ZTE3ANNRB721224,5872C9902AA1,5872C9902AA2,ZTEGDC617DBB$ZTE3ANNT3H72922,D831399D70B4,D831399D70B5,ZTEGDD32ED79$ZTE3ANNT7U23278,58920402218E,58920402218F,ZTEGDF0347E2$ZTE3ANNQ8M18921,843C99208361,843C99208362,ZTEGD7BA9156$ZTE3ANNT2V02328,D831398BC568,D831398BC569,ZTEGDD2FFB97$ZTE3ANNQ8M44747,843C9922E0AD,843C9922E0AE,ZTEGD7BAF638$ZTE3ANNR7B47517,3891484D4655,3891484D4656,ZTEGDB084AFD$ZTE3ANNR8C24248,38914850BF57,38914850BF58,ZTEGDB08DF28$ZTE3ANNR9W44587,D89A0DAC7125,D89A0DAC7126,ZTEGDB16BFD6$ZTE3ANNRAM63395,5872C98D060B,5872C98D060C,ZTEGDC60F7A2$ZTE3ANNR5W25386,48D68230D6C6,48D68230D6C7,ZTEGDB006329$ZTE3ANNRAD23611,D89A0DB003C5,D89A0DB003C6,ZTEGDB175846$ZTE3ANNQ4A00640,3CF9F0AA0746,3CF9F0AA0747,ZTEGD641413F$ZTE3ANNR3J05999,F4E84F86DAFA,F4E84F86DAFB,ZTEGD97B7939$ZTE3ANNT4Q06886,F00C51556FBC,F00C51556FBD,ZTEGDE35981B$ZTE3ANNR3J05786,F4E84F86D5FC,F4E84F86D5FD,ZTEGD97B7864$ZTE3ANNT3H23534,D8313998EB2C,D8313998EB2D,ZTEGDD322C8D$ZTE3ANNR4N10750,4896D956570C,4896D956570D,ZTEGD97F49C3$ZTE3ANNRC575768,6C11BA6919A7,6C11BA6919A8,ZTEGDC6F3DB7$ZTE3ANNRCB66148,D8313923DD56,D8313923DD57,ZTEGDD2AB7F9$ZTE3ANNQ8122625,689E29BDF111,689E29BDF112,ZTEGD7B792F1$ZTE3ANNT3J12733,D83139A115C0,D83139A115C1,ZTEGDD3388FB$ZTE3ANNT4Q05228,F00C515548E0,F00C515548E1,ZTEGDE3591A1$ZTE3ANNRAM35189,5872C98A70F7,5872C98A70F8,ZTEGDC608974$ZTE3ANNQ4N01586,3CF9F0A8B6DA,3CF9F0A8B6DB,ZTEGD641092D$ZTE3ANNQ9J21669,843C992DCD13,843C992DCD14,ZTEGD7BB5D50$ZTE3ANNRCP49336,6C11BA6DAF1F,6C11BA6DAF20,ZTEGDC70014B$ZTE3ANNRC554109,6C11BA671E05,6C11BA671E06,ZTEGDC6EE91C', '',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":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-07 13:18:08 Duration: 3s10ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 734 5m20s 150ms 2s164ms 436ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 07 07 12 7s982ms 665ms 08 112 51s250ms 457ms 09 95 39s182ms 412ms 10 108 43s9ms 398ms 11 134 48s916ms 365ms 12 3 2s109ms 703ms 13 19 9s931ms 522ms 14 73 44s531ms 610ms 15 83 35s329ms 425ms 16 67 27s55ms 403ms 17 28 11s217ms 400ms [ User: intelifix - Total duration: 5m20s - Times executed: 734 ]
[ Application: [unknown] - Total duration: 5m20s - Times executed: 734 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "294173", "modelo" : "141", "itens" : "229783817677,229687227880,229784390518,229933597985,229810540612,229805528696,216942165169,229816616883,229810123545,229809000114,216940010616,229805358501,229813676484,229745216065,229753957681,229673164769,229728629395,229743673042,229752442843,229810616679,229933307171,229669514951,229932943747,229739954048,229739960211,229749359095,229737525775,229751557492", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246597155870,226403574452,246598222731,226001639008,246642932437,246596214858,246471125366,246630385353,246618888383,246627576684,246463934451,246575097791,246630783956,246543888708,246560997582,246491114455,246110126868,246544833839,246531734345,246642159802,246134801926,246515484252,226119073443,246569733138,246568932443,246529853657,246527643946,246629886382,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-07 14:41:40 Duration: 2s164ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "293982", "modelo" : "464", "itens" : "241742399313,241820207377,241764808390,241764692948,241827190417,241820508394,241777668287,241760237989,241764861932,241747550815,241760246778,241770195269,241775685468,241767383850,241738301618,241777809615,241742565064,241760120426,241764781318,241772252036,241814173052,241745407496,241813941739,241771278898,241813772631,241815558911,241818613137,241812751735,241763734863,241767660219,241764216986,241740745975,241818815154,241745810522,241764915775,241745396485,241777657579,241768700208,241812865965,241760107292,241762679899,241742525969,241777855253,241742142240,241778925470,241743179400,241743839093,241740639803,241760154345,241688088299,241815450214,241761401628,241813743739,241763382225,241759484852,241739643657,241738604150,241815457183,241770209917,241744698404", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-07 07:36:50 Duration: 1s821ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "294255", "modelo" : "129", "itens" : "D06EDE78C048,981E19B0E82D,B8668518FD87,E8ADA6BC2E92,34495B8E6894,ECBEDDFFCD0D,3093BCC5BA79,B866851D12C7,D06EDE78B50B,B866850CC553", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-07 17:11:32 Duration: 1s550ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 275 7m21s 185ms 6s385ms 1s606ms call rs_giga_triagem (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 07 00 12 23s477ms 1s956ms 01 12 18s841ms 1s570ms 02 12 18s676ms 1s556ms 03 12 18s689ms 1s557ms 04 12 17s698ms 1s474ms 05 12 17s467ms 1s455ms 06 12 17s924ms 1s493ms 07 12 18s276ms 1s523ms 08 12 20s763ms 1s730ms 09 12 19s906ms 1s658ms 10 12 21s764ms 1s813ms 11 12 18s645ms 1s553ms 12 12 20s513ms 1s709ms 13 12 20s74ms 1s672ms 14 12 22s87ms 1s840ms 15 12 20s251ms 1s687ms 16 12 18s341ms 1s528ms 17 12 17s866ms 1s488ms 18 12 17s571ms 1s464ms 19 11 17s404ms 1s582ms 20 12 20s728ms 1s727ms 21 12 17s355ms 1s446ms 22 12 17s417ms 1s451ms [ User: intelifix - Total duration: 7m21s - Times executed: 275 ]
[ Application: psql - Total duration: 7m21s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-07 00:05:20 Duration: 6s385ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-07 10:05:12 Duration: 5s550ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-07 08:35:09 Duration: 4s348ms Database: rio User: intelifix Remote: [local] Application: psql
4 158 5m13s 157ms 12s12ms 1s983ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 07 00 6 18s121ms 3s20ms 01 6 7s269ms 1s211ms 02 6 6s339ms 1s56ms 03 5 8s727ms 1s745ms 04 6 9s5ms 1s500ms 05 4 2s986ms 746ms 07 12 29s594ms 2s466ms 08 12 36s461ms 3s38ms 09 12 31s271ms 2s605ms 10 12 28s568ms 2s380ms 11 12 25s134ms 2s94ms 12 11 27s236ms 2s476ms 13 7 5s66ms 723ms 14 11 24s127ms 2s193ms 15 12 26s319ms 2s193ms 16 9 10s710ms 1s190ms 17 4 2s18ms 504ms 21 5 7s197ms 1s439ms 22 6 7s178ms 1s196ms [ User: intelifix - Total duration: 5m13s - Times executed: 158 ]
[ Application: psql - Total duration: 5m13s - Times executed: 158 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-07 00:05:13 Duration: 12s12ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-07 08:15:08 Duration: 6s694ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-07 07:45:07 Duration: 6s370ms Database: rio User: intelifix Remote: [local] Application: psql
5 154 59m13s 150ms 6m12s 23s77ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 07 07 11 6m28s 35s349ms 08 21 6m30s 18s609ms 09 19 2m10s 6s851ms 10 16 11m58s 44s907ms 11 11 5m46s 31s454ms 12 6 2s489ms 414ms 13 3 1s157ms 385ms 14 30 13m34s 27s139ms 15 15 5m59s 23s971ms 16 3 14s728ms 4s909ms 17 17 6m14s 22s23ms 18 2 13s8ms 6s504ms [ User: intelifix - Total duration: 59m13s - Times executed: 154 ]
[ Application: [unknown] - Total duration: 59m13s - Times executed: 154 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030786, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-07 07:36:24 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030811, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-07 14:26:26 Duration: 6m11s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030838, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-07 14:54:07 Duration: 5m58s Database: rio User: intelifix Remote: [local] Application: [unknown]
6 102 32s678ms 294ms 425ms 320ms 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 #6
Day Hour Count Duration Avg duration Oct 07 01 2 660ms 330ms 03 1 313ms 313ms 04 2 624ms 312ms 05 2 621ms 310ms 06 1 310ms 310ms 07 6 1s930ms 321ms 08 12 3s861ms 321ms 09 12 3s745ms 312ms 10 10 3s176ms 317ms 11 7 2s223ms 317ms 12 5 1s729ms 345ms 13 7 2s264ms 323ms 14 10 3s374ms 337ms 15 7 2s399ms 342ms 16 9 2s749ms 305ms 17 6 1s801ms 300ms 18 1 297ms 297ms 20 1 298ms 298ms 22 1 298ms 298ms [ User: lenon - Total duration: 32s678ms - Times executed: 102 ]
[ Application: [unknown] - Total duration: 32s678ms - Times executed: 102 ]
-
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-10-07 15:12:12 Duration: 425ms 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-10-07 14:06:57 Duration: 397ms 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-10-07 10:11:57 Duration: 380ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
7 93 35s254ms 328ms 570ms 379ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 07 01 2 872ms 436ms 04 2 752ms 376ms 05 2 720ms 360ms 07 3 1s105ms 368ms 08 12 4s647ms 387ms 09 11 4s96ms 372ms 10 10 3s645ms 364ms 11 7 2s679ms 382ms 12 5 2s77ms 415ms 13 6 2s285ms 380ms 14 9 3s517ms 390ms 15 7 2s782ms 397ms 16 9 3s239ms 359ms 17 6 2s118ms 353ms 18 1 356ms 356ms 22 1 358ms 358ms [ User: intelifix - Total duration: 35s254ms - Times executed: 93 ]
[ Application: [unknown] - Total duration: 35s254ms - Times executed: 93 ]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-10-07 08:22:24 Duration: 570ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (499, 19, 1);
Date: 2026-10-07 01:18:54 Duration: 478ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (406, 18, 1);
Date: 2026-10-07 09:38:42 Duration: 467ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
8 83 16s446ms 150ms 429ms 198ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 07 03 4 743ms 185ms 04 8 1s639ms 204ms 05 3 632ms 210ms 07 1 201ms 201ms 08 12 2s187ms 182ms 09 9 1s822ms 202ms 10 8 1s429ms 178ms 11 10 2s147ms 214ms 12 6 1s282ms 213ms 13 2 313ms 156ms 14 4 835ms 208ms 15 12 2s255ms 187ms 16 4 954ms 238ms [ User: intelifix - Total duration: 16s446ms - Times executed: 83 ]
[ Application: [unknown] - Total duration: 16s446ms - Times executed: 83 ]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '229953123943,229947995979,229945497878,230002360107,229953460116,229970403138,229992709905,229930225266', NULL, NULL, 0287, 00);
Date: 2026-10-07 04:02:04 Duration: 429ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (310, 5, '63', 2, 'B85E71EE0084,E4BFFAFB46BC,80DAC2CC215C,B85E71B8FE98,3C82C0C5352C,B85E71EDF544,3C82C0C56484,B85E71E1C06C,C4509CBEB6E4,4075C3C34078,1C9ECCF2F844,484BD497AF54,4075C3B9B5E4,F8D2ACC89D64,E4BFFAF8A2CC,00CB7AE2AB3C,3C82C0C9CE48,B85E71D29650,F8D2AC1529E8,CCF3C847C894,8C6A8DBF6184,C4509CF30A34,4075C3BAA65C,4075C3B9B6E8,08A7C073799C,B85E71CA0184,B85E710E49D4,4075C3B8C1FC,B85E71C2EFD4,B85E71DFB0EC,B85E71EECE74,3C82C0C900D0,3C82C09257EC,C4509CF4DFCC,C4509CAC7424,D4E2CB96E63C,00CB7ADC3F90', NULL, NULL, 0185, 00);
Date: 2026-10-07 11:07:48 Duration: 353ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (310, 5, '95', 2, 'E4C0E2977F3B,94988F956FB7,5CFA2580A996,6CBAB8EAB1B5,E8D2FF962F54,8CFDDE7D8C92,3C585D79A756,841EA38804A5,44D45460A9F1,943C96792F83,CC5830E03812,64FD9654365B,4C195DD4763C,E4C0E23FF89E,CC5830034170,8CC5B4EDD1BD,38A6591A5AA6,209A7DB53DD6,5CFA2517052D', NULL, NULL, 0155, 00);
Date: 2026-10-07 16:29:39 Duration: 300ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 69 20s698ms 261ms 601ms 299ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 07 07 2 553ms 276ms 08 11 3s92ms 281ms 09 13 3s813ms 293ms 10 8 2s314ms 289ms 11 2 871ms 435ms 13 1 310ms 310ms 14 14 4s341ms 310ms 15 5 1s761ms 352ms 16 2 660ms 330ms 17 9 2s455ms 272ms 18 2 523ms 261ms [ User: intelifix - Total duration: 20s698ms - Times executed: 69 ]
[ Application: [unknown] - Total duration: 20s698ms - Times executed: 69 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-10-07 11:33:18 Duration: 601ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-10-07 15:01:01 Duration: 460ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-10-07 15:11:20 Duration: 420ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
10 66 13m8s 10s384ms 21s443ms 11s942ms create table temp0000293596 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 07 07 3 43s320ms 14s440ms 08 6 1m7s 11s295ms 09 18 3m28s 11s601ms 10 11 2m6s 11s519ms 11 3 36s589ms 12s196ms 14 16 3m21s 12s601ms 15 9 1m43s 11s481ms [ User: intelifix - Total duration: 13m8s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 13m8s - Times executed: 66 ]
-
CREATE TABLE temp0000293596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 07:29:27 Duration: 21s443ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 09:28:15 Duration: 16s800ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 10:22:39 Duration: 15s697ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 66 26s238ms 151ms 1s201ms 397ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 07 07 12 4s586ms 382ms 08 15 5s822ms 388ms 09 3 981ms 327ms 10 1 179ms 179ms 11 7 3s455ms 493ms 12 4 2s14ms 503ms 14 12 5s92ms 424ms 15 12 4s106ms 342ms [ User: intelifix - Total duration: 26s238ms - Times executed: 66 ]
[ Application: [unknown] - Total duration: 26s238ms - Times executed: 66 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0293988) LIMIT 1;
Date: 2026-10-07 11:26:01 Duration: 1s201ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0129067) LIMIT 1;
Date: 2026-10-07 08:42:44 Duration: 1s31ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0293994) LIMIT 1;
Date: 2026-10-07 15:34:43 Duration: 992ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 57 5m12s 1s410ms 12s590ms 5s485ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 07 07 1 6s443ms 6s443ms 08 2 10s391ms 5s195ms 09 3 24s579ms 8s193ms 10 4 13s665ms 3s416ms 11 7 22s345ms 3s192ms 12 2 4s606ms 2s303ms 13 4 30s504ms 7s626ms 14 9 59s646ms 6s627ms 15 4 26s254ms 6s563ms 16 13 1m23s 6s445ms 17 7 28s364ms 4s52ms 18 1 2s85ms 2s85ms [ User: intelifix - Total duration: 5m12s - Times executed: 57 ]
[ Application: [unknown] - Total duration: 5m12s - Times executed: 57 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-07', 0320, '', '', 0, 6, '2026-10-01');
Date: 2026-10-07 15:06:48 Duration: 12s590ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-07', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-07 13:36:04 Duration: 11s886ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-07', 0320, '', '', 0, 6, '2026-10-01');
Date: 2026-10-07 14:20:25 Duration: 11s591ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 53 1m23s 569ms 21s24ms 1s580ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 07 08 3 2s539ms 846ms 09 3 2s14ms 671ms 10 3 5s561ms 1s853ms 11 4 6s891ms 1s722ms 12 3 2s829ms 943ms 13 3 2s465ms 821ms 14 4 5s720ms 1s430ms 15 5 12s982ms 2s596ms 16 4 6s419ms 1s604ms 17 3 2s167ms 722ms 18 3 22s307ms 7s435ms 19 4 3s262ms 815ms 20 3 2s462ms 820ms 21 4 3s20ms 755ms 22 4 3s105ms 776ms [ User: intelifix - Total duration: 1m23s - Times executed: 53 ]
[ Application: psql - Total duration: 1m23s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-07 18:00:23 Duration: 21s24ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-07 15:00:07 Duration: 5s683ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-07 15:40:06 Duration: 5s60ms Database: rio User: intelifix Remote: [local] Application: psql
14 48 1h33m29s 2s100ms 6m27s 1m56s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 07 07 3 6m59s 2m19s 08 3 5m50s 1m56s 09 3 6m7s 2m2s 10 3 6m 2m 11 3 5m37s 1m52s 12 3 6m7s 2m2s 13 3 6m5s 2m1s 14 3 6m5s 2m1s 15 3 6m11s 2m3s 16 3 5m26s 1m48s 17 3 5m51s 1m57s 18 3 5m24s 1m48s 19 3 5m22s 1m47s 20 3 5m32s 1m50s 21 3 5m26s 1m48s 22 3 5m21s 1m47s [ User: intelifix - Total duration: 1h33m29s - Times executed: 48 ]
[ Application: psql - Total duration: 1h33m29s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-07 07:11:28 Duration: 6m27s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-07 15:10:55 Duration: 5m53s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-07 09:10:50 Duration: 5m49s Database: rio User: intelifix Remote: [local] Application: psql
15 48 1h3m25s 218ms 3m54s 1m19s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 07 07 3 4m39s 1m33s 08 3 3m53s 1m17s 09 3 4m15s 1m25s 10 3 4m7s 1m22s 11 3 3m47s 1m15s 12 3 4m26s 1m28s 13 3 4m4s 1m21s 14 3 4m17s 1m25s 15 3 4m2s 1m20s 16 3 3m37s 1m12s 17 3 3m56s 1m18s 18 3 3m41s 1m13s 19 3 3m38s 1m12s 20 3 3m38s 1m12s 21 3 3m38s 1m12s 22 3 3m41s 1m13s [ User: intelifix - Total duration: 1h3m25s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m25s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-07 12:15:31 Duration: 3m54s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-07 14:15:20 Duration: 3m45s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-07 09:15:22 Duration: 3m42s Database: brasilia User: intelifix Remote: [local] Application: psql
16 47 9m34s 11s458ms 13s59ms 12s225ms create table temp0000293656 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 07 14 40 8m5s 12s144ms 15 7 1m28s 12s690ms [ User: intelifix - Total duration: 9m34s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 9m34s - Times executed: 47 ]
-
CREATE TABLE temp0000293656 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 15:02:33 Duration: 13s59ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293656 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 14:26:30 Duration: 12s986ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293656 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 15:04:14 Duration: 12s959ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 40 12s582ms 150ms 613ms 314ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 07 08 12 5s10ms 417ms 09 15 4s56ms 270ms 10 3 1s182ms 394ms 14 5 1s331ms 266ms 15 2 492ms 246ms 16 1 150ms 150ms 17 2 358ms 179ms [ User: intelifix - Total duration: 12s582ms - Times executed: 40 ]
[ Application: [unknown] - Total duration: 12s582ms - Times executed: 40 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '2035431BFF51,94988F2D7F9F,D8CF616406B0,2035431662DE,929240121182,929240156436,929240608154,929240171856,929240795235,929240739424', '138;1', 'DEFAULT', 09, 0302, '','', '', 00);
Date: 2026-10-07 08:06:20 Duration: 613ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '5872C98F9975,C4EBFF89F10C,F4E84F8697EC,4896D956BAD2,D89A0D829485,48D68233261A,D89A0DA9C9B1,4896D955D30C,5872C98F9EF7,4896D9568E98,F4E84F89A55A,3891484C1539,D83139A046B4,843C992E57F1,C4EBFF8C2728,843C9936170F,48D6823200D4,843C99361223,F4E84F869CEA,3CF9F0AC33A2', '','DEFAULT',09,0323,'', '','', 00);
Date: 2026-10-07 08:36:28 Duration: 610ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'C4EBFF89FEEC,6C11BA6855E7,3CF9F0A581D6,843C9935D10D,3CF9F0AC633C,843C99203459,48D68237D8AE,3CF9F0AF7FF8,4896D958B23C,C4EBFF892A2E,D89A0DA865CB,D831399C1358,843C99212EF1,843C99351947', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-10-07 10:12:34 Duration: 562ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
18 38 50s620ms 151ms 17s546ms 1s332ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 07 07 1 564ms 564ms 08 2 506ms 253ms 09 7 6s22ms 860ms 10 5 1s1ms 200ms 11 1 289ms 289ms 14 13 26s925ms 2s71ms 15 5 963ms 192ms 17 4 14s346ms 3s586ms [ User: intelifix - Total duration: 50s620ms - Times executed: 38 ]
[ Application: psql - Total duration: 50s620ms - Times executed: 38 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030809);
Date: 2026-10-07 14:07:07 Duration: 17s546ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030860);
Date: 2026-10-07 17:29:40 Duration: 6s577ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030791);
Date: 2026-10-07 09:40:07 Duration: 4s666ms Database: rio User: intelifix Remote: [local] Application: psql
19 35 1m44s 606ms 9s599ms 2s984ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 07 08 3 10s698ms 3s566ms 09 3 13s810ms 4s603ms 10 2 8s831ms 4s415ms 11 2 16s13ms 8s6ms 12 3 5s263ms 1s754ms 13 3 3s965ms 1s321ms 14 2 7s704ms 3s852ms 15 1 7s762ms 7s762ms 16 2 9s608ms 4s804ms 17 3 11s213ms 3s737ms 18 2 1s522ms 761ms 19 2 1s607ms 803ms 20 3 2s736ms 912ms 21 2 2s51ms 1s25ms 22 2 1s680ms 840ms [ User: intelifix - Total duration: 1m44s - Times executed: 35 ]
[ Application: psql - Total duration: 1m44s - Times executed: 35 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-07 11:40:10 Duration: 9s599ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-07 15:20:09 Duration: 7s762ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-07 09:40:07 Duration: 6s514ms Database: rio User: intelifix Remote: [local] Application: psql
20 31 1m8s 1s820ms 4s379ms 2s221ms create table temp0000293596 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 07 07 3 5s708ms 1s902ms 08 6 12s530ms 2s88ms 09 14 29s116ms 2s79ms 10 2 6s438ms 3s219ms 14 6 15s66ms 2s511ms [ User: intelifix - Total duration: 1m8s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 1m8s - Times executed: 31 ]
-
CREATE TABLE temp0000293596 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"02-10-2026", "ate" :"07-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-07 10:24:38 Duration: 4s379ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293596 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"02-10-2026", "ate" :"07-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-07 14:57:10 Duration: 2s738ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293596 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"02-10-2026", "ate" :"07-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-07 08:40:53 Duration: 2s661ms 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 2m36s 9m19s 6m12s 3 18m37s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 07 05 3 18m37s 6m12s [ User: intelifix - Total duration: 18m37s - Times executed: 3 ]
[ Application: psql - Total duration: 18m37s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-07 05:09:20 Duration: 9m19s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-07 05:16:02 Duration: 6m41s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-07 05:18:39 Duration: 2m36s Database: contagem User: intelifix Remote: [local] Application: psql
2 2s100ms 6m27s 1m56s 48 1h33m29s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 07 07 3 6m59s 2m19s 08 3 5m50s 1m56s 09 3 6m7s 2m2s 10 3 6m 2m 11 3 5m37s 1m52s 12 3 6m7s 2m2s 13 3 6m5s 2m1s 14 3 6m5s 2m1s 15 3 6m11s 2m3s 16 3 5m26s 1m48s 17 3 5m51s 1m57s 18 3 5m24s 1m48s 19 3 5m22s 1m47s 20 3 5m32s 1m50s 21 3 5m26s 1m48s 22 3 5m21s 1m47s [ User: intelifix - Total duration: 1h33m29s - Times executed: 48 ]
[ Application: psql - Total duration: 1h33m29s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-07 07:11:28 Duration: 6m27s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-07 15:10:55 Duration: 5m53s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-07 09:10:50 Duration: 5m49s Database: rio User: intelifix Remote: [local] Application: psql
3 1m23s 1m23s 1m23s 1 1m23s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 07 05 1 1m23s 1m23s [ User: intelifix - Total duration: 1m23s - Times executed: 1 ]
[ Application: psql - Total duration: 1m23s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-07 05:32:04 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-07 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 218ms 3m54s 1m19s 48 1h3m25s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 07 07 3 4m39s 1m33s 08 3 3m53s 1m17s 09 3 4m15s 1m25s 10 3 4m7s 1m22s 11 3 3m47s 1m15s 12 3 4m26s 1m28s 13 3 4m4s 1m21s 14 3 4m17s 1m25s 15 3 4m2s 1m20s 16 3 3m37s 1m12s 17 3 3m56s 1m18s 18 3 3m41s 1m13s 19 3 3m38s 1m12s 20 3 3m38s 1m12s 21 3 3m38s 1m12s 22 3 3m41s 1m13s [ User: intelifix - Total duration: 1h3m25s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m25s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-07 12:15:31 Duration: 3m54s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-07 14:15:20 Duration: 3m45s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-07 09:15:22 Duration: 3m42s Database: brasilia User: intelifix Remote: [local] Application: psql
5 4s124ms 1m1s 32s957ms 4 2m11s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 07 20 2 1m6s 33s180ms 23 2 1m5s 32s734ms [ User: intelifix - Total duration: 2m11s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m11s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-07 20:08:33 Duration: 1m1s 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-10-07 23:16:32 Duration: 1m1s 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-10-07 20:10:30 Duration: 4s483ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 336ms 52s178ms 26s187ms 4 1m44s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 07 20 2 52s521ms 26s260ms 23 2 52s229ms 26s114ms [ User: intelifix - Total duration: 1m44s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m44s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-07 20:05:40 Duration: 52s178ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-07 23:13:39 Duration: 51s893ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-07 20:09:56 Duration: 343ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 150ms 6m12s 23s77ms 154 59m13s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 07 07 11 6m28s 35s349ms 08 21 6m30s 18s609ms 09 19 2m10s 6s851ms 10 16 11m58s 44s907ms 11 11 5m46s 31s454ms 12 6 2s489ms 414ms 13 3 1s157ms 385ms 14 30 13m34s 27s139ms 15 15 5m59s 23s971ms 16 3 14s728ms 4s909ms 17 17 6m14s 22s23ms 18 2 13s8ms 6s504ms [ User: intelifix - Total duration: 59m13s - Times executed: 154 ]
[ Application: [unknown] - Total duration: 59m13s - Times executed: 154 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030786, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-07 07:36:24 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030811, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-07 14:26:26 Duration: 6m11s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030838, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-07 14:54:07 Duration: 5m58s Database: rio User: intelifix Remote: [local] Application: [unknown]
8 3s188ms 39s753ms 17s765ms 6 1m46s 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 #8
Day Hour Count Duration Avg duration Oct 07 20 3 53s217ms 17s739ms 23 3 53s374ms 17s791ms [ User: intelifix - Total duration: 1m46s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m46s - 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-10-07 23:14:21 Duration: 39s753ms 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-10-07 20:06:22 Duration: 39s639ms 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-10-07 20:10:06 Duration: 10s389ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 2s274ms 31s364ms 13s780ms 6 1m22s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 07 20 3 41s403ms 13s801ms 23 3 41s278ms 13s759ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-07 23:14:55 Duration: 31s364ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-07 20:06:56 Duration: 31s334ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-07 20:10:15 Duration: 7s752ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 11s458ms 13s59ms 12s225ms 47 9m34s create table temp0000293656 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 07 14 40 8m5s 12s144ms 15 7 1m28s 12s690ms [ User: intelifix - Total duration: 9m34s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 9m34s - Times executed: 47 ]
-
CREATE TABLE temp0000293656 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 15:02:33 Duration: 13s59ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293656 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 14:26:30 Duration: 12s986ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293656 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 15:04:14 Duration: 12s959ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s384ms 21s443ms 11s942ms 66 13m8s create table temp0000293596 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 07 07 3 43s320ms 14s440ms 08 6 1m7s 11s295ms 09 18 3m28s 11s601ms 10 11 2m6s 11s519ms 11 3 36s589ms 12s196ms 14 16 3m21s 12s601ms 15 9 1m43s 11s481ms [ User: intelifix - Total duration: 13m8s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 13m8s - Times executed: 66 ]
-
CREATE TABLE temp0000293596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 07:29:27 Duration: 21s443ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 09:28:15 Duration: 16s800ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 10:22:39 Duration: 15s697ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 10s890ms 11s302ms 11s55ms 10 1m50s create table temp0000293620 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 07 10 10 1m50s 11s55ms [ User: intelifix - Total duration: 1m50s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 1m50s - Times executed: 10 ]
-
CREATE TABLE temp0000293620 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 10:24:15 Duration: 11s302ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293620 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 10:24:33 Duration: 11s229ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293620 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-07 10:32:09 Duration: 11s58ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 1s410ms 12s590ms 5s485ms 57 5m12s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 07 07 1 6s443ms 6s443ms 08 2 10s391ms 5s195ms 09 3 24s579ms 8s193ms 10 4 13s665ms 3s416ms 11 7 22s345ms 3s192ms 12 2 4s606ms 2s303ms 13 4 30s504ms 7s626ms 14 9 59s646ms 6s627ms 15 4 26s254ms 6s563ms 16 13 1m23s 6s445ms 17 7 28s364ms 4s52ms 18 1 2s85ms 2s85ms [ User: intelifix - Total duration: 5m12s - Times executed: 57 ]
[ Application: [unknown] - Total duration: 5m12s - Times executed: 57 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-07', 0320, '', '', 0, 6, '2026-10-01');
Date: 2026-10-07 15:06:48 Duration: 12s590ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-07', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-07 13:36:04 Duration: 11s886ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-07', 0320, '', '', 0, 6, '2026-10-01');
Date: 2026-10-07 14:20:25 Duration: 11s591ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 219ms 15s191ms 3s416ms 29 1m39s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 07 07 1 15s191ms 15s191ms 08 2 3s965ms 1s982ms 09 4 13s622ms 3s405ms 10 4 15s714ms 3s928ms 11 1 3s658ms 3s658ms 14 12 34s934ms 2s911ms 15 3 10s568ms 3s522ms 17 2 1s430ms 715ms [ User: intelifix - Total duration: 1m39s - Times executed: 29 ]
[ Application: psql - Total duration: 1m39s - Times executed: 29 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030786);
Date: 2026-10-07 07:29:51 Duration: 15s191ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030798);
Date: 2026-10-07 10:24:32 Duration: 10s196ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030795);
Date: 2026-10-07 09:59:15 Duration: 7s727ms Database: rio User: intelifix Remote: [local] Application: psql
15 606ms 9s599ms 2s984ms 35 1m44s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 07 08 3 10s698ms 3s566ms 09 3 13s810ms 4s603ms 10 2 8s831ms 4s415ms 11 2 16s13ms 8s6ms 12 3 5s263ms 1s754ms 13 3 3s965ms 1s321ms 14 2 7s704ms 3s852ms 15 1 7s762ms 7s762ms 16 2 9s608ms 4s804ms 17 3 11s213ms 3s737ms 18 2 1s522ms 761ms 19 2 1s607ms 803ms 20 3 2s736ms 912ms 21 2 2s51ms 1s25ms 22 2 1s680ms 840ms [ User: intelifix - Total duration: 1m44s - Times executed: 35 ]
[ Application: psql - Total duration: 1m44s - Times executed: 35 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-07 11:40:10 Duration: 9s599ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-07 15:20:09 Duration: 7s762ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-07 09:40:07 Duration: 6s514ms Database: rio User: intelifix Remote: [local] Application: psql
16 1s820ms 4s379ms 2s221ms 31 1m8s create table temp0000293596 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 07 07 3 5s708ms 1s902ms 08 6 12s530ms 2s88ms 09 14 29s116ms 2s79ms 10 2 6s438ms 3s219ms 14 6 15s66ms 2s511ms [ User: intelifix - Total duration: 1m8s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 1m8s - Times executed: 31 ]
-
CREATE TABLE temp0000293596 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"02-10-2026", "ate" :"07-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-07 10:24:38 Duration: 4s379ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293596 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"02-10-2026", "ate" :"07-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-07 14:57:10 Duration: 2s738ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293596 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"02-10-2026", "ate" :"07-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-07 08:40:53 Duration: 2s661ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 157ms 12s12ms 1s983ms 158 5m13s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 07 00 6 18s121ms 3s20ms 01 6 7s269ms 1s211ms 02 6 6s339ms 1s56ms 03 5 8s727ms 1s745ms 04 6 9s5ms 1s500ms 05 4 2s986ms 746ms 07 12 29s594ms 2s466ms 08 12 36s461ms 3s38ms 09 12 31s271ms 2s605ms 10 12 28s568ms 2s380ms 11 12 25s134ms 2s94ms 12 11 27s236ms 2s476ms 13 7 5s66ms 723ms 14 11 24s127ms 2s193ms 15 12 26s319ms 2s193ms 16 9 10s710ms 1s190ms 17 4 2s18ms 504ms 21 5 7s197ms 1s439ms 22 6 7s178ms 1s196ms [ User: intelifix - Total duration: 5m13s - Times executed: 158 ]
[ Application: psql - Total duration: 5m13s - Times executed: 158 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-07 00:05:13 Duration: 12s12ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-07 08:15:08 Duration: 6s694ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-07 07:45:07 Duration: 6s370ms Database: rio User: intelifix Remote: [local] Application: psql
18 185ms 6s385ms 1s606ms 275 7m21s call rs_giga_triagem (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 07 00 12 23s477ms 1s956ms 01 12 18s841ms 1s570ms 02 12 18s676ms 1s556ms 03 12 18s689ms 1s557ms 04 12 17s698ms 1s474ms 05 12 17s467ms 1s455ms 06 12 17s924ms 1s493ms 07 12 18s276ms 1s523ms 08 12 20s763ms 1s730ms 09 12 19s906ms 1s658ms 10 12 21s764ms 1s813ms 11 12 18s645ms 1s553ms 12 12 20s513ms 1s709ms 13 12 20s74ms 1s672ms 14 12 22s87ms 1s840ms 15 12 20s251ms 1s687ms 16 12 18s341ms 1s528ms 17 12 17s866ms 1s488ms 18 12 17s571ms 1s464ms 19 11 17s404ms 1s582ms 20 12 20s728ms 1s727ms 21 12 17s355ms 1s446ms 22 12 17s417ms 1s451ms [ User: intelifix - Total duration: 7m21s - Times executed: 275 ]
[ Application: psql - Total duration: 7m21s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-07 00:05:20 Duration: 6s385ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-07 10:05:12 Duration: 5s550ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-07 08:35:09 Duration: 4s348ms Database: rio User: intelifix Remote: [local] Application: psql
19 569ms 21s24ms 1s580ms 53 1m23s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 07 08 3 2s539ms 846ms 09 3 2s14ms 671ms 10 3 5s561ms 1s853ms 11 4 6s891ms 1s722ms 12 3 2s829ms 943ms 13 3 2s465ms 821ms 14 4 5s720ms 1s430ms 15 5 12s982ms 2s596ms 16 4 6s419ms 1s604ms 17 3 2s167ms 722ms 18 3 22s307ms 7s435ms 19 4 3s262ms 815ms 20 3 2s462ms 820ms 21 4 3s20ms 755ms 22 4 3s105ms 776ms [ User: intelifix - Total duration: 1m23s - Times executed: 53 ]
[ Application: psql - Total duration: 1m23s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-07 18:00:23 Duration: 21s24ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-07 15:00:07 Duration: 5s683ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-07 15:40:06 Duration: 5s60ms Database: rio User: intelifix Remote: [local] Application: psql
20 151ms 17s546ms 1s332ms 38 50s620ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 07 07 1 564ms 564ms 08 2 506ms 253ms 09 7 6s22ms 860ms 10 5 1s1ms 200ms 11 1 289ms 289ms 14 13 26s925ms 2s71ms 15 5 963ms 192ms 17 4 14s346ms 3s586ms [ User: intelifix - Total duration: 50s620ms - Times executed: 38 ]
[ Application: psql - Total duration: 50s620ms - Times executed: 38 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030809);
Date: 2026-10-07 14:07:07 Duration: 17s546ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030860);
Date: 2026-10-07 17:29:40 Duration: 6s577ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030791);
Date: 2026-10-07 09:40:07 Duration: 4s666ms Database: rio User: intelifix Remote: [local] Application: psql
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 4 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Oct 07 16 1 0ms 0ms 19 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 1s102ms - Times executed: 4 ]
[ Application: psql - Total duration: 744ms - Times executed: 3 ]
[ Application: [unknown] - Total duration: 358ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 16,617 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 19 FATAL entries
- 4455 ERROR entries
- 0 WARNING entries
- 3 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,394 Max number of times the same event was reported
- 4,477 Total events found
Rank Times reported Error 1 4,394 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 07 00 120 01 120 02 118 03 118 04 120 05 120 06 118 07 142 08 350 09 471 10 366 11 450 12 256 13 193 14 408 15 471 16 253 17 194 18 6 - ERROR: prepared statement "_PLAN0000000029B3B360" does not exist
- ERROR: prepared statement "_PLAN0000000029D72810" does not exist
- ERROR: prepared statement "_PLAN0000000029D75B70" does not exist
Statement: DEALLOCATE "_PLAN0000000029B3B360"
Date: 2026-10-07 00:00:11 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029D72810"
Date: 2026-10-07 00:00:12 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029D75B70"
Date: 2026-10-07 00:01:12 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 23 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 07 09 7 11 6 16 10 - ERROR: syntax error at or near "]" at character 34
- ERROR: syntax error at or near "]" at character 34
- ERROR: syntax error at or near "518110071116" at character 32
Statement: select * from rs_caixa_qr(405916 ])
Date: 2026-10-07 09:01:48 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(405916 ])
Date: 2026-10-07 09:01:48 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT RS_SERIAL_TEMPORARIO( ''518110071116' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''518110071116' )
Date: 2026-10-07 09:49:47 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
3 15 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 07 11 15 - ERROR: trailing junk after numeric literal at or near "83350052750368A" at character 27
- ERROR: trailing junk after numeric literal at or near "83350052750368A" at character 27
- ERROR: trailing junk after numeric literal at or near "83350052750368A" at character 27
Statement: SELECT * FROM RS_ETIQUETA(83350052750368A)
Date: 2026-10-07 11:25:59 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(83350052750368A)
Date: 2026-10-07 11:25:59 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(83350052750368A)
Date: 2026-10-07 11:25:59 Database: rio Application: [unknown] User: etiquetas Remote: [local]
4 12 ERROR: function rs_lote_manutencao_itens(...) does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 07 08 3 09 2 10 4 11 3 - ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
- ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
- ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(139869,401,'921021039930,4829524540F8$922471228815,5447CC496FAC$923391087980,20B82BF976C4$923341118076,20B82BF8C35D$921501017432,345D9EBDC201$922441072350,B0FC88EAF37E$921081098411,841EA38D3842$923191159632,186A81D4F42C$922481054867,5447CC49E17A$920421021684,8CFDDE989934','',0155,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',048295245408);Date: 2026-10-07 08:34:46 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(139869,401,'921021039930,4829524540F8$922471228815,5447CC496FAC$923391087980,20B82BF976C4$923341118076,20B82BF8C35D$921501017432,345D9EBDC201$922441072350,B0FC88EAF37E$921081098411,841EA38D3842$923191159632,186A81D4F42C$922481054867,5447CC49E17A$920421021684,8CFDDE989934','',0155,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',048295245408);Date: 2026-10-07 08:34:52 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(139869,401,'921021039930,4829524540F8$922471228815,5447CC496FAC$923391087980,20B82BF976C4$923341118076,20B82BF8C35D$921501017432,345D9EBDC201$922441072350,B0FC88EAF37E$921081098411,841EA38D3842$923191159632,186A81D4F42C$922481054867,5447CC49E17A$920421021684,8CFDDE989934','',0155,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',048295245408);Date: 2026-10-07 08:34:54 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
5 10 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 07 03 1 06 1 07 1 10 4 12 2 22 1 - FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-10-07 03:30:45 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-07 06:50:31 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-07 07:12:41 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
6 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 07 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-10-07 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-10-07 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-10-07 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
7 6 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Oct 07 09 2 15 2 17 2 - ERROR: column "e820e250f0b2" does not exist at character 27
- ERROR: column "e820e250f0b2" does not exist at character 27
- ERROR: column "v" does not exist at character 27
Statement: select * from rs_caixa_qr(E820E250F0B2)
Date: 2026-10-07 09:21:49 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(E820E250F0B2)
Date: 2026-10-07 09:21:50 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(V)
Date: 2026-10-07 15:40: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 Oct 07 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-10-07 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-07 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-07 05:32:04 Database: contagem Application: psql User: intelifix Remote: [local]
9 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #9
Day Hour Count Oct 07 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-10-07 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-07 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
10 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #10
Day Hour Count Oct 07 17 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000293682"
Date: 2026-10-07 17:05:41
11 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #11
Day Hour Count Oct 07 03 1 - LOG: database system was shut down at 2026-10-07 03:05:01 -03
Date: 2026-10-07 03:05:02
12 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #12
Day Hour Count Oct 07 17 1 - LOG: process 3799356 still waiting for AccessExclusiveLock on relation 5840065 of database 358220 after 1000.055 ms
Detail: Process holding the lock: 3824626. Wait queue: 3799356.
Statement: DROP TABLE IF EXISTS temp0000293682;Date: 2026-10-07 17:05:41 Database: rio Application: [unknown] User: intelifix Remote: [local]
13 1 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #13
Day Hour Count Oct 07 14 1 - LOG: process 3654960 still waiting for ShareLock on transaction 7383788 after 1000.076 ms
Detail: Process holding the lock: 3655045. Wait queue: 3654960.
Context: while updating tuple (20307,143) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer,boolean) line 142 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1044 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(293940,450,'ZTE3ANNRAM21733,5872C9893597,5872C9893598,ZTEGDC6054E4$ZTE3ANNRCP17648,6C11BA6AC86F,6C11BA6AC870,ZTEGDC6F8583$ZTE3ANNQ4N02715,3CF9F0A8D150,3CF9F0A8D151,ZTEGD6410D96$ZTE3ANNR3J13429,F4E84F87891E,F4E84F87891F,ZTEGD97B963F$ZTE3ANNQ5N07788,3CF9F0AD7BFE,3CF9F0AD7BFF,ZTEGD641D4B3$ZTE3ANNQ8M44233,843C9922D4A1,843C9922D4A2,ZTEGD7BAF436$ZTE3ANNR9F29749,D89A0DA59721,D89A0DA59722,ZTEGDB159B80$ZTE3ANNQ9J13795,843C992D1487,843C992D1488,ZTEGD7BB3E8E$ZTE3ANNRB728610,5872C990D7BD,5872C990D7BE,ZTEGDC619A95$ZTE3ANNR2Q20095,F4E84F828AFA,F4E84F828AFB,ZTEGD97AC139$ZTE3ANNT2V30855,D831398E6202,D831398E6203,ZTEGDD306B06$ZTE3ANNQ5B07433,3CF9F0AF2DF0,3CF9F0AF2DF1,ZTEGD6421D06$ZTE3ANNR5W36063,48D68231D104,48D68231D105,ZTEGDB008CDE$ZTE3ANNR3Y38669,4896D9534B06,4896D9534B07,ZTEGD97EC7C2$ZTE3ANNT2V01612,D831398BB4A0,D831398BB4A1,ZTEGDD2FF8CB$ZTE3ANNT4Q02011,F00C5154FD7A,F00C5154FD7B,ZTEGDE358510$ZTE3ANNQ5200481,3CF9F0A7365C,3CF9F0A7365D,ZTEGD640C918$ZTE3ANNQ9J16949,843C992D5E73,843C992D5E74,ZTEGD7BB4AE0$ZTE3ANNRC509223,6C11BA630201,6C11BA630202,ZTEGDC6E39C6$ZTE3ANNRC573845,6C11BA68EC95,6C11BA68EC96,ZTEGDC6F3634$ZTE3ANNT4Q01033,F00C5154E68E,F00C5154E68F,ZTEGDE35813E$ZTE3ANNR5W35048,48D68231B93A,48D68231B93B,ZTEGDB0088E7$ZTE3ANNQ8F14384,689E29FD73FD,689E29FD73FE,ZTEGD7BA3500$ZTE3ANNT4Q00764,F00C5154E040,F00C5154E041,ZTEGDE358031$ZTE3ANNRC511486,6C11BA63370B,6C11BA63370C,ZTEGDC6E429D$ZTE3ANNR4N54703,4896D95A5D32,4896D95A5D33,ZTEGD97FF574$ZTE3ANNQ4N14549,3CF9F0A9E6AC,3CF9F0A9E6AD,ZTEGD6413BD0$ZTE3ANNRCP13777,6C11BA6A6DB5,6C11BA6A6DB6,ZTEGDC6F7664$ZTE3ANNR5W57180,48D68233BFF2,48D68233BFF3,ZTEGDB00DF5B$ZTE3ANNR3Y02230,4896D94FF4FC,4896D94FF4FD,ZTEGD97E396B$ZTE3ANNT4P25397,F00C514DF9DC,F00C514DF9DD,ZTEGDE3459CB$ZTE3ANNT3H09472,D8313997A198,D8313997A199,ZTEGDD31F59F$ZTE3ANNR7B48215,3891484D56B1,3891484D56B2,ZTEGDB084DB7$ZTE3ANNT3H48451,D831399B332A,D831399B332B,ZTEGDD328DE2$ZTE3ANNQ4N09386,3CF9F0A96DAA,3CF9F0A96DAB,ZTEGD64127A5$ZTE3ANNR2Q43327,F4E84F84AB7A,F4E84F84AB7B,ZTEGD97B1BF9$ZTE3ANNQ9J18963,843C992D8DA7,843C992D8DA8,ZTEGD7BB52BE$ZTE3ANNRAD16506,D89A0DAF5D3F,D89A0DAF5D40,ZTEGDB173C85$ZTE3ANNRAD12877,D89A0DAF0831,D89A0DAF0832,ZTEGDB172E58$ZTE3ANNR6R46940,48D68239D0EA,48D68239D0EB,ZTEGDB01E22F','',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',00);Date: 2026-10-07 14:06:12 Database: rio Application: [unknown] User: intelifix Remote: [local]