pgBadger-
Global information
- Generated on Wed Aug 26 23:50:19 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 48,459 log entries in 17s
- Log start from 2026-08-25 00:00:56 to 2026-08-25 23:59:51
-
Overview
Global Stats
- 442 Number of unique normalized queries
- 8,065 Number of queries
- 10h38m30s Total query duration
- 2026-08-25 00:02:42 First query
- 2026-08-25 23:52:53 Last query
- 20 queries/s at 2026-08-25 16:20:50 Query peak
- 10h38m30s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 10h38m30s Execute total duration
- 4,067 Number of events
- 16 Number of unique normalized events
- 3,977 Max number of times the same event was reported
- 0 Number of cancellation
- 478 Total number of automatic vacuums
- 1,037 Total number of automatic analyzes
- 14 Number temporary file
- 242.52 MiB Max size of temporary file
- 103.74 MiB Average size of temporary file
- 380 Total number of sessions
- 19 sessions at 2026-08-25 16:20:47 Session peak
- 13d11h3m Total duration of sessions
- 51m Average duration of sessions
- 21 Average queries per session
- 1m40s Average queries duration per session
- 49m19s Average idle time per session
- 430 Total number of connections
- 11 connections/s at 2026-08-25 16:20:47 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 20 queries/s Query Peak
- 2026-08-25 16:20:50 Date
SELECT Traffic
Key values
- 20 queries/s Query Peak
- 2026-08-25 16:20:50 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-25 23:52:47 Date
Queries duration
Key values
- 10h38m30s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 25 00 27 0ms 39s407ms 6s851ms 6s970ms 7s812ms 1m35s 01 47 0ms 4s831ms 1s115ms 5s908ms 7s896ms 9s753ms 02 18 0ms 6s443ms 2s328ms 5s117ms 6s767ms 9s411ms 03 38 0ms 5s638ms 1s331ms 6s330ms 7s716ms 10s468ms 04 39 0ms 6s136ms 1s514ms 6s770ms 9s746ms 11s357ms 05 24 0ms 10m44s 1m1s 13s377ms 3m24s 10m44s 06 24 0ms 42s212ms 5s896ms 5s366ms 24s249ms 51s166ms 07 167 0ms 11m25s 16s457ms 1m9s 8m52s 11m27s 08 770 150ms 7m34s 4s528ms 1m50s 7m47s 8m44s 09 962 150ms 9m25s 3s679ms 1m40s 7m21s 10m22s 10 677 0ms 9m32s 4s209ms 1m51s 3m50s 9m58s 11 702 150ms 11m49s 5s396ms 5m46s 6m48s 11m57s 12 161 0ms 6m47s 8s798ms 27s460ms 3m44s 6m55s 13 350 0ms 6m29s 3s59ms 22s886ms 56s412ms 6m30s 14 880 151ms 7m48s 3s960ms 1m28s 7m45s 10m44s 15 1,052 150ms 7m16s 2s701ms 58s190ms 6m6s 8m9s 16 932 0ms 9m34s 2s307ms 1m16s 1m56s 10m27s 17 660 0ms 13m27s 3s21ms 42s965ms 2m20s 13m54s 18 23 0ms 5m59s 29s762ms 6s667ms 11s545ms 6m53s 19 23 0ms 5m53s 28s900ms 7s231ms 50s181ms 5m53s 20 150 0ms 9m47s 11s570ms 1m15s 1m56s 9m47s 21 31 0ms 6m17s 23s506ms 11s428ms 21s141ms 6m51s 22 30 0ms 5m56s 23s122ms 7s806ms 48s362ms 5m56s 23 278 0ms 1m46s 8s722ms 1m9s 1m14s 1m47s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 25 00 4 0 13s600ms 0ms 0ms 363ms 01 29 0 343ms 298ms 593ms 1s178ms 02 0 0 0ms 0ms 0ms 0ms 03 20 0 252ms 179ms 344ms 544ms 04 21 0 299ms 189ms 253ms 902ms 05 4 0 352ms 0ms 0ms 0ms 06 10 0 8s413ms 0ms 0ms 24s249ms 07 116 0 19s440ms 7s184ms 55s290ms 8m52s 08 572 0 4s769ms 26s352ms 1m33s 7m38s 09 738 0 3s268ms 15s620ms 1m19s 7m6s 10 500 0 4s206ms 24s745ms 1m6s 8m27s 11 516 0 6s248ms 12s293ms 5m32s 7m25s 12 106 0 11s627ms 5s737ms 27s460ms 5m30s 13 262 0 3s647ms 8s639ms 22s886ms 3m42s 14 693 0 3s687ms 22s103ms 1m11s 7m44s 15 875 0 2s531ms 19s403ms 36s414ms 7m20s 16 754 0 2s87ms 20s187ms 53s816ms 1m54s 17 545 0 3s448ms 23s251ms 36s396ms 5m27s 18 7 0 1m29s 0ms 0ms 3m31s 19 6 0 1m41s 0ms 0ms 3m24s 20 32 92 13s328ms 41s200ms 1m11s 5m12s 21 9 0 1m11s 0ms 0ms 3m23s 22 6 0 1m42s 0ms 0ms 3m29s 23 27 251 8s722ms 1m5s 1m7s 1m19s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 25 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Aug 25 00 0 0 0.00 0.00% 01 0 3 3.00 0.00% 02 0 0 0.00 0.00% 03 0 2 2.00 0.00% 04 0 2 2.00 0.00% 05 0 1 1.00 0.00% 06 0 2 2.00 0.00% 07 0 11 11.00 0.00% 08 0 23 23.00 0.00% 09 0 24 24.00 0.00% 10 0 29 29.00 0.00% 11 0 14 14.00 0.00% 12 0 11 11.00 0.00% 13 0 14 14.00 0.00% 14 0 21 21.00 0.00% 15 0 11 11.00 0.00% 16 0 29 29.00 0.00% 17 0 6 6.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 2 2.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 4 4.00 0.00% Day Hour Count Average / Second Aug 25 00 17 0.00/s 01 11 0.00/s 02 9 0.00/s 03 20 0.01/s 04 8 0.00/s 05 14 0.00/s 06 14 0.00/s 07 15 0.00/s 08 27 0.01/s 09 25 0.01/s 10 42 0.01/s 11 19 0.01/s 12 19 0.01/s 13 15 0.00/s 14 25 0.01/s 15 21 0.01/s 16 44 0.01/s 17 17 0.00/s 18 8 0.00/s 19 11 0.00/s 20 16 0.00/s 21 9 0.00/s 22 10 0.00/s 23 14 0.00/s Day Hour Count Average Duration Average idle time Aug 25 00 6 1h 59m29s 01 16 1h56s 1h53s 02 11 1h16s 1h13s 03 19 22m49s 22m47s 04 10 1h2m32s 1h2m26s 05 8 1h45s 57m40s 06 11 1h5s 59m52s 07 14 1h8s 56m52s 08 17 49m31s 46m6s 09 25 55m51s 53m29s 10 23 30m29s 28m25s 11 23 1h49s 58m5s 12 24 47m25s 46m26s 13 14 59m53s 58m36s 14 18 56m24s 53m11s 15 23 58m34s 56m30s 16 24 18m52s 17m22s 17 23 57m56s 56m30s 18 15 1h39s 59m54s 19 9 55m 53m46s 20 13 47m44s 45m30s 21 12 1h46s 59m46s 22 9 1h39s 59m22s 23 13 43m58s 40m52s -
Connections
Established Connections
Key values
- 11 connections Connection Peak
- 2026-08-25 16:20:47 Date
Connections per database
Key values
- rio Main Database
- 430 connections Total
Connections per user
Key values
- intelifix Main User
- 430 connections Total
-
Sessions
Simultaneous sessions
Key values
- 19 sessions Session Peak
- 2026-08-25 16:20:47 Date
Histogram of session times
Key values
- 289 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 380 sessions Total
Sessions per user
Key values
- intelifix Main User
- 380 sessions Total
Sessions per host
Key values
- [local] Main Host
- 380 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 66,528 buffers Checkpoint Peak
- 2026-08-25 00:09:43 Date
- 271.436 seconds Highest write time
- 0.780 seconds Sync time
Checkpoints Wal files
Key values
- 26 files Wal files usage Peak
- 2026-08-25 10:33:38 Date
Checkpoints distance
Key values
- 812.82 Mo Distance Peak
- 2026-08-25 10:33:38 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 25 00 82,410 633.804s 0.092s 634.006s 01 3,123 313.912s 0.142s 314.128s 02 1,368 137.538s 0.182s 137.762s 03 2,323 232.904s 0.246s 233.218s 04 4,230 425.277s 0.225s 425.587s 05 9,771 979.126s 0.287s 979.484s 06 4,188 269.602s 0.005s 269.617s 07 28,023 2,126.559s 0.384s 2,127.088s 08 64,569 3,237.865s 1.257s 3,239.334s 09 68,819 3,237.875s 1.465s 3,239.681s 10 90,083 1,891.766s 1.179s 1,893.187s 11 78,965 3,237.081s 2.1s 3,239.562s 12 28,562 2,128.408s 0.708s 2,129.227s 13 18,679 1,921.997s 0.728s 1,922.861s 14 66,824 3,210.921s 2.125s 3,213.277s 15 64,607 3,238.852s 1.531s 3,240.616s 16 52,726 1,890.219s 0.798s 1,891.25s 17 32,619 2,415.634s 1.017s 2,417.178s 18 908 90.867s 0.136s 91.118s 19 28 2.821s 0.094s 2.962s 20 1,271 386.946s 0.09s 387.15s 21 2,628 263.301s 0.267s 263.814s 22 1,751 175.642s 0.278s 176.053s 23 523 52.509s 0.141s 52.8s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 25 00 0 0 11 493 0.020s 0.013s 01 0 0 1 691 0.032s 0.025s 02 0 0 1 396 0.098s 0.007s 03 0 0 1 608 0.076s 0.013s 04 0 0 1 864 0.065s 0.011s 05 0 0 4 602 0.034s 0.011s 06 0 0 1 24 0.002s 0.001s 07 0 0 17 2,482 0.037s 0.012s 08 0 0 43 6,434 0.051s 0.012s 09 0 0 84 7,822 0.086s 0.012s 10 0 0 46 5,187 0.336s 0.008s 11 0 0 59 8,131 0.075s 0.012s 12 0 0 15 2,955 0.083s 0.012s 13 0 0 6 4,100 0.092s 0.012s 14 0 0 50 6,930 0.448s 0.013s 15 0 0 47 6,961 0.053s 0.012s 16 0 0 23 4,802 0.054s 0.008s 17 0 0 23 4,898 0.062s 0.011s 18 0 0 1 46 0.049s 0.039s 19 0 0 0 4 0.078s 0.024s 20 0 0 1 106 0.040s 0.023s 21 0 0 1 393 0.079s 0.024s 22 0 0 0 405 0.068s 0.039s 23 0 0 0 114 0.064s 0.016s Day Hour Count Avg time (sec) Aug 25 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Aug 25 00 26,448.14 kB 78,869.29 kB 01 1,603.40 kB 34,391.90 kB 02 1,196.83 kB 15,118.67 kB 03 1,113.20 kB 2,383.90 kB 04 2,131.10 kB 3,432.90 kB 05 8,394.88 kB 13,263.12 kB 06 11,985.00 kB 13,486.00 kB 07 23,009.50 kB 47,483.50 kB 08 59,529.25 kB 107,525.92 kB 09 114,874.00 kB 171,059.00 kB 10 93,396.00 kB 269,685.12 kB 11 81,257.33 kB 201,188.33 kB 12 19,931.08 kB 84,523.50 kB 13 8,405.25 kB 29,999.33 kB 14 67,661.50 kB 91,104.17 kB 15 63,928.67 kB 117,135.75 kB 16 49,029.62 kB 91,726.75 kB 17 34,256.91 kB 60,850.91 kB 18 578.40 kB 37,546.60 kB 19 193.00 kB 27,111.00 kB 20 3,953.00 kB 21,486.20 kB 21 2,132.00 kB 12,794.83 kB 22 1,321.00 kB 7,251.14 kB 23 226.00 kB 4,029.83 kB -
Temporary Files
Size of temporary files
Key values
- 485.03 MiB Temp Files size Peak
- 2026-08-25 05:32:13 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-25 05:32:20 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 25 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 12 1.22 GiB 103.70 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 1 104.00 MiB 104.00 MiB 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 1 104.00 MiB 104.00 MiB 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 942.15 MiB 72.33 MiB 242.52 MiB 117.77 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-25 05:32:22 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-25 05:32:13 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 302.24 MiB 56.18 MiB 92.45 MiB 75.56 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-25 05:30:47 Duration: 45s17ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-25 05:30:43 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 2 208.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-08-03''),DATE(''2026-08-24'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-08-25 16:07:02 Duration: 9m34s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029002, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-25 10:58:16 Duration: 9m32s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028921, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-25 07:21:04 Duration: 8m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 242.52 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-25 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 242.52 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-25 05:32:13 - 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-08-25 16:27:27 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 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-08-25 10:14:04 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 92.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-25 05:30:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 92.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-25 05:30:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 80.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-25 05:32:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 79.99 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-25 05:32:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 79.99 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-25 05:32:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 72.40 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-25 05:32:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 72.33 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-25 05:32:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 72.33 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-25 05:32:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 61.16 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-25 05:30:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 56.18 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-25 05:30:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.43 sec Highest CPU-cost vacuum
Table public.temp0000289492
Database rio - 2026-08-25 08:56:29 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.43 sec Highest CPU-cost vacuum
Table public.temp0000289492
Database rio - 2026-08-25 08:56:29 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (93) Main table analyzed (database rio)
- 1,037 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 93 rio.pg_catalog.pg_class 51 rio.public.temp0000289508 47 rio.public.usuarios 45 brasilia.pg_catalog.pg_attribute 45 rio.pg_catalog.pg_type 42 contagem.pg_catalog.pg_attribute 41 contagem.public.temp0000226917 36 rio.public.temp0000289575 36 rio.public.temp0000289597 34 rio.pg_catalog.pg_index 28 brasilia.pg_catalog.pg_class 25 contagem.pg_catalog.pg_class 25 rio.public.temp0000289492 25 contagem.public.temp0000226915 25 contagem.public.temp0000226961 24 brasilia.pg_catalog.pg_type 21 rio.pg_catalog.pg_depend 21 contagem.public.usuarios 20 contagem.pg_catalog.pg_type 20 rio.public.temp0000289488 18 contagem.public.temp0000226965 17 rio.public.temp0000289528 16 rio.public.temp0000289223 13 brasilia.pg_catalog.pg_index 13 brasilia.public.temp0000238846 12 contagem.pg_catalog.pg_index 12 rio.public.temp0000289498 11 brasilia.public.temp0000238840 10 brasilia.pg_catalog.pg_depend 10 rio.public.temp0000289448 9 rio.public.temp0000289392 9 rio.public.temp0000289516 9 brasilia.public.temp0000238848 8 rio.public.temp0000289484 8 contagem.pg_catalog.pg_depend 8 rio.public.temp0000289589 8 contagem.public.temp0000226919 7 rio.public.temp0000289370 7 brasilia.public.usuarios 7 rio.public.temp0000289496 6 brasilia.public.temp0000238836 6 rio.public.temp0000289536 6 brasilia.public.temp0000238832 6 rio.public.temp0000289542 5 brasilia.pg_catalog.pg_shdepend 5 contagem.pg_catalog.pg_shdepend 5 rio.public.tmp_drill_0175 4 rio.public.temp0000289619 4 brasilia.public.temp0000238850 4 rio.public.tmp_drill_0302 4 rio.public.tmp_drill_0320 3 rio.public.temp0000289623 3 rio.pg_catalog.pg_shdepend 3 rio.public.temp0000289658 3 contagem.public.temp0000226959 3 brasilia.public.nf_entrada 3 brasilia.public.temp0000238830 2 rio.public.temp0000289502 2 rio.public.temp0000289611 2 brasilia.public.temp0000238878 2 brasilia.public.temp0000238854 2 brasilia.public.temp0000238882 2 rio.public.temp0000289486 2 brasilia.public.temp0000238888 2 rio.public.temp0000289595 2 rio.public.temp0000289621 2 rio.public.temp0000289591 1 contagem.public.temp0000226921 1 brasilia.public.temp0000238858 1 rio.public.temp0000289514 1 brasilia.public.temp0000238876 1 brasilia.public.temp0000238884 1 rio.public.temp0000289668 1 rio.public.temp0000289534 1 contagem.public.temp0000226956 1 contagem.public.nf_entrada 1 contagem.public.temp0000226969 1 brasilia.public.temp0000238870 1 rio.public.temp0000289504 1 brasilia.public.temp0000238828 1 rio.public.temp0000289512 1 rio.public.temp0000289593 1 rio.public.temp0000289615 1 rio.public.temp0000289603 1 brasilia.public.temp0000238852 1 rio.public.temp0000289583 1 rio.public.temp0000289579 1 rio.public.temp0000289510 1 contagem.public.temp0000226954 1 rio.public.temp0000289538 1 brasilia.public.temp0000238844 1 brasilia.public.temp0000238872 1 rio.public.temp0000289656 1 contagem.public.tmp_dias_226958 1 Total 1,037 Vacuums per table
Key values
- pg_catalog.pg_attribute (45) Main table vacuumed on database rio
- 478 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 45 35 0 0 0 0 0 18,613 5,163 7,496,044 304 7,414 rio.public.temp0000289508 36 0 0 0 0 0 0 10,232 312 849,897 0 0 rio.public.temp0000289575 36 0 0 0 0 0 0 32,682 3,846 6,830,970 0 0 rio.pg_catalog.pg_class 31 21 0 0 0 0 0 4,330 1,383 1,984,722 86 316 rio.public.temp0000289492 25 0 0 0 0 0 0 16,709 2,018 3,565,553 0 0 rio.pg_catalog.pg_type 20 16 0 0 0 0 0 1,679 513 641,400 62 226 contagem.public.usuarios 19 0 0 0 0 0 0 98 74 39,194 0 0 rio.public.temp0000289528 16 0 0 0 0 0 0 14,072 1,809 3,099,897 0 0 brasilia.pg_catalog.pg_attribute 15 15 0 0 0 0 0 7,679 1,643 2,908,273 49 1,304 rio.pg_catalog.pg_index 15 11 0 0 0 0 0 545 163 175,784 25 72 rio.public.tmp_drill_0320 15 3 0 0 0 0 0 2,201 24 375,800 1 65 rio.public.temp0000289597 15 0 0 0 0 0 0 932 74 67,359 0 0 contagem.pg_catalog.pg_attribute 14 14 0 0 0 0 0 8,617 2,236 4,058,359 32 808 rio.public.usuarios 10 6 0 0 0 0 0 125 37 70,005 6 76 rio.public.temp0000289223 10 0 0 0 0 0 0 537 180 254,991 0 0 brasilia.pg_catalog.pg_class 10 10 0 0 0 0 0 2,136 417 712,096 23 71 rio.public.temp0000289448 9 0 0 0 0 0 0 718 45 49,632 0 0 brasilia.pg_catalog.pg_type 9 9 0 0 0 0 0 878 192 293,552 13 40 rio.public.temp0000289516 8 0 0 0 0 0 0 719 47 49,600 0 0 rio.pg_catalog.pg_depend 8 8 0 0 0 0 0 2,692 998 1,332,987 56 498 contagem.pg_catalog.pg_class 7 7 0 0 0 0 0 1,490 371 588,597 14 48 rio.public.tmp_drill_0302 7 4 0 0 0 0 0 107 13 24,968 0 0 rio.public.temp0000289370 7 0 0 0 0 0 0 628 38 43,207 0 0 brasilia.pg_catalog.pg_index 6 6 0 0 0 0 0 367 100 79,220 13 23 contagem.pg_catalog.pg_type 6 6 0 0 0 0 0 606 191 303,344 8 20 rio.public.temp0000289536 5 0 0 0 0 0 0 5,353 21 319,090 0 0 rio.pg_catalog.pg_statistic 5 5 0 0 0 0 0 8,774 2,379 10,693,122 1,385 7,176 brasilia.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 825 255 444,233 55 111 brasilia.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,244 373 548,148 16 126 rio.public.tmp_drill_0175 4 4 0 0 0 0 0 197 12 45,225 0 0 rio.public.temp0000289589 4 0 0 0 0 0 0 1,950 21 118,314 0 0 brasilia.public.temp0000238850 4 0 0 0 0 0 0 747 258 425,616 0 0 rio.public.temp0000289542 4 0 0 0 0 0 0 3,516 14 209,726 0 0 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 228 43 71,005 3 3 rio.public.temp0000289623 3 0 0 0 0 0 0 5,268 1,764 2,574,552 0 0 rio.public.temp0000289392 3 0 0 0 0 0 0 321 17 21,804 0 0 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 1,206 315 676,990 10 79 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,579 427 2,050,365 150 400 brasilia.public.temp0000238882 2 0 0 0 0 0 0 494 252 411,589 0 0 brasilia.public.temp0000238888 2 0 0 0 0 0 0 494 252 411,592 0 0 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,336 523 2,147,044 372 2,783 rio.public.temp0000289611 2 0 0 0 0 0 0 1,851 10 110,742 0 0 rio.public.temp0000289510 1 0 0 0 0 0 0 81 6 5,680 0 0 contagem.public.nf_entrada 1 1 0 0 0 0 0 89 4 15,207 0 0 contagem.public.temp0000226956 1 0 0 0 0 0 0 112 6 7,572 0 0 rio.public.temp0000289603 1 0 0 0 0 0 0 95 6 6,536 0 0 rio.public.temp0000289514 1 0 0 0 0 0 0 8 5 1,294 0 0 brasilia.public.temp0000238852 1 0 0 0 0 0 0 247 4 15,176 0 0 rio.public.temp0000289593 1 0 0 0 0 0 0 94 6 6,478 0 0 rio.public.temp0000289512 1 0 0 0 0 0 0 8 5 1,295 0 0 rio.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 217 70 78,053 7 10 brasilia.public.nf_entrada 1 1 0 0 0 0 0 198 98 253,131 8 9 rio.public.temp0000289615 1 0 0 0 0 0 0 100 6 6,840 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 140 25 53,234 11 24 contagem.public.temp0000226969 1 0 0 0 0 0 0 112 6 7,572 0 0 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 163 39 109,428 9 12 rio.public.temp0000289538 1 0 0 0 0 0 0 87 6 6,049 0 0 rio.public.temp0000289502 1 0 0 0 0 0 0 8 5 1,219 0 0 brasilia.public.temp0000238872 1 0 0 0 0 0 0 247 4 15,176 0 0 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,765 396 1,593,586 360 2,544 rio.public.temp0000289656 1 0 0 0 0 0 0 101 6 6,908 0 0 rio.public.temp0000289504 1 0 0 0 0 0 0 81 6 5,684 0 0 Total 478 207 0 0 0 0 0 171,728 29,532 59,370,726 3,078 24,258 Vacuum throughput per table
Key values
- pg_catalog.pg_attribute (3.63) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 3.63 rio.public.temp0000289508 0 0 0.99 rio.public.temp0000289575 0 0 1.27 rio.pg_catalog.pg_class 0 0 1.08 rio.public.temp0000289492 0 0 1.25 rio.pg_catalog.pg_type 0 0 0.37 contagem.public.usuarios 0 0 0.04 rio.public.temp0000289528 0 0 0.81 brasilia.pg_catalog.pg_attribute 0 0 1.73 rio.pg_catalog.pg_index 0 0 0.42 rio.public.tmp_drill_0320 0 0 0.09 rio.public.temp0000289597 0 0 0.25 contagem.pg_catalog.pg_attribute 0 0 2.17 rio.public.usuarios 0 0 0 rio.public.temp0000289223 0 0 0.13 brasilia.pg_catalog.pg_class 0 0 0.78 rio.public.temp0000289448 0 0 0.11 brasilia.pg_catalog.pg_type 0 0 0.24 rio.public.temp0000289516 0 0 0.1 rio.pg_catalog.pg_depend 0 0 1.16 contagem.pg_catalog.pg_class 0 0 0.84 rio.public.tmp_drill_0302 0 0 0 rio.public.temp0000289370 0 0 0.08 brasilia.pg_catalog.pg_index 0 0 0.17 contagem.pg_catalog.pg_type 0 0 0.49 rio.public.temp0000289536 0 0 0.26 rio.pg_catalog.pg_statistic 0 0 1.44 brasilia.pg_catalog.pg_shdepend 0 0 0.44 brasilia.pg_catalog.pg_depend 0 0 0.55 rio.public.tmp_drill_0175 0 0 0 rio.public.temp0000289589 0 0 0.09 brasilia.public.temp0000238850 0 0 0.01 rio.public.temp0000289542 0 0 0.19 contagem.pg_catalog.pg_index 0 0 0.11 rio.public.temp0000289623 0 0 0.2 rio.public.temp0000289392 0 0 0.03 contagem.pg_catalog.pg_depend 0 0 0.45 rio.pg_toast.pg_toast_2619 0 0 0.26 brasilia.public.temp0000238882 0 0 0.01 brasilia.public.temp0000238888 0 0 0.01 contagem.pg_catalog.pg_statistic 0 0 0.35 rio.public.temp0000289611 0 0 0.06 rio.public.temp0000289510 0 0 0.02 contagem.public.nf_entrada 0 0 0.05 contagem.public.temp0000226956 0 0 0.01 rio.public.temp0000289603 0 0 0.02 rio.public.temp0000289514 0 0 0.01 brasilia.public.temp0000238852 0 0 0 rio.public.temp0000289593 0 0 0.01 rio.public.temp0000289512 0 0 0.01 rio.pg_catalog.pg_shdepend 0 0 0.17 brasilia.public.nf_entrada 0 0 0.11 rio.public.temp0000289615 0 0 0.01 contagem.pg_toast.pg_toast_2619 0 0 0 contagem.public.temp0000226969 0 0 0.01 brasilia.pg_toast.pg_toast_2619 0 0 0.01 rio.public.temp0000289538 0 0 0.01 rio.public.temp0000289502 0 0 0.01 brasilia.public.temp0000238872 0 0 0 brasilia.pg_catalog.pg_statistic 0 0 0.24 rio.public.temp0000289656 0 0 0.02 rio.public.temp0000289504 0 0 0.01 Total 0 0 23.39 Tuples removed per table
Key values
- pg_catalog.pg_attribute (139158) Main table with removed tuples on database rio
- 386415 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 45 35 139,158 1,163,865 121,278 363 27,018 brasilia.pg_catalog.pg_attribute 15 15 71,070 329,678 64 275 8,236 contagem.pg_catalog.pg_attribute 14 14 68,653 328,904 0 0 7,905 rio.public.tmp_drill_0320 15 3 33,494 37,454 1,980 0 901 rio.pg_catalog.pg_statistic 5 5 11,060 40,832 0 0 6,430 rio.pg_catalog.pg_depend 8 8 6,676 157,919 4,746 13 1,449 rio.pg_catalog.pg_type 20 16 6,239 51,618 5,920 5 1,506 brasilia.pg_catalog.pg_shdepend 5 5 6,160 68,432 430 0 620 contagem.pg_catalog.pg_statistic 2 2 6,011 14,995 0 0 2,022 brasilia.pg_catalog.pg_class 10 10 5,796 34,472 20 61 1,226 brasilia.pg_catalog.pg_depend 4 4 4,192 72,013 0 16 695 rio.pg_catalog.pg_class 31 21 3,952 131,781 23,277 12 4,188 brasilia.pg_catalog.pg_statistic 1 1 3,903 7,346 0 0 1,072 brasilia.pg_catalog.pg_type 9 9 3,721 19,893 0 28 604 brasilia.pg_catalog.pg_index 6 6 1,893 11,271 5 6 336 rio.pg_catalog.pg_index 15 11 1,886 31,939 3,026 8 820 contagem.pg_catalog.pg_depend 3 3 1,726 57,740 0 0 556 contagem.pg_catalog.pg_index 4 4 1,407 7,620 0 0 214 contagem.pg_catalog.pg_class 7 7 1,319 29,257 0 0 1,687 brasilia.public.nf_entrada 1 1 1,299 4,605 0 0 152 rio.public.tmp_drill_0175 4 4 1,282 2,453 0 0 67 rio.pg_catalog.pg_shdepend 1 1 1,188 13,561 0 0 124 contagem.public.usuarios 19 0 1,130 456 0 0 38 rio.pg_toast.pg_toast_2619 3 3 1,080 1,922 19 0 828 contagem.public.nf_entrada 1 1 896 1,606 0 0 79 contagem.pg_catalog.pg_type 6 6 425 13,560 0 0 414 rio.public.tmp_drill_0302 7 4 296 1,687 339 0 36 rio.public.usuarios 10 6 233 6,563 1,473 0 210 brasilia.pg_toast.pg_toast_2619 1 1 149 127 0 0 67 contagem.pg_toast.pg_toast_2619 1 1 121 114 0 0 55 rio.public.temp0000289516 8 0 0 32,146 0 301 723 brasilia.public.temp0000238882 2 0 0 6,490 0 0 512 rio.public.temp0000289510 1 0 0 1,349 0 55 73 contagem.public.temp0000226956 1 0 0 1,343 0 24 104 rio.public.temp0000289536 5 0 0 100,440 0 49 7,247 rio.public.temp0000289623 3 0 0 74,348 0 0 5,376 rio.public.temp0000289603 1 0 0 1,568 0 41 87 rio.public.temp0000289448 9 0 0 46,283 0 281 1,063 rio.public.temp0000289508 36 0 0 350,584 0 1,043 23,213 rio.public.temp0000289392 3 0 0 17,311 0 121 391 rio.public.temp0000289514 1 0 0 1,350 0 55 73 brasilia.public.temp0000238852 1 0 0 3,244 0 0 256 brasilia.public.temp0000238888 2 0 0 6,496 0 0 512 rio.public.temp0000289589 4 0 0 34,382 0 120 2,056 rio.public.temp0000289593 1 0 0 1,566 0 42 86 rio.public.temp0000289512 1 0 0 1,349 0 55 73 rio.public.temp0000289223 10 0 0 31,478 0 264 696 rio.public.temp0000289528 16 0 0 372,732 0 50 26,958 rio.public.temp0000289615 1 0 0 1,630 0 36 92 rio.public.temp0000289575 36 0 0 505,198 0 618 35,606 brasilia.public.temp0000238850 4 0 0 12,971 0 0 1,024 rio.public.temp0000289542 4 0 0 99,018 0 0 7,168 contagem.public.temp0000226969 1 0 0 1,344 0 24 104 rio.public.temp0000289538 1 0 0 1,447 0 49 79 rio.public.temp0000289611 2 0 0 26,346 0 41 1,879 rio.public.temp0000289502 1 0 0 1,868 0 22 42 rio.public.temp0000289492 25 0 0 314,434 0 694 22,474 brasilia.public.temp0000238872 1 0 0 3,244 0 0 256 rio.public.temp0000289597 15 0 0 100,610 0 383 5,057 rio.public.temp0000289370 7 0 0 36,126 0 207 817 rio.public.temp0000289656 1 0 0 1,641 0 35 93 rio.public.temp0000289504 1 0 0 1,349 0 55 73 Total 478 207 386,415 4,835,368 162,577 5,452 213,818 Pages removed per table
Key values
- public.temp0000289508 (1043) Main table with removed pages on database rio
- 5452 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000289508 36 0 0 1043 rio.public.temp0000289492 25 0 0 694 rio.public.temp0000289575 36 0 0 618 rio.public.temp0000289597 15 0 0 383 rio.pg_catalog.pg_attribute 45 35 139158 363 rio.public.temp0000289516 8 0 0 301 rio.public.temp0000289448 9 0 0 281 brasilia.pg_catalog.pg_attribute 15 15 71070 275 rio.public.temp0000289223 10 0 0 264 rio.public.temp0000289370 7 0 0 207 rio.public.temp0000289392 3 0 0 121 rio.public.temp0000289589 4 0 0 120 brasilia.pg_catalog.pg_class 10 10 5796 61 rio.public.temp0000289510 1 0 0 55 rio.public.temp0000289514 1 0 0 55 rio.public.temp0000289512 1 0 0 55 rio.public.temp0000289504 1 0 0 55 rio.public.temp0000289528 16 0 0 50 rio.public.temp0000289536 5 0 0 49 rio.public.temp0000289538 1 0 0 49 rio.public.temp0000289593 1 0 0 42 rio.public.temp0000289603 1 0 0 41 rio.public.temp0000289611 2 0 0 41 rio.public.temp0000289615 1 0 0 36 rio.public.temp0000289656 1 0 0 35 brasilia.pg_catalog.pg_type 9 9 3721 28 contagem.public.temp0000226956 1 0 0 24 contagem.public.temp0000226969 1 0 0 24 rio.public.temp0000289502 1 0 0 22 brasilia.pg_catalog.pg_depend 4 4 4192 16 rio.pg_catalog.pg_depend 8 8 6676 13 rio.pg_catalog.pg_class 31 21 3952 12 rio.pg_catalog.pg_index 15 11 1886 8 brasilia.pg_catalog.pg_index 6 6 1893 6 rio.pg_catalog.pg_type 20 16 6239 5 brasilia.public.temp0000238882 2 0 0 0 contagem.public.nf_entrada 1 1 896 0 contagem.pg_catalog.pg_class 7 7 1319 0 rio.public.temp0000289623 3 0 0 0 rio.public.tmp_drill_0320 15 3 33494 0 rio.public.usuarios 10 6 233 0 rio.public.tmp_drill_0175 4 4 1282 0 brasilia.public.temp0000238852 1 0 0 0 rio.public.tmp_drill_0302 7 4 296 0 brasilia.public.temp0000238888 2 0 0 0 contagem.public.usuarios 19 0 1130 0 contagem.pg_catalog.pg_statistic 2 2 6011 0 rio.pg_catalog.pg_shdepend 1 1 1188 0 rio.pg_catalog.pg_statistic 5 5 11060 0 contagem.pg_catalog.pg_type 6 6 425 0 brasilia.public.nf_entrada 1 1 1299 0 contagem.pg_toast.pg_toast_2619 1 1 121 0 contagem.pg_catalog.pg_depend 3 3 1726 0 brasilia.public.temp0000238850 4 0 0 0 rio.public.temp0000289542 4 0 0 0 brasilia.pg_catalog.pg_shdepend 5 5 6160 0 brasilia.pg_toast.pg_toast_2619 1 1 149 0 rio.pg_toast.pg_toast_2619 3 3 1080 0 contagem.pg_catalog.pg_attribute 14 14 68653 0 brasilia.public.temp0000238872 1 0 0 0 contagem.pg_catalog.pg_index 4 4 1407 0 brasilia.pg_catalog.pg_statistic 1 1 3903 0 Total 478 207 386,415 5,452 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 25 00 0 0 01 0 2 02 0 0 03 0 1 04 0 8 05 6 1 06 0 0 07 9 18 08 74 121 09 72 136 10 44 106 11 51 125 12 13 25 13 14 55 14 72 127 15 39 113 16 46 127 17 38 69 18 0 0 19 0 0 20 0 0 21 0 2 22 0 0 23 0 1 - 0.43 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 6 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 5 9m51s 35s359ms 3m2s 1m58s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-25 14:58:25 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-25 07:47:56 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-25 14:37:46 Database: rio User: intelifix Remote: [local] Application: psql
2 1 1s4ms 1s4ms 1s4ms 1s4ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (281316, 452, 'ZTE3ANNQ8101903,689E29BC0B65,689E29BC0B66,ZTEGD7B741FF$ZTE3ANNR5W35807,48D68231CB04,48D68231CB05,ZTEGDB008BDE$ZTE3ANNT2V31063,D831398E66E2,D831398E66E3,ZTEGDD306BD6$ZTE3ANNR8C43524,38914852831F,389148528320,ZTEGDB092A74$ZTE3ANNT2V37558,D831398EFF1C,D831398EFF1D,ZTEGDD308535$ZTE3ANNQ8F09517,689E29FD01EB,689E29FD01EC,ZTEGD7BA21FD$ZTE3ANNQ5N08209,3CF9F0AD85DC,3CF9F0AD85DD,ZTEGD641D658$ZTE3ANNR9F54217,D89A0DA7D499,D89A0DA7D49A,ZTEGDB15FB14$ZTE3ANNR8C46088,38914852BF37,38914852BF38,ZTEGDB093478$ZTE3ANNRCB01798,D831391DF922,D831391DF923,ZTEGDD29BC9B$ZTE3ANNQ8F11537,689E29FD3143,689E29FD3144,ZTEGD7BA29E1$ZTE3ANNQ8F09980,689E29FD0CC5,689E29FD0CC6,ZTEGD7BA23CC$ZTE3ANNR9F51259,D89A0DA78F45,D89A0DA78F46,ZTEGDB15EF86$ZTE3ANNR9W55155,D89A0DAD68D5,D89A0DAD68D6,ZTEGDB16E91E$ZTE3ANNRAM49107,5872C98BB72B,5872C98BB72C,ZTEGDC60BFD2$ZTE3ANNRCB18715,D831391F85A0,D831391F85A1,ZTEGDD29FEB0$ZTE3ANNR2Q21372,F4E84F82A8E8,F4E84F82A8E9,ZTEGD97AC636$ZTE3ANNQ9J01605,843C992BF6D3,843C992BF6D4,ZTEGD7BB0EF0$ZTE3ANNT2V16301,D831398D0CE6,D831398D0CE7,ZTEGDD30322C$ZTE3ANNQ4412980,3CF9F0AC8F16,3CF9F0AC8F17,ZTEGD641AD37$ZTE3ANNQ3610335,3CF9F0A5C7A8,3CF9F0A5C7A9,ZTEGD6408BFA$ZTE3ANNQ4414357,3CF9F0ACAF5C,3CF9F0ACAF5D,ZTEGD641B298$ZTE3ANNR9F15355,D89A0DA445C5,D89A0DA445C6,ZTEGDB156346$ZTE3ANNR6R44212,48D6823990FA,48D6823990FB,ZTEGDB01D787', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-25 17:19:17 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (281304, 508, '14126785850098500015,D86C5A3C1353,D86C5A3BF6F1,C85D3814DB7E,C85D389F9C08,C85D388BEF93,C85D380F7A1B,C85D3870CDA9,C85D38F0A7EE,C85D380CBDF8,C85D3810E17C,C85D38600090,C85D388489B8,D86C5A3D28D6,C85D38D4C005,D86C5A3DAF34,C85D3817C70B,D86C5A561663,C85D38EC2AAC', '',0151,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-25 14:03:33 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (280903, 452, '270911029485100950,229780192229,229734103859,229672890927,229748165051,229689097782,229810671130,229665155154,229747886988,229735420318,216943782443,229673928995,229663452643,229672217190,229860319308,229784389911,229816231313,229748793351,229689216582,229810467192,216940469403,216943043347,229688723145,229784291013,229806589697,229808152545,229816916890,229850315256,229859223556,216936955356,229688416167,229865856885,229785472228,229806526785,229782009397,229785129411,229879786370,229685304663,229806292038', '246587508700,246538552138,246501746278,246570309109,246518427681,246639548201,246469085975,246548989193,246546563447,246457061626,246496143644,246499572733,246499134351,246424894861,246098339108,246628834046,246552084154,246617664056,246639363233,246474611128,246457063848,246515962537,246587379595,246604729202,246581551329,246627280214,246639695364,246641300516,246477431818,246518363658,246651833036,246596388084,246581324460,246588097578,246584716777,246652208808,246499044163,246596465264,,', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-25 10:00:04 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 3m2s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-25 14:58:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 2m35s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-25 07:47:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 2m26s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-25 14:37:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 1m12s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-25 08:46:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 35s359ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-25 11:55:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 1s4ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (54567, 406, '835225933006295,241703972443$833277940001671,230039512442$835176926002556,241692622536$835153923000282,241680371217$834253937000920,241622467787', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""}]','$$$$','', 00);[ Date: 2026-08-25 11:40:21 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 5,852 Total read queries
- 1,683 Total write queries
Queries by database
Key values
- rio Main database
- 4,545 Requests
- 8h14m37s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 7,843 Requests
User Request type Count Duration etiquetas Total 88 23s167ms select 88 23s167ms intelifix Total 7,843 10h35m12s copy to 343 50m31s ddl 1,340 1h9m28s others 530 1h11m18s select 5,630 7h23m54s lenon Total 134 2m54s select 134 2m54s Duration by user
Key values
- 10h35m12s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 88 23s167ms select 88 23s167ms intelifix Total 7,843 10h35m12s copy to 343 50m31s ddl 1,340 1h9m28s others 530 1h11m18s select 5,630 7h23m54s lenon Total 134 2m54s select 134 2m54s Queries by host
Key values
- [local] Main host
- 8,065 Requests
- 10h38m30s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 6,913 Requests
- 4h54m22s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-25 11:29:24 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 4,064 100-500ms duration
Slowest individual queries
Rank Duration Query 1 13m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-25 17:18:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 11m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-25 11:16:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 11m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-25 07:16:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 10m44s analyze verbose;[ Date: 2026-08-25 05:10:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 9m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-25 20:14:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 9m34s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-08-03''),DATE(''2026-08-24'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-08-25 16:07:02 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 9m32s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029002, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-25 10:58:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 9m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA () NOTICE: table "tmp_entrada" does not exist, skipping;[ Date: 2026-08-25 09:14:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 8m52s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028921, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-25 07:21:04 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 8m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-25 10:13:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m48s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029019, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-25 14:37:42 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 7m34s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028926, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-25 08:20:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 7m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-25 14:12:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 7m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-25 15:12:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 7m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-25 08:12:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 7m11s analyze verbose;[ Date: 2026-08-25 05:17:57 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
17 7m7s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029031, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-25 15:51:22 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 7m5s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028955, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-25 09:43:18 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 6m50s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028929, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-25 08:46:31 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 6m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-25 12:11:48 - 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 2h25m54s 263 160ms 9m34s 33s288ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 25 07 6 15m20s 2m33s 08 45 23m28s 31s303ms 09 61 15m48s 15s548ms 10 11 11m22s 1m2s 11 20 25m8s 1m15s 12 5 7m26s 1m29s 13 26 44s484ms 1s710ms 14 18 20m4s 1m6s 15 22 13m23s 36s529ms 16 21 11m21s 32s450ms 17 28 1m45s 3s752ms [ User: intelifix - Total duration: 2h25m54s - Times executed: 263 ]
[ Application: [unknown] - Total duration: 2h25m54s - Times executed: 263 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-08-03''),DATE(''2026-08-24'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-08-25 16:07:02 Duration: 9m34s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029002, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-25 10:58:16 Duration: 9m32s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028921, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-25 07:21:04 Duration: 8m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 2h2m38s 43 1s561ms 13m27s 2m51s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 25 07 3 12m34s 4m11s 08 3 7m48s 2m36s 09 2 32s279ms 16s139ms 10 2 8m40s 4m20s 11 3 12m56s 4m18s 12 3 7m10s 2m23s 13 3 6m51s 2m17s 14 3 7m47s 2m35s 15 3 7m40s 2m33s 17 3 14m36s 4m52s 18 3 6m17s 2m5s 19 3 6m11s 2m3s 20 3 10m38s 3m32s 21 3 6m38s 2m12s 22 3 6m14s 2m4s [ User: intelifix - Total duration: 2h2m38s - Times executed: 43 ]
[ Application: psql - Total duration: 2h2m38s - Times executed: 43 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-25 17:18:28 Duration: 13m27s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-25 11:16:50 Duration: 11m49s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-25 07:16:26 Duration: 11m25s Database: rio User: intelifix Remote: [local] Application: psql
3 1h17m26s 44 242ms 6m1s 1m45s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 25 07 3 7m10s 2m23s 08 3 5m8s 1m42s 09 3 4m45s 1m35s 10 2 4m40s 2m20s 11 3 8m1s 2m40s 12 3 4m9s 1m23s 13 3 4m11s 1m23s 14 3 4m19s 1m26s 15 3 5m6s 1m42s 17 3 7m32s 2m30s 18 3 4m6s 1m22s 19 3 3m56s 1m18s 20 3 6m23s 2m7s 21 3 3m55s 1m18s 22 3 3m59s 1m19s [ User: intelifix - Total duration: 1h17m26s - Times executed: 44 ]
[ Application: psql - Total duration: 1h17m26s - Times executed: 44 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-25 11:25:44 Duration: 6m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-25 07:24:27 Duration: 5m15s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-25 17:26:49 Duration: 5m14s Database: brasilia User: intelifix Remote: [local] Application: psql
4 29m11s 1,313 150ms 10s991ms 1s333ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 25 08 183 3m8s 1s27ms 09 222 4m10s 1s128ms 10 119 2m6s 1s60ms 11 204 2m46s 817ms 12 26 56s125ms 2s158ms 13 54 1m30s 1s684ms 14 130 4m10s 1s928ms 15 173 5m 1s738ms 16 135 3m33s 1s579ms 17 67 1m48s 1s612ms [ User: intelifix - Total duration: 29m11s - Times executed: 1313 ]
[ Application: [unknown] - Total duration: 29m11s - Times executed: 1313 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (281316, 452, 'ZTE3ANNQ8101903,689E29BC0B65,689E29BC0B66,ZTEGD7B741FF$ZTE3ANNR5W35807,48D68231CB04,48D68231CB05,ZTEGDB008BDE$ZTE3ANNT2V31063,D831398E66E2,D831398E66E3,ZTEGDD306BD6$ZTE3ANNR8C43524,38914852831F,389148528320,ZTEGDB092A74$ZTE3ANNT2V37558,D831398EFF1C,D831398EFF1D,ZTEGDD308535$ZTE3ANNQ8F09517,689E29FD01EB,689E29FD01EC,ZTEGD7BA21FD$ZTE3ANNQ5N08209,3CF9F0AD85DC,3CF9F0AD85DD,ZTEGD641D658$ZTE3ANNR9F54217,D89A0DA7D499,D89A0DA7D49A,ZTEGDB15FB14$ZTE3ANNR8C46088,38914852BF37,38914852BF38,ZTEGDB093478$ZTE3ANNRCB01798,D831391DF922,D831391DF923,ZTEGDD29BC9B$ZTE3ANNQ8F11537,689E29FD3143,689E29FD3144,ZTEGD7BA29E1$ZTE3ANNQ8F09980,689E29FD0CC5,689E29FD0CC6,ZTEGD7BA23CC$ZTE3ANNR9F51259,D89A0DA78F45,D89A0DA78F46,ZTEGDB15EF86$ZTE3ANNR9W55155,D89A0DAD68D5,D89A0DAD68D6,ZTEGDB16E91E$ZTE3ANNRAM49107,5872C98BB72B,5872C98BB72C,ZTEGDC60BFD2$ZTE3ANNRCB18715,D831391F85A0,D831391F85A1,ZTEGDD29FEB0$ZTE3ANNR2Q21372,F4E84F82A8E8,F4E84F82A8E9,ZTEGD97AC636$ZTE3ANNQ9J01605,843C992BF6D3,843C992BF6D4,ZTEGD7BB0EF0$ZTE3ANNT2V16301,D831398D0CE6,D831398D0CE7,ZTEGDD30322C$ZTE3ANNQ4412980,3CF9F0AC8F16,3CF9F0AC8F17,ZTEGD641AD37$ZTE3ANNQ3610335,3CF9F0A5C7A8,3CF9F0A5C7A9,ZTEGD6408BFA$ZTE3ANNQ4414357,3CF9F0ACAF5C,3CF9F0ACAF5D,ZTEGD641B298$ZTE3ANNR9F15355,D89A0DA445C5,D89A0DA445C6,ZTEGDB156346$ZTE3ANNR6R44212,48D6823990FA,48D6823990FB,ZTEGDB01D787', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-25 17:19:17 Duration: 10s991ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (281304, 508, '14126785850098500015,D86C5A3C1353,D86C5A3BF6F1,C85D3814DB7E,C85D389F9C08,C85D388BEF93,C85D380F7A1B,C85D3870CDA9,C85D38F0A7EE,C85D380CBDF8,C85D3810E17C,C85D38600090,C85D388489B8,D86C5A3D28D6,C85D38D4C005,D86C5A3DAF34,C85D3817C70B,D86C5A561663,C85D38EC2AAC', '',0151,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-25 14:03:33 Duration: 10s756ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (280903, 452, '270911029485100950,229780192229,229734103859,229672890927,229748165051,229689097782,229810671130,229665155154,229747886988,229735420318,216943782443,229673928995,229663452643,229672217190,229860319308,229784389911,229816231313,229748793351,229689216582,229810467192,216940469403,216943043347,229688723145,229784291013,229806589697,229808152545,229816916890,229850315256,229859223556,216936955356,229688416167,229865856885,229785472228,229806526785,229782009397,229785129411,229879786370,229685304663,229806292038', '246587508700,246538552138,246501746278,246570309109,246518427681,246639548201,246469085975,246548989193,246546563447,246457061626,246496143644,246499572733,246499134351,246424894861,246098339108,246628834046,246552084154,246617664056,246639363233,246474611128,246457063848,246515962537,246587379595,246604729202,246581551329,246627280214,246639695364,246641300516,246477431818,246518363658,246651833036,246596388084,246581324460,246588097578,246584716777,246652208808,246499044163,246596465264,,', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-25 10:00:04 Duration: 8s217ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 24m57s 263 153ms 3m10s 5s694ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 25 00 11 41s778ms 3s798ms 01 12 28s409ms 2s367ms 02 12 31s666ms 2s638ms 03 12 32s472ms 2s706ms 04 12 35s391ms 2s949ms 05 11 32s853ms 2s986ms 06 11 30s583ms 2s780ms 07 11 3m14s 17s657ms 08 11 1m57s 10s710ms 09 12 49s231ms 4s102ms 10 10 55s652ms 5s565ms 11 12 1m14s 6s174ms 12 13 38s168ms 2s936ms 13 11 31s29ms 2s820ms 14 12 6m10s 30s875ms 15 12 43s515ms 3s626ms 16 10 1m1s 6s101ms 17 12 37s300ms 3s108ms 18 10 34s968ms 3s496ms 19 11 34s79ms 3s98ms 20 12 56s729ms 4s727ms 21 11 32s963ms 2s996ms 22 12 33s161ms 2s763ms [ User: intelifix - Total duration: 24m57s - Times executed: 263 ]
[ Application: psql - Total duration: 24m57s - Times executed: 263 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-25 14:58:25 Duration: 3m10s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-25 07:47:56 Duration: 2m42s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-25 14:37:46 Duration: 2m35s Database: rio User: intelifix Remote: [local] Application: psql
6 21m20s 3 3m24s 10m44s 7m6s analyze verbose;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 25 05 3 21m20s 7m6s [ User: intelifix - Total duration: 21m20s - Times executed: 3 ]
[ Application: psql - Total duration: 21m20s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-25 05:10:46 Duration: 10m44s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-25 05:17:57 Duration: 7m11s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-25 05:21:21 Duration: 3m24s Database: contagem User: intelifix Remote: [local] Application: psql
7 14m39s 53 926ms 1m31s 16s599ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 25 06 2 22s840ms 11s420ms 07 4 6s839ms 1s709ms 08 3 1m37s 32s409ms 09 1 16s232ms 16s232ms 10 1 30s333ms 30s333ms 11 4 1m50s 27s718ms 12 1 3s715ms 3s715ms 13 5 1m11s 14s230ms 14 6 1m15s 12s507ms 15 5 1m20s 16s90ms 16 12 3m58s 19s853ms 17 9 2m6s 14s91ms [ User: intelifix - Total duration: 14m39s - Times executed: 53 ]
[ Application: [unknown] - Total duration: 14m39s - Times executed: 53 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-25', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-25 16:58:11 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-25', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-25 11:25:08 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-25', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-25 08:05:37 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: [unknown]
8 14m36s 150 155ms 30s429ms 5s842ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 25 00 6 33s523ms 5s587ms 01 6 14s61ms 2s343ms 02 6 10s253ms 1s708ms 03 5 12s376ms 2s475ms 04 6 17s383ms 2s897ms 05 4 20s513ms 5s128ms 07 13 1m2s 4s783ms 08 12 1m21s 6s772ms 09 12 1m32s 7s672ms 10 10 1m26s 8s698ms 11 12 1m16s 6s338ms 12 9 1m5s 7s300ms 13 5 18s59ms 3s611ms 14 12 1m32s 7s683ms 15 12 1m27s 7s281ms 16 7 50s201ms 7s171ms 20 2 387ms 193ms 21 5 31s440ms 6s288ms 22 6 24s257ms 4s42ms [ User: intelifix - Total duration: 14m36s - Times executed: 150 ]
[ Application: psql - Total duration: 14m36s - Times executed: 150 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-25 10:45:32 Duration: 30s429ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-25 00:05:23 Duration: 21s901ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-25 14:25:22 Duration: 21s1ms Database: rio User: intelifix Remote: [local] Application: psql
9 12m35s 1,059 150ms 6s670ms 713ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 25 07 26 28s28ms 1s78ms 08 137 1m42s 748ms 09 129 1m34s 735ms 10 117 1m28s 760ms 11 145 1m32s 637ms 12 18 17s865ms 992ms 13 103 52s505ms 509ms 14 114 1m6s 584ms 15 123 1m6s 542ms 16 139 2m10s 941ms 17 8 14s178ms 1s772ms [ User: intelifix - Total duration: 12m35s - Times executed: 1059 ]
[ Application: [unknown] - Total duration: 12m35s - Times executed: 1059 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "242688", "modelo" : "185", "itens" : "B85E71E1616C,08A7C06C3E84,B85E71D04648,B85E71C24FC0,ECA81F1BB66C,4075C3BA330C,80DAC2CC08C0,80DAC2CCEE70,E4BFFAEF88D4,484BD4A3550C,F8D2AC151B60", "usuario" : "414", "caixa" : "2901430", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-25 14:58:13 Duration: 6s670ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "281552", "modelo" : "320", "itens" : "241638265659,241651033651,241701728990,241630943340,241655146274,241651133436,241617855867,241621065361,241649832939,241631374650,241649581523,241651430716,241614869100,241651228899,241630746171,241645648287,241666090710,241668123759,834281941000788,835048908000622,241674130507,241649465776,241689924259,241694471830,241709403545,241694542443,241645844648,241618302230,241674849600,836043907003911,241695253657,241603342128,241609802029,241609087177,241712204761,241655258080,241658990208,230039555173,241607452428,241661096473,241667782940,241652413954,241618543847,241691699505,241733964045,835021904000707,241679874546,241694185258", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-25 16:29:16 Duration: 5s613ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "281552", "modelo" : "320", "itens" : "241646485272,241638418200,241629351120,241663305555,241630202123,241658101019,241706673245,241675704667,241658915071,241619690514,834340949002138,241731769611,241646086669,241714706475,241691293046,241634718298,241712111924,241709565154,241731760217,241663278404,241637990224,241655947171,241620774850,835209931002630,241710935557,241629307579,241666136067,241649859406,241734153738,241692942646,241699066778,241628036479,241632343847,241646713959,241703540931,241709561619,241699805773,241620037595,241601559204,241731767792,241658875875,241730394561,241630726674,241651615963,241621031116,241649913755,241694276883,241628820002", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-25 16:30:31 Duration: 4s994ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 11m41s 54 10s364ms 19s33ms 12s986ms create table temp0000289575 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 25 10 6 1m8s 11s475ms 11 14 3m2s 13s33ms 12 3 33s584ms 11s194ms 14 9 1m59s 13s324ms 15 22 4m56s 13s473ms [ User: intelifix - Total duration: 11m41s - Times executed: 54 ]
[ Application: [unknown] - Total duration: 11m41s - Times executed: 54 ]
-
CREATE TABLE temp0000289575 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 15:15:56 Duration: 19s33ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289575 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 11:35:55 Duration: 16s256ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289575 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 15:02:38 Duration: 16s81ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 11m23s 53 10s532ms 16s106ms 12s889ms create table temp0000289508 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 25 08 4 49s637ms 12s409ms 09 43 9m17s 12s953ms 10 6 1m16s 12s746ms [ User: intelifix - Total duration: 11m23s - Times executed: 53 ]
[ Application: [unknown] - Total duration: 11m23s - Times executed: 53 ]
-
CREATE TABLE temp0000289508 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 09:27:51 Duration: 16s106ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289508 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 09:22:05 Duration: 15s859ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289508 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 09:46:05 Duration: 15s531ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 9m25s 1 9m25s 9m25s 9m25s select * from rs_smart_fiscal_entrada () notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 25 09 1 9m25s 9m25s [ User: intelifix - Total duration: 9m25s - Times executed: 1 ]
[ Application: psql - Total duration: 9m25s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA () NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-08-25 09:14:26 Duration: 9m25s Database: rio User: intelifix Remote: [local] Application: psql
13 8m21s 1,212 150ms 3s255ms 413ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 25 09 64 42s209ms 659ms 10 30 27s198ms 906ms 14 266 2m9s 485ms 15 382 2m4s 324ms 16 173 1m32s 535ms 17 297 1m26s 289ms [ User: intelifix - Total duration: 8m21s - Times executed: 1212 ]
[ Application: [unknown] - Total duration: 8m21s - Times executed: 1212 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"52992","seriais":"8401122AD543,9877E74AEAFB,743AEFDB9C24,8401127FB234,8401129499BA,9877E77E7408,9877E74D745E,1834AF9AFAAE,840112601D74,1834AF9B9595,840112602681,9877E7BDC0D1,9877E7BC16BF,743AEF70C8CF,743AEFAC0F78,9877E74C88F7","usuario":"406","observacao":""}');
Date: 2026-08-25 16:27:10 Duration: 3s255ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"52992","seriais":"44D454C3DE83,E4C0E290AEAC,44ADB131FBC7,64FD965E4E2E,E4C0E2981F15,943C9678F0E5,D833B7CBF05D,44D454610A69,943C96AD338E,CC5830E3317C,38A6591AA93C,B0BBE54D601B,D0CF0EFCFCAA,E4C0E240DF51,841EA38C19EA,D833B7C920D7,582FF7973081,3453D2A7D55A","usuario":"406","observacao":""}');
Date: 2026-08-25 16:27:26 Duration: 2s227ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"53989","seriais":"38914851F133,14CA56CD7441,6C11BA6C9765,4896D952042A,389148521827,389148506635,5872C98A71F3,F4E84F82C472,D83139902D14,389148519CCD,38914851F49F,4896D94FC7F6,D8313993607A,843C991F8797,3891484BDBDF,38914851F39D,3CF9F0AC58E6,D831398C9BDC","usuario":"416","observacao":""}');
Date: 2026-08-25 09:44:48 Duration: 1s990ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
14 7m29s 32 11s122ms 54s781ms 14s46ms create table temp0000289492 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 25 07 11 2m59s 16s339ms 08 18 3m49s 12s765ms 09 3 39s963ms 13s321ms [ User: intelifix - Total duration: 7m29s - Times executed: 32 ]
[ Application: [unknown] - Total duration: 7m29s - Times executed: 32 ]
-
CREATE TABLE temp0000289492 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 07:11:12 Duration: 54s781ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289492 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 08:54:22 Duration: 15s49ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289492 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 08:10:56 Duration: 14s759ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 5m23s 54 326ms 59s728ms 5s986ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 25 07 3 47s351ms 15s783ms 08 9 49s248ms 5s472ms 09 14 34s27ms 2s430ms 10 8 1m46s 13s279ms 11 3 10s183ms 3s394ms 12 1 2s319ms 2s319ms 14 4 24s678ms 6s169ms 15 4 13s730ms 3s432ms 16 7 31s262ms 4s466ms 17 1 4s254ms 4s254ms [ User: intelifix - Total duration: 5m23s - Times executed: 54 ]
[ Application: psql - Total duration: 5m23s - Times executed: 54 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029002);
Date: 2026-08-25 10:49:10 Duration: 59s728ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028921);
Date: 2026-08-25 07:12:07 Duration: 40s36ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029003);
Date: 2026-08-25 10:56:57 Duration: 16s208ms Database: rio User: intelifix Remote: [local] Application: psql
16 4m29s 83 176ms 1m53s 3s245ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 25 07 4 7s256ms 1s814ms 08 12 30s334ms 2s527ms 09 28 19s138ms 683ms 10 12 1m58s 9s871ms 11 8 30s523ms 3s815ms 12 1 763ms 763ms 14 8 23s727ms 2s965ms 15 7 5s640ms 805ms 16 3 33s504ms 11s168ms [ User: intelifix - Total duration: 4m29s - Times executed: 83 ]
[ Application: psql - Total duration: 4m29s - Times executed: 83 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028967);
Date: 2026-08-25 10:16:35 Duration: 1m53s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029065);
Date: 2026-08-25 16:29:36 Duration: 31s982ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029022);
Date: 2026-08-25 14:36:54 Duration: 19s141ms Database: rio User: intelifix Remote: [local] Application: psql
17 4m27s 21 10s361ms 16s182ms 12s736ms create table temp0000289528 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 25 08 5 1m2s 12s562ms 09 5 1m1s 12s390ms 11 7 1m30s 12s941ms 14 4 52s117ms 13s29ms [ User: intelifix - Total duration: 4m27s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 4m27s - Times executed: 21 ]
-
CREATE TABLE temp0000289528 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 08:37:24 Duration: 16s182ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289528 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 14:46:36 Duration: 14s281ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289528 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 11:02:44 Duration: 13s886ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 3m47s 17 10s493ms 22s36ms 13s377ms create table temp0000289597 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 25 14 13 2m41s 12s384ms 16 4 1m6s 16s602ms [ User: intelifix - Total duration: 3m47s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 3m47s - Times executed: 17 ]
-
CREATE TABLE temp0000289597 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 16:04:35 Duration: 22s36ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289597 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 16:07:57 Duration: 15s479ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289597 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 14:19:39 Duration: 15s428ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 3m45s 4 5s95ms 1m47s 56s301ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 25 20 2 1m53s 56s628ms 23 2 1m51s 55s974ms [ User: intelifix - Total duration: 3m45s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m45s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-25 20:09:39 Duration: 1m47s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-25 23:17:43 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-25 20:11:54 Duration: 5s572ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 3m5s 50 668ms 5s801ms 3s716ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 25 08 3 11s17ms 3s672ms 09 3 10s611ms 3s537ms 10 2 7s506ms 3s753ms 11 3 10s699ms 3s566ms 12 5 17s242ms 3s448ms 13 4 14s323ms 3s580ms 14 4 14s827ms 3s706ms 15 3 10s793ms 3s597ms 16 3 11s884ms 3s961ms 17 3 10s584ms 3s528ms 18 4 16s101ms 4s25ms 19 4 15s261ms 3s815ms 20 3 11s730ms 3s910ms 21 3 11s586ms 3s862ms 22 3 11s640ms 3s880ms [ User: intelifix - Total duration: 3m5s - Times executed: 50 ]
[ Application: psql - Total duration: 3m5s - Times executed: 50 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-25 12:20:11 Duration: 5s801ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-25 18:00:11 Duration: 5s132ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-25 16:40:06 Duration: 4s883ms Database: rio User: intelifix Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,313 29m11s 150ms 10s991ms 1s333ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 25 08 183 3m8s 1s27ms 09 222 4m10s 1s128ms 10 119 2m6s 1s60ms 11 204 2m46s 817ms 12 26 56s125ms 2s158ms 13 54 1m30s 1s684ms 14 130 4m10s 1s928ms 15 173 5m 1s738ms 16 135 3m33s 1s579ms 17 67 1m48s 1s612ms [ User: intelifix - Total duration: 29m11s - Times executed: 1313 ]
[ Application: [unknown] - Total duration: 29m11s - Times executed: 1313 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (281316, 452, 'ZTE3ANNQ8101903,689E29BC0B65,689E29BC0B66,ZTEGD7B741FF$ZTE3ANNR5W35807,48D68231CB04,48D68231CB05,ZTEGDB008BDE$ZTE3ANNT2V31063,D831398E66E2,D831398E66E3,ZTEGDD306BD6$ZTE3ANNR8C43524,38914852831F,389148528320,ZTEGDB092A74$ZTE3ANNT2V37558,D831398EFF1C,D831398EFF1D,ZTEGDD308535$ZTE3ANNQ8F09517,689E29FD01EB,689E29FD01EC,ZTEGD7BA21FD$ZTE3ANNQ5N08209,3CF9F0AD85DC,3CF9F0AD85DD,ZTEGD641D658$ZTE3ANNR9F54217,D89A0DA7D499,D89A0DA7D49A,ZTEGDB15FB14$ZTE3ANNR8C46088,38914852BF37,38914852BF38,ZTEGDB093478$ZTE3ANNRCB01798,D831391DF922,D831391DF923,ZTEGDD29BC9B$ZTE3ANNQ8F11537,689E29FD3143,689E29FD3144,ZTEGD7BA29E1$ZTE3ANNQ8F09980,689E29FD0CC5,689E29FD0CC6,ZTEGD7BA23CC$ZTE3ANNR9F51259,D89A0DA78F45,D89A0DA78F46,ZTEGDB15EF86$ZTE3ANNR9W55155,D89A0DAD68D5,D89A0DAD68D6,ZTEGDB16E91E$ZTE3ANNRAM49107,5872C98BB72B,5872C98BB72C,ZTEGDC60BFD2$ZTE3ANNRCB18715,D831391F85A0,D831391F85A1,ZTEGDD29FEB0$ZTE3ANNR2Q21372,F4E84F82A8E8,F4E84F82A8E9,ZTEGD97AC636$ZTE3ANNQ9J01605,843C992BF6D3,843C992BF6D4,ZTEGD7BB0EF0$ZTE3ANNT2V16301,D831398D0CE6,D831398D0CE7,ZTEGDD30322C$ZTE3ANNQ4412980,3CF9F0AC8F16,3CF9F0AC8F17,ZTEGD641AD37$ZTE3ANNQ3610335,3CF9F0A5C7A8,3CF9F0A5C7A9,ZTEGD6408BFA$ZTE3ANNQ4414357,3CF9F0ACAF5C,3CF9F0ACAF5D,ZTEGD641B298$ZTE3ANNR9F15355,D89A0DA445C5,D89A0DA445C6,ZTEGDB156346$ZTE3ANNR6R44212,48D6823990FA,48D6823990FB,ZTEGDB01D787', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-25 17:19:17 Duration: 10s991ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (281304, 508, '14126785850098500015,D86C5A3C1353,D86C5A3BF6F1,C85D3814DB7E,C85D389F9C08,C85D388BEF93,C85D380F7A1B,C85D3870CDA9,C85D38F0A7EE,C85D380CBDF8,C85D3810E17C,C85D38600090,C85D388489B8,D86C5A3D28D6,C85D38D4C005,D86C5A3DAF34,C85D3817C70B,D86C5A561663,C85D38EC2AAC', '',0151,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-25 14:03:33 Duration: 10s756ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (280903, 452, '270911029485100950,229780192229,229734103859,229672890927,229748165051,229689097782,229810671130,229665155154,229747886988,229735420318,216943782443,229673928995,229663452643,229672217190,229860319308,229784389911,229816231313,229748793351,229689216582,229810467192,216940469403,216943043347,229688723145,229784291013,229806589697,229808152545,229816916890,229850315256,229859223556,216936955356,229688416167,229865856885,229785472228,229806526785,229782009397,229785129411,229879786370,229685304663,229806292038', '246587508700,246538552138,246501746278,246570309109,246518427681,246639548201,246469085975,246548989193,246546563447,246457061626,246496143644,246499572733,246499134351,246424894861,246098339108,246628834046,246552084154,246617664056,246639363233,246474611128,246457063848,246515962537,246587379595,246604729202,246581551329,246627280214,246639695364,246641300516,246477431818,246518363658,246651833036,246596388084,246581324460,246588097578,246584716777,246652208808,246499044163,246596465264,,', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-25 10:00:04 Duration: 8s217ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1,212 8m21s 150ms 3s255ms 413ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 25 09 64 42s209ms 659ms 10 30 27s198ms 906ms 14 266 2m9s 485ms 15 382 2m4s 324ms 16 173 1m32s 535ms 17 297 1m26s 289ms [ User: intelifix - Total duration: 8m21s - Times executed: 1212 ]
[ Application: [unknown] - Total duration: 8m21s - Times executed: 1212 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"52992","seriais":"8401122AD543,9877E74AEAFB,743AEFDB9C24,8401127FB234,8401129499BA,9877E77E7408,9877E74D745E,1834AF9AFAAE,840112601D74,1834AF9B9595,840112602681,9877E7BDC0D1,9877E7BC16BF,743AEF70C8CF,743AEFAC0F78,9877E74C88F7","usuario":"406","observacao":""}');
Date: 2026-08-25 16:27:10 Duration: 3s255ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"52992","seriais":"44D454C3DE83,E4C0E290AEAC,44ADB131FBC7,64FD965E4E2E,E4C0E2981F15,943C9678F0E5,D833B7CBF05D,44D454610A69,943C96AD338E,CC5830E3317C,38A6591AA93C,B0BBE54D601B,D0CF0EFCFCAA,E4C0E240DF51,841EA38C19EA,D833B7C920D7,582FF7973081,3453D2A7D55A","usuario":"406","observacao":""}');
Date: 2026-08-25 16:27:26 Duration: 2s227ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"53989","seriais":"38914851F133,14CA56CD7441,6C11BA6C9765,4896D952042A,389148521827,389148506635,5872C98A71F3,F4E84F82C472,D83139902D14,389148519CCD,38914851F49F,4896D94FC7F6,D8313993607A,843C991F8797,3891484BDBDF,38914851F39D,3CF9F0AC58E6,D831398C9BDC","usuario":"416","observacao":""}');
Date: 2026-08-25 09:44:48 Duration: 1s990ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
3 1,059 12m35s 150ms 6s670ms 713ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 25 07 26 28s28ms 1s78ms 08 137 1m42s 748ms 09 129 1m34s 735ms 10 117 1m28s 760ms 11 145 1m32s 637ms 12 18 17s865ms 992ms 13 103 52s505ms 509ms 14 114 1m6s 584ms 15 123 1m6s 542ms 16 139 2m10s 941ms 17 8 14s178ms 1s772ms [ User: intelifix - Total duration: 12m35s - Times executed: 1059 ]
[ Application: [unknown] - Total duration: 12m35s - Times executed: 1059 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "242688", "modelo" : "185", "itens" : "B85E71E1616C,08A7C06C3E84,B85E71D04648,B85E71C24FC0,ECA81F1BB66C,4075C3BA330C,80DAC2CC08C0,80DAC2CCEE70,E4BFFAEF88D4,484BD4A3550C,F8D2AC151B60", "usuario" : "414", "caixa" : "2901430", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-25 14:58:13 Duration: 6s670ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "281552", "modelo" : "320", "itens" : "241638265659,241651033651,241701728990,241630943340,241655146274,241651133436,241617855867,241621065361,241649832939,241631374650,241649581523,241651430716,241614869100,241651228899,241630746171,241645648287,241666090710,241668123759,834281941000788,835048908000622,241674130507,241649465776,241689924259,241694471830,241709403545,241694542443,241645844648,241618302230,241674849600,836043907003911,241695253657,241603342128,241609802029,241609087177,241712204761,241655258080,241658990208,230039555173,241607452428,241661096473,241667782940,241652413954,241618543847,241691699505,241733964045,835021904000707,241679874546,241694185258", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-25 16:29:16 Duration: 5s613ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "281552", "modelo" : "320", "itens" : "241646485272,241638418200,241629351120,241663305555,241630202123,241658101019,241706673245,241675704667,241658915071,241619690514,834340949002138,241731769611,241646086669,241714706475,241691293046,241634718298,241712111924,241709565154,241731760217,241663278404,241637990224,241655947171,241620774850,835209931002630,241710935557,241629307579,241666136067,241649859406,241734153738,241692942646,241699066778,241628036479,241632343847,241646713959,241703540931,241709561619,241699805773,241620037595,241601559204,241731767792,241658875875,241730394561,241630726674,241651615963,241621031116,241649913755,241694276883,241628820002", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-25 16:30:31 Duration: 4s994ms Database: rio User: intelifix Remote: [local] Application: [unknown]
4 263 2h25m54s 160ms 9m34s 33s288ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 25 07 6 15m20s 2m33s 08 45 23m28s 31s303ms 09 61 15m48s 15s548ms 10 11 11m22s 1m2s 11 20 25m8s 1m15s 12 5 7m26s 1m29s 13 26 44s484ms 1s710ms 14 18 20m4s 1m6s 15 22 13m23s 36s529ms 16 21 11m21s 32s450ms 17 28 1m45s 3s752ms [ User: intelifix - Total duration: 2h25m54s - Times executed: 263 ]
[ Application: [unknown] - Total duration: 2h25m54s - Times executed: 263 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-08-03''),DATE(''2026-08-24'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-08-25 16:07:02 Duration: 9m34s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029002, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-25 10:58:16 Duration: 9m32s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028921, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-25 07:21:04 Duration: 8m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 263 24m57s 153ms 3m10s 5s694ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 25 00 11 41s778ms 3s798ms 01 12 28s409ms 2s367ms 02 12 31s666ms 2s638ms 03 12 32s472ms 2s706ms 04 12 35s391ms 2s949ms 05 11 32s853ms 2s986ms 06 11 30s583ms 2s780ms 07 11 3m14s 17s657ms 08 11 1m57s 10s710ms 09 12 49s231ms 4s102ms 10 10 55s652ms 5s565ms 11 12 1m14s 6s174ms 12 13 38s168ms 2s936ms 13 11 31s29ms 2s820ms 14 12 6m10s 30s875ms 15 12 43s515ms 3s626ms 16 10 1m1s 6s101ms 17 12 37s300ms 3s108ms 18 10 34s968ms 3s496ms 19 11 34s79ms 3s98ms 20 12 56s729ms 4s727ms 21 11 32s963ms 2s996ms 22 12 33s161ms 2s763ms [ User: intelifix - Total duration: 24m57s - Times executed: 263 ]
[ Application: psql - Total duration: 24m57s - Times executed: 263 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-25 14:58:25 Duration: 3m10s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-25 07:47:56 Duration: 2m42s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-25 14:37:46 Duration: 2m35s Database: rio User: intelifix Remote: [local] Application: psql
6 187 55s920ms 150ms 1s139ms 299ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 25 01 22 6s386ms 290ms 03 14 3s427ms 244ms 04 14 3s470ms 247ms 05 1 192ms 192ms 07 15 5s510ms 367ms 08 12 3s630ms 302ms 09 10 2s800ms 280ms 10 25 9s229ms 369ms 11 16 4s603ms 287ms 12 9 2s470ms 274ms 13 2 390ms 195ms 14 12 4s280ms 356ms 15 18 5s431ms 301ms 16 16 3s843ms 240ms 17 1 251ms 251ms [ User: intelifix - Total duration: 55s920ms - Times executed: 187 ]
[ Application: [unknown] - Total duration: 55s920ms - Times executed: 187 ]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '229975765367,230010396872,229967959813,230009806276', NULL, NULL, 0295, 00);
Date: 2026-08-25 14:24:58 Duration: 1s139ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (430, 5, '138', 6, '9877E707556A,743AEFDC9DD4,9877E74AF2C6,743AEF958712,8401128290F5,8401127FAFD3,1834AF614BB9,743AEFC55CE2,840112DCBEA7,9877E74DC818,840112C03043,9877E74E07A4,743AEF9521B5,1834AF616C35,8401123778DD,743AEF340CFE,8401122A6A9F,743AEF5C7ED9,743AEF33DE7B,840112824BAB,743AEFDA5417,743AEF5CD915,743AEF5C6D21,8401125F9548,84011206FBD0,840112953E02,9877E74DF8BD,9877E708D48E,743AEF73E333,743AEF95215A,9877E700E879,840112DCD8BD', NULL, NULL, 0153, 00);
Date: 2026-08-25 07:28:14 Duration: 1s14ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (404, 5, '113', 3, '229804436682,229803156972,229867542628,229863930110,229844889407,229867023150,229796370015,229818135864,229858949006,229772516586', NULL, NULL, 0145, 00);
Date: 2026-08-25 09:59:30 Duration: 789ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 150 14m36s 155ms 30s429ms 5s842ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 25 00 6 33s523ms 5s587ms 01 6 14s61ms 2s343ms 02 6 10s253ms 1s708ms 03 5 12s376ms 2s475ms 04 6 17s383ms 2s897ms 05 4 20s513ms 5s128ms 07 13 1m2s 4s783ms 08 12 1m21s 6s772ms 09 12 1m32s 7s672ms 10 10 1m26s 8s698ms 11 12 1m16s 6s338ms 12 9 1m5s 7s300ms 13 5 18s59ms 3s611ms 14 12 1m32s 7s683ms 15 12 1m27s 7s281ms 16 7 50s201ms 7s171ms 20 2 387ms 193ms 21 5 31s440ms 6s288ms 22 6 24s257ms 4s42ms [ User: intelifix - Total duration: 14m36s - Times executed: 150 ]
[ Application: psql - Total duration: 14m36s - Times executed: 150 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-25 10:45:32 Duration: 30s429ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-25 00:05:23 Duration: 21s901ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-25 14:25:22 Duration: 21s1ms Database: rio User: intelifix Remote: [local] Application: psql
8 130 32s927ms 150ms 819ms 253ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 25 08 11 3s145ms 285ms 09 16 5s168ms 323ms 10 11 4s372ms 397ms 11 17 3s595ms 211ms 12 2 437ms 218ms 13 10 2s80ms 208ms 14 15 3s125ms 208ms 15 18 3s870ms 215ms 16 13 3s692ms 284ms 17 17 3s440ms 202ms [ User: intelifix - Total duration: 32s927ms - Times executed: 130 ]
[ Application: [unknown] - Total duration: 32s927ms - Times executed: 130 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"155", "usuario" :"413", "tipo" :"N", "itens" :"011", "nota-fiscal" :"11084", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-25 10:47:24 Duration: 819ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"298", "usuario" :"507", "tipo" :"N", "itens" :"008", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-25 08:04:48 Duration: 717ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"145", "usuario" :"413", "tipo" :"N", "itens" :"010", "nota-fiscal" :"11084", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-25 16:27:54 Duration: 710ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
9 127 1m53s 165ms 4s753ms 896ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 25 08 23 17s46ms 741ms 09 35 32s468ms 927ms 11 1 2s161ms 2s161ms 13 17 17s81ms 1s4ms 14 5 2s478ms 495ms 15 4 3s315ms 828ms 16 12 15s124ms 1s260ms 17 30 24s172ms 805ms [ User: intelifix - Total duration: 1m53s - Times executed: 127 ]
[ Application: [unknown] - Total duration: 1m53s - Times executed: 127 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0134424) LIMIT 1;
Date: 2026-08-25 17:04:03 Duration: 4s753ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0281213) LIMIT 1;
Date: 2026-08-25 13:38:01 Duration: 3s611ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0280739) LIMIT 1;
Date: 2026-08-25 08:37:55 Duration: 3s595ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 127 1m1s 264ms 911ms 486ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 25 01 3 1s383ms 461ms 03 1 378ms 378ms 04 2 1s40ms 520ms 05 1 440ms 440ms 06 2 855ms 427ms 07 6 2s678ms 446ms 08 13 6s738ms 518ms 09 10 4s923ms 492ms 10 18 7s957ms 442ms 11 7 3s477ms 496ms 12 8 3s200ms 400ms 13 8 3s902ms 487ms 14 14 6s516ms 465ms 15 7 3s133ms 447ms 16 19 11s463ms 603ms 17 6 2s694ms 449ms 20 2 1s27ms 513ms [ User: lenon - Total duration: 1m1s - Times executed: 127 ]
[ Application: [unknown] - Total duration: 1m1s - Times executed: 127 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-25 16:20:50 Duration: 911ms 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-08-25 16:20:50 Duration: 844ms 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-08-25 16:20:50 Duration: 831ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
11 120 1m17s 329ms 1s571ms 648ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 25 01 3 1s874ms 624ms 03 1 528ms 528ms 04 2 1s254ms 627ms 05 1 614ms 614ms 07 5 2s882ms 576ms 08 12 7s978ms 664ms 09 10 6s201ms 620ms 10 18 11s993ms 666ms 11 7 4s368ms 624ms 12 7 3s584ms 512ms 13 8 5s68ms 633ms 14 14 7s948ms 567ms 15 7 4s2ms 571ms 16 18 15s676ms 870ms 17 6 3s361ms 560ms 20 1 491ms 491ms [ User: intelifix - Total duration: 1m17s - Times executed: 120 ]
[ Application: [unknown] - Total duration: 1m17s - Times executed: 120 ]
-
select * from rs_menu_grants (509, 21, 1);
Date: 2026-08-25 16:20:50 Duration: 1s571ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (406, 18, 1);
Date: 2026-08-25 16:20:59 Duration: 1s362ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (417, 21, 1);
Date: 2026-08-25 16:20:50 Duration: 1s358ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 97 22s875ms 150ms 1s7ms 235ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 25 00 1 363ms 363ms 03 2 354ms 177ms 04 2 368ms 184ms 07 3 614ms 204ms 08 10 1s956ms 195ms 09 16 3s961ms 247ms 10 14 2s795ms 199ms 11 9 2s839ms 315ms 12 1 159ms 159ms 13 1 213ms 213ms 14 8 1s751ms 218ms 15 3 653ms 217ms 16 20 4s485ms 224ms 17 5 1s122ms 224ms 20 2 1s235ms 617ms [ User: intelifix - Total duration: 22s875ms - Times executed: 97 ]
[ Application: [unknown] - Total duration: 22s875ms - Times executed: 97 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('241592239292');
Date: 2026-08-25 20:58:15 Duration: 1s7ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('184062165258');
Date: 2026-08-25 11:04:05 Duration: 968ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('6CFFCE690C8C');
Date: 2026-08-25 09:10:00 Duration: 930ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
13 95 32s594ms 151ms 3s162ms 343ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 25 08 22 6s489ms 294ms 09 3 512ms 170ms 10 4 2s9ms 502ms 13 1 216ms 216ms 14 18 5s751ms 319ms 15 30 9s131ms 304ms 16 11 7s518ms 683ms 17 6 964ms 160ms [ User: intelifix - Total duration: 32s594ms - Times executed: 95 ]
[ Application: [unknown] - Total duration: 32s594ms - Times executed: 95 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (53989);
Date: 2026-08-25 16:07:21 Duration: 3s162ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (0108374);
Date: 2026-08-25 16:20:55 Duration: 2s849ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (0281110);
Date: 2026-08-25 10:33:43 Duration: 919ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 85 55s5ms 156ms 2s883ms 647ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 25 07 5 2s637ms 527ms 08 12 7s511ms 625ms 09 14 9s136ms 652ms 10 12 12s310ms 1s25ms 11 15 9s515ms 634ms 14 3 923ms 307ms 15 4 1s57ms 264ms 16 7 2s4ms 286ms 17 13 9s909ms 762ms [ User: intelifix - Total duration: 55s5ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 55s5ms - Times executed: 85 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '9C635B90496C,9C635B8F500C,F4E84FACDC18,9C635B8E1260,F4E84FABC230,9C635B8E9270,9C635B90B164,9C635B8F642E,9C635B8DEB90,9C635B8EC390', '138;1', 'DEFAULT', 09, 0318, '','', '', 00);
Date: 2026-08-25 10:35:12 Duration: 2s883ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, 'D4925E06581F,D4925E04BFB6,D4925E0534D1,D4925EBD9B0F,D4925EF6A146,08C7F5228894,D4925E07D3CF,D4925ED4B3D0', '76;1', 'DEFAULT', 09, 0298, '','', '', 00);
Date: 2026-08-25 17:15:19 Duration: 1s887ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, 'D4925EA5A4C4,D4925E068825,08C7F52EA379,D4925ECC44F7,D4925EBDEE61', '76;1', 'DEFAULT', 09, 0298, '','', '', 00);
Date: 2026-08-25 17:05:26 Duration: 1s753ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 85 50s360ms 153ms 1s266ms 592ms create table temp0000226915 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 25 08 1 375ms 375ms 09 1 391ms 391ms 10 1 153ms 153ms 11 7 4s302ms 614ms 13 17 10s298ms 605ms 14 32 18s968ms 592ms 15 26 15s870ms 610ms [ User: intelifix - Total duration: 50s360ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 50s360ms - Times executed: 85 ]
-
CREATE TABLE temp0000226915 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"20-08-2026", "ate" :"25-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-25 14:51:16 Duration: 1s266ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226915 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"20-08-2026", "ate" :"25-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-25 15:31:14 Duration: 947ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226915 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"20-08-2026", "ate" :"25-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-25 13:53:05 Duration: 908ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
16 83 4m29s 176ms 1m53s 3s245ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 25 07 4 7s256ms 1s814ms 08 12 30s334ms 2s527ms 09 28 19s138ms 683ms 10 12 1m58s 9s871ms 11 8 30s523ms 3s815ms 12 1 763ms 763ms 14 8 23s727ms 2s965ms 15 7 5s640ms 805ms 16 3 33s504ms 11s168ms [ User: intelifix - Total duration: 4m29s - Times executed: 83 ]
[ Application: psql - Total duration: 4m29s - Times executed: 83 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028967);
Date: 2026-08-25 10:16:35 Duration: 1m53s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029065);
Date: 2026-08-25 16:29:36 Duration: 31s982ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029022);
Date: 2026-08-25 14:36:54 Duration: 19s141ms Database: rio User: intelifix Remote: [local] Application: psql
17 83 1m1s 150ms 16s797ms 736ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 25 01 1 320ms 320ms 05 1 160ms 160ms 07 8 10s590ms 1s323ms 08 4 1s800ms 450ms 09 8 21s728ms 2s716ms 10 8 5s550ms 693ms 11 7 2s209ms 315ms 12 6 1s363ms 227ms 14 5 1s878ms 375ms 15 11 3s356ms 305ms 16 20 11s517ms 575ms 17 4 670ms 167ms [ User: intelifix - Total duration: 1m1s - Times executed: 83 ]
[ Application: [unknown] - Total duration: 1m1s - Times executed: 83 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "353", "data-de" : "2026-01-01", "data-ate" : "2026-08-25", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 398 }');
Date: 2026-08-25 09:08:37 Duration: 16s797ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "362", "data-de" : "2026-08-25", "data-ate" : "2026-08-25", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 414 }');
Date: 2026-08-25 16:20:54 Duration: 3s530ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "362", "data-de" : "2026-08-24", "data-ate" : "2026-08-24", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 414 }');
Date: 2026-08-25 07:06:04 Duration: 2s712ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 78 26s62ms 150ms 4s576ms 334ms create table temp0000238846 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 25 09 2 1s819ms 909ms 10 6 3s809ms 634ms 11 9 1s413ms 157ms 12 8 1s504ms 188ms 13 2 613ms 306ms 14 8 2s802ms 350ms 15 7 1s443ms 206ms 16 26 10s395ms 399ms 17 10 2s260ms 226ms [ User: intelifix - Total duration: 26s62ms - Times executed: 78 ]
[ Application: [unknown] - Total duration: 26s62ms - Times executed: 78 ]
-
CREATE TABLE temp0000238846 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "25-08-2026", "data-ate" : "25-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-25 16:23:29 Duration: 4s576ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000238846 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "25-08-2026", "data-ate" : "25-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-25 10:33:45 Duration: 2s901ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000238846 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "20-08-2026", "data-ate" : "25-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-25 09:36:13 Duration: 1s580ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
19 77 35s202ms 156ms 1s833ms 457ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 25 07 3 1s473ms 491ms 08 12 5s931ms 494ms 09 17 7s875ms 463ms 10 10 4s16ms 401ms 11 5 2s232ms 446ms 12 1 337ms 337ms 13 2 962ms 481ms 14 5 2s114ms 422ms 15 8 3s507ms 438ms 16 9 5s144ms 571ms 17 5 1s608ms 321ms [ User: intelifix - Total duration: 35s202ms - Times executed: 77 ]
[ Application: [unknown] - Total duration: 35s202ms - Times executed: 77 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-08-25 16:26:04 Duration: 1s833ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-25 08:09:25 Duration: 1s430ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-25 09:17:26 Duration: 1s114ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
20 74 11s963ms 150ms 215ms 161ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 25 03 1 162ms 162ms 07 4 687ms 171ms 08 9 1s421ms 157ms 09 10 1s628ms 162ms 10 4 643ms 160ms 11 10 1s590ms 159ms 12 1 175ms 175ms 13 2 309ms 154ms 14 3 479ms 159ms 15 12 1s960ms 163ms 16 13 2s82ms 160ms 17 5 822ms 164ms [ User: intelifix - Total duration: 11s963ms - Times executed: 74 ]
[ Application: [unknown] - Total duration: 11s963ms - Times executed: 74 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0464;
Date: 2026-08-25 07:40:17 Duration: 215ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-08-25 16:20:51 Duration: 188ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0318;
Date: 2026-08-25 09:07:01 Duration: 184ms 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 9m25s 9m25s 9m25s 1 9m25s select * from rs_smart_fiscal_entrada () notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 25 09 1 9m25s 9m25s [ User: intelifix - Total duration: 9m25s - Times executed: 1 ]
[ Application: psql - Total duration: 9m25s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA () NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-08-25 09:14:26 Duration: 9m25s Database: rio User: intelifix Remote: [local] Application: psql
2 3m24s 10m44s 7m6s 3 21m20s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 25 05 3 21m20s 7m6s [ User: intelifix - Total duration: 21m20s - Times executed: 3 ]
[ Application: psql - Total duration: 21m20s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-25 05:10:46 Duration: 10m44s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-25 05:17:57 Duration: 7m11s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-25 05:21:21 Duration: 3m24s Database: contagem User: intelifix Remote: [local] Application: psql
3 1s561ms 13m27s 2m51s 43 2h2m38s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 25 07 3 12m34s 4m11s 08 3 7m48s 2m36s 09 2 32s279ms 16s139ms 10 2 8m40s 4m20s 11 3 12m56s 4m18s 12 3 7m10s 2m23s 13 3 6m51s 2m17s 14 3 7m47s 2m35s 15 3 7m40s 2m33s 17 3 14m36s 4m52s 18 3 6m17s 2m5s 19 3 6m11s 2m3s 20 3 10m38s 3m32s 21 3 6m38s 2m12s 22 3 6m14s 2m4s [ User: intelifix - Total duration: 2h2m38s - Times executed: 43 ]
[ Application: psql - Total duration: 2h2m38s - Times executed: 43 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-25 17:18:28 Duration: 13m27s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-25 11:16:50 Duration: 11m49s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-25 07:16:26 Duration: 11m25s Database: rio User: intelifix Remote: [local] Application: psql
4 242ms 6m1s 1m45s 44 1h17m26s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 25 07 3 7m10s 2m23s 08 3 5m8s 1m42s 09 3 4m45s 1m35s 10 2 4m40s 2m20s 11 3 8m1s 2m40s 12 3 4m9s 1m23s 13 3 4m11s 1m23s 14 3 4m19s 1m26s 15 3 5m6s 1m42s 17 3 7m32s 2m30s 18 3 4m6s 1m22s 19 3 3m56s 1m18s 20 3 6m23s 2m7s 21 3 3m55s 1m18s 22 3 3m59s 1m19s [ User: intelifix - Total duration: 1h17m26s - Times executed: 44 ]
[ Application: psql - Total duration: 1h17m26s - Times executed: 44 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-25 11:25:44 Duration: 6m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-25 07:24:27 Duration: 5m15s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-25 17:26:49 Duration: 5m14s Database: brasilia User: intelifix Remote: [local] Application: psql
5 5s95ms 1m47s 56s301ms 4 3m45s 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 Aug 25 20 2 1m53s 56s628ms 23 2 1m51s 55s974ms [ User: intelifix - Total duration: 3m45s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m45s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-25 20:09:39 Duration: 1m47s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-25 23:17:43 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-25 20:11:54 Duration: 5s572ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 160ms 9m34s 33s288ms 263 2h25m54s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 25 07 6 15m20s 2m33s 08 45 23m28s 31s303ms 09 61 15m48s 15s548ms 10 11 11m22s 1m2s 11 20 25m8s 1m15s 12 5 7m26s 1m29s 13 26 44s484ms 1s710ms 14 18 20m4s 1m6s 15 22 13m23s 36s529ms 16 21 11m21s 32s450ms 17 28 1m45s 3s752ms [ User: intelifix - Total duration: 2h25m54s - Times executed: 263 ]
[ Application: [unknown] - Total duration: 2h25m54s - Times executed: 263 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-08-03''),DATE(''2026-08-24'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-08-25 16:07:02 Duration: 9m34s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029002, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-25 10:58:16 Duration: 9m32s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028921, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-25 07:21:04 Duration: 8m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 926ms 1m31s 16s599ms 53 14m39s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 25 06 2 22s840ms 11s420ms 07 4 6s839ms 1s709ms 08 3 1m37s 32s409ms 09 1 16s232ms 16s232ms 10 1 30s333ms 30s333ms 11 4 1m50s 27s718ms 12 1 3s715ms 3s715ms 13 5 1m11s 14s230ms 14 6 1m15s 12s507ms 15 5 1m20s 16s90ms 16 12 3m58s 19s853ms 17 9 2m6s 14s91ms [ User: intelifix - Total duration: 14m39s - Times executed: 53 ]
[ Application: [unknown] - Total duration: 14m39s - Times executed: 53 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-25', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-25 16:58:11 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-25', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-25 11:25:08 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-25', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-25 08:05:37 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: [unknown]
8 11s122ms 54s781ms 14s46ms 32 7m29s create table temp0000289492 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 25 07 11 2m59s 16s339ms 08 18 3m49s 12s765ms 09 3 39s963ms 13s321ms [ User: intelifix - Total duration: 7m29s - Times executed: 32 ]
[ Application: [unknown] - Total duration: 7m29s - Times executed: 32 ]
-
CREATE TABLE temp0000289492 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 07:11:12 Duration: 54s781ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289492 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 08:54:22 Duration: 15s49ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289492 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 08:10:56 Duration: 14s759ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s493ms 22s36ms 13s377ms 17 3m47s create table temp0000289597 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 25 14 13 2m41s 12s384ms 16 4 1m6s 16s602ms [ User: intelifix - Total duration: 3m47s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 3m47s - Times executed: 17 ]
-
CREATE TABLE temp0000289597 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 16:04:35 Duration: 22s36ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289597 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 16:07:57 Duration: 15s479ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289597 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 14:19:39 Duration: 15s428ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s364ms 19s33ms 12s986ms 54 11m41s create table temp0000289575 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 25 10 6 1m8s 11s475ms 11 14 3m2s 13s33ms 12 3 33s584ms 11s194ms 14 9 1m59s 13s324ms 15 22 4m56s 13s473ms [ User: intelifix - Total duration: 11m41s - Times executed: 54 ]
[ Application: [unknown] - Total duration: 11m41s - Times executed: 54 ]
-
CREATE TABLE temp0000289575 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 15:15:56 Duration: 19s33ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289575 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 11:35:55 Duration: 16s256ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289575 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 15:02:38 Duration: 16s81ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s532ms 16s106ms 12s889ms 53 11m23s create table temp0000289508 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 25 08 4 49s637ms 12s409ms 09 43 9m17s 12s953ms 10 6 1m16s 12s746ms [ User: intelifix - Total duration: 11m23s - Times executed: 53 ]
[ Application: [unknown] - Total duration: 11m23s - Times executed: 53 ]
-
CREATE TABLE temp0000289508 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 09:27:51 Duration: 16s106ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289508 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 09:22:05 Duration: 15s859ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289508 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 09:46:05 Duration: 15s531ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 10s361ms 16s182ms 12s736ms 21 4m27s create table temp0000289528 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 25 08 5 1m2s 12s562ms 09 5 1m1s 12s390ms 11 7 1m30s 12s941ms 14 4 52s117ms 13s29ms [ User: intelifix - Total duration: 4m27s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 4m27s - Times executed: 21 ]
-
CREATE TABLE temp0000289528 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 08:37:24 Duration: 16s182ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289528 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 14:46:36 Duration: 14s281ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000289528 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-25 11:02:44 Duration: 13s886ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 326ms 59s728ms 5s986ms 54 5m23s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 25 07 3 47s351ms 15s783ms 08 9 49s248ms 5s472ms 09 14 34s27ms 2s430ms 10 8 1m46s 13s279ms 11 3 10s183ms 3s394ms 12 1 2s319ms 2s319ms 14 4 24s678ms 6s169ms 15 4 13s730ms 3s432ms 16 7 31s262ms 4s466ms 17 1 4s254ms 4s254ms [ User: intelifix - Total duration: 5m23s - Times executed: 54 ]
[ Application: psql - Total duration: 5m23s - Times executed: 54 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029002);
Date: 2026-08-25 10:49:10 Duration: 59s728ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028921);
Date: 2026-08-25 07:12:07 Duration: 40s36ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029003);
Date: 2026-08-25 10:56:57 Duration: 16s208ms Database: rio User: intelifix Remote: [local] Application: psql
14 155ms 30s429ms 5s842ms 150 14m36s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 25 00 6 33s523ms 5s587ms 01 6 14s61ms 2s343ms 02 6 10s253ms 1s708ms 03 5 12s376ms 2s475ms 04 6 17s383ms 2s897ms 05 4 20s513ms 5s128ms 07 13 1m2s 4s783ms 08 12 1m21s 6s772ms 09 12 1m32s 7s672ms 10 10 1m26s 8s698ms 11 12 1m16s 6s338ms 12 9 1m5s 7s300ms 13 5 18s59ms 3s611ms 14 12 1m32s 7s683ms 15 12 1m27s 7s281ms 16 7 50s201ms 7s171ms 20 2 387ms 193ms 21 5 31s440ms 6s288ms 22 6 24s257ms 4s42ms [ User: intelifix - Total duration: 14m36s - Times executed: 150 ]
[ Application: psql - Total duration: 14m36s - Times executed: 150 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-25 10:45:32 Duration: 30s429ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-25 00:05:23 Duration: 21s901ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-25 14:25:22 Duration: 21s1ms Database: rio User: intelifix Remote: [local] Application: psql
15 153ms 3m10s 5s694ms 263 24m57s call rs_giga_triagem (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 25 00 11 41s778ms 3s798ms 01 12 28s409ms 2s367ms 02 12 31s666ms 2s638ms 03 12 32s472ms 2s706ms 04 12 35s391ms 2s949ms 05 11 32s853ms 2s986ms 06 11 30s583ms 2s780ms 07 11 3m14s 17s657ms 08 11 1m57s 10s710ms 09 12 49s231ms 4s102ms 10 10 55s652ms 5s565ms 11 12 1m14s 6s174ms 12 13 38s168ms 2s936ms 13 11 31s29ms 2s820ms 14 12 6m10s 30s875ms 15 12 43s515ms 3s626ms 16 10 1m1s 6s101ms 17 12 37s300ms 3s108ms 18 10 34s968ms 3s496ms 19 11 34s79ms 3s98ms 20 12 56s729ms 4s727ms 21 11 32s963ms 2s996ms 22 12 33s161ms 2s763ms [ User: intelifix - Total duration: 24m57s - Times executed: 263 ]
[ Application: psql - Total duration: 24m57s - Times executed: 263 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-25 14:58:25 Duration: 3m10s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-25 07:47:56 Duration: 2m42s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-25 14:37:46 Duration: 2m35s Database: rio User: intelifix Remote: [local] Application: psql
16 668ms 5s801ms 3s716ms 50 3m5s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 25 08 3 11s17ms 3s672ms 09 3 10s611ms 3s537ms 10 2 7s506ms 3s753ms 11 3 10s699ms 3s566ms 12 5 17s242ms 3s448ms 13 4 14s323ms 3s580ms 14 4 14s827ms 3s706ms 15 3 10s793ms 3s597ms 16 3 11s884ms 3s961ms 17 3 10s584ms 3s528ms 18 4 16s101ms 4s25ms 19 4 15s261ms 3s815ms 20 3 11s730ms 3s910ms 21 3 11s586ms 3s862ms 22 3 11s640ms 3s880ms [ User: intelifix - Total duration: 3m5s - Times executed: 50 ]
[ Application: psql - Total duration: 3m5s - Times executed: 50 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-25 12:20:11 Duration: 5s801ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-25 18:00:11 Duration: 5s132ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-25 16:40:06 Duration: 4s883ms Database: rio User: intelifix Remote: [local] Application: psql
17 176ms 1m53s 3s245ms 83 4m29s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 25 07 4 7s256ms 1s814ms 08 12 30s334ms 2s527ms 09 28 19s138ms 683ms 10 12 1m58s 9s871ms 11 8 30s523ms 3s815ms 12 1 763ms 763ms 14 8 23s727ms 2s965ms 15 7 5s640ms 805ms 16 3 33s504ms 11s168ms [ User: intelifix - Total duration: 4m29s - Times executed: 83 ]
[ Application: psql - Total duration: 4m29s - Times executed: 83 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028967);
Date: 2026-08-25 10:16:35 Duration: 1m53s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029065);
Date: 2026-08-25 16:29:36 Duration: 31s982ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029022);
Date: 2026-08-25 14:36:54 Duration: 19s141ms Database: rio User: intelifix Remote: [local] Application: psql
18 150ms 10s991ms 1s333ms 1,313 29m11s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 25 08 183 3m8s 1s27ms 09 222 4m10s 1s128ms 10 119 2m6s 1s60ms 11 204 2m46s 817ms 12 26 56s125ms 2s158ms 13 54 1m30s 1s684ms 14 130 4m10s 1s928ms 15 173 5m 1s738ms 16 135 3m33s 1s579ms 17 67 1m48s 1s612ms [ User: intelifix - Total duration: 29m11s - Times executed: 1313 ]
[ Application: [unknown] - Total duration: 29m11s - Times executed: 1313 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (281316, 452, 'ZTE3ANNQ8101903,689E29BC0B65,689E29BC0B66,ZTEGD7B741FF$ZTE3ANNR5W35807,48D68231CB04,48D68231CB05,ZTEGDB008BDE$ZTE3ANNT2V31063,D831398E66E2,D831398E66E3,ZTEGDD306BD6$ZTE3ANNR8C43524,38914852831F,389148528320,ZTEGDB092A74$ZTE3ANNT2V37558,D831398EFF1C,D831398EFF1D,ZTEGDD308535$ZTE3ANNQ8F09517,689E29FD01EB,689E29FD01EC,ZTEGD7BA21FD$ZTE3ANNQ5N08209,3CF9F0AD85DC,3CF9F0AD85DD,ZTEGD641D658$ZTE3ANNR9F54217,D89A0DA7D499,D89A0DA7D49A,ZTEGDB15FB14$ZTE3ANNR8C46088,38914852BF37,38914852BF38,ZTEGDB093478$ZTE3ANNRCB01798,D831391DF922,D831391DF923,ZTEGDD29BC9B$ZTE3ANNQ8F11537,689E29FD3143,689E29FD3144,ZTEGD7BA29E1$ZTE3ANNQ8F09980,689E29FD0CC5,689E29FD0CC6,ZTEGD7BA23CC$ZTE3ANNR9F51259,D89A0DA78F45,D89A0DA78F46,ZTEGDB15EF86$ZTE3ANNR9W55155,D89A0DAD68D5,D89A0DAD68D6,ZTEGDB16E91E$ZTE3ANNRAM49107,5872C98BB72B,5872C98BB72C,ZTEGDC60BFD2$ZTE3ANNRCB18715,D831391F85A0,D831391F85A1,ZTEGDD29FEB0$ZTE3ANNR2Q21372,F4E84F82A8E8,F4E84F82A8E9,ZTEGD97AC636$ZTE3ANNQ9J01605,843C992BF6D3,843C992BF6D4,ZTEGD7BB0EF0$ZTE3ANNT2V16301,D831398D0CE6,D831398D0CE7,ZTEGDD30322C$ZTE3ANNQ4412980,3CF9F0AC8F16,3CF9F0AC8F17,ZTEGD641AD37$ZTE3ANNQ3610335,3CF9F0A5C7A8,3CF9F0A5C7A9,ZTEGD6408BFA$ZTE3ANNQ4414357,3CF9F0ACAF5C,3CF9F0ACAF5D,ZTEGD641B298$ZTE3ANNR9F15355,D89A0DA445C5,D89A0DA445C6,ZTEGDB156346$ZTE3ANNR6R44212,48D6823990FA,48D6823990FB,ZTEGDB01D787', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-25 17:19:17 Duration: 10s991ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (281304, 508, '14126785850098500015,D86C5A3C1353,D86C5A3BF6F1,C85D3814DB7E,C85D389F9C08,C85D388BEF93,C85D380F7A1B,C85D3870CDA9,C85D38F0A7EE,C85D380CBDF8,C85D3810E17C,C85D38600090,C85D388489B8,D86C5A3D28D6,C85D38D4C005,D86C5A3DAF34,C85D3817C70B,D86C5A561663,C85D38EC2AAC', '',0151,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-25 14:03:33 Duration: 10s756ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (280903, 452, '270911029485100950,229780192229,229734103859,229672890927,229748165051,229689097782,229810671130,229665155154,229747886988,229735420318,216943782443,229673928995,229663452643,229672217190,229860319308,229784389911,229816231313,229748793351,229689216582,229810467192,216940469403,216943043347,229688723145,229784291013,229806589697,229808152545,229816916890,229850315256,229859223556,216936955356,229688416167,229865856885,229785472228,229806526785,229782009397,229785129411,229879786370,229685304663,229806292038', '246587508700,246538552138,246501746278,246570309109,246518427681,246639548201,246469085975,246548989193,246546563447,246457061626,246496143644,246499572733,246499134351,246424894861,246098339108,246628834046,246552084154,246617664056,246639363233,246474611128,246457063848,246515962537,246587379595,246604729202,246581551329,246627280214,246639695364,246641300516,246477431818,246518363658,246651833036,246596388084,246581324460,246588097578,246584716777,246652208808,246499044163,246596465264,,', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-25 10:00:04 Duration: 8s217ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 165ms 4s753ms 896ms 127 1m53s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 25 08 23 17s46ms 741ms 09 35 32s468ms 927ms 11 1 2s161ms 2s161ms 13 17 17s81ms 1s4ms 14 5 2s478ms 495ms 15 4 3s315ms 828ms 16 12 15s124ms 1s260ms 17 30 24s172ms 805ms [ User: intelifix - Total duration: 1m53s - Times executed: 127 ]
[ Application: [unknown] - Total duration: 1m53s - Times executed: 127 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0134424) LIMIT 1;
Date: 2026-08-25 17:04:03 Duration: 4s753ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0281213) LIMIT 1;
Date: 2026-08-25 13:38:01 Duration: 3s611ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0280739) LIMIT 1;
Date: 2026-08-25 08:37:55 Duration: 3s595ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 150ms 16s797ms 736ms 83 1m1s select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 25 01 1 320ms 320ms 05 1 160ms 160ms 07 8 10s590ms 1s323ms 08 4 1s800ms 450ms 09 8 21s728ms 2s716ms 10 8 5s550ms 693ms 11 7 2s209ms 315ms 12 6 1s363ms 227ms 14 5 1s878ms 375ms 15 11 3s356ms 305ms 16 20 11s517ms 575ms 17 4 670ms 167ms [ User: intelifix - Total duration: 1m1s - Times executed: 83 ]
[ Application: [unknown] - Total duration: 1m1s - Times executed: 83 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "353", "data-de" : "2026-01-01", "data-ate" : "2026-08-25", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 398 }');
Date: 2026-08-25 09:08:37 Duration: 16s797ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "362", "data-de" : "2026-08-25", "data-ate" : "2026-08-25", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 414 }');
Date: 2026-08-25 16:20:54 Duration: 3s530ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "362", "data-de" : "2026-08-24", "data-ate" : "2026-08-24", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 414 }');
Date: 2026-08-25 07:06:04 Duration: 2s712ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 3 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 25 12 1 0ms 0ms 18 1 0ms 0ms 20 1 0ms 0ms [ User: intelifix - Total duration: 2s49ms - Times executed: 3 ]
[ Application: psql - Total duration: 1s391ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 658ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 20,046 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 30 FATAL entries
- 4009 ERROR entries
- 0 WARNING entries
- 28 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,977 Max number of times the same event was reported
- 4,067 Total events found
Rank Times reported Error 1 3,977 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 25 00 59 01 60 02 59 03 55 04 59 05 60 06 60 07 176 08 315 09 439 10 288 11 412 12 227 13 218 14 356 15 436 16 233 17 109 18 60 19 59 20 60 21 60 22 59 23 58 - ERROR: prepared statement "_PLAN0000000029A0DC60" does not exist
- ERROR: prepared statement "_PLAN0000000029A0E0F0" does not exist
- ERROR: prepared statement "_PLAN0000000029A0D7D0" does not exist
Statement: DEALLOCATE "_PLAN0000000029A0DC60"
Date: 2026-08-25 00:00:56 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029A0E0F0"
Date: 2026-08-25 00:01:56 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029A0D7D0"
Date: 2026-08-25 00:02:57 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 20 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 25 07 1 09 6 10 2 12 7 15 2 17 2 - ERROR: syntax error at or near "230055399211" at character 41
- ERROR: syntax error at or near "270911029173103694" at character 46
- ERROR: syntax error at or near "270911029173103694" at character 32
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''230055399211');
Date: 2026-08-25 07:49:03 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT SAIDA FROM RS_SMARTCARD_TELA( 0141, ''270911029173103694' )
Date: 2026-08-25 09:02:33 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT RS_SERIAL_TEMPORARIO( ''270911029173103694' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''270911029173103694' )
Date: 2026-08-25 09:02:33 Database: rio Application: [unknown] User: intelifix Remote: [local]
3 13 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 25 00 1 05 3 06 1 07 1 08 1 09 1 10 1 16 1 20 1 22 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-08-25 00:02:56 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-25 05:16:48 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-25 05:17:04 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
4 12 ERROR: process ... detected deadlock while waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 25 07 3 08 2 14 7 - ERROR: process 2411625 detected deadlock while waiting for ShareLock on transaction 4981256 after 1000.265 ms
- ERROR: process 2411625 detected deadlock while waiting for ShareLock on transaction 4981256 after 1000.218 ms
- ERROR: process 2411625 detected deadlock while waiting for ShareLock on transaction 4981256 after 1000.135 ms
Detail: Process holding the lock: 2419468. Wait queue: .
Context: while updating tuple (18753,205) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 028923, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-08-25 07:47:46 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 2419468. Wait queue: .
Context: while updating tuple (18753,205) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL assignment "cRetAux := RS_NF_ASSOCIA_EQUIPAMENTO( nLI )" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 028923, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-08-25 07:47:48 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 2419468. Wait queue: .
Context: while updating tuple (77628,69) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL assignment "cRetAux := RS_NF_ASSOCIA_EQUIPAMENTO( nLI )" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 028923, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-08-25 07:47:49 Database: rio Application: [unknown] User: intelifix Remote: [local]
5 11 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 25 07 1 08 1 11 3 14 6 - LOG: process 2419468 still waiting for ShareLock on transaction 4980573 after 1000.214 ms
- LOG: process 2461004 still waiting for ShareLock on transaction 4985856 after 1000.158 ms
- LOG: process 95881 still waiting for ShareLock on transaction 5014927 after 1000.096 ms
Detail: Process holding the lock: 2411625. Wait queue: 2419468.
Context: while updating tuple (77628,53) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-08-25 07:45:21 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 2427270. Wait queue: 2461004.
Context: while updating tuple (77634,65) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-08-25 08:45:20 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 93033. Wait queue: 95881.
Context: while updating tuple (1,30) in relation "usuarios" SQL statement "UPDATE USUARIOS SET EQ_CODIGO = NULL, USU_CHECK_IN = NULL WHERE USU_ID = nUser" PL/pgSQL function rs_tecnico_check_out(integer) line 28 at SQL statement SQL statement "SELECT RS_TECNICO_CHECK_OUT( nTecnico )" PL/pgSQL function rs_baixa(integer,integer,integer,integer,character varying,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1129 at PERFORM PL/pgSQL function rs_fluxo_encerra(integer,integer,boolean) line 169 at assignment PL/pgSQL function rs_cria_fluxo_fechado(integer,character varying,integer,boolean) line 94 at assignment PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1095 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(54567,406,'835225933006295,241703972443$833277940001671,230039512442$835176926002556,241692622536$835153923000282,241680371217$834253937000920,241622467787','',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""}]','$$$$','',00);Date: 2026-08-25 11:40:21 Database: contagem Application: [unknown] User: intelifix Remote: [local]
6 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 25 03 9 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-08-25 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-25 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-08-25 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
7 4 ERROR: function rs_etiqueta(...) does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 25 08 2 15 2 - ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) 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_ETIQUETA(229728875458.)Date: 2026-08-25 08:29:32 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(229728875458.)Date: 2026-08-25 08:29:33 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73931885850072300742)Date: 2026-08-25 15:20:17 Database: rio Application: [unknown] User: etiquetas Remote: [local]
8 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 25 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-25 05:32:22 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-25 05:32:22 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-25 05:32:22 Database: contagem Application: psql User: intelifix Remote: [local]
9 4 FATAL: the database system is starting up
Times Reported Most Frequent Error / Event #9
Day Hour Count Aug 25 10 1 16 3 - FATAL: the database system is starting up
- FATAL: the database system is starting up
- FATAL: the database system is starting up
Date: 2026-08-25 10:33:24 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-25 16:20:32 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-25 16:20:33 Database: rio Application: [unknown] User: etiquetas Remote: [local]
10 3 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Aug 25 07 3 - ERROR: column "pas_id" does not exist at character 66 2026-08-25 07:16:28 -03 [2408352]: [21-1] user=intelifix,db=brasilia,app=[unknown],client=[local] QUERY: SELECT * FROM PARTE_MOVIMENTOS WHERE PM_ID = ANY( aPMs ) AND PAS_ID = nPasso
- ERROR: column "pas_id" does not exist at character 66 2026-08-25 07:16:41 -03 [2408352]: [26-1] user=intelifix,db=brasilia,app=[unknown],client=[local] QUERY: SELECT * FROM PARTE_MOVIMENTOS WHERE PM_ID = ANY( aPMs ) AND PAS_ID = nPasso
- ERROR: column "pas_id" does not exist at character 66 2026-08-25 07:17:19 -03 [2408352]: [31-1] user=intelifix,db=brasilia,app=[unknown],client=[local] QUERY: SELECT * FROM PARTE_MOVIMENTOS WHERE PM_ID = ANY( aPMs ) AND PAS_ID = nPasso
Context: PL/pgSQL function rs_caixa_kits_exclui(integer,integer) line 46 at FOR over SELECT rows PL/pgSQL function rs_lote_saida_exclui(integer) line 87 at assignment
Hint: Perhaps you meant to reference the column "parte_movimentos.ps_id".
Statement: SELECT * FROM RS_LOTE_SAIDA_EXCLUI(0134423);Date: 2026-08-25 07:16:28 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL function rs_caixa_kits_exclui(integer,integer) line 46 at FOR over SELECT rows PL/pgSQL function rs_lote_saida_exclui(integer) line 87 at assignment
Hint: Perhaps you meant to reference the column "parte_movimentos.ps_id".
Statement: SELECT * FROM RS_LOTE_SAIDA_EXCLUI(0134423);Date: 2026-08-25 07:16:41 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL function rs_caixa_kits_exclui(integer,integer) line 46 at FOR over SELECT rows PL/pgSQL function rs_lote_saida_exclui(integer) line 87 at assignment
Hint: Perhaps you meant to reference the column "parte_movimentos.ps_id".
Statement: SELECT * FROM RS_LOTE_SAIDA_EXCLUI(0134423);Date: 2026-08-25 07:17:19 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
11 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #11
Day Hour Count Aug 25 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-25 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-25 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-25 03:05:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
12 2 LOG: database system was interrupted; last known up at ...
Times Reported Most Frequent Error / Event #12
Day Hour Count Aug 25 10 1 16 1 - LOG: database system was interrupted; last known up at 2026-08-25 10:14:38 -03
- LOG: database system was interrupted; last known up at 2026-08-25 16:03:05 -03
Date: 2026-08-25 10:33:24
Date: 2026-08-25 16:20:32
13 2 LOG: database system was not properly shut down; automatic recovery in progress
Times Reported Most Frequent Error / Event #13
Day Hour Count Aug 25 10 1 16 1 - LOG: database system was not properly shut down; automatic recovery in progress
- LOG: database system was not properly shut down; automatic recovery in progress
Date: 2026-08-25 10:33:26
Date: 2026-08-25 16:20:35
14 1 FATAL: the database system is not yet accepting connections
Times Reported Most Frequent Error / Event #14
Day Hour Count Aug 25 10 1 - FATAL: the database system is not yet accepting connections
Detail: Consistent recovery state has not been yet reached.
Date: 2026-08-25 10:33:27 Database: contagem Application: [unknown] User: intelifix Remote: [local]
15 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #15
Day Hour Count Aug 25 03 1 - LOG: database system was shut down at 2026-08-25 03:05:02 -03
Date: 2026-08-25 03:05:03
16 1 ERROR: invalid input syntax for type integer: ...
Times Reported Most Frequent Error / Event #16
Day Hour Count Aug 25 11 1 - ERROR: invalid input syntax for type integer: ""
Context: PL/pgSQL function rs_pre_alerta_tela(text) line 30 at assignment
Statement: SELECT * FROM RS_PRE_ALERTA_TELA('{"barra1":"CLARO_93796B","barra2":"","barra3":"","lote":""}');Date: 2026-08-25 11:33:56 Database: brasilia Application: [unknown] User: intelifix Remote: [local]