pgBadger-
Global information
- Generated on Wed Jul 22 23:50:11 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 45,215 log entries in 10s
- Log start from 2026-07-22 00:00:10 to 2026-07-22 23:49:47
-
Overview
Global Stats
- 407 Number of unique normalized queries
- 7,441 Number of queries
- 8h34m1s Total query duration
- 2026-07-22 00:02:26 First query
- 2026-07-22 23:49:47 Last query
- 5 queries/s at 2026-07-22 12:05:08 Query peak
- 8h34m1s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h34m1s Execute total duration
- 3,647 Number of events
- 17 Number of unique normalized events
- 3,485 Max number of times the same event was reported
- 0 Number of cancellation
- 475 Total number of automatic vacuums
- 1,056 Total number of automatic analyzes
- 10 Number temporary file
- 236.43 MiB Max size of temporary file
- 109.94 MiB Average size of temporary file
- 360 Total number of sessions
- 9 sessions at 2026-07-22 13:10:24 Session peak
- 13d7h15m8s Total duration of sessions
- 53m12s Average duration of sessions
- 20 Average queries per session
- 1m25s Average queries duration per session
- 51m46s Average idle time per session
- 367 Total number of connections
- 5 connections/s at 2026-07-22 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-22 12:05:08 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-22 13:34:30 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-22 23:49:16 Date
Queries duration
Key values
- 8h34m1s 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) Jul 22 00 28 0ms 24s23ms 4s681ms 4s477ms 5s586ms 1m15s 01 28 0ms 3s525ms 1s144ms 4s200ms 5s122ms 6s238ms 02 18 0ms 3s703ms 1s705ms 4s676ms 5s106ms 6s29ms 03 20 0ms 9s472ms 1s933ms 3s804ms 6s433ms 10s873ms 04 19 0ms 3s890ms 1s780ms 3s871ms 5s525ms 7s240ms 05 45 0ms 8m33s 23s878ms 14s270ms 2m21s 8m33s 06 30 0ms 8s715ms 2s326ms 3s754ms 5s582ms 29s53ms 07 250 0ms 8m22s 8s169ms 41s220ms 4m37s 8m24s 08 662 150ms 7m7s 3s227ms 1m20s 4m17s 7m49s 09 881 150ms 8m45s 3s877ms 4m50s 6m12s 8m47s 10 696 150ms 8m54s 3s61ms 54s723ms 5m 9m 11 905 150ms 9m33s 3s69ms 57s66ms 6m32s 10m23s 12 211 0ms 8m14s 4s665ms 21s705ms 48s54ms 8m53s 13 547 0ms 5m31s 1s918ms 30s435ms 50s952ms 5m33s 14 896 150ms 6m34s 2s214ms 1m1s 4m34s 6m49s 15 634 150ms 7m24s 3s942ms 2m20s 4m51s 7m28s 16 602 150ms 6m50s 4s31ms 1m15s 3m49s 11m55s 17 419 151ms 7m23s 3s556ms 41s826ms 1m33s 7m27s 18 24 0ms 6m35s 29s661ms 1m13s 3m34s 6m35s 19 21 0ms 5m46s 30s126ms 3m36s 5m46s 5m46s 20 118 0ms 7m34s 12s290ms 1m44s 4m16s 8m4s 21 33 0ms 6m22s 20s840ms 16s716ms 3m40s 6m56s 22 27 0ms 5m34s 23s553ms 3m38s 5m34s 5m34s 23 327 0ms 1m35s 7s256ms 1m7s 1m9s 1m35s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 22 00 6 0 5s165ms 0ms 0ms 1s109ms 01 10 0 292ms 0ms 159ms 880ms 02 0 0 0ms 0ms 0ms 0ms 03 2 0 430ms 0ms 0ms 0ms 04 2 0 500ms 0ms 0ms 0ms 05 23 0 294ms 182ms 348ms 1s44ms 06 8 0 1s983ms 0ms 0ms 1s177ms 07 172 0 9s190ms 3s205ms 15s947ms 5m25s 08 505 0 3s251ms 14s411ms 1m8s 4m50s 09 725 0 3s765ms 19s71ms 4m50s 6m9s 10 549 0 3s154ms 17s807ms 34s907ms 5m54s 11 712 0 3s109ms 16s888ms 37s965ms 6m31s 12 139 0 6s435ms 2s275ms 9s138ms 3m43s 13 426 0 1s995ms 7s449ms 15s636ms 3m22s 14 696 0 2s375ms 18s880ms 38s558ms 5m40s 15 480 0 4s416ms 14s730ms 2m16s 5m2s 16 439 0 4s484ms 28s672ms 45s749ms 4m22s 17 285 0 4s186ms 19s969ms 25s581ms 4m9s 18 9 0 1m16s 0ms 1m13s 6m35s 19 6 0 1m40s 46s716ms 3m32s 5m46s 20 13 90 13s760ms 1m11s 1m44s 7m34s 21 14 0 46s632ms 1s47ms 16s716ms 6m56s 22 6 0 1m39s 262ms 3m38s 5m34s 23 7 320 7s256ms 1m4s 1m7s 1m35s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 22 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 Jul 22 00 0 1 1.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 1 1.00 0.00% 05 0 3 3.00 0.00% 06 0 2 2.00 0.00% 07 0 11 11.00 0.00% 08 0 16 16.00 0.00% 09 0 17 17.00 0.00% 10 0 13 13.00 0.00% 11 0 18 18.00 0.00% 12 0 8 8.00 0.00% 13 0 14 14.00 0.00% 14 0 18 18.00 0.00% 15 0 10 10.00 0.00% 16 0 13 13.00 0.00% 17 0 7 7.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 2 2.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jul 22 00 15 0.00/s 01 9 0.00/s 02 7 0.00/s 03 17 0.00/s 04 10 0.00/s 05 10 0.00/s 06 15 0.00/s 07 22 0.01/s 08 23 0.01/s 09 26 0.01/s 10 17 0.00/s 11 25 0.01/s 12 15 0.00/s 13 22 0.01/s 14 23 0.01/s 15 25 0.01/s 16 18 0.01/s 17 17 0.00/s 18 8 0.00/s 19 6 0.00/s 20 13 0.00/s 21 8 0.00/s 22 7 0.00/s 23 9 0.00/s Day Hour Count Average Duration Average idle time Jul 22 00 2 1h 58m54s 01 14 1h1m14s 1h1m12s 02 9 1h20s 1h16s 03 15 20m9s 20m7s 04 9 1h2m40s 1h2m36s 05 11 56m16s 54m38s 06 9 57m14s 57m6s 07 15 59m40s 57m24s 08 21 56m25s 54m43s 09 23 54m29s 52m 10 24 56m31s 55m2s 11 20 51m32s 49m13s 12 23 54m50s 54m8s 13 17 50m44s 49m42s 14 22 50m54s 49m24s 15 23 52m 50m11s 16 21 58m58s 57m2s 17 20 54m32s 53m18s 18 15 1h24s 59m36s 19 8 1h13s 58m54s 20 10 38m3s 35m38s 21 9 54m26s 53m10s 22 8 1h23s 59m3s 23 12 33m33s 30m16s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-22 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 367 connections Total
Connections per user
Key values
- intelifix Main User
- 367 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2026-07-22 13:10:24 Date
Histogram of session times
Key values
- 288 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 360 sessions Total
Sessions per user
Key values
- intelifix Main User
- 360 sessions Total
Sessions per host
Key values
- [local] Main Host
- 360 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 60,960 buffers Checkpoint Peak
- 2026-07-22 00:09:44 Date
- 270.001 seconds Highest write time
- 0.131 seconds Sync time
Checkpoints Wal files
Key values
- 15 files Wal files usage Peak
- 2026-07-22 14:24:36 Date
Checkpoints distance
Key values
- 469.24 Mo Distance Peak
- 2026-07-22 14:24:36 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 22 00 76,271 677.068s 0.037s 677.175s 01 3,080 309.375s 0.042s 309.484s 02 1,937 194.663s 0.029s 194.734s 03 1,660 166.902s 0.035s 166.992s 04 3,357 336.758s 0.077s 336.891s 05 11,137 1,024.132s 0.081s 1,024.286s 06 5,541 501.538s 0.031s 501.601s 07 34,524 2,532.36s 0.36s 2,532.897s 08 58,154 3,238.003s 0.72s 3,238.946s 09 78,419 3,238.778s 0.712s 3,239.752s 10 73,267 3,238.628s 0.715s 3,239.592s 11 83,979 3,238.727s 0.826s 3,239.817s 12 29,763 1,800.694s 0.224s 1,801.034s 13 31,596 2,406.044s 0.352s 2,406.525s 14 91,346 3,238.768s 0.723s 3,239.738s 15 84,729 3,238.976s 0.603s 3,239.791s 16 67,946 3,238.974s 0.518s 3,239.692s 17 42,543 2,648.34s 0.406s 2,648.935s 18 2,451 245.991s 0.023s 246.055s 19 35 3.582s 0.007s 3.608s 20 1,143 271.49s 0.03s 271.54s 21 2,702 272.679s 0.036s 272.795s 22 2,134 214.136s 0.051s 214.283s 23 316 33.785s 0.022s 33.862s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 22 00 0 0 11 517 0.003s 0.008s 01 0 0 1 556 0.003s 0.01s 02 0 0 0 432 0.002s 0.006s 03 0 0 1 352 0.003s 0.008s 04 0 0 7 483 0.049s 0.007s 05 0 0 5 874 0.005s 0.008s 06 0 0 1 232 0.003s 0.005s 07 0 0 20 4,200 0.016s 0.012s 08 0 0 39 6,874 0.020s 0.012s 09 0 0 51 7,487 0.012s 0.012s 10 0 0 38 7,317 0.005s 0.012s 11 0 0 38 7,864 0.005s 0.012s 12 0 0 12 3,095 0.010s 0.012s 13 0 0 14 5,337 0.006s 0.012s 14 0 0 52 7,958 0.011s 0.012s 15 0 0 46 7,052 0.009s 0.012s 16 0 0 44 6,152 0.006s 0.012s 17 0 0 33 5,449 0.004s 0.012s 18 0 0 0 362 0.003s 0.007s 19 0 0 0 11 0.002s 0.003s 20 0 0 2 89 0.004s 0.003s 21 0 0 1 373 0.004s 0.013s 22 0 0 0 416 0.023s 0.008s 23 0 0 0 29 0.008s 0.006s Day Hour Count Avg time (sec) Jul 22 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 Jul 22 00 24,613.00 kB 76,179.86 kB 01 1,673.78 kB 34,614.44 kB 02 1,646.50 kB 16,369.83 kB 03 1,092.38 kB 3,093.12 kB 04 17,301.29 kB 54,760.57 kB 05 9,265.62 kB 55,052.88 kB 06 3,593.20 kB 30,070.00 kB 07 28,134.08 kB 60,955.42 kB 08 52,561.92 kB 81,617.25 kB 09 69,622.50 kB 95,116.67 kB 10 52,421.25 kB 118,678.08 kB 11 52,045.08 kB 90,400.17 kB 12 15,887.33 kB 65,767.17 kB 13 19,443.83 kB 34,096.83 kB 14 71,043.67 kB 152,866.58 kB 15 62,682.92 kB 118,184.83 kB 16 60,098.08 kB 118,827.08 kB 17 44,012.42 kB 74,904.50 kB 18 1,690.14 kB 36,651.71 kB 19 73.00 kB 21,365.67 kB 20 8,390.33 kB 19,397.67 kB 21 1,397.40 kB 10,841.30 kB 22 1,519.00 kB 5,082.12 kB 23 152.80 kB 2,945.80 kB -
Temporary Files
Size of temporary files
Key values
- 472.86 MiB Temp Files size Peak
- 2026-07-22 05:31:59 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-22 05:32:06 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 22 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.07 GiB 109.94 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 918.54 MiB 70.52 MiB 236.43 MiB 114.82 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-22 05:32:07 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-22 05:31:59 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 180.86 MiB 90.43 MiB 90.43 MiB 90.43 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-22 05:30:41 Duration: 38s950ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-22 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 236.43 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-22 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 236.43 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-22 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 90.43 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-22 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 90.43 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-22 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 78.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-22 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 77.99 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-22 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 77.99 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-22 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 70.60 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-22 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 70.52 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-22 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 70.52 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-22 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 28.98 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-22 04:26:08 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 28.98 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-22 04:26:08 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (127) Main table analyzed (database rio)
- 1,056 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 127 rio.pg_catalog.pg_class 70 rio.pg_catalog.pg_type 59 brasilia.pg_catalog.pg_attribute 54 rio.public.temp0000286092 51 rio.public.usuarios 49 contagem.public.temp0000226658 42 rio.pg_catalog.pg_index 39 rio.pg_catalog.pg_depend 31 contagem.pg_catalog.pg_attribute 27 contagem.public.usuarios 26 rio.public.temp0000286086 24 brasilia.pg_catalog.pg_class 23 rio.public.temp0000286126 23 rio.public.temp0000286166 22 contagem.public.temp0000226674 21 brasilia.pg_catalog.pg_type 18 rio.public.temp0000286190 16 rio.public.temp0000286194 16 rio.public.temp0000286090 15 rio.public.temp0000286100 13 contagem.pg_catalog.pg_class 12 rio.public.temp0000285404 12 brasilia.pg_catalog.pg_index 11 brasilia.public.temp0000236626 10 contagem.pg_catalog.pg_type 10 brasilia.public.usuarios 10 rio.public.temp0000286080 10 brasilia.public.temp0000236678 9 rio.public.temp0000286112 8 rio.public.temp0000286084 8 brasilia.pg_catalog.pg_depend 8 rio.public.temp0000286170 8 rio.public.temp0000286124 8 rio.public.temp0000286096 8 brasilia.public.temp0000236664 7 contagem.pg_catalog.pg_index 7 rio.public.temp0000286182 7 rio.public.temp0000286094 6 brasilia.public.temp0000236622 6 brasilia.public.temp0000236618 5 rio.public.temp0000284750 5 rio.public.temp0000286162 5 contagem.pg_catalog.pg_depend 5 rio.public.temp0000286156 5 brasilia.pg_catalog.pg_shdepend 4 brasilia.public.temp0000236672 4 rio.public.temp0000286114 4 rio.public.temp0000285960 4 brasilia.public.temp0000236684 4 contagem.public.nf_entrada 3 contagem.pg_catalog.pg_shdepend 3 rio.public.temp0000286148 3 rio.public.temp0000286178 3 rio.public.tmp_drill_0175 3 brasilia.public.temp0000236700 3 brasilia.public.temp0000236698 3 rio.public.temp0000286174 3 postgres.pg_catalog.pg_shdepend 3 contagem.public.temp0000226676 2 rio.public.temp0000286206 2 rio.public.temp0000286106 2 template1.pg_catalog.pg_shdepend 2 rio.public.temp0000285824 2 brasilia.public.temp0000236686 2 rio.public.temp0000286082 2 rio.public.tmp_drill_0302 2 rio.public.temp0000286184 2 rio.public.temp0000286180 2 rio.pg_catalog.pg_shdepend 2 rio.public.temp0000286172 1 rio.public.temp0000286120 1 brasilia.public.temp0000236668 1 rio.public.temp0000286108 1 brasilia.public.temp0000236642 1 brasilia.public.temp0000236656 1 brasilia.public.temp0000236650 1 rio.public.temp0000286152 1 rio.public.temp0000286160 1 rio.public.temp0000286138 1 brasilia.public.temp0000236692 1 rio.public.temp0000286134 1 rio.public.temp0000286130 1 rio.public.temp0000286208 1 rio.public.temp0000286202 1 brasilia.public.temp0000236632 1 brasilia.public.temp0000236628 1 brasilia.public.temp0000236624 1 rio.public.temp0000285950 1 rio.public.temp0000286098 1 brasilia.public.temp0000236696 1 brasilia.public.temp0000236708 1 rio.public.temp0000286104 1 brasilia.public.temp0000236636 1 rio.public.temp0000286146 1 brasilia.public.temp0000236702 1 rio.public.temp0000286128 1 contagem.public.temp0000226612 1 rio.public.temp0000286204 1 brasilia.public.temp0000236690 1 rio.public.temp0000286136 1 Total 1,056 Vacuums per table
Key values
- public.temp0000286092 (51) Main table vacuumed on database rio
- 475 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000286092 51 0 0 0 0 0 0 29,080 4,132 7,133,179 0 0 rio.pg_catalog.pg_attribute 51 47 0 0 0 0 0 27,353 7,330 10,997,674 433 10,304 rio.pg_catalog.pg_class 38 30 0 0 0 0 0 6,554 2,092 2,938,539 100 367 rio.pg_catalog.pg_type 28 26 0 0 0 0 0 2,609 733 1,065,848 92 339 contagem.public.usuarios 25 0 0 0 0 0 0 117 88 46,657 0 0 rio.public.temp0000286190 16 0 0 0 0 0 0 13,976 5,083 7,271,550 0 0 rio.pg_catalog.pg_index 16 16 0 0 0 0 0 915 262 259,126 52 124 rio.public.temp0000286194 16 0 0 0 0 0 0 18,422 60 1,098,551 0 0 brasilia.pg_catalog.pg_attribute 14 14 0 0 0 0 0 6,524 2,015 3,073,156 73 1,988 rio.pg_catalog.pg_depend 14 14 0 0 0 0 0 4,376 1,546 2,148,104 93 783 rio.public.usuarios 10 2 0 0 0 0 0 76 15 22,872 5 8 contagem.pg_catalog.pg_attribute 10 10 0 0 0 0 0 7,072 1,376 2,782,531 24 802 rio.public.temp0000285404 9 0 0 0 0 0 0 790 51 54,889 0 0 rio.public.temp0000286126 9 0 0 0 0 0 0 2,262 203 443,993 0 0 rio.public.temp0000286112 8 0 0 0 0 0 0 844 388 649,165 0 0 rio.public.temp0000286124 8 0 0 0 0 0 0 10,030 3,367 4,886,312 0 0 rio.pg_catalog.pg_statistic 8 8 0 0 0 0 0 10,151 2,359 10,798,892 864 4,105 rio.public.temp0000286166 8 0 0 0 0 0 0 2,487 46 154,009 0 0 rio.pg_catalog.pg_shdepend 7 7 0 0 0 0 0 813 262 440,144 46 100 rio.public.temp0000286182 7 0 0 0 0 0 0 10,034 1,696 2,741,426 0 0 rio.public.temp0000286170 6 0 0 0 0 0 0 634 174 289,808 0 0 brasilia.pg_catalog.pg_class 6 6 0 0 0 0 0 1,018 453 681,135 24 92 contagem.pg_catalog.pg_type 5 5 0 0 0 0 0 637 102 199,889 1 2 rio.public.temp0000286162 5 0 0 0 0 0 0 6,689 1,687 2,540,908 0 0 brasilia.pg_catalog.pg_type 5 5 0 0 0 0 0 433 172 211,188 11 34 contagem.pg_catalog.pg_class 5 5 0 0 0 0 0 1,278 151 302,855 3 6 contagem.public.temp0000226674 4 0 0 0 0 0 0 424 24 28,832 0 0 rio.public.temp0000284750 4 0 0 0 0 0 0 305 23 21,534 0 0 rio.public.temp0000286114 4 0 0 0 0 0 0 16 13 5,068 0 0 rio.public.temp0000285960 4 0 0 0 0 0 0 323 19 22,127 0 0 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 2,206 450 2,590,555 163 461 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 271 60 67,776 2 2 brasilia.pg_catalog.pg_index 3 3 0 0 0 0 0 176 60 45,751 11 19 rio.public.tmp_drill_0175 3 3 0 0 0 0 0 101 9 22,740 0 0 brasilia.pg_catalog.pg_depend 3 3 0 0 0 0 0 954 374 509,261 10 90 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,107 505 2,047,295 334 2,370 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 1,186 219 512,003 3 18 rio.public.temp0000286148 3 0 0 0 0 0 0 5,013 12 297,576 0 0 rio.public.temp0000286178 3 0 0 0 0 0 0 315 122 226,425 0 0 rio.public.temp0000286206 2 0 0 0 0 0 0 1,677 7 100,084 0 0 brasilia.public.temp0000236698 2 0 0 0 0 0 0 250 11 16,941 0 0 rio.public.temp0000286180 2 0 0 0 0 0 0 1,766 10 105,725 0 0 template1.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 297 92 137,951 21 48 rio.public.temp0000286106 2 0 0 0 0 0 0 83 9 6,333 0 0 rio.public.temp0000285824 2 0 0 0 0 0 0 87 83 153,087 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 386 83 292,754 25 60 contagem.public.temp0000226676 2 0 0 0 0 0 0 213 12 14,466 0 0 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,125 1,210 3,807,535 1,088 7,428 rio.public.tmp_drill_0302 2 2 0 0 0 0 0 52 6 11,645 0 0 brasilia.public.temp0000236650 1 0 0 0 0 0 0 242 6 15,413 0 0 contagem.auditor.auditor_2026_07 1 0 0 0 0 0 0 34,333 17,846 23,080,513 7,779 166,940 rio.public.temp0000286138 1 0 0 0 0 0 0 83 6 5,805 0 0 rio.public.temp0000286094 1 0 0 0 0 0 0 8 5 1,293 0 0 rio.public.temp0000286174 1 0 0 0 0 0 0 93 6 6,413 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 171 65 188,256 24 76 rio.public.temp0000286086 1 0 0 0 0 0 0 105 6 7,146 0 0 rio.public.temp0000286156 1 0 0 0 0 0 0 8 5 1,295 0 0 contagem.public.acessorios 1 1 0 0 0 0 0 475 343 1,150,838 6 461 rio.public.temp0000286134 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000286130 1 0 0 0 0 0 0 81 6 5,681 0 0 rio.public.temp0000286202 1 0 0 0 0 0 0 1,672 4 99,251 0 0 rio.public.temp0000286204 1 0 0 0 0 0 0 1,673 4 99,310 0 0 brasilia.public.temp0000236690 1 0 0 0 0 0 0 242 6 15,413 0 0 rio.public.temp0000286136 1 0 0 0 0 0 0 86 85 164,024 0 0 rio.public.temp0000286120 1 0 0 0 0 0 0 81 6 5,681 0 0 rio.public.temp0000286172 1 0 0 0 0 0 0 93 6 6,413 0 0 brasilia.public.temp0000236628 1 0 0 0 0 0 0 242 6 15,415 0 0 contagem.public.nf_entrada 1 1 0 0 0 0 0 134 31 48,703 2 6 brasilia.public.temp0000236636 1 0 0 0 0 0 0 242 6 15,415 0 0 rio.public.equipamentos_referencia 1 0 0 0 0 0 0 338 262 899,179 36 6,622 rio.public.temp0000286108 1 0 0 0 0 0 0 79 78 149,815 0 0 brasilia.public.temp0000236642 1 0 0 0 0 0 0 243 6 15,469 0 0 rio.auditor.auditor_2026_07 1 0 0 0 0 0 0 93,458 88,614 108,602,874 2,585 54,867 rio.public.temp0000286128 1 0 0 0 0 0 0 80 6 5,623 0 0 Total 475 229 0 0 0 0 0 322,773 146,673 208,881,876 13,910 258,522 Vacuum throughput per table
Key values
- auditor.auditor_2026_07 (28.98) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000286092 0 0 1.71 rio.pg_catalog.pg_attribute 0 0 3.82 rio.pg_catalog.pg_class 0 0 1.05 rio.pg_catalog.pg_type 0 0 0.37 contagem.public.usuarios 0 0 0 rio.public.temp0000286190 0 0 0.62 rio.pg_catalog.pg_index 0 0 0.25 rio.public.temp0000286194 0 0 0.8 brasilia.pg_catalog.pg_attribute 0 0 1.22 rio.pg_catalog.pg_depend 0 0 0.94 rio.public.usuarios 0 0 0 contagem.pg_catalog.pg_attribute 0 0 0.92 rio.public.temp0000285404 0 0 0.14 rio.public.temp0000286126 0 0 0.22 rio.public.temp0000286112 0 0 0.13 rio.public.temp0000286124 0 0 0.47 rio.pg_catalog.pg_statistic 0 0 1.25 rio.public.temp0000286166 0 0 0.16 rio.pg_catalog.pg_shdepend 0 0 0.4 rio.public.temp0000286182 0 0 0.35 rio.public.temp0000286170 0 0 0.11 brasilia.pg_catalog.pg_class 0 0 0.23 contagem.pg_catalog.pg_type 0 0 0.14 rio.public.temp0000286162 0 0 0.27 brasilia.pg_catalog.pg_type 0 0 0.09 contagem.pg_catalog.pg_class 0 0 0.28 contagem.public.temp0000226674 0 0 0.06 rio.public.temp0000284750 0 0 0.06 rio.public.temp0000286114 0 0 0.18 rio.public.temp0000285960 0 0 0.04 rio.pg_toast.pg_toast_2619 0 0 0.19 contagem.pg_catalog.pg_index 0 0 0.22 brasilia.pg_catalog.pg_index 0 0 0.04 rio.public.tmp_drill_0175 0 0 0 brasilia.pg_catalog.pg_depend 0 0 0.27 brasilia.pg_catalog.pg_statistic 0 0 0.32 contagem.pg_catalog.pg_depend 0 0 0.16 rio.public.temp0000286148 0 0 0.16 rio.public.temp0000286178 0 0 0.05 rio.public.temp0000286206 0 0 0.09 brasilia.public.temp0000236698 0 0 0.04 rio.public.temp0000286180 0 0 0.06 template1.pg_catalog.pg_shdepend 0 0 0.12 rio.public.temp0000286106 0 0 0.07 rio.public.temp0000285824 0 0 0.05 brasilia.pg_toast.pg_toast_2619 0 0 0.02 contagem.public.temp0000226676 0 0 0.02 contagem.pg_catalog.pg_statistic 0 0 0.25 rio.public.tmp_drill_0302 0 0 0 brasilia.public.temp0000236650 0 0 0.02 contagem.auditor.auditor_2026_07 0 0 6.01 rio.public.temp0000286138 0 0 0.01 rio.public.temp0000286094 0 0 0.02 rio.public.temp0000286174 0 0 0.01 contagem.pg_toast.pg_toast_2619 0 0 0.02 rio.public.temp0000286086 0 0 0.02 rio.public.temp0000286156 0 0 0.02 contagem.public.acessorios 0 0 0.16 rio.public.temp0000286134 0 0 0.05 rio.public.temp0000286130 0 0 0.02 rio.public.temp0000286202 0 0 0.05 rio.public.temp0000286204 0 0 0.05 brasilia.public.temp0000236690 0 0 0.02 rio.public.temp0000286136 0 0 0.02 rio.public.temp0000286120 0 0 0.01 rio.public.temp0000286172 0 0 0.01 brasilia.public.temp0000236628 0 0 0.02 contagem.public.nf_entrada 0 0 0.02 brasilia.public.temp0000236636 0 0 0.02 rio.public.equipamentos_referencia 0 0 0.1 rio.public.temp0000286108 0 0 0.02 brasilia.public.temp0000236642 0 0 0.03 rio.auditor.auditor_2026_07 0 0 28.98 rio.public.temp0000286128 0 0 0.02 Total 0 0 54.14 Tuples removed per table
Key values
- pg_catalog.pg_attribute (204856) Main table with removed tuples on database rio
- 392595 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 51 47 204,856 1,262,205 52,887 310 30,967 contagem.pg_catalog.pg_attribute 10 10 57,603 235,305 0 397 5,721 brasilia.pg_catalog.pg_attribute 14 14 47,611 309,619 0 38 7,571 rio.pg_catalog.pg_statistic 8 8 14,046 67,714 817 0 10,288 rio.pg_catalog.pg_type 28 26 10,357 66,500 2,304 18 1,991 rio.pg_catalog.pg_depend 14 14 9,818 256,630 2,946 0 2,618 brasilia.pg_catalog.pg_statistic 3 3 6,372 23,907 0 0 3,216 contagem.pg_catalog.pg_statistic 2 2 5,416 14,921 0 0 2,022 rio.pg_catalog.pg_class 38 30 4,331 147,863 12,332 44 5,207 rio.pg_catalog.pg_shdepend 7 7 4,305 96,959 1,774 0 813 rio.auditor.auditor_2026_07 1 0 4,294 14,685,308 0 0 680,140 rio.pg_catalog.pg_index 16 16 4,256 31,401 515 9 886 contagem.pg_catalog.pg_type 5 5 3,884 12,018 0 40 368 brasilia.pg_catalog.pg_depend 3 3 3,499 53,258 0 11 528 contagem.pg_catalog.pg_index 4 4 1,898 7,587 0 18 225 contagem.public.usuarios 25 0 1,623 575 0 0 50 template1.pg_catalog.pg_shdepend 2 2 1,327 27,089 0 0 230 brasilia.pg_catalog.pg_class 6 6 1,288 20,220 0 0 672 rio.pg_toast.pg_toast_2619 4 4 1,265 2,825 8 0 1,164 contagem.pg_catalog.pg_depend 3 3 1,134 59,578 0 54 570 contagem.pg_catalog.pg_class 5 5 942 18,984 0 101 753 brasilia.pg_catalog.pg_type 5 5 862 11,061 0 0 325 brasilia.pg_catalog.pg_index 3 3 550 5,617 0 5 159 rio.public.usuarios 10 2 313 7,141 2,051 0 160 contagem.public.nf_entrada 1 1 244 952 0 0 69 brasilia.pg_toast.pg_toast_2619 2 2 229 270 0 0 138 contagem.pg_toast.pg_toast_2619 1 1 128 112 0 26 38 contagem.public.acessorios 1 1 106 20,212 0 0 194 rio.public.equipamentos_referencia 1 0 38 5,218,222 0 0 28,208 brasilia.public.temp0000236650 1 0 0 3,126 0 22 234 rio.public.temp0000286206 2 0 0 47,100 0 0 3,456 rio.public.temp0000286170 6 0 0 31,255 0 137 695 contagem.public.temp0000226674 4 0 0 5,109 0 120 392 rio.public.temp0000285404 9 0 0 44,828 0 414 994 brasilia.public.temp0000236698 2 0 0 6,252 0 44 468 rio.public.temp0000286180 2 0 0 25,135 0 43 1,813 contagem.auditor.auditor_2026_07 1 0 0 2,507,419 0 0 108,069 rio.public.temp0000286190 16 0 0 223,579 0 266 16,182 rio.public.temp0000286138 1 0 0 1,350 0 53 75 rio.public.temp0000286094 1 0 0 1,353 0 53 75 rio.public.temp0000286092 51 0 0 512,295 0 1,640 36,888 rio.public.temp0000286106 2 0 0 24,801 0 57 1,799 rio.public.temp0000284750 4 0 0 16,479 0 117 363 rio.public.temp0000286174 1 0 0 1,588 0 43 85 rio.public.temp0000286112 8 0 0 39,933 0 265 887 rio.public.temp0000286086 1 0 0 1,753 0 31 97 rio.public.temp0000285824 2 0 0 2,564 0 114 142 rio.public.temp0000286156 1 0 0 3,738 0 45 83 rio.public.temp0000286126 9 0 0 37,227 0 304 2,256 rio.public.temp0000286114 4 0 0 94,022 0 0 6,912 rio.public.temp0000286134 1 0 0 23,519 0 0 1,728 rio.public.temp0000286130 1 0 0 1,307 0 55 73 rio.public.temp0000286124 8 0 0 188,108 0 0 13,824 rio.public.temp0000285960 4 0 0 19,415 0 74 438 rio.public.temp0000286182 7 0 0 164,740 0 0 12,096 rio.public.temp0000286202 1 0 0 23,545 0 0 1,728 rio.public.temp0000286204 1 0 0 23,548 0 0 1,728 brasilia.public.temp0000236690 1 0 0 3,126 0 22 234 rio.public.tmp_drill_0175 3 3 0 1,132 0 0 32 rio.public.temp0000286136 1 0 0 1,404 0 50 78 rio.public.temp0000286120 1 0 0 1,298 0 55 73 rio.public.temp0000286172 1 0 0 1,588 0 43 85 brasilia.public.temp0000236628 1 0 0 3,126 0 22 234 contagem.public.temp0000226676 2 0 0 2,554 0 60 196 rio.public.temp0000286162 5 0 0 117,637 0 0 8,640 rio.public.temp0000286166 8 0 0 50,515 0 265 2,487 brasilia.public.temp0000236636 1 0 0 3,126 0 22 234 rio.public.temp0000286108 1 0 0 1,282 0 57 71 brasilia.public.temp0000236642 1 0 0 3,126 0 22 234 rio.public.temp0000286148 3 0 0 70,567 0 0 5,184 rio.public.temp0000286178 3 0 0 5,352 0 93 291 rio.public.temp0000286194 16 0 0 376,772 0 0 27,648 rio.public.tmp_drill_0302 2 2 0 449 0 0 13 rio.public.temp0000286128 1 0 0 1,307 0 56 72 Total 475 229 392,595 27,383,502 75,634 5,735 1,044,677 Pages removed per table
Key values
- public.temp0000286092 (1640) Main table with removed pages on database rio
- 5735 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000286092 51 0 0 1640 rio.public.temp0000285404 9 0 0 414 contagem.pg_catalog.pg_attribute 10 10 57603 397 rio.pg_catalog.pg_attribute 51 47 204856 310 rio.public.temp0000286126 9 0 0 304 rio.public.temp0000286190 16 0 0 266 rio.public.temp0000286112 8 0 0 265 rio.public.temp0000286166 8 0 0 265 rio.public.temp0000286170 6 0 0 137 contagem.public.temp0000226674 4 0 0 120 rio.public.temp0000284750 4 0 0 117 rio.public.temp0000285824 2 0 0 114 contagem.pg_catalog.pg_class 5 5 942 101 rio.public.temp0000286178 3 0 0 93 rio.public.temp0000285960 4 0 0 74 contagem.public.temp0000226676 2 0 0 60 rio.public.temp0000286106 2 0 0 57 rio.public.temp0000286108 1 0 0 57 rio.public.temp0000286128 1 0 0 56 rio.public.temp0000286130 1 0 0 55 rio.public.temp0000286120 1 0 0 55 contagem.pg_catalog.pg_depend 3 3 1134 54 rio.public.temp0000286138 1 0 0 53 rio.public.temp0000286094 1 0 0 53 rio.public.temp0000286136 1 0 0 50 rio.public.temp0000286156 1 0 0 45 brasilia.public.temp0000236698 2 0 0 44 rio.pg_catalog.pg_class 38 30 4331 44 rio.public.temp0000286180 2 0 0 43 rio.public.temp0000286174 1 0 0 43 rio.public.temp0000286172 1 0 0 43 contagem.pg_catalog.pg_type 5 5 3884 40 brasilia.pg_catalog.pg_attribute 14 14 47611 38 rio.public.temp0000286086 1 0 0 31 contagem.pg_toast.pg_toast_2619 1 1 128 26 brasilia.public.temp0000236650 1 0 0 22 brasilia.public.temp0000236690 1 0 0 22 brasilia.public.temp0000236628 1 0 0 22 brasilia.public.temp0000236636 1 0 0 22 brasilia.public.temp0000236642 1 0 0 22 rio.pg_catalog.pg_type 28 26 10357 18 contagem.pg_catalog.pg_index 4 4 1898 18 brasilia.pg_catalog.pg_depend 3 3 3499 11 rio.pg_catalog.pg_index 16 16 4256 9 brasilia.pg_catalog.pg_index 3 3 550 5 rio.public.temp0000286206 2 0 0 0 contagem.auditor.auditor_2026_07 1 0 0 0 template1.pg_catalog.pg_shdepend 2 2 1327 0 rio.pg_catalog.pg_shdepend 7 7 4305 0 rio.public.temp0000286114 4 0 0 0 contagem.public.acessorios 1 1 106 0 rio.public.temp0000286134 1 0 0 0 brasilia.pg_toast.pg_toast_2619 2 2 229 0 rio.public.temp0000286124 8 0 0 0 rio.public.temp0000286182 7 0 0 0 rio.public.temp0000286202 1 0 0 0 rio.public.temp0000286204 1 0 0 0 rio.public.tmp_drill_0175 3 3 0 0 rio.public.temp0000286162 5 0 0 0 contagem.public.nf_entrada 1 1 244 0 brasilia.pg_catalog.pg_statistic 3 3 6372 0 rio.pg_catalog.pg_statistic 8 8 14046 0 rio.public.equipamentos_referencia 1 0 38 0 rio.public.usuarios 10 2 313 0 brasilia.pg_catalog.pg_type 5 5 862 0 rio.pg_toast.pg_toast_2619 4 4 1265 0 contagem.public.usuarios 25 0 1623 0 rio.public.temp0000286148 3 0 0 0 contagem.pg_catalog.pg_statistic 2 2 5416 0 rio.auditor.auditor_2026_07 1 0 4294 0 rio.public.temp0000286194 16 0 0 0 rio.public.tmp_drill_0302 2 2 0 0 rio.pg_catalog.pg_depend 14 14 9818 0 brasilia.pg_catalog.pg_class 6 6 1288 0 Total 475 229 392,595 5,735 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 22 00 0 0 01 0 1 02 0 0 03 0 0 04 1 0 05 6 11 06 1 0 07 31 44 08 60 111 09 51 122 10 47 109 11 57 119 12 7 27 13 26 78 14 56 132 15 48 108 16 41 109 17 39 79 18 0 0 19 0 0 20 0 0 21 4 6 22 0 0 23 0 0 - 28.98 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 5 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 3 6m45s 1m25s 3m42s 2m15s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-22 11:38:52 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-22 09:06:46 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-22 07:16:37 Database: rio User: intelifix Remote: [local] Application: psql
2 1 1s21ms 1s21ms 1s21ms 1s21ms drop table if exists temp0000286092;-
DROP TABLE IF EXISTS temp0000286092;
Date: 2026-07-22 09:52:09 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000286092;
Date: 2026-07-22 08:59:08 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000286092;
Date: 2026-07-22 09:35:08 Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1 1s12ms 1s12ms 1s12ms 1s12ms drop table if exists temp0000286166;-
DROP TABLE IF EXISTS temp0000286166;
Date: 2026-07-22 16:37:13 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000286166;
Date: 2026-07-22 16:37:13 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 3m42s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-22 11:38:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1m37s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-22 09:06:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 1m25s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-22 07:16:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 1s21ms DROP TABLE IF EXISTS temp0000286092;[ Date: 2026-07-22 09:52:09 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 1s12ms DROP TABLE IF EXISTS temp0000286166;[ Date: 2026-07-22 16:37:13 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 5,234 Total read queries
- 1,714 Total write queries
Queries by database
Key values
- rio Main database
- 4,469 Requests
- 6h28m53s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 7,277 Requests
User Request type Count Duration etiquetas Total 39 7s429ms select 39 7s429ms intelifix Total 7,277 8h32m14s copy to 410 49m47s ddl 1,304 52m50s others 491 44m59s select 5,070 6h4m36s lenon Total 125 1m39s select 125 1m39s Duration by user
Key values
- 8h32m14s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 39 7s429ms select 39 7s429ms intelifix Total 7,277 8h32m14s copy to 410 49m47s ddl 1,304 52m50s others 491 44m59s select 5,070 6h4m36s lenon Total 125 1m39s select 125 1m39s Queries by host
Key values
- [local] Main host
- 7,441 Requests
- 8h34m1s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 6,321 Requests
- 4h13m42s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-22 09:50:14 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 4,159 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-22 11:14:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-22 10:13:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-22 09:13:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m33s analyze verbose;[ Date: 2026-07-22 05:08:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-22 07:13:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-22 12:13:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 7m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-22 20:12:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 7m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-22 15:12:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 7m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-22 17:12:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-22 08:12:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-22 16:11:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-22 18:11:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-22 14:11:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m26s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027404, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-22 11:38:52 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 6m23s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027403, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-22 11:03:01 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 6m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-22 21:11:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 6m3s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027394, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-22 09:41:30 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m59s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027388, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-22 09:06:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 5m52s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027400, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-22 10:34:59 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-22 19:10:47 - 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 2h4m17s 48 1s407ms 9m33s 2m35s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 22 07 3 9m 3m 08 3 7m29s 2m29s 09 3 9m25s 3m8s 10 3 9m31s 3m10s 11 3 10m10s 3m23s 12 3 8m38s 2m52s 13 3 5m51s 1m57s 14 3 7m11s 2m23s 15 3 8m9s 2m43s 16 3 7m22s 2m27s 17 3 7m51s 2m37s 18 3 7m 2m20s 19 3 6m4s 2m1s 20 3 7m56s 2m38s 21 3 6m41s 2m13s 22 3 5m51s 1m57s [ User: intelifix - Total duration: 2h4m17s - Times executed: 48 ]
[ Application: psql - Total duration: 2h4m17s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-22 11:14:35 Duration: 9m33s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-22 10:13:56 Duration: 8m54s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-22 09:13:46 Duration: 8m45s Database: rio User: intelifix Remote: [local] Application: psql
2 1h42m46s 366 151ms 6m26s 16s847ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 22 07 30 10m31s 21s54ms 08 27 7m13s 16s43ms 09 40 23m36s 35s417ms 10 33 7m14s 13s163ms 11 28 13m44s 29s454ms 12 10 26s3ms 2s600ms 13 24 29s815ms 1s242ms 14 53 6m24s 7s258ms 15 39 16m25s 25s281ms 16 52 13m18s 15s362ms 17 30 3m20s 6s677ms [ User: intelifix - Total duration: 1h42m46s - Times executed: 366 ]
[ Application: [unknown] - Total duration: 1h42m46s - Times executed: 366 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027404, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-22 11:38:52 Duration: 6m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027403, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-22 11:03:01 Duration: 6m23s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027394, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-22 09:41:30 Duration: 6m3s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h11m46s 46 262ms 4m50s 1m33s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 22 07 3 5m15s 1m45s 08 3 4m46s 1m35s 09 3 5m59s 1m59s 10 2 53s960ms 26s980ms 11 3 5m39s 1m53s 12 3 4m18s 1m26s 13 3 3m50s 1m16s 14 3 4m36s 1m32s 15 3 4m55s 1m38s 16 3 4m40s 1m33s 17 3 4m49s 1m36s 18 3 4m23s 1m27s 19 3 4m1s 1m20s 20 2 5m20s 2m40s 21 3 4m7s 1m22s 22 3 4m7s 1m22s [ User: intelifix - Total duration: 1h11m46s - Times executed: 46 ]
[ Application: psql - Total duration: 1h11m46s - Times executed: 46 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-22 09:20:20 Duration: 4m50s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-22 11:20:46 Duration: 4m40s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-22 07:19:11 Duration: 4m14s Database: brasilia User: intelifix Remote: [local] Application: psql
4 21m18s 1,648 150ms 4s940ms 775ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 22 07 38 22s632ms 595ms 08 184 2m2s 663ms 09 222 2m57s 797ms 10 174 2m46s 959ms 11 223 3m10s 852ms 12 57 35s963ms 630ms 13 110 1m26s 789ms 14 232 2m53s 747ms 15 181 2m9s 714ms 16 122 1m58s 969ms 17 105 55s605ms 529ms [ User: intelifix - Total duration: 21m18s - Times executed: 1648 ]
[ Application: [unknown] - Total duration: 21m18s - Times executed: 1648 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (47364, 418, 'ZTE3A8TR4H03869,38165A476064$ZTE3A8TT2L17146,7C7D21F2483B$ZTE3A8TT2L17264,7C7D21F24A13$ZTE3A8TRB709523,7C7D21EB975F$ZTE3A8TT3302181,14200452F516$ZTE3A8TT2L02308,7C7D21F16063$ZTE3A8TT2L02238,7C7D21F15F4B$ZTE3A8TR4H20566,38165A486548$ZTE3A8TR8U19494,B47CA608E13A$ZTE3A8TT3310864,142004537CC2$ZTE3A8TR1M03307,DC5193D9FD72$ZTE3A8TT3302024,14200452F2A2$ZTE3A8TT3311138,14200453810A$ZTE3A8TR4H03938,38165A476178$ZTE3A8TT2L02171,7C7D21F15E3F$ZTE3A8TT4722990,14200458E58A$ZTE3A8TR7R11244,E44E12B32331$ZTE3A8TT3C13774,1420045538AA$ZTE3A8TRCS24912,7C7D21F13323$ZTE3A8TRB709238,7C7D21EB92EB$ZTE3A8TR8U19557,B47CA608E236$ZTE3A8TT4722974,14200458E54A$ZTE3A8TT3302315,14200452F72E$ZTE3A8TT2L01620,7C7D21F155A3$ZTE3A8TT3C17779,14200455773E$ZTE3A8TT3R11276,14200456A012$ZTE3A8TR4X14720,38165A499860$ZTE3A8TR7R11253,E44E12B32355$ZTE3A8TRCS25410,7C7D21F13AEB$ZTE3A8TR1M11383,DC5193DA7BA2$ZTE3A8TT3C17634,1420045574FA$ZTE3A8TR4H03893,38165A4760C4', '',05,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-22 09:45:10 Duration: 4s940ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (267737, 504, '318322262944,946A7725FCB8,1062D0C98B26,905851A6B085,BC9B689822DA,54A65C8AFEC9,5C76959750B5,1062D012BD90,10C25A10815F,A456CCE10314,9058514391D6,BC9B6897FB5E,905851ABDB77,54A65C8BC60A,90585142B85F,1062D09C62C9,383FB3A8D1CB,90585144D105,80D04A928614,B42A0E1B34C3,80D04A958806,383FB3A894A0,946A7728AAC6,10C25A3C52F0,905851447E4E,946A77279BEF,14B7F8DE946E,54A65C11DB64,90585142C738,BC9B68993C3F,905851A6F83E,D4B92F27473C,D4B92F29B87A,946A7726C64C,D4B92F2EE2BD,D4B92F2C9D62,383FB3A1E837,90585146F401,905851A93B70,D4B92F2BC549', '',046,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-22 11:01:20 Duration: 4s909ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (47359, 418, '834325947001300,241636049910,241656732939,241671524562,230043561322,241622550928,241656721726,241647148603,241593319713,241654490723,241672950022,241659741426,241604741120,241676711825,241704266567,241646267900,241673338498,241622605455,241728717988,241676703743,241703471126,241617403646,241656745465,241668253648,241689141119,241689119499,241636048899,241622648792,241711223442,241692644962,241713367893,241732120308,241695111320,241695460928,241698729090,241646408193,241676676063,241732112428,241728545772,241728641921,241713729803,241620909813,241622594545,241729521334,241695581321,241668197076,241676644545,241728688086,241629902644,241708850809,241695578592', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-22 14:13:26 Duration: 4s806ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
5 16m11s 276 157ms 3m46s 3s519ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 22 00 12 28s152ms 2s346ms 01 12 20s929ms 1s744ms 02 12 22s299ms 1s858ms 03 12 28s820ms 2s401ms 04 12 21s98ms 1s758ms 05 12 22s733ms 1s894ms 06 12 19s834ms 1s652ms 07 12 1m51s 9s253ms 08 12 24s995ms 2s82ms 09 12 2m5s 10s435ms 10 12 28s33ms 2s336ms 11 12 4m9s 20s808ms 12 12 22s966ms 1s913ms 13 12 21s178ms 1s764ms 14 12 22s781ms 1s898ms 15 12 26s395ms 2s199ms 16 12 29s56ms 2s421ms 17 12 24s636ms 2s53ms 18 12 22s562ms 1s880ms 19 12 24s310ms 2s25ms 20 12 28s670ms 2s389ms 21 12 24s166ms 2s13ms 22 12 21s659ms 1s804ms [ User: intelifix - Total duration: 16m11s - Times executed: 276 ]
[ Application: psql - Total duration: 16m11s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-22 11:38:52 Duration: 3m46s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-22 09:06:46 Duration: 1m41s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-22 07:16:37 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: psql
6 14m57s 3 2m21s 8m33s 4m59s analyze verbose;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 22 05 3 14m57s 4m59s [ User: intelifix - Total duration: 14m57s - Times executed: 3 ]
[ Application: psql - Total duration: 14m57s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-22 05:08:34 Duration: 8m33s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-22 05:12:37 Duration: 4m2s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-22 05:14:58 Duration: 2m21s Database: contagem User: intelifix Remote: [local] Application: psql
7 10m41s 48 9s323ms 39s430ms 13s367ms create table temp0000286092 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 22 07 15 3m7s 12s508ms 08 4 48s981ms 12s245ms 09 17 3m47s 13s390ms 10 9 1m51s 12s365ms 11 3 1m6s 22s27ms [ User: intelifix - Total duration: 10m41s - Times executed: 48 ]
[ Application: [unknown] - Total duration: 10m41s - Times executed: 48 ]
-
CREATE TABLE temp0000286092 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 11:31:35 Duration: 39s430ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286092 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 07:07:43 Duration: 34s752ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286092 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 09:51:42 Duration: 16s631ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 9m43s 47 1s377ms 43s338ms 12s412ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 22 07 2 10s208ms 5s104ms 08 3 1m18s 26s15ms 09 1 5s770ms 5s770ms 10 7 42s761ms 6s108ms 11 2 17s617ms 8s808ms 13 4 43s475ms 10s868ms 14 7 1m35s 13s603ms 15 2 24s647ms 12s323ms 16 9 2m28s 16s455ms 17 10 1m57s 11s754ms [ User: intelifix - Total duration: 9m43s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 9m43s - Times executed: 47 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-22', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-22 08:10:42 Duration: 43s338ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-22', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-22 16:02:50 Duration: 39s586ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-22', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-22 14:38:32 Duration: 29s603ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 9m11s 1,115 150ms 3s427ms 495ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 22 07 12 9s72ms 756ms 08 141 1m40s 710ms 09 160 1m13s 459ms 10 136 1m6s 490ms 11 133 1m5s 492ms 12 17 8s618ms 506ms 13 101 41s140ms 407ms 14 124 58s379ms 470ms 15 139 57s339ms 412ms 16 104 49s318ms 474ms 17 48 22s165ms 461ms [ User: intelifix - Total duration: 9m11s - Times executed: 1115 ]
[ Application: [unknown] - Total duration: 9m11s - Times executed: 1115 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "269194", "modelo" : "464", "itens" : "241744483355,241770142436,241742589006,241740994664,241740866570,241759858604,241688163840,241763637479,241741167890,241739759908,241744578593,241743843034,241760964054,241738967698,241743627176,241768306173,241739742533,241769660919,241742613857,241770139203,241744448199,241743847377,241763853640,241743985775,241743844347,241739008790,241687989502,241761466987,241743572929,241739005457,241737978500,241748069406,241739944752,241741200925,241741185266,241763674453,241766289714,241768317184,241739618098,241747274951,241767849810,241777718696,241778766161,241768854869,241743628287,241766817576,241760977893,241745415757,241743488903,241766302847,241739868000,241687741925,241762126883,241739013741,241760804768,241759809912,241762192951,241739775566,241743588586,241738958203", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-22 08:05:04 Duration: 3s427ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "269196", "modelo" : "464", "itens" : "241765325871,241765230105,241744041213,241767813140,241765375876,241747589303,241745608706,241747623044,241770204664,241745455054,241759463739,241764794349,241765437879,241765460509,241745741525,241742673537,241762481217,241744607384,241767122130,241743290523,241742954956,241738287777,241771153758,241760840911,241768007681,241738462341,241765459598,241778848896,241765628303,241767884157,241760093655,241760049408,241770042931,241777773450,241747416884,241759505965,241747452343,241745462833,241746570506,241739853150,241738813441,241767736364,241770184460,241768483340,241745951523,241745989203,241760056883,241760788908,241743166267,241765445658,241688105978,241744224160,241770198198,241770230425,241777718999,241764803643,241738635668,241740699304,241762755564,241762766878", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-22 08:15:02 Duration: 2s295ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "269222", "modelo" : "464", "itens" : "241747662644,241747537883,241779044651,241778777778,241767418601,241738919613,241767944567,241743220920,241768866890,241688041326,241764048585,241765461721,241770043941,241778965171,241767689312,241746022540,241761481333,241768752233,241778979213,241777704554,241742405475,241739478993,241761434055,241747510811,241760925868,241767782632,241773888301,241760036780,241747511720,241740576587,241745483744,241765416385,241777788198,241770211635,241745949805,241764043131,241745662426,241771515162,241762748088,241764909310,241764030123,241745980920,241767110917,241760144445,241776646583,241779147792,241772674052,241742256470,241742348904,241738763032,241743298200,241777619797,241779351528,241762844361,241762861838,241738796469,241745824765,241779148499,241742647294,241763287086", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-22 08:24:12 Duration: 2s155ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 7m29s 157 161ms 11s660ms 2s860ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 22 00 6 18s818ms 3s136ms 01 6 8s193ms 1s365ms 02 6 8s401ms 1s400ms 03 5 8s670ms 1s734ms 04 5 11s735ms 2s347ms 05 4 8s245ms 2s61ms 06 4 5s799ms 1s449ms 07 10 40s789ms 4s78ms 08 12 50s230ms 4s185ms 09 12 49s389ms 4s115ms 10 12 41s859ms 3s488ms 11 12 53s151ms 4s429ms 12 7 24s325ms 3s475ms 13 7 7s707ms 1s101ms 14 12 30s500ms 2s541ms 15 12 32s736ms 2s728ms 16 11 25s452ms 2s313ms 17 4 2s676ms 669ms 21 4 8s66ms 2s16ms 22 6 12s344ms 2s57ms [ User: intelifix - Total duration: 7m29s - Times executed: 157 ]
[ Application: psql - Total duration: 7m29s - Times executed: 157 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-22 00:05:13 Duration: 11s660ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-22 07:25:09 Duration: 8s498ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-22 07:35:10 Duration: 8s108ms Database: rio User: intelifix Remote: [local] Application: psql
11 5m8s 27 9s341ms 15s221ms 11s432ms create table temp0000286190 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 22 14 5 1m4s 12s832ms 15 12 2m19s 11s635ms 16 10 1m44s 10s488ms [ User: intelifix - Total duration: 5m8s - Times executed: 27 ]
[ Application: [unknown] - Total duration: 5m8s - Times executed: 27 ]
-
CREATE TABLE temp0000286190 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 14:20:24 Duration: 15s221ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286190 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 15:54:07 Duration: 14s121ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286190 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 14:21:21 Duration: 13s509ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 4m41s 1 4m41s 4m41s 4m41s select * from rs_smart_fiscal_saida () / 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 (/ 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 (/ 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 (/ 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 Jul 22 10 1 4m41s 4m41s [ User: intelifix - Total duration: 4m41s - Times executed: 1 ]
[ Application: psql - Total duration: 4m41s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-07-22 10:20:01 Duration: 4m41s Database: brasilia User: intelifix Remote: [local] Application: psql
13 4m33s 63 193ms 1m12s 4s337ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 22 07 6 3s485ms 580ms 08 7 7s35ms 1s5ms 09 10 7s146ms 714ms 10 6 34s922ms 5s820ms 11 4 56s605ms 14s151ms 12 1 29s89ms 29s89ms 13 3 3s45ms 1s15ms 14 7 1m38s 14s77ms 15 5 15s343ms 3s68ms 16 8 10s208ms 1s276ms 17 6 7s848ms 1s308ms [ User: intelifix - Total duration: 4m33s - Times executed: 63 ]
[ Application: psql - Total duration: 4m33s - Times executed: 63 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027416);
Date: 2026-07-22 14:18:26 Duration: 1m12s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027408);
Date: 2026-07-22 12:02:37 Duration: 29s89ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027405);
Date: 2026-07-22 11:35:23 Duration: 27s667ms Database: rio User: intelifix Remote: [local] Application: psql
14 4m18s 22 9s392ms 33s205ms 11s747ms create table temp0000286194 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 22 15 2 45s388ms 22s694ms 16 7 1m14s 10s619ms 17 13 2m18s 10s670ms [ User: intelifix - Total duration: 4m18s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 4m18s - Times executed: 22 ]
-
CREATE TABLE temp0000286194 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 15:39:53 Duration: 33s205ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286194 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 16:56:06 Duration: 12s542ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286194 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 15:40:20 Duration: 12s183ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 3m58s 55 2s999ms 11s493ms 4s334ms create table temp0000286092 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 22 07 18 1m5s 3s663ms 08 10 41s619ms 4s161ms 09 13 1m 4s646ms 10 8 33s843ms 4s230ms 11 6 36s587ms 6s97ms [ User: intelifix - Total duration: 3m58s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 3m58s - Times executed: 55 ]
-
CREATE TABLE temp0000286092 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"17-07-2026", "ate" :"22-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-22 11:39:09 Duration: 11s493ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286092 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"17-07-2026", "ate" :"22-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-22 09:44:55 Duration: 5s770ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286092 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"17-07-2026", "ate" :"22-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-22 11:04:17 Duration: 5s531ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 3m28s 4 4s796ms 1m41s 52s133ms 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 Jul 22 20 2 1m47s 53s871ms 23 2 1m40s 50s395ms [ User: intelifix - Total duration: 3m28s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m28s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-22 20:09:39 Duration: 1m41s 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-07-22 23:16:54 Duration: 1m35s 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-07-22 20:11:50 Duration: 5s862ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 3m8s 656 150ms 1s505ms 286ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 22 09 154 51s594ms 335ms 10 68 16s127ms 237ms 11 168 44s678ms 265ms 12 10 2s727ms 272ms 13 108 31s486ms 291ms 14 133 38s118ms 286ms 16 15 3s487ms 232ms [ User: intelifix - Total duration: 3m8s - Times executed: 656 ]
[ Application: [unknown] - Total duration: 3m8s - Times executed: 656 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"46989","seriais":"246301092835,226198946984,246023427576,226326362035,226194718086,226140467685,246331315672,226283416182,246301702345,226250128488,226196308690,226136967175,246219665258,246203887489,226367240817,246123246768,226045998702,246205043753,246297643542,226187335054,226181389198,246139890414,246323979210,226400942748,226099822945,226142205880,246104766480,226370985065,246160313237,246280183039,226146417278,246329645464,226418304958,246198590217,246083292028,246101130425,246079756688,246005779300,226355605876,246013210722,226363495759,246135728693,226292910611,226385026783,226171517483,246003120220,246285088804,246081467382,226376115072,246144516880","usuario":"416","observacao":""}');
Date: 2026-07-22 09:07:05 Duration: 1s505ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"46989","seriais":"246227160525,226031428693,226376180410,226122727480,246208517795,226145468891,246039961537,246202731429,226268448504,226112469308,246089105670,226006509113,246330202848,226183636668,246258408399,226298004755,246206819302,246112328295,246277407784,246138428990,246236611941,246094740205,246335148795,226180325874,246284675576,246088591827,226376489811,246041352323,246255240022,226337830618,246101212127,226187539697,246157969696,226321401214,246011496569,226202142437,246220520101,246078948494,226092940321,226130080814,246331820425,226288508788,246153499003,246151306364,246276009500,226313513048,246175323041,226293753555","usuario":"416","observacao":""}');
Date: 2026-07-22 09:22:39 Duration: 1s200ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"46989","seriais":"246046992840,226481160824,246279450409,226025462938,226305628697,226174821937,246053747494,246153688190,226112375056,226354383849,226097445664,226408987595,226416114666,246227116782,226173362838,246173453139,226106530929,226126208291,226173310106,226074283550,226288743840,226339135458,226136143044,226408987393,246275992933,246230596280,226280210909,226287387579,246279413233,246166194866,226087141831,226363518690,246173453038,246158810016,226288066568,226371016684,226678918697,226575645566","usuario":"416","observacao":""}');
Date: 2026-07-22 09:06:37 Duration: 1s150ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
18 2m36s 107 156ms 16s60ms 1s461ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 22 07 22 10s437ms 474ms 09 7 4s683ms 669ms 10 8 5s660ms 707ms 11 10 5s340ms 534ms 12 2 1s88ms 544ms 13 7 3s375ms 482ms 14 25 14s27ms 561ms 15 6 35s97ms 5s849ms 16 20 1m16s 3s830ms [ User: intelifix - Total duration: 2m36s - Times executed: 107 ]
[ Application: [unknown] - Total duration: 2m36s - Times executed: 107 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (046986) LIMIT 1;
Date: 2026-07-22 15:38:57 Duration: 16s60ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (046986) LIMIT 1;
Date: 2026-07-22 16:39:35 Duration: 13s126ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (046986) LIMIT 1;
Date: 2026-07-22 16:44:34 Duration: 10s692ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 2m32s 12 9s526ms 15s143ms 12s746ms create table temp0000286124 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 22 08 6 1m21s 13s616ms 09 3 36s347ms 12s115ms 10 3 34s907ms 11s635ms [ User: intelifix - Total duration: 2m32s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m32s - Times executed: 12 ]
-
CREATE TABLE temp0000286124 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 08:33:01 Duration: 15s143ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286124 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 08:32:24 Duration: 15s9ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286124 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 09:52:37 Duration: 13s613ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 2m17s 11 9s675ms 14s815ms 12s458ms create table temp0000286126 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 22 08 4 50s446ms 12s611ms 09 7 1m26s 12s370ms [ User: intelifix - Total duration: 2m17s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 2m17s - Times executed: 11 ]
-
CREATE TABLE temp0000286126 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 08:49:13 Duration: 14s815ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286126 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 08:48:48 Duration: 13s445ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286126 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 09:17:25 Duration: 13s234ms 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,648 21m18s 150ms 4s940ms 775ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 22 07 38 22s632ms 595ms 08 184 2m2s 663ms 09 222 2m57s 797ms 10 174 2m46s 959ms 11 223 3m10s 852ms 12 57 35s963ms 630ms 13 110 1m26s 789ms 14 232 2m53s 747ms 15 181 2m9s 714ms 16 122 1m58s 969ms 17 105 55s605ms 529ms [ User: intelifix - Total duration: 21m18s - Times executed: 1648 ]
[ Application: [unknown] - Total duration: 21m18s - Times executed: 1648 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (47364, 418, 'ZTE3A8TR4H03869,38165A476064$ZTE3A8TT2L17146,7C7D21F2483B$ZTE3A8TT2L17264,7C7D21F24A13$ZTE3A8TRB709523,7C7D21EB975F$ZTE3A8TT3302181,14200452F516$ZTE3A8TT2L02308,7C7D21F16063$ZTE3A8TT2L02238,7C7D21F15F4B$ZTE3A8TR4H20566,38165A486548$ZTE3A8TR8U19494,B47CA608E13A$ZTE3A8TT3310864,142004537CC2$ZTE3A8TR1M03307,DC5193D9FD72$ZTE3A8TT3302024,14200452F2A2$ZTE3A8TT3311138,14200453810A$ZTE3A8TR4H03938,38165A476178$ZTE3A8TT2L02171,7C7D21F15E3F$ZTE3A8TT4722990,14200458E58A$ZTE3A8TR7R11244,E44E12B32331$ZTE3A8TT3C13774,1420045538AA$ZTE3A8TRCS24912,7C7D21F13323$ZTE3A8TRB709238,7C7D21EB92EB$ZTE3A8TR8U19557,B47CA608E236$ZTE3A8TT4722974,14200458E54A$ZTE3A8TT3302315,14200452F72E$ZTE3A8TT2L01620,7C7D21F155A3$ZTE3A8TT3C17779,14200455773E$ZTE3A8TT3R11276,14200456A012$ZTE3A8TR4X14720,38165A499860$ZTE3A8TR7R11253,E44E12B32355$ZTE3A8TRCS25410,7C7D21F13AEB$ZTE3A8TR1M11383,DC5193DA7BA2$ZTE3A8TT3C17634,1420045574FA$ZTE3A8TR4H03893,38165A4760C4', '',05,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-22 09:45:10 Duration: 4s940ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (267737, 504, '318322262944,946A7725FCB8,1062D0C98B26,905851A6B085,BC9B689822DA,54A65C8AFEC9,5C76959750B5,1062D012BD90,10C25A10815F,A456CCE10314,9058514391D6,BC9B6897FB5E,905851ABDB77,54A65C8BC60A,90585142B85F,1062D09C62C9,383FB3A8D1CB,90585144D105,80D04A928614,B42A0E1B34C3,80D04A958806,383FB3A894A0,946A7728AAC6,10C25A3C52F0,905851447E4E,946A77279BEF,14B7F8DE946E,54A65C11DB64,90585142C738,BC9B68993C3F,905851A6F83E,D4B92F27473C,D4B92F29B87A,946A7726C64C,D4B92F2EE2BD,D4B92F2C9D62,383FB3A1E837,90585146F401,905851A93B70,D4B92F2BC549', '',046,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-22 11:01:20 Duration: 4s909ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (47359, 418, '834325947001300,241636049910,241656732939,241671524562,230043561322,241622550928,241656721726,241647148603,241593319713,241654490723,241672950022,241659741426,241604741120,241676711825,241704266567,241646267900,241673338498,241622605455,241728717988,241676703743,241703471126,241617403646,241656745465,241668253648,241689141119,241689119499,241636048899,241622648792,241711223442,241692644962,241713367893,241732120308,241695111320,241695460928,241698729090,241646408193,241676676063,241732112428,241728545772,241728641921,241713729803,241620909813,241622594545,241729521334,241695581321,241668197076,241676644545,241728688086,241629902644,241708850809,241695578592', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-22 14:13:26 Duration: 4s806ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 1,115 9m11s 150ms 3s427ms 495ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 22 07 12 9s72ms 756ms 08 141 1m40s 710ms 09 160 1m13s 459ms 10 136 1m6s 490ms 11 133 1m5s 492ms 12 17 8s618ms 506ms 13 101 41s140ms 407ms 14 124 58s379ms 470ms 15 139 57s339ms 412ms 16 104 49s318ms 474ms 17 48 22s165ms 461ms [ User: intelifix - Total duration: 9m11s - Times executed: 1115 ]
[ Application: [unknown] - Total duration: 9m11s - Times executed: 1115 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "269194", "modelo" : "464", "itens" : "241744483355,241770142436,241742589006,241740994664,241740866570,241759858604,241688163840,241763637479,241741167890,241739759908,241744578593,241743843034,241760964054,241738967698,241743627176,241768306173,241739742533,241769660919,241742613857,241770139203,241744448199,241743847377,241763853640,241743985775,241743844347,241739008790,241687989502,241761466987,241743572929,241739005457,241737978500,241748069406,241739944752,241741200925,241741185266,241763674453,241766289714,241768317184,241739618098,241747274951,241767849810,241777718696,241778766161,241768854869,241743628287,241766817576,241760977893,241745415757,241743488903,241766302847,241739868000,241687741925,241762126883,241739013741,241760804768,241759809912,241762192951,241739775566,241743588586,241738958203", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-22 08:05:04 Duration: 3s427ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "269196", "modelo" : "464", "itens" : "241765325871,241765230105,241744041213,241767813140,241765375876,241747589303,241745608706,241747623044,241770204664,241745455054,241759463739,241764794349,241765437879,241765460509,241745741525,241742673537,241762481217,241744607384,241767122130,241743290523,241742954956,241738287777,241771153758,241760840911,241768007681,241738462341,241765459598,241778848896,241765628303,241767884157,241760093655,241760049408,241770042931,241777773450,241747416884,241759505965,241747452343,241745462833,241746570506,241739853150,241738813441,241767736364,241770184460,241768483340,241745951523,241745989203,241760056883,241760788908,241743166267,241765445658,241688105978,241744224160,241770198198,241770230425,241777718999,241764803643,241738635668,241740699304,241762755564,241762766878", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-22 08:15:02 Duration: 2s295ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "269222", "modelo" : "464", "itens" : "241747662644,241747537883,241779044651,241778777778,241767418601,241738919613,241767944567,241743220920,241768866890,241688041326,241764048585,241765461721,241770043941,241778965171,241767689312,241746022540,241761481333,241768752233,241778979213,241777704554,241742405475,241739478993,241761434055,241747510811,241760925868,241767782632,241773888301,241760036780,241747511720,241740576587,241745483744,241765416385,241777788198,241770211635,241745949805,241764043131,241745662426,241771515162,241762748088,241764909310,241764030123,241745980920,241767110917,241760144445,241776646583,241779147792,241772674052,241742256470,241742348904,241738763032,241743298200,241777619797,241779351528,241762844361,241762861838,241738796469,241745824765,241779148499,241742647294,241763287086", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-22 08:24:12 Duration: 2s155ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 656 3m8s 150ms 1s505ms 286ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 22 09 154 51s594ms 335ms 10 68 16s127ms 237ms 11 168 44s678ms 265ms 12 10 2s727ms 272ms 13 108 31s486ms 291ms 14 133 38s118ms 286ms 16 15 3s487ms 232ms [ User: intelifix - Total duration: 3m8s - Times executed: 656 ]
[ Application: [unknown] - Total duration: 3m8s - Times executed: 656 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"46989","seriais":"246301092835,226198946984,246023427576,226326362035,226194718086,226140467685,246331315672,226283416182,246301702345,226250128488,226196308690,226136967175,246219665258,246203887489,226367240817,246123246768,226045998702,246205043753,246297643542,226187335054,226181389198,246139890414,246323979210,226400942748,226099822945,226142205880,246104766480,226370985065,246160313237,246280183039,226146417278,246329645464,226418304958,246198590217,246083292028,246101130425,246079756688,246005779300,226355605876,246013210722,226363495759,246135728693,226292910611,226385026783,226171517483,246003120220,246285088804,246081467382,226376115072,246144516880","usuario":"416","observacao":""}');
Date: 2026-07-22 09:07:05 Duration: 1s505ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"46989","seriais":"246227160525,226031428693,226376180410,226122727480,246208517795,226145468891,246039961537,246202731429,226268448504,226112469308,246089105670,226006509113,246330202848,226183636668,246258408399,226298004755,246206819302,246112328295,246277407784,246138428990,246236611941,246094740205,246335148795,226180325874,246284675576,246088591827,226376489811,246041352323,246255240022,226337830618,246101212127,226187539697,246157969696,226321401214,246011496569,226202142437,246220520101,246078948494,226092940321,226130080814,246331820425,226288508788,246153499003,246151306364,246276009500,226313513048,246175323041,226293753555","usuario":"416","observacao":""}');
Date: 2026-07-22 09:22:39 Duration: 1s200ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"46989","seriais":"246046992840,226481160824,246279450409,226025462938,226305628697,226174821937,246053747494,246153688190,226112375056,226354383849,226097445664,226408987595,226416114666,246227116782,226173362838,246173453139,226106530929,226126208291,226173310106,226074283550,226288743840,226339135458,226136143044,226408987393,246275992933,246230596280,226280210909,226287387579,246279413233,246166194866,226087141831,226363518690,246173453038,246158810016,226288066568,226371016684,226678918697,226575645566","usuario":"416","observacao":""}');
Date: 2026-07-22 09:06:37 Duration: 1s150ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
4 366 1h42m46s 151ms 6m26s 16s847ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 22 07 30 10m31s 21s54ms 08 27 7m13s 16s43ms 09 40 23m36s 35s417ms 10 33 7m14s 13s163ms 11 28 13m44s 29s454ms 12 10 26s3ms 2s600ms 13 24 29s815ms 1s242ms 14 53 6m24s 7s258ms 15 39 16m25s 25s281ms 16 52 13m18s 15s362ms 17 30 3m20s 6s677ms [ User: intelifix - Total duration: 1h42m46s - Times executed: 366 ]
[ Application: [unknown] - Total duration: 1h42m46s - Times executed: 366 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027404, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-22 11:38:52 Duration: 6m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027403, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-22 11:03:01 Duration: 6m23s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027394, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-22 09:41:30 Duration: 6m3s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 276 16m11s 157ms 3m46s 3s519ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 22 00 12 28s152ms 2s346ms 01 12 20s929ms 1s744ms 02 12 22s299ms 1s858ms 03 12 28s820ms 2s401ms 04 12 21s98ms 1s758ms 05 12 22s733ms 1s894ms 06 12 19s834ms 1s652ms 07 12 1m51s 9s253ms 08 12 24s995ms 2s82ms 09 12 2m5s 10s435ms 10 12 28s33ms 2s336ms 11 12 4m9s 20s808ms 12 12 22s966ms 1s913ms 13 12 21s178ms 1s764ms 14 12 22s781ms 1s898ms 15 12 26s395ms 2s199ms 16 12 29s56ms 2s421ms 17 12 24s636ms 2s53ms 18 12 22s562ms 1s880ms 19 12 24s310ms 2s25ms 20 12 28s670ms 2s389ms 21 12 24s166ms 2s13ms 22 12 21s659ms 1s804ms [ User: intelifix - Total duration: 16m11s - Times executed: 276 ]
[ Application: psql - Total duration: 16m11s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-22 11:38:52 Duration: 3m46s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-22 09:06:46 Duration: 1m41s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-22 07:16:37 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: psql
6 157 7m29s 161ms 11s660ms 2s860ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 22 00 6 18s818ms 3s136ms 01 6 8s193ms 1s365ms 02 6 8s401ms 1s400ms 03 5 8s670ms 1s734ms 04 5 11s735ms 2s347ms 05 4 8s245ms 2s61ms 06 4 5s799ms 1s449ms 07 10 40s789ms 4s78ms 08 12 50s230ms 4s185ms 09 12 49s389ms 4s115ms 10 12 41s859ms 3s488ms 11 12 53s151ms 4s429ms 12 7 24s325ms 3s475ms 13 7 7s707ms 1s101ms 14 12 30s500ms 2s541ms 15 12 32s736ms 2s728ms 16 11 25s452ms 2s313ms 17 4 2s676ms 669ms 21 4 8s66ms 2s16ms 22 6 12s344ms 2s57ms [ User: intelifix - Total duration: 7m29s - Times executed: 157 ]
[ Application: psql - Total duration: 7m29s - Times executed: 157 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-22 00:05:13 Duration: 11s660ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-22 07:25:09 Duration: 8s498ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-22 07:35:10 Duration: 8s108ms Database: rio User: intelifix Remote: [local] Application: psql
7 128 53s109ms 222ms 1s20ms 414ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 22 07 4 1s720ms 430ms 08 15 6s132ms 408ms 09 13 5s877ms 452ms 10 16 6s951ms 434ms 11 11 4s723ms 429ms 12 4 1s639ms 409ms 13 7 3s407ms 486ms 14 13 5s255ms 404ms 15 12 4s908ms 409ms 16 15 5s620ms 374ms 17 18 6s872ms 381ms [ User: intelifix - Total duration: 53s109ms - Times executed: 128 ]
[ Application: [unknown] - Total duration: 53s109ms - Times executed: 128 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-22 13:41:39 Duration: 1s20ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-22 11:25:57 Duration: 621ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 054;
Date: 2026-07-22 07:20:52 Duration: 612ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 119 55s550ms 280ms 755ms 466ms 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 #8
Day Hour Count Duration Avg duration Jul 22 00 1 435ms 435ms 01 2 828ms 414ms 03 1 351ms 351ms 04 1 428ms 428ms 05 3 1s263ms 421ms 06 2 758ms 379ms 07 9 4s86ms 454ms 08 10 4s892ms 489ms 09 13 6s321ms 486ms 10 8 4s58ms 507ms 11 12 6s286ms 523ms 12 4 1s863ms 465ms 13 13 5s313ms 408ms 14 12 5s927ms 493ms 15 10 4s600ms 460ms 16 9 4s321ms 480ms 17 6 2s349ms 391ms 20 1 423ms 423ms 21 2 1s39ms 519ms [ User: lenon - Total duration: 55s550ms - Times executed: 119 ]
[ Application: [unknown] - Total duration: 55s550ms - Times executed: 119 ]
-
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-07-22 14:42:42 Duration: 755ms 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-07-22 11:33:54 Duration: 726ms 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-07-22 11:49:44 Duration: 684ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
9 114 1m7s 353ms 1s535ms 589ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 22 00 1 673ms 673ms 01 2 1s95ms 547ms 03 1 510ms 510ms 04 1 572ms 572ms 05 2 1s48ms 524ms 07 9 5s174ms 574ms 08 10 6s36ms 603ms 09 13 7s873ms 605ms 10 8 4s826ms 603ms 11 12 7s704ms 642ms 12 4 2s290ms 572ms 13 13 6s487ms 499ms 14 12 7s145ms 595ms 15 10 6s675ms 667ms 16 8 4s781ms 597ms 17 6 3s160ms 526ms 21 2 1s200ms 600ms [ User: intelifix - Total duration: 1m7s - Times executed: 114 ]
[ Application: [unknown] - Total duration: 1m7s - Times executed: 114 ]
-
select * from rs_menu_grants (416, 21, 1);
Date: 2026-07-22 15:42:54 Duration: 1s535ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (503, 18, 1);
Date: 2026-07-22 11:49:44 Duration: 868ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (450, 18, 1);
Date: 2026-07-22 11:33:54 Duration: 864ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 107 2m36s 156ms 16s60ms 1s461ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 22 07 22 10s437ms 474ms 09 7 4s683ms 669ms 10 8 5s660ms 707ms 11 10 5s340ms 534ms 12 2 1s88ms 544ms 13 7 3s375ms 482ms 14 25 14s27ms 561ms 15 6 35s97ms 5s849ms 16 20 1m16s 3s830ms [ User: intelifix - Total duration: 2m36s - Times executed: 107 ]
[ Application: [unknown] - Total duration: 2m36s - Times executed: 107 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (046986) LIMIT 1;
Date: 2026-07-22 15:38:57 Duration: 16s60ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (046986) LIMIT 1;
Date: 2026-07-22 16:39:35 Duration: 13s126ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (046986) LIMIT 1;
Date: 2026-07-22 16:44:34 Duration: 10s692ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
11 101 20s592ms 150ms 650ms 203ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 22 01 6 996ms 166ms 05 15 3s566ms 237ms 07 8 1s619ms 202ms 08 13 2s633ms 202ms 09 7 1s524ms 217ms 10 8 1s543ms 192ms 11 15 3s225ms 215ms 12 4 657ms 164ms 14 9 1s690ms 187ms 15 10 1s911ms 191ms 16 6 1s222ms 203ms [ User: intelifix - Total duration: 20s592ms - Times executed: 101 ]
[ Application: [unknown] - Total duration: 20s592ms - Times executed: 101 ]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '229682149999,229651847682,229761638296,229682306480,229683892943,229759990415,229650444751,229760117070,229651375257,229652408096,229651248702,229652933232,229652141730,229760565072,229760857782,229654052040,229681217294,229654014056,229757498195,229762819007,229680038908,229756307888,229651336970,229762393051,229654777272,229682162325,229681034246,229650631010,229762154767,229652468204,229651445163,229652644764,229756306878,229682831010,229679689401,229651270624,216917208692,229652999400,229760121718,229682401316,229653845678,229682485970,229653576381,229681053339,229651461428,229680505171,229654880112,229651010621,229762444447,229757212029,229679724455', NULL, NULL, 0159, 00);
Date: 2026-07-22 05:19:42 Duration: 650ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (430, 5, '138', 6, '843C9933FF8F,5872C98EDEF7,843C992E693D,843C9933AA45,843C992F55BF,C4EBFF8D2430,ZTEGD640D021,ZTEGD6407B80,48D68233B974,3CF9F0AAB79E,843C99215DE3,3CF9F0AD4838,5872C994C99D,ZTEGD64123E8,ZTEGD70A82D1,4896D956067E,14CA56D274ED,ZTEGDB14DF4C,ZTEGD52E6263', NULL, NULL, 0318, 00);
Date: 2026-07-22 11:32:20 Duration: 400ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229653376384,229653365878,229682847374,229682906774,229652760309,229649860419,229762775669,229758664258,229762302638,229653634950,229762530820', NULL, NULL, 0159, 00);
Date: 2026-07-22 05:07:53 Duration: 337ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 96 18s541ms 150ms 336ms 193ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 22 05 1 265ms 265ms 08 5 1s87ms 217ms 09 3 518ms 172ms 10 1 162ms 162ms 11 8 1s361ms 170ms 12 5 869ms 173ms 13 4 776ms 194ms 14 6 1s88ms 181ms 15 12 2s388ms 199ms 16 30 5s737ms 191ms 17 21 4s286ms 204ms [ User: intelifix - Total duration: 18s541ms - Times executed: 96 ]
[ Application: [unknown] - Total duration: 18s541ms - Times executed: 96 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "358", "data-de" : "2026-07-21", "data-ate" : "2026-07-21", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 427 }');
Date: 2026-07-22 08:47:04 Duration: 336ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "307", "data-de" : "2026-07-22", "data-ate" : "2026-07-22", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 304 }');
Date: 2026-07-22 16:51:38 Duration: 305ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "332", "data-de" : "2026-07-22", "data-ate" : "2026-07-22", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 401 }');
Date: 2026-07-22 16:51:13 Duration: 275ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
13 83 20s450ms 151ms 4s427ms 246ms create table temp0000286134 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 22 08 1 4s427ms 4s427ms 09 7 1s160ms 165ms 10 3 481ms 160ms 11 15 3s16ms 201ms 12 11 2s116ms 192ms 13 8 1s593ms 199ms 14 32 6s602ms 206ms 15 1 160ms 160ms 16 3 528ms 176ms 17 2 362ms 181ms [ User: intelifix - Total duration: 20s450ms - Times executed: 83 ]
[ Application: [unknown] - Total duration: 20s450ms - Times executed: 83 ]
-
CREATE TABLE temp0000286134 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"17-07-2026", "ate" :"22-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-22 08:44:29 Duration: 4s427ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286134 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"17-07-2026", "ate" :"22-07-2026", "nota-fiscal":"2131", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-22 11:30:25 Duration: 301ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286134 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"17-07-2026", "ate" :"22-07-2026", "nota-fiscal":"2131", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-22 11:37:52 Duration: 261ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 78 18s355ms 150ms 3s754ms 235ms create table temp0000286116 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 22 08 9 5s37ms 559ms 09 1 156ms 156ms 10 6 1s63ms 177ms 11 16 3s227ms 201ms 12 1 212ms 212ms 13 8 1s610ms 201ms 14 7 1s381ms 197ms 15 7 1s259ms 179ms 16 9 1s647ms 183ms 17 14 2s759ms 197ms [ User: intelifix - Total duration: 18s355ms - Times executed: 78 ]
[ Application: [unknown] - Total duration: 18s355ms - Times executed: 78 ]
-
CREATE TABLE temp0000286116 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"17-07-2026", "ate" :"22-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-22 08:03:32 Duration: 3s754ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286116 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"17-07-2026", "ate" :"22-07-2026", "nota-fiscal":"1564", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-22 17:27:10 Duration: 307ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286116 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"17-07-2026", "ate" :"22-07-2026", "nota-fiscal":"2131", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-22 11:30:21 Duration: 276ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 72 15s52ms 150ms 1s667ms 209ms create table temp0000236626 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 22 07 1 1s667ms 1s667ms 08 10 1s719ms 171ms 09 17 3s191ms 187ms 10 26 5s212ms 200ms 11 18 3s262ms 181ms [ User: intelifix - Total duration: 15s52ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 15s52ms - Times executed: 72 ]
-
CREATE TABLE temp0000236626 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"17-07-2026", "ate" :"22-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-22 07:57:44 Duration: 1s667ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000236626 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"17-07-2026", "ate" :"22-07-2026", "nota-fiscal":"15077", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-22 09:39:45 Duration: 295ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000236626 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"17-07-2026", "ate" :"22-07-2026", "nota-fiscal":"15077", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-22 11:09:00 Duration: 247ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
16 72 11s590ms 150ms 213ms 160ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 22 05 1 152ms 152ms 08 16 2s582ms 161ms 09 14 2s190ms 156ms 10 15 2s383ms 158ms 11 19 3s137ms 165ms 14 3 491ms 163ms 15 1 152ms 152ms 16 3 499ms 166ms [ User: intelifix - Total duration: 11s590ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 11s590ms - Times executed: 72 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0263;
Date: 2026-07-22 11:01:29 Duration: 213ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0153;
Date: 2026-07-22 08:35:11 Duration: 196ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-22 08:41:03 Duration: 186ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 63 4m33s 193ms 1m12s 4s337ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 22 07 6 3s485ms 580ms 08 7 7s35ms 1s5ms 09 10 7s146ms 714ms 10 6 34s922ms 5s820ms 11 4 56s605ms 14s151ms 12 1 29s89ms 29s89ms 13 3 3s45ms 1s15ms 14 7 1m38s 14s77ms 15 5 15s343ms 3s68ms 16 8 10s208ms 1s276ms 17 6 7s848ms 1s308ms [ User: intelifix - Total duration: 4m33s - Times executed: 63 ]
[ Application: psql - Total duration: 4m33s - Times executed: 63 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027416);
Date: 2026-07-22 14:18:26 Duration: 1m12s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027408);
Date: 2026-07-22 12:02:37 Duration: 29s89ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027405);
Date: 2026-07-22 11:35:23 Duration: 27s667ms Database: rio User: intelifix Remote: [local] Application: psql
18 60 21s560ms 159ms 1s208ms 359ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 22 08 3 706ms 235ms 09 7 1s803ms 257ms 10 2 461ms 230ms 11 12 6s639ms 553ms 12 1 164ms 164ms 13 11 3s573ms 324ms 14 7 1s646ms 235ms 15 5 1s941ms 388ms 16 6 2s422ms 403ms 17 6 2s201ms 366ms [ User: intelifix - Total duration: 21s560ms - Times executed: 60 ]
[ Application: [unknown] - Total duration: 21s560ms - Times executed: 60 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'F4E84F860E3A,3CF9F0AB2620,F4E84F8691FE,F4E84F82E746,5872C98B6157,D83139985C8E,48D68231F24C,843C992F4EC9,689E29BD9E79,843C99216C9B,14CA56D510F7,3CF9F0ABFFA6,C4EBFF8BE5F4,6C11BA6BE46D,843C9936135B,4896D9548AFE,48D68233647E', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-07-22 11:30:21 Duration: 1s208ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '229757141921,229683222137,229761276667,229653101532,229654410212,229683206882,229652490002,229653556581,229653527790,229650654850,229756720309,229650418485,229654453549,229681799203,229652083542,229653349715,229760525876,229653688591,229652756065,229757601012,229679984054,229652514246,229653158911,229682278700,229679679400,229757102142,229653292437,229758166274,229653748092,229653501627,229651045977,229759181335,229680866676,229650753446,229682183943,229682552139,229683325154,229683182941,216917543956,229761991620,229761362333,229757444554,229680248603,229654695469,229759264148,229652186077', '','DEFAULT',056,0159,'', '','', 00);
Date: 2026-07-22 16:44:59 Duration: 992ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '229837861112,229853499999,229839488183,229852211525,229852719105,229838919913,229840102846,229840422327,229841630212,229852669099,229853154759,229856706688,229840859091,229853780915,229852743350,229853871934,229848104659,229851760112,229856339503,229861877585,229843718394,229851993950,229840872730,229861505978,229841688500,229853427793,229854512030,229856915676,229861773939,229854493846,229856891028,229854785266,229853419712,229855107777,229853780511,229839488284,229861770000,229855572021,229853757376,229855834044,229855435464,229853855871,229853656278,229861856169,229856265859,229841904256,229852983351,229856619205,229853312934', '','DEFAULT',056,0160,'', '','', 00);
Date: 2026-07-22 15:51:47 Duration: 989ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 55 3m58s 2s999ms 11s493ms 4s334ms create table temp0000286092 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 22 07 18 1m5s 3s663ms 08 10 41s619ms 4s161ms 09 13 1m 4s646ms 10 8 33s843ms 4s230ms 11 6 36s587ms 6s97ms [ User: intelifix - Total duration: 3m58s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 3m58s - Times executed: 55 ]
-
CREATE TABLE temp0000286092 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"17-07-2026", "ate" :"22-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-22 11:39:09 Duration: 11s493ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286092 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"17-07-2026", "ate" :"22-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-22 09:44:55 Duration: 5s770ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286092 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"17-07-2026", "ate" :"22-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-22 11:04:17 Duration: 5s531ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 54 10s790ms 150ms 946ms 199ms create table temp0000236672 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 22 13 10 3s17ms 301ms 14 20 3s458ms 172ms 15 24 4s313ms 179ms [ User: intelifix - Total duration: 10s790ms - Times executed: 54 ]
[ Application: [unknown] - Total duration: 10s790ms - Times executed: 54 ]
-
CREATE TABLE temp0000236672 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"", "ate" :"22-07-2026", "nota-fiscal":"2031", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-22 13:29:42 Duration: 946ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000236672 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"17-07-2026", "ate" :"22-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-22 13:29:32 Duration: 729ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000236672 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"17-07-2026", "ate" :"22-07-2026", "nota-fiscal":"15082", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-22 15:53:55 Duration: 208ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m21s 8m33s 4m59s 3 14m57s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 22 05 3 14m57s 4m59s [ User: intelifix - Total duration: 14m57s - Times executed: 3 ]
[ Application: psql - Total duration: 14m57s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-22 05:08:34 Duration: 8m33s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-22 05:12:37 Duration: 4m2s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-22 05:14:58 Duration: 2m21s Database: contagem User: intelifix Remote: [local] Application: psql
2 4m41s 4m41s 4m41s 1 4m41s select * from rs_smart_fiscal_saida () / 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 (/ 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 (/ 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 (/ 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 Jul 22 10 1 4m41s 4m41s [ User: intelifix - Total duration: 4m41s - Times executed: 1 ]
[ Application: psql - Total duration: 4m41s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-07-22 10:20:01 Duration: 4m41s Database: brasilia User: intelifix Remote: [local] Application: psql
3 1s407ms 9m33s 2m35s 48 2h4m17s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 22 07 3 9m 3m 08 3 7m29s 2m29s 09 3 9m25s 3m8s 10 3 9m31s 3m10s 11 3 10m10s 3m23s 12 3 8m38s 2m52s 13 3 5m51s 1m57s 14 3 7m11s 2m23s 15 3 8m9s 2m43s 16 3 7m22s 2m27s 17 3 7m51s 2m37s 18 3 7m 2m20s 19 3 6m4s 2m1s 20 3 7m56s 2m38s 21 3 6m41s 2m13s 22 3 5m51s 1m57s [ User: intelifix - Total duration: 2h4m17s - Times executed: 48 ]
[ Application: psql - Total duration: 2h4m17s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-22 11:14:35 Duration: 9m33s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-22 10:13:56 Duration: 8m54s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-22 09:13:46 Duration: 8m45s Database: rio User: intelifix Remote: [local] Application: psql
4 262ms 4m50s 1m33s 46 1h11m46s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 22 07 3 5m15s 1m45s 08 3 4m46s 1m35s 09 3 5m59s 1m59s 10 2 53s960ms 26s980ms 11 3 5m39s 1m53s 12 3 4m18s 1m26s 13 3 3m50s 1m16s 14 3 4m36s 1m32s 15 3 4m55s 1m38s 16 3 4m40s 1m33s 17 3 4m49s 1m36s 18 3 4m23s 1m27s 19 3 4m1s 1m20s 20 2 5m20s 2m40s 21 3 4m7s 1m22s 22 3 4m7s 1m22s [ User: intelifix - Total duration: 1h11m46s - Times executed: 46 ]
[ Application: psql - Total duration: 1h11m46s - Times executed: 46 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-22 09:20:20 Duration: 4m50s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-22 11:20:46 Duration: 4m40s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-22 07:19:11 Duration: 4m14s Database: brasilia User: intelifix Remote: [local] Application: psql
5 4s796ms 1m41s 52s133ms 4 3m28s 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 Jul 22 20 2 1m47s 53s871ms 23 2 1m40s 50s395ms [ User: intelifix - Total duration: 3m28s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m28s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-22 20:09:39 Duration: 1m41s 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-07-22 23:16:54 Duration: 1m35s 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-07-22 20:11:50 Duration: 5s862ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 151ms 6m26s 16s847ms 366 1h42m46s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 22 07 30 10m31s 21s54ms 08 27 7m13s 16s43ms 09 40 23m36s 35s417ms 10 33 7m14s 13s163ms 11 28 13m44s 29s454ms 12 10 26s3ms 2s600ms 13 24 29s815ms 1s242ms 14 53 6m24s 7s258ms 15 39 16m25s 25s281ms 16 52 13m18s 15s362ms 17 30 3m20s 6s677ms [ User: intelifix - Total duration: 1h42m46s - Times executed: 366 ]
[ Application: [unknown] - Total duration: 1h42m46s - Times executed: 366 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027404, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-22 11:38:52 Duration: 6m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027403, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-22 11:03:01 Duration: 6m23s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027394, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-22 09:41:30 Duration: 6m3s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 9s323ms 39s430ms 13s367ms 48 10m41s create table temp0000286092 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 22 07 15 3m7s 12s508ms 08 4 48s981ms 12s245ms 09 17 3m47s 13s390ms 10 9 1m51s 12s365ms 11 3 1m6s 22s27ms [ User: intelifix - Total duration: 10m41s - Times executed: 48 ]
[ Application: [unknown] - Total duration: 10m41s - Times executed: 48 ]
-
CREATE TABLE temp0000286092 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 11:31:35 Duration: 39s430ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286092 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 07:07:43 Duration: 34s752ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286092 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 09:51:42 Duration: 16s631ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 9s526ms 15s143ms 12s746ms 12 2m32s create table temp0000286124 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 22 08 6 1m21s 13s616ms 09 3 36s347ms 12s115ms 10 3 34s907ms 11s635ms [ User: intelifix - Total duration: 2m32s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m32s - Times executed: 12 ]
-
CREATE TABLE temp0000286124 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 08:33:01 Duration: 15s143ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286124 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 08:32:24 Duration: 15s9ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286124 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 09:52:37 Duration: 13s613ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 9s675ms 14s815ms 12s458ms 11 2m17s create table temp0000286126 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 22 08 4 50s446ms 12s611ms 09 7 1m26s 12s370ms [ User: intelifix - Total duration: 2m17s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 2m17s - Times executed: 11 ]
-
CREATE TABLE temp0000286126 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 08:49:13 Duration: 14s815ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286126 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 08:48:48 Duration: 13s445ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286126 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 09:17:25 Duration: 13s234ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 1s377ms 43s338ms 12s412ms 47 9m43s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 22 07 2 10s208ms 5s104ms 08 3 1m18s 26s15ms 09 1 5s770ms 5s770ms 10 7 42s761ms 6s108ms 11 2 17s617ms 8s808ms 13 4 43s475ms 10s868ms 14 7 1m35s 13s603ms 15 2 24s647ms 12s323ms 16 9 2m28s 16s455ms 17 10 1m57s 11s754ms [ User: intelifix - Total duration: 9m43s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 9m43s - Times executed: 47 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-22', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-22 08:10:42 Duration: 43s338ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-22', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-22 16:02:50 Duration: 39s586ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-22', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-22 14:38:32 Duration: 29s603ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 9s392ms 33s205ms 11s747ms 22 4m18s create table temp0000286194 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 22 15 2 45s388ms 22s694ms 16 7 1m14s 10s619ms 17 13 2m18s 10s670ms [ User: intelifix - Total duration: 4m18s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 4m18s - Times executed: 22 ]
-
CREATE TABLE temp0000286194 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 15:39:53 Duration: 33s205ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286194 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 16:56:06 Duration: 12s542ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286194 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 15:40:20 Duration: 12s183ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 9s341ms 15s221ms 11s432ms 27 5m8s create table temp0000286190 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 22 14 5 1m4s 12s832ms 15 12 2m19s 11s635ms 16 10 1m44s 10s488ms [ User: intelifix - Total duration: 5m8s - Times executed: 27 ]
[ Application: [unknown] - Total duration: 5m8s - Times executed: 27 ]
-
CREATE TABLE temp0000286190 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 14:20:24 Duration: 15s221ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286190 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 15:54:07 Duration: 14s121ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286190 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-22 14:21:21 Duration: 13s509ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 193ms 1m12s 4s337ms 63 4m33s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 22 07 6 3s485ms 580ms 08 7 7s35ms 1s5ms 09 10 7s146ms 714ms 10 6 34s922ms 5s820ms 11 4 56s605ms 14s151ms 12 1 29s89ms 29s89ms 13 3 3s45ms 1s15ms 14 7 1m38s 14s77ms 15 5 15s343ms 3s68ms 16 8 10s208ms 1s276ms 17 6 7s848ms 1s308ms [ User: intelifix - Total duration: 4m33s - Times executed: 63 ]
[ Application: psql - Total duration: 4m33s - Times executed: 63 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027416);
Date: 2026-07-22 14:18:26 Duration: 1m12s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027408);
Date: 2026-07-22 12:02:37 Duration: 29s89ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027405);
Date: 2026-07-22 11:35:23 Duration: 27s667ms Database: rio User: intelifix Remote: [local] Application: psql
14 2s999ms 11s493ms 4s334ms 55 3m58s create table temp0000286092 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 22 07 18 1m5s 3s663ms 08 10 41s619ms 4s161ms 09 13 1m 4s646ms 10 8 33s843ms 4s230ms 11 6 36s587ms 6s97ms [ User: intelifix - Total duration: 3m58s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 3m58s - Times executed: 55 ]
-
CREATE TABLE temp0000286092 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"17-07-2026", "ate" :"22-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-22 11:39:09 Duration: 11s493ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286092 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"17-07-2026", "ate" :"22-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-22 09:44:55 Duration: 5s770ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286092 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"17-07-2026", "ate" :"22-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-22 11:04:17 Duration: 5s531ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 157ms 3m46s 3s519ms 276 16m11s call rs_giga_triagem (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 22 00 12 28s152ms 2s346ms 01 12 20s929ms 1s744ms 02 12 22s299ms 1s858ms 03 12 28s820ms 2s401ms 04 12 21s98ms 1s758ms 05 12 22s733ms 1s894ms 06 12 19s834ms 1s652ms 07 12 1m51s 9s253ms 08 12 24s995ms 2s82ms 09 12 2m5s 10s435ms 10 12 28s33ms 2s336ms 11 12 4m9s 20s808ms 12 12 22s966ms 1s913ms 13 12 21s178ms 1s764ms 14 12 22s781ms 1s898ms 15 12 26s395ms 2s199ms 16 12 29s56ms 2s421ms 17 12 24s636ms 2s53ms 18 12 22s562ms 1s880ms 19 12 24s310ms 2s25ms 20 12 28s670ms 2s389ms 21 12 24s166ms 2s13ms 22 12 21s659ms 1s804ms [ User: intelifix - Total duration: 16m11s - Times executed: 276 ]
[ Application: psql - Total duration: 16m11s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-22 11:38:52 Duration: 3m46s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-22 09:06:46 Duration: 1m41s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-22 07:16:37 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: psql
16 161ms 11s660ms 2s860ms 157 7m29s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 22 00 6 18s818ms 3s136ms 01 6 8s193ms 1s365ms 02 6 8s401ms 1s400ms 03 5 8s670ms 1s734ms 04 5 11s735ms 2s347ms 05 4 8s245ms 2s61ms 06 4 5s799ms 1s449ms 07 10 40s789ms 4s78ms 08 12 50s230ms 4s185ms 09 12 49s389ms 4s115ms 10 12 41s859ms 3s488ms 11 12 53s151ms 4s429ms 12 7 24s325ms 3s475ms 13 7 7s707ms 1s101ms 14 12 30s500ms 2s541ms 15 12 32s736ms 2s728ms 16 11 25s452ms 2s313ms 17 4 2s676ms 669ms 21 4 8s66ms 2s16ms 22 6 12s344ms 2s57ms [ User: intelifix - Total duration: 7m29s - Times executed: 157 ]
[ Application: psql - Total duration: 7m29s - Times executed: 157 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-22 00:05:13 Duration: 11s660ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-22 07:25:09 Duration: 8s498ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-22 07:35:10 Duration: 8s108ms Database: rio User: intelifix Remote: [local] Application: psql
17 156ms 16s60ms 1s461ms 107 2m36s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 22 07 22 10s437ms 474ms 09 7 4s683ms 669ms 10 8 5s660ms 707ms 11 10 5s340ms 534ms 12 2 1s88ms 544ms 13 7 3s375ms 482ms 14 25 14s27ms 561ms 15 6 35s97ms 5s849ms 16 20 1m16s 3s830ms [ User: intelifix - Total duration: 2m36s - Times executed: 107 ]
[ Application: [unknown] - Total duration: 2m36s - Times executed: 107 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (046986) LIMIT 1;
Date: 2026-07-22 15:38:57 Duration: 16s60ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (046986) LIMIT 1;
Date: 2026-07-22 16:39:35 Duration: 13s126ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (046986) LIMIT 1;
Date: 2026-07-22 16:44:34 Duration: 10s692ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
18 150ms 4s940ms 775ms 1,648 21m18s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 22 07 38 22s632ms 595ms 08 184 2m2s 663ms 09 222 2m57s 797ms 10 174 2m46s 959ms 11 223 3m10s 852ms 12 57 35s963ms 630ms 13 110 1m26s 789ms 14 232 2m53s 747ms 15 181 2m9s 714ms 16 122 1m58s 969ms 17 105 55s605ms 529ms [ User: intelifix - Total duration: 21m18s - Times executed: 1648 ]
[ Application: [unknown] - Total duration: 21m18s - Times executed: 1648 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (47364, 418, 'ZTE3A8TR4H03869,38165A476064$ZTE3A8TT2L17146,7C7D21F2483B$ZTE3A8TT2L17264,7C7D21F24A13$ZTE3A8TRB709523,7C7D21EB975F$ZTE3A8TT3302181,14200452F516$ZTE3A8TT2L02308,7C7D21F16063$ZTE3A8TT2L02238,7C7D21F15F4B$ZTE3A8TR4H20566,38165A486548$ZTE3A8TR8U19494,B47CA608E13A$ZTE3A8TT3310864,142004537CC2$ZTE3A8TR1M03307,DC5193D9FD72$ZTE3A8TT3302024,14200452F2A2$ZTE3A8TT3311138,14200453810A$ZTE3A8TR4H03938,38165A476178$ZTE3A8TT2L02171,7C7D21F15E3F$ZTE3A8TT4722990,14200458E58A$ZTE3A8TR7R11244,E44E12B32331$ZTE3A8TT3C13774,1420045538AA$ZTE3A8TRCS24912,7C7D21F13323$ZTE3A8TRB709238,7C7D21EB92EB$ZTE3A8TR8U19557,B47CA608E236$ZTE3A8TT4722974,14200458E54A$ZTE3A8TT3302315,14200452F72E$ZTE3A8TT2L01620,7C7D21F155A3$ZTE3A8TT3C17779,14200455773E$ZTE3A8TT3R11276,14200456A012$ZTE3A8TR4X14720,38165A499860$ZTE3A8TR7R11253,E44E12B32355$ZTE3A8TRCS25410,7C7D21F13AEB$ZTE3A8TR1M11383,DC5193DA7BA2$ZTE3A8TT3C17634,1420045574FA$ZTE3A8TR4H03893,38165A4760C4', '',05,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-22 09:45:10 Duration: 4s940ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (267737, 504, '318322262944,946A7725FCB8,1062D0C98B26,905851A6B085,BC9B689822DA,54A65C8AFEC9,5C76959750B5,1062D012BD90,10C25A10815F,A456CCE10314,9058514391D6,BC9B6897FB5E,905851ABDB77,54A65C8BC60A,90585142B85F,1062D09C62C9,383FB3A8D1CB,90585144D105,80D04A928614,B42A0E1B34C3,80D04A958806,383FB3A894A0,946A7728AAC6,10C25A3C52F0,905851447E4E,946A77279BEF,14B7F8DE946E,54A65C11DB64,90585142C738,BC9B68993C3F,905851A6F83E,D4B92F27473C,D4B92F29B87A,946A7726C64C,D4B92F2EE2BD,D4B92F2C9D62,383FB3A1E837,90585146F401,905851A93B70,D4B92F2BC549', '',046,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-22 11:01:20 Duration: 4s909ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (47359, 418, '834325947001300,241636049910,241656732939,241671524562,230043561322,241622550928,241656721726,241647148603,241593319713,241654490723,241672950022,241659741426,241604741120,241676711825,241704266567,241646267900,241673338498,241622605455,241728717988,241676703743,241703471126,241617403646,241656745465,241668253648,241689141119,241689119499,241636048899,241622648792,241711223442,241692644962,241713367893,241732120308,241695111320,241695460928,241698729090,241646408193,241676676063,241732112428,241728545772,241728641921,241713729803,241620909813,241622594545,241729521334,241695581321,241668197076,241676644545,241728688086,241629902644,241708850809,241695578592', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-22 14:13:26 Duration: 4s806ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 353ms 1s535ms 589ms 114 1m7s select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 22 00 1 673ms 673ms 01 2 1s95ms 547ms 03 1 510ms 510ms 04 1 572ms 572ms 05 2 1s48ms 524ms 07 9 5s174ms 574ms 08 10 6s36ms 603ms 09 13 7s873ms 605ms 10 8 4s826ms 603ms 11 12 7s704ms 642ms 12 4 2s290ms 572ms 13 13 6s487ms 499ms 14 12 7s145ms 595ms 15 10 6s675ms 667ms 16 8 4s781ms 597ms 17 6 3s160ms 526ms 21 2 1s200ms 600ms [ User: intelifix - Total duration: 1m7s - Times executed: 114 ]
[ Application: [unknown] - Total duration: 1m7s - Times executed: 114 ]
-
select * from rs_menu_grants (416, 21, 1);
Date: 2026-07-22 15:42:54 Duration: 1s535ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (503, 18, 1);
Date: 2026-07-22 11:49:44 Duration: 868ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (450, 18, 1);
Date: 2026-07-22 11:33:54 Duration: 864ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 150ms 3s427ms 495ms 1,115 9m11s select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 22 07 12 9s72ms 756ms 08 141 1m40s 710ms 09 160 1m13s 459ms 10 136 1m6s 490ms 11 133 1m5s 492ms 12 17 8s618ms 506ms 13 101 41s140ms 407ms 14 124 58s379ms 470ms 15 139 57s339ms 412ms 16 104 49s318ms 474ms 17 48 22s165ms 461ms [ User: intelifix - Total duration: 9m11s - Times executed: 1115 ]
[ Application: [unknown] - Total duration: 9m11s - Times executed: 1115 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "269194", "modelo" : "464", "itens" : "241744483355,241770142436,241742589006,241740994664,241740866570,241759858604,241688163840,241763637479,241741167890,241739759908,241744578593,241743843034,241760964054,241738967698,241743627176,241768306173,241739742533,241769660919,241742613857,241770139203,241744448199,241743847377,241763853640,241743985775,241743844347,241739008790,241687989502,241761466987,241743572929,241739005457,241737978500,241748069406,241739944752,241741200925,241741185266,241763674453,241766289714,241768317184,241739618098,241747274951,241767849810,241777718696,241778766161,241768854869,241743628287,241766817576,241760977893,241745415757,241743488903,241766302847,241739868000,241687741925,241762126883,241739013741,241760804768,241759809912,241762192951,241739775566,241743588586,241738958203", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-22 08:05:04 Duration: 3s427ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "269196", "modelo" : "464", "itens" : "241765325871,241765230105,241744041213,241767813140,241765375876,241747589303,241745608706,241747623044,241770204664,241745455054,241759463739,241764794349,241765437879,241765460509,241745741525,241742673537,241762481217,241744607384,241767122130,241743290523,241742954956,241738287777,241771153758,241760840911,241768007681,241738462341,241765459598,241778848896,241765628303,241767884157,241760093655,241760049408,241770042931,241777773450,241747416884,241759505965,241747452343,241745462833,241746570506,241739853150,241738813441,241767736364,241770184460,241768483340,241745951523,241745989203,241760056883,241760788908,241743166267,241765445658,241688105978,241744224160,241770198198,241770230425,241777718999,241764803643,241738635668,241740699304,241762755564,241762766878", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-22 08:15:02 Duration: 2s295ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "269222", "modelo" : "464", "itens" : "241747662644,241747537883,241779044651,241778777778,241767418601,241738919613,241767944567,241743220920,241768866890,241688041326,241764048585,241765461721,241770043941,241778965171,241767689312,241746022540,241761481333,241768752233,241778979213,241777704554,241742405475,241739478993,241761434055,241747510811,241760925868,241767782632,241773888301,241760036780,241747511720,241740576587,241745483744,241765416385,241777788198,241770211635,241745949805,241764043131,241745662426,241771515162,241762748088,241764909310,241764030123,241745980920,241767110917,241760144445,241776646583,241779147792,241772674052,241742256470,241742348904,241738763032,241743298200,241777619797,241779351528,241762844361,241762861838,241738796469,241745824765,241779148499,241742647294,241763287086", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-22 08:24:12 Duration: 2s155ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 5 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 22 12 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 7m36s - Times executed: 5 ]
[ Application: psql - Total duration: 7m34s - Times executed: 2 ]
[ Application: [unknown] - Total duration: 1s478ms - Times executed: 3 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 18,502 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 14 FATAL entries
- 3620 ERROR entries
- 0 WARNING entries
- 13 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,485 Max number of times the same event was reported
- 3,647 Total events found
Rank Times reported Error 1 3,485 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 22 00 60 01 59 02 59 03 59 04 59 05 59 06 60 07 231 08 365 09 424 10 454 11 293 12 202 13 166 14 325 15 267 16 228 17 115 - ERROR: prepared statement "_PLAN000000002963CBD0" does not exist
- ERROR: prepared statement "_PLAN0000000029640290" does not exist
- ERROR: prepared statement "_PLAN000000002967A340" does not exist
Statement: DEALLOCATE "_PLAN000000002963CBD0"
Date: 2026-07-22 00:00:10 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029640290"
Date: 2026-07-22 00:01:11 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002967A340"
Date: 2026-07-22 00:02:12 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 22 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-22 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-22 00:35:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-22 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
3 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 22 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-22 08:00:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-22 08:20:14 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-22 08:40:10 Database: brasilia Application: psql User: intelifix Remote: [local]
4 16 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 22 07 2 08 2 10 4 11 3 15 4 16 1 - ERROR: syntax error at or near "120562" at character 73
- ERROR: syntax error at or near "120562" at character 73
- ERROR: syntax error at or near ")" at character 34
Statement: select * from rs_caixa_qr(''''''''''''''''''''''''''''''''''''''''''''''120562)
Date: 2026-07-22 07:39:50 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(''''''''''''''''''''''''''''''''''''''''''''''120562)
Date: 2026-07-22 07:39:50 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(382267,)
Date: 2026-07-22 08:58:17 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
5 16 ERROR: function rs_etiqueta(...) does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 22 08 6 14 2 15 8 - ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(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_ETIQUETA(73903085850064700470)Date: 2026-07-22 08:19:37 Database: rio 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_ETIQUETA(73903085850064700470)Date: 2026-07-22 08:19:37 Database: rio 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_ETIQUETA(73015085850081606555)Date: 2026-07-22 08:20:50 Database: rio Application: [unknown] User: etiquetas Remote: [local]
6 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 22 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-22 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-22 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-22 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
7 5 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 22 00 1 06 1 07 3 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-22 00:02:31 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-22 06:02:15 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-22 07:26:41 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
8 5 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 22 07 1 09 2 11 2 - LOG: process 1300809 still waiting for ShareLock on transaction 3083608 after 1000.146 ms
- LOG: process 1324232 still waiting for ShareLock on transaction 3092463 after 1000.071 ms
- LOG: process 1324232 still waiting for ShareLock on transaction 3092463 after 6512.381 ms
Detail: Process holding the lock: 1301490. Wait queue: 1300809.
Context: while updating tuple (74276,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) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-22 07:15:12 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1338758. Wait queue: 1324232.
Context: while updating tuple (74285,36) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-22 09:05:10 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1338758. Wait queue: 1324232.
Context: while updating tuple (74285,36) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-22 09:05:15 Database: rio Application: psql User: intelifix Remote: [local]
9 5 ERROR: process ... detected deadlock while waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 22 07 5 - ERROR: process 1301490 detected deadlock while waiting for ShareLock on transaction 3084106 after 1000.138 ms
- ERROR: process 1301490 detected deadlock while waiting for ShareLock on transaction 3084106 after 1000.183 ms
- ERROR: process 1301490 detected deadlock while waiting for ShareLock on transaction 3084106 after 1000.115 ms
Detail: Process holding the lock: 1300809. Wait queue: .
Context: while updating tuple (74276,77) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 027376, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-07-22 07:16:27 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1300809. Wait queue: .
Context: while updating tuple (74276,78) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL assignment "cRetAux := RS_NF_ASSOCIA_EQUIPAMENTO( nLI )" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 027376, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-07-22 07:16:28 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1300809. Wait queue: .
Context: while updating tuple (74276,79) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL assignment "cRetAux := RS_NF_ASSOCIA_EQUIPAMENTO( nLI )" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 027376, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-07-22 07:16:30 Database: rio Application: [unknown] User: intelifix Remote: [local]
10 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 22 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-07-22 05:32:07 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-22 05:32:07 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-22 05:32:07 Database: contagem Application: psql User: intelifix Remote: [local]
11 4 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 22 08 2 14 2 - ERROR: trailing junk after numeric literal at or near "506F0C3D38E0" at character 27
- ERROR: trailing junk after numeric literal at or near "506F0C3D38E0" at character 27
- ERROR: trailing junk after numeric literal at or near "8C444F91D8C9" at character 27
Statement: select * from rs_caixa_qr(506F0C3D38E0)
Date: 2026-07-22 08:50:06 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(506F0C3D38E0)
Date: 2026-07-22 08:50:06 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(8C444F91D8C9)
Date: 2026-07-22 14:38:28 Database: rio Application: [unknown] User: etiquetas Remote: [local]
12 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 22 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-22 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-22 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
13 2 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #13
Day Hour Count Jul 22 09 1 16 1 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000286092"
Date: 2026-07-22 09:52:09
Context: automatic vacuum of table "rio.public.temp0000286166"
Date: 2026-07-22 16:37:13
14 2 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #14
Day Hour Count Jul 22 09 1 16 1 - LOG: process 1382695 still waiting for AccessExclusiveLock on relation 2759727 of database 358220 after 1000.168 ms
- LOG: process 1758412 still waiting for AccessExclusiveLock on relation 2804122 of database 358220 after 1000.070 ms
Detail: Process holding the lock: 1430390. Wait queue: 1382695.
Statement: DROP TABLE IF EXISTS temp0000286092;Date: 2026-07-22 09:52:09 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1799581. Wait queue: 1758412.
Statement: DROP TABLE IF EXISTS temp0000286166;Date: 2026-07-22 16:37:13 Database: rio Application: [unknown] User: intelifix Remote: [local]
15 1 ERROR: function rs_equipamento_excecoes() does not exist
Times Reported Most Frequent Error / Event #15
Day Hour Count Jul 22 16 1 - ERROR: function rs_equipamento_excecoes() does not exist at character 8
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT RS_EQUIPAMENTO_EXCECOES()Date: 2026-07-22 16:17:45 Database: rio Application: [unknown] User: intelifix Remote: [local]
16 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #16
Day Hour Count Jul 22 03 1 - LOG: database system was shut down at 2026-07-22 03:05:01 -03
Date: 2026-07-22 03:05:03
17 1 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #17
Day Hour Count Jul 22 16 1 - ERROR: column "cai_id" does not exist at character 39
Hint: Perhaps you meant to reference the column "temp0000226674.cli_id".
Statement: SELECT * FROM temp0000226674 ORDER BY CAI_ID DESCDate: 2026-07-22 16:34:40 Database: contagem Application: [unknown] User: intelifix Remote: [local]