pgBadger-
Global information
- Generated on Thu Aug 6 23:50:12 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 43,530 log entries in 10s
- Log start from 2026-08-06 00:00:39 to 2026-08-06 23:49:37
-
Overview
Global Stats
- 383 Number of unique normalized queries
- 6,660 Number of queries
- 8h44m11s Total query duration
- 2026-08-06 00:02:08 First query
- 2026-08-06 23:47:26 Last query
- 4 queries/s at 2026-08-06 09:11:40 Query peak
- 8h44m11s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h44m11s Execute total duration
- 3,751 Number of events
- 13 Number of unique normalized events
- 3,663 Max number of times the same event was reported
- 0 Number of cancellation
- 527 Total number of automatic vacuums
- 1,126 Total number of automatic analyzes
- 12 Number temporary file
- 239.09 MiB Max size of temporary file
- 109.96 MiB Average size of temporary file
- 367 Total number of sessions
- 7 sessions at 2026-08-06 08:11:14 Session peak
- 13d17h53m54s Total duration of sessions
- 53m56s Average duration of sessions
- 18 Average queries per session
- 1m25s Average queries duration per session
- 52m30s Average idle time per session
- 371 Total number of connections
- 7 connections/s at 2026-08-06 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-06 09:11:40 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-06 09:11:40 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-06 23:46:55 Date
Queries duration
Key values
- 8h44m11s 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 06 00 32 0ms 18s92ms 3s906ms 4s694ms 8s648ms 1m23s 01 44 0ms 3s812ms 972ms 4s244ms 7s204ms 8s492ms 02 23 0ms 4s51ms 1s561ms 4s333ms 6s211ms 7s147ms 03 26 0ms 5s461ms 1s566ms 3s654ms 7s521ms 9s204ms 04 29 0ms 3s889ms 1s394ms 5s228ms 6s275ms 7s682ms 05 35 0ms 10m43s 35s820ms 9s400ms 2m42s 10m43s 06 23 0ms 8s527ms 2s424ms 3s709ms 5s152ms 28s123ms 07 200 0ms 11m8s 11s22ms 1m27s 4m38s 11m10s 08 514 0ms 6m1s 2s994ms 46s748ms 4m14s 6m46s 09 532 150ms 9m50s 4s812ms 2m5s 5m13s 10m3s 10 687 150ms 8m13s 3s345ms 1m15s 5m11s 8m17s 11 613 150ms 9m19s 3s685ms 1m15s 4m55s 9m24s 12 214 0ms 8m42s 7s335ms 42s390ms 4m58s 8m43s 13 422 0ms 5m40s 2s824ms 48s440ms 1m24s 5m42s 14 704 150ms 8m13s 3s512ms 1m2s 6m18s 8m17s 15 876 150ms 10m3s 2s897ms 57s140ms 5m40s 10m25s 16 592 150ms 8m51s 3s533ms 50s545ms 4m33s 9m2s 17 497 0ms 7m44s 4s543ms 1m17s 2m35s 8m16s 18 27 0ms 7m49s 31s547ms 6s989ms 1m41s 7m49s 19 24 0ms 6m22s 28s998ms 6s283ms 16s623ms 6m55s 20 122 0ms 9m18s 12s843ms 1m8s 2m25s 9m18s 21 46 0ms 6m20s 17s706ms 13s543ms 58s97ms 6m51s 22 37 0ms 5m55s 19s183ms 8s341ms 49s803ms 5m55s 23 341 0ms 1m29s 6s549ms 1m9s 1m11s 1m31s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 06 00 10 0 1s166ms 0ms 0ms 1s460ms 01 25 0 251ms 183ms 373ms 1s21ms 02 5 0 275ms 0ms 0ms 222ms 03 7 0 258ms 0ms 158ms 223ms 04 11 0 263ms 0ms 162ms 533ms 05 15 0 283ms 0ms 210ms 929ms 06 7 0 989ms 0ms 0ms 1s512ms 07 146 0 12s289ms 5s278ms 36s737ms 5m50s 08 387 0 3s216ms 8s600ms 17s439ms 4m58s 09 410 0 5s460ms 8s635ms 2m5s 5m41s 10 485 0 3s865ms 12s292ms 50s13ms 5m14s 11 448 0 4s56ms 13s235ms 1m 6m12s 12 144 0 9s240ms 3s806ms 7s210ms 5m29s 13 292 0 3s534ms 8s979ms 48s440ms 3m36s 14 506 0 3s801ms 14s173ms 36s984ms 6m18s 15 656 0 3s164ms 19s378ms 48s783ms 6m33s 16 385 0 4s360ms 11s804ms 27s347ms 6m25s 17 279 0 5s483ms 21s203ms 59s788ms 4m15s 18 9 0 1m28s 0ms 0ms 3m45s 19 6 0 1m47s 0ms 0ms 3m34s 20 15 89 14s458ms 37s432ms 1m8s 4m4s 21 24 0 31s266ms 0ms 7s342ms 3m24s 22 13 0 49s284ms 0ms 1s65ms 3m21s 23 16 325 6s549ms 1m3s 1m9s 1m31s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 06 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 06 00 0 3 3.00 0.00% 01 0 4 4.00 0.00% 02 0 4 4.00 0.00% 03 0 5 5.00 0.00% 04 0 4 4.00 0.00% 05 0 4 4.00 0.00% 06 0 1 1.00 0.00% 07 0 12 12.00 0.00% 08 0 11 11.00 0.00% 09 0 14 14.00 0.00% 10 0 16 16.00 0.00% 11 0 18 18.00 0.00% 12 0 6 6.00 0.00% 13 0 14 14.00 0.00% 14 0 10 10.00 0.00% 15 0 19 19.00 0.00% 16 0 12 12.00 0.00% 17 0 6 6.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 3 3.00 0.00% 22 0 2 2.00 0.00% 23 0 3 3.00 0.00% Day Hour Count Average / Second Aug 06 00 16 0.00/s 01 12 0.00/s 02 12 0.00/s 03 19 0.01/s 04 7 0.00/s 05 10 0.00/s 06 14 0.00/s 07 20 0.01/s 08 22 0.01/s 09 23 0.01/s 10 22 0.01/s 11 20 0.01/s 12 13 0.00/s 13 18 0.01/s 14 22 0.01/s 15 25 0.01/s 16 20 0.01/s 17 15 0.00/s 18 9 0.00/s 19 10 0.00/s 20 10 0.00/s 21 10 0.00/s 22 11 0.00/s 23 11 0.00/s Day Hour Count Average Duration Average idle time Aug 06 00 6 1h 59m39s 01 15 1h59s 1h56s 02 12 1h30s 1h27s 03 22 25m44s 25m42s 04 9 1h2m40s 1h2m35s 05 7 1h30s 57m31s 06 10 57m50s 57m44s 07 16 51m43s 49m25s 08 19 54m20s 52m59s 09 25 52m49s 51m6s 10 21 53m49s 52m 11 21 55m51s 54m4s 12 16 1h29s 58m51s 13 14 1h1m41s 1h16s 14 20 57m31s 55m27s 15 24 53m20s 51m34s 16 21 56m18s 54m39s 17 20 55m34s 53m41s 18 13 1h47s 59m42s 19 9 1h 58m43s 20 13 46m54s 44m54s 21 7 1h54s 58m58s 22 11 55m43s 54m39s 23 16 40m1s 37m42s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-08-06 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 371 connections Total
Connections per user
Key values
- intelifix Main User
- 371 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-08-06 08:11:14 Date
Histogram of session times
Key values
- 303 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 367 sessions Total
Sessions per user
Key values
- intelifix Main User
- 367 sessions Total
Sessions per host
Key values
- [local] Main Host
- 367 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 20,058 buffers Checkpoint Peak
- 2026-08-06 00:09:50 Date
- 269.982 seconds Highest write time
- 0.151 seconds Sync time
Checkpoints Wal files
Key values
- 14 files Wal files usage Peak
- 2026-08-06 17:34:36 Date
Checkpoints distance
Key values
- 456.25 Mo Distance Peak
- 2026-08-06 17:34:36 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 06 00 33,308 679.517s 0.182s 679.777s 01 3,464 348.101s 0.182s 348.358s 02 2,397 240.536s 0.137s 240.733s 03 1,694 170.251s 0.209s 170.521s 04 2,552 256.38s 0.097s 256.549s 05 9,719 967.969s 0.193s 968.224s 06 1,624 162.606s 0.003s 162.617s 07 34,125 2,527.042s 0.512s 2,527.688s 08 44,643 3,042.544s 0.637s 3,043.359s 09 65,288 3,238.596s 0.835s 3,239.659s 10 67,513 3,238.597s 0.894s 3,239.768s 11 57,712 3,234.058s 0.796s 3,235.05s 12 32,850 2,477.611s 0.22s 2,478.003s 13 29,648 2,582.934s 0.528s 2,583.619s 14 60,517 3,238.432s 0.854s 3,239.561s 15 89,999 3,238.513s 1.005s 3,239.775s 16 60,502 3,238.649s 0.768s 3,239.688s 17 60,885 2,828.885s 0.652s 2,829.757s 18 1,366 137.15s 0.098s 137.29s 19 26 2.651s 0.008s 2.674s 20 1,932 242.409s 0.088s 242.527s 21 3,759 386.024s 0.059s 386.165s 22 2,390 240.057s 0.066s 240.209s 23 365 37.039s 0.108s 37.194s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 06 00 0 0 8 579 0.063s 0.01s 01 0 0 1 732 0.066s 0.01s 02 0 0 0 438 0.063s 0.016s 03 0 0 1 422 0.060s 0.008s 04 0 0 1 588 0.009s 0.009s 05 0 0 4 756 0.040s 0.008s 06 0 0 0 9 0.001s 0.001s 07 0 0 20 3,461 0.063s 0.012s 08 0 0 21 5,708 0.046s 0.012s 09 0 0 34 5,911 0.062s 0.012s 10 0 0 36 7,030 0.064s 0.012s 11 0 0 38 6,039 0.063s 0.012s 12 0 0 20 3,440 0.011s 0.012s 13 0 0 12 5,336 0.036s 0.012s 14 0 0 39 7,238 0.062s 0.012s 15 0 0 50 7,913 0.049s 0.012s 16 0 0 39 6,981 0.055s 0.012s 17 0 0 66 5,936 0.065s 0.012s 18 0 0 1 218 0.061s 0.011s 19 0 0 0 6 0.003s 0.003s 20 0 0 1 91 0.062s 0.007s 21 0 0 3 498 0.010s 0.008s 22 0 0 1 491 0.009s 0.013s 23 0 0 0 46 0.059s 0.019s Day Hour Count Avg time (sec) Aug 06 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 06 00 14,449.78 kB 50,347.78 kB 01 1,665.30 kB 20,494.50 kB 02 1,275.56 kB 8,404.00 kB 03 1,155.88 kB 2,297.88 kB 04 1,464.89 kB 2,115.11 kB 05 9,151.38 kB 14,975.25 kB 06 2,214.00 kB 13,372.00 kB 07 27,598.75 kB 50,583.75 kB 08 28,707.67 kB 66,844.33 kB 09 46,029.75 kB 92,474.67 kB 10 49,132.67 kB 109,148.92 kB 11 51,840.17 kB 109,104.17 kB 12 26,579.83 kB 74,126.42 kB 13 17,556.83 kB 34,982.83 kB 14 52,280.50 kB 74,807.83 kB 15 68,675.58 kB 115,270.75 kB 16 52,947.08 kB 83,360.83 kB 17 90,696.67 kB 144,508.25 kB 18 975.00 kB 120,471.17 kB 19 95.00 kB 77,970.00 kB 20 3,560.00 kB 58,288.75 kB 21 8,021.29 kB 39,484.00 kB 22 1,314.40 kB 20,174.40 kB 23 177.83 kB 8,819.67 kB -
Temporary Files
Size of temporary files
Key values
- 478.19 MiB Temp Files size Peak
- 2026-08-06 05:32:00 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-06 05:32:00 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 06 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.09 GiB 111.15 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 2 208.00 MiB 104.00 MiB 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 928.83 MiB 71.31 MiB 239.09 MiB 116.10 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-06 05:32:08 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-06 05:32:00 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 182.66 MiB 91.33 MiB 91.33 MiB 91.33 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-06 05:30:42 Duration: 40s12ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-06 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 2 208.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028120, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-06 16:07:54 Duration: 6m22s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028108, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-06 14:31:30 Duration: 6m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028100, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-06 11:32:34 Duration: 6m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 239.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[Ā Date: 2026-08-06 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 239.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[Ā Date: 2026-08-06 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAĆĆO DE LOTES - PADRĆO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[Ā Date: 2026-08-06 11:17:52 - 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-06 11:01:30 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 91.33 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[Ā Date: 2026-08-06 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 91.33 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[Ā Date: 2026-08-06 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 78.93 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[Ā Date: 2026-08-06 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 78.85 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[Ā Date: 2026-08-06 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 78.84 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[Ā Date: 2026-08-06 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 71.39 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[Ā Date: 2026-08-06 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 71.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[Ā Date: 2026-08-06 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 71.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[Ā Date: 2026-08-06 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 6.73 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-06 14:55:40 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 6.73 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-06 14:55:40 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (123) Main table analyzed (database rio)
- 1,126 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 123 rio.public.temp0000287693 100 rio.pg_catalog.pg_class 64 rio.public.temp0000287659 55 rio.public.usuarios 54 rio.pg_catalog.pg_type 53 brasilia.pg_catalog.pg_attribute 44 rio.pg_catalog.pg_index 37 rio.public.temp0000287629 30 rio.public.temp0000287627 28 rio.pg_catalog.pg_depend 27 contagem.pg_catalog.pg_attribute 25 rio.public.temp0000287623 24 contagem.public.usuarios 24 brasilia.pg_catalog.pg_class 22 rio.public.temp0000287705 20 rio.public.temp0000287637 19 brasilia.pg_catalog.pg_type 18 rio.public.temp0000287312 17 contagem.public.temp0000226778 15 rio.public.temp0000287625 15 rio.public.temp0000287617 15 contagem.pg_catalog.pg_class 13 brasilia.public.temp0000237592 13 rio.public.temp0000287651 12 brasilia.pg_catalog.pg_index 12 rio.public.temp0000287306 11 rio.public.temp0000287649 11 contagem.pg_catalog.pg_type 11 rio.public.temp0000287715 10 brasilia.public.usuarios 10 brasilia.pg_catalog.pg_depend 9 contagem.public.temp0000226724 9 contagem.pg_catalog.pg_index 8 rio.public.temp0000287703 8 rio.public.temp0000287699 8 rio.public.temp0000287653 7 rio.public.temp0000287701 6 brasilia.public.temp0000237666 6 contagem.pg_catalog.pg_depend 6 rio.public.temp0000287679 5 brasilia.public.temp0000237624 5 rio.public.temp0000287454 5 brasilia.public.temp0000237660 5 contagem.pg_catalog.pg_shdepend 5 contagem.public.temp0000226776 5 contagem.public.temp0000226782 5 rio.pg_catalog.pg_shdepend 4 brasilia.pg_catalog.pg_shdepend 4 rio.public.tmp_drill_0320 4 brasilia.public.temp0000237664 4 rio.public.temp0000287388 4 contagem.public.nf_entrada 4 contagem.auditor.auditor_2026_08 3 rio.public.temp0000287406 3 rio.public.temp0000287709 3 rio.public.temp0000287719 3 brasilia.public.temp0000237680 3 brasilia.auditor.auditor_2026_08 3 brasilia.public.temp0000237656 3 rio.public.temp0000287514 3 rio.public.tmp_drill_0302 3 rio.public.temp0000287564 3 rio.auditor.auditor_2026_08 2 rio.public.temp0000287727 2 brasilia.public.temp0000237602 2 contagem.public.temp0000226772 2 brasilia.public.nf_entrada 2 rio.public.temp0000287669 2 rio.public.temp0000287645 2 rio.public.temp0000287735 1 brasilia.public.temp0000237646 1 brasilia.public.temp0000237608 1 brasilia.public.temp0000237642 1 brasilia.public.temp0000237668 1 brasilia.public.temp0000237684 1 brasilia.public.temp0000237652 1 template1.pg_catalog.pg_shdepend 1 brasilia.public.temp0000237676 1 rio.public.temp0000287733 1 rio.public.temp0000287647 1 brasilia.public.temp0000237636 1 rio.public.temp0000287410 1 rio.public.temp0000287695 1 brasilia.public.temp0000237594 1 brasilia.public.temp0000237612 1 brasilia.public.temp0000237662 1 rio.public.temp0000287665 1 brasilia.public.temp0000237648 1 rio.public.temp0000287671 1 rio.public.temp0000287673 1 brasilia.public.temp0000237618 1 rio.public.temp0000287707 1 brasilia.public.temp0000237674 1 Total 1,126 Vacuums per table
Key values
- public.temp0000287693 (80) Main table vacuumed on database rio
- 527 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000287693 80 0 0 0 0 0 0 20,844 1,146 2,593,144 0 0 rio.pg_catalog.pg_attribute 42 40 0 0 0 0 0 23,118 5,311 8,430,864 321 7,565 rio.public.temp0000287659 34 0 0 0 0 0 0 3,736 342 555,788 0 0 rio.public.temp0000287629 30 0 0 0 0 0 0 28,017 3,600 6,192,272 0 0 rio.pg_catalog.pg_class 26 25 0 0 0 0 0 5,024 1,512 2,368,119 71 270 contagem.public.usuarios 23 0 0 0 0 0 0 131 106 50,280 0 0 rio.pg_catalog.pg_type 22 22 0 0 0 0 0 2,063 578 768,356 62 202 rio.public.temp0000287705 20 0 0 0 0 0 0 25,747 3,493 5,932,565 0 0 brasilia.pg_catalog.pg_attribute 15 15 0 0 0 0 0 7,724 1,784 2,990,471 73 1,707 rio.public.temp0000287312 14 0 0 0 0 0 0 1,300 201 296,685 0 0 rio.pg_catalog.pg_index 14 13 0 0 0 0 0 887 259 239,341 44 85 contagem.pg_catalog.pg_attribute 11 11 0 0 0 0 0 8,587 1,318 2,963,131 12 336 rio.pg_catalog.pg_depend 10 10 0 0 0 0 0 3,296 1,181 1,587,479 65 542 rio.pg_catalog.pg_statistic 10 10 0 0 0 0 0 11,505 3,263 13,666,619 1,761 7,616 rio.public.temp0000287715 10 0 0 0 0 0 0 10,555 116 771,272 0 0 rio.public.usuarios 10 7 0 0 0 0 0 179 74 140,702 5 5 rio.public.temp0000287306 9 0 0 0 0 0 0 705 42 48,562 0 0 brasilia.pg_catalog.pg_type 8 8 0 0 0 0 0 775 162 253,088 13 50 rio.public.tmp_drill_0320 8 4 0 0 0 0 0 2,312 70 465,770 1 27 brasilia.pg_catalog.pg_class 8 8 0 0 0 0 0 1,634 389 613,632 31 94 contagem.pg_catalog.pg_type 7 7 0 0 0 0 0 970 123 248,401 2 5 contagem.pg_catalog.pg_class 6 6 0 0 0 0 0 1,783 134 326,346 2 7 brasilia.pg_catalog.pg_index 5 5 0 0 0 0 0 321 99 83,541 19 37 contagem.pg_catalog.pg_depend 5 5 0 0 0 0 0 1,701 190 548,481 4 18 contagem.public.temp0000226776 5 0 0 0 0 0 0 540 130 204,612 0 0 contagem.pg_catalog.pg_index 5 5 0 0 0 0 0 354 59 94,446 1 1 rio.public.temp0000287679 5 0 0 0 0 0 0 6,837 1,724 2,604,193 0 0 rio.public.temp0000287454 4 0 0 0 0 0 0 266 21 18,919 0 0 postgres.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 614 171 286,092 29 65 rio.public.temp0000287649 4 0 0 0 0 0 0 1,787 1,724 2,309,149 0 0 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,832 487 2,297,519 136 343 rio.public.temp0000287388 4 0 0 0 0 0 0 326 164 273,525 0 0 contagem.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 575 125 253,893 22 49 brasilia.public.temp0000237664 3 0 0 0 0 0 0 741 258 420,401 0 0 rio.public.temp0000287709 3 0 0 0 0 0 0 158 15 11,650 0 0 rio.public.temp0000287653 3 0 0 0 0 0 0 204 18 14,662 0 0 rio.public.tmp_drill_0302 3 3 0 0 0 0 0 2,097 9 362,405 0 0 rio.public.temp0000287699 3 0 0 0 0 0 0 1,782 11 106,882 0 0 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 3,969 1,473 4,938,704 1,213 7,615 contagem.public.temp0000226782 3 0 0 0 0 0 0 324 119 191,824 0 0 rio.public.temp0000287701 3 0 0 0 0 0 0 140 11 10,004 0 0 brasilia.pg_catalog.pg_depend 3 3 0 0 0 0 0 878 267 355,281 12 120 rio.auditor.auditor_2026_08 3 0 0 0 0 0 0 103,312 46,056 59,844,672 28,603 545,165 rio.public.temp0000287651 2 0 0 0 0 0 0 1,778 10 106,375 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 365 111 447,686 41 99 contagem.public.nf_entrada 2 2 0 0 0 0 0 302 132 204,436 10 14 rio.public.temp0000287669 2 0 0 0 0 0 0 133 70 134,510 0 0 rio.public.temp0000287406 2 0 0 0 0 0 0 241 153 262,344 0 0 brasilia.auditor.auditor_2026_08 2 0 0 0 0 0 0 22,580 11,944 15,782,366 5,345 112,386 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,791 174 747,504 138 1,280 rio.public.temp0000287727 2 0 0 0 0 0 0 3,418 8 202,868 0 0 rio.public.temp0000287719 2 0 0 0 0 0 0 1,713 7 102,208 0 0 brasilia.public.temp0000237674 1 0 0 0 0 0 0 247 6 15,721 0 0 brasilia.public.temp0000237612 1 0 0 0 0 0 0 247 6 15,715 0 0 rio.public.temp0000287645 1 0 0 0 0 0 0 68 6 4,884 0 0 rio.public.temp0000287695 1 0 0 0 0 0 0 128 6 8,515 0 0 rio.public.temp0000287647 1 0 0 0 0 0 0 68 66 128,139 0 0 brasilia.public.temp0000237636 1 0 0 0 0 0 0 247 6 15,715 0 0 contagem.auditor.auditor_2026_08 1 0 0 0 0 0 0 12,953 6,554 8,686,961 3,153 53,574 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 155 5 17,255 0 0 brasilia.public.temp0000237684 1 0 0 0 0 0 0 247 246 390,440 0 0 brasilia.public.temp0000237648 1 0 0 0 0 0 0 247 6 15,715 0 0 rio.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 122 22 41,385 4 5 rio.public.temp0000287665 1 0 0 0 0 0 0 8 5 1,240 0 0 rio.public.temp0000287735 1 0 0 0 0 0 0 84 6 5,865 0 0 Total 527 230 0 0 0 0 0 337,792 97,884 154,071,589 41,193 739,282 Vacuum throughput per table
Key values
- auditor.auditor_2026_08 (13.66) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000287693 0 0 1.16 rio.pg_catalog.pg_attribute 0 0 2.94 rio.public.temp0000287659 0 0 0.48 rio.public.temp0000287629 0 0 1.02 rio.pg_catalog.pg_class 0 0 1 contagem.public.usuarios 0 0 0.01 rio.pg_catalog.pg_type 0 0 0.43 rio.public.temp0000287705 0 0 1.03 brasilia.pg_catalog.pg_attribute 0 0 1.14 rio.public.temp0000287312 0 0 0.19 rio.pg_catalog.pg_index 0 0 0.18 contagem.pg_catalog.pg_attribute 0 0 1.07 rio.pg_catalog.pg_depend 0 0 1.22 rio.pg_catalog.pg_statistic 0 0 1.56 rio.public.temp0000287715 0 0 0.37 rio.public.usuarios 0 0 0 rio.public.temp0000287306 0 0 0.07 brasilia.pg_catalog.pg_type 0 0 0.14 rio.public.tmp_drill_0320 0 0 0.11 brasilia.pg_catalog.pg_class 0 0 0.28 contagem.pg_catalog.pg_type 0 0 0.16 contagem.pg_catalog.pg_class 0 0 0.36 brasilia.pg_catalog.pg_index 0 0 0.07 contagem.pg_catalog.pg_depend 0 0 0.4 contagem.public.temp0000226776 0 0 0.07 contagem.pg_catalog.pg_index 0 0 0.08 rio.public.temp0000287679 0 0 0.26 rio.public.temp0000287454 0 0 0.05 postgres.pg_catalog.pg_shdepend 0 0 0.52 rio.public.temp0000287649 0 0 0.19 rio.pg_toast.pg_toast_2619 0 0 0.16 rio.public.temp0000287388 0 0 0.06 contagem.pg_catalog.pg_shdepend 0 0 0.21 brasilia.public.temp0000237664 0 0 0.06 rio.public.temp0000287709 0 0 0.02 rio.public.temp0000287653 0 0 0.02 rio.public.tmp_drill_0302 0 0 0.06 rio.public.temp0000287699 0 0 0.09 brasilia.pg_catalog.pg_statistic 0 0 0.39 contagem.public.temp0000226782 0 0 0.04 rio.public.temp0000287701 0 0 0 brasilia.pg_catalog.pg_depend 0 0 0.37 rio.auditor.auditor_2026_08 0 0 13.66 rio.public.temp0000287651 0 0 0.05 brasilia.pg_toast.pg_toast_2619 0 0 0.01 contagem.public.nf_entrada 0 0 0.14 rio.public.temp0000287669 0 0 0.01 rio.public.temp0000287406 0 0 0.04 brasilia.auditor.auditor_2026_08 0 0 4.67 contagem.pg_catalog.pg_statistic 0 0 0.14 rio.public.temp0000287727 0 0 0.11 rio.public.temp0000287719 0 0 0.1 brasilia.public.temp0000237674 0 0 0.02 brasilia.public.temp0000237612 0 0 0.02 rio.public.temp0000287645 0 0 0.02 rio.public.temp0000287695 0 0 0.02 rio.public.temp0000287647 0 0 0.01 brasilia.public.temp0000237636 0 0 0.02 contagem.auditor.auditor_2026_08 0 0 3.27 contagem.pg_toast.pg_toast_2619 0 0 0.01 brasilia.public.temp0000237684 0 0 0.02 brasilia.public.temp0000237648 0 0 0.02 rio.pg_catalog.pg_shdepend 0 0 0.05 rio.public.temp0000287665 0 0 0.01 rio.public.temp0000287735 0 0 0.01 Total 0 0 40.47 Tuples removed per table
Key values
- pg_catalog.pg_attribute (173792) Main table with removed tuples on database rio
- 472177 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 42 40 173,792 1,021,868 27,007 275 24,685 contagem.pg_catalog.pg_attribute 11 11 78,941 262,917 0 723 6,004 brasilia.pg_catalog.pg_attribute 15 15 65,265 335,346 0 81 8,456 rio.public.tmp_drill_0320 8 4 34,507 43,971 4,732 0 1,002 rio.public.tmp_drill_0302 3 3 30,314 31,919 0 0 806 rio.pg_catalog.pg_statistic 10 10 16,438 85,125 987 0 12,860 rio.pg_catalog.pg_depend 10 10 8,920 193,725 3,260 0 1,870 rio.pg_catalog.pg_type 22 22 7,260 51,650 1,352 32 1,553 contagem.pg_catalog.pg_type 7 7 6,228 15,737 0 74 458 brasilia.auditor.auditor_2026_08 2 0 6,117 1,736,593 0 0 79,554 brasilia.pg_catalog.pg_statistic 3 3 5,850 24,307 0 0 3,216 contagem.pg_catalog.pg_statistic 2 2 5,405 14,917 0 0 2,022 contagem.pg_catalog.pg_shdepend 4 4 4,173 53,745 1 0 476 rio.pg_catalog.pg_class 26 25 3,939 95,001 4,363 40 3,397 rio.pg_catalog.pg_index 14 13 3,573 27,677 785 0 799 postgres.pg_catalog.pg_shdepend 4 4 3,324 54,313 2 0 476 brasilia.pg_catalog.pg_type 8 8 2,988 17,888 10 11 528 contagem.pg_catalog.pg_index 5 5 2,869 9,483 0 31 258 brasilia.pg_catalog.pg_depend 3 3 2,098 54,301 0 0 531 rio.auditor.auditor_2026_08 3 0 1,820 9,901,003 0 0 479,453 contagem.public.usuarios 23 0 1,490 552 0 0 46 brasilia.pg_catalog.pg_index 5 5 1,324 9,429 0 12 261 rio.pg_toast.pg_toast_2619 4 4 1,127 2,517 0 0 1,020 brasilia.pg_catalog.pg_class 8 8 1,117 28,176 0 40 982 rio.pg_catalog.pg_shdepend 1 1 800 12,936 0 0 119 contagem.pg_catalog.pg_depend 5 5 646 95,905 0 57 854 contagem.public.nf_entrada 2 2 640 1,971 0 0 158 contagem.pg_catalog.pg_class 6 6 596 21,150 0 84 879 rio.public.usuarios 10 7 304 6,353 1,263 0 170 brasilia.pg_toast.pg_toast_2619 2 2 182 291 0 0 126 contagem.pg_toast.pg_toast_2619 1 1 130 117 0 7 55 rio.public.temp0000287659 34 0 0 137,372 0 642 4,542 rio.public.temp0000287454 4 0 0 16,738 0 134 378 brasilia.public.temp0000237664 3 0 0 9,549 0 51 717 rio.public.temp0000287649 4 0 0 73,323 0 4 5,244 brasilia.public.temp0000237674 1 0 0 3,186 0 17 239 rio.public.temp0000287709 3 0 0 3,521 0 118 202 rio.public.temp0000287653 3 0 0 3,034 0 12 180 brasilia.public.temp0000237612 1 0 0 3,183 0 17 239 rio.public.temp0000287651 2 0 0 25,114 0 4 1,788 rio.public.temp0000287645 1 0 0 1,011 0 4 60 rio.public.temp0000287312 14 0 0 56,370 0 441 1,255 rio.public.temp0000287699 3 0 0 49,270 0 0 3,520 rio.public.temp0000287306 9 0 0 50,549 0 266 1,142 rio.public.temp0000287669 2 0 0 2,029 0 4 124 rio.public.temp0000287695 1 0 0 5,358 0 8 120 rio.public.temp0000287406 2 0 0 10,019 0 95 225 contagem.public.temp0000226782 3 0 0 3,902 0 84 300 rio.public.temp0000287647 1 0 0 1,011 0 4 60 brasilia.public.temp0000237636 1 0 0 3,183 0 17 239 rio.public.temp0000287629 30 0 0 424,193 0 29 30,179 contagem.auditor.auditor_2026_08 1 0 0 591,785 0 0 29,321 rio.public.temp0000287701 3 0 0 3,232 0 0 192 rio.public.temp0000287705 20 0 0 459,117 0 57 32,903 rio.public.temp0000287693 80 0 0 583,680 0 1,820 24,484 contagem.public.temp0000226776 5 0 0 6,491 0 140 500 brasilia.public.temp0000237684 1 0 0 3,188 0 17 239 rio.public.temp0000287715 10 0 0 149,071 0 244 10,636 brasilia.public.temp0000237648 1 0 0 3,183 0 17 239 rio.public.temp0000287727 2 0 0 48,184 0 0 3,456 rio.public.temp0000287719 2 0 0 48,174 0 0 3,456 rio.public.temp0000287388 4 0 0 20,305 0 115 461 rio.public.temp0000287665 1 0 0 2,351 0 12 52 rio.public.temp0000287679 5 0 0 120,389 0 0 8,640 rio.public.temp0000287735 1 0 0 1,308 0 52 76 Total 527 230 472,177 17,133,256 43,762 5,892 798,482 Pages removed per table
Key values
- public.temp0000287693 (1820) Main table with removed pages on database rio
- 5892 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000287693 80 0 0 1820 contagem.pg_catalog.pg_attribute 11 11 78941 723 rio.public.temp0000287659 34 0 0 642 rio.public.temp0000287312 14 0 0 441 rio.pg_catalog.pg_attribute 42 40 173792 275 rio.public.temp0000287306 9 0 0 266 rio.public.temp0000287715 10 0 0 244 contagem.public.temp0000226776 5 0 0 140 rio.public.temp0000287454 4 0 0 134 rio.public.temp0000287709 3 0 0 118 rio.public.temp0000287388 4 0 0 115 rio.public.temp0000287406 2 0 0 95 contagem.public.temp0000226782 3 0 0 84 contagem.pg_catalog.pg_class 6 6 596 84 brasilia.pg_catalog.pg_attribute 15 15 65265 81 contagem.pg_catalog.pg_type 7 7 6228 74 contagem.pg_catalog.pg_depend 5 5 646 57 rio.public.temp0000287705 20 0 0 57 rio.public.temp0000287735 1 0 0 52 brasilia.public.temp0000237664 3 0 0 51 rio.pg_catalog.pg_class 26 25 3939 40 brasilia.pg_catalog.pg_class 8 8 1117 40 rio.pg_catalog.pg_type 22 22 7260 32 contagem.pg_catalog.pg_index 5 5 2869 31 rio.public.temp0000287629 30 0 0 29 brasilia.public.temp0000237674 1 0 0 17 brasilia.public.temp0000237612 1 0 0 17 brasilia.public.temp0000237636 1 0 0 17 brasilia.public.temp0000237684 1 0 0 17 brasilia.public.temp0000237648 1 0 0 17 brasilia.pg_catalog.pg_index 5 5 1324 12 rio.public.temp0000287653 3 0 0 12 rio.public.temp0000287665 1 0 0 12 brasilia.pg_catalog.pg_type 8 8 2988 11 rio.public.temp0000287695 1 0 0 8 contagem.pg_toast.pg_toast_2619 1 1 130 7 rio.public.temp0000287649 4 0 0 4 rio.public.temp0000287651 2 0 0 4 rio.public.temp0000287645 1 0 0 4 rio.public.temp0000287669 2 0 0 4 rio.public.temp0000287647 1 0 0 4 postgres.pg_catalog.pg_shdepend 4 4 3324 0 rio.pg_catalog.pg_depend 10 10 8920 0 rio.public.tmp_drill_0320 8 4 34507 0 rio.public.tmp_drill_0302 3 3 30314 0 brasilia.pg_toast.pg_toast_2619 2 2 182 0 rio.public.temp0000287699 3 0 0 0 contagem.public.nf_entrada 2 2 640 0 brasilia.pg_catalog.pg_statistic 3 3 5850 0 rio.pg_toast.pg_toast_2619 4 4 1127 0 contagem.public.usuarios 23 0 1490 0 rio.pg_catalog.pg_statistic 10 10 16438 0 brasilia.auditor.auditor_2026_08 2 0 6117 0 contagem.auditor.auditor_2026_08 1 0 0 0 contagem.pg_catalog.pg_statistic 2 2 5405 0 rio.public.temp0000287701 3 0 0 0 brasilia.pg_catalog.pg_depend 3 3 2098 0 rio.public.usuarios 10 7 304 0 rio.pg_catalog.pg_index 14 13 3573 0 rio.public.temp0000287727 2 0 0 0 rio.public.temp0000287719 2 0 0 0 rio.pg_catalog.pg_shdepend 1 1 800 0 rio.auditor.auditor_2026_08 3 0 1820 0 rio.public.temp0000287679 5 0 0 0 contagem.pg_catalog.pg_shdepend 4 4 4173 0 Total 527 230 472,177 5,892 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 06 00 1 2 01 0 8 02 0 0 03 0 0 04 0 4 05 6 6 06 0 1 07 13 22 08 24 71 09 30 84 10 57 127 11 51 108 12 11 32 13 43 82 14 66 137 15 74 158 16 55 148 17 86 126 18 0 0 19 0 0 20 0 0 21 5 9 22 5 1 23 0 0 - 6.73 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 4 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 2 3m23s 1m36s 1m46s 1m41s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-06 07:47:00 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-06 14:46:54 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-06 20:15:16 Database: rio User: intelifix Remote: [local] Application: psql
2 1 1s39ms 1s39ms 1s39ms 1s39ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (51278, 416, '835237935003041,241708787390,241604324255,241713345164,241664784757,241704657088,241680302344,241617412132,241606694767,241609877995,241632281821,241678311319,241649685573,241671570325,241713712428,241663850918,241668191521,241676762234,241691219604,241647348296,241659887073,241656696268,241729562325,241676825977,241704341424,241615881433,241673086577,241730911436,241704329402,241676706975,241676710613,241673347691,241607229397,241620869102,241689115762,241678290812,241727085562,241652016687,241695609909,241616949303,241646326266,241669453350,241680505977,241676812037,241617357883,241617420820,241727042629,241639279406,241695570007,241660138691,241680299313', '',0321,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-06 15:07:49 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (51280, 407, 'ZTE3ANNT2V71640,D83139921DE8,D83139921DE9,ZTEGDD310A57$ZTE3ANNRC559251,6C11BA679689,6C11BA67968A,ZTEGDC6EFD32$ZTE3ANNT3H17813,D83139986516,D83139986517,ZTEGDD321634$ZTE3ANNRCP02167,6C11BA695D99,6C11BA695D9A,ZTEGDC6F490A$ZTE3ANNRC552370,6C11BA66F543,6C11BA66F544,ZTEGDC6EE251$ZTE3ANNR3Y01650,4896D94FE764,4896D94FE765,ZTEGD97E3727$ZTE3ANNR8C34398,38914851AD3B,38914851AD3C,ZTEGDB0906CE$ZTE3ANNR9F14472,D89A0DA43113,D89A0DA43114,ZTEGDB155FD3$ZTE3ANNR9F58172,D89A0DA8314B,D89A0DA8314C,ZTEGDB160A87$ZTE3ANNR8C27032,389148510097,389148510098,ZTEGDB08EA08$ZTE3ANNRCB24710,D83139201222,D83139201223,ZTEGDD2A161B$ZTE3ANNT2V50458,D83139902D74,D83139902D75,ZTEGDD30B799$ZTE3ANNRAM61812,5872C98CE0F1,5872C98CE0F2,ZTEGDC60F173$ZTE3ANNRCB04921,D831391E4254,D831391E4255,ZTEGDD29C8CE$ZTE3ANNQ8M29799,843C99218255,843C99218256,ZTEGD7BABBD4$ZTE3ANNT3H83271,D831399E6342,D831399E6343,ZTEGDD3315E6$ZTE3ANNR1Y12650,14CA56CDD2F7,14CA56CDD2F8,ZTEGD970A7C5$ZTE3ANNR7B16859,3891484A77C9,3891484A77CA,ZTEGDB07D33B$ZTE3ANNR3J06957,F4E84F86F16E,F4E84F86F16F,ZTEGD97B7CF7$ZTE3ANNR8C09687,3891484F6A11,3891484F6A12,ZTEGDB08A647$ZTE3ANNQ4N05998,3CF9F0A91E42,3CF9F0A91E43,ZTEGD6411A69$ZTE3ANNQ4N06163,3CF9F0A92220,3CF9F0A92221,ZTEGD6411B0E$ZTE3ANNRCB04745,D831391E3E34,D831391E3E35,ZTEGDD29C81E$ZTE3ANNR9343438,D89A0D865A1F,D89A0D865A20,ZTEGDB151DAD$ZTE3ANNT4P40292,F00C514F56F6,F00C514F56F7,ZTEGDE3493FA$ZTE3ANNR6R23468,48D68237AACA,48D68237AACB,ZTEGDB01867F$ZTE3ANNR5W68544,48D68234CA4A,48D68234CA4B,ZTEGDB010BBF$ZTE3ANNQ8M16721,843C99204FD1,843C99204FD2,ZTEGD7BA88BE$ZTE3ANNT2V84856,D831399353A8,D831399353A9,ZTEGDD313DF7$ZTE3ANNRC501625,6C11BA624FED,6C11BA624FEE,ZTEGDC6E1C18$ZTE3ANNRB710331,5872C98F2B53,5872C98F2B54,ZTEGDC61532E$ZTE3ANNR6R25663,48D68237DE3C,48D68237DE3D,ZTEGDB018F12$ZTE3ANNQ8M16638,843C99204DDF,843C99204DE0,ZTEGD7BA886B$ZTE3ANNRCB03070,D831391E16F2,D831391E16F3,ZTEGDD29C193$ZTE3ANNT4P36203,F00C514EF720,F00C514EF721,ZTEGDE348401$ZTE3ANNRC558512,6C11BA678537,6C11BA678538,ZTEGDC6EFA4F$ZTE3ANNR7B17071,3891484A7CC1,3891484A7CC2,ZTEGDB07D40F$ZTE3ANNRC552195,6C11BA66F129,6C11BA66F12A,ZTEGDC6EE1A2$ZTE3ANNR9326575,D89A0D84CEE5,D89A0D84CEE6,ZTEGDB14DBCE', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-06 15:10:29 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (51247, 407, '270911029072105997,229669947698,229805239802,216940589415,229816217495,216944396778,229865996573,229934063744,229685445664,229933293759,229753801326,229837169797,229859791726,229787199411,229748610202,229747563242,229865270712,216943421824,229933344347,229806783758,229739804965,229925598899,229865768492,229850143747,229866009302,229809318607,229812660213,216936627490,229925328693,229751102140,229860353251,229686723556,229805260209,229737730622,229740314465,229782951522,216932032340,229670192526,229744075359,229670211316', '246472754459,246593072644,246474642242,246628817478,246456748990,246653659094,246254619601,246499746767,226055229816,246563151531,246641420606,246649933434,246598190708,246550662837,246550664049,246648241429,246468822235,226247001832,246581304155,246526362946,226007317788,246163529397,246642058805,246651698904,246627544257,246629633047,246463871516,246160730001,246566448181,246652022022,246513397583,246598448689,246527586566,246549798094,246602761435,246432670615,246514482830,246547263448,246488563443', 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-06 14:51:10 Database: contagem User: intelifix Remote: [local] Application: [unknown]
3 1 1s10ms 1s10ms 1s10ms 1s10ms drop table if exists temp0000287693;-
DROP TABLE IF EXISTS temp0000287693;
Date: 2026-08-06 17:20:36 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000287693;
Date: 2026-08-06 17:20:36 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 1m46s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-06 07:46:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1m36s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-06 14:46:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 1s39ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (51098, 416, 'ZTE3ANNR5W17931,48D68230280C,48D68230280D,ZTEGDB00460A$ZTE3ANNT4P36297,F00C514EF954,F00C514EF955,ZTEGDE34845F', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""}]','$','', 00);[ Date: 2026-08-06 13:23:24 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
4 1s10ms DROP TABLE IF EXISTS temp0000287693;[ Date: 2026-08-06 17:20:36 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,301 Total read queries
- 1,817 Total write queries
Queries by database
Key values
- rio Main database
- 4,331 Requests
- 6h35m29s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,481 Requests
User Request type Count Duration etiquetas Total 62 12s587ms select 62 12s587ms intelifix Total 6,481 8h42m54s copy to 414 46m37s ddl 1,403 52m43s others 542 52m16s select 4,122 6h11m16s lenon Total 117 1m4s select 117 1m4s Duration by user
Key values
- 8h42m54s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 62 12s587ms select 62 12s587ms intelifix Total 6,481 8h42m54s copy to 414 46m37s ddl 1,403 52m43s others 542 52m16s select 4,122 6h11m16s lenon Total 117 1m4s select 117 1m4s Queries by host
Key values
- [local] Main host
- 6,660 Requests
- 8h44m11s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,452 Requests
- 4h39m54s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-06 09:18:16 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,264 100-500ms duration
Slowest individual queries
Rank Duration Query 1 11m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-06 07:16:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 10m43s analyze verbose;[ Date: 2026-08-06 05:10:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 10m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-06 15:15:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 9m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-06 09:14:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 9m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-06 11:14:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 9m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-06 20:14:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA () NOTICE: table "tmp_entrada" does not exist, skipping;[ Date: 2026-08-06 16:13:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-06 12:13:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 8m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-06 10:13:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 8m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-06 14:13:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-06 18:12:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 7m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-06 17:12:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-06 19:11:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m22s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028120, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-06 16:07:54 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 6m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-06 21:11:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 6m16s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028108, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-06 14:31:30 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 6m10s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028100, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-06 11:32:34 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 6m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-06 08:11:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-06 22:10:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m49s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028079, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-06 07:21:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h9m54s 47 1s340ms 11m8s 2m45s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 06 07 3 11m51s 3m57s 08 3 6m22s 2m7s 09 3 10m36s 3m32s 10 3 8m52s 2m57s 11 3 10m1s 3m20s 12 3 9m24s 3m8s 13 3 5m58s 1m59s 14 3 8m56s 2m58s 15 3 10m53s 3m37s 16 2 40s454ms 20s227ms 17 3 8m31s 2m50s 18 3 8m20s 2m46s 19 3 6m40s 2m13s 20 3 9m51s 3m17s 21 3 6m38s 2m12s 22 3 6m13s 2m4s [ User: intelifix - Total duration: 2h9m54s - Times executed: 47 ]
[ Application: psql - Total duration: 2h9m54s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-06 07:16:09 Duration: 11m8s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-06 15:15:04 Duration: 10m3s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-06 09:14:51 Duration: 9m50s Database: rio User: intelifix Remote: [local] Application: psql
2 1h40m35s 327 152ms 6m22s 18s456ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 06 07 5 10m43s 2m8s 08 29 5m47s 11s970ms 09 38 16m30s 26s56ms 10 33 12m13s 22s226ms 11 26 8m35s 19s818ms 12 6 5m38s 56s379ms 13 18 3m53s 12s964ms 14 44 11m51s 16s161ms 15 44 8m16s 11s292ms 16 33 7m29s 13s627ms 17 47 8m5s 10s323ms 18 1 2s831ms 2s831ms 21 2 58s97ms 29s48ms 22 1 30s571ms 30s571ms [ User: intelifix - Total duration: 1h40m35s - Times executed: 327 ]
[ Application: [unknown] - Total duration: 1h40m35s - Times executed: 327 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028120, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-06 16:07:54 Duration: 6m22s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028108, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-06 14:31:30 Duration: 6m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028100, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-06 11:32:34 Duration: 6m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h22m43s 47 206ms 4m59s 1m45s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 06 07 3 5m24s 1m48s 08 3 4m27s 1m29s 09 3 6m3s 2m1s 10 3 5m29s 1m49s 11 3 6m14s 2m4s 12 2 5m28s 2m44s 13 3 4m5s 1m21s 14 3 5m28s 1m49s 15 3 6m32s 2m10s 16 3 5m38s 1m52s 17 3 5m20s 1m46s 18 3 4m56s 1m38s 19 3 4m5s 1m21s 20 3 5m39s 1m53s 21 3 3m54s 1m18s 22 3 3m53s 1m17s [ User: intelifix - Total duration: 1h22m43s - Times executed: 47 ]
[ Application: psql - Total duration: 1h22m43s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-06 15:22:12 Duration: 4m59s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-06 11:21:08 Duration: 4m40s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-06 09:21:29 Duration: 4m38s Database: brasilia User: intelifix Remote: [local] Application: psql
4 18m7s 3 2m42s 10m43s 6m2s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 06 05 3 18m7s 6m2s [ User: intelifix - Total duration: 18m7s - Times executed: 3 ]
[ Application: psql - Total duration: 18m7s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-06 05:10:45 Duration: 10m43s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-06 05:15:26 Duration: 4m41s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-06 05:18:08 Duration: 2m42s Database: contagem User: intelifix Remote: [local] Application: psql
5 16m21s 1,140 150ms 8s306ms 861ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 06 07 26 15s799ms 607ms 08 109 1m20s 738ms 09 123 1m47s 872ms 10 134 1m49s 816ms 11 127 1m48s 853ms 12 37 38s202ms 1s32ms 13 89 1m28s 994ms 14 125 1m36s 772ms 15 172 3m11s 1s111ms 16 132 1m44s 789ms 17 66 41s413ms 627ms [ User: intelifix - Total duration: 16m21s - Times executed: 1140 ]
[ Application: [unknown] - Total duration: 16m21s - Times executed: 1140 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (51278, 416, '835237935003041,241708787390,241604324255,241713345164,241664784757,241704657088,241680302344,241617412132,241606694767,241609877995,241632281821,241678311319,241649685573,241671570325,241713712428,241663850918,241668191521,241676762234,241691219604,241647348296,241659887073,241656696268,241729562325,241676825977,241704341424,241615881433,241673086577,241730911436,241704329402,241676706975,241676710613,241673347691,241607229397,241620869102,241689115762,241678290812,241727085562,241652016687,241695609909,241616949303,241646326266,241669453350,241680505977,241676812037,241617357883,241617420820,241727042629,241639279406,241695570007,241660138691,241680299313', '',0321,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-06 15:07:49 Duration: 8s306ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (51280, 407, 'ZTE3ANNT2V71640,D83139921DE8,D83139921DE9,ZTEGDD310A57$ZTE3ANNRC559251,6C11BA679689,6C11BA67968A,ZTEGDC6EFD32$ZTE3ANNT3H17813,D83139986516,D83139986517,ZTEGDD321634$ZTE3ANNRCP02167,6C11BA695D99,6C11BA695D9A,ZTEGDC6F490A$ZTE3ANNRC552370,6C11BA66F543,6C11BA66F544,ZTEGDC6EE251$ZTE3ANNR3Y01650,4896D94FE764,4896D94FE765,ZTEGD97E3727$ZTE3ANNR8C34398,38914851AD3B,38914851AD3C,ZTEGDB0906CE$ZTE3ANNR9F14472,D89A0DA43113,D89A0DA43114,ZTEGDB155FD3$ZTE3ANNR9F58172,D89A0DA8314B,D89A0DA8314C,ZTEGDB160A87$ZTE3ANNR8C27032,389148510097,389148510098,ZTEGDB08EA08$ZTE3ANNRCB24710,D83139201222,D83139201223,ZTEGDD2A161B$ZTE3ANNT2V50458,D83139902D74,D83139902D75,ZTEGDD30B799$ZTE3ANNRAM61812,5872C98CE0F1,5872C98CE0F2,ZTEGDC60F173$ZTE3ANNRCB04921,D831391E4254,D831391E4255,ZTEGDD29C8CE$ZTE3ANNQ8M29799,843C99218255,843C99218256,ZTEGD7BABBD4$ZTE3ANNT3H83271,D831399E6342,D831399E6343,ZTEGDD3315E6$ZTE3ANNR1Y12650,14CA56CDD2F7,14CA56CDD2F8,ZTEGD970A7C5$ZTE3ANNR7B16859,3891484A77C9,3891484A77CA,ZTEGDB07D33B$ZTE3ANNR3J06957,F4E84F86F16E,F4E84F86F16F,ZTEGD97B7CF7$ZTE3ANNR8C09687,3891484F6A11,3891484F6A12,ZTEGDB08A647$ZTE3ANNQ4N05998,3CF9F0A91E42,3CF9F0A91E43,ZTEGD6411A69$ZTE3ANNQ4N06163,3CF9F0A92220,3CF9F0A92221,ZTEGD6411B0E$ZTE3ANNRCB04745,D831391E3E34,D831391E3E35,ZTEGDD29C81E$ZTE3ANNR9343438,D89A0D865A1F,D89A0D865A20,ZTEGDB151DAD$ZTE3ANNT4P40292,F00C514F56F6,F00C514F56F7,ZTEGDE3493FA$ZTE3ANNR6R23468,48D68237AACA,48D68237AACB,ZTEGDB01867F$ZTE3ANNR5W68544,48D68234CA4A,48D68234CA4B,ZTEGDB010BBF$ZTE3ANNQ8M16721,843C99204FD1,843C99204FD2,ZTEGD7BA88BE$ZTE3ANNT2V84856,D831399353A8,D831399353A9,ZTEGDD313DF7$ZTE3ANNRC501625,6C11BA624FED,6C11BA624FEE,ZTEGDC6E1C18$ZTE3ANNRB710331,5872C98F2B53,5872C98F2B54,ZTEGDC61532E$ZTE3ANNR6R25663,48D68237DE3C,48D68237DE3D,ZTEGDB018F12$ZTE3ANNQ8M16638,843C99204DDF,843C99204DE0,ZTEGD7BA886B$ZTE3ANNRCB03070,D831391E16F2,D831391E16F3,ZTEGDD29C193$ZTE3ANNT4P36203,F00C514EF720,F00C514EF721,ZTEGDE348401$ZTE3ANNRC558512,6C11BA678537,6C11BA678538,ZTEGDC6EFA4F$ZTE3ANNR7B17071,3891484A7CC1,3891484A7CC2,ZTEGDB07D40F$ZTE3ANNRC552195,6C11BA66F129,6C11BA66F12A,ZTEGDC6EE1A2$ZTE3ANNR9326575,D89A0D84CEE5,D89A0D84CEE6,ZTEGDB14DBCE', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-06 15:10:29 Duration: 6s591ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (51247, 407, '270911029072105997,229669947698,229805239802,216940589415,229816217495,216944396778,229865996573,229934063744,229685445664,229933293759,229753801326,229837169797,229859791726,229787199411,229748610202,229747563242,229865270712,216943421824,229933344347,229806783758,229739804965,229925598899,229865768492,229850143747,229866009302,229809318607,229812660213,216936627490,229925328693,229751102140,229860353251,229686723556,229805260209,229737730622,229740314465,229782951522,216932032340,229670192526,229744075359,229670211316', '246472754459,246593072644,246474642242,246628817478,246456748990,246653659094,246254619601,246499746767,226055229816,246563151531,246641420606,246649933434,246598190708,246550662837,246550664049,246648241429,246468822235,226247001832,246581304155,246526362946,226007317788,246163529397,246642058805,246651698904,246627544257,246629633047,246463871516,246160730001,246566448181,246652022022,246513397583,246598448689,246527586566,246549798094,246602761435,246432670615,246514482830,246547263448,246488563443', 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-06 14:51:10 Duration: 5s446ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
6 14m1s 277 157ms 1m51s 3s38ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 06 00 12 34s91ms 2s840ms 01 12 23s593ms 1s966ms 02 12 22s325ms 1s860ms 03 13 22s641ms 1s741ms 04 12 23s148ms 1s929ms 05 12 22s305ms 1s858ms 06 12 24s512ms 2s42ms 07 12 2m12s 11s6ms 08 12 24s894ms 2s74ms 09 12 27s791ms 2s315ms 10 12 28s445ms 2s370ms 11 12 31s731ms 2s644ms 12 12 24s379ms 2s31ms 13 12 25s515ms 2s126ms 14 12 2m6s 10s514ms 15 12 31s701ms 2s641ms 16 12 31s30ms 2s585ms 17 12 32s717ms 2s726ms 18 12 27s645ms 2s303ms 19 12 29s748ms 2s479ms 20 12 40s967ms 3s413ms 21 12 27s965ms 2s330ms 22 12 26s332ms 2s194ms [ User: intelifix - Total duration: 14m1s - Times executed: 277 ]
[ Application: psql - Total duration: 14m1s - Times executed: 277 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-06 07:47:00 Duration: 1m51s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-06 14:46:54 Duration: 1m41s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-06 20:15:16 Duration: 14s980ms Database: rio User: intelifix Remote: [local] Application: psql
7 11m7s 162 155ms 17s294ms 4s117ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 06 00 6 29s905ms 4s984ms 01 6 12s556ms 2s92ms 02 6 12s202ms 2s33ms 03 5 15s789ms 3s157ms 04 6 14s379ms 2s396ms 05 3 14s110ms 4s703ms 07 11 50s559ms 4s596ms 08 12 1m9s 5s789ms 09 12 1m7s 5s637ms 10 12 1m3s 5s305ms 11 12 1m14s 6s190ms 12 13 52s904ms 4s69ms 13 9 9s917ms 1s101ms 14 11 50s852ms 4s622ms 15 12 53s679ms 4s473ms 16 10 33s556ms 3s355ms 17 6 9s898ms 1s649ms 21 4 15s253ms 3s813ms 22 6 16s376ms 2s729ms [ User: intelifix - Total duration: 11m7s - Times executed: 162 ]
[ Application: psql - Total duration: 11m7s - Times executed: 162 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-06 00:05:18 Duration: 17s294ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-06 09:55:16 Duration: 15s112ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-06 08:55:15 Duration: 13s649ms Database: rio User: intelifix Remote: [local] Application: psql
8 10m58s 1,073 150ms 4s159ms 613ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 06 07 59 47s466ms 804ms 08 127 1m42s 810ms 09 127 1m4s 510ms 10 141 1m20s 568ms 11 158 1m27s 556ms 12 47 24s296ms 516ms 13 89 44s819ms 503ms 14 124 1m11s 578ms 15 92 1m13s 802ms 16 94 52s515ms 558ms 17 15 8s4ms 533ms [ User: intelifix - Total duration: 10m58s - Times executed: 1073 ]
[ Application: [unknown] - Total duration: 10m58s - Times executed: 1073 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "108194", "modelo" : "320", "itens" : "241594112731,241604803146,241619547693,241598932629,241607110016,241616158484,241604600422,241620624454,241607655051,241604591835,241630942027,241599430613,241610896467,241604545971,241630950210,241620590411,241608842429,241606095056,241619346383,241631082445,241631043249,241604810521,241593830022,241628174652,241602897381,241615082533,241630003641,241628151418,241606009515,241619534561,241604821835,241634864452,241595266670,241599509610,241631504360,241631578586,241597429407,241628215868,241616121232,241599429400,241630937480,241630948794,241617324648", "usuario" : "414", "caixa" : "1298789", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-06 08:37:54 Duration: 4s159ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "274779", "modelo" : "320", "itens" : "241602691829,241710352336,241664021821,241629093642,241691042135,241628136466,241601111327,241629914867,230043549097,241695607888,241595010810,241710303543,241664255760,241635607285,241675347886,241649316266,241675283941,241667075968,241699136280,241691073855,241638330717,241669587279,241703929004,241669531820,241713041319,241715051919,241598874363,241598835975,241632300308,241653305769,241703744463,230048422941,241610935461,241673298999,241660133035,241621160321,241732121419,241629266262,241649212845,241664842440,241654115455,241728361939,241716649011,241596213138,241731464856,241689718100,241651977794,241669539901", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-06 08:12:59 Duration: 3s95ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "274907", "modelo" : "141", "itens" : "229786451830,229836654159,229864903246,229750661435,229690622444,229740274764,229685975873,229685587901,229741733739,229669704364,229879812636,229736156281,229813077278,229673025260,229864991313,229864982850,216939420525,229739432931,229813837184,229745212732,216935892234,229748953849,216941729515,229785346076,229860212631,216932367377,229685194147,229816765057", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246596334769,246640844758,246648119901,246562942543,246518020920,246558989306,246519290606,246524653037,246528389810,246514248283,246652211031,246526733745,246630752539,246499143847,246649820517,246649816374,246463681419,246528473960,246628265371,246535456773,246441740928,246550995877,246470867282,246598371029,246648336162,246433454058,246499568489,246628872030,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-06 14:49:05 Duration: 2s760ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10m19s 53 9s650ms 13s966ms 11s680ms create table temp0000287629 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 06 07 10 1m48s 10s855ms 08 9 1m46s 11s788ms 09 12 2m22s 11s909ms 10 8 1m34s 11s809ms 11 5 1m1s 12s354ms 12 9 1m45s 11s694ms [ User: intelifix - Total duration: 10m19s - Times executed: 53 ]
[ Application: [unknown] - Total duration: 10m19s - Times executed: 53 ]
-
CREATE TABLE temp0000287629 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 11:25:05 Duration: 13s966ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287629 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 12:20:16 Duration: 13s756ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287629 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 11:24:48 Duration: 13s385ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 8m51s 1 8m51s 8m51s 8m51s select * from rs_smart_fiscal_entrada () notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 06 16 1 8m51s 8m51s [ User: intelifix - Total duration: 8m51s - Times executed: 1 ]
[ Application: psql - Total duration: 8m51s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA () NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-08-06 16:13:53 Duration: 8m51s Database: rio User: intelifix Remote: [local] Application: psql
11 6m50s 37 9s835ms 12s874ms 11s100ms create table temp0000287693 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 06 16 12 2m17s 11s428ms 17 25 4m33s 10s943ms [ User: intelifix - Total duration: 6m50s - Times executed: 37 ]
[ Application: [unknown] - Total duration: 6m50s - Times executed: 37 ]
-
CREATE TABLE temp0000287693 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 17:30:07 Duration: 12s874ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287693 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 16:38:43 Duration: 12s762ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287693 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 16:25:20 Duration: 12s477ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 5m49s 55 1s464ms 27s949ms 6s355ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 06 07 2 7s532ms 3s766ms 08 1 11s681ms 11s681ms 09 3 18s154ms 6s51ms 10 3 7s795ms 2s598ms 11 10 54s929ms 5s492ms 13 3 20s680ms 6s893ms 14 7 45s739ms 6s534ms 15 6 50s545ms 8s424ms 16 9 58s501ms 6s500ms 17 9 38s701ms 4s300ms 21 2 35s291ms 17s645ms [ User: intelifix - Total duration: 5m49s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 5m49s - Times executed: 55 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-06', 0320, '', '', 0, 6, '2026-08-01');
Date: 2026-08-06 21:12:55 Duration: 27s949ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-06', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-06 15:54:05 Duration: 12s278ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-06', 0302, '', '', 0, 6, '2026-08-06');
Date: 2026-08-06 08:47:19 Duration: 11s681ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 5m21s 27 10s277ms 15s206ms 11s924ms create table temp0000287705 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 06 13 2 27s339ms 13s669ms 15 9 1m52s 12s514ms 16 1 12s297ms 12s297ms 17 15 2m49s 11s313ms [ User: intelifix - Total duration: 5m21s - Times executed: 27 ]
[ Application: [unknown] - Total duration: 5m21s - Times executed: 27 ]
-
CREATE TABLE temp0000287705 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 13:47:35 Duration: 15s206ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287705 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 15:18:25 Duration: 13s610ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287705 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 15:24:24 Duration: 13s82ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 5m17s 24 10s589ms 37s412ms 13s232ms create table temp0000287715 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 06 14 15 3m25s 13s729ms 15 6 1m17s 12s922ms 16 3 34s100ms 11s366ms [ User: intelifix - Total duration: 5m17s - Times executed: 24 ]
[ Application: [unknown] - Total duration: 5m17s - Times executed: 24 ]
-
CREATE TABLE temp0000287715 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 14:23:23 Duration: 37s412ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287715 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 15:59:40 Duration: 14s663ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287715 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 15:59:58 Duration: 13s590ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 3m31s 53 2s880ms 13s307ms 3s991ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 06 08 3 12s871ms 4s290ms 09 3 9s994ms 3s331ms 10 3 10s550ms 3s516ms 11 3 11s430ms 3s810ms 12 3 10s433ms 3s477ms 13 3 9s925ms 3s308ms 14 2 6s334ms 3s167ms 15 4 24s5ms 6s1ms 16 5 21s315ms 4s263ms 17 6 24s924ms 4s154ms 18 4 15s640ms 3s910ms 19 4 13s221ms 3s305ms 20 4 14s760ms 3s690ms 21 3 10s334ms 3s444ms 22 3 15s784ms 5s261ms [ User: intelifix - Total duration: 3m31s - Times executed: 53 ]
[ Application: psql - Total duration: 3m31s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-06 15:20:14 Duration: 13s307ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-06 22:00:14 Duration: 9s32ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-06 08:20:09 Duration: 5s213ms Database: brasilia User: intelifix Remote: [local] Application: psql
16 3m18s 4 4s937ms 1m37s 49s547ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 06 20 2 1m42s 51s302ms 23 2 1m35s 47s792ms [ User: intelifix - Total duration: 3m18s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m18s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-06 20:09:05 Duration: 1m37s 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-06 23:16:40 Duration: 1m29s 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-06 23:36:24 Duration: 5s735ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 3m10s 48 152ms 25s97ms 3s975ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 06 07 3 25s465ms 8s488ms 08 2 9s206ms 4s603ms 09 2 13s44ms 6s522ms 10 3 13s804ms 4s601ms 11 6 20s116ms 3s352ms 12 2 18s574ms 9s287ms 13 1 1s460ms 1s460ms 14 4 27s189ms 6s797ms 15 7 8s881ms 1s268ms 16 10 39s521ms 3s952ms 17 8 13s549ms 1s693ms [ User: intelifix - Total duration: 3m10s - Times executed: 48 ]
[ Application: psql - Total duration: 3m10s - Times executed: 48 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028120);
Date: 2026-08-06 16:01:23 Duration: 25s97ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028079);
Date: 2026-08-06 07:15:04 Duration: 21s731ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028108);
Date: 2026-08-06 14:24:59 Duration: 18s987ms Database: rio User: intelifix Remote: [local] Application: psql
18 2m30s 13 10s561ms 13s512ms 11s592ms create table temp0000287659 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 06 10 6 1m10s 11s779ms 11 7 1m20s 11s431ms [ User: intelifix - Total duration: 2m30s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m30s - Times executed: 13 ]
-
CREATE TABLE temp0000287659 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 10:28:37 Duration: 13s512ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287659 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 11:16:36 Duration: 12s516ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287659 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 11:10:57 Duration: 11s981ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 2m24s 42 2s769ms 10s495ms 3s440ms create table temp0000287693 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 06 13 2 6s214ms 3s107ms 16 15 55s176ms 3s678ms 17 25 1m23s 3s324ms [ User: intelifix - Total duration: 2m24s - Times executed: 42 ]
[ Application: [unknown] - Total duration: 2m24s - Times executed: 42 ]
-
CREATE TABLE temp0000287693 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-08-2026", "ate" :"06-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-06 16:25:33 Duration: 10s495ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287693 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-08-2026", "ate" :"06-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-06 17:30:11 Duration: 3s809ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287693 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-08-2026", "ate" :"06-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-06 17:41:41 Duration: 3s791ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 2m10s 258 161ms 2s584ms 507ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 06 14 78 33s900ms 434ms 15 180 1m37s 539ms [ User: intelifix - Total duration: 2m10s - Times executed: 258 ]
[ Application: [unknown] - Total duration: 2m10s - Times executed: 258 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"131789","seriais":"241650561327,230048528911,241730744550,241655146274,241615178906,241694541837,241694470921,241689929411,241709420315,241709403545,241651033651,241694542443,241694542342,241694471830,241650569610,241618302230,241706508504,241615179411,241677405461,241630949906,241709397382,241631266682,241667239092,241645844648,241618298491,241630943340,241649465776,241630941825,241663243653,241679399315,241664923233,241691763249,241675200825,241670028691,241657201425,241674130507,241689924259,241638265659,241667814458,241653805672","usuario":"399","observacao":""}');
Date: 2026-08-06 15:27:52 Duration: 2s584ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"131789","seriais":"241709307373,241652413954,241660344851,241732940119,241645881622,241707014950,241649458402,241726190111,241733990210,241652240324,241652062730,241672016383,241660418898,241630013440,241677453446,241645867175,241608862532,241733964045,241704770411,241646713959,230040065559,241650572136,241616877578,230040233253,241667782738,241667782031,241593000614,241709085253,241691699505,241667778696,241618543847,241667782940","usuario":"399","observacao":""}');
Date: 2026-08-06 15:07:15 Duration: 2s51ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"131789","seriais":"241649470626,241605293351,241674849600,241618294855,241630942633,241675441331,241691761229,241675470829,241709416071,241674130305,241675448199,241638418200,241679337591,241652344654,241676861133,241604604159,241630927479,241630931723,241650575267,241674138587,241730744348,241658725557,241688211320,241638239999,241607665355,241655145870,241615093847,241667638302,241679339208,241645660512,241630940613,230048574852,241667835773,241630928590,241675469414,241618299603,241628197280,241635172339,241675445371,241604594461","usuario":"399","observacao":""}');
Date: 2026-08-06 15:28:04 Duration: 1s833ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,140 16m21s 150ms 8s306ms 861ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 06 07 26 15s799ms 607ms 08 109 1m20s 738ms 09 123 1m47s 872ms 10 134 1m49s 816ms 11 127 1m48s 853ms 12 37 38s202ms 1s32ms 13 89 1m28s 994ms 14 125 1m36s 772ms 15 172 3m11s 1s111ms 16 132 1m44s 789ms 17 66 41s413ms 627ms [ User: intelifix - Total duration: 16m21s - Times executed: 1140 ]
[ Application: [unknown] - Total duration: 16m21s - Times executed: 1140 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (51278, 416, '835237935003041,241708787390,241604324255,241713345164,241664784757,241704657088,241680302344,241617412132,241606694767,241609877995,241632281821,241678311319,241649685573,241671570325,241713712428,241663850918,241668191521,241676762234,241691219604,241647348296,241659887073,241656696268,241729562325,241676825977,241704341424,241615881433,241673086577,241730911436,241704329402,241676706975,241676710613,241673347691,241607229397,241620869102,241689115762,241678290812,241727085562,241652016687,241695609909,241616949303,241646326266,241669453350,241680505977,241676812037,241617357883,241617420820,241727042629,241639279406,241695570007,241660138691,241680299313', '',0321,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-06 15:07:49 Duration: 8s306ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (51280, 407, 'ZTE3ANNT2V71640,D83139921DE8,D83139921DE9,ZTEGDD310A57$ZTE3ANNRC559251,6C11BA679689,6C11BA67968A,ZTEGDC6EFD32$ZTE3ANNT3H17813,D83139986516,D83139986517,ZTEGDD321634$ZTE3ANNRCP02167,6C11BA695D99,6C11BA695D9A,ZTEGDC6F490A$ZTE3ANNRC552370,6C11BA66F543,6C11BA66F544,ZTEGDC6EE251$ZTE3ANNR3Y01650,4896D94FE764,4896D94FE765,ZTEGD97E3727$ZTE3ANNR8C34398,38914851AD3B,38914851AD3C,ZTEGDB0906CE$ZTE3ANNR9F14472,D89A0DA43113,D89A0DA43114,ZTEGDB155FD3$ZTE3ANNR9F58172,D89A0DA8314B,D89A0DA8314C,ZTEGDB160A87$ZTE3ANNR8C27032,389148510097,389148510098,ZTEGDB08EA08$ZTE3ANNRCB24710,D83139201222,D83139201223,ZTEGDD2A161B$ZTE3ANNT2V50458,D83139902D74,D83139902D75,ZTEGDD30B799$ZTE3ANNRAM61812,5872C98CE0F1,5872C98CE0F2,ZTEGDC60F173$ZTE3ANNRCB04921,D831391E4254,D831391E4255,ZTEGDD29C8CE$ZTE3ANNQ8M29799,843C99218255,843C99218256,ZTEGD7BABBD4$ZTE3ANNT3H83271,D831399E6342,D831399E6343,ZTEGDD3315E6$ZTE3ANNR1Y12650,14CA56CDD2F7,14CA56CDD2F8,ZTEGD970A7C5$ZTE3ANNR7B16859,3891484A77C9,3891484A77CA,ZTEGDB07D33B$ZTE3ANNR3J06957,F4E84F86F16E,F4E84F86F16F,ZTEGD97B7CF7$ZTE3ANNR8C09687,3891484F6A11,3891484F6A12,ZTEGDB08A647$ZTE3ANNQ4N05998,3CF9F0A91E42,3CF9F0A91E43,ZTEGD6411A69$ZTE3ANNQ4N06163,3CF9F0A92220,3CF9F0A92221,ZTEGD6411B0E$ZTE3ANNRCB04745,D831391E3E34,D831391E3E35,ZTEGDD29C81E$ZTE3ANNR9343438,D89A0D865A1F,D89A0D865A20,ZTEGDB151DAD$ZTE3ANNT4P40292,F00C514F56F6,F00C514F56F7,ZTEGDE3493FA$ZTE3ANNR6R23468,48D68237AACA,48D68237AACB,ZTEGDB01867F$ZTE3ANNR5W68544,48D68234CA4A,48D68234CA4B,ZTEGDB010BBF$ZTE3ANNQ8M16721,843C99204FD1,843C99204FD2,ZTEGD7BA88BE$ZTE3ANNT2V84856,D831399353A8,D831399353A9,ZTEGDD313DF7$ZTE3ANNRC501625,6C11BA624FED,6C11BA624FEE,ZTEGDC6E1C18$ZTE3ANNRB710331,5872C98F2B53,5872C98F2B54,ZTEGDC61532E$ZTE3ANNR6R25663,48D68237DE3C,48D68237DE3D,ZTEGDB018F12$ZTE3ANNQ8M16638,843C99204DDF,843C99204DE0,ZTEGD7BA886B$ZTE3ANNRCB03070,D831391E16F2,D831391E16F3,ZTEGDD29C193$ZTE3ANNT4P36203,F00C514EF720,F00C514EF721,ZTEGDE348401$ZTE3ANNRC558512,6C11BA678537,6C11BA678538,ZTEGDC6EFA4F$ZTE3ANNR7B17071,3891484A7CC1,3891484A7CC2,ZTEGDB07D40F$ZTE3ANNRC552195,6C11BA66F129,6C11BA66F12A,ZTEGDC6EE1A2$ZTE3ANNR9326575,D89A0D84CEE5,D89A0D84CEE6,ZTEGDB14DBCE', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-06 15:10:29 Duration: 6s591ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (51247, 407, '270911029072105997,229669947698,229805239802,216940589415,229816217495,216944396778,229865996573,229934063744,229685445664,229933293759,229753801326,229837169797,229859791726,229787199411,229748610202,229747563242,229865270712,216943421824,229933344347,229806783758,229739804965,229925598899,229865768492,229850143747,229866009302,229809318607,229812660213,216936627490,229925328693,229751102140,229860353251,229686723556,229805260209,229737730622,229740314465,229782951522,216932032340,229670192526,229744075359,229670211316', '246472754459,246593072644,246474642242,246628817478,246456748990,246653659094,246254619601,246499746767,226055229816,246563151531,246641420606,246649933434,246598190708,246550662837,246550664049,246648241429,246468822235,226247001832,246581304155,246526362946,226007317788,246163529397,246642058805,246651698904,246627544257,246629633047,246463871516,246160730001,246566448181,246652022022,246513397583,246598448689,246527586566,246549798094,246602761435,246432670615,246514482830,246547263448,246488563443', 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-06 14:51:10 Duration: 5s446ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 1,073 10m58s 150ms 4s159ms 613ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 06 07 59 47s466ms 804ms 08 127 1m42s 810ms 09 127 1m4s 510ms 10 141 1m20s 568ms 11 158 1m27s 556ms 12 47 24s296ms 516ms 13 89 44s819ms 503ms 14 124 1m11s 578ms 15 92 1m13s 802ms 16 94 52s515ms 558ms 17 15 8s4ms 533ms [ User: intelifix - Total duration: 10m58s - Times executed: 1073 ]
[ Application: [unknown] - Total duration: 10m58s - Times executed: 1073 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "108194", "modelo" : "320", "itens" : "241594112731,241604803146,241619547693,241598932629,241607110016,241616158484,241604600422,241620624454,241607655051,241604591835,241630942027,241599430613,241610896467,241604545971,241630950210,241620590411,241608842429,241606095056,241619346383,241631082445,241631043249,241604810521,241593830022,241628174652,241602897381,241615082533,241630003641,241628151418,241606009515,241619534561,241604821835,241634864452,241595266670,241599509610,241631504360,241631578586,241597429407,241628215868,241616121232,241599429400,241630937480,241630948794,241617324648", "usuario" : "414", "caixa" : "1298789", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-06 08:37:54 Duration: 4s159ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "274779", "modelo" : "320", "itens" : "241602691829,241710352336,241664021821,241629093642,241691042135,241628136466,241601111327,241629914867,230043549097,241695607888,241595010810,241710303543,241664255760,241635607285,241675347886,241649316266,241675283941,241667075968,241699136280,241691073855,241638330717,241669587279,241703929004,241669531820,241713041319,241715051919,241598874363,241598835975,241632300308,241653305769,241703744463,230048422941,241610935461,241673298999,241660133035,241621160321,241732121419,241629266262,241649212845,241664842440,241654115455,241728361939,241716649011,241596213138,241731464856,241689718100,241651977794,241669539901", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-06 08:12:59 Duration: 3s95ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "274907", "modelo" : "141", "itens" : "229786451830,229836654159,229864903246,229750661435,229690622444,229740274764,229685975873,229685587901,229741733739,229669704364,229879812636,229736156281,229813077278,229673025260,229864991313,229864982850,216939420525,229739432931,229813837184,229745212732,216935892234,229748953849,216941729515,229785346076,229860212631,216932367377,229685194147,229816765057", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246596334769,246640844758,246648119901,246562942543,246518020920,246558989306,246519290606,246524653037,246528389810,246514248283,246652211031,246526733745,246630752539,246499143847,246649820517,246649816374,246463681419,246528473960,246628265371,246535456773,246441740928,246550995877,246470867282,246598371029,246648336162,246433454058,246499568489,246628872030,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-06 14:49:05 Duration: 2s760ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 327 1h40m35s 152ms 6m22s 18s456ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 06 07 5 10m43s 2m8s 08 29 5m47s 11s970ms 09 38 16m30s 26s56ms 10 33 12m13s 22s226ms 11 26 8m35s 19s818ms 12 6 5m38s 56s379ms 13 18 3m53s 12s964ms 14 44 11m51s 16s161ms 15 44 8m16s 11s292ms 16 33 7m29s 13s627ms 17 47 8m5s 10s323ms 18 1 2s831ms 2s831ms 21 2 58s97ms 29s48ms 22 1 30s571ms 30s571ms [ User: intelifix - Total duration: 1h40m35s - Times executed: 327 ]
[ Application: [unknown] - Total duration: 1h40m35s - Times executed: 327 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028120, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-06 16:07:54 Duration: 6m22s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028108, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-06 14:31:30 Duration: 6m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028100, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-06 11:32:34 Duration: 6m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 277 14m1s 157ms 1m51s 3s38ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 06 00 12 34s91ms 2s840ms 01 12 23s593ms 1s966ms 02 12 22s325ms 1s860ms 03 13 22s641ms 1s741ms 04 12 23s148ms 1s929ms 05 12 22s305ms 1s858ms 06 12 24s512ms 2s42ms 07 12 2m12s 11s6ms 08 12 24s894ms 2s74ms 09 12 27s791ms 2s315ms 10 12 28s445ms 2s370ms 11 12 31s731ms 2s644ms 12 12 24s379ms 2s31ms 13 12 25s515ms 2s126ms 14 12 2m6s 10s514ms 15 12 31s701ms 2s641ms 16 12 31s30ms 2s585ms 17 12 32s717ms 2s726ms 18 12 27s645ms 2s303ms 19 12 29s748ms 2s479ms 20 12 40s967ms 3s413ms 21 12 27s965ms 2s330ms 22 12 26s332ms 2s194ms [ User: intelifix - Total duration: 14m1s - Times executed: 277 ]
[ Application: psql - Total duration: 14m1s - Times executed: 277 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-06 07:47:00 Duration: 1m51s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-06 14:46:54 Duration: 1m41s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-06 20:15:16 Duration: 14s980ms Database: rio User: intelifix Remote: [local] Application: psql
5 258 2m10s 161ms 2s584ms 507ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 06 14 78 33s900ms 434ms 15 180 1m37s 539ms [ User: intelifix - Total duration: 2m10s - Times executed: 258 ]
[ Application: [unknown] - Total duration: 2m10s - Times executed: 258 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"131789","seriais":"241650561327,230048528911,241730744550,241655146274,241615178906,241694541837,241694470921,241689929411,241709420315,241709403545,241651033651,241694542443,241694542342,241694471830,241650569610,241618302230,241706508504,241615179411,241677405461,241630949906,241709397382,241631266682,241667239092,241645844648,241618298491,241630943340,241649465776,241630941825,241663243653,241679399315,241664923233,241691763249,241675200825,241670028691,241657201425,241674130507,241689924259,241638265659,241667814458,241653805672","usuario":"399","observacao":""}');
Date: 2026-08-06 15:27:52 Duration: 2s584ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"131789","seriais":"241709307373,241652413954,241660344851,241732940119,241645881622,241707014950,241649458402,241726190111,241733990210,241652240324,241652062730,241672016383,241660418898,241630013440,241677453446,241645867175,241608862532,241733964045,241704770411,241646713959,230040065559,241650572136,241616877578,230040233253,241667782738,241667782031,241593000614,241709085253,241691699505,241667778696,241618543847,241667782940","usuario":"399","observacao":""}');
Date: 2026-08-06 15:07:15 Duration: 2s51ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"131789","seriais":"241649470626,241605293351,241674849600,241618294855,241630942633,241675441331,241691761229,241675470829,241709416071,241674130305,241675448199,241638418200,241679337591,241652344654,241676861133,241604604159,241630927479,241630931723,241650575267,241674138587,241730744348,241658725557,241688211320,241638239999,241607665355,241655145870,241615093847,241667638302,241679339208,241645660512,241630940613,230048574852,241667835773,241630928590,241675469414,241618299603,241628197280,241635172339,241675445371,241604594461","usuario":"399","observacao":""}');
Date: 2026-08-06 15:28:04 Duration: 1s833ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
6 162 11m7s 155ms 17s294ms 4s117ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 06 00 6 29s905ms 4s984ms 01 6 12s556ms 2s92ms 02 6 12s202ms 2s33ms 03 5 15s789ms 3s157ms 04 6 14s379ms 2s396ms 05 3 14s110ms 4s703ms 07 11 50s559ms 4s596ms 08 12 1m9s 5s789ms 09 12 1m7s 5s637ms 10 12 1m3s 5s305ms 11 12 1m14s 6s190ms 12 13 52s904ms 4s69ms 13 9 9s917ms 1s101ms 14 11 50s852ms 4s622ms 15 12 53s679ms 4s473ms 16 10 33s556ms 3s355ms 17 6 9s898ms 1s649ms 21 4 15s253ms 3s813ms 22 6 16s376ms 2s729ms [ User: intelifix - Total duration: 11m7s - Times executed: 162 ]
[ Application: psql - Total duration: 11m7s - Times executed: 162 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-06 00:05:18 Duration: 17s294ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-06 09:55:16 Duration: 15s112ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-06 08:55:15 Duration: 13s649ms Database: rio User: intelifix Remote: [local] Application: psql
7 153 36s446ms 150ms 555ms 238ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 06 00 1 298ms 298ms 01 15 3s461ms 230ms 04 5 847ms 169ms 05 5 987ms 197ms 07 7 1s884ms 269ms 08 15 3s366ms 224ms 09 14 3s620ms 258ms 10 22 5s30ms 228ms 11 21 4s848ms 230ms 12 11 2s660ms 241ms 13 4 1s131ms 282ms 14 14 3s694ms 263ms 15 18 4s407ms 244ms 16 1 208ms 208ms [ User: intelifix - Total duration: 36s446ms - Times executed: 153 ]
[ Application: [unknown] - Total duration: 36s446ms - Times executed: 153 ]
-
SELECT * FROM RS_TRIAGEM (310, 5, '63', 2, 'B0935BE9CD6D,B0DAF94F175D,BC644BDF4600,4C1265EB9D81,A8F5DDE48278,BC644BBF6C31,BC644BD7D5AA,BC644BD2BC69,5819F842A0ED,5819F8475ACF,A8F5DDEACED5,4C1265E6272F,4C1265EA8991,BC644BDD2FF0,A8F5DDEC8E91,BC644BCAB96F,CC75E2BDDDA5,5819F8420368,B0DAF965D70B,B0DAF950EAAB,F8F532536578,BC644BD73F3C,CC75E2C00C5B,A8F5DDEA4B8B,2C9569EF0894,B0DAF963CF60,CC75E2BF921C', NULL, NULL, 042, 00);
Date: 2026-08-06 13:44:54 Duration: 555ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (310, 5, '63', 2, '942CB374BD4D,E820E2D1A667,E820E29E3ABF,8C444FBC5C8F,E820E259996D,8C444FA0D019,E820E2199F09,8C444F06D179,E820E2D11DD2,E820E2F1BBE6,8C444FF1AF05,8C444F4999AD,8C444F5C48AC,90F30557396E,8C444F5CB548,90F3055B882D,E820E2EED5AE,E820E237BA41,E820E26F6150', NULL, NULL, 039, 00);
Date: 2026-08-06 09:55:27 Duration: 480ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (310, 5, '63', 2, '8C444F5EA8EF,E820E2D07D9D,8C444F410535,E820E272C756,942CB3ADBB2F,942CB3E41267,E820E25D1530,942CB3F51181,942CB3762595,E820E20AA93E,942CB3F5037A,942CB3E1A519,942CB3A5E01B,E820E2EC42F8,8C444F7CE36F,8C444F09A845,E820E27FA378,E820E26FE412,E820E2702963,942CB377EC09,942CB3EDDBE2,8C444FC45CCC,8C444F34FCEF', NULL, NULL, 039, 00);
Date: 2026-08-06 11:16:00 Duration: 478ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 139 2m2s 160ms 8s683ms 884ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 06 08 14 7s234ms 516ms 09 26 13s47ms 501ms 10 14 6s719ms 479ms 11 16 9s907ms 619ms 14 19 24s318ms 1s279ms 15 21 34s867ms 1s660ms 16 14 13s397ms 956ms 17 15 13s460ms 897ms [ User: intelifix - Total duration: 2m2s - Times executed: 139 ]
[ Application: [unknown] - Total duration: 2m2s - Times executed: 139 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0131789) LIMIT 1;
Date: 2026-08-06 15:32:48 Duration: 8s683ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0274751) LIMIT 1;
Date: 2026-08-06 16:42:41 Duration: 4s28ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0131663) LIMIT 1;
Date: 2026-08-06 14:42:38 Duration: 3s890ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
9 111 50s521ms 294ms 721ms 455ms 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 06 00 2 946ms 473ms 01 2 726ms 363ms 02 1 350ms 350ms 03 1 375ms 375ms 04 1 537ms 537ms 05 3 1s76ms 358ms 06 1 502ms 502ms 07 8 3s452ms 431ms 08 10 4s664ms 466ms 09 11 4s854ms 441ms 10 10 4s563ms 456ms 11 8 3s678ms 459ms 12 4 2s141ms 535ms 13 10 4s508ms 450ms 14 9 4s80ms 453ms 15 10 4s614ms 461ms 16 8 4s270ms 533ms 17 6 2s440ms 406ms 21 3 1s464ms 488ms 22 2 784ms 392ms 23 1 486ms 486ms [ User: lenon - Total duration: 50s521ms - Times executed: 111 ]
[ Application: [unknown] - Total duration: 50s521ms - Times executed: 111 ]
-
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-06 12:20:29 Duration: 721ms Database: brasilia 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-06 16:39:56 Duration: 719ms 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-06 11:24:48 Duration: 700ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
10 101 57s613ms 395ms 874ms 570ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 06 00 2 1s356ms 678ms 01 2 1s18ms 509ms 02 1 484ms 484ms 03 1 506ms 506ms 04 1 657ms 657ms 05 3 1s431ms 477ms 06 1 625ms 625ms 07 5 2s921ms 584ms 08 9 5s106ms 567ms 09 11 6s416ms 583ms 10 10 5s513ms 551ms 11 8 4s549ms 568ms 12 4 2s609ms 652ms 13 9 5s3ms 555ms 14 9 5s12ms 556ms 15 9 5s62ms 562ms 16 8 5s148ms 643ms 17 5 2s605ms 521ms 21 1 514ms 514ms 22 2 1s69ms 534ms [ User: intelifix - Total duration: 57s613ms - Times executed: 101 ]
[ Application: [unknown] - Total duration: 57s613ms - Times executed: 101 ]
-
select * from rs_menu_grants (428, 21, 1);
Date: 2026-08-06 12:20:29 Duration: 874ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (477, 19, 1);
Date: 2026-08-06 00:03:18 Duration: 859ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (416, 5, 1);
Date: 2026-08-06 16:39:56 Duration: 844ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
11 100 26s666ms 151ms 3s142ms 266ms create table temp0000287649 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 06 08 3 3s458ms 1s152ms 09 9 1s725ms 191ms 10 27 5s562ms 206ms 11 10 2s332ms 233ms 12 4 915ms 228ms 13 11 5s260ms 478ms 14 15 3s68ms 204ms 15 17 3s545ms 208ms 16 4 797ms 199ms [ User: intelifix - Total duration: 26s666ms - Times executed: 100 ]
[ Application: [unknown] - Total duration: 26s666ms - Times executed: 100 ]
-
CREATE TABLE temp0000287649 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-08-2026", "ate" :"06-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-06 08:12:32 Duration: 3s142ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287649 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-08-2026", "ate" :"06-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-06 13:40:49 Duration: 2s733ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287649 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-08-2026", "ate" :"06-08-2026", "nota-fiscal":"2133", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-06 14:08:01 Duration: 316ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 87 36s321ms 228ms 701ms 417ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 06 07 4 1s565ms 391ms 08 7 3s112ms 444ms 09 2 929ms 464ms 10 9 3s516ms 390ms 11 6 2s577ms 429ms 12 4 1s554ms 388ms 13 6 2s586ms 431ms 14 5 1s863ms 372ms 15 13 6s280ms 483ms 16 12 4s927ms 410ms 17 19 7s406ms 389ms [ User: intelifix - Total duration: 36s321ms - Times executed: 87 ]
[ Application: [unknown] - Total duration: 36s321ms - Times executed: 87 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-06 15:56:49 Duration: 701ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-08-06 15:20:29 Duration: 700ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-06 17:20:49 Duration: 649ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 85 25s590ms 180ms 2s897ms 301ms create table temp0000287699 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 06 13 11 5s483ms 498ms 14 16 3s878ms 242ms 15 10 2s953ms 295ms 16 28 7s921ms 282ms 17 20 5s353ms 267ms [ User: intelifix - Total duration: 25s590ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 25s590ms - Times executed: 85 ]
-
CREATE TABLE temp0000287699 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-08-2026", "ate" :"06-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-06 13:33:37 Duration: 2s897ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287699 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-08-2026", "ate" :"06-08-2026", "nota-fiscal":"124", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-06 16:17:15 Duration: 385ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287699 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-08-2026", "ate" :"06-08-2026", "nota-fiscal":"124", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-06 17:11:37 Duration: 359ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 84 38s861ms 150ms 1s188ms 462ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 06 08 3 2s393ms 797ms 09 10 5s740ms 574ms 10 8 5s76ms 634ms 11 12 5s80ms 423ms 13 9 2s844ms 316ms 14 15 7s153ms 476ms 15 15 6s110ms 407ms 16 8 3s116ms 389ms 17 4 1s344ms 336ms [ User: intelifix - Total duration: 38s861ms - Times executed: 84 ]
[ Application: [unknown] - Total duration: 38s861ms - Times executed: 84 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '3CF9F0AD07C4,6C11BA6FF273,C4EBFF9028E6,843C99224EE5,F4E84F8387A2,843C992256FB,4896D9563BAC,4896D95710EE,14CA56CFA7C3,D89A0DAD2E0D,6C11BA66CF57,6C11BA62CD99,843C99224813,4896D954771E,C4EBFF903054,3CF9F0A8E5C6,5872C98D9F8F,14CA56CF97BB,689E29BC2479,F4E84F864596,14CA56CDB68F,F4E84F899834,F4E84F80FFA2,D831398E55AE,D8313921DD1C,3891484AA6D3,3CF9F0A6FBFA,4896D952789A,14CA56CFF149,3891484AA04F,14CA56D742D5,843C992C6BA3,48D68232D856,843C9922B14F,14CA56CDC7F3,843C99228C11,D8313991C01C,5872C994C04F,48D682311A04,F4E84F8677E8', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-08-06 10:51:43 Duration: 1s188ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'A0FF7082FB3C,5C7D7D65E4A4,484BD47DD41C,A0FF70287B84,5C7D7D62B4BC,484BD47AF984,6C55E8CB912C,484BD48EB35C,5C7D7D74B30C,A0FF70256294,A0FF70D33064,484BD4A40F24,A0FF70D2D82C,A0FF7086AA8C,5C7D7D715834,484BD4A08104,484BD4863FFC,5C7D7D5C78BC,A0FF7086B674,6C55E8CD2F5C', '138;1', 'DEFAULT', 09, 0154, '','', '', 00);
Date: 2026-08-06 09:25:54 Duration: 1s117ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '7C7D21F0A8BF,DC5193DC0326,DC5193DA65BA,14200455D0DA,14200454A3C2,DC5193DC06BE,14200455E73E,E44E1293C383,E44E12B2D7A1,7C7D21EC0653,DC5193DA8CC6,7C7D21F0CBAF,14200455E742,38165A480F50,38165A47DFE8,DC5193DA214A,E44E129398FB,7C7D21ED1543,7C7D21ED156B', '','DEFAULT',09,0329,'', '','', 00);
Date: 2026-08-06 14:39:52 Duration: 1s42ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
15 75 51s126ms 478ms 1s305ms 681ms create table temp0000287693 as select * from rs_fluxos_lista (?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 06 13 28 18s253ms 651ms 14 24 15s829ms 659ms 15 2 1s289ms 644ms 16 5 4s272ms 854ms 17 16 11s480ms 717ms [ User: intelifix - Total duration: 51s126ms - Times executed: 75 ]
[ Application: [unknown] - Total duration: 51s126ms - Times executed: 75 ]
-
CREATE TABLE temp0000287693 AS SELECT * FROM RS_FLUXOS_LISTA (06, 00, 00, '06-08-2026', '06-08-2026', 0, '', 00);
Date: 2026-08-06 16:26:24 Duration: 1s305ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287693 AS SELECT * FROM RS_FLUXOS_LISTA (06, 00, 00, '06-08-2026', '06-08-2026', 0, '', 00);
Date: 2026-08-06 13:45:58 Duration: 1s36ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287693 AS SELECT * FROM RS_FLUXOS_LISTA (06, 00, 00, '06-08-2026', '06-08-2026', 0, '', 00);
Date: 2026-08-06 14:16:44 Duration: 1s4ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 68 1m20s 159ms 12s656ms 1s188ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 06 07 4 2s821ms 705ms 08 3 1s890ms 630ms 09 4 2s610ms 652ms 10 6 2s867ms 477ms 11 7 14s333ms 2s47ms 12 3 1s652ms 550ms 13 1 5s892ms 5s892ms 14 6 15s316ms 2s552ms 15 7 15s242ms 2s177ms 16 8 2s701ms 337ms 17 19 15s483ms 814ms [ User: intelifix - Total duration: 1m20s - Times executed: 68 ]
[ Application: psql - Total duration: 1m20s - Times executed: 68 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028111);
Date: 2026-08-06 14:47:31 Duration: 12s656ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028102);
Date: 2026-08-06 11:29:34 Duration: 9s922ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028118);
Date: 2026-08-06 15:32:53 Duration: 6s529ms Database: rio User: intelifix Remote: [local] Application: psql
17 68 15s210ms 150ms 2s461ms 223ms create table temp0000287693 as select * from rs_baixas_lista (?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 06 13 8 1s399ms 174ms 14 18 5s834ms 324ms 15 11 2s92ms 190ms 16 9 1s797ms 199ms 17 22 4s86ms 185ms [ User: intelifix - Total duration: 15s210ms - Times executed: 68 ]
[ Application: [unknown] - Total duration: 15s210ms - Times executed: 68 ]
-
CREATE TABLE temp0000287693 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '743AEF9BF55C', '2026-08-04', '2026-08-06');
Date: 2026-08-06 14:14:46 Duration: 2s461ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287693 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, 'F200010269E22C2', '2026-08-04', '2026-08-06');
Date: 2026-08-06 14:14:52 Duration: 341ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287693 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '', '2026-08-04', '2026-08-06');
Date: 2026-08-06 15:14:05 Duration: 262ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 66 25s392ms 164ms 738ms 384ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 06 06 1 384ms 384ms 08 23 6s326ms 275ms 10 42 18s680ms 444ms [ User: intelifix - Total duration: 25s392ms - Times executed: 66 ]
[ Application: [unknown] - Total duration: 25s392ms - Times executed: 66 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-08-06 10:35:47 Duration: 738ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-08-06 10:36:19 Duration: 692ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-08-06 10:36:27 Duration: 666ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 65 16s194ms 155ms 1s516ms 249ms create table temp0000226778 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 06 13 14 4s271ms 305ms 14 13 2s763ms 212ms 15 16 3s638ms 227ms 16 18 4s702ms 261ms 17 4 819ms 204ms [ User: intelifix - Total duration: 16s194ms - Times executed: 65 ]
[ Application: [unknown] - Total duration: 16s194ms - Times executed: 65 ]
-
CREATE TABLE temp0000226778 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"01-08-2026", "ate" :"06-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-06 13:09:23 Duration: 1s516ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226778 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"01-08-2026", "ate" :"06-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-06 13:18:22 Duration: 534ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226778 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"01-08-2026", "ate" :"06-08-2026", "nota-fiscal":"2832", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-06 14:25:26 Duration: 403ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 63 12s860ms 153ms 545ms 204ms create table temp0000287659 as select * from rs_baixas_lista (?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 06 08 16 3s317ms 207ms 09 20 4s108ms 205ms 10 7 1s232ms 176ms 11 20 4s202ms 210ms [ User: intelifix - Total duration: 12s860ms - Times executed: 63 ]
[ Application: [unknown] - Total duration: 12s860ms - Times executed: 63 ]
-
CREATE TABLE temp0000287659 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '840112296736', '2026-08-04', '2026-08-06');
Date: 2026-08-06 09:02:11 Duration: 545ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287659 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '', '2026-08-04', '2026-08-06');
Date: 2026-08-06 08:31:56 Duration: 536ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287659 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '11729085850046907479', '2026-08-04', '2026-08-06');
Date: 2026-08-06 11:33:43 Duration: 470ms 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 8m51s 8m51s 8m51s 1 8m51s select * from rs_smart_fiscal_entrada () notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 06 16 1 8m51s 8m51s [ User: intelifix - Total duration: 8m51s - Times executed: 1 ]
[ Application: psql - Total duration: 8m51s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA () NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-08-06 16:13:53 Duration: 8m51s Database: rio User: intelifix Remote: [local] Application: psql
2 2m42s 10m43s 6m2s 3 18m7s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 06 05 3 18m7s 6m2s [ User: intelifix - Total duration: 18m7s - Times executed: 3 ]
[ Application: psql - Total duration: 18m7s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-06 05:10:45 Duration: 10m43s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-06 05:15:26 Duration: 4m41s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-06 05:18:08 Duration: 2m42s Database: contagem User: intelifix Remote: [local] Application: psql
3 1s340ms 11m8s 2m45s 47 2h9m54s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 06 07 3 11m51s 3m57s 08 3 6m22s 2m7s 09 3 10m36s 3m32s 10 3 8m52s 2m57s 11 3 10m1s 3m20s 12 3 9m24s 3m8s 13 3 5m58s 1m59s 14 3 8m56s 2m58s 15 3 10m53s 3m37s 16 2 40s454ms 20s227ms 17 3 8m31s 2m50s 18 3 8m20s 2m46s 19 3 6m40s 2m13s 20 3 9m51s 3m17s 21 3 6m38s 2m12s 22 3 6m13s 2m4s [ User: intelifix - Total duration: 2h9m54s - Times executed: 47 ]
[ Application: psql - Total duration: 2h9m54s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-06 07:16:09 Duration: 11m8s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-06 15:15:04 Duration: 10m3s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-06 09:14:51 Duration: 9m50s Database: rio User: intelifix Remote: [local] Application: psql
4 206ms 4m59s 1m45s 47 1h22m43s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 06 07 3 5m24s 1m48s 08 3 4m27s 1m29s 09 3 6m3s 2m1s 10 3 5m29s 1m49s 11 3 6m14s 2m4s 12 2 5m28s 2m44s 13 3 4m5s 1m21s 14 3 5m28s 1m49s 15 3 6m32s 2m10s 16 3 5m38s 1m52s 17 3 5m20s 1m46s 18 3 4m56s 1m38s 19 3 4m5s 1m21s 20 3 5m39s 1m53s 21 3 3m54s 1m18s 22 3 3m53s 1m17s [ User: intelifix - Total duration: 1h22m43s - Times executed: 47 ]
[ Application: psql - Total duration: 1h22m43s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-06 15:22:12 Duration: 4m59s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-06 11:21:08 Duration: 4m40s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-06 09:21:29 Duration: 4m38s Database: brasilia User: intelifix Remote: [local] Application: psql
5 4s937ms 1m37s 49s547ms 4 3m18s 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 06 20 2 1m42s 51s302ms 23 2 1m35s 47s792ms [ User: intelifix - Total duration: 3m18s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m18s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-06 20:09:05 Duration: 1m37s 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-06 23:16:40 Duration: 1m29s 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-06 23:36:24 Duration: 5s735ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 152ms 6m22s 18s456ms 327 1h40m35s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 06 07 5 10m43s 2m8s 08 29 5m47s 11s970ms 09 38 16m30s 26s56ms 10 33 12m13s 22s226ms 11 26 8m35s 19s818ms 12 6 5m38s 56s379ms 13 18 3m53s 12s964ms 14 44 11m51s 16s161ms 15 44 8m16s 11s292ms 16 33 7m29s 13s627ms 17 47 8m5s 10s323ms 18 1 2s831ms 2s831ms 21 2 58s97ms 29s48ms 22 1 30s571ms 30s571ms [ User: intelifix - Total duration: 1h40m35s - Times executed: 327 ]
[ Application: [unknown] - Total duration: 1h40m35s - Times executed: 327 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028120, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-06 16:07:54 Duration: 6m22s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028108, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-06 14:31:30 Duration: 6m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028100, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-06 11:32:34 Duration: 6m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 10s589ms 37s412ms 13s232ms 24 5m17s create table temp0000287715 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 06 14 15 3m25s 13s729ms 15 6 1m17s 12s922ms 16 3 34s100ms 11s366ms [ User: intelifix - Total duration: 5m17s - Times executed: 24 ]
[ Application: [unknown] - Total duration: 5m17s - Times executed: 24 ]
-
CREATE TABLE temp0000287715 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 14:23:23 Duration: 37s412ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287715 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 15:59:40 Duration: 14s663ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287715 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 15:59:58 Duration: 13s590ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10s277ms 15s206ms 11s924ms 27 5m21s create table temp0000287705 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 06 13 2 27s339ms 13s669ms 15 9 1m52s 12s514ms 16 1 12s297ms 12s297ms 17 15 2m49s 11s313ms [ User: intelifix - Total duration: 5m21s - Times executed: 27 ]
[ Application: [unknown] - Total duration: 5m21s - Times executed: 27 ]
-
CREATE TABLE temp0000287705 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 13:47:35 Duration: 15s206ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287705 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 15:18:25 Duration: 13s610ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287705 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 15:24:24 Duration: 13s82ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 9s650ms 13s966ms 11s680ms 53 10m19s create table temp0000287629 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 06 07 10 1m48s 10s855ms 08 9 1m46s 11s788ms 09 12 2m22s 11s909ms 10 8 1m34s 11s809ms 11 5 1m1s 12s354ms 12 9 1m45s 11s694ms [ User: intelifix - Total duration: 10m19s - Times executed: 53 ]
[ Application: [unknown] - Total duration: 10m19s - Times executed: 53 ]
-
CREATE TABLE temp0000287629 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 11:25:05 Duration: 13s966ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287629 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 12:20:16 Duration: 13s756ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287629 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 11:24:48 Duration: 13s385ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s561ms 13s512ms 11s592ms 13 2m30s create table temp0000287659 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 06 10 6 1m10s 11s779ms 11 7 1m20s 11s431ms [ User: intelifix - Total duration: 2m30s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m30s - Times executed: 13 ]
-
CREATE TABLE temp0000287659 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 10:28:37 Duration: 13s512ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287659 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 11:16:36 Duration: 12s516ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287659 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 11:10:57 Duration: 11s981ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 9s835ms 12s874ms 11s100ms 37 6m50s create table temp0000287693 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 06 16 12 2m17s 11s428ms 17 25 4m33s 10s943ms [ User: intelifix - Total duration: 6m50s - Times executed: 37 ]
[ Application: [unknown] - Total duration: 6m50s - Times executed: 37 ]
-
CREATE TABLE temp0000287693 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 17:30:07 Duration: 12s874ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287693 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 16:38:43 Duration: 12s762ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287693 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-06 16:25:20 Duration: 12s477ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 1s464ms 27s949ms 6s355ms 55 5m49s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 06 07 2 7s532ms 3s766ms 08 1 11s681ms 11s681ms 09 3 18s154ms 6s51ms 10 3 7s795ms 2s598ms 11 10 54s929ms 5s492ms 13 3 20s680ms 6s893ms 14 7 45s739ms 6s534ms 15 6 50s545ms 8s424ms 16 9 58s501ms 6s500ms 17 9 38s701ms 4s300ms 21 2 35s291ms 17s645ms [ User: intelifix - Total duration: 5m49s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 5m49s - Times executed: 55 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-06', 0320, '', '', 0, 6, '2026-08-01');
Date: 2026-08-06 21:12:55 Duration: 27s949ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-06', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-06 15:54:05 Duration: 12s278ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-06', 0302, '', '', 0, 6, '2026-08-06');
Date: 2026-08-06 08:47:19 Duration: 11s681ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 155ms 17s294ms 4s117ms 162 11m7s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 06 00 6 29s905ms 4s984ms 01 6 12s556ms 2s92ms 02 6 12s202ms 2s33ms 03 5 15s789ms 3s157ms 04 6 14s379ms 2s396ms 05 3 14s110ms 4s703ms 07 11 50s559ms 4s596ms 08 12 1m9s 5s789ms 09 12 1m7s 5s637ms 10 12 1m3s 5s305ms 11 12 1m14s 6s190ms 12 13 52s904ms 4s69ms 13 9 9s917ms 1s101ms 14 11 50s852ms 4s622ms 15 12 53s679ms 4s473ms 16 10 33s556ms 3s355ms 17 6 9s898ms 1s649ms 21 4 15s253ms 3s813ms 22 6 16s376ms 2s729ms [ User: intelifix - Total duration: 11m7s - Times executed: 162 ]
[ Application: psql - Total duration: 11m7s - Times executed: 162 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-06 00:05:18 Duration: 17s294ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-06 09:55:16 Duration: 15s112ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-06 08:55:15 Duration: 13s649ms Database: rio User: intelifix Remote: [local] Application: psql
14 2s880ms 13s307ms 3s991ms 53 3m31s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 06 08 3 12s871ms 4s290ms 09 3 9s994ms 3s331ms 10 3 10s550ms 3s516ms 11 3 11s430ms 3s810ms 12 3 10s433ms 3s477ms 13 3 9s925ms 3s308ms 14 2 6s334ms 3s167ms 15 4 24s5ms 6s1ms 16 5 21s315ms 4s263ms 17 6 24s924ms 4s154ms 18 4 15s640ms 3s910ms 19 4 13s221ms 3s305ms 20 4 14s760ms 3s690ms 21 3 10s334ms 3s444ms 22 3 15s784ms 5s261ms [ User: intelifix - Total duration: 3m31s - Times executed: 53 ]
[ Application: psql - Total duration: 3m31s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-06 15:20:14 Duration: 13s307ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-06 22:00:14 Duration: 9s32ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-06 08:20:09 Duration: 5s213ms Database: brasilia User: intelifix Remote: [local] Application: psql
15 152ms 25s97ms 3s975ms 48 3m10s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 06 07 3 25s465ms 8s488ms 08 2 9s206ms 4s603ms 09 2 13s44ms 6s522ms 10 3 13s804ms 4s601ms 11 6 20s116ms 3s352ms 12 2 18s574ms 9s287ms 13 1 1s460ms 1s460ms 14 4 27s189ms 6s797ms 15 7 8s881ms 1s268ms 16 10 39s521ms 3s952ms 17 8 13s549ms 1s693ms [ User: intelifix - Total duration: 3m10s - Times executed: 48 ]
[ Application: psql - Total duration: 3m10s - Times executed: 48 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028120);
Date: 2026-08-06 16:01:23 Duration: 25s97ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028079);
Date: 2026-08-06 07:15:04 Duration: 21s731ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028108);
Date: 2026-08-06 14:24:59 Duration: 18s987ms Database: rio User: intelifix Remote: [local] Application: psql
16 2s769ms 10s495ms 3s440ms 42 2m24s create table temp0000287693 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 06 13 2 6s214ms 3s107ms 16 15 55s176ms 3s678ms 17 25 1m23s 3s324ms [ User: intelifix - Total duration: 2m24s - Times executed: 42 ]
[ Application: [unknown] - Total duration: 2m24s - Times executed: 42 ]
-
CREATE TABLE temp0000287693 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-08-2026", "ate" :"06-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-06 16:25:33 Duration: 10s495ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287693 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-08-2026", "ate" :"06-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-06 17:30:11 Duration: 3s809ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287693 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-08-2026", "ate" :"06-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-06 17:41:41 Duration: 3s791ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 157ms 1m51s 3s38ms 277 14m1s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 06 00 12 34s91ms 2s840ms 01 12 23s593ms 1s966ms 02 12 22s325ms 1s860ms 03 13 22s641ms 1s741ms 04 12 23s148ms 1s929ms 05 12 22s305ms 1s858ms 06 12 24s512ms 2s42ms 07 12 2m12s 11s6ms 08 12 24s894ms 2s74ms 09 12 27s791ms 2s315ms 10 12 28s445ms 2s370ms 11 12 31s731ms 2s644ms 12 12 24s379ms 2s31ms 13 12 25s515ms 2s126ms 14 12 2m6s 10s514ms 15 12 31s701ms 2s641ms 16 12 31s30ms 2s585ms 17 12 32s717ms 2s726ms 18 12 27s645ms 2s303ms 19 12 29s748ms 2s479ms 20 12 40s967ms 3s413ms 21 12 27s965ms 2s330ms 22 12 26s332ms 2s194ms [ User: intelifix - Total duration: 14m1s - Times executed: 277 ]
[ Application: psql - Total duration: 14m1s - Times executed: 277 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-06 07:47:00 Duration: 1m51s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-06 14:46:54 Duration: 1m41s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-06 20:15:16 Duration: 14s980ms Database: rio User: intelifix Remote: [local] Application: psql
18 159ms 12s656ms 1s188ms 68 1m20s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 06 07 4 2s821ms 705ms 08 3 1s890ms 630ms 09 4 2s610ms 652ms 10 6 2s867ms 477ms 11 7 14s333ms 2s47ms 12 3 1s652ms 550ms 13 1 5s892ms 5s892ms 14 6 15s316ms 2s552ms 15 7 15s242ms 2s177ms 16 8 2s701ms 337ms 17 19 15s483ms 814ms [ User: intelifix - Total duration: 1m20s - Times executed: 68 ]
[ Application: psql - Total duration: 1m20s - Times executed: 68 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028111);
Date: 2026-08-06 14:47:31 Duration: 12s656ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028102);
Date: 2026-08-06 11:29:34 Duration: 9s922ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028118);
Date: 2026-08-06 15:32:53 Duration: 6s529ms Database: rio User: intelifix Remote: [local] Application: psql
19 160ms 8s683ms 884ms 139 2m2s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 06 08 14 7s234ms 516ms 09 26 13s47ms 501ms 10 14 6s719ms 479ms 11 16 9s907ms 619ms 14 19 24s318ms 1s279ms 15 21 34s867ms 1s660ms 16 14 13s397ms 956ms 17 15 13s460ms 897ms [ User: intelifix - Total duration: 2m2s - Times executed: 139 ]
[ Application: [unknown] - Total duration: 2m2s - Times executed: 139 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0131789) LIMIT 1;
Date: 2026-08-06 15:32:48 Duration: 8s683ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0274751) LIMIT 1;
Date: 2026-08-06 16:42:41 Duration: 4s28ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0131663) LIMIT 1;
Date: 2026-08-06 14:42:38 Duration: 3s890ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
20 150ms 8s306ms 861ms 1,140 16m21s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 06 07 26 15s799ms 607ms 08 109 1m20s 738ms 09 123 1m47s 872ms 10 134 1m49s 816ms 11 127 1m48s 853ms 12 37 38s202ms 1s32ms 13 89 1m28s 994ms 14 125 1m36s 772ms 15 172 3m11s 1s111ms 16 132 1m44s 789ms 17 66 41s413ms 627ms [ User: intelifix - Total duration: 16m21s - Times executed: 1140 ]
[ Application: [unknown] - Total duration: 16m21s - Times executed: 1140 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (51278, 416, '835237935003041,241708787390,241604324255,241713345164,241664784757,241704657088,241680302344,241617412132,241606694767,241609877995,241632281821,241678311319,241649685573,241671570325,241713712428,241663850918,241668191521,241676762234,241691219604,241647348296,241659887073,241656696268,241729562325,241676825977,241704341424,241615881433,241673086577,241730911436,241704329402,241676706975,241676710613,241673347691,241607229397,241620869102,241689115762,241678290812,241727085562,241652016687,241695609909,241616949303,241646326266,241669453350,241680505977,241676812037,241617357883,241617420820,241727042629,241639279406,241695570007,241660138691,241680299313', '',0321,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-06 15:07:49 Duration: 8s306ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (51280, 407, 'ZTE3ANNT2V71640,D83139921DE8,D83139921DE9,ZTEGDD310A57$ZTE3ANNRC559251,6C11BA679689,6C11BA67968A,ZTEGDC6EFD32$ZTE3ANNT3H17813,D83139986516,D83139986517,ZTEGDD321634$ZTE3ANNRCP02167,6C11BA695D99,6C11BA695D9A,ZTEGDC6F490A$ZTE3ANNRC552370,6C11BA66F543,6C11BA66F544,ZTEGDC6EE251$ZTE3ANNR3Y01650,4896D94FE764,4896D94FE765,ZTEGD97E3727$ZTE3ANNR8C34398,38914851AD3B,38914851AD3C,ZTEGDB0906CE$ZTE3ANNR9F14472,D89A0DA43113,D89A0DA43114,ZTEGDB155FD3$ZTE3ANNR9F58172,D89A0DA8314B,D89A0DA8314C,ZTEGDB160A87$ZTE3ANNR8C27032,389148510097,389148510098,ZTEGDB08EA08$ZTE3ANNRCB24710,D83139201222,D83139201223,ZTEGDD2A161B$ZTE3ANNT2V50458,D83139902D74,D83139902D75,ZTEGDD30B799$ZTE3ANNRAM61812,5872C98CE0F1,5872C98CE0F2,ZTEGDC60F173$ZTE3ANNRCB04921,D831391E4254,D831391E4255,ZTEGDD29C8CE$ZTE3ANNQ8M29799,843C99218255,843C99218256,ZTEGD7BABBD4$ZTE3ANNT3H83271,D831399E6342,D831399E6343,ZTEGDD3315E6$ZTE3ANNR1Y12650,14CA56CDD2F7,14CA56CDD2F8,ZTEGD970A7C5$ZTE3ANNR7B16859,3891484A77C9,3891484A77CA,ZTEGDB07D33B$ZTE3ANNR3J06957,F4E84F86F16E,F4E84F86F16F,ZTEGD97B7CF7$ZTE3ANNR8C09687,3891484F6A11,3891484F6A12,ZTEGDB08A647$ZTE3ANNQ4N05998,3CF9F0A91E42,3CF9F0A91E43,ZTEGD6411A69$ZTE3ANNQ4N06163,3CF9F0A92220,3CF9F0A92221,ZTEGD6411B0E$ZTE3ANNRCB04745,D831391E3E34,D831391E3E35,ZTEGDD29C81E$ZTE3ANNR9343438,D89A0D865A1F,D89A0D865A20,ZTEGDB151DAD$ZTE3ANNT4P40292,F00C514F56F6,F00C514F56F7,ZTEGDE3493FA$ZTE3ANNR6R23468,48D68237AACA,48D68237AACB,ZTEGDB01867F$ZTE3ANNR5W68544,48D68234CA4A,48D68234CA4B,ZTEGDB010BBF$ZTE3ANNQ8M16721,843C99204FD1,843C99204FD2,ZTEGD7BA88BE$ZTE3ANNT2V84856,D831399353A8,D831399353A9,ZTEGDD313DF7$ZTE3ANNRC501625,6C11BA624FED,6C11BA624FEE,ZTEGDC6E1C18$ZTE3ANNRB710331,5872C98F2B53,5872C98F2B54,ZTEGDC61532E$ZTE3ANNR6R25663,48D68237DE3C,48D68237DE3D,ZTEGDB018F12$ZTE3ANNQ8M16638,843C99204DDF,843C99204DE0,ZTEGD7BA886B$ZTE3ANNRCB03070,D831391E16F2,D831391E16F3,ZTEGDD29C193$ZTE3ANNT4P36203,F00C514EF720,F00C514EF721,ZTEGDE348401$ZTE3ANNRC558512,6C11BA678537,6C11BA678538,ZTEGDC6EFA4F$ZTE3ANNR7B17071,3891484A7CC1,3891484A7CC2,ZTEGDB07D40F$ZTE3ANNRC552195,6C11BA66F129,6C11BA66F12A,ZTEGDC6EE1A2$ZTE3ANNR9326575,D89A0D84CEE5,D89A0D84CEE6,ZTEGDB14DBCE', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-06 15:10:29 Duration: 6s591ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (51247, 407, '270911029072105997,229669947698,229805239802,216940589415,229816217495,216944396778,229865996573,229934063744,229685445664,229933293759,229753801326,229837169797,229859791726,229787199411,229748610202,229747563242,229865270712,216943421824,229933344347,229806783758,229739804965,229925598899,229865768492,229850143747,229866009302,229809318607,229812660213,216936627490,229925328693,229751102140,229860353251,229686723556,229805260209,229737730622,229740314465,229782951522,216932032340,229670192526,229744075359,229670211316', '246472754459,246593072644,246474642242,246628817478,246456748990,246653659094,246254619601,246499746767,226055229816,246563151531,246641420606,246649933434,246598190708,246550662837,246550664049,246648241429,246468822235,226247001832,246581304155,246526362946,226007317788,246163529397,246642058805,246651698904,246627544257,246629633047,246463871516,246160730001,246566448181,246652022022,246513397583,246598448689,246527586566,246549798094,246602761435,246432670615,246514482830,246547263448,246488563443', 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-06 14:51:10 Duration: 5s446ms Database: contagem 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 06 10 1 0ms 0ms 16 1 0ms 0ms 20 2 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 10s92ms - Times executed: 5 ]
[ Application: psql - Total duration: 8s811ms - Times executed: 3 ]
[ Application: [unknown] - Total duration: 1s280ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 17,951 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 20 FATAL entries
- 3723 ERROR entries
- 0 WARNING entries
- 8 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,663 Max number of times the same event was reported
- 3,751 Total events found
Rank Times reported Error 1 3,663 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 06 00 82 01 113 02 83 03 82 04 96 05 76 06 60 07 180 08 306 09 339 10 314 11 354 12 189 13 190 14 249 15 289 16 202 17 112 18 60 19 59 20 60 21 59 22 59 23 50 - ERROR: prepared statement "_PLAN0000000029AD8A30" does not exist
- ERROR: prepared statement "_PLAN0000000029757700" does not exist
- ERROR: prepared statement "_PLAN0000000029AD9C70" does not exist
Statement: DEALLOCATE "_PLAN0000000029AD8A30"
Date: 2026-08-06 00:00:39 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029757700"
Date: 2026-08-06 00:01:39 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029AD9C70"
Date: 2026-08-06 00:02:40 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 06 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-06 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-06 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-06 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
3 12 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 06 03 12 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-08-06 03:05:01 Database: rio Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-06 03:05:01 Database: rio Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-06 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
4 6 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 06 05 4 08 2 - 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-06 05:32:08 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-06 05:32:08 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-06 05:32:08 Database: contagem Application: psql User: intelifix Remote: [local]
5 6 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 06 07 2 13 1 14 3 - LOG: process 3994507 still waiting for ShareLock on transaction 3938067 after 1000.165 ms
- LOG: process 3994507 still waiting for ShareLock on transaction 3938067 after 6123.222 ms
- LOG: process 60784 still waiting for ShareLock on transaction 3963811 after 1000.189 ms
Detail: Process holding the lock: 3992585. Wait queue: 3994507.
Context: while updating tuple (75976,41) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-08-06 07:45:13 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 3992585. Wait queue: 3994507.
Context: while updating tuple (75976,41) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-08-06 07:45:18 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 79056. Wait queue: 60784.
Context: while updating tuple (1,55) in relation "usuarios" SQL statement "UPDATE USUARIOS SET EQ_CODIGO = NULL, USU_CHECK_IN = NULL WHERE USU_ID = nUser" PL/pgSQL function rs_tecnico_check_out(integer) line 28 at SQL statement SQL statement "SELECT RS_TECNICO_CHECK_OUT( nTecnico )" PL/pgSQL function rs_baixa(integer,integer,integer,integer,character varying,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1129 at PERFORM PL/pgSQL function rs_fluxo_encerra(integer,integer,boolean) line 169 at assignment PL/pgSQL function rs_cria_fluxo_fechado(integer,character varying,integer,boolean) line 94 at assignment PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1095 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(51098,416,'ZTE3ANNR5W17931,48D68230280C,48D68230280D,ZTEGDB00460A$ZTE3ANNT4P36297,F00C514EF954,F00C514EF955,ZTEGDE34845F','',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""}]','$','',00);Date: 2026-08-06 13:23:24 Database: contagem Application: [unknown] User: intelifix Remote: [local]
6 5 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 06 00 1 06 1 10 1 15 2 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-08-06 00:02:11 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-06 06:02:07 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-06 10:54:42 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
7 4 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 06 08 2 15 2 - ERROR: column "v" does not exist at character 27
- ERROR: column "v" does not exist at character 27
- ERROR: column "k3414118" does not exist at character 27
Statement: select * from rs_caixa_qr(v)
Date: 2026-08-06 08:28:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(v)
Date: 2026-08-06 08:28:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(K3414118 )
Date: 2026-08-06 15:55:55 Database: rio Application: [unknown] User: etiquetas Remote: [local]
8 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 06 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-06 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-06 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-06 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
9 2 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Aug 06 10 1 15 1 - ERROR: syntax error at or near "1011" at character 44
- ERROR: syntax error at or near ""},{"" at character 81
Statement: SELECT * FROM RS_LOGIN('reclassificaĆ§Ć£o'','1011','177.99.204.34')
Date: 2026-08-06 10:08:18 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"274051","seriais":[{"serial":"'"},{"serial":""},{"serial":""}]}')
Date: 2026-08-06 15:50:55 Database: rio Application: [unknown] User: intelifix Remote: [local]
10 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #10
Day Hour Count Aug 06 17 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000287693"
Date: 2026-08-06 17:20:36
11 1 ERROR: function rs_lote_manutencao_itens(...) does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count Aug 06 08 1 - ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(131622,401,'71506385850012539626,216550534243$71822785850058009152,216880175864$71722785850043200750,216801217496$7160208787H010989234,216634698103','',062,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""}]','$$$$$$$$$$$$$$$$$','',0216550534243);Date: 2026-08-06 08:29:58 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
12 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #12
Day Hour Count Aug 06 17 1 - LOG: process 307749 still waiting for AccessExclusiveLock on relation 3499410 of database 358220 after 1000.179 ms
Detail: Process holding the lock: 327957. Wait queue: 307749.
Statement: DROP TABLE IF EXISTS temp0000287693;Date: 2026-08-06 17:20:36 Database: rio Application: [unknown] User: intelifix Remote: [local]
13 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #13
Day Hour Count Aug 06 03 1 - LOG: database system was shut down at 2026-08-06 03:05:01 -03
Date: 2026-08-06 03:05:02