pgBadger-
Global information
- Generated on Wed Jul 8 23:50:11 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 43,665 log entries in 10s
- Log start from 2026-07-07 00:00:06 to 2026-07-07 23:59:28
-
Overview
Global Stats
- 361 Number of unique normalized queries
- 5,893 Number of queries
- 7h37m Total query duration
- 2026-07-07 00:00:28 First query
- 2026-07-07 23:49:55 Last query
- 5 queries/s at 2026-07-07 16:35:12 Query peak
- 7h37m Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h37m Execute total duration
- 4,441 Number of events
- 14 Number of unique normalized events
- 4,296 Max number of times the same event was reported
- 0 Number of cancellation
- 417 Total number of automatic vacuums
- 1,009 Total number of automatic analyzes
- 11 Number temporary file
- 233.60 MiB Max size of temporary file
- 108.19 MiB Average size of temporary file
- 375 Total number of sessions
- 8 sessions at 2026-07-07 16:27:51 Session peak
- 13d16h35m22s Total duration of sessions
- 52m34s Average duration of sessions
- 15 Average queries per session
- 1m13s Average queries duration per session
- 51m21s Average idle time per session
- 379 Total number of connections
- 7 connections/s at 2026-07-07 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-07 16:35:12 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-07 09:51:41 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2026-07-07 23:38:52 Date
Queries duration
Key values
- 7h37m Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 07 00 22 0ms 19s241ms 4s838ms 3s345ms 5s629ms 1m18s 01 24 0ms 3s716ms 1s289ms 3s636ms 4s764ms 5s936ms 02 13 0ms 4s279ms 2s57ms 3s575ms 4s366ms 5s470ms 03 18 0ms 4s404ms 1s652ms 3s752ms 4s678ms 7s138ms 04 17 0ms 3s442ms 1s666ms 3s162ms 4s884ms 5s806ms 05 36 0ms 8m10s 28s558ms 7s95ms 2m16s 8m11s 06 24 0ms 40s130ms 4s602ms 4s574ms 5s508ms 53s643ms 07 192 0ms 7m45s 10s903ms 52s482ms 5m20s 7m51s 08 596 150ms 6m40s 3s967ms 56s902ms 4m49s 6m42s 09 692 150ms 7m50s 2s747ms 44s156ms 3m49s 8m7s 10 453 0ms 7m23s 4s359ms 1m5s 4m14s 7m25s 11 534 0ms 7m58s 3s496ms 52s317ms 4m2s 8m2s 12 204 0ms 7m26s 4s786ms 17s304ms 54s385ms 7m30s 13 337 0ms 6m4s 2s874ms 21s759ms 36s907ms 6m52s 14 602 150ms 7m8s 3s786ms 1m8s 5m4s 7m12s 15 782 150ms 8m22s 2s966ms 56s323ms 4m38s 8m29s 16 611 150ms 7m20s 3s418ms 59s729ms 4m7s 7m24s 17 311 0ms 7m7s 3s924ms 37s511ms 2m21s 7m59s 18 18 0ms 5m51s 35s511ms 4s331ms 47s455ms 5m51s 19 15 0ms 5m26s 39s544ms 4s779ms 14s836ms 5m57s 20 105 0ms 6m23s 11s202ms 56s278ms 2m3s 6m23s 21 24 0ms 5m33s 25s78ms 5s308ms 43s651ms 5m33s 22 24 0ms 5m31s 25s400ms 6s13ms 44s642ms 5m31s 23 239 0ms 1m41s 9s973ms 1m12s 1m39s 2m13s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 07 00 5 0 1s239ms 0ms 0ms 345ms 01 9 0 282ms 0ms 158ms 254ms 02 0 0 0ms 0ms 0ms 0ms 03 3 0 342ms 0ms 0ms 169ms 04 5 0 261ms 0ms 0ms 191ms 05 21 0 271ms 152ms 286ms 1s248ms 06 9 0 871ms 0ms 0ms 2s142ms 07 108 0 15s678ms 3s66ms 52s482ms 5m20s 08 448 0 4s145ms 12s539ms 56s902ms 4m48s 09 568 0 2s709ms 11s623ms 23s755ms 5m31s 10 351 0 4s628ms 9s597ms 1m1s 5m3s 11 424 0 3s533ms 11s79ms 35s137ms 4m51s 12 150 0 5s915ms 5s259ms 17s29ms 3m40s 13 249 0 3s292ms 5s734ms 10s755ms 3m23s 14 478 0 4s8ms 15s557ms 1m7s 5m32s 15 577 0 2s900ms 12s119ms 26s190ms 5m33s 16 456 0 3s903ms 16s359ms 45s49ms 5m58s 17 207 0 5s324ms 6s576ms 14s714ms 3m54s 18 7 0 1m27s 0ms 0ms 3m29s 19 6 0 1m33s 0ms 0ms 3m11s 20 10 84 12s131ms 385ms 56s278ms 3m23s 21 11 0 51s609ms 0ms 213ms 3m9s 22 8 0 1m11s 0ms 0ms 3m14s 23 10 229 9s973ms 1m3s 1m12s 1m41s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 07 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 07 00 0 1 1.00 0.00% 01 0 1 1.00 0.00% 02 0 0 0.00 0.00% 03 0 2 2.00 0.00% 04 0 1 1.00 0.00% 05 0 3 3.00 0.00% 06 0 3 3.00 0.00% 07 0 10 10.00 0.00% 08 0 16 16.00 0.00% 09 0 12 12.00 0.00% 10 0 15 15.00 0.00% 11 0 15 15.00 0.00% 12 0 12 12.00 0.00% 13 0 11 11.00 0.00% 14 0 10 10.00 0.00% 15 0 15 15.00 0.00% 16 0 12 12.00 0.00% 17 0 6 6.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 1 1.00 0.00% 22 0 1 1.00 0.00% 23 0 2 2.00 0.00% Day Hour Count Average / Second Jul 07 00 17 0.00/s 01 11 0.00/s 02 9 0.00/s 03 20 0.01/s 04 9 0.00/s 05 10 0.00/s 06 16 0.00/s 07 14 0.00/s 08 23 0.01/s 09 24 0.01/s 10 20 0.01/s 11 20 0.01/s 12 16 0.00/s 13 21 0.01/s 14 20 0.01/s 15 22 0.01/s 16 32 0.01/s 17 15 0.00/s 18 9 0.00/s 19 10 0.00/s 20 12 0.00/s 21 12 0.00/s 22 11 0.00/s 23 6 0.00/s Day Hour Count Average Duration Average idle time Jul 07 00 4 1h 59m33s 01 16 1h1m5s 1h1m3s 02 11 1h33s 1h30s 03 20 25m15s 25m14s 04 9 1h2m40s 1h2m37s 05 9 54m47s 52m52s 06 9 58m40s 58m28s 07 16 57m43s 55m33s 08 15 53m34s 50m57s 09 24 52m 50m41s 10 22 55m27s 53m57s 11 21 55m39s 54m10s 12 20 55m6s 54m17s 13 17 51m22s 50m25s 14 21 52m20s 50m31s 15 18 56m21s 54m12s 16 34 38m45s 37m44s 17 21 56m30s 55m32s 18 12 1h26s 59m32s 19 9 1h56s 59m50s 20 13 47m36s 46m5s 21 9 1h37s 59m30s 22 12 58m11s 57m20s 23 13 49m47s 46m44s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-07-07 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 379 connections Total
Connections per user
Key values
- intelifix Main User
- 379 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-07-07 16:27:51 Date
Histogram of session times
Key values
- 300 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 375 sessions Total
Sessions per user
Key values
- intelifix Main User
- 375 sessions Total
Sessions per host
Key values
- [local] Main Host
- 375 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 375 sessions Total
Application Count Total Duration Average Duration [unknown] 346 13d2h39m32s 54m33s pgAdmin 4 - CONN:4183051 2 13s346ms 6s673ms pgAdmin 4 - CONN:566028 2 21s284ms 10s642ms pgAdmin 4 - CONN:6997493 2 30s578ms 15s289ms pgAdmin 4 - DB:brasilia 1 25s722ms 25s722ms pgAdmin 4 - DB:contagem 1 19s245ms 19s245ms pgAdmin 4 - DB:postgres 1 1m38s 1m38s pgAdmin 4 - DB:rio 1 36s549ms 36s549ms pg_dump 6 49m44s 8m17s postgres_fdw 1 45m3s 45m3s psql 12 12h16m56s 1h1m24s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 24,528 buffers Checkpoint Peak
- 2026-07-07 08:19:36 Date
- 270.014 seconds Highest write time
- 0.120 seconds Sync time
Checkpoints Wal files
Key values
- 17 files Wal files usage Peak
- 2026-07-07 09:04:36 Date
Checkpoints distance
Key values
- 538.69 Mo Distance Peak
- 2026-07-07 09:04:36 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 07 00 17,370 613.608s 0.025s 613.68s 01 2,618 263.079s 0.042s 263.191s 02 1,479 148.826s 0.03s 148.899s 03 1,659 166.763s 0.028s 166.869s 04 2,026 203.504s 0.027s 203.582s 05 10,123 943.606s 0.115s 943.788s 06 6,130 460.192s 0.017s 460.247s 07 31,123 2,413.802s 0.213s 2,414.153s 08 82,200 3,191.83s 0.68s 3,192.747s 09 95,314 3,238.656s 0.647s 3,239.575s 10 80,124 3,199.837s 0.496s 3,200.556s 11 79,477 3,238.08s 0.527s 3,238.833s 12 25,206 2,070.851s 0.241s 2,071.21s 13 28,094 2,007.698s 0.329s 2,008.159s 14 69,951 3,225.918s 0.564s 3,226.722s 15 62,949 3,238.635s 0.765s 3,239.665s 16 84,771 3,238.729s 0.638s 3,239.604s 17 31,903 2,229.83s 0.298s 2,230.26s 18 2,488 249.541s 0.025s 249.608s 19 30 3.037s 0.003s 3.047s 20 1,539 327.715s 0.024s 327.759s 21 2,139 215.12s 0.03s 215.23s 22 1,991 199.888s 0.035s 199.977s 23 2,251 551.346s 0.019s 551.398s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 07 00 0 0 6 352 0.003s 0.005s 01 0 0 1 535 0.003s 0.01s 02 0 0 0 389 0.003s 0.006s 03 0 0 1 411 0.002s 0.009s 04 0 0 0 421 0.003s 0.008s 05 0 0 4 901 0.016s 0.009s 06 0 0 1 224 0.002s 0.004s 07 0 0 25 2,633 0.003s 0.012s 08 0 0 38 6,221 0.012s 0.012s 09 0 0 53 7,285 0.015s 0.012s 10 0 0 47 5,941 0.004s 0.012s 11 0 0 45 6,031 0.006s 0.012s 12 0 0 10 3,859 0.006s 0.012s 13 0 0 13 4,506 0.004s 0.012s 14 0 0 37 6,776 0.004s 0.012s 15 0 0 48 7,290 0.011s 0.012s 16 0 0 39 6,703 0.015s 0.012s 17 0 0 14 3,908 0.004s 0.011s 18 0 0 1 324 0.003s 0.009s 19 0 0 0 12 0.001s 0.001s 20 0 0 2 96 0.004s 0.003s 21 0 0 0 354 0.003s 0.01s 22 0 0 1 412 0.003s 0.009s 23 0 0 2 27 0.005s 0.005s Day Hour Count Avg time (sec) Jul 07 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jul 07 00 19,395.80 kB 47,067.40 kB 01 1,366.90 kB 25,722.00 kB 02 1,326.00 kB 11,469.50 kB 03 965.00 kB 3,182.67 kB 04 1,365.38 kB 2,135.62 kB 05 7,295.33 kB 15,910.11 kB 06 4,491.00 kB 11,654.00 kB 07 33,581.75 kB 64,802.83 kB 08 51,757.17 kB 93,216.00 kB 09 73,232.83 kB 186,191.25 kB 10 63,521.25 kB 108,463.83 kB 11 61,865.67 kB 106,729.25 kB 12 13,846.50 kB 58,871.50 kB 13 16,764.75 kB 33,431.08 kB 14 50,728.92 kB 85,715.25 kB 15 66,319.33 kB 101,076.42 kB 16 52,965.92 kB 113,187.08 kB 17 20,571.36 kB 66,988.18 kB 18 1,453.00 kB 34,427.71 kB 19 194.00 kB 22,292.00 kB 20 10,724.67 kB 25,669.67 kB 21 1,336.50 kB 15,319.25 kB 22 1,389.50 kB 7,374.38 kB 23 7,976.50 kB 17,156.00 kB -
Temporary Files
Size of temporary files
Key values
- 467.20 MiB Temp Files size Peak
- 2026-07-07 05:32:01 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-07 05:32:01 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 07 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.06 GiB 108.61 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 1 104.00 MiB 104.00 MiB 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 907.46 MiB 69.68 MiB 233.60 MiB 113.43 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-07 05:32:10 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-07 05:32:01 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 178.64 MiB 89.32 MiB 89.32 MiB 89.32 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-07 05:30:41 Duration: 38s955ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-07 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 1 104.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026751, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-07 16:33:59 Duration: 5m41s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026747, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-07 15:56:52 Duration: 5m28s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026732, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-07 14:39:29 Duration: 5m27s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
Queries generating the largest temporary files
Rank Size Query 1 233.60 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-07 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 233.60 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-07 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-07 17:29:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 89.32 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-07 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 89.32 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-07 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 77.10 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-07 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 77.03 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-07 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 77.02 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-07 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 69.75 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-07 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 69.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-07 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 69.68 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-07 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 7.29 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-07 08:13:49 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 7.29 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-07 08:13:49 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (120) Main table analyzed (database rio)
- 1,009 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 120 rio.pg_catalog.pg_class 64 rio.pg_catalog.pg_type 56 rio.public.temp0000284646 49 brasilia.pg_catalog.pg_attribute 48 rio.public.usuarios 46 rio.public.temp0000284648 43 rio.pg_catalog.pg_index 38 rio.public.temp0000284712 32 rio.pg_catalog.pg_depend 31 brasilia.public.temp0000235440 25 contagem.public.temp0000226520 24 rio.public.temp0000284652 23 brasilia.pg_catalog.pg_class 22 contagem.public.usuarios 20 contagem.public.temp0000226553 20 brasilia.pg_catalog.pg_type 19 rio.public.temp0000284316 17 brasilia.public.temp0000235502 14 brasilia.public.temp0000235520 13 rio.public.temp0000284654 13 contagem.pg_catalog.pg_attribute 13 rio.public.temp0000284636 12 rio.public.temp0000283932 12 rio.public.temp0000284620 11 rio.public.temp0000284640 11 rio.public.temp0000284644 10 rio.public.temp0000284728 10 brasilia.pg_catalog.pg_index 10 brasilia.public.usuarios 9 brasilia.pg_catalog.pg_depend 8 rio.public.temp0000284556 8 rio.public.temp0000284686 7 rio.public.temp0000284682 7 brasilia.public.temp0000235458 6 rio.public.temp0000284662 6 brasilia.public.temp0000235504 6 rio.public.temp0000284704 6 rio.public.temp0000284664 6 rio.public.temp0000284744 5 contagem.pg_catalog.pg_class 5 rio.public.temp0000284244 5 template1.pg_catalog.pg_shdepend 5 rio.public.temp0000281789 5 contagem.pg_catalog.pg_type 4 brasilia.public.temp0000235544 4 rio.public.temp0000284660 4 brasilia.public.temp0000235442 4 rio.public.temp0000284718 3 rio.public.temp0000284548 3 brasilia.public.temp0000235546 3 rio.public.temp0000284674 3 rio.public.temp0000284710 3 rio.public.temp0000284722 3 contagem.pg_catalog.pg_index 2 brasilia.public.temp0000235470 2 contagem.pg_catalog.pg_shdepend 2 brasilia.public.temp0000235494 2 rio.public.tmp_drill_0175 2 rio.public.temp0000284732 2 brasilia.public.temp0000235524 2 contagem.auditor.auditor_2026_07 2 rio.public.temp0000284658 2 rio.public.temp0000284730 2 contagem.pg_catalog.pg_depend 2 rio.auditor.auditor_2026_07 2 rio.pg_catalog.pg_shdepend 2 rio.public.temp0000284670 2 rio.public.temp0000284666 2 brasilia.pg_catalog.pg_shdepend 2 postgres.pg_catalog.pg_shdepend 2 rio.public.temp0000284746 2 brasilia.public.temp0000235518 1 rio.public.temp0000284656 1 brasilia.public.temp0000235480 1 brasilia.public.temp0000235488 1 brasilia.public.temp0000235438 1 brasilia.public.temp0000235484 1 rio.public.temp0000283926 1 rio.public.temp0000284748 1 brasilia.public.temp0000235532 1 brasilia.public.temp0000235460 1 rio.public.temp0000284692 1 rio.public.temp0000284720 1 rio.public.temp0000284684 1 brasilia.public.temp0000235444 1 brasilia.public.temp0000235538 1 brasilia.public.temp0000235512 1 brasilia.public.temp0000235542 1 brasilia.auditor.auditor_2026_07 1 brasilia.public.nf_entrada 1 Total 1,009 Vacuums per table
Key values
- pg_catalog.pg_attribute (48) Main table vacuumed on database rio
- 417 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 48 44 0 0 0 0 0 26,287 6,381 10,408,318 392 9,555 rio.public.temp0000284646 45 0 0 0 0 0 0 52,352 5,063 9,389,989 0 0 rio.public.temp0000284648 43 0 0 0 0 0 0 37,414 3,558 6,603,260 0 0 rio.pg_catalog.pg_class 30 27 0 0 0 0 0 5,828 1,743 2,656,563 67 231 rio.pg_catalog.pg_type 27 24 0 0 0 0 0 2,705 729 1,063,300 91 343 rio.pg_catalog.pg_index 21 19 0 0 0 0 0 990 274 303,557 39 107 contagem.public.usuarios 20 0 0 0 0 0 0 99 84 41,639 0 0 rio.public.temp0000284712 17 0 0 0 0 0 0 9,553 92 578,164 0 0 rio.pg_catalog.pg_depend 16 15 0 0 0 0 0 5,517 1,954 2,996,164 119 1,083 brasilia.pg_catalog.pg_attribute 14 14 0 0 0 0 0 6,765 2,100 3,139,420 99 2,717 rio.public.temp0000283932 12 0 0 0 0 0 0 1,020 283 444,304 0 0 rio.pg_catalog.pg_statistic 8 8 0 0 0 0 0 10,087 2,348 10,215,968 1,096 4,012 rio.public.temp0000284556 8 0 0 0 0 0 0 559 141 204,565 0 0 rio.public.temp0000284682 7 0 0 0 0 0 0 8,175 26 486,416 0 0 brasilia.pg_catalog.pg_class 7 7 0 0 0 0 0 1,163 417 664,800 32 104 rio.public.usuarios 7 4 0 0 0 0 0 119 36 86,944 4 6 postgres.pg_catalog.pg_shdepend 7 7 0 0 0 0 0 1,018 309 579,056 46 67 rio.public.temp0000284664 6 0 0 0 0 0 0 524 35 36,435 0 0 brasilia.pg_catalog.pg_type 5 5 0 0 0 0 0 367 137 198,076 24 90 contagem.pg_catalog.pg_attribute 4 4 0 0 0 0 0 2,108 754 1,220,022 6 176 brasilia.pg_catalog.pg_statistic 4 4 0 0 0 0 0 4,547 729 2,812,882 404 2,541 rio.public.temp0000284244 4 0 0 0 0 0 0 248 103 158,332 0 0 brasilia.pg_catalog.pg_index 4 4 0 0 0 0 0 225 70 54,369 17 32 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,880 398 2,094,503 135 435 rio.public.temp0000281789 4 0 0 0 0 0 0 352 24 24,357 0 0 brasilia.pg_catalog.pg_depend 3 3 0 0 0 0 0 876 332 551,375 43 2,811 rio.public.temp0000284718 2 0 0 0 0 0 0 1,739 1,643 2,197,501 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 364 79 316,774 33 79 rio.public.temp0000284658 2 0 0 0 0 0 0 1,718 10 102,872 0 0 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,590 131 579,677 96 906 rio.auditor.auditor_2026_07 2 0 0 0 0 0 0 93,552 45,504 61,310,477 23,285 524,876 brasilia.public.temp0000235494 2 0 0 0 0 0 0 478 12 30,476 0 0 rio.public.tmp_drill_0175 2 2 0 0 0 0 0 68 6 16,320 0 0 rio.public.temp0000284666 2 0 0 0 0 0 0 111 11 8,322 0 0 rio.public.temp0000284620 2 0 0 0 0 0 0 214 12 14,487 0 0 rio.public.temp0000284548 2 0 0 0 0 0 0 90 9 6,761 0 0 contagem.pg_catalog.pg_index 1 1 0 0 0 0 0 71 28 20,443 0 0 contagem.pg_catalog.pg_class 1 1 0 0 0 0 0 188 72 83,014 2 6 contagem.auditor.auditor_2026_07 1 0 0 0 0 0 0 8,710 6,804 7,953,104 907 14,918 rio.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 1,656 903 2,554,631 377 18,016 rio.public.temp0000284744 1 0 0 0 0 0 0 138 6 9,131 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 133 2 10,489 0 0 contagem.pg_catalog.pg_type 1 1 0 0 0 0 0 128 54 63,516 3 8 brasilia.public.temp0000235458 1 0 0 0 0 0 0 239 6 15,234 0 0 rio.public.temp0000284692 1 0 0 0 0 0 0 88 6 6,107 0 0 contagem.pg_catalog.pg_depend 1 1 0 0 0 0 0 354 134 239,583 2 12 rio.public.temp0000284730 1 0 0 0 0 0 0 1,636 1,636 2,188,427 0 0 rio.public.temp0000284684 1 0 0 0 0 0 0 88 6 6,109 0 0 rio.public.temp0000284720 1 0 0 0 0 0 0 103 6 7,021 0 0 rio.public.temp0000284710 1 0 0 0 0 0 0 132 4 8,391 0 0 brasilia.public.temp0000235484 1 0 0 0 0 0 0 239 6 15,235 0 0 rio.public.temp0000284704 1 0 0 0 0 0 0 94 6 6,455 0 0 rio.public.temp0000284732 1 0 0 0 0 0 0 108 6 7,328 0 0 rio.public.temp0000284722 1 0 0 0 0 0 0 8 5 1,336 0 0 brasilia.public.temp0000235488 1 0 0 0 0 0 0 239 6 15,238 0 0 rio.public.temp0000284686 1 0 0 0 0 0 0 4 3 774 0 0 brasilia.auditor.auditor_2026_07 1 0 0 0 0 0 0 10,686 7,922 10,153,968 1,392 27,425 rio.public.temp0000284748 1 0 0 0 0 0 0 1,636 4 97,127 0 0 Total 417 204 0 0 0 0 0 308,380 93,162 145,059,106 28,711 610,556 Vacuum throughput per table
Key values
- auditor.auditor_2026_07 (14.55) 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 3.37 rio.public.temp0000284646 0 0 2.3 rio.public.temp0000284648 0 0 1.62 rio.pg_catalog.pg_class 0 0 0.9 rio.pg_catalog.pg_type 0 0 0.4 rio.pg_catalog.pg_index 0 0 0.17 contagem.public.usuarios 0 0 0 rio.public.temp0000284712 0 0 0.44 rio.pg_catalog.pg_depend 0 0 0.95 brasilia.pg_catalog.pg_attribute 0 0 1.03 rio.public.temp0000283932 0 0 0.18 rio.pg_catalog.pg_statistic 0 0 1.27 rio.public.temp0000284556 0 0 0.13 rio.public.temp0000284682 0 0 0.33 brasilia.pg_catalog.pg_class 0 0 0.24 rio.public.usuarios 0 0 0 postgres.pg_catalog.pg_shdepend 0 0 0.19 rio.public.temp0000284664 0 0 0.12 brasilia.pg_catalog.pg_type 0 0 0.07 contagem.pg_catalog.pg_attribute 0 0 0.38 brasilia.pg_catalog.pg_statistic 0 0 0.47 rio.public.temp0000284244 0 0 0.05 brasilia.pg_catalog.pg_index 0 0 0.04 rio.pg_toast.pg_toast_2619 0 0 0.21 rio.public.temp0000281789 0 0 0.07 brasilia.pg_catalog.pg_depend 0 0 0.21 rio.public.temp0000284718 0 0 0.1 brasilia.pg_toast.pg_toast_2619 0 0 0.02 rio.public.temp0000284658 0 0 0.06 contagem.pg_catalog.pg_statistic 0 0 0.11 rio.auditor.auditor_2026_07 0 0 14.55 brasilia.public.temp0000235494 0 0 0.05 rio.public.tmp_drill_0175 0 0 0 rio.public.temp0000284666 0 0 0.03 rio.public.temp0000284620 0 0 0.03 rio.public.temp0000284548 0 0 0.05 contagem.pg_catalog.pg_index 0 0 0.08 contagem.pg_catalog.pg_class 0 0 0.14 contagem.auditor.auditor_2026_07 0 0 2.18 rio.public.nf_entrada_arquivo_erros 0 0 0.52 rio.public.temp0000284744 0 0 0.02 contagem.pg_toast.pg_toast_2619 0 0 0 contagem.pg_catalog.pg_type 0 0 0.04 brasilia.public.temp0000235458 0 0 0.02 rio.public.temp0000284692 0 0 0.02 contagem.pg_catalog.pg_depend 0 0 0.1 rio.public.temp0000284730 0 0 0.08 rio.public.temp0000284684 0 0 0.02 rio.public.temp0000284720 0 0 0.02 rio.public.temp0000284710 0 0 0 brasilia.public.temp0000235484 0 0 0.02 rio.public.temp0000284704 0 0 0.02 rio.public.temp0000284732 0 0 0.02 rio.public.temp0000284722 0 0 0.02 brasilia.public.temp0000235488 0 0 0.02 rio.public.temp0000284686 0 0 0 brasilia.auditor.auditor_2026_07 0 0 2.54 rio.public.temp0000284748 0 0 0.05 Total 0 0 36.07 Tuples removed per table
Key values
- pg_catalog.pg_attribute (210521) Main table with removed tuples on database rio
- 346642 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 48 44 210,521 1,186,870 62,883 451 29,020 brasilia.pg_catalog.pg_attribute 14 14 50,871 309,584 592 78 7,819 rio.pg_catalog.pg_statistic 8 8 14,395 66,551 260 0 10,288 rio.pg_catalog.pg_type 27 24 11,894 65,187 3,948 28 1,984 contagem.pg_catalog.pg_attribute 4 4 10,386 94,152 0 0 2,096 rio.pg_catalog.pg_depend 16 15 9,432 307,585 3,723 0 2,992 brasilia.pg_catalog.pg_statistic 4 4 7,800 32,240 0 0 4,288 contagem.pg_catalog.pg_statistic 2 2 5,057 14,807 0 0 2,022 postgres.pg_catalog.pg_shdepend 7 7 4,728 95,968 968 0 805 rio.pg_catalog.pg_index 21 19 4,218 42,143 1,968 22 1,120 rio.pg_catalog.pg_class 30 27 3,773 117,000 11,223 65 3,923 brasilia.pg_catalog.pg_depend 3 3 3,365 54,218 0 0 522 brasilia.pg_catalog.pg_type 5 5 1,325 11,145 0 0 320 contagem.public.usuarios 20 0 1,294 460 0 0 40 brasilia.pg_catalog.pg_class 7 7 1,266 23,732 29 8 822 rio.pg_toast.pg_toast_2619 4 4 1,227 2,300 0 0 1,112 rio.public.nf_entrada_arquivo_erros 1 0 1,127 8,443,609 0 0 151,377 brasilia.pg_catalog.pg_index 4 4 976 7,521 0 3 212 contagem.pg_catalog.pg_depend 1 1 835 18,696 0 11 168 rio.auditor.auditor_2026_07 2 0 720 8,806,602 0 0 407,172 rio.public.usuarios 7 4 365 4,331 768 0 119 contagem.pg_catalog.pg_class 1 1 247 3,328 0 2 110 contagem.pg_catalog.pg_type 1 1 242 2,247 0 0 72 brasilia.pg_toast.pg_toast_2619 2 2 213 271 0 0 130 contagem.pg_catalog.pg_index 1 1 164 1,894 0 0 57 contagem.pg_toast.pg_toast_2619 1 1 109 115 0 0 54 brasilia.auditor.auditor_2026_07 1 0 92 991,420 0 0 43,656 rio.public.temp0000284718 2 0 0 25,102 0 33 1,759 rio.public.temp0000284682 7 0 0 160,794 0 0 11,648 contagem.auditor.auditor_2026_07 1 0 0 704,877 0 0 31,499 rio.public.temp0000284658 2 0 0 24,666 0 52 1,740 rio.public.temp0000284744 1 0 0 5,803 0 62 130 brasilia.public.temp0000235458 1 0 0 3,074 0 25 231 brasilia.public.temp0000235494 2 0 0 6,152 0 50 462 rio.public.temp0000284648 43 0 0 651,379 0 634 46,342 rio.public.temp0000284692 1 0 0 1,778 0 48 80 rio.public.temp0000284730 1 0 0 23,010 0 0 1,664 rio.public.temp0000284684 1 0 0 1,768 0 48 80 rio.public.temp0000284720 1 0 0 2,091 0 33 95 rio.public.temp0000284710 1 0 0 5,708 0 0 128 brasilia.public.temp0000235484 1 0 0 3,075 0 25 231 rio.public.temp0000284244 4 0 0 15,428 0 164 348 rio.public.temp0000284704 1 0 0 3,836 0 42 86 rio.public.temp0000284732 1 0 0 2,205 0 28 100 rio.public.temp0000284722 1 0 0 2,116 0 32 96 brasilia.public.temp0000235488 1 0 0 3,076 0 25 231 rio.public.tmp_drill_0175 2 2 0 796 0 0 22 rio.public.temp0000284666 2 0 0 3,774 0 84 172 rio.public.temp0000284646 45 0 0 1,034,245 0 0 74,880 rio.public.temp0000284686 1 0 0 2,768 0 0 64 rio.public.temp0000284712 17 0 0 158,549 0 255 9,601 rio.public.temp0000284620 2 0 0 8,861 0 122 198 rio.public.temp0000281789 4 0 0 14,360 0 64 320 rio.public.temp0000284556 8 0 0 30,218 0 287 673 rio.public.temp0000283932 12 0 0 46,095 0 250 1,030 rio.public.temp0000284664 6 0 0 26,690 0 173 595 rio.public.temp0000284548 2 0 0 24,692 0 50 1,742 rio.public.temp0000284748 1 0 0 23,011 0 0 1,664 Total 417 204 346,642 23,723,973 86,362 3,254 860,211 Pages removed per table
Key values
- public.temp0000284648 (634) Main table with removed pages on database rio
- 3254 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000284648 43 0 0 634 rio.pg_catalog.pg_attribute 48 44 210521 451 rio.public.temp0000284556 8 0 0 287 rio.public.temp0000284712 17 0 0 255 rio.public.temp0000283932 12 0 0 250 rio.public.temp0000284664 6 0 0 173 rio.public.temp0000284244 4 0 0 164 rio.public.temp0000284620 2 0 0 122 rio.public.temp0000284666 2 0 0 84 brasilia.pg_catalog.pg_attribute 14 14 50871 78 rio.pg_catalog.pg_class 30 27 3773 65 rio.public.temp0000281789 4 0 0 64 rio.public.temp0000284744 1 0 0 62 rio.public.temp0000284658 2 0 0 52 brasilia.public.temp0000235494 2 0 0 50 rio.public.temp0000284548 2 0 0 50 rio.public.temp0000284692 1 0 0 48 rio.public.temp0000284684 1 0 0 48 rio.public.temp0000284704 1 0 0 42 rio.public.temp0000284718 2 0 0 33 rio.public.temp0000284720 1 0 0 33 rio.public.temp0000284722 1 0 0 32 rio.public.temp0000284732 1 0 0 28 rio.pg_catalog.pg_type 27 24 11894 28 brasilia.public.temp0000235458 1 0 0 25 brasilia.public.temp0000235484 1 0 0 25 brasilia.public.temp0000235488 1 0 0 25 rio.pg_catalog.pg_index 21 19 4218 22 contagem.pg_catalog.pg_depend 1 1 835 11 brasilia.pg_catalog.pg_class 7 7 1266 8 brasilia.pg_catalog.pg_index 4 4 976 3 contagem.pg_catalog.pg_class 1 1 247 2 rio.public.temp0000284682 7 0 0 0 contagem.pg_catalog.pg_index 1 1 164 0 contagem.auditor.auditor_2026_07 1 0 0 0 contagem.public.usuarios 20 0 1294 0 brasilia.pg_toast.pg_toast_2619 2 2 213 0 rio.pg_catalog.pg_depend 16 15 9432 0 rio.public.nf_entrada_arquivo_erros 1 0 1127 0 contagem.pg_catalog.pg_attribute 4 4 10386 0 contagem.pg_toast.pg_toast_2619 1 1 109 0 contagem.pg_catalog.pg_statistic 2 2 5057 0 brasilia.pg_catalog.pg_statistic 4 4 7800 0 contagem.pg_catalog.pg_type 1 1 242 0 brasilia.pg_catalog.pg_depend 3 3 3365 0 rio.auditor.auditor_2026_07 2 0 720 0 brasilia.pg_catalog.pg_type 5 5 1325 0 rio.public.temp0000284730 1 0 0 0 rio.public.usuarios 7 4 365 0 rio.public.temp0000284710 1 0 0 0 rio.public.tmp_drill_0175 2 2 0 0 rio.public.temp0000284646 45 0 0 0 rio.pg_toast.pg_toast_2619 4 4 1227 0 rio.public.temp0000284686 1 0 0 0 rio.pg_catalog.pg_statistic 8 8 14395 0 postgres.pg_catalog.pg_shdepend 7 7 4728 0 brasilia.auditor.auditor_2026_07 1 0 92 0 rio.public.temp0000284748 1 0 0 0 Total 417 204 346,642 3,254 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 07 00 0 1 01 0 0 02 0 0 03 0 0 04 0 1 05 6 11 06 1 1 07 17 35 08 62 123 09 45 115 10 35 93 11 45 92 12 14 33 13 26 75 14 51 121 15 58 148 16 40 105 17 13 53 18 1 0 19 0 0 20 0 0 21 3 2 22 0 0 23 0 0 - 7.29 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 1 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 1m5s 1m5s 1m5s 1m5s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-07 07:46:14 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-07 00:05:25 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-07 16:15:13 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
Queries that waited the most
Rank Wait time Query 1 1m5s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-07 07:46:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Queries
Queries by type
Key values
- 4,120 Total read queries
- 1,383 Total write queries
Queries by database
Key values
- rio Main database
- 4,072 Requests
- 5h46m47s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 5,735 Requests
User Request type Count Duration etiquetas Total 45 9s46ms select 45 9s46ms intelifix Total 5,735 7h35m52s copy to 313 48m ddl 1,067 47m53s others 385 38m14s select 3,965 5h21m43s lenon Total 113 58s614ms ddl 3 838ms select 110 57s776ms Duration by user
Key values
- 7h35m52s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 45 9s46ms select 45 9s46ms intelifix Total 5,735 7h35m52s copy to 313 48m ddl 1,067 47m53s others 385 38m14s select 3,965 5h21m43s lenon Total 113 58s614ms ddl 3 838ms select 110 57s776ms Queries by host
Key values
- [local] Main host
- 5,890 Requests
- 7h36m59s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,969 Requests
- 3h51m25s (psql)
- Main time consuming application
Application Request type Count Duration [unknown] Total 4,969 2h57m31s ddl 1,067 47m53s select 3,897 2h9m36s pgAdmin 4 - CONN:4183051 Total 1 294ms ddl 1 294ms pgAdmin 4 - CONN:566028 Total 1 254ms ddl 1 254ms pgAdmin 4 - CONN:6997493 Total 1 289ms ddl 1 289ms pg_dump Total 325 48m2s copy to 313 48m select 12 2s353ms psql Total 596 3h51m25s others 385 38m14s select 211 3h13m10s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-07 10:09:29 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,938 100-500ms duration
Slowest individual queries
Rank Duration Query 1 8m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-07 15:13:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m10s analyze verbose;[ Date: 2026-07-07 05:08:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-07 11:12:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 7m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-07 09:12:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 7m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-07 07:12:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 7m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-07 12:12:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 7m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-07 10:12:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 7m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-07 16:12:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 7m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-07 14:12:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-07 17:12:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-07 08:11:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-07 20:11:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-07 13:11:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-07 18:10:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m41s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026751, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-07 16:33:59 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 5m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-07 21:10:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-07 22:10:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m28s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026747, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-07 15:56:52 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 5m27s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026732, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-07 14:39:29 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-07 19:10:28 - 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 1h56m59s 48 1s305ms 8m22s 2m26s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 07 07 3 8m21s 2m47s 08 3 7m1s 2m20s 09 3 8m17s 2m45s 10 3 7m49s 2m36s 11 3 8m36s 2m52s 12 3 7m49s 2m36s 13 3 6m22s 2m7s 14 3 7m43s 2m34s 15 3 8m57s 2m59s 16 3 8m4s 2m41s 17 3 7m39s 2m33s 18 3 6m13s 2m4s 19 3 5m42s 1m54s 20 3 6m42s 2m14s 21 3 5m49s 1m56s 22 3 5m47s 1m55s [ User: intelifix - Total duration: 1h56m59s - Times executed: 48 ]
[ Application: psql - Total duration: 1h56m59s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-07 15:13:24 Duration: 8m22s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-07 11:12:59 Duration: 7m58s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-07 09:12:52 Duration: 7m50s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
2 1h25m13s 387 152ms 5m41s 13s212ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 07 07 16 14m18s 53s682ms 08 39 14m52s 22s891ms 09 53 6m47s 7s679ms 10 29 9m45s 20s202ms 11 38 5m32s 8s749ms 12 10 50s251ms 5s25ms 13 24 45s594ms 1s899ms 14 50 12m 14s409ms 15 50 7m2s 8s449ms 16 55 9m28s 10s336ms 17 23 3m48s 9s945ms [ User: intelifix - Total duration: 1h25m13s - Times executed: 387 ]
[ Application: [unknown] - Total duration: 1h25m13s - Times executed: 387 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026751, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-07 16:33:59 Duration: 5m41s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026747, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-07 15:56:52 Duration: 5m28s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026732, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-07 14:39:29 Duration: 5m27s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
3 1h9m23s 48 259ms 4m20s 1m26s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 07 07 3 4m35s 1m31s 08 3 4m24s 1m28s 09 3 4m46s 1m35s 10 3 4m29s 1m29s 11 3 4m43s 1m34s 12 3 4m8s 1m22s 13 3 3m53s 1m17s 14 3 5m15s 1m45s 15 3 4m55s 1m38s 16 3 4m51s 1m37s 17 3 4m28s 1m29s 18 3 3m54s 1m18s 19 3 3m40s 1m13s 20 3 3m57s 1m19s 21 3 3m36s 1m12s 22 3 3m41s 1m13s [ User: intelifix - Total duration: 1h9m23s - Times executed: 48 ]
[ Application: psql - Total duration: 1h9m23s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-07 14:17:53 Duration: 4m20s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-07 15:18:51 Duration: 4m3s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-07 16:17:54 Duration: 3m58s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
4 18m38s 1,162 150ms 6s559ms 962ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 07 07 6 2s38ms 339ms 08 170 2m20s 823ms 09 188 2m59s 954ms 10 78 1m15s 963ms 11 108 1m55s 1s72ms 12 52 42s206ms 811ms 13 49 49s352ms 1s7ms 14 147 2m39s 1s85ms 15 148 2m23s 971ms 16 161 2m43s 1s15ms 17 55 47s702ms 867ms [ User: intelifix - Total duration: 18m38s - Times executed: 1162 ]
[ Application: [unknown] - Total duration: 18m38s - Times executed: 1162 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45119, 407, 'ZTE3ANNR3Y57368,4896D9550148,4896D9550149,ZTEGD97F10CD$ZTE3ANNQ4A01357,3CF9F0AA1814,3CF9F0AA1815,ZTEGD641440C$ZTE3ANNRC565743,6C11BA682EB1,6C11BA682EB2,ZTEGDC6F168E$ZTE3ANNRC565676,6C11BA682D1F,6C11BA682D20,ZTEGDC6F164B$ZTE3ANNRB705113,5872C98EB107,5872C98EB108,ZTEGDC613ECC$ZTE3ANNR2Q01633,F4E84F80DA46,F4E84F80DA47,ZTEGD97A791B$ZTE3ANNR3J00452,F4E84F8658F8,F4E84F8658F9,ZTEGD97B638E$ZTE3ANNQ8113279,689E29BD1605,689E29BD1606,ZTEGD7B76E6F$ZTE3ANNQ9336930,843C9935F6C9,843C9935F6CA,ZTEGD7BC4C39$ZTE3ANNT3H64503,D831399CAB62,D831399CAB63,ZTEGDD32CC96$ZTE3ANNR9W03845,D89A0DA8B641,D89A0DA8B642,ZTEGDB1620B0$ZTE3ANNRCP67228,6C11BA6F5277,6C11BA6F5278,ZTEGDC70472F$ZTE3ANNR3Y57362,4896D9550124,4896D9550125,ZTEGD97F10C7$ZTE3ANNRB746067,5872C99270E3,5872C99270E4,ZTEGDC61DEC6$ZTE3ANNR1Y17885,14CA56CE4DA9,14CA56CE4DAA,ZTEGD970BC38$ZTE3ANNR3J30282,F4E84F89141C,F4E84F89141D,ZTEGD97BD814$ZTE3ANNRAD24817,D89A0DB02009,D89A0DB0200A,ZTEGDB175CFC$ZTE3ANNQCA39355,14CA56D5DF3D,14CA56D5DF3E,ZTEGD971FF26$ZTE3ANNR8C24285,38914850C035,38914850C036,ZTEGDB08DF4D$ZTE3ANNR3Y57759,4896D9550A72,4896D9550A73,ZTEGD97F1254$ZTE3ANNR2Q04439,F4E84F811C0A,F4E84F811C0B,ZTEGD97A8411$ZTE3ANNQ4410104,3CF9F0AC4BAE,3CF9F0AC4BAF,ZTEGD641A1FB$ZTE3ANNR8C24292,38914850C05F,38914850C060,ZTEGDB08DF54$ZTE3ANNQ8M07255,843C991F71F5,843C991F71F6,ZTEGD7BA63C4$ZTE3ANNRAD32004,D89A0DB0C87B,D89A0DB0C87C,ZTEGDB17790F$ZTE3ANNQ7503240,C4EBFF8B3F2C,C4EBFF8B3F2D,ZTEGD70A5B48$ZTE3ANNRAM35399,5872C98A75E3,5872C98A75E4,ZTEGDC608A46$ZTE3ANNR8C24244,38914850BF3F,38914850BF40,ZTEGDB08DF24$ZTE3ANNQ9334530,843C9935BE89,843C9935BE8A,ZTEGD7BC42D9', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-07 16:20:29 Duration: 6s559ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (44827, 418, 'ZTE3ANNRCB66767,D8313923EBD8,D8313923EBD9,ZTEGDD2ABA64$ZTE3ANNR5W14504,48D6822FD7BA,48D6822FD7BB,ZTEGDB0038A7$ZTE3ANNR9F36715,D89A0DA63A65,D89A0DA63A66,ZTEGDB15B6B6$ZTE3ANNT4P16619,F00C514D2C20,F00C514D2C21,ZTEGDE343781$ZTE3ANNQCA03505,14CA56D29701,14CA56D29702,ZTEGD971731C$ZTE3ANNRCB61254,D83139236AA2,D83139236AA3,ZTEGDD2AA4DB$ZTE3ANNR9325443,D89A0D84B45D,D89A0D84B45E,ZTEGDB14D762$ZTE3ANNT2V84818,D831399352C4,D831399352C5,ZTEGDD313DD1$ZTE3ANNR8C25888,38914850E5C7,38914850E5C8,ZTEGDB08E590$ZTE3ANNR6R27788,48D68238100A,48D68238100B,ZTEGDB01975F$ZTE3ANNR9F17014,D89A0DA46CA7,D89A0DA46CA8,ZTEGDB1569C1$ZTE3ANNR3J05788,F4E84F86D608,F4E84F86D609,ZTEGD97B7866$ZTE3ANNRC560194,6C11BA67ACA3,6C11BA67ACA4,ZTEGDC6F00E1$ZTE3ANNR3J30280,F4E84F891410,F4E84F891411,ZTEGD97BD812$ZTE3ANNR9F18286,D89A0DA48A77,D89A0DA48A78,ZTEGDB156EB9$ZTE3ANNR5W76324,48D6823580A2,48D6823580A3,ZTEGDB012A23$ZTE3ANNR4N17708,4896D956FA20,4896D956FA21,ZTEGD97F64F1$ZTE3ANNR3Y01691,4896D94FE85A,4896D94FE85B,ZTEGD97E3750$ZTE3ANNRC575711,6C11BA691851,6C11BA691852,ZTEGDC6F3D7E$ZTE3ANNRCB63595,D8313923A180,D8313923A181,ZTEGDD2AAE00$ZTE3ANNR1Y08072,14CA56CD67AB,14CA56CD67AC,ZTEGD97095E3$ZTE3ANNR3J07047,F4E84F86F38A,F4E84F86F38B,ZTEGD97B7D51$ZTE3ANNRCB23954,D8313920006A,D8313920006B,ZTEGDD2A1327$ZTE3ANNR5W13231,48D6822FB9E4,48D6822FB9E5,ZTEGDB0033AE$ZTE3ANNRCP03776,6C11BA69834F,6C11BA698350,ZTEGDC6F4F53$ZTE3ANNQ7913825,C4EBFF8D6216,C4EBFF8D6217,ZTEGD70AB66F$ZTE3ANNQ9306654,843C99333131,843C99333132,ZTEGD7BBD5F5$ZTE3ANNRC575098,6C11BA6909F3,6C11BA6909F4,ZTEGDC6F3B19$ZTE3ANNRCB63506,D83139239F6A,D83139239F6B,ZTEGDD2AADA7$ZTE3ANNR9W03905,D89A0DA8B7A9,D89A0DA8B7AA,ZTEGDB1620EC$ZTE3ANNT2V84668,D83139934F40,D83139934F41,ZTEGDD313D3B$ZTE3ANNT4P14192,F00C514CF33E,F00C514CF33F,ZTEGDE342E06$ZTE3ANNT2V13493,D831398CCB16,D831398CCB17,ZTEGDD302734$ZTE3ANNR7B32179,3891484BDED9,3891484BDEDA,ZTEGDB080F13$ZTE3ANNRC565289,6C11BA68240D,6C11BA68240E,ZTEGDC6F14C8$ZTE3ANNRC552219,6C11BA66F1B9,6C11BA66F1BA,ZTEGDC6EE1BA$ZTE3ANNR9W44466,D89A0DAC6E4F,D89A0DAC6E50,ZTEGDB16BF5D$ZTE3ANNRCB72508,D83139247266,D83139247267,ZTEGDD2AD0D1$ZTE3ANNRAD20893,D89A0DAFC411,D89A0DAFC412,ZTEGDB174DA8$ZTE3ANNR9W44728,D89A0DAC7473,D89A0DAC7474,ZTEGDB16C063$ZTE3ANNT3J12649,D83139A113C8,D83139A113C9,ZTEGDD3388A7', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-07 15:37:21 Duration: 5s509ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (44779, 407, '270911020033105272,229784727878,229670624162,229749891629,229740274764,229865173654,229865385773,229745804563,229669714062,229933915772,229815885970,229784229009,229745810827,229784139808,229859601629,229782345368,229669005272,229782932934,229808863658,229665133940,229689058889,216932466781,229691632026,229669108087,229689434460,229816886382,229781783944,216944515353,229837217479,229809223244,229816654463', '246586642039,246514192241,246562977091,246558989306,246649804050,246649734346,246548537982,246515568402,226407785065,246630211723,246586853653,246550251529,246588434256,246641593451,246596049208,246515698391,246597909917,246612976875,246472207076,246516706885,246433329601,246506365371,246514472829,246285156565,246628233954,246598585067,246461409401,246640726183,246627571937,246628335254,,,,,,,,', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-07 10:55:25 Duration: 5s272ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
5 14m24s 3 2m16s 8m10s 4m48s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 07 05 3 14m24s 4m48s [ User: intelifix - Total duration: 14m24s - Times executed: 3 ]
[ Application: psql - Total duration: 14m24s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-07 05:08:12 Duration: 8m10s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
analyze verbose;
Date: 2026-07-07 05:12:08 Duration: 3m56s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
analyze verbose;
Date: 2026-07-07 05:14:25 Duration: 2m16s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
6 14m20s 70 9s504ms 40s130ms 12s294ms create table temp0000284646 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 07 06 1 40s130ms 40s130ms 08 6 1m10s 11s780ms 09 10 1m59s 11s922ms 10 13 2m46s 12s799ms 11 14 2m40s 11s442ms 13 6 1m11s 11s956ms 14 8 1m34s 11s791ms 15 8 1m30s 11s293ms 16 4 47s562ms 11s890ms [ User: intelifix - Total duration: 14m20s - Times executed: 70 ]
[ Application: [unknown] - Total duration: 14m20s - Times executed: 70 ]
-
CREATE TABLE temp0000284646 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 06:58:59 Duration: 40s130ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284646 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 10:42:22 Duration: 16s100ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284646 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 10:38:29 Duration: 15s695ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
7 12m49s 68 9s187ms 15s132ms 11s317ms create table temp0000284648 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 07 07 18 3m10s 10s564ms 08 15 2m50s 11s361ms 09 3 34s240ms 11s413ms 10 6 1m3s 10s501ms 11 6 1m8s 11s403ms 14 8 1m34s 11s767ms 15 6 1m14s 12s444ms 16 6 1m14s 12s420ms [ User: intelifix - Total duration: 12m49s - Times executed: 68 ]
[ Application: [unknown] - Total duration: 12m49s - Times executed: 68 ]
-
CREATE TABLE temp0000284648 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 16:26:18 Duration: 15s132ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284648 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 15:49:24 Duration: 14s194ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284648 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 16:27:40 Duration: 13s645ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
8 10m46s 201 1s133ms 13s218ms 3s215ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 07 07 2 6s230ms 3s115ms 08 1 5s727ms 5s727ms 09 3 9s592ms 3s197ms 10 7 26s226ms 3s746ms 11 14 53s117ms 3s794ms 12 13 30s188ms 2s322ms 13 14 34s384ms 2s456ms 14 29 2m3s 4s254ms 15 41 1m59s 2s920ms 16 53 3m2s 3s438ms 17 24 55s471ms 2s311ms [ User: intelifix - Total duration: 10m46s - Times executed: 201 ]
[ Application: [unknown] - Total duration: 10m46s - Times executed: 201 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-07', 0320, '', '', 0, 6, '2026-07-01');
Date: 2026-07-07 10:59:00 Duration: 13s218ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-07', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-07 14:02:24 Duration: 12s568ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-07', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-07 14:02:42 Duration: 11s719ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
9 10m38s 163 151ms 1m10s 3s919ms call rs_giga_triagem (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 07 00 8 27s135ms 3s391ms 01 8 19s233ms 2s404ms 02 7 20s73ms 2s867ms 03 9 20s759ms 2s306ms 04 6 17s674ms 2s945ms 05 6 20s661ms 3s443ms 06 7 21s206ms 3s29ms 07 6 1m28s 14s830ms 08 8 23s814ms 2s976ms 09 9 22s707ms 2s523ms 10 6 23s714ms 3s952ms 11 8 25s345ms 3s168ms 12 7 21s127ms 3s18ms 13 6 23s231ms 3s871ms 14 6 29s510ms 4s918ms 15 6 33s184ms 5s530ms 16 10 35s763ms 3s576ms 17 6 28s738ms 4s789ms 18 7 26s357ms 3s765ms 19 6 27s265ms 4s544ms 20 8 31s654ms 3s956ms 21 6 25s335ms 4s222ms 22 7 25s354ms 3s622ms [ User: intelifix - Total duration: 10m38s - Times executed: 163 ]
[ Application: psql - Total duration: 10m38s - Times executed: 163 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-07 07:46:14 Duration: 1m10s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-07 00:05:25 Duration: 10s89ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-07 16:15:13 Duration: 8s421ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
10 7m40s 948 151ms 1s886ms 486ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 07 07 13 8s244ms 634ms 08 100 56s287ms 562ms 09 168 1m17s 459ms 10 128 1m6s 519ms 11 126 58s88ms 461ms 12 17 9s194ms 540ms 13 72 31s856ms 442ms 14 117 46s454ms 397ms 15 128 1m5s 515ms 16 46 28s535ms 620ms 17 33 12s612ms 382ms [ User: intelifix - Total duration: 7m40s - Times executed: 948 ]
[ Application: [unknown] - Total duration: 7m40s - Times executed: 948 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "263660", "modelo" : "320", "itens" : "241653914347,241655612033,241677179300,241734198388,241676470612,241678322027,241708582646,241654544061,241601122136,241654657281,241700754160,241652384355,230048066789,241652855568,241632344049,241729904457,241731220411,241726970827,241711195560,241668246374,241680511231,241594992828,241680343436,241676851132,241607261321,241637691530,241593448591,241729894557,241654446576,241658326876,241708831436,241704722527,241689370715,241703620310,241634359295,241634352730,241680362832,241729928601,241651551334,835046907000064,241702111835,241678297074,241714990219,241664849713,241697150206,230048436881,241717158891,241632327279", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-07 16:07:57 Duration: 1s886ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "263000", "modelo" : "320", "itens" : "241734106281,241697061533,241672366170,241661408906,241629137282,241654486883,241649593241,241668307390,241704180825,241636269505,241649168193,230048080910,241694900615,241699132341,241734196772,241711232433,241708835678,241729770606,241593014554,230048924965,241673062232,230048068810,241666410113,241659021221,241652114452,241594082021,241596243949,230055032733,241694828182,241617501131,241631564343,241647338700,241697114848,241674576565,241674601417,241656333551,241661113142,241661110415,241631585961,241703403745", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-07 16:15:54 Duration: 1s770ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "262940", "modelo" : "141", "itens" : "229786989918,229933714361,229738797279,229860989912,229750430627,229781771216,229788172222,229748081733,229672664361,229749201326,229739600221,229738334653,229739022936,229860893236,229751418185,229781480829,229686351320,229879537277,229884860312,229859443555,229736695155,229805566276,229728121839,229812831116,229865597084,229753278288,229738265555,229933255371", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246455399397,246169170421,246569402242,246651968706,246529422021,246566554960,246597986669,246548204965,246256252836,246602640312,246526815066,246550132123,246527840509,246541773047,246529856586,246597944567,226184680722,246345611737,246244633150,246174937694,246280719208,246596137476,246489487887,246612166785,246651997294,246563965762,246548480627,226293066181,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-07 08:04:20 Duration: 1s649ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
11 6m37s 163 160ms 14s2ms 2s440ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 07 00 4 18s965ms 4s741ms 01 6 8s135ms 1s355ms 02 6 6s670ms 1s111ms 03 5 7s646ms 1s529ms 04 6 9s350ms 1s558ms 05 4 8s977ms 2s244ms 06 3 4s634ms 1s544ms 07 9 26s61ms 2s895ms 08 12 40s422ms 3s368ms 09 12 37s331ms 3s110ms 10 12 32s210ms 2s684ms 11 12 40s156ms 3s346ms 12 12 28s4ms 2s333ms 13 10 8s545ms 854ms 14 12 36s84ms 3s7ms 15 12 38s448ms 3s204ms 16 12 27s323ms 2s276ms 17 4 3s388ms 847ms 21 4 5s817ms 1s454ms 22 6 9s648ms 1s608ms [ User: intelifix - Total duration: 6m37s - Times executed: 163 ]
[ Application: psql - Total duration: 6m37s - Times executed: 163 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-07 00:05:15 Duration: 14s2ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-07 07:25:08 Duration: 7s334ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-07 14:25:08 Duration: 7s85ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
12 4m41s 64 218ms 54s706ms 4s391ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 07 07 6 4s114ms 685ms 08 9 21s543ms 2s393ms 09 5 23s274ms 4s654ms 10 7 1m24s 12s141ms 11 7 1m28s 12s597ms 13 2 11s231ms 5s615ms 14 7 24s644ms 3s520ms 15 15 6s621ms 441ms 16 5 9s242ms 1s848ms 17 1 7s214ms 7s214ms [ User: intelifix - Total duration: 4m41s - Times executed: 64 ]
[ Application: psql - Total duration: 4m41s - Times executed: 64 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026717);
Date: 2026-07-07 10:49:22 Duration: 54s706ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026723);
Date: 2026-07-07 11:35:14 Duration: 52s217ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026724);
Date: 2026-07-07 11:43:35 Duration: 24s463ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
13 3m26s 17 9s554ms 16s641ms 12s153ms create table temp0000284712 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 07 15 17 3m26s 12s153ms [ User: intelifix - Total duration: 3m26s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 3m26s - Times executed: 17 ]
-
CREATE TABLE temp0000284712 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 15:20:52 Duration: 16s641ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284712 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 15:36:02 Duration: 13s680ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284712 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 15:28:13 Duration: 13s575ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
14 3m6s 16 10s12ms 14s331ms 11s668ms create table temp0000284682 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 07 08 9 1m41s 11s266ms 09 5 1m3s 12s651ms 10 2 22s40ms 11s20ms [ User: intelifix - Total duration: 3m6s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 3m6s - Times executed: 16 ]
-
CREATE TABLE temp0000284682 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 09:00:09 Duration: 14s331ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284682 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 09:56:14 Duration: 14s73ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284682 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 08:56:51 Duration: 13s253ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
15 3m 4 4s285ms 1m28s 45s116ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 07 20 2 1m27s 43s570ms 23 2 1m33s 46s663ms [ User: intelifix - Total duration: 3m - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-07 23:38:08 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-07 20:08:15 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-07 23:49:05 Duration: 4s764ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-07.log
16 2m13s 28 2s813ms 12s384ms 4s781ms create table temp0000284648 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 07 07 11 36s902ms 3s354ms 09 6 26s680ms 4s446ms 11 2 17s50ms 8s525ms 14 8 48s355ms 6s44ms 15 1 4s881ms 4s881ms [ User: intelifix - Total duration: 2m13s - Times executed: 28 ]
[ Application: [unknown] - Total duration: 2m13s - Times executed: 28 ]
-
CREATE TABLE temp0000284648 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"02-07-2026", "ate" :"07-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-07 11:07:08 Duration: 12s384ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284648 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"02-07-2026", "ate" :"07-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-07 14:39:59 Duration: 11s846ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284648 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"02-07-2026", "ate" :"07-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-07 09:01:45 Duration: 5s766ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
17 2m9s 32 671ms 15s925ms 4s39ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 07 08 2 4s375ms 2s187ms 09 1 671ms 671ms 10 2 20s780ms 10s390ms 11 2 13s357ms 6s678ms 12 2 7s193ms 3s596ms 13 3 5s337ms 1s779ms 14 2 11s854ms 5s927ms 15 3 27s636ms 9s212ms 16 3 23s861ms 7s953ms 17 2 2s498ms 1s249ms 18 3 3s144ms 1s48ms 19 1 1s213ms 1s213ms 20 2 3s459ms 1s729ms 21 2 1s948ms 974ms 22 2 1s935ms 967ms [ User: intelifix - Total duration: 2m9s - Times executed: 32 ]
[ Application: psql - Total duration: 2m9s - Times executed: 32 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-07 16:20:17 Duration: 15s925ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-07 15:40:16 Duration: 15s333ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-07 10:20:13 Duration: 11s703ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
18 2m3s 2 22s403ms 1m41s 1m1s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 07 23 2 2m3s 1m1s [ User: intelifix - Total duration: 2m3s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m3s - Times executed: 2 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-07 23:13:00 Duration: 1m41s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-07 23:49:55 Duration: 22s403ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-07.log
19 1m48s 4 347ms 55s900ms 27s115ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 07 20 2 56s248ms 28s124ms 23 2 52s213ms 26s106ms [ User: intelifix - Total duration: 1m48s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-07 20:05:18 Duration: 55s900ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-07 23:18:12 Duration: 51s849ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-07 23:39:30 Duration: 364ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-07.log
20 1m44s 2 5s437ms 1m39s 52s393ms copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 07 23 2 1m44s 52s393ms [ User: intelifix - Total duration: 1m44s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m44s - Times executed: 2 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-07 23:14:40 Duration: 1m39s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-07 23:38:41 Duration: 5s437ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-07.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,162 18m38s 150ms 6s559ms 962ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 07 07 6 2s38ms 339ms 08 170 2m20s 823ms 09 188 2m59s 954ms 10 78 1m15s 963ms 11 108 1m55s 1s72ms 12 52 42s206ms 811ms 13 49 49s352ms 1s7ms 14 147 2m39s 1s85ms 15 148 2m23s 971ms 16 161 2m43s 1s15ms 17 55 47s702ms 867ms [ User: intelifix - Total duration: 18m38s - Times executed: 1162 ]
[ Application: [unknown] - Total duration: 18m38s - Times executed: 1162 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45119, 407, 'ZTE3ANNR3Y57368,4896D9550148,4896D9550149,ZTEGD97F10CD$ZTE3ANNQ4A01357,3CF9F0AA1814,3CF9F0AA1815,ZTEGD641440C$ZTE3ANNRC565743,6C11BA682EB1,6C11BA682EB2,ZTEGDC6F168E$ZTE3ANNRC565676,6C11BA682D1F,6C11BA682D20,ZTEGDC6F164B$ZTE3ANNRB705113,5872C98EB107,5872C98EB108,ZTEGDC613ECC$ZTE3ANNR2Q01633,F4E84F80DA46,F4E84F80DA47,ZTEGD97A791B$ZTE3ANNR3J00452,F4E84F8658F8,F4E84F8658F9,ZTEGD97B638E$ZTE3ANNQ8113279,689E29BD1605,689E29BD1606,ZTEGD7B76E6F$ZTE3ANNQ9336930,843C9935F6C9,843C9935F6CA,ZTEGD7BC4C39$ZTE3ANNT3H64503,D831399CAB62,D831399CAB63,ZTEGDD32CC96$ZTE3ANNR9W03845,D89A0DA8B641,D89A0DA8B642,ZTEGDB1620B0$ZTE3ANNRCP67228,6C11BA6F5277,6C11BA6F5278,ZTEGDC70472F$ZTE3ANNR3Y57362,4896D9550124,4896D9550125,ZTEGD97F10C7$ZTE3ANNRB746067,5872C99270E3,5872C99270E4,ZTEGDC61DEC6$ZTE3ANNR1Y17885,14CA56CE4DA9,14CA56CE4DAA,ZTEGD970BC38$ZTE3ANNR3J30282,F4E84F89141C,F4E84F89141D,ZTEGD97BD814$ZTE3ANNRAD24817,D89A0DB02009,D89A0DB0200A,ZTEGDB175CFC$ZTE3ANNQCA39355,14CA56D5DF3D,14CA56D5DF3E,ZTEGD971FF26$ZTE3ANNR8C24285,38914850C035,38914850C036,ZTEGDB08DF4D$ZTE3ANNR3Y57759,4896D9550A72,4896D9550A73,ZTEGD97F1254$ZTE3ANNR2Q04439,F4E84F811C0A,F4E84F811C0B,ZTEGD97A8411$ZTE3ANNQ4410104,3CF9F0AC4BAE,3CF9F0AC4BAF,ZTEGD641A1FB$ZTE3ANNR8C24292,38914850C05F,38914850C060,ZTEGDB08DF54$ZTE3ANNQ8M07255,843C991F71F5,843C991F71F6,ZTEGD7BA63C4$ZTE3ANNRAD32004,D89A0DB0C87B,D89A0DB0C87C,ZTEGDB17790F$ZTE3ANNQ7503240,C4EBFF8B3F2C,C4EBFF8B3F2D,ZTEGD70A5B48$ZTE3ANNRAM35399,5872C98A75E3,5872C98A75E4,ZTEGDC608A46$ZTE3ANNR8C24244,38914850BF3F,38914850BF40,ZTEGDB08DF24$ZTE3ANNQ9334530,843C9935BE89,843C9935BE8A,ZTEGD7BC42D9', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-07 16:20:29 Duration: 6s559ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (44827, 418, 'ZTE3ANNRCB66767,D8313923EBD8,D8313923EBD9,ZTEGDD2ABA64$ZTE3ANNR5W14504,48D6822FD7BA,48D6822FD7BB,ZTEGDB0038A7$ZTE3ANNR9F36715,D89A0DA63A65,D89A0DA63A66,ZTEGDB15B6B6$ZTE3ANNT4P16619,F00C514D2C20,F00C514D2C21,ZTEGDE343781$ZTE3ANNQCA03505,14CA56D29701,14CA56D29702,ZTEGD971731C$ZTE3ANNRCB61254,D83139236AA2,D83139236AA3,ZTEGDD2AA4DB$ZTE3ANNR9325443,D89A0D84B45D,D89A0D84B45E,ZTEGDB14D762$ZTE3ANNT2V84818,D831399352C4,D831399352C5,ZTEGDD313DD1$ZTE3ANNR8C25888,38914850E5C7,38914850E5C8,ZTEGDB08E590$ZTE3ANNR6R27788,48D68238100A,48D68238100B,ZTEGDB01975F$ZTE3ANNR9F17014,D89A0DA46CA7,D89A0DA46CA8,ZTEGDB1569C1$ZTE3ANNR3J05788,F4E84F86D608,F4E84F86D609,ZTEGD97B7866$ZTE3ANNRC560194,6C11BA67ACA3,6C11BA67ACA4,ZTEGDC6F00E1$ZTE3ANNR3J30280,F4E84F891410,F4E84F891411,ZTEGD97BD812$ZTE3ANNR9F18286,D89A0DA48A77,D89A0DA48A78,ZTEGDB156EB9$ZTE3ANNR5W76324,48D6823580A2,48D6823580A3,ZTEGDB012A23$ZTE3ANNR4N17708,4896D956FA20,4896D956FA21,ZTEGD97F64F1$ZTE3ANNR3Y01691,4896D94FE85A,4896D94FE85B,ZTEGD97E3750$ZTE3ANNRC575711,6C11BA691851,6C11BA691852,ZTEGDC6F3D7E$ZTE3ANNRCB63595,D8313923A180,D8313923A181,ZTEGDD2AAE00$ZTE3ANNR1Y08072,14CA56CD67AB,14CA56CD67AC,ZTEGD97095E3$ZTE3ANNR3J07047,F4E84F86F38A,F4E84F86F38B,ZTEGD97B7D51$ZTE3ANNRCB23954,D8313920006A,D8313920006B,ZTEGDD2A1327$ZTE3ANNR5W13231,48D6822FB9E4,48D6822FB9E5,ZTEGDB0033AE$ZTE3ANNRCP03776,6C11BA69834F,6C11BA698350,ZTEGDC6F4F53$ZTE3ANNQ7913825,C4EBFF8D6216,C4EBFF8D6217,ZTEGD70AB66F$ZTE3ANNQ9306654,843C99333131,843C99333132,ZTEGD7BBD5F5$ZTE3ANNRC575098,6C11BA6909F3,6C11BA6909F4,ZTEGDC6F3B19$ZTE3ANNRCB63506,D83139239F6A,D83139239F6B,ZTEGDD2AADA7$ZTE3ANNR9W03905,D89A0DA8B7A9,D89A0DA8B7AA,ZTEGDB1620EC$ZTE3ANNT2V84668,D83139934F40,D83139934F41,ZTEGDD313D3B$ZTE3ANNT4P14192,F00C514CF33E,F00C514CF33F,ZTEGDE342E06$ZTE3ANNT2V13493,D831398CCB16,D831398CCB17,ZTEGDD302734$ZTE3ANNR7B32179,3891484BDED9,3891484BDEDA,ZTEGDB080F13$ZTE3ANNRC565289,6C11BA68240D,6C11BA68240E,ZTEGDC6F14C8$ZTE3ANNRC552219,6C11BA66F1B9,6C11BA66F1BA,ZTEGDC6EE1BA$ZTE3ANNR9W44466,D89A0DAC6E4F,D89A0DAC6E50,ZTEGDB16BF5D$ZTE3ANNRCB72508,D83139247266,D83139247267,ZTEGDD2AD0D1$ZTE3ANNRAD20893,D89A0DAFC411,D89A0DAFC412,ZTEGDB174DA8$ZTE3ANNR9W44728,D89A0DAC7473,D89A0DAC7474,ZTEGDB16C063$ZTE3ANNT3J12649,D83139A113C8,D83139A113C9,ZTEGDD3388A7', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-07 15:37:21 Duration: 5s509ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (44779, 407, '270911020033105272,229784727878,229670624162,229749891629,229740274764,229865173654,229865385773,229745804563,229669714062,229933915772,229815885970,229784229009,229745810827,229784139808,229859601629,229782345368,229669005272,229782932934,229808863658,229665133940,229689058889,216932466781,229691632026,229669108087,229689434460,229816886382,229781783944,216944515353,229837217479,229809223244,229816654463', '246586642039,246514192241,246562977091,246558989306,246649804050,246649734346,246548537982,246515568402,226407785065,246630211723,246586853653,246550251529,246588434256,246641593451,246596049208,246515698391,246597909917,246612976875,246472207076,246516706885,246433329601,246506365371,246514472829,246285156565,246628233954,246598585067,246461409401,246640726183,246627571937,246628335254,,,,,,,,', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-07 10:55:25 Duration: 5s272ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
2 948 7m40s 151ms 1s886ms 486ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 07 07 13 8s244ms 634ms 08 100 56s287ms 562ms 09 168 1m17s 459ms 10 128 1m6s 519ms 11 126 58s88ms 461ms 12 17 9s194ms 540ms 13 72 31s856ms 442ms 14 117 46s454ms 397ms 15 128 1m5s 515ms 16 46 28s535ms 620ms 17 33 12s612ms 382ms [ User: intelifix - Total duration: 7m40s - Times executed: 948 ]
[ Application: [unknown] - Total duration: 7m40s - Times executed: 948 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "263660", "modelo" : "320", "itens" : "241653914347,241655612033,241677179300,241734198388,241676470612,241678322027,241708582646,241654544061,241601122136,241654657281,241700754160,241652384355,230048066789,241652855568,241632344049,241729904457,241731220411,241726970827,241711195560,241668246374,241680511231,241594992828,241680343436,241676851132,241607261321,241637691530,241593448591,241729894557,241654446576,241658326876,241708831436,241704722527,241689370715,241703620310,241634359295,241634352730,241680362832,241729928601,241651551334,835046907000064,241702111835,241678297074,241714990219,241664849713,241697150206,230048436881,241717158891,241632327279", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-07 16:07:57 Duration: 1s886ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "263000", "modelo" : "320", "itens" : "241734106281,241697061533,241672366170,241661408906,241629137282,241654486883,241649593241,241668307390,241704180825,241636269505,241649168193,230048080910,241694900615,241699132341,241734196772,241711232433,241708835678,241729770606,241593014554,230048924965,241673062232,230048068810,241666410113,241659021221,241652114452,241594082021,241596243949,230055032733,241694828182,241617501131,241631564343,241647338700,241697114848,241674576565,241674601417,241656333551,241661113142,241661110415,241631585961,241703403745", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-07 16:15:54 Duration: 1s770ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "262940", "modelo" : "141", "itens" : "229786989918,229933714361,229738797279,229860989912,229750430627,229781771216,229788172222,229748081733,229672664361,229749201326,229739600221,229738334653,229739022936,229860893236,229751418185,229781480829,229686351320,229879537277,229884860312,229859443555,229736695155,229805566276,229728121839,229812831116,229865597084,229753278288,229738265555,229933255371", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246455399397,246169170421,246569402242,246651968706,246529422021,246566554960,246597986669,246548204965,246256252836,246602640312,246526815066,246550132123,246527840509,246541773047,246529856586,246597944567,226184680722,246345611737,246244633150,246174937694,246280719208,246596137476,246489487887,246612166785,246651997294,246563965762,246548480627,226293066181,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-07 08:04:20 Duration: 1s649ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
3 387 1h25m13s 152ms 5m41s 13s212ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 07 07 16 14m18s 53s682ms 08 39 14m52s 22s891ms 09 53 6m47s 7s679ms 10 29 9m45s 20s202ms 11 38 5m32s 8s749ms 12 10 50s251ms 5s25ms 13 24 45s594ms 1s899ms 14 50 12m 14s409ms 15 50 7m2s 8s449ms 16 55 9m28s 10s336ms 17 23 3m48s 9s945ms [ User: intelifix - Total duration: 1h25m13s - Times executed: 387 ]
[ Application: [unknown] - Total duration: 1h25m13s - Times executed: 387 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026751, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-07 16:33:59 Duration: 5m41s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026747, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-07 15:56:52 Duration: 5m28s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026732, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-07 14:39:29 Duration: 5m27s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
4 201 10m46s 1s133ms 13s218ms 3s215ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 07 07 2 6s230ms 3s115ms 08 1 5s727ms 5s727ms 09 3 9s592ms 3s197ms 10 7 26s226ms 3s746ms 11 14 53s117ms 3s794ms 12 13 30s188ms 2s322ms 13 14 34s384ms 2s456ms 14 29 2m3s 4s254ms 15 41 1m59s 2s920ms 16 53 3m2s 3s438ms 17 24 55s471ms 2s311ms [ User: intelifix - Total duration: 10m46s - Times executed: 201 ]
[ Application: [unknown] - Total duration: 10m46s - Times executed: 201 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-07', 0320, '', '', 0, 6, '2026-07-01');
Date: 2026-07-07 10:59:00 Duration: 13s218ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-07', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-07 14:02:24 Duration: 12s568ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-07', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-07 14:02:42 Duration: 11s719ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
5 164 27s109ms 150ms 210ms 165ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 07 05 5 760ms 152ms 07 5 812ms 162ms 08 9 1s508ms 167ms 09 30 5s43ms 168ms 10 12 1s969ms 164ms 11 27 4s443ms 164ms 12 1 192ms 192ms 13 17 2s764ms 162ms 14 19 3s137ms 165ms 15 29 4s825ms 166ms 16 9 1s491ms 165ms 17 1 158ms 158ms [ User: intelifix - Total duration: 27s109ms - Times executed: 164 ]
[ Application: [unknown] - Total duration: 27s109ms - Times executed: 164 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0320;
Date: 2026-07-07 16:00:41 Duration: 210ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0211;
Date: 2026-07-07 14:59:56 Duration: 206ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0298;
Date: 2026-07-07 15:14:14 Duration: 202ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
6 163 10m38s 151ms 1m10s 3s919ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 07 00 8 27s135ms 3s391ms 01 8 19s233ms 2s404ms 02 7 20s73ms 2s867ms 03 9 20s759ms 2s306ms 04 6 17s674ms 2s945ms 05 6 20s661ms 3s443ms 06 7 21s206ms 3s29ms 07 6 1m28s 14s830ms 08 8 23s814ms 2s976ms 09 9 22s707ms 2s523ms 10 6 23s714ms 3s952ms 11 8 25s345ms 3s168ms 12 7 21s127ms 3s18ms 13 6 23s231ms 3s871ms 14 6 29s510ms 4s918ms 15 6 33s184ms 5s530ms 16 10 35s763ms 3s576ms 17 6 28s738ms 4s789ms 18 7 26s357ms 3s765ms 19 6 27s265ms 4s544ms 20 8 31s654ms 3s956ms 21 6 25s335ms 4s222ms 22 7 25s354ms 3s622ms [ User: intelifix - Total duration: 10m38s - Times executed: 163 ]
[ Application: psql - Total duration: 10m38s - Times executed: 163 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-07 07:46:14 Duration: 1m10s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-07 00:05:25 Duration: 10s89ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-07 16:15:13 Duration: 8s421ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
7 163 6m37s 160ms 14s2ms 2s440ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 07 00 4 18s965ms 4s741ms 01 6 8s135ms 1s355ms 02 6 6s670ms 1s111ms 03 5 7s646ms 1s529ms 04 6 9s350ms 1s558ms 05 4 8s977ms 2s244ms 06 3 4s634ms 1s544ms 07 9 26s61ms 2s895ms 08 12 40s422ms 3s368ms 09 12 37s331ms 3s110ms 10 12 32s210ms 2s684ms 11 12 40s156ms 3s346ms 12 12 28s4ms 2s333ms 13 10 8s545ms 854ms 14 12 36s84ms 3s7ms 15 12 38s448ms 3s204ms 16 12 27s323ms 2s276ms 17 4 3s388ms 847ms 21 4 5s817ms 1s454ms 22 6 9s648ms 1s608ms [ User: intelifix - Total duration: 6m37s - Times executed: 163 ]
[ Application: psql - Total duration: 6m37s - Times executed: 163 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-07 00:05:15 Duration: 14s2ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-07 07:25:08 Duration: 7s334ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-07 14:25:08 Duration: 7s85ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
8 149 1m39s 156ms 3s714ms 671ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 07 07 9 5s608ms 623ms 08 18 15s8ms 833ms 09 15 8s231ms 548ms 10 14 9s556ms 682ms 11 12 8s257ms 688ms 12 2 2s232ms 1s116ms 13 13 8s558ms 658ms 14 17 11s912ms 700ms 15 17 15s59ms 885ms 16 27 11s373ms 421ms 17 5 4s188ms 837ms [ User: intelifix - Total duration: 1m39s - Times executed: 149 ]
[ Application: [unknown] - Total duration: 1m39s - Times executed: 149 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0126995) LIMIT 1;
Date: 2026-07-07 15:16:57 Duration: 3s714ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0126995) LIMIT 1;
Date: 2026-07-07 11:31:29 Duration: 2s790ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0126760) LIMIT 1;
Date: 2026-07-07 15:04:23 Duration: 2s767ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
9 116 23s909ms 151ms 872ms 206ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 07 01 3 543ms 181ms 04 2 317ms 158ms 05 7 1s618ms 231ms 07 9 1s675ms 186ms 08 16 3s64ms 191ms 09 10 2s150ms 215ms 10 12 2s437ms 203ms 11 11 3s372ms 306ms 12 6 1s93ms 182ms 13 1 155ms 155ms 14 8 1s407ms 175ms 15 20 3s788ms 189ms 16 11 2s282ms 207ms [ User: intelifix - Total duration: 23s909ms - Times executed: 116 ]
[ Application: [unknown] - Total duration: 23s909ms - Times executed: 116 ]
-
SELECT * FROM RS_TRIAGEM (310, 5, '63', 2, '484BD4B4989C,F8D2AC4D08C8,3C82C0916D3C,08A7C070E674,B85E71D38A4C,08A7C052206C,D4E2CB8C8454,B85E71C60FFC,4075C3BB3CC0,E4BFFAF03524,B85E71C3E204,C4509CB026EC,4075C39B2084,ECA81F2043D4,08A7C06B4074,CCF3C848092C,E4BFFAF24FA4,3C82C091444C,D4E2CB8D6D94,B85E71C53F64,3C82C06BA2B0,C4509CAC7394,B85E71E1EB64,ECA81F20354C,B85E71CAB6EC,4075C3BBEAF8,4075C3B99B54,D4E2CB97A714,08A7C0725264,8C6A8DC0DA1C,3C82C06C1240,B85E71D92894,B85E71C6E800,4075C39ADC50,3C82C0CB4070,8C6A8DC214BC,B85E71D02384,B85E71ED53C8,484BD4B41934,00CB7ADCC6A4,400FC185AFE4,B85E71D89884,4075C3B99A28,3C82C06BCB8C,D4E2CB8FCEC4,08A7C06ABBFC,C4509CAC71CC,B85E71E60D48,C4509CE838A4,400FC17F40B4,B85E71E4FA98,B85E71C5C600,400FC182E1F4,B85E71DFB4FC,08A7C07121FC,B85E71DE3690,80DAC2D21D00,3C82C0C4FE04', NULL, NULL, 0185, 00);
Date: 2026-07-07 11:05:36 Duration: 872ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_TRIAGEM (310, 5, '63', 2, '3C82C0919DE8,E4BFFAF7DB4C,B85E71D1DF94,484BD48A302C,3C82C091BFBC,1C9D72850CBC,D4E2CB1F33D4,B85E71EAE2DC,ECA81FFB2D64,ECA81F6A79B4,4075C39A9434,B85E71E8DD48,B85E71DB5358,3C82C0CAC834,CCF3C846AE4C,4075C3BD8520,400FC17F5944,B85E71E36D68,B85E71D9D000,484BD4AFCEA4,484BD4A55CCC,400FC182D36C,F8D2AC4CC4F8,B85E71C50C9C,B85E71D1A998,B85E71D20104,B85E71DF7384,1C9D72809544,C4509CAF074C,F8D2AC162AC8,4075C3B8EFEC,4075C39A233C,ECA81FF6D35C,E4BFFAF41444', NULL, NULL, 0185, 00);
Date: 2026-07-07 11:20:52 Duration: 519ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '216734131017,216800525880,216870754350,216879647901,216815973841,216873759806,216872492444,184268170628,216834416370,216818358899,216832511718,216750701624,216514450913', NULL, NULL, 062, 00);
Date: 2026-07-07 11:20:16 Duration: 302ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
10 112 43s604ms 209ms 619ms 389ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 07 07 4 1s582ms 395ms 08 8 2s902ms 362ms 09 14 5s842ms 417ms 10 7 2s688ms 384ms 11 9 3s409ms 378ms 12 3 1s232ms 410ms 13 7 2s513ms 359ms 14 16 6s340ms 396ms 15 19 7s704ms 405ms 16 13 4s805ms 369ms 17 12 4s583ms 381ms [ User: intelifix - Total duration: 43s604ms - Times executed: 112 ]
[ Application: [unknown] - Total duration: 43s604ms - Times executed: 112 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-07 14:53:02 Duration: 619ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-07-07 09:04:14 Duration: 593ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-07 15:58:58 Duration: 591ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
11 103 46s720ms 277ms 781ms 453ms 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 #11
Day Hour Count Duration Avg duration Jul 07 01 1 494ms 494ms 03 1 352ms 352ms 04 1 331ms 331ms 05 3 1s207ms 402ms 06 3 1s274ms 424ms 07 7 3s113ms 444ms 08 12 5s801ms 483ms 09 8 4s39ms 504ms 10 11 4s440ms 403ms 11 5 2s237ms 447ms 12 7 3s357ms 479ms 13 10 4s320ms 432ms 14 7 3s716ms 530ms 15 10 4s321ms 432ms 16 10 4s569ms 456ms 17 5 2s349ms 469ms 21 1 401ms 401ms 22 1 388ms 388ms [ User: lenon - Total duration: 46s720ms - Times executed: 103 ]
[ Application: [unknown] - Total duration: 46s720ms - Times executed: 103 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-07 14:03:27 Duration: 781ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-07.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-07-07 12:02:49 Duration: 710ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-07.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-07-07 08:25:26 Duration: 668ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-07.log
12 94 53s590ms 345ms 859ms 570ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 07 01 1 739ms 739ms 04 1 464ms 464ms 05 3 1s529ms 509ms 07 6 3s271ms 545ms 08 12 7s22ms 585ms 09 8 4s980ms 622ms 10 11 5s665ms 515ms 11 4 2s214ms 553ms 12 6 3s794ms 632ms 13 9 5s68ms 563ms 14 7 4s403ms 629ms 15 10 5s465ms 546ms 16 10 5s645ms 564ms 17 5 2s765ms 553ms 22 1 559ms 559ms [ User: intelifix - Total duration: 53s590ms - Times executed: 94 ]
[ Application: [unknown] - Total duration: 53s590ms - Times executed: 94 ]
-
select * from rs_menu_grants (427, 21, 1);
Date: 2026-07-07 14:03:27 Duration: 859ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-07-07 15:27:46 Duration: 858ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
select * from rs_menu_grants (397, 18, 1);
Date: 2026-07-07 08:25:26 Duration: 828ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
13 75 16s135ms 150ms 2s867ms 215ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 07 01 1 182ms 182ms 07 2 344ms 172ms 08 1 304ms 304ms 09 3 521ms 173ms 11 8 3s977ms 497ms 12 2 369ms 184ms 13 1 154ms 154ms 14 6 993ms 165ms 15 21 3s565ms 169ms 16 17 3s396ms 199ms 17 13 2s326ms 178ms [ User: intelifix - Total duration: 16s135ms - Times executed: 75 ]
[ Application: [unknown] - Total duration: 16s135ms - Times executed: 75 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-07-07", "data-ate" : "2026-07-07", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 509 }');
Date: 2026-07-07 11:38:33 Duration: 2s867ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "432", "data-de" : "2026-07-06", "data-ate" : "2026-07-06", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 503 }');
Date: 2026-07-07 08:24:25 Duration: 304ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "432", "data-de" : "2026-07-07", "data-ate" : "2026-07-07", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 503 }');
Date: 2026-07-07 16:32:38 Duration: 261ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
14 70 14m20s 9s504ms 40s130ms 12s294ms create table temp0000284646 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 07 06 1 40s130ms 40s130ms 08 6 1m10s 11s780ms 09 10 1m59s 11s922ms 10 13 2m46s 12s799ms 11 14 2m40s 11s442ms 13 6 1m11s 11s956ms 14 8 1m34s 11s791ms 15 8 1m30s 11s293ms 16 4 47s562ms 11s890ms [ User: intelifix - Total duration: 14m20s - Times executed: 70 ]
[ Application: [unknown] - Total duration: 14m20s - Times executed: 70 ]
-
CREATE TABLE temp0000284646 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 06:58:59 Duration: 40s130ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284646 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 10:42:22 Duration: 16s100ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284646 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 10:38:29 Duration: 15s695ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
15 68 12m49s 9s187ms 15s132ms 11s317ms create table temp0000284648 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 07 07 18 3m10s 10s564ms 08 15 2m50s 11s361ms 09 3 34s240ms 11s413ms 10 6 1m3s 10s501ms 11 6 1m8s 11s403ms 14 8 1m34s 11s767ms 15 6 1m14s 12s444ms 16 6 1m14s 12s420ms [ User: intelifix - Total duration: 12m49s - Times executed: 68 ]
[ Application: [unknown] - Total duration: 12m49s - Times executed: 68 ]
-
CREATE TABLE temp0000284648 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 16:26:18 Duration: 15s132ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284648 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 15:49:24 Duration: 14s194ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284648 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 16:27:40 Duration: 13s645ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
16 64 4m41s 218ms 54s706ms 4s391ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 07 07 6 4s114ms 685ms 08 9 21s543ms 2s393ms 09 5 23s274ms 4s654ms 10 7 1m24s 12s141ms 11 7 1m28s 12s597ms 13 2 11s231ms 5s615ms 14 7 24s644ms 3s520ms 15 15 6s621ms 441ms 16 5 9s242ms 1s848ms 17 1 7s214ms 7s214ms [ User: intelifix - Total duration: 4m41s - Times executed: 64 ]
[ Application: psql - Total duration: 4m41s - Times executed: 64 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026717);
Date: 2026-07-07 10:49:22 Duration: 54s706ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026723);
Date: 2026-07-07 11:35:14 Duration: 52s217ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026724);
Date: 2026-07-07 11:43:35 Duration: 24s463ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
17 55 11s940ms 150ms 591ms 217ms create table temp0000235442 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 07 07 6 1s634ms 272ms 08 3 773ms 257ms 09 3 481ms 160ms 10 11 2s313ms 210ms 11 9 1s846ms 205ms 12 17 3s749ms 220ms 13 6 1s142ms 190ms [ User: intelifix - Total duration: 11s940ms - Times executed: 55 ]
[ Application: [unknown] - Total duration: 11s940ms - Times executed: 55 ]
-
CREATE TABLE temp0000235442 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "02-07-2026", "data-ate" : "07-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-07 07:56:24 Duration: 591ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000235442 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "07-07-2026", "data-ate" : "07-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-07 12:51:44 Duration: 335ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000235442 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "06-07-2026", "data-ate" : "06-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-07 08:00:47 Duration: 321ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
18 51 14s704ms 153ms 2s21ms 288ms create table temp0000226553 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 07 08 1 156ms 156ms 09 8 3s283ms 410ms 10 13 2s619ms 201ms 11 7 1s822ms 260ms 13 5 1s322ms 264ms 14 5 923ms 184ms 15 3 510ms 170ms 16 7 3s80ms 440ms 17 2 986ms 493ms [ User: intelifix - Total duration: 14s704ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 14s704ms - Times executed: 51 ]
-
CREATE TABLE temp0000226553 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"02-07-2026", "ate" :"07-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-07 16:53:41 Duration: 2s21ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000226553 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"02-07-2026", "ate" :"07-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-07 09:02:48 Duration: 1s537ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000226553 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"02-07-2026", "ate" :"07-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-07 17:42:42 Duration: 818ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
19 49 16s644ms 154ms 1s89ms 339ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 07 09 10 4s272ms 427ms 10 3 555ms 185ms 11 5 1s479ms 295ms 12 4 778ms 194ms 13 8 3s329ms 416ms 14 10 3s916ms 391ms 15 6 1s672ms 278ms 16 2 468ms 234ms 17 1 171ms 171ms [ User: intelifix - Total duration: 16s644ms - Times executed: 49 ]
[ Application: [unknown] - Total duration: 16s644ms - Times executed: 49 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '843C992C7B6F,D83139A0281E,3CF9F0A8E0F2,D89A0DB05717,C4EBFF8ADFB0,D831399E08D0,4896D9528416,6C11BA66CFF9,C4EBFF8D2436,843C992D4151,6C11BA6BD5B5,843C9921839F,D831399C9C20,C4EBFF8DFFE4,C4EBFF8A12EA,F4E84F8492C6,843C9933A8BF,3CF9F0AC3546', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-07-07 09:48:58 Duration: 1s89ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'ZTE3A8TRCB09903,DC5193DC440A,7C7D21F0F543,7C7D21F1D39F,7C7D21EB6907,E44E12B1AAB1,E44E12937AD3,7C7D21F0A24B,7C7D21EED713,E44E1291BD23,E44E12B0D9A1,E44E1292EE97,DC5193DC06FA,E44E12B0DAFD,14200452E9E2,E44E12AF7415,DC5193D9E842,7C7D21ED4173,ZTE3A8TR6509451', '','DEFAULT',09,0329,'', '','', 00);
Date: 2026-07-07 14:05:32 Duration: 946ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '229711972945,216929183745,216924347481,229702721021,229731064056,229732873649,229716517585,216927154961,229703954261,229733248791,229824058787,229713556376,229830722222,229676637273,229829448595,229715102532,216930266061,229678280510,229732650519,229714037186,229646958282,216931451924,229774064459,229827845061,229733411132,229832434757,229833183551', '','DEFAULT',056,0137,'', '','', 00);
Date: 2026-07-07 09:55:39 Duration: 914ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
20 48 1h56m59s 1s305ms 8m22s 2m26s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 07 07 3 8m21s 2m47s 08 3 7m1s 2m20s 09 3 8m17s 2m45s 10 3 7m49s 2m36s 11 3 8m36s 2m52s 12 3 7m49s 2m36s 13 3 6m22s 2m7s 14 3 7m43s 2m34s 15 3 8m57s 2m59s 16 3 8m4s 2m41s 17 3 7m39s 2m33s 18 3 6m13s 2m4s 19 3 5m42s 1m54s 20 3 6m42s 2m14s 21 3 5m49s 1m56s 22 3 5m47s 1m55s [ User: intelifix - Total duration: 1h56m59s - Times executed: 48 ]
[ Application: psql - Total duration: 1h56m59s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-07 15:13:24 Duration: 8m22s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-07 11:12:59 Duration: 7m58s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-07 09:12:52 Duration: 7m50s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m16s 8m10s 4m48s 3 14m24s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 07 05 3 14m24s 4m48s [ User: intelifix - Total duration: 14m24s - Times executed: 3 ]
[ Application: psql - Total duration: 14m24s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-07 05:08:12 Duration: 8m10s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
analyze verbose;
Date: 2026-07-07 05:12:08 Duration: 3m56s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
analyze verbose;
Date: 2026-07-07 05:14:25 Duration: 2m16s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
2 1s305ms 8m22s 2m26s 48 1h56m59s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 07 07 3 8m21s 2m47s 08 3 7m1s 2m20s 09 3 8m17s 2m45s 10 3 7m49s 2m36s 11 3 8m36s 2m52s 12 3 7m49s 2m36s 13 3 6m22s 2m7s 14 3 7m43s 2m34s 15 3 8m57s 2m59s 16 3 8m4s 2m41s 17 3 7m39s 2m33s 18 3 6m13s 2m4s 19 3 5m42s 1m54s 20 3 6m42s 2m14s 21 3 5m49s 1m56s 22 3 5m47s 1m55s [ User: intelifix - Total duration: 1h56m59s - Times executed: 48 ]
[ Application: psql - Total duration: 1h56m59s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-07 15:13:24 Duration: 8m22s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-07 11:12:59 Duration: 7m58s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-07 09:12:52 Duration: 7m50s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
3 259ms 4m20s 1m26s 48 1h9m23s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 07 07 3 4m35s 1m31s 08 3 4m24s 1m28s 09 3 4m46s 1m35s 10 3 4m29s 1m29s 11 3 4m43s 1m34s 12 3 4m8s 1m22s 13 3 3m53s 1m17s 14 3 5m15s 1m45s 15 3 4m55s 1m38s 16 3 4m51s 1m37s 17 3 4m28s 1m29s 18 3 3m54s 1m18s 19 3 3m40s 1m13s 20 3 3m57s 1m19s 21 3 3m36s 1m12s 22 3 3m41s 1m13s [ User: intelifix - Total duration: 1h9m23s - Times executed: 48 ]
[ Application: psql - Total duration: 1h9m23s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-07 14:17:53 Duration: 4m20s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-07 15:18:51 Duration: 4m3s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-07 16:17:54 Duration: 3m58s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
4 22s403ms 1m41s 1m1s 2 2m3s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 07 23 2 2m3s 1m1s [ User: intelifix - Total duration: 2m3s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m3s - Times executed: 2 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-07 23:13:00 Duration: 1m41s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-07 23:49:55 Duration: 22s403ms Database: contagem User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-07.log
5 5s437ms 1m39s 52s393ms 2 1m44s copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 07 23 2 1m44s 52s393ms [ User: intelifix - Total duration: 1m44s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m44s - Times executed: 2 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-07 23:14:40 Duration: 1m39s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-07 23:38:41 Duration: 5s437ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-07.log
6 4s285ms 1m28s 45s116ms 4 3m copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 07 20 2 1m27s 43s570ms 23 2 1m33s 46s663ms [ User: intelifix - Total duration: 3m - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-07 23:38:08 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-07 20:08:15 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-07 23:49:05 Duration: 4s764ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-07.log
7 347ms 55s900ms 27s115ms 4 1m48s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 07 20 2 56s248ms 28s124ms 23 2 52s213ms 26s106ms [ User: intelifix - Total duration: 1m48s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-07 20:05:18 Duration: 55s900ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-07 23:18:12 Duration: 51s849ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-07 23:39:30 Duration: 364ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-07.log
8 152ms 5m41s 13s212ms 387 1h25m13s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 07 07 16 14m18s 53s682ms 08 39 14m52s 22s891ms 09 53 6m47s 7s679ms 10 29 9m45s 20s202ms 11 38 5m32s 8s749ms 12 10 50s251ms 5s25ms 13 24 45s594ms 1s899ms 14 50 12m 14s409ms 15 50 7m2s 8s449ms 16 55 9m28s 10s336ms 17 23 3m48s 9s945ms [ User: intelifix - Total duration: 1h25m13s - Times executed: 387 ]
[ Application: [unknown] - Total duration: 1h25m13s - Times executed: 387 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026751, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-07 16:33:59 Duration: 5m41s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026747, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-07 15:56:52 Duration: 5m28s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026732, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-07 14:39:29 Duration: 5m27s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
9 9s504ms 40s130ms 12s294ms 70 14m20s create table temp0000284646 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 07 06 1 40s130ms 40s130ms 08 6 1m10s 11s780ms 09 10 1m59s 11s922ms 10 13 2m46s 12s799ms 11 14 2m40s 11s442ms 13 6 1m11s 11s956ms 14 8 1m34s 11s791ms 15 8 1m30s 11s293ms 16 4 47s562ms 11s890ms [ User: intelifix - Total duration: 14m20s - Times executed: 70 ]
[ Application: [unknown] - Total duration: 14m20s - Times executed: 70 ]
-
CREATE TABLE temp0000284646 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 06:58:59 Duration: 40s130ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284646 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 10:42:22 Duration: 16s100ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284646 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 10:38:29 Duration: 15s695ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
10 9s554ms 16s641ms 12s153ms 17 3m26s create table temp0000284712 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 07 15 17 3m26s 12s153ms [ User: intelifix - Total duration: 3m26s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 3m26s - Times executed: 17 ]
-
CREATE TABLE temp0000284712 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 15:20:52 Duration: 16s641ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284712 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 15:36:02 Duration: 13s680ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284712 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 15:28:13 Duration: 13s575ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
11 10s12ms 14s331ms 11s668ms 16 3m6s create table temp0000284682 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 07 08 9 1m41s 11s266ms 09 5 1m3s 12s651ms 10 2 22s40ms 11s20ms [ User: intelifix - Total duration: 3m6s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 3m6s - Times executed: 16 ]
-
CREATE TABLE temp0000284682 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 09:00:09 Duration: 14s331ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284682 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 09:56:14 Duration: 14s73ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284682 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 08:56:51 Duration: 13s253ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
12 9s187ms 15s132ms 11s317ms 68 12m49s create table temp0000284648 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 07 07 18 3m10s 10s564ms 08 15 2m50s 11s361ms 09 3 34s240ms 11s413ms 10 6 1m3s 10s501ms 11 6 1m8s 11s403ms 14 8 1m34s 11s767ms 15 6 1m14s 12s444ms 16 6 1m14s 12s420ms [ User: intelifix - Total duration: 12m49s - Times executed: 68 ]
[ Application: [unknown] - Total duration: 12m49s - Times executed: 68 ]
-
CREATE TABLE temp0000284648 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 16:26:18 Duration: 15s132ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284648 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 15:49:24 Duration: 14s194ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284648 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-07 16:27:40 Duration: 13s645ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
13 2s813ms 12s384ms 4s781ms 28 2m13s create table temp0000284648 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 07 07 11 36s902ms 3s354ms 09 6 26s680ms 4s446ms 11 2 17s50ms 8s525ms 14 8 48s355ms 6s44ms 15 1 4s881ms 4s881ms [ User: intelifix - Total duration: 2m13s - Times executed: 28 ]
[ Application: [unknown] - Total duration: 2m13s - Times executed: 28 ]
-
CREATE TABLE temp0000284648 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"02-07-2026", "ate" :"07-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-07 11:07:08 Duration: 12s384ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284648 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"02-07-2026", "ate" :"07-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-07 14:39:59 Duration: 11s846ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CREATE TABLE temp0000284648 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"02-07-2026", "ate" :"07-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-07 09:01:45 Duration: 5s766ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
14 218ms 54s706ms 4s391ms 64 4m41s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 07 07 6 4s114ms 685ms 08 9 21s543ms 2s393ms 09 5 23s274ms 4s654ms 10 7 1m24s 12s141ms 11 7 1m28s 12s597ms 13 2 11s231ms 5s615ms 14 7 24s644ms 3s520ms 15 15 6s621ms 441ms 16 5 9s242ms 1s848ms 17 1 7s214ms 7s214ms [ User: intelifix - Total duration: 4m41s - Times executed: 64 ]
[ Application: psql - Total duration: 4m41s - Times executed: 64 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026717);
Date: 2026-07-07 10:49:22 Duration: 54s706ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026723);
Date: 2026-07-07 11:35:14 Duration: 52s217ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026724);
Date: 2026-07-07 11:43:35 Duration: 24s463ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
15 671ms 15s925ms 4s39ms 32 2m9s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 07 08 2 4s375ms 2s187ms 09 1 671ms 671ms 10 2 20s780ms 10s390ms 11 2 13s357ms 6s678ms 12 2 7s193ms 3s596ms 13 3 5s337ms 1s779ms 14 2 11s854ms 5s927ms 15 3 27s636ms 9s212ms 16 3 23s861ms 7s953ms 17 2 2s498ms 1s249ms 18 3 3s144ms 1s48ms 19 1 1s213ms 1s213ms 20 2 3s459ms 1s729ms 21 2 1s948ms 974ms 22 2 1s935ms 967ms [ User: intelifix - Total duration: 2m9s - Times executed: 32 ]
[ Application: psql - Total duration: 2m9s - Times executed: 32 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-07 16:20:17 Duration: 15s925ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-07 15:40:16 Duration: 15s333ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-07 10:20:13 Duration: 11s703ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
16 151ms 1m10s 3s919ms 163 10m38s call rs_giga_triagem (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 07 00 8 27s135ms 3s391ms 01 8 19s233ms 2s404ms 02 7 20s73ms 2s867ms 03 9 20s759ms 2s306ms 04 6 17s674ms 2s945ms 05 6 20s661ms 3s443ms 06 7 21s206ms 3s29ms 07 6 1m28s 14s830ms 08 8 23s814ms 2s976ms 09 9 22s707ms 2s523ms 10 6 23s714ms 3s952ms 11 8 25s345ms 3s168ms 12 7 21s127ms 3s18ms 13 6 23s231ms 3s871ms 14 6 29s510ms 4s918ms 15 6 33s184ms 5s530ms 16 10 35s763ms 3s576ms 17 6 28s738ms 4s789ms 18 7 26s357ms 3s765ms 19 6 27s265ms 4s544ms 20 8 31s654ms 3s956ms 21 6 25s335ms 4s222ms 22 7 25s354ms 3s622ms [ User: intelifix - Total duration: 10m38s - Times executed: 163 ]
[ Application: psql - Total duration: 10m38s - Times executed: 163 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-07 07:46:14 Duration: 1m10s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-07 00:05:25 Duration: 10s89ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-07 16:15:13 Duration: 8s421ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
17 1s133ms 13s218ms 3s215ms 201 10m46s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 07 07 2 6s230ms 3s115ms 08 1 5s727ms 5s727ms 09 3 9s592ms 3s197ms 10 7 26s226ms 3s746ms 11 14 53s117ms 3s794ms 12 13 30s188ms 2s322ms 13 14 34s384ms 2s456ms 14 29 2m3s 4s254ms 15 41 1m59s 2s920ms 16 53 3m2s 3s438ms 17 24 55s471ms 2s311ms [ User: intelifix - Total duration: 10m46s - Times executed: 201 ]
[ Application: [unknown] - Total duration: 10m46s - Times executed: 201 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-07', 0320, '', '', 0, 6, '2026-07-01');
Date: 2026-07-07 10:59:00 Duration: 13s218ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-07', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-07 14:02:24 Duration: 12s568ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-07', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-07 14:02:42 Duration: 11s719ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
18 160ms 14s2ms 2s440ms 163 6m37s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 07 00 4 18s965ms 4s741ms 01 6 8s135ms 1s355ms 02 6 6s670ms 1s111ms 03 5 7s646ms 1s529ms 04 6 9s350ms 1s558ms 05 4 8s977ms 2s244ms 06 3 4s634ms 1s544ms 07 9 26s61ms 2s895ms 08 12 40s422ms 3s368ms 09 12 37s331ms 3s110ms 10 12 32s210ms 2s684ms 11 12 40s156ms 3s346ms 12 12 28s4ms 2s333ms 13 10 8s545ms 854ms 14 12 36s84ms 3s7ms 15 12 38s448ms 3s204ms 16 12 27s323ms 2s276ms 17 4 3s388ms 847ms 21 4 5s817ms 1s454ms 22 6 9s648ms 1s608ms [ User: intelifix - Total duration: 6m37s - Times executed: 163 ]
[ Application: psql - Total duration: 6m37s - Times executed: 163 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-07 00:05:15 Duration: 14s2ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-07 07:25:08 Duration: 7s334ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-07 14:25:08 Duration: 7s85ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-07.log
19 150ms 6s559ms 962ms 1,162 18m38s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 07 07 6 2s38ms 339ms 08 170 2m20s 823ms 09 188 2m59s 954ms 10 78 1m15s 963ms 11 108 1m55s 1s72ms 12 52 42s206ms 811ms 13 49 49s352ms 1s7ms 14 147 2m39s 1s85ms 15 148 2m23s 971ms 16 161 2m43s 1s15ms 17 55 47s702ms 867ms [ User: intelifix - Total duration: 18m38s - Times executed: 1162 ]
[ Application: [unknown] - Total duration: 18m38s - Times executed: 1162 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45119, 407, 'ZTE3ANNR3Y57368,4896D9550148,4896D9550149,ZTEGD97F10CD$ZTE3ANNQ4A01357,3CF9F0AA1814,3CF9F0AA1815,ZTEGD641440C$ZTE3ANNRC565743,6C11BA682EB1,6C11BA682EB2,ZTEGDC6F168E$ZTE3ANNRC565676,6C11BA682D1F,6C11BA682D20,ZTEGDC6F164B$ZTE3ANNRB705113,5872C98EB107,5872C98EB108,ZTEGDC613ECC$ZTE3ANNR2Q01633,F4E84F80DA46,F4E84F80DA47,ZTEGD97A791B$ZTE3ANNR3J00452,F4E84F8658F8,F4E84F8658F9,ZTEGD97B638E$ZTE3ANNQ8113279,689E29BD1605,689E29BD1606,ZTEGD7B76E6F$ZTE3ANNQ9336930,843C9935F6C9,843C9935F6CA,ZTEGD7BC4C39$ZTE3ANNT3H64503,D831399CAB62,D831399CAB63,ZTEGDD32CC96$ZTE3ANNR9W03845,D89A0DA8B641,D89A0DA8B642,ZTEGDB1620B0$ZTE3ANNRCP67228,6C11BA6F5277,6C11BA6F5278,ZTEGDC70472F$ZTE3ANNR3Y57362,4896D9550124,4896D9550125,ZTEGD97F10C7$ZTE3ANNRB746067,5872C99270E3,5872C99270E4,ZTEGDC61DEC6$ZTE3ANNR1Y17885,14CA56CE4DA9,14CA56CE4DAA,ZTEGD970BC38$ZTE3ANNR3J30282,F4E84F89141C,F4E84F89141D,ZTEGD97BD814$ZTE3ANNRAD24817,D89A0DB02009,D89A0DB0200A,ZTEGDB175CFC$ZTE3ANNQCA39355,14CA56D5DF3D,14CA56D5DF3E,ZTEGD971FF26$ZTE3ANNR8C24285,38914850C035,38914850C036,ZTEGDB08DF4D$ZTE3ANNR3Y57759,4896D9550A72,4896D9550A73,ZTEGD97F1254$ZTE3ANNR2Q04439,F4E84F811C0A,F4E84F811C0B,ZTEGD97A8411$ZTE3ANNQ4410104,3CF9F0AC4BAE,3CF9F0AC4BAF,ZTEGD641A1FB$ZTE3ANNR8C24292,38914850C05F,38914850C060,ZTEGDB08DF54$ZTE3ANNQ8M07255,843C991F71F5,843C991F71F6,ZTEGD7BA63C4$ZTE3ANNRAD32004,D89A0DB0C87B,D89A0DB0C87C,ZTEGDB17790F$ZTE3ANNQ7503240,C4EBFF8B3F2C,C4EBFF8B3F2D,ZTEGD70A5B48$ZTE3ANNRAM35399,5872C98A75E3,5872C98A75E4,ZTEGDC608A46$ZTE3ANNR8C24244,38914850BF3F,38914850BF40,ZTEGDB08DF24$ZTE3ANNQ9334530,843C9935BE89,843C9935BE8A,ZTEGD7BC42D9', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-07 16:20:29 Duration: 6s559ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (44827, 418, 'ZTE3ANNRCB66767,D8313923EBD8,D8313923EBD9,ZTEGDD2ABA64$ZTE3ANNR5W14504,48D6822FD7BA,48D6822FD7BB,ZTEGDB0038A7$ZTE3ANNR9F36715,D89A0DA63A65,D89A0DA63A66,ZTEGDB15B6B6$ZTE3ANNT4P16619,F00C514D2C20,F00C514D2C21,ZTEGDE343781$ZTE3ANNQCA03505,14CA56D29701,14CA56D29702,ZTEGD971731C$ZTE3ANNRCB61254,D83139236AA2,D83139236AA3,ZTEGDD2AA4DB$ZTE3ANNR9325443,D89A0D84B45D,D89A0D84B45E,ZTEGDB14D762$ZTE3ANNT2V84818,D831399352C4,D831399352C5,ZTEGDD313DD1$ZTE3ANNR8C25888,38914850E5C7,38914850E5C8,ZTEGDB08E590$ZTE3ANNR6R27788,48D68238100A,48D68238100B,ZTEGDB01975F$ZTE3ANNR9F17014,D89A0DA46CA7,D89A0DA46CA8,ZTEGDB1569C1$ZTE3ANNR3J05788,F4E84F86D608,F4E84F86D609,ZTEGD97B7866$ZTE3ANNRC560194,6C11BA67ACA3,6C11BA67ACA4,ZTEGDC6F00E1$ZTE3ANNR3J30280,F4E84F891410,F4E84F891411,ZTEGD97BD812$ZTE3ANNR9F18286,D89A0DA48A77,D89A0DA48A78,ZTEGDB156EB9$ZTE3ANNR5W76324,48D6823580A2,48D6823580A3,ZTEGDB012A23$ZTE3ANNR4N17708,4896D956FA20,4896D956FA21,ZTEGD97F64F1$ZTE3ANNR3Y01691,4896D94FE85A,4896D94FE85B,ZTEGD97E3750$ZTE3ANNRC575711,6C11BA691851,6C11BA691852,ZTEGDC6F3D7E$ZTE3ANNRCB63595,D8313923A180,D8313923A181,ZTEGDD2AAE00$ZTE3ANNR1Y08072,14CA56CD67AB,14CA56CD67AC,ZTEGD97095E3$ZTE3ANNR3J07047,F4E84F86F38A,F4E84F86F38B,ZTEGD97B7D51$ZTE3ANNRCB23954,D8313920006A,D8313920006B,ZTEGDD2A1327$ZTE3ANNR5W13231,48D6822FB9E4,48D6822FB9E5,ZTEGDB0033AE$ZTE3ANNRCP03776,6C11BA69834F,6C11BA698350,ZTEGDC6F4F53$ZTE3ANNQ7913825,C4EBFF8D6216,C4EBFF8D6217,ZTEGD70AB66F$ZTE3ANNQ9306654,843C99333131,843C99333132,ZTEGD7BBD5F5$ZTE3ANNRC575098,6C11BA6909F3,6C11BA6909F4,ZTEGDC6F3B19$ZTE3ANNRCB63506,D83139239F6A,D83139239F6B,ZTEGDD2AADA7$ZTE3ANNR9W03905,D89A0DA8B7A9,D89A0DA8B7AA,ZTEGDB1620EC$ZTE3ANNT2V84668,D83139934F40,D83139934F41,ZTEGDD313D3B$ZTE3ANNT4P14192,F00C514CF33E,F00C514CF33F,ZTEGDE342E06$ZTE3ANNT2V13493,D831398CCB16,D831398CCB17,ZTEGDD302734$ZTE3ANNR7B32179,3891484BDED9,3891484BDEDA,ZTEGDB080F13$ZTE3ANNRC565289,6C11BA68240D,6C11BA68240E,ZTEGDC6F14C8$ZTE3ANNRC552219,6C11BA66F1B9,6C11BA66F1BA,ZTEGDC6EE1BA$ZTE3ANNR9W44466,D89A0DAC6E4F,D89A0DAC6E50,ZTEGDB16BF5D$ZTE3ANNRCB72508,D83139247266,D83139247267,ZTEGDD2AD0D1$ZTE3ANNRAD20893,D89A0DAFC411,D89A0DAFC412,ZTEGDB174DA8$ZTE3ANNR9W44728,D89A0DAC7473,D89A0DAC7474,ZTEGDB16C063$ZTE3ANNT3J12649,D83139A113C8,D83139A113C9,ZTEGDD3388A7', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-07 15:37:21 Duration: 5s509ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (44779, 407, '270911020033105272,229784727878,229670624162,229749891629,229740274764,229865173654,229865385773,229745804563,229669714062,229933915772,229815885970,229784229009,229745810827,229784139808,229859601629,229782345368,229669005272,229782932934,229808863658,229665133940,229689058889,216932466781,229691632026,229669108087,229689434460,229816886382,229781783944,216944515353,229837217479,229809223244,229816654463', '246586642039,246514192241,246562977091,246558989306,246649804050,246649734346,246548537982,246515568402,226407785065,246630211723,246586853653,246550251529,246588434256,246641593451,246596049208,246515698391,246597909917,246612976875,246472207076,246516706885,246433329601,246506365371,246514472829,246285156565,246628233954,246598585067,246461409401,246640726183,246627571937,246628335254,,,,,,,,', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-07 10:55:25 Duration: 5s272ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
20 156ms 3s714ms 671ms 149 1m39s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 07 07 9 5s608ms 623ms 08 18 15s8ms 833ms 09 15 8s231ms 548ms 10 14 9s556ms 682ms 11 12 8s257ms 688ms 12 2 2s232ms 1s116ms 13 13 8s558ms 658ms 14 17 11s912ms 700ms 15 17 15s59ms 885ms 16 27 11s373ms 421ms 17 5 4s188ms 837ms [ User: intelifix - Total duration: 1m39s - Times executed: 149 ]
[ Application: [unknown] - Total duration: 1m39s - Times executed: 149 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0126995) LIMIT 1;
Date: 2026-07-07 15:16:57 Duration: 3s714ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0126995) LIMIT 1;
Date: 2026-07-07 11:31:29 Duration: 2s790ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0126760) LIMIT 1;
Date: 2026-07-07 15:04:23 Duration: 2s767ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-07.log
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 9 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 07 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 17 1 0ms 0ms 20 2 0ms 0ms 21 2 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 3m41s - Times executed: 8 ]
[ User: lenon - Total duration: 538ms - Times executed: 1 ]
[ Application: psql - Total duration: 3m36s - Times executed: 5 ]
[ Application: [unknown] - Total duration: 5s924ms - Times executed: 4 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 18,423 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 16 FATAL entries
- 4422 ERROR entries
- 0 WARNING entries
- 3 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,296 Max number of times the same event was reported
- 4,441 Total events found
Rank Times reported Error 1 4,296 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 07 00 59 01 60 02 60 03 55 04 60 05 59 06 60 07 200 08 321 09 444 10 432 11 380 12 253 13 137 14 288 15 401 16 174 17 142 18 119 19 119 20 119 21 120 22 118 23 116 - ERROR: prepared statement "_PLAN0000000029F73EA0" does not exist
- ERROR: prepared statement "_PLAN0000000029C3F240" does not exist
- ERROR: prepared statement "_PLAN0000000029C43220" does not exist
Statement: DEALLOCATE "_PLAN0000000029F73EA0"
Date: 2026-07-07 00:00:28 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
Statement: DEALLOCATE "_PLAN0000000029C3F240"
Date: 2026-07-07 00:01:29 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
Statement: DEALLOCATE "_PLAN0000000029C43220"
Date: 2026-07-07 00:02:29 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
2 45 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 07 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 1 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-07 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.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-07-07 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.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-07-07 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
3 43 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 07 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 2 20 2 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-07 08:00:09 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-07 08:20:05 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-07 08:40:03 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
4 14 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 07 07 6 09 3 10 3 15 2 - ERROR: trailing junk after numeric literal at or near "7D" at character 42
- ERROR: trailing junk after numeric literal at or near "7D" at character 42
- ERROR: trailing junk after numeric literal at or near "7D" at character 42
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-9E-85-7D)
Date: 2026-07-07 07:06:25 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-9E-85-7D)
Date: 2026-07-07 07:06:25 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-9E-85-7D)
Date: 2026-07-07 07:06:25 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
5 10 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 07 07 3 12 2 15 3 17 2 - ERROR: column "dc" does not exist at character 27
- ERROR: column "dc" does not exist at character 27
- ERROR: column "dc" does not exist at character 27
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-93-B6-AB)
Date: 2026-07-07 07:03:13 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-93-B6-AB)
Date: 2026-07-07 07:03:13 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-93-B6-AB)
Date: 2026-07-07 07:03:13 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
6 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 07 03 9 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-07 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
Date: 2026-07-07 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
Date: 2026-07-07 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
7 7 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 07 08 3 09 4 - ERROR: syntax error at or near ":" at character 29
- ERROR: syntax error at or near ":" at character 29
- ERROR: syntax error at or near ":" at character 29
Statement: SELECT * FROM RS_ETIQUETA(DC:97:E6:8A:5E:D7)
Date: 2026-07-07 08:57:28 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
Statement: SELECT * FROM RS_ETIQUETA(DC:97:E6:8A:5E:D7)
Date: 2026-07-07 08:57:28 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
Statement: SELECT * FROM RS_ETIQUETA(DC:97:E6:8A:5E:D7)
Date: 2026-07-07 08:57:28 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
8 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 07 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-07 05:32:10 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-07 05:32:10 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-07 05:32:10 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
9 4 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 07 00 1 05 1 06 1 17 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-07-07 00:02:07 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
Date: 2026-07-07 05:35:20 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
Date: 2026-07-07 06:02:07 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
10 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 07 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-07-07 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
Date: 2026-07-07 03:05:02 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
Date: 2026-07-07 03:05:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
11 2 ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(...) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(...) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(...) line 48 at assignment
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 07 19 1 20 1 - ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
- ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-07 19:40:03 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-07 20:00:03 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
12 2 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 07 07 2 - LOG: process 2460208 still waiting for ShareLock on transaction 2238634 after 1000.128 ms
- LOG: process 2460208 still waiting for ShareLock on transaction 2238634 after 8958.060 ms
Detail: Process holding the lock: 2462287. Wait queue: 2460208.
Context: while updating tuple (72734,75) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-07 07:45:05 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
Detail: Process holding the lock: 2462287. Wait queue: 2460208.
Context: while updating tuple (72734,75) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-07 07:45:13 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
13 1 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "...", line 21, in <module> os.chmod(...) PL/Python function "..." PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Times Reported Most Frequent Error / Event #13
Day Hour Count Jul 07 20 1 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' 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
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-07 20:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-07.log
14 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #14
Day Hour Count Jul 07 03 1 - LOG: database system was shut down at 2026-07-07 03:05:02 -03
Date: 2026-07-07 03:05:03 Log file: /usr/local/pgsql/data/log/serverlog-07.log