pgBadger-
Global information
- Generated on Fri Aug 14 23:50:17 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 55,477 log entries in 14s
- Log start from 2026-08-14 00:00:06 to 2026-08-14 23:50:08
-
Overview
Global Stats
- 386 Number of unique normalized queries
- 7,317 Number of queries
- 12h17m21s Total query duration
- 2026-08-14 00:00:38 First query
- 2026-08-14 23:48:53 Last query
- 5 queries/s at 2026-08-14 14:29:09 Query peak
- 12h17m21s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 12h17m21s Execute total duration
- 6,155 Number of events
- 17 Number of unique normalized events
- 6,028 Max number of times the same event was reported
- 0 Number of cancellation
- 777 Total number of automatic vacuums
- 1,138 Total number of automatic analyzes
- 10 Number temporary file
- 240.59 MiB Max size of temporary file
- 111.82 MiB Average size of temporary file
- 436 Total number of sessions
- 8 sessions at 2026-08-14 07:49:25 Session peak
- 14d14h29m46s Total duration of sessions
- 48m14s Average duration of sessions
- 16 Average queries per session
- 1m41s Average queries duration per session
- 46m32s Average idle time per session
- 441 Total number of connections
- 7 connections/s at 2026-08-14 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-14 14:29:09 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-14 13:11:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-14 23:48:22 Date
Queries duration
Key values
- 12h17m21s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 14 00 29 0ms 19s818ms 4s808ms 6s387ms 8s832ms 1m30s 01 45 0ms 5s212ms 1s137ms 5s230ms 7s343ms 8s859ms 02 21 0ms 5s86ms 2s70ms 5s41ms 7s779ms 8s56ms 03 18 0ms 5s645ms 2s453ms 4s977ms 8s110ms 8s771ms 04 18 0ms 5s247ms 2s277ms 5s745ms 7s161ms 8s169ms 05 54 0ms 10m10s 25s420ms 10s690ms 2m59s 10m11s 06 37 0ms 47s320ms 3s517ms 5s205ms 11s776ms 51s229ms 07 414 150ms 10m34s 7s784ms 2m38s 6m48s 10m50s 08 633 150ms 9m59s 5s822ms 3m45s 9m 10m1s 09 832 150ms 9m22s 5s35ms 2m 8m7s 15m12s 10 930 150ms 15m41s 5s908ms 5m24s 10m58s 15m50s 11 965 150ms 35m25s 6s749ms 2m58s 13m38s 36m51s 12 265 0ms 11m48s 10s369ms 49s809ms 5m28s 23m 13 500 0ms 6m54s 2s861ms 48s310ms 1m9s 6m58s 14 882 150ms 11m43s 3s433ms 1m 6m10s 11m46s 15 773 150ms 9m59s 4s566ms 2m24s 6m36s 10m42s 16 185 0ms 10m2s 6s835ms 27s319ms 1m39s 10m18s 17 115 0ms 6m43s 6s942ms 8s513ms 54s81ms 6m46s 18 25 0ms 5m50s 25s818ms 6s347ms 48s39ms 5m50s 19 24 0ms 5m51s 27s293ms 5s957ms 51s214ms 5m51s 20 131 0ms 9m21s 11s518ms 1m14s 1m29s 9m21s 21 38 0ms 6m29s 18s900ms 8s550ms 51s287ms 6m29s 22 32 0ms 5m53s 20s739ms 7s908ms 47s151ms 5m53s 23 351 0ms 1m38s 6s617ms 1m5s 1m9s 1m38s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 14 00 6 0 2s260ms 0ms 0ms 726ms 01 27 0 263ms 246ms 394ms 798ms 02 3 0 391ms 0ms 0ms 0ms 03 1 0 425ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 31 0 311ms 228ms 818ms 1s598ms 06 19 0 1s296ms 0ms 814ms 3s909ms 07 315 0 8s481ms 12s873ms 2m32s 7m42s 08 443 0 6s868ms 21s804ms 3m45s 8m57s 09 616 0 5s197ms 17s475ms 1m28s 8m44s 10 748 0 6s595ms 47s26ms 5m23s 14m51s 11 763 0 7s661ms 30s956ms 2m22s 15m23s 12 172 0 14s210ms 7s810ms 47s733ms 7m18s 13 378 0 2s722ms 11s388ms 16s343ms 3m37s 14 673 0 3s746ms 20s232ms 58s875ms 7m31s 15 576 0 4s934ms 28s734ms 2m 7m26s 16 137 0 8s674ms 5s779ms 26s44ms 4m18s 17 63 0 11s660ms 3s100ms 5s654ms 3m31s 18 7 0 1m24s 0ms 0ms 3m15s 19 6 0 1m40s 0ms 0ms 3m20s 20 24 87 13s43ms 23s335ms 1m14s 3m51s 21 14 0 46s445ms 0ms 0ms 3m27s 22 8 0 1m14s 0ms 0ms 3m15s 23 22 329 6s617ms 1m3s 1m5s 1m12s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 14 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Aug 14 00 0 2 2.00 0.00% 01 0 2 2.00 0.00% 02 0 1 1.00 0.00% 03 0 1 1.00 0.00% 04 0 0 0.00 0.00% 05 0 4 4.00 0.00% 06 0 4 4.00 0.00% 07 0 13 13.00 0.00% 08 0 16 16.00 0.00% 09 0 16 16.00 0.00% 10 0 26 26.00 0.00% 11 0 21 21.00 0.00% 12 0 8 8.00 0.00% 13 0 15 15.00 0.00% 14 0 18 18.00 0.00% 15 0 12 12.00 0.00% 16 0 6 6.00 0.00% 17 0 4 4.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 4 4.00 0.00% 21 0 3 3.00 0.00% 22 0 1 1.00 0.00% 23 0 5 5.00 0.00% Day Hour Count Average / Second Aug 14 00 17 0.00/s 01 14 0.00/s 02 13 0.00/s 03 21 0.01/s 04 10 0.00/s 05 14 0.00/s 06 17 0.00/s 07 24 0.01/s 08 24 0.01/s 09 27 0.01/s 10 29 0.01/s 11 30 0.01/s 12 17 0.00/s 13 23 0.01/s 14 30 0.01/s 15 21 0.01/s 16 17 0.00/s 17 13 0.00/s 18 9 0.00/s 19 12 0.00/s 20 18 0.01/s 21 11 0.00/s 22 17 0.00/s 23 13 0.00/s Day Hour Count Average Duration Average idle time Aug 14 00 10 1h36s 1h22s 01 16 1h45s 1h42s 02 14 1h26s 1h22s 03 25 20m24s 20m22s 04 9 1h4m 1h3m55s 05 10 55m10s 52m53s 06 13 59m35s 59m25s 07 22 49m42s 47m16s 08 22 47m22s 44m35s 09 27 47m3s 44m28s 10 23 51m9s 47m10s 11 36 39m6s 36m5s 12 22 53m8s 51m3s 13 17 47m4s 45m40s 14 28 46m55s 45m7s 15 24 52m21s 49m54s 16 19 53m21s 52m15s 17 18 57m7s 56m23s 18 11 1h32s 59m33s 19 11 52m10s 51m11s 20 15 35m36s 33m55s 21 13 51m37s 50m42s 22 15 40m35s 39m51s 23 16 35m19s 32m54s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-08-14 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 441 connections Total
Connections per user
Key values
- intelifix Main User
- 441 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-08-14 07:49:25 Date
Histogram of session times
Key values
- 302 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 436 sessions Total
Sessions per user
Key values
- intelifix Main User
- 436 sessions Total
Sessions per host
Key values
- [local] Main Host
- 436 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 436 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 18,168 buffers Checkpoint Peak
- 2026-08-14 09:04:34 Date
- 269.987 seconds Highest write time
- 0.214 seconds Sync time
Checkpoints Wal files
Key values
- 12 files Wal files usage Peak
- 2026-08-14 09:34:34 Date
Checkpoints distance
Key values
- 376.88 Mo Distance Peak
- 2026-08-14 09:34:34 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 14 00 28,317 629.768s 0.132s 630.036s 01 3,448 346.862s 0.109s 347.038s 02 1,958 196.596s 0.146s 196.808s 03 1,858 186.633s 0.2s 186.886s 04 1,802 180.952s 0.257s 181.255s 05 10,035 1,005.348s 0.212s 1,005.655s 06 7,361 563.074s 0.066s 563.178s 07 63,247 3,205.355s 0.791s 3,206.359s 08 95,611 3,238.593s 0.944s 3,239.777s 09 102,936 3,238.324s 1.106s 3,239.748s 10 82,349 3,238.063s 1.294s 3,239.634s 11 71,761 3,238.382s 1.048s 3,239.7s 12 52,160 2,569.23s 0.508s 2,569.923s 13 32,612 2,270.054s 0.508s 2,270.753s 14 69,895 3,238.43s 1.031s 3,239.733s 15 84,037 3,213.442s 0.935s 3,214.671s 16 17,712 1,574.587s 0.487s 1,575.265s 17 8,390 842.627s 0.267s 843.046s 18 558 56.125s 0.015s 56.187s 19 23 2.318s 0.014s 2.339s 20 1,459 208.87s 0.117s 209.021s 21 3,282 333.226s 0.091s 333.54s 22 2,765 277.374s 0.199s 277.721s 23 513 51.57s 0.015s 51.629s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 14 00 0 0 7 497 0.062s 0.007s 01 0 0 1 666 0.017s 0.009s 02 0 0 1 464 0.064s 0.01s 03 0 0 0 334 0.063s 0.007s 04 0 0 1 415 0.063s 0.008s 05 0 0 5 771 0.063s 0.014s 06 0 0 1 302 0.006s 0.003s 07 0 0 44 4,855 0.062s 0.012s 08 0 0 51 6,903 0.025s 0.012s 09 0 0 82 8,357 0.062s 0.012s 10 0 0 53 7,982 0.062s 0.012s 11 0 0 51 8,287 0.064s 0.012s 12 0 0 29 3,751 0.060s 0.012s 13 0 0 25 4,844 0.008s 0.012s 14 0 0 40 7,673 0.009s 0.012s 15 0 0 67 7,626 0.062s 0.012s 16 0 0 10 3,094 0.063s 0.012s 17 0 0 2 2,143 0.064s 0.01s 18 0 0 1 58 0.004s 0.006s 19 0 0 0 3 0.012s 0.005s 20 0 0 0 95 0.065s 0.007s 21 0 0 2 478 0.021s 0.008s 22 0 0 0 448 0.064s 0.012s 23 0 0 0 27 0.003s 0.006s Day Hour Count Avg time (sec) Aug 14 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Aug 14 00 19,465.17 kB 55,340.67 kB 01 1,845.78 kB 29,319.89 kB 02 1,114.44 kB 12,173.89 kB 03 1,520.00 kB 2,783.71 kB 04 1,552.33 kB 2,598.33 kB 05 8,850.22 kB 16,776.22 kB 06 7,627.33 kB 13,994.67 kB 07 59,755.42 kB 77,273.75 kB 08 69,143.08 kB 105,802.25 kB 09 111,813.83 kB 163,582.83 kB 10 72,424.67 kB 130,012.25 kB 11 70,019.75 kB 137,633.58 kB 12 39,667.67 kB 93,285.50 kB 13 34,913.92 kB 57,138.50 kB 14 53,395.83 kB 84,455.33 kB 15 91,955.92 kB 138,167.42 kB 16 13,106.42 kB 70,734.58 kB 17 4,721.40 kB 25,390.20 kB 18 481.00 kB 13,295.50 kB 19 187.00 kB 10,179.00 kB 20 3,899.00 kB 10,386.50 kB 21 2,418.29 kB 6,823.14 kB 22 1,352.40 kB 3,753.40 kB 23 229.60 kB 2,170.00 kB -
Temporary Files
Size of temporary files
Key values
- 481.19 MiB Temp Files size Peak
- 2026-08-14 05:32:05 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-14 05:32:11 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 14 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.09 GiB 111.82 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 934.60 MiB 71.76 MiB 240.59 MiB 116.83 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-14 05:32:13 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-14 05:32:05 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 183.64 MiB 91.82 MiB 91.82 MiB 91.82 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-14 05:30:42 Duration: 40s566ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-14 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 240.59 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-14 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 240.59 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-14 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 91.82 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-14 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 91.82 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-14 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 79.41 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-14 05:32:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 79.32 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-14 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 79.32 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-14 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 71.84 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-14 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 71.76 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-14 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 71.76 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-14 05:32:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 16.44 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-14 12:10:00 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 16.44 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-14 12:10:00 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (132) Main table analyzed (database rio)
- 1,138 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 132 rio.pg_catalog.pg_class 71 rio.pg_catalog.pg_type 56 rio.public.temp0000288427 53 rio.public.usuarios 48 contagem.public.temp0000226832 42 brasilia.pg_catalog.pg_attribute 42 rio.pg_catalog.pg_index 39 contagem.pg_catalog.pg_attribute 38 contagem.public.usuarios 34 rio.public.temp0000288508 32 rio.public.temp0000288387 29 rio.pg_catalog.pg_depend 28 rio.public.temp0000288373 25 rio.public.temp0000288469 23 brasilia.pg_catalog.pg_class 22 brasilia.pg_catalog.pg_type 19 rio.public.temp0000288409 19 contagem.pg_catalog.pg_class 17 contagem.pg_catalog.pg_type 14 brasilia.pg_catalog.pg_index 14 rio.public.temp0000288421 14 rio.public.temp0000288431 14 rio.public.temp0000288130 13 brasilia.public.temp0000238182 13 rio.public.temp0000288425 13 brasilia.pg_catalog.pg_depend 13 rio.public.temp0000288471 13 brasilia.public.temp0000238246 12 rio.public.temp0000288401 11 rio.public.temp0000288403 10 rio.public.temp0000288437 9 brasilia.public.temp0000238232 9 contagem.public.temp0000226764 9 contagem.pg_catalog.pg_index 9 rio.public.temp0000288146 8 rio.public.temp0000288500 7 rio.public.temp0000288534 7 rio.pg_catalog.pg_shdepend 7 rio.public.temp0000288453 7 rio.public.temp0000288417 6 brasilia.public.nf_entrada 6 contagem.pg_catalog.pg_depend 6 brasilia.public.usuarios 6 rio.public.temp0000288262 6 rio.public.temp0000288154 5 contagem.public.temp0000226812 5 rio.public.tmp_drill_0302 5 rio.public.temp0000288449 5 brasilia.public.temp0000238250 5 rio.public.temp0000288124 4 brasilia.public.temp0000238190 4 brasilia.public.temp0000238240 4 rio.public.temp0000288136 4 brasilia.public.temp0000238258 4 rio.public.tmp_drill_0320 3 rio.public.tmp_drill_0175 3 brasilia.public.temp0000238218 3 contagem.pg_catalog.pg_shdepend 3 brasilia.public.temp0000238184 2 brasilia.public.temp0000238220 2 rio.public.temp0000288459 2 brasilia.public.temp0000238242 2 brasilia.public.temp0000238198 2 contagem.public.nf_entrada 2 template1.pg_catalog.pg_shdepend 2 postgres.pg_catalog.pg_shdepend 2 contagem.public.temp0000226842 2 rio.public.temp0000288506 2 rio.public.temp0000288134 2 rio.public.temp0000288477 2 brasilia.public.temp0000238214 1 rio.public.temp0000288465 1 rio.public.temp0000288405 1 brasilia.public.temp0000238210 1 rio.public.temp0000288463 1 brasilia.public.temp0000238230 1 rio.auditor.auditor_2026_08 1 rio.public.temp0000288520 1 brasilia.pg_catalog.pg_shdepend 1 rio.pg_catalog.pg_sequence 1 rio.public.temp0000288524 1 rio.public.temp0000288467 1 brasilia.public.temp0000238194 1 rio.pg_catalog.pg_attrdef 1 rio.public.tmp_dias_288487 1 contagem.auditor.auditor_2026_08 1 contagem.public.temp0000226838 1 rio.public.temp0000288451 1 rio.public.temp0000288492 1 brasilia.public.temp0000238244 1 rio.public.temp0000288510 1 rio.public.temp0000288544 1 rio.public.temp0000288522 1 brasilia.public.temp0000238186 1 rio.public.temp0000288479 1 rio.public.temp0000288461 1 brasilia.public.temp0000238188 1 rio.public.temp0000288415 1 rio.public.temp0000288473 1 brasilia.public.temp0000238238 1 rio.public.temp0000288419 1 brasilia.public.temp0000238236 1 Total 1,138 Vacuums per table
Key values
- pg_catalog.pg_attribute (103) Main table vacuumed on database rio
- 777 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 103 52 0 0 0 0 0 27,540 8,161 11,610,154 410 9,614 rio.pg_catalog.pg_class 63 24 0 0 0 0 0 5,190 1,749 2,401,630 96 363 rio.public.usuarios 58 12 0 0 0 0 0 366 150 300,098 19 63 rio.pg_catalog.pg_type 56 21 0 0 0 0 0 2,321 728 865,953 82 236 rio.pg_catalog.pg_index 44 16 0 0 0 0 0 1,255 408 340,614 56 133 contagem.public.usuarios 34 0 0 0 0 0 0 157 115 61,343 1 1 rio.pg_catalog.pg_depend 33 13 0 0 0 0 0 4,055 1,616 2,142,036 87 709 rio.public.temp0000288387 29 0 0 0 0 0 0 19,085 1,824 3,368,738 0 0 rio.public.temp0000288373 25 0 0 0 0 0 0 22,534 1,811 3,566,839 0 0 rio.public.temp0000288427 24 0 0 0 0 0 0 4,371 227 451,452 0 0 rio.public.temp0000288469 23 0 0 0 0 0 0 17,801 104 1,068,361 0 0 rio.public.tmp_drill_0175 19 1 0 0 0 0 0 104 65 78,508 1 38 rio.public.temp0000288508 17 0 0 0 0 0 0 8,148 90 495,638 0 0 brasilia.pg_catalog.pg_attribute 17 17 0 0 0 0 0 8,988 1,674 3,122,585 61 1,470 rio.pg_catalog.pg_statistic 14 10 0 0 0 0 0 12,389 4,140 17,355,319 1,787 8,620 rio.public.temp0000288421 14 0 0 0 0 0 0 7,362 1,788 2,668,362 0 0 contagem.pg_catalog.pg_attribute 13 13 0 0 0 0 0 7,461 1,800 3,372,221 29 842 rio.public.temp0000288130 12 0 0 0 0 0 0 952 69 66,860 0 0 brasilia.pg_catalog.pg_class 12 12 0 0 0 0 0 2,520 457 789,279 32 104 rio.public.temp0000288401 10 0 0 0 0 0 0 706 188 270,490 0 0 brasilia.pg_catalog.pg_type 10 10 0 0 0 0 0 1,013 210 336,396 19 48 brasilia.public.temp0000238246 9 0 0 0 0 0 0 2,205 1,004 1,647,668 0 0 rio.public.tmp_drill_0320 8 3 0 0 0 0 0 383 31 88,189 1 43 brasilia.pg_catalog.pg_index 7 7 0 0 0 0 0 402 67 82,327 16 26 rio.public.temp0000288146 7 0 0 0 0 0 0 614 39 42,836 0 0 rio.public.temp0000288534 7 0 0 0 0 0 0 5,210 24 311,351 0 0 rio.public.tmp_drill_0302 6 5 0 0 0 0 0 2,147 165 516,197 1 44 rio.public.temp0000288500 6 0 0 0 0 0 0 10,380 24 616,038 0 0 brasilia.pg_catalog.pg_depend 6 6 0 0 0 0 0 1,681 429 707,137 20 162 contagem.pg_catalog.pg_class 5 5 0 0 0 0 0 1,249 228 394,562 12 39 brasilia.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 649 293 417,887 48 91 rio.public.temp0000288471 5 0 0 0 0 0 0 477 28 32,715 0 0 rio.pg_toast.pg_toast_2619 5 5 0 0 0 0 0 1,872 563 2,603,453 149 347 contagem.pg_catalog.pg_type 5 5 0 0 0 0 0 631 158 240,167 5 14 rio.public.temp0000288124 4 0 0 0 0 0 0 209 23 15,733 0 0 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 1,148 237 544,060 6 59 contagem.pg_catalog.pg_index 3 3 0 0 0 0 0 208 47 54,407 4 8 rio.public.temp0000288136 3 0 0 0 0 0 0 264 17 18,245 0 0 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,303 987 3,784,089 699 4,590 brasilia.public.temp0000238218 3 0 0 0 0 0 0 735 12 45,174 0 0 postgres.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 460 137 231,667 11 26 contagem.public.temp0000226832 3 0 0 0 0 0 0 332 18 22,461 0 0 brasilia.public.temp0000238250 2 0 0 0 0 0 0 490 8 30,116 0 0 brasilia.public.temp0000238190 2 0 0 0 0 0 0 490 8 30,116 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 333 82 312,705 31 66 rio.public.temp0000288506 2 0 0 0 0 0 0 228 10 15,062 0 0 contagem.public.nf_entrada 2 2 0 0 0 0 0 192 6 26,025 0 0 rio.public.temp0000288477 2 0 0 0 0 0 0 122 11 9,041 0 0 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,020 1,213 3,915,785 1,063 7,345 rio.public.temp0000288134 2 0 0 0 0 0 0 207 12 14,048 0 0 contagem.public.temp0000226812 2 0 0 0 0 0 0 221 12 14,956 0 0 rio.public.temp0000288510 1 0 0 0 0 0 0 67 6 4,817 0 0 rio.public.temp0000288520 1 0 0 0 0 0 0 117 6 7,878 0 0 contagem.public.nf_entrada_arquivo_erros 1 1 0 0 0 0 0 2,290 1,834 5,232,390 7 298 rio.public.temp0000288522 1 0 0 0 0 0 0 117 6 7,878 0 0 rio.public.temp0000288465 1 0 0 0 0 0 0 63 6 4,579 0 0 rio.public.temp0000288449 1 0 0 0 0 0 0 49 6 3,715 0 0 rio.public.temp0000288516 1 0 0 0 0 0 0 1,730 1,730 2,329,681 0 0 brasilia.public.nf_entrada 1 1 0 0 0 0 0 151 81 201,226 12 20 rio.auditor.auditor_2026_08 1 0 0 0 0 0 0 110,318 42,791 58,534,493 33,820 662,782 brasilia.public.temp0000238230 1 0 0 0 0 0 0 245 4 15,058 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 153 63 211,894 19 36 rio.public.temp0000288419 1 0 0 0 0 0 0 4 3 774 0 0 brasilia.public.temp0000238238 1 0 0 0 0 0 0 245 4 15,058 0 0 rio.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 2,176 1,949 5,371,506 126 6,124 rio.public.temp0000288461 1 0 0 0 0 0 0 62 6 4,521 0 0 rio.pg_catalog.pg_sequence 1 1 0 0 0 0 0 9 8 7,223 1 41 rio.public.temp0000288479 1 0 0 0 0 0 0 8 5 1,252 0 0 rio.public.temp0000288524 1 0 0 0 0 0 0 117 6 7,878 0 0 rio.public.temp0000288467 1 0 0 0 0 0 0 8 5 1,340 0 0 contagem.public.lote_caixas 1 1 0 0 0 0 0 448 301 1,058,020 25 944 rio.pg_catalog.pg_attrdef 1 1 0 0 0 0 0 25 17 21,172 1 14 rio.public.temp0000288409 1 0 0 0 0 0 0 8 5 1,343 0 0 rio.public.temp0000288473 1 0 0 0 0 0 0 63 6 4,581 0 0 Total 777 266 0 0 0 0 0 313,653 82,115 144,565,370 38,757 705,360 Vacuum throughput per table
Key values
- auditor.auditor_2026_08 (16.44) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 5.99 rio.pg_catalog.pg_class 0 0 1.23 rio.public.usuarios 0 0 0.04 rio.pg_catalog.pg_type 0 0 0.43 rio.pg_catalog.pg_index 0 0 0.47 contagem.public.usuarios 0 0 0.01 rio.pg_catalog.pg_depend 0 0 1.63 rio.public.temp0000288387 0 0 1.46 rio.public.temp0000288373 0 0 1.34 rio.public.temp0000288427 0 0 0.51 rio.public.temp0000288469 0 0 0.87 rio.public.tmp_drill_0175 0 0 0.04 rio.public.temp0000288508 0 0 0.49 brasilia.pg_catalog.pg_attribute 0 0 1.27 rio.pg_catalog.pg_statistic 0 0 1.92 rio.public.temp0000288421 0 0 0.43 contagem.pg_catalog.pg_attribute 0 0 1.73 rio.public.temp0000288130 0 0 0.19 brasilia.pg_catalog.pg_class 0 0 0.56 rio.public.temp0000288401 0 0 0.21 brasilia.pg_catalog.pg_type 0 0 0.29 brasilia.public.temp0000238246 0 0 0.07 rio.public.tmp_drill_0320 0 0 0.01 brasilia.pg_catalog.pg_index 0 0 0.12 rio.public.temp0000288146 0 0 0.12 rio.public.temp0000288534 0 0 0.36 rio.public.tmp_drill_0302 0 0 0.06 rio.public.temp0000288500 0 0 0.31 brasilia.pg_catalog.pg_depend 0 0 0.34 contagem.pg_catalog.pg_class 0 0 0.65 brasilia.pg_catalog.pg_shdepend 0 0 0.45 rio.public.temp0000288471 0 0 0.08 rio.pg_toast.pg_toast_2619 0 0 0.21 contagem.pg_catalog.pg_type 0 0 0.46 rio.public.temp0000288124 0 0 0.05 contagem.pg_catalog.pg_depend 0 0 0.39 contagem.pg_catalog.pg_index 0 0 0.26 rio.public.temp0000288136 0 0 0.06 brasilia.pg_catalog.pg_statistic 0 0 0.43 brasilia.public.temp0000238218 0 0 0.02 postgres.pg_catalog.pg_shdepend 0 0 0.16 contagem.public.temp0000226832 0 0 0.05 brasilia.public.temp0000238250 0 0 0 brasilia.public.temp0000238190 0 0 0.01 brasilia.pg_toast.pg_toast_2619 0 0 0.02 rio.public.temp0000288506 0 0 0.02 contagem.public.nf_entrada 0 0 0.02 rio.public.temp0000288477 0 0 0.03 contagem.pg_catalog.pg_statistic 0 0 0.24 rio.public.temp0000288134 0 0 0.04 contagem.public.temp0000226812 0 0 0.04 rio.public.temp0000288510 0 0 0.02 rio.public.temp0000288520 0 0 0.02 contagem.public.nf_entrada_arquivo_erros 0 0 1.03 rio.public.temp0000288522 0 0 0.02 rio.public.temp0000288465 0 0 0.01 rio.public.temp0000288449 0 0 0.02 rio.public.temp0000288516 0 0 0.09 brasilia.public.nf_entrada 0 0 0.06 rio.auditor.auditor_2026_08 0 0 16.44 brasilia.public.temp0000238230 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000288419 0 0 0.04 brasilia.public.temp0000238238 0 0 0 rio.public.nf_entrada_arquivo_erros 0 0 0.98 rio.public.temp0000288461 0 0 0.01 rio.pg_catalog.pg_sequence 0 0 0 rio.public.temp0000288479 0 0 0.01 rio.public.temp0000288524 0 0 0.02 rio.public.temp0000288467 0 0 0.03 contagem.public.lote_caixas 0 0 0.26 rio.pg_catalog.pg_attrdef 0 0 0.03 rio.public.temp0000288409 0 0 0.02 rio.public.temp0000288473 0 0 0.01 Total 0 0 45.31 Tuples removed per table
Key values
- pg_catalog.pg_attribute (216196) Main table with removed tuples on database rio
- 513820 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 103 52 216,196 3,413,384 950,494 773 92,981 brasilia.pg_catalog.pg_attribute 17 17 87,955 381,440 4,366 134 10,093 contagem.pg_catalog.pg_attribute 13 13 55,222 314,732 0 382 7,108 rio.public.tmp_drill_0302 6 5 31,302 41,761 4,573 0 931 rio.pg_catalog.pg_depend 33 13 18,201 750,242 126,500 0 6,627 rio.pg_catalog.pg_statistic 14 10 16,165 134,315 10,318 0 18,004 brasilia.pg_catalog.pg_depend 6 6 9,699 106,974 1,179 0 1,123 rio.pg_catalog.pg_type 56 21 9,044 187,708 53,556 0 5,389 contagem.pg_catalog.pg_depend 3 3 6,687 56,234 0 24 536 brasilia.pg_catalog.pg_statistic 3 3 6,261 24,115 0 0 3,216 contagem.pg_catalog.pg_statistic 2 2 5,430 14,891 0 0 2,022 brasilia.pg_catalog.pg_type 10 10 5,286 22,156 0 0 714 rio.pg_catalog.pg_class 63 24 5,272 359,497 129,830 16 11,174 contagem.pg_catalog.pg_class 5 5 4,997 17,968 0 0 819 rio.pg_catalog.pg_index 44 16 4,910 110,122 25,001 34 2,931 brasilia.pg_catalog.pg_shdepend 5 5 4,657 70,135 2,135 0 615 brasilia.pg_catalog.pg_class 12 12 3,797 41,447 881 22 1,508 contagem.pg_catalog.pg_type 5 5 2,978 11,265 0 35 354 brasilia.pg_catalog.pg_index 7 7 2,877 13,357 184 0 401 postgres.pg_catalog.pg_shdepend 3 3 2,644 40,769 79 0 357 contagem.public.nf_entrada 2 2 2,427 3,078 0 0 158 rio.auditor.auditor_2026_08 1 0 2,343 9,135,148 0 0 436,636 contagem.public.usuarios 34 0 2,095 816 0 0 68 contagem.pg_catalog.pg_index 3 3 1,298 5,697 0 9 167 rio.pg_toast.pg_toast_2619 5 5 1,219 2,536 69 0 1,400 rio.public.tmp_drill_0175 19 1 1,177 53,847 26,335 0 713 brasilia.public.nf_entrada 1 1 1,034 4,871 0 0 152 rio.public.tmp_drill_0320 8 3 957 11,338 2,425 0 228 rio.public.usuarios 58 12 802 47,102 17,580 0 992 contagem.public.nf_entrada_arquivo_erros 1 1 237 447,349 0 0 8,220 brasilia.pg_toast.pg_toast_2619 2 2 197 272 0 0 128 rio.public.nf_entrada_arquivo_erros 1 0 187 8,655,971 156 0 156,488 contagem.pg_toast.pg_toast_2619 1 1 141 114 0 0 60 contagem.public.lote_caixas 1 1 82 54,134 0 0 469 rio.pg_catalog.pg_sequence 1 1 30 134 0 0 2 rio.pg_catalog.pg_attrdef 1 1 14 328 12 0 12 rio.public.temp0000288130 12 0 0 46,809 0 400 1,136 rio.public.temp0000288124 4 0 0 4,463 0 20 236 rio.public.temp0000288510 1 0 0 1,125 0 5 59 brasilia.public.temp0000238250 2 0 0 6,433 0 0 512 rio.public.temp0000288520 1 0 0 2,069 0 19 109 brasilia.public.temp0000238190 2 0 0 6,418 0 0 512 rio.public.temp0000288522 1 0 0 2,068 0 19 109 rio.public.temp0000288465 1 0 0 1,044 0 9 55 rio.public.temp0000288500 6 0 0 146,343 0 0 10,368 rio.public.temp0000288449 1 0 0 1,857 0 23 41 rio.public.temp0000288516 1 0 0 24,399 0 0 1,728 rio.public.temp0000288401 10 0 0 50,970 0 336 1,136 brasilia.public.temp0000238246 9 0 0 28,942 0 0 2,304 brasilia.public.temp0000238230 1 0 0 3,214 0 0 256 rio.public.temp0000288387 29 0 0 706,648 0 0 50,112 rio.public.temp0000288506 2 0 0 8,040 0 38 218 rio.public.temp0000288508 17 0 0 163,965 0 505 8,647 rio.public.temp0000288136 3 0 0 14,033 0 136 312 rio.public.temp0000288419 1 0 0 24,394 0 0 1,728 rio.public.temp0000288469 23 0 0 337,097 0 212 23,532 rio.public.temp0000288471 5 0 0 27,105 0 226 606 brasilia.public.temp0000238238 1 0 0 3,214 0 0 256 rio.public.temp0000288373 25 0 0 609,736 0 0 43,200 rio.public.temp0000288477 2 0 0 3,809 0 51 205 rio.public.temp0000288134 2 0 0 7,041 0 65 191 rio.public.temp0000288146 7 0 0 42,923 0 319 961 rio.public.temp0000288421 14 0 0 183,081 0 224 12,768 rio.public.temp0000288461 1 0 0 1,030 0 10 54 brasilia.public.temp0000238218 3 0 0 9,642 0 0 768 rio.public.temp0000288479 1 0 0 1,069 0 8 56 rio.public.temp0000288524 1 0 0 2,070 0 19 109 rio.public.temp0000288427 24 0 0 158,985 0 780 8,564 rio.public.temp0000288467 1 0 0 1,802 0 31 97 rio.public.temp0000288534 7 0 0 170,871 0 0 12,096 contagem.public.temp0000226812 2 0 0 2,655 0 52 204 contagem.public.temp0000226832 3 0 0 3,986 0 78 306 rio.public.temp0000288409 1 0 0 1,805 0 30 98 rio.public.temp0000288473 1 0 0 1,044 0 9 55 Total 777 266 513,820 27,347,446 1,355,673 5,053 956,500 Pages removed per table
Key values
- public.temp0000288427 (780) Main table with removed pages on database rio
- 5053 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000288427 24 0 0 780 rio.pg_catalog.pg_attribute 103 52 216196 773 rio.public.temp0000288508 17 0 0 505 rio.public.temp0000288130 12 0 0 400 contagem.pg_catalog.pg_attribute 13 13 55222 382 rio.public.temp0000288401 10 0 0 336 rio.public.temp0000288146 7 0 0 319 rio.public.temp0000288471 5 0 0 226 rio.public.temp0000288421 14 0 0 224 rio.public.temp0000288469 23 0 0 212 rio.public.temp0000288136 3 0 0 136 brasilia.pg_catalog.pg_attribute 17 17 87955 134 contagem.public.temp0000226832 3 0 0 78 rio.public.temp0000288134 2 0 0 65 contagem.public.temp0000226812 2 0 0 52 rio.public.temp0000288477 2 0 0 51 rio.public.temp0000288506 2 0 0 38 contagem.pg_catalog.pg_type 5 5 2978 35 rio.pg_catalog.pg_index 44 16 4910 34 rio.public.temp0000288467 1 0 0 31 rio.public.temp0000288409 1 0 0 30 contagem.pg_catalog.pg_depend 3 3 6687 24 rio.public.temp0000288449 1 0 0 23 brasilia.pg_catalog.pg_class 12 12 3797 22 rio.public.temp0000288124 4 0 0 20 rio.public.temp0000288520 1 0 0 19 rio.public.temp0000288522 1 0 0 19 rio.public.temp0000288524 1 0 0 19 rio.pg_catalog.pg_class 63 24 5272 16 rio.public.temp0000288461 1 0 0 10 rio.public.temp0000288465 1 0 0 9 contagem.pg_catalog.pg_index 3 3 1298 9 rio.public.temp0000288473 1 0 0 9 rio.public.temp0000288479 1 0 0 8 rio.public.temp0000288510 1 0 0 5 contagem.pg_catalog.pg_class 5 5 4997 0 brasilia.public.temp0000238250 2 0 0 0 rio.public.tmp_drill_0320 8 3 957 0 brasilia.pg_catalog.pg_shdepend 5 5 4657 0 rio.pg_catalog.pg_type 56 21 9044 0 contagem.public.nf_entrada_arquivo_erros 1 1 237 0 rio.public.usuarios 58 12 802 0 brasilia.public.temp0000238190 2 0 0 0 rio.public.tmp_drill_0302 6 5 31302 0 brasilia.pg_toast.pg_toast_2619 2 2 197 0 rio.public.temp0000288500 6 0 0 0 rio.public.temp0000288516 1 0 0 0 brasilia.public.nf_entrada 1 1 1034 0 brasilia.public.temp0000238246 9 0 0 0 rio.pg_catalog.pg_depend 33 13 18201 0 rio.auditor.auditor_2026_08 1 0 2343 0 brasilia.public.temp0000238230 1 0 0 0 contagem.public.usuarios 34 0 2095 0 rio.public.temp0000288387 29 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 141 0 rio.pg_catalog.pg_statistic 14 10 16165 0 contagem.public.nf_entrada 2 2 2427 0 brasilia.pg_catalog.pg_depend 6 6 9699 0 rio.public.temp0000288419 1 0 0 0 brasilia.public.temp0000238238 1 0 0 0 rio.public.temp0000288373 25 0 0 0 brasilia.pg_catalog.pg_index 7 7 2877 0 brasilia.pg_catalog.pg_type 10 10 5286 0 brasilia.pg_catalog.pg_statistic 3 3 6261 0 contagem.pg_catalog.pg_statistic 2 2 5430 0 rio.public.nf_entrada_arquivo_erros 1 0 187 0 brasilia.public.temp0000238218 3 0 0 0 rio.pg_catalog.pg_sequence 1 1 30 0 postgres.pg_catalog.pg_shdepend 3 3 2644 0 contagem.public.lote_caixas 1 1 82 0 rio.pg_toast.pg_toast_2619 5 5 1219 0 rio.public.temp0000288534 7 0 0 0 rio.pg_catalog.pg_attrdef 1 1 14 0 rio.public.tmp_drill_0175 19 1 1177 0 Total 777 266 513,820 5,053 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 14 00 0 0 01 0 5 02 0 0 03 0 0 04 0 0 05 6 6 06 2 6 07 38 70 08 53 127 09 91 157 10 185 149 11 181 162 12 21 40 13 38 72 14 48 132 15 88 160 16 16 34 17 7 15 18 0 0 19 0 0 20 0 0 21 3 3 22 0 0 23 0 0 - 16.44 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 11 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 6 12m45s 17s467ms 5m56s 2m7s select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT LEGADO "SAP (LEGADO)", COALESCE((RS_FAST_BARRAS(EQ_ID)).NS, (RS_FAST_BARRAS(EQ_ID)).BARRA1 )"SERIAL",END_PRINCIPAL "ENDEREÇÁVEL PRINCIPAL", ACESSORIO2 "SMART", SITUACAO "STATUS" FROM POSICAO_ESTOQUE WHERE ( NOT TCN_ID IN (38,39,37)) AND SIT_ID IN (1,2,3,5,6) ;' , '/var/www/html/tmp/Status-Oficina_80.xlsx');
Date: 2026-08-14 11:10:41 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM POSICAO_ESTOQUE WHERE GRU_ID = 2 AND OFI_ID = 6;', '/var/www/html/tmp/posicao_oficina_80.xlsx');
Date: 2026-08-14 10:29:16 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM POSICAO_ESTOQUE WHERE GRU_ID = 2 AND OFI_ID = 6;', '/var/www/html/tmp/posicao_oficina_80.xlsx');
Date: 2026-08-14 10:48:55 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
2 1 5m31s 5m31s 5m31s 5m31s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277973, 507, '2102312JCYRYL4003045,8CE5EFC0456B,4857544317F96CA2JCYRYL4005107,8CE5EFC04B10,4857544317F9C1A2JCYRYK9004402,1C20DB824E69,4857544374F52C9FJCYRYL2011436,30E98E83D109,485754432150B9A1RGBRYJA044661,F87588084DC0,485754439668D99DJCYRYK9013929,D0C65B28D670,485754438C10A69FJCYRYK9014137,D0C65B28C3A5,485754438C0F8B9FJCYRYK1007401,2841C6886E17,485754434192179EJCYRYK9011744,18CF24AAD93C,485754438470109FJCYRYKB006890,CC0577B61353,48575443E4EE2E9F', '', 0147, 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":""}]', '$$$$$$$$$', '8CE5EFC0456E||8CE5EFC04B13||1C20DB824E6C||30E98E83D10C ||F87588084DC3||D0C65B28D673||D0C65B28C3A8||2841C6886E1A||18CF24AAD93F||CC0577B61356', 00);
Date: 2026-08-14 09:21:42 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277785, 452, '2102312JCYRYK5000104,04FE8DA7B2B8,48575443DB777E9EJCYRYK9013451,D0C65B276E69,485754438C07B89FJCYRYL2001795,AC8D34A05F50,48575443157E97A1JCYRYK5000075,04FE8DA7B32F,48575443DB77859EJCYRYKB002784,CC0577BE25B0,48575443E4F6779FJCYRYK9014374,D0C65B272C45,485754438C03D49FJCYRYK1005531,2841C688CD62,485754434197B29EJCYRYKA001431,D0C65BF2BC43,4857544394FE0D9FRGBRYJA050056,14A0F826C4FA,4857544396B3069DJCYRYK9017592,D0C65B274EEF,485754438C05DE9FJCYRYK9014987,D0C65B294C2D,485754438C17939FRGBRYJA044108,14A0F82A442F,4857544396ECFC9DJCYRYK9013564,D0C65B26A7EC,485754438BFC0B9FJCYRYK9907850,D0C65B2FCD84,485754438C57519F', '',0147,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-14 13:52:38 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277965, 507, '2102311RGB6RHC001983,E86819BFF627,485754437857AF9BRGBRYJ9009022,AC751D14ACBD,4857544376ECCF9DRGB6RJ9025148,4857021511E7,4857544382A6E29DJCY6RL4009736,8CE5EFD26133,4857544318C533A2RGBRYJ9004528,AC751D13A6F2,4857544376DDEF9DRGBRYJA030757,4857028A094A,485754438D48479D', '', 0126, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""}]', '$$$$$$$$$', 'E86819BFF629||AC751D14ACBF||4857021511EA||8CE5EFD26136||AC751D13A6F5||4857028A094D||||||||', 00);
Date: 2026-08-14 08:55:50 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
3 3 3m5s 12s650ms 2m27s 1m1s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-14 08:27:47 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-14 10:35:46 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-14 09:35:31 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
4 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000288508;-
DROP TABLE IF EXISTS temp0000288508;
Date: 2026-08-14 13:43:46 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
DROP TABLE IF EXISTS temp0000288508;
Date: 2026-08-14 13:43:46 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Queries that waited the most
Rank Wait time Query 1 5m56s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028516, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-14 12:09:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 5m31s SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277973, 507, '2102312JCYRYL4003045,8CE5EFC0456B,4857544317F96CA2$2102312JCYRYL4005107,8CE5EFC04B10,4857544317F9C1A2$2102312JCYRYK9004402,1C20DB824E69,4857544374F52C9F$2102312JCYRYL2011436,30E98E83D109,485754432150B9A1$02311RGBRYJA044661,F87588084DC0,485754439668D99D$2102312JCYRYK9013929,D0C65B28D670,485754438C10A69F$2102312JCYRYK9014137,D0C65B28C3A5,485754438C0F8B9F$02312JCYRYK1007401,2841C6886E17,485754434192179E$2102312JCYRYK9011744,18CF24AAD93C,485754438470109F$2102312JCYRYKB006890,CC0577B61353,48575443E4EE2E9F', '', 0147, 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":""}]', '$$$$$$$$$', '8CE5EFC0456E||8CE5EFC04B13||1C20DB824E6C||30E98E83D10C ||F87588084DC3||D0C65B28D673||D0C65B28C3A8||2841C6886E1A||18CF24AAD93F||CC0577B61356', 00);[ Date: 2026-08-14 09:21:41 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 3m25s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028469, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-14 08:06:20 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 2m27s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-14 08:27:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 1m40s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028491, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-14 09:35:30 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 54s394ms SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028463, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-14 07:29:25 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 30s801ms SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028511, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');[ Date: 2026-08-14 11:27:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 25s752ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-14 10:35:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 17s467ms SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028501, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-14 10:35:45 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 12s650ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-14 09:35:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 1s1ms DROP TABLE IF EXISTS temp0000288508;[ Date: 2026-08-14 13:43:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 5,052 Total read queries
- 1,729 Total write queries
Queries by database
Key values
- rio Main database
- 4,718 Requests
- 10h23s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 14,113 Requests
User Request type Count Duration etiquetas Total 148 35s15ms select 148 35s15ms intelifix Total 14,113 23h45m4s copy to 762 1h37m54s ddl 2,476 2h19m53s others 1,075 1h49m21s select 9,798 17h57m53s lenon Total 258 2m47s others 1 150ms select 257 2m47s Duration by user
Key values
- 23h45m4s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 148 35s15ms select 148 35s15ms intelifix Total 14,113 23h45m4s copy to 762 1h37m54s ddl 2,476 2h19m53s others 1,075 1h49m21s select 9,798 17h57m53s lenon Total 258 2m47s others 1 150ms select 257 2m47s Queries by host
Key values
- [local] Main host
- 14,515 Requests
- 23h48m25s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 6,081 Requests
- 6h34m30s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-14 05:32:11 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,832 100-500ms duration
Slowest individual queries
Rank Duration Query 1 35m25s SELECT * FROM RS_FAST_EXCEL ('SELECT LEGADO "SAP (LEGADO)", COALESCE((RS_FAST_BARRAS(EQ_ID)).NS, (RS_FAST_BARRAS(EQ_ID)).BARRA1 )"SERIAL",END_PRINCIPAL "ENDEREÇÁVEL PRINCIPAL", ACESSORIO2 "SMART", SITUACAO "STATUS" FROM POSICAO_ESTOQUE WHERE ( NOT TCN_ID IN (38,39,37)) AND SIT_ID IN (1,2,3,5,6) ;' , '/var/www/html/tmp/Status-Oficina_80.xlsx');[ Date: 2026-08-14 11:10:41 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 15m41s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM POSICAO_ESTOQUE WHERE GRU_ID = 2 AND OFI_ID = 6;', '/var/www/html/tmp/posicao_oficina_80.xlsx');[ Date: 2026-08-14 10:29:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 14m40s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM POSICAO_ESTOQUE WHERE GRU_ID = 2 AND OFI_ID = 6;', '/var/www/html/tmp/posicao_oficina_80.xlsx');[ Date: 2026-08-14 10:48:55 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 13m30s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM POSICAO_ESTOQUE WHERE OFI_ID = 6;', '/var/www/html/tmp/posicao_oficina_80.xlsx');[ Date: 2026-08-14 11:16:12 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 13m26s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM POSICAO_ESTOQUE WHERE GRU_ID = 2 AND OFI_ID = 6;', '/var/www/html/tmp/posicao_oficina_80.xlsx');[ Date: 2026-08-14 11:12:33 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 11m48s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028516, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-14 12:15:20 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 11m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-14 14:16:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 10m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-14 12:15:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 10m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-14 07:15:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 10m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-14 10:15:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 10m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-14 11:15:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 10m10s analyze verbose;[ Date: 2026-08-14 05:10:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 10m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-14 16:15:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 9m59s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028467, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-14 08:06:20 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 9m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-14 15:15:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 9m22s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028480, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-14 09:21:41 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 9m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-14 20:14:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 8m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-14 08:13:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 8m37s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028469, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-14 08:11:13 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 8m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-14 09:13:35 - 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 4h15m43s 322 155ms 35m25s 47s651ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 14 07 21 22m5s 1m3s 08 36 31m1s 51s707ms 09 50 24m33s 29s471ms 10 35 52m22s 1m29s 11 39 1h7m39s 1m44s 12 11 19m28s 1m46s 13 40 35s65ms 876ms 14 23 14m59s 39s113ms 15 48 21m51s 27s331ms 16 12 58s21ms 4s835ms 17 7 7s912ms 1s130ms [ User: intelifix - Total duration: 4h15m43s - Times executed: 322 ]
[ Application: [unknown] - Total duration: 4h15m43s - Times executed: 322 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT LEGADO "SAP (LEGADO)", COALESCE((RS_FAST_BARRAS(EQ_ID)).NS, (RS_FAST_BARRAS(EQ_ID)).BARRA1 )"SERIAL",END_PRINCIPAL "ENDEREÇÁVEL PRINCIPAL", ACESSORIO2 "SMART", SITUACAO "STATUS" FROM POSICAO_ESTOQUE WHERE ( NOT TCN_ID IN (38,39,37)) AND SIT_ID IN (1,2,3,5,6) ;' , '/var/www/html/tmp/Status-Oficina_80.xlsx');
Date: 2026-08-14 11:10:41 Duration: 35m25s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM POSICAO_ESTOQUE WHERE GRU_ID = 2 AND OFI_ID = 6;', '/var/www/html/tmp/posicao_oficina_80.xlsx');
Date: 2026-08-14 10:29:16 Duration: 15m41s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM POSICAO_ESTOQUE WHERE GRU_ID = 2 AND OFI_ID = 6;', '/var/www/html/tmp/posicao_oficina_80.xlsx');
Date: 2026-08-14 10:48:55 Duration: 14m40s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
2 2h27m23s 47 1s462ms 11m43s 3m8s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 14 07 3 11m27s 3m49s 08 3 9m20s 3m6s 09 3 9m21s 3m7s 10 3 11m10s 3m43s 11 3 11m8s 3m42s 12 3 11m48s 3m56s 13 3 7m15s 2m25s 14 3 12m20s 4m6s 15 3 10m36s 3m32s 16 3 10m40s 3m33s 17 3 7m7s 2m22s 18 3 6m9s 2m3s 19 3 6m10s 2m3s 20 2 9m44s 4m52s 21 3 6m51s 2m17s 22 3 6m11s 2m3s [ User: intelifix - Total duration: 2h27m23s - Times executed: 47 ]
[ Application: psql - Total duration: 2h27m23s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-14 14:16:44 Duration: 11m43s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-14 12:15:54 Duration: 10m53s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-14 07:15:36 Duration: 10m34s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
3 1h22m49s 48 216ms 5m8s 1m43s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 14 07 3 6m34s 2m11s 08 3 4m25s 1m28s 09 3 6m1s 2m 10 3 6m30s 2m10s 11 3 6m22s 2m7s 12 3 6m37s 2m12s 13 3 4m12s 1m24s 14 3 6m18s 2m6s 15 3 5m59s 1m59s 16 3 5m19s 1m46s 17 3 3m57s 1m19s 18 3 3m44s 1m14s 19 3 3m53s 1m17s 20 3 5m12s 1m44s 21 3 3m54s 1m18s 22 3 3m44s 1m14s [ User: intelifix - Total duration: 1h22m49s - Times executed: 48 ]
[ Application: psql - Total duration: 1h22m49s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-14 10:22:32 Duration: 5m8s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-14 12:23:13 Duration: 5m8s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-14 07:22:52 Duration: 5m5s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
4 29m31s 1,542 150ms 5m32s 1s149ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 14 07 105 1m48s 1s33ms 08 157 2m33s 980ms 09 200 8m31s 2s559ms 10 255 4m13s 992ms 11 245 3m49s 935ms 12 61 58s186ms 953ms 13 90 1m19s 887ms 14 232 3m3s 790ms 15 154 2m11s 854ms 16 21 32s124ms 1s529ms 17 22 30s168ms 1s371ms [ User: intelifix - Total duration: 29m31s - Times executed: 1542 ]
[ Application: [unknown] - Total duration: 29m31s - Times executed: 1542 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277973, 507, '2102312JCYRYL4003045,8CE5EFC0456B,4857544317F96CA2JCYRYL4005107,8CE5EFC04B10,4857544317F9C1A2JCYRYK9004402,1C20DB824E69,4857544374F52C9FJCYRYL2011436,30E98E83D109,485754432150B9A1RGBRYJA044661,F87588084DC0,485754439668D99DJCYRYK9013929,D0C65B28D670,485754438C10A69FJCYRYK9014137,D0C65B28C3A5,485754438C0F8B9FJCYRYK1007401,2841C6886E17,485754434192179EJCYRYK9011744,18CF24AAD93C,485754438470109FJCYRYKB006890,CC0577B61353,48575443E4EE2E9F', '', 0147, 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":""}]', '$$$$$$$$$', '8CE5EFC0456E||8CE5EFC04B13||1C20DB824E6C||30E98E83D10C ||F87588084DC3||D0C65B28D673||D0C65B28C3A8||2841C6886E1A||18CF24AAD93F||CC0577B61356', 00);
Date: 2026-08-14 09:21:42 Duration: 5m32s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277785, 452, '2102312JCYRYK5000104,04FE8DA7B2B8,48575443DB777E9EJCYRYK9013451,D0C65B276E69,485754438C07B89FJCYRYL2001795,AC8D34A05F50,48575443157E97A1JCYRYK5000075,04FE8DA7B32F,48575443DB77859EJCYRYKB002784,CC0577BE25B0,48575443E4F6779FJCYRYK9014374,D0C65B272C45,485754438C03D49FJCYRYK1005531,2841C688CD62,485754434197B29EJCYRYKA001431,D0C65BF2BC43,4857544394FE0D9FRGBRYJA050056,14A0F826C4FA,4857544396B3069DJCYRYK9017592,D0C65B274EEF,485754438C05DE9FJCYRYK9014987,D0C65B294C2D,485754438C17939FRGBRYJA044108,14A0F82A442F,4857544396ECFC9DJCYRYK9013564,D0C65B26A7EC,485754438BFC0B9FJCYRYK9907850,D0C65B2FCD84,485754438C57519F', '',0147,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-14 13:52:38 Duration: 9s902ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277965, 507, '2102311RGB6RHC001983,E86819BFF627,485754437857AF9BRGBRYJ9009022,AC751D14ACBD,4857544376ECCF9DRGB6RJ9025148,4857021511E7,4857544382A6E29DJCY6RL4009736,8CE5EFD26133,4857544318C533A2RGBRYJ9004528,AC751D13A6F2,4857544376DDEF9DRGBRYJA030757,4857028A094A,485754438D48479D', '', 0126, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""}]', '$$$$$$$$$', 'E86819BFF629||AC751D14ACBF||4857021511EA||8CE5EFD26136||AC751D13A6F5||4857028A094D||||||||', 00);
Date: 2026-08-14 08:55:50 Duration: 7s159ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
5 19m51s 3 2m59s 10m10s 6m37s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 14 05 3 19m51s 6m37s [ User: intelifix - Total duration: 19m51s - Times executed: 3 ]
[ Application: psql - Total duration: 19m51s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-14 05:10:11 Duration: 10m10s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
analyze verbose;
Date: 2026-08-14 05:16:53 Duration: 6m41s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
analyze verbose;
Date: 2026-08-14 05:19:53 Duration: 2m59s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
6 16m47s 274 214ms 2m34s 3s677ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 14 00 12 41s728ms 3s477ms 01 12 30s46ms 2s503ms 02 12 29s153ms 2s429ms 03 12 30s621ms 2s551ms 04 12 28s768ms 2s397ms 05 12 28s648ms 2s387ms 06 12 31s24ms 2s585ms 07 12 35s172ms 2s931ms 08 12 2m59s 14s985ms 09 12 53s607ms 4s467ms 10 12 1m23s 6s996ms 11 11 48s323ms 4s393ms 12 12 36s711ms 3s59ms 13 12 35s108ms 2s925ms 14 12 41s461ms 3s455ms 15 11 39s674ms 3s606ms 16 12 35s625ms 2s968ms 17 12 31s795ms 2s649ms 18 12 32s577ms 2s714ms 19 12 30s506ms 2s542ms 20 12 39s980ms 3s331ms 21 12 32s161ms 2s680ms 22 12 31s233ms 2s602ms [ User: intelifix - Total duration: 16m47s - Times executed: 274 ]
[ Application: psql - Total duration: 16m47s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-14 08:27:47 Duration: 2m34s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-14 10:35:46 Duration: 34s318ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-14 09:35:31 Duration: 18s622ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
7 14m46s 77 1s776ms 42s309ms 11s516ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 14 07 3 25s938ms 8s646ms 08 3 54s586ms 18s195ms 09 8 1m12s 9s123ms 10 10 2m28s 14s884ms 11 9 2m16s 15s167ms 12 3 11s947ms 3s982ms 13 7 1m14s 10s629ms 14 11 1m59s 10s891ms 15 9 2m11s 14s609ms 16 6 1m26s 14s381ms 17 8 23s960ms 2s995ms [ User: intelifix - Total duration: 14m46s - Times executed: 77 ]
[ Application: [unknown] - Total duration: 14m46s - Times executed: 77 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-14', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-14 11:33:25 Duration: 42s309ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-14', 0175, '', '', 0, 6, '2026-08-01');
Date: 2026-08-14 11:10:14 Duration: 40s569ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-14', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-14 09:25:17 Duration: 35s502ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
8 10m37s 45 10s665ms 47s713ms 14s167ms create table temp0000288469 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 14 09 12 2m33s 12s756ms 10 6 1m56s 19s486ms 12 3 38s6ms 12s668ms 14 15 3m32s 14s167ms 15 9 1m57s 13s1ms [ User: intelifix - Total duration: 10m37s - Times executed: 45 ]
[ Application: [unknown] - Total duration: 10m37s - Times executed: 45 ]
-
CREATE TABLE temp0000288469 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 10:25:35 Duration: 47s713ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288469 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 14:14:15 Duration: 16s554ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288469 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 14:42:43 Duration: 15s633ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
9 10m33s 50 10s406ms 16s201ms 12s663ms create table temp0000288387 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 14 07 18 3m42s 12s357ms 08 6 1m10s 11s760ms 09 11 2m18s 12s609ms 10 5 1m9s 13s996ms 11 2 30s357ms 15s178ms 12 3 36s233ms 12s77ms 14 2 26s768ms 13s384ms 15 3 38s118ms 12s706ms [ User: intelifix - Total duration: 10m33s - Times executed: 50 ]
[ Application: [unknown] - Total duration: 10m33s - Times executed: 50 ]
-
CREATE TABLE temp0000288387 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 10:32:46 Duration: 16s201ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288387 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 11:54:30 Duration: 16s132ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288387 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 07:27:15 Duration: 15s464ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
10 9m51s 152 156ms 17s475ms 3s890ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 14 00 6 28s156ms 4s692ms 01 5 12s504ms 2s500ms 02 6 13s143ms 2s190ms 03 4 12s859ms 3s214ms 04 6 12s234ms 2s39ms 05 4 10s565ms 2s641ms 07 11 47s892ms 4s353ms 08 12 57s470ms 4s789ms 09 12 1m 5s21ms 10 12 1m 5s45ms 11 12 1m6s 5s545ms 12 12 59s157ms 4s929ms 13 7 10s184ms 1s454ms 14 12 53s745ms 4s478ms 15 10 40s690ms 4s69ms 16 6 9s918ms 1s653ms 17 3 3s880ms 1s293ms 20 1 347ms 347ms 21 5 15s410ms 3s82ms 22 6 15s832ms 2s638ms [ User: intelifix - Total duration: 9m51s - Times executed: 152 ]
[ Application: psql - Total duration: 9m51s - Times executed: 152 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-14 00:05:19 Duration: 17s475ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-14 08:25:13 Duration: 12s243ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-14 14:45:12 Duration: 11s410ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
11 9m13s 950 150ms 6s818ms 582ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 14 06 5 6s714ms 1s342ms 07 77 42s805ms 555ms 08 103 53s6ms 514ms 09 147 1m24s 576ms 10 138 1m29s 648ms 11 108 1m26s 797ms 12 24 17s327ms 721ms 13 68 40s279ms 592ms 14 114 58s810ms 515ms 15 130 58s839ms 452ms 16 33 13s762ms 417ms 17 3 1s530ms 510ms [ User: intelifix - Total duration: 9m13s - Times executed: 950 ]
[ Application: [unknown] - Total duration: 9m13s - Times executed: 950 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "230007", "modelo" : "320", "itens" : "241701742730,241694955266,241654845358,241699259198,241593254454,230049304250,241695625264,241674513552,241695118693,241654561717,241661060915,241607167899,241714693141,241610896871,241622637074,241617367985,241713020307,241614465267,241708964355,241704364456,241622631014,241670390928,241622440008,241652290306,241704161227,241620778183,241610084357,241663175868,241622485466,241657626168,241714943850,241622543856,241656698086,241629127483,241680303556,241646268910,241726632836,241678325865,241689391626,241658760006,241658797685,241694493852,241615859107,241666320306,241660090910", "usuario" : "414", "caixa" : "2756724", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-14 11:36:24 Duration: 6s818ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "106328", "modelo" : "160", "itens" : "229851695357,229847315053,229841176878,229848362541,229843468190,229856378901,229853099501,229763092547,229862140014,229842651636,229841895265,229845932427,229763132932,229846870813,229852617175,229843477787,229853732829,229842851229,229852635460,229838524869,229851994354,229841831219,229853701940,229842132943,229853773338,229846929101,229851794458,229856975659,229853716688,229853992832,229855941227,229841158492,229843483546,229842291522,229846635256,229853323844", "usuario" : "414", "caixa" : "1240990", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-14 10:47:18 Duration: 3s681ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "207113", "modelo" : "454", "itens" : "241613201721,241623641124,241612462850,241634136973,241612445575,241624883052,241624699902,241623978989,241632773036,241600559903,241643844554,241614383643,241641600924,241624244448,241624416283,241624889517,241624865171,241611405058,241632645167,241627148199,241625129696,241625186268,241625359393,241626681836,241625480619,241642270518,241613690916,241600455067,241624462932,241643750505,241634302344,241613943140,241613923138,241624407797,241600335055,241634141621,241634141217,241626567177,241613867071,241613581635,241632404257,241626573744,241634160916,241634139397,241625121010", "usuario" : "414", "caixa" : "2521937", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-14 11:16:44 Duration: 2s983ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
12 8m3s 30 10s897ms 47s320ms 16s100ms create table temp0000288373 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 14 06 1 47s320ms 47s320ms 07 1 10s996ms 10s996ms 10 7 1m57s 16s731ms 11 13 3m28s 16s46ms 12 3 36s964ms 12s321ms 14 1 13s417ms 13s417ms 15 4 48s575ms 12s143ms [ User: intelifix - Total duration: 8m3s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 8m3s - Times executed: 30 ]
-
CREATE TABLE temp0000288373 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 06:58:38 Duration: 47s320ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288373 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 11:05:57 Duration: 31s173ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288373 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 11:00:28 Duration: 26s598ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
13 6m42s 32 11s183ms 14s660ms 12s589ms create table temp0000288421 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 14 07 12 2m33s 12s764ms 08 14 2m55s 12s516ms 09 6 1m14s 12s408ms [ User: intelifix - Total duration: 6m42s - Times executed: 32 ]
[ Application: [unknown] - Total duration: 6m42s - Times executed: 32 ]
-
CREATE TABLE temp0000288421 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 07:42:48 Duration: 14s660ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288421 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 07:43:21 Duration: 14s342ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288421 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 08:01:13 Duration: 14s1ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
14 4m33s 60 171ms 43s343ms 4s555ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 14 07 5 34s162ms 6s832ms 08 7 11s294ms 1s613ms 09 12 38s703ms 3s225ms 10 5 33s680ms 6s736ms 11 9 11s504ms 1s278ms 12 3 46s65ms 15s355ms 13 4 33s474ms 8s368ms 14 4 22s674ms 5s668ms 15 11 41s767ms 3s797ms [ User: intelifix - Total duration: 4m33s - Times executed: 60 ]
[ Application: psql - Total duration: 4m33s - Times executed: 60 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028515);
Date: 2026-08-14 12:02:30 Duration: 43s343ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028519);
Date: 2026-08-14 13:34:06 Duration: 21s335ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028498);
Date: 2026-08-14 10:27:22 Duration: 21s90ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
15 3m52s 19 10s722ms 13s994ms 12s250ms create table temp0000288427 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 14 09 19 3m52s 12s250ms [ User: intelifix - Total duration: 3m52s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 3m52s - Times executed: 19 ]
-
CREATE TABLE temp0000288427 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 09:50:01 Duration: 13s994ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288427 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 09:49:40 Duration: 13s989ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288427 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 09:07:40 Duration: 13s402ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
16 3m46s 18 10s861ms 15s205ms 12s569ms create table temp0000288534 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 14 15 18 3m46s 12s569ms [ User: intelifix - Total duration: 3m46s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 3m46s - Times executed: 18 ]
-
CREATE TABLE temp0000288534 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 15:28:41 Duration: 15s205ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288534 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 15:06:26 Duration: 14s10ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288534 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 15:25:54 Duration: 13s802ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
17 3m16s 4 4s867ms 1m38s 49s82ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 14 20 2 1m32s 46s191ms 23 2 1m43s 51s972ms [ User: intelifix - Total duration: 3m16s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m16s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-14 23:17:52 Duration: 1m38s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-14 20:08:39 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-14 23:37:41 Duration: 5s136ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-14.log
18 3m7s 56 2s805ms 4s242ms 3s356ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 14 08 4 13s731ms 3s432ms 09 2 7s771ms 3s885ms 10 3 9s798ms 3s266ms 11 5 16s244ms 3s248ms 12 3 10s20ms 3s340ms 13 5 17s66ms 3s413ms 14 4 15s71ms 3s767ms 15 4 12s829ms 3s207ms 16 5 15s939ms 3s187ms 17 3 10s202ms 3s400ms 18 4 12s22ms 3s5ms 19 4 14s309ms 3s577ms 20 4 14s44ms 3s511ms 21 3 9s273ms 3s91ms 22 3 9s646ms 3s215ms [ User: intelifix - Total duration: 3m7s - Times executed: 56 ]
[ Application: psql - Total duration: 3m7s - Times executed: 56 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-14 09:00:09 Duration: 4s242ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-14 14:00:05 Duration: 4s176ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-14 14:00:09 Duration: 4s129ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
19 2m52s 473 151ms 1s496ms 365ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 14 09 21 13s132ms 625ms 10 83 27s781ms 334ms 11 136 47s681ms 350ms 13 52 14s278ms 274ms 14 140 48s683ms 347ms 15 22 7s266ms 330ms 16 19 14s48ms 739ms [ User: intelifix - Total duration: 2m52s - Times executed: 473 ]
[ Application: [unknown] - Total duration: 2m52s - Times executed: 473 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"52974","seriais":"246316961623","usuario":"409","observacao":""}');
Date: 2026-08-14 16:18:29 Duration: 1s496ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"52974","seriais":"246227882626","usuario":"409","observacao":""}');
Date: 2026-08-14 16:22:02 Duration: 1s452ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"52724","seriais":"203AEBA7793E,802D1A1EF430,6877DA597DCF,802D1A1EF40C,D8E8448890C6,6877DA59D097,CC29BDED1931,D8E844AB00BE,CC29BDEDA4C1,30424092094C,D8E8448B2286,802D1A1EF46C,CC29BDE670CD,D8E8448A61C2,D8E8448B9B2E,30424093E1A8,6877DA5C1D7B,D8E8448A65C2,203AEBA6B99A,6877DA597EE7,D8E8448A1B5A,6877DA597E8F,802D1A1F98D4,6877DA61D053,6877DA59C097,6877DA61D167,802D1A1F8898,CC29BDED18C5,802D1A1F990C,6877DA5C1DA7,D8E8448A18D6,CC29BDED26ED,D8E844AB00EA,203AEBA73246,6877DA59B857,D8E8448B9B42,D8E844893CCA,D8E844AAFFD2","usuario":"409","observacao":""}');
Date: 2026-08-14 14:55:06 Duration: 1s367ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
20 2m31s 83 175ms 33s871ms 1s820ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 14 07 9 14s773ms 1s641ms 08 7 4s540ms 648ms 09 22 9s280ms 421ms 10 7 16s371ms 2s338ms 11 11 1m24s 7s642ms 12 4 5s111ms 1s277ms 13 6 1s647ms 274ms 14 6 6s279ms 1s46ms 15 11 9s39ms 821ms [ User: intelifix - Total duration: 2m31s - Times executed: 83 ]
[ Application: psql - Total duration: 2m31s - Times executed: 83 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028508);
Date: 2026-08-14 11:20:49 Duration: 33s871ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028505);
Date: 2026-08-14 11:05:42 Duration: 16s490ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028460);
Date: 2026-08-14 07:19:42 Duration: 8s487ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,542 29m31s 150ms 5m32s 1s149ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 14 07 105 1m48s 1s33ms 08 157 2m33s 980ms 09 200 8m31s 2s559ms 10 255 4m13s 992ms 11 245 3m49s 935ms 12 61 58s186ms 953ms 13 90 1m19s 887ms 14 232 3m3s 790ms 15 154 2m11s 854ms 16 21 32s124ms 1s529ms 17 22 30s168ms 1s371ms [ User: intelifix - Total duration: 29m31s - Times executed: 1542 ]
[ Application: [unknown] - Total duration: 29m31s - Times executed: 1542 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277973, 507, '2102312JCYRYL4003045,8CE5EFC0456B,4857544317F96CA2JCYRYL4005107,8CE5EFC04B10,4857544317F9C1A2JCYRYK9004402,1C20DB824E69,4857544374F52C9FJCYRYL2011436,30E98E83D109,485754432150B9A1RGBRYJA044661,F87588084DC0,485754439668D99DJCYRYK9013929,D0C65B28D670,485754438C10A69FJCYRYK9014137,D0C65B28C3A5,485754438C0F8B9FJCYRYK1007401,2841C6886E17,485754434192179EJCYRYK9011744,18CF24AAD93C,485754438470109FJCYRYKB006890,CC0577B61353,48575443E4EE2E9F', '', 0147, 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":""}]', '$$$$$$$$$', '8CE5EFC0456E||8CE5EFC04B13||1C20DB824E6C||30E98E83D10C ||F87588084DC3||D0C65B28D673||D0C65B28C3A8||2841C6886E1A||18CF24AAD93F||CC0577B61356', 00);
Date: 2026-08-14 09:21:42 Duration: 5m32s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277785, 452, '2102312JCYRYK5000104,04FE8DA7B2B8,48575443DB777E9EJCYRYK9013451,D0C65B276E69,485754438C07B89FJCYRYL2001795,AC8D34A05F50,48575443157E97A1JCYRYK5000075,04FE8DA7B32F,48575443DB77859EJCYRYKB002784,CC0577BE25B0,48575443E4F6779FJCYRYK9014374,D0C65B272C45,485754438C03D49FJCYRYK1005531,2841C688CD62,485754434197B29EJCYRYKA001431,D0C65BF2BC43,4857544394FE0D9FRGBRYJA050056,14A0F826C4FA,4857544396B3069DJCYRYK9017592,D0C65B274EEF,485754438C05DE9FJCYRYK9014987,D0C65B294C2D,485754438C17939FRGBRYJA044108,14A0F82A442F,4857544396ECFC9DJCYRYK9013564,D0C65B26A7EC,485754438BFC0B9FJCYRYK9907850,D0C65B2FCD84,485754438C57519F', '',0147,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-14 13:52:38 Duration: 9s902ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277965, 507, '2102311RGB6RHC001983,E86819BFF627,485754437857AF9BRGBRYJ9009022,AC751D14ACBD,4857544376ECCF9DRGB6RJ9025148,4857021511E7,4857544382A6E29DJCY6RL4009736,8CE5EFD26133,4857544318C533A2RGBRYJ9004528,AC751D13A6F2,4857544376DDEF9DRGBRYJA030757,4857028A094A,485754438D48479D', '', 0126, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""}]', '$$$$$$$$$', 'E86819BFF629||AC751D14ACBF||4857021511EA||8CE5EFD26136||AC751D13A6F5||4857028A094D||||||||', 00);
Date: 2026-08-14 08:55:50 Duration: 7s159ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
2 950 9m13s 150ms 6s818ms 582ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 14 06 5 6s714ms 1s342ms 07 77 42s805ms 555ms 08 103 53s6ms 514ms 09 147 1m24s 576ms 10 138 1m29s 648ms 11 108 1m26s 797ms 12 24 17s327ms 721ms 13 68 40s279ms 592ms 14 114 58s810ms 515ms 15 130 58s839ms 452ms 16 33 13s762ms 417ms 17 3 1s530ms 510ms [ User: intelifix - Total duration: 9m13s - Times executed: 950 ]
[ Application: [unknown] - Total duration: 9m13s - Times executed: 950 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "230007", "modelo" : "320", "itens" : "241701742730,241694955266,241654845358,241699259198,241593254454,230049304250,241695625264,241674513552,241695118693,241654561717,241661060915,241607167899,241714693141,241610896871,241622637074,241617367985,241713020307,241614465267,241708964355,241704364456,241622631014,241670390928,241622440008,241652290306,241704161227,241620778183,241610084357,241663175868,241622485466,241657626168,241714943850,241622543856,241656698086,241629127483,241680303556,241646268910,241726632836,241678325865,241689391626,241658760006,241658797685,241694493852,241615859107,241666320306,241660090910", "usuario" : "414", "caixa" : "2756724", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-14 11:36:24 Duration: 6s818ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "106328", "modelo" : "160", "itens" : "229851695357,229847315053,229841176878,229848362541,229843468190,229856378901,229853099501,229763092547,229862140014,229842651636,229841895265,229845932427,229763132932,229846870813,229852617175,229843477787,229853732829,229842851229,229852635460,229838524869,229851994354,229841831219,229853701940,229842132943,229853773338,229846929101,229851794458,229856975659,229853716688,229853992832,229855941227,229841158492,229843483546,229842291522,229846635256,229853323844", "usuario" : "414", "caixa" : "1240990", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-14 10:47:18 Duration: 3s681ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "207113", "modelo" : "454", "itens" : "241613201721,241623641124,241612462850,241634136973,241612445575,241624883052,241624699902,241623978989,241632773036,241600559903,241643844554,241614383643,241641600924,241624244448,241624416283,241624889517,241624865171,241611405058,241632645167,241627148199,241625129696,241625186268,241625359393,241626681836,241625480619,241642270518,241613690916,241600455067,241624462932,241643750505,241634302344,241613943140,241613923138,241624407797,241600335055,241634141621,241634141217,241626567177,241613867071,241613581635,241632404257,241626573744,241634160916,241634139397,241625121010", "usuario" : "414", "caixa" : "2521937", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-14 11:16:44 Duration: 2s983ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
3 473 2m52s 151ms 1s496ms 365ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 14 09 21 13s132ms 625ms 10 83 27s781ms 334ms 11 136 47s681ms 350ms 13 52 14s278ms 274ms 14 140 48s683ms 347ms 15 22 7s266ms 330ms 16 19 14s48ms 739ms [ User: intelifix - Total duration: 2m52s - Times executed: 473 ]
[ Application: [unknown] - Total duration: 2m52s - Times executed: 473 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"52974","seriais":"246316961623","usuario":"409","observacao":""}');
Date: 2026-08-14 16:18:29 Duration: 1s496ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"52974","seriais":"246227882626","usuario":"409","observacao":""}');
Date: 2026-08-14 16:22:02 Duration: 1s452ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"52724","seriais":"203AEBA7793E,802D1A1EF430,6877DA597DCF,802D1A1EF40C,D8E8448890C6,6877DA59D097,CC29BDED1931,D8E844AB00BE,CC29BDEDA4C1,30424092094C,D8E8448B2286,802D1A1EF46C,CC29BDE670CD,D8E8448A61C2,D8E8448B9B2E,30424093E1A8,6877DA5C1D7B,D8E8448A65C2,203AEBA6B99A,6877DA597EE7,D8E8448A1B5A,6877DA597E8F,802D1A1F98D4,6877DA61D053,6877DA59C097,6877DA61D167,802D1A1F8898,CC29BDED18C5,802D1A1F990C,6877DA5C1DA7,D8E8448A18D6,CC29BDED26ED,D8E844AB00EA,203AEBA73246,6877DA59B857,D8E8448B9B42,D8E844893CCA,D8E844AAFFD2","usuario":"409","observacao":""}');
Date: 2026-08-14 14:55:06 Duration: 1s367ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
4 322 4h15m43s 155ms 35m25s 47s651ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 14 07 21 22m5s 1m3s 08 36 31m1s 51s707ms 09 50 24m33s 29s471ms 10 35 52m22s 1m29s 11 39 1h7m39s 1m44s 12 11 19m28s 1m46s 13 40 35s65ms 876ms 14 23 14m59s 39s113ms 15 48 21m51s 27s331ms 16 12 58s21ms 4s835ms 17 7 7s912ms 1s130ms [ User: intelifix - Total duration: 4h15m43s - Times executed: 322 ]
[ Application: [unknown] - Total duration: 4h15m43s - Times executed: 322 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT LEGADO "SAP (LEGADO)", COALESCE((RS_FAST_BARRAS(EQ_ID)).NS, (RS_FAST_BARRAS(EQ_ID)).BARRA1 )"SERIAL",END_PRINCIPAL "ENDEREÇÁVEL PRINCIPAL", ACESSORIO2 "SMART", SITUACAO "STATUS" FROM POSICAO_ESTOQUE WHERE ( NOT TCN_ID IN (38,39,37)) AND SIT_ID IN (1,2,3,5,6) ;' , '/var/www/html/tmp/Status-Oficina_80.xlsx');
Date: 2026-08-14 11:10:41 Duration: 35m25s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM POSICAO_ESTOQUE WHERE GRU_ID = 2 AND OFI_ID = 6;', '/var/www/html/tmp/posicao_oficina_80.xlsx');
Date: 2026-08-14 10:29:16 Duration: 15m41s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM POSICAO_ESTOQUE WHERE GRU_ID = 2 AND OFI_ID = 6;', '/var/www/html/tmp/posicao_oficina_80.xlsx');
Date: 2026-08-14 10:48:55 Duration: 14m40s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
5 274 16m47s 214ms 2m34s 3s677ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 14 00 12 41s728ms 3s477ms 01 12 30s46ms 2s503ms 02 12 29s153ms 2s429ms 03 12 30s621ms 2s551ms 04 12 28s768ms 2s397ms 05 12 28s648ms 2s387ms 06 12 31s24ms 2s585ms 07 12 35s172ms 2s931ms 08 12 2m59s 14s985ms 09 12 53s607ms 4s467ms 10 12 1m23s 6s996ms 11 11 48s323ms 4s393ms 12 12 36s711ms 3s59ms 13 12 35s108ms 2s925ms 14 12 41s461ms 3s455ms 15 11 39s674ms 3s606ms 16 12 35s625ms 2s968ms 17 12 31s795ms 2s649ms 18 12 32s577ms 2s714ms 19 12 30s506ms 2s542ms 20 12 39s980ms 3s331ms 21 12 32s161ms 2s680ms 22 12 31s233ms 2s602ms [ User: intelifix - Total duration: 16m47s - Times executed: 274 ]
[ Application: psql - Total duration: 16m47s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-14 08:27:47 Duration: 2m34s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-14 10:35:46 Duration: 34s318ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-14 09:35:31 Duration: 18s622ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
6 157 36s281ms 150ms 633ms 231ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 14 01 20 4s470ms 223ms 05 19 4s970ms 261ms 07 10 2s26ms 202ms 08 16 3s23ms 188ms 09 7 1s604ms 229ms 10 20 4s595ms 229ms 11 21 5s90ms 242ms 12 11 2s440ms 221ms 14 16 4s217ms 263ms 15 15 3s418ms 227ms 16 2 424ms 212ms [ User: intelifix - Total duration: 36s281ms - Times executed: 157 ]
[ Application: [unknown] - Total duration: 36s281ms - Times executed: 157 ]
-
SELECT * FROM RS_TRIAGEM (407, 5, '113', 3, '230010508196,229972474956,230020860319,230032867696,230043089603,229971744750,229963205757,229972362241,229972456974,230027064661,229971647692,229988933555,229981750823,229972075770,230027114969', NULL, NULL, 0295, 00);
Date: 2026-08-14 11:14:06 Duration: 633ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_TRIAGEM (404, 5, '113', 3, '229849626973,229844972648,229725438994,229877970818,229797349414,229790037072,229770534956', NULL, NULL, 0145, 00);
Date: 2026-08-14 10:29:09 Duration: 512ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_TRIAGEM (407, 5, '113', 3, '230030058499,230030116283,230043053034,229975361939,229971919717,230020038082,230033969207,230031592836,230054266182,230027183337,229976264664,230007325271,230026176987,229970597477', NULL, NULL, 0295, 00);
Date: 2026-08-14 14:38:13 Duration: 483ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
7 152 9m51s 156ms 17s475ms 3s890ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 14 00 6 28s156ms 4s692ms 01 5 12s504ms 2s500ms 02 6 13s143ms 2s190ms 03 4 12s859ms 3s214ms 04 6 12s234ms 2s39ms 05 4 10s565ms 2s641ms 07 11 47s892ms 4s353ms 08 12 57s470ms 4s789ms 09 12 1m 5s21ms 10 12 1m 5s45ms 11 12 1m6s 5s545ms 12 12 59s157ms 4s929ms 13 7 10s184ms 1s454ms 14 12 53s745ms 4s478ms 15 10 40s690ms 4s69ms 16 6 9s918ms 1s653ms 17 3 3s880ms 1s293ms 20 1 347ms 347ms 21 5 15s410ms 3s82ms 22 6 15s832ms 2s638ms [ User: intelifix - Total duration: 9m51s - Times executed: 152 ]
[ Application: psql - Total duration: 9m51s - Times executed: 152 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-14 00:05:19 Duration: 17s475ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-14 08:25:13 Duration: 12s243ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-14 14:45:12 Duration: 11s410ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
8 148 49s500ms 150ms 7s810ms 334ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 14 01 1 258ms 258ms 02 1 290ms 290ms 05 1 280ms 280ms 07 4 1s697ms 424ms 08 2 478ms 239ms 09 5 1s659ms 331ms 10 11 2s878ms 261ms 11 22 5s912ms 268ms 12 17 14s728ms 866ms 13 8 2s406ms 300ms 14 25 6s39ms 241ms 15 45 11s721ms 260ms 16 5 813ms 162ms 17 1 334ms 334ms [ User: intelifix - Total duration: 49s500ms - Times executed: 148 ]
[ Application: [unknown] - Total duration: 49s500ms - Times executed: 148 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "407", "data-de" : "2025-10-07", "data-ate" : "2026-08-14", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 474 }');
Date: 2026-08-14 12:44:19 Duration: 7s810ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "432", "data-de" : "2026-08-13", "data-ate" : "2026-08-14", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 503 }');
Date: 2026-08-14 07:01:17 Duration: 1s143ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "430", "data-de" : "2026-08-14", "data-ate" : "2026-08-14", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 502 }');
Date: 2026-08-14 15:36:04 Duration: 929ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
9 130 1m52s 158ms 14s988ms 866ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 14 07 9 9s77ms 1s8ms 08 19 31s783ms 1s672ms 09 15 5s77ms 338ms 10 8 5s76ms 634ms 11 11 7s652ms 695ms 12 1 264ms 264ms 13 32 26s850ms 839ms 14 4 8s815ms 2s203ms 15 23 13s174ms 572ms 16 8 4s844ms 605ms [ User: intelifix - Total duration: 1m52s - Times executed: 130 ]
[ Application: [unknown] - Total duration: 1m52s - Times executed: 130 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052715) LIMIT 1;
Date: 2026-08-14 08:36:55 Duration: 14s988ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052715) LIMIT 1;
Date: 2026-08-14 08:37:09 Duration: 6s632ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0277948) LIMIT 1;
Date: 2026-08-14 13:46:44 Duration: 4s516ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
10 121 54s719ms 281ms 757ms 452ms 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 #10
Day Hour Count Duration Avg duration Aug 14 01 2 751ms 375ms 02 1 364ms 364ms 05 4 1s589ms 397ms 06 3 1s359ms 453ms 07 9 4s20ms 446ms 08 12 5s933ms 494ms 09 13 5s399ms 415ms 10 14 7s509ms 536ms 11 9 3s788ms 420ms 12 5 2s493ms 498ms 13 13 6s452ms 496ms 14 12 5s415ms 451ms 15 9 3s578ms 397ms 16 6 2s343ms 390ms 17 4 1s664ms 416ms 20 1 453ms 453ms 21 3 1s206ms 402ms 22 1 394ms 394ms [ User: lenon - Total duration: 54s719ms - Times executed: 121 ]
[ Application: [unknown] - Total duration: 54s719ms - Times executed: 121 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-14 10:18:43 Duration: 757ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-14 12:18:59 Duration: 750ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-14 07:34:47 Duration: 715ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-14.log
11 112 1m3s 351ms 905ms 567ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 14 01 2 1s188ms 594ms 02 1 519ms 519ms 05 4 2s171ms 542ms 06 3 1s648ms 549ms 07 7 4s224ms 603ms 08 11 6s563ms 596ms 09 13 6s606ms 508ms 10 14 8s990ms 642ms 11 8 4s403ms 550ms 12 5 3s120ms 624ms 13 11 6s805ms 618ms 14 12 6s767ms 563ms 15 9 4s564ms 507ms 16 5 2s377ms 475ms 17 4 2s32ms 508ms 21 2 954ms 477ms 22 1 567ms 567ms [ User: intelifix - Total duration: 1m3s - Times executed: 112 ]
[ Application: [unknown] - Total duration: 1m3s - Times executed: 112 ]
-
select * from rs_menu_grants (428, 21, 1);
Date: 2026-08-14 12:18:59 Duration: 905ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
select * from rs_menu_grants (406, 18, 1);
Date: 2026-08-14 08:14:44 Duration: 895ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
select * from rs_menu_grants (509, 21, 1);
Date: 2026-08-14 13:06:52 Duration: 870ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
12 93 21s777ms 151ms 846ms 234ms create table temp0000288427 as select * from rs_baixas_lista (?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 14 07 14 3s238ms 231ms 08 35 7s542ms 215ms 09 5 1s704ms 340ms 10 24 5s807ms 241ms 11 15 3s484ms 232ms [ User: intelifix - Total duration: 21s777ms - Times executed: 93 ]
[ Application: [unknown] - Total duration: 21s777ms - Times executed: 93 ]
-
CREATE TABLE temp0000288427 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '', '2026-08-12', '2026-08-14');
Date: 2026-08-14 09:24:00 Duration: 846ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288427 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '229809002538', '2026-08-12', '2026-08-14');
Date: 2026-08-14 08:27:53 Duration: 491ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288427 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '', '2026-08-12', '2026-08-14');
Date: 2026-08-14 10:47:25 Duration: 489ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
13 92 42s295ms 158ms 1s322ms 459ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 14 07 10 4s865ms 486ms 08 8 3s747ms 468ms 09 18 8s350ms 463ms 10 12 6s342ms 528ms 11 9 3s506ms 389ms 12 6 2s563ms 427ms 13 2 962ms 481ms 14 7 2s960ms 422ms 15 14 6s663ms 475ms 16 2 712ms 356ms 17 4 1s619ms 404ms [ User: intelifix - Total duration: 42s295ms - Times executed: 92 ]
[ Application: [unknown] - Total duration: 42s295ms - Times executed: 92 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-14 07:02:08 Duration: 1s322ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-14 10:22:34 Duration: 1s167ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-08-14 10:45:10 Duration: 1s152ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
14 83 2m31s 175ms 33s871ms 1s820ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 14 07 9 14s773ms 1s641ms 08 7 4s540ms 648ms 09 22 9s280ms 421ms 10 7 16s371ms 2s338ms 11 11 1m24s 7s642ms 12 4 5s111ms 1s277ms 13 6 1s647ms 274ms 14 6 6s279ms 1s46ms 15 11 9s39ms 821ms [ User: intelifix - Total duration: 2m31s - Times executed: 83 ]
[ Application: psql - Total duration: 2m31s - Times executed: 83 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028508);
Date: 2026-08-14 11:20:49 Duration: 33s871ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028505);
Date: 2026-08-14 11:05:42 Duration: 16s490ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028460);
Date: 2026-08-14 07:19:42 Duration: 8s487ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
15 77 14m46s 1s776ms 42s309ms 11s516ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 14 07 3 25s938ms 8s646ms 08 3 54s586ms 18s195ms 09 8 1m12s 9s123ms 10 10 2m28s 14s884ms 11 9 2m16s 15s167ms 12 3 11s947ms 3s982ms 13 7 1m14s 10s629ms 14 11 1m59s 10s891ms 15 9 2m11s 14s609ms 16 6 1m26s 14s381ms 17 8 23s960ms 2s995ms [ User: intelifix - Total duration: 14m46s - Times executed: 77 ]
[ Application: [unknown] - Total duration: 14m46s - Times executed: 77 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-14', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-14 11:33:25 Duration: 42s309ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-14', 0175, '', '', 0, 6, '2026-08-01');
Date: 2026-08-14 11:10:14 Duration: 40s569ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-14', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-14 09:25:17 Duration: 35s502ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
16 65 18s345ms 151ms 1s155ms 282ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 14 08 8 2s40ms 255ms 09 13 3s852ms 296ms 10 17 5s51ms 297ms 11 6 1s555ms 259ms 13 1 289ms 289ms 14 11 3s649ms 331ms 15 9 1s905ms 211ms [ User: intelifix - Total duration: 18s345ms - Times executed: 65 ]
[ Application: [unknown] - Total duration: 18s345ms - Times executed: 65 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, 'A8705D7DF658,A8705D834626,A8705D79666F,A8705D771EA5,A8705D86BBF8,A8705D7DE38E,F820D205DEEF,A8705D7DDCCC,F8790A2BCCDE,A8705D810947,A8705D86ACD5,A8705D7A6420,A8705D7673C9,A8705D74FBE3,A8705D79DF5A,A8705D7837DB,F820D207A301', '77;1', 'DEFAULT', 09, 0211, '','', '', 00);
Date: 2026-08-14 14:47:24 Duration: 1s155ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, 'D4B92F27923D,1062D09E70DA,383FB3A62C92,383FB3A56096,70037EA126A5,A456CCE30ECB,905851464F57,383FB3A89820,10C25A1618A0,1062D0C62C19,905851ACF989,10C25A3A50D9,BC9B689AF0AE,54A65C0FFAE1,5C76959660F5,10C25A3CA24A,90585141DB5A,B42A0ED1B35A,D4B92F2C3017,80D04ABAC600,80D04AB7E78C,A456CCDFC615,1062D01227AA,1062D09E5EDC,10C25A3C4F2A,54A65C108789,5C769593053E', '','DEFAULT',056,046,'', '','', 00);
Date: 2026-08-14 10:15:29 Duration: 673ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '80D04A911EF9,905851465776,54A65C910895,A456CCE08B96,54A65C896271,54A65C9066DF,14B7F8E0E4F1,10C25A3A8C05,48003304ADD5,B42A0E9A79A9,54A65C13D015,14B7F80EB469,80D04A91DBCF,14B7F88E082E,54A65C11BE84,B42A0E19C383,54A65C8B434F,10C25A3A5C0F,B42A0E9AE86E,383FB3A468DA,1062D010EE63,383FB3A98A10,603D265E789E,A456CCE49788,1062D0275935,70037E9AD512,087E6484B1D0', '','DEFAULT',056,046,'', '','', 00);
Date: 2026-08-14 10:38:36 Duration: 628ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
17 63 17s485ms 151ms 473ms 277ms create table temp0000226832 as select * from rs_caixas_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 14 08 1 197ms 197ms 09 6 1s121ms 186ms 10 7 1s656ms 236ms 11 16 4s128ms 258ms 14 33 10s381ms 314ms [ User: intelifix - Total duration: 17s485ms - Times executed: 63 ]
[ Application: [unknown] - Total duration: 17s485ms - Times executed: 63 ]
-
CREATE TABLE temp0000226832 AS SELECT * FROM RS_CAIXAS_LISTA (52752);
Date: 2026-08-14 14:41:37 Duration: 473ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000226832 AS SELECT * FROM RS_CAIXAS_LISTA (52752);
Date: 2026-08-14 14:24:05 Duration: 444ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000226832 AS SELECT * FROM RS_CAIXAS_LISTA (52752);
Date: 2026-08-14 14:45:11 Duration: 432ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
18 62 10s72ms 150ms 195ms 162ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 14 01 1 183ms 183ms 07 6 962ms 160ms 08 9 1s446ms 160ms 09 4 638ms 159ms 10 13 2s106ms 162ms 11 9 1s474ms 163ms 13 8 1s348ms 168ms 14 2 322ms 161ms 15 7 1s104ms 157ms 16 3 484ms 161ms [ User: intelifix - Total duration: 10s72ms - Times executed: 62 ]
[ Application: [unknown] - Total duration: 10s72ms - Times executed: 62 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0303;
Date: 2026-08-14 13:39:42 Duration: 195ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-08-14 13:19:57 Duration: 188ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0295;
Date: 2026-08-14 01:19:51 Duration: 183ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
19 60 4m33s 171ms 43s343ms 4s555ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 14 07 5 34s162ms 6s832ms 08 7 11s294ms 1s613ms 09 12 38s703ms 3s225ms 10 5 33s680ms 6s736ms 11 9 11s504ms 1s278ms 12 3 46s65ms 15s355ms 13 4 33s474ms 8s368ms 14 4 22s674ms 5s668ms 15 11 41s767ms 3s797ms [ User: intelifix - Total duration: 4m33s - Times executed: 60 ]
[ Application: psql - Total duration: 4m33s - Times executed: 60 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028515);
Date: 2026-08-14 12:02:30 Duration: 43s343ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028519);
Date: 2026-08-14 13:34:06 Duration: 21s335ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028498);
Date: 2026-08-14 10:27:22 Duration: 21s90ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
20 60 18s345ms 151ms 868ms 305ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 14 09 1 204ms 204ms 10 23 7s23ms 305ms 11 28 8s966ms 320ms 14 7 1s916ms 273ms 16 1 234ms 234ms [ User: intelifix - Total duration: 18s345ms - Times executed: 60 ]
[ Application: [unknown] - Total duration: 18s345ms - Times executed: 60 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (52752);
Date: 2026-08-14 14:00:29 Duration: 868ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (106328);
Date: 2026-08-14 10:45:25 Duration: 487ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (230007);
Date: 2026-08-14 11:35:12 Duration: 451ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m59s 10m10s 6m37s 3 19m51s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 14 05 3 19m51s 6m37s [ User: intelifix - Total duration: 19m51s - Times executed: 3 ]
[ Application: psql - Total duration: 19m51s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-14 05:10:11 Duration: 10m10s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
analyze verbose;
Date: 2026-08-14 05:16:53 Duration: 6m41s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
analyze verbose;
Date: 2026-08-14 05:19:53 Duration: 2m59s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
2 1s462ms 11m43s 3m8s 47 2h27m23s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 14 07 3 11m27s 3m49s 08 3 9m20s 3m6s 09 3 9m21s 3m7s 10 3 11m10s 3m43s 11 3 11m8s 3m42s 12 3 11m48s 3m56s 13 3 7m15s 2m25s 14 3 12m20s 4m6s 15 3 10m36s 3m32s 16 3 10m40s 3m33s 17 3 7m7s 2m22s 18 3 6m9s 2m3s 19 3 6m10s 2m3s 20 2 9m44s 4m52s 21 3 6m51s 2m17s 22 3 6m11s 2m3s [ User: intelifix - Total duration: 2h27m23s - Times executed: 47 ]
[ Application: psql - Total duration: 2h27m23s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-14 14:16:44 Duration: 11m43s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-14 12:15:54 Duration: 10m53s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-14 07:15:36 Duration: 10m34s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
3 216ms 5m8s 1m43s 48 1h22m49s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 14 07 3 6m34s 2m11s 08 3 4m25s 1m28s 09 3 6m1s 2m 10 3 6m30s 2m10s 11 3 6m22s 2m7s 12 3 6m37s 2m12s 13 3 4m12s 1m24s 14 3 6m18s 2m6s 15 3 5m59s 1m59s 16 3 5m19s 1m46s 17 3 3m57s 1m19s 18 3 3m44s 1m14s 19 3 3m53s 1m17s 20 3 5m12s 1m44s 21 3 3m54s 1m18s 22 3 3m44s 1m14s [ User: intelifix - Total duration: 1h22m49s - Times executed: 48 ]
[ Application: psql - Total duration: 1h22m49s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-14 10:22:32 Duration: 5m8s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-14 12:23:13 Duration: 5m8s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-14 07:22:52 Duration: 5m5s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
4 4s867ms 1m38s 49s82ms 4 3m16s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 14 20 2 1m32s 46s191ms 23 2 1m43s 51s972ms [ User: intelifix - Total duration: 3m16s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m16s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-14 23:17:52 Duration: 1m38s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-14 20:08:39 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-14 23:37:41 Duration: 5s136ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-14.log
5 155ms 35m25s 47s651ms 322 4h15m43s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 14 07 21 22m5s 1m3s 08 36 31m1s 51s707ms 09 50 24m33s 29s471ms 10 35 52m22s 1m29s 11 39 1h7m39s 1m44s 12 11 19m28s 1m46s 13 40 35s65ms 876ms 14 23 14m59s 39s113ms 15 48 21m51s 27s331ms 16 12 58s21ms 4s835ms 17 7 7s912ms 1s130ms [ User: intelifix - Total duration: 4h15m43s - Times executed: 322 ]
[ Application: [unknown] - Total duration: 4h15m43s - Times executed: 322 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT LEGADO "SAP (LEGADO)", COALESCE((RS_FAST_BARRAS(EQ_ID)).NS, (RS_FAST_BARRAS(EQ_ID)).BARRA1 )"SERIAL",END_PRINCIPAL "ENDEREÇÁVEL PRINCIPAL", ACESSORIO2 "SMART", SITUACAO "STATUS" FROM POSICAO_ESTOQUE WHERE ( NOT TCN_ID IN (38,39,37)) AND SIT_ID IN (1,2,3,5,6) ;' , '/var/www/html/tmp/Status-Oficina_80.xlsx');
Date: 2026-08-14 11:10:41 Duration: 35m25s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM POSICAO_ESTOQUE WHERE GRU_ID = 2 AND OFI_ID = 6;', '/var/www/html/tmp/posicao_oficina_80.xlsx');
Date: 2026-08-14 10:29:16 Duration: 15m41s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM POSICAO_ESTOQUE WHERE GRU_ID = 2 AND OFI_ID = 6;', '/var/www/html/tmp/posicao_oficina_80.xlsx');
Date: 2026-08-14 10:48:55 Duration: 14m40s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
6 10s897ms 47s320ms 16s100ms 30 8m3s create table temp0000288373 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 14 06 1 47s320ms 47s320ms 07 1 10s996ms 10s996ms 10 7 1m57s 16s731ms 11 13 3m28s 16s46ms 12 3 36s964ms 12s321ms 14 1 13s417ms 13s417ms 15 4 48s575ms 12s143ms [ User: intelifix - Total duration: 8m3s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 8m3s - Times executed: 30 ]
-
CREATE TABLE temp0000288373 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 06:58:38 Duration: 47s320ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288373 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 11:05:57 Duration: 31s173ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288373 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 11:00:28 Duration: 26s598ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
7 10s665ms 47s713ms 14s167ms 45 10m37s create table temp0000288469 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 14 09 12 2m33s 12s756ms 10 6 1m56s 19s486ms 12 3 38s6ms 12s668ms 14 15 3m32s 14s167ms 15 9 1m57s 13s1ms [ User: intelifix - Total duration: 10m37s - Times executed: 45 ]
[ Application: [unknown] - Total duration: 10m37s - Times executed: 45 ]
-
CREATE TABLE temp0000288469 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 10:25:35 Duration: 47s713ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288469 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 14:14:15 Duration: 16s554ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288469 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 14:42:43 Duration: 15s633ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
8 10s406ms 16s201ms 12s663ms 50 10m33s create table temp0000288387 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 14 07 18 3m42s 12s357ms 08 6 1m10s 11s760ms 09 11 2m18s 12s609ms 10 5 1m9s 13s996ms 11 2 30s357ms 15s178ms 12 3 36s233ms 12s77ms 14 2 26s768ms 13s384ms 15 3 38s118ms 12s706ms [ User: intelifix - Total duration: 10m33s - Times executed: 50 ]
[ Application: [unknown] - Total duration: 10m33s - Times executed: 50 ]
-
CREATE TABLE temp0000288387 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 10:32:46 Duration: 16s201ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288387 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 11:54:30 Duration: 16s132ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288387 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 07:27:15 Duration: 15s464ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
9 11s183ms 14s660ms 12s589ms 32 6m42s create table temp0000288421 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 14 07 12 2m33s 12s764ms 08 14 2m55s 12s516ms 09 6 1m14s 12s408ms [ User: intelifix - Total duration: 6m42s - Times executed: 32 ]
[ Application: [unknown] - Total duration: 6m42s - Times executed: 32 ]
-
CREATE TABLE temp0000288421 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 07:42:48 Duration: 14s660ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288421 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 07:43:21 Duration: 14s342ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288421 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 08:01:13 Duration: 14s1ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
10 10s861ms 15s205ms 12s569ms 18 3m46s create table temp0000288534 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 14 15 18 3m46s 12s569ms [ User: intelifix - Total duration: 3m46s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 3m46s - Times executed: 18 ]
-
CREATE TABLE temp0000288534 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 15:28:41 Duration: 15s205ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288534 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 15:06:26 Duration: 14s10ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288534 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 15:25:54 Duration: 13s802ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
11 10s722ms 13s994ms 12s250ms 19 3m52s create table temp0000288427 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 14 09 19 3m52s 12s250ms [ User: intelifix - Total duration: 3m52s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 3m52s - Times executed: 19 ]
-
CREATE TABLE temp0000288427 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 09:50:01 Duration: 13s994ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288427 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 09:49:40 Duration: 13s989ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CREATE TABLE temp0000288427 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-14 09:07:40 Duration: 13s402ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
12 1s776ms 42s309ms 11s516ms 77 14m46s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 14 07 3 25s938ms 8s646ms 08 3 54s586ms 18s195ms 09 8 1m12s 9s123ms 10 10 2m28s 14s884ms 11 9 2m16s 15s167ms 12 3 11s947ms 3s982ms 13 7 1m14s 10s629ms 14 11 1m59s 10s891ms 15 9 2m11s 14s609ms 16 6 1m26s 14s381ms 17 8 23s960ms 2s995ms [ User: intelifix - Total duration: 14m46s - Times executed: 77 ]
[ Application: [unknown] - Total duration: 14m46s - Times executed: 77 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-14', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-14 11:33:25 Duration: 42s309ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-14', 0175, '', '', 0, 6, '2026-08-01');
Date: 2026-08-14 11:10:14 Duration: 40s569ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-14', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-14 09:25:17 Duration: 35s502ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
13 171ms 43s343ms 4s555ms 60 4m33s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 14 07 5 34s162ms 6s832ms 08 7 11s294ms 1s613ms 09 12 38s703ms 3s225ms 10 5 33s680ms 6s736ms 11 9 11s504ms 1s278ms 12 3 46s65ms 15s355ms 13 4 33s474ms 8s368ms 14 4 22s674ms 5s668ms 15 11 41s767ms 3s797ms [ User: intelifix - Total duration: 4m33s - Times executed: 60 ]
[ Application: psql - Total duration: 4m33s - Times executed: 60 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028515);
Date: 2026-08-14 12:02:30 Duration: 43s343ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028519);
Date: 2026-08-14 13:34:06 Duration: 21s335ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028498);
Date: 2026-08-14 10:27:22 Duration: 21s90ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
14 156ms 17s475ms 3s890ms 152 9m51s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 14 00 6 28s156ms 4s692ms 01 5 12s504ms 2s500ms 02 6 13s143ms 2s190ms 03 4 12s859ms 3s214ms 04 6 12s234ms 2s39ms 05 4 10s565ms 2s641ms 07 11 47s892ms 4s353ms 08 12 57s470ms 4s789ms 09 12 1m 5s21ms 10 12 1m 5s45ms 11 12 1m6s 5s545ms 12 12 59s157ms 4s929ms 13 7 10s184ms 1s454ms 14 12 53s745ms 4s478ms 15 10 40s690ms 4s69ms 16 6 9s918ms 1s653ms 17 3 3s880ms 1s293ms 20 1 347ms 347ms 21 5 15s410ms 3s82ms 22 6 15s832ms 2s638ms [ User: intelifix - Total duration: 9m51s - Times executed: 152 ]
[ Application: psql - Total duration: 9m51s - Times executed: 152 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-14 00:05:19 Duration: 17s475ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-14 08:25:13 Duration: 12s243ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-14 14:45:12 Duration: 11s410ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
15 214ms 2m34s 3s677ms 274 16m47s call rs_giga_triagem (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 14 00 12 41s728ms 3s477ms 01 12 30s46ms 2s503ms 02 12 29s153ms 2s429ms 03 12 30s621ms 2s551ms 04 12 28s768ms 2s397ms 05 12 28s648ms 2s387ms 06 12 31s24ms 2s585ms 07 12 35s172ms 2s931ms 08 12 2m59s 14s985ms 09 12 53s607ms 4s467ms 10 12 1m23s 6s996ms 11 11 48s323ms 4s393ms 12 12 36s711ms 3s59ms 13 12 35s108ms 2s925ms 14 12 41s461ms 3s455ms 15 11 39s674ms 3s606ms 16 12 35s625ms 2s968ms 17 12 31s795ms 2s649ms 18 12 32s577ms 2s714ms 19 12 30s506ms 2s542ms 20 12 39s980ms 3s331ms 21 12 32s161ms 2s680ms 22 12 31s233ms 2s602ms [ User: intelifix - Total duration: 16m47s - Times executed: 274 ]
[ Application: psql - Total duration: 16m47s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-14 08:27:47 Duration: 2m34s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-14 10:35:46 Duration: 34s318ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-14 09:35:31 Duration: 18s622ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
16 2s805ms 4s242ms 3s356ms 56 3m7s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 14 08 4 13s731ms 3s432ms 09 2 7s771ms 3s885ms 10 3 9s798ms 3s266ms 11 5 16s244ms 3s248ms 12 3 10s20ms 3s340ms 13 5 17s66ms 3s413ms 14 4 15s71ms 3s767ms 15 4 12s829ms 3s207ms 16 5 15s939ms 3s187ms 17 3 10s202ms 3s400ms 18 4 12s22ms 3s5ms 19 4 14s309ms 3s577ms 20 4 14s44ms 3s511ms 21 3 9s273ms 3s91ms 22 3 9s646ms 3s215ms [ User: intelifix - Total duration: 3m7s - Times executed: 56 ]
[ Application: psql - Total duration: 3m7s - Times executed: 56 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-14 09:00:09 Duration: 4s242ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-14 14:00:05 Duration: 4s176ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-14 14:00:09 Duration: 4s129ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
17 175ms 33s871ms 1s820ms 83 2m31s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 14 07 9 14s773ms 1s641ms 08 7 4s540ms 648ms 09 22 9s280ms 421ms 10 7 16s371ms 2s338ms 11 11 1m24s 7s642ms 12 4 5s111ms 1s277ms 13 6 1s647ms 274ms 14 6 6s279ms 1s46ms 15 11 9s39ms 821ms [ User: intelifix - Total duration: 2m31s - Times executed: 83 ]
[ Application: psql - Total duration: 2m31s - Times executed: 83 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028508);
Date: 2026-08-14 11:20:49 Duration: 33s871ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028505);
Date: 2026-08-14 11:05:42 Duration: 16s490ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028460);
Date: 2026-08-14 07:19:42 Duration: 8s487ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-14.log
18 150ms 5m32s 1s149ms 1,542 29m31s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 14 07 105 1m48s 1s33ms 08 157 2m33s 980ms 09 200 8m31s 2s559ms 10 255 4m13s 992ms 11 245 3m49s 935ms 12 61 58s186ms 953ms 13 90 1m19s 887ms 14 232 3m3s 790ms 15 154 2m11s 854ms 16 21 32s124ms 1s529ms 17 22 30s168ms 1s371ms [ User: intelifix - Total duration: 29m31s - Times executed: 1542 ]
[ Application: [unknown] - Total duration: 29m31s - Times executed: 1542 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277973, 507, '2102312JCYRYL4003045,8CE5EFC0456B,4857544317F96CA2JCYRYL4005107,8CE5EFC04B10,4857544317F9C1A2JCYRYK9004402,1C20DB824E69,4857544374F52C9FJCYRYL2011436,30E98E83D109,485754432150B9A1RGBRYJA044661,F87588084DC0,485754439668D99DJCYRYK9013929,D0C65B28D670,485754438C10A69FJCYRYK9014137,D0C65B28C3A5,485754438C0F8B9FJCYRYK1007401,2841C6886E17,485754434192179EJCYRYK9011744,18CF24AAD93C,485754438470109FJCYRYKB006890,CC0577B61353,48575443E4EE2E9F', '', 0147, 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":""}]', '$$$$$$$$$', '8CE5EFC0456E||8CE5EFC04B13||1C20DB824E6C||30E98E83D10C ||F87588084DC3||D0C65B28D673||D0C65B28C3A8||2841C6886E1A||18CF24AAD93F||CC0577B61356', 00);
Date: 2026-08-14 09:21:42 Duration: 5m32s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277785, 452, '2102312JCYRYK5000104,04FE8DA7B2B8,48575443DB777E9EJCYRYK9013451,D0C65B276E69,485754438C07B89FJCYRYL2001795,AC8D34A05F50,48575443157E97A1JCYRYK5000075,04FE8DA7B32F,48575443DB77859EJCYRYKB002784,CC0577BE25B0,48575443E4F6779FJCYRYK9014374,D0C65B272C45,485754438C03D49FJCYRYK1005531,2841C688CD62,485754434197B29EJCYRYKA001431,D0C65BF2BC43,4857544394FE0D9FRGBRYJA050056,14A0F826C4FA,4857544396B3069DJCYRYK9017592,D0C65B274EEF,485754438C05DE9FJCYRYK9014987,D0C65B294C2D,485754438C17939FRGBRYJA044108,14A0F82A442F,4857544396ECFC9DJCYRYK9013564,D0C65B26A7EC,485754438BFC0B9FJCYRYK9907850,D0C65B2FCD84,485754438C57519F', '',0147,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-14 13:52:38 Duration: 9s902ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277965, 507, '2102311RGB6RHC001983,E86819BFF627,485754437857AF9BRGBRYJ9009022,AC751D14ACBD,4857544376ECCF9DRGB6RJ9025148,4857021511E7,4857544382A6E29DJCY6RL4009736,8CE5EFD26133,4857544318C533A2RGBRYJ9004528,AC751D13A6F2,4857544376DDEF9DRGBRYJA030757,4857028A094A,485754438D48479D', '', 0126, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""}]', '$$$$$$$$$', 'E86819BFF629||AC751D14ACBF||4857021511EA||8CE5EFD26136||AC751D13A6F5||4857028A094D||||||||', 00);
Date: 2026-08-14 08:55:50 Duration: 7s159ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
19 158ms 14s988ms 866ms 130 1m52s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 14 07 9 9s77ms 1s8ms 08 19 31s783ms 1s672ms 09 15 5s77ms 338ms 10 8 5s76ms 634ms 11 11 7s652ms 695ms 12 1 264ms 264ms 13 32 26s850ms 839ms 14 4 8s815ms 2s203ms 15 23 13s174ms 572ms 16 8 4s844ms 605ms [ User: intelifix - Total duration: 1m52s - Times executed: 130 ]
[ Application: [unknown] - Total duration: 1m52s - Times executed: 130 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052715) LIMIT 1;
Date: 2026-08-14 08:36:55 Duration: 14s988ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052715) LIMIT 1;
Date: 2026-08-14 08:37:09 Duration: 6s632ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0277948) LIMIT 1;
Date: 2026-08-14 13:46:44 Duration: 4s516ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
20 150ms 6s818ms 582ms 950 9m13s select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 14 06 5 6s714ms 1s342ms 07 77 42s805ms 555ms 08 103 53s6ms 514ms 09 147 1m24s 576ms 10 138 1m29s 648ms 11 108 1m26s 797ms 12 24 17s327ms 721ms 13 68 40s279ms 592ms 14 114 58s810ms 515ms 15 130 58s839ms 452ms 16 33 13s762ms 417ms 17 3 1s530ms 510ms [ User: intelifix - Total duration: 9m13s - Times executed: 950 ]
[ Application: [unknown] - Total duration: 9m13s - Times executed: 950 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "230007", "modelo" : "320", "itens" : "241701742730,241694955266,241654845358,241699259198,241593254454,230049304250,241695625264,241674513552,241695118693,241654561717,241661060915,241607167899,241714693141,241610896871,241622637074,241617367985,241713020307,241614465267,241708964355,241704364456,241622631014,241670390928,241622440008,241652290306,241704161227,241620778183,241610084357,241663175868,241622485466,241657626168,241714943850,241622543856,241656698086,241629127483,241680303556,241646268910,241726632836,241678325865,241689391626,241658760006,241658797685,241694493852,241615859107,241666320306,241660090910", "usuario" : "414", "caixa" : "2756724", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-14 11:36:24 Duration: 6s818ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "106328", "modelo" : "160", "itens" : "229851695357,229847315053,229841176878,229848362541,229843468190,229856378901,229853099501,229763092547,229862140014,229842651636,229841895265,229845932427,229763132932,229846870813,229852617175,229843477787,229853732829,229842851229,229852635460,229838524869,229851994354,229841831219,229853701940,229842132943,229853773338,229846929101,229851794458,229856975659,229853716688,229853992832,229855941227,229841158492,229843483546,229842291522,229846635256,229853323844", "usuario" : "414", "caixa" : "1240990", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-14 10:47:18 Duration: 3s681ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "207113", "modelo" : "454", "itens" : "241613201721,241623641124,241612462850,241634136973,241612445575,241624883052,241624699902,241623978989,241632773036,241600559903,241643844554,241614383643,241641600924,241624244448,241624416283,241624889517,241624865171,241611405058,241632645167,241627148199,241625129696,241625186268,241625359393,241626681836,241625480619,241642270518,241613690916,241600455067,241624462932,241643750505,241634302344,241613943140,241613923138,241624407797,241600335055,241634141621,241634141217,241626567177,241613867071,241613581635,241632404257,241626573744,241634160916,241634139397,241625121010", "usuario" : "414", "caixa" : "2521937", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-14 11:16:44 Duration: 2s983ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 160ms 1 160ms 160ms 160ms select * from rs_caixa_qr ();Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Aug 14 23 1 160ms 160ms [ User: etiquetas - Total duration: 153ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 153ms - Times executed: 1 ]
-
select * from rs_caixa_qr ();
Date: 2026-08-13 23:36:41 Duration: 160ms Database: postgres User: contagem Remote: etiquetas Application: [local] Queryid: [unknown]
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 8 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 13 10 1 0ms 0ms 20 1 0ms 0ms 21 2 0ms 0ms Aug 14 14 1 0ms 0ms 19 1 0ms 0ms 20 2 0ms 0ms [ User: intelifix - Total duration: 7s758ms - Times executed: 8 ]
[ Application: psql - Total duration: 6s933ms - Times executed: 6 ]
[ Application: [unknown] - Total duration: 825ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 23,980 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 23 FATAL entries
- 6110 ERROR entries
- 0 WARNING entries
- 22 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 6,028 Max number of times the same event was reported
- 6,155 Total events found
Rank Times reported Error 1 6,028 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 14 00 178 01 180 02 177 03 164 04 179 05 179 06 187 07 394 08 557 09 559 10 481 11 445 12 284 13 209 14 438 15 396 16 183 17 163 18 118 19 117 20 114 21 115 22 114 23 97 - ERROR: prepared statement "_PLAN0000000029B160F0" does not exist
- ERROR: prepared statement "_PLAN0000000028EF1500" does not exist
- ERROR: prepared statement "_PLAN000000002A4CB8C0" does not exist
Statement: DEALLOCATE "_PLAN0000000029B160F0"
Date: 2026-08-14 00:00:06 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Statement: DEALLOCATE "_PLAN0000000028EF1500"
Date: 2026-08-14 00:00:47 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Statement: DEALLOCATE "_PLAN000000002A4CB8C0"
Date: 2026-08-14 00:00:53 Database: contagem Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
2 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 14 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-14 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-14 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-14 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
3 18 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 14 07 1 08 4 09 7 10 2 11 2 12 2 - LOG: process 3660185 still waiting for ShareLock on transaction 4394950 after 1000.188 ms
- LOG: process 3689638 still waiting for ShareLock on transaction 4398636 after 1000.097 ms
- LOG: process 3689638 still waiting for ShareLock on transaction 4398636 after 18111.019 ms
Detail: Process holding the lock: 3648417. Wait queue: 3660185.
Context: while deleting tuple (14580,66) in relation "codigos_barra" SQL statement "DELETE FROM CODIGOS_BARRA WHERE EQ_ID = cRet.ID" PL/pgSQL function rs_equipamento_manutencao(integer,integer,integer,integer,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 655 at SQL statement SQL statement "SELECT * FROM RS_EQUIPAMENTO_MANUTENCAO( 0,5,34,6,502,'465043426372','','465043426372','216475549292',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 920 at EXECUTE 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( 028463, 0502 )' , '/var/www/html/tmp/nf_carga_lotes_0502.xlsx' )Date: 2026-08-14 07:28:32 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Detail: Process holding the lock: 3665731. Wait queue: 3689638.
Context: while deleting tuple (19321,104) in relation "codigos_barra" SQL statement "DELETE FROM CODIGOS_BARRA WHERE EQ_ID = cRet.ID" PL/pgSQL function rs_equipamento_manutencao(integer,integer,integer,integer,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 655 at SQL statement SQL statement "SELECT * FROM RS_EQUIPAMENTO_MANUTENCAO( 0,5,34,6,507,'465043426372','','465043426372','216475549292',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 920 at EXECUTE 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( 028469, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-08-14 08:02:55 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Detail: Process holding the lock: 3665731. Wait queue: 3689638.
Context: while deleting tuple (19321,104) in relation "codigos_barra" SQL statement "DELETE FROM CODIGOS_BARRA WHERE EQ_ID = cRet.ID" PL/pgSQL function rs_equipamento_manutencao(integer,integer,integer,integer,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 655 at SQL statement SQL statement "SELECT * FROM RS_EQUIPAMENTO_MANUTENCAO( 0,5,34,6,507,'465043426372','','465043426372','216475549292',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 920 at EXECUTE 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( 028469, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-08-14 08:03:12 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
4 18 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 14 09 9 10 3 12 3 14 3 - ERROR: trailing junk after numeric literal at or near "8C444F6055E0" at character 27
- ERROR: trailing junk after numeric literal at or near "8C444F6055E0" at character 27
- ERROR: trailing junk after numeric literal at or near "8C444F6055E0" at character 27
Statement: SELECT * FROM RS_ETIQUETA(8C444F6055E0)
Date: 2026-08-14 09:20:46 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Statement: SELECT * FROM RS_ETIQUETA(8C444F6055E0)
Date: 2026-08-14 09:20:47 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Statement: SELECT * FROM RS_ETIQUETA(8C444F6055E0)
Date: 2026-08-14 09:20:47 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
5 13 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 14 03 13 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-08-14 03:05:01 Database: contagem Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Context: PL/pgSQL expression "bAtualiza" PL/pgSQL function rs_giga_triagem(character varying,integer) line 100 at IF SQL statement "CALL RS_GIGA_TRIAGEM( cNome, nAux )" PL/pgSQL function rs_giga_processa_arquivos() line 63 at CALL
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-08-14 03:05:01 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Date: 2026-08-14 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
6 6 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 14 00 1 04 1 06 1 08 1 10 1 19 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-08-14 00:02:14 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Date: 2026-08-14 04:01:06 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Date: 2026-08-14 06:02:14 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
7 6 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 14 08 6 - ERROR: syntax error at or near ""},{"" at character 81
- ERROR: syntax error at or near ""},{"" at character 81
- ERROR: syntax error at or near "","" at character 47
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"277923","seriais":[{"serial":"'"},{"serial":"6802B8DB425C"}]}')
Date: 2026-08-14 08:24:46 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"277923","seriais":[{"serial":"'"},{"serial":""}]}')
Date: 2026-08-14 08:24:51 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Statement: SELECT * FROM RS_PRE_ALERTA_TELA('{"barra1":"'","barra2":"","barra3":"721243035351","lote":"277923"}');
Date: 2026-08-14 08:24:51 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
8 5 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 14 09 2 10 2 14 1 - ERROR: column "v" does not exist at character 27
- ERROR: column "v" does not exist at character 27
- ERROR: column "v" does not exist at character 27
Statement: select * from rs_caixa_qr(V)
Date: 2026-08-14 09:01:23 Database: contagem Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Statement: select * from rs_caixa_qr(V)
Date: 2026-08-14 09:01:23 Database: contagem Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Statement: select * from rs_caixa_qr(V)
Date: 2026-08-14 10:15:39 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
9 5 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Aug 14 05 4 11 1 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-14 05:32:13 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-14 05:32:13 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-14 05:32:13 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
10 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #10
Day Hour Count Aug 14 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-14 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Date: 2026-08-14 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
Date: 2026-08-14 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
11 1 LOG: skipping analyze of "..." --- lock not available
Times Reported Most Frequent Error / Event #11
Day Hour Count Aug 14 13 1 - LOG: skipping analyze of "temp0000288516" --- lock not available
Date: 2026-08-14 13:35:45 Log file: /usr/local/pgsql/data/log/serverlog-14.log
12 1 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #12
Day Hour Count Aug 14 11 1 - ERROR: unterminated quoted string at or near "'241758875163'');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('241758875163'');
Date: 2026-08-14 11:06:06 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
13 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #13
Day Hour Count Aug 14 03 1 - LOG: database system was shut down at 2026-08-14 03:05:01 -03
Date: 2026-08-14 03:05:02 Log file: /usr/local/pgsql/data/log/serverlog-14.log
14 1 LOG: could not send data to client: Broken pipe
Times Reported Most Frequent Error / Event #14
Day Hour Count Aug 14 11 1 - LOG: could not send data to client: Broken pipe
Date: 2026-08-14 11:10:41 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
15 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #15
Day Hour Count Aug 14 13 1 - LOG: process 4012944 still waiting for AccessExclusiveLock on relation 3854612 of database 358220 after 1000.263 ms
Detail: Process holding the lock: 4020215. Wait queue: 4012944.
Statement: DROP TABLE IF EXISTS temp0000288508;Date: 2026-08-14 13:43:46 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
16 1 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #16
Day Hour Count Aug 14 11 1 - FATAL: connection to client lost
Date: 2026-08-14 11:10:41 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-14.log
17 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #17
Day Hour Count Aug 14 13 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000288508"
Date: 2026-08-14 13:43:46 Log file: /usr/local/pgsql/data/log/serverlog-14.log