pgBadger-
Global information
- Generated on Mon Aug 17 23:50:14 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 47,766 log entries in 12s
- Log start from 2026-08-17 00:00:02 to 2026-08-17 23:49:14
-
Overview
Global Stats
- 409 Number of unique normalized queries
- 6,582 Number of queries
- 11h55m14s Total query duration
- 2026-08-17 00:02:16 First query
- 2026-08-17 23:45:07 Last query
- 5 queries/s at 2026-08-17 11:05:21 Query peak
- 11h55m14s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 11h55m14s Execute total duration
- 4,901 Number of events
- 17 Number of unique normalized events
- 4,794 Max number of times the same event was reported
- 0 Number of cancellation
- 516 Total number of automatic vacuums
- 1,115 Total number of automatic analyzes
- 11 Number temporary file
- 240.82 MiB Max size of temporary file
- 111.23 MiB Average size of temporary file
- 405 Total number of sessions
- 8 sessions at 2026-08-17 06:05:01 Session peak
- 13d5h18m25s Total duration of sessions
- 47m Average duration of sessions
- 16 Average queries per session
- 1m45s Average queries duration per session
- 45m14s Average idle time per session
- 414 Total number of connections
- 4 connections/s at 2026-08-17 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-17 11:05:21 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-17 15:14:28 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-17 23:44:36 Date
Queries duration
Key values
- 11h55m14s 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 17 00 22 0ms 27s710ms 6s789ms 5s24ms 19s41ms 1m20s 01 12 0ms 5s686ms 2s607ms 4s560ms 5s217ms 6s218ms 02 12 0ms 4s942ms 2s503ms 4s396ms 5s257ms 5s572ms 03 13 0ms 4s917ms 1s954ms 1s506ms 4s666ms 5s464ms 04 12 0ms 5s812ms 2s611ms 4s344ms 5s375ms 6s493ms 05 17 0ms 13m18s 1m37s 6s209ms 3m14s 13m18s 06 18 0ms 14s445ms 4s925ms 5s59ms 5s666ms 42s676ms 07 144 0ms 16m9s 21s520ms 1m35s 5m55s 16m9s 08 490 0ms 8m51s 6s249ms 1m46s 9m5s 10m8s 09 807 150ms 14m22s 4s651ms 2m36s 6m37s 14m32s 10 727 150ms 13m13s 5s290ms 1m40s 7m13s 13m17s 11 663 150ms 12m26s 4s757ms 1m48s 6m33s 12m30s 12 195 0ms 12m36s 10s785ms 45s745ms 5m54s 13m 13 405 0ms 7m4s 3s377ms 39s78ms 1m21s 8m47s 14 677 150ms 12m20s 4s319ms 1m11s 5m41s 12m26s 15 708 150ms 12m35s 6s608ms 6m7s 8m 12m51s 16 705 150ms 11m42s 5s126ms 2m20s 6m18s 11m54s 17 322 0ms 12m10s 6s873ms 1m4s 3m21s 12m31s 18 41 0ms 11m32s 27s206ms 7s945ms 1m5s 11m34s 19 24 0ms 5m39s 26s163ms 6s126ms 47s748ms 5m39s 20 141 0ms 11m56s 12s553ms 1m19s 1m38s 11m56s 21 44 0ms 6m55s 17s137ms 10s945ms 53s344ms 6m58s 22 31 0ms 6m12s 23s57ms 9s914ms 15s376ms 6m45s 23 352 0ms 1m27s 5s952ms 1m8s 1m9s 1m27s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 17 00 4 0 4s859ms 0ms 0ms 396ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 153ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 3 0 6s600ms 0ms 0ms 0ms 07 97 0 25s819ms 4s61ms 1m12s 8m48s 08 320 0 6s532ms 15s670ms 1m11s 6m20s 09 647 0 5s86ms 28s408ms 2m36s 7m3s 10 556 0 5s857ms 27s909ms 1m40s 8m10s 11 500 0 5s533ms 23s940ms 1m47s 7m5s 12 131 0 14s381ms 5s625ms 44s284ms 6m37s 13 293 0 3s568ms 8s372ms 13s155ms 3m25s 14 528 0 4s457ms 18s212ms 43s555ms 8m59s 15 527 0 7s351ms 20s314ms 5m38s 8m5s 16 505 0 5s528ms 31s830ms 1m43s 6m54s 17 245 0 7s991ms 29s741ms 1m4s 5m22s 18 20 0 52s541ms 418ms 1s467ms 4m10s 19 6 0 1m36s 0ms 0ms 3m9s 20 30 91 14s4ms 32s798ms 1m7s 4m46s 21 21 0 32s39ms 0ms 525ms 3m16s 22 7 0 1m31s 0ms 0ms 3m37s 23 25 327 5s952ms 1m2s 1m8s 1m27s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 17 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 17 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 23 23.00 0.00% 08 0 21 21.00 0.00% 09 0 21 21.00 0.00% 10 0 23 23.00 0.00% 11 0 20 20.00 0.00% 12 0 14 14.00 0.00% 13 0 13 13.00 0.00% 14 0 26 26.00 0.00% 15 0 20 20.00 0.00% 16 0 18 18.00 0.00% 17 0 11 11.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 2 2.00 0.00% 21 0 2 2.00 0.00% 22 0 0 0.00 0.00% 23 0 4 4.00 0.00% Day Hour Count Average / Second Aug 17 00 17 0.00/s 01 9 0.00/s 02 7 0.00/s 03 18 0.01/s 04 9 0.00/s 05 12 0.00/s 06 16 0.00/s 07 20 0.01/s 08 25 0.01/s 09 27 0.01/s 10 27 0.01/s 11 19 0.01/s 12 18 0.01/s 13 21 0.01/s 14 25 0.01/s 15 28 0.01/s 16 25 0.01/s 17 23 0.01/s 18 13 0.00/s 19 10 0.00/s 20 14 0.00/s 21 8 0.00/s 22 9 0.00/s 23 14 0.00/s Day Hour Count Average Duration Average idle time Aug 17 00 4 33m57s 33m19s 01 17 50m44s 50m42s 02 7 59m15s 59m10s 03 16 24m57s 24m55s 04 10 50m28s 50m25s 05 10 41m44s 38m57s 06 10 41m42s 41m34s 07 19 45m 42m17s 08 18 47m38s 44m48s 09 28 51m23s 49m8s 10 27 47m18s 44m55s 11 22 53m6s 50m43s 12 21 47m11s 45m31s 13 13 57m31s 55m46s 14 28 48m32s 46m48s 15 27 41m37s 38m44s 16 26 47m12s 44m53s 17 23 47m56s 46m20s 18 20 54m33s 53m37s 19 12 52m10s 51m18s 20 12 43m37s 41m9s 21 10 58m20s 57m5s 22 10 44m19s 43m7s 23 15 31m19s 29m -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-08-17 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 414 connections Total
Connections per user
Key values
- intelifix Main User
- 414 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-08-17 06:05:01 Date
Histogram of session times
Key values
- 264 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 405 sessions Total
Sessions per user
Key values
- intelifix Main User
- 405 sessions Total
Sessions per host
Key values
- [local] Main Host
- 405 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 19,841 buffers Checkpoint Peak
- 2026-08-17 15:04:41 Date
- 269.999 seconds Highest write time
- 1.102 seconds Sync time
Checkpoints Wal files
Key values
- 9 files Wal files usage Peak
- 2026-08-17 10:19:40 Date
Checkpoints distance
Key values
- 278.90 Mo Distance Peak
- 2026-08-17 16:54:41 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 17 00 6,193 269.169s 0.032s 269.282s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 11,718 0.697s 1.105s 1.853s 04 0 0s 0s 0s 05 7,821 783.598s 0.234s 783.936s 06 3,046 269.88s 0.01s 269.91s 07 28,387 2,054.791s 0.481s 2,055.403s 08 53,985 3,188.683s 0.741s 3,189.687s 09 90,429 3,238.142s 1.358s 3,239.793s 10 83,045 3,238.196s 1.248s 3,239.701s 11 70,451 3,237.988s 1.476s 3,239.731s 12 40,681 2,205.012s 0.426s 2,205.571s 13 26,646 2,327.153s 0.529s 2,327.811s 14 63,001 3,129.241s 1.232s 3,130.702s 15 110,525 3,238.178s 1.221s 3,239.678s 16 64,110 3,238.37s 1.114s 3,239.726s 17 46,830 2,694.217s 1.006s 2,695.386s 18 3,001 301.41s 0.169s 301.641s 19 34 3.436s 0.028s 3.487s 20 762 207.891s 0.091s 208.028s 21 3,190 319.745s 0.11s 319.919s 22 2,336 234.639s 0.069s 234.767s 23 387 41.838s 0.042s 41.946s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 17 00 0 0 2 28 0.013s 0.002s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 4 36 1.080s 0.035s 04 0 0 0 0 0s 0s 05 0 0 3 156 0.061s 0.017s 06 0 0 0 10 0.008s 0.001s 07 0 0 19 2,443 0.065s 0.011s 08 0 0 30 5,697 0.050s 0.012s 09 0 0 47 7,867 0.066s 0.012s 10 0 0 46 7,257 0.069s 0.012s 11 0 0 32 7,312 0.080s 0.012s 12 0 0 21 3,763 0.063s 0.012s 13 0 0 14 5,027 0.060s 0.012s 14 0 0 46 7,008 0.047s 0.012s 15 0 0 59 7,813 0.032s 0.012s 16 0 0 60 6,771 0.074s 0.012s 17 0 0 29 4,918 0.076s 0.011s 18 0 0 1 585 0.066s 0.007s 19 0 0 0 9 0.026s 0.004s 20 0 0 1 88 0.042s 0.007s 21 0 0 1 496 0.062s 0.011s 22 0 0 0 425 0.017s 0.014s 23 0 0 1 39 0.025s 0.01s Day Hour Count Avg time (sec) Aug 17 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 17 00 27,973.00 kB 27,973.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 31,538.50 kB 31,538.50 kB 04 0.00 kB 0.00 kB 05 6,395.62 kB 9,462.25 kB 06 7,225.00 kB 10,630.00 kB 07 27,575.27 kB 53,724.27 kB 08 40,852.25 kB 92,492.08 kB 09 64,249.25 kB 94,014.50 kB 10 63,630.08 kB 104,279.67 kB 11 43,475.83 kB 82,294.58 kB 12 27,812.25 kB 65,031.25 kB 13 19,817.00 kB 34,638.08 kB 14 62,996.50 kB 98,747.33 kB 15 80,107.50 kB 112,582.17 kB 16 82,210.33 kB 116,216.42 kB 17 42,823.36 kB 99,526.73 kB 18 2,269.71 kB 53,020.29 kB 19 237.00 kB 34,658.00 kB 20 4,223.25 kB 28,131.25 kB 21 2,412.50 kB 17,590.50 kB 22 1,389.22 kB 9,007.33 kB 23 169.67 kB 4,478.50 kB -
Temporary Files
Size of temporary files
Key values
- 481.64 MiB Temp Files size Peak
- 2026-08-17 05:32:09 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-17 05:32:16 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 17 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.95 MiB 06 0 0 0 07 0 0 0 08 1 104.00 MiB 104.00 MiB 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 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 935.74 MiB 71.83 MiB 240.82 MiB 116.97 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-17 05:32:17 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-17 05:32:09 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 183.78 MiB 91.89 MiB 91.89 MiB 91.89 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-17 05:30:45 Duration: 43s389ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-17 05:30:41 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 1 104.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028582, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-17 14:33:00 Duration: 8m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028544, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-17 07:28:26 Duration: 8m47s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028560, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-17 10:20:04 Duration: 7m48s Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 240.82 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-17 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 240.82 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-17 05:32:09 - 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-17 08:22:41 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 91.89 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-17 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 91.89 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-17 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 79.57 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-17 05:32:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 79.48 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-17 05:32:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 79.48 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-17 05:32:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 71.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-17 05:32:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 71.83 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-17 05:32:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 71.83 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-17 05:32:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 21.33 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-17 14:41:09 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 21.33 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-17 14:41:09 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (120) Main table analyzed (database rio)
- 1,115 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 120 rio.pg_catalog.pg_class 66 rio.pg_catalog.pg_type 54 rio.public.usuarios 48 rio.public.temp0000288580 40 brasilia.public.temp0000238322 38 rio.pg_catalog.pg_index 37 brasilia.pg_catalog.pg_attribute 37 rio.public.temp0000288562 35 rio.public.temp0000288600 34 contagem.public.usuarios 33 contagem.pg_catalog.pg_attribute 30 rio.public.temp0000288660 28 rio.pg_catalog.pg_depend 28 rio.public.temp0000288686 24 rio.public.temp0000288670 19 brasilia.pg_catalog.pg_class 18 rio.public.temp0000288566 18 contagem.pg_catalog.pg_class 18 rio.public.temp0000288594 18 rio.public.temp0000288622 17 brasilia.pg_catalog.pg_type 15 contagem.pg_catalog.pg_type 15 brasilia.public.temp0000238264 15 rio.public.temp0000288578 15 rio.public.temp0000288590 15 rio.public.temp0000288598 14 brasilia.public.temp0000238338 13 rio.public.temp0000288642 12 contagem.public.temp0000226858 12 rio.public.temp0000288572 12 rio.public.temp0000288658 11 brasilia.public.temp0000238292 11 brasilia.public.temp0000238282 10 rio.public.temp0000288560 10 brasilia.pg_catalog.pg_index 9 contagem.public.temp0000226852 9 contagem.pg_catalog.pg_index 9 contagem.public.temp0000226850 9 brasilia.public.usuarios 9 rio.public.temp0000288610 8 rio.public.temp0000288136 7 brasilia.pg_catalog.pg_depend 7 rio.public.temp0000288564 6 rio.public.temp0000288584 6 rio.pg_catalog.pg_shdepend 6 contagem.pg_catalog.pg_depend 6 brasilia.public.temp0000238354 5 rio.public.temp0000288652 5 rio.public.temp0000288574 4 brasilia.public.temp0000238312 4 brasilia.public.temp0000238366 4 contagem.public.temp0000226862 4 rio.public.temp0000288604 4 rio.public.tmp_drill_0175 3 rio.public.temp0000288656 3 rio.public.tmp_drill_0320 3 contagem.pg_catalog.pg_shdepend 3 contagem.public.nf_entrada 2 rio.public.temp0000288688 2 rio.public.temp0000288614 2 brasilia.public.temp0000238324 2 brasilia.public.temp0000238302 2 rio.public.temp0000288606 2 contagem.public.temp0000226856 2 rio.public.temp0000288672 1 brasilia.pg_catalog.pg_shdepend 1 brasilia.public.temp0000238342 1 postgres.pg_catalog.pg_shdepend 1 rio.public.temp0000288681 1 rio.public.temp0000288634 1 brasilia.public.temp0000238336 1 brasilia.public.temp0000238350 1 rio.public.temp0000288690 1 rio.public.temp0000288678 1 rio.public.temp0000288676 1 contagem.public.temp0000226832 1 brasilia.public.temp0000238340 1 brasilia.public.temp0000238286 1 brasilia.public.temp0000238284 1 rio.public.temp0000288644 1 brasilia.public.temp0000238268 1 rio.public.temp0000288582 1 rio.public.tmp_drill_0302 1 brasilia.public.temp0000238344 1 rio.public.temp0000288586 1 brasilia.public.temp0000238332 1 template1.pg_catalog.pg_shdepend 1 brasilia.public.temp0000238272 1 rio.public.temp0000288666 1 rio.public.temp0000288602 1 rio.public.temp0000288588 1 rio.public.temp0000288620 1 Total 1,115 Vacuums per table
Key values
- pg_catalog.pg_attribute (61) Main table vacuumed on database rio
- 516 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 61 45 0 0 0 0 0 23,045 6,296 9,216,163 404 9,897 rio.pg_catalog.pg_class 44 26 0 0 0 0 0 4,783 1,471 2,248,464 97 320 rio.pg_catalog.pg_type 36 23 0 0 0 0 0 2,413 804 1,014,971 91 288 rio.public.temp0000288562 35 0 0 0 0 0 0 16,707 156 1,010,099 0 0 contagem.public.usuarios 33 0 0 0 0 0 0 155 120 64,023 0 0 rio.public.temp0000288686 22 0 0 0 0 0 0 8,621 123 527,587 0 0 rio.public.usuarios 21 9 0 0 0 0 0 251 84 183,463 13 18 rio.public.temp0000288670 19 0 0 0 0 0 0 17,929 164 1,226,103 0 0 rio.public.temp0000288622 17 0 0 0 0 0 0 20,826 1,792 3,468,332 0 0 rio.pg_catalog.pg_index 14 13 0 0 0 0 0 656 194 209,345 40 106 rio.public.temp0000288660 12 0 0 0 0 0 0 3,759 57 230,848 0 0 contagem.pg_catalog.pg_attribute 11 11 0 0 0 0 0 7,221 1,740 3,231,571 21 628 rio.pg_catalog.pg_depend 11 11 0 0 0 0 0 3,294 1,341 1,726,371 87 693 brasilia.pg_catalog.pg_attribute 11 11 0 0 0 0 0 5,636 1,568 2,324,010 64 1,591 rio.public.temp0000288572 11 0 0 0 0 0 0 8,687 38 518,776 0 0 rio.pg_catalog.pg_statistic 10 10 0 0 0 0 0 12,000 2,993 13,596,287 1,073 5,125 rio.public.tmp_drill_0320 9 3 0 0 0 0 0 223 28 58,905 1 9 rio.public.temp0000288590 9 0 0 0 0 0 0 336 86 86,086 0 0 postgres.pg_catalog.pg_shdepend 8 8 0 0 0 0 0 1,237 433 667,376 74 129 brasilia.pg_catalog.pg_class 7 7 0 0 0 0 0 1,391 446 660,538 26 86 rio.public.temp0000288600 7 0 0 0 0 0 0 352 84 99,549 0 0 contagem.pg_catalog.pg_class 6 6 0 0 0 0 0 1,462 254 451,952 7 24 rio.public.temp0000288136 6 0 0 0 0 0 0 282 33 21,788 0 0 contagem.pg_catalog.pg_type 5 5 0 0 0 0 0 627 146 245,042 4 8 brasilia.pg_catalog.pg_type 5 5 0 0 0 0 0 458 128 187,188 14 38 rio.public.tmp_drill_0302 5 1 0 0 0 0 0 44 28 40,083 1 52 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 248 61 76,989 2 2 brasilia.pg_catalog.pg_statistic 4 4 0 0 0 0 0 5,069 1,315 5,379,074 946 5,796 rio.public.temp0000288610 4 0 0 0 0 0 0 208 102 148,923 0 0 contagem.public.temp0000226862 4 0 0 0 0 0 0 442 24 29,938 0 0 rio.public.temp0000288658 4 0 0 0 0 0 0 335 24 23,392 0 0 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,825 397 2,424,904 159 543 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 1,175 273 621,641 4 24 rio.public.temp0000288656 3 0 0 0 0 0 0 1,822 13 109,547 0 0 rio.public.tmp_drill_0175 3 3 0 0 0 0 0 383 30 89,448 0 0 brasilia.pg_catalog.pg_index 3 3 0 0 0 0 0 177 51 37,181 8 28 rio.public.temp0000288574 3 0 0 0 0 0 0 161 17 12,013 0 0 brasilia.public.temp0000238366 3 0 0 0 0 0 0 253 251 392,906 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 381 87 495,099 39 103 rio.public.temp0000288606 2 0 0 0 0 0 0 8 6 1,548 0 0 brasilia.pg_catalog.pg_depend 2 2 0 0 0 0 0 608 182 234,905 11 96 rio.public.temp0000288560 2 0 0 0 0 0 0 16 10 2,588 0 0 rio.public.temp0000288594 2 0 0 0 0 0 0 16 10 2,380 0 0 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,773 1,166 3,686,623 1,076 7,433 rio.public.temp0000288564 2 0 0 0 0 0 0 16 10 2,625 0 0 contagem.public.nf_entrada 2 2 0 0 0 0 0 142 5 18,031 0 0 rio.public.temp0000288614 2 0 0 0 0 0 0 57 11 4,920 0 0 contagem.public.codigos_barra 1 1 0 0 0 0 0 12,904 7,600 37,730,379 19 1,680 rio.public.temp0000288620 1 0 0 0 0 0 0 8 6 2,757 0 0 contagem.public.acessorios 1 1 0 0 0 0 0 536 355 1,206,625 10 740 rio.public.temp0000288588 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000288566 1 0 0 0 0 0 0 84 6 5,865 0 0 rio.public.temp0000288678 1 0 0 0 0 0 0 8 5 1,297 0 0 brasilia.public.temp0000238350 1 0 0 0 0 0 0 245 4 15,058 0 0 rio.public.temp0000288690 1 0 0 0 0 0 0 84 6 5,863 0 0 rio.public.notas_fiscais 1 0 0 0 0 0 0 27 24 89,295 1 185 rio.public.temp0000288652 1 0 0 0 0 0 0 1,733 4 102,850 0 0 rio.public.temp0000288666 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000288602 1 0 0 0 0 0 0 73 71 136,267 0 0 rio.public.temp0000288586 1 0 0 0 0 0 0 8 5 1,281 0 0 rio.auditor.auditor_2026_08 1 0 0 0 0 0 0 110,471 51,601 66,428,229 29,457 553,693 rio.public.temp0000288582 1 0 0 0 0 0 0 1,732 4 102,791 0 0 contagem.public.fluxo_passos 1 1 0 0 0 0 0 1,812 1,625 5,788,711 30 2,404 rio.public.temp0000288672 1 0 0 0 0 0 0 83 6 5,804 0 0 rio.public.temp0000288644 1 0 0 0 0 0 0 79 6 5,559 0 0 rio.public.lotes 1 1 0 0 0 0 0 2,825 2,125 5,699,663 74 3,371 rio.public.temp0000288676 1 0 0 0 0 0 0 8 5 1,298 0 0 brasilia.public.temp0000238324 1 0 0 0 0 0 0 245 4 15,058 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 126 54 171,644 22 47 Total 516 227 0 0 0 0 0 291,609 88,174 174,627,437 33,875 595,157 Vacuum throughput per table
Key values
- auditor.auditor_2026_08 (21.33) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 4.17 rio.pg_catalog.pg_class 0 0 1.1 rio.pg_catalog.pg_type 0 0 0.68 rio.public.temp0000288562 0 0 1.06 contagem.public.usuarios 0 0 0.02 rio.public.temp0000288686 0 0 0.51 rio.public.usuarios 0 0 0.01 rio.public.temp0000288670 0 0 0.68 rio.public.temp0000288622 0 0 0.86 rio.pg_catalog.pg_index 0 0 0.39 rio.public.temp0000288660 0 0 0.3 contagem.pg_catalog.pg_attribute 0 0 2.46 rio.pg_catalog.pg_depend 0 0 1.49 brasilia.pg_catalog.pg_attribute 0 0 1.7 rio.public.temp0000288572 0 0 0.51 rio.pg_catalog.pg_statistic 0 0 2.28 rio.public.tmp_drill_0320 0 0 0 rio.public.temp0000288590 0 0 0.1 postgres.pg_catalog.pg_shdepend 0 0 0.55 brasilia.pg_catalog.pg_class 0 0 1 rio.public.temp0000288600 0 0 0.34 contagem.pg_catalog.pg_class 0 0 1.03 rio.public.temp0000288136 0 0 0.1 contagem.pg_catalog.pg_type 0 0 0.37 brasilia.pg_catalog.pg_type 0 0 0.46 rio.public.tmp_drill_0302 0 0 0 contagem.pg_catalog.pg_index 0 0 0.42 brasilia.pg_catalog.pg_statistic 0 0 1.11 rio.public.temp0000288610 0 0 0.06 contagem.public.temp0000226862 0 0 0.14 rio.public.temp0000288658 0 0 0.06 rio.pg_toast.pg_toast_2619 0 0 0.23 contagem.pg_catalog.pg_depend 0 0 0.69 rio.public.temp0000288656 0 0 0.11 rio.public.tmp_drill_0175 0 0 0.01 brasilia.pg_catalog.pg_index 0 0 0.19 rio.public.temp0000288574 0 0 0.05 brasilia.public.temp0000238366 0 0 0.01 brasilia.pg_toast.pg_toast_2619 0 0 0.1 rio.public.temp0000288606 0 0 0.09 brasilia.pg_catalog.pg_depend 0 0 0.43 rio.public.temp0000288560 0 0 0.02 rio.public.temp0000288594 0 0 0.02 contagem.pg_catalog.pg_statistic 0 0 0.29 rio.public.temp0000288564 0 0 0.03 contagem.public.nf_entrada 0 0 0.09 rio.public.temp0000288614 0 0 0.02 contagem.public.codigos_barra 0 0 10.53 rio.public.temp0000288620 0 0 0.01 contagem.public.acessorios 0 0 0.24 rio.public.temp0000288588 0 0 0 rio.public.temp0000288566 0 0 0.01 rio.public.temp0000288678 0 0 0.02 brasilia.public.temp0000238350 0 0 0 rio.public.temp0000288690 0 0 0.01 rio.public.notas_fiscais 0 0 0.12 rio.public.temp0000288652 0 0 0.06 rio.public.temp0000288666 0 0 0.04 rio.public.temp0000288602 0 0 0.07 rio.public.temp0000288586 0 0 0.01 rio.auditor.auditor_2026_08 0 0 21.33 rio.public.temp0000288582 0 0 0.06 contagem.public.fluxo_passos 0 0 1.48 rio.public.temp0000288672 0 0 0.02 rio.public.temp0000288644 0 0 0.01 rio.public.lotes 0 0 1.09 rio.public.temp0000288676 0 0 0.02 brasilia.public.temp0000238324 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 Total 0 0 61.47 Tuples removed per table
Key values
- pg_catalog.pg_attribute (180173) Main table with removed tuples on database rio
- 371329 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 61 45 180,173 1,654,237 195,959 10 41,690 contagem.pg_catalog.pg_attribute 11 11 56,838 257,678 0 344 5,857 brasilia.pg_catalog.pg_attribute 11 11 42,764 243,729 0 133 6,066 rio.pg_catalog.pg_statistic 10 10 15,787 85,677 1,424 0 12,860 rio.pg_catalog.pg_depend 11 11 9,309 218,137 7,288 39 1,958 rio.pg_catalog.pg_type 36 23 7,250 92,870 11,034 61 2,649 brasilia.pg_catalog.pg_statistic 4 4 7,112 33,577 0 0 4,288 postgres.pg_catalog.pg_shdepend 8 8 6,931 110,409 1,703 0 992 contagem.pg_catalog.pg_class 6 6 6,914 24,722 0 77 1,067 rio.pg_catalog.pg_class 44 26 5,155 188,635 31,510 40 5,987 contagem.pg_catalog.pg_statistic 2 2 5,132 14,891 0 0 2,022 contagem.pg_catalog.pg_type 5 5 3,308 11,255 0 52 319 rio.public.tmp_drill_0320 9 3 3,097 11,797 4,350 0 192 rio.auditor.auditor_2026_08 1 0 3,014 10,059,582 0 0 483,836 contagem.pg_catalog.pg_depend 3 3 2,935 57,594 0 43 508 rio.pg_catalog.pg_index 14 13 2,729 28,351 1,433 0 766 contagem.public.usuarios 33 0 2,037 922 65 0 66 contagem.pg_catalog.pg_index 4 4 1,543 7,593 0 31 189 brasilia.pg_catalog.pg_class 7 7 1,420 27,436 0 21 959 brasilia.pg_catalog.pg_type 5 5 1,404 11,083 0 15 315 brasilia.pg_catalog.pg_depend 2 2 1,301 35,840 0 18 347 rio.pg_toast.pg_toast_2619 3 3 1,030 2,299 0 0 798 rio.public.usuarios 21 9 852 14,325 3,636 0 441 brasilia.pg_catalog.pg_index 3 3 776 5,651 0 9 156 rio.public.tmp_drill_0302 5 1 549 4,941 2,196 0 75 rio.public.tmp_drill_0175 3 3 527 6,524 0 0 164 contagem.public.nf_entrada 2 2 442 3,172 0 0 158 rio.public.lotes 1 1 273 172,979 0 0 2,778 brasilia.pg_toast.pg_toast_2619 2 2 195 268 0 0 124 contagem.public.acessorios 1 1 174 21,825 0 0 211 contagem.public.codigos_barra 1 1 161 932,340 0 0 6,460 contagem.pg_toast.pg_toast_2619 1 1 100 112 0 0 51 contagem.public.fluxo_passos 1 1 95 377,182 0 0 3,746 rio.public.notas_fiscais 1 0 2 184,066 0 0 998 rio.public.temp0000288620 1 0 0 1,214 0 62 66 rio.public.temp0000288588 1 0 0 1,189 0 0 64 rio.public.temp0000288566 1 0 0 1,394 0 52 76 rio.public.temp0000288678 1 0 0 1,394 0 53 75 brasilia.public.temp0000238350 1 0 0 3,220 0 0 256 rio.public.temp0000288690 1 0 0 1,400 0 52 76 rio.public.temp0000288652 1 0 0 24,436 0 0 1,792 rio.public.temp0000288666 1 0 0 24,442 0 0 1,792 rio.public.temp0000288602 1 0 0 1,191 0 63 65 rio.public.temp0000288670 19 0 0 303,110 0 371 22,029 rio.public.temp0000288606 2 0 0 48,835 0 0 3,456 rio.public.temp0000288562 35 0 0 460,787 0 837 32,699 rio.public.temp0000288560 2 0 0 7,736 0 83 173 rio.public.temp0000288136 6 0 0 21,032 0 168 472 rio.public.temp0000288594 2 0 0 2,121 0 16 48 rio.public.temp0000288586 1 0 0 1,188 0 63 65 rio.public.temp0000288610 4 0 0 10,984 0 169 247 rio.public.temp0000288656 3 0 0 50,313 0 53 3,659 contagem.public.temp0000226862 4 0 0 5,321 0 103 409 rio.public.temp0000288572 11 0 0 268,763 0 0 19,584 rio.public.temp0000288590 9 0 0 19,078 0 149 427 rio.public.temp0000288660 12 0 0 117,015 0 417 7,775 rio.public.temp0000288582 1 0 0 24,416 0 0 1,728 rio.public.temp0000288672 1 0 0 1,388 0 53 75 rio.public.temp0000288686 22 0 0 149,966 0 690 8,782 rio.public.temp0000288644 1 0 0 1,314 0 57 71 rio.public.temp0000288564 2 0 0 8,670 0 62 194 rio.public.temp0000288658 4 0 0 5,588 0 209 303 rio.public.temp0000288676 1 0 0 1,388 0 53 75 rio.public.temp0000288600 7 0 0 19,981 0 191 449 rio.public.temp0000288622 17 0 0 415,531 0 0 30,080 brasilia.public.temp0000238324 1 0 0 3,218 0 0 256 rio.public.temp0000288574 3 0 0 8,259 0 71 185 rio.public.temp0000288614 2 0 0 2,930 0 29 67 brasilia.public.temp0000238366 3 0 0 9,660 0 0 768 Total 516 227 371,329 16,930,171 260,598 5,019 727,431 Pages removed per table
Key values
- public.temp0000288562 (837) Main table with removed pages on database rio
- 5019 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000288562 35 0 0 837 rio.public.temp0000288686 22 0 0 690 rio.public.temp0000288660 12 0 0 417 rio.public.temp0000288670 19 0 0 371 contagem.pg_catalog.pg_attribute 11 11 56838 344 rio.public.temp0000288658 4 0 0 209 rio.public.temp0000288600 7 0 0 191 rio.public.temp0000288610 4 0 0 169 rio.public.temp0000288136 6 0 0 168 rio.public.temp0000288590 9 0 0 149 brasilia.pg_catalog.pg_attribute 11 11 42764 133 contagem.public.temp0000226862 4 0 0 103 rio.public.temp0000288560 2 0 0 83 contagem.pg_catalog.pg_class 6 6 6914 77 rio.public.temp0000288574 3 0 0 71 rio.public.temp0000288602 1 0 0 63 rio.public.temp0000288586 1 0 0 63 rio.public.temp0000288620 1 0 0 62 rio.public.temp0000288564 2 0 0 62 rio.pg_catalog.pg_type 36 23 7250 61 rio.public.temp0000288644 1 0 0 57 rio.public.temp0000288678 1 0 0 53 rio.public.temp0000288656 3 0 0 53 rio.public.temp0000288672 1 0 0 53 rio.public.temp0000288676 1 0 0 53 rio.public.temp0000288566 1 0 0 52 rio.public.temp0000288690 1 0 0 52 contagem.pg_catalog.pg_type 5 5 3308 52 contagem.pg_catalog.pg_depend 3 3 2935 43 rio.pg_catalog.pg_class 44 26 5155 40 rio.pg_catalog.pg_depend 11 11 9309 39 contagem.pg_catalog.pg_index 4 4 1543 31 rio.public.temp0000288614 2 0 0 29 brasilia.pg_catalog.pg_class 7 7 1420 21 brasilia.pg_catalog.pg_depend 2 2 1301 18 rio.public.temp0000288594 2 0 0 16 brasilia.pg_catalog.pg_type 5 5 1404 15 rio.pg_catalog.pg_attribute 61 45 180173 10 brasilia.pg_catalog.pg_index 3 3 776 9 contagem.public.codigos_barra 1 1 161 0 rio.public.usuarios 21 9 852 0 contagem.public.acessorios 1 1 174 0 rio.public.temp0000288588 1 0 0 0 brasilia.public.temp0000238350 1 0 0 0 rio.public.notas_fiscais 1 0 2 0 rio.public.temp0000288652 1 0 0 0 brasilia.pg_toast.pg_toast_2619 2 2 195 0 rio.public.temp0000288666 1 0 0 0 brasilia.pg_catalog.pg_statistic 4 4 7112 0 rio.public.temp0000288606 2 0 0 0 rio.pg_toast.pg_toast_2619 3 3 1030 0 rio.public.tmp_drill_0320 9 3 3097 0 postgres.pg_catalog.pg_shdepend 8 8 6931 0 rio.auditor.auditor_2026_08 1 0 3014 0 rio.public.temp0000288572 11 0 0 0 rio.public.tmp_drill_0175 3 3 527 0 rio.public.tmp_drill_0302 5 1 549 0 rio.public.temp0000288582 1 0 0 0 contagem.public.fluxo_passos 1 1 95 0 contagem.pg_catalog.pg_statistic 2 2 5132 0 contagem.public.usuarios 33 0 2037 0 rio.pg_catalog.pg_index 14 13 2729 0 rio.pg_catalog.pg_statistic 10 10 15787 0 rio.public.lotes 1 1 273 0 rio.public.temp0000288622 17 0 0 0 brasilia.public.temp0000238324 1 0 0 0 contagem.public.nf_entrada 2 2 442 0 contagem.pg_toast.pg_toast_2619 1 1 100 0 brasilia.public.temp0000238366 3 0 0 0 Total 516 227 371,329 5,019 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 17 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 6 12 08 43 90 09 91 137 10 67 142 11 40 140 12 20 43 13 19 68 14 51 127 15 52 148 16 72 129 17 44 72 18 2 5 19 0 0 20 0 0 21 3 2 22 0 0 23 0 0 - 21.33 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 9 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 5 13m53s 1m15s 3m50s 2m46s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-17 08:49:05 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-17 08:28:27 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-17 07:28:27 Database: rio User: intelifix Remote: [local] Application: psql
2 2 3s744ms 1s306ms 2s438ms 1s872ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52953, 406, '836030905001924,241728551632,241704648603,241664773443,241622436572,241732087980,241728526376,241654532545,241599288196,241728671621,241598837591,241708521024,241731238694,241664814457,241617447286,230043318693,241667756876,241713695658,241620852737,241676631739,241727046467,241676663436,241700930317,241704382135,241704165974,241708987185,241704739497,241689459107,241695524547,241636028190,241676735362,241706685165,241610117390,241594349094,241645810830,241728680006,241607244349,241622562040,241732109902,241666955878,241607233641,241728679499,241680297797,241692655973,241727053741,241727260406,241608708802,241695617586,241631264864,241620712342,241661218405', '',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-17 14:28:00 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52916, 406, '270911029132107551,229726410415,229755875265,229669753235,216941986161,229736813450,229755008907,229735571219,229741654259,229817050417,229859086673,229805221619,229735559803,229813385569,229687352136,229745333350,229880019299,229664247175,229728467180,216945127388,229686226481,216944103035,229749599400,216937556582,229925397084,229809398692,229689784045,229786736683,229864928197,229879519700,229780839193,229689029314,229736846483,229669254971,229755448298,229807180621,229782747988,229805744756,229805245055,229809535272,229669490707,229728562847,229813800414,229805245762,229663868698,216945082334,229748817595,229752744062,229859193755,229745689298,229742000410', '246506731120,246559542828,246548880924,246471264650,246528454564,246587399901,246542826471,246530885160,246632310514,246641329205,246598450610,246509277888,246630120828,246517568495,246535987992,246652852440,246467952947,246543938083,246489124665,246515627374,246498352547,246562562831,246442025758,246042535659,246629425574,246516512041,246598590018,246648107778,246652546270,246585998888,246521431926,246532728291,246516094850,246588241129,246581535266,246597883753,246581746375,246598447376,246629424867,246514842136,246545001331,246628980930,246593072139,246471633351,246488087380,246551319702,246566537786,246642197179,246542845463,246549614968', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-17 11:28:08 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (133219, 401, 'ZTE3ANNT3H15111,D831399825C2,D831399825C3,ZTEGDD320BA6$ZTE3ANNQ7101666,C4EBFF89EF74,C4EBFF89EF75,ZTEGD70A2354$ZTE3ANNQ7901538,C4EBFF8C421C,C4EBFF8C421D,ZTEGD70A8670$ZTE3ANNR9F15124,D89A0DA4405B,D89A0DA4405C,ZTEGDB15625F$ZTE3ANNT3F15887,D8313996A022,D8313996A023,ZTEGDD31CAB6$ZTE3ANNRCP73926,6C11BA6FEF73,6C11BA6FEF74,ZTEGDC706159$ZTE3ANNT2V51383,D83139904322,D83139904323,ZTEGDD30BB36$ZTE3ANNR4N13476,4896D95696F0,4896D95696F1,ZTEGD97F5469$ZTE3ANNRAD25655,D89A0DB033AD,D89A0DB033AE,ZTEGDB176042$ZTE3ANNQ5N05248,3CF9F0AD4076,3CF9F0AD4077,ZTEGD641CAC7$ZTE3ANNR3Y51927,4896D95481C2,4896D95481C3,ZTEGD97EFB8C$ZTE3ANNR9336670,D89A0D85BB7F,D89A0D85BB80,ZTEGDB15033D$ZTE3ANNR1Y17439,14CA56CE4335,14CA56CE4336,ZTEGD970BA7A$ZTE3ANNQ4A10727,3CF9F0AAF3B0,3CF9F0AAF3B1,ZTEGD64168A6$ZTE3ANNR6R32458,48D682387D7E,48D682387D7F,ZTEGDB01A99D$ZTE3ANNQ7112235,C4EBFF8AE72A,C4EBFF8AE72B,ZTEGD70A4C9D$ZTE3ANNR5W57569,48D68233C910,48D68233C911,ZTEGDB00E0E0$ZTE3ANNQ9J38182,843C992F5019,843C992F501A,ZTEGD7BB9DD1$ZTE3ANNRAM39021,5872C98ACAC7,5872C98ACAC8,ZTEGDC60986C$ZTE3ANNR9300427,D89A0D826A0D,D89A0D826A0E,ZTEGDB1475AA$ZTE3ANNR2Q13725,F4E84F81F5AE,F4E84F81F5AF,ZTEGD97AA857$ZTE3ANNQ9J43607,843C992FCF3F,843C992FCF40,ZTEGD7BBB302$ZTE3ANNT2V80356,D8313992EA30,D8313992EA31,ZTEGDD312C63$ZTE3ANNQ9J43742,843C992FD269,843C992FD26A,ZTEGD7BBB389$ZTE3ANNR3Y05576,4896D9504368,4896D9504369,ZTEGD97E467D$ZTE3ANNRAM61820,5872C98CE121,5872C98CE122,ZTEGDC60F17B', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-17 09:51:22 Database: brasilia User: intelifix Remote: [local] Application: [unknown]
3 1 1s9ms 1s9ms 1s9ms 1s9ms drop table if exists temp0000288572;-
DROP TABLE IF EXISTS temp0000288572;
Date: 2026-08-17 11:11:47 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000288572;
Date: 2026-08-17 11:07:48 Database: rio User: intelifix Remote: [local] Application: [unknown]
4 1 1s 1s 1s 1s drop table if exists temp0000288686;-
DROP TABLE IF EXISTS temp0000288686;
Date: 2026-08-17 16:26:50 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000288686;
Date: 2026-08-17 16:26:50 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 3m50s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-17 08:49:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 3m8s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-17 07:28:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 3m7s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-17 08:28:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 2m30s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-17 15:57:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 1m15s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-17 15:26:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 2s438ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52923, 406, '466048153345,216656476580$465028136676,216464125462$466019272135,216652298091$467192014550,216787949602$464276308485,216329569401$467047118905,216760477291$467060009407,216765616569$467020028696,216747872930$467053223954,216762010921$466034412338,216655442832$464325305964,216420510017$465034495454,216468868002$467026055051,216748770527$466204197383,216709540413$465107288386,216580795064$466349178592,216743991115$465159199100,216588761723$465040580317,216471099308$465216040622,216595055468$464232081026,184297547287', '',034,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);[ Date: 2026-08-17 11:41:19 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
7 1s306ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52986, 406, '11725785850044707644,942CB3F5AA69$11725785850044705786,942CB3F511FF', '',039,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""}]','$','', 00);[ Date: 2026-08-17 14:46:32 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
8 1s9ms DROP TABLE IF EXISTS temp0000288572;[ Date: 2026-08-17 11:11:47 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 1s DROP TABLE IF EXISTS temp0000288686;[ Date: 2026-08-17 16:26:50 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,466 Total read queries
- 1,599 Total write queries
Queries by database
Key values
- rio Main database
- 4,064 Requests
- 9h17m23s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,354 Requests
User Request type Count Duration etiquetas Total 105 29s16ms select 105 29s16ms intelifix Total 6,354 11h53m13s copy to 418 43m44s ddl 1,181 1h5m11s others 517 1h13m36s select 4,238 8h50m39s lenon Total 123 1m31s select 123 1m31s Duration by user
Key values
- 11h53m13s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 105 29s16ms select 105 29s16ms intelifix Total 6,354 11h53m13s copy to 418 43m44s ddl 1,181 1h5m11s others 517 1h13m36s select 4,238 8h50m39s lenon Total 123 1m31s select 123 1m31s Queries by host
Key values
- [local] Main host
- 6,582 Requests
- 11h55m14s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,394 Requests
- 6h11m48s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-17 08:45:37 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,929 100-500ms duration
Slowest individual queries
Rank Duration Query 1 16m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-17 07:21:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 14m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-17 09:19:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 13m18s analyze verbose;[ Date: 2026-08-17 05:13:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 13m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-17 10:18:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 12m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-17 12:17:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 12m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-17 15:17:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 12m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-17 11:17:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 12m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-17 14:17:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 12m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-17 17:17:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 11m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-17 20:16:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 11m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-17 16:16:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 11m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-17 18:16:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 8m52s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028582, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-17 14:33:00 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 8m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-17 08:13:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 8m47s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028544, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-17 07:28:26 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 8m23s analyze verbose;[ Date: 2026-08-17 05:21:43 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
17 7m48s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028560, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-17 10:20:04 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 7m9s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028561, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-17 10:36:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 7m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-17 13:12:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 7m4s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028569, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-17 11:34:35 - 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 3h10m9s 48 1s674ms 16m9s 3m57s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 17 07 3 17m38s 5m52s 08 3 9m13s 3m4s 09 3 15m48s 5m16s 10 3 14m30s 4m50s 11 3 13m40s 4m33s 12 3 14m1s 4m40s 13 3 7m28s 2m29s 14 3 13m22s 4m27s 15 3 13m44s 4m34s 16 3 12m56s 4m18s 17 3 13m19s 4m26s 18 3 12m9s 4m3s 19 3 5m56s 1m58s 20 3 12m35s 4m11s 21 3 7m14s 2m24s 22 3 6m29s 2m9s [ User: intelifix - Total duration: 3h10m9s - Times executed: 48 ]
[ Application: psql - Total duration: 3h10m9s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-17 07:21:11 Duration: 16m9s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-17 09:19:24 Duration: 14m22s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-17 10:18:15 Duration: 13m13s Database: rio User: intelifix Remote: [local] Application: psql
2 2h34m43s 324 153ms 8m52s 28s652ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 17 07 5 14m13s 2m50s 08 18 15m29s 51s625ms 09 63 22m25s 21s353ms 10 33 21m34s 39s235ms 11 27 15m54s 35s364ms 12 10 8m11s 49s165ms 13 27 16s608ms 615ms 14 53 9m55s 11s231ms 15 29 29m45s 1m1s 16 33 9m8s 16s617ms 17 24 7m48s 19s520ms 18 2 452ms 226ms [ User: intelifix - Total duration: 2h34m43s - Times executed: 324 ]
[ Application: [unknown] - Total duration: 2h34m43s - Times executed: 324 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028582, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-17 14:33:00 Duration: 8m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028544, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-17 07:28:26 Duration: 8m47s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028560, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-17 10:20:04 Duration: 7m48s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h35m33s 47 269ms 5m40s 2m1s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 17 07 3 7m56s 2m38s 08 3 4m52s 1m37s 09 3 7m43s 2m34s 10 2 5m44s 2m52s 11 3 7m18s 2m26s 12 3 6m49s 2m16s 13 3 4m11s 1m23s 14 3 6m51s 2m17s 15 3 7m5s 2m21s 16 3 6m49s 2m16s 17 3 6m53s 2m17s 18 3 5m10s 1m43s 19 3 3m40s 1m13s 20 3 6m28s 2m9s 21 3 3m48s 1m16s 22 3 4m8s 1m22s [ User: intelifix - Total duration: 1h35m33s - Times executed: 47 ]
[ Application: psql - Total duration: 1h35m33s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-17 10:26:42 Duration: 5m40s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-17 09:28:12 Duration: 5m38s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-17 11:25:45 Duration: 5m35s Database: brasilia User: intelifix Remote: [local] Application: psql
4 27m53s 1,140 150ms 7s720ms 1s468ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 17 08 83 1m32s 1s111ms 09 170 3m38s 1s285ms 10 154 3m26s 1s338ms 11 141 3m43s 1s584ms 12 31 47s930ms 1s546ms 13 90 2m1s 1s345ms 14 172 4m28s 1s560ms 15 150 3m44s 1s498ms 16 97 3m4s 1s906ms 17 47 1m18s 1s676ms 18 5 7s182ms 1s436ms [ User: intelifix - Total duration: 27m53s - Times executed: 1140 ]
[ Application: [unknown] - Total duration: 27m53s - Times executed: 1140 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52953, 406, '836030905001924,241728551632,241704648603,241664773443,241622436572,241732087980,241728526376,241654532545,241599288196,241728671621,241598837591,241708521024,241731238694,241664814457,241617447286,230043318693,241667756876,241713695658,241620852737,241676631739,241727046467,241676663436,241700930317,241704382135,241704165974,241708987185,241704739497,241689459107,241695524547,241636028190,241676735362,241706685165,241610117390,241594349094,241645810830,241728680006,241607244349,241622562040,241732109902,241666955878,241607233641,241728679499,241680297797,241692655973,241727053741,241727260406,241608708802,241695617586,241631264864,241620712342,241661218405', '',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-17 14:28:00 Duration: 7s720ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52916, 406, '270911029132107551,229726410415,229755875265,229669753235,216941986161,229736813450,229755008907,229735571219,229741654259,229817050417,229859086673,229805221619,229735559803,229813385569,229687352136,229745333350,229880019299,229664247175,229728467180,216945127388,229686226481,216944103035,229749599400,216937556582,229925397084,229809398692,229689784045,229786736683,229864928197,229879519700,229780839193,229689029314,229736846483,229669254971,229755448298,229807180621,229782747988,229805744756,229805245055,229809535272,229669490707,229728562847,229813800414,229805245762,229663868698,216945082334,229748817595,229752744062,229859193755,229745689298,229742000410', '246506731120,246559542828,246548880924,246471264650,246528454564,246587399901,246542826471,246530885160,246632310514,246641329205,246598450610,246509277888,246630120828,246517568495,246535987992,246652852440,246467952947,246543938083,246489124665,246515627374,246498352547,246562562831,246442025758,246042535659,246629425574,246516512041,246598590018,246648107778,246652546270,246585998888,246521431926,246532728291,246516094850,246588241129,246581535266,246597883753,246581746375,246598447376,246629424867,246514842136,246545001331,246628980930,246593072139,246471633351,246488087380,246551319702,246566537786,246642197179,246542845463,246549614968', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-17 11:28:08 Duration: 7s465ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (133219, 401, 'ZTE3ANNT3H15111,D831399825C2,D831399825C3,ZTEGDD320BA6$ZTE3ANNQ7101666,C4EBFF89EF74,C4EBFF89EF75,ZTEGD70A2354$ZTE3ANNQ7901538,C4EBFF8C421C,C4EBFF8C421D,ZTEGD70A8670$ZTE3ANNR9F15124,D89A0DA4405B,D89A0DA4405C,ZTEGDB15625F$ZTE3ANNT3F15887,D8313996A022,D8313996A023,ZTEGDD31CAB6$ZTE3ANNRCP73926,6C11BA6FEF73,6C11BA6FEF74,ZTEGDC706159$ZTE3ANNT2V51383,D83139904322,D83139904323,ZTEGDD30BB36$ZTE3ANNR4N13476,4896D95696F0,4896D95696F1,ZTEGD97F5469$ZTE3ANNRAD25655,D89A0DB033AD,D89A0DB033AE,ZTEGDB176042$ZTE3ANNQ5N05248,3CF9F0AD4076,3CF9F0AD4077,ZTEGD641CAC7$ZTE3ANNR3Y51927,4896D95481C2,4896D95481C3,ZTEGD97EFB8C$ZTE3ANNR9336670,D89A0D85BB7F,D89A0D85BB80,ZTEGDB15033D$ZTE3ANNR1Y17439,14CA56CE4335,14CA56CE4336,ZTEGD970BA7A$ZTE3ANNQ4A10727,3CF9F0AAF3B0,3CF9F0AAF3B1,ZTEGD64168A6$ZTE3ANNR6R32458,48D682387D7E,48D682387D7F,ZTEGDB01A99D$ZTE3ANNQ7112235,C4EBFF8AE72A,C4EBFF8AE72B,ZTEGD70A4C9D$ZTE3ANNR5W57569,48D68233C910,48D68233C911,ZTEGDB00E0E0$ZTE3ANNQ9J38182,843C992F5019,843C992F501A,ZTEGD7BB9DD1$ZTE3ANNRAM39021,5872C98ACAC7,5872C98ACAC8,ZTEGDC60986C$ZTE3ANNR9300427,D89A0D826A0D,D89A0D826A0E,ZTEGDB1475AA$ZTE3ANNR2Q13725,F4E84F81F5AE,F4E84F81F5AF,ZTEGD97AA857$ZTE3ANNQ9J43607,843C992FCF3F,843C992FCF40,ZTEGD7BBB302$ZTE3ANNT2V80356,D8313992EA30,D8313992EA31,ZTEGDD312C63$ZTE3ANNQ9J43742,843C992FD269,843C992FD26A,ZTEGD7BBB389$ZTE3ANNR3Y05576,4896D9504368,4896D9504369,ZTEGD97E467D$ZTE3ANNRAM61820,5872C98CE121,5872C98CE122,ZTEGDC60F17B', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-17 09:51:22 Duration: 6s727ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
5 27m31s 275 172ms 3m56s 6s6ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 17 00 12 53s859ms 4s488ms 01 12 31s290ms 2s607ms 02 12 30s44ms 2s503ms 03 11 24s425ms 2s220ms 04 12 31s337ms 2s611ms 05 12 31s169ms 2s597ms 06 12 31s156ms 2s596ms 07 12 3m40s 18s389ms 08 12 7m34s 37s851ms 09 12 49s308ms 4s109ms 10 12 42s94ms 3s507ms 11 12 41s353ms 3s446ms 12 12 30s369ms 2s530ms 13 12 29s995ms 2s499ms 14 12 35s851ms 2s987ms 15 12 4m22s 21s910ms 16 12 41s918ms 3s493ms 17 12 31s163ms 2s596ms 18 12 28s471ms 2s372ms 19 12 29s477ms 2s456ms 20 12 53s57ms 4s421ms 21 12 33s485ms 2s790ms 22 12 34s40ms 2s836ms [ User: intelifix - Total duration: 27m31s - Times executed: 275 ]
[ Application: psql - Total duration: 27m31s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-17 08:49:05 Duration: 3m56s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-17 08:28:27 Duration: 3m14s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-17 07:28:27 Duration: 3m13s Database: rio User: intelifix Remote: [local] Application: psql
6 24m56s 3 3m14s 13m18s 8m18s analyze verbose;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 17 05 3 24m56s 8m18s [ User: intelifix - Total duration: 24m56s - Times executed: 3 ]
[ Application: psql - Total duration: 24m56s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-17 05:13:20 Duration: 13m18s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-17 05:21:43 Duration: 8m23s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-17 05:24:58 Duration: 3m14s Database: contagem User: intelifix Remote: [local] Application: psql
7 13m36s 1,078 150ms 12s930ms 757ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 17 07 13 18s172ms 1s397ms 08 89 1m5s 737ms 09 144 1m50s 765ms 10 167 2m49s 1s16ms 11 124 1m29s 723ms 12 16 11s327ms 707ms 13 89 58s304ms 655ms 14 107 1m27s 814ms 15 119 1m11s 601ms 16 140 1m34s 678ms 17 70 39s458ms 563ms [ User: intelifix - Total duration: 13m36s - Times executed: 1078 ]
[ Application: [unknown] - Total duration: 13m36s - Times executed: 1078 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "241543", "modelo" : "320", "itens" : "241714722235,241708278800,241714660512,241629316570,241635886785,241646146978,241649837787,241593972942,241608134245,241631101717,241708457178,241604287180,241694661321,230048572630,241694684656,241679489200,241714231020,241619872327,241617580712,241645820808,241649142939,241714397073,241656995265,241664718992,241658772229,241716699598,241675590212,241658187996,241653961928,241716688688,241694765068,241708420206,241634917285,241708367293,241682633233,241604309102,241592235353,241617648798,241631404754,241668741833,241651158791,241712259514,241666112429,241653948996", "usuario" : "414", "caixa" : "2880116", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-17 10:47:14 Duration: 12s930ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104485", "modelo" : "39", "itens" : "8C444F084513,E820E2150F3D,8C444F5AED30,E820E26F6C39,8C444F02DE31,8C444F04D5F2,E820E2B86A24", "usuario" : "414", "caixa" : "1221337", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-17 09:57:38 Duration: 10s741ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "278351", "modelo" : "320", "itens" : "241731164445,241693012327,241619727991,241628910920,241727003658,241620854656,241636034252,241731239503,241711203945,241650790923,241711257990,241637642030,241693148502,241592208000,241689327275,230057031032,241639017180,241670078898,241711572949,241731768904,241675874055,241636093147,241617329193,241654513856,241635015353,241631612530,241728729909,241618222828,241661051924,241674234254,241732806064,230055083647,241667229798,241691301734,241631749715,241608924255,241606214967,241617367177,241653376988,241696686265,241669119399,241673184163,241615895070,241698477293,241734177881,241712731031,241674454455,241708602850", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-17 10:29:05 Duration: 3s908ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 12m 49 10s322ms 1m20s 14s711ms create table temp0000288562 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 17 07 10 3m1s 18s128ms 08 9 1m53s 12s655ms 09 9 1m49s 12s121ms 10 18 4m41s 15s612ms 11 3 35s580ms 11s860ms [ User: intelifix - Total duration: 12m - Times executed: 49 ]
[ Application: [unknown] - Total duration: 12m - Times executed: 49 ]
-
CREATE TABLE temp0000288562 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 07:17:23 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288562 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 10:28:38 Duration: 1m11s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288562 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 10:29:03 Duration: 15s280ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 11m29s 77 759ms 1m5s 8s948ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 17 07 4 17s392ms 4s348ms 08 7 1m17s 11s33ms 09 9 28s524ms 3s169ms 10 10 1m42s 10s275ms 11 12 2m1s 10s83ms 12 4 10s624ms 2s656ms 13 6 1m14s 12s407ms 14 7 58s958ms 8s422ms 15 4 21s240ms 5s310ms 16 7 1m36s 13s824ms 17 7 1m20s 11s443ms [ User: intelifix - Total duration: 11m29s - Times executed: 77 ]
[ Application: [unknown] - Total duration: 11m29s - Times executed: 77 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-17', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-17 08:47:24 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-17', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-17 13:12:14 Duration: 49s359ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-17', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-17 11:27:15 Duration: 40s418ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 11m25s 136 185ms 17s424ms 5s42ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 17 00 1 629ms 629ms 07 11 1m5s 5s940ms 08 12 1m19s 6s597ms 09 12 1m9s 5s778ms 10 12 49s532ms 4s127ms 11 12 1m5s 5s492ms 12 13 57s721ms 4s440ms 13 7 10s704ms 1s529ms 14 11 56s449ms 5s131ms 15 12 1m33s 7s797ms 16 12 1m13s 6s105ms 17 10 19s197ms 1s919ms 21 5 22s707ms 4s541ms 22 6 22s163ms 3s693ms [ User: intelifix - Total duration: 11m25s - Times executed: 136 ]
[ Application: psql - Total duration: 11m25s - Times executed: 136 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-17 07:45:18 Duration: 17s424ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-17 16:25:18 Duration: 17s104ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-17 15:55:17 Duration: 16s500ms Database: rio User: intelifix Remote: [local] Application: psql
11 7m43s 2 3m13s 4m30s 3m51s select * from rs_resumo_defeitos (?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 17 16 2 7m43s 3m51s [ User: intelifix - Total duration: 7m43s - Times executed: 2 ]
[ Application: [unknown] - Total duration: 7m43s - Times executed: 2 ]
-
SELECT * FROM RS_RESUMO_DEFEITOS (01, 00);
Date: 2026-08-17 16:02:23 Duration: 4m30s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_DEFEITOS (01, 00);
Date: 2026-08-17 16:17:19 Duration: 3m13s Database: rio User: intelifix Remote: [local] Application: [unknown]
12 7m9s 35 10s313ms 14s581ms 12s269ms create table temp0000288670 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 17 14 15 3m5s 12s382ms 15 17 3m28s 12s262ms 16 3 35s223ms 11s741ms [ User: intelifix - Total duration: 7m9s - Times executed: 35 ]
[ Application: [unknown] - Total duration: 7m9s - Times executed: 35 ]
-
CREATE TABLE temp0000288670 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 15:32:31 Duration: 14s581ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288670 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 15:32:53 Duration: 14s437ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288670 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 14:24:04 Duration: 13s917ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 7m5s 39 774ms 47s850ms 10s903ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 17 07 2 50s298ms 25s149ms 08 4 31s96ms 7s774ms 09 3 19s502ms 6s500ms 10 6 1m20s 13s342ms 11 2 27s793ms 13s896ms 12 1 32s416ms 32s416ms 13 1 41s899ms 41s899ms 14 5 44s871ms 8s974ms 15 7 19s811ms 2s830ms 16 7 1m16s 10s955ms 17 1 790ms 790ms [ User: intelifix - Total duration: 7m5s - Times executed: 39 ]
[ Application: psql - Total duration: 7m5s - Times executed: 39 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028544);
Date: 2026-08-17 07:19:48 Duration: 47s850ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028574);
Date: 2026-08-17 13:53:40 Duration: 41s899ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028595);
Date: 2026-08-17 16:27:50 Duration: 39s632ms Database: rio User: intelifix Remote: [local] Application: psql
14 6m14s 4 172ms 6m13s 1m33s select * from rs_fast_excel (?, ?) notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 17 09 1 570ms 570ms 10 1 172ms 172ms 15 1 6m13s 6m13s 17 1 292ms 292ms [ User: intelifix - Total duration: 6m14s - Times executed: 4 ]
[ Application: [unknown] - Total duration: 6m14s - Times executed: 4 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028588, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx') NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-08-17 15:19:23 Duration: 6m13s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/EXCLUSÃO 83.xlsx'') ;', '/var/www/html/tmp/temp_83.xlsx') NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-08-17 09:20:06 Duration: 570ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/83 EXCLUSÃO (12).xlsx'') ;', '/var/www/html/tmp/temp_83.xlsx') NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-08-17 17:23:07 Duration: 292ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
15 5m21s 27 10s424ms 14s43ms 11s899ms create table temp0000288686 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 17 16 27 5m21s 11s899ms [ User: intelifix - Total duration: 5m21s - Times executed: 27 ]
[ Application: [unknown] - Total duration: 5m21s - Times executed: 27 ]
-
CREATE TABLE temp0000288686 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 16:46:07 Duration: 14s43ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288686 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 16:46:37 Duration: 13s579ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288686 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 16:32:28 Duration: 13s409ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 4m55s 21 10s823ms 45s887ms 14s85ms create table temp0000288572 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 17 08 3 37s336ms 12s445ms 11 7 2m3s 17s606ms 12 4 46s610ms 11s652ms 15 7 1m28s 12s656ms [ User: intelifix - Total duration: 4m55s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 4m55s - Times executed: 21 ]
-
CREATE TABLE temp0000288572 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 11:56:48 Duration: 45s887ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288572 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 11:12:02 Duration: 14s550ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288572 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 15:12:14 Duration: 14s207ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 4m27s 22 10s340ms 13s858ms 12s137ms create table temp0000288622 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 17 09 7 1m29s 12s761ms 10 2 26s945ms 13s472ms 11 1 12s571ms 12s571ms 12 3 36s493ms 12s164ms 17 9 1m41s 11s297ms [ User: intelifix - Total duration: 4m27s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 4m27s - Times executed: 22 ]
-
CREATE TABLE temp0000288622 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 10:31:47 Duration: 13s858ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288622 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 09:06:37 Duration: 13s792ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288622 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 09:44:45 Duration: 13s519ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 4m6s 40 2s860ms 49s387ms 6s171ms create table temp0000288562 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 17 07 2 52s348ms 26s174ms 08 17 56s358ms 3s315ms 09 2 31s670ms 15s835ms 10 17 1m38s 5s771ms 11 2 8s358ms 4s179ms [ User: intelifix - Total duration: 4m6s - Times executed: 40 ]
[ Application: [unknown] - Total duration: 4m6s - Times executed: 40 ]
-
CREATE TABLE temp0000288562 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-08-2026", "ate" :"17-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-17 07:58:44 Duration: 49s387ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288562 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-08-2026", "ate" :"17-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-17 10:22:14 Duration: 39s883ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288562 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-08-2026", "ate" :"17-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-17 09:27:10 Duration: 28s810ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 3m50s 17 10s226ms 45s192ms 13s561ms create table temp0000288660 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 17 13 5 55s758ms 11s151ms 14 10 1m58s 11s878ms 16 2 56s8ms 28s4ms [ User: intelifix - Total duration: 3m50s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 3m50s - Times executed: 17 ]
-
CREATE TABLE temp0000288660 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 16:21:30 Duration: 45s192ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288660 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 14:10:51 Duration: 14s119ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288660 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 14:10:26 Duration: 13s54ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 3m25s 55 2s903ms 8s574ms 3s737ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 17 08 3 11s12ms 3s670ms 09 3 9s926ms 3s308ms 10 4 14s609ms 3s652ms 11 4 14s556ms 3s639ms 12 3 10s115ms 3s371ms 13 3 10s306ms 3s435ms 14 5 25s374ms 5s74ms 15 4 15s674ms 3s918ms 16 4 14s757ms 3s689ms 17 3 10s140ms 3s380ms 18 4 14s427ms 3s606ms 19 4 14s219ms 3s554ms 20 3 10s561ms 3s520ms 21 3 12s987ms 4s329ms 22 5 16s873ms 3s374ms [ User: intelifix - Total duration: 3m25s - Times executed: 55 ]
[ Application: psql - Total duration: 3m25s - Times executed: 55 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-17 14:40:10 Duration: 8s574ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-17 21:00:10 Duration: 6s181ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-17 14:40:15 Duration: 5s5ms Database: brasilia User: intelifix Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,140 27m53s 150ms 7s720ms 1s468ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 17 08 83 1m32s 1s111ms 09 170 3m38s 1s285ms 10 154 3m26s 1s338ms 11 141 3m43s 1s584ms 12 31 47s930ms 1s546ms 13 90 2m1s 1s345ms 14 172 4m28s 1s560ms 15 150 3m44s 1s498ms 16 97 3m4s 1s906ms 17 47 1m18s 1s676ms 18 5 7s182ms 1s436ms [ User: intelifix - Total duration: 27m53s - Times executed: 1140 ]
[ Application: [unknown] - Total duration: 27m53s - Times executed: 1140 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52953, 406, '836030905001924,241728551632,241704648603,241664773443,241622436572,241732087980,241728526376,241654532545,241599288196,241728671621,241598837591,241708521024,241731238694,241664814457,241617447286,230043318693,241667756876,241713695658,241620852737,241676631739,241727046467,241676663436,241700930317,241704382135,241704165974,241708987185,241704739497,241689459107,241695524547,241636028190,241676735362,241706685165,241610117390,241594349094,241645810830,241728680006,241607244349,241622562040,241732109902,241666955878,241607233641,241728679499,241680297797,241692655973,241727053741,241727260406,241608708802,241695617586,241631264864,241620712342,241661218405', '',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-17 14:28:00 Duration: 7s720ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52916, 406, '270911029132107551,229726410415,229755875265,229669753235,216941986161,229736813450,229755008907,229735571219,229741654259,229817050417,229859086673,229805221619,229735559803,229813385569,229687352136,229745333350,229880019299,229664247175,229728467180,216945127388,229686226481,216944103035,229749599400,216937556582,229925397084,229809398692,229689784045,229786736683,229864928197,229879519700,229780839193,229689029314,229736846483,229669254971,229755448298,229807180621,229782747988,229805744756,229805245055,229809535272,229669490707,229728562847,229813800414,229805245762,229663868698,216945082334,229748817595,229752744062,229859193755,229745689298,229742000410', '246506731120,246559542828,246548880924,246471264650,246528454564,246587399901,246542826471,246530885160,246632310514,246641329205,246598450610,246509277888,246630120828,246517568495,246535987992,246652852440,246467952947,246543938083,246489124665,246515627374,246498352547,246562562831,246442025758,246042535659,246629425574,246516512041,246598590018,246648107778,246652546270,246585998888,246521431926,246532728291,246516094850,246588241129,246581535266,246597883753,246581746375,246598447376,246629424867,246514842136,246545001331,246628980930,246593072139,246471633351,246488087380,246551319702,246566537786,246642197179,246542845463,246549614968', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-17 11:28:08 Duration: 7s465ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (133219, 401, 'ZTE3ANNT3H15111,D831399825C2,D831399825C3,ZTEGDD320BA6$ZTE3ANNQ7101666,C4EBFF89EF74,C4EBFF89EF75,ZTEGD70A2354$ZTE3ANNQ7901538,C4EBFF8C421C,C4EBFF8C421D,ZTEGD70A8670$ZTE3ANNR9F15124,D89A0DA4405B,D89A0DA4405C,ZTEGDB15625F$ZTE3ANNT3F15887,D8313996A022,D8313996A023,ZTEGDD31CAB6$ZTE3ANNRCP73926,6C11BA6FEF73,6C11BA6FEF74,ZTEGDC706159$ZTE3ANNT2V51383,D83139904322,D83139904323,ZTEGDD30BB36$ZTE3ANNR4N13476,4896D95696F0,4896D95696F1,ZTEGD97F5469$ZTE3ANNRAD25655,D89A0DB033AD,D89A0DB033AE,ZTEGDB176042$ZTE3ANNQ5N05248,3CF9F0AD4076,3CF9F0AD4077,ZTEGD641CAC7$ZTE3ANNR3Y51927,4896D95481C2,4896D95481C3,ZTEGD97EFB8C$ZTE3ANNR9336670,D89A0D85BB7F,D89A0D85BB80,ZTEGDB15033D$ZTE3ANNR1Y17439,14CA56CE4335,14CA56CE4336,ZTEGD970BA7A$ZTE3ANNQ4A10727,3CF9F0AAF3B0,3CF9F0AAF3B1,ZTEGD64168A6$ZTE3ANNR6R32458,48D682387D7E,48D682387D7F,ZTEGDB01A99D$ZTE3ANNQ7112235,C4EBFF8AE72A,C4EBFF8AE72B,ZTEGD70A4C9D$ZTE3ANNR5W57569,48D68233C910,48D68233C911,ZTEGDB00E0E0$ZTE3ANNQ9J38182,843C992F5019,843C992F501A,ZTEGD7BB9DD1$ZTE3ANNRAM39021,5872C98ACAC7,5872C98ACAC8,ZTEGDC60986C$ZTE3ANNR9300427,D89A0D826A0D,D89A0D826A0E,ZTEGDB1475AA$ZTE3ANNR2Q13725,F4E84F81F5AE,F4E84F81F5AF,ZTEGD97AA857$ZTE3ANNQ9J43607,843C992FCF3F,843C992FCF40,ZTEGD7BBB302$ZTE3ANNT2V80356,D8313992EA30,D8313992EA31,ZTEGDD312C63$ZTE3ANNQ9J43742,843C992FD269,843C992FD26A,ZTEGD7BBB389$ZTE3ANNR3Y05576,4896D9504368,4896D9504369,ZTEGD97E467D$ZTE3ANNRAM61820,5872C98CE121,5872C98CE122,ZTEGDC60F17B', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-17 09:51:22 Duration: 6s727ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
2 1,078 13m36s 150ms 12s930ms 757ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 17 07 13 18s172ms 1s397ms 08 89 1m5s 737ms 09 144 1m50s 765ms 10 167 2m49s 1s16ms 11 124 1m29s 723ms 12 16 11s327ms 707ms 13 89 58s304ms 655ms 14 107 1m27s 814ms 15 119 1m11s 601ms 16 140 1m34s 678ms 17 70 39s458ms 563ms [ User: intelifix - Total duration: 13m36s - Times executed: 1078 ]
[ Application: [unknown] - Total duration: 13m36s - Times executed: 1078 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "241543", "modelo" : "320", "itens" : "241714722235,241708278800,241714660512,241629316570,241635886785,241646146978,241649837787,241593972942,241608134245,241631101717,241708457178,241604287180,241694661321,230048572630,241694684656,241679489200,241714231020,241619872327,241617580712,241645820808,241649142939,241714397073,241656995265,241664718992,241658772229,241716699598,241675590212,241658187996,241653961928,241716688688,241694765068,241708420206,241634917285,241708367293,241682633233,241604309102,241592235353,241617648798,241631404754,241668741833,241651158791,241712259514,241666112429,241653948996", "usuario" : "414", "caixa" : "2880116", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-17 10:47:14 Duration: 12s930ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104485", "modelo" : "39", "itens" : "8C444F084513,E820E2150F3D,8C444F5AED30,E820E26F6C39,8C444F02DE31,8C444F04D5F2,E820E2B86A24", "usuario" : "414", "caixa" : "1221337", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-17 09:57:38 Duration: 10s741ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "278351", "modelo" : "320", "itens" : "241731164445,241693012327,241619727991,241628910920,241727003658,241620854656,241636034252,241731239503,241711203945,241650790923,241711257990,241637642030,241693148502,241592208000,241689327275,230057031032,241639017180,241670078898,241711572949,241731768904,241675874055,241636093147,241617329193,241654513856,241635015353,241631612530,241728729909,241618222828,241661051924,241674234254,241732806064,230055083647,241667229798,241691301734,241631749715,241608924255,241606214967,241617367177,241653376988,241696686265,241669119399,241673184163,241615895070,241698477293,241734177881,241712731031,241674454455,241708602850", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-17 10:29:05 Duration: 3s908ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 324 2h34m43s 153ms 8m52s 28s652ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 17 07 5 14m13s 2m50s 08 18 15m29s 51s625ms 09 63 22m25s 21s353ms 10 33 21m34s 39s235ms 11 27 15m54s 35s364ms 12 10 8m11s 49s165ms 13 27 16s608ms 615ms 14 53 9m55s 11s231ms 15 29 29m45s 1m1s 16 33 9m8s 16s617ms 17 24 7m48s 19s520ms 18 2 452ms 226ms [ User: intelifix - Total duration: 2h34m43s - Times executed: 324 ]
[ Application: [unknown] - Total duration: 2h34m43s - Times executed: 324 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028582, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-17 14:33:00 Duration: 8m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028544, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-17 07:28:26 Duration: 8m47s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028560, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-17 10:20:04 Duration: 7m48s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 275 27m31s 172ms 3m56s 6s6ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 17 00 12 53s859ms 4s488ms 01 12 31s290ms 2s607ms 02 12 30s44ms 2s503ms 03 11 24s425ms 2s220ms 04 12 31s337ms 2s611ms 05 12 31s169ms 2s597ms 06 12 31s156ms 2s596ms 07 12 3m40s 18s389ms 08 12 7m34s 37s851ms 09 12 49s308ms 4s109ms 10 12 42s94ms 3s507ms 11 12 41s353ms 3s446ms 12 12 30s369ms 2s530ms 13 12 29s995ms 2s499ms 14 12 35s851ms 2s987ms 15 12 4m22s 21s910ms 16 12 41s918ms 3s493ms 17 12 31s163ms 2s596ms 18 12 28s471ms 2s372ms 19 12 29s477ms 2s456ms 20 12 53s57ms 4s421ms 21 12 33s485ms 2s790ms 22 12 34s40ms 2s836ms [ User: intelifix - Total duration: 27m31s - Times executed: 275 ]
[ Application: psql - Total duration: 27m31s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-17 08:49:05 Duration: 3m56s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-17 08:28:27 Duration: 3m14s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-17 07:28:27 Duration: 3m13s Database: rio User: intelifix Remote: [local] Application: psql
5 158 46s650ms 150ms 925ms 295ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 17 07 12 4s119ms 343ms 08 19 6s18ms 316ms 09 34 10s755ms 316ms 10 10 2s334ms 233ms 11 15 4s41ms 269ms 12 13 4s513ms 347ms 13 1 154ms 154ms 14 14 4s13ms 286ms 15 16 4s765ms 297ms 16 24 5s933ms 247ms [ User: intelifix - Total duration: 46s650ms - Times executed: 158 ]
[ Application: [unknown] - Total duration: 46s650ms - Times executed: 158 ]
-
SELECT * FROM RS_TRIAGEM (403, 5, '70', 2, '230055033036,230055065463,241682647375,241645813860,241646555054,241634529919,241637519515,241651075675,241709801216,241618142944,241635408602,241658672646', NULL, NULL, 0320, 00);
Date: 2026-08-17 09:45:14 Duration: 925ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '229643345360,229799451718,229834564561,229823890209,229776764150,229695638095,216931264049,229712914361,229827817381,229826381013,229828423636,229830755760,229831574460,229881050524,229792975272', NULL, NULL, 0137, 00);
Date: 2026-08-17 07:25:07 Duration: 762ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (430, 5, '138', 6, '840112DCAA87,8401128045DC,743AEF9A8B18,743AEF738841,9877E700701B,9877E7BBAD09,9877E7BC9E58,9877E7075EE0,9877E749B0C6,9877E70C855D,743AEFAC54D0,9877E7BDC6D5,84011298163A,84011282553D,9877E74E9F66,9877E70B6537', NULL, NULL, 0153, 00);
Date: 2026-08-17 09:17:17 Duration: 747ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 138 59s845ms 203ms 1s579ms 433ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 17 07 3 1s131ms 377ms 08 13 6s21ms 463ms 09 22 9s258ms 420ms 10 14 6s876ms 491ms 11 12 4s983ms 415ms 12 7 2s741ms 391ms 13 3 1s130ms 376ms 14 19 8s101ms 426ms 15 17 6s960ms 409ms 16 8 4s81ms 510ms 17 17 7s447ms 438ms 18 3 1s112ms 370ms [ User: intelifix - Total duration: 59s845ms - Times executed: 138 ]
[ Application: [unknown] - Total duration: 59s845ms - Times executed: 138 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 085;
Date: 2026-08-17 17:02:58 Duration: 1s579ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-17 16:29:03 Duration: 1s161ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-17 10:21:08 Duration: 856ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
7 136 11m25s 185ms 17s424ms 5s42ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 17 00 1 629ms 629ms 07 11 1m5s 5s940ms 08 12 1m19s 6s597ms 09 12 1m9s 5s778ms 10 12 49s532ms 4s127ms 11 12 1m5s 5s492ms 12 13 57s721ms 4s440ms 13 7 10s704ms 1s529ms 14 11 56s449ms 5s131ms 15 12 1m33s 7s797ms 16 12 1m13s 6s105ms 17 10 19s197ms 1s919ms 21 5 22s707ms 4s541ms 22 6 22s163ms 3s693ms [ User: intelifix - Total duration: 11m25s - Times executed: 136 ]
[ Application: psql - Total duration: 11m25s - Times executed: 136 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-17 07:45:18 Duration: 17s424ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-17 16:25:18 Duration: 17s104ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-17 15:55:17 Duration: 16s500ms Database: rio User: intelifix Remote: [local] Application: psql
8 130 1m18s 152ms 1s765ms 604ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 17 08 2 967ms 483ms 09 12 4s999ms 416ms 10 26 16s846ms 647ms 11 21 12s815ms 610ms 12 4 2s99ms 524ms 13 5 1s15ms 203ms 14 8 6s876ms 859ms 15 28 20s985ms 749ms 16 24 11s918ms 496ms [ User: intelifix - Total duration: 1m18s - Times executed: 130 ]
[ Application: [unknown] - Total duration: 1m18s - Times executed: 130 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '241659660913,241647558294,241649692847,241620909005,241594978405,241730517580,241694386265,241692384757,241635802535,241608005669,241599276882,241635990410,241599559211,241604625373,241700807677,241601575872,241599563252,241635168499,241669999496,241690567991,241674328607,230043551422,241692653448,241667000204,241656687681,241617807983,241729054262,241694237081,241682722232,241704728587,241607802844,241727428503,241619538197,241652407690,241606158193,241602988805,241607038290,241707365669,241674043349,241616894752,241594185364,241727323442,241675387486,230048373239,241635794958,241676421213,241595394259,241599232838,241666412133,241630910307,241701248507,241608657584,241675283537,241645973045,241614672235,241677202131,241663225772', '','DEFAULT',056,0320,'', '','', 00);
Date: 2026-08-17 10:20:29 Duration: 1s765ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '4896D9577DDE,843C992F73E9,14CA56D01927,D831398EADE6,3CF9F0A700F8,14CA56D5173F,843C991F8623,D83139217BF6,4896D9577DCC,D89A0DACF057,D831399408B6,3CF9F0ABEB6C,3891484AC87B,843C99226F97,3CF9F0A7003E,F4E84F866B22,4896D95020BE,48D682387AC0,3CF9F0AA97C4', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-08-17 15:30:28 Duration: 1s653ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'ZTE3A98Q9515052,ZTE3A98Q4F03191,ZTE3A98Q7H07440,ZTE3A98Q4F04229,802D1A4F7446,ZTE3A98Q6410286,ZTE3A98Q4P14491,ZTE3A98Q6403010,ZTE3A98Q6M04442,301F4855DB48,ZTE3A98Q9505107,ZTE3A98Q7H02857,ZTE3A98Q7H04234,ZTE3A98Q7H05146,ZTE3A98QA901764,ZTE3A98QBE08377,ZTE3A98QBE05188,ZTE3A98Q7H05241,ZTE3A98Q4P04805,ZTE3A98Q9510957', '138;1', 'DEFAULT', 09, 0325, '','', '', 00);
Date: 2026-08-17 15:01:35 Duration: 1s648ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
9 117 52s758ms 263ms 797ms 450ms 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 17 07 8 3s242ms 405ms 08 14 6s397ms 456ms 09 12 5s366ms 447ms 10 13 6s18ms 462ms 11 8 3s948ms 493ms 12 6 2s627ms 437ms 13 11 4s851ms 441ms 14 10 4s825ms 482ms 15 11 4s922ms 447ms 16 12 5s241ms 436ms 17 7 3s46ms 435ms 18 1 376ms 376ms 20 1 534ms 534ms 21 2 957ms 478ms 23 1 403ms 403ms [ User: lenon - Total duration: 52s758ms - Times executed: 117 ]
[ Application: [unknown] - Total duration: 52s758ms - Times executed: 117 ]
-
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-17 11:04:38 Duration: 797ms 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-17 14:31:46 Duration: 733ms 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-17 11:11:01 Duration: 714ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
10 104 59s908ms 187ms 988ms 576ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 17 07 4 2s15ms 503ms 08 11 5s831ms 530ms 09 12 7s201ms 600ms 10 13 6s959ms 535ms 11 8 4s830ms 603ms 12 6 3s602ms 600ms 13 10 5s505ms 550ms 14 9 5s705ms 633ms 15 10 5s901ms 590ms 16 12 6s954ms 579ms 17 7 4s380ms 625ms 18 1 481ms 481ms 23 1 539ms 539ms [ User: intelifix - Total duration: 59s908ms - Times executed: 104 ]
[ Application: [unknown] - Total duration: 59s908ms - Times executed: 104 ]
-
select * from rs_menu_grants (413, 18, 1);
Date: 2026-08-17 11:04:38 Duration: 988ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (406, 18, 1);
Date: 2026-08-17 14:31:46 Duration: 988ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (413, 18, 1);
Date: 2026-08-17 16:18:13 Duration: 983ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
11 97 29s903ms 154ms 973ms 308ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 17 07 1 694ms 694ms 08 8 2s331ms 291ms 09 1 371ms 371ms 10 9 3s222ms 358ms 11 2 1s51ms 525ms 12 1 685ms 685ms 13 3 1s180ms 393ms 14 22 6s603ms 300ms 15 25 6s509ms 260ms 16 20 6s242ms 312ms 17 5 1s10ms 202ms [ User: intelifix - Total duration: 29s903ms - Times executed: 97 ]
[ Application: [unknown] - Total duration: 29s903ms - Times executed: 97 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"141", "usuario" :"413", "tipo" :"N", "itens" :"021", "nota-fiscal" :"11286", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-17 16:18:35 Duration: 973ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"34", "usuario" :"413", "tipo" :"N", "itens" :"014", "nota-fiscal" :"11286", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-17 14:12:31 Duration: 746ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"318", "usuario" :"507", "tipo" :"N", "itens" :"009", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-17 07:58:55 Duration: 694ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 96 26s589ms 150ms 5s713ms 276ms create table temp0000238264 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 17 07 2 5s963ms 2s981ms 08 6 1s269ms 211ms 09 12 2s352ms 196ms 10 10 1s663ms 166ms 11 20 3s496ms 174ms 12 7 1s467ms 209ms 13 6 1s260ms 210ms 14 5 1s59ms 211ms 15 5 1s174ms 234ms 16 23 6s882ms 299ms [ User: intelifix - Total duration: 26s589ms - Times executed: 96 ]
[ Application: [unknown] - Total duration: 26s589ms - Times executed: 96 ]
-
CREATE TABLE temp0000238264 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "12-08-2026", "data-ate" : "17-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-17 07:05:51 Duration: 5s713ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000238264 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "17-08-2026", "data-ate" : "17-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-17 16:24:01 Duration: 2s228ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000238264 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "17-08-2026", "data-ate" : "17-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-17 15:18:33 Duration: 402ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
13 90 34s568ms 150ms 2s243ms 384ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 17 07 2 2s563ms 1s281ms 08 1 261ms 261ms 09 6 1s432ms 238ms 10 6 1s748ms 291ms 11 9 2s738ms 304ms 12 4 1s448ms 362ms 13 3 466ms 155ms 14 5 2s473ms 494ms 15 19 8s349ms 439ms 16 18 4s631ms 257ms 17 14 6s379ms 455ms 18 1 437ms 437ms 21 2 1s636ms 818ms [ User: intelifix - Total duration: 34s568ms - Times executed: 90 ]
[ Application: [unknown] - Total duration: 34s568ms - Times executed: 90 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "366", "data-de" : "2026-08-14", "data-ate" : "2026-08-14", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 418 }');
Date: 2026-08-17 07:23:55 Duration: 2s243ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "434", "data-de" : "2026-08-17", "data-ate" : "2026-08-17", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 508 }');
Date: 2026-08-17 17:26:31 Duration: 1s385ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "328", "data-de" : "2026-08-17", "data-ate" : "2026-08-17", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 398 }');
Date: 2026-08-17 17:23:44 Duration: 1s186ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
14 82 1m12s 164ms 4s701ms 886ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 17 08 1 386ms 386ms 09 31 15s564ms 502ms 10 2 8s489ms 4s244ms 11 6 2s434ms 405ms 13 11 10s906ms 991ms 14 21 21s109ms 1s5ms 16 8 11s10ms 1s376ms 17 2 2s794ms 1s397ms [ User: intelifix - Total duration: 1m12s - Times executed: 82 ]
[ Application: [unknown] - Total duration: 1m12s - Times executed: 82 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0278445) LIMIT 1;
Date: 2026-08-17 16:17:45 Duration: 4s701ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0132789) LIMIT 1;
Date: 2026-08-17 10:41:42 Duration: 4s691ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0132591) LIMIT 1;
Date: 2026-08-17 10:59:09 Duration: 3s797ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
15 82 20s132ms 150ms 2s878ms 245ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 17 07 2 522ms 261ms 08 6 1s359ms 226ms 09 8 1s750ms 218ms 10 10 1s911ms 191ms 11 21 4s379ms 208ms 12 2 372ms 186ms 13 4 700ms 175ms 14 6 1s105ms 184ms 15 6 1s333ms 222ms 16 8 1s582ms 197ms 17 4 857ms 214ms 20 2 955ms 477ms 21 1 160ms 160ms 22 1 262ms 262ms 23 1 2s878ms 2s878ms [ User: intelifix - Total duration: 20s132ms - Times executed: 82 ]
[ Application: [unknown] - Total duration: 20s132ms - Times executed: 82 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('230014468000');
Date: 2026-08-17 23:33:48 Duration: 2s878ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229999162937');
Date: 2026-08-17 20:58:14 Duration: 737ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229869949608');
Date: 2026-08-17 11:38:36 Duration: 354ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 77 11m29s 759ms 1m5s 8s948ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 17 07 4 17s392ms 4s348ms 08 7 1m17s 11s33ms 09 9 28s524ms 3s169ms 10 10 1m42s 10s275ms 11 12 2m1s 10s83ms 12 4 10s624ms 2s656ms 13 6 1m14s 12s407ms 14 7 58s958ms 8s422ms 15 4 21s240ms 5s310ms 16 7 1m36s 13s824ms 17 7 1m20s 11s443ms [ User: intelifix - Total duration: 11m29s - Times executed: 77 ]
[ Application: [unknown] - Total duration: 11m29s - Times executed: 77 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-17', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-17 08:47:24 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-17', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-17 13:12:14 Duration: 49s359ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-17', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-17 11:27:15 Duration: 40s418ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 73 29s496ms 152ms 1s617ms 404ms select * from rs_lote_saida_manutencao (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 17 07 2 649ms 324ms 08 3 668ms 222ms 09 9 3s535ms 392ms 10 6 1s836ms 306ms 11 11 2s844ms 258ms 12 1 1s617ms 1s617ms 13 6 3s384ms 564ms 14 5 1s568ms 313ms 15 4 1s912ms 478ms 16 22 10s252ms 466ms 17 4 1s225ms 306ms [ User: intelifix - Total duration: 29s496ms - Times executed: 73 ]
[ Application: [unknown] - Total duration: 29s496ms - Times executed: 73 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "133420", "oficina" : "7", "cliente" : "11", "usuario" : "427", "nf" : "", "data-saida" : "2026-08-17", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "Cosmético Pintura", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-17 12:06:18 Duration: 1s617ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "278445", "oficina" : "6", "cliente" : "5", "usuario" : "417", "nf" : "", "data-saida" : "2026-08-17", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "S", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-17 13:27:27 Duration: 1s227ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "133429", "oficina" : "7", "cliente" : "11", "usuario" : "427", "nf" : "", "data-saida" : "2026-08-17", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "Cosmético Pintura", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-17 16:58:21 Duration: 1s223ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
18 70 20s109ms 150ms 1s499ms 287ms select * from rs_etiqueta (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 17 00 1 396ms 396ms 03 1 153ms 153ms 07 14 3s425ms 244ms 08 4 778ms 194ms 09 4 766ms 191ms 10 9 2s593ms 288ms 11 7 2s305ms 329ms 12 6 1s73ms 178ms 13 1 173ms 173ms 14 9 2s292ms 254ms 15 7 1s433ms 204ms 16 3 693ms 231ms 20 1 810ms 810ms 23 3 3s211ms 1s70ms [ User: etiquetas - Total duration: 20s109ms - Times executed: 70 ]
[ Application: [unknown] - Total duration: 20s109ms - Times executed: 70 ]
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-08-17 23:19:02 Duration: 1s499ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-08-17 23:42:12 Duration: 1s475ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
-
SELECT * FROM RS_ETIQUETA ('743AEF5E8978');
Date: 2026-08-17 11:55:15 Duration: 1s128ms Database: brasilia User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
19 68 2m19s 195ms 39s374ms 2s49ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 17 07 4 3s801ms 950ms 08 5 9s231ms 1s846ms 09 7 49s990ms 7s141ms 10 8 12s949ms 1s618ms 11 4 9s146ms 2s286ms 12 3 14s9ms 4s669ms 13 2 797ms 398ms 14 10 4s552ms 455ms 15 8 8s967ms 1s120ms 16 13 3s595ms 276ms 17 4 22s341ms 5s585ms [ User: intelifix - Total duration: 2m19s - Times executed: 68 ]
[ Application: psql - Total duration: 2m19s - Times executed: 68 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028554);
Date: 2026-08-17 09:07:30 Duration: 39s374ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 508); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028608);
Date: 2026-08-17 17:23:22 Duration: 10s791ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 450); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028573);
Date: 2026-08-17 12:17:06 Duration: 10s82ms Database: rio User: intelifix Remote: [local] Application: psql
20 55 3m25s 2s903ms 8s574ms 3s737ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 17 08 3 11s12ms 3s670ms 09 3 9s926ms 3s308ms 10 4 14s609ms 3s652ms 11 4 14s556ms 3s639ms 12 3 10s115ms 3s371ms 13 3 10s306ms 3s435ms 14 5 25s374ms 5s74ms 15 4 15s674ms 3s918ms 16 4 14s757ms 3s689ms 17 3 10s140ms 3s380ms 18 4 14s427ms 3s606ms 19 4 14s219ms 3s554ms 20 3 10s561ms 3s520ms 21 3 12s987ms 4s329ms 22 5 16s873ms 3s374ms [ User: intelifix - Total duration: 3m25s - Times executed: 55 ]
[ Application: psql - Total duration: 3m25s - Times executed: 55 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-17 14:40:10 Duration: 8s574ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-17 21:00:10 Duration: 6s181ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-17 14:40:15 Duration: 5s5ms Database: brasilia User: intelifix Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m14s 13m18s 8m18s 3 24m56s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 17 05 3 24m56s 8m18s [ User: intelifix - Total duration: 24m56s - Times executed: 3 ]
[ Application: psql - Total duration: 24m56s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-17 05:13:20 Duration: 13m18s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-17 05:21:43 Duration: 8m23s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-17 05:24:58 Duration: 3m14s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s674ms 16m9s 3m57s 48 3h10m9s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 17 07 3 17m38s 5m52s 08 3 9m13s 3m4s 09 3 15m48s 5m16s 10 3 14m30s 4m50s 11 3 13m40s 4m33s 12 3 14m1s 4m40s 13 3 7m28s 2m29s 14 3 13m22s 4m27s 15 3 13m44s 4m34s 16 3 12m56s 4m18s 17 3 13m19s 4m26s 18 3 12m9s 4m3s 19 3 5m56s 1m58s 20 3 12m35s 4m11s 21 3 7m14s 2m24s 22 3 6m29s 2m9s [ User: intelifix - Total duration: 3h10m9s - Times executed: 48 ]
[ Application: psql - Total duration: 3h10m9s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-17 07:21:11 Duration: 16m9s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-17 09:19:24 Duration: 14m22s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-17 10:18:15 Duration: 13m13s Database: rio User: intelifix Remote: [local] Application: psql
3 3m13s 4m30s 3m51s 2 7m43s select * from rs_resumo_defeitos (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 17 16 2 7m43s 3m51s [ User: intelifix - Total duration: 7m43s - Times executed: 2 ]
[ Application: [unknown] - Total duration: 7m43s - Times executed: 2 ]
-
SELECT * FROM RS_RESUMO_DEFEITOS (01, 00);
Date: 2026-08-17 16:02:23 Duration: 4m30s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_DEFEITOS (01, 00);
Date: 2026-08-17 16:17:19 Duration: 3m13s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 269ms 5m40s 2m1s 47 1h35m33s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 17 07 3 7m56s 2m38s 08 3 4m52s 1m37s 09 3 7m43s 2m34s 10 2 5m44s 2m52s 11 3 7m18s 2m26s 12 3 6m49s 2m16s 13 3 4m11s 1m23s 14 3 6m51s 2m17s 15 3 7m5s 2m21s 16 3 6m49s 2m16s 17 3 6m53s 2m17s 18 3 5m10s 1m43s 19 3 3m40s 1m13s 20 3 6m28s 2m9s 21 3 3m48s 1m16s 22 3 4m8s 1m22s [ User: intelifix - Total duration: 1h35m33s - Times executed: 47 ]
[ Application: psql - Total duration: 1h35m33s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-17 10:26:42 Duration: 5m40s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-17 09:28:12 Duration: 5m38s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-17 11:25:45 Duration: 5m35s Database: brasilia User: intelifix Remote: [local] Application: psql
5 172ms 6m13s 1m33s 4 6m14s select * from rs_fast_excel (?, ?) notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 17 09 1 570ms 570ms 10 1 172ms 172ms 15 1 6m13s 6m13s 17 1 292ms 292ms [ User: intelifix - Total duration: 6m14s - Times executed: 4 ]
[ Application: [unknown] - Total duration: 6m14s - Times executed: 4 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028588, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx') NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-08-17 15:19:23 Duration: 6m13s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/EXCLUSÃO 83.xlsx'') ;', '/var/www/html/tmp/temp_83.xlsx') NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-08-17 09:20:06 Duration: 570ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/83 EXCLUSÃO (12).xlsx'') ;', '/var/www/html/tmp/temp_83.xlsx') NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-08-17 17:23:07 Duration: 292ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
6 153ms 8m52s 28s652ms 324 2h34m43s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 17 07 5 14m13s 2m50s 08 18 15m29s 51s625ms 09 63 22m25s 21s353ms 10 33 21m34s 39s235ms 11 27 15m54s 35s364ms 12 10 8m11s 49s165ms 13 27 16s608ms 615ms 14 53 9m55s 11s231ms 15 29 29m45s 1m1s 16 33 9m8s 16s617ms 17 24 7m48s 19s520ms 18 2 452ms 226ms [ User: intelifix - Total duration: 2h34m43s - Times executed: 324 ]
[ Application: [unknown] - Total duration: 2h34m43s - Times executed: 324 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028582, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-17 14:33:00 Duration: 8m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028544, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-17 07:28:26 Duration: 8m47s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028560, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-17 10:20:04 Duration: 7m48s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 10s322ms 1m20s 14s711ms 49 12m create table temp0000288562 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 17 07 10 3m1s 18s128ms 08 9 1m53s 12s655ms 09 9 1m49s 12s121ms 10 18 4m41s 15s612ms 11 3 35s580ms 11s860ms [ User: intelifix - Total duration: 12m - Times executed: 49 ]
[ Application: [unknown] - Total duration: 12m - Times executed: 49 ]
-
CREATE TABLE temp0000288562 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 07:17:23 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288562 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 10:28:38 Duration: 1m11s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288562 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 10:29:03 Duration: 15s280ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10s823ms 45s887ms 14s85ms 21 4m55s create table temp0000288572 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 17 08 3 37s336ms 12s445ms 11 7 2m3s 17s606ms 12 4 46s610ms 11s652ms 15 7 1m28s 12s656ms [ User: intelifix - Total duration: 4m55s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 4m55s - Times executed: 21 ]
-
CREATE TABLE temp0000288572 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 11:56:48 Duration: 45s887ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288572 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 11:12:02 Duration: 14s550ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288572 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 15:12:14 Duration: 14s207ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s226ms 45s192ms 13s561ms 17 3m50s create table temp0000288660 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 17 13 5 55s758ms 11s151ms 14 10 1m58s 11s878ms 16 2 56s8ms 28s4ms [ User: intelifix - Total duration: 3m50s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 3m50s - Times executed: 17 ]
-
CREATE TABLE temp0000288660 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 16:21:30 Duration: 45s192ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288660 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 14:10:51 Duration: 14s119ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288660 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 14:10:26 Duration: 13s54ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s313ms 14s581ms 12s269ms 35 7m9s create table temp0000288670 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 17 14 15 3m5s 12s382ms 15 17 3m28s 12s262ms 16 3 35s223ms 11s741ms [ User: intelifix - Total duration: 7m9s - Times executed: 35 ]
[ Application: [unknown] - Total duration: 7m9s - Times executed: 35 ]
-
CREATE TABLE temp0000288670 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 15:32:31 Duration: 14s581ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288670 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 15:32:53 Duration: 14s437ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288670 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 14:24:04 Duration: 13s917ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s340ms 13s858ms 12s137ms 22 4m27s create table temp0000288622 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 17 09 7 1m29s 12s761ms 10 2 26s945ms 13s472ms 11 1 12s571ms 12s571ms 12 3 36s493ms 12s164ms 17 9 1m41s 11s297ms [ User: intelifix - Total duration: 4m27s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 4m27s - Times executed: 22 ]
-
CREATE TABLE temp0000288622 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 10:31:47 Duration: 13s858ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288622 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 09:06:37 Duration: 13s792ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288622 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 09:44:45 Duration: 13s519ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 10s424ms 14s43ms 11s899ms 27 5m21s create table temp0000288686 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 17 16 27 5m21s 11s899ms [ User: intelifix - Total duration: 5m21s - Times executed: 27 ]
[ Application: [unknown] - Total duration: 5m21s - Times executed: 27 ]
-
CREATE TABLE temp0000288686 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 16:46:07 Duration: 14s43ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288686 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 16:46:37 Duration: 13s579ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288686 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-17 16:32:28 Duration: 13s409ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 774ms 47s850ms 10s903ms 39 7m5s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 17 07 2 50s298ms 25s149ms 08 4 31s96ms 7s774ms 09 3 19s502ms 6s500ms 10 6 1m20s 13s342ms 11 2 27s793ms 13s896ms 12 1 32s416ms 32s416ms 13 1 41s899ms 41s899ms 14 5 44s871ms 8s974ms 15 7 19s811ms 2s830ms 16 7 1m16s 10s955ms 17 1 790ms 790ms [ User: intelifix - Total duration: 7m5s - Times executed: 39 ]
[ Application: psql - Total duration: 7m5s - Times executed: 39 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028544);
Date: 2026-08-17 07:19:48 Duration: 47s850ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028574);
Date: 2026-08-17 13:53:40 Duration: 41s899ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028595);
Date: 2026-08-17 16:27:50 Duration: 39s632ms Database: rio User: intelifix Remote: [local] Application: psql
14 759ms 1m5s 8s948ms 77 11m29s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 17 07 4 17s392ms 4s348ms 08 7 1m17s 11s33ms 09 9 28s524ms 3s169ms 10 10 1m42s 10s275ms 11 12 2m1s 10s83ms 12 4 10s624ms 2s656ms 13 6 1m14s 12s407ms 14 7 58s958ms 8s422ms 15 4 21s240ms 5s310ms 16 7 1m36s 13s824ms 17 7 1m20s 11s443ms [ User: intelifix - Total duration: 11m29s - Times executed: 77 ]
[ Application: [unknown] - Total duration: 11m29s - Times executed: 77 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-17', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-17 08:47:24 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-17', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-17 13:12:14 Duration: 49s359ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-17', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-17 11:27:15 Duration: 40s418ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 2s860ms 49s387ms 6s171ms 40 4m6s create table temp0000288562 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 17 07 2 52s348ms 26s174ms 08 17 56s358ms 3s315ms 09 2 31s670ms 15s835ms 10 17 1m38s 5s771ms 11 2 8s358ms 4s179ms [ User: intelifix - Total duration: 4m6s - Times executed: 40 ]
[ Application: [unknown] - Total duration: 4m6s - Times executed: 40 ]
-
CREATE TABLE temp0000288562 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-08-2026", "ate" :"17-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-17 07:58:44 Duration: 49s387ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288562 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-08-2026", "ate" :"17-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-17 10:22:14 Duration: 39s883ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288562 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-08-2026", "ate" :"17-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-17 09:27:10 Duration: 28s810ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 172ms 3m56s 6s6ms 275 27m31s call rs_giga_triagem (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 17 00 12 53s859ms 4s488ms 01 12 31s290ms 2s607ms 02 12 30s44ms 2s503ms 03 11 24s425ms 2s220ms 04 12 31s337ms 2s611ms 05 12 31s169ms 2s597ms 06 12 31s156ms 2s596ms 07 12 3m40s 18s389ms 08 12 7m34s 37s851ms 09 12 49s308ms 4s109ms 10 12 42s94ms 3s507ms 11 12 41s353ms 3s446ms 12 12 30s369ms 2s530ms 13 12 29s995ms 2s499ms 14 12 35s851ms 2s987ms 15 12 4m22s 21s910ms 16 12 41s918ms 3s493ms 17 12 31s163ms 2s596ms 18 12 28s471ms 2s372ms 19 12 29s477ms 2s456ms 20 12 53s57ms 4s421ms 21 12 33s485ms 2s790ms 22 12 34s40ms 2s836ms [ User: intelifix - Total duration: 27m31s - Times executed: 275 ]
[ Application: psql - Total duration: 27m31s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-17 08:49:05 Duration: 3m56s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-17 08:28:27 Duration: 3m14s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-17 07:28:27 Duration: 3m13s Database: rio User: intelifix Remote: [local] Application: psql
17 185ms 17s424ms 5s42ms 136 11m25s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 17 00 1 629ms 629ms 07 11 1m5s 5s940ms 08 12 1m19s 6s597ms 09 12 1m9s 5s778ms 10 12 49s532ms 4s127ms 11 12 1m5s 5s492ms 12 13 57s721ms 4s440ms 13 7 10s704ms 1s529ms 14 11 56s449ms 5s131ms 15 12 1m33s 7s797ms 16 12 1m13s 6s105ms 17 10 19s197ms 1s919ms 21 5 22s707ms 4s541ms 22 6 22s163ms 3s693ms [ User: intelifix - Total duration: 11m25s - Times executed: 136 ]
[ Application: psql - Total duration: 11m25s - Times executed: 136 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-17 07:45:18 Duration: 17s424ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-17 16:25:18 Duration: 17s104ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-17 15:55:17 Duration: 16s500ms Database: rio User: intelifix Remote: [local] Application: psql
18 2s903ms 8s574ms 3s737ms 55 3m25s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 17 08 3 11s12ms 3s670ms 09 3 9s926ms 3s308ms 10 4 14s609ms 3s652ms 11 4 14s556ms 3s639ms 12 3 10s115ms 3s371ms 13 3 10s306ms 3s435ms 14 5 25s374ms 5s74ms 15 4 15s674ms 3s918ms 16 4 14s757ms 3s689ms 17 3 10s140ms 3s380ms 18 4 14s427ms 3s606ms 19 4 14s219ms 3s554ms 20 3 10s561ms 3s520ms 21 3 12s987ms 4s329ms 22 5 16s873ms 3s374ms [ User: intelifix - Total duration: 3m25s - Times executed: 55 ]
[ Application: psql - Total duration: 3m25s - Times executed: 55 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-17 14:40:10 Duration: 8s574ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-17 21:00:10 Duration: 6s181ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-17 14:40:15 Duration: 5s5ms Database: brasilia User: intelifix Remote: [local] Application: psql
19 195ms 39s374ms 2s49ms 68 2m19s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 17 07 4 3s801ms 950ms 08 5 9s231ms 1s846ms 09 7 49s990ms 7s141ms 10 8 12s949ms 1s618ms 11 4 9s146ms 2s286ms 12 3 14s9ms 4s669ms 13 2 797ms 398ms 14 10 4s552ms 455ms 15 8 8s967ms 1s120ms 16 13 3s595ms 276ms 17 4 22s341ms 5s585ms [ User: intelifix - Total duration: 2m19s - Times executed: 68 ]
[ Application: psql - Total duration: 2m19s - Times executed: 68 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028554);
Date: 2026-08-17 09:07:30 Duration: 39s374ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 508); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028608);
Date: 2026-08-17 17:23:22 Duration: 10s791ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 450); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028573);
Date: 2026-08-17 12:17:06 Duration: 10s82ms Database: rio User: intelifix Remote: [local] Application: psql
20 150ms 7s720ms 1s468ms 1,140 27m53s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 17 08 83 1m32s 1s111ms 09 170 3m38s 1s285ms 10 154 3m26s 1s338ms 11 141 3m43s 1s584ms 12 31 47s930ms 1s546ms 13 90 2m1s 1s345ms 14 172 4m28s 1s560ms 15 150 3m44s 1s498ms 16 97 3m4s 1s906ms 17 47 1m18s 1s676ms 18 5 7s182ms 1s436ms [ User: intelifix - Total duration: 27m53s - Times executed: 1140 ]
[ Application: [unknown] - Total duration: 27m53s - Times executed: 1140 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52953, 406, '836030905001924,241728551632,241704648603,241664773443,241622436572,241732087980,241728526376,241654532545,241599288196,241728671621,241598837591,241708521024,241731238694,241664814457,241617447286,230043318693,241667756876,241713695658,241620852737,241676631739,241727046467,241676663436,241700930317,241704382135,241704165974,241708987185,241704739497,241689459107,241695524547,241636028190,241676735362,241706685165,241610117390,241594349094,241645810830,241728680006,241607244349,241622562040,241732109902,241666955878,241607233641,241728679499,241680297797,241692655973,241727053741,241727260406,241608708802,241695617586,241631264864,241620712342,241661218405', '',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-17 14:28:00 Duration: 7s720ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (52916, 406, '270911029132107551,229726410415,229755875265,229669753235,216941986161,229736813450,229755008907,229735571219,229741654259,229817050417,229859086673,229805221619,229735559803,229813385569,229687352136,229745333350,229880019299,229664247175,229728467180,216945127388,229686226481,216944103035,229749599400,216937556582,229925397084,229809398692,229689784045,229786736683,229864928197,229879519700,229780839193,229689029314,229736846483,229669254971,229755448298,229807180621,229782747988,229805744756,229805245055,229809535272,229669490707,229728562847,229813800414,229805245762,229663868698,216945082334,229748817595,229752744062,229859193755,229745689298,229742000410', '246506731120,246559542828,246548880924,246471264650,246528454564,246587399901,246542826471,246530885160,246632310514,246641329205,246598450610,246509277888,246630120828,246517568495,246535987992,246652852440,246467952947,246543938083,246489124665,246515627374,246498352547,246562562831,246442025758,246042535659,246629425574,246516512041,246598590018,246648107778,246652546270,246585998888,246521431926,246532728291,246516094850,246588241129,246581535266,246597883753,246581746375,246598447376,246629424867,246514842136,246545001331,246628980930,246593072139,246471633351,246488087380,246551319702,246566537786,246642197179,246542845463,246549614968', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-17 11:28:08 Duration: 7s465ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (133219, 401, 'ZTE3ANNT3H15111,D831399825C2,D831399825C3,ZTEGDD320BA6$ZTE3ANNQ7101666,C4EBFF89EF74,C4EBFF89EF75,ZTEGD70A2354$ZTE3ANNQ7901538,C4EBFF8C421C,C4EBFF8C421D,ZTEGD70A8670$ZTE3ANNR9F15124,D89A0DA4405B,D89A0DA4405C,ZTEGDB15625F$ZTE3ANNT3F15887,D8313996A022,D8313996A023,ZTEGDD31CAB6$ZTE3ANNRCP73926,6C11BA6FEF73,6C11BA6FEF74,ZTEGDC706159$ZTE3ANNT2V51383,D83139904322,D83139904323,ZTEGDD30BB36$ZTE3ANNR4N13476,4896D95696F0,4896D95696F1,ZTEGD97F5469$ZTE3ANNRAD25655,D89A0DB033AD,D89A0DB033AE,ZTEGDB176042$ZTE3ANNQ5N05248,3CF9F0AD4076,3CF9F0AD4077,ZTEGD641CAC7$ZTE3ANNR3Y51927,4896D95481C2,4896D95481C3,ZTEGD97EFB8C$ZTE3ANNR9336670,D89A0D85BB7F,D89A0D85BB80,ZTEGDB15033D$ZTE3ANNR1Y17439,14CA56CE4335,14CA56CE4336,ZTEGD970BA7A$ZTE3ANNQ4A10727,3CF9F0AAF3B0,3CF9F0AAF3B1,ZTEGD64168A6$ZTE3ANNR6R32458,48D682387D7E,48D682387D7F,ZTEGDB01A99D$ZTE3ANNQ7112235,C4EBFF8AE72A,C4EBFF8AE72B,ZTEGD70A4C9D$ZTE3ANNR5W57569,48D68233C910,48D68233C911,ZTEGDB00E0E0$ZTE3ANNQ9J38182,843C992F5019,843C992F501A,ZTEGD7BB9DD1$ZTE3ANNRAM39021,5872C98ACAC7,5872C98ACAC8,ZTEGDC60986C$ZTE3ANNR9300427,D89A0D826A0D,D89A0D826A0E,ZTEGDB1475AA$ZTE3ANNR2Q13725,F4E84F81F5AE,F4E84F81F5AF,ZTEGD97AA857$ZTE3ANNQ9J43607,843C992FCF3F,843C992FCF40,ZTEGD7BBB302$ZTE3ANNT2V80356,D8313992EA30,D8313992EA31,ZTEGDD312C63$ZTE3ANNQ9J43742,843C992FD269,843C992FD26A,ZTEGD7BBB389$ZTE3ANNR3Y05576,4896D9504368,4896D9504369,ZTEGD97E467D$ZTE3ANNRAM61820,5872C98CE121,5872C98CE122,ZTEGDC60F17B', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-17 09:51:22 Duration: 6s727ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 4 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 17 15 1 0ms 0ms 19 2 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 7s812ms - Times executed: 4 ]
[ Application: psql - Total duration: 6s733ms - Times executed: 3 ]
[ Application: [unknown] - Total duration: 1s79ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 20,268 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 14 FATAL entries
- 4869 ERROR entries
- 0 WARNING entries
- 18 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,794 Max number of times the same event was reported
- 4,901 Total events found
Rank Times reported Error 1 4,794 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 17 00 59 01 56 02 58 03 55 04 58 05 56 06 57 07 245 08 515 09 583 10 530 11 490 12 284 13 236 14 379 15 358 16 291 17 147 18 61 19 57 20 58 21 57 22 57 23 47 - ERROR: prepared statement "_PLAN000000002A5CF7C0" does not exist
- ERROR: prepared statement "_PLAN000000002A5CF7C0" does not exist
- ERROR: prepared statement "_PLAN000000002A5D20D0" does not exist
Statement: DEALLOCATE "_PLAN000000002A5CF7C0"
Date: 2026-08-17 00:00:02 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002A5CF7C0"
Date: 2026-08-17 00:01:02 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002A5D20D0"
Date: 2026-08-17 00:02:02 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 17 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-17 00:05:03 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-17 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-17 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
3 14 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 17 07 1 08 5 11 1 14 1 15 6 - LOG: process 2099297 still waiting for ShareLock on transaction 4508704 after 1000.095 ms
- LOG: process 2126044 still waiting for ShareLock on transaction 4512042 after 1000.177 ms
- LOG: process 2126044 still waiting for ShareLock on transaction 4512042 after 107007.419 ms
Detail: Process holding the lock: 2098623. Wait queue: 2099297.
Context: while updating tuple (76852,39) 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-17 07:25:19 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 2113709. Wait queue: 2126044.
Context: while updating tuple (76854,61) 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-17 08:25:19 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 2113709. Wait queue: 2126044.
Context: while updating tuple (76854,61) 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-17 08:27:05 Database: rio Application: psql User: intelifix Remote: [local]
4 11 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 17 08 1 09 5 14 2 15 3 - ERROR: syntax error at or near "241704733336" at character 41
- ERROR: syntax error at or near "]" at character 33
- ERROR: syntax error at or near "]" at character 33
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''241704733336');
Date: 2026-08-17 08:57:29 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: select * from rs_caixa_qr(128869])
Date: 2026-08-17 09:10:10 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(128869])
Date: 2026-08-17 09:10:10 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
5 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 17 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-08-17 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-08-17 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-17 03:05:01 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 17 00 1 05 1 06 1 11 1 18 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-08-17 00:02:21 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-17 05:56:02 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-17 06:02:22 Database: testes Application: [unknown] User: lenon Remote: [local]
7 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 17 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-17 05:32:17 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-17 05:32:17 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-17 05:32:17 Database: contagem Application: psql User: intelifix Remote: [local]
8 4 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 17 08 2 09 2 - ERROR: column "v" does not exist at character 27
- ERROR: column "v" does not exist at character 27
- ERROR: column "v" does not exist at character 27
Statement: select * from rs_caixa_qr(v)
Date: 2026-08-17 08:54:33 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(v)
Date: 2026-08-17 08:54:33 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(v)
Date: 2026-08-17 09:27:28 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
9 4 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Aug 17 10 1 14 3 - ERROR: trailing junk after numeric literal at or near "5447CC496897" at character 41
- ERROR: trailing junk after numeric literal at or near "0F" at character 30
- ERROR: trailing junk after numeric literal at or near "0F" at character 30
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''5447CC496897');
Date: 2026-08-17 10:37:37 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(88-0F-A2-B4-0E-15)
Date: 2026-08-17 14:49:33 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(88-0F-A2-B4-0E-15)
Date: 2026-08-17 14:49:33 Database: rio Application: [unknown] User: etiquetas Remote: [local]
10 2 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #10
Day Hour Count Aug 17 11 1 16 1 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000288572"
Date: 2026-08-17 11:11:47
Context: automatic vacuum of table "rio.public.temp0000288686"
Date: 2026-08-17 16:26:50
11 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #11
Day Hour Count Aug 17 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-17 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-17 03:05:02 Database: rio Application: [unknown] User: etiquetas Remote: [local]
12 2 ERROR: insert or update on table "..." violates foreign key constraint "..."
Times Reported Most Frequent Error / Event #12
Day Hour Count Aug 17 15 2 - ERROR: insert or update on table "lote_itens" violates foreign key constraint "lote_itens_flu_id_fkey"
- ERROR: insert or update on table "lote_itens" violates foreign key constraint "lote_itens_flu_id_fkey"
Detail: Key (flu_id)=(5840661) is not present in table "fluxos".
Context: SQL statement "UPDATE LOTE_ITENS SET FLU_ID = nOriginal, LI_STATUS = 1 WHERE LI_ID = nLI" PL/pgSQL function rs_triagem_exclui(integer,integer) line 106 at SQL statement
Statement: SELECT * FROM RS_TRIAGEM_EXCLUI(6014303,99);Date: 2026-08-17 15:31:03 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Key (flu_id)=(5840661) is not present in table "fluxos".
Context: SQL statement "UPDATE LOTE_ITENS SET FLU_ID = nOriginal, LI_STATUS = 1 WHERE LI_ID = nLI" PL/pgSQL function rs_triagem_exclui(integer,integer) line 106 at SQL statement
Statement: SELECT * FROM RS_TRIAGEM_EXCLUI(6014303,99);Date: 2026-08-17 15:32:16 Database: rio Application: [unknown] User: intelifix Remote: [local]
13 2 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #13
Day Hour Count Aug 17 11 1 16 1 - LOG: process 2279139 still waiting for AccessExclusiveLock on relation 3889562 of database 358220 after 1000.065 ms
- LOG: process 2568320 still waiting for AccessExclusiveLock on relation 3915155 of database 358220 after 1000.174 ms
Detail: Process holding the lock: 2312237. Wait queue: 2279139.
Statement: DROP TABLE IF EXISTS temp0000288572;Date: 2026-08-17 11:11:47 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 2585236. Wait queue: 2568320.
Statement: DROP TABLE IF EXISTS temp0000288686;Date: 2026-08-17 16:26:50 Database: rio Application: [unknown] User: intelifix Remote: [local]
14 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #14
Day Hour Count Aug 17 03 1 - LOG: database system was shut down at 2026-08-17 03:05:03 -03
Date: 2026-08-17 03:05:05
15 1 ERROR: function rs_lote_manutencao_itens(...) does not exist
Times Reported Most Frequent Error / Event #15
Day Hour Count Aug 17 10 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(52925,413,'510016272032,CC75E2BDB884$518191037988,2C9569F29379$517335092434,BC644BD95CDB$517303121120,BC644BC7872C$519137349293,CC75E2B99835$517152236682,B0DAF96398F1$517276561823,BC644BC5242D$510043030406,A8F5DDED4B92$517284489611,BC644BD5DF7A$517249706065,B0935BED7350$519126041020,A8F5DDE5F2BB$518295151515,4C1265344050','',042,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',0128894510016272032);Date: 2026-08-17 10:02:27 Database: contagem Application: [unknown] User: intelifix Remote: [local]
16 1 LOG: skipping analyze of "..." --- lock not available
Times Reported Most Frequent Error / Event #16
Day Hour Count Aug 17 16 1 - LOG: skipping analyze of "temp0000288664" --- lock not available
Date: 2026-08-17 16:45:51
17 1 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #17
Day Hour Count Aug 17 10 1 - ERROR: unterminated quoted string at or near "''');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-08-17 10:37:31 Database: brasilia Application: [unknown] User: intelifix Remote: [local]