pgBadger-
Global information
- Generated on Thu Oct 8 23:50:09 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 27,855 log entries in 8s
- Log start from 2026-10-08 00:02:02 to 2026-10-08 23:48:36
-
Overview
Global Stats
- 328 Number of unique normalized queries
- 3,701 Number of queries
- 5h53m1s Total query duration
- 2026-10-08 00:02:03 First query
- 2026-10-08 23:43:06 Last query
- 5 queries/s at 2026-10-08 23:43:02 Query peak
- 5h53m1s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 5h53m1s Execute total duration
- 2,344 Number of events
- 13 Number of unique normalized events
- 2,288 Max number of times the same event was reported
- 0 Number of cancellation
- 334 Total number of automatic vacuums
- 796 Total number of automatic analyzes
- 20 Number temporary file
- 249.82 MiB Max size of temporary file
- 67.96 MiB Average size of temporary file
- 341 Total number of sessions
- 9 sessions at 2026-10-08 07:55:55 Session peak
- 11d20h12m16s Total duration of sessions
- 50m Average duration of sessions
- 10 Average queries per session
- 1m2s Average queries duration per session
- 48m58s Average idle time per session
- 361 Total number of connections
- 6 connections/s at 2026-10-08 00:05:01 Connection peak
- 4 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-08 23:43:02 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-10-08 09:59:34 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-08 23:43:02 Date
Queries duration
Key values
- 5h53m1s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 08 00 28 0ms 13s13ms 2s693ms 5s19ms 50s462ms 50s462ms 01 25 0ms 2s694ms 1s158ms 5s173ms 6s285ms 6s285ms 02 17 0ms 2s961ms 1s307ms 4s21ms 5s442ms 5s442ms 03 17 0ms 2s623ms 1s449ms 4s856ms 4s856ms 4s856ms 04 20 0ms 3s788ms 1s353ms 6s437ms 6s437ms 6s437ms 05 31 0ms 9m 40s22ms 2m37s 6m41s 9m 06 22 0ms 12s325ms 2s477ms 12s325ms 22s30ms 22s30ms 07 174 0ms 6m36s 8s559ms 39s173ms 3m49s 6m36s 08 329 0ms 5m35s 4s900ms 27s447ms 5m41s 5m48s 09 487 0ms 5m52s 3s276ms 42s378ms 3m41s 5m54s 10 390 151ms 5m40s 3s680ms 42s186ms 3m31s 5m41s 11 268 0ms 5m50s 4s480ms 15s693ms 3m31s 5m54s 12 78 0ms 5m34s 8s384ms 6s469ms 47s502ms 5m34s 13 155 0ms 5m11s 4s463ms 8s870ms 10s228ms 5m58s 14 289 0ms 5m50s 4s675ms 39s687ms 4m3s 5m50s 15 443 0ms 5m39s 4s576ms 1m4s 3m38s 5m52s 16 253 0ms 5m24s 4s177ms 31s225ms 38s412ms 6m8s 17 119 0ms 5m17s 8s612ms 25s184ms 3m41s 5m48s 18 39 0ms 5m11s 15s705ms 22s141ms 3m19s 5m55s 19 24 0ms 5m8s 23s951ms 3m13s 5m52s 5m52s 20 110 0ms 5m39s 10s835ms 3m29s 6m43s 6m43s 21 30 0ms 5m28s 20s489ms 3m23s 5m58s 5m58s 22 30 0ms 5m18s 20s4ms 3m19s 5m47s 5m47s 23 323 0ms 1m2s 6s113ms 1m6s 1m14s 1m15s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 08 00 4 0 1s254ms 0ms 0ms 5s19ms 01 7 0 265ms 154ms 685ms 846ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 2 0 324ms 0ms 648ms 648ms 05 9 0 273ms 167ms 640ms 662ms 06 6 0 927ms 0ms 686ms 4s877ms 07 91 0 12s664ms 2s137ms 8s754ms 6m17s 08 253 0 5s589ms 6s191ms 15s96ms 5m37s 09 388 0 3s28ms 10s479ms 14s829ms 5m53s 10 303 0 3s702ms 6s350ms 12s757ms 5m28s 11 200 0 5s356ms 3s452ms 11s327ms 5m50s 12 35 0 17s125ms 687ms 1s758ms 3m20s 13 111 0 5s739ms 1s499ms 5s247ms 3m26s 14 213 0 5s286ms 4s857ms 10s608ms 5m42s 15 259 0 4s268ms 6s735ms 19s470ms 5m41s 16 158 0 4s450ms 3s782ms 11s967ms 3m25s 17 82 0 11s800ms 6s133ms 21s281ms 5m47s 18 20 0 28s197ms 2s137ms 2s667ms 5m55s 19 6 0 1m31s 0ms 3m13s 5m52s 20 8 82 12s879ms 1m6s 3m29s 5m39s 21 7 0 1m22s 212ms 3m23s 5m58s 22 6 0 1m33s 0ms 3m19s 5m47s 23 2 321 6s113ms 1m3s 1m6s 1m15s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 08 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Oct 08 00 0 0 0.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 1 1.00 0.00% 05 0 3 3.00 0.00% 06 0 1 1.00 0.00% 07 0 8 8.00 0.00% 08 0 11 11.00 0.00% 09 0 9 9.00 0.00% 10 0 10 10.00 0.00% 11 0 6 6.00 0.00% 12 0 3 3.00 0.00% 13 0 5 5.00 0.00% 14 0 9 9.00 0.00% 15 0 10 10.00 0.00% 16 0 8 8.00 0.00% 17 0 4 4.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Oct 08 00 16 0.00/s 01 9 0.00/s 02 9 0.00/s 03 12 0.00/s 04 8 0.00/s 05 10 0.00/s 06 14 0.00/s 07 22 0.01/s 08 24 0.01/s 09 28 0.01/s 10 21 0.01/s 11 20 0.01/s 12 16 0.00/s 13 20 0.01/s 14 18 0.01/s 15 27 0.01/s 16 19 0.01/s 17 12 0.00/s 18 7 0.00/s 19 13 0.00/s 20 12 0.00/s 21 7 0.00/s 22 7 0.00/s 23 10 0.00/s Day Hour Count Average Duration Average idle time Oct 08 00 4 47m30s 47m11s 01 15 1h1m 1h58s 02 9 1h20s 1h17s 03 15 23m34s 23m32s 04 5 1h1m12s 1h1m6s 05 9 55m28s 53m10s 06 6 57m30s 57m21s 07 15 54m31s 52m51s 08 26 44m34s 43m32s 09 25 38m52s 37m48s 10 22 54m38s 53m32s 11 24 42m55s 42m4s 12 14 1h1m36s 1h49s 13 13 57m36s 56m43s 14 21 53m3s 51m59s 15 20 47m29s 45m48s 16 21 53m19s 52m29s 17 20 53m2s 52m10s 18 10 56m30s 55m29s 19 7 1h2m2s 1h40s 20 12 41m37s 39m58s 21 8 1h45s 59m28s 22 7 1h45s 59m19s 23 13 34m51s 32m19s -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2026-10-08 00:05:01 Date
Connections per database
Key values
- brasilia Main Database
- 361 connections Total
Connections per user
Key values
- intelifix Main User
- 361 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2026-10-08 07:55:55 Date
Histogram of session times
Key values
- 254 3600000-28800000ms duration
Sessions per database
Key values
- brasilia Main Database
- 341 sessions Total
Sessions per user
Key values
- intelifix Main User
- 341 sessions Total
Sessions per host
Key values
- [local] Main Host
- 341 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 19,866 buffers Checkpoint Peak
- 2026-10-08 00:09:44 Date
- 270.068 seconds Highest write time
- 0.022 seconds Sync time
Checkpoints Wal files
Key values
- 12 files Wal files usage Peak
- 2026-10-08 15:34:37 Date
Checkpoints distance
Key values
- 395.96 Mo Distance Peak
- 2026-10-08 15:34:37 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Oct 08 00 29,858 652.914s 0.013s 652.945s 01 2,519 252.326s 0.015s 252.359s 02 1,152 115.529s 0.014s 115.559s 03 1,766 176.166s 0.026s 176.211s 04 2,053 205.693s 0.013s 205.722s 05 10,241 1,025.338s 0.05s 1,025.417s 06 4,584 269.175s 0.001s 269.178s 07 20,415 2,038.348s 0.054s 2,038.452s 08 42,053 2,807.407s 0.109s 2,807.585s 09 43,763 3,239.356s 0.145s 3,239.585s 10 44,116 3,196.49s 0.124s 3,196.685s 11 42,240 3,073.486s 0.084s 3,073.637s 12 14,740 1,476.035s 0.052s 1,476.127s 13 17,270 1,520.784s 0.053s 1,520.873s 14 38,595 2,903.528s 0.094s 2,903.684s 15 36,368 3,234.363s 0.097s 3,234.549s 16 27,639 2,252.722s 0.072s 2,252.855s 17 16,027 1,065.439s 0.05s 1,065.562s 18 3,095 310.035s 0.017s 310.068s 19 24 2.412s 0.002s 2.416s 20 760 86.583s 0.007s 86.599s 21 3,204 320.5s 0.011s 320.531s 22 3,630 363.269s 0.016s 363.302s 23 430 43.221s 0.006s 43.238s Day Hour Added Removed Recycled Synced files Longest sync Average sync Oct 08 00 0 0 8 547 0.002s 0.006s 01 0 0 1 560 0.002s 0.007s 02 0 0 0 377 0.002s 0.006s 03 0 0 1 357 0.002s 0.008s 04 0 0 0 436 0.002s 0.006s 05 0 0 5 809 0.017s 0.009s 06 0 0 0 12 0.001s 0.001s 07 0 0 22 2,246 0.004s 0.012s 08 0 0 30 5,469 0.003s 0.012s 09 0 0 45 6,948 0.003s 0.012s 10 0 0 31 6,614 0.004s 0.012s 11 0 0 23 4,990 0.002s 0.012s 12 0 0 6 2,399 0.003s 0.012s 13 0 0 7 3,077 0.002s 0.012s 14 0 0 24 4,766 0.003s 0.012s 15 0 0 70 5,577 0.002s 0.012s 16 0 0 38 4,426 0.004s 0.012s 17 0 0 13 2,287 0.002s 0.012s 18 0 0 1 394 0.002s 0.006s 19 0 0 0 3 0.002s 0.001s 20 0 0 0 79 0.002s 0.003s 21 0 0 1 391 0.002s 0.005s 22 0 0 1 485 0.003s 0.007s 23 0 0 0 41 0.002s 0.005s Day Hour Count Avg time (sec) Oct 08 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Oct 08 00 20,391.00 kB 51,825.83 kB 01 1,845.00 kB 27,625.86 kB 02 913.17 kB 14,497.17 kB 03 1,150.75 kB 2,691.38 kB 04 1,751.00 kB 2,311.00 kB 05 8,119.78 kB 15,484.89 kB 06 9,338.00 kB 13,238.00 kB 07 29,971.42 kB 48,376.00 kB 08 40,042.17 kB 91,894.08 kB 09 62,101.42 kB 109,232.17 kB 10 41,991.50 kB 100,455.25 kB 11 30,969.17 kB 74,570.08 kB 12 8,684.83 kB 33,593.92 kB 13 9,732.75 kB 22,604.58 kB 14 33,449.00 kB 73,501.83 kB 15 94,396.25 kB 144,899.75 kB 16 52,372.42 kB 118,948.25 kB 17 17,806.42 kB 53,313.17 kB 18 2,348.67 kB 21,994.83 kB 19 189.00 kB 15,131.00 kB 20 1,914.67 kB 12,688.33 kB 21 3,050.80 kB 9,285.40 kB 22 2,500.43 kB 6,203.43 kB 23 294.80 kB 3,920.60 kB -
Temporary Files
Size of temporary files
Key values
- 499.64 MiB Temp Files size Peak
- 2026-10-08 05:31:54 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-10-08 05:32:00 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 08 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.33 GiB 67.96 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.02 GiB 37.26 MiB 249.82 MiB 65.55 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-08 05:32:02 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-08 05:31:54 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 310.32 MiB 57.69 MiB 94.94 MiB 77.58 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-08 05:30:40 Duration: 38s854ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-08 05:30:36 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 249.82 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-08 05:31:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 249.82 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-08 05:31:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 94.94 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-08 05:30:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 94.94 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-08 05:30:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 62.76 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-08 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 57.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-08 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 41.24 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-08 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 41.18 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-08 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 41.17 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-08 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 41.17 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-08 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 41.17 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-08 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 41.17 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-08 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 41.17 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-08 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 37.32 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-08 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 37.27 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-08 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 37.26 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-08 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 37.26 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-08 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 37.26 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-08 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 37.26 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-08 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 37.26 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-08 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 8.05 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_10
Database rio - 2026-10-08 12:37:44 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 8.05 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_10
Database rio - 2026-10-08 12:37:44 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (83) Main table analyzed (database rio)
- 796 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 83 rio.public.temp0000293704 58 rio.public.temp0000293762 54 rio.public.usuarios 49 rio.pg_catalog.pg_class 43 rio.pg_catalog.pg_type 36 brasilia.pg_catalog.pg_attribute 35 rio.public.temp0000293696 33 brasilia.public.temp0000241860 31 brasilia.public.temp0000241838 28 rio.pg_catalog.pg_index 23 brasilia.pg_catalog.pg_class 20 rio.public.temp0000293716 20 brasilia.pg_catalog.pg_type 19 rio.public.temp0000293774 16 rio.pg_catalog.pg_depend 16 contagem.public.temp0000227480 14 contagem.pg_catalog.pg_attribute 14 rio.public.temp0000293000 12 brasilia.pg_catalog.pg_index 12 rio.public.temp0000293700 11 brasilia.pg_catalog.pg_depend 11 rio.public.temp0000292754 11 rio.public.temp0000293692 9 rio.public.temp0000293756 8 contagem.public.usuarios 7 rio.public.temp0000293686 7 brasilia.public.usuarios 7 brasilia.public.nf_entrada 6 contagem.pg_catalog.pg_class 6 rio.public.temp0000293690 6 brasilia.public.temp0000241876 6 rio.public.temp0000293702 6 contagem.pg_catalog.pg_type 5 brasilia.public.temp0000241820 5 rio.public.temp0000293714 5 rio.public.temp0000293712 5 brasilia.public.temp0000241850 3 brasilia.public.temp0000241862 3 brasilia.public.temp0000241800 3 contagem.pg_catalog.pg_index 3 brasilia.public.temp0000241848 3 contagem.pg_catalog.pg_depend 2 rio.public.temp0000293766 2 postgres.pg_catalog.pg_shdepend 2 brasilia.public.temp0000241866 2 rio.public.temp0000293708 2 rio.pg_catalog.pg_shdepend 2 brasilia.public.temp0000241808 2 rio.public.temp0000293786 2 brasilia.public.temp0000241840 2 rio.public.temp0000293788 2 brasilia.public.temp0000241806 2 rio.public.tmp_drill_0320 2 brasilia.pg_catalog.pg_shdepend 1 rio.public.temp0000293710 1 contagem.pg_catalog.pg_shdepend 1 testes.pg_catalog.pg_shdepend 1 rio.public.temp0000293728 1 rio.auditor.auditor_2026_10 1 contagem.public.temp0000227484 1 brasilia.public.temp0000241832 1 template1.pg_catalog.pg_shdepend 1 brasilia.public.temp0000241880 1 rio.public.temp0000293718 1 rio.public.temp0000293758 1 brasilia.public.temp0000241816 1 contagem.public.nf_entrada 1 brasilia.public.temp0000241844 1 rio.public.temp0000293780 1 rio.public.temp0000293694 1 brasilia.auditor.auditor_2026_10 1 brasilia.public.temp0000241874 1 contagem.public.temp0000227478 1 Total 796 Vacuums per table
Key values
- public.temp0000293696 (33) Main table vacuumed on database rio
- 334 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000293696 33 0 0 0 0 0 0 2,951 496 721,684 0 0 rio.public.temp0000293704 31 0 0 0 0 0 0 57,435 5,669 10,589,599 0 0 rio.pg_catalog.pg_attribute 30 26 0 0 0 0 0 14,581 4,346 6,410,601 177 4,129 rio.public.temp0000293762 20 0 0 0 0 0 0 12,829 100 772,365 0 0 rio.pg_catalog.pg_class 20 15 0 0 0 0 0 2,775 993 1,478,505 57 198 rio.pg_catalog.pg_type 17 13 0 0 0 0 0 1,339 435 626,507 43 114 brasilia.pg_catalog.pg_attribute 15 15 0 0 0 0 0 8,838 1,542 2,933,879 53 1,409 rio.public.temp0000292754 11 0 0 0 0 0 0 913 127 175,683 0 0 rio.public.temp0000293000 11 0 0 0 0 0 0 721 132 162,856 0 0 brasilia.pg_catalog.pg_class 10 10 0 0 0 0 0 2,132 208 486,242 10 37 rio.public.temp0000293716 9 0 0 0 0 0 0 3,977 41 240,882 0 0 brasilia.pg_catalog.pg_type 9 9 0 0 0 0 0 987 149 293,266 7 34 rio.pg_catalog.pg_index 9 9 0 0 0 0 0 468 127 160,060 19 40 contagem.public.usuarios 7 0 0 0 0 0 0 27 19 12,331 0 0 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 8,271 1,652 7,183,521 806 3,168 rio.public.temp0000293686 7 0 0 0 0 0 0 11,120 1,876 3,054,119 0 0 brasilia.pg_catalog.pg_index 7 7 0 0 0 0 0 347 63 79,376 9 17 rio.pg_catalog.pg_depend 7 7 0 0 0 0 0 2,430 910 1,419,082 49 378 contagem.pg_catalog.pg_attribute 6 6 0 0 0 0 0 3,957 906 1,734,522 5 137 brasilia.pg_catalog.pg_depend 5 5 0 0 0 0 0 1,614 305 687,432 10 49 rio.public.tmp_drill_0320 5 2 0 0 0 0 0 83 31 44,483 1 58 rio.public.temp0000293702 5 0 0 0 0 0 0 327 127 189,745 0 0 rio.public.usuarios 5 4 0 0 0 0 0 144 66 150,352 17 25 postgres.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 1,323 460 1,026,502 47 84 rio.public.temp0000293700 5 0 0 0 0 0 0 395 107 159,765 0 0 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,751 314 1,633,692 83 232 brasilia.pg_catalog.pg_statistic 4 4 0 0 0 0 0 4,642 1,590 5,544,464 1,296 7,616 brasilia.public.temp0000241862 3 0 0 0 0 0 0 776 12 47,593 0 0 brasilia.public.temp0000241800 3 0 0 0 0 0 0 774 12 47,475 0 0 contagem.pg_catalog.pg_type 2 2 0 0 0 0 0 225 45 72,370 1 2 rio.public.temp0000293788 2 0 0 0 0 0 0 1,860 1,859 2,509,021 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 389 112 478,673 45 111 contagem.pg_catalog.pg_class 2 2 0 0 0 0 0 465 77 119,014 4 10 contagem.public.nf_entrada 1 1 0 0 0 0 0 69 19 49,485 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,178 5 157,408 0 0 contagem.pg_catalog.pg_index 1 1 0 0 0 0 0 76 11 18,618 0 0 contagem.public.temp0000227480 1 0 0 0 0 0 0 118 6 7,940 0 0 brasilia.auditor.auditor_2026_10 1 0 0 0 0 0 0 16,145 9,724 12,558,156 3,177 63,426 contagem.auditor.auditor_2026_10 1 0 0 0 0 0 0 9,974 6,966 8,660,045 1,453 36,761 brasilia.public.temp0000241874 1 0 0 0 0 0 0 259 4 15,884 0 0 brasilia.public.temp0000241860 1 0 0 0 0 0 0 259 4 15,884 0 0 brasilia.public.temp0000241848 1 0 0 0 0 0 0 258 4 15,825 0 0 contagem.pg_catalog.pg_depend 1 1 0 0 0 0 0 366 52 107,666 0 0 rio.public.temp0000293728 1 0 0 0 0 0 0 75 6 5,307 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 153 10 37,545 0 0 brasilia.public.nf_entrada 1 1 0 0 0 0 0 291 150 254,121 6 8 rio.auditor.auditor_2026_10 1 0 0 0 0 0 0 61,691 25,335 33,600,738 18,218 349,338 contagem.public.temp0000227484 1 0 0 0 0 0 0 118 6 7,940 0 0 brasilia.public.temp0000241840 1 0 0 0 0 0 0 258 4 15,825 0 0 Total 334 160 0 0 0 0 0 243,154 67,214 106,774,048 25,593 467,381 Vacuum throughput per table
Key values
- auditor.auditor_2026_10 (8.05) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000293696 0 0 0.14 rio.public.temp0000293704 0 0 1.35 rio.pg_catalog.pg_attribute 0 0 1.89 rio.public.temp0000293762 0 0 0.25 rio.pg_catalog.pg_class 0 0 0.48 rio.pg_catalog.pg_type 0 0 0.14 brasilia.pg_catalog.pg_attribute 0 0 0.92 rio.public.temp0000292754 0 0 0.01 rio.public.temp0000293000 0 0 0.02 brasilia.pg_catalog.pg_class 0 0 0.13 rio.public.temp0000293716 0 0 0.17 brasilia.pg_catalog.pg_type 0 0 0.07 rio.pg_catalog.pg_index 0 0 0.08 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_statistic 0 0 1.02 rio.public.temp0000293686 0 0 0.31 brasilia.pg_catalog.pg_index 0 0 0.02 rio.pg_catalog.pg_depend 0 0 0.48 contagem.pg_catalog.pg_attribute 0 0 0.49 brasilia.pg_catalog.pg_depend 0 0 0.38 rio.public.tmp_drill_0320 0 0 0 rio.public.temp0000293702 0 0 0.01 rio.public.usuarios 0 0 0 postgres.pg_catalog.pg_shdepend 0 0 0.28 rio.public.temp0000293700 0 0 0.02 rio.pg_toast.pg_toast_2619 0 0 0.15 brasilia.pg_catalog.pg_statistic 0 0 0.52 brasilia.public.temp0000241862 0 0 0 brasilia.public.temp0000241800 0 0 0 contagem.pg_catalog.pg_type 0 0 0.11 rio.public.temp0000293788 0 0 0.1 brasilia.pg_toast.pg_toast_2619 0 0 0.02 contagem.pg_catalog.pg_class 0 0 0.2 contagem.public.nf_entrada 0 0 0.02 contagem.pg_catalog.pg_statistic 0 0 0.03 contagem.pg_catalog.pg_index 0 0 0.03 contagem.public.temp0000227480 0 0 0 brasilia.auditor.auditor_2026_10 0 0 2.88 contagem.auditor.auditor_2026_10 0 0 2.28 brasilia.public.temp0000241874 0 0 0 brasilia.public.temp0000241860 0 0 0 brasilia.public.temp0000241848 0 0 0 contagem.pg_catalog.pg_depend 0 0 0.11 rio.public.temp0000293728 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 brasilia.public.nf_entrada 0 0 0.08 rio.auditor.auditor_2026_10 0 0 8.05 contagem.public.temp0000227484 0 0 0 brasilia.public.temp0000241840 0 0 0 Total 0 0 23.24 Tuples removed per table
Key values
- pg_catalog.pg_attribute (99594) Main table with removed tuples on database rio
- 261584 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 30 26 99,594 714,243 44,110 193 17,510 brasilia.pg_catalog.pg_attribute 15 15 77,897 346,585 0 138 8,984 contagem.pg_catalog.pg_attribute 6 6 24,454 151,772 0 235 3,268 rio.pg_catalog.pg_statistic 7 7 12,439 56,843 382 0 9,002 brasilia.pg_catalog.pg_statistic 4 4 7,059 32,885 0 0 4,284 rio.auditor.auditor_2026_10 1 0 5,026 4,581,650 0 0 222,219 contagem.pg_catalog.pg_statistic 1 1 4,435 7,274 0 0 1,011 rio.pg_catalog.pg_depend 7 7 4,371 135,107 2,552 0 1,316 brasilia.pg_catalog.pg_type 9 9 3,974 19,999 0 0 659 postgres.pg_catalog.pg_shdepend 5 5 3,507 90,101 4 0 750 rio.pg_catalog.pg_type 17 13 3,500 42,479 4,196 6 1,215 brasilia.pg_catalog.pg_index 7 7 2,212 13,210 0 3 368 rio.pg_catalog.pg_class 20 15 2,173 84,423 11,118 40 2,593 brasilia.pg_catalog.pg_class 10 10 1,771 34,806 0 36 1,288 rio.pg_catalog.pg_index 9 9 1,597 17,712 536 11 471 brasilia.pg_catalog.pg_depend 5 5 1,482 91,853 0 0 873 contagem.pg_catalog.pg_type 2 2 1,218 4,494 0 22 140 rio.pg_toast.pg_toast_2619 4 4 1,203 2,206 0 0 1,128 rio.public.usuarios 5 4 720 2,640 95 0 95 contagem.pg_catalog.pg_index 1 1 552 1,896 0 0 57 rio.public.tmp_drill_0320 5 2 543 4,288 1,629 0 73 contagem.public.usuarios 7 0 418 168 0 0 14 brasilia.public.nf_entrada 1 1 349 3,332 0 0 152 contagem.public.nf_entrada 1 1 327 1,683 0 0 87 brasilia.auditor.auditor_2026_10 1 0 222 1,332,039 0 0 60,312 brasilia.pg_toast.pg_toast_2619 2 2 202 300 0 0 144 contagem.pg_catalog.pg_class 2 2 140 7,097 0 0 304 contagem.pg_toast.pg_toast_2619 1 1 139 116 0 3 57 contagem.pg_catalog.pg_depend 1 1 60 19,059 0 0 180 rio.public.temp0000293704 31 0 0 815,358 0 0 57,536 rio.public.temp0000293788 2 0 0 52,706 0 0 3,712 contagem.public.temp0000227480 1 0 0 1,413 0 18 110 contagem.auditor.auditor_2026_10 1 0 0 970,315 0 0 44,818 rio.public.temp0000293716 9 0 0 118,273 0 90 7,718 rio.public.temp0000293686 7 0 0 184,121 0 0 12,992 brasilia.public.temp0000241874 1 0 0 3,399 0 0 256 rio.public.temp0000293702 5 0 0 12,865 0 97 287 brasilia.public.temp0000241860 1 0 0 3,399 0 0 256 brasilia.public.temp0000241848 1 0 0 3,390 0 0 256 rio.public.temp0000293762 20 0 0 229,406 0 169 12,759 rio.public.temp0000292754 11 0 0 42,139 0 263 953 brasilia.public.temp0000241862 3 0 0 10,188 0 0 768 rio.public.temp0000293728 1 0 0 3,006 0 61 67 rio.public.temp0000293700 5 0 0 19,866 0 195 445 contagem.public.temp0000227484 1 0 0 1,413 0 18 110 rio.public.temp0000293696 33 0 0 129,949 0 1,021 2,915 brasilia.public.temp0000241840 1 0 0 3,390 0 0 256 brasilia.public.temp0000241800 3 0 0 10,164 0 0 768 rio.public.temp0000293000 11 0 0 30,379 0 345 679 Total 334 160 261,584 10,445,399 64,622 2,964 486,215 Pages removed per table
Key values
- public.temp0000293696 (1021) Main table with removed pages on database rio
- 2964 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000293696 33 0 0 1021 rio.public.temp0000293000 11 0 0 345 rio.public.temp0000292754 11 0 0 263 contagem.pg_catalog.pg_attribute 6 6 24454 235 rio.public.temp0000293700 5 0 0 195 rio.pg_catalog.pg_attribute 30 26 99594 193 rio.public.temp0000293762 20 0 0 169 brasilia.pg_catalog.pg_attribute 15 15 77897 138 rio.public.temp0000293702 5 0 0 97 rio.public.temp0000293716 9 0 0 90 rio.public.temp0000293728 1 0 0 61 rio.pg_catalog.pg_class 20 15 2173 40 brasilia.pg_catalog.pg_class 10 10 1771 36 contagem.pg_catalog.pg_type 2 2 1218 22 contagem.public.temp0000227480 1 0 0 18 contagem.public.temp0000227484 1 0 0 18 rio.pg_catalog.pg_index 9 9 1597 11 rio.pg_catalog.pg_type 17 13 3500 6 brasilia.pg_catalog.pg_index 7 7 2212 3 contagem.pg_toast.pg_toast_2619 1 1 139 3 contagem.public.usuarios 7 0 418 0 contagem.public.nf_entrada 1 1 327 0 contagem.pg_catalog.pg_statistic 1 1 4435 0 rio.public.temp0000293704 31 0 0 0 contagem.pg_catalog.pg_index 1 1 552 0 rio.public.temp0000293788 2 0 0 0 rio.pg_toast.pg_toast_2619 4 4 1203 0 rio.pg_catalog.pg_statistic 7 7 12439 0 brasilia.auditor.auditor_2026_10 1 0 222 0 contagem.auditor.auditor_2026_10 1 0 0 0 rio.public.temp0000293686 7 0 0 0 brasilia.pg_catalog.pg_depend 5 5 1482 0 brasilia.public.temp0000241874 1 0 0 0 brasilia.pg_toast.pg_toast_2619 2 2 202 0 rio.public.tmp_drill_0320 5 2 543 0 brasilia.public.temp0000241860 1 0 0 0 brasilia.public.temp0000241848 1 0 0 0 brasilia.pg_catalog.pg_statistic 4 4 7059 0 contagem.pg_catalog.pg_depend 1 1 60 0 rio.pg_catalog.pg_depend 7 7 4371 0 brasilia.public.temp0000241862 3 0 0 0 rio.public.usuarios 5 4 720 0 brasilia.pg_catalog.pg_type 9 9 3974 0 postgres.pg_catalog.pg_shdepend 5 5 3507 0 brasilia.public.nf_entrada 1 1 349 0 contagem.pg_catalog.pg_class 2 2 140 0 rio.auditor.auditor_2026_10 1 0 5026 0 brasilia.public.temp0000241840 1 0 0 0 brasilia.public.temp0000241800 3 0 0 0 Total 334 160 261,584 2,964 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 08 00 0 0 01 0 3 02 0 0 03 0 0 04 0 0 05 6 4 06 0 1 07 14 37 08 39 73 09 39 105 10 51 84 11 22 60 12 17 17 13 18 48 14 28 84 15 53 153 16 38 99 17 9 21 18 0 2 19 0 0 20 0 0 21 0 5 22 0 0 23 0 0 - 8.05 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 3 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 2 2s 1s 1s 1s drop table if exists temp0000293704;-
DROP TABLE IF EXISTS temp0000293704;
Date: 2026-10-08 15:52:39 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000293704;
Date: 2026-10-08 10:55:37 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000293704;
Date: 2026-10-08 07:55:35 Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1 1s 1s 1s 1s drop table if exists temp0000293762;-
DROP TABLE IF EXISTS temp0000293762;
Date: 2026-10-08 16:16:39 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000293762;
Date: 2026-10-08 15:34:39 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 1s DROP TABLE IF EXISTS temp0000293762;[ Date: 2026-10-08 16:16:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 1s DROP TABLE IF EXISTS temp0000293704;[ Date: 2026-10-08 10:55:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 1s DROP TABLE IF EXISTS temp0000293704;[ Date: 2026-10-08 15:52:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 2,170 Total read queries
- 1,005 Total write queries
Queries by database
Key values
- rio Main database
- 2,139 Requests
- 4h16m57s (rio)
- Main time consuming database
Database Request type Count Duration brasilia Total 1,072 1h27m53s copy to 140 11m1s ddl 131 1m39s others 237 9m20s select 564 1h5m52s contagem Total 488 8m10s copy to 117 1m26s ddl 13 12s642ms others 5 2m52s select 353 3m39s rio Total 2,139 4h16m57s copy to 146 29m49s ddl 458 39m42s others 284 24m41s select 1,251 2h42m43s testes Total 2 480ms select 2 480ms Queries by user
Key values
- intelifix Main user
- 3,603 Requests
User Request type Count Duration etiquetas Total 5 1s459ms select 5 1s459ms intelifix Total 3,603 5h52m23s copy to 403 42m16s ddl 602 41m34s others 526 36m55s select 2,072 3h51m37s lenon Total 93 36s672ms select 93 36s672ms Duration by user
Key values
- 5h52m23s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 5 1s459ms select 5 1s459ms intelifix Total 3,603 5h52m23s copy to 403 42m16s ddl 602 41m34s others 526 36m55s select 2,072 3h51m37s lenon Total 93 36s672ms select 93 36s672ms Queries by host
Key values
- [local] Main host
- 3,701 Requests
- 5h53m1s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 2,564 Requests
- 3h16m2s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-10-08 12:14:48 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,895 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m analyze verbose;[ Date: 2026-10-08 05:09:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 6m38s analyze verbose;[ Date: 2026-10-08 05:15:40 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
3 6m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-08 07:11:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m16s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030864, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-08 07:38:14 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 5m52s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030875, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-08 09:41:03 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 5m50s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030895, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-08 14:32:41 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 5m50s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030891, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-08 11:01:43 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 5m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-08 14:10:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m40s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030890, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-08 10:43:04 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 5m39s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030898, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-08 15:06:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 5m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-08 20:10:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m35s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030869, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-08 08:25:27 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 5m35s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030871, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-08 08:40:04 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 5m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-08 12:10:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-08 21:10:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-08 10:10:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-08 16:10:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-08 11:10:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-08 09:10:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-08 15:10:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h32m29s 48 2s114ms 6m36s 1m55s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 08 07 3 7m6s 2m22s 08 3 5m38s 1m52s 09 3 5m42s 1m54s 10 3 5m47s 1m55s 11 3 5m41s 1m53s 12 3 5m51s 1m57s 13 3 5m31s 1m50s 14 3 6m 2m 15 3 5m37s 1m52s 16 3 5m44s 1m54s 17 3 5m35s 1m51s 18 3 5m28s 1m49s 19 3 5m25s 1m48s 20 3 5m57s 1m59s 21 3 5m45s 1m55s 22 3 5m34s 1m51s [ User: intelifix - Total duration: 1h32m29s - Times executed: 48 ]
[ Application: psql - Total duration: 1h32m29s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-08 07:11:37 Duration: 6m36s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-08 14:10:42 Duration: 5m41s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-08 20:10:40 Duration: 5m39s Database: rio User: intelifix Remote: [local] Application: psql
2 1h2m48s 48 225ms 3m43s 1m18s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 08 07 3 4m41s 1m33s 08 3 3m49s 1m16s 09 3 3m48s 1m16s 10 3 3m59s 1m19s 11 3 3m58s 1m19s 12 3 3m49s 1m16s 13 3 3m51s 1m17s 14 3 4m6s 1m22s 15 3 3m51s 1m17s 16 3 3m53s 1m17s 17 3 3m52s 1m17s 18 3 3m46s 1m15s 19 3 3m40s 1m13s 20 3 3m59s 1m19s 21 3 3m51s 1m17s 22 3 3m46s 1m15s [ User: intelifix - Total duration: 1h2m48s - Times executed: 48 ]
[ Application: psql - Total duration: 1h2m48s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-08 07:16:43 Duration: 3m43s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-08 14:15:05 Duration: 3m34s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-08 11:14:39 Duration: 3m28s Database: brasilia User: intelifix Remote: [local] Application: psql
3 56m19s 193 150ms 6m16s 17s510ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 08 07 14 6m22s 27s348ms 08 21 11m55s 34s92ms 09 15 6m33s 26s246ms 10 28 6m32s 14s23ms 11 16 6m7s 22s986ms 12 4 2s276ms 569ms 13 16 18s7ms 1s125ms 14 19 6m18s 19s931ms 15 26 6m5s 14s39ms 16 16 36s134ms 2s258ms 17 15 5m23s 21s559ms 18 3 3s29ms 1s9ms [ User: intelifix - Total duration: 56m19s - Times executed: 193 ]
[ Application: [unknown] - Total duration: 56m19s - Times executed: 193 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030864, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-08 07:38:14 Duration: 6m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030875, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-08 09:41:03 Duration: 5m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030895, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-08 14:32:41 Duration: 5m50s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 18m16s 3 2m37s 9m 6m5s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 08 05 3 18m16s 6m5s [ User: intelifix - Total duration: 18m16s - Times executed: 3 ]
[ Application: psql - Total duration: 18m16s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-08 05:09:01 Duration: 9m Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-08 05:15:40 Duration: 6m38s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-08 05:18:17 Duration: 2m37s Database: contagem User: intelifix Remote: [local] Application: psql
5 16m34s 87 10s577ms 24s195ms 11s431ms create table temp0000293704 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 08 07 18 3m35s 11s966ms 08 9 1m36s 10s751ms 09 11 2m2s 11s143ms 10 15 2m48s 11s229ms 14 10 1m55s 11s525ms 15 24 4m36s 11s502ms [ User: intelifix - Total duration: 16m34s - Times executed: 87 ]
[ Application: [unknown] - Total duration: 16m34s - Times executed: 87 ]
-
CREATE TABLE temp0000293704 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 07:29:52 Duration: 24s195ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293704 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 10:21:47 Duration: 14s924ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293704 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 15:25:18 Duration: 12s144ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 9m28s 50 10s792ms 12s490ms 11s369ms create table temp0000293762 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 08 15 33 6m19s 11s494ms 16 17 3m9s 11s125ms [ User: intelifix - Total duration: 9m28s - Times executed: 50 ]
[ Application: [unknown] - Total duration: 9m28s - Times executed: 50 ]
-
CREATE TABLE temp0000293762 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 15:18:06 Duration: 12s490ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293762 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 15:52:03 Duration: 12s343ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293762 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 15:48:20 Duration: 12s67ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 7m56s 271 178ms 5s513ms 1s756ms call rs_giga_triagem (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 08 00 12 20s765ms 1s730ms 01 12 16s891ms 1s407ms 02 12 17s217ms 1s434ms 03 12 16s378ms 1s364ms 04 12 16s141ms 1s345ms 05 12 16s587ms 1s382ms 06 12 17s269ms 1s439ms 07 12 18s219ms 1s518ms 08 12 19s369ms 1s614ms 09 12 18s383ms 1s531ms 10 12 17s625ms 1s468ms 11 12 21s153ms 1s762ms 12 12 21s542ms 1s795ms 13 12 22s109ms 1s842ms 14 12 23s472ms 1s956ms 15 11 23s335ms 2s121ms 16 12 24s68ms 2s5ms 17 12 24s409ms 2s34ms 18 11 23s236ms 2s112ms 19 11 23s251ms 2s113ms 20 10 26s662ms 2s666ms 21 12 24s878ms 2s73ms 22 12 23s150ms 1s929ms [ User: intelifix - Total duration: 7m56s - Times executed: 271 ]
[ Application: psql - Total duration: 7m56s - Times executed: 271 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-08 20:05:07 Duration: 5s513ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-08 00:05:19 Duration: 5s228ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-08 20:15:05 Duration: 4s351ms Database: rio User: intelifix Remote: [local] Application: psql
8 4m50s 56 1s305ms 13s384ms 5s179ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 08 07 2 7s972ms 3s986ms 08 3 18s158ms 6s52ms 09 6 33s316ms 5s552ms 10 4 16s951ms 4s237ms 11 8 38s652ms 4s831ms 12 1 3s195ms 3s195ms 13 2 12s477ms 6s238ms 14 7 59s961ms 8s565ms 15 8 50s678ms 6s334ms 16 5 19s242ms 3s848ms 17 9 27s482ms 3s53ms 18 1 1s960ms 1s960ms [ User: intelifix - Total duration: 4m50s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 4m50s - Times executed: 56 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-08', 0320, '', '', 0, 6, '2026-10-01');
Date: 2026-10-08 08:53:21 Duration: 13s384ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-08', 0302, '', '', 0, 6, '2026-10-01');
Date: 2026-10-08 16:39:17 Duration: 10s88ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-08', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-08 15:57:59 Duration: 10s71ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 4m30s 615 150ms 1s681ms 439ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 08 07 14 10s54ms 718ms 08 66 32s120ms 486ms 09 109 48s16ms 440ms 10 105 43s708ms 416ms 11 88 40s478ms 459ms 12 1 514ms 514ms 13 48 18s490ms 385ms 14 48 17s592ms 366ms 15 71 32s644ms 459ms 16 49 18s781ms 383ms 17 14 7s154ms 511ms 18 2 531ms 265ms [ User: intelifix - Total duration: 4m30s - Times executed: 615 ]
[ Application: [unknown] - Total duration: 4m30s - Times executed: 615 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "294482", "modelo" : "463", "itens" : "241792107878,241736535766,241794820726,241793463253,241720429200,241794885456,241757892834,241790002646,241757344161,241754244756,241786236879,241736849815,241753689618,241755813338,241795312547,241723219809,241786957286,241792112627,241786348507,241785779405,241784482242,241736855674,241736781324,241755932340,241786327494,241750114050,241786887683,241792658392,241785778293,241792137679,241790080611,241792092648,241725650002,241755690723,241794799713,241749073758,241704888200,241791787690,241720304867,241794803754,241784424559,241758567478,241779521320,241725631818,241755931431,241723784062,241758625060,241720113838,241750124354,241784515454,241786255467,241755805660,241781980202,241781579297,241784527778,241755816570,241720058805,241721581019,241785976573,241786233546", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-08 07:18:35 Duration: 1s681ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "294482", "modelo" : "463", "itens" : "241748515970,241790134757,241786469001,241705898286,241789955570,241792689911,241790035555,241792257792,241789971633,241725715967,241795311840,241735399909,241781955575,241755964565,241725847293,241781779395,241720100628,241753503236,241755817681,241779532735,241786840003,241754700817,241754636365,241786368384,241755919611,241758646779,241748537487,241786931325,241735458602,241789962642,241725733242,241736817488,241786487184,241737137373,241736805366,241758645769,241706260321,241792101717,241786823435,241720043753,241781567680,241736588802,241791987788,241784520001,241786551333,241753689315,241721574250,241748556479,241736726065,241748411213,241782144965,241754610505,241786161721,241786186470,241720042238,241721560916,241725636464,241723836165,241736773545,241725558702", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-08 07:21:37 Duration: 1s518ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "294630", "modelo" : "463", "itens" : "241791981526,241781976890,241748540216,241723225870,241758107377,241720114040,241721713153,241748560218,241748481220,241758156069,241786165559,241723273956,241755834855,241736692628,241786169397,241751227985,241758312325,241781834351,241756846480,241750022930,241786682232,241722904144,241753889918,241751196770,241755656981,241754702635,241758251231,241725491524,241794742132,241725839313,241750458708,241736533948,241722076678,241757353051,241724808695,241721540207,241722473844,241753730105,241792105656,241786348103,241787273535,241791137795,241704984954,241750015656,241720482842,241755983759,241795012136,241795010217,241792676273,241784496788,241752208800,241786944558,241792033349,241789203342,241784510606", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-08 11:05:14 Duration: 1s515ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 4m29s 144 172ms 13s13ms 1s871ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 08 00 6 18s989ms 3s164ms 01 6 10s212ms 1s702ms 02 5 5s9ms 1s1ms 03 5 8s261ms 1s652ms 04 6 10s275ms 1s712ms 05 5 3s835ms 767ms 07 9 19s248ms 2s138ms 08 12 21s400ms 1s783ms 09 12 27s648ms 2s304ms 10 12 25s502ms 2s125ms 11 12 26s326ms 2s193ms 12 10 14s800ms 1s480ms 13 5 4s417ms 883ms 14 11 14s921ms 1s356ms 15 12 31s705ms 2s642ms 16 5 8s109ms 1s621ms 21 5 8s216ms 1s643ms 22 6 10s613ms 1s768ms [ User: intelifix - Total duration: 4m29s - Times executed: 144 ]
[ Application: psql - Total duration: 4m29s - Times executed: 144 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-08 00:05:14 Duration: 13s13ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-08 09:45:06 Duration: 5s383ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-08 08:05:06 Duration: 4s845ms Database: rio User: intelifix Remote: [local] Application: psql
11 3m14s 428 151ms 2s158ms 453ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 08 07 5 1s883ms 376ms 08 54 28s68ms 519ms 09 78 32s776ms 420ms 10 82 37s811ms 461ms 11 31 17s869ms 576ms 12 11 6s217ms 565ms 13 5 2s881ms 576ms 14 77 32s481ms 421ms 15 51 20s68ms 393ms 16 26 9s93ms 349ms 17 8 5s93ms 636ms [ User: intelifix - Total duration: 3m14s - Times executed: 428 ]
[ Application: [unknown] - Total duration: 3m14s - Times executed: 428 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (294163, 450, 'C492D945636B,ZTE3A8TT7P01413$DC5193D8B5DA,ZTE3A8TQCH02741C7D21EC6897,ZTE3A8TRB722913$B47CA6081C86,ZTE3A8TR8U06905$C492D945639B,ZTE3A8TT7P01425$E44E12B3DB5D,ZTE3A8TR7R23031$E44E12B3DAE9,ZTE3A8TR7R23002$DC5193DA3EDA,ZTE3A8TR1M07493CE,ZTE3A8TT3R20667$B47CA6086736,ZTE3A8TR8U11685$B47CA60823EE,ZTE3A8TR8U07379$B47CA608253A,ZTE3A8TR8U07462$B47CA608265E,ZTE3A8TR8U07535$B47CA6086702,ZTE3A8TR8U11672$B47CA6082512,ZTE3A8TR8U07452A,ZTE3A8TT3R20714A,ZTE3A8TT3306238CA,ZTE3A8TT3303058$B47CA6082EAE,ZTE3A8TR8U08067$E44E1292046F,ZTE3A8TR5U10634$E44E1291F9BB,ZTE3A8TR5U09949$E44E12B040B9,ZTE3A8TR6D14982A,ZTE3A8TT3R20690E,ZTE3A8TT3R20687C7D21EFAD3B,ZTE3A8TRCP25458A,ZTE3A8TT3R22102$DC5193DA52FE,ZTE3A8TR1M08782C7D21EFAD23,ZTE3A8TRCP25452$E44E12AFA605,ZTE3A8TR6D05081D26,ZTE3A8TT4712213C7D21F0E01B,ZTE3A8TRCS19598C7D21EFAC93,ZTE3A8TRCP25416,ZTE3A8TT3R22089$E44E12938F9B,ZTE3A8TR6510425$E44E1291FAE7,ZTE3A8TR5U10024$E44E12938FD7,ZTE3A8TR6510440C7D21EFB033,ZTE3A8TRCS00148C7D21EE9957,ZTE3A8TRCP07801C7D21EFAFDF,ZTE3A8TRCS00127C7D21ED6EB3,ZTE3A8TRCB14188', '',0461,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-08 08:25:49 Duration: 2s158ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (139831, 397, '246042705979', '',0172,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-10-08 09:14:43 Duration: 2s95ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60620, 406, 'ZTE3ANNR4N06006,4896D955E7DC,4896D955E7DD,ZTEGD97F373B$ZTE3ANNRC565937,6C11BA68333D,6C11BA68333E,ZTEGDC6F1750$ZTE3ANNR1Y08413,14CA56CD6FA9,14CA56CD6FAA,ZTEGD9709738$ZTE3ANNT3H66761,D831399CE04E,D831399CE04F,ZTEGDD32D568$ZTE3ANNQ8M44379,843C9922D80D,843C9922D80E,ZTEGD7BAF4C8$ZTE3ANNQ8F08447,689E29FCE8D7,689E29FCE8D8,ZTEGD7BA1DCF$ZTE3ANNT3H45102,D831399AE4AC,D831399AE4AD,ZTEGDD3280CD$ZTE3ANNRC551480,6C11BA66E067,6C11BA66E068,ZTEGDC6EDED7$ZTE3ANNQ8M44477,843C9922DA59,843C9922DA5A,ZTEGD7BAF52A$ZTE3ANNQ4414899,3CF9F0ACBC10,3CF9F0ACBC11,ZTEGD641B4B6$ZTE3ANNR3Y13379,4896D950FA4A,4896D950FA4B,ZTEGD97E64F8$ZTE3ANNR4N06233,4896D955ED2E,4896D955ED2F,ZTEGD97F381E$ZTE3ANNR5W03035,48D6822ECAEC,48D6822ECAED,ZTEGDB000BDA$ZTE3ANNT3H66768,D831399CE078,D831399CE079,ZTEGDD32D56F$ZTE3ANNQ4N02449,3CF9F0A8CB14,3CF9F0A8CB15,ZTEGD6410C8C$ZTE3ANNRC501671,6C11BA625101,6C11BA625102,ZTEGDC6E1C46$ZTE3ANNR3Y59431,4896D95531A2,4896D95531A3,ZTEGD97F18DC$ZTE3ANNR9W45991,D89A0DAC920D,D89A0DAC920E,ZTEGDB16C552$ZTE3ANNQ7L07111,C4EBFF8E2B52,C4EBFF8E2B53,ZTEGD70AD7F9$ZTE3ANNR3J00127,F4E84F86515A,F4E84F86515B,ZTEGD97B6249$ZTE3ANNR7B17077,3891484A7CE5,3891484A7CE6,ZTEGDB07D415$ZTE3ANNT4P64351,F00C51518AD8,F00C51518AD9,ZTEGDE34F1F5', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-08 09:25:06 Duration: 1s811ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
12 2m26s 13 10s907ms 12s88ms 11s281ms create table temp0000293716 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 08 09 11 2m3s 11s242ms 10 2 22s995ms 11s497ms [ User: intelifix - Total duration: 2m26s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m26s - Times executed: 13 ]
-
CREATE TABLE temp0000293716 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 10:06:53 Duration: 12s88ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293716 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 09:47:58 Duration: 11s680ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293716 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 09:46:06 Duration: 11s609ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 2m16s 4 4s375ms 1m5s 34s203ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 08 20 2 1m10s 35s29ms 23 2 1m6s 33s376ms [ User: intelifix - Total duration: 2m16s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m16s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-08 20:08:48 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-08 23:16:38 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-08 20:10:50 Duration: 4s482ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 2m6s 47 226ms 21s222ms 2s696ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 08 07 3 24s947ms 8s315ms 08 4 8s316ms 2s79ms 09 7 28s374ms 4s53ms 10 4 12s173ms 3s43ms 11 1 3s268ms 3s268ms 13 2 1s290ms 645ms 14 3 11s659ms 3s886ms 15 17 31s634ms 1s860ms 16 6 5s84ms 847ms [ User: intelifix - Total duration: 2m6s - Times executed: 47 ]
[ Application: psql - Total duration: 2m6s - Times executed: 47 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030864);
Date: 2026-10-08 07:31:50 Duration: 21s222ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030873);
Date: 2026-10-08 09:16:17 Duration: 9s392ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030879);
Date: 2026-10-08 09:39:46 Duration: 8s801ms Database: rio User: intelifix Remote: [local] Application: psql
15 1m48s 4 338ms 55s484ms 27s201ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 08 20 2 55s827ms 27s913ms 23 2 52s978ms 26s489ms [ User: intelifix - Total duration: 1m48s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-08 20:05:48 Duration: 55s484ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-08 23:13:43 Duration: 52s640ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-08 20:10:14 Duration: 343ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1m48s 6 3s232ms 40s201ms 18s48ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 08 20 3 54s182ms 18s60ms 23 3 54s105ms 18s35ms [ User: intelifix - Total duration: 1m48s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-08 20:06:30 Duration: 40s201ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-08 23:14:25 Duration: 40s47ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-08 23:33:39 Duration: 10s825ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 1m47s 9 10s796ms 14s489ms 11s898ms create table temp0000293686 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 08 08 1 10s796ms 10s796ms 09 2 22s613ms 11s306ms 10 1 11s858ms 11s858ms 11 3 37s786ms 12s595ms 14 2 24s28ms 12s14ms [ User: intelifix - Total duration: 1m47s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 1m47s - Times executed: 9 ]
-
CREATE TABLE temp0000293686 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 11:09:39 Duration: 14s489ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293686 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 14:15:29 Duration: 12s776ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293686 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 10:57:14 Duration: 11s858ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 1m44s 58 577ms 18s455ms 1s800ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 08 08 4 6s886ms 1s721ms 09 3 2s263ms 754ms 10 3 2s197ms 732ms 11 6 17s591ms 2s931ms 12 4 11s969ms 2s992ms 13 3 2s181ms 727ms 14 4 6s961ms 1s740ms 15 3 1s973ms 657ms 16 5 8s776ms 1s755ms 17 4 8s457ms 2s114ms 18 4 23s340ms 5s835ms 19 4 3s126ms 781ms 20 4 3s236ms 809ms 21 3 2s300ms 766ms 22 4 3s173ms 793ms [ User: intelifix - Total duration: 1m44s - Times executed: 58 ]
[ Application: psql - Total duration: 1m44s - Times executed: 58 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-08 18:00:20 Duration: 18s455ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-08 12:00:08 Duration: 6s750ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-08 11:20:07 Duration: 6s93ms Database: rio User: intelifix Remote: [local] Application: psql
19 1m44s 47 1s978ms 2s534ms 2s220ms create table temp0000293704 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 08 07 5 10s228ms 2s45ms 09 11 22s926ms 2s84ms 10 4 8s528ms 2s132ms 14 9 20s357ms 2s261ms 15 18 42s336ms 2s352ms [ User: intelifix - Total duration: 1m44s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 1m44s - Times executed: 47 ]
-
CREATE TABLE temp0000293704 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-10-2026", "ate" :"08-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-08 15:45:07 Duration: 2s534ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293704 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-10-2026", "ate" :"08-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-08 14:39:21 Duration: 2s468ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293704 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"03-10-2026", "ate" :"08-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-08 15:28:16 Duration: 2s463ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 1m34s 30 594ms 11s486ms 3s146ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 08 08 2 11s366ms 5s683ms 09 3 10s24ms 3s341ms 10 3 20s861ms 6s953ms 12 1 816ms 816ms 13 3 5s975ms 1s991ms 14 2 5s449ms 2s724ms 15 3 24s480ms 8s160ms 16 1 2s343ms 2s343ms 17 2 4s392ms 2s196ms 18 1 910ms 910ms 19 2 1s812ms 906ms 20 2 1s927ms 963ms 21 3 2s440ms 813ms 22 2 1s604ms 802ms [ User: intelifix - Total duration: 1m34s - Times executed: 30 ]
[ Application: psql - Total duration: 1m34s - Times executed: 30 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-08 15:20:12 Duration: 11s486ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-08 10:40:10 Duration: 8s485ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-08 08:20:09 Duration: 7s486ms Database: rio User: intelifix Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 615 4m30s 150ms 1s681ms 439ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 08 07 14 10s54ms 718ms 08 66 32s120ms 486ms 09 109 48s16ms 440ms 10 105 43s708ms 416ms 11 88 40s478ms 459ms 12 1 514ms 514ms 13 48 18s490ms 385ms 14 48 17s592ms 366ms 15 71 32s644ms 459ms 16 49 18s781ms 383ms 17 14 7s154ms 511ms 18 2 531ms 265ms [ User: intelifix - Total duration: 4m30s - Times executed: 615 ]
[ Application: [unknown] - Total duration: 4m30s - Times executed: 615 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "294482", "modelo" : "463", "itens" : "241792107878,241736535766,241794820726,241793463253,241720429200,241794885456,241757892834,241790002646,241757344161,241754244756,241786236879,241736849815,241753689618,241755813338,241795312547,241723219809,241786957286,241792112627,241786348507,241785779405,241784482242,241736855674,241736781324,241755932340,241786327494,241750114050,241786887683,241792658392,241785778293,241792137679,241790080611,241792092648,241725650002,241755690723,241794799713,241749073758,241704888200,241791787690,241720304867,241794803754,241784424559,241758567478,241779521320,241725631818,241755931431,241723784062,241758625060,241720113838,241750124354,241784515454,241786255467,241755805660,241781980202,241781579297,241784527778,241755816570,241720058805,241721581019,241785976573,241786233546", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-08 07:18:35 Duration: 1s681ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "294482", "modelo" : "463", "itens" : "241748515970,241790134757,241786469001,241705898286,241789955570,241792689911,241790035555,241792257792,241789971633,241725715967,241795311840,241735399909,241781955575,241755964565,241725847293,241781779395,241720100628,241753503236,241755817681,241779532735,241786840003,241754700817,241754636365,241786368384,241755919611,241758646779,241748537487,241786931325,241735458602,241789962642,241725733242,241736817488,241786487184,241737137373,241736805366,241758645769,241706260321,241792101717,241786823435,241720043753,241781567680,241736588802,241791987788,241784520001,241786551333,241753689315,241721574250,241748556479,241736726065,241748411213,241782144965,241754610505,241786161721,241786186470,241720042238,241721560916,241725636464,241723836165,241736773545,241725558702", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-08 07:21:37 Duration: 1s518ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "294630", "modelo" : "463", "itens" : "241791981526,241781976890,241748540216,241723225870,241758107377,241720114040,241721713153,241748560218,241748481220,241758156069,241786165559,241723273956,241755834855,241736692628,241786169397,241751227985,241758312325,241781834351,241756846480,241750022930,241786682232,241722904144,241753889918,241751196770,241755656981,241754702635,241758251231,241725491524,241794742132,241725839313,241750458708,241736533948,241722076678,241757353051,241724808695,241721540207,241722473844,241753730105,241792105656,241786348103,241787273535,241791137795,241704984954,241750015656,241720482842,241755983759,241795012136,241795010217,241792676273,241784496788,241752208800,241786944558,241792033349,241789203342,241784510606", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-08 11:05:14 Duration: 1s515ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 428 3m14s 151ms 2s158ms 453ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 08 07 5 1s883ms 376ms 08 54 28s68ms 519ms 09 78 32s776ms 420ms 10 82 37s811ms 461ms 11 31 17s869ms 576ms 12 11 6s217ms 565ms 13 5 2s881ms 576ms 14 77 32s481ms 421ms 15 51 20s68ms 393ms 16 26 9s93ms 349ms 17 8 5s93ms 636ms [ User: intelifix - Total duration: 3m14s - Times executed: 428 ]
[ Application: [unknown] - Total duration: 3m14s - Times executed: 428 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (294163, 450, 'C492D945636B,ZTE3A8TT7P01413$DC5193D8B5DA,ZTE3A8TQCH02741C7D21EC6897,ZTE3A8TRB722913$B47CA6081C86,ZTE3A8TR8U06905$C492D945639B,ZTE3A8TT7P01425$E44E12B3DB5D,ZTE3A8TR7R23031$E44E12B3DAE9,ZTE3A8TR7R23002$DC5193DA3EDA,ZTE3A8TR1M07493CE,ZTE3A8TT3R20667$B47CA6086736,ZTE3A8TR8U11685$B47CA60823EE,ZTE3A8TR8U07379$B47CA608253A,ZTE3A8TR8U07462$B47CA608265E,ZTE3A8TR8U07535$B47CA6086702,ZTE3A8TR8U11672$B47CA6082512,ZTE3A8TR8U07452A,ZTE3A8TT3R20714A,ZTE3A8TT3306238CA,ZTE3A8TT3303058$B47CA6082EAE,ZTE3A8TR8U08067$E44E1292046F,ZTE3A8TR5U10634$E44E1291F9BB,ZTE3A8TR5U09949$E44E12B040B9,ZTE3A8TR6D14982A,ZTE3A8TT3R20690E,ZTE3A8TT3R20687C7D21EFAD3B,ZTE3A8TRCP25458A,ZTE3A8TT3R22102$DC5193DA52FE,ZTE3A8TR1M08782C7D21EFAD23,ZTE3A8TRCP25452$E44E12AFA605,ZTE3A8TR6D05081D26,ZTE3A8TT4712213C7D21F0E01B,ZTE3A8TRCS19598C7D21EFAC93,ZTE3A8TRCP25416,ZTE3A8TT3R22089$E44E12938F9B,ZTE3A8TR6510425$E44E1291FAE7,ZTE3A8TR5U10024$E44E12938FD7,ZTE3A8TR6510440C7D21EFB033,ZTE3A8TRCS00148C7D21EE9957,ZTE3A8TRCP07801C7D21EFAFDF,ZTE3A8TRCS00127C7D21ED6EB3,ZTE3A8TRCB14188', '',0461,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-08 08:25:49 Duration: 2s158ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (139831, 397, '246042705979', '',0172,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-10-08 09:14:43 Duration: 2s95ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60620, 406, 'ZTE3ANNR4N06006,4896D955E7DC,4896D955E7DD,ZTEGD97F373B$ZTE3ANNRC565937,6C11BA68333D,6C11BA68333E,ZTEGDC6F1750$ZTE3ANNR1Y08413,14CA56CD6FA9,14CA56CD6FAA,ZTEGD9709738$ZTE3ANNT3H66761,D831399CE04E,D831399CE04F,ZTEGDD32D568$ZTE3ANNQ8M44379,843C9922D80D,843C9922D80E,ZTEGD7BAF4C8$ZTE3ANNQ8F08447,689E29FCE8D7,689E29FCE8D8,ZTEGD7BA1DCF$ZTE3ANNT3H45102,D831399AE4AC,D831399AE4AD,ZTEGDD3280CD$ZTE3ANNRC551480,6C11BA66E067,6C11BA66E068,ZTEGDC6EDED7$ZTE3ANNQ8M44477,843C9922DA59,843C9922DA5A,ZTEGD7BAF52A$ZTE3ANNQ4414899,3CF9F0ACBC10,3CF9F0ACBC11,ZTEGD641B4B6$ZTE3ANNR3Y13379,4896D950FA4A,4896D950FA4B,ZTEGD97E64F8$ZTE3ANNR4N06233,4896D955ED2E,4896D955ED2F,ZTEGD97F381E$ZTE3ANNR5W03035,48D6822ECAEC,48D6822ECAED,ZTEGDB000BDA$ZTE3ANNT3H66768,D831399CE078,D831399CE079,ZTEGDD32D56F$ZTE3ANNQ4N02449,3CF9F0A8CB14,3CF9F0A8CB15,ZTEGD6410C8C$ZTE3ANNRC501671,6C11BA625101,6C11BA625102,ZTEGDC6E1C46$ZTE3ANNR3Y59431,4896D95531A2,4896D95531A3,ZTEGD97F18DC$ZTE3ANNR9W45991,D89A0DAC920D,D89A0DAC920E,ZTEGDB16C552$ZTE3ANNQ7L07111,C4EBFF8E2B52,C4EBFF8E2B53,ZTEGD70AD7F9$ZTE3ANNR3J00127,F4E84F86515A,F4E84F86515B,ZTEGD97B6249$ZTE3ANNR7B17077,3891484A7CE5,3891484A7CE6,ZTEGDB07D415$ZTE3ANNT4P64351,F00C51518AD8,F00C51518AD9,ZTEGDE34F1F5', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-08 09:25:06 Duration: 1s811ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
3 271 7m56s 178ms 5s513ms 1s756ms call rs_giga_triagem (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 08 00 12 20s765ms 1s730ms 01 12 16s891ms 1s407ms 02 12 17s217ms 1s434ms 03 12 16s378ms 1s364ms 04 12 16s141ms 1s345ms 05 12 16s587ms 1s382ms 06 12 17s269ms 1s439ms 07 12 18s219ms 1s518ms 08 12 19s369ms 1s614ms 09 12 18s383ms 1s531ms 10 12 17s625ms 1s468ms 11 12 21s153ms 1s762ms 12 12 21s542ms 1s795ms 13 12 22s109ms 1s842ms 14 12 23s472ms 1s956ms 15 11 23s335ms 2s121ms 16 12 24s68ms 2s5ms 17 12 24s409ms 2s34ms 18 11 23s236ms 2s112ms 19 11 23s251ms 2s113ms 20 10 26s662ms 2s666ms 21 12 24s878ms 2s73ms 22 12 23s150ms 1s929ms [ User: intelifix - Total duration: 7m56s - Times executed: 271 ]
[ Application: psql - Total duration: 7m56s - Times executed: 271 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-08 20:05:07 Duration: 5s513ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-08 00:05:19 Duration: 5s228ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-08 20:15:05 Duration: 4s351ms Database: rio User: intelifix Remote: [local] Application: psql
4 193 56m19s 150ms 6m16s 17s510ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 08 07 14 6m22s 27s348ms 08 21 11m55s 34s92ms 09 15 6m33s 26s246ms 10 28 6m32s 14s23ms 11 16 6m7s 22s986ms 12 4 2s276ms 569ms 13 16 18s7ms 1s125ms 14 19 6m18s 19s931ms 15 26 6m5s 14s39ms 16 16 36s134ms 2s258ms 17 15 5m23s 21s559ms 18 3 3s29ms 1s9ms [ User: intelifix - Total duration: 56m19s - Times executed: 193 ]
[ Application: [unknown] - Total duration: 56m19s - Times executed: 193 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030864, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-08 07:38:14 Duration: 6m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030875, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-08 09:41:03 Duration: 5m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030895, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-08 14:32:41 Duration: 5m50s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 144 4m29s 172ms 13s13ms 1s871ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 08 00 6 18s989ms 3s164ms 01 6 10s212ms 1s702ms 02 5 5s9ms 1s1ms 03 5 8s261ms 1s652ms 04 6 10s275ms 1s712ms 05 5 3s835ms 767ms 07 9 19s248ms 2s138ms 08 12 21s400ms 1s783ms 09 12 27s648ms 2s304ms 10 12 25s502ms 2s125ms 11 12 26s326ms 2s193ms 12 10 14s800ms 1s480ms 13 5 4s417ms 883ms 14 11 14s921ms 1s356ms 15 12 31s705ms 2s642ms 16 5 8s109ms 1s621ms 21 5 8s216ms 1s643ms 22 6 10s613ms 1s768ms [ User: intelifix - Total duration: 4m29s - Times executed: 144 ]
[ Application: psql - Total duration: 4m29s - Times executed: 144 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-08 00:05:14 Duration: 13s13ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-08 09:45:06 Duration: 5s383ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-08 08:05:06 Duration: 4s845ms Database: rio User: intelifix Remote: [local] Application: psql
6 144 1m2s 150ms 1s193ms 431ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 08 08 37 17s989ms 486ms 09 107 44s106ms 412ms [ User: intelifix - Total duration: 1m2s - Times executed: 144 ]
[ Application: [unknown] - Total duration: 1m2s - Times executed: 144 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"60554","seriais":"B0DAF96819DF,2C584F349970,2C9569F5CFC1,BC644BDD1722,B0DAF94FE624,BC644BE16A66,2C584F30520C,F8F532504866,88EF16257DE5,B0DAF965EA2A,5819F8435907,4C12653A6BD8,BC644BD1C46C,B0935BEC1B22,B0935BED6342,BC644BDA902E,4C1265EB8837","usuario":"416","observacao":""}');
Date: 2026-10-08 08:17:41 Duration: 1s193ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"60671","seriais":"229691452435,229737724459,229806759715,229661319404,229753072837,216944695169,229691202534,229737609497,229879559401,229815736180,229865641837,229837162828,229747066773,229736538900,229668753250,229812299616,229735823039,229691751634,216938131319","usuario":"416","observacao":""}');
Date: 2026-10-08 09:17:12 Duration: 1s3ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"60671","seriais":"215662340008","usuario":"416","observacao":""}');
Date: 2026-10-08 09:41:06 Duration: 921ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
7 88 38s965ms 153ms 2s450ms 442ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 08 07 14 7s169ms 512ms 08 16 5s349ms 334ms 10 5 1s232ms 246ms 11 7 3s488ms 498ms 12 3 2s462ms 820ms 13 10 4s737ms 473ms 14 9 2s907ms 323ms 15 9 2s708ms 300ms 16 4 3s567ms 891ms 17 11 5s340ms 485ms [ User: intelifix - Total duration: 38s965ms - Times executed: 88 ]
[ Application: [unknown] - Total duration: 38s965ms - Times executed: 88 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0139950) LIMIT 1;
Date: 2026-10-08 16:29:14 Duration: 2s450ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0294014) LIMIT 1;
Date: 2026-10-08 07:18:59 Duration: 1s983ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0294518) LIMIT 1;
Date: 2026-10-08 13:24:45 Duration: 1s529ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 87 16m34s 10s577ms 24s195ms 11s431ms create table temp0000293704 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 08 07 18 3m35s 11s966ms 08 9 1m36s 10s751ms 09 11 2m2s 11s143ms 10 15 2m48s 11s229ms 14 10 1m55s 11s525ms 15 24 4m36s 11s502ms [ User: intelifix - Total duration: 16m34s - Times executed: 87 ]
[ Application: [unknown] - Total duration: 16m34s - Times executed: 87 ]
-
CREATE TABLE temp0000293704 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 07:29:52 Duration: 24s195ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293704 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 10:21:47 Duration: 14s924ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293704 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 15:25:18 Duration: 12s144ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 85 26s775ms 295ms 403ms 315ms 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 Oct 08 01 2 608ms 304ms 04 1 295ms 295ms 05 3 911ms 303ms 06 1 313ms 313ms 07 7 2s254ms 322ms 08 9 2s855ms 317ms 09 8 2s548ms 318ms 10 9 2s739ms 304ms 11 6 1s897ms 316ms 12 3 942ms 314ms 13 5 1s541ms 308ms 14 9 2s959ms 328ms 15 10 3s167ms 316ms 16 8 2s485ms 310ms 17 4 1s255ms 313ms [ User: lenon - Total duration: 26s775ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 26s775ms - Times executed: 85 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-10-08 09:09:41 Duration: 403ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-10-08 14:37:25 Duration: 368ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-10-08 14:13:46 Duration: 363ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
10 82 23s629ms 253ms 464ms 288ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 08 07 2 590ms 295ms 08 6 1s620ms 270ms 09 12 3s451ms 287ms 10 13 3s721ms 286ms 11 3 853ms 284ms 13 5 1s434ms 286ms 14 6 1s880ms 313ms 15 16 4s563ms 285ms 16 14 3s878ms 277ms 17 2 757ms 378ms 18 3 878ms 292ms [ User: intelifix - Total duration: 23s629ms - Times executed: 82 ]
[ Application: [unknown] - Total duration: 23s629ms - Times executed: 82 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 054;
Date: 2026-10-08 17:43:46 Duration: 464ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-10-08 14:15:03 Duration: 451ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-10-08 15:58:36 Duration: 379ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
11 72 26s537ms 329ms 452ms 368ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 08 01 1 377ms 377ms 04 1 353ms 353ms 05 3 1s36ms 345ms 07 5 1s927ms 385ms 08 7 2s666ms 380ms 09 7 2s569ms 367ms 10 7 2s444ms 349ms 11 6 2s240ms 373ms 12 3 1s128ms 376ms 13 4 1s457ms 364ms 14 8 3s57ms 382ms 15 9 3s279ms 364ms 16 7 2s547ms 363ms 17 4 1s449ms 362ms [ User: intelifix - Total duration: 26s537ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 26s537ms - Times executed: 72 ]
-
select * from rs_menu_grants (398, 72, 1);
Date: 2026-10-08 08:21:44 Duration: 452ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (476, 19, 1);
Date: 2026-10-08 14:37:25 Duration: 447ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (399, 18, 1);
Date: 2026-10-08 09:09:41 Duration: 436ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
12 58 1m44s 577ms 18s455ms 1s800ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 08 08 4 6s886ms 1s721ms 09 3 2s263ms 754ms 10 3 2s197ms 732ms 11 6 17s591ms 2s931ms 12 4 11s969ms 2s992ms 13 3 2s181ms 727ms 14 4 6s961ms 1s740ms 15 3 1s973ms 657ms 16 5 8s776ms 1s755ms 17 4 8s457ms 2s114ms 18 4 23s340ms 5s835ms 19 4 3s126ms 781ms 20 4 3s236ms 809ms 21 3 2s300ms 766ms 22 4 3s173ms 793ms [ User: intelifix - Total duration: 1m44s - Times executed: 58 ]
[ Application: psql - Total duration: 1m44s - Times executed: 58 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-08 18:00:20 Duration: 18s455ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-08 12:00:08 Duration: 6s750ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-08 11:20:07 Duration: 6s93ms Database: rio User: intelifix Remote: [local] Application: psql
13 56 4m50s 1s305ms 13s384ms 5s179ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 08 07 2 7s972ms 3s986ms 08 3 18s158ms 6s52ms 09 6 33s316ms 5s552ms 10 4 16s951ms 4s237ms 11 8 38s652ms 4s831ms 12 1 3s195ms 3s195ms 13 2 12s477ms 6s238ms 14 7 59s961ms 8s565ms 15 8 50s678ms 6s334ms 16 5 19s242ms 3s848ms 17 9 27s482ms 3s53ms 18 1 1s960ms 1s960ms [ User: intelifix - Total duration: 4m50s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 4m50s - Times executed: 56 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-08', 0320, '', '', 0, 6, '2026-10-01');
Date: 2026-10-08 08:53:21 Duration: 13s384ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-08', 0302, '', '', 0, 6, '2026-10-01');
Date: 2026-10-08 16:39:17 Duration: 10s88ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-08', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-08 15:57:59 Duration: 10s71ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 53 14s796ms 151ms 536ms 279ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 08 09 3 697ms 232ms 10 21 5s616ms 267ms 11 17 4s993ms 293ms 14 12 3s489ms 290ms [ User: intelifix - Total duration: 14s796ms - Times executed: 53 ]
[ Application: [unknown] - Total duration: 14s796ms - Times executed: 53 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '142004591F3A,7C7D21EEDAD7,14200455D0F2,14200454D08E,7C7D21EC0DB3,142004541B6E,14200455D3AE,E44E1291C477,E44E12933FDB,38165A47BCA0,7C7D21F1F2F7,E44E12B1C6F9,7C7D21F0F4EB,7C7D21F11293,14200452EE9A,14200457942A,14200454E5A6,7C7D21F003C3,7C7D21EEDA73', '','DEFAULT',09,0329,'', '','', 00);
Date: 2026-10-08 11:19:19 Duration: 536ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '229788554156,229726163948,229791848810,229797036779,229790791120,229820542542,229804571623,229768483140,229797225159,229769250825,229789198292,229805163151,229857820827,229797209905,229844010826,229772599804,229768516274,229725462634,229725295468,229820344767,229844636475,229867341217,229770427897,229802813348,229820029102,229819875271,229772490120,229917020308,229770985359,229796936567,229795895770,229877608706,229770404966,229725170709,229789152228,229788958594,229848974755,229725264859,229797242838,229802345165,229772528305,229796583346,229805173556,229768548803,229851325265,229817716878,229770869613,229858582730', '','DEFAULT',056,0145,'', '','', 00);
Date: 2026-10-08 14:11:19 Duration: 524ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'D83139A0618A,14CA56CE4143,843C992C395D,3891484CD8B1,843C991EE0F9,3CF9F0AB0B08,3CF9F0A4C284,4896D9568C16,843C99201125,F4E84F8755D6,D89A0D84D9E3,3891484ACD73,843C9935FD0B,3CF9F0AE10AE,14CA56D552FD,843C992E5899,D831398FB71E,F4E84F888818,843C9932A19D,48D68230DB04', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-10-08 11:54:49 Duration: 513ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
15 50 9m28s 10s792ms 12s490ms 11s369ms create table temp0000293762 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 08 15 33 6m19s 11s494ms 16 17 3m9s 11s125ms [ User: intelifix - Total duration: 9m28s - Times executed: 50 ]
[ Application: [unknown] - Total duration: 9m28s - Times executed: 50 ]
-
CREATE TABLE temp0000293762 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 15:18:06 Duration: 12s490ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293762 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 15:52:03 Duration: 12s343ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293762 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 15:48:20 Duration: 12s67ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 48 1h32m29s 2s114ms 6m36s 1m55s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 08 07 3 7m6s 2m22s 08 3 5m38s 1m52s 09 3 5m42s 1m54s 10 3 5m47s 1m55s 11 3 5m41s 1m53s 12 3 5m51s 1m57s 13 3 5m31s 1m50s 14 3 6m 2m 15 3 5m37s 1m52s 16 3 5m44s 1m54s 17 3 5m35s 1m51s 18 3 5m28s 1m49s 19 3 5m25s 1m48s 20 3 5m57s 1m59s 21 3 5m45s 1m55s 22 3 5m34s 1m51s [ User: intelifix - Total duration: 1h32m29s - Times executed: 48 ]
[ Application: psql - Total duration: 1h32m29s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-08 07:11:37 Duration: 6m36s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-08 14:10:42 Duration: 5m41s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-08 20:10:40 Duration: 5m39s Database: rio User: intelifix Remote: [local] Application: psql
17 48 1h2m48s 225ms 3m43s 1m18s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 08 07 3 4m41s 1m33s 08 3 3m49s 1m16s 09 3 3m48s 1m16s 10 3 3m59s 1m19s 11 3 3m58s 1m19s 12 3 3m49s 1m16s 13 3 3m51s 1m17s 14 3 4m6s 1m22s 15 3 3m51s 1m17s 16 3 3m53s 1m17s 17 3 3m52s 1m17s 18 3 3m46s 1m15s 19 3 3m40s 1m13s 20 3 3m59s 1m19s 21 3 3m51s 1m17s 22 3 3m46s 1m15s [ User: intelifix - Total duration: 1h2m48s - Times executed: 48 ]
[ Application: psql - Total duration: 1h2m48s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-08 07:16:43 Duration: 3m43s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-08 14:15:05 Duration: 3m34s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-08 11:14:39 Duration: 3m28s Database: brasilia User: intelifix Remote: [local] Application: psql
18 47 2m6s 226ms 21s222ms 2s696ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 08 07 3 24s947ms 8s315ms 08 4 8s316ms 2s79ms 09 7 28s374ms 4s53ms 10 4 12s173ms 3s43ms 11 1 3s268ms 3s268ms 13 2 1s290ms 645ms 14 3 11s659ms 3s886ms 15 17 31s634ms 1s860ms 16 6 5s84ms 847ms [ User: intelifix - Total duration: 2m6s - Times executed: 47 ]
[ Application: psql - Total duration: 2m6s - Times executed: 47 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030864);
Date: 2026-10-08 07:31:50 Duration: 21s222ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030873);
Date: 2026-10-08 09:16:17 Duration: 9s392ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030879);
Date: 2026-10-08 09:39:46 Duration: 8s801ms Database: rio User: intelifix Remote: [local] Application: psql
19 47 1m44s 1s978ms 2s534ms 2s220ms create table temp0000293704 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 08 07 5 10s228ms 2s45ms 09 11 22s926ms 2s84ms 10 4 8s528ms 2s132ms 14 9 20s357ms 2s261ms 15 18 42s336ms 2s352ms [ User: intelifix - Total duration: 1m44s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 1m44s - Times executed: 47 ]
-
CREATE TABLE temp0000293704 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-10-2026", "ate" :"08-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-08 15:45:07 Duration: 2s534ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293704 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-10-2026", "ate" :"08-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-08 14:39:21 Duration: 2s468ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293704 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"03-10-2026", "ate" :"08-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-08 15:28:16 Duration: 2s463ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 37 1m27s 2s185ms 2s832ms 2s363ms create table temp0000293762 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 08 15 28 1m6s 2s362ms 16 9 21s288ms 2s365ms [ User: intelifix - Total duration: 1m27s - Times executed: 37 ]
[ Application: [unknown] - Total duration: 1m27s - Times executed: 37 ]
-
CREATE TABLE temp0000293762 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"03-10-2026", "ate" :"08-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-08 15:42:03 Duration: 2s832ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293762 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-10-2026", "ate" :"08-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-08 16:09:52 Duration: 2s707ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293762 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"03-10-2026", "ate" :"08-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-08 15:35:04 Duration: 2s620ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m37s 9m 6m5s 3 18m16s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 08 05 3 18m16s 6m5s [ User: intelifix - Total duration: 18m16s - Times executed: 3 ]
[ Application: psql - Total duration: 18m16s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-08 05:09:01 Duration: 9m Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-08 05:15:40 Duration: 6m38s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-08 05:18:17 Duration: 2m37s Database: contagem User: intelifix Remote: [local] Application: psql
2 2s114ms 6m36s 1m55s 48 1h32m29s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 08 07 3 7m6s 2m22s 08 3 5m38s 1m52s 09 3 5m42s 1m54s 10 3 5m47s 1m55s 11 3 5m41s 1m53s 12 3 5m51s 1m57s 13 3 5m31s 1m50s 14 3 6m 2m 15 3 5m37s 1m52s 16 3 5m44s 1m54s 17 3 5m35s 1m51s 18 3 5m28s 1m49s 19 3 5m25s 1m48s 20 3 5m57s 1m59s 21 3 5m45s 1m55s 22 3 5m34s 1m51s [ User: intelifix - Total duration: 1h32m29s - Times executed: 48 ]
[ Application: psql - Total duration: 1h32m29s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-08 07:11:37 Duration: 6m36s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-08 14:10:42 Duration: 5m41s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-08 20:10:40 Duration: 5m39s Database: rio User: intelifix Remote: [local] Application: psql
3 225ms 3m43s 1m18s 48 1h2m48s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 08 07 3 4m41s 1m33s 08 3 3m49s 1m16s 09 3 3m48s 1m16s 10 3 3m59s 1m19s 11 3 3m58s 1m19s 12 3 3m49s 1m16s 13 3 3m51s 1m17s 14 3 4m6s 1m22s 15 3 3m51s 1m17s 16 3 3m53s 1m17s 17 3 3m52s 1m17s 18 3 3m46s 1m15s 19 3 3m40s 1m13s 20 3 3m59s 1m19s 21 3 3m51s 1m17s 22 3 3m46s 1m15s [ User: intelifix - Total duration: 1h2m48s - Times executed: 48 ]
[ Application: psql - Total duration: 1h2m48s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-08 07:16:43 Duration: 3m43s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-08 14:15:05 Duration: 3m34s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-08 11:14:39 Duration: 3m28s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s375ms 1m5s 34s203ms 4 2m16s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 08 20 2 1m10s 35s29ms 23 2 1m6s 33s376ms [ User: intelifix - Total duration: 2m16s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m16s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-08 20:08:48 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-08 23:16:38 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-08 20:10:50 Duration: 4s482ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 338ms 55s484ms 27s201ms 4 1m48s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 08 20 2 55s827ms 27s913ms 23 2 52s978ms 26s489ms [ User: intelifix - Total duration: 1m48s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-08 20:05:48 Duration: 55s484ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-08 23:13:43 Duration: 52s640ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-08 20:10:14 Duration: 343ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 3s232ms 40s201ms 18s48ms 6 1m48s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 08 20 3 54s182ms 18s60ms 23 3 54s105ms 18s35ms [ User: intelifix - Total duration: 1m48s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-08 20:06:30 Duration: 40s201ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-08 23:14:25 Duration: 40s47ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-08 23:33:39 Duration: 10s825ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 150ms 6m16s 17s510ms 193 56m19s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 08 07 14 6m22s 27s348ms 08 21 11m55s 34s92ms 09 15 6m33s 26s246ms 10 28 6m32s 14s23ms 11 16 6m7s 22s986ms 12 4 2s276ms 569ms 13 16 18s7ms 1s125ms 14 19 6m18s 19s931ms 15 26 6m5s 14s39ms 16 16 36s134ms 2s258ms 17 15 5m23s 21s559ms 18 3 3s29ms 1s9ms [ User: intelifix - Total duration: 56m19s - Times executed: 193 ]
[ Application: [unknown] - Total duration: 56m19s - Times executed: 193 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030864, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-08 07:38:14 Duration: 6m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030875, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-08 09:41:03 Duration: 5m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030895, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-08 14:32:41 Duration: 5m50s Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10s796ms 14s489ms 11s898ms 9 1m47s create table temp0000293686 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 08 08 1 10s796ms 10s796ms 09 2 22s613ms 11s306ms 10 1 11s858ms 11s858ms 11 3 37s786ms 12s595ms 14 2 24s28ms 12s14ms [ User: intelifix - Total duration: 1m47s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 1m47s - Times executed: 9 ]
-
CREATE TABLE temp0000293686 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 11:09:39 Duration: 14s489ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293686 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 14:15:29 Duration: 12s776ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293686 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 10:57:14 Duration: 11s858ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s577ms 24s195ms 11s431ms 87 16m34s create table temp0000293704 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 08 07 18 3m35s 11s966ms 08 9 1m36s 10s751ms 09 11 2m2s 11s143ms 10 15 2m48s 11s229ms 14 10 1m55s 11s525ms 15 24 4m36s 11s502ms [ User: intelifix - Total duration: 16m34s - Times executed: 87 ]
[ Application: [unknown] - Total duration: 16m34s - Times executed: 87 ]
-
CREATE TABLE temp0000293704 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 07:29:52 Duration: 24s195ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293704 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 10:21:47 Duration: 14s924ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293704 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 15:25:18 Duration: 12s144ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s792ms 12s490ms 11s369ms 50 9m28s create table temp0000293762 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 08 15 33 6m19s 11s494ms 16 17 3m9s 11s125ms [ User: intelifix - Total duration: 9m28s - Times executed: 50 ]
[ Application: [unknown] - Total duration: 9m28s - Times executed: 50 ]
-
CREATE TABLE temp0000293762 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 15:18:06 Duration: 12s490ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293762 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 15:52:03 Duration: 12s343ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293762 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 15:48:20 Duration: 12s67ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s907ms 12s88ms 11s281ms 13 2m26s create table temp0000293716 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 08 09 11 2m3s 11s242ms 10 2 22s995ms 11s497ms [ User: intelifix - Total duration: 2m26s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m26s - Times executed: 13 ]
-
CREATE TABLE temp0000293716 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 10:06:53 Duration: 12s88ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293716 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 09:47:58 Duration: 11s680ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293716 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-08 09:46:06 Duration: 11s609ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 1s305ms 13s384ms 5s179ms 56 4m50s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 08 07 2 7s972ms 3s986ms 08 3 18s158ms 6s52ms 09 6 33s316ms 5s552ms 10 4 16s951ms 4s237ms 11 8 38s652ms 4s831ms 12 1 3s195ms 3s195ms 13 2 12s477ms 6s238ms 14 7 59s961ms 8s565ms 15 8 50s678ms 6s334ms 16 5 19s242ms 3s848ms 17 9 27s482ms 3s53ms 18 1 1s960ms 1s960ms [ User: intelifix - Total duration: 4m50s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 4m50s - Times executed: 56 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-08', 0320, '', '', 0, 6, '2026-10-01');
Date: 2026-10-08 08:53:21 Duration: 13s384ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-08', 0302, '', '', 0, 6, '2026-10-01');
Date: 2026-10-08 16:39:17 Duration: 10s88ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-08', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-08 15:57:59 Duration: 10s71ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 594ms 11s486ms 3s146ms 30 1m34s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 08 08 2 11s366ms 5s683ms 09 3 10s24ms 3s341ms 10 3 20s861ms 6s953ms 12 1 816ms 816ms 13 3 5s975ms 1s991ms 14 2 5s449ms 2s724ms 15 3 24s480ms 8s160ms 16 1 2s343ms 2s343ms 17 2 4s392ms 2s196ms 18 1 910ms 910ms 19 2 1s812ms 906ms 20 2 1s927ms 963ms 21 3 2s440ms 813ms 22 2 1s604ms 802ms [ User: intelifix - Total duration: 1m34s - Times executed: 30 ]
[ Application: psql - Total duration: 1m34s - Times executed: 30 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-08 15:20:12 Duration: 11s486ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-08 10:40:10 Duration: 8s485ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-08 08:20:09 Duration: 7s486ms Database: rio User: intelifix Remote: [local] Application: psql
14 226ms 21s222ms 2s696ms 47 2m6s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 08 07 3 24s947ms 8s315ms 08 4 8s316ms 2s79ms 09 7 28s374ms 4s53ms 10 4 12s173ms 3s43ms 11 1 3s268ms 3s268ms 13 2 1s290ms 645ms 14 3 11s659ms 3s886ms 15 17 31s634ms 1s860ms 16 6 5s84ms 847ms [ User: intelifix - Total duration: 2m6s - Times executed: 47 ]
[ Application: psql - Total duration: 2m6s - Times executed: 47 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030864);
Date: 2026-10-08 07:31:50 Duration: 21s222ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030873);
Date: 2026-10-08 09:16:17 Duration: 9s392ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030879);
Date: 2026-10-08 09:39:46 Duration: 8s801ms Database: rio User: intelifix Remote: [local] Application: psql
15 2s185ms 2s832ms 2s363ms 37 1m27s create table temp0000293762 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 08 15 28 1m6s 2s362ms 16 9 21s288ms 2s365ms [ User: intelifix - Total duration: 1m27s - Times executed: 37 ]
[ Application: [unknown] - Total duration: 1m27s - Times executed: 37 ]
-
CREATE TABLE temp0000293762 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"03-10-2026", "ate" :"08-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-08 15:42:03 Duration: 2s832ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293762 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-10-2026", "ate" :"08-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-08 16:09:52 Duration: 2s707ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293762 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"03-10-2026", "ate" :"08-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-08 15:35:04 Duration: 2s620ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 1s978ms 2s534ms 2s220ms 47 1m44s create table temp0000293704 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 08 07 5 10s228ms 2s45ms 09 11 22s926ms 2s84ms 10 4 8s528ms 2s132ms 14 9 20s357ms 2s261ms 15 18 42s336ms 2s352ms [ User: intelifix - Total duration: 1m44s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 1m44s - Times executed: 47 ]
-
CREATE TABLE temp0000293704 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-10-2026", "ate" :"08-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-08 15:45:07 Duration: 2s534ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293704 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-10-2026", "ate" :"08-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-08 14:39:21 Duration: 2s468ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293704 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"03-10-2026", "ate" :"08-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-08 15:28:16 Duration: 2s463ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 172ms 13s13ms 1s871ms 144 4m29s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 08 00 6 18s989ms 3s164ms 01 6 10s212ms 1s702ms 02 5 5s9ms 1s1ms 03 5 8s261ms 1s652ms 04 6 10s275ms 1s712ms 05 5 3s835ms 767ms 07 9 19s248ms 2s138ms 08 12 21s400ms 1s783ms 09 12 27s648ms 2s304ms 10 12 25s502ms 2s125ms 11 12 26s326ms 2s193ms 12 10 14s800ms 1s480ms 13 5 4s417ms 883ms 14 11 14s921ms 1s356ms 15 12 31s705ms 2s642ms 16 5 8s109ms 1s621ms 21 5 8s216ms 1s643ms 22 6 10s613ms 1s768ms [ User: intelifix - Total duration: 4m29s - Times executed: 144 ]
[ Application: psql - Total duration: 4m29s - Times executed: 144 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-08 00:05:14 Duration: 13s13ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-08 09:45:06 Duration: 5s383ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-08 08:05:06 Duration: 4s845ms Database: rio User: intelifix Remote: [local] Application: psql
18 577ms 18s455ms 1s800ms 58 1m44s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 08 08 4 6s886ms 1s721ms 09 3 2s263ms 754ms 10 3 2s197ms 732ms 11 6 17s591ms 2s931ms 12 4 11s969ms 2s992ms 13 3 2s181ms 727ms 14 4 6s961ms 1s740ms 15 3 1s973ms 657ms 16 5 8s776ms 1s755ms 17 4 8s457ms 2s114ms 18 4 23s340ms 5s835ms 19 4 3s126ms 781ms 20 4 3s236ms 809ms 21 3 2s300ms 766ms 22 4 3s173ms 793ms [ User: intelifix - Total duration: 1m44s - Times executed: 58 ]
[ Application: psql - Total duration: 1m44s - Times executed: 58 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-08 18:00:20 Duration: 18s455ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-08 12:00:08 Duration: 6s750ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-08 11:20:07 Duration: 6s93ms Database: rio User: intelifix Remote: [local] Application: psql
19 178ms 5s513ms 1s756ms 271 7m56s call rs_giga_triagem (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 08 00 12 20s765ms 1s730ms 01 12 16s891ms 1s407ms 02 12 17s217ms 1s434ms 03 12 16s378ms 1s364ms 04 12 16s141ms 1s345ms 05 12 16s587ms 1s382ms 06 12 17s269ms 1s439ms 07 12 18s219ms 1s518ms 08 12 19s369ms 1s614ms 09 12 18s383ms 1s531ms 10 12 17s625ms 1s468ms 11 12 21s153ms 1s762ms 12 12 21s542ms 1s795ms 13 12 22s109ms 1s842ms 14 12 23s472ms 1s956ms 15 11 23s335ms 2s121ms 16 12 24s68ms 2s5ms 17 12 24s409ms 2s34ms 18 11 23s236ms 2s112ms 19 11 23s251ms 2s113ms 20 10 26s662ms 2s666ms 21 12 24s878ms 2s73ms 22 12 23s150ms 1s929ms [ User: intelifix - Total duration: 7m56s - Times executed: 271 ]
[ Application: psql - Total duration: 7m56s - Times executed: 271 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-08 20:05:07 Duration: 5s513ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-08 00:05:19 Duration: 5s228ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-08 20:15:05 Duration: 4s351ms Database: rio User: intelifix Remote: [local] Application: psql
20 151ms 2s158ms 453ms 428 3m14s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 08 07 5 1s883ms 376ms 08 54 28s68ms 519ms 09 78 32s776ms 420ms 10 82 37s811ms 461ms 11 31 17s869ms 576ms 12 11 6s217ms 565ms 13 5 2s881ms 576ms 14 77 32s481ms 421ms 15 51 20s68ms 393ms 16 26 9s93ms 349ms 17 8 5s93ms 636ms [ User: intelifix - Total duration: 3m14s - Times executed: 428 ]
[ Application: [unknown] - Total duration: 3m14s - Times executed: 428 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (294163, 450, 'C492D945636B,ZTE3A8TT7P01413$DC5193D8B5DA,ZTE3A8TQCH02741C7D21EC6897,ZTE3A8TRB722913$B47CA6081C86,ZTE3A8TR8U06905$C492D945639B,ZTE3A8TT7P01425$E44E12B3DB5D,ZTE3A8TR7R23031$E44E12B3DAE9,ZTE3A8TR7R23002$DC5193DA3EDA,ZTE3A8TR1M07493CE,ZTE3A8TT3R20667$B47CA6086736,ZTE3A8TR8U11685$B47CA60823EE,ZTE3A8TR8U07379$B47CA608253A,ZTE3A8TR8U07462$B47CA608265E,ZTE3A8TR8U07535$B47CA6086702,ZTE3A8TR8U11672$B47CA6082512,ZTE3A8TR8U07452A,ZTE3A8TT3R20714A,ZTE3A8TT3306238CA,ZTE3A8TT3303058$B47CA6082EAE,ZTE3A8TR8U08067$E44E1292046F,ZTE3A8TR5U10634$E44E1291F9BB,ZTE3A8TR5U09949$E44E12B040B9,ZTE3A8TR6D14982A,ZTE3A8TT3R20690E,ZTE3A8TT3R20687C7D21EFAD3B,ZTE3A8TRCP25458A,ZTE3A8TT3R22102$DC5193DA52FE,ZTE3A8TR1M08782C7D21EFAD23,ZTE3A8TRCP25452$E44E12AFA605,ZTE3A8TR6D05081D26,ZTE3A8TT4712213C7D21F0E01B,ZTE3A8TRCS19598C7D21EFAC93,ZTE3A8TRCP25416,ZTE3A8TT3R22089$E44E12938F9B,ZTE3A8TR6510425$E44E1291FAE7,ZTE3A8TR5U10024$E44E12938FD7,ZTE3A8TR6510440C7D21EFB033,ZTE3A8TRCS00148C7D21EE9957,ZTE3A8TRCP07801C7D21EFAFDF,ZTE3A8TRCS00127C7D21ED6EB3,ZTE3A8TRCB14188', '',0461,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-08 08:25:49 Duration: 2s158ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (139831, 397, '246042705979', '',0172,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-10-08 09:14:43 Duration: 2s95ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (60620, 406, 'ZTE3ANNR4N06006,4896D955E7DC,4896D955E7DD,ZTEGD97F373B$ZTE3ANNRC565937,6C11BA68333D,6C11BA68333E,ZTEGDC6F1750$ZTE3ANNR1Y08413,14CA56CD6FA9,14CA56CD6FAA,ZTEGD9709738$ZTE3ANNT3H66761,D831399CE04E,D831399CE04F,ZTEGDD32D568$ZTE3ANNQ8M44379,843C9922D80D,843C9922D80E,ZTEGD7BAF4C8$ZTE3ANNQ8F08447,689E29FCE8D7,689E29FCE8D8,ZTEGD7BA1DCF$ZTE3ANNT3H45102,D831399AE4AC,D831399AE4AD,ZTEGDD3280CD$ZTE3ANNRC551480,6C11BA66E067,6C11BA66E068,ZTEGDC6EDED7$ZTE3ANNQ8M44477,843C9922DA59,843C9922DA5A,ZTEGD7BAF52A$ZTE3ANNQ4414899,3CF9F0ACBC10,3CF9F0ACBC11,ZTEGD641B4B6$ZTE3ANNR3Y13379,4896D950FA4A,4896D950FA4B,ZTEGD97E64F8$ZTE3ANNR4N06233,4896D955ED2E,4896D955ED2F,ZTEGD97F381E$ZTE3ANNR5W03035,48D6822ECAEC,48D6822ECAED,ZTEGDB000BDA$ZTE3ANNT3H66768,D831399CE078,D831399CE079,ZTEGDD32D56F$ZTE3ANNQ4N02449,3CF9F0A8CB14,3CF9F0A8CB15,ZTEGD6410C8C$ZTE3ANNRC501671,6C11BA625101,6C11BA625102,ZTEGDC6E1C46$ZTE3ANNR3Y59431,4896D95531A2,4896D95531A3,ZTEGD97F18DC$ZTE3ANNR9W45991,D89A0DAC920D,D89A0DAC920E,ZTEGDB16C552$ZTE3ANNQ7L07111,C4EBFF8E2B52,C4EBFF8E2B53,ZTEGD70AD7F9$ZTE3ANNR3J00127,F4E84F86515A,F4E84F86515B,ZTEGD97B6249$ZTE3ANNR7B17077,3891484A7CE5,3891484A7CE6,ZTEGDB07D415$ZTE3ANNT4P64351,F00C51518AD8,F00C51518AD9,ZTEGDE34F1F5', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-08 09:25:06 Duration: 1s811ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 10 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Oct 08 11 1 0ms 0ms 12 1 0ms 0ms 14 2 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 18 1 0ms 0ms 19 2 0ms 0ms 20 1 0ms 0ms [ User: intelifix - Total duration: 5m27s - Times executed: 9 ]
[ User: lenon - Total duration: 368ms - Times executed: 1 ]
[ Application: psql - Total duration: 5m25s - Times executed: 5 ]
[ Application: [unknown] - Total duration: 2s150ms - Times executed: 5 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 11,488 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 31 FATAL entries
- 2309 ERROR entries
- 0 WARNING entries
- 4 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2,288 Max number of times the same event was reported
- 2,344 Total events found
Rank Times reported Error 1 2,288 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 08 07 167 08 220 09 369 10 308 11 289 12 104 13 67 14 222 15 320 16 178 17 42 18 2 - ERROR: prepared statement "_PLAN000000003229E040" does not exist
- ERROR: prepared statement "_PLAN0000000047081AA0" does not exist
- ERROR: prepared statement "_PLAN0000000033F583B0" does not exist
Statement: DEALLOCATE "_PLAN000000003229E040"
Date: 2026-10-08 07:18:09 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000047081AA0"
Date: 2026-10-08 07:19:25 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000033F583B0"
Date: 2026-10-08 07:19:40 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 19 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 08 02 1 05 3 06 1 08 1 09 1 12 4 13 2 15 1 19 4 23 1 - FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-10-08 02:14:01 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-08 05:35:59 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-08 05:36:15 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
3 8 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 08 03 8 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-10-08 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-10-08 03:05:01 Database: testes Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL expression "'RS_PARAMETRO'" PL/pgSQL function rs_parametro(character varying) line 15 during statement block local variable initialization PL/pgSQL function rs_giga_tecnicos() line 16 during statement block local variable initialization
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-10-08 03:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
4 7 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 08 10 2 11 2 15 1 16 2 - ERROR: syntax error at or near "]" at character 35
- ERROR: syntax error at or near "]" at character 35
- ERROR: syntax error at or near "]" at character 34
Statement: select * from rs_caixa_qr(3778668 ])
Date: 2026-10-08 10:59:50 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(3778668 ]) /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn( /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn( /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn( /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Date: 2026-10-08 10:59:50 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(406387 ])
Date: 2026-10-08 11:19:23 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
5 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 08 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-08 05:32:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-08 05:32:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-08 05:32:02 Database: contagem Application: psql User: intelifix Remote: [local]
6 3 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 08 10 1 15 1 16 1 - LOG: process 477189 still waiting for AccessExclusiveLock on relation 5862499 of database 358220 after 1000.119 ms
- LOG: process 673905 still waiting for AccessExclusiveLock on relation 5876700 of database 358220 after 1000.069 ms
- LOG: process 673919 still waiting for AccessExclusiveLock on relation 5885094 of database 358220 after 1000.127 ms
Detail: Process holding the lock: 505166. Wait queue: 477189.
Statement: DROP TABLE IF EXISTS temp0000293704;Date: 2026-10-08 10:55:37 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 682492. Wait queue: 673905.
Statement: DROP TABLE IF EXISTS temp0000293704;Date: 2026-10-08 15:52:39 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 699190. Wait queue: 673919.
Statement: DROP TABLE IF EXISTS temp0000293762;Date: 2026-10-08 16:16:39 Database: rio Application: [unknown] User: intelifix Remote: [local]
7 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #7
Day Hour Count Oct 08 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-10-08 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-08 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-08 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
8 3 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #8
Day Hour Count Oct 08 07 3 - ERROR: trailing junk after numeric literal at or near "83350053091282D" at character 27
- ERROR: trailing junk after numeric literal at or near "83350053091282D" at character 27
- ERROR: trailing junk after numeric literal at or near "83350053091282D" at character 27
Statement: SELECT * FROM RS_ETIQUETA(83350053091282D)
Date: 2026-10-08 07:59:26 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(83350053091282D)
Date: 2026-10-08 07:59:26 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(83350053091282D)
Date: 2026-10-08 07:59:27 Database: rio Application: [unknown] User: etiquetas Remote: [local]
9 3 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #9
Day Hour Count Oct 08 10 1 15 1 16 1 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000293704"
Date: 2026-10-08 10:55:37
Context: automatic vacuum of table "rio.public.temp0000293704"
Date: 2026-10-08 15:52:39
Context: automatic vacuum of table "rio.public.temp0000293762"
Date: 2026-10-08 16:16:39
10 2 ERROR: function rs_lote_manutencao_itens(...) does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Oct 08 15 2 - ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
- ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(140058,399,'14020485850083303620,C85D38779826$14311585850103309129,D86C5A519600$14011885850079503343,C85D385D4CCB$14032285850086702659,C85D389A9241$14317085850104102827,D86C5A677BBA$14113485850095605092,C85D38F12B04$14026885850084810780,C85D388F7375$14102585850089301685,C85D38E50B3D$14008385850078204857,C85D380901D0$14011885850079501313,C85D385CA645','',0151,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$','',08538779826);Date: 2026-10-08 15:03:32 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(140058,399,'14011885850079501313,C85D385CA645$14032285850086702659,C85D389A9241$14317085850104102827,D86C5A677BBA$14011885850079503343,C85D385D4CCB$14113485850095605092,C85D38F12B04$14102585850089301685,C85D38E50B3D$14311585850103303820,D86C5A4FE27F$14018885850082702212,C85D387591E0','',0151,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$','',08538779826);Date: 2026-10-08 15:06:34 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
11 2 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count Oct 08 09 2 - ERROR: column "f4e84f868070" does not exist at character 27
- ERROR: column "f4e84f868070" does not exist at character 27
Statement: select * from rs_caixa_qr(F4E84F868070)
Date: 2026-10-08 09:27:07 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(F4E84F868070)
Date: 2026-10-08 09:27:07 Database: rio Application: [unknown] User: etiquetas Remote: [local]
12 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #12
Day Hour Count Oct 08 03 1 - LOG: database system was shut down at 2026-10-08 03:05:01 -03
Date: 2026-10-08 03:05:01
13 1 FATAL: database "..." does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Times Reported Most Frequent Error / Event #13
Day Hour Count Oct 08 19 1 - FATAL: database "jaboatao" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Date: 2026-10-08 19:59:56 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]