pgBadger-
Global information
- Generated on Wed Aug 5 23:50:12 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 42,622 log entries in 11s
- Log start from 2026-08-05 00:00:51 to 2026-08-05 23:49:35
-
Overview
Global Stats
- 399 Number of unique normalized queries
- 6,470 Number of queries
- 8h57m49s Total query duration
- 2026-08-05 00:02:07 First query
- 2026-08-05 23:44:46 Last query
- 4 queries/s at 2026-08-05 23:43:46 Query peak
- 8h57m49s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h57m49s Execute total duration
- 3,772 Number of events
- 18 Number of unique normalized events
- 3,667 Max number of times the same event was reported
- 0 Number of cancellation
- 513 Total number of automatic vacuums
- 1,009 Total number of automatic analyzes
- 12 Number temporary file
- 238.91 MiB Max size of temporary file
- 109.88 MiB Average size of temporary file
- 380 Total number of sessions
- 8 sessions at 2026-08-05 13:05:06 Session peak
- 13d21h4m17s Total duration of sessions
- 52m35s Average duration of sessions
- 17 Average queries per session
- 1m24s Average queries duration per session
- 51m10s Average idle time per session
- 387 Total number of connections
- 5 connections/s at 2026-08-05 06:02:04 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-05 23:43:46 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-05 08:45:11 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-05 23:43:46 Date
Queries duration
Key values
- 8h57m49s 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 05 00 28 0ms 17s941ms 4s549ms 5s189ms 8s809ms 1m24s 01 42 0ms 4s570ms 1s66ms 3s401ms 7s329ms 8s172ms 02 24 0ms 3s820ms 1s532ms 4s387ms 5s688ms 6s905ms 03 24 0ms 4s764ms 1s846ms 5s313ms 7s79ms 9s862ms 04 43 0ms 4s399ms 1s71ms 5s729ms 7s263ms 7s666ms 05 38 0ms 10m13s 33s996ms 6s594ms 2m51s 10m38s 06 18 0ms 8s987ms 2s745ms 3s371ms 3s971ms 28s799ms 07 164 0ms 11m12s 10s648ms 32s734ms 4m19s 11m12s 08 557 0ms 6m1s 2s671ms 27s363ms 4m9s 6m57s 09 537 0ms 9m35s 5s324ms 2m15s 6m27s 9m51s 10 697 150ms 8m52s 4s637ms 4m35s 5m16s 9m 11 616 150ms 9m58s 5s717ms 4m41s 5m43s 10m23s 12 157 0ms 7m33s 6s555ms 30s159ms 1m15s 7m34s 13 341 0ms 6m21s 3s154ms 16s202ms 2m5s 6m22s 14 603 151ms 7m7s 3s156ms 1m1s 3m51s 8m29s 15 707 150ms 9m55s 5s634ms 2m54s 7m42s 13m 16 744 150ms 9m32s 2s425ms 58s686ms 2m42s 9m35s 17 514 0ms 8m9s 3s480ms 1m3s 1m38s 8m10s 18 27 0ms 6m36s 26s221ms 6s515ms 53s771ms 6m36s 19 24 0ms 5m41s 26s659ms 6s64ms 50s906ms 5m41s 20 128 0ms 8m40s 11s173ms 1m11s 1m30s 8m40s 21 52 0ms 5m52s 13s231ms 8s478ms 52s6ms 5m52s 22 37 0ms 5m54s 18s661ms 7s866ms 47s533ms 5m54s 23 348 0ms 1m24s 5s857ms 1m7s 1m12s 1m26s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 05 00 5 0 1s804ms 0ms 0ms 1s102ms 01 24 0 256ms 186ms 383ms 543ms 02 7 0 394ms 0ms 0ms 1s196ms 03 6 0 398ms 0ms 0ms 613ms 04 25 0 229ms 179ms 368ms 862ms 05 14 0 326ms 0ms 175ms 1s171ms 06 3 0 726ms 0ms 0ms 0ms 07 114 0 12s944ms 3s112ms 21s831ms 5m51s 08 413 0 2s970ms 10s225ms 20s541ms 4m53s 09 397 0 6s399ms 10s612ms 2m15s 7m32s 10 507 0 4s922ms 13s549ms 4m25s 5m16s 11 469 0 6s587ms 26s704ms 4m38s 8m28s 12 98 0 8s938ms 2s619ms 15s465ms 3m31s 13 267 0 3s642ms 7s295ms 11s457ms 4m8s 14 444 0 3s345ms 15s63ms 36s9ms 3m52s 15 521 0 6s77ms 23s600ms 2m35s 7m20s 16 575 0 2s755ms 17s962ms 42s762ms 3m58s 17 381 0 3s932ms 17s246ms 1m2s 4m38s 18 9 0 1m12s 0ms 0ms 3m21s 19 6 0 1m38s 0ms 0ms 3m19s 20 16 92 12s613ms 18s245ms 1m7s 3m40s 21 22 0 28s159ms 0ms 1s166ms 3m30s 22 13 0 48s179ms 0ms 239ms 3m41s 23 23 325 5s857ms 1m1s 1m7s 1m26s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 05 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 05 00 0 1 1.00 0.00% 01 0 1 1.00 0.00% 02 0 2 2.00 0.00% 03 0 2 2.00 0.00% 04 0 2 2.00 0.00% 05 0 2 2.00 0.00% 06 0 0 0.00 0.00% 07 0 9 9.00 0.00% 08 0 9 9.00 0.00% 09 0 15 15.00 0.00% 10 0 15 15.00 0.00% 11 0 12 12.00 0.00% 12 0 4 4.00 0.00% 13 0 13 13.00 0.00% 14 0 9 9.00 0.00% 15 0 21 21.00 0.00% 16 0 15 15.00 0.00% 17 0 8 8.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 4 4.00 0.00% 22 0 6 6.00 0.00% 23 0 11 11.00 0.00% Day Hour Count Average / Second Aug 05 00 17 0.00/s 01 11 0.00/s 02 11 0.00/s 03 24 0.01/s 04 9 0.00/s 05 9 0.00/s 06 14 0.00/s 07 17 0.00/s 08 16 0.00/s 09 23 0.01/s 10 26 0.01/s 11 22 0.01/s 12 15 0.00/s 13 18 0.01/s 14 21 0.01/s 15 25 0.01/s 16 22 0.01/s 17 17 0.00/s 18 12 0.00/s 19 10 0.00/s 20 13 0.00/s 21 12 0.00/s 22 12 0.00/s 23 11 0.00/s Day Hour Count Average Duration Average idle time Aug 05 00 6 1h30s 1h9s 01 16 1h1m5s 1h1m2s 02 11 1h16s 1h13s 03 21 21m55s 21m53s 04 10 1h2m20s 1h2m16s 05 9 1h46s 58m23s 06 8 58m35s 58m29s 07 16 52m49s 50m59s 08 13 1h17s 58m22s 09 20 49m23s 47m 10 23 54m28s 52m8s 11 29 49m22s 47m20s 12 17 58m32s 57m32s 13 14 1h13s 58m56s 14 21 53m50s 52m19s 15 24 48m35s 45m49s 16 21 53m51s 52m25s 17 21 57m41s 56m15s 18 19 54m9s 53m32s 19 9 1h20s 59m9s 20 14 44m26s 42m44s 21 9 1h 58m43s 22 13 56m23s 55m30s 23 16 39m38s 37m30s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-08-05 06:02:04 Date
Connections per database
Key values
- rio Main Database
- 387 connections Total
Connections per user
Key values
- intelifix Main User
- 387 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-08-05 13:05:06 Date
Histogram of session times
Key values
- 306 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
- 15,169 buffers Checkpoint Peak
- 2026-08-05 14:39:46 Date
- 270.001 seconds Highest write time
- 0.152 seconds Sync time
Checkpoints Wal files
Key values
- 14 files Wal files usage Peak
- 2026-08-05 10:29:42 Date
Checkpoints distance
Key values
- 456.83 Mo Distance Peak
- 2026-08-05 10:29:42 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 05 00 28,892 633.852s 0.132s 634.046s 01 3,638 365.263s 0.1s 365.505s 02 11,576 439.562s 0.049s 439.74s 03 2,585 239.294s 0.241s 239.656s 04 3,311 332.297s 0.21s 332.586s 05 9,693 971.848s 0.326s 972.386s 06 3,582 358.937s 0.007s 358.962s 07 19,257 1,626.798s 0.301s 1,627.213s 08 46,500 2,825.06s 0.54s 2,825.772s 09 82,889 3,238.558s 0.862s 3,239.655s 10 82,092 3,238.573s 0.902s 3,239.721s 11 91,195 3,238.517s 0.893s 3,239.655s 12 27,123 2,166.343s 0.295s 2,166.813s 13 32,913 2,162.901s 0.721s 2,163.766s 14 80,365 3,237.742s 0.75s 3,238.719s 15 93,216 3,238.643s 0.825s 3,239.722s 16 46,745 3,154.463s 0.889s 3,155.622s 17 53,424 2,726.242s 0.51s 2,726.928s 18 1,626 163.191s 0.032s 163.27s 19 28 2.832s 0.007s 2.846s 20 630 200.854s 0.029s 200.906s 21 3,471 348.523s 0.106s 348.9s 22 2,464 247.455s 0.247s 247.877s 23 416 41.833s 0.08s 41.976s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 05 00 0 0 6 455 0.060s 0.006s 01 0 0 1 730 0.010s 0.01s 02 0 0 2 345 0.006s 0.006s 03 0 0 0 510 0.062s 0.013s 04 0 0 1 625 0.063s 0.013s 05 0 0 5 815 0.083s 0.009s 06 0 0 1 21 0.002s 0.002s 07 0 0 16 2,022 0.064s 0.011s 08 0 0 19 5,198 0.023s 0.012s 09 0 0 40 6,795 0.062s 0.012s 10 0 0 66 7,381 0.064s 0.012s 11 0 0 50 7,509 0.062s 0.012s 12 0 0 13 3,107 0.047s 0.011s 13 0 0 10 5,060 0.063s 0.012s 14 0 0 42 7,401 0.012s 0.012s 15 0 0 52 7,488 0.041s 0.012s 16 0 0 24 6,634 0.027s 0.012s 17 0 0 33 4,747 0.036s 0.011s 18 0 0 1 188 0.006s 0.007s 19 0 0 0 7 0.004s 0.001s 20 0 0 1 81 0.004s 0.003s 21 0 0 1 723 0.029s 0.01s 22 0 0 1 563 0.088s 0.032s 23 0 0 0 45 0.062s 0.015s Day Hour Count Avg time (sec) Aug 05 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 05 00 18,362.50 kB 55,120.33 kB 01 1,807.70 kB 28,855.60 kB 02 3,482.00 kB 13,824.00 kB 03 1,377.10 kB 3,483.40 kB 04 1,621.80 kB 2,560.70 kB 05 9,114.00 kB 15,943.62 kB 06 5,933.00 kB 14,607.50 kB 07 23,815.91 kB 49,403.91 kB 08 25,847.33 kB 57,996.92 kB 09 54,653.33 kB 77,720.42 kB 10 90,499.83 kB 161,830.17 kB 11 69,091.08 kB 121,794.33 kB 12 17,934.00 kB 83,647.73 kB 13 14,228.50 kB 36,532.00 kB 14 57,386.67 kB 88,667.75 kB 15 70,779.75 kB 101,741.25 kB 16 32,835.17 kB 78,820.58 kB 17 49,761.09 kB 69,577.09 kB 18 1,144.50 kB 45,511.17 kB 19 193.00 kB 31,060.00 kB 20 5,932.00 kB 26,720.67 kB 21 1,810.78 kB 15,466.56 kB 22 1,289.10 kB 6,689.10 kB 23 143.00 kB 3,047.86 kB -
Temporary Files
Size of temporary files
Key values
- 477.81 MiB Temp Files size Peak
- 2026-08-05 05:32:13 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-05 05:30:40 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 05 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.08 GiB 111.06 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 2 208.00 MiB 104.00 MiB 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 928.07 MiB 71.26 MiB 238.91 MiB 116.01 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-05 05:32:21 Duration: 1m38s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-05 05:32:13 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 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_NF_CARGA_LOTES( 028054, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-05 11:38:51 Duration: 8m Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028029, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-05 09:20:28 Duration: 7m25s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028067, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-05 15:08:41 Duration: 7m18s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 2 182.53 MiB 91.27 MiB 91.27 MiB 91.27 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-05 05:30:43 Duration: 41s696ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-05 05:30:40 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 238.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-05 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 238.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-05 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_83.xlsx');[ Date: 2026-08-05 15:12:30 - 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-05 15:17:35 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 91.27 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-05 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 91.27 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-05 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 78.86 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-05 05:32:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 78.77 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-05 05:32:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 78.77 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-05 05:32:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 71.34 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-05 05:32:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 71.26 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-05 05:32:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 71.26 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-05 05:32:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 5.11 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-05 15:08:51 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 5.11 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-05 15:08:51 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (115) Main table analyzed (database rio)
- 1,009 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 115 brasilia.pg_catalog.pg_attribute 58 rio.pg_catalog.pg_class 58 rio.pg_catalog.pg_type 50 rio.public.usuarios 49 rio.pg_catalog.pg_index 33 brasilia.pg_catalog.pg_class 30 rio.pg_catalog.pg_depend 28 contagem.pg_catalog.pg_attribute 28 brasilia.pg_catalog.pg_type 27 rio.public.temp0000287518 27 rio.public.temp0000287578 25 contagem.public.usuarios 24 rio.public.temp0000287574 21 rio.public.temp0000287520 19 brasilia.pg_catalog.pg_index 18 rio.public.temp0000287516 18 rio.public.temp0000287312 17 contagem.public.temp0000226768 16 brasilia.pg_catalog.pg_depend 16 contagem.pg_catalog.pg_class 14 rio.public.temp0000287498 13 rio.public.temp0000287598 12 rio.public.temp0000287532 12 rio.public.temp0000287508 11 contagem.pg_catalog.pg_type 11 rio.public.temp0000287611 10 rio.public.temp0000287454 10 rio.public.temp0000287570 9 brasilia.public.usuarios 9 rio.public.temp0000287484 9 rio.public.temp0000287596 8 rio.public.temp0000287514 8 contagem.pg_catalog.pg_index 7 brasilia.public.temp0000237496 7 brasilia.public.temp0000237544 7 brasilia.public.temp0000237522 7 rio.public.temp0000287556 6 rio.public.temp0000287306 6 rio.public.tmp_drill_0320 6 rio.public.tmp_drill_0175 5 rio.public.temp0000287406 5 rio.public.temp0000287590 5 brasilia.public.temp0000237500 5 rio.pg_catalog.pg_shdepend 5 rio.public.temp0000287510 5 brasilia.public.nf_entrada 5 contagem.pg_catalog.pg_depend 5 brasilia.public.temp0000237572 5 brasilia.public.temp0000237512 5 template1.pg_catalog.pg_shdepend 4 brasilia.pg_catalog.pg_shdepend 4 brasilia.auditor.auditor_2026_08 4 rio.public.temp0000287394 4 rio.public.temp0000287502 4 rio.public.temp0000287388 4 brasilia.public.temp0000237556 4 rio.public.temp0000287566 4 brasilia.public.temp0000237558 3 rio.public.temp0000287619 3 rio.public.temp0000287617 3 rio.auditor.auditor_2026_08 3 rio.public.temp0000287534 3 brasilia.public.temp0000237552 3 brasilia.public.temp0000237564 2 brasilia.public.temp0000237542 2 rio.public.temp0000287594 2 brasilia.public.temp0000237518 2 rio.public.temp0000287550 2 rio.public.temp0000287522 2 rio.public.temp0000287592 2 brasilia.public.temp0000237548 2 contagem.public.temp0000226766 2 contagem.auditor.auditor_2026_08 2 rio.public.temp0000287536 2 rio.public.temp0000287540 1 brasilia.public.temp0000237498 1 contagem.public.temp0000226764 1 rio.public.temp0000287410 1 brasilia.public.temp0000237588 1 brasilia.public.temp0000237532 1 rio.public.temp0000287615 1 contagem.public.temp0000226710 1 rio.public.temp0000287588 1 rio.public.temp0000287568 1 contagem.pg_catalog.pg_shdepend 1 brasilia.public.temp0000237578 1 brasilia.public.temp0000237504 1 brasilia.public.temp0000237514 1 brasilia.public.temp0000237580 1 brasilia.public.temp0000237582 1 contagem.public.temp0000226724 1 postgres.pg_catalog.pg_shdepend 1 brasilia.public.temp0000237502 1 rio.public.temp0000287526 1 brasilia.public.temp0000237568 1 brasilia.public.temp0000237510 1 rio.public.temp0000287528 1 rio.public.temp0000287548 1 rio.public.temp0000287580 1 brasilia.public.temp0000237524 1 brasilia.public.temp0000237546 1 rio.public.temp0000287584 1 Total 1,009 Vacuums per table
Key values
- pg_catalog.pg_attribute (63) Main table vacuumed on database rio
- 513 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 63 45 0 0 0 0 0 23,406 6,076 8,807,970 305 7,015 rio.pg_catalog.pg_class 53 29 0 0 0 0 0 5,422 1,501 2,241,266 85 339 rio.pg_catalog.pg_type 35 23 0 0 0 0 0 2,234 683 910,165 65 198 brasilia.pg_catalog.pg_attribute 25 21 0 0 0 0 0 10,575 2,125 3,787,361 95 2,147 contagem.public.usuarios 24 0 0 0 0 0 0 116 90 47,557 2 2 rio.public.temp0000287574 21 0 0 0 0 0 0 25,618 3,484 5,912,422 0 0 rio.public.temp0000287312 15 0 0 0 0 0 0 1,212 81 83,838 0 0 rio.public.usuarios 14 4 0 0 0 0 0 157 58 92,823 7 15 brasilia.pg_catalog.pg_class 14 14 0 0 0 0 0 2,763 506 905,052 29 83 rio.public.temp0000287518 14 0 0 0 0 0 0 20,462 3,456 5,598,311 0 0 rio.pg_catalog.pg_index 14 14 0 0 0 0 0 786 235 259,515 41 105 rio.pg_catalog.pg_depend 13 13 0 0 0 0 0 3,726 1,383 1,902,011 84 636 brasilia.pg_catalog.pg_type 11 11 0 0 0 0 0 1,146 210 312,272 21 54 rio.public.temp0000287454 10 0 0 0 0 0 0 538 50 39,801 0 0 rio.public.temp0000287611 10 0 0 0 0 0 0 11,961 5,146 7,294,214 0 0 rio.public.temp0000287484 9 0 0 0 0 0 0 10,242 33 609,510 0 0 contagem.pg_catalog.pg_attribute 9 9 0 0 0 0 0 4,641 1,506 2,553,481 14 542 rio.public.tmp_drill_0175 9 5 0 0 0 0 0 1,790 603 1,012,179 2 130 brasilia.pg_catalog.pg_index 8 8 0 0 0 0 0 396 70 76,630 14 28 rio.public.temp0000287596 8 0 0 0 0 0 0 8,682 35 517,568 0 0 rio.public.tmp_drill_0320 7 5 0 0 0 0 0 4,190 17 707,201 0 0 brasilia.public.temp0000237522 7 0 0 0 0 0 0 1,486 41 95,593 0 0 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 9,812 3,065 12,322,216 1,917 8,722 rio.public.temp0000287532 6 0 0 0 0 0 0 3,587 28 215,921 0 0 brasilia.pg_catalog.pg_depend 6 6 0 0 0 0 0 1,639 430 739,575 18 109 rio.public.temp0000287556 6 0 0 0 0 0 0 3,426 20 205,492 0 0 rio.public.temp0000287306 5 0 0 0 0 0 0 510 25 34,093 0 0 rio.public.temp0000287590 5 0 0 0 0 0 0 8,534 1,724 2,701,774 0 0 template1.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 637 182 311,647 69 151 brasilia.public.temp0000237512 4 0 0 0 0 0 0 749 23 48,706 0 0 rio.public.temp0000287566 4 0 0 0 0 0 0 5,122 15 304,545 0 0 rio.public.temp0000287388 4 0 0 0 0 0 0 524 22 34,416 0 0 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 2,127 602 2,824,089 164 562 contagem.pg_catalog.pg_class 4 4 0 0 0 0 0 552 212 280,614 7 23 rio.public.temp0000287578 4 0 0 0 0 0 0 580 24 38,142 0 0 rio.auditor.auditor_2026_08 4 0 0 0 0 0 0 114,650 44,975 60,114,371 34,239 675,565 brasilia.public.temp0000237556 3 0 0 0 0 0 0 738 18 46,998 0 0 brasilia.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 532 160 601,050 37 88 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,395 1,615 5,638,390 1,269 7,716 brasilia.auditor.auditor_2026_08 3 0 0 0 0 0 0 19,894 10,880 14,065,070 3,863 71,432 contagem.pg_catalog.pg_type 3 3 0 0 0 0 0 252 108 144,189 3 6 postgres.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 249 98 136,766 25 59 contagem.auditor.auditor_2026_08 2 0 0 0 0 0 0 13,458 7,376 8,573,199 2,144 35,719 rio.public.temp0000287592 2 0 0 0 0 0 0 1,771 8 105,695 0 0 contagem.pg_catalog.pg_depend 2 2 0 0 0 0 0 617 229 430,238 1 6 contagem.pg_catalog.pg_index 2 2 0 0 0 0 0 136 54 37,211 1 1 rio.public.temp0000287406 2 0 0 0 0 0 0 239 87 138,358 0 0 rio.public.temp0000287550 2 0 0 0 0 0 0 1,708 7 101,913 0 0 rio.public.temp0000287594 2 0 0 0 0 0 0 1,710 7 102,031 0 0 brasilia.public.temp0000237542 2 0 0 0 0 0 0 254 11 17,205 0 0 rio.public.temp0000287394 2 0 0 0 0 0 0 3,414 8 202,632 0 0 brasilia.public.temp0000237548 2 0 0 0 0 0 0 492 12 31,330 0 0 brasilia.public.temp0000237564 2 0 0 0 0 0 0 492 12 31,332 0 0 rio.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 123 38 69,608 5 10 rio.public.temp0000287570 1 0 0 0 0 0 0 8 5 1,292 0 0 rio.public.temp0000287598 1 0 0 0 0 0 0 8 5 1,279 0 0 brasilia.public.temp0000237582 1 0 0 0 0 0 0 247 6 15,727 0 0 brasilia.public.temp0000237514 1 0 0 0 0 0 0 246 6 15,651 0 0 brasilia.public.temp0000237578 1 0 0 0 0 0 0 8 5 1,541 0 0 brasilia.public.temp0000237532 1 0 0 0 0 0 0 246 6 15,654 0 0 rio.public.temp0000287588 1 0 0 0 0 0 0 1,706 4 101,257 0 0 brasilia.public.nf_entrada 1 1 0 0 0 0 0 154 66 167,236 6 8 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 164 3 17,981 0 0 contagem.public.temp0000226766 1 0 0 0 0 0 0 108 6 7,328 0 0 brasilia.public.lotes 1 1 0 0 0 0 0 1,234 865 2,900,601 59 1,714 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,253 5 154,584 0 0 Total 513 247 0 0 0 0 0 350,854 100,446 157,815,687 44,591 813,185 Vacuum throughput per table
Key values
- auditor.auditor_2026_08 (16.11) 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.53 rio.pg_catalog.pg_class 0 0 1.02 rio.pg_catalog.pg_type 0 0 0.38 brasilia.pg_catalog.pg_attribute 0 0 1.5 contagem.public.usuarios 0 0 0.01 rio.public.temp0000287574 0 0 1.11 rio.public.temp0000287312 0 0 0.22 rio.public.usuarios 0 0 3.28 brasilia.pg_catalog.pg_class 0 0 0.36 rio.public.temp0000287518 0 0 0.78 rio.pg_catalog.pg_index 0 0 0.27 rio.pg_catalog.pg_depend 0 0 0.94 brasilia.pg_catalog.pg_type 0 0 0.2 rio.public.temp0000287454 0 0 0.13 rio.public.temp0000287611 0 0 0.56 rio.public.temp0000287484 0 0 0.47 contagem.pg_catalog.pg_attribute 0 0 1.06 rio.public.tmp_drill_0175 0 0 0.06 brasilia.pg_catalog.pg_index 0 0 0.06 rio.public.temp0000287596 0 0 0.27 rio.public.tmp_drill_0320 0 0 0.19 brasilia.public.temp0000237522 0 0 0.13 rio.pg_catalog.pg_statistic 0 0 1.25 rio.public.temp0000287532 0 0 0.23 brasilia.pg_catalog.pg_depend 0 0 0.3 rio.public.temp0000287556 0 0 0.3 rio.public.temp0000287306 0 0 0.07 rio.public.temp0000287590 0 0 0.29 template1.pg_catalog.pg_shdepend 0 0 0.31 brasilia.public.temp0000237512 0 0 0.04 rio.public.temp0000287566 0 0 0.2 rio.public.temp0000287388 0 0 0.05 rio.pg_toast.pg_toast_2619 0 0 0.2 contagem.pg_catalog.pg_class 0 0 0.47 rio.public.temp0000287578 0 0 0.06 rio.auditor.auditor_2026_08 0 0 16.11 brasilia.public.temp0000237556 0 0 0.06 brasilia.pg_toast.pg_toast_2619 0 0 0.07 brasilia.pg_catalog.pg_statistic 0 0 0.41 brasilia.auditor.auditor_2026_08 0 0 4.09 contagem.pg_catalog.pg_type 0 0 0.17 postgres.pg_catalog.pg_shdepend 0 0 0.13 contagem.auditor.auditor_2026_08 0 0 2.52 rio.public.temp0000287592 0 0 0.05 contagem.pg_catalog.pg_depend 0 0 0.25 contagem.pg_catalog.pg_index 0 0 0.11 rio.public.temp0000287406 0 0 0.04 rio.public.temp0000287550 0 0 0.09 rio.public.temp0000287594 0 0 0.1 brasilia.public.temp0000237542 0 0 0.03 rio.public.temp0000287394 0 0 0.12 brasilia.public.temp0000237548 0 0 0.03 brasilia.public.temp0000237564 0 0 0.04 rio.pg_catalog.pg_shdepend 0 0 0.02 rio.public.temp0000287570 0 0 0.02 rio.public.temp0000287598 0 0 0.02 brasilia.public.temp0000237582 0 0 0.02 brasilia.public.temp0000237514 0 0 0.02 brasilia.public.temp0000237578 0 0 0.01 brasilia.public.temp0000237532 0 0 0.02 rio.public.temp0000287588 0 0 0.05 brasilia.public.nf_entrada 0 0 0.06 contagem.pg_toast.pg_toast_2619 0 0 0 contagem.public.temp0000226766 0 0 0.01 brasilia.public.lotes 0 0 0.42 contagem.pg_catalog.pg_statistic 0 0 0.05 Total 0 0 45.44 Tuples removed per table
Key values
- pg_catalog.pg_attribute (176462) Main table with removed tuples on database rio
- 473150 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 63 45 176,462 1,590,819 170,168 222 39,505 brasilia.pg_catalog.pg_attribute 25 21 101,160 546,800 21,804 130 14,293 rio.public.tmp_drill_0320 7 5 62,751 125,673 30,935 0 2,383 contagem.pg_catalog.pg_attribute 9 9 25,649 210,860 0 0 4,770 rio.public.tmp_drill_0175 9 5 23,041 31,240 2,492 0 741 rio.pg_catalog.pg_statistic 7 7 12,502 59,205 0 0 9,002 rio.pg_catalog.pg_depend 13 13 10,067 255,125 7,283 0 2,407 rio.pg_catalog.pg_type 35 23 8,830 89,959 10,218 4 2,557 brasilia.pg_catalog.pg_statistic 3 3 6,111 24,069 0 0 3,216 brasilia.pg_catalog.pg_type 11 11 5,225 24,397 0 27 779 template1.pg_catalog.pg_shdepend 5 5 4,559 68,645 805 0 595 rio.pg_catalog.pg_class 53 29 4,447 217,364 37,714 18 7,124 contagem.pg_catalog.pg_statistic 1 1 4,056 7,274 0 0 1,011 rio.pg_catalog.pg_index 14 14 3,529 27,500 548 0 774 brasilia.pg_catalog.pg_class 14 14 3,462 50,413 96 27 1,812 rio.auditor.auditor_2026_08 4 0 3,269 9,580,440 0 0 461,262 brasilia.pg_catalog.pg_index 8 8 3,006 15,067 0 11 424 brasilia.pg_catalog.pg_depend 6 6 2,418 107,597 0 27 1,053 postgres.pg_catalog.pg_shdepend 2 2 2,292 27,525 295 0 238 contagem.pg_catalog.pg_depend 2 2 1,854 37,711 0 14 338 brasilia.auditor.auditor_2026_08 3 0 1,651 1,759,744 0 0 79,028 contagem.public.usuarios 24 0 1,583 576 0 0 48 rio.pg_toast.pg_toast_2619 4 4 1,212 2,782 6 67 872 contagem.pg_catalog.pg_class 4 4 787 15,098 0 0 608 rio.pg_catalog.pg_shdepend 1 1 745 13,927 328 0 119 brasilia.public.nf_entrada 1 1 686 4,913 0 0 152 brasilia.public.lotes 1 1 524 97,941 0 0 1,367 contagem.pg_catalog.pg_index 2 2 305 3,791 0 14 92 rio.public.usuarios 14 4 298 10,627 3,501 2 230 brasilia.pg_toast.pg_toast_2619 3 3 290 417 0 13 180 contagem.pg_catalog.pg_type 3 3 235 6,739 0 10 177 contagem.pg_toast.pg_toast_2619 1 1 144 114 0 0 62 rio.public.temp0000287570 1 0 0 3,924 0 41 87 contagem.auditor.auditor_2026_08 2 0 0 935,989 0 0 45,331 brasilia.public.temp0000237556 3 0 0 9,534 0 54 714 rio.public.temp0000287484 9 0 0 216,322 0 0 15,552 brasilia.public.temp0000237512 4 0 0 12,702 0 72 952 rio.public.temp0000287566 4 0 0 96,172 0 0 6,912 rio.public.temp0000287532 6 0 0 82,361 0 158 5,410 rio.public.temp0000287598 1 0 0 1,147 0 63 65 rio.public.temp0000287388 4 0 0 22,301 0 74 502 brasilia.public.temp0000237582 1 0 0 3,181 0 17 239 rio.public.temp0000287592 2 0 0 25,131 0 0 1,792 brasilia.public.temp0000237522 7 0 0 22,233 0 126 1,666 rio.public.temp0000287306 5 0 0 27,110 0 29 611 brasilia.public.temp0000237514 1 0 0 3,176 0 18 238 brasilia.public.temp0000237578 1 0 0 3,178 0 18 238 rio.public.temp0000287454 10 0 0 43,342 0 246 970 rio.public.temp0000287406 2 0 0 10,017 0 97 223 rio.public.temp0000287590 5 0 0 120,272 0 0 8,640 brasilia.public.temp0000237532 1 0 0 3,177 0 18 238 rio.public.temp0000287556 6 0 0 144,183 0 0 10,368 rio.public.temp0000287550 2 0 0 48,044 0 0 3,456 rio.public.temp0000287588 1 0 0 24,049 0 0 1,728 rio.public.temp0000287611 10 0 0 240,607 0 0 17,280 rio.public.temp0000287594 2 0 0 48,103 0 0 3,456 contagem.public.temp0000226766 1 0 0 1,298 0 28 100 rio.public.temp0000287574 21 0 0 505,016 0 0 36,288 rio.public.temp0000287518 14 0 0 336,360 0 0 24,192 brasilia.public.temp0000237542 2 0 0 6,356 0 36 476 rio.public.temp0000287394 2 0 0 48,125 0 0 3,456 rio.public.temp0000287312 15 0 0 63,415 0 381 1,411 brasilia.public.temp0000237548 2 0 0 6,356 0 36 476 brasilia.public.temp0000237564 2 0 0 6,356 0 36 476 rio.public.temp0000287578 4 0 0 24,521 0 156 548 rio.public.temp0000287596 8 0 0 123,674 0 126 8,834 Total 513 247 473,150 18,282,084 286,193 2,416 840,144 Pages removed per table
Key values
- public.temp0000287312 (381) Main table with removed pages on database rio
- 2416 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000287312 15 0 0 381 rio.public.temp0000287454 10 0 0 246 rio.pg_catalog.pg_attribute 63 45 176462 222 rio.public.temp0000287532 6 0 0 158 rio.public.temp0000287578 4 0 0 156 brasilia.pg_catalog.pg_attribute 25 21 101160 130 brasilia.public.temp0000237522 7 0 0 126 rio.public.temp0000287596 8 0 0 126 rio.public.temp0000287406 2 0 0 97 rio.public.temp0000287388 4 0 0 74 brasilia.public.temp0000237512 4 0 0 72 rio.pg_toast.pg_toast_2619 4 4 1212 67 rio.public.temp0000287598 1 0 0 63 brasilia.public.temp0000237556 3 0 0 54 rio.public.temp0000287570 1 0 0 41 brasilia.public.temp0000237542 2 0 0 36 brasilia.public.temp0000237548 2 0 0 36 brasilia.public.temp0000237564 2 0 0 36 rio.public.temp0000287306 5 0 0 29 contagem.public.temp0000226766 1 0 0 28 brasilia.pg_catalog.pg_class 14 14 3462 27 brasilia.pg_catalog.pg_depend 6 6 2418 27 brasilia.pg_catalog.pg_type 11 11 5225 27 brasilia.public.temp0000237514 1 0 0 18 brasilia.public.temp0000237578 1 0 0 18 brasilia.public.temp0000237532 1 0 0 18 rio.pg_catalog.pg_class 53 29 4447 18 brasilia.public.temp0000237582 1 0 0 17 contagem.pg_catalog.pg_depend 2 2 1854 14 contagem.pg_catalog.pg_index 2 2 305 14 brasilia.pg_toast.pg_toast_2619 3 3 290 13 brasilia.pg_catalog.pg_index 8 8 3006 11 contagem.pg_catalog.pg_type 3 3 235 10 rio.pg_catalog.pg_type 35 23 8830 4 rio.public.usuarios 14 4 298 2 postgres.pg_catalog.pg_shdepend 2 2 2292 0 rio.pg_catalog.pg_shdepend 1 1 745 0 contagem.auditor.auditor_2026_08 2 0 0 0 rio.public.tmp_drill_0320 7 5 62751 0 rio.public.temp0000287484 9 0 0 0 rio.public.temp0000287566 4 0 0 0 brasilia.pg_catalog.pg_statistic 3 3 6111 0 rio.public.temp0000287592 2 0 0 0 brasilia.auditor.auditor_2026_08 3 0 1651 0 contagem.pg_catalog.pg_class 4 4 787 0 rio.pg_catalog.pg_depend 13 13 10067 0 rio.public.temp0000287590 5 0 0 0 rio.public.temp0000287556 6 0 0 0 rio.public.temp0000287550 2 0 0 0 rio.public.temp0000287588 1 0 0 0 brasilia.public.nf_entrada 1 1 686 0 rio.public.temp0000287611 10 0 0 0 rio.pg_catalog.pg_statistic 7 7 12502 0 template1.pg_catalog.pg_shdepend 5 5 4559 0 contagem.pg_toast.pg_toast_2619 1 1 144 0 rio.public.temp0000287594 2 0 0 0 contagem.pg_catalog.pg_attribute 9 9 25649 0 rio.public.temp0000287574 21 0 0 0 rio.public.temp0000287518 14 0 0 0 brasilia.public.lotes 1 1 524 0 contagem.pg_catalog.pg_statistic 1 1 4056 0 rio.pg_catalog.pg_index 14 14 3529 0 rio.public.temp0000287394 2 0 0 0 rio.public.tmp_drill_0175 9 5 23041 0 contagem.public.usuarios 24 0 1583 0 rio.auditor.auditor_2026_08 4 0 3269 0 Total 513 247 473,150 2,416 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 05 00 1 1 01 0 5 02 1 1 03 0 1 04 0 4 05 7 6 06 0 0 07 6 17 08 28 95 09 75 103 10 64 120 11 73 121 12 11 26 13 16 51 14 66 121 15 65 127 16 33 108 17 64 89 18 0 0 19 0 0 20 0 0 21 3 12 22 0 1 23 0 0 - 5.11 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 2 5m47s 2m21s 3m25s 2m53s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-05 15:08:41 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-05 15:47:37 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-05 00:05:33 Database: rio User: intelifix Remote: [local] Application: psql
2 2 2m52s 1s361ms 2m51s 1m26s select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028054, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-05 11:38:51 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028029, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-05 09:20:28 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028067, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-05 15:08:41 Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1 5s44ms 5s44ms 5s44ms 5s44ms select * from rs_resumo_tecnico1 (?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_RESUMO_TECNICO1 (06, 00, 00, 0310, 00, '2026-07-13', '2026-08-05', 00);
Date: 2026-08-05 11:01:10 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_TECNICO1 (06, 00, 00, 00, 00, '2026-08-05', '2026-08-05', 00);
Date: 2026-08-05 16:27:03 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_TECNICO1 (06, 00, 00, 00, 00, '2026-08-05', '2026-08-05', 00);
Date: 2026-08-05 15:42:47 Database: rio User: intelifix Remote: [local] Application: [unknown]
4 1 1s 1s 1s 1s drop table if exists temp0000287532;-
DROP TABLE IF EXISTS temp0000287532;
Date: 2026-08-05 10:24:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000287532;
Date: 2026-08-05 10:24:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 3m25s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-05 15:08:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 2m51s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028054, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-05 11:33:50 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 2m21s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-05 15:47:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 5s44ms SELECT * FROM RS_RESUMO_TECNICO1 (06, 00, 00, 00, 00, '2026-08-05', '2026-08-05', 00);[ Date: 2026-08-05 16:26:56 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 1s361ms 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-05 15:17:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 1s DROP TABLE IF EXISTS temp0000287532;[ Date: 2026-08-05 10:24:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,359 Total read queries
- 1,568 Total write queries
Queries by database
Key values
- rio Main database
- 4,109 Requests
- 6h54m52s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,299 Requests
User Request type Count Duration etiquetas Total 55 18s478ms select 55 18s478ms intelifix Total 6,299 8h56m30s copy to 417 42m41s ddl 1,151 44m57s others 543 53m55s select 4,188 6h34m56s lenon Total 116 59s732ms select 116 59s732ms Duration by user
Key values
- 8h56m30s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 55 18s478ms select 55 18s478ms intelifix Total 6,299 8h56m30s copy to 417 42m41s ddl 1,151 44m57s others 543 53m55s select 4,188 6h34m56s lenon Total 116 59s732ms select 116 59s732ms Queries by host
Key values
- [local] Main host
- 6,470 Requests
- 8h57m49s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,279 Requests
- 4h36m6s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-05 16:21:15 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,165 100-500ms duration
Slowest individual queries
Rank Duration Query 1 11m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-05 07:16:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 10m13s analyze verbose;[ Date: 2026-08-05 05:10:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-05 11:15:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 9m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-05 15:14:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 9m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-05 09:14:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 9m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-05 16:14:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-05 10:13:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-05 20:13:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 8m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-05 17:13:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 8m SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028054, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-05 11:38:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 7m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-05 12:12:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 7m25s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028029, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-05 09:20:28 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 7m18s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028067, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-05 15:08:41 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 7m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-05 14:12:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 6m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-05 18:11:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 6m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-05 13:11:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 6m14s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028030, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-05 09:30:17 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 6m7s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028072, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-05 15:40:36 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 6m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-05 08:11:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-05 22:10:56 - 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 2h15m19s 48 1s348ms 11m12s 2m49s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 05 07 3 11m54s 3m58s 08 3 6m22s 2m7s 09 3 10m21s 3m27s 10 3 9m39s 3m13s 11 3 10m39s 3m33s 12 3 7m58s 2m39s 13 3 6m42s 2m14s 14 3 7m30s 2m30s 15 3 10m59s 3m39s 16 3 10m11s 3m23s 17 3 8m42s 2m54s 18 3 6m54s 2m18s 19 3 5m59s 1m59s 20 3 9m1s 3m 21 3 6m10s 2m3s 22 3 6m12s 2m4s [ User: intelifix - Total duration: 2h15m19s - Times executed: 48 ]
[ Application: psql - Total duration: 2h15m19s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-05 07:16:14 Duration: 11m12s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-05 11:15:00 Duration: 9m58s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-05 15:14:57 Duration: 9m55s Database: rio User: intelifix Remote: [local] Application: psql
2 2h4m38s 312 152ms 8m 23s969ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 05 07 6 6m4s 1m 08 14 5m31s 23s679ms 09 31 19m56s 38s586ms 10 37 19m41s 31s930ms 11 46 28m57s 37s772ms 12 10 1m6s 6s662ms 13 27 1m12s 2s671ms 14 29 6m1s 12s460ms 15 42 27m49s 39s738ms 16 36 1m53s 3s153ms 17 34 6m24s 11s311ms [ User: intelifix - Total duration: 2h4m38s - Times executed: 312 ]
[ Application: [unknown] - Total duration: 2h4m38s - Times executed: 312 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028054, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-05 11:38:51 Duration: 8m Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028029, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-05 09:20:28 Duration: 7m25s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028067, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-05 15:08:41 Duration: 7m18s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h19m44s 48 206ms 5m5s 1m39s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 05 07 3 5m20s 1m46s 08 3 4m10s 1m23s 09 3 6m28s 2m9s 10 3 6m7s 2m2s 11 3 5m56s 1m58s 12 3 4m40s 1m33s 13 3 4m52s 1m37s 14 3 4m26s 1m28s 15 3 6m26s 2m8s 16 3 5m 1m40s 17 3 5m26s 1m48s 18 3 3m57s 1m19s 19 3 3m52s 1m17s 20 3 4m44s 1m34s 21 3 4m2s 1m20s 22 3 4m11s 1m23s [ User: intelifix - Total duration: 1h19m44s - Times executed: 48 ]
[ Application: psql - Total duration: 1h19m44s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-05 15:22:01 Duration: 5m5s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-05 09:21:42 Duration: 4m53s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-05 10:20:35 Duration: 4m29s Database: brasilia User: intelifix Remote: [local] Application: psql
4 21m15s 1,350 150ms 7s806ms 944ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 05 07 14 5s585ms 398ms 08 93 1m14s 804ms 09 125 2m1s 972ms 10 155 2m14s 868ms 11 147 2m22s 968ms 12 28 25s22ms 893ms 13 96 2m4s 1s301ms 14 188 3m27s 1s104ms 15 213 3m12s 902ms 16 218 3m8s 863ms 17 73 58s529ms 801ms [ User: intelifix - Total duration: 21m15s - Times executed: 1350 ]
[ Application: [unknown] - Total duration: 21m15s - Times executed: 1350 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (50188, 407, '270911029126105008,229690211921,229866089007,229690854565,216944803440,229662942638,229811300215,229670488289,229805223437,229808947481,229685284762,229669699111,229813786068,229808843656,229747733640,229728456977,229934150723,229810604557,216944305860,229781785459,229782439192,229733715762,216940420409,216936655877,229807413449,229781832838,229669200825,229690868203,229781830919,216944595159,229837120120,229933515778,229808084962,229810947474,229816608701,229749232945,216939545362,229879716161,229740188593,229782716874,229738239717,229778939817,229660299191,229737081434,229807404963,229668723348,229751500215,229782330822,229934078997,229805501119,216938846169', '246513952341,246653349817,246516999999,246468021315,246490773737,246630355676,246513610613,246592888507,246618195050,246518625052,246515344160,246627182123,246612968288,246548274242,246546213132,246171838996,246640393345,246468166985,246602355760,246072966171,246526719905,246463981931,246462239213,246619552950,246586965459,246512915258,246513539517,246586979804,246456917088,246640091318,246482026688,246618305364,246640372030,246628893850,246548951537,246473874355,246652307481,246529974151,246598768800,246570479709,246571400013,246488641734,246529339712,246581372142,246515752438,246533105354,246599145559,246040882143,246596189906,246464293959', 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":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-05 15:07:23 Duration: 7s806ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (274076, 304, '863400535703109,241746489308,241778781820,241744752427,241778755880,241778766363,241744527477,241778762727,241744731112,241742809611,241742832644,241759932730,241778768181,241759948892,241759831834,241744759194,241744754144', '',0464,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-05 13:41:54 Duration: 5s931ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (274258, 404, '834136920000323,241601098901,241677675970,241666810915,241691064460,241712062020,241701239011,241607791833,241712186880,241674511431,241672950224,241649102026,241656736878,241680316991,241669493556,241597318789,241610111431,241707336676,241726780000,241655002546,241688952638,241677678293,241651359091,241665851517,241601526170,241639160809,230048067597,241597319698,230040233152,241674599092,241670193658,241653136684,241629255072,241674541434,241639147395', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-05 13:55:12 Duration: 5s550ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 18m3s 3 2m50s 10m13s 6m1s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 05 05 3 18m3s 6m1s [ User: intelifix - Total duration: 18m3s - Times executed: 3 ]
[ Application: psql - Total duration: 18m3s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-05 05:10:14 Duration: 10m13s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-05 05:15:14 Duration: 4m59s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-05 05:18:04 Duration: 2m50s Database: contagem User: intelifix Remote: [local] Application: psql
6 16m27s 274 198ms 3m31s 3s603ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 05 00 12 37s821ms 3s151ms 01 12 23s512ms 1s959ms 02 12 22s771ms 1s897ms 03 12 24s652ms 2s54ms 04 12 24s345ms 2s28ms 05 12 25s359ms 2s113ms 06 12 22s421ms 1s868ms 07 12 23s159ms 1s929ms 08 12 25s554ms 2s129ms 09 12 27s86ms 2s257ms 10 11 25s391ms 2s308ms 11 12 27s15ms 2s251ms 12 11 24s598ms 2s236ms 13 12 28s146ms 2s345ms 14 12 26s180ms 2s181ms 15 12 6m21s 31s816ms 16 12 33s850ms 2s820ms 17 12 30s76ms 2s506ms 18 12 28s906ms 2s408ms 19 12 26s291ms 2s190ms 20 12 46s796ms 3s899ms 21 12 25s851ms 2s154ms 22 12 25s689ms 2s140ms [ User: intelifix - Total duration: 16m27s - Times executed: 274 ]
[ Application: psql - Total duration: 16m27s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-05 15:08:41 Duration: 3m31s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-05 15:47:37 Duration: 2m28s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-05 00:05:33 Duration: 16s208ms Database: rio User: intelifix Remote: [local] Application: psql
7 10m15s 161 158ms 15s482ms 3s825ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 05 00 6 29s993ms 4s998ms 01 5 14s751ms 2s950ms 02 5 11s244ms 2s248ms 03 5 16s753ms 3s350ms 04 6 15s985ms 2s664ms 05 6 13s985ms 2s330ms 07 9 39s302ms 4s366ms 08 12 59s284ms 4s940ms 09 12 1m 5s47ms 10 11 51s86ms 4s644ms 11 12 57s318ms 4s776ms 12 12 45s678ms 3s806ms 13 9 11s539ms 1s282ms 14 11 50s346ms 4s576ms 15 12 58s914ms 4s909ms 16 9 33s390ms 3s710ms 17 6 9s528ms 1s588ms 20 1 158ms 158ms 21 6 19s202ms 3s200ms 22 6 16s889ms 2s814ms [ User: intelifix - Total duration: 10m15s - Times executed: 161 ]
[ Application: psql - Total duration: 10m15s - Times executed: 161 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-05 00:05:17 Duration: 15s482ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-05 14:25:14 Duration: 13s247ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-05 08:15:13 Duration: 12s121ms Database: rio User: intelifix Remote: [local] Application: psql
8 9m54s 913 151ms 4s325ms 650ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 05 07 38 19s11ms 500ms 08 127 1m24s 667ms 09 112 1m25s 765ms 10 128 1m48s 846ms 11 129 1m12s 565ms 12 10 5s519ms 551ms 13 70 36s855ms 526ms 14 112 1m 541ms 15 68 45s900ms 675ms 16 92 57s171ms 621ms 17 27 17s316ms 641ms [ User: intelifix - Total duration: 9m54s - Times executed: 913 ]
[ Application: [unknown] - Total duration: 9m54s - Times executed: 913 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "274621", "modelo" : "320", "itens" : "241670173959,241670389109,241693210809,241615240203,241676314659,241664708890,241595784252,835092914003549,241671561031,241696837088,241704375871,241656661013,241732668497,241666087880,241676348400,241692863042,241713735561,241637576972,241712553740,241695599100,241726947591,241715701534,241713731622,241710321424,241694717285,241691107090,241676390425,241691055671,241663094345,241695549903,241728699805,241605377881,241618251013,241698659006,241672922544,241714937182,241699201517,241648766785,241610021624,241607829412,241708831941,241601563043,241609927900,241732686580,241661145569,241602608991,241653136482,241676585168", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-05 16:55:06 Duration: 4s325ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "274272", "modelo" : "141", "itens" : "229690420505,216937000715,229815933955,229686085558,229665003041,216943097594,229779939701,229737989311,229666115360,229781545054,229672999702,229750684444,229865451111,229738547580,216944894964,229810696889,229752849504,229666815462,229661595267,229665404752,229735089600,229686069192,229749117579,229785235762,229735195166,229783254155,229780090222,229740366063", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246524701123,246475689099,246628472945,246499545154,246509695157,246493520527,246570948801,246527942539,246496347580,246583756672,246514173451,246562867282,246652632542,246557938282,246489078498,246641349611,246563232324,246472147272,246489614870,246469743649,246547890109,246501645359,246563271015,246599940924,246547850509,246585264362,246557011515,246529376180,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-05 09:44:23 Duration: 3s463ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "274159", "modelo" : "464", "itens" : "241745304355,241814084154,241776314149,241762580419,241764703858,241764801219,241772386066,863400609104995,241772670113,241770587383,241761344046,241762819207,241738847888,241742122541,241747697596,241739479903,241762215253,241740610508,241742251925,241779225757,241738656276,241748122644,241769540627,241766244659,241738454764,241687233536,241738954768,241743960723,241769946378,241770592839,241766278400,241741194156,241748107187,241687289703,241740711225,241745552741,241764882944,241779111224,241778793841,241815587779,241763371921,241768726775,241765515261,241738532729,241746634350,241772621623,241739165776,241770015880,241759890527,241765236468,241764900724,241747619710,241759696264,241778858998,241743472336,241746019610,241812733248,241743758200,241769660818,241743997190", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-05 10:05:52 Duration: 3s322ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 8m35s 41 9s698ms 55s619ms 12s578ms create table temp0000287518 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 05 07 11 2m40s 14s594ms 08 3 33s719ms 11s239ms 09 9 1m49s 12s215ms 10 12 2m24s 12s63ms 11 6 1m6s 11s123ms [ User: intelifix - Total duration: 8m35s - Times executed: 41 ]
[ Application: [unknown] - Total duration: 8m35s - Times executed: 41 ]
-
CREATE TABLE temp0000287518 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 07:17:51 Duration: 55s619ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287518 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 09:12:42 Duration: 14s490ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287518 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 09:12:20 Duration: 14s4ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 5m48s 30 9s909ms 13s695ms 11s631ms create table temp0000287574 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 05 11 7 1m20s 11s564ms 12 5 52s944ms 10s588ms 13 1 11s232ms 11s232ms 14 12 2m19s 11s594ms 15 5 1m4s 12s937ms [ User: intelifix - Total duration: 5m48s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 5m48s - Times executed: 30 ]
-
CREATE TABLE temp0000287574 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 15:19:44 Duration: 13s695ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287574 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 15:11:45 Duration: 13s323ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287574 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 15:12:15 Duration: 12s949ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 4m13s 55 1s734ms 15s584ms 4s603ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 05 07 3 7s924ms 2s641ms 08 2 15s901ms 7s950ms 09 4 15s105ms 3s776ms 10 7 32s44ms 4s577ms 11 1 2s210ms 2s210ms 12 1 2s584ms 2s584ms 13 2 12s432ms 6s216ms 14 5 22s436ms 4s487ms 15 10 52s147ms 5s214ms 16 12 53s934ms 4s494ms 17 8 36s458ms 4s557ms [ User: intelifix - Total duration: 4m13s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 4m13s - Times executed: 55 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-05', 0302, '', '', 0, 6, '2026-08-05');
Date: 2026-08-05 10:30:11 Duration: 15s584ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-05', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-05 15:33:13 Duration: 14s353ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-05', 0302, '', '', 0, 6, '2026-08-05');
Date: 2026-08-05 14:45:48 Duration: 13s358ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 3m32s 59 2s863ms 8s626ms 3s603ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 05 08 3 12s119ms 4s39ms 09 4 14s146ms 3s536ms 10 3 11s38ms 3s679ms 11 5 18s189ms 3s637ms 12 4 14s110ms 3s527ms 13 4 12s831ms 3s207ms 14 5 17s732ms 3s546ms 15 4 19s422ms 4s855ms 16 4 13s111ms 3s277ms 17 3 10s198ms 3s399ms 18 4 14s104ms 3s526ms 19 4 13s353ms 3s338ms 20 4 14s595ms 3s648ms 21 4 13s667ms 3s416ms 22 4 14s 3s500ms [ User: intelifix - Total duration: 3m32s - Times executed: 59 ]
[ Application: psql - Total duration: 3m32s - Times executed: 59 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-05 15:00:10 Duration: 8s626ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-05 08:00:10 Duration: 4s918ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-05 11:00:09 Duration: 4s858ms Database: brasilia User: intelifix Remote: [local] Application: psql
13 3m15s 13 9s884ms 1m 15s35ms create table temp0000287611 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 05 16 1 1m 1m 17 12 2m14s 11s232ms [ User: intelifix - Total duration: 3m15s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 3m15s - Times executed: 13 ]
-
CREATE TABLE temp0000287611 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 16:54:57 Duration: 1m Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287611 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 17:30:56 Duration: 13s77ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287611 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 17:38:46 Duration: 12s273ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 2m58s 4 4s396ms 1m25s 44s727ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 05 20 2 1m30s 45s30ms 23 2 1m28s 44s425ms [ User: intelifix - Total duration: 2m58s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m58s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-05 20:08:37 Duration: 1m25s 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-05 23:16:38 Duration: 1m24s 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-05 20:10:29 Duration: 4s568ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 2m55s 56 204ms 33s631ms 3s132ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 05 07 4 2s268ms 567ms 08 1 684ms 684ms 09 4 29s975ms 7s493ms 10 19 8s66ms 424ms 11 7 21s230ms 3s32ms 12 2 4s294ms 2s147ms 14 7 1m2s 8s980ms 15 7 27s937ms 3s991ms 17 5 18s80ms 3s616ms [ User: intelifix - Total duration: 2m55s - Times executed: 56 ]
[ Application: psql - Total duration: 2m55s - Times executed: 56 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028063);
Date: 2026-08-05 14:34:50 Duration: 33s631ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028028);
Date: 2026-08-05 09:06:03 Duration: 27s73ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028069);
Date: 2026-08-05 15:18:22 Duration: 15s547ms Database: rio User: intelifix Remote: [local] Application: psql
16 2m53s 14 9s998ms 13s861ms 12s358ms create table temp0000287596 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 05 14 3 36s827ms 12s275ms 15 11 2m16s 12s381ms [ User: intelifix - Total duration: 2m53s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 2m53s - Times executed: 14 ]
-
CREATE TABLE temp0000287596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 15:33:47 Duration: 13s861ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 15:01:18 Duration: 13s740ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 15:42:15 Duration: 13s623ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 2m44s 38 157ms 34s177ms 4s321ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 05 07 2 25s865ms 12s932ms 08 3 4s276ms 1s425ms 09 5 31s608ms 6s321ms 10 10 22s111ms 2s211ms 11 5 13s737ms 2s747ms 14 3 9s328ms 3s109ms 15 5 54s223ms 10s844ms 17 5 3s65ms 613ms [ User: intelifix - Total duration: 2m44s - Times executed: 38 ]
[ Application: psql - Total duration: 2m44s - Times executed: 38 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028067);
Date: 2026-08-05 15:01:24 Duration: 34s177ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028026);
Date: 2026-08-05 07:40:07 Duration: 21s831ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028029);
Date: 2026-08-05 09:12:45 Duration: 16s930ms Database: rio User: intelifix Remote: [local] Application: psql
18 2m43s 14 10s324ms 13s1ms 11s683ms create table temp0000287532 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 05 10 14 2m43s 11s683ms [ User: intelifix - Total duration: 2m43s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 2m43s - Times executed: 14 ]
-
CREATE TABLE temp0000287532 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 10:29:06 Duration: 13s1ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287532 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 10:24:34 Duration: 12s416ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287532 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 10:19:10 Duration: 12s288ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 2m33s 13 10s889ms 12s840ms 11s828ms create table temp0000287556 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 05 10 10 1m58s 11s873ms 11 3 35s38ms 11s679ms [ User: intelifix - Total duration: 2m33s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m33s - Times executed: 13 ]
-
CREATE TABLE temp0000287556 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 11:18:09 Duration: 12s840ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287556 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 10:05:52 Duration: 12s700ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287556 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 10:06:08 Duration: 12s562ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 2m11s 1 2m11s 2m11s 2m11s select * from rs_resumo_defeitos (?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 05 16 1 2m11s 2m11s [ User: intelifix - Total duration: 2m11s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 2m11s - Times executed: 1 ]
-
SELECT * FROM RS_RESUMO_DEFEITOS (01, 00);
Date: 2026-08-05 16:25:50 Duration: 2m11s Database: rio User: intelifix Remote: [local] Application: [unknown]
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,350 21m15s 150ms 7s806ms 944ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 05 07 14 5s585ms 398ms 08 93 1m14s 804ms 09 125 2m1s 972ms 10 155 2m14s 868ms 11 147 2m22s 968ms 12 28 25s22ms 893ms 13 96 2m4s 1s301ms 14 188 3m27s 1s104ms 15 213 3m12s 902ms 16 218 3m8s 863ms 17 73 58s529ms 801ms [ User: intelifix - Total duration: 21m15s - Times executed: 1350 ]
[ Application: [unknown] - Total duration: 21m15s - Times executed: 1350 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (50188, 407, '270911029126105008,229690211921,229866089007,229690854565,216944803440,229662942638,229811300215,229670488289,229805223437,229808947481,229685284762,229669699111,229813786068,229808843656,229747733640,229728456977,229934150723,229810604557,216944305860,229781785459,229782439192,229733715762,216940420409,216936655877,229807413449,229781832838,229669200825,229690868203,229781830919,216944595159,229837120120,229933515778,229808084962,229810947474,229816608701,229749232945,216939545362,229879716161,229740188593,229782716874,229738239717,229778939817,229660299191,229737081434,229807404963,229668723348,229751500215,229782330822,229934078997,229805501119,216938846169', '246513952341,246653349817,246516999999,246468021315,246490773737,246630355676,246513610613,246592888507,246618195050,246518625052,246515344160,246627182123,246612968288,246548274242,246546213132,246171838996,246640393345,246468166985,246602355760,246072966171,246526719905,246463981931,246462239213,246619552950,246586965459,246512915258,246513539517,246586979804,246456917088,246640091318,246482026688,246618305364,246640372030,246628893850,246548951537,246473874355,246652307481,246529974151,246598768800,246570479709,246571400013,246488641734,246529339712,246581372142,246515752438,246533105354,246599145559,246040882143,246596189906,246464293959', 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":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-05 15:07:23 Duration: 7s806ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (274076, 304, '863400535703109,241746489308,241778781820,241744752427,241778755880,241778766363,241744527477,241778762727,241744731112,241742809611,241742832644,241759932730,241778768181,241759948892,241759831834,241744759194,241744754144', '',0464,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-05 13:41:54 Duration: 5s931ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (274258, 404, '834136920000323,241601098901,241677675970,241666810915,241691064460,241712062020,241701239011,241607791833,241712186880,241674511431,241672950224,241649102026,241656736878,241680316991,241669493556,241597318789,241610111431,241707336676,241726780000,241655002546,241688952638,241677678293,241651359091,241665851517,241601526170,241639160809,230048067597,241597319698,230040233152,241674599092,241670193658,241653136684,241629255072,241674541434,241639147395', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-05 13:55:12 Duration: 5s550ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 913 9m54s 151ms 4s325ms 650ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 05 07 38 19s11ms 500ms 08 127 1m24s 667ms 09 112 1m25s 765ms 10 128 1m48s 846ms 11 129 1m12s 565ms 12 10 5s519ms 551ms 13 70 36s855ms 526ms 14 112 1m 541ms 15 68 45s900ms 675ms 16 92 57s171ms 621ms 17 27 17s316ms 641ms [ User: intelifix - Total duration: 9m54s - Times executed: 913 ]
[ Application: [unknown] - Total duration: 9m54s - Times executed: 913 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "274621", "modelo" : "320", "itens" : "241670173959,241670389109,241693210809,241615240203,241676314659,241664708890,241595784252,835092914003549,241671561031,241696837088,241704375871,241656661013,241732668497,241666087880,241676348400,241692863042,241713735561,241637576972,241712553740,241695599100,241726947591,241715701534,241713731622,241710321424,241694717285,241691107090,241676390425,241691055671,241663094345,241695549903,241728699805,241605377881,241618251013,241698659006,241672922544,241714937182,241699201517,241648766785,241610021624,241607829412,241708831941,241601563043,241609927900,241732686580,241661145569,241602608991,241653136482,241676585168", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-05 16:55:06 Duration: 4s325ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "274272", "modelo" : "141", "itens" : "229690420505,216937000715,229815933955,229686085558,229665003041,216943097594,229779939701,229737989311,229666115360,229781545054,229672999702,229750684444,229865451111,229738547580,216944894964,229810696889,229752849504,229666815462,229661595267,229665404752,229735089600,229686069192,229749117579,229785235762,229735195166,229783254155,229780090222,229740366063", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246524701123,246475689099,246628472945,246499545154,246509695157,246493520527,246570948801,246527942539,246496347580,246583756672,246514173451,246562867282,246652632542,246557938282,246489078498,246641349611,246563232324,246472147272,246489614870,246469743649,246547890109,246501645359,246563271015,246599940924,246547850509,246585264362,246557011515,246529376180,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-05 09:44:23 Duration: 3s463ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "274159", "modelo" : "464", "itens" : "241745304355,241814084154,241776314149,241762580419,241764703858,241764801219,241772386066,863400609104995,241772670113,241770587383,241761344046,241762819207,241738847888,241742122541,241747697596,241739479903,241762215253,241740610508,241742251925,241779225757,241738656276,241748122644,241769540627,241766244659,241738454764,241687233536,241738954768,241743960723,241769946378,241770592839,241766278400,241741194156,241748107187,241687289703,241740711225,241745552741,241764882944,241779111224,241778793841,241815587779,241763371921,241768726775,241765515261,241738532729,241746634350,241772621623,241739165776,241770015880,241759890527,241765236468,241764900724,241747619710,241759696264,241778858998,241743472336,241746019610,241812733248,241743758200,241769660818,241743997190", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-05 10:05:52 Duration: 3s322ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 312 2h4m38s 152ms 8m 23s969ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 05 07 6 6m4s 1m 08 14 5m31s 23s679ms 09 31 19m56s 38s586ms 10 37 19m41s 31s930ms 11 46 28m57s 37s772ms 12 10 1m6s 6s662ms 13 27 1m12s 2s671ms 14 29 6m1s 12s460ms 15 42 27m49s 39s738ms 16 36 1m53s 3s153ms 17 34 6m24s 11s311ms [ User: intelifix - Total duration: 2h4m38s - Times executed: 312 ]
[ Application: [unknown] - Total duration: 2h4m38s - Times executed: 312 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028054, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-05 11:38:51 Duration: 8m Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028029, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-05 09:20:28 Duration: 7m25s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028067, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-05 15:08:41 Duration: 7m18s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 274 16m27s 198ms 3m31s 3s603ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 05 00 12 37s821ms 3s151ms 01 12 23s512ms 1s959ms 02 12 22s771ms 1s897ms 03 12 24s652ms 2s54ms 04 12 24s345ms 2s28ms 05 12 25s359ms 2s113ms 06 12 22s421ms 1s868ms 07 12 23s159ms 1s929ms 08 12 25s554ms 2s129ms 09 12 27s86ms 2s257ms 10 11 25s391ms 2s308ms 11 12 27s15ms 2s251ms 12 11 24s598ms 2s236ms 13 12 28s146ms 2s345ms 14 12 26s180ms 2s181ms 15 12 6m21s 31s816ms 16 12 33s850ms 2s820ms 17 12 30s76ms 2s506ms 18 12 28s906ms 2s408ms 19 12 26s291ms 2s190ms 20 12 46s796ms 3s899ms 21 12 25s851ms 2s154ms 22 12 25s689ms 2s140ms [ User: intelifix - Total duration: 16m27s - Times executed: 274 ]
[ Application: psql - Total duration: 16m27s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-05 15:08:41 Duration: 3m31s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-05 15:47:37 Duration: 2m28s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-05 00:05:33 Duration: 16s208ms Database: rio User: intelifix Remote: [local] Application: psql
5 179 1m35s 150ms 1s899ms 535ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 05 16 62 43s641ms 703ms 17 117 52s162ms 445ms [ User: intelifix - Total duration: 1m35s - Times executed: 179 ]
[ Application: [unknown] - Total duration: 1m35s - Times executed: 179 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"48103","seriais":"229781486990,229933963555,22969152890","usuario":"419","observacao":""}');
Date: 2026-08-05 16:21:18 Duration: 1s899ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"51323","seriais":"230044973345,230037509798,229988166375,230025409303,230042191929,229971845669,230014484769,229990897180,230034037395,230030278296,230037656682,230035452730,230006030308,230006315464,230036894251,230045113942,230042887282,229964916373,230006732935,229975027685,230031574046,230030633842,230006702124,230030408589,230045119295,230028688905,230053261225,230030484860,229985963456,230018951928,229977646583,230047582040,229981788907,230030567595,230051359501,230014803947,230036894554,229971773339","usuario":"419","observacao":""}');
Date: 2026-08-05 17:26:44 Duration: 1s556ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"48103","seriais":"229701397793,229836043336,229645395661,229674828286,229711259912,229699956777,216928284151,229778128087,229728734659,216928721119,229643809097,229702417881,229699553854,229699862728,229792217487,229763486479,229776155976,229833650320,229765144262,229826071836,216928130624,229706414254,229705184549,229834600525,229703670822,229676209600,229767017474,229767560009,216923770120,229677911630,229700592732,229646001636","usuario":"419","observacao":""}');
Date: 2026-08-05 16:23:57 Duration: 1s344ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
6 174 41s994ms 150ms 755ms 241ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 05 01 18 4s128ms 229ms 04 13 2s669ms 205ms 05 5 1s299ms 259ms 07 12 3s91ms 257ms 08 11 2s456ms 223ms 09 15 3s481ms 232ms 10 18 4s627ms 257ms 11 17 4s26ms 236ms 12 16 3s542ms 221ms 14 10 2s442ms 244ms 15 27 6s975ms 258ms 16 10 2s806ms 280ms 17 2 444ms 222ms [ User: intelifix - Total duration: 41s994ms - Times executed: 174 ]
[ Application: [unknown] - Total duration: 41s994ms - Times executed: 174 ]
-
SELECT * FROM RS_TRIAGEM (310, 5, '95', 2, 'ECA81F6C824C,484BD4B5433C,484BD4A75124,C4509CEEB9A4,3C82C091F338,ECA81F1F78DC,C4509CF3B0FC,B85E710B26B4,B85E71D3C41C,00CB7AE168E4,B85E71D1AC68,B85E71EE258C,B85E71DAB808,B85E71DAADF4,4075C39C5314,4075C3B93B64,400FC17F8EE4,B85E71DFB59C,4075C3BAB070,B85E71EB2724,B85E71D37E08,E4BFFAEFE3C4,3C82C0C5280C,B85E71ED2330,B85E71C5B64C,B85E71D28084,F8D2AC15303C,08A7C07122D4,F8D2AC16424C,B85E71DABE5C,00CB7ADC4184,484BD4A57844,1C9D726A3FB4,B85E71C6D8D8,B85E71CFCA24,3C82C0CF9724,B85E71D3778C,F8D2ACC97220,F8D2AC15150C,C4509CE822CC,4075C3BAE4F0,B85E71DB1050,B85E710AF734,3C82C0C52140,484BD48B5F74,B85E71C5F3C8,C4509CE87744,B85E71E544BC,484BD49771BC,B85E71C8B964,B85E71D9DAA0', NULL, NULL, 0185, 00);
Date: 2026-08-05 16:43:05 Duration: 755ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '229813848195,216936489092,229691101335,229806567901,229752525050,229666447087,229751271932,216941329598,229865539705,216943290824', NULL, NULL, 0141, 00);
Date: 2026-08-05 10:14:56 Duration: 504ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '229684668406,229865173654,229691632026,229810919717,229816886382,216932466781,229673292537,216944951536,229812934156,229743457891,229685820606,216937336987,229925382033,229934208304', NULL, NULL, 0141, 00);
Date: 2026-08-05 15:26:01 Duration: 464ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 161 10m15s 158ms 15s482ms 3s825ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 05 00 6 29s993ms 4s998ms 01 5 14s751ms 2s950ms 02 5 11s244ms 2s248ms 03 5 16s753ms 3s350ms 04 6 15s985ms 2s664ms 05 6 13s985ms 2s330ms 07 9 39s302ms 4s366ms 08 12 59s284ms 4s940ms 09 12 1m 5s47ms 10 11 51s86ms 4s644ms 11 12 57s318ms 4s776ms 12 12 45s678ms 3s806ms 13 9 11s539ms 1s282ms 14 11 50s346ms 4s576ms 15 12 58s914ms 4s909ms 16 9 33s390ms 3s710ms 17 6 9s528ms 1s588ms 20 1 158ms 158ms 21 6 19s202ms 3s200ms 22 6 16s889ms 2s814ms [ User: intelifix - Total duration: 10m15s - Times executed: 161 ]
[ Application: psql - Total duration: 10m15s - Times executed: 161 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-05 00:05:17 Duration: 15s482ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-05 14:25:14 Duration: 13s247ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-05 08:15:13 Duration: 12s121ms Database: rio User: intelifix Remote: [local] Application: psql
8 127 51s980ms 150ms 705ms 409ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 05 07 3 1s343ms 447ms 08 11 4s460ms 405ms 09 18 7s179ms 398ms 10 16 6s495ms 405ms 11 15 5s778ms 385ms 12 7 2s573ms 367ms 13 4 1s679ms 419ms 14 11 4s997ms 454ms 15 19 7s918ms 416ms 16 4 1s912ms 478ms 17 19 7s642ms 402ms [ User: intelifix - Total duration: 51s980ms - Times executed: 127 ]
[ Application: [unknown] - Total duration: 51s980ms - Times executed: 127 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-05 15:11:01 Duration: 705ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 073;
Date: 2026-08-05 13:21:22 Duration: 666ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-08-05 14:27:45 Duration: 655ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 110 49s632ms 266ms 791ms 451ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 05 00 1 422ms 422ms 01 1 462ms 462ms 02 2 954ms 477ms 03 1 494ms 494ms 04 2 716ms 358ms 05 2 1s128ms 564ms 07 6 2s223ms 370ms 08 8 3s701ms 462ms 09 11 5s327ms 484ms 10 12 5s123ms 426ms 11 10 4s419ms 441ms 12 3 1s203ms 401ms 13 11 5s473ms 497ms 14 7 3s266ms 466ms 15 13 6s150ms 473ms 16 10 4s815ms 481ms 17 6 2s199ms 366ms 21 3 1s180ms 393ms 22 1 368ms 368ms [ User: lenon - Total duration: 49s632ms - Times executed: 110 ]
[ Application: [unknown] - Total duration: 49s632ms - Times executed: 110 ]
-
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-05 14:19:43 Duration: 791ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-05 09:05:59 Duration: 745ms 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-05 08:47:52 Duration: 742ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
10 102 1m2s 151ms 1s868ms 613ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 05 08 14 7s916ms 565ms 09 7 5s370ms 767ms 10 18 8s253ms 458ms 11 13 7s318ms 562ms 14 10 7s806ms 780ms 15 18 11s102ms 616ms 16 13 9s349ms 719ms 17 9 5s460ms 606ms [ User: intelifix - Total duration: 1m2s - Times executed: 102 ]
[ Application: [unknown] - Total duration: 1m2s - Times executed: 102 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '229967349494,230053933546,229990258498,230022138590,229974559806,230035509199,230011990508,230030092645,229962929917,229986632242,230007023749,229986039703,230045136873,230045030725,229972053647,229966617392,229970572122,230034385162,229982179809,229980287480,230033960419,229971515154,229962864052,230006003537,229981252435,230028777375,229976737998,229990035570,229981172326,229981604141,230051075455,230044066982,229978017281,229977055358,229989000711,229973262946,229965946889,229988506161,230052800316,230052312232,230021040112,230021082237,230053807091,229966324659,230010160812,230053249203,229975746173,230032527180,230005836775,230047032031,230029335567,230014644964,230009956672,230014704061,230049534149,230055449394,230041243138,229975114664,229991193753,230051485978,230043900323,230043910324,230011393042', '','DEFAULT',051,0295,'', '','', 00);
Date: 2026-08-05 16:37:42 Duration: 1s868ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '229973952845,229988537578,229971226181,230014448705,230035461216,230031515252,230035250511,229977567787,229988650015,230053952538,230011213350,229990626671,230011243050,229982773436,230008159202,229963379411,230021426063,229977501418,229981763248,230037975759,230026258083,230053773654,230041290315,229982223551,229991251739,230026112335,230028254665,230028620414,230043980712,230014616678,229973612026,229982147886,230025231228,230045336163,229976140410,229972015259,229963645273,230025978809,230050997187,230030446876,230033962439,229991456685', '','DEFAULT',056,0295,'', '','', 00);
Date: 2026-08-05 09:29:48 Duration: 1s775ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '241606108289,241661100717,241656735464,241734080118,241636132040,241688968093,241639180407,241693141835,241656750315,241618208708,241594527698,241712775860,241654643644,241658984045,241703819598,241710876685,241659664448,241631806768,241608186775,241606232141,241693063039,241608701024,241602246678,241734199196,241616225562,241691888086,241674073049,241616908288,241731197983,241608893141,241660748707,241609258888,241663777980,230049338091,241733116678,241600984445,241601679900,241707376882,241688841718,230043556876,241706779393,241660437082,241617906074,241631070323,241635162843,241698704970,241601046370,241646758182,241620293636,241661071926,241677293049,241618192545,241659886164,241618161734,241604220205,241670409717,241666266484,241694768705,241676491422,241716582338,241667917172', '','DEFAULT',051,0320,'', '','', 00);
Date: 2026-08-05 14:45:29 Duration: 1s409ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 102 58s190ms 318ms 948ms 570ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 05 00 1 680ms 680ms 01 1 618ms 618ms 02 2 1s175ms 587ms 04 2 978ms 489ms 05 2 1s286ms 643ms 07 2 963ms 481ms 08 8 4s488ms 561ms 09 11 6s756ms 614ms 10 11 6s75ms 552ms 11 10 5s566ms 556ms 12 2 958ms 479ms 13 11 6s600ms 600ms 14 7 4s88ms 584ms 15 13 7s612ms 585ms 16 10 5s871ms 587ms 17 6 2s905ms 484ms 21 2 994ms 497ms 22 1 569ms 569ms [ User: intelifix - Total duration: 58s190ms - Times executed: 102 ]
[ Application: [unknown] - Total duration: 58s190ms - Times executed: 102 ]
-
select * from rs_menu_grants (409, 18, 1);
Date: 2026-08-05 14:19:43 Duration: 948ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (401, 53, 1);
Date: 2026-08-05 08:47:52 Duration: 834ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (414, 19, 1);
Date: 2026-08-05 13:15:04 Duration: 814ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 90 34s579ms 158ms 865ms 384ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 05 08 85 33s415ms 393ms 15 4 991ms 247ms 17 1 172ms 172ms [ User: intelifix - Total duration: 34s579ms - Times executed: 90 ]
[ Application: [unknown] - Total duration: 34s579ms - Times executed: 90 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-08-05 08:16:09 Duration: 865ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-08-05 08:13:53 Duration: 755ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-08-05 08:16:05 Duration: 636ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 88 24s190ms 150ms 1s94ms 274ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 05 01 1 299ms 299ms 07 1 805ms 805ms 09 1 289ms 289ms 10 5 1s755ms 351ms 11 3 1s407ms 469ms 12 8 2s965ms 370ms 13 3 581ms 193ms 14 12 3s403ms 283ms 15 18 4s336ms 240ms 16 20 3s567ms 178ms 17 16 4s777ms 298ms [ User: intelifix - Total duration: 24s190ms - Times executed: 88 ]
[ Application: [unknown] - Total duration: 24s190ms - Times executed: 88 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "434", "data-de" : "2026-08-05", "data-ate" : "2026-08-05", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 508 }');
Date: 2026-08-05 11:53:09 Duration: 1s94ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "432", "data-de" : "2026-08-05", "data-ate" : "2026-08-05", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 503 }');
Date: 2026-08-05 17:23:22 Duration: 1s49ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "398", "data-de" : "2026-08-05", "data-ate" : "2026-08-05", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 452 }');
Date: 2026-08-05 15:35:11 Duration: 989ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 86 18s448ms 150ms 1s861ms 214ms create table temp0000287526 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 05 07 3 2s295ms 765ms 08 16 3s225ms 201ms 09 5 858ms 171ms 10 11 2s41ms 185ms 11 4 799ms 199ms 12 2 390ms 195ms 13 1 246ms 246ms 14 5 1s76ms 215ms 15 21 4s32ms 192ms 16 14 2s596ms 185ms 17 4 886ms 221ms [ User: intelifix - Total duration: 18s448ms - Times executed: 86 ]
[ Application: [unknown] - Total duration: 18s448ms - Times executed: 86 ]
-
CREATE TABLE temp0000287526 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-07-2026", "ate" :"05-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-05 07:53:38 Duration: 1s861ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287526 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-07-2026", "ate" :"05-08-2026", "nota-fiscal":"2133", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-05 17:35:40 Duration: 276ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287526 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-07-2026", "ate" :"05-08-2026", "nota-fiscal":"1065363", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-05 11:33:47 Duration: 258ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 80 59s821ms 150ms 4s247ms 747ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 05 10 7 4s176ms 596ms 11 23 18s142ms 788ms 13 17 12s272ms 721ms 14 3 3s988ms 1s329ms 15 7 3s746ms 535ms 16 16 13s255ms 828ms 17 7 4s239ms 605ms [ User: intelifix - Total duration: 59s821ms - Times executed: 80 ]
[ Application: [unknown] - Total duration: 59s821ms - Times executed: 80 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0131424) LIMIT 1;
Date: 2026-08-05 16:54:48 Duration: 4s247ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0274322) LIMIT 1;
Date: 2026-08-05 16:08:14 Duration: 2s834ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0274268) LIMIT 1;
Date: 2026-08-05 14:34:15 Duration: 2s505ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 70 15s488ms 151ms 749ms 221ms create table temp0000287578 as select * from rs_baixas_lista (?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 05 13 5 989ms 197ms 14 35 7s81ms 202ms 15 20 4s830ms 241ms 16 10 2s587ms 258ms [ User: intelifix - Total duration: 15s488ms - Times executed: 70 ]
[ Application: [unknown] - Total duration: 15s488ms - Times executed: 70 ]
-
CREATE TABLE temp0000287578 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '14122885850098301911', '2026-08-03', '2026-08-05');
Date: 2026-08-05 15:33:54 Duration: 749ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287578 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, 'F200013216B3745', '2026-08-03', '2026-08-05');
Date: 2026-08-05 16:31:29 Duration: 511ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287578 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '', '2026-08-03', '2026-08-05');
Date: 2026-08-05 16:30:49 Duration: 384ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 68 21s629ms 156ms 6s797ms 318ms create table temp0000287580 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 05 13 8 8s352ms 1s44ms 14 14 3s50ms 217ms 15 15 2s920ms 194ms 16 30 7s124ms 237ms 17 1 181ms 181ms [ User: intelifix - Total duration: 21s629ms - Times executed: 68 ]
[ Application: [unknown] - Total duration: 21s629ms - Times executed: 68 ]
-
CREATE TABLE temp0000287580 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-07-2026", "ate" :"05-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-05 13:35:29 Duration: 6s797ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287580 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"010196622", "ate" :"010196623", "nota-fiscal":"299", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-05 16:45:30 Duration: 1s365ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287580 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"31-07-2026", "ate" :"05-08-2026", "nota-fiscal":"1065363", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-05 14:15:23 Duration: 317ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 59 3m32s 2s863ms 8s626ms 3s603ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 05 08 3 12s119ms 4s39ms 09 4 14s146ms 3s536ms 10 3 11s38ms 3s679ms 11 5 18s189ms 3s637ms 12 4 14s110ms 3s527ms 13 4 12s831ms 3s207ms 14 5 17s732ms 3s546ms 15 4 19s422ms 4s855ms 16 4 13s111ms 3s277ms 17 3 10s198ms 3s399ms 18 4 14s104ms 3s526ms 19 4 13s353ms 3s338ms 20 4 14s595ms 3s648ms 21 4 13s667ms 3s416ms 22 4 14s 3s500ms [ User: intelifix - Total duration: 3m32s - Times executed: 59 ]
[ Application: psql - Total duration: 3m32s - Times executed: 59 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-05 15:00:10 Duration: 8s626ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-05 08:00:10 Duration: 4s918ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-05 11:00:09 Duration: 4s858ms Database: brasilia User: intelifix Remote: [local] Application: psql
19 56 2m55s 204ms 33s631ms 3s132ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 05 07 4 2s268ms 567ms 08 1 684ms 684ms 09 4 29s975ms 7s493ms 10 19 8s66ms 424ms 11 7 21s230ms 3s32ms 12 2 4s294ms 2s147ms 14 7 1m2s 8s980ms 15 7 27s937ms 3s991ms 17 5 18s80ms 3s616ms [ User: intelifix - Total duration: 2m55s - Times executed: 56 ]
[ Application: psql - Total duration: 2m55s - Times executed: 56 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028063);
Date: 2026-08-05 14:34:50 Duration: 33s631ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028028);
Date: 2026-08-05 09:06:03 Duration: 27s73ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028069);
Date: 2026-08-05 15:18:22 Duration: 15s547ms Database: rio User: intelifix Remote: [local] Application: psql
20 55 4m13s 1s734ms 15s584ms 4s603ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 05 07 3 7s924ms 2s641ms 08 2 15s901ms 7s950ms 09 4 15s105ms 3s776ms 10 7 32s44ms 4s577ms 11 1 2s210ms 2s210ms 12 1 2s584ms 2s584ms 13 2 12s432ms 6s216ms 14 5 22s436ms 4s487ms 15 10 52s147ms 5s214ms 16 12 53s934ms 4s494ms 17 8 36s458ms 4s557ms [ User: intelifix - Total duration: 4m13s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 4m13s - Times executed: 55 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-05', 0302, '', '', 0, 6, '2026-08-05');
Date: 2026-08-05 10:30:11 Duration: 15s584ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-05', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-05 15:33:13 Duration: 14s353ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-05', 0302, '', '', 0, 6, '2026-08-05');
Date: 2026-08-05 14:45:48 Duration: 13s358ms 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 2m50s 10m13s 6m1s 3 18m3s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 05 05 3 18m3s 6m1s [ User: intelifix - Total duration: 18m3s - Times executed: 3 ]
[ Application: psql - Total duration: 18m3s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-05 05:10:14 Duration: 10m13s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-05 05:15:14 Duration: 4m59s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-05 05:18:04 Duration: 2m50s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s348ms 11m12s 2m49s 48 2h15m19s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 05 07 3 11m54s 3m58s 08 3 6m22s 2m7s 09 3 10m21s 3m27s 10 3 9m39s 3m13s 11 3 10m39s 3m33s 12 3 7m58s 2m39s 13 3 6m42s 2m14s 14 3 7m30s 2m30s 15 3 10m59s 3m39s 16 3 10m11s 3m23s 17 3 8m42s 2m54s 18 3 6m54s 2m18s 19 3 5m59s 1m59s 20 3 9m1s 3m 21 3 6m10s 2m3s 22 3 6m12s 2m4s [ User: intelifix - Total duration: 2h15m19s - Times executed: 48 ]
[ Application: psql - Total duration: 2h15m19s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-05 07:16:14 Duration: 11m12s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-05 11:15:00 Duration: 9m58s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-05 15:14:57 Duration: 9m55s Database: rio User: intelifix Remote: [local] Application: psql
3 2m11s 2m11s 2m11s 1 2m11s select * from rs_resumo_defeitos (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 05 16 1 2m11s 2m11s [ User: intelifix - Total duration: 2m11s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 2m11s - Times executed: 1 ]
-
SELECT * FROM RS_RESUMO_DEFEITOS (01, 00);
Date: 2026-08-05 16:25:50 Duration: 2m11s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 206ms 5m5s 1m39s 48 1h19m44s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 05 07 3 5m20s 1m46s 08 3 4m10s 1m23s 09 3 6m28s 2m9s 10 3 6m7s 2m2s 11 3 5m56s 1m58s 12 3 4m40s 1m33s 13 3 4m52s 1m37s 14 3 4m26s 1m28s 15 3 6m26s 2m8s 16 3 5m 1m40s 17 3 5m26s 1m48s 18 3 3m57s 1m19s 19 3 3m52s 1m17s 20 3 4m44s 1m34s 21 3 4m2s 1m20s 22 3 4m11s 1m23s [ User: intelifix - Total duration: 1h19m44s - Times executed: 48 ]
[ Application: psql - Total duration: 1h19m44s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-05 15:22:01 Duration: 5m5s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-05 09:21:42 Duration: 4m53s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-05 10:20:35 Duration: 4m29s Database: brasilia User: intelifix Remote: [local] Application: psql
5 4s396ms 1m25s 44s727ms 4 2m58s 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 05 20 2 1m30s 45s30ms 23 2 1m28s 44s425ms [ User: intelifix - Total duration: 2m58s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m58s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-05 20:08:37 Duration: 1m25s 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-05 23:16:38 Duration: 1m24s 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-05 20:10:29 Duration: 4s568ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 152ms 8m 23s969ms 312 2h4m38s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 05 07 6 6m4s 1m 08 14 5m31s 23s679ms 09 31 19m56s 38s586ms 10 37 19m41s 31s930ms 11 46 28m57s 37s772ms 12 10 1m6s 6s662ms 13 27 1m12s 2s671ms 14 29 6m1s 12s460ms 15 42 27m49s 39s738ms 16 36 1m53s 3s153ms 17 34 6m24s 11s311ms [ User: intelifix - Total duration: 2h4m38s - Times executed: 312 ]
[ Application: [unknown] - Total duration: 2h4m38s - Times executed: 312 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028054, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-05 11:38:51 Duration: 8m Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028029, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-05 09:20:28 Duration: 7m25s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028067, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-05 15:08:41 Duration: 7m18s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 9s884ms 1m 15s35ms 13 3m15s create table temp0000287611 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 05 16 1 1m 1m 17 12 2m14s 11s232ms [ User: intelifix - Total duration: 3m15s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 3m15s - Times executed: 13 ]
-
CREATE TABLE temp0000287611 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 16:54:57 Duration: 1m Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287611 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 17:30:56 Duration: 13s77ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287611 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 17:38:46 Duration: 12s273ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 9s698ms 55s619ms 12s578ms 41 8m35s create table temp0000287518 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 05 07 11 2m40s 14s594ms 08 3 33s719ms 11s239ms 09 9 1m49s 12s215ms 10 12 2m24s 12s63ms 11 6 1m6s 11s123ms [ User: intelifix - Total duration: 8m35s - Times executed: 41 ]
[ Application: [unknown] - Total duration: 8m35s - Times executed: 41 ]
-
CREATE TABLE temp0000287518 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 07:17:51 Duration: 55s619ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287518 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 09:12:42 Duration: 14s490ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287518 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 09:12:20 Duration: 14s4ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 9s998ms 13s861ms 12s358ms 14 2m53s create table temp0000287596 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 05 14 3 36s827ms 12s275ms 15 11 2m16s 12s381ms [ User: intelifix - Total duration: 2m53s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 2m53s - Times executed: 14 ]
-
CREATE TABLE temp0000287596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 15:33:47 Duration: 13s861ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 15:01:18 Duration: 13s740ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 15:42:15 Duration: 13s623ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s889ms 12s840ms 11s828ms 13 2m33s create table temp0000287556 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 05 10 10 1m58s 11s873ms 11 3 35s38ms 11s679ms [ User: intelifix - Total duration: 2m33s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m33s - Times executed: 13 ]
-
CREATE TABLE temp0000287556 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 11:18:09 Duration: 12s840ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287556 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 10:05:52 Duration: 12s700ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287556 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 10:06:08 Duration: 12s562ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s324ms 13s1ms 11s683ms 14 2m43s create table temp0000287532 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 05 10 14 2m43s 11s683ms [ User: intelifix - Total duration: 2m43s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 2m43s - Times executed: 14 ]
-
CREATE TABLE temp0000287532 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 10:29:06 Duration: 13s1ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287532 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 10:24:34 Duration: 12s416ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287532 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 10:19:10 Duration: 12s288ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 9s909ms 13s695ms 11s631ms 30 5m48s create table temp0000287574 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 05 11 7 1m20s 11s564ms 12 5 52s944ms 10s588ms 13 1 11s232ms 11s232ms 14 12 2m19s 11s594ms 15 5 1m4s 12s937ms [ User: intelifix - Total duration: 5m48s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 5m48s - Times executed: 30 ]
-
CREATE TABLE temp0000287574 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 15:19:44 Duration: 13s695ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287574 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 15:11:45 Duration: 13s323ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287574 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-05 15:12:15 Duration: 12s949ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 1s734ms 15s584ms 4s603ms 55 4m13s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 05 07 3 7s924ms 2s641ms 08 2 15s901ms 7s950ms 09 4 15s105ms 3s776ms 10 7 32s44ms 4s577ms 11 1 2s210ms 2s210ms 12 1 2s584ms 2s584ms 13 2 12s432ms 6s216ms 14 5 22s436ms 4s487ms 15 10 52s147ms 5s214ms 16 12 53s934ms 4s494ms 17 8 36s458ms 4s557ms [ User: intelifix - Total duration: 4m13s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 4m13s - Times executed: 55 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-05', 0302, '', '', 0, 6, '2026-08-05');
Date: 2026-08-05 10:30:11 Duration: 15s584ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-05', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-05 15:33:13 Duration: 14s353ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-05', 0302, '', '', 0, 6, '2026-08-05');
Date: 2026-08-05 14:45:48 Duration: 13s358ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 157ms 34s177ms 4s321ms 38 2m44s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 05 07 2 25s865ms 12s932ms 08 3 4s276ms 1s425ms 09 5 31s608ms 6s321ms 10 10 22s111ms 2s211ms 11 5 13s737ms 2s747ms 14 3 9s328ms 3s109ms 15 5 54s223ms 10s844ms 17 5 3s65ms 613ms [ User: intelifix - Total duration: 2m44s - Times executed: 38 ]
[ Application: psql - Total duration: 2m44s - Times executed: 38 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028067);
Date: 2026-08-05 15:01:24 Duration: 34s177ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028026);
Date: 2026-08-05 07:40:07 Duration: 21s831ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028029);
Date: 2026-08-05 09:12:45 Duration: 16s930ms Database: rio User: intelifix Remote: [local] Application: psql
15 158ms 15s482ms 3s825ms 161 10m15s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 05 00 6 29s993ms 4s998ms 01 5 14s751ms 2s950ms 02 5 11s244ms 2s248ms 03 5 16s753ms 3s350ms 04 6 15s985ms 2s664ms 05 6 13s985ms 2s330ms 07 9 39s302ms 4s366ms 08 12 59s284ms 4s940ms 09 12 1m 5s47ms 10 11 51s86ms 4s644ms 11 12 57s318ms 4s776ms 12 12 45s678ms 3s806ms 13 9 11s539ms 1s282ms 14 11 50s346ms 4s576ms 15 12 58s914ms 4s909ms 16 9 33s390ms 3s710ms 17 6 9s528ms 1s588ms 20 1 158ms 158ms 21 6 19s202ms 3s200ms 22 6 16s889ms 2s814ms [ User: intelifix - Total duration: 10m15s - Times executed: 161 ]
[ Application: psql - Total duration: 10m15s - Times executed: 161 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-05 00:05:17 Duration: 15s482ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-05 14:25:14 Duration: 13s247ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-05 08:15:13 Duration: 12s121ms Database: rio User: intelifix Remote: [local] Application: psql
16 2s863ms 8s626ms 3s603ms 59 3m32s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 05 08 3 12s119ms 4s39ms 09 4 14s146ms 3s536ms 10 3 11s38ms 3s679ms 11 5 18s189ms 3s637ms 12 4 14s110ms 3s527ms 13 4 12s831ms 3s207ms 14 5 17s732ms 3s546ms 15 4 19s422ms 4s855ms 16 4 13s111ms 3s277ms 17 3 10s198ms 3s399ms 18 4 14s104ms 3s526ms 19 4 13s353ms 3s338ms 20 4 14s595ms 3s648ms 21 4 13s667ms 3s416ms 22 4 14s 3s500ms [ User: intelifix - Total duration: 3m32s - Times executed: 59 ]
[ Application: psql - Total duration: 3m32s - Times executed: 59 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-05 15:00:10 Duration: 8s626ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-05 08:00:10 Duration: 4s918ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-05 11:00:09 Duration: 4s858ms Database: brasilia User: intelifix Remote: [local] Application: psql
17 198ms 3m31s 3s603ms 274 16m27s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 05 00 12 37s821ms 3s151ms 01 12 23s512ms 1s959ms 02 12 22s771ms 1s897ms 03 12 24s652ms 2s54ms 04 12 24s345ms 2s28ms 05 12 25s359ms 2s113ms 06 12 22s421ms 1s868ms 07 12 23s159ms 1s929ms 08 12 25s554ms 2s129ms 09 12 27s86ms 2s257ms 10 11 25s391ms 2s308ms 11 12 27s15ms 2s251ms 12 11 24s598ms 2s236ms 13 12 28s146ms 2s345ms 14 12 26s180ms 2s181ms 15 12 6m21s 31s816ms 16 12 33s850ms 2s820ms 17 12 30s76ms 2s506ms 18 12 28s906ms 2s408ms 19 12 26s291ms 2s190ms 20 12 46s796ms 3s899ms 21 12 25s851ms 2s154ms 22 12 25s689ms 2s140ms [ User: intelifix - Total duration: 16m27s - Times executed: 274 ]
[ Application: psql - Total duration: 16m27s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-05 15:08:41 Duration: 3m31s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-05 15:47:37 Duration: 2m28s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-05 00:05:33 Duration: 16s208ms Database: rio User: intelifix Remote: [local] Application: psql
18 204ms 33s631ms 3s132ms 56 2m55s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 05 07 4 2s268ms 567ms 08 1 684ms 684ms 09 4 29s975ms 7s493ms 10 19 8s66ms 424ms 11 7 21s230ms 3s32ms 12 2 4s294ms 2s147ms 14 7 1m2s 8s980ms 15 7 27s937ms 3s991ms 17 5 18s80ms 3s616ms [ User: intelifix - Total duration: 2m55s - Times executed: 56 ]
[ Application: psql - Total duration: 2m55s - Times executed: 56 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028063);
Date: 2026-08-05 14:34:50 Duration: 33s631ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028028);
Date: 2026-08-05 09:06:03 Duration: 27s73ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028069);
Date: 2026-08-05 15:18:22 Duration: 15s547ms Database: rio User: intelifix Remote: [local] Application: psql
19 150ms 7s806ms 944ms 1,350 21m15s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 05 07 14 5s585ms 398ms 08 93 1m14s 804ms 09 125 2m1s 972ms 10 155 2m14s 868ms 11 147 2m22s 968ms 12 28 25s22ms 893ms 13 96 2m4s 1s301ms 14 188 3m27s 1s104ms 15 213 3m12s 902ms 16 218 3m8s 863ms 17 73 58s529ms 801ms [ User: intelifix - Total duration: 21m15s - Times executed: 1350 ]
[ Application: [unknown] - Total duration: 21m15s - Times executed: 1350 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (50188, 407, '270911029126105008,229690211921,229866089007,229690854565,216944803440,229662942638,229811300215,229670488289,229805223437,229808947481,229685284762,229669699111,229813786068,229808843656,229747733640,229728456977,229934150723,229810604557,216944305860,229781785459,229782439192,229733715762,216940420409,216936655877,229807413449,229781832838,229669200825,229690868203,229781830919,216944595159,229837120120,229933515778,229808084962,229810947474,229816608701,229749232945,216939545362,229879716161,229740188593,229782716874,229738239717,229778939817,229660299191,229737081434,229807404963,229668723348,229751500215,229782330822,229934078997,229805501119,216938846169', '246513952341,246653349817,246516999999,246468021315,246490773737,246630355676,246513610613,246592888507,246618195050,246518625052,246515344160,246627182123,246612968288,246548274242,246546213132,246171838996,246640393345,246468166985,246602355760,246072966171,246526719905,246463981931,246462239213,246619552950,246586965459,246512915258,246513539517,246586979804,246456917088,246640091318,246482026688,246618305364,246640372030,246628893850,246548951537,246473874355,246652307481,246529974151,246598768800,246570479709,246571400013,246488641734,246529339712,246581372142,246515752438,246533105354,246599145559,246040882143,246596189906,246464293959', 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":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-05 15:07:23 Duration: 7s806ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (274076, 304, '863400535703109,241746489308,241778781820,241744752427,241778755880,241778766363,241744527477,241778762727,241744731112,241742809611,241742832644,241759932730,241778768181,241759948892,241759831834,241744759194,241744754144', '',0464,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-05 13:41:54 Duration: 5s931ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (274258, 404, '834136920000323,241601098901,241677675970,241666810915,241691064460,241712062020,241701239011,241607791833,241712186880,241674511431,241672950224,241649102026,241656736878,241680316991,241669493556,241597318789,241610111431,241707336676,241726780000,241655002546,241688952638,241677678293,241651359091,241665851517,241601526170,241639160809,230048067597,241597319698,230040233152,241674599092,241670193658,241653136684,241629255072,241674541434,241639147395', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-05 13:55:12 Duration: 5s550ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 150ms 4s247ms 747ms 80 59s821ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 05 10 7 4s176ms 596ms 11 23 18s142ms 788ms 13 17 12s272ms 721ms 14 3 3s988ms 1s329ms 15 7 3s746ms 535ms 16 16 13s255ms 828ms 17 7 4s239ms 605ms [ User: intelifix - Total duration: 59s821ms - Times executed: 80 ]
[ Application: [unknown] - Total duration: 59s821ms - Times executed: 80 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0131424) LIMIT 1;
Date: 2026-08-05 16:54:48 Duration: 4s247ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0274322) LIMIT 1;
Date: 2026-08-05 16:08:14 Duration: 2s834ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0274268) LIMIT 1;
Date: 2026-08-05 14:34:15 Duration: 2s505ms 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 5 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 05 13 1 0ms 0ms 19 1 0ms 0ms 21 1 0ms 0ms 22 2 0ms 0ms [ User: intelifix - Total duration: 5s775ms - Times executed: 5 ]
[ Application: psql - Total duration: 5s619ms - Times executed: 4 ]
[ Application: [unknown] - Total duration: 156ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 17,740 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 21 FATAL entries
- 3737 ERROR entries
- 0 WARNING entries
- 14 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,667 Max number of times the same event was reported
- 3,772 Total events found
Rank Times reported Error 1 3,667 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 05 00 59 01 60 02 59 03 55 04 59 05 60 06 60 07 159 08 309 09 369 10 326 11 351 12 120 13 167 14 346 15 357 16 242 17 87 18 59 19 60 20 59 21 68 22 98 23 78 - ERROR: prepared statement "_PLAN00000000296CA5C0" does not exist
- ERROR: prepared statement "_PLAN00000000298E0880" does not exist
- ERROR: prepared statement "_PLAN000000001BEDCCF0" does not exist
Statement: DEALLOCATE "_PLAN00000000296CA5C0"
Date: 2026-08-05 00:00:51 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000298E0880"
Date: 2026-08-05 00:01:51 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000001BEDCCF0"
Date: 2026-08-05 00:02:52 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 05 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-05 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-05 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-05 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
3 11 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 05 03 11 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-08-05 03:05:01 Database: rio Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-05 03:05:01 Database: rio Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-05 03:05:01 Database: rio Application: psql User: intelifix Remote: [local]
4 8 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 05 11 3 15 5 - LOG: process 3027325 still waiting for ShareLock on transaction 3886931 after 1000.120 ms
- LOG: process 3027325 still waiting for ShareLock on transaction 3886931 after 1556.919 ms
- LOG: process 3027325 still waiting for ShareLock on transaction 3886931 after 24696.981 ms
Detail: Process holding the lock: 3025372. Wait queue: 3027325.
Context: while deleting tuple (70516,67) in relation "codigos_barra" SQL statement "DELETE FROM CODIGOS_BARRA WHERE EQ_ID = cRet.ID" PL/pgSQL function rs_equipamento_manutencao(integer,integer,integer,integer,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 655 at SQL statement SQL statement "SELECT * FROM RS_EQUIPAMENTO_MANUTENCAO( 0,5,34,6,502,'465043426372','','465043426372','216475549292',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 920 at EXECUTE 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( 028054, 0502 )' , '/var/www/html/tmp/nf_carga_lotes_0502.xlsx' )Date: 2026-08-05 11:31:00 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 3025372. Wait queue: 3027325.
Context: while deleting tuple (70516,67) in relation "codigos_barra" SQL statement "DELETE FROM CODIGOS_BARRA WHERE EQ_ID = cRet.ID" PL/pgSQL function rs_equipamento_manutencao(integer,integer,integer,integer,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 655 at SQL statement SQL statement "SELECT * FROM RS_EQUIPAMENTO_MANUTENCAO( 0,5,34,6,502,'465043426372','','465043426372','216475549292',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 920 at EXECUTE 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( 028054, 0502 )' , '/var/www/html/tmp/nf_carga_lotes_0502.xlsx' )Date: 2026-08-05 11:31:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 3025372. Wait queue: 3027325.
Context: while deleting tuple (70516,67) in relation "codigos_barra" SQL statement "DELETE FROM CODIGOS_BARRA WHERE EQ_ID = cRet.ID" PL/pgSQL function rs_equipamento_manutencao(integer,integer,integer,integer,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 655 at SQL statement SQL statement "SELECT * FROM RS_EQUIPAMENTO_MANUTENCAO( 0,5,34,6,502,'465043426372','','465043426372','216475549292',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 920 at EXECUTE 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( 028054, 0502 )' , '/var/www/html/tmp/nf_carga_lotes_0502.xlsx' )Date: 2026-08-05 11:31:24 Database: rio Application: [unknown] User: intelifix Remote: [local]
5 7 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 05 00 1 03 4 05 1 06 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-08-05 00:02:10 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-05 03:04:00 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-05 03:04:15 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
6 7 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 05 09 3 11 4 - ERROR: syntax error at or near "241703719612" at character 41
- ERROR: syntax error at or near ")" at character 34
- ERROR: syntax error at or near ")" at character 34
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''241703719612');
Date: 2026-08-05 09:10:15 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: select * from rs_caixa_qr(386986,)
Date: 2026-08-05 09:29:46 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(386986,)
Date: 2026-08-05 09:29:46 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
7 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 05 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-05 05:32:21 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-05 05:32:21 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-05 05:32:21 Database: contagem Application: psql User: intelifix Remote: [local]
8 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 05 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-05 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-05 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-08-05 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
9 3 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Aug 05 10 3 - ERROR: column "controle" does not exist at character 36
- ERROR: column "controle" does not exist at character 36
- ERROR: column "controle" does not exist at character 36
Statement: SELECT * FROM temp0000237500 WHERE CONTROLE='L'
Date: 2026-08-05 10:02:06 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM temp0000237500 WHERE CONTROLE='L'
Date: 2026-08-05 10:02:06 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM temp0000237500 WHERE CONTROLE='L'
Date: 2026-08-05 10:02:07 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
10 3 ERROR: invalid input syntax for type date: ...
Times Reported Most Frequent Error / Event #10
Day Hour Count Aug 05 09 2 10 1 - ERROR: invalid input syntax for type date: "N-Na--N-Na" at character 40
- ERROR: invalid input syntax for type date: "N-Na--N-Na" at character 40
- ERROR: invalid input syntax for type date: "N-Na--N-Na" at character 40
Statement: SELECT * FROM RS_RESUMO_PERIODO_GERAL( 'N-Na--N-Na', 0404 ,'', '',0,7,'2026-08-01');
Date: 2026-08-05 09:47:05 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_RESUMO_PERIODO_GERAL( 'N-Na--N-Na', 0404 ,'', '',0,7,'2026-08-01');
Date: 2026-08-05 09:47:23 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_RESUMO_PERIODO_GERAL( 'N-Na--N-Na', 0404 ,'', '',0,7,'2026-08-01');
Date: 2026-08-05 10:05:42 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
11 2 ERROR: type "..." does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count Aug 05 10 2 - ERROR: type "q1" does not exist at character 27
- ERROR: type "q1" does not exist at character 27
Statement: select * from rs_caixa_qr(q1'')
Date: 2026-08-05 10:08:16 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(q1'')
Date: 2026-08-05 10:08:16 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
12 2 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #12
Day Hour Count Aug 05 09 2 - ERROR: unterminated quoted string at or near "'241635815970'');" at character 39
- ERROR: unterminated quoted string at or near "'241703719612'');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('241635815970'');
Date: 2026-08-05 09:09:17 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('241703719612'');
Date: 2026-08-05 09:10:19 Database: rio Application: [unknown] User: intelifix Remote: [local]
13 2 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #13
Day Hour Count Aug 05 10 1 16 1 - LOG: process 2934556 still waiting for AccessExclusiveLock on relation 3401544 of database 358220 after 1000.094 ms
- LOG: process 3267019 still waiting for AccessExclusiveLock on relation 3429591 of database 358220 after 1000.118 ms
Detail: Process holding the lock: 3000268. Wait queue: 2934556.
Statement: DROP TABLE IF EXISTS temp0000287532;Date: 2026-08-05 10:24:44 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 3289494. Wait queue: 3267019.
Context: SQL statement "DROP TABLE IF EXISTS TMP_DRILL_0320; CREATE TABLE TMP_DRILL_0320( TIPO INTEGER, CONSUMO VARCHAR, FLU_ID INTEGER, CLI_ID INTEGER , TEC_ID INTEGER , PAS_ID INTEGER, MOD_ID INTEGER, RES_ID INTEGER, HORARIO VARCHAR , DATA_ACAO DATE, HORA_ACAO INTEGER, MEIA_HORA INTEGER ,PASSO_NOME VARCHAR,PASSO_DATA VARCHAR,PASSO_TECNICO VARCHAR,PASSO_RESULTADO VARCHAR, PASSO_APROVADO VARCHAR ); CREATE INDEX TMP_DRILL_03200 ON TMP_DRILL_0320(TIPO) TABLESPACE INDEXES; CREATE INDEX TMP_DRILL_03201 ON TMP_DRILL_0320(FLU_ID) TABLESPACE INDEXES; CREATE INDEX TMP_DRILL_03202 ON TMP_DRILL_0320(CLI_ID) TABLESPACE INDEXES; CREATE INDEX TMP_DRILL_03203 ON TMP_DRILL_0320(TEC_ID) TABLESPACE INDEXES; CREATE INDEX TMP_DRILL_03204 ON TMP_DRILL_0320(PAS_ID) TABLESPACE INDEXES; CREATE INDEX TMP_DRILL_03205 ON TMP_DRILL_0320(MOD_ID) TABLESPACE INDEXES; GRANT SELECT ON TMP_DRILL_0320 TO PUBLIC; COMMENT ON TABLE TMP_DRILL_0320 IS 'CRIADA EM 05/AGO/2026 16:26';" PL/pgSQL function rs_resumo_tecnico_simples(integer,integer,integer,integer,integer,date,date) line 128 at EXECUTE PL/pgSQL function rs_resumo_tecnico1(integer,integer,integer,integer,integer,date,date,integer) line 72 at FETCH
Statement: SELECT * FROM RS_RESUMO_TECNICO1(06,00,00,00,00,'2026-08-05','2026-08-05',00);Date: 2026-08-05 16:26:52 Database: rio Application: [unknown] User: intelifix Remote: [local]
14 2 ERROR: function rs_caixa_qr(...) does not exist
Times Reported Most Frequent Error / Event #14
Day Hour Count Aug 05 14 2 - ERROR: function rs_caixa_qr(numeric) does not exist at character 15
- ERROR: function rs_caixa_qr(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_caixa_qr(.387213)Date: 2026-08-05 14:53:13 Database: brasilia 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_caixa_qr(.387213)Date: 2026-08-05 14:53:13 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
15 2 LOG: process ... still waiting for ExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #15
Day Hour Count Aug 05 15 2 - LOG: process 3190084 still waiting for ExclusiveLock on relation 364924 of database 358220 after 1000.100 ms
- LOG: process 3190084 still waiting for ExclusiveLock on relation 364924 of database 358220 after 1346.257 ms
Detail: Process holding the lock: 3214025. Wait queue: 3190084.
Context: SQL statement "REFRESH MATERIALIZED VIEW CONCURRENTLY RS_V_LOTES_REDE" PL/pgSQL function rs_atualiza_views() line 17 at SQL statement SQL statement "CALL RS_ATUALIZA_VIEWS()" PL/pgSQL function rs_lote_manutencao(text) line 361 at CALL PL/pgSQL function rs_lotes_cria(integer,integer,text) line 90 at assignment PL/Python function "rs_fast_excel"
Statement: 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-05 15:17:36 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 3214025. Wait queue: 3190084.
Context: SQL statement "REFRESH MATERIALIZED VIEW CONCURRENTLY RS_V_LOTES_REDE" PL/pgSQL function rs_atualiza_views() line 17 at SQL statement SQL statement "CALL RS_ATUALIZA_VIEWS()" PL/pgSQL function rs_lote_manutencao(text) line 361 at CALL PL/pgSQL function rs_lotes_cria(integer,integer,text) line 90 at assignment PL/Python function "rs_fast_excel"
Statement: 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-05 15:17:37 Database: rio Application: [unknown] User: intelifix Remote: [local]
16 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #16
Day Hour Count Aug 05 03 1 - LOG: database system was shut down at 2026-08-05 03:05:01 -03
Date: 2026-08-05 03:05:02
17 1 ERROR: process ... detected deadlock while waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #17
Day Hour Count Aug 05 15 1 - ERROR: process 3214724 detected deadlock while waiting for ShareLock on transaction 3901157 after 1000.132 ms
Detail: Process holding the lock: 3214025. Wait queue: .
Context: while updating tuple (75935,42) 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,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( 028067, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-08-05 15:06:30 Database: rio Application: [unknown] User: intelifix Remote: [local]
18 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #18
Day Hour Count Aug 05 10 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000287532"
Date: 2026-08-05 10:24:44