pgBadger-
Global information
- Generated on Tue Oct 13 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 34,159 log entries in 9s
- Log start from 2026-10-13 00:02:02 to 2026-10-13 23:45:23
-
Overview
Global Stats
- 347 Number of unique normalized queries
- 4,550 Number of queries
- 7h4m7s Total query duration
- 2026-10-13 00:02:07 First query
- 2026-10-13 23:42:54 Last query
- 5 queries/s at 2026-10-13 23:42:32 Query peak
- 7h4m7s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h4m7s Execute total duration
- 3,351 Number of events
- 12 Number of unique normalized events
- 3,268 Max number of times the same event was reported
- 0 Number of cancellation
- 382 Total number of automatic vacuums
- 866 Total number of automatic analyzes
- 22 Number temporary file
- 250.15 MiB Max size of temporary file
- 71.33 MiB Average size of temporary file
- 337 Total number of sessions
- 9 sessions at 2026-10-13 01:05:02 Session peak
- 12d10h30m18s Total duration of sessions
- 53m8s Average duration of sessions
- 13 Average queries per session
- 1m15s Average queries duration per session
- 51m53s Average idle time per session
- 357 Total number of connections
- 4 connections/s at 2026-10-13 03:05:17 Connection peak
- 4 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-13 23:42:32 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-13 15:24:56 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-13 23:42:32 Date
Queries duration
Key values
- 7h4m7s 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 13 00 23 0ms 18s297ms 3s816ms 1m1s 1m1s 1m1s 01 12 0ms 2s746ms 1s398ms 2s852ms 2s934ms 2s934ms 02 12 0ms 2s811ms 1s420ms 3s46ms 3s46ms 3s46ms 03 12 0ms 2s673ms 1s355ms 2s765ms 2s934ms 2s934ms 04 12 0ms 2s533ms 1s334ms 2s708ms 2s708ms 2s708ms 05 18 0ms 10m10s 1m14s 2m50s 7m6s 10m10s 06 22 0ms 10s703ms 2s365ms 9s616ms 27s916ms 27s916ms 07 107 0ms 9m53s 19s742ms 1m18s 5m42s 9m53s 08 275 0ms 5m43s 5s62ms 31s260ms 3m34s 6m17s 09 380 0ms 5m52s 5s939ms 1m31s 5m51s 5m59s 10 355 0ms 6m6s 4s600ms 51s436ms 3m45s 6m31s 11 383 0ms 5m45s 4s821ms 37s465ms 5m43s 5m55s 12 133 0ms 5m16s 6s543ms 36s674ms 57s819ms 5m46s 13 332 0ms 5m9s 3s607ms 42s296ms 1m10s 5m55s 14 404 150ms 5m43s 3s588ms 40s808ms 3m35s 6m12s 15 514 0ms 5m50s 5s90ms 1m59s 5m44s 6m39s 16 484 151ms 5m53s 3s771ms 51s880ms 1m44s 12m22s 17 439 150ms 5m22s 2s398ms 29s805ms 41s634ms 5m57s 18 104 0ms 5m15s 7s149ms 17s804ms 3m30s 5m46s 19 40 0ms 5m14s 14s764ms 3s418ms 3m24s 5m57s 20 113 0ms 5m25s 10s360ms 1m15s 3m28s 6m22s 21 26 0ms 5m14s 22s522ms 3m23s 5m43s 5m43s 22 24 0ms 5m6s 24s439ms 3m34s 5m49s 5m49s 23 326 0ms 1m2s 6s19ms 1m5s 1m14s 1m15s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 13 00 4 0 2s802ms 0ms 11s210ms 11s210ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 7 0 1s535ms 0ms 1s135ms 9s616ms 07 64 0 29s543ms 2s178ms 1m1s 7m41s 08 201 0 5s522ms 5s458ms 8s648ms 5m43s 09 282 0 6s967ms 18s736ms 1m17s 5m54s 10 296 0 4s736ms 12s826ms 29s516ms 6m8s 11 308 0 4s900ms 6s675ms 18s110ms 5m48s 12 84 0 8s573ms 1s474ms 13s756ms 3m31s 13 238 0 3s891ms 7s36ms 26s225ms 3m36s 14 323 0 3s967ms 7s202ms 36s932ms 5m48s 15 365 0 5s649ms 12s925ms 1m24s 5m53s 16 335 0 3s981ms 5s896ms 13s655ms 3m35s 17 340 0 2s396ms 7s397ms 12s978ms 3m34s 18 60 0 10s511ms 4s869ms 12s774ms 5m44s 19 21 0 26s993ms 443ms 1s625ms 5m57s 20 12 80 12s372ms 1m4s 1m11s 5m26s 21 8 0 1m10s 759ms 3m23s 5m43s 22 6 0 1m34s 0ms 3m34s 5m49s 23 5 321 6s19ms 1m3s 1m5s 1m15s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 13 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 13 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 1 1.00 0.00% 07 0 11 11.00 0.00% 08 0 12 12.00 0.00% 09 0 11 11.00 0.00% 10 0 12 12.00 0.00% 11 0 12 12.00 0.00% 12 0 4 4.00 0.00% 13 0 9 9.00 0.00% 14 0 13 13.00 0.00% 15 0 9 9.00 0.00% 16 0 10 10.00 0.00% 17 0 10 10.00 0.00% 18 0 2 2.00 0.00% 19 0 1 1.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 13 00 16 0.00/s 01 6 0.00/s 02 5 0.00/s 03 16 0.00/s 04 5 0.00/s 05 12 0.00/s 06 16 0.00/s 07 15 0.00/s 08 20 0.01/s 09 19 0.01/s 10 21 0.01/s 11 22 0.01/s 12 19 0.01/s 13 19 0.01/s 14 22 0.01/s 15 26 0.01/s 16 22 0.01/s 17 19 0.01/s 18 12 0.00/s 19 10 0.00/s 20 12 0.00/s 21 6 0.00/s 22 9 0.00/s 23 8 0.00/s Day Hour Count Average Duration Average idle time Oct 13 00 2 1h 59m16s 01 16 1h2m47s 1h2m46s 02 6 1h 59m57s 03 10 21m51s 21m49s 04 6 1h30s 1h27s 05 5 1h35s 56m5s 06 8 57m37s 57m30s 07 14 58m24s 55m53s 08 17 51m26s 50m4s 09 17 56m19s 54m6s 10 19 55m21s 53m55s 11 21 54m24s 52m56s 12 22 48m59s 48m19s 13 14 58m23s 56m58s 14 21 52m9s 51m 15 26 47m39s 45m58s 16 22 58m18s 56m56s 17 22 54m46s 53m58s 18 19 55m47s 55m8s 19 10 56m52s 55m53s 20 11 45m15s 43m29s 21 8 1h39s 59m26s 22 8 56m15s 55m2s 23 13 35m4s 32m33s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-10-13 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 357 connections Total
Connections per user
Key values
- intelifix Main User
- 357 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2026-10-13 01:05:02 Date
Histogram of session times
Key values
- 273 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 337 sessions Total
Sessions per user
Key values
- intelifix Main User
- 337 sessions Total
Sessions per host
Key values
- [local] Main Host
- 337 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 13,050 buffers Checkpoint Peak
- 2026-10-13 09:54:39 Date
- 270.048 seconds Highest write time
- 0.106 seconds Sync time
Checkpoints Wal files
Key values
- 10 files Wal files usage Peak
- 2026-10-13 09:54:39 Date
Checkpoints distance
Key values
- 328.36 Mo Distance Peak
- 2026-10-13 09:54:39 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Oct 13 00 6,787 269.727s 0.002s 269.733s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 8,932 0.195s 0.058s 0.26s 04 0 0s 0s 0s 05 6,931 693.655s 0.032s 693.705s 06 3,795 379.866s 0.004s 379.876s 07 21,700 1,714.349s 0.055s 1,714.437s 08 25,369 2,175.454s 0.084s 2,175.59s 09 49,332 2,923.877s 0.124s 2,924.073s 10 51,654 2,912.292s 0.167s 2,912.53s 11 48,636 3,239.512s 0.122s 3,239.701s 12 20,441 1,642.331s 0.055s 1,642.439s 13 22,450 2,395.564s 0.091s 2,395.713s 14 44,100 3,205.884s 0.123s 3,206.078s 15 49,305 3,193.529s 0.247s 3,193.862s 16 34,275 3,160.246s 0.145s 3,160.477s 17 27,444 2,833.299s 0.088s 2,833.458s 18 6,827 1,010.234s 0.045s 1,010.32s 19 625 62.713s 0.02s 62.752s 20 861 103.12s 0.009s 103.137s 21 1,327 132.83s 0.014s 132.858s 22 26 2.623s 0.004s 2.63s 23 317 32.8s 0.008s 32.818s Day Hour Added Removed Recycled Synced files Longest sync Average sync Oct 13 00 0 0 2 33 0.001s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 3 26 0.056s 0.004s 04 0 0 0 0 0s 0s 05 0 0 3 144 0.021s 0.008s 06 0 0 1 32 0.001s 0.002s 07 0 0 12 1,824 0.002s 0.011s 08 0 0 19 4,171 0.003s 0.012s 09 0 0 35 5,166 0.004s 0.012s 10 0 0 27 5,605 0.007s 0.012s 11 0 0 36 6,266 0.002s 0.012s 12 0 0 14 2,766 0.003s 0.012s 13 0 0 22 5,685 0.002s 0.012s 14 0 0 24 6,497 0.003s 0.012s 15 0 0 56 6,972 0.081s 0.012s 16 0 0 44 6,851 0.003s 0.012s 17 0 0 25 6,053 0.002s 0.012s 18 0 0 10 1,526 0.002s 0.012s 19 0 0 0 337 0.004s 0.009s 20 0 0 1 83 0.002s 0.003s 21 0 0 0 100 0.003s 0.004s 22 0 0 0 6 0.002s 0.002s 23 0 0 0 26 0.003s 0.005s Day Hour Count Avg time (sec) Oct 13 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 13 00 38,270.00 kB 38,270.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 27,615.50 kB 27,615.50 kB 04 0.00 kB 0.00 kB 05 6,925.57 kB 9,816.29 kB 06 7,141.00 kB 10,726.00 kB 07 18,146.45 kB 35,831.09 kB 08 26,118.83 kB 72,127.17 kB 09 46,569.17 kB 93,448.25 kB 10 37,719.50 kB 102,662.75 kB 11 49,056.42 kB 91,599.33 kB 12 18,684.17 kB 90,186.08 kB 13 30,826.50 kB 78,447.83 kB 14 32,048.50 kB 64,789.67 kB 15 76,614.42 kB 121,430.42 kB 16 60,566.17 kB 107,174.50 kB 17 33,631.58 kB 85,445.75 kB 18 13,955.50 kB 50,251.00 kB 19 361.22 kB 17,742.56 kB 20 3,612.00 kB 10,044.33 kB 21 1,279.00 kB 7,405.25 kB 22 99.00 kB 5,535.50 kB 23 173.75 kB 4,108.75 kB -
Temporary Files
Size of temporary files
Key values
- 500.30 MiB Temp Files size Peak
- 2026-10-13 05:31:57 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-10-13 05:32:02 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 13 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 68.07 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 1 104.00 MiB 104.00 MiB 10 1 104.00 MiB 104.00 MiB 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 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.03 GiB 37.31 MiB 250.15 MiB 65.66 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-13 05:32:05 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-13 05:31:57 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 310.75 MiB 57.75 MiB 95.05 MiB 77.69 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-13 05:30:41 Duration: 39s518ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-13 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 2 207.99 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031037, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-13 07:33:22 Duration: 7m41s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031048, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-13 10:51:32 Duration: 6m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031085, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-13 16:10:51 Duration: 5m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 250.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-13 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 250.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-13 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-10-13 10:37:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-10-13 09:45:33 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 95.05 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-13 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 95.05 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-13 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 62.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-13 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 57.75 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-13 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 41.35 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-13 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 41.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-13 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 41.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-13 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 41.28 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-13 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 41.28 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-13 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 41.28 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-13 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 41.28 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-13 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 37.37 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-13 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 37.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-13 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 37.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-13 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 37.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-13 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 37.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-13 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 11.63 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_10
Database rio - 2026-10-13 15:34:51 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 11.63 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_10
Database rio - 2026-10-13 15:34:51 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (105) Main table analyzed (database rio)
- 866 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 105 rio.pg_catalog.pg_class 54 rio.public.usuarios 53 rio.public.temp0000294006 43 rio.public.temp0000294014 43 rio.pg_catalog.pg_type 43 brasilia.pg_catalog.pg_attribute 40 rio.public.temp0000293954 33 rio.public.temp0000294016 30 rio.pg_catalog.pg_index 28 contagem.pg_catalog.pg_attribute 26 rio.public.temp0000293702 24 rio.public.temp0000294042 24 brasilia.pg_catalog.pg_class 22 contagem.public.usuarios 19 rio.pg_catalog.pg_depend 19 brasilia.pg_catalog.pg_type 17 rio.public.temp0000292754 17 contagem.pg_catalog.pg_class 15 rio.public.temp0000293950 12 brasilia.pg_catalog.pg_index 12 contagem.pg_catalog.pg_type 12 rio.public.temp0000293952 11 brasilia.public.temp0000242080 10 rio.public.temp0000293846 9 brasilia.pg_catalog.pg_depend 8 brasilia.public.usuarios 8 contagem.pg_catalog.pg_index 8 rio.public.temp0000293998 7 brasilia.public.temp0000242010 7 rio.public.temp0000293986 7 rio.public.temp0000293940 6 brasilia.public.temp0000242056 6 brasilia.public.temp0000242016 6 contagem.pg_catalog.pg_depend 5 rio.public.temp0000293964 5 brasilia.public.temp0000242022 4 brasilia.public.temp0000242038 4 rio.public.tmp_drill_0175 4 brasilia.public.temp0000242008 3 brasilia.public.temp0000242020 3 rio.public.tmp_drill_0320 3 brasilia.public.nf_entrada 3 postgres.pg_catalog.pg_shdepend 3 rio.public.temp0000292986 2 rio.public.temp0000293996 2 brasilia.public.temp0000242096 2 rio.public.temp0000294004 2 brasilia.public.temp0000242058 2 testes.pg_catalog.pg_shdepend 2 contagem.public.temp0000227514 2 brasilia.pg_catalog.pg_shdepend 2 rio.public.temp0000294044 1 rio.public.temp0000294022 1 rio.public.temp0000294026 1 rio.public.temp0000293976 1 rio.public.temp0000293982 1 brasilia.public.temp0000242072 1 contagem.public.temp0000227508 1 brasilia.public.temp0000242024 1 brasilia.public.temp0000242094 1 brasilia.public.temp0000242018 1 rio.public.temp0000294050 1 contagem.public.temp0000227518 1 brasilia.public.temp0000242036 1 contagem.public.temp0000227512 1 rio.public.temp0000293962 1 brasilia.public.temp0000242066 1 rio.pg_catalog.pg_shdepend 1 brasilia.public.temp0000242088 1 rio.public.temp0000293720 1 contagem.public.nf_entrada 1 brasilia.public.temp0000242006 1 rio.public.temp0000293930 1 brasilia.public.temp0000242014 1 brasilia.public.temp0000242048 1 rio.public.tmp_drill_0302 1 template1.pg_catalog.pg_shdepend 1 rio.public.temp0000294028 1 brasilia.public.temp0000242078 1 rio.public.temp0000293994 1 Total 866 Vacuums per table
Key values
- pg_catalog.pg_attribute (32) Main table vacuumed on database rio
- 382 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 32 32 0 0 0 0 0 18,205 5,123 8,128,939 196 4,625 rio.public.temp0000294006 30 0 0 0 0 0 0 9,082 308 820,415 0 0 rio.public.temp0000294016 28 0 0 0 0 0 0 1,695 296 385,805 0 0 rio.public.temp0000293702 21 0 0 0 0 0 0 1,003 115 78,284 0 0 rio.public.temp0000293954 18 0 0 0 0 0 0 29,782 5,642 8,982,829 0 0 contagem.public.usuarios 18 0 0 0 0 0 0 87 67 37,185 0 0 rio.pg_catalog.pg_class 17 17 0 0 0 0 0 3,237 1,145 1,804,215 65 241 rio.public.temp0000294014 17 0 0 0 0 0 0 28,029 1,929 4,071,373 0 0 rio.public.temp0000294042 16 0 0 0 0 0 0 1,140 327 514,761 0 0 rio.public.temp0000292754 14 0 0 0 0 0 0 796 79 58,573 0 0 rio.pg_catalog.pg_type 14 14 0 0 0 0 0 1,428 450 702,229 30 84 brasilia.pg_catalog.pg_attribute 13 13 0 0 0 0 0 8,068 1,861 3,204,613 84 1,851 rio.pg_catalog.pg_index 10 10 0 0 0 0 0 500 152 186,250 24 62 contagem.pg_catalog.pg_attribute 9 9 0 0 0 0 0 6,710 1,529 2,926,719 11 262 rio.pg_catalog.pg_depend 9 9 0 0 0 0 0 2,567 838 1,595,440 44 324 brasilia.pg_catalog.pg_class 9 9 0 0 0 0 0 2,092 473 835,961 20 78 rio.public.tmp_drill_0175 8 3 0 0 0 0 0 514 11 102,301 0 0 rio.public.temp0000293986 7 0 0 0 0 0 0 11,171 1,884 3,068,103 0 0 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 9,377 2,835 11,780,396 1,652 8,102 rio.public.usuarios 7 6 0 0 0 0 0 199 60 132,618 16 28 rio.public.temp0000293998 7 0 0 0 0 0 0 11,170 27 663,186 0 0 brasilia.pg_catalog.pg_type 6 6 0 0 0 0 0 706 149 276,931 18 60 brasilia.pg_catalog.pg_index 6 6 0 0 0 0 0 298 59 74,482 2 6 testes.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 1,318 496 1,087,246 44 64 contagem.pg_catalog.pg_class 5 5 0 0 0 0 0 1,146 238 386,432 8 20 contagem.pg_catalog.pg_type 4 4 0 0 0 0 0 490 93 155,537 3 6 brasilia.public.temp0000242016 4 0 0 0 0 0 0 1,036 16 63,536 0 0 brasilia.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,546 486 900,175 8 99 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,905 511 2,673,354 176 598 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,440 1,085 4,439,010 761 4,659 rio.public.tmp_drill_0320 3 3 0 0 0 0 0 1,539 9 260,796 0 0 rio.public.temp0000293846 3 0 0 0 0 0 0 109 17 8,827 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 337 79 365,371 36 93 contagem.public.temp0000227514 2 0 0 0 0 0 0 238 12 16,000 0 0 brasilia.public.temp0000242058 2 0 0 0 0 0 0 518 8 31,768 0 0 contagem.pg_catalog.pg_index 2 2 0 0 0 0 0 207 44 50,942 1 1 rio.public.temp0000292986 2 0 0 0 0 0 0 74 11 6,003 0 0 contagem.pg_catalog.pg_depend 2 2 0 0 0 0 0 926 188 407,597 3 23 brasilia.auditor.auditor_2026_10 1 0 0 0 0 0 0 13,366 11,538 15,118,086 894 19,214 rio.public.tmp_drill_0302 1 1 0 0 0 0 0 31 3 6,341 0 0 brasilia.public.temp0000242010 1 0 0 0 0 0 0 259 4 15,884 0 0 brasilia.public.temp0000242078 1 0 0 0 0 0 0 259 4 15,884 0 0 brasilia.public.nf_entrada 1 1 0 0 0 0 0 235 122 251,869 10 14 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,272 900 2,799,851 868 6,219 contagem.auditor.auditor_2026_10 1 0 0 0 0 0 0 8,623 6,278 8,602,940 1,161 34,567 rio.auditor.auditor_2026_10 1 0 0 0 0 0 0 89,404 35,445 47,690,699 26,793 556,109 brasilia.public.temp0000242094 1 0 0 0 0 0 0 260 4 15,943 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 131 31 88,333 12 29 rio.public.temp0000293996 1 0 0 0 0 0 0 50 6 3,784 0 0 brasilia.public.nf_entrada_arquivo_erros 1 1 0 0 0 0 0 2,428 1,620 4,008,028 13 608 rio.public.logs 1 0 0 0 0 0 0 10,907 10,617 12,864,093 136 3,294 Total 382 179 0 0 0 0 0 291,910 95,224 152,765,937 33,089 641,340 Vacuum throughput per table
Key values
- auditor.auditor_2026_10 (11.63) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 2.3 rio.public.temp0000294006 0 0 0.25 rio.public.temp0000294016 0 0 0.06 rio.public.temp0000293702 0 0 0.04 rio.public.temp0000293954 0 0 1.26 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_class 0 0 0.59 rio.public.temp0000294014 0 0 0.8 rio.public.temp0000294042 0 0 0.18 rio.public.temp0000292754 0 0 0.02 rio.pg_catalog.pg_type 0 0 0.18 brasilia.pg_catalog.pg_attribute 0 0 0.94 rio.pg_catalog.pg_index 0 0 0.22 contagem.pg_catalog.pg_attribute 0 0 0.9 rio.pg_catalog.pg_depend 0 0 0.58 brasilia.pg_catalog.pg_class 0 0 0.31 rio.public.tmp_drill_0175 0 0 0 rio.public.temp0000293986 0 0 0.34 rio.pg_catalog.pg_statistic 0 0 1.32 rio.public.usuarios 0 0 0 rio.public.temp0000293998 0 0 0.32 brasilia.pg_catalog.pg_type 0 0 0.1 brasilia.pg_catalog.pg_index 0 0 0.19 testes.pg_catalog.pg_shdepend 0 0 0.64 contagem.pg_catalog.pg_class 0 0 0.21 contagem.pg_catalog.pg_type 0 0 0.12 brasilia.public.temp0000242016 0 0 0 brasilia.pg_catalog.pg_depend 0 0 0.66 rio.pg_toast.pg_toast_2619 0 0 0.26 brasilia.pg_catalog.pg_statistic 0 0 0.62 rio.public.tmp_drill_0320 0 0 0.04 rio.public.temp0000293846 0 0 0 brasilia.pg_toast.pg_toast_2619 0 0 0.03 contagem.public.temp0000227514 0 0 0.01 brasilia.public.temp0000242058 0 0 0 contagem.pg_catalog.pg_index 0 0 0.14 rio.public.temp0000292986 0 0 0 contagem.pg_catalog.pg_depend 0 0 0.29 brasilia.auditor.auditor_2026_10 0 0 3.87 rio.public.tmp_drill_0302 0 0 0 brasilia.public.temp0000242010 0 0 0 brasilia.public.temp0000242078 0 0 0 brasilia.public.nf_entrada 0 0 0.07 contagem.pg_catalog.pg_statistic 0 0 0.08 contagem.auditor.auditor_2026_10 0 0 1.94 rio.auditor.auditor_2026_10 0 0 11.63 brasilia.public.temp0000242094 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000293996 0 0 0 brasilia.public.nf_entrada_arquivo_erros 0 0 1.1 rio.public.logs 0 0 3.46 Total 0 0 36.07 Tuples removed per table
Key values
- pg_catalog.pg_attribute (122309) Main table with removed tuples on database rio
- 335693 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 32 32 122,309 749,995 2,507 81 18,072 brasilia.pg_catalog.pg_attribute 13 13 70,131 295,543 0 253 7,364 contagem.pg_catalog.pg_attribute 9 9 48,510 238,009 34 540 5,568 rio.public.tmp_drill_0320 3 3 22,134 23,170 0 0 587 rio.pg_catalog.pg_statistic 7 7 12,739 58,901 0 0 9,002 brasilia.pg_catalog.pg_statistic 3 3 6,416 23,702 0 0 3,213 rio.pg_catalog.pg_depend 9 9 6,123 170,268 12 0 1,692 rio.auditor.auditor_2026_10 1 0 5,089 6,422,467 0 0 306,699 testes.pg_catalog.pg_shdepend 5 5 4,537 90,105 6 0 755 contagem.pg_catalog.pg_statistic 1 1 4,258 7,274 0 0 1,011 rio.pg_catalog.pg_type 14 14 4,000 31,546 2 0 1,022 brasilia.pg_catalog.pg_type 6 6 3,858 13,346 0 29 398 brasilia.pg_catalog.pg_class 9 9 3,676 33,956 0 51 1,286 brasilia.pg_catalog.pg_depend 4 4 3,084 73,030 0 19 684 contagem.pg_catalog.pg_type 4 4 2,986 10,093 2 70 298 rio.public.tmp_drill_0175 8 3 2,895 41,581 16,950 0 642 rio.pg_catalog.pg_class 17 17 2,742 60,572 116 23 2,115 rio.pg_catalog.pg_index 10 10 1,983 19,127 9 9 509 brasilia.pg_catalog.pg_index 6 6 1,848 11,656 354 25 293 contagem.pg_catalog.pg_index 2 2 1,334 3,795 1 28 120 contagem.public.usuarios 18 0 1,117 432 0 0 36 rio.pg_toast.pg_toast_2619 3 3 983 2,355 0 0 786 brasilia.public.nf_entrada 1 1 823 4,509 0 0 152 rio.public.usuarios 7 6 707 4,063 500 0 133 contagem.pg_catalog.pg_class 5 5 593 19,338 4 9 1,095 contagem.pg_catalog.pg_depend 2 2 474 41,530 6 53 391 brasilia.pg_toast.pg_toast_2619 2 2 183 271 0 10 108 contagem.pg_toast.pg_toast_2619 1 1 98 119 0 0 52 brasilia.public.nf_entrada_arquivo_erros 1 1 63 1,761,458 0 0 32,223 rio.public.temp0000292754 14 0 0 37,660 0 436 844 brasilia.auditor.auditor_2026_10 1 0 0 1,872,357 0 0 79,705 rio.public.tmp_drill_0302 1 1 0 315 0 0 9 brasilia.public.temp0000242010 1 0 0 3,401 0 0 256 brasilia.public.temp0000242016 4 0 0 13,610 0 0 1,024 rio.public.temp0000293986 7 0 0 185,115 0 0 13,440 brasilia.public.temp0000242078 1 0 0 3,405 0 0 256 contagem.public.temp0000227514 2 0 0 2,832 0 34 222 brasilia.public.temp0000242058 2 0 0 6,807 0 0 512 contagem.auditor.auditor_2026_10 1 0 0 1,341,941 0 0 56,124 rio.public.temp0000293846 3 0 0 5,449 0 71 121 brasilia.public.temp0000242094 1 0 0 3,407 0 0 256 rio.public.temp0000293954 18 0 0 476,006 0 0 34,368 rio.public.temp0000292986 2 0 0 5,210 0 11 117 rio.public.temp0000293996 1 0 0 1,892 0 22 42 rio.public.temp0000293998 7 0 0 185,152 0 0 13,440 rio.public.temp0000294014 17 0 0 426,977 0 52 30,796 rio.public.temp0000294042 16 0 0 101,568 0 699 4,933 rio.public.temp0000293702 21 0 0 60,339 0 755 1,357 rio.public.temp0000294016 28 0 0 83,687 0 868 1,884 rio.public.logs 1 0 0 16,870,649 0 0 674,136 rio.public.temp0000294006 30 0 0 177,442 0 761 9,287 Total 382 179 335,693 32,077,432 20,503 4,909 1,319,435 Pages removed per table
Key values
- public.temp0000294016 (868) Main table with removed pages on database rio
- 4909 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000294016 28 0 0 868 rio.public.temp0000294006 30 0 0 761 rio.public.temp0000293702 21 0 0 755 rio.public.temp0000294042 16 0 0 699 contagem.pg_catalog.pg_attribute 9 9 48510 540 rio.public.temp0000292754 14 0 0 436 brasilia.pg_catalog.pg_attribute 13 13 70131 253 rio.pg_catalog.pg_attribute 32 32 122309 81 rio.public.temp0000293846 3 0 0 71 contagem.pg_catalog.pg_type 4 4 2986 70 contagem.pg_catalog.pg_depend 2 2 474 53 rio.public.temp0000294014 17 0 0 52 brasilia.pg_catalog.pg_class 9 9 3676 51 contagem.public.temp0000227514 2 0 0 34 brasilia.pg_catalog.pg_type 6 6 3858 29 contagem.pg_catalog.pg_index 2 2 1334 28 brasilia.pg_catalog.pg_index 6 6 1848 25 rio.pg_catalog.pg_class 17 17 2742 23 rio.public.temp0000293996 1 0 0 22 brasilia.pg_catalog.pg_depend 4 4 3084 19 rio.public.temp0000292986 2 0 0 11 brasilia.pg_toast.pg_toast_2619 2 2 183 10 contagem.pg_catalog.pg_class 5 5 593 9 rio.pg_catalog.pg_index 10 10 1983 9 brasilia.auditor.auditor_2026_10 1 0 0 0 rio.public.tmp_drill_0302 1 1 0 0 brasilia.public.temp0000242010 1 0 0 0 brasilia.public.temp0000242016 4 0 0 0 rio.public.temp0000293986 7 0 0 0 brasilia.public.temp0000242078 1 0 0 0 rio.pg_catalog.pg_statistic 7 7 12739 0 brasilia.public.nf_entrada 1 1 823 0 rio.public.usuarios 7 6 707 0 rio.pg_toast.pg_toast_2619 3 3 983 0 brasilia.pg_catalog.pg_statistic 3 3 6416 0 contagem.pg_catalog.pg_statistic 1 1 4258 0 testes.pg_catalog.pg_shdepend 5 5 4537 0 rio.public.tmp_drill_0320 3 3 22134 0 rio.pg_catalog.pg_depend 9 9 6123 0 brasilia.public.temp0000242058 2 0 0 0 rio.public.tmp_drill_0175 8 3 2895 0 contagem.auditor.auditor_2026_10 1 0 0 0 rio.pg_catalog.pg_type 14 14 4000 0 rio.auditor.auditor_2026_10 1 0 5089 0 brasilia.public.temp0000242094 1 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 98 0 rio.public.temp0000293954 18 0 0 0 rio.public.temp0000293998 7 0 0 0 contagem.public.usuarios 18 0 1117 0 brasilia.public.nf_entrada_arquivo_erros 1 1 63 0 rio.public.logs 1 0 0 0 Total 382 179 335,693 4,909 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 13 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 6 13 08 13 57 09 38 81 10 25 62 11 36 81 12 11 24 13 32 69 14 37 94 15 59 121 16 49 118 17 44 109 18 20 28 19 0 4 20 0 0 21 6 5 22 0 0 23 0 0 - 11.63 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 2 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 37s89ms 37s89ms 37s89ms 37s89ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (295397, 184, 'CP2526LV3VP,B85E710FF270', '',0185,00,'[{"item":"0","qrcode":""}]','', '', 00);
Date: 2026-10-13 16:10:51 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (61747, 406, '835237935002890,241708772642,241700840712,241605397479,241700838488,241650797084,241593391112,241676686468,241676855677,241704248484,241708950718,241659737788,241663101316,241700853238,241713821833,241620863344,241698312934,241646273153,241593782340,241708951829,241703970524,241703986181,241652334956,241635931212,241729899305,241676816380,241698716587,241671533452,241704731720,241599251931,241650802742,241704231335,241708951324,241708775369,241695645973,241698704465,241668278094,241708763348,241650796175,241727063136,241664862341,241695643852,241698666178,241676852849,241669969820,241714040822,241630115369,241659738091', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-13 15:16:21 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (61754, 406, 'ZTE3ANNR8C33325,389148519415,389148519416,ZTEGDB09029D$ZTE3ANNR8C26556,38914850F56F,38914850F570,ZTEGDB08E82C$ZTE3ANNRCB66345,D8313923E1F4,D8313923E1F5,ZTEGDD2AB8BE$ZTE3ANNQCA12290,14CA56D364E7,14CA56D364E8,ZTEGD971956D$ZTE3ANNT3H64111,D831399CA232,D831399CA233,ZTEGDD32CB0E$ZTE3ANNR6R27897,48D682381298,48D682381299,ZTEGDB0197CC$ZTE3ANNQ9337121,843C9935FB43,843C9935FB44,ZTEGD7BC4CF8$ZTE3ANNR4N23362,4896D9577EA4,4896D9577EA5,ZTEGD97F7B07$ZTE3ANNT4P15588,F00C514D13F6,F00C514D13F7,ZTEGDE34337A$ZTE3ANNR6R55621,48D6823A9C60,48D6823A9C61,ZTEGDB020418$ZTE3ANNT2V12073,D831398CA9CE,D831398CA9CF,ZTEGDD3021A8$ZTE3ANNR6R50764,48D6823A2A8A,48D6823A2A8B,ZTEGDB01F11F$ZTE3ANNR4N39460,4896D958F7F0,4896D958F7F1,ZTEGD97FB9E9$ZTE3ANNRB756842,5872C9936D6D,5872C9936D6E,ZTEGDC6208DD$ZTE3ANNR2Q25513,F4E84F8309F6,F4E84F8309F7,ZTEGD97AD663$ZTE3ANNRC501350,6C11BA62497B,6C11BA62497C,ZTEGDC6E1B05$ZTE3ANNRAD24855,D89A0DB020ED,D89A0DB020EE,ZTEGDB175D22$ZTE3ANNRCP46474,6C11BA6D6C0B,6C11BA6D6C0C,ZTEGDC6FF61D$ZTE3ANNR5W07825,48D6822F3B30,48D6822F3B31,ZTEGDB001E90$ZTE3ANNR9F15099,D89A0DA43FC5,D89A0DA43FC6,ZTEGDB156246$ZTE3ANNR1Y08610,14CA56CD7447,14CA56CD7448,ZTEGD97097FD$ZTE3ANNR6R25461,48D68237D980,48D68237D981,ZTEGDB018E48$ZTE3ANNRAM61536,5872C98CDA79,5872C98CDA7A,ZTEGDC60F05F$ZTE3ANNQ9J41589,843C992F9FF3,843C992F9FF4,ZTEGD7BBAB20$ZTE3ANNR1Y21263,14CA56CE9CD5,14CA56CE9CD6,ZTEGD970C96A$ZTE3ANNR7B15328,3891484A53E7,3891484A53E8,ZTEGDB07CD40$ZTE3ANNR9W42308,D89A0DAC3BBB,D89A0DAC3BBC,ZTEGDB16B6EF$ZTE3ANNT3H01827,D8313996EE6A,D8313996EE6B,ZTEGDD31D7C2', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-13 16:45:48 Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 1 26s597ms 26s597ms 26s597ms 26s597ms call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-13 08:45:34 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-13 00:05:20 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-13 20:15:08 Database: rio User: intelifix Remote: [local] Application: psql
Queries that waited the most
Rank Wait time Query 1 37s89ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (295397, 184, 'CP2526LV3VP,B85E710FF270', '',0185,00,'[{"item":"0","qrcode":""}]','', '', 00);[ Date: 2026-10-13 16:10:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 26s597ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-10-13 08:45:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Queries
Queries by type
Key values
- 2,959 Total read queries
- 1,080 Total write queries
Queries by database
Key values
- rio Main database
- 2,872 Requests
- 5h14m57s (rio)
- Main time consuming database
Database Request type Count Duration brasilia Total 1,223 1h36m35s copy to 140 10m58s ddl 155 1m39s others 248 11m11s select 680 1h12m45s contagem Total 449 12m32s copy to 116 1m24s ddl 15 25s331ms others 6 3m6s select 312 7m35s rio Total 2,872 5h14m57s copy to 145 29m32s ddl 509 38m58s others 257 27m42s select 1,961 3h38m45s testes Total 6 1s694ms select 6 1s694ms Queries by user
Key values
- intelifix Main user
- 4,423 Requests
User Request type Count Duration etiquetas Total 27 6s34ms select 27 6s34ms intelifix Total 4,423 7h3m10s copy to 401 41m55s ddl 679 41m2s others 511 42m select 2,832 4h58m11s lenon Total 100 50s236ms select 100 50s236ms Duration by user
Key values
- 7h3m10s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 27 6s34ms select 27 6s34ms intelifix Total 4,423 7h3m10s copy to 401 41m55s ddl 679 41m2s others 511 42m select 2,832 4h58m11s lenon Total 100 50s236ms select 100 50s236ms Queries by host
Key values
- [local] Main host
- 4,550 Requests
- 7h4m7s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 3,421 Requests
- 3h31m2s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-10-13 23:42:21 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,213 100-500ms duration
Slowest individual queries
Rank Duration Query 1 10m10s analyze verbose;[ Date: 2026-10-13 05:10:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-13 07:14:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m41s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031037, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-13 07:33:22 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 7m6s analyze verbose;[ Date: 2026-10-13 05:17:19 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
5 6m6s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031048, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-13 10:51:32 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 5m53s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031085, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-13 16:10:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 5m52s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031044, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-13 09:33:31 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 5m50s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031074, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-13 15:11:13 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 5m50s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031046, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-13 09:59:25 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 5m46s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031069, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx') / 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-13 15:00:09 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 5m45s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031050, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-13 11:20:29 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 5m43s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031042, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-13 08:45:31 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 5m43s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031065, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-13 14:02:42 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 5m42s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031078, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-13 15:31:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 5m42s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031038, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-13 07:52:32 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 5m40s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031054, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-13 11:52:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m29s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-13 15:10:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-13 09:10:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-13 20:10:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-13 11:10:24 - 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 1h35m 48 2s378ms 9m53s 1m58s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 13 07 3 10m41s 3m33s 08 3 5m34s 1m51s 09 3 5m45s 1m55s 10 3 5m41s 1m53s 11 3 5m42s 1m54s 12 3 5m36s 1m52s 13 3 5m28s 1m49s 14 3 5m31s 1m50s 15 3 5m49s 1m56s 16 3 5m39s 1m53s 17 3 5m41s 1m53s 18 3 5m35s 1m51s 19 3 5m31s 1m50s 20 3 5m44s 1m54s 21 3 5m32s 1m50s 22 3 5m23s 1m47s [ User: intelifix - Total duration: 1h35m - Times executed: 48 ]
[ Application: psql - Total duration: 1h35m - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-13 07:14:54 Duration: 9m53s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-13 15:10:31 Duration: 5m29s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-13 09:10:28 Duration: 5m26s Database: rio User: intelifix Remote: [local] Application: psql
2 1h34m35s 222 150ms 7m41s 25s565ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 13 07 9 13m33s 1m30s 08 14 6m48s 29s174ms 09 24 18m24s 46s12ms 10 19 7m53s 24s943ms 11 16 11m42s 43s880ms 12 7 1m44s 14s880ms 13 27 1m56s 4s328ms 14 24 8m29s 21s211ms 15 32 14m16s 26s765ms 16 16 8m30s 31s900ms 17 22 52s948ms 2s406ms 18 7 21s414ms 3s59ms 19 5 2s297ms 459ms [ User: intelifix - Total duration: 1h34m35s - Times executed: 222 ]
[ Application: [unknown] - Total duration: 1h34m35s - Times executed: 222 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031037, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-13 07:33:22 Duration: 7m41s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031048, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-13 10:51:32 Duration: 6m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031085, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-13 16:10:51 Duration: 5m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h5m25s 48 282ms 3m49s 1m21s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 13 07 3 5m38s 1m52s 08 3 3m56s 1m18s 09 3 4m3s 1m21s 10 3 4m12s 1m24s 11 3 4m3s 1m21s 12 3 3m57s 1m19s 13 3 4m 1m20s 14 3 3m57s 1m19s 15 3 4m3s 1m21s 16 3 4m 1m20s 17 3 3m58s 1m19s 18 3 3m54s 1m18s 19 3 3m49s 1m16s 20 3 3m58s 1m19s 21 3 3m49s 1m16s 22 3 4m 1m20s [ User: intelifix - Total duration: 1h5m25s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m25s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-13 07:21:11 Duration: 3m49s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-13 10:14:52 Duration: 3m39s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-13 11:14:43 Duration: 3m33s Database: brasilia User: intelifix Remote: [local] Application: psql
4 20m7s 3 2m50s 10m10s 6m42s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 13 05 3 20m7s 6m42s [ User: intelifix - Total duration: 20m7s - Times executed: 3 ]
[ Application: psql - Total duration: 20m7s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-13 05:10:12 Duration: 10m10s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-13 05:17:19 Duration: 7m6s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-13 05:20:09 Duration: 2m50s Database: contagem User: intelifix Remote: [local] Application: psql
5 11m17s 1,150 150ms 10s24ms 589ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 13 08 76 1m5s 867ms 09 124 1m19s 639ms 10 116 1m28s 760ms 11 133 1m25s 639ms 12 24 17s308ms 721ms 13 85 51s424ms 604ms 14 120 1m19s 662ms 15 135 1m16s 567ms 16 144 1m3s 444ms 17 173 1m2s 362ms 18 20 7s435ms 371ms [ User: intelifix - Total duration: 11m17s - Times executed: 1150 ]
[ Application: [unknown] - Total duration: 11m17s - Times executed: 1150 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "295184", "modelo" : "181", "itens" : "T51238003941,T51241019944,10412132D6E0,T51226003885,104121071CC0,,1041210FA5F0,10412127A500,10412122A310", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-13 10:04:15 Duration: 10s24ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "295125", "modelo" : "295", "itens" : "230032666767,230046788089,229981912634,230001934857,230049536573,230027643337,230011299294,229981960316,230014771621,230044998094,229990042339,230053055368,230014128796,230001254959,229990879299,230049981623,230037956464,229987692031,229965803542,230037244970,229985962244,229982746284", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-13 08:01:20 Duration: 3s44ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "295141", "modelo" : "463", "itens" : "241794035867,241794117996,241794105268,241794385172,241719125672,241735510224,241704902242,241725845677,241755122530,241748828403,241795303253,241786428087,241758255574,241786481427,241720826971,241783485062,241781734465,241724786572,241750134860,241789620106,241749950724,241791982940,241785928588,241792254560,241758563539,241789659199,241787359806,241790307478,241756884363,241794261019,241758849201,241783488395,241720938497,241783547997,241720389802,241782059603,241754312137,241753889716,241719248792,241721804553,241789527896,241724170621,241735578489,241719137895,241756926465,241787761013,241782313141,241782312939,241788624868,241783360606,241788632041,241789528705,241757652328,241735583945,241751413234,241755876778,241786928798,241705882629,241721755457,241721006282", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-13 08:00:33 Duration: 3s18ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 9m12s 48 11s14ms 14s476ms 11s518ms create table temp0000294014 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 13 13 2 22s389ms 11s194ms 14 3 34s552ms 11s517ms 15 22 4m14s 11s561ms 16 15 2m53s 11s543ms 17 6 1m8s 11s403ms [ User: intelifix - Total duration: 9m12s - Times executed: 48 ]
[ Application: [unknown] - Total duration: 9m12s - Times executed: 48 ]
-
CREATE TABLE temp0000294014 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 16:16:16 Duration: 14s476ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000294014 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 17:21:25 Duration: 12s243ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000294014 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 15:49:20 Duration: 12s143ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 8m32s 42 10s816ms 43s130ms 12s203ms create table temp0000293954 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 13 07 5 1m28s 17s683ms 08 10 1m51s 11s189ms 09 9 1m42s 11s371ms 10 2 24s782ms 12s391ms 11 15 2m53s 11s591ms 12 1 11s242ms 11s242ms [ User: intelifix - Total duration: 8m32s - Times executed: 42 ]
[ Application: [unknown] - Total duration: 8m32s - Times executed: 42 ]
-
CREATE TABLE temp0000293954 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 07:24:24 Duration: 43s130ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293954 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 11:29:29 Duration: 14s377ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293954 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 10:45:21 Duration: 12s814ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 7m55s 274 174ms 29s840ms 1s736ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 13 00 12 37s219ms 3s101ms 01 12 16s777ms 1s398ms 02 12 17s40ms 1s420ms 03 12 16s268ms 1s355ms 04 12 16s11ms 1s334ms 05 12 16s193ms 1s349ms 06 12 16s15ms 1s334ms 07 12 18s41ms 1s503ms 08 12 52s24ms 4s335ms 09 12 18s740ms 1s561ms 10 12 19s936ms 1s661ms 11 12 19s253ms 1s604ms 12 12 17s997ms 1s499ms 13 12 17s228ms 1s435ms 14 12 20s241ms 1s686ms 15 12 22s880ms 1s906ms 16 12 20s81ms 1s673ms 17 12 18s115ms 1s509ms 18 12 17s805ms 1s483ms 19 12 17s153ms 1s429ms 20 11 26s376ms 2s397ms 21 12 17s514ms 1s459ms 22 11 16s890ms 1s535ms [ User: intelifix - Total duration: 7m55s - Times executed: 274 ]
[ Application: psql - Total duration: 7m55s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-13 08:45:34 Duration: 29s840ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-13 00:05:20 Duration: 18s297ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-13 20:15:08 Duration: 7s37ms Database: rio User: intelifix Remote: [local] Application: psql
9 7m30s 39 11s87ms 14s458ms 11s547ms create table temp0000294006 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 13 13 11 2m8s 11s668ms 14 3 35s143ms 11s714ms 15 10 1m55s 11s540ms 16 15 2m51s 11s430ms [ User: intelifix - Total duration: 7m30s - Times executed: 39 ]
[ Application: [unknown] - Total duration: 7m30s - Times executed: 39 ]
-
CREATE TABLE temp0000294006 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 13:30:32 Duration: 14s458ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000294006 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 13:22:39 Duration: 12s484ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000294006 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 16:09:08 Duration: 12s353ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 6m36s 127 158ms 12s816ms 3s120ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 13 00 1 300ms 300ms 05 1 166ms 166ms 07 10 46s629ms 4s662ms 08 12 47s735ms 3s977ms 09 12 48s711ms 4s59ms 10 12 50s338ms 4s194ms 11 12 44s253ms 3s687ms 12 12 20s821ms 1s735ms 13 12 16s514ms 1s376ms 14 12 37s872ms 3s156ms 15 12 35s287ms 2s940ms 16 11 33s512ms 3s46ms 17 7 13s950ms 1s992ms 20 1 158ms 158ms [ User: intelifix - Total duration: 6m36s - Times executed: 127 ]
[ Application: psql - Total duration: 6m36s - Times executed: 127 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-13 07:25:14 Duration: 12s816ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-13 08:55:14 Duration: 12s353ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-13 10:15:10 Duration: 9s139ms Database: rio User: intelifix Remote: [local] Application: psql
11 6m29s 460 150ms 37s274ms 846ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 13 07 1 258ms 258ms 08 19 9s555ms 502ms 09 26 17s119ms 658ms 10 55 42s369ms 770ms 11 60 46s952ms 782ms 12 8 5s36ms 629ms 13 48 35s214ms 733ms 14 70 1m 865ms 15 59 42s360ms 717ms 16 73 1m36s 1s327ms 17 40 32s402ms 810ms 18 1 529ms 529ms [ User: intelifix - Total duration: 6m29s - Times executed: 460 ]
[ Application: [unknown] - Total duration: 6m29s - Times executed: 460 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (295397, 184, 'CP2526LV3VP,B85E710FF270', '',0185,00,'[{"item":"0","qrcode":""}]','', '', 00);
Date: 2026-10-13 16:10:51 Duration: 37s274ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (61747, 406, '835237935002890,241708772642,241700840712,241605397479,241700838488,241650797084,241593391112,241676686468,241676855677,241704248484,241708950718,241659737788,241663101316,241700853238,241713821833,241620863344,241698312934,241646273153,241593782340,241708951829,241703970524,241703986181,241652334956,241635931212,241729899305,241676816380,241698716587,241671533452,241704731720,241599251931,241650802742,241704231335,241708951324,241708775369,241695645973,241698704465,241668278094,241708763348,241650796175,241727063136,241664862341,241695643852,241698666178,241676852849,241669969820,241714040822,241630115369,241659738091', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-13 15:16:21 Duration: 4s891ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (61754, 406, 'ZTE3ANNR8C33325,389148519415,389148519416,ZTEGDB09029D$ZTE3ANNR8C26556,38914850F56F,38914850F570,ZTEGDB08E82C$ZTE3ANNRCB66345,D8313923E1F4,D8313923E1F5,ZTEGDD2AB8BE$ZTE3ANNQCA12290,14CA56D364E7,14CA56D364E8,ZTEGD971956D$ZTE3ANNT3H64111,D831399CA232,D831399CA233,ZTEGDD32CB0E$ZTE3ANNR6R27897,48D682381298,48D682381299,ZTEGDB0197CC$ZTE3ANNQ9337121,843C9935FB43,843C9935FB44,ZTEGD7BC4CF8$ZTE3ANNR4N23362,4896D9577EA4,4896D9577EA5,ZTEGD97F7B07$ZTE3ANNT4P15588,F00C514D13F6,F00C514D13F7,ZTEGDE34337A$ZTE3ANNR6R55621,48D6823A9C60,48D6823A9C61,ZTEGDB020418$ZTE3ANNT2V12073,D831398CA9CE,D831398CA9CF,ZTEGDD3021A8$ZTE3ANNR6R50764,48D6823A2A8A,48D6823A2A8B,ZTEGDB01F11F$ZTE3ANNR4N39460,4896D958F7F0,4896D958F7F1,ZTEGD97FB9E9$ZTE3ANNRB756842,5872C9936D6D,5872C9936D6E,ZTEGDC6208DD$ZTE3ANNR2Q25513,F4E84F8309F6,F4E84F8309F7,ZTEGD97AD663$ZTE3ANNRC501350,6C11BA62497B,6C11BA62497C,ZTEGDC6E1B05$ZTE3ANNRAD24855,D89A0DB020ED,D89A0DB020EE,ZTEGDB175D22$ZTE3ANNRCP46474,6C11BA6D6C0B,6C11BA6D6C0C,ZTEGDC6FF61D$ZTE3ANNR5W07825,48D6822F3B30,48D6822F3B31,ZTEGDB001E90$ZTE3ANNR9F15099,D89A0DA43FC5,D89A0DA43FC6,ZTEGDB156246$ZTE3ANNR1Y08610,14CA56CD7447,14CA56CD7448,ZTEGD97097FD$ZTE3ANNR6R25461,48D68237D980,48D68237D981,ZTEGDB018E48$ZTE3ANNRAM61536,5872C98CDA79,5872C98CDA7A,ZTEGDC60F05F$ZTE3ANNQ9J41589,843C992F9FF3,843C992F9FF4,ZTEGD7BBAB20$ZTE3ANNR1Y21263,14CA56CE9CD5,14CA56CE9CD6,ZTEGD970C96A$ZTE3ANNR7B15328,3891484A53E7,3891484A53E8,ZTEGDB07CD40$ZTE3ANNR9W42308,D89A0DAC3BBB,D89A0DAC3BBC,ZTEGDB16B6EF$ZTE3ANNT3H01827,D8313996EE6A,D8313996EE6B,ZTEGDD31D7C2', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-13 16:45:48 Duration: 3s754ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
12 5m46s 1 5m46s 5m46s 5m46s select * from rs_fast_excel (?, ?) / 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 #12
Day Hour Count Duration Avg duration Oct 13 15 1 5m46s 5m46s [ User: intelifix - Total duration: 5m46s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 5m46s - Times executed: 1 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031069, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx') / 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-13 15:00:09 Duration: 5m46s Database: rio User: intelifix Remote: [local] Application: [unknown]
13 5m20s 60 757ms 33s311ms 5s338ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 13 07 2 12s546ms 6s273ms 08 2 8s673ms 4s336ms 09 9 22s781ms 2s531ms 10 7 1m24s 12s82ms 11 3 23s241ms 7s747ms 13 4 28s889ms 7s222ms 14 3 20s578ms 6s859ms 15 7 43s949ms 6s278ms 16 8 23s482ms 2s935ms 17 13 36s899ms 2s838ms 18 2 14s667ms 7s333ms [ User: intelifix - Total duration: 5m20s - Times executed: 60 ]
[ Application: [unknown] - Total duration: 5m20s - Times executed: 60 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-13', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-13 10:10:21 Duration: 33s311ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-13', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-13 10:49:33 Duration: 23s865ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-13', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-13 11:28:56 Duration: 17s210ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 4m55s 47 181ms 1m1s 6s282ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 13 07 2 1m4s 32s484ms 08 2 7s585ms 3s792ms 09 4 39s978ms 9s994ms 10 3 22s5ms 7s335ms 11 4 16s393ms 4s98ms 12 1 4s80ms 4s80ms 13 6 39s586ms 6s597ms 14 2 10s871ms 5s435ms 15 11 39s804ms 3s618ms 16 8 33s762ms 4s220ms 17 3 11s768ms 3s922ms 18 1 4s482ms 4s482ms [ User: intelifix - Total duration: 4m55s - Times executed: 47 ]
[ Application: psql - Total duration: 4m55s - Times executed: 47 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (031037);
Date: 2026-10-13 07:25:36 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (031057);
Date: 2026-10-13 13:23:22 Duration: 23s245ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (031046);
Date: 2026-10-13 09:53:15 Duration: 18s736ms Database: rio User: intelifix Remote: [local] Application: psql
15 2m23s 114 153ms 15s996ms 1s260ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 13 07 7 7s400ms 1s57ms 08 15 18s741ms 1s249ms 09 7 6s627ms 946ms 10 8 8s600ms 1s75ms 11 9 8s848ms 983ms 13 18 58s440ms 3s246ms 14 7 4s740ms 677ms 15 17 17s132ms 1s7ms 16 7 4s919ms 702ms 17 8 4s536ms 567ms 18 4 1s83ms 270ms 19 7 2s579ms 368ms [ User: intelifix - Total duration: 2m23s - Times executed: 114 ]
[ Application: [unknown] - Total duration: 2m23s - Times executed: 114 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059277) LIMIT 1;
Date: 2026-10-13 13:43:23 Duration: 15s996ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059276) LIMIT 1;
Date: 2026-10-13 13:43:53 Duration: 11s429ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059782) LIMIT 1;
Date: 2026-10-13 13:42:37 Duration: 9s922ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
16 2m15s 4 4s470ms 1m4s 33s943ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 13 20 2 1m8s 34s450ms 23 2 1m6s 33s436ms [ User: intelifix - Total duration: 2m15s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m15s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-13 20:08:44 Duration: 1m4s 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-13 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-13 20:10:44 Duration: 4s528ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 2m12s 44 150ms 1m 3s22ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 13 07 2 1s386ms 693ms 08 4 1s128ms 282ms 09 4 1m1s 15s499ms 10 2 41s808ms 20s904ms 11 6 15s300ms 2s550ms 12 2 2s806ms 1s403ms 13 3 634ms 211ms 14 1 666ms 666ms 15 9 3s945ms 438ms 16 7 2s103ms 300ms 17 3 1s26ms 342ms 18 1 192ms 192ms [ User: intelifix - Total duration: 2m12s - Times executed: 44 ]
[ Application: psql - Total duration: 2m12s - Times executed: 44 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (031045);
Date: 2026-10-13 09:48:13 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (031047);
Date: 2026-10-13 10:39:29 Duration: 41s532ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 508); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (031052);
Date: 2026-10-13 11:43:02 Duration: 14s293ms Database: rio User: intelifix Remote: [local] Application: psql
18 2m4s 36 690ms 10s273ms 3s468ms 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 #18
Day Hour Count Duration Avg duration Oct 13 08 2 6s577ms 3s288ms 09 3 12s301ms 4s100ms 10 3 13s459ms 4s486ms 11 3 14s750ms 4s916ms 12 2 3s997ms 1s998ms 13 2 5s606ms 2s803ms 14 2 7s687ms 3s843ms 15 3 26s154ms 8s718ms 16 2 11s162ms 5s581ms 17 2 9s232ms 4s616ms 18 2 5s579ms 2s789ms 19 3 2s481ms 827ms 20 3 2s489ms 829ms 21 2 1s829ms 914ms 22 2 1s561ms 780ms [ User: intelifix - Total duration: 2m4s - Times executed: 36 ]
[ Application: psql - Total duration: 2m4s - Times executed: 36 ]
-
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-13 15:00:11 Duration: 10s273ms 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-13 15:40:09 Duration: 8s174ms 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-13 15:20:08 Duration: 7s706ms Database: rio User: intelifix Remote: [local] Application: psql
19 2m4s 11 10s788ms 11s847ms 11s273ms create table temp0000293998 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 13 11 5 56s924ms 11s384ms 12 6 1m7s 11s179ms [ User: intelifix - Total duration: 2m4s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 2m4s - Times executed: 11 ]
-
CREATE TABLE temp0000293998 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 11:43:02 Duration: 11s847ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293998 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 12:12:17 Duration: 11s514ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293998 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 11:42:32 Duration: 11s436ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 2m1s 9 11s307ms 20s127ms 13s533ms create table temp0000293986 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 13 09 5 57s739ms 11s547ms 10 4 1m4s 16s16ms [ User: intelifix - Total duration: 2m1s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 2m1s - Times executed: 9 ]
-
CREATE TABLE temp0000293986 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 10:38:10 Duration: 20s127ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293986 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 10:59:45 Duration: 18s559ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293986 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 10:40:29 Duration: 13s608ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,150 11m17s 150ms 10s24ms 589ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 13 08 76 1m5s 867ms 09 124 1m19s 639ms 10 116 1m28s 760ms 11 133 1m25s 639ms 12 24 17s308ms 721ms 13 85 51s424ms 604ms 14 120 1m19s 662ms 15 135 1m16s 567ms 16 144 1m3s 444ms 17 173 1m2s 362ms 18 20 7s435ms 371ms [ User: intelifix - Total duration: 11m17s - Times executed: 1150 ]
[ Application: [unknown] - Total duration: 11m17s - Times executed: 1150 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "295184", "modelo" : "181", "itens" : "T51238003941,T51241019944,10412132D6E0,T51226003885,104121071CC0,,1041210FA5F0,10412127A500,10412122A310", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-13 10:04:15 Duration: 10s24ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "295125", "modelo" : "295", "itens" : "230032666767,230046788089,229981912634,230001934857,230049536573,230027643337,230011299294,229981960316,230014771621,230044998094,229990042339,230053055368,230014128796,230001254959,229990879299,230049981623,230037956464,229987692031,229965803542,230037244970,229985962244,229982746284", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-13 08:01:20 Duration: 3s44ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "295141", "modelo" : "463", "itens" : "241794035867,241794117996,241794105268,241794385172,241719125672,241735510224,241704902242,241725845677,241755122530,241748828403,241795303253,241786428087,241758255574,241786481427,241720826971,241783485062,241781734465,241724786572,241750134860,241789620106,241749950724,241791982940,241785928588,241792254560,241758563539,241789659199,241787359806,241790307478,241756884363,241794261019,241758849201,241783488395,241720938497,241783547997,241720389802,241782059603,241754312137,241753889716,241719248792,241721804553,241789527896,241724170621,241735578489,241719137895,241756926465,241787761013,241782313141,241782312939,241788624868,241783360606,241788632041,241789528705,241757652328,241735583945,241751413234,241755876778,241786928798,241705882629,241721755457,241721006282", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-13 08:00:33 Duration: 3s18ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 460 6m29s 150ms 37s274ms 846ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 13 07 1 258ms 258ms 08 19 9s555ms 502ms 09 26 17s119ms 658ms 10 55 42s369ms 770ms 11 60 46s952ms 782ms 12 8 5s36ms 629ms 13 48 35s214ms 733ms 14 70 1m 865ms 15 59 42s360ms 717ms 16 73 1m36s 1s327ms 17 40 32s402ms 810ms 18 1 529ms 529ms [ User: intelifix - Total duration: 6m29s - Times executed: 460 ]
[ Application: [unknown] - Total duration: 6m29s - Times executed: 460 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (295397, 184, 'CP2526LV3VP,B85E710FF270', '',0185,00,'[{"item":"0","qrcode":""}]','', '', 00);
Date: 2026-10-13 16:10:51 Duration: 37s274ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (61747, 406, '835237935002890,241708772642,241700840712,241605397479,241700838488,241650797084,241593391112,241676686468,241676855677,241704248484,241708950718,241659737788,241663101316,241700853238,241713821833,241620863344,241698312934,241646273153,241593782340,241708951829,241703970524,241703986181,241652334956,241635931212,241729899305,241676816380,241698716587,241671533452,241704731720,241599251931,241650802742,241704231335,241708951324,241708775369,241695645973,241698704465,241668278094,241708763348,241650796175,241727063136,241664862341,241695643852,241698666178,241676852849,241669969820,241714040822,241630115369,241659738091', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-13 15:16:21 Duration: 4s891ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (61754, 406, 'ZTE3ANNR8C33325,389148519415,389148519416,ZTEGDB09029D$ZTE3ANNR8C26556,38914850F56F,38914850F570,ZTEGDB08E82C$ZTE3ANNRCB66345,D8313923E1F4,D8313923E1F5,ZTEGDD2AB8BE$ZTE3ANNQCA12290,14CA56D364E7,14CA56D364E8,ZTEGD971956D$ZTE3ANNT3H64111,D831399CA232,D831399CA233,ZTEGDD32CB0E$ZTE3ANNR6R27897,48D682381298,48D682381299,ZTEGDB0197CC$ZTE3ANNQ9337121,843C9935FB43,843C9935FB44,ZTEGD7BC4CF8$ZTE3ANNR4N23362,4896D9577EA4,4896D9577EA5,ZTEGD97F7B07$ZTE3ANNT4P15588,F00C514D13F6,F00C514D13F7,ZTEGDE34337A$ZTE3ANNR6R55621,48D6823A9C60,48D6823A9C61,ZTEGDB020418$ZTE3ANNT2V12073,D831398CA9CE,D831398CA9CF,ZTEGDD3021A8$ZTE3ANNR6R50764,48D6823A2A8A,48D6823A2A8B,ZTEGDB01F11F$ZTE3ANNR4N39460,4896D958F7F0,4896D958F7F1,ZTEGD97FB9E9$ZTE3ANNRB756842,5872C9936D6D,5872C9936D6E,ZTEGDC6208DD$ZTE3ANNR2Q25513,F4E84F8309F6,F4E84F8309F7,ZTEGD97AD663$ZTE3ANNRC501350,6C11BA62497B,6C11BA62497C,ZTEGDC6E1B05$ZTE3ANNRAD24855,D89A0DB020ED,D89A0DB020EE,ZTEGDB175D22$ZTE3ANNRCP46474,6C11BA6D6C0B,6C11BA6D6C0C,ZTEGDC6FF61D$ZTE3ANNR5W07825,48D6822F3B30,48D6822F3B31,ZTEGDB001E90$ZTE3ANNR9F15099,D89A0DA43FC5,D89A0DA43FC6,ZTEGDB156246$ZTE3ANNR1Y08610,14CA56CD7447,14CA56CD7448,ZTEGD97097FD$ZTE3ANNR6R25461,48D68237D980,48D68237D981,ZTEGDB018E48$ZTE3ANNRAM61536,5872C98CDA79,5872C98CDA7A,ZTEGDC60F05F$ZTE3ANNQ9J41589,843C992F9FF3,843C992F9FF4,ZTEGD7BBAB20$ZTE3ANNR1Y21263,14CA56CE9CD5,14CA56CE9CD6,ZTEGD970C96A$ZTE3ANNR7B15328,3891484A53E7,3891484A53E8,ZTEGDB07CD40$ZTE3ANNR9W42308,D89A0DAC3BBB,D89A0DAC3BBC,ZTEGDB16B6EF$ZTE3ANNT3H01827,D8313996EE6A,D8313996EE6B,ZTEGDD31D7C2', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-13 16:45:48 Duration: 3s754ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
3 274 7m55s 174ms 29s840ms 1s736ms call rs_giga_triagem (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 13 00 12 37s219ms 3s101ms 01 12 16s777ms 1s398ms 02 12 17s40ms 1s420ms 03 12 16s268ms 1s355ms 04 12 16s11ms 1s334ms 05 12 16s193ms 1s349ms 06 12 16s15ms 1s334ms 07 12 18s41ms 1s503ms 08 12 52s24ms 4s335ms 09 12 18s740ms 1s561ms 10 12 19s936ms 1s661ms 11 12 19s253ms 1s604ms 12 12 17s997ms 1s499ms 13 12 17s228ms 1s435ms 14 12 20s241ms 1s686ms 15 12 22s880ms 1s906ms 16 12 20s81ms 1s673ms 17 12 18s115ms 1s509ms 18 12 17s805ms 1s483ms 19 12 17s153ms 1s429ms 20 11 26s376ms 2s397ms 21 12 17s514ms 1s459ms 22 11 16s890ms 1s535ms [ User: intelifix - Total duration: 7m55s - Times executed: 274 ]
[ Application: psql - Total duration: 7m55s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-13 08:45:34 Duration: 29s840ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-13 00:05:20 Duration: 18s297ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-13 20:15:08 Duration: 7s37ms Database: rio User: intelifix Remote: [local] Application: psql
4 222 1h34m35s 150ms 7m41s 25s565ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 13 07 9 13m33s 1m30s 08 14 6m48s 29s174ms 09 24 18m24s 46s12ms 10 19 7m53s 24s943ms 11 16 11m42s 43s880ms 12 7 1m44s 14s880ms 13 27 1m56s 4s328ms 14 24 8m29s 21s211ms 15 32 14m16s 26s765ms 16 16 8m30s 31s900ms 17 22 52s948ms 2s406ms 18 7 21s414ms 3s59ms 19 5 2s297ms 459ms [ User: intelifix - Total duration: 1h34m35s - Times executed: 222 ]
[ Application: [unknown] - Total duration: 1h34m35s - Times executed: 222 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031037, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-13 07:33:22 Duration: 7m41s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031048, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-13 10:51:32 Duration: 6m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031085, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-13 16:10:51 Duration: 5m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 127 6m36s 158ms 12s816ms 3s120ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 13 00 1 300ms 300ms 05 1 166ms 166ms 07 10 46s629ms 4s662ms 08 12 47s735ms 3s977ms 09 12 48s711ms 4s59ms 10 12 50s338ms 4s194ms 11 12 44s253ms 3s687ms 12 12 20s821ms 1s735ms 13 12 16s514ms 1s376ms 14 12 37s872ms 3s156ms 15 12 35s287ms 2s940ms 16 11 33s512ms 3s46ms 17 7 13s950ms 1s992ms 20 1 158ms 158ms [ User: intelifix - Total duration: 6m36s - Times executed: 127 ]
[ Application: psql - Total duration: 6m36s - Times executed: 127 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-13 07:25:14 Duration: 12s816ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-13 08:55:14 Duration: 12s353ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-13 10:15:10 Duration: 9s139ms Database: rio User: intelifix Remote: [local] Application: psql
6 114 2m23s 153ms 15s996ms 1s260ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 13 07 7 7s400ms 1s57ms 08 15 18s741ms 1s249ms 09 7 6s627ms 946ms 10 8 8s600ms 1s75ms 11 9 8s848ms 983ms 13 18 58s440ms 3s246ms 14 7 4s740ms 677ms 15 17 17s132ms 1s7ms 16 7 4s919ms 702ms 17 8 4s536ms 567ms 18 4 1s83ms 270ms 19 7 2s579ms 368ms [ User: intelifix - Total duration: 2m23s - Times executed: 114 ]
[ Application: [unknown] - Total duration: 2m23s - Times executed: 114 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059277) LIMIT 1;
Date: 2026-10-13 13:43:23 Duration: 15s996ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059276) LIMIT 1;
Date: 2026-10-13 13:43:53 Duration: 11s429ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059782) LIMIT 1;
Date: 2026-10-13 13:42:37 Duration: 9s922ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
7 92 29s409ms 300ms 394ms 319ms 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 #7
Day Hour Count Duration Avg duration Oct 13 06 1 300ms 300ms 07 5 1s548ms 309ms 08 9 2s838ms 315ms 09 9 2s831ms 314ms 10 8 2s572ms 321ms 11 9 2s892ms 321ms 12 4 1s327ms 331ms 13 9 2s889ms 321ms 14 10 3s191ms 319ms 15 9 3s7ms 334ms 16 8 2s561ms 320ms 17 8 2s512ms 314ms 18 2 633ms 316ms 19 1 301ms 301ms [ User: lenon - Total duration: 29s409ms - Times executed: 92 ]
[ Application: [unknown] - Total duration: 29s409ms - Times executed: 92 ]
-
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-13 15:05:02 Duration: 394ms 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-13 12:43:51 Duration: 374ms 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-13 16:45:39 Duration: 357ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
8 90 27s433ms 259ms 844ms 304ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 13 07 2 595ms 297ms 08 6 2s37ms 339ms 09 16 4s783ms 298ms 10 10 3s459ms 345ms 11 9 2s778ms 308ms 12 2 710ms 355ms 13 8 2s231ms 278ms 14 7 1s971ms 281ms 15 12 3s567ms 297ms 16 10 3s23ms 302ms 17 5 1s437ms 287ms 18 3 837ms 279ms [ User: intelifix - Total duration: 27s433ms - Times executed: 90 ]
[ Application: [unknown] - Total duration: 27s433ms - Times executed: 90 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-10-13 10:50:10 Duration: 844ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-10-13 08:14:02 Duration: 594ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-10-13 12:15:54 Duration: 423ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 82 31s37ms 335ms 494ms 378ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 13 07 1 335ms 335ms 08 7 2s577ms 368ms 09 9 3s355ms 372ms 10 7 2s642ms 377ms 11 9 3s390ms 376ms 12 4 1s556ms 389ms 13 9 3s382ms 375ms 14 9 3s410ms 378ms 15 8 3s293ms 411ms 16 8 3s26ms 378ms 17 8 2s904ms 363ms 18 2 799ms 399ms 19 1 362ms 362ms [ User: intelifix - Total duration: 31s37ms - Times executed: 82 ]
[ Application: [unknown] - Total duration: 31s37ms - Times executed: 82 ]
-
select * from rs_menu_grants (507, 72, 1);
Date: 2026-10-13 15:05:02 Duration: 494ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (415, 0, 1);
Date: 2026-10-13 15:23:46 Duration: 457ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (509, 21, 1);
Date: 2026-10-13 18:52:19 Duration: 443ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 79 14s829ms 150ms 467ms 187ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 13 07 3 572ms 190ms 08 3 567ms 189ms 09 2 410ms 205ms 10 5 1s60ms 212ms 11 2 335ms 167ms 12 6 1s170ms 195ms 14 24 4s380ms 182ms 15 21 4s12ms 191ms 16 6 1s59ms 176ms 17 7 1s259ms 179ms [ User: intelifix - Total duration: 14s829ms - Times executed: 79 ]
[ Application: [unknown] - Total duration: 14s829ms - Times executed: 79 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('4857028A6C24');
Date: 2026-10-13 15:24:46 Duration: 467ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('30FD6515F2A0');
Date: 2026-10-13 14:40:32 Duration: 333ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('230042231529');
Date: 2026-10-13 10:03:04 Duration: 281ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 71 19s990ms 150ms 686ms 281ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 13 07 3 1s41ms 347ms 08 10 2s717ms 271ms 09 8 2s329ms 291ms 10 15 4s170ms 278ms 11 13 4s494ms 345ms 12 8 1s784ms 223ms 14 9 2s406ms 267ms 15 2 353ms 176ms 16 2 450ms 225ms 17 1 243ms 243ms [ User: intelifix - Total duration: 19s990ms - Times executed: 71 ]
[ Application: [unknown] - Total duration: 19s990ms - Times executed: 71 ]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '229853759801,229841831623,229861252542,229854339611,229861245874,229855766181,229853175569,229845637998,229855998505,229842976167', NULL, NULL, 0160, 00);
Date: 2026-10-13 11:07:22 Duration: 686ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '229854978393,229851992435,229845121529,229841542930,229837984457,229843284963,229843276982,229852670919,229842343244,229840519508', NULL, NULL, 0160, 00);
Date: 2026-10-13 11:08:20 Duration: 635ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '230006725156,230005953555,230014884561,230049564657,229990700720,230025295274,230030502842,230020965053,230029034449,229967881725,230027544360', NULL, NULL, 0295, 00);
Date: 2026-10-13 09:24:26 Duration: 537ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 61 18s812ms 150ms 549ms 308ms select (rs_fast_barras (b.eq_id)).* from caixa_itens a inner join fluxos b on b.flu_id = a.flu_id where a.cai_id = ? order by a.cai_ordem;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 13 08 5 1s354ms 270ms 09 4 1s392ms 348ms 10 1 293ms 293ms 11 1 257ms 257ms 13 2 572ms 286ms 14 3 838ms 279ms 15 1 150ms 150ms 16 13 3s349ms 257ms 17 29 9s914ms 341ms 18 2 687ms 343ms [ User: intelifix - Total duration: 18s812ms - Times executed: 61 ]
[ Application: [unknown] - Total duration: 18s812ms - Times executed: 61 ]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 405098 ORDER BY A.CAI_ORDEM;
Date: 2026-10-13 09:10:39 Duration: 549ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3799848 ORDER BY A.CAI_ORDEM;
Date: 2026-10-13 17:07:27 Duration: 503ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3799845 ORDER BY A.CAI_ORDEM;
Date: 2026-10-13 17:02:35 Duration: 494ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 60 5m20s 757ms 33s311ms 5s338ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 13 07 2 12s546ms 6s273ms 08 2 8s673ms 4s336ms 09 9 22s781ms 2s531ms 10 7 1m24s 12s82ms 11 3 23s241ms 7s747ms 13 4 28s889ms 7s222ms 14 3 20s578ms 6s859ms 15 7 43s949ms 6s278ms 16 8 23s482ms 2s935ms 17 13 36s899ms 2s838ms 18 2 14s667ms 7s333ms [ User: intelifix - Total duration: 5m20s - Times executed: 60 ]
[ Application: [unknown] - Total duration: 5m20s - Times executed: 60 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-13', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-13 10:10:21 Duration: 33s311ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-13', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-13 10:49:33 Duration: 23s865ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-13', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-13 11:28:56 Duration: 17s210ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 53 2m1s 562ms 25s853ms 2s291ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 13 08 4 16s567ms 4s141ms 09 3 2s247ms 749ms 10 3 2s428ms 809ms 11 3 5s589ms 1s863ms 12 4 7s821ms 1s955ms 13 4 9s468ms 2s367ms 14 4 11s593ms 2s898ms 15 3 2s800ms 933ms 16 3 5s158ms 1s719ms 17 4 12s247ms 3s61ms 18 4 34s372ms 8s593ms 19 3 2s316ms 772ms 20 3 2s458ms 819ms 21 4 3s286ms 821ms 22 4 3s82ms 770ms [ User: intelifix - Total duration: 2m1s - Times executed: 53 ]
[ Application: psql - Total duration: 2m1s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-13 18:00:32 Duration: 25s853ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-13 08:40:15 Duration: 13s996ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-13 17:00:11 Duration: 9s841ms Database: rio User: intelifix Remote: [local] Application: psql
15 49 1m14s 1s431ms 1s746ms 1s529ms create table temp0000294014 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 13 14 3 4s525ms 1s508ms 15 26 39s601ms 1s523ms 16 14 21s559ms 1s539ms 17 6 9s235ms 1s539ms [ User: intelifix - Total duration: 1m14s - Times executed: 49 ]
[ Application: [unknown] - Total duration: 1m14s - Times executed: 49 ]
-
CREATE TABLE temp0000294014 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"08-10-2026", "ate" :"13-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-13 15:12:10 Duration: 1s746ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000294014 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"08-10-2026", "ate" :"13-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-13 15:50:13 Duration: 1s668ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000294014 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"08-10-2026", "ate" :"13-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-13 16:23:26 Duration: 1s643ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 48 1h35m 2s378ms 9m53s 1m58s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 13 07 3 10m41s 3m33s 08 3 5m34s 1m51s 09 3 5m45s 1m55s 10 3 5m41s 1m53s 11 3 5m42s 1m54s 12 3 5m36s 1m52s 13 3 5m28s 1m49s 14 3 5m31s 1m50s 15 3 5m49s 1m56s 16 3 5m39s 1m53s 17 3 5m41s 1m53s 18 3 5m35s 1m51s 19 3 5m31s 1m50s 20 3 5m44s 1m54s 21 3 5m32s 1m50s 22 3 5m23s 1m47s [ User: intelifix - Total duration: 1h35m - Times executed: 48 ]
[ Application: psql - Total duration: 1h35m - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-13 07:14:54 Duration: 9m53s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-13 15:10:31 Duration: 5m29s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-13 09:10:28 Duration: 5m26s Database: rio User: intelifix Remote: [local] Application: psql
17 48 1h5m25s 282ms 3m49s 1m21s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 13 07 3 5m38s 1m52s 08 3 3m56s 1m18s 09 3 4m3s 1m21s 10 3 4m12s 1m24s 11 3 4m3s 1m21s 12 3 3m57s 1m19s 13 3 4m 1m20s 14 3 3m57s 1m19s 15 3 4m3s 1m21s 16 3 4m 1m20s 17 3 3m58s 1m19s 18 3 3m54s 1m18s 19 3 3m49s 1m16s 20 3 3m58s 1m19s 21 3 3m49s 1m16s 22 3 4m 1m20s [ User: intelifix - Total duration: 1h5m25s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m25s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-13 07:21:11 Duration: 3m49s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-13 10:14:52 Duration: 3m39s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-13 11:14:43 Duration: 3m33s Database: brasilia User: intelifix Remote: [local] Application: psql
18 48 9m12s 11s14ms 14s476ms 11s518ms create table temp0000294014 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 13 13 2 22s389ms 11s194ms 14 3 34s552ms 11s517ms 15 22 4m14s 11s561ms 16 15 2m53s 11s543ms 17 6 1m8s 11s403ms [ User: intelifix - Total duration: 9m12s - Times executed: 48 ]
[ Application: [unknown] - Total duration: 9m12s - Times executed: 48 ]
-
CREATE TABLE temp0000294014 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 16:16:16 Duration: 14s476ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000294014 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 17:21:25 Duration: 12s243ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000294014 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 15:49:20 Duration: 12s143ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 47 4m55s 181ms 1m1s 6s282ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 13 07 2 1m4s 32s484ms 08 2 7s585ms 3s792ms 09 4 39s978ms 9s994ms 10 3 22s5ms 7s335ms 11 4 16s393ms 4s98ms 12 1 4s80ms 4s80ms 13 6 39s586ms 6s597ms 14 2 10s871ms 5s435ms 15 11 39s804ms 3s618ms 16 8 33s762ms 4s220ms 17 3 11s768ms 3s922ms 18 1 4s482ms 4s482ms [ User: intelifix - Total duration: 4m55s - Times executed: 47 ]
[ Application: psql - Total duration: 4m55s - Times executed: 47 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (031037);
Date: 2026-10-13 07:25:36 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (031057);
Date: 2026-10-13 13:23:22 Duration: 23s245ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (031046);
Date: 2026-10-13 09:53:15 Duration: 18s736ms Database: rio User: intelifix Remote: [local] Application: psql
20 44 2m12s 150ms 1m 3s22ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 13 07 2 1s386ms 693ms 08 4 1s128ms 282ms 09 4 1m1s 15s499ms 10 2 41s808ms 20s904ms 11 6 15s300ms 2s550ms 12 2 2s806ms 1s403ms 13 3 634ms 211ms 14 1 666ms 666ms 15 9 3s945ms 438ms 16 7 2s103ms 300ms 17 3 1s26ms 342ms 18 1 192ms 192ms [ User: intelifix - Total duration: 2m12s - Times executed: 44 ]
[ Application: psql - Total duration: 2m12s - Times executed: 44 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (031045);
Date: 2026-10-13 09:48:13 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (031047);
Date: 2026-10-13 10:39:29 Duration: 41s532ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 508); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (031052);
Date: 2026-10-13 11:43:02 Duration: 14s293ms Database: rio User: intelifix Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m50s 10m10s 6m42s 3 20m7s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 13 05 3 20m7s 6m42s [ User: intelifix - Total duration: 20m7s - Times executed: 3 ]
[ Application: psql - Total duration: 20m7s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-13 05:10:12 Duration: 10m10s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-13 05:17:19 Duration: 7m6s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-13 05:20:09 Duration: 2m50s Database: contagem User: intelifix Remote: [local] Application: psql
2 5m46s 5m46s 5m46s 1 5m46s select * from rs_fast_excel (?, ?) / 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 #2
Day Hour Count Duration Avg duration Oct 13 15 1 5m46s 5m46s [ User: intelifix - Total duration: 5m46s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 5m46s - Times executed: 1 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031069, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx') / 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-13 15:00:09 Duration: 5m46s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 2s378ms 9m53s 1m58s 48 1h35m select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 13 07 3 10m41s 3m33s 08 3 5m34s 1m51s 09 3 5m45s 1m55s 10 3 5m41s 1m53s 11 3 5m42s 1m54s 12 3 5m36s 1m52s 13 3 5m28s 1m49s 14 3 5m31s 1m50s 15 3 5m49s 1m56s 16 3 5m39s 1m53s 17 3 5m41s 1m53s 18 3 5m35s 1m51s 19 3 5m31s 1m50s 20 3 5m44s 1m54s 21 3 5m32s 1m50s 22 3 5m23s 1m47s [ User: intelifix - Total duration: 1h35m - Times executed: 48 ]
[ Application: psql - Total duration: 1h35m - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-13 07:14:54 Duration: 9m53s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-13 15:10:31 Duration: 5m29s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-13 09:10:28 Duration: 5m26s Database: rio User: intelifix Remote: [local] Application: psql
4 282ms 3m49s 1m21s 48 1h5m25s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 13 07 3 5m38s 1m52s 08 3 3m56s 1m18s 09 3 4m3s 1m21s 10 3 4m12s 1m24s 11 3 4m3s 1m21s 12 3 3m57s 1m19s 13 3 4m 1m20s 14 3 3m57s 1m19s 15 3 4m3s 1m21s 16 3 4m 1m20s 17 3 3m58s 1m19s 18 3 3m54s 1m18s 19 3 3m49s 1m16s 20 3 3m58s 1m19s 21 3 3m49s 1m16s 22 3 4m 1m20s [ User: intelifix - Total duration: 1h5m25s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m25s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-13 07:21:11 Duration: 3m49s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-13 10:14:52 Duration: 3m39s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-13 11:14:43 Duration: 3m33s Database: brasilia User: intelifix Remote: [local] Application: psql
5 4s470ms 1m4s 33s943ms 4 2m15s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 13 20 2 1m8s 34s450ms 23 2 1m6s 33s436ms [ User: intelifix - Total duration: 2m15s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m15s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-13 20:08:44 Duration: 1m4s 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-13 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-13 20:10:44 Duration: 4s528ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 150ms 7m41s 25s565ms 222 1h34m35s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 13 07 9 13m33s 1m30s 08 14 6m48s 29s174ms 09 24 18m24s 46s12ms 10 19 7m53s 24s943ms 11 16 11m42s 43s880ms 12 7 1m44s 14s880ms 13 27 1m56s 4s328ms 14 24 8m29s 21s211ms 15 32 14m16s 26s765ms 16 16 8m30s 31s900ms 17 22 52s948ms 2s406ms 18 7 21s414ms 3s59ms 19 5 2s297ms 459ms [ User: intelifix - Total duration: 1h34m35s - Times executed: 222 ]
[ Application: [unknown] - Total duration: 1h34m35s - Times executed: 222 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031037, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-13 07:33:22 Duration: 7m41s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031048, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-13 10:51:32 Duration: 6m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031085, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-13 16:10:51 Duration: 5m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 11s307ms 20s127ms 13s533ms 9 2m1s create table temp0000293986 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 13 09 5 57s739ms 11s547ms 10 4 1m4s 16s16ms [ User: intelifix - Total duration: 2m1s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 2m1s - Times executed: 9 ]
-
CREATE TABLE temp0000293986 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 10:38:10 Duration: 20s127ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293986 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 10:59:45 Duration: 18s559ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293986 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 10:40:29 Duration: 13s608ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10s816ms 43s130ms 12s203ms 42 8m32s create table temp0000293954 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 13 07 5 1m28s 17s683ms 08 10 1m51s 11s189ms 09 9 1m42s 11s371ms 10 2 24s782ms 12s391ms 11 15 2m53s 11s591ms 12 1 11s242ms 11s242ms [ User: intelifix - Total duration: 8m32s - Times executed: 42 ]
[ Application: [unknown] - Total duration: 8m32s - Times executed: 42 ]
-
CREATE TABLE temp0000293954 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 07:24:24 Duration: 43s130ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293954 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 11:29:29 Duration: 14s377ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293954 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 10:45:21 Duration: 12s814ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 11s87ms 14s458ms 11s547ms 39 7m30s create table temp0000294006 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 13 13 11 2m8s 11s668ms 14 3 35s143ms 11s714ms 15 10 1m55s 11s540ms 16 15 2m51s 11s430ms [ User: intelifix - Total duration: 7m30s - Times executed: 39 ]
[ Application: [unknown] - Total duration: 7m30s - Times executed: 39 ]
-
CREATE TABLE temp0000294006 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 13:30:32 Duration: 14s458ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000294006 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 13:22:39 Duration: 12s484ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000294006 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 16:09:08 Duration: 12s353ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 11s14ms 14s476ms 11s518ms 48 9m12s create table temp0000294014 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 13 13 2 22s389ms 11s194ms 14 3 34s552ms 11s517ms 15 22 4m14s 11s561ms 16 15 2m53s 11s543ms 17 6 1m8s 11s403ms [ User: intelifix - Total duration: 9m12s - Times executed: 48 ]
[ Application: [unknown] - Total duration: 9m12s - Times executed: 48 ]
-
CREATE TABLE temp0000294014 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 16:16:16 Duration: 14s476ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000294014 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 17:21:25 Duration: 12s243ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000294014 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 15:49:20 Duration: 12s143ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s788ms 11s847ms 11s273ms 11 2m4s create table temp0000293998 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 13 11 5 56s924ms 11s384ms 12 6 1m7s 11s179ms [ User: intelifix - Total duration: 2m4s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 2m4s - Times executed: 11 ]
-
CREATE TABLE temp0000293998 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 11:43:02 Duration: 11s847ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293998 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 12:12:17 Duration: 11s514ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293998 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-13 11:42:32 Duration: 11s436ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 181ms 1m1s 6s282ms 47 4m55s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 13 07 2 1m4s 32s484ms 08 2 7s585ms 3s792ms 09 4 39s978ms 9s994ms 10 3 22s5ms 7s335ms 11 4 16s393ms 4s98ms 12 1 4s80ms 4s80ms 13 6 39s586ms 6s597ms 14 2 10s871ms 5s435ms 15 11 39s804ms 3s618ms 16 8 33s762ms 4s220ms 17 3 11s768ms 3s922ms 18 1 4s482ms 4s482ms [ User: intelifix - Total duration: 4m55s - Times executed: 47 ]
[ Application: psql - Total duration: 4m55s - Times executed: 47 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (031037);
Date: 2026-10-13 07:25:36 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (031057);
Date: 2026-10-13 13:23:22 Duration: 23s245ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (031046);
Date: 2026-10-13 09:53:15 Duration: 18s736ms Database: rio User: intelifix Remote: [local] Application: psql
13 757ms 33s311ms 5s338ms 60 5m20s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 13 07 2 12s546ms 6s273ms 08 2 8s673ms 4s336ms 09 9 22s781ms 2s531ms 10 7 1m24s 12s82ms 11 3 23s241ms 7s747ms 13 4 28s889ms 7s222ms 14 3 20s578ms 6s859ms 15 7 43s949ms 6s278ms 16 8 23s482ms 2s935ms 17 13 36s899ms 2s838ms 18 2 14s667ms 7s333ms [ User: intelifix - Total duration: 5m20s - Times executed: 60 ]
[ Application: [unknown] - Total duration: 5m20s - Times executed: 60 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-13', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-13 10:10:21 Duration: 33s311ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-13', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-13 10:49:33 Duration: 23s865ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-13', 099, '', '', 0, 6, '2026-10-01');
Date: 2026-10-13 11:28:56 Duration: 17s210ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 690ms 10s273ms 3s468ms 36 2m4s 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 #14
Day Hour Count Duration Avg duration Oct 13 08 2 6s577ms 3s288ms 09 3 12s301ms 4s100ms 10 3 13s459ms 4s486ms 11 3 14s750ms 4s916ms 12 2 3s997ms 1s998ms 13 2 5s606ms 2s803ms 14 2 7s687ms 3s843ms 15 3 26s154ms 8s718ms 16 2 11s162ms 5s581ms 17 2 9s232ms 4s616ms 18 2 5s579ms 2s789ms 19 3 2s481ms 827ms 20 3 2s489ms 829ms 21 2 1s829ms 914ms 22 2 1s561ms 780ms [ User: intelifix - Total duration: 2m4s - Times executed: 36 ]
[ Application: psql - Total duration: 2m4s - Times executed: 36 ]
-
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-13 15:00:11 Duration: 10s273ms 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-13 15:40:09 Duration: 8s174ms 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-13 15:20:08 Duration: 7s706ms Database: rio User: intelifix Remote: [local] Application: psql
15 158ms 12s816ms 3s120ms 127 6m36s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 13 00 1 300ms 300ms 05 1 166ms 166ms 07 10 46s629ms 4s662ms 08 12 47s735ms 3s977ms 09 12 48s711ms 4s59ms 10 12 50s338ms 4s194ms 11 12 44s253ms 3s687ms 12 12 20s821ms 1s735ms 13 12 16s514ms 1s376ms 14 12 37s872ms 3s156ms 15 12 35s287ms 2s940ms 16 11 33s512ms 3s46ms 17 7 13s950ms 1s992ms 20 1 158ms 158ms [ User: intelifix - Total duration: 6m36s - Times executed: 127 ]
[ Application: psql - Total duration: 6m36s - Times executed: 127 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-13 07:25:14 Duration: 12s816ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-13 08:55:14 Duration: 12s353ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-13 10:15:10 Duration: 9s139ms Database: rio User: intelifix Remote: [local] Application: psql
16 150ms 1m 3s22ms 44 2m12s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 13 07 2 1s386ms 693ms 08 4 1s128ms 282ms 09 4 1m1s 15s499ms 10 2 41s808ms 20s904ms 11 6 15s300ms 2s550ms 12 2 2s806ms 1s403ms 13 3 634ms 211ms 14 1 666ms 666ms 15 9 3s945ms 438ms 16 7 2s103ms 300ms 17 3 1s26ms 342ms 18 1 192ms 192ms [ User: intelifix - Total duration: 2m12s - Times executed: 44 ]
[ Application: psql - Total duration: 2m12s - Times executed: 44 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (031045);
Date: 2026-10-13 09:48:13 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (031047);
Date: 2026-10-13 10:39:29 Duration: 41s532ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 508); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (031052);
Date: 2026-10-13 11:43:02 Duration: 14s293ms Database: rio User: intelifix Remote: [local] Application: psql
17 562ms 25s853ms 2s291ms 53 2m1s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 13 08 4 16s567ms 4s141ms 09 3 2s247ms 749ms 10 3 2s428ms 809ms 11 3 5s589ms 1s863ms 12 4 7s821ms 1s955ms 13 4 9s468ms 2s367ms 14 4 11s593ms 2s898ms 15 3 2s800ms 933ms 16 3 5s158ms 1s719ms 17 4 12s247ms 3s61ms 18 4 34s372ms 8s593ms 19 3 2s316ms 772ms 20 3 2s458ms 819ms 21 4 3s286ms 821ms 22 4 3s82ms 770ms [ User: intelifix - Total duration: 2m1s - Times executed: 53 ]
[ Application: psql - Total duration: 2m1s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-13 18:00:32 Duration: 25s853ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-13 08:40:15 Duration: 13s996ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-13 17:00:11 Duration: 9s841ms Database: rio User: intelifix Remote: [local] Application: psql
18 174ms 29s840ms 1s736ms 274 7m55s call rs_giga_triagem (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 13 00 12 37s219ms 3s101ms 01 12 16s777ms 1s398ms 02 12 17s40ms 1s420ms 03 12 16s268ms 1s355ms 04 12 16s11ms 1s334ms 05 12 16s193ms 1s349ms 06 12 16s15ms 1s334ms 07 12 18s41ms 1s503ms 08 12 52s24ms 4s335ms 09 12 18s740ms 1s561ms 10 12 19s936ms 1s661ms 11 12 19s253ms 1s604ms 12 12 17s997ms 1s499ms 13 12 17s228ms 1s435ms 14 12 20s241ms 1s686ms 15 12 22s880ms 1s906ms 16 12 20s81ms 1s673ms 17 12 18s115ms 1s509ms 18 12 17s805ms 1s483ms 19 12 17s153ms 1s429ms 20 11 26s376ms 2s397ms 21 12 17s514ms 1s459ms 22 11 16s890ms 1s535ms [ User: intelifix - Total duration: 7m55s - Times executed: 274 ]
[ Application: psql - Total duration: 7m55s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-13 08:45:34 Duration: 29s840ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-13 00:05:20 Duration: 18s297ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-13 20:15:08 Duration: 7s37ms Database: rio User: intelifix Remote: [local] Application: psql
19 1s431ms 1s746ms 1s529ms 49 1m14s create table temp0000294014 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 13 14 3 4s525ms 1s508ms 15 26 39s601ms 1s523ms 16 14 21s559ms 1s539ms 17 6 9s235ms 1s539ms [ User: intelifix - Total duration: 1m14s - Times executed: 49 ]
[ Application: [unknown] - Total duration: 1m14s - Times executed: 49 ]
-
CREATE TABLE temp0000294014 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"08-10-2026", "ate" :"13-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-13 15:12:10 Duration: 1s746ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000294014 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"08-10-2026", "ate" :"13-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-13 15:50:13 Duration: 1s668ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000294014 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"08-10-2026", "ate" :"13-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-13 16:23:26 Duration: 1s643ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 153ms 15s996ms 1s260ms 114 2m23s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 13 07 7 7s400ms 1s57ms 08 15 18s741ms 1s249ms 09 7 6s627ms 946ms 10 8 8s600ms 1s75ms 11 9 8s848ms 983ms 13 18 58s440ms 3s246ms 14 7 4s740ms 677ms 15 17 17s132ms 1s7ms 16 7 4s919ms 702ms 17 8 4s536ms 567ms 18 4 1s83ms 270ms 19 7 2s579ms 368ms [ User: intelifix - Total duration: 2m23s - Times executed: 114 ]
[ Application: [unknown] - Total duration: 2m23s - Times executed: 114 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059277) LIMIT 1;
Date: 2026-10-13 13:43:23 Duration: 15s996ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059276) LIMIT 1;
Date: 2026-10-13 13:43:53 Duration: 11s429ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059782) LIMIT 1;
Date: 2026-10-13 13:42:37 Duration: 9s922ms 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 7 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Oct 13 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 17 1 0ms 0ms 22 2 0ms 0ms [ User: intelifix - Total duration: 2s702ms - Times executed: 7 ]
[ Application: [unknown] - Total duration: 1s539ms - Times executed: 5 ]
[ Application: psql - Total duration: 1s163ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 14,423 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 26 FATAL entries
- 3321 ERROR entries
- 0 WARNING entries
- 4 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,268 Max number of times the same event was reported
- 3,351 Total events found
Rank Times reported Error 1 3,268 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 13 07 236 08 262 09 247 10 360 11 389 12 147 13 122 14 478 15 399 16 383 17 236 18 9 - ERROR: prepared statement "_PLAN0000000035DA5290" does not exist
- ERROR: prepared statement "_PLAN0000000035DA5720" does not exist
- ERROR: prepared statement "_PLAN0000000035DA2E10" does not exist
Statement: DEALLOCATE "_PLAN0000000035DA5290"
Date: 2026-10-13 07:06:35 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000035DA5720"
Date: 2026-10-13 07:07:36 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000035DA2E10"
Date: 2026-10-13 07:08:40 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 20 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 13 08 3 09 3 11 4 12 1 13 2 14 2 16 1 17 4 - ERROR: syntax error at or near "]" at character 27
- ERROR: syntax error at or near "]" at character 27
- ERROR: syntax error at or near "]" at character 27
Statement: select * from rs_caixa_qr(])
Date: 2026-10-13 08:42:42 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(])
Date: 2026-10-13 08:42:42 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(])
Date: 2026-10-13 08:50:18 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
3 19 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 13 03 5 05 4 06 3 08 2 11 2 12 1 19 2 - FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-10-13 03:18:08 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-13 03:30:07 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-13 03:30:22 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
4 14 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 13 08 3 09 3 10 1 13 2 14 2 16 3 - ERROR: trailing junk after numeric literal at or near "88Ç0FÇA2ÇB0Ç29Ç7F" at character 27
- ERROR: trailing junk after numeric literal at or near "88Ç0FÇA2ÇB0Ç29Ç7F" at character 27
- ERROR: trailing junk after numeric literal at or near "88Ç0FÇA2ÇB0Ç29Ç7F" at character 27
Statement: SELECT * FROM RS_ETIQUETA(88Ç0FÇA2ÇB0Ç29Ç7F)
Date: 2026-10-13 08:00:00 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(88Ç0FÇA2ÇB0Ç29Ç7F)
Date: 2026-10-13 08:00:00 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(88Ç0FÇA2ÇB0Ç29Ç7F) /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-13 08:00:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
5 7 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 13 10 1 16 6 - ERROR: unterminated quoted string at or near "'8C444F7B9BA3'' )" at character 43
- ERROR: unterminated quoted string at or near "'229853397891'');" at character 39
- ERROR: unterminated quoted string at or near "'831084912000959'');" at character 39
Statement: SELECT SAIDA FROM RS_SMARTCARD_TELA( 039, '8C444F7B9BA3'' )
Date: 2026-10-13 10:48:52 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('229853397891'');
Date: 2026-10-13 16:22:41 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('831084912000959'');
Date: 2026-10-13 16:24:10 Database: rio Application: [unknown] User: intelifix Remote: [local]
6 5 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 13 09 2 15 3 - ERROR: column "b85e71ba3e84" does not exist at character 27
- ERROR: column "b85e71ba3e84" does not exist at character 27
- ERROR: column "dcÇ97Çe6ÇbbÇ7bÇ55" does not exist at character 27
Statement: select * from rs_caixa_qr(B85E71BA3E84)
Date: 2026-10-13 09:43:23 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(B85E71BA3E84)
Date: 2026-10-13 09:43:23 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DCÇ97ÇE6ÇBBÇ7BÇ55)
Date: 2026-10-13 15:27:00 Database: rio Application: [unknown] User: etiquetas Remote: [local]
7 5 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #7
Day Hour Count Oct 13 03 5 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-10-13 03:05:01 Database: rio Application: psql User: intelifix Remote: [local]
Date: 2026-10-13 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-13 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
8 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Oct 13 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-13 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-13 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-13 05:32:05 Database: contagem Application: psql User: intelifix Remote: [local]
9 3 ERROR: function rs_caixa_qr(...) does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Oct 13 11 3 - ERROR: function rs_caixa_qr(numeric) does not exist at character 15
- ERROR: function rs_caixa_qr(numeric) does not exist at character 15
- ERROR: function rs_caixa_qr(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select * from rs_caixa_qr(407400.)Date: 2026-10-13 11:39:47 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select * from rs_caixa_qr(407400.)Date: 2026-10-13 11:39:47 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select * from rs_caixa_qr(407400.)Date: 2026-10-13 11:39:49 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
10 3 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #10
Day Hour Count Oct 13 08 1 16 2 - LOG: process 955890 still waiting for ShareLock on transaction 7609620 after 1000.098 ms
- LOG: process 1244953 still waiting for ShareLock on transaction 7637383 after 1000.087 ms
- LOG: process 1244953 still waiting for ShareLock on transaction 7637383 after 9817.992 ms
Detail: Process holding the lock: 942306. Wait queue: 955890.
Context: while updating tuple (82396,58) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer,boolean) line 139 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-10-13 08:45:06 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1228994. Wait queue: 1244953.
Context: while updating tuple (18718,37) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer,boolean) line 142 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1044 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(295397,184,'CP2526LV3VP,B85E710FF270','',0185,00,'[{"item":"0","qrcode":""}]','','',00);Date: 2026-10-13 16:10:14 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1228994. Wait queue: 1244953.
Context: while updating tuple (18718,37) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer,boolean) line 142 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1044 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(295397,184,'CP2526LV3VP,B85E710FF270','',0185,00,'[{"item":"0","qrcode":""}]','','',00);Date: 2026-10-13 16:10:23 Database: rio Application: [unknown] User: intelifix Remote: [local]
11 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #11
Day Hour Count Oct 13 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-10-13 03:05:02 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-13 03:05:02 Database: rio Application: [unknown] User: intelifix Remote: [local]
12 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #12
Day Hour Count Oct 13 03 1 - LOG: database system was shut down at 2026-10-13 03:05:02 -03
Date: 2026-10-13 03:05:02