pgBadger-
Global information
- Generated on Tue Aug 4 23:50:14 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 43,326 log entries in 13s
- Log start from 2026-08-04 00:00:40 to 2026-08-04 23:50:12
-
Overview
Global Stats
- 376 Number of unique normalized queries
- 6,309 Number of queries
- 8h15m43s Total query duration
- 2026-08-04 00:02:07 First query
- 2026-08-04 23:46:55 Last query
- 5 queries/s at 2026-08-04 16:09:56 Query peak
- 8h15m43s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h15m43s Execute total duration
- 4,167 Number of events
- 14 Number of unique normalized events
- 4,003 Max number of times the same event was reported
- 0 Number of cancellation
- 459 Total number of automatic vacuums
- 930 Total number of automatic analyzes
- 11 Number temporary file
- 238.69 MiB Max size of temporary file
- 110.33 MiB Average size of temporary file
- 372 Total number of sessions
- 7 sessions at 2026-08-04 20:07:34 Session peak
- 13d15h18m9s Total duration of sessions
- 52m47s Average duration of sessions
- 16 Average queries per session
- 1m19s Average queries duration per session
- 51m27s Average idle time per session
- 380 Total number of connections
- 7 connections/s at 2026-08-04 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-04 16:09:56 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-04 14:56:49 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-04 23:46:24 Date
Queries duration
Key values
- 8h15m43s 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 04 00 27 0ms 20s990ms 4s810ms 5s568ms 7s634ms 1m29s 01 39 0ms 4s372ms 1s139ms 5s139ms 7s310ms 8s192ms 02 18 0ms 3s995ms 2s80ms 5s85ms 6s104ms 8s44ms 03 20 0ms 5s289ms 1s889ms 5s81ms 6s231ms 9s35ms 04 24 0ms 3s960ms 1s591ms 4s934ms 6s69ms 6s955ms 05 62 0ms 10m3s 20s338ms 13s480ms 2m45s 10m4s 06 21 0ms 9s444ms 2s659ms 3s544ms 4s341ms 28s801ms 07 179 0ms 11m19s 10s632ms 1m3s 4m15s 11m19s 08 481 150ms 5m44s 5s465ms 4m19s 5m2s 6m24s 09 704 150ms 11m20s 4s704ms 1m2s 7m37s 11m54s 10 544 150ms 8m19s 3s398ms 47s220ms 3m53s 8m21s 11 634 150ms 6m49s 2s795ms 1m15s 2m5s 6m58s 12 222 0ms 7m15s 8s90ms 51s535ms 4m44s 7m21s 13 422 0ms 5m38s 2s537ms 35s589ms 50s344ms 5m41s 14 633 150ms 6m26s 2s542ms 44s277ms 1m38s 6m31s 15 749 150ms 8m25s 4s525ms 4m27s 6m11s 8m34s 16 583 150ms 8m14s 2s868ms 51s886ms 2m57s 8m32s 17 358 0ms 7m6s 2s873ms 14s620ms 25s390ms 7m58s 18 28 0ms 5m38s 22s16ms 3s859ms 46s23ms 5m38s 19 21 0ms 5m35s 29s270ms 4s99ms 45s34ms 5m35s 20 128 0ms 5m59s 10s133ms 1m10s 2m12s 7m53s 21 40 0ms 7m 18s305ms 6s785ms 9s988ms 7m46s 22 32 0ms 5m23s 20s58ms 7s417ms 16s788ms 5m53s 23 340 0ms 1m27s 6s485ms 1m7s 1m14s 1m31s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 04 00 4 0 2s144ms 0ms 0ms 150ms 01 21 0 268ms 173ms 291ms 1s278ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 192ms 0ms 0ms 0ms 04 6 0 390ms 0ms 0ms 451ms 05 37 0 276ms 311ms 583ms 1s272ms 06 6 0 1s296ms 0ms 0ms 807ms 07 102 0 15s443ms 2s757ms 31s20ms 6m46s 08 346 0 6s348ms 12s166ms 4m4s 5m17s 09 546 0 4s225ms 12s607ms 19s934ms 6m39s 10 456 0 3s435ms 9s822ms 20s291ms 6m26s 11 509 0 2s832ms 15s128ms 42s484ms 4m24s 12 162 0 9s598ms 4s299ms 26s703ms 5m56s 13 327 0 2s799ms 10s837ms 14s220ms 3m43s 14 489 0 2s483ms 11s570ms 21s181ms 4m33s 15 574 0 4s778ms 18s468ms 4m27s 6m11s 16 415 0 3s231ms 10s266ms 16s299ms 4m6s 17 228 0 4s125ms 6s959ms 8s897ms 4m12s 18 11 0 53s362ms 0ms 0ms 3m17s 19 6 0 1m38s 0ms 0ms 3m27s 20 18 93 11s204ms 18s35ms 1m6s 3m40s 21 15 0 44s752ms 0ms 451ms 3m21s 22 9 0 1m4s 0ms 0ms 3m31s 23 16 324 6s485ms 1m3s 1m6s 1m27s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 04 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 04 00 0 1 1.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 1 1.00 0.00% 05 0 3 3.00 0.00% 06 0 2 2.00 0.00% 07 0 15 15.00 0.00% 08 0 13 13.00 0.00% 09 0 16 16.00 0.00% 10 0 16 16.00 0.00% 11 0 15 15.00 0.00% 12 0 6 6.00 0.00% 13 0 10 10.00 0.00% 14 0 15 15.00 0.00% 15 0 14 14.00 0.00% 16 0 10 10.00 0.00% 17 0 8 8.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 2 2.00 0.00% 22 0 1 1.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Aug 04 00 13 0.00/s 01 10 0.00/s 02 8 0.00/s 03 15 0.00/s 04 10 0.00/s 05 9 0.00/s 06 16 0.00/s 07 18 0.01/s 08 23 0.01/s 09 26 0.01/s 10 21 0.01/s 11 27 0.01/s 12 12 0.00/s 13 21 0.01/s 14 25 0.01/s 15 19 0.01/s 16 19 0.01/s 17 20 0.01/s 18 10 0.00/s 19 9 0.00/s 20 16 0.00/s 21 11 0.00/s 22 11 0.00/s 23 11 0.00/s Day Hour Count Average Duration Average idle time Aug 04 00 6 1h1m 1h38s 01 12 1h1m15s 1h1m11s 02 10 1h36s 1h32s 03 16 21m15s 21m13s 04 7 1h3m 1h2m54s 05 10 1h37s 58m31s 06 9 57m26s 57m20s 07 16 55m11s 53m12s 08 19 58m27s 56m9s 09 26 44m39s 42m32s 10 24 56m20s 55m3s 11 27 44m10s 43m5s 12 18 56m36s 54m56s 13 12 57m48s 56m19s 14 23 54m22s 53m12s 15 23 52m19s 49m52s 16 18 56m57s 55m24s 17 20 52m48s 51m56s 18 18 1h40s 1h6s 19 10 1h18s 59m17s 20 12 46m24s 44m36s 21 11 57m44s 56m37s 22 11 1h1m2s 1h4s 23 14 37m8s 34m30s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-08-04 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 380 connections Total
Connections per user
Key values
- intelifix Main User
- 380 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-08-04 20:07:34 Date
Histogram of session times
Key values
- 294 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 372 sessions Total
Sessions per user
Key values
- intelifix Main User
- 372 sessions Total
Sessions per host
Key values
- [local] Main Host
- 372 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 16,848 buffers Checkpoint Peak
- 2026-08-04 11:44:37 Date
- 270.015 seconds Highest write time
- 0.914 seconds Sync time
Checkpoints Wal files
Key values
- 13 files Wal files usage Peak
- 2026-08-04 11:44:37 Date
Checkpoints distance
Key values
- 412.07 Mo Distance Peak
- 2026-08-04 11:44:37 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 04 00 26,169 623.779s 0.099s 623.933s 01 2,571 258.162s 0.273s 258.494s 02 1,305 131.144s 0.082s 131.29s 03 1,487 149.5s 0.084s 149.64s 04 1,791 179.852s 0.129s 180.085s 05 10,971 1,078.643s 1.124s 1,079.843s 06 2,909 269.513s 0.004s 269.54s 07 32,972 2,248.85s 0.354s 2,249.419s 08 61,974 3,238.751s 0.813s 3,239.778s 09 69,383 3,238.374s 1.004s 3,239.642s 10 59,868 3,238.629s 0.811s 3,239.618s 11 77,750 3,238.771s 0.857s 3,239.83s 12 42,244 2,286.353s 0.479s 2,286.979s 13 38,237 2,558.846s 0.792s 2,559.802s 14 67,110 3,238.546s 0.998s 3,239.799s 15 104,521 3,238.128s 1.232s 3,239.634s 16 52,611 3,232.721s 0.715s 3,233.647s 17 25,052 2,300.249s 0.453s 2,300.853s 18 2,165 218.695s 0.116s 218.857s 19 51 5.155s 0.007s 5.175s 20 2,308 242.172s 0.083s 242.279s 21 2,567 258.333s 0.19s 258.734s 22 2,170 217.787s 0.128s 217.978s 23 245 24.732s 0.068s 24.837s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 04 00 0 0 6 493 0.032s 0.006s 01 0 0 1 597 0.065s 0.01s 02 0 0 0 396 0.012s 0.006s 03 0 0 1 339 0.008s 0.006s 04 0 0 0 432 0.061s 0.006s 05 0 0 5 999 0.845s 0.024s 06 0 0 1 8 0.003s 0.001s 07 0 0 13 2,472 0.037s 0.012s 08 0 0 40 6,123 0.022s 0.012s 09 0 0 63 7,510 0.041s 0.012s 10 0 0 27 6,808 0.064s 0.012s 11 0 0 38 6,891 0.064s 0.012s 12 0 0 23 3,621 0.066s 0.012s 13 0 0 22 5,641 0.120s 0.012s 14 0 0 37 7,774 0.065s 0.012s 15 0 0 67 7,932 0.063s 0.012s 16 0 0 34 5,934 0.063s 0.012s 17 0 0 9 4,570 0.024s 0.011s 18 0 0 1 313 0.069s 0.01s 19 0 0 0 8 0.003s 0.003s 20 0 0 1 85 0.060s 0.005s 21 0 0 1 436 0.064s 0.016s 22 0 0 0 412 0.064s 0.01s 23 0 0 1 21 0.062s 0.016s Day Hour Count Avg time (sec) Aug 04 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 04 00 17,832.33 kB 52,448.50 kB 01 1,604.00 kB 29,460.25 kB 02 1,104.83 kB 14,631.83 kB 03 1,174.71 kB 2,920.00 kB 04 1,433.00 kB 2,038.17 kB 05 9,224.33 kB 17,273.67 kB 06 6,600.00 kB 15,253.00 kB 07 18,108.08 kB 43,981.08 kB 08 54,996.42 kB 93,154.83 kB 09 85,325.17 kB 110,064.33 kB 10 37,104.50 kB 100,719.67 kB 11 52,244.00 kB 113,331.67 kB 12 31,462.33 kB 118,372.00 kB 13 30,007.92 kB 61,749.25 kB 14 50,079.75 kB 88,834.67 kB 15 91,707.58 kB 148,665.92 kB 16 46,548.25 kB 120,109.58 kB 17 13,654.64 kB 58,985.27 kB 18 1,563.33 kB 27,074.33 kB 19 138.50 kB 17,679.00 kB 20 5,218.33 kB 14,871.00 kB 21 1,388.78 kB 8,743.33 kB 22 1,462.62 kB 4,488.38 kB 23 144.50 kB 2,739.00 kB -
Temporary Files
Size of temporary files
Key values
- 477.38 MiB Temp Files size Peak
- 2026-08-04 05:32:07 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-04 05:32:07 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 04 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.08 GiB 110.96 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 1 104.00 MiB 104.00 MiB 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 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 927.20 MiB 71.19 MiB 238.69 MiB 115.90 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-04 05:32:14 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-04 05:32:07 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 182.38 MiB 91.19 MiB 91.19 MiB 91.19 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-04 05:30:44 Duration: 42s258ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-04 05:30:41 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( 027947, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-04 07:19:59 Duration: 6m46s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027984, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-04 09:57:57 Duration: 6m36s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028006, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-04 15:03:48 Duration: 6m7s Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 238.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-04 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 238.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-04 05:32:07 - 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-04 10:01:54 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 91.19 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-04 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 91.19 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-04 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 78.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-04 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 78.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-04 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 78.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-04 05:32:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 71.27 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-04 05:32:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 71.19 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-04 05:32:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 71.19 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-04 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 3.85 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-04 09:20:11 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 3.85 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-04 09:20:11 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (116) Main table analyzed (database rio)
- 930 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 116 rio.pg_catalog.pg_class 63 rio.pg_catalog.pg_type 50 rio.public.usuarios 47 brasilia.pg_catalog.pg_attribute 46 contagem.pg_catalog.pg_attribute 39 rio.pg_catalog.pg_index 36 rio.public.temp0000287398 34 rio.public.temp0000287372 32 contagem.public.usuarios 30 rio.pg_catalog.pg_depend 27 rio.public.temp0000287450 23 brasilia.pg_catalog.pg_class 18 contagem.pg_catalog.pg_class 18 brasilia.pg_catalog.pg_type 16 contagem.pg_catalog.pg_type 16 rio.public.temp0000287388 14 rio.public.temp0000287368 14 rio.public.temp0000287382 12 contagem.pg_catalog.pg_index 11 brasilia.public.usuarios 10 rio.public.temp0000287482 9 contagem.pg_catalog.pg_depend 9 brasilia.pg_catalog.pg_index 9 rio.public.temp0000287440 9 rio.public.temp0000287376 8 rio.public.temp0000287492 8 rio.public.temp0000287306 8 rio.public.temp0000287456 8 rio.public.temp0000287436 8 rio.public.temp0000287476 8 rio.public.temp0000287406 7 rio.public.temp0000287366 7 brasilia.pg_catalog.pg_depend 7 rio.public.temp0000287374 6 rio.public.temp0000287312 6 rio.public.temp0000287356 6 rio.public.temp0000287472 6 brasilia.public.temp0000237412 6 rio.auditor.auditor_2026_08 5 contagem.auditor.auditor_2026_08 5 contagem.public.temp0000226710 5 rio.public.temp0000287442 5 rio.public.temp0000287480 5 rio.public.temp0000287484 5 contagem.public.temp0000226760 5 brasilia.public.temp0000237420 5 rio.public.temp0000287304 5 contagem.pg_catalog.pg_shdepend 5 brasilia.auditor.auditor_2026_08 4 template1.pg_catalog.pg_shdepend 3 postgres.pg_catalog.pg_shdepend 3 brasilia.public.temp0000237464 3 rio.public.temp0000287426 3 brasilia.public.temp0000237436 3 rio.public.temp0000287454 3 rio.public.temp0000287446 2 brasilia.public.temp0000237472 2 rio.public.temp0000287384 2 rio.public.temp0000287370 2 rio.public.temp0000287470 2 brasilia.public.temp0000237484 2 rio.public.temp0000287410 2 contagem.public.nf_entrada 2 rio.public.temp0000287394 2 rio.public.temp0000287466 1 contagem.public.temp0000226758 1 brasilia.public.temp0000237422 1 rio.pg_catalog.pg_shdepend 1 rio.public.temp0000287390 1 contagem.public.temp0000226764 1 brasilia.public.temp0000237424 1 rio.public.temp0000287400 1 rio.public.temp0000287420 1 rio.public.temp0000287462 1 brasilia.public.temp0000237462 1 rio.public.temp0000287414 1 rio.public.temp0000287424 1 brasilia.public.temp0000237452 1 contagem.public.temp0000226762 1 rio.public.temp0000287448 1 brasilia.public.temp0000237448 1 rio.public.temp0000287318 1 contagem.public.temp0000226724 1 rio.public.temp0000287396 1 brasilia.public.temp0000237460 1 rio.public.temp0000287486 1 brasilia.public.temp0000237458 1 rio.public.temp0000287444 1 contagem.public.temp0000226748 1 rio.public.temp0000287438 1 rio.public.temp0000287364 1 contagem.public.temp0000226756 1 brasilia.pg_catalog.pg_shdepend 1 brasilia.public.nf_entrada 1 brasilia.public.temp0000237480 1 rio.public.temp0000287458 1 rio.public.temp0000287392 1 Total 930 Vacuums per table
Key values
- pg_catalog.pg_attribute (47) Main table vacuumed on database rio
- 459 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 47 39 0 0 0 0 0 22,499 6,524 9,294,562 412 9,795 rio.pg_catalog.pg_class 33 21 0 0 0 0 0 4,493 1,524 2,264,675 92 419 contagem.public.usuarios 30 0 0 0 0 0 0 132 101 57,245 0 0 rio.pg_catalog.pg_type 28 20 0 0 0 0 0 1,902 557 749,320 65 233 rio.public.temp0000287450 23 0 0 0 0 0 0 25,953 1,801 3,739,249 0 0 contagem.pg_catalog.pg_attribute 20 20 0 0 0 0 0 18,411 2,716 6,215,266 31 788 rio.pg_catalog.pg_index 19 14 0 0 0 0 0 871 300 269,150 47 114 rio.public.usuarios 16 6 0 0 0 0 0 166 56 108,917 6 7 rio.public.temp0000287372 15 0 0 0 0 0 0 17,023 4,087 6,212,348 0 0 brasilia.pg_catalog.pg_attribute 14 14 0 0 0 0 0 6,696 1,878 3,021,239 63 1,578 rio.public.temp0000287398 13 0 0 0 0 0 0 5,294 1,754 2,510,894 0 0 contagem.pg_catalog.pg_class 12 12 0 0 0 0 0 4,217 401 820,235 6 18 rio.public.temp0000287388 12 0 0 0 0 0 0 839 262 391,662 0 0 rio.pg_catalog.pg_depend 11 11 0 0 0 0 0 3,340 1,245 1,791,802 74 542 contagem.pg_catalog.pg_index 10 10 0 0 0 0 0 843 111 187,954 5 10 contagem.pg_catalog.pg_type 10 10 0 0 0 0 0 1,909 262 564,557 6 16 contagem.pg_catalog.pg_depend 10 10 0 0 0 0 0 4,293 566 1,432,200 6 52 rio.public.temp0000287482 9 0 0 0 0 0 0 10,232 1,734 2,800,213 0 0 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 9,425 2,779 11,313,993 1,740 8,465 rio.public.temp0000287436 7 0 0 0 0 0 0 10,216 1,725 2,794,028 0 0 template1.pg_catalog.pg_shdepend 7 7 0 0 0 0 0 876 168 326,688 66 142 rio.public.temp0000287312 6 0 0 0 0 0 0 693 231 385,264 0 0 rio.public.temp0000287472 6 0 0 0 0 0 0 6,820 3,422 4,784,424 0 0 rio.public.temp0000287306 6 0 0 0 0 0 0 469 86 115,991 0 0 rio.auditor.auditor_2026_08 5 0 0 0 0 0 0 110,211 47,390 62,762,345 31,227 617,698 contagem.public.temp0000226760 5 0 0 0 0 0 0 540 30 36,635 0 0 brasilia.pg_catalog.pg_class 5 5 0 0 0 0 0 1,106 371 576,173 22 69 brasilia.pg_catalog.pg_type 5 5 0 0 0 0 0 547 184 222,722 21 46 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,834 546 2,458,915 172 482 rio.public.temp0000287484 4 0 0 0 0 0 0 3,418 14 204,004 0 0 rio.public.temp0000287440 4 0 0 0 0 0 0 337 122 190,212 0 0 rio.public.temp0000287406 4 0 0 0 0 0 0 507 183 309,293 0 0 rio.public.temp0000287492 3 0 0 0 0 0 0 501 179 307,306 0 0 contagem.auditor.auditor_2026_08 3 1 0 0 0 0 0 18,575 8,237 10,714,758 3,090 52,100 brasilia.pg_catalog.pg_index 3 3 0 0 0 0 0 215 66 49,941 16 21 postgres.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 466 156 279,200 15 24 rio.public.temp0000287304 3 0 0 0 0 0 0 243 16 16,715 0 0 brasilia.auditor.auditor_2026_08 3 0 0 0 0 0 0 15,156 8,776 11,579,262 2,834 55,200 brasilia.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 389 102 178,280 22 44 rio.public.temp0000287426 3 0 0 0 0 0 0 12 9 2,322 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 422 132 484,059 36 86 brasilia.pg_catalog.pg_depend 2 2 0 0 0 0 0 752 235 302,251 17 114 rio.public.temp0000287454 2 0 0 0 0 0 0 283 154 264,393 0 0 rio.public.temp0000287446 2 0 0 0 0 0 0 1,706 7 101,795 0 0 rio.public.temp0000287470 2 0 0 0 0 0 0 3,406 8 202,160 0 0 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,264 1,301 4,233,360 1,126 7,340 brasilia.public.temp0000237472 2 0 0 0 0 0 0 492 250 402,800 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,217 10 168,393 1 13 contagem.public.temp0000226748 1 0 0 0 0 0 0 107 6 7,268 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 148 10 31,655 6 10 rio.public.temp0000287448 1 0 0 0 0 0 0 65 4 4,438 0 0 rio.pg_toast.pg_toast_365051 1 0 0 0 0 0 0 859 292 1,932,479 284 1,071 rio.public.temp0000287480 1 0 0 0 0 0 0 68 4 4,615 0 0 rio.public.temp0000287394 1 0 0 0 0 0 0 1,704 4 101,139 0 0 rio.public.temp0000287466 1 0 0 0 0 0 0 65 4 4,438 0 0 brasilia.public.temp0000237424 1 0 0 0 0 0 0 246 6 15,652 0 0 rio.public.temp0000287462 1 0 0 0 0 0 0 65 4 4,438 0 0 rio.public.temp0000287456 1 0 0 0 0 0 0 8 5 1,374 0 0 rio.public.temp0000287486 1 0 0 0 0 0 0 4 3 774 0 0 brasilia.public.temp0000237458 1 0 0 0 0 0 0 246 6 15,650 0 0 brasilia.public.temp0000237462 1 0 0 0 0 0 0 246 6 15,650 0 0 Total 459 233 0 0 0 0 0 328,042 103,122 160,338,740 41,508 756,497 Vacuum throughput per table
Key values
- auditor.auditor_2026_08 (16.8) 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.43 rio.pg_catalog.pg_class 0 0 0.81 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_type 0 0 0.29 rio.public.temp0000287450 0 0 0.99 contagem.pg_catalog.pg_attribute 0 0 1.96 rio.pg_catalog.pg_index 0 0 0.53 rio.public.usuarios 0 0 0.01 rio.public.temp0000287372 0 0 0.77 brasilia.pg_catalog.pg_attribute 0 0 1.16 rio.public.temp0000287398 0 0 0.45 contagem.pg_catalog.pg_class 0 0 0.93 rio.public.temp0000287388 0 0 0.16 rio.pg_catalog.pg_depend 0 0 0.72 contagem.pg_catalog.pg_index 0 0 0.21 contagem.pg_catalog.pg_type 0 0 0.41 contagem.pg_catalog.pg_depend 0 0 0.62 rio.public.temp0000287482 0 0 0.48 rio.pg_catalog.pg_statistic 0 0 1.16 rio.public.temp0000287436 0 0 0.36 template1.pg_catalog.pg_shdepend 0 0 0.22 rio.public.temp0000287312 0 0 0.03 rio.public.temp0000287472 0 0 0.37 rio.public.temp0000287306 0 0 0.06 rio.auditor.auditor_2026_08 0 0 16.8 contagem.public.temp0000226760 0 0 0.08 brasilia.pg_catalog.pg_class 0 0 0.4 brasilia.pg_catalog.pg_type 0 0 0.27 rio.pg_toast.pg_toast_2619 0 0 0.13 rio.public.temp0000287484 0 0 0.2 rio.public.temp0000287440 0 0 0.07 rio.public.temp0000287406 0 0 0.05 rio.public.temp0000287492 0 0 0.06 contagem.auditor.auditor_2026_08 0 0 3.69 brasilia.pg_catalog.pg_index 0 0 0.13 postgres.pg_catalog.pg_shdepend 0 0 0.29 rio.public.temp0000287304 0 0 0.03 brasilia.auditor.auditor_2026_08 0 0 2.94 brasilia.pg_catalog.pg_shdepend 0 0 0.12 rio.public.temp0000287426 0 0 0.13 brasilia.pg_toast.pg_toast_2619 0 0 0.04 brasilia.pg_catalog.pg_depend 0 0 0.34 rio.public.temp0000287454 0 0 0.02 rio.public.temp0000287446 0 0 0.1 rio.public.temp0000287470 0 0 0.1 brasilia.pg_catalog.pg_statistic 0 0 0.31 brasilia.public.temp0000237472 0 0 0.05 contagem.pg_catalog.pg_statistic 0 0 0.04 contagem.public.temp0000226748 0 0 0.02 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000287448 0 0 0 rio.pg_toast.pg_toast_365051 0 0 0.29 rio.public.temp0000287480 0 0 0 rio.public.temp0000287394 0 0 0.05 rio.public.temp0000287466 0 0 0 brasilia.public.temp0000237424 0 0 0.02 rio.public.temp0000287462 0 0 0 rio.public.temp0000287456 0 0 0.02 rio.public.temp0000287486 0 0 0.05 brasilia.public.temp0000237458 0 0 0.02 brasilia.public.temp0000237462 0 0 0.03 Total 0 0 43.02 Tuples removed per table
Key values
- pg_catalog.pg_attribute (159254) Main table with removed tuples on database contagem
- 510232 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain contagem.pg_catalog.pg_attribute 20 20 159,254 475,045 0 836 14,003 rio.pg_catalog.pg_attribute 47 39 155,037 1,232,706 104,099 647 28,667 brasilia.pg_catalog.pg_attribute 14 14 52,646 319,646 0 205 8,539 contagem.pg_catalog.pg_depend 10 10 30,724 186,893 0 79 2,047 contagem.auditor.auditor_2026_08 3 1 12,138 871,624 0 0 41,660 rio.pg_catalog.pg_statistic 7 7 12,005 57,839 87 0 9,002 contagem.pg_catalog.pg_type 10 10 11,112 24,543 0 107 1,057 rio.pg_catalog.pg_depend 11 11 10,092 216,143 5,848 0 2,035 template1.pg_catalog.pg_shdepend 7 7 7,696 95,383 211 0 833 rio.pg_catalog.pg_type 28 20 7,230 73,090 8,742 13 2,061 contagem.pg_catalog.pg_index 10 10 6,452 18,985 0 36 688 brasilia.pg_catalog.pg_depend 2 2 5,954 34,355 0 0 390 contagem.pg_catalog.pg_class 12 12 5,154 48,566 0 200 2,540 brasilia.pg_catalog.pg_statistic 2 2 4,856 15,475 63 0 2,144 contagem.pg_catalog.pg_statistic 1 1 4,171 7,274 0 0 1,011 brasilia.pg_catalog.pg_class 5 5 3,460 20,805 0 22 700 rio.pg_catalog.pg_class 33 21 3,202 145,240 26,010 51 4,451 brasilia.pg_catalog.pg_shdepend 3 3 2,886 40,794 17 0 357 rio.pg_catalog.pg_index 19 14 2,815 40,117 3,564 10 1,053 postgres.pg_catalog.pg_shdepend 3 3 2,575 40,646 2 0 357 brasilia.auditor.auditor_2026_08 3 0 2,050 1,049,522 0 0 46,648 rio.auditor.auditor_2026_08 5 0 2,030 7,520,306 0 0 360,216 brasilia.pg_catalog.pg_type 5 5 1,946 11,053 0 9 400 contagem.public.usuarios 30 0 1,835 720 0 0 60 rio.pg_toast.pg_toast_2619 4 4 1,207 2,263 8 0 1,140 brasilia.pg_catalog.pg_index 3 3 979 5,631 0 7 177 rio.public.usuarios 16 6 350 10,697 2,553 0 256 brasilia.pg_toast.pg_toast_2619 2 2 244 277 0 0 146 contagem.pg_toast.pg_toast_2619 1 1 132 113 0 0 58 rio.public.temp0000287398 13 0 0 184,176 0 85 12,459 rio.public.temp0000287492 3 0 0 21,349 0 99 477 contagem.public.temp0000226748 1 0 0 1,295 0 29 99 rio.public.temp0000287304 3 0 0 10,069 0 97 223 rio.public.temp0000287312 6 0 0 29,771 0 88 680 rio.public.temp0000287436 7 0 0 167,966 0 0 12,096 rio.public.temp0000287448 1 0 0 1,056 0 0 64 rio.pg_toast.pg_toast_365051 1 0 0 172,536 0 0 38,431 rio.public.temp0000287480 1 0 0 1,131 0 0 64 rio.public.temp0000287394 1 0 0 24,016 0 0 1,728 rio.public.temp0000287484 4 0 0 96,059 0 0 6,912 rio.public.temp0000287440 4 0 0 18,054 0 112 400 contagem.public.temp0000226760 5 0 0 6,487 0 140 500 rio.public.temp0000287454 2 0 0 12,224 0 49 271 rio.public.temp0000287388 12 0 0 58,637 0 358 1,306 rio.public.temp0000287472 6 0 0 144,016 0 0 10,368 rio.public.temp0000287446 2 0 0 47,991 0 0 3,456 rio.public.temp0000287466 1 0 0 1,056 0 0 64 rio.public.temp0000287470 2 0 0 48,000 0 0 3,456 rio.public.temp0000287372 15 0 0 359,447 0 0 25,920 brasilia.public.temp0000237424 1 0 0 3,170 0 18 238 rio.public.temp0000287450 23 0 0 438,485 0 290 31,454 rio.public.temp0000287462 1 0 0 1,056 0 0 64 rio.public.temp0000287426 3 0 0 71,971 0 0 5,184 rio.public.temp0000287456 1 0 0 6,328 0 51 141 rio.public.temp0000287306 6 0 0 19,110 0 81 431 rio.public.temp0000287482 9 0 0 216,089 0 0 15,552 rio.public.temp0000287406 4 0 0 21,498 0 97 479 rio.public.temp0000287486 1 0 0 24,007 0 0 1,728 brasilia.public.temp0000237458 1 0 0 3,172 0 18 238 brasilia.public.temp0000237462 1 0 0 3,172 0 18 238 brasilia.public.temp0000237472 2 0 0 6,344 0 36 476 Total 459 233 510,232 14,785,489 151,204 3,888 707,893 Pages removed per table
Key values
- pg_catalog.pg_attribute (836) Main table with removed pages on database contagem
- 3888 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed contagem.pg_catalog.pg_attribute 20 20 159254 836 rio.pg_catalog.pg_attribute 47 39 155037 647 rio.public.temp0000287388 12 0 0 358 rio.public.temp0000287450 23 0 0 290 brasilia.pg_catalog.pg_attribute 14 14 52646 205 contagem.pg_catalog.pg_class 12 12 5154 200 contagem.public.temp0000226760 5 0 0 140 rio.public.temp0000287440 4 0 0 112 contagem.pg_catalog.pg_type 10 10 11112 107 rio.public.temp0000287492 3 0 0 99 rio.public.temp0000287304 3 0 0 97 rio.public.temp0000287406 4 0 0 97 rio.public.temp0000287312 6 0 0 88 rio.public.temp0000287398 13 0 0 85 rio.public.temp0000287306 6 0 0 81 contagem.pg_catalog.pg_depend 10 10 30724 79 rio.pg_catalog.pg_class 33 21 3202 51 rio.public.temp0000287456 1 0 0 51 rio.public.temp0000287454 2 0 0 49 contagem.pg_catalog.pg_index 10 10 6452 36 brasilia.public.temp0000237472 2 0 0 36 contagem.public.temp0000226748 1 0 0 29 brasilia.pg_catalog.pg_class 5 5 3460 22 brasilia.public.temp0000237424 1 0 0 18 brasilia.public.temp0000237458 1 0 0 18 brasilia.public.temp0000237462 1 0 0 18 rio.pg_catalog.pg_type 28 20 7230 13 rio.pg_catalog.pg_index 19 14 2815 10 brasilia.pg_catalog.pg_type 5 5 1946 9 brasilia.pg_catalog.pg_index 3 3 979 7 contagem.pg_catalog.pg_statistic 1 1 4171 0 contagem.auditor.auditor_2026_08 3 1 12138 0 rio.auditor.auditor_2026_08 5 0 2030 0 brasilia.pg_toast.pg_toast_2619 2 2 244 0 brasilia.pg_catalog.pg_depend 2 2 5954 0 rio.pg_catalog.pg_depend 11 11 10092 0 postgres.pg_catalog.pg_shdepend 3 3 2575 0 contagem.public.usuarios 30 0 1835 0 contagem.pg_toast.pg_toast_2619 1 1 132 0 rio.pg_toast.pg_toast_2619 4 4 1207 0 rio.pg_catalog.pg_statistic 7 7 12005 0 brasilia.auditor.auditor_2026_08 3 0 2050 0 rio.public.temp0000287436 7 0 0 0 rio.public.temp0000287448 1 0 0 0 rio.pg_toast.pg_toast_365051 1 0 0 0 rio.public.temp0000287480 1 0 0 0 brasilia.pg_catalog.pg_shdepend 3 3 2886 0 rio.public.temp0000287394 1 0 0 0 rio.public.temp0000287484 4 0 0 0 rio.public.temp0000287472 6 0 0 0 rio.public.usuarios 16 6 350 0 rio.public.temp0000287446 2 0 0 0 rio.public.temp0000287466 1 0 0 0 rio.public.temp0000287470 2 0 0 0 rio.public.temp0000287372 15 0 0 0 rio.public.temp0000287462 1 0 0 0 rio.public.temp0000287426 3 0 0 0 rio.public.temp0000287482 9 0 0 0 rio.public.temp0000287486 1 0 0 0 template1.pg_catalog.pg_shdepend 7 7 7696 0 brasilia.pg_catalog.pg_statistic 2 2 4856 0 Total 459 233 510,232 3,888 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 04 00 2 1 01 0 2 02 0 0 03 0 0 04 0 0 05 6 6 06 0 0 07 19 35 08 35 108 09 52 121 10 36 78 11 33 94 12 14 29 13 54 71 14 77 118 15 82 137 16 32 77 17 16 51 18 0 0 19 0 0 20 0 0 21 1 2 22 0 0 23 0 0 - 3.85 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 3 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 3 5m49s 1m30s 2m37s 1m56s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-04 09:57:58 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-04 15:56:56 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-04 09:06:49 Database: rio User: intelifix Remote: [local] Application: psql
Queries that waited the most
Rank Wait time Query 1 2m37s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-04 09:57:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1m41s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-04 15:56:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 1m30s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-04 09:06:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Queries
Queries by type
Key values
- 4,304 Total read queries
- 1,494 Total write queries
Queries by database
Key values
- rio Main database
- 4,264 Requests
- 6h16m27s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,149 Requests
User Request type Count Duration etiquetas Total 41 7s983ms select 41 7s983ms intelifix Total 6,149 8h14m31s copy to 417 46m24s ddl 1,077 47m57s others 511 52m37s select 4,144 5h47m31s lenon Total 119 1m4s select 119 1m4s Duration by user
Key values
- 8h14m31s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 41 7s983ms select 41 7s983ms intelifix Total 6,149 8h14m31s copy to 417 46m24s ddl 1,077 47m57s others 511 52m37s select 4,144 5h47m31s lenon Total 119 1m4s select 119 1m4s Queries by host
Key values
- [local] Main host
- 6,309 Requests
- 8h15m43s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,138 Requests
- 4h19m1s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-04 15:25:40 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,868 100-500ms duration
Slowest individual queries
Rank Duration Query 1 11m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-04 09:16:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 11m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-04 07:16:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 10m3s analyze verbose;[ Date: 2026-08-04 05:10:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-04 15:13:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-04 10:13:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-04 16:13:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 7m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-04 12:12:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 7m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-04 17:12:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 7m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-04 21:12:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 6m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-04 11:11:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m46s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027947, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-04 07:19:59 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 6m36s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027984, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-04 09:57:57 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 6m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-04 14:11:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m7s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028006, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-04 15:03:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 5m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-04 20:11:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m54s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027994, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-04 12:11:04 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-04 08:10:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-04 18:10:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-04 13:10:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-04 19:10:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h3m35s 48 1s418ms 11m20s 2m34s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 04 07 3 12m4s 4m1s 08 3 6m5s 2m1s 09 3 12m15s 4m5s 10 3 8m49s 2m56s 11 3 7m22s 2m27s 12 3 7m48s 2m36s 13 3 5m55s 1m58s 14 3 6m54s 2m18s 15 3 9m 3m 16 3 8m41s 2m53s 17 3 7m26s 2m28s 18 3 5m56s 1m58s 19 3 5m53s 1m57s 20 3 6m20s 2m6s 21 3 7m17s 2m25s 22 3 5m41s 1m53s [ User: intelifix - Total duration: 2h3m35s - Times executed: 48 ]
[ Application: psql - Total duration: 2h3m35s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-04 09:16:22 Duration: 11m20s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-04 07:16:20 Duration: 11m19s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-04 15:13:27 Duration: 8m25s Database: rio User: intelifix Remote: [local] Application: psql
2 1h31m49s 284 151ms 6m46s 19s398ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 04 07 5 7m3s 1m24s 08 23 20m44s 54s115ms 09 19 12m30s 39s506ms 10 18 6m48s 22s712ms 11 40 4m7s 6s179ms 12 24 10m58s 27s447ms 13 36 1m3s 1s775ms 14 26 1m22s 3s155ms 15 36 23m33s 39s274ms 16 44 3m24s 4s636ms 17 12 9s964ms 830ms 18 1 1s796ms 1s796ms [ User: intelifix - Total duration: 1h31m49s - Times executed: 284 ]
[ Application: [unknown] - Total duration: 1h31m49s - Times executed: 284 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027947, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-04 07:19:59 Duration: 6m46s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027984, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-04 09:57:57 Duration: 6m36s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028006, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-04 15:03:48 Duration: 6m7s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h15m54s 48 226ms 4m54s 1m34s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 04 07 3 5m42s 1m54s 08 3 4m27s 1m29s 09 3 6m36s 2m12s 10 3 4m44s 1m34s 11 3 5m22s 1m47s 12 3 5m7s 1m42s 13 3 4m4s 1m21s 14 3 5m10s 1m43s 15 3 5m10s 1m43s 16 3 4m39s 1m33s 17 3 4m45s 1m35s 18 3 3m45s 1m15s 19 3 3m55s 1m18s 20 3 4m31s 1m30s 21 3 3m50s 1m16s 22 3 3m59s 1m19s [ User: intelifix - Total duration: 1h15m54s - Times executed: 48 ]
[ Application: psql - Total duration: 1h15m54s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-04 09:23:36 Duration: 4m54s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-04 14:17:01 Duration: 4m21s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-04 15:19:04 Duration: 4m15s Database: brasilia User: intelifix Remote: [local] Application: psql
4 27m19s 1,689 150ms 6s757ms 970ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 04 07 16 14s402ms 900ms 08 83 1m34s 1s138ms 09 170 3m5s 1s90ms 10 197 3m12s 977ms 11 201 3m19s 992ms 12 59 58s768ms 996ms 13 138 2m28s 1s79ms 14 252 3m15s 775ms 15 246 4m1s 981ms 16 234 3m42s 952ms 17 93 1m26s 926ms [ User: intelifix - Total duration: 27m19s - Times executed: 1689 ]
[ Application: [unknown] - Total duration: 27m19s - Times executed: 1689 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (50065, 417, '246343077089', '',0172,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":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-04 13:59:46 Duration: 6s757ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (273483, 304, 'CP2327322MB,D4925ED50170,544D4242006DA91D,D4925ED50173$CP2411326UA,08C7F53086F1,544D424200789596,08C7F53086F4$CP240932CBG,08C7F52D174C,544D4242007833D9,08C7F52D174F$CP234232WQ5,D4925EFA105B,544D424200726400,D4925EFA105E$CP23453222L,08C7F5022260,544D424200733AD5,08C7F5022263$CP2303321CQ,D4925E13CA12,544D42420062B913,D4925E13CA15$CP2409328K9,08C7F52C8731,544D4242007823D6,08C7F52C8734$CP240932BG7,08C7F52CF67F,544D424200783034,08C7F52CF682$CP2301323AG,D4925E01E21B,544D424200611E02,D4925E01E21E$CP23173247C,D4925E95000F,544D424200682AB9,D4925E950012$CP2310327R3,D4925E349609,544D42420065D0DB,D4925E34960C$CP230132337,D4925E01D9AB,544D424200611D12,D4925E01D9AE$CP2411322GG,08C7F52FE017,544D42420078830C,08C7F52FE01A$CP232532KEF,D4925ECE7AA7,544D4242006D6605,D4925ECE7AAA$CP240932R9D,08C7F52F0694,544D424200786AE1,08C7F52F0697$CP234232QNS,D4925EF92910,544D424200724A4D,D4925EF92913$CP2301326K0,D4925E025EE0,544D424200612BDF,D4925E025EE3$CP230232RSN,D4925E09FCDA,544D4242006203CF,D4925E09FCDD$CP230232RUJ,D4925E09FF08,544D42420062040D,D4925E09FF0B$CP230232MZG,D4925E096A76,544D42420061F38B,D4925E096A79$CP2301322FF,D4925E01C18D,544D424200611A64,D4925E01C190$CP2325324RV,D4925ECB5F41,544D4242006D27AF,D4925ECB5F44$CP240932KNF,08C7F52E3005,544D42420078530A,08C7F52E3008$CP240932P70,08C7F52EB73B,544D424200786210,08C7F52EB73E$CP234532EY1,08C7F5040EC6,544D42420073718B,08C7F5040EC9$CP24093253J,08C7F52C0217,544D42420078150C,08C7F52C021A$CP2322322EU,D4925EB3335A,544D4242006B962A,D4925EB3335D$CP230232N50,D4925E0970DC,544D42420061F441,D4925E0970DF$CP23223204H,D4925EB2DACB,544D4242006B8C53,D4925EB2DACE$CP23173219C,D4925E948F86,544D424200681E38,D4925E948F89$CP232532P3Q,D4925ECF0759,544D4242006D75A7,D4925ECF075C$CP2322322JL,D4925EB337B6,544D4242006B96A6,D4925EB337B9$CP2327321KQ,D4925ED4D938,544D4242006DA4A5,D4925ED4D93B', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-04 09:07:04 Duration: 6s269ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (273477, 304, '922111017732,64FD965E1666,E8D2FF96B8D7,186A81D52691,C4EB42EADAAD,186A81D3E532,3453D2A83FD4,ACD75BB7E9E6,94988F93E6AD,94988F3066A9,3453D2A8D718,ACD75BB5F703,B0BBE53D2855,44D454C3BF57,D0CF0EFE2D46,D0CF0EFDA9AB,94988F959335,943C9678BADD,ACD75BB5F85A,5CFA259B925A,345D9EB44B5F,ACD75BB5F527,8CFDDE9813BD,D06DC964B51E,B0BBE53DADA9,8CC5B4EDD097,4C195DCC71FA,C03C04864FDF,44D45493948A,4829524633E4,841EA3986D8B,5447CC4945F9,582FF79C9644,8CC5B4EDA60B,345D9EBD7C40,5CFA25159BE2', '',0155,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-04 13:50:09 Duration: 5s982ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 17m36s 3 2m45s 10m3s 5m52s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 04 05 3 17m36s 5m52s [ User: intelifix - Total duration: 17m36s - Times executed: 3 ]
[ Application: psql - Total duration: 17m36s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-04 05:10:05 Duration: 10m3s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-04 05:14:52 Duration: 4m47s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-04 05:17:38 Duration: 2m45s Database: contagem User: intelifix Remote: [local] Application: psql
6 15m43s 277 166ms 2m41s 3s407ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 04 00 12 40s548ms 3s379ms 01 12 23s139ms 1s928ms 02 12 24s553ms 2s46ms 03 13 21s990ms 1s691ms 04 12 22s363ms 1s863ms 05 12 26s727ms 2s227ms 06 12 22s630ms 1s885ms 07 12 23s895ms 1s991ms 08 12 28s182ms 2s348ms 09 12 4m36s 23s22ms 10 12 23s637ms 1s969ms 11 12 22s996ms 1s916ms 12 12 20s900ms 1s741ms 13 12 24s984ms 2s82ms 14 12 24s628ms 2s52ms 15 12 2m7s 10s633ms 16 12 25s461ms 2s121ms 17 12 26s455ms 2s204ms 18 12 24s612ms 2s51ms 19 12 23s654ms 1s971ms 20 12 41s358ms 3s446ms 21 12 24s316ms 2s26ms 22 12 23s42ms 1s920ms [ User: intelifix - Total duration: 15m43s - Times executed: 277 ]
[ Application: psql - Total duration: 15m43s - Times executed: 277 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-04 09:57:58 Duration: 2m41s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-04 15:56:56 Duration: 1m45s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-04 09:06:49 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: psql
7 12m40s 168 153ms 20s990ms 4s527ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 04 00 6 32s362ms 5s393ms 01 6 15s640ms 2s606ms 02 6 12s901ms 2s150ms 03 5 14s984ms 2s996ms 04 6 13s486ms 2s247ms 05 6 23s942ms 3s990ms 07 9 43s136ms 4s792ms 08 12 1m16s 6s376ms 09 12 1m24s 7s62ms 10 12 1m11s 5s991ms 11 12 1m22s 6s863ms 12 12 1m9s 5s796ms 13 10 15s298ms 1s529ms 14 12 49s549ms 4s129ms 15 12 1m7s 5s613ms 16 11 41s142ms 3s740ms 17 6 12s36ms 2s6ms 18 1 1s454ms 1s454ms 20 1 153ms 153ms 21 6 15s922ms 2s653ms 22 5 16s232ms 3s246ms [ User: intelifix - Total duration: 12m40s - Times executed: 168 ]
[ Application: psql - Total duration: 12m40s - Times executed: 168 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-04 00:05:22 Duration: 20s990ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-04 12:15:19 Duration: 18s37ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-04 09:55:16 Duration: 15s529ms Database: rio User: intelifix Remote: [local] Application: psql
8 11m24s 880 150ms 5s420ms 777ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 04 08 108 2m13s 1s238ms 09 160 1m59s 747ms 10 126 1m27s 691ms 11 129 1m34s 733ms 12 12 10s157ms 846ms 13 61 41s964ms 687ms 14 102 1m15s 743ms 15 119 1m17s 649ms 16 32 25s182ms 786ms 17 31 19s78ms 615ms [ User: intelifix - Total duration: 11m24s - Times executed: 880 ]
[ Application: [unknown] - Total duration: 11m24s - Times executed: 880 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "273705", "modelo" : "320", "itens" : "241693054250,241703767394,241732095961,241709338689,241711191823,241609890523,241710328292,241680420515,241677667585,241614548888,241695635467,241614836975,241619698493,241666959111,241703947187,230048964262,241617485876,241646622435,241672841223,241688914048,241689019816,241597822431,241670266066,241674552748,241646662843,241704298489,241647240004,241703924357,241730927979,241691087391,241608701226,241728680612,241710593953,241649265880,241616302439,241713748087,230049085766,241653916771,241672347986,241660082323,241706879202,241694161115,241704291419,241603098590,241673155675,241699214447,241651919506,241708782441", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-04 08:05:13 Duration: 5s420ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "273707", "modelo" : "464", "itens" : "241738911128,241771320318,241766283653,241760821010,241763767492,241743926981,241762280008,241762109104,241748097085,241740011931,241769631320,241766279713,241768314356,241764781116,241768405173,241760182328,241812710620,241742696569,241767648297,241746192130,241773838598,241777656973,241745563651,241743698799,241770772834,241770941818,241763386164,241738837584,241765426464,241768088497,241765413456,241778591420,241738898803,241739670910,241739017680,241739857695,241759752028,241762284351,241773646582,241768366886,241740072341,241743841418,241742247681,241759819307,241744041415,241738013958,241739973442,241738976868,241773872138,241766947791,241761162132,241775608591,241767997074,241764800714,241779234142,241761185568,241747381528,241746772142,241776668404,241747222646", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-04 08:11:34 Duration: 3s655ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "273704", "modelo" : "464", "itens" : "241740605456,241764593645,241745446063,241770167993,241770747477,241762529201,241776519904,241744346068,241776516267,241766936679,241747670827,241761218298,241774188587,241748065769,241741192136,241772276987,241741215067,241748077487,241759738894,241762439191,241744734748,241739979199,241743781940,241767103845,241743361517,241762470105,241767060003,241738682441,241771146282,241775536991,241769940722,241778451328,241738523637,241759732127,241764524345,241762692932,241744293235,241764416276,241740570123,241772676880,241770715959,241769532747,241744674260,241744602940,241741068587,241759896587,241773556169,241745291728,241745211114,241739126782,241765474550,241738546669,241779181332,241768754455,241778862333,241761171830,241760828181,241742801126,241762521524,241778182637", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-04 08:01:53 Duration: 3s342ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 8m26s 45 9s554ms 13s891ms 11s261ms create table temp0000287450 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 04 12 12 2m6s 10s548ms 14 13 2m26s 11s263ms 15 17 3m16s 11s581ms 16 3 36s882ms 12s294ms [ User: intelifix - Total duration: 8m26s - Times executed: 45 ]
[ Application: [unknown] - Total duration: 8m26s - Times executed: 45 ]
-
CREATE TABLE temp0000287450 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 15:51:34 Duration: 13s891ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287450 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 15:51:08 Duration: 13s813ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287450 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 16:02:29 Duration: 12s839ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 8m16s 39 9s922ms 1m 12s738ms create table temp0000287372 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 04 07 11 2m48s 15s345ms 08 16 3m4s 11s512ms 09 6 1m20s 13s457ms 10 6 1m3s 10s513ms [ User: intelifix - Total duration: 8m16s - Times executed: 39 ]
[ Application: [unknown] - Total duration: 8m16s - Times executed: 39 ]
-
CREATE TABLE temp0000287372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 07:09:03 Duration: 1m Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 09:00:51 Duration: 16s783ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 09:00:27 Duration: 16s270ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 6m56s 36 9s788ms 13s121ms 11s575ms create table temp0000287398 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 04 09 36 6m56s 11s575ms [ User: intelifix - Total duration: 6m56s - Times executed: 36 ]
[ Application: [unknown] - Total duration: 6m56s - Times executed: 36 ]
-
CREATE TABLE temp0000287398 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 09:35:03 Duration: 13s121ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287398 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 09:26:34 Duration: 12s984ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287398 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 09:35:24 Duration: 12s823ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 4m31s 80 1s328ms 10s930ms 3s391ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 04 08 6 24s435ms 4s72ms 09 6 24s322ms 4s53ms 10 3 17s493ms 5s831ms 11 5 20s554ms 4s110ms 13 5 14s971ms 2s994ms 14 8 25s863ms 3s232ms 15 5 32s629ms 6s525ms 16 9 36s64ms 4s7ms 17 33 1m15s 2s273ms [ User: intelifix - Total duration: 4m31s - Times executed: 80 ]
[ Application: [unknown] - Total duration: 4m31s - Times executed: 80 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-04', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-04 08:25:18 Duration: 10s930ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-04', 0302, '', '', 0, 6, '2026-08-04');
Date: 2026-08-04 14:18:38 Duration: 8s994ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-04', 0395, '', '', 0, 6, '2026-08-01');
Date: 2026-08-04 15:10:21 Duration: 7s976ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 3m18s 4 4s756ms 1m41s 49s692ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 04 20 2 1m46s 53s101ms 23 2 1m32s 46s282ms [ User: intelifix - Total duration: 3m18s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m18s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-04 20:09:25 Duration: 1m41s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-04 23:16:37 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-04 20:11:20 Duration: 5s185ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 3m3s 16 10s16ms 13s484ms 11s456ms create table temp0000287482 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 04 14 3 36s805ms 12s268ms 15 10 1m54s 11s409ms 16 3 32s406ms 10s802ms [ User: intelifix - Total duration: 3m3s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 3m3s - Times executed: 16 ]
-
CREATE TABLE temp0000287482 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 15:08:37 Duration: 13s484ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287482 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 14:56:57 Duration: 12s765ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287482 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 15:14:24 Duration: 12s123ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 2m49s 77 208ms 51s397ms 2s205ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 04 07 4 3s619ms 904ms 08 6 3s921ms 653ms 09 29 7s600ms 262ms 10 4 11s899ms 2s974ms 11 4 48s281ms 12s70ms 12 4 1s755ms 438ms 13 2 2s935ms 1s467ms 14 8 20s275ms 2s534ms 15 11 1m 5s529ms 16 5 8s681ms 1s736ms [ User: intelifix - Total duration: 2m49s - Times executed: 77 ]
[ Application: psql - Total duration: 2m49s - Times executed: 77 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028008);
Date: 2026-08-04 15:09:15 Duration: 51s397ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027991);
Date: 2026-08-04 11:37:15 Duration: 36s402ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028001);
Date: 2026-08-04 14:45:04 Duration: 10s244ms Database: rio User: intelifix Remote: [local] Application: psql
16 2m48s 39 284ms 29s908ms 4s307ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 04 07 3 33s737ms 11s245ms 08 5 13s147ms 2s629ms 09 9 36s62ms 4s6ms 10 3 2s832ms 944ms 11 4 12s312ms 3s78ms 12 2 27s703ms 13s851ms 13 1 2s407ms 2s407ms 14 6 23s967ms 3s994ms 15 5 13s894ms 2s778ms 16 1 1s944ms 1s944ms [ User: intelifix - Total duration: 2m48s - Times executed: 39 ]
[ Application: psql - Total duration: 2m48s - Times executed: 39 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027947);
Date: 2026-08-04 07:12:45 Duration: 29s908ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027994);
Date: 2026-08-04 12:05:07 Duration: 25s692ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028006);
Date: 2026-08-04 14:57:26 Duration: 13s703ms Database: rio User: intelifix Remote: [local] Application: psql
17 2m28s 13 10s514ms 12s249ms 11s388ms create table temp0000287436 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 04 10 3 33s754ms 11s251ms 11 9 1m42s 11s401ms 12 1 11s681ms 11s681ms [ User: intelifix - Total duration: 2m28s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m28s - Times executed: 13 ]
-
CREATE TABLE temp0000287436 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 10:58:03 Duration: 12s249ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287436 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 11:39:16 Duration: 12s84ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287436 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 11:37:18 Duration: 11s764ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 2m3s 11 9s239ms 12s753ms 11s239ms create table temp0000287484 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 04 16 11 2m3s 11s239ms [ User: intelifix - Total duration: 2m3s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 2m3s - Times executed: 11 ]
-
CREATE TABLE temp0000287484 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 16:11:42 Duration: 12s753ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287484 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 16:15:15 Duration: 12s439ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287484 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 16:12:28 Duration: 11s900ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 2m2s 4 421ms 1m4s 30s698ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 04 20 2 1m5s 32s636ms 23 2 57s519ms 28s759ms [ User: intelifix - Total duration: 2m2s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m2s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-04 20:05:48 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-04 23:13:25 Duration: 57s97ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-04 20:10:45 Duration: 426ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 1m43s 29 775ms 12s2ms 3s584ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 04 08 2 14s164ms 7s82ms 10 3 15s449ms 5s149ms 11 2 8s319ms 4s159ms 12 2 2s854ms 1s427ms 13 2 2s542ms 1s271ms 14 2 16s80ms 8s40ms 15 1 5s928ms 5s928ms 16 3 9s952ms 3s317ms 17 2 4s530ms 2s265ms 18 1 1s112ms 1s112ms 19 2 1s786ms 893ms 20 1 775ms 775ms 21 3 10s598ms 3s532ms 22 3 9s864ms 3s288ms [ User: intelifix - Total duration: 1m43s - Times executed: 29 ]
[ Application: psql - Total duration: 1m43s - Times executed: 29 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-04 14:00:13 Duration: 12s2ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-04 08:20:11 Duration: 10s44ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-04 10:20:08 Duration: 7s754ms Database: rio User: intelifix Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,689 27m19s 150ms 6s757ms 970ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 04 07 16 14s402ms 900ms 08 83 1m34s 1s138ms 09 170 3m5s 1s90ms 10 197 3m12s 977ms 11 201 3m19s 992ms 12 59 58s768ms 996ms 13 138 2m28s 1s79ms 14 252 3m15s 775ms 15 246 4m1s 981ms 16 234 3m42s 952ms 17 93 1m26s 926ms [ User: intelifix - Total duration: 27m19s - Times executed: 1689 ]
[ Application: [unknown] - Total duration: 27m19s - Times executed: 1689 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (50065, 417, '246343077089', '',0172,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":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-04 13:59:46 Duration: 6s757ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (273483, 304, 'CP2327322MB,D4925ED50170,544D4242006DA91D,D4925ED50173$CP2411326UA,08C7F53086F1,544D424200789596,08C7F53086F4$CP240932CBG,08C7F52D174C,544D4242007833D9,08C7F52D174F$CP234232WQ5,D4925EFA105B,544D424200726400,D4925EFA105E$CP23453222L,08C7F5022260,544D424200733AD5,08C7F5022263$CP2303321CQ,D4925E13CA12,544D42420062B913,D4925E13CA15$CP2409328K9,08C7F52C8731,544D4242007823D6,08C7F52C8734$CP240932BG7,08C7F52CF67F,544D424200783034,08C7F52CF682$CP2301323AG,D4925E01E21B,544D424200611E02,D4925E01E21E$CP23173247C,D4925E95000F,544D424200682AB9,D4925E950012$CP2310327R3,D4925E349609,544D42420065D0DB,D4925E34960C$CP230132337,D4925E01D9AB,544D424200611D12,D4925E01D9AE$CP2411322GG,08C7F52FE017,544D42420078830C,08C7F52FE01A$CP232532KEF,D4925ECE7AA7,544D4242006D6605,D4925ECE7AAA$CP240932R9D,08C7F52F0694,544D424200786AE1,08C7F52F0697$CP234232QNS,D4925EF92910,544D424200724A4D,D4925EF92913$CP2301326K0,D4925E025EE0,544D424200612BDF,D4925E025EE3$CP230232RSN,D4925E09FCDA,544D4242006203CF,D4925E09FCDD$CP230232RUJ,D4925E09FF08,544D42420062040D,D4925E09FF0B$CP230232MZG,D4925E096A76,544D42420061F38B,D4925E096A79$CP2301322FF,D4925E01C18D,544D424200611A64,D4925E01C190$CP2325324RV,D4925ECB5F41,544D4242006D27AF,D4925ECB5F44$CP240932KNF,08C7F52E3005,544D42420078530A,08C7F52E3008$CP240932P70,08C7F52EB73B,544D424200786210,08C7F52EB73E$CP234532EY1,08C7F5040EC6,544D42420073718B,08C7F5040EC9$CP24093253J,08C7F52C0217,544D42420078150C,08C7F52C021A$CP2322322EU,D4925EB3335A,544D4242006B962A,D4925EB3335D$CP230232N50,D4925E0970DC,544D42420061F441,D4925E0970DF$CP23223204H,D4925EB2DACB,544D4242006B8C53,D4925EB2DACE$CP23173219C,D4925E948F86,544D424200681E38,D4925E948F89$CP232532P3Q,D4925ECF0759,544D4242006D75A7,D4925ECF075C$CP2322322JL,D4925EB337B6,544D4242006B96A6,D4925EB337B9$CP2327321KQ,D4925ED4D938,544D4242006DA4A5,D4925ED4D93B', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-04 09:07:04 Duration: 6s269ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (273477, 304, '922111017732,64FD965E1666,E8D2FF96B8D7,186A81D52691,C4EB42EADAAD,186A81D3E532,3453D2A83FD4,ACD75BB7E9E6,94988F93E6AD,94988F3066A9,3453D2A8D718,ACD75BB5F703,B0BBE53D2855,44D454C3BF57,D0CF0EFE2D46,D0CF0EFDA9AB,94988F959335,943C9678BADD,ACD75BB5F85A,5CFA259B925A,345D9EB44B5F,ACD75BB5F527,8CFDDE9813BD,D06DC964B51E,B0BBE53DADA9,8CC5B4EDD097,4C195DCC71FA,C03C04864FDF,44D45493948A,4829524633E4,841EA3986D8B,5447CC4945F9,582FF79C9644,8CC5B4EDA60B,345D9EBD7C40,5CFA25159BE2', '',0155,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-04 13:50:09 Duration: 5s982ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 880 11m24s 150ms 5s420ms 777ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 04 08 108 2m13s 1s238ms 09 160 1m59s 747ms 10 126 1m27s 691ms 11 129 1m34s 733ms 12 12 10s157ms 846ms 13 61 41s964ms 687ms 14 102 1m15s 743ms 15 119 1m17s 649ms 16 32 25s182ms 786ms 17 31 19s78ms 615ms [ User: intelifix - Total duration: 11m24s - Times executed: 880 ]
[ Application: [unknown] - Total duration: 11m24s - Times executed: 880 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "273705", "modelo" : "320", "itens" : "241693054250,241703767394,241732095961,241709338689,241711191823,241609890523,241710328292,241680420515,241677667585,241614548888,241695635467,241614836975,241619698493,241666959111,241703947187,230048964262,241617485876,241646622435,241672841223,241688914048,241689019816,241597822431,241670266066,241674552748,241646662843,241704298489,241647240004,241703924357,241730927979,241691087391,241608701226,241728680612,241710593953,241649265880,241616302439,241713748087,230049085766,241653916771,241672347986,241660082323,241706879202,241694161115,241704291419,241603098590,241673155675,241699214447,241651919506,241708782441", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-04 08:05:13 Duration: 5s420ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "273707", "modelo" : "464", "itens" : "241738911128,241771320318,241766283653,241760821010,241763767492,241743926981,241762280008,241762109104,241748097085,241740011931,241769631320,241766279713,241768314356,241764781116,241768405173,241760182328,241812710620,241742696569,241767648297,241746192130,241773838598,241777656973,241745563651,241743698799,241770772834,241770941818,241763386164,241738837584,241765426464,241768088497,241765413456,241778591420,241738898803,241739670910,241739017680,241739857695,241759752028,241762284351,241773646582,241768366886,241740072341,241743841418,241742247681,241759819307,241744041415,241738013958,241739973442,241738976868,241773872138,241766947791,241761162132,241775608591,241767997074,241764800714,241779234142,241761185568,241747381528,241746772142,241776668404,241747222646", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-04 08:11:34 Duration: 3s655ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "273704", "modelo" : "464", "itens" : "241740605456,241764593645,241745446063,241770167993,241770747477,241762529201,241776519904,241744346068,241776516267,241766936679,241747670827,241761218298,241774188587,241748065769,241741192136,241772276987,241741215067,241748077487,241759738894,241762439191,241744734748,241739979199,241743781940,241767103845,241743361517,241762470105,241767060003,241738682441,241771146282,241775536991,241769940722,241778451328,241738523637,241759732127,241764524345,241762692932,241744293235,241764416276,241740570123,241772676880,241770715959,241769532747,241744674260,241744602940,241741068587,241759896587,241773556169,241745291728,241745211114,241739126782,241765474550,241738546669,241779181332,241768754455,241778862333,241761171830,241760828181,241742801126,241762521524,241778182637", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-04 08:01:53 Duration: 3s342ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 284 1h31m49s 151ms 6m46s 19s398ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 04 07 5 7m3s 1m24s 08 23 20m44s 54s115ms 09 19 12m30s 39s506ms 10 18 6m48s 22s712ms 11 40 4m7s 6s179ms 12 24 10m58s 27s447ms 13 36 1m3s 1s775ms 14 26 1m22s 3s155ms 15 36 23m33s 39s274ms 16 44 3m24s 4s636ms 17 12 9s964ms 830ms 18 1 1s796ms 1s796ms [ User: intelifix - Total duration: 1h31m49s - Times executed: 284 ]
[ Application: [unknown] - Total duration: 1h31m49s - Times executed: 284 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027947, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-04 07:19:59 Duration: 6m46s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027984, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-04 09:57:57 Duration: 6m36s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028006, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-04 15:03:48 Duration: 6m7s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 277 15m43s 166ms 2m41s 3s407ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 04 00 12 40s548ms 3s379ms 01 12 23s139ms 1s928ms 02 12 24s553ms 2s46ms 03 13 21s990ms 1s691ms 04 12 22s363ms 1s863ms 05 12 26s727ms 2s227ms 06 12 22s630ms 1s885ms 07 12 23s895ms 1s991ms 08 12 28s182ms 2s348ms 09 12 4m36s 23s22ms 10 12 23s637ms 1s969ms 11 12 22s996ms 1s916ms 12 12 20s900ms 1s741ms 13 12 24s984ms 2s82ms 14 12 24s628ms 2s52ms 15 12 2m7s 10s633ms 16 12 25s461ms 2s121ms 17 12 26s455ms 2s204ms 18 12 24s612ms 2s51ms 19 12 23s654ms 1s971ms 20 12 41s358ms 3s446ms 21 12 24s316ms 2s26ms 22 12 23s42ms 1s920ms [ User: intelifix - Total duration: 15m43s - Times executed: 277 ]
[ Application: psql - Total duration: 15m43s - Times executed: 277 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-04 09:57:58 Duration: 2m41s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-04 15:56:56 Duration: 1m45s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-04 09:06:49 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: psql
5 200 52s20ms 150ms 984ms 260ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 04 01 12 2s726ms 227ms 04 4 1s429ms 357ms 05 23 5s571ms 242ms 07 23 6s829ms 296ms 08 20 4s513ms 225ms 09 29 8s232ms 283ms 10 15 4s10ms 267ms 11 18 5s115ms 284ms 12 12 3s279ms 273ms 13 1 214ms 214ms 14 7 1s706ms 243ms 15 29 6s959ms 239ms 16 6 1s231ms 205ms 17 1 197ms 197ms [ User: intelifix - Total duration: 52s20ms - Times executed: 200 ]
[ Application: [unknown] - Total duration: 52s20ms - Times executed: 200 ]
-
SELECT * FROM RS_TRIAGEM (430, 5, '138', 6, '9877E70AC4D8,8401129325F6,9877E70ACBB5,840112BCCEE3,743AEFDCC263,9877E77CDE6A,9877E77E371C,9877E70B2E1E,9877E77CACD7,9877E7B92C9E,840112C246AB,743AEF7415E5,743AEFDB5FCB,840112C20D2A,9877E7496E46,1834AF257EB5,743AEFD97425,9877E7BE3C9A,840112E01874,743AEF758622,9877E7067F50,8401122AC7C1,743AEF33D957,9877E70AD149,9877E70AC1B3,743AEF141F7A,840112ECBE0D,743AEFC4D5EA,743AEF751BF5,9877E74BA2FA,1834AF24B17E,9877E749B901,743AEF30CF07,840112DA7953,743AEF95E227,9877E7BD869A,9877E70765A8,743AEF743144,840112DD7771,743AEF95CA33,840112C248E2,1834AF999EAD,743AEFC5A6E7,9877E77C3FD2,9877E749AD9A,84011205473E,84011238C9B6,8401125FF33C,9877E70C1890,1834AF256D6D,743AEF5C8E14,743AEF751684,8401125F93B9,84011228DA48,9877E7B94786,743AEF757E2D,743AEFC4D588,8401128027B3,743AEF9638C7,1834AF25907B,8401123832C6', NULL, NULL, 0153, 00);
Date: 2026-08-04 09:12:33 Duration: 984ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (403, 5, '113', 3, '241773871431,241812723045,241813963536,241770156982,241767063235,241813744143,241778973354,241774006067,241773710809,241765465761,241772665869,241760238797,241745207880,241772629300,241738601625', NULL, NULL, 0464, 00);
Date: 2026-08-04 07:08:14 Duration: 565ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '229881056180,229700005166,229710945358,229834562541,229703689914,229823904452,229675445878,229767384054,229699450006,229774549209,229711339718,229793448809', NULL, NULL, 0137, 00);
Date: 2026-08-04 07:14:22 Duration: 538ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 168 12m40s 153ms 20s990ms 4s527ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 04 00 6 32s362ms 5s393ms 01 6 15s640ms 2s606ms 02 6 12s901ms 2s150ms 03 5 14s984ms 2s996ms 04 6 13s486ms 2s247ms 05 6 23s942ms 3s990ms 07 9 43s136ms 4s792ms 08 12 1m16s 6s376ms 09 12 1m24s 7s62ms 10 12 1m11s 5s991ms 11 12 1m22s 6s863ms 12 12 1m9s 5s796ms 13 10 15s298ms 1s529ms 14 12 49s549ms 4s129ms 15 12 1m7s 5s613ms 16 11 41s142ms 3s740ms 17 6 12s36ms 2s6ms 18 1 1s454ms 1s454ms 20 1 153ms 153ms 21 6 15s922ms 2s653ms 22 5 16s232ms 3s246ms [ User: intelifix - Total duration: 12m40s - Times executed: 168 ]
[ Application: psql - Total duration: 12m40s - Times executed: 168 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-04 00:05:22 Duration: 20s990ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-04 12:15:19 Duration: 18s37ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-04 09:55:16 Duration: 15s529ms Database: rio User: intelifix Remote: [local] Application: psql
7 113 49s722ms 275ms 745ms 440ms 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 #7
Day Hour Count Duration Avg duration Aug 04 01 2 894ms 447ms 04 1 387ms 387ms 05 3 1s314ms 438ms 06 1 337ms 337ms 07 10 4s98ms 409ms 08 11 4s649ms 422ms 09 12 5s889ms 490ms 10 11 4s782ms 434ms 11 9 4s60ms 451ms 12 5 2s223ms 444ms 13 10 3s994ms 399ms 14 10 4s422ms 442ms 15 8 3s653ms 456ms 16 8 3s339ms 417ms 17 6 3s242ms 540ms 18 1 502ms 502ms 20 1 489ms 489ms 21 2 728ms 364ms 22 1 335ms 335ms 23 1 375ms 375ms [ User: lenon - Total duration: 49s722ms - Times executed: 113 ]
[ Application: [unknown] - Total duration: 49s722ms - Times executed: 113 ]
-
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-04 11:40:05 Duration: 745ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-04 17:38:48 Duration: 690ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-04 15:58:19 Duration: 672ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
8 101 33s342ms 150ms 1s394ms 330ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 04 08 13 3s875ms 298ms 09 18 6s683ms 371ms 10 24 7s259ms 302ms 11 11 3s400ms 309ms 12 5 1s483ms 296ms 13 4 1s847ms 461ms 14 5 1s812ms 362ms 15 14 5s104ms 364ms 16 2 414ms 207ms 17 5 1s460ms 292ms [ User: intelifix - Total duration: 33s342ms - Times executed: 101 ]
[ Application: [unknown] - Total duration: 33s342ms - Times executed: 101 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '84011205473E,9877E77C3FD2,8401125F93B9,743AEF7415E5,743AEF751BF5,1834AF24B17E,9877E74BA2FA,9877E749B901,84011228DA48,840112ECBE0D,9877E70AD149,9877E7BE3C9A,840112E01874,840112C20D2A,840112DA7953,743AEFD97425,1834AF257EB5,743AEF758622,840112DD7771,743AEF743144,743AEFC5A6E7,743AEF95CA33,9877E749AD9A,840112C248E2,743AEF751684,743AEF95E227,743AEF141F7A,9877E7BD869A,9877E7067F50,743AEF30CF07,9877E70765A8,9877E7B92C9E,9877E70B2E1E,743AEFDB5FCB,840112C246AB,743AEFC4D5EA,9877E77CACD7', '77;1', 'DEFAULT', 09, 0153, '','', '', 00);
Date: 2026-08-04 15:48:15 Duration: 1s394ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '54A65C120055,14B7F8DF81F0,54A65C913E81,B42A0ED36A15,B42A0E9A88C1,905851AB51A7,90585147F1D6,10C25A13CB42,10C25A1109E6,54A65C8C96CF,5C769591E400,54A65C1061AA,1062D0C8AF7F,603D265CF95E,D4B92F29D5FB,D4B92F2EE76A,70037E9C10DD,5C7695943BA6,1062D09C3343,54A65C8D0B59,905851417627,5C769592A663,80D04AB7EBD0,383FB3A68E5A,383FB3A766FF,1062D09AC0B3,A456CCE3AF15,383FB3A99A40,319067624450,383FB3A76681,946A77264543,70037E9EBFCB,905851478CDB,5C76959521E2,10C25A3D1EBB,54A65C113B6E,B42A0ED4106A,5C7695977CAD', '','DEFAULT',051,046,'', '','', 00);
Date: 2026-08-04 14:50:24 Duration: 1s45ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '70037E9F6C63,905851A93CC0,10C25A167A45,80D04ABAD42A,383FB3A71433,B42A0E19CB08,1062D012A47D,54A65C115A69,90585141AADF,5C769595EA88,BC9B6896883B,90585145E006,B42A0ED3036F,70037E9F83F5,905851A8BC82,54A65C103A51,905851A8E173,80D04A94B1D0,383FB3A878E6,10C25A3BA054,14B7F8E05F2D,80D04AB7C6AE,D4B92F280B82,54A65C8C1525,14B7F8DE2AA3,54A65C902B0B,D4B92F2EEE94,383FB3A1F025,10C25A3A73F5,10C25A14CDE7,5C769595BD01,383FB3A4F8C3,946A7726FE61,D4B92F27AD80,54A65C1179A3,A456CCE694D6,10C25A3B5E7C,54A65C1240C8,70037E9BBA36,54A65C8B12A3,5C769592FAE8,1062D012AC3A,1062D01278AF,80D04A931356,9058514594F0,905851AB3BD5', '','DEFAULT',051,046,'', '','', 00);
Date: 2026-08-04 09:20:25 Duration: 1s28ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 98 53s154ms 346ms 953ms 542ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 04 01 2 1s82ms 541ms 04 1 523ms 523ms 05 2 1s60ms 530ms 07 8 4s174ms 521ms 08 10 4s918ms 491ms 09 11 6s555ms 595ms 10 11 5s791ms 526ms 11 8 4s73ms 509ms 12 3 1s672ms 557ms 13 9 4s713ms 523ms 14 10 5s371ms 537ms 15 8 4s379ms 547ms 16 8 4s169ms 521ms 17 5 3s247ms 649ms 22 1 468ms 468ms 23 1 953ms 953ms [ User: intelifix - Total duration: 53s154ms - Times executed: 98 ]
[ Application: [unknown] - Total duration: 53s154ms - Times executed: 98 ]
-
select * from rs_menu_grants (477, 0, 1);
Date: 2026-08-04 23:41:38 Duration: 953ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (418, 81, 1);
Date: 2026-08-04 09:35:25 Duration: 834ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (474, 19, 1);
Date: 2026-08-04 15:58:19 Duration: 799ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 90 38s65ms 224ms 667ms 422ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 04 07 2 857ms 428ms 08 9 3s830ms 425ms 09 16 7s176ms 448ms 10 8 2s986ms 373ms 11 11 4s418ms 401ms 12 5 1s822ms 364ms 13 9 3s656ms 406ms 14 11 4s871ms 442ms 15 12 5s706ms 475ms 16 5 1s988ms 397ms 17 1 380ms 380ms 18 1 370ms 370ms [ User: intelifix - Total duration: 38s65ms - Times executed: 90 ]
[ Application: [unknown] - Total duration: 38s65ms - Times executed: 90 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-08-04 11:35:49 Duration: 667ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-08-04 08:35:23 Duration: 663ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-04 14:54:40 Duration: 646ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 84 1m6s 150ms 2s678ms 791ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 04 08 6 2s247ms 374ms 11 13 11s877ms 913ms 12 10 4s376ms 437ms 13 17 17s399ms 1s23ms 15 8 6s814ms 851ms 16 25 21s416ms 856ms 17 5 2s338ms 467ms [ User: intelifix - Total duration: 1m6s - Times executed: 84 ]
[ Application: [unknown] - Total duration: 1m6s - Times executed: 84 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0273728) LIMIT 1;
Date: 2026-08-04 15:23:06 Duration: 2s678ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0131150) LIMIT 1;
Date: 2026-08-04 11:53:37 Duration: 2s238ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0273725) LIMIT 1;
Date: 2026-08-04 16:25:31 Duration: 2s223ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 80 4m31s 1s328ms 10s930ms 3s391ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 04 08 6 24s435ms 4s72ms 09 6 24s322ms 4s53ms 10 3 17s493ms 5s831ms 11 5 20s554ms 4s110ms 13 5 14s971ms 2s994ms 14 8 25s863ms 3s232ms 15 5 32s629ms 6s525ms 16 9 36s64ms 4s7ms 17 33 1m15s 2s273ms [ User: intelifix - Total duration: 4m31s - Times executed: 80 ]
[ Application: [unknown] - Total duration: 4m31s - Times executed: 80 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-04', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-04 08:25:18 Duration: 10s930ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-04', 0302, '', '', 0, 6, '2026-08-04');
Date: 2026-08-04 14:18:38 Duration: 8s994ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-04', 0395, '', '', 0, 6, '2026-08-01');
Date: 2026-08-04 15:10:21 Duration: 7s976ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 77 2m49s 208ms 51s397ms 2s205ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 04 07 4 3s619ms 904ms 08 6 3s921ms 653ms 09 29 7s600ms 262ms 10 4 11s899ms 2s974ms 11 4 48s281ms 12s70ms 12 4 1s755ms 438ms 13 2 2s935ms 1s467ms 14 8 20s275ms 2s534ms 15 11 1m 5s529ms 16 5 8s681ms 1s736ms [ User: intelifix - Total duration: 2m49s - Times executed: 77 ]
[ Application: psql - Total duration: 2m49s - Times executed: 77 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028008);
Date: 2026-08-04 15:09:15 Duration: 51s397ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027991);
Date: 2026-08-04 11:37:15 Duration: 36s402ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028001);
Date: 2026-08-04 14:45:04 Duration: 10s244ms Database: rio User: intelifix Remote: [local] Application: psql
14 65 15s984ms 151ms 756ms 245ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 04 01 1 257ms 257ms 05 1 299ms 299ms 08 1 298ms 298ms 09 1 235ms 235ms 10 3 1s43ms 347ms 11 4 1s361ms 340ms 12 2 850ms 425ms 13 5 860ms 172ms 14 6 1s94ms 182ms 15 21 5s539ms 263ms 16 7 1s247ms 178ms 17 13 2s897ms 222ms [ User: intelifix - Total duration: 15s984ms - Times executed: 65 ]
[ Application: [unknown] - Total duration: 15s984ms - Times executed: 65 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "434", "data-de" : "2026-08-04", "data-ate" : "2026-08-04", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 508 }');
Date: 2026-08-04 15:56:38 Duration: 756ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "328", "data-de" : "2026-08-04", "data-ate" : "2026-08-04", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 401 }');
Date: 2026-08-04 12:27:01 Duration: 626ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "398", "data-de" : "2026-08-04", "data-ate" : "2026-08-04", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 452 }');
Date: 2026-08-04 15:13:23 Duration: 537ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 59 11s648ms 151ms 1s52ms 197ms create table temp0000237454 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 04 12 3 1s390ms 463ms 13 20 3s386ms 169ms 14 17 3s90ms 181ms 15 19 3s780ms 198ms [ User: intelifix - Total duration: 11s648ms - Times executed: 59 ]
[ Application: [unknown] - Total duration: 11s648ms - Times executed: 59 ]
-
CREATE TABLE temp0000237454 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"30-07-2026", "ate" :"04-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-04 12:49:51 Duration: 1s52ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000237454 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"30-07-2026", "ate" :"04-08-2026", "nota-fiscal":"11160", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-04 15:14:52 Duration: 296ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000237454 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"30-07-2026", "ate" :"04-08-2026", "nota-fiscal":"11160", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-04 15:07:51 Duration: 284ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
16 58 20s322ms 155ms 1s991ms 350ms select * from rs_lote_saida_manutencao (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 04 07 1 180ms 180ms 08 9 2s229ms 247ms 09 10 2s972ms 297ms 10 3 664ms 221ms 11 11 7s579ms 689ms 13 7 2s100ms 300ms 14 4 802ms 200ms 15 6 2s39ms 339ms 16 1 261ms 261ms 17 6 1s492ms 248ms [ User: intelifix - Total duration: 20s322ms - Times executed: 58 ]
[ Application: [unknown] - Total duration: 20s322ms - Times executed: 58 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "273449", "oficina" : "6", "cliente" : "5", "usuario" : "405", "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-04 11:37:54 Duration: 1s991ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "273449", "oficina" : "6", "cliente" : "5", "usuario" : "405", "nf" : "", "data-saida" : "2026-08-04", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "S", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-04 11:42:03 Duration: 1s409ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "273449", "oficina" : "6", "cliente" : "5", "usuario" : "405", "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-04 11:49:22 Duration: 845ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 56 15s857ms 150ms 3s236ms 283ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 04 01 3 508ms 169ms 05 4 925ms 231ms 07 7 2s550ms 364ms 08 1 338ms 338ms 09 3 501ms 167ms 10 4 661ms 165ms 11 4 853ms 213ms 12 5 1s172ms 234ms 13 2 322ms 161ms 14 4 692ms 173ms 15 6 991ms 165ms 16 3 505ms 168ms 17 2 317ms 158ms 21 3 962ms 320ms 22 1 166ms 166ms 23 4 4s386ms 1s96ms [ User: intelifix - Total duration: 15s857ms - Times executed: 56 ]
[ Application: [unknown] - Total duration: 15s857ms - Times executed: 56 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('230034574754');
Date: 2026-08-04 23:28:04 Duration: 3s236ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('246277779617');
Date: 2026-08-04 07:09:20 Duration: 1s290ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229973296989');
Date: 2026-08-04 23:41:36 Duration: 737ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 53 12s510ms 153ms 1s874ms 236ms create table temp0000287396 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 04 08 1 1s874ms 1s874ms 09 1 243ms 243ms 10 4 733ms 183ms 11 9 1s677ms 186ms 13 7 1s401ms 200ms 14 10 2s60ms 206ms 15 9 1s827ms 203ms 16 6 1s247ms 207ms 17 6 1s443ms 240ms [ User: intelifix - Total duration: 12s510ms - Times executed: 53 ]
[ Application: [unknown] - Total duration: 12s510ms - Times executed: 53 ]
-
CREATE TABLE temp0000287396 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"30-07-2026", "ate" :"04-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-04 08:08:22 Duration: 1s874ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287396 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"30-07-2026", "ate" :"04-08-2026", "nota-fiscal":"1579", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-04 17:04:21 Duration: 289ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287396 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"30-07-2026", "ate" :"04-08-2026", "nota-fiscal":"1579", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-04 13:54:21 Duration: 267ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 53 10s627ms 150ms 1s973ms 200ms create table temp0000287394 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 04 08 6 2s948ms 491ms 09 1 185ms 185ms 10 1 205ms 205ms 13 2 320ms 160ms 14 9 1s449ms 161ms 15 17 2s751ms 161ms 16 11 1s809ms 164ms 17 6 956ms 159ms [ User: intelifix - Total duration: 10s627ms - Times executed: 53 ]
[ Application: [unknown] - Total duration: 10s627ms - Times executed: 53 ]
-
CREATE TABLE temp0000287394 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"30-07-2026", "ate" :"04-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-04 08:06:38 Duration: 1s973ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287394 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"30-07-2026", "ate" :"04-08-2026", "nota-fiscal":"70562", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-04 08:17:29 Duration: 229ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287394 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"30-07-2026", "ate" :"04-08-2026", "nota-fiscal":"70562", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-04 10:45:10 Duration: 205ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 48 2h3m35s 1s418ms 11m20s 2m34s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 04 07 3 12m4s 4m1s 08 3 6m5s 2m1s 09 3 12m15s 4m5s 10 3 8m49s 2m56s 11 3 7m22s 2m27s 12 3 7m48s 2m36s 13 3 5m55s 1m58s 14 3 6m54s 2m18s 15 3 9m 3m 16 3 8m41s 2m53s 17 3 7m26s 2m28s 18 3 5m56s 1m58s 19 3 5m53s 1m57s 20 3 6m20s 2m6s 21 3 7m17s 2m25s 22 3 5m41s 1m53s [ User: intelifix - Total duration: 2h3m35s - Times executed: 48 ]
[ Application: psql - Total duration: 2h3m35s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-04 09:16:22 Duration: 11m20s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-04 07:16:20 Duration: 11m19s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-04 15:13:27 Duration: 8m25s Database: rio User: intelifix Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m45s 10m3s 5m52s 3 17m36s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 04 05 3 17m36s 5m52s [ User: intelifix - Total duration: 17m36s - Times executed: 3 ]
[ Application: psql - Total duration: 17m36s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-04 05:10:05 Duration: 10m3s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-04 05:14:52 Duration: 4m47s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-04 05:17:38 Duration: 2m45s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s418ms 11m20s 2m34s 48 2h3m35s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 04 07 3 12m4s 4m1s 08 3 6m5s 2m1s 09 3 12m15s 4m5s 10 3 8m49s 2m56s 11 3 7m22s 2m27s 12 3 7m48s 2m36s 13 3 5m55s 1m58s 14 3 6m54s 2m18s 15 3 9m 3m 16 3 8m41s 2m53s 17 3 7m26s 2m28s 18 3 5m56s 1m58s 19 3 5m53s 1m57s 20 3 6m20s 2m6s 21 3 7m17s 2m25s 22 3 5m41s 1m53s [ User: intelifix - Total duration: 2h3m35s - Times executed: 48 ]
[ Application: psql - Total duration: 2h3m35s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-04 09:16:22 Duration: 11m20s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-04 07:16:20 Duration: 11m19s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-04 15:13:27 Duration: 8m25s Database: rio User: intelifix Remote: [local] Application: psql
3 226ms 4m54s 1m34s 48 1h15m54s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 04 07 3 5m42s 1m54s 08 3 4m27s 1m29s 09 3 6m36s 2m12s 10 3 4m44s 1m34s 11 3 5m22s 1m47s 12 3 5m7s 1m42s 13 3 4m4s 1m21s 14 3 5m10s 1m43s 15 3 5m10s 1m43s 16 3 4m39s 1m33s 17 3 4m45s 1m35s 18 3 3m45s 1m15s 19 3 3m55s 1m18s 20 3 4m31s 1m30s 21 3 3m50s 1m16s 22 3 3m59s 1m19s [ User: intelifix - Total duration: 1h15m54s - Times executed: 48 ]
[ Application: psql - Total duration: 1h15m54s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-04 09:23:36 Duration: 4m54s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-04 14:17:01 Duration: 4m21s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-04 15:19:04 Duration: 4m15s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s756ms 1m41s 49s692ms 4 3m18s 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 04 20 2 1m46s 53s101ms 23 2 1m32s 46s282ms [ User: intelifix - Total duration: 3m18s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m18s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-04 20:09:25 Duration: 1m41s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-04 23:16:37 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-04 20:11:20 Duration: 5s185ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 421ms 1m4s 30s698ms 4 2m2s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 04 20 2 1m5s 32s636ms 23 2 57s519ms 28s759ms [ User: intelifix - Total duration: 2m2s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m2s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-04 20:05:48 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-04 23:13:25 Duration: 57s97ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-04 20:10:45 Duration: 426ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 151ms 6m46s 19s398ms 284 1h31m49s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 04 07 5 7m3s 1m24s 08 23 20m44s 54s115ms 09 19 12m30s 39s506ms 10 18 6m48s 22s712ms 11 40 4m7s 6s179ms 12 24 10m58s 27s447ms 13 36 1m3s 1s775ms 14 26 1m22s 3s155ms 15 36 23m33s 39s274ms 16 44 3m24s 4s636ms 17 12 9s964ms 830ms 18 1 1s796ms 1s796ms [ User: intelifix - Total duration: 1h31m49s - Times executed: 284 ]
[ Application: [unknown] - Total duration: 1h31m49s - Times executed: 284 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027947, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-04 07:19:59 Duration: 6m46s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027984, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-04 09:57:57 Duration: 6m36s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028006, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-04 15:03:48 Duration: 6m7s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 9s922ms 1m 12s738ms 39 8m16s create table temp0000287372 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 04 07 11 2m48s 15s345ms 08 16 3m4s 11s512ms 09 6 1m20s 13s457ms 10 6 1m3s 10s513ms [ User: intelifix - Total duration: 8m16s - Times executed: 39 ]
[ Application: [unknown] - Total duration: 8m16s - Times executed: 39 ]
-
CREATE TABLE temp0000287372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 07:09:03 Duration: 1m Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 09:00:51 Duration: 16s783ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 09:00:27 Duration: 16s270ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 9s788ms 13s121ms 11s575ms 36 6m56s create table temp0000287398 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 04 09 36 6m56s 11s575ms [ User: intelifix - Total duration: 6m56s - Times executed: 36 ]
[ Application: [unknown] - Total duration: 6m56s - Times executed: 36 ]
-
CREATE TABLE temp0000287398 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 09:35:03 Duration: 13s121ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287398 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 09:26:34 Duration: 12s984ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287398 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 09:35:24 Duration: 12s823ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s16ms 13s484ms 11s456ms 16 3m3s create table temp0000287482 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 04 14 3 36s805ms 12s268ms 15 10 1m54s 11s409ms 16 3 32s406ms 10s802ms [ User: intelifix - Total duration: 3m3s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 3m3s - Times executed: 16 ]
-
CREATE TABLE temp0000287482 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 15:08:37 Duration: 13s484ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287482 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 14:56:57 Duration: 12s765ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287482 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 15:14:24 Duration: 12s123ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s514ms 12s249ms 11s388ms 13 2m28s create table temp0000287436 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 04 10 3 33s754ms 11s251ms 11 9 1m42s 11s401ms 12 1 11s681ms 11s681ms [ User: intelifix - Total duration: 2m28s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m28s - Times executed: 13 ]
-
CREATE TABLE temp0000287436 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 10:58:03 Duration: 12s249ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287436 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 11:39:16 Duration: 12s84ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287436 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 11:37:18 Duration: 11s764ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 9s554ms 13s891ms 11s261ms 45 8m26s create table temp0000287450 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 04 12 12 2m6s 10s548ms 14 13 2m26s 11s263ms 15 17 3m16s 11s581ms 16 3 36s882ms 12s294ms [ User: intelifix - Total duration: 8m26s - Times executed: 45 ]
[ Application: [unknown] - Total duration: 8m26s - Times executed: 45 ]
-
CREATE TABLE temp0000287450 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 15:51:34 Duration: 13s891ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287450 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 15:51:08 Duration: 13s813ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287450 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 16:02:29 Duration: 12s839ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 9s239ms 12s753ms 11s239ms 11 2m3s create table temp0000287484 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 04 16 11 2m3s 11s239ms [ User: intelifix - Total duration: 2m3s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 2m3s - Times executed: 11 ]
-
CREATE TABLE temp0000287484 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 16:11:42 Duration: 12s753ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287484 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 16:15:15 Duration: 12s439ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287484 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-04 16:12:28 Duration: 11s900ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 153ms 20s990ms 4s527ms 168 12m40s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 04 00 6 32s362ms 5s393ms 01 6 15s640ms 2s606ms 02 6 12s901ms 2s150ms 03 5 14s984ms 2s996ms 04 6 13s486ms 2s247ms 05 6 23s942ms 3s990ms 07 9 43s136ms 4s792ms 08 12 1m16s 6s376ms 09 12 1m24s 7s62ms 10 12 1m11s 5s991ms 11 12 1m22s 6s863ms 12 12 1m9s 5s796ms 13 10 15s298ms 1s529ms 14 12 49s549ms 4s129ms 15 12 1m7s 5s613ms 16 11 41s142ms 3s740ms 17 6 12s36ms 2s6ms 18 1 1s454ms 1s454ms 20 1 153ms 153ms 21 6 15s922ms 2s653ms 22 5 16s232ms 3s246ms [ User: intelifix - Total duration: 12m40s - Times executed: 168 ]
[ Application: psql - Total duration: 12m40s - Times executed: 168 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-04 00:05:22 Duration: 20s990ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-04 12:15:19 Duration: 18s37ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-04 09:55:16 Duration: 15s529ms Database: rio User: intelifix Remote: [local] Application: psql
14 284ms 29s908ms 4s307ms 39 2m48s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 04 07 3 33s737ms 11s245ms 08 5 13s147ms 2s629ms 09 9 36s62ms 4s6ms 10 3 2s832ms 944ms 11 4 12s312ms 3s78ms 12 2 27s703ms 13s851ms 13 1 2s407ms 2s407ms 14 6 23s967ms 3s994ms 15 5 13s894ms 2s778ms 16 1 1s944ms 1s944ms [ User: intelifix - Total duration: 2m48s - Times executed: 39 ]
[ Application: psql - Total duration: 2m48s - Times executed: 39 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027947);
Date: 2026-08-04 07:12:45 Duration: 29s908ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027994);
Date: 2026-08-04 12:05:07 Duration: 25s692ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028006);
Date: 2026-08-04 14:57:26 Duration: 13s703ms Database: rio User: intelifix Remote: [local] Application: psql
15 775ms 12s2ms 3s584ms 29 1m43s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 04 08 2 14s164ms 7s82ms 10 3 15s449ms 5s149ms 11 2 8s319ms 4s159ms 12 2 2s854ms 1s427ms 13 2 2s542ms 1s271ms 14 2 16s80ms 8s40ms 15 1 5s928ms 5s928ms 16 3 9s952ms 3s317ms 17 2 4s530ms 2s265ms 18 1 1s112ms 1s112ms 19 2 1s786ms 893ms 20 1 775ms 775ms 21 3 10s598ms 3s532ms 22 3 9s864ms 3s288ms [ User: intelifix - Total duration: 1m43s - Times executed: 29 ]
[ Application: psql - Total duration: 1m43s - Times executed: 29 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-04 14:00:13 Duration: 12s2ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-04 08:20:11 Duration: 10s44ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-04 10:20:08 Duration: 7s754ms Database: rio User: intelifix Remote: [local] Application: psql
16 166ms 2m41s 3s407ms 277 15m43s call rs_giga_triagem (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 04 00 12 40s548ms 3s379ms 01 12 23s139ms 1s928ms 02 12 24s553ms 2s46ms 03 13 21s990ms 1s691ms 04 12 22s363ms 1s863ms 05 12 26s727ms 2s227ms 06 12 22s630ms 1s885ms 07 12 23s895ms 1s991ms 08 12 28s182ms 2s348ms 09 12 4m36s 23s22ms 10 12 23s637ms 1s969ms 11 12 22s996ms 1s916ms 12 12 20s900ms 1s741ms 13 12 24s984ms 2s82ms 14 12 24s628ms 2s52ms 15 12 2m7s 10s633ms 16 12 25s461ms 2s121ms 17 12 26s455ms 2s204ms 18 12 24s612ms 2s51ms 19 12 23s654ms 1s971ms 20 12 41s358ms 3s446ms 21 12 24s316ms 2s26ms 22 12 23s42ms 1s920ms [ User: intelifix - Total duration: 15m43s - Times executed: 277 ]
[ Application: psql - Total duration: 15m43s - Times executed: 277 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-04 09:57:58 Duration: 2m41s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-04 15:56:56 Duration: 1m45s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-04 09:06:49 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: psql
17 1s328ms 10s930ms 3s391ms 80 4m31s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 04 08 6 24s435ms 4s72ms 09 6 24s322ms 4s53ms 10 3 17s493ms 5s831ms 11 5 20s554ms 4s110ms 13 5 14s971ms 2s994ms 14 8 25s863ms 3s232ms 15 5 32s629ms 6s525ms 16 9 36s64ms 4s7ms 17 33 1m15s 2s273ms [ User: intelifix - Total duration: 4m31s - Times executed: 80 ]
[ Application: [unknown] - Total duration: 4m31s - Times executed: 80 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-04', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-04 08:25:18 Duration: 10s930ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-04', 0302, '', '', 0, 6, '2026-08-04');
Date: 2026-08-04 14:18:38 Duration: 8s994ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-04', 0395, '', '', 0, 6, '2026-08-01');
Date: 2026-08-04 15:10:21 Duration: 7s976ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 208ms 51s397ms 2s205ms 77 2m49s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 04 07 4 3s619ms 904ms 08 6 3s921ms 653ms 09 29 7s600ms 262ms 10 4 11s899ms 2s974ms 11 4 48s281ms 12s70ms 12 4 1s755ms 438ms 13 2 2s935ms 1s467ms 14 8 20s275ms 2s534ms 15 11 1m 5s529ms 16 5 8s681ms 1s736ms [ User: intelifix - Total duration: 2m49s - Times executed: 77 ]
[ Application: psql - Total duration: 2m49s - Times executed: 77 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028008);
Date: 2026-08-04 15:09:15 Duration: 51s397ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027991);
Date: 2026-08-04 11:37:15 Duration: 36s402ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028001);
Date: 2026-08-04 14:45:04 Duration: 10s244ms Database: rio User: intelifix Remote: [local] Application: psql
19 150ms 6s757ms 970ms 1,689 27m19s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 04 07 16 14s402ms 900ms 08 83 1m34s 1s138ms 09 170 3m5s 1s90ms 10 197 3m12s 977ms 11 201 3m19s 992ms 12 59 58s768ms 996ms 13 138 2m28s 1s79ms 14 252 3m15s 775ms 15 246 4m1s 981ms 16 234 3m42s 952ms 17 93 1m26s 926ms [ User: intelifix - Total duration: 27m19s - Times executed: 1689 ]
[ Application: [unknown] - Total duration: 27m19s - Times executed: 1689 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (50065, 417, '246343077089', '',0172,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":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-04 13:59:46 Duration: 6s757ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (273483, 304, 'CP2327322MB,D4925ED50170,544D4242006DA91D,D4925ED50173$CP2411326UA,08C7F53086F1,544D424200789596,08C7F53086F4$CP240932CBG,08C7F52D174C,544D4242007833D9,08C7F52D174F$CP234232WQ5,D4925EFA105B,544D424200726400,D4925EFA105E$CP23453222L,08C7F5022260,544D424200733AD5,08C7F5022263$CP2303321CQ,D4925E13CA12,544D42420062B913,D4925E13CA15$CP2409328K9,08C7F52C8731,544D4242007823D6,08C7F52C8734$CP240932BG7,08C7F52CF67F,544D424200783034,08C7F52CF682$CP2301323AG,D4925E01E21B,544D424200611E02,D4925E01E21E$CP23173247C,D4925E95000F,544D424200682AB9,D4925E950012$CP2310327R3,D4925E349609,544D42420065D0DB,D4925E34960C$CP230132337,D4925E01D9AB,544D424200611D12,D4925E01D9AE$CP2411322GG,08C7F52FE017,544D42420078830C,08C7F52FE01A$CP232532KEF,D4925ECE7AA7,544D4242006D6605,D4925ECE7AAA$CP240932R9D,08C7F52F0694,544D424200786AE1,08C7F52F0697$CP234232QNS,D4925EF92910,544D424200724A4D,D4925EF92913$CP2301326K0,D4925E025EE0,544D424200612BDF,D4925E025EE3$CP230232RSN,D4925E09FCDA,544D4242006203CF,D4925E09FCDD$CP230232RUJ,D4925E09FF08,544D42420062040D,D4925E09FF0B$CP230232MZG,D4925E096A76,544D42420061F38B,D4925E096A79$CP2301322FF,D4925E01C18D,544D424200611A64,D4925E01C190$CP2325324RV,D4925ECB5F41,544D4242006D27AF,D4925ECB5F44$CP240932KNF,08C7F52E3005,544D42420078530A,08C7F52E3008$CP240932P70,08C7F52EB73B,544D424200786210,08C7F52EB73E$CP234532EY1,08C7F5040EC6,544D42420073718B,08C7F5040EC9$CP24093253J,08C7F52C0217,544D42420078150C,08C7F52C021A$CP2322322EU,D4925EB3335A,544D4242006B962A,D4925EB3335D$CP230232N50,D4925E0970DC,544D42420061F441,D4925E0970DF$CP23223204H,D4925EB2DACB,544D4242006B8C53,D4925EB2DACE$CP23173219C,D4925E948F86,544D424200681E38,D4925E948F89$CP232532P3Q,D4925ECF0759,544D4242006D75A7,D4925ECF075C$CP2322322JL,D4925EB337B6,544D4242006B96A6,D4925EB337B9$CP2327321KQ,D4925ED4D938,544D4242006DA4A5,D4925ED4D93B', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-04 09:07:04 Duration: 6s269ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (273477, 304, '922111017732,64FD965E1666,E8D2FF96B8D7,186A81D52691,C4EB42EADAAD,186A81D3E532,3453D2A83FD4,ACD75BB7E9E6,94988F93E6AD,94988F3066A9,3453D2A8D718,ACD75BB5F703,B0BBE53D2855,44D454C3BF57,D0CF0EFE2D46,D0CF0EFDA9AB,94988F959335,943C9678BADD,ACD75BB5F85A,5CFA259B925A,345D9EB44B5F,ACD75BB5F527,8CFDDE9813BD,D06DC964B51E,B0BBE53DADA9,8CC5B4EDD097,4C195DCC71FA,C03C04864FDF,44D45493948A,4829524633E4,841EA3986D8B,5447CC4945F9,582FF79C9644,8CC5B4EDA60B,345D9EBD7C40,5CFA25159BE2', '',0155,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-04 13:50:09 Duration: 5s982ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 150ms 2s678ms 791ms 84 1m6s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 04 08 6 2s247ms 374ms 11 13 11s877ms 913ms 12 10 4s376ms 437ms 13 17 17s399ms 1s23ms 15 8 6s814ms 851ms 16 25 21s416ms 856ms 17 5 2s338ms 467ms [ User: intelifix - Total duration: 1m6s - Times executed: 84 ]
[ Application: [unknown] - Total duration: 1m6s - Times executed: 84 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0273728) LIMIT 1;
Date: 2026-08-04 15:23:06 Duration: 2s678ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0131150) LIMIT 1;
Date: 2026-08-04 11:53:37 Duration: 2s238ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0273725) LIMIT 1;
Date: 2026-08-04 16:25:31 Duration: 2s223ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 7 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 04 14 1 0ms 0ms 19 2 0ms 0ms 20 2 0ms 0ms 21 2 0ms 0ms [ User: intelifix - Total duration: 5m40s - Times executed: 6 ]
[ User: lenon - Total duration: 555ms - Times executed: 1 ]
[ Application: psql - Total duration: 5m40s - Times executed: 6 ]
[ Application: [unknown] - Total duration: 555ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 18,302 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 17 FATAL entries
- 4141 ERROR entries
- 0 WARNING entries
- 9 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,003 Max number of times the same event was reported
- 4,167 Total events found
Rank Times reported Error 1 4,003 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 04 00 58 01 57 02 51 03 52 04 57 05 54 06 55 07 162 08 382 09 529 10 432 11 378 12 157 13 183 14 352 15 371 16 199 17 128 18 60 19 59 20 60 21 58 22 59 23 50 - ERROR: prepared statement "_PLAN000000003C2A55E0" does not exist
- ERROR: prepared statement "_PLAN000000003C2A5150" does not exist
- ERROR: prepared statement "_PLAN000000003C29B630" does not exist
Statement: DEALLOCATE "_PLAN000000003C2A55E0"
Date: 2026-08-04 00:00:40 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000003C2A5150"
Date: 2026-08-04 00:01:41 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000003C29B630"
Date: 2026-08-04 00:02:42 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
2 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 04 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-04 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-04 00:35:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-04 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
3 37 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 04 08 3 09 3 10 3 11 3 12 3 13 2 14 3 15 3 16 3 17 3 18 3 19 3 20 2 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-08-04 08:00:07 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-08-04 08:20:12 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-08-04 08:40:08 Database: brasilia Application: psql User: intelifix Remote: [local]
4 29 ERROR: out of shared memory
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 04 13 29 - ERROR: out of shared memory at character 61
- ERROR: out of shared memory at character 35 2026-08-04 13:39:16 -03 [1987114]: [36-1] user=intelifix,db=brasilia,app=[unknown],client=[local] QUERY: SELECT PAR_VALOR FROM PARAMETROS WHERE PAR_NOME = cParam
- ERROR: out of shared memory
Hint: You might need to increase "max_locks_per_transaction".
Statement: SELECT pg_encoding_to_char(encoding) FROM pg_database WHERE datname = current_database();Date: 2026-08-04 13:39:16 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL function rs_parametro(character varying) line 20 at SQL statement PL/pgSQL function rs_serial_temporario_vivo(character varying) line 21 during statement block local variable initialization
Hint: You might need to increase "max_locks_per_transaction".
Statement: SELECT RS_SERIAL_TEMPORARIO( '518073077182' ) OR RS_SERIAL_TEMPORARIO_VIVO( '518073077182' )Date: 2026-08-04 13:39:16 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Hint: You might need to increase "max_locks_per_transaction".
Statement: DISCARD ALLDate: 2026-08-04 13:39:16 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
5 8 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 04 03 8 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-08-04 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-08-04 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-04 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
6 8 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 04 09 3 10 3 16 2 - ERROR: trailing junk after numeric literal at or near "88ç0fça2çb6çaaç23" at character 27
- ERROR: trailing junk after numeric literal at or near "88ç0fça2çb6çaaç23" at character 27
- ERROR: trailing junk after numeric literal at or near "88ç0fça2çb6çaaç23" at character 27
Statement: SELECT * FROM RS_ETIQUETA(88ç0fça2çb6çaaç23)
Date: 2026-08-04 09:28:49 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(88ç0fça2çb6çaaç23)
Date: 2026-08-04 09:28:49 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(88ç0fça2çb6çaaç23)
Date: 2026-08-04 09:28:49 Database: rio Application: [unknown] User: etiquetas Remote: [local]
7 8 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 04 09 5 15 3 - LOG: process 1771325 still waiting for ShareLock on transaction 3801923 after 1000.056 ms
- LOG: process 1771325 still waiting for ShareLock on transaction 3801923 after 37682.276 ms
- LOG: process 1771325 still waiting for ShareLock on transaction 3807272 after 1000.180 ms
Detail: Process holding the lock: 1767598. Wait queue: 1771325.
Context: while updating tuple (75751,46) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-08-04 09:05:18 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1767598. Wait queue: 1771325.
Context: while updating tuple (75751,46) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-08-04 09:05:54 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1805455. Wait queue: 1771325.
Context: while updating tuple (75751,95) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-08-04 09:55:21 Database: rio Application: psql User: intelifix Remote: [local]
8 6 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 04 05 4 13 2 - 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-04 05:32:14 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-04 05:32:14 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-04 05:32:14 Database: contagem Application: psql User: intelifix Remote: [local]
9 6 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Aug 04 00 1 06 1 11 1 14 1 20 1 21 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-08-04 00:02:11 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-04 06:02:08 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-04 11:01:30 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
10 5 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #10
Day Hour Count Aug 04 09 1 11 2 14 2 - ERROR: syntax error at or near "229985165465" at character 41
- ERROR: syntax error at or near "]" at character 34
- ERROR: syntax error at or near "]" at character 34
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''229985165465');
Date: 2026-08-04 09:39:08 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: select * from rs_caixa_qr(386652 ][)
Date: 2026-08-04 11:45:23 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(386652 ][)
Date: 2026-08-04 11:45:23 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
11 4 ERROR: spiexceptions.OutOfMemory: out of shared memory
Times Reported Most Frequent Error / Event #11
Day Hour Count Aug 04 13 4 - ERROR: spiexceptions.OutOfMemory: out of shared memory
- ERROR: spiexceptions.OutOfMemory: out of shared memory
- ERROR: spiexceptions.OutOfMemory: out of shared memory
Context: Traceback (most recent call last): PL/Python function "rs_fast_excel", line 135, in <module> rows = dados.fetch(1000) PL/Python function "rs_fast_excel"
Hint: You might need to increase "max_locks_per_transaction".
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_lotes_cria(2,409,''/var/www/html/uploads/03-08 - Query 29.xlsx'') ;' , '/var/www/html/tmp/temp_29.xlsx' )Date: 2026-08-04 13:39:17 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_fast_excel", line 135, in <module> rows = dados.fetch(1000) PL/Python function "rs_fast_excel"
Hint: You might need to increase "max_locks_per_transaction".
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_lotes_cria(2,409,''/var/www/html/uploads/03-08 - Query 29.xlsx'') ;' , '/var/www/html/tmp/temp_29.xlsx' )Date: 2026-08-04 13:40:07 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_fast_excel", line 135, in <module> rows = dados.fetch(1000) PL/Python function "rs_fast_excel"
Hint: You might need to increase "max_locks_per_transaction".
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_lotes_cria(2,409,''/var/www/html/uploads/03-08 - Query 29 - Copia.xlsx'') ;' , '/var/www/html/tmp/temp_29.xlsx' )Date: 2026-08-04 13:41:21 Database: contagem Application: [unknown] User: intelifix Remote: [local]
12 3 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #12
Day Hour Count Aug 04 12 3 - ERROR: unterminated quoted string at or near "''');" at character 39
- ERROR: unterminated quoted string at or near "''');" at character 39
- ERROR: unterminated quoted string at or near "''');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-08-04 12:02:59 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-08-04 12:03:07 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-08-04 12:08:17 Database: rio Application: [unknown] User: intelifix Remote: [local]
13 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #13
Day Hour Count Aug 04 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-04 03:05:02 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-04 03:05:02 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-04 03:05:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
14 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #14
Day Hour Count Aug 04 03 1 - LOG: database system was shut down at 2026-08-04 03:05:02 -03
Date: 2026-08-04 03:05:03