pgBadger-
Global information
- Generated on Sun Jun 28 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 22,208 log entries in 8s
- Log start from 2026-06-27 00:00:46 to 2026-06-27 23:59:38
-
Overview
Global Stats
- 226 Number of unique normalized queries
- 2,433 Number of queries
- 6h2m52s Total query duration
- 2026-06-27 00:02:33 First query
- 2026-06-27 23:53:00 Last query
- 6 queries/s at 2026-06-27 10:25:05 Query peak
- 6h2m52s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 6h2m52s Execute total duration
- 3,242 Number of events
- 12 Number of unique normalized events
- 3,123 Max number of times the same event was reported
- 0 Number of cancellation
- 111 Total number of automatic vacuums
- 266 Total number of automatic analyzes
- 14 Number temporary file
- 232.38 MiB Max size of temporary file
- 106.90 MiB Average size of temporary file
- 250 Total number of sessions
- 6 sessions at 2026-06-27 13:14:34 Session peak
- 9d13h32m17s Total duration of sessions
- 55m5s Average duration of sessions
- 9 Average queries per session
- 1m27s Average queries duration per session
- 53m38s Average idle time per session
- 255 Total number of connections
- 4 connections/s at 2026-06-27 23:45:02 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-06-27 10:25:05 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-27 10:25:05 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-27 23:52:21 Date
Queries duration
Key values
- 6h2m52s 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) Jun 27 00 26 0ms 31s955ms 5s481ms 5s111ms 6s525ms 1m18s 01 23 0ms 3s687ms 1s355ms 3s729ms 4s773ms 5s391ms 02 12 0ms 3s591ms 2s244ms 3s497ms 4s191ms 6s351ms 03 19 0ms 4s520ms 1s774ms 4s96ms 5s901ms 7s364ms 04 27 0ms 4s34ms 1s371ms 4s437ms 6s204ms 6s526ms 05 21 0ms 8m32s 50s99ms 9s309ms 2m30s 8m32s 06 32 0ms 26s39ms 3s730ms 10s631ms 12s261ms 32s368ms 07 185 0ms 7m27s 5s521ms 18s907ms 1m31s 7m33s 08 340 150ms 5m52s 6s454ms 56s370ms 6m36s 8m22s 09 335 0ms 6m54s 5s631ms 1m13s 4m16s 6m56s 10 423 150ms 11m39s 7s448ms 4m1s 5m17s 11m44s 11 342 0ms 7m27s 5s700ms 58s708ms 3m47s 7m28s 12 66 0ms 6m54s 14s120ms 26s172ms 1m32s 6m55s 13 28 0ms 5m33s 21s782ms 3s926ms 44s799ms 5m33s 14 21 0ms 5m41s 29s728ms 3s629ms 42s762ms 5m41s 15 15 0ms 5m42s 41s522ms 2s978ms 45s211ms 5m42s 16 17 0ms 5m31s 35s271ms 3s559ms 46s207ms 5m31s 17 16 0ms 5m30s 37s798ms 3s669ms 46s886ms 5m30s 18 17 0ms 5m46s 35s942ms 3s680ms 43s259ms 5m46s 19 17 0ms 5m28s 35s10ms 3s722ms 15s17ms 5m57s 20 103 0ms 7m2s 12s677ms 1m6s 2m23s 7m45s 21 19 0ms 5m22s 30s632ms 3s983ms 14s515ms 5m50s 22 17 0ms 5m31s 35s551ms 3s459ms 44s151ms 5m31s 23 312 0ms 1m35s 7s806ms 1m10s 1m35s 1m37s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 27 00 8 0 4s628ms 0ms 0ms 1s132ms 01 10 0 412ms 0ms 231ms 1s102ms 02 0 0 0ms 0ms 0ms 0ms 03 3 0 374ms 0ms 0ms 195ms 04 14 0 332ms 267ms 323ms 467ms 05 5 0 362ms 0ms 0ms 661ms 06 15 0 2s373ms 0ms 205ms 1s628ms 07 149 0 5s667ms 2s842ms 4s552ms 3m46s 08 267 0 6s876ms 8s102ms 56s207ms 6m52s 09 264 0 5s877ms 7s329ms 1m 4m20s 10 334 0 8s308ms 31s129ms 4m1s 6m58s 11 259 0 6s627ms 31s885ms 58s708ms 4m43s 12 53 0 16s888ms 1s679ms 26s172ms 3m34s 13 15 0 38s893ms 0ms 854ms 3m15s 14 12 0 50s140ms 0ms 3s325ms 3m23s 15 6 0 1m40s 0ms 0ms 3m33s 16 6 0 1m35s 0ms 0ms 3m17s 17 6 0 1m36s 0ms 0ms 3m22s 18 8 0 1m13s 0ms 0ms 3m17s 19 6 0 1m35s 0ms 0ms 3m17s 20 10 82 13s891ms 19s101ms 1m3s 3m41s 21 7 0 1m19s 0ms 0ms 3m11s 22 6 0 1m36s 0ms 0ms 3m25s 23 10 302 7s806ms 1m5s 1m10s 1m35s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 27 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 Jun 27 00 0 1 1.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 1 1.00 0.00% 05 0 2 2.00 0.00% 06 0 5 5.00 0.00% 07 0 8 8.00 0.00% 08 0 10 10.00 0.00% 09 0 10 10.00 0.00% 10 0 11 11.00 0.00% 11 0 8 8.00 0.00% 12 0 5 5.00 0.00% 13 0 2 2.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Jun 27 00 14 0.00/s 01 7 0.00/s 02 8 0.00/s 03 17 0.00/s 04 7 0.00/s 05 12 0.00/s 06 15 0.00/s 07 15 0.00/s 08 13 0.00/s 09 16 0.00/s 10 15 0.00/s 11 15 0.00/s 12 13 0.00/s 13 9 0.00/s 14 7 0.00/s 15 8 0.00/s 16 7 0.00/s 17 7 0.00/s 18 8 0.00/s 19 7 0.00/s 20 10 0.00/s 21 7 0.00/s 22 7 0.00/s 23 11 0.00/s Day Hour Count Average Duration Average idle time Jun 27 00 8 1h1m7s 1h49s 01 13 1h1m9s 1h1m6s 02 7 1h26s 1h22s 03 16 22m9s 22m7s 04 9 1h2m40s 1h2m36s 05 8 54m8s 51m56s 06 11 58m56s 58m45s 07 14 1h51s 59m38s 08 16 50m32s 48m15s 09 11 57m40s 54m48s 10 17 57m47s 54m42s 11 14 53m45s 51m26s 12 15 57m34s 56m32s 13 13 57m 56m13s 14 8 1h 58m42s 15 7 1h49s 59m20s 16 8 57m15s 56m 17 7 1h47s 59m21s 18 7 1h4s 58m36s 19 8 1h22s 59m8s 20 10 43m41s 41m30s 21 7 1h25s 59m2s 22 7 1h48s 59m21s 23 9 50m12s 45m41s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-06-27 23:45:02 Date
Connections per database
Key values
- rio Main Database
- 255 connections Total
Connections per user
Key values
- intelifix Main User
- 255 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2026-06-27 13:14:34 Date
Histogram of session times
Key values
- 212 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 250 sessions Total
Sessions per user
Key values
- intelifix Main User
- 250 sessions Total
Sessions per host
Key values
- [local] Main Host
- 250 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 13,818 buffers Checkpoint Peak
- 2026-06-27 08:39:38 Date
- 270.073 seconds Highest write time
- 0.085 seconds Sync time
Checkpoints Wal files
Key values
- 8 files Wal files usage Peak
- 2026-06-27 08:34:38 Date
Checkpoints distance
Key values
- 258.71 Mo Distance Peak
- 2026-06-27 08:34:38 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 27 00 20,792 672.49s 0.111s 672.661s 01 2,282 229.687s 0.074s 229.847s 02 1,108 111.436s 0.04s 111.503s 03 1,451 145.887s 0.07s 146.008s 04 4,696 471.522s 0.09s 471.683s 05 8,396 840.389s 0.114s 840.572s 06 14,158 1,138.33s 0.081s 1,138.487s 07 21,479 1,956.519s 0.297s 1,956.963s 08 65,299 3,060.92s 0.377s 3,061.472s 09 56,651 3,212.045s 0.488s 3,212.696s 10 94,429 3,172.76s 0.527s 3,173.508s 11 35,806 2,839.972s 0.381s 2,840.498s 12 5,188 522.435s 0.099s 522.604s 13 931 93.562s 0.025s 93.632s 14 1,652 165.823s 0.022s 165.887s 15 21 2.128s 0.003s 2.135s 16 21 2.128s 0.003s 2.138s 17 21 2.131s 0.003s 2.14s 18 569 57.145s 0.005s 57.162s 19 21 2.128s 0.002s 2.135s 20 1,015 166.242s 0.019s 166.281s 21 479 48.15s 0.012s 48.193s 22 27 2.754s 0.004s 2.77s 23 593 91.562s 0.014s 91.612s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 27 00 0 0 7 521 0.030s 0.007s 01 0 0 1 570 0.008s 0.01s 02 0 0 0 305 0.007s 0.004s 03 0 0 1 357 0.008s 0.008s 04 0 0 1 752 0.009s 0.01s 05 0 0 4 590 0.012s 0.009s 06 0 0 4 727 0.007s 0.009s 07 0 0 7 2,430 0.019s 0.012s 08 0 0 36 4,018 0.016s 0.012s 09 0 0 29 3,907 0.032s 0.012s 10 0 0 52 4,477 0.014s 0.012s 11 0 0 20 3,982 0.016s 0.012s 12 0 0 2 1,124 0.005s 0.008s 13 0 0 0 161 0.003s 0.008s 14 0 0 1 124 0.003s 0.007s 15 0 0 0 3 0.002s 0.001s 16 0 0 0 3 0.002s 0.001s 17 0 0 0 3 0.002s 0.001s 18 0 0 0 47 0.002s 0.002s 19 0 0 0 3 0.002s 0.001s 20 0 0 0 52 0.004s 0.003s 21 0 0 1 46 0.003s 0.005s 22 0 0 0 6 0.002s 0.002s 23 0 0 2 90 0.003s 0.005s Day Hour Count Avg time (sec) Jun 27 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 Jun 27 00 16,057.29 kB 53,237.71 kB 01 1,243.33 kB 26,834.22 kB 02 1,415.75 kB 13,780.25 kB 03 1,162.43 kB 2,887.57 kB 04 2,327.20 kB 3,025.40 kB 05 6,680.11 kB 15,516.56 kB 06 6,810.11 kB 10,877.00 kB 07 10,529.17 kB 17,795.67 kB 08 48,689.42 kB 85,884.75 kB 09 39,792.75 kB 88,886.00 kB 10 70,333.92 kB 105,837.92 kB 11 28,243.42 kB 81,184.00 kB 12 3,329.88 kB 35,174.75 kB 13 556.14 kB 16,500.71 kB 14 998.57 kB 8,330.14 kB 15 166.00 kB 5,580.00 kB 16 165.00 kB 5,038.00 kB 17 165.00 kB 4,551.00 kB 18 1,075.00 kB 4,085.00 kB 19 165.00 kB 3,510.00 kB 20 3,227.33 kB 6,915.67 kB 21 359.00 kB 4,958.75 kB 22 97.00 kB 3,640.50 kB 23 7,307.40 kB 24,242.20 kB -
Temporary Files
Size of temporary files
Key values
- 464.77 MiB Temp Files size Peak
- 2026-06-27 05:31:58 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-06-27 05:31:58 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jun 27 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.06 MiB 06 0 0 0 07 0 0 0 08 1 104.00 MiB 104.00 MiB 09 1 104.00 MiB 104.00 MiB 10 1 104.00 MiB 104.00 MiB 11 1 104.00 MiB 104.00 MiB 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 902.74 MiB 69.31 MiB 232.38 MiB 112.84 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-27 05:32:05 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-27 05:31:58 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 416.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( 026301, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-06-27 10:52:55 Duration: 11m39s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026285, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-27 08:15:38 Duration: 4m46s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026303, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-27 11:07:51 Duration: 4m41s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
3 2 177.84 MiB 88.92 MiB 88.92 MiB 88.92 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-27 05:30:41 Duration: 39s518ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-27 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 232.38 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-27 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 232.38 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-27 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,508,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-27 10:36:03 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,504,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-27 11:22:08 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,404,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-27 08:30:12 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,508,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-06-27 09:48:35 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 88.92 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-06-27 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 88.92 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-06-27 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 76.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-27 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 76.63 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-27 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 76.62 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-27 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 69.39 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-27 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 69.32 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-27 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 69.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-06-27 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 2.00 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database brasilia - 2026-06-27 11:25:58 Date
- 0 sec Highest CPU-cost analyze
Table
Database brasilia - Date
Average Autovacuum Duration
Key values
- 2.00 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database brasilia - 2026-06-27 11:25:58 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (40) Main table analyzed (database rio)
- 266 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 40 rio.pg_catalog.pg_class 20 rio.public.temp0000283816 19 rio.public.usuarios 18 rio.pg_catalog.pg_type 17 rio.public.temp0000283826 14 rio.public.temp0000283810 11 rio.public.temp0000283178 11 rio.pg_catalog.pg_index 10 rio.public.temp0000283290 9 rio.public.temp0000283784 9 brasilia.pg_catalog.pg_attribute 9 rio.public.temp0000283788 8 rio.pg_catalog.pg_depend 8 rio.public.temp0000283790 8 rio.public.temp0000283808 7 rio.public.temp0000283572 6 rio.public.temp0000283794 5 brasilia.public.usuarios 5 brasilia.public.temp0000234824 4 rio.public.temp0000283796 4 brasilia.pg_catalog.pg_class 4 rio.public.temp0000281789 3 brasilia.pg_catalog.pg_type 3 brasilia.pg_catalog.pg_index 2 rio.public.temp0000283840 1 rio.public.temp0000283804 1 brasilia.pg_catalog.pg_depend 1 rio.public.temp0000283800 1 rio.public.temp0000283802 1 brasilia.public.temp0000234816 1 rio.public.temp0000283420 1 brasilia.auditor.auditor_2026_06 1 brasilia.public.temp0000234828 1 postgres.pg_catalog.pg_shdepend 1 rio.pg_catalog.pg_shdepend 1 rio.public.temp0000283818 1 Total 266 Vacuums per table
Key values
- public.temp0000283816 (19) Main table vacuumed on database rio
- 111 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000283816 19 0 0 0 0 0 0 21,672 85 1,292,164 0 0 rio.pg_catalog.pg_attribute 13 13 0 0 0 0 0 6,279 1,985 2,809,750 119 2,892 rio.public.temp0000283178 11 0 0 0 0 0 0 450 194 261,505 0 0 rio.public.temp0000283810 10 0 0 0 0 0 0 12,906 38 767,354 0 0 rio.public.temp0000283808 7 0 0 0 0 0 0 520 40 36,534 0 0 rio.pg_catalog.pg_class 7 7 0 0 0 0 0 1,253 466 707,568 19 66 rio.public.temp0000283572 5 0 0 0 0 0 0 368 26 25,923 0 0 rio.pg_catalog.pg_type 5 5 0 0 0 0 0 458 142 205,137 18 48 rio.pg_catalog.pg_index 4 4 0 0 0 0 0 326 106 76,068 23 42 brasilia.pg_catalog.pg_attribute 3 3 0 0 0 0 0 1,441 461 622,528 6 162 rio.public.temp0000283796 3 0 0 0 0 0 0 3,232 13 192,835 0 0 rio.pg_catalog.pg_statistic 3 3 0 0 0 0 0 5,131 968 4,372,886 549 2,957 rio.pg_catalog.pg_depend 3 3 0 0 0 0 0 1,271 489 680,454 20 156 rio.public.temp0000281789 3 0 0 0 0 0 0 157 17 11,818 0 0 rio.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 1,374 268 1,615,469 122 452 brasilia.pg_catalog.pg_class 1 1 0 0 0 0 0 135 64 102,777 4 7 postgres.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 189 71 93,577 9 23 rio.public.temp0000283818 1 0 0 0 0 0 0 140 6 9,279 0 0 brasilia.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 159 27 107,746 10 24 brasilia.auditor.auditor_2026_06 1 0 0 0 0 0 0 9,744 6,156 7,692,576 1,789 31,662 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 143 57 182,892 26 66 rio.public.temp0000283420 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000283802 1 0 0 0 0 0 0 143 6 9,467 0 0 brasilia.pg_catalog.pg_type 1 1 0 0 0 0 0 48 20 26,225 2 4 rio.public.temp0000283800 1 0 0 0 0 0 0 1,612 4 95,711 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,364 1,047 3,206,050 1,005 7,263 rio.public.temp0000283804 1 0 0 0 0 0 0 140 6 9,283 0 0 brasilia.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,688 210 712,543 193 1,228 Total 111 47 0 0 0 0 0 74,347 12,975 25,926,893 3,914 47,052 Vacuum throughput per table
Key values
- auditor.auditor_2026_06 (2) Max CPU elapsed for vacuum on database brasilia
- unknown (0 ms) Max I/O read time for vacuum on database brasilia
- unknown (0 ms) Max I/O write time for vacuum on database brasilia
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000283816 0 0 0.83 rio.pg_catalog.pg_attribute 0 0 1.12 rio.public.temp0000283178 0 0 0.15 rio.public.temp0000283810 0 0 0.52 rio.public.temp0000283808 0 0 0.11 rio.pg_catalog.pg_class 0 0 0.27 rio.public.temp0000283572 0 0 0.04 rio.pg_catalog.pg_type 0 0 0.05 rio.pg_catalog.pg_index 0 0 0.09 brasilia.pg_catalog.pg_attribute 0 0 0.27 rio.public.temp0000283796 0 0 0.12 rio.pg_catalog.pg_statistic 0 0 0.65 rio.pg_catalog.pg_depend 0 0 0.28 rio.public.temp0000281789 0 0 0.04 rio.pg_toast.pg_toast_2619 0 0 0.13 brasilia.pg_catalog.pg_class 0 0 0.05 postgres.pg_catalog.pg_shdepend 0 0 0.07 rio.public.temp0000283818 0 0 0.02 brasilia.pg_toast.pg_toast_2619 0 0 0 brasilia.auditor.auditor_2026_06 0 0 2 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000283420 0 0 0.04 rio.public.temp0000283802 0 0 0.01 brasilia.pg_catalog.pg_type 0 0 0.02 rio.public.temp0000283800 0 0 0.05 contagem.pg_catalog.pg_statistic 0 0 0.11 rio.public.temp0000283804 0 0 0.01 brasilia.pg_catalog.pg_statistic 0 0 0.16 Total 0 0 7.21 Tuples removed per table
Key values
- pg_catalog.pg_attribute (43594) Main table with removed tuples on database rio
- 79332 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 13 13 43,594 305,349 3,970 0 7,278 brasilia.pg_catalog.pg_attribute 3 3 9,798 61,861 0 31 1,624 rio.pg_catalog.pg_statistic 3 3 7,196 23,552 51 0 3,858 contagem.pg_catalog.pg_statistic 1 1 4,308 7,274 0 0 1,011 brasilia.pg_catalog.pg_statistic 1 1 3,999 7,318 0 0 1,072 rio.pg_catalog.pg_depend 3 3 3,094 57,156 150 0 543 rio.pg_catalog.pg_type 5 5 1,633 11,253 6 0 345 brasilia.auditor.auditor_2026_06 1 0 1,545 871,797 0 0 39,054 rio.pg_catalog.pg_class 7 7 1,110 24,601 664 11 779 rio.pg_toast.pg_toast_2619 2 2 936 1,437 0 0 582 rio.pg_catalog.pg_index 4 4 916 7,767 157 0 236 postgres.pg_catalog.pg_shdepend 1 1 749 13,533 0 0 115 brasilia.pg_catalog.pg_class 1 1 119 3,326 0 0 114 brasilia.pg_toast.pg_toast_2619 1 1 119 133 0 0 63 contagem.pg_toast.pg_toast_2619 1 1 114 115 0 0 54 brasilia.pg_catalog.pg_type 1 1 102 2,183 0 0 57 rio.public.temp0000283808 7 0 0 18,132 0 171 469 rio.public.temp0000283818 1 0 0 2,644 0 60 132 rio.public.temp0000283178 11 0 0 34,661 0 390 762 rio.public.temp0000283572 5 0 0 11,693 0 128 448 rio.public.temp0000283420 1 0 0 22,666 0 0 1,664 rio.public.temp0000283802 1 0 0 2,661 0 57 135 rio.public.temp0000283800 1 0 0 22,669 0 0 1,664 rio.public.temp0000283796 3 0 0 47,992 0 60 3,460 rio.public.temp0000281789 3 0 0 9,864 0 104 216 rio.public.temp0000283810 10 0 0 226,745 0 0 16,640 rio.public.temp0000283816 19 0 0 330,710 0 288 23,968 rio.public.temp0000283804 1 0 0 2,644 0 60 132 Total 111 47 79,332 2,131,736 4,998 1,360 106,475 Pages removed per table
Key values
- public.temp0000283178 (390) Main table with removed pages on database rio
- 1360 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000283178 11 0 0 390 rio.public.temp0000283816 19 0 0 288 rio.public.temp0000283808 7 0 0 171 rio.public.temp0000283572 5 0 0 128 rio.public.temp0000281789 3 0 0 104 rio.public.temp0000283818 1 0 0 60 rio.public.temp0000283796 3 0 0 60 rio.public.temp0000283804 1 0 0 60 rio.public.temp0000283802 1 0 0 57 brasilia.pg_catalog.pg_attribute 3 3 9798 31 rio.pg_catalog.pg_class 7 7 1110 11 brasilia.pg_catalog.pg_class 1 1 119 0 postgres.pg_catalog.pg_shdepend 1 1 749 0 brasilia.pg_toast.pg_toast_2619 1 1 119 0 rio.pg_catalog.pg_attribute 13 13 43594 0 brasilia.auditor.auditor_2026_06 1 0 1545 0 contagem.pg_toast.pg_toast_2619 1 1 114 0 rio.public.temp0000283420 1 0 0 0 brasilia.pg_catalog.pg_type 1 1 102 0 rio.public.temp0000283800 1 0 0 0 contagem.pg_catalog.pg_statistic 1 1 4308 0 rio.pg_toast.pg_toast_2619 2 2 936 0 rio.pg_catalog.pg_statistic 3 3 7196 0 rio.pg_catalog.pg_depend 3 3 3094 0 rio.pg_catalog.pg_index 4 4 916 0 rio.pg_catalog.pg_type 5 5 1633 0 rio.public.temp0000283810 10 0 0 0 brasilia.pg_catalog.pg_statistic 1 1 3999 0 Total 111 47 79,332 1,360 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 27 00 0 1 01 0 2 02 0 0 03 0 1 04 0 5 05 6 1 06 0 0 07 10 19 08 28 50 09 23 60 10 22 70 11 19 48 12 2 7 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 1 2 22 0 0 23 0 0 - 2.00 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 16s959ms 16s959ms 16s959ms 16s959ms call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-27 10:05:27 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-27 00:05:24 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-27 20:15:07 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
Queries that waited the most
Rank Wait time Query 1 16s959ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-27 10:05:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Queries
Queries by type
Key values
- 1,473 Total read queries
- 635 Total write queries
Queries by database
Key values
- rio Main database
- 1,831 Requests
- 4h36m51s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 2,359 Requests
User Request type Count Duration etiquetas Total 22 4s518ms select 22 4s518ms intelifix Total 2,359 6h1m20s copy to 384 50m3s ddl 251 17m42s others 325 34m16s select 1,399 4h19m18s lenon Total 52 1m27s select 52 1m27s Duration by user
Key values
- 6h1m20s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 22 4s518ms select 22 4s518ms intelifix Total 2,359 6h1m20s copy to 384 50m3s ddl 251 17m42s others 325 34m16s select 1,399 4h19m18s lenon Total 52 1m27s select 52 1m27s Queries by host
Key values
- [local] Main host
- 2,433 Requests
- 6h2m52s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 1,577 Requests
- 3h24m41s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-27 08:55:25 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,092 100-500ms duration
Slowest individual queries
Rank Duration Query 1 11m39s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026301, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-06-27 10:52:55 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 8m32s analyze verbose;[ Date: 2026-06-27 05:08:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-27 07:12:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 7m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-27 11:12:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 7m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-27 20:12:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-27 12:11:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-27 09:11:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-27 10:11:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-27 08:10:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-27 18:10:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-27 15:10:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-27 14:10:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-27 13:10:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-27 16:10:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-27 22:10:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-27 17:10:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-27 19:10:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-27 21:10:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 4m46s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026285, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-27 08:15:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 4m41s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026303, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-06-27 11:07:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h43m21s 48 1s347ms 7m27s 2m9s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 27 07 3 8m1s 2m40s 08 3 6m9s 2m3s 09 3 7m14s 2m24s 10 3 6m37s 2m12s 11 3 7m56s 2m38s 12 3 7m22s 2m27s 13 3 5m50s 1m56s 14 3 5m57s 1m59s 15 3 5m59s 1m59s 16 3 5m48s 1m56s 17 3 5m46s 1m55s 18 3 6m1s 2m 19 3 5m44s 1m54s 20 3 7m24s 2m28s 21 3 5m38s 1m52s 22 3 5m47s 1m55s [ User: intelifix - Total duration: 1h43m21s - Times executed: 48 ]
[ Application: psql - Total duration: 1h43m21s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-27 07:12:29 Duration: 7m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-27 11:12:28 Duration: 7m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-27 20:12:04 Duration: 7m2s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
2 1h4m36s 48 175ms 3m54s 1m20s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 27 07 3 4m34s 1m31s 08 3 3m55s 1m18s 09 3 4m20s 1m26s 10 3 4m34s 1m31s 11 3 4m28s 1m29s 12 3 4m10s 1m23s 13 3 3m43s 1m14s 14 3 3m44s 1m14s 15 3 4m2s 1m20s 16 3 3m46s 1m15s 17 3 3m53s 1m17s 18 3 3m44s 1m14s 19 3 3m45s 1m15s 20 3 4m21s 1m27s 21 3 3m37s 1m12s 22 3 3m53s 1m17s [ User: intelifix - Total duration: 1h4m36s - Times executed: 48 ]
[ Application: psql - Total duration: 1h4m36s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-27 10:16:11 Duration: 3m54s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-27 11:17:21 Duration: 3m41s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-27 07:17:32 Duration: 3m40s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
3 1h1m9s 61 155ms 11m39s 1m select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 27 07 2 13s653ms 6s826ms 08 11 17m22s 1m34s 09 12 9m33s 47s821ms 10 19 26m27s 1m23s 11 7 7m4s 1m 12 1 1s299ms 1s299ms 13 3 6s231ms 2s77ms 14 6 20s425ms 3s404ms [ User: intelifix - Total duration: 1h1m9s - Times executed: 61 ]
[ Application: [unknown] - Total duration: 1h1m9s - Times executed: 61 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026301, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-06-27 10:52:55 Duration: 11m39s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026285, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-27 08:15:38 Duration: 4m46s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026303, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-27 11:07:51 Duration: 4m41s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
4 16m3s 53 1s402ms 54s96ms 18s175ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 27 08 4 25s120ms 6s280ms 09 5 24s4ms 4s800ms 10 18 5m24s 18s37ms 11 20 7m9s 21s484ms 12 6 2m39s 26s636ms [ User: intelifix - Total duration: 16m3s - Times executed: 53 ]
[ Application: [unknown] - Total duration: 16m3s - Times executed: 53 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-27', 0366, '', '', 0, 6, '2026-06-01');
Date: 2026-06-27 10:25:14 Duration: 54s96ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-27', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-27 11:31:16 Duration: 31s472ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-27', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-27 11:33:02 Duration: 31s413ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
5 14m56s 3 2m30s 8m32s 4m58s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 27 05 3 14m56s 4m58s [ User: intelifix - Total duration: 14m56s - Times executed: 3 ]
[ Application: psql - Total duration: 14m56s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-27 05:08:33 Duration: 8m32s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
analyze verbose;
Date: 2026-06-27 05:12:27 Duration: 3m53s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
analyze verbose;
Date: 2026-06-27 05:14:57 Duration: 2m30s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
6 9m1s 171 150ms 21s169ms 3s167ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 27 00 8 27s336ms 3s417ms 01 7 19s883ms 2s840ms 02 8 20s859ms 2s607ms 03 9 24s369ms 2s707ms 04 7 21s898ms 3s128ms 05 7 22s870ms 3s267ms 06 7 20s584ms 2s940ms 07 7 25s221ms 3s603ms 08 7 26s85ms 3s726ms 09 7 26s696ms 3s813ms 10 8 44s938ms 5s617ms 11 8 26s887ms 3s360ms 12 8 20s524ms 2s565ms 13 7 22s91ms 3s155ms 14 6 19s712ms 3s285ms 15 6 18s716ms 3s119ms 16 8 21s858ms 2s732ms 17 7 21s444ms 3s63ms 18 6 20s402ms 3s400ms 19 8 22s145ms 2s768ms 20 8 24s318ms 3s39ms 21 9 22s607ms 2s511ms 22 8 20s185ms 2s523ms [ User: intelifix - Total duration: 9m1s - Times executed: 171 ]
[ Application: psql - Total duration: 9m1s - Times executed: 171 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-27 10:05:27 Duration: 21s169ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-27 00:05:24 Duration: 10s428ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-27 20:15:07 Duration: 6s196ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
7 8m54s 50 8s771ms 13s697ms 10s698ms create table temp0000283816 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 27 08 15 2m39s 10s602ms 09 14 2m24s 10s325ms 10 15 2m37s 10s496ms 11 6 1m13s 12s313ms [ User: intelifix - Total duration: 8m54s - Times executed: 50 ]
[ Application: [unknown] - Total duration: 8m54s - Times executed: 50 ]
-
CREATE TABLE temp0000283816 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-27 11:02:32 Duration: 13s697ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000283816 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-27 08:09:01 Duration: 13s367ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000283816 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-27 11:02:52 Duration: 12s890ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
8 5m8s 95 154ms 12s639ms 3s243ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 27 00 6 23s286ms 3s881ms 01 6 7s169ms 1s194ms 02 4 6s72ms 1s518ms 03 5 7s767ms 1s553ms 04 6 10s471ms 1s745ms 05 4 7s387ms 1s846ms 06 6 36s498ms 6s83ms 07 9 38s145ms 4s238ms 08 12 41s80ms 3s423ms 09 12 40s303ms 3s358ms 10 12 43s824ms 3s652ms 11 12 45s958ms 3s829ms 12 1 209ms 209ms [ User: intelifix - Total duration: 5m8s - Times executed: 95 ]
[ Application: psql - Total duration: 5m8s - Times executed: 95 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-27 00:05:13 Duration: 12s639ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-27 11:35:10 Duration: 9s285ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-27 06:15:09 Duration: 8s124ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
9 4m53s 337 152ms 4s170ms 869ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 27 07 33 31s800ms 963ms 08 70 1m9s 999ms 09 74 1m4s 877ms 10 83 1m12s 873ms 11 76 53s335ms 701ms 13 1 535ms 535ms [ User: intelifix - Total duration: 4m53s - Times executed: 337 ]
[ Application: [unknown] - Total duration: 4m53s - Times executed: 337 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (259571, 317, '318110571728,54A65C13C27E,10C25A3D2FFC,10C25A3A6C8C,5C7695954448,383FB3A57AC8,905851A766F5,B42A0E1C056C,54A65C13757E,BC9B68963F4E,383FB3A246A9,BC9B689592D2,905851421AD8,905851AB0396,D4B92F2EADE9,A456CCE240B4,B42A0E1A495C,D4B92F277445,D4B92F263C5C,905851A73887,383FB3A5340B,10C25A3C9267,D4B92F29D028,B42A0ED28D80,D4B92F2644BA,90585141D3CE,BC9B689DB632,A456CCE3E98B,10C25A3D2AA0,B42A0E18CE59,5C76959394A9,1062D099EEEB,70037E9DFDE6,80D04AB8AEBF,70037E9E219C,383FB3A34E5D,5C7695924AB4,54A65C8F7BFD,B42A0E18628F,B42A0EDBE049,14B7F8DE50A5', '',046,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-27 10:25:36 Duration: 4s170ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (259577, 404, 'CP2144LVDTW,D4E2CB1E7E24$CP2248LVBQB,B85E71E2B544$CP2439LV2FA,C4509CF4AB7C$CP2530LVB5G,3C82C08B17C0$CP2210LV8B7,3C82C0CA429C$CP2204LV4C7,1C9D726B2BC4$CP2302LV0W4,B85E71E65D20$CP2234LV8YT,4075C3B6A638$CP2204LVBBC,1C9D72811DAC$CP2429LV249,C4509CBC93F4$CP2301LVB71,B85E71E75194$CP2233LVBQ5,4075C3B2EE6C$CP2130LV75P,8C6A8DC11574$CP2301LV1QQ,B85E71E61A40$CP2131LV2EN,8C6A8DC30264$CP2239LVPNG,B85E71BE6BBC$CP2248LV9SS,B85E71E3E018$CP2120LV2MQ,08A7C06BDF8C$CP2302LV0AK,B85E71E62058$CP2107LV381,E4BFFAF88DCC$CP2432LV068,C4509CE98FF4$CP2218LV0QF,3C82C0C6B1CC$CP2120LV4RW,08A7C06BCB64$CP2432LV9LY,C4509CEAE5F4$CP2248LVCG0,B85E71D819CC$CP2206LV5QF,3C82C06ADA9C$CP2242LVLF9,B85E71CAC628$CP2439LV28C,C4509CF4B95C$CP2128LV46V,08A7C07B61AC$CP2347LV1ZC,400FC17F0484$CP2425LV4GR,C4509CABAD7C$CP2048LV4ZU,484BD49972D4$CP2125LV225,08A7C070C64C$CP2104LV3J9,08A7C06DBBB4$CP2131LV8DD,8C6A8DC36FFC$CP2439LV7UK,C4509CF4CAB4$CP2432LV2R9,C4509CEA9E84$CP2105LV16A,484BD4AEB54C$CP2248LV618,B85E71E31638$CP2048LV64L,484BD4A171AC', '',0185,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-27 09:29:44 Duration: 3s892ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (259252, 433, 'CP234232V33,D4925EF9D1A3,544D424200725D08,D4925EF9D1A6$CP2303325KS,D4925E146B79,544D42420062CB02,D4925E146B7C$CP230132508,D4925E0222F8,544D424200612537,D4925E0222FB$CP232532ML6,D4925ECECDDE,544D4242006D6F44,D4925ECECDE1$CP234232SZN,D4925EF98118,544D424200725415,D4925EF9811B$CP2411322DN,08C7F52FDCD2,544D4242007882AF,08C7F52FDCD5$CP230232MGP,D4925E095825,544D42420061F182,D4925E095828$CP230232JJ6,D4925E08E703,544D42420061E4F0,D4925E08E706$CP240932JQR,08C7F52E0C68,544D424200784F15,08C7F52E0C6B$CP2345325AR,08C7F5029EB0,544D4242007348A5,08C7F5029EB3$CP234232PED,D4925EF8F90A,544D4242007244F7,D4925EF8F90D$CP2320325FN,D4925EA454C7,544D42420069C775,D4925EA454CA$CP2335322MH,D4925EE9C12E,544D4242006F5617,D4925EE9C131$CP230232EWU,D4925E085C91,544D42420061D58E,D4925E085C94$CP240932RV9,08C7F52F1DA4,544D424200786D71,08C7F52F1DA7$CP2301329CZ,D4925E02CABC,544D4242006137DB,D4925E02CABF$CP2303324CN,D4925E143CDB,544D42420062C5D4,D4925E143CDE$CP230232LSC,D4925E093D13,544D42420061EE80,D4925E093D16$CP2302321VM,D4925E066974,544D424200619E19,D4925E066977$CP2301324Q4,D4925E02183F,544D424200612406,D4925E021842$CP2303325CP,D4925E14632D,544D42420062CA16,D4925E146330$CP2227320U9,A0B53C64777E,544D42420059D44A,A0B53C647781$CP2323321LG,D4925EBA9367,544D4242006C7437,D4925EBA936A$CP23303299Q,D4925EE33944,544D4242006E7115,D4925EE33947$CP232232DWF,D4925EBD83A5,544D4242006BC6F8,D4925EBD83A8$CP232032D81,D4925EA57E3C,544D42420069E882,D4925EA57E3F$CP230232107,D4925E0647AB,544D424200619A58,D4925E0647AE$CP234232VUU,D4925EF9EF85,544D42420072605A,D4925EF9EF88$CP23433206W,D4925EFE4A94,544D42420072AA29,D4925EFE4A97$CP234232T3Y,D4925EF9860D,544D4242007254A2,D4925EF98610$CP2302322U3,D4925E068DF2,544D42420061A227,D4925E068DF5$CP2330329U1,D4925EE34E80,544D4242006E7371,D4925EE34E83$CP2302320H6,D4925E0634D3,544D424200619840,D4925E0634D6$CP2303325LE,D4925E146C36,544D42420062CB17,D4925E146C39$CP232532MR2,D4925ECED387,544D4242006D6FE5,D4925ECED38A$CP2335320WY,D4925EE97F31,544D4242006F4EC2,D4925EE97F34$CP230232PTD,D4925E09B120,544D42420061FB65,D4925E09B123$CP2319320TM,D4925E9FA4D4,544D424200698C3E,D4925E9FA4D7$CP240932QKP,08C7F52EEC3F,544D4242007867F4,08C7F52EEC42$CP230332A6C,D4925E151B65,544D42420062DE8E,D4925E151B68', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-27 10:19:30 Duration: 3s590ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
10 3m30s 538 150ms 1s299ms 391ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 27 07 76 31s594ms 415ms 08 112 45s727ms 408ms 09 94 33s272ms 353ms 10 131 50s944ms 388ms 11 100 38s796ms 387ms 12 25 10s145ms 405ms [ User: intelifix - Total duration: 3m30s - Times executed: 538 ]
[ Application: [unknown] - Total duration: 3m30s - Times executed: 538 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "125860", "modelo" : "323", "itens" : "D8313998950A,D83139987446,D83139989E10,D89A0DB0C20F,D89A0D82A8EF,48D6823137F8,F4E84F846770,C4EBFF89EFCE,843C992BF5FB,4896D95944E8,689E29BDBB5F,D89A0DA9E3CD,D831391E480C,6C11BA688545,6C11BA6872C7,D8313996723E,D89A0DACBF37,4896D9565652,14CA56D5435B,689E29BC8A5B", "usuario" : "428", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-27 08:28:16 Duration: 1s299ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "125860", "modelo" : "323", "itens" : "3891484A5AC5,D89A0DACD8BD,D89A0DA6874B,D89A0DACD84B,843C993648B3,14CA56CE307B,843C99208D3F,D83139984A2E,48D68231FA92,843C9935D50F,D89A0DA9DBCF,6C11BA6C01E9,4896D954B46E,5872C98EDF4B,4896D9588314,D89A0DACA56F,D8313991BD1C,3891484AA055,4896D95756D8,38914851BF1D", "usuario" : "428", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-27 08:31:40 Duration: 1s232ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "259648", "modelo" : "302", "itens" : "D8CF61607A70,441524E37835,20B82B23CB55,203543220B69,2035431A114C,2035432126C3,2035431584CF,2035431302F8,647B1EEC1A94,9C24722FF44E", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-27 11:09:52 Duration: 1s138ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
11 3m17s 16 9s400ms 32s993ms 12s337ms create table temp0000283810 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 27 08 3 32s968ms 10s989ms 09 4 42s546ms 10s636ms 10 6 1m4s 10s761ms 11 3 57s316ms 19s105ms [ User: intelifix - Total duration: 3m17s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 3m17s - Times executed: 16 ]
-
CREATE TABLE temp0000283810 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-27 11:23:18 Duration: 32s993ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000283810 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-27 08:30:36 Duration: 12s770ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000283810 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-27 11:24:12 Duration: 12s588ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
12 3m8s 3 5s132ms 1m36s 1m2s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 27 20 2 1m41s 50s797ms 23 1 1m26s 1m26s [ User: intelifix - Total duration: 3m8s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 3m8s - Times executed: 3 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-27 20:09:08 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-27 23:38:57 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-27 20:11:05 Duration: 5s132ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
13 2m11s 1 2m11s 2m11s 2m11s select * from rs_fast_excel (?, ?) / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 27 09 1 2m11s 2m11s [ User: intelifix - Total duration: 2m11s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 2m11s - Times executed: 1 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026294, 0508 )', '/var/www/html/tmp/nf_carga_lotes_0508.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-27 09:59:57 Duration: 2m11s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
14 2m2s 4 394ms 1m1s 30s578ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 27 20 2 1m2s 31s114ms 23 2 1m 30s42ms [ User: intelifix - Total duration: 2m2s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m2s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-27 20:05:43 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-27 23:19:06 Duration: 59s663ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-27 23:40:12 Duration: 420ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
15 1m36s 2 3s844ms 1m32s 48s240ms 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 #15
Day Hour Count Duration Avg duration Jun 27 23 2 1m36s 48s240ms [ User: intelifix - Total duration: 1m36s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m36s - 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-06-27 23:15:48 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.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-06-27 23:39:29 Duration: 3s844ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
16 1m35s 1 1m35s 1m35s 1m35s 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 #16
Day Hour Count Duration Avg duration Jun 27 23 1 1m35s 1m35s [ User: intelifix - Total duration: 1m35s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1m35s - Times executed: 1 ]
-
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-06-27 23:14:15 Duration: 1m35s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
17 1m31s 1 1m31s 1m31s 1m31s copy auditor.auditor_2026_03 (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 #17
Day Hour Count Duration Avg duration Jun 27 23 1 1m31s 1m31s [ User: intelifix - Total duration: 1m31s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1m31s - Times executed: 1 ]
-
COPY auditor.auditor_2026_03 (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-06-27 23:11:35 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
18 1m24s 5 2s123ms 33s963ms 16s971ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 27 20 3 44s924ms 14s974ms 23 2 39s931ms 19s965ms [ User: intelifix - Total duration: 1m24s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m24s - Times executed: 5 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-06-27 20:06:18 Duration: 33s963ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-06-27 23:19:38 Duration: 30s677ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-06-27 23:40:22 Duration: 9s253ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
19 1m23s 1 1m23s 1m23s 1m23s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 27 05 1 1m23s 1m23s [ User: intelifix - Total duration: 1m23s - Times executed: 1 ]
[ Application: psql - Total duration: 1m23s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-27 05:32:05 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-27 05:31:58 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
20 1m21s 6 8s341ms 19s679ms 13s534ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 27 00 3 54s708ms 18s236ms 06 3 26s499ms 8s833ms [ User: intelifix - Total duration: 1m21s - Times executed: 6 ]
[ Application: psql - Total duration: 1m21s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-27 00:05:56 Duration: 19s679ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-27 00:05:20 Duration: 19s67ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-27 00:05:36 Duration: 15s961ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 538 3m30s 150ms 1s299ms 391ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 27 07 76 31s594ms 415ms 08 112 45s727ms 408ms 09 94 33s272ms 353ms 10 131 50s944ms 388ms 11 100 38s796ms 387ms 12 25 10s145ms 405ms [ User: intelifix - Total duration: 3m30s - Times executed: 538 ]
[ Application: [unknown] - Total duration: 3m30s - Times executed: 538 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "125860", "modelo" : "323", "itens" : "D8313998950A,D83139987446,D83139989E10,D89A0DB0C20F,D89A0D82A8EF,48D6823137F8,F4E84F846770,C4EBFF89EFCE,843C992BF5FB,4896D95944E8,689E29BDBB5F,D89A0DA9E3CD,D831391E480C,6C11BA688545,6C11BA6872C7,D8313996723E,D89A0DACBF37,4896D9565652,14CA56D5435B,689E29BC8A5B", "usuario" : "428", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-27 08:28:16 Duration: 1s299ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "125860", "modelo" : "323", "itens" : "3891484A5AC5,D89A0DACD8BD,D89A0DA6874B,D89A0DACD84B,843C993648B3,14CA56CE307B,843C99208D3F,D83139984A2E,48D68231FA92,843C9935D50F,D89A0DA9DBCF,6C11BA6C01E9,4896D954B46E,5872C98EDF4B,4896D9588314,D89A0DACA56F,D8313991BD1C,3891484AA055,4896D95756D8,38914851BF1D", "usuario" : "428", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-27 08:31:40 Duration: 1s232ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "259648", "modelo" : "302", "itens" : "D8CF61607A70,441524E37835,20B82B23CB55,203543220B69,2035431A114C,2035432126C3,2035431584CF,2035431302F8,647B1EEC1A94,9C24722FF44E", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-27 11:09:52 Duration: 1s138ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
2 337 4m53s 152ms 4s170ms 869ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 27 07 33 31s800ms 963ms 08 70 1m9s 999ms 09 74 1m4s 877ms 10 83 1m12s 873ms 11 76 53s335ms 701ms 13 1 535ms 535ms [ User: intelifix - Total duration: 4m53s - Times executed: 337 ]
[ Application: [unknown] - Total duration: 4m53s - Times executed: 337 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (259571, 317, '318110571728,54A65C13C27E,10C25A3D2FFC,10C25A3A6C8C,5C7695954448,383FB3A57AC8,905851A766F5,B42A0E1C056C,54A65C13757E,BC9B68963F4E,383FB3A246A9,BC9B689592D2,905851421AD8,905851AB0396,D4B92F2EADE9,A456CCE240B4,B42A0E1A495C,D4B92F277445,D4B92F263C5C,905851A73887,383FB3A5340B,10C25A3C9267,D4B92F29D028,B42A0ED28D80,D4B92F2644BA,90585141D3CE,BC9B689DB632,A456CCE3E98B,10C25A3D2AA0,B42A0E18CE59,5C76959394A9,1062D099EEEB,70037E9DFDE6,80D04AB8AEBF,70037E9E219C,383FB3A34E5D,5C7695924AB4,54A65C8F7BFD,B42A0E18628F,B42A0EDBE049,14B7F8DE50A5', '',046,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-27 10:25:36 Duration: 4s170ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (259577, 404, 'CP2144LVDTW,D4E2CB1E7E24$CP2248LVBQB,B85E71E2B544$CP2439LV2FA,C4509CF4AB7C$CP2530LVB5G,3C82C08B17C0$CP2210LV8B7,3C82C0CA429C$CP2204LV4C7,1C9D726B2BC4$CP2302LV0W4,B85E71E65D20$CP2234LV8YT,4075C3B6A638$CP2204LVBBC,1C9D72811DAC$CP2429LV249,C4509CBC93F4$CP2301LVB71,B85E71E75194$CP2233LVBQ5,4075C3B2EE6C$CP2130LV75P,8C6A8DC11574$CP2301LV1QQ,B85E71E61A40$CP2131LV2EN,8C6A8DC30264$CP2239LVPNG,B85E71BE6BBC$CP2248LV9SS,B85E71E3E018$CP2120LV2MQ,08A7C06BDF8C$CP2302LV0AK,B85E71E62058$CP2107LV381,E4BFFAF88DCC$CP2432LV068,C4509CE98FF4$CP2218LV0QF,3C82C0C6B1CC$CP2120LV4RW,08A7C06BCB64$CP2432LV9LY,C4509CEAE5F4$CP2248LVCG0,B85E71D819CC$CP2206LV5QF,3C82C06ADA9C$CP2242LVLF9,B85E71CAC628$CP2439LV28C,C4509CF4B95C$CP2128LV46V,08A7C07B61AC$CP2347LV1ZC,400FC17F0484$CP2425LV4GR,C4509CABAD7C$CP2048LV4ZU,484BD49972D4$CP2125LV225,08A7C070C64C$CP2104LV3J9,08A7C06DBBB4$CP2131LV8DD,8C6A8DC36FFC$CP2439LV7UK,C4509CF4CAB4$CP2432LV2R9,C4509CEA9E84$CP2105LV16A,484BD4AEB54C$CP2248LV618,B85E71E31638$CP2048LV64L,484BD4A171AC', '',0185,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-27 09:29:44 Duration: 3s892ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (259252, 433, 'CP234232V33,D4925EF9D1A3,544D424200725D08,D4925EF9D1A6$CP2303325KS,D4925E146B79,544D42420062CB02,D4925E146B7C$CP230132508,D4925E0222F8,544D424200612537,D4925E0222FB$CP232532ML6,D4925ECECDDE,544D4242006D6F44,D4925ECECDE1$CP234232SZN,D4925EF98118,544D424200725415,D4925EF9811B$CP2411322DN,08C7F52FDCD2,544D4242007882AF,08C7F52FDCD5$CP230232MGP,D4925E095825,544D42420061F182,D4925E095828$CP230232JJ6,D4925E08E703,544D42420061E4F0,D4925E08E706$CP240932JQR,08C7F52E0C68,544D424200784F15,08C7F52E0C6B$CP2345325AR,08C7F5029EB0,544D4242007348A5,08C7F5029EB3$CP234232PED,D4925EF8F90A,544D4242007244F7,D4925EF8F90D$CP2320325FN,D4925EA454C7,544D42420069C775,D4925EA454CA$CP2335322MH,D4925EE9C12E,544D4242006F5617,D4925EE9C131$CP230232EWU,D4925E085C91,544D42420061D58E,D4925E085C94$CP240932RV9,08C7F52F1DA4,544D424200786D71,08C7F52F1DA7$CP2301329CZ,D4925E02CABC,544D4242006137DB,D4925E02CABF$CP2303324CN,D4925E143CDB,544D42420062C5D4,D4925E143CDE$CP230232LSC,D4925E093D13,544D42420061EE80,D4925E093D16$CP2302321VM,D4925E066974,544D424200619E19,D4925E066977$CP2301324Q4,D4925E02183F,544D424200612406,D4925E021842$CP2303325CP,D4925E14632D,544D42420062CA16,D4925E146330$CP2227320U9,A0B53C64777E,544D42420059D44A,A0B53C647781$CP2323321LG,D4925EBA9367,544D4242006C7437,D4925EBA936A$CP23303299Q,D4925EE33944,544D4242006E7115,D4925EE33947$CP232232DWF,D4925EBD83A5,544D4242006BC6F8,D4925EBD83A8$CP232032D81,D4925EA57E3C,544D42420069E882,D4925EA57E3F$CP230232107,D4925E0647AB,544D424200619A58,D4925E0647AE$CP234232VUU,D4925EF9EF85,544D42420072605A,D4925EF9EF88$CP23433206W,D4925EFE4A94,544D42420072AA29,D4925EFE4A97$CP234232T3Y,D4925EF9860D,544D4242007254A2,D4925EF98610$CP2302322U3,D4925E068DF2,544D42420061A227,D4925E068DF5$CP2330329U1,D4925EE34E80,544D4242006E7371,D4925EE34E83$CP2302320H6,D4925E0634D3,544D424200619840,D4925E0634D6$CP2303325LE,D4925E146C36,544D42420062CB17,D4925E146C39$CP232532MR2,D4925ECED387,544D4242006D6FE5,D4925ECED38A$CP2335320WY,D4925EE97F31,544D4242006F4EC2,D4925EE97F34$CP230232PTD,D4925E09B120,544D42420061FB65,D4925E09B123$CP2319320TM,D4925E9FA4D4,544D424200698C3E,D4925E9FA4D7$CP240932QKP,08C7F52EEC3F,544D4242007867F4,08C7F52EEC42$CP230332A6C,D4925E151B65,544D42420062DE8E,D4925E151B68', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-27 10:19:30 Duration: 3s590ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
3 171 9m1s 150ms 21s169ms 3s167ms call rs_giga_triagem (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 27 00 8 27s336ms 3s417ms 01 7 19s883ms 2s840ms 02 8 20s859ms 2s607ms 03 9 24s369ms 2s707ms 04 7 21s898ms 3s128ms 05 7 22s870ms 3s267ms 06 7 20s584ms 2s940ms 07 7 25s221ms 3s603ms 08 7 26s85ms 3s726ms 09 7 26s696ms 3s813ms 10 8 44s938ms 5s617ms 11 8 26s887ms 3s360ms 12 8 20s524ms 2s565ms 13 7 22s91ms 3s155ms 14 6 19s712ms 3s285ms 15 6 18s716ms 3s119ms 16 8 21s858ms 2s732ms 17 7 21s444ms 3s63ms 18 6 20s402ms 3s400ms 19 8 22s145ms 2s768ms 20 8 24s318ms 3s39ms 21 9 22s607ms 2s511ms 22 8 20s185ms 2s523ms [ User: intelifix - Total duration: 9m1s - Times executed: 171 ]
[ Application: psql - Total duration: 9m1s - Times executed: 171 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-27 10:05:27 Duration: 21s169ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-27 00:05:24 Duration: 10s428ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-27 20:15:07 Duration: 6s196ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
4 95 5m8s 154ms 12s639ms 3s243ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 27 00 6 23s286ms 3s881ms 01 6 7s169ms 1s194ms 02 4 6s72ms 1s518ms 03 5 7s767ms 1s553ms 04 6 10s471ms 1s745ms 05 4 7s387ms 1s846ms 06 6 36s498ms 6s83ms 07 9 38s145ms 4s238ms 08 12 41s80ms 3s423ms 09 12 40s303ms 3s358ms 10 12 43s824ms 3s652ms 11 12 45s958ms 3s829ms 12 1 209ms 209ms [ User: intelifix - Total duration: 5m8s - Times executed: 95 ]
[ Application: psql - Total duration: 5m8s - Times executed: 95 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-27 00:05:13 Duration: 12s639ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-27 11:35:10 Duration: 9s285ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-27 06:15:09 Duration: 8s124ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
5 61 1h1m9s 155ms 11m39s 1m select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 27 07 2 13s653ms 6s826ms 08 11 17m22s 1m34s 09 12 9m33s 47s821ms 10 19 26m27s 1m23s 11 7 7m4s 1m 12 1 1s299ms 1s299ms 13 3 6s231ms 2s77ms 14 6 20s425ms 3s404ms [ User: intelifix - Total duration: 1h1m9s - Times executed: 61 ]
[ Application: [unknown] - Total duration: 1h1m9s - Times executed: 61 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026301, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-06-27 10:52:55 Duration: 11m39s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026285, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-27 08:15:38 Duration: 4m46s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026303, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-27 11:07:51 Duration: 4m41s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
6 58 13s246ms 150ms 520ms 228ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 27 01 4 1s520ms 380ms 04 11 3s649ms 331ms 06 3 618ms 206ms 07 8 1s594ms 199ms 08 4 658ms 164ms 09 13 2s342ms 180ms 10 8 1s513ms 189ms 11 7 1s350ms 192ms [ User: intelifix - Total duration: 13s246ms - Times executed: 58 ]
[ Application: [unknown] - Total duration: 13s246ms - Times executed: 58 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '73', 2, '229911952428,229910420921,229911438203,229876141425,229908910931,229870983233,229876486991,229909942636,229915629093,229901899404,229895985067,229871082334,229870692240,229871645778,229902190320,229913917086,229918658188,229876851225', NULL, NULL, 0263, 00);
Date: 2026-06-27 01:15:20 Duration: 520ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229896151627,229902035556,229915931526,229910219206,229910162130,229909014756,229920747079,229910714765,229902032223,229898046985,229919242141,229902335462,229913447489,229900719502,229896348996,229918649804,229902925071,229897878204,229916351825,229897596885', NULL, NULL, 0263, 00);
Date: 2026-06-27 04:35:51 Duration: 467ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229893346874,229912095169,229870997779,229918123535,229896031739,229901985574,229900027178,229899383244,229871674849,229896868902,229916457390,229901027590,229919009413,229918290825,229896635568,229894140219,229899809604,229896984244,229915394346,229915855659', NULL, NULL, 0263, 00);
Date: 2026-06-27 04:33:20 Duration: 408ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
7 53 16m3s 1s402ms 54s96ms 18s175ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 27 08 4 25s120ms 6s280ms 09 5 24s4ms 4s800ms 10 18 5m24s 18s37ms 11 20 7m9s 21s484ms 12 6 2m39s 26s636ms [ User: intelifix - Total duration: 16m3s - Times executed: 53 ]
[ Application: [unknown] - Total duration: 16m3s - Times executed: 53 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-27', 0366, '', '', 0, 6, '2026-06-01');
Date: 2026-06-27 10:25:14 Duration: 54s96ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-27', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-27 11:31:16 Duration: 31s472ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-27', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-27 11:33:02 Duration: 31s413ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
8 50 8m54s 8s771ms 13s697ms 10s698ms create table temp0000283816 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 27 08 15 2m39s 10s602ms 09 14 2m24s 10s325ms 10 15 2m37s 10s496ms 11 6 1m13s 12s313ms [ User: intelifix - Total duration: 8m54s - Times executed: 50 ]
[ Application: [unknown] - Total duration: 8m54s - Times executed: 50 ]
-
CREATE TABLE temp0000283816 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-27 11:02:32 Duration: 13s697ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000283816 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-27 08:09:01 Duration: 13s367ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000283816 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-27 11:02:52 Duration: 12s890ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
9 48 1h43m21s 1s347ms 7m27s 2m9s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 27 07 3 8m1s 2m40s 08 3 6m9s 2m3s 09 3 7m14s 2m24s 10 3 6m37s 2m12s 11 3 7m56s 2m38s 12 3 7m22s 2m27s 13 3 5m50s 1m56s 14 3 5m57s 1m59s 15 3 5m59s 1m59s 16 3 5m48s 1m56s 17 3 5m46s 1m55s 18 3 6m1s 2m 19 3 5m44s 1m54s 20 3 7m24s 2m28s 21 3 5m38s 1m52s 22 3 5m47s 1m55s [ User: intelifix - Total duration: 1h43m21s - Times executed: 48 ]
[ Application: psql - Total duration: 1h43m21s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-27 07:12:29 Duration: 7m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-27 11:12:28 Duration: 7m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-27 20:12:04 Duration: 7m2s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
10 48 1h4m36s 175ms 3m54s 1m20s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 27 07 3 4m34s 1m31s 08 3 3m55s 1m18s 09 3 4m20s 1m26s 10 3 4m34s 1m31s 11 3 4m28s 1m29s 12 3 4m10s 1m23s 13 3 3m43s 1m14s 14 3 3m44s 1m14s 15 3 4m2s 1m20s 16 3 3m46s 1m15s 17 3 3m53s 1m17s 18 3 3m44s 1m14s 19 3 3m45s 1m15s 20 3 4m21s 1m27s 21 3 3m37s 1m12s 22 3 3m53s 1m17s [ User: intelifix - Total duration: 1h4m36s - Times executed: 48 ]
[ Application: psql - Total duration: 1h4m36s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-27 10:16:11 Duration: 3m54s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-27 11:17:21 Duration: 3m41s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-27 07:17:32 Duration: 3m40s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
11 48 9s770ms 151ms 798ms 203ms create table temp0000234824 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 27 09 2 956ms 478ms 10 13 2s403ms 184ms 11 33 6s410ms 194ms [ User: intelifix - Total duration: 9s770ms - Times executed: 48 ]
[ Application: [unknown] - Total duration: 9s770ms - Times executed: 48 ]
-
CREATE TABLE temp0000234824 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "22-06-2026", "data-ate" : "27-06-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-27 09:17:55 Duration: 798ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000234824 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "27-06-2026", "data-ate" : "27-06-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-27 11:06:15 Duration: 321ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000234824 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "27-06-2026", "data-ate" : "27-06-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-27 10:38:20 Duration: 263ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
12 46 21s336ms 271ms 690ms 463ms 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 #12
Day Hour Count Duration Avg duration Jun 27 00 1 410ms 410ms 01 2 962ms 481ms 03 1 384ms 384ms 04 1 359ms 359ms 05 2 691ms 345ms 06 3 1s525ms 508ms 07 6 3s84ms 514ms 08 6 3s173ms 528ms 09 7 3s113ms 444ms 10 6 2s539ms 423ms 11 5 2s469ms 493ms 12 4 1s837ms 459ms 13 2 782ms 391ms [ User: lenon - Total duration: 21s336ms - Times executed: 46 ]
[ Application: [unknown] - Total duration: 21s336ms - Times executed: 46 ]
-
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-06-27 08:11:47 Duration: 690ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-27.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-06-27 07:35:13 Duration: 659ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-27.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-06-27 11:06:14 Duration: 657ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-27.log
13 39 22s439ms 351ms 786ms 575ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 27 00 1 721ms 721ms 01 2 1s240ms 620ms 03 1 544ms 544ms 04 1 494ms 494ms 05 2 960ms 480ms 06 3 1s855ms 618ms 07 5 3s110ms 622ms 08 5 3s80ms 616ms 09 5 2s708ms 541ms 10 6 3s166ms 527ms 11 5 2s994ms 598ms 12 3 1s563ms 521ms [ User: intelifix - Total duration: 22s439ms - Times executed: 39 ]
[ Application: [unknown] - Total duration: 22s439ms - Times executed: 39 ]
-
select * from rs_menu_grants (428, 21, 1);
Date: 2026-06-27 11:06:14 Duration: 786ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
select * from rs_menu_grants (428, 21, 1);
Date: 2026-06-27 08:11:47 Duration: 763ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
select * from rs_menu_grants (404, 18, 1);
Date: 2026-06-27 09:05:36 Duration: 730ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
14 36 6s122ms 150ms 227ms 170ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 27 04 1 154ms 154ms 06 1 152ms 152ms 07 4 716ms 179ms 08 8 1s419ms 177ms 09 7 1s197ms 171ms 10 8 1s312ms 164ms 11 5 855ms 171ms 12 2 312ms 156ms [ User: intelifix - Total duration: 6s122ms - Times executed: 36 ]
[ Application: [unknown] - Total duration: 6s122ms - Times executed: 36 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-27 09:53:49 Duration: 227ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0151;
Date: 2026-06-27 08:30:05 Duration: 218ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-06-27 07:22:03 Duration: 208ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
15 33 1m8s 689ms 6s646ms 2s85ms 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 Jun 27 08 1 2s211ms 2s211ms 09 2 10s624ms 5s312ms 10 2 6s304ms 3s152ms 11 3 12s188ms 4s62ms 12 3 15s835ms 5s278ms 13 3 3s156ms 1s52ms 14 1 938ms 938ms 15 2 1s539ms 769ms 16 3 3s81ms 1s27ms 17 2 2s 1s 18 1 1s112ms 1s112ms 19 3 2s713ms 904ms 20 3 3s427ms 1s142ms 21 1 726ms 726ms 22 3 2s971ms 990ms [ User: intelifix - Total duration: 1m8s - Times executed: 33 ]
[ Application: psql - Total duration: 1m8s - Times executed: 33 ]
-
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-06-27 12:00:08 Duration: 6s646ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.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-06-27 11:20:07 Duration: 5s628ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.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-06-27 09:40:06 Duration: 5s513ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
16 24 9s296ms 191ms 573ms 387ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 27 07 1 423ms 423ms 08 6 2s516ms 419ms 09 5 2s56ms 411ms 10 7 2s418ms 345ms 11 3 1s133ms 377ms 12 1 394ms 394ms 13 1 352ms 352ms [ User: intelifix - Total duration: 9s296ms - Times executed: 24 ]
[ Application: [unknown] - Total duration: 9s296ms - Times executed: 24 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-27 10:28:44 Duration: 573ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-27 09:15:33 Duration: 498ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-27 08:28:40 Duration: 481ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
17 21 49s696ms 290ms 28s390ms 2s366ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 27 08 6 8s212ms 1s368ms 09 6 6s731ms 1s121ms 10 6 30s278ms 5s46ms 11 3 4s473ms 1s491ms [ User: intelifix - Total duration: 49s696ms - Times executed: 21 ]
[ Application: psql - Total duration: 49s696ms - Times executed: 21 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026301);
Date: 2026-06-27 10:38:43 Duration: 28s390ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT RS_SETGLOBAL ('USUARIO', 404); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026288);
Date: 2026-06-27 08:30:54 Duration: 5s205ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT RS_SETGLOBAL ('USUARIO', 508); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026294);
Date: 2026-06-27 09:50:39 Duration: 3s876ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
18 20 4s318ms 158ms 409ms 215ms select (rs_fast_barras (b.eq_id)).* from caixa_itens a inner join fluxos b on b.flu_id = a.flu_id where a.cai_id = ? order by a.cai_ordem;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 27 07 2 417ms 208ms 08 3 599ms 199ms 09 8 1s655ms 206ms 10 2 370ms 185ms 11 5 1s274ms 254ms [ User: intelifix - Total duration: 4s318ms - Times executed: 20 ]
[ Application: [unknown] - Total duration: 4s318ms - Times executed: 20 ]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3177683 ORDER BY A.CAI_ORDEM;
Date: 2026-06-27 11:12:32 Duration: 409ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3177683 ORDER BY A.CAI_ORDEM;
Date: 2026-06-27 11:12:44 Duration: 339ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3169268 ORDER BY A.CAI_ORDEM;
Date: 2026-06-27 09:46:52 Duration: 247ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
19 16 3m17s 9s400ms 32s993ms 12s337ms create table temp0000283810 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 27 08 3 32s968ms 10s989ms 09 4 42s546ms 10s636ms 10 6 1m4s 10s761ms 11 3 57s316ms 19s105ms [ User: intelifix - Total duration: 3m17s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 3m17s - Times executed: 16 ]
-
CREATE TABLE temp0000283810 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-27 11:23:18 Duration: 32s993ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000283810 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-27 08:30:36 Duration: 12s770ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000283810 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-27 11:24:12 Duration: 12s588ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
20 14 2s838ms 165ms 273ms 202ms select * from rs_etiqueta (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 27 06 2 442ms 221ms 07 2 473ms 236ms 08 2 438ms 219ms 09 2 361ms 180ms 10 3 543ms 181ms 11 2 402ms 201ms 12 1 175ms 175ms [ User: etiquetas - Total duration: 2s838ms - Times executed: 14 ]
[ Application: [unknown] - Total duration: 2s838ms - Times executed: 14 ]
-
SELECT * FROM RS_ETIQUETA (229962662136);
Date: 2026-06-27 08:24:48 Duration: 273ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_ETIQUETA ('3C585D79740A');
Date: 2026-06-27 07:28:35 Duration: 256ms Database: brasilia User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_ETIQUETA (822145921000462);
Date: 2026-06-27 06:15:48 Duration: 237ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-27.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m30s 8m32s 4m58s 3 14m56s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 27 05 3 14m56s 4m58s [ User: intelifix - Total duration: 14m56s - Times executed: 3 ]
[ Application: psql - Total duration: 14m56s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-06-27 05:08:33 Duration: 8m32s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
analyze verbose;
Date: 2026-06-27 05:12:27 Duration: 3m53s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
analyze verbose;
Date: 2026-06-27 05:14:57 Duration: 2m30s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
2 2m11s 2m11s 2m11s 1 2m11s select * from rs_fast_excel (?, ?) / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 27 09 1 2m11s 2m11s [ User: intelifix - Total duration: 2m11s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 2m11s - Times executed: 1 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026294, 0508 )', '/var/www/html/tmp/nf_carga_lotes_0508.xlsx') / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-06-27 09:59:57 Duration: 2m11s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
3 1s347ms 7m27s 2m9s 48 1h43m21s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 27 07 3 8m1s 2m40s 08 3 6m9s 2m3s 09 3 7m14s 2m24s 10 3 6m37s 2m12s 11 3 7m56s 2m38s 12 3 7m22s 2m27s 13 3 5m50s 1m56s 14 3 5m57s 1m59s 15 3 5m59s 1m59s 16 3 5m48s 1m56s 17 3 5m46s 1m55s 18 3 6m1s 2m 19 3 5m44s 1m54s 20 3 7m24s 2m28s 21 3 5m38s 1m52s 22 3 5m47s 1m55s [ User: intelifix - Total duration: 1h43m21s - Times executed: 48 ]
[ Application: psql - Total duration: 1h43m21s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-27 07:12:29 Duration: 7m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-27 11:12:28 Duration: 7m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-27 20:12:04 Duration: 7m2s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
4 1m35s 1m35s 1m35s 1 1m35s 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 Jun 27 23 1 1m35s 1m35s [ User: intelifix - Total duration: 1m35s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1m35s - Times executed: 1 ]
-
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-06-27 23:14:15 Duration: 1m35s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
5 1m31s 1m31s 1m31s 1 1m31s copy auditor.auditor_2026_03 (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 Jun 27 23 1 1m31s 1m31s [ User: intelifix - Total duration: 1m31s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 1m31s - Times executed: 1 ]
-
COPY auditor.auditor_2026_03 (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-06-27 23:11:35 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
6 1m23s 1m23s 1m23s 1 1m23s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 27 05 1 1m23s 1m23s [ User: intelifix - Total duration: 1m23s - Times executed: 1 ]
[ Application: psql - Total duration: 1m23s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-27 05:32:05 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-27 05:31:58 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
7 175ms 3m54s 1m20s 48 1h4m36s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 27 07 3 4m34s 1m31s 08 3 3m55s 1m18s 09 3 4m20s 1m26s 10 3 4m34s 1m31s 11 3 4m28s 1m29s 12 3 4m10s 1m23s 13 3 3m43s 1m14s 14 3 3m44s 1m14s 15 3 4m2s 1m20s 16 3 3m46s 1m15s 17 3 3m53s 1m17s 18 3 3m44s 1m14s 19 3 3m45s 1m15s 20 3 4m21s 1m27s 21 3 3m37s 1m12s 22 3 3m53s 1m17s [ User: intelifix - Total duration: 1h4m36s - Times executed: 48 ]
[ Application: psql - Total duration: 1h4m36s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-27 10:16:11 Duration: 3m54s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-27 11:17:21 Duration: 3m41s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-27 07:17:32 Duration: 3m40s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
8 5s132ms 1m36s 1m2s 3 3m8s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 27 20 2 1m41s 50s797ms 23 1 1m26s 1m26s [ User: intelifix - Total duration: 3m8s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 3m8s - Times executed: 3 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-27 20:09:08 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-27 23:38:57 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-27 20:11:05 Duration: 5s132ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
9 155ms 11m39s 1m 61 1h1m9s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 27 07 2 13s653ms 6s826ms 08 11 17m22s 1m34s 09 12 9m33s 47s821ms 10 19 26m27s 1m23s 11 7 7m4s 1m 12 1 1s299ms 1s299ms 13 3 6s231ms 2s77ms 14 6 20s425ms 3s404ms [ User: intelifix - Total duration: 1h1m9s - Times executed: 61 ]
[ Application: [unknown] - Total duration: 1h1m9s - Times executed: 61 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026301, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-06-27 10:52:55 Duration: 11m39s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026285, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-27 08:15:38 Duration: 4m46s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026303, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-06-27 11:07:51 Duration: 4m41s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
10 3s844ms 1m32s 48s240ms 2 1m36s 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 #10
Day Hour Count Duration Avg duration Jun 27 23 2 1m36s 48s240ms [ User: intelifix - Total duration: 1m36s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m36s - 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-06-27 23:15:48 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.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-06-27 23:39:29 Duration: 3s844ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
11 394ms 1m1s 30s578ms 4 2m2s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 27 20 2 1m2s 31s114ms 23 2 1m 30s42ms [ User: intelifix - Total duration: 2m2s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m2s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-27 20:05:43 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-27 23:19:06 Duration: 59s663ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-27 23:40:12 Duration: 420ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
12 1s402ms 54s96ms 18s175ms 53 16m3s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 27 08 4 25s120ms 6s280ms 09 5 24s4ms 4s800ms 10 18 5m24s 18s37ms 11 20 7m9s 21s484ms 12 6 2m39s 26s636ms [ User: intelifix - Total duration: 16m3s - Times executed: 53 ]
[ Application: [unknown] - Total duration: 16m3s - Times executed: 53 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-27', 0366, '', '', 0, 6, '2026-06-01');
Date: 2026-06-27 10:25:14 Duration: 54s96ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-27', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-27 11:31:16 Duration: 31s472ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-27', 0175, '', '', 0, 6, '2026-06-01');
Date: 2026-06-27 11:33:02 Duration: 31s413ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
13 2s123ms 33s963ms 16s971ms 5 1m24s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 27 20 3 44s924ms 14s974ms 23 2 39s931ms 19s965ms [ User: intelifix - Total duration: 1m24s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m24s - Times executed: 5 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-06-27 20:06:18 Duration: 33s963ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-06-27 23:19:38 Duration: 30s677ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-06-27 23:40:22 Duration: 9s253ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
14 8s341ms 19s679ms 13s534ms 6 1m21s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 27 00 3 54s708ms 18s236ms 06 3 26s499ms 8s833ms [ User: intelifix - Total duration: 1m21s - Times executed: 6 ]
[ Application: psql - Total duration: 1m21s - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-27 00:05:56 Duration: 19s679ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-27 00:05:20 Duration: 19s67ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-06-27 00:05:36 Duration: 15s961ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
15 9s400ms 32s993ms 12s337ms 16 3m17s create table temp0000283810 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 27 08 3 32s968ms 10s989ms 09 4 42s546ms 10s636ms 10 6 1m4s 10s761ms 11 3 57s316ms 19s105ms [ User: intelifix - Total duration: 3m17s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 3m17s - Times executed: 16 ]
-
CREATE TABLE temp0000283810 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-27 11:23:18 Duration: 32s993ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000283810 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-27 08:30:36 Duration: 12s770ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000283810 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-27 11:24:12 Duration: 12s588ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
16 8s771ms 13s697ms 10s698ms 50 8m54s create table temp0000283816 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 27 08 15 2m39s 10s602ms 09 14 2m24s 10s325ms 10 15 2m37s 10s496ms 11 6 1m13s 12s313ms [ User: intelifix - Total duration: 8m54s - Times executed: 50 ]
[ Application: [unknown] - Total duration: 8m54s - Times executed: 50 ]
-
CREATE TABLE temp0000283816 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-27 11:02:32 Duration: 13s697ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000283816 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-27 08:09:01 Duration: 13s367ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000283816 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-27 11:02:52 Duration: 12s890ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
17 154ms 12s639ms 3s243ms 95 5m8s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 27 00 6 23s286ms 3s881ms 01 6 7s169ms 1s194ms 02 4 6s72ms 1s518ms 03 5 7s767ms 1s553ms 04 6 10s471ms 1s745ms 05 4 7s387ms 1s846ms 06 6 36s498ms 6s83ms 07 9 38s145ms 4s238ms 08 12 41s80ms 3s423ms 09 12 40s303ms 3s358ms 10 12 43s824ms 3s652ms 11 12 45s958ms 3s829ms 12 1 209ms 209ms [ User: intelifix - Total duration: 5m8s - Times executed: 95 ]
[ Application: psql - Total duration: 5m8s - Times executed: 95 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-27 00:05:13 Duration: 12s639ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-27 11:35:10 Duration: 9s285ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-27 06:15:09 Duration: 8s124ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
18 150ms 21s169ms 3s167ms 171 9m1s call rs_giga_triagem (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 27 00 8 27s336ms 3s417ms 01 7 19s883ms 2s840ms 02 8 20s859ms 2s607ms 03 9 24s369ms 2s707ms 04 7 21s898ms 3s128ms 05 7 22s870ms 3s267ms 06 7 20s584ms 2s940ms 07 7 25s221ms 3s603ms 08 7 26s85ms 3s726ms 09 7 26s696ms 3s813ms 10 8 44s938ms 5s617ms 11 8 26s887ms 3s360ms 12 8 20s524ms 2s565ms 13 7 22s91ms 3s155ms 14 6 19s712ms 3s285ms 15 6 18s716ms 3s119ms 16 8 21s858ms 2s732ms 17 7 21s444ms 3s63ms 18 6 20s402ms 3s400ms 19 8 22s145ms 2s768ms 20 8 24s318ms 3s39ms 21 9 22s607ms 2s511ms 22 8 20s185ms 2s523ms [ User: intelifix - Total duration: 9m1s - Times executed: 171 ]
[ Application: psql - Total duration: 9m1s - Times executed: 171 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-27 10:05:27 Duration: 21s169ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-27 00:05:24 Duration: 10s428ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-27 20:15:07 Duration: 6s196ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
19 290ms 28s390ms 2s366ms 21 49s696ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 27 08 6 8s212ms 1s368ms 09 6 6s731ms 1s121ms 10 6 30s278ms 5s46ms 11 3 4s473ms 1s491ms [ User: intelifix - Total duration: 49s696ms - Times executed: 21 ]
[ Application: psql - Total duration: 49s696ms - Times executed: 21 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026301);
Date: 2026-06-27 10:38:43 Duration: 28s390ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT RS_SETGLOBAL ('USUARIO', 404); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026288);
Date: 2026-06-27 08:30:54 Duration: 5s205ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT RS_SETGLOBAL ('USUARIO', 508); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026294);
Date: 2026-06-27 09:50:39 Duration: 3s876ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
20 689ms 6s646ms 2s85ms 33 1m8s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 27 08 1 2s211ms 2s211ms 09 2 10s624ms 5s312ms 10 2 6s304ms 3s152ms 11 3 12s188ms 4s62ms 12 3 15s835ms 5s278ms 13 3 3s156ms 1s52ms 14 1 938ms 938ms 15 2 1s539ms 769ms 16 3 3s81ms 1s27ms 17 2 2s 1s 18 1 1s112ms 1s112ms 19 3 2s713ms 904ms 20 3 3s427ms 1s142ms 21 1 726ms 726ms 22 3 2s971ms 990ms [ User: intelifix - Total duration: 1m8s - Times executed: 33 ]
[ Application: psql - Total duration: 1m8s - Times executed: 33 ]
-
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-06-27 12:00:08 Duration: 6s646ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.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-06-27 11:20:07 Duration: 5s628ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.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-06-27 09:40:06 Duration: 5s513ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.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 10 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 27 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 18 2 0ms 0ms 19 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 6m50s - Times executed: 10 ]
[ Application: psql - Total duration: 6m49s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 1s39ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 10,854 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 15 FATAL entries
- 3224 ERROR entries
- 0 WARNING entries
- 3 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,123 Max number of times the same event was reported
- 3,242 Total events found
Rank Times reported Error 1 3,123 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 27 00 118 01 118 02 120 03 118 04 120 05 118 06 225 07 368 08 295 09 299 10 332 11 130 12 109 13 60 14 59 15 60 16 60 17 59 18 60 19 59 20 60 21 59 22 60 23 57 - ERROR: prepared statement "_PLAN0000000029986770" does not exist
- ERROR: prepared statement "_PLAN0000000029D327F0" does not exist
- ERROR: prepared statement "_PLAN0000000029989080" does not exist
Statement: DEALLOCATE "_PLAN0000000029986770"
Date: 2026-06-27 00:00:46 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Statement: DEALLOCATE "_PLAN0000000029D327F0"
Date: 2026-06-27 00:00:46 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Statement: DEALLOCATE "_PLAN0000000029989080"
Date: 2026-06-27 00:01:52 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
2 44 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 27 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 1 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 1 - 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-06-27 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.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-06-27 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.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-06-27 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
3 44 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 27 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 2 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-06-27 08:00:18 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.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-06-27 08:20:12 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.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-06-27 08:40:04 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
4 8 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 27 03 8 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-06-27 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Date: 2026-06-27 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Date: 2026-06-27 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
5 6 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 27 10 6 - ERROR: trailing junk after numeric literal at or near "9839104AAF4C" at character 27
- ERROR: trailing junk after numeric literal at or near "9839104AAF4C" at character 27
- ERROR: trailing junk after numeric literal at or near "9839104AAF4C" at character 27
Statement: SELECT * FROM RS_ETIQUETA(9839104AAF4C)
Date: 2026-06-27 10:01:42 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Statement: SELECT * FROM RS_ETIQUETA(9839104AAF4C)
Date: 2026-06-27 10:01:42 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Statement: SELECT * FROM RS_ETIQUETA(9839104AAF4C)
Date: 2026-06-27 10:01:42 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
6 5 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 27 00 1 06 1 07 1 10 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-06-27 00:02:37 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Date: 2026-06-27 06:02:33 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Date: 2026-06-27 07:32:38 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
7 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 27 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-06-27 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-27 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-06-27 05:32:05 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
8 2 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 27 10 2 - LOG: process 2139917 still waiting for ShareLock on transaction 1756623 after 1000.158 ms
- LOG: process 2139917 still waiting for ShareLock on transaction 1756623 after 6924.041 ms
Detail: Process holding the lock: 2156716. Wait queue: 2139917.
Context: while updating tuple (71875,24) 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-06-27 10:05:10 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Detail: Process holding the lock: 2156716. Wait queue: 2139917.
Context: while updating tuple (71875,24) 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-06-27 10:05:16 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
9 2 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 #9
Day Hour Count Jun 27 09 1 22 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
- 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-06-27 09:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-06-27 22:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
10 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 27 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-06-27 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Date: 2026-06-27 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
11 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 27 03 1 - LOG: database system was shut down at 2026-06-27 03:05:01 -03
Date: 2026-06-27 03:05:02 Log file: /usr/local/pgsql/data/log/serverlog-27.log
12 1 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 #12
Day Hour Count Jun 27 21 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
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-06-27 21:20:03 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log