pgBadger-
Global information
- Generated on Tue Aug 18 23:50:11 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 44,466 log entries in 9s
- Log start from 2026-08-18 00:00:19 to 2026-08-18 23:50:10
-
Overview
Global Stats
- 411 Number of unique normalized queries
- 6,758 Number of queries
- 10h12m43s Total query duration
- 2026-08-18 00:02:19 First query
- 2026-08-18 23:49:16 Last query
- 6 queries/s at 2026-08-18 13:37:27 Query peak
- 10h12m43s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 10h12m43s Execute total duration
- 3,891 Number of events
- 17 Number of unique normalized events
- 3,776 Max number of times the same event was reported
- 0 Number of cancellation
- 424 Total number of automatic vacuums
- 1,068 Total number of automatic analyzes
- 13 Number temporary file
- 241.15 MiB Max size of temporary file
- 110.20 MiB Average size of temporary file
- 410 Total number of sessions
- 8 sessions at 2026-08-18 13:16:03 Session peak
- 13d5h41m46s Total duration of sessions
- 46m29s Average duration of sessions
- 16 Average queries per session
- 1m29s Average queries duration per session
- 44m59s Average idle time per session
- 422 Total number of connections
- 5 connections/s at 2026-08-18 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-08-18 13:37:27 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-18 10:06:01 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-18 23:49:09 Date
Queries duration
Key values
- 10h12m43s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 18 00 34 0ms 27s276ms 5s106ms 7s952ms 22s706ms 1m22s 01 46 0ms 4s714ms 1s89ms 5s50ms 7s661ms 8s915ms 02 18 0ms 5s40ms 2s228ms 4s386ms 7s370ms 7s730ms 03 19 0ms 4s692ms 2s194ms 5s680ms 7s541ms 9s99ms 04 25 0ms 7s349ms 1s836ms 4s556ms 7s314ms 13s165ms 05 38 0ms 10m36s 36s742ms 10s130ms 2m55s 10m36s 06 20 0ms 15s962ms 3s825ms 3s848ms 4s87ms 30s183ms 07 240 0ms 10m45s 9s971ms 1m15s 5m14s 10m59s 08 606 150ms 7m17s 5s62ms 4m5s 6m 8m39s 09 697 150ms 11m33s 5s657ms 3m24s 8m2s 11m39s 10 620 150ms 10m55s 6s532ms 5m58s 7m58s 11m3s 11 676 150ms 9m15s 3s821ms 1m3s 4m47s 9m50s 12 222 0ms 8m25s 6s913ms 39s271ms 3m33s 9m5s 13 558 0ms 6m5s 2s793ms 1m 2m24s 7m 14 793 150ms 9m19s 3s632ms 1m39s 6m18s 9m52s 15 708 150ms 10m14s 5s122ms 2m19s 7m45s 11m14s 16 596 150ms 9m18s 2s743ms 31s594ms 1m31s 9m44s 17 236 0ms 7m4s 5s284ms 22s385ms 1m18s 7m48s 18 49 0ms 6m23s 15s252ms 8s359ms 57s748ms 6m23s 19 24 0ms 5m52s 27s251ms 6s675ms 49s868ms 5m52s 20 131 0ms 7m38s 10s490ms 1m3s 1m56s 7m38s 21 38 0ms 5m56s 17s247ms 7s775ms 50s408ms 5m56s 22 32 0ms 5m44s 20s181ms 3m13s 5m44s 5m44s 23 332 0ms 1m38s 7s51ms 1m8s 1m8s 2m7s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 18 00 11 0 2s821ms 0ms 188ms 1s554ms 01 28 0 248ms 235ms 447ms 827ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 183ms 0ms 0ms 183ms 04 7 0 325ms 0ms 0ms 228ms 05 16 0 341ms 151ms 367ms 817ms 06 5 0 5s362ms 0ms 0ms 903ms 07 133 0 14s497ms 4s405ms 47s848ms 7m15s 08 452 0 5s577ms 15s192ms 4m5s 5m53s 09 531 0 6s70ms 20s637ms 2m40s 8m42s 10 487 0 7s543ms 47s720ms 5m58s 8m6s 11 513 0 4s417ms 22s582ms 1m3s 8m34s 12 115 0 11s126ms 4s941ms 8s244ms 5m47s 13 441 0 2s658ms 14s677ms 38s635ms 3m31s 14 588 0 4s231ms 19s124ms 39s847ms 8m49s 15 488 0 5s905ms 23s929ms 2m4s 8m42s 16 445 0 3s362ms 17s966ms 22s662ms 4m46s 17 145 0 7s245ms 9s762ms 19s345ms 3m55s 18 24 0 28s723ms 0ms 3s552ms 3m20s 19 6 0 1m40s 0ms 0ms 3m21s 20 21 90 11s783ms 1s469ms 1m3s 3m42s 21 16 0 37s538ms 0ms 1s283ms 5m56s 22 8 0 1m13s 47s199ms 3m13s 5m44s 23 6 326 7s51ms 1m4s 1m8s 2m7s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 18 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Aug 18 00 0 2 2.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 2 2.00 0.00% 05 0 2 2.00 0.00% 06 0 1 1.00 0.00% 07 0 12 12.00 0.00% 08 0 17 17.00 0.00% 09 0 21 21.00 0.00% 10 0 22 22.00 0.00% 11 0 16 16.00 0.00% 12 0 4 4.00 0.00% 13 0 14 14.00 0.00% 14 0 24 24.00 0.00% 15 0 21 21.00 0.00% 16 0 11 11.00 0.00% 17 0 7 7.00 0.00% 18 0 2 2.00 0.00% 19 0 0 0.00 0.00% 20 0 2 2.00 0.00% 21 0 2 2.00 0.00% 22 0 1 1.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Aug 18 00 18 0.01/s 01 16 0.00/s 02 9 0.00/s 03 20 0.01/s 04 12 0.00/s 05 11 0.00/s 06 18 0.01/s 07 18 0.01/s 08 29 0.01/s 09 30 0.01/s 10 25 0.01/s 11 24 0.01/s 12 14 0.00/s 13 26 0.01/s 14 31 0.01/s 15 24 0.01/s 16 21 0.01/s 17 17 0.00/s 18 12 0.00/s 19 10 0.00/s 20 12 0.00/s 21 10 0.00/s 22 7 0.00/s 23 8 0.00/s Day Hour Count Average Duration Average idle time Aug 18 00 8 45m38s 45m16s 01 20 43m51s 43m49s 02 10 53m8s 53m4s 03 17 19m59s 19m56s 04 10 51m51s 51m46s 05 14 44m59s 43m19s 06 10 41m53s 41m46s 07 15 54m11s 51m31s 08 24 41m59s 39m51s 09 27 44m7s 41m41s 10 26 53m1s 50m25s 11 26 48m18s 46m39s 12 19 55m6s 53m45s 13 18 45m35s 44m9s 14 27 43m21s 41m34s 15 26 51m23s 49m4s 16 22 54m8s 52m54s 17 22 50m6s 49m10s 18 15 50m49s 49m59s 19 11 47m54s 46m55s 20 14 36m11s 34m33s 21 8 47m11s 45m49s 22 9 54m46s 53m35s 23 12 33m16s 30m1s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-08-18 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 422 connections Total
Connections per user
Key values
- intelifix Main User
- 422 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-08-18 13:16:03 Date
Histogram of session times
Key values
- 274 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 410 sessions Total
Sessions per user
Key values
- intelifix Main User
- 410 sessions Total
Sessions per host
Key values
- [local] Main Host
- 410 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 45,145 buffers Checkpoint Peak
- 2026-08-18 00:09:46 Date
- 270.033 seconds Highest write time
- 0.599 seconds Sync time
Checkpoints Wal files
Key values
- 20 files Wal files usage Peak
- 2026-08-18 15:44:37 Date
Checkpoints distance
Key values
- 648.17 Mo Distance Peak
- 2026-08-18 15:44:37 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 18 00 60,057 693.226s 0.082s 693.374s 01 3,546 355.929s 0.063s 356.047s 02 1,793 180.086s 0.047s 180.168s 03 1,772 177.251s 0.745s 178.037s 04 2,028 203.608s 0.058s 203.711s 05 10,889 1,092.01s 0.163s 1,092.247s 06 6,654 397.977s 0.074s 398.075s 07 33,179 2,322.984s 0.501s 2,323.632s 08 84,346 3,238.363s 1.151s 3,239.805s 09 75,569 3,234.482s 1.597s 3,239.709s 10 107,004 3,235.462s 1.039s 3,239.622s 11 55,392 3,214.883s 0.669s 3,216.671s 12 26,021 1,824.849s 0.186s 1,825.162s 13 42,119 2,358.243s 0.971s 2,359.383s 14 71,740 3,216.378s 1.155s 3,217.76s 15 71,330 3,225.965s 0.731s 3,226.966s 16 42,810 3,168.175s 0.593s 3,168.93s 17 26,540 2,291.456s 0.225s 2,291.796s 18 4,469 408.341s 0.136s 408.522s 19 42 4.257s 0.004s 4.273s 20 1,149 161.393s 0.018s 161.424s 21 1,916 194.388s 0.022s 194.46s 22 1,792 180.141s 0.029s 180.21s 23 304 30.544s 0.008s 30.575s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 18 00 0 0 9 500 0.027s 0.01s 01 0 0 1 762 0.010s 0.009s 02 0 0 1 440 0.007s 0.006s 03 0 0 0 352 0.583s 0.017s 04 0 0 1 440 0.013s 0.006s 05 0 0 5 909 0.064s 0.009s 06 0 0 1 66 0.063s 0.004s 07 0 0 20 2,915 0.073s 0.012s 08 0 0 49 6,194 0.047s 0.012s 09 0 0 51 7,534 0.198s 0.012s 10 0 0 46 7,844 0.042s 0.012s 11 0 0 26 7,000 0.036s 0.012s 12 0 0 23 3,429 0.003s 0.012s 13 0 0 20 5,358 0.038s 0.012s 14 0 0 37 7,479 0.040s 0.012s 15 0 0 59 7,149 0.014s 0.012s 16 0 0 17 5,906 0.031s 0.012s 17 0 0 12 4,037 0.003s 0.011s 18 0 0 2 454 0.034s 0.007s 19 0 0 0 16 0.002s 0.002s 20 0 0 1 83 0.002s 0.003s 21 0 0 0 351 0.003s 0.006s 22 0 0 1 423 0.003s 0.007s 23 0 0 0 25 0.002s 0.004s Day Hour Count Avg time (sec) Aug 18 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Aug 18 00 19,353.00 kB 58,184.00 kB 01 1,909.56 kB 25,282.56 kB 02 1,501.00 kB 12,209.33 kB 03 1,388.29 kB 2,987.00 kB 04 1,736.00 kB 2,596.50 kB 05 8,900.89 kB 15,415.89 kB 06 5,730.00 kB 12,484.00 kB 07 27,699.17 kB 46,231.58 kB 08 67,079.17 kB 108,450.50 kB 09 69,312.00 kB 105,952.08 kB 10 63,345.42 kB 146,320.17 kB 11 34,809.58 kB 75,802.58 kB 12 32,047.00 kB 73,573.92 kB 13 26,691.67 kB 49,305.42 kB 14 51,017.92 kB 92,867.67 kB 15 80,607.83 kB 159,332.25 kB 16 22,661.08 kB 149,416.50 kB 17 17,368.73 kB 58,635.73 kB 18 6,497.17 kB 35,940.00 kB 19 124.00 kB 27,647.50 kB 20 5,132.67 kB 22,552.00 kB 21 1,590.67 kB 14,787.17 kB 22 1,304.29 kB 8,157.00 kB 23 188.50 kB 4,892.25 kB -
Temporary Files
Size of temporary files
Key values
- 482.30 MiB Temp Files size Peak
- 2026-08-18 05:32:03 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-18 05:32:10 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 18 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.09 GiB 112.06 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 1 104.00 MiB 104.00 MiB 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 2 208.00 MiB 104.00 MiB 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 936.68 MiB 71.93 MiB 241.15 MiB 117.09 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-18 05:32:12 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-18 05:32:03 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 3 312.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( 028630, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-18 10:19:33 Duration: 10m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028654, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-18 14:35:13 Duration: 9m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028627, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-18 09:30:17 Duration: 8m41s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 2 183.97 MiB 91.98 MiB 91.98 MiB 91.98 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-18 05:30:42 Duration: 39s816ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-18 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 241.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-18 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 241.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-18 05:32:03 - 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-08-18 15:33:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 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-08-18 10:53:28 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 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-08-18 15:42:06 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 91.98 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-18 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 91.98 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-18 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 79.57 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-18 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 79.48 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-18 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 79.48 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-18 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 72.00 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-18 05:32:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 71.93 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-18 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 71.93 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-18 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 20.96 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-18 13:58:06 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 20.96 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-18 13:58:06 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (101) Main table analyzed (database rio)
- 1,068 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 101 rio.public.temp0000288740 56 rio.pg_catalog.pg_class 51 contagem.pg_catalog.pg_attribute 47 rio.public.usuarios 47 rio.pg_catalog.pg_type 42 rio.public.temp0000288744 41 rio.public.temp0000288790 41 brasilia.pg_catalog.pg_attribute 39 contagem.public.usuarios 35 contagem.pg_catalog.pg_class 31 contagem.public.temp0000226852 29 rio.pg_catalog.pg_index 27 contagem.pg_catalog.pg_type 24 rio.pg_catalog.pg_depend 20 brasilia.pg_catalog.pg_class 19 rio.public.temp0000288590 18 brasilia.public.temp0000238382 17 brasilia.pg_catalog.pg_type 16 rio.public.temp0000288714 15 rio.public.temp0000288804 14 contagem.pg_catalog.pg_index 14 contagem.public.temp0000226870 13 rio.public.temp0000288806 12 brasilia.public.temp0000238432 11 brasilia.public.temp0000238420 11 contagem.pg_catalog.pg_depend 11 brasilia.public.temp0000238438 10 brasilia.pg_catalog.pg_index 9 brasilia.public.usuarios 9 rio.public.temp0000288718 9 rio.public.temp0000288808 9 contagem.public.temp0000226850 8 rio.public.temp0000288712 8 rio.public.temp0000288720 7 brasilia.public.temp0000238376 7 rio.public.temp0000288748 7 rio.public.temp0000288716 7 contagem.public.temp0000226866 7 brasilia.pg_catalog.pg_depend 7 rio.public.temp0000288796 6 rio.public.temp0000288834 6 rio.public.temp0000288774 6 rio.public.temp0000288754 6 rio.public.temp0000288136 5 contagem.public.temp0000226856 5 rio.public.temp0000288696 5 brasilia.public.temp0000238450 5 rio.public.temp0000288710 4 rio.public.temp0000288852 4 rio.public.temp0000288702 4 rio.public.temp0000288800 4 rio.public.temp0000288842 4 rio.public.temp0000288814 4 brasilia.public.temp0000238392 3 rio.public.temp0000288818 3 postgres.pg_catalog.pg_shdepend 3 rio.public.temp0000288700 3 rio.public.temp0000288794 3 rio.public.temp0000288708 3 template1.pg_catalog.pg_shdepend 3 rio.public.temp0000288728 3 rio.public.tmp_drill_0173 3 rio.public.temp0000288826 3 rio.public.temp0000288572 3 rio.public.temp0000288752 2 brasilia.public.nf_entrada 2 rio.pg_catalog.pg_shdepend 2 rio.public.temp0000288824 2 brasilia.public.temp0000238378 2 rio.public.temp0000288816 2 rio.public.temp0000288768 2 rio.public.temp0000288610 2 rio.public.temp0000288812 2 rio.public.temp0000288776 2 rio.public.temp0000288758 2 rio.public.temp0000288830 2 rio.public.temp0000288730 2 rio.public.temp0000288844 2 contagem.public.temp0000226858 2 rio.public.temp0000288760 1 brasilia.public.temp0000238406 1 rio.public.temp0000288746 1 rio.public.temp0000288734 1 contagem.public.parametros 1 rio.public.temp0000288772 1 rio.public.temp0000288810 1 brasilia.public.temp0000238380 1 contagem.public.nf_entrada 1 rio.public.temp0000288742 1 rio.public.temp0000288864 1 brasilia.public.temp0000238386 1 rio.public.temp0000288786 1 rio.public.temp0000288802 1 rio.public.temp0000288850 1 brasilia.public.temp0000238412 1 brasilia.public.parametros 1 brasilia.public.temp0000238436 1 brasilia.public.temp0000238390 1 rio.public.temp0000288706 1 rio.public.temp0000288846 1 rio.public.temp0000288858 1 rio.public.temp0000288600 1 rio.public.temp0000288750 1 brasilia.public.temp0000238416 1 brasilia.pg_catalog.pg_shdepend 1 rio.public.temp0000288840 1 rio.public.temp0000288832 1 brasilia.public.temp0000238388 1 brasilia.public.temp0000238442 1 contagem.pg_catalog.pg_shdepend 1 Total 1,068 Vacuums per table
Key values
- public.temp0000288740 (56) Main table vacuumed on database rio
- 424 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000288740 56 0 0 0 0 0 0 25,006 2,008 3,757,127 0 0 contagem.public.usuarios 35 0 0 0 0 0 0 178 137 75,301 0 0 rio.pg_catalog.pg_attribute 35 35 0 0 0 0 0 18,419 5,505 7,665,886 315 7,742 rio.public.temp0000288790 20 0 0 0 0 0 0 9,730 222 796,613 0 0 rio.public.temp0000288744 18 0 0 0 0 0 0 518 89 46,786 0 0 contagem.pg_catalog.pg_attribute 16 16 0 0 0 0 0 7,921 2,398 4,152,896 34 692 rio.pg_catalog.pg_class 15 15 0 0 0 0 0 2,968 1,183 1,819,324 59 274 rio.public.temp0000288714 15 0 0 0 0 0 0 10,933 1,870 3,022,272 0 0 rio.public.temp0000288590 15 0 0 0 0 0 0 670 83 51,432 0 0 rio.pg_catalog.pg_type 13 13 0 0 0 0 0 1,183 389 487,037 54 160 rio.public.usuarios 13 8 0 0 0 0 0 226 74 164,126 12 20 brasilia.pg_catalog.pg_attribute 11 11 0 0 0 0 0 5,472 1,547 2,415,596 52 1,364 rio.pg_catalog.pg_statistic 9 9 0 0 0 0 0 10,966 3,216 13,253,189 1,648 7,403 rio.pg_catalog.pg_index 9 9 0 0 0 0 0 645 181 179,318 41 90 contagem.pg_catalog.pg_class 8 8 0 0 0 0 0 1,291 432 624,480 23 54 contagem.pg_catalog.pg_type 7 7 0 0 0 0 0 664 241 359,650 5 14 rio.pg_catalog.pg_depend 7 7 0 0 0 0 0 2,229 835 1,134,306 58 550 rio.public.temp0000288834 6 0 0 0 0 0 0 545 30 37,156 0 0 brasilia.pg_catalog.pg_type 6 6 0 0 0 0 0 533 170 256,977 12 28 postgres.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 867 267 457,841 52 94 brasilia.pg_catalog.pg_class 5 5 0 0 0 0 0 922 286 495,047 16 66 rio.public.temp0000288716 5 0 0 0 0 0 0 497 110 171,446 0 0 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 214 62 62,830 3 3 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,840 497 2,195,502 141 394 rio.public.temp0000288842 4 0 0 0 0 0 0 1,750 1,748 2,343,531 0 0 brasilia.pg_catalog.pg_index 4 4 0 0 0 0 0 167 37 46,078 6 11 rio.public.temp0000288136 4 0 0 0 0 0 0 292 104 159,354 0 0 rio.public.temp0000288748 4 0 0 0 0 0 0 94 19 8,591 0 0 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 933 301 600,381 2 12 rio.public.temp0000288572 3 0 0 0 0 0 0 3,476 11 206,828 0 0 contagem.public.temp0000226866 3 0 0 0 0 0 0 335 18 22,674 0 0 rio.public.tmp_drill_0173 3 3 0 0 0 0 0 243 9 42,211 0 0 brasilia.public.temp0000238450 3 0 0 0 0 0 0 738 12 45,351 0 0 contagem.pg_catalog.pg_statistic 3 3 0 0 0 0 0 3,399 966 3,141,288 795 5,345 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,017 840 3,320,211 642 3,856 rio.public.temp0000288610 2 0 0 0 0 0 0 173 12 12,003 0 0 brasilia.pg_catalog.pg_depend 2 2 0 0 0 0 0 666 188 272,858 5 39 rio.public.temp0000288768 2 0 0 0 0 0 0 3,474 8 206,172 0 0 rio.public.temp0000288754 2 0 0 0 0 0 0 148 78 144,178 0 0 rio.public.temp0000288830 2 0 0 0 0 0 0 152 12 10,758 0 0 rio.public.temp0000288774 2 0 0 0 0 0 0 151 80 149,519 0 0 rio.public.temp0000288758 2 0 0 0 0 0 0 3,472 8 206,054 0 0 rio.public.temp0000288776 2 0 0 0 0 0 0 1,741 7 103,860 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 375 91 359,961 40 88 rio.public.temp0000288852 2 0 0 0 0 0 0 172 10 11,742 0 0 rio.public.temp0000288752 2 0 0 0 0 0 0 1,811 10 108,343 0 0 rio.public.temp0000288844 1 0 0 0 0 0 0 4 3 774 0 0 brasilia.public.temp0000238388 1 0 0 0 0 0 0 247 4 15,211 0 0 contagem.public.temp0000226852 1 0 0 0 0 0 0 111 6 7,512 0 0 rio.public.temp0000288832 1 0 0 0 0 0 0 76 6 5,379 0 0 brasilia.auditor.auditor_2026_08 1 0 0 0 0 0 0 29,507 18,941 23,861,875 5,335 111,950 rio.public.temp0000288864 1 0 0 0 0 0 0 80 6 5,618 0 0 contagem.public.lote_itens 1 1 0 0 0 0 0 11,852 9,276 29,649,300 339 9,571 rio.public.temp0000288600 1 0 0 0 0 0 0 79 6 5,544 0 0 brasilia.public.temp0000238390 1 0 0 0 0 0 0 245 4 15,058 0 0 rio.public.temp0000288800 1 0 0 0 0 0 0 76 74 143,021 0 0 contagem.public.nf_entrada_itens 1 1 0 0 0 0 0 6,488 5,267 14,897,557 109 7,210 brasilia.public.temp0000238436 1 0 0 0 0 0 0 246 4 15,117 0 0 rio.public.temp0000288846 1 0 0 0 0 0 0 137 6 9,072 0 0 rio.public.temp0000288858 1 0 0 0 0 0 0 80 6 5,618 0 0 rio.public.temp0000288706 1 0 0 0 0 0 0 8 5 1,196 0 0 rio.public.temp0000288734 1 0 0 0 0 0 0 8 5 1,265 0 0 contagem.auditor.auditor_2026_08 1 0 0 0 0 0 0 32,625 18,139 22,365,721 7,174 131,666 rio.public.temp0000288746 1 0 0 0 0 0 0 8 5 1,281 0 0 rio.auditor.auditor_2026_08 1 0 0 0 0 0 0 118,525 53,974 69,852,208 32,334 631,810 rio.public.temp0000288728 1 0 0 0 0 0 0 8 5 1,279 0 0 rio.public.temp0000288850 1 0 0 0 0 0 0 132 4 8,391 0 0 rio.public.temp0000288802 1 0 0 0 0 0 0 76 6 5,379 0 0 brasilia.public.temp0000238406 1 0 0 0 0 0 0 246 4 15,117 0 0 rio.pg_catalog.pg_constraint 1 1 0 0 0 0 0 22 9 17,406 0 0 rio.public.temp0000288712 1 0 0 0 0 0 0 8 5 1,195 0 0 rio.public.temp0000288796 1 0 0 0 0 0 0 76 6 5,379 0 0 rio.public.temp0000288794 1 0 0 0 0 0 0 76 6 5,379 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 150 38 103,130 16 27 Total 424 186 0 0 0 0 0 333,412 132,221 216,225,066 49,322 920,533 Vacuum throughput per table
Key values
- auditor.auditor_2026_08 (20.96) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000288740 0 0 1.79 contagem.public.usuarios 0 0 0.01 rio.pg_catalog.pg_attribute 0 0 3.43 rio.public.temp0000288790 0 0 0.51 rio.public.temp0000288744 0 0 0.35 contagem.pg_catalog.pg_attribute 0 0 1.54 rio.pg_catalog.pg_class 0 0 1.05 rio.public.temp0000288714 0 0 0.55 rio.public.temp0000288590 0 0 0.21 rio.pg_catalog.pg_type 0 0 0.34 rio.public.usuarios 0 0 0.01 brasilia.pg_catalog.pg_attribute 0 0 1.1 rio.pg_catalog.pg_statistic 0 0 1.64 rio.pg_catalog.pg_index 0 0 0.42 contagem.pg_catalog.pg_class 0 0 1.11 contagem.pg_catalog.pg_type 0 0 0.62 rio.pg_catalog.pg_depend 0 0 0.6 rio.public.temp0000288834 0 0 0.09 brasilia.pg_catalog.pg_type 0 0 0.41 postgres.pg_catalog.pg_shdepend 0 0 0.96 brasilia.pg_catalog.pg_class 0 0 0.75 rio.public.temp0000288716 0 0 0.07 contagem.pg_catalog.pg_index 0 0 0.27 rio.pg_toast.pg_toast_2619 0 0 0.48 rio.public.temp0000288842 0 0 0.25 brasilia.pg_catalog.pg_index 0 0 0.1 rio.public.temp0000288136 0 0 0.08 rio.public.temp0000288748 0 0 0.09 contagem.pg_catalog.pg_depend 0 0 0.58 rio.public.temp0000288572 0 0 0.18 contagem.public.temp0000226866 0 0 0.05 rio.public.tmp_drill_0173 0 0 0.01 brasilia.public.temp0000238450 0 0 0.02 contagem.pg_catalog.pg_statistic 0 0 0.38 brasilia.pg_catalog.pg_statistic 0 0 0.56 rio.public.temp0000288610 0 0 0.02 brasilia.pg_catalog.pg_depend 0 0 0.26 rio.public.temp0000288768 0 0 0.12 rio.public.temp0000288754 0 0 0.03 rio.public.temp0000288830 0 0 0.04 rio.public.temp0000288774 0 0 0.04 rio.public.temp0000288758 0 0 0.1 rio.public.temp0000288776 0 0 0.1 brasilia.pg_toast.pg_toast_2619 0 0 0.06 rio.public.temp0000288852 0 0 0.02 rio.public.temp0000288752 0 0 0.06 rio.public.temp0000288844 0 0 0 brasilia.public.temp0000238388 0 0 0 contagem.public.temp0000226852 0 0 0.03 rio.public.temp0000288832 0 0 0.02 brasilia.auditor.auditor_2026_08 0 0 7.79 rio.public.temp0000288864 0 0 0.02 contagem.public.lote_itens 0 0 5.13 rio.public.temp0000288600 0 0 0.02 brasilia.public.temp0000238390 0 0 0.01 rio.public.temp0000288800 0 0 0.02 contagem.public.nf_entrada_itens 0 0 2.72 brasilia.public.temp0000238436 0 0 0.01 rio.public.temp0000288846 0 0 0.02 rio.public.temp0000288858 0 0 0.02 rio.public.temp0000288706 0 0 0.01 rio.public.temp0000288734 0 0 0.01 contagem.auditor.auditor_2026_08 0 0 7.35 rio.public.temp0000288746 0 0 0.01 rio.auditor.auditor_2026_08 0 0 20.96 rio.public.temp0000288728 0 0 0.02 rio.public.temp0000288850 0 0 0 rio.public.temp0000288802 0 0 0.05 brasilia.public.temp0000238406 0 0 0.01 rio.pg_catalog.pg_constraint 0 0 0.03 rio.public.temp0000288712 0 0 0.01 rio.public.temp0000288796 0 0 0.02 rio.public.temp0000288794 0 0 0.02 contagem.pg_toast.pg_toast_2619 0 0 0 Total 0 0 65.77 Tuples removed per table
Key values
- pg_catalog.pg_attribute (124768) Main table with removed tuples on database rio
- 299958 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 35 35 124,768 872,495 26,329 254 20,225 contagem.pg_catalog.pg_attribute 16 16 51,343 382,083 0 93 8,436 brasilia.pg_catalog.pg_attribute 11 11 47,017 247,711 80 1 6,435 rio.pg_catalog.pg_statistic 9 9 15,331 76,807 918 0 11,574 rio.pg_catalog.pg_depend 7 7 7,691 135,913 811 0 1,246 contagem.pg_catalog.pg_statistic 3 3 6,482 22,723 0 0 3,033 rio.auditor.auditor_2026_08 1 0 6,391 11,093,308 0 0 535,123 brasilia.pg_catalog.pg_statistic 3 3 6,223 23,690 88 0 3,216 postgres.pg_catalog.pg_shdepend 5 5 4,858 67,897 0 0 620 contagem.public.lote_itens 1 1 4,555 467,738 0 0 6,849 rio.pg_catalog.pg_type 13 13 3,960 30,069 182 6 939 rio.pg_catalog.pg_class 15 15 2,417 54,321 813 51 1,599 rio.pg_catalog.pg_index 9 9 2,330 17,335 5 0 522 contagem.public.usuarios 35 0 2,167 840 0 0 70 brasilia.pg_catalog.pg_type 6 6 1,942 13,244 0 12 386 contagem.pg_catalog.pg_depend 3 3 1,696 57,026 0 0 522 contagem.pg_catalog.pg_type 7 7 1,579 15,743 0 19 444 contagem.pg_catalog.pg_class 8 8 1,330 28,166 0 0 1,039 brasilia.auditor.auditor_2026_08 1 0 1,274 2,646,433 0 0 118,963 rio.pg_toast.pg_toast_2619 4 4 1,237 2,279 14 0 1,172 contagem.public.nf_entrada_itens 1 1 1,201 439,822 0 0 4,883 brasilia.pg_catalog.pg_depend 2 2 1,059 36,111 0 0 352 brasilia.pg_catalog.pg_index 4 4 804 7,518 0 5 202 contagem.pg_catalog.pg_index 4 4 797 7,589 0 0 208 brasilia.pg_catalog.pg_class 5 5 603 16,886 0 29 528 rio.public.usuarios 13 8 549 8,023 1,406 0 273 brasilia.pg_toast.pg_toast_2619 2 2 208 266 0 0 130 contagem.pg_toast.pg_toast_2619 1 1 134 121 0 0 60 rio.pg_catalog.pg_constraint 1 1 12 1,372 0 0 37 rio.public.temp0000288844 1 0 0 5,693 0 0 128 brasilia.public.temp0000238388 1 0 0 3,221 0 0 256 contagem.public.temp0000226852 1 0 0 1,332 0 25 103 rio.public.temp0000288744 18 0 0 109,105 0 599 6,377 rio.public.temp0000288832 1 0 0 1,226 0 60 68 rio.public.temp0000288572 3 0 0 73,434 0 0 5,376 rio.public.temp0000288610 2 0 0 6,974 0 99 157 rio.public.temp0000288714 15 0 0 203,994 0 440 14,792 rio.public.temp0000288864 1 0 0 1,293 0 56 72 rio.public.temp0000288600 1 0 0 3,151 0 57 71 rio.public.temp0000288768 2 0 0 48,974 0 0 3,584 rio.public.temp0000288754 2 0 0 2,379 0 124 132 brasilia.public.temp0000238390 1 0 0 3,220 0 0 256 rio.public.temp0000288740 56 0 0 679,345 0 1,588 45,516 rio.public.temp0000288800 1 0 0 1,225 0 60 68 rio.public.temp0000288790 20 0 0 160,837 0 700 10,244 brasilia.public.temp0000238436 1 0 0 3,221 0 0 256 rio.public.temp0000288834 6 0 0 33,496 0 198 762 rio.public.temp0000288830 2 0 0 2,452 0 120 136 rio.public.temp0000288846 1 0 0 5,712 0 63 129 rio.public.temp0000288858 1 0 0 1,293 0 56 72 rio.public.temp0000288774 2 0 0 2,436 0 121 135 rio.public.temp0000288706 1 0 0 1,250 0 4 28 rio.public.temp0000288734 1 0 0 2,953 0 62 66 rio.public.temp0000288842 4 0 0 98,032 0 0 7,168 contagem.public.temp0000226866 3 0 0 3,994 0 75 309 rio.public.tmp_drill_0173 3 3 0 3,920 0 0 101 contagem.auditor.auditor_2026_08 1 0 0 2,394,737 0 0 110,565 rio.public.temp0000288758 2 0 0 48,948 0 0 3,584 rio.public.temp0000288776 2 0 0 48,976 0 0 3,584 rio.public.temp0000288746 1 0 0 1,208 0 61 67 brasilia.public.temp0000238450 3 0 0 9,663 0 0 768 rio.public.temp0000288716 5 0 0 20,263 0 183 457 rio.public.temp0000288728 1 0 0 1,178 0 63 65 rio.public.temp0000288850 1 0 0 5,694 0 0 128 rio.public.temp0000288136 4 0 0 13,855 0 136 312 rio.public.temp0000288590 15 0 0 38,275 0 410 838 rio.public.temp0000288802 1 0 0 1,225 0 60 68 brasilia.public.temp0000238406 1 0 0 3,221 0 0 256 rio.public.temp0000288852 2 0 0 7,198 0 63 161 rio.public.temp0000288712 1 0 0 1,237 0 4 28 rio.public.temp0000288752 2 0 0 25,668 0 62 1,858 rio.public.temp0000288796 1 0 0 1,225 0 60 68 rio.public.temp0000288794 1 0 0 1,225 0 60 68 rio.public.temp0000288748 4 0 0 28,034 0 186 1,990 Total 424 186 299,958 20,889,521 30,646 6,325 950,313 Pages removed per table
Key values
- public.temp0000288740 (1588) Main table with removed pages on database rio
- 6325 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000288740 56 0 0 1588 rio.public.temp0000288790 20 0 0 700 rio.public.temp0000288744 18 0 0 599 rio.public.temp0000288714 15 0 0 440 rio.public.temp0000288590 15 0 0 410 rio.pg_catalog.pg_attribute 35 35 124768 254 rio.public.temp0000288834 6 0 0 198 rio.public.temp0000288748 4 0 0 186 rio.public.temp0000288716 5 0 0 183 rio.public.temp0000288136 4 0 0 136 rio.public.temp0000288754 2 0 0 124 rio.public.temp0000288774 2 0 0 121 rio.public.temp0000288830 2 0 0 120 rio.public.temp0000288610 2 0 0 99 contagem.pg_catalog.pg_attribute 16 16 51343 93 contagem.public.temp0000226866 3 0 0 75 rio.public.temp0000288846 1 0 0 63 rio.public.temp0000288728 1 0 0 63 rio.public.temp0000288852 2 0 0 63 rio.public.temp0000288734 1 0 0 62 rio.public.temp0000288752 2 0 0 62 rio.public.temp0000288746 1 0 0 61 rio.public.temp0000288832 1 0 0 60 rio.public.temp0000288800 1 0 0 60 rio.public.temp0000288802 1 0 0 60 rio.public.temp0000288796 1 0 0 60 rio.public.temp0000288794 1 0 0 60 rio.public.temp0000288600 1 0 0 57 rio.public.temp0000288864 1 0 0 56 rio.public.temp0000288858 1 0 0 56 rio.pg_catalog.pg_class 15 15 2417 51 brasilia.pg_catalog.pg_class 5 5 603 29 contagem.public.temp0000226852 1 0 0 25 contagem.pg_catalog.pg_type 7 7 1579 19 brasilia.pg_catalog.pg_type 6 6 1942 12 rio.pg_catalog.pg_type 13 13 3960 6 brasilia.pg_catalog.pg_index 4 4 804 5 rio.public.temp0000288706 1 0 0 4 rio.public.temp0000288712 1 0 0 4 brasilia.pg_catalog.pg_attribute 11 11 47017 1 rio.public.temp0000288844 1 0 0 0 brasilia.public.temp0000238388 1 0 0 0 contagem.pg_catalog.pg_depend 3 3 1696 0 contagem.public.usuarios 35 0 2167 0 rio.pg_catalog.pg_statistic 9 9 15331 0 rio.public.temp0000288572 3 0 0 0 brasilia.auditor.auditor_2026_08 1 0 1274 0 postgres.pg_catalog.pg_shdepend 5 5 4858 0 contagem.pg_catalog.pg_index 4 4 797 0 rio.pg_catalog.pg_index 9 9 2330 0 brasilia.pg_catalog.pg_depend 2 2 1059 0 contagem.public.lote_itens 1 1 4555 0 rio.public.temp0000288768 2 0 0 0 brasilia.public.temp0000238390 1 0 0 0 contagem.public.nf_entrada_itens 1 1 1201 0 brasilia.public.temp0000238436 1 0 0 0 contagem.pg_catalog.pg_class 8 8 1330 0 rio.pg_toast.pg_toast_2619 4 4 1237 0 rio.pg_catalog.pg_depend 7 7 7691 0 rio.public.usuarios 13 8 549 0 rio.public.temp0000288842 4 0 0 0 rio.public.tmp_drill_0173 3 3 0 0 contagem.auditor.auditor_2026_08 1 0 0 0 rio.public.temp0000288758 2 0 0 0 rio.public.temp0000288776 2 0 0 0 rio.auditor.auditor_2026_08 1 0 6391 0 brasilia.public.temp0000238450 3 0 0 0 contagem.pg_catalog.pg_statistic 3 3 6482 0 brasilia.pg_toast.pg_toast_2619 2 2 208 0 rio.public.temp0000288850 1 0 0 0 brasilia.public.temp0000238406 1 0 0 0 brasilia.pg_catalog.pg_statistic 3 3 6223 0 rio.pg_catalog.pg_constraint 1 1 12 0 contagem.pg_toast.pg_toast_2619 1 1 134 0 Total 424 186 299,958 6,325 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 18 00 0 0 01 0 4 02 0 0 03 0 0 04 0 2 05 6 6 06 0 0 07 22 42 08 44 101 09 54 127 10 44 114 11 47 109 12 21 47 13 34 87 14 40 150 15 52 129 16 35 86 17 17 50 18 6 10 19 0 0 20 0 0 21 2 4 22 0 0 23 0 0 - 20.96 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 4 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 2 6m58s 1m37s 5m21s 3m29s select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028630, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-18 10:19:33 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028654, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-18 14:35:13 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028627, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-18 09:30:17 Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1 1s472ms 1s472ms 1s472ms 1s472ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276458, 404, '255044117689205,216528437294,216827572942,216821582537,216885450005,216528953843,216913604559,216414467383,216442735967,216647124646,216850353347,216451774560,216881695575,216367984957,216839413334,216567183848,216811718903,216932663445,216849789396,216683950205,216881940527,216883507188,216783435469', '',064,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-18 11:21:48 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276489, 450, '836066910000848,241732061234,241673358804,241708810525,241708826485,241654543253,241622596868,241695500202,241602671221,241692616878,241637748101,241659807896,230048413041,241618570517,241700955066,241708261425,241728533650,241728684955,241672209006,241727436786,241601110115,241727469719,241717176368,241636090622,241704740408,241680344850,241727496567,241622523046,241604336074,241659731324,241731233442,241693223234,241671530018,241730920303,241659735970,241679924248,241617366470,241731220714,241617674761', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-18 09:40:15 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276492, 503, 'ZTE3ANNQ8M21148,843C9920B793,843C9920B794,ZTEGD7BA9A09$ZTE3ANNQ9J21672,843C992DCD25,843C992DCD26,ZTEGD7BB5D53$ZTE3ANNRC506290,6C11BA62BD43,6C11BA62BD44,ZTEGDC6E2E51$ZTE3ANNR4N39425,4896D958F71E,4896D958F71F,ZTEGD97FB9C6$ZTE3ANNR8C09527,3891484F6651,3891484F6652,ZTEGDB08A5A7$ZTE3ANNT3H44248,D831399AD0A8,D831399AD0A9,ZTEGDD327D77$ZTE3ANNT3H84105,D831399E76CE,D831399E76CF,ZTEGDD331928$ZTE3ANNQ5205971,3CF9F0A7B708,3CF9F0A7B709,ZTEGD640DE8A$ZTE3ANNR1Y02243,14CA56CCDF0D,14CA56CCDF0E,ZTEGD9707F1E$ZTE3ANNR5W07722,48D6822F38C6,48D6822F38C7,ZTEGDB001E29$ZTE3ANNT2V86514,D83139937A84,D83139937A85,ZTEGDD314471$ZTE3ANNQ4N01105,3CF9F0A8AB94,3CF9F0A8AB95,ZTEGD641074C$ZTE3ANNR3Y22505,4896D951D02E,4896D951D02F,ZTEGD97E889E$ZTE3ANNQ8F09274,689E29FCFC39,689E29FCFC3A,ZTEGD7BA210A$ZTE3ANNT4P14342,F00C514CF6C2,F00C514CF6C3,ZTEGDE342E9C$ZTE3ANNR3Y03781,4896D9501956,4896D9501957,ZTEGD97E3F7A$ZTE3ANNT3H26867,D8313999394A,D8313999394B,ZTEGDD323992$ZTE3ANNQ8F13506,689E29FD5F69,689E29FD5F6A,ZTEGD7BA3192$ZTE3ANNT2V12177,D831398CAC3E,D831398CAC3F,ZTEGDD302210$ZTE3ANNR9F18235,D89A0DA48945,D89A0DA48946,ZTEGDB156E86$ZTE3ANNR3Y45871,4896D953F3D2,4896D953F3D3,ZTEGD97EE3E4$ZTE3ANNQ4N02041,3CF9F0A8C184,3CF9F0A8C185,ZTEGD6410AF4$ZTE3ANNT3F09322,D83139960644,D83139960645,ZTEGDD31B111$ZTE3ANNRAM42310,5872C98B17DD,5872C98B17DE,ZTEGDC60A545$ZTE3ANNR7B33016,3891484BF277,3891484BF278,ZTEGDB081258$ZTE3ANNQCA06665,14CA56D2E111,14CA56D2E112,ZTEGD9717F74$ZTE3ANNR5W76379,48D6823581EC,48D6823581ED,ZTEGDB012A5A$ZTE3ANNT3H23543,D8313998EB62,D8313998EB63,ZTEGDD322C96$ZTE3ANNRCB23956,D83139200076,D83139200077,ZTEGDD2A1329$ZTE3ANNR6R24547,48D68237C414,48D68237C415,ZTEGDB018AB6$ZTE3ANNRB725227,5872C9908873,5872C9908874,ZTEGDC618D5E$ZTE3ANNRC575652,6C11BA6916EF,6C11BA6916F0,ZTEGDC6F3D43$ZTE3ANNRB737565,5872C991A99F,5872C991A9A0,ZTEGDC61BD90$ZTE3ANNT2V71503,D83139921AB2,D83139921AB3,ZTEGDD3109CE$ZTE3ANNQ7506311,C4EBFF8B8726,C4EBFF8B8727,ZTEGD70A6747$ZTE3ANNR7B32772,3891484BECBF,3891484BECC0,ZTEGDB081164$ZTE3ANNRC565508,6C11BA68292F,6C11BA682930,ZTEGDC6F15A3$ZTE3ANNQ3611397,3CF9F0A5E08C,3CF9F0A5E08D,ZTEGD6409020$ZTE3ANNR6R28468,48D682381FFA,48D682381FFB,ZTEGDB019A07', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-18 09:26:46 Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1 1s42ms 1s42ms 1s42ms 1s42ms drop table if exists temp0000288744;-
DROP TABLE IF EXISTS temp0000288744;
Date: 2026-08-18 09:51:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000288744;
Date: 2026-08-18 09:51:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 5m21s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028630, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-18 10:14:22 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 1m37s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028638, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-18 10:08:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 1s472ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (278883, 404, '922411074515,3C585D7966DC$923401062368,20B82BFA1D2E$922031078940,D833B7316593$922341114508,943C96AE3C7D$922411099712,3C585D79ABC4$921211125212,38A65925012A$923191157749,186A81D4F0AC$921081117784,841EA38D6D39$921231004356,44D45460D9E0', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);[ Date: 2026-08-18 15:50:43 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 1s42ms DROP TABLE IF EXISTS temp0000288744;[ Date: 2026-08-18 09:51:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,487 Total read queries
- 1,744 Total write queries
Queries by database
Key values
- rio Main database
- 4,001 Requests
- 7h45m52s (rio)
- Main time consuming database
Database Request type Count Duration brasilia Total 1,695 2h1m31s copy to 143 13m17s ddl 361 3m41s others 250 13m37s select 941 1h30m55s contagem Total 1,062 25m19s copy to 122 1m33s ddl 190 1m49s others 7 3m28s select 742 18m26s tcl 1 408ms rio Total 4,001 7h45m52s copy to 151 32m35s ddl 776 48m45s others 270 38m17s select 2,804 5h46m13s Queries by user
Key values
- intelifix Main user
- 6,565 Requests
User Request type Count Duration etiquetas Total 66 15s310ms select 66 15s310ms intelifix Total 6,565 10h10m39s copy to 416 47m26s ddl 1,327 54m16s others 527 55m24s select 4,294 7h33m31s tcl 1 408ms lenon Total 127 1m48s select 127 1m48s Duration by user
Key values
- 10h10m39s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 66 15s310ms select 66 15s310ms intelifix Total 6,565 10h10m39s copy to 416 47m26s ddl 1,327 54m16s others 527 55m24s select 4,294 7h33m31s tcl 1 408ms lenon Total 127 1m48s select 127 1m48s Queries by host
Key values
- [local] Main host
- 6,758 Requests
- 10h12m43s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,594 Requests
- 4h47m6s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-18 14:59:46 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,058 100-500ms duration
Slowest individual queries
Rank Duration Query 1 11m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-18 09:16:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 10m55s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028630, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-18 10:19:33 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 10m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-18 07:15:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 10m36s analyze verbose;[ Date: 2026-08-18 05:10:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 10m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-18 15:15:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 9m19s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028654, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-18 14:35:13 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 9m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-18 16:14:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 9m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-18 11:14:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 8m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-18 14:13:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 8m41s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028627, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-18 09:30:17 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 8m31s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028643, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-18 11:24:24 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 8m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-18 12:13:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 8m25s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028658, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-18 15:24:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 7m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-18 10:12:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 7m41s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028638, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-18 10:14:22 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 7m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-18 20:12:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 7m25s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028666, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-18 15:46:31 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 7m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-18 08:12:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 7m15s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028613, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-18 07:32:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 7m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-18 17:12:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h26m3s 331 150ms 10m55s 26s476ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 18 07 6 12m28s 2m4s 08 46 23m45s 30s999ms 09 50 22m25s 26s905ms 10 39 38m31s 59s270ms 11 44 10m15s 13s988ms 12 6 7s62ms 1s177ms 13 37 1m19s 2s162ms 14 35 16m 27s441ms 15 36 18m27s 30s771ms 16 19 32s447ms 1s707ms 17 10 1m45s 10s535ms 18 3 23s716ms 7s905ms [ User: intelifix - Total duration: 2h26m3s - Times executed: 331 ]
[ Application: [unknown] - Total duration: 2h26m3s - Times executed: 331 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028630, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-18 10:19:33 Duration: 10m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028654, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-18 14:35:13 Duration: 9m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028627, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-18 09:30:17 Duration: 8m41s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 2h18m45s 48 1s633ms 11m33s 2m53s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 18 07 3 11m43s 3m54s 08 3 7m37s 2m32s 09 3 13m28s 4m29s 10 3 8m16s 2m45s 11 3 10m14s 3m24s 12 3 8m57s 2m59s 13 3 6m25s 2m8s 14 3 9m43s 3m14s 15 3 11m13s 3m44s 16 3 10m17s 3m25s 17 3 7m23s 2m27s 18 3 6m42s 2m14s 19 3 6m10s 2m3s 20 3 8m12s 2m44s 21 3 6m15s 2m5s 22 3 6m2s 2m [ User: intelifix - Total duration: 2h18m45s - Times executed: 48 ]
[ Application: psql - Total duration: 2h18m45s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-18 09:16:35 Duration: 11m33s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-18 07:15:46 Duration: 10m45s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-18 15:15:16 Duration: 10m14s Database: rio User: intelifix Remote: [local] Application: psql
3 1h22m22s 48 218ms 6m38s 1m42s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 18 07 3 5m57s 1m59s 08 3 5m5s 1m41s 09 3 9m12s 3m4s 10 3 4m27s 1m29s 11 3 5m57s 1m59s 12 3 4m43s 1m34s 13 3 3m53s 1m17s 14 3 6m13s 2m4s 15 3 6m13s 2m4s 16 3 5m55s 1m58s 17 3 4m25s 1m28s 18 3 3m58s 1m19s 19 3 3m52s 1m17s 20 3 5m3s 1m41s 21 3 3m40s 1m13s 22 3 3m42s 1m14s [ User: intelifix - Total duration: 1h22m22s - Times executed: 48 ]
[ Application: psql - Total duration: 1h22m22s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-18 09:27:19 Duration: 6m38s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-18 14:20:38 Duration: 4m42s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-18 15:22:20 Duration: 4m40s Database: brasilia User: intelifix Remote: [local] Application: psql
4 36m1s 1,320 150ms 11s615ms 1s637ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 18 07 8 4s754ms 594ms 08 104 2m15s 1s303ms 09 148 4m26s 1s800ms 10 157 4m30s 1s721ms 11 188 6m11s 1s977ms 12 46 1m2s 1s347ms 13 85 2m56s 2s76ms 14 195 5m2s 1s548ms 15 185 4m39s 1s509ms 16 138 3m15s 1s419ms 17 66 1m36s 1s468ms [ User: intelifix - Total duration: 36m1s - Times executed: 1320 ]
[ Application: [unknown] - Total duration: 36m1s - Times executed: 1320 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276458, 404, '255044117689205,216528437294,216827572942,216821582537,216885450005,216528953843,216913604559,216414467383,216442735967,216647124646,216850353347,216451774560,216881695575,216367984957,216839413334,216567183848,216811718903,216932663445,216849789396,216683950205,216881940527,216883507188,216783435469', '',064,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-18 11:21:48 Duration: 11s615ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276489, 450, '836066910000848,241732061234,241673358804,241708810525,241708826485,241654543253,241622596868,241695500202,241602671221,241692616878,241637748101,241659807896,230048413041,241618570517,241700955066,241708261425,241728533650,241728684955,241672209006,241727436786,241601110115,241727469719,241717176368,241636090622,241704740408,241680344850,241727496567,241622523046,241604336074,241659731324,241731233442,241693223234,241671530018,241730920303,241659735970,241679924248,241617366470,241731220714,241617674761', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-18 09:40:15 Duration: 10s830ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276492, 503, 'ZTE3ANNQ8M21148,843C9920B793,843C9920B794,ZTEGD7BA9A09$ZTE3ANNQ9J21672,843C992DCD25,843C992DCD26,ZTEGD7BB5D53$ZTE3ANNRC506290,6C11BA62BD43,6C11BA62BD44,ZTEGDC6E2E51$ZTE3ANNR4N39425,4896D958F71E,4896D958F71F,ZTEGD97FB9C6$ZTE3ANNR8C09527,3891484F6651,3891484F6652,ZTEGDB08A5A7$ZTE3ANNT3H44248,D831399AD0A8,D831399AD0A9,ZTEGDD327D77$ZTE3ANNT3H84105,D831399E76CE,D831399E76CF,ZTEGDD331928$ZTE3ANNQ5205971,3CF9F0A7B708,3CF9F0A7B709,ZTEGD640DE8A$ZTE3ANNR1Y02243,14CA56CCDF0D,14CA56CCDF0E,ZTEGD9707F1E$ZTE3ANNR5W07722,48D6822F38C6,48D6822F38C7,ZTEGDB001E29$ZTE3ANNT2V86514,D83139937A84,D83139937A85,ZTEGDD314471$ZTE3ANNQ4N01105,3CF9F0A8AB94,3CF9F0A8AB95,ZTEGD641074C$ZTE3ANNR3Y22505,4896D951D02E,4896D951D02F,ZTEGD97E889E$ZTE3ANNQ8F09274,689E29FCFC39,689E29FCFC3A,ZTEGD7BA210A$ZTE3ANNT4P14342,F00C514CF6C2,F00C514CF6C3,ZTEGDE342E9C$ZTE3ANNR3Y03781,4896D9501956,4896D9501957,ZTEGD97E3F7A$ZTE3ANNT3H26867,D8313999394A,D8313999394B,ZTEGDD323992$ZTE3ANNQ8F13506,689E29FD5F69,689E29FD5F6A,ZTEGD7BA3192$ZTE3ANNT2V12177,D831398CAC3E,D831398CAC3F,ZTEGDD302210$ZTE3ANNR9F18235,D89A0DA48945,D89A0DA48946,ZTEGDB156E86$ZTE3ANNR3Y45871,4896D953F3D2,4896D953F3D3,ZTEGD97EE3E4$ZTE3ANNQ4N02041,3CF9F0A8C184,3CF9F0A8C185,ZTEGD6410AF4$ZTE3ANNT3F09322,D83139960644,D83139960645,ZTEGDD31B111$ZTE3ANNRAM42310,5872C98B17DD,5872C98B17DE,ZTEGDC60A545$ZTE3ANNR7B33016,3891484BF277,3891484BF278,ZTEGDB081258$ZTE3ANNQCA06665,14CA56D2E111,14CA56D2E112,ZTEGD9717F74$ZTE3ANNR5W76379,48D6823581EC,48D6823581ED,ZTEGDB012A5A$ZTE3ANNT3H23543,D8313998EB62,D8313998EB63,ZTEGDD322C96$ZTE3ANNRCB23956,D83139200076,D83139200077,ZTEGDD2A1329$ZTE3ANNR6R24547,48D68237C414,48D68237C415,ZTEGDB018AB6$ZTE3ANNRB725227,5872C9908873,5872C9908874,ZTEGDC618D5E$ZTE3ANNRC575652,6C11BA6916EF,6C11BA6916F0,ZTEGDC6F3D43$ZTE3ANNRB737565,5872C991A99F,5872C991A9A0,ZTEGDC61BD90$ZTE3ANNT2V71503,D83139921AB2,D83139921AB3,ZTEGDD3109CE$ZTE3ANNQ7506311,C4EBFF8B8726,C4EBFF8B8727,ZTEGD70A6747$ZTE3ANNR7B32772,3891484BECBF,3891484BECC0,ZTEGDB081164$ZTE3ANNRC565508,6C11BA68292F,6C11BA682930,ZTEGDC6F15A3$ZTE3ANNQ3611397,3CF9F0A5E08C,3CF9F0A5E08D,ZTEGD6409020$ZTE3ANNR6R28468,48D682381FFA,48D682381FFB,ZTEGDB019A07', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-18 09:26:46 Duration: 9s323ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 20m21s 3 2m55s 10m36s 6m47s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 18 05 3 20m21s 6m47s [ User: intelifix - Total duration: 20m21s - Times executed: 3 ]
[ Application: psql - Total duration: 20m21s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-18 05:10:38 Duration: 10m36s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-18 05:17:27 Duration: 6m49s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-18 05:20:23 Duration: 2m55s Database: contagem User: intelifix Remote: [local] Application: psql
6 13m56s 145 208ms 2m10s 5s766ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 18 00 6 42s370ms 7s61ms 01 6 17s125ms 2s854ms 02 6 14s48ms 2s341ms 03 5 15s604ms 3s120ms 04 6 20s689ms 3s448ms 05 5 14s45ms 2s809ms 07 11 49s127ms 4s466ms 08 12 1m4s 5s344ms 09 12 1m57s 9s831ms 10 12 1m13s 6s125ms 11 6 24s588ms 4s98ms 12 7 10s81ms 1s440ms 13 8 2m21s 17s667ms 14 12 1m5s 5s484ms 15 10 1m1s 6s191ms 16 5 8s642ms 1s728ms 17 5 1m18s 15s666ms 20 1 208ms 208ms 21 4 6s715ms 1s678ms 22 6 9s880ms 1s646ms [ User: intelifix - Total duration: 13m56s - Times executed: 145 ]
[ Application: psql - Total duration: 13m56s - Times executed: 145 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-18 13:47:11 Duration: 2m10s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-18 17:46:15 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-18 00:05:29 Duration: 27s276ms Database: rio User: intelifix Remote: [local] Application: psql
7 13m28s 1,057 150ms 7s932ms 764ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 18 07 50 48s75ms 961ms 08 112 1m15s 677ms 09 129 1m38s 761ms 10 150 1m43s 687ms 11 98 1m8s 695ms 12 13 11s872ms 913ms 13 125 1m26s 690ms 14 124 1m36s 780ms 15 68 1m3s 938ms 16 171 2m12s 773ms 17 17 23s555ms 1s385ms [ User: intelifix - Total duration: 13m28s - Times executed: 1057 ]
[ Application: [unknown] - Total duration: 13m28s - Times executed: 1057 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "279002", "modelo" : "320", "itens" : "241688900007,241645824545,241717186369,241621046571,241660751637,241672211431,241631102626,241594190113,241603787378,241615130619,241630182727,241709742344,241703351114,241690179716,230049252528,241655156174,241668236878,241620835866,241704646178,241655508587,241598871939,241593713545,241609849306,241631468295,230048531212,241664804052,241639118706,241701304550,241645522945,241671498599", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-18 17:29:57 Duration: 7s932ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "278791", "modelo" : "320", "itens" : "241658500407,241629326369,241651084969,241637804447,241679534154,241669945777,241592240708,230055065463,241666334549,241619613132,241657047492,241617110913,241666097376,241712266686,241673288493,241628888088,241603359604,241708405759,241666438701,241603365362,241619745367,241593168485,241639110019,241637820005,241700285674,241669934665,241639386969,241604195555,241706599499,241651980422,241617561114,241667983240,241651087696,241606226887,241645520723,241614895870,241630752637,241651186572,241653995264,241634529919,241637519515,241651075675,241709801216,241618142944,241635408602,241658672646,230055033036,241682647375", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-18 07:07:55 Duration: 4s563ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "241543", "modelo" : "305", "itens" : "241681680425,229951637288,230030840103,241670918789,241681802232,241639716777,241683134348,241681571727,241683058000,241656187172", "usuario" : "414", "caixa" : "2880602", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-18 13:37:45 Duration: 4s204ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 12m56s 59 10s705ms 19s640ms 13s168ms create table temp0000288740 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 18 08 12 2m30s 12s520ms 09 12 2m46s 13s910ms 10 3 41s538ms 13s846ms 11 6 1m15s 12s516ms 12 3 34s573ms 11s524ms 14 12 2m43s 13s625ms 15 11 2m25s 13s184ms [ User: intelifix - Total duration: 12m56s - Times executed: 59 ]
[ Application: [unknown] - Total duration: 12m56s - Times executed: 59 ]
-
CREATE TABLE temp0000288740 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 14:23:19 Duration: 19s640ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288740 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 09:21:30 Duration: 15s419ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288740 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 09:19:33 Duration: 15s302ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 11m39s 275 162ms 17s585ms 2s542ms call rs_giga_triagem (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 18 00 12 39s815ms 3s317ms 01 12 26s5ms 2s167ms 02 12 26s68ms 2s172ms 03 12 25s181ms 2s98ms 04 12 22s938ms 1s911ms 05 12 25s451ms 2s120ms 06 12 24s97ms 2s8ms 07 11 25s134ms 2s284ms 08 12 31s415ms 2s617ms 09 12 35s863ms 2s988ms 10 12 32s30ms 2s669ms 11 12 39s250ms 3s270ms 12 12 27s585ms 2s298ms 13 12 27s143ms 2s261ms 14 12 36s688ms 3s57ms 15 12 47s703ms 3s975ms 16 12 30s380ms 2s531ms 17 12 29s18ms 2s418ms 18 12 28s458ms 2s371ms 19 12 25s752ms 2s146ms 20 12 41s355ms 3s446ms 21 12 25s858ms 2s154ms 22 12 26s88ms 2s174ms [ User: intelifix - Total duration: 11m39s - Times executed: 275 ]
[ Application: psql - Total duration: 11m39s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-18 20:15:18 Duration: 17s585ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-18 00:05:43 Duration: 14s327ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-18 11:25:14 Duration: 13s42ms Database: rio User: intelifix Remote: [local] Application: psql
10 9m40s 63 1s146ms 43s891ms 9s209ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 18 07 2 13s181ms 6s590ms 08 3 9s407ms 3s135ms 09 2 16s962ms 8s481ms 10 7 1m4s 9s151ms 11 7 1m9s 9s924ms 12 1 1s360ms 1s360ms 13 5 1m10s 14s68ms 14 6 56s30ms 9s338ms 15 12 1m50s 9s176ms 16 9 1m42s 11s424ms 17 9 1m6s 7s383ms [ User: intelifix - Total duration: 9m40s - Times executed: 63 ]
[ Application: [unknown] - Total duration: 9m40s - Times executed: 63 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-18', 0175, '', '', 0, 6, '2026-08-01');
Date: 2026-08-18 13:30:43 Duration: 43s891ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-18', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-18 11:17:31 Duration: 43s875ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-18', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-18 10:38:26 Duration: 43s263ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 5m53s 2 5s401ms 5m47s 2m56s select * from rs_fast_excel (?, ?) / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 18 12 1 5m47s 5m47s 17 1 5s401ms 5s401ms [ User: intelifix - Total duration: 5m53s - Times executed: 2 ]
[ Application: [unknown] - Total duration: 5m53s - Times executed: 2 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028651, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx') / 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-08-18 12:20:00 Duration: 5m47s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/excluir.xlsx'') ;', '/var/www/html/tmp/temp_83.xlsx') / 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-08-18 17:39:51 Duration: 5s401ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
12 5m10s 21 11s213ms 43s671ms 14s794ms create table temp0000288790 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 18 13 4 1m21s 20s469ms 15 17 3m48s 13s459ms [ User: intelifix - Total duration: 5m10s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 5m10s - Times executed: 21 ]
-
CREATE TABLE temp0000288790 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 13:40:24 Duration: 43s671ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288790 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 15:29:17 Duration: 15s759ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288790 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 15:36:44 Duration: 15s287ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 4m51s 22 10s508ms 52s83ms 13s258ms create table temp0000288714 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 18 07 17 3m50s 13s550ms 08 5 1m1s 12s267ms [ User: intelifix - Total duration: 4m51s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 4m51s - Times executed: 22 ]
-
CREATE TABLE temp0000288714 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 07:16:41 Duration: 52s83ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288714 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 08:11:52 Duration: 13s999ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288714 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 08:12:11 Duration: 12s570ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 4m34s 36 196ms 31s772ms 7s627ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 18 07 3 30s854ms 10s284ms 08 5 21s344ms 4s268ms 09 5 34s30ms 6s806ms 10 5 23s372ms 4s674ms 11 2 34s636ms 17s318ms 12 4 16s827ms 4s206ms 13 1 31s772ms 31s772ms 14 2 31s670ms 15s835ms 15 7 48s442ms 6s920ms 18 2 1s641ms 820ms [ User: intelifix - Total duration: 4m34s - Times executed: 36 ]
[ Application: psql - Total duration: 4m34s - Times executed: 36 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028652);
Date: 2026-08-18 13:45:27 Duration: 31s772ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028643);
Date: 2026-08-18 11:15:50 Duration: 30s111ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028654);
Date: 2026-08-18 14:25:47 Duration: 27s107ms Database: rio User: intelifix Remote: [local] Application: psql
15 4m6s 20 10s538ms 15s411ms 12s308ms create table temp0000288744 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 18 08 1 12s706ms 12s706ms 09 8 1m46s 13s288ms 11 3 35s272ms 11s757ms 12 8 1m31s 11s485ms [ User: intelifix - Total duration: 4m6s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 4m6s - Times executed: 20 ]
-
CREATE TABLE temp0000288744 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 09:51:39 Duration: 15s411ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288744 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 09:51:09 Duration: 14s867ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288744 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 09:49:07 Duration: 13s573ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 4m4s 59 218ms 1m55s 4s143ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 18 07 6 5s262ms 877ms 08 8 24s556ms 3s69ms 09 12 15s721ms 1s310ms 10 4 56s785ms 14s196ms 11 4 2s912ms 728ms 12 5 1s704ms 340ms 13 1 396ms 396ms 14 4 3s601ms 900ms 15 15 2m13s 8s901ms [ User: intelifix - Total duration: 4m4s - Times executed: 59 ]
[ Application: psql - Total duration: 4m4s - Times executed: 59 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028662);
Date: 2026-08-18 15:37:10 Duration: 1m55s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028641);
Date: 2026-08-18 10:54:51 Duration: 52s725ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028622);
Date: 2026-08-18 08:35:40 Duration: 19s587ms Database: rio User: intelifix Remote: [local] Application: psql
17 3m50s 61 168ms 5s207ms 3s771ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 18 08 5 19s73ms 3s814ms 09 5 14s899ms 2s979ms 10 5 19s342ms 3s868ms 11 4 15s453ms 3s863ms 12 5 19s720ms 3s944ms 13 4 15s722ms 3s930ms 14 4 15s651ms 3s912ms 15 4 14s955ms 3s738ms 16 3 10s566ms 3s522ms 17 3 10s715ms 3s571ms 18 3 11s661ms 3s887ms 19 4 15s634ms 3s908ms 20 4 15s400ms 3s850ms 21 4 14s486ms 3s621ms 22 4 16s761ms 4s190ms [ User: intelifix - Total duration: 3m50s - Times executed: 61 ]
[ Application: psql - Total duration: 3m50s - Times executed: 61 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-18 19:40:12 Duration: 5s207ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-18 13:00:09 Duration: 4s822ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-18 14:00:09 Duration: 4s776ms Database: brasilia User: intelifix Remote: [local] Application: psql
18 3m28s 120 160ms 26s801ms 1s735ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 18 08 26 17s988ms 691ms 09 20 19s821ms 991ms 11 19 1m8s 3s582ms 13 19 24s737ms 1s301ms 14 8 10s830ms 1s353ms 15 15 36s391ms 2s426ms 16 12 8s497ms 708ms 17 1 21s933ms 21s933ms [ User: intelifix - Total duration: 3m28s - Times executed: 120 ]
[ Application: [unknown] - Total duration: 3m28s - Times executed: 120 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052752) LIMIT 1;
Date: 2026-08-18 11:06:08 Duration: 26s801ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052715) LIMIT 1;
Date: 2026-08-18 17:32:38 Duration: 21s933ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052715) LIMIT 1;
Date: 2026-08-18 11:07:59 Duration: 15s407ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 3m6s 4 4s256ms 1m38s 46s686ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 18 20 2 1m24s 42s175ms 23 2 1m42s 51s197ms [ User: intelifix - Total duration: 3m6s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m6s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-18 23:17:17 Duration: 1m38s 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-08-18 20:08:14 Duration: 1m20s 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-08-18 23:37:28 Duration: 4s264ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 2m2s 4 411ms 1m6s 30s628ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 18 20 2 55s228ms 27s614ms 23 2 1m7s 33s643ms [ User: intelifix - Total duration: 2m2s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m2s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-18 23:13:44 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-18 20:05:17 Duration: 54s816ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-18 23:36:57 Duration: 649ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,320 36m1s 150ms 11s615ms 1s637ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 18 07 8 4s754ms 594ms 08 104 2m15s 1s303ms 09 148 4m26s 1s800ms 10 157 4m30s 1s721ms 11 188 6m11s 1s977ms 12 46 1m2s 1s347ms 13 85 2m56s 2s76ms 14 195 5m2s 1s548ms 15 185 4m39s 1s509ms 16 138 3m15s 1s419ms 17 66 1m36s 1s468ms [ User: intelifix - Total duration: 36m1s - Times executed: 1320 ]
[ Application: [unknown] - Total duration: 36m1s - Times executed: 1320 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276458, 404, '255044117689205,216528437294,216827572942,216821582537,216885450005,216528953843,216913604559,216414467383,216442735967,216647124646,216850353347,216451774560,216881695575,216367984957,216839413334,216567183848,216811718903,216932663445,216849789396,216683950205,216881940527,216883507188,216783435469', '',064,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-18 11:21:48 Duration: 11s615ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276489, 450, '836066910000848,241732061234,241673358804,241708810525,241708826485,241654543253,241622596868,241695500202,241602671221,241692616878,241637748101,241659807896,230048413041,241618570517,241700955066,241708261425,241728533650,241728684955,241672209006,241727436786,241601110115,241727469719,241717176368,241636090622,241704740408,241680344850,241727496567,241622523046,241604336074,241659731324,241731233442,241693223234,241671530018,241730920303,241659735970,241679924248,241617366470,241731220714,241617674761', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-18 09:40:15 Duration: 10s830ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276492, 503, 'ZTE3ANNQ8M21148,843C9920B793,843C9920B794,ZTEGD7BA9A09$ZTE3ANNQ9J21672,843C992DCD25,843C992DCD26,ZTEGD7BB5D53$ZTE3ANNRC506290,6C11BA62BD43,6C11BA62BD44,ZTEGDC6E2E51$ZTE3ANNR4N39425,4896D958F71E,4896D958F71F,ZTEGD97FB9C6$ZTE3ANNR8C09527,3891484F6651,3891484F6652,ZTEGDB08A5A7$ZTE3ANNT3H44248,D831399AD0A8,D831399AD0A9,ZTEGDD327D77$ZTE3ANNT3H84105,D831399E76CE,D831399E76CF,ZTEGDD331928$ZTE3ANNQ5205971,3CF9F0A7B708,3CF9F0A7B709,ZTEGD640DE8A$ZTE3ANNR1Y02243,14CA56CCDF0D,14CA56CCDF0E,ZTEGD9707F1E$ZTE3ANNR5W07722,48D6822F38C6,48D6822F38C7,ZTEGDB001E29$ZTE3ANNT2V86514,D83139937A84,D83139937A85,ZTEGDD314471$ZTE3ANNQ4N01105,3CF9F0A8AB94,3CF9F0A8AB95,ZTEGD641074C$ZTE3ANNR3Y22505,4896D951D02E,4896D951D02F,ZTEGD97E889E$ZTE3ANNQ8F09274,689E29FCFC39,689E29FCFC3A,ZTEGD7BA210A$ZTE3ANNT4P14342,F00C514CF6C2,F00C514CF6C3,ZTEGDE342E9C$ZTE3ANNR3Y03781,4896D9501956,4896D9501957,ZTEGD97E3F7A$ZTE3ANNT3H26867,D8313999394A,D8313999394B,ZTEGDD323992$ZTE3ANNQ8F13506,689E29FD5F69,689E29FD5F6A,ZTEGD7BA3192$ZTE3ANNT2V12177,D831398CAC3E,D831398CAC3F,ZTEGDD302210$ZTE3ANNR9F18235,D89A0DA48945,D89A0DA48946,ZTEGDB156E86$ZTE3ANNR3Y45871,4896D953F3D2,4896D953F3D3,ZTEGD97EE3E4$ZTE3ANNQ4N02041,3CF9F0A8C184,3CF9F0A8C185,ZTEGD6410AF4$ZTE3ANNT3F09322,D83139960644,D83139960645,ZTEGDD31B111$ZTE3ANNRAM42310,5872C98B17DD,5872C98B17DE,ZTEGDC60A545$ZTE3ANNR7B33016,3891484BF277,3891484BF278,ZTEGDB081258$ZTE3ANNQCA06665,14CA56D2E111,14CA56D2E112,ZTEGD9717F74$ZTE3ANNR5W76379,48D6823581EC,48D6823581ED,ZTEGDB012A5A$ZTE3ANNT3H23543,D8313998EB62,D8313998EB63,ZTEGDD322C96$ZTE3ANNRCB23956,D83139200076,D83139200077,ZTEGDD2A1329$ZTE3ANNR6R24547,48D68237C414,48D68237C415,ZTEGDB018AB6$ZTE3ANNRB725227,5872C9908873,5872C9908874,ZTEGDC618D5E$ZTE3ANNRC575652,6C11BA6916EF,6C11BA6916F0,ZTEGDC6F3D43$ZTE3ANNRB737565,5872C991A99F,5872C991A9A0,ZTEGDC61BD90$ZTE3ANNT2V71503,D83139921AB2,D83139921AB3,ZTEGDD3109CE$ZTE3ANNQ7506311,C4EBFF8B8726,C4EBFF8B8727,ZTEGD70A6747$ZTE3ANNR7B32772,3891484BECBF,3891484BECC0,ZTEGDB081164$ZTE3ANNRC565508,6C11BA68292F,6C11BA682930,ZTEGDC6F15A3$ZTE3ANNQ3611397,3CF9F0A5E08C,3CF9F0A5E08D,ZTEGD6409020$ZTE3ANNR6R28468,48D682381FFA,48D682381FFB,ZTEGDB019A07', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-18 09:26:46 Duration: 9s323ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1,057 13m28s 150ms 7s932ms 764ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 18 07 50 48s75ms 961ms 08 112 1m15s 677ms 09 129 1m38s 761ms 10 150 1m43s 687ms 11 98 1m8s 695ms 12 13 11s872ms 913ms 13 125 1m26s 690ms 14 124 1m36s 780ms 15 68 1m3s 938ms 16 171 2m12s 773ms 17 17 23s555ms 1s385ms [ User: intelifix - Total duration: 13m28s - Times executed: 1057 ]
[ Application: [unknown] - Total duration: 13m28s - Times executed: 1057 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "279002", "modelo" : "320", "itens" : "241688900007,241645824545,241717186369,241621046571,241660751637,241672211431,241631102626,241594190113,241603787378,241615130619,241630182727,241709742344,241703351114,241690179716,230049252528,241655156174,241668236878,241620835866,241704646178,241655508587,241598871939,241593713545,241609849306,241631468295,230048531212,241664804052,241639118706,241701304550,241645522945,241671498599", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-18 17:29:57 Duration: 7s932ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "278791", "modelo" : "320", "itens" : "241658500407,241629326369,241651084969,241637804447,241679534154,241669945777,241592240708,230055065463,241666334549,241619613132,241657047492,241617110913,241666097376,241712266686,241673288493,241628888088,241603359604,241708405759,241666438701,241603365362,241619745367,241593168485,241639110019,241637820005,241700285674,241669934665,241639386969,241604195555,241706599499,241651980422,241617561114,241667983240,241651087696,241606226887,241645520723,241614895870,241630752637,241651186572,241653995264,241634529919,241637519515,241651075675,241709801216,241618142944,241635408602,241658672646,230055033036,241682647375", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-18 07:07:55 Duration: 4s563ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "241543", "modelo" : "305", "itens" : "241681680425,229951637288,230030840103,241670918789,241681802232,241639716777,241683134348,241681571727,241683058000,241656187172", "usuario" : "414", "caixa" : "2880602", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-18 13:37:45 Duration: 4s204ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 331 2h26m3s 150ms 10m55s 26s476ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 18 07 6 12m28s 2m4s 08 46 23m45s 30s999ms 09 50 22m25s 26s905ms 10 39 38m31s 59s270ms 11 44 10m15s 13s988ms 12 6 7s62ms 1s177ms 13 37 1m19s 2s162ms 14 35 16m 27s441ms 15 36 18m27s 30s771ms 16 19 32s447ms 1s707ms 17 10 1m45s 10s535ms 18 3 23s716ms 7s905ms [ User: intelifix - Total duration: 2h26m3s - Times executed: 331 ]
[ Application: [unknown] - Total duration: 2h26m3s - Times executed: 331 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028630, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-18 10:19:33 Duration: 10m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028654, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-18 14:35:13 Duration: 9m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028627, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-18 09:30:17 Duration: 8m41s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 275 11m39s 162ms 17s585ms 2s542ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 18 00 12 39s815ms 3s317ms 01 12 26s5ms 2s167ms 02 12 26s68ms 2s172ms 03 12 25s181ms 2s98ms 04 12 22s938ms 1s911ms 05 12 25s451ms 2s120ms 06 12 24s97ms 2s8ms 07 11 25s134ms 2s284ms 08 12 31s415ms 2s617ms 09 12 35s863ms 2s988ms 10 12 32s30ms 2s669ms 11 12 39s250ms 3s270ms 12 12 27s585ms 2s298ms 13 12 27s143ms 2s261ms 14 12 36s688ms 3s57ms 15 12 47s703ms 3s975ms 16 12 30s380ms 2s531ms 17 12 29s18ms 2s418ms 18 12 28s458ms 2s371ms 19 12 25s752ms 2s146ms 20 12 41s355ms 3s446ms 21 12 25s858ms 2s154ms 22 12 26s88ms 2s174ms [ User: intelifix - Total duration: 11m39s - Times executed: 275 ]
[ Application: psql - Total duration: 11m39s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-18 20:15:18 Duration: 17s585ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-18 00:05:43 Duration: 14s327ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-18 11:25:14 Duration: 13s42ms Database: rio User: intelifix Remote: [local] Application: psql
5 183 49s625ms 150ms 926ms 271ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 18 00 2 512ms 256ms 01 21 4s795ms 228ms 04 3 587ms 195ms 05 9 2s829ms 314ms 07 6 1s704ms 284ms 08 17 4s81ms 240ms 09 19 4s965ms 261ms 10 15 4s659ms 310ms 11 10 3s71ms 307ms 12 9 2s676ms 297ms 14 47 12s230ms 260ms 15 17 5s705ms 335ms 16 6 1s353ms 225ms 17 2 451ms 225ms [ User: intelifix - Total duration: 49s625ms - Times executed: 183 ]
[ Application: [unknown] - Total duration: 49s625ms - Times executed: 183 ]
-
SELECT * FROM RS_TRIAGEM (430, 5, '138', 6, '9877E74E71D8,9877E707DC85,9877E77BCA53,743AEF742543,9877E77DDC5B,9877E7078A5A,743AEF960A44,840112808E3D,743AEF5FED2F,9877E7031125,1834AF9BAC94,1834AF615800,9877E700C174,743AEFDB3117,9877E7499ADF,9877E70711EE,84011207E35C', NULL, NULL, 0153, 00);
Date: 2026-08-18 15:38:03 Duration: 926ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (302, 5, '113', 3, '6802B8A2AD98,B4F2675EC8D5,6802B814C986,6802B8A38379,6802B8A3F99F,6802B8A4E996,6802B8BE5F09,6802B8AC5B1F,6802B8F09512', NULL, NULL, 0156, 00);
Date: 2026-08-18 11:48:14 Duration: 723ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (310, 5, '63', 2, '80D04A940C4D,54A65C0F0620,087E64841871,D4B92F2D235E,383FB3A9B624,10C25A150AF6,80D04AB8B874,70037E9DEEF8,B42A0EDC544E,D4B92F2750AB,1062D010D6CA', NULL, NULL, 046, 00);
Date: 2026-08-18 10:00:48 Duration: 711ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 145 13m56s 208ms 2m10s 5s766ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 18 00 6 42s370ms 7s61ms 01 6 17s125ms 2s854ms 02 6 14s48ms 2s341ms 03 5 15s604ms 3s120ms 04 6 20s689ms 3s448ms 05 5 14s45ms 2s809ms 07 11 49s127ms 4s466ms 08 12 1m4s 5s344ms 09 12 1m57s 9s831ms 10 12 1m13s 6s125ms 11 6 24s588ms 4s98ms 12 7 10s81ms 1s440ms 13 8 2m21s 17s667ms 14 12 1m5s 5s484ms 15 10 1m1s 6s191ms 16 5 8s642ms 1s728ms 17 5 1m18s 15s666ms 20 1 208ms 208ms 21 4 6s715ms 1s678ms 22 6 9s880ms 1s646ms [ User: intelifix - Total duration: 13m56s - Times executed: 145 ]
[ Application: psql - Total duration: 13m56s - Times executed: 145 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-18 13:47:11 Duration: 2m10s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-18 17:46:15 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-18 00:05:29 Duration: 27s276ms Database: rio User: intelifix Remote: [local] Application: psql
7 126 30s378ms 151ms 757ms 241ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 18 07 5 1s367ms 273ms 08 11 3s71ms 279ms 09 14 3s533ms 252ms 10 20 3s780ms 189ms 11 22 4s855ms 220ms 12 3 591ms 197ms 13 15 3s847ms 256ms 14 23 5s884ms 255ms 15 13 3s448ms 265ms [ User: intelifix - Total duration: 30s378ms - Times executed: 126 ]
[ Application: [unknown] - Total duration: 30s378ms - Times executed: 126 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"321", "usuario" :"413", "tipo" :"N", "itens" :"045", "nota-fiscal" :"11286", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-18 08:21:56 Duration: 757ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"466", "usuario" :"507", "tipo" :"N", "itens" :"004", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-18 14:53:21 Duration: 723ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"185", "usuario" :"184", "tipo" :"N", "itens" :"01", "nota-fiscal" :"6969", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-18 13:42:16 Duration: 700ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 120 3m28s 160ms 26s801ms 1s735ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 18 08 26 17s988ms 691ms 09 20 19s821ms 991ms 11 19 1m8s 3s582ms 13 19 24s737ms 1s301ms 14 8 10s830ms 1s353ms 15 15 36s391ms 2s426ms 16 12 8s497ms 708ms 17 1 21s933ms 21s933ms [ User: intelifix - Total duration: 3m28s - Times executed: 120 ]
[ Application: [unknown] - Total duration: 3m28s - Times executed: 120 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052752) LIMIT 1;
Date: 2026-08-18 11:06:08 Duration: 26s801ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052715) LIMIT 1;
Date: 2026-08-18 17:32:38 Duration: 21s933ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052715) LIMIT 1;
Date: 2026-08-18 11:07:59 Duration: 15s407ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
9 120 55s84ms 261ms 799ms 459ms 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 #9
Day Hour Count Duration Avg duration Aug 18 00 1 598ms 598ms 01 2 714ms 357ms 04 2 715ms 357ms 05 2 838ms 419ms 06 1 381ms 381ms 07 8 3s36ms 379ms 08 11 5s103ms 463ms 09 12 5s788ms 482ms 10 11 5s43ms 458ms 11 12 5s901ms 491ms 12 3 1s74ms 358ms 13 12 5s463ms 455ms 14 13 5s890ms 453ms 15 10 4s708ms 470ms 16 9 4s745ms 527ms 17 6 2s862ms 477ms 18 2 888ms 444ms 21 2 814ms 407ms 22 1 515ms 515ms [ User: lenon - Total duration: 55s84ms - Times executed: 120 ]
[ Application: [unknown] - Total duration: 55s84ms - Times executed: 120 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-18 09:35:09 Duration: 799ms 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-08-18 17:17:52 Duration: 791ms Database: brasilia 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-08-18 14:05:43 Duration: 712ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
10 114 1m8s 164ms 2s971ms 601ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 18 11 31 25s196ms 812ms 13 61 35s954ms 589ms 14 22 7s470ms 339ms [ User: intelifix - Total duration: 1m8s - Times executed: 114 ]
[ Application: [unknown] - Total duration: 1m8s - Times executed: 114 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"52975","seriais":"229726410415,229755875265,229669753235,216941986161,229736813450,229755008907,229735571219,229741654259,229817050417,229859086673,229805221619,229735559803,229813385569,229687352136,229745333350,229880019299,229664247175,229728467180,216945127388,229686226481,216944103035,229749599400,216937556582,229925397084,229809398692,229689784045,229786736683,229864928197,229879519700,229780839193,229689029314,229736846483,229669254971,229755448298,229807180621,229782747988,229805744756,229805245055,229809535272,229669490707,229728562847,229813800414,229805245762,229663868698,216945082334,229748817595,229752744062,229859193755,229745689298,229742000410","usuario":"416","observacao":""}');
Date: 2026-08-18 13:37:55 Duration: 2s971ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"52975","seriais":"54A65C8C49EB,A456CCE766CF,54A65C8A5008,1062D0105D70,1062D09AB418,A456CCE6A6E2,383FB3A40337,54A65C8AE0BC,383FB3A625E6,14B7F8DE6FF4,80D04AB8D57E,9058514592C7,D4B92F2A66F5,905851458610,54A65C0EC598,BC9B689B1FD9,383FB3A35B6F,BC9B68977D81,A456CCDF7763,383FB3A37FC6,D4B92F2BDE6A,54A65C8AD261,A456CCE33DFD,80D04ABB6D51,80D04ABAB3A7,1062D012BCB7","usuario":"416","observacao":""}');
Date: 2026-08-18 13:36:47 Duration: 1s693ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"52992","seriais":"186A81D6B6B7,B0FC88E9E01D,D833B7C91386,E4C0E240E1D5,E8D2FFAA6509,943C9679CF09,B0BBE54C1975,8CFDDE97D010,345D9EBD4471,5CFA2514EF51,209A7DB63B2D,841EA38D03D7,186A81D565FA,3C585D79B28C,C03C0480C3F5,8CFDDE87C747","usuario":"416","observacao":""}');
Date: 2026-08-18 11:39:34 Duration: 1s689ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
11 111 1m4s 332ms 955ms 578ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 18 00 1 955ms 955ms 01 1 435ms 435ms 04 2 976ms 488ms 05 2 1s18ms 509ms 07 7 3s327ms 475ms 08 10 6s13ms 601ms 09 11 6s681ms 607ms 10 11 6s317ms 574ms 11 12 7s96ms 591ms 12 3 1s421ms 473ms 13 12 6s832ms 569ms 14 12 6s727ms 560ms 15 10 5s874ms 587ms 16 9 5s902ms 655ms 17 6 3s559ms 593ms 18 1 528ms 528ms 22 1 587ms 587ms [ User: intelifix - Total duration: 1m4s - Times executed: 111 ]
[ Application: [unknown] - Total duration: 1m4s - Times executed: 111 ]
-
select * from rs_menu_grants (499, 19, 1);
Date: 2026-08-18 00:22:35 Duration: 955ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (413, 18, 1);
Date: 2026-08-18 10:19:26 Duration: 947ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (470, 19, 1);
Date: 2026-08-18 14:40:20 Duration: 899ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 81 35s380ms 169ms 710ms 436ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 18 07 3 987ms 329ms 08 13 6s136ms 472ms 09 9 4s388ms 487ms 10 9 4s229ms 469ms 11 4 1s822ms 455ms 12 3 1s1ms 333ms 13 9 3s697ms 410ms 14 10 4s611ms 461ms 15 11 4s802ms 436ms 16 3 1s11ms 337ms 17 5 2s3ms 400ms 18 2 686ms 343ms [ User: intelifix - Total duration: 35s380ms - Times executed: 81 ]
[ Application: [unknown] - Total duration: 35s380ms - Times executed: 81 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-18 14:30:04 Duration: 710ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-08-18 08:34:21 Duration: 707ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-18 08:36:20 Duration: 692ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
13 73 27s158ms 151ms 7s391ms 372ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 18 07 1 191ms 191ms 08 40 12s288ms 307ms 09 1 153ms 153ms 11 1 161ms 161ms 13 14 3s810ms 272ms 14 4 749ms 187ms 16 12 9s803ms 816ms [ User: intelifix - Total duration: 27s158ms - Times executed: 73 ]
[ Application: [unknown] - Total duration: 27s158ms - Times executed: 73 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (241493);
Date: 2026-08-18 16:14:12 Duration: 7s391ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (52992);
Date: 2026-08-18 13:12:41 Duration: 761ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (229989);
Date: 2026-08-18 08:45:57 Duration: 435ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 73 22s537ms 150ms 1s446ms 308ms select * from rs_lote_saida_manutencao (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 18 07 7 1s492ms 213ms 08 9 2s21ms 224ms 09 7 1s681ms 240ms 10 5 1s642ms 328ms 11 6 2s821ms 470ms 13 7 2s129ms 304ms 14 6 2s922ms 487ms 15 4 2s195ms 548ms 16 18 4s450ms 247ms 17 4 1s181ms 295ms [ User: intelifix - Total duration: 22s537ms - Times executed: 73 ]
[ Application: [unknown] - Total duration: 22s537ms - Times executed: 73 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "133554", "oficina" : "7", "cliente" : "11", "usuario" : "427", "nf" : "", "data-saida" : "2026-08-18", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "S", "valorado" : "", "motivo" : "0", "obs" : "COSMÉTICO CHOCALHO D= 3-2", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-18 15:16:43 Duration: 1s446ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "278893", "oficina" : "6", "cliente" : "5", "usuario" : "418", "nf" : "", "data-saida" : "2026-08-18", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "S", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-18 14:16:48 Duration: 973ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "278891", "oficina" : "6", "cliente" : "5", "usuario" : "414", "nf" : "", "data-saida" : "2026-08-18", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "S", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-18 14:40:45 Duration: 846ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 63 9m40s 1s146ms 43s891ms 9s209ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 18 07 2 13s181ms 6s590ms 08 3 9s407ms 3s135ms 09 2 16s962ms 8s481ms 10 7 1m4s 9s151ms 11 7 1m9s 9s924ms 12 1 1s360ms 1s360ms 13 5 1m10s 14s68ms 14 6 56s30ms 9s338ms 15 12 1m50s 9s176ms 16 9 1m42s 11s424ms 17 9 1m6s 7s383ms [ User: intelifix - Total duration: 9m40s - Times executed: 63 ]
[ Application: [unknown] - Total duration: 9m40s - Times executed: 63 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-18', 0175, '', '', 0, 6, '2026-08-01');
Date: 2026-08-18 13:30:43 Duration: 43s891ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-18', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-18 11:17:31 Duration: 43s875ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-18', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-18 10:38:26 Duration: 43s263ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 63 15s218ms 150ms 570ms 241ms create table temp0000226852 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 18 11 1 200ms 200ms 13 3 604ms 201ms 14 41 9s614ms 234ms 15 17 4s648ms 273ms 16 1 150ms 150ms [ User: intelifix - Total duration: 15s218ms - Times executed: 63 ]
[ Application: [unknown] - Total duration: 15s218ms - Times executed: 63 ]
-
CREATE TABLE temp0000226852 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"13-08-2026", "ate" :"18-08-2026", "nota-fiscal":"141", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-18 15:46:33 Duration: 570ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226852 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"13-08-2026", "ate" :"18-08-2026", "nota-fiscal":"141", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-18 14:38:54 Duration: 449ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226852 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"1", "desde" :"13-08-2026", "ate" :"18-08-2026", "nota-fiscal":"141", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-18 14:15:09 Duration: 366ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
17 63 14s220ms 150ms 724ms 225ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 18 00 2 709ms 354ms 01 2 380ms 190ms 05 2 629ms 314ms 07 1 171ms 171ms 08 2 439ms 219ms 09 12 3s609ms 300ms 10 10 1s713ms 171ms 11 4 854ms 213ms 12 3 557ms 185ms 13 2 509ms 254ms 14 5 932ms 186ms 15 9 1s661ms 184ms 16 3 710ms 236ms 17 1 182ms 182ms 18 2 359ms 179ms 21 3 799ms 266ms [ User: intelifix - Total duration: 14s220ms - Times executed: 63 ]
[ Application: [unknown] - Total duration: 14s220ms - Times executed: 63 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('A8705D811E5F');
Date: 2026-08-18 09:12:59 Duration: 724ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229928915071');
Date: 2026-08-18 00:15:16 Duration: 556ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229758885469');
Date: 2026-08-18 09:37:04 Duration: 440ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 61 3m50s 168ms 5s207ms 3s771ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 18 08 5 19s73ms 3s814ms 09 5 14s899ms 2s979ms 10 5 19s342ms 3s868ms 11 4 15s453ms 3s863ms 12 5 19s720ms 3s944ms 13 4 15s722ms 3s930ms 14 4 15s651ms 3s912ms 15 4 14s955ms 3s738ms 16 3 10s566ms 3s522ms 17 3 10s715ms 3s571ms 18 3 11s661ms 3s887ms 19 4 15s634ms 3s908ms 20 4 15s400ms 3s850ms 21 4 14s486ms 3s621ms 22 4 16s761ms 4s190ms [ User: intelifix - Total duration: 3m50s - Times executed: 61 ]
[ Application: psql - Total duration: 3m50s - Times executed: 61 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-18 19:40:12 Duration: 5s207ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-18 13:00:09 Duration: 4s822ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-18 14:00:09 Duration: 4s776ms Database: brasilia User: intelifix Remote: [local] Application: psql
19 61 22s763ms 153ms 1s404ms 373ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 18 08 2 595ms 297ms 09 10 4s553ms 455ms 10 7 4s416ms 630ms 11 2 380ms 190ms 14 23 8s181ms 355ms 15 16 4s454ms 278ms 16 1 181ms 181ms [ User: intelifix - Total duration: 22s763ms - Times executed: 61 ]
[ Application: [unknown] - Total duration: 22s763ms - Times executed: 61 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, 'F09BB855DC37,BC76C5B48781,20AB48B95C28,C0BC9A4DDDC3,FC73FB021F30,30C50FB63014,C40D969786DB,6C442A9303E6,C0BC9A4E23F4', '87;1', 'DEFAULT', 09, 0189, '','', '', 00);
Date: 2026-08-18 14:47:26 Duration: 1s404ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '241674178187,241688931020,241628284562,241618235556,241704273639,241703529414,241669585865,241655511316,241716896767,241733065764,241691893138,241595306977,241713669820,241680789393,241618134256,241692875265,241675738687,241688777996,241715478201,241729513555,241608666979,241671550424,241700737491,241783941022,241635315158,241688830808,241729945572,241673117186,241622844345,241654578889,241712681228,241679447680,241666322124,241712142533,241604767990,241658897897,241619369416,241677193039,241699115874,241614665264,241657657787,241691241930,241608891828,241667728186,241691407579,241709614957,241629523538,241649505555,241617864858,241630142039,241658113949,241646657791,241600789600,241679905458,241602896977,241620669004,241709332023', '','DEFAULT',051,0320,'', '','', 00);
Date: 2026-08-18 09:08:30 Duration: 1s182ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '80D04A93390B,14B7F8E02773,905851A75368,946A77270D6B,D4B92F26B490,905851A6FEA4,946A77286337,80D04A940C4D,54A65C0F0620,80D04A9137E9,087E64841871,1062D098E570,D4B92F2D235E,383FB3A9B624,10C25A150AF6,80D04AB8B874,70037E9DEEF8,48003305F355,B42A0EDC544E,54A65C115A62,D4B92F2750AB,BC9B689A23EE,946A7727C578,383FB3A655B9,B42A0ED494D0,54A65C1173D7,54A65C9041C4,70037E9BF47B,905851A73CC4,BC9B6896A19B,480033E9B629,1062D010D6CA,1062D010ED28,54A65C127492,383FB3A7580A,54A65C0EFEB7,5C76959668EA,480033062081,905851A6E3A0,70037E9DAE62,54A65C122905,D4B92F266EDD,905851AC64DE', '','DEFAULT',056,046,'', '','', 00);
Date: 2026-08-18 09:58:44 Duration: 950ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 60 14s18ms 153ms 1s529ms 233ms create table temp0000238376 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 18 07 13 4s522ms 347ms 08 2 843ms 421ms 09 1 157ms 157ms 10 6 1s99ms 183ms 11 10 1s808ms 180ms 12 14 2s559ms 182ms 13 5 954ms 190ms 14 7 1s599ms 228ms 15 2 472ms 236ms [ User: intelifix - Total duration: 14s18ms - Times executed: 60 ]
[ Application: [unknown] - Total duration: 14s18ms - Times executed: 60 ]
-
CREATE TABLE temp0000238376 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "13-08-2026", "data-ate" : "18-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-18 07:34:35 Duration: 1s529ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000238376 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "13-08-2026", "data-ate" : "18-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-18 08:04:41 Duration: 650ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000238376 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "13-08-2026", "data-ate" : "18-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-18 07:35:08 Duration: 584ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m55s 10m36s 6m47s 3 20m21s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 18 05 3 20m21s 6m47s [ User: intelifix - Total duration: 20m21s - Times executed: 3 ]
[ Application: psql - Total duration: 20m21s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-18 05:10:38 Duration: 10m36s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-18 05:17:27 Duration: 6m49s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-18 05:20:23 Duration: 2m55s Database: contagem User: intelifix Remote: [local] Application: psql
2 5s401ms 5m47s 2m56s 2 5m53s select * from rs_fast_excel (?, ?) / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 18 12 1 5m47s 5m47s 17 1 5s401ms 5s401ms [ User: intelifix - Total duration: 5m53s - Times executed: 2 ]
[ Application: [unknown] - Total duration: 5m53s - Times executed: 2 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028651, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx') / 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-08-18 12:20:00 Duration: 5m47s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/excluir.xlsx'') ;', '/var/www/html/tmp/temp_83.xlsx') / 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-08-18 17:39:51 Duration: 5s401ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
3 1s633ms 11m33s 2m53s 48 2h18m45s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 18 07 3 11m43s 3m54s 08 3 7m37s 2m32s 09 3 13m28s 4m29s 10 3 8m16s 2m45s 11 3 10m14s 3m24s 12 3 8m57s 2m59s 13 3 6m25s 2m8s 14 3 9m43s 3m14s 15 3 11m13s 3m44s 16 3 10m17s 3m25s 17 3 7m23s 2m27s 18 3 6m42s 2m14s 19 3 6m10s 2m3s 20 3 8m12s 2m44s 21 3 6m15s 2m5s 22 3 6m2s 2m [ User: intelifix - Total duration: 2h18m45s - Times executed: 48 ]
[ Application: psql - Total duration: 2h18m45s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-18 09:16:35 Duration: 11m33s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-18 07:15:46 Duration: 10m45s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-18 15:15:16 Duration: 10m14s Database: rio User: intelifix Remote: [local] Application: psql
4 218ms 6m38s 1m42s 48 1h22m22s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 18 07 3 5m57s 1m59s 08 3 5m5s 1m41s 09 3 9m12s 3m4s 10 3 4m27s 1m29s 11 3 5m57s 1m59s 12 3 4m43s 1m34s 13 3 3m53s 1m17s 14 3 6m13s 2m4s 15 3 6m13s 2m4s 16 3 5m55s 1m58s 17 3 4m25s 1m28s 18 3 3m58s 1m19s 19 3 3m52s 1m17s 20 3 5m3s 1m41s 21 3 3m40s 1m13s 22 3 3m42s 1m14s [ User: intelifix - Total duration: 1h22m22s - Times executed: 48 ]
[ Application: psql - Total duration: 1h22m22s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-18 09:27:19 Duration: 6m38s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-18 14:20:38 Duration: 4m42s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-18 15:22:20 Duration: 4m40s Database: brasilia User: intelifix Remote: [local] Application: psql
5 4s256ms 1m38s 46s686ms 4 3m6s 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 Aug 18 20 2 1m24s 42s175ms 23 2 1m42s 51s197ms [ User: intelifix - Total duration: 3m6s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m6s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-18 23:17:17 Duration: 1m38s 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-08-18 20:08:14 Duration: 1m20s 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-08-18 23:37:28 Duration: 4s264ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 411ms 1m6s 30s628ms 4 2m2s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 18 20 2 55s228ms 27s614ms 23 2 1m7s 33s643ms [ User: intelifix - Total duration: 2m2s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m2s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-18 23:13:44 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-18 20:05:17 Duration: 54s816ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-18 23:36:57 Duration: 649ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 150ms 10m55s 26s476ms 331 2h26m3s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 18 07 6 12m28s 2m4s 08 46 23m45s 30s999ms 09 50 22m25s 26s905ms 10 39 38m31s 59s270ms 11 44 10m15s 13s988ms 12 6 7s62ms 1s177ms 13 37 1m19s 2s162ms 14 35 16m 27s441ms 15 36 18m27s 30s771ms 16 19 32s447ms 1s707ms 17 10 1m45s 10s535ms 18 3 23s716ms 7s905ms [ User: intelifix - Total duration: 2h26m3s - Times executed: 331 ]
[ Application: [unknown] - Total duration: 2h26m3s - Times executed: 331 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028630, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-18 10:19:33 Duration: 10m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028654, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-18 14:35:13 Duration: 9m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028627, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-18 09:30:17 Duration: 8m41s Database: rio User: intelifix Remote: [local] Application: [unknown]
8 11s213ms 43s671ms 14s794ms 21 5m10s create table temp0000288790 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 18 13 4 1m21s 20s469ms 15 17 3m48s 13s459ms [ User: intelifix - Total duration: 5m10s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 5m10s - Times executed: 21 ]
-
CREATE TABLE temp0000288790 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 13:40:24 Duration: 43s671ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288790 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 15:29:17 Duration: 15s759ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288790 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 15:36:44 Duration: 15s287ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s508ms 52s83ms 13s258ms 22 4m51s create table temp0000288714 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 18 07 17 3m50s 13s550ms 08 5 1m1s 12s267ms [ User: intelifix - Total duration: 4m51s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 4m51s - Times executed: 22 ]
-
CREATE TABLE temp0000288714 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 07:16:41 Duration: 52s83ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288714 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 08:11:52 Duration: 13s999ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288714 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 08:12:11 Duration: 12s570ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s705ms 19s640ms 13s168ms 59 12m56s create table temp0000288740 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 18 08 12 2m30s 12s520ms 09 12 2m46s 13s910ms 10 3 41s538ms 13s846ms 11 6 1m15s 12s516ms 12 3 34s573ms 11s524ms 14 12 2m43s 13s625ms 15 11 2m25s 13s184ms [ User: intelifix - Total duration: 12m56s - Times executed: 59 ]
[ Application: [unknown] - Total duration: 12m56s - Times executed: 59 ]
-
CREATE TABLE temp0000288740 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 14:23:19 Duration: 19s640ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288740 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 09:21:30 Duration: 15s419ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288740 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 09:19:33 Duration: 15s302ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s538ms 15s411ms 12s308ms 20 4m6s create table temp0000288744 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 18 08 1 12s706ms 12s706ms 09 8 1m46s 13s288ms 11 3 35s272ms 11s757ms 12 8 1m31s 11s485ms [ User: intelifix - Total duration: 4m6s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 4m6s - Times executed: 20 ]
-
CREATE TABLE temp0000288744 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 09:51:39 Duration: 15s411ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288744 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 09:51:09 Duration: 14s867ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000288744 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-18 09:49:07 Duration: 13s573ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 1s146ms 43s891ms 9s209ms 63 9m40s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 18 07 2 13s181ms 6s590ms 08 3 9s407ms 3s135ms 09 2 16s962ms 8s481ms 10 7 1m4s 9s151ms 11 7 1m9s 9s924ms 12 1 1s360ms 1s360ms 13 5 1m10s 14s68ms 14 6 56s30ms 9s338ms 15 12 1m50s 9s176ms 16 9 1m42s 11s424ms 17 9 1m6s 7s383ms [ User: intelifix - Total duration: 9m40s - Times executed: 63 ]
[ Application: [unknown] - Total duration: 9m40s - Times executed: 63 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-18', 0175, '', '', 0, 6, '2026-08-01');
Date: 2026-08-18 13:30:43 Duration: 43s891ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-18', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-18 11:17:31 Duration: 43s875ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-18', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-18 10:38:26 Duration: 43s263ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 196ms 31s772ms 7s627ms 36 4m34s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 18 07 3 30s854ms 10s284ms 08 5 21s344ms 4s268ms 09 5 34s30ms 6s806ms 10 5 23s372ms 4s674ms 11 2 34s636ms 17s318ms 12 4 16s827ms 4s206ms 13 1 31s772ms 31s772ms 14 2 31s670ms 15s835ms 15 7 48s442ms 6s920ms 18 2 1s641ms 820ms [ User: intelifix - Total duration: 4m34s - Times executed: 36 ]
[ Application: psql - Total duration: 4m34s - Times executed: 36 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028652);
Date: 2026-08-18 13:45:27 Duration: 31s772ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028643);
Date: 2026-08-18 11:15:50 Duration: 30s111ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028654);
Date: 2026-08-18 14:25:47 Duration: 27s107ms Database: rio User: intelifix Remote: [local] Application: psql
14 208ms 2m10s 5s766ms 145 13m56s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 18 00 6 42s370ms 7s61ms 01 6 17s125ms 2s854ms 02 6 14s48ms 2s341ms 03 5 15s604ms 3s120ms 04 6 20s689ms 3s448ms 05 5 14s45ms 2s809ms 07 11 49s127ms 4s466ms 08 12 1m4s 5s344ms 09 12 1m57s 9s831ms 10 12 1m13s 6s125ms 11 6 24s588ms 4s98ms 12 7 10s81ms 1s440ms 13 8 2m21s 17s667ms 14 12 1m5s 5s484ms 15 10 1m1s 6s191ms 16 5 8s642ms 1s728ms 17 5 1m18s 15s666ms 20 1 208ms 208ms 21 4 6s715ms 1s678ms 22 6 9s880ms 1s646ms [ User: intelifix - Total duration: 13m56s - Times executed: 145 ]
[ Application: psql - Total duration: 13m56s - Times executed: 145 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-18 13:47:11 Duration: 2m10s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-18 17:46:15 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-18 00:05:29 Duration: 27s276ms Database: rio User: intelifix Remote: [local] Application: psql
15 218ms 1m55s 4s143ms 59 4m4s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 18 07 6 5s262ms 877ms 08 8 24s556ms 3s69ms 09 12 15s721ms 1s310ms 10 4 56s785ms 14s196ms 11 4 2s912ms 728ms 12 5 1s704ms 340ms 13 1 396ms 396ms 14 4 3s601ms 900ms 15 15 2m13s 8s901ms [ User: intelifix - Total duration: 4m4s - Times executed: 59 ]
[ Application: psql - Total duration: 4m4s - Times executed: 59 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028662);
Date: 2026-08-18 15:37:10 Duration: 1m55s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028641);
Date: 2026-08-18 10:54:51 Duration: 52s725ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028622);
Date: 2026-08-18 08:35:40 Duration: 19s587ms Database: rio User: intelifix Remote: [local] Application: psql
16 168ms 5s207ms 3s771ms 61 3m50s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 18 08 5 19s73ms 3s814ms 09 5 14s899ms 2s979ms 10 5 19s342ms 3s868ms 11 4 15s453ms 3s863ms 12 5 19s720ms 3s944ms 13 4 15s722ms 3s930ms 14 4 15s651ms 3s912ms 15 4 14s955ms 3s738ms 16 3 10s566ms 3s522ms 17 3 10s715ms 3s571ms 18 3 11s661ms 3s887ms 19 4 15s634ms 3s908ms 20 4 15s400ms 3s850ms 21 4 14s486ms 3s621ms 22 4 16s761ms 4s190ms [ User: intelifix - Total duration: 3m50s - Times executed: 61 ]
[ Application: psql - Total duration: 3m50s - Times executed: 61 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-18 19:40:12 Duration: 5s207ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-18 13:00:09 Duration: 4s822ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-18 14:00:09 Duration: 4s776ms Database: brasilia User: intelifix Remote: [local] Application: psql
17 162ms 17s585ms 2s542ms 275 11m39s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 18 00 12 39s815ms 3s317ms 01 12 26s5ms 2s167ms 02 12 26s68ms 2s172ms 03 12 25s181ms 2s98ms 04 12 22s938ms 1s911ms 05 12 25s451ms 2s120ms 06 12 24s97ms 2s8ms 07 11 25s134ms 2s284ms 08 12 31s415ms 2s617ms 09 12 35s863ms 2s988ms 10 12 32s30ms 2s669ms 11 12 39s250ms 3s270ms 12 12 27s585ms 2s298ms 13 12 27s143ms 2s261ms 14 12 36s688ms 3s57ms 15 12 47s703ms 3s975ms 16 12 30s380ms 2s531ms 17 12 29s18ms 2s418ms 18 12 28s458ms 2s371ms 19 12 25s752ms 2s146ms 20 12 41s355ms 3s446ms 21 12 25s858ms 2s154ms 22 12 26s88ms 2s174ms [ User: intelifix - Total duration: 11m39s - Times executed: 275 ]
[ Application: psql - Total duration: 11m39s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-18 20:15:18 Duration: 17s585ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-18 00:05:43 Duration: 14s327ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-18 11:25:14 Duration: 13s42ms Database: rio User: intelifix Remote: [local] Application: psql
18 160ms 26s801ms 1s735ms 120 3m28s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 18 08 26 17s988ms 691ms 09 20 19s821ms 991ms 11 19 1m8s 3s582ms 13 19 24s737ms 1s301ms 14 8 10s830ms 1s353ms 15 15 36s391ms 2s426ms 16 12 8s497ms 708ms 17 1 21s933ms 21s933ms [ User: intelifix - Total duration: 3m28s - Times executed: 120 ]
[ Application: [unknown] - Total duration: 3m28s - Times executed: 120 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052752) LIMIT 1;
Date: 2026-08-18 11:06:08 Duration: 26s801ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052715) LIMIT 1;
Date: 2026-08-18 17:32:38 Duration: 21s933ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052715) LIMIT 1;
Date: 2026-08-18 11:07:59 Duration: 15s407ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 150ms 11s615ms 1s637ms 1,320 36m1s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 18 07 8 4s754ms 594ms 08 104 2m15s 1s303ms 09 148 4m26s 1s800ms 10 157 4m30s 1s721ms 11 188 6m11s 1s977ms 12 46 1m2s 1s347ms 13 85 2m56s 2s76ms 14 195 5m2s 1s548ms 15 185 4m39s 1s509ms 16 138 3m15s 1s419ms 17 66 1m36s 1s468ms [ User: intelifix - Total duration: 36m1s - Times executed: 1320 ]
[ Application: [unknown] - Total duration: 36m1s - Times executed: 1320 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276458, 404, '255044117689205,216528437294,216827572942,216821582537,216885450005,216528953843,216913604559,216414467383,216442735967,216647124646,216850353347,216451774560,216881695575,216367984957,216839413334,216567183848,216811718903,216932663445,216849789396,216683950205,216881940527,216883507188,216783435469', '',064,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-18 11:21:48 Duration: 11s615ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276489, 450, '836066910000848,241732061234,241673358804,241708810525,241708826485,241654543253,241622596868,241695500202,241602671221,241692616878,241637748101,241659807896,230048413041,241618570517,241700955066,241708261425,241728533650,241728684955,241672209006,241727436786,241601110115,241727469719,241717176368,241636090622,241704740408,241680344850,241727496567,241622523046,241604336074,241659731324,241731233442,241693223234,241671530018,241730920303,241659735970,241679924248,241617366470,241731220714,241617674761', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-18 09:40:15 Duration: 10s830ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (276492, 503, 'ZTE3ANNQ8M21148,843C9920B793,843C9920B794,ZTEGD7BA9A09$ZTE3ANNQ9J21672,843C992DCD25,843C992DCD26,ZTEGD7BB5D53$ZTE3ANNRC506290,6C11BA62BD43,6C11BA62BD44,ZTEGDC6E2E51$ZTE3ANNR4N39425,4896D958F71E,4896D958F71F,ZTEGD97FB9C6$ZTE3ANNR8C09527,3891484F6651,3891484F6652,ZTEGDB08A5A7$ZTE3ANNT3H44248,D831399AD0A8,D831399AD0A9,ZTEGDD327D77$ZTE3ANNT3H84105,D831399E76CE,D831399E76CF,ZTEGDD331928$ZTE3ANNQ5205971,3CF9F0A7B708,3CF9F0A7B709,ZTEGD640DE8A$ZTE3ANNR1Y02243,14CA56CCDF0D,14CA56CCDF0E,ZTEGD9707F1E$ZTE3ANNR5W07722,48D6822F38C6,48D6822F38C7,ZTEGDB001E29$ZTE3ANNT2V86514,D83139937A84,D83139937A85,ZTEGDD314471$ZTE3ANNQ4N01105,3CF9F0A8AB94,3CF9F0A8AB95,ZTEGD641074C$ZTE3ANNR3Y22505,4896D951D02E,4896D951D02F,ZTEGD97E889E$ZTE3ANNQ8F09274,689E29FCFC39,689E29FCFC3A,ZTEGD7BA210A$ZTE3ANNT4P14342,F00C514CF6C2,F00C514CF6C3,ZTEGDE342E9C$ZTE3ANNR3Y03781,4896D9501956,4896D9501957,ZTEGD97E3F7A$ZTE3ANNT3H26867,D8313999394A,D8313999394B,ZTEGDD323992$ZTE3ANNQ8F13506,689E29FD5F69,689E29FD5F6A,ZTEGD7BA3192$ZTE3ANNT2V12177,D831398CAC3E,D831398CAC3F,ZTEGDD302210$ZTE3ANNR9F18235,D89A0DA48945,D89A0DA48946,ZTEGDB156E86$ZTE3ANNR3Y45871,4896D953F3D2,4896D953F3D3,ZTEGD97EE3E4$ZTE3ANNQ4N02041,3CF9F0A8C184,3CF9F0A8C185,ZTEGD6410AF4$ZTE3ANNT3F09322,D83139960644,D83139960645,ZTEGDD31B111$ZTE3ANNRAM42310,5872C98B17DD,5872C98B17DE,ZTEGDC60A545$ZTE3ANNR7B33016,3891484BF277,3891484BF278,ZTEGDB081258$ZTE3ANNQCA06665,14CA56D2E111,14CA56D2E112,ZTEGD9717F74$ZTE3ANNR5W76379,48D6823581EC,48D6823581ED,ZTEGDB012A5A$ZTE3ANNT3H23543,D8313998EB62,D8313998EB63,ZTEGDD322C96$ZTE3ANNRCB23956,D83139200076,D83139200077,ZTEGDD2A1329$ZTE3ANNR6R24547,48D68237C414,48D68237C415,ZTEGDB018AB6$ZTE3ANNRB725227,5872C9908873,5872C9908874,ZTEGDC618D5E$ZTE3ANNRC575652,6C11BA6916EF,6C11BA6916F0,ZTEGDC6F3D43$ZTE3ANNRB737565,5872C991A99F,5872C991A9A0,ZTEGDC61BD90$ZTE3ANNT2V71503,D83139921AB2,D83139921AB3,ZTEGDD3109CE$ZTE3ANNQ7506311,C4EBFF8B8726,C4EBFF8B8727,ZTEGD70A6747$ZTE3ANNR7B32772,3891484BECBF,3891484BECC0,ZTEGDB081164$ZTE3ANNRC565508,6C11BA68292F,6C11BA682930,ZTEGDC6F15A3$ZTE3ANNQ3611397,3CF9F0A5E08C,3CF9F0A5E08D,ZTEGD6409020$ZTE3ANNR6R28468,48D682381FFA,48D682381FFB,ZTEGDB019A07', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-18 09:26:46 Duration: 9s323ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 150ms 7s932ms 764ms 1,057 13m28s select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 18 07 50 48s75ms 961ms 08 112 1m15s 677ms 09 129 1m38s 761ms 10 150 1m43s 687ms 11 98 1m8s 695ms 12 13 11s872ms 913ms 13 125 1m26s 690ms 14 124 1m36s 780ms 15 68 1m3s 938ms 16 171 2m12s 773ms 17 17 23s555ms 1s385ms [ User: intelifix - Total duration: 13m28s - Times executed: 1057 ]
[ Application: [unknown] - Total duration: 13m28s - Times executed: 1057 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "279002", "modelo" : "320", "itens" : "241688900007,241645824545,241717186369,241621046571,241660751637,241672211431,241631102626,241594190113,241603787378,241615130619,241630182727,241709742344,241703351114,241690179716,230049252528,241655156174,241668236878,241620835866,241704646178,241655508587,241598871939,241593713545,241609849306,241631468295,230048531212,241664804052,241639118706,241701304550,241645522945,241671498599", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-18 17:29:57 Duration: 7s932ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "278791", "modelo" : "320", "itens" : "241658500407,241629326369,241651084969,241637804447,241679534154,241669945777,241592240708,230055065463,241666334549,241619613132,241657047492,241617110913,241666097376,241712266686,241673288493,241628888088,241603359604,241708405759,241666438701,241603365362,241619745367,241593168485,241639110019,241637820005,241700285674,241669934665,241639386969,241604195555,241706599499,241651980422,241617561114,241667983240,241651087696,241606226887,241645520723,241614895870,241630752637,241651186572,241653995264,241634529919,241637519515,241651075675,241709801216,241618142944,241635408602,241658672646,230055033036,241682647375", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-18 07:07:55 Duration: 4s563ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "241543", "modelo" : "305", "itens" : "241681680425,229951637288,230030840103,241670918789,241681802232,241639716777,241683134348,241681571727,241683058000,241656187172", "usuario" : "414", "caixa" : "2880602", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-18 13:37:45 Duration: 4s204ms 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 4 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 18 19 1 0ms 0ms 21 2 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 5s135ms - Times executed: 4 ]
[ Application: psql - Total duration: 5s135ms - Times executed: 4 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 18,345 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 26 FATAL entries
- 3857 ERROR entries
- 0 WARNING entries
- 8 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,776 Max number of times the same event was reported
- 3,891 Total events found
Rank Times reported Error 1 3,776 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 18 00 57 01 52 02 58 03 47 04 57 05 57 06 56 07 245 08 426 09 500 10 409 11 204 12 67 13 207 14 476 15 369 16 207 17 73 18 58 19 57 20 56 21 38 - ERROR: prepared statement "_PLAN000000002A5D00E0" does not exist
- ERROR: prepared statement "_PLAN000000002A5D1C40" does not exist
- ERROR: prepared statement "_PLAN000000002A5CFC50" does not exist
Statement: DEALLOCATE "_PLAN000000002A5D00E0"
Date: 2026-08-18 00:00:19 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002A5D1C40"
Date: 2026-08-18 00:01:19 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002A5CFC50"
Date: 2026-08-18 00:02:19 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 18 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-18 00:05:03 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-18 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-18 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
3 16 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 18 00 2 01 1 02 1 03 2 06 1 07 2 10 1 11 1 12 2 14 1 15 1 18 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-08-18 00:02:30 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-18 00:38:45 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-18 01:40:00 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
4 15 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 18 09 3 10 2 14 10 - ERROR: syntax error at or near ")" at character 34
- ERROR: syntax error at or near ")" at character 34
- ERROR: syntax error at or near ")" at character 34
Statement: select * from rs_caixa_qr(337886,)
Date: 2026-08-18 09:19:21 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(337886,)
Date: 2026-08-18 09:19:21 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(337886,)
Date: 2026-08-18 09:19:28 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
5 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 18 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-08-18 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-08-18 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-08-18 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
6 6 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 18 08 2 09 1 10 2 17 1 - ERROR: column "seig624084012cd8ae5a77e4" does not exist at character 27
- ERROR: column "seig624084012cd8ae5a77e4" does not exist at character 27
- ERROR: column "pas_id" does not exist at character 66 2026-08-18 09:53:27 -03 [3374455]: [106-1] user=intelifix,db=rio,app=[unknown],client=[local] QUERY: SELECT * FROM PARTE_MOVIMENTOS WHERE PM_ID = ANY( aPMs ) AND PAS_ID = nPasso
Statement: select * from rs_caixa_qr(SEIG624084012CD8AE5A77E4)
Date: 2026-08-18 08:30:27 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(SEIG624084012CD8AE5A77E4)
Date: 2026-08-18 08:30:27 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Context: PL/pgSQL function rs_caixa_kits_exclui(integer,integer) line 46 at FOR over SELECT rows PL/pgSQL function rs_lote_saida_exclui(integer) line 87 at assignment
Hint: Perhaps you meant to reference the column "parte_movimentos.ps_id".
Statement: SELECT * FROM RS_LOTE_SAIDA_EXCLUI(0278658); NOTICE: table "tmp_entrada" does not exist, skippingDate: 2026-08-18 09:53:27 Database: rio Application: [unknown] User: intelifix Remote: [local]
7 5 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 18 10 4 15 1 - LOG: process 3441142 still waiting for ShareLock on transaction 4598029 after 1000.081 ms
- LOG: process 3441142 still waiting for ShareLock on transaction 4598029 after 41004.395 ms
- LOG: process 3390686 still waiting for ShareLock on transaction 4598698 after 1000.077 ms
Detail: Process holding the lock: 3390686. Wait queue: 3441142.
Context: while deleting tuple (63563,147) in relation "codigos_barra" SQL statement "DELETE FROM CODIGOS_BARRA WHERE EQ_ID = cRet.ID" PL/pgSQL function rs_equipamento_manutencao(integer,integer,integer,integer,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 655 at SQL statement SQL statement "SELECT * FROM RS_EQUIPAMENTO_MANUTENCAO( 0,5,34,6,507,'465043426372','','465043426372','216475549292',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 920 at EXECUTE PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 028638, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-08-18 10:07:00 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 3390686. Wait queue: 3441142.
Context: while deleting tuple (63563,147) in relation "codigos_barra" SQL statement "DELETE FROM CODIGOS_BARRA WHERE EQ_ID = cRet.ID" PL/pgSQL function rs_equipamento_manutencao(integer,integer,integer,integer,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 655 at SQL statement SQL statement "SELECT * FROM RS_EQUIPAMENTO_MANUTENCAO( 0,5,34,6,507,'465043426372','','465043426372','216475549292',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 920 at EXECUTE PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 028638, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-08-18 10:07:40 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 3441142. Wait queue: 3390686.
Context: while deleting tuple (63621,133) in relation "codigos_barra" SQL statement "DELETE FROM CODIGOS_BARRA WHERE EQ_ID = cRet.ID" PL/pgSQL function rs_equipamento_manutencao(integer,integer,integer,integer,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 655 at SQL statement SQL statement "SELECT * FROM RS_EQUIPAMENTO_MANUTENCAO( 0,5,39,6,502,'317137172639','','317137172639','B42A0ED375F3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 920 at EXECUTE PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 028630, 0502 )' , '/var/www/html/tmp/nf_carga_lotes_0502.xlsx' )Date: 2026-08-18 10:09:02 Database: rio Application: [unknown] User: intelifix Remote: [local]
8 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 18 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-18 05:32:12 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-18 05:32:12 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-18 05:32:12 Database: contagem Application: psql User: intelifix Remote: [local]
9 3 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Aug 18 09 1 10 2 - ERROR: unterminated quoted string at or near "''');" at character 39
- ERROR: unterminated quoted string at or near "''');" at character 39
- ERROR: unterminated quoted string at or near "''');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-08-18 09:16:37 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-08-18 10:22:45 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-08-18 10:22:54 Database: contagem Application: [unknown] User: intelifix Remote: [local]
10 3 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #10
Day Hour Count Aug 18 15 3 - ERROR: trailing junk after numeric literal at or near "20AB48B92D9E" at character 27
- ERROR: trailing junk after numeric literal at or near "20AB48B92D9E" at character 27
- ERROR: trailing junk after numeric literal at or near "20AB48B92D9E" at character 27
Statement: select * from rs_caixa_qr(20AB48B92D9E)
Date: 2026-08-18 15:40:04 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(20AB48B92D9E)
Date: 2026-08-18 15:40:05 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(20AB48B92D9E)
Date: 2026-08-18 15:40:06 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
11 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #11
Day Hour Count Aug 18 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-18 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-18 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-18 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
12 2 ERROR: function rs_caixa_qr(...) does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Aug 18 10 2 - ERROR: function rs_caixa_qr(numeric) does not exist at character 15
- ERROR: function rs_caixa_qr(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select * from rs_caixa_qr(390797.)Date: 2026-08-18 10:21:23 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select * from rs_caixa_qr(390797.)Date: 2026-08-18 10:21:24 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
13 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #13
Day Hour Count Aug 18 09 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000288744"
Date: 2026-08-18 09:51:44
14 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #14
Day Hour Count Aug 18 03 1 - LOG: database system was shut down at 2026-08-18 03:05:01 -03
Date: 2026-08-18 03:05:02
15 1 LOG: skipping analyze of "..." --- lock not available
Times Reported Most Frequent Error / Event #15
Day Hour Count Aug 18 16 1 - LOG: skipping analyze of "temp0000288846" --- lock not available
Date: 2026-08-18 16:03:10
16 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #16
Day Hour Count Aug 18 09 1 - LOG: process 3425010 still waiting for AccessExclusiveLock on relation 3934043 of database 358220 after 1000.184 ms
Detail: Process holding the lock: 3426167. Wait queue: 3425010.
Statement: DROP TABLE IF EXISTS temp0000288744;Date: 2026-08-18 09:51:44 Database: rio Application: [unknown] User: intelifix Remote: [local]
17 1 ERROR: invalid input syntax for type integer: ...
Times Reported Most Frequent Error / Event #17
Day Hour Count Aug 18 17 1 - ERROR: invalid input syntax for type integer: ""
Context: PL/pgSQL function rs_pre_alerta_tela(text) line 30 at assignment
Statement: SELECT * FROM RS_PRE_ALERTA_TELA('{"barra1":"485754432017F9B8","barra2":"40B15CB23E57","barra3":"WIFITWPASCLARO_B23E57PA","lote":""}');Date: 2026-08-18 17:02:18 Database: contagem Application: [unknown] User: intelifix Remote: [local]