pgBadger-
Global information
- Generated on Wed Sep 30 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 38,523 log entries in 9s
- Log start from 2026-09-30 00:00:50 to 2026-09-30 23:49:33
-
Overview
Global Stats
- 377 Number of unique normalized queries
- 4,070 Number of queries
- 6h47m58s Total query duration
- 2026-09-30 00:02:23 First query
- 2026-09-30 23:45:03 Last query
- 5 queries/s at 2026-09-30 23:42:11 Query peak
- 6h47m58s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 6h47m58s Execute total duration
- 4,850 Number of events
- 19 Number of unique normalized events
- 4,448 Max number of times the same event was reported
- 0 Number of cancellation
- 335 Total number of automatic vacuums
- 801 Total number of automatic analyzes
- 21 Number temporary file
- 248.23 MiB Max size of temporary file
- 69.27 MiB Average size of temporary file
- 419 Total number of sessions
- 15 sessions at 2026-09-30 11:30:26 Session peak
- 14d14h7m21s Total duration of sessions
- 50m8s Average duration of sessions
- 9 Average queries per session
- 58s421ms Average queries duration per session
- 49m9s Average idle time per session
- 424 Total number of connections
- 6 connections/s at 2026-09-30 03:05:17 Connection peak
- 4 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-30 23:42:11 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-09-30 09:25:42 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-30 23:42:11 Date
Queries duration
Key values
- 6h47m58s 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) Sep 30 00 22 0ms 21s612ms 4s486ms 3s109ms 4s306ms 50s171ms 01 29 0ms 3s85ms 893ms 3s85ms 3s679ms 4s619ms 02 10 0ms 3s18ms 2s98ms 2s813ms 3s622ms 4s259ms 03 11 0ms 3s112ms 1s842ms 2s816ms 3s309ms 4s68ms 04 14 0ms 2s899ms 1s690ms 3s484ms 3s826ms 4s383ms 05 26 0ms 9m6s 47s627ms 4s880ms 2m44s 9m6s 06 23 0ms 27s882ms 4s367ms 3s546ms 25s213ms 28s410ms 07 156 0ms 6m15s 5s913ms 16s599ms 1m26s 6m15s 08 417 0ms 5m52s 6s738ms 3m49s 6m13s 8m4s 09 495 150ms 5m48s 5s131ms 1m22s 4m53s 11m34s 10 381 0ms 5m44s 6s665ms 3m38s 5m41s 6m21s 11 289 0ms 5m37s 3s606ms 23s923ms 50s21ms 6m37s 12 141 0ms 5m32s 5s168ms 10s226ms 50s508ms 5m34s 13 216 0ms 5m16s 3s673ms 19s854ms 25s37ms 5m45s 14 488 0ms 5m32s 3s19ms 40s432ms 3m39s 5m53s 15 370 151ms 5m40s 6s384ms 1m12s 5m30s 5m41s 16 200 0ms 5m22s 4s559ms 26s963ms 39s91ms 5m51s 17 215 0ms 5m29s 6s507ms 50s660ms 3m28s 7m35s 18 38 0ms 5m11s 16s50ms 3s93ms 26s354ms 5m54s 19 24 0ms 5m16s 24s226ms 3s39ms 14s127ms 5m45s 20 115 0ms 5m14s 9s818ms 1m1s 1m19s 6m42s 21 33 0ms 5m14s 17s734ms 3s692ms 5s283ms 5m57s 22 30 0ms 5m8s 19s266ms 3s892ms 4s406ms 5m51s 23 327 0ms 1m2s 5s944ms 1m5s 1m13s 1m23s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 30 00 3 0 9s936ms 0ms 0ms 0ms 01 17 0 277ms 154ms 381ms 673ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 2 0 342ms 0ms 0ms 0ms 05 12 0 268ms 0ms 171ms 694ms 06 7 0 4s174ms 0ms 0ms 663ms 07 99 0 7s624ms 1s710ms 4s289ms 3m41s 08 334 0 6s768ms 10s9ms 3m37s 5m54s 09 407 0 5s67ms 11s17ms 52s636ms 5m43s 10 293 0 7s536ms 12s11ms 3m38s 5m41s 11 217 0 4s182ms 8s393ms 23s320ms 3m40s 12 89 0 7s285ms 1s695ms 2s767ms 3m36s 13 167 0 4s329ms 3s682ms 16s783ms 3m26s 14 419 0 2s963ms 11s791ms 20s948ms 5m33s 15 294 0 7s138ms 23s76ms 52s689ms 5m35s 16 154 0 5s301ms 6s277ms 24s927ms 3m26s 17 165 0 7s761ms 6s987ms 45s398ms 5m29s 18 17 0 33s381ms 0ms 677ms 3m19s 19 6 0 1m33s 0ms 0ms 3m18s 20 13 82 11s612ms 15s166ms 1m1s 3m19s 21 11 0 50s717ms 0ms 0ms 3m18s 22 6 0 1m31s 0ms 0ms 3m17s 23 7 320 5s944ms 1m3s 1m5s 1m23s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 30 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 1 0 0 221ms 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 Sep 30 00 0 0 0.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 1 1.00 0.00% 05 0 3 3.00 0.00% 06 0 1 1.00 0.00% 07 0 8 8.00 0.00% 08 0 12 12.00 0.00% 09 0 12 12.00 0.00% 10 0 12 12.00 0.00% 11 0 7 7.00 0.00% 12 0 7 7.00 0.00% 13 0 7 7.00 0.00% 14 0 13 13.00 0.00% 15 0 9 9.00 0.00% 16 0 7 7.00 0.00% 17 0 5 5.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Sep 30 00 17 0.00/s 01 12 0.00/s 02 10 0.00/s 03 17 0.00/s 04 10 0.00/s 05 9 0.00/s 06 15 0.00/s 07 20 0.01/s 08 27 0.01/s 09 25 0.01/s 10 43 0.01/s 11 27 0.01/s 12 17 0.00/s 13 20 0.01/s 14 25 0.01/s 15 18 0.01/s 16 22 0.01/s 17 14 0.00/s 18 12 0.00/s 19 12 0.00/s 20 15 0.00/s 21 11 0.00/s 22 9 0.00/s 23 17 0.00/s Day Hour Count Average Duration Average idle time Sep 30 00 10 57m18s 57m8s 01 16 1h1m30s 1h1m28s 02 12 1h15s 1h13s 03 19 20m11s 20m9s 04 8 1h2m15s 1h2m12s 05 10 1h36s 58m32s 06 9 59m39s 59m28s 07 20 48m20s 47m33s 08 20 49m7s 46m46s 09 23 57m42s 55m52s 10 42 33m12s 32m11s 11 33 39m57s 39m25s 12 20 58m6s 57m30s 13 17 55m45s 54m59s 14 22 52m16s 51m10s 15 22 53m46s 51m59s 16 18 56m14s 55m23s 17 20 56m2s 54m52s 18 14 58m32s 57m48s 19 12 56m5s 55m16s 20 14 48m23s 47m2s 21 11 1h1s 59m8s 22 12 1h1m7s 1h19s 23 15 38m10s 36m -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2026-09-30 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 424 connections Total
Connections per user
Key values
- intelifix Main User
- 424 connections Total
-
Sessions
Simultaneous sessions
Key values
- 15 sessions Session Peak
- 2026-09-30 11:30:26 Date
Histogram of session times
Key values
- 319 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 419 sessions Total
Sessions per user
Key values
- intelifix Main User
- 419 sessions Total
Sessions per host
Key values
- [local] Main Host
- 419 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 419 sessions Total
Application Count Total Duration Average Duration [unknown] 365 13d16h22m26s 53m58s pgAdmin 4 - CONN:31268 2 26m9s 13m4s pgAdmin 4 - CONN:412032 2 11s856ms 5s928ms pgAdmin 4 - CONN:4593780 1 4m42s 4m42s pgAdmin 4 - CONN:4647761 2 11s736ms 5s868ms pgAdmin 4 - CONN:5804137 2 6m5s 3m2s pgAdmin 4 - CONN:6961353 1 2m7s 2m7s pgAdmin 4 - CONN:7275575 4 2m 30s87ms pgAdmin 4 - CONN:9786099 2 12s114ms 6s57ms pgAdmin 4 - DB:brasilia 2 5m15s 2m37s pgAdmin 4 - DB:contagem 2 2m38s 1m19s pgAdmin 4 - DB:postgres 5 2h49m11s 33m50s pgAdmin 4 - DB:rio 2 2m26s 1m13s pgAdmin 4 - DB:testes 3 2h49m48s 56m36s pg_dump 9 41m43s 4m38s postgres_fdw 1 56m51s 56m51s psql 14 13h35m20s 58m14s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 68,399 buffers Checkpoint Peak
- 2026-09-30 00:08:38 Date
- 270.031 seconds Highest write time
- 0.063 seconds Sync time
Checkpoints Wal files
Key values
- 9 files Wal files usage Peak
- 2026-09-30 17:14:40 Date
Checkpoints distance
Key values
- 341.83 Mo Distance Peak
- 2026-09-30 09:09:38 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 30 00 88,821 605.131s 0.013s 605.18s 01 2,359 236.429s 0.026s 236.48s 02 846 84.837s 0.008s 84.854s 03 765 76.732s 0.011s 76.758s 04 1,297 130.068s 0.024s 130.108s 05 8,733 869.298s 0.029s 869.352s 06 7,120 492.102s 0.014s 492.139s 07 14,616 1,354.427s 0.047s 1,354.531s 08 64,975 3,145.287s 0.161s 3,145.59s 09 61,690 3,238.386s 0.201s 3,238.737s 10 59,922 3,226.387s 0.242s 3,226.719s 11 42,784 3,110.419s 0.107s 3,110.59s 12 23,105 2,229.395s 0.065s 2,229.515s 13 22,701 2,324.958s 0.089s 2,325.093s 14 56,093 3,070.306s 0.183s 3,070.564s 15 43,207 3,239.504s 0.172s 3,239.75s 16 29,232 2,523.52s 0.117s 2,523.688s 17 47,301 2,000.514s 0.121s 2,000.685s 18 2,394 240.027s 0.017s 240.059s 19 24 2.413s 0.002s 2.416s 20 410 302.875s 0.006s 302.92s 21 2,484 248.83s 0.023s 248.884s 22 1,630 163.436s 0.014s 163.467s 23 435 43.628s 0.007s 43.648s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 30 00 0 11 0 435 0.002s 0.006s 01 0 1 0 711 0.002s 0.009s 02 0 0 0 263 0.002s 0.004s 03 0 1 0 271 0.003s 0.005s 04 0 0 0 519 0.003s 0.007s 05 0 4 0 722 0.005s 0.008s 06 0 1 0 434 0.002s 0.007s 07 0 8 0 2,104 0.002s 0.012s 08 0 42 0 6,012 0.008s 0.012s 09 0 44 5 7,864 0.004s 0.012s 10 0 0 40 6,895 0.017s 0.012s 11 0 0 17 4,819 0.002s 0.012s 12 0 0 8 3,354 0.002s 0.012s 13 0 0 10 4,154 0.007s 0.012s 14 0 0 32 6,793 0.006s 0.012s 15 0 0 36 6,953 0.024s 0.012s 16 0 0 17 5,012 0.003s 0.012s 17 0 0 25 3,964 0.005s 0.012s 18 0 0 1 333 0.003s 0.006s 19 0 0 0 4 0.001s 0.001s 20 0 0 1 104 0.002s 0.003s 21 0 0 1 357 0.004s 0.01s 22 0 0 0 439 0.002s 0.007s 23 0 0 0 115 0.001s 0.005s Day Hour Count Avg time (sec) Sep 30 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 Sep 30 00 31,940.67 kB 106,927.67 kB 01 1,241.22 kB 51,031.44 kB 02 1,037.25 kB 25,577.00 kB 03 645.00 kB 4,138.50 kB 04 832.86 kB 1,163.00 kB 05 7,858.75 kB 15,484.38 kB 06 3,162.29 kB 11,379.86 kB 07 11,375.75 kB 13,769.42 kB 08 56,683.17 kB 113,107.00 kB 09 67,679.17 kB 127,785.33 kB 10 54,600.33 kB 98,677.75 kB 11 22,659.25 kB 68,697.08 kB 12 10,885.92 kB 30,801.25 kB 13 13,081.42 kB 25,792.92 kB 14 43,717.92 kB 63,392.42 kB 15 50,271.42 kB 83,274.58 kB 16 22,237.58 kB 59,543.17 kB 17 34,313.92 kB 98,684.50 kB 18 1,952.33 kB 44,424.00 kB 19 189.00 kB 30,356.00 kB 20 7,396.33 kB 26,550.67 kB 21 1,173.80 kB 14,416.80 kB 22 1,139.71 kB 6,586.57 kB 23 269.80 kB 3,751.00 kB -
Temporary Files
Size of temporary files
Key values
- 496.45 MiB Temp Files size Peak
- 2026-09-30 05:31:56 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-30 05:32:02 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 30 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.32 GiB 67.53 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 1 104.00 MiB 104.00 MiB 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.02 GiB 37.02 MiB 248.23 MiB 65.14 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-30 05:32:05 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-30 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 308.52 MiB 57.35 MiB 94.38 MiB 77.13 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-30 05:30:41 Duration: 39s492ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-30 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 1 104.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030599, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-09-30 08:00:36 Duration: 5m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030610, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-09-30 09:10:27 Duration: 5m48s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030617, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-30 10:16:40 Duration: 5m44s Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 248.23 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-30 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 248.23 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-30 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-09-30 17:08:08 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 94.38 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-30 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 94.38 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-30 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 62.41 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-30 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 57.35 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-30 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 40.99 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-30 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.92 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-30 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.92 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-30 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.92 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-30 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.92 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-30 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-30 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 40.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-30 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 37.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-30 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 37.03 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-30 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 37.03 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-30 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 37.02 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-30 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 37.02 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-30 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 37.02 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-30 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.43 sec Highest CPU-cost vacuum
Table public.temp0000292946
Database rio - 2026-09-30 10:11:37 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.43 sec Highest CPU-cost vacuum
Table public.temp0000292946
Database rio - 2026-09-30 10:11:37 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (92) Main table analyzed (database rio)
- 801 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 92 rio.pg_catalog.pg_class 50 brasilia.pg_catalog.pg_attribute 43 brasilia.public.temp0000241274 42 rio.pg_catalog.pg_type 42 rio.public.usuarios 42 rio.pg_catalog.pg_index 27 rio.public.temp0000292946 27 rio.pg_catalog.pg_depend 22 contagem.pg_catalog.pg_attribute 21 brasilia.pg_catalog.pg_class 18 brasilia.pg_catalog.pg_type 16 rio.public.temp0000292920 16 contagem.pg_catalog.pg_class 14 contagem.public.usuarios 13 rio.public.temp0000292992 13 brasilia.public.temp0000241220 13 contagem.pg_catalog.pg_type 12 rio.public.temp0000293020 11 rio.public.temp0000292914 11 brasilia.public.usuarios 10 brasilia.public.temp0000241226 10 rio.public.temp0000293032 9 brasilia.pg_catalog.pg_index 9 rio.public.temp0000292916 9 rio.public.temp0000292994 7 rio.public.temp0000293040 7 rio.public.temp0000292944 7 rio.public.temp0000293050 7 brasilia.pg_catalog.pg_depend 7 rio.public.temp0000292906 7 contagem.pg_catalog.pg_index 7 brasilia.public.temp0000241232 6 rio.public.temp0000292754 6 contagem.pg_catalog.pg_depend 6 contagem.public.temp0000227362 6 rio.public.temp0000292936 6 contagem.public.temp0000227352 5 rio.public.temp0000292986 5 rio.public.temp0000292760 5 rio.public.temp0000292898 5 rio.public.temp0000292774 4 rio.public.temp0000292892 4 rio.public.temp0000293000 4 testes.public.temp0000227352 4 postgres.pg_catalog.pg_shdepend 3 contagem.public.temp0000227368 3 testes.auditor.auditor_2026_09 3 brasilia.public.temp0000241286 3 contagem.public.temp0000227354 3 rio.public.temp0000293034 3 brasilia.public.temp0000241262 3 contagem.public.temp0000227364 3 rio.public.tmp_drill_0302 3 rio.pg_catalog.pg_shdepend 3 rio.public.temp0000292974 3 contagem.public.nf_entrada 2 brasilia.public.temp0000241238 2 brasilia.public.temp0000241276 2 rio.public.temp0000292874 2 rio.public.temp0000293052 2 brasilia.public.temp0000241328 2 brasilia.public.temp0000241252 2 rio.public.temp0000293056 2 rio.public.temp0000292924 2 brasilia.public.temp0000241290 2 rio.public.temp0000292932 2 rio.public.temp0000293026 2 rio.public.temp0000292962 2 rio.public.temp0000292952 1 rio.public.temp0000292940 1 brasilia.public.temp0000241304 1 rio.public.temp0000292954 1 brasilia.public.temp0000241234 1 contagem.public.temp0000227350 1 rio.public.temp0000292912 1 rio.public.temp0000293054 1 rio.public.temp0000292928 1 contagem.pg_catalog.pg_shdepend 1 brasilia.public.temp0000241310 1 rio.public.temp0000292982 1 rio.public.temp0000293004 1 rio.public.temp0000292926 1 contagem.public.temp0000227366 1 brasilia.pg_catalog.pg_shdepend 1 rio.public.temp0000293028 1 rio.public.temp0000292984 1 template1.pg_catalog.pg_shdepend 1 brasilia.public.temp0000241224 1 brasilia.public.temp0000241322 1 rio.public.temp0000292772 1 rio.public.temp0000293038 1 rio.public.temp0000292990 1 brasilia.public.temp0000241244 1 rio.public.temp0000292988 1 rio.public.temp0000293030 1 rio.public.temp0000292910 1 brasilia.public.temp0000241228 1 contagem.public.temp0000227256 1 brasilia.public.temp0000241334 1 rio.public.temp0000292966 1 brasilia.public.temp0000241326 1 brasilia.public.temp0000241272 1 rio.public.temp0000293036 1 Total 801 Vacuums per table
Key values
- pg_catalog.pg_attribute (42) Main table vacuumed on database rio
- 335 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 42 38 0 0 0 0 0 20,390 4,958 7,727,086 295 7,401 rio.public.temp0000292946 27 0 0 0 0 0 0 21,374 212 1,430,554 0 0 rio.pg_catalog.pg_class 22 19 0 0 0 0 0 4,005 1,179 1,897,732 70 296 rio.pg_catalog.pg_type 21 17 0 0 0 0 0 1,973 625 924,971 79 264 rio.pg_catalog.pg_index 14 12 0 0 0 0 0 772 197 227,174 39 91 contagem.public.usuarios 13 0 0 0 0 0 0 67 53 26,526 0 0 rio.pg_catalog.pg_depend 12 10 0 0 0 0 0 3,415 1,140 1,880,615 79 615 brasilia.pg_catalog.pg_attribute 11 11 0 0 0 0 0 5,382 1,745 2,773,848 94 2,397 rio.public.temp0000293032 9 0 0 0 0 0 0 14,797 38 878,759 0 0 contagem.pg_catalog.pg_attribute 8 8 0 0 0 0 0 5,435 1,381 2,510,532 26 685 rio.public.temp0000293040 7 0 0 0 0 0 0 12,874 1,863 3,138,863 0 0 contagem.public.temp0000227362 6 0 0 0 0 0 0 705 145 233,676 0 0 rio.public.usuarios 6 4 0 0 0 0 0 116 47 100,612 9 15 rio.pg_catalog.pg_statistic 6 6 0 0 0 0 0 8,113 1,703 7,988,810 769 3,756 brasilia.pg_catalog.pg_class 6 6 0 0 0 0 0 1,123 469 733,685 28 130 brasilia.public.temp0000241232 6 0 0 0 0 0 0 1,285 23 79,361 0 0 rio.public.temp0000292936 6 0 0 0 0 0 0 9,192 1,857 2,919,130 0 0 contagem.pg_catalog.pg_type 5 5 0 0 0 0 0 480 138 225,161 6 16 rio.public.tmp_drill_0302 5 3 0 0 0 0 0 209 27 57,218 1 31 rio.public.temp0000292754 5 0 0 0 0 0 0 322 130 200,042 0 0 brasilia.pg_catalog.pg_type 5 5 0 0 0 0 0 448 204 301,288 18 119 rio.public.temp0000292986 5 0 0 0 0 0 0 411 25 28,195 0 0 rio.public.temp0000292920 4 0 0 0 0 0 0 5,515 15 327,732 0 0 rio.public.temp0000293000 4 0 0 0 0 0 0 185 22 14,422 0 0 contagem.pg_catalog.pg_class 4 4 0 0 0 0 0 941 168 307,505 5 24 rio.public.temp0000292760 4 0 0 0 0 0 0 205 23 15,452 0 0 template1.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 926 367 812,897 103 4,301 rio.public.temp0000292774 4 0 0 0 0 0 0 191 53 62,836 0 0 rio.public.temp0000292892 4 0 0 0 0 0 0 1,972 21 119,494 0 0 brasilia.pg_catalog.pg_statistic 4 4 0 0 0 0 0 4,656 1,573 5,705,782 1,266 7,586 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 851 214 467,370 7 71 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,797 338 1,947,062 153 455 contagem.pg_catalog.pg_index 3 3 0 0 0 0 0 175 42 49,668 2 2 brasilia.pg_catalog.pg_index 3 3 0 0 0 0 0 133 49 35,571 6 28 rio.public.temp0000292924 2 0 0 0 0 0 0 1,843 7 109,878 0 0 rio.public.temp0000292994 2 0 0 0 0 0 0 86 11 6,780 0 0 rio.public.temp0000293056 2 0 0 0 0 0 0 8 6 1,548 0 0 rio.public.temp0000293052 2 0 0 0 0 0 0 3,680 8 218,326 0 0 brasilia.pg_catalog.pg_depend 2 2 0 0 0 0 0 738 326 493,020 38 1,294 brasilia.public.temp0000241276 2 0 0 0 0 0 0 512 8 31,414 0 0 rio.public.temp0000292962 2 0 0 0 0 0 0 3,678 1,843 2,593,810 0 0 rio.public.temp0000292932 2 0 0 0 0 0 0 151 10 10,417 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 387 113 465,212 40 95 contagem.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 425 91 229,934 8 11 rio.public.temp0000293028 1 0 0 0 0 0 0 84 6 5,865 0 0 brasilia.public.usuarios 1 1 0 0 0 0 0 13 2 3,262 0 0 rio.public.temp0000292874 1 0 0 0 0 0 0 100 6 6,824 0 0 rio.public.temp0000292926 1 0 0 0 0 0 0 4 4 3,036 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 139 5 31,335 0 0 rio.public.temp0000293004 1 0 0 0 0 0 0 84 6 5,865 0 0 rio.public.temp0000292982 1 0 0 0 0 0 0 83 6 5,804 0 0 rio.public.temp0000293030 1 0 0 0 0 0 0 84 6 5,865 0 0 brasilia.public.temp0000241272 1 0 0 0 0 0 0 256 256 409,086 0 0 rio.public.temp0000293036 1 0 0 0 0 0 0 118 6 7,915 0 0 rio.pg_catalog.pg_proc 1 1 0 0 0 0 0 880 415 1,053,988 69 309 rio.public.temp0000292772 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000293026 1 0 0 0 0 0 0 84 6 5,865 0 0 rio.public.temp0000292984 1 0 0 0 0 0 0 8 5 1,300 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,119 2 148,270 0 0 contagem.public.temp0000227368 1 0 0 0 0 0 0 117 6 7,880 0 0 brasilia.public.temp0000241304 1 0 0 0 0 0 0 256 4 15,707 0 0 rio.public.temp0000292952 1 0 0 0 0 0 0 8 5 1,219 0 0 rio.public.temp0000292940 1 0 0 0 0 0 0 4 3 774 0 0 contagem.public.nf_entrada 1 1 0 0 0 0 0 100 33 81,026 1 1 rio.public.temp0000292928 1 0 0 0 0 0 0 67 4 4,556 0 0 testes.pg_toast.pg_toast_1255 1 1 0 0 0 0 0 490 134 905,293 48 185 rio.public.temp0000293054 1 0 0 0 0 0 0 8 5 1,309 0 0 rio.public.temp0000292990 1 0 0 0 0 0 0 84 6 5,864 0 0 Total 335 180 0 0 0 0 0 147,137 24,401 53,028,650 3,259 30,178 Vacuum throughput per table
Key values
- pg_catalog.pg_attribute (2.6) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 2.6 rio.public.temp0000292946 0 0 0.98 rio.pg_catalog.pg_class 0 0 0.61 rio.pg_catalog.pg_type 0 0 0.25 rio.pg_catalog.pg_index 0 0 0.09 contagem.public.usuarios 0 0 0.01 rio.pg_catalog.pg_depend 0 0 0.55 brasilia.pg_catalog.pg_attribute 0 0 1.16 rio.public.temp0000293032 0 0 0.76 contagem.pg_catalog.pg_attribute 0 0 0.95 rio.public.temp0000293040 0 0 0.31 contagem.public.temp0000227362 0 0 0.01 rio.public.usuarios 0 0 0 rio.pg_catalog.pg_statistic 0 0 1.14 brasilia.pg_catalog.pg_class 0 0 0.54 brasilia.public.temp0000241232 0 0 0 rio.public.temp0000292936 0 0 0.3 contagem.pg_catalog.pg_type 0 0 0.26 rio.public.tmp_drill_0302 0 0 0 rio.public.temp0000292754 0 0 0 brasilia.pg_catalog.pg_type 0 0 0.18 rio.public.temp0000292986 0 0 0.04 rio.public.temp0000292920 0 0 0.19 rio.public.temp0000293000 0 0 0.01 contagem.pg_catalog.pg_class 0 0 0.33 rio.public.temp0000292760 0 0 0 template1.pg_catalog.pg_shdepend 0 0 0.24 rio.public.temp0000292774 0 0 0 rio.public.temp0000292892 0 0 0.04 brasilia.pg_catalog.pg_statistic 0 0 0.46 contagem.pg_catalog.pg_depend 0 0 0.22 rio.pg_toast.pg_toast_2619 0 0 0.25 contagem.pg_catalog.pg_index 0 0 0.1 brasilia.pg_catalog.pg_index 0 0 0.13 rio.public.temp0000292924 0 0 0.04 rio.public.temp0000292994 0 0 0.02 rio.public.temp0000293056 0 0 0.08 rio.public.temp0000293052 0 0 0.1 brasilia.pg_catalog.pg_depend 0 0 0.34 brasilia.public.temp0000241276 0 0 0 rio.public.temp0000292962 0 0 0.1 rio.public.temp0000292932 0 0 0 brasilia.pg_toast.pg_toast_2619 0 0 0.27 contagem.pg_catalog.pg_shdepend 0 0 0.03 rio.public.temp0000293028 0 0 0.01 brasilia.public.usuarios 0 0 0 rio.public.temp0000292874 0 0 0.01 rio.public.temp0000292926 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000293004 0 0 0 rio.public.temp0000292982 0 0 0.02 rio.public.temp0000293030 0 0 0 brasilia.public.temp0000241272 0 0 0.05 rio.public.temp0000293036 0 0 0 rio.pg_catalog.pg_proc 0 0 0.18 rio.public.temp0000292772 0 0 0 rio.public.temp0000293026 0 0 0 rio.public.temp0000292984 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.09 contagem.public.temp0000227368 0 0 0 brasilia.public.temp0000241304 0 0 0 rio.public.temp0000292952 0 0 0 rio.public.temp0000292940 0 0 0.04 contagem.public.nf_entrada 0 0 0.05 rio.public.temp0000292928 0 0 0 testes.pg_toast.pg_toast_1255 0 0 0.07 rio.public.temp0000293054 0 0 0 rio.public.temp0000292990 0 0 0 Total 0 0 14.21 Tuples removed per table
Key values
- pg_catalog.pg_attribute (140874) Main table with removed tuples on database rio
- 280701 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 42 38 140,874 1,161,627 73,673 206 31,406 brasilia.pg_catalog.pg_attribute 11 11 38,338 254,435 0 0 6,038 contagem.pg_catalog.pg_attribute 8 8 37,032 198,438 0 335 4,448 rio.pg_catalog.pg_statistic 6 6 11,345 49,378 141 0 7,716 rio.pg_catalog.pg_depend 12 10 10,667 234,535 17,954 11 2,192 brasilia.pg_catalog.pg_statistic 4 4 6,973 32,891 0 0 4,288 rio.pg_catalog.pg_type 21 17 6,854 54,335 6,390 35 1,566 contagem.pg_catalog.pg_statistic 1 1 4,423 7,274 0 0 1,011 rio.pg_catalog.pg_index 14 12 2,930 29,697 2,810 0 873 template1.pg_catalog.pg_shdepend 4 4 2,695 72,453 397 0 591 contagem.pg_catalog.pg_class 4 4 2,527 14,200 0 28 596 rio.public.tmp_drill_0302 5 3 2,437 4,186 710 0 91 rio.pg_catalog.pg_class 22 19 2,341 96,196 15,902 73 3,070 brasilia.pg_catalog.pg_depend 2 2 1,635 36,655 42 13 336 contagem.pg_catalog.pg_shdepend 2 2 1,227 36,637 496 0 300 contagem.pg_catalog.pg_type 5 5 1,164 11,259 0 43 329 brasilia.pg_catalog.pg_class 6 6 1,146 27,492 0 0 924 rio.pg_toast.pg_toast_2619 3 3 1,074 2,063 0 0 861 contagem.pg_catalog.pg_index 3 3 924 5,695 0 20 149 contagem.public.usuarios 13 0 803 312 0 0 26 contagem.pg_catalog.pg_depend 3 3 796 56,638 0 18 515 contagem.public.nf_entrada 1 1 593 1,575 0 0 87 brasilia.pg_catalog.pg_type 5 5 534 11,153 6 21 300 rio.public.usuarios 6 4 321 3,686 632 0 114 brasilia.pg_toast.pg_toast_2619 2 2 237 280 0 0 154 testes.pg_toast.pg_toast_1255 1 1 228 1,033 0 0 267 brasilia.pg_catalog.pg_index 3 3 165 5,689 0 15 138 brasilia.public.usuarios 1 1 149 429 0 0 11 rio.pg_catalog.pg_proc 1 1 136 4,423 77 0 612 contagem.pg_toast.pg_toast_2619 1 1 133 114 0 0 57 rio.public.temp0000293040 7 0 0 182,620 0 0 12,992 rio.public.temp0000292924 2 0 0 27,191 0 0 1,920 rio.public.temp0000293028 1 0 0 1,345 0 52 76 rio.public.temp0000292994 2 0 0 6,782 0 105 151 rio.public.temp0000292920 4 0 0 104,259 0 0 7,424 contagem.public.temp0000227362 6 0 0 8,401 0 114 654 rio.public.temp0000293056 2 0 0 52,186 0 0 3,712 rio.public.temp0000293000 4 0 0 16,138 0 151 361 rio.public.temp0000292874 1 0 0 4,126 0 36 92 rio.public.temp0000293052 2 0 0 52,186 0 0 3,712 rio.public.temp0000292926 1 0 0 1,110 0 0 64 rio.public.temp0000293004 1 0 0 1,345 0 52 76 brasilia.public.temp0000241276 2 0 0 6,730 0 0 512 rio.public.temp0000292982 1 0 0 1,339 0 53 75 rio.public.temp0000293030 1 0 0 1,345 0 52 76 rio.public.temp0000292760 4 0 0 10,186 0 93 227 brasilia.public.temp0000241272 1 0 0 3,365 0 0 256 rio.public.temp0000293036 1 0 0 4,907 0 18 110 rio.public.temp0000292962 2 0 0 52,151 0 0 3,712 rio.public.temp0000292772 1 0 0 1,110 0 0 64 rio.public.temp0000293026 1 0 0 1,345 0 52 76 rio.public.temp0000292984 1 0 0 1,345 0 52 76 rio.public.temp0000292932 2 0 0 2,449 0 52 140 rio.public.temp0000293032 9 0 0 210,034 0 51 14,925 contagem.public.temp0000227368 1 0 0 1,401 0 19 109 brasilia.public.temp0000241304 1 0 0 3,365 0 0 256 rio.public.temp0000292754 5 0 0 14,225 0 131 317 rio.public.temp0000292774 4 0 0 7,301 0 60 164 rio.public.temp0000292952 1 0 0 1,846 0 23 41 rio.public.temp0000292940 1 0 0 26,065 0 0 1,856 rio.public.temp0000292986 5 0 0 19,900 0 79 497 brasilia.public.temp0000241232 6 0 0 20,190 0 0 1,536 rio.public.temp0000292892 4 0 0 30,406 0 135 2,041 rio.public.temp0000292946 27 0 0 332,590 0 817 23,375 rio.public.temp0000292928 1 0 0 1,110 0 0 64 rio.public.temp0000293054 1 0 0 1,460 0 47 81 rio.public.temp0000292936 6 0 0 156,411 0 0 11,136 rio.public.temp0000292990 1 0 0 1,340 0 52 76 Total 335 180 280,701 3,786,383 119,230 3,114 162,098 Pages removed per table
Key values
- public.temp0000292946 (817) Main table with removed pages on database rio
- 3114 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000292946 27 0 0 817 contagem.pg_catalog.pg_attribute 8 8 37032 335 rio.pg_catalog.pg_attribute 42 38 140874 206 rio.public.temp0000293000 4 0 0 151 rio.public.temp0000292892 4 0 0 135 rio.public.temp0000292754 5 0 0 131 contagem.public.temp0000227362 6 0 0 114 rio.public.temp0000292994 2 0 0 105 rio.public.temp0000292760 4 0 0 93 rio.public.temp0000292986 5 0 0 79 rio.pg_catalog.pg_class 22 19 2341 73 rio.public.temp0000292774 4 0 0 60 rio.public.temp0000292982 1 0 0 53 rio.public.temp0000293028 1 0 0 52 rio.public.temp0000293004 1 0 0 52 rio.public.temp0000293030 1 0 0 52 rio.public.temp0000293026 1 0 0 52 rio.public.temp0000292984 1 0 0 52 rio.public.temp0000292932 2 0 0 52 rio.public.temp0000292990 1 0 0 52 rio.public.temp0000293032 9 0 0 51 rio.public.temp0000293054 1 0 0 47 contagem.pg_catalog.pg_type 5 5 1164 43 rio.public.temp0000292874 1 0 0 36 rio.pg_catalog.pg_type 21 17 6854 35 contagem.pg_catalog.pg_class 4 4 2527 28 rio.public.temp0000292952 1 0 0 23 brasilia.pg_catalog.pg_type 5 5 534 21 contagem.pg_catalog.pg_index 3 3 924 20 contagem.public.temp0000227368 1 0 0 19 contagem.pg_catalog.pg_depend 3 3 796 18 rio.public.temp0000293036 1 0 0 18 brasilia.pg_catalog.pg_index 3 3 165 15 brasilia.pg_catalog.pg_depend 2 2 1635 13 rio.pg_catalog.pg_depend 12 10 10667 11 rio.public.temp0000293040 7 0 0 0 rio.public.temp0000292924 2 0 0 0 rio.public.temp0000292920 4 0 0 0 brasilia.pg_catalog.pg_attribute 11 11 38338 0 brasilia.public.usuarios 1 1 149 0 rio.public.temp0000293056 2 0 0 0 rio.public.temp0000293052 2 0 0 0 rio.public.temp0000292926 1 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 133 0 rio.public.tmp_drill_0302 5 3 2437 0 brasilia.public.temp0000241276 2 0 0 0 brasilia.public.temp0000241272 1 0 0 0 rio.pg_catalog.pg_index 14 12 2930 0 rio.public.usuarios 6 4 321 0 rio.pg_toast.pg_toast_2619 3 3 1074 0 rio.pg_catalog.pg_proc 1 1 136 0 rio.public.temp0000292962 2 0 0 0 rio.public.temp0000292772 1 0 0 0 contagem.public.usuarios 13 0 803 0 rio.pg_catalog.pg_statistic 6 6 11345 0 template1.pg_catalog.pg_shdepend 4 4 2695 0 brasilia.pg_catalog.pg_class 6 6 1146 0 contagem.pg_catalog.pg_statistic 1 1 4423 0 brasilia.public.temp0000241304 1 0 0 0 brasilia.pg_toast.pg_toast_2619 2 2 237 0 rio.public.temp0000292940 1 0 0 0 brasilia.public.temp0000241232 6 0 0 0 contagem.public.nf_entrada 1 1 593 0 contagem.pg_catalog.pg_shdepend 2 2 1227 0 rio.public.temp0000292928 1 0 0 0 testes.pg_toast.pg_toast_1255 1 1 228 0 rio.public.temp0000292936 6 0 0 0 brasilia.pg_catalog.pg_statistic 4 4 6973 0 Total 335 180 280,701 3,114 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 30 00 0 0 01 0 4 02 0 0 03 0 0 04 0 0 05 7 5 06 0 1 07 4 13 08 66 101 09 49 120 10 41 93 11 23 69 12 7 35 13 20 50 14 38 93 15 29 107 16 20 62 17 28 42 18 0 3 19 0 0 20 0 0 21 3 3 22 0 0 23 0 0 - 0.43 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 6 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 3 3m34s 16s448ms 2m27s 1m11s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-30 08:17:38 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-30 08:35:57 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-30 09:05:24 Database: rio User: intelifix Remote: [local] Application: psql
2 2 3m 53s405ms 2m7s 1m30s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (292503, 304, '465253182027,216598657177', '',034,00,'[{"item":"0","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-30 17:02:37 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (292244, 503, '821075911000032,229849991533', '246610923342,,,,,', 0145, 00, '[{"item":"0","qrcode":""}]', '$$$$$', '', 00);
Date: 2026-09-30 11:10:39 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (291895, 449, 'CP241332723,08C7F53488C1,544D42420078EB46,08C7F53488C4$CP234532GS7,08C7F50455C1,544D42420073796E,08C7F50455C4$CP2304326G8,D4925E165684,544D42420062FB0F,D4925E165687$CP2330322HA,D4925EE23633,544D4242006E544C,D4925EE23636$CP2241322D5,A0B53CC2963D,544D4242005E9A4C,A0B53CC29640$CP230232J8D,D4925E08DBB1,544D42420061E3AE,D4925E08DBB4$CP240932BP5,08C7F52CFE8C,544D424200783119,08C7F52CFE8F$CP234232Q40,D4925EF91344,544D4242007247E1,D4925EF91347$CP234232S5V,D4925EF96231,544D4242007250A6,D4925EF96234$CP234232VBP,D4925EF9DB9F,544D424200725E24,D4925EF9DBA2$CP2411321UP,08C7F52FC7F9,544D42420078805E,08C7F52FC7FC$CP2227320VP,A0B53C647925,544D42420059D479,A0B53C647928$CP24113288E,08C7F530BC73,544D424200789B88,08C7F530BC76$CP232532G1Y,D4925ECD0EF9,544D4242006D57A7,D4925ECD0EFC$CP2322322WE,D4925EB3456C,544D4242006B982C,D4925EB3456F$CP22413213E,A0B53CC264AB,544D4242005E94CA,A0B53CC264AE$CP2320323F0,D4925EA4076F,544D42420069BEDD,D4925EA40772$CP234232JJS,D4925EF83EF5,544D42420072304A,D4925EF83EF8$CP234232THL,D4925EF995E8,544D424200725665,D4925EF995EB$CP230132555,D4925E0228C5,544D4242006125DC,D4925E0228C8$CP2301327GD,D4925E028235,544D424200612FCC,D4925E028238$CP230232RQD,D4925E09FA37,544D424200620384,D4925E09FA3A$CP232032A4U,D4925EA507D4,544D42420069DB5A,D4925EA507D7$CP240932QCS,08C7F52EE43B,544D424200786710,08C7F52EE43E$CP230232PBV,D4925E099F20,544D42420061F965,D4925E099F23$CP2317320Y1,D4925E948260,544D424200681CC2,D4925E948263$CP230232F8N,D4925E086939,544D42420061D6F6,D4925E08693C$CP234532AR6,08C7F5036ED9,544D424200735FC6,08C7F5036EDC', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-30 11:18:49 Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1 1s 1s 1s 1s drop table if exists temp0000292946;-
DROP TABLE IF EXISTS temp0000292946;
Date: 2026-09-30 08:58:37 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000292946;
Date: 2026-09-30 08:58:37 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 2m27s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-09-30 08:17:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 2m7s SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (292503, 304, '465253182027,216598657177', '',034,00,'[{"item":"0","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);[ Date: 2026-09-30 17:02:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 53s405ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (292244, 503, '821075911000032,229849991533', '246610923342,,,,,', 0145, 00, '[{"item":"0","qrcode":""}]', '$$$$$', '', 00);[ Date: 2026-09-30 11:10:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 50s784ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-09-30 08:35:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 16s448ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-09-30 09:05:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 1s DROP TABLE IF EXISTS temp0000292946;[ Date: 2026-09-30 08:58:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 2,739 Total read queries
- 854 Total write queries
Queries by database
Key values
- rio Main database
- 2,360 Requests
- 5h6m3s (rio)
- Main time consuming database
Database Request type Count Duration brasilia Total 1,227 1h32m36s copy to 139 10m49s ddl 149 1m50s others 186 9m27s select 753 1h10m29s contagem Total 462 9m4s copy to 116 1m22s ddl 23 22s440ms others 5 3m select 318 4m19s rio Total 2,360 5h6m3s copy to 147 29m10s ddl 275 26m3s others 286 27m59s select 1,652 3h42m49s testes Total 21 14s276ms ddl 4 4s524ms select 16 9s529ms update 1 221ms Queries by user
Key values
- intelifix Main user
- 3,945 Requests
User Request type Count Duration etiquetas Total 8 1s740ms select 8 1s740ms intelifix Total 3,945 6h46m23s copy to 402 41m22s ddl 446 28m19s others 477 40m27s select 2,620 4h56m14s lenon Total 117 1m33s ddl 5 1s390ms select 111 1m31s update 1 221ms Duration by user
Key values
- 6h46m23s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 8 1s740ms select 8 1s740ms intelifix Total 3,945 6h46m23s copy to 402 41m22s ddl 446 28m19s others 477 40m27s select 2,620 4h56m14s lenon Total 117 1m33s ddl 5 1s390ms select 111 1m31s update 1 221ms Queries by host
Key values
- [local] Main host
- 4,061 Requests
- 6h47m56s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 2,996 Requests
- 3h21m15s (psql)
- Main time consuming application
Application Request type Count Duration [unknown] Total 2,996 2h45m16s ddl 446 28m19s select 2,550 2h16m57s pgAdmin 4 - CONN:31268 Total 5 1s575ms ddl 2 728ms select 2 624ms update 1 221ms pgAdmin 4 - CONN:412032 Total 1 273ms ddl 1 273ms pgAdmin 4 - CONN:4593780 Total 1 209ms ddl 1 209ms pgAdmin 4 - CONN:5804137 Total 1 246ms select 1 246ms pgAdmin 4 - CONN:9786099 Total 1 178ms ddl 1 178ms pg_dump Total 410 41m23s copy to 402 41m22s select 8 1s663ms psql Total 655 3h21m15s others 477 40m27s select 178 2h40m48s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-30 14:40:36 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,086 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m6s analyze verbose;[ Date: 2026-09-30 05:09:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 6m21s analyze verbose;[ Date: 2026-09-30 05:15:29 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
3 6m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-30 07:11:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 5m52s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030599, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-09-30 08:00:36 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 5m48s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030610, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-09-30 09:10:27 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 5m44s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030617, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-30 10:16:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 5m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-30 09:10:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m40s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030616, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-30 10:01:19 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 5m40s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030630, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-30 15:28:53 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 5m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-30 11:10:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m36s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030605, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-30 08:35:57 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 5m36s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030618, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-30 10:29:14 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 5m35s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030621, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-30 10:53:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 5m34s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030612, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-30 09:31:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 5m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-30 12:10:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m32s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030622, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-30 14:29:25 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-30 10:10:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-30 15:10:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m30s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030606, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-30 08:45:10 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m29s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030631, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-30 15:41:18 - 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 1h39m14s 179 154ms 5m52s 33s268ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 30 07 13 5s568ms 428ms 08 20 23m59s 1m11s 09 16 18m56s 1m11s 10 17 23m2s 1m21s 11 10 33s567ms 3s356ms 12 4 3s179ms 794ms 13 11 31s16ms 2s819ms 14 21 6m19s 18s60ms 15 19 17m7s 54s85ms 16 15 41s358ms 2s757ms 17 30 7m47s 15s597ms 18 3 6s325ms 2s108ms [ User: intelifix - Total duration: 1h39m14s - Times executed: 179 ]
[ Application: [unknown] - Total duration: 1h39m14s - Times executed: 179 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030599, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-09-30 08:00:36 Duration: 5m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030610, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-09-30 09:10:27 Duration: 5m48s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030617, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-30 10:16:40 Duration: 5m44s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1h32m34s 48 2s78ms 6m15s 1m55s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 30 07 3 6m50s 2m16s 08 3 5m49s 1m56s 09 3 6m18s 2m6s 10 3 5m49s 1m56s 11 3 5m55s 1m58s 12 3 5m52s 1m57s 13 3 5m33s 1m51s 14 3 5m40s 1m53s 15 3 5m48s 1m56s 16 3 5m41s 1m53s 17 3 5m46s 1m55s 18 3 5m27s 1m49s 19 3 5m33s 1m51s 20 3 5m31s 1m50s 21 3 5m31s 1m50s 22 3 5m24s 1m48s [ User: intelifix - Total duration: 1h32m34s - Times executed: 48 ]
[ Application: psql - Total duration: 1h32m34s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-30 07:11:16 Duration: 6m15s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-30 09:10:45 Duration: 5m44s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-30 11:10:39 Duration: 5m37s Database: rio User: intelifix Remote: [local] Application: psql
3 1h3m53s 48 242ms 3m58s 1m19s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 30 07 3 4m31s 1m30s 08 3 4m 1m20s 09 3 4m47s 1m35s 10 3 4m5s 1m21s 11 3 4m3s 1m21s 12 3 4m4s 1m21s 13 3 3m52s 1m17s 14 3 3m55s 1m18s 15 3 3m57s 1m19s 16 3 3m52s 1m17s 17 3 3m53s 1m17s 18 3 3m46s 1m15s 19 3 3m45s 1m15s 20 3 3m48s 1m16s 21 3 3m45s 1m15s 22 3 3m44s 1m14s [ User: intelifix - Total duration: 1h3m53s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m53s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-30 09:16:00 Duration: 3m58s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-30 10:14:53 Duration: 3m33s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-30 07:16:14 Duration: 3m33s Database: brasilia User: intelifix Remote: [local] Application: psql
4 18m12s 3 2m44s 9m6s 6m4s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 30 05 3 18m12s 6m4s [ User: intelifix - Total duration: 18m12s - Times executed: 3 ]
[ Application: psql - Total duration: 18m12s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-30 05:09:08 Duration: 9m6s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-30 05:15:29 Duration: 6m21s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-30 05:18:14 Duration: 2m44s Database: contagem User: intelifix Remote: [local] Application: psql
5 16m11s 101 1s168ms 38s199ms 9s615ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 30 07 2 13s642ms 6s821ms 08 2 40s774ms 20s387ms 09 2 42s749ms 21s374ms 10 7 1m20s 11s541ms 11 13 1m59s 9s158ms 12 3 8s379ms 2s793ms 13 5 57s591ms 11s518ms 14 8 1m13s 9s141ms 15 28 5m54s 12s676ms 16 17 2m 7s103ms 17 13 54s217ms 4s170ms 18 1 5s161ms 5s161ms [ User: intelifix - Total duration: 16m11s - Times executed: 101 ]
[ Application: [unknown] - Total duration: 16m11s - Times executed: 101 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-29', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-30 08:21:10 Duration: 38s199ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-30', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-30 10:24:23 Duration: 32s739ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-30', 0173, '', '', 0, 6, '2026-09-01');
Date: 2026-09-30 11:05:44 Duration: 30s925ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 11m54s 893 150ms 2m7s 800ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 30 08 120 1m1s 515ms 09 168 1m36s 575ms 10 146 1m31s 628ms 11 90 1m53s 1s260ms 12 36 26s271ms 729ms 13 38 20s574ms 541ms 14 116 1m15s 652ms 15 95 51s175ms 538ms 16 57 36s191ms 634ms 17 27 2m21s 5s232ms [ User: intelifix - Total duration: 11m54s - Times executed: 893 ]
[ Application: [unknown] - Total duration: 11m54s - Times executed: 893 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (292503, 304, '465253182027,216598657177', '',034,00,'[{"item":"0","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-30 17:02:37 Duration: 2m7s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (292244, 503, '821075911000032,229849991533', '246610923342,,,,,', 0145, 00, '[{"item":"0","qrcode":""}]', '$$$$$', '', 00);
Date: 2026-09-30 11:10:39 Duration: 53s598ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (291895, 449, 'CP241332723,08C7F53488C1,544D42420078EB46,08C7F53488C4$CP234532GS7,08C7F50455C1,544D42420073796E,08C7F50455C4$CP2304326G8,D4925E165684,544D42420062FB0F,D4925E165687$CP2330322HA,D4925EE23633,544D4242006E544C,D4925EE23636$CP2241322D5,A0B53CC2963D,544D4242005E9A4C,A0B53CC29640$CP230232J8D,D4925E08DBB1,544D42420061E3AE,D4925E08DBB4$CP240932BP5,08C7F52CFE8C,544D424200783119,08C7F52CFE8F$CP234232Q40,D4925EF91344,544D4242007247E1,D4925EF91347$CP234232S5V,D4925EF96231,544D4242007250A6,D4925EF96234$CP234232VBP,D4925EF9DB9F,544D424200725E24,D4925EF9DBA2$CP2411321UP,08C7F52FC7F9,544D42420078805E,08C7F52FC7FC$CP2227320VP,A0B53C647925,544D42420059D479,A0B53C647928$CP24113288E,08C7F530BC73,544D424200789B88,08C7F530BC76$CP232532G1Y,D4925ECD0EF9,544D4242006D57A7,D4925ECD0EFC$CP2322322WE,D4925EB3456C,544D4242006B982C,D4925EB3456F$CP22413213E,A0B53CC264AB,544D4242005E94CA,A0B53CC264AE$CP2320323F0,D4925EA4076F,544D42420069BEDD,D4925EA40772$CP234232JJS,D4925EF83EF5,544D42420072304A,D4925EF83EF8$CP234232THL,D4925EF995E8,544D424200725665,D4925EF995EB$CP230132555,D4925E0228C5,544D4242006125DC,D4925E0228C8$CP2301327GD,D4925E028235,544D424200612FCC,D4925E028238$CP230232RQD,D4925E09FA37,544D424200620384,D4925E09FA3A$CP232032A4U,D4925EA507D4,544D42420069DB5A,D4925EA507D7$CP240932QCS,08C7F52EE43B,544D424200786710,08C7F52EE43E$CP230232PBV,D4925E099F20,544D42420061F965,D4925E099F23$CP2317320Y1,D4925E948260,544D424200681CC2,D4925E948263$CP230232F8N,D4925E086939,544D42420061D6F6,D4925E08693C$CP234532AR6,08C7F5036ED9,544D424200735FC6,08C7F5036EDC', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-30 11:18:49 Duration: 4s449ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 10m46s 217 150ms 2m33s 2s978ms call rs_giga_triagem (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 30 00 8 22s898ms 2s862ms 01 7 17s233ms 2s461ms 02 6 17s494ms 2s915ms 03 7 17s289ms 2s469ms 04 6 16s892ms 2s815ms 05 6 17s228ms 2s871ms 06 6 16s575ms 2s762ms 07 6 17s305ms 2s884ms 08 7 3m39s 31s400ms 09 8 36s925ms 4s615ms 10 9 19s133ms 2s125ms 11 10 19s800ms 1s980ms 12 11 18s773ms 1s706ms 13 12 18s802ms 1s566ms 14 12 19s375ms 1s614ms 15 12 19s295ms 1s607ms 16 12 19s350ms 1s612ms 17 12 18s861ms 1s571ms 18 12 18s353ms 1s529ms 19 12 18s312ms 1s526ms 20 12 20s63ms 1s671ms 21 12 18s158ms 1s513ms 22 12 18s378ms 1s531ms [ User: intelifix - Total duration: 10m46s - Times executed: 217 ]
[ Application: psql - Total duration: 10m46s - Times executed: 217 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-30 08:17:38 Duration: 2m33s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-30 08:35:57 Duration: 54s60ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-30 09:05:24 Duration: 20s580ms Database: rio User: intelifix Remote: [local] Application: psql
8 6m9s 31 10s999ms 17s291ms 11s907ms create table temp0000292946 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 30 08 9 1m43s 11s545ms 09 11 2m4s 11s360ms 10 11 2m20s 12s749ms [ User: intelifix - Total duration: 6m9s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 6m9s - Times executed: 31 ]
-
CREATE TABLE temp0000292946 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 10:22:56 Duration: 17s291ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292946 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 10:10:08 Duration: 17s12ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292946 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 10:23:32 Duration: 12s259ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 5m25s 155 175ms 6s842ms 2s99ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 30 00 5 10s870ms 2s174ms 01 5 3s963ms 792ms 02 4 3s491ms 872ms 03 4 2s982ms 745ms 04 6 6s85ms 1s14ms 05 3 1s936ms 645ms 06 6 4s603ms 767ms 07 11 29s888ms 2s717ms 08 11 25s564ms 2s324ms 09 10 31s574ms 3s157ms 10 12 37s27ms 3s85ms 11 12 38s726ms 3s227ms 12 11 35s25ms 3s184ms 13 7 8s100ms 1s157ms 14 12 29s925ms 2s493ms 15 12 29s72ms 2s422ms 16 8 9s57ms 1s132ms 17 5 7s629ms 1s525ms 20 1 253ms 253ms 21 4 4s406ms 1s101ms 22 6 5s239ms 873ms [ User: intelifix - Total duration: 5m25s - Times executed: 155 ]
[ Application: psql - Total duration: 5m25s - Times executed: 155 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-30 09:45:08 Duration: 6s842ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-30 00:05:08 Duration: 6s808ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-30 10:05:08 Duration: 6s780ms Database: rio User: intelifix Remote: [local] Application: psql
10 4m32s 689 150ms 1s884ms 395ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 30 07 38 17s701ms 465ms 08 102 53s997ms 529ms 09 94 39s376ms 418ms 10 66 25s681ms 389ms 11 63 25s980ms 412ms 12 16 6s684ms 417ms 13 77 25s413ms 330ms 14 109 39s364ms 361ms 15 75 23s520ms 313ms 16 22 7s268ms 330ms 17 27 7s694ms 284ms [ User: intelifix - Total duration: 4m32s - Times executed: 689 ]
[ Application: [unknown] - Total duration: 4m32s - Times executed: 689 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "292166", "modelo" : "320", "itens" : "241630905154,241651002032,241699872222,241604578297,241597103539,241658991824,241695093035,241717091434,241679406363,241691623336,241734269204,241691344364,241628281431,241729046685,241732885365,241689753030,241664971521,230048515475,241629488810,241733005657,241601700004,241658506871,241708457279,241676257683,241651197785,241717114870,241678285861,241651128182,241617818489,241677622733,241657197989,241716697982,241682635051,241666326770,241709808185,241708268900,241658862339,241674624954,241730362033,241593220108,241607960110,241783909301,241658231941,241728835374,241660499614,241656546478,241678019517,241649724971", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-30 07:57:28 Duration: 1s884ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "292167", "modelo" : "320", "itens" : "241664727983,241594071010,241694247991,241650488490,241655912141,241635660827,241632334048,241713038085,241607412323,241708347998,241666144755,241654842429,241647270108,241610007076,241596410610,241593117291,230043599305,241699452630,241708401012,241734271427,241730381732,241691331030,241672070104,241599626669,241697522745,241714736680,241733082635,241694310221,241716719803,241730966569,241655277678,241708270012,241677612227,241593149416,241677543354,241620934260,241599577495,241700367073,241670081627,241690168806,241675787783,241694800022,241653882526,241609753236,241706766082,241666103337,241679557691,241677603842", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-30 08:01:13 Duration: 1s648ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "292166", "modelo" : "320", "itens" : "241604835270,241677371721,241708530722,241651134547,241679163254,241690105870,241651845559,241666405869,241647942934,241733094656,241620357985,241655479618,241731050215,241661103040,241651928496,241645603435,241669880923,241628921123,241630667779,241699098498,241635915576,241682712938,241649526870,241711580425,241658186986,241657185968,241709726584,241649828796,241599596161,241620021130,241657029208,241597084547,241727563342,241730773846,241631671425,241655224363,241700816567,241733937476,241655231738,241731107492,241650427676,241730470809,241694686878,241658178703,241731054457,241600935776,241731040618,241694776685", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-30 08:00:08 Duration: 1s615ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 3m45s 20 10s477ms 12s94ms 11s294ms create table temp0000293032 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 30 14 8 1m31s 11s424ms 15 12 2m14s 11s207ms [ User: intelifix - Total duration: 3m45s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 3m45s - Times executed: 20 ]
-
CREATE TABLE temp0000293032 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 15:22:55 Duration: 12s94ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293032 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 14:23:08 Duration: 11s979ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293032 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 14:23:47 Duration: 11s969ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 2m17s 11 10s951ms 24s764ms 12s512ms create table temp0000292920 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 30 07 4 57s938ms 14s484ms 08 4 44s695ms 11s173ms 09 3 35s2ms 11s667ms [ User: intelifix - Total duration: 2m17s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 2m17s - Times executed: 11 ]
-
CREATE TABLE temp0000292920 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 07:52:41 Duration: 24s764ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292920 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 09:03:39 Duration: 11s700ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292920 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 09:04:16 Duration: 11s678ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 2m12s 4 4s202ms 1m2s 33s115ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 30 20 2 1m5s 32s996ms 23 2 1m6s 33s235ms [ User: intelifix - Total duration: 2m12s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m12s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-30 23:16:33 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-30 20:08:35 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-30 20:10:32 Duration: 4s294ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1m49s 29 290ms 18s717ms 3s772ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 30 07 1 18s717ms 18s717ms 08 8 26s924ms 3s365ms 09 4 19s351ms 4s837ms 10 3 15s924ms 5s308ms 13 1 1s936ms 1s936ms 14 5 9s355ms 1s871ms 15 5 13s854ms 2s770ms 16 2 3s334ms 1s667ms [ User: intelifix - Total duration: 1m49s - Times executed: 29 ]
[ Application: psql - Total duration: 1m49s - Times executed: 29 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 502); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030599);
Date: 2026-09-30 07:53:46 Duration: 18s717ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030605);
Date: 2026-09-30 08:30:00 Duration: 9s219ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030613);
Date: 2026-09-30 09:39:29 Duration: 6s379ms Database: rio User: intelifix Remote: [local] Application: psql
15 1m47s 6 3s168ms 40s114ms 17s882ms 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 #15
Day Hour Count Duration Avg duration Sep 30 20 3 53s739ms 17s913ms 23 3 53s556ms 17s852ms [ User: intelifix - Total duration: 1m47s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 6 ]
-
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-09-30 20:06:23 Duration: 40s114ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-09-30 23:14:21 Duration: 39s780ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-09-30 23:33:14 Duration: 10s579ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1m45s 4 338ms 52s588ms 26s460ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 30 20 2 52s915ms 26s457ms 23 2 52s926ms 26s463ms [ User: intelifix - Total duration: 1m45s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m45s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-30 23:13:40 Duration: 52s588ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-30 20:05:41 Duration: 52s573ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-30 20:09:58 Duration: 342ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 1m34s 173 150ms 2s32ms 547ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 30 08 7 4s388ms 626ms 09 45 28s871ms 641ms 14 94 49s996ms 531ms 17 27 11s478ms 425ms [ User: intelifix - Total duration: 1m34s - Times executed: 173 ]
[ Application: [unknown] - Total duration: 1m34s - Times executed: 173 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"139056","seriais":"241771388607,241775310606,241814528798,241746642634,241778794144,241775627179,241826656065,241768090822,241739518694,241771394264,241744370415,241765571126,241744341927,241768025158,241814393556,241738537173,241738639103,241813272829,241777835173,241771465359,241765584359,241778676175,241776871735,241813987578,241739520413,241765626989,241743347979,241744369000,241769177279,241775603137,241814238287,241738442844,241762563346,241819602740","usuario":"399","observacao":""}');
Date: 2026-09-30 14:19:32 Duration: 2s32ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"139056","seriais":"241707117283,241712591724,241652303842,241712639607,241709343842,241621407493,241716393150,241656919095,241709012643,241675300408,241716481924,241704798089,241664962429,241694203846,241650588400,241714532744,241711050519,241709011734,241671641824,241675288688,241665839494,241709493958,241706859604,241710869412,241655113544,241604376785,241605990726,241663330710,241674070120,241594059112,241594106164,241691249001,241689725979,241629919009,241710164158,241694459808,241607867799,241691459504,241638203151,241689241533","usuario":"399","observacao":""}');
Date: 2026-09-30 14:22:34 Duration: 1s604ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"59782","seriais":"946A7728A865,1062D09BE5A9,A456CCE28F19,54A65C909221,70037E9E6852,D4B92F2ADB8D,54A65C8EC188,A456CCE044D2,BC9B6898B6D6,B42A0ED0D6D3,905851A751AF,A456CCE5A00E,14B7F88EB751,1062D09ED52D,54A65C907F9E,A456CCE18A60,905851429829,54A65C8A5078,D4B92F29948C,B42A0EDC1619,905851AC2AA0,80D04AB9C32A,383FB3A6E4A6","usuario":"416","observacao":""}');
Date: 2026-09-30 09:00:34 Duration: 1s518ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
18 1m33s 8 11s370ms 12s394ms 11s726ms create table temp0000292936 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 30 08 4 45s731ms 11s432ms 09 4 48s83ms 12s20ms [ User: intelifix - Total duration: 1m33s - Times executed: 8 ]
[ Application: [unknown] - Total duration: 1m33s - Times executed: 8 ]
-
CREATE TABLE temp0000292936 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 09:20:00 Duration: 12s394ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292936 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 09:02:37 Duration: 12s188ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292936 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 09:01:29 Duration: 11s786ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 1m28s 54 599ms 19s287ms 1s635ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 30 08 4 12s627ms 3s156ms 09 5 14s977ms 2s995ms 10 3 2s244ms 748ms 11 3 2s292ms 764ms 12 3 2s570ms 856ms 13 3 2s102ms 700ms 14 3 2s762ms 920ms 15 3 2s492ms 830ms 16 4 6s407ms 1s601ms 17 3 4s654ms 1s551ms 18 4 21s702ms 5s425ms 19 4 3s226ms 806ms 20 5 4s443ms 888ms 21 4 3s121ms 780ms 22 3 2s711ms 903ms [ User: intelifix - Total duration: 1m28s - Times executed: 54 ]
[ Application: psql - Total duration: 1m28s - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-30 18:00:21 Duration: 19s287ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-30 08:40:08 Duration: 6s793ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-30 09:40:07 Duration: 6s341ms Database: rio User: intelifix Remote: [local] Application: psql
20 1m23s 34 717ms 7s134ms 2s465ms 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 Sep 30 08 2 9s131ms 4s565ms 10 3 9s221ms 3s73ms 11 3 5s783ms 1s927ms 12 3 6s354ms 2s118ms 13 3 11s693ms 3s897ms 14 3 17s456ms 5s818ms 15 3 9s659ms 3s219ms 16 2 4s313ms 2s156ms 17 2 2s4ms 1s2ms 18 2 1s549ms 774ms 19 2 1s655ms 827ms 20 1 775ms 775ms 21 2 1s661ms 830ms 22 3 2s578ms 859ms [ User: intelifix - Total duration: 1m23s - Times executed: 34 ]
[ Application: psql - Total duration: 1m23s - Times executed: 34 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-30 14:20:08 Duration: 7s134ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-30 13:40:07 Duration: 6s547ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-30 08:20:07 Duration: 5s841ms Database: rio User: intelifix Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 893 11m54s 150ms 2m7s 800ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 30 08 120 1m1s 515ms 09 168 1m36s 575ms 10 146 1m31s 628ms 11 90 1m53s 1s260ms 12 36 26s271ms 729ms 13 38 20s574ms 541ms 14 116 1m15s 652ms 15 95 51s175ms 538ms 16 57 36s191ms 634ms 17 27 2m21s 5s232ms [ User: intelifix - Total duration: 11m54s - Times executed: 893 ]
[ Application: [unknown] - Total duration: 11m54s - Times executed: 893 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (292503, 304, '465253182027,216598657177', '',034,00,'[{"item":"0","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-30 17:02:37 Duration: 2m7s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (292244, 503, '821075911000032,229849991533', '246610923342,,,,,', 0145, 00, '[{"item":"0","qrcode":""}]', '$$$$$', '', 00);
Date: 2026-09-30 11:10:39 Duration: 53s598ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (291895, 449, 'CP241332723,08C7F53488C1,544D42420078EB46,08C7F53488C4$CP234532GS7,08C7F50455C1,544D42420073796E,08C7F50455C4$CP2304326G8,D4925E165684,544D42420062FB0F,D4925E165687$CP2330322HA,D4925EE23633,544D4242006E544C,D4925EE23636$CP2241322D5,A0B53CC2963D,544D4242005E9A4C,A0B53CC29640$CP230232J8D,D4925E08DBB1,544D42420061E3AE,D4925E08DBB4$CP240932BP5,08C7F52CFE8C,544D424200783119,08C7F52CFE8F$CP234232Q40,D4925EF91344,544D4242007247E1,D4925EF91347$CP234232S5V,D4925EF96231,544D4242007250A6,D4925EF96234$CP234232VBP,D4925EF9DB9F,544D424200725E24,D4925EF9DBA2$CP2411321UP,08C7F52FC7F9,544D42420078805E,08C7F52FC7FC$CP2227320VP,A0B53C647925,544D42420059D479,A0B53C647928$CP24113288E,08C7F530BC73,544D424200789B88,08C7F530BC76$CP232532G1Y,D4925ECD0EF9,544D4242006D57A7,D4925ECD0EFC$CP2322322WE,D4925EB3456C,544D4242006B982C,D4925EB3456F$CP22413213E,A0B53CC264AB,544D4242005E94CA,A0B53CC264AE$CP2320323F0,D4925EA4076F,544D42420069BEDD,D4925EA40772$CP234232JJS,D4925EF83EF5,544D42420072304A,D4925EF83EF8$CP234232THL,D4925EF995E8,544D424200725665,D4925EF995EB$CP230132555,D4925E0228C5,544D4242006125DC,D4925E0228C8$CP2301327GD,D4925E028235,544D424200612FCC,D4925E028238$CP230232RQD,D4925E09FA37,544D424200620384,D4925E09FA3A$CP232032A4U,D4925EA507D4,544D42420069DB5A,D4925EA507D7$CP240932QCS,08C7F52EE43B,544D424200786710,08C7F52EE43E$CP230232PBV,D4925E099F20,544D42420061F965,D4925E099F23$CP2317320Y1,D4925E948260,544D424200681CC2,D4925E948263$CP230232F8N,D4925E086939,544D42420061D6F6,D4925E08693C$CP234532AR6,08C7F5036ED9,544D424200735FC6,08C7F5036EDC', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-30 11:18:49 Duration: 4s449ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 689 4m32s 150ms 1s884ms 395ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 30 07 38 17s701ms 465ms 08 102 53s997ms 529ms 09 94 39s376ms 418ms 10 66 25s681ms 389ms 11 63 25s980ms 412ms 12 16 6s684ms 417ms 13 77 25s413ms 330ms 14 109 39s364ms 361ms 15 75 23s520ms 313ms 16 22 7s268ms 330ms 17 27 7s694ms 284ms [ User: intelifix - Total duration: 4m32s - Times executed: 689 ]
[ Application: [unknown] - Total duration: 4m32s - Times executed: 689 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "292166", "modelo" : "320", "itens" : "241630905154,241651002032,241699872222,241604578297,241597103539,241658991824,241695093035,241717091434,241679406363,241691623336,241734269204,241691344364,241628281431,241729046685,241732885365,241689753030,241664971521,230048515475,241629488810,241733005657,241601700004,241658506871,241708457279,241676257683,241651197785,241717114870,241678285861,241651128182,241617818489,241677622733,241657197989,241716697982,241682635051,241666326770,241709808185,241708268900,241658862339,241674624954,241730362033,241593220108,241607960110,241783909301,241658231941,241728835374,241660499614,241656546478,241678019517,241649724971", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-30 07:57:28 Duration: 1s884ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "292167", "modelo" : "320", "itens" : "241664727983,241594071010,241694247991,241650488490,241655912141,241635660827,241632334048,241713038085,241607412323,241708347998,241666144755,241654842429,241647270108,241610007076,241596410610,241593117291,230043599305,241699452630,241708401012,241734271427,241730381732,241691331030,241672070104,241599626669,241697522745,241714736680,241733082635,241694310221,241716719803,241730966569,241655277678,241708270012,241677612227,241593149416,241677543354,241620934260,241599577495,241700367073,241670081627,241690168806,241675787783,241694800022,241653882526,241609753236,241706766082,241666103337,241679557691,241677603842", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-30 08:01:13 Duration: 1s648ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "292166", "modelo" : "320", "itens" : "241604835270,241677371721,241708530722,241651134547,241679163254,241690105870,241651845559,241666405869,241647942934,241733094656,241620357985,241655479618,241731050215,241661103040,241651928496,241645603435,241669880923,241628921123,241630667779,241699098498,241635915576,241682712938,241649526870,241711580425,241658186986,241657185968,241709726584,241649828796,241599596161,241620021130,241657029208,241597084547,241727563342,241730773846,241631671425,241655224363,241700816567,241733937476,241655231738,241731107492,241650427676,241730470809,241694686878,241658178703,241731054457,241600935776,241731040618,241694776685", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-30 08:00:08 Duration: 1s615ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 217 10m46s 150ms 2m33s 2s978ms call rs_giga_triagem (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 30 00 8 22s898ms 2s862ms 01 7 17s233ms 2s461ms 02 6 17s494ms 2s915ms 03 7 17s289ms 2s469ms 04 6 16s892ms 2s815ms 05 6 17s228ms 2s871ms 06 6 16s575ms 2s762ms 07 6 17s305ms 2s884ms 08 7 3m39s 31s400ms 09 8 36s925ms 4s615ms 10 9 19s133ms 2s125ms 11 10 19s800ms 1s980ms 12 11 18s773ms 1s706ms 13 12 18s802ms 1s566ms 14 12 19s375ms 1s614ms 15 12 19s295ms 1s607ms 16 12 19s350ms 1s612ms 17 12 18s861ms 1s571ms 18 12 18s353ms 1s529ms 19 12 18s312ms 1s526ms 20 12 20s63ms 1s671ms 21 12 18s158ms 1s513ms 22 12 18s378ms 1s531ms [ User: intelifix - Total duration: 10m46s - Times executed: 217 ]
[ Application: psql - Total duration: 10m46s - Times executed: 217 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-30 08:17:38 Duration: 2m33s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-30 08:35:57 Duration: 54s60ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-30 09:05:24 Duration: 20s580ms Database: rio User: intelifix Remote: [local] Application: psql
4 179 1h39m14s 154ms 5m52s 33s268ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 30 07 13 5s568ms 428ms 08 20 23m59s 1m11s 09 16 18m56s 1m11s 10 17 23m2s 1m21s 11 10 33s567ms 3s356ms 12 4 3s179ms 794ms 13 11 31s16ms 2s819ms 14 21 6m19s 18s60ms 15 19 17m7s 54s85ms 16 15 41s358ms 2s757ms 17 30 7m47s 15s597ms 18 3 6s325ms 2s108ms [ User: intelifix - Total duration: 1h39m14s - Times executed: 179 ]
[ Application: [unknown] - Total duration: 1h39m14s - Times executed: 179 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030599, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-09-30 08:00:36 Duration: 5m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030610, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-09-30 09:10:27 Duration: 5m48s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030617, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-30 10:16:40 Duration: 5m44s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 173 1m34s 150ms 2s32ms 547ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 30 08 7 4s388ms 626ms 09 45 28s871ms 641ms 14 94 49s996ms 531ms 17 27 11s478ms 425ms [ User: intelifix - Total duration: 1m34s - Times executed: 173 ]
[ Application: [unknown] - Total duration: 1m34s - Times executed: 173 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"139056","seriais":"241771388607,241775310606,241814528798,241746642634,241778794144,241775627179,241826656065,241768090822,241739518694,241771394264,241744370415,241765571126,241744341927,241768025158,241814393556,241738537173,241738639103,241813272829,241777835173,241771465359,241765584359,241778676175,241776871735,241813987578,241739520413,241765626989,241743347979,241744369000,241769177279,241775603137,241814238287,241738442844,241762563346,241819602740","usuario":"399","observacao":""}');
Date: 2026-09-30 14:19:32 Duration: 2s32ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"139056","seriais":"241707117283,241712591724,241652303842,241712639607,241709343842,241621407493,241716393150,241656919095,241709012643,241675300408,241716481924,241704798089,241664962429,241694203846,241650588400,241714532744,241711050519,241709011734,241671641824,241675288688,241665839494,241709493958,241706859604,241710869412,241655113544,241604376785,241605990726,241663330710,241674070120,241594059112,241594106164,241691249001,241689725979,241629919009,241710164158,241694459808,241607867799,241691459504,241638203151,241689241533","usuario":"399","observacao":""}');
Date: 2026-09-30 14:22:34 Duration: 1s604ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"59782","seriais":"946A7728A865,1062D09BE5A9,A456CCE28F19,54A65C909221,70037E9E6852,D4B92F2ADB8D,54A65C8EC188,A456CCE044D2,BC9B6898B6D6,B42A0ED0D6D3,905851A751AF,A456CCE5A00E,14B7F88EB751,1062D09ED52D,54A65C907F9E,A456CCE18A60,905851429829,54A65C8A5078,D4B92F29948C,B42A0EDC1619,905851AC2AA0,80D04AB9C32A,383FB3A6E4A6","usuario":"416","observacao":""}');
Date: 2026-09-30 09:00:34 Duration: 1s518ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
6 155 5m25s 175ms 6s842ms 2s99ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 30 00 5 10s870ms 2s174ms 01 5 3s963ms 792ms 02 4 3s491ms 872ms 03 4 2s982ms 745ms 04 6 6s85ms 1s14ms 05 3 1s936ms 645ms 06 6 4s603ms 767ms 07 11 29s888ms 2s717ms 08 11 25s564ms 2s324ms 09 10 31s574ms 3s157ms 10 12 37s27ms 3s85ms 11 12 38s726ms 3s227ms 12 11 35s25ms 3s184ms 13 7 8s100ms 1s157ms 14 12 29s925ms 2s493ms 15 12 29s72ms 2s422ms 16 8 9s57ms 1s132ms 17 5 7s629ms 1s525ms 20 1 253ms 253ms 21 4 4s406ms 1s101ms 22 6 5s239ms 873ms [ User: intelifix - Total duration: 5m25s - Times executed: 155 ]
[ Application: psql - Total duration: 5m25s - Times executed: 155 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-30 09:45:08 Duration: 6s842ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-30 00:05:08 Duration: 6s808ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-30 10:05:08 Duration: 6s780ms Database: rio User: intelifix Remote: [local] Application: psql
7 101 16m11s 1s168ms 38s199ms 9s615ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 30 07 2 13s642ms 6s821ms 08 2 40s774ms 20s387ms 09 2 42s749ms 21s374ms 10 7 1m20s 11s541ms 11 13 1m59s 9s158ms 12 3 8s379ms 2s793ms 13 5 57s591ms 11s518ms 14 8 1m13s 9s141ms 15 28 5m54s 12s676ms 16 17 2m 7s103ms 17 13 54s217ms 4s170ms 18 1 5s161ms 5s161ms [ User: intelifix - Total duration: 16m11s - Times executed: 101 ]
[ Application: [unknown] - Total duration: 16m11s - Times executed: 101 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-29', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-30 08:21:10 Duration: 38s199ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-30', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-30 10:24:23 Duration: 32s739ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-30', 0173, '', '', 0, 6, '2026-09-01');
Date: 2026-09-30 11:05:44 Duration: 30s925ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 101 32s452ms 296ms 415ms 321ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 30 01 2 654ms 327ms 04 1 310ms 310ms 05 3 945ms 315ms 06 1 302ms 302ms 07 7 2s205ms 315ms 08 11 3s665ms 333ms 09 11 3s763ms 342ms 10 9 2s819ms 313ms 11 6 1s952ms 325ms 12 7 2s220ms 317ms 13 7 2s189ms 312ms 14 13 4s88ms 314ms 15 8 2s632ms 329ms 16 7 2s201ms 314ms 17 5 1s551ms 310ms 18 1 308ms 308ms 20 1 326ms 326ms 21 1 314ms 314ms [ User: lenon - Total duration: 32s452ms - Times executed: 101 ]
[ Application: [unknown] - Total duration: 32s452ms - Times executed: 101 ]
-
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-09-30 15:38:03 Duration: 415ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-30 09:05:07 Duration: 405ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-30 09:00:01 Duration: 381ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
9 91 25s735ms 254ms 347ms 282ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 30 07 2 558ms 279ms 08 15 4s324ms 288ms 09 12 3s511ms 292ms 10 4 1s232ms 308ms 11 5 1s455ms 291ms 12 2 564ms 282ms 13 3 827ms 275ms 14 11 3s118ms 283ms 15 15 4s205ms 280ms 16 8 2s159ms 269ms 17 12 3s241ms 270ms 18 2 537ms 268ms [ User: intelifix - Total duration: 25s735ms - Times executed: 91 ]
[ Application: [unknown] - Total duration: 25s735ms - Times executed: 91 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-30 10:44:51 Duration: 347ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-30 09:08:22 Duration: 341ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-09-30 09:00:30 Duration: 326ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 86 33s365ms 334ms 773ms 387ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 30 01 2 891ms 445ms 05 3 1s117ms 372ms 07 6 2s369ms 394ms 08 10 4s157ms 415ms 09 7 2s815ms 402ms 10 8 3s443ms 430ms 11 5 1s969ms 393ms 12 6 2s241ms 373ms 13 6 2s233ms 372ms 14 13 4s643ms 357ms 15 8 3s53ms 381ms 16 7 2s649ms 378ms 17 5 1s779ms 355ms [ User: intelifix - Total duration: 33s365ms - Times executed: 86 ]
[ Application: [unknown] - Total duration: 33s365ms - Times executed: 86 ]
-
select * from rs_menu_grants (80, 18, 1);
Date: 2026-09-30 10:35:07 Duration: 773ms Database: testes User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (305, 53, 1);
Date: 2026-09-30 08:15:14 Duration: 621ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (399, 5, 1);
Date: 2026-09-30 07:59:45 Duration: 545ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
11 58 28s645ms 154ms 1s692ms 493ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 30 07 12 7s270ms 605ms 08 3 1s84ms 361ms 09 3 2s738ms 912ms 10 4 3s408ms 852ms 11 3 1s642ms 547ms 13 9 3s491ms 387ms 14 8 2s665ms 333ms 15 5 2s542ms 508ms 16 6 1s927ms 321ms 17 5 1s874ms 374ms [ User: intelifix - Total duration: 28s645ms - Times executed: 58 ]
[ Application: [unknown] - Total duration: 28s645ms - Times executed: 58 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0139036) LIMIT 1;
Date: 2026-09-30 09:18:10 Duration: 1s692ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0292054) LIMIT 1;
Date: 2026-09-30 07:05:55 Duration: 1s350ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0292053) LIMIT 1;
Date: 2026-09-30 07:17:47 Duration: 1s323ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 54 1m28s 599ms 19s287ms 1s635ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 30 08 4 12s627ms 3s156ms 09 5 14s977ms 2s995ms 10 3 2s244ms 748ms 11 3 2s292ms 764ms 12 3 2s570ms 856ms 13 3 2s102ms 700ms 14 3 2s762ms 920ms 15 3 2s492ms 830ms 16 4 6s407ms 1s601ms 17 3 4s654ms 1s551ms 18 4 21s702ms 5s425ms 19 4 3s226ms 806ms 20 5 4s443ms 888ms 21 4 3s121ms 780ms 22 3 2s711ms 903ms [ User: intelifix - Total duration: 1m28s - Times executed: 54 ]
[ Application: psql - Total duration: 1m28s - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-30 18:00:21 Duration: 19s287ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-30 08:40:08 Duration: 6s793ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-30 09:40:07 Duration: 6s341ms Database: rio User: intelifix Remote: [local] Application: psql
13 48 1h32m34s 2s78ms 6m15s 1m55s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 30 07 3 6m50s 2m16s 08 3 5m49s 1m56s 09 3 6m18s 2m6s 10 3 5m49s 1m56s 11 3 5m55s 1m58s 12 3 5m52s 1m57s 13 3 5m33s 1m51s 14 3 5m40s 1m53s 15 3 5m48s 1m56s 16 3 5m41s 1m53s 17 3 5m46s 1m55s 18 3 5m27s 1m49s 19 3 5m33s 1m51s 20 3 5m31s 1m50s 21 3 5m31s 1m50s 22 3 5m24s 1m48s [ User: intelifix - Total duration: 1h32m34s - Times executed: 48 ]
[ Application: psql - Total duration: 1h32m34s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-30 07:11:16 Duration: 6m15s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-30 09:10:45 Duration: 5m44s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-30 11:10:39 Duration: 5m37s Database: rio User: intelifix Remote: [local] Application: psql
14 48 1h3m53s 242ms 3m58s 1m19s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 30 07 3 4m31s 1m30s 08 3 4m 1m20s 09 3 4m47s 1m35s 10 3 4m5s 1m21s 11 3 4m3s 1m21s 12 3 4m4s 1m21s 13 3 3m52s 1m17s 14 3 3m55s 1m18s 15 3 3m57s 1m19s 16 3 3m52s 1m17s 17 3 3m53s 1m17s 18 3 3m46s 1m15s 19 3 3m45s 1m15s 20 3 3m48s 1m16s 21 3 3m45s 1m15s 22 3 3m44s 1m14s [ User: intelifix - Total duration: 1h3m53s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m53s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-30 09:16:00 Duration: 3m58s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-30 10:14:53 Duration: 3m33s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-30 07:16:14 Duration: 3m33s Database: brasilia User: intelifix Remote: [local] Application: psql
15 39 8s333ms 150ms 381ms 213ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 30 01 11 2s665ms 242ms 05 6 1s163ms 193ms 08 2 528ms 264ms 09 1 215ms 215ms 10 5 848ms 169ms 11 7 1s535ms 219ms 12 2 305ms 152ms 14 3 612ms 204ms 15 2 458ms 229ms [ User: intelifix - Total duration: 8s333ms - Times executed: 39 ]
[ Application: [unknown] - Total duration: 8s333ms - Times executed: 39 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229985057676,229949870405,229996675769,230017181733,229983866281,229949237985,229961990724,229953172534,230012547789,229946358603', NULL, NULL, 0287, 00);
Date: 2026-09-30 01:26:09 Duration: 381ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (430, 5, '138', 6, '743AEF738C2A,1834AF9B83D6,9877E74B6BEF,84011228E030,9877E7058946,743AEFC4C956,743AEF709624,743AEFC4CC43,9877E7063A3E,9877E749B8BB,8401120780BB,743AEFAD2CA3,743AEFACD474,9877E74A01CB,9877E77D01A2,743AEF96D87E,9877E77CCA0B,9877E77E5A23,743AEFAF8CA0,9877E7BB8000,743AEF5FFC71,9877E7BB915D,840112BCF5A9,84011238A69A,1834AF25EE8B,84011228F951,840112056AF4,743AEFAD0845,840112EA160A,9877E74EAB05,9877E77CBEAB,9877E7B91862,84011205264B,9877E707785C,9877E74B7BE7,840112C0B7CE,9877E749C4D1,743AEF9ACD36,743AEF5D6562,743AEFD96F6A,840112C21AC8,743AEFAE2C3F,1834AF9AE8A9', NULL, NULL, 0153, 00);
Date: 2026-09-30 11:12:55 Duration: 320ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229921565476,229937062432,229957558999,230000312028,229959174960,229938434451,229969414949,229925973134,229945445472', NULL, NULL, 0287, 00);
Date: 2026-09-30 01:23:22 Duration: 315ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 36 1m10s 155ms 14s308ms 1s948ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 30 07 1 403ms 403ms 08 8 22s706ms 2s838ms 09 8 10s177ms 1s272ms 10 4 1s208ms 302ms 14 5 11s308ms 2s261ms 15 7 2s571ms 367ms 16 2 16s11ms 8s5ms 17 1 5s749ms 5s749ms [ User: intelifix - Total duration: 1m10s - Times executed: 36 ]
[ Application: psql - Total duration: 1m10s - Times executed: 36 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030634);
Date: 2026-09-30 16:18:29 Duration: 14s308ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030601);
Date: 2026-09-30 08:15:31 Duration: 12s96ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030625);
Date: 2026-09-30 14:55:07 Duration: 9s367ms Database: rio User: intelifix Remote: [local] Application: psql
17 34 1m23s 717ms 7s134ms 2s465ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 30 08 2 9s131ms 4s565ms 10 3 9s221ms 3s73ms 11 3 5s783ms 1s927ms 12 3 6s354ms 2s118ms 13 3 11s693ms 3s897ms 14 3 17s456ms 5s818ms 15 3 9s659ms 3s219ms 16 2 4s313ms 2s156ms 17 2 2s4ms 1s2ms 18 2 1s549ms 774ms 19 2 1s655ms 827ms 20 1 775ms 775ms 21 2 1s661ms 830ms 22 3 2s578ms 859ms [ User: intelifix - Total duration: 1m23s - Times executed: 34 ]
[ Application: psql - Total duration: 1m23s - Times executed: 34 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-30 14:20:08 Duration: 7s134ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-30 13:40:07 Duration: 6s547ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-30 08:20:07 Duration: 5s841ms Database: rio User: intelifix Remote: [local] Application: psql
18 31 6m9s 10s999ms 17s291ms 11s907ms create table temp0000292946 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 30 08 9 1m43s 11s545ms 09 11 2m4s 11s360ms 10 11 2m20s 12s749ms [ User: intelifix - Total duration: 6m9s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 6m9s - Times executed: 31 ]
-
CREATE TABLE temp0000292946 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 10:22:56 Duration: 17s291ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292946 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 10:10:08 Duration: 17s12ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292946 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 10:23:32 Duration: 12s259ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 29 1m49s 290ms 18s717ms 3s772ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 30 07 1 18s717ms 18s717ms 08 8 26s924ms 3s365ms 09 4 19s351ms 4s837ms 10 3 15s924ms 5s308ms 13 1 1s936ms 1s936ms 14 5 9s355ms 1s871ms 15 5 13s854ms 2s770ms 16 2 3s334ms 1s667ms [ User: intelifix - Total duration: 1m49s - Times executed: 29 ]
[ Application: psql - Total duration: 1m49s - Times executed: 29 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 502); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030599);
Date: 2026-09-30 07:53:46 Duration: 18s717ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030605);
Date: 2026-09-30 08:30:00 Duration: 9s219ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030613);
Date: 2026-09-30 09:39:29 Duration: 6s379ms Database: rio User: intelifix Remote: [local] Application: psql
20 27 37s824ms 1s319ms 1s601ms 1s400ms create table temp0000292898 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 30 07 27 37s824ms 1s400ms [ User: intelifix - Total duration: 37s824ms - Times executed: 27 ]
[ Application: [unknown] - Total duration: 37s824ms - Times executed: 27 ]
-
CREATE TABLE temp0000292898 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "25-09-2026", "data-ate" : "30-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-30 07:53:32 Duration: 1s601ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292898 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "25-09-2026", "data-ate" : "30-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-30 07:52:19 Duration: 1s562ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292898 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "25-09-2026", "data-ate" : "30-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-30 07:53:51 Duration: 1s528ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m44s 9m6s 6m4s 3 18m12s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 30 05 3 18m12s 6m4s [ User: intelifix - Total duration: 18m12s - Times executed: 3 ]
[ Application: psql - Total duration: 18m12s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-30 05:09:08 Duration: 9m6s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-30 05:15:29 Duration: 6m21s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-30 05:18:14 Duration: 2m44s Database: contagem User: intelifix Remote: [local] Application: psql
2 2s78ms 6m15s 1m55s 48 1h32m34s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 30 07 3 6m50s 2m16s 08 3 5m49s 1m56s 09 3 6m18s 2m6s 10 3 5m49s 1m56s 11 3 5m55s 1m58s 12 3 5m52s 1m57s 13 3 5m33s 1m51s 14 3 5m40s 1m53s 15 3 5m48s 1m56s 16 3 5m41s 1m53s 17 3 5m46s 1m55s 18 3 5m27s 1m49s 19 3 5m33s 1m51s 20 3 5m31s 1m50s 21 3 5m31s 1m50s 22 3 5m24s 1m48s [ User: intelifix - Total duration: 1h32m34s - Times executed: 48 ]
[ Application: psql - Total duration: 1h32m34s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-30 07:11:16 Duration: 6m15s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-30 09:10:45 Duration: 5m44s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-30 11:10:39 Duration: 5m37s Database: rio User: intelifix Remote: [local] Application: psql
3 242ms 3m58s 1m19s 48 1h3m53s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 30 07 3 4m31s 1m30s 08 3 4m 1m20s 09 3 4m47s 1m35s 10 3 4m5s 1m21s 11 3 4m3s 1m21s 12 3 4m4s 1m21s 13 3 3m52s 1m17s 14 3 3m55s 1m18s 15 3 3m57s 1m19s 16 3 3m52s 1m17s 17 3 3m53s 1m17s 18 3 3m46s 1m15s 19 3 3m45s 1m15s 20 3 3m48s 1m16s 21 3 3m45s 1m15s 22 3 3m44s 1m14s [ User: intelifix - Total duration: 1h3m53s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m53s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-30 09:16:00 Duration: 3m58s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-30 10:14:53 Duration: 3m33s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-30 07:16:14 Duration: 3m33s Database: brasilia User: intelifix Remote: [local] Application: psql
4 154ms 5m52s 33s268ms 179 1h39m14s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 30 07 13 5s568ms 428ms 08 20 23m59s 1m11s 09 16 18m56s 1m11s 10 17 23m2s 1m21s 11 10 33s567ms 3s356ms 12 4 3s179ms 794ms 13 11 31s16ms 2s819ms 14 21 6m19s 18s60ms 15 19 17m7s 54s85ms 16 15 41s358ms 2s757ms 17 30 7m47s 15s597ms 18 3 6s325ms 2s108ms [ User: intelifix - Total duration: 1h39m14s - Times executed: 179 ]
[ Application: [unknown] - Total duration: 1h39m14s - Times executed: 179 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030599, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-09-30 08:00:36 Duration: 5m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030610, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-09-30 09:10:27 Duration: 5m48s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030617, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-30 10:16:40 Duration: 5m44s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 4s202ms 1m2s 33s115ms 4 2m12s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 30 20 2 1m5s 32s996ms 23 2 1m6s 33s235ms [ User: intelifix - Total duration: 2m12s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m12s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-30 23:16:33 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-30 20:08:35 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-30 20:10:32 Duration: 4s294ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 338ms 52s588ms 26s460ms 4 1m45s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 30 20 2 52s915ms 26s457ms 23 2 52s926ms 26s463ms [ User: intelifix - Total duration: 1m45s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m45s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-30 23:13:40 Duration: 52s588ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-30 20:05:41 Duration: 52s573ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-30 20:09:58 Duration: 342ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 3s168ms 40s114ms 17s882ms 6 1m47s 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 #7
Day Hour Count Duration Avg duration Sep 30 20 3 53s739ms 17s913ms 23 3 53s556ms 17s852ms [ User: intelifix - Total duration: 1m47s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 6 ]
-
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-09-30 20:06:23 Duration: 40s114ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-09-30 23:14:21 Duration: 39s780ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-09-30 23:33:14 Duration: 10s579ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 10s951ms 24s764ms 12s512ms 11 2m17s create table temp0000292920 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 30 07 4 57s938ms 14s484ms 08 4 44s695ms 11s173ms 09 3 35s2ms 11s667ms [ User: intelifix - Total duration: 2m17s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 2m17s - Times executed: 11 ]
-
CREATE TABLE temp0000292920 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 07:52:41 Duration: 24s764ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292920 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 09:03:39 Duration: 11s700ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292920 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 09:04:16 Duration: 11s678ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s999ms 17s291ms 11s907ms 31 6m9s create table temp0000292946 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 30 08 9 1m43s 11s545ms 09 11 2m4s 11s360ms 10 11 2m20s 12s749ms [ User: intelifix - Total duration: 6m9s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 6m9s - Times executed: 31 ]
-
CREATE TABLE temp0000292946 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 10:22:56 Duration: 17s291ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292946 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 10:10:08 Duration: 17s12ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292946 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 10:23:32 Duration: 12s259ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 11s370ms 12s394ms 11s726ms 8 1m33s create table temp0000292936 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 30 08 4 45s731ms 11s432ms 09 4 48s83ms 12s20ms [ User: intelifix - Total duration: 1m33s - Times executed: 8 ]
[ Application: [unknown] - Total duration: 1m33s - Times executed: 8 ]
-
CREATE TABLE temp0000292936 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 09:20:00 Duration: 12s394ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292936 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 09:02:37 Duration: 12s188ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292936 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 09:01:29 Duration: 11s786ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s477ms 12s94ms 11s294ms 20 3m45s create table temp0000293032 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 30 14 8 1m31s 11s424ms 15 12 2m14s 11s207ms [ User: intelifix - Total duration: 3m45s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 3m45s - Times executed: 20 ]
-
CREATE TABLE temp0000293032 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 15:22:55 Duration: 12s94ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293032 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 14:23:08 Duration: 11s979ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293032 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-30 14:23:47 Duration: 11s969ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 1s168ms 38s199ms 9s615ms 101 16m11s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 30 07 2 13s642ms 6s821ms 08 2 40s774ms 20s387ms 09 2 42s749ms 21s374ms 10 7 1m20s 11s541ms 11 13 1m59s 9s158ms 12 3 8s379ms 2s793ms 13 5 57s591ms 11s518ms 14 8 1m13s 9s141ms 15 28 5m54s 12s676ms 16 17 2m 7s103ms 17 13 54s217ms 4s170ms 18 1 5s161ms 5s161ms [ User: intelifix - Total duration: 16m11s - Times executed: 101 ]
[ Application: [unknown] - Total duration: 16m11s - Times executed: 101 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-29', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-30 08:21:10 Duration: 38s199ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-30', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-30 10:24:23 Duration: 32s739ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-30', 0173, '', '', 0, 6, '2026-09-01');
Date: 2026-09-30 11:05:44 Duration: 30s925ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 290ms 18s717ms 3s772ms 29 1m49s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 30 07 1 18s717ms 18s717ms 08 8 26s924ms 3s365ms 09 4 19s351ms 4s837ms 10 3 15s924ms 5s308ms 13 1 1s936ms 1s936ms 14 5 9s355ms 1s871ms 15 5 13s854ms 2s770ms 16 2 3s334ms 1s667ms [ User: intelifix - Total duration: 1m49s - Times executed: 29 ]
[ Application: psql - Total duration: 1m49s - Times executed: 29 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 502); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030599);
Date: 2026-09-30 07:53:46 Duration: 18s717ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030605);
Date: 2026-09-30 08:30:00 Duration: 9s219ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030613);
Date: 2026-09-30 09:39:29 Duration: 6s379ms Database: rio User: intelifix Remote: [local] Application: psql
14 150ms 2m33s 2s978ms 217 10m46s call rs_giga_triagem (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 30 00 8 22s898ms 2s862ms 01 7 17s233ms 2s461ms 02 6 17s494ms 2s915ms 03 7 17s289ms 2s469ms 04 6 16s892ms 2s815ms 05 6 17s228ms 2s871ms 06 6 16s575ms 2s762ms 07 6 17s305ms 2s884ms 08 7 3m39s 31s400ms 09 8 36s925ms 4s615ms 10 9 19s133ms 2s125ms 11 10 19s800ms 1s980ms 12 11 18s773ms 1s706ms 13 12 18s802ms 1s566ms 14 12 19s375ms 1s614ms 15 12 19s295ms 1s607ms 16 12 19s350ms 1s612ms 17 12 18s861ms 1s571ms 18 12 18s353ms 1s529ms 19 12 18s312ms 1s526ms 20 12 20s63ms 1s671ms 21 12 18s158ms 1s513ms 22 12 18s378ms 1s531ms [ User: intelifix - Total duration: 10m46s - Times executed: 217 ]
[ Application: psql - Total duration: 10m46s - Times executed: 217 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-30 08:17:38 Duration: 2m33s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-30 08:35:57 Duration: 54s60ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-30 09:05:24 Duration: 20s580ms Database: rio User: intelifix Remote: [local] Application: psql
15 717ms 7s134ms 2s465ms 34 1m23s 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 Sep 30 08 2 9s131ms 4s565ms 10 3 9s221ms 3s73ms 11 3 5s783ms 1s927ms 12 3 6s354ms 2s118ms 13 3 11s693ms 3s897ms 14 3 17s456ms 5s818ms 15 3 9s659ms 3s219ms 16 2 4s313ms 2s156ms 17 2 2s4ms 1s2ms 18 2 1s549ms 774ms 19 2 1s655ms 827ms 20 1 775ms 775ms 21 2 1s661ms 830ms 22 3 2s578ms 859ms [ User: intelifix - Total duration: 1m23s - Times executed: 34 ]
[ Application: psql - Total duration: 1m23s - Times executed: 34 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-30 14:20:08 Duration: 7s134ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-30 13:40:07 Duration: 6s547ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-30 08:20:07 Duration: 5s841ms Database: rio User: intelifix Remote: [local] Application: psql
16 175ms 6s842ms 2s99ms 155 5m25s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 30 00 5 10s870ms 2s174ms 01 5 3s963ms 792ms 02 4 3s491ms 872ms 03 4 2s982ms 745ms 04 6 6s85ms 1s14ms 05 3 1s936ms 645ms 06 6 4s603ms 767ms 07 11 29s888ms 2s717ms 08 11 25s564ms 2s324ms 09 10 31s574ms 3s157ms 10 12 37s27ms 3s85ms 11 12 38s726ms 3s227ms 12 11 35s25ms 3s184ms 13 7 8s100ms 1s157ms 14 12 29s925ms 2s493ms 15 12 29s72ms 2s422ms 16 8 9s57ms 1s132ms 17 5 7s629ms 1s525ms 20 1 253ms 253ms 21 4 4s406ms 1s101ms 22 6 5s239ms 873ms [ User: intelifix - Total duration: 5m25s - Times executed: 155 ]
[ Application: psql - Total duration: 5m25s - Times executed: 155 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-30 09:45:08 Duration: 6s842ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-30 00:05:08 Duration: 6s808ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-30 10:05:08 Duration: 6s780ms Database: rio User: intelifix Remote: [local] Application: psql
17 155ms 14s308ms 1s948ms 36 1m10s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 30 07 1 403ms 403ms 08 8 22s706ms 2s838ms 09 8 10s177ms 1s272ms 10 4 1s208ms 302ms 14 5 11s308ms 2s261ms 15 7 2s571ms 367ms 16 2 16s11ms 8s5ms 17 1 5s749ms 5s749ms [ User: intelifix - Total duration: 1m10s - Times executed: 36 ]
[ Application: psql - Total duration: 1m10s - Times executed: 36 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030634);
Date: 2026-09-30 16:18:29 Duration: 14s308ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030601);
Date: 2026-09-30 08:15:31 Duration: 12s96ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030625);
Date: 2026-09-30 14:55:07 Duration: 9s367ms Database: rio User: intelifix Remote: [local] Application: psql
18 599ms 19s287ms 1s635ms 54 1m28s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 30 08 4 12s627ms 3s156ms 09 5 14s977ms 2s995ms 10 3 2s244ms 748ms 11 3 2s292ms 764ms 12 3 2s570ms 856ms 13 3 2s102ms 700ms 14 3 2s762ms 920ms 15 3 2s492ms 830ms 16 4 6s407ms 1s601ms 17 3 4s654ms 1s551ms 18 4 21s702ms 5s425ms 19 4 3s226ms 806ms 20 5 4s443ms 888ms 21 4 3s121ms 780ms 22 3 2s711ms 903ms [ User: intelifix - Total duration: 1m28s - Times executed: 54 ]
[ Application: psql - Total duration: 1m28s - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-30 18:00:21 Duration: 19s287ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-30 08:40:08 Duration: 6s793ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-30 09:40:07 Duration: 6s341ms Database: rio User: intelifix Remote: [local] Application: psql
19 1s319ms 1s601ms 1s400ms 27 37s824ms create table temp0000292898 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 30 07 27 37s824ms 1s400ms [ User: intelifix - Total duration: 37s824ms - Times executed: 27 ]
[ Application: [unknown] - Total duration: 37s824ms - Times executed: 27 ]
-
CREATE TABLE temp0000292898 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "25-09-2026", "data-ate" : "30-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-30 07:53:32 Duration: 1s601ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292898 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "25-09-2026", "data-ate" : "30-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-30 07:52:19 Duration: 1s562ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292898 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "25-09-2026", "data-ate" : "30-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-30 07:53:51 Duration: 1s528ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 150ms 2m7s 800ms 893 11m54s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 30 08 120 1m1s 515ms 09 168 1m36s 575ms 10 146 1m31s 628ms 11 90 1m53s 1s260ms 12 36 26s271ms 729ms 13 38 20s574ms 541ms 14 116 1m15s 652ms 15 95 51s175ms 538ms 16 57 36s191ms 634ms 17 27 2m21s 5s232ms [ User: intelifix - Total duration: 11m54s - Times executed: 893 ]
[ Application: [unknown] - Total duration: 11m54s - Times executed: 893 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (292503, 304, '465253182027,216598657177', '',034,00,'[{"item":"0","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-30 17:02:37 Duration: 2m7s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (292244, 503, '821075911000032,229849991533', '246610923342,,,,,', 0145, 00, '[{"item":"0","qrcode":""}]', '$$$$$', '', 00);
Date: 2026-09-30 11:10:39 Duration: 53s598ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (291895, 449, 'CP241332723,08C7F53488C1,544D42420078EB46,08C7F53488C4$CP234532GS7,08C7F50455C1,544D42420073796E,08C7F50455C4$CP2304326G8,D4925E165684,544D42420062FB0F,D4925E165687$CP2330322HA,D4925EE23633,544D4242006E544C,D4925EE23636$CP2241322D5,A0B53CC2963D,544D4242005E9A4C,A0B53CC29640$CP230232J8D,D4925E08DBB1,544D42420061E3AE,D4925E08DBB4$CP240932BP5,08C7F52CFE8C,544D424200783119,08C7F52CFE8F$CP234232Q40,D4925EF91344,544D4242007247E1,D4925EF91347$CP234232S5V,D4925EF96231,544D4242007250A6,D4925EF96234$CP234232VBP,D4925EF9DB9F,544D424200725E24,D4925EF9DBA2$CP2411321UP,08C7F52FC7F9,544D42420078805E,08C7F52FC7FC$CP2227320VP,A0B53C647925,544D42420059D479,A0B53C647928$CP24113288E,08C7F530BC73,544D424200789B88,08C7F530BC76$CP232532G1Y,D4925ECD0EF9,544D4242006D57A7,D4925ECD0EFC$CP2322322WE,D4925EB3456C,544D4242006B982C,D4925EB3456F$CP22413213E,A0B53CC264AB,544D4242005E94CA,A0B53CC264AE$CP2320323F0,D4925EA4076F,544D42420069BEDD,D4925EA40772$CP234232JJS,D4925EF83EF5,544D42420072304A,D4925EF83EF8$CP234232THL,D4925EF995E8,544D424200725665,D4925EF995EB$CP230132555,D4925E0228C5,544D4242006125DC,D4925E0228C8$CP2301327GD,D4925E028235,544D424200612FCC,D4925E028238$CP230232RQD,D4925E09FA37,544D424200620384,D4925E09FA3A$CP232032A4U,D4925EA507D4,544D42420069DB5A,D4925EA507D7$CP240932QCS,08C7F52EE43B,544D424200786710,08C7F52EE43E$CP230232PBV,D4925E099F20,544D42420061F965,D4925E099F23$CP2317320Y1,D4925E948260,544D424200681CC2,D4925E948263$CP230232F8N,D4925E086939,544D42420061D6F6,D4925E08693C$CP234532AR6,08C7F5036ED9,544D424200735FC6,08C7F5036EDC', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-30 11:18:49 Duration: 4s449ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 6 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 30 10 1 0ms 0ms 12 2 0ms 0ms 20 2 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 3m37s - Times executed: 6 ]
[ Application: psql - Total duration: 3m36s - Times executed: 4 ]
[ Application: [unknown] - Total duration: 751ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 17,528 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 18 FATAL entries
- 4816 ERROR entries
- 0 WARNING entries
- 16 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,448 Max number of times the same event was reported
- 4,850 Total events found
Rank Times reported Error 1 4,448 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 30 00 110 01 111 02 118 03 104 04 112 05 119 06 118 07 247 08 257 09 368 10 334 11 242 12 170 13 252 14 333 15 393 16 211 17 155 18 118 19 120 20 118 21 120 22 118 23 100 - ERROR: prepared statement "_PLAN0000000029D36FC0" does not exist
- ERROR: prepared statement "_PLAN0000000029CD4AD0" does not exist
- ERROR: prepared statement "_PLAN0000000029B61FF0" does not exist
Statement: DEALLOCATE "_PLAN0000000029D36FC0"
Date: 2026-09-30 00:00:50 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029CD4AD0"
Date: 2026-09-30 00:00:50 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029B61FF0"
Date: 2026-09-30 00:01:51 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 223 ERROR: invalid input syntax for type integer: ...
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 30 10 50 11 173 - ERROR: invalid input syntax for type integer: "undefined"
- ERROR: invalid input syntax for type integer: "undefined"
- ERROR: invalid input syntax for type integer: "undefined"
Context: PL/pgSQL function rs_pre_alerta_tela(text) line 32 at assignment
Statement: SELECT * FROM RS_PRE_ALERTA_TELA('{"barra1":"undefined","barra2":"","barra3":"","lote":"undefined"}');Date: 2026-09-30 10:55:38 Database: rio Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL function rs_pre_alerta_tela(text) line 32 at assignment
Statement: SELECT * FROM RS_PRE_ALERTA_TELA('{"barra1":"undefined","barra2":"","barra3":"","lote":"undefined"}');Date: 2026-09-30 10:55:43 Database: rio Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL function rs_pre_alerta_tela(text) line 32 at assignment
Statement: SELECT * FROM RS_PRE_ALERTA_TELA('{"barra1":"undefined","barra2":"","barra3":"","lote":"undefined"}');Date: 2026-09-30 10:55:44 Database: rio Application: [unknown] User: intelifix Remote: [local]
3 74 ERROR: cache lookup failed for type 359777
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 30 10 16 11 58 - ERROR: cache lookup failed for type 359777
- ERROR: cache lookup failed for type 359777
- ERROR: cache lookup failed for type 359777
Context: PL/pgSQL assignment "cRetEnt := RS_SERIAL_NF_ENTRADA( cBarra , aIDs[ 1 ] )" PL/pgSQL function rs_equipamento_consulta(character varying) line 114 at assignment
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('3CF9F06B5D07');Date: 2026-09-30 10:55:10 Database: rio Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL assignment "cRetEnt := RS_SERIAL_NF_ENTRADA( cBarra , aIDs[ 1 ] )" PL/pgSQL function rs_equipamento_consulta(character varying) line 114 at assignment
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('E466AB5A1B88');Date: 2026-09-30 10:55:41 Database: rio Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL assignment "cRetEnt := RS_SERIAL_NF_ENTRADA( cBarra , aIDs[ 1 ] )" PL/pgSQL function rs_equipamento_consulta(character varying) line 114 at assignment
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('ZTEGP8C01931');Date: 2026-09-30 10:55:44 Database: rio Application: [unknown] User: intelifix Remote: [local]
4 44 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 30 08 12 09 20 10 4 11 4 13 2 14 2 - ERROR: syntax error at or near "923291051415" at character 32
- ERROR: syntax error at or near "923291051415" at character 81
- ERROR: syntax error at or near "923291051415" at character 72
Statement: SELECT RS_SERIAL_TEMPORARIO( ''923291051415' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''923291051415' )
Date: 2026-09-30 08:36:15 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"138787","seriais":[{"serial":"'923291051415"},{"serial":""}]}')
Date: 2026-09-30 08:36:23 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_CASA_MASCARAS('{"modelo":"155","seriais":[{"serial":"'923291051415"},{"serial":""}]}');
Date: 2026-09-30 08:36:23 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
5 12 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 30 08 5 09 2 11 2 17 3 - LOG: process 9947 still waiting for ShareLock on transaction 6997332 after 1000.062 ms
- LOG: process 9947 still waiting for ShareLock on transaction 6997332 after 2830.716 ms
- LOG: process 9947 still waiting for ShareLock on transaction 6997332 after 4867.356 ms
Detail: Process holding the lock: 13410. Wait queue: 9947.
Context: while updating tuple (81503,98) 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-09-30 08:15:11 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 13410. Wait queue: 9947.
Context: while updating tuple (81503,98) 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-09-30 08:15:13 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 13410. Wait queue: 9947.
Context: while updating tuple (81503,98) 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-09-30 08:15:15 Database: rio Application: psql User: intelifix Remote: [local]
6 10 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 30 03 10 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-30 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-30 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-30 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
7 8 ERROR: cache lookup failed for type 369281
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 30 11 8 - ERROR: cache lookup failed for type 369281
- ERROR: cache lookup failed for type 369281
- ERROR: cache lookup failed for type 369281
Context: PL/pgSQL assignment "cRetEnt := RS_SERIAL_NF_ENTRADA( cBarra , aIDs[ 1 ] )" PL/pgSQL function rs_equipamento_consulta(character varying) line 114 at assignment
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('E820E2821A9E');Date: 2026-09-30 11:09:05 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL assignment "cRetEnt := RS_SERIAL_NF_ENTRADA( cBarra , aIDs[ 1 ] )" PL/pgSQL function rs_equipamento_consulta(character varying) line 114 at assignment
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(' E820E256BCA4');Date: 2026-09-30 11:09:14 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL assignment "cRetEnt := RS_SERIAL_NF_ENTRADA( cBarra , aIDs[ 1 ] )" PL/pgSQL function rs_equipamento_consulta(character varying) line 114 at assignment
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('E820E2AE85AC');Date: 2026-09-30 11:09:46 Database: contagem Application: [unknown] User: intelifix Remote: [local]
8 6 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 30 14 6 - ERROR: trailing junk after numeric literal at or near "2CD8AE7A129D" at character 27
- ERROR: trailing junk after numeric literal at or near "2CD8AE7A129D" at character 27
- ERROR: trailing junk after numeric literal at or near "2CD8AE7A129D" at character 27
Statement: select * from rs_caixa_qr(2CD8AE7A129D )
Date: 2026-09-30 14:23:09 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(2CD8AE7A129D )
Date: 2026-09-30 14:23:10 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(2CD8AE7A129D )
Date: 2026-09-30 14:23:14 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
9 5 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 30 00 2 08 1 16 1 18 1 - FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-30 00:02:29 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-30 00:42:32 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-30 08:43:25 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
10 5 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 30 05 4 10 1 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-30 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-30 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-30 05:32:05 Database: contagem Application: psql User: intelifix Remote: [local]
11 4 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 30 10 4 - ERROR: column "array´caux" does not exist at character 13 2026-09-30 10:14:48 -03 [148517]: [5-1] user=lenon,db=testes,app=pgAdmin 4 - CONN:31268,client=172.20.0.3 QUERY: aSeriais := ARRAY´cAux [ cAux ]
- ERROR: column "a456cce735eb" does not exist at character 27
- ERROR: column "a456cce735eb" does not exist at character 27
Context: PL/pgSQL function rs_nf_associa_equipamento(integer,boolean) line 68 at assignment
Statement: select * from rs_nf_associa_equipamento(530907,true)Date: 2026-09-30 10:14:48 Database: testes Application: pgAdmin 4 - CONN:31268 User: lenon Remote: 172.20.0.3
Statement: select * from rs_caixa_qr(A456CCE735EB )
Date: 2026-09-30 10:47:06 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(A456CCE735EB )
Date: 2026-09-30 10:47:06 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
12 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 30 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-09-30 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-30 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-30 03:05:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
13 2 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 30 12 2 - LOG: could not receive data from client: Connection timed out
- LOG: could not receive data from client: Connection timed out
Date: 2026-09-30 12:08:11 Database: postgres Application: pgAdmin 4 - DB:postgres User: lenon Remote: 172.20.0.3
Date: 2026-09-30 12:08:52 Database: testes Application: pgAdmin 4 - DB:testes User: lenon Remote: 172.20.0.3
14 1 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #14
Day Hour Count Sep 30 10 1 - ERROR: unterminated quoted string at or near "''');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-09-30 10:28:44 Database: rio Application: [unknown] User: intelifix Remote: [local]
15 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #15
Day Hour Count Sep 30 08 1 - LOG: process 47526 still waiting for AccessExclusiveLock on relation 5593931 of database 358220 after 1000.119 ms
Detail: Process holding the lock: 75138. Wait queue: 47526.
Statement: DROP TABLE IF EXISTS temp0000292946;Date: 2026-09-30 08:58:37 Database: rio Application: [unknown] User: intelifix Remote: [local]
16 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #16
Day Hour Count Sep 30 08 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000292946"
Date: 2026-09-30 08:58:37
17 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #17
Day Hour Count Sep 30 03 1 - LOG: database system was shut down at 2026-09-30 03:05:01 -03
Date: 2026-09-30 03:05:02
18 1 ERROR: function rs_numerico(...) does not exist
Times Reported Most Frequent Error / Event #18
Day Hour Count Sep 30 11 1 - ERROR: function rs_numerico(unknown) does not exist at character 8
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select rs_numerico('432')Date: 2026-09-30 11:26:37 Database: brasilia Application: pgAdmin 4 - CONN:4593780 User: lenon Remote: 172.20.0.3
19 1 ERROR: function rs_nf_associa_equipamento(...) is not unique
Times Reported Most Frequent Error / Event #19
Day Hour Count Sep 30 10 1 - ERROR: function rs_nf_associa_equipamento(integer) is not unique at character 15
Hint: Could not choose a best candidate function. You might need to add explicit type casts.
Statement: select * from rs_nf_associa_equipamento(530907)Date: 2026-09-30 10:16:01 Database: testes Application: pgAdmin 4 - CONN:31268 User: lenon Remote: 172.20.0.3