pgBadger-
Global information
- Generated on Mon Aug 24 23:50:19 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 42,852 log entries in 16s
- Log start from 2026-08-24 00:00:37 to 2026-08-24 23:49:50
-
Overview
Global Stats
- 387 Number of unique normalized queries
- 7,153 Number of queries
- 10h31m34s Total query duration
- 2026-08-24 00:02:39 First query
- 2026-08-24 23:44:46 Last query
- 5 queries/s at 2026-08-24 09:13:38 Query peak
- 10h31m34s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 10h31m34s Execute total duration
- 3,557 Number of events
- 16 Number of unique normalized events
- 3,479 Max number of times the same event was reported
- 0 Number of cancellation
- 454 Total number of automatic vacuums
- 942 Total number of automatic analyzes
- 13 Number temporary file
- 242.37 MiB Max size of temporary file
- 103.68 MiB Average size of temporary file
- 359 Total number of sessions
- 8 sessions at 2026-08-24 16:26:20 Session peak
- 13d9h27m13s Total duration of sessions
- 53m43s Average duration of sessions
- 19 Average queries per session
- 1m45s Average queries duration per session
- 51m57s Average idle time per session
- 387 Total number of connections
- 3 connections/s at 2026-08-24 07:05:04 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-24 09:13:38 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-24 10:18:49 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-24 23:44:18 Date
Queries duration
Key values
- 10h31m34s 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 24 00 24 0ms 35s337ms 7s282ms 4s516ms 21s471ms 1m20s 01 12 0ms 4s352ms 2s188ms 4s144ms 4s282ms 4s817ms 02 12 0ms 4s617ms 2s213ms 4s188ms 4s421ms 4s854ms 03 12 0ms 5s372ms 2s113ms 874ms 4s615ms 5s819ms 04 11 0ms 4s518ms 2s473ms 4s116ms 4s657ms 4s805ms 05 20 0ms 10m48s 1m12s 10s392ms 3m11s 10m48s 06 26 0ms 2m7s 8s886ms 4s533ms 32s891ms 2m15s 07 226 0ms 16m2s 8s116ms 42s20ms 2m21s 16m2s 08 590 0ms 10m31s 5s492ms 2m11s 7m11s 11m33s 09 724 150ms 15m20s 4s436ms 1m32s 5m53s 15m45s 10 825 150ms 12m52s 4s579ms 2m9s 8m57s 12m59s 11 712 150ms 13m44s 4s714ms 1m7s 7m52s 14m13s 12 353 0ms 11m43s 7s901ms 1m25s 5m47s 11m46s 13 411 0ms 6m49s 3s149ms 38s326ms 1m41s 6m50s 14 658 150ms 10m4s 4s87ms 1m7s 4m38s 11m7s 15 848 150ms 8m3s 3s358ms 57s348ms 6m12s 9m44s 16 764 150ms 7m56s 3s138ms 59s517ms 4m46s 8m3s 17 324 0ms 11m49s 7s324ms 1m26s 4m36s 11m52s 18 25 0ms 7m13s 30s346ms 7s133ms 17s112ms 7m51s 19 24 0ms 5m49s 26s630ms 6s675ms 48s960ms 5m49s 20 129 0ms 7m1s 10s159ms 1m10s 1m29s 7m49s 21 39 0ms 6m3s 17s483ms 7s363ms 9s675ms 6m51s 22 36 0ms 5m25s 18s335ms 9s202ms 16s155ms 5m55s 23 348 0ms 1m30s 5s960ms 1m7s 1m14s 1m31s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 24 00 4 0 12s468ms 0ms 0ms 186ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 258ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 11 0 15s772ms 0ms 0ms 42s581ms 07 154 0 10s289ms 2s42ms 11s788ms 5m22s 08 420 0 6s115ms 16s279ms 2m6s 8m49s 09 574 0 4s771ms 13s916ms 1m 11m1s 10 652 0 4s871ms 30s149ms 1m45s 10m8s 11 550 0 5s198ms 27s259ms 43s447ms 9m22s 12 232 0 9s788ms 8s814ms 1m25s 7m26s 13 340 0 3s288ms 9s900ms 19s260ms 4m3s 14 515 0 4s206ms 19s569ms 40s387ms 7m37s 15 700 0 3s377ms 21s614ms 31s540ms 7m41s 16 590 0 3s461ms 25s428ms 47s944ms 7m7s 17 258 0 8s180ms 22s866ms 1m26s 5m24s 18 7 0 1m40s 0ms 0ms 3m35s 19 6 0 1m37s 0ms 0ms 3m9s 20 20 88 11s518ms 22s381ms 1m5s 3m26s 21 16 0 38s328ms 0ms 433ms 3m17s 22 12 0 48s654ms 0ms 169ms 3m30s 23 25 323 5s960ms 1m2s 1m7s 1m30s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 24 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 24 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 1 1.00 0.00% 07 0 20 20.00 0.00% 08 0 34 34.00 0.00% 09 0 17 17.00 0.00% 10 0 27 27.00 0.00% 11 0 29 29.00 0.00% 12 0 21 21.00 0.00% 13 0 12 12.00 0.00% 14 0 20 20.00 0.00% 15 0 16 16.00 0.00% 16 0 12 12.00 0.00% 17 0 7 7.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 2 2.00 0.00% 22 0 1 1.00 0.00% 23 0 3 3.00 0.00% Day Hour Count Average / Second Aug 24 00 17 0.00/s 01 9 0.00/s 02 8 0.00/s 03 14 0.00/s 04 8 0.00/s 05 12 0.00/s 06 16 0.00/s 07 16 0.00/s 08 26 0.01/s 09 25 0.01/s 10 23 0.01/s 11 21 0.01/s 12 17 0.00/s 13 22 0.01/s 14 23 0.01/s 15 22 0.01/s 16 22 0.01/s 17 18 0.01/s 18 9 0.00/s 19 9 0.00/s 20 14 0.00/s 21 11 0.00/s 22 12 0.00/s 23 13 0.00/s Day Hour Count Average Duration Average idle time Aug 24 00 7 53m17s 52m52s 01 13 1h41s 1h39s 02 7 1h1s 59m57s 03 12 21m24s 21m22s 04 7 1h2m34s 1h2m31s 05 8 54m8s 51m8s 06 9 59m26s 59m1s 07 15 57m40s 55m38s 08 18 53m31s 50m31s 09 24 54m47s 52m33s 10 24 52m45s 50m8s 11 19 53m23s 50m26s 12 22 50m43s 48m36s 13 15 50m16s 48m49s 14 21 56m13s 54m5s 15 20 58m45s 56m23s 16 23 54m19s 52m35s 17 21 55m14s 53m21s 18 14 1h13s 59m19s 19 9 1h39s 59m28s 20 12 46m2s 44m12s 21 10 1h54s 59m46s 22 11 1h58s 59m58s 23 18 42m14s 40m19s -
Connections
Established Connections
Key values
- 3 connections Connection Peak
- 2026-08-24 07:05:04 Date
Connections per database
Key values
- rio Main Database
- 387 connections Total
Connections per user
Key values
- intelifix Main User
- 387 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-08-24 16:26:20 Date
Histogram of session times
Key values
- 297 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 359 sessions Total
Sessions per user
Key values
- intelifix Main User
- 359 sessions Total
Sessions per host
Key values
- [local] Main Host
- 359 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 13,744 buffers Checkpoint Peak
- 2026-08-24 12:09:34 Date
- 270.044 seconds Highest write time
- 0.389 seconds Sync time
Checkpoints Wal files
Key values
- 11 files Wal files usage Peak
- 2026-08-24 08:44:34 Date
Checkpoints distance
Key values
- 364.80 Mo Distance Peak
- 2026-08-24 12:14:34 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 24 00 5,241 269.28s 0.025s 269.336s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 12,384 0.551s 0.042s 0.629s 04 0 0s 0s 0s 05 7,631 764.796s 0.22s 765.103s 06 4,034 386.146s 0.04s 386.209s 07 12,360 1,224.031s 0.345s 1,224.528s 08 58,917 2,969.674s 1.414s 2,971.317s 09 49,118 3,237.751s 1.672s 3,239.676s 10 51,207 3,237.65s 1.794s 3,239.714s 11 63,679 3,221.657s 1.757s 3,223.646s 12 46,891 2,741.029s 0.849s 2,742.074s 13 21,975 2,285.088s 1.055s 2,286.302s 14 54,379 3,237.706s 1.037s 3,238.99s 15 60,884 3,237.755s 1.689s 3,239.751s 16 61,130 3,231.966s 1.317s 3,233.535s 17 44,225 2,267.918s 0.986s 2,269.058s 18 1,991 199.664s 0.087s 199.823s 19 57 5.766s 0.062s 5.851s 20 1,473 178.104s 0.083s 178.239s 21 3,076 309.733s 0.229s 310.03s 22 2,478 249.031s 0.229s 249.334s 23 367 36.982s 0.079s 37.123s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 24 00 0 0 2 28 0.010s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 4 35 0.027s 0.01s 04 0 0 0 0 0s 0s 05 0 0 3 154 0.058s 0.016s 06 0 0 1 36 0.019s 0.005s 07 0 0 4 2,480 0.029s 0.012s 08 0 0 43 6,256 0.053s 0.012s 09 0 0 27 7,491 0.034s 0.012s 10 0 0 34 7,468 0.054s 0.012s 11 0 0 35 6,247 0.130s 0.012s 12 0 0 41 4,024 0.062s 0.012s 13 0 0 8 5,084 0.120s 0.012s 14 0 0 36 6,322 0.060s 0.012s 15 0 0 39 6,946 0.071s 0.012s 16 0 0 37 6,065 0.058s 0.012s 17 0 0 29 4,159 0.068s 0.011s 18 0 0 0 209 0.042s 0.011s 19 0 0 1 16 0.021s 0.015s 20 0 0 0 83 0.031s 0.004s 21 0 0 1 476 0.063s 0.008s 22 0 0 1 524 0.071s 0.017s 23 0 0 0 44 0.028s 0.04s Day Hour Count Avg time (sec) Aug 24 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 24 00 26,976.00 kB 26,976.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 33,103.50 kB 33,103.50 kB 04 0.00 kB 0.00 kB 05 7,182.57 kB 10,136.00 kB 06 7,915.50 kB 10,886.50 kB 07 6,107.92 kB 10,593.33 kB 08 58,734.17 kB 90,738.42 kB 09 36,099.25 kB 92,492.83 kB 10 46,866.33 kB 100,761.83 kB 11 48,282.42 kB 95,709.25 kB 12 55,236.08 kB 131,325.42 kB 13 10,866.92 kB 52,289.58 kB 14 49,470.83 kB 69,383.08 kB 15 52,890.92 kB 101,115.67 kB 16 51,218.00 kB 90,056.92 kB 17 42,115.64 kB 75,055.73 kB 18 3,472.25 kB 54,385.75 kB 19 99.67 kB 38,231.67 kB 20 4,415.00 kB 28,952.67 kB 21 2,278.29 kB 18,254.00 kB 22 1,449.00 kB 8,903.11 kB 23 149.57 kB 4,228.14 kB -
Temporary Files
Size of temporary files
Key values
- 484.73 MiB Temp Files size Peak
- 2026-08-24 05:32:05 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-24 05:32:12 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 24 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 12 1.21 GiB 103.65 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 1 104.00 MiB 104.00 MiB 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 941.72 MiB 72.29 MiB 242.37 MiB 117.71 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-24 05:32:13 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-24 05:32:05 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 302.10 MiB 56.15 MiB 92.40 MiB 75.53 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-24 05:30:45 Duration: 42s784ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-24 05:30:42 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 1 104.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028884, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-24 09:16:13 Duration: 10m53s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028875, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-24 08:25:51 Duration: 10m31s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028889, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-24 10:57:11 Duration: 9m53s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
Queries generating the largest temporary files
Rank Size Query 1 242.37 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-24 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 242.37 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-24 05:32:05 - 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-24 12:00:56 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 92.40 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-24 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 92.40 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-24 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 80.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-24 05:32:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 79.99 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-24 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 79.99 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-24 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 72.36 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-24 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 72.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-24 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 72.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-24 05:32:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 61.16 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-24 05:30:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 56.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-24 05:30:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.54 sec Highest CPU-cost vacuum
Table public.nf_entrada_modelos
Database contagem - 2026-08-24 13:35:52 Date
- 0 sec Highest CPU-cost analyze
Table
Database contagem - Date
Average Autovacuum Duration
Key values
- 0.54 sec Highest CPU-cost vacuum
Table public.nf_entrada_modelos
Database contagem - 2026-08-24 13:35:52 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (119) Main table analyzed (database rio)
- 942 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 119 rio.pg_catalog.pg_class 55 brasilia.pg_catalog.pg_attribute 51 rio.public.temp0000289444 50 rio.pg_catalog.pg_type 47 rio.public.usuarios 44 rio.pg_catalog.pg_index 32 brasilia.pg_catalog.pg_class 29 brasilia.pg_catalog.pg_type 25 rio.pg_catalog.pg_depend 24 rio.public.temp0000289408 23 contagem.pg_catalog.pg_attribute 22 contagem.public.usuarios 22 rio.public.temp0000289366 17 brasilia.pg_catalog.pg_index 16 rio.public.temp0000289472 16 brasilia.public.temp0000238738 16 rio.public.temp0000289360 15 rio.public.temp0000289370 14 brasilia.pg_catalog.pg_depend 14 rio.public.temp0000289368 13 rio.public.temp0000289442 12 contagem.public.temp0000226915 12 rio.public.temp0000289418 11 brasilia.public.temp0000238746 11 contagem.public.temp0000226913 11 rio.public.temp0000289362 11 contagem.pg_catalog.pg_class 10 rio.public.temp0000289223 10 brasilia.public.usuarios 10 rio.public.temp0000289374 10 brasilia.public.temp0000238792 9 rio.public.temp0000289382 8 contagem.pg_catalog.pg_type 8 rio.public.temp0000289402 7 brasilia.public.temp0000238754 7 rio.public.temp0000289430 7 rio.public.tmp_drill_0302 7 rio.public.temp0000289448 6 contagem.pg_catalog.pg_shdepend 6 rio.public.temp0000289239 6 contagem.pg_catalog.pg_index 5 brasilia.pg_catalog.pg_shdepend 5 contagem.public.temp0000226907 5 contagem.public.temp0000226911 5 brasilia.public.temp0000238772 5 rio.public.temp0000289440 4 contagem.pg_catalog.pg_depend 4 brasilia.public.nf_entrada 3 brasilia.public.temp0000238762 3 contagem.public.nf_entrada 3 brasilia.public.temp0000238764 3 contagem.public.temp0000226909 3 brasilia.public.temp0000238756 3 rio.public.temp0000289474 3 rio.public.temp0000289380 2 rio.public.temp0000289478 2 brasilia.public.temp0000238812 2 rio.public.temp0000289388 2 rio.public.temp0000289392 2 rio.public.temp0000289462 2 brasilia.public.temp0000238774 2 rio.pg_catalog.pg_shdepend 2 brasilia.public.temp0000238820 2 rio.public.temp0000289378 2 rio.public.temp0000289422 2 rio.public.temp0000289400 2 rio.public.temp0000289358 1 brasilia.public.temp0000238758 1 brasilia.public.temp0000238824 1 rio.public.temp0000289464 1 brasilia.public.temp0000238750 1 rio.public.temp0000289466 1 contagem.public.temp0000226905 1 brasilia.public.temp0000238810 1 rio.public.temp0000289386 1 rio.public.temp0000289420 1 rio.public.temp0000289476 1 brasilia.public.temp0000238776 1 rio.public.temp0000289396 1 rio.public.temp0000289404 1 rio.public.temp0000289460 1 brasilia.public.temp0000238742 1 rio.public.equipamento_mudancas 1 brasilia.public.temp0000238786 1 rio.public.temp0000289432 1 rio.public.temp0000289384 1 rio.public.temp0000289456 1 Total 942 Vacuums per table
Key values
- pg_catalog.pg_attribute (52) Main table vacuumed on database rio
- 454 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 52 41 0 0 0 0 0 21,372 6,530 9,364,423 371 9,083 rio.pg_catalog.pg_class 32 22 0 0 0 0 0 4,103 1,522 2,304,604 103 386 rio.pg_catalog.pg_type 29 22 0 0 0 0 0 1,869 636 857,717 79 245 rio.public.temp0000289408 25 0 0 0 0 0 0 13,126 3,605 5,301,197 0 0 contagem.public.usuarios 22 0 0 0 0 0 0 100 78 43,992 0 0 brasilia.pg_catalog.pg_attribute 21 20 0 0 0 0 0 10,530 1,758 3,484,954 52 1,396 rio.public.usuarios 21 7 0 0 0 0 0 199 61 124,727 11 14 rio.public.temp0000289472 17 0 0 0 0 0 0 11,051 235 987,305 0 0 rio.public.temp0000289444 16 0 0 0 0 0 0 4,729 275 635,093 0 0 brasilia.pg_catalog.pg_class 14 13 0 0 0 0 0 2,558 431 837,194 12 47 rio.public.temp0000289370 13 0 0 0 0 0 0 848 187 259,317 0 0 brasilia.pg_catalog.pg_type 13 11 0 0 0 0 0 1,148 191 333,677 12 34 rio.pg_catalog.pg_index 11 11 0 0 0 0 0 750 246 224,204 47 97 rio.public.tmp_drill_0302 11 5 0 0 0 0 0 2,202 48 392,429 2 117 rio.public.temp0000289418 11 0 0 0 0 0 0 10,530 5,281 7,397,052 0 0 rio.pg_catalog.pg_depend 9 9 0 0 0 0 0 3,002 1,271 1,669,595 60 553 rio.public.temp0000289382 8 0 0 0 0 0 0 7,016 1,775 2,682,441 0 0 contagem.pg_catalog.pg_attribute 8 8 0 0 0 0 0 6,300 1,123 2,338,842 16 450 brasilia.pg_catalog.pg_index 8 7 0 0 0 0 0 365 48 78,084 6 17 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 10,033 2,834 12,381,359 1,441 6,761 rio.public.temp0000289402 7 0 0 0 0 0 0 5,266 24 314,655 0 0 rio.public.temp0000289239 6 0 0 0 0 0 0 521 146 228,513 0 0 rio.public.temp0000289223 6 0 0 0 0 0 0 496 130 201,265 0 0 brasilia.pg_catalog.pg_depend 5 5 0 0 0 0 0 1,597 389 663,859 12 102 rio.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 777 242 366,834 51 94 rio.public.temp0000289448 5 0 0 0 0 0 0 519 144 245,365 0 0 contagem.public.temp0000226911 4 0 0 0 0 0 0 349 23 24,466 0 0 contagem.pg_catalog.pg_type 4 4 0 0 0 0 0 592 91 170,899 4 12 contagem.pg_catalog.pg_class 4 4 0 0 0 0 0 1,094 93 223,453 3 9 rio.public.temp0000289440 4 0 0 0 0 0 0 1,762 13 106,175 0 0 contagem.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 545 164 266,351 18 24 brasilia.public.temp0000238756 3 0 0 0 0 0 0 256 10 16,824 0 0 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,133 763 3,286,307 523 3,651 brasilia.public.temp0000238764 3 0 0 0 0 0 0 741 256 425,121 0 0 contagem.pg_catalog.pg_index 3 3 0 0 0 0 0 269 51 70,168 1 2 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,793 480 2,516,911 158 527 contagem.public.nf_entrada 2 2 0 0 0 0 0 226 82 139,153 5 16 rio.public.temp0000289400 2 0 0 0 0 0 0 16 10 2,584 0 0 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,973 376 1,532,972 284 2,115 rio.public.temp0000289462 2 0 0 0 0 0 0 174 12 12,095 0 0 contagem.pg_catalog.pg_depend 2 2 0 0 0 0 0 1,041 162 402,687 1 6 rio.public.temp0000289430 2 0 0 0 0 0 0 85 11 6,687 0 0 rio.public.temp0000289380 2 0 0 0 0 0 0 174 12 12,098 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 353 70 368,322 33 105 rio.public.temp0000289378 2 0 0 0 0 0 0 83 9 6,334 0 0 brasilia.public.temp0000238812 2 0 0 0 0 0 0 494 8 30,352 0 0 rio.public.temp0000289374 2 0 0 0 0 0 0 71 7 5,330 0 0 rio.public.temp0000289478 2 0 0 0 0 0 0 1,755 7 104,686 0 0 rio.public.temp0000289432 1 0 0 0 0 0 0 84 6 5,864 0 0 rio.public.temp0000289464 1 0 0 0 0 0 0 87 6 6,048 0 0 rio.public.temp0000289460 1 0 0 0 0 0 0 87 6 6,047 0 0 rio.public.temp0000289404 1 0 0 0 0 0 0 8 5 1,292 0 0 rio.public.temp0000289456 1 0 0 0 0 0 0 87 6 6,047 0 0 rio.public.temp0000289466 1 0 0 0 0 0 0 87 6 6,046 0 0 rio.public.temp0000289392 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000289384 1 0 0 0 0 0 0 79 78 144,011 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 141 25 82,004 12 27 contagem.public.temp0000226909 1 0 0 0 0 0 0 113 6 7,649 0 0 rio.public.temp0000289386 1 0 0 0 0 0 0 8 5 1,288 0 0 rio.public.temp0000289396 1 0 0 0 0 0 0 8 5 1,286 0 0 contagem.public.nf_entrada_modelos 1 1 0 0 0 0 0 1,008 560 1,839,086 114 6,329 contagem.public.parametros 1 1 0 0 0 0 0 121 57 15,755 1 1 Total 454 224 0 0 0 0 0 141,908 32,694 65,571,869 3,432 32,220 Vacuum throughput per table
Key values
- pg_catalog.pg_attribute (3.91) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 3.91 rio.pg_catalog.pg_class 0 0 1.16 rio.pg_catalog.pg_type 0 0 0.47 rio.public.temp0000289408 0 0 0.99 contagem.public.usuarios 0 0 0.09 brasilia.pg_catalog.pg_attribute 0 0 1.64 rio.public.usuarios 0 0 0.05 rio.public.temp0000289472 0 0 0.7 rio.public.temp0000289444 0 0 0.35 brasilia.pg_catalog.pg_class 0 0 0.84 rio.public.temp0000289370 0 0 0.15 brasilia.pg_catalog.pg_type 0 0 0.33 rio.pg_catalog.pg_index 0 0 0.57 rio.public.tmp_drill_0302 0 0 0.09 rio.public.temp0000289418 0 0 0.71 rio.pg_catalog.pg_depend 0 0 1.34 rio.public.temp0000289382 0 0 0.49 contagem.pg_catalog.pg_attribute 0 0 1.3 brasilia.pg_catalog.pg_index 0 0 0.25 rio.pg_catalog.pg_statistic 0 0 1.57 rio.public.temp0000289402 0 0 0.39 rio.public.temp0000289239 0 0 0.1 rio.public.temp0000289223 0 0 0.12 brasilia.pg_catalog.pg_depend 0 0 0.53 rio.pg_catalog.pg_shdepend 0 0 0.42 rio.public.temp0000289448 0 0 0.01 contagem.public.temp0000226911 0 0 0.08 contagem.pg_catalog.pg_type 0 0 0.24 contagem.pg_catalog.pg_class 0 0 0.48 rio.public.temp0000289440 0 0 0.21 contagem.pg_catalog.pg_shdepend 0 0 0.31 brasilia.public.temp0000238756 0 0 0.01 brasilia.pg_catalog.pg_statistic 0 0 0.6 brasilia.public.temp0000238764 0 0 0.02 contagem.pg_catalog.pg_index 0 0 0.28 rio.pg_toast.pg_toast_2619 0 0 0.28 contagem.public.nf_entrada 0 0 0.11 rio.public.temp0000289400 0 0 0.02 contagem.pg_catalog.pg_statistic 0 0 0.31 rio.public.temp0000289462 0 0 0.02 contagem.pg_catalog.pg_depend 0 0 0.44 rio.public.temp0000289430 0 0 0.03 rio.public.temp0000289380 0 0 0.04 brasilia.pg_toast.pg_toast_2619 0 0 0.05 rio.public.temp0000289378 0 0 0.07 brasilia.public.temp0000238812 0 0 0.01 rio.public.temp0000289374 0 0 0 rio.public.temp0000289478 0 0 0.11 rio.public.temp0000289432 0 0 0.02 rio.public.temp0000289464 0 0 0.02 rio.public.temp0000289460 0 0 0.01 rio.public.temp0000289404 0 0 0.01 rio.public.temp0000289456 0 0 0.02 rio.public.temp0000289466 0 0 0.01 rio.public.temp0000289392 0 0 0 rio.public.temp0000289384 0 0 0.02 contagem.pg_toast.pg_toast_2619 0 0 0.01 contagem.public.temp0000226909 0 0 0.01 rio.public.temp0000289386 0 0 0.01 rio.public.temp0000289396 0 0 0.02 contagem.public.nf_entrada_modelos 0 0 0.54 contagem.public.parametros 0 0 0.12 Total 0 0 23.11 Tuples removed per table
Key values
- pg_catalog.pg_attribute (162582) Main table with removed tuples on database rio
- 432914 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 52 41 162,582 1,357,777 125,053 0 32,576 brasilia.pg_catalog.pg_attribute 21 20 102,777 500,530 19,902 169 14,360 contagem.pg_catalog.pg_attribute 8 8 54,715 189,959 34 510 4,338 rio.public.tmp_drill_0302 11 5 32,402 79,047 22,960 0 1,412 rio.pg_catalog.pg_statistic 7 7 13,118 57,704 139 0 9,002 rio.pg_catalog.pg_depend 9 9 9,102 174,180 2,696 0 1,679 brasilia.pg_catalog.pg_statistic 3 3 6,455 24,155 0 0 3,216 rio.pg_catalog.pg_type 29 22 5,967 72,569 6,324 0 2,016 brasilia.pg_catalog.pg_type 13 11 5,951 30,631 1,884 22 1,075 contagem.pg_catalog.pg_statistic 2 2 5,679 14,940 0 0 2,022 rio.pg_catalog.pg_shdepend 5 5 4,708 68,011 37 0 620 rio.pg_catalog.pg_class 32 22 4,456 159,580 17,499 33 4,991 contagem.pg_catalog.pg_shdepend 3 3 3,940 40,797 75 0 372 contagem.pg_catalog.pg_type 4 4 3,914 9,002 2 66 254 brasilia.pg_catalog.pg_index 8 7 2,700 15,965 944 10 444 rio.pg_catalog.pg_index 11 11 2,696 21,171 68 12 618 contagem.public.nf_entrada_modelos 1 1 2,085 34,495 0 0 396 contagem.pg_catalog.pg_index 3 3 1,884 5,691 1 34 157 brasilia.pg_catalog.pg_depend 5 5 1,828 91,073 3,724 0 943 contagem.public.usuarios 22 0 1,344 528 0 0 44 brasilia.pg_catalog.pg_class 14 13 1,230 62,352 4,623 0 2,258 rio.pg_toast.pg_toast_2619 3 3 988 2,316 11 0 792 contagem.pg_catalog.pg_class 4 4 599 13,925 4 0 616 contagem.public.nf_entrada 2 2 543 2,049 0 0 158 contagem.pg_catalog.pg_depend 2 2 537 38,146 6 53 343 rio.public.usuarios 21 7 402 14,142 3,453 0 441 brasilia.pg_toast.pg_toast_2619 2 2 183 271 0 25 92 contagem.pg_toast.pg_toast_2619 1 1 109 110 0 19 41 contagem.public.parametros 1 1 20 384 0 0 58 rio.public.temp0000289432 1 0 0 1,418 0 52 76 rio.public.temp0000289400 2 0 0 2,732 0 112 144 rio.public.temp0000289464 1 0 0 1,458 0 49 79 rio.public.temp0000289382 8 0 0 197,485 0 0 14,336 rio.public.temp0000289472 17 0 0 280,540 0 291 20,189 rio.public.temp0000289444 16 0 0 102,702 0 499 4,877 contagem.public.temp0000226911 4 0 0 5,367 0 96 416 rio.public.temp0000289408 25 0 0 384,657 0 518 27,642 rio.public.temp0000289460 1 0 0 1,458 0 49 79 brasilia.public.temp0000238756 3 0 0 9,703 0 0 768 rio.public.temp0000289370 13 0 0 46,386 0 270 1,042 rio.public.temp0000289404 1 0 0 1,366 0 56 72 rio.public.temp0000289462 2 0 0 2,916 0 98 158 rio.public.temp0000289456 1 0 0 1,458 0 49 79 rio.public.temp0000289466 1 0 0 1,458 0 49 79 rio.public.temp0000289392 1 0 0 5,503 0 0 128 rio.public.temp0000289239 6 0 0 21,315 0 95 481 rio.public.temp0000289223 6 0 0 23,006 0 124 516 brasilia.public.temp0000238764 3 0 0 9,708 0 0 768 rio.public.temp0000289384 1 0 0 1,366 0 57 71 rio.public.temp0000289418 11 0 0 271,754 0 0 19,712 rio.public.temp0000289430 2 0 0 6,276 0 116 140 rio.public.temp0000289380 2 0 0 2,911 0 98 158 contagem.public.temp0000226909 1 0 0 1,340 0 24 104 rio.public.temp0000289386 1 0 0 1,366 0 57 71 rio.public.temp0000289396 1 0 0 1,366 0 57 71 rio.public.temp0000289378 2 0 0 26,056 0 57 1,863 rio.public.temp0000289448 5 0 0 27,227 0 10 630 rio.public.temp0000289402 7 0 0 172,806 0 0 12,544 brasilia.public.temp0000238812 2 0 0 6,477 0 0 512 rio.public.temp0000289374 2 0 0 5,644 0 0 128 rio.public.temp0000289478 2 0 0 49,415 0 0 3,584 rio.public.temp0000289440 4 0 0 98,788 0 0 7,168 Total 454 224 432,914 4,854,928 209,439 3,836 204,019 Pages removed per table
Key values
- public.temp0000289408 (518) Main table with removed pages on database rio
- 3836 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000289408 25 0 0 518 contagem.pg_catalog.pg_attribute 8 8 54715 510 rio.public.temp0000289444 16 0 0 499 rio.public.temp0000289472 17 0 0 291 rio.public.temp0000289370 13 0 0 270 brasilia.pg_catalog.pg_attribute 21 20 102777 169 rio.public.temp0000289223 6 0 0 124 rio.public.temp0000289430 2 0 0 116 rio.public.temp0000289400 2 0 0 112 rio.public.temp0000289462 2 0 0 98 rio.public.temp0000289380 2 0 0 98 contagem.public.temp0000226911 4 0 0 96 rio.public.temp0000289239 6 0 0 95 contagem.pg_catalog.pg_type 4 4 3914 66 rio.public.temp0000289384 1 0 0 57 rio.public.temp0000289386 1 0 0 57 rio.public.temp0000289396 1 0 0 57 rio.public.temp0000289378 2 0 0 57 rio.public.temp0000289404 1 0 0 56 contagem.pg_catalog.pg_depend 2 2 537 53 rio.public.temp0000289432 1 0 0 52 rio.public.temp0000289464 1 0 0 49 rio.public.temp0000289460 1 0 0 49 rio.public.temp0000289456 1 0 0 49 rio.public.temp0000289466 1 0 0 49 contagem.pg_catalog.pg_index 3 3 1884 34 rio.pg_catalog.pg_class 32 22 4456 33 brasilia.pg_toast.pg_toast_2619 2 2 183 25 contagem.public.temp0000226909 1 0 0 24 brasilia.pg_catalog.pg_type 13 11 5951 22 contagem.pg_toast.pg_toast_2619 1 1 109 19 rio.pg_catalog.pg_index 11 11 2696 12 brasilia.pg_catalog.pg_index 8 7 2700 10 rio.public.temp0000289448 5 0 0 10 contagem.public.nf_entrada 2 2 543 0 brasilia.pg_catalog.pg_class 14 13 1230 0 rio.public.temp0000289382 8 0 0 0 contagem.public.usuarios 22 0 1344 0 contagem.pg_catalog.pg_shdepend 3 3 3940 0 brasilia.pg_catalog.pg_depend 5 5 1828 0 brasilia.public.temp0000238756 3 0 0 0 contagem.pg_catalog.pg_statistic 2 2 5679 0 rio.pg_catalog.pg_type 29 22 5967 0 rio.public.tmp_drill_0302 11 5 32402 0 brasilia.pg_catalog.pg_statistic 3 3 6455 0 rio.public.temp0000289392 1 0 0 0 brasilia.public.temp0000238764 3 0 0 0 rio.public.temp0000289418 11 0 0 0 rio.pg_catalog.pg_depend 9 9 9102 0 rio.pg_catalog.pg_shdepend 5 5 4708 0 rio.pg_toast.pg_toast_2619 3 3 988 0 rio.pg_catalog.pg_attribute 52 41 162582 0 rio.public.usuarios 21 7 402 0 rio.pg_catalog.pg_statistic 7 7 13118 0 contagem.public.nf_entrada_modelos 1 1 2085 0 rio.public.temp0000289402 7 0 0 0 brasilia.public.temp0000238812 2 0 0 0 contagem.public.parametros 1 1 20 0 rio.public.temp0000289374 2 0 0 0 contagem.pg_catalog.pg_class 4 4 599 0 rio.public.temp0000289478 2 0 0 0 rio.public.temp0000289440 4 0 0 0 Total 454 224 432,914 3,836 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 24 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 4 38 08 54 98 09 31 82 10 65 95 11 51 100 12 23 49 13 23 65 14 36 98 15 54 133 16 60 130 17 45 51 18 0 0 19 0 0 20 0 0 21 2 3 22 0 0 23 0 0 - 0.54 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 2 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 1s12ms 1s12ms 1s12ms 1s12ms drop table if exists temp0000289472;-
DROP TABLE IF EXISTS temp0000289472;
Date: 2026-08-24 15:06:14 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
DROP TABLE IF EXISTS temp0000289472;
Date: 2026-08-24 15:06:14 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
2 1 1s 1s 1s 1s drop table if exists temp0000289408;-
DROP TABLE IF EXISTS temp0000289408;
Date: 2026-08-24 11:19:32 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
DROP TABLE IF EXISTS temp0000289408;
Date: 2026-08-24 11:19:32 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
Queries that waited the most
Rank Wait time Query 1 1s12ms DROP TABLE IF EXISTS temp0000289472;[ Date: 2026-08-24 15:06:14 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 1s DROP TABLE IF EXISTS temp0000289408;[ Date: 2026-08-24 11:19:32 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 5,087 Total read queries
- 1,553 Total write queries
Queries by database
Key values
- rio Main database
- 4,975 Requests
- 8h10m16s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 7,859 Requests
User Request type Count Duration etiquetas Total 126 35s628ms select 126 35s628ms intelifix Total 7,859 15h9m3s copy to 819 1h34m33s ddl 1,142 55m58s others 898 1h41m47s select 4,999 10h56m44s tcl 1 822ms lenon Total 119 3m56s select 119 3m56s Duration by user
Key values
- 15h9m3s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 126 35s628ms select 126 35s628ms intelifix Total 7,859 15h9m3s copy to 819 1h34m33s ddl 1,142 55m58s others 898 1h41m47s select 4,999 10h56m44s tcl 1 822ms lenon Total 119 3m56s select 119 3m56s Queries by host
Key values
- [local] Main host
- 8,104 Requests
- 15h13m35s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 6,003 Requests
- 5h15m49s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-24 15:27:18 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,367 100-500ms duration
Slowest individual queries
Rank Duration Query 1 16m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-24 07:21:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 15m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-24 09:20:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 13m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-24 11:18:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 12m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-24 10:17:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 11m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-24 17:16:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 11m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-24 12:16:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 10m53s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028884, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-24 09:16:13 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 10m48s analyze verbose;[ Date: 2026-08-24 05:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 10m31s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028875, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-24 08:25:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 10m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-24 14:15:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 9m53s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028889, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-24 10:57:11 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 9m6s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028891, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-24 11:28:55 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 8m49s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028886, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-24 10:21:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 8m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-24 15:13:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 8m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-24 08:13:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 7m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-24 16:12:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 7m47s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028894, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-24 11:54:05 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 7m32s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028902, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-24 14:36:53 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 7m24s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028897, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-24 12:14:53 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 7m18s analyze verbose;[ Date: 2026-08-24 05:18:07 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h42m19s 48 1s278ms 16m2s 3m22s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 24 07 3 17m18s 5m46s 08 3 8m30s 2m50s 09 3 16m23s 5m27s 10 3 13m23s 4m27s 11 3 14m20s 4m46s 12 3 12m13s 4m4s 13 3 7m9s 2m23s 14 3 10m35s 3m31s 15 3 8m33s 2m51s 16 3 8m18s 2m46s 17 3 12m20s 4m6s 18 3 7m32s 2m30s 19 3 6m6s 2m2s 20 3 7m26s 2m28s 21 3 6m21s 2m7s 22 3 5m43s 1m54s [ User: intelifix - Total duration: 2h42m19s - Times executed: 48 ]
[ Application: psql - Total duration: 2h42m19s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-24 07:21:04 Duration: 16m2s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-24 09:20:22 Duration: 15m20s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-24 11:18:45 Duration: 13m44s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
2 2h14m54s 300 154ms 10m53s 26s982ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 24 07 1 7s650ms 7s650ms 08 33 21m10s 38s492ms 09 29 12m3s 24s959ms 10 40 20m57s 31s425ms 11 39 19m19s 29s721ms 12 17 14m42s 51s916ms 13 19 44s273ms 2s330ms 14 21 9m33s 27s330ms 15 28 14m28s 31s10ms 16 45 9m8s 12s195ms 17 28 12m39s 27s107ms [ User: intelifix - Total duration: 2h14m54s - Times executed: 300 ]
[ Application: [unknown] - Total duration: 2h14m54s - Times executed: 300 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028884, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-24 09:16:13 Duration: 10m53s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028875, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-24 08:25:51 Duration: 10m31s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028889, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-24 10:57:11 Duration: 9m53s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
3 1h19m25s 48 286ms 5m30s 1m39s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 24 07 3 7m25s 2m28s 08 3 4m35s 1m31s 09 3 7m56s 2m38s 10 3 4m45s 1m35s 11 3 4m47s 1m35s 12 3 4m44s 1m34s 13 3 4m34s 1m31s 14 3 5m11s 1m43s 15 3 5m9s 1m43s 16 3 5m15s 1m45s 17 3 5m10s 1m43s 18 3 4m10s 1m23s 19 3 3m40s 1m13s 20 3 4m10s 1m23s 21 3 3m47s 1m15s 22 3 3m58s 1m19s [ User: intelifix - Total duration: 1h19m25s - Times executed: 48 ]
[ Application: psql - Total duration: 1h19m25s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-24 09:29:07 Duration: 5m30s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-24 07:29:27 Duration: 5m3s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-24 16:18:31 Duration: 4m36s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
4 37m10s 1,671 150ms 10s967ms 1s334ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 24 07 2 1s173ms 586ms 08 130 2m30s 1s157ms 09 296 5m11s 1s52ms 10 222 3m42s 1s3ms 11 162 2m43s 1s9ms 12 66 54s843ms 830ms 13 46 1m56s 2s521ms 14 199 6m17s 1s898ms 15 253 6m16s 1s488ms 16 206 6m2s 1s761ms 17 89 1m32s 1s38ms [ User: intelifix - Total duration: 37m10s - Times executed: 1671 ]
[ Application: [unknown] - Total duration: 37m10s - Times executed: 1671 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (54472, 406, '835091914000366,241664936971,241620782225,241620867384,241632248911,241679918186,241604747281,241727049700,241649689917,241694978602,241637734261,241609915777,241678344655,241649552934,230048476481,241728719201,241726966280,241609885067,241639105270,241711218390,241668285671,241598864362,241678304045,241609896583,241689117176,241676720715,241690076170,241729921631,241713730814,241607471420,241676645858,241637720018,241732175666,241727492931,230040174257,241714204552,241728553046,241714900513,241607088700,241668207481,241727052125', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-24 13:08:53 Duration: 10s967ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (54474, 413, 'ZTE3ANNT3H64525,D831399CABE6,D831399CABE7,ZTEGDD32CCAC$ZTE3ANNR4N60550,4896D95AE63C,4896D95AE63D,ZTEGD9800C4B$ZTE3ANNT3H68911,D831399D12B2,D831399D12B3,ZTEGDD32DDCE$ZTE3ANNT3F09174,D831399602CC,D831399602CD,ZTEGDD31B07D$ZTE3ANNRCP46761,6C11BA6D72C5,6C11BA6D72C6,ZTEGDC6FF73C$ZTE3ANNT3H64521,D831399CABCE,D831399CABCF,ZTEGDD32CCA8$ZTE3ANNR5W01258,48D6822EA146,48D6822EA147,ZTEGDB0004E9$ZTE3ANNT2V49449,D831399015CE,D831399015CF,ZTEGDD30B3A8$ZTE3ANNR9325875,D89A0D84BE7D,D89A0D84BE7E,ZTEGDB14D912$ZTE3ANNRC562250,6C11BA67DCD3,6C11BA67DCD4,ZTEGDC6F08E9$ZTE3ANNT3F09378,D83139960794,D83139960795,ZTEGDD31B149$ZTE3ANNRCB01435,D831391DF0A0,D831391DF0A1,ZTEGDD29BB30$ZTE3ANNRC557056,6C11BA676317,6C11BA676318,ZTEGDC6EF49F$ZTE3ANNT3J09802,D83139A0D10E,D83139A0D10F,ZTEGDD337D88$ZTE3ANNQ8M18802,843C99208097,843C99208098,ZTEGD7BA90DF$ZTE3ANNRC565051,6C11BA681E79,6C11BA681E7A,ZTEGDC6F13DA$ZTE3ANNRB737722,5872C991AD4D,5872C991AD4E,ZTEGDC61BE2D$ZTE3ANNRB737440,5872C991A6B1,5872C991A6B2,ZTEGDC61BD13$ZTE3ANNR7B33107,3891484BF499,3891484BF49A,ZTEGDB0812B3$ZTE3ANNR2Q01504,F4E84F80D740,F4E84F80D741,ZTEGD97A789A$ZTE3ANNR9325794,D89A0D84BC97,D89A0D84BC98,ZTEGDB14D8C1$ZTE3ANNR9W44361,D89A0DAC6BD9,D89A0DAC6BDA,ZTEGDB16BEF4$ZTE3ANNT4P35650,F00C514EEA2A,F00C514EEA2B,ZTEGDE3481D8$ZTE3ANNT3H17595,D83139985FFA,D83139985FFB,ZTEGDD32155A$ZTE3ANNQ9J09617,843C992CB29B,843C992CB29C,ZTEGD7BB2E3C$ZTE3ANNRCB04712,D831391E3D6E,D831391E3D6F,ZTEGDD29C7FD$ZTE3ANNRCP49327,6C11BA6DAEE9,6C11BA6DAEEA,ZTEGDC700142$ZTE3ANNQ8M18800,843C9920808B,843C9920808C,ZTEGD7BA90DD$ZTE3ANNQ4A03475,3CF9F0AA49B8,3CF9F0AA49B9,ZTEGD6414C52$ZTE3ANNQ7507526,C4EBFF8BA3A0,C4EBFF8BA3A1,ZTEGD70A6C06$ZTE3ANNR9W46279,D89A0DAC98CD,D89A0DAC98CE,ZTEGDB16C672$ZTE3ANNRCB24568,D83139200ECE,D83139200ECF,ZTEGDD2A158D$ZTE3ANNRC552224,6C11BA66F1D7,6C11BA66F1D8,ZTEGDC6EE1BF$ZTE3ANNR2Q37336,F4E84F841F10,F4E84F841F11,ZTEGD97B0492$ZTE3ANNT3F11299,D8313996349A,D8313996349B,ZTEGDD31B8CA$ZTE3ANNRC501591,6C11BA624F21,6C11BA624F22,ZTEGDC6E1BF6$ZTE3ANNR5W76300,48D682358012,48D682358013,ZTEGDB012A0B$ZTE3ANNRCB04778,D831391E3EFA,D831391E3EFB,ZTEGDD29C83F$ZTE3ANNT3J07475,D83139A09A84,D83139A09A85,ZTEGDD337471$ZTE3ANNRCP04060,6C11BA6989F7,6C11BA6989F8,ZTEGDC6F506F$ZTE3ANNQ4N02414,3CF9F0A8CA42,3CF9F0A8CA43,ZTEGD6410C69', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-24 13:57:05 Duration: 8s686ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (280073, 452, '14308685850103102433,D86C5A490FCE,C85D380593EA,C85D3805A7C4,D86C5A401C04,C85D3881D410,D86C5A4B8C34,D86C5A05500F,C85D3875BED4,D86C5A08CA04', '',0151,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-24 11:38:34 Duration: 8s508ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
5 21m17s 3 3m11s 10m48s 7m5s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 24 05 3 21m17s 7m5s [ User: intelifix - Total duration: 21m17s - Times executed: 3 ]
[ Application: psql - Total duration: 21m17s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-24 05:10:49 Duration: 10m48s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
analyze verbose;
Date: 2026-08-24 05:18:07 Duration: 7m18s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
analyze verbose;
Date: 2026-08-24 05:21:19 Duration: 3m11s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
6 17m4s 64 1s261ms 2m7s 16s14ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 24 06 1 2m7s 2m7s 07 5 30s990ms 6s198ms 08 1 2m4s 2m4s 09 3 24s92ms 8s30ms 10 10 4m53s 29s321ms 11 7 48s602ms 6s943ms 12 6 27s48ms 4s508ms 13 6 2m2s 20s367ms 14 6 1m2s 10s466ms 15 7 32s220ms 4s602ms 16 8 31s420ms 3s927ms 17 4 1m40s 25s28ms [ User: intelifix - Total duration: 17m4s - Times executed: 64 ]
[ Application: [unknown] - Total duration: 17m4s - Times executed: 64 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-24', 0366, '', '', 0, 6, '2026-08-01');
Date: 2026-08-24 06:45:22 Duration: 2m7s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-24', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-24 08:56:38 Duration: 2m4s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-24', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-24 10:04:44 Duration: 2m2s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
7 15m5s 1,015 150ms 8s556ms 891ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 24 07 19 15s665ms 824ms 08 70 1m 861ms 09 102 1m34s 930ms 10 134 2m29s 1s114ms 11 121 2m 994ms 12 34 28s547ms 839ms 13 106 1m17s 728ms 14 123 1m50s 899ms 15 169 2m26s 868ms 16 119 1m25s 721ms 17 18 15s481ms 860ms [ User: intelifix - Total duration: 15m5s - Times executed: 1015 ]
[ Application: [unknown] - Total duration: 15m5s - Times executed: 1015 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "229989", "modelo" : "155", "itens" : "D833B71EB914,94988F948C30,186A81D58E10,44D454ABDB03,94988F30840E,841EA3690C12,D0CF0EFDDFF2", "usuario" : "414", "caixa" : "2755449", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-24 15:03:14 Duration: 8s556ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "280804", "modelo" : "155", "itens" : "C03C048535CB,,C4EB42A02C24,D0CF0EFD863B,44D4546B66BB,C03C0486558F,4C195DCCCC05,582FF79BC4B4,6CFFCE68D0FE,B0FC88EB9327,C4EB429FF7CE", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-24 09:49:59 Duration: 7s914ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "280790", "modelo" : "320", "itens" : "241704764652,241714193238,241615215071,241706432436,241604358298,241702795470,241706515878,241694432028,241593801736,241674659604,241609834254,241671496377,241645521026,241622678391,241614509211,241704658907,241702085064,241675751417,241691401923,241714212028,241726186574,241666315658,241703438899,241610173737,241679072841,241645656773,241619591436,241706628391,241679499403,241694509409,241730317886,241703442537,241660875161,241631840712", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-24 11:02:35 Duration: 4s771ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
8 14m29s 130 152ms 23s119ms 6s686ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 24 00 2 1s30ms 515ms 05 1 195ms 195ms 07 10 1m25s 8s581ms 08 12 1m38s 8s196ms 09 12 1m42s 8s574ms 10 12 1m45s 8s776ms 11 12 1m49s 9s130ms 12 12 1m25s 7s150ms 13 7 26s405ms 3s772ms 14 12 1m5s 5s447ms 15 12 1m30s 7s504ms 16 9 55s231ms 6s136ms 17 5 6s550ms 1s310ms 20 1 700ms 700ms 21 5 17s135ms 3s427ms 22 6 18s829ms 3s138ms [ User: intelifix - Total duration: 14m29s - Times executed: 130 ]
[ Application: psql - Total duration: 14m29s - Times executed: 130 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-24 10:25:24 Duration: 23s119ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-24 07:45:24 Duration: 23s115ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-24 09:05:22 Duration: 21s258ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
9 13m44s 273 176ms 28s757ms 3s21ms call rs_giga_triagem (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 24 00 12 56s994ms 4s749ms 01 12 26s265ms 2s188ms 02 12 26s559ms 2s213ms 03 11 25s99ms 2s281ms 04 11 27s208ms 2s473ms 05 12 35s502ms 2s958ms 06 12 29s646ms 2s470ms 07 12 25s419ms 2s118ms 08 12 42s864ms 3s572ms 09 12 39s463ms 3s288ms 10 12 49s216ms 4s101ms 11 12 36s283ms 3s23ms 12 12 33s690ms 2s807ms 13 12 35s431ms 2s952ms 14 11 40s732ms 3s702ms 15 12 44s83ms 3s673ms 16 12 38s853ms 3s237ms 17 12 41s300ms 3s441ms 18 12 33s421ms 2s785ms 19 12 31s330ms 2s610ms 20 12 43s893ms 3s657ms 21 12 29s387ms 2s448ms 22 12 32s180ms 2s681ms [ User: intelifix - Total duration: 13m44s - Times executed: 273 ]
[ Application: psql - Total duration: 13m44s - Times executed: 273 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-24 00:05:31 Duration: 28s757ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-24 08:25:28 Duration: 16s794ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-24 10:15:30 Duration: 14s261ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
10 9m8s 38 10s726ms 50s412ms 14s441ms create table temp0000289408 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 24 10 12 2m48s 14s12ms 11 11 3m4s 16s776ms 12 15 3m16s 13s71ms [ User: intelifix - Total duration: 9m8s - Times executed: 38 ]
[ Application: [unknown] - Total duration: 9m8s - Times executed: 38 ]
-
CREATE TABLE temp0000289408 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 11:17:39 Duration: 50s412ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289408 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 12:23:52 Duration: 30s447ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289408 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 11:44:15 Duration: 18s945ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
11 6m51s 31 162ms 1m2s 13s269ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 24 08 4 1m16s 19s223ms 09 1 1m2s 1m2s 10 3 1m1s 20s513ms 11 4 1m4s 16s25ms 12 4 1m2s 15s548ms 14 5 39s937ms 7s987ms 15 3 19s400ms 6s466ms 16 7 24s569ms 3s509ms [ User: intelifix - Total duration: 6m51s - Times executed: 31 ]
[ Application: psql - Total duration: 6m51s - Times executed: 31 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028884);
Date: 2026-08-24 09:05:45 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028875);
Date: 2026-08-24 08:15:42 Duration: 55s920ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028895);
Date: 2026-08-24 12:06:05 Duration: 38s534ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
12 6m18s 24 11s436ms 37s812ms 15s787ms create table temp0000289472 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 24 14 6 1m46s 17s675ms 15 12 2m54s 14s510ms 16 6 1m38s 16s452ms [ User: intelifix - Total duration: 6m18s - Times executed: 24 ]
[ Application: [unknown] - Total duration: 6m18s - Times executed: 24 ]
-
CREATE TABLE temp0000289472 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 14:25:32 Duration: 37s812ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289472 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 16:06:12 Duration: 28s677ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289472 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 15:23:15 Duration: 17s882ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
13 6m3s 19 11s103ms 1m5s 19s106ms create table temp0000289382 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 24 08 12 3m28s 17s415ms 09 7 2m34s 22s4ms [ User: intelifix - Total duration: 6m3s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 6m3s - Times executed: 19 ]
-
CREATE TABLE temp0000289382 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 09:45:01 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289382 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 08:09:25 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289382 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 09:04:58 Duration: 15s937ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
14 4m56s 47 244ms 2m31s 6s300ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 24 08 9 32s595ms 3s621ms 09 2 2s365ms 1s182ms 10 5 10s362ms 2s72ms 11 5 27s253ms 5s450ms 12 6 2m36s 26s161ms 14 8 5s224ms 653ms 15 4 4s660ms 1s165ms 16 3 16s634ms 5s544ms 17 5 40s41ms 8s8ms [ User: intelifix - Total duration: 4m56s - Times executed: 47 ]
[ Application: psql - Total duration: 4m56s - Times executed: 47 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028895);
Date: 2026-08-24 12:05:27 Duration: 2m31s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028915);
Date: 2026-08-24 16:24:48 Duration: 14s116ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028917);
Date: 2026-08-24 17:13:27 Duration: 11s927ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
15 3m56s 14 11s586ms 34s888ms 16s858ms create table temp0000289418 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 24 10 3 1m 20s52ms 11 1 25s834ms 25s834ms 16 2 34s269ms 17s134ms 17 8 1m55s 14s470ms [ User: intelifix - Total duration: 3m56s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 3m56s - Times executed: 14 ]
-
CREATE TABLE temp0000289418 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 10:09:54 Duration: 34s888ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289418 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 11:30:00 Duration: 25s834ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289418 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 17:13:36 Duration: 19s720ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
16 3m30s 57 3s49ms 5s127ms 3s691ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 24 08 3 11s579ms 3s859ms 09 3 10s504ms 3s501ms 10 5 18s513ms 3s702ms 11 3 11s204ms 3s734ms 12 3 11s521ms 3s840ms 13 4 13s887ms 3s471ms 14 4 15s80ms 3s770ms 15 6 22s14ms 3s669ms 16 4 15s12ms 3s753ms 17 4 14s40ms 3s510ms 18 3 10s229ms 3s409ms 19 3 10s10ms 3s336ms 20 4 14s98ms 3s524ms 21 4 15s149ms 3s787ms 22 4 17s569ms 4s392ms [ User: intelifix - Total duration: 3m30s - Times executed: 57 ]
[ Application: psql - Total duration: 3m30s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-24 22:00:11 Duration: 5s127ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-24 15:20:05 Duration: 4s871ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-24 21:00:08 Duration: 4s608ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
17 3m7s 4 4s923ms 1m30s 46s923ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 24 20 2 1m32s 46s45ms 23 2 1m35s 47s802ms [ User: intelifix - Total duration: 3m7s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m7s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-24 23:16:39 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-24 20:08:38 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-24 20:10:34 Duration: 5s650ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-24.log
18 2m46s 13 10s890ms 15s250ms 12s829ms create table temp0000289402 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 24 08 13 2m46s 12s829ms [ User: intelifix - Total duration: 2m46s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m46s - Times executed: 13 ]
-
CREATE TABLE temp0000289402 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 08:55:52 Duration: 15s250ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289402 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 08:39:10 Duration: 14s743ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289402 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 08:37:55 Duration: 13s964ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
19 2m39s 11 11s359ms 16s135ms 14s530ms create table temp0000289444 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 24 14 11 2m39s 14s530ms [ User: intelifix - Total duration: 2m39s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 2m39s - Times executed: 11 ]
-
CREATE TABLE temp0000289444 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 14:39:56 Duration: 16s135ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289444 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 14:39:17 Duration: 16s43ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289444 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 14:46:00 Duration: 15s899ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
20 2m9s 113 153ms 8s769ms 1s142ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 24 08 6 6s31ms 1s5ms 09 10 9s82ms 908ms 10 13 18s577ms 1s429ms 11 16 33s191ms 2s74ms 12 8 7s4ms 875ms 13 13 10s691ms 822ms 15 11 5s395ms 490ms 16 30 30s625ms 1s20ms 17 6 8s516ms 1s419ms [ User: intelifix - Total duration: 2m9s - Times executed: 113 ]
[ Application: [unknown] - Total duration: 2m9s - Times executed: 113 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0279926) LIMIT 1;
Date: 2026-08-24 11:39:28 Duration: 8s769ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0279926) LIMIT 1;
Date: 2026-08-24 11:06:55 Duration: 6s608ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0280488) LIMIT 1;
Date: 2026-08-24 10:54:30 Duration: 6s279ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,671 37m10s 150ms 10s967ms 1s334ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 24 07 2 1s173ms 586ms 08 130 2m30s 1s157ms 09 296 5m11s 1s52ms 10 222 3m42s 1s3ms 11 162 2m43s 1s9ms 12 66 54s843ms 830ms 13 46 1m56s 2s521ms 14 199 6m17s 1s898ms 15 253 6m16s 1s488ms 16 206 6m2s 1s761ms 17 89 1m32s 1s38ms [ User: intelifix - Total duration: 37m10s - Times executed: 1671 ]
[ Application: [unknown] - Total duration: 37m10s - Times executed: 1671 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (54472, 406, '835091914000366,241664936971,241620782225,241620867384,241632248911,241679918186,241604747281,241727049700,241649689917,241694978602,241637734261,241609915777,241678344655,241649552934,230048476481,241728719201,241726966280,241609885067,241639105270,241711218390,241668285671,241598864362,241678304045,241609896583,241689117176,241676720715,241690076170,241729921631,241713730814,241607471420,241676645858,241637720018,241732175666,241727492931,230040174257,241714204552,241728553046,241714900513,241607088700,241668207481,241727052125', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-24 13:08:53 Duration: 10s967ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (54474, 413, 'ZTE3ANNT3H64525,D831399CABE6,D831399CABE7,ZTEGDD32CCAC$ZTE3ANNR4N60550,4896D95AE63C,4896D95AE63D,ZTEGD9800C4B$ZTE3ANNT3H68911,D831399D12B2,D831399D12B3,ZTEGDD32DDCE$ZTE3ANNT3F09174,D831399602CC,D831399602CD,ZTEGDD31B07D$ZTE3ANNRCP46761,6C11BA6D72C5,6C11BA6D72C6,ZTEGDC6FF73C$ZTE3ANNT3H64521,D831399CABCE,D831399CABCF,ZTEGDD32CCA8$ZTE3ANNR5W01258,48D6822EA146,48D6822EA147,ZTEGDB0004E9$ZTE3ANNT2V49449,D831399015CE,D831399015CF,ZTEGDD30B3A8$ZTE3ANNR9325875,D89A0D84BE7D,D89A0D84BE7E,ZTEGDB14D912$ZTE3ANNRC562250,6C11BA67DCD3,6C11BA67DCD4,ZTEGDC6F08E9$ZTE3ANNT3F09378,D83139960794,D83139960795,ZTEGDD31B149$ZTE3ANNRCB01435,D831391DF0A0,D831391DF0A1,ZTEGDD29BB30$ZTE3ANNRC557056,6C11BA676317,6C11BA676318,ZTEGDC6EF49F$ZTE3ANNT3J09802,D83139A0D10E,D83139A0D10F,ZTEGDD337D88$ZTE3ANNQ8M18802,843C99208097,843C99208098,ZTEGD7BA90DF$ZTE3ANNRC565051,6C11BA681E79,6C11BA681E7A,ZTEGDC6F13DA$ZTE3ANNRB737722,5872C991AD4D,5872C991AD4E,ZTEGDC61BE2D$ZTE3ANNRB737440,5872C991A6B1,5872C991A6B2,ZTEGDC61BD13$ZTE3ANNR7B33107,3891484BF499,3891484BF49A,ZTEGDB0812B3$ZTE3ANNR2Q01504,F4E84F80D740,F4E84F80D741,ZTEGD97A789A$ZTE3ANNR9325794,D89A0D84BC97,D89A0D84BC98,ZTEGDB14D8C1$ZTE3ANNR9W44361,D89A0DAC6BD9,D89A0DAC6BDA,ZTEGDB16BEF4$ZTE3ANNT4P35650,F00C514EEA2A,F00C514EEA2B,ZTEGDE3481D8$ZTE3ANNT3H17595,D83139985FFA,D83139985FFB,ZTEGDD32155A$ZTE3ANNQ9J09617,843C992CB29B,843C992CB29C,ZTEGD7BB2E3C$ZTE3ANNRCB04712,D831391E3D6E,D831391E3D6F,ZTEGDD29C7FD$ZTE3ANNRCP49327,6C11BA6DAEE9,6C11BA6DAEEA,ZTEGDC700142$ZTE3ANNQ8M18800,843C9920808B,843C9920808C,ZTEGD7BA90DD$ZTE3ANNQ4A03475,3CF9F0AA49B8,3CF9F0AA49B9,ZTEGD6414C52$ZTE3ANNQ7507526,C4EBFF8BA3A0,C4EBFF8BA3A1,ZTEGD70A6C06$ZTE3ANNR9W46279,D89A0DAC98CD,D89A0DAC98CE,ZTEGDB16C672$ZTE3ANNRCB24568,D83139200ECE,D83139200ECF,ZTEGDD2A158D$ZTE3ANNRC552224,6C11BA66F1D7,6C11BA66F1D8,ZTEGDC6EE1BF$ZTE3ANNR2Q37336,F4E84F841F10,F4E84F841F11,ZTEGD97B0492$ZTE3ANNT3F11299,D8313996349A,D8313996349B,ZTEGDD31B8CA$ZTE3ANNRC501591,6C11BA624F21,6C11BA624F22,ZTEGDC6E1BF6$ZTE3ANNR5W76300,48D682358012,48D682358013,ZTEGDB012A0B$ZTE3ANNRCB04778,D831391E3EFA,D831391E3EFB,ZTEGDD29C83F$ZTE3ANNT3J07475,D83139A09A84,D83139A09A85,ZTEGDD337471$ZTE3ANNRCP04060,6C11BA6989F7,6C11BA6989F8,ZTEGDC6F506F$ZTE3ANNQ4N02414,3CF9F0A8CA42,3CF9F0A8CA43,ZTEGD6410C69', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-24 13:57:05 Duration: 8s686ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (280073, 452, '14308685850103102433,D86C5A490FCE,C85D380593EA,C85D3805A7C4,D86C5A401C04,C85D3881D410,D86C5A4B8C34,D86C5A05500F,C85D3875BED4,D86C5A08CA04', '',0151,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-24 11:38:34 Duration: 8s508ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
2 1,015 15m5s 150ms 8s556ms 891ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 24 07 19 15s665ms 824ms 08 70 1m 861ms 09 102 1m34s 930ms 10 134 2m29s 1s114ms 11 121 2m 994ms 12 34 28s547ms 839ms 13 106 1m17s 728ms 14 123 1m50s 899ms 15 169 2m26s 868ms 16 119 1m25s 721ms 17 18 15s481ms 860ms [ User: intelifix - Total duration: 15m5s - Times executed: 1015 ]
[ Application: [unknown] - Total duration: 15m5s - Times executed: 1015 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "229989", "modelo" : "155", "itens" : "D833B71EB914,94988F948C30,186A81D58E10,44D454ABDB03,94988F30840E,841EA3690C12,D0CF0EFDDFF2", "usuario" : "414", "caixa" : "2755449", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-24 15:03:14 Duration: 8s556ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "280804", "modelo" : "155", "itens" : "C03C048535CB,,C4EB42A02C24,D0CF0EFD863B,44D4546B66BB,C03C0486558F,4C195DCCCC05,582FF79BC4B4,6CFFCE68D0FE,B0FC88EB9327,C4EB429FF7CE", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-24 09:49:59 Duration: 7s914ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "280790", "modelo" : "320", "itens" : "241704764652,241714193238,241615215071,241706432436,241604358298,241702795470,241706515878,241694432028,241593801736,241674659604,241609834254,241671496377,241645521026,241622678391,241614509211,241704658907,241702085064,241675751417,241691401923,241714212028,241726186574,241666315658,241703438899,241610173737,241679072841,241645656773,241619591436,241706628391,241679499403,241694509409,241730317886,241703442537,241660875161,241631840712", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-24 11:02:35 Duration: 4s771ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
3 300 2h14m54s 154ms 10m53s 26s982ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 24 07 1 7s650ms 7s650ms 08 33 21m10s 38s492ms 09 29 12m3s 24s959ms 10 40 20m57s 31s425ms 11 39 19m19s 29s721ms 12 17 14m42s 51s916ms 13 19 44s273ms 2s330ms 14 21 9m33s 27s330ms 15 28 14m28s 31s10ms 16 45 9m8s 12s195ms 17 28 12m39s 27s107ms [ User: intelifix - Total duration: 2h14m54s - Times executed: 300 ]
[ Application: [unknown] - Total duration: 2h14m54s - Times executed: 300 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028884, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-24 09:16:13 Duration: 10m53s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028875, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-24 08:25:51 Duration: 10m31s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028889, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-24 10:57:11 Duration: 9m53s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
4 273 13m44s 176ms 28s757ms 3s21ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 24 00 12 56s994ms 4s749ms 01 12 26s265ms 2s188ms 02 12 26s559ms 2s213ms 03 11 25s99ms 2s281ms 04 11 27s208ms 2s473ms 05 12 35s502ms 2s958ms 06 12 29s646ms 2s470ms 07 12 25s419ms 2s118ms 08 12 42s864ms 3s572ms 09 12 39s463ms 3s288ms 10 12 49s216ms 4s101ms 11 12 36s283ms 3s23ms 12 12 33s690ms 2s807ms 13 12 35s431ms 2s952ms 14 11 40s732ms 3s702ms 15 12 44s83ms 3s673ms 16 12 38s853ms 3s237ms 17 12 41s300ms 3s441ms 18 12 33s421ms 2s785ms 19 12 31s330ms 2s610ms 20 12 43s893ms 3s657ms 21 12 29s387ms 2s448ms 22 12 32s180ms 2s681ms [ User: intelifix - Total duration: 13m44s - Times executed: 273 ]
[ Application: psql - Total duration: 13m44s - Times executed: 273 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-24 00:05:31 Duration: 28s757ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-24 08:25:28 Duration: 16s794ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-24 10:15:30 Duration: 14s261ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
5 216 1m11s 150ms 2s336ms 330ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 24 07 54 23s138ms 428ms 08 27 7s80ms 262ms 09 14 4s376ms 312ms 10 28 10s15ms 357ms 11 19 5s615ms 295ms 12 13 4s777ms 367ms 13 2 355ms 177ms 14 22 5s674ms 257ms 15 29 8s492ms 292ms 16 8 1s930ms 241ms [ User: intelifix - Total duration: 1m11s - Times executed: 216 ]
[ Application: [unknown] - Total duration: 1m11s - Times executed: 216 ]
-
SELECT * FROM RS_TRIAGEM (410, 5, '113', 3, '241600677793,241644757179,241611429909,241644169412,241614311414,241613430004,241632353545,241627187193,241644813751', NULL, NULL, 0454, 00);
Date: 2026-08-24 07:39:33 Duration: 2s336ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '229977166379,230026014749,230051905772,230028300607,230054180720,229989195555,229963251823,230006617087,230050377474', NULL, NULL, 0295, 00);
Date: 2026-08-24 07:03:31 Duration: 1s365ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_TRIAGEM (404, 5, '113', 3, '229848450507,229819913333,229789850411,229805020006,229770159207,229820392830,229849558202,229795969818,229768851919,229878637683,229821061313', NULL, NULL, 0145, 00);
Date: 2026-08-24 10:34:41 Duration: 1s137ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
6 156 38s483ms 150ms 1s646ms 246ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 24 07 15 3s632ms 242ms 08 16 3s618ms 226ms 09 17 3s979ms 234ms 10 32 6s918ms 216ms 11 18 5s150ms 286ms 12 14 2s734ms 195ms 13 1 543ms 543ms 14 6 1s167ms 194ms 15 5 906ms 181ms 16 16 4s155ms 259ms 17 5 1s115ms 223ms 21 3 802ms 267ms 22 4 671ms 167ms 23 4 3s87ms 771ms [ User: intelifix - Total duration: 38s483ms - Times executed: 156 ]
[ Application: [unknown] - Total duration: 38s483ms - Times executed: 156 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('230034393951');
Date: 2026-08-24 23:15:30 Duration: 1s646ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229784795158');
Date: 2026-08-24 11:44:30 Duration: 905ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('3FE49937ACAA');
Date: 2026-08-24 10:42:25 Duration: 611ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
7 143 43s246ms 150ms 2s975ms 302ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 24 06 3 773ms 257ms 08 3 1s958ms 652ms 09 8 2s716ms 339ms 10 4 1s211ms 302ms 11 5 3s14ms 602ms 12 11 9s557ms 868ms 13 1 238ms 238ms 14 11 3s203ms 291ms 15 17 4s649ms 273ms 16 46 8s609ms 187ms 17 34 7s312ms 215ms [ User: intelifix - Total duration: 43s246ms - Times executed: 143 ]
[ Application: [unknown] - Total duration: 43s246ms - Times executed: 143 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "362", "data-de" : "2026-08-24", "data-ate" : "2026-08-24", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 417 }');
Date: 2026-08-24 12:41:51 Duration: 2s975ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "365", "data-de" : "2026-08-24", "data-ate" : "2026-08-24", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 417 }');
Date: 2026-08-24 12:42:43 Duration: 1s145ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-08-24", "data-ate" : "2026-08-24", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 507 }');
Date: 2026-08-24 08:25:52 Duration: 1s87ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
8 135 27s557ms 151ms 374ms 204ms select * from rs_equipamento_manutencao (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 24 08 1 356ms 356ms 10 4 903ms 225ms 11 19 3s700ms 194ms 13 77 15s453ms 200ms 15 34 7s144ms 210ms [ User: intelifix - Total duration: 27s557ms - Times executed: 135 ]
[ Application: [unknown] - Total duration: 27s557ms - Times executed: 135 ]
-
SELECT * FROM RS_EQUIPAMENTO_MANUTENCAO (08297836, 05, 461, 6, 509, 'ZTE3A8TR1M18071', '','ZTE3A8TR1M18071','DC5193DAE422','', '','', '','', '','', '');
Date: 2026-08-24 15:24:32 Duration: 374ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_EQUIPAMENTO_MANUTENCAO (04103261, 011, 155, 7, 428, '922021156455', '','922021156455','D833B7303D1C','', '','', '','', '','', '');
Date: 2026-08-24 08:44:17 Duration: 356ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_EQUIPAMENTO_MANUTENCAO (08402712, 05, 461, 6, 80, 'ZTE3A8TR4H07546', '','ZTE3A8TR4H07546','38165A4799D8','', '','', '','', '','', '');
Date: 2026-08-24 13:31:34 Duration: 355ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
9 130 14m29s 152ms 23s119ms 6s686ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 24 00 2 1s30ms 515ms 05 1 195ms 195ms 07 10 1m25s 8s581ms 08 12 1m38s 8s196ms 09 12 1m42s 8s574ms 10 12 1m45s 8s776ms 11 12 1m49s 9s130ms 12 12 1m25s 7s150ms 13 7 26s405ms 3s772ms 14 12 1m5s 5s447ms 15 12 1m30s 7s504ms 16 9 55s231ms 6s136ms 17 5 6s550ms 1s310ms 20 1 700ms 700ms 21 5 17s135ms 3s427ms 22 6 18s829ms 3s138ms [ User: intelifix - Total duration: 14m29s - Times executed: 130 ]
[ Application: psql - Total duration: 14m29s - Times executed: 130 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-24 10:25:24 Duration: 23s119ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-24 07:45:24 Duration: 23s115ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-24 09:05:22 Duration: 21s258ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
10 124 19s813ms 150ms 187ms 159ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 24 07 4 645ms 161ms 08 9 1s486ms 165ms 09 3 494ms 164ms 10 18 2s887ms 160ms 11 12 1s939ms 161ms 12 2 314ms 157ms 13 14 2s235ms 159ms 14 17 2s691ms 158ms 15 23 3s670ms 159ms 16 16 2s522ms 157ms 17 6 927ms 154ms [ User: intelifix - Total duration: 19s813ms - Times executed: 124 ]
[ Application: [unknown] - Total duration: 19s813ms - Times executed: 124 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 046;
Date: 2026-08-24 10:37:06 Duration: 187ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-08-24 15:26:00 Duration: 186ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 046;
Date: 2026-08-24 08:22:02 Duration: 182ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
11 115 39s524ms 151ms 9s470ms 343ms create table temp0000238738 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 24 07 10 11s523ms 1s152ms 08 3 835ms 278ms 09 6 1s223ms 203ms 10 7 1s885ms 269ms 11 11 2s284ms 207ms 12 20 4s5ms 200ms 13 5 1s394ms 278ms 14 5 2s445ms 489ms 15 16 4s827ms 301ms 16 28 7s115ms 254ms 17 4 1s985ms 496ms [ User: intelifix - Total duration: 39s524ms - Times executed: 115 ]
[ Application: [unknown] - Total duration: 39s524ms - Times executed: 115 ]
-
CREATE TABLE temp0000238738 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "19-08-2026", "data-ate" : "24-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-24 07:05:33 Duration: 9s470ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000238738 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "24-08-2026", "data-ate" : "24-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-24 14:25:02 Duration: 1s464ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000238738 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "24-08-2026", "data-ate" : "24-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-24 15:13:38 Duration: 1s324ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
12 113 2m9s 153ms 8s769ms 1s142ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 24 08 6 6s31ms 1s5ms 09 10 9s82ms 908ms 10 13 18s577ms 1s429ms 11 16 33s191ms 2s74ms 12 8 7s4ms 875ms 13 13 10s691ms 822ms 15 11 5s395ms 490ms 16 30 30s625ms 1s20ms 17 6 8s516ms 1s419ms [ User: intelifix - Total duration: 2m9s - Times executed: 113 ]
[ Application: [unknown] - Total duration: 2m9s - Times executed: 113 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0279926) LIMIT 1;
Date: 2026-08-24 11:39:28 Duration: 8s769ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0279926) LIMIT 1;
Date: 2026-08-24 11:06:55 Duration: 6s608ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0280488) LIMIT 1;
Date: 2026-08-24 10:54:30 Duration: 6s279ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
13 105 49s326ms 266ms 780ms 469ms 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 #13
Day Hour Count Duration Avg duration Aug 24 06 1 418ms 418ms 07 6 2s591ms 431ms 08 14 7s193ms 513ms 09 10 4s104ms 410ms 10 9 3s825ms 425ms 11 11 5s513ms 501ms 12 7 2s876ms 410ms 13 8 3s781ms 472ms 14 9 4s916ms 546ms 15 11 5s174ms 470ms 16 9 4s309ms 478ms 17 6 2s929ms 488ms 21 2 894ms 447ms 22 1 426ms 426ms 23 1 371ms 371ms [ User: lenon - Total duration: 49s326ms - Times executed: 105 ]
[ Application: [unknown] - Total duration: 49s326ms - Times executed: 105 ]
-
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-24 11:00:14 Duration: 780ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-24 14:36:34 Duration: 772ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-24 17:07:40 Duration: 759ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-24.log
14 102 45s98ms 209ms 792ms 442ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 24 07 2 787ms 393ms 08 15 5s885ms 392ms 09 8 3s424ms 428ms 10 11 4s947ms 449ms 11 13 5s472ms 420ms 12 4 1s521ms 380ms 13 4 1s799ms 449ms 14 14 5s703ms 407ms 15 6 2s501ms 416ms 16 12 5s953ms 496ms 17 13 7s101ms 546ms [ User: intelifix - Total duration: 45s98ms - Times executed: 102 ]
[ Application: [unknown] - Total duration: 45s98ms - Times executed: 102 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-24 17:28:25 Duration: 792ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-24 11:29:03 Duration: 720ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-08-24 17:24:07 Duration: 675ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
15 98 59s920ms 363ms 1s57ms 611ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 24 07 5 2s752ms 550ms 08 13 8s539ms 656ms 09 10 5s572ms 557ms 10 9 4s813ms 534ms 11 11 7s398ms 672ms 12 6 3s425ms 570ms 13 8 4s890ms 611ms 14 9 6s116ms 679ms 15 11 6s668ms 606ms 16 8 4s795ms 599ms 17 6 3s688ms 614ms 22 1 577ms 577ms 23 1 680ms 680ms [ User: intelifix - Total duration: 59s920ms - Times executed: 98 ]
[ Application: [unknown] - Total duration: 59s920ms - Times executed: 98 ]
-
select * from rs_menu_grants (399, 18, 1);
Date: 2026-08-24 11:00:14 Duration: 1s57ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
select * from rs_menu_grants (399, 18, 1);
Date: 2026-08-24 16:25:34 Duration: 942ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
select * from rs_menu_grants (182, 81, 1);
Date: 2026-08-24 17:07:40 Duration: 919ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
16 90 17s414ms 150ms 482ms 193ms create table temp0000289271 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 24 08 4 821ms 205ms 09 13 2s258ms 173ms 10 29 5s179ms 178ms 11 20 3s688ms 184ms 12 12 2s234ms 186ms 14 4 781ms 195ms 15 4 1s70ms 267ms 16 2 571ms 285ms 17 2 808ms 404ms [ User: intelifix - Total duration: 17s414ms - Times executed: 90 ]
[ Application: [unknown] - Total duration: 17s414ms - Times executed: 90 ]
-
CREATE TABLE temp0000289271 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-08-2026", "ate" :"24-08-2026", "nota-fiscal":"67362", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-24 17:22:52 Duration: 482ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289271 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-08-2026", "ate" :"24-08-2026", "nota-fiscal":"67362", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-24 16:18:56 Duration: 358ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289271 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-08-2026", "ate" :"24-08-2026", "nota-fiscal":"67362", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-24 17:05:27 Duration: 326ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
17 84 21s304ms 152ms 2s665ms 253ms select * from rs_etiqueta (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 24 07 12 3s40ms 253ms 08 15 3s426ms 228ms 09 3 642ms 214ms 10 14 2s977ms 212ms 11 14 3s49ms 217ms 12 12 2s588ms 215ms 13 2 2s910ms 1s455ms 14 9 2s94ms 232ms 15 2 404ms 202ms 16 1 171ms 171ms [ User: etiquetas - Total duration: 21s304ms - Times executed: 84 ]
[ Application: [unknown] - Total duration: 21s304ms - Times executed: 84 ]
-
SELECT * FROM RS_ETIQUETA ('C03C047F32E8');
Date: 2026-08-24 13:44:30 Duration: 2s665ms Database: brasilia User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_ETIQUETA (241683122731);
Date: 2026-08-24 07:07:51 Duration: 682ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_ETIQUETA ('ZTE3A8TR5U06461');
Date: 2026-08-24 08:57:59 Duration: 468ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-24.log
18 83 33s805ms 150ms 2s426ms 407ms select * from rs_lote_saida_manutencao (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 24 07 2 979ms 489ms 08 1 329ms 329ms 09 4 1s686ms 421ms 10 15 8s687ms 579ms 11 21 11s628ms 553ms 13 7 2s353ms 336ms 14 10 2s250ms 225ms 15 10 2s900ms 290ms 16 10 2s523ms 252ms 17 3 466ms 155ms [ User: intelifix - Total duration: 33s805ms - Times executed: 83 ]
[ Application: [unknown] - Total duration: 33s805ms - Times executed: 83 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "133511", "oficina" : "7", "cliente" : "11", "usuario" : "427", "nf" : "", "data-saida" : "2026-08-24", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "DEFEITO ELÉTRICO", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-24 10:16:03 Duration: 2s426ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "133989", "oficina" : "7", "cliente" : "11", "usuario" : "427", "nf" : "", "data-saida" : "", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "Cosmético Pintura", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-24 11:13:42 Duration: 1s887ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "279926", "oficina" : "6", "cliente" : "5", "usuario" : "417", "nf" : "", "data-saida" : "", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-24 11:14:30 Duration: 1s499ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
19 65 37s465ms 152ms 2s199ms 576ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 24 08 14 11s833ms 845ms 09 18 14s588ms 810ms 10 1 380ms 380ms 11 5 1s863ms 372ms 13 4 951ms 237ms 14 8 2s201ms 275ms 15 8 3s845ms 480ms 16 2 402ms 201ms 17 5 1s398ms 279ms [ User: intelifix - Total duration: 37s465ms - Times executed: 65 ]
[ Application: [unknown] - Total duration: 37s465ms - Times executed: 65 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'F00C51535B00,4896D95460BC,D89A0DACCAF5,14CA56CFDC73,D89A0DA47A51,D831399E2136,3891484BF997,C4EBFF8AD098,4896D955E344,843C99341099,14CA56D05D25,6C11BA66B025,F4E84F89642C,3CF9F0A4C3F2,D831399E280E,48D68237AA46,6C11BA6C1371,C4EBFF8CC2E6,D89A0D859239,C4EBFF8AB2E6,843C992F8C43,C4EBFF8AB03A,5872C98F4863,48D68231B238,D831399E21B4,C4EBFF89F922,3CF9F0ADB6F6,C4EBFF896922,843C992C65C1,689E29BD8D69,6C11BA64AB41,D83139245BF8,D89A0DA8BA31,C4EBFF895DCA,48D682333718,48D6822F11FC,D8313999824C,689E29BC2BBD,F4E84F83F7E0', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-08-24 08:14:53 Duration: 2s199ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '843C9936A487,D8313923FBF2,14CA56D00C5B,6C11BA6D164F,5872C98AF14F,3CF9F0A7EA5C,F00C514D4F0C,4896D9595946,14CA56D6C3F1,14CA56D723BB,48D682380704,14CA56CFE46B,843C991FE911,F4E84F860B82,D831399E7CE6,6C11BA658A49,D89A0D85929F,F4E84F81CAB2,3CF9F0A8E338,4896D95692AC,5872C98D2855', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-08-24 08:42:23 Duration: 1s880ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '5872C98F88A1,14CA56D511DB,3CF9F0A95FAC,843C99338477,4896D956052E,843C99362F81,843C99225FAD,3CF9F06FA851,843C992F1C77,689E29FD2963,4896D957D3D0,C4EBFF89BD34,3CF9F06FA9D7,4896D953D90E,843C993467ED,6C11BA6538F5,4896D9532D12,D89A0DAB7C8D', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-08-24 09:03:54 Duration: 1s684ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
20 64 17m4s 1s261ms 2m7s 16s14ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 24 06 1 2m7s 2m7s 07 5 30s990ms 6s198ms 08 1 2m4s 2m4s 09 3 24s92ms 8s30ms 10 10 4m53s 29s321ms 11 7 48s602ms 6s943ms 12 6 27s48ms 4s508ms 13 6 2m2s 20s367ms 14 6 1m2s 10s466ms 15 7 32s220ms 4s602ms 16 8 31s420ms 3s927ms 17 4 1m40s 25s28ms [ User: intelifix - Total duration: 17m4s - Times executed: 64 ]
[ Application: [unknown] - Total duration: 17m4s - Times executed: 64 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-24', 0366, '', '', 0, 6, '2026-08-01');
Date: 2026-08-24 06:45:22 Duration: 2m7s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-24', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-24 08:56:38 Duration: 2m4s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-24', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-24 10:04:44 Duration: 2m2s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m11s 10m48s 7m5s 3 21m17s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 24 05 3 21m17s 7m5s [ User: intelifix - Total duration: 21m17s - Times executed: 3 ]
[ Application: psql - Total duration: 21m17s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-24 05:10:49 Duration: 10m48s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
analyze verbose;
Date: 2026-08-24 05:18:07 Duration: 7m18s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
analyze verbose;
Date: 2026-08-24 05:21:19 Duration: 3m11s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
2 1s278ms 16m2s 3m22s 48 2h42m19s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 24 07 3 17m18s 5m46s 08 3 8m30s 2m50s 09 3 16m23s 5m27s 10 3 13m23s 4m27s 11 3 14m20s 4m46s 12 3 12m13s 4m4s 13 3 7m9s 2m23s 14 3 10m35s 3m31s 15 3 8m33s 2m51s 16 3 8m18s 2m46s 17 3 12m20s 4m6s 18 3 7m32s 2m30s 19 3 6m6s 2m2s 20 3 7m26s 2m28s 21 3 6m21s 2m7s 22 3 5m43s 1m54s [ User: intelifix - Total duration: 2h42m19s - Times executed: 48 ]
[ Application: psql - Total duration: 2h42m19s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-24 07:21:04 Duration: 16m2s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-24 09:20:22 Duration: 15m20s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-24 11:18:45 Duration: 13m44s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
3 286ms 5m30s 1m39s 48 1h19m25s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 24 07 3 7m25s 2m28s 08 3 4m35s 1m31s 09 3 7m56s 2m38s 10 3 4m45s 1m35s 11 3 4m47s 1m35s 12 3 4m44s 1m34s 13 3 4m34s 1m31s 14 3 5m11s 1m43s 15 3 5m9s 1m43s 16 3 5m15s 1m45s 17 3 5m10s 1m43s 18 3 4m10s 1m23s 19 3 3m40s 1m13s 20 3 4m10s 1m23s 21 3 3m47s 1m15s 22 3 3m58s 1m19s [ User: intelifix - Total duration: 1h19m25s - Times executed: 48 ]
[ Application: psql - Total duration: 1h19m25s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-24 09:29:07 Duration: 5m30s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-24 07:29:27 Duration: 5m3s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-24 16:18:31 Duration: 4m36s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
4 4s923ms 1m30s 46s923ms 4 3m7s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 24 20 2 1m32s 46s45ms 23 2 1m35s 47s802ms [ User: intelifix - Total duration: 3m7s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m7s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-24 23:16:39 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-24 20:08:38 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-24 20:10:34 Duration: 5s650ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-24.log
5 154ms 10m53s 26s982ms 300 2h14m54s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 24 07 1 7s650ms 7s650ms 08 33 21m10s 38s492ms 09 29 12m3s 24s959ms 10 40 20m57s 31s425ms 11 39 19m19s 29s721ms 12 17 14m42s 51s916ms 13 19 44s273ms 2s330ms 14 21 9m33s 27s330ms 15 28 14m28s 31s10ms 16 45 9m8s 12s195ms 17 28 12m39s 27s107ms [ User: intelifix - Total duration: 2h14m54s - Times executed: 300 ]
[ Application: [unknown] - Total duration: 2h14m54s - Times executed: 300 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028884, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-24 09:16:13 Duration: 10m53s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028875, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-24 08:25:51 Duration: 10m31s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028889, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-24 10:57:11 Duration: 9m53s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
6 11s103ms 1m5s 19s106ms 19 6m3s create table temp0000289382 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 24 08 12 3m28s 17s415ms 09 7 2m34s 22s4ms [ User: intelifix - Total duration: 6m3s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 6m3s - Times executed: 19 ]
-
CREATE TABLE temp0000289382 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 09:45:01 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289382 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 08:09:25 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289382 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 09:04:58 Duration: 15s937ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
7 11s586ms 34s888ms 16s858ms 14 3m56s create table temp0000289418 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 24 10 3 1m 20s52ms 11 1 25s834ms 25s834ms 16 2 34s269ms 17s134ms 17 8 1m55s 14s470ms [ User: intelifix - Total duration: 3m56s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 3m56s - Times executed: 14 ]
-
CREATE TABLE temp0000289418 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 10:09:54 Duration: 34s888ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289418 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 11:30:00 Duration: 25s834ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289418 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 17:13:36 Duration: 19s720ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
8 1s261ms 2m7s 16s14ms 64 17m4s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 24 06 1 2m7s 2m7s 07 5 30s990ms 6s198ms 08 1 2m4s 2m4s 09 3 24s92ms 8s30ms 10 10 4m53s 29s321ms 11 7 48s602ms 6s943ms 12 6 27s48ms 4s508ms 13 6 2m2s 20s367ms 14 6 1m2s 10s466ms 15 7 32s220ms 4s602ms 16 8 31s420ms 3s927ms 17 4 1m40s 25s28ms [ User: intelifix - Total duration: 17m4s - Times executed: 64 ]
[ Application: [unknown] - Total duration: 17m4s - Times executed: 64 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-24', 0366, '', '', 0, 6, '2026-08-01');
Date: 2026-08-24 06:45:22 Duration: 2m7s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-24', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-24 08:56:38 Duration: 2m4s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-24', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-24 10:04:44 Duration: 2m2s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
9 11s436ms 37s812ms 15s787ms 24 6m18s create table temp0000289472 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 24 14 6 1m46s 17s675ms 15 12 2m54s 14s510ms 16 6 1m38s 16s452ms [ User: intelifix - Total duration: 6m18s - Times executed: 24 ]
[ Application: [unknown] - Total duration: 6m18s - Times executed: 24 ]
-
CREATE TABLE temp0000289472 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 14:25:32 Duration: 37s812ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289472 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 16:06:12 Duration: 28s677ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289472 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 15:23:15 Duration: 17s882ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
10 11s359ms 16s135ms 14s530ms 11 2m39s create table temp0000289444 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 24 14 11 2m39s 14s530ms [ User: intelifix - Total duration: 2m39s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 2m39s - Times executed: 11 ]
-
CREATE TABLE temp0000289444 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 14:39:56 Duration: 16s135ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289444 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 14:39:17 Duration: 16s43ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289444 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 14:46:00 Duration: 15s899ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
11 10s726ms 50s412ms 14s441ms 38 9m8s create table temp0000289408 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 24 10 12 2m48s 14s12ms 11 11 3m4s 16s776ms 12 15 3m16s 13s71ms [ User: intelifix - Total duration: 9m8s - Times executed: 38 ]
[ Application: [unknown] - Total duration: 9m8s - Times executed: 38 ]
-
CREATE TABLE temp0000289408 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 11:17:39 Duration: 50s412ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289408 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 12:23:52 Duration: 30s447ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289408 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 11:44:15 Duration: 18s945ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
12 162ms 1m2s 13s269ms 31 6m51s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 24 08 4 1m16s 19s223ms 09 1 1m2s 1m2s 10 3 1m1s 20s513ms 11 4 1m4s 16s25ms 12 4 1m2s 15s548ms 14 5 39s937ms 7s987ms 15 3 19s400ms 6s466ms 16 7 24s569ms 3s509ms [ User: intelifix - Total duration: 6m51s - Times executed: 31 ]
[ Application: psql - Total duration: 6m51s - Times executed: 31 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028884);
Date: 2026-08-24 09:05:45 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028875);
Date: 2026-08-24 08:15:42 Duration: 55s920ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028895);
Date: 2026-08-24 12:06:05 Duration: 38s534ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
13 10s890ms 15s250ms 12s829ms 13 2m46s create table temp0000289402 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 24 08 13 2m46s 12s829ms [ User: intelifix - Total duration: 2m46s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m46s - Times executed: 13 ]
-
CREATE TABLE temp0000289402 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 08:55:52 Duration: 15s250ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289402 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 08:39:10 Duration: 14s743ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CREATE TABLE temp0000289402 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-24 08:37:55 Duration: 13s964ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
14 152ms 23s119ms 6s686ms 130 14m29s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 24 00 2 1s30ms 515ms 05 1 195ms 195ms 07 10 1m25s 8s581ms 08 12 1m38s 8s196ms 09 12 1m42s 8s574ms 10 12 1m45s 8s776ms 11 12 1m49s 9s130ms 12 12 1m25s 7s150ms 13 7 26s405ms 3s772ms 14 12 1m5s 5s447ms 15 12 1m30s 7s504ms 16 9 55s231ms 6s136ms 17 5 6s550ms 1s310ms 20 1 700ms 700ms 21 5 17s135ms 3s427ms 22 6 18s829ms 3s138ms [ User: intelifix - Total duration: 14m29s - Times executed: 130 ]
[ Application: psql - Total duration: 14m29s - Times executed: 130 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-24 10:25:24 Duration: 23s119ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-24 07:45:24 Duration: 23s115ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-24 09:05:22 Duration: 21s258ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
15 244ms 2m31s 6s300ms 47 4m56s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 24 08 9 32s595ms 3s621ms 09 2 2s365ms 1s182ms 10 5 10s362ms 2s72ms 11 5 27s253ms 5s450ms 12 6 2m36s 26s161ms 14 8 5s224ms 653ms 15 4 4s660ms 1s165ms 16 3 16s634ms 5s544ms 17 5 40s41ms 8s8ms [ User: intelifix - Total duration: 4m56s - Times executed: 47 ]
[ Application: psql - Total duration: 4m56s - Times executed: 47 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028895);
Date: 2026-08-24 12:05:27 Duration: 2m31s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028915);
Date: 2026-08-24 16:24:48 Duration: 14s116ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028917);
Date: 2026-08-24 17:13:27 Duration: 11s927ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
16 3s49ms 5s127ms 3s691ms 57 3m30s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 24 08 3 11s579ms 3s859ms 09 3 10s504ms 3s501ms 10 5 18s513ms 3s702ms 11 3 11s204ms 3s734ms 12 3 11s521ms 3s840ms 13 4 13s887ms 3s471ms 14 4 15s80ms 3s770ms 15 6 22s14ms 3s669ms 16 4 15s12ms 3s753ms 17 4 14s40ms 3s510ms 18 3 10s229ms 3s409ms 19 3 10s10ms 3s336ms 20 4 14s98ms 3s524ms 21 4 15s149ms 3s787ms 22 4 17s569ms 4s392ms [ User: intelifix - Total duration: 3m30s - Times executed: 57 ]
[ Application: psql - Total duration: 3m30s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-24 22:00:11 Duration: 5s127ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-24 15:20:05 Duration: 4s871ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-24 21:00:08 Duration: 4s608ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
17 176ms 28s757ms 3s21ms 273 13m44s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 24 00 12 56s994ms 4s749ms 01 12 26s265ms 2s188ms 02 12 26s559ms 2s213ms 03 11 25s99ms 2s281ms 04 11 27s208ms 2s473ms 05 12 35s502ms 2s958ms 06 12 29s646ms 2s470ms 07 12 25s419ms 2s118ms 08 12 42s864ms 3s572ms 09 12 39s463ms 3s288ms 10 12 49s216ms 4s101ms 11 12 36s283ms 3s23ms 12 12 33s690ms 2s807ms 13 12 35s431ms 2s952ms 14 11 40s732ms 3s702ms 15 12 44s83ms 3s673ms 16 12 38s853ms 3s237ms 17 12 41s300ms 3s441ms 18 12 33s421ms 2s785ms 19 12 31s330ms 2s610ms 20 12 43s893ms 3s657ms 21 12 29s387ms 2s448ms 22 12 32s180ms 2s681ms [ User: intelifix - Total duration: 13m44s - Times executed: 273 ]
[ Application: psql - Total duration: 13m44s - Times executed: 273 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-24 00:05:31 Duration: 28s757ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-24 08:25:28 Duration: 16s794ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-24 10:15:30 Duration: 14s261ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-24.log
18 150ms 10s967ms 1s334ms 1,671 37m10s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 24 07 2 1s173ms 586ms 08 130 2m30s 1s157ms 09 296 5m11s 1s52ms 10 222 3m42s 1s3ms 11 162 2m43s 1s9ms 12 66 54s843ms 830ms 13 46 1m56s 2s521ms 14 199 6m17s 1s898ms 15 253 6m16s 1s488ms 16 206 6m2s 1s761ms 17 89 1m32s 1s38ms [ User: intelifix - Total duration: 37m10s - Times executed: 1671 ]
[ Application: [unknown] - Total duration: 37m10s - Times executed: 1671 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (54472, 406, '835091914000366,241664936971,241620782225,241620867384,241632248911,241679918186,241604747281,241727049700,241649689917,241694978602,241637734261,241609915777,241678344655,241649552934,230048476481,241728719201,241726966280,241609885067,241639105270,241711218390,241668285671,241598864362,241678304045,241609896583,241689117176,241676720715,241690076170,241729921631,241713730814,241607471420,241676645858,241637720018,241732175666,241727492931,230040174257,241714204552,241728553046,241714900513,241607088700,241668207481,241727052125', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-24 13:08:53 Duration: 10s967ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (54474, 413, 'ZTE3ANNT3H64525,D831399CABE6,D831399CABE7,ZTEGDD32CCAC$ZTE3ANNR4N60550,4896D95AE63C,4896D95AE63D,ZTEGD9800C4B$ZTE3ANNT3H68911,D831399D12B2,D831399D12B3,ZTEGDD32DDCE$ZTE3ANNT3F09174,D831399602CC,D831399602CD,ZTEGDD31B07D$ZTE3ANNRCP46761,6C11BA6D72C5,6C11BA6D72C6,ZTEGDC6FF73C$ZTE3ANNT3H64521,D831399CABCE,D831399CABCF,ZTEGDD32CCA8$ZTE3ANNR5W01258,48D6822EA146,48D6822EA147,ZTEGDB0004E9$ZTE3ANNT2V49449,D831399015CE,D831399015CF,ZTEGDD30B3A8$ZTE3ANNR9325875,D89A0D84BE7D,D89A0D84BE7E,ZTEGDB14D912$ZTE3ANNRC562250,6C11BA67DCD3,6C11BA67DCD4,ZTEGDC6F08E9$ZTE3ANNT3F09378,D83139960794,D83139960795,ZTEGDD31B149$ZTE3ANNRCB01435,D831391DF0A0,D831391DF0A1,ZTEGDD29BB30$ZTE3ANNRC557056,6C11BA676317,6C11BA676318,ZTEGDC6EF49F$ZTE3ANNT3J09802,D83139A0D10E,D83139A0D10F,ZTEGDD337D88$ZTE3ANNQ8M18802,843C99208097,843C99208098,ZTEGD7BA90DF$ZTE3ANNRC565051,6C11BA681E79,6C11BA681E7A,ZTEGDC6F13DA$ZTE3ANNRB737722,5872C991AD4D,5872C991AD4E,ZTEGDC61BE2D$ZTE3ANNRB737440,5872C991A6B1,5872C991A6B2,ZTEGDC61BD13$ZTE3ANNR7B33107,3891484BF499,3891484BF49A,ZTEGDB0812B3$ZTE3ANNR2Q01504,F4E84F80D740,F4E84F80D741,ZTEGD97A789A$ZTE3ANNR9325794,D89A0D84BC97,D89A0D84BC98,ZTEGDB14D8C1$ZTE3ANNR9W44361,D89A0DAC6BD9,D89A0DAC6BDA,ZTEGDB16BEF4$ZTE3ANNT4P35650,F00C514EEA2A,F00C514EEA2B,ZTEGDE3481D8$ZTE3ANNT3H17595,D83139985FFA,D83139985FFB,ZTEGDD32155A$ZTE3ANNQ9J09617,843C992CB29B,843C992CB29C,ZTEGD7BB2E3C$ZTE3ANNRCB04712,D831391E3D6E,D831391E3D6F,ZTEGDD29C7FD$ZTE3ANNRCP49327,6C11BA6DAEE9,6C11BA6DAEEA,ZTEGDC700142$ZTE3ANNQ8M18800,843C9920808B,843C9920808C,ZTEGD7BA90DD$ZTE3ANNQ4A03475,3CF9F0AA49B8,3CF9F0AA49B9,ZTEGD6414C52$ZTE3ANNQ7507526,C4EBFF8BA3A0,C4EBFF8BA3A1,ZTEGD70A6C06$ZTE3ANNR9W46279,D89A0DAC98CD,D89A0DAC98CE,ZTEGDB16C672$ZTE3ANNRCB24568,D83139200ECE,D83139200ECF,ZTEGDD2A158D$ZTE3ANNRC552224,6C11BA66F1D7,6C11BA66F1D8,ZTEGDC6EE1BF$ZTE3ANNR2Q37336,F4E84F841F10,F4E84F841F11,ZTEGD97B0492$ZTE3ANNT3F11299,D8313996349A,D8313996349B,ZTEGDD31B8CA$ZTE3ANNRC501591,6C11BA624F21,6C11BA624F22,ZTEGDC6E1BF6$ZTE3ANNR5W76300,48D682358012,48D682358013,ZTEGDB012A0B$ZTE3ANNRCB04778,D831391E3EFA,D831391E3EFB,ZTEGDD29C83F$ZTE3ANNT3J07475,D83139A09A84,D83139A09A85,ZTEGDD337471$ZTE3ANNRCP04060,6C11BA6989F7,6C11BA6989F8,ZTEGDC6F506F$ZTE3ANNQ4N02414,3CF9F0A8CA42,3CF9F0A8CA43,ZTEGD6410C69', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-24 13:57:05 Duration: 8s686ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (280073, 452, '14308685850103102433,D86C5A490FCE,C85D380593EA,C85D3805A7C4,D86C5A401C04,C85D3881D410,D86C5A4B8C34,D86C5A05500F,C85D3875BED4,D86C5A08CA04', '',0151,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-24 11:38:34 Duration: 8s508ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
19 153ms 8s769ms 1s142ms 113 2m9s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 24 08 6 6s31ms 1s5ms 09 10 9s82ms 908ms 10 13 18s577ms 1s429ms 11 16 33s191ms 2s74ms 12 8 7s4ms 875ms 13 13 10s691ms 822ms 15 11 5s395ms 490ms 16 30 30s625ms 1s20ms 17 6 8s516ms 1s419ms [ User: intelifix - Total duration: 2m9s - Times executed: 113 ]
[ Application: [unknown] - Total duration: 2m9s - Times executed: 113 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0279926) LIMIT 1;
Date: 2026-08-24 11:39:28 Duration: 8s769ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0279926) LIMIT 1;
Date: 2026-08-24 11:06:55 Duration: 6s608ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0280488) LIMIT 1;
Date: 2026-08-24 10:54:30 Duration: 6s279ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
20 150ms 8s556ms 891ms 1,015 15m5s select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 24 07 19 15s665ms 824ms 08 70 1m 861ms 09 102 1m34s 930ms 10 134 2m29s 1s114ms 11 121 2m 994ms 12 34 28s547ms 839ms 13 106 1m17s 728ms 14 123 1m50s 899ms 15 169 2m26s 868ms 16 119 1m25s 721ms 17 18 15s481ms 860ms [ User: intelifix - Total duration: 15m5s - Times executed: 1015 ]
[ Application: [unknown] - Total duration: 15m5s - Times executed: 1015 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "229989", "modelo" : "155", "itens" : "D833B71EB914,94988F948C30,186A81D58E10,44D454ABDB03,94988F30840E,841EA3690C12,D0CF0EFDDFF2", "usuario" : "414", "caixa" : "2755449", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-24 15:03:14 Duration: 8s556ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "280804", "modelo" : "155", "itens" : "C03C048535CB,,C4EB42A02C24,D0CF0EFD863B,44D4546B66BB,C03C0486558F,4C195DCCCC05,582FF79BC4B4,6CFFCE68D0FE,B0FC88EB9327,C4EB429FF7CE", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-24 09:49:59 Duration: 7s914ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "280790", "modelo" : "320", "itens" : "241704764652,241714193238,241615215071,241706432436,241604358298,241702795470,241706515878,241694432028,241593801736,241674659604,241609834254,241671496377,241645521026,241622678391,241614509211,241704658907,241702085064,241675751417,241691401923,241714212028,241726186574,241666315658,241703438899,241610173737,241679072841,241645656773,241619591436,241706628391,241679499403,241694509409,241730317886,241703442537,241660875161,241631840712", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-24 11:02:35 Duration: 4s771ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-24.log
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 13 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 23 08 1 0ms 0ms 09 1 0ms 0ms 10 2 0ms 0ms 13 2 0ms 0ms 16 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms Aug 24 21 2 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 10m38s - Times executed: 13 ]
[ Application: psql - Total duration: 10m38s - Times executed: 13 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 17,665 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 36 FATAL entries
- 3517 ERROR entries
- 0 WARNING entries
- 4 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,479 Max number of times the same event was reported
- 3,557 Total events found
Rank Times reported Error 1 3,479 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 24 00 59 01 60 02 59 03 60 04 60 05 59 06 60 07 202 08 363 09 291 10 341 11 326 12 164 13 139 14 308 15 298 16 182 17 101 18 59 19 59 20 60 21 59 22 60 23 50 - ERROR: prepared statement "_PLAN00000000299C7BF0" does not exist
- ERROR: prepared statement "_PLAN0000000029A0F7C0" does not exist
- ERROR: prepared statement "_PLAN0000000029A0A5A0" does not exist
Statement: DEALLOCATE "_PLAN00000000299C7BF0"
Date: 2026-08-24 00:00:37 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
Statement: DEALLOCATE "_PLAN0000000029A0F7C0"
Date: 2026-08-24 00:01:38 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
Statement: DEALLOCATE "_PLAN0000000029A0A5A0"
Date: 2026-08-24 00:02:38 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
2 28 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 24 00 3 01 2 02 2 03 1 04 1 05 2 06 2 07 1 08 1 09 1 10 3 11 1 12 1 13 1 14 2 16 1 17 1 20 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-08-24 00:02:53 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
Date: 2026-08-24 00:25:40 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
Date: 2026-08-24 00:41:03 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
3 16 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 24 08 2 10 2 11 2 14 6 16 4 - ERROR: syntax error at or near "]" at character 35
- ERROR: syntax error at or near "]" at character 35
- ERROR: syntax error at or near "f" at character 35
Statement: select * from rs_caixa_qr(3518482 ])
Date: 2026-08-24 08:50:59 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
Statement: select * from rs_caixa_qr(3518482 ])
Date: 2026-08-24 08:51:00 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
Statement: select * from rs_caixa_qr(3519825 f)
Date: 2026-08-24 10:36:22 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
4 7 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 24 08 2 10 3 11 1 15 1 - ERROR: column "khy" does not exist at character 27
- ERROR: column "khy" does not exist at character 27
- ERROR: column "m1" does not exist at character 29
Statement: select * from rs_caixa_qr(KHY)
Date: 2026-08-24 08:30:01 Database: contagem Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
Statement: select * from rs_caixa_qr(KHY)
Date: 2026-08-24 08:30:02 Database: contagem Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
Statement: SELECT * FROM RS_ETIQUETA( -M1)
Date: 2026-08-24 10:08:14 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
5 6 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 24 03 6 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-08-24 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
Date: 2026-08-24 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
Date: 2026-08-24 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
6 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 24 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-24 05:32:13 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-24 05:32:13 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-24 05:32:13 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
7 4 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 24 11 3 14 1 - ERROR: trailing junk after numeric literal at or near "30Ç93ÇBCÇBDÇA4Ç14" at character 27
- ERROR: trailing junk after numeric literal at or near "30Ç93ÇBCÇBDÇA4Ç14" at character 27
- ERROR: trailing junk after numeric literal at or near "30Ç93ÇBCÇBDÇA4Ç14" at character 27
Statement: SELECT * FROM RS_ETIQUETA(30Ç93ÇBCÇBDÇA4Ç14)
Date: 2026-08-24 11:10:45 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
Statement: SELECT * FROM RS_ETIQUETA(30Ç93ÇBCÇBDÇA4Ç14)
Date: 2026-08-24 11:10:45 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
Statement: SELECT * FROM RS_ETIQUETA(30Ç93ÇBCÇBDÇA4Ç14)
Date: 2026-08-24 11:10:45 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
8 2 ERROR: function rs_etiqueta(...) does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 24 11 2 - ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(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_ETIQUETA(73833485850062500927)Date: 2026-08-24 11:12:39 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73833485850062500927)Date: 2026-08-24 11:12:39 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
9 2 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #9
Day Hour Count Aug 24 11 1 15 1 - LOG: process 1489563 still waiting for AccessExclusiveLock on relation 4188431 of database 358220 after 1000.368 ms
- LOG: process 1593738 still waiting for AccessExclusiveLock on relation 4203623 of database 358220 after 1000.164 ms
Detail: Process holding the lock: 1493966. Wait queue: 1489563.
Statement: DROP TABLE IF EXISTS temp0000289408;Date: 2026-08-24 11:19:32 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
Detail: Process holding the lock: 1660528. Wait queue: 1593738.
Statement: DROP TABLE IF EXISTS temp0000289472;Date: 2026-08-24 15:06:14 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
10 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #10
Day Hour Count Aug 24 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-24 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
Date: 2026-08-24 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
11 2 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #11
Day Hour Count Aug 24 11 1 15 1 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000289408"
Date: 2026-08-24 11:19:32 Log file: /usr/local/pgsql/data/log/serverlog-24.log
Context: automatic vacuum of table "rio.public.temp0000289472"
Date: 2026-08-24 15:06:14 Log file: /usr/local/pgsql/data/log/serverlog-24.log
12 1 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #12
Day Hour Count Aug 24 11 1 - ERROR: unterminated quoted string at or near "''');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-08-24 11:25:45 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
13 1 LOG: skipping analyze of "..." --- lock not available
Times Reported Most Frequent Error / Event #13
Day Hour Count Aug 24 10 1 - LOG: skipping analyze of "temp0000289408" --- lock not available
Date: 2026-08-24 10:45:29 Log file: /usr/local/pgsql/data/log/serverlog-24.log
14 1 ERROR: function rs_lote_manutencao_itens(...) does not exist
Times Reported Most Frequent Error / Event #14
Day Hour Count Aug 24 10 1 - ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) 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_LOTE_MANUTENCAO_ITENS(54342,413,'835192928004306,241694228898$835196929005267,241695066668$835016903001993,241649663046$835248936000196,241712554851','',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""}]','$$$','',0241694228898);Date: 2026-08-24 10:15:01 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log
15 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #15
Day Hour Count Aug 24 03 1 - LOG: database system was shut down at 2026-08-24 03:05:02 -03
Date: 2026-08-24 03:05:02 Log file: /usr/local/pgsql/data/log/serverlog-24.log
16 1 ERROR: invalid input syntax for type date: ...
Times Reported Most Frequent Error / Event #16
Day Hour Count Aug 24 07 1 - ERROR: invalid input syntax for type date: "N-Na--N-Na" at character 40
Statement: SELECT * FROM RS_RESUMO_PERIODO_GERAL( 'N-Na--N-Na', 0404 ,'', '',0,7,'2026-08-01');
Date: 2026-08-24 07:39:22 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-24.log